Symfony Profiler

SELECT
  c0_.`id` AS id_0,
  c0_.`url` AS url_1,
  c0_.`code` AS code_2,
  c0_.`name` AS name_3,
  c0_.`alternate_name` AS alternate_name_4,
  c0_.`name_full` AS name_full_5,
  f1_.`id` AS id_6,
  f1_.`url` AS url_7,
  f1_.`unid` AS unid_8,
  f2_.`id` AS id_9,
  f1_.`url` AS url_10,
  f1_.`name` AS name_11,
  (
    SELECT
      COUNT(p3_.`star`) AS sclr_13
    FROM
      `product_reviews_cache` p3_
    WHERE
      p3_.`sku` = c0_.`code`
  ) AS sclr_12,
  (
    SELECT
      SUM(p4_.`star`) AS sclr_15
    FROM
      `product_reviews_cache` p4_
    WHERE
      p4_.`sku` = c0_.`code`
  ) AS sclr_14
FROM
  `collection` c0_
  INNER JOIN `factory` f1_ ON c0_.factory = f1_.id
  INNER JOIN `filters` f2_ ON f1_.filter = f2_.id
  INNER JOIN `list_country` l5_ ON f1_.country = l5_.id
  LEFT JOIN `locale_url` l6_ ON f2_.id = l6_.filter_id
  LEFT JOIN `filter_pages` f7_ ON f2_.page_id = f7_.id
WHERE
  f1_.filter IS NOT NULL
  AND c0_.factory <> ''
  AND f1_.`status` = ?
  AND (
    c0_.`test_access` IS NULL
    OR c0_.`test_access` = 0
  )
  AND (
    f1_.`test_access` IS NULL
    OR f1_.`test_access` = 0
  )
  AND c0_.`status` = ?
  AND c0_.`status` = ?
  AND f1_.`status` = ?
ORDER BY
  c0_.`id` ASC

SELECT c0_.`id` AS id_0, c0_.`url` AS url_1, c0_.`code` AS code_2, c0_.`name` AS name_3, c0_.`alternate_name` AS alternate_name_4, c0_.`name_full` AS name_full_5, f1_.`id` AS id_6, f1_.`url` AS url_7, f1_.`unid` AS unid_8, f2_.`id` AS id_9, f1_.`url` AS url_10, f1_.`name` AS name_11, (SELECT COUNT(p3_.`star`) AS sclr_13 FROM `product_reviews_cache` p3_ WHERE p3_.`sku` = c0_.`code`) AS sclr_12, (SELECT SUM(p4_.`star`) AS sclr_15 FROM `product_reviews_cache` p4_ WHERE p4_.`sku` = c0_.`code`) AS sclr_14 FROM `collection` c0_ INNER JOIN `factory` f1_ ON c0_.factory = f1_.id INNER JOIN `filters` f2_ ON f1_.filter = f2_.id INNER JOIN `list_country` l5_ ON f1_.country = l5_.id LEFT JOIN `locale_url` l6_ ON f2_.id = l6_.filter_id LEFT JOIN `filter_pages` f7_ ON f2_.page_id = f7_.id WHERE f1_.filter IS NOT NULL AND c0_.factory <> '' AND f1_.`status` = 1 AND (c0_.`test_access` IS NULL OR c0_.`test_access` = 0) AND (f1_.`test_access` IS NULL OR f1_.`test_access` = 0) AND c0_.`status` = 1 AND c0_.`status` = 1 AND f1_.`status` = 1 ORDER BY c0_.`id` ASC;

