Query Metrics
17
Database Queries
10
Different statements
90.20 ms
Query time
0
Invalid entities
Grouped Statements
default connection
| Time▼ | Count | Info |
|---|---|---|
|
75.19 ms (83.36%) |
1 |
SELECT t0.id AS id_1, t0.meta_title AS meta_title_2, t0.meta_description AS meta_description_3, t0.title AS title_4, t0.description AS description_5, t0.slug AS slug_6, t0.short_title AS short_title_7, t0.modified_at AS modified_at_8, t0.priority AS priority_9, t0.url AS url_10, t0.is_published AS is_published_11, t0.bitrix_id AS bitrix_id_12, t0.keywords AS keywords_13, t0.menu_title AS menu_title_14, t0.is_problems AS is_problems_15, t0.is_ready AS is_ready_16, t0.problems_string AS problems_string_17, t0.search_string AS search_string_18, t0.vote_count AS vote_count_19, t0.vote_sum AS vote_sum_20, t0.meta_ok AS meta_ok_21, t0.notice_field AS notice_field_22, t0.voc_code AS voc_code_23, t0.is_ready_pm AS is_ready_pm_24, t0.is_ready_cm AS is_ready_cm_25, t0.og_title AS og_title_26, t0.og_description AS og_description_27, t0.short_code AS short_code_28, t0.source_link AS source_link_29, t0.created_at AS created_at_30, t0.no_index AS no_index_31, t0.not_menu AS not_menu_32, t0.is_private AS is_private_33, t0.filtered_elements_count AS filtered_elements_count_34, t0.is_no_page AS is_no_page_35, t0.is_no_list AS is_no_list_36, t0.is_no_filter AS is_no_filter_37, t0.list_title AS list_title_38, t0.child_placeholder AS child_placeholder_39, t0.sort_order AS sort_order_40, t41.id AS id_42, t41.value AS value_43, t41.content_id AS content_id_44, t0.seo_type_id AS seo_type_id_45, t0.parent_id AS parent_id_46, t47.id AS id_48, t47.xml_id AS xml_id_49, t47.price_base AS price_base_50, t47.price_old AS price_old_51, t47.price_min AS price_min_52, t47.price_d1 AS price_d1_53, t47.price_d2 AS price_d2_54, t47.price_d1_from AS price_d1_from_55, t47.price_d2_from AS price_d2_from_56, t47.stock AS stock_57, t47.custom AS custom_58, t47.is_hit AS is_hit_59, t47.is_new AS is_new_60, t47.is_sale AS is_sale_61, t47.title AS title_62, t47.search AS search_63, t47.by_count AS by_count_64, t47.price_personal_from AS price_personal_from_65, t47.exclusive_dev AS exclusive_dev_66, t47.weight AS weight_67, t47.transport_length AS transport_length_68, t47.transport_width AS transport_width_69, t47.transport_height AS transport_height_70, t47.param_desc AS param_desc_71, t47.zakaz_days AS zakaz_days_72, t47.vendor_code AS vendor_code_73, t47.external_code AS external_code_74, t47.sort_order AS sort_order_75, t47.length AS length_76, t47.width AS width_77, t47.height AS height_78, t47.size_count AS size_count_79, t47.content_id AS content_id_80, t47.color_id AS color_id_81, t47.mark_id AS mark_id_82, t47.fluid_id AS fluid_id_83, t47.construction_id AS construction_id_84, t0.last_edit_user_id AS last_edit_user_id_85, t86.id AS id_87, t86.development AS development_88, t86.case_type AS case_type_89, t86.content_id AS content_id_90, t0.merge_to_id AS merge_to_id_91, t0.real_type_id AS real_type_id_92, t93.id AS id_94, t93.er_id AS er_id_95, t93.er_sku AS er_sku_96, t93.er_name AS er_name_97, t93.er_data AS er_data_98, t93.er_prices AS er_prices_99, t93.weight AS weight_100, t93.volume AS volume_101, t93.er_code AS er_code_102, t93.price_group AS price_group_103, t93.content_id AS content_id_104, t105.id AS id_106, t105.content_id AS content_id_107, t108.id AS id_109, t108.start_at AS start_at_110, t108.end_at AS end_at_111, t108.banner_title AS banner_title_112, t108.banner_badge AS banner_badge_113, t108.banner_comment AS banner_comment_114, t108.banner_image AS banner_image_115, t108.is_catalog_banner AS is_catalog_banner_116, t108.banner_link AS banner_link_117, t108.banner_link_text AS banner_link_text_118, t108.banner_delay AS banner_delay_119, t108.sort_order AS sort_order_120, t108.content_id AS content_id_121, t108.template_id AS template_id_122 FROM seo_content t0 LEFT JOIN seo_raw t41 ON t41.content_id = t0.id LEFT JOIN seo_product t47 ON t47.content_id = t0.id LEFT JOIN seo_portfolio t86 ON t86.content_id = t0.id LEFT JOIN erpzdc_prod t93 ON t93.content_id = t0.id LEFT JOIN seo_pseudo_category_group t105 ON t105.content_id = t0.id LEFT JOIN promo_action t108 ON t108.content_id = t0.id
Parameters:
[] |
|
8.30 ms (9.20%) |
8 |
SELECT t0.id AS id_1, t0.factor AS factor_2, t0.product_id AS product_id_3, t4.id AS id_5, t4.xml_id AS xml_id_6, t4.price_base AS price_base_7, t4.price_old AS price_old_8, t4.price_min AS price_min_9, t4.price_d1 AS price_d1_10, t4.price_d2 AS price_d2_11, t4.price_d1_from AS price_d1_from_12, t4.price_d2_from AS price_d2_from_13, t4.stock AS stock_14, t4.custom AS custom_15, t4.is_hit AS is_hit_16, t4.is_new AS is_new_17, t4.is_sale AS is_sale_18, t4.title AS title_19, t4.search AS search_20, t4.by_count AS by_count_21, t4.price_personal_from AS price_personal_from_22, t4.exclusive_dev AS exclusive_dev_23, t4.weight AS weight_24, t4.transport_length AS transport_length_25, t4.transport_width AS transport_width_26, t4.transport_height AS transport_height_27, t4.param_desc AS param_desc_28, t4.zakaz_days AS zakaz_days_29, t4.vendor_code AS vendor_code_30, t4.external_code AS external_code_31, t4.sort_order AS sort_order_32, t4.length AS length_33, t4.width AS width_34, t4.height AS height_35, t4.size_count AS size_count_36, t4.content_id AS content_id_37, t4.color_id AS color_id_38, t4.mark_id AS mark_id_39, t4.fluid_id AS fluid_id_40, t4.construction_id AS construction_id_41, t0.category_id AS category_id_42 FROM seo_product_sort t0 LEFT JOIN seo_product t4 ON t0.product_id = t4.id WHERE t0.product_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ 609 681 265 287 680 310 598 628 11 679 677 536 626 797 875 496 136 464 182 562 795 276 459 273 270 179 695 267 266 176 705 262 552 551 550 260 172 259 543 692 169 542 481 144 691 207 541 540 539 538 537 881 880 535 723 142 534 533 832 846 202 532 199 531 879 272 271 196 629 195 641 874 455 249 513 666 664 618 512 26 872 616 510 873 488 248 623 871 244 869 243 866 451 621 450 280 158 449 863 433 ] |
|
2.11 ms (2.34%) |
1 |
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.is_verified AS is_verified_5, t0.plain_password AS plain_password_6, t0.is_active AS is_active_7, t8.id AS id_9, t8.name AS name_10, t8.email AS email_11, t8.user_id AS user_id_12 FROM symfony_user t0 LEFT JOIN person t8 ON t8.user_id = t0.id WHERE t0.id = ?
Parameters:
[
1
]
|
|
1.04 ms (1.16%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.title AS title_3, t0.base_path AS base_path_4, t0.short_title AS short_title_5, t0.is_list AS is_list_6, t0.is_search AS is_search_7, t0.is_cart AS is_cart_8, t0.is_side_menu AS is_side_menu_9, t0.fast_order_title AS fast_order_title_10, t0.is_active AS is_active_11, t0.meta_title_template AS meta_title_template_12, t0.meta_description_template AS meta_description_template_13, t0.sort_order AS sort_order_14, t0.child_type_id AS child_type_id_15, t16.id AS id_17, t16.name AS name_18, t16.title AS title_19, t16.base_path AS base_path_20, t16.short_title AS short_title_21, t16.is_list AS is_list_22, t16.is_search AS is_search_23, t16.is_cart AS is_cart_24, t16.is_side_menu AS is_side_menu_25, t16.fast_order_title AS fast_order_title_26, t16.is_active AS is_active_27, t16.meta_title_template AS meta_title_template_28, t16.meta_description_template AS meta_description_template_29, t16.sort_order AS sort_order_30, t16.child_type_id AS child_type_id_31, t16.root_content_id AS root_content_id_32, t0.root_content_id AS root_content_id_33 FROM seo_type t0 LEFT JOIN seo_type t16 ON t16.child_type_id = t0.id
Parameters:
[] |
|
0.87 ms (0.96%) |
1 |
SELECT DISTINCT s0_.id AS id_0, s0_.id AS id_1 FROM seo_content s0_ WHERE s0_.is_published = ? AND s0_.seo_type_id = ? ORDER BY s0_.id DESC LIMIT 25
Parameters:
[ 1 25 ] |
|
0.83 ms (0.92%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.title AS title_3, t0.base_path AS base_path_4, t0.short_title AS short_title_5, t0.is_list AS is_list_6, t0.is_search AS is_search_7, t0.is_cart AS is_cart_8, t0.is_side_menu AS is_side_menu_9, t0.fast_order_title AS fast_order_title_10, t0.is_active AS is_active_11, t0.meta_title_template AS meta_title_template_12, t0.meta_description_template AS meta_description_template_13, t0.sort_order AS sort_order_14, t0.child_type_id AS child_type_id_15, t16.id AS id_17, t16.name AS name_18, t16.title AS title_19, t16.base_path AS base_path_20, t16.short_title AS short_title_21, t16.is_list AS is_list_22, t16.is_search AS is_search_23, t16.is_cart AS is_cart_24, t16.is_side_menu AS is_side_menu_25, t16.fast_order_title AS fast_order_title_26, t16.is_active AS is_active_27, t16.meta_title_template AS meta_title_template_28, t16.meta_description_template AS meta_description_template_29, t16.sort_order AS sort_order_30, t16.child_type_id AS child_type_id_31, t16.root_content_id AS root_content_id_32, t0.root_content_id AS root_content_id_33 FROM seo_type t0 LEFT JOIN seo_type t16 ON t16.child_type_id = t0.id WHERE t0.child_type_id = ?
Parameters:
[
1
]
|
|
0.57 ms (0.63%) |
1 |
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.is_verified AS is_verified_5, t0.plain_password AS plain_password_6, t0.is_active AS is_active_7, t8.id AS id_9, t8.name AS name_10, t8.email AS email_11, t8.user_id AS user_id_12 FROM symfony_user t0 LEFT JOIN person t8 ON t8.user_id = t0.id
Parameters:
[] |
|
0.53 ms (0.59%) |
1 |
SELECT t0.id AS id_1, t0.factor AS factor_2, t0.product_id AS product_id_3, t4.id AS id_5, t4.xml_id AS xml_id_6, t4.price_base AS price_base_7, t4.price_old AS price_old_8, t4.price_min AS price_min_9, t4.price_d1 AS price_d1_10, t4.price_d2 AS price_d2_11, t4.price_d1_from AS price_d1_from_12, t4.price_d2_from AS price_d2_from_13, t4.stock AS stock_14, t4.custom AS custom_15, t4.is_hit AS is_hit_16, t4.is_new AS is_new_17, t4.is_sale AS is_sale_18, t4.title AS title_19, t4.search AS search_20, t4.by_count AS by_count_21, t4.price_personal_from AS price_personal_from_22, t4.exclusive_dev AS exclusive_dev_23, t4.weight AS weight_24, t4.transport_length AS transport_length_25, t4.transport_width AS transport_width_26, t4.transport_height AS transport_height_27, t4.param_desc AS param_desc_28, t4.zakaz_days AS zakaz_days_29, t4.vendor_code AS vendor_code_30, t4.external_code AS external_code_31, t4.sort_order AS sort_order_32, t4.length AS length_33, t4.width AS width_34, t4.height AS height_35, t4.size_count AS size_count_36, t4.content_id AS content_id_37, t4.color_id AS color_id_38, t4.mark_id AS mark_id_39, t4.fluid_id AS fluid_id_40, t4.construction_id AS construction_id_41, t0.category_id AS category_id_42 FROM seo_product_sort t0 LEFT JOIN seo_product t4 ON t0.product_id = t4.id WHERE t0.product_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ 365 400 638 826 43 348 799 381 825 347 42 346 345 720 344 343 342 810 702 341 340 339 719 335 800 653 791 328 652 651 85 84 82 633 634 359 32 30 808 358 643 631 640 804 568 803 439 73 801 441 71 429 68 35 630 34 639 67 637 349 636 62 635 298 625 294 72 69 51 565 61 338 58 331 412 332 53 564 407 55 40 406 54 38 884 772 600 159 102 63 ] |
|
0.41 ms (0.45%) |
1 |
SELECT count(*) AS sclr_0 FROM seo_content s0_ WHERE s0_.is_published = ? AND s0_.seo_type_id = ?
Parameters:
[ 1 25 ] |
|
0.35 ms (0.38%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.email AS email_3, t0.user_id AS user_id_4 FROM person t0
Parameters:
[] |
Database Connections
| Name | Service |
|---|---|
| litedb | doctrine.dbal.litedb_connection |
| default | doctrine.dbal.default_connection |
Entity Managers
| Name | Service |
|---|---|
| litedb | doctrine.orm.litedb_entity_manager |
| default | doctrine.orm.default_entity_manager |
Second Level Cache
Second Level Cache is not enabled.
Entities Mapping
litedb entity manager
No loaded entities.