GET https://www.primigenagroup.com/admin/brand/1/servizio-garanzie/28/scheda

Query Metrics

4 Database Queries
4 Different statements
2.31 ms Query time
0 Invalid entities
11 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"
]
2 0.57 ms
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.title AS title_3, t0.duration_month AS duration_month_4, t0.receipt_path AS receipt_path_5, t0.extension_path AS extension_path_6, t0.purchase_date AS purchase_date_7, t0.is_extension_active AS is_extension_active_8, t0.ean_code_id AS ean_code_id_9, t0.iqb_code_id AS iqb_code_id_10, t0.iqp_code_id AS iqp_code_id_11, t0.user_id AS user_id_12 FROM prim_warranty t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
  "28"
]
3 0.60 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 WHERE t0.id = ?
Parameters:
[
  "1541"
]
4 0.49 ms
SELECT t0.id AS id_1, t0.is_active AS is_active_2, t0.email AS email_3, t0.password AS password_4, t0.role AS role_5, t0.name AS name_6, t0.surname AS surname_7, t0.phone AS phone_8, t0.address AS address_9, t0.city AS city_10, t0.zip AS zip_11, t0.country AS country_12, t0.activation_code AS activation_code_13, t0.one_time_code AS one_time_code_14, t0.directory_path AS directory_path_15, t0.primigena_points AS primigena_points_16, t0.subscription_datetime AS subscription_datetime_17, t0.expiration_one_time_code AS expiration_one_time_code_18, t19.id AS id_20, t19.update_date_time AS update_date_time_21, t19.user_id AS user_id_22 FROM prim_user t0 LEFT JOIN prim_cart t19 ON t19.user_id = t0.id WHERE t0.id = ?
Parameters:
[
  "5"
]

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\Brand 1
App\Entity\Application\Application 1
App\Entity\Warranty\Warranty 1
App\Entity\EanCode 1
App\Entity\User 1
App\Entity\Catalogue\Product 1
App\Entity\IqbCode 1
App\Entity\Catalogue\Category 1
App\Entity\Catalogue\Subcategory1 1
App\Entity\Catalogue\Subcategory2 1
App\Entity\Catalogue\Subcategory3 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\Warranty\Warranty No errors.
App\Entity\IqpCode No errors.
App\Entity\User 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\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\Cart No errors.
App\Entity\JoinTableUserPointOfSale No errors.
App\Entity\Notification No errors.
App\Entity\Order No errors.
App\Entity\Campaign\JoinTableUserCampaign No errors.
App\Entity\Campaign\Ticket No errors.
App\Entity\Maintenance\Notification No errors.
App\Entity\Shopping\Storage No errors.