Symfony Profiler

SELECT
  (c0_.id) AS sclr_0,
  (c0_.name) AS sclr_1,
  (c0_.parent_id) AS sclr_2,
  (c0_.products_number) AS sclr_3,
  (c0_.slug) AS sclr_4,
  (c0_.sort) AS sclr_5,
  (c0_.icon) AS sclr_6,
  (c0_.image) AS sclr_7
FROM
  category c0_
WHERE
  c0_.visible = 1
ORDER BY
  c0_.sort ASC

SELECT (c0_.id) AS sclr_0, (c0_.name) AS sclr_1, (c0_.parent_id) AS sclr_2, (c0_.products_number) AS sclr_3, (c0_.slug) AS sclr_4, (c0_.sort) AS sclr_5, (c0_.icon) AS sclr_6, (c0_.image) AS sclr_7 FROM category c0_ WHERE c0_.visible = 1 ORDER BY c0_.sort ASC;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.postal_code AS postal_code_3,
  t0.kladr AS kladr_4,
  t0.fias AS fias_5,
  t0.oktmo AS oktmo_6,
  t0.time_zone AS time_zone_7,
  t0.latitude AS latitude_8,
  t0.longitude AS longitude_9,
  t0.population AS population_10,
  t0.full_address AS full_address_11,
  t0.okato AS okato_12,
  t0.country AS country_13,
  t0.region_id AS region_id_14,
  t0.delivery_zone_id AS delivery_zone_id_15
FROM
  city t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.postal_code AS postal_code_3, t0.kladr AS kladr_4, t0.fias AS fias_5, t0.oktmo AS oktmo_6, t0.time_zone AS time_zone_7, t0.latitude AS latitude_8, t0.longitude AS longitude_9, t0.population AS population_10, t0.full_address AS full_address_11, t0.okato AS okato_12, t0.country AS country_13, t0.region_id AS region_id_14, t0.delivery_zone_id AS delivery_zone_id_15 FROM city t0 WHERE t0.id = 1;

SELECT
  p0_.id AS id_0,
  p0_.is_active AS is_active_1,
  p0_.date_from AS date_from_2,
  p0_.date_to AS date_to_3,
  p0_.name AS name_4,
  p0_.config AS config_5,
  p0_.type AS type_6,
  p0_.product_label_id AS product_label_id_7
FROM
  promotion p0_
WHERE
  (
    p0_.is_active = 1
    AND p0_.date_to >= ?
    AND p0_.date_from <= ?
  )
  AND p0_.type IN (
    'profit_set', 'registered_customer',
    'even_less_price', 'discount_on_products'
  )

SELECT p0_.id AS id_0, p0_.is_active AS is_active_1, p0_.date_from AS date_from_2, p0_.date_to AS date_to_3, p0_.name AS name_4, p0_.config AS config_5, p0_.type AS type_6, p0_.product_label_id AS product_label_id_7 FROM promotion p0_ WHERE (p0_.is_active = 1 AND p0_.date_to >= '2026-02-04 08:09:51' AND p0_.date_from <= '2026-02-04 08:09:51') AND p0_.type IN ('profit_set', 'registered_customer', 'even_less_price', 'discount_on_products');

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.created_at AS created_at_4,
  t0.updated_at AS updated_at_5,
  t0.conditions AS conditions_6,
  t0.visible AS visible_7,
  t0.short_name AS short_name_8,
  t0.image AS image_9,
  t0.filter_properties AS filter_properties_10,
  t0.products_count AS products_count_11,
  t0.content_id AS content_id_12
FROM
  virtual_category t0
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.conditions AS conditions_6, t0.visible AS visible_7, t0.short_name AS short_name_8, t0.image AS image_9, t0.filter_properties AS filter_properties_10, t0.products_count AS products_count_11, t0.content_id AS content_id_12 FROM virtual_category t0 WHERE t0.slug = 'svezhie-aromaty' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.meta_title AS meta_title_2,
  t0.meta_description AS meta_description_3,
  t0.h1 AS h1_4,
  t0.top_banner_img AS top_banner_img_5,
  t0.seo_text_top AS seo_text_top_6,
  t0.seo_text_bottom AS seo_text_bottom_7,
  t0.created_at AS created_at_8,
  t0.updated_at AS updated_at_9,
  t0.top_banner_img_mobile AS top_banner_img_mobile_10,
  t0.top_banner_url AS top_banner_url_11
