Symfony Profiler

SELECT
  c0_.category_id AS category_id_0,
  c0_.category_left AS category_left_1,
  c0_.category_right AS category_right_2,
  c0_.active AS active_3
FROM
  Categories c0_
WHERE
  c0_.active = ?
ORDER BY
  c0_.category_left ASC

SELECT c0_.category_id AS category_id_0, c0_.category_left AS category_left_1, c0_.category_right AS category_right_2, c0_.active AS active_3 FROM Categories c0_ WHERE c0_.active = 0 ORDER BY c0_.category_left ASC;

SELECT
  c0_.category_id AS category_id_0,
  c0_.category_name AS category_name_1,
  c0_.category_left AS category_left_2,
  c0_.category_level AS category_level_3,
  c0_.category_right AS category_right_4,
  c0_.description AS description_5,
  c0_.short_desc AS short_desc_6,
  c0_.code AS code_7,
  c0_.img AS img_8,
  c0_.meta_title AS meta_title_9,
  c0_.meta_keywords AS meta_keywords_10,
  c0_.meta_description AS meta_description_11,
  c0_.active AS active_12,
  c0_.is_empty AS is_empty_13,
  c0_.category_top AS category_top_14
FROM
  Categories c0_
WHERE
  c0_.active = 1
  AND c0_.category_id = ?
LIMIT
  1

SELECT c0_.category_id AS category_id_0, c0_.category_name AS category_name_1, c0_.category_left AS category_left_2, c0_.category_level AS category_level_3, c0_.category_right AS category_right_4, c0_.description AS description_5, c0_.short_desc AS short_desc_6, c0_.code AS code_7, c0_.img AS img_8, c0_.meta_title AS meta_title_9, c0_.meta_keywords AS meta_keywords_10, c0_.meta_description AS meta_description_11, c0_.active AS active_12, c0_.is_empty AS is_empty_13, c0_.category_top AS category_top_14 FROM Categories c0_ WHERE c0_.active = 1 AND c0_.category_id = 1008 LIMIT 1;

SELECT
  f0_.id AS id_0,
  f0_.feature_id AS feature_id_1,
  f0_.category_id AS category_id_2,
  f0_.code AS code_3,
  f0_.is_slider AS is_slider_4,
  f0_.view_settings AS view_settings_5,
  f0_.logic AS logic_6,
  f1_.id AS id_7,
  f1_.code AS code_8,
  f1_.name AS name_9,
  f1_.weight AS weight_10,
  f1_.category_id AS category_id_11,
  f1_.active AS active_12,
  f1_.auto_settings AS auto_settings_13,
  f1_.logic AS logic_14,
  f1_.feature_id AS feature_id_15,
  f2_.id AS id_16,
  f2_.feature_id AS feature_id_17,
  f2_.value_id AS value_id_18,
  f2_.code AS code_19,
  f2_.img AS img_20,
  f2_.value AS value_21,
  f2_.description AS description_22,
  f2_.json_path AS json_path_23,
  f2_.facet_size AS facet_size_24,
  f0_.filter_id AS filter_id_25,
  f2_.filter_id AS filter_id_26
FROM
  filters_list_index f0_
  LEFT JOIN filters f1_ ON f0_.filter_id = f1_.id
  LEFT JOIN filters_value_index f2_ ON f1_.id = f2_.filter_id
  AND (
    f0_.feature_id > 0
    AND f0_.is_slider = 1
  )
WHERE
  f0_.category_id = ?
ORDER BY
  f0_.id ASC

SELECT f0_.id AS id_0, f0_.feature_id AS feature_id_1, f0_.category_id AS category_id_2, f0_.code AS code_3, f0_.is_slider AS is_slider_4, f0_.view_settings AS view_settings_5, f0_.logic AS logic_6, f1_.id AS id_7, f1_.code AS code_8, f1_.name AS name_9, f1_.weight AS weight_10, f1_.category_id AS category_id_11, f1_.active AS active_12, f1_.auto_settings AS auto_settings_13, f1_.logic AS logic_14, f1_.feature_id AS feature_id_15, f2_.id AS id_16, f2_.feature_id AS feature_id_17, f2_.value_id AS value_id_18, f2_.code AS code_19, f2_.img AS img_20, f2_.value AS value_21, f2_.description AS description_22, f2_.json_path AS json_path_23, f2_.facet_size AS facet_size_24, f0_.filter_id AS filter_id_25, f2_.filter_id AS filter_id_26 FROM filters_list_index f0_ LEFT JOIN filters f1_ ON f0_.filter_id = f1_.id LEFT JOIN filters_value_index f2_ ON f1_.id = f2_.filter_id AND (f0_.feature_id > 0 AND f0_.is_slider = 1) WHERE f0_.category_id = 1008 ORDER BY f0_.id ASC;

SELECT
  MIN(f0_.price_selling) AS sclr_0,
  MAX(f0_.price_selling) AS sclr_1
FROM
  filters_product_index f0_
  INNER JOIN Products p1_ ON f0_.catalog_product_id = p1_.product_id
  INNER JOIN Products_Categoryes p3_ ON p1_.product_id = p3_.product_id
  INNER JOIN Categories c2_ ON c2_.category_id = p3_.category_id
WHERE
  c2_.category_id = ?
  AND f0_.price_selling > 0

SELECT MIN(f0_.price_selling) AS sclr_0, MAX(f0_.price_selling) AS sclr_1 FROM filters_product_index f0_ INNER JOIN Products p1_ ON f0_.catalog_product_id = p1_.product_id INNER JOIN Products_Categoryes p3_ ON p1_.product_id = p3_.product_id INNER JOIN Categories c2_ ON c2_.category_id = p3_.category_id WHERE c2_.category_id = 1008 AND f0_.price_selling > 0;

