Symfony Profiler

• Request / Response
• Performance
• Validator
• Forms
• Exception
• Logs 14
• Events
• Routing
• Cache
• Translation
• Security
• Twig
• HTTP Client
• Doctrine
• Debug
• Messages
• Emails
• Notifications
• Serializer
• Configuration

Query Metrics

SELECT p.id as id, p.machine_number as machine_number, CONCAT_WS(' ', p.manufacturer, p.manufacture_type) as name, p.description, (SELECT REPLACE(m.url, "https://emuk.de/", "") FROM media m WHERE m.product_id = p.id AND m.type = "PICTURE" LIMIT 1) as thumbnail_url, (SELECT m.description FROM media m WHERE m.product_id = p.id AND m.type = "PICTURE" LIMIT 1) as thumbnail_description FROM product p WHERE p.lang_code = 'en' AND p.is_archived = 0 AND p.highlighted_at IS NOT NULL ORDER BY p.highlighted_at DESC, p.id DESC LIMIT 3

[]

SELECT
  p.id as id,
  p.machine_number as machine_number,
  CONCAT_WS(
    ' ', p.manufacturer, p.manufacture_type
  ) as name,
  p.description,
  (
    SELECT
      REPLACE(m.url, "https://emuk.de/", "")
    FROM
      media m
    WHERE
      m.product_id = p.id
      AND m.type = "PICTURE"
    LIMIT
      1
  ) as thumbnail_url,
  (
    SELECT
      m.description
    FROM
      media m
    WHERE
      m.product_id = p.id
      AND m.type = "PICTURE"
    LIMIT
      1
  ) as thumbnail_description
FROM
  product p
WHERE
  p.lang_code = 'en'
  AND p.is_archived = 0
  AND p.highlighted_at IS NOT NULL
ORDER BY
  p.highlighted_at DESC,
  p.id DESC
LIMIT
  3

SELECT p.id as id, p.machine_number as machine_number, CONCAT_WS(' ', p.manufacturer, p.manufacture_type) as name, p.description, (SELECT REPLACE(m.url, "https://emuk.de/", "") FROM media m WHERE m.product_id = p.id AND m.type = "PICTURE" LIMIT 1) as thumbnail_url, (SELECT m.description FROM media m WHERE m.product_id = p.id AND m.type = "PICTURE" LIMIT 1) as thumbnail_description FROM product p WHERE p.lang_code = 'en' AND p.is_archived = 0 AND p.highlighted_at IS NOT NULL ORDER BY p.highlighted_at DESC, p.id DESC LIMIT 3 ;

SELECT c.slug as slug, c.name, COUNT(c.id) as machineCount, c.is_accessory as isAccessoryOnly FROM product p INNER JOIN sub_category sc ON sc.id = p.sub_category_id INNER JOIN category c ON c.id = sc.category_id WHERE p.lang_code = 'en' AND p.is_archived = 0 AND c.is_top_category = 1 GROUP BY c.id ORDER BY c.name;

[]

SELECT
  c.slug as slug,
  c.name,
  COUNT(c.id) as machineCount,
  c.is_accessory as isAccessoryOnly
FROM
  product p
  INNER JOIN sub_category sc ON sc.id = p.sub_category_id
  INNER JOIN category c ON c.id = sc.category_id
WHERE
  p.lang_code = 'en'
  AND p.is_archived = 0
  AND c.is_top_category = 1
GROUP BY
  c.id
ORDER BY
  c.name;

SELECT c.slug as slug, c.name, COUNT(c.id) as machineCount, c.is_accessory as isAccessoryOnly FROM product p INNER JOIN sub_category sc ON sc.id = p.sub_category_id INNER JOIN category c ON c.id = sc.category_id WHERE p.lang_code = 'en' AND p.is_archived = 0 AND c.is_top_category = 1 GROUP BY c.id ORDER BY c.name;;

SELECT c.slug as slug, c.name, COUNT(c.id) as machineCount, c.is_accessory as isAccessoryOnly FROM product p INNER JOIN sub_category sc ON sc.id = p.sub_category_id INNER JOIN category c ON c.id = sc.category_id WHERE p.lang_code = 'en' AND p.is_archived = 0 AND c.is_top_category = 0 GROUP BY c.id ORDER BY c.name;

[]

SELECT
  c.slug as slug,
  c.name,
  COUNT(c.id) as machineCount,
  c.is_accessory as isAccessoryOnly
FROM
  product p
  INNER JOIN sub_category sc ON sc.id = p.sub_category_id
  INNER JOIN category c ON c.id = sc.category_id
WHERE
  p.lang_code = 'en'
  AND p.is_archived = 0
  AND c.is_top_category = 0
GROUP BY
  c.id
ORDER BY
  c.name;

SELECT c.slug as slug, c.name, COUNT(c.id) as machineCount, c.is_accessory as isAccessoryOnly FROM product p INNER JOIN sub_category sc ON sc.id = p.sub_category_id INNER JOIN category c ON c.id = sc.category_id WHERE p.lang_code = 'en' AND p.is_archived = 0 AND c.is_top_category = 0 GROUP BY c.id ORDER BY c.name;;