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

Query Metrics

8 Database Queries
8 Different statements
8.59 ms Query time
0 Invalid entities
5790 Managed entities

Queries

Group similar statements

# Time Info
1 0.67 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:
[
  "57"
]
2 5.11 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.66 ms
SELECT count(DISTINCT p0_.id) AS sclr_0 FROM prim_ean_code p0_ WHERE p0_.brand_id = ?
Parameters:
[
  "57"
]
4 0.36 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:
[
  "57"
]
5 0.25 ms
SELECT p0_.id AS id_0, p0_.value AS value_1, p0_.is_active AS is_active_2, p0_.brand_id AS brand_id_3 FROM prim_ean_code p0_ WHERE p0_.brand_id = ? AND p0_.id IN (?) ORDER BY p0_.value ASC
Parameters:
[
  "57"
  "1693"
]
6 0.76 ms
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.name AS name_3, t0.website AS website_4, t0.image_path AS image_path_5, t0.description AS description_6, t0.notes AS notes_7, t0.product_id AS product_id_8, t0.language_id AS language_id_9 FROM prim_catalogue_product_detail t0 WHERE t0.product_id = ?
Parameters:
[
  "1586"
]
7 0.29 ms
SELECT t0.id AS id_1, t0.value AS value_2, t0.slug AS slug_3 FROM prim_language t0 WHERE t0.id = ?
Parameters:
[
  "1"
]
8 0.50 ms
SELECT t0.id AS id_1, t0.datetime AS datetime_2, t0.device AS device_3, t0.device_id AS device_id_4, t0.service AS service_5, t0.os AS os_6, t0.geocoords AS geocoords_7, t0.application AS application_8, t0.version AS version_9, t0.area_1 AS area_1_10, t0.area_2 AS area_2_11, t0.area_3 AS area_3_12, t0.area_4 AS area_4_13, t0.country AS country_14, t0.zip AS zip_15, t0.lang AS lang_16, t0.user_id AS user_id_17, t0.watermark_id AS watermark_id_18, t0.ean_code_id AS ean_code_id_19, t0.iqp_code_id AS iqp_code_id_20, t0.iqb_code_id AS iqb_code_id_21, t0.iqc_code_id AS iqc_code_id_22, t0.iqe_code_id AS iqe_code_id_23, t0.iqs_code_id AS iqs_code_id_24, t0.format_type_id AS format_type_id_25, t0.code_type_id AS code_type_id_26, t0.read_type_id AS read_type_id_27 FROM prim_read t0 WHERE t0.ean_code_id = ?
Parameters:
[
  "1693"
]

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 97
App\Entity\Catalogue\Subcategory1 90
App\Entity\Catalogue\Trademark 30
App\Entity\Catalogue\Category 16
App\Entity\Read 3
App\Entity\User 2
App\Entity\Application\Application 1
App\Entity\Catalogue\Subcategory4 1
App\Entity\Catalogue\ProductDetail 1
App\Entity\Language 1
App\Entity\FormatType 1
App\Entity\CodeType 1
App\Entity\ReadType 1

Entities Mapping

Class Mapping errors
App\Entity\Brand No errors.
App\Entity\Application\Application No errors.
App\Entity\JoinTableUserBrand No errors.
App\Entity\Watermark No errors.
App\Entity\IqbCode No errors.
App\Entity\EanCode No errors.
App\Entity\IqcCode No errors.
App\Entity\JoinTableBrandService No errors.
App\Entity\JoinTableBrandLanguage No errors.
App\Entity\Advertising\Advertising No errors.
App\Entity\Campaign\Campaign No errors.
App\Entity\Catalogue\Trademark No errors.
App\Entity\Graduation\Course No errors.
App\Entity\Panel\Panel No errors.
App\Entity\Maintenance\MaintenanceCategory No errors.
App\Entity\Redirect\Redirect No errors.
App\Entity\CountdownRedirect\CountdownRedirect No errors.
App\Entity\Producer No errors.
App\Entity\Maintenance\NotificationType No errors.
App\Entity\Catalogue\Product No errors.
App\Entity\Catalogue\Category No errors.
App\Entity\Catalogue\Subcategory1 No errors.
App\Entity\Catalogue\Subcategory2 No errors.
App\Entity\Catalogue\Subcategory3 No errors.
App\Entity\Catalogue\Subcategory4 No errors.
App\Entity\Read No errors.
App\Entity\Warranty\Warranty No errors.
App\Entity\Shopping\Stock No errors.
App\Entity\Catalogue\ProductDetail No errors.
App\Entity\Campaign\JoinTableCampaignProduct No errors.
App\Entity\JoinTablePointOfSaleCatalogueProduct No errors.
App\Entity\Warehouse\ProductionOrder No errors.
App\Entity\Language No errors.
App\Entity\Catalogue\Attachment No errors.
App\Entity\Catalogue\JoinTableProductDetailRecycling No errors.
App\Entity\Catalogue\Certification No errors.
App\Entity\CategoryDetail No errors.
App\Entity\Catalogue\CategoryDetail No errors.
App\Entity\Catalogue\Subcategory1Detail No errors.
App\Entity\Catalogue\Subcategory2Detail No errors.
App\Entity\Catalogue\Subcategory3Detail No errors.
App\Entity\Catalogue\Subcategory4Detail No errors.
App\Entity\Catalogue\RecyclingCategory No errors.
App\Entity\Catalogue\Recycling No errors.
App\Entity\Disability\CategoryDetail No errors.
App\Entity\Disability\Subcategory1Detail No errors.
App\Entity\Disability\Subcategory2Detail No errors.
App\Entity\Disability\Subcategory3Detail No errors.
App\Entity\Disability\ArticleDetail No errors.
App\Entity\Maintenance\MaintenanceCategoryDetails No errors.
App\Entity\User No errors.
App\Entity\IqpCode No errors.
App\Entity\IqeCode No errors.
App\Entity\IqsCode No errors.
App\Entity\FormatType No errors.
App\Entity\CodeType No errors.
App\Entity\ReadType No errors.