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

[
  "absorbent-mattifier"
]

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

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

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

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

[
  "function"
  68
  "ru"
]

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

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

[
  68
]

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

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

[
  68
]

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

[
  68
  18773
  17494
  18774
  18258
  18775
  18776
  18051
  18415
  18777
  18523
  18524
  18778
  18779
  16898
  18780
  18781
  17644
  16987
  18782
  17034
  18783
  18784
  17380
  18785
  17783
  18786
  18787
  3800
  17419
  17420
  18788
  18016
  18789
  17623
  17465
  18790
  17383
  18791
  18792
  18793
  18794
  17887
  18795
  18796
  18797
  17298
  18798
  18799
  18800
  17393
]

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 = 68 AND i0_.id IN (18773, 17494, 18774, 18258, 18775, 18776, 18051, 18415, 18777, 18523, 18524, 18778, 18779, 16898, 18780, 18781, 17644, 16987, 18782, 17034, 18783, 18784, 17380, 18785, 17783, 18786, 18787, 3800, 17419, 17420, 18788, 18016, 18789, 17623, 17465, 18790, 17383, 18791, 18792, 18793, 18794, 17887, 18795, 18796, 18797, 17298, 18798, 18799, 18800, 17393) ORDER BY i0_.ingredient_name ASC;