Symfony Profiler

• Request / Response
• API Platform
• Performance
• Validator
• Forms
• Exception
• Logs 1294
• Events
• Routing
• Cache
• Translation
• Security
• Twig
• Twig Components
• HTTP Client
• Doctrine 1
• Debug
• Messages
• Emails
• Notifications
• Serializer
• EasyAdmin
• Mercure
• Configuration

Query Metrics

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.address AS address_4, t5.id AS id_6, t5.text AS text_7, t5.link AS link_8, t5.text_color AS text_color_9, t5.bg_color AS bg_color_10, t5.display AS display_11, t5.start_at AS start_at_12, t5.end_at AS end_at_13, t5.shop_id AS shop_id_14 FROM shop t0 LEFT JOIN banner t5 ON t5.shop_id = t0.id WHERE t0.id = ?

[
  "1"
]

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.address AS address_4,
  t5.id AS id_6,
  t5.text AS text_7,
  t5.link AS link_8,
  t5.text_color AS text_color_9,
  t5.bg_color AS bg_color_10,
  t5.display AS display_11,
  t5.start_at AS start_at_12,
  t5.end_at AS end_at_13,
  t5.shop_id AS shop_id_14
FROM
  shop t0
  LEFT JOIN banner t5 ON t5.shop_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.address AS address_4, t5.id AS id_6, t5.text AS text_7, t5.link AS link_8, t5.text_color AS text_color_9, t5.bg_color AS bg_color_10, t5.display AS display_11, t5.start_at AS start_at_12, t5.end_at AS end_at_13, t5.shop_id AS shop_id_14 FROM shop t0 LEFT JOIN banner t5 ON t5.shop_id = t0.id WHERE t0.id = '1';

SELECT p0_.id AS id_0 FROM product p0_ INNER JOIN shop_product s2_ ON p0_.id = s2_.product_id INNER JOIN shop s1_ ON s1_.id = s2_.shop_id WHERE s1_.id = ? AND p0_.new = 1 ORDER BY p0_.id ASC LIMIT 6

[
  1
]

SELECT
  p0_.id AS id_0
FROM
  product p0_
  INNER JOIN shop_product s2_ ON p0_.id = s2_.product_id
  INNER JOIN shop s1_ ON s1_.id = s2_.shop_id
WHERE
  s1_.id = ?
  AND p0_.new = 1
ORDER BY
  p0_.id ASC
LIMIT
  6

SELECT p0_.id AS id_0 FROM product p0_ INNER JOIN shop_product s2_ ON p0_.id = s2_.product_id INNER JOIN shop s1_ ON s1_.id = s2_.shop_id WHERE s1_.id = 1 AND p0_.new = 1 ORDER BY p0_.id ASC LIMIT 6;

SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.slug AS slug_2, p0_.description AS description_3, p0_.short_description AS short_description_4, p0_.price AS price_5, p0_.is_gift_card AS is_gift_card_6, p0_.is_only_for_seo AS is_only_for_seo_7, p0_.visible AS visible_8, p0_.new AS new_9, p0_.featured AS featured_10, p0_.sku AS sku_11, p0_.meta_title AS meta_title_12, p0_.meta_description AS meta_description_13, p0_.meta_robots AS meta_robots_14, p0_.url_path AS url_path_15, p0_.buying_price AS buying_price_16, p0_.vat_rate AS vat_rate_17, p0_.weight AS weight_18, p0_.width AS width_19, p0_.height AS height_20, p0_.additional_shipping_costs AS additional_shipping_costs_21, p0_.inventory AS inventory_22, p0_.data AS data_23, p0_.created_at AS created_at_24, p0_.updated_at AS updated_at_25, p1_.id AS id_26, p1_.ordering AS ordering_27, p1_.product_id AS product_id_28, p1_.media_id AS media_id_29 FROM product p0_ LEFT JOIN product_media p1_ ON p0_.id = p1_.product_id WHERE p0_.id IN (?, ?, ?, ?, ?, ?) ORDER BY p0_.id ASC, p1_.ordering ASC

[
  142
  606
  607
  650
  652
  653
]

SELECT
  p0_.id AS id_0,
  p0_.name AS name_1,
  p0_.slug AS slug_2,
  p0_.description AS description_3,
  p0_.short_description AS short_description_4,
  p0_.price AS price_5,
  p0_.is_gift_card AS is_gift_card_6,
  p0_.is_only_for_seo AS is_only_for_seo_7,
  p0_.visible AS visible_8,
  p0_.new AS new_9,
  p0_.featured AS featured_10,
  p0_.sku AS sku_11,
  p0_.meta_title AS meta_title_12,
  p0_.meta_description AS meta_description_13,
  p0_.meta_robots AS meta_robots_14,
  p0_.url_path AS url_path_15,
  p0_.buying_price AS buying_price_16,
  p0_.vat_rate AS vat_rate_17,
  p0_.weight AS weight_18,
  p0_.width AS width_19,
  p0_.height AS height_20,
  p0_.additional_shipping_costs AS additional_shipping_costs_21,
  p0_.inventory AS inventory_22,
  p0_.data AS data_23,
  p0_.created_at AS created_at_24,
  p0_.updated_at AS updated_at_25,
  p1_.id AS id_26,
  p1_.ordering AS ordering_27,
  p1_.product_id AS product_id_28,
  p1_.media_id AS media_id_29