SELECT
  a0_.`id` AS id_0,
  a0_.`code` AS code_1,
  a0_.`alternate_name` AS alternate_name_2,
  a0_.`urla` AS urla_3,
  a1_.`file` AS file_4,
  a0_.`price_euro` AS price_euro_5,
  a0_.`price_usd` AS price_usd_6,
  a0_.`price_prx` AS price_prx_7,
  a0_.`size_x` AS size_x_8,
  a0_.`size_y` AS size_y_9,
  a0_.`size_gb_x` AS size_gb_x_10,
  a0_.`size_gb_y` AS size_gb_y_11,
  a0_.`thick` AS thick_12,
  a0_.`weight` AS weight_13,
  a1_.`file_size2_x` AS file_size2_x_14,
  a1_.`file_size2_y` AS file_size2_y_15,
  l2_.`alias` AS alias_16,
  l3_.`alias` AS alias_17,
  l4_.`alias` AS alias_18,
  l5_.`alias` AS alias_19,
  l6_.`alias` AS alias_20,
  l7_.`alias` AS alias_21,
  c8_.`code` AS code_22,
  c8_.`name` AS name_23,
  c8_.`alternate_name` AS alternate_name_24,
  c8_.`url` AS url_25,
  f9_.`name` AS name_26,
  f9_.`url` AS url_27,
  l10_.`alias` AS alias_28,
  l11_.`alias` AS alias_29,
  l12_.`alias` AS alias_30
FROM
  `article` a0_
  LEFT JOIN `list_type` l2_ ON a0_.type = l2_.id
  LEFT JOIN `list_edge_type` l3_ ON a0_.edge_type = l3_.id
  LEFT JOIN `list_shape` l4_ ON a0_.shape = l4_.id
  LEFT JOIN `list_material` l5_ ON a0_.material = l5_.id
  LEFT JOIN `list_sliding` l6_ ON a0_.sliding = l6_.id
  LEFT JOIN `list_off_shade` l7_ ON a0_.off_shade = l7_.id
  LEFT JOIN `list_using` l10_ ON a0_.using = l10_.id
  LEFT JOIN `collection` c8_ ON a0_.collection = c8_.id
  LEFT JOIN `list_price` l12_ ON a0_.category_price = l12_.id
  LEFT JOIN `list_delivery` l13_ ON a0_.delivery = l13_.id
  LEFT JOIN `article_detail` a1_ ON a0_.id = a1_.article_id
  LEFT JOIN `factory` f9_ ON c8_.factory = f9_.id
  LEFT JOIN `list_country` l11_ ON f9_.country = l11_.id
WHERE
  c8_.`id` IS NOT NULL
  AND l13_.`id` <> 6
  AND a0_.`price_euro` > 0
  AND c8_.`status` IN (1, 2, 3, 4, 7)
  AND (
    c8_.`url` IS NOT NULL
    AND c8_.`url` <> ''
  )
  AND f9_.`status` = 1
  AND a1_.`file` IS NOT NULL
  AND a0_.`id` IN (?)

SELECT a0_.`id` AS id_0, a0_.`code` AS code_1, a0_.`alternate_name` AS alternate_name_2, a0_.`urla` AS urla_3, a1_.`file` AS file_4, a0_.`price_euro` AS price_euro_5, a0_.`price_usd` AS price_usd_6, a0_.`price_prx` AS price_prx_7, a0_.`size_x` AS size_x_8, a0_.`size_y` AS size_y_9, a0_.`size_gb_x` AS size_gb_x_10, a0_.`size_gb_y` AS size_gb_y_11, a0_.`thick` AS thick_12, a0_.`weight` AS weight_13, a1_.`file_size2_x` AS file_size2_x_14, a1_.`file_size2_y` AS file_size2_y_15, l2_.`alias` AS alias_16, l3_.`alias` AS alias_17, l4_.`alias` AS alias_18, l5_.`alias` AS alias_19, l6_.`alias` AS alias_20, l7_.`alias` AS alias_21, c8_.`code` AS code_22, c8_.`name` AS name_23, c8_.`alternate_name` AS alternate_name_24, c8_.`url` AS url_25, f9_.`name` AS name_26, f9_.`url` AS url_27, l10_.`alias` AS alias_28, l11_.`alias` AS alias_29, l12_.`alias` AS alias_30 FROM `article` a0_ LEFT JOIN `list_type` l2_ ON a0_.type = l2_.id LEFT JOIN `list_edge_type` l3_ ON a0_.edge_type = l3_.id LEFT JOIN `list_shape` l4_ ON a0_.shape = l4_.id LEFT JOIN `list_material` l5_ ON a0_.material = l5_.id LEFT JOIN `list_sliding` l6_ ON a0_.sliding = l6_.id LEFT JOIN `list_off_shade` l7_ ON a0_.off_shade = l7_.id LEFT JOIN `list_using` l10_ ON a0_.using = l10_.id LEFT JOIN `collection` c8_ ON a0_.collection = c8_.id LEFT JOIN `list_price` l12_ ON a0_.category_price = l12_.id LEFT JOIN `list_delivery` l13_ ON a0_.delivery = l13_.id LEFT JOIN `article_detail` a1_ ON a0_.id = a1_.article_id LEFT JOIN `factory` f9_ ON c8_.factory = f9_.id LEFT JOIN `list_country` l11_ ON f9_.country = l11_.id WHERE c8_.`id` IS NOT NULL AND l13_.`id` <> 6 AND a0_.`price_euro` > 0 AND c8_.`status` IN (1, 2, 3, 4, 7) AND (c8_.`url` IS NOT NULL AND c8_.`url` <> '') AND f9_.`status` = 1 AND a1_.`file` IS NOT NULL AND a0_.`id` IN ('238848253');

