GET https://primigenagroup.com/admin/configurazioni/catalogo/smaltimento?page=2

Query Metrics

18 Database Queries
7 Different statements
5.16 ms Query time
0 Invalid entities
108 Managed entities

Grouped Statements

Show all queries

Time Count Info
2.09 ms
(40.49%)
10
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:
[
  "16"
]
0.71 ms
(13.65%)
3
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"
]
0.61 ms
(11.83%)
1
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:
[]
0.53 ms
(10.23%)
1
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:
[]
0.50 ms
(9.74%)
1
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 OFFSET 30
Parameters:
[]
0.50 ms
(9.72%)
1
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:
[
  "16"
  "21"
  "22"
  "23"
  "24"
  "25"
  "26"
  "30"
  "35"
  "27"
]
0.22 ms
(4.34%)
1
SELECT p0_.id AS id_0, p0_.value AS value_1, p0_.slug AS slug_2 FROM prim_language p0_
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.

Managed Entities

default entity manager

Class Amount of managed objects
App\Entity\Catalogue\JoinTableProductDetailRecycling 43
App\Entity\Catalogue\ProductDetail 34
App\Entity\Catalogue\RecyclingCategory 18
App\Entity\Catalogue\Recycling 10
App\Entity\Language 3