FROM
  products_list_content t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.meta_title AS meta_title_2, t0.meta_description AS meta_description_3, t0.h1 AS h1_4, t0.top_banner_img AS top_banner_img_5, t0.seo_text_top AS seo_text_top_6, t0.seo_text_bottom AS seo_text_bottom_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.top_banner_img_mobile AS top_banner_img_mobile_10, t0.top_banner_url AS top_banner_url_11 FROM products_list_content t0 WHERE t0.id = 381;

SELECT
  t0.id AS id_1,
  t0.object AS object_2,
  t0.title AS title_3,
  t0.description AS description_4,
  t0.h1 AS h1_5,
  t0.keywords AS keywords_6,
  t0.title_pagination AS title_pagination_7,
  t0.description_pagination AS description_pagination_8,
  t0.h1_pagination AS h1_pagination_9,
  t0.keywords_pagination AS keywords_pagination_10
FROM
  seo_template t0
WHERE
  t0.object = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.object AS object_2, t0.title AS title_3, t0.description AS description_4, t0.h1 AS h1_5, t0.keywords AS keywords_6, t0.title_pagination AS title_pagination_7, t0.description_pagination AS description_pagination_8, t0.h1_pagination AS h1_pagination_9, t0.keywords_pagination AS keywords_pagination_10 FROM seo_template t0 WHERE t0.object = 'virtual_category' LIMIT 1;

SELECT
  p0_.id AS id_0
FROM
  product p0_
WHERE
  p0_.visible = 1
  AND p0_.id IN (
    '34367', '34431', '34428', '34424',
    '34421', '34420', '34418', '34374',
    '34362', '34361', '34356', '34350',
    '33943', '33249', '32806', '29233',
    '29163', '33368', '32803', '28010',
    '29170', '29168', '29175', '14772',
    '8665', '8688', '9902', '22324', '23078',
    '23059', '22322', '22318', '22324',
    '19510', '8769', '8814', '8768', '8823',
    '8766', '22322', '38919', '31244',
    '32806', '32803', '33249', '34350',
    '34421', '36915', '38389', '38919',
    '40821', '40820', '40807', '40804',
    '40803', '40802', '40794', '40833',
    '40828', '41726', '41722', '41607',
    '41158', '41156', '41144'
  )

SELECT p0_.id AS id_0 FROM product p0_ WHERE p0_.visible = 1 AND p0_.id IN ('34367', '34431', '34428', '34424', '34421', '34420', '34418', '34374', '34362', '34361', '34356', '34350', '33943', '33249', '32806', '29233', '29163', '33368', '32803', '28010', '29170', '29168', '29175', '14772', '8665', '8688', '9902', '22324', '23078', '23059', '22322', '22318', '22324', '19510', '8769', '8814', '8768', '8823', '8766', '22322', '38919', '31244', '32806', '32803', '33249', '34350', '34421', '36915', '38389', '38919', '40821', '40820', '40807', '40804', '40803', '40802', '40794', '40833', '40828', '41726', '41722', '41607', '41158', '41156', '41144');

SELECT
  p0_.id AS id_0
FROM
  product p0_
WHERE
  p0_.visible = 1
  AND p0_.id IN (
    33249, 34350, 34421, 36915, 38389, 38919,
    40794, 40803, 40804, 40807, 40820,
    40821, 40828, 40833, 41144, 41156,
    41158, 41607, 41722, 41726
  )
ORDER BY
  p0_.is_hit DESC

SELECT p0_.id AS id_0 FROM product p0_ WHERE p0_.visible = 1 AND p0_.id IN (33249, 34350, 34421, 36915, 38389, 38919, 40794, 40803, 40804, 40807, 40820, 40821, 40828, 40833, 41144, 41156, 41158, 41607, 41722, 41726) ORDER BY p0_.is_hit DESC;

SELECT
  MIN(p0_.price) AS sclr_0,
  MAX(p0_.price) AS sclr_1
FROM
  product p0_
WHERE
  p0_.visible = 1
  AND p0_.id IN (
    33249, 34350, 34421, 36915, 38389, 38919,
    40794, 40803, 40804, 40807, 40820,
    40821, 40828, 40833, 41144, 41156,
    41158, 41607, 41722, 41726
  )
