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

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
21.23 ms
(78.30%)
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.96 ms
(14.60%)
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 105
Parameters:
[]
0.72 ms
(2.67%)
1
SELECT count(DISTINCT p0_.id) AS sclr_0 FROM prim_exhibition_product p0_ WHERE 1 = 1
Parameters:
[]
0.70 ms
(2.59%)
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.50 ms
(1.85%)
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:
[
  "107"
  "108"
  "109"
  "110"
  "111"
  "112"
  "113"
  "114"
  "115"
  "116"
  "117"
  "118"
  "119"
  "120"
  "121"
]

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