Query Metrics
2
Database Queries
2
Different statements
3.24 ms
Query time
0
Invalid entities
Queries
#▲ | Time | Info |
---|---|---|
1 | 1.43 ms |
SELECT i0_.id_ind AS id_ind_0, i0_.title AS title_1, i0_.fname AS fname_2, i0_.mname AS mname_3, i0_.sname AS sname_4, i0_.identifier AS identifier_5, i0_.reg_type AS reg_type_6, i0_.use_inst_addr AS use_inst_addr_7, i0_.private_address AS private_address_8, i0_.addr_1 AS addr_1_9, i0_.addr_2 AS addr_2_10, i0_.city AS city_11, i0_.state AS state_12, i0_.postcode AS postcode_13, i0_.country_code AS country_code_14, i0_.id_nationality AS id_nationality_15, i0_.gender AS gender_16, i0_.tel AS tel_17, i0_.fax AS fax_18, i0_.email1 AS email1_19, i0_.email2 AS email2_20, i0_.email3 AS email3_21, i0_.emailtouse AS emailtouse_22, i0_.url1 AS url1_23, i0_.url1Valid AS url1Valid_24, i0_.url2 AS url2_25, i0_.url2Valid AS url2Valid_26, i0_.url3 AS url3_27, i0_.url3Valid AS url3Valid_28, i0_.urlsChecked AS urlsChecked_29, i0_.linkedin AS linkedin_30, i0_.facebook AS facebook_31, i0_.twitter AS twitter_32, i0_.flickr AS flickr_33, i0_.other AS other_34, i0_.degree AS degree_35, i0_.activeng AS activeng_36, i0_.activother AS activother_37, i0_.jobtitle AS jobtitle_38, i0_.dept AS dept_39, i0_.studyregion AS studyregion_40, i0_.languages AS languages_41, i0_.skills AS skills_42, i0_.comments AS comments_43, i0_.do_not_invite AS do_not_invite_44, i0_.do_no_invite_by AS do_no_invite_by_45, i0_.do_no_invite_on AS do_no_invite_on_46, i0_.admin_comments AS admin_comments_47, i0_.id_imagefile AS id_imagefile_48, i0_.id_imagefile_full AS id_imagefile_full_49, i0_.receive_mail AS receive_mail_50, i0_.member_alert AS member_alert_51, i0_.cit_alert AS cit_alert_52, i0_.f_date_ent AS f_date_ent_53, i0_.l_date_upd AS l_date_upd_54, i0_.created_by AS created_by_55, i0_.last_edit_by AS last_edit_by_56, i0_.quality_checked_by AS quality_checked_by_57, i0_.quality_checked_date AS quality_checked_date_58, i0_.quality_checked AS quality_checked_59, i0_.is_global AS is_global_60, i0_.status AS status_61, i0_.statusLastChanged AS statusLastChanged_62, i0_.deceased AS deceased_63, i0_.deceased_date AS deceased_date_64, i0_.retired AS retired_65, i0_.retired_date AS retired_date_66, i0_.id AS id_67, p1_.id AS id_68, p1_.id_ind AS id_ind_69, p1_.name AS name_70, p1_.path AS path_71, i2_.parent_id AS parent_id_72, i2_.inst_type_id AS inst_type_id_73, i2_.inst_name AS inst_name_74, i2_.inst_name_eng AS inst_name_eng_75, i2_.inst_address AS inst_address_76, i2_.addr_2 AS addr_2_77, i2_.city AS city_78, i2_.state AS state_79, i2_.postcode AS postcode_80, i2_.country_code AS country_code_81, i2_.acronym AS acronym_82, i2_.inst_tel AS inst_tel_83, i2_.inst_fax AS inst_fax_84, i2_.inst_email AS inst_email_85, i2_.inst_url AS inst_url_86, i2_.inst_logo AS inst_logo_87, i2_.edmo_code AS edmo_code_88, i2_.activities AS activities_89, i2_.inst_region AS inst_region_90, i2_.popularity AS popularity_91, i2_.activated AS activated_92, i2_.f_date_entered AS f_date_entered_93, i2_.l_date_updated AS l_date_updated_94, i2_.created_by AS created_by_95, i2_.last_edit_by AS last_edit_by_96, i2_.id_inst AS id_inst_97 FROM indiv i0_ LEFT JOIN profile_images p1_ ON (p1_.id_ind = i0_.id_ind) LEFT JOIN indiv_institution i3_ ON (i0_.id_ind = i3_.id_ind) LEFT JOIN institutions i2_ ON (i3_.id_inst = i2_.id_inst) WHERE i0_.id_ind = ? AND i0_.status = 1
Parameters:
[
"14188"
]
|
2 | 1.81 ms |
SELECT t0.username AS username_1, t0.username_canonical AS username_canonical_2, t0.email AS email_3, t0.email_canonical AS email_canonical_4, t0.enabled AS enabled_5, t0.salt AS salt_6, t0.password AS password_7, t0.last_login AS last_login_8, t0.confirmation_token AS confirmation_token_9, t0.password_requested_at AS password_requested_at_10, t0.roles AS roles_11, t0.id AS id_12 FROM fos_user t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
"14188"
]
|
Database Connections
Name | Service |
---|---|
default | doctrine.dbal.default_connection |
Entity Managers
Name | Service |
---|---|
default | doctrine.orm.default_entity_manager |
Second Level Cache
Second Level Cache is not enabled.
Entities Mapping
Class | Mapping errors |
---|---|
OceanExpertBundle\Entity\Indiv | No errors. |
OceanExpertBundle\Entity\ProfileImages | No errors. |
OceanExpertBundle\Entity\IndivInstitution | No errors. |
OceanExpertBundle\Entity\Institutions | No errors. |
FOS\UserBundle\Model\User | No errors. |
OceanExpertBundle\Entity\User | No errors. |