SELECT
  f0_.id AS id_0,
  f0_.feature_id AS feature_id_1,
  f0_.value_id AS value_id_2,
  f0_.code AS code_3,
  f0_.img AS img_4,
  f0_.value AS value_5,
  f0_.description AS description_6,
  f0_.json_path AS json_path_7,
  f0_.facet_size AS facet_size_8,
  f0_.filter_id AS filter_id_9
FROM
  filters_value_index f0_
  LEFT JOIN filters f1_ ON f0_.filter_id = f1_.id
  LEFT JOIN filters_list_index f2_ ON f1_.id = f2_.filter_id
  AND (
    f2_.feature_id > 0
    AND f2_.is_slider = 1
  )
WHERE
  f2_.id IS NULL
  AND f0_.filter_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
ORDER BY
  f0_.id ASC

SELECT f0_.id AS id_0, f0_.feature_id AS feature_id_1, f0_.value_id AS value_id_2, f0_.code AS code_3, f0_.img AS img_4, f0_.value AS value_5, f0_.description AS description_6, f0_.json_path AS json_path_7, f0_.facet_size AS facet_size_8, f0_.filter_id AS filter_id_9 FROM filters_value_index f0_ LEFT JOIN filters f1_ ON f0_.filter_id = f1_.id LEFT JOIN filters_list_index f2_ ON f1_.id = f2_.filter_id AND (f2_.feature_id > 0 AND f2_.is_slider = 1) WHERE f2_.id IS NULL AND f0_.filter_id IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14) ORDER BY f0_.id ASC;

SELECT
  (
    CASE WHEN (
      JSON_EXTRACT(
        f0_.features, '$.j_virobnik.j_samsung'
      ) IS NOT NULL
    ) THEN 'samsung' WHEN (
      JSON_EXTRACT(
        f0_.features, '$.j_virobnik.j_sony'
      ) IS NOT NULL
    ) THEN 'sony' WHEN (
      JSON_EXTRACT(
        f0_.features, '$.j_virobnik.j_lg'
      ) IS NOT NULL
    ) THEN 'lg' ELSE '' END
  ) AS sclr_0,
  COUNT(DISTINCT p1_.product_id) AS sclr_1
FROM
  filters_product_index f0_
  INNER JOIN Products p1_ ON f0_.catalog_product_id = p1_.product_id
  INNER JOIN Products_Categoryes p3_ ON p1_.product_id = p3_.product_id
  INNER JOIN Categories c2_ ON c2_.category_id = p3_.category_id
WHERE
  c2_.category_id = ?
GROUP BY
  sclr_0
HAVING
  sclr_0 IS NOT NULL
  AND sclr_0 <> ''

SELECT (CASE WHEN (JSON_EXTRACT(f0_.features, '$.j_virobnik.j_samsung') IS NOT NULL) THEN 'samsung' WHEN (JSON_EXTRACT(f0_.features, '$.j_virobnik.j_sony') IS NOT NULL) THEN 'sony' WHEN (JSON_EXTRACT(f0_.features, '$.j_virobnik.j_lg') IS NOT NULL) THEN 'lg' ELSE '' END) AS sclr_0, COUNT(DISTINCT p1_.product_id) AS sclr_1 FROM filters_product_index f0_ INNER JOIN Products p1_ ON f0_.catalog_product_id = p1_.product_id INNER JOIN Products_Categoryes p3_ ON p1_.product_id = p3_.product_id INNER JOIN Categories c2_ ON c2_.category_id = p3_.category_id WHERE c2_.category_id = 1008 GROUP BY sclr_0 HAVING sclr_0 IS NOT NULL AND sclr_0 <> '';

SELECT
  (
    CASE WHEN (
      JSON_EXTRACT(
        f0_.features, '$.j_grov_funkts.j_rezhim_allm_rezhim_hgig'
      ) IS NOT NULL
    ) THEN 'rezhim-allm-rezhim-hgig' WHEN (
      JSON_EXTRACT(
        f0_.features, '$.j_grov_funkts.j_pdtrimka_hdmi_2_1_rezhim_allm'
      ) IS NOT NULL
    ) THEN 'pdtrimka-hdmi-2-1-rezhim-allm' ELSE '' END
  ) AS sclr_0,
  COUNT(DISTINCT p1_.product_id) AS sclr_1
FROM
  filters_product_index f0_
  INNER JOIN Products p1_ ON f0_.catalog_product_id = p1_.product_id
  INNER JOIN Products_Categoryes p3_ ON p1_.product_id = p3_.product_id
  INNER JOIN Categories c2_ ON c2_.category_id = p3_.category_id
WHERE
  c2_.category_id = ?
  AND JSON_EXTRACT(
    f0_.features, '$.j_virobnik.j_samsung'
  ) IS NOT NULL
GROUP BY
  sclr_0
HAVING
  sclr_0 IS NOT NULL
  AND sclr_0 <> ''

SELECT (CASE WHEN (JSON_EXTRACT(f0_.features, '$.j_grov_funkts.j_rezhim_allm_rezhim_hgig') IS NOT NULL) THEN 'rezhim-allm-rezhim-hgig' WHEN (JSON_EXTRACT(f0_.features, '$.j_grov_funkts.j_pdtrimka_hdmi_2_1_rezhim_allm') IS NOT NULL) THEN 'pdtrimka-hdmi-2-1-rezhim-allm' ELSE '' END) AS sclr_0, COUNT(DISTINCT p1_.product_id) AS sclr_1 FROM filters_product_index f0_ INNER JOIN Products p1_ ON f0_.catalog_product_id = p1_.product_id INNER JOIN Products_Categoryes p3_ ON p1_.product_id = p3_.product_id INNER JOIN Categories c2_ ON c2_.category_id = p3_.category_id WHERE c2_.category_id = 1008 AND JSON_EXTRACT(f0_.features, '$.j_virobnik.j_samsung') IS NOT NULL GROUP BY sclr_0 HAVING sclr_0 IS NOT NULL AND sclr_0 <> '';

