| 1 |
0.37 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.start AS start_3, t0.end AS end_4, t0.multiple_registrations AS multiple_registrations_5, t0.enabled AS enabled_6, t0.ask_health_info AS ask_health_info_7, t0.ask_can_swim AS ask_can_swim_8, t0.ask_media_consent AS ask_media_consent_9, t0.registration_open AS registration_open_10, t0.age_start AS age_start_11, t0.age_end AS age_end_12, t0.age_limit AS age_limit_13, t0.registration_date_limit AS registration_date_limit_14, t0.visible AS visible_15, t0.slug AS slug_16, t0.description AS description_17, t0.capacity AS capacity_18, t0.ask_contact_phone AS ask_contact_phone_19, t0.ask_leaves_alone AS ask_leaves_alone_20, t0.ask_address AS ask_address_21, t0.allow_self_registration AS allow_self_registration_22, t0.created_by AS created_by_23, t0.updated_by AS updated_by_24, t0.created_at AS created_at_25, t0.updated_at AS updated_at_26, t0.main_image_id AS main_image_id_27, t0.price_id AS price_id_28 FROM event t0 WHERE t0.slug = ? LIMIT 1
Parameters: [
"prueba-campamento"
]
SELECT t0.id AS id_1, t0.name AS name_2, t0.start AS start_3, t0.end AS end_4, t0.multiple_registrations AS multiple_registrations_5, t0.enabled AS enabled_6, t0.ask_health_info AS ask_health_info_7, t0.ask_can_swim AS ask_can_swim_8, t0.ask_media_consent AS ask_media_consent_9, t0.registration_open AS registration_open_10, t0.age_start AS age_start_11, t0.age_end AS age_end_12, t0.age_limit AS age_limit_13, t0.registration_date_limit AS registration_date_limit_14, t0.visible AS visible_15, t0.slug AS slug_16, t0.description AS description_17, t0.capacity AS capacity_18, t0.ask_contact_phone AS ask_contact_phone_19, t0.ask_leaves_alone AS ask_leaves_alone_20, t0.ask_address AS ask_address_21, t0.allow_self_registration AS allow_self_registration_22, t0.created_by AS created_by_23, t0.updated_by AS updated_by_24, t0.created_at AS created_at_25, t0.updated_at AS updated_at_26, t0.main_image_id AS main_image_id_27, t0.price_id AS price_id_28 FROM event t0 WHERE t0.slug = 'prueba-campamento' LIMIT 1;
|
| 2 |
0.29 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.start AS start_3, t0.end AS end_4, t0.capacity AS capacity_5, t0.registration_date_limit AS registration_date_limit_6, t0.event_id AS event_id_7 FROM event_period t0 WHERE t0.event_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.start AS start_3, t0.end AS end_4, t0.capacity AS capacity_5, t0.registration_date_limit AS registration_date_limit_6, t0.event_id AS event_id_7 FROM event_period t0 WHERE t0.event_id = 7;
|
| 3 |
0.31 ms |
SELECT t0.id AS id_1, t0.base_price AS base_price_2, t0.subscription_price AS subscription_price_3, t4.id AS id_5, t4.name AS name_6, t4.start AS start_7, t4.end AS end_8, t4.multiple_registrations AS multiple_registrations_9, t4.enabled AS enabled_10, t4.ask_health_info AS ask_health_info_11, t4.ask_can_swim AS ask_can_swim_12, t4.ask_media_consent AS ask_media_consent_13, t4.registration_open AS registration_open_14, t4.age_start AS age_start_15, t4.age_end AS age_end_16, t4.age_limit AS age_limit_17, t4.registration_date_limit AS registration_date_limit_18, t4.visible AS visible_19, t4.slug AS slug_20, t4.description AS description_21, t4.capacity AS capacity_22, t4.ask_contact_phone AS ask_contact_phone_23, t4.ask_leaves_alone AS ask_leaves_alone_24, t4.ask_address AS ask_address_25, t4.allow_self_registration AS allow_self_registration_26, t4.created_by AS created_by_27, t4.updated_by AS updated_by_28, t4.created_at AS created_at_29, t4.updated_at AS updated_at_30, t4.main_image_id AS main_image_id_31, t4.price_id AS price_id_32 FROM event_price t0 LEFT JOIN event t4 ON t4.price_id = t0.id WHERE t0.id = ?
SELECT t0.id AS id_1, t0.base_price AS base_price_2, t0.subscription_price AS subscription_price_3, t4.id AS id_5, t4.name AS name_6, t4.start AS start_7, t4.end AS end_8, t4.multiple_registrations AS multiple_registrations_9, t4.enabled AS enabled_10, t4.ask_health_info AS ask_health_info_11, t4.ask_can_swim AS ask_can_swim_12, t4.ask_media_consent AS ask_media_consent_13, t4.registration_open AS registration_open_14, t4.age_start AS age_start_15, t4.age_end AS age_end_16, t4.age_limit AS age_limit_17, t4.registration_date_limit AS registration_date_limit_18, t4.visible AS visible_19, t4.slug AS slug_20, t4.description AS description_21, t4.capacity AS capacity_22, t4.ask_contact_phone AS ask_contact_phone_23, t4.ask_leaves_alone AS ask_leaves_alone_24, t4.ask_address AS ask_address_25, t4.allow_self_registration AS allow_self_registration_26, t4.created_by AS created_by_27, t4.updated_by AS updated_by_28, t4.created_at AS created_at_29, t4.updated_at AS updated_at_30, t4.main_image_id AS main_image_id_31, t4.price_id AS price_id_32 FROM event_price t0 LEFT JOIN event t4 ON t4.price_id = t0.id WHERE t0.id = 5;
|
| 4 |
0.33 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.surname AS surname_3, t0.birthday AS birthday_4, t0.can_swim AS can_swim_5, t0.health_info AS health_info_6, t0.media_consent AS media_consent_7, t0.is_user AS is_user_8, t0.status AS status_9, t0.phone AS phone_10, t0.leaves_alone AS leaves_alone_11, t0.authorized_person AS authorized_person_12, t0.address AS address_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15, t0.user_id AS user_id_16, t0.event_id AS event_id_17, t0.event_booking_id AS event_booking_id_18, t0.payment_gateway_order_id AS payment_gateway_order_id_19 FROM event_registration t0 INNER JOIN event_registration_event_period ON t0.id = event_registration_event_period.event_registration_id WHERE event_registration_event_period.event_period_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.surname AS surname_3, t0.birthday AS birthday_4, t0.can_swim AS can_swim_5, t0.health_info AS health_info_6, t0.media_consent AS media_consent_7, t0.is_user AS is_user_8, t0.status AS status_9, t0.phone AS phone_10, t0.leaves_alone AS leaves_alone_11, t0.authorized_person AS authorized_person_12, t0.address AS address_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15, t0.user_id AS user_id_16, t0.event_id AS event_id_17, t0.event_booking_id AS event_booking_id_18, t0.payment_gateway_order_id AS payment_gateway_order_id_19 FROM event_registration t0 INNER JOIN event_registration_event_period ON t0.id = event_registration_event_period.event_registration_id WHERE event_registration_event_period.event_period_id = 3;
|
| 5 |
0.30 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.surname AS surname_3, t0.birthday AS birthday_4, t0.can_swim AS can_swim_5, t0.health_info AS health_info_6, t0.media_consent AS media_consent_7, t0.is_user AS is_user_8, t0.status AS status_9, t0.phone AS phone_10, t0.leaves_alone AS leaves_alone_11, t0.authorized_person AS authorized_person_12, t0.address AS address_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15, t0.user_id AS user_id_16, t0.event_id AS event_id_17, t0.event_booking_id AS event_booking_id_18, t0.payment_gateway_order_id AS payment_gateway_order_id_19 FROM event_registration t0 INNER JOIN event_registration_event_period ON t0.id = event_registration_event_period.event_registration_id WHERE event_registration_event_period.event_period_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.surname AS surname_3, t0.birthday AS birthday_4, t0.can_swim AS can_swim_5, t0.health_info AS health_info_6, t0.media_consent AS media_consent_7, t0.is_user AS is_user_8, t0.status AS status_9, t0.phone AS phone_10, t0.leaves_alone AS leaves_alone_11, t0.authorized_person AS authorized_person_12, t0.address AS address_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15, t0.user_id AS user_id_16, t0.event_id AS event_id_17, t0.event_booking_id AS event_booking_id_18, t0.payment_gateway_order_id AS payment_gateway_order_id_19 FROM event_registration t0 INNER JOIN event_registration_event_period ON t0.id = event_registration_event_period.event_registration_id WHERE event_registration_event_period.event_period_id = 4;
|
| 6 |
0.26 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.surname AS surname_3, t0.birthday AS birthday_4, t0.can_swim AS can_swim_5, t0.health_info AS health_info_6, t0.media_consent AS media_consent_7, t0.is_user AS is_user_8, t0.status AS status_9, t0.phone AS phone_10, t0.leaves_alone AS leaves_alone_11, t0.authorized_person AS authorized_person_12, t0.address AS address_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15, t0.user_id AS user_id_16, t0.event_id AS event_id_17, t0.event_booking_id AS event_booking_id_18, t0.payment_gateway_order_id AS payment_gateway_order_id_19 FROM event_registration t0 INNER JOIN event_registration_event_period ON t0.id = event_registration_event_period.event_registration_id WHERE event_registration_event_period.event_period_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.surname AS surname_3, t0.birthday AS birthday_4, t0.can_swim AS can_swim_5, t0.health_info AS health_info_6, t0.media_consent AS media_consent_7, t0.is_user AS is_user_8, t0.status AS status_9, t0.phone AS phone_10, t0.leaves_alone AS leaves_alone_11, t0.authorized_person AS authorized_person_12, t0.address AS address_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15, t0.user_id AS user_id_16, t0.event_id AS event_id_17, t0.event_booking_id AS event_booking_id_18, t0.payment_gateway_order_id AS payment_gateway_order_id_19 FROM event_registration t0 INNER JOIN event_registration_event_period ON t0.id = event_registration_event_period.event_registration_id WHERE event_registration_event_period.event_period_id = 5;
|
| 7 |
0.25 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.surname AS surname_3, t0.birthday AS birthday_4, t0.can_swim AS can_swim_5, t0.health_info AS health_info_6, t0.media_consent AS media_consent_7, t0.is_user AS is_user_8, t0.status AS status_9, t0.phone AS phone_10, t0.leaves_alone AS leaves_alone_11, t0.authorized_person AS authorized_person_12, t0.address AS address_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15, t0.user_id AS user_id_16, t0.event_id AS event_id_17, t0.event_booking_id AS event_booking_id_18, t0.payment_gateway_order_id AS payment_gateway_order_id_19 FROM event_registration t0 INNER JOIN event_registration_event_period ON t0.id = event_registration_event_period.event_registration_id WHERE event_registration_event_period.event_period_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.surname AS surname_3, t0.birthday AS birthday_4, t0.can_swim AS can_swim_5, t0.health_info AS health_info_6, t0.media_consent AS media_consent_7, t0.is_user AS is_user_8, t0.status AS status_9, t0.phone AS phone_10, t0.leaves_alone AS leaves_alone_11, t0.authorized_person AS authorized_person_12, t0.address AS address_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15, t0.user_id AS user_id_16, t0.event_id AS event_id_17, t0.event_booking_id AS event_booking_id_18, t0.payment_gateway_order_id AS payment_gateway_order_id_19 FROM event_registration t0 INNER JOIN event_registration_event_period ON t0.id = event_registration_event_period.event_registration_id WHERE event_registration_event_period.event_period_id = 6;
|
| 8 |
0.29 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.surname AS surname_3, t0.birthday AS birthday_4, t0.can_swim AS can_swim_5, t0.health_info AS health_info_6, t0.media_consent AS media_consent_7, t0.is_user AS is_user_8, t0.status AS status_9, t0.phone AS phone_10, t0.leaves_alone AS leaves_alone_11, t0.authorized_person AS authorized_person_12, t0.address AS address_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15, t0.user_id AS user_id_16, t0.event_id AS event_id_17, t0.event_booking_id AS event_booking_id_18, t0.payment_gateway_order_id AS payment_gateway_order_id_19 FROM event_registration t0 INNER JOIN event_registration_event_period ON t0.id = event_registration_event_period.event_registration_id WHERE event_registration_event_period.event_period_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.surname AS surname_3, t0.birthday AS birthday_4, t0.can_swim AS can_swim_5, t0.health_info AS health_info_6, t0.media_consent AS media_consent_7, t0.is_user AS is_user_8, t0.status AS status_9, t0.phone AS phone_10, t0.leaves_alone AS leaves_alone_11, t0.authorized_person AS authorized_person_12, t0.address AS address_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15, t0.user_id AS user_id_16, t0.event_id AS event_id_17, t0.event_booking_id AS event_booking_id_18, t0.payment_gateway_order_id AS payment_gateway_order_id_19 FROM event_registration t0 INNER JOIN event_registration_event_period ON t0.id = event_registration_event_period.event_registration_id WHERE event_registration_event_period.event_period_id = 7;
|
| 9 |
0.23 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.base_discount AS base_discount_3, t0.subscription_discount AS subscription_discount_4, t0.applies_to_minors_only AS applies_to_minors_only_5, t0.requires_documentation AS requires_documentation_6, t0.event_id AS event_id_7 FROM event_discount t0 WHERE t0.event_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.base_discount AS base_discount_3, t0.subscription_discount AS subscription_discount_4, t0.applies_to_minors_only AS applies_to_minors_only_5, t0.requires_documentation AS requires_documentation_6, t0.event_id AS event_id_7 FROM event_discount t0 WHERE t0.event_id = 7;
|