ORDER BY
  p0_.is_hit DESC

SELECT MIN(p0_.price) AS sclr_0, MAX(p0_.price) AS sclr_1 FROM product p0_ WHERE p0_.visible = 1 AND p0_.id IN (33249, 34350, 34421, 36915, 38389, 38919, 40794, 40803, 40804, 40807, 40820, 40821, 40828, 40833, 41144, 41156, 41158, 41607, 41722, 41726) ORDER BY p0_.is_hit DESC;

SELECT
  p0_.property_id AS sclr_0,
  p0_.value_id AS sclr_1,
  p1_.id AS id_2
FROM
  product p1_
  INNER JOIN product_property p0_ ON p1_.id = p0_.product_id
WHERE
  p1_.id IN (
    0, 40820, 34350, 40833, 40807, 38389,
    40804, 41144, 41156, 41158, 41607,
    41722, 40828, 40821, 33249, 40803,
    40794, 38919, 36915, 34421, 41726
  )

SELECT p0_.property_id AS sclr_0, p0_.value_id AS sclr_1, p1_.id AS id_2 FROM product p1_ INNER JOIN product_property p0_ ON p1_.id = p0_.product_id WHERE p1_.id IN (0, 40820, 34350, 40833, 40807, 38389, 40804, 41144, 41156, 41158, 41607, 41722, 40828, 40821, 33249, 40803, 40794, 38919, 36915, 34421, 41726);

SELECT
  p0_.id AS id_0,
  c1_.id AS id_1
FROM
  product p0_
  INNER JOIN category_1c c2_ ON p0_.category1c_id = c2_.id
  INNER JOIN category_category1c c3_ ON c2_.id = c3_.category1c_id
  INNER JOIN category c1_ ON c1_.id = c3_.category_id
WHERE
  p0_.id IN (
    0, 40820, 34350, 40833, 40807, 38389,
    40804, 41144, 41156, 41158, 41607,
    41722, 40828, 40821, 33249, 40803,
    40794, 38919, 36915, 34421, 41726
  )

SELECT p0_.id AS id_0, c1_.id AS id_1 FROM product p0_ INNER JOIN category_1c c2_ ON p0_.category1c_id = c2_.id INNER JOIN category_category1c c3_ ON c2_.id = c3_.category1c_id INNER JOIN category c1_ ON c1_.id = c3_.category_id WHERE p0_.id IN (0, 40820, 34350, 40833, 40807, 38389, 40804, 41144, 41156, 41158, 41607, 41722, 40828, 40821, 33249, 40803, 40794, 38919, 36915, 34421, 41726);

SELECT
  p0_.id AS id_0,
  p0_.alias AS alias_1,
  p0_.title AS title_2,
  p0_.values_sort AS values_sort_3
FROM
  property p0_
WHERE
  p0_.in_filter = 1

SELECT p0_.id AS id_0, p0_.alias AS alias_1, p0_.title AS title_2, p0_.values_sort AS values_sort_3 FROM property p0_ WHERE p0_.in_filter = 1;

SELECT
  p0_.id AS id_0,
  p0_.title AS title_1
FROM
  property_value p0_
WHERE
  p0_.id IN (
    3628598, 4984, 2816, 3845920, 3846256,
    8, 4064, 4985, 3841927, 2828, 3949,
    4232, 3846255, 3839561, 3840317, 3841919,
    3843806, 3845745, 3839701, 3841219,
    3841883, 3841926, 3843812, 3844641,
    3844807, 3845872, 3845883, 3845884,
    3845887, 3845900, 3845901, 3845908,
    3845913, 3846285, 3846439, 3846441,
    3846228, 3846257, 3846261, 229, 855,
    193, 4689, 2061, 4991, 3918, 989, 1198,
    1740122, 3844479, 1797, 811, 1487,
    3837743, 5145, 7581, 163, 573735, 4987,
    1137, 347, 256, 131, 290, 4052, 1899751,
    5969, 185, 114, 257, 17, 3251, 2313,
    82, 152, 165, 261, 3840994, 3840323,
    3840246, 3840275, 3842043, 3843462,
    3839250, 3840003, 3842230, 3842255,
    3840736, 154, 19, 332, 1045, 330, 16,
    1160, 67, 619, 604, 99, 519, 31, 3583345,
    13, 0
  )

