GET https://www.primigenagroup.com/admin/configurazioni/catalogo/smaltimento

Query Metrics

38 Database Queries
7 Different statements
16.14 ms Query time
0 Invalid entities
227 Managed entities

Queries

Group similar statements

# Time Info
1 1.95 ms
SELECT count(DISTINCT p0_.id) AS sclr_0 FROM prim_catalogue_recycling p0_ LEFT JOIN prim_language p1_ ON p0_.language_id = p1_.id WHERE 1 = 1
Parameters:
[]
2 0.54 ms
SELECT DISTINCT p0_.id AS id_0, p1_.id AS id_1, p0_.name AS name_2 FROM prim_catalogue_recycling p0_ LEFT JOIN prim_language p1_ ON p0_.language_id = p1_.id WHERE 1 = 1 ORDER BY p1_.id ASC, p0_.name ASC LIMIT 30
Parameters:
[]
3 0.59 ms
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.image_path AS image_path_2, p0_.recycling_category_id AS recycling_category_id_3, p0_.language_id AS language_id_4 FROM prim_catalogue_recycling p0_ LEFT JOIN prim_language p1_ ON p0_.language_id = p1_.id WHERE 1 = 1 AND p0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY p1_.id ASC, p0_.name ASC
Parameters:
[
  "1"
  "2"
  "3"
  "4"
  "29"
  "43"
  "42"
  "44"
  "37"
  "5"
  "6"
  "7"
  "41"
  "9"
  "45"
  "40"
  "31"
  "10"
  "39"
  "12"
  "13"
  "14"
  "15"
  "11"
  "28"
  "34"
  "17"
  "18"
  "19"
  "20"
]
4 0.69 ms
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.language_id AS language_id_2 FROM prim_catalogue_recycling_category p0_
Parameters:
[]
5 0.38 ms
SELECT t0.id AS id_1, t0.value AS value_2, t0.slug AS slug_3 FROM prim_language t0 WHERE t0.id = ?
Parameters:
[
  "1"
]
6 0.56 ms
SELECT t0.id AS id_1, t0.value AS value_2, t0.slug AS slug_3 FROM prim_language t0 WHERE t0.id = ?
Parameters:
[
  "2"
]
7 0.30 ms
SELECT t0.id AS id_1, t0.value AS value_2, t0.slug AS slug_3 FROM prim_language t0 WHERE t0.id = ?
Parameters:
[
  "3"
]
8 0.30 ms
SELECT p0_.id AS id_0, p0_.value AS value_1, p0_.slug AS slug_2 FROM prim_language p0_
Parameters:
[]
9 2.89 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.product_detail_id AS product_detail_id_3, t0.recycling_id AS recycling_id_4 FROM prim_catalogue_join_table_product_detail_recycling t0 WHERE t0.recycling_id = ?
Parameters:
[
  "1"
]
10 0.39 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.product_detail_id AS product_detail_id_3, t0.recycling_id AS recycling_id_4 FROM prim_catalogue_join_table_product_detail_recycling t0 WHERE t0.recycling_id = ?
Parameters:
[
  "2"
]
11 0.74 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.product_detail_id AS product_detail_id_3, t0.recycling_id AS recycling_id_4 FROM prim_catalogue_join_table_product_detail_recycling t0 WHERE t0.recycling_id = ?
Parameters:
[
  "3"
]
12 0.50 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.product_detail_id AS product_detail_id_3, t0.recycling_id AS recycling_id_4 FROM prim_catalogue_join_table_product_detail_recycling t0 WHERE t0.recycling_id = ?
Parameters:
[
  "4"
]
13 0.40 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.product_detail_id AS product_detail_id_3, t0.recycling_id AS recycling_id_4 FROM prim_catalogue_join_table_product_detail_recycling t0 WHERE t0.recycling_id = ?
Parameters:
[
  "29"
]
14 0.37 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.product_detail_id AS product_detail_id_3, t0.recycling_id AS recycling_id_4 FROM prim_catalogue_join_table_product_detail_recycling t0 WHERE t0.recycling_id = ?
Parameters:
[
  "43"
]
15 0.29 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.product_detail_id AS product_detail_id_3, t0.recycling_id AS recycling_id_4 FROM prim_catalogue_join_table_product_detail_recycling t0 WHERE t0.recycling_id = ?
Parameters:
[
  "42"
]
16 0.24 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.product_detail_id AS product_detail_id_3, t0.recycling_id AS recycling_id_4 FROM prim_catalogue_join_table_product_detail_recycling t0 WHERE t0.recycling_id = ?
Parameters:
[
  "44"
]
17 0.24 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.product_detail_id AS product_detail_id_3, t0.recycling_id AS recycling_id_4 FROM prim_catalogue_join_table_product_detail_recycling t0 WHERE t0.recycling_id = ?
Parameters:
[
  "37"
]
18 0.27 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.product_detail_id AS product_detail_id_3, t0.recycling_id AS recycling_id_4 FROM prim_catalogue_join_table_product_detail_recycling t0 WHERE t0.recycling_id = ?
Parameters:
[
  "5"
]
19 0.25 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.product_detail_id AS product_detail_id_3, t0.recycling_id AS recycling_id_4 FROM prim_catalogue_join_table_product_detail_recycling t0 WHERE t0.recycling_id = ?
Parameters:
[
  "6"
]
20 0.19 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.product_detail_id AS product_detail_id_3, t0.recycling_id AS recycling_id_4 FROM prim_catalogue_join_table_product_detail_recycling t0 WHERE t0.recycling_id = ?
Parameters:
[
  "7"
]
21 0.20 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.product_detail_id AS product_detail_id_3, t0.recycling_id AS recycling_id_4 FROM prim_catalogue_join_table_product_detail_recycling t0 WHERE t0.recycling_id = ?
Parameters:
[
  "41"
]
22 0.21 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.product_detail_id AS product_detail_id_3, t0.recycling_id AS recycling_id_4 FROM prim_catalogue_join_table_product_detail_recycling t0 WHERE t0.recycling_id = ?
Parameters:
[
  "9"
]
23 0.23 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.product_detail_id AS product_detail_id_3, t0.recycling_id AS recycling_id_4 FROM prim_catalogue_join_table_product_detail_recycling t0 WHERE t0.recycling_id = ?
Parameters:
[
  "45"
]
24 0.21 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.product_detail_id AS product_detail_id_3, t0.recycling_id AS recycling_id_4 FROM prim_catalogue_join_table_product_detail_recycling t0 WHERE t0.recycling_id = ?
Parameters:
[
  "40"
]
25 0.23 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.product_detail_id AS product_detail_id_3, t0.recycling_id AS recycling_id_4 FROM prim_catalogue_join_table_product_detail_recycling t0 WHERE t0.recycling_id = ?
Parameters:
[
  "31"
]
26 0.24 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.product_detail_id AS product_detail_id_3, t0.recycling_id AS recycling_id_4 FROM prim_catalogue_join_table_product_detail_recycling t0 WHERE t0.recycling_id = ?
Parameters:
[
  "10"
]
27 0.21 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.product_detail_id AS product_detail_id_3, t0.recycling_id AS recycling_id_4 FROM prim_catalogue_join_table_product_detail_recycling t0 WHERE t0.recycling_id = ?
Parameters:
[
  "39"
]
28 0.22 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.product_detail_id AS product_detail_id_3, t0.recycling_id AS recycling_id_4 FROM prim_catalogue_join_table_product_detail_recycling t0 WHERE t0.recycling_id = ?
Parameters:
[
  "12"
]
29 0.23 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.product_detail_id AS product_detail_id_3, t0.recycling_id AS recycling_id_4 FROM prim_catalogue_join_table_product_detail_recycling t0 WHERE t0.recycling_id = ?
Parameters:
[
  "13"
]
30 0.26 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.product_detail_id AS product_detail_id_3, t0.recycling_id AS recycling_id_4 FROM prim_catalogue_join_table_product_detail_recycling t0 WHERE t0.recycling_id = ?
Parameters:
[
  "14"
]
31 0.24 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.product_detail_id AS product_detail_id_3, t0.recycling_id AS recycling_id_4 FROM prim_catalogue_join_table_product_detail_recycling t0 WHERE t0.recycling_id = ?
Parameters:
[
  "15"
]
32 0.21 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.product_detail_id AS product_detail_id_3, t0.recycling_id AS recycling_id_4 FROM prim_catalogue_join_table_product_detail_recycling t0 WHERE t0.recycling_id = ?
Parameters:
[
  "11"
]
33 0.23 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.product_detail_id AS product_detail_id_3, t0.recycling_id AS recycling_id_4 FROM prim_catalogue_join_table_product_detail_recycling t0 WHERE t0.recycling_id = ?
Parameters:
[
  "28"
]
34 0.25 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.product_detail_id AS product_detail_id_3, t0.recycling_id AS recycling_id_4 FROM prim_catalogue_join_table_product_detail_recycling t0 WHERE t0.recycling_id = ?
Parameters:
[
  "34"
]
35 0.23 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.product_detail_id AS product_detail_id_3, t0.recycling_id AS recycling_id_4 FROM prim_catalogue_join_table_product_detail_recycling t0 WHERE t0.recycling_id = ?
Parameters:
[
  "17"
]
36 0.25 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.product_detail_id AS product_detail_id_3, t0.recycling_id AS recycling_id_4 FROM prim_catalogue_join_table_product_detail_recycling t0 WHERE t0.recycling_id = ?
Parameters:
[
  "18"
]
37 0.23 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.product_detail_id AS product_detail_id_3, t0.recycling_id AS recycling_id_4 FROM prim_catalogue_join_table_product_detail_recycling t0 WHERE t0.recycling_id = ?
Parameters:
[
  "19"
]
38 0.21 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.product_detail_id AS product_detail_id_3, t0.recycling_id AS recycling_id_4 FROM prim_catalogue_join_table_product_detail_recycling t0 WHERE t0.recycling_id = ?
Parameters:
[
  "20"
]

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\JoinTableProductDetailRecycling 104
App\Entity\Catalogue\ProductDetail 72
App\Entity\Catalogue\Recycling 30
App\Entity\Catalogue\RecyclingCategory 18
App\Entity\Language 3