SELECT
  (
    CASE WHEN (
      JSON_EXTRACT(
        f0_.features, '$.j_tip_televzora.j_qled'
      ) IS NOT NULL
    ) THEN 'qled' WHEN (
      JSON_EXTRACT(
        f0_.features, '$.j_tip_televzora.j_led'
      ) IS NOT NULL
    ) THEN 'led' ELSE '' END
  ) AS sclr_0,
  COUNT(DISTINCT p1_.product_id) AS sclr_1
FROM
  filters_product_index f0_
  INNER JOIN Products p1_ ON f0_.catalog_product_id = p1_.product_id
  INNER JOIN Products_Categoryes p3_ ON p1_.product_id = p3_.product_id
  INNER JOIN Categories c2_ ON c2_.category_id = p3_.category_id
WHERE
  c2_.category_id = ?
  AND JSON_EXTRACT(
    f0_.features, '$.j_virobnik.j_samsung'
  ) IS NOT NULL
GROUP BY
  sclr_0
HAVING
  sclr_0 IS NOT NULL
  AND sclr_0 <> ''

SELECT (CASE WHEN (JSON_EXTRACT(f0_.features, '$.j_tip_televzora.j_qled') IS NOT NULL) THEN 'qled' WHEN (JSON_EXTRACT(f0_.features, '$.j_tip_televzora.j_led') IS NOT NULL) THEN 'led' ELSE '' END) AS sclr_0, COUNT(DISTINCT p1_.product_id) AS sclr_1 FROM filters_product_index f0_ INNER JOIN Products p1_ ON f0_.catalog_product_id = p1_.product_id INNER JOIN Products_Categoryes p3_ ON p1_.product_id = p3_.product_id INNER JOIN Categories c2_ ON c2_.category_id = p3_.category_id WHERE c2_.category_id = 1008 AND JSON_EXTRACT(f0_.features, '$.j_virobnik.j_samsung') IS NOT NULL GROUP BY sclr_0 HAVING sclr_0 IS NOT NULL AND sclr_0 <> '';

SELECT
  (
    CASE WHEN (
      JSON_EXTRACT(
        f0_.features, '$.j_smart_tv.j_tak'
      ) IS NOT NULL
    ) THEN 'tak' ELSE '' END
  ) AS sclr_0,
  COUNT(DISTINCT p1_.product_id) AS sclr_1
FROM
  filters_product_index f0_
  INNER JOIN Products p1_ ON f0_.catalog_product_id = p1_.product_id
  INNER JOIN Products_Categoryes p3_ ON p1_.product_id = p3_.product_id
  INNER JOIN Categories c2_ ON c2_.category_id = p3_.category_id
WHERE
  c2_.category_id = ?
  AND JSON_EXTRACT(
    f0_.features, '$.j_virobnik.j_samsung'
  ) IS NOT NULL
GROUP BY
  sclr_0
HAVING
  sclr_0 IS NOT NULL
  AND sclr_0 <> ''

SELECT (CASE WHEN (JSON_EXTRACT(f0_.features, '$.j_smart_tv.j_tak') IS NOT NULL) THEN 'tak' ELSE '' END) AS sclr_0, COUNT(DISTINCT p1_.product_id) AS sclr_1 FROM filters_product_index f0_ INNER JOIN Products p1_ ON f0_.catalog_product_id = p1_.product_id INNER JOIN Products_Categoryes p3_ ON p1_.product_id = p3_.product_id INNER JOIN Categories c2_ ON c2_.category_id = p3_.category_id WHERE c2_.category_id = 1008 AND JSON_EXTRACT(f0_.features, '$.j_virobnik.j_samsung') IS NOT NULL GROUP BY sclr_0 HAVING sclr_0 IS NOT NULL AND sclr_0 <> '';

SELECT
  (
    CASE WHEN (
      JSON_EXTRACT(
        f0_.features, '$.j_smart_platforma.j_tizen'
      ) IS NOT NULL
    ) THEN 'tizen' WHEN (
      JSON_EXTRACT(
        f0_.features, '$.j_smart_platforma.j_google_tv'
      ) IS NOT NULL
    ) THEN 'google-tv' WHEN (
      JSON_EXTRACT(
        f0_.features, '$.j_smart_platforma.j_webos'
      ) IS NOT NULL
    ) THEN 'webos' ELSE '' END
  ) AS sclr_0,
  COUNT(DISTINCT p1_.product_id) AS sclr_1
FROM
  filters_product_index f0_
  INNER JOIN Products p1_ ON f0_.catalog_product_id = p1_.product_id
  INNER JOIN Products_Categoryes p3_ ON p1_.product_id = p3_.product_id
  INNER JOIN Categories c2_ ON c2_.category_id = p3_.category_id
WHERE
  c2_.category_id = ?
  AND JSON_EXTRACT(
    f0_.features, '$.j_virobnik.j_samsung'
  ) IS NOT NULL
GROUP BY
  sclr_0
HAVING
  sclr_0 IS NOT NULL
  AND sclr_0 <> ''

