Symfony Profiler

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

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

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

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

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

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

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

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

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

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

SELECT
  t0.`id` AS id_1,
  t0.`unid` AS unid_2,
  t0.`code` AS code_3,
  t0.`name` AS name_4,
  t0.`alternate_name` AS alternate_name_5,
  t0.`name_full` AS name_full_6,
  t0.`url` AS url_7,
  t0.`status` AS status_8,
  t0.`type` AS type_9,
  t0.`typeSet` AS typeSet_10,
  t0.`pc_as_m` AS pc_as_m_11,
  t0.`publish_date` AS publish_date_12,
  t0.`update_date` AS update_date_13,
  t0.`archive` AS archive_14,
  t0.`pr_min_euro` AS pr_min_euro_15,
  t0.`pr_min_euro_de` AS pr_min_euro_de_16,
  t0.`pr_min_euro_at` AS pr_min_euro_at_17,
  t0.`pr_min_euro_fi` AS pr_min_euro_fi_18,
  t0.`pr_min_euro_fr` AS pr_min_euro_fr_19,
  t0.`pr_min_euro_it` AS pr_min_euro_it_20,
  t0.`pr_min_euro_be` AS pr_min_euro_be_21,
  t0.`pr_min_euro_ie` AS pr_min_euro_ie_22,
  t0.`pr_min_euro_nl` AS pr_min_euro_nl_23,
  t0.`pr_min_euro_es` AS pr_min_euro_es_24,
  t0.`pr_min_rub` AS pr_min_rub_25,
  t0.`pr_min_rue` AS pr_min_rue_26,
  t0.`pr_min_gbp` AS pr_min_gbp_27,
  t0.`pr_min_gbe` AS pr_min_gbe_28,
  t0.`pr_min_usd` AS pr_min_usd_29,
  t0.`pr_min_use` AS pr_min_use_30,
  t0.`pr_min_f_usd` AS pr_min_f_usd_31,
  t0.`pr_min_f_use` AS pr_min_f_use_32,
  t0.`pr_min_chf` AS pr_min_chf_33,
  t0.`pr_min_che` AS pr_min_che_34,
  t0.`pr_min_sek` AS pr_min_sek_35,
  t0.`pr_min_see` AS pr_min_see_36,
  t0.`pr_min_dkk` AS pr_min_dkk_37,
  t0.`pr_min_dke` AS pr_min_dke_38,
  t0.`pr_min_nok` AS pr_min_nok_39,
  t0.`pr_min_noe` AS pr_min_noe_40,
  t0.`pr_min_pln` AS pr_min_pln_41,
  t0.`pr_min_ple` AS pr_min_ple_42,
  t0.`pr_min_cad` AS pr_min_cad_43,
  t0.`pr_min_cae` AS pr_min_cae_44,
  t0.`pr_min_f_cad` AS pr_min_f_cad_45,
  t0.`pr_min_f_cae` AS pr_min_f_cae_46,
  t0.`pr_min_ed` AS pr_min_ed_47,
  t0.`important` AS important_48,
  t0.`author` AS author_49,
  t0.`author_id` AS author_id_50,
  t0.`rating` AS rating_51,
  t0.`header` AS header_52,
  t0.`settings` AS settings_53,
  t0.`fids` AS fids_54,
  t0.`portal_unid` AS portal_unid_55,
  t0.`accepted_at` AS accepted_at_56,
  t0.`accept_state` AS accept_state_57,
  t0.`description_edit` AS description_edit_58,
  t0.`link_award` AS link_award_59,
  t0.`awards` AS awards_60,
  t0.`video` AS video_61,
  t0.`stated_at` AS stated_at_62,
  t0.`state` AS state_63,
  t0.`description_state` AS description_state_64,
  t0.`body_hide` AS body_hide_65,
  t0.`release_year` AS release_year_66,
  t0.`site` AS site_67,
  t0.`show_main` AS show_main_68,
  t0.`glue_url` AS glue_url_69,
  t0.`accessible` AS accessible_70,
  t0.`delivery_suspended` AS delivery_suspended_71,
  t0.`process` AS process_72,
  t0.`exhibition` AS exhibition_73,
  t0.`test_access` AS test_access_74,
  t0.`views` AS views_75,
  t0.`comment_unid` AS comment_unid_76,
  t0.`accesible_at` AS accesible_at_77,
  t0.`created_at` AS created_at_78,
  t0.`updated_at` AS updated_at_79,
  t0.factory AS factory_80,
  t0.category_price AS category_price_81,
  t82.`id` AS id_83,
  t82.`source` AS source_84,
  t82.`ru` AS ru_85,
  t82.`en` AS en_86,
  t82.`it` AS it_87,
  t82.`es` AS es_88,
  t82.`fr` AS fr_89,
  t82.`de` AS de_90,
  t82.`pl` AS pl_91,
  t82.`pt` AS pt_92,
  t82.`nl` AS nl_93,
  t82.`fi` AS fi_94,
  t82.`ua` AS ua_95,
  t82.`sv` AS sv_96,
  t82.`no` AS no_97,
  t82.`da` AS da_98,
  t82.`cn` AS cn_99,
  t82.`zh` AS zh_100,
  t82.`created_at` AS created_at_101,
  t82.`updated_at` AS updated_at_102,
  t82.email_body_id AS email_body_id_103,
  t82.publication_body_id AS publication_body_id_104,
  t82.static_page_body_id AS static_page_body_id_105,
  t82.collection_body_id AS collection_body_id_106,
  t82.trans_val_id AS trans_val_id_107,
  t82.exh_text_id AS exh_text_id_108,
  t82.exh_brand_text_id AS exh_brand_text_id_109,
  t82.exh_collection_text_id AS exh_collection_text_id_110,
  t82.filter_html_id AS filter_html_id_111,
  t112.`id` AS id_113,
  t112.`source` AS source_114,
  t112.`ru` AS ru_115,
  t112.`en` AS en_116,
  t112.`it` AS it_117,
  t112.`es` AS es_118,
  t112.`fr` AS fr_119,
  t112.`de` AS de_120,
  t112.`pl` AS pl_121,
  t112.`pt` AS pt_122,
  t112.`nl` AS nl_123,
  t112.`fi` AS fi_124,
  t112.`ua` AS ua_125,
  t112.`sv` AS sv_126,
  t112.`no` AS no_127,
  t112.`da` AS da_128,
  t112.`cn` AS cn_129,
  t112.`zh` AS zh_130,
  t112.`created_at` AS created_at_131,
  t112.`updated_at` AS updated_at_132,
  t112.static_page_title_id AS static_page_title_id_133,
  t112.static_page_keywords_id AS static_page_keywords_id_134,
  t112.static_page_description_id AS static_page_description_id_135,
  t112.collection_keywords_id AS collection_keywords_id_136,
  t112.collection_description_id AS collection_description_id_137,
  t112.blog_keywords_id AS blog_keywords_id_138,
  t112.blog_description_id AS blog_description_id_139,
  t112.exh_keywords_id AS exh_keywords_id_140,
  t112.exh_description_id AS exh_description_id_141,
  t142.`id` AS id_143,
  t142.`source` AS source_144,
  t142.`ru` AS ru_145,
  t142.`en` AS en_146,
  t142.`it` AS it_147,
  t142.`es` AS es_148,
  t142.`fr` AS fr_149,
  t142.`de` AS de_150,
  t142.`pl` AS pl_151,
  t142.`pt` AS pt_152,
  t142.`nl` AS nl_153,
  t142.`fi` AS fi_154,
  t142.`ua` AS ua_155,
  t142.`sv` AS sv_156,
  t142.`no` AS no_157,
  t142.`da` AS da_158,
  t142.`cn` AS cn_159,
  t142.`zh` AS zh_160,
  t142.`created_at` AS created_at_161,
  t142.`updated_at` AS updated_at_162,
  t142.static_page_title_id AS static_page_title_id_163,
  t142.static_page_keywords_id AS static_page_keywords_id_164,
  t142.static_page_description_id AS static_page_description_id_165,
  t142.collection_keywords_id AS collection_keywords_id_166,
  t142.collection_description_id AS collection_description_id_167,
  t142.blog_keywords_id AS blog_keywords_id_168,
  t142.blog_description_id AS blog_description_id_169,
  t142.exh_keywords_id AS exh_keywords_id_170,
  t142.exh_description_id AS exh_description_id_171
