Symfony Profiler

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 = ?

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 = 17;

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 = ?

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 = 17;

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 = ?

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 = '9';

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 = ?

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 = 9;

SELECT
  f0_.id AS id_0,
  f0_.nickname AS nickname_1,
  f0_.address AS address_2,
  f0_.zip AS zip_3,
  f0_.city AS city_4,
  f0_.province AS province_5,
  f0_.country AS country_6,
  f0_.latitude AS latitude_7,
  f0_.longitude AS longitude_8,
  f0_.active AS active_9,
  f0_.store_id AS store_id_10
FROM
  fun_point_of_sale f0_
  INNER JOIN fun_store f1_ ON f0_.store_id = f1_.id
  INNER JOIN fun_jt_user_store f2_ ON f1_.id = f2_.store_id
WHERE
  f0_.active = ?
  AND f2_.user_id = ?

SELECT f0_.id AS id_0, f0_.nickname AS nickname_1, f0_.address AS address_2, f0_.zip AS zip_3, f0_.city AS city_4, f0_.province AS province_5, f0_.country AS country_6, f0_.latitude AS latitude_7, f0_.longitude AS longitude_8, f0_.active AS active_9, f0_.store_id AS store_id_10 FROM fun_point_of_sale f0_ INNER JOIN fun_store f1_ ON f0_.store_id = f1_.id INNER JOIN fun_jt_user_store f2_ ON f1_.id = f2_.store_id WHERE f0_.active = 1 AND f2_.user_id = '17';

SELECT
  f0_.id AS id_0,
  f0_.nickname AS nickname_1,
  f0_.address AS address_2,
  f0_.zip AS zip_3,
  f0_.city AS city_4,
  f0_.province AS province_5,
  f0_.country AS country_6,
  f0_.latitude AS latitude_7,
  f0_.longitude AS longitude_8,
  f0_.active AS active_9,
  f0_.store_id AS store_id_10
FROM
  fun_point_of_sale f0_
  INNER JOIN fun_store f1_ ON f0_.store_id = f1_.id
  INNER JOIN fun_jt_user_store f2_ ON f1_.id = f2_.store_id
WHERE
  f0_.active = ?
  AND f2_.user_id = ?
  AND f0_.id IN (?)

SELECT f0_.id AS id_0, f0_.nickname AS nickname_1, f0_.address AS address_2, f0_.zip AS zip_3, f0_.city AS city_4, f0_.province AS province_5, f0_.country AS country_6, f0_.latitude AS latitude_7, f0_.longitude AS longitude_8, f0_.active AS active_9, f0_.store_id AS store_id_10 FROM fun_point_of_sale f0_ INNER JOIN fun_store f1_ ON f0_.store_id = f1_.id INNER JOIN fun_jt_user_store f2_ ON f1_.id = f2_.store_id WHERE f0_.active = 1 AND f2_.user_id = '17' AND f0_.id IN ('10');

SELECT
  f0_.id AS id_0,
  f0_.slug AS slug_1,
  f0_.value AS value_2
FROM
  fun_campaign_media f0_
WHERE
  f0_.id IN (?)
ORDER BY
  f0_.value ASC

SELECT f0_.id AS id_0, f0_.slug AS slug_1, f0_.value AS value_2 FROM fun_campaign_media f0_ WHERE f0_.id IN ('2') ORDER BY f0_.value ASC;

SELECT
  f0_.id AS id_0,
  f0_.slug AS slug_1,
  f0_.value AS value_2,
  f0_.description AS description_3
FROM
  fun_campaign_type f0_
WHERE
  f0_.id IN (?)
ORDER BY
  f0_.value DESC

SELECT f0_.id AS id_0, f0_.slug AS slug_1, f0_.value AS value_2, f0_.description AS description_3 FROM fun_campaign_type f0_ WHERE f0_.id IN ('1') ORDER BY f0_.value DESC;

SELECT
  f0_.id AS id_0,
  f0_.slug AS slug_1,
  f0_.value AS value_2
FROM
  fun_campaign_radius f0_
WHERE
  f0_.id IN (?)
ORDER BY
  f0_.value ASC

SELECT f0_.id AS id_0, f0_.slug AS slug_1, f0_.value AS value_2 FROM fun_campaign_radius f0_ WHERE f0_.id IN ('2') ORDER BY f0_.value ASC;

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.slug = ?
LIMIT
  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.slug = 'required_details' LIMIT 1;

"START TRANSACTION"

"START TRANSACTION";

INSERT INTO fun_campaign (
  datetime_start, datetime_end, number_of_views,
  number_of_scan, minimum_spend, banner_image_path,
  banner_video_path, banner_url, code,
  game_first_discount_percentage,
  game_second_discount_percentage,
  game_third_discount_percentage,
  max_voucher_number, campaign_type_id,
  campaign_media_id, campaign_radius_id,
  game_id, campaign_phase_id
)
VALUES
  (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?
  )

INSERT INTO fun_campaign (datetime_start, datetime_end, number_of_views, number_of_scan, minimum_spend, banner_image_path, banner_video_path, banner_url, code, game_first_discount_percentage, game_second_discount_percentage, game_third_discount_percentage, max_voucher_number, campaign_type_id, campaign_media_id, campaign_radius_id, game_id, campaign_phase_id) VALUES ('2026-01-27 15:00:30', '2026-02-26 15:00:30', 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1', '2', '2', NULL, '1');

INSERT INTO fun_jt_campaign_point_of_sale (campaign_id, point_of_sale_id)
VALUES
  (?, ?)

INSERT INTO fun_jt_campaign_point_of_sale (campaign_id, point_of_sale_id) VALUES ('15', '10');

"COMMIT"

"COMMIT";

"START TRANSACTION"

"START TRANSACTION";

UPDATE
  fun_campaign
SET
  code = ?
WHERE
  id = ?

UPDATE fun_campaign SET code = 'P9CE15' WHERE id = '15';

"COMMIT"

"COMMIT";