Symfony Profiler

• Request / Response
• Performance
• Validator
• Forms
• Exception
• Logs 2
• Events
• Routing
• Cache
• Translation
• Twig
• HTTP Client
• Doctrine
• Configuration

Query Metrics

SELECT t0.id AS id_1, t0.function_name AS function_name_2, t0.slug AS slug_3, t0.function_desctiption AS function_desctiption_4, t0.readable AS readable_5, t0.official AS official_6 FROM functions t0 WHERE t0.slug = ? LIMIT 1

[
  "antioxidant"
]

SELECT
  t0.id AS id_1,
  t0.function_name AS function_name_2,
  t0.slug AS slug_3,
  t0.function_desctiption AS function_desctiption_4,
  t0.readable AS readable_5,
  t0.official AS official_6
FROM
  functions t0
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.function_name AS function_name_2, t0.slug AS slug_3, t0.function_desctiption AS function_desctiption_4, t0.readable AS readable_5, t0.official AS official_6 FROM functions t0 WHERE t0.slug = 'antioxidant' LIMIT 1;

SELECT field_name, content FROM translations
             WHERE entity_type = ? AND entity_id = ? AND locale = ?

[
  "function"
  14
  "ru"
]

SELECT
  field_name,
  content
FROM
  translations
WHERE
  entity_type = ?
  AND entity_id = ?
  AND locale = ?

SELECT field_name, content FROM translations
             WHERE entity_type = 'function' AND entity_id = 14 AND locale = 'ru';

SELECT COUNT(*) FROM translations
             WHERE entity_type = ? AND entity_id = ? AND locale = ?

[
  "function"
  14
  "ru"
]

SELECT
  COUNT(*)
FROM
  translations
WHERE
  entity_type = ?
  AND entity_id = ?
  AND locale = ?

SELECT COUNT(*) FROM translations
             WHERE entity_type = 'function' AND entity_id = 14 AND locale = 'ru';

SELECT count(DISTINCT i0_.id) AS sclr_0 FROM ingredients i0_ INNER JOIN function_to_ingredient f2_ ON i0_.id = f2_.ingredient_id INNER JOIN functions f1_ ON f1_.id = f2_.function_id WHERE f1_.id = ?

[
  14
]

SELECT
  count(DISTINCT i0_.id) AS sclr_0
FROM
  ingredients i0_
  INNER JOIN function_to_ingredient f2_ ON i0_.id = f2_.ingredient_id
  INNER JOIN functions f1_ ON f1_.id = f2_.function_id
WHERE
  f1_.id = ?

SELECT count(DISTINCT i0_.id) AS sclr_0 FROM ingredients i0_ INNER JOIN function_to_ingredient f2_ ON i0_.id = f2_.ingredient_id INNER JOIN functions f1_ ON f1_.id = f2_.function_id WHERE f1_.id = 14;

SELECT DISTINCT i0_.id AS id_0, i0_.ingredient_name AS ingredient_name_1 FROM ingredients i0_ INNER JOIN function_to_ingredient f2_ ON i0_.id = f2_.ingredient_id INNER JOIN functions f1_ ON f1_.id = f2_.function_id WHERE f1_.id = ? ORDER BY i0_.ingredient_name ASC LIMIT 50

[
  14
]

SELECT
  DISTINCT i0_.id AS id_0,
  i0_.ingredient_name AS ingredient_name_1
FROM
  ingredients i0_
  INNER JOIN function_to_ingredient f2_ ON i0_.id = f2_.ingredient_id
  INNER JOIN functions f1_ ON f1_.id = f2_.function_id
WHERE
  f1_.id = ?
ORDER BY
  i0_.ingredient_name ASC
LIMIT
  50

SELECT DISTINCT i0_.id AS id_0, i0_.ingredient_name AS ingredient_name_1 FROM ingredients i0_ INNER JOIN function_to_ingredient f2_ ON i0_.id = f2_.ingredient_id INNER JOIN functions f1_ ON f1_.id = f2_.function_id WHERE f1_.id = 14 ORDER BY i0_.ingredient_name ASC LIMIT 50;

