Symfony Profiler

SELECT
  p0_.`id` AS id_0,
  p0_.`publish_date` AS publish_date_1,
  p0_.`hide_countries` AS hide_countries_2
FROM
  `publication` p0_
  LEFT JOIN `locale_html` l1_ ON p0_.id = l1_.publication_body_id
  LEFT JOIN `locale_bool` l2_ ON p0_.id = l2_.blog_show_id
  LEFT JOIN `locale_bool` l3_ ON p0_.id = l3_.blog_hide_single_id
WHERE
  p0_.`enable` = 1
  AND l2_.`fr` = 1
  AND l1_.`fr` <> ''
  AND l3_.`fr` = ?
  AND p0_.`id` <> ?
ORDER BY
  p0_.`publish_date` ASC

SELECT p0_.`id` AS id_0, p0_.`publish_date` AS publish_date_1, p0_.`hide_countries` AS hide_countries_2 FROM `publication` p0_ LEFT JOIN `locale_html` l1_ ON p0_.id = l1_.publication_body_id LEFT JOIN `locale_bool` l2_ ON p0_.id = l2_.blog_show_id LEFT JOIN `locale_bool` l3_ ON p0_.id = l3_.blog_hide_single_id WHERE p0_.`enable` = 1 AND l2_.`fr` = 1 AND l1_.`fr` <> '' AND l3_.`fr` = 0 AND p0_.`id` <> 2235 ORDER BY p0_.`publish_date` ASC;

SELECT
  e0_.`id` AS id_0,
  e0_.`created_at` AS created_at_1
FROM
  `exh` e0_
  LEFT JOIN `locale_html` l1_ ON e0_.id = l1_.exh_text_id
  LEFT JOIN `locale_bool` l2_ ON e0_.id = l2_.exh_show_id
  LEFT JOIN `locale_bool` l3_ ON e0_.id = l3_.exh_hide_single_id
WHERE
  e0_.`enable` = 1
  AND l2_.`fr` = 1
  AND l1_.`fr` <> ''
  AND l3_.`fr` = ?

SELECT e0_.`id` AS id_0, e0_.`created_at` AS created_at_1 FROM `exh` e0_ LEFT JOIN `locale_html` l1_ ON e0_.id = l1_.exh_text_id LEFT JOIN `locale_bool` l2_ ON e0_.id = l2_.exh_show_id LEFT JOIN `locale_bool` l3_ ON e0_.id = l3_.exh_hide_single_id WHERE e0_.`enable` = 1 AND l2_.`fr` = 1 AND l1_.`fr` <> '' AND l3_.`fr` = 0;

SELECT
  p.id,
  p.enable,
  p.unid,
  p.view,
  p.publish_date AS `publishDate`,
  p.hide_countries AS `hideCountries`,
  lcurl.fr AS `url`,
  lctitle.fr AS `title`,
  lchtml.fr AS `body`,
  lcssShow.fr AS `statusShow`,
  lchs.fr AS `hideSingle`,
  lcpw.def AS `preview.def`,
  lcpw.en AS `preview.en`,
  lcpw.fr AS `preview.lc`,
  COUNT(DISTINCT cmt.id) AS `commentCnt`
FROM
  publication p
  LEFT JOIN `publication_like` `plike` ON plike.publication_id = p.id
  LEFT JOIN `locale_url` `lcurl` ON lcurl.publication_id = p.id
  LEFT JOIN `locale_title` `lctitle` ON lctitle.publication_id = p.id
  LEFT JOIN `locale_html` `lchtml` ON lchtml.publication_body_id = p.id
  LEFT JOIN `locale_bool` `lcssShow` ON lcssShow.blog_show_id = p.id
  LEFT JOIN `locale_bool` `lchs` ON lchs.blog_hide_single_id = p.id
  LEFT JOIN `locale_preview` `lcpw` ON lcpw.publication_id = p.id
  LEFT JOIN `comment_refact` `cmt` ON cmt.commentable_unid = p.unid
  AND cmt.locale = 'fr'
WHERE
  p.id IN (
    2308, 2302, 2305, 2296, 2293, 2290, 2287,
    2278, 2248, 2241, 2232
  )
GROUP BY
  p.id;

SELECT
                p.id,
                p.enable,
                p.unid,
                p.view,
                p.publish_date AS `publishDate`,
                p.hide_countries AS `hideCountries`,
                lcurl.fr AS `url`,
                lctitle.fr AS `title`,
                lchtml.fr AS `body`,
                lcssShow.fr AS `statusShow`,
                lchs.fr AS `hideSingle`,
                lcpw.def AS `preview.def`,
                lcpw.en AS `preview.en`,
                lcpw.fr AS `preview.lc`,
                COUNT(DISTINCT cmt.id) AS `commentCnt`
            FROM
                publication p
            LEFT JOIN `publication_like` `plike` ON plike.publication_id = p.id
            LEFT JOIN `locale_url` `lcurl` ON lcurl.publication_id = p.id
            LEFT JOIN `locale_title` `lctitle` ON lctitle.publication_id = p.id
            LEFT JOIN `locale_html` `lchtml` ON lchtml.publication_body_id = p.id
            LEFT JOIN `locale_bool` `lcssShow` ON lcssShow.blog_show_id = p.id
            LEFT JOIN `locale_bool` `lchs` ON lchs.blog_hide_single_id = p.id
            LEFT JOIN `locale_preview` `lcpw` ON lcpw.publication_id = p.id
            LEFT JOIN `comment_refact` `cmt` ON cmt.commentable_unid = p.unid AND cmt.locale = 'fr'

            WHERE p.id IN (2308,2302,2305,2296,2293,2290,2287,2278,2248,2241,2232)
            GROUP BY p.id;;

