Query Metrics
20
Database Queries
14
Different statements
143.86 ms
Query time
0
Invalid entities
Queries
default connection
#▲ | Time | Info |
---|---|---|
1 | 5.77 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` = 'c5dd51ecc003db192e144b874914f3608ac266809280a8144aaf537b800c96bb' AND b0_.`status` <> 12 ORDER BY b0_.`create_date` DESC, b1_.`id` DESC, a3_.`amount` DESC
Parameters:
[] |
2 | 1.42 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:
[
"c5dd51ecc003db192e144b874914f3608ac266809280a8144aaf537b800c96bb"
]
|
3 | 0.54 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:
[
"c5dd51ecc003db192e144b874914f3608ac266809280a8144aaf537b800c96bb"
]
|
4 | 0.43 ms |
SELECT b0_.`id` AS id_0 FROM `buy_order` b0_ WHERE b0_.`token` = ? AND b0_.`status` <> 12
Parameters:
[
"c5dd51ecc003db192e144b874914f3608ac266809280a8144aaf537b800c96bb"
]
|
5 | 0.64 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:
[
"c5dd51ecc003db192e144b874914f3608ac266809280a8144aaf537b800c96bb"
]
|
6 | 3.00 ms |
SELECT COUNT(v0_.`id`) AS sclr_0 FROM `visit` v0_ WHERE v0_.`token` = ? AND v0_.`url` <> '/.*catalog.*/'
Parameters:
[
"c5dd51ecc003db192e144b874914f3608ac266809280a8144aaf537b800c96bb"
]
|
7 | 0.49 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:
[
"c5dd51ecc003db192e144b874914f3608ac266809280a8144aaf537b800c96bb"
]
|
8 | 0.39 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:
[
"at"
]
|
9 | 125.15 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 | 0.30 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 | 0.24 ms |
SELECT lu.de 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.de = 1 AND lst.de = 1;
Parameters:
[] |
12 | 1.97 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_.`de` AS de_6, f3_.`name_menu_de` AS name_menu_de_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_.`de` 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 | 1.04 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:
[
"c5dd51ecc003db192e144b874914f3608ac266809280a8144aaf537b800c96bb"
]
|
14 | 0.20 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:
[
"c5dd51ecc003db192e144b874914f3608ac266809280a8144aaf537b800c96bb"
]
|
15 | 0.13 ms |
SELECT b0_.`id` AS id_0 FROM `buy_order` b0_ WHERE b0_.`token` = ? AND b0_.`status` <> 12
Parameters:
[
"c5dd51ecc003db192e144b874914f3608ac266809280a8144aaf537b800c96bb"
]
|
16 | 0.78 ms |
SELECT COUNT(v0_.`id`) AS sclr_0 FROM `visit` v0_ WHERE v0_.`token` = ? AND v0_.`url` <> '/.*catalog.*/'
Parameters:
[
"c5dd51ecc003db192e144b874914f3608ac266809280a8144aaf537b800c96bb"
]
|
17 | 0.17 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:
[
"c5dd51ecc003db192e144b874914f3608ac266809280a8144aaf537b800c96bb"
]
|
18 | 0.24 ms |
SELECT b0_.`id` AS id_0, b0_.`name` AS name_1, b0_.`descr` AS descr_2, b0_.`val` AS val_3 FROM `BoolDBSetting` b0_ WHERE b0_.`name` = ?
Parameters:
[
"RTWidget"
]
|
19 | 0.71 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:
[
"c5dd51ecc003db192e144b874914f3608ac266809280a8144aaf537b800c96bb"
]
|
20 | 0.26 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.