3 |
1.16 ms |
SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.content AS content_2, p0_.created_at AS created_at_3, p0_.updated_at AS updated_at_4, p0_.description AS description_5, p0_.meta_title AS meta_title_6, p0_.meta_description AS meta_description_7, p0_.indexation AS indexation_8, p0_.slug AS slug_9, p0_.in_menu AS in_menu_10, p0_.profile AS profile_11, p0_.linked_to_route AS linked_to_route_12, p0_.menu_title AS menu_title_13, p0_.display_order AS display_order_14, p0_.language_id AS language_id_15, p0_.parent_id AS parent_id_16, p0_.author_id AS author_id_17 FROM page p0_ INNER JOIN language l1_ ON p0_.language_id = l1_.id WHERE l1_.iso = ? AND l1_.status = ? ORDER BY p0_.display_order ASC
SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.content AS content_2, p0_.created_at AS created_at_3, p0_.updated_at AS updated_at_4, p0_.description AS description_5, p0_.meta_title AS meta_title_6, p0_.meta_description AS meta_description_7, p0_.indexation AS indexation_8, p0_.slug AS slug_9, p0_.in_menu AS in_menu_10, p0_.profile AS profile_11, p0_.linked_to_route AS linked_to_route_12, p0_.menu_title AS menu_title_13, p0_.display_order AS display_order_14, p0_.language_id AS language_id_15, p0_.parent_id AS parent_id_16, p0_.author_id AS author_id_17 FROM page p0_ INNER JOIN language l1_ ON p0_.language_id = l1_.id WHERE l1_.iso = 'en' AND l1_.status = 1 ORDER BY p0_.display_order ASC;
|
4 |
0.50 ms |
SELECT t0.id AS id_4, t0.email AS email_5, t0.roles AS roles_6, t0.password AS password_7, t0.firstname AS firstname_8, t0.lastname AS lastname_9, t0.address1 AS address1_10, t0.address2 AS address2_11, t0.zipcode AS zipcode_12, t0.city AS city_13, t0.phone AS phone_14, t0.mobile AS mobile_15, t0.other_position AS other_position_16, t0.activation_token AS activation_token_17, t0.reset_token AS reset_token_18, t0.auto_identification_token AS auto_identification_token_19, t0.terms_approved AS terms_approved_20, t0.terms_approval_date AS terms_approval_date_21, t0.password_creation AS password_creation_22, t0.active AS active_23, t0.avatar_name AS avatar_name_24, t0.updated_at AS updated_at_25, t0.created_at AS created_at_26, t0.last_login_ip AS last_login_ip_27, t0.last_login_at AS last_login_at_28, t0.banned_at AS banned_at_29, t0.last_search_at AS last_search_at_30, t0.theme AS theme_31, t0.vegan_menu AS vegan_menu_32, t0.evening22 AS evening22_33, t0.evening23 AS evening23_34, t0.evening24 AS evening24_35, t0.accept_meeting AS accept_meeting_36, t0.country_id AS country_id_37, t0.phone_prefix_id AS phone_prefix_id_38, t0.mobile_prefix_id AS mobile_prefix_id_39, t0.position_id AS position_id_40, t0.locale_id AS locale_id_41, t0.company_id AS company_id_42, t0.title_id AS title_id_43, t0.registration_id AS registration_id_44, t0.type, t3.birth_date AS birth_date_45 FROM `user` t0 LEFT JOIN `organiser_user` t1 ON t0.id = t1.id LEFT JOIN `exhibitor_user` t2 ON t0.id = t2.id LEFT JOIN `visitor_user` t3 ON t0.id = t3.id WHERE t0.id = ?
SELECT
t0.id AS id_4,
t0.email AS email_5,
t0.roles AS roles_6,
t0.password AS password_7,
t0.firstname AS firstname_8,
t0.lastname AS lastname_9,
t0.address1 AS address1_10,
t0.address2 AS address2_11,
t0.zipcode AS zipcode_12,
t0.city AS city_13,
t0.phone AS phone_14,
t0.mobile AS mobile_15,
t0.other_position AS other_position_16,
t0.activation_token AS activation_token_17,
t0.reset_token AS reset_token_18,
t0.auto_identification_token AS auto_identification_token_19,
t0.terms_approved AS terms_approved_20,
t0.terms_approval_date AS terms_approval_date_21,
t0.password_creation AS password_creation_22,
t0.active AS active_23,
t0.avatar_name AS avatar_name_24,
t0.updated_at AS updated_at_25,
t0.created_at AS created_at_26,
t0.last_login_ip AS last_login_ip_27,
t0.last_login_at AS last_login_at_28,
t0.banned_at AS banned_at_29,
t0.last_search_at AS last_search_at_30,
t0.theme AS theme_31,
t0.vegan_menu AS vegan_menu_32,
t0.evening22 AS evening22_33,
t0.evening23 AS evening23_34,
t0.evening24 AS evening24_35,
t0.accept_meeting AS accept_meeting_36,
t0.country_id AS country_id_37,
t0.phone_prefix_id AS phone_prefix_id_38,
t0.mobile_prefix_id AS mobile_prefix_id_39,
t0.position_id AS position_id_40,
t0.locale_id AS locale_id_41,
t0.company_id AS company_id_42,
t0.title_id AS title_id_43,
t0.registration_id AS registration_id_44,
t0.type,
t3.birth_date AS birth_date_45
FROM
`user` t0
LEFT JOIN `organiser_user` t1 ON t0.id = t1.id
LEFT JOIN `exhibitor_user` t2 ON t0.id = t2.id
LEFT JOIN `visitor_user` t3 ON t0.id = t3.id
WHERE
t0.id = ?
SELECT t0.id AS id_4, t0.email AS email_5, t0.roles AS roles_6, t0.password AS password_7, t0.firstname AS firstname_8, t0.lastname AS lastname_9, t0.address1 AS address1_10, t0.address2 AS address2_11, t0.zipcode AS zipcode_12, t0.city AS city_13, t0.phone AS phone_14, t0.mobile AS mobile_15, t0.other_position AS other_position_16, t0.activation_token AS activation_token_17, t0.reset_token AS reset_token_18, t0.auto_identification_token AS auto_identification_token_19, t0.terms_approved AS terms_approved_20, t0.terms_approval_date AS terms_approval_date_21, t0.password_creation AS password_creation_22, t0.active AS active_23, t0.avatar_name AS avatar_name_24, t0.updated_at AS updated_at_25, t0.created_at AS created_at_26, t0.last_login_ip AS last_login_ip_27, t0.last_login_at AS last_login_at_28, t0.banned_at AS banned_at_29, t0.last_search_at AS last_search_at_30, t0.theme AS theme_31, t0.vegan_menu AS vegan_menu_32, t0.evening22 AS evening22_33, t0.evening23 AS evening23_34, t0.evening24 AS evening24_35, t0.accept_meeting AS accept_meeting_36, t0.country_id AS country_id_37, t0.phone_prefix_id AS phone_prefix_id_38, t0.mobile_prefix_id AS mobile_prefix_id_39, t0.position_id AS position_id_40, t0.locale_id AS locale_id_41, t0.company_id AS company_id_42, t0.title_id AS title_id_43, t0.registration_id AS registration_id_44, t0.type, t3.birth_date AS birth_date_45 FROM `user` t0 LEFT JOIN `organiser_user` t1 ON t0.id = t1.id LEFT JOIN `exhibitor_user` t2 ON t0.id = t2.id LEFT JOIN `visitor_user` t3 ON t0.id = t3.id WHERE t0.id = 1;
|
5 |
0.27 ms |
SELECT t0.id AS id_3, t0.stand_shared_with_company AS stand_shared_with_company_4, t0.status AS status_5, t0.rgpd_consent AS rgpd_consent_6, t0.last_step AS last_step_7, t0.updated_at AS updated_at_8, t0.created_at AS created_at_9, t0.cancelled_at AS cancelled_at_10, t0.atout_france_checked AS atout_france_checked_11, t0.status_thera_checked AS status_thera_checked_12, t0.fl_sent_validataion_mail AS fl_sent_validataion_mail_13, t0.status_changed_at AS status_changed_at_14, t0.subscribed_at AS subscribed_at_15, t0.manager_id AS manager_id_16, t0.company_id AS company_id_17, t0.type FROM `registration` t0 LEFT JOIN `exhibitor_registration` t1 ON t0.id = t1.id LEFT JOIN `visitor_registration` t2 ON t0.id = t2.id WHERE t0.id = ?
SELECT t0.id AS id_3, t0.stand_shared_with_company AS stand_shared_with_company_4, t0.status AS status_5, t0.rgpd_consent AS rgpd_consent_6, t0.last_step AS last_step_7, t0.updated_at AS updated_at_8, t0.created_at AS created_at_9, t0.cancelled_at AS cancelled_at_10, t0.atout_france_checked AS atout_france_checked_11, t0.status_thera_checked AS status_thera_checked_12, t0.fl_sent_validataion_mail AS fl_sent_validataion_mail_13, t0.status_changed_at AS status_changed_at_14, t0.subscribed_at AS subscribed_at_15, t0.manager_id AS manager_id_16, t0.company_id AS company_id_17, t0.type FROM `registration` t0 LEFT JOIN `exhibitor_registration` t1 ON t0.id = t1.id LEFT JOIN `visitor_registration` t2 ON t0.id = t2.id WHERE t0.id = 0;
|