Query Metrics
134
Database Queries
12
Different statements
75.96 ms
Query time
0
Invalid entities
Grouped Statements
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.
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\Person\Manager | No errors. |
Shared\Entity\Main\Seo\SeoContent | No errors. |
Shared\Entity\Main\Seo\SeoType | No errors. |
Shared\Entity\Main\Seo\SeoImage | No errors. |
Shared\Entity\Main\Seo\SeoRaw | 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\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\ContentChanges | No errors. |
Shared\Entity\Main\Seo\SeoTag | No errors. |
Shared\Entity\Main\Seo\SeoSite | No errors. |