SELECT (CASE WHEN (JSON_EXTRACT(f0_.features, '$.j_smart_platforma.j_tizen') IS NOT NULL) THEN 'tizen' WHEN (JSON_EXTRACT(f0_.features, '$.j_smart_platforma.j_google_tv') IS NOT NULL) THEN 'google-tv' WHEN (JSON_EXTRACT(f0_.features, '$.j_smart_platforma.j_webos') IS NOT NULL) THEN 'webos' ELSE '' END) AS sclr_0, COUNT(DISTINCT p1_.product_id) AS sclr_1 FROM filters_product_index f0_ INNER JOIN Products p1_ ON f0_.catalog_product_id = p1_.product_id INNER JOIN Products_Categoryes p3_ ON p1_.product_id = p3_.product_id INNER JOIN Categories c2_ ON c2_.category_id = p3_.category_id WHERE c2_.category_id = 1008 AND JSON_EXTRACT(f0_.features, '$.j_virobnik.j_samsung') IS NOT NULL GROUP BY sclr_0 HAVING sclr_0 IS NOT NULL AND sclr_0 <> '';

SELECT
  (
    CASE WHEN (
      JSON_EXTRACT(
        f0_.features, '$.j_rozdlna_zdatnst_ekranu.j_4k_uhd_3840x2160'
      ) IS NOT NULL
    ) THEN '4k-uhd-3840x2160' ELSE '' END
  ) AS sclr_0,
  COUNT(DISTINCT p1_.product_id) AS sclr_1
FROM
  filters_product_index f0_
  INNER JOIN Products p1_ ON f0_.catalog_product_id = p1_.product_id
  INNER JOIN Products_Categoryes p3_ ON p1_.product_id = p3_.product_id
  INNER JOIN Categories c2_ ON c2_.category_id = p3_.category_id
WHERE
  c2_.category_id = ?
  AND JSON_EXTRACT(
    f0_.features, '$.j_virobnik.j_samsung'
  ) IS NOT NULL
GROUP BY
  sclr_0
HAVING
  sclr_0 IS NOT NULL
  AND sclr_0 <> ''

SELECT (CASE WHEN (JSON_EXTRACT(f0_.features, '$.j_rozdlna_zdatnst_ekranu.j_4k_uhd_3840x2160') IS NOT NULL) THEN '4k-uhd-3840x2160' ELSE '' END) AS sclr_0, COUNT(DISTINCT p1_.product_id) AS sclr_1 FROM filters_product_index f0_ INNER JOIN Products p1_ ON f0_.catalog_product_id = p1_.product_id INNER JOIN Products_Categoryes p3_ ON p1_.product_id = p3_.product_id INNER JOIN Categories c2_ ON c2_.category_id = p3_.category_id WHERE c2_.category_id = 1008 AND JSON_EXTRACT(f0_.features, '$.j_virobnik.j_samsung') IS NOT NULL GROUP BY sclr_0 HAVING sclr_0 IS NOT NULL AND sclr_0 <> '';

SELECT
  CONCAT_WS(
    ',',
    IF(
      JSON_EXTRACT(
        f0_.features, '$.j_priznachennya.j_geymerskiy'
      ) IS NOT NULL,
      'geymerskiy',
      NULL
    ),
    IF(
      JSON_EXTRACT(
        f0_.features, '$.j_priznachennya.j_dlya_vtaln'
      ) IS NOT NULL,
      'dlya-vtaln',
      NULL
    ),
    IF(
      JSON_EXTRACT(
        f0_.features, '$.j_priznachennya.j_dlya_spaln'
      ) IS NOT NULL,
      'dlya-spaln',
      NULL
    ),
    IF(
      JSON_EXTRACT(
        f0_.features, '$.j_priznachennya.j_knoteatr'
      ) IS NOT NULL,
      'knoteatr',
      NULL
    )
  ) AS sclr_0,
  COUNT(DISTINCT p1_.product_id) AS sclr_1
FROM
  filters_product_index f0_
  INNER JOIN Products p1_ ON f0_.catalog_product_id = p1_.product_id
  INNER JOIN Products_Categoryes p3_ ON p1_.product_id = p3_.product_id
  INNER JOIN Categories c2_ ON c2_.category_id = p3_.category_id
WHERE
  c2_.category_id = ?
  AND JSON_EXTRACT(
    f0_.features, '$.j_virobnik.j_samsung'
  ) IS NOT NULL
GROUP BY
  sclr_0
HAVING
  sclr_0 IS NOT NULL
  AND sclr_0 <> ''

SELECT CONCAT_WS(',', IF(JSON_EXTRACT(f0_.features, '$.j_priznachennya.j_geymerskiy') IS NOT NULL, 'geymerskiy', NULL), IF(JSON_EXTRACT(f0_.features, '$.j_priznachennya.j_dlya_vtaln') IS NOT NULL, 'dlya-vtaln', NULL), IF(JSON_EXTRACT(f0_.features, '$.j_priznachennya.j_dlya_spaln') IS NOT NULL, 'dlya-spaln', NULL), IF(JSON_EXTRACT(f0_.features, '$.j_priznachennya.j_knoteatr') IS NOT NULL, 'knoteatr', NULL)) AS sclr_0, COUNT(DISTINCT p1_.product_id) AS sclr_1 FROM filters_product_index f0_ INNER JOIN Products p1_ ON f0_.catalog_product_id = p1_.product_id INNER JOIN Products_Categoryes p3_ ON p1_.product_id = p3_.product_id INNER JOIN Categories c2_ ON c2_.category_id = p3_.category_id WHERE c2_.category_id = 1008 AND JSON_EXTRACT(f0_.features, '$.j_virobnik.j_samsung') IS NOT NULL GROUP BY sclr_0 HAVING sclr_0 IS NOT NULL AND sclr_0 <> '';

SELECT
  (
    CASE WHEN (
      JSON_EXTRACT(
        f0_.features, '$.j_rk_vipusku.j_2024'
      ) IS NOT NULL
    ) THEN '2024' WHEN (
      JSON_EXTRACT(
        f0_.features, '$.j_rk_vipusku.j_2023'
      ) IS NOT NULL
    ) THEN '2023' ELSE '' END
  ) AS sclr_0,
  COUNT(DISTINCT p1_.product_id) AS sclr_1
