GET https://www.primigenagroup.com/admin/utenti/97/scheda

Response
200 OK
IP
216.73.217.162
Profiled on
Token
cb277f

Query Metrics

9 Database Queries
3 Different statements
4.26 ms Query time
0 Invalid entities
22 Managed entities

Queries

Group similar statements

#▲ Time Info
1 0.64 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 = ? LIMIT 1
Parameters: 
[
  "97"
]
View formatted query    View runnable query    Explain query
2 0.64 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.brand_id AS brand_id_5 FROM prim_join_table_user_brand t0 WHERE t0.user_id = ?
Parameters: 
[
  "97"
]
View formatted query    View runnable query    Explain query
3 0.55 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 = ?
Parameters: 
[
  "19"
]
View formatted query    View runnable query    Explain query
4 0.72 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 = ?
Parameters: 
[
  "1"
]
View formatted query    View runnable query    Explain query
5 0.35 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 = ?
Parameters: 
[
  "55"
]
View formatted query    View runnable query    Explain query
6 0.39 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 = ?
Parameters: 
[
  "99"
]
View formatted query    View runnable query    Explain query
7 0.29 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 = ?
Parameters: 
[
  "100"
]
View formatted query    View runnable query    Explain query
8 0.35 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 = ?
Parameters: 
[
  "112"
]
View formatted query    View runnable query    Explain query
9 0.34 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 = ?
Parameters: 
[
  "36"
]
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\JoinTableUserBrand 7
App\Entity\Brand 7
App\Entity\Application\Application 7
App\Entity\User 1

Entities Mapping

Class Mapping errors
App\Entity\User No errors.
App\Entity\Cart No errors.
App\Entity\JoinTableUserBrand No errors.
App\Entity\JoinTableUserPointOfSale 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\Campaign\Ticket No errors.
App\Entity\Maintenance\Notification No errors.
App\Entity\Warranty\Warranty No errors.
App\Entity\Shopping\Storage No errors.
App\Entity\Brand No errors.
App\Entity\Application\Application 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.