Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

25 Database Queries

14 Different statements

151.09 ms Query time

1 Invalid entities

Queries

Group similar statements

default connection


SELECT b0_.`id` AS id_0, b0_.`mirror` AS mirror_1, b0_.`unid` AS unid_2, b0_.`unid_vat_player` AS unid_vat_player_3, b0_.`hash` AS hash_4, b0_.`number` AS number_5, b0_.`number_donor` AS number_donor_6, b0_.`token` AS token_7, b0_.`email` AS email_8, b0_.`email_send` AS email_send_9, b0_.`status` AS status_10, b0_.`step` AS step_11, b0_.`name` AS name_12, b0_.`adyen` AS adyen_13, b0_.`tax_number` AS tax_number_14, b0_.`vat_type` AS vat_type_15, b0_.`vat_number` AS vat_number_16, b0_.`vat_percent` AS vat_percent_17, b0_.`discount` AS discount_18, b0_.`address_equal` AS address_equal_19, b0_.`full_payment_date` AS full_payment_date_20, b0_.`delivery_index` AS delivery_index_21, b0_.`personal_data_agree` AS personal_data_agree_22, b0_.`delivery_region` AS delivery_region_23, b0_.`delivery_city` AS delivery_city_24, b0_.`delivery_address` AS delivery_address_25, b0_.`delivery_building` AS delivery_building_26, b0_.`delivery_apartment_office` AS delivery_apartment_office_27, b0_.`delivery_phone_code` AS delivery_phone_code_28, b0_.`delivery_phone` AS delivery_phone_29, b0_.`where_delivered` AS where_delivered_30, b0_.`warehouse_data` AS warehouse_data_31, b0_.`ref_number` AS ref_number_32, b0_.`sex` AS sex_33, b0_.`client_name` AS client_name_34, b0_.`client_surname` AS client_surname_35, b0_.`company_name` AS company_name_36, b0_.`description` AS description_37, b0_.`pay_type` AS pay_type_38, b0_.`pay_date_execution` AS pay_date_execution_39, b0_.`accept_pay` AS accept_pay_40, b0_.`cancel_date` AS cancel_date_41, b0_.`create_date` AS create_date_42, b0_.`update_date` AS update_date_43, b0_.`marker_reset` AS marker_reset_44, b0_.`marker_change` AS marker_change_45, b0_.`marker_delivery_change` AS marker_delivery_change_46, b0_.`locale` AS locale_47, b0_.`currency` AS currency_48, b0_.`payment_euro` AS payment_euro_49, b0_.`cur_rate` AS cur_rate_50, b0_.`measure` AS measure_51, b0_.`tracking_number` AS tracking_number_52, b0_.`carrier_name` AS carrier_name_53, b0_.`carrier_contact_data` AS carrier_contact_data_54, b0_.`write_off_reason` AS write_off_reason_55, b0_.`offset_explain` AS offset_explain_56, b0_.`weight_gross` AS weight_gross_57, b0_.`weight_limit` AS weight_limit_58, b0_.`remember` AS remember_59, b0_.`bank_details` AS bank_details_60, b0_.`recipient_number` AS recipient_number_61, b0_.`date_payment_back` AS date_payment_back_62, b0_.`send_create_1c` AS send_create_1c_63, b0_.`bank_transfer_requested` AS bank_transfer_requested_64, b0_.`marker_test` AS marker_test_65, b0_.`no_change` AS no_change_66, b0_.`kladr_id` AS kladr_id_67, b0_.`okato_id` AS okato_id_68, b0_.`product_review` AS product_review_69, b0_.`entrance_review` AS entrance_review_70, b0_.`send_review` AS send_review_71, b0_.`reserve` AS reserve_72, b0_.`key_email` AS key_email_73, b0_.`process` AS process_74, b0_.`spec_price` AS spec_price_75, b0_.`compensation` AS compensation_76, b0_.`is_refunded` AS is_refunded_77, b0_.`check_breakdown` AS check_breakdown_78, b0_.`truspilot_review_requested` AS truspilot_review_requested_79, b0_.`collection_review_requested` AS collection_review_requested_80, b0_.`prohibit_send_review_request` AS prohibit_send_review_request_81, b1_.`id` AS id_82, b1_.`type` AS type_83, b1_.`article_time_type` AS article_time_type_84, b1_.`code` AS code_85, b1_.`packaging_count` AS packaging_count_86, b1_.`packaging` AS packaging_87, b1_.`pallet` AS pallet_88, b1_.`multiple_pallet` AS multiple_pallet_89, b1_.`weight` AS weight_90, b1_.`amount` AS amount_91, b1_.`price` AS price_92, b1_.`price_eur` AS price_eur_93, b1_.`currency` AS currency_94, b1_.`measure` AS measure_95, b1_.`delivery_time_min` AS delivery_time_min_96, b1_.`delivery_time_max` AS delivery_time_max_97, b1_.`delivery_time_min_faster` AS delivery_time_min_faster_98, b1_.`delivery_time_max_faster` AS delivery_time_max_faster_99, b1_.`delivery_time_confirm_min` AS delivery_time_confirm_min_100, b1_.`delivery_time_confirm_max` AS delivery_time_confirm_max_101, b1_.`holiday` AS holiday_102, b1_.`sample_format` AS sample_format_103, b1_.`sample_type` AS sample_type_104, b1_.`sample_code` AS sample_code_105, b1_.`swimming_pool` AS swimming_pool_106, b1_.`add_time` AS add_time_107, a2_.`id` AS id_108, a2_.`code` AS code_109, a2_.`name` AS name_110, a2_.`alternate_name` AS alternate_name_111, a2_.`urla` AS urla_112, a2_.`file` AS file_113, a2_.`size_x` AS size_x_114, a2_.`size_y` AS size_y_115, a2_.`size_gb_x` AS size_gb_x_116, a2_.`size_gb_y` AS size_gb_y_117, a2_.`size_tessera` AS size_tessera_118, a2_.`file_size1_x` AS file_size1_x_119, a2_.`file_size1_y` AS file_size1_y_120, a2_.`file_size2_x` AS file_size2_x_121, a2_.`file_size2_y` AS file_size2_y_122, a2_.`file_size3_x` AS file_size3_x_123, a2_.`file_size3_y` AS file_size3_y_124, a2_.`file_size500_x` AS file_size500_x_125, a2_.`file_size500_y` AS file_size500_y_126, a2_.`file_size740_x` AS file_size740_x_127, a2_.`file_size740_y` AS file_size740_y_128, a2_.`file_size8_x` AS file_size8_x_129, a2_.`file_size8_y` AS file_size8_y_130, a2_.`pallet` AS pallet_131, a2_.`pallet_ft` AS pallet_ft_132, a2_.`type_constraint` AS type_constraint_133, a2_.`multiple_pallet` AS multiple_pallet_134, a2_.`min_order` AS min_order_135, a2_.`price_euro` AS price_euro_136, a2_.`price_mq_euro` AS price_mq_euro_137, a2_.`price_euro_de` AS price_euro_de_138, a2_.`price_mq_euro_de` AS price_mq_euro_de_139, a2_.`price_euro_at` AS price_euro_at_140, a2_.`price_mq_euro_at` AS price_mq_euro_at_141, a2_.`price_euro_fi` AS price_euro_fi_142, a2_.`price_mq_euro_fi` AS price_mq_euro_fi_143, a2_.`price_euro_fr` AS price_euro_fr_144, a2_.`price_mq_euro_fr` AS price_mq_euro_fr_145, a2_.`price_euro_it` AS price_euro_it_146, a2_.`price_mq_euro_it` AS price_mq_euro_it_147, a2_.`price_euro_be` AS price_euro_be_148, a2_.`price_mq_euro_be` AS price_mq_euro_be_149, a2_.`price_euro_ie` AS price_euro_ie_150, a2_.`price_mq_euro_ie` AS price_mq_euro_ie_151, a2_.`price_euro_nl` AS price_euro_nl_152, a2_.`price_mq_euro_nl` AS price_mq_euro_nl_153, a2_.`price_euro_es` AS price_euro_es_154, a2_.`price_mq_euro_es` AS price_mq_euro_es_155, a2_.`price_rub` AS price_rub_156, a2_.`price_rue` AS price_rue_157, a2_.`price_mq_rub` AS price_mq_rub_158, a2_.`price_mq_rue` AS price_mq_rue_159, a2_.`price_gbp` AS price_gbp_160, a2_.`price_gbe` AS price_gbe_161, a2_.`price_mq_gbp` AS price_mq_gbp_162, a2_.`price_mq_gbe` AS price_mq_gbe_163, a2_.`price_usd` AS price_usd_164, a2_.`price_use` AS price_use_165, a2_.`price_fq_usd` AS price_fq_usd_166, a2_.`price_fq_use` AS price_fq_use_167, a2_.`price_mq_usd` AS price_mq_usd_168, a2_.`price_mq_use` AS price_mq_use_169, a2_.`price_chf` AS price_chf_170, a2_.`price_che` AS price_che_171, a2_.`price_mq_chf` AS price_mq_chf_172, a2_.`price_mq_che` AS price_mq_che_173, a2_.`price_sek` AS price_sek_174, a2_.`price_see` AS price_see_175, a2_.`price_mq_sek` AS price_mq_sek_176, a2_.`price_mq_see` AS price_mq_see_177, a2_.`price_dkk` AS price_dkk_178, a2_.`price_dke` AS price_dke_179, a2_.`price_mq_dkk` AS price_mq_dkk_180, a2_.`price_mq_dke` AS price_mq_dke_181, a2_.`price_nok` AS price_nok_182, a2_.`price_noe` AS price_noe_183, a2_.`price_mq_nok` AS price_mq_nok_184, a2_.`price_mq_noe` AS price_mq_noe_185, a2_.`price_pln` AS price_pln_186, a2_.`price_ple` AS price_ple_187, a2_.`price_mq_pln` AS price_mq_pln_188, a2_.`price_mq_ple` AS price_mq_ple_189, a2_.`price_cad` AS price_cad_190, a2_.`price_cae` AS price_cae_191, a2_.`price_fq_cad` AS price_fq_cad_192, a2_.`price_fq_cae` AS price_fq_cae_193, a2_.`price_mq_cad` AS price_mq_cad_194, a2_.`price_mq_cae` AS price_mq_cae_195, a2_.`thick` AS thick_196, a2_.`weight` AS weight_197, a2_.`packaging_count` AS packaging_count_198, a2_.`packaging_count_ft` AS packaging_count_ft_199, a2_.`packaging_count_pc` AS packaging_count_pc_200, a2_.`m2one_ps` AS m2one_ps_201, a2_.`description_ru` AS description_ru_202, a2_.`description_en` AS description_en_203, a2_.`description_it` AS description_it_204, a2_.`description_es` AS description_es_205, a2_.`description_fr` AS description_fr_206, a2_.`description_de` AS description_de_207, a2_.`description_pt` AS description_pt_208, a2_.`description_pl` AS description_pl_209, a2_.`description_nl` AS description_nl_210, a2_.`description_fi` AS description_fi_211, a2_.`description_ua` AS description_ua_212, a2_.`description_sv` AS description_sv_213, a2_.`description_no` AS description_no_214, a2_.`description_da` AS description_da_215, a2_.`description_cn` AS description_cn_216, a2_.`scheme` AS scheme_217, a2_.`sale_date` AS sale_date_218, a2_.`thin_granite` AS thin_granite_219, a2_.`glazed_granite` AS glazed_granite_220, a2_.`pei` AS pei_221, a2_.`is_grouped` AS is_grouped_222, a2_.`is_rotate` AS is_rotate_223, a2_.`price_prx` AS price_prx_224, a2_.`background_white` AS background_white_225, a2_.`border_grey` AS border_grey_226, a2_.`is_edit` AS is_edit_227, a2_.`edited_at` AS edited_at_228, a2_.`comment` AS comment_229, a2_.`file_edit` AS file_edit_230, a2_.`image_setting` AS image_setting_231, a2_.`file_w` AS file_w_232, a2_.`file_h` AS file_h_233, a2_.`file_w4000` AS file_w4000_234, a2_.`file_h4000` AS file_h4000_235, a2_.`size_z` AS size_z_236, a2_.`size_gb_z` AS size_gb_z_237, a2_.`repeat_number` AS repeat_number_238, a2_.`size_big` AS size_big_239, a2_.`delivery_suspended` AS delivery_suspended_240, a2_.`poddon_x` AS poddon_x_241, a2_.`poddon_y` AS poddon_y_242, a2_.`poddon_z` AS poddon_z_243, a2_.`module` AS module_244, a2_.`tessera_size_x` AS tessera_size_x_245, a2_.`tessera_size_y` AS tessera_size_y_246, a2_.`tessera_size_z` AS tessera_size_z_247, a2_.`poddon_count` AS poddon_count_248, a2_.`poddon_weight` AS poddon_weight_249, a2_.`added_to_cart` AS added_to_cart_250, a2_.`sold_out` AS sold_out_251, a2_.`sold_out_vol` AS sold_out_vol_252, a2_.`swimming_pool` AS swimming_pool_253, a2_.`can_select_substrate` AS can_select_substrate_254, a2_.`designer` AS designer_255, a2_.`designer_id` AS designer_id_256, a2_.`mosaic_effect` AS mosaic_effect_257, a2_.`not_sample` AS not_sample_258, a2_.`express_sample` AS express_sample_259, a2_.`description_edit` AS description_edit_260, a2_.`comment_scheme_image` AS comment_scheme_image_261, a2_.`variant_image` AS variant_image_262, a2_.`square` AS square_263, a2_.`fix_big_size` AS fix_big_size_264, a2_.`overflow_sink` AS overflow_sink_265, a2_.`drain_size_sink` AS drain_size_sink_266, a2_.`faucet_hole_sink` AS faucet_hole_sink_267, a2_.`rotate` AS rotate_268, a2_.`dyed_in_mass` AS dyed_in_mass_269, a2_.`durability_class` AS durability_class_270, a2_.`is_comment_ru` AS is_comment_ru_271, a2_.`file_rotation` AS file_rotation_272, a2_.`created_at` AS created_at_273, a2_.`updated_at` AS updated_at_274, a3_.`id` AS id_275, a3_.`amount` AS amount_276, a3_.`amount_ft` AS amount_ft_277, a3_.`fold` AS fold_278, a3_.`price` AS price_279, a3_.`price_euro` AS price_euro_280, a3_.`price_euro_de` AS price_euro_de_281, a3_.`price_euro_at` AS price_euro_at_282, a3_.`price_euro_fi` AS price_euro_fi_283, a3_.`price_euro_fr` AS price_euro_fr_284, a3_.`price_euro_it` AS price_euro_it_285, a3_.`price_euro_be` AS price_euro_be_286, a3_.`price_euro_ie` AS price_euro_ie_287, a3_.`price_euro_nl` AS price_euro_nl_288, a3_.`price_euro_es` AS price_euro_es_289, a3_.`price_rub` AS price_rub_290, a3_.`price_rue` AS price_rue_291, a3_.`price_gbp` AS price_gbp_292, a3_.`price_gbe` AS price_gbe_293, a3_.`price_usd` AS price_usd_294, a3_.`price_use` AS price_use_295, a3_.`price_fq_usd` AS price_fq_usd_296, a3_.`price_fq_use` AS price_fq_use_297, a3_.`price_chf` AS price_chf_298, a3_.`price_che` AS price_che_299, a3_.`price_sek` AS price_sek_300, a3_.`price_see` AS price_see_301, a3_.`price_dkk` AS price_dkk_302, a3_.`price_dke` AS price_dke_303, a3_.`price_nok` AS price_nok_304, a3_.`price_noe` AS price_noe_305, a3_.`price_pln` AS price_pln_306, a3_.`price_ple` AS price_ple_307, a3_.`price_cad` AS price_cad_308, a3_.`price_cae` AS price_cae_309, a3_.`price_fq_cad` AS price_fq_cad_310, a3_.`price_fq_cae` AS price_fq_cae_311, a3_.`del` AS del_312, b0_.user_id AS user_id_313, b0_.warehouse AS warehouse_314, b0_.address_recipient AS address_recipient_315, b0_.address_payer AS address_payer_316, b0_.delivery_country AS delivery_country_317, b0_.mailing_id AS mailing_id_318, b0_.buy_order_manager AS buy_order_manager_319, b1_.buy_order_id AS buy_order_id_320, b1_.article_id AS article_id_321, a2_.collection AS collection_322, a2_.newCollection AS newCollection_323, a2_.type AS type_324, a2_.measure AS measure_325, a2_.surface AS surface_326, a2_.pr_status AS pr_status_327, a2_.category_price AS category_price_328, a2_.edge_type AS edge_type_329, a2_.using AS using_330, a2_.shape AS shape_331, a2_.material AS material_332, a2_.delivery AS delivery_333, a2_.sliding AS sliding_334, a2_.off_shade AS off_shade_335, a2_.style AS style_336, a2_.repeat_draw AS repeat_draw_337, a2_.measurement_size AS measurement_size_338, a2_.installation_type AS installation_type_339, a2_.meth_laying AS meth_laying_340, a2_.draw AS draw_341, a3_.article AS article_342 FROM `buy_order` b0_ LEFT JOIN `buy_order_article` b1_ ON b0_.id = b1_.buy_order_id LEFT JOIN `article` a2_ ON b1_.article_id = a2_.id LEFT JOIN `list_country` l4_ ON b0_.delivery_country = l4_.id LEFT JOIN `article_price_discount` a3_ ON a2_.id = a3_.article AND (a3_.`price_euro` <> 0) LEFT JOIN `user` u5_ ON b0_.user_id = u5_.id WHERE b0_.`token` = '9552f540dd43d672b5698cbe02444caddadce7f4fd925265a10a6e6c2fa24dc9' AND b0_.`status` <> 12 ORDER BY b0_.`create_date` DESC, b1_.`id` DESC, a3_.`amount` DESC
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 t0.`id` AS id_1, t0.`token` AS token_2, t0.`name` AS name_3, t0.`create_date` AS create_date_4, t0.`update_date` AS update_date_5, t0.`process` AS process_6, t0.user_id AS user_id_7 FROM `idea` t0 WHERE t0.`token` = ? ORDER BY t0.`update_date` DESC
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 f0_.`id` AS id_0 FROM `geo_country` g1_ LEFT JOIN factory_hide_countries f2_ ON g1_.id = f2_.country_id LEFT JOIN `factory` f0_ ON f0_.id = f2_.factory_id WHERE g1_.`code` = ?
SELECT c0_.`id` AS id_0, c0_.`url` AS url_1, c0_.`code` AS code_2, c0_.`name` AS name_3, c0_.`alternate_name` AS alternate_name_4, c0_.`name_full` AS name_full_5, f1_.`id` AS id_6, f1_.`url` AS url_7, f1_.`unid` AS unid_8, f2_.`id` AS id_9, f1_.`url` AS url_10, f1_.`name` AS name_11, (SELECT COUNT(p3_.`star`) AS sclr_13 FROM `product_reviews_cache` p3_ WHERE p3_.`sku` = c0_.`code`) AS sclr_12, (SELECT SUM(p4_.`star`) AS sclr_15 FROM `product_reviews_cache` p4_ WHERE p4_.`sku` = c0_.`code`) AS sclr_14 FROM `collection` c0_ INNER JOIN `factory` f1_ ON c0_.factory = f1_.id INNER JOIN `filters` f2_ ON f1_.filter = f2_.id INNER JOIN `list_country` l5_ ON f1_.country = l5_.id LEFT JOIN `locale_url` l6_ ON f2_.id = l6_.filter_id LEFT JOIN `filter_pages` f7_ ON f2_.page_id = f7_.id WHERE f1_.filter IS NOT NULL AND c0_.factory <> '' AND f1_.`status` = ? AND 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 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 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.41 ms	SELECT b0_.`id` AS id_0, b0_.`mirror` AS mirror_1, b0_.`unid` AS unid_2, b0_.`unid_vat_player` AS unid_vat_player_3, b0_.`hash` AS hash_4, b0_.`number` AS number_5, b0_.`number_donor` AS number_donor_6, b0_.`token` AS token_7, b0_.`email` AS email_8, b0_.`email_send` AS email_send_9, b0_.`status` AS status_10, b0_.`step` AS step_11, b0_.`name` AS name_12, b0_.`adyen` AS adyen_13, b0_.`tax_number` AS tax_number_14, b0_.`vat_type` AS vat_type_15, b0_.`vat_number` AS vat_number_16, b0_.`vat_percent` AS vat_percent_17, b0_.`discount` AS discount_18, b0_.`address_equal` AS address_equal_19, b0_.`full_payment_date` AS full_payment_date_20, b0_.`delivery_index` AS delivery_index_21, b0_.`personal_data_agree` AS personal_data_agree_22, b0_.`delivery_region` AS delivery_region_23, b0_.`delivery_city` AS delivery_city_24, b0_.`delivery_address` AS delivery_address_25, b0_.`delivery_building` AS delivery_building_26, b0_.`delivery_apartment_office` AS delivery_apartment_office_27, b0_.`delivery_phone_code` AS delivery_phone_code_28, b0_.`delivery_phone` AS delivery_phone_29, b0_.`where_delivered` AS where_delivered_30, b0_.`warehouse_data` AS warehouse_data_31, b0_.`ref_number` AS ref_number_32, b0_.`sex` AS sex_33, b0_.`client_name` AS client_name_34, b0_.`client_surname` AS client_surname_35, b0_.`company_name` AS company_name_36, b0_.`description` AS description_37, b0_.`pay_type` AS pay_type_38, b0_.`pay_date_execution` AS pay_date_execution_39, b0_.`accept_pay` AS accept_pay_40, b0_.`cancel_date` AS cancel_date_41, b0_.`create_date` AS create_date_42, b0_.`update_date` AS update_date_43, b0_.`marker_reset` AS marker_reset_44, b0_.`marker_change` AS marker_change_45, b0_.`marker_delivery_change` AS marker_delivery_change_46, b0_.`locale` AS locale_47, b0_.`currency` AS currency_48, b0_.`payment_euro` AS payment_euro_49, b0_.`cur_rate` AS cur_rate_50, b0_.`measure` AS measure_51, b0_.`tracking_number` AS tracking_number_52, b0_.`carrier_name` AS carrier_name_53, b0_.`carrier_contact_data` AS carrier_contact_data_54, b0_.`write_off_reason` AS write_off_reason_55, b0_.`offset_explain` AS offset_explain_56, b0_.`weight_gross` AS weight_gross_57, b0_.`weight_limit` AS weight_limit_58, b0_.`remember` AS remember_59, b0_.`bank_details` AS bank_details_60, b0_.`recipient_number` AS recipient_number_61, b0_.`date_payment_back` AS date_payment_back_62, b0_.`send_create_1c` AS send_create_1c_63, b0_.`bank_transfer_requested` AS bank_transfer_requested_64, b0_.`marker_test` AS marker_test_65, b0_.`no_change` AS no_change_66, b0_.`kladr_id` AS kladr_id_67, b0_.`okato_id` AS okato_id_68, b0_.`product_review` AS product_review_69, b0_.`entrance_review` AS entrance_review_70, b0_.`send_review` AS send_review_71, b0_.`reserve` AS reserve_72, b0_.`key_email` AS key_email_73, b0_.`process` AS process_74, b0_.`spec_price` AS spec_price_75, b0_.`compensation` AS compensation_76, b0_.`is_refunded` AS is_refunded_77, b0_.`check_breakdown` AS check_breakdown_78, b0_.`truspilot_review_requested` AS truspilot_review_requested_79, b0_.`collection_review_requested` AS collection_review_requested_80, b0_.`prohibit_send_review_request` AS prohibit_send_review_request_81, b1_.`id` AS id_82, b1_.`type` AS type_83, b1_.`article_time_type` AS article_time_type_84, b1_.`code` AS code_85, b1_.`packaging_count` AS packaging_count_86, b1_.`packaging` AS packaging_87, b1_.`pallet` AS pallet_88, b1_.`multiple_pallet` AS multiple_pallet_89, b1_.`weight` AS weight_90, b1_.`amount` AS amount_91, b1_.`price` AS price_92, b1_.`price_eur` AS price_eur_93, b1_.`currency` AS currency_94, b1_.`measure` AS measure_95, b1_.`delivery_time_min` AS delivery_time_min_96, b1_.`delivery_time_max` AS delivery_time_max_97, b1_.`delivery_time_min_faster` AS delivery_time_min_faster_98, b1_.`delivery_time_max_faster` AS delivery_time_max_faster_99, b1_.`delivery_time_confirm_min` AS delivery_time_confirm_min_100, b1_.`delivery_time_confirm_max` AS delivery_time_confirm_max_101, b1_.`holiday` AS holiday_102, b1_.`sample_format` AS sample_format_103, b1_.`sample_type` AS sample_type_104, b1_.`sample_code` AS sample_code_105, b1_.`swimming_pool` AS swimming_pool_106, b1_.`add_time` AS add_time_107, a2_.`id` AS id_108, a2_.`code` AS code_109, a2_.`name` AS name_110, a2_.`alternate_name` AS alternate_name_111, a2_.`urla` AS urla_112, a2_.`file` AS file_113, a2_.`size_x` AS size_x_114, a2_.`size_y` AS size_y_115, a2_.`size_gb_x` AS size_gb_x_116, a2_.`size_gb_y` AS size_gb_y_117, a2_.`size_tessera` AS size_tessera_118, a2_.`file_size1_x` AS file_size1_x_119, a2_.`file_size1_y` AS file_size1_y_120, a2_.`file_size2_x` AS file_size2_x_121, a2_.`file_size2_y` AS file_size2_y_122, a2_.`file_size3_x` AS file_size3_x_123, a2_.`file_size3_y` AS file_size3_y_124, a2_.`file_size500_x` AS file_size500_x_125, a2_.`file_size500_y` AS file_size500_y_126, a2_.`file_size740_x` AS file_size740_x_127, a2_.`file_size740_y` AS file_size740_y_128, a2_.`file_size8_x` AS file_size8_x_129, a2_.`file_size8_y` AS file_size8_y_130, a2_.`pallet` AS pallet_131, a2_.`pallet_ft` AS pallet_ft_132, a2_.`type_constraint` AS type_constraint_133, a2_.`multiple_pallet` AS multiple_pallet_134, a2_.`min_order` AS min_order_135, a2_.`price_euro` AS price_euro_136, a2_.`price_mq_euro` AS price_mq_euro_137, a2_.`price_euro_de` AS price_euro_de_138, a2_.`price_mq_euro_de` AS price_mq_euro_de_139, a2_.`price_euro_at` AS price_euro_at_140, a2_.`price_mq_euro_at` AS price_mq_euro_at_141, a2_.`price_euro_fi` AS price_euro_fi_142, a2_.`price_mq_euro_fi` AS price_mq_euro_fi_143, a2_.`price_euro_fr` AS price_euro_fr_144, a2_.`price_mq_euro_fr` AS price_mq_euro_fr_145, a2_.`price_euro_it` AS price_euro_it_146, a2_.`price_mq_euro_it` AS price_mq_euro_it_147, a2_.`price_euro_be` AS price_euro_be_148, a2_.`price_mq_euro_be` AS price_mq_euro_be_149, a2_.`price_euro_ie` AS price_euro_ie_150, a2_.`price_mq_euro_ie` AS price_mq_euro_ie_151, a2_.`price_euro_nl` AS price_euro_nl_152, a2_.`price_mq_euro_nl` AS price_mq_euro_nl_153, a2_.`price_euro_es` AS price_euro_es_154, a2_.`price_mq_euro_es` AS price_mq_euro_es_155, a2_.`price_rub` AS price_rub_156, a2_.`price_rue` AS price_rue_157, a2_.`price_mq_rub` AS price_mq_rub_158, a2_.`price_mq_rue` AS price_mq_rue_159, a2_.`price_gbp` AS price_gbp_160, a2_.`price_gbe` AS price_gbe_161, a2_.`price_mq_gbp` AS price_mq_gbp_162, a2_.`price_mq_gbe` AS price_mq_gbe_163, a2_.`price_usd` AS price_usd_164, a2_.`price_use` AS price_use_165, a2_.`price_fq_usd` AS price_fq_usd_166, a2_.`price_fq_use` AS price_fq_use_167, a2_.`price_mq_usd` AS price_mq_usd_168, a2_.`price_mq_use` AS price_mq_use_169, a2_.`price_chf` AS price_chf_170, a2_.`price_che` AS price_che_171, a2_.`price_mq_chf` AS price_mq_chf_172, a2_.`price_mq_che` AS price_mq_che_173, a2_.`price_sek` AS price_sek_174, a2_.`price_see` AS price_see_175, a2_.`price_mq_sek` AS price_mq_sek_176, a2_.`price_mq_see` AS price_mq_see_177, a2_.`price_dkk` AS price_dkk_178, a2_.`price_dke` AS price_dke_179, a2_.`price_mq_dkk` AS price_mq_dkk_180, a2_.`price_mq_dke` AS price_mq_dke_181, a2_.`price_nok` AS price_nok_182, a2_.`price_noe` AS price_noe_183, a2_.`price_mq_nok` AS price_mq_nok_184, a2_.`price_mq_noe` AS price_mq_noe_185, a2_.`price_pln` AS price_pln_186, a2_.`price_ple` AS price_ple_187, a2_.`price_mq_pln` AS price_mq_pln_188, a2_.`price_mq_ple` AS price_mq_ple_189, a2_.`price_cad` AS price_cad_190, a2_.`price_cae` AS price_cae_191, a2_.`price_fq_cad` AS price_fq_cad_192, a2_.`price_fq_cae` AS price_fq_cae_193, a2_.`price_mq_cad` AS price_mq_cad_194, a2_.`price_mq_cae` AS price_mq_cae_195, a2_.`thick` AS thick_196, a2_.`weight` AS weight_197, a2_.`packaging_count` AS packaging_count_198, a2_.`packaging_count_ft` AS packaging_count_ft_199, a2_.`packaging_count_pc` AS packaging_count_pc_200, a2_.`m2one_ps` AS m2one_ps_201, a2_.`description_ru` AS description_ru_202, a2_.`description_en` AS description_en_203, a2_.`description_it` AS description_it_204, a2_.`description_es` AS description_es_205, a2_.`description_fr` AS description_fr_206, a2_.`description_de` AS description_de_207, a2_.`description_pt` AS description_pt_208, a2_.`description_pl` AS description_pl_209, a2_.`description_nl` AS description_nl_210, a2_.`description_fi` AS description_fi_211, a2_.`description_ua` AS description_ua_212, a2_.`description_sv` AS description_sv_213, a2_.`description_no` AS description_no_214, a2_.`description_da` AS description_da_215, a2_.`description_cn` AS description_cn_216, a2_.`scheme` AS scheme_217, a2_.`sale_date` AS sale_date_218, a2_.`thin_granite` AS thin_granite_219, a2_.`glazed_granite` AS glazed_granite_220, a2_.`pei` AS pei_221, a2_.`is_grouped` AS is_grouped_222, a2_.`is_rotate` AS is_rotate_223, a2_.`price_prx` AS price_prx_224, a2_.`background_white` AS background_white_225, a2_.`border_grey` AS border_grey_226, a2_.`is_edit` AS is_edit_227, a2_.`edited_at` AS edited_at_228, a2_.`comment` AS comment_229, a2_.`file_edit` AS file_edit_230, a2_.`image_setting` AS image_setting_231, a2_.`file_w` AS file_w_232, a2_.`file_h` AS file_h_233, a2_.`file_w4000` AS file_w4000_234, a2_.`file_h4000` AS file_h4000_235, a2_.`size_z` AS size_z_236, a2_.`size_gb_z` AS size_gb_z_237, a2_.`repeat_number` AS repeat_number_238, a2_.`size_big` AS size_big_239, a2_.`delivery_suspended` AS delivery_suspended_240, a2_.`poddon_x` AS poddon_x_241, a2_.`poddon_y` AS poddon_y_242, a2_.`poddon_z` AS poddon_z_243, a2_.`module` AS module_244, a2_.`tessera_size_x` AS tessera_size_x_245, a2_.`tessera_size_y` AS tessera_size_y_246, a2_.`tessera_size_z` AS tessera_size_z_247, a2_.`poddon_count` AS poddon_count_248, a2_.`poddon_weight` AS poddon_weight_249, a2_.`added_to_cart` AS added_to_cart_250, a2_.`sold_out` AS sold_out_251, a2_.`sold_out_vol` AS sold_out_vol_252, a2_.`swimming_pool` AS swimming_pool_253, a2_.`can_select_substrate` AS can_select_substrate_254, a2_.`designer` AS designer_255, a2_.`designer_id` AS designer_id_256, a2_.`mosaic_effect` AS mosaic_effect_257, a2_.`not_sample` AS not_sample_258, a2_.`express_sample` AS express_sample_259, a2_.`description_edit` AS description_edit_260, a2_.`comment_scheme_image` AS comment_scheme_image_261, a2_.`variant_image` AS variant_image_262, a2_.`square` AS square_263, a2_.`fix_big_size` AS fix_big_size_264, a2_.`overflow_sink` AS overflow_sink_265, a2_.`drain_size_sink` AS drain_size_sink_266, a2_.`faucet_hole_sink` AS faucet_hole_sink_267, a2_.`rotate` AS rotate_268, a2_.`dyed_in_mass` AS dyed_in_mass_269, a2_.`durability_class` AS durability_class_270, a2_.`is_comment_ru` AS is_comment_ru_271, a2_.`file_rotation` AS file_rotation_272, a2_.`created_at` AS created_at_273, a2_.`updated_at` AS updated_at_274, a3_.`id` AS id_275, a3_.`amount` AS amount_276, a3_.`amount_ft` AS amount_ft_277, a3_.`fold` AS fold_278, a3_.`price` AS price_279, a3_.`price_euro` AS price_euro_280, a3_.`price_euro_de` AS price_euro_de_281, a3_.`price_euro_at` AS price_euro_at_282, a3_.`price_euro_fi` AS price_euro_fi_283, a3_.`price_euro_fr` AS price_euro_fr_284, a3_.`price_euro_it` AS price_euro_it_285, a3_.`price_euro_be` AS price_euro_be_286, a3_.`price_euro_ie` AS price_euro_ie_287, a3_.`price_euro_nl` AS price_euro_nl_288, a3_.`price_euro_es` AS price_euro_es_289, a3_.`price_rub` AS price_rub_290, a3_.`price_rue` AS price_rue_291, a3_.`price_gbp` AS price_gbp_292, a3_.`price_gbe` AS price_gbe_293, a3_.`price_usd` AS price_usd_294, a3_.`price_use` AS price_use_295, a3_.`price_fq_usd` AS price_fq_usd_296, a3_.`price_fq_use` AS price_fq_use_297, a3_.`price_chf` AS price_chf_298, a3_.`price_che` AS price_che_299, a3_.`price_sek` AS price_sek_300, a3_.`price_see` AS price_see_301, a3_.`price_dkk` AS price_dkk_302, a3_.`price_dke` AS price_dke_303, a3_.`price_nok` AS price_nok_304, a3_.`price_noe` AS price_noe_305, a3_.`price_pln` AS price_pln_306, a3_.`price_ple` AS price_ple_307, a3_.`price_cad` AS price_cad_308, a3_.`price_cae` AS price_cae_309, a3_.`price_fq_cad` AS price_fq_cad_310, a3_.`price_fq_cae` AS price_fq_cae_311, a3_.`del` AS del_312, b0_.user_id AS user_id_313, b0_.warehouse AS warehouse_314, b0_.address_recipient AS address_recipient_315, b0_.address_payer AS address_payer_316, b0_.delivery_country AS delivery_country_317, b0_.mailing_id AS mailing_id_318, b0_.buy_order_manager AS buy_order_manager_319, b1_.buy_order_id AS buy_order_id_320, b1_.article_id AS article_id_321, a2_.collection AS collection_322, a2_.newCollection AS newCollection_323, a2_.type AS type_324, a2_.measure AS measure_325, a2_.surface AS surface_326, a2_.pr_status AS pr_status_327, a2_.category_price AS category_price_328, a2_.edge_type AS edge_type_329, a2_.using AS using_330, a2_.shape AS shape_331, a2_.material AS material_332, a2_.delivery AS delivery_333, a2_.sliding AS sliding_334, a2_.off_shade AS off_shade_335, a2_.style AS style_336, a2_.repeat_draw AS repeat_draw_337, a2_.measurement_size AS measurement_size_338, a2_.installation_type AS installation_type_339, a2_.meth_laying AS meth_laying_340, a2_.draw AS draw_341, a3_.article AS article_342 FROM `buy_order` b0_ LEFT JOIN `buy_order_article` b1_ ON b0_.id = b1_.buy_order_id LEFT JOIN `article` a2_ ON b1_.article_id = a2_.id LEFT JOIN `list_country` l4_ ON b0_.delivery_country = l4_.id LEFT JOIN `article_price_discount` a3_ ON a2_.id = a3_.article AND (a3_.`price_euro` <> 0) LEFT JOIN `user` u5_ ON b0_.user_id = u5_.id WHERE b0_.`token` = '9552f540dd43d672b5698cbe02444caddadce7f4fd925265a10a6e6c2fa24dc9' AND b0_.`status` <> 12 ORDER BY b0_.`create_date` DESC, b1_.`id` DESC, a3_.`amount` DESC Parameters: [] View formatted query View runnable query Explain query SELECT b0_.`id` AS id_0, b0_.`mirror` AS mirror_1, b0_.`unid` AS unid_2, b0_.`unid_vat_player` AS unid_vat_player_3, b0_.`hash` AS hash_4, b0_.`number` AS number_5, b0_.`number_donor` AS number_donor_6, b0_.`token` AS token_7, b0_.`email` AS email_8, b0_.`email_send` AS email_send_9, b0_.`status` AS status_10, b0_.`step` AS step_11, b0_.`name` AS name_12, b0_.`adyen` AS adyen_13, b0_.`tax_number` AS tax_number_14, b0_.`vat_type` AS vat_type_15, b0_.`vat_number` AS vat_number_16, b0_.`vat_percent` AS vat_percent_17, b0_.`discount` AS discount_18, b0_.`address_equal` AS address_equal_19, b0_.`full_payment_date` AS full_payment_date_20, b0_.`delivery_index` AS delivery_index_21, b0_.`personal_data_agree` AS personal_data_agree_22, b0_.`delivery_region` AS delivery_region_23, b0_.`delivery_city` AS delivery_city_24, b0_.`delivery_address` AS delivery_address_25, b0_.`delivery_building` AS delivery_building_26, b0_.`delivery_apartment_office` AS delivery_apartment_office_27, b0_.`delivery_phone_code` AS delivery_phone_code_28, b0_.`delivery_phone` AS delivery_phone_29, b0_.`where_delivered` AS where_delivered_30, b0_.`warehouse_data` AS warehouse_data_31, b0_.`ref_number` AS ref_number_32, b0_.`sex` AS sex_33, b0_.`client_name` AS client_name_34, b0_.`client_surname` AS client_surname_35, b0_.`company_name` AS company_name_36, b0_.`description` AS description_37, b0_.`pay_type` AS pay_type_38, b0_.`pay_date_execution` AS pay_date_execution_39, b0_.`accept_pay` AS accept_pay_40, b0_.`cancel_date` AS cancel_date_41, b0_.`create_date` AS create_date_42, b0_.`update_date` AS update_date_43, b0_.`marker_reset` AS marker_reset_44, b0_.`marker_change` AS marker_change_45, b0_.`marker_delivery_change` AS marker_delivery_change_46, b0_.`locale` AS locale_47, b0_.`currency` AS currency_48, b0_.`payment_euro` AS payment_euro_49, b0_.`cur_rate` AS cur_rate_50, b0_.`measure` AS measure_51, b0_.`tracking_number` AS tracking_number_52, b0_.`carrier_name` AS carrier_name_53, b0_.`carrier_contact_data` AS carrier_contact_data_54, b0_.`write_off_reason` AS write_off_reason_55, b0_.`offset_explain` AS offset_explain_56, b0_.`weight_gross` AS weight_gross_57, b0_.`weight_limit` AS weight_limit_58, b0_.`remember` AS remember_59, b0_.`bank_details` AS bank_details_60, b0_.`recipient_number` AS recipient_number_61, b0_.`date_payment_back` AS date_payment_back_62, b0_.`send_create_1c` AS send_create_1c_63, b0_.`bank_transfer_requested` AS bank_transfer_requested_64, b0_.`marker_test` AS marker_test_65, b0_.`no_change` AS no_change_66, b0_.`kladr_id` AS kladr_id_67, b0_.`okato_id` AS okato_id_68, b0_.`product_review` AS product_review_69, b0_.`entrance_review` AS entrance_review_70, b0_.`send_review` AS send_review_71, b0_.`reserve` AS reserve_72, b0_.`key_email` AS key_email_73, b0_.`process` AS process_74, b0_.`spec_price` AS spec_price_75, b0_.`compensation` AS compensation_76, b0_.`is_refunded` AS is_refunded_77, b0_.`check_breakdown` AS check_breakdown_78, b0_.`truspilot_review_requested` AS truspilot_review_requested_79, b0_.`collection_review_requested` AS collection_review_requested_80, b0_.`prohibit_send_review_request` AS prohibit_send_review_request_81, b1_.`id` AS id_82, b1_.`type` AS type_83, b1_.`article_time_type` AS article_time_type_84, b1_.`code` AS code_85, b1_.`packaging_count` AS packaging_count_86, b1_.`packaging` AS packaging_87, b1_.`pallet` AS pallet_88, b1_.`multiple_pallet` AS multiple_pallet_89, b1_.`weight` AS weight_90, b1_.`amount` AS amount_91, b1_.`price` AS price_92, b1_.`price_eur` AS price_eur_93, b1_.`currency` AS currency_94, b1_.`measure` AS measure_95, b1_.`delivery_time_min` AS delivery_time_min_96, b1_.`delivery_time_max` AS delivery_time_max_97, b1_.`delivery_time_min_faster` AS delivery_time_min_faster_98, b1_.`delivery_time_max_faster` AS delivery_time_max_faster_99, b1_.`delivery_time_confirm_min` AS delivery_time_confirm_min_100, b1_.`delivery_time_confirm_max` AS delivery_time_confirm_max_101, b1_.`holiday` AS holiday_102, b1_.`sample_format` AS sample_format_103, b1_.`sample_type` AS sample_type_104, b1_.`sample_code` AS sample_code_105, b1_.`swimming_pool` AS swimming_pool_106, b1_.`add_time` AS add_time_107, a2_.`id` AS id_108, a2_.`code` AS code_109, a2_.`name` AS name_110, a2_.`alternate_name` AS alternate_name_111, a2_.`urla` AS urla_112, a2_.`file` AS file_113, a2_.`size_x` AS size_x_114, a2_.`size_y` AS size_y_115, a2_.`size_gb_x` AS size_gb_x_116, a2_.`size_gb_y` AS size_gb_y_117, a2_.`size_tessera` AS size_tessera_118, a2_.`file_size1_x` AS file_size1_x_119, a2_.`file_size1_y` AS file_size1_y_120, a2_.`file_size2_x` AS file_size2_x_121, a2_.`file_size2_y` AS file_size2_y_122, a2_.`file_size3_x` AS file_size3_x_123, a2_.`file_size3_y` AS file_size3_y_124, a2_.`file_size500_x` AS file_size500_x_125, a2_.`file_size500_y` AS file_size500_y_126, a2_.`file_size740_x` AS file_size740_x_127, a2_.`file_size740_y` AS file_size740_y_128, a2_.`file_size8_x` AS file_size8_x_129, a2_.`file_size8_y` AS file_size8_y_130, a2_.`pallet` AS pallet_131, a2_.`pallet_ft` AS pallet_ft_132, a2_.`type_constraint` AS type_constraint_133, a2_.`multiple_pallet` AS multiple_pallet_134, a2_.`min_order` AS min_order_135, a2_.`price_euro` AS price_euro_136, a2_.`price_mq_euro` AS price_mq_euro_137, a2_.`price_euro_de` AS price_euro_de_138, a2_.`price_mq_euro_de` AS price_mq_euro_de_139, a2_.`price_euro_at` AS price_euro_at_140, a2_.`price_mq_euro_at` AS price_mq_euro_at_141, a2_.`price_euro_fi` AS price_euro_fi_142, a2_.`price_mq_euro_fi` AS price_mq_euro_fi_143, a2_.`price_euro_fr` AS price_euro_fr_144, a2_.`price_mq_euro_fr` AS price_mq_euro_fr_145, a2_.`price_euro_it` AS price_euro_it_146, a2_.`price_mq_euro_it` AS price_mq_euro_it_147, a2_.`price_euro_be` AS price_euro_be_148, a2_.`price_mq_euro_be` AS price_mq_euro_be_149, a2_.`price_euro_ie` AS price_euro_ie_150, a2_.`price_mq_euro_ie` AS price_mq_euro_ie_151, a2_.`price_euro_nl` AS price_euro_nl_152, a2_.`price_mq_euro_nl` AS price_mq_euro_nl_153, a2_.`price_euro_es` AS price_euro_es_154, a2_.`price_mq_euro_es` AS price_mq_euro_es_155, a2_.`price_rub` AS price_rub_156, a2_.`price_rue` AS price_rue_157, a2_.`price_mq_rub` AS price_mq_rub_158, a2_.`price_mq_rue` AS price_mq_rue_159, a2_.`price_gbp` AS price_gbp_160, a2_.`price_gbe` AS price_gbe_161, a2_.`price_mq_gbp` AS price_mq_gbp_162, a2_.`price_mq_gbe` AS price_mq_gbe_163, a2_.`price_usd` AS price_usd_164, a2_.`price_use` AS price_use_165, a2_.`price_fq_usd` AS price_fq_usd_166, a2_.`price_fq_use` AS price_fq_use_167, a2_.`price_mq_usd` AS price_mq_usd_168, a2_.`price_mq_use` AS price_mq_use_169, a2_.`price_chf` AS price_chf_170, a2_.`price_che` AS price_che_171, a2_.`price_mq_chf` AS price_mq_chf_172, a2_.`price_mq_che` AS price_mq_che_173, a2_.`price_sek` AS price_sek_174, a2_.`price_see` AS price_see_175, a2_.`price_mq_sek` AS price_mq_sek_176, a2_.`price_mq_see` AS price_mq_see_177, a2_.`price_dkk` AS price_dkk_178, a2_.`price_dke` AS price_dke_179, a2_.`price_mq_dkk` AS price_mq_dkk_180, a2_.`price_mq_dke` AS price_mq_dke_181, a2_.`price_nok` AS price_nok_182, a2_.`price_noe` AS price_noe_183, a2_.`price_mq_nok` AS price_mq_nok_184, a2_.`price_mq_noe` AS price_mq_noe_185, a2_.`price_pln` AS price_pln_186, a2_.`price_ple` AS price_ple_187, a2_.`price_mq_pln` AS price_mq_pln_188, a2_.`price_mq_ple` AS price_mq_ple_189, a2_.`price_cad` AS price_cad_190, a2_.`price_cae` AS price_cae_191, a2_.`price_fq_cad` AS price_fq_cad_192, a2_.`price_fq_cae` AS price_fq_cae_193, a2_.`price_mq_cad` AS price_mq_cad_194, a2_.`price_mq_cae` AS price_mq_cae_195, a2_.`thick` AS thick_196, a2_.`weight` AS weight_197, a2_.`packaging_count` AS packaging_count_198, a2_.`packaging_count_ft` AS packaging_count_ft_199, a2_.`packaging_count_pc` AS packaging_count_pc_200, a2_.`m2one_ps` AS m2one_ps_201, a2_.`description_ru` AS description_ru_202, a2_.`description_en` AS description_en_203, a2_.`description_it` AS description_it_204, a2_.`description_es` AS description_es_205, a2_.`description_fr` AS description_fr_206, a2_.`description_de` AS description_de_207, a2_.`description_pt` AS description_pt_208, a2_.`description_pl` AS description_pl_209, a2_.`description_nl` AS description_nl_210, a2_.`description_fi` AS description_fi_211, a2_.`description_ua` AS description_ua_212, a2_.`description_sv` AS description_sv_213, a2_.`description_no` AS description_no_214, a2_.`description_da` AS description_da_215, a2_.`description_cn` AS description_cn_216, a2_.`scheme` AS scheme_217, a2_.`sale_date` AS sale_date_218, a2_.`thin_granite` AS thin_granite_219, a2_.`glazed_granite` AS glazed_granite_220, a2_.`pei` AS pei_221, a2_.`is_grouped` AS is_grouped_222, a2_.`is_rotate` AS is_rotate_223, a2_.`price_prx` AS price_prx_224, a2_.`background_white` AS background_white_225, a2_.`border_grey` AS border_grey_226, a2_.`is_edit` AS is_edit_227, a2_.`edited_at` AS edited_at_228, a2_.`comment` AS comment_229, a2_.`file_edit` AS file_edit_230, a2_.`image_setting` AS image_setting_231, a2_.`file_w` AS file_w_232, a2_.`file_h` AS file_h_233, a2_.`file_w4000` AS file_w4000_234, a2_.`file_h4000` AS file_h4000_235, a2_.`size_z` AS size_z_236, a2_.`size_gb_z` AS size_gb_z_237, a2_.`repeat_number` AS repeat_number_238, a2_.`size_big` AS size_big_239, a2_.`delivery_suspended` AS delivery_suspended_240, a2_.`poddon_x` AS poddon_x_241, a2_.`poddon_y` AS poddon_y_242, a2_.`poddon_z` AS poddon_z_243, a2_.`module` AS module_244, a2_.`tessera_size_x` AS tessera_size_x_245, a2_.`tessera_size_y` AS tessera_size_y_246, a2_.`tessera_size_z` AS tessera_size_z_247, a2_.`poddon_count` AS poddon_count_248, a2_.`poddon_weight` AS poddon_weight_249, a2_.`added_to_cart` AS added_to_cart_250, a2_.`sold_out` AS sold_out_251, a2_.`sold_out_vol` AS sold_out_vol_252, a2_.`swimming_pool` AS swimming_pool_253, a2_.`can_select_substrate` AS can_select_substrate_254, a2_.`designer` AS designer_255, a2_.`designer_id` AS designer_id_256, a2_.`mosaic_effect` AS mosaic_effect_257, a2_.`not_sample` AS not_sample_258, a2_.`express_sample` AS express_sample_259, a2_.`description_edit` AS description_edit_260, a2_.`comment_scheme_image` AS comment_scheme_image_261, a2_.`variant_image` AS variant_image_262, a2_.`square` AS square_263, a2_.`fix_big_size` AS fix_big_size_264, a2_.`overflow_sink` AS overflow_sink_265, a2_.`drain_size_sink` AS drain_size_sink_266, a2_.`faucet_hole_sink` AS faucet_hole_sink_267, a2_.`rotate` AS rotate_268, a2_.`dyed_in_mass` AS dyed_in_mass_269, a2_.`durability_class` AS durability_class_270, a2_.`is_comment_ru` AS is_comment_ru_271, a2_.`file_rotation` AS file_rotation_272, a2_.`created_at` AS created_at_273, a2_.`updated_at` AS updated_at_274, a3_.`id` AS id_275, a3_.`amount` AS amount_276, a3_.`amount_ft` AS amount_ft_277, a3_.`fold` AS fold_278, a3_.`price` AS price_279, a3_.`price_euro` AS price_euro_280, a3_.`price_euro_de` AS price_euro_de_281, a3_.`price_euro_at` AS price_euro_at_282, a3_.`price_euro_fi` AS price_euro_fi_283, a3_.`price_euro_fr` AS price_euro_fr_284, a3_.`price_euro_it` AS price_euro_it_285, a3_.`price_euro_be` AS price_euro_be_286, a3_.`price_euro_ie` AS price_euro_ie_287, a3_.`price_euro_nl` AS price_euro_nl_288, a3_.`price_euro_es` AS price_euro_es_289, a3_.`price_rub` AS price_rub_290, a3_.`price_rue` AS price_rue_291, a3_.`price_gbp` AS price_gbp_292, a3_.`price_gbe` AS price_gbe_293, a3_.`price_usd` AS price_usd_294, a3_.`price_use` AS price_use_295, a3_.`price_fq_usd` AS price_fq_usd_296, a3_.`price_fq_use` AS price_fq_use_297, a3_.`price_chf` AS price_chf_298, a3_.`price_che` AS price_che_299, a3_.`price_sek` AS price_sek_300, a3_.`price_see` AS price_see_301, a3_.`price_dkk` AS price_dkk_302, a3_.`price_dke` AS price_dke_303, a3_.`price_nok` AS price_nok_304, a3_.`price_noe` AS price_noe_305, a3_.`price_pln` AS price_pln_306, a3_.`price_ple` AS price_ple_307, a3_.`price_cad` AS price_cad_308, a3_.`price_cae` AS price_cae_309, a3_.`price_fq_cad` AS price_fq_cad_310, a3_.`price_fq_cae` AS price_fq_cae_311, a3_.`del` AS del_312, b0_.user_id AS user_id_313, b0_.warehouse AS warehouse_314, b0_.address_recipient AS address_recipient_315, b0_.address_payer AS address_payer_316, b0_.delivery_country AS delivery_country_317, b0_.mailing_id AS mailing_id_318, b0_.buy_order_manager AS buy_order_manager_319, b1_.buy_order_id AS buy_order_id_320, b1_.article_id AS article_id_321, a2_.collection AS collection_322, a2_.newCollection AS newCollection_323, a2_.type AS type_324, a2_.measure AS measure_325, a2_.surface AS surface_326, a2_.pr_status AS pr_status_327, a2_.category_price AS category_price_328, a2_.edge_type AS edge_type_329, a2_.using AS using_330, a2_.shape AS shape_331, a2_.material AS material_332, a2_.delivery AS delivery_333, a2_.sliding AS sliding_334, a2_.off_shade AS off_shade_335, a2_.style AS style_336, a2_.repeat_draw AS repeat_draw_337, a2_.measurement_size AS measurement_size_338, a2_.installation_type AS installation_type_339, a2_.meth_laying AS meth_laying_340, a2_.draw AS draw_341, a3_.article AS article_342 FROM `buy_order` b0_ LEFT JOIN `buy_order_article` b1_ ON b0_.id = b1_.buy_order_id LEFT JOIN `article` a2_ ON b1_.article_id = a2_.id LEFT JOIN `list_country` l4_ ON b0_.delivery_country = l4_.id LEFT JOIN `article_price_discount` a3_ ON a2_.id = a3_.article AND (a3_.`price_euro` <> 0) LEFT JOIN `user` u5_ ON b0_.user_id = u5_.id WHERE b0_.`token` = '9552f540dd43d672b5698cbe02444caddadce7f4fd925265a10a6e6c2fa24dc9' AND b0_.`status` <> 12 ORDER BY b0_.`create_date` DESC, b1_.`id` DESC, a3_.`amount` DESC SELECT b0_.`id` AS id_0, b0_.`mirror` AS mirror_1, b0_.`unid` AS unid_2, b0_.`unid_vat_player` AS unid_vat_player_3, b0_.`hash` AS hash_4, b0_.`number` AS number_5, b0_.`number_donor` AS number_donor_6, b0_.`token` AS token_7, b0_.`email` AS email_8, b0_.`email_send` AS email_send_9, b0_.`status` AS status_10, b0_.`step` AS step_11, b0_.`name` AS name_12, b0_.`adyen` AS adyen_13, b0_.`tax_number` AS tax_number_14, b0_.`vat_type` AS vat_type_15, b0_.`vat_number` AS vat_number_16, b0_.`vat_percent` AS vat_percent_17, b0_.`discount` AS discount_18, b0_.`address_equal` AS address_equal_19, b0_.`full_payment_date` AS full_payment_date_20, b0_.`delivery_index` AS delivery_index_21, b0_.`personal_data_agree` AS personal_data_agree_22, b0_.`delivery_region` AS delivery_region_23, b0_.`delivery_city` AS delivery_city_24, b0_.`delivery_address` AS delivery_address_25, b0_.`delivery_building` AS delivery_building_26, b0_.`delivery_apartment_office` AS delivery_apartment_office_27, b0_.`delivery_phone_code` AS delivery_phone_code_28, b0_.`delivery_phone` AS delivery_phone_29, b0_.`where_delivered` AS where_delivered_30, b0_.`warehouse_data` AS warehouse_data_31, b0_.`ref_number` AS ref_number_32, b0_.`sex` AS sex_33, b0_.`client_name` AS client_name_34, b0_.`client_surname` AS client_surname_35, b0_.`company_name` AS company_name_36, b0_.`description` AS description_37, b0_.`pay_type` AS pay_type_38, b0_.`pay_date_execution` AS pay_date_execution_39, b0_.`accept_pay` AS accept_pay_40, b0_.`cancel_date` AS cancel_date_41, b0_.`create_date` AS create_date_42, b0_.`update_date` AS update_date_43, b0_.`marker_reset` AS marker_reset_44, b0_.`marker_change` AS marker_change_45, b0_.`marker_delivery_change` AS marker_delivery_change_46, b0_.`locale` AS locale_47, b0_.`currency` AS currency_48, b0_.`payment_euro` AS payment_euro_49, b0_.`cur_rate` AS cur_rate_50, b0_.`measure` AS measure_51, b0_.`tracking_number` AS tracking_number_52, b0_.`carrier_name` AS carrier_name_53, b0_.`carrier_contact_data` AS carrier_contact_data_54, b0_.`write_off_reason` AS write_off_reason_55, b0_.`offset_explain` AS offset_explain_56, b0_.`weight_gross` AS weight_gross_57, b0_.`weight_limit` AS weight_limit_58, b0_.`remember` AS remember_59, b0_.`bank_details` AS bank_details_60, b0_.`recipient_number` AS recipient_number_61, b0_.`date_payment_back` AS date_payment_back_62, b0_.`send_create_1c` AS send_create_1c_63, b0_.`bank_transfer_requested` AS bank_transfer_requested_64, b0_.`marker_test` AS marker_test_65, b0_.`no_change` AS no_change_66, b0_.`kladr_id` AS kladr_id_67, b0_.`okato_id` AS okato_id_68, b0_.`product_review` AS product_review_69, b0_.`entrance_review` AS entrance_review_70, b0_.`send_review` AS send_review_71, b0_.`reserve` AS reserve_72, b0_.`key_email` AS key_email_73, b0_.`process` AS process_74, b0_.`spec_price` AS spec_price_75, b0_.`compensation` AS compensation_76, b0_.`is_refunded` AS is_refunded_77, b0_.`check_breakdown` AS check_breakdown_78, b0_.`truspilot_review_requested` AS truspilot_review_requested_79, b0_.`collection_review_requested` AS collection_review_requested_80, b0_.`prohibit_send_review_request` AS prohibit_send_review_request_81, b1_.`id` AS id_82, b1_.`type` AS type_83, b1_.`article_time_type` AS article_time_type_84, b1_.`code` AS code_85, b1_.`packaging_count` AS packaging_count_86, b1_.`packaging` AS packaging_87, b1_.`pallet` AS pallet_88, b1_.`multiple_pallet` AS multiple_pallet_89, b1_.`weight` AS weight_90, b1_.`amount` AS amount_91, b1_.`price` AS price_92, b1_.`price_eur` AS price_eur_93, b1_.`currency` AS currency_94, b1_.`measure` AS measure_95, b1_.`delivery_time_min` AS delivery_time_min_96, b1_.`delivery_time_max` AS delivery_time_max_97, b1_.`delivery_time_min_faster` AS delivery_time_min_faster_98, b1_.`delivery_time_max_faster` AS delivery_time_max_faster_99, b1_.`delivery_time_confirm_min` AS delivery_time_confirm_min_100, b1_.`delivery_time_confirm_max` AS delivery_time_confirm_max_101, b1_.`holiday` AS holiday_102, b1_.`sample_format` AS sample_format_103, b1_.`sample_type` AS sample_type_104, b1_.`sample_code` AS sample_code_105, b1_.`swimming_pool` AS swimming_pool_106, b1_.`add_time` AS add_time_107, a2_.`id` AS id_108, a2_.`code` AS code_109, a2_.`name` AS name_110, a2_.`alternate_name` AS alternate_name_111, a2_.`urla` AS urla_112, a2_.`file` AS file_113, a2_.`size_x` AS size_x_114, a2_.`size_y` AS size_y_115, a2_.`size_gb_x` AS size_gb_x_116, a2_.`size_gb_y` AS size_gb_y_117, a2_.`size_tessera` AS size_tessera_118, a2_.`file_size1_x` AS file_size1_x_119, a2_.`file_size1_y` AS file_size1_y_120, a2_.`file_size2_x` AS file_size2_x_121, a2_.`file_size2_y` AS file_size2_y_122, a2_.`file_size3_x` AS file_size3_x_123, a2_.`file_size3_y` AS file_size3_y_124, a2_.`file_size500_x` AS file_size500_x_125, a2_.`file_size500_y` AS file_size500_y_126, a2_.`file_size740_x` AS file_size740_x_127, a2_.`file_size740_y` AS file_size740_y_128, a2_.`file_size8_x` AS file_size8_x_129, a2_.`file_size8_y` AS file_size8_y_130, a2_.`pallet` AS pallet_131, a2_.`pallet_ft` AS pallet_ft_132, a2_.`type_constraint` AS type_constraint_133, a2_.`multiple_pallet` AS multiple_pallet_134, a2_.`min_order` AS min_order_135, a2_.`price_euro` AS price_euro_136, a2_.`price_mq_euro` AS price_mq_euro_137, a2_.`price_euro_de` AS price_euro_de_138, a2_.`price_mq_euro_de` AS price_mq_euro_de_139, a2_.`price_euro_at` AS price_euro_at_140, a2_.`price_mq_euro_at` AS price_mq_euro_at_141, a2_.`price_euro_fi` AS price_euro_fi_142, a2_.`price_mq_euro_fi` AS price_mq_euro_fi_143, a2_.`price_euro_fr` AS price_euro_fr_144, a2_.`price_mq_euro_fr` AS price_mq_euro_fr_145, a2_.`price_euro_it` AS price_euro_it_146, a2_.`price_mq_euro_it` AS price_mq_euro_it_147, a2_.`price_euro_be` AS price_euro_be_148, a2_.`price_mq_euro_be` AS price_mq_euro_be_149, a2_.`price_euro_ie` AS price_euro_ie_150, a2_.`price_mq_euro_ie` AS price_mq_euro_ie_151, a2_.`price_euro_nl` AS price_euro_nl_152, a2_.`price_mq_euro_nl` AS price_mq_euro_nl_153, a2_.`price_euro_es` AS price_euro_es_154, a2_.`price_mq_euro_es` AS price_mq_euro_es_155, a2_.`price_rub` AS price_rub_156, a2_.`price_rue` AS price_rue_157, a2_.`price_mq_rub` AS price_mq_rub_158, a2_.`price_mq_rue` AS price_mq_rue_159, a2_.`price_gbp` AS price_gbp_160, a2_.`price_gbe` AS price_gbe_161, a2_.`price_mq_gbp` AS price_mq_gbp_162, a2_.`price_mq_gbe` AS price_mq_gbe_163, a2_.`price_usd` AS price_usd_164, a2_.`price_use` AS price_use_165, a2_.`price_fq_usd` AS price_fq_usd_166, a2_.`price_fq_use` AS price_fq_use_167, a2_.`price_mq_usd` AS price_mq_usd_168, a2_.`price_mq_use` AS price_mq_use_169, a2_.`price_chf` AS price_chf_170, a2_.`price_che` AS price_che_171, a2_.`price_mq_chf` AS price_mq_chf_172, a2_.`price_mq_che` AS price_mq_che_173, a2_.`price_sek` AS price_sek_174, a2_.`price_see` AS price_see_175, a2_.`price_mq_sek` AS price_mq_sek_176, a2_.`price_mq_see` AS price_mq_see_177, a2_.`price_dkk` AS price_dkk_178, a2_.`price_dke` AS price_dke_179, a2_.`price_mq_dkk` AS price_mq_dkk_180, a2_.`price_mq_dke` AS price_mq_dke_181, a2_.`price_nok` AS price_nok_182, a2_.`price_noe` AS price_noe_183, a2_.`price_mq_nok` AS price_mq_nok_184, a2_.`price_mq_noe` AS price_mq_noe_185, a2_.`price_pln` AS price_pln_186, a2_.`price_ple` AS price_ple_187, a2_.`price_mq_pln` AS price_mq_pln_188, a2_.`price_mq_ple` AS price_mq_ple_189, a2_.`price_cad` AS price_cad_190, a2_.`price_cae` AS price_cae_191, a2_.`price_fq_cad` AS price_fq_cad_192, a2_.`price_fq_cae` AS price_fq_cae_193, a2_.`price_mq_cad` AS price_mq_cad_194, a2_.`price_mq_cae` AS price_mq_cae_195, a2_.`thick` AS thick_196, a2_.`weight` AS weight_197, a2_.`packaging_count` AS packaging_count_198, a2_.`packaging_count_ft` AS packaging_count_ft_199, a2_.`packaging_count_pc` AS packaging_count_pc_200, a2_.`m2one_ps` AS m2one_ps_201, a2_.`description_ru` AS description_ru_202, a2_.`description_en` AS description_en_203, a2_.`description_it` AS description_it_204, a2_.`description_es` AS description_es_205, a2_.`description_fr` AS description_fr_206, a2_.`description_de` AS description_de_207, a2_.`description_pt` AS description_pt_208, a2_.`description_pl` AS description_pl_209, a2_.`description_nl` AS description_nl_210, a2_.`description_fi` AS description_fi_211, a2_.`description_ua` AS description_ua_212, a2_.`description_sv` AS description_sv_213, a2_.`description_no` AS description_no_214, a2_.`description_da` AS description_da_215, a2_.`description_cn` AS description_cn_216, a2_.`scheme` AS scheme_217, a2_.`sale_date` AS sale_date_218, a2_.`thin_granite` AS thin_granite_219, a2_.`glazed_granite` AS glazed_granite_220, a2_.`pei` AS pei_221, a2_.`is_grouped` AS is_grouped_222, a2_.`is_rotate` AS is_rotate_223, a2_.`price_prx` AS price_prx_224, a2_.`background_white` AS background_white_225, a2_.`border_grey` AS border_grey_226, a2_.`is_edit` AS is_edit_227, a2_.`edited_at` AS edited_at_228, a2_.`comment` AS comment_229, a2_.`file_edit` AS file_edit_230, a2_.`image_setting` AS image_setting_231, a2_.`file_w` AS file_w_232, a2_.`file_h` AS file_h_233, a2_.`file_w4000` AS file_w4000_234, a2_.`file_h4000` AS file_h4000_235, a2_.`size_z` AS size_z_236, a2_.`size_gb_z` AS size_gb_z_237, a2_.`repeat_number` AS repeat_number_238, a2_.`size_big` AS size_big_239, a2_.`delivery_suspended` AS delivery_suspended_240, a2_.`poddon_x` AS poddon_x_241, a2_.`poddon_y` AS poddon_y_242, a2_.`poddon_z` AS poddon_z_243, a2_.`module` AS module_244, a2_.`tessera_size_x` AS tessera_size_x_245, a2_.`tessera_size_y` AS tessera_size_y_246, a2_.`tessera_size_z` AS tessera_size_z_247, a2_.`poddon_count` AS poddon_count_248, a2_.`poddon_weight` AS poddon_weight_249, a2_.`added_to_cart` AS added_to_cart_250, a2_.`sold_out` AS sold_out_251, a2_.`sold_out_vol` AS sold_out_vol_252, a2_.`swimming_pool` AS swimming_pool_253, a2_.`can_select_substrate` AS can_select_substrate_254, a2_.`designer` AS designer_255, a2_.`designer_id` AS designer_id_256, a2_.`mosaic_effect` AS mosaic_effect_257, a2_.`not_sample` AS not_sample_258, a2_.`express_sample` AS express_sample_259, a2_.`description_edit` AS description_edit_260, a2_.`comment_scheme_image` AS comment_scheme_image_261, a2_.`variant_image` AS variant_image_262, a2_.`square` AS square_263, a2_.`fix_big_size` AS fix_big_size_264, a2_.`overflow_sink` AS overflow_sink_265, a2_.`drain_size_sink` AS drain_size_sink_266, a2_.`faucet_hole_sink` AS faucet_hole_sink_267, a2_.`rotate` AS rotate_268, a2_.`dyed_in_mass` AS dyed_in_mass_269, a2_.`durability_class` AS durability_class_270, a2_.`is_comment_ru` AS is_comment_ru_271, a2_.`file_rotation` AS file_rotation_272, a2_.`created_at` AS created_at_273, a2_.`updated_at` AS updated_at_274, a3_.`id` AS id_275, a3_.`amount` AS amount_276, a3_.`amount_ft` AS amount_ft_277, a3_.`fold` AS fold_278, a3_.`price` AS price_279, a3_.`price_euro` AS price_euro_280, a3_.`price_euro_de` AS price_euro_de_281, a3_.`price_euro_at` AS price_euro_at_282, a3_.`price_euro_fi` AS price_euro_fi_283, a3_.`price_euro_fr` AS price_euro_fr_284, a3_.`price_euro_it` AS price_euro_it_285, a3_.`price_euro_be` AS price_euro_be_286, a3_.`price_euro_ie` AS price_euro_ie_287, a3_.`price_euro_nl` AS price_euro_nl_288, a3_.`price_euro_es` AS price_euro_es_289, a3_.`price_rub` AS price_rub_290, a3_.`price_rue` AS price_rue_291, a3_.`price_gbp` AS price_gbp_292, a3_.`price_gbe` AS price_gbe_293, a3_.`price_usd` AS price_usd_294, a3_.`price_use` AS price_use_295, a3_.`price_fq_usd` AS price_fq_usd_296, a3_.`price_fq_use` AS price_fq_use_297, a3_.`price_chf` AS price_chf_298, a3_.`price_che` AS price_che_299, a3_.`price_sek` AS price_sek_300, a3_.`price_see` AS price_see_301, a3_.`price_dkk` AS price_dkk_302, a3_.`price_dke` AS price_dke_303, a3_.`price_nok` AS price_nok_304, a3_.`price_noe` AS price_noe_305, a3_.`price_pln` AS price_pln_306, a3_.`price_ple` AS price_ple_307, a3_.`price_cad` AS price_cad_308, a3_.`price_cae` AS price_cae_309, a3_.`price_fq_cad` AS price_fq_cad_310, a3_.`price_fq_cae` AS price_fq_cae_311, a3_.`del` AS del_312, b0_.user_id AS user_id_313, b0_.warehouse AS warehouse_314, b0_.address_recipient AS address_recipient_315, b0_.address_payer AS address_payer_316, b0_.delivery_country AS delivery_country_317, b0_.mailing_id AS mailing_id_318, b0_.buy_order_manager AS buy_order_manager_319, b1_.buy_order_id AS buy_order_id_320, b1_.article_id AS article_id_321, a2_.collection AS collection_322, a2_.newCollection AS newCollection_323, a2_.type AS type_324, a2_.measure AS measure_325, a2_.surface AS surface_326, a2_.pr_status AS pr_status_327, a2_.category_price AS category_price_328, a2_.edge_type AS edge_type_329, a2_.using AS using_330, a2_.shape AS shape_331, a2_.material AS material_332, a2_.delivery AS delivery_333, a2_.sliding AS sliding_334, a2_.off_shade AS off_shade_335, a2_.style AS style_336, a2_.repeat_draw AS repeat_draw_337, a2_.measurement_size AS measurement_size_338, a2_.installation_type AS installation_type_339, a2_.meth_laying AS meth_laying_340, a2_.draw AS draw_341, a3_.article AS article_342 FROM `buy_order` b0_ LEFT JOIN `buy_order_article` b1_ ON b0_.id = b1_.buy_order_id LEFT JOIN `article` a2_ ON b1_.article_id = a2_.id LEFT JOIN `list_country` l4_ ON b0_.delivery_country = l4_.id LEFT JOIN `article_price_discount` a3_ ON a2_.id = a3_.article AND (a3_.`price_euro` <> 0) LEFT JOIN `user` u5_ ON b0_.user_id = u5_.id WHERE b0_.`token` = '9552f540dd43d672b5698cbe02444caddadce7f4fd925265a10a6e6c2fa24dc9' AND b0_.`status` <> 12 ORDER BY b0_.`create_date` DESC, b1_.`id` DESC, a3_.`amount` DESC;
2	0.26 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: [`"9552f540dd43d672b5698cbe02444caddadce7f4fd925265a10a6e6c2fa24dc9"`] 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` = '9552f540dd43d672b5698cbe02444caddadce7f4fd925265a10a6e6c2fa24dc9' LIMIT 1;
3	0.12 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: [`"9552f540dd43d672b5698cbe02444caddadce7f4fd925265a10a6e6c2fa24dc9"`] 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` = '9552f540dd43d672b5698cbe02444caddadce7f4fd925265a10a6e6c2fa24dc9' AND b1_.`status` <> 12;
4	0.16 ms	SELECT b0_.`id` AS id_0 FROM `buy_order` b0_ WHERE b0_.`token` = ? AND b0_.`status` <> 12 Parameters: [`"9552f540dd43d672b5698cbe02444caddadce7f4fd925265a10a6e6c2fa24dc9"`] 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` = '9552f540dd43d672b5698cbe02444caddadce7f4fd925265a10a6e6c2fa24dc9' AND b0_.`status` <> 12;
5	0.15 ms	SELECT t0.`id` AS id_1, t0.`token` AS token_2, t0.`name` AS name_3, t0.`create_date` AS create_date_4, t0.`update_date` AS update_date_5, t0.`process` AS process_6, t0.user_id AS user_id_7 FROM `idea` t0 WHERE t0.`token` = ? ORDER BY t0.`update_date` DESC Parameters: [`"9552f540dd43d672b5698cbe02444caddadce7f4fd925265a10a6e6c2fa24dc9"`] View formatted query View runnable query Explain query SELECT t0.`id` AS id_1, t0.`token` AS token_2, t0.`name` AS name_3, t0.`create_date` AS create_date_4, t0.`update_date` AS update_date_5, t0.`process` AS process_6, t0.user_id AS user_id_7 FROM `idea` t0 WHERE t0.`token` = ? ORDER BY t0.`update_date` DESC SELECT t0.`id` AS id_1, t0.`token` AS token_2, t0.`name` AS name_3, t0.`create_date` AS create_date_4, t0.`update_date` AS update_date_5, t0.`process` AS process_6, t0.user_id AS user_id_7 FROM `idea` t0 WHERE t0.`token` = '9552f540dd43d672b5698cbe02444caddadce7f4fd925265a10a6e6c2fa24dc9' ORDER BY t0.`update_date` DESC;
6	0.72 ms	SELECT COUNT(v0_.`id`) AS sclr_0 FROM `visit` v0_ WHERE v0_.`token` = ? AND v0_.`url` <> '/.catalog./' Parameters: [`"9552f540dd43d672b5698cbe02444caddadce7f4fd925265a10a6e6c2fa24dc9"`] 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` = '9552f540dd43d672b5698cbe02444caddadce7f4fd925265a10a6e6c2fa24dc9' AND v0_.`url` <> '/.catalog./';
7	0.24 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: [`"9552f540dd43d672b5698cbe02444caddadce7f4fd925265a10a6e6c2fa24dc9"`] 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` = '9552f540dd43d672b5698cbe02444caddadce7f4fd925265a10a6e6c2fa24dc9';
8	0.24 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';
9	91.97 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;
10	0.23 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;
11	0.12 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; ;
12	1.04 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;
13	0.25 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: [`"9552f540dd43d672b5698cbe02444caddadce7f4fd925265a10a6e6c2fa24dc9"`] 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` = '9552f540dd43d672b5698cbe02444caddadce7f4fd925265a10a6e6c2fa24dc9' LIMIT 1;
14	0.11 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: [`"9552f540dd43d672b5698cbe02444caddadce7f4fd925265a10a6e6c2fa24dc9"`] 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` = '9552f540dd43d672b5698cbe02444caddadce7f4fd925265a10a6e6c2fa24dc9' AND b1_.`status` <> 12;
15	0.12 ms	SELECT b0_.`id` AS id_0 FROM `buy_order` b0_ WHERE b0_.`token` = ? AND b0_.`status` <> 12 Parameters: [`"9552f540dd43d672b5698cbe02444caddadce7f4fd925265a10a6e6c2fa24dc9"`] 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` = '9552f540dd43d672b5698cbe02444caddadce7f4fd925265a10a6e6c2fa24dc9' AND b0_.`status` <> 12;
16	0.15 ms	SELECT COUNT(v0_.`id`) AS sclr_0 FROM `visit` v0_ WHERE v0_.`token` = ? AND v0_.`url` <> '/.catalog./' Parameters: [`"9552f540dd43d672b5698cbe02444caddadce7f4fd925265a10a6e6c2fa24dc9"`] 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` = '9552f540dd43d672b5698cbe02444caddadce7f4fd925265a10a6e6c2fa24dc9' AND v0_.`url` <> '/.catalog./';
17	0.13 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: [`"9552f540dd43d672b5698cbe02444caddadce7f4fd925265a10a6e6c2fa24dc9"`] 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` = '9552f540dd43d672b5698cbe02444caddadce7f4fd925265a10a6e6c2fa24dc9';
18	0.21 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';
19	0.14 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: [`"9552f540dd43d672b5698cbe02444caddadce7f4fd925265a10a6e6c2fa24dc9"`] 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` = '9552f540dd43d672b5698cbe02444caddadce7f4fd925265a10a6e6c2fa24dc9' LIMIT 1;
20	0.14 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';
21	52.40 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;
22	0.21 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;
23	0.14 ms	SELECT lu.en AS slug FROM publication p LEFT JOIN `locale_url` `lu` ON `lu`.publication_id = `p`.id LEFT JOIN `locale_bool` `lp` ON `lp`.blog_show_id = `p`.id LEFT JOIN `locale_status_translate` `lst` ON `lst`.publication_id = `p`.id WHERE p.id = 2232 AND lp.en = 1 AND lst.en = 1; Parameters: [] View formatted query View runnable query Explain query SELECT lu.en AS slug FROM publication p LEFT JOIN `locale_url` `lu` ON `lu`.publication_id = `p`.id LEFT JOIN `locale_bool` `lp` ON `lp`.blog_show_id = `p`.id LEFT JOIN `locale_status_translate` `lst` ON `lst`.publication_id = `p`.id WHERE p.id = 2232 AND lp.en = 1 AND lst.en = 1; SELECT lu.en AS slug FROM publication p LEFT JOIN `locale_url` `lu` ON `lu`.publication_id = `p`.id LEFT JOIN `locale_bool` `lp` ON `lp`.blog_show_id = `p`.id LEFT JOIN `locale_status_translate` `lst` ON `lst`.publication_id = `p`.id WHERE p.id = 2232 AND lp.en = 1 AND lst.en = 1; ;
24	1.27 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;
25	0.15 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.
FlexApp\Entity\ChatB	No errors.
FlexApp\Entity\ChatBMessage	No errors.
FlexApp\Entity\BoolDBSetting	No errors.
FlexApp\Entity\Widget	No errors.
FlexApp\Entity\CountryAndLangSpecificDataEntity	No errors.
WebBundle\Entity\ListCountry	No errors.
FlexApp\Entity\ConsultantEntity	No errors.
WebBundle\Entity\BuyOrderArticle	No errors.
WebBundle\Entity\Article	No errors.
WebBundle\Entity\OrderAddress	No errors.
FlexApp\Entity\GeoCountryEntity	No errors.
WebBundle\Entity\ListEmail	No errors.
WebBundle\Entity\OrderHistory	No errors.
WebBundle\Entity\OrderPayment	No errors.
WebBundle\Entity\CurrencyRate	No errors.
WebBundle\Entity\SampleEntity	No errors.
WebBundle\Entity\Interior	No errors.
WebBundle\Entity\Idea	No errors.
WebBundle\Entity\FilterEntity	No errors.
WebBundle\Entity\Collection	No errors.
WebBundle\Entity\Factory	No errors.
WebBundle\Entity\CollectionAlsoViewed	No errors.
WebBundle\Entity\InteriorHistory	No errors.
WebBundle\Entity\Visit	No errors.
WebBundle\Entity\ListVat	No errors.
WebBundle\Entity\WarehouseEntity	No errors.
WebBundle\Entity\BuyOrderManager	No errors.
WebBundle\Entity\ItalianMunicipalityEntity	No errors.
WebBundle\Entity\ListMeasure	No errors.
WebBundle\Entity\ListMaterial	No errors.
WebBundle\Entity\Publication	No errors.
FlexApp\Entity\CountryEntity	No errors.
WebBundle\Entity\StaticPageEntity	No errors.
FlexApp\Entity\InterviewEntity	No errors.
WebBundle\Entity\UserForeignAlias	No errors.
WebBundle\Entity\TransExEntity	No errors.
WebBundle\Entity\Participant	No errors.
WebBundle\Entity\FactoryUser	No errors.
WebBundle\Entity\SocialNetwork	No errors.
FlexApp\Entity\Mailing	No errors.
WebBundle\Entity\BuyOrderDelivery	No errors.
FlexApp\Entity\AttachmentEntity	No errors.
WebBundle\Entity\ListState	No errors.
WebBundle\Entity\ProductReviewsCache	No errors.
WebBundle\Entity\BuyOrderArticleHoliday	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\ListPrice	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.
FlexApp\Entity\GeoLocaleNameEntity	No errors.
FlexApp\Entity\GeoRegionEntity	No errors.
WebBundle\Entity\LocaleHtmlEntity	No errors.
WebBundle\Entity\LocaleTitleEntity	No errors.
WebBundle\Entity\ListEmailGroup	No errors.
WebBundle\Entity\ListApply	No errors.
WebBundle\Entity\FilterPageEntity	No errors.
WebBundle\Entity\FilterParamEntity	No errors.
WebBundle\Entity\LocaleUrlEntity	No errors.
WebBundle\Entity\FilterGroupEntity	No errors.
WebBundle\Entity\LocaleTextEntity	No errors.
WebBundle\Entity\LocaleBoolEntity	No errors.
FlexApp\Entity\Exhibition\ExhImageEntity	No errors.
WebBundle\Entity\LocaleMetaEntity	No errors.
FlexApp\Entity\Exhibition\ExhCollectionEntity	No errors.
WebBundle\Entity\CheckList	No errors.
WebBundle\Entity\ListBrandParser	No errors.
FlexApp\Entity\Exhibition\ExhBrandEntity	No errors.
WebBundle\Entity\PublicationLike	No errors.
WebBundle\Entity\LocalePreviewEntity	No errors.
WebBundle\Entity\LocaleStatusTranslateEntity	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/orders

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