SELECT p0_.id AS id_0, p0_.title AS title_1 FROM property_value p0_ WHERE p0_.id IN (3628598, 4984, 2816, 3845920, 3846256, 8, 4064, 4985, 3841927, 2828, 3949, 4232, 3846255, 3839561, 3840317, 3841919, 3843806, 3845745, 3839701, 3841219, 3841883, 3841926, 3843812, 3844641, 3844807, 3845872, 3845883, 3845884, 3845887, 3845900, 3845901, 3845908, 3845913, 3846285, 3846439, 3846441, 3846228, 3846257, 3846261, 229, 855, 193, 4689, 2061, 4991, 3918, 989, 1198, 1740122, 3844479, 1797, 811, 1487, 3837743, 5145, 7581, 163, 573735, 4987, 1137, 347, 256, 131, 290, 4052, 1899751, 5969, 185, 114, 257, 17, 3251, 2313, 82, 152, 165, 261, 3840994, 3840323, 3840246, 3840275, 3842043, 3843462, 3839250, 3840003, 3842230, 3842255, 3840736, 154, 19, 332, 1045, 330, 16, 1160, 67, 619, 604, 99, 519, 31, 3583345, 13, 0);

SELECT
  p0_.property_id AS sclr_0,
  p0_.value_id AS sclr_1,
  p0_.product_id AS sclr_2
FROM
  product_property p0_
WHERE
  p0_.product_id IN (
    0, 40820, 34350, 40833, 40807, 38389,
    40804, 41144, 41156, 41158, 41607,
    41722, 40828, 40821, 33249, 40803,
    40794, 38919, 36915, 34421, 41726
  )

SELECT p0_.property_id AS sclr_0, p0_.value_id AS sclr_1, p0_.product_id AS sclr_2 FROM product_property p0_ WHERE p0_.product_id IN (0, 40820, 34350, 40833, 40807, 38389, 40804, 41144, 41156, 41158, 41607, 41722, 40828, 40821, 33249, 40803, 40794, 38919, 36915, 34421, 41726);

SELECT
  p0_.id AS id_0,
  b1_.image AS image_1
FROM
  property_value p0_
  INNER JOIN brand b1_ ON (b1_.uid = p0_.uid)
WHERE
  p0_.id IN (
    3845745, 3839701, 3839561, 3840317,
    3841919, 3843806
  )

SELECT p0_.id AS id_0, b1_.image AS image_1 FROM property_value p0_ INNER JOIN brand b1_ ON (b1_.uid = p0_.uid) WHERE p0_.id IN (3845745, 3839701, 3839561, 3840317, 3841919, 3843806);

SELECT
  COUNT(*) AS dctrn_count
FROM
  (
    SELECT
      DISTINCT id_0
    FROM
      (
        SELECT
          p0_.id AS id_0,
          p0_.visible AS visible_1,
          p0_.name AS name_2,
          p0_.sku AS sku_3,
          p0_.description AS description_4,
          p0_.main_image AS main_image_5,
          p0_.uid AS uid_6,
          p0_.characteristic AS characteristic_7,
          p0_.created_at AS created_at_8,
          p0_.updated_at AS updated_at_9,
          p0_.created_at_in1_c AS created_at_in1_c_10,
          p0_.price AS price_11,
          p0_.old_price AS old_price_12,
          p0_.bonus AS bonus_13,
          p0_.slug AS slug_14,
          p0_.images AS images_15,
          p0_.number_of_orders AS number_of_orders_16,
          p0_.is_new AS is_new_17,
          p0_.is_hit AS is_hit_18,
          p0_.is_gift AS is_gift_19,
          p0_.is_new_year AS is_new_year_20,
          p0_.full_title AS full_title_21,
          p0_.discount_percent AS discount_percent_22,
          p0_.balance_store AS balance_store_23,
          p0_.balance_warehouse AS balance_warehouse_24,
          p0_.old_slug AS old_slug_25,
          p0_.viewed AS viewed_26,
          p0_.code1c AS code1c_27,
          p0_.data AS data_28,
          p0_.on_demand AS on_demand_29,
          p0_.hash AS hash_30,
          p0_.reviews_number AS reviews_number_31,
          p0_.reviews_avg_score AS reviews_avg_score_32,
          p0_.group_uid AS group_uid_33,
          p0_.is_little_remains AS is_little_remains_34,
          p0_.common_group_name AS common_group_name_35
        FROM
          product p0_
        WHERE
          p0_.visible = 1
          AND p0_.id IN (
            33249, 34350, 34421, 36915, 38389, 38919,
            40794, 40803, 40804, 40807, 40820,
            40821, 40828, 40833, 41144, 41156,
            41158, 41607, 41722, 41726
          )
        ORDER BY
          p0_.is_hit DESC
      ) dctrn_result
  ) dctrn_table

SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT p0_.id AS id_0, p0_.visible AS visible_1, p0_.name AS name_2, p0_.sku AS sku_3, p0_.description AS description_4, p0_.main_image AS main_image_5, p0_.uid AS uid_6, p0_.characteristic AS characteristic_7, p0_.created_at AS created_at_8, p0_.updated_at AS updated_at_9, p0_.created_at_in1_c AS created_at_in1_c_10, p0_.price AS price_11, p0_.old_price AS old_price_12, p0_.bonus AS bonus_13, p0_.slug AS slug_14, p0_.images AS images_15, p0_.number_of_orders AS number_of_orders_16, p0_.is_new AS is_new_17, p0_.is_hit AS is_hit_18, p0_.is_gift AS is_gift_19, p0_.is_new_year AS is_new_year_20, p0_.full_title AS full_title_21, p0_.discount_percent AS discount_percent_22, p0_.balance_store AS balance_store_23, p0_.balance_warehouse AS balance_warehouse_24, p0_.old_slug AS old_slug_25, p0_.viewed AS viewed_26, p0_.code1c AS code1c_27, p0_.data AS data_28, p0_.on_demand AS on_demand_29, p0_.hash AS hash_30, p0_.reviews_number AS reviews_number_31, p0_.reviews_avg_score AS reviews_avg_score_32, p0_.group_uid AS group_uid_33, p0_.is_little_remains AS is_little_remains_34, p0_.common_group_name AS common_group_name_35 FROM product p0_ WHERE p0_.visible = 1 AND p0_.id IN (33249, 34350, 34421, 36915, 38389, 38919, 40794, 40803, 40804, 40807, 40820, 40821, 40828, 40833, 41144, 41156, 41158, 41607, 41722, 41726) ORDER BY p0_.is_hit DESC) dctrn_result) dctrn_table;

SELECT
  p0_.id AS id_0,
  p0_.visible AS visible_1,
  p0_.name AS name_2,
  p0_.sku AS sku_3,
  p0_.description AS description_4,
  p0_.main_image AS main_image_5,
  p0_.uid AS uid_6,
  p0_.characteristic AS characteristic_7,
  p0_.created_at AS created_at_8,
  p0_.updated_at AS updated_at_9,
  p0_.created_at_in1_c AS created_at_in1_c_10,
  p0_.price AS price_11,
  p0_.old_price AS old_price_12,
  p0_.bonus AS bonus_13,
  p0_.slug AS slug_14,
  p0_.images AS images_15,
  p0_.number_of_orders AS number_of_orders_16,
  p0_.is_new AS is_new_17,
  p0_.is_hit AS is_hit_18,
  p0_.is_gift AS is_gift_19,
  p0_.is_new_year AS is_new_year_20,
  p0_.full_title AS full_title_21,
  p0_.discount_percent AS discount_percent_22,
  p0_.balance_store AS balance_store_23,
  p0_.balance_warehouse AS balance_warehouse_24,
  p0_.old_slug AS old_slug_25,
  p0_.viewed AS viewed_26,
  p0_.code1c AS code1c_27,
  p0_.data AS data_28,
  p0_.on_demand AS on_demand_29,
  p0_.hash AS hash_30,
  p0_.reviews_number AS reviews_number_31,
  p0_.reviews_avg_score AS reviews_avg_score_32,
  p0_.group_uid AS group_uid_33,
  p0_.is_little_remains AS is_little_remains_34,
  p0_.common_group_name AS common_group_name_35,
  p0_.brand_id AS brand_id_36,
  p0_.size_id AS size_id_37,
  p0_.category1c_id AS category1c_id_38
