GET https://primigenagroup.com/admin/configurazioni/catalogo/sottocategorie/livello-4/nuova

Query Metrics

19 Database Queries
9 Different statements
5.37 ms Query time
0 Invalid entities
43 Managed entities

Grouped Statements

Show all queries

Time Count Info
1.08 ms
(20.06%)
5
SELECT t0.id AS id_1, t0.name AS name_2, t0.subcategory_3_id AS subcategory_3_id_3, t0.language_id AS language_id_4 FROM prim_catalogue_subcategory_3_detail t0 WHERE t0.subcategory_3_id = ?
Parameters:
[
  "1"
]
0.77 ms
(14.37%)
2
SELECT t0.id AS id_1, t0.subcategory_1_id AS subcategory_1_id_2 FROM prim_catalogue_subcategory_2 t0 WHERE t0.id = ?
Parameters:
[
  "1"
]
0.66 ms
(12.34%)
1
SELECT p0_.id AS id_0, p0_.subcategory_2_id AS subcategory_2_id_1 FROM prim_catalogue_subcategory_3 p0_ LEFT JOIN prim_catalogue_subcategory_3_detail p1_ ON p0_.id = p1_.subcategory_3_id LEFT JOIN prim_catalogue_subcategory_2 p2_ ON p0_.subcategory_2_id = p2_.id LEFT JOIN prim_catalogue_subcategory_1 p3_ ON p2_.subcategory_1_id = p3_.id LEFT JOIN prim_catalogue_category p4_ ON p3_.category_id = p4_.id WHERE 1 = 1 AND p1_.name LIKE ? LIMIT 15
Parameters:
[
  "%%"
]
0.52 ms
(9.76%)
1
SELECT t0.id AS id_1, t0.value AS value_2, t0.slug AS slug_3 FROM prim_language t0
Parameters:
[]
0.50 ms
(9.40%)
2
SELECT t0.id AS id_1 FROM prim_catalogue_category t0 WHERE t0.id = ?
Parameters:
[
  "4"
]
0.47 ms
(8.83%)
2
SELECT t0.id AS id_1, t0.name AS name_2, t0.subcategory_2_id AS subcategory_2_id_3, t0.language_id AS language_id_4 FROM prim_catalogue_subcategory_2_detail t0 WHERE t0.subcategory_2_id = ?
Parameters:
[
  "1"
]
0.47 ms
(8.72%)
2
SELECT t0.id AS id_1, t0.category_id AS category_id_2 FROM prim_catalogue_subcategory_1 t0 WHERE t0.id = ?
Parameters:
[
  "3"
]
0.46 ms
(8.52%)
2
SELECT t0.id AS id_1, t0.name AS name_2, t0.category_id AS category_id_3, t0.language_id AS language_id_4 FROM prim_catalogue_category_detail t0 WHERE t0.category_id = ?
Parameters:
[
  "4"
]
0.43 ms
(8.01%)
2
SELECT t0.id AS id_1, t0.name AS name_2, t0.subcategory_1_id AS subcategory_1_id_3, t0.language_id AS language_id_4 FROM prim_catalogue_subcategory_1_detail t0 WHERE t0.subcategory_1_id = ?
Parameters:
[
  "3"
]

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.

Managed Entities

default entity manager

Class Amount of managed objects
App\Entity\Catalogue\Subcategory3Detail 15
App\Entity\Catalogue\CategoryDetail 6
App\Entity\Catalogue\Subcategory3 5
App\Entity\Catalogue\Subcategory1Detail 4
App\Entity\Catalogue\Subcategory2Detail 4
App\Entity\Language 3
App\Entity\Catalogue\Subcategory2 2
App\Entity\Catalogue\Subcategory1 2
App\Entity\Catalogue\Category 2