FROM
  `collection` t0
  LEFT JOIN `locale_html` t82 ON t82.collection_body_id = t0.id
  LEFT JOIN `locale_meta` t112 ON t112.collection_keywords_id = t0.id
  LEFT JOIN `locale_meta` t142 ON t142.collection_description_id = t0.id
WHERE
  t0.factory = ?

SELECT t0.`id` AS id_1, t0.`unid` AS unid_2, t0.`code` AS code_3, t0.`name` AS name_4, t0.`alternate_name` AS alternate_name_5, t0.`name_full` AS name_full_6, t0.`url` AS url_7, t0.`status` AS status_8, t0.`type` AS type_9, t0.`typeSet` AS typeSet_10, t0.`pc_as_m` AS pc_as_m_11, t0.`publish_date` AS publish_date_12, t0.`update_date` AS update_date_13, t0.`archive` AS archive_14, t0.`pr_min_euro` AS pr_min_euro_15, t0.`pr_min_euro_de` AS pr_min_euro_de_16, t0.`pr_min_euro_at` AS pr_min_euro_at_17, t0.`pr_min_euro_fi` AS pr_min_euro_fi_18, t0.`pr_min_euro_fr` AS pr_min_euro_fr_19, t0.`pr_min_euro_it` AS pr_min_euro_it_20, t0.`pr_min_euro_be` AS pr_min_euro_be_21, t0.`pr_min_euro_ie` AS pr_min_euro_ie_22, t0.`pr_min_euro_nl` AS pr_min_euro_nl_23, t0.`pr_min_euro_es` AS pr_min_euro_es_24, t0.`pr_min_rub` AS pr_min_rub_25, t0.`pr_min_rue` AS pr_min_rue_26, t0.`pr_min_gbp` AS pr_min_gbp_27, t0.`pr_min_gbe` AS pr_min_gbe_28, t0.`pr_min_usd` AS pr_min_usd_29, t0.`pr_min_use` AS pr_min_use_30, t0.`pr_min_f_usd` AS pr_min_f_usd_31, t0.`pr_min_f_use` AS pr_min_f_use_32, t0.`pr_min_chf` AS pr_min_chf_33, t0.`pr_min_che` AS pr_min_che_34, t0.`pr_min_sek` AS pr_min_sek_35, t0.`pr_min_see` AS pr_min_see_36, t0.`pr_min_dkk` AS pr_min_dkk_37, t0.`pr_min_dke` AS pr_min_dke_38, t0.`pr_min_nok` AS pr_min_nok_39, t0.`pr_min_noe` AS pr_min_noe_40, t0.`pr_min_pln` AS pr_min_pln_41, t0.`pr_min_ple` AS pr_min_ple_42, t0.`pr_min_cad` AS pr_min_cad_43, t0.`pr_min_cae` AS pr_min_cae_44, t0.`pr_min_f_cad` AS pr_min_f_cad_45, t0.`pr_min_f_cae` AS pr_min_f_cae_46, t0.`pr_min_ed` AS pr_min_ed_47, t0.`important` AS important_48, t0.`author` AS author_49, t0.`author_id` AS author_id_50, t0.`rating` AS rating_51, t0.`header` AS header_52, t0.`settings` AS settings_53, t0.`fids` AS fids_54, t0.`portal_unid` AS portal_unid_55, t0.`accepted_at` AS accepted_at_56, t0.`accept_state` AS accept_state_57, t0.`description_edit` AS description_edit_58, t0.`link_award` AS link_award_59, t0.`awards` AS awards_60, t0.`video` AS video_61, t0.`stated_at` AS stated_at_62, t0.`state` AS state_63, t0.`description_state` AS description_state_64, t0.`body_hide` AS body_hide_65, t0.`release_year` AS release_year_66, t0.`site` AS site_67, t0.`show_main` AS show_main_68, t0.`glue_url` AS glue_url_69, t0.`accessible` AS accessible_70, t0.`delivery_suspended` AS delivery_suspended_71, t0.`process` AS process_72, t0.`exhibition` AS exhibition_73, t0.`test_access` AS test_access_74, t0.`views` AS views_75, t0.`comment_unid` AS comment_unid_76, t0.`accesible_at` AS accesible_at_77, t0.`created_at` AS created_at_78, t0.`updated_at` AS updated_at_79, t0.factory AS factory_80, t0.category_price AS category_price_81, t82.`id` AS id_83, t82.`source` AS source_84, t82.`ru` AS ru_85, t82.`en` AS en_86, t82.`it` AS it_87, t82.`es` AS es_88, t82.`fr` AS fr_89, t82.`de` AS de_90, t82.`pl` AS pl_91, t82.`pt` AS pt_92, t82.`nl` AS nl_93, t82.`fi` AS fi_94, t82.`ua` AS ua_95, t82.`sv` AS sv_96, t82.`no` AS no_97, t82.`da` AS da_98, t82.`cn` AS cn_99, t82.`zh` AS zh_100, t82.`created_at` AS created_at_101, t82.`updated_at` AS updated_at_102, t82.email_body_id AS email_body_id_103, t82.publication_body_id AS publication_body_id_104, t82.static_page_body_id AS static_page_body_id_105, t82.collection_body_id AS collection_body_id_106, t82.trans_val_id AS trans_val_id_107, t82.exh_text_id AS exh_text_id_108, t82.exh_brand_text_id AS exh_brand_text_id_109, t82.exh_collection_text_id AS exh_collection_text_id_110, t82.filter_html_id AS filter_html_id_111, t112.`id` AS id_113, t112.`source` AS source_114, t112.`ru` AS ru_115, t112.`en` AS en_116, t112.`it` AS it_117, t112.`es` AS es_118, t112.`fr` AS fr_119, t112.`de` AS de_120, t112.`pl` AS pl_121, t112.`pt` AS pt_122, t112.`nl` AS nl_123, t112.`fi` AS fi_124, t112.`ua` AS ua_125, t112.`sv` AS sv_126, t112.`no` AS no_127, t112.`da` AS da_128, t112.`cn` AS cn_129, t112.`zh` AS zh_130, t112.`created_at` AS created_at_131, t112.`updated_at` AS updated_at_132, t112.static_page_title_id AS static_page_title_id_133, t112.static_page_keywords_id AS static_page_keywords_id_134, t112.static_page_description_id AS static_page_description_id_135, t112.collection_keywords_id AS collection_keywords_id_136, t112.collection_description_id AS collection_description_id_137, t112.blog_keywords_id AS blog_keywords_id_138, t112.blog_description_id AS blog_description_id_139, t112.exh_keywords_id AS exh_keywords_id_140, t112.exh_description_id AS exh_description_id_141, t142.`id` AS id_143, t142.`source` AS source_144, t142.`ru` AS ru_145, t142.`en` AS en_146, t142.`it` AS it_147, t142.`es` AS es_148, t142.`fr` AS fr_149, t142.`de` AS de_150, t142.`pl` AS pl_151, t142.`pt` AS pt_152, t142.`nl` AS nl_153, t142.`fi` AS fi_154, t142.`ua` AS ua_155, t142.`sv` AS sv_156, t142.`no` AS no_157, t142.`da` AS da_158, t142.`cn` AS cn_159, t142.`zh` AS zh_160, t142.`created_at` AS created_at_161, t142.`updated_at` AS updated_at_162, t142.static_page_title_id AS static_page_title_id_163, t142.static_page_keywords_id AS static_page_keywords_id_164, t142.static_page_description_id AS static_page_description_id_165, t142.collection_keywords_id AS collection_keywords_id_166, t142.collection_description_id AS collection_description_id_167, t142.blog_keywords_id AS blog_keywords_id_168, t142.blog_description_id AS blog_description_id_169, t142.exh_keywords_id AS exh_keywords_id_170, t142.exh_description_id AS exh_description_id_171 FROM `collection` t0 LEFT JOIN `locale_html` t82 ON t82.collection_body_id = t0.id LEFT JOIN `locale_meta` t112 ON t112.collection_keywords_id = t0.id LEFT JOIN `locale_meta` t142 ON t142.collection_description_id = t0.id WHERE t0.factory = 8797;

