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

SELECT
  v0_.`id` AS id_0,
  v0_.`token` AS token_1,
  v0_.`url` AS url_2,
  v0_.`title` AS title_3,
  v0_.`icon` AS icon_4,
  v0_.`visit_date` AS visit_date_5,
  v0_.`v_type` AS v_type_6,
  v0_.`v_object_id` AS v_object_id_7
FROM
  `visit` v0_
WHERE
  v0_.`token` = ?
  AND v0_.`url` = ?
  AND v0_.`url` <> '/.*catalog.*/'
LIMIT
  1

SELECT v0_.`id` AS id_0, v0_.`token` AS token_1, v0_.`url` AS url_2, v0_.`title` AS title_3, v0_.`icon` AS icon_4, v0_.`visit_date` AS visit_date_5, v0_.`v_type` AS v_type_6, v0_.`v_object_id` AS v_object_id_7 FROM `visit` v0_ WHERE v0_.`token` = 'e64696d62b52c6708e6196ee7f46ee09f25fcd8ea7f4d2ad186368888ea398d8' AND v0_.`url` = 'catalogue/zuletzt-hinzugefugte-fliesen' AND v0_.`url` <> '/.*catalog.*/' LIMIT 1;

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 = 3259210
  AND i.status = 1
  AND i.id IN (293515, 293518, 293506)

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 = 3259210 AND i.status = 1
         AND i.id IN (293515, 293518, 293506);

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 = 3259024
  AND i.status = 1
  AND i.id IN (290668, 290671, 290674)

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 = 3259024 AND i.status = 1
         AND i.id IN (290668, 290671, 290674);

SELECT
  b0_.`id` AS id_0,
  b0_.`name` AS name_1,
  b0_.`descr` AS descr_2,
  b0_.`val` AS val_3
FROM
  `BoolDBSetting` b0_
WHERE
  b0_.`name` = ?

SELECT b0_.`id` AS id_0, b0_.`name` AS name_1, b0_.`descr` AS descr_2, b0_.`val` AS val_3 FROM `BoolDBSetting` b0_ WHERE b0_.`name` = 'RTWidget';

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 = 3259114
  AND i.status = 1
  AND i.id IN (292030, 292045, 292069)

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 = 3259114 AND i.status = 1
         AND i.id IN (292030, 292045, 292069);