FROM
  filters_product_index f0_
  INNER JOIN Products p1_ ON f0_.catalog_product_id = p1_.product_id
  INNER JOIN Products_Categoryes p3_ ON p1_.product_id = p3_.product_id
  INNER JOIN Categories c2_ ON c2_.category_id = p3_.category_id
WHERE
  c2_.category_id = ?
  AND JSON_EXTRACT(
    f0_.features, '$.j_virobnik.j_samsung'
  ) IS NOT NULL
GROUP BY
  sclr_0
HAVING
  sclr_0 IS NOT NULL
  AND sclr_0 <> ''

SELECT (CASE WHEN (JSON_EXTRACT(f0_.features, '$.j_rk_vipusku.j_2024') IS NOT NULL) THEN '2024' WHEN (JSON_EXTRACT(f0_.features, '$.j_rk_vipusku.j_2023') IS NOT NULL) THEN '2023' ELSE '' END) AS sclr_0, COUNT(DISTINCT p1_.product_id) AS sclr_1 FROM filters_product_index f0_ INNER JOIN Products p1_ ON f0_.catalog_product_id = p1_.product_id INNER JOIN Products_Categoryes p3_ ON p1_.product_id = p3_.product_id INNER JOIN Categories c2_ ON c2_.category_id = p3_.category_id WHERE c2_.category_id = 1008 AND JSON_EXTRACT(f0_.features, '$.j_virobnik.j_samsung') IS NOT NULL GROUP BY sclr_0 HAVING sclr_0 IS NOT NULL AND sclr_0 <> '';

SELECT
  CONCAT_WS(
    ',',
    IF(
      JSON_EXTRACT(
        f0_.features, '$.j_tehnolog.j_4k_upscaling'
      ) IS NOT NULL,
      '4k-upscaling',
      NULL
    ),
    IF(
      JSON_EXTRACT(
        f0_.features, '$.j_tehnolog.j_adaptive_sound'
      ) IS NOT NULL,
      'adaptive-sound',
      NULL
    ),
    IF(
      JSON_EXTRACT(
        f0_.features, '$.j_tehnolog.j_anynet'
      ) IS NOT NULL,
      'anynet',
      NULL
    ),
    IF(
      JSON_EXTRACT(
        f0_.features, '$.j_tehnolog.j_contrast_enhancer'
      ) IS NOT NULL,
      'contrast-enhancer',
      NULL
    ),
    IF(
      JSON_EXTRACT(
        f0_.features, '$.j_tehnolog.j_game_motion_plus'
      ) IS NOT NULL,
      'game-motion-plus',
      NULL
    ),
    IF(
      JSON_EXTRACT(
        f0_.features, '$.j_tehnolog.j_motion_xcelerator'
      ) IS NOT NULL,
      'motion-xcelerator',
      NULL
    ),
    IF(
      JSON_EXTRACT(
        f0_.features, '$.j_tehnolog.j_ots_lite'
      ) IS NOT NULL,
      'ots-lite',
      NULL
    ),
    IF(
      JSON_EXTRACT(
        f0_.features, '$.j_tehnolog.j_q_symphony'
      ) IS NOT NULL,
      'q-symphony',
      NULL
    ),
    IF(
      JSON_EXTRACT(
        f0_.features, '$.j_tehnolog.j_supreme_uhd_dimming'
      ) IS NOT NULL,
      'supreme-uhd-dimming',
      NULL
    ),
    IF(
      JSON_EXTRACT(
        f0_.features, '$.j_tehnolog.j_4k_x_reality_pro'
      ) IS NOT NULL,
      '4k-x-reality-pro',
      NULL
    ),
    IF(
      JSON_EXTRACT(
        f0_.features, '$.j_tehnolog.j_apple_airplay_2'
      ) IS NOT NULL,
      'apple-airplay-2',
      NULL
    ),
    IF(
      JSON_EXTRACT(
        f0_.features, '$.j_tehnolog.j_apple_homekit'
      ) IS NOT NULL,
      'apple-homekit',
      NULL
    ),
    IF(
      JSON_EXTRACT(
        f0_.features, '$.j_tehnolog.j_chromecast'
      ) IS NOT NULL,
      'chromecast',
      NULL
    ),
    IF(
      JSON_EXTRACT(
        f0_.features, '$.j_tehnolog.j_dolby_atmos'
      ) IS NOT NULL,
      'dolby-atmos',
      NULL
    ),
    IF(
      JSON_EXTRACT(
        f0_.features, '$.j_tehnolog.j_dolby_audio'
      ) IS NOT NULL,
      'dolby-audio',
      NULL
    ),
    IF(
      JSON_EXTRACT(
        f0_.features, '$.j_tehnolog.j_dts'
      ) IS NOT NULL,
      'dts',
      NULL
    ),
    IF(
      JSON_EXTRACT(
        f0_.features, '$.j_tehnolog.j_dynamic_backlight_control'
      ) IS NOT NULL,
      'dynamic-backlight-control',
      NULL
    ),
    IF(
      JSON_EXTRACT(
        f0_.features, '$.j_tehnolog.j_dynamic_contrast_enhancer'
      ) IS NOT NULL,
      'dynamic-contrast-enhancer',
      NULL
    ),
    IF(
      JSON_EXTRACT(
        f0_.features, '$.j_tehnolog.j_frame_dimming'
      ) IS NOT NULL,
      'frame-dimming',
      NULL
    ),
    IF(
      JSON_EXTRACT(
        f0_.features, '$.j_tehnolog.j_game_menu'
      ) IS NOT NULL,
      'game-menu',
      NULL
    ),
    IF(
      JSON_EXTRACT(
        f0_.features, '$.j_tehnolog.j_live_colour'
      ) IS NOT NULL,
      'live-colour',
      NULL
    ),
    IF(
      JSON_EXTRACT(
        f0_.features, '$.j_tehnolog.j_motionflow_xr'
      ) IS NOT NULL,
      'motionflow-xr',
      NULL
    ),
    IF(
      JSON_EXTRACT(
        f0_.features, '$.j_tehnolog.j_object_based_hdr_remaster'
      ) IS NOT NULL,
      'object-based-hdr-remaster',
      NULL
    ),
    IF(
      JSON_EXTRACT(
        f0_.features, '$.j_tehnolog.j_triluminos_pro'
      ) IS NOT NULL,
      'triluminos-pro',
      NULL
    ),
    IF(
      JSON_EXTRACT(
        f0_.features, '$.j_tehnolog.j_ai_brightness_control'
      ) IS NOT NULL,
      'ai-brightness-control',
      NULL
    ),
    IF(
      JSON_EXTRACT(
        f0_.features, '$.j_tehnolog.j_ai_sound_pro'
      ) IS NOT NULL,
      'ai-sound-pro',
      NULL
    ),
    IF(
      JSON_EXTRACT(
        f0_.features, '$.j_tehnolog.j_bluetooth_surround_ready'
      ) IS NOT NULL,
      'bluetooth-surround-ready',
      NULL
    ),
    IF(
      JSON_EXTRACT(
        f0_.features, '$.j_tehnolog.j_clear_voice_pro'
      ) IS NOT NULL,
      'clear-voice-pro',
      NULL
    ),
    IF(
      JSON_EXTRACT(
        f0_.features, '$.j_tehnolog.j_dynamic_tone_mappng'
      ) IS NOT NULL,
      'dynamic-tone-mappng',
      NULL
    ),
    IF(
      JSON_EXTRACT(
        f0_.features, '$.j_tehnolog.j_lg_sound_sync'
      ) IS NOT NULL,
      'lg-sound-sync',
      NULL
    )
  ) AS sclr_0,
  COUNT(DISTINCT p1_.product_id) AS sclr_1
