Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

34 Database Queries

25 Different statements

71.88 ms Query time

0 Invalid entities

Queries

Group similar statements

default connection


SELECT
    f2.id,
    f2.name,
    f2.old_command,
    f2.old_id,
    GROUP_CONCAT(f.id) AS ids,
    GROUP_CONCAT(f.old_id) AS old_ids
FROM
    `filters` f
LEFT JOIN filters f2 ON
    f.parent_id = f2.id
LEFT JOIN filter_params p ON
    f.param_id = p.id
WHERE
    f.parent_id IS NOT NULL AND p.is_enable = 1  AND p.show_menu != 0  
GROUP BY
    f.parent_id;
SELECT
    f2.id,
    f2.name,
    f2.old_command,
    f2.old_id,
    GROUP_CONCAT(f.id) AS ids,
    GROUP_CONCAT(f.old_id) AS old_ids
FROM
    `filters` f
LEFT JOIN filters f2 ON
    f.parent_id = f2.id
LEFT JOIN filter_params p ON
    f.param_id = p.id
WHERE
    f.parent_id IS NOT NULL AND p.is_enable = 1  AND p.show_menu != 0  
GROUP BY
    f.parent_id;
SELECT
    f2.id,
    f2.name,
    f2.old_command,
    f2.old_id,
    GROUP_CONCAT(f.id) AS ids,
    GROUP_CONCAT(f.old_id) AS old_ids
FROM
    `filters` f
LEFT JOIN filters f2 ON
    f.parent_id = f2.id
LEFT JOIN filter_params p ON
    f.param_id = p.id
WHERE
    f.parent_id IS NOT NULL AND p.is_enable = 1  AND p.show_menu != 0  
GROUP BY
    f.parent_id;
SELECT i0_.`id` AS id_0 FROM `idea` i1_ INNER JOIN idea_interior i2_ ON i1_.id = i2_.idea_id INNER JOIN `interior` i0_ ON i0_.id = i2_.interior_id WHERE i1_.`token` = ? GROUP BY i0_.`id`
SELECT
    f2.id,
    f2.name,
    f2.old_command,
    f2.old_id,
    GROUP_CONCAT(f.id) AS ids,
    GROUP_CONCAT(f.old_id) AS old_ids
FROM
    `filters` f
LEFT JOIN filters f2 ON
    f.parent_id = f2.id
LEFT JOIN filter_params p ON
    f.param_id = p.id
WHERE
    f.parent_id IS NOT NULL AND p.is_enable = 1  AND p.show_menu_advanced != 0 
GROUP BY
    f.parent_id;
SELECT t0.`id` AS id_1, t0.`unid` AS unid_2, t0.`name` AS name_3, t0.`name_inv` AS name_inv_4, t0.`url` AS url_5, t0.`alternate_name` AS alternate_name_6, t0.`description_ru` AS description_ru_7, t0.`description_en` AS description_en_8, t0.`description_it` AS description_it_9, t0.`description_es` AS description_es_10, t0.`description_fr` AS description_fr_11, t0.`description_de` AS description_de_12, t0.`description_pt` AS description_pt_13, t0.`description_pl` AS description_pl_14, t0.`description_nl` AS description_nl_15, t0.`description_fi` AS description_fi_16, t0.`description_ua` AS description_ua_17, t0.`description_sv` AS description_sv_18, t0.`description_no` AS description_no_19, t0.`description_da` AS description_da_20, t0.`description_zh` AS description_zh_21, t0.`delivery_time` AS delivery_time_22, t0.`not_regular` AS not_regular_23, t0.`suspended` AS suspended_24, t0.`status` AS status_25, t0.`type` AS type_26, t0.`discount` AS discount_27, t0.`discount_date_start` AS discount_date_start_28, t0.`discount_date_end` AS discount_date_end_29, t0.`transcription` AS transcription_30, t0.`cost_delivery` AS cost_delivery_31, t0.`create_date` AS create_date_32, t0.`is_accepted` AS is_accepted_33, t0.`accepted_at` AS accepted_at_34, t0.`accept_state` AS accept_state_35, t0.`description_edit` AS description_edit_36, t0.`stated_at` AS stated_at_37, t0.`state` AS state_38, t0.`description_state` AS description_state_39, t0.`video` AS video_40, t0.`parser_address` AS parser_address_41, t0.`accessible` AS accessible_42, t0.`sound` AS sound_43, t0.`test_access` AS test_access_44, t0.`total_ideas` AS total_ideas_45, t0.`votes_submit` AS votes_submit_46, t0.`votes_stars` AS votes_stars_47, t0.`brand_link` AS brand_link_48, t0.`brand_logo` AS brand_logo_49, t0.`no_send_portl_message` AS no_send_portl_message_50, t0.user_id AS user_id_51, t0.country AS country_52, t0.filter AS filter_53 FROM `factory` t0 WHERE t0.`id` = ?
SELECT t0.`id` AS id_1, t0.`unid` AS unid_2, t0.`code` AS code_3, t0.`name` AS name_4, t0.`alternate_name` AS alternate_name_5, t0.`name_full` AS name_full_6, t0.`url` AS url_7, t0.`status` AS status_8, t0.`type` AS type_9, t0.`typeSet` AS typeSet_10, t0.`pc_as_m` AS pc_as_m_11, t0.`publish_date` AS publish_date_12, t0.`update_date` AS update_date_13, t0.`archive` AS archive_14, t0.`pr_min_euro` AS pr_min_euro_15, t0.`pr_min_euro_de` AS pr_min_euro_de_16, t0.`pr_min_euro_at` AS pr_min_euro_at_17, t0.`pr_min_euro_fi` AS pr_min_euro_fi_18, t0.`pr_min_euro_fr` AS pr_min_euro_fr_19, t0.`pr_min_euro_it` AS pr_min_euro_it_20, t0.`pr_min_euro_be` AS pr_min_euro_be_21, t0.`pr_min_euro_ie` AS pr_min_euro_ie_22, t0.`pr_min_euro_nl` AS pr_min_euro_nl_23, t0.`pr_min_euro_es` AS pr_min_euro_es_24, t0.`pr_min_rub` AS pr_min_rub_25, t0.`pr_min_rue` AS pr_min_rue_26, t0.`pr_min_gbp` AS pr_min_gbp_27, t0.`pr_min_gbe` AS pr_min_gbe_28, t0.`pr_min_usd` AS pr_min_usd_29, t0.`pr_min_use` AS pr_min_use_30, t0.`pr_min_f_usd` AS pr_min_f_usd_31, t0.`pr_min_f_use` AS pr_min_f_use_32, t0.`pr_min_chf` AS pr_min_chf_33, t0.`pr_min_che` AS pr_min_che_34, t0.`pr_min_sek` AS pr_min_sek_35, t0.`pr_min_see` AS pr_min_see_36, t0.`pr_min_dkk` AS pr_min_dkk_37, t0.`pr_min_dke` AS pr_min_dke_38, t0.`pr_min_nok` AS pr_min_nok_39, t0.`pr_min_noe` AS pr_min_noe_40, t0.`pr_min_pln` AS pr_min_pln_41, t0.`pr_min_ple` AS pr_min_ple_42, t0.`pr_min_cad` AS pr_min_cad_43, t0.`pr_min_cae` AS pr_min_cae_44, t0.`pr_min_f_cad` AS pr_min_f_cad_45, t0.`pr_min_f_cae` AS pr_min_f_cae_46, t0.`pr_min_ed` AS pr_min_ed_47, t0.`important` AS important_48, t0.`author` AS author_49, t0.`author_id` AS author_id_50, t0.`rating` AS rating_51, t0.`header` AS header_52, t0.`settings` AS settings_53, t0.`fids` AS fids_54, t0.`portal_unid` AS portal_unid_55, t0.`accepted_at` AS accepted_at_56, t0.`accept_state` AS accept_state_57, t0.`description_edit` AS description_edit_58, t0.`link_award` AS link_award_59, t0.`awards` AS awards_60, t0.`video` AS video_61, t0.`stated_at` AS stated_at_62, t0.`state` AS state_63, t0.`description_state` AS description_state_64, t0.`body_hide` AS body_hide_65, t0.`release_year` AS release_year_66, t0.`site` AS site_67, t0.`show_main` AS show_main_68, t0.`glue_url` AS glue_url_69, t0.`accessible` AS accessible_70, t0.`delivery_suspended` AS delivery_suspended_71, t0.`process` AS process_72, t0.`exhibition` AS exhibition_73, t0.`test_access` AS test_access_74, t0.`views` AS views_75, t0.`comment_unid` AS comment_unid_76, t0.`accesible_at` AS accesible_at_77, t0.`created_at` AS created_at_78, t0.`updated_at` AS updated_at_79, t0.factory AS factory_80, t0.category_price AS category_price_81, t82.`id` AS id_83, t82.`source` AS source_84, t82.`ru` AS ru_85, t82.`en` AS en_86, t82.`it` AS it_87, t82.`es` AS es_88, t82.`fr` AS fr_89, t82.`de` AS de_90, t82.`pl` AS pl_91, t82.`pt` AS pt_92, t82.`nl` AS nl_93, t82.`fi` AS fi_94, t82.`ua` AS ua_95, t82.`sv` AS sv_96, t82.`no` AS no_97, t82.`da` AS da_98, t82.`cn` AS cn_99, t82.`zh` AS zh_100, t82.`created_at` AS created_at_101, t82.`updated_at` AS updated_at_102, t82.email_body_id AS email_body_id_103, t82.publication_body_id AS publication_body_id_104, t82.static_page_body_id AS static_page_body_id_105, t82.collection_body_id AS collection_body_id_106, t82.trans_val_id AS trans_val_id_107, t82.exh_text_id AS exh_text_id_108, t82.exh_brand_text_id AS exh_brand_text_id_109, t82.exh_collection_text_id AS exh_collection_text_id_110, t82.filter_html_id AS filter_html_id_111, t112.`id` AS id_113, t112.`source` AS source_114, t112.`ru` AS ru_115, t112.`en` AS en_116, t112.`it` AS it_117, t112.`es` AS es_118, t112.`fr` AS fr_119, t112.`de` AS de_120, t112.`pl` AS pl_121, t112.`pt` AS pt_122, t112.`nl` AS nl_123, t112.`fi` AS fi_124, t112.`ua` AS ua_125, t112.`sv` AS sv_126, t112.`no` AS no_127, t112.`da` AS da_128, t112.`cn` AS cn_129, t112.`zh` AS zh_130, t112.`created_at` AS created_at_131, t112.`updated_at` AS updated_at_132, t112.static_page_title_id AS static_page_title_id_133, t112.static_page_keywords_id AS static_page_keywords_id_134, t112.static_page_description_id AS static_page_description_id_135, t112.collection_keywords_id AS collection_keywords_id_136, t112.collection_description_id AS collection_description_id_137, t112.blog_keywords_id AS blog_keywords_id_138, t112.blog_description_id AS blog_description_id_139, t112.exh_keywords_id AS exh_keywords_id_140, t112.exh_description_id AS exh_description_id_141, t142.`id` AS id_143, t142.`source` AS source_144, t142.`ru` AS ru_145, t142.`en` AS en_146, t142.`it` AS it_147, t142.`es` AS es_148, t142.`fr` AS fr_149, t142.`de` AS de_150, t142.`pl` AS pl_151, t142.`pt` AS pt_152, t142.`nl` AS nl_153, t142.`fi` AS fi_154, t142.`ua` AS ua_155, t142.`sv` AS sv_156, t142.`no` AS no_157, t142.`da` AS da_158, t142.`cn` AS cn_159, t142.`zh` AS zh_160, t142.`created_at` AS created_at_161, t142.`updated_at` AS updated_at_162, t142.static_page_title_id AS static_page_title_id_163, t142.static_page_keywords_id AS static_page_keywords_id_164, t142.static_page_description_id AS static_page_description_id_165, t142.collection_keywords_id AS collection_keywords_id_166, t142.collection_description_id AS collection_description_id_167, t142.blog_keywords_id AS blog_keywords_id_168, t142.blog_description_id AS blog_description_id_169, t142.exh_keywords_id AS exh_keywords_id_170, t142.exh_description_id AS exh_description_id_171 FROM `collection` t0 LEFT JOIN `locale_html` t82 ON t82.collection_body_id = t0.id LEFT JOIN `locale_meta` t112 ON t112.collection_keywords_id = t0.id LEFT JOIN `locale_meta` t142 ON t142.collection_description_id = t0.id WHERE t0.factory = ?
SELECT t0.`id` AS id_1, t0.`reviewId` AS reviewId_2, t0.`referenceId` AS referenceId_3, t0.`conversationId` AS conversationId_4, t0.`p_id` AS p_id_5, t0.`sku` AS sku_6, t0.`gtin` AS gtin_7, t0.`mpn` AS mpn_8, t0.`url` AS url_9, t0.`star` AS star_10, t0.`score` AS score_11, t0.`date` AS date_12, t0.`created_at` AS created_at_13, t0.`content` AS content_14, t0.`username` AS username_15, t0.`country` AS country_16, t0.`locale` AS locale_17, t0.`language` AS language_18, t0.`state` AS state_19, t0.`unid_theme` AS unid_theme_20, t0.`send_portal_date` AS send_portal_date_21, t0.`answer` AS answer_22, t0.`manager` AS manager_23, t0.`is_anonymous` AS is_anonymous_24, t0.`is_collection_review` AS is_collection_review_25, t0.article_id AS article_id_26, t0.collection_id AS collection_id_27, t0.order_id AS order_id_28, t0.user_id AS user_id_29 FROM `product_reviews_cache` t0 WHERE t0.collection_id IN (?)
SELECT f0_.`old_id` AS old_id_0, f1_.`name_single_en` AS name_single_en_1, f1_.`name_menu_en` AS name_menu_en_2 FROM `filters` f0_ LEFT JOIN `filter_pages` f1_ ON f0_.page_id = f1_.id LEFT JOIN `filter_groups` f2_ ON f0_.group_id = f2_.id WHERE f2_.`id` = 407 ORDER BY f0_.`sort` ASC
SELECT t0.`id` AS id_1, t0.`unid` AS unid_2, t0.`name` AS name_3, t0.`name_inv` AS name_inv_4, t0.`url` AS url_5, t0.`alternate_name` AS alternate_name_6, t0.`description_ru` AS description_ru_7, t0.`description_en` AS description_en_8, t0.`description_it` AS description_it_9, t0.`description_es` AS description_es_10, t0.`description_fr` AS description_fr_11, t0.`description_de` AS description_de_12, t0.`description_pt` AS description_pt_13, t0.`description_pl` AS description_pl_14, t0.`description_nl` AS description_nl_15, t0.`description_fi` AS description_fi_16, t0.`description_ua` AS description_ua_17, t0.`description_sv` AS description_sv_18, t0.`description_no` AS description_no_19, t0.`description_da` AS description_da_20, t0.`description_zh` AS description_zh_21, t0.`delivery_time` AS delivery_time_22, t0.`not_regular` AS not_regular_23, t0.`suspended` AS suspended_24, t0.`status` AS status_25, t0.`type` AS type_26, t0.`discount` AS discount_27, t0.`discount_date_start` AS discount_date_start_28, t0.`discount_date_end` AS discount_date_end_29, t0.`transcription` AS transcription_30, t0.`cost_delivery` AS cost_delivery_31, t0.`create_date` AS create_date_32, t0.`is_accepted` AS is_accepted_33, t0.`accepted_at` AS accepted_at_34, t0.`accept_state` AS accept_state_35, t0.`description_edit` AS description_edit_36, t0.`stated_at` AS stated_at_37, t0.`state` AS state_38, t0.`description_state` AS description_state_39, t0.`video` AS video_40, t0.`parser_address` AS parser_address_41, t0.`accessible` AS accessible_42, t0.`sound` AS sound_43, t0.`test_access` AS test_access_44, t0.`total_ideas` AS total_ideas_45, t0.`votes_submit` AS votes_submit_46, t0.`votes_stars` AS votes_stars_47, t0.`brand_link` AS brand_link_48, t0.`brand_logo` AS brand_logo_49, t0.`no_send_portl_message` AS no_send_portl_message_50, t0.user_id AS user_id_51, t0.country AS country_52, t0.filter AS filter_53 FROM `factory` t0 WHERE t0.`url` = ? LIMIT 1
SELECT t0.`id` AS id_1, t0.`unid` AS unid_2, t0.`code` AS code_3, t0.`name` AS name_4, t0.`alternate_name` AS alternate_name_5, t0.`name_full` AS name_full_6, t0.`url` AS url_7, t0.`status` AS status_8, t0.`type` AS type_9, t0.`typeSet` AS typeSet_10, t0.`pc_as_m` AS pc_as_m_11, t0.`publish_date` AS publish_date_12, t0.`update_date` AS update_date_13, t0.`archive` AS archive_14, t0.`pr_min_euro` AS pr_min_euro_15, t0.`pr_min_euro_de` AS pr_min_euro_de_16, t0.`pr_min_euro_at` AS pr_min_euro_at_17, t0.`pr_min_euro_fi` AS pr_min_euro_fi_18, t0.`pr_min_euro_fr` AS pr_min_euro_fr_19, t0.`pr_min_euro_it` AS pr_min_euro_it_20, t0.`pr_min_euro_be` AS pr_min_euro_be_21, t0.`pr_min_euro_ie` AS pr_min_euro_ie_22, t0.`pr_min_euro_nl` AS pr_min_euro_nl_23, t0.`pr_min_euro_es` AS pr_min_euro_es_24, t0.`pr_min_rub` AS pr_min_rub_25, t0.`pr_min_rue` AS pr_min_rue_26, t0.`pr_min_gbp` AS pr_min_gbp_27, t0.`pr_min_gbe` AS pr_min_gbe_28, t0.`pr_min_usd` AS pr_min_usd_29, t0.`pr_min_use` AS pr_min_use_30, t0.`pr_min_f_usd` AS pr_min_f_usd_31, t0.`pr_min_f_use` AS pr_min_f_use_32, t0.`pr_min_chf` AS pr_min_chf_33, t0.`pr_min_che` AS pr_min_che_34, t0.`pr_min_sek` AS pr_min_sek_35, t0.`pr_min_see` AS pr_min_see_36, t0.`pr_min_dkk` AS pr_min_dkk_37, t0.`pr_min_dke` AS pr_min_dke_38, t0.`pr_min_nok` AS pr_min_nok_39, t0.`pr_min_noe` AS pr_min_noe_40, t0.`pr_min_pln` AS pr_min_pln_41, t0.`pr_min_ple` AS pr_min_ple_42, t0.`pr_min_cad` AS pr_min_cad_43, t0.`pr_min_cae` AS pr_min_cae_44, t0.`pr_min_f_cad` AS pr_min_f_cad_45, t0.`pr_min_f_cae` AS pr_min_f_cae_46, t0.`pr_min_ed` AS pr_min_ed_47, t0.`important` AS important_48, t0.`author` AS author_49, t0.`author_id` AS author_id_50, t0.`rating` AS rating_51, t0.`header` AS header_52, t0.`settings` AS settings_53, t0.`fids` AS fids_54, t0.`portal_unid` AS portal_unid_55, t0.`accepted_at` AS accepted_at_56, t0.`accept_state` AS accept_state_57, t0.`description_edit` AS description_edit_58, t0.`link_award` AS link_award_59, t0.`awards` AS awards_60, t0.`video` AS video_61, t0.`stated_at` AS stated_at_62, t0.`state` AS state_63, t0.`description_state` AS description_state_64, t0.`body_hide` AS body_hide_65, t0.`release_year` AS release_year_66, t0.`site` AS site_67, t0.`show_main` AS show_main_68, t0.`glue_url` AS glue_url_69, t0.`accessible` AS accessible_70, t0.`delivery_suspended` AS delivery_suspended_71, t0.`process` AS process_72, t0.`exhibition` AS exhibition_73, t0.`test_access` AS test_access_74, t0.`views` AS views_75, t0.`comment_unid` AS comment_unid_76, t0.`accesible_at` AS accesible_at_77, t0.`created_at` AS created_at_78, t0.`updated_at` AS updated_at_79, t0.factory AS factory_80, t0.category_price AS category_price_81, t82.`id` AS id_83, t82.`source` AS source_84, t82.`ru` AS ru_85, t82.`en` AS en_86, t82.`it` AS it_87, t82.`es` AS es_88, t82.`fr` AS fr_89, t82.`de` AS de_90, t82.`pl` AS pl_91, t82.`pt` AS pt_92, t82.`nl` AS nl_93, t82.`fi` AS fi_94, t82.`ua` AS ua_95, t82.`sv` AS sv_96, t82.`no` AS no_97, t82.`da` AS da_98, t82.`cn` AS cn_99, t82.`zh` AS zh_100, t82.`created_at` AS created_at_101, t82.`updated_at` AS updated_at_102, t82.email_body_id AS email_body_id_103, t82.publication_body_id AS publication_body_id_104, t82.static_page_body_id AS static_page_body_id_105, t82.collection_body_id AS collection_body_id_106, t82.trans_val_id AS trans_val_id_107, t82.exh_text_id AS exh_text_id_108, t82.exh_brand_text_id AS exh_brand_text_id_109, t82.exh_collection_text_id AS exh_collection_text_id_110, t82.filter_html_id AS filter_html_id_111, t112.`id` AS id_113, t112.`source` AS source_114, t112.`ru` AS ru_115, t112.`en` AS en_116, t112.`it` AS it_117, t112.`es` AS es_118, t112.`fr` AS fr_119, t112.`de` AS de_120, t112.`pl` AS pl_121, t112.`pt` AS pt_122, t112.`nl` AS nl_123, t112.`fi` AS fi_124, t112.`ua` AS ua_125, t112.`sv` AS sv_126, t112.`no` AS no_127, t112.`da` AS da_128, t112.`cn` AS cn_129, t112.`zh` AS zh_130, t112.`created_at` AS created_at_131, t112.`updated_at` AS updated_at_132, t112.static_page_title_id AS static_page_title_id_133, t112.static_page_keywords_id AS static_page_keywords_id_134, t112.static_page_description_id AS static_page_description_id_135, t112.collection_keywords_id AS collection_keywords_id_136, t112.collection_description_id AS collection_description_id_137, t112.blog_keywords_id AS blog_keywords_id_138, t112.blog_description_id AS blog_description_id_139, t112.exh_keywords_id AS exh_keywords_id_140, t112.exh_description_id AS exh_description_id_141, t142.`id` AS id_143, t142.`source` AS source_144, t142.`ru` AS ru_145, t142.`en` AS en_146, t142.`it` AS it_147, t142.`es` AS es_148, t142.`fr` AS fr_149, t142.`de` AS de_150, t142.`pl` AS pl_151, t142.`pt` AS pt_152, t142.`nl` AS nl_153, t142.`fi` AS fi_154, t142.`ua` AS ua_155, t142.`sv` AS sv_156, t142.`no` AS no_157, t142.`da` AS da_158, t142.`cn` AS cn_159, t142.`zh` AS zh_160, t142.`created_at` AS created_at_161, t142.`updated_at` AS updated_at_162, t142.static_page_title_id AS static_page_title_id_163, t142.static_page_keywords_id AS static_page_keywords_id_164, t142.static_page_description_id AS static_page_description_id_165, t142.collection_keywords_id AS collection_keywords_id_166, t142.collection_description_id AS collection_description_id_167, t142.blog_keywords_id AS blog_keywords_id_168, t142.blog_description_id AS blog_description_id_169, t142.exh_keywords_id AS exh_keywords_id_170, t142.exh_description_id AS exh_description_id_171 FROM `collection` t0 LEFT JOIN `locale_html` t82 ON t82.collection_body_id = t0.id LEFT JOIN `locale_meta` t112 ON t112.collection_keywords_id = t0.id LEFT JOIN `locale_meta` t142 ON t142.collection_description_id = t0.id WHERE t0.factory = ?
SELECT t0.`id` AS id_1, t0.`reviewId` AS reviewId_2, t0.`referenceId` AS referenceId_3, t0.`conversationId` AS conversationId_4, t0.`p_id` AS p_id_5, t0.`sku` AS sku_6, t0.`gtin` AS gtin_7, t0.`mpn` AS mpn_8, t0.`url` AS url_9, t0.`star` AS star_10, t0.`score` AS score_11, t0.`date` AS date_12, t0.`created_at` AS created_at_13, t0.`content` AS content_14, t0.`username` AS username_15, t0.`country` AS country_16, t0.`locale` AS locale_17, t0.`language` AS language_18, t0.`state` AS state_19, t0.`unid_theme` AS unid_theme_20, t0.`send_portal_date` AS send_portal_date_21, t0.`answer` AS answer_22, t0.`manager` AS manager_23, t0.`is_anonymous` AS is_anonymous_24, t0.`is_collection_review` AS is_collection_review_25, t0.article_id AS article_id_26, t0.collection_id AS collection_id_27, t0.order_id AS order_id_28, t0.user_id AS user_id_29 FROM `product_reviews_cache` t0 WHERE t0.collection_id IN (?)
SELECT
    f2.id,
    f2.name,
    f2.old_command,
    f2.old_id,
    GROUP_CONCAT(f.id) AS ids,
    GROUP_CONCAT(f.old_id) AS old_ids
