Symfony Profiler

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
  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
  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
FROM
  `geo_country` g1_
  LEFT JOIN factory_hide_countries f2_ ON g1_.id = f2_.country_id
  LEFT JOIN `factory` f0_ ON f0_.id = f2_.factory_id
WHERE
  g1_.`code` = ?

SELECT f0_.`id` AS id_0 FROM `geo_country` g1_ LEFT JOIN factory_hide_countries f2_ ON g1_.id = f2_.country_id LEFT JOIN `factory` f0_ ON f0_.id = f2_.factory_id WHERE g1_.`code` = 'lu';

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_advanced != 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_advanced != 0 
GROUP BY
    f.parent_id;;

SELECT
  t0.`id` AS id_1,
  t0.`name` AS name_2,
  t0.`alias` AS alias_3,
  t0.`sort` AS sort_4,
  t0.`count` AS count_5,
  t0.`hide` AS hide_6,
  t0.`important` AS important_7
FROM
  `list_measure` t0
WHERE
  t0.`hide` = ?

SELECT t0.`id` AS id_1, t0.`name` AS name_2, t0.`alias` AS alias_3, t0.`sort` AS sort_4, t0.`count` AS count_5, t0.`hide` AS hide_6, t0.`important` AS important_7 FROM `list_measure` t0 WHERE t0.`hide` = 0;

SELECT
  l0_.`id` AS id_0,
  l0_.`name` AS name_1,
  l0_.`alias` AS alias_2,
  l0_.`sort` AS sort_3,
  l0_.`count` AS count_4,
  l0_.`hide` AS hide_5,
  l0_.`important` AS important_6
FROM
  `list_material` l0_
ORDER BY
  l0_.`sort` DESC,
  l0_.`name` ASC

SELECT l0_.`id` AS id_0, l0_.`name` AS name_1, l0_.`alias` AS alias_2, l0_.`sort` AS sort_3, l0_.`count` AS count_4, l0_.`hide` AS hide_5, l0_.`important` AS important_6 FROM `list_material` l0_ ORDER BY l0_.`sort` DESC, l0_.`name` ASC;

SELECT
  i.id AS iId,
  i.url AS iUrl,
  i.name AS iName,
  i.alt AS iAlt,
  i.file AS iFile,
  i.status AS iStatus,
  i.file_size_x AS iFileSizeX,
  i.file_size_y AS iFileSizeY,
  i.file_size_z_x AS iFileSizeZX,
  i.file_size_z_y AS iFileSizeZY,
  i.file_size_hd_x AS iFileSizeHdX,
  i.file_size_hd_y AS iFileSizeHdY,
  i.file_size_shd_x AS iFileSizeShdX,
  i.file_size_shd_y AS iFileSizeShdY,
  i.file_size4k_x AS iFileSize4kX,
  i.file_size4k_y AS iFileSize4kY,
  c.id AS cId,
  c.url AS cUrl,
  c.status AS cStatus,
  c.name AS cName,
  c.alternate_name AS cAName,
  c.pr_min_euro AS prMinEuro,
  c.pr_min_euro_de AS prMinEuroDe,
  c.pr_min_euro_fr AS prMinEuroFr,
  c.pr_min_euro_it AS prMinEuroIt,
  c.pr_min_euro_be AS prMinEuroBe,
  c.pr_min_euro_ie AS prMinEuroIe,
  c.pr_min_euro_nl AS prMinEuroNl,
  c.pr_min_euro_es AS prMinEuroEs,
  c.pr_min_rue AS prMinRUB,
  c.pr_min_rue AS prMinRUE,
  c.pr_min_gbp AS prMinGBP,
  c.pr_min_gbe AS prMinGBE,
  c.pr_min_usd AS prMinUSD,
  c.pr_min_use AS prMinUSE,
  c.pr_min_f_usd AS prMinFUSD,
  c.pr_min_f_use AS prMinFUSE,
  c.pr_min_chf AS prMinCHF,
  c.pr_min_che AS prMinCHE,
  c.pr_min_sek AS prMinSEK,
  c.pr_min_see AS prMinSEE,
  c.pr_min_dkk AS prMinDKK,
  c.pr_min_dke AS prMinDKE,
  c.pr_min_nok AS prMinNOK,
  c.pr_min_noe AS prMinNOE,
  c.pr_min_pln AS prMinPLN,
  c.pr_min_ple AS prMinPLE,
  c.pr_min_cad AS prMinCAD,
  c.pr_min_cae AS prMinCAE,
  c.pr_min_f_cad AS prMinEuroFCAD,
  c.pr_min_f_cae AS prMinEuroFCAE,
  f.id AS fId,
  f.url AS fUrl,
  f.status AS fStatus,
  f.name AS fName,
  f.alternate_name AS fAName,
  f.suspended AS fSuspended,
  a.id AS itemId,
  lc.id AS lcId,
  lc.code AS lcCode,
  lc.alias AS lcAlias,
  la.id AS laId,
  la.alias AS laAlias,
  lst.id AS lstId,
  lst.alias AS lstAlias,
  lt.id AS ltId,
  lt.alias AS ltAlias,
  (
    SELECT
      COUNT(ii.idea_id)
    FROM
      `idea_interior` ii
    WHERE
      `ii`.`interior_id` = `i`.id
  ) AS ideaCount
