Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

22 Database Queries

18 Different statements

149.17 ms Query time

0 Invalid entities

Queries

Group similar statements

default connection


SELECT p0_.`id` AS id_0, p0_.`enable` AS enable_1, p0_.`unid` AS unid_2, p0_.`publish_date` AS publish_date_3, p0_.`update_date` AS update_date_4, p0_.`view` AS view_5, p0_.`hide_countries` AS hide_countries_6, l1_.`id` AS id_7, l1_.`source` AS source_8, l1_.`ru` AS ru_9, l1_.`en` AS en_10, l1_.`it` AS it_11, l1_.`es` AS es_12, l1_.`fr` AS fr_13, l1_.`de` AS de_14, l1_.`pl` AS pl_15, l1_.`pt` AS pt_16, l1_.`nl` AS nl_17, l1_.`fi` AS fi_18, l1_.`ua` AS ua_19, l1_.`sv` AS sv_20, l1_.`no` AS no_21, l1_.`da` AS da_22, l1_.`cn` AS cn_23, l1_.`zh` AS zh_24, l1_.`created_at` AS created_at_25, l1_.`updated_at` AS updated_at_26, l2_.`id` AS id_27, l2_.`source` AS source_28, l2_.`ru` AS ru_29, l2_.`en` AS en_30, l2_.`it` AS it_31, l2_.`es` AS es_32, l2_.`fr` AS fr_33, l2_.`de` AS de_34, l2_.`pl` AS pl_35, l2_.`pt` AS pt_36, l2_.`nl` AS nl_37, l2_.`fi` AS fi_38, l2_.`ua` AS ua_39, l2_.`sv` AS sv_40, l2_.`no` AS no_41, l2_.`da` AS da_42, l2_.`cn` AS cn_43, l2_.`zh` AS zh_44, l2_.`created_at` AS created_at_45, l2_.`updated_at` AS updated_at_46, l3_.`id` AS id_47, l3_.`source` AS source_48, l3_.`ru` AS ru_49, l3_.`en` AS en_50, l3_.`it` AS it_51, l3_.`es` AS es_52, l3_.`fr` AS fr_53, l3_.`de` AS de_54, l3_.`pl` AS pl_55, l3_.`pt` AS pt_56, l3_.`nl` AS nl_57, l3_.`fi` AS fi_58, l3_.`ua` AS ua_59, l3_.`sv` AS sv_60, l3_.`no` AS no_61, l3_.`da` AS da_62, l3_.`cn` AS cn_63, l3_.`zh` AS zh_64, l3_.`created_at` AS created_at_65, l3_.`updated_at` AS updated_at_66, l4_.`id` AS id_67, l4_.`source` AS source_68, l4_.`ru` AS ru_69, l4_.`en` AS en_70, l4_.`it` AS it_71, l4_.`es` AS es_72, l4_.`fr` AS fr_73, l4_.`de` AS de_74, l4_.`pl` AS pl_75, l4_.`pt` AS pt_76, l4_.`nl` AS nl_77, l4_.`fi` AS fi_78, l4_.`ua` AS ua_79, l4_.`sv` AS sv_80, l4_.`no` AS no_81, l4_.`da` AS da_82, l4_.`cn` AS cn_83, l4_.`zh` AS zh_84, l4_.`created_at` AS created_at_85, l4_.`updated_at` AS updated_at_86, l5_.`id` AS id_87, l5_.`source` AS source_88, l5_.`ru` AS ru_89, l5_.`en` AS en_90, l5_.`it` AS it_91, l5_.`es` AS es_92, l5_.`fr` AS fr_93, l5_.`de` AS de_94, l5_.`pl` AS pl_95, l5_.`pt` AS pt_96, l5_.`nl` AS nl_97, l5_.`fi` AS fi_98, l5_.`ua` AS ua_99, l5_.`sv` AS sv_100, l5_.`no` AS no_101, l5_.`da` AS da_102, l5_.`cn` AS cn_103, l5_.`zh` AS zh_104, l5_.`created_at` AS created_at_105, l5_.`updated_at` AS updated_at_106, l6_.`id` AS id_107, l6_.`source` AS source_108, l6_.`ru` AS ru_109, l6_.`en` AS en_110, l6_.`it` AS it_111, l6_.`es` AS es_112, l6_.`fr` AS fr_113, l6_.`de` AS de_114, l6_.`pl` AS pl_115, l6_.`pt` AS pt_116, l6_.`nl` AS nl_117, l6_.`fi` AS fi_118, l6_.`ua` AS ua_119, l6_.`sv` AS sv_120, l6_.`no` AS no_121, l6_.`da` AS da_122, l6_.`cn` AS cn_123, l6_.`zh` AS zh_124, l6_.`created_at` AS created_at_125, l6_.`updated_at` AS updated_at_126, l7_.`id` AS id_127, l7_.`def` AS def_128, l7_.`ru` AS ru_129, l7_.`en` AS en_130, l7_.`it` AS it_131, l7_.`es` AS es_132, l7_.`fr` AS fr_133, l7_.`de` AS de_134, l7_.`pl` AS pl_135, l7_.`pt` AS pt_136, l7_.`nl` AS nl_137, l7_.`fi` AS fi_138, l7_.`ua` AS ua_139, l7_.`sv` AS sv_140, l7_.`no` AS no_141, l7_.`da` AS da_142, l7_.`cn` AS cn_143, l7_.`zh` AS zh_144, l7_.`created_at` AS created_at_145, l7_.`updated_at` AS updated_at_146, p8_.`id` AS id_147, p8_.`token` AS token_148, u9_.`id` AS id_149, u9_.`unid` AS unid_150, u9_.`corporate_unid` AS corporate_unid_151, u9_.`token` AS token_152, u9_.`is_active` AS is_active_153, u9_.`proved` AS proved_154, u9_.`alias` AS alias_155, u9_.`foreign_alias` AS foreign_alias_156, u9_.`lotus_name` AS lotus_name_157, u9_.`password` AS password_158, u9_.`expired` AS expired_159, u9_.`expires_at` AS expires_at_160, u9_.`credentials_expired` AS credentials_expired_161, u9_.`credentials_expire_at` AS credentials_expire_at_162, u9_.`last_ip` AS last_ip_163, u9_.`source` AS source_164, u9_.`social_network` AS social_network_165, u9_.`social_network_id` AS social_network_id_166, u9_.`google_id` AS google_id_167, u9_.`fb_id` AS fb_id_168, u9_.`vk_id` AS vk_id_169, u9_.`ig_id` AS ig_id_170, u9_.`test` AS test_171, u9_.`token_fixed` AS token_fixed_172, u9_.`bid` AS bid_173, u9_.`email` AS email_174, u9_.`salt` AS salt_175, u9_.`review_request_sent` AS review_request_sent_176, u9_.`username` AS username_177, u9_.`roles` AS roles_178, u9_.`enabled` AS enabled_179, u9_.`confirmation_token` AS confirmation_token_180, u9_.`last_login` AS last_login_181, u9_.`password_requested_at` AS password_requested_at_182, u9_.`security_field` AS security_field_183, u9_.`created_at` AS created_at_184, u9_.`is_legal_entity` AS is_legal_entity_185, u9_.`companyName` AS companyName_186, u9_.`vatNumber` AS vatNumber_187, u9_.`lang` AS lang_188, l10_.`id` AS id_189, l10_.`source` AS source_190, l10_.`ru` AS ru_191, l10_.`en` AS en_192, l10_.`it` AS it_193, l10_.`es` AS es_194, l10_.`fr` AS fr_195, l10_.`de` AS de_196, l10_.`pl` AS pl_197, l10_.`pt` AS pt_198, l10_.`nl` AS nl_199, l10_.`fi` AS fi_200, l10_.`ua` AS ua_201, l10_.`sv` AS sv_202, l10_.`no` AS no_203, l10_.`da` AS da_204, l10_.`cn` AS cn_205, l10_.`zh` AS zh_206, l10_.`created_at` AS created_at_207, l10_.`updated_at` AS updated_at_208 FROM `publication` p0_ LEFT JOIN `locale_url` l1_ ON p0_.id = l1_.publication_id LEFT JOIN `locale_html` l2_ ON p0_.id = l2_.publication_body_id LEFT JOIN `locale_title` l3_ ON p0_.id = l3_.publication_id LEFT JOIN `locale_meta` l4_ ON p0_.id = l4_.blog_description_id LEFT JOIN `locale_meta` l5_ ON p0_.id = l5_.blog_keywords_id LEFT JOIN `locale_bool` l6_ ON p0_.id = l6_.blog_show_id LEFT JOIN `locale_preview` l7_ ON p0_.id = l7_.publication_id LEFT JOIN `publication_like` p8_ ON p0_.id = p8_.publication_id LEFT JOIN `user` u9_ ON p0_.author = u9_.id LEFT JOIN `locale_bool` l10_ ON p0_.id = l10_.blog_hide_single_id WHERE l1_.`ru` = ? OR l1_.`en` = ? OR l1_.`it` = ? OR l1_.`es` = ? OR l1_.`fr` = ? OR l1_.`de` = ? OR l1_.`pl` = ? OR l1_.`nl` = ? OR l1_.`fi` = ? OR l1_.`sv` = ?
UPDATE `publication` SET `view` = `view` + 1  WHERE `id` = 2232;
SELECT t0.`id` AS id_1, t0.`enable` AS enable_2, t0.`unid` AS unid_3, t0.`publish_date` AS publish_date_4, t0.`update_date` AS update_date_5, t0.`view` AS view_6, t0.`hide_countries` AS hide_countries_7, t0.author AS author_8, t9.`id` AS id_10, t9.`source` AS source_11, t9.`ru` AS ru_12, t9.`en` AS en_13, t9.`it` AS it_14, t9.`es` AS es_15, t9.`fr` AS fr_16, t9.`de` AS de_17, t9.`pl` AS pl_18, t9.`pt` AS pt_19, t9.`nl` AS nl_20, t9.`fi` AS fi_21, t9.`ua` AS ua_22, t9.`sv` AS sv_23, t9.`no` AS no_24, t9.`da` AS da_25, t9.`cn` AS cn_26, t9.`zh` AS zh_27, t9.`created_at` AS created_at_28, t9.`updated_at` AS updated_at_29, t9.email_title_id AS email_title_id_30, t9.publication_id AS publication_id_31, t9.static_page_title_id AS static_page_title_id_32, t9.exh_title_id AS exh_title_id_33, t9.filter_name_single_id AS filter_name_single_id_34, t9.filter_name_many_id AS filter_name_many_id_35, t9.filter_name_menu_id AS filter_name_menu_id_36, t37.`id` AS id_38, t37.`source` AS source_39, t37.`ru` AS ru_40, t37.`en` AS en_41, t37.`it` AS it_42, t37.`es` AS es_43, t37.`fr` AS fr_44, t37.`de` AS de_45, t37.`pl` AS pl_46, t37.`pt` AS pt_47, t37.`nl` AS nl_48, t37.`fi` AS fi_49, t37.`ua` AS ua_50, t37.`sv` AS sv_51, t37.`no` AS no_52, t37.`da` AS da_53, t37.`cn` AS cn_54, t37.`zh` AS zh_55, t37.`created_at` AS created_at_56, t37.`updated_at` AS updated_at_57, t37.email_body_id AS email_body_id_58, t37.publication_body_id AS publication_body_id_59, t37.static_page_body_id AS static_page_body_id_60, t37.collection_body_id AS collection_body_id_61, t37.trans_val_id AS trans_val_id_62, t37.exh_text_id AS exh_text_id_63, t37.exh_brand_text_id AS exh_brand_text_id_64, t37.exh_collection_text_id AS exh_collection_text_id_65, t37.filter_html_id AS filter_html_id_66, t67.`id` AS id_68, t67.`source` AS source_69, t67.`ru` AS ru_70, t67.`en` AS en_71, t67.`it` AS it_72, t67.`es` AS es_73, t67.`fr` AS fr_74, t67.`de` AS de_75, t67.`pl` AS pl_76, t67.`pt` AS pt_77, t67.`nl` AS nl_78, t67.`fi` AS fi_79, t67.`ua` AS ua_80, t67.`sv` AS sv_81, t67.`no` AS no_82, t67.`da` AS da_83, t67.`cn` AS cn_84, t67.`zh` AS zh_85, t67.`created_at` AS created_at_86, t67.`updated_at` AS updated_at_87, t67.publication_id AS publication_id_88, t67.filter_id AS filter_id_89, t67.exh_id AS exh_id_90, t91.`id` AS id_92, t91.`def` AS def_93, t91.`ru` AS ru_94, t91.`en` AS en_95, t91.`it` AS it_96, t91.`es` AS es_97, t91.`fr` AS fr_98, t91.`de` AS de_99, t91.`pl` AS pl_100, t91.`pt` AS pt_101, t91.`nl` AS nl_102, t91.`fi` AS fi_103, t91.`ua` AS ua_104, t91.`sv` AS sv_105, t91.`no` AS no_106, t91.`da` AS da_107, t91.`cn` AS cn_108, t91.`zh` AS zh_109, t91.`created_at` AS created_at_110, t91.`updated_at` AS updated_at_111, t91.publication_id AS publication_id_112, t91.exh_id AS exh_id_113, t114.`id` AS id_115, t114.`source` AS source_116, t114.`ru` AS ru_117, t114.`en` AS en_118, t114.`it` AS it_119, t114.`es` AS es_120, t114.`fr` AS fr_121, t114.`de` AS de_122, t114.`pl` AS pl_123, t114.`pt` AS pt_124, t114.`nl` AS nl_125, t114.`fi` AS fi_126, t114.`ua` AS ua_127, t114.`sv` AS sv_128, t114.`no` AS no_129, t114.`da` AS da_130, t114.`cn` AS cn_131, t114.`zh` AS zh_132, t114.`created_at` AS created_at_133, t114.`updated_at` AS updated_at_134, t114.static_page_title_id AS static_page_title_id_135, t114.static_page_keywords_id AS static_page_keywords_id_136, t114.static_page_description_id AS static_page_description_id_137, t114.collection_keywords_id AS collection_keywords_id_138, t114.collection_description_id AS collection_description_id_139, t114.blog_keywords_id AS blog_keywords_id_140, t114.blog_description_id AS blog_description_id_141, t114.exh_keywords_id AS exh_keywords_id_142, t114.exh_description_id AS exh_description_id_143, t144.`id` AS id_145, t144.`source` AS source_146, t144.`ru` AS ru_147, t144.`en` AS en_148, t144.`it` AS it_149, t144.`es` AS es_150, t144.`fr` AS fr_151, t144.`de` AS de_152, t144.`pl` AS pl_153, t144.`pt` AS pt_154, t144.`nl` AS nl_155, t144.`fi` AS fi_156, t144.`ua` AS ua_157, t144.`sv` AS sv_158, t144.`no` AS no_159, t144.`da` AS da_160, t144.`cn` AS cn_161, t144.`zh` AS zh_162, t144.`created_at` AS created_at_163, t144.`updated_at` AS updated_at_164, t144.static_page_title_id AS static_page_title_id_165, t144.static_page_keywords_id AS static_page_keywords_id_166, t144.static_page_description_id AS static_page_description_id_167, t144.collection_keywords_id AS collection_keywords_id_168, t144.collection_description_id AS collection_description_id_169, t144.blog_keywords_id AS blog_keywords_id_170, t144.blog_description_id AS blog_description_id_171, t144.exh_keywords_id AS exh_keywords_id_172, t144.exh_description_id AS exh_description_id_173, t174.`id` AS id_175, t174.`source` AS source_176, t174.`ru` AS ru_177, t174.`en` AS en_178, t174.`it` AS it_179, t174.`es` AS es_180, t174.`fr` AS fr_181, t174.`de` AS de_182, t174.`pl` AS pl_183, t174.`pt` AS pt_184, t174.`nl` AS nl_185, t174.`fi` AS fi_186, t174.`ua` AS ua_187, t174.`sv` AS sv_188, t174.`no` AS no_189, t174.`da` AS da_190, t174.`cn` AS cn_191, t174.`zh` AS zh_192, t174.`created_at` AS created_at_193, t174.`updated_at` AS updated_at_194, t174.blog_show_id AS blog_show_id_195, t174.blog_hide_single_id AS blog_hide_single_id_196, t174.static_page_status_show_id AS static_page_status_show_id_197, t174.static_page_comment_show_id AS static_page_comment_show_id_198, t174.filter_html_show_id AS filter_html_show_id_199, t174.exh_show_id AS exh_show_id_200, t174.exh_hide_single_id AS exh_hide_single_id_201, t202.`id` AS id_203, t202.`ru` AS ru_204, t202.`en` AS en_205, t202.`it` AS it_206, t202.`es` AS es_207, t202.`fr` AS fr_208, t202.`de` AS de_209, t202.`pl` AS pl_210, t202.`pt` AS pt_211, t202.`nl` AS nl_212, t202.`fi` AS fi_213, t202.`ua` AS ua_214, t202.`sv` AS sv_215, t202.`no` AS no_216, t202.`da` AS da_217, t202.`cn` AS cn_218, t202.`zh` AS zh_219, t202.`created_at` AS created_at_220, t202.`updated_at` AS updated_at_221, t202.publication_id AS publication_id_222, t202.exh_id AS exh_id_223, t224.`id` AS id_225, t224.`source` AS source_226, t224.`ru` AS ru_227, t224.`en` AS en_228, t224.`it` AS it_229, t224.`es` AS es_230, t224.`fr` AS fr_231, t224.`de` AS de_232, t224.`pl` AS pl_233, t224.`pt` AS pt_234, t224.`nl` AS nl_235, t224.`fi` AS fi_236, t224.`ua` AS ua_237, t224.`sv` AS sv_238, t224.`no` AS no_239, t224.`da` AS da_240, t224.`cn` AS cn_241, t224.`zh` AS zh_242, t224.`created_at` AS created_at_243, t224.`updated_at` AS updated_at_244, t224.blog_show_id AS blog_show_id_245, t224.blog_hide_single_id AS blog_hide_single_id_246, t224.static_page_status_show_id AS static_page_status_show_id_247, t224.static_page_comment_show_id AS static_page_comment_show_id_248, t224.filter_html_show_id AS filter_html_show_id_249, t224.exh_show_id AS exh_show_id_250, t224.exh_hide_single_id AS exh_hide_single_id_251 FROM `publication` t0 LEFT JOIN `locale_title` t9 ON t9.publication_id = t0.id LEFT JOIN `locale_html` t37 ON t37.publication_body_id = t0.id LEFT JOIN `locale_url` t67 ON t67.publication_id = t0.id LEFT JOIN `locale_preview` t91 ON t91.publication_id = t0.id LEFT JOIN `locale_meta` t114 ON t114.blog_keywords_id = t0.id LEFT JOIN `locale_meta` t144 ON t144.blog_description_id = t0.id LEFT JOIN `locale_bool` t174 ON t174.blog_show_id = t0.id LEFT JOIN `locale_status_translate` t202 ON t202.publication_id = t0.id LEFT JOIN `locale_bool` t224 ON t224.blog_hide_single_id = t0.id WHERE t0.`id` = ?
SELECT c0_.`id` AS id_0, c0_.`special_date_start` AS special_date_start_1, c0_.`special_date_end` AS special_date_end_2, c0_.`is_working` AS is_working_3, c0_.`mode` AS mode_4, c0_.`mode_holiday` AS mode_holiday_5, c0_.`lang` AS lang_6, c0_.`timeZoneName` AS timeZoneName_7, c0_.country_id AS country_id_8, c0_.blog_id AS blog_id_9 FROM `calendar` c0_ WHERE c0_.blog_id = ? AND c0_.`is_working` = ? AND c0_.country_id = ? ORDER BY c0_.`special_date_start` ASC LIMIT 100
SELECT c0_.`id` AS id_0, c0_.`special_date_start` AS special_date_start_1, c0_.`special_date_end` AS special_date_end_2, c0_.`is_working` AS is_working_3, c0_.`mode` AS mode_4, c0_.`mode_holiday` AS mode_holiday_5, c0_.`lang` AS lang_6, c0_.`timeZoneName` AS timeZoneName_7, c0_.country_id AS country_id_8, c0_.blog_id AS blog_id_9 FROM `calendar` c0_ WHERE c0_.blog_id = ? AND c0_.`is_working` = ? AND (c0_.country_id IS NULL OR c0_.country_id = 0 OR c0_.country_id = 'en') ORDER BY c0_.`special_date_start` ASC LIMIT 100
SELECT c0_.`id` AS id_0, c0_.`special_date_start` AS special_date_start_1, c0_.`special_date_end` AS special_date_end_2, c0_.`is_working` AS is_working_3, c0_.`mode` AS mode_4, c0_.`mode_holiday` AS mode_holiday_5, c0_.`lang` AS lang_6, c0_.`timeZoneName` AS timeZoneName_7, c0_.country_id AS country_id_8, c0_.blog_id AS blog_id_9 FROM `calendar` c0_ WHERE c0_.blog_id = ? AND c0_.`is_working` = ? AND c0_.country_id = ? ORDER BY c0_.`special_date_start` ASC LIMIT 100
SELECT c0_.`id` AS id_0, c0_.`special_date_start` AS special_date_start_1, c0_.`special_date_end` AS special_date_end_2, c0_.`is_working` AS is_working_3, c0_.`mode` AS mode_4, c0_.`mode_holiday` AS mode_holiday_5, c0_.`lang` AS lang_6, c0_.`timeZoneName` AS timeZoneName_7, c0_.country_id AS country_id_8, c0_.blog_id AS blog_id_9 FROM `calendar` c0_ WHERE c0_.blog_id = ? AND c0_.`is_working` = ? AND (c0_.country_id IS NULL OR c0_.country_id = 0 OR c0_.country_id = 'en') ORDER BY c0_.`special_date_start` ASC LIMIT 100
SELECT s0_.`code` AS code_0, s0_.`value` AS value_1, s0_.`link` AS link_2, s0_.`login` AS login_3, s0_.`token` AS token_4 FROM `social_stat` s0_ WHERE s0_.`locale` IS NULL OR s0_.`locale` = ?
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
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
SELECT b0_.`id` AS id_0 FROM `buy_order` b0_ WHERE b0_.`token` = ? AND b0_.`status` <> 12
SELECT COUNT(v0_.`id`) AS sclr_0 FROM `visit` v0_ WHERE v0_.`token` = ? AND v0_.`url` <> '/.*catalog.*/'
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` = ?
SELECT b0_.`id` AS id_0, b0_.`name` AS name_1, b0_.`descr` AS descr_2, b0_.`val` AS val_3 FROM `BoolDBSetting` b0_ WHERE b0_.`name` = ?
SELECT 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
SELECT b0_.`id` AS id_0, b0_.`name` AS name_1, b0_.`descr` AS descr_2, b0_.`val` AS val_3 FROM `BoolDBSetting` b0_ WHERE b0_.`name` = ?
SELECT 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 c0_.`id` AS id_0, c0_.`url` AS url_1, c0_.`code` AS code_2, c0_.`name` AS name_3, c0_.`alternate_name` AS alternate_name_4, c0_.`name_full` AS name_full_5, f1_.`id` AS id_6, f1_.`url` AS url_7, f1_.`unid` AS unid_8, f2_.`id` AS id_9, f1_.`url` AS url_10, f1_.`name` AS name_11, (SELECT COUNT(p3_.`star`) AS sclr_13 FROM `product_reviews_cache` p3_ WHERE p3_.`sku` = c0_.`code`) AS sclr_12, (SELECT SUM(p4_.`star`) AS sclr_15 FROM `product_reviews_cache` p4_ WHERE p4_.`sku` = c0_.`code`) AS sclr_14 FROM `collection` c0_ INNER JOIN `factory` f1_ ON c0_.factory = f1_.id INNER JOIN `filters` f2_ ON f1_.filter = f2_.id INNER JOIN `list_country` l5_ ON f1_.country = l5_.id LEFT JOIN `locale_url` l6_ ON f2_.id = l6_.filter_id LEFT JOIN `filter_pages` f7_ ON f2_.page_id = f7_.id WHERE f1_.filter IS NOT NULL AND c0_.factory <> '' AND f1_.`status` = ? AND (c0_.`test_access` IS NULL OR c0_.`test_access` = 0) AND (f1_.`test_access` IS NULL OR f1_.`test_access` = 0) AND c0_.`status` = ? AND c0_.`status` = ? AND f1_.`status` = ? ORDER BY c0_.`id` ASC
SELECT 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
SELECT
       			lu.en 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.en = 1 AND lst.en = 1;
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_.`en` AS en_6, f3_.`name_menu_en` AS name_menu_en_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_.`en` IS NOT NULL AND f5_.`count` > 0 AND f4_.`alt_name` IN (?) ORDER BY f0_.`sort` ASC, f0_.`name` ASC
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` = ?

