Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

29 Database Queries

27 Different statements

70.22 ms Query time

1 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 c0_.`id` AS id_0, c0_.`rating` AS rating_1 FROM `collection` c0_ WHERE c0_.`id` IN (3249584, 3250102, 3255445, 3249206, 3249099, 3254668, 3249815, 3244718, 3255535, 3250571, 3248243, 3246444, 3255454, 3249361, 3256156, 3251424, 3248944, 3248044, 3250721, 3257947, 3249167, 3246447, 3249288, 3248942, 3246673, 3246344, 3246169, 3249543, 3245392, 3258625)
SELECT f0_.`id` AS id_0, f0_.`icon` AS icon_1, f0_.`icon_url` AS icon_url_2, f1_.`name_single_en` AS name_single_en_3 FROM `filters` f0_ LEFT JOIN `filter_pages` f1_ ON f0_.page_id = f1_.id WHERE f0_.`id` IN (10824)
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 = ? AND t0.`status` = ?
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 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_.`lotus_name` AS lotus_name_7, u0_.`security_field` AS security_field_8, u0_.`is_legal_entity` AS is_legal_entity_9, u0_.`companyName` AS companyName_10, u0_.`vatNumber` AS vatNumber_11, u0_.`password` AS password_12, u0_.`last_ip` AS last_ip_13, u0_.`source` AS source_14, u0_.`test` AS test_15, u0_.`bid` AS bid_16, u0_.`email` AS email_17, u0_.`salt` AS salt_18, u0_.`username` AS username_19, u0_.`roles` AS roles_20, u0_.`enabled` AS enabled_21, u0_.`confirmation_token` AS confirmation_token_22, u0_.`last_login` AS last_login_23, u0_.`created_at` AS created_at_24, u0_.`lang` AS lang_25 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 (75) 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	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;;
2	0.10 ms	SELECT c0_.`id` AS id_0, c0_.`rating` AS rating_1 FROM `collection` c0_ WHERE c0_.`id` IN (3249584, 3250102, 3255445, 3249206, 3249099, 3254668, 3249815, 3244718, 3255535, 3250571, 3248243, 3246444, 3255454, 3249361, 3256156, 3251424, 3248944, 3248044, 3250721, 3257947, 3249167, 3246447, 3249288, 3248942, 3246673, 3246344, 3246169, 3249543, 3245392, 3258625) Parameters: [] View formatted query View runnable query Explain query SELECT c0_.`id` AS id_0, c0_.`rating` AS rating_1 FROM `collection` c0_ WHERE c0_.`id` IN ( 3249584, 3250102, 3255445, 3249206, 3249099, 3254668, 3249815, 3244718, 3255535, 3250571, 3248243, 3246444, 3255454, 3249361, 3256156, 3251424, 3248944, 3248044, 3250721, 3257947, 3249167, 3246447, 3249288, 3248942, 3246673, 3246344, 3246169, 3249543, 3245392, 3258625 ) SELECT c0_.`id` AS id_0, c0_.`rating` AS rating_1 FROM `collection` c0_ WHERE c0_.`id` IN (3249584, 3250102, 3255445, 3249206, 3249099, 3254668, 3249815, 3244718, 3255535, 3250571, 3248243, 3246444, 3255454, 3249361, 3256156, 3251424, 3248944, 3248044, 3250721, 3257947, 3249167, 3246447, 3249288, 3248942, 3246673, 3246344, 3246169, 3249543, 3245392, 3258625);
3	0.08 ms	SELECT f0_.`id` AS id_0, f0_.`icon` AS icon_1, f0_.`icon_url` AS icon_url_2, f1_.`name_single_en` AS name_single_en_3 FROM `filters` f0_ LEFT JOIN `filter_pages` f1_ ON f0_.page_id = f1_.id WHERE f0_.`id` IN (10824) Parameters: [] View formatted query View runnable query Explain query SELECT f0_.`id` AS id_0, f0_.`icon` AS icon_1, f0_.`icon_url` AS icon_url_2, f1_.`name_single_en` AS name_single_en_3 FROM `filters` f0_ LEFT JOIN `filter_pages` f1_ ON f0_.page_id = f1_.id WHERE f0_.`id` IN (10824) SELECT f0_.`id` AS id_0, f0_.`icon` AS icon_1, f0_.`icon_url` AS icon_url_2, f1_.`name_single_en` AS name_single_en_3 FROM `filters` f0_ LEFT JOIN `filter_pages` f1_ ON f0_.page_id = f1_.id WHERE f0_.`id` IN (10824);
4	0.11 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: [`"2accca18062f0696a0db38a715e56e072afe496051de948d31df2624014414b2"`] 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` = '2accca18062f0696a0db38a715e56e072afe496051de948d31df2624014414b2' GROUP BY i0_.`id`;
5	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_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: [`75`] 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` = 75;
7	0.78 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 = ? AND t0.`status` = ? Parameters: [`75 1`] 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 = ? AND t0.`status` = ? 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 = 75 AND t0.`status` = 1;
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: [[ 170876 174590 1651231 1742318 1861195 3244696 3244718 3245337 3245338 3245392 3245426 3245427 3245536 3245569 3246169 3246170 3246344 3246345 3246346 3246347 3246443 3246444 3246445 3246447 3246448 3246455 3246456 3246457 3246458 3246669 3246670 3246671 3246672 3246673 3246973 3246974 3246975 3247860 3247861 3247863 3248044 3248242 3248243 3248244 3248248 3248249 3248250 3248406 3248407 3248409 3248410 3248518 3248520 3248624 3248626 3248627 3248628 3248757 3248758 3248759 3248867 3248868 3248869 3248870 3248942 3248943 3248944 3249002 3249004 3249005 3249099 3249112 3249126 3249130 3249131 3249132 3249167 3249206 3249211 3249215 3249217 3249236 3249237 3249252 3249283 3249288 3249289 3249350 3249361 3249436 3249437 3249482 3249539 3249540 3249543 3249584 3249600 3249643 3249645 3249729 3249783 3249790 3249815 3249828 3250097 3250102 3250271 3250411 3250571 3250701 3250721 3250761 3251043 3251186 3251424 3251427 3251572 3251575 3252070 3252073 3252076 3252196 3252202 3252478 3252481 3252943 3254287 3254425 3254668 3254896 3255445 3255451 3255454 3255532 3255535 3256021 3256033 3256156 3256159 3256225 ]] 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 (170876, 174590, 1651231, 1742318, 1861195, 3244696, 3244718, 3245337, 3245338, 3245392, 3245426, 3245427, 3245536, 3245569, 3246169, 3246170, 3246344, 3246345, 3246346, 3246347, 3246443, 3246444, 3246445, 3246447, 3246448, 3246455, 3246456, 3246457, 3246458, 3246669, 3246670, 3246671, 3246672, 3246673, 3246973, 3246974, 3246975, 3247860, 3247861, 3247863, 3248044, 3248242, 3248243, 3248244, 3248248, 3248249, 3248250, 3248406, 3248407, 3248409, 3248410, 3248518, 3248520, 3248624, 3248626, 3248627, 3248628, 3248757, 3248758, 3248759, 3248867, 3248868, 3248869, 3248870, 3248942, 3248943, 3248944, 3249002, 3249004, 3249005, 3249099, 3249112, 3249126, 3249130, 3249131, 3249132, 3249167, 3249206, 3249211, 3249215, 3249217, 3249236, 3249237, 3249252, 3249283, 3249288, 3249289, 3249350, 3249361, 3249436, 3249437, 3249482, 3249539, 3249540, 3249543, 3249584, 3249600, 3249643, 3249645, 3249729, 3249783, 3249790, 3249815, 3249828, 3250097, 3250102, 3250271, 3250411, 3250571, 3250701, 3250721, 3250761, 3251043, 3251186, 3251424, 3251427, 3251572, 3251575, 3252070, 3252073, 3252076, 3252196, 3252202, 3252478, 3252481, 3252943, 3254287, 3254425, 3254668, 3254896, 3255445, 3255451, 3255454, 3255532, 3255535, 3256021, 3256033, 3256156, 3256159, 3256225);
9	0.18 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.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.`url` = ? LIMIT 1 Parameters: [`"marazzi"`] 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` = 'marazzi' LIMIT 1;
11	0.09 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';
12	0.38 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: [`"2accca18062f0696a0db38a715e56e072afe496051de948d31df2624014414b2" "catalogue/marazzi"`] 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` = '2accca18062f0696a0db38a715e56e072afe496051de948d31df2624014414b2' AND v0_.`url` = 'catalogue/marazzi' AND v0_.`url` <> '/.catalog./' LIMIT 1;
13	0.10 ms	"START TRANSACTION" Parameters: [] View formatted query View runnable query Explain query "START TRANSACTION" "START TRANSACTION";
14	0.18 ms	INSERT INTO `visit` (`token`, `url`, `title`, `icon`, `visit_date`, `v_type`, `v_object_id`) VALUES (?, ?, ?, ?, ?, ?, ?) Parameters: [`1 => "2accca18062f0696a0db38a715e56e072afe496051de948d31df2624014414b2" 2 => "catalogue/marazzi" 3 => "Manufacturer Marazzi" 4 => "/img/histories/tile-catalogue.jpg?64" 5 => "2026-01-30 08:10:43" 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 ('2accca18062f0696a0db38a715e56e072afe496051de948d31df2624014414b2', 'catalogue/marazzi', 'Manufacturer Marazzi', '/img/histories/tile-catalogue.jpg?64', '2026-01-30 08:10:43', 5, 0);
15	0.11 ms	"COMMIT" Parameters: [] View formatted query View runnable query Explain query "COMMIT" "COMMIT";
16	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_.`lotus_name` AS lotus_name_7, u0_.`security_field` AS security_field_8, u0_.`is_legal_entity` AS is_legal_entity_9, u0_.`companyName` AS companyName_10, u0_.`vatNumber` AS vatNumber_11, u0_.`password` AS password_12, u0_.`last_ip` AS last_ip_13, u0_.`source` AS source_14, u0_.`test` AS test_15, u0_.`bid` AS bid_16, u0_.`email` AS email_17, u0_.`salt` AS salt_18, u0_.`username` AS username_19, u0_.`roles` AS roles_20, u0_.`enabled` AS enabled_21, u0_.`confirmation_token` AS confirmation_token_22, u0_.`last_login` AS last_login_23, u0_.`created_at` AS created_at_24, u0_.`lang` AS lang_25 FROM `user` u0_ WHERE u0_.`token` = ? LIMIT 1 Parameters: [`"2accca18062f0696a0db38a715e56e072afe496051de948d31df2624014414b2"`] 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_.`lotus_name` AS lotus_name_7, u0_.`security_field` AS security_field_8, u0_.`is_legal_entity` AS is_legal_entity_9, u0_.`companyName` AS companyName_10, u0_.`vatNumber` AS vatNumber_11, u0_.`password` AS password_12, u0_.`last_ip` AS last_ip_13, u0_.`source` AS source_14, u0_.`test` AS test_15, u0_.`bid` AS bid_16, u0_.`email` AS email_17, u0_.`salt` AS salt_18, u0_.`username` AS username_19, u0_.`roles` AS roles_20, u0_.`enabled` AS enabled_21, u0_.`confirmation_token` AS confirmation_token_22, u0_.`last_login` AS last_login_23, u0_.`created_at` AS created_at_24, u0_.`lang` AS lang_25 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_.`lotus_name` AS lotus_name_7, u0_.`security_field` AS security_field_8, u0_.`is_legal_entity` AS is_legal_entity_9, u0_.`companyName` AS companyName_10, u0_.`vatNumber` AS vatNumber_11, u0_.`password` AS password_12, u0_.`last_ip` AS last_ip_13, u0_.`source` AS source_14, u0_.`test` AS test_15, u0_.`bid` AS bid_16, u0_.`email` AS email_17, u0_.`salt` AS salt_18, u0_.`username` AS username_19, u0_.`roles` AS roles_20, u0_.`enabled` AS enabled_21, u0_.`confirmation_token` AS confirmation_token_22, u0_.`last_login` AS last_login_23, u0_.`created_at` AS created_at_24, u0_.`lang` AS lang_25 FROM `user` u0_ WHERE u0_.`token` = '2accca18062f0696a0db38a715e56e072afe496051de948d31df2624014414b2' LIMIT 1;
17	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: [`"2accca18062f0696a0db38a715e56e072afe496051de948d31df2624014414b2"`] 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` = '2accca18062f0696a0db38a715e56e072afe496051de948d31df2624014414b2' AND b1_.`status` <> 12;
18	0.09 ms	SELECT b0_.`id` AS id_0 FROM `buy_order` b0_ WHERE b0_.`token` = ? AND b0_.`status` <> 12 Parameters: [`"2accca18062f0696a0db38a715e56e072afe496051de948d31df2624014414b2"`] 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` = '2accca18062f0696a0db38a715e56e072afe496051de948d31df2624014414b2' AND b0_.`status` <> 12;
19	0.41 ms	SELECT COUNT(v0_.`id`) AS sclr_0 FROM `visit` v0_ WHERE v0_.`token` = ? AND v0_.`url` <> '/.catalog./' Parameters: [`"2accca18062f0696a0db38a715e56e072afe496051de948d31df2624014414b2"`] 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` = '2accca18062f0696a0db38a715e56e072afe496051de948d31df2624014414b2' AND v0_.`url` <> '/.catalog./';
20	0.09 ms	SELECT COUNT(i0_.`id`) AS sclr_0 FROM `idea` i1_ INNER JOIN idea_interior i2_ ON i1_.id = i2_.idea_id INNER JOIN `interior` i0_ ON i0_.id = i2_.interior_id WHERE i1_.`token` = ? Parameters: [`"2accca18062f0696a0db38a715e56e072afe496051de948d31df2624014414b2"`] 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` = '2accca18062f0696a0db38a715e56e072afe496051de948d31df2624014414b2';
21	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';
22	0.42 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: [`"2accca18062f0696a0db38a715e56e072afe496051de948d31df2624014414b2"`] 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` = '2accca18062f0696a0db38a715e56e072afe496051de948d31df2624014414b2' LIMIT 1;
23	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';
24	53.19 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;
25	0.24 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;
26	0.20 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; ;
27	1.08 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;
28	10.51 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 (75) 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 (75) 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 (75) GROUP BY c0_.`id` ORDER BY c0_.`name` ASC, c0_.`publish_date` ASC;
29	0.39 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';

unbuffered connection

No database queries were performed.

oneC connection

No database queries were performed.

logs connection

No database queries were performed.

Database Connections

Name	Service
default	doctrine.dbal.default_connection
unbuffered	doctrine.dbal.unbuffered_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	The field WebBundle\Entity\User#foreignAlias is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity WebBundle\Entity\UserForeignAlias#user does not contain the required 'inversedBy="foreignAlias"' attribute. The field WebBundle\Entity\User#socialNetwork is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity WebBundle\Entity\SocialNetwork#user does not contain the required 'inversedBy="socialNetwork"' attribute.
WebBundle\Entity\BuyOrder	No errors.
FlexApp\Entity\InvitationEmailDeliveryStats	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\CurrencyRate	No errors.
WebBundle\Entity\SampleEntity	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\Visit	No errors.
FlexApp\Entity\CountryEntity	No errors.
WebBundle\Entity\OrderAddress	No errors.
WebBundle\Entity\OrderHistory	No errors.
WebBundle\Entity\OrderPayment	No errors.
WebBundle\Entity\ListVat	No errors.
WebBundle\Entity\WarehouseEntity	No errors.
WebBundle\Entity\BuyOrderManager	No errors.
WebBundle\Entity\ItalianMunicipalityEntity	No errors.
FlexApp\Entity\InterviewEntity	No errors.
WebBundle\Entity\UserForeignAlias	No errors.
WebBundle\Entity\TransExEntity	No errors.
WebBundle\Entity\Participant	No errors.
WebBundle\Entity\SocialNetwork	No errors.
FlexApp\Entity\Mailing	No errors.
WebBundle\Entity\BuyOrderDelivery	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\ListSink	No errors.
WebBundle\Entity\ListMethLaying	No errors.
WebBundle\Entity\ArticleDetail	No errors.
WebBundle\Entity\ListDraw	No errors.
FlexApp\Entity\Article\ArticleDescriptionEntity	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\NameEntity	No errors.
FlexApp\Entity\StaticContent\StaticContentEntity	No errors.
FlexApp\Entity\DeclinationCountryEntity	No errors.
FlexApp\Entity\PhoneMaskEntity	No errors.
FlexApp\Entity\ZipMaskEntity	No errors.
FlexApp\Entity\LocaleEntity	No errors.

oneC entity manager

No loaded entities.

logs entity manager

No loaded entities.

Symfony Profiler

https://dev5.tile.expert/en-us/catalogue/marazzi

Configuration Settings

Theme

Page Width

Query Metrics

Queries

default connection

unbuffered connection

oneC connection

logs connection

Database Connections

Entity Managers

Second Level Cache

Entities Mapping

default entity manager

oneC entity manager

logs entity manager