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

Query Metrics

44 Database Queries
12 Different statements
21.05 ms Query time
0 Invalid entities
108 Managed entities

Queries

Group similar statements

# Time Info
1 0.47 ms
SELECT t0.id AS id_1, t0.value AS value_2, t0.slug AS slug_3 FROM prim_language t0
Parameters:
[]
2 10.27 ms
SELECT count(DISTINCT p0_.id) AS sclr_0 FROM prim_catalogue_subcategory_2 p0_ LEFT JOIN prim_catalogue_subcategory_2_detail p1_ ON p0_.id = p1_.subcategory_2_id LEFT JOIN prim_catalogue_subcategory_1 p2_ ON p0_.subcategory_1_id = p2_.id LEFT JOIN prim_catalogue_subcategory_1_detail p3_ ON p2_.id = p3_.subcategory_1_id LEFT JOIN prim_catalogue_category p4_ ON p2_.category_id = p4_.id LEFT JOIN prim_catalogue_category_detail p5_ ON p4_.id = p5_.category_id WHERE 1 = 1
Parameters:
[]
3 0.75 ms
SELECT DISTINCT p0_.id AS id_0 FROM prim_catalogue_subcategory_2 p0_ LEFT JOIN prim_catalogue_subcategory_2_detail p1_ ON p0_.id = p1_.subcategory_2_id LEFT JOIN prim_catalogue_subcategory_1 p2_ ON p0_.subcategory_1_id = p2_.id LEFT JOIN prim_catalogue_subcategory_1_detail p3_ ON p2_.id = p3_.subcategory_1_id LEFT JOIN prim_catalogue_category p4_ ON p2_.category_id = p4_.id LEFT JOIN prim_catalogue_category_detail p5_ ON p4_.id = p5_.category_id WHERE 1 = 1 LIMIT 15
Parameters:
[]
4 0.75 ms
SELECT p0_.id AS id_0, p0_.subcategory_1_id AS subcategory_1_id_1 FROM prim_catalogue_subcategory_2 p0_ LEFT JOIN prim_catalogue_subcategory_2_detail p1_ ON p0_.id = p1_.subcategory_2_id LEFT JOIN prim_catalogue_subcategory_1 p2_ ON p0_.subcategory_1_id = p2_.id LEFT JOIN prim_catalogue_subcategory_1_detail p3_ ON p2_.id = p3_.subcategory_1_id LEFT JOIN prim_catalogue_category p4_ ON p2_.category_id = p4_.id LEFT JOIN prim_catalogue_category_detail p5_ ON p4_.id = p5_.category_id WHERE 1 = 1 AND p0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  "1"
  "54"
  "55"
  "56"
  "57"
  "58"
  "59"
  "60"
  "61"
  "2"
  "3"
  "4"
  "5"
  "6"
  "7"
]
5 0.50 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:
[
  "1"
]
6 0.23 ms
SELECT t0.id AS id_1, t0.category_id AS category_id_2 FROM prim_catalogue_subcategory_1 t0 WHERE t0.id = ?
Parameters:
[
  "3"
]
7 0.19 ms
SELECT t0.id AS id_1 FROM prim_catalogue_category t0 WHERE t0.id = ?
Parameters:
[
  "4"
]
8 0.21 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"
]
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:
[
  "3"
]
10 0.19 ms
SELECT t0.id AS id_1, t0.subcategory_2_id AS subcategory_2_id_2 FROM prim_catalogue_subcategory_3 t0 WHERE t0.subcategory_2_id = ?
Parameters:
[
  "1"
]
11 0.24 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:
[
  "2"
]
12 0.20 ms
SELECT t0.id AS id_1, t0.category_id AS category_id_2 FROM prim_catalogue_subcategory_1 t0 WHERE t0.id = ?
Parameters:
[
  "4"
]
13 0.19 ms
SELECT t0.id AS id_1 FROM prim_catalogue_category t0 WHERE t0.id = ?
Parameters:
[
  "8"
]
14 0.21 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.24 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.27 ms
SELECT t0.id AS id_1, t0.subcategory_2_id AS subcategory_2_id_2 FROM prim_catalogue_subcategory_3 t0 WHERE t0.subcategory_2_id = ?
Parameters:
[
  "2"
]
17 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"
]
18 0.25 ms
SELECT t0.id AS id_1, t0.subcategory_2_id AS subcategory_2_id_2 FROM prim_catalogue_subcategory_3 t0 WHERE t0.subcategory_2_id = ?
Parameters:
[
  "3"
]
19 0.20 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:
[
  "4"
]
20 0.23 ms
SELECT t0.id AS id_1, t0.subcategory_2_id AS subcategory_2_id_2 FROM prim_catalogue_subcategory_3 t0 WHERE t0.subcategory_2_id = ?
Parameters:
[
  "4"
]
21 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:
[
  "5"
]
22 0.16 ms
SELECT t0.id AS id_1, t0.subcategory_2_id AS subcategory_2_id_2 FROM prim_catalogue_subcategory_3 t0 WHERE t0.subcategory_2_id = ?
Parameters:
[
  "5"
]
23 0.19 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:
[
  "6"
]
24 0.19 ms
SELECT t0.id AS id_1, t0.subcategory_2_id AS subcategory_2_id_2 FROM prim_catalogue_subcategory_3 t0 WHERE t0.subcategory_2_id = ?
Parameters:
[
  "6"
]
25 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:
[
  "7"
]
26 0.20 ms
SELECT t0.id AS id_1, t0.subcategory_2_id AS subcategory_2_id_2 FROM prim_catalogue_subcategory_3 t0 WHERE t0.subcategory_2_id = ?
Parameters:
[
  "7"
]
27 0.21 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:
[
  "54"
]
28 0.19 ms
SELECT t0.id AS id_1, t0.subcategory_2_id AS subcategory_2_id_2 FROM prim_catalogue_subcategory_3 t0 WHERE t0.subcategory_2_id = ?
Parameters:
[
  "54"
]
29 0.32 ms
SELECT t0.id AS id_1, t0.is_active AS is_active_2, t0.is_expirable AS is_expirable_3, t0.directory_path AS directory_path_4, t0.warranty_path AS warranty_path_5, t0.iqb_code_id AS iqb_code_id_6, t0.ean_code_id AS ean_code_id_7, t0.watermark_id AS watermark_id_8, t0.category_id AS category_id_9, t0.producer_id AS producer_id_10, t0.trademark_id AS trademark_id_11, t0.subcategory_1_id AS subcategory_1_id_12, t0.subcategory_2_id AS subcategory_2_id_13, t0.subcategory_3_id AS subcategory_3_id_14, t0.subcategory_4_id AS subcategory_4_id_15 FROM prim_catalogue_product t0 WHERE t0.subcategory_2_id = ?
Parameters:
[
  "54"
]
30 0.27 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.image_path AS image_path_4, t0.start_date AS start_date_5, t0.end_date AS end_date_6, t0.is_table_active AS is_table_active_7, t0.is_map_active AS is_map_active_8, t0.is_url_active AS is_url_active_9, t0.watermark_id AS watermark_id_10, t0.brand_id AS brand_id_11, t0.category_id AS category_id_12, t0.subcategory1_id AS subcategory1_id_13, t0.subcategory2_id AS subcategory2_id_14, t0.subcategory3_id AS subcategory3_id_15, t0.subcategory4_id AS subcategory4_id_16, t0.product_id AS product_id_17 FROM prim_panel t0 WHERE t0.subcategory2_id = ?
Parameters:
[
  "54"
]
31 0.20 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:
[
  "55"
]
32 0.23 ms
SELECT t0.id AS id_1, t0.subcategory_2_id AS subcategory_2_id_2 FROM prim_catalogue_subcategory_3 t0 WHERE t0.subcategory_2_id = ?
Parameters:
[
  "55"
]
33 0.18 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:
[
  "56"
]
34 0.22 ms
SELECT t0.id AS id_1, t0.subcategory_2_id AS subcategory_2_id_2 FROM prim_catalogue_subcategory_3 t0 WHERE t0.subcategory_2_id = ?
Parameters:
[
  "56"
]
35 0.19 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:
[
  "57"
]
36 0.18 ms
SELECT t0.id AS id_1, t0.subcategory_2_id AS subcategory_2_id_2 FROM prim_catalogue_subcategory_3 t0 WHERE t0.subcategory_2_id = ?
Parameters:
[
  "57"
]
37 0.27 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:
[
  "58"
]
38 0.19 ms
SELECT t0.id AS id_1, t0.subcategory_2_id AS subcategory_2_id_2 FROM prim_catalogue_subcategory_3 t0 WHERE t0.subcategory_2_id = ?
Parameters:
[
  "58"
]
39 0.20 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:
[
  "59"
]
40 0.16 ms
SELECT t0.id AS id_1, t0.subcategory_2_id AS subcategory_2_id_2 FROM prim_catalogue_subcategory_3 t0 WHERE t0.subcategory_2_id = ?
Parameters:
[
  "59"
]
41 0.17 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:
[
  "60"
]
42 0.20 ms
SELECT t0.id AS id_1, t0.subcategory_2_id AS subcategory_2_id_2 FROM prim_catalogue_subcategory_3 t0 WHERE t0.subcategory_2_id = ?
Parameters:
[
  "60"
]
43 0.23 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:
[
  "61"
]
44 0.23 ms
SELECT t0.id AS id_1, t0.subcategory_2_id AS subcategory_2_id_2 FROM prim_catalogue_subcategory_3 t0 WHERE t0.subcategory_2_id = ?
Parameters:
[
  "61"
]

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\Subcategory3 46
App\Entity\Catalogue\Subcategory2Detail 30
App\Entity\Catalogue\Subcategory2 15
App\Entity\Catalogue\CategoryDetail 6
App\Entity\Catalogue\Subcategory1Detail 4
App\Entity\Language 3
App\Entity\Catalogue\Subcategory1 2
App\Entity\Catalogue\Category 2