Query Metrics
98
Database Queries
23
Different statements
140.37 ms
Query time
0
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
16.16 ms (11.51%) |
9 |
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.object_id AS object_id_5 FROM application_translations t0 WHERE t0.object_id = ?
Parameters:
[
9
]
|
9.95 ms (7.09%) |
9 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.icon AS icon_4, t0.ordine AS ordine_5, t0.createdAt AS createdAt_6, t0.updatedAt AS updatedAt_7, t0.deletedAt AS deletedAt_8 FROM categories t0 INNER JOIN applications_categories ON t0.id = applications_categories.category_id WHERE applications_categories.application_id = ? AND ((t0.deletedAt IS NULL))
Parameters:
[
9
]
|
7.95 ms (5.67%) |
9 |
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.object_id AS object_id_5 FROM document_translations t0 WHERE t0.object_id = ?
Parameters:
[
201
]
|
7.62 ms (5.43%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.revision AS revision_4, t0.publicRevision AS publicRevision_5, t0.image AS image_6, t0.active AS active_7, t0.createdAt AS createdAt_8, t0.updatedAt AS updatedAt_9, t0.deletedAt AS deletedAt_10 FROM products t0 WHERE t0.id = ? AND ((t0.deletedAt IS NULL))
Parameters:
[
"78"
]
|
7.09 ms (5.05%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.createdAt AS createdAt_3, t0.updatedAt AS updatedAt_4, t0.deletedAt AS deletedAt_5 FROM applications t0 INNER JOIN main_page_applications ON t0.id = main_page_applications.application_id WHERE main_page_applications.main_page_id = ? AND ((t0.deletedAt IS NULL))
Parameters:
[
42
]
|
6.94 ms (4.95%) |
9 |
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.object_id AS object_id_5 FROM attribute_name_translations t0 WHERE t0.object_id = ?
Parameters:
[
162
]
|
6.83 ms (4.87%) |
9 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.createdAt AS createdAt_3, t0.updatedAt AS updatedAt_4, t0.deletedAt AS deletedAt_5 FROM attribute_names t0 WHERE t0.id = ? AND ((t0.deletedAt IS NULL))
Parameters:
[
162
]
|
6.40 ms (4.56%) |
5 |
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.object_id AS object_id_5 FROM image_page_translations t0 WHERE t0.object_id = ?
Parameters:
[
51
]
|
6.05 ms (4.31%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.note AS note_3, t0.pageType AS pageType_4, t0.pageId AS pageId_5, t0.ordine AS ordine_6, t0.createdAt AS createdAt_7, t0.updatedAt AS updatedAt_8, t0.deletedAt AS deletedAt_9, t0.product_id AS product_id_10 FROM document t0 WHERE t0.product_id = ? AND ((t0.deletedAt IS NULL)) ORDER BY t0.ordine ASC
Parameters:
[
78
]
|
6.04 ms (4.30%) |
9 |
SELECT t0.id AS id_1, t0.createdAt AS createdAt_2, t0.updatedAt AS updatedAt_3, t0.deletedAt AS deletedAt_4, t0.attribute_name_id AS attribute_name_id_5, t0.attribute_value_id AS attribute_value_id_6 FROM attribute_name_value t0 WHERE t0.id = ? AND ((t0.deletedAt IS NULL))
Parameters:
[
194
]
|
6.03 ms (4.29%) |
6 |
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.object_id AS object_id_5 FROM category_translations t0 WHERE t0.object_id = ?
Parameters:
[
1
]
|
5.95 ms (4.24%) |
1 |
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.object_id AS object_id_5 FROM product_translations t0 WHERE t0.object_id = ?
Parameters:
[
78
]
|
5.63 ms (4.01%) |
7 |
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.object_id AS object_id_5 FROM attribute_value_translations t0 WHERE t0.object_id = ?
Parameters:
[
146
]
|
5.41 ms (3.85%) |
5 |
SELECT t0.id AS id_1, t0.title AS title_2, t0.image AS image_3, t0.description AS description_4, t0.createdAt AS createdAt_5, t0.updatedAt AS updatedAt_6, t0.deletedAt AS deletedAt_7 FROM image_pages t0 WHERE t0.id = ? AND ((t0.deletedAt IS NULL))
Parameters:
[
51
]
|
5.16 ms (3.68%) |
2 |
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.object_id AS object_id_5 FROM text_page_translations t0 WHERE t0.object_id = ?
Parameters:
[
59
]
|
5.12 ms (3.64%) |
7 |
SELECT t0.id AS id_1, t0.value AS value_2, t0.createdAt AS createdAt_3, t0.updatedAt AS updatedAt_4, t0.deletedAt AS deletedAt_5 FROM attribute_values t0 WHERE t0.id = ? AND ((t0.deletedAt IS NULL))
Parameters:
[
146
]
|
4.85 ms (3.45%) |
1 |
SELECT t0.id AS id_1, t0.ordine AS ordine_2, t0.radio_page_id AS radio_page_id_3, t0.eav_id AS eav_id_4 FROM RadioEav t0 WHERE t0.radio_page_id = ?
Parameters:
[
29
]
|
4.83 ms (3.44%) |
2 |
SELECT t0.id AS id_1, t0.title AS title_2, t0.text AS text_3, t0.createdAt AS createdAt_4, t0.updatedAt AS updatedAt_5, t0.deletedAt AS deletedAt_6 FROM text_pages t0 WHERE t0.id = ? AND ((t0.deletedAt IS NULL))
Parameters:
[
59
]
|
4.25 ms (3.02%) |
1 |
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.object_id AS object_id_5 FROM radio_page_translations t0 WHERE t0.object_id = ?
Parameters:
[
29
]
|
3.63 ms (2.58%) |
1 |
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.object_id AS object_id_5 FROM main_page_translations t0 WHERE t0.object_id = ?
Parameters:
[
42
]
|
3.12 ms (2.22%) |
1 |
SELECT t0.id AS id_1, t0.title AS title_2, t0.text AS text_3, t0.createdAt AS createdAt_4, t0.updatedAt AS updatedAt_5, t0.deletedAt AS deletedAt_6 FROM main_pages t0 WHERE t0.id = ? AND ((t0.deletedAt IS NULL))
Parameters:
[
42
]
|
2.73 ms (1.95%) |
1 |
SELECT t0.id AS id_1, t0.title AS title_2, t0.createdAt AS createdAt_3, t0.updatedAt AS updatedAt_4, t0.deletedAt AS deletedAt_5 FROM radio_pages t0 WHERE t0.id = ? AND ((t0.deletedAt IS NULL))
Parameters:
[
29
]
|
2.64 ms (1.88%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.icon AS icon_4, t0.ordine AS ordine_5, t0.createdAt AS createdAt_6, t0.updatedAt AS updatedAt_7, t0.deletedAt AS deletedAt_8 FROM categories t0 WHERE ((t0.deletedAt IS NULL))
Parameters:
[] |
Database Connections
Name | Service |
---|---|
default | doctrine.dbal.default_connection |
Entity Managers
Name | Service |
---|---|
default | doctrine.orm.default_entity_manager |
Second Level Cache
Second Level Cache is not enabled.
Entities Mapping
Class | Mapping errors |
---|---|
App\Entity\Product | No errors. |
Gedmo\Translatable\Entity\MappedSuperclass\AbstractPersonalTranslation | No errors. |
App\Entity\ProductTranslation | No errors. |
App\Entity\Document | No errors. |
App\Entity\DocumentTranslation | No errors. |
App\Entity\MainPage | No errors. |
App\Entity\Application | No errors. |
App\Entity\MainPageTranslation | No errors. |
App\Entity\TextPage | No errors. |
App\Entity\TextPageTranslation | No errors. |
App\Entity\ImagePage | No errors. |
App\Entity\ImagePageTranslation | No errors. |
App\Entity\RadioPage | No errors. |
App\Entity\RadioEav | No errors. |
App\Entity\RadioPageTranslation | No errors. |
App\Entity\Category | No errors. |
App\Entity\CategoryTranslation | No errors. |
App\Entity\ApplicationTranslation | No errors. |
App\Entity\AttributeNameValue | No errors. |
App\Entity\AttributeName | No errors. |
App\Entity\AttributeValue | No errors. |
App\Entity\AttributeNameTranslation | No errors. |
App\Entity\AttributeValueTranslation | No errors. |