| 1 |
0.84 ms |
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;
|
| 2 |
0.23 ms |
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;
|
| 3 |
0.19 ms |
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';
|
| 4 |
0.19 ms |
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;
|
| 5 |
0.27 ms |
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 = ?
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 = 10;
|
| 6 |
0.27 ms |
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
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 = 'P9CE15' LIMIT 1;
|
| 7 |
0.17 ms |
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 = ?
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 = '1';
|
| 8 |
0.19 ms |
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 = ?
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 = '1';
|