Query Metrics
28
Database Queries
20
Different statements
81.57 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 7.40 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:
[
"30288"
]
|
| 2 | 25.66 ms |
SELECT i0_.meta_option AS meta_option_0, i0_.meta_value AS meta_value_1 FROM indiv_meta i0_ WHERE i0_.indiv_id = ?
Parameters:
[
30288
]
|
| 3 | 0.67 ms |
SELECT j0_.jobname AS jobname_0, j0_.id_job AS id_job_1 FROM indiv_jobtype i1_ LEFT JOIN jobtypes j0_ ON (j0_.id_job = i1_.id_job) WHERE i1_.id_ind = ?
Parameters:
[
30288
]
|
| 4 | 0.55 ms |
SELECT g0_.groupname AS groupname_0, g0_.id_group AS id_group_1 FROM member_groups m1_ LEFT JOIN groups g0_ ON (m1_.id_group = g0_.id_group) WHERE m1_.id_ind = ? ORDER BY g0_.groupname ASC
Parameters:
[
"30288"
]
|
| 5 | 25.29 ms |
SELECT i0_.meta_option AS meta_option_0, i0_.meta_value AS meta_value_1 FROM indiv_meta i0_ WHERE i0_.indiv_id = ?
Parameters:
[
30288
]
|
| 6 | 0.98 ms |
SELECT c0_.country AS country_0 FROM countries c0_ WHERE c0_.id_country IN (?)
Parameters:
[
[
"230"
]
]
|
| 7 | 0.47 ms |
SELECT j0_.jobname AS jobname_0 FROM jobtypes j0_ WHERE j0_.id_job IN (?)
Parameters:
[
[
"Researcher"
]
]
|
| 8 | 0.74 ms |
SELECT t0.id_ind AS id_ind_1, t0.title AS title_2, t0.fname AS fname_3, t0.mname AS mname_4, t0.sname AS sname_5, t0.identifier AS identifier_6, t0.reg_type AS reg_type_7, t0.use_inst_addr AS use_inst_addr_8, t0.private_address AS private_address_9, t0.addr_1 AS addr_1_10, t0.addr_2 AS addr_2_11, t0.city AS city_12, t0.state AS state_13, t0.postcode AS postcode_14, t0.country_code AS country_code_15, t0.id_nationality AS id_nationality_16, t0.gender AS gender_17, t0.tel AS tel_18, t0.fax AS fax_19, t0.email1 AS email1_20, t0.email2 AS email2_21, t0.email3 AS email3_22, t0.emailtouse AS emailtouse_23, t0.url1 AS url1_24, t0.url1Valid AS url1Valid_25, t0.url2 AS url2_26, t0.url2Valid AS url2Valid_27, t0.url3 AS url3_28, t0.url3Valid AS url3Valid_29, t0.urlsChecked AS urlsChecked_30, t0.linkedin AS linkedin_31, t0.facebook AS facebook_32, t0.twitter AS twitter_33, t0.flickr AS flickr_34, t0.other AS other_35, t0.degree AS degree_36, t0.activeng AS activeng_37, t0.activother AS activother_38, t0.jobtitle AS jobtitle_39, t0.dept AS dept_40, t0.studyregion AS studyregion_41, t0.languages AS languages_42, t0.skills AS skills_43, t0.comments AS comments_44, t0.do_not_invite AS do_not_invite_45, t0.do_no_invite_by AS do_no_invite_by_46, t0.do_no_invite_on AS do_no_invite_on_47, t0.admin_comments AS admin_comments_48, t0.id_imagefile AS id_imagefile_49, t0.id_imagefile_full AS id_imagefile_full_50, t0.receive_mail AS receive_mail_51, t0.member_alert AS member_alert_52, t0.cit_alert AS cit_alert_53, t0.f_date_ent AS f_date_ent_54, t0.l_date_upd AS l_date_upd_55, t0.created_by AS created_by_56, t0.last_edit_by AS last_edit_by_57, t0.quality_checked_by AS quality_checked_by_58, t0.quality_checked_date AS quality_checked_date_59, t0.quality_checked AS quality_checked_60, t0.is_global AS is_global_61, t0.status AS status_62, t0.statusLastChanged AS statusLastChanged_63, t0.deceased AS deceased_64, t0.deceased_date AS deceased_date_65, t0.retired AS retired_66, t0.retired_date AS retired_date_67, t0.id AS id_68 FROM indiv t0 WHERE t0.id_ind = ? LIMIT 1
Parameters:
[
30288
]
|
| 9 | 0.57 ms |
SELECT t0.id_ind AS id_ind_1, t0.title AS title_2, t0.fname AS fname_3, t0.mname AS mname_4, t0.sname AS sname_5, t0.identifier AS identifier_6, t0.reg_type AS reg_type_7, t0.use_inst_addr AS use_inst_addr_8, t0.private_address AS private_address_9, t0.addr_1 AS addr_1_10, t0.addr_2 AS addr_2_11, t0.city AS city_12, t0.state AS state_13, t0.postcode AS postcode_14, t0.country_code AS country_code_15, t0.id_nationality AS id_nationality_16, t0.gender AS gender_17, t0.tel AS tel_18, t0.fax AS fax_19, t0.email1 AS email1_20, t0.email2 AS email2_21, t0.email3 AS email3_22, t0.emailtouse AS emailtouse_23, t0.url1 AS url1_24, t0.url1Valid AS url1Valid_25, t0.url2 AS url2_26, t0.url2Valid AS url2Valid_27, t0.url3 AS url3_28, t0.url3Valid AS url3Valid_29, t0.urlsChecked AS urlsChecked_30, t0.linkedin AS linkedin_31, t0.facebook AS facebook_32, t0.twitter AS twitter_33, t0.flickr AS flickr_34, t0.other AS other_35, t0.degree AS degree_36, t0.activeng AS activeng_37, t0.activother AS activother_38, t0.jobtitle AS jobtitle_39, t0.dept AS dept_40, t0.studyregion AS studyregion_41, t0.languages AS languages_42, t0.skills AS skills_43, t0.comments AS comments_44, t0.do_not_invite AS do_not_invite_45, t0.do_no_invite_by AS do_no_invite_by_46, t0.do_no_invite_on AS do_no_invite_on_47, t0.admin_comments AS admin_comments_48, t0.id_imagefile AS id_imagefile_49, t0.id_imagefile_full AS id_imagefile_full_50, t0.receive_mail AS receive_mail_51, t0.member_alert AS member_alert_52, t0.cit_alert AS cit_alert_53, t0.f_date_ent AS f_date_ent_54, t0.l_date_upd AS l_date_upd_55, t0.created_by AS created_by_56, t0.last_edit_by AS last_edit_by_57, t0.quality_checked_by AS quality_checked_by_58, t0.quality_checked_date AS quality_checked_date_59, t0.quality_checked AS quality_checked_60, t0.is_global AS is_global_61, t0.status AS status_62, t0.statusLastChanged AS statusLastChanged_63, t0.deceased AS deceased_64, t0.deceased_date AS deceased_date_65, t0.retired AS retired_66, t0.retired_date AS retired_date_67, t0.id AS id_68 FROM indiv t0 WHERE t0.id_ind = ? LIMIT 1
Parameters:
[
30288
]
|
| 10 | 0.47 ms |
SELECT s0_.subname AS subname_0, s0_.id_sub AS id_sub_1 FROM indiv_subjects i1_ LEFT JOIN subjects s0_ ON (s0_.id_sub = i1_.id_sub) WHERE i1_.id_ind = ?
Parameters:
[
30288
]
|
| 11 | 0.40 ms |
SELECT c0_.country AS country_0 FROM countries c0_ WHERE c0_.id_country IN (?)
Parameters:
[
[
"230"
]
]
|
| 12 | 0.39 ms |
SELECT t0.country AS country_1, t0.postcode_pos AS postcode_pos_2, t0.postcode_spacer AS postcode_spacer_3, t0.country_code AS country_code_4, t0.latitude AS latitude_5, t0.longitude AS longitude_6, t0.id_country AS id_country_7 FROM countries t0 WHERE t0.id_country = ? LIMIT 1
Parameters:
[
"230"
]
|
| 13 | 0.39 ms |
SELECT r0_.name AS name_0 FROM regions r0_ WHERE r0_.id_region IN (?)
Parameters:
[
[
"84"
]
]
|
| 14 | 0.38 ms |
SELECT t0.country AS country_1, t0.postcode_pos AS postcode_pos_2, t0.postcode_spacer AS postcode_spacer_3, t0.country_code AS country_code_4, t0.latitude AS latitude_5, t0.longitude AS longitude_6, t0.id_country AS id_country_7 FROM countries t0 WHERE t0.id_country = ? LIMIT 1
Parameters:
[
230
]
|
| 15 | 0.89 ms |
SELECT t0.country AS country_1, t0.postcode_pos AS postcode_pos_2, t0.postcode_spacer AS postcode_spacer_3, t0.country_code AS country_code_4, t0.latitude AS latitude_5, t0.longitude AS longitude_6, t0.id_country AS id_country_7 FROM countries t0 WHERE t0.id_country = ? LIMIT 1
Parameters:
[
230
]
|
| 16 | 0.38 ms |
SELECT t0.country AS country_1, t0.postcode_pos AS postcode_pos_2, t0.postcode_spacer AS postcode_spacer_3, t0.country_code AS country_code_4, t0.latitude AS latitude_5, t0.longitude AS longitude_6, t0.id_country AS id_country_7 FROM countries t0 WHERE t0.id_country = ? LIMIT 1
Parameters:
[
230
]
|
| 17 | 0.40 ms |
SELECT t0.country AS country_1, t0.postcode_pos AS postcode_pos_2, t0.postcode_spacer AS postcode_spacer_3, t0.country_code AS country_code_4, t0.latitude AS latitude_5, t0.longitude AS longitude_6, t0.id_country AS id_country_7 FROM countries t0 WHERE t0.id_country = ? LIMIT 1
Parameters:
[
230
]
|
| 18 | 0.80 ms |
SELECT t0.id_ind AS id_ind_1, t0.title AS title_2, t0.fname AS fname_3, t0.mname AS mname_4, t0.sname AS sname_5, t0.identifier AS identifier_6, t0.reg_type AS reg_type_7, t0.use_inst_addr AS use_inst_addr_8, t0.private_address AS private_address_9, t0.addr_1 AS addr_1_10, t0.addr_2 AS addr_2_11, t0.city AS city_12, t0.state AS state_13, t0.postcode AS postcode_14, t0.country_code AS country_code_15, t0.id_nationality AS id_nationality_16, t0.gender AS gender_17, t0.tel AS tel_18, t0.fax AS fax_19, t0.email1 AS email1_20, t0.email2 AS email2_21, t0.email3 AS email3_22, t0.emailtouse AS emailtouse_23, t0.url1 AS url1_24, t0.url1Valid AS url1Valid_25, t0.url2 AS url2_26, t0.url2Valid AS url2Valid_27, t0.url3 AS url3_28, t0.url3Valid AS url3Valid_29, t0.urlsChecked AS urlsChecked_30, t0.linkedin AS linkedin_31, t0.facebook AS facebook_32, t0.twitter AS twitter_33, t0.flickr AS flickr_34, t0.other AS other_35, t0.degree AS degree_36, t0.activeng AS activeng_37, t0.activother AS activother_38, t0.jobtitle AS jobtitle_39, t0.dept AS dept_40, t0.studyregion AS studyregion_41, t0.languages AS languages_42, t0.skills AS skills_43, t0.comments AS comments_44, t0.do_not_invite AS do_not_invite_45, t0.do_no_invite_by AS do_no_invite_by_46, t0.do_no_invite_on AS do_no_invite_on_47, t0.admin_comments AS admin_comments_48, t0.id_imagefile AS id_imagefile_49, t0.id_imagefile_full AS id_imagefile_full_50, t0.receive_mail AS receive_mail_51, t0.member_alert AS member_alert_52, t0.cit_alert AS cit_alert_53, t0.f_date_ent AS f_date_ent_54, t0.l_date_upd AS l_date_upd_55, t0.created_by AS created_by_56, t0.last_edit_by AS last_edit_by_57, t0.quality_checked_by AS quality_checked_by_58, t0.quality_checked_date AS quality_checked_date_59, t0.quality_checked AS quality_checked_60, t0.is_global AS is_global_61, t0.status AS status_62, t0.statusLastChanged AS statusLastChanged_63, t0.deceased AS deceased_64, t0.deceased_date AS deceased_date_65, t0.retired AS retired_66, t0.retired_date AS retired_date_67, t0.id AS id_68 FROM indiv t0 WHERE t0.id_ind = ? LIMIT 1
Parameters:
[
0
]
|
| 19 | 0.41 ms |
SELECT m0_.id_group AS id_group_0 FROM member_groups m0_ WHERE m0_.id_ind = ?
Parameters:
[
30288
]
|
| 20 | 0.41 ms |
SELECT m0_.id_country AS id_country_0 FROM member_edits_country m0_ WHERE m0_.id_ind = ?
Parameters:
[
30288
]
|
| 21 | 0.40 ms |
SELECT m0_.id_ind AS id_ind_0, m0_.id_inst AS id_inst_1 FROM member_edits_institution m0_ WHERE m0_.id_ind = ? AND m0_.id_inst = ?
Parameters:
[ 30288 15595 ] |
| 22 | 0.57 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:
[
"30288"
]
|
| 23 | 1.27 ms |
SELECT t0.country AS country_1, t0.postcode_pos AS postcode_pos_2, t0.postcode_spacer AS postcode_spacer_3, t0.country_code AS country_code_4, t0.latitude AS latitude_5, t0.longitude AS longitude_6, t0.id_country AS id_country_7 FROM countries t0 ORDER BY t0.country ASC
Parameters:
[] |
| 24 | 2.76 ms |
SELECT t0.groupname AS groupname_1, t0.description AS description_2, t0.id_parentgroup AS id_parentgroup_3, t0.group_order AS group_order_4, t0.has_site AS has_site_5, t0.url AS url_6, t0.official_body AS official_body_7, t0.id_mstemplate AS id_mstemplate_8, t0.id_group AS id_group_9 FROM groups t0 ORDER BY t0.groupname ASC
Parameters:
[] |
| 25 | 6.45 ms |
SELECT e0_.id_event AS id_event_0 FROM event_participants e0_ WHERE e0_.id_ind = ?
Parameters:
[
"30288"
]
|
| 26 | 1.06 ms |
SELECT e0_.id_event AS id_event_0 FROM event_contacts e0_ WHERE e0_.id_ind = ?
Parameters:
[
"30288"
]
|
| 27 | 0.74 ms |
SELECT e0_.id_event AS id_event_0 FROM event_staff e0_ WHERE e0_.id_ind = ?
Parameters:
[
"30288"
]
|
| 28 | 0.70 ms |
SELECT e0_.id_event AS id_event_0, e0_.title AS title_1, e0_.start_on AS start_on_2, e0_.end_on AS end_on_3, e0_.address AS address_4, e0_.city AS city_5, e0_.state AS state_6, e0_.postcode AS postcode_7, c1_.country AS country_8 FROM events e0_ LEFT JOIN countries c1_ ON (e0_.id_country = c1_.id_country) WHERE e0_.id_event IN (?) AND e0_.status = 1 ORDER BY e0_.start_on DESC
Parameters:
[
[
2020
2015
2282
2413
]
]
|
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. |
| OceanExpertBundle\Entity\IndivMeta | No errors. |
| OceanExpertBundle\Entity\IndivJobtype | No errors. |
| OceanExpertBundle\Entity\Jobtypes | No errors. |
| OceanExpertBundle\Entity\MemberGroups | No errors. |
| OceanExpertBundle\Entity\Groups | No errors. |
| OceanExpertBundle\Entity\Countries | No errors. |
| OceanExpertBundle\Entity\IndivSubjects | No errors. |
| OceanExpertBundle\Entity\Subjects | No errors. |
| OceanExpertBundle\Entity\Regions | No errors. |
| OceanExpertBundle\Entity\MemberEditsCountry | No errors. |
| OceanExpertBundle\Entity\MemberEditsInstitution | No errors. |
| FOS\UserBundle\Model\User | No errors. |
| OceanExpertBundle\Entity\User | No errors. |
| OceanExpertBundle\Entity\EventParticipants | No errors. |
| OceanExpertBundle\Entity\EventContacts | No errors. |
| OceanExpertBundle\Entity\EventStaff | No errors. |
| OceanExpertBundle\Entity\Events | No errors. |