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

Query Metrics

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

Queries

Group similar statements

# Time Info
1 9.06 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
[ "26192" ]
2 28.46 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
[ 26192 ]
3 0.72 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
[ 26192 ]
4 0.80 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
[ "26192" ]
5 0.67 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:
0 of 0
[ 21 ]
6 0.98 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
[ [ "BE" ] [ "BE" ] ]
7 0.54 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.47 ms
SELECT j0_.jobname AS jobname_0 FROM jobtypes j0_ WHERE j0_.id_job IN (?)
Parameters:
0 of 0
[ [ "OBIS Data Manager" ] ]
9 0.74 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
[ 26192 ]
10 0.57 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
[ [ "21" ] [ "21" ] ]
11 0.50 ms
SELECT r0_.name AS name_0 FROM regions r0_ WHERE r0_.id_region IN (?)
Parameters:
0 of 0
[ [ "" ] ]
12 0.69 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.48 ms
SELECT m0_.id_group AS id_group_0 FROM member_groups m0_ WHERE m0_.id_ind = ?
Parameters:
0 of 0
[ "26192" ]
14 0.48 ms
SELECT m0_.id_country AS id_country_0 FROM member_edits_country m0_ WHERE m0_.id_ind = ?
Parameters:
0 of 0
[ "26192" ]
15 0.56 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
[ "26192" 10171 ]
16 0.79 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
[ "26192" ]
17 1.25 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:
[]
18 2.86 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.34 ms
SELECT e0_.id_event AS id_event_0 FROM event_participants e0_ WHERE e0_.id_ind = ?
Parameters:
0 of 0
[ 26192 ]
20 4.88 ms
SELECT e0_.id_event AS id_event_0 FROM event_contacts e0_ WHERE e0_.id_ind = ?
Parameters:
0 of 0
[ 26192 ]
21 0.89 ms
SELECT e0_.id_event AS id_event_0 FROM event_staff e0_ WHERE e0_.id_ind = ?
Parameters:
0 of 0
[ 26192 ]
22 3.37 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 => 1660 1 => 1667 2 => 1698 3 => 1727 4 => 1731 5 => 1841 6 => 1872 7 => 1937 8 => 1875 9 => 1650 10 => 2030 11 => 1883 12 => 2014 13 => 2091 14 => 2016 15 => 2163 16 => 2025 17 => 2077 18 => 2202 19 => 2118 20 => 2146 21 => 2099 22 => 2144 23 => 2238 24 => 2136 25 => 2247 26 => 2506 27 => 2538 28 => 2454 29 => 2551 30 => 2650 31 => 2608 32 => 2720 33 => 2754 34 => 2753 35 => 2823 36 => 2752 37 => 2858 38 => 2891 39 => 2641 40 => 2699 41 => 2755 42 => 2849 43 => 2916 44 => 2924 45 => 2911 46 => 2912 47 => 2914 48 => 2985 49 => 3011 50 => 2884 51 => 2844 52 => 3102 53 => 2890 54 => 3110 55 => 3111 56 => 2940 57 => 2944 58 => 2886 59 => 2887 60 => 2986 61 => 2889 62 => 2893 63 => 2732 64 => 2734 65 => 2903 66 => 2943 67 => 3073 68 => 3113 69 => 3114 70 => 3115 71 => 3265 72 => 3132 73 => 3276 74 => 3087 75 => 3122 76 => 3123 77 => 3125 78 => 3191 79 => 3349 80 => 3350 81 => 3351 82 => 3353 83 => 3356 84 => 3358 85 => 3362 86 => 3364 87 => 3365 88 => 3368 89 => 3385 90 => 3394 91 => 3440 92 => 3441 93 => 3442 94 => 3443 95 => 3444 96 => 3445 97 => 3446 98 => 3447 99 => 3448 100 => 3449 101 => 3451 102 => 3452 103 => 3453 104 => 3454 105 => 3455 106 => 3456 107 => 3457 108 => 3458 109 => 3459 110 => 3460 111 => 3461 112 => 3462 113 => 3463 114 => 3464 115 => 3465 116 => 3466 117 => 3467 118 => 3472 119 => 3473 120 => 3474 121 => 3475 122 => 3476 123 => 3477 124 => 3478 125 => 3479 126 => 3480 127 => 3481 128 => 3482 129 => 3483 130 => 3580 131 => 3581 132 => 3583 133 => 3586 134 => 3587 135 => 3588 136 => 3589 137 => 3592 138 => 3679 139 => 3614 140 => 3733 141 => 3734 142 => 3735 143 => 3736 144 => 3737 145 => 3738 146 => 3739 147 => 3740 148 => 3741 149 => 3742 150 => 3743 151 => 3744 152 => 3745 153 => 3746 154 => 3747 155 => 3748 156 => 3750 157 => 3751 158 => 3752 159 => 3753 160 => 3754 161 => 3755 162 => 3756 163 => 3757 164 => 3758 165 => 3762 166 => 3763 167 => 3764 168 => 3765 169 => 3766 170 => 3767 171 => 3768 172 => 3769 173 => 3770 174 => 3771 175 => 3772 176 => 3773 177 => 3774 178 => 3775 179 => 3776 180 => 3777 181 => 3782 182 => 3785 183 => 3786 184 => 3787 185 => 3788 186 => 3789 187 => 3790 188 => 3791 189 => 3450 190 => 3657 191 => 3607 192 => 3852 193 => 3878 194 => 3879 195 => 3880 196 => 3881 197 => 3882 198 => 3883 199 => 3884 200 => 3885 201 => 3886 202 => 3887 203 => 3888 204 => 3889 205 => 3890 206 => 3891 207 => 3892 208 => 3893 209 => 3894 210 => 3895 211 => 3896 212 => 3714 213 => 3715 214 => 3716 215 => 3717 216 => 3718 217 => 3719 218 => 3720 219 => 3721 220 => 3722 221 => 3723 222 => 3724 223 => 3725 224 => 3727 225 => 3728 226 => 3729 227 => 3730 228 => 3731 229 => 3732 230 => 3967 231 => 3974 232 => 3979 233 => 3929 234 => 3965 235 => 4048 236 => 4099 237 => 4100 238 => 4101 239 => 4102 240 => 4103 241 => 4104 242 => 4105 243 => 4106 244 => 4107 245 => 4108 246 => 4109 247 => 4110 248 => 4111 249 => 4112 250 => 4113 251 => 4114 252 => 4115 253 => 4116 254 => 4117 255 => 4118 256 => 4119 257 => 4120 258 => 4121 259 => 4122 260 => 4123 261 => 4124 262 => 4125 263 => 4126 264 => 4127 265 => 4128 266 => 4129 267 => 4130 268 => 4131 269 => 4132 270 => 4133 271 => 4134 272 => 4135 273 => 4136 274 => 4137 275 => 4138 276 => 4139 277 => 4140 278 => 4141 279 => 4142 280 => 4143 281 => 4144 282 => 4145 283 => 4146 284 => 4147 285 => 4148 286 => 4149 287 => 4150 288 => 4151 289 => 4152 290 => 4153 291 => 4154 292 => 4155 293 => 4156 294 => 4157 295 => 4158 296 => 4159 297 => 4160 298 => 4161 299 => 4162 300 => 4163 301 => 4164 302 => 4165 303 => 4166 304 => 4167 305 => 4168 306 => 4169 307 => 3983 308 => 4224 309 => 4278 310 => 4327 311 => 4358 312 => 4430 313 => 0 314 => 4477 315 => 4483 318 => 2729 319 => 2731 320 => 2733 321 => 1860 323 => 2407 324 => 3361 ] ]

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\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.