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_.inst_type_id AS inst_type_id_1, i0_.inst_name AS inst_name_2, i0_.inst_name_eng AS inst_name_eng_3, i0_.inst_address AS inst_address_4, i0_.addr_2 AS addr_2_5, i0_.city AS city_6, i0_.state AS state_7, i0_.postcode AS postcode_8, i0_.country_code AS country_code_9, i0_.acronym AS acronym_10, i0_.inst_logo AS inst_logo_11, i0_.inst_tel AS inst_tel_12, i0_.inst_fax AS inst_fax_13, i0_.inst_email AS inst_email_14, i0_.inst_url AS inst_url_15, i0_.edmo_code AS edmo_code_16, i0_.inst_region AS inst_region_17, i0_.activities AS activities_18, i0_.popularity AS popularity_19, i0_.activated AS activated_20, i0_.f_date_entered AS f_date_entered_21, i0_.l_date_updated AS l_date_updated_22, i0_.created_by AS created_by_23, i0_.last_edit_by AS last_edit_by_24, i1_.insttype_name AS insttype_name_25, c2_.country AS country_26, c2_.country_code AS country_code_27, i0_.parent_id AS parent_id_28, i3_.inst_name AS inst_name_29, i3_.inst_name_eng AS inst_name_eng_30, i3_.acronym AS acronym_31, i3_.inst_logo AS inst_logo_32 FROM institutions i0_ LEFT JOIN insttypes i1_ ON (i1_.id_insttype = i0_.inst_type_id) LEFT JOIN countries c2_ ON (c2_.id_country = i0_.country_code) LEFT JOIN institutions i3_ ON (i3_.id_inst = i0_.parent_id AND i3_.activated = 1) WHERE i0_.id_inst = ? AND (i0_.activated = 1 OR i0_.created_by = ?)

[
  16862
  0
]

SELECT
  i0_.id_inst AS id_inst_0,
  i0_.inst_type_id AS inst_type_id_1,
  i0_.inst_name AS inst_name_2,
  i0_.inst_name_eng AS inst_name_eng_3,
  i0_.inst_address AS inst_address_4,
  i0_.addr_2 AS addr_2_5,
  i0_.city AS city_6,
  i0_.state AS state_7,
  i0_.postcode AS postcode_8,
  i0_.country_code AS country_code_9,
  i0_.acronym AS acronym_10,
  i0_.inst_logo AS inst_logo_11,
  i0_.inst_tel AS inst_tel_12,
  i0_.inst_fax AS inst_fax_13,
  i0_.inst_email AS inst_email_14,
  i0_.inst_url AS inst_url_15,
  i0_.edmo_code AS edmo_code_16,
  i0_.inst_region AS inst_region_17,
  i0_.activities AS activities_18,
  i0_.popularity AS popularity_19,
  i0_.activated AS activated_20,
  i0_.f_date_entered AS f_date_entered_21,
  i0_.l_date_updated AS l_date_updated_22,
  i0_.created_by AS created_by_23,
  i0_.last_edit_by AS last_edit_by_24,
  i1_.insttype_name AS insttype_name_25,
  c2_.country AS country_26,
  c2_.country_code AS country_code_27,
  i0_.parent_id AS parent_id_28,
  i3_.inst_name AS inst_name_29,
  i3_.inst_name_eng AS inst_name_eng_30,
  i3_.acronym AS acronym_31,
  i3_.inst_logo AS inst_logo_32
FROM
  institutions i0_
  LEFT JOIN insttypes i1_ ON (
    i1_.id_insttype = i0_.inst_type_id
  )
  LEFT JOIN countries c2_ ON (
    c2_.id_country = i0_.country_code
  )
  LEFT JOIN institutions i3_ ON (
    i3_.id_inst = i0_.parent_id
    AND i3_.activated = 1
  )
WHERE
  i0_.id_inst = ?
  AND (
    i0_.activated = 1
    OR i0_.created_by = ?
  )

SELECT i0_.id_inst AS id_inst_0, i0_.inst_type_id AS inst_type_id_1, i0_.inst_name AS inst_name_2, i0_.inst_name_eng AS inst_name_eng_3, i0_.inst_address AS inst_address_4, i0_.addr_2 AS addr_2_5, i0_.city AS city_6, i0_.state AS state_7, i0_.postcode AS postcode_8, i0_.country_code AS country_code_9, i0_.acronym AS acronym_10, i0_.inst_logo AS inst_logo_11, i0_.inst_tel AS inst_tel_12, i0_.inst_fax AS inst_fax_13, i0_.inst_email AS inst_email_14, i0_.inst_url AS inst_url_15, i0_.edmo_code AS edmo_code_16, i0_.inst_region AS inst_region_17, i0_.activities AS activities_18, i0_.popularity AS popularity_19, i0_.activated AS activated_20, i0_.f_date_entered AS f_date_entered_21, i0_.l_date_updated AS l_date_updated_22, i0_.created_by AS created_by_23, i0_.last_edit_by AS last_edit_by_24, i1_.insttype_name AS insttype_name_25, c2_.country AS country_26, c2_.country_code AS country_code_27, i0_.parent_id AS parent_id_28, i3_.inst_name AS inst_name_29, i3_.inst_name_eng AS inst_name_eng_30, i3_.acronym AS acronym_31, i3_.inst_logo AS inst_logo_32 FROM institutions i0_ LEFT JOIN insttypes i1_ ON (i1_.id_insttype = i0_.inst_type_id) LEFT JOIN countries c2_ ON (c2_.id_country = i0_.country_code) LEFT JOIN institutions i3_ ON (i3_.id_inst = i0_.parent_id AND i3_.activated = 1) WHERE i0_.id_inst = 16862 AND (i0_.activated = 1 OR i0_.created_by = 0);

SELECT t0.insttype_name AS insttype_name_1, t0.id_insttype AS id_insttype_2 FROM insttypes t0

[]

SELECT
  t0.insttype_name AS insttype_name_1,
  t0.id_insttype AS id_insttype_2
FROM
  insttypes t0

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

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 s0_.id_searegion AS id_searegion_0, s0_.name AS name_1 FROM searegions s0_ ORDER BY s0_.name ASC

[]

SELECT
  s0_.id_searegion AS id_searegion_0,
  s0_.name AS name_1
FROM
  searegions s0_
ORDER BY
  s0_.name ASC

SELECT s0_.id_searegion AS id_searegion_0, s0_.name AS name_1 FROM searegions s0_ ORDER BY s0_.name ASC;