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.is_archived = 1
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.is_archived = 1
            ORDER BY p.id DESC;
        ;

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 = 1
  ) 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 (
    350,
    350,
    94,
    337,
    92,
    92,
    325,
    94,
    315,
    315,
    94,
    92,
    88,
    11,
    315,
    92,
    11,
    299,
    92,
    91,
    245,
    11,
    95,
    65,
    92,
    92,
    91,
    68,
    92,
    92,
    92,
    92,
    92,
    267,
    95,
    91,
    92,
    11,
    91,
    94,
    92,
    83,
    92,
    7,
    203,
    72,
    95,
    92,
    41,
    41,
    41,
    41,
    41,
    41,
    41,
    22,
    22,
    91,
    222,
    95,
    225,
    42,
    48,
    27,
    27,
    24,
    94,
    92,
    92,
    92,
    11,
    30,
    30,
    72,
    42,
    95,
    43,
    95,
    91,
    91,
    92,
    203,
    24,
    55,
    30,
    30,
    30,
    30,
    30,
    30,
    30,
    30,
    17,
    95,
    95,
    95,
    94,
    94,
    92,
    92,
    92,
    92,
    92,
    92,
    92,
    91,
    91,
    75,
    75,
    75,
    70,
    70,
    65,
    55,
    55,
    55,
    55,
    50,
    50,
    49,
    48,
    48,
    48,
    48,
    48,
    48,
    48,
    48,
    48,
    48,
    48,
    48,
    48,
    48,
    48,
    48,
    48,
    30,
    30,
    46,
    46,
    46,
    46,
    46,
    46,
    46,
    46,
    46,
    43,
    42,
    41,
    41,
    41,
    41,
    41,
    41,
    41,
    41,
    41,
    39,
    38,
    35,
    32,
    32,
    32,
    30,
    30,
    30,
    30,
    30,
    27,
    24,
    24,
    24,
    24,
    24,
    24,
    24,
    24,
    24,
    11,
    7,
    3,
    3,
    3,
    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 = 1) 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 (350,350,94,337,92,92,325,94,315,315,94,92,88,11,315,92,11,299,92,91,245,11,95,65,92,92,91,68,92,92,92,92,92,267,95,91,92,11,91,94,92,83,92,7,203,72,95,92,41,41,41,41,41,41,41,22,22,91,222,95,225,42,48,27,27,24,94,92,92,92,11,30,30,72,42,95,43,95,91,91,92,203,24,55,30,30,30,30,30,30,30,30,17,95,95,95,94,94,92,92,92,92,92,92,92,91,91,75,75,75,70,70,65,55,55,55,55,50,50,49,48,48,48,48,48,48,48,48,48,48,48,48,48,48,48,48,48,30,30,46,46,46,46,46,46,46,46,46,43,42,41,41,41,41,41,41,41,41,41,39,38,35,32,32,32,30,30,30,30,30,27,24,24,24,24,24,24,24,24,24,11,7,3,3,3,3)
            ORDER BY categoryName, subcategoryName        
        ;