FROM
    `filters` f
LEFT JOIN filters f2 ON
    f.parent_id = f2.id
LEFT JOIN filter_params p ON
    f.param_id = p.id
WHERE
    f.parent_id IS NOT NULL AND p.is_enable = 1  AND p.show_menu != 0  
GROUP BY
    f.parent_id;
SELECT
    f2.id,
    f2.name,
    f2.old_command,
    f2.old_id,
    GROUP_CONCAT(f.id) AS ids,
    GROUP_CONCAT(f.old_id) AS old_ids
FROM
    `filters` f
LEFT JOIN filters f2 ON
    f.parent_id = f2.id
LEFT JOIN filter_params p ON
    f.param_id = p.id
WHERE
    f.parent_id IS NOT NULL AND p.is_enable = 1  AND p.show_menu != 0  
GROUP BY
    f.parent_id;
SELECT
    f2.id,
    f2.name,
    f2.old_command,
    f2.old_id,
    GROUP_CONCAT(f.id) AS ids,
    GROUP_CONCAT(f.old_id) AS old_ids
FROM
    `filters` f
LEFT JOIN filters f2 ON
    f.parent_id = f2.id
LEFT JOIN filter_params p ON
    f.param_id = p.id
WHERE
    f.parent_id IS NOT NULL AND p.is_enable = 1  AND p.show_menu != 0  
GROUP BY
    f.parent_id;
