Symfony Profiler

• Request / Response
• Performance
• Validator
• Forms
• Exception
• Logs 1
• Events
• Routing
• Cache
• Translation 9
• Security
• Twig
• Twig Components
• HTTP Client
• Doctrine
• Debug
• Messages
• Emails
• Notifications
• Serializer
• MCP 0
• VichUploader
• Configuration

Query Metrics

SELECT t0.id AS id_1, t0.setting_key AS setting_key_2, t0.value AS value_3, t0.updated_at AS updated_at_4 FROM marketplace_setting t0 WHERE t0.setting_key = ? LIMIT 1

[
  "public.locale_definitions"
]

SELECT
  t0.id AS id_1,
  t0.setting_key AS setting_key_2,
  t0.value AS value_3,
  t0.updated_at AS updated_at_4
FROM
  marketplace_setting t0
WHERE
  t0.setting_key = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.setting_key AS setting_key_2, t0.value AS value_3, t0.updated_at AS updated_at_4 FROM marketplace_setting t0 WHERE t0.setting_key = 'public.locale_definitions' LIMIT 1;

SELECT t0.id AS id_1, t0.slug AS slug_2, t0.created_at AS created_at_3, t0.tag_category_id AS tag_category_id_4, t0.parent_id AS parent_id_5 FROM tag t0 WHERE t0.slug = ? LIMIT 1

[
  "japon"
]

SELECT
  t0.id AS id_1,
  t0.slug AS slug_2,
  t0.created_at AS created_at_3,
  t0.tag_category_id AS tag_category_id_4,
  t0.parent_id AS parent_id_5
FROM
  tag t0
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.slug AS slug_2, t0.created_at AS created_at_3, t0.tag_category_id AS tag_category_id_4, t0.parent_id AS parent_id_5 FROM tag t0 WHERE t0.slug = 'japon' LIMIT 1;

SELECT t0.id AS id_1, t0.setting_key AS setting_key_2, t0.value AS value_3, t0.updated_at AS updated_at_4 FROM marketplace_setting t0 WHERE t0.setting_key = ? LIMIT 1

[
  "catalogue_per_page"
]

SELECT
  t0.id AS id_1,
  t0.setting_key AS setting_key_2,
  t0.value AS value_3,
  t0.updated_at AS updated_at_4
FROM
  marketplace_setting t0
WHERE
  t0.setting_key = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.setting_key AS setting_key_2, t0.value AS value_3, t0.updated_at AS updated_at_4 FROM marketplace_setting t0 WHERE t0.setting_key = 'catalogue_per_page' LIMIT 1;

SELECT t0.id AS id_1, t0.slug AS slug_2, t0.created_at AS created_at_3, t0.tag_category_id AS tag_category_id_4, t0.parent_id AS parent_id_5 FROM tag t0 WHERE t0.parent_id = ?

[
  86
]

SELECT
  t0.id AS id_1,
  t0.slug AS slug_2,
  t0.created_at AS created_at_3,
  t0.tag_category_id AS tag_category_id_4,
  t0.parent_id AS parent_id_5
FROM
  tag t0
WHERE
  t0.parent_id = ?

SELECT t0.id AS id_1, t0.slug AS slug_2, t0.created_at AS created_at_3, t0.tag_category_id AS tag_category_id_4, t0.parent_id AS parent_id_5 FROM tag t0 WHERE t0.parent_id = 86;

SELECT p0_.id AS id_0 FROM product p0_ LEFT JOIN seller s1_ ON p0_.seller_id = s1_.id LEFT JOIN seller_profile s2_ ON s1_.id = s2_.seller_id LEFT JOIN seller_address s3_ ON s1_.id = s3_.seller_id LEFT JOIN geo_city g4_ ON s3_.geo_city_id = g4_.id INNER JOIN product_tag p6_ ON p0_.id = p6_.product_id INNER JOIN tag t5_ ON t5_.id = p6_.tag_id WHERE p0_.status IN (?, ?) AND p0_.display = 1 AND t5_.id IN (?) GROUP BY p0_.id ORDER BY CASE WHEN p0_.status = ? THEN 1 ELSE 0 END ASC, p0_.published_at DESC LIMIT 24