FROM
  filters_product_index f0_
  INNER JOIN Products p1_ ON f0_.catalog_product_id = p1_.product_id
  INNER JOIN Products_Categoryes p3_ ON p1_.product_id = p3_.product_id
  INNER JOIN Categories c2_ ON c2_.category_id = p3_.category_id
WHERE
  c2_.category_id = ?
  AND JSON_EXTRACT(
    f0_.features, '$.j_virobnik.j_samsung'
  ) IS NOT NULL
GROUP BY
  sclr_0
HAVING
  sclr_0 IS NOT NULL
  AND sclr_0 <> ''

SELECT CONCAT_WS(',', IF(JSON_EXTRACT(f0_.features, '$.j_tehnolog.j_4k_upscaling') IS NOT NULL, '4k-upscaling', NULL), IF(JSON_EXTRACT(f0_.features, '$.j_tehnolog.j_adaptive_sound') IS NOT NULL, 'adaptive-sound', NULL), IF(JSON_EXTRACT(f0_.features, '$.j_tehnolog.j_anynet') IS NOT NULL, 'anynet', NULL), IF(JSON_EXTRACT(f0_.features, '$.j_tehnolog.j_contrast_enhancer') IS NOT NULL, 'contrast-enhancer', NULL), IF(JSON_EXTRACT(f0_.features, '$.j_tehnolog.j_game_motion_plus') IS NOT NULL, 'game-motion-plus', NULL), IF(JSON_EXTRACT(f0_.features, '$.j_tehnolog.j_motion_xcelerator') IS NOT NULL, 'motion-xcelerator', NULL), IF(JSON_EXTRACT(f0_.features, '$.j_tehnolog.j_ots_lite') IS NOT NULL, 'ots-lite', NULL), IF(JSON_EXTRACT(f0_.features, '$.j_tehnolog.j_q_symphony') IS NOT NULL, 'q-symphony', NULL), IF(JSON_EXTRACT(f0_.features, '$.j_tehnolog.j_supreme_uhd_dimming') IS NOT NULL, 'supreme-uhd-dimming', NULL), IF(JSON_EXTRACT(f0_.features, '$.j_tehnolog.j_4k_x_reality_pro') IS NOT NULL, '4k-x-reality-pro', NULL), IF(JSON_EXTRACT(f0_.features, '$.j_tehnolog.j_apple_airplay_2') IS NOT NULL, 'apple-airplay-2', NULL), IF(JSON_EXTRACT(f0_.features, '$.j_tehnolog.j_apple_homekit') IS NOT NULL, 'apple-homekit', NULL), IF(JSON_EXTRACT(f0_.features, '$.j_tehnolog.j_chromecast') IS NOT NULL, 'chromecast', NULL), IF(JSON_EXTRACT(f0_.features, '$.j_tehnolog.j_dolby_atmos') IS NOT NULL, 'dolby-atmos', NULL), IF(JSON_EXTRACT(f0_.features, '$.j_tehnolog.j_dolby_audio') IS NOT NULL, 'dolby-audio', NULL), IF(JSON_EXTRACT(f0_.features, '$.j_tehnolog.j_dts') IS NOT NULL, 'dts', NULL), IF(JSON_EXTRACT(f0_.features, '$.j_tehnolog.j_dynamic_backlight_control') IS NOT NULL, 'dynamic-backlight-control', NULL), IF(JSON_EXTRACT(f0_.features, '$.j_tehnolog.j_dynamic_contrast_enhancer') IS NOT NULL, 'dynamic-contrast-enhancer', NULL), IF(JSON_EXTRACT(f0_.features, '$.j_tehnolog.j_frame_dimming') IS NOT NULL, 'frame-dimming', NULL), IF(JSON_EXTRACT(f0_.features, '$.j_tehnolog.j_game_menu') IS NOT NULL, 'game-menu', NULL), IF(JSON_EXTRACT(f0_.features, '$.j_tehnolog.j_live_colour') IS NOT NULL, 'live-colour', NULL), IF(JSON_EXTRACT(f0_.features, '$.j_tehnolog.j_motionflow_xr') IS NOT NULL, 'motionflow-xr', NULL), IF(JSON_EXTRACT(f0_.features, '$.j_tehnolog.j_object_based_hdr_remaster') IS NOT NULL, 'object-based-hdr-remaster', NULL), IF(JSON_EXTRACT(f0_.features, '$.j_tehnolog.j_triluminos_pro') IS NOT NULL, 'triluminos-pro', NULL), IF(JSON_EXTRACT(f0_.features, '$.j_tehnolog.j_ai_brightness_control') IS NOT NULL, 'ai-brightness-control', NULL), IF(JSON_EXTRACT(f0_.features, '$.j_tehnolog.j_ai_sound_pro') IS NOT NULL, 'ai-sound-pro', NULL), IF(JSON_EXTRACT(f0_.features, '$.j_tehnolog.j_bluetooth_surround_ready') IS NOT NULL, 'bluetooth-surround-ready', NULL), IF(JSON_EXTRACT(f0_.features, '$.j_tehnolog.j_clear_voice_pro') IS NOT NULL, 'clear-voice-pro', NULL), IF(JSON_EXTRACT(f0_.features, '$.j_tehnolog.j_dynamic_tone_mappng') IS NOT NULL, 'dynamic-tone-mappng', NULL), IF(JSON_EXTRACT(f0_.features, '$.j_tehnolog.j_lg_sound_sync') IS NOT NULL, 'lg-sound-sync', NULL)) AS sclr_0, COUNT(DISTINCT p1_.product_id) AS sclr_1 FROM filters_product_index f0_ INNER JOIN Products p1_ ON f0_.catalog_product_id = p1_.product_id INNER JOIN Products_Categoryes p3_ ON p1_.product_id = p3_.product_id INNER JOIN Categories c2_ ON c2_.category_id = p3_.category_id WHERE c2_.category_id = 1008 AND JSON_EXTRACT(f0_.features, '$.j_virobnik.j_samsung') IS NOT NULL GROUP BY sclr_0 HAVING sclr_0 IS NOT NULL AND sclr_0 <> '';

