Symfony Profiler

• Request / Response
• Performance
• Validator
• Forms
• Exception
• Logs 5
• Events
• Routing
• Cache
• Translation
• Security
• Twig
• Doctrine
• Debug
• Emails
• Serializer
• JMS Serializer 0 + 0
• Configuration

Query Metrics

SELECT i0_.id_inst AS id_inst_0, i0_.parent_id AS parent_id_1, i0_.inst_type_id AS inst_type_id_2, i0_.inst_name AS inst_name_3, i0_.inst_name_eng AS inst_name_eng_4, i0_.country_code AS country_code_5, i0_.activated AS activated_6, c1_.country AS country_7, i2_.insttype_name AS insttype_name_8 FROM institutions i0_ LEFT JOIN countries c1_ ON (i0_.country_code = c1_.id_country) LEFT JOIN insttypes i2_ ON (i0_.inst_type_id = i2_.id_insttype) WHERE i0_.activated = 1 OR i0_.created_by = ? ORDER BY i0_.f_date_entered DESC

[
  0
]

SELECT
  i0_.id_inst AS id_inst_0,
  i0_.parent_id AS parent_id_1,
  i0_.inst_type_id AS inst_type_id_2,
  i0_.inst_name AS inst_name_3,
  i0_.inst_name_eng AS inst_name_eng_4,
  i0_.country_code AS country_code_5,
  i0_.activated AS activated_6,
  c1_.country AS country_7,
  i2_.insttype_name AS insttype_name_8
FROM
  institutions i0_
  LEFT JOIN countries c1_ ON (
    i0_.country_code = c1_.id_country
  )
  LEFT JOIN insttypes i2_ ON (
    i0_.inst_type_id = i2_.id_insttype
  )
WHERE
  i0_.activated = 1
  OR i0_.created_by = ?
ORDER BY
  i0_.f_date_entered DESC

SELECT i0_.id_inst AS id_inst_0, i0_.parent_id AS parent_id_1, i0_.inst_type_id AS inst_type_id_2, i0_.inst_name AS inst_name_3, i0_.inst_name_eng AS inst_name_eng_4, i0_.country_code AS country_code_5, i0_.activated AS activated_6, c1_.country AS country_7, i2_.insttype_name AS insttype_name_8 FROM institutions i0_ LEFT JOIN countries c1_ ON (i0_.country_code = c1_.id_country) LEFT JOIN insttypes i2_ ON (i0_.inst_type_id = i2_.id_insttype) WHERE i0_.activated = 1 OR i0_.created_by = 0 ORDER BY i0_.f_date_entered DESC;

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

[]

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

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;

SELECT t0.insttype_name AS insttype_name_1, t0.id_insttype AS id_insttype_2 FROM insttypes t0 ORDER BY t0.insttype_name ASC

[]

SELECT
  t0.insttype_name AS insttype_name_1,
  t0.id_insttype AS id_insttype_2
FROM
  insttypes t0
ORDER BY
  t0.insttype_name ASC

SELECT t0.insttype_name AS insttype_name_1, t0.id_insttype AS id_insttype_2 FROM insttypes t0 ORDER BY t0.insttype_name ASC;

SELECT count(DISTINCT i0_.id_inst) AS sclr_0 FROM institutions i0_ LEFT JOIN countries c1_ ON (i0_.country_code = c1_.id_country) LEFT JOIN insttypes i2_ ON (i0_.inst_type_id = i2_.id_insttype) WHERE i0_.activated = 1 OR i0_.created_by = ?

[
  0
]

SELECT
  count(DISTINCT i0_.id_inst) AS sclr_0
FROM
  institutions i0_
  LEFT JOIN countries c1_ ON (
    i0_.country_code = c1_.id_country
  )
  LEFT JOIN insttypes i2_ ON (
    i0_.inst_type_id = i2_.id_insttype
  )
WHERE
  i0_.activated = 1
  OR i0_.created_by = ?

SELECT count(DISTINCT i0_.id_inst) AS sclr_0 FROM institutions i0_ LEFT JOIN countries c1_ ON (i0_.country_code = c1_.id_country) LEFT JOIN insttypes i2_ ON (i0_.inst_type_id = i2_.id_insttype) WHERE i0_.activated = 1 OR i0_.created_by = 0;