FROM
  interior i
  LEFT JOIN collection c ON c.id = i.collection
  LEFT JOIN factory f ON f.id = c.factory
  LEFT JOIN interior_article iat ON iat.interior_id = i.id
  LEFT JOIN article a ON a.id = iat.article_id
  LEFT JOIN list_country lc ON lc.id = f.country
  LEFT JOIN interior_apply ia ON ia.interior_id = i.id
  LEFT JOIN list_apply la ON la.id = ia.apply_id
  LEFT JOIN interior_texture it ON it.interior_id = i.id
  LEFT JOIN list_texture lt ON lt.id = it.texture_id
  LEFT JOIN interior_style ist ON ist.interior_id = i.id
  LEFT JOIN list_style lst ON lst.id = ist.style_id
WHERE
  c.id = 3246208
  AND i.status = 1
  AND i.id IN (174907, 243709, 243703)

SELECT
                i.id AS iId,
                i.url AS iUrl,
                i.name AS iName,
                i.alt AS iAlt,
                i.file AS iFile,
                i.status AS iStatus,
                i.file_size_x AS iFileSizeX,
                i.file_size_y AS iFileSizeY,
                i.file_size_z_x AS iFileSizeZX,
                i.file_size_z_y AS iFileSizeZY,
                i.file_size_hd_x AS iFileSizeHdX,
                i.file_size_hd_y AS iFileSizeHdY,
                i.file_size_shd_x AS iFileSizeShdX,
                i.file_size_shd_y AS iFileSizeShdY,
                i.file_size4k_x AS iFileSize4kX,
                i.file_size4k_y AS iFileSize4kY,
                c.id AS cId,
                c.url AS cUrl,
                c.status AS cStatus,
                c.name AS cName,
                c.alternate_name AS cAName,
                c.pr_min_euro AS prMinEuro,
                c.pr_min_euro_de AS prMinEuroDe,
                c.pr_min_euro_fr AS prMinEuroFr,
                c.pr_min_euro_it AS prMinEuroIt,
                c.pr_min_euro_be AS prMinEuroBe,
                c.pr_min_euro_ie AS prMinEuroIe,
                c.pr_min_euro_nl AS prMinEuroNl,
                c.pr_min_euro_es AS prMinEuroEs,
                c.pr_min_rue AS prMinRUB,
                c.pr_min_rue AS prMinRUE,
                c.pr_min_gbp AS prMinGBP,
                c.pr_min_gbe AS prMinGBE,
                c.pr_min_usd AS prMinUSD,
                c.pr_min_use AS prMinUSE,
                c.pr_min_f_usd AS prMinFUSD,
                c.pr_min_f_use AS prMinFUSE,
                c.pr_min_chf AS prMinCHF,
                c.pr_min_che AS prMinCHE,
                c.pr_min_sek AS prMinSEK,
                c.pr_min_see AS prMinSEE,
                c.pr_min_dkk AS prMinDKK,
                c.pr_min_dke AS prMinDKE,
                c.pr_min_nok AS prMinNOK,
                c.pr_min_noe AS prMinNOE,
                c.pr_min_pln AS prMinPLN,
                c.pr_min_ple AS prMinPLE,
                c.pr_min_cad AS prMinCAD,
                c.pr_min_cae AS prMinCAE,
                c.pr_min_f_cad AS prMinEuroFCAD,
                c.pr_min_f_cae AS prMinEuroFCAE,
                f.id AS fId,
                f.url AS fUrl,
                f.status AS fStatus,
                f.name AS fName,
                f.alternate_name AS fAName,
                f.suspended AS fSuspended,
                a.id AS itemId,
                lc.id AS lcId,
                lc.code AS lcCode,
                lc.alias AS lcAlias,
                la.id AS laId,
                la.alias AS laAlias,
                lst.id AS lstId,
                lst.alias AS lstAlias,
                lt.id AS ltId,
                lt.alias AS ltAlias,
                (SELECT COUNT(ii.idea_id) FROM `idea_interior` ii WHERE `ii`.`interior_id` = `i`.id) AS ideaCount
            FROM interior i
            LEFT JOIN collection c ON c.id = i.collection
            LEFT JOIN factory f ON f.id = c.factory
            LEFT JOIN interior_article iat ON iat.interior_id = i.id
            LEFT JOIN article a ON a.id = iat.article_id
            LEFT JOIN list_country lc ON lc.id = f.country
            LEFT JOIN interior_apply ia ON ia.interior_id = i.id
            LEFT JOIN list_apply la ON la.id = ia.apply_id
            LEFT JOIN interior_texture it ON it.interior_id = i.id
            LEFT JOIN list_texture lt ON lt.id = it.texture_id
            LEFT JOIN interior_style ist ON ist.interior_id = i.id
            LEFT JOIN list_style lst ON lst.id = ist.style_id
            WHERE c.id = 3246208 AND i.status = 1
         AND i.id IN (174907, 243709, 243703);

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 ('808600636');

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

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

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

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

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

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

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

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

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