SELECT i0_.id AS id_0, i0_.ingredient_name AS ingredient_name_1, i0_.slug AS slug_2, i0_.ingredient_image AS ingredient_image_3, i0_.ingredient_second_name AS ingredient_second_name_4, i0_.is_goodie AS is_goodie_5, i0_.all_functions AS all_functions_6, i0_.ingr_irritancy AS ingr_irritancy_7, i0_.ingr_comedogencity AS ingr_comedogencity_8, i0_.ingr_description AS ingr_description_9, i0_.ingr_cas_1 AS ingr_cas_1_10, i0_.ingr_ec_number_1 AS ingr_ec_number_1_11, i0_.ingr_ec_number_2 AS ingr_ec_number_2_12, i0_.ingr_details AS ingr_details_13, i0_.UPAC_Name AS UPAC_Name_14, i0_.Ph_Eur_Name AS Ph_Eur_Name_15, i0_.Cosmetic_Restrictions AS Cosmetic_Restrictions_16, i0_.Details AS Details_17, i0_.Geeky_Details AS Geeky_Details_18 FROM ingredients i0_ INNER JOIN function_to_ingredient f2_ ON i0_.id = f2_.ingredient_id INNER JOIN functions f1_ ON f1_.id = f2_.function_id WHERE f1_.id = ? AND i0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY i0_.ingredient_name ASC

[
  14
  17068
  17069
  17070
  17071
  17072
  17073
  17074
  17075
  17076
  17077
  17078
  17079
  17080
  17081
  17082
  17083
  17084
  17085
  17086
  17087
  17088
  17089
  17090
  17091
  17092
  17093
  17094
  17095
  17096
  17097
  17098
  17099
  17100
  17101
  17102
  17103
  17104
  17105
  17106
  17107
  17108
  16860
  17109
  17110
  17111
  17112
  17113
  17114
  17115
  17116
]

SELECT
  i0_.id AS id_0,
  i0_.ingredient_name AS ingredient_name_1,
  i0_.slug AS slug_2,
  i0_.ingredient_image AS ingredient_image_3,
  i0_.ingredient_second_name AS ingredient_second_name_4,
  i0_.is_goodie AS is_goodie_5,
  i0_.all_functions AS all_functions_6,
  i0_.ingr_irritancy AS ingr_irritancy_7,
  i0_.ingr_comedogencity AS ingr_comedogencity_8,
  i0_.ingr_description AS ingr_description_9,
  i0_.ingr_cas_1 AS ingr_cas_1_10,
  i0_.ingr_ec_number_1 AS ingr_ec_number_1_11,
  i0_.ingr_ec_number_2 AS ingr_ec_number_2_12,
  i0_.ingr_details AS ingr_details_13,
  i0_.UPAC_Name AS UPAC_Name_14,
  i0_.Ph_Eur_Name AS Ph_Eur_Name_15,
  i0_.Cosmetic_Restrictions AS Cosmetic_Restrictions_16,
  i0_.Details AS Details_17,
  i0_.Geeky_Details AS Geeky_Details_18
FROM
  ingredients i0_
  INNER JOIN function_to_ingredient f2_ ON i0_.id = f2_.ingredient_id
  INNER JOIN functions f1_ ON f1_.id = f2_.function_id
WHERE
  f1_.id = ?
  AND i0_.id IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?
  )
ORDER BY
  i0_.ingredient_name ASC

SELECT i0_.id AS id_0, i0_.ingredient_name AS ingredient_name_1, i0_.slug AS slug_2, i0_.ingredient_image AS ingredient_image_3, i0_.ingredient_second_name AS ingredient_second_name_4, i0_.is_goodie AS is_goodie_5, i0_.all_functions AS all_functions_6, i0_.ingr_irritancy AS ingr_irritancy_7, i0_.ingr_comedogencity AS ingr_comedogencity_8, i0_.ingr_description AS ingr_description_9, i0_.ingr_cas_1 AS ingr_cas_1_10, i0_.ingr_ec_number_1 AS ingr_ec_number_1_11, i0_.ingr_ec_number_2 AS ingr_ec_number_2_12, i0_.ingr_details AS ingr_details_13, i0_.UPAC_Name AS UPAC_Name_14, i0_.Ph_Eur_Name AS Ph_Eur_Name_15, i0_.Cosmetic_Restrictions AS Cosmetic_Restrictions_16, i0_.Details AS Details_17, i0_.Geeky_Details AS Geeky_Details_18 FROM ingredients i0_ INNER JOIN function_to_ingredient f2_ ON i0_.id = f2_.ingredient_id INNER JOIN functions f1_ ON f1_.id = f2_.function_id WHERE f1_.id = 14 AND i0_.id IN (17068, 17069, 17070, 17071, 17072, 17073, 17074, 17075, 17076, 17077, 17078, 17079, 17080, 17081, 17082, 17083, 17084, 17085, 17086, 17087, 17088, 17089, 17090, 17091, 17092, 17093, 17094, 17095, 17096, 17097, 17098, 17099, 17100, 17101, 17102, 17103, 17104, 17105, 17106, 17107, 17108, 16860, 17109, 17110, 17111, 17112, 17113, 17114, 17115, 17116) ORDER BY i0_.ingredient_name ASC;