Redirect 302 redirect from GET @admin_service_select (92bff0)

GET https://www.primigenagroup.com/admin/punto-vendita/1/scheda

Query Metrics

21 Database Queries
8 Different statements
7.75 ms Query time
0 Invalid entities
69 Managed entities

Queries

Group similar statements

# Time Info
1 0.46 ms
SELECT t0.id AS id_1, t0.is_active AS is_active_2, t0.slug AS slug_3, t0.code AS code_4, t0.name AS name_5, t0.vat AS vat_6, t0.fiscal_code AS fiscal_code_7, t0.address AS address_8, t0.city AS city_9, t0.zip AS zip_10, t0.country AS country_11, t0.email AS email_12, t0.phone AS phone_13, t0.directory_path AS directory_path_14, t0.logo_path AS logo_path_15, t0.latitude AS latitude_16, t0.longitude AS longitude_17 FROM prim_point_of_sale t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
  "1"
]
2 0.30 ms
SELECT t0.id AS id_1, t0.is_active AS is_active_2, t0.role AS role_3, t0.user_id AS user_id_4, t0.point_of_sale_id AS point_of_sale_id_5 FROM prim_join_table_user_pos t0 WHERE t0.point_of_sale_id = ?
Parameters:
[
  "1"
]
3 0.93 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.company AS company_4, t0.address AS address_5, t0.lat AS lat_6, t0.lng AS lng_7, t0.image_path AS image_path_8, t0.directory_path AS directory_path_9, t0.alert_email AS alert_email_10, t0.notes AS notes_11, t0.iqp_code_id AS iqp_code_id_12, t0.maintenance_category_id AS maintenance_category_id_13, t0.point_of_sale_id AS point_of_sale_id_14 FROM prim_maintenance t0 WHERE t0.point_of_sale_id = ?
Parameters:
[
  "1"
]
4 0.58 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:
[
  "56"
]
5 0.83 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:
[
  "97"
]
6 0.49 ms
SELECT t0.id AS id_1, t0.is_active AS is_active_2, t0.is_offer AS is_offer_3, t0.qty AS qty_4, t0.price AS price_5, t0.price_offer AS price_offer_6, t0.catalogue_product_id AS catalogue_product_id_7, t0.point_of_sale_id AS point_of_sale_id_8 FROM prim_join_table_pos_catalogue_product t0 WHERE t0.point_of_sale_id = ?
Parameters:
[
  "1"
]
7 0.50 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:
[
  "211"
]
8 0.50 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:
[
  "211"
]
9 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"
]
10 0.34 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:
[
  "1660"
]
11 0.36 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:
[
  "1660"
]
12 0.25 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:
[
  "1681"
]
13 0.27 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:
[
  "1681"
]
14 0.20 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:
[
  "1679"
]
15 0.22 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:
[
  "1679"
]
16 0.20 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:
[
  "1625"
]
17 0.21 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:
[
  "1625"
]
18 0.19 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:
[
  "1678"
]
19 0.24 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:
[
  "1678"
]
20 0.20 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:
[
  "1565"
]
21 0.19 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:
[
  "1565"
]

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\JoinTablePointOfSaleCatalogueProduct 7
App\Entity\Catalogue\Product 7
App\Entity\IqbCode 7
App\Entity\EanCode 7
App\Entity\Producer 7
App\Entity\Catalogue\ProductDetail 7
App\Entity\Catalogue\Subcategory1 6
App\Entity\Catalogue\Subcategory2 5
App\Entity\Catalogue\Category 4
App\Entity\Catalogue\Subcategory3 4
App\Entity\JoinTableUserPointOfSale 2
App\Entity\User 2
App\Entity\Catalogue\Trademark 2
App\Entity\PointOfSale 1
App\Entity\Language 1

Entities Mapping

Class Mapping errors
App\Entity\PointOfSale No errors.
App\Entity\JoinTableUserPointOfSale No errors.
App\Entity\JoinTablePointOfSaleCatalogueProduct No errors.
App\Entity\Campaign\Ticket No errors.
App\Entity\Maintenance\Maintenance No errors.
App\Entity\User No errors.
App\Entity\IqpCode No errors.
App\Entity\Maintenance\MaintenanceCategory No errors.
App\Entity\Cart No errors.
App\Entity\JoinTableUserBrand No errors.
App\Entity\Notification No errors.
App\Entity\Order No errors.
App\Entity\Read No errors.
App\Entity\Campaign\JoinTableUserCampaign No errors.
App\Entity\Maintenance\Notification No errors.
App\Entity\Warranty\Warranty No errors.
App\Entity\Shopping\Storage No errors.
App\Entity\Catalogue\Product No errors.
App\Entity\IqbCode No errors.
App\Entity\EanCode No errors.
App\Entity\Watermark No errors.
App\Entity\Catalogue\Category No errors.
App\Entity\Producer No errors.
App\Entity\Catalogue\Trademark 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\ProductDetail No errors.
App\Entity\Campaign\JoinTableCampaignProduct No errors.
App\Entity\Panel\Panel 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.