SELECT
  i.id AS iId,
  i.url AS iUrl,
  i.name AS iName,
  i.alt AS iAlt,
  i.file AS iFile,
  i.status AS iStatus,
  i.file_size_x AS iFileSizeX,
  i.file_size_y AS iFileSizeY,
  i.file_size_z_x AS iFileSizeZX,
  i.file_size_z_y AS iFileSizeZY,
  i.file_size_hd_x AS iFileSizeHdX,
  i.file_size_hd_y AS iFileSizeHdY,
  i.file_size_shd_x AS iFileSizeShdX,
  i.file_size_shd_y AS iFileSizeShdY,
  i.file_size4k_x AS iFileSize4kX,
  i.file_size4k_y AS iFileSize4kY,
  c.id AS cId,
  c.url AS cUrl,
  c.status AS cStatus,
  c.name AS cName,
  c.alternate_name AS cAName,
  c.pr_min_euro AS prMinEuro,
  c.pr_min_euro_de AS prMinEuroDe,
  c.pr_min_euro_fr AS prMinEuroFr,
  c.pr_min_euro_it AS prMinEuroIt,
  c.pr_min_euro_be AS prMinEuroBe,
  c.pr_min_euro_ie AS prMinEuroIe,
  c.pr_min_euro_nl AS prMinEuroNl,
  c.pr_min_euro_es AS prMinEuroEs,
  c.pr_min_rue AS prMinRUB,
  c.pr_min_rue AS prMinRUE,
  c.pr_min_gbp AS prMinGBP,
  c.pr_min_gbe AS prMinGBE,
  c.pr_min_usd AS prMinUSD,
  c.pr_min_use AS prMinUSE,
  c.pr_min_f_usd AS prMinFUSD,
  c.pr_min_f_use AS prMinFUSE,
  c.pr_min_chf AS prMinCHF,
  c.pr_min_che AS prMinCHE,
  c.pr_min_sek AS prMinSEK,
  c.pr_min_see AS prMinSEE,
  c.pr_min_dkk AS prMinDKK,
  c.pr_min_dke AS prMinDKE,
  c.pr_min_nok AS prMinNOK,
  c.pr_min_noe AS prMinNOE,
  c.pr_min_pln AS prMinPLN,
  c.pr_min_ple AS prMinPLE,
  c.pr_min_cad AS prMinCAD,
  c.pr_min_cae AS prMinCAE,
  c.pr_min_f_cad AS prMinEuroFCAD,
  c.pr_min_f_cae AS prMinEuroFCAE,
  f.id AS fId,
  f.url AS fUrl,
  f.status AS fStatus,
  f.name AS fName,
  f.alternate_name AS fAName,
  f.suspended AS fSuspended,
  a.id AS itemId,
  lc.id AS lcId,
  lc.code AS lcCode,
  lc.alias AS lcAlias,
  la.id AS laId,
  la.alias AS laAlias,
  lst.id AS lstId,
  lst.alias AS lstAlias,
  lt.id AS ltId,
  lt.alias AS ltAlias,
  (
    SELECT
      COUNT(ii.idea_id)
    FROM
      `idea_interior` ii
    WHERE
      `ii`.`interior_id` = `i`.id
  ) AS ideaCount