SELECT
  f.id,
  f.rank AS `rank`,
  f.alt_name AS `altName`,
  f.old_command AS `sphinxName`,
  f.old_id AS `sphinxId`,
  htmlshow.de AS `isHtmlShow`,
  fp.name_menu_de AS `nameMenu`,
  fp.name_many_de AS `nameMany`,
  fp.name_single_de AS `nameSingle`,
  fp.html_de AS `html`,
  fp.description_de AS `description`,
  metadesc.de AS `metaDescriptionName`,
  par.count AS `count`,
  par.code AS `code`,
  par.is_enable AS `isEnable`,
  gr.id AS `groupId`,
  gr.alt_name AS `groupAltName`,
  gpname.de AS `groupName`,
  url.de AS `slug`,
  url.ru AS `slug.ru`,
  url.en AS `slug.en`,
  url.it AS `slug.it`,
  url.es AS `slug.es`,
  url.fr AS `slug.fr`,
  url.de AS `slug.de`,
  url.pl AS `slug.pl`,
  url.nl AS `slug.nl`,
  url.fi AS `slug.fi`,
  url.sv AS `slug.sv`,
  b.id AS `brandId`,
  b.status AS `brandStatus`,
  b.stated_at AS `brandStatedAt`,
  b.type AS `brandType`,
  b.name AS `brandName`,
  f.logo AS `brandLogo`,
  f.logo_url AS `brandLogoUrl`,
  b.sound AS `brandSound`,
  b.video AS `brandVideo`,
  cn.id AS `countryId`,
  cnfp.name_single_de AS `countryName`,
  cnurl.de AS `countrySlug`,
  cnpar.code AS `countryCode`
FROM
  filters f
  LEFT JOIN filter_pages fp ON fp.id = f.page_id
  LEFT JOIN filter_params par ON par.id = f.param_id
  LEFT JOIN filter_groups gr ON gr.id = f.group_id
  LEFT JOIN locale_text gpname ON gpname.filter_group_name = gr.id
  LEFT JOIN locale_text metadesc ON metadesc.filter_name_for_meta_descr_id = f.id
  LEFT JOIN locale_url url ON url.filter_id = f.id
  LEFT JOIN locale_bool htmlshow ON htmlshow.filter_html_show_id = f.id
  LEFT JOIN factory b ON b.id = f.brand
  LEFT JOIN filters cn ON cn.id = f.country_id
  LEFT JOIN filter_pages cnfp ON cnfp.id = cn.page_id
  LEFT JOIN locale_url cnurl ON cnurl.filter_id = cn.id
  LEFT JOIN filter_params cnpar ON cnpar.id = cn.param_id
