https://dev.oceanexpert.org/expert/11768

Query Metrics

22 Database Queries
21 Different statements
92.34 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 9.21 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_.name AS name_68, p1_.path AS path_69, i2_.id_inst AS id_inst_70, i2_.inst_name AS inst_name_71, i2_.country_code AS country_code_72, i2_.state AS state_73, i2_.city AS city_74, i2_.postcode AS postcode_75, i2_.inst_address AS inst_address_76, i2_.addr_2 AS addr_2_77 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:
0 of 0
[ "11768" ]
2 33.54 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:
0 of 0
[ 11768 ]
3 1.54 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:
0 of 0
[ 11768 ]
4 2.49 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:
0 of 0
[ "11768" ]
5 1.88 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.unesco_member AS unesco_member_7, t0.ioc_member AS ioc_member_8, t0.is_executive AS is_executive_9, t0.id_country AS id_country_10 FROM countries t0 WHERE t0.id_country = ? LIMIT 1
Parameters:
0 of 0
[ 205 ]
6 0.77 ms
SELECT c0_.country AS country_0, c0_.country_code AS country_code_1, c0_.longitude AS longitude_2, c0_.latitude AS latitude_3 FROM countries c0_ WHERE c0_.id_country IN (?) OR c0_.country_code IN (?)
Parameters:
0 of 0
[ [ "CH" ] [ "CH" ] ]
7 0.44 ms
SELECT t0.languagename AS languagename_1, t0.languagecode AS languagecode_2, t0.id_language AS id_language_3 FROM languages t0
Parameters:
[]
8 0.43 ms
SELECT j0_.jobname AS jobname_0 FROM jobtypes j0_ WHERE j0_.id_job IN (?)
Parameters:
0 of 0
[ [ "Director" " WIGOS" ] ]
9 1.15 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:
0 of 0
[ 11768 ]
10 0.53 ms
SELECT c0_.country AS country_0, c0_.country_code AS country_code_1, c0_.longitude AS longitude_2, c0_.latitude AS latitude_3 FROM countries c0_ WHERE c0_.id_country IN (?) OR c0_.country_code IN (?)
Parameters:
0 of 0
[ [ "205" "223" ] [ "205" "223" ] ]
11 0.47 ms
SELECT s0_.name AS name_0 FROM searegions s0_ WHERE s0_.id_searegion IN (?)
Parameters:
0 of 0
[ [ "" ] ]
12 4.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:
0 of 0
[ 0 ]
13 0.51 ms
SELECT m0_.id_group AS id_group_0 FROM member_groups m0_ WHERE m0_.id_ind = ?
Parameters:
0 of 0
[ "11768" ]
14 0.55 ms
SELECT m0_.id_country AS id_country_0 FROM member_edits_country m0_ WHERE m0_.id_ind = ?
Parameters:
0 of 0
[ "11768" ]
15 1.12 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:
0 of 0
[ "11768" 9625 ]
16 1.06 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:
0 of 0
[ "11768" ]
17 1.74 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.unesco_member AS unesco_member_7, t0.ioc_member AS ioc_member_8, t0.is_executive AS is_executive_9, t0.id_country AS id_country_10 FROM countries t0 ORDER BY t0.country ASC
Parameters:
[]
18 4.80 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:
[]
19 7.23 ms
SELECT e0_.id_event AS id_event_0 FROM event_participants e0_ WHERE e0_.id_ind = ?
Parameters:
0 of 0
[ 11768 ]
20 1.45 ms
SELECT e0_.id_event AS id_event_0 FROM event_contacts e0_ WHERE e0_.id_ind = ?
Parameters:
0 of 0
[ 11768 ]
21 1.02 ms
SELECT e0_.id_event AS id_event_0 FROM event_staff e0_ WHERE e0_.id_ind = ?
Parameters:
0 of 0
[ 11768 ]
22 15.69 ms
SELECT e0_.id_event AS id_event_0, e0_.title AS title_1, e0_.id_eventtype AS id_eventtype_2, e0_.start_on AS start_on_3, e0_.end_on AS end_on_4, e0_.address AS address_5, e0_.city AS city_6, e0_.state AS state_7, e0_.postcode AS postcode_8, c1_.country AS country_9 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:
0 of 0
[ [ 0 => 112 1 => 113 2 => 153 3 => 155 4 => 160 5 => 187 6 => 198 7 => 204 8 => 326 9 => 375 10 => 441 11 => 537 12 => 553 13 => 596 14 => 651 15 => 661 16 => 681 17 => 708 18 => 756 19 => 762 20 => 813 21 => 919 22 => 1014 23 => 1055 24 => 1087 25 => 1102 26 => 1194 27 => 1248 28 => 1281 29 => 1282 30 => 1298 31 => 1331 32 => 1338 33 => 1364 34 => 1383 35 => 1402 36 => 1409 37 => 1450 38 => 1494 39 => 1496 40 => 1498 41 => 1521 42 => 1601 43 => 1629 44 => 1630 45 => 1663 46 => 1670 47 => 1695 48 => 1701 49 => 1727 50 => 1733 51 => 1786 52 => 1795 53 => 1801 54 => 1841 55 => 1886 56 => 1938 57 => 393 58 => 1266 59 => 1825 60 => 1900 61 => 1904 62 => 1919 63 => 2146 64 => 2166 65 => 2099 66 => 2229 67 => 1974 68 => 2120 69 => 2243 70 => 2363 71 => 2457 72 => 2321 73 => 2422 74 => 2320 75 => 2544 76 => 1686 77 => 2588 78 => 2397 79 => 2314 80 => 2561 81 => 2608 82 => 2486 83 => 2591 84 => 2662 85 => 2754 86 => 2848 87 => 2759 88 => 2641 89 => 2755 90 => 2924 91 => 2041 92 => 1817 93 => 1468 94 => 2844 95 => 3260 96 => 3379 97 => 3606 98 => 3647 99 => 3642 100 => 3818 101 => 4019 102 => 3981 103 => 4343 104 => 4598 105 => 4656 106 => 61 109 => 320 112 => 387 119 => 712 120 => 735 122 => 758 123 => 761 125 => 1045 126 => 1071 128 => 1188 133 => 1288 134 => 1303 136 => 1448 137 => 1473 139 => 1613 141 => 1688 145 => 2086 146 => 2214 147 => 2224 151 => 2602 152 => 2661 154 => 3318 156 => 0 157 => 140 160 => 175 161 => 242 162 => 478 163 => 523 164 => 549 165 => 700 166 => 755 167 => 760 168 => 1099 169 => 1206 170 => 1226 174 => 1444 176 => 1513 180 => 1653 183 => 1767 185 => 1805 187 => 1869 188 => 1890 189 => 1921 190 => 1973 191 => 2029 194 => 2256 195 => 2262 197 => 2418 199 => 2539 201 => 2599 203 => 3006 204 => 3194 205 => 3195 206 => 3196 ] ]

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\Languages No errors.
OceanExpertBundle\Entity\IndivSubjects No errors.
OceanExpertBundle\Entity\Subjects No errors.
OceanExpertBundle\Entity\Searegions 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.