FROM
  interior i
  LEFT JOIN collection c ON c.id = i.collection
  LEFT JOIN factory f ON f.id = c.factory
  LEFT JOIN interior_article iat ON iat.interior_id = i.id
  LEFT JOIN article a ON a.id = iat.article_id
  LEFT JOIN list_country lc ON lc.id = f.country
  LEFT JOIN interior_apply ia ON ia.interior_id = i.id
  LEFT JOIN list_apply la ON la.id = ia.apply_id
  LEFT JOIN interior_texture it ON it.interior_id = i.id
  LEFT JOIN list_texture lt ON lt.id = it.texture_id
  LEFT JOIN interior_style ist ON ist.interior_id = i.id
  LEFT JOIN list_style lst ON lst.id = ist.style_id
WHERE
  c.id = 3249544
  AND i.status = 1
  AND i.id IN (199395)

SELECT
                i.id AS iId,
                i.url AS iUrl,
                i.name AS iName,
                i.alt AS iAlt,
                i.file AS iFile,
                i.status AS iStatus,
                i.file_size_x AS iFileSizeX,
                i.file_size_y AS iFileSizeY,
                i.file_size_z_x AS iFileSizeZX,
                i.file_size_z_y AS iFileSizeZY,
                i.file_size_hd_x AS iFileSizeHdX,
                i.file_size_hd_y AS iFileSizeHdY,
                i.file_size_shd_x AS iFileSizeShdX,
                i.file_size_shd_y AS iFileSizeShdY,
                i.file_size4k_x AS iFileSize4kX,
                i.file_size4k_y AS iFileSize4kY,
                c.id AS cId,
                c.url AS cUrl,
                c.status AS cStatus,
                c.name AS cName,
                c.alternate_name AS cAName,
                c.pr_min_euro AS prMinEuro,
                c.pr_min_euro_de AS prMinEuroDe,
                c.pr_min_euro_fr AS prMinEuroFr,
                c.pr_min_euro_it AS prMinEuroIt,
                c.pr_min_euro_be AS prMinEuroBe,
                c.pr_min_euro_ie AS prMinEuroIe,
                c.pr_min_euro_nl AS prMinEuroNl,
                c.pr_min_euro_es AS prMinEuroEs,
                c.pr_min_rue AS prMinRUB,
                c.pr_min_rue AS prMinRUE,
                c.pr_min_gbp AS prMinGBP,
                c.pr_min_gbe AS prMinGBE,
                c.pr_min_usd AS prMinUSD,
                c.pr_min_use AS prMinUSE,
                c.pr_min_f_usd AS prMinFUSD,
                c.pr_min_f_use AS prMinFUSE,
                c.pr_min_chf AS prMinCHF,
                c.pr_min_che AS prMinCHE,
                c.pr_min_sek AS prMinSEK,
                c.pr_min_see AS prMinSEE,
                c.pr_min_dkk AS prMinDKK,
                c.pr_min_dke AS prMinDKE,
                c.pr_min_nok AS prMinNOK,
                c.pr_min_noe AS prMinNOE,
                c.pr_min_pln AS prMinPLN,
                c.pr_min_ple AS prMinPLE,
                c.pr_min_cad AS prMinCAD,
                c.pr_min_cae AS prMinCAE,
                c.pr_min_f_cad AS prMinEuroFCAD,
                c.pr_min_f_cae AS prMinEuroFCAE,
                f.id AS fId,
                f.url AS fUrl,
                f.status AS fStatus,
                f.name AS fName,
                f.alternate_name AS fAName,
                f.suspended AS fSuspended,
                a.id AS itemId,
                lc.id AS lcId,
                lc.code AS lcCode,
                lc.alias AS lcAlias,
                la.id AS laId,
                la.alias AS laAlias,
                lst.id AS lstId,
                lst.alias AS lstAlias,
                lt.id AS ltId,
                lt.alias AS ltAlias,
                (SELECT COUNT(ii.idea_id) FROM `idea_interior` ii WHERE `ii`.`interior_id` = `i`.id) AS ideaCount
            FROM interior i
            LEFT JOIN collection c ON c.id = i.collection
            LEFT JOIN factory f ON f.id = c.factory
            LEFT JOIN interior_article iat ON iat.interior_id = i.id
            LEFT JOIN article a ON a.id = iat.article_id
            LEFT JOIN list_country lc ON lc.id = f.country
            LEFT JOIN interior_apply ia ON ia.interior_id = i.id
            LEFT JOIN list_apply la ON la.id = ia.apply_id
            LEFT JOIN interior_texture it ON it.interior_id = i.id
            LEFT JOIN list_texture lt ON lt.id = it.texture_id
            LEFT JOIN interior_style ist ON ist.interior_id = i.id
            LEFT JOIN list_style lst ON lst.id = ist.style_id
            WHERE c.id = 3249544 AND i.status = 1
         AND i.id IN (199395);