#▲	Time	Info
1	16.59 ms	SELECT p0_.`id` AS id_0, p0_.`enable` AS enable_1, p0_.`unid` AS unid_2, p0_.`publish_date` AS publish_date_3, p0_.`update_date` AS update_date_4, p0_.`view` AS view_5, p0_.`hide_countries` AS hide_countries_6, l1_.`id` AS id_7, l1_.`source` AS source_8, l1_.`ru` AS ru_9, l1_.`en` AS en_10, l1_.`it` AS it_11, l1_.`es` AS es_12, l1_.`fr` AS fr_13, l1_.`de` AS de_14, l1_.`pl` AS pl_15, l1_.`pt` AS pt_16, l1_.`nl` AS nl_17, l1_.`fi` AS fi_18, l1_.`ua` AS ua_19, l1_.`sv` AS sv_20, l1_.`no` AS no_21, l1_.`da` AS da_22, l1_.`cn` AS cn_23, l1_.`zh` AS zh_24, l1_.`created_at` AS created_at_25, l1_.`updated_at` AS updated_at_26, l2_.`id` AS id_27, l2_.`source` AS source_28, l2_.`ru` AS ru_29, l2_.`en` AS en_30, l2_.`it` AS it_31, l2_.`es` AS es_32, l2_.`fr` AS fr_33, l2_.`de` AS de_34, l2_.`pl` AS pl_35, l2_.`pt` AS pt_36, l2_.`nl` AS nl_37, l2_.`fi` AS fi_38, l2_.`ua` AS ua_39, l2_.`sv` AS sv_40, l2_.`no` AS no_41, l2_.`da` AS da_42, l2_.`cn` AS cn_43, l2_.`zh` AS zh_44, l2_.`created_at` AS created_at_45, l2_.`updated_at` AS updated_at_46, l3_.`id` AS id_47, l3_.`source` AS source_48, l3_.`ru` AS ru_49, l3_.`en` AS en_50, l3_.`it` AS it_51, l3_.`es` AS es_52, l3_.`fr` AS fr_53, l3_.`de` AS de_54, l3_.`pl` AS pl_55, l3_.`pt` AS pt_56, l3_.`nl` AS nl_57, l3_.`fi` AS fi_58, l3_.`ua` AS ua_59, l3_.`sv` AS sv_60, l3_.`no` AS no_61, l3_.`da` AS da_62, l3_.`cn` AS cn_63, l3_.`zh` AS zh_64, l3_.`created_at` AS created_at_65, l3_.`updated_at` AS updated_at_66, l4_.`id` AS id_67, l4_.`source` AS source_68, l4_.`ru` AS ru_69, l4_.`en` AS en_70, l4_.`it` AS it_71, l4_.`es` AS es_72, l4_.`fr` AS fr_73, l4_.`de` AS de_74, l4_.`pl` AS pl_75, l4_.`pt` AS pt_76, l4_.`nl` AS nl_77, l4_.`fi` AS fi_78, l4_.`ua` AS ua_79, l4_.`sv` AS sv_80, l4_.`no` AS no_81, l4_.`da` AS da_82, l4_.`cn` AS cn_83, l4_.`zh` AS zh_84, l4_.`created_at` AS created_at_85, l4_.`updated_at` AS updated_at_86, l5_.`id` AS id_87, l5_.`source` AS source_88, l5_.`ru` AS ru_89, l5_.`en` AS en_90, l5_.`it` AS it_91, l5_.`es` AS es_92, l5_.`fr` AS fr_93, l5_.`de` AS de_94, l5_.`pl` AS pl_95, l5_.`pt` AS pt_96, l5_.`nl` AS nl_97, l5_.`fi` AS fi_98, l5_.`ua` AS ua_99, l5_.`sv` AS sv_100, l5_.`no` AS no_101, l5_.`da` AS da_102, l5_.`cn` AS cn_103, l5_.`zh` AS zh_104, l5_.`created_at` AS created_at_105, l5_.`updated_at` AS updated_at_106, l6_.`id` AS id_107, l6_.`source` AS source_108, l6_.`ru` AS ru_109, l6_.`en` AS en_110, l6_.`it` AS it_111, l6_.`es` AS es_112, l6_.`fr` AS fr_113, l6_.`de` AS de_114, l6_.`pl` AS pl_115, l6_.`pt` AS pt_116, l6_.`nl` AS nl_117, l6_.`fi` AS fi_118, l6_.`ua` AS ua_119, l6_.`sv` AS sv_120, l6_.`no` AS no_121, l6_.`da` AS da_122, l6_.`cn` AS cn_123, l6_.`zh` AS zh_124, l6_.`created_at` AS created_at_125, l6_.`updated_at` AS updated_at_126, l7_.`id` AS id_127, l7_.`def` AS def_128, l7_.`ru` AS ru_129, l7_.`en` AS en_130, l7_.`it` AS it_131, l7_.`es` AS es_132, l7_.`fr` AS fr_133, l7_.`de` AS de_134, l7_.`pl` AS pl_135, l7_.`pt` AS pt_136, l7_.`nl` AS nl_137, l7_.`fi` AS fi_138, l7_.`ua` AS ua_139, l7_.`sv` AS sv_140, l7_.`no` AS no_141, l7_.`da` AS da_142, l7_.`cn` AS cn_143, l7_.`zh` AS zh_144, l7_.`created_at` AS created_at_145, l7_.`updated_at` AS updated_at_146, p8_.`id` AS id_147, p8_.`token` AS token_148, u9_.`id` AS id_149, u9_.`unid` AS unid_150, u9_.`corporate_unid` AS corporate_unid_151, u9_.`token` AS token_152, u9_.`is_active` AS is_active_153, u9_.`proved` AS proved_154, u9_.`alias` AS alias_155, u9_.`foreign_alias` AS foreign_alias_156, u9_.`lotus_name` AS lotus_name_157, u9_.`password` AS password_158, u9_.`expired` AS expired_159, u9_.`expires_at` AS expires_at_160, u9_.`credentials_expired` AS credentials_expired_161, u9_.`credentials_expire_at` AS credentials_expire_at_162, u9_.`last_ip` AS last_ip_163, u9_.`source` AS source_164, u9_.`social_network` AS social_network_165, u9_.`social_network_id` AS social_network_id_166, u9_.`google_id` AS google_id_167, u9_.`fb_id` AS fb_id_168, u9_.`vk_id` AS vk_id_169, u9_.`ig_id` AS ig_id_170, u9_.`test` AS test_171, u9_.`token_fixed` AS token_fixed_172, u9_.`bid` AS bid_173, u9_.`email` AS email_174, u9_.`salt` AS salt_175, u9_.`review_request_sent` AS review_request_sent_176, u9_.`username` AS username_177, u9_.`roles` AS roles_178, u9_.`enabled` AS enabled_179, u9_.`confirmation_token` AS confirmation_token_180, u9_.`last_login` AS last_login_181, u9_.`password_requested_at` AS password_requested_at_182, u9_.`security_field` AS security_field_183, u9_.`created_at` AS created_at_184, u9_.`is_legal_entity` AS is_legal_entity_185, u9_.`companyName` AS companyName_186, u9_.`vatNumber` AS vatNumber_187, u9_.`lang` AS lang_188, l10_.`id` AS id_189, l10_.`source` AS source_190, l10_.`ru` AS ru_191, l10_.`en` AS en_192, l10_.`it` AS it_193, l10_.`es` AS es_194, l10_.`fr` AS fr_195, l10_.`de` AS de_196, l10_.`pl` AS pl_197, l10_.`pt` AS pt_198, l10_.`nl` AS nl_199, l10_.`fi` AS fi_200, l10_.`ua` AS ua_201, l10_.`sv` AS sv_202, l10_.`no` AS no_203, l10_.`da` AS da_204, l10_.`cn` AS cn_205, l10_.`zh` AS zh_206, l10_.`created_at` AS created_at_207, l10_.`updated_at` AS updated_at_208 FROM `publication` p0_ LEFT JOIN `locale_url` l1_ ON p0_.id = l1_.publication_id LEFT JOIN `locale_html` l2_ ON p0_.id = l2_.publication_body_id LEFT JOIN `locale_title` l3_ ON p0_.id = l3_.publication_id LEFT JOIN `locale_meta` l4_ ON p0_.id = l4_.blog_description_id LEFT JOIN `locale_meta` l5_ ON p0_.id = l5_.blog_keywords_id LEFT JOIN `locale_bool` l6_ ON p0_.id = l6_.blog_show_id LEFT JOIN `locale_preview` l7_ ON p0_.id = l7_.publication_id LEFT JOIN `publication_like` p8_ ON p0_.id = p8_.publication_id LEFT JOIN `user` u9_ ON p0_.author = u9_.id LEFT JOIN `locale_bool` l10_ ON p0_.id = l10_.blog_hide_single_id WHERE l1_.`ru` = ? OR l1_.`en` = ? OR l1_.`it` = ? OR l1_.`es` = ? OR l1_.`fr` = ? OR l1_.`de` = ? OR l1_.`pl` = ? OR l1_.`nl` = ? OR l1_.`fi` = ? OR l1_.`sv` = ? Parameters: [`"fast-delivery-tile-samples" "fast-delivery-tile-samples" "fast-delivery-tile-samples" "fast-delivery-tile-samples" "fast-delivery-tile-samples" "fast-delivery-tile-samples" "fast-delivery-tile-samples" "fast-delivery-tile-samples" "fast-delivery-tile-samples" "fast-delivery-tile-samples"`] View formatted query View runnable query Explain query SELECT p0_.`id` AS id_0, p0_.`enable` AS enable_1, p0_.`unid` AS unid_2, p0_.`publish_date` AS publish_date_3, p0_.`update_date` AS update_date_4, p0_.`view` AS view_5, p0_.`hide_countries` AS hide_countries_6, l1_.`id` AS id_7, l1_.`source` AS source_8, l1_.`ru` AS ru_9, l1_.`en` AS en_10, l1_.`it` AS it_11, l1_.`es` AS es_12, l1_.`fr` AS fr_13, l1_.`de` AS de_14, l1_.`pl` AS pl_15, l1_.`pt` AS pt_16, l1_.`nl` AS nl_17, l1_.`fi` AS fi_18, l1_.`ua` AS ua_19, l1_.`sv` AS sv_20, l1_.`no` AS no_21, l1_.`da` AS da_22, l1_.`cn` AS cn_23, l1_.`zh` AS zh_24, l1_.`created_at` AS created_at_25, l1_.`updated_at` AS updated_at_26, l2_.`id` AS id_27, l2_.`source` AS source_28, l2_.`ru` AS ru_29, l2_.`en` AS en_30, l2_.`it` AS it_31, l2_.`es` AS es_32, l2_.`fr` AS fr_33, l2_.`de` AS de_34, l2_.`pl` AS pl_35, l2_.`pt` AS pt_36, l2_.`nl` AS nl_37, l2_.`fi` AS fi_38, l2_.`ua` AS ua_39, l2_.`sv` AS sv_40, l2_.`no` AS no_41, l2_.`da` AS da_42, l2_.`cn` AS cn_43, l2_.`zh` AS zh_44, l2_.`created_at` AS created_at_45, l2_.`updated_at` AS updated_at_46, l3_.`id` AS id_47, l3_.`source` AS source_48, l3_.`ru` AS ru_49, l3_.`en` AS en_50, l3_.`it` AS it_51, l3_.`es` AS es_52, l3_.`fr` AS fr_53, l3_.`de` AS de_54, l3_.`pl` AS pl_55, l3_.`pt` AS pt_56, l3_.`nl` AS nl_57, l3_.`fi` AS fi_58, l3_.`ua` AS ua_59, l3_.`sv` AS sv_60, l3_.`no` AS no_61, l3_.`da` AS da_62, l3_.`cn` AS cn_63, l3_.`zh` AS zh_64, l3_.`created_at` AS created_at_65, l3_.`updated_at` AS updated_at_66, l4_.`id` AS id_67, l4_.`source` AS source_68, l4_.`ru` AS ru_69, l4_.`en` AS en_70, l4_.`it` AS it_71, l4_.`es` AS es_72, l4_.`fr` AS fr_73, l4_.`de` AS de_74, l4_.`pl` AS pl_75, l4_.`pt` AS pt_76, l4_.`nl` AS nl_77, l4_.`fi` AS fi_78, l4_.`ua` AS ua_79, l4_.`sv` AS sv_80, l4_.`no` AS no_81, l4_.`da` AS da_82, l4_.`cn` AS cn_83, l4_.`zh` AS zh_84, l4_.`created_at` AS created_at_85, l4_.`updated_at` AS updated_at_86, l5_.`id` AS id_87, l5_.`source` AS source_88, l5_.`ru` AS ru_89, l5_.`en` AS en_90, l5_.`it` AS it_91, l5_.`es` AS es_92, l5_.`fr` AS fr_93, l5_.`de` AS de_94, l5_.`pl` AS pl_95, l5_.`pt` AS pt_96, l5_.`nl` AS nl_97, l5_.`fi` AS fi_98, l5_.`ua` AS ua_99, l5_.`sv` AS sv_100, l5_.`no` AS no_101, l5_.`da` AS da_102, l5_.`cn` AS cn_103, l5_.`zh` AS zh_104, l5_.`created_at` AS created_at_105, l5_.`updated_at` AS updated_at_106, l6_.`id` AS id_107, l6_.`source` AS source_108, l6_.`ru` AS ru_109, l6_.`en` AS en_110, l6_.`it` AS it_111, l6_.`es` AS es_112, l6_.`fr` AS fr_113, l6_.`de` AS de_114, l6_.`pl` AS pl_115, l6_.`pt` AS pt_116, l6_.`nl` AS nl_117, l6_.`fi` AS fi_118, l6_.`ua` AS ua_119, l6_.`sv` AS sv_120, l6_.`no` AS no_121, l6_.`da` AS da_122, l6_.`cn` AS cn_123, l6_.`zh` AS zh_124, l6_.`created_at` AS created_at_125, l6_.`updated_at` AS updated_at_126, l7_.`id` AS id_127, l7_.`def` AS def_128, l7_.`ru` AS ru_129, l7_.`en` AS en_130, l7_.`it` AS it_131, l7_.`es` AS es_132, l7_.`fr` AS fr_133, l7_.`de` AS de_134, l7_.`pl` AS pl_135, l7_.`pt` AS pt_136, l7_.`nl` AS nl_137, l7_.`fi` AS fi_138, l7_.`ua` AS ua_139, l7_.`sv` AS sv_140, l7_.`no` AS no_141, l7_.`da` AS da_142, l7_.`cn` AS cn_143, l7_.`zh` AS zh_144, l7_.`created_at` AS created_at_145, l7_.`updated_at` AS updated_at_146, p8_.`id` AS id_147, p8_.`token` AS token_148, u9_.`id` AS id_149, u9_.`unid` AS unid_150, u9_.`corporate_unid` AS corporate_unid_151, u9_.`token` AS token_152, u9_.`is_active` AS is_active_153, u9_.`proved` AS proved_154, u9_.`alias` AS alias_155, u9_.`foreign_alias` AS foreign_alias_156, u9_.`lotus_name` AS lotus_name_157, u9_.`password` AS password_158, u9_.`expired` AS expired_159, u9_.`expires_at` AS expires_at_160, u9_.`credentials_expired` AS credentials_expired_161, u9_.`credentials_expire_at` AS credentials_expire_at_162, u9_.`last_ip` AS last_ip_163, u9_.`source` AS source_164, u9_.`social_network` AS social_network_165, u9_.`social_network_id` AS social_network_id_166, u9_.`google_id` AS google_id_167, u9_.`fb_id` AS fb_id_168, u9_.`vk_id` AS vk_id_169, u9_.`ig_id` AS ig_id_170, u9_.`test` AS test_171, u9_.`token_fixed` AS token_fixed_172, u9_.`bid` AS bid_173, u9_.`email` AS email_174, u9_.`salt` AS salt_175, u9_.`review_request_sent` AS review_request_sent_176, u9_.`username` AS username_177, u9_.`roles` AS roles_178, u9_.`enabled` AS enabled_179, u9_.`confirmation_token` AS confirmation_token_180, u9_.`last_login` AS last_login_181, u9_.`password_requested_at` AS password_requested_at_182, u9_.`security_field` AS security_field_183, u9_.`created_at` AS created_at_184, u9_.`is_legal_entity` AS is_legal_entity_185, u9_.`companyName` AS companyName_186, u9_.`vatNumber` AS vatNumber_187, u9_.`lang` AS lang_188, l10_.`id` AS id_189, l10_.`source` AS source_190, l10_.`ru` AS ru_191, l10_.`en` AS en_192, l10_.`it` AS it_193, l10_.`es` AS es_194, l10_.`fr` AS fr_195, l10_.`de` AS de_196, l10_.`pl` AS pl_197, l10_.`pt` AS pt_198, l10_.`nl` AS nl_199, l10_.`fi` AS fi_200, l10_.`ua` AS ua_201, l10_.`sv` AS sv_202, l10_.`no` AS no_203, l10_.`da` AS da_204, l10_.`cn` AS cn_205, l10_.`zh` AS zh_206, l10_.`created_at` AS created_at_207, l10_.`updated_at` AS updated_at_208 FROM `publication` p0_ LEFT JOIN `locale_url` l1_ ON p0_.id = l1_.publication_id LEFT JOIN `locale_html` l2_ ON p0_.id = l2_.publication_body_id LEFT JOIN `locale_title` l3_ ON p0_.id = l3_.publication_id LEFT JOIN `locale_meta` l4_ ON p0_.id = l4_.blog_description_id LEFT JOIN `locale_meta` l5_ ON p0_.id = l5_.blog_keywords_id LEFT JOIN `locale_bool` l6_ ON p0_.id = l6_.blog_show_id LEFT JOIN `locale_preview` l7_ ON p0_.id = l7_.publication_id LEFT JOIN `publication_like` p8_ ON p0_.id = p8_.publication_id LEFT JOIN `user` u9_ ON p0_.author = u9_.id LEFT JOIN `locale_bool` l10_ ON p0_.id = l10_.blog_hide_single_id WHERE l1_.`ru` = ? OR l1_.`en` = ? OR l1_.`it` = ? OR l1_.`es` = ? OR l1_.`fr` = ? OR l1_.`de` = ? OR l1_.`pl` = ? OR l1_.`nl` = ? OR l1_.`fi` = ? OR l1_.`sv` = ? SELECT p0_.`id` AS id_0, p0_.`enable` AS enable_1, p0_.`unid` AS unid_2, p0_.`publish_date` AS publish_date_3, p0_.`update_date` AS update_date_4, p0_.`view` AS view_5, p0_.`hide_countries` AS hide_countries_6, l1_.`id` AS id_7, l1_.`source` AS source_8, l1_.`ru` AS ru_9, l1_.`en` AS en_10, l1_.`it` AS it_11, l1_.`es` AS es_12, l1_.`fr` AS fr_13, l1_.`de` AS de_14, l1_.`pl` AS pl_15, l1_.`pt` AS pt_16, l1_.`nl` AS nl_17, l1_.`fi` AS fi_18, l1_.`ua` AS ua_19, l1_.`sv` AS sv_20, l1_.`no` AS no_21, l1_.`da` AS da_22, l1_.`cn` AS cn_23, l1_.`zh` AS zh_24, l1_.`created_at` AS created_at_25, l1_.`updated_at` AS updated_at_26, l2_.`id` AS id_27, l2_.`source` AS source_28, l2_.`ru` AS ru_29, l2_.`en` AS en_30, l2_.`it` AS it_31, l2_.`es` AS es_32, l2_.`fr` AS fr_33, l2_.`de` AS de_34, l2_.`pl` AS pl_35, l2_.`pt` AS pt_36, l2_.`nl` AS nl_37, l2_.`fi` AS fi_38, l2_.`ua` AS ua_39, l2_.`sv` AS sv_40, l2_.`no` AS no_41, l2_.`da` AS da_42, l2_.`cn` AS cn_43, l2_.`zh` AS zh_44, l2_.`created_at` AS created_at_45, l2_.`updated_at` AS updated_at_46, l3_.`id` AS id_47, l3_.`source` AS source_48, l3_.`ru` AS ru_49, l3_.`en` AS en_50, l3_.`it` AS it_51, l3_.`es` AS es_52, l3_.`fr` AS fr_53, l3_.`de` AS de_54, l3_.`pl` AS pl_55, l3_.`pt` AS pt_56, l3_.`nl` AS nl_57, l3_.`fi` AS fi_58, l3_.`ua` AS ua_59, l3_.`sv` AS sv_60, l3_.`no` AS no_61, l3_.`da` AS da_62, l3_.`cn` AS cn_63, l3_.`zh` AS zh_64, l3_.`created_at` AS created_at_65, l3_.`updated_at` AS updated_at_66, l4_.`id` AS id_67, l4_.`source` AS source_68, l4_.`ru` AS ru_69, l4_.`en` AS en_70, l4_.`it` AS it_71, l4_.`es` AS es_72, l4_.`fr` AS fr_73, l4_.`de` AS de_74, l4_.`pl` AS pl_75, l4_.`pt` AS pt_76, l4_.`nl` AS nl_77, l4_.`fi` AS fi_78, l4_.`ua` AS ua_79, l4_.`sv` AS sv_80, l4_.`no` AS no_81, l4_.`da` AS da_82, l4_.`cn` AS cn_83, l4_.`zh` AS zh_84, l4_.`created_at` AS created_at_85, l4_.`updated_at` AS updated_at_86, l5_.`id` AS id_87, l5_.`source` AS source_88, l5_.`ru` AS ru_89, l5_.`en` AS en_90, l5_.`it` AS it_91, l5_.`es` AS es_92, l5_.`fr` AS fr_93, l5_.`de` AS de_94, l5_.`pl` AS pl_95, l5_.`pt` AS pt_96, l5_.`nl` AS nl_97, l5_.`fi` AS fi_98, l5_.`ua` AS ua_99, l5_.`sv` AS sv_100, l5_.`no` AS no_101, l5_.`da` AS da_102, l5_.`cn` AS cn_103, l5_.`zh` AS zh_104, l5_.`created_at` AS created_at_105, l5_.`updated_at` AS updated_at_106, l6_.`id` AS id_107, l6_.`source` AS source_108, l6_.`ru` AS ru_109, l6_.`en` AS en_110, l6_.`it` AS it_111, l6_.`es` AS es_112, l6_.`fr` AS fr_113, l6_.`de` AS de_114, l6_.`pl` AS pl_115, l6_.`pt` AS pt_116, l6_.`nl` AS nl_117, l6_.`fi` AS fi_118, l6_.`ua` AS ua_119, l6_.`sv` AS sv_120, l6_.`no` AS no_121, l6_.`da` AS da_122, l6_.`cn` AS cn_123, l6_.`zh` AS zh_124, l6_.`created_at` AS created_at_125, l6_.`updated_at` AS updated_at_126, l7_.`id` AS id_127, l7_.`def` AS def_128, l7_.`ru` AS ru_129, l7_.`en` AS en_130, l7_.`it` AS it_131, l7_.`es` AS es_132, l7_.`fr` AS fr_133, l7_.`de` AS de_134, l7_.`pl` AS pl_135, l7_.`pt` AS pt_136, l7_.`nl` AS nl_137, l7_.`fi` AS fi_138, l7_.`ua` AS ua_139, l7_.`sv` AS sv_140, l7_.`no` AS no_141, l7_.`da` AS da_142, l7_.`cn` AS cn_143, l7_.`zh` AS zh_144, l7_.`created_at` AS created_at_145, l7_.`updated_at` AS updated_at_146, p8_.`id` AS id_147, p8_.`token` AS token_148, u9_.`id` AS id_149, u9_.`unid` AS unid_150, u9_.`corporate_unid` AS corporate_unid_151, u9_.`token` AS token_152, u9_.`is_active` AS is_active_153, u9_.`proved` AS proved_154, u9_.`alias` AS alias_155, u9_.`foreign_alias` AS foreign_alias_156, u9_.`lotus_name` AS lotus_name_157, u9_.`password` AS password_158, u9_.`expired` AS expired_159, u9_.`expires_at` AS expires_at_160, u9_.`credentials_expired` AS credentials_expired_161, u9_.`credentials_expire_at` AS credentials_expire_at_162, u9_.`last_ip` AS last_ip_163, u9_.`source` AS source_164, u9_.`social_network` AS social_network_165, u9_.`social_network_id` AS social_network_id_166, u9_.`google_id` AS google_id_167, u9_.`fb_id` AS fb_id_168, u9_.`vk_id` AS vk_id_169, u9_.`ig_id` AS ig_id_170, u9_.`test` AS test_171, u9_.`token_fixed` AS token_fixed_172, u9_.`bid` AS bid_173, u9_.`email` AS email_174, u9_.`salt` AS salt_175, u9_.`review_request_sent` AS review_request_sent_176, u9_.`username` AS username_177, u9_.`roles` AS roles_178, u9_.`enabled` AS enabled_179, u9_.`confirmation_token` AS confirmation_token_180, u9_.`last_login` AS last_login_181, u9_.`password_requested_at` AS password_requested_at_182, u9_.`security_field` AS security_field_183, u9_.`created_at` AS created_at_184, u9_.`is_legal_entity` AS is_legal_entity_185, u9_.`companyName` AS companyName_186, u9_.`vatNumber` AS vatNumber_187, u9_.`lang` AS lang_188, l10_.`id` AS id_189, l10_.`source` AS source_190, l10_.`ru` AS ru_191, l10_.`en` AS en_192, l10_.`it` AS it_193, l10_.`es` AS es_194, l10_.`fr` AS fr_195, l10_.`de` AS de_196, l10_.`pl` AS pl_197, l10_.`pt` AS pt_198, l10_.`nl` AS nl_199, l10_.`fi` AS fi_200, l10_.`ua` AS ua_201, l10_.`sv` AS sv_202, l10_.`no` AS no_203, l10_.`da` AS da_204, l10_.`cn` AS cn_205, l10_.`zh` AS zh_206, l10_.`created_at` AS created_at_207, l10_.`updated_at` AS updated_at_208 FROM `publication` p0_ LEFT JOIN `locale_url` l1_ ON p0_.id = l1_.publication_id LEFT JOIN `locale_html` l2_ ON p0_.id = l2_.publication_body_id LEFT JOIN `locale_title` l3_ ON p0_.id = l3_.publication_id LEFT JOIN `locale_meta` l4_ ON p0_.id = l4_.blog_description_id LEFT JOIN `locale_meta` l5_ ON p0_.id = l5_.blog_keywords_id LEFT JOIN `locale_bool` l6_ ON p0_.id = l6_.blog_show_id LEFT JOIN `locale_preview` l7_ ON p0_.id = l7_.publication_id LEFT JOIN `publication_like` p8_ ON p0_.id = p8_.publication_id LEFT JOIN `user` u9_ ON p0_.author = u9_.id LEFT JOIN `locale_bool` l10_ ON p0_.id = l10_.blog_hide_single_id WHERE l1_.`ru` = 'fast-delivery-tile-samples' OR l1_.`en` = 'fast-delivery-tile-samples' OR l1_.`it` = 'fast-delivery-tile-samples' OR l1_.`es` = 'fast-delivery-tile-samples' OR l1_.`fr` = 'fast-delivery-tile-samples' OR l1_.`de` = 'fast-delivery-tile-samples' OR l1_.`pl` = 'fast-delivery-tile-samples' OR l1_.`nl` = 'fast-delivery-tile-samples' OR l1_.`fi` = 'fast-delivery-tile-samples' OR l1_.`sv` = 'fast-delivery-tile-samples';
2	0.75 ms	UPDATE `publication` SET `view` = `view` + 1 WHERE `id` = 2232; Parameters: [] View formatted query View runnable query Explain query UPDATE `publication` SET `view` = `view` + 1 WHERE `id` = 2232; UPDATE `publication` SET `view` = `view` + 1 WHERE `id` = 2232;;
3	2.05 ms	SELECT t0.`id` AS id_1, t0.`enable` AS enable_2, t0.`unid` AS unid_3, t0.`publish_date` AS publish_date_4, t0.`update_date` AS update_date_5, t0.`view` AS view_6, t0.`hide_countries` AS hide_countries_7, t0.author AS author_8, t9.`id` AS id_10, t9.`source` AS source_11, t9.`ru` AS ru_12, t9.`en` AS en_13, t9.`it` AS it_14, t9.`es` AS es_15, t9.`fr` AS fr_16, t9.`de` AS de_17, t9.`pl` AS pl_18, t9.`pt` AS pt_19, t9.`nl` AS nl_20, t9.`fi` AS fi_21, t9.`ua` AS ua_22, t9.`sv` AS sv_23, t9.`no` AS no_24, t9.`da` AS da_25, t9.`cn` AS cn_26, t9.`zh` AS zh_27, t9.`created_at` AS created_at_28, t9.`updated_at` AS updated_at_29, t9.email_title_id AS email_title_id_30, t9.publication_id AS publication_id_31, t9.static_page_title_id AS static_page_title_id_32, t9.exh_title_id AS exh_title_id_33, t9.filter_name_single_id AS filter_name_single_id_34, t9.filter_name_many_id AS filter_name_many_id_35, t9.filter_name_menu_id AS filter_name_menu_id_36, t37.`id` AS id_38, t37.`source` AS source_39, t37.`ru` AS ru_40, t37.`en` AS en_41, t37.`it` AS it_42, t37.`es` AS es_43, t37.`fr` AS fr_44, t37.`de` AS de_45, t37.`pl` AS pl_46, t37.`pt` AS pt_47, t37.`nl` AS nl_48, t37.`fi` AS fi_49, t37.`ua` AS ua_50, t37.`sv` AS sv_51, t37.`no` AS no_52, t37.`da` AS da_53, t37.`cn` AS cn_54, t37.`zh` AS zh_55, t37.`created_at` AS created_at_56, t37.`updated_at` AS updated_at_57, t37.email_body_id AS email_body_id_58, t37.publication_body_id AS publication_body_id_59, t37.static_page_body_id AS static_page_body_id_60, t37.collection_body_id AS collection_body_id_61, t37.trans_val_id AS trans_val_id_62, t37.exh_text_id AS exh_text_id_63, t37.exh_brand_text_id AS exh_brand_text_id_64, t37.exh_collection_text_id AS exh_collection_text_id_65, t37.filter_html_id AS filter_html_id_66, t67.`id` AS id_68, t67.`source` AS source_69, t67.`ru` AS ru_70, t67.`en` AS en_71, t67.`it` AS it_72, t67.`es` AS es_73, t67.`fr` AS fr_74, t67.`de` AS de_75, t67.`pl` AS pl_76, t67.`pt` AS pt_77, t67.`nl` AS nl_78, t67.`fi` AS fi_79, t67.`ua` AS ua_80, t67.`sv` AS sv_81, t67.`no` AS no_82, t67.`da` AS da_83, t67.`cn` AS cn_84, t67.`zh` AS zh_85, t67.`created_at` AS created_at_86, t67.`updated_at` AS updated_at_87, t67.publication_id AS publication_id_88, t67.filter_id AS filter_id_89, t67.exh_id AS exh_id_90, t91.`id` AS id_92, t91.`def` AS def_93, t91.`ru` AS ru_94, t91.`en` AS en_95, t91.`it` AS it_96, t91.`es` AS es_97, t91.`fr` AS fr_98, t91.`de` AS de_99, t91.`pl` AS pl_100, t91.`pt` AS pt_101, t91.`nl` AS nl_102, t91.`fi` AS fi_103, t91.`ua` AS ua_104, t91.`sv` AS sv_105, t91.`no` AS no_106, t91.`da` AS da_107, t91.`cn` AS cn_108, t91.`zh` AS zh_109, t91.`created_at` AS created_at_110, t91.`updated_at` AS updated_at_111, t91.publication_id AS publication_id_112, t91.exh_id AS exh_id_113, t114.`id` AS id_115, t114.`source` AS source_116, t114.`ru` AS ru_117, t114.`en` AS en_118, t114.`it` AS it_119, t114.`es` AS es_120, t114.`fr` AS fr_121, t114.`de` AS de_122, t114.`pl` AS pl_123, t114.`pt` AS pt_124, t114.`nl` AS nl_125, t114.`fi` AS fi_126, t114.`ua` AS ua_127, t114.`sv` AS sv_128, t114.`no` AS no_129, t114.`da` AS da_130, t114.`cn` AS cn_131, t114.`zh` AS zh_132, t114.`created_at` AS created_at_133, t114.`updated_at` AS updated_at_134, t114.static_page_title_id AS static_page_title_id_135, t114.static_page_keywords_id AS static_page_keywords_id_136, t114.static_page_description_id AS static_page_description_id_137, t114.collection_keywords_id AS collection_keywords_id_138, t114.collection_description_id AS collection_description_id_139, t114.blog_keywords_id AS blog_keywords_id_140, t114.blog_description_id AS blog_description_id_141, t114.exh_keywords_id AS exh_keywords_id_142, t114.exh_description_id AS exh_description_id_143, t144.`id` AS id_145, t144.`source` AS source_146, t144.`ru` AS ru_147, t144.`en` AS en_148, t144.`it` AS it_149, t144.`es` AS es_150, t144.`fr` AS fr_151, t144.`de` AS de_152, t144.`pl` AS pl_153, t144.`pt` AS pt_154, t144.`nl` AS nl_155, t144.`fi` AS fi_156, t144.`ua` AS ua_157, t144.`sv` AS sv_158, t144.`no` AS no_159, t144.`da` AS da_160, t144.`cn` AS cn_161, t144.`zh` AS zh_162, t144.`created_at` AS created_at_163, t144.`updated_at` AS updated_at_164, t144.static_page_title_id AS static_page_title_id_165, t144.static_page_keywords_id AS static_page_keywords_id_166, t144.static_page_description_id AS static_page_description_id_167, t144.collection_keywords_id AS collection_keywords_id_168, t144.collection_description_id AS collection_description_id_169, t144.blog_keywords_id AS blog_keywords_id_170, t144.blog_description_id AS blog_description_id_171, t144.exh_keywords_id AS exh_keywords_id_172, t144.exh_description_id AS exh_description_id_173, t174.`id` AS id_175, t174.`source` AS source_176, t174.`ru` AS ru_177, t174.`en` AS en_178, t174.`it` AS it_179, t174.`es` AS es_180, t174.`fr` AS fr_181, t174.`de` AS de_182, t174.`pl` AS pl_183, t174.`pt` AS pt_184, t174.`nl` AS nl_185, t174.`fi` AS fi_186, t174.`ua` AS ua_187, t174.`sv` AS sv_188, t174.`no` AS no_189, t174.`da` AS da_190, t174.`cn` AS cn_191, t174.`zh` AS zh_192, t174.`created_at` AS created_at_193, t174.`updated_at` AS updated_at_194, t174.blog_show_id AS blog_show_id_195, t174.blog_hide_single_id AS blog_hide_single_id_196, t174.static_page_status_show_id AS static_page_status_show_id_197, t174.static_page_comment_show_id AS static_page_comment_show_id_198, t174.filter_html_show_id AS filter_html_show_id_199, t174.exh_show_id AS exh_show_id_200, t174.exh_hide_single_id AS exh_hide_single_id_201, t202.`id` AS id_203, t202.`ru` AS ru_204, t202.`en` AS en_205, t202.`it` AS it_206, t202.`es` AS es_207, t202.`fr` AS fr_208, t202.`de` AS de_209, t202.`pl` AS pl_210, t202.`pt` AS pt_211, t202.`nl` AS nl_212, t202.`fi` AS fi_213, t202.`ua` AS ua_214, t202.`sv` AS sv_215, t202.`no` AS no_216, t202.`da` AS da_217, t202.`cn` AS cn_218, t202.`zh` AS zh_219, t202.`created_at` AS created_at_220, t202.`updated_at` AS updated_at_221, t202.publication_id AS publication_id_222, t202.exh_id AS exh_id_223, t224.`id` AS id_225, t224.`source` AS source_226, t224.`ru` AS ru_227, t224.`en` AS en_228, t224.`it` AS it_229, t224.`es` AS es_230, t224.`fr` AS fr_231, t224.`de` AS de_232, t224.`pl` AS pl_233, t224.`pt` AS pt_234, t224.`nl` AS nl_235, t224.`fi` AS fi_236, t224.`ua` AS ua_237, t224.`sv` AS sv_238, t224.`no` AS no_239, t224.`da` AS da_240, t224.`cn` AS cn_241, t224.`zh` AS zh_242, t224.`created_at` AS created_at_243, t224.`updated_at` AS updated_at_244, t224.blog_show_id AS blog_show_id_245, t224.blog_hide_single_id AS blog_hide_single_id_246, t224.static_page_status_show_id AS static_page_status_show_id_247, t224.static_page_comment_show_id AS static_page_comment_show_id_248, t224.filter_html_show_id AS filter_html_show_id_249, t224.exh_show_id AS exh_show_id_250, t224.exh_hide_single_id AS exh_hide_single_id_251 FROM `publication` t0 LEFT JOIN `locale_title` t9 ON t9.publication_id = t0.id LEFT JOIN `locale_html` t37 ON t37.publication_body_id = t0.id LEFT JOIN `locale_url` t67 ON t67.publication_id = t0.id LEFT JOIN `locale_preview` t91 ON t91.publication_id = t0.id LEFT JOIN `locale_meta` t114 ON t114.blog_keywords_id = t0.id LEFT JOIN `locale_meta` t144 ON t144.blog_description_id = t0.id LEFT JOIN `locale_bool` t174 ON t174.blog_show_id = t0.id LEFT JOIN `locale_status_translate` t202 ON t202.publication_id = t0.id LEFT JOIN `locale_bool` t224 ON t224.blog_hide_single_id = t0.id WHERE t0.`id` = ? Parameters: [`2232`] View formatted query View runnable query Explain query SELECT t0.`id` AS id_1, t0.`enable` AS enable_2, t0.`unid` AS unid_3, t0.`publish_date` AS publish_date_4, t0.`update_date` AS update_date_5, t0.`view` AS view_6, t0.`hide_countries` AS hide_countries_7, t0.author AS author_8, t9.`id` AS id_10, t9.`source` AS source_11, t9.`ru` AS ru_12, t9.`en` AS en_13, t9.`it` AS it_14, t9.`es` AS es_15, t9.`fr` AS fr_16, t9.`de` AS de_17, t9.`pl` AS pl_18, t9.`pt` AS pt_19, t9.`nl` AS nl_20, t9.`fi` AS fi_21, t9.`ua` AS ua_22, t9.`sv` AS sv_23, t9.`no` AS no_24, t9.`da` AS da_25, t9.`cn` AS cn_26, t9.`zh` AS zh_27, t9.`created_at` AS created_at_28, t9.`updated_at` AS updated_at_29, t9.email_title_id AS email_title_id_30, t9.publication_id AS publication_id_31, t9.static_page_title_id AS static_page_title_id_32, t9.exh_title_id AS exh_title_id_33, t9.filter_name_single_id AS filter_name_single_id_34, t9.filter_name_many_id AS filter_name_many_id_35, t9.filter_name_menu_id AS filter_name_menu_id_36, t37.`id` AS id_38, t37.`source` AS source_39, t37.`ru` AS ru_40, t37.`en` AS en_41, t37.`it` AS it_42, t37.`es` AS es_43, t37.`fr` AS fr_44, t37.`de` AS de_45, t37.`pl` AS pl_46, t37.`pt` AS pt_47, t37.`nl` AS nl_48, t37.`fi` AS fi_49, t37.`ua` AS ua_50, t37.`sv` AS sv_51, t37.`no` AS no_52, t37.`da` AS da_53, t37.`cn` AS cn_54, t37.`zh` AS zh_55, t37.`created_at` AS created_at_56, t37.`updated_at` AS updated_at_57, t37.email_body_id AS email_body_id_58, t37.publication_body_id AS publication_body_id_59, t37.static_page_body_id AS static_page_body_id_60, t37.collection_body_id AS collection_body_id_61, t37.trans_val_id AS trans_val_id_62, t37.exh_text_id AS exh_text_id_63, t37.exh_brand_text_id AS exh_brand_text_id_64, t37.exh_collection_text_id AS exh_collection_text_id_65, t37.filter_html_id AS filter_html_id_66, t67.`id` AS id_68, t67.`source` AS source_69, t67.`ru` AS ru_70, t67.`en` AS en_71, t67.`it` AS it_72, t67.`es` AS es_73, t67.`fr` AS fr_74, t67.`de` AS de_75, t67.`pl` AS pl_76, t67.`pt` AS pt_77, t67.`nl` AS nl_78, t67.`fi` AS fi_79, t67.`ua` AS ua_80, t67.`sv` AS sv_81, t67.`no` AS no_82, t67.`da` AS da_83, t67.`cn` AS cn_84, t67.`zh` AS zh_85, t67.`created_at` AS created_at_86, t67.`updated_at` AS updated_at_87, t67.publication_id AS publication_id_88, t67.filter_id AS filter_id_89, t67.exh_id AS exh_id_90, t91.`id` AS id_92, t91.`def` AS def_93, t91.`ru` AS ru_94, t91.`en` AS en_95, t91.`it` AS it_96, t91.`es` AS es_97, t91.`fr` AS fr_98, t91.`de` AS de_99, t91.`pl` AS pl_100, t91.`pt` AS pt_101, t91.`nl` AS nl_102, t91.`fi` AS fi_103, t91.`ua` AS ua_104, t91.`sv` AS sv_105, t91.`no` AS no_106, t91.`da` AS da_107, t91.`cn` AS cn_108, t91.`zh` AS zh_109, t91.`created_at` AS created_at_110, t91.`updated_at` AS updated_at_111, t91.publication_id AS publication_id_112, t91.exh_id AS exh_id_113, t114.`id` AS id_115, t114.`source` AS source_116, t114.`ru` AS ru_117, t114.`en` AS en_118, t114.`it` AS it_119, t114.`es` AS es_120, t114.`fr` AS fr_121, t114.`de` AS de_122, t114.`pl` AS pl_123, t114.`pt` AS pt_124, t114.`nl` AS nl_125, t114.`fi` AS fi_126, t114.`ua` AS ua_127, t114.`sv` AS sv_128, t114.`no` AS no_129, t114.`da` AS da_130, t114.`cn` AS cn_131, t114.`zh` AS zh_132, t114.`created_at` AS created_at_133, t114.`updated_at` AS updated_at_134, t114.static_page_title_id AS static_page_title_id_135, t114.static_page_keywords_id AS static_page_keywords_id_136, t114.static_page_description_id AS static_page_description_id_137, t114.collection_keywords_id AS collection_keywords_id_138, t114.collection_description_id AS collection_description_id_139, t114.blog_keywords_id AS blog_keywords_id_140, t114.blog_description_id AS blog_description_id_141, t114.exh_keywords_id AS exh_keywords_id_142, t114.exh_description_id AS exh_description_id_143, t144.`id` AS id_145, t144.`source` AS source_146, t144.`ru` AS ru_147, t144.`en` AS en_148, t144.`it` AS it_149, t144.`es` AS es_150, t144.`fr` AS fr_151, t144.`de` AS de_152, t144.`pl` AS pl_153, t144.`pt` AS pt_154, t144.`nl` AS nl_155, t144.`fi` AS fi_156, t144.`ua` AS ua_157, t144.`sv` AS sv_158, t144.`no` AS no_159, t144.`da` AS da_160, t144.`cn` AS cn_161, t144.`zh` AS zh_162, t144.`created_at` AS created_at_163, t144.`updated_at` AS updated_at_164, t144.static_page_title_id AS static_page_title_id_165, t144.static_page_keywords_id AS static_page_keywords_id_166, t144.static_page_description_id AS static_page_description_id_167, t144.collection_keywords_id AS collection_keywords_id_168, t144.collection_description_id AS collection_description_id_169, t144.blog_keywords_id AS blog_keywords_id_170, t144.blog_description_id AS blog_description_id_171, t144.exh_keywords_id AS exh_keywords_id_172, t144.exh_description_id AS exh_description_id_173, t174.`id` AS id_175, t174.`source` AS source_176, t174.`ru` AS ru_177, t174.`en` AS en_178, t174.`it` AS it_179, t174.`es` AS es_180, t174.`fr` AS fr_181, t174.`de` AS de_182, t174.`pl` AS pl_183, t174.`pt` AS pt_184, t174.`nl` AS nl_185, t174.`fi` AS fi_186, t174.`ua` AS ua_187, t174.`sv` AS sv_188, t174.`no` AS no_189, t174.`da` AS da_190, t174.`cn` AS cn_191, t174.`zh` AS zh_192, t174.`created_at` AS created_at_193, t174.`updated_at` AS updated_at_194, t174.blog_show_id AS blog_show_id_195, t174.blog_hide_single_id AS blog_hide_single_id_196, t174.static_page_status_show_id AS static_page_status_show_id_197, t174.static_page_comment_show_id AS static_page_comment_show_id_198, t174.filter_html_show_id AS filter_html_show_id_199, t174.exh_show_id AS exh_show_id_200, t174.exh_hide_single_id AS exh_hide_single_id_201, t202.`id` AS id_203, t202.`ru` AS ru_204, t202.`en` AS en_205, t202.`it` AS it_206, t202.`es` AS es_207, t202.`fr` AS fr_208, t202.`de` AS de_209, t202.`pl` AS pl_210, t202.`pt` AS pt_211, t202.`nl` AS nl_212, t202.`fi` AS fi_213, t202.`ua` AS ua_214, t202.`sv` AS sv_215, t202.`no` AS no_216, t202.`da` AS da_217, t202.`cn` AS cn_218, t202.`zh` AS zh_219, t202.`created_at` AS created_at_220, t202.`updated_at` AS updated_at_221, t202.publication_id AS publication_id_222, t202.exh_id AS exh_id_223, t224.`id` AS id_225, t224.`source` AS source_226, t224.`ru` AS ru_227, t224.`en` AS en_228, t224.`it` AS it_229, t224.`es` AS es_230, t224.`fr` AS fr_231, t224.`de` AS de_232, t224.`pl` AS pl_233, t224.`pt` AS pt_234, t224.`nl` AS nl_235, t224.`fi` AS fi_236, t224.`ua` AS ua_237, t224.`sv` AS sv_238, t224.`no` AS no_239, t224.`da` AS da_240, t224.`cn` AS cn_241, t224.`zh` AS zh_242, t224.`created_at` AS created_at_243, t224.`updated_at` AS updated_at_244, t224.blog_show_id AS blog_show_id_245, t224.blog_hide_single_id AS blog_hide_single_id_246, t224.static_page_status_show_id AS static_page_status_show_id_247, t224.static_page_comment_show_id AS static_page_comment_show_id_248, t224.filter_html_show_id AS filter_html_show_id_249, t224.exh_show_id AS exh_show_id_250, t224.exh_hide_single_id AS exh_hide_single_id_251 FROM `publication` t0 LEFT JOIN `locale_title` t9 ON t9.publication_id = t0.id LEFT JOIN `locale_html` t37 ON t37.publication_body_id = t0.id LEFT JOIN `locale_url` t67 ON t67.publication_id = t0.id LEFT JOIN `locale_preview` t91 ON t91.publication_id = t0.id LEFT JOIN `locale_meta` t114 ON t114.blog_keywords_id = t0.id LEFT JOIN `locale_meta` t144 ON t144.blog_description_id = t0.id LEFT JOIN `locale_bool` t174 ON t174.blog_show_id = t0.id LEFT JOIN `locale_status_translate` t202 ON t202.publication_id = t0.id LEFT JOIN `locale_bool` t224 ON t224.blog_hide_single_id = t0.id WHERE t0.`id` = ? SELECT t0.`id` AS id_1, t0.`enable` AS enable_2, t0.`unid` AS unid_3, t0.`publish_date` AS publish_date_4, t0.`update_date` AS update_date_5, t0.`view` AS view_6, t0.`hide_countries` AS hide_countries_7, t0.author AS author_8, t9.`id` AS id_10, t9.`source` AS source_11, t9.`ru` AS ru_12, t9.`en` AS en_13, t9.`it` AS it_14, t9.`es` AS es_15, t9.`fr` AS fr_16, t9.`de` AS de_17, t9.`pl` AS pl_18, t9.`pt` AS pt_19, t9.`nl` AS nl_20, t9.`fi` AS fi_21, t9.`ua` AS ua_22, t9.`sv` AS sv_23, t9.`no` AS no_24, t9.`da` AS da_25, t9.`cn` AS cn_26, t9.`zh` AS zh_27, t9.`created_at` AS created_at_28, t9.`updated_at` AS updated_at_29, t9.email_title_id AS email_title_id_30, t9.publication_id AS publication_id_31, t9.static_page_title_id AS static_page_title_id_32, t9.exh_title_id AS exh_title_id_33, t9.filter_name_single_id AS filter_name_single_id_34, t9.filter_name_many_id AS filter_name_many_id_35, t9.filter_name_menu_id AS filter_name_menu_id_36, t37.`id` AS id_38, t37.`source` AS source_39, t37.`ru` AS ru_40, t37.`en` AS en_41, t37.`it` AS it_42, t37.`es` AS es_43, t37.`fr` AS fr_44, t37.`de` AS de_45, t37.`pl` AS pl_46, t37.`pt` AS pt_47, t37.`nl` AS nl_48, t37.`fi` AS fi_49, t37.`ua` AS ua_50, t37.`sv` AS sv_51, t37.`no` AS no_52, t37.`da` AS da_53, t37.`cn` AS cn_54, t37.`zh` AS zh_55, t37.`created_at` AS created_at_56, t37.`updated_at` AS updated_at_57, t37.email_body_id AS email_body_id_58, t37.publication_body_id AS publication_body_id_59, t37.static_page_body_id AS static_page_body_id_60, t37.collection_body_id AS collection_body_id_61, t37.trans_val_id AS trans_val_id_62, t37.exh_text_id AS exh_text_id_63, t37.exh_brand_text_id AS exh_brand_text_id_64, t37.exh_collection_text_id AS exh_collection_text_id_65, t37.filter_html_id AS filter_html_id_66, t67.`id` AS id_68, t67.`source` AS source_69, t67.`ru` AS ru_70, t67.`en` AS en_71, t67.`it` AS it_72, t67.`es` AS es_73, t67.`fr` AS fr_74, t67.`de` AS de_75, t67.`pl` AS pl_76, t67.`pt` AS pt_77, t67.`nl` AS nl_78, t67.`fi` AS fi_79, t67.`ua` AS ua_80, t67.`sv` AS sv_81, t67.`no` AS no_82, t67.`da` AS da_83, t67.`cn` AS cn_84, t67.`zh` AS zh_85, t67.`created_at` AS created_at_86, t67.`updated_at` AS updated_at_87, t67.publication_id AS publication_id_88, t67.filter_id AS filter_id_89, t67.exh_id AS exh_id_90, t91.`id` AS id_92, t91.`def` AS def_93, t91.`ru` AS ru_94, t91.`en` AS en_95, t91.`it` AS it_96, t91.`es` AS es_97, t91.`fr` AS fr_98, t91.`de` AS de_99, t91.`pl` AS pl_100, t91.`pt` AS pt_101, t91.`nl` AS nl_102, t91.`fi` AS fi_103, t91.`ua` AS ua_104, t91.`sv` AS sv_105, t91.`no` AS no_106, t91.`da` AS da_107, t91.`cn` AS cn_108, t91.`zh` AS zh_109, t91.`created_at` AS created_at_110, t91.`updated_at` AS updated_at_111, t91.publication_id AS publication_id_112, t91.exh_id AS exh_id_113, t114.`id` AS id_115, t114.`source` AS source_116, t114.`ru` AS ru_117, t114.`en` AS en_118, t114.`it` AS it_119, t114.`es` AS es_120, t114.`fr` AS fr_121, t114.`de` AS de_122, t114.`pl` AS pl_123, t114.`pt` AS pt_124, t114.`nl` AS nl_125, t114.`fi` AS fi_126, t114.`ua` AS ua_127, t114.`sv` AS sv_128, t114.`no` AS no_129, t114.`da` AS da_130, t114.`cn` AS cn_131, t114.`zh` AS zh_132, t114.`created_at` AS created_at_133, t114.`updated_at` AS updated_at_134, t114.static_page_title_id AS static_page_title_id_135, t114.static_page_keywords_id AS static_page_keywords_id_136, t114.static_page_description_id AS static_page_description_id_137, t114.collection_keywords_id AS collection_keywords_id_138, t114.collection_description_id AS collection_description_id_139, t114.blog_keywords_id AS blog_keywords_id_140, t114.blog_description_id AS blog_description_id_141, t114.exh_keywords_id AS exh_keywords_id_142, t114.exh_description_id AS exh_description_id_143, t144.`id` AS id_145, t144.`source` AS source_146, t144.`ru` AS ru_147, t144.`en` AS en_148, t144.`it` AS it_149, t144.`es` AS es_150, t144.`fr` AS fr_151, t144.`de` AS de_152, t144.`pl` AS pl_153, t144.`pt` AS pt_154, t144.`nl` AS nl_155, t144.`fi` AS fi_156, t144.`ua` AS ua_157, t144.`sv` AS sv_158, t144.`no` AS no_159, t144.`da` AS da_160, t144.`cn` AS cn_161, t144.`zh` AS zh_162, t144.`created_at` AS created_at_163, t144.`updated_at` AS updated_at_164, t144.static_page_title_id AS static_page_title_id_165, t144.static_page_keywords_id AS static_page_keywords_id_166, t144.static_page_description_id AS static_page_description_id_167, t144.collection_keywords_id AS collection_keywords_id_168, t144.collection_description_id AS collection_description_id_169, t144.blog_keywords_id AS blog_keywords_id_170, t144.blog_description_id AS blog_description_id_171, t144.exh_keywords_id AS exh_keywords_id_172, t144.exh_description_id AS exh_description_id_173, t174.`id` AS id_175, t174.`source` AS source_176, t174.`ru` AS ru_177, t174.`en` AS en_178, t174.`it` AS it_179, t174.`es` AS es_180, t174.`fr` AS fr_181, t174.`de` AS de_182, t174.`pl` AS pl_183, t174.`pt` AS pt_184, t174.`nl` AS nl_185, t174.`fi` AS fi_186, t174.`ua` AS ua_187, t174.`sv` AS sv_188, t174.`no` AS no_189, t174.`da` AS da_190, t174.`cn` AS cn_191, t174.`zh` AS zh_192, t174.`created_at` AS created_at_193, t174.`updated_at` AS updated_at_194, t174.blog_show_id AS blog_show_id_195, t174.blog_hide_single_id AS blog_hide_single_id_196, t174.static_page_status_show_id AS static_page_status_show_id_197, t174.static_page_comment_show_id AS static_page_comment_show_id_198, t174.filter_html_show_id AS filter_html_show_id_199, t174.exh_show_id AS exh_show_id_200, t174.exh_hide_single_id AS exh_hide_single_id_201, t202.`id` AS id_203, t202.`ru` AS ru_204, t202.`en` AS en_205, t202.`it` AS it_206, t202.`es` AS es_207, t202.`fr` AS fr_208, t202.`de` AS de_209, t202.`pl` AS pl_210, t202.`pt` AS pt_211, t202.`nl` AS nl_212, t202.`fi` AS fi_213, t202.`ua` AS ua_214, t202.`sv` AS sv_215, t202.`no` AS no_216, t202.`da` AS da_217, t202.`cn` AS cn_218, t202.`zh` AS zh_219, t202.`created_at` AS created_at_220, t202.`updated_at` AS updated_at_221, t202.publication_id AS publication_id_222, t202.exh_id AS exh_id_223, t224.`id` AS id_225, t224.`source` AS source_226, t224.`ru` AS ru_227, t224.`en` AS en_228, t224.`it` AS it_229, t224.`es` AS es_230, t224.`fr` AS fr_231, t224.`de` AS de_232, t224.`pl` AS pl_233, t224.`pt` AS pt_234, t224.`nl` AS nl_235, t224.`fi` AS fi_236, t224.`ua` AS ua_237, t224.`sv` AS sv_238, t224.`no` AS no_239, t224.`da` AS da_240, t224.`cn` AS cn_241, t224.`zh` AS zh_242, t224.`created_at` AS created_at_243, t224.`updated_at` AS updated_at_244, t224.blog_show_id AS blog_show_id_245, t224.blog_hide_single_id AS blog_hide_single_id_246, t224.static_page_status_show_id AS static_page_status_show_id_247, t224.static_page_comment_show_id AS static_page_comment_show_id_248, t224.filter_html_show_id AS filter_html_show_id_249, t224.exh_show_id AS exh_show_id_250, t224.exh_hide_single_id AS exh_hide_single_id_251 FROM `publication` t0 LEFT JOIN `locale_title` t9 ON t9.publication_id = t0.id LEFT JOIN `locale_html` t37 ON t37.publication_body_id = t0.id LEFT JOIN `locale_url` t67 ON t67.publication_id = t0.id LEFT JOIN `locale_preview` t91 ON t91.publication_id = t0.id LEFT JOIN `locale_meta` t114 ON t114.blog_keywords_id = t0.id LEFT JOIN `locale_meta` t144 ON t144.blog_description_id = t0.id LEFT JOIN `locale_bool` t174 ON t174.blog_show_id = t0.id LEFT JOIN `locale_status_translate` t202 ON t202.publication_id = t0.id LEFT JOIN `locale_bool` t224 ON t224.blog_hide_single_id = t0.id WHERE t0.`id` = 2232;
4	3.22 ms	SELECT c0_.`id` AS id_0, c0_.`special_date_start` AS special_date_start_1, c0_.`special_date_end` AS special_date_end_2, c0_.`is_working` AS is_working_3, c0_.`mode` AS mode_4, c0_.`mode_holiday` AS mode_holiday_5, c0_.`lang` AS lang_6, c0_.`timeZoneName` AS timeZoneName_7, c0_.country_id AS country_id_8, c0_.blog_id AS blog_id_9 FROM `calendar` c0_ WHERE c0_.blog_id = ? AND c0_.`is_working` = ? AND c0_.country_id = ? ORDER BY c0_.`special_date_start` ASC LIMIT 100 Parameters: [`2232 2 124`] View formatted query View runnable query Explain query SELECT c0_.`id` AS id_0, c0_.`special_date_start` AS special_date_start_1, c0_.`special_date_end` AS special_date_end_2, c0_.`is_working` AS is_working_3, c0_.`mode` AS mode_4, c0_.`mode_holiday` AS mode_holiday_5, c0_.`lang` AS lang_6, c0_.`timeZoneName` AS timeZoneName_7, c0_.country_id AS country_id_8, c0_.blog_id AS blog_id_9 FROM `calendar` c0_ WHERE c0_.blog_id = ? AND c0_.`is_working` = ? AND c0_.country_id = ? ORDER BY c0_.`special_date_start` ASC LIMIT 100 SELECT c0_.`id` AS id_0, c0_.`special_date_start` AS special_date_start_1, c0_.`special_date_end` AS special_date_end_2, c0_.`is_working` AS is_working_3, c0_.`mode` AS mode_4, c0_.`mode_holiday` AS mode_holiday_5, c0_.`lang` AS lang_6, c0_.`timeZoneName` AS timeZoneName_7, c0_.country_id AS country_id_8, c0_.blog_id AS blog_id_9 FROM `calendar` c0_ WHERE c0_.blog_id = 2232 AND c0_.`is_working` = 2 AND c0_.country_id = 124 ORDER BY c0_.`special_date_start` ASC LIMIT 100;
5	0.30 ms	SELECT c0_.`id` AS id_0, c0_.`special_date_start` AS special_date_start_1, c0_.`special_date_end` AS special_date_end_2, c0_.`is_working` AS is_working_3, c0_.`mode` AS mode_4, c0_.`mode_holiday` AS mode_holiday_5, c0_.`lang` AS lang_6, c0_.`timeZoneName` AS timeZoneName_7, c0_.country_id AS country_id_8, c0_.blog_id AS blog_id_9 FROM `calendar` c0_ WHERE c0_.blog_id = ? AND c0_.`is_working` = ? AND (c0_.country_id IS NULL OR c0_.country_id = 0 OR c0_.country_id = 'en') ORDER BY c0_.`special_date_start` ASC LIMIT 100 Parameters: [`2232 2`] View formatted query View runnable query Explain query SELECT c0_.`id` AS id_0, c0_.`special_date_start` AS special_date_start_1, c0_.`special_date_end` AS special_date_end_2, c0_.`is_working` AS is_working_3, c0_.`mode` AS mode_4, c0_.`mode_holiday` AS mode_holiday_5, c0_.`lang` AS lang_6, c0_.`timeZoneName` AS timeZoneName_7, c0_.country_id AS country_id_8, c0_.blog_id AS blog_id_9 FROM `calendar` c0_ WHERE c0_.blog_id = ? AND c0_.`is_working` = ? AND ( c0_.country_id IS NULL OR c0_.country_id = 0 OR c0_.country_id = 'en' ) ORDER BY c0_.`special_date_start` ASC LIMIT 100 SELECT c0_.`id` AS id_0, c0_.`special_date_start` AS special_date_start_1, c0_.`special_date_end` AS special_date_end_2, c0_.`is_working` AS is_working_3, c0_.`mode` AS mode_4, c0_.`mode_holiday` AS mode_holiday_5, c0_.`lang` AS lang_6, c0_.`timeZoneName` AS timeZoneName_7, c0_.country_id AS country_id_8, c0_.blog_id AS blog_id_9 FROM `calendar` c0_ WHERE c0_.blog_id = 2232 AND c0_.`is_working` = 2 AND (c0_.country_id IS NULL OR c0_.country_id = 0 OR c0_.country_id = 'en') ORDER BY c0_.`special_date_start` ASC LIMIT 100;
6	0.55 ms	SELECT c0_.`id` AS id_0, c0_.`special_date_start` AS special_date_start_1, c0_.`special_date_end` AS special_date_end_2, c0_.`is_working` AS is_working_3, c0_.`mode` AS mode_4, c0_.`mode_holiday` AS mode_holiday_5, c0_.`lang` AS lang_6, c0_.`timeZoneName` AS timeZoneName_7, c0_.country_id AS country_id_8, c0_.blog_id AS blog_id_9 FROM `calendar` c0_ WHERE c0_.blog_id = ? AND c0_.`is_working` = ? AND c0_.country_id = ? ORDER BY c0_.`special_date_start` ASC LIMIT 100 Parameters: [`2232 3 124`] View formatted query View runnable query Explain query SELECT c0_.`id` AS id_0, c0_.`special_date_start` AS special_date_start_1, c0_.`special_date_end` AS special_date_end_2, c0_.`is_working` AS is_working_3, c0_.`mode` AS mode_4, c0_.`mode_holiday` AS mode_holiday_5, c0_.`lang` AS lang_6, c0_.`timeZoneName` AS timeZoneName_7, c0_.country_id AS country_id_8, c0_.blog_id AS blog_id_9 FROM `calendar` c0_ WHERE c0_.blog_id = ? AND c0_.`is_working` = ? AND c0_.country_id = ? ORDER BY c0_.`special_date_start` ASC LIMIT 100 SELECT c0_.`id` AS id_0, c0_.`special_date_start` AS special_date_start_1, c0_.`special_date_end` AS special_date_end_2, c0_.`is_working` AS is_working_3, c0_.`mode` AS mode_4, c0_.`mode_holiday` AS mode_holiday_5, c0_.`lang` AS lang_6, c0_.`timeZoneName` AS timeZoneName_7, c0_.country_id AS country_id_8, c0_.blog_id AS blog_id_9 FROM `calendar` c0_ WHERE c0_.blog_id = 2232 AND c0_.`is_working` = 3 AND c0_.country_id = 124 ORDER BY c0_.`special_date_start` ASC LIMIT 100;
7	0.19 ms	SELECT c0_.`id` AS id_0, c0_.`special_date_start` AS special_date_start_1, c0_.`special_date_end` AS special_date_end_2, c0_.`is_working` AS is_working_3, c0_.`mode` AS mode_4, c0_.`mode_holiday` AS mode_holiday_5, c0_.`lang` AS lang_6, c0_.`timeZoneName` AS timeZoneName_7, c0_.country_id AS country_id_8, c0_.blog_id AS blog_id_9 FROM `calendar` c0_ WHERE c0_.blog_id = ? AND c0_.`is_working` = ? AND (c0_.country_id IS NULL OR c0_.country_id = 0 OR c0_.country_id = 'en') ORDER BY c0_.`special_date_start` ASC LIMIT 100 Parameters: [`2232 3`] View formatted query View runnable query Explain query SELECT c0_.`id` AS id_0, c0_.`special_date_start` AS special_date_start_1, c0_.`special_date_end` AS special_date_end_2, c0_.`is_working` AS is_working_3, c0_.`mode` AS mode_4, c0_.`mode_holiday` AS mode_holiday_5, c0_.`lang` AS lang_6, c0_.`timeZoneName` AS timeZoneName_7, c0_.country_id AS country_id_8, c0_.blog_id AS blog_id_9 FROM `calendar` c0_ WHERE c0_.blog_id = ? AND c0_.`is_working` = ? AND ( c0_.country_id IS NULL OR c0_.country_id = 0 OR c0_.country_id = 'en' ) ORDER BY c0_.`special_date_start` ASC LIMIT 100 SELECT c0_.`id` AS id_0, c0_.`special_date_start` AS special_date_start_1, c0_.`special_date_end` AS special_date_end_2, c0_.`is_working` AS is_working_3, c0_.`mode` AS mode_4, c0_.`mode_holiday` AS mode_holiday_5, c0_.`lang` AS lang_6, c0_.`timeZoneName` AS timeZoneName_7, c0_.country_id AS country_id_8, c0_.blog_id AS blog_id_9 FROM `calendar` c0_ WHERE c0_.blog_id = 2232 AND c0_.`is_working` = 3 AND (c0_.country_id IS NULL OR c0_.country_id = 0 OR c0_.country_id = 'en') ORDER BY c0_.`special_date_start` ASC LIMIT 100;
8	0.18 ms	SELECT s0_.`code` AS code_0, s0_.`value` AS value_1, s0_.`link` AS link_2, s0_.`login` AS login_3, s0_.`token` AS token_4 FROM `social_stat` s0_ WHERE s0_.`locale` IS NULL OR s0_.`locale` = ? Parameters: [`"en"`] View formatted query View runnable query Explain query SELECT s0_.`code` AS code_0, s0_.`value` AS value_1, s0_.`link` AS link_2, s0_.`login` AS login_3, s0_.`token` AS token_4 FROM `social_stat` s0_ WHERE s0_.`locale` IS NULL OR s0_.`locale` = ? SELECT s0_.`code` AS code_0, s0_.`value` AS value_1, s0_.`link` AS link_2, s0_.`login` AS login_3, s0_.`token` AS token_4 FROM `social_stat` s0_ WHERE s0_.`locale` IS NULL OR s0_.`locale` = 'en';
9	2.67 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: [`"8ff1784ccd88f5964392bdd4d6dbf7002390295b8c7bee24c25714037167c117"`] View formatted query View runnable query Explain query 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 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` = '8ff1784ccd88f5964392bdd4d6dbf7002390295b8c7bee24c25714037167c117' LIMIT 1;
10	0.74 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: [`"8ff1784ccd88f5964392bdd4d6dbf7002390295b8c7bee24c25714037167c117"`] View formatted query View runnable query Explain query 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 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` = '8ff1784ccd88f5964392bdd4d6dbf7002390295b8c7bee24c25714037167c117' AND b1_.`status` <> 12;
11	0.50 ms	SELECT b0_.`id` AS id_0 FROM `buy_order` b0_ WHERE b0_.`token` = ? AND b0_.`status` <> 12 Parameters: [`"8ff1784ccd88f5964392bdd4d6dbf7002390295b8c7bee24c25714037167c117"`] View formatted query View runnable query Explain query SELECT b0_.`id` AS id_0 FROM `buy_order` b0_ WHERE b0_.`token` = ? AND b0_.`status` <> 12 SELECT b0_.`id` AS id_0 FROM `buy_order` b0_ WHERE b0_.`token` = '8ff1784ccd88f5964392bdd4d6dbf7002390295b8c7bee24c25714037167c117' AND b0_.`status` <> 12;
12	0.62 ms	SELECT COUNT(v0_.`id`) AS sclr_0 FROM `visit` v0_ WHERE v0_.`token` = ? AND v0_.`url` <> '/.catalog./' Parameters: [`"8ff1784ccd88f5964392bdd4d6dbf7002390295b8c7bee24c25714037167c117"`] View formatted query View runnable query Explain query 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` = '8ff1784ccd88f5964392bdd4d6dbf7002390295b8c7bee24c25714037167c117' AND v0_.`url` <> '/.catalog./';
13	2.09 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: [`"8ff1784ccd88f5964392bdd4d6dbf7002390295b8c7bee24c25714037167c117"`] View formatted query View runnable query Explain query 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` = ? 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` = '8ff1784ccd88f5964392bdd4d6dbf7002390295b8c7bee24c25714037167c117';
14	0.35 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 SELECT b0_.`id` AS id_0, b0_.`name` AS name_1, b0_.`descr` AS descr_2, b0_.`val` AS val_3 FROM `BoolDBSetting` b0_ WHERE b0_.`name` = ? SELECT b0_.`id` AS id_0, b0_.`name` AS name_1, b0_.`descr` AS descr_2, b0_.`val` AS val_3 FROM `BoolDBSetting` b0_ WHERE b0_.`name` = 'RTWidget';
15	0.60 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: [`"8ff1784ccd88f5964392bdd4d6dbf7002390295b8c7bee24c25714037167c117"`] View formatted query View runnable query Explain query 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 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` = '8ff1784ccd88f5964392bdd4d6dbf7002390295b8c7bee24c25714037167c117' LIMIT 1;
16	0.24 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 SELECT b0_.`id` AS id_0, b0_.`name` AS name_1, b0_.`descr` AS descr_2, b0_.`val` AS val_3 FROM `BoolDBSetting` b0_ WHERE b0_.`name` = ? SELECT b0_.`id` AS id_0, b0_.`name` AS name_1, b0_.`descr` AS descr_2, b0_.`val` AS val_3 FROM `BoolDBSetting` b0_ WHERE b0_.`name` = 'RTWidget';
17	0.25 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: [`"ca"`] View formatted query View runnable query Explain query 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` = 'ca';
18	109.61 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 (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 1 1 1`] View formatted query View runnable query Explain query SELECT c0_.`id` AS id_0, c0_.`url` AS url_1, c0_.`code` AS code_2, c0_.`name` AS name_3, c0_.`alternate_name` AS alternate_name_4, c0_.`name_full` AS name_full_5, f1_.`id` AS id_6, f1_.`url` AS url_7, f1_.`unid` AS unid_8, f2_.`id` AS id_9, f1_.`url` AS url_10, f1_.`name` AS name_11, ( SELECT COUNT(p3_.`star`) AS sclr_13 FROM `product_reviews_cache` p3_ WHERE p3_.`sku` = c0_.`code` ) AS sclr_12, ( SELECT SUM(p4_.`star`) AS sclr_15 FROM `product_reviews_cache` p4_ WHERE p4_.`sku` = c0_.`code` ) AS sclr_14 FROM `collection` c0_ INNER JOIN `factory` f1_ ON c0_.factory = f1_.id INNER JOIN `filters` f2_ ON f1_.filter = f2_.id INNER JOIN `list_country` l5_ ON f1_.country = l5_.id LEFT JOIN `locale_url` l6_ ON f2_.id = l6_.filter_id LEFT JOIN `filter_pages` f7_ ON f2_.page_id = f7_.id WHERE f1_.filter IS NOT NULL AND c0_.factory <> '' AND f1_.`status` = ? AND ( c0_.`test_access` IS NULL OR c0_.`test_access` = 0 ) AND ( f1_.`test_access` IS NULL OR f1_.`test_access` = 0 ) AND c0_.`status` = ? AND c0_.`status` = ? AND f1_.`status` = ? ORDER BY c0_.`id` ASC SELECT c0_.`id` AS id_0, c0_.`url` AS url_1, c0_.`code` AS code_2, c0_.`name` AS name_3, c0_.`alternate_name` AS alternate_name_4, c0_.`name_full` AS name_full_5, f1_.`id` AS id_6, f1_.`url` AS url_7, f1_.`unid` AS unid_8, f2_.`id` AS id_9, f1_.`url` AS url_10, f1_.`name` AS name_11, (SELECT COUNT(p3_.`star`) AS sclr_13 FROM `product_reviews_cache` p3_ WHERE p3_.`sku` = c0_.`code`) AS sclr_12, (SELECT SUM(p4_.`star`) AS sclr_15 FROM `product_reviews_cache` p4_ WHERE p4_.`sku` = c0_.`code`) AS sclr_14 FROM `collection` c0_ INNER JOIN `factory` f1_ ON c0_.factory = f1_.id INNER JOIN `filters` f2_ ON f1_.filter = f2_.id INNER JOIN `list_country` l5_ ON f1_.country = l5_.id LEFT JOIN `locale_url` l6_ ON f2_.id = l6_.filter_id LEFT JOIN `filter_pages` f7_ ON f2_.page_id = f7_.id WHERE f1_.filter IS NOT NULL AND c0_.factory <> '' AND f1_.`status` = 1 AND (c0_.`test_access` IS NULL OR c0_.`test_access` = 0) AND (f1_.`test_access` IS NULL OR f1_.`test_access` = 0) AND c0_.`status` = 1 AND c0_.`status` = 1 AND f1_.`status` = 1 ORDER BY c0_.`id` ASC;
19	0.29 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 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 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` = 1 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;
20	1.14 ms	SELECT lu.en 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.en = 1 AND lst.en = 1; Parameters: [] View formatted query View runnable query Explain query SELECT lu.en 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.en = 1 AND lst.en = 1; SELECT lu.en 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.en = 1 AND lst.en = 1; ;
21	3.63 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_.`en` AS en_6, f3_.`name_menu_en` AS name_menu_en_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_.`en` 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 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_.`en` AS en_6, f3_.`name_menu_en` AS name_menu_en_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_.`en` IS NOT NULL AND f5_.`count` > 0 AND f4_.`alt_name` IN (?) ORDER BY f0_.`sort` ASC, f0_.`name` ASC 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_.`en` AS en_6, f3_.`name_menu_en` AS name_menu_en_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_.`en` IS NOT NULL AND f5_.`count` > 0 AND f4_.`alt_name` IN ('effect', 'style', 'samples', 'price', 'color', 'using', 'brand') ORDER BY f0_.`sort` ASC, f0_.`name` ASC;
22	2.62 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 SELECT b0_.`id` AS id_0, b0_.`name` AS name_1, b0_.`descr` AS descr_2, b0_.`val` AS val_3 FROM `BoolDBSetting` b0_ WHERE b0_.`name` = ? SELECT b0_.`id` AS id_0, b0_.`name` AS name_1, b0_.`descr` AS descr_2, b0_.`val` AS val_3 FROM `BoolDBSetting` b0_ WHERE b0_.`name` = 'RTWidget';

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\LocaleUrlEntity	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.
WebBundle\Entity\ListCountry	No errors.
FlexApp\Entity\ConsultantEntity	No errors.
WebBundle\Entity\LocaleHtmlEntity	No errors.
WebBundle\Entity\LocaleTitleEntity	No errors.
WebBundle\Entity\LocaleMetaEntity	No errors.
WebBundle\Entity\LocaleBoolEntity	No errors.
WebBundle\Entity\LocalePreviewEntity	No errors.
WebBundle\Entity\PublicationLike	No errors.
WebBundle\Entity\ListEmail	No errors.
WebBundle\Entity\StaticPageEntity	No errors.
WebBundle\Entity\FilterEntity	No errors.
WebBundle\Entity\Collection	No errors.
WebBundle\Entity\TransEntity	No errors.
FlexApp\Entity\Exhibition\ExhBrandEntity	No errors.
FlexApp\Entity\Exhibition\ExhCollectionEntity	No errors.
WebBundle\Entity\LocaleStatusTranslateEntity	No errors.
WebBundle\Entity\Factory	No errors.
WebBundle\Entity\Calendar	No errors.
WebBundle\Entity\SocialStat	No errors.
FlexApp\Entity\GeoCountryEntity	No errors.
WebBundle\Entity\Article	No errors.
WebBundle\Entity\Visit	No errors.
WebBundle\Entity\Idea	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.
FlexApp\Entity\LikesEntity	No errors.
FlexApp\Entity\AttachmentEntity	No errors.
WebBundle\Entity\ListState	No errors.
WebBundle\Entity\ListEmailGroup	No errors.
WebBundle\Entity\LocaleTextEntity	No errors.
WebBundle\Entity\FilterPageEntity	No errors.
WebBundle\Entity\FilterParamEntity	No errors.
WebBundle\Entity\FilterGroupEntity	No errors.
FlexApp\Entity\Exhibition\ExhImageEntity	No errors.
WebBundle\Entity\ListPrice	No errors.
WebBundle\Entity\Interior	No errors.
WebBundle\Entity\CheckList	No errors.
WebBundle\Entity\TransGroupsEntity	No errors.
FlexApp\Entity\Exhibition\ExhLineEntity	No errors.
WebBundle\Entity\ListBrandParser	No errors.
FlexApp\Entity\GeoLocaleNameEntity	No errors.
FlexApp\Entity\GeoRegionEntity	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\ListUsing	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\ListStyle	No errors.
WebBundle\Entity\ListColor	No errors.
WebBundle\Entity\ListFactoryColor	No errors.
WebBundle\Entity\ListTexture	No errors.
WebBundle\Entity\ListStoneTexture	No errors.
WebBundle\Entity\ArticlePriceDiscount	No errors.
WebBundle\Entity\InteriorArticle	No errors.
WebBundle\Entity\InteriorArticleLogging	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.
WebBundle\Entity\InteriorHistory	No errors.
FlexApp\Entity\Mailing	No errors.
WebBundle\Entity\BuyOrderDelivery	No errors.
WebBundle\Entity\ProductReviewsCache	No errors.
WebBundle\Entity\BuyOrderArticleHoliday	No errors.

oneC entity manager

No loaded entities.

logs entity manager