Redirect 302 redirect from POST @user_campaign_step1 (9a26fe)

GET https://software.funride.it/utente/attivit%C3%A0/campagna/P9CE15/step-2

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
0.84 ms
(35.82%)
1
SELECT t0.id AS id_1, t0.email AS email_2, t0.password AS password_3, t0.role AS role_4, t0.is_active AS is_active_5, t0.is_admin_active AS is_admin_active_6, t0.is_tutorial_active AS is_tutorial_active_7, t0.datetime_creation AS datetime_creation_8, t0.one_time_code AS one_time_code_9, t0.expiration_one_time_code AS expiration_one_time_code_10, t11.id AS id_12, t11.name AS name_13, t11.surname AS surname_14, t11.fiscal_code AS fiscal_code_15, t11.birth_place AS birth_place_16, t11.date_birth AS date_birth_17, t11.image_path AS image_path_18, t11.user_id AS user_id_19, t20.id AS id_21, t20.license_number AS license_number_22, t20.license_plate AS license_plate_23, t20.car_producer AS car_producer_24, t20.car_model AS car_model_25, t20.number_of_people AS number_of_people_26, t20.datetime_subscription AS datetime_subscription_27, t20.datetime_expiration AS datetime_expiration_28, t20.user_id AS user_id_29 FROM fun_user t0 LEFT JOIN fun_profile t11 ON t11.user_id = t0.id LEFT JOIN fun_taxi t20 ON t20.user_id = t0.id WHERE t0.id = ?
Parameters:
[
  17
]
0.27 ms
(11.60%)
1
SELECT t0.id AS id_1, t0.datetime_start AS datetime_start_2, t0.datetime_end AS datetime_end_3, t0.number_of_views AS number_of_views_4, t0.number_of_scan AS number_of_scan_5, t0.minimum_spend AS minimum_spend_6, t0.banner_image_path AS banner_image_path_7, t0.banner_video_path AS banner_video_path_8, t0.banner_url AS banner_url_9, t0.code AS code_10, t0.game_first_discount_percentage AS game_first_discount_percentage_11, t0.game_second_discount_percentage AS game_second_discount_percentage_12, t0.game_third_discount_percentage AS game_third_discount_percentage_13, t0.max_voucher_number AS max_voucher_number_14, t15.id AS id_16, t15.code AS code_17, t15.datetime_creation AS datetime_creation_18, t15.datetime_purchase AS datetime_purchase_19, t15.datetime_payment AS datetime_payment_20, t15.vat_price AS vat_price_21, t15.net_price AS net_price_22, t15.total_amount AS total_amount_23, t15.invoice_number AS invoice_number_24, t15.is_invoice AS is_invoice_25, t15.campaign_id AS campaign_id_26, t15.store_id AS store_id_27, t0.campaign_type_id AS campaign_type_id_28, t0.campaign_media_id AS campaign_media_id_29, t0.campaign_radius_id AS campaign_radius_id_30, t0.game_id AS game_id_31, t0.campaign_phase_id AS campaign_phase_id_32 FROM fun_campaign t0 LEFT JOIN fun_purchase t15 ON t15.campaign_id = t0.id INNER JOIN fun_jt_campaign_point_of_sale ON t0.id = fun_jt_campaign_point_of_sale.campaign_id WHERE fun_jt_campaign_point_of_sale.point_of_sale_id = ?
Parameters:
[
  10
]
0.27 ms
(11.51%)
1
SELECT t0.id AS id_1, t0.datetime_start AS datetime_start_2, t0.datetime_end AS datetime_end_3, t0.number_of_views AS number_of_views_4, t0.number_of_scan AS number_of_scan_5, t0.minimum_spend AS minimum_spend_6, t0.banner_image_path AS banner_image_path_7, t0.banner_video_path AS banner_video_path_8, t0.banner_url AS banner_url_9, t0.code AS code_10, t0.game_first_discount_percentage AS game_first_discount_percentage_11, t0.game_second_discount_percentage AS game_second_discount_percentage_12, t0.game_third_discount_percentage AS game_third_discount_percentage_13, t0.max_voucher_number AS max_voucher_number_14, t15.id AS id_16, t15.code AS code_17, t15.datetime_creation AS datetime_creation_18, t15.datetime_purchase AS datetime_purchase_19, t15.datetime_payment AS datetime_payment_20, t15.vat_price AS vat_price_21, t15.net_price AS net_price_22, t15.total_amount AS total_amount_23, t15.invoice_number AS invoice_number_24, t15.is_invoice AS is_invoice_25, t15.campaign_id AS campaign_id_26, t15.store_id AS store_id_27, t0.campaign_type_id AS campaign_type_id_28, t0.campaign_media_id AS campaign_media_id_29, t0.campaign_radius_id AS campaign_radius_id_30, t0.game_id AS game_id_31, t0.campaign_phase_id AS campaign_phase_id_32 FROM fun_campaign t0 LEFT JOIN fun_purchase t15 ON t15.campaign_id = t0.id WHERE t0.code = ? LIMIT 1
Parameters:
[
  "P9CE15"
]
0.23 ms
(9.72%)
1
SELECT t0.id AS id_1, t0.role AS role_2, t0.user_id AS user_id_3, t0.store_id AS store_id_4 FROM fun_jt_user_store t0 WHERE t0.user_id = ?
Parameters:
[
  17
]
0.19 ms
(8.11%)
1
SELECT t0.id AS id_1, t0.directory_path AS directory_path_2, t0.business_name AS business_name_3, t0.vat AS vat_4, t0.fiscal_code AS fiscal_code_5, t0.sdi_code AS sdi_code_6, t0.address AS address_7, t0.zip AS zip_8, t0.city AS city_9, t0.province AS province_10, t0.country AS country_11, t0.latitude AS latitude_12, t0.longitude AS longitude_13, t0.logo_path AS logo_path_14, t0.active AS active_15, t0.datetime_subscription AS datetime_subscription_16, t0.datetime_expiration AS datetime_expiration_17, t0.subcategory_id AS subcategory_id_18 FROM fun_store t0 WHERE t0.id = ?
Parameters:
[
  "9"
]
0.19 ms
(7.94%)
1
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.value AS value_3, t0.description AS description_4 FROM fun_campaign_type t0 WHERE t0.id = ?
Parameters:
[
  "1"
]
0.19 ms
(7.90%)
1
SELECT t0.id AS id_1, t0.nickname AS nickname_2, t0.address AS address_3, t0.zip AS zip_4, t0.city AS city_5, t0.province AS province_6, t0.country AS country_7, t0.latitude AS latitude_8, t0.longitude AS longitude_9, t0.active AS active_10, t0.store_id AS store_id_11 FROM fun_point_of_sale t0 WHERE t0.store_id = ?
Parameters:
[
  9
]
0.17 ms
(7.39%)
1
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.value AS value_3, t0.color AS color_4 FROM fun_campaign_phase t0 WHERE t0.id = ?
Parameters:
[
  "1"
]

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\User 1
App\Entity\Profile 1
App\Entity\JoinTableUserStore 1
App\Entity\Store 1
App\Entity\StoreSubcategory 1
App\Entity\PointOfSale 1
App\Entity\Campaign 1
App\Entity\CampaignType 1
App\Entity\CampaignMedia 1
App\Entity\CampaignRadius 1
App\Entity\CampaignPhase 1