WHERE
  url.ru = :slug
  OR url.en = :slug
  OR url.it = :slug
  OR url.es = :slug
  OR url.fr = :slug
  OR url.de = :slug
  OR url.pl = :slug
  OR url.nl = :slug
  OR url.fi = :slug
  OR url.sv = :slug

SELECT f.id, f.rank AS `rank`, f.alt_name AS `altName`, f.old_command AS `sphinxName`, f.old_id AS `sphinxId`, htmlshow.de AS `isHtmlShow`, fp.name_menu_de AS `nameMenu`, fp.name_many_de AS `nameMany`, fp.name_single_de AS `nameSingle`, fp.html_de AS `html`, fp.description_de AS `description`, metadesc.de AS `metaDescriptionName`, par.count AS `count`, par.code AS `code`, par.is_enable AS `isEnable`, gr.id AS `groupId`, gr.alt_name AS `groupAltName`, gpname.de AS `groupName`, url.de AS `slug`, url.ru AS `slug.ru`, url.en AS `slug.en`, url.it AS `slug.it`, url.es AS `slug.es`, url.fr AS `slug.fr`, url.de AS `slug.de`, url.pl AS `slug.pl`, url.nl AS `slug.nl`, url.fi AS `slug.fi`, url.sv AS `slug.sv`, b.id AS `brandId`, b.status AS `brandStatus`, b.stated_at AS `brandStatedAt`, b.type AS `brandType`, b.name AS `brandName`, f.logo AS `brandLogo`, f.logo_url AS `brandLogoUrl`, b.sound AS `brandSound`, b.video AS `brandVideo`, cn.id AS `countryId`, cnfp.name_single_de AS `countryName`, cnurl.de AS `countrySlug`, cnpar.code AS `countryCode` FROM filters f LEFT JOIN filter_pages fp ON fp.id = f.page_id LEFT JOIN filter_params par ON par.id = f.param_id LEFT JOIN filter_groups gr ON gr.id = f.group_id LEFT JOIN locale_text gpname ON gpname.filter_group_name = gr.id LEFT JOIN locale_text metadesc ON metadesc.filter_name_for_meta_descr_id = f.id LEFT JOIN locale_url url ON url.filter_id = f.id LEFT JOIN locale_bool htmlshow ON htmlshow.filter_html_show_id = f.id LEFT JOIN factory b ON b.id = f.brand LEFT JOIN filters cn ON cn.id = f.country_id LEFT JOIN filter_pages cnfp ON cnfp.id = cn.page_id LEFT JOIN locale_url cnurl ON cnurl.filter_id = cn.id LEFT JOIN filter_params cnpar ON cnpar.id = cn.param_id WHERE url.ru = 'tuscania' OR url.en = 'tuscania' OR url.it = 'tuscania' OR url.es = 'tuscania' OR url.fr = 'tuscania' OR url.de = 'tuscania' OR url.pl = 'tuscania' OR url.nl = 'tuscania' OR url.fi = 'tuscania' OR url.sv = 'tuscania' ;

SELECT
  a0_.`id` AS id_0,
  f1_.`name_single_en` AS name_single_en_1,
  f1_.`name_single_it` AS name_single_it_2,
  f1_.`name_single_es` AS name_single_es_3,
  f1_.`name_single_fr` AS name_single_fr_4,
  f1_.`name_single_de` AS name_single_de_5,
  f1_.`name_single_pl` AS name_single_pl_6,
  f1_.`name_single_ua` AS name_single_ua_7,
  f1_.`name_single_ru` AS name_single_ru_8,
  f1_.`name_single_sv` AS name_single_sv_9,
  f1_.`name_single_da` AS name_single_da_10
FROM
  `article` a0_
  LEFT JOIN `collection` c2_ ON a0_.collection = c2_.id
  LEFT JOIN collection_filters c4_ ON c2_.id = c4_.collection_id
  LEFT JOIN `filters` f3_ ON f3_.id = c4_.filter_id
  LEFT JOIN `filter_pages` f1_ ON f3_.page_id = f1_.id
  INNER JOIN `filter_groups` f5_ ON f3_.group_id = f5_.id
  AND (f5_.`id` = 419)
