GET https://primigenagroup.com/admin/brand/1/servizio-pannello/48/tabella/category/esporta-excel

Response
200 OK
IP
216.73.216.156
Profiled on
Token
49f05e

Query Metrics

2 Database Queries
2 Different statements
4.59 ms Query time
0 Invalid entities
6 Managed entities

Queries

Group similar statements

#▲ Time Info
1 0.50 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
2 4.09 ms 
SELECT p0_.id AS id_0, p0_.datetime AS datetime_1, p0_.device AS device_2, p0_.device_id AS device_id_3, p0_.service AS service_4, p0_.os AS os_5, p0_.geocoords AS geocoords_6, p0_.application AS application_7, p0_.version AS version_8, p0_.area_1 AS area_1_9, p0_.area_2 AS area_2_10, p0_.area_3 AS area_3_11, p0_.area_4 AS area_4_12, p0_.country AS country_13, p0_.zip AS zip_14, p0_.lang AS lang_15, p0_.user_id AS user_id_16, p0_.watermark_id AS watermark_id_17, p0_.ean_code_id AS ean_code_id_18, p0_.iqp_code_id AS iqp_code_id_19, p0_.iqb_code_id AS iqb_code_id_20, p0_.iqc_code_id AS iqc_code_id_21, p0_.iqe_code_id AS iqe_code_id_22, p0_.iqs_code_id AS iqs_code_id_23, p0_.format_type_id AS format_type_id_24, p0_.code_type_id AS code_type_id_25, p0_.read_type_id AS read_type_id_26 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 <= ? ORDER BY p0_.datetime DESC
Parameters: 
[
  "2022-04-10"
  "31"
  "31"
  "31"
  "2022-04-30"
]
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\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

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\IqpCode No errors.
App\Entity\User No errors.
App\Entity\IqcCode 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.