GET https://www.primigenagroup.com/admin/brand/113/codici-ean

Query Metrics

4 Database Queries
4 Different statements
6.18 ms Query time
0 Invalid entities
5780 Managed entities

Queries

Group similar statements

# Time Info
1 0.64 ms
SELECT t0.id AS id_1, t0.is_active AS is_active_2, t0.name AS name_3, t0.vat AS vat_4, t0.fiscal_code AS fiscal_code_5, t0.address AS address_6, t0.zip AS zip_7, t0.city AS city_8, t0.country AS country_9, t0.email AS email_10, t0.phone AS phone_11, t0.website AS website_12, t0.logo_path AS logo_path_13, t0.directory_name AS directory_name_14, t0.warranty_email AS warranty_email_15, t16.id AS id_17, t16.logo_path AS logo_path_18, t16.splash_path AS splash_path_19, t16.color_splash_back AS color_splash_back_20, t16.color_back AS color_back_21, t16.brand_id AS brand_id_22 FROM prim_brand t0 LEFT JOIN prim_application t16 ON t16.brand_id = t0.id WHERE t0.id = ? LIMIT 1
Parameters:
[
  "113"
]
2 4.57 ms
SELECT t0.id AS id_1, t0.value AS value_2, t0.is_active AS is_active_3, t4.id AS id_5, t4.is_active AS is_active_6, t4.is_expirable AS is_expirable_7, t4.directory_path AS directory_path_8, t4.warranty_path AS warranty_path_9, t4.iqb_code_id AS iqb_code_id_10, t4.ean_code_id AS ean_code_id_11, t4.watermark_id AS watermark_id_12, t4.category_id AS category_id_13, t4.producer_id AS producer_id_14, t4.trademark_id AS trademark_id_15, t4.subcategory_1_id AS subcategory_1_id_16, t4.subcategory_2_id AS subcategory_2_id_17, t4.subcategory_3_id AS subcategory_3_id_18, t4.subcategory_4_id AS subcategory_4_id_19, t0.brand_id AS brand_id_20 FROM prim_ean_code t0 LEFT JOIN prim_catalogue_product t4 ON t4.ean_code_id = t0.id
Parameters:
[]
3 0.56 ms
SELECT count(DISTINCT p0_.id) AS sclr_0 FROM prim_ean_code p0_ WHERE p0_.brand_id = ?
Parameters:
[
  "113"
]
4 0.40 ms
SELECT DISTINCT p0_.id AS id_0, p0_.value AS value_1 FROM prim_ean_code p0_ WHERE p0_.brand_id = ? ORDER BY p0_.value ASC LIMIT 15
Parameters:
[
  "113"
]

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\EanCode 1633
App\Entity\Catalogue\Product 1368
App\Entity\IqbCode 1364
App\Entity\Catalogue\Subcategory3 543
App\Entity\Producer 342
App\Entity\Catalogue\Subcategory2 295
App\Entity\Brand 98
App\Entity\Catalogue\Subcategory1 90
App\Entity\Catalogue\Trademark 30
App\Entity\Catalogue\Category 16
App\Entity\Catalogue\Subcategory4 1