FROM
  product p0_
  LEFT JOIN product_media p1_ ON p0_.id = p1_.product_id
WHERE
  p0_.id IN (?, ?, ?, ?, ?, ?)
ORDER BY
  p0_.id ASC,
  p1_.ordering ASC

SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.slug AS slug_2, p0_.description AS description_3, p0_.short_description AS short_description_4, p0_.price AS price_5, p0_.is_gift_card AS is_gift_card_6, p0_.is_only_for_seo AS is_only_for_seo_7, p0_.visible AS visible_8, p0_.new AS new_9, p0_.featured AS featured_10, p0_.sku AS sku_11, p0_.meta_title AS meta_title_12, p0_.meta_description AS meta_description_13, p0_.meta_robots AS meta_robots_14, p0_.url_path AS url_path_15, p0_.buying_price AS buying_price_16, p0_.vat_rate AS vat_rate_17, p0_.weight AS weight_18, p0_.width AS width_19, p0_.height AS height_20, p0_.additional_shipping_costs AS additional_shipping_costs_21, p0_.inventory AS inventory_22, p0_.data AS data_23, p0_.created_at AS created_at_24, p0_.updated_at AS updated_at_25, p1_.id AS id_26, p1_.ordering AS ordering_27, p1_.product_id AS product_id_28, p1_.media_id AS media_id_29 FROM product p0_ LEFT JOIN product_media p1_ ON p0_.id = p1_.product_id WHERE p0_.id IN (142, 606, 607, 650, 652, 653) ORDER BY p0_.id ASC, p1_.ordering ASC;

SELECT COUNT(DISTINCT p0_.id) AS sclr_0 FROM product p0_ INNER JOIN shop_product s2_ ON p0_.id = s2_.product_id INNER JOIN shop s1_ ON s1_.id = s2_.shop_id WHERE s1_.id = ? AND p0_.new = 1

[
  1
]

SELECT
  COUNT(DISTINCT p0_.id) AS sclr_0
FROM
  product p0_
  INNER JOIN shop_product s2_ ON p0_.id = s2_.product_id
  INNER JOIN shop s1_ ON s1_.id = s2_.shop_id
WHERE
  s1_.id = ?
  AND p0_.new = 1

SELECT COUNT(DISTINCT p0_.id) AS sclr_0 FROM product p0_ INNER JOIN shop_product s2_ ON p0_.id = s2_.product_id INNER JOIN shop s1_ ON s1_.id = s2_.shop_id WHERE s1_.id = 1 AND p0_.new = 1;

SELECT t0.id AS id_1, t0.name AS name_2, t0.original_name AS original_name_3, t0.shop_id AS shop_id_4 FROM media t0 WHERE t0.id = ?

[
  239
]

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.original_name AS original_name_3,
  t0.shop_id AS shop_id_4
FROM
  media t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.original_name AS original_name_3, t0.shop_id AS shop_id_4 FROM media t0 WHERE t0.id = 239;

SELECT t0.id AS id_1, t0.name AS name_2, t0.original_name AS original_name_3, t0.shop_id AS shop_id_4 FROM media t0 WHERE t0.id = ?

[
  926384
]

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.original_name AS original_name_3,
  t0.shop_id AS shop_id_4
FROM
  media t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.original_name AS original_name_3, t0.shop_id AS shop_id_4 FROM media t0 WHERE t0.id = 926384;

SELECT t0.id AS id_1, t0.name AS name_2, t0.original_name AS original_name_3, t0.shop_id AS shop_id_4 FROM media t0 WHERE t0.id = ?

[
  1183800
]

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.original_name AS original_name_3,
  t0.shop_id AS shop_id_4
FROM
  media t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.original_name AS original_name_3, t0.shop_id AS shop_id_4 FROM media t0 WHERE t0.id = 1183800;

SELECT t0.id AS id_1, t0.name AS name_2, t0.original_name AS original_name_3, t0.shop_id AS shop_id_4 FROM media t0 WHERE t0.id = ?

[
  1194015
]

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.original_name AS original_name_3,
  t0.shop_id AS shop_id_4
FROM
  media t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.original_name AS original_name_3, t0.shop_id AS shop_id_4 FROM media t0 WHERE t0.id = 1194015;

SELECT t0.id AS id_1, t0.name AS name_2, t0.original_name AS original_name_3, t0.shop_id AS shop_id_4 FROM media t0 WHERE t0.id = ?

[
  1194020
]

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.original_name AS original_name_3,
  t0.shop_id AS shop_id_4
FROM
  media t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.original_name AS original_name_3, t0.shop_id AS shop_id_4 FROM media t0 WHERE t0.id = 1194020;

SELECT t0.id AS id_1, t0.name AS name_2, t0.original_name AS original_name_3, t0.shop_id AS shop_id_4 FROM media t0 WHERE t0.id = ?

[
  1194023
]

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.original_name AS original_name_3,
  t0.shop_id AS shop_id_4
FROM
  media t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.original_name AS original_name_3, t0.shop_id AS shop_id_4 FROM media t0 WHERE t0.id = 1194023;