http://gvfiltri.echocreative.it/en/printer/download/78

Query Metrics

98 Database Queries
23 Different statements
140.37 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

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.