GET https://www.primigenagroup.com/admin/brand/lista

Query Metrics

33 Database Queries
4 Different statements
6.88 ms Query time
0 Invalid entities
55 Managed entities

Grouped Statements

Show all queries

Time Count Info
5.41 ms
(78.65%)
30
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"
]
0.57 ms
(8.25%)
1
SELECT count(DISTINCT p0_.id) AS sclr_0 FROM prim_brand p0_ WHERE 1 = 1
Parameters:
[]
0.48 ms
(7.04%)
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_ WHERE 1 = 1 AND p0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY p0_.name ASC
Parameters:
[
  "58"
  "83"
  "25"
  "32"
  "59"
  "99"
  "94"
  "39"
  "75"
  "98"
  "124"
  "74"
  "78"
  "22"
  "20"
  "70"
  "93"
  "115"
  "90"
  "64"
  "47"
  "122"
  "103"
  "51"
  "53"
  "119"
  "91"
  "6"
  "16"
  "24"
]
0.42 ms
(6.06%)
1
SELECT DISTINCT p0_.id AS id_0, p0_.name AS name_1 FROM prim_brand p0_ WHERE 1 = 1 ORDER BY 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\Brand 30
App\Entity\Application\Application 25