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 06:47:15' AND p0_.date_from <= '2026-02-04 06:47:15') 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.visible AS visible_3,
  t0.slug AS slug_4,
  t0.sort AS sort_5,
  t0.products_number AS products_number_6,
  t0.created_at AS created_at_7,
  t0.updated_at AS updated_at_8,
  t0.image AS image_9,
  t0.icon AS icon_10,
  t0.level AS level_11,
  t0.filter_properties AS filter_properties_12,
  t0.product_properties AS product_properties_13,
  t0.parent_id AS parent_id_14,
  t0.content_id AS content_id_15
FROM
  category t0
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.visible AS visible_3, t0.slug AS slug_4, t0.sort AS sort_5, t0.products_number AS products_number_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.image AS image_9, t0.icon AS icon_10, t0.level AS level_11, t0.filter_properties AS filter_properties_12, t0.product_properties AS product_properties_13, t0.parent_id AS parent_id_14, t0.content_id AS content_id_15 FROM category t0 WHERE t0.slug = 'pledy-lnyanye' 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 = 461;

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 = 'category' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.visible AS visible_3,
  t0.slug AS slug_4,
  t0.sort AS sort_5,
  t0.products_number AS products_number_6,
  t0.created_at AS created_at_7,
  t0.updated_at AS updated_at_8,
  t0.image AS image_9,
  t0.icon AS icon_10,
  t0.level AS level_11,
  t0.filter_properties AS filter_properties_12,
  t0.product_properties AS product_properties_13,
  t0.parent_id AS parent_id_14,
  t0.content_id AS content_id_15
FROM
  category t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.visible AS visible_3, t0.slug AS slug_4, t0.sort AS sort_5, t0.products_number AS products_number_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.image AS image_9, t0.icon AS icon_10, t0.level AS level_11, t0.filter_properties AS filter_properties_12, t0.product_properties AS product_properties_13, t0.parent_id AS parent_id_14, t0.content_id AS content_id_15 FROM category t0 WHERE t0.id = 24;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.visible AS visible_3,
  t0.slug AS slug_4,
  t0.sort AS sort_5,
  t0.products_number AS products_number_6,
  t0.created_at AS created_at_7,
  t0.updated_at AS updated_at_8,
  t0.image AS image_9,
  t0.icon AS icon_10,
  t0.level AS level_11,
  t0.filter_properties AS filter_properties_12,
  t0.product_properties AS product_properties_13,
  t0.parent_id AS parent_id_14,
  t0.content_id AS content_id_15
FROM
  category t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.visible AS visible_3, t0.slug AS slug_4, t0.sort AS sort_5, t0.products_number AS products_number_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.image AS image_9, t0.icon AS icon_10, t0.level AS level_11, t0.filter_properties AS filter_properties_12, t0.product_properties AS product_properties_13, t0.parent_id AS parent_id_14, t0.content_id AS content_id_15 FROM category t0 WHERE t0.id = 23;

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 (0)

SELECT p0_.id AS id_0, p0_.title AS title_1 FROM property_value p0_ WHERE p0_.id IN (0);

SELECT
  p0_.id AS id_0
FROM
  product p0_
  INNER JOIN category_1c c1_ ON p0_.category1c_id = c1_.id
  INNER JOIN category_category1c c3_ ON c1_.id = c3_.category1c_id
  INNER JOIN category c2_ ON c2_.id = c3_.category_id
WHERE
  p0_.visible = 1
  AND c2_.id IN (601)
ORDER BY
  p0_.is_hit DESC

SELECT p0_.id AS id_0 FROM product p0_ INNER JOIN category_1c c1_ ON p0_.category1c_id = c1_.id INNER JOIN category_category1c c3_ ON c1_.id = c3_.category1c_id INNER JOIN category c2_ ON c2_.id = c3_.category_id WHERE p0_.visible = 1 AND c2_.id IN (601) ORDER BY p0_.is_hit DESC;

SELECT
  MIN(p0_.price) AS sclr_0,
  MAX(p0_.price) AS sclr_1
FROM
  product p0_
  INNER JOIN category_1c c1_ ON p0_.category1c_id = c1_.id
  INNER JOIN category_category1c c3_ ON c1_.id = c3_.category1c_id
  INNER JOIN category c2_ ON c2_.id = c3_.category_id
WHERE
  p0_.visible = 1
  AND c2_.id IN (601)
ORDER BY
  p0_.is_hit DESC

