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:53' AND p0_.date_from <= '2026-02-04 08:09:53') 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 = 'skaterti-kruglye' 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 = 356;

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_
  LEFT JOIN product_property p1_ ON p0_.id = p1_.product_id
  LEFT JOIN property p2_ ON p1_.property_id = p2_.id
  LEFT JOIN property_value p3_ ON p1_.value_id = p3_.id
WHERE
  p0_.visible = 1
  AND (
    p2_.id = 9
    AND p3_.id IN (
      2234591, 2234588, 2234586, 2234583,
      1295479, 643397, 7928, 7926, 7925,
      7916, 6966, 6689, 6357, 6348, 6326,
      6307, 6305, 5806, 5801, 5784, 5773,
      5140, 3485, 3197, 1300, 1291, 1237,
      1234, 1224
    )
  )

SELECT p0_.id AS id_0 FROM product p0_ LEFT JOIN product_property p1_ ON p0_.id = p1_.product_id LEFT JOIN property p2_ ON p1_.property_id = p2_.id LEFT JOIN property_value p3_ ON p1_.value_id = p3_.id WHERE p0_.visible = 1 AND (p2_.id = 9 AND p3_.id IN (2234591, 2234588, 2234586, 2234583, 1295479, 643397, 7928, 7926, 7925, 7916, 6966, 6689, 6357, 6348, 6326, 6307, 6305, 5806, 5801, 5784, 5773, 5140, 3485, 3197, 1300, 1291, 1237, 1234, 1224));

SELECT
  p0_.id AS id_0
FROM
  product p0_
WHERE
  p0_.visible = 1
  AND p0_.id IN (
    0, 10734, 10740, 10741, 13945, 13946,
    13949, 31647, 36780, 38223, 38224,
    38979, 38984, 38993, 41587, 41588,
    36479, 36485, 36487, 36488, 14346,
    31224, 31225, 32206
  )

SELECT p0_.id AS id_0 FROM product p0_ WHERE p0_.visible = 1 AND p0_.id IN (0, 10734, 10740, 10741, 13945, 13946, 13949, 31647, 36780, 38223, 38224, 38979, 38984, 38993, 41587, 41588, 36479, 36485, 36487, 36488, 14346, 31224, 31225, 32206);

SELECT
  p0_.id AS id_0
FROM
  product p0_
WHERE
  p0_.visible = 1
  AND p0_.id IN (
    10734, 10740, 10741, 13945, 13946, 13949,
    14346, 31224, 31225, 31647, 32206,
    36479, 36485, 36487, 36488, 36780,
    38223, 38224, 38979, 38984, 38993,
    41587, 41588
  )
ORDER BY
  p0_.is_hit DESC

SELECT p0_.id AS id_0 FROM product p0_ WHERE p0_.visible = 1 AND p0_.id IN (10734, 10740, 10741, 13945, 13946, 13949, 14346, 31224, 31225, 31647, 32206, 36479, 36485, 36487, 36488, 36780, 38223, 38224, 38979, 38984, 38993, 41587, 41588) 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 (
    10734, 10740, 10741, 13945, 13946, 13949,
    14346, 31224, 31225, 31647, 32206,
    36479, 36485, 36487, 36488, 36780,
    38223, 38224, 38979, 38984, 38993,
    41587, 41588
  )
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 (10734, 10740, 10741, 13945, 13946, 13949, 14346, 31224, 31225, 31647, 32206, 36479, 36485, 36487, 36488, 36780, 38223, 38224, 38979, 38984, 38993, 41587, 41588) 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, 10734, 36487, 36488, 36780, 38223,
    38224, 38979, 38984, 38993, 41587,
    36485, 36479, 32206, 10740, 10741,
    13945, 13946, 13949, 14346, 31224,
    31225, 31647, 41588
  )

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, 10734, 36487, 36488, 36780, 38223, 38224, 38979, 38984, 38993, 41587, 36485, 36479, 32206, 10740, 10741, 13945, 13946, 13949, 14346, 31224, 31225, 31647, 41588);

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, 10734, 36487, 36488, 36780, 38223,
    38224, 38979, 38984, 38993, 41587,
    36485, 36479, 32206, 10740, 10741,
    13945, 13946, 13949, 14346, 31224,
    31225, 31647, 41588
  )

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, 10734, 36487, 36488, 36780, 38223, 38224, 38979, 38984, 38993, 41587, 36485, 36479, 32206, 10740, 10741, 13945, 13946, 13949, 14346, 31224, 31225, 31647, 41588);

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 (
    27, 147, 60, 159, 89, 146, 499, 5426, 1854,
    1848, 157, 3839320, 3841329, 3844814,
    2841, 8, 465, 808764, 5773, 6348, 5784,
    3839574, 3839578, 3839698, 3839706,
    5424, 1852, 1845, 6861, 3840311, 3840654,
    3843583, 3843585, 3839319, 3844815,
    3844817, 3844819, 855, 229, 1159, 1571,
    3822, 3840093, 24627, 2539, 3843584,
    7543, 3843730, 3841231, 3841391, 14,
    604, 130, 307, 164, 290, 54, 163, 208,
    347, 519, 617, 256, 522, 269, 121, 17,
    3251, 131, 82, 491, 768, 3840652, 3840312,
    3840467, 3840024, 2393, 492, 3839325,
    3841052, 19, 473, 154, 808766, 510,
    1847, 3599, 749, 1001, 1017, 2048, 3159,
    1327, 1559, 688, 1555, 341, 1400, 960,
    3541, 5422, 1851, 57, 2856, 2897, 1030,
    699, 5893, 6863, 186, 134, 1161846,
    144, 403, 1675, 808747, 216, 0
  )