SELECT
  e0_.`id` AS id_0,
  e0_.`enable` AS enable_1,
  e0_.`unid` AS unid_2,
  e0_.`view` AS view_3,
  e0_.`created_at` AS created_at_4,
  e0_.`updated_at` AS updated_at_5,
  l1_.`id` AS id_6,
  l1_.`source` AS source_7,
  l1_.`ru` AS ru_8,
  l1_.`en` AS en_9,
  l1_.`it` AS it_10,
  l1_.`es` AS es_11,
  l1_.`fr` AS fr_12,
  l1_.`de` AS de_13,
  l1_.`pl` AS pl_14,
  l1_.`pt` AS pt_15,
  l1_.`nl` AS nl_16,
  l1_.`fi` AS fi_17,
  l1_.`ua` AS ua_18,
  l1_.`sv` AS sv_19,
  l1_.`no` AS no_20,
  l1_.`da` AS da_21,
  l1_.`cn` AS cn_22,
  l1_.`zh` AS zh_23,
  l1_.`created_at` AS created_at_24,
  l1_.`updated_at` AS updated_at_25,
  l2_.`id` AS id_26,
  l2_.`source` AS source_27,
  l2_.`ru` AS ru_28,
  l2_.`en` AS en_29,
  l2_.`it` AS it_30,
  l2_.`es` AS es_31,
  l2_.`fr` AS fr_32,
  l2_.`de` AS de_33,
  l2_.`pl` AS pl_34,
  l2_.`pt` AS pt_35,
  l2_.`nl` AS nl_36,
  l2_.`fi` AS fi_37,
  l2_.`ua` AS ua_38,
  l2_.`sv` AS sv_39,
  l2_.`no` AS no_40,
  l2_.`da` AS da_41,
  l2_.`cn` AS cn_42,
  l2_.`zh` AS zh_43,
  l2_.`created_at` AS created_at_44,
  l2_.`updated_at` AS updated_at_45,
  l3_.`id` AS id_46,
  l3_.`source` AS source_47,
  l3_.`ru` AS ru_48,
  l3_.`en` AS en_49,
  l3_.`it` AS it_50,
  l3_.`es` AS es_51,
  l3_.`fr` AS fr_52,
  l3_.`de` AS de_53,
  l3_.`pl` AS pl_54,
  l3_.`pt` AS pt_55,
  l3_.`nl` AS nl_56,
  l3_.`fi` AS fi_57,
  l3_.`ua` AS ua_58,
  l3_.`sv` AS sv_59,
  l3_.`no` AS no_60,
  l3_.`da` AS da_61,
  l3_.`cn` AS cn_62,
  l3_.`zh` AS zh_63,
  l3_.`created_at` AS created_at_64,
  l3_.`updated_at` AS updated_at_65,
  l4_.`id` AS id_66,
  l4_.`source` AS source_67,
  l4_.`ru` AS ru_68,
  l4_.`en` AS en_69,
  l4_.`it` AS it_70,
  l4_.`es` AS es_71,
  l4_.`fr` AS fr_72,
  l4_.`de` AS de_73,
  l4_.`pl` AS pl_74,
  l4_.`pt` AS pt_75,
  l4_.`nl` AS nl_76,
  l4_.`fi` AS fi_77,
  l4_.`ua` AS ua_78,
  l4_.`sv` AS sv_79,
  l4_.`no` AS no_80,
  l4_.`da` AS da_81,
  l4_.`cn` AS cn_82,
  l4_.`zh` AS zh_83,
  l4_.`created_at` AS created_at_84,
  l4_.`updated_at` AS updated_at_85,
  l5_.`id` AS id_86,
  l5_.`source` AS source_87,
  l5_.`ru` AS ru_88,
  l5_.`en` AS en_89,
  l5_.`it` AS it_90,
  l5_.`es` AS es_91,
  l5_.`fr` AS fr_92,
  l5_.`de` AS de_93,
  l5_.`pl` AS pl_94,
  l5_.`pt` AS pt_95,
  l5_.`nl` AS nl_96,
  l5_.`fi` AS fi_97,
  l5_.`ua` AS ua_98,
  l5_.`sv` AS sv_99,
  l5_.`no` AS no_100,
  l5_.`da` AS da_101,
  l5_.`cn` AS cn_102,
  l5_.`zh` AS zh_103,
  l5_.`created_at` AS created_at_104,
  l5_.`updated_at` AS updated_at_105,
  l6_.`id` AS id_106,
  l6_.`def` AS def_107,
  l6_.`ru` AS ru_108,
  l6_.`en` AS en_109,
  l6_.`it` AS it_110,
  l6_.`es` AS es_111,
  l6_.`fr` AS fr_112,
  l6_.`de` AS de_113,
  l6_.`pl` AS pl_114,
  l6_.`pt` AS pt_115,
  l6_.`nl` AS nl_116,
  l6_.`fi` AS fi_117,
  l6_.`ua` AS ua_118,
  l6_.`sv` AS sv_119,
  l6_.`no` AS no_120,
  l6_.`da` AS da_121,
  l6_.`cn` AS cn_122,
  l6_.`zh` AS zh_123,
  l6_.`created_at` AS created_at_124,
  l6_.`updated_at` AS updated_at_125,
  l7_.`id` AS id_126,
  l7_.`token` AS token_127,
  u8_.`id` AS id_128,
  u8_.`unid` AS unid_129,
  u8_.`corporate_unid` AS corporate_unid_130,
  u8_.`token` AS token_131,
  u8_.`is_active` AS is_active_132,
  u8_.`proved` AS proved_133,
  u8_.`alias` AS alias_134,
  u8_.`foreign_alias` AS foreign_alias_135,
  u8_.`lotus_name` AS lotus_name_136,
  u8_.`password` AS password_137,
  u8_.`expired` AS expired_138,
  u8_.`expires_at` AS expires_at_139,
  u8_.`credentials_expired` AS credentials_expired_140,
  u8_.`credentials_expire_at` AS credentials_expire_at_141,
  u8_.`last_ip` AS last_ip_142,
  u8_.`source` AS source_143,
  u8_.`social_network` AS social_network_144,
  u8_.`social_network_id` AS social_network_id_145,
  u8_.`google_id` AS google_id_146,
  u8_.`fb_id` AS fb_id_147,
  u8_.`vk_id` AS vk_id_148,
  u8_.`ig_id` AS ig_id_149,
  u8_.`test` AS test_150,
  u8_.`token_fixed` AS token_fixed_151,
  u8_.`bid` AS bid_152,
  u8_.`email` AS email_153,
  u8_.`salt` AS salt_154,
  u8_.`review_request_sent` AS review_request_sent_155,
  u8_.`username` AS username_156,
  u8_.`roles` AS roles_157,
  u8_.`enabled` AS enabled_158,
  u8_.`confirmation_token` AS confirmation_token_159,
  u8_.`last_login` AS last_login_160,
  u8_.`password_requested_at` AS password_requested_at_161,
  u8_.`security_field` AS security_field_162,
  u8_.`created_at` AS created_at_163,
  u8_.`is_legal_entity` AS is_legal_entity_164,
  u8_.`companyName` AS companyName_165,
  u8_.`vatNumber` AS vatNumber_166,
  u8_.`lang` AS lang_167,
  l9_.`id` AS id_168,
  l9_.`source` AS source_169,
  l9_.`ru` AS ru_170,
  l9_.`en` AS en_171,
  l9_.`it` AS it_172,
  l9_.`es` AS es_173,
  l9_.`fr` AS fr_174,
  l9_.`de` AS de_175,
  l9_.`pl` AS pl_176,
  l9_.`pt` AS pt_177,
  l9_.`nl` AS nl_178,
  l9_.`fi` AS fi_179,
  l9_.`ua` AS ua_180,
  l9_.`sv` AS sv_181,
  l9_.`no` AS no_182,
  l9_.`da` AS da_183,
  l9_.`cn` AS cn_184,
  l9_.`zh` AS zh_185,
  l9_.`created_at` AS created_at_186,
  l9_.`updated_at` AS updated_at_187,
  l10_.`id` AS id_188,
  l10_.`ru` AS ru_189,
  l10_.`en` AS en_190,
  l10_.`it` AS it_191,
  l10_.`es` AS es_192,
  l10_.`fr` AS fr_193,
  l10_.`de` AS de_194,
  l10_.`pl` AS pl_195,
  l10_.`pt` AS pt_196,
  l10_.`nl` AS nl_197,
  l10_.`fi` AS fi_198,
  l10_.`ua` AS ua_199,
  l10_.`sv` AS sv_200,
  l10_.`no` AS no_201,
  l10_.`da` AS da_202,
  l10_.`cn` AS cn_203,
  l10_.`zh` AS zh_204,
  l10_.`created_at` AS created_at_205,
  l10_.`updated_at` AS updated_at_206,
  l11_.`id` AS id_207,
  l11_.`source` AS source_208,
  l11_.`ru` AS ru_209,
  l11_.`en` AS en_210,
  l11_.`it` AS it_211,
  l11_.`es` AS es_212,
  l11_.`fr` AS fr_213,
  l11_.`de` AS de_214,
  l11_.`pl` AS pl_215,
  l11_.`pt` AS pt_216,
  l11_.`nl` AS nl_217,
  l11_.`fi` AS fi_218,
  l11_.`ua` AS ua_219,
  l11_.`sv` AS sv_220,
  l11_.`no` AS no_221,
  l11_.`da` AS da_222,
  l11_.`cn` AS cn_223,
  l11_.`zh` AS zh_224,
  l11_.`created_at` AS created_at_225,
  l11_.`updated_at` AS updated_at_226
