Symfony Profiler

SELECT
  p.id as id,
  REPLACE(
    REPLACE(
      TRIM(
        CONCAT_WS(
          ' ', p.manufacturer, p.manufacture_type
        )
      ),
      '''',
      '\u0027'
    ),
    '"',
    '\u0022'
  ) as name,
  p.machine_number as machine_number,
  (
    SELECT
      CONCAT_WS(' / ', c.name, sc.name)
    FROM
      sub_category sc
      INNER JOIN category c ON c.id = sc.category_id
    WHERE
      sc.id = p.sub_category_id
  ) as categoryName,
  (
    SELECT
      c.id
    FROM
      sub_category sc
      INNER JOIN category c ON c.id = sc.category_id
    WHERE
      sc.id = p.sub_category_id
  ) as categoryId,
  p.sub_category_id as subCategoryId,
  IFNULL(p.manufacture_year, 'unknown') as manufacture_year,
  (
    SELECT
      w.location
    FROM
      warehouse w
    WHERE
      w.id = p.warehouse_id
  ) as warehouse_name,
  IFNULL(p.country_of_origin, 'unknown') as country_of_origin,
  p.delivery_time as delivery_time,
  IF(
    p.price = 0,
    'Price on Request',
    CONCAT_WS(' ', p.price, p.currency)
  ) as price,
  (
    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,
  p.is_archived as is_archived,
  p.overview_video_link as videoOnFire,
  p.youtube_codes as youtubeCodes
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 = 'de'
  AND p.sub_category_id IN (
    3, 5, 7, 9, 11, 14, 17, 21, 22, 57, 65, 68,
    70, 72, 73, 80, 82, 83, 86, 87, 88, 91,
    92, 94, 95, 203, 205, 209, 211, 213, 222,
    225, 231, 239, 243, 245, 253, 254, 255,
    261, 263, 267, 285, 286, 293, 299, 305,
    307, 315, 317, 325, 331, 335, 336, 337,
    343, 345, 347, 350, 353, 355, 357
  )
  AND p.is_archived = 0
ORDER BY
  p.id DESC;

SELECT 
                p.id as id,
                REPLACE(REPLACE(TRIM(CONCAT_WS(' ', p.manufacturer, p.manufacture_type)), '''', '\u0027'), '"', '\u0022') as name,
                p.machine_number as machine_number,
                (SELECT CONCAT_WS(' / ', c.name, sc.name) FROM sub_category sc INNER JOIN category c ON c.id = sc.category_id WHERE sc.id = p.sub_category_id) as categoryName,
                (SELECT c.id FROM sub_category sc INNER JOIN category c ON c.id = sc.category_id WHERE sc.id = p.sub_category_id) as categoryId,
                p.sub_category_id as subCategoryId,
                IFNULL(p.manufacture_year, 'unknown') as manufacture_year,
                (SELECT w.location FROM warehouse w WHERE w.id = p.warehouse_id) as warehouse_name,
                IFNULL(p.country_of_origin, 'unknown') as country_of_origin,
                p.delivery_time as delivery_time,
                IF(p.price = 0, 'Price on Request', CONCAT_WS(' ', p.price, p.currency)) as price, 
                (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,
                p.is_archived as is_archived,
                p.overview_video_link as videoOnFire,
                p.youtube_codes as youtubeCodes
            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 = 'de'   AND p.sub_category_id IN (3,5,7,9,11,14,17,21,22,57,65,68,70,72,73,80,82,83,86,87,88,91,92,94,95,203,205,209,211,213,222,225,231,239,243,245,253,254,255,261,263,267,285,286,293,299,305,307,315,317,325,331,335,336,337,343,345,347,350,353,355,357)  AND p.is_archived = 0
            ORDER BY p.id DESC;
        ;

SELECT
  c.name as categoryName,
  c.id as categoryId,
  (
    SELECT
      COUNT(p.id)
    FROM
      sub_category sc
      INNER JOIN product p ON p.sub_category_id = sc.id
      AND p.is_archived = 0
    WHERE
      sc.category_id = c.id
      AND sc.is_accessory = 0
  ) as productCount
FROM
  category c
WHERE
  c.is_accessory = 0
  AND c.lang_code = 'de'
ORDER BY
  categoryName;

SELECT 
                c.name as categoryName, 
                c.id as categoryId, 
                (SELECT COUNT(p.id) FROM sub_category sc INNER JOIN product p ON p.sub_category_id = sc.id AND p.is_archived = 0 WHERE sc.category_id = c.id AND sc.is_accessory = 0) 
                    as productCount FROM category c 
            WHERE c.is_accessory = 0 AND c.lang_code = 'de'
            ORDER BY categoryName;
        ;

SELECT
  c.name as categoryName,
  c.id as categoryId,
  c.slug as categorySlug,
  sc.name as subcategoryName,
  sc.id as subcategoryId,
  (
    SELECT
      COUNT(p.id)
    FROM
      product p
    WHERE
      p.sub_category_id = sc.id
      AND p.is_archived = 0
  ) as productCount
FROM
  sub_category sc
  INNER JOIN category c ON c.id = sc.category_id
WHERE
  sc.lang_code = 'de'
  AND sc.id IN (
    357, 95, 355, 286, 94, 353, 350, 347, 267,
    345, 91, 91, 343, 337, 336, 335, 261,
    254, 254, 331, 92, 254, 92, 92, 92, 94,
    325, 325, 7, 315, 315, 315, 95, 95, 92,
    317, 299, 243, 7, 7, 7, 307, 245, 305,
    305, 305, 305, 299, 72, 293, 92, 92, 65,
    286, 285, 95, 267, 91, 91, 267, 82, 253,
    263, 95, 261, 239, 70, 254, 253, 245,
    243, 239, 95, 92, 255, 22, 22, 22, 22,
    22, 231, 225, 203, 95, 222, 11, 213, 211,
    209, 7, 68, 95, 88, 95, 205, 92, 95, 95,
    95, 91, 91, 88, 88, 88, 87, 86, 83, 83,
    82, 80, 73, 72, 68, 57, 22, 21, 17, 14,
    11, 9, 5, 5, 3
  )
ORDER BY
  categoryName,
  subcategoryName

SELECT 
                c.name as categoryName,
                c.id as categoryId, 
                c.slug as categorySlug,
                sc.name as subcategoryName, 
                sc.id as subcategoryId, 
                (SELECT COUNT(p.id) FROM product p WHERE p.sub_category_id = sc.id   AND p.is_archived = 0) as productCount 
            FROM sub_category sc 
                INNER JOIN category c ON c.id = sc.category_id 
            WHERE sc.lang_code = 'de' AND sc.id IN (357,95,355,286,94,353,350,347,267,345,91,91,343,337,336,335,261,254,254,331,92,254,92,92,92,94,325,325,7,315,315,315,95,95,92,317,299,243,7,7,7,307,245,305,305,305,305,299,72,293,92,92,65,286,285,95,267,91,91,267,82,253,263,95,261,239,70,254,253,245,243,239,95,92,255,22,22,22,22,22,231,225,203,95,222,11,213,211,209,7,68,95,88,95,205,92,95,95,95,91,91,88,88,88,87,86,83,83,82,80,73,72,68,57,22,21,17,14,11,9,5,5,3)
            ORDER BY categoryName, subcategoryName        
        ;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.external_id AS external_id_3,
  t0.code AS code_4,
  t0.post_id AS post_id_5,
  t0.lang_code AS lang_code_6,
  t0.is_top_category AS is_top_category_7,
  t0.is_accessory AS is_accessory_8,
  t0.slug AS slug_9
FROM
  category t0
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.external_id AS external_id_3, t0.code AS code_4, t0.post_id AS post_id_5, t0.lang_code AS lang_code_6, t0.is_top_category AS is_top_category_7, t0.is_accessory AS is_accessory_8, t0.slug AS slug_9 FROM category t0 WHERE t0.slug = 'schweissmaschinen-etc-' LIMIT 1;

SELECT
  sc.id as subCategoryId
FROM
  sub_category sc
WHERE
  sc.category_id IN (
    1, 47, 2, 59, 3, 49, 4, 6, 43, 7, 8, 11, 61,
    13, 17, 14, 55, 15, 16, 63, 45, 19, 20,
    57
  )
  AND sc.is_accessory = 0;

SELECT sc.id as subCategoryId FROM sub_category sc WHERE sc.category_id IN (1,47,2,59,3,49,4,6,43,7,8,11,61,13,17,14,55,15,16,63,45,19,20,57) AND sc.is_accessory = 0;
        ;