Query Metrics

4 Database Queries
4 Different statements
5.63 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 1.53 ms
SELECT i0_.id AS id_0, 1 AS sclr_1, m1_.id_ind AS id_ind_2, i0_.id_ind AS id_ind_3, i0_.fname AS fname_4, i0_.mname AS mname_5, i0_.sname AS sname_6, i0_.email1 AS email1_7, i0_.email2 AS email2_8, CONCAT('/uploads/profile/profile_', i0_.id_ind, '.png') AS sclr_9, CONCAT(i0_.sname, ' ', i0_.fname) AS sclr_10, i0_.status AS status_11, i0_.deceased AS deceased_12, i0_.retired AS retired_13, i0_.do_not_invite AS do_not_invite_14, m1_.role AS role_15, c2_.country AS country_16, i0_.id_nationality AS id_nationality_17 FROM indiv i0_, member_groups m1_, countries c2_ WHERE m1_.id_group = 218 AND m1_.id_ind = i0_.id_ind AND i0_.country_code = c2_.id_country AND i0_.use_inst_addr <> 1
Parameters:
[]
2 1.86 ms
SELECT i0_.id AS id_0, 1 AS sclr_1, m1_.id_ind AS id_ind_2, i0_.id_ind AS id_ind_3, i0_.fname AS fname_4, i0_.mname AS mname_5, i0_.sname AS sname_6, i0_.email1 AS email1_7, i0_.email2 AS email2_8, CONCAT('/uploads/profile/profile_', i0_.id_ind, '.png') AS sclr_9, CONCAT(i0_.sname, ' ', i0_.fname) AS sclr_10, i0_.status AS status_11, i0_.deceased AS deceased_12, i0_.retired AS retired_13, i0_.do_not_invite AS do_not_invite_14, m1_.role AS role_15, c2_.country AS country_16, i0_.id_nationality AS id_nationality_17 FROM indiv i0_, member_groups m1_, institutions i3_, indiv_institution i4_, countries c2_ WHERE m1_.id_group = 218 AND m1_.id_ind = i0_.id_ind AND i3_.country_code = c2_.id_country AND i0_.use_inst_addr = 1 AND i4_.id_ind = i0_.id_ind AND i4_.id_inst = i3_.id_inst
Parameters:
[]
3 1.10 ms
SELECT c0_.id_country AS id_country_0, c0_.country AS country_1 FROM countries c0_
Parameters:
[]
4 1.14 ms
SELECT i0_.id_ind AS id_ind_0, i1_.id_inst AS id_inst_1, i1_.inst_name AS inst_name_2 FROM institutions i1_, indiv_institution i0_ WHERE i0_.id_ind IN (12123, 23908, 18340, 16111, 33563, 16016, 16193, 24009, 22532, 23385, 36030, 16268, 22531, 39209, 14823, 18770, 31907) AND i0_.id_inst = i1_.id_inst
Parameters:
[]

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\MemberGroups No errors.
OceanExpertBundle\Entity\Countries No errors.
OceanExpertBundle\Entity\Institutions No errors.
OceanExpertBundle\Entity\IndivInstitution No errors.