https://dev5.tile.expert/_fragment?_path=_format%3Dhtml%26_locale%3Dpl%26_controller%3DWebBundle%255CController%255CHomeController%253A%253AcarouselAction

Method
GET
HTTP Status
200
IP
216.73.216.124
Profiled on
Token
a7784b

Query Metrics

28 Database Queries
26 Different statements
309.11 ms Query time
0 Invalid entities

Queries

Group similar statements

default connection

#▲ Time Info
1 2.63 ms 
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_.`pl` = 1 AND l1_.`pl` <> '' AND l3_.`pl` = ? AND p0_.`id` <> ? ORDER BY p0_.`publish_date` ASC
Parameters: 
[
  0
  2235
]
View formatted query    View runnable query    Explain query
2 1.36 ms 
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_.`pl` = 1 AND l1_.`pl` <> '' AND l3_.`pl` = ?
Parameters: 
[
  0
]
View formatted query    View runnable query    Explain query
3 9.55 ms 
SELECT
                p.id,
                p.enable,
                p.unid,
                p.view,
                p.publish_date AS `publishDate`,
                p.hide_countries AS `hideCountries`,
                lcurl.pl AS `url`,
                lctitle.pl AS `title`,
                lchtml.pl AS `body`,
                lcssShow.pl AS `statusShow`,
                lchs.pl AS `hideSingle`,
                lcpw.def AS `preview.def`,
                lcpw.en AS `preview.en`,
                lcpw.pl 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 = 'pl'

            WHERE p.id IN (2308,2302,2305,2296,2293,2290,2287,2278,2249,2241,2232)
            GROUP BY p.id;
Parameters: 
[]
View formatted query    View runnable query    Explain query
4 14.40 ms 
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 (?)
Parameters: 
[
  [
    16
    13
    9
    5
    4
  ]
]
View formatted query    View runnable query    Explain query
5 0.56 ms 
SELECT
               lurl.pl 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)
