Symfony Profiler

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 IS NULL
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 IS NULL LIMIT 1;

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 = 'en'
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 = 'en'
            ORDER BY categoryName;
        ;

SELECT
  sc.id as subCategoryId
FROM
  sub_category sc
WHERE
  sc.category_id IN (
    22, 58, 60, 44, 50, 25, 48, 26, 27, 28, 29,
    30, 31, 34, 62, 35, 64, 38, 39, 40, 41,
    46, 42, 56
  )
  AND sc.is_accessory = 0;

SELECT sc.id as subCategoryId FROM sub_category sc WHERE sc.category_id IN (22,58,60,44,50,25,48,26,27,28,29,30,31,34,62,35,64,38,39,40,41,46,42,56) AND sc.is_accessory = 0;
        ;

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 = 'en'
  AND p.sub_category_id IN (
    104, 105, 106, 110, 113, 116, 117, 118,
    119, 120, 121, 123, 124, 132, 135, 137,
    139, 149, 150, 183, 186, 187, 192, 195,
    197, 204, 206, 210, 212, 214, 224, 226,
    232, 240, 244, 247, 257, 258, 260, 262,
    264, 268, 287, 288, 294, 304, 306, 308,
    318, 319, 326, 332, 338, 339, 340, 344,
    346, 348, 351, 354, 358
  )
  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 = 'en'   AND p.sub_category_id IN (104,105,106,110,113,116,117,118,119,120,121,123,124,132,135,137,139,149,150,183,186,187,192,195,197,204,206,210,212,214,224,226,232,240,244,247,257,258,260,262,264,268,287,288,294,304,306,308,318,319,326,332,338,339,340,344,346,348,351,354,358)  AND p.is_archived = 0
            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 = 0
  ) as productCount
FROM
  sub_category sc
  INNER JOIN category c ON c.id = sc.category_id
WHERE
  sc.lang_code = 'en'
  AND sc.id IN (
    358, 120, 287, 116, 354, 351, 348, 268,
    346, 118, 118, 344, 340, 339, 338, 262,
    260, 260, 332, 119, 260, 135, 116, 119,
    119, 119, 326, 326, 319, 319, 319, 120,
    120, 119, 244, 135, 135, 304, 318, 135,
    308, 247, 306, 306, 306, 306, 304, 105,
    294, 119, 119, 183, 288, 287, 268, 120,
    118, 118, 268, 113, 257, 264, 120, 262,
    240, 260, 104, 257, 247, 244, 240, 120,
    119, 258, 139, 139, 139, 139, 139, 232,
    226, 204, 120, 150, 224, 214, 212, 210,
    135, 186, 120, 121, 206, 120, 119, 197,
    195, 195, 192, 187, 186, 150, 149, 139,
    137, 132, 124, 123, 121, 121, 121, 120,
    120, 120, 118, 118, 117, 113, 110, 110,
    106, 105
  )
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 = 'en' AND sc.id IN (358,120,287,116,354,351,348,268,346,118,118,344,340,339,338,262,260,260,332,119,260,135,116,119,119,119,326,326,319,319,319,120,120,119,244,135,135,304,318,135,308,247,306,306,306,306,304,105,294,119,119,183,288,287,268,120,118,118,268,113,257,264,120,262,240,260,104,257,247,244,240,120,119,258,139,139,139,139,139,232,226,204,120,150,224,214,212,210,135,186,120,121,206,120,119,197,195,195,192,187,186,150,149,139,137,132,124,123,121,121,121,120,120,120,118,118,117,113,110,110,106,105)
            ORDER BY categoryName, subcategoryName        
        ;