WHERE
  a0_.`id` IN (?)

SELECT a0_.`id` AS id_0, f1_.`name_single_en` AS name_single_en_1, f1_.`name_single_it` AS name_single_it_2, f1_.`name_single_es` AS name_single_es_3, f1_.`name_single_fr` AS name_single_fr_4, f1_.`name_single_de` AS name_single_de_5, f1_.`name_single_pl` AS name_single_pl_6, f1_.`name_single_ua` AS name_single_ua_7, f1_.`name_single_ru` AS name_single_ru_8, f1_.`name_single_sv` AS name_single_sv_9, f1_.`name_single_da` AS name_single_da_10 FROM `article` a0_ LEFT JOIN `collection` c2_ ON a0_.collection = c2_.id LEFT JOIN collection_filters c4_ ON c2_.id = c4_.collection_id LEFT JOIN `filters` f3_ ON f3_.id = c4_.filter_id LEFT JOIN `filter_pages` f1_ ON f3_.page_id = f1_.id INNER JOIN `filter_groups` f5_ ON f3_.group_id = f5_.id AND (f5_.`id` = 419) WHERE a0_.`id` IN (238848253);

SELECT
  COUNT(c0_.`id`) AS sclr_0
FROM
  `collection` c0_
  LEFT JOIN `factory` f1_ ON c0_.factory = f1_.id
  LEFT JOIN `article` a2_ ON c0_.id = a2_.collection
WHERE
  c0_.factory <> ''
  AND f1_.`id` <> 99
  AND f1_.`status` = ?
  AND c0_.`status` = ?
  AND c0_.`archive` <> 1
  AND a2_.`price_euro` IS NOT NULL
  AND (
    c0_.`test_access` IS NULL
    OR c0_.`test_access` = 0
  )
  AND (
    f1_.`test_access` IS NULL
    OR f1_.`test_access` = 0
  )
  AND f1_.`id` IN (398780)
GROUP BY
  c0_.`id`
ORDER BY
  c0_.`name` ASC,
  c0_.`publish_date` ASC

SELECT COUNT(c0_.`id`) AS sclr_0 FROM `collection` c0_ LEFT JOIN `factory` f1_ ON c0_.factory = f1_.id LEFT JOIN `article` a2_ ON c0_.id = a2_.collection WHERE c0_.factory <> '' AND f1_.`id` <> 99 AND f1_.`status` = 1 AND c0_.`status` = 1 AND c0_.`archive` <> 1 AND a2_.`price_euro` IS NOT NULL AND (c0_.`test_access` IS NULL OR c0_.`test_access` = 0) AND (f1_.`test_access` IS NULL OR f1_.`test_access` = 0) AND f1_.`id` IN (398780) GROUP BY c0_.`id` ORDER BY c0_.`name` ASC, c0_.`publish_date` ASC;

SELECT
  a0_.`id` AS id_0,
  l1_.`alias` AS alias_1
FROM
  `article` a0_
  INNER JOIN article_texture a2_ ON a0_.id = a2_.article_id
  INNER JOIN `list_texture` l1_ ON l1_.id = a2_.texture_id
WHERE
  a0_.`id` IN (?)

SELECT a0_.`id` AS id_0, l1_.`alias` AS alias_1 FROM `article` a0_ INNER JOIN article_texture a2_ ON a0_.id = a2_.article_id INNER JOIN `list_texture` l1_ ON l1_.id = a2_.texture_id WHERE a0_.`id` IN (238848253);

SELECT
  a0_.`id` AS id_0,
  f1_.`name` AS name_1
FROM
  `article` a0_
  LEFT JOIN `collection` c2_ ON a0_.collection = c2_.id
  LEFT JOIN collection_filters c3_ ON c2_.id = c3_.collection_id
  LEFT JOIN `filters` f1_ ON f1_.id = c3_.filter_id
  INNER JOIN `filter_groups` f4_ ON f1_.group_id = f4_.id
  AND (f4_.`id` = 420)
WHERE
  a0_.`id` IN (?)

