3.83 ms (59.29%)
|
1 |
SELECT t0.username AS username_1, t0.username_canonical AS username_canonical_2, t0.email AS email_3, t0.email_canonical AS email_canonical_4, t0.enabled AS enabled_5, t0.salt AS salt_6, t0.password AS password_7, t0.last_login AS last_login_8, t0.confirmation_token AS confirmation_token_9, t0.password_requested_at AS password_requested_at_10, t0.roles AS roles_11, t0.id AS id_12, t0.firstname AS firstname_13, t0.lastname AS lastname_14, t0.phone_number AS phone_number_15, t16.id AS id_17, t16.birthdate AS birthdate_18, t16.hire_date AS hire_date_19, t16.birth_place AS birth_place_20, t16.gender AS gender_21, t16.is_conveyed AS is_conveyed_22, t16.hourly_rate AS hourly_rate_23, t16.is_approved AS is_approved_24, t16.rate_by_word AS rate_by_word_25, t16.rate_by_page AS rate_by_page_26, t16.is_self_employed AS is_self_employed_27, t16.siren_number AS siren_number_28, t16.is_filled AS is_filled_29, t16.is_sworn_in AS is_sworn_in_30, t16.comments AS comments_31, t16.languages AS languages_32, t16.user_id AS user_id_33, t16.address_id AS address_id_34, t35.id AS id_36, t35.is_approved AS is_approved_37, t35.is_filled AS is_filled_38, t35.address_id AS address_id_39, t35.user_id AS user_id_40, t41.id AS id_42, t41.name AS name_43, t41.is_approved AS is_approved_44, t41.is_filled AS is_filled_45, t41.siren AS siren_46, t41.customer_email AS customer_email_47, t41.referent_function AS referent_function_48, t41.accounting_email AS accounting_email_49, t41.accounting_phone AS accounting_phone_50, t41.client_type AS client_type_51, t41.address_id AS address_id_52, t41.user_id AS user_id_53 FROM users t0 LEFT JOIN interpreter t16 ON t16.user_id = t0.id LEFT JOIN individual_customer t35 ON t35.user_id = t0.id LEFT JOIN professional_customer t41 ON t41.user_id = t0.id WHERE t0.id = ? LIMIT 1
SELECT
t0.username AS username_1,
t0.username_canonical AS username_canonical_2,
t0.email AS email_3,
t0.email_canonical AS email_canonical_4,
t0.enabled AS enabled_5,
t0.salt AS salt_6,
t0.password AS password_7,
t0.last_login AS last_login_8,
t0.confirmation_token AS confirmation_token_9,
t0.password_requested_at AS password_requested_at_10,
t0.roles AS roles_11,
t0.id AS id_12,
t0.firstname AS firstname_13,
t0.lastname AS lastname_14,
t0.phone_number AS phone_number_15,
t16.id AS id_17,
t16.birthdate AS birthdate_18,
t16.hire_date AS hire_date_19,
t16.birth_place AS birth_place_20,
t16.gender AS gender_21,
t16.is_conveyed AS is_conveyed_22,
t16.hourly_rate AS hourly_rate_23,
t16.is_approved AS is_approved_24,
t16.rate_by_word AS rate_by_word_25,
t16.rate_by_page AS rate_by_page_26,
t16.is_self_employed AS is_self_employed_27,
t16.siren_number AS siren_number_28,
t16.is_filled AS is_filled_29,
t16.is_sworn_in AS is_sworn_in_30,
t16.comments AS comments_31,
t16.languages AS languages_32,
t16.user_id AS user_id_33,
t16.address_id AS address_id_34,
t35.id AS id_36,
t35.is_approved AS is_approved_37,
t35.is_filled AS is_filled_38,
t35.address_id AS address_id_39,
t35.user_id AS user_id_40,
t41.id AS id_42,
t41.name AS name_43,
t41.is_approved AS is_approved_44,
t41.is_filled AS is_filled_45,
t41.siren AS siren_46,
t41.customer_email AS customer_email_47,
t41.referent_function AS referent_function_48,
t41.accounting_email AS accounting_email_49,
t41.accounting_phone AS accounting_phone_50,
t41.client_type AS client_type_51,
t41.address_id AS address_id_52,
t41.user_id AS user_id_53
FROM
users t0
LEFT JOIN interpreter t16 ON t16.user_id = t0.id
LEFT JOIN individual_customer t35 ON t35.user_id = t0.id
LEFT JOIN professional_customer t41 ON t41.user_id = t0.id
WHERE
t0.id = ?
LIMIT
1
SELECT t0.username AS username_1, t0.username_canonical AS username_canonical_2, t0.email AS email_3, t0.email_canonical AS email_canonical_4, t0.enabled AS enabled_5, t0.salt AS salt_6, t0.password AS password_7, t0.last_login AS last_login_8, t0.confirmation_token AS confirmation_token_9, t0.password_requested_at AS password_requested_at_10, t0.roles AS roles_11, t0.id AS id_12, t0.firstname AS firstname_13, t0.lastname AS lastname_14, t0.phone_number AS phone_number_15, t16.id AS id_17, t16.birthdate AS birthdate_18, t16.hire_date AS hire_date_19, t16.birth_place AS birth_place_20, t16.gender AS gender_21, t16.is_conveyed AS is_conveyed_22, t16.hourly_rate AS hourly_rate_23, t16.is_approved AS is_approved_24, t16.rate_by_word AS rate_by_word_25, t16.rate_by_page AS rate_by_page_26, t16.is_self_employed AS is_self_employed_27, t16.siren_number AS siren_number_28, t16.is_filled AS is_filled_29, t16.is_sworn_in AS is_sworn_in_30, t16.comments AS comments_31, t16.languages AS languages_32, t16.user_id AS user_id_33, t16.address_id AS address_id_34, t35.id AS id_36, t35.is_approved AS is_approved_37, t35.is_filled AS is_filled_38, t35.address_id AS address_id_39, t35.user_id AS user_id_40, t41.id AS id_42, t41.name AS name_43, t41.is_approved AS is_approved_44, t41.is_filled AS is_filled_45, t41.siren AS siren_46, t41.customer_email AS customer_email_47, t41.referent_function AS referent_function_48, t41.accounting_email AS accounting_email_49, t41.accounting_phone AS accounting_phone_50, t41.client_type AS client_type_51, t41.address_id AS address_id_52, t41.user_id AS user_id_53 FROM users t0 LEFT JOIN interpreter t16 ON t16.user_id = t0.id LEFT JOIN individual_customer t35 ON t35.user_id = t0.id LEFT JOIN professional_customer t41 ON t41.user_id = t0.id WHERE t0.id = 1 LIMIT 1;
|
0.58 ms (8.96%)
|
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.is_approved AS is_approved_3, t0.is_filled AS is_filled_4, t0.siren AS siren_5, t0.customer_email AS customer_email_6, t0.referent_function AS referent_function_7, t0.accounting_email AS accounting_email_8, t0.accounting_phone AS accounting_phone_9, t0.client_type AS client_type_10, t0.address_id AS address_id_11, t0.user_id AS user_id_12 FROM professional_customer t0 WHERE t0.is_approved = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.is_approved AS is_approved_3, t0.is_filled AS is_filled_4, t0.siren AS siren_5, t0.customer_email AS customer_email_6, t0.referent_function AS referent_function_7, t0.accounting_email AS accounting_email_8, t0.accounting_phone AS accounting_phone_9, t0.client_type AS client_type_10, t0.address_id AS address_id_11, t0.user_id AS user_id_12 FROM professional_customer t0 WHERE t0.is_approved = 0;
|