SELECT 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 v0_.`id` AS id_0, v0_.`token` AS token_1, v0_.`url` AS url_2, v0_.`title` AS title_3, v0_.`icon` AS icon_4, v0_.`visit_date` AS visit_date_5, v0_.`v_type` AS v_type_6, v0_.`v_object_id` AS v_object_id_7 FROM `visit` v0_ WHERE v0_.`token` = ? AND v0_.`url` = ? AND v0_.`url` <> '/.*catalog.*/' LIMIT 1
"START TRANSACTION"
INSERT INTO `visit` (`token`, `url`, `title`, `icon`, `visit_date`, `v_type`, `v_object_id`) VALUES (?, ?, ?, ?, ?, ?, ?)
"COMMIT"
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 c0_.`id` AS id_0, c0_.`url` AS url_1, c0_.`code` AS code_2, c0_.`name` AS name_3, c0_.`alternate_name` AS alternate_name_4, c0_.`name_full` AS name_full_5, f1_.`id` AS id_6, f1_.`url` AS url_7, f1_.`unid` AS unid_8, f2_.`id` AS id_9, f1_.`url` AS url_10, f1_.`name` AS name_11, (SELECT COUNT(p3_.`star`) AS sclr_13 FROM `product_reviews_cache` p3_ WHERE p3_.`sku` = c0_.`code`) AS sclr_12, (SELECT SUM(p4_.`star`) AS sclr_15 FROM `product_reviews_cache` p4_ WHERE p4_.`sku` = c0_.`code`) AS sclr_14 FROM `collection` c0_ INNER JOIN `factory` f1_ ON c0_.factory = f1_.id INNER JOIN `filters` f2_ ON f1_.filter = f2_.id INNER JOIN `list_country` l5_ ON f1_.country = l5_.id LEFT JOIN `locale_url` l6_ ON f2_.id = l6_.filter_id LEFT JOIN `filter_pages` f7_ ON f2_.page_id = f7_.id WHERE f1_.filter IS NOT NULL AND c0_.factory <> '' AND f1_.`status` = ? AND f1_.`id` NOT IN (?) AND (c0_.`test_access` IS NULL OR c0_.`test_access` = 0) AND (f1_.`test_access` IS NULL OR f1_.`test_access` = 0) AND c0_.`status` = ? AND c0_.`status` = ? AND f1_.`status` = ? ORDER BY c0_.`id` ASC
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 COUNT(c0_.`id`) AS sclr_0 FROM `collection` c0_ LEFT JOIN `factory` f1_ ON c0_.factory = f1_.id LEFT JOIN `article` a2_ ON c0_.id = a2_.collection WHERE c0_.factory <> '' AND f1_.`id` <> 99 AND f1_.`status` = ? AND c0_.`status` = ? AND c0_.`archive` <> 1 AND a2_.`price_euro` IS NOT NULL AND (c0_.`test_access` IS NULL OR c0_.`test_access` = 0) AND (f1_.`test_access` IS NULL OR f1_.`test_access` = 0) AND f1_.`id` IN (1255) GROUP BY c0_.`id` ORDER BY c0_.`name` ASC, c0_.`publish_date` 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	2.07 ms	SELECT f2.id, f2.name, f2.old_command, f2.old_id, GROUP_CONCAT(f.id) AS ids, GROUP_CONCAT(f.old_id) AS old_ids FROM `filters` f LEFT JOIN filters f2 ON f.parent_id = f2.id LEFT JOIN filter_params p ON f.param_id = p.id WHERE f.parent_id IS NOT NULL AND p.is_enable = 1 AND p.show_menu != 0 GROUP BY f.parent_id; Parameters: [] View formatted query View runnable query Explain query SELECT f2.id, f2.name, f2.old_command, f2.old_id, GROUP_CONCAT(f.id) AS ids, GROUP_CONCAT(f.old_id) AS old_ids FROM `filters` f LEFT JOIN filters f2 ON f.parent_id = f2.id LEFT JOIN filter_params p ON f.param_id = p.id WHERE f.parent_id IS NOT NULL AND p.is_enable = 1 AND p.show_menu != 0 GROUP BY f.parent_id; SELECT f2.id, f2.name, f2.old_command, f2.old_id, GROUP_CONCAT(f.id) AS ids, GROUP_CONCAT(f.old_id) AS old_ids FROM `filters` f LEFT JOIN filters f2 ON f.parent_id = f2.id LEFT JOIN filter_params p ON f.param_id = p.id WHERE f.parent_id IS NOT NULL AND p.is_enable = 1 AND p.show_menu != 0 GROUP BY f.parent_id;;
2	0.14 ms	SELECT f2.id, f2.name, f2.old_command, f2.old_id, GROUP_CONCAT(f.id) AS ids, GROUP_CONCAT(f.old_id) AS old_ids FROM `filters` f LEFT JOIN filters f2 ON f.parent_id = f2.id LEFT JOIN filter_params p ON f.param_id = p.id WHERE f.parent_id IS NOT NULL AND p.is_enable = 1 AND p.show_menu != 0 GROUP BY f.parent_id; Parameters: [] View formatted query View runnable query Explain query SELECT f2.id, f2.name, f2.old_command, f2.old_id, GROUP_CONCAT(f.id) AS ids, GROUP_CONCAT(f.old_id) AS old_ids FROM `filters` f LEFT JOIN filters f2 ON f.parent_id = f2.id LEFT JOIN filter_params p ON f.param_id = p.id WHERE f.parent_id IS NOT NULL AND p.is_enable = 1 AND p.show_menu != 0 GROUP BY f.parent_id; SELECT f2.id, f2.name, f2.old_command, f2.old_id, GROUP_CONCAT(f.id) AS ids, GROUP_CONCAT(f.old_id) AS old_ids FROM `filters` f LEFT JOIN filters f2 ON f.parent_id = f2.id LEFT JOIN filter_params p ON f.param_id = p.id WHERE f.parent_id IS NOT NULL AND p.is_enable = 1 AND p.show_menu != 0 GROUP BY f.parent_id;;
3	0.08 ms	SELECT f2.id, f2.name, f2.old_command, f2.old_id, GROUP_CONCAT(f.id) AS ids, GROUP_CONCAT(f.old_id) AS old_ids FROM `filters` f LEFT JOIN filters f2 ON f.parent_id = f2.id LEFT JOIN filter_params p ON f.param_id = p.id WHERE f.parent_id IS NOT NULL AND p.is_enable = 1 AND p.show_menu != 0 GROUP BY f.parent_id; Parameters: [] View formatted query View runnable query Explain query SELECT f2.id, f2.name, f2.old_command, f2.old_id, GROUP_CONCAT(f.id) AS ids, GROUP_CONCAT(f.old_id) AS old_ids FROM `filters` f LEFT JOIN filters f2 ON f.parent_id = f2.id LEFT JOIN filter_params p ON f.param_id = p.id WHERE f.parent_id IS NOT NULL AND p.is_enable = 1 AND p.show_menu != 0 GROUP BY f.parent_id; SELECT f2.id, f2.name, f2.old_command, f2.old_id, GROUP_CONCAT(f.id) AS ids, GROUP_CONCAT(f.old_id) AS old_ids FROM `filters` f LEFT JOIN filters f2 ON f.parent_id = f2.id LEFT JOIN filter_params p ON f.param_id = p.id WHERE f.parent_id IS NOT NULL AND p.is_enable = 1 AND p.show_menu != 0 GROUP BY f.parent_id;;
4	0.13 ms	SELECT i0_.`id` AS id_0 FROM `idea` i1_ INNER JOIN idea_interior i2_ ON i1_.id = i2_.idea_id INNER JOIN `interior` i0_ ON i0_.id = i2_.interior_id WHERE i1_.`token` = ? GROUP BY i0_.`id` Parameters: [`"86bc87cd665833aa5c0767bb4adbbbf9491f9706cca40c7c56b3393e654c98c8"`] View formatted query View runnable query Explain query SELECT i0_.`id` AS id_0 FROM `idea` i1_ INNER JOIN idea_interior i2_ ON i1_.id = i2_.idea_id INNER JOIN `interior` i0_ ON i0_.id = i2_.interior_id WHERE i1_.`token` = ? GROUP BY i0_.`id` SELECT i0_.`id` AS id_0 FROM `idea` i1_ INNER JOIN idea_interior i2_ ON i1_.id = i2_.idea_id INNER JOIN `interior` i0_ ON i0_.id = i2_.interior_id WHERE i1_.`token` = '86bc87cd665833aa5c0767bb4adbbbf9491f9706cca40c7c56b3393e654c98c8' GROUP BY i0_.`id`;
5	0.08 ms	SELECT f2.id, f2.name, f2.old_command, f2.old_id, GROUP_CONCAT(f.id) AS ids, GROUP_CONCAT(f.old_id) AS old_ids FROM `filters` f LEFT JOIN filters f2 ON f.parent_id = f2.id LEFT JOIN filter_params p ON f.param_id = p.id WHERE f.parent_id IS NOT NULL AND p.is_enable = 1 AND p.show_menu_advanced != 0 GROUP BY f.parent_id; Parameters: [] View formatted query View runnable query Explain query SELECT f2.id, f2.name, f2.old_command, f2.old_id, GROUP_CONCAT(f.id) AS ids, GROUP_CONCAT(f.old_id) AS old_ids FROM `filters` f LEFT JOIN filters f2 ON f.parent_id = f2.id LEFT JOIN filter_params p ON f.param_id = p.id WHERE f.parent_id IS NOT NULL AND p.is_enable = 1 AND p.show_menu_advanced != 0 GROUP BY f.parent_id; SELECT f2.id, f2.name, f2.old_command, f2.old_id, GROUP_CONCAT(f.id) AS ids, GROUP_CONCAT(f.old_id) AS old_ids FROM `filters` f LEFT JOIN filters f2 ON f.parent_id = f2.id LEFT JOIN filter_params p ON f.param_id = p.id WHERE f.parent_id IS NOT NULL AND p.is_enable = 1 AND p.show_menu_advanced != 0 GROUP BY f.parent_id;;
6	0.13 ms	SELECT t0.`id` AS id_1, t0.`unid` AS unid_2, t0.`name` AS name_3, t0.`name_inv` AS name_inv_4, t0.`url` AS url_5, t0.`alternate_name` AS alternate_name_6, t0.`description_ru` AS description_ru_7, t0.`description_en` AS description_en_8, t0.`description_it` AS description_it_9, t0.`description_es` AS description_es_10, t0.`description_fr` AS description_fr_11, t0.`description_de` AS description_de_12, t0.`description_pt` AS description_pt_13, t0.`description_pl` AS description_pl_14, t0.`description_nl` AS description_nl_15, t0.`description_fi` AS description_fi_16, t0.`description_ua` AS description_ua_17, t0.`description_sv` AS description_sv_18, t0.`description_no` AS description_no_19, t0.`description_da` AS description_da_20, t0.`description_zh` AS description_zh_21, t0.`delivery_time` AS delivery_time_22, t0.`not_regular` AS not_regular_23, t0.`suspended` AS suspended_24, t0.`status` AS status_25, t0.`type` AS type_26, t0.`discount` AS discount_27, t0.`discount_date_start` AS discount_date_start_28, t0.`discount_date_end` AS discount_date_end_29, t0.`transcription` AS transcription_30, t0.`cost_delivery` AS cost_delivery_31, t0.`create_date` AS create_date_32, t0.`is_accepted` AS is_accepted_33, t0.`accepted_at` AS accepted_at_34, t0.`accept_state` AS accept_state_35, t0.`description_edit` AS description_edit_36, t0.`stated_at` AS stated_at_37, t0.`state` AS state_38, t0.`description_state` AS description_state_39, t0.`video` AS video_40, t0.`parser_address` AS parser_address_41, t0.`accessible` AS accessible_42, t0.`sound` AS sound_43, t0.`test_access` AS test_access_44, t0.`total_ideas` AS total_ideas_45, t0.`votes_submit` AS votes_submit_46, t0.`votes_stars` AS votes_stars_47, t0.`brand_link` AS brand_link_48, t0.`brand_logo` AS brand_logo_49, t0.`no_send_portl_message` AS no_send_portl_message_50, t0.user_id AS user_id_51, t0.country AS country_52, t0.filter AS filter_53 FROM `factory` t0 WHERE t0.`id` = ? Parameters: [`1255`] View formatted query View runnable query Explain query SELECT t0.`id` AS id_1, t0.`unid` AS unid_2, t0.`name` AS name_3, t0.`name_inv` AS name_inv_4, t0.`url` AS url_5, t0.`alternate_name` AS alternate_name_6, t0.`description_ru` AS description_ru_7, t0.`description_en` AS description_en_8, t0.`description_it` AS description_it_9, t0.`description_es` AS description_es_10, t0.`description_fr` AS description_fr_11, t0.`description_de` AS description_de_12, t0.`description_pt` AS description_pt_13, t0.`description_pl` AS description_pl_14, t0.`description_nl` AS description_nl_15, t0.`description_fi` AS description_fi_16, t0.`description_ua` AS description_ua_17, t0.`description_sv` AS description_sv_18, t0.`description_no` AS description_no_19, t0.`description_da` AS description_da_20, t0.`description_zh` AS description_zh_21, t0.`delivery_time` AS delivery_time_22, t0.`not_regular` AS not_regular_23, t0.`suspended` AS suspended_24, t0.`status` AS status_25, t0.`type` AS type_26, t0.`discount` AS discount_27, t0.`discount_date_start` AS discount_date_start_28, t0.`discount_date_end` AS discount_date_end_29, t0.`transcription` AS transcription_30, t0.`cost_delivery` AS cost_delivery_31, t0.`create_date` AS create_date_32, t0.`is_accepted` AS is_accepted_33, t0.`accepted_at` AS accepted_at_34, t0.`accept_state` AS accept_state_35, t0.`description_edit` AS description_edit_36, t0.`stated_at` AS stated_at_37, t0.`state` AS state_38, t0.`description_state` AS description_state_39, t0.`video` AS video_40, t0.`parser_address` AS parser_address_41, t0.`accessible` AS accessible_42, t0.`sound` AS sound_43, t0.`test_access` AS test_access_44, t0.`total_ideas` AS total_ideas_45, t0.`votes_submit` AS votes_submit_46, t0.`votes_stars` AS votes_stars_47, t0.`brand_link` AS brand_link_48, t0.`brand_logo` AS brand_logo_49, t0.`no_send_portl_message` AS no_send_portl_message_50, t0.user_id AS user_id_51, t0.country AS country_52, t0.filter AS filter_53 FROM `factory` t0 WHERE t0.`id` = ? SELECT t0.`id` AS id_1, t0.`unid` AS unid_2, t0.`name` AS name_3, t0.`name_inv` AS name_inv_4, t0.`url` AS url_5, t0.`alternate_name` AS alternate_name_6, t0.`description_ru` AS description_ru_7, t0.`description_en` AS description_en_8, t0.`description_it` AS description_it_9, t0.`description_es` AS description_es_10, t0.`description_fr` AS description_fr_11, t0.`description_de` AS description_de_12, t0.`description_pt` AS description_pt_13, t0.`description_pl` AS description_pl_14, t0.`description_nl` AS description_nl_15, t0.`description_fi` AS description_fi_16, t0.`description_ua` AS description_ua_17, t0.`description_sv` AS description_sv_18, t0.`description_no` AS description_no_19, t0.`description_da` AS description_da_20, t0.`description_zh` AS description_zh_21, t0.`delivery_time` AS delivery_time_22, t0.`not_regular` AS not_regular_23, t0.`suspended` AS suspended_24, t0.`status` AS status_25, t0.`type` AS type_26, t0.`discount` AS discount_27, t0.`discount_date_start` AS discount_date_start_28, t0.`discount_date_end` AS discount_date_end_29, t0.`transcription` AS transcription_30, t0.`cost_delivery` AS cost_delivery_31, t0.`create_date` AS create_date_32, t0.`is_accepted` AS is_accepted_33, t0.`accepted_at` AS accepted_at_34, t0.`accept_state` AS accept_state_35, t0.`description_edit` AS description_edit_36, t0.`stated_at` AS stated_at_37, t0.`state` AS state_38, t0.`description_state` AS description_state_39, t0.`video` AS video_40, t0.`parser_address` AS parser_address_41, t0.`accessible` AS accessible_42, t0.`sound` AS sound_43, t0.`test_access` AS test_access_44, t0.`total_ideas` AS total_ideas_45, t0.`votes_submit` AS votes_submit_46, t0.`votes_stars` AS votes_stars_47, t0.`brand_link` AS brand_link_48, t0.`brand_logo` AS brand_logo_49, t0.`no_send_portl_message` AS no_send_portl_message_50, t0.user_id AS user_id_51, t0.country AS country_52, t0.filter AS filter_53 FROM `factory` t0 WHERE t0.`id` = 1255;
7	0.61 ms	SELECT t0.`id` AS id_1, t0.`unid` AS unid_2, t0.`code` AS code_3, t0.`name` AS name_4, t0.`alternate_name` AS alternate_name_5, t0.`name_full` AS name_full_6, t0.`url` AS url_7, t0.`status` AS status_8, t0.`type` AS type_9, t0.`typeSet` AS typeSet_10, t0.`pc_as_m` AS pc_as_m_11, t0.`publish_date` AS publish_date_12, t0.`update_date` AS update_date_13, t0.`archive` AS archive_14, t0.`pr_min_euro` AS pr_min_euro_15, t0.`pr_min_euro_de` AS pr_min_euro_de_16, t0.`pr_min_euro_at` AS pr_min_euro_at_17, t0.`pr_min_euro_fi` AS pr_min_euro_fi_18, t0.`pr_min_euro_fr` AS pr_min_euro_fr_19, t0.`pr_min_euro_it` AS pr_min_euro_it_20, t0.`pr_min_euro_be` AS pr_min_euro_be_21, t0.`pr_min_euro_ie` AS pr_min_euro_ie_22, t0.`pr_min_euro_nl` AS pr_min_euro_nl_23, t0.`pr_min_euro_es` AS pr_min_euro_es_24, t0.`pr_min_rub` AS pr_min_rub_25, t0.`pr_min_rue` AS pr_min_rue_26, t0.`pr_min_gbp` AS pr_min_gbp_27, t0.`pr_min_gbe` AS pr_min_gbe_28, t0.`pr_min_usd` AS pr_min_usd_29, t0.`pr_min_use` AS pr_min_use_30, t0.`pr_min_f_usd` AS pr_min_f_usd_31, t0.`pr_min_f_use` AS pr_min_f_use_32, t0.`pr_min_chf` AS pr_min_chf_33, t0.`pr_min_che` AS pr_min_che_34, t0.`pr_min_sek` AS pr_min_sek_35, t0.`pr_min_see` AS pr_min_see_36, t0.`pr_min_dkk` AS pr_min_dkk_37, t0.`pr_min_dke` AS pr_min_dke_38, t0.`pr_min_nok` AS pr_min_nok_39, t0.`pr_min_noe` AS pr_min_noe_40, t0.`pr_min_pln` AS pr_min_pln_41, t0.`pr_min_ple` AS pr_min_ple_42, t0.`pr_min_cad` AS pr_min_cad_43, t0.`pr_min_cae` AS pr_min_cae_44, t0.`pr_min_f_cad` AS pr_min_f_cad_45, t0.`pr_min_f_cae` AS pr_min_f_cae_46, t0.`pr_min_ed` AS pr_min_ed_47, t0.`important` AS important_48, t0.`author` AS author_49, t0.`author_id` AS author_id_50, t0.`rating` AS rating_51, t0.`header` AS header_52, t0.`settings` AS settings_53, t0.`fids` AS fids_54, t0.`portal_unid` AS portal_unid_55, t0.`accepted_at` AS accepted_at_56, t0.`accept_state` AS accept_state_57, t0.`description_edit` AS description_edit_58, t0.`link_award` AS link_award_59, t0.`awards` AS awards_60, t0.`video` AS video_61, t0.`stated_at` AS stated_at_62, t0.`state` AS state_63, t0.`description_state` AS description_state_64, t0.`body_hide` AS body_hide_65, t0.`release_year` AS release_year_66, t0.`site` AS site_67, t0.`show_main` AS show_main_68, t0.`glue_url` AS glue_url_69, t0.`accessible` AS accessible_70, t0.`delivery_suspended` AS delivery_suspended_71, t0.`process` AS process_72, t0.`exhibition` AS exhibition_73, t0.`test_access` AS test_access_74, t0.`views` AS views_75, t0.`comment_unid` AS comment_unid_76, t0.`accesible_at` AS accesible_at_77, t0.`created_at` AS created_at_78, t0.`updated_at` AS updated_at_79, t0.factory AS factory_80, t0.category_price AS category_price_81, t82.`id` AS id_83, t82.`source` AS source_84, t82.`ru` AS ru_85, t82.`en` AS en_86, t82.`it` AS it_87, t82.`es` AS es_88, t82.`fr` AS fr_89, t82.`de` AS de_90, t82.`pl` AS pl_91, t82.`pt` AS pt_92, t82.`nl` AS nl_93, t82.`fi` AS fi_94, t82.`ua` AS ua_95, t82.`sv` AS sv_96, t82.`no` AS no_97, t82.`da` AS da_98, t82.`cn` AS cn_99, t82.`zh` AS zh_100, t82.`created_at` AS created_at_101, t82.`updated_at` AS updated_at_102, t82.email_body_id AS email_body_id_103, t82.publication_body_id AS publication_body_id_104, t82.static_page_body_id AS static_page_body_id_105, t82.collection_body_id AS collection_body_id_106, t82.trans_val_id AS trans_val_id_107, t82.exh_text_id AS exh_text_id_108, t82.exh_brand_text_id AS exh_brand_text_id_109, t82.exh_collection_text_id AS exh_collection_text_id_110, t82.filter_html_id AS filter_html_id_111, t112.`id` AS id_113, t112.`source` AS source_114, t112.`ru` AS ru_115, t112.`en` AS en_116, t112.`it` AS it_117, t112.`es` AS es_118, t112.`fr` AS fr_119, t112.`de` AS de_120, t112.`pl` AS pl_121, t112.`pt` AS pt_122, t112.`nl` AS nl_123, t112.`fi` AS fi_124, t112.`ua` AS ua_125, t112.`sv` AS sv_126, t112.`no` AS no_127, t112.`da` AS da_128, t112.`cn` AS cn_129, t112.`zh` AS zh_130, t112.`created_at` AS created_at_131, t112.`updated_at` AS updated_at_132, t112.static_page_title_id AS static_page_title_id_133, t112.static_page_keywords_id AS static_page_keywords_id_134, t112.static_page_description_id AS static_page_description_id_135, t112.collection_keywords_id AS collection_keywords_id_136, t112.collection_description_id AS collection_description_id_137, t112.blog_keywords_id AS blog_keywords_id_138, t112.blog_description_id AS blog_description_id_139, t112.exh_keywords_id AS exh_keywords_id_140, t112.exh_description_id AS exh_description_id_141, t142.`id` AS id_143, t142.`source` AS source_144, t142.`ru` AS ru_145, t142.`en` AS en_146, t142.`it` AS it_147, t142.`es` AS es_148, t142.`fr` AS fr_149, t142.`de` AS de_150, t142.`pl` AS pl_151, t142.`pt` AS pt_152, t142.`nl` AS nl_153, t142.`fi` AS fi_154, t142.`ua` AS ua_155, t142.`sv` AS sv_156, t142.`no` AS no_157, t142.`da` AS da_158, t142.`cn` AS cn_159, t142.`zh` AS zh_160, t142.`created_at` AS created_at_161, t142.`updated_at` AS updated_at_162, t142.static_page_title_id AS static_page_title_id_163, t142.static_page_keywords_id AS static_page_keywords_id_164, t142.static_page_description_id AS static_page_description_id_165, t142.collection_keywords_id AS collection_keywords_id_166, t142.collection_description_id AS collection_description_id_167, t142.blog_keywords_id AS blog_keywords_id_168, t142.blog_description_id AS blog_description_id_169, t142.exh_keywords_id AS exh_keywords_id_170, t142.exh_description_id AS exh_description_id_171 FROM `collection` t0 LEFT JOIN `locale_html` t82 ON t82.collection_body_id = t0.id LEFT JOIN `locale_meta` t112 ON t112.collection_keywords_id = t0.id LEFT JOIN `locale_meta` t142 ON t142.collection_description_id = t0.id WHERE t0.factory = ? Parameters: [`1255`] View formatted query View runnable query Explain query SELECT t0.`id` AS id_1, t0.`unid` AS unid_2, t0.`code` AS code_3, t0.`name` AS name_4, t0.`alternate_name` AS alternate_name_5, t0.`name_full` AS name_full_6, t0.`url` AS url_7, t0.`status` AS status_8, t0.`type` AS type_9, t0.`typeSet` AS typeSet_10, t0.`pc_as_m` AS pc_as_m_11, t0.`publish_date` AS publish_date_12, t0.`update_date` AS update_date_13, t0.`archive` AS archive_14, t0.`pr_min_euro` AS pr_min_euro_15, t0.`pr_min_euro_de` AS pr_min_euro_de_16, t0.`pr_min_euro_at` AS pr_min_euro_at_17, t0.`pr_min_euro_fi` AS pr_min_euro_fi_18, t0.`pr_min_euro_fr` AS pr_min_euro_fr_19, t0.`pr_min_euro_it` AS pr_min_euro_it_20, t0.`pr_min_euro_be` AS pr_min_euro_be_21, t0.`pr_min_euro_ie` AS pr_min_euro_ie_22, t0.`pr_min_euro_nl` AS pr_min_euro_nl_23, t0.`pr_min_euro_es` AS pr_min_euro_es_24, t0.`pr_min_rub` AS pr_min_rub_25, t0.`pr_min_rue` AS pr_min_rue_26, t0.`pr_min_gbp` AS pr_min_gbp_27, t0.`pr_min_gbe` AS pr_min_gbe_28, t0.`pr_min_usd` AS pr_min_usd_29, t0.`pr_min_use` AS pr_min_use_30, t0.`pr_min_f_usd` AS pr_min_f_usd_31, t0.`pr_min_f_use` AS pr_min_f_use_32, t0.`pr_min_chf` AS pr_min_chf_33, t0.`pr_min_che` AS pr_min_che_34, t0.`pr_min_sek` AS pr_min_sek_35, t0.`pr_min_see` AS pr_min_see_36, t0.`pr_min_dkk` AS pr_min_dkk_37, t0.`pr_min_dke` AS pr_min_dke_38, t0.`pr_min_nok` AS pr_min_nok_39, t0.`pr_min_noe` AS pr_min_noe_40, t0.`pr_min_pln` AS pr_min_pln_41, t0.`pr_min_ple` AS pr_min_ple_42, t0.`pr_min_cad` AS pr_min_cad_43, t0.`pr_min_cae` AS pr_min_cae_44, t0.`pr_min_f_cad` AS pr_min_f_cad_45, t0.`pr_min_f_cae` AS pr_min_f_cae_46, t0.`pr_min_ed` AS pr_min_ed_47, t0.`important` AS important_48, t0.`author` AS author_49, t0.`author_id` AS author_id_50, t0.`rating` AS rating_51, t0.`header` AS header_52, t0.`settings` AS settings_53, t0.`fids` AS fids_54, t0.`portal_unid` AS portal_unid_55, t0.`accepted_at` AS accepted_at_56, t0.`accept_state` AS accept_state_57, t0.`description_edit` AS description_edit_58, t0.`link_award` AS link_award_59, t0.`awards` AS awards_60, t0.`video` AS video_61, t0.`stated_at` AS stated_at_62, t0.`state` AS state_63, t0.`description_state` AS description_state_64, t0.`body_hide` AS body_hide_65, t0.`release_year` AS release_year_66, t0.`site` AS site_67, t0.`show_main` AS show_main_68, t0.`glue_url` AS glue_url_69, t0.`accessible` AS accessible_70, t0.`delivery_suspended` AS delivery_suspended_71, t0.`process` AS process_72, t0.`exhibition` AS exhibition_73, t0.`test_access` AS test_access_74, t0.`views` AS views_75, t0.`comment_unid` AS comment_unid_76, t0.`accesible_at` AS accesible_at_77, t0.`created_at` AS created_at_78, t0.`updated_at` AS updated_at_79, t0.factory AS factory_80, t0.category_price AS category_price_81, t82.`id` AS id_83, t82.`source` AS source_84, t82.`ru` AS ru_85, t82.`en` AS en_86, t82.`it` AS it_87, t82.`es` AS es_88, t82.`fr` AS fr_89, t82.`de` AS de_90, t82.`pl` AS pl_91, t82.`pt` AS pt_92, t82.`nl` AS nl_93, t82.`fi` AS fi_94, t82.`ua` AS ua_95, t82.`sv` AS sv_96, t82.`no` AS no_97, t82.`da` AS da_98, t82.`cn` AS cn_99, t82.`zh` AS zh_100, t82.`created_at` AS created_at_101, t82.`updated_at` AS updated_at_102, t82.email_body_id AS email_body_id_103, t82.publication_body_id AS publication_body_id_104, t82.static_page_body_id AS static_page_body_id_105, t82.collection_body_id AS collection_body_id_106, t82.trans_val_id AS trans_val_id_107, t82.exh_text_id AS exh_text_id_108, t82.exh_brand_text_id AS exh_brand_text_id_109, t82.exh_collection_text_id AS exh_collection_text_id_110, t82.filter_html_id AS filter_html_id_111, t112.`id` AS id_113, t112.`source` AS source_114, t112.`ru` AS ru_115, t112.`en` AS en_116, t112.`it` AS it_117, t112.`es` AS es_118, t112.`fr` AS fr_119, t112.`de` AS de_120, t112.`pl` AS pl_121, t112.`pt` AS pt_122, t112.`nl` AS nl_123, t112.`fi` AS fi_124, t112.`ua` AS ua_125, t112.`sv` AS sv_126, t112.`no` AS no_127, t112.`da` AS da_128, t112.`cn` AS cn_129, t112.`zh` AS zh_130, t112.`created_at` AS created_at_131, t112.`updated_at` AS updated_at_132, t112.static_page_title_id AS static_page_title_id_133, t112.static_page_keywords_id AS static_page_keywords_id_134, t112.static_page_description_id AS static_page_description_id_135, t112.collection_keywords_id AS collection_keywords_id_136, t112.collection_description_id AS collection_description_id_137, t112.blog_keywords_id AS blog_keywords_id_138, t112.blog_description_id AS blog_description_id_139, t112.exh_keywords_id AS exh_keywords_id_140, t112.exh_description_id AS exh_description_id_141, t142.`id` AS id_143, t142.`source` AS source_144, t142.`ru` AS ru_145, t142.`en` AS en_146, t142.`it` AS it_147, t142.`es` AS es_148, t142.`fr` AS fr_149, t142.`de` AS de_150, t142.`pl` AS pl_151, t142.`pt` AS pt_152, t142.`nl` AS nl_153, t142.`fi` AS fi_154, t142.`ua` AS ua_155, t142.`sv` AS sv_156, t142.`no` AS no_157, t142.`da` AS da_158, t142.`cn` AS cn_159, t142.`zh` AS zh_160, t142.`created_at` AS created_at_161, t142.`updated_at` AS updated_at_162, t142.static_page_title_id AS static_page_title_id_163, t142.static_page_keywords_id AS static_page_keywords_id_164, t142.static_page_description_id AS static_page_description_id_165, t142.collection_keywords_id AS collection_keywords_id_166, t142.collection_description_id AS collection_description_id_167, t142.blog_keywords_id AS blog_keywords_id_168, t142.blog_description_id AS blog_description_id_169, t142.exh_keywords_id AS exh_keywords_id_170, t142.exh_description_id AS exh_description_id_171 FROM `collection` t0 LEFT JOIN `locale_html` t82 ON t82.collection_body_id = t0.id LEFT JOIN `locale_meta` t112 ON t112.collection_keywords_id = t0.id LEFT JOIN `locale_meta` t142 ON t142.collection_description_id = t0.id WHERE t0.factory = ? SELECT t0.`id` AS id_1, t0.`unid` AS unid_2, t0.`code` AS code_3, t0.`name` AS name_4, t0.`alternate_name` AS alternate_name_5, t0.`name_full` AS name_full_6, t0.`url` AS url_7, t0.`status` AS status_8, t0.`type` AS type_9, t0.`typeSet` AS typeSet_10, t0.`pc_as_m` AS pc_as_m_11, t0.`publish_date` AS publish_date_12, t0.`update_date` AS update_date_13, t0.`archive` AS archive_14, t0.`pr_min_euro` AS pr_min_euro_15, t0.`pr_min_euro_de` AS pr_min_euro_de_16, t0.`pr_min_euro_at` AS pr_min_euro_at_17, t0.`pr_min_euro_fi` AS pr_min_euro_fi_18, t0.`pr_min_euro_fr` AS pr_min_euro_fr_19, t0.`pr_min_euro_it` AS pr_min_euro_it_20, t0.`pr_min_euro_be` AS pr_min_euro_be_21, t0.`pr_min_euro_ie` AS pr_min_euro_ie_22, t0.`pr_min_euro_nl` AS pr_min_euro_nl_23, t0.`pr_min_euro_es` AS pr_min_euro_es_24, t0.`pr_min_rub` AS pr_min_rub_25, t0.`pr_min_rue` AS pr_min_rue_26, t0.`pr_min_gbp` AS pr_min_gbp_27, t0.`pr_min_gbe` AS pr_min_gbe_28, t0.`pr_min_usd` AS pr_min_usd_29, t0.`pr_min_use` AS pr_min_use_30, t0.`pr_min_f_usd` AS pr_min_f_usd_31, t0.`pr_min_f_use` AS pr_min_f_use_32, t0.`pr_min_chf` AS pr_min_chf_33, t0.`pr_min_che` AS pr_min_che_34, t0.`pr_min_sek` AS pr_min_sek_35, t0.`pr_min_see` AS pr_min_see_36, t0.`pr_min_dkk` AS pr_min_dkk_37, t0.`pr_min_dke` AS pr_min_dke_38, t0.`pr_min_nok` AS pr_min_nok_39, t0.`pr_min_noe` AS pr_min_noe_40, t0.`pr_min_pln` AS pr_min_pln_41, t0.`pr_min_ple` AS pr_min_ple_42, t0.`pr_min_cad` AS pr_min_cad_43, t0.`pr_min_cae` AS pr_min_cae_44, t0.`pr_min_f_cad` AS pr_min_f_cad_45, t0.`pr_min_f_cae` AS pr_min_f_cae_46, t0.`pr_min_ed` AS pr_min_ed_47, t0.`important` AS important_48, t0.`author` AS author_49, t0.`author_id` AS author_id_50, t0.`rating` AS rating_51, t0.`header` AS header_52, t0.`settings` AS settings_53, t0.`fids` AS fids_54, t0.`portal_unid` AS portal_unid_55, t0.`accepted_at` AS accepted_at_56, t0.`accept_state` AS accept_state_57, t0.`description_edit` AS description_edit_58, t0.`link_award` AS link_award_59, t0.`awards` AS awards_60, t0.`video` AS video_61, t0.`stated_at` AS stated_at_62, t0.`state` AS state_63, t0.`description_state` AS description_state_64, t0.`body_hide` AS body_hide_65, t0.`release_year` AS release_year_66, t0.`site` AS site_67, t0.`show_main` AS show_main_68, t0.`glue_url` AS glue_url_69, t0.`accessible` AS accessible_70, t0.`delivery_suspended` AS delivery_suspended_71, t0.`process` AS process_72, t0.`exhibition` AS exhibition_73, t0.`test_access` AS test_access_74, t0.`views` AS views_75, t0.`comment_unid` AS comment_unid_76, t0.`accesible_at` AS accesible_at_77, t0.`created_at` AS created_at_78, t0.`updated_at` AS updated_at_79, t0.factory AS factory_80, t0.category_price AS category_price_81, t82.`id` AS id_83, t82.`source` AS source_84, t82.`ru` AS ru_85, t82.`en` AS en_86, t82.`it` AS it_87, t82.`es` AS es_88, t82.`fr` AS fr_89, t82.`de` AS de_90, t82.`pl` AS pl_91, t82.`pt` AS pt_92, t82.`nl` AS nl_93, t82.`fi` AS fi_94, t82.`ua` AS ua_95, t82.`sv` AS sv_96, t82.`no` AS no_97, t82.`da` AS da_98, t82.`cn` AS cn_99, t82.`zh` AS zh_100, t82.`created_at` AS created_at_101, t82.`updated_at` AS updated_at_102, t82.email_body_id AS email_body_id_103, t82.publication_body_id AS publication_body_id_104, t82.static_page_body_id AS static_page_body_id_105, t82.collection_body_id AS collection_body_id_106, t82.trans_val_id AS trans_val_id_107, t82.exh_text_id AS exh_text_id_108, t82.exh_brand_text_id AS exh_brand_text_id_109, t82.exh_collection_text_id AS exh_collection_text_id_110, t82.filter_html_id AS filter_html_id_111, t112.`id` AS id_113, t112.`source` AS source_114, t112.`ru` AS ru_115, t112.`en` AS en_116, t112.`it` AS it_117, t112.`es` AS es_118, t112.`fr` AS fr_119, t112.`de` AS de_120, t112.`pl` AS pl_121, t112.`pt` AS pt_122, t112.`nl` AS nl_123, t112.`fi` AS fi_124, t112.`ua` AS ua_125, t112.`sv` AS sv_126, t112.`no` AS no_127, t112.`da` AS da_128, t112.`cn` AS cn_129, t112.`zh` AS zh_130, t112.`created_at` AS created_at_131, t112.`updated_at` AS updated_at_132, t112.static_page_title_id AS static_page_title_id_133, t112.static_page_keywords_id AS static_page_keywords_id_134, t112.static_page_description_id AS static_page_description_id_135, t112.collection_keywords_id AS collection_keywords_id_136, t112.collection_description_id AS collection_description_id_137, t112.blog_keywords_id AS blog_keywords_id_138, t112.blog_description_id AS blog_description_id_139, t112.exh_keywords_id AS exh_keywords_id_140, t112.exh_description_id AS exh_description_id_141, t142.`id` AS id_143, t142.`source` AS source_144, t142.`ru` AS ru_145, t142.`en` AS en_146, t142.`it` AS it_147, t142.`es` AS es_148, t142.`fr` AS fr_149, t142.`de` AS de_150, t142.`pl` AS pl_151, t142.`pt` AS pt_152, t142.`nl` AS nl_153, t142.`fi` AS fi_154, t142.`ua` AS ua_155, t142.`sv` AS sv_156, t142.`no` AS no_157, t142.`da` AS da_158, t142.`cn` AS cn_159, t142.`zh` AS zh_160, t142.`created_at` AS created_at_161, t142.`updated_at` AS updated_at_162, t142.static_page_title_id AS static_page_title_id_163, t142.static_page_keywords_id AS static_page_keywords_id_164, t142.static_page_description_id AS static_page_description_id_165, t142.collection_keywords_id AS collection_keywords_id_166, t142.collection_description_id AS collection_description_id_167, t142.blog_keywords_id AS blog_keywords_id_168, t142.blog_description_id AS blog_description_id_169, t142.exh_keywords_id AS exh_keywords_id_170, t142.exh_description_id AS exh_description_id_171 FROM `collection` t0 LEFT JOIN `locale_html` t82 ON t82.collection_body_id = t0.id LEFT JOIN `locale_meta` t112 ON t112.collection_keywords_id = t0.id LEFT JOIN `locale_meta` t142 ON t142.collection_description_id = t0.id WHERE t0.factory = 1255;
8	0.39 ms	SELECT t0.`id` AS id_1, t0.`reviewId` AS reviewId_2, t0.`referenceId` AS referenceId_3, t0.`conversationId` AS conversationId_4, t0.`p_id` AS p_id_5, t0.`sku` AS sku_6, t0.`gtin` AS gtin_7, t0.`mpn` AS mpn_8, t0.`url` AS url_9, t0.`star` AS star_10, t0.`score` AS score_11, t0.`date` AS date_12, t0.`created_at` AS created_at_13, t0.`content` AS content_14, t0.`username` AS username_15, t0.`country` AS country_16, t0.`locale` AS locale_17, t0.`language` AS language_18, t0.`state` AS state_19, t0.`unid_theme` AS unid_theme_20, t0.`send_portal_date` AS send_portal_date_21, t0.`answer` AS answer_22, t0.`manager` AS manager_23, t0.`is_anonymous` AS is_anonymous_24, t0.`is_collection_review` AS is_collection_review_25, t0.article_id AS article_id_26, t0.collection_id AS collection_id_27, t0.order_id AS order_id_28, t0.user_id AS user_id_29 FROM `product_reviews_cache` t0 WHERE t0.collection_id IN (?) Parameters: [[ 212913 374992 1618573 1618574 1618575 3245532 3245547 3245570 3245571 3245572 3245872 3245873 3245874 3245875 3245892 3246101 3246383 3246384 3246519 3246520 3246521 3246552 3246566 3246567 3246659 3246661 3246710 3246864 3247094 3247095 3247180 3247201 3247260 3247430 3247680 3248046 3248055 3248263 3248353 3248476 3248484 3248780 3248789 3248941 3249011 3249048 3249061 3249300 3249608 3249784 3249821 3249826 3249894 3250276 3251980 3252022 3252025 3255199 3255367 3255370 3255373 3255376 3255406 3255409 3255442 3255541 3256153 ]] View formatted query View runnable query Explain query SELECT t0.`id` AS id_1, t0.`reviewId` AS reviewId_2, t0.`referenceId` AS referenceId_3, t0.`conversationId` AS conversationId_4, t0.`p_id` AS p_id_5, t0.`sku` AS sku_6, t0.`gtin` AS gtin_7, t0.`mpn` AS mpn_8, t0.`url` AS url_9, t0.`star` AS star_10, t0.`score` AS score_11, t0.`date` AS date_12, t0.`created_at` AS created_at_13, t0.`content` AS content_14, t0.`username` AS username_15, t0.`country` AS country_16, t0.`locale` AS locale_17, t0.`language` AS language_18, t0.`state` AS state_19, t0.`unid_theme` AS unid_theme_20, t0.`send_portal_date` AS send_portal_date_21, t0.`answer` AS answer_22, t0.`manager` AS manager_23, t0.`is_anonymous` AS is_anonymous_24, t0.`is_collection_review` AS is_collection_review_25, t0.article_id AS article_id_26, t0.collection_id AS collection_id_27, t0.order_id AS order_id_28, t0.user_id AS user_id_29 FROM `product_reviews_cache` t0 WHERE t0.collection_id IN (?) SELECT t0.`id` AS id_1, t0.`reviewId` AS reviewId_2, t0.`referenceId` AS referenceId_3, t0.`conversationId` AS conversationId_4, t0.`p_id` AS p_id_5, t0.`sku` AS sku_6, t0.`gtin` AS gtin_7, t0.`mpn` AS mpn_8, t0.`url` AS url_9, t0.`star` AS star_10, t0.`score` AS score_11, t0.`date` AS date_12, t0.`created_at` AS created_at_13, t0.`content` AS content_14, t0.`username` AS username_15, t0.`country` AS country_16, t0.`locale` AS locale_17, t0.`language` AS language_18, t0.`state` AS state_19, t0.`unid_theme` AS unid_theme_20, t0.`send_portal_date` AS send_portal_date_21, t0.`answer` AS answer_22, t0.`manager` AS manager_23, t0.`is_anonymous` AS is_anonymous_24, t0.`is_collection_review` AS is_collection_review_25, t0.article_id AS article_id_26, t0.collection_id AS collection_id_27, t0.order_id AS order_id_28, t0.user_id AS user_id_29 FROM `product_reviews_cache` t0 WHERE t0.collection_id IN (212913, 374992, 1618573, 1618574, 1618575, 3245532, 3245547, 3245570, 3245571, 3245572, 3245872, 3245873, 3245874, 3245875, 3245892, 3246101, 3246383, 3246384, 3246519, 3246520, 3246521, 3246552, 3246566, 3246567, 3246659, 3246661, 3246710, 3246864, 3247094, 3247095, 3247180, 3247201, 3247260, 3247430, 3247680, 3248046, 3248055, 3248263, 3248353, 3248476, 3248484, 3248780, 3248789, 3248941, 3249011, 3249048, 3249061, 3249300, 3249608, 3249784, 3249821, 3249826, 3249894, 3250276, 3251980, 3252022, 3252025, 3255199, 3255367, 3255370, 3255373, 3255376, 3255406, 3255409, 3255442, 3255541, 3256153);
9	0.14 ms	SELECT f0_.`old_id` AS old_id_0, f1_.`name_single_en` AS name_single_en_1, f1_.`name_menu_en` AS name_menu_en_2 FROM `filters` f0_ LEFT JOIN `filter_pages` f1_ ON f0_.page_id = f1_.id LEFT JOIN `filter_groups` f2_ ON f0_.group_id = f2_.id WHERE f2_.`id` = 407 ORDER BY f0_.`sort` ASC Parameters: [] View formatted query View runnable query Explain query SELECT f0_.`old_id` AS old_id_0, f1_.`name_single_en` AS name_single_en_1, f1_.`name_menu_en` AS name_menu_en_2 FROM `filters` f0_ LEFT JOIN `filter_pages` f1_ ON f0_.page_id = f1_.id LEFT JOIN `filter_groups` f2_ ON f0_.group_id = f2_.id WHERE f2_.`id` = 407 ORDER BY f0_.`sort` ASC SELECT f0_.`old_id` AS old_id_0, f1_.`name_single_en` AS name_single_en_1, f1_.`name_menu_en` AS name_menu_en_2 FROM `filters` f0_ LEFT JOIN `filter_pages` f1_ ON f0_.page_id = f1_.id LEFT JOIN `filter_groups` f2_ ON f0_.group_id = f2_.id WHERE f2_.`id` = 407 ORDER BY f0_.`sort` ASC;
10	0.16 ms	SELECT t0.`id` AS id_1, t0.`unid` AS unid_2, t0.`name` AS name_3, t0.`name_inv` AS name_inv_4, t0.`url` AS url_5, t0.`alternate_name` AS alternate_name_6, t0.`description_ru` AS description_ru_7, t0.`description_en` AS description_en_8, t0.`description_it` AS description_it_9, t0.`description_es` AS description_es_10, t0.`description_fr` AS description_fr_11, t0.`description_de` AS description_de_12, t0.`description_pt` AS description_pt_13, t0.`description_pl` AS description_pl_14, t0.`description_nl` AS description_nl_15, t0.`description_fi` AS description_fi_16, t0.`description_ua` AS description_ua_17, t0.`description_sv` AS description_sv_18, t0.`description_no` AS description_no_19, t0.`description_da` AS description_da_20, t0.`description_zh` AS description_zh_21, t0.`delivery_time` AS delivery_time_22, t0.`not_regular` AS not_regular_23, t0.`suspended` AS suspended_24, t0.`status` AS status_25, t0.`type` AS type_26, t0.`discount` AS discount_27, t0.`discount_date_start` AS discount_date_start_28, t0.`discount_date_end` AS discount_date_end_29, t0.`transcription` AS transcription_30, t0.`cost_delivery` AS cost_delivery_31, t0.`create_date` AS create_date_32, t0.`is_accepted` AS is_accepted_33, t0.`accepted_at` AS accepted_at_34, t0.`accept_state` AS accept_state_35, t0.`description_edit` AS description_edit_36, t0.`stated_at` AS stated_at_37, t0.`state` AS state_38, t0.`description_state` AS description_state_39, t0.`video` AS video_40, t0.`parser_address` AS parser_address_41, t0.`accessible` AS accessible_42, t0.`sound` AS sound_43, t0.`test_access` AS test_access_44, t0.`total_ideas` AS total_ideas_45, t0.`votes_submit` AS votes_submit_46, t0.`votes_stars` AS votes_stars_47, t0.`brand_link` AS brand_link_48, t0.`brand_logo` AS brand_logo_49, t0.`no_send_portl_message` AS no_send_portl_message_50, t0.user_id AS user_id_51, t0.country AS country_52, t0.filter AS filter_53 FROM `factory` t0 WHERE t0.`url` = ? LIMIT 1 Parameters: [`"colorker"`] View formatted query View runnable query Explain query SELECT t0.`id` AS id_1, t0.`unid` AS unid_2, t0.`name` AS name_3, t0.`name_inv` AS name_inv_4, t0.`url` AS url_5, t0.`alternate_name` AS alternate_name_6, t0.`description_ru` AS description_ru_7, t0.`description_en` AS description_en_8, t0.`description_it` AS description_it_9, t0.`description_es` AS description_es_10, t0.`description_fr` AS description_fr_11, t0.`description_de` AS description_de_12, t0.`description_pt` AS description_pt_13, t0.`description_pl` AS description_pl_14, t0.`description_nl` AS description_nl_15, t0.`description_fi` AS description_fi_16, t0.`description_ua` AS description_ua_17, t0.`description_sv` AS description_sv_18, t0.`description_no` AS description_no_19, t0.`description_da` AS description_da_20, t0.`description_zh` AS description_zh_21, t0.`delivery_time` AS delivery_time_22, t0.`not_regular` AS not_regular_23, t0.`suspended` AS suspended_24, t0.`status` AS status_25, t0.`type` AS type_26, t0.`discount` AS discount_27, t0.`discount_date_start` AS discount_date_start_28, t0.`discount_date_end` AS discount_date_end_29, t0.`transcription` AS transcription_30, t0.`cost_delivery` AS cost_delivery_31, t0.`create_date` AS create_date_32, t0.`is_accepted` AS is_accepted_33, t0.`accepted_at` AS accepted_at_34, t0.`accept_state` AS accept_state_35, t0.`description_edit` AS description_edit_36, t0.`stated_at` AS stated_at_37, t0.`state` AS state_38, t0.`description_state` AS description_state_39, t0.`video` AS video_40, t0.`parser_address` AS parser_address_41, t0.`accessible` AS accessible_42, t0.`sound` AS sound_43, t0.`test_access` AS test_access_44, t0.`total_ideas` AS total_ideas_45, t0.`votes_submit` AS votes_submit_46, t0.`votes_stars` AS votes_stars_47, t0.`brand_link` AS brand_link_48, t0.`brand_logo` AS brand_logo_49, t0.`no_send_portl_message` AS no_send_portl_message_50, t0.user_id AS user_id_51, t0.country AS country_52, t0.filter AS filter_53 FROM `factory` t0 WHERE t0.`url` = ? LIMIT 1 SELECT t0.`id` AS id_1, t0.`unid` AS unid_2, t0.`name` AS name_3, t0.`name_inv` AS name_inv_4, t0.`url` AS url_5, t0.`alternate_name` AS alternate_name_6, t0.`description_ru` AS description_ru_7, t0.`description_en` AS description_en_8, t0.`description_it` AS description_it_9, t0.`description_es` AS description_es_10, t0.`description_fr` AS description_fr_11, t0.`description_de` AS description_de_12, t0.`description_pt` AS description_pt_13, t0.`description_pl` AS description_pl_14, t0.`description_nl` AS description_nl_15, t0.`description_fi` AS description_fi_16, t0.`description_ua` AS description_ua_17, t0.`description_sv` AS description_sv_18, t0.`description_no` AS description_no_19, t0.`description_da` AS description_da_20, t0.`description_zh` AS description_zh_21, t0.`delivery_time` AS delivery_time_22, t0.`not_regular` AS not_regular_23, t0.`suspended` AS suspended_24, t0.`status` AS status_25, t0.`type` AS type_26, t0.`discount` AS discount_27, t0.`discount_date_start` AS discount_date_start_28, t0.`discount_date_end` AS discount_date_end_29, t0.`transcription` AS transcription_30, t0.`cost_delivery` AS cost_delivery_31, t0.`create_date` AS create_date_32, t0.`is_accepted` AS is_accepted_33, t0.`accepted_at` AS accepted_at_34, t0.`accept_state` AS accept_state_35, t0.`description_edit` AS description_edit_36, t0.`stated_at` AS stated_at_37, t0.`state` AS state_38, t0.`description_state` AS description_state_39, t0.`video` AS video_40, t0.`parser_address` AS parser_address_41, t0.`accessible` AS accessible_42, t0.`sound` AS sound_43, t0.`test_access` AS test_access_44, t0.`total_ideas` AS total_ideas_45, t0.`votes_submit` AS votes_submit_46, t0.`votes_stars` AS votes_stars_47, t0.`brand_link` AS brand_link_48, t0.`brand_logo` AS brand_logo_49, t0.`no_send_portl_message` AS no_send_portl_message_50, t0.user_id AS user_id_51, t0.country AS country_52, t0.filter AS filter_53 FROM `factory` t0 WHERE t0.`url` = 'colorker' LIMIT 1;
11	0.71 ms	SELECT t0.`id` AS id_1, t0.`unid` AS unid_2, t0.`code` AS code_3, t0.`name` AS name_4, t0.`alternate_name` AS alternate_name_5, t0.`name_full` AS name_full_6, t0.`url` AS url_7, t0.`status` AS status_8, t0.`type` AS type_9, t0.`typeSet` AS typeSet_10, t0.`pc_as_m` AS pc_as_m_11, t0.`publish_date` AS publish_date_12, t0.`update_date` AS update_date_13, t0.`archive` AS archive_14, t0.`pr_min_euro` AS pr_min_euro_15, t0.`pr_min_euro_de` AS pr_min_euro_de_16, t0.`pr_min_euro_at` AS pr_min_euro_at_17, t0.`pr_min_euro_fi` AS pr_min_euro_fi_18, t0.`pr_min_euro_fr` AS pr_min_euro_fr_19, t0.`pr_min_euro_it` AS pr_min_euro_it_20, t0.`pr_min_euro_be` AS pr_min_euro_be_21, t0.`pr_min_euro_ie` AS pr_min_euro_ie_22, t0.`pr_min_euro_nl` AS pr_min_euro_nl_23, t0.`pr_min_euro_es` AS pr_min_euro_es_24, t0.`pr_min_rub` AS pr_min_rub_25, t0.`pr_min_rue` AS pr_min_rue_26, t0.`pr_min_gbp` AS pr_min_gbp_27, t0.`pr_min_gbe` AS pr_min_gbe_28, t0.`pr_min_usd` AS pr_min_usd_29, t0.`pr_min_use` AS pr_min_use_30, t0.`pr_min_f_usd` AS pr_min_f_usd_31, t0.`pr_min_f_use` AS pr_min_f_use_32, t0.`pr_min_chf` AS pr_min_chf_33, t0.`pr_min_che` AS pr_min_che_34, t0.`pr_min_sek` AS pr_min_sek_35, t0.`pr_min_see` AS pr_min_see_36, t0.`pr_min_dkk` AS pr_min_dkk_37, t0.`pr_min_dke` AS pr_min_dke_38, t0.`pr_min_nok` AS pr_min_nok_39, t0.`pr_min_noe` AS pr_min_noe_40, t0.`pr_min_pln` AS pr_min_pln_41, t0.`pr_min_ple` AS pr_min_ple_42, t0.`pr_min_cad` AS pr_min_cad_43, t0.`pr_min_cae` AS pr_min_cae_44, t0.`pr_min_f_cad` AS pr_min_f_cad_45, t0.`pr_min_f_cae` AS pr_min_f_cae_46, t0.`pr_min_ed` AS pr_min_ed_47, t0.`important` AS important_48, t0.`author` AS author_49, t0.`author_id` AS author_id_50, t0.`rating` AS rating_51, t0.`header` AS header_52, t0.`settings` AS settings_53, t0.`fids` AS fids_54, t0.`portal_unid` AS portal_unid_55, t0.`accepted_at` AS accepted_at_56, t0.`accept_state` AS accept_state_57, t0.`description_edit` AS description_edit_58, t0.`link_award` AS link_award_59, t0.`awards` AS awards_60, t0.`video` AS video_61, t0.`stated_at` AS stated_at_62, t0.`state` AS state_63, t0.`description_state` AS description_state_64, t0.`body_hide` AS body_hide_65, t0.`release_year` AS release_year_66, t0.`site` AS site_67, t0.`show_main` AS show_main_68, t0.`glue_url` AS glue_url_69, t0.`accessible` AS accessible_70, t0.`delivery_suspended` AS delivery_suspended_71, t0.`process` AS process_72, t0.`exhibition` AS exhibition_73, t0.`test_access` AS test_access_74, t0.`views` AS views_75, t0.`comment_unid` AS comment_unid_76, t0.`accesible_at` AS accesible_at_77, t0.`created_at` AS created_at_78, t0.`updated_at` AS updated_at_79, t0.factory AS factory_80, t0.category_price AS category_price_81, t82.`id` AS id_83, t82.`source` AS source_84, t82.`ru` AS ru_85, t82.`en` AS en_86, t82.`it` AS it_87, t82.`es` AS es_88, t82.`fr` AS fr_89, t82.`de` AS de_90, t82.`pl` AS pl_91, t82.`pt` AS pt_92, t82.`nl` AS nl_93, t82.`fi` AS fi_94, t82.`ua` AS ua_95, t82.`sv` AS sv_96, t82.`no` AS no_97, t82.`da` AS da_98, t82.`cn` AS cn_99, t82.`zh` AS zh_100, t82.`created_at` AS created_at_101, t82.`updated_at` AS updated_at_102, t82.email_body_id AS email_body_id_103, t82.publication_body_id AS publication_body_id_104, t82.static_page_body_id AS static_page_body_id_105, t82.collection_body_id AS collection_body_id_106, t82.trans_val_id AS trans_val_id_107, t82.exh_text_id AS exh_text_id_108, t82.exh_brand_text_id AS exh_brand_text_id_109, t82.exh_collection_text_id AS exh_collection_text_id_110, t82.filter_html_id AS filter_html_id_111, t112.`id` AS id_113, t112.`source` AS source_114, t112.`ru` AS ru_115, t112.`en` AS en_116, t112.`it` AS it_117, t112.`es` AS es_118, t112.`fr` AS fr_119, t112.`de` AS de_120, t112.`pl` AS pl_121, t112.`pt` AS pt_122, t112.`nl` AS nl_123, t112.`fi` AS fi_124, t112.`ua` AS ua_125, t112.`sv` AS sv_126, t112.`no` AS no_127, t112.`da` AS da_128, t112.`cn` AS cn_129, t112.`zh` AS zh_130, t112.`created_at` AS created_at_131, t112.`updated_at` AS updated_at_132, t112.static_page_title_id AS static_page_title_id_133, t112.static_page_keywords_id AS static_page_keywords_id_134, t112.static_page_description_id AS static_page_description_id_135, t112.collection_keywords_id AS collection_keywords_id_136, t112.collection_description_id AS collection_description_id_137, t112.blog_keywords_id AS blog_keywords_id_138, t112.blog_description_id AS blog_description_id_139, t112.exh_keywords_id AS exh_keywords_id_140, t112.exh_description_id AS exh_description_id_141, t142.`id` AS id_143, t142.`source` AS source_144, t142.`ru` AS ru_145, t142.`en` AS en_146, t142.`it` AS it_147, t142.`es` AS es_148, t142.`fr` AS fr_149, t142.`de` AS de_150, t142.`pl` AS pl_151, t142.`pt` AS pt_152, t142.`nl` AS nl_153, t142.`fi` AS fi_154, t142.`ua` AS ua_155, t142.`sv` AS sv_156, t142.`no` AS no_157, t142.`da` AS da_158, t142.`cn` AS cn_159, t142.`zh` AS zh_160, t142.`created_at` AS created_at_161, t142.`updated_at` AS updated_at_162, t142.static_page_title_id AS static_page_title_id_163, t142.static_page_keywords_id AS static_page_keywords_id_164, t142.static_page_description_id AS static_page_description_id_165, t142.collection_keywords_id AS collection_keywords_id_166, t142.collection_description_id AS collection_description_id_167, t142.blog_keywords_id AS blog_keywords_id_168, t142.blog_description_id AS blog_description_id_169, t142.exh_keywords_id AS exh_keywords_id_170, t142.exh_description_id AS exh_description_id_171 FROM `collection` t0 LEFT JOIN `locale_html` t82 ON t82.collection_body_id = t0.id LEFT JOIN `locale_meta` t112 ON t112.collection_keywords_id = t0.id LEFT JOIN `locale_meta` t142 ON t142.collection_description_id = t0.id WHERE t0.factory = ? Parameters: [`1255`] View formatted query View runnable query Explain query SELECT t0.`id` AS id_1, t0.`unid` AS unid_2, t0.`code` AS code_3, t0.`name` AS name_4, t0.`alternate_name` AS alternate_name_5, t0.`name_full` AS name_full_6, t0.`url` AS url_7, t0.`status` AS status_8, t0.`type` AS type_9, t0.`typeSet` AS typeSet_10, t0.`pc_as_m` AS pc_as_m_11, t0.`publish_date` AS publish_date_12, t0.`update_date` AS update_date_13, t0.`archive` AS archive_14, t0.`pr_min_euro` AS pr_min_euro_15, t0.`pr_min_euro_de` AS pr_min_euro_de_16, t0.`pr_min_euro_at` AS pr_min_euro_at_17, t0.`pr_min_euro_fi` AS pr_min_euro_fi_18, t0.`pr_min_euro_fr` AS pr_min_euro_fr_19, t0.`pr_min_euro_it` AS pr_min_euro_it_20, t0.`pr_min_euro_be` AS pr_min_euro_be_21, t0.`pr_min_euro_ie` AS pr_min_euro_ie_22, t0.`pr_min_euro_nl` AS pr_min_euro_nl_23, t0.`pr_min_euro_es` AS pr_min_euro_es_24, t0.`pr_min_rub` AS pr_min_rub_25, t0.`pr_min_rue` AS pr_min_rue_26, t0.`pr_min_gbp` AS pr_min_gbp_27, t0.`pr_min_gbe` AS pr_min_gbe_28, t0.`pr_min_usd` AS pr_min_usd_29, t0.`pr_min_use` AS pr_min_use_30, t0.`pr_min_f_usd` AS pr_min_f_usd_31, t0.`pr_min_f_use` AS pr_min_f_use_32, t0.`pr_min_chf` AS pr_min_chf_33, t0.`pr_min_che` AS pr_min_che_34, t0.`pr_min_sek` AS pr_min_sek_35, t0.`pr_min_see` AS pr_min_see_36, t0.`pr_min_dkk` AS pr_min_dkk_37, t0.`pr_min_dke` AS pr_min_dke_38, t0.`pr_min_nok` AS pr_min_nok_39, t0.`pr_min_noe` AS pr_min_noe_40, t0.`pr_min_pln` AS pr_min_pln_41, t0.`pr_min_ple` AS pr_min_ple_42, t0.`pr_min_cad` AS pr_min_cad_43, t0.`pr_min_cae` AS pr_min_cae_44, t0.`pr_min_f_cad` AS pr_min_f_cad_45, t0.`pr_min_f_cae` AS pr_min_f_cae_46, t0.`pr_min_ed` AS pr_min_ed_47, t0.`important` AS important_48, t0.`author` AS author_49, t0.`author_id` AS author_id_50, t0.`rating` AS rating_51, t0.`header` AS header_52, t0.`settings` AS settings_53, t0.`fids` AS fids_54, t0.`portal_unid` AS portal_unid_55, t0.`accepted_at` AS accepted_at_56, t0.`accept_state` AS accept_state_57, t0.`description_edit` AS description_edit_58, t0.`link_award` AS link_award_59, t0.`awards` AS awards_60, t0.`video` AS video_61, t0.`stated_at` AS stated_at_62, t0.`state` AS state_63, t0.`description_state` AS description_state_64, t0.`body_hide` AS body_hide_65, t0.`release_year` AS release_year_66, t0.`site` AS site_67, t0.`show_main` AS show_main_68, t0.`glue_url` AS glue_url_69, t0.`accessible` AS accessible_70, t0.`delivery_suspended` AS delivery_suspended_71, t0.`process` AS process_72, t0.`exhibition` AS exhibition_73, t0.`test_access` AS test_access_74, t0.`views` AS views_75, t0.`comment_unid` AS comment_unid_76, t0.`accesible_at` AS accesible_at_77, t0.`created_at` AS created_at_78, t0.`updated_at` AS updated_at_79, t0.factory AS factory_80, t0.category_price AS category_price_81, t82.`id` AS id_83, t82.`source` AS source_84, t82.`ru` AS ru_85, t82.`en` AS en_86, t82.`it` AS it_87, t82.`es` AS es_88, t82.`fr` AS fr_89, t82.`de` AS de_90, t82.`pl` AS pl_91, t82.`pt` AS pt_92, t82.`nl` AS nl_93, t82.`fi` AS fi_94, t82.`ua` AS ua_95, t82.`sv` AS sv_96, t82.`no` AS no_97, t82.`da` AS da_98, t82.`cn` AS cn_99, t82.`zh` AS zh_100, t82.`created_at` AS created_at_101, t82.`updated_at` AS updated_at_102, t82.email_body_id AS email_body_id_103, t82.publication_body_id AS publication_body_id_104, t82.static_page_body_id AS static_page_body_id_105, t82.collection_body_id AS collection_body_id_106, t82.trans_val_id AS trans_val_id_107, t82.exh_text_id AS exh_text_id_108, t82.exh_brand_text_id AS exh_brand_text_id_109, t82.exh_collection_text_id AS exh_collection_text_id_110, t82.filter_html_id AS filter_html_id_111, t112.`id` AS id_113, t112.`source` AS source_114, t112.`ru` AS ru_115, t112.`en` AS en_116, t112.`it` AS it_117, t112.`es` AS es_118, t112.`fr` AS fr_119, t112.`de` AS de_120, t112.`pl` AS pl_121, t112.`pt` AS pt_122, t112.`nl` AS nl_123, t112.`fi` AS fi_124, t112.`ua` AS ua_125, t112.`sv` AS sv_126, t112.`no` AS no_127, t112.`da` AS da_128, t112.`cn` AS cn_129, t112.`zh` AS zh_130, t112.`created_at` AS created_at_131, t112.`updated_at` AS updated_at_132, t112.static_page_title_id AS static_page_title_id_133, t112.static_page_keywords_id AS static_page_keywords_id_134, t112.static_page_description_id AS static_page_description_id_135, t112.collection_keywords_id AS collection_keywords_id_136, t112.collection_description_id AS collection_description_id_137, t112.blog_keywords_id AS blog_keywords_id_138, t112.blog_description_id AS blog_description_id_139, t112.exh_keywords_id AS exh_keywords_id_140, t112.exh_description_id AS exh_description_id_141, t142.`id` AS id_143, t142.`source` AS source_144, t142.`ru` AS ru_145, t142.`en` AS en_146, t142.`it` AS it_147, t142.`es` AS es_148, t142.`fr` AS fr_149, t142.`de` AS de_150, t142.`pl` AS pl_151, t142.`pt` AS pt_152, t142.`nl` AS nl_153, t142.`fi` AS fi_154, t142.`ua` AS ua_155, t142.`sv` AS sv_156, t142.`no` AS no_157, t142.`da` AS da_158, t142.`cn` AS cn_159, t142.`zh` AS zh_160, t142.`created_at` AS created_at_161, t142.`updated_at` AS updated_at_162, t142.static_page_title_id AS static_page_title_id_163, t142.static_page_keywords_id AS static_page_keywords_id_164, t142.static_page_description_id AS static_page_description_id_165, t142.collection_keywords_id AS collection_keywords_id_166, t142.collection_description_id AS collection_description_id_167, t142.blog_keywords_id AS blog_keywords_id_168, t142.blog_description_id AS blog_description_id_169, t142.exh_keywords_id AS exh_keywords_id_170, t142.exh_description_id AS exh_description_id_171 FROM `collection` t0 LEFT JOIN `locale_html` t82 ON t82.collection_body_id = t0.id LEFT JOIN `locale_meta` t112 ON t112.collection_keywords_id = t0.id LEFT JOIN `locale_meta` t142 ON t142.collection_description_id = t0.id WHERE t0.factory = ? SELECT t0.`id` AS id_1, t0.`unid` AS unid_2, t0.`code` AS code_3, t0.`name` AS name_4, t0.`alternate_name` AS alternate_name_5, t0.`name_full` AS name_full_6, t0.`url` AS url_7, t0.`status` AS status_8, t0.`type` AS type_9, t0.`typeSet` AS typeSet_10, t0.`pc_as_m` AS pc_as_m_11, t0.`publish_date` AS publish_date_12, t0.`update_date` AS update_date_13, t0.`archive` AS archive_14, t0.`pr_min_euro` AS pr_min_euro_15, t0.`pr_min_euro_de` AS pr_min_euro_de_16, t0.`pr_min_euro_at` AS pr_min_euro_at_17, t0.`pr_min_euro_fi` AS pr_min_euro_fi_18, t0.`pr_min_euro_fr` AS pr_min_euro_fr_19, t0.`pr_min_euro_it` AS pr_min_euro_it_20, t0.`pr_min_euro_be` AS pr_min_euro_be_21, t0.`pr_min_euro_ie` AS pr_min_euro_ie_22, t0.`pr_min_euro_nl` AS pr_min_euro_nl_23, t0.`pr_min_euro_es` AS pr_min_euro_es_24, t0.`pr_min_rub` AS pr_min_rub_25, t0.`pr_min_rue` AS pr_min_rue_26, t0.`pr_min_gbp` AS pr_min_gbp_27, t0.`pr_min_gbe` AS pr_min_gbe_28, t0.`pr_min_usd` AS pr_min_usd_29, t0.`pr_min_use` AS pr_min_use_30, t0.`pr_min_f_usd` AS pr_min_f_usd_31, t0.`pr_min_f_use` AS pr_min_f_use_32, t0.`pr_min_chf` AS pr_min_chf_33, t0.`pr_min_che` AS pr_min_che_34, t0.`pr_min_sek` AS pr_min_sek_35, t0.`pr_min_see` AS pr_min_see_36, t0.`pr_min_dkk` AS pr_min_dkk_37, t0.`pr_min_dke` AS pr_min_dke_38, t0.`pr_min_nok` AS pr_min_nok_39, t0.`pr_min_noe` AS pr_min_noe_40, t0.`pr_min_pln` AS pr_min_pln_41, t0.`pr_min_ple` AS pr_min_ple_42, t0.`pr_min_cad` AS pr_min_cad_43, t0.`pr_min_cae` AS pr_min_cae_44, t0.`pr_min_f_cad` AS pr_min_f_cad_45, t0.`pr_min_f_cae` AS pr_min_f_cae_46, t0.`pr_min_ed` AS pr_min_ed_47, t0.`important` AS important_48, t0.`author` AS author_49, t0.`author_id` AS author_id_50, t0.`rating` AS rating_51, t0.`header` AS header_52, t0.`settings` AS settings_53, t0.`fids` AS fids_54, t0.`portal_unid` AS portal_unid_55, t0.`accepted_at` AS accepted_at_56, t0.`accept_state` AS accept_state_57, t0.`description_edit` AS description_edit_58, t0.`link_award` AS link_award_59, t0.`awards` AS awards_60, t0.`video` AS video_61, t0.`stated_at` AS stated_at_62, t0.`state` AS state_63, t0.`description_state` AS description_state_64, t0.`body_hide` AS body_hide_65, t0.`release_year` AS release_year_66, t0.`site` AS site_67, t0.`show_main` AS show_main_68, t0.`glue_url` AS glue_url_69, t0.`accessible` AS accessible_70, t0.`delivery_suspended` AS delivery_suspended_71, t0.`process` AS process_72, t0.`exhibition` AS exhibition_73, t0.`test_access` AS test_access_74, t0.`views` AS views_75, t0.`comment_unid` AS comment_unid_76, t0.`accesible_at` AS accesible_at_77, t0.`created_at` AS created_at_78, t0.`updated_at` AS updated_at_79, t0.factory AS factory_80, t0.category_price AS category_price_81, t82.`id` AS id_83, t82.`source` AS source_84, t82.`ru` AS ru_85, t82.`en` AS en_86, t82.`it` AS it_87, t82.`es` AS es_88, t82.`fr` AS fr_89, t82.`de` AS de_90, t82.`pl` AS pl_91, t82.`pt` AS pt_92, t82.`nl` AS nl_93, t82.`fi` AS fi_94, t82.`ua` AS ua_95, t82.`sv` AS sv_96, t82.`no` AS no_97, t82.`da` AS da_98, t82.`cn` AS cn_99, t82.`zh` AS zh_100, t82.`created_at` AS created_at_101, t82.`updated_at` AS updated_at_102, t82.email_body_id AS email_body_id_103, t82.publication_body_id AS publication_body_id_104, t82.static_page_body_id AS static_page_body_id_105, t82.collection_body_id AS collection_body_id_106, t82.trans_val_id AS trans_val_id_107, t82.exh_text_id AS exh_text_id_108, t82.exh_brand_text_id AS exh_brand_text_id_109, t82.exh_collection_text_id AS exh_collection_text_id_110, t82.filter_html_id AS filter_html_id_111, t112.`id` AS id_113, t112.`source` AS source_114, t112.`ru` AS ru_115, t112.`en` AS en_116, t112.`it` AS it_117, t112.`es` AS es_118, t112.`fr` AS fr_119, t112.`de` AS de_120, t112.`pl` AS pl_121, t112.`pt` AS pt_122, t112.`nl` AS nl_123, t112.`fi` AS fi_124, t112.`ua` AS ua_125, t112.`sv` AS sv_126, t112.`no` AS no_127, t112.`da` AS da_128, t112.`cn` AS cn_129, t112.`zh` AS zh_130, t112.`created_at` AS created_at_131, t112.`updated_at` AS updated_at_132, t112.static_page_title_id AS static_page_title_id_133, t112.static_page_keywords_id AS static_page_keywords_id_134, t112.static_page_description_id AS static_page_description_id_135, t112.collection_keywords_id AS collection_keywords_id_136, t112.collection_description_id AS collection_description_id_137, t112.blog_keywords_id AS blog_keywords_id_138, t112.blog_description_id AS blog_description_id_139, t112.exh_keywords_id AS exh_keywords_id_140, t112.exh_description_id AS exh_description_id_141, t142.`id` AS id_143, t142.`source` AS source_144, t142.`ru` AS ru_145, t142.`en` AS en_146, t142.`it` AS it_147, t142.`es` AS es_148, t142.`fr` AS fr_149, t142.`de` AS de_150, t142.`pl` AS pl_151, t142.`pt` AS pt_152, t142.`nl` AS nl_153, t142.`fi` AS fi_154, t142.`ua` AS ua_155, t142.`sv` AS sv_156, t142.`no` AS no_157, t142.`da` AS da_158, t142.`cn` AS cn_159, t142.`zh` AS zh_160, t142.`created_at` AS created_at_161, t142.`updated_at` AS updated_at_162, t142.static_page_title_id AS static_page_title_id_163, t142.static_page_keywords_id AS static_page_keywords_id_164, t142.static_page_description_id AS static_page_description_id_165, t142.collection_keywords_id AS collection_keywords_id_166, t142.collection_description_id AS collection_description_id_167, t142.blog_keywords_id AS blog_keywords_id_168, t142.blog_description_id AS blog_description_id_169, t142.exh_keywords_id AS exh_keywords_id_170, t142.exh_description_id AS exh_description_id_171 FROM `collection` t0 LEFT JOIN `locale_html` t82 ON t82.collection_body_id = t0.id LEFT JOIN `locale_meta` t112 ON t112.collection_keywords_id = t0.id LEFT JOIN `locale_meta` t142 ON t142.collection_description_id = t0.id WHERE t0.factory = 1255;
12	0.57 ms	SELECT t0.`id` AS id_1, t0.`reviewId` AS reviewId_2, t0.`referenceId` AS referenceId_3, t0.`conversationId` AS conversationId_4, t0.`p_id` AS p_id_5, t0.`sku` AS sku_6, t0.`gtin` AS gtin_7, t0.`mpn` AS mpn_8, t0.`url` AS url_9, t0.`star` AS star_10, t0.`score` AS score_11, t0.`date` AS date_12, t0.`created_at` AS created_at_13, t0.`content` AS content_14, t0.`username` AS username_15, t0.`country` AS country_16, t0.`locale` AS locale_17, t0.`language` AS language_18, t0.`state` AS state_19, t0.`unid_theme` AS unid_theme_20, t0.`send_portal_date` AS send_portal_date_21, t0.`answer` AS answer_22, t0.`manager` AS manager_23, t0.`is_anonymous` AS is_anonymous_24, t0.`is_collection_review` AS is_collection_review_25, t0.article_id AS article_id_26, t0.collection_id AS collection_id_27, t0.order_id AS order_id_28, t0.user_id AS user_id_29 FROM `product_reviews_cache` t0 WHERE t0.collection_id IN (?) Parameters: [[ 212913 374992 1618573 1618574 1618575 3245532 3245547 3245570 3245571 3245572 3245872 3245873 3245874 3245875 3245892 3246101 3246383 3246384 3246519 3246520 3246521 3246552 3246566 3246567 3246659 3246661 3246710 3246864 3247094 3247095 3247180 3247201 3247260 3247430 3247680 3248046 3248055 3248263 3248353 3248476 3248484 3248780 3248789 3248941 3249011 3249048 3249061 3249300 3249608 3249784 3249821 3249826 3249894 3250276 3251980 3252022 3252025 3255199 3255367 3255370 3255373 3255376 3255406 3255409 3255442 3255541 3256153 ]] View formatted query View runnable query Explain query SELECT t0.`id` AS id_1, t0.`reviewId` AS reviewId_2, t0.`referenceId` AS referenceId_3, t0.`conversationId` AS conversationId_4, t0.`p_id` AS p_id_5, t0.`sku` AS sku_6, t0.`gtin` AS gtin_7, t0.`mpn` AS mpn_8, t0.`url` AS url_9, t0.`star` AS star_10, t0.`score` AS score_11, t0.`date` AS date_12, t0.`created_at` AS created_at_13, t0.`content` AS content_14, t0.`username` AS username_15, t0.`country` AS country_16, t0.`locale` AS locale_17, t0.`language` AS language_18, t0.`state` AS state_19, t0.`unid_theme` AS unid_theme_20, t0.`send_portal_date` AS send_portal_date_21, t0.`answer` AS answer_22, t0.`manager` AS manager_23, t0.`is_anonymous` AS is_anonymous_24, t0.`is_collection_review` AS is_collection_review_25, t0.article_id AS article_id_26, t0.collection_id AS collection_id_27, t0.order_id AS order_id_28, t0.user_id AS user_id_29 FROM `product_reviews_cache` t0 WHERE t0.collection_id IN (?) SELECT t0.`id` AS id_1, t0.`reviewId` AS reviewId_2, t0.`referenceId` AS referenceId_3, t0.`conversationId` AS conversationId_4, t0.`p_id` AS p_id_5, t0.`sku` AS sku_6, t0.`gtin` AS gtin_7, t0.`mpn` AS mpn_8, t0.`url` AS url_9, t0.`star` AS star_10, t0.`score` AS score_11, t0.`date` AS date_12, t0.`created_at` AS created_at_13, t0.`content` AS content_14, t0.`username` AS username_15, t0.`country` AS country_16, t0.`locale` AS locale_17, t0.`language` AS language_18, t0.`state` AS state_19, t0.`unid_theme` AS unid_theme_20, t0.`send_portal_date` AS send_portal_date_21, t0.`answer` AS answer_22, t0.`manager` AS manager_23, t0.`is_anonymous` AS is_anonymous_24, t0.`is_collection_review` AS is_collection_review_25, t0.article_id AS article_id_26, t0.collection_id AS collection_id_27, t0.order_id AS order_id_28, t0.user_id AS user_id_29 FROM `product_reviews_cache` t0 WHERE t0.collection_id IN (212913, 374992, 1618573, 1618574, 1618575, 3245532, 3245547, 3245570, 3245571, 3245572, 3245872, 3245873, 3245874, 3245875, 3245892, 3246101, 3246383, 3246384, 3246519, 3246520, 3246521, 3246552, 3246566, 3246567, 3246659, 3246661, 3246710, 3246864, 3247094, 3247095, 3247180, 3247201, 3247260, 3247430, 3247680, 3248046, 3248055, 3248263, 3248353, 3248476, 3248484, 3248780, 3248789, 3248941, 3249011, 3249048, 3249061, 3249300, 3249608, 3249784, 3249821, 3249826, 3249894, 3250276, 3251980, 3252022, 3252025, 3255199, 3255367, 3255370, 3255373, 3255376, 3255406, 3255409, 3255442, 3255541, 3256153);
13	0.10 ms	SELECT f2.id, f2.name, f2.old_command, f2.old_id, GROUP_CONCAT(f.id) AS ids, GROUP_CONCAT(f.old_id) AS old_ids FROM `filters` f LEFT JOIN filters f2 ON f.parent_id = f2.id LEFT JOIN filter_params p ON f.param_id = p.id WHERE f.parent_id IS NOT NULL AND p.is_enable = 1 AND p.show_menu != 0 GROUP BY f.parent_id; Parameters: [] View formatted query View runnable query Explain query SELECT f2.id, f2.name, f2.old_command, f2.old_id, GROUP_CONCAT(f.id) AS ids, GROUP_CONCAT(f.old_id) AS old_ids FROM `filters` f LEFT JOIN filters f2 ON f.parent_id = f2.id LEFT JOIN filter_params p ON f.param_id = p.id WHERE f.parent_id IS NOT NULL AND p.is_enable = 1 AND p.show_menu != 0 GROUP BY f.parent_id; SELECT f2.id, f2.name, f2.old_command, f2.old_id, GROUP_CONCAT(f.id) AS ids, GROUP_CONCAT(f.old_id) AS old_ids FROM `filters` f LEFT JOIN filters f2 ON f.parent_id = f2.id LEFT JOIN filter_params p ON f.param_id = p.id WHERE f.parent_id IS NOT NULL AND p.is_enable = 1 AND p.show_menu != 0 GROUP BY f.parent_id;;
14	0.11 ms	SELECT f2.id, f2.name, f2.old_command, f2.old_id, GROUP_CONCAT(f.id) AS ids, GROUP_CONCAT(f.old_id) AS old_ids FROM `filters` f LEFT JOIN filters f2 ON f.parent_id = f2.id LEFT JOIN filter_params p ON f.param_id = p.id WHERE f.parent_id IS NOT NULL AND p.is_enable = 1 AND p.show_menu != 0 GROUP BY f.parent_id; Parameters: [] View formatted query View runnable query Explain query SELECT f2.id, f2.name, f2.old_command, f2.old_id, GROUP_CONCAT(f.id) AS ids, GROUP_CONCAT(f.old_id) AS old_ids FROM `filters` f LEFT JOIN filters f2 ON f.parent_id = f2.id LEFT JOIN filter_params p ON f.param_id = p.id WHERE f.parent_id IS NOT NULL AND p.is_enable = 1 AND p.show_menu != 0 GROUP BY f.parent_id; SELECT f2.id, f2.name, f2.old_command, f2.old_id, GROUP_CONCAT(f.id) AS ids, GROUP_CONCAT(f.old_id) AS old_ids FROM `filters` f LEFT JOIN filters f2 ON f.parent_id = f2.id LEFT JOIN filter_params p ON f.param_id = p.id WHERE f.parent_id IS NOT NULL AND p.is_enable = 1 AND p.show_menu != 0 GROUP BY f.parent_id;;
15	0.09 ms	SELECT f2.id, f2.name, f2.old_command, f2.old_id, GROUP_CONCAT(f.id) AS ids, GROUP_CONCAT(f.old_id) AS old_ids FROM `filters` f LEFT JOIN filters f2 ON f.parent_id = f2.id LEFT JOIN filter_params p ON f.param_id = p.id WHERE f.parent_id IS NOT NULL AND p.is_enable = 1 AND p.show_menu != 0 GROUP BY f.parent_id; Parameters: [] View formatted query View runnable query Explain query SELECT f2.id, f2.name, f2.old_command, f2.old_id, GROUP_CONCAT(f.id) AS ids, GROUP_CONCAT(f.old_id) AS old_ids FROM `filters` f LEFT JOIN filters f2 ON f.parent_id = f2.id LEFT JOIN filter_params p ON f.param_id = p.id WHERE f.parent_id IS NOT NULL AND p.is_enable = 1 AND p.show_menu != 0 GROUP BY f.parent_id; SELECT f2.id, f2.name, f2.old_command, f2.old_id, GROUP_CONCAT(f.id) AS ids, GROUP_CONCAT(f.old_id) AS old_ids FROM `filters` f LEFT JOIN filters f2 ON f.parent_id = f2.id LEFT JOIN filter_params p ON f.param_id = p.id WHERE f.parent_id IS NOT NULL AND p.is_enable = 1 AND p.show_menu != 0 GROUP BY f.parent_id;;
16	0.10 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: [`"us"`] 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` = 'us';
17	2.99 ms	SELECT v0_.`id` AS id_0, v0_.`token` AS token_1, v0_.`url` AS url_2, v0_.`title` AS title_3, v0_.`icon` AS icon_4, v0_.`visit_date` AS visit_date_5, v0_.`v_type` AS v_type_6, v0_.`v_object_id` AS v_object_id_7 FROM `visit` v0_ WHERE v0_.`token` = ? AND v0_.`url` = ? AND v0_.`url` <> '/.catalog./' LIMIT 1 Parameters: [`"86bc87cd665833aa5c0767bb4adbbbf9491f9706cca40c7c56b3393e654c98c8" "catalogue/colorker"`] View formatted query View runnable query Explain query SELECT v0_.`id` AS id_0, v0_.`token` AS token_1, v0_.`url` AS url_2, v0_.`title` AS title_3, v0_.`icon` AS icon_4, v0_.`visit_date` AS visit_date_5, v0_.`v_type` AS v_type_6, v0_.`v_object_id` AS v_object_id_7 FROM `visit` v0_ WHERE v0_.`token` = ? AND v0_.`url` = ? AND v0_.`url` <> '/.catalog./' LIMIT 1 SELECT v0_.`id` AS id_0, v0_.`token` AS token_1, v0_.`url` AS url_2, v0_.`title` AS title_3, v0_.`icon` AS icon_4, v0_.`visit_date` AS visit_date_5, v0_.`v_type` AS v_type_6, v0_.`v_object_id` AS v_object_id_7 FROM `visit` v0_ WHERE v0_.`token` = '86bc87cd665833aa5c0767bb4adbbbf9491f9706cca40c7c56b3393e654c98c8' AND v0_.`url` = 'catalogue/colorker' AND v0_.`url` <> '/.catalog./' LIMIT 1;
18	0.09 ms	"START TRANSACTION" Parameters: [] View formatted query View runnable query Explain query "START TRANSACTION" "START TRANSACTION";
19	0.22 ms	INSERT INTO `visit` (`token`, `url`, `title`, `icon`, `visit_date`, `v_type`, `v_object_id`) VALUES (?, ?, ?, ?, ?, ?, ?) Parameters: [`1 => "86bc87cd665833aa5c0767bb4adbbbf9" 2 => "catalogue/colorker" 3 => "Manufacturer Colorker" 4 => "/img/histories/tile-catalogue.jpg?64" 5 => "2025-09-28 23:22:01" 6 => 5 7 => 0`] View formatted query View runnable query Explain query INSERT INTO `visit` ( `token`, `url`, `title`, `icon`, `visit_date`, `v_type`, `v_object_id` ) VALUES (?, ?, ?, ?, ?, ?, ?) INSERT INTO `visit` (`token`, `url`, `title`, `icon`, `visit_date`, `v_type`, `v_object_id`) VALUES ('86bc87cd665833aa5c0767bb4adbbbf9', 'catalogue/colorker', 'Manufacturer Colorker', '/img/histories/tile-catalogue.jpg?64', '2025-09-28 23:22:01', 5, 0);
20	0.11 ms	"COMMIT" Parameters: [] View formatted query View runnable query Explain query "COMMIT" "COMMIT";
21	0.17 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: [`"86bc87cd665833aa5c0767bb4adbbbf9491f9706cca40c7c56b3393e654c98c8"`] 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` = '86bc87cd665833aa5c0767bb4adbbbf9491f9706cca40c7c56b3393e654c98c8' LIMIT 1;
22	0.09 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: [`"86bc87cd665833aa5c0767bb4adbbbf9491f9706cca40c7c56b3393e654c98c8"`] 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` = '86bc87cd665833aa5c0767bb4adbbbf9491f9706cca40c7c56b3393e654c98c8' AND b1_.`status` <> 12;
23	0.10 ms	SELECT b0_.`id` AS id_0 FROM `buy_order` b0_ WHERE b0_.`token` = ? AND b0_.`status` <> 12 Parameters: [`"86bc87cd665833aa5c0767bb4adbbbf9491f9706cca40c7c56b3393e654c98c8"`] 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` = '86bc87cd665833aa5c0767bb4adbbbf9491f9706cca40c7c56b3393e654c98c8' AND b0_.`status` <> 12;
24	0.45 ms	SELECT COUNT(v0_.`id`) AS sclr_0 FROM `visit` v0_ WHERE v0_.`token` = ? AND v0_.`url` <> '/.catalog./' Parameters: [`"86bc87cd665833aa5c0767bb4adbbbf9491f9706cca40c7c56b3393e654c98c8"`] 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` = '86bc87cd665833aa5c0767bb4adbbbf9491f9706cca40c7c56b3393e654c98c8' AND v0_.`url` <> '/.catalog./';
25	0.11 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: [`"86bc87cd665833aa5c0767bb4adbbbf9491f9706cca40c7c56b3393e654c98c8"`] 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` = '86bc87cd665833aa5c0767bb4adbbbf9491f9706cca40c7c56b3393e654c98c8';
26	0.12 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';
27	0.15 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: [`"86bc87cd665833aa5c0767bb4adbbbf9491f9706cca40c7c56b3393e654c98c8"`] 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` = '86bc87cd665833aa5c0767bb4adbbbf9491f9706cca40c7c56b3393e654c98c8' LIMIT 1;
28	0.19 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';
29	54.87 ms	SELECT c0_.`id` AS id_0, c0_.`url` AS url_1, c0_.`code` AS code_2, c0_.`name` AS name_3, c0_.`alternate_name` AS alternate_name_4, c0_.`name_full` AS name_full_5, f1_.`id` AS id_6, f1_.`url` AS url_7, f1_.`unid` AS unid_8, f2_.`id` AS id_9, f1_.`url` AS url_10, f1_.`name` AS name_11, (SELECT COUNT(p3_.`star`) AS sclr_13 FROM `product_reviews_cache` p3_ WHERE p3_.`sku` = c0_.`code`) AS sclr_12, (SELECT SUM(p4_.`star`) AS sclr_15 FROM `product_reviews_cache` p4_ WHERE p4_.`sku` = c0_.`code`) AS sclr_14 FROM `collection` c0_ INNER JOIN `factory` f1_ ON c0_.factory = f1_.id INNER JOIN `filters` f2_ ON f1_.filter = f2_.id INNER JOIN `list_country` l5_ ON f1_.country = l5_.id LEFT JOIN `locale_url` l6_ ON f2_.id = l6_.filter_id LEFT JOIN `filter_pages` f7_ ON f2_.page_id = f7_.id WHERE f1_.filter IS NOT NULL AND c0_.factory <> '' AND f1_.`status` = ? AND f1_.`id` NOT IN (?) AND (c0_.`test_access` IS NULL OR c0_.`test_access` = 0) AND (f1_.`test_access` IS NULL OR f1_.`test_access` = 0) AND c0_.`status` = ? AND c0_.`status` = ? AND f1_.`status` = ? ORDER BY c0_.`id` ASC Parameters: [`1 [ 14 ] 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 f1_.`id` NOT IN (?) AND ( c0_.`test_access` IS NULL OR c0_.`test_access` = 0 ) AND ( f1_.`test_access` IS NULL OR f1_.`test_access` = 0 ) AND c0_.`status` = ? AND c0_.`status` = ? AND f1_.`status` = ? ORDER BY c0_.`id` ASC 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 f1_.`id` NOT IN (14) 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;
30	0.15 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;
31	0.11 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; ;
32	0.99 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;
33	5.16 ms	SELECT COUNT(c0_.`id`) AS sclr_0 FROM `collection` c0_ LEFT JOIN `factory` f1_ ON c0_.factory = f1_.id LEFT JOIN `article` a2_ ON c0_.id = a2_.collection WHERE c0_.factory <> '' AND f1_.`id` <> 99 AND f1_.`status` = ? AND c0_.`status` = ? AND c0_.`archive` <> 1 AND a2_.`price_euro` IS NOT NULL AND (c0_.`test_access` IS NULL OR c0_.`test_access` = 0) AND (f1_.`test_access` IS NULL OR f1_.`test_access` = 0) AND f1_.`id` IN (1255) GROUP BY c0_.`id` ORDER BY c0_.`name` ASC, c0_.`publish_date` ASC Parameters: [`1 1`] View formatted query View runnable query Explain query SELECT COUNT(c0_.`id`) AS sclr_0 FROM `collection` c0_ LEFT JOIN `factory` f1_ ON c0_.factory = f1_.id LEFT JOIN `article` a2_ ON c0_.id = a2_.collection WHERE c0_.factory <> '' AND f1_.`id` <> 99 AND f1_.`status` = ? AND c0_.`status` = ? AND c0_.`archive` <> 1 AND a2_.`price_euro` IS NOT NULL AND ( c0_.`test_access` IS NULL OR c0_.`test_access` = 0 ) AND ( f1_.`test_access` IS NULL OR f1_.`test_access` = 0 ) AND f1_.`id` IN (1255) GROUP BY c0_.`id` ORDER BY c0_.`name` ASC, c0_.`publish_date` ASC SELECT COUNT(c0_.`id`) AS sclr_0 FROM `collection` c0_ LEFT JOIN `factory` f1_ ON c0_.factory = f1_.id LEFT JOIN `article` a2_ ON c0_.id = a2_.collection WHERE c0_.factory <> '' AND f1_.`id` <> 99 AND f1_.`status` = 1 AND c0_.`status` = 1 AND c0_.`archive` <> 1 AND a2_.`price_euro` IS NOT NULL AND (c0_.`test_access` IS NULL OR c0_.`test_access` = 0) AND (f1_.`test_access` IS NULL OR f1_.`test_access` = 0) AND f1_.`id` IN (1255) GROUP BY c0_.`id` ORDER BY c0_.`name` ASC, c0_.`publish_date` ASC;
34	0.18 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.
WebBundle\Entity\FilterEntity	No errors.
WebBundle\Entity\Collection	No errors.
WebBundle\Entity\Factory	No errors.
WebBundle\Entity\ListMeasure	No errors.
WebBundle\Entity\ListMaterial	No errors.
WebBundle\Entity\ProductReviewsCache	No errors.
WebBundle\Entity\ReviewsCache	No errors.
WebBundle\Entity\ListCountry	No errors.
WebBundle\Entity\Article	No errors.
WebBundle\Entity\Interior	No errors.
WebBundle\Entity\Idea	No errors.
WebBundle\Entity\CollectionAlsoViewed	No errors.
WebBundle\Entity\InteriorHistory	No errors.
FlexApp\Entity\ChatB	No errors.
FlexApp\Entity\ChatBMessage	No errors.
FlexApp\Entity\BoolDBSetting	No errors.
FlexApp\Entity\Widget	No errors.
FlexApp\Entity\CountryAndLangSpecificDataEntity	No errors.
FlexApp\Entity\ConsultantEntity	No errors.
FlexApp\Entity\GeoCountryEntity	No errors.
WebBundle\Entity\FactoryUser	No errors.
WebBundle\Entity\ListBrandParser	No errors.
FlexApp\Entity\Exhibition\ExhBrandEntity	No errors.
WebBundle\Entity\CheckList	No errors.
WebBundle\Entity\ListPrice	No errors.
WebBundle\Entity\LocaleHtmlEntity	No errors.
WebBundle\Entity\ListEmail	No errors.
WebBundle\Entity\StaticPageEntity	No errors.
WebBundle\Entity\TransEntity	No errors.
FlexApp\Entity\Exhibition\ExhEntity	No errors.
FlexApp\Entity\Exhibition\ExhCollectionEntity	No errors.
WebBundle\Entity\LocaleMetaEntity	No errors.
WebBundle\Entity\BuyOrderArticle	No errors.
WebBundle\Entity\BuyOrder	No errors.
WebBundle\Entity\Visit	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\BuyOrderManager	No errors.
FlexApp\Entity\InterviewEntity	No errors.
WebBundle\Entity\TransExEntity	No errors.
WebBundle\Entity\Participant	No errors.
WebBundle\Entity\PublicationLike	No errors.
WebBundle\Entity\LocaleTitleEntity	No errors.
WebBundle\Entity\LocaleUrlEntity	No errors.
WebBundle\Entity\LocalePreviewEntity	No errors.
WebBundle\Entity\LocaleBoolEntity	No errors.
WebBundle\Entity\LocaleStatusTranslateEntity	No errors.
WebBundle\Entity\FilterPageEntity	No errors.
WebBundle\Entity\FilterParamEntity	No errors.
WebBundle\Entity\FilterGroupEntity	No errors.
WebBundle\Entity\LocaleTextEntity	No errors.
FlexApp\Entity\Exhibition\ExhImageEntity	No errors.
WebBundle\Entity\ListState	No errors.
FlexApp\Entity\Collection\CollectionEntity	No errors.
WebBundle\Entity\ListType	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\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\ListApply	No errors.
FlexApp\Entity\AttachmentEntity	No errors.
FlexApp\Entity\GeoLocaleNameEntity	No errors.
FlexApp\Entity\GeoRegionEntity	No errors.
WebBundle\Entity\ListEmailGroup	No errors.
WebBundle\Entity\TransGroupsEntity	No errors.
FlexApp\Entity\LikesEntity	No errors.
FlexApp\Entity\Exhibition\ExhLineEntity	No errors.
WebBundle\Entity\BuyOrderArticleHoliday	No errors.
FlexApp\Entity\Mailing	No errors.
WebBundle\Entity\BuyOrderDelivery	No errors.

oneC entity manager

No loaded entities.

logs entity manager