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

[
  "astringent"
]

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 = 'astringent' LIMIT 1;

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

[
  "function"
  88
  "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 = 88 AND locale = 'ru';

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

[
  "function"
  88
  "ru"
]

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

SELECT COUNT(*) FROM translations
             WHERE entity_type = 'function' AND entity_id = 88 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 = ?

[
  88
]

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 = 88;

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

[
  88
]

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 = 88 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

[
  88
  18321
  18322
  18323
  18324
  18325
  17082
  17083
  17729
  18326
  18327
  18125
  17085
  18285
  17505
  16834
  18328
  18329
  18330
  18331
  18291
  18332
  17121
  18292
  17122
  18333
  18334
  18335
  18336
  18337
  18338
  18339
  18340
  18341
  18342
  18343
  18344
  18345
  18346
  18347
  17098
  18348
  18349
  18350
  18294
  18351
  18352
  17506
  18353
  18354
  18355
]

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 = 88 AND i0_.id IN (18321, 18322, 18323, 18324, 18325, 17082, 17083, 17729, 18326, 18327, 18125, 17085, 18285, 17505, 16834, 18328, 18329, 18330, 18331, 18291, 18332, 17121, 18292, 17122, 18333, 18334, 18335, 18336, 18337, 18338, 18339, 18340, 18341, 18342, 18343, 18344, 18345, 18346, 18347, 17098, 18348, 18349, 18350, 18294, 18351, 18352, 17506, 18353, 18354, 18355) ORDER BY i0_.ingredient_name ASC;