Symfony Profiler

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

Query Metrics

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_ WHERE i0_.is_goodie IN ('goodie', 'superstar') AND i0_.ingredient_second_name <> ? ORDER BY i0_.id ASC LIMIT 8

[
  ""
]

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_
WHERE
  i0_.is_goodie IN ('goodie', 'superstar')
  AND i0_.ingredient_second_name <> ?
ORDER BY
  i0_.id ASC
LIMIT
  8

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_ WHERE i0_.is_goodie IN ('goodie', 'superstar') AND i0_.ingredient_second_name <> '' ORDER BY i0_.id ASC LIMIT 8;

SELECT f.id, f.function_name, f.slug, f.function_desctiption, f.readable,
                       COUNT(fi.ingredient_id) as ingredient_count
                FROM functions f
                LEFT JOIN function_to_ingredient fi ON fi.function_id = f.id
                WHERE f.readable = 1
                GROUP BY f.id
                ORDER BY f.function_name ASC

[]

SELECT
  f.id,
  f.function_name,
  f.slug,
  f.function_desctiption,
  f.readable,
  COUNT(fi.ingredient_id) as ingredient_count
FROM
  functions f
  LEFT JOIN function_to_ingredient fi ON fi.function_id = f.id
WHERE
  f.readable = 1
GROUP BY
  f.id
ORDER BY
  f.function_name ASC

SELECT f.id, f.function_name, f.slug, f.function_desctiption, f.readable,
                       COUNT(fi.ingredient_id) as ingredient_count
                FROM functions f
                LEFT JOIN function_to_ingredient fi ON fi.function_id = f.id
                WHERE f.readable = 1
                GROUP BY f.id
                ORDER BY f.function_name ASC;

SELECT COUNT(i0_.id) AS sclr_0 FROM ingredients i0_

[]

SELECT
  COUNT(i0_.id) AS sclr_0
FROM
  ingredients i0_

SELECT COUNT(i0_.id) AS sclr_0 FROM ingredients i0_;

SELECT COUNT(p0_.id) AS sclr_0 FROM products p0_

[]

SELECT
  COUNT(p0_.id) AS sclr_0
FROM
  products p0_

SELECT COUNT(p0_.id) AS sclr_0 FROM products p0_;

SELECT COUNT(b0_.id) AS sclr_0 FROM brands b0_

[]

SELECT
  COUNT(b0_.id) AS sclr_0
FROM
  brands b0_

SELECT COUNT(b0_.id) AS sclr_0 FROM brands b0_;

SELECT f0_.id AS id_0, f0_.function_name AS function_name_1, f0_.slug AS slug_2, f0_.function_desctiption AS function_desctiption_3, f0_.readable AS readable_4, f0_.official AS official_5 FROM functions f0_ WHERE f0_.readable = 1 ORDER BY f0_.function_name ASC

[]

SELECT
  f0_.id AS id_0,
  f0_.function_name AS function_name_1,
  f0_.slug AS slug_2,
  f0_.function_desctiption AS function_desctiption_3,
  f0_.readable AS readable_4,
  f0_.official AS official_5
FROM
  functions f0_
WHERE
  f0_.readable = 1
ORDER BY
  f0_.function_name ASC

SELECT f0_.id AS id_0, f0_.function_name AS function_name_1, f0_.slug AS slug_2, f0_.function_desctiption AS function_desctiption_3, f0_.readable AS readable_4, f0_.official AS official_5 FROM functions f0_ WHERE f0_.readable = 1 ORDER BY f0_.function_name ASC;