[
  "active"
  "sold"
  86
  "sold"
]

SELECT
  p0_.id AS id_0
FROM
  product p0_
  LEFT JOIN seller s1_ ON p0_.seller_id = s1_.id
  LEFT JOIN seller_profile s2_ ON s1_.id = s2_.seller_id
  LEFT JOIN seller_address s3_ ON s1_.id = s3_.seller_id
  LEFT JOIN geo_city g4_ ON s3_.geo_city_id = g4_.id
  INNER JOIN product_tag p6_ ON p0_.id = p6_.product_id
  INNER JOIN tag t5_ ON t5_.id = p6_.tag_id
WHERE
  p0_.status IN (?, ?)
  AND p0_.display = 1
  AND t5_.id IN (?)
GROUP BY
  p0_.id
ORDER BY
  CASE WHEN p0_.status = ? THEN
    1
  ELSE
    0
  END ASC,
  p0_.published_at DESC
LIMIT
  24

SELECT p0_.id AS id_0 FROM product p0_ LEFT JOIN seller s1_ ON p0_.seller_id = s1_.id LEFT JOIN seller_profile s2_ ON s1_.id = s2_.seller_id LEFT JOIN seller_address s3_ ON s1_.id = s3_.seller_id LEFT JOIN geo_city g4_ ON s3_.geo_city_id = g4_.id INNER JOIN product_tag p6_ ON p0_.id = p6_.product_id INNER JOIN tag t5_ ON t5_.id = p6_.tag_id WHERE p0_.status IN ('active', 'sold') AND p0_.display = 1 AND t5_.id IN (86) GROUP BY p0_.id ORDER BY CASE WHEN p0_.status = 'sold' THEN 1 ELSE 0 END ASC, p0_.published_at DESC LIMIT 24;

SELECT COUNT(DISTINCT p0_.id) AS sclr_0 FROM product p0_ LEFT JOIN seller s1_ ON p0_.seller_id = s1_.id LEFT JOIN seller_profile s2_ ON s1_.id = s2_.seller_id LEFT JOIN seller_address s3_ ON s1_.id = s3_.seller_id LEFT JOIN geo_city g4_ ON s3_.geo_city_id = g4_.id INNER JOIN product_tag p6_ ON p0_.id = p6_.product_id INNER JOIN tag t5_ ON t5_.id = p6_.tag_id WHERE p0_.status IN (?, ?) AND p0_.display = 1 AND t5_.id IN (?)

[
  "active"
  "sold"
  86
]

SELECT
  COUNT(DISTINCT p0_.id) AS sclr_0
FROM
  product p0_
  LEFT JOIN seller s1_ ON p0_.seller_id = s1_.id
  LEFT JOIN seller_profile s2_ ON s1_.id = s2_.seller_id
  LEFT JOIN seller_address s3_ ON s1_.id = s3_.seller_id
  LEFT JOIN geo_city g4_ ON s3_.geo_city_id = g4_.id
  INNER JOIN product_tag p6_ ON p0_.id = p6_.product_id
  INNER JOIN tag t5_ ON t5_.id = p6_.tag_id
WHERE
  p0_.status IN (?, ?)
  AND p0_.display = 1
  AND t5_.id IN (?)

SELECT COUNT(DISTINCT p0_.id) AS sclr_0 FROM product p0_ LEFT JOIN seller s1_ ON p0_.seller_id = s1_.id LEFT JOIN seller_profile s2_ ON s1_.id = s2_.seller_id LEFT JOIN seller_address s3_ ON s1_.id = s3_.seller_id LEFT JOIN geo_city g4_ ON s3_.geo_city_id = g4_.id INNER JOIN product_tag p6_ ON p0_.id = p6_.product_id INNER JOIN tag t5_ ON t5_.id = p6_.tag_id WHERE p0_.status IN ('active', 'sold') AND p0_.display = 1 AND t5_.id IN (86);