SELECT
  COUNT(v0_.`id`) AS sclr_0
FROM
  `visit` v0_
WHERE
  v0_.`token` = ?
  AND v0_.`url` <> '/.*catalog.*/'

SELECT COUNT(v0_.`id`) AS sclr_0 FROM `visit` v0_ WHERE v0_.`token` = '14600f09060a9d20eb08fcac92373f22e3df09c8c028decfcc894486ce8d8ab9' AND v0_.`url` <> '/.*catalog.*/';

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` = '14600f09060a9d20eb08fcac92373f22e3df09c8c028decfcc894486ce8d8ab9' AND v0_.`url` = 'catalogue/codicer-95' AND v0_.`url` <> '/.*catalog.*/' LIMIT 1;

SELECT
  t0.`id` AS id_1,
  t0.`reviewId` AS reviewId_2,
  t0.`referenceId` AS referenceId_3,
  t0.`conversationId` AS conversationId_4,
  t0.`p_id` AS p_id_5,
  t0.`sku` AS sku_6,
  t0.`gtin` AS gtin_7,
  t0.`mpn` AS mpn_8,
  t0.`url` AS url_9,
  t0.`star` AS star_10,
  t0.`score` AS score_11,
  t0.`date` AS date_12,
  t0.`created_at` AS created_at_13,
  t0.`content` AS content_14,
  t0.`username` AS username_15,
  t0.`country` AS country_16,
  t0.`locale` AS locale_17,
  t0.`language` AS language_18,
  t0.`state` AS state_19,
  t0.`unid_theme` AS unid_theme_20,
  t0.`send_portal_date` AS send_portal_date_21,
  t0.`answer` AS answer_22,
  t0.`manager` AS manager_23,
  t0.`is_anonymous` AS is_anonymous_24,
  t0.`is_collection_review` AS is_collection_review_25,
  t0.article_id AS article_id_26,
  t0.collection_id AS collection_id_27,
  t0.order_id AS order_id_28,
  t0.user_id AS user_id_29
FROM
  `product_reviews_cache` t0
WHERE
  t0.collection_id IN (?)

SELECT t0.`id` AS id_1, t0.`reviewId` AS reviewId_2, t0.`referenceId` AS referenceId_3, t0.`conversationId` AS conversationId_4, t0.`p_id` AS p_id_5, t0.`sku` AS sku_6, t0.`gtin` AS gtin_7, t0.`mpn` AS mpn_8, t0.`url` AS url_9, t0.`star` AS star_10, t0.`score` AS score_11, t0.`date` AS date_12, t0.`created_at` AS created_at_13, t0.`content` AS content_14, t0.`username` AS username_15, t0.`country` AS country_16, t0.`locale` AS locale_17, t0.`language` AS language_18, t0.`state` AS state_19, t0.`unid_theme` AS unid_theme_20, t0.`send_portal_date` AS send_portal_date_21, t0.`answer` AS answer_22, t0.`manager` AS manager_23, t0.`is_anonymous` AS is_anonymous_24, t0.`is_collection_review` AS is_collection_review_25, t0.article_id AS article_id_26, t0.collection_id AS collection_id_27, t0.order_id AS order_id_28, t0.user_id AS user_id_29 FROM `product_reviews_cache` t0 WHERE t0.collection_id IN (296956, 298786, 298787, 304543, 304544, 1618569, 1618570, 1618571, 1618572, 2254524, 3244524, 3244548, 3244549, 3244550, 3244551, 3244561, 3244594, 3244669, 3244670, 3245074, 3245298, 3245299, 3245300, 3245823, 3245824, 3245825, 3245826, 3245827, 3245828, 3246281, 3246317, 3246371, 3246432, 3246465, 3246799, 3246805, 3247002, 3247054, 3247062, 3247149, 3247208, 3247247, 3247253, 3247258, 3247338, 3247365, 3247385, 3247555, 3247833, 3247834, 3247835, 3247836, 3247916, 3248256, 3248273, 3248394, 3248404, 3248418, 3248611, 3248612, 3248613, 3248614, 3248615, 3248618, 3248619, 3248620, 3248719, 3248763, 3248785, 3248792, 3248798, 3248800, 3248801, 3248833, 3248955, 3248960, 3248968, 3248982, 3248987, 3249015, 3249016, 3249074, 3249075, 3249076, 3249143, 3249187, 3249371, 3249373, 3249393, 3249394, 3249395, 3249396, 3249397, 3249408, 3249498, 3249515, 3249601, 3249607, 3249657, 3250861, 3250866, 3251166, 3251170, 3251174, 3251222, 3251226, 3251638, 3251968, 3252511, 3253066, 3253078, 3253084, 3253087, 3253090, 3253120, 3253126, 3253141, 3253156, 3253159, 3253258, 3253261, 3253264, 3253267, 3253270, 3253417, 3253420, 3253423, 3253426, 3253453, 3253456, 3253459, 3253462, 3253465, 3253474, 3253477, 3253483, 3253486, 3253489, 3253495, 3253498, 3253501, 3253504, 3253534, 3253990, 3254038, 3254101, 3254188, 3254455, 3254458, 3254470, 3254473, 3254476, 3254527, 3254530, 3254533, 3254605, 3254608, 3254641, 3254644, 3254671, 3254698, 3254752, 3254827, 3254842, 3254893, 3254911);