FROM
  product p0_
WHERE
  p0_.visible = 1
  AND p0_.id IN (
    33249, 34350, 34421, 36915, 38389, 38919,
    40794, 40803, 40804, 40807, 40820,
    40821, 40828, 40833, 41144, 41156,
    41158, 41607, 41722, 41726
  )
ORDER BY
  p0_.is_hit DESC
LIMIT
  64

SELECT p0_.id AS id_0, p0_.visible AS visible_1, p0_.name AS name_2, p0_.sku AS sku_3, p0_.description AS description_4, p0_.main_image AS main_image_5, p0_.uid AS uid_6, p0_.characteristic AS characteristic_7, p0_.created_at AS created_at_8, p0_.updated_at AS updated_at_9, p0_.created_at_in1_c AS created_at_in1_c_10, p0_.price AS price_11, p0_.old_price AS old_price_12, p0_.bonus AS bonus_13, p0_.slug AS slug_14, p0_.images AS images_15, p0_.number_of_orders AS number_of_orders_16, p0_.is_new AS is_new_17, p0_.is_hit AS is_hit_18, p0_.is_gift AS is_gift_19, p0_.is_new_year AS is_new_year_20, p0_.full_title AS full_title_21, p0_.discount_percent AS discount_percent_22, p0_.balance_store AS balance_store_23, p0_.balance_warehouse AS balance_warehouse_24, p0_.old_slug AS old_slug_25, p0_.viewed AS viewed_26, p0_.code1c AS code1c_27, p0_.data AS data_28, p0_.on_demand AS on_demand_29, p0_.hash AS hash_30, p0_.reviews_number AS reviews_number_31, p0_.reviews_avg_score AS reviews_avg_score_32, p0_.group_uid AS group_uid_33, p0_.is_little_remains AS is_little_remains_34, p0_.common_group_name AS common_group_name_35, p0_.brand_id AS brand_id_36, p0_.size_id AS size_id_37, p0_.category1c_id AS category1c_id_38 FROM product p0_ WHERE p0_.visible = 1 AND p0_.id IN (33249, 34350, 34421, 36915, 38389, 38919, 40794, 40803, 40804, 40807, 40820, 40821, 40828, 40833, 41144, 41156, 41158, 41607, 41722, 41726) ORDER BY p0_.is_hit DESC LIMIT 64;

SELECT
  p0_.id AS id_0,
  p0_.text AS text_1,
  p0_.color AS color_2,
  p0_.visible AS visible_3,
  p0_.priority AS priority_4,
  p0_.type AS type_5
FROM
  product_label p0_
WHERE
  p0_.type <> ?
  AND p0_.visible = 1

SELECT p0_.id AS id_0, p0_.text AS text_1, p0_.color AS color_2, p0_.visible AS visible_3, p0_.priority AS priority_4, p0_.type AS type_5 FROM product_label p0_ WHERE p0_.type <> 'custom' AND p0_.visible = 1;

SELECT
  plp.product_id,
  pl.text,
  pl.color,
  pl.priority,
  pl.type
FROM
  product_label_product plp
  join product_label pl on pl.id = plp.product_label_id
WHERE
  plp.product_id IN (
    34350, 40804, 40807, 40820, 40833, 38919,
    40794, 40803, 40821, 40828, 41607,
    41144, 41156, 41158, 41722, 41726
  )
  AND pl.visible = 1
ORDER BY
  plp.product_id,
  pl.priority DESC

SELECT plp.product_id,pl.text,pl.color,pl.priority,pl.type 
                    FROM product_label_product plp join product_label pl on pl.id = plp.product_label_id
                    WHERE plp.product_id IN (34350,40804,40807,40820,40833,38919,40794,40803,40821,40828,41607,41144,41156,41158,41722,41726) AND pl.visible=1 ORDER BY plp.product_id,pl.priority DESC;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.content AS content_3,
  t0.created_at AS created_at_4,
  t0.updated_at AS updated_at_5,
  t0.content_head AS content_head_6
FROM
  ext_script t0

SELECT t0.id AS id_1, t0.name AS name_2, t0.content AS content_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.content_head AS content_head_6 FROM ext_script t0;