SELECT a0_.`id` AS id_0, f1_.`name` AS name_1 FROM `article` a0_ LEFT JOIN `collection` c2_ ON a0_.collection = c2_.id LEFT JOIN collection_filters c3_ ON c2_.id = c3_.collection_id LEFT JOIN `filters` f1_ ON f1_.id = c3_.filter_id INNER JOIN `filter_groups` f4_ ON f1_.group_id = f4_.id AND (f4_.`id` = 420) WHERE a0_.`id` IN (238848253);

SELECT
  a0_.`id` AS id_0,
  f1_.`name` AS name_1
FROM
  `article` a0_
  LEFT JOIN `collection` c2_ ON a0_.collection = c2_.id
  LEFT JOIN collection_filters c3_ ON c2_.id = c3_.collection_id
  LEFT JOIN `filters` f1_ ON f1_.id = c3_.filter_id
  INNER JOIN `filter_groups` f4_ ON f1_.group_id = f4_.id
  AND (
    f4_.`id` = 417
    AND f1_.`id` <> 10546
  )
WHERE
  a0_.`id` IN (?)

SELECT a0_.`id` AS id_0, f1_.`name` AS name_1 FROM `article` a0_ LEFT JOIN `collection` c2_ ON a0_.collection = c2_.id LEFT JOIN collection_filters c3_ ON c2_.id = c3_.collection_id LEFT JOIN `filters` f1_ ON f1_.id = c3_.filter_id INNER JOIN `filter_groups` f4_ ON f1_.group_id = f4_.id AND (f4_.`id` = 417 AND f1_.`id` <> 10546) WHERE a0_.`id` IN (238848253);

SELECT
  DISTINCT a0_.`id` AS id_0,
  l1_.`alias` AS alias_1
FROM
  `article` a0_
  LEFT JOIN interior_article i3_ ON a0_.id = i3_.article_id
  LEFT JOIN `interior` i2_ ON i2_.id = i3_.interior_id
  INNER JOIN interior_apply i4_ ON i2_.id = i4_.interior_id
  INNER JOIN `list_apply` l1_ ON l1_.id = i4_.apply_id
WHERE
  a0_.`id` IN (?)

SELECT DISTINCT a0_.`id` AS id_0, l1_.`alias` AS alias_1 FROM `article` a0_ LEFT JOIN interior_article i3_ ON a0_.id = i3_.article_id LEFT JOIN `interior` i2_ ON i2_.id = i3_.interior_id INNER JOIN interior_apply i4_ ON i2_.id = i4_.interior_id INNER JOIN `list_apply` l1_ ON l1_.id = i4_.apply_id WHERE a0_.`id` IN (238848253);

SELECT
  a0_.`id` AS id_0,
  l1_.`alias` AS alias_1
FROM
  `article` a0_
  INNER JOIN article_surface a2_ ON a0_.id = a2_.article_id
  INNER JOIN `list_surface` l1_ ON l1_.id = a2_.surface_id
WHERE
  a0_.`id` IN (?)

SELECT a0_.`id` AS id_0, l1_.`alias` AS alias_1 FROM `article` a0_ INNER JOIN article_surface a2_ ON a0_.id = a2_.article_id INNER JOIN `list_surface` l1_ ON l1_.id = a2_.surface_id WHERE a0_.`id` IN (238848253);

SELECT
  a0_.`id` AS id_0,
  l1_.`alias` AS alias_1
FROM
  `article` a0_
  INNER JOIN article_color a2_ ON a0_.id = a2_.article_id
  INNER JOIN `list_color` l1_ ON l1_.id = a2_.color_id
WHERE
  a0_.`id` IN (?)

SELECT a0_.`id` AS id_0, l1_.`alias` AS alias_1 FROM `article` a0_ INNER JOIN article_color a2_ ON a0_.id = a2_.article_id INNER JOIN `list_color` l1_ ON l1_.id = a2_.color_id WHERE a0_.`id` IN (238848253);

SELECT
  a0_.`id` AS id_0,
  l1_.`alias` AS alias_1
