GET https://www.primigenagroup.com/admin/brand/1/servizio-pannello/48/tabella/product-pieces

Query Metrics

7 Database Queries
7 Different statements
3.83 ms Query time
0 Invalid entities
11 Managed entities

Queries

Group similar statements

# Time Info
1 0.55 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.image_path AS image_path_4, t0.start_date AS start_date_5, t0.end_date AS end_date_6, t0.is_table_active AS is_table_active_7, t0.is_map_active AS is_map_active_8, t0.is_url_active AS is_url_active_9, t0.watermark_id AS watermark_id_10, t0.brand_id AS brand_id_11, t0.category_id AS category_id_12, t0.subcategory1_id AS subcategory1_id_13, t0.subcategory2_id AS subcategory2_id_14, t0.subcategory3_id AS subcategory3_id_15, t0.subcategory4_id AS subcategory4_id_16, t0.product_id AS product_id_17 FROM prim_panel t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
  "48"
]
2 0.41 ms
SELECT t0.id AS id_1, t0.is_active AS is_active_2, t0.is_expirable AS is_expirable_3, t0.directory_path AS directory_path_4, t0.warranty_path AS warranty_path_5, t0.iqb_code_id AS iqb_code_id_6, t0.ean_code_id AS ean_code_id_7, t0.watermark_id AS watermark_id_8, t0.category_id AS category_id_9, t0.producer_id AS producer_id_10, t0.trademark_id AS trademark_id_11, t0.subcategory_1_id AS subcategory_1_id_12, t0.subcategory_2_id AS subcategory_2_id_13, t0.subcategory_3_id AS subcategory_3_id_14, t0.subcategory_4_id AS subcategory_4_id_15 FROM prim_catalogue_product t0 WHERE t0.id = ?
Parameters:
[
  "1561"
]
3 0.43 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:
[
  "1561"
]
4 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"
]
5 0.93 ms
SELECT count(DISTINCT p0_.id) AS sclr_0 FROM prim_read p0_ LEFT JOIN prim_iqp_code p1_ ON p0_.iqp_code_id = p1_.id LEFT JOIN prim_iqb_code p2_ ON p1_.iqb_code_id = p2_.id LEFT JOIN prim_catalogue_product p3_ ON p2_.id = p3_.iqb_code_id WHERE p0_.datetime >= ? AND p3_.id = ? AND p0_.datetime <= ?
Parameters:
[
  "2022-04-10"
  "1561"
  "2022-04-30"
]
6 0.54 ms
SELECT DISTINCT p0_.id AS id_0, p0_.datetime AS datetime_1 FROM prim_read p0_ LEFT JOIN prim_iqp_code p1_ ON p0_.iqp_code_id = p1_.id LEFT JOIN prim_iqb_code p2_ ON p1_.iqb_code_id = p2_.id LEFT JOIN prim_catalogue_product p3_ ON p2_.id = p3_.iqb_code_id WHERE p0_.datetime >= ? AND p3_.id = ? AND p0_.datetime <= ? ORDER BY p0_.datetime DESC LIMIT 100
Parameters:
[
  "2022-04-10"
  "1561"
  "2022-04-30"
]
7 0.68 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 = ?
Parameters:
[
  "1"
]

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\Panel\Panel 1
App\Entity\Watermark 1
App\Entity\Brand 1
App\Entity\Catalogue\Category 1
App\Entity\Catalogue\Subcategory1 1
App\Entity\Catalogue\Product 1
App\Entity\IqbCode 1
App\Entity\EanCode 1
App\Entity\Catalogue\ProductDetail 1
App\Entity\Language 1
App\Entity\Application\Application 1

Entities Mapping

Class Mapping errors
App\Entity\Panel\Panel No errors.
App\Entity\Watermark No errors.
App\Entity\Brand 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\Catalogue\Product No errors.
App\Entity\Read No errors.
App\Entity\IqbCode No errors.
App\Entity\EanCode No errors.
App\Entity\Producer No errors.
App\Entity\Catalogue\Trademark 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\JoinTableBrandLanguage 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\Maintenance\NotificationType No errors.
App\Entity\IqpCode No errors.
App\Entity\Application\Application No errors.
App\Entity\JoinTableUserBrand No errors.
App\Entity\IqcCode No errors.
App\Entity\JoinTableBrandService No errors.
App\Entity\Advertising\Advertising No errors.
App\Entity\Campaign\Campaign No errors.
App\Entity\Graduation\Course No errors.
App\Entity\Maintenance\MaintenanceCategory No errors.
App\Entity\Redirect\Redirect No errors.
App\Entity\CountdownRedirect\CountdownRedirect No errors.