FROM
  `exh` e0_
  LEFT JOIN `locale_url` l1_ ON e0_.id = l1_.exh_id
  LEFT JOIN `locale_title` l2_ ON e0_.id = l2_.exh_title_id
  LEFT JOIN `locale_html` l3_ ON e0_.id = l3_.exh_text_id
  LEFT JOIN `locale_meta` l4_ ON e0_.id = l4_.exh_description_id
  LEFT JOIN `locale_meta` l5_ ON e0_.id = l5_.exh_keywords_id
  LEFT JOIN `locale_preview` l6_ ON e0_.id = l6_.exh_id
  LEFT JOIN `likes` l7_ ON e0_.id = l7_.exh_id
  LEFT JOIN `user` u8_ ON e0_.author_id = u8_.id
  LEFT JOIN `locale_bool` l9_ ON e0_.id = l9_.exh_show_id
  LEFT JOIN `locale_status_translate` l10_ ON e0_.id = l10_.exh_id
  LEFT JOIN `locale_bool` l11_ ON e0_.id = l11_.exh_hide_single_id
WHERE
  e0_.`id` IN (?)

SELECT e0_.`id` AS id_0, e0_.`enable` AS enable_1, e0_.`unid` AS unid_2, e0_.`view` AS view_3, e0_.`created_at` AS created_at_4, e0_.`updated_at` AS updated_at_5, l1_.`id` AS id_6, l1_.`source` AS source_7, l1_.`ru` AS ru_8, l1_.`en` AS en_9, l1_.`it` AS it_10, l1_.`es` AS es_11, l1_.`fr` AS fr_12, l1_.`de` AS de_13, l1_.`pl` AS pl_14, l1_.`pt` AS pt_15, l1_.`nl` AS nl_16, l1_.`fi` AS fi_17, l1_.`ua` AS ua_18, l1_.`sv` AS sv_19, l1_.`no` AS no_20, l1_.`da` AS da_21, l1_.`cn` AS cn_22, l1_.`zh` AS zh_23, l1_.`created_at` AS created_at_24, l1_.`updated_at` AS updated_at_25, l2_.`id` AS id_26, l2_.`source` AS source_27, l2_.`ru` AS ru_28, l2_.`en` AS en_29, l2_.`it` AS it_30, l2_.`es` AS es_31, l2_.`fr` AS fr_32, l2_.`de` AS de_33, l2_.`pl` AS pl_34, l2_.`pt` AS pt_35, l2_.`nl` AS nl_36, l2_.`fi` AS fi_37, l2_.`ua` AS ua_38, l2_.`sv` AS sv_39, l2_.`no` AS no_40, l2_.`da` AS da_41, l2_.`cn` AS cn_42, l2_.`zh` AS zh_43, l2_.`created_at` AS created_at_44, l2_.`updated_at` AS updated_at_45, l3_.`id` AS id_46, l3_.`source` AS source_47, l3_.`ru` AS ru_48, l3_.`en` AS en_49, l3_.`it` AS it_50, l3_.`es` AS es_51, l3_.`fr` AS fr_52, l3_.`de` AS de_53, l3_.`pl` AS pl_54, l3_.`pt` AS pt_55, l3_.`nl` AS nl_56, l3_.`fi` AS fi_57, l3_.`ua` AS ua_58, l3_.`sv` AS sv_59, l3_.`no` AS no_60, l3_.`da` AS da_61, l3_.`cn` AS cn_62, l3_.`zh` AS zh_63, l3_.`created_at` AS created_at_64, l3_.`updated_at` AS updated_at_65, l4_.`id` AS id_66, l4_.`source` AS source_67, l4_.`ru` AS ru_68, l4_.`en` AS en_69, l4_.`it` AS it_70, l4_.`es` AS es_71, l4_.`fr` AS fr_72, l4_.`de` AS de_73, l4_.`pl` AS pl_74, l4_.`pt` AS pt_75, l4_.`nl` AS nl_76, l4_.`fi` AS fi_77, l4_.`ua` AS ua_78, l4_.`sv` AS sv_79, l4_.`no` AS no_80, l4_.`da` AS da_81, l4_.`cn` AS cn_82, l4_.`zh` AS zh_83, l4_.`created_at` AS created_at_84, l4_.`updated_at` AS updated_at_85, l5_.`id` AS id_86, l5_.`source` AS source_87, l5_.`ru` AS ru_88, l5_.`en` AS en_89, l5_.`it` AS it_90, l5_.`es` AS es_91, l5_.`fr` AS fr_92, l5_.`de` AS de_93, l5_.`pl` AS pl_94, l5_.`pt` AS pt_95, l5_.`nl` AS nl_96, l5_.`fi` AS fi_97, l5_.`ua` AS ua_98, l5_.`sv` AS sv_99, l5_.`no` AS no_100, l5_.`da` AS da_101, l5_.`cn` AS cn_102, l5_.`zh` AS zh_103, l5_.`created_at` AS created_at_104, l5_.`updated_at` AS updated_at_105, l6_.`id` AS id_106, l6_.`def` AS def_107, l6_.`ru` AS ru_108, l6_.`en` AS en_109, l6_.`it` AS it_110, l6_.`es` AS es_111, l6_.`fr` AS fr_112, l6_.`de` AS de_113, l6_.`pl` AS pl_114, l6_.`pt` AS pt_115, l6_.`nl` AS nl_116, l6_.`fi` AS fi_117, l6_.`ua` AS ua_118, l6_.`sv` AS sv_119, l6_.`no` AS no_120, l6_.`da` AS da_121, l6_.`cn` AS cn_122, l6_.`zh` AS zh_123, l6_.`created_at` AS created_at_124, l6_.`updated_at` AS updated_at_125, l7_.`id` AS id_126, l7_.`token` AS token_127, u8_.`id` AS id_128, u8_.`unid` AS unid_129, u8_.`corporate_unid` AS corporate_unid_130, u8_.`token` AS token_131, u8_.`is_active` AS is_active_132, u8_.`proved` AS proved_133, u8_.`alias` AS alias_134, u8_.`foreign_alias` AS foreign_alias_135, u8_.`lotus_name` AS lotus_name_136, u8_.`password` AS password_137, u8_.`expired` AS expired_138, u8_.`expires_at` AS expires_at_139, u8_.`credentials_expired` AS credentials_expired_140, u8_.`credentials_expire_at` AS credentials_expire_at_141, u8_.`last_ip` AS last_ip_142, u8_.`source` AS source_143, u8_.`social_network` AS social_network_144, u8_.`social_network_id` AS social_network_id_145, u8_.`google_id` AS google_id_146, u8_.`fb_id` AS fb_id_147, u8_.`vk_id` AS vk_id_148, u8_.`ig_id` AS ig_id_149, u8_.`test` AS test_150, u8_.`token_fixed` AS token_fixed_151, u8_.`bid` AS bid_152, u8_.`email` AS email_153, u8_.`salt` AS salt_154, u8_.`review_request_sent` AS review_request_sent_155, u8_.`username` AS username_156, u8_.`roles` AS roles_157, u8_.`enabled` AS enabled_158, u8_.`confirmation_token` AS confirmation_token_159, u8_.`last_login` AS last_login_160, u8_.`password_requested_at` AS password_requested_at_161, u8_.`security_field` AS security_field_162, u8_.`created_at` AS created_at_163, u8_.`is_legal_entity` AS is_legal_entity_164, u8_.`companyName` AS companyName_165, u8_.`vatNumber` AS vatNumber_166, u8_.`lang` AS lang_167, l9_.`id` AS id_168, l9_.`source` AS source_169, l9_.`ru` AS ru_170, l9_.`en` AS en_171, l9_.`it` AS it_172, l9_.`es` AS es_173, l9_.`fr` AS fr_174, l9_.`de` AS de_175, l9_.`pl` AS pl_176, l9_.`pt` AS pt_177, l9_.`nl` AS nl_178, l9_.`fi` AS fi_179, l9_.`ua` AS ua_180, l9_.`sv` AS sv_181, l9_.`no` AS no_182, l9_.`da` AS da_183, l9_.`cn` AS cn_184, l9_.`zh` AS zh_185, l9_.`created_at` AS created_at_186, l9_.`updated_at` AS updated_at_187, l10_.`id` AS id_188, l10_.`ru` AS ru_189, l10_.`en` AS en_190, l10_.`it` AS it_191, l10_.`es` AS es_192, l10_.`fr` AS fr_193, l10_.`de` AS de_194, l10_.`pl` AS pl_195, l10_.`pt` AS pt_196, l10_.`nl` AS nl_197, l10_.`fi` AS fi_198, l10_.`ua` AS ua_199, l10_.`sv` AS sv_200, l10_.`no` AS no_201, l10_.`da` AS da_202, l10_.`cn` AS cn_203, l10_.`zh` AS zh_204, l10_.`created_at` AS created_at_205, l10_.`updated_at` AS updated_at_206, l11_.`id` AS id_207, l11_.`source` AS source_208, l11_.`ru` AS ru_209, l11_.`en` AS en_210, l11_.`it` AS it_211, l11_.`es` AS es_212, l11_.`fr` AS fr_213, l11_.`de` AS de_214, l11_.`pl` AS pl_215, l11_.`pt` AS pt_216, l11_.`nl` AS nl_217, l11_.`fi` AS fi_218, l11_.`ua` AS ua_219, l11_.`sv` AS sv_220, l11_.`no` AS no_221, l11_.`da` AS da_222, l11_.`cn` AS cn_223, l11_.`zh` AS zh_224, l11_.`created_at` AS created_at_225, l11_.`updated_at` AS updated_at_226 FROM `exh` e0_ LEFT JOIN `locale_url` l1_ ON e0_.id = l1_.exh_id LEFT JOIN `locale_title` l2_ ON e0_.id = l2_.exh_title_id LEFT JOIN `locale_html` l3_ ON e0_.id = l3_.exh_text_id LEFT JOIN `locale_meta` l4_ ON e0_.id = l4_.exh_description_id LEFT JOIN `locale_meta` l5_ ON e0_.id = l5_.exh_keywords_id LEFT JOIN `locale_preview` l6_ ON e0_.id = l6_.exh_id LEFT JOIN `likes` l7_ ON e0_.id = l7_.exh_id LEFT JOIN `user` u8_ ON e0_.author_id = u8_.id LEFT JOIN `locale_bool` l9_ ON e0_.id = l9_.exh_show_id LEFT JOIN `locale_status_translate` l10_ ON e0_.id = l10_.exh_id LEFT JOIN `locale_bool` l11_ ON e0_.id = l11_.exh_hide_single_id WHERE e0_.`id` IN (16, 13, 9, 5, 4);

