Query Metrics

20 Database Queries
14 Different statements
165.49 ms Query time
0 Invalid entities

Queries

Group similar statements

default connection

# Time Info
1 3.89 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_.`check_breakdown` AS check_breakdown_77, b0_.`truspilot_review_requested` AS truspilot_review_requested_78, b0_.`collection_review_requested` AS collection_review_requested_79, b0_.`prohibit_send_review_request` AS prohibit_send_review_request_80, b1_.`id` AS id_81, b1_.`type` AS type_82, b1_.`article_time_type` AS article_time_type_83, b1_.`code` AS code_84, b1_.`packaging_count` AS packaging_count_85, b1_.`packaging` AS packaging_86, b1_.`pallet` AS pallet_87, b1_.`multiple_pallet` AS multiple_pallet_88, b1_.`weight` AS weight_89, b1_.`amount` AS amount_90, b1_.`price` AS price_91, b1_.`price_eur` AS price_eur_92, b1_.`currency` AS currency_93, b1_.`measure` AS measure_94, b1_.`delivery_time_min` AS delivery_time_min_95, b1_.`delivery_time_max` AS delivery_time_max_96, b1_.`delivery_time_min_faster` AS delivery_time_min_faster_97, b1_.`delivery_time_max_faster` AS delivery_time_max_faster_98, b1_.`delivery_time_confirm_min` AS delivery_time_confirm_min_99, b1_.`delivery_time_confirm_max` AS delivery_time_confirm_max_100, b1_.`holiday` AS holiday_101, b1_.`sample_format` AS sample_format_102, b1_.`sample_type` AS sample_type_103, b1_.`sample_code` AS sample_code_104, b1_.`swimming_pool` AS swimming_pool_105, b1_.`add_time` AS add_time_106, a2_.`id` AS id_107, a2_.`code` AS code_108, a2_.`name` AS name_109, a2_.`alternate_name` AS alternate_name_110, a2_.`urla` AS urla_111, a2_.`file` AS file_112, a2_.`size_x` AS size_x_113, a2_.`size_y` AS size_y_114, a2_.`size_gb_x` AS size_gb_x_115, a2_.`size_gb_y` AS size_gb_y_116, a2_.`size_tessera` AS size_tessera_117, a2_.`file_size1_x` AS file_size1_x_118, a2_.`file_size1_y` AS file_size1_y_119, a2_.`file_size2_x` AS file_size2_x_120, a2_.`file_size2_y` AS file_size2_y_121, a2_.`file_size3_x` AS file_size3_x_122, a2_.`file_size3_y` AS file_size3_y_123, a2_.`file_size500_x` AS file_size500_x_124, a2_.`file_size500_y` AS file_size500_y_125, a2_.`file_size740_x` AS file_size740_x_126, a2_.`file_size740_y` AS file_size740_y_127, a2_.`file_size8_x` AS file_size8_x_128, a2_.`file_size8_y` AS file_size8_y_129, a2_.`pallet` AS pallet_130, a2_.`pallet_ft` AS pallet_ft_131, a2_.`type_constraint` AS type_constraint_132, a2_.`multiple_pallet` AS multiple_pallet_133, a2_.`min_order` AS min_order_134, a2_.`price_euro` AS price_euro_135, a2_.`price_mq_euro` AS price_mq_euro_136, a2_.`price_euro_de` AS price_euro_de_137, a2_.`price_mq_euro_de` AS price_mq_euro_de_138, a2_.`price_euro_at` AS price_euro_at_139, a2_.`price_mq_euro_at` AS price_mq_euro_at_140, a2_.`price_euro_fi` AS price_euro_fi_141, a2_.`price_mq_euro_fi` AS price_mq_euro_fi_142, a2_.`price_euro_fr` AS price_euro_fr_143, a2_.`price_mq_euro_fr` AS price_mq_euro_fr_144, a2_.`price_euro_it` AS price_euro_it_145, a2_.`price_mq_euro_it` AS price_mq_euro_it_146, a2_.`price_euro_be` AS price_euro_be_147, a2_.`price_mq_euro_be` AS price_mq_euro_be_148, a2_.`price_euro_ie` AS price_euro_ie_149, a2_.`price_mq_euro_ie` AS price_mq_euro_ie_150, a2_.`price_euro_nl` AS price_euro_nl_151, a2_.`price_mq_euro_nl` AS price_mq_euro_nl_152, a2_.`price_euro_es` AS price_euro_es_153, a2_.`price_mq_euro_es` AS price_mq_euro_es_154, a2_.`price_rub` AS price_rub_155, a2_.`price_rue` AS price_rue_156, a2_.`price_mq_rub` AS price_mq_rub_157, a2_.`price_mq_rue` AS price_mq_rue_158, a2_.`price_gbp` AS price_gbp_159, a2_.`price_gbe` AS price_gbe_160, a2_.`price_mq_gbp` AS price_mq_gbp_161, a2_.`price_mq_gbe` AS price_mq_gbe_162, a2_.`price_usd` AS price_usd_163, a2_.`price_use` AS price_use_164, a2_.`price_fq_usd` AS price_fq_usd_165, a2_.`price_fq_use` AS price_fq_use_166, a2_.`price_mq_usd` AS price_mq_usd_167, a2_.`price_mq_use` AS price_mq_use_168, a2_.`price_chf` AS price_chf_169, a2_.`price_che` AS price_che_170, a2_.`price_mq_chf` AS price_mq_chf_171, a2_.`price_mq_che` AS price_mq_che_172, a2_.`price_sek` AS price_sek_173, a2_.`price_see` AS price_see_174, a2_.`price_mq_sek` AS price_mq_sek_175, a2_.`price_mq_see` AS price_mq_see_176, a2_.`price_dkk` AS price_dkk_177, a2_.`price_dke` AS price_dke_178, a2_.`price_mq_dkk` AS price_mq_dkk_179, a2_.`price_mq_dke` AS price_mq_dke_180, a2_.`price_nok` AS price_nok_181, a2_.`price_noe` AS price_noe_182, a2_.`price_mq_nok` AS price_mq_nok_183, a2_.`price_mq_noe` AS price_mq_noe_184, a2_.`price_pln` AS price_pln_185, a2_.`price_ple` AS price_ple_186, a2_.`price_mq_pln` AS price_mq_pln_187, a2_.`price_mq_ple` AS price_mq_ple_188, a2_.`price_cad` AS price_cad_189, a2_.`price_cae` AS price_cae_190, a2_.`price_fq_cad` AS price_fq_cad_191, a2_.`price_fq_cae` AS price_fq_cae_192, a2_.`price_mq_cad` AS price_mq_cad_193, a2_.`price_mq_cae` AS price_mq_cae_194, a2_.`thick` AS thick_195, a2_.`weight` AS weight_196, a2_.`packaging_count` AS packaging_count_197, a2_.`packaging_count_ft` AS packaging_count_ft_198, a2_.`packaging_count_pc` AS packaging_count_pc_199, a2_.`m2one_ps` AS m2one_ps_200, a2_.`description_ru` AS description_ru_201, a2_.`description_en` AS description_en_202, a2_.`description_it` AS description_it_203, a2_.`description_es` AS description_es_204, a2_.`description_fr` AS description_fr_205, a2_.`description_de` AS description_de_206, a2_.`description_pt` AS description_pt_207, a2_.`description_pl` AS description_pl_208, a2_.`description_nl` AS description_nl_209, a2_.`description_fi` AS description_fi_210, a2_.`description_ua` AS description_ua_211, a2_.`description_sv` AS description_sv_212, a2_.`description_no` AS description_no_213, a2_.`description_da` AS description_da_214, a2_.`description_cn` AS description_cn_215, a2_.`scheme` AS scheme_216, a2_.`sale_date` AS sale_date_217, a2_.`thin_granite` AS thin_granite_218, a2_.`glazed_granite` AS glazed_granite_219, a2_.`pei` AS pei_220, a2_.`is_grouped` AS is_grouped_221, a2_.`is_rotate` AS is_rotate_222, a2_.`price_prx` AS price_prx_223, a2_.`background_white` AS background_white_224, a2_.`border_grey` AS border_grey_225, a2_.`is_edit` AS is_edit_226, a2_.`edited_at` AS edited_at_227, a2_.`comment` AS comment_228, a2_.`file_edit` AS file_edit_229, a2_.`image_setting` AS image_setting_230, a2_.`file_w` AS file_w_231, a2_.`file_h` AS file_h_232, a2_.`file_w4000` AS file_w4000_233, a2_.`file_h4000` AS file_h4000_234, a2_.`size_z` AS size_z_235, a2_.`size_gb_z` AS size_gb_z_236, a2_.`repeat_number` AS repeat_number_237, a2_.`size_big` AS size_big_238, a2_.`delivery_suspended` AS delivery_suspended_239, a2_.`poddon_x` AS poddon_x_240, a2_.`poddon_y` AS poddon_y_241, a2_.`poddon_z` AS poddon_z_242, a2_.`module` AS module_243, a2_.`tessera_size_x` AS tessera_size_x_244, a2_.`tessera_size_y` AS tessera_size_y_245, a2_.`tessera_size_z` AS tessera_size_z_246, a2_.`poddon_count` AS poddon_count_247, a2_.`poddon_weight` AS poddon_weight_248, a2_.`added_to_cart` AS added_to_cart_249, a2_.`sold_out` AS sold_out_250, a2_.`sold_out_vol` AS sold_out_vol_251, a2_.`swimming_pool` AS swimming_pool_252, a2_.`can_select_substrate` AS can_select_substrate_253, a2_.`designer` AS designer_254, a2_.`designer_id` AS designer_id_255, a2_.`mosaic_effect` AS mosaic_effect_256, a2_.`not_sample` AS not_sample_257, a2_.`express_sample` AS express_sample_258, a2_.`description_edit` AS description_edit_259, a2_.`comment_scheme_image` AS comment_scheme_image_260, a2_.`variant_image` AS variant_image_261, a2_.`square` AS square_262, a2_.`fix_big_size` AS fix_big_size_263, a2_.`overflow_sink` AS overflow_sink_264, a2_.`drain_size_sink` AS drain_size_sink_265, a2_.`faucet_hole_sink` AS faucet_hole_sink_266, a2_.`rotate` AS rotate_267, a2_.`dyed_in_mass` AS dyed_in_mass_268, a2_.`durability_class` AS durability_class_269, a2_.`is_comment_ru` AS is_comment_ru_270, a2_.`file_rotation` AS file_rotation_271, a2_.`created_at` AS created_at_272, a2_.`updated_at` AS updated_at_273, a3_.`id` AS id_274, a3_.`amount` AS amount_275, a3_.`amount_ft` AS amount_ft_276, a3_.`fold` AS fold_277, a3_.`price` AS price_278, a3_.`price_euro` AS price_euro_279, a3_.`price_euro_de` AS price_euro_de_280, a3_.`price_euro_at` AS price_euro_at_281, a3_.`price_euro_fi` AS price_euro_fi_282, a3_.`price_euro_fr` AS price_euro_fr_283, a3_.`price_euro_it` AS price_euro_it_284, a3_.`price_euro_be` AS price_euro_be_285, a3_.`price_euro_ie` AS price_euro_ie_286, a3_.`price_euro_nl` AS price_euro_nl_287, a3_.`price_euro_es` AS price_euro_es_288, a3_.`price_rub` AS price_rub_289, a3_.`price_rue` AS price_rue_290, a3_.`price_gbp` AS price_gbp_291, a3_.`price_gbe` AS price_gbe_292, a3_.`price_usd` AS price_usd_293, a3_.`price_use` AS price_use_294, a3_.`price_fq_usd` AS price_fq_usd_295, a3_.`price_fq_use` AS price_fq_use_296, a3_.`price_chf` AS price_chf_297, a3_.`price_che` AS price_che_298, a3_.`price_sek` AS price_sek_299, a3_.`price_see` AS price_see_300, a3_.`price_dkk` AS price_dkk_301, a3_.`price_dke` AS price_dke_302, a3_.`price_nok` AS price_nok_303, a3_.`price_noe` AS price_noe_304, a3_.`price_pln` AS price_pln_305, a3_.`price_ple` AS price_ple_306, a3_.`price_cad` AS price_cad_307, a3_.`price_cae` AS price_cae_308, a3_.`price_fq_cad` AS price_fq_cad_309, a3_.`price_fq_cae` AS price_fq_cae_310, a3_.`del` AS del_311, b0_.user_id AS user_id_312, b0_.warehouse AS warehouse_313, b0_.address_recipient AS address_recipient_314, b0_.address_payer AS address_payer_315, b0_.delivery_country AS delivery_country_316, b0_.mailing_id AS mailing_id_317, b0_.buy_order_manager AS buy_order_manager_318, b1_.buy_order_id AS buy_order_id_319, b1_.article_id AS article_id_320, a2_.collection AS collection_321, a2_.newCollection AS newCollection_322, a2_.type AS type_323, a2_.measure AS measure_324, a2_.surface AS surface_325, a2_.pr_status AS pr_status_326, a2_.category_price AS category_price_327, a2_.edge_type AS edge_type_328, a2_.using AS using_329, a2_.shape AS shape_330, a2_.material AS material_331, a2_.delivery AS delivery_332, a2_.sliding AS sliding_333, a2_.off_shade AS off_shade_334, a2_.style AS style_335, a2_.repeat_draw AS repeat_draw_336, a2_.measurement_size AS measurement_size_337, a2_.installation_type AS installation_type_338, a2_.meth_laying AS meth_laying_339, a2_.draw AS draw_340, a3_.article AS article_341 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` = 'd95878d33b4418b1a0066d66c182c842ffde71e4fd113ec483be66742929215b' AND b0_.`status` <> 12 ORDER BY b0_.`create_date` DESC, b1_.`id` DESC, a3_.`amount` DESC
Parameters:
[]
2 1.85 ms
SELECT u0_.`id` AS id_0, u0_.`unid` AS unid_1, u0_.`corporate_unid` AS corporate_unid_2, u0_.`token` AS token_3, u0_.`is_active` AS is_active_4, u0_.`proved` AS proved_5, u0_.`alias` AS alias_6, u0_.`foreign_alias` AS foreign_alias_7, u0_.`lotus_name` AS lotus_name_8, u0_.`password` AS password_9, u0_.`expired` AS expired_10, u0_.`expires_at` AS expires_at_11, u0_.`credentials_expired` AS credentials_expired_12, u0_.`credentials_expire_at` AS credentials_expire_at_13, u0_.`last_ip` AS last_ip_14, u0_.`source` AS source_15, u0_.`social_network` AS social_network_16, u0_.`social_network_id` AS social_network_id_17, u0_.`google_id` AS google_id_18, u0_.`fb_id` AS fb_id_19, u0_.`vk_id` AS vk_id_20, u0_.`ig_id` AS ig_id_21, u0_.`test` AS test_22, u0_.`token_fixed` AS token_fixed_23, u0_.`bid` AS bid_24, u0_.`email` AS email_25, u0_.`salt` AS salt_26, u0_.`review_request_sent` AS review_request_sent_27, u0_.`username` AS username_28, u0_.`roles` AS roles_29, u0_.`enabled` AS enabled_30, u0_.`confirmation_token` AS confirmation_token_31, u0_.`last_login` AS last_login_32, u0_.`password_requested_at` AS password_requested_at_33, u0_.`security_field` AS security_field_34, u0_.`created_at` AS created_at_35, u0_.`is_legal_entity` AS is_legal_entity_36, u0_.`companyName` AS companyName_37, u0_.`vatNumber` AS vatNumber_38, u0_.`lang` AS lang_39 FROM `user` u0_ WHERE u0_.`token` = ? LIMIT 1
Parameters:
[
  "d95878d33b4418b1a0066d66c182c842ffde71e4fd113ec483be66742929215b"
]
3 0.23 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:
[
  "d95878d33b4418b1a0066d66c182c842ffde71e4fd113ec483be66742929215b"
]
4 0.16 ms
SELECT b0_.`id` AS id_0 FROM `buy_order` b0_ WHERE b0_.`token` = ? AND b0_.`status` <> 12
Parameters:
[
  "d95878d33b4418b1a0066d66c182c842ffde71e4fd113ec483be66742929215b"
]
5 0.19 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:
[
  "d95878d33b4418b1a0066d66c182c842ffde71e4fd113ec483be66742929215b"
]
6 1.90 ms
SELECT COUNT(v0_.`id`) AS sclr_0 FROM `visit` v0_ WHERE v0_.`token` = ? AND v0_.`url` <> '/.*catalog.*/'
Parameters:
[
  "d95878d33b4418b1a0066d66c182c842ffde71e4fd113ec483be66742929215b"
]
7 0.21 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:
[
  "d95878d33b4418b1a0066d66c182c842ffde71e4fd113ec483be66742929215b"
]
8 1.28 ms
SELECT f0_.`id` AS id_0 FROM `geo_country` g1_ LEFT JOIN factory_hide_countries f2_ ON g1_.id = f2_.country_id LEFT JOIN `factory` f0_ ON f0_.id = f2_.factory_id WHERE g1_.`code` = ?
Parameters:
[
  "gr"
]
9 135.35 ms
SELECT c0_.`id` AS id_0, c0_.`url` AS url_1, c0_.`code` AS code_2, c0_.`name` AS name_3, c0_.`alternate_name` AS alternate_name_4, c0_.`name_full` AS name_full_5, f1_.`id` AS id_6, f1_.`url` AS url_7, f1_.`unid` AS unid_8, f2_.`id` AS id_9, f1_.`url` AS url_10, f1_.`name` AS name_11, (SELECT COUNT(p3_.`star`) AS sclr_13 FROM `product_reviews_cache` p3_ WHERE p3_.`sku` = c0_.`code`) AS sclr_12, (SELECT SUM(p4_.`star`) AS sclr_15 FROM `product_reviews_cache` p4_ WHERE p4_.`sku` = c0_.`code`) AS sclr_14 FROM `collection` c0_ INNER JOIN `factory` f1_ ON c0_.factory = f1_.id INNER JOIN `filters` f2_ ON f1_.filter = f2_.id INNER JOIN `list_country` l5_ ON f1_.country = l5_.id LEFT JOIN `locale_url` l6_ ON f2_.id = l6_.filter_id LEFT JOIN `filter_pages` f7_ ON f2_.page_id = f7_.id WHERE f1_.filter IS NOT NULL AND c0_.factory <> '' AND f1_.`status` = ? AND (c0_.`test_access` IS NULL OR c0_.`test_access` = 0) AND (f1_.`test_access` IS NULL OR f1_.`test_access` = 0) AND c0_.`status` = ? AND c0_.`status` = ? AND f1_.`status` = ? ORDER BY c0_.`id` ASC
Parameters:
[
  1
  1
  1
  1
]
10 2.10 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
]
11 2.63 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:
[]
12 2.01 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"
  ]
]
13 9.58 ms
SELECT u0_.`id` AS id_0, u0_.`unid` AS unid_1, u0_.`corporate_unid` AS corporate_unid_2, u0_.`token` AS token_3, u0_.`is_active` AS is_active_4, u0_.`proved` AS proved_5, u0_.`alias` AS alias_6, u0_.`foreign_alias` AS foreign_alias_7, u0_.`lotus_name` AS lotus_name_8, u0_.`password` AS password_9, u0_.`expired` AS expired_10, u0_.`expires_at` AS expires_at_11, u0_.`credentials_expired` AS credentials_expired_12, u0_.`credentials_expire_at` AS credentials_expire_at_13, u0_.`last_ip` AS last_ip_14, u0_.`source` AS source_15, u0_.`social_network` AS social_network_16, u0_.`social_network_id` AS social_network_id_17, u0_.`google_id` AS google_id_18, u0_.`fb_id` AS fb_id_19, u0_.`vk_id` AS vk_id_20, u0_.`ig_id` AS ig_id_21, u0_.`test` AS test_22, u0_.`token_fixed` AS token_fixed_23, u0_.`bid` AS bid_24, u0_.`email` AS email_25, u0_.`salt` AS salt_26, u0_.`review_request_sent` AS review_request_sent_27, u0_.`username` AS username_28, u0_.`roles` AS roles_29, u0_.`enabled` AS enabled_30, u0_.`confirmation_token` AS confirmation_token_31, u0_.`last_login` AS last_login_32, u0_.`password_requested_at` AS password_requested_at_33, u0_.`security_field` AS security_field_34, u0_.`created_at` AS created_at_35, u0_.`is_legal_entity` AS is_legal_entity_36, u0_.`companyName` AS companyName_37, u0_.`vatNumber` AS vatNumber_38, u0_.`lang` AS lang_39 FROM `user` u0_ WHERE u0_.`token` = ? LIMIT 1
Parameters:
[
  "d95878d33b4418b1a0066d66c182c842ffde71e4fd113ec483be66742929215b"
]
14 0.90 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:
[
  "d95878d33b4418b1a0066d66c182c842ffde71e4fd113ec483be66742929215b"
]
15 0.19 ms
SELECT b0_.`id` AS id_0 FROM `buy_order` b0_ WHERE b0_.`token` = ? AND b0_.`status` <> 12
Parameters:
[
  "d95878d33b4418b1a0066d66c182c842ffde71e4fd113ec483be66742929215b"
]
16 0.68 ms
SELECT COUNT(v0_.`id`) AS sclr_0 FROM `visit` v0_ WHERE v0_.`token` = ? AND v0_.`url` <> '/.*catalog.*/'
Parameters:
[
  "d95878d33b4418b1a0066d66c182c842ffde71e4fd113ec483be66742929215b"
]
17 0.75 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:
[
  "d95878d33b4418b1a0066d66c182c842ffde71e4fd113ec483be66742929215b"
]
18 0.82 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"
]
19 0.46 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:
[
  "d95878d33b4418b1a0066d66c182c842ffde71e4fd113ec483be66742929215b"
]
20 0.30 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"
]

oneC connection

No database queries were performed.

logs connection

No database queries were performed.

Database Connections

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

Entity Managers

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

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

default entity manager

Class Mapping errors
WebBundle\Entity\User No errors.
WebBundle\Entity\BuyOrder No errors.
WebBundle\Entity\BuyOrderArticle No errors.
WebBundle\Entity\Article No errors.
WebBundle\Entity\ListCountry No errors.
WebBundle\Entity\ArticlePriceDiscount No errors.
WebBundle\Entity\WarehouseEntity No errors.
WebBundle\Entity\OrderAddress No errors.
FlexApp\Entity\Mailing No errors.
WebBundle\Entity\BuyOrderManager No errors.
WebBundle\Entity\Collection No errors.
FlexApp\Entity\Collection\CollectionEntity No errors.
WebBundle\Entity\ListType No errors.
WebBundle\Entity\ListMeasure No errors.
WebBundle\Entity\ListSurface No errors.
WebBundle\Entity\ListPRStatus No errors.
WebBundle\Entity\ListPrice No errors.
WebBundle\Entity\ListEdgeType No errors.
WebBundle\Entity\ListUsing No errors.
WebBundle\Entity\ListShape No errors.
WebBundle\Entity\ListMaterial No errors.
WebBundle\Entity\ListDelivery No errors.
WebBundle\Entity\ListSliding No errors.
WebBundle\Entity\ListOffShade No errors.
WebBundle\Entity\ListStyle No errors.
WebBundle\Entity\ListRepeatDraw No errors.
WebBundle\Entity\ListMeasureSize No errors.
WebBundle\Entity\ListSink No errors.
WebBundle\Entity\ListMethLaying No errors.
WebBundle\Entity\ListDraw No errors.
FlexApp\Entity\ChatB No errors.
FlexApp\Entity\ChatBMessage No errors.
FlexApp\Entity\BoolDBSetting No errors.
FlexApp\Entity\Widget No errors.
FlexApp\Entity\CountryAndLangSpecificDataEntity No errors.
FlexApp\Entity\ConsultantEntity No errors.
FlexApp\Entity\GeoCountryEntity No errors.
WebBundle\Entity\ListEmail No errors.
WebBundle\Entity\OrderHistory No errors.
WebBundle\Entity\OrderPayment No errors.
WebBundle\Entity\CurrencyRate No errors.
WebBundle\Entity\ListVat No errors.
WebBundle\Entity\Visit No errors.
WebBundle\Entity\Idea No errors.
WebBundle\Entity\FilterEntity No errors.
WebBundle\Entity\Factory No errors.
WebBundle\Entity\Publication No errors.
FlexApp\Entity\InterviewEntity No errors.

oneC entity manager

No loaded entities.

logs entity manager

No loaded entities.