Query Metrics

17 Database Queries
10 Different statements
148.67 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

default connection

Time▼ Count Info
122.37 ms
(82.31%)
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:
[]
12.39 ms
(8.33%)
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
]
8.43 ms
(5.67%)
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.17 ms
(1.46%)
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
]
1.08 ms
(0.72%)
1
SELECT count(*) AS sclr_0 FROM seo_content s0_ WHERE s0_.is_published = ? AND s0_.seo_type_id = ?
Parameters:
[
  1
  25
]
0.88 ms
(0.59%)
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.44 ms
(0.30%)
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.27%)
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.34 ms
(0.23%)
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.18 ms
(0.12%)
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.

default entity manager

Class Mapping errors
Shared\Entity\Main\User No errors.
Shared\Entity\Main\Person\Person No errors.
Shared\Entity\Main\UserRole No errors.
Shared\Entity\Main\Client\ClientBrowser No errors.
Shared\Entity\Main\Seo\SeoContent No errors.
Shared\Entity\Main\Seo\SeoType No errors.
Shared\Entity\Main\Seo\SeoRaw No errors.
Shared\Entity\Main\Seo\SeoProduct No errors.
Shared\Entity\Main\Seo\SeoProductColor No errors.
Shared\Entity\Main\Seo\SeoProductMark No errors.
Shared\Entity\Main\Seo\SeoProductFluid No errors.
Shared\Entity\Main\Construction\Construction No errors.
Shared\Entity\Main\Seo\SeoPortfolio No errors.
Shared\Entity\Main\Seo\ErpzdcProd No errors.
Shared\Entity\Main\Seo\SeoPseudoCategoryGroup No errors.
Shared\Entity\Main\Seo\PromoAction No errors.
Shared\Entity\Main\Seo\PromoActionTemplate No errors.
Shared\Entity\Main\Seo\SeoImage No errors.
Shared\Entity\Main\Seo\SeoVideo No errors.
Shared\Entity\Main\Seo\SeoParagraph No errors.
Shared\Entity\Main\Seo\OldSlug No errors.
Shared\Entity\Main\Seo\OldUrl No errors.
Shared\Entity\Main\Seo\SeoFile No errors.
Shared\Entity\Main\Seo\SeoLink No errors.
Shared\Entity\Main\Seo\ContentChanges No errors.
Shared\Entity\Main\Seo\SeoTag No errors.
Shared\Entity\Main\Client\OrderCalc No errors.
Shared\Entity\Main\Seo\SearchQuery No errors.
Shared\Entity\Main\Seo\SeoFaq No errors.
Shared\Entity\Main\Seo\SeoFaqGroup No errors.
Shared\Entity\Main\Seo\SeoElement No errors.
Shared\Entity\Main\Seo\SeoBlockContent No errors.
Shared\Entity\Main\Seo\SearchStat No errors.
Shared\Entity\Main\Client\AiAnswer No errors.
Shared\Entity\Main\Seo\SeoPrice No errors.
Shared\Entity\Main\Seo\SeoProductOptions No errors.
Shared\Entity\Main\Seo\SeoProductPurpose No errors.
Shared\Entity\Main\Seo\SeoProductSegment No errors.
Shared\Entity\Main\Seo\SeoProductSort No errors.
Shared\Entity\Main\Seo\ErpzdcClass No errors.
Shared\Entity\Main\Seo\ErpzdcTerm No errors.
Shared\Entity\Main\Seo\SeoSite No errors.
Shared\Entity\Main\Seo\SeoBlockContentType No errors.