FROM
  `article` a0_
  INNER JOIN article_style a2_ ON a0_.id = a2_.article_id
  INNER JOIN `list_style` l1_ ON l1_.id = a2_.style_id
WHERE
  a0_.`id` IN (?)

SELECT a0_.`id` AS id_0, l1_.`alias` AS alias_1 FROM `article` a0_ INNER JOIN article_style a2_ ON a0_.id = a2_.article_id INNER JOIN `list_style` l1_ ON l1_.id = a2_.style_id WHERE a0_.`id` IN (238848253);

SELECT
  a0_.`id` AS id_0,
  l1_.`alias` AS alias_1
FROM
  `article` a0_
  INNER JOIN article_motiv a2_ ON a0_.id = a2_.article_id
  INNER JOIN `list_motiv` l1_ ON l1_.id = a2_.motiv_id
WHERE
  a0_.`id` IN (?)

SELECT a0_.`id` AS id_0, l1_.`alias` AS alias_1 FROM `article` a0_ INNER JOIN article_motiv a2_ ON a0_.id = a2_.article_id INNER JOIN `list_motiv` l1_ ON l1_.id = a2_.motiv_id WHERE a0_.`id` IN (238848253);

SELECT
  f2.id,
  f2.name,
  f2.old_command,
  f2.old_id,
  GROUP_CONCAT(f.id) AS ids,
  GROUP_CONCAT(f.old_id) AS old_ids
FROM
  `filters` f
  LEFT JOIN filters f2 ON f.parent_id = f2.id
  LEFT JOIN filter_params p ON f.param_id = p.id
WHERE
  f.parent_id IS NOT NULL
  AND p.is_enable = 1
  AND p.show_menu != 0
GROUP BY
  f.parent_id;

SELECT
    f2.id,
    f2.name,
    f2.old_command,
    f2.old_id,
    GROUP_CONCAT(f.id) AS ids,
    GROUP_CONCAT(f.old_id) AS old_ids
FROM
    `filters` f
LEFT JOIN filters f2 ON
    f.parent_id = f2.id
LEFT JOIN filter_params p ON
    f.param_id = p.id
WHERE
    f.parent_id IS NOT NULL AND p.is_enable = 1  AND p.show_menu != 0  
GROUP BY
    f.parent_id;;

SELECT
  f0_.`id` AS id_0,
  f0_.`old_command` AS old_command_1,
  f0_.`old_id` AS old_id_2,
  f0_.`left_menu` AS left_menu_3,
  f1_.`id` AS id_4,
  f0_.`important` AS important_5,
  l2_.`de` AS de_6,
  f3_.`name_menu_de` AS name_menu_de_7,
  f4_.`alt_name` AS alt_name_8,
  f5_.`count` AS count_9,
  f0_.`id` AS id_10,
  f0_.`name` AS name_11,
  f0_.`alt_name` AS alt_name_12,
  f0_.`left_menu` AS left_menu_13,
  f0_.`sort` AS sort_14,
  f0_.`important` AS important_15,
  f0_.`old_command` AS old_command_16,
  f0_.`old_id` AS old_id_17,
  f0_.`sub_key` AS sub_key_18,
  f0_.`parent_key` AS parent_key_19,
  f0_.`rank` AS rank_20,
  f0_.`icon` AS icon_21,
  f0_.`icon_url` AS icon_url_22,
  f0_.`logo` AS logo_23,
  f0_.`logo_url` AS logo_url_24,
  f0_.`created_at` AS created_at_25,
  f0_.`updated_at` AS updated_at_26,
  f6_.`id` AS id_27,
  f6_.`name` AS name_28,
  f6_.`alt_name` AS alt_name_29,
  f6_.`left_menu` AS left_menu_30,
  f6_.`sort` AS sort_31,
  f6_.`important` AS important_32,
  f6_.`old_command` AS old_command_33,
  f6_.`old_id` AS old_id_34,
  f6_.`sub_key` AS sub_key_35,
  f6_.`parent_key` AS parent_key_36,
  f6_.`rank` AS rank_37,
  f6_.`icon` AS icon_38,
  f6_.`icon_url` AS icon_url_39,
  f6_.`logo` AS logo_40,
  f6_.`logo_url` AS logo_url_41,
  f6_.`created_at` AS created_at_42,
  f6_.`updated_at` AS updated_at_43