SELECT MIN(p0_.price) AS sclr_0, MAX(p0_.price) AS sclr_1 FROM product p0_ INNER JOIN category_1c c1_ ON p0_.category1c_id = c1_.id INNER JOIN category_category1c c3_ ON c1_.id = c3_.category1c_id INNER JOIN category c2_ ON c2_.id = c3_.category_id WHERE p0_.visible = 1 AND c2_.id IN (601) 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, 37564, 37844)

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, 37564, 37844);

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, 37564, 37844)

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, 37564, 37844);

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 (
    89, 336, 3840960, 808764, 3844163, 3839617,
    2215221, 855, 785, 604, 75, 3844164,
    808766, 474, 1682, 7966, 1060, 0
  )

SELECT p0_.id AS id_0, p0_.title AS title_1 FROM property_value p0_ WHERE p0_.id IN (89, 336, 3840960, 808764, 3844163, 3839617, 2215221, 855, 785, 604, 75, 3844164, 808766, 474, 1682, 7966, 1060, 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, 37564, 37844)

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, 37564, 37844);

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 (3839617)

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 (3839617);

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_
          INNER JOIN category_1c c1_ ON p0_.category1c_id = c1_.id
          INNER JOIN category_category1c c3_ ON c1_.id = c3_.category1c_id
          INNER JOIN category c2_ ON c2_.id = c3_.category_id
        WHERE
          p0_.visible = 1
          AND c2_.id IN (601)
        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_ INNER JOIN category_1c c1_ ON p0_.category1c_id = c1_.id INNER JOIN category_category1c c3_ ON c1_.id = c3_.category1c_id INNER JOIN category c2_ ON c2_.id = c3_.category_id WHERE p0_.visible = 1 AND c2_.id IN (601) 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_
  INNER JOIN category_1c c1_ ON p0_.category1c_id = c1_.id
  INNER JOIN category_category1c c3_ ON c1_.id = c3_.category1c_id
  INNER JOIN category c2_ ON c2_.id = c3_.category_id
WHERE
  p0_.visible = 1
  AND c2_.id IN (601)
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_ INNER JOIN category_1c c1_ ON p0_.category1c_id = c1_.id INNER JOIN category_category1c c3_ ON c1_.id = c3_.category1c_id INNER JOIN category c2_ ON c2_.id = c3_.category_id WHERE p0_.visible = 1 AND c2_.id IN (601) 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 (37564, 37844)
  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 (37564,37844) AND pl.visible=1 ORDER BY plp.product_id,pl.priority DESC;

SELECT
  te.id AS id,
  te.name AS name,
  te.slug AS slug,
  te.created_at AS created_at,
  te.updated_at AS updated_at,
  te.conditions AS conditions,
  te.visible AS visible,
  te.short_name AS short_name,
  te.image AS image,
  te.filter_properties AS filter_properties,
  te.products_count AS products_count,
  te.content_id AS content_id
FROM
  virtual_category te
  JOIN virtual_category_category t ON t.virtual_category_id = te.id
WHERE
  t.category_id = ?
  AND te.visible = ?
  AND te.products_count > ?

SELECT te.id AS id, te.name AS name, te.slug AS slug, te.created_at AS created_at, te.updated_at AS updated_at, te.conditions AS conditions, te.visible AS visible, te.short_name AS short_name, te.image AS image, te.filter_properties AS filter_properties, te.products_count AS products_count, te.content_id AS content_id FROM virtual_category te JOIN virtual_category_category t ON t.virtual_category_id = te.id WHERE t.category_id = 601 AND te.visible = 1 AND te.products_count > 0;

SELECT
  te.id AS id,
  te.name AS name,
  te.visible AS visible,
  te.slug AS slug,
  te.sort AS sort,
  te.products_number AS products_number,
  te.created_at AS created_at,
  te.updated_at AS updated_at,
  te.image AS image,
  te.icon AS icon,
  te.level AS level,
  te.filter_properties AS filter_properties,
  te.product_properties AS product_properties,
  te.parent_id AS parent_id,
  te.content_id AS content_id
FROM
  category te
  JOIN category_category_to_tag t ON t.category_source = te.id
WHERE
  t.category_target = ?
  AND te.visible = ?
  AND te.products_number > ?

SELECT te.id AS id, te.name AS name, te.visible AS visible, te.slug AS slug, te.sort AS sort, te.products_number AS products_number, te.created_at AS created_at, te.updated_at AS updated_at, te.image AS image, te.icon AS icon, te.level AS level, te.filter_properties AS filter_properties, te.product_properties AS product_properties, te.parent_id AS parent_id, te.content_id AS content_id FROM category te JOIN category_category_to_tag t ON t.category_source = te.id WHERE t.category_target = 601 AND te.visible = 1 AND te.products_number > 0;

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;