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

Query Metrics

22 Database Queries
5 Different statements
7.42 ms Query time
0 Invalid entities
61 Managed entities

Grouped Statements

Show all queries

Time Count Info
5.42 ms
(73.01%)
18
SELECT t0.id AS id_1, t0.name AS name_2, t0.image_path AS image_path_3, t0.recycling_category_id AS recycling_category_id_4, t0.language_id AS language_id_5 FROM prim_catalogue_recycling t0 WHERE t0.recycling_category_id = ?
Parameters:
[
  "2"
]
0.60 ms
(8.05%)
1
SELECT count(DISTINCT p0_.id) AS sclr_0 FROM prim_catalogue_recycling_category p0_ LEFT JOIN prim_language p1_ ON p0_.language_id = p1_.id WHERE 1 = 1
Parameters:
[]
0.58 ms
(7.86%)
1
SELECT p0_.id AS id_0, p0_.value AS value_1, p0_.slug AS slug_2 FROM prim_language p0_
Parameters:
[]
0.42 ms
(5.68%)
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_ 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:
[
  "2"
  "3"
  "1"
  "4"
  "5"
  "6"
  "9"
  "7"
  "12"
  "10"
  "8"
  "11"
  "13"
  "15"
  "16"
  "14"
  "17"
  "18"
]
0.40 ms
(5.41%)
1
SELECT DISTINCT p0_.id AS id_0, p1_.id AS id_1, p0_.name AS name_2 FROM prim_catalogue_recycling_category 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:
[]

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\Recycling 40
App\Entity\Catalogue\RecyclingCategory 18
App\Entity\Language 3