GET https://www.primigenagroup.com/admin/brand/1/servizio-reindirizzamento/30/modifica

Query Metrics

25 Database Queries
11 Different statements
7.72 ms Query time
0 Invalid entities
8 Managed entities

Queries

Group similar statements

# Time Info
1 0.56 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.33 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.url AS url_3, t0.iqb_code_id AS iqb_code_id_4, t0.brand_id AS brand_id_5 FROM prim_redirect t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
  "30"
]
3 2.00 ms
SELECT p0_.id AS id_0, p0_.is_active AS is_active_1, p0_.value AS value_2, p0_.rfid AS rfid_3, p0_.description AS description_4, p0_.json_msg AS json_msg_5, p0_.creation_date AS creation_date_6, p0_.brand_id AS brand_id_7, p0_.service_id AS service_id_8 FROM prim_iqb_code p0_ INNER JOIN prim_brand p1_ ON p0_.brand_id = p1_.id INNER JOIN prim_service p2_ ON p0_.service_id = p2_.id WHERE p0_.is_active = 0 AND p1_.id = ? AND p2_.slug = ?
Parameters:
[
  "1"
  "redirect"
]
4 0.33 ms
SELECT t0.id AS id_1, t0.directory_path AS directory_path_2, t0.is_active AS is_active_3, t0.is_reload_active AS is_reload_active_4, t0.title AS title_5, t0.text AS text_6, t0.start_time AS start_time_7, t0.end_time AS end_time_8, t0.backup_path AS backup_path_9, t0.iqb_code_id AS iqb_code_id_10, t0.brand_id AS brand_id_11 FROM prim_advertising t0 WHERE t0.iqb_code_id = ?
Parameters:
[
  "1756"
]
5 0.25 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.url_link AS url_link_4, t0.description AS description_5, t0.image_path AS image_path_6, t0.cover_path AS cover_path_7, t0.campaign_points_per_read AS campaign_points_per_read_8, t0.primigena_points_per_read AS primigena_points_per_read_9, t0.max_num_of_reads_per_user AS max_num_of_reads_per_user_10, t0.status AS status_11, t0.is_ean_campaign AS is_ean_campaign_12, t0.is_product_campaign AS is_product_campaign_13, t0.has_receipt AS has_receipt_14, t0.iqb_code_id AS iqb_code_id_15, t0.algorithm_id AS algorithm_id_16, t0.campaign_type_id AS campaign_type_id_17, t0.brand_id AS brand_id_18 FROM prim_campaign t0 WHERE t0.iqb_code_id = ?
Parameters:
[
  "1756"
]
6 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.iqb_code_id = ?
Parameters:
[
  "1756"
]
7 0.25 ms
SELECT t0.id AS id_1, t0.is_active AS is_active_2, t0.directory_path AS directory_path_3, t0.iqb_code_id AS iqb_code_id_4, t0.category_id AS category_id_5, t0.subcategory_1_id AS subcategory_1_id_6, t0.subcategory_2_id AS subcategory_2_id_7, t0.subcategory_3_id AS subcategory_3_id_8 FROM prim_disability_article t0 WHERE t0.iqb_code_id = ?
Parameters:
[
  "1756"
]
8 0.26 ms
SELECT t0.id AS id_1, t0.is_active AS is_active_2, t0.name AS name_3, t0.surname AS surname_4, t0.graduation_date AS graduation_date_5, t0.birth_date AS birth_date_6, t0.birth_city AS birth_city_7, t0.birth_province AS birth_province_8, t0.graduation_num AS graduation_num_9, t0.image_path AS image_path_10, t0.iqb_code_id AS iqb_code_id_11, t0.ordering_id AS ordering_id_12 FROM prim_graduation_graduate t0 WHERE t0.iqb_code_id = ?
Parameters:
[
  "1756"
]
9 0.18 ms
SELECT t0.id AS id_1, t0.priority AS priority_2, t0.image_path AS image_path_3, t0.directory_path AS directory_path_4, t0.iqb_code_id AS iqb_code_id_5, t0.brand_id AS brand_id_6 FROM prim_maintenance_category t0 WHERE t0.iqb_code_id = ?
Parameters:
[
  "1756"
]
10 0.16 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.url AS url_3, t0.iqb_code_id AS iqb_code_id_4, t0.brand_id AS brand_id_5 FROM prim_redirect t0 WHERE t0.iqb_code_id = ?
Parameters:
[
  "1756"
]
11 0.22 ms
SELECT t0.id AS id_1, t0.directory_path AS directory_path_2, t0.is_active AS is_active_3, t0.is_reload_active AS is_reload_active_4, t0.title AS title_5, t0.text AS text_6, t0.start_time AS start_time_7, t0.end_time AS end_time_8, t0.backup_path AS backup_path_9, t0.iqb_code_id AS iqb_code_id_10, t0.brand_id AS brand_id_11 FROM prim_advertising t0 WHERE t0.iqb_code_id = ?
Parameters:
[
  "1806"
]
12 0.22 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.url_link AS url_link_4, t0.description AS description_5, t0.image_path AS image_path_6, t0.cover_path AS cover_path_7, t0.campaign_points_per_read AS campaign_points_per_read_8, t0.primigena_points_per_read AS primigena_points_per_read_9, t0.max_num_of_reads_per_user AS max_num_of_reads_per_user_10, t0.status AS status_11, t0.is_ean_campaign AS is_ean_campaign_12, t0.is_product_campaign AS is_product_campaign_13, t0.has_receipt AS has_receipt_14, t0.iqb_code_id AS iqb_code_id_15, t0.algorithm_id AS algorithm_id_16, t0.campaign_type_id AS campaign_type_id_17, t0.brand_id AS brand_id_18 FROM prim_campaign t0 WHERE t0.iqb_code_id = ?
Parameters:
[
  "1806"
]
13 0.17 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.iqb_code_id = ?
Parameters:
[
  "1806"
]
14 0.14 ms
SELECT t0.id AS id_1, t0.is_active AS is_active_2, t0.directory_path AS directory_path_3, t0.iqb_code_id AS iqb_code_id_4, t0.category_id AS category_id_5, t0.subcategory_1_id AS subcategory_1_id_6, t0.subcategory_2_id AS subcategory_2_id_7, t0.subcategory_3_id AS subcategory_3_id_8 FROM prim_disability_article t0 WHERE t0.iqb_code_id = ?
Parameters:
[
  "1806"
]
15 0.16 ms
SELECT t0.id AS id_1, t0.is_active AS is_active_2, t0.name AS name_3, t0.surname AS surname_4, t0.graduation_date AS graduation_date_5, t0.birth_date AS birth_date_6, t0.birth_city AS birth_city_7, t0.birth_province AS birth_province_8, t0.graduation_num AS graduation_num_9, t0.image_path AS image_path_10, t0.iqb_code_id AS iqb_code_id_11, t0.ordering_id AS ordering_id_12 FROM prim_graduation_graduate t0 WHERE t0.iqb_code_id = ?
Parameters:
[
  "1806"
]
16 0.23 ms
SELECT t0.id AS id_1, t0.priority AS priority_2, t0.image_path AS image_path_3, t0.directory_path AS directory_path_4, t0.iqb_code_id AS iqb_code_id_5, t0.brand_id AS brand_id_6 FROM prim_maintenance_category t0 WHERE t0.iqb_code_id = ?
Parameters:
[
  "1806"
]
17 0.14 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.url AS url_3, t0.iqb_code_id AS iqb_code_id_4, t0.brand_id AS brand_id_5 FROM prim_redirect t0 WHERE t0.iqb_code_id = ?
Parameters:
[
  "1806"
]
18 0.17 ms
SELECT t0.id AS id_1, t0.directory_path AS directory_path_2, t0.is_active AS is_active_3, t0.is_reload_active AS is_reload_active_4, t0.title AS title_5, t0.text AS text_6, t0.start_time AS start_time_7, t0.end_time AS end_time_8, t0.backup_path AS backup_path_9, t0.iqb_code_id AS iqb_code_id_10, t0.brand_id AS brand_id_11 FROM prim_advertising t0 WHERE t0.iqb_code_id = ?
Parameters:
[
  "2041"
]
19 0.18 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.url_link AS url_link_4, t0.description AS description_5, t0.image_path AS image_path_6, t0.cover_path AS cover_path_7, t0.campaign_points_per_read AS campaign_points_per_read_8, t0.primigena_points_per_read AS primigena_points_per_read_9, t0.max_num_of_reads_per_user AS max_num_of_reads_per_user_10, t0.status AS status_11, t0.is_ean_campaign AS is_ean_campaign_12, t0.is_product_campaign AS is_product_campaign_13, t0.has_receipt AS has_receipt_14, t0.iqb_code_id AS iqb_code_id_15, t0.algorithm_id AS algorithm_id_16, t0.campaign_type_id AS campaign_type_id_17, t0.brand_id AS brand_id_18 FROM prim_campaign t0 WHERE t0.iqb_code_id = ?
Parameters:
[
  "2041"
]
20 0.14 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.iqb_code_id = ?
Parameters:
[
  "2041"
]
21 0.13 ms
SELECT t0.id AS id_1, t0.is_active AS is_active_2, t0.directory_path AS directory_path_3, t0.iqb_code_id AS iqb_code_id_4, t0.category_id AS category_id_5, t0.subcategory_1_id AS subcategory_1_id_6, t0.subcategory_2_id AS subcategory_2_id_7, t0.subcategory_3_id AS subcategory_3_id_8 FROM prim_disability_article t0 WHERE t0.iqb_code_id = ?
Parameters:
[
  "2041"
]
22 0.13 ms
SELECT t0.id AS id_1, t0.is_active AS is_active_2, t0.name AS name_3, t0.surname AS surname_4, t0.graduation_date AS graduation_date_5, t0.birth_date AS birth_date_6, t0.birth_city AS birth_city_7, t0.birth_province AS birth_province_8, t0.graduation_num AS graduation_num_9, t0.image_path AS image_path_10, t0.iqb_code_id AS iqb_code_id_11, t0.ordering_id AS ordering_id_12 FROM prim_graduation_graduate t0 WHERE t0.iqb_code_id = ?
Parameters:
[
  "2041"
]
23 0.12 ms
SELECT t0.id AS id_1, t0.priority AS priority_2, t0.image_path AS image_path_3, t0.directory_path AS directory_path_4, t0.iqb_code_id AS iqb_code_id_5, t0.brand_id AS brand_id_6 FROM prim_maintenance_category t0 WHERE t0.iqb_code_id = ?
Parameters:
[
  "2041"
]
24 0.11 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.url AS url_3, t0.iqb_code_id AS iqb_code_id_4, t0.brand_id AS brand_id_5 FROM prim_redirect t0 WHERE t0.iqb_code_id = ?
Parameters:
[
  "2041"
]
25 0.93 ms
SELECT t0.id AS id_1, t0.is_active AS is_active_2, t0.value AS value_3, t0.rfid AS rfid_4, t0.description AS description_5, t0.json_msg AS json_msg_6, t0.creation_date AS creation_date_7, t8.id AS id_9, t8.directory_path AS directory_path_10, t8.is_active AS is_active_11, t8.is_reload_active AS is_reload_active_12, t8.title AS title_13, t8.text AS text_14, t8.start_time AS start_time_15, t8.end_time AS end_time_16, t8.backup_path AS backup_path_17, t8.iqb_code_id AS iqb_code_id_18, t8.brand_id AS brand_id_19, t20.id AS id_21, t20.title AS title_22, t20.slug AS slug_23, t20.url_link AS url_link_24, t20.description AS description_25, t20.image_path AS image_path_26, t20.cover_path AS cover_path_27, t20.campaign_points_per_read AS campaign_points_per_read_28, t20.primigena_points_per_read AS primigena_points_per_read_29, t20.max_num_of_reads_per_user AS max_num_of_reads_per_user_30, t20.status AS status_31, t20.is_ean_campaign AS is_ean_campaign_32, t20.is_product_campaign AS is_product_campaign_33, t20.has_receipt AS has_receipt_34, t20.iqb_code_id AS iqb_code_id_35, t20.algorithm_id AS algorithm_id_36, t20.campaign_type_id AS campaign_type_id_37, t20.brand_id AS brand_id_38, t39.id AS id_40, t39.is_active AS is_active_41, t39.is_expirable AS is_expirable_42, t39.directory_path AS directory_path_43, t39.warranty_path AS warranty_path_44, t39.iqb_code_id AS iqb_code_id_45, t39.ean_code_id AS ean_code_id_46, t39.watermark_id AS watermark_id_47, t39.category_id AS category_id_48, t39.producer_id AS producer_id_49, t39.trademark_id AS trademark_id_50, t39.subcategory_1_id AS subcategory_1_id_51, t39.subcategory_2_id AS subcategory_2_id_52, t39.subcategory_3_id AS subcategory_3_id_53, t39.subcategory_4_id AS subcategory_4_id_54, t55.id AS id_56, t55.is_active AS is_active_57, t55.directory_path AS directory_path_58, t55.iqb_code_id AS iqb_code_id_59, t55.category_id AS category_id_60, t55.subcategory_1_id AS subcategory_1_id_61, t55.subcategory_2_id AS subcategory_2_id_62, t55.subcategory_3_id AS subcategory_3_id_63, t64.id AS id_65, t64.is_active AS is_active_66, t64.name AS name_67, t64.surname AS surname_68, t64.graduation_date AS graduation_date_69, t64.birth_date AS birth_date_70, t64.birth_city AS birth_city_71, t64.birth_province AS birth_province_72, t64.graduation_num AS graduation_num_73, t64.image_path AS image_path_74, t64.iqb_code_id AS iqb_code_id_75, t64.ordering_id AS ordering_id_76, t77.id AS id_78, t77.priority AS priority_79, t77.image_path AS image_path_80, t77.directory_path AS directory_path_81, t77.iqb_code_id AS iqb_code_id_82, t77.brand_id AS brand_id_83, t84.id AS id_85, t84.title AS title_86, t84.url AS url_87, t84.iqb_code_id AS iqb_code_id_88, t84.brand_id AS brand_id_89, t0.brand_id AS brand_id_90, t0.service_id AS service_id_91 FROM prim_iqb_code t0 LEFT JOIN prim_advertising t8 ON t8.iqb_code_id = t0.id LEFT JOIN prim_campaign t20 ON t20.iqb_code_id = t0.id LEFT JOIN prim_catalogue_product t39 ON t39.iqb_code_id = t0.id LEFT JOIN prim_disability_article t55 ON t55.iqb_code_id = t0.id LEFT JOIN prim_graduation_graduate t64 ON t64.iqb_code_id = t0.id LEFT JOIN prim_maintenance_category t77 ON t77.iqb_code_id = t0.id LEFT JOIN prim_redirect t84 ON t84.iqb_code_id = t0.id WHERE t0.id = ?
Parameters:
[
  "1865"
]

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\IqbCode 4
App\Entity\Brand 1
App\Entity\Application\Application 1
App\Entity\Redirect\Redirect 1
App\Entity\Service 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\Service No errors.
App\Entity\Campaign\Algorithm No errors.
App\Entity\Campaign\CampaignType 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\Disability\Article No errors.
App\Entity\Disability\Category No errors.
App\Entity\Disability\Subcategory1 No errors.
App\Entity\Disability\Subcategory2 No errors.
App\Entity\Disability\Subcategory3 No errors.
App\Entity\Graduation\Graduate No errors.
App\Entity\Graduation\Ordering No errors.
App\Entity\IqpCode No errors.
App\Entity\Read No errors.
App\Entity\Shopping\Stock No errors.
App\Entity\Warranty\Warranty No errors.