SELECT s0_.id AS id_0, s0_.tag_slug AS tag_slug_1, s0_.locale AS locale_2, s0_.meta_title AS meta_title_3, s0_.meta_description AS meta_description_4, s0_.intro_html AS intro_html_5, s0_.outro_html AS outro_html_6, s0_.faq_items AS faq_items_7, s0_.is_published AS is_published_8, s0_.created_at AS created_at_9, s0_.updated_at AS updated_at_10 FROM seo_page_content s0_ WHERE s0_.tag_slug = ? AND s0_.locale = ? AND s0_.is_published = 1

[
  "japon"
  "nl"
]

SELECT
  s0_.id AS id_0,
  s0_.tag_slug AS tag_slug_1,
  s0_.locale AS locale_2,
  s0_.meta_title AS meta_title_3,
  s0_.meta_description AS meta_description_4,
  s0_.intro_html AS intro_html_5,
  s0_.outro_html AS outro_html_6,
  s0_.faq_items AS faq_items_7,
  s0_.is_published AS is_published_8,
  s0_.created_at AS created_at_9,
  s0_.updated_at AS updated_at_10
FROM
  seo_page_content s0_
WHERE
  s0_.tag_slug = ?
  AND s0_.locale = ?
  AND s0_.is_published = 1

SELECT s0_.id AS id_0, s0_.tag_slug AS tag_slug_1, s0_.locale AS locale_2, s0_.meta_title AS meta_title_3, s0_.meta_description AS meta_description_4, s0_.intro_html AS intro_html_5, s0_.outro_html AS outro_html_6, s0_.faq_items AS faq_items_7, s0_.is_published AS is_published_8, s0_.created_at AS created_at_9, s0_.updated_at AS updated_at_10 FROM seo_page_content s0_ WHERE s0_.tag_slug = 'japon' AND s0_.locale = 'nl' AND s0_.is_published = 1;

SELECT t0_.id AS id_0, t0_.key_name AS key_name_1, t0_.position AS position_2, t0_.filterable AS filterable_3, t0_.icon AS icon_4, t1_.id AS id_5, t1_.locale AS locale_6, t1_.label AS label_7, t2_.id AS id_8, t2_.slug AS slug_9, t2_.created_at AS created_at_10, t3_.id AS id_11, t3_.locale AS locale_12, t3_.label AS label_13, t3_.auto_translated AS auto_translated_14, t4_.id AS id_15, t4_.slug AS slug_16, t4_.created_at AS created_at_17, t5_.id AS id_18, t5_.locale AS locale_19, t5_.label AS label_20, t5_.auto_translated AS auto_translated_21, t1_.tag_category_id AS tag_category_id_22, t2_.tag_category_id AS tag_category_id_23, t2_.parent_id AS parent_id_24, t3_.tag_id AS tag_id_25, t4_.tag_category_id AS tag_category_id_26, t4_.parent_id AS parent_id_27, t5_.tag_id AS tag_id_28 FROM tag_category t0_ LEFT JOIN tag_category_translation t1_ ON t0_.id = t1_.tag_category_id LEFT JOIN tag t2_ ON t0_.id = t2_.tag_category_id LEFT JOIN tag_translation t3_ ON t2_.id = t3_.tag_id LEFT JOIN tag t4_ ON t2_.id = t4_.parent_id LEFT JOIN tag_translation t5_ ON t4_.id = t5_.tag_id WHERE t0_.filterable = 1 ORDER BY t0_.position ASC, t2_.slug ASC

[]