SELECT
  lurl.fr AS `url`,
  lurl.en AS `key`,
  f.alt_name AS `alt`,
  f.id AS `id`
FROM
  filters f
  LEFT JOIN locale_url lurl ON f.id = lurl.filter_id
WHERE
  f.id IN (10592, 10591)

SELECT
               lurl.fr AS `url`,
               lurl.en AS `key`,
               f.alt_name AS `alt`,
               f.id AS `id`
        FROM
            filters f
        LEFT JOIN locale_url lurl ON f.id = lurl.filter_id
        WHERE f.id IN (10592,10591);

SELECT
  c0_.`id` AS id_0
FROM
  `collection` c0_
  LEFT JOIN `factory` f1_ ON c0_.factory = f1_.id
  LEFT JOIN `filters` f2_ ON f1_.filter = f2_.id
WHERE
  c0_.`status` = ?
  AND c0_.`show_main` = ?
  AND (
    c0_.`accessible` <> ?
    OR c0_.`accessible` IS NULL
  )
  AND f1_.filter IS NOT NULL
  AND f1_.`status` = ?
  AND c0_.factory <> ?
  AND (
    c0_.`test_access` IS NULL
    OR c0_.`test_access` = 0
  )
  AND (
    f1_.`test_access` IS NULL
    OR f1_.`test_access` = 0
  )