SELECT
  (
    CASE WHEN (
      JSON_EXTRACT(
        f0_.features, '$.j_protsesor_zobrazhennya.j_quantum_processor_lite_4k'
      ) IS NOT NULL
    ) THEN 'quantum-processor-lite-4k' WHEN (
      JSON_EXTRACT(
        f0_.features, '$.j_protsesor_zobrazhennya.j_4k_x1'
      ) IS NOT NULL
    ) THEN '4k-x1' WHEN (
      JSON_EXTRACT(
        f0_.features, '$.j_protsesor_zobrazhennya.j_ai_processor_4k_5_gen_7'
      ) IS NOT NULL
    ) THEN 'ai-processor-4k-5-gen-7' ELSE '' END
  ) AS sclr_0,
  COUNT(DISTINCT p1_.product_id) AS sclr_1
FROM
  filters_product_index f0_
  INNER JOIN Products p1_ ON f0_.catalog_product_id = p1_.product_id
  INNER JOIN Products_Categoryes p3_ ON p1_.product_id = p3_.product_id
  INNER JOIN Categories c2_ ON c2_.category_id = p3_.category_id
WHERE
  c2_.category_id = ?
  AND JSON_EXTRACT(
    f0_.features, '$.j_virobnik.j_samsung'
  ) IS NOT NULL
GROUP BY
  sclr_0
HAVING
  sclr_0 IS NOT NULL
  AND sclr_0 <> ''

SELECT (CASE WHEN (JSON_EXTRACT(f0_.features, '$.j_protsesor_zobrazhennya.j_quantum_processor_lite_4k') IS NOT NULL) THEN 'quantum-processor-lite-4k' WHEN (JSON_EXTRACT(f0_.features, '$.j_protsesor_zobrazhennya.j_4k_x1') IS NOT NULL) THEN '4k-x1' WHEN (JSON_EXTRACT(f0_.features, '$.j_protsesor_zobrazhennya.j_ai_processor_4k_5_gen_7') IS NOT NULL) THEN 'ai-processor-4k-5-gen-7' ELSE '' END) AS sclr_0, COUNT(DISTINCT p1_.product_id) AS sclr_1 FROM filters_product_index f0_ INNER JOIN Products p1_ ON f0_.catalog_product_id = p1_.product_id INNER JOIN Products_Categoryes p3_ ON p1_.product_id = p3_.product_id INNER JOIN Categories c2_ ON c2_.category_id = p3_.category_id WHERE c2_.category_id = 1008 AND JSON_EXTRACT(f0_.features, '$.j_virobnik.j_samsung') IS NOT NULL GROUP BY sclr_0 HAVING sclr_0 IS NOT NULL AND sclr_0 <> '';

SELECT
  (
    CASE WHEN (
      JSON_EXTRACT(
        f0_.features, '$.j_audosistema_vt.j_20'
      ) IS NOT NULL
    ) THEN '20' ELSE '' END
  ) AS sclr_0,
  COUNT(DISTINCT p1_.product_id) AS sclr_1
FROM
  filters_product_index f0_
  INNER JOIN Products p1_ ON f0_.catalog_product_id = p1_.product_id
  INNER JOIN Products_Categoryes p3_ ON p1_.product_id = p3_.product_id
  INNER JOIN Categories c2_ ON c2_.category_id = p3_.category_id