Parameters: 
[]
View formatted query    View runnable query    Explain query
6 31.29 ms 
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
Parameters: 
[
  1
  1
  1
  1
  ""
]
View formatted query    View runnable query    Explain query
7 0.28 ms 
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` = ?
Parameters: 
[
  "pl"
]
View formatted query    View runnable query    Explain query
8 25.53 ms 
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 f3_.`id` NOT IN (?) 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
Parameters: 
[
  1
  [
    125
  ]
  1
]
View formatted query    View runnable query    Explain query
9 16.84 ms 
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.`id` IN (?)
Parameters: 
[
  [
    3256252
  ]
]
View formatted query    View runnable query    Explain query
10 0.39 ms 
SELECT l0_.`pl` AS pl_0 FROM `publication` p1_ LEFT JOIN `locale_url` l0_ ON p1_.id = l0_.publication_id WHERE p1_.`id` = ?
Parameters: 
[
  2232
]
View formatted query    View runnable query    Explain query
11 0.50 ms 
SELECT u0_.`id` AS id_0, u0_.`unid` AS unid_1, u0_.`corporate_unid` AS corporate_unid_2, u0_.`token` AS token_3, u0_.`is_active` AS is_active_4, u0_.`proved` AS proved_5, u0_.`alias` AS alias_6, u0_.`foreign_alias` AS foreign_alias_7, u0_.`lotus_name` AS lotus_name_8, u0_.`password` AS password_9, u0_.`expired` AS expired_10, u0_.`expires_at` AS expires_at_11, u0_.`credentials_expired` AS credentials_expired_12, u0_.`credentials_expire_at` AS credentials_expire_at_13, u0_.`last_ip` AS last_ip_14, u0_.`source` AS source_15, u0_.`social_network` AS social_network_16, u0_.`social_network_id` AS social_network_id_17, u0_.`google_id` AS google_id_18, u0_.`fb_id` AS fb_id_19, u0_.`vk_id` AS vk_id_20, u0_.`ig_id` AS ig_id_21, u0_.`test` AS test_22, u0_.`token_fixed` AS token_fixed_23, u0_.`bid` AS bid_24, u0_.`email` AS email_25, u0_.`salt` AS salt_26, u0_.`review_request_sent` AS review_request_sent_27, u0_.`username` AS username_28, u0_.`roles` AS roles_29, u0_.`enabled` AS enabled_30, u0_.`confirmation_token` AS confirmation_token_31, u0_.`last_login` AS last_login_32, u0_.`password_requested_at` AS password_requested_at_33, u0_.`security_field` AS security_field_34, u0_.`created_at` AS created_at_35, u0_.`is_legal_entity` AS is_legal_entity_36, u0_.`companyName` AS companyName_37, u0_.`vatNumber` AS vatNumber_38, u0_.`lang` AS lang_39 FROM `user` u0_ WHERE u0_.`token` = ? LIMIT 1
Parameters: 
[
  "36a83b3845f52b899df643eb26a9fd8a1e7108a7badf5f60457c1605a55d25f0"
]
View formatted query    View runnable query    Explain query
12 0.33 ms 
SELECT COUNT(b0_.`code`) AS sclr_0 FROM `buy_order` b1_ LEFT JOIN `buy_order_article` b0_ ON b1_.id = b0_.buy_order_id WHERE b1_.`token` = ? AND b1_.`status` <> 12
Parameters: 
[
  "36a83b3845f52b899df643eb26a9fd8a1e7108a7badf5f60457c1605a55d25f0"
]
View formatted query    View runnable query    Explain query
13 0.25 ms 
SELECT b0_.`id` AS id_0 FROM `buy_order` b0_ WHERE b0_.`token` = ? AND b0_.`status` <> 12
Parameters: 
[
  "36a83b3845f52b899df643eb26a9fd8a1e7108a7badf5f60457c1605a55d25f0"
]
View formatted query    View runnable query    Explain query
14 0.30 ms 
SELECT COUNT(v0_.`id`) AS sclr_0 FROM `visit` v0_ WHERE v0_.`token` = ? AND v0_.`url` <> '/.*catalog.*/'
Parameters: 
[
  "36a83b3845f52b899df643eb26a9fd8a1e7108a7badf5f60457c1605a55d25f0"
]
View formatted query    View runnable query    Explain query
15 0.29 ms 
SELECT COUNT(i0_.`id`) AS sclr_0 FROM `idea` i1_ INNER JOIN idea_interior i2_ ON i1_.id = i2_.idea_id INNER JOIN `interior` i0_ ON i0_.id = i2_.interior_id WHERE i1_.`token` = ?
Parameters: 
[
  "36a83b3845f52b899df643eb26a9fd8a1e7108a7badf5f60457c1605a55d25f0"
]
View formatted query    View runnable query    Explain query
16 0.20 ms 
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` = ?
Parameters: 
[
  "RTWidget"
]
View formatted query    View runnable query    Explain query
17 0.58 ms 
SELECT t0.`id` AS id_1, t0.`token` AS token_2, t0.`current_welcome_cons` AS current_welcome_cons_3, t0.`current_country` AS current_country_4, t0.`current_country_by_ip` AS current_country_by_ip_5, t0.`current_locale` AS current_locale_6, t0.`is_interview` AS is_interview_7, t0.`job_seeker_unid` AS job_seeker_unid_8, t0.interview_id AS interview_id_9 FROM `chat_b` t0 WHERE t0.`token` = ? LIMIT 1
Parameters: 
[
  "36a83b3845f52b899df643eb26a9fd8a1e7108a7badf5f60457c1605a55d25f0"
]
View formatted query    View runnable query    Explain query
18 0.33 ms 
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` = ?
Parameters: 
[
  "RTWidget"
]
View formatted query    View runnable query    Explain query
19 79.69 ms 
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 f1_.`id` NOT IN (?) 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
Parameters: 
[
  1
  [
    125
  ]
  1
  1
  1
]
View formatted query    View runnable query    Explain query
20 3.90 ms 
SELECT COUNT(f0_.`id`) AS sclr_0 FROM `filters` f0_ LEFT JOIN `factory` f1_ ON f0_.brand = f1_.id LEFT JOIN `filter_params` f2_ ON f0_.param_id = f2_.id WHERE f0_.brand IS NOT NULL AND f0_.`id` <> 10639 AND f1_.`status` = ? AND f2_.`is_enable` = 1 AND f2_.`count` >= 0 AND f1_.`unid` IS NOT NULL AND f1_.`test_access` IS NULL ORDER BY f0_.`name` ASC
Parameters: 
[
  1
]
View formatted query    View runnable query    Explain query
21 0.56 ms 
SELECT
       			lu.pl AS slug
            FROM
                publication p
            LEFT JOIN `locale_url` `lu` ON `lu`.publication_id = `p`.id
            LEFT JOIN `locale_bool` `lp` ON `lp`.blog_show_id = `p`.id
            LEFT JOIN `locale_status_translate` `lst` ON `lst`.publication_id = `p`.id
			WHERE p.id = 2232 AND lp.pl = 1 AND lst.pl = 1;
Parameters: 
[]
View formatted query    View runnable query    Explain query
22 1.24 ms 
SELECT f0_.`id` AS id_0, f0_.`old_command` AS old_command_1, f0_.`old_id` AS old_id_2, f0_.`left_menu` AS left_menu_3, f1_.`id` AS id_4, f0_.`important` AS important_5, l2_.`pl` AS pl_6, f3_.`name_menu_pl` AS name_menu_pl_7, f4_.`alt_name` AS alt_name_8, f5_.`count` AS count_9, f0_.`id` AS id_10, f0_.`name` AS name_11, f0_.`alt_name` AS alt_name_12, f0_.`left_menu` AS left_menu_13, f0_.`sort` AS sort_14, f0_.`important` AS important_15, f0_.`old_command` AS old_command_16, f0_.`old_id` AS old_id_17, f0_.`sub_key` AS sub_key_18, f0_.`parent_key` AS parent_key_19, f0_.`rank` AS rank_20, f0_.`icon` AS icon_21, f0_.`icon_url` AS icon_url_22, f0_.`logo` AS logo_23, f0_.`logo_url` AS logo_url_24, f0_.`created_at` AS created_at_25, f0_.`updated_at` AS updated_at_26, f6_.`id` AS id_27, f6_.`name` AS name_28, f6_.`alt_name` AS alt_name_29, f6_.`left_menu` AS left_menu_30, f6_.`sort` AS sort_31, f6_.`important` AS important_32, f6_.`old_command` AS old_command_33, f6_.`old_id` AS old_id_34, f6_.`sub_key` AS sub_key_35, f6_.`parent_key` AS parent_key_36, f6_.`rank` AS rank_37, f6_.`icon` AS icon_38, f6_.`icon_url` AS icon_url_39, f6_.`logo` AS logo_40, f6_.`logo_url` AS logo_url_41, f6_.`created_at` AS created_at_42, f6_.`updated_at` AS updated_at_43 FROM `filters` f0_ LEFT JOIN `locale_url` l2_ ON f0_.id = l2_.filter_id LEFT JOIN `filter_pages` f3_ ON f0_.page_id = f3_.id LEFT JOIN `filter_params` f5_ ON f0_.param_id = f5_.id LEFT JOIN `filter_groups` f4_ ON f0_.group_id = f4_.id LEFT JOIN `filters` f6_ ON f0_.country_id = f6_.id LEFT JOIN `filters` f1_ ON f0_.parent_id = f1_.id WHERE f5_.`is_enable` = 1 AND (f5_.`show_menu` = 1 OR f5_.`show_menu_advanced` = 1) AND l2_.`pl` IS NOT NULL AND f5_.`count` > 0 AND f4_.`alt_name` IN (?) ORDER BY f0_.`sort` ASC, f0_.`name` ASC
Parameters: 
[
  [
    "effect"
    "style"
    "samples"
    "price"
    "color"
    "using"
    "brand"
  ]
]
View formatted query    View runnable query    Explain query
23 25.26 ms 
SELECT f.id, f.rank AS `rank`, f.alt_name AS `altName`, f.old_command AS `sphinxName`, f.old_id AS `sphinxId`, htmlshow.pl AS `isHtmlShow`, fp.name_menu_pl AS `nameMenu`, fp.name_many_pl AS `nameMany`, fp.name_single_pl AS `nameSingle`, fp.html_pl AS `html`, fp.description_pl AS `description`, metadesc.pl AS `metaDescriptionName`, par.count AS `count`, par.code AS `code`, par.is_enable AS `isEnable`, gr.id AS `groupId`, gr.alt_name AS `groupAltName`, gpname.pl AS `groupName`, url.pl AS `slug`, url.ru AS `slug.ru`, url.en AS `slug.en`, url.it AS `slug.it`, url.es AS `slug.es`, url.fr AS `slug.fr`, url.de AS `slug.de`, url.pl AS `slug.pl`, url.nl AS `slug.nl`, url.fi AS `slug.fi`, url.sv AS `slug.sv`, b.id AS `brandId`, b.status AS `brandStatus`, b.stated_at AS `brandStatedAt`, b.type AS `brandType`, b.name AS `brandName`, f.logo AS `brandLogo`, f.logo_url AS `brandLogoUrl`, b.sound AS `brandSound`, b.video AS `brandVideo`, cn.id AS `countryId`, cnfp.name_single_pl AS `countryName`, cnurl.pl AS `countrySlug`, cnpar.code AS `countryCode` FROM filters f LEFT JOIN filter_pages fp ON fp.id = f.page_id LEFT JOIN filter_params par ON par.id = f.param_id LEFT JOIN filter_groups gr ON gr.id = f.group_id LEFT JOIN locale_text gpname ON gpname.filter_group_name = gr.id LEFT JOIN locale_text metadesc ON metadesc.filter_name_for_meta_descr_id = f.id LEFT JOIN locale_url url ON url.filter_id = f.id LEFT JOIN locale_bool htmlshow ON htmlshow.filter_html_show_id = f.id LEFT JOIN factory b ON b.id = f.brand LEFT JOIN filters cn ON cn.id = f.country_id LEFT JOIN filter_pages cnfp ON cnfp.id = cn.page_id LEFT JOIN locale_url cnurl ON cnurl.filter_id = cn.id LEFT JOIN filter_params cnpar ON cnpar.id = cn.param_id WHERE url.ru = :slug OR url.en = :slug OR url.it = :slug OR url.es = :slug OR url.fr = :slug OR url.de = :slug OR url.pl = :slug OR url.nl = :slug OR url.fi = :slug OR url.sv = :slug
Parameters: 
[
  "slug" => "recently-added-tiles"
]
View formatted query    View runnable query    Explain query
24 0.12 ms 
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;
Parameters: 
[]
View formatted query    View runnable query    Explain query
25 0.51 ms 
SELECT i0_.`id` AS id_0 FROM `idea` i1_ INNER JOIN idea_interior i2_ ON i1_.id = i2_.idea_id INNER JOIN `interior` i0_ ON i0_.id = i2_.interior_id WHERE i1_.`token` = ? GROUP BY i0_.`id`
Parameters: 
[
  "36a83b3845f52b899df643eb26a9fd8a1e7108a7badf5f60457c1605a55d25f0"
]
View formatted query    View runnable query    Explain query
26 31.31 ms 
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 20
Parameters: 
[
  1
  1
  1
  1
  ""
]
View formatted query    View runnable query    Explain query
27 54.22 ms 
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 f3_.`id` NOT IN (?) 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, 3256228, 3256249, 3256246, 3256174, 3256225, 3256222, 3256141, 3255772, 3256216, 3247145, 3256177, 3256180, 3256144, 3256168, 3256192, 3256165, 3256213, 3256138, 3256153) GROUP BY c1_.`id` ORDER BY c1_.`publish_date` DESC, c1_.`id` ASC, i5_.`is_main` DESC
Parameters: 
[
  1
  [
    125
  ]
  1
]
View formatted query    View runnable query    Explain query
28 6.67 ms 
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.`id` IN (?)
Parameters: 
[
  [
    3256252
    3256228
    3256249
    3256246
    3256174
    3256225
    3256222
    3256141
    3255772
    3256216
    3247145
    3256177
    3256180
    3256144
    3256168
    3256192
    3256165
    3256213
    3256138
    3256153
  ]
]
View formatted query    View runnable query    Explain query

oneC connection

No database queries were performed.

logs connection

No database queries were performed.

Database Connections

Name Service
default doctrine.dbal.default_connection
oneC doctrine.dbal.oneC_connection
logs doctrine.dbal.logs_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager
oneC doctrine.orm.oneC_entity_manager
logs doctrine.orm.logs_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

default entity manager

Class Mapping errors
WebBundle\Entity\User No errors.
WebBundle\Entity\Publication No errors.
FlexApp\Entity\Exhibition\ExhEntity No errors.
WebBundle\Entity\ProductReviewsCache No errors.
WebBundle\Entity\ReviewsCache No errors.
WebBundle\Entity\ListCountry No errors.
WebBundle\Entity\FilterEntity No errors.
WebBundle\Entity\Collection No errors.
WebBundle\Entity\Idea No errors.
WebBundle\Entity\InteriorHistory No errors.
FlexApp\Entity\ChatB No errors.
FlexApp\Entity\ChatBMessage No errors.
FlexApp\Entity\BoolDBSetting No errors.
FlexApp\Entity\Widget No errors.
FlexApp\Entity\CountryAndLangSpecificDataEntity No errors.
FlexApp\Entity\ConsultantEntity No errors.
WebBundle\Entity\LocaleUrlEntity No errors.
WebBundle\Entity\LocaleTitleEntity No errors.
WebBundle\Entity\LocaleHtmlEntity No errors.
WebBundle\Entity\LocaleMetaEntity No errors.
WebBundle\Entity\LocalePreviewEntity No errors.
FlexApp\Entity\LikesEntity No errors.
WebBundle\Entity\LocaleBoolEntity No errors.
WebBundle\Entity\LocaleStatusTranslateEntity No errors.
FlexApp\Entity\GeoCountryEntity No errors.
WebBundle\Entity\Factory No errors.
WebBundle\Entity\Interior No errors.
WebBundle\Entity\ListPrice No errors.
WebBundle\Entity\ListEmail No errors.
WebBundle\Entity\StaticPageEntity No errors.
WebBundle\Entity\TransEntity No errors.
FlexApp\Entity\Exhibition\ExhBrandEntity No errors.
FlexApp\Entity\Exhibition\ExhCollectionEntity No errors.
WebBundle\Entity\Article No errors.
WebBundle\Entity\CheckList No errors.
WebBundle\Entity\Visit No errors.
WebBundle\Entity\BuyOrder No errors.
WebBundle\Entity\OrderAddress No errors.
WebBundle\Entity\OrderHistory No errors.
WebBundle\Entity\OrderPayment No errors.
WebBundle\Entity\CurrencyRate No errors.
WebBundle\Entity\ListVat No errors.
WebBundle\Entity\WarehouseEntity No errors.
WebBundle\Entity\BuyOrderArticle No errors.
WebBundle\Entity\BuyOrderManager No errors.
FlexApp\Entity\InterviewEntity No errors.
WebBundle\Entity\TransExEntity No errors.
WebBundle\Entity\Participant No errors.
WebBundle\Entity\FactoryUser No errors.
WebBundle\Entity\PublicationLike No errors.
WebBundle\Entity\ListState No errors.
WebBundle\Entity\FilterPageEntity No errors.
WebBundle\Entity\FilterParamEntity No errors.
WebBundle\Entity\FilterGroupEntity No errors.
WebBundle\Entity\LocaleTextEntity No errors.
FlexApp\Entity\Exhibition\ExhImageEntity No errors.
FlexApp\Entity\AttachmentEntity No errors.
FlexApp\Entity\GeoLocaleNameEntity No errors.
FlexApp\Entity\GeoRegionEntity No errors.
WebBundle\Entity\ListBrandParser No errors.
WebBundle\Entity\ListTexture No errors.
WebBundle\Entity\ListStyle No errors.
WebBundle\Entity\ListApply No errors.
WebBundle\Entity\InteriorArticle No errors.
WebBundle\Entity\InteriorArticleLogging No errors.
WebBundle\Entity\ListUsing No errors.
WebBundle\Entity\ListEmailGroup No errors.
WebBundle\Entity\TransGroupsEntity No errors.
FlexApp\Entity\Exhibition\ExhLineEntity No errors.
FlexApp\Entity\Collection\CollectionEntity No errors.
WebBundle\Entity\ListType No errors.
WebBundle\Entity\ListMeasure No errors.
WebBundle\Entity\ListSurface No errors.
WebBundle\Entity\ListPRStatus No errors.
WebBundle\Entity\ListEdgeType No errors.
WebBundle\Entity\ListShape No errors.
WebBundle\Entity\ListMaterial No errors.
WebBundle\Entity\ListDelivery No errors.
WebBundle\Entity\ListSliding No errors.
WebBundle\Entity\ListOffShade No errors.
WebBundle\Entity\ListColor No errors.
WebBundle\Entity\ListFactoryColor No errors.
WebBundle\Entity\ListStoneTexture No errors.
WebBundle\Entity\ArticlePriceDiscount No errors.
WebBundle\Entity\ListRepeatDraw No errors.
WebBundle\Entity\ListMotiv No errors.
WebBundle\Entity\ListMeasureSize No errors.
WebBundle\Entity\SampleEntity No errors.
WebBundle\Entity\ListSink No errors.
WebBundle\Entity\ListMethLaying No errors.
WebBundle\Entity\ArticleDetail No errors.
WebBundle\Entity\ListDraw No errors.
FlexApp\Entity\Mailing No errors.
WebBundle\Entity\BuyOrderDelivery No errors.
WebBundle\Entity\BuyOrderArticleHoliday No errors.

oneC entity manager

No loaded entities.

logs entity manager

No loaded entities.