SELECT DISTINCT i0_.id_inst AS id_inst_0, i0_.f_date_entered AS f_date_entered_1 FROM institutions i0_ LEFT JOIN countries c1_ ON (i0_.country_code = c1_.id_country) LEFT JOIN insttypes i2_ ON (i0_.inst_type_id = i2_.id_insttype) WHERE i0_.activated = 1 OR i0_.created_by = ? ORDER BY i0_.f_date_entered DESC LIMIT 10 OFFSET 9760

[
  0
]

SELECT
  DISTINCT i0_.id_inst AS id_inst_0,
  i0_.f_date_entered AS f_date_entered_1
FROM
  institutions i0_
  LEFT JOIN countries c1_ ON (
    i0_.country_code = c1_.id_country
  )
  LEFT JOIN insttypes i2_ ON (
    i0_.inst_type_id = i2_.id_insttype
  )
WHERE
  i0_.activated = 1
  OR i0_.created_by = ?
ORDER BY
  i0_.f_date_entered DESC
LIMIT
  10
OFFSET
  9760

SELECT DISTINCT i0_.id_inst AS id_inst_0, i0_.f_date_entered AS f_date_entered_1 FROM institutions i0_ LEFT JOIN countries c1_ ON (i0_.country_code = c1_.id_country) LEFT JOIN insttypes i2_ ON (i0_.inst_type_id = i2_.id_insttype) WHERE i0_.activated = 1 OR i0_.created_by = 0 ORDER BY i0_.f_date_entered DESC LIMIT 10 OFFSET 9760;

SELECT i0_.id_inst AS id_inst_0, i0_.parent_id AS parent_id_1, i0_.inst_type_id AS inst_type_id_2, i0_.inst_name AS inst_name_3, i0_.inst_name_eng AS inst_name_eng_4, i0_.country_code AS country_code_5, i0_.activated AS activated_6, c1_.country AS country_7, i2_.insttype_name AS insttype_name_8 FROM institutions i0_ LEFT JOIN countries c1_ ON (i0_.country_code = c1_.id_country) LEFT JOIN insttypes i2_ ON (i0_.inst_type_id = i2_.id_insttype) WHERE (i0_.activated = 1 OR i0_.created_by = ?) AND i0_.id_inst IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY i0_.f_date_entered DESC

[
  0
  9998
  10013
  10023
  10027
  10042
  10047
  10052
  10053
  10054
  10057
]

SELECT
  i0_.id_inst AS id_inst_0,
  i0_.parent_id AS parent_id_1,
  i0_.inst_type_id AS inst_type_id_2,
  i0_.inst_name AS inst_name_3,
  i0_.inst_name_eng AS inst_name_eng_4,
  i0_.country_code AS country_code_5,
  i0_.activated AS activated_6,
  c1_.country AS country_7,
  i2_.insttype_name AS insttype_name_8
FROM
  institutions i0_
  LEFT JOIN countries c1_ ON (
    i0_.country_code = c1_.id_country
  )
  LEFT JOIN insttypes i2_ ON (
    i0_.inst_type_id = i2_.id_insttype
  )
WHERE
  (
    i0_.activated = 1
    OR i0_.created_by = ?
  )
  AND i0_.id_inst IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
ORDER BY
  i0_.f_date_entered DESC

SELECT i0_.id_inst AS id_inst_0, i0_.parent_id AS parent_id_1, i0_.inst_type_id AS inst_type_id_2, i0_.inst_name AS inst_name_3, i0_.inst_name_eng AS inst_name_eng_4, i0_.country_code AS country_code_5, i0_.activated AS activated_6, c1_.country AS country_7, i2_.insttype_name AS insttype_name_8 FROM institutions i0_ LEFT JOIN countries c1_ ON (i0_.country_code = c1_.id_country) LEFT JOIN insttypes i2_ ON (i0_.inst_type_id = i2_.id_insttype) WHERE (i0_.activated = 1 OR i0_.created_by = 0) AND i0_.id_inst IN (9998, 10013, 10023, 10027, 10042, 10047, 10052, 10053, 10054, 10057) ORDER BY i0_.f_date_entered DESC;