Query Metrics

134 Database Queries
12 Different statements
75.96 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

default connection

Time Count Info
14.27 ms
(18.78%)
25
SELECT t0.id AS id_1, t0.seo_name AS seo_name_2, t0.alt_text AS alt_text_3, t0.sort_order AS sort_order_4, t0.is_page_preview AS is_page_preview_5, t0.raw_name AS raw_name_6, t0.old_path AS old_path_7, t0.default_alt_text AS default_alt_text_8, t0.paragraph_id AS paragraph_id_9, t0.content_id AS content_id_10 FROM seo_image t0 WHERE t0.content_id = ? ORDER BY t0.id ASC
Parameters:
[
  130
]
14.22 ms
(18.72%)
25
SELECT t0.id AS id_1, t0.url AS url_2, t0.title AS title_3, t0.thumbnail_url AS thumbnail_url_4, t0.created_at AS created_at_5, t0.description AS description_6, t0.slug AS slug_7, t0.title_default AS title_default_8, t0.description_default AS description_default_9, t0.content_id AS content_id_10 FROM seo_video t0 WHERE t0.content_id = ?
Parameters:
[
  130
]
13.92 ms
(18.32%)
25
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.text AS text_4, t0.raw_value AS raw_value_5, t0.bitrix_id AS bitrix_id_6, t0.sort_order AS sort_order_7, t0.content_id AS content_id_8 FROM seo_paragraph t0 WHERE t0.content_id = ? ORDER BY t0.id ASC
Parameters:
[
  130
]
12.92 ms
(17.01%)
25
SELECT t0.id AS id_1, t0.xml_id AS xml_id_2, t0.price_base AS price_base_3, t0.price_old AS price_old_4, t0.price_min AS price_min_5, t0.price_d1 AS price_d1_6, t0.price_d2 AS price_d2_7, t0.price_d1_from AS price_d1_from_8, t0.price_d2_from AS price_d2_from_9, t0.stock AS stock_10, t0.custom AS custom_11, t0.is_hit AS is_hit_12, t0.is_new AS is_new_13, t0.is_sale AS is_sale_14, t0.title AS title_15, t0.search AS search_16, t0.by_count AS by_count_17, t0.price_personal_from AS price_personal_from_18, t0.exclusive_dev AS exclusive_dev_19, t0.vendor_code AS vendor_code_20, t0.external_code AS external_code_21, t0.sort_order AS sort_order_22, t0.length AS length_23, t0.width AS width_24, t0.height AS height_25, t0.size_count AS size_count_26, t0.content_id AS content_id_27, t0.color_id AS color_id_28, t0.mark_id AS mark_id_29, t0.fluid_id AS fluid_id_30, t0.construction_id AS construction_id_31 FROM seo_product t0 WHERE t0.content_id = ?
Parameters:
[
  130
]
12.65 ms
(16.65%)
25
SELECT t0.id AS id_1, t0.value AS value_2, t0.content_id AS content_id_3 FROM seo_raw t0 WHERE t0.content_id = ?
Parameters:
[
  130
]
3.35 ms
(4.41%)
3
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.sort_order AS sort_order_24, t25.id AS id_26, t25.value AS value_27, t25.content_id AS content_id_28, t0.seo_type_id AS seo_type_id_29, t0.parent_id AS parent_id_30, t31.id AS id_32, t31.xml_id AS xml_id_33, t31.price_base AS price_base_34, t31.price_old AS price_old_35, t31.price_min AS price_min_36, t31.price_d1 AS price_d1_37, t31.price_d2 AS price_d2_38, t31.price_d1_from AS price_d1_from_39, t31.price_d2_from AS price_d2_from_40, t31.stock AS stock_41, t31.custom AS custom_42, t31.is_hit AS is_hit_43, t31.is_new AS is_new_44, t31.is_sale AS is_sale_45, t31.title AS title_46, t31.search AS search_47, t31.by_count AS by_count_48, t31.price_personal_from AS price_personal_from_49, t31.exclusive_dev AS exclusive_dev_50, t31.vendor_code AS vendor_code_51, t31.external_code AS external_code_52, t31.sort_order AS sort_order_53, t31.length AS length_54, t31.width AS width_55, t31.height AS height_56, t31.size_count AS size_count_57, t31.content_id AS content_id_58, t31.color_id AS color_id_59, t31.mark_id AS mark_id_60, t31.fluid_id AS fluid_id_61, t31.construction_id AS construction_id_62, t0.last_edit_user_id AS last_edit_user_id_63 FROM seo_content t0 LEFT JOIN seo_raw t25 ON t25.content_id = t0.id LEFT JOIN seo_product t31 ON t31.content_id = t0.id WHERE t0.id = ?
Parameters:
[
  52
]
1.29 ms
(1.70%)
1
SELECT s0_.id AS id_0, s0_.meta_title AS meta_title_1, s0_.meta_description AS meta_description_2, s0_.title AS title_3, s0_.description AS description_4, s0_.slug AS slug_5, s0_.short_title AS short_title_6, s0_.modified_at AS modified_at_7, s0_.priority AS priority_8, s0_.url AS url_9, s0_.is_published AS is_published_10, s0_.bitrix_id AS bitrix_id_11, s0_.keywords AS keywords_12, s0_.menu_title AS menu_title_13, s0_.is_problems AS is_problems_14, s0_.is_ready AS is_ready_15, s0_.problems_string AS problems_string_16, s0_.search_string AS search_string_17, s0_.vote_count AS vote_count_18, s0_.vote_sum AS vote_sum_19, s0_.meta_ok AS meta_ok_20, s0_.notice_field AS notice_field_21, s0_.voc_code AS voc_code_22, s0_.sort_order AS sort_order_23, s0_.seo_type_id AS seo_type_id_24, s0_.parent_id AS parent_id_25, s0_.last_edit_user_id AS last_edit_user_id_26 FROM seo_content s0_ WHERE s0_.is_published = ? AND s0_.seo_type_id = ? AND s0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY s0_.id DESC
Parameters:
[
  1
  1
  130
  129
  126
  125
  124
  123
  122
  121
  120
  119
  118
  117
  116
  115
  114
  113
  112
  110
  109
  108
  107
  103
  101
  100
  96
]
0.92 ms
(1.21%)
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
  1
]
0.75 ms
(0.99%)
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
]
0.66 ms
(0.87%)
1
SELECT COUNT(s0_.id) AS sclr_0 FROM seo_content s0_ WHERE s0_.is_published = ? AND s0_.seo_type_id = ?
Parameters:
[
  1
  1
]
0.53 ms
(0.69%)
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 FROM seo_type t0 WHERE t0.id = ?
Parameters:
[
  1
]
0.50 ms
(0.66%)
1
SELECT t0.id AS id_1, t0.is_active AS is_active_2, t0.person_id AS person_id_3 FROM manager t0 WHERE t0.person_id = ?
Parameters:
[
  22
]

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.