GET https://www.primigenagroup.com/admin/configurazioni/catalogo/sottocategorie/livello-2/3/modifica

Query Metrics

29 Database Queries
7 Different statements
6.42 ms Query time
0 Invalid entities
70 Managed entities

Queries

Group similar statements

# Time Info
1 0.39 ms
SELECT t0.id AS id_1, t0.value AS value_2, t0.slug AS slug_3 FROM prim_language t0
Parameters:
[]
2 0.46 ms
SELECT p0_.id AS id_0, p0_.category_id AS category_id_1 FROM prim_catalogue_subcategory_1 p0_ LEFT JOIN prim_catalogue_subcategory_1_detail p1_ ON p0_.id = p1_.subcategory_1_id LEFT JOIN prim_catalogue_category p2_ ON p0_.category_id = p2_.id WHERE p1_.name LIKE ? LIMIT 15
Parameters:
[
  "%%"
]
3 0.26 ms
SELECT t0.id AS id_1, t0.subcategory_1_id AS subcategory_1_id_2 FROM prim_catalogue_subcategory_2 t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
  "3"
]
4 0.62 ms
SELECT t0.id AS id_1 FROM prim_catalogue_category t0 WHERE t0.id = ?
Parameters:
[
  "1"
]
5 0.38 ms
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:
[
  "1"
]
6 0.25 ms
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:
[
  "1"
]
7 0.21 ms
SELECT t0.id AS id_1 FROM prim_catalogue_category t0 WHERE t0.id = ?
Parameters:
[
  "2"
]
8 0.22 ms
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:
[
  "2"
]
9 0.23 ms
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:
[
  "2"
]
10 0.22 ms
SELECT t0.id AS id_1 FROM prim_catalogue_category t0 WHERE t0.id = ?
Parameters:
[
  "4"
]
11 0.16 ms
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"
]
12 0.17 ms
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"
]
13 0.23 ms
SELECT t0.id AS id_1 FROM prim_catalogue_category t0 WHERE t0.id = ?
Parameters:
[
  "8"
]
14 0.18 ms
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:
[
  "8"
]
15 0.16 ms
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:
[
  "4"
]
16 0.16 ms
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:
[
  "5"
]
17 0.16 ms
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:
[
  "6"
]
18 0.12 ms
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:
[
  "7"
]
19 0.11 ms
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:
[
  "8"
]
20 0.12 ms
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:
[
  "9"
]
21 0.18 ms
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:
[
  "10"
]
22 0.16 ms
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:
[
  "11"
]
23 0.16 ms
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:
[
  "12"
]
24 0.13 ms
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:
[
  "13"
]
25 0.19 ms
SELECT t0.id AS id_1 FROM prim_catalogue_category t0 WHERE t0.id = ?
Parameters:
[
  "6"
]
26 0.15 ms
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:
[
  "6"
]
27 0.18 ms
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:
[
  "14"
]
28 0.22 ms
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:
[
  "15"
]
29 0.22 ms
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:
[
  "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\Subcategory1Detail 29
App\Entity\Catalogue\Subcategory1 15
App\Entity\Catalogue\CategoryDetail 15
App\Entity\Catalogue\Category 5
App\Entity\Language 3
App\Entity\Catalogue\Subcategory2Detail 2
App\Entity\Catalogue\Subcategory2 1