ORDER BY
  c0_.`publish_date` DESC,
  c0_.`id` ASC
LIMIT
  1

SELECT c0_.`id` AS id_0 FROM `collection` c0_ LEFT JOIN `factory` f1_ ON c0_.factory = f1_.id LEFT JOIN `filters` f2_ ON f1_.filter = f2_.id WHERE c0_.`status` = 1 AND c0_.`show_main` = 1 AND (c0_.`accessible` <> 1 OR c0_.`accessible` IS NULL) AND f1_.filter IS NOT NULL AND f1_.`status` = 1 AND c0_.factory <> '' AND (c0_.`test_access` IS NULL OR c0_.`test_access` = 0) AND (f1_.`test_access` IS NULL OR f1_.`test_access` = 0) ORDER BY c0_.`publish_date` DESC, c0_.`id` ASC LIMIT 1;

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` = 'be';

SELECT
  (
    SELECT
      COUNT(p0_.`star`) AS sclr_1
    FROM
      `product_reviews_cache` p0_
    WHERE
      p0_.`sku` = c1_.`code`
  ) AS sclr_0,
  (
    SELECT
      SUM(p2_.`star`) AS sclr_3
    FROM
      `product_reviews_cache` p2_
    WHERE
      p2_.`sku` = c1_.`code`
  ) AS sclr_2,
  c1_.`id` AS id_4,
  c1_.`unid` AS unid_5,
  c1_.`code` AS code_6,
  c1_.`name` AS name_7,
  c1_.`alternate_name` AS alternate_name_8,
  c1_.`name_full` AS name_full_9,
  c1_.`url` AS url_10,
  c1_.`status` AS status_11,
  c1_.`type` AS type_12,
  c1_.`typeSet` AS typeSet_13,
  c1_.`pc_as_m` AS pc_as_m_14,
  c1_.`publish_date` AS publish_date_15,
  c1_.`update_date` AS update_date_16,
  c1_.`archive` AS archive_17,
  c1_.`pr_min_euro` AS pr_min_euro_18,
  c1_.`pr_min_euro_de` AS pr_min_euro_de_19,
  c1_.`pr_min_euro_at` AS pr_min_euro_at_20,
  c1_.`pr_min_euro_fi` AS pr_min_euro_fi_21,
  c1_.`pr_min_euro_fr` AS pr_min_euro_fr_22,
  c1_.`pr_min_euro_it` AS pr_min_euro_it_23,
  c1_.`pr_min_euro_be` AS pr_min_euro_be_24,
  c1_.`pr_min_euro_ie` AS pr_min_euro_ie_25,
  c1_.`pr_min_euro_nl` AS pr_min_euro_nl_26,
  c1_.`pr_min_euro_es` AS pr_min_euro_es_27,
  c1_.`pr_min_rub` AS pr_min_rub_28,
  c1_.`pr_min_rue` AS pr_min_rue_29,
  c1_.`pr_min_gbp` AS pr_min_gbp_30,
  c1_.`pr_min_gbe` AS pr_min_gbe_31,
  c1_.`pr_min_usd` AS pr_min_usd_32,
  c1_.`pr_min_use` AS pr_min_use_33,
  c1_.`pr_min_f_usd` AS pr_min_f_usd_34,
  c1_.`pr_min_f_use` AS pr_min_f_use_35,
  c1_.`pr_min_chf` AS pr_min_chf_36,
  c1_.`pr_min_che` AS pr_min_che_37,
  c1_.`pr_min_sek` AS pr_min_sek_38,
  c1_.`pr_min_see` AS pr_min_see_39,
  c1_.`pr_min_dkk` AS pr_min_dkk_40,
  c1_.`pr_min_dke` AS pr_min_dke_41,
  c1_.`pr_min_nok` AS pr_min_nok_42,
  c1_.`pr_min_noe` AS pr_min_noe_43,
  c1_.`pr_min_pln` AS pr_min_pln_44,
  c1_.`pr_min_ple` AS pr_min_ple_45,
  c1_.`pr_min_cad` AS pr_min_cad_46,
  c1_.`pr_min_cae` AS pr_min_cae_47,
  c1_.`pr_min_f_cad` AS pr_min_f_cad_48,
  c1_.`pr_min_f_cae` AS pr_min_f_cae_49,
  c1_.`pr_min_ed` AS pr_min_ed_50,
  c1_.`important` AS important_51,
  c1_.`author` AS author_52,
  c1_.`author_id` AS author_id_53,
  c1_.`rating` AS rating_54,
  c1_.`header` AS header_55,
  c1_.`settings` AS settings_56,
  c1_.`fids` AS fids_57,
  c1_.`portal_unid` AS portal_unid_58,
  c1_.`accepted_at` AS accepted_at_59,
  c1_.`accept_state` AS accept_state_60,
  c1_.`description_edit` AS description_edit_61,
  c1_.`link_award` AS link_award_62,
  c1_.`awards` AS awards_63,
  c1_.`video` AS video_64,
  c1_.`stated_at` AS stated_at_65,
  c1_.`state` AS state_66,
  c1_.`description_state` AS description_state_67,
  c1_.`body_hide` AS body_hide_68,
  c1_.`release_year` AS release_year_69,
  c1_.`site` AS site_70,
  c1_.`show_main` AS show_main_71,
  c1_.`glue_url` AS glue_url_72,
  c1_.`accessible` AS accessible_73,
  c1_.`delivery_suspended` AS delivery_suspended_74,
  c1_.`process` AS process_75,
  c1_.`exhibition` AS exhibition_76,
  c1_.`test_access` AS test_access_77,
  c1_.`views` AS views_78,
  c1_.`comment_unid` AS comment_unid_79,
  c1_.`accesible_at` AS accesible_at_80,
  c1_.`created_at` AS created_at_81,
  c1_.`updated_at` AS updated_at_82,
  f3_.`id` AS id_83,
  f3_.`unid` AS unid_84,
  f3_.`name` AS name_85,
  f3_.`name_inv` AS name_inv_86,
  f3_.`url` AS url_87,
  f3_.`alternate_name` AS alternate_name_88,
  f3_.`description_ru` AS description_ru_89,
  f3_.`description_en` AS description_en_90,
  f3_.`description_it` AS description_it_91,
  f3_.`description_es` AS description_es_92,
  f3_.`description_fr` AS description_fr_93,
  f3_.`description_de` AS description_de_94,
  f3_.`description_pt` AS description_pt_95,
  f3_.`description_pl` AS description_pl_96,
  f3_.`description_nl` AS description_nl_97,
  f3_.`description_fi` AS description_fi_98,
  f3_.`description_ua` AS description_ua_99,
  f3_.`description_sv` AS description_sv_100,
  f3_.`description_no` AS description_no_101,
  f3_.`description_da` AS description_da_102,
  f3_.`description_zh` AS description_zh_103,
  f3_.`delivery_time` AS delivery_time_104,
  f3_.`not_regular` AS not_regular_105,
  f3_.`suspended` AS suspended_106,
  f3_.`status` AS status_107,
  f3_.`type` AS type_108,
  f3_.`discount` AS discount_109,
  f3_.`discount_date_start` AS discount_date_start_110,
  f3_.`discount_date_end` AS discount_date_end_111,
  f3_.`transcription` AS transcription_112,
  f3_.`cost_delivery` AS cost_delivery_113,
  f3_.`create_date` AS create_date_114,
  f3_.`is_accepted` AS is_accepted_115,
  f3_.`accepted_at` AS accepted_at_116,
  f3_.`accept_state` AS accept_state_117,
  f3_.`description_edit` AS description_edit_118,
  f3_.`stated_at` AS stated_at_119,
  f3_.`state` AS state_120,
  f3_.`description_state` AS description_state_121,
  f3_.`video` AS video_122,
  f3_.`parser_address` AS parser_address_123,
  f3_.`accessible` AS accessible_124,
  f3_.`sound` AS sound_125,
  f3_.`test_access` AS test_access_126,
  f3_.`total_ideas` AS total_ideas_127,
  f3_.`votes_submit` AS votes_submit_128,
  f3_.`votes_stars` AS votes_stars_129,
  f3_.`brand_link` AS brand_link_130,
  f3_.`brand_logo` AS brand_logo_131,
  f3_.`no_send_portl_message` AS no_send_portl_message_132,
  l4_.`id` AS id_133,
  l4_.`code` AS code_134,
  l4_.`locale` AS locale_135,
  l4_.`phone_code` AS phone_code_136,
  l4_.`phone_mask` AS phone_mask_137,
  l4_.`min_valid_phone_numbers` AS min_valid_phone_numbers_138,
  l4_.`zip_code_mask` AS zip_code_mask_139,
  l4_.`percent_vat` AS percent_vat_140,
  l4_.`name` AS name_141,
  l4_.`name_en` AS name_en_142,
  l4_.`alias` AS alias_143,
  l4_.`sort` AS sort_144,
  l4_.`count` AS count_145,
  l4_.`hide` AS hide_146,
  l4_.`important` AS important_147,
  l4_.`pay_pal_percent` AS pay_pal_percent_148,
  l4_.`pay_pal_percent_own` AS pay_pal_percent_own_149,
  l4_.`vat` AS vat_150,
  l4_.`pv_type` AS pv_type_151,
  l4_.`capital_timezone_diff` AS capital_timezone_diff_152,
  l4_.`capital` AS capital_153,
  l4_.`free_sample_delivery` AS free_sample_delivery_154,
  l4_.`units` AS units_155,
  i5_.`id` AS id_156,
  i5_.`name` AS name_157,
  i5_.`alt` AS alt_158,
  i5_.`is_head` AS is_head_159,
  i5_.`is_main` AS is_main_160,
  i5_.`file_size_x` AS file_size_x_161,
  i5_.`file_size_y` AS file_size_y_162,
  i5_.`file_size_z_x` AS file_size_z_x_163,
  i5_.`file_size_z_y` AS file_size_z_y_164,
  i5_.`file_size_hd_x` AS file_size_hd_x_165,
  i5_.`file_size_hd_y` AS file_size_hd_y_166,
  i5_.`file_size_shd_x` AS file_size_shd_x_167,
  i5_.`file_size_shd_y` AS file_size_shd_y_168,
  i5_.`file_size500_x` AS file_size500_x_169,
  i5_.`file_size500_y` AS file_size500_y_170,
  i5_.`file_size740_x` AS file_size740_x_171,
  i5_.`file_size740_y` AS file_size740_y_172,
  i5_.`data_article_no_portal` AS data_article_no_portal_173,
  i5_.`file` AS file_174,
  i5_.`collection_id` AS collection_id_175,
  i5_.`name_old` AS name_old_176,
  i5_.`file_size4k_x` AS file_size4k_x_177,
  i5_.`file_size4k_y` AS file_size4k_y_178,
  i5_.`is_edit` AS is_edit_179,
  i5_.`edited_at` AS edited_at_180,
  i5_.`comment` AS comment_181,
  i5_.`status` AS status_182,
  i5_.`is_manual_status` AS is_manual_status_183,
  i5_.`render_status` AS render_status_184,
  i5_.`image_added_at` AS image_added_at_185,
  i5_.`url` AS url_186,
  i5_.`ideasCount` AS ideasCount_187,
  i5_.`gravity` AS gravity_188,
  i5_.`process` AS process_189,
  i6_.`id` AS id_190,
  i6_.`token` AS token_191,
  i6_.`name` AS name_192,
  i6_.`create_date` AS create_date_193,
  i6_.`update_date` AS update_date_194,
  i6_.`process` AS process_195
FROM
  `collection` c1_
  INNER JOIN `factory` f3_ ON c1_.factory = f3_.id
  INNER JOIN `filters` f7_ ON f3_.filter = f7_.id
  INNER JOIN `list_country` l4_ ON f3_.country = l4_.id
  LEFT JOIN `interior` i5_ ON c1_.id = i5_.collection
  LEFT JOIN idea_interior i8_ ON i5_.id = i8_.interior_id
  LEFT JOIN `idea` i6_ ON i6_.id = i8_.idea_id
WHERE
  f3_.filter IS NOT NULL
  AND c1_.factory <> ''
  AND f3_.`status` = ?
  AND (
    c1_.`test_access` IS NULL
    OR c1_.`test_access` = 0
  )
  AND (
    f3_.`test_access` IS NULL
    OR f3_.`test_access` = 0
  )
  AND c1_.`status` = ?
  AND c1_.`id` IN (3256252)
GROUP BY
  c1_.`id`
ORDER BY
  c1_.`publish_date` DESC,
  c1_.`id` ASC,
  i5_.`is_main` DESC