GET https://www.primigenagroup.com/admin/brand/1/servizio-pannello/48/anteprima

Response
200 OK
IP
216.73.216.168
Profiled on
Token
9fcfa8

Query Metrics

22 Database Queries
16 Different statements
63.15 ms Query time
0 Invalid entities
19 Managed entities

Queries

Group similar statements

#▲ Time Info
1 0.66 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: 
[
  "1"
]
View formatted query    View runnable query    Explain query
2 0.60 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"
]
View formatted query    View runnable query    Explain query
3 1.60 ms 
SELECT COUNT(p0_.id) AS sclr_0 FROM prim_read p0_ INNER JOIN prim_watermark p1_ ON p0_.watermark_id = p1_.id WHERE p0_.datetime >= ? AND p1_.id = ? AND p0_.datetime <= ?
Parameters: 
[
  "2022-04-10"
  "11"
  "2022-04-30"
]
View formatted query    View runnable query    Explain query
4 1.20 ms 
SELECT COUNT(p0_.id) AS sclr_0 FROM prim_read p0_ INNER JOIN prim_watermark p1_ ON p0_.watermark_id = p1_.id WHERE p0_.datetime >= ? AND p1_.id = ? AND p0_.datetime <= ?
Parameters: 
[
  "2022-04-10"
  "11"
  "2022-04-30"
]
View formatted query    View runnable query    Explain query
5 6.03 ms 
SELECT COUNT(p0_.id) AS sclr_0 FROM prim_read p0_ LEFT JOIN prim_iqb_code p1_ ON p0_.iqb_code_id = p1_.id LEFT JOIN prim_catalogue_product p2_ ON p1_.id = p2_.iqb_code_id LEFT JOIN prim_catalogue_category p3_ ON p2_.category_id = p3_.id LEFT JOIN prim_ean_code p4_ ON p0_.ean_code_id = p4_.id LEFT JOIN prim_catalogue_product p5_ ON p4_.id = p5_.ean_code_id LEFT JOIN prim_catalogue_category p6_ ON p5_.category_id = p6_.id LEFT JOIN prim_iqp_code p7_ ON p0_.iqp_code_id = p7_.id LEFT JOIN prim_iqb_code p8_ ON p7_.iqb_code_id = p8_.id LEFT JOIN prim_catalogue_product p9_ ON p8_.id = p9_.iqb_code_id LEFT JOIN prim_catalogue_category p10_ ON p9_.category_id = p10_.id WHERE p0_.datetime >= ? AND (p3_.id = ? OR p6_.id = ? OR p10_.id = ?) AND p0_.datetime <= ?
Parameters: 
[
  "2022-04-10"
  "31"
  "31"
  "31"
  "2022-04-30"
]
View formatted query    View runnable query    Explain query
6 5.21 ms 
SELECT COUNT(p0_.id) AS sclr_0 FROM prim_read p0_ LEFT JOIN prim_iqb_code p1_ ON p0_.iqb_code_id = p1_.id LEFT JOIN prim_catalogue_product p2_ ON p1_.id = p2_.iqb_code_id LEFT JOIN prim_catalogue_category p3_ ON p2_.category_id = p3_.id LEFT JOIN prim_ean_code p4_ ON p0_.ean_code_id = p4_.id LEFT JOIN prim_catalogue_product p5_ ON p4_.id = p5_.ean_code_id LEFT JOIN prim_catalogue_category p6_ ON p5_.category_id = p6_.id LEFT JOIN prim_iqp_code p7_ ON p0_.iqp_code_id = p7_.id LEFT JOIN prim_iqb_code p8_ ON p7_.iqb_code_id = p8_.id LEFT JOIN prim_catalogue_product p9_ ON p8_.id = p9_.iqb_code_id LEFT JOIN prim_catalogue_category p10_ ON p9_.category_id = p10_.id WHERE p0_.datetime >= ? AND (p3_.id = ? OR p6_.id = ? OR p10_.id = ?) AND p0_.datetime <= ?
Parameters: 
[
  "2022-04-10"
  "31"
  "31"
  "31"
  "2022-04-30"
]
View formatted query    View runnable query    Explain query
7 4.97 ms 
SELECT COUNT(p0_.id) AS sclr_0 FROM prim_read p0_ LEFT JOIN prim_iqb_code p1_ ON p0_.iqb_code_id = p1_.id LEFT JOIN prim_catalogue_product p2_ ON p1_.id = p2_.iqb_code_id LEFT JOIN prim_catalogue_subcategory_1 p3_ ON p2_.subcategory_1_id = p3_.id LEFT JOIN prim_ean_code p4_ ON p0_.ean_code_id = p4_.id LEFT JOIN prim_catalogue_product p5_ ON p4_.id = p5_.ean_code_id LEFT JOIN prim_catalogue_subcategory_1 p6_ ON p5_.subcategory_1_id = p6_.id LEFT JOIN prim_iqp_code p7_ ON p0_.iqp_code_id = p7_.id LEFT JOIN prim_iqb_code p8_ ON p7_.iqb_code_id = p8_.id LEFT JOIN prim_catalogue_product p9_ ON p8_.id = p9_.iqb_code_id LEFT JOIN prim_catalogue_subcategory_1 p10_ ON p9_.subcategory_1_id = p10_.id WHERE p0_.datetime >= ? AND (p3_.id = ? OR p6_.id = ? OR p10_.id = ?) AND p0_.datetime <= ?
Parameters: 
[
  "2022-04-10"
  "124"
  "124"
  "124"
  "2022-04-30"
]
View formatted query    View runnable query    Explain query
8 5.82 ms 
SELECT COUNT(p0_.id) AS sclr_0 FROM prim_read p0_ LEFT JOIN prim_iqb_code p1_ ON p0_.iqb_code_id = p1_.id LEFT JOIN prim_catalogue_product p2_ ON p1_.id = p2_.iqb_code_id LEFT JOIN prim_catalogue_subcategory_1 p3_ ON p2_.subcategory_1_id = p3_.id LEFT JOIN prim_ean_code p4_ ON p0_.ean_code_id = p4_.id LEFT JOIN prim_catalogue_product p5_ ON p4_.id = p5_.ean_code_id LEFT JOIN prim_catalogue_subcategory_1 p6_ ON p5_.subcategory_1_id = p6_.id LEFT JOIN prim_iqp_code p7_ ON p0_.iqp_code_id = p7_.id LEFT JOIN prim_iqb_code p8_ ON p7_.iqb_code_id = p8_.id LEFT JOIN prim_catalogue_product p9_ ON p8_.id = p9_.iqb_code_id LEFT JOIN prim_catalogue_subcategory_1 p10_ ON p9_.subcategory_1_id = p10_.id WHERE p0_.datetime >= ? AND (p3_.id = ? OR p6_.id = ? OR p10_.id = ?) AND p0_.datetime <= ?
Parameters: 
[
  "2022-04-10"
  "124"
  "124"
  "124"
  "2022-04-30"
]
View formatted query    View runnable query    Explain query
9 4.98 ms 
SELECT COUNT(p0_.id) AS sclr_0 FROM prim_read p0_ LEFT JOIN prim_iqb_code p1_ ON p0_.iqb_code_id = p1_.id LEFT JOIN prim_catalogue_product p2_ ON p1_.id = p2_.iqb_code_id LEFT JOIN prim_ean_code p3_ ON p0_.ean_code_id = p3_.id LEFT JOIN prim_catalogue_product p4_ ON p3_.id = p4_.ean_code_id LEFT JOIN prim_iqp_code p5_ ON p0_.iqp_code_id = p5_.id LEFT JOIN prim_iqb_code p6_ ON p5_.iqb_code_id = p6_.id LEFT JOIN prim_catalogue_product p7_ ON p6_.id = p7_.iqb_code_id WHERE p0_.datetime >= ? AND (p2_.id = ? OR p4_.id = ? OR p7_.id = ?) AND p0_.datetime <= ?
Parameters: 
[
  "2022-04-10"
  "1561"
  "1561"
  "1561"
  "2022-04-30"
]
View formatted query    View runnable query    Explain query
10 7.54 ms 
SELECT COUNT(p0_.id) AS sclr_0 FROM prim_read p0_ LEFT JOIN prim_iqb_code p1_ ON p0_.iqb_code_id = p1_.id LEFT JOIN prim_catalogue_product p2_ ON p1_.id = p2_.iqb_code_id LEFT JOIN prim_ean_code p3_ ON p0_.ean_code_id = p3_.id LEFT JOIN prim_catalogue_product p4_ ON p3_.id = p4_.ean_code_id LEFT JOIN prim_iqp_code p5_ ON p0_.iqp_code_id = p5_.id LEFT JOIN prim_iqb_code p6_ ON p5_.iqb_code_id = p6_.id LEFT JOIN prim_catalogue_product p7_ ON p6_.id = p7_.iqb_code_id WHERE p0_.datetime >= ? AND (p2_.id = ? OR p4_.id = ? OR p7_.id = ?) AND p0_.datetime <= ?
Parameters: 
[
  "2022-04-10"
  "1561"
  "1561"
  "1561"
  "2022-04-30"
]
View formatted query    View runnable query    Explain query
11 1.11 ms 
SELECT COUNT(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"
]
View formatted query    View runnable query    Explain query
12 0.69 ms 
SELECT COUNT(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"
]
View formatted query    View runnable query    Explain query
13 9.69 ms 
SELECT COUNT(p0_.id) AS sclr_0 FROM prim_read p0_ LEFT JOIN prim_ean_code p1_ ON p0_.ean_code_id = p1_.id LEFT JOIN prim_catalogue_product p2_ ON p1_.id = p2_.ean_code_id LEFT JOIN prim_iqp_code p3_ ON p0_.iqp_code_id = p3_.id LEFT JOIN prim_iqb_code p4_ ON p3_.iqb_code_id = p4_.id LEFT JOIN prim_catalogue_product p5_ ON p4_.id = p5_.iqb_code_id LEFT JOIN prim_read_type p6_ ON p0_.read_type_id = p6_.id WHERE p0_.datetime >= ? AND (p2_.id = ? OR p5_.id = ?) AND p6_.slug = ? AND p0_.datetime <= ?
Parameters: 
[
  "2022-04-10"
  "1561"
  "1561"
  "benefit"
  "2022-04-30"
]
View formatted query    View runnable query    Explain query
14 10.18 ms 
SELECT COUNT(p0_.id) AS sclr_0 FROM prim_read p0_ LEFT JOIN prim_ean_code p1_ ON p0_.ean_code_id = p1_.id LEFT JOIN prim_catalogue_product p2_ ON p1_.id = p2_.ean_code_id LEFT JOIN prim_iqp_code p3_ ON p0_.iqp_code_id = p3_.id LEFT JOIN prim_iqb_code p4_ ON p3_.iqb_code_id = p4_.id LEFT JOIN prim_catalogue_product p5_ ON p4_.id = p5_.iqb_code_id LEFT JOIN prim_read_type p6_ ON p0_.read_type_id = p6_.id WHERE p0_.datetime >= ? AND (p2_.id = ? OR p5_.id = ?) AND p6_.slug = ? AND p0_.datetime <= ?
Parameters: 
[
  "2022-04-10"
  "1561"
  "1561"
  "benefit"
  "2022-04-30"
]
View formatted query    View runnable query    Explain query
15 0.84 ms 
SELECT t0.id AS id_1, t0.is_paired AS is_paired_2, t0.is_advertising AS is_advertising_3, t0.is_check_original AS is_check_original_4, t0.code AS code_5, t0.name AS name_6, t0.url AS url_7, t0.expiration_date AS expiration_date_8, t0.description AS description_9, t10.id AS id_11, t10.is_active AS is_active_12, t10.is_expirable AS is_expirable_13, t10.directory_path AS directory_path_14, t10.warranty_path AS warranty_path_15, t10.iqb_code_id AS iqb_code_id_16, t10.ean_code_id AS ean_code_id_17, t10.watermark_id AS watermark_id_18, t10.category_id AS category_id_19, t10.producer_id AS producer_id_20, t10.trademark_id AS trademark_id_21, t10.subcategory_1_id AS subcategory_1_id_22, t10.subcategory_2_id AS subcategory_2_id_23, t10.subcategory_3_id AS subcategory_3_id_24, t10.subcategory_4_id AS subcategory_4_id_25, t0.brand_id AS brand_id_26 FROM prim_watermark t0 LEFT JOIN prim_catalogue_product t10 ON t10.watermark_id = t0.id WHERE t0.id = ?
Parameters: 
[
  "11"
]
View formatted query    View runnable query    Explain query
16 0.23 ms 
SELECT t0.id AS id_1 FROM prim_catalogue_category t0 WHERE t0.id = ?
Parameters: 
[
  "31"
]
View formatted query    View runnable query    Explain query
17 0.34 ms 
SELECT t0.id AS id_1, t0.name AS name_2, t0.category_id AS category_id_3, t0.language_id AS language_id_4 FROM prim_catalogue_category_detail t0 WHERE t0.category_id = ?
Parameters: 
[
  "31"
]
View formatted query    View runnable query    Explain query
18 0.25 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"
]
View formatted query    View runnable query    Explain query
19 0.28 ms 
SELECT t0.id AS id_1, t0.category_id AS category_id_2 FROM prim_catalogue_subcategory_1 t0 WHERE t0.id = ?
Parameters: 
[
  "124"
]
View formatted query    View runnable query    Explain query
20 0.35 ms 
SELECT t0.id AS id_1, t0.name AS name_2, t0.subcategory_1_id AS subcategory_1_id_3, t0.language_id AS language_id_4 FROM prim_catalogue_subcategory_1_detail t0 WHERE t0.subcategory_1_id = ?
Parameters: 
[
  "124"
]
View formatted query    View runnable query    Explain query
21 0.24 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"
]
View formatted query    View runnable query    Explain query
22 0.35 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"
]
View formatted query    View runnable query    Explain query

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\Catalogue\CategoryDetail 3
App\Entity\Language 3
App\Entity\Catalogue\Subcategory1Detail 3
App\Entity\Brand 1
App\Entity\Application\Application 1
App\Entity\Panel\Panel 1
App\Entity\Watermark 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

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\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\IqpCode No errors.
App\Entity\ReadType No errors.
App\Entity\Catalogue\CategoryDetail No errors.
App\Entity\Language No errors.
App\Entity\CategoryDetail No errors.
App\Entity\Catalogue\Certification 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\ProductDetail 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\Campaign\JoinTableCampaignProduct No errors.
App\Entity\JoinTablePointOfSaleCatalogueProduct No errors.
App\Entity\Warehouse\ProductionOrder No errors.
App\Entity\Catalogue\Attachment No errors.
App\Entity\Catalogue\JoinTableProductDetailRecycling No errors.