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

[
  "anti-acne"
]

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

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

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

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

[
  "function"
  186
  "ru"
]

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

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

[
  186
]

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

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

[
  186
]

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

[
  186
  18688
  18359
  16981
  16982
  18305
  16995
  17309
  16921
  18801
  17541
  17751
  17693
  16832
  16854
  18802
  17431
  17255
]

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 = 186 AND i0_.id IN (18688, 18359, 16981, 16982, 18305, 16995, 17309, 16921, 18801, 17541, 17751, 17693, 16832, 16854, 18802, 17431, 17255) ORDER BY i0_.ingredient_name ASC;