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

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
18.78 ms
(77.63%)
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.21 ms
(13.27%)
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 1920
Parameters:
[]
1.10 ms
(4.53%)
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.55 ms
(2.28%)
1
SELECT count(DISTINCT p0_.id) AS sclr_0 FROM prim_exhibition_product p0_ WHERE 1 = 1
Parameters:
[]
0.55 ms
(2.28%)
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:
[
  "1922"
  "1923"
  "1924"
  "1925"
  "1926"
  "1927"
  "1928"
  "1929"
  "1930"
  "1931"
  "1932"
  "1933"
  "1934"
  "1935"
  "1936"
]

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