GET https://primigenagroup.com/admin/prodotti-fiera/?page=87

Query Metrics

121 Database Queries
5 Different statements
24.88 ms Query time
0 Invalid entities
228 Managed entities

Grouped Statements

Show all queries

Time Count Info
19.37 ms
(77.89%)
117
SELECT t0.id AS id_1, t0.logo_path AS logo_path_2, t0.splash_path AS splash_path_3, t0.color_splash_back AS color_splash_back_4, t0.color_back AS color_back_5, t0.brand_id AS brand_id_6 FROM prim_application t0 WHERE t0.brand_id = ?
Parameters:
[
  "58"
]
3.14 ms
(12.62%)
1
SELECT DISTINCT p0_.id AS id_0, p0_.status AS status_1, p0_.iqp_value AS iqp_value_2 FROM prim_exhibition_product p0_ WHERE 1 = 1 ORDER BY p0_.status DESC, p0_.iqp_value ASC LIMIT 15 OFFSET 1290
Parameters:
[]
1.09 ms
(4.39%)
1
SELECT p0_.id AS id_0, p0_.is_active AS is_active_1, p0_.name AS name_2, p0_.vat AS vat_3, p0_.fiscal_code AS fiscal_code_4, p0_.address AS address_5, p0_.zip AS zip_6, p0_.city AS city_7, p0_.country AS country_8, p0_.email AS email_9, p0_.phone AS phone_10, p0_.website AS website_11, p0_.logo_path AS logo_path_12, p0_.directory_name AS directory_name_13, p0_.warranty_email AS warranty_email_14 FROM prim_brand p0_ ORDER BY p0_.name ASC
Parameters:
[]
0.76 ms
(3.07%)
1
SELECT count(DISTINCT p0_.id) AS sclr_0 FROM prim_exhibition_product p0_ WHERE 1 = 1
Parameters:
[]
0.51 ms
(2.04%)
1
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.status AS status_2, p0_.brand AS brand_3, p0_.ean_value AS ean_value_4, p0_.iqb_id AS iqb_id_5, p0_.iqp_value AS iqp_value_6, p0_.json AS json_7 FROM prim_exhibition_product p0_ WHERE 1 = 1 AND p0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY p0_.status DESC, p0_.iqp_value ASC
Parameters:
[
  "1292"
  "1293"
  "1294"
  "1295"
  "1296"
  "1297"
  "1298"
  "1299"
  "1300"
  "1301"
  "1302"
  "1303"
  "1304"
  "1305"
  "1306"
]

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\Brand 117
App\Entity\Application\Application 96
App\Entity\ExhibitionProduct 15