SELECT p0_.id AS id_0, p0_.title AS title_1 FROM property_value p0_ WHERE p0_.id IN (27, 147, 60, 159, 89, 146, 499, 5426, 1854, 1848, 157, 3839320, 3841329, 3844814, 2841, 8, 465, 808764, 5773, 6348, 5784, 3839574, 3839578, 3839698, 3839706, 5424, 1852, 1845, 6861, 3840311, 3840654, 3843583, 3843585, 3839319, 3844815, 3844817, 3844819, 855, 229, 1159, 1571, 3822, 3840093, 24627, 2539, 3843584, 7543, 3843730, 3841231, 3841391, 14, 604, 130, 307, 164, 290, 54, 163, 208, 347, 519, 617, 256, 522, 269, 121, 17, 3251, 131, 82, 491, 768, 3840652, 3840312, 3840467, 3840024, 2393, 492, 3839325, 3841052, 19, 473, 154, 808766, 510, 1847, 3599, 749, 1001, 1017, 2048, 3159, 1327, 1559, 688, 1555, 341, 1400, 960, 3541, 5422, 1851, 57, 2856, 2897, 1030, 699, 5893, 6863, 186, 134, 1161846, 144, 403, 1675, 808747, 216, 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, 10734, 36487, 36488, 36780, 38223,
    38224, 38979, 38984, 38993, 41587,
    36485, 36479, 32206, 10740, 10741,
    13945, 13946, 13949, 14346, 31224,
    31225, 31647, 41588
  )

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, 10734, 36487, 36488, 36780, 38223, 38224, 38979, 38984, 38993, 41587, 36485, 36479, 32206, 10740, 10741, 13945, 13946, 13949, 14346, 31224, 31225, 31647, 41588);

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 (
    3839574, 3839706, 3839578, 3839698
  )

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 (3839574, 3839706, 3839578, 3839698);

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 (
            10734, 10740, 10741, 13945, 13946, 13949,
            14346, 31224, 31225, 31647, 32206,
            36479, 36485, 36487, 36488, 36780,
            38223, 38224, 38979, 38984, 38993,
            41587, 41588
          )
        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 (10734, 10740, 10741, 13945, 13946, 13949, 14346, 31224, 31225, 31647, 32206, 36479, 36485, 36487, 36488, 36780, 38223, 38224, 38979, 38984, 38993, 41587, 41588) 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 (
    10734, 10740, 10741, 13945, 13946, 13949,
    14346, 31224, 31225, 31647, 32206,
    36479, 36485, 36487, 36488, 36780,
    38223, 38224, 38979, 38984, 38993,
    41587, 41588
  )
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 (10734, 10740, 10741, 13945, 13946, 13949, 14346, 31224, 31225, 31647, 32206, 36479, 36485, 36487, 36488, 36780, 38223, 38224, 38979, 38984, 38993, 41587, 41588) 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 (
    38979, 38984, 38223, 38224, 38993, 41587,
    41588, 13945, 13946, 13949, 36487,
    36488, 31647, 36780, 32206, 10734,
    10740, 10741, 31224, 31225
  )
  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 (38979,38984,38223,38224,38993,41587,41588,13945,13946,13949,36487,36488,31647,36780,32206,10734,10740,10741,31224,31225) 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;