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.ingredient_name AS ingredient_name_2, t0.slug AS slug_3, t0.ingredient_image AS ingredient_image_4, t0.ingredient_second_name AS ingredient_second_name_5, t0.is_goodie AS is_goodie_6, t0.all_functions AS all_functions_7, t0.ingr_irritancy AS ingr_irritancy_8, t0.ingr_comedogencity AS ingr_comedogencity_9, t0.ingr_description AS ingr_description_10, t0.ingr_cas_1 AS ingr_cas_1_11, t0.ingr_ec_number_1 AS ingr_ec_number_1_12, t0.ingr_ec_number_2 AS ingr_ec_number_2_13, t0.ingr_details AS ingr_details_14, t0.UPAC_Name AS UPAC_Name_15, t0.Ph_Eur_Name AS Ph_Eur_Name_16, t0.Cosmetic_Restrictions AS Cosmetic_Restrictions_17, t0.Details AS Details_18, t0.Geeky_Details AS Geeky_Details_19 FROM ingredients t0 WHERE t0.slug = ? LIMIT 1

[
  "tetrahydrobisdemethoxydiferuloylmethane"
]

SELECT
  t0.id AS id_1,
  t0.ingredient_name AS ingredient_name_2,
  t0.slug AS slug_3,
  t0.ingredient_image AS ingredient_image_4,
  t0.ingredient_second_name AS ingredient_second_name_5,
  t0.is_goodie AS is_goodie_6,
  t0.all_functions AS all_functions_7,
  t0.ingr_irritancy AS ingr_irritancy_8,
  t0.ingr_comedogencity AS ingr_comedogencity_9,
  t0.ingr_description AS ingr_description_10,
  t0.ingr_cas_1 AS ingr_cas_1_11,
  t0.ingr_ec_number_1 AS ingr_ec_number_1_12,
  t0.ingr_ec_number_2 AS ingr_ec_number_2_13,
  t0.ingr_details AS ingr_details_14,
  t0.UPAC_Name AS UPAC_Name_15,
  t0.Ph_Eur_Name AS Ph_Eur_Name_16,
  t0.Cosmetic_Restrictions AS Cosmetic_Restrictions_17,
  t0.Details AS Details_18,
  t0.Geeky_Details AS Geeky_Details_19
FROM
  ingredients t0
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.ingredient_name AS ingredient_name_2, t0.slug AS slug_3, t0.ingredient_image AS ingredient_image_4, t0.ingredient_second_name AS ingredient_second_name_5, t0.is_goodie AS is_goodie_6, t0.all_functions AS all_functions_7, t0.ingr_irritancy AS ingr_irritancy_8, t0.ingr_comedogencity AS ingr_comedogencity_9, t0.ingr_description AS ingr_description_10, t0.ingr_cas_1 AS ingr_cas_1_11, t0.ingr_ec_number_1 AS ingr_ec_number_1_12, t0.ingr_ec_number_2 AS ingr_ec_number_2_13, t0.ingr_details AS ingr_details_14, t0.UPAC_Name AS UPAC_Name_15, t0.Ph_Eur_Name AS Ph_Eur_Name_16, t0.Cosmetic_Restrictions AS Cosmetic_Restrictions_17, t0.Details AS Details_18, t0.Geeky_Details AS Geeky_Details_19 FROM ingredients t0 WHERE t0.slug = 'tetrahydrobisdemethoxydiferuloylmethane' LIMIT 1;

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

[
  "ingredient"
  625
  "ru"
]

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

SELECT field_name, content FROM translations
             WHERE entity_type = 'ingredient' AND entity_id = 625 AND locale = 'ru';

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

[
  "ingredient"
  625
  "ru"
]

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

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

SELECT p.id, p.product_name, p.slug, b.brand_name, b.slug as brand_slug
                FROM ingredient_list il
                JOIN products p ON p.id = il.product_id
                LEFT JOIN brands b ON b.id = p.brand_id
                WHERE il.ingredient_id = :id
                LIMIT :limit

[
  "id" => 625
  "limit" => 12
]

SELECT
  p.id,
  p.product_name,
  p.slug,
  b.brand_name,
  b.slug as brand_slug
FROM
  ingredient_list il
  JOIN products p ON p.id = il.product_id
  LEFT JOIN brands b ON b.id = p.brand_id
WHERE
  il.ingredient_id = :id
LIMIT
  :limit

SELECT p.id, p.product_name, p.slug, b.brand_name, b.slug as brand_slug
                FROM ingredient_list il
                JOIN products p ON p.id = il.product_id
                LEFT JOIN brands b ON b.id = p.brand_id
                WHERE il.ingredient_id = 625
                LIMIT 12;

SELECT COUNT(*) FROM ingredient_list WHERE ingredient_id = ?

[
  625
]

SELECT
  COUNT(*)
FROM
  ingredient_list
WHERE
  ingredient_id = ?

SELECT COUNT(*) FROM ingredient_list WHERE ingredient_id = 625;

SELECT t0.id AS id_1, t0.fact_title AS fact_title_2, t0.lang_id AS lang_id_3, t0.ing_id AS ing_id_4 FROM Quick_Facts t0 WHERE t0.ing_id = ?

[
  625
]

SELECT
  t0.id AS id_1,
  t0.fact_title AS fact_title_2,
  t0.lang_id AS lang_id_3,
  t0.ing_id AS ing_id_4
FROM
  Quick_Facts t0
WHERE
  t0.ing_id = ?

SELECT t0.id AS id_1, t0.fact_title AS fact_title_2, t0.lang_id AS lang_id_3, t0.ing_id AS ing_id_4 FROM Quick_Facts t0 WHERE t0.ing_id = 625;

SELECT t0.id AS id_1, t0.opinion_title AS opinion_title_2, t0.opinion_url AS opinion_url_3, t0.ing_id AS ing_id_4 FROM SCCS_Opinions t0 WHERE t0.ing_id = ?

[
  625
]

SELECT
  t0.id AS id_1,
  t0.opinion_title AS opinion_title_2,
  t0.opinion_url AS opinion_url_3,
  t0.ing_id AS ing_id_4
FROM
  SCCS_Opinions t0
WHERE
  t0.ing_id = ?

SELECT t0.id AS id_1, t0.opinion_title AS opinion_title_2, t0.opinion_url AS opinion_url_3, t0.ing_id AS ing_id_4 FROM SCCS_Opinions t0 WHERE t0.ing_id = 625;

SELECT t0.ing_name AS ing_name_1, t0.ing_id AS ing_id_2 FROM ingredients_aka t0 WHERE t0.ing_id = ?

[
  625
]

SELECT
  t0.ing_name AS ing_name_1,
  t0.ing_id AS ing_id_2
FROM
  ingredients_aka t0
WHERE
  t0.ing_id = ?

SELECT t0.ing_name AS ing_name_1, t0.ing_id AS ing_id_2 FROM ingredients_aka t0 WHERE t0.ing_id = 625;