WHERE
  c2_.category_id = ?
  AND JSON_EXTRACT(
    f0_.features, '$.j_virobnik.j_samsung'
  ) IS NOT NULL
GROUP BY
  sclr_0
HAVING
  sclr_0 IS NOT NULL
  AND sclr_0 <> ''

SELECT (CASE WHEN (JSON_EXTRACT(f0_.features, '$.j_audosistema_vt.j_20') IS NOT NULL) THEN '20' ELSE '' END) AS sclr_0, COUNT(DISTINCT p1_.product_id) AS sclr_1 FROM filters_product_index f0_ INNER JOIN Products p1_ ON f0_.catalog_product_id = p1_.product_id INNER JOIN Products_Categoryes p3_ ON p1_.product_id = p3_.product_id INNER JOIN Categories c2_ ON c2_.category_id = p3_.category_id WHERE c2_.category_id = 1008 AND JSON_EXTRACT(f0_.features, '$.j_virobnik.j_samsung') IS NOT NULL GROUP BY sclr_0 HAVING sclr_0 IS NOT NULL AND sclr_0 <> '';

SELECT
  (
    CASE WHEN (
      JSON_EXTRACT(
        f0_.features, '$.j_dagonal_ekrana.j_55'
      ) IS NOT NULL
    ) THEN '55' WHEN (
      JSON_EXTRACT(
        f0_.features, '$.j_dagonal_ekrana.j_49'
      ) IS NOT NULL
    ) THEN '49' WHEN (
      JSON_EXTRACT(
        f0_.features, '$.j_dagonal_ekrana.j_65'
      ) IS NOT NULL
    ) THEN '65' ELSE '' END
  ) AS sclr_0,
  COUNT(DISTINCT p1_.product_id) AS sclr_1
FROM
  filters_product_index f0_
  INNER JOIN Products p1_ ON f0_.catalog_product_id = p1_.product_id
  INNER JOIN Products_Categoryes p3_ ON p1_.product_id = p3_.product_id
  INNER JOIN Categories c2_ ON c2_.category_id = p3_.category_id
WHERE
  c2_.category_id = ?
  AND JSON_EXTRACT(
    f0_.features, '$.j_virobnik.j_samsung'
  ) IS NOT NULL
GROUP BY
  sclr_0
HAVING
  sclr_0 IS NOT NULL
  AND sclr_0 <> ''

SELECT (CASE WHEN (JSON_EXTRACT(f0_.features, '$.j_dagonal_ekrana.j_55') IS NOT NULL) THEN '55' WHEN (JSON_EXTRACT(f0_.features, '$.j_dagonal_ekrana.j_49') IS NOT NULL) THEN '49' WHEN (JSON_EXTRACT(f0_.features, '$.j_dagonal_ekrana.j_65') IS NOT NULL) THEN '65' ELSE '' END) AS sclr_0, COUNT(DISTINCT p1_.product_id) AS sclr_1 FROM filters_product_index f0_ INNER JOIN Products p1_ ON f0_.catalog_product_id = p1_.product_id INNER JOIN Products_Categoryes p3_ ON p1_.product_id = p3_.product_id INNER JOIN Categories c2_ ON c2_.category_id = p3_.category_id WHERE c2_.category_id = 1008 AND JSON_EXTRACT(f0_.features, '$.j_virobnik.j_samsung') IS NOT NULL GROUP BY sclr_0 HAVING sclr_0 IS NOT NULL AND sclr_0 <> '';

SELECT
  (
    CASE WHEN (
      JSON_EXTRACT(
        f0_.features, '$.j_tip_matrits.j_qled'
      ) IS NOT NULL
    ) THEN 'qled' WHEN (
      JSON_EXTRACT(
        f0_.features, '$.j_tip_matrits.j_led'
      ) IS NOT NULL
    ) THEN 'led' ELSE '' END
  ) AS sclr_0,
  COUNT(DISTINCT p1_.product_id) AS sclr_1
FROM
  filters_product_index f0_
  INNER JOIN Products p1_ ON f0_.catalog_product_id = p1_.product_id
  INNER JOIN Products_Categoryes p3_ ON p1_.product_id = p3_.product_id
  INNER JOIN Categories c2_ ON c2_.category_id = p3_.category_id
WHERE
  c2_.category_id = ?
  AND JSON_EXTRACT(
    f0_.features, '$.j_virobnik.j_samsung'
  ) IS NOT NULL
GROUP BY
  sclr_0
HAVING
  sclr_0 IS NOT NULL
  AND sclr_0 <> ''

SELECT (CASE WHEN (JSON_EXTRACT(f0_.features, '$.j_tip_matrits.j_qled') IS NOT NULL) THEN 'qled' WHEN (JSON_EXTRACT(f0_.features, '$.j_tip_matrits.j_led') IS NOT NULL) THEN 'led' ELSE '' END) AS sclr_0, COUNT(DISTINCT p1_.product_id) AS sclr_1 FROM filters_product_index f0_ INNER JOIN Products p1_ ON f0_.catalog_product_id = p1_.product_id INNER JOIN Products_Categoryes p3_ ON p1_.product_id = p3_.product_id INNER JOIN Categories c2_ ON c2_.category_id = p3_.category_id WHERE c2_.category_id = 1008 AND JSON_EXTRACT(f0_.features, '$.j_virobnik.j_samsung') IS NOT NULL GROUP BY sclr_0 HAVING sclr_0 IS NOT NULL AND sclr_0 <> '';

SELECT
  k0_.id AS id_0,
  k0_.name AS name_1,
  k0_.code AS code_2,
  k0_.active AS active_3,
  k0_.default AS default_4
FROM
  kk_language k0_
WHERE
  k0_.code = ?
LIMIT
  1