FROM
  `filters` f0_
  LEFT JOIN `locale_url` l2_ ON f0_.id = l2_.filter_id
  LEFT JOIN `filter_pages` f3_ ON f0_.page_id = f3_.id
  LEFT JOIN `filter_params` f5_ ON f0_.param_id = f5_.id
  LEFT JOIN `filter_groups` f4_ ON f0_.group_id = f4_.id
  LEFT JOIN `filters` f6_ ON f0_.country_id = f6_.id
  LEFT JOIN `filters` f1_ ON f0_.parent_id = f1_.id
WHERE
  f5_.`is_enable` = 1
  AND (
    f5_.`show_menu` = 1
    OR f5_.`show_menu_advanced` = 1
  )
  AND l2_.`de` IS NOT NULL
  AND f5_.`count` > 0
  AND f4_.`alt_name` IN (?)
ORDER BY
  f0_.`sort` ASC,
  f0_.`name` ASC

SELECT f0_.`id` AS id_0, f0_.`old_command` AS old_command_1, f0_.`old_id` AS old_id_2, f0_.`left_menu` AS left_menu_3, f1_.`id` AS id_4, f0_.`important` AS important_5, l2_.`de` AS de_6, f3_.`name_menu_de` AS name_menu_de_7, f4_.`alt_name` AS alt_name_8, f5_.`count` AS count_9, f0_.`id` AS id_10, f0_.`name` AS name_11, f0_.`alt_name` AS alt_name_12, f0_.`left_menu` AS left_menu_13, f0_.`sort` AS sort_14, f0_.`important` AS important_15, f0_.`old_command` AS old_command_16, f0_.`old_id` AS old_id_17, f0_.`sub_key` AS sub_key_18, f0_.`parent_key` AS parent_key_19, f0_.`rank` AS rank_20, f0_.`icon` AS icon_21, f0_.`icon_url` AS icon_url_22, f0_.`logo` AS logo_23, f0_.`logo_url` AS logo_url_24, f0_.`created_at` AS created_at_25, f0_.`updated_at` AS updated_at_26, f6_.`id` AS id_27, f6_.`name` AS name_28, f6_.`alt_name` AS alt_name_29, f6_.`left_menu` AS left_menu_30, f6_.`sort` AS sort_31, f6_.`important` AS important_32, f6_.`old_command` AS old_command_33, f6_.`old_id` AS old_id_34, f6_.`sub_key` AS sub_key_35, f6_.`parent_key` AS parent_key_36, f6_.`rank` AS rank_37, f6_.`icon` AS icon_38, f6_.`icon_url` AS icon_url_39, f6_.`logo` AS logo_40, f6_.`logo_url` AS logo_url_41, f6_.`created_at` AS created_at_42, f6_.`updated_at` AS updated_at_43 FROM `filters` f0_ LEFT JOIN `locale_url` l2_ ON f0_.id = l2_.filter_id LEFT JOIN `filter_pages` f3_ ON f0_.page_id = f3_.id LEFT JOIN `filter_params` f5_ ON f0_.param_id = f5_.id LEFT JOIN `filter_groups` f4_ ON f0_.group_id = f4_.id LEFT JOIN `filters` f6_ ON f0_.country_id = f6_.id LEFT JOIN `filters` f1_ ON f0_.parent_id = f1_.id WHERE f5_.`is_enable` = 1 AND (f5_.`show_menu` = 1 OR f5_.`show_menu_advanced` = 1) AND l2_.`de` IS NOT NULL AND f5_.`count` > 0 AND f4_.`alt_name` IN ('effect', 'style', 'samples', 'price', 'color', 'using', 'brand') ORDER BY f0_.`sort` ASC, f0_.`name` ASC;