3
0.25 ms
SELECT t0 . id AS id_1 , t0 . username AS username_2 , t0 . roles AS roles_3 , t0 . password AS password_4 , t0 . enabled AS enabled_5 , t0 . created_at AS created_at_6 , t0 . updated_at AS updated_at_7 , t0 . email_token AS email_token_8 , t0 . is_password_set AS is_password_set_9 , t0 . email_token_date AS email_token_date_10 , t11 . id AS id_12 , t11 . firstname AS firstname_13 , t11 . lastname AS lastname_14 , t11 . email AS email_15 , t11 . phone AS phone_16 , t11 . user_id AS user_id_17 , t11 . function_id AS function_id_18 , t11 . address_id AS address_id_19 , t0 . default_btob_territory_id AS default_btob_territory_id_20 , t0 . default_btoc_territory_id AS default_btoc_territory_id_21 , t0 . login_message_id AS login_message_id_22 FROM `user` t0 LEFT JOIN profile t11 ON t11 . user_id = t0 . id WHERE t0 . id = ?
Parameters :
[
b"\x01 žË9“À{©©±õ·\x12 òõU "
]
SELECT t0 . id AS id_1 , t0 . username AS username_2 , t0 . roles AS roles_3 , t0 . password AS password_4 , t0 . enabled AS enabled_5 , t0 . created_at AS created_at_6 , t0 . updated_at AS updated_at_7 , t0 . email_token AS email_token_8 , t0 . is_password_set AS is_password_set_9 , t0 . email_token_date AS email_token_date_10 , t11 . id AS id_12 , t11 . firstname AS firstname_13 , t11 . lastname AS lastname_14 , t11 . email AS email_15 , t11 . phone AS phone_16 , t11 . user_id AS user_id_17 , t11 . function_id AS function_id_18 , t11 . address_id AS address_id_19 , t0 . default_btob_territory_id AS default_btob_territory_id_20 , t0 . default_btoc_territory_id AS default_btoc_territory_id_21 , t0 . login_message_id AS login_message_id_22 FROM `user` t0 LEFT JOIN profile t11 ON t11 . user_id = t0 . id WHERE t0 . id = 0x019ECB3993C07BA9A9B1F5B712F2F555 ;
Copy
4
0.48 ms
SELECT t0 . id AS id_1 , t0 . username AS username_2 , t0 . roles AS roles_3 , t0 . password AS password_4 , t0 . enabled AS enabled_5 , t0 . created_at AS created_at_6 , t0 . updated_at AS updated_at_7 , t0 . email_token AS email_token_8 , t0 . is_password_set AS is_password_set_9 , t0 . email_token_date AS email_token_date_10 , t11 . id AS id_12 , t11 . firstname AS firstname_13 , t11 . lastname AS lastname_14 , t11 . email AS email_15 , t11 . phone AS phone_16 , t11 . user_id AS user_id_17 , t11 . function_id AS function_id_18 , t11 . address_id AS address_id_19 , t0 . default_btob_territory_id AS default_btob_territory_id_20 , t0 . default_btoc_territory_id AS default_btoc_territory_id_21 , t0 . login_message_id AS login_message_id_22 FROM `user` t0 LEFT JOIN profile t11 ON t11 . user_id = t0 . id WHERE t0 . id = ?
Parameters :
[
b"\x01 žË?OŽsî¸à9Ãp·žV "
]
SELECT t0 . id AS id_1 , t0 . username AS username_2 , t0 . roles AS roles_3 , t0 . password AS password_4 , t0 . enabled AS enabled_5 , t0 . created_at AS created_at_6 , t0 . updated_at AS updated_at_7 , t0 . email_token AS email_token_8 , t0 . is_password_set AS is_password_set_9 , t0 . email_token_date AS email_token_date_10 , t11 . id AS id_12 , t11 . firstname AS firstname_13 , t11 . lastname AS lastname_14 , t11 . email AS email_15 , t11 . phone AS phone_16 , t11 . user_id AS user_id_17 , t11 . function_id AS function_id_18 , t11 . address_id AS address_id_19 , t0 . default_btob_territory_id AS default_btob_territory_id_20 , t0 . default_btoc_territory_id AS default_btoc_territory_id_21 , t0 . login_message_id AS login_message_id_22 FROM `user` t0 LEFT JOIN profile t11 ON t11 . user_id = t0 . id WHERE t0 . id = 0x019ECB3F4F8E73EEB8E039C370B79E56 ;
Copy
5
0.34 ms
SELECT t0 . id AS id_1 , t0 . code AS code_2 , t0 . social_reason AS social_reason_3 , t0 . commercial_name AS commercial_name_4 , t0 . enabled AS enabled_5 , t0 . created_at AS created_at_6 , t0 . updated_at AS updated_at_7 , t0 . subscribed AS subscribed_8 , t0 . subscription AS subscription_9 , t0 . license_siv AS license_siv_10 , t0 . subscription_type AS subscription_type_11 , t0 . phone AS phone_12 , t0 . netsuite_id AS netsuite_id_13 , t0 . netsuite_periodicity AS netsuite_periodicity_14 , t0 . network_id AS network_id_15 , t16 . id AS id_17 , t16 . code AS code_18 , t16 . name AS name_19 , t16 . description AS description_20 , t16 . enabled AS enabled_21 , t16 . logo AS logo_22 , t16 . icon AS icon_23 , t16 . menu_logo AS menu_logo_24 , t16 . gocad_id AS gocad_id_25 , t16 . gocad_server_id AS gocad_server_id_26 , t16 . db_sources AS db_sources_27 , t16 . conditions_generales AS conditions_generales_28 , t16 . devis_payment_mode AS devis_payment_mode_29 , t16 . devis_legal_payment_mention AS devis_legal_payment_mention_30 , t16 . devis_bottom_page AS devis_bottom_page_31 , t16 . devis_logo AS devis_logo_32 , t16 . reduction AS reduction_33 , t16 . devis_code AS devis_code_34 , t16 . free_fiche AS free_fiche_35 , t16 . decimal_precision AS decimal_precision_36 , t16 . default_subscription_price_id AS default_subscription_price_id_37 , t16 . type_id AS type_id_38 , t16 . billing_information_id AS billing_information_id_39 , t16 . subscription_price_id AS subscription_price_id_40 , t0 . subscription_price_id AS subscription_price_id_41 , t0 . alternative_billing_information_id AS alternative_billing_information_id_42 , t0 . split_id AS split_id_43 , t0 . type_id AS type_id_44 FROM sale_ref t0 INNER JOIN network t16 ON t0 . network_id = t16 . id INNER JOIN user_sale_ref ON t0 . id = user_sale_ref . sale_ref_id WHERE user_sale_ref . user_id = ?
Parameters :
[
b"\x01 žË?OŽsî¸à9Ãp·žV "
]
SELECT
t0 . id AS id_1 ,
t0 . code AS code_2 ,
t0 . social_reason AS social_reason_3 ,
t0 . commercial_name AS commercial_name_4 ,
t0 . enabled AS enabled_5 ,
t0 . created_at AS created_at_6 ,
t0 . updated_at AS updated_at_7 ,
t0 . subscribed AS subscribed_8 ,
t0 . subscription AS subscription_9 ,
t0 . license_siv AS license_siv_10 ,
t0 . subscription_type AS subscription_type_11 ,
t0 . phone AS phone_12 ,
t0 . netsuite_id AS netsuite_id_13 ,
t0 . netsuite_periodicity AS netsuite_periodicity_14 ,
t0 . network_id AS network_id_15 ,
t16 . id AS id_17 ,
t16 . code AS code_18 ,
t16 . name AS name_19 ,
t16 . description AS description_20 ,
t16 . enabled AS enabled_21 ,
t16 . logo AS logo_22 ,
t16 . icon AS icon_23 ,
t16 . menu_logo AS menu_logo_24 ,
t16 . gocad_id AS gocad_id_25 ,
t16 . gocad_server_id AS gocad_server_id_26 ,
t16 . db_sources AS db_sources_27 ,
t16 . conditions_generales AS conditions_generales_28 ,
t16 . devis_payment_mode AS devis_payment_mode_29 ,
t16 . devis_legal_payment_mention AS devis_legal_payment_mention_30 ,
t16 . devis_bottom_page AS devis_bottom_page_31 ,
t16 . devis_logo AS devis_logo_32 ,
t16 . reduction AS reduction_33 ,
t16 . devis_code AS devis_code_34 ,
t16 . free_fiche AS free_fiche_35 ,
t16 . decimal_precision AS decimal_precision_36 ,
t16 . default_subscription_price_id AS default_subscription_price_id_37 ,
t16 . type_id AS type_id_38 ,
t16 . billing_information_id AS billing_information_id_39 ,
t16 . subscription_price_id AS subscription_price_id_40 ,
t0 . subscription_price_id AS subscription_price_id_41 ,
t0 . alternative_billing_information_id AS alternative_billing_information_id_42 ,
t0 . split_id AS split_id_43 ,
t0 . type_id AS type_id_44
FROM
sale_ref t0
INNER JOIN network t16 ON t0 . network_id = t16 . id
INNER JOIN user_sale_ref ON t0 . id = user_sale_ref . sale_ref_id
WHERE
user_sale_ref . user_id = ?
Copy
SELECT t0 . id AS id_1 , t0 . code AS code_2 , t0 . social_reason AS social_reason_3 , t0 . commercial_name AS commercial_name_4 , t0 . enabled AS enabled_5 , t0 . created_at AS created_at_6 , t0 . updated_at AS updated_at_7 , t0 . subscribed AS subscribed_8 , t0 . subscription AS subscription_9 , t0 . license_siv AS license_siv_10 , t0 . subscription_type AS subscription_type_11 , t0 . phone AS phone_12 , t0 . netsuite_id AS netsuite_id_13 , t0 . netsuite_periodicity AS netsuite_periodicity_14 , t0 . network_id AS network_id_15 , t16 . id AS id_17 , t16 . code AS code_18 , t16 . name AS name_19 , t16 . description AS description_20 , t16 . enabled AS enabled_21 , t16 . logo AS logo_22 , t16 . icon AS icon_23 , t16 . menu_logo AS menu_logo_24 , t16 . gocad_id AS gocad_id_25 , t16 . gocad_server_id AS gocad_server_id_26 , t16 . db_sources AS db_sources_27 , t16 . conditions_generales AS conditions_generales_28 , t16 . devis_payment_mode AS devis_payment_mode_29 , t16 . devis_legal_payment_mention AS devis_legal_payment_mention_30 , t16 . devis_bottom_page AS devis_bottom_page_31 , t16 . devis_logo AS devis_logo_32 , t16 . reduction AS reduction_33 , t16 . devis_code AS devis_code_34 , t16 . free_fiche AS free_fiche_35 , t16 . decimal_precision AS decimal_precision_36 , t16 . default_subscription_price_id AS default_subscription_price_id_37 , t16 . type_id AS type_id_38 , t16 . billing_information_id AS billing_information_id_39 , t16 . subscription_price_id AS subscription_price_id_40 , t0 . subscription_price_id AS subscription_price_id_41 , t0 . alternative_billing_information_id AS alternative_billing_information_id_42 , t0 . split_id AS split_id_43 , t0 . type_id AS type_id_44 FROM sale_ref t0 INNER JOIN network t16 ON t0 . network_id = t16 . id INNER JOIN user_sale_ref ON t0 . id = user_sale_ref . sale_ref_id WHERE user_sale_ref . user_id = 0x019ECB3F4F8E73EEB8E039C370B79E56 ;
Copy
6
0.53 ms
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . social_reason AS social_reason_3 , t0 . enabled AS enabled_4 , t0 . iban AS iban_5 , t0 . bic AS bic_6 , t0 . bank_label AS bank_label_7 , t0 . sale_ref_id AS sale_ref_id_8 , t0 . type_id AS type_id_9 , t0 . address_id AS address_id_10 FROM billing_information t0 WHERE t0 . sale_ref_id IN (? , ? , ? , ? , ? , ? , ? , ? , ? )
Parameters :
[
2
89
90
91
92
93
94
131
143
]
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . social_reason AS social_reason_3 , t0 . enabled AS enabled_4 , t0 . iban AS iban_5 , t0 . bic AS bic_6 , t0 . bank_label AS bank_label_7 , t0 . sale_ref_id AS sale_ref_id_8 , t0 . type_id AS type_id_9 , t0 . address_id AS address_id_10 FROM billing_information t0 WHERE t0 . sale_ref_id IN (2 , 89 , 90 , 91 , 92 , 93 , 94 , 131 , 143 );
Copy