SELECT
  t0_.id AS id_0,
  t0_.key_name AS key_name_1,
  t0_.position AS position_2,
  t0_.filterable AS filterable_3,
  t0_.icon AS icon_4,
  t1_.id AS id_5,
  t1_.locale AS locale_6,
  t1_.label AS label_7,
  t2_.id AS id_8,
  t2_.slug AS slug_9,
  t2_.created_at AS created_at_10,
  t3_.id AS id_11,
  t3_.locale AS locale_12,
  t3_.label AS label_13,
  t3_.auto_translated AS auto_translated_14,
  t4_.id AS id_15,
  t4_.slug AS slug_16,
  t4_.created_at AS created_at_17,
  t5_.id AS id_18,
  t5_.locale AS locale_19,
  t5_.label AS label_20,
  t5_.auto_translated AS auto_translated_21,
  t1_.tag_category_id AS tag_category_id_22,
  t2_.tag_category_id AS tag_category_id_23,
  t2_.parent_id AS parent_id_24,
  t3_.tag_id AS tag_id_25,
  t4_.tag_category_id AS tag_category_id_26,
  t4_.parent_id AS parent_id_27,
  t5_.tag_id AS tag_id_28
FROM
  tag_category t0_
  LEFT JOIN tag_category_translation t1_ ON t0_.id = t1_.tag_category_id
  LEFT JOIN tag t2_ ON t0_.id = t2_.tag_category_id
  LEFT JOIN tag_translation t3_ ON t2_.id = t3_.tag_id
  LEFT JOIN tag t4_ ON t2_.id = t4_.parent_id
  LEFT JOIN tag_translation t5_ ON t4_.id = t5_.tag_id
WHERE
  t0_.filterable = 1
ORDER BY
  t0_.position ASC,
  t2_.slug ASC

SELECT t0_.id AS id_0, t0_.key_name AS key_name_1, t0_.position AS position_2, t0_.filterable AS filterable_3, t0_.icon AS icon_4, t1_.id AS id_5, t1_.locale AS locale_6, t1_.label AS label_7, t2_.id AS id_8, t2_.slug AS slug_9, t2_.created_at AS created_at_10, t3_.id AS id_11, t3_.locale AS locale_12, t3_.label AS label_13, t3_.auto_translated AS auto_translated_14, t4_.id AS id_15, t4_.slug AS slug_16, t4_.created_at AS created_at_17, t5_.id AS id_18, t5_.locale AS locale_19, t5_.label AS label_20, t5_.auto_translated AS auto_translated_21, t1_.tag_category_id AS tag_category_id_22, t2_.tag_category_id AS tag_category_id_23, t2_.parent_id AS parent_id_24, t3_.tag_id AS tag_id_25, t4_.tag_category_id AS tag_category_id_26, t4_.parent_id AS parent_id_27, t5_.tag_id AS tag_id_28 FROM tag_category t0_ LEFT JOIN tag_category_translation t1_ ON t0_.id = t1_.tag_category_id LEFT JOIN tag t2_ ON t0_.id = t2_.tag_category_id LEFT JOIN tag_translation t3_ ON t2_.id = t3_.tag_id LEFT JOIN tag t4_ ON t2_.id = t4_.parent_id LEFT JOIN tag_translation t5_ ON t4_.id = t5_.tag_id WHERE t0_.filterable = 1 ORDER BY t0_.position ASC, t2_.slug ASC;

SELECT t0.id AS id_1, t0.setting_key AS setting_key_2, t0.value AS value_3, t0.updated_at AS updated_at_4 FROM marketplace_setting t0 WHERE t0.setting_key = ? LIMIT 1

[
  "catalogue_columns"
]

SELECT
  t0.id AS id_1,
  t0.setting_key AS setting_key_2,
  t0.value AS value_3,
  t0.updated_at AS updated_at_4
FROM
  marketplace_setting t0
WHERE
  t0.setting_key = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.setting_key AS setting_key_2, t0.value AS value_3, t0.updated_at AS updated_at_4 FROM marketplace_setting t0 WHERE t0.setting_key = 'catalogue_columns' LIMIT 1;