0.53 ms (12.51%)
|
2 |
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 p0_.slug = ? AND l1_.status = ?
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 p0_.slug = '4471' AND l1_.status = 1;
|
0.34 ms (7.98%)
|
1 |
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 = '4471';
|