1
4.27 ms
SELECT t0 . id AS id_1 , t0 . email AS email_2 , t0 . roles AS roles_3 , t0 . password AS password_4 , t0 . is_verified AS is_verified_5 , t0 . firstname AS firstname_6 , t0 . name AS name_7 , t0 . is_active AS is_active_8 , t0 . partenaire AS partenaire_9 , t0 . last_login AS last_login_10 , t0 . is_ready AS is_ready_11 , t0 . referent AS referent_12 , t0 . difficulty AS difficulty_13 , t0 . is_premium AS is_premium_14 , t0 . is_gold AS is_gold_15 , t0 . tokens_invalidated_at AS tokens_invalidated_at_16 , t0 . hubspot_id AS hubspot_id_17 , t0 . service_id AS service_id_18 , t0 . notif_configuration_id AS notif_configuration_id_19 , t0 . mail_configuration_id AS mail_configuration_id_20 FROM admin t0 WHERE t0 . email = ? LIMIT 1
Parameters :
[
"poseuradmin@reseauglass.fr "
]
SELECT t0 . id AS id_1 , t0 . email AS email_2 , t0 . roles AS roles_3 , t0 . password AS password_4 , t0 . is_verified AS is_verified_5 , t0 . firstname AS firstname_6 , t0 . name AS name_7 , t0 . is_active AS is_active_8 , t0 . partenaire AS partenaire_9 , t0 . last_login AS last_login_10 , t0 . is_ready AS is_ready_11 , t0 . referent AS referent_12 , t0 . difficulty AS difficulty_13 , t0 . is_premium AS is_premium_14 , t0 . is_gold AS is_gold_15 , t0 . tokens_invalidated_at AS tokens_invalidated_at_16 , t0 . hubspot_id AS hubspot_id_17 , t0 . service_id AS service_id_18 , t0 . notif_configuration_id AS notif_configuration_id_19 , t0 . mail_configuration_id AS mail_configuration_id_20 FROM admin t0 WHERE t0 . email = 'poseuradmin@reseauglass.fr' LIMIT 1 ;
Copy
2
5.34 ms
SELECT t0 . id AS id_1 , t0 . siret AS siret_2 , t0 . name AS name_3 , t0 . trade_name AS trade_name_4 , t0 . iban AS iban_5 , t0 . tva_number AS tva_number_6 , t0 . created_at AS created_at_7 , t0 . email AS email_8 , t0 . logo AS logo_9 , t0 . phone AS phone_10 , t0 . bic AS bic_11 , t0 . price AS price_12 , t0 . price_no_decla AS price_no_decla_13 , t0 . stripe_id AS stripe_id_14 , t0 . jeton AS jeton_15 , t0 . is_supplier AS is_supplier_16 , t0 . is_prospect AS is_prospect_17 , t0 . is_active AS is_active_18 , t0 . comment AS comment_19 , t0 . invoice_number_prefix AS invoice_number_prefix_20 , t0 . invoice_number_start_counter AS invoice_number_start_counter_21 , t0 . invoice_number_reset_counter AS invoice_number_reset_counter_22 , t0 . number_of_digits_for_invoice_number AS number_of_digits_for_invoice_number_23 , t0 . quotation_number_prefix AS quotation_number_prefix_24 , t0 . quotation_number_start_counter AS quotation_number_start_counter_25 , t0 . quotation_number_reset_counter AS quotation_number_reset_counter_26 , t0 . number_of_digits_for_quotation_number AS number_of_digits_for_quotation_number_27 , t0 . is_no_same_number AS is_no_same_number_28 , t0 . credit_number_prefix AS credit_number_prefix_29 , t0 . lat AS lat_30 , t0 . lng AS lng_31 , t0 . identite_recto AS identite_recto_32 , t0 . identite_verso AS identite_verso_33 , t0 . kbis AS kbis_34 , t0 . rib AS rib_35 , t0 . unsubmit_tva AS unsubmit_tva_36 , t0 . supplier_hello_glass AS supplier_hello_glass_37 , t0 . ape AS ape_38 , t0 . difficulty AS difficulty_39 , t0 . stripe_tax_rate_id AS stripe_tax_rate_id_40 , t0 . tax_rate AS tax_rate_41 , t0 . clearbus AS clearbus_42 , t0 . morning_start AS morning_start_43 , t0 . morning_end AS morning_end_44 , t0 . afternoon_start AS afternoon_start_45 , t0 . afternoon_end AS afternoon_end_46 , t0 . morning_saturday_start AS morning_saturday_start_47 , t0 . morning_saturday_end AS morning_saturday_end_48 , t0 . afternoon_saturday_start AS afternoon_saturday_start_49 , t0 . afternoon_saturday_end AS afternoon_saturday_end_50 , t0 . prime AS prime_51 , t0 . verso_invoice AS verso_invoice_52 , t0 . charge_folder AS charge_folder_53 , t0 . comment_update AS comment_update_54 , t0 . known_name AS known_name_55 , t0 . gifts AS gifts_56 , t0 . customer_authorisation AS customer_authorisation_57 , t0 . garage_type AS garage_type_58 , t0 . contractual_franchise AS contractual_franchise_59 , t0 . other_authorisation AS other_authorisation_60 , t0 . other_gifts AS other_gifts_61 , t0 . blocked AS blocked_62 , t0 . id_garage AS id_garage_63 , t0 . email_api AS email_api_64 , t0 . paid_date_day AS paid_date_day_65 , t0 . payment_method AS payment_method_66 , t0 . acquisition_source AS acquisition_source_67 , t0 . acquisition_source_detail AS acquisition_source_detail_68 , t0 . is_premium AS is_premium_69 , t0 . legal_form AS legal_form_70 , t0 . tax_regime AS tax_regime_71 , t0 . share_capital AS share_capital_72 , t0 . rcs AS rcs_73 , t0 . terms_and_conditions_file AS terms_and_conditions_file_74 , t0 . apply_terms_for_invoice AS apply_terms_for_invoice_75 , t0 . apply_terms_for_quote AS apply_terms_for_quote_76 , t0 . apply_terms_for_repair_order AS apply_terms_for_repair_order_77 , t0 . hubspot_id AS hubspot_id_78 , t0 . supplier_id AS supplier_id_79 , t0 . commercial_id AS commercial_id_80 , t0 . category_id AS category_id_81 , t0 . configuration_id AS configuration_id_82 , t0 . bridge_user_id AS bridge_user_id_83 , t0 . franchise_id AS franchise_id_84 , t0 . franchise_supplier_id AS franchise_supplier_id_85 , t86 . id AS id_87 , t86 . provider AS provider_88 , t86 . email AS email_89 , t86 . access_token AS access_token_90 , t86 . refresh_token AS refresh_token_91 , t86 . token_expires_at AS token_expires_at_92 , t86 . company_id AS company_id_93 FROM companie t0 LEFT JOIN email_credential t86 ON t86 . company_id = t0 . id WHERE t0 . id = ?
SELECT
t0 . id AS id_1 ,
t0 . siret AS siret_2 ,
t0 . name AS name_3 ,
t0 . trade_name AS trade_name_4 ,
t0 . iban AS iban_5 ,
t0 . tva_number AS tva_number_6 ,
t0 . created_at AS created_at_7 ,
t0 . email AS email_8 ,
t0 . logo AS logo_9 ,
t0 . phone AS phone_10 ,
t0 . bic AS bic_11 ,
t0 . price AS price_12 ,
t0 . price_no_decla AS price_no_decla_13 ,
t0 . stripe_id AS stripe_id_14 ,
t0 . jeton AS jeton_15 ,
t0 . is_supplier AS is_supplier_16 ,
t0 . is_prospect AS is_prospect_17 ,
t0 . is_active AS is_active_18 ,
t0 . comment AS comment_19 ,
t0 . invoice_number_prefix AS invoice_number_prefix_20 ,
t0 . invoice_number_start_counter AS invoice_number_start_counter_21 ,
t0 . invoice_number_reset_counter AS invoice_number_reset_counter_22 ,
t0 . number_of_digits_for_invoice_number AS number_of_digits_for_invoice_number_23 ,
t0 . quotation_number_prefix AS quotation_number_prefix_24 ,
t0 . quotation_number_start_counter AS quotation_number_start_counter_25 ,
t0 . quotation_number_reset_counter AS quotation_number_reset_counter_26 ,
t0 . number_of_digits_for_quotation_number AS number_of_digits_for_quotation_number_27 ,
t0 . is_no_same_number AS is_no_same_number_28 ,
t0 . credit_number_prefix AS credit_number_prefix_29 ,
t0 . lat AS lat_30 ,
t0 . lng AS lng_31 ,
t0 . identite_recto AS identite_recto_32 ,
t0 . identite_verso AS identite_verso_33 ,
t0 . kbis AS kbis_34 ,
t0 . rib AS rib_35 ,
t0 . unsubmit_tva AS unsubmit_tva_36 ,
t0 . supplier_hello_glass AS supplier_hello_glass_37 ,
t0 . ape AS ape_38 ,
t0 . difficulty AS difficulty_39 ,
t0 . stripe_tax_rate_id AS stripe_tax_rate_id_40 ,
t0 . tax_rate AS tax_rate_41 ,
t0 . clearbus AS clearbus_42 ,
t0 . morning_start AS morning_start_43 ,
t0 . morning_end AS morning_end_44 ,
t0 . afternoon_start AS afternoon_start_45 ,
t0 . afternoon_end AS afternoon_end_46 ,
t0 . morning_saturday_start AS morning_saturday_start_47 ,
t0 . morning_saturday_end AS morning_saturday_end_48 ,
t0 . afternoon_saturday_start AS afternoon_saturday_start_49 ,
t0 . afternoon_saturday_end AS afternoon_saturday_end_50 ,
t0 . prime AS prime_51 ,
t0 . verso_invoice AS verso_invoice_52 ,
t0 . charge_folder AS charge_folder_53 ,
t0 . comment_update AS comment_update_54 ,
t0 . known_name AS known_name_55 ,
t0 . gifts AS gifts_56 ,
t0 . customer_authorisation AS customer_authorisation_57 ,
t0 . garage_type AS garage_type_58 ,
t0 . contractual_franchise AS contractual_franchise_59 ,
t0 . other_authorisation AS other_authorisation_60 ,
t0 . other_gifts AS other_gifts_61 ,
t0 . blocked AS blocked_62 ,
t0 . id_garage AS id_garage_63 ,
t0 . email_api AS email_api_64 ,
t0 . paid_date_day AS paid_date_day_65 ,
t0 . payment_method AS payment_method_66 ,
t0 . acquisition_source AS acquisition_source_67 ,
t0 . acquisition_source_detail AS acquisition_source_detail_68 ,
t0 . is_premium AS is_premium_69 ,
t0 . legal_form AS legal_form_70 ,
t0 . tax_regime AS tax_regime_71 ,
t0 . share_capital AS share_capital_72 ,
t0 . rcs AS rcs_73 ,
t0 . terms_and_conditions_file AS terms_and_conditions_file_74 ,
t0 . apply_terms_for_invoice AS apply_terms_for_invoice_75 ,
t0 . apply_terms_for_quote AS apply_terms_for_quote_76 ,
t0 . apply_terms_for_repair_order AS apply_terms_for_repair_order_77 ,
t0 . hubspot_id AS hubspot_id_78 ,
t0 . supplier_id AS supplier_id_79 ,
t0 . commercial_id AS commercial_id_80 ,
t0 . category_id AS category_id_81 ,
t0 . configuration_id AS configuration_id_82 ,
t0 . bridge_user_id AS bridge_user_id_83 ,
t0 . franchise_id AS franchise_id_84 ,
t0 . franchise_supplier_id AS franchise_supplier_id_85 ,
t86 . id AS id_87 ,
t86 . provider AS provider_88 ,
t86 . email AS email_89 ,
t86 . access_token AS access_token_90 ,
t86 . refresh_token AS refresh_token_91 ,
t86 . token_expires_at AS token_expires_at_92 ,
t86 . company_id AS company_id_93
FROM
companie t0
LEFT JOIN email_credential t86 ON t86 . company_id = t0 . id
WHERE
t0 . id = ?
Copy
SELECT t0 . id AS id_1 , t0 . siret AS siret_2 , t0 . name AS name_3 , t0 . trade_name AS trade_name_4 , t0 . iban AS iban_5 , t0 . tva_number AS tva_number_6 , t0 . created_at AS created_at_7 , t0 . email AS email_8 , t0 . logo AS logo_9 , t0 . phone AS phone_10 , t0 . bic AS bic_11 , t0 . price AS price_12 , t0 . price_no_decla AS price_no_decla_13 , t0 . stripe_id AS stripe_id_14 , t0 . jeton AS jeton_15 , t0 . is_supplier AS is_supplier_16 , t0 . is_prospect AS is_prospect_17 , t0 . is_active AS is_active_18 , t0 . comment AS comment_19 , t0 . invoice_number_prefix AS invoice_number_prefix_20 , t0 . invoice_number_start_counter AS invoice_number_start_counter_21 , t0 . invoice_number_reset_counter AS invoice_number_reset_counter_22 , t0 . number_of_digits_for_invoice_number AS number_of_digits_for_invoice_number_23 , t0 . quotation_number_prefix AS quotation_number_prefix_24 , t0 . quotation_number_start_counter AS quotation_number_start_counter_25 , t0 . quotation_number_reset_counter AS quotation_number_reset_counter_26 , t0 . number_of_digits_for_quotation_number AS number_of_digits_for_quotation_number_27 , t0 . is_no_same_number AS is_no_same_number_28 , t0 . credit_number_prefix AS credit_number_prefix_29 , t0 . lat AS lat_30 , t0 . lng AS lng_31 , t0 . identite_recto AS identite_recto_32 , t0 . identite_verso AS identite_verso_33 , t0 . kbis AS kbis_34 , t0 . rib AS rib_35 , t0 . unsubmit_tva AS unsubmit_tva_36 , t0 . supplier_hello_glass AS supplier_hello_glass_37 , t0 . ape AS ape_38 , t0 . difficulty AS difficulty_39 , t0 . stripe_tax_rate_id AS stripe_tax_rate_id_40 , t0 . tax_rate AS tax_rate_41 , t0 . clearbus AS clearbus_42 , t0 . morning_start AS morning_start_43 , t0 . morning_end AS morning_end_44 , t0 . afternoon_start AS afternoon_start_45 , t0 . afternoon_end AS afternoon_end_46 , t0 . morning_saturday_start AS morning_saturday_start_47 , t0 . morning_saturday_end AS morning_saturday_end_48 , t0 . afternoon_saturday_start AS afternoon_saturday_start_49 , t0 . afternoon_saturday_end AS afternoon_saturday_end_50 , t0 . prime AS prime_51 , t0 . verso_invoice AS verso_invoice_52 , t0 . charge_folder AS charge_folder_53 , t0 . comment_update AS comment_update_54 , t0 . known_name AS known_name_55 , t0 . gifts AS gifts_56 , t0 . customer_authorisation AS customer_authorisation_57 , t0 . garage_type AS garage_type_58 , t0 . contractual_franchise AS contractual_franchise_59 , t0 . other_authorisation AS other_authorisation_60 , t0 . other_gifts AS other_gifts_61 , t0 . blocked AS blocked_62 , t0 . id_garage AS id_garage_63 , t0 . email_api AS email_api_64 , t0 . paid_date_day AS paid_date_day_65 , t0 . payment_method AS payment_method_66 , t0 . acquisition_source AS acquisition_source_67 , t0 . acquisition_source_detail AS acquisition_source_detail_68 , t0 . is_premium AS is_premium_69 , t0 . legal_form AS legal_form_70 , t0 . tax_regime AS tax_regime_71 , t0 . share_capital AS share_capital_72 , t0 . rcs AS rcs_73 , t0 . terms_and_conditions_file AS terms_and_conditions_file_74 , t0 . apply_terms_for_invoice AS apply_terms_for_invoice_75 , t0 . apply_terms_for_quote AS apply_terms_for_quote_76 , t0 . apply_terms_for_repair_order AS apply_terms_for_repair_order_77 , t0 . hubspot_id AS hubspot_id_78 , t0 . supplier_id AS supplier_id_79 , t0 . commercial_id AS commercial_id_80 , t0 . category_id AS category_id_81 , t0 . configuration_id AS configuration_id_82 , t0 . bridge_user_id AS bridge_user_id_83 , t0 . franchise_id AS franchise_id_84 , t0 . franchise_supplier_id AS franchise_supplier_id_85 , t86 . id AS id_87 , t86 . provider AS provider_88 , t86 . email AS email_89 , t86 . access_token AS access_token_90 , t86 . refresh_token AS refresh_token_91 , t86 . token_expires_at AS token_expires_at_92 , t86 . company_id AS company_id_93 FROM companie t0 LEFT JOIN email_credential t86 ON t86 . company_id = t0 . id WHERE t0 . id = 864 ;
Copy
3
7.31 ms
SELECT COUNT (m0_ . id ) AS sclr_0 FROM message m0_ LEFT JOIN folder f1_ ON m0_ . folder_id = f1_ . id WHERE m0_ . archived = ? AND m0_ . registered_recipient_id = ? AND f1_ . companie_id = ? AND m0_ . type = ?
Parameters :
[
0
637
864
"mercure "
]
SELECT COUNT (m0_ . id ) AS sclr_0 FROM message m0_ LEFT JOIN folder f1_ ON m0_ . folder_id = f1_ . id WHERE m0_ . archived = 0 AND m0_ . registered_recipient_id = 637 AND f1_ . companie_id = 864 AND m0_ . type = 'mercure' ;
Copy
4
4.13 ms
SELECT DISTINCT id_0 , MIN (sclr_18 ) AS dctrn_minrownum FROM (SELECT m0_ . id AS id_0 , m0_ . type AS type_1 , m0_ . recipient_email AS recipient_email_2 , m0_ . subject AS subject_3 , m0_ . content AS content_4 , m0_ . created_at AS created_at_5 , m0_ . notification_read AS notification_read_6 , m0_ . link AS link_7 , m0_ . archived AS archived_8 , m0_ . couriers_parent_number AS couriers_parent_number_9 , m0_ . type_folder AS type_folder_10 , m0_ . sms_count AS sms_count_11 , m0_ . external_id AS external_id_12 , m0_ . last_update AS last_update_13 , m0_ . sent_at AS sent_at_14 , m0_ . delivered_at AS delivered_at_15 , m0_ . opened_at AS opened_at_16 , m0_ . status AS status_17 , ROW_NUMBER () OVER (ORDER BY m0_ . created_at DESC ) AS sclr_18 FROM message m0_ INNER JOIN folder f1_ ON m0_ . folder_id = f1_ . id WHERE m0_ . archived = ? AND m0_ . registered_recipient_id = ? AND f1_ . companie_id = ? AND m0_ . type = ? ) dctrn_result GROUP BY id_0 ORDER BY dctrn_minrownum ASC LIMIT 10
Parameters :
[
0
637
864
"mercure "
]
SELECT DISTINCT id_0 , MIN (sclr_18 ) AS dctrn_minrownum FROM (SELECT m0_ . id AS id_0 , m0_ . type AS type_1 , m0_ . recipient_email AS recipient_email_2 , m0_ . subject AS subject_3 , m0_ . content AS content_4 , m0_ . created_at AS created_at_5 , m0_ . notification_read AS notification_read_6 , m0_ . link AS link_7 , m0_ . archived AS archived_8 , m0_ . couriers_parent_number AS couriers_parent_number_9 , m0_ . type_folder AS type_folder_10 , m0_ . sms_count AS sms_count_11 , m0_ . external_id AS external_id_12 , m0_ . last_update AS last_update_13 , m0_ . sent_at AS sent_at_14 , m0_ . delivered_at AS delivered_at_15 , m0_ . opened_at AS opened_at_16 , m0_ . status AS status_17 , ROW_NUMBER () OVER (ORDER BY m0_ . created_at DESC ) AS sclr_18 FROM message m0_ INNER JOIN folder f1_ ON m0_ . folder_id = f1_ . id WHERE m0_ . archived = 0 AND m0_ . registered_recipient_id = 637 AND f1_ . companie_id = 864 AND m0_ . type = 'mercure' ) dctrn_result GROUP BY id_0 ORDER BY dctrn_minrownum ASC LIMIT 10 ;
Copy
5
1.60 ms
SELECT m0_ . id AS id_0 , m0_ . type AS type_1 , m0_ . recipient_email AS recipient_email_2 , m0_ . subject AS subject_3 , m0_ . content AS content_4 , m0_ . created_at AS created_at_5 , m0_ . notification_read AS notification_read_6 , m0_ . link AS link_7 , m0_ . archived AS archived_8 , m0_ . couriers_parent_number AS couriers_parent_number_9 , m0_ . type_folder AS type_folder_10 , m0_ . sms_count AS sms_count_11 , m0_ . external_id AS external_id_12 , m0_ . last_update AS last_update_13 , m0_ . sent_at AS sent_at_14 , m0_ . delivered_at AS delivered_at_15 , m0_ . opened_at AS opened_at_16 , m0_ . status AS status_17 , m0_ . folder_id AS folder_id_18 , m0_ . recovery_id AS recovery_id_19 , m0_ . created_by_id AS created_by_id_20 , m0_ . registered_recipient_id AS registered_recipient_id_21 FROM message m0_ INNER JOIN folder f1_ ON m0_ . folder_id = f1_ . id WHERE m0_ . archived = ? AND m0_ . registered_recipient_id = ? AND f1_ . companie_id = ? AND m0_ . type = ? AND m0_ . id IN (? , ? , ? , ? , ? , ? , ? , ? , ? , ? ) ORDER BY m0_ . created_at DESC
Parameters :
[
0
637
864
"mercure "
159550
159545
159540
159534
159529
159524
159519
159512
159506
159500
]
SELECT m0_ . id AS id_0 , m0_ . type AS type_1 , m0_ . recipient_email AS recipient_email_2 , m0_ . subject AS subject_3 , m0_ . content AS content_4 , m0_ . created_at AS created_at_5 , m0_ . notification_read AS notification_read_6 , m0_ . link AS link_7 , m0_ . archived AS archived_8 , m0_ . couriers_parent_number AS couriers_parent_number_9 , m0_ . type_folder AS type_folder_10 , m0_ . sms_count AS sms_count_11 , m0_ . external_id AS external_id_12 , m0_ . last_update AS last_update_13 , m0_ . sent_at AS sent_at_14 , m0_ . delivered_at AS delivered_at_15 , m0_ . opened_at AS opened_at_16 , m0_ . status AS status_17 , m0_ . folder_id AS folder_id_18 , m0_ . recovery_id AS recovery_id_19 , m0_ . created_by_id AS created_by_id_20 , m0_ . registered_recipient_id AS registered_recipient_id_21 FROM message m0_ INNER JOIN folder f1_ ON m0_ . folder_id = f1_ . id WHERE m0_ . archived = 0 AND m0_ . registered_recipient_id = 637 AND f1_ . companie_id = 864 AND m0_ . type = 'mercure' AND m0_ . id IN (159550 , 159545 , 159540 , 159534 , 159529 , 159524 , 159519 , 159512 , 159506 , 159500 ) ORDER BY m0_ . created_at DESC ;
Copy
6
2.89 ms
SELECT t0 . id AS id_1 , t0 . registration AS registration_2 , t0 . registration_normalized AS registration_normalized_3 , t0 . vehicle_model AS vehicle_model_4 , t0 . insurance_name AS insurance_name_5 , t0 . appointment AS appointment_6 , t0 . appointment_end AS appointment_end_7 , t0 . status AS status_8 , t0 . windscreen AS windscreen_9 , t0 . insurance_card AS insurance_card_10 , t0 . vehicle_card AS vehicle_card_11 , t0 . created_at AS created_at_12 , t0 . professional AS professional_13 , t0 . tva_subject AS tva_subject_14 , t0 . sensor AS sensor_15 , t0 . athermal AS athermal_16 , t0 . camera AS camera_17 , t0 . glass AS glass_18 , t0 . sinister_date AS sinister_date_19 , t0 . declare_date AS declare_date_20 , t0 . sinister_reason AS sinister_reason_21 , t0 . sinister_circ AS sinister_circ_22 , t0 . sinister_location AS sinister_location_23 , t0 . travel_reason AS travel_reason_24 , t0 . invoice_due AS invoice_due_25 , t0 . deductible_amount AS deductible_amount_26 , t0 . verified_deductible AS verified_deductible_27 , t0 . insurance_number AS insurance_number_28 , t0 . cca AS cca_29 , t0 . procedure AS procedure_30 , t0 . signed AS signed_31 , t0 . signed_date AS signed_date_32 , t0 . file AS file_33 , t0 . known_by AS known_by_34 , t0 . gift AS gift_35 , t0 . adresse_pose AS adresse_pose_36 , t0 . task AS task_37 , t0 . updated_at AS updated_at_38 , t0 . relance_at AS relance_at_39 , t0 . is_paid AS is_paid_40 , t0 . sinister_number AS sinister_number_41 , t0 . is_assured AS is_assured_42 , t0 . is_send_folder AS is_send_folder_43 , t0 . is_send_invoice AS is_send_invoice_44 , t0 . cancellation_reason AS cancellation_reason_45 , t0 . cover AS cover_46 , t0 . status_command AS status_command_47 , t0 . ref AS ref_48 , t0 . ref_client AS ref_client_49 , t0 . km AS km_50 , t0 . member_client AS member_client_51 , t0 . member_garage AS member_garage_52 , t0 . is_gift_send AS is_gift_send_53 , t0 . status_updated AS status_updated_54 , t0 . pattern_cover AS pattern_cover_55 , t0 . judicial AS judicial_56 , t0 . relance_updated_at AS relance_updated_at_57 , t0 . relance_created_at AS relance_created_at_58 , t0 . relance_after_at AS relance_after_at_59 , t0 . sms_balance AS sms_balance_60 , t0 . brand AS brand_61 , t0 . mine_type AS mine_type_62 , t0 . serial_number AS serial_number_63 , t0 . wan_code AS wan_code_64 , t0 . audatex_code AS audatex_code_65 , t0 . euro_code AS euro_code_66 , t0 . vin_identified AS vin_identified_67 , t0 . sidexa_state AS sidexa_state_68 , t0 . sidexa_vehicle_model AS sidexa_vehicle_model_69 , t0 . data_updated AS data_updated_70 , t0 . category AS category_71 , t0 . department AS department_72 , t0 . complexity AS complexity_73 , t0 . repar AS repar_74 , t0 . marge AS marge_75 , t0 . appointment_update_reason AS appointment_update_reason_76 , t0 . closing_date AS closing_date_77 , t0 . planif_date AS planif_date_78 , t0 . gap AS gap_79 , t0 . offset_pose AS offset_pose_80 , t0 . duplicate AS duplicate_81 , t0 . couriers_parent_number AS couriers_parent_number_82 , t0 . state AS state_83 , t0 . quiz_sent_folder_submited AS quiz_sent_folder_submited_84 , t0 . prime_date AS prime_date_85 , t0 . insurance_card_added_at AS insurance_card_added_at_86 , t0 . vehicle_card_added_at AS vehicle_card_added_at_87 , t0 . windscreen_added_at AS windscreen_added_at_88 , t0 . last_agent_update_at AS last_agent_update_at_89 , t0 . openai_thread_id AS openai_thread_id_90 , t0 . vehicle_description AS vehicle_description_91 , t0 . has_partial_payment AS has_partial_payment_92 , t0 . paid_gap_amount AS paid_gap_amount_93 , t0 . gap_declarate_date AS gap_declarate_date_94 , t0 . hubspot_id AS hubspot_id_95 , t0 . ht_repair_order AS ht_repair_order_96 , t0 . task_verif_closed_date AS task_verif_closed_date_97 , t0 . first_signature_date AS first_signature_date_98 , t0 . companie_id AS companie_id_99 , t0 . customer_id AS customer_id_100 , t0 . gestionnaire_id AS gestionnaire_id_101 , t0 . created_by AS created_by_102 , t0 . updated_by AS updated_by_103 , t0 . technician_id AS technician_id_104 , t0 . service_client_id AS service_client_id_105 , t0 . agent_id AS agent_id_106 , t0 . relanceur_id AS relanceur_id_107 , t0 . recouvreur_id AS recouvreur_id_108 , t0 . status_folder_id AS status_folder_id_109 , t0 . insurance_name_new_id AS insurance_name_new_id_110 , t0 . recovery_id AS recovery_id_111 , t0 . known_id AS known_id_112 FROM folder t0 WHERE t0 . id = ?
SELECT
t0 . id AS id_1 ,
t0 . registration AS registration_2 ,
t0 . registration_normalized AS registration_normalized_3 ,
t0 . vehicle_model AS vehicle_model_4 ,
t0 . insurance_name AS insurance_name_5 ,
t0 . appointment AS appointment_6 ,
t0 . appointment_end AS appointment_end_7 ,
t0 . status AS status_8 ,
t0 . windscreen AS windscreen_9 ,
t0 . insurance_card AS insurance_card_10 ,
t0 . vehicle_card AS vehicle_card_11 ,
t0 . created_at AS created_at_12 ,
t0 . professional AS professional_13 ,
t0 . tva_subject AS tva_subject_14 ,
t0 . sensor AS sensor_15 ,
t0 . athermal AS athermal_16 ,
t0 . camera AS camera_17 ,
t0 . glass AS glass_18 ,
t0 . sinister_date AS sinister_date_19 ,
t0 . declare_date AS declare_date_20 ,
t0 . sinister_reason AS sinister_reason_21 ,
t0 . sinister_circ AS sinister_circ_22 ,
t0 . sinister_location AS sinister_location_23 ,
t0 . travel_reason AS travel_reason_24 ,
t0 . invoice_due AS invoice_due_25 ,
t0 . deductible_amount AS deductible_amount_26 ,
t0 . verified_deductible AS verified_deductible_27 ,
t0 . insurance_number AS insurance_number_28 ,
t0 . cca AS cca_29 ,
t0 . procedure AS procedure_30 ,
t0 . signed AS signed_31 ,
t0 . signed_date AS signed_date_32 ,
t0 . file AS file_33 ,
t0 . known_by AS known_by_34 ,
t0 . gift AS gift_35 ,
t0 . adresse_pose AS adresse_pose_36 ,
t0 . task AS task_37 ,
t0 . updated_at AS updated_at_38 ,
t0 . relance_at AS relance_at_39 ,
t0 . is_paid AS is_paid_40 ,
t0 . sinister_number AS sinister_number_41 ,
t0 . is_assured AS is_assured_42 ,
t0 . is_send_folder AS is_send_folder_43 ,
t0 . is_send_invoice AS is_send_invoice_44 ,
t0 . cancellation_reason AS cancellation_reason_45 ,
t0 . cover AS cover_46 ,
t0 . status_command AS status_command_47 ,
t0 . ref AS ref_48 ,
t0 . ref_client AS ref_client_49 ,
t0 . km AS km_50 ,
t0 . member_client AS member_client_51 ,
t0 . member_garage AS member_garage_52 ,
t0 . is_gift_send AS is_gift_send_53 ,
t0 . status_updated AS status_updated_54 ,
t0 . pattern_cover AS pattern_cover_55 ,
t0 . judicial AS judicial_56 ,
t0 . relance_updated_at AS relance_updated_at_57 ,
t0 . relance_created_at AS relance_created_at_58 ,
t0 . relance_after_at AS relance_after_at_59 ,
t0 . sms_balance AS sms_balance_60 ,
t0 . brand AS brand_61 ,
t0 . mine_type AS mine_type_62 ,
t0 . serial_number AS serial_number_63 ,
t0 . wan_code AS wan_code_64 ,
t0 . audatex_code AS audatex_code_65 ,
t0 . euro_code AS euro_code_66 ,
t0 . vin_identified AS vin_identified_67 ,
t0 . sidexa_state AS sidexa_state_68 ,
t0 . sidexa_vehicle_model AS sidexa_vehicle_model_69 ,
t0 . data_updated AS data_updated_70 ,
t0 . category AS category_71 ,
t0 . department AS department_72 ,
t0 . complexity AS complexity_73 ,
t0 . repar AS repar_74 ,
t0 . marge AS marge_75 ,
t0 . appointment_update_reason AS appointment_update_reason_76 ,
t0 . closing_date AS closing_date_77 ,
t0 . planif_date AS planif_date_78 ,
t0 . gap AS gap_79 ,
t0 . offset_pose AS offset_pose_80 ,
t0 . duplicate AS duplicate_81 ,
t0 . couriers_parent_number AS couriers_parent_number_82 ,
t0 . state AS state_83 ,
t0 . quiz_sent_folder_submited AS quiz_sent_folder_submited_84 ,
t0 . prime_date AS prime_date_85 ,
t0 . insurance_card_added_at AS insurance_card_added_at_86 ,
t0 . vehicle_card_added_at AS vehicle_card_added_at_87 ,
t0 . windscreen_added_at AS windscreen_added_at_88 ,
t0 . last_agent_update_at AS last_agent_update_at_89 ,
t0 . openai_thread_id AS openai_thread_id_90 ,
t0 . vehicle_description AS vehicle_description_91 ,
t0 . has_partial_payment AS has_partial_payment_92 ,
t0 . paid_gap_amount AS paid_gap_amount_93 ,
t0 . gap_declarate_date AS gap_declarate_date_94 ,
t0 . hubspot_id AS hubspot_id_95 ,
t0 . ht_repair_order AS ht_repair_order_96 ,
t0 . task_verif_closed_date AS task_verif_closed_date_97 ,
t0 . first_signature_date AS first_signature_date_98 ,
t0 . companie_id AS companie_id_99 ,
t0 . customer_id AS customer_id_100 ,
t0 . gestionnaire_id AS gestionnaire_id_101 ,
t0 . created_by AS created_by_102 ,
t0 . updated_by AS updated_by_103 ,
t0 . technician_id AS technician_id_104 ,
t0 . service_client_id AS service_client_id_105 ,
t0 . agent_id AS agent_id_106 ,
t0 . relanceur_id AS relanceur_id_107 ,
t0 . recouvreur_id AS recouvreur_id_108 ,
t0 . status_folder_id AS status_folder_id_109 ,
t0 . insurance_name_new_id AS insurance_name_new_id_110 ,
t0 . recovery_id AS recovery_id_111 ,
t0 . known_id AS known_id_112
FROM
folder t0
WHERE
t0 . id = ?
Copy
SELECT t0 . id AS id_1 , t0 . registration AS registration_2 , t0 . registration_normalized AS registration_normalized_3 , t0 . vehicle_model AS vehicle_model_4 , t0 . insurance_name AS insurance_name_5 , t0 . appointment AS appointment_6 , t0 . appointment_end AS appointment_end_7 , t0 . status AS status_8 , t0 . windscreen AS windscreen_9 , t0 . insurance_card AS insurance_card_10 , t0 . vehicle_card AS vehicle_card_11 , t0 . created_at AS created_at_12 , t0 . professional AS professional_13 , t0 . tva_subject AS tva_subject_14 , t0 . sensor AS sensor_15 , t0 . athermal AS athermal_16 , t0 . camera AS camera_17 , t0 . glass AS glass_18 , t0 . sinister_date AS sinister_date_19 , t0 . declare_date AS declare_date_20 , t0 . sinister_reason AS sinister_reason_21 , t0 . sinister_circ AS sinister_circ_22 , t0 . sinister_location AS sinister_location_23 , t0 . travel_reason AS travel_reason_24 , t0 . invoice_due AS invoice_due_25 , t0 . deductible_amount AS deductible_amount_26 , t0 . verified_deductible AS verified_deductible_27 , t0 . insurance_number AS insurance_number_28 , t0 . cca AS cca_29 , t0 . procedure AS procedure_30 , t0 . signed AS signed_31 , t0 . signed_date AS signed_date_32 , t0 . file AS file_33 , t0 . known_by AS known_by_34 , t0 . gift AS gift_35 , t0 . adresse_pose AS adresse_pose_36 , t0 . task AS task_37 , t0 . updated_at AS updated_at_38 , t0 . relance_at AS relance_at_39 , t0 . is_paid AS is_paid_40 , t0 . sinister_number AS sinister_number_41 , t0 . is_assured AS is_assured_42 , t0 . is_send_folder AS is_send_folder_43 , t0 . is_send_invoice AS is_send_invoice_44 , t0 . cancellation_reason AS cancellation_reason_45 , t0 . cover AS cover_46 , t0 . status_command AS status_command_47 , t0 . ref AS ref_48 , t0 . ref_client AS ref_client_49 , t0 . km AS km_50 , t0 . member_client AS member_client_51 , t0 . member_garage AS member_garage_52 , t0 . is_gift_send AS is_gift_send_53 , t0 . status_updated AS status_updated_54 , t0 . pattern_cover AS pattern_cover_55 , t0 . judicial AS judicial_56 , t0 . relance_updated_at AS relance_updated_at_57 , t0 . relance_created_at AS relance_created_at_58 , t0 . relance_after_at AS relance_after_at_59 , t0 . sms_balance AS sms_balance_60 , t0 . brand AS brand_61 , t0 . mine_type AS mine_type_62 , t0 . serial_number AS serial_number_63 , t0 . wan_code AS wan_code_64 , t0 . audatex_code AS audatex_code_65 , t0 . euro_code AS euro_code_66 , t0 . vin_identified AS vin_identified_67 , t0 . sidexa_state AS sidexa_state_68 , t0 . sidexa_vehicle_model AS sidexa_vehicle_model_69 , t0 . data_updated AS data_updated_70 , t0 . category AS category_71 , t0 . department AS department_72 , t0 . complexity AS complexity_73 , t0 . repar AS repar_74 , t0 . marge AS marge_75 , t0 . appointment_update_reason AS appointment_update_reason_76 , t0 . closing_date AS closing_date_77 , t0 . planif_date AS planif_date_78 , t0 . gap AS gap_79 , t0 . offset_pose AS offset_pose_80 , t0 . duplicate AS duplicate_81 , t0 . couriers_parent_number AS couriers_parent_number_82 , t0 . state AS state_83 , t0 . quiz_sent_folder_submited AS quiz_sent_folder_submited_84 , t0 . prime_date AS prime_date_85 , t0 . insurance_card_added_at AS insurance_card_added_at_86 , t0 . vehicle_card_added_at AS vehicle_card_added_at_87 , t0 . windscreen_added_at AS windscreen_added_at_88 , t0 . last_agent_update_at AS last_agent_update_at_89 , t0 . openai_thread_id AS openai_thread_id_90 , t0 . vehicle_description AS vehicle_description_91 , t0 . has_partial_payment AS has_partial_payment_92 , t0 . paid_gap_amount AS paid_gap_amount_93 , t0 . gap_declarate_date AS gap_declarate_date_94 , t0 . hubspot_id AS hubspot_id_95 , t0 . ht_repair_order AS ht_repair_order_96 , t0 . task_verif_closed_date AS task_verif_closed_date_97 , t0 . first_signature_date AS first_signature_date_98 , t0 . companie_id AS companie_id_99 , t0 . customer_id AS customer_id_100 , t0 . gestionnaire_id AS gestionnaire_id_101 , t0 . created_by AS created_by_102 , t0 . updated_by AS updated_by_103 , t0 . technician_id AS technician_id_104 , t0 . service_client_id AS service_client_id_105 , t0 . agent_id AS agent_id_106 , t0 . relanceur_id AS relanceur_id_107 , t0 . recouvreur_id AS recouvreur_id_108 , t0 . status_folder_id AS status_folder_id_109 , t0 . insurance_name_new_id AS insurance_name_new_id_110 , t0 . recovery_id AS recovery_id_111 , t0 . known_id AS known_id_112 FROM folder t0 WHERE t0 . id = 20451 ;
Copy
7
1.40 ms
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . firstname AS firstname_3 , t0 . email AS email_4 , t0 . address AS address_5 , t0 . phone AS phone_6 , t0 . postal_code AS postal_code_7 , t0 . town AS town_8 , t0 . siret AS siret_9 , t0 . rcs AS rcs_10 , t0 . tva_number AS tva_number_11 , t0 . derogation_regime AS derogation_regime_12 , t0 . is_professional AS is_professional_13 , t0 . is_tva_subject AS is_tva_subject_14 FROM customer t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . firstname AS firstname_3 , t0 . email AS email_4 , t0 . address AS address_5 , t0 . phone AS phone_6 , t0 . postal_code AS postal_code_7 , t0 . town AS town_8 , t0 . siret AS siret_9 , t0 . rcs AS rcs_10 , t0 . tva_number AS tva_number_11 , t0 . derogation_regime AS derogation_regime_12 , t0 . is_professional AS is_professional_13 , t0 . is_tva_subject AS is_tva_subject_14 FROM customer t0 WHERE t0 . id = 23288 ;
Copy
8
1.02 ms
SELECT t0 . id AS id_1 , t0 . registration AS registration_2 , t0 . registration_normalized AS registration_normalized_3 , t0 . vehicle_model AS vehicle_model_4 , t0 . insurance_name AS insurance_name_5 , t0 . appointment AS appointment_6 , t0 . appointment_end AS appointment_end_7 , t0 . status AS status_8 , t0 . windscreen AS windscreen_9 , t0 . insurance_card AS insurance_card_10 , t0 . vehicle_card AS vehicle_card_11 , t0 . created_at AS created_at_12 , t0 . professional AS professional_13 , t0 . tva_subject AS tva_subject_14 , t0 . sensor AS sensor_15 , t0 . athermal AS athermal_16 , t0 . camera AS camera_17 , t0 . glass AS glass_18 , t0 . sinister_date AS sinister_date_19 , t0 . declare_date AS declare_date_20 , t0 . sinister_reason AS sinister_reason_21 , t0 . sinister_circ AS sinister_circ_22 , t0 . sinister_location AS sinister_location_23 , t0 . travel_reason AS travel_reason_24 , t0 . invoice_due AS invoice_due_25 , t0 . deductible_amount AS deductible_amount_26 , t0 . verified_deductible AS verified_deductible_27 , t0 . insurance_number AS insurance_number_28 , t0 . cca AS cca_29 , t0 . procedure AS procedure_30 , t0 . signed AS signed_31 , t0 . signed_date AS signed_date_32 , t0 . file AS file_33 , t0 . known_by AS known_by_34 , t0 . gift AS gift_35 , t0 . adresse_pose AS adresse_pose_36 , t0 . task AS task_37 , t0 . updated_at AS updated_at_38 , t0 . relance_at AS relance_at_39 , t0 . is_paid AS is_paid_40 , t0 . sinister_number AS sinister_number_41 , t0 . is_assured AS is_assured_42 , t0 . is_send_folder AS is_send_folder_43 , t0 . is_send_invoice AS is_send_invoice_44 , t0 . cancellation_reason AS cancellation_reason_45 , t0 . cover AS cover_46 , t0 . status_command AS status_command_47 , t0 . ref AS ref_48 , t0 . ref_client AS ref_client_49 , t0 . km AS km_50 , t0 . member_client AS member_client_51 , t0 . member_garage AS member_garage_52 , t0 . is_gift_send AS is_gift_send_53 , t0 . status_updated AS status_updated_54 , t0 . pattern_cover AS pattern_cover_55 , t0 . judicial AS judicial_56 , t0 . relance_updated_at AS relance_updated_at_57 , t0 . relance_created_at AS relance_created_at_58 , t0 . relance_after_at AS relance_after_at_59 , t0 . sms_balance AS sms_balance_60 , t0 . brand AS brand_61 , t0 . mine_type AS mine_type_62 , t0 . serial_number AS serial_number_63 , t0 . wan_code AS wan_code_64 , t0 . audatex_code AS audatex_code_65 , t0 . euro_code AS euro_code_66 , t0 . vin_identified AS vin_identified_67 , t0 . sidexa_state AS sidexa_state_68 , t0 . sidexa_vehicle_model AS sidexa_vehicle_model_69 , t0 . data_updated AS data_updated_70 , t0 . category AS category_71 , t0 . department AS department_72 , t0 . complexity AS complexity_73 , t0 . repar AS repar_74 , t0 . marge AS marge_75 , t0 . appointment_update_reason AS appointment_update_reason_76 , t0 . closing_date AS closing_date_77 , t0 . planif_date AS planif_date_78 , t0 . gap AS gap_79 , t0 . offset_pose AS offset_pose_80 , t0 . duplicate AS duplicate_81 , t0 . couriers_parent_number AS couriers_parent_number_82 , t0 . state AS state_83 , t0 . quiz_sent_folder_submited AS quiz_sent_folder_submited_84 , t0 . prime_date AS prime_date_85 , t0 . insurance_card_added_at AS insurance_card_added_at_86 , t0 . vehicle_card_added_at AS vehicle_card_added_at_87 , t0 . windscreen_added_at AS windscreen_added_at_88 , t0 . last_agent_update_at AS last_agent_update_at_89 , t0 . openai_thread_id AS openai_thread_id_90 , t0 . vehicle_description AS vehicle_description_91 , t0 . has_partial_payment AS has_partial_payment_92 , t0 . paid_gap_amount AS paid_gap_amount_93 , t0 . gap_declarate_date AS gap_declarate_date_94 , t0 . hubspot_id AS hubspot_id_95 , t0 . ht_repair_order AS ht_repair_order_96 , t0 . task_verif_closed_date AS task_verif_closed_date_97 , t0 . first_signature_date AS first_signature_date_98 , t0 . companie_id AS companie_id_99 , t0 . customer_id AS customer_id_100 , t0 . gestionnaire_id AS gestionnaire_id_101 , t0 . created_by AS created_by_102 , t0 . updated_by AS updated_by_103 , t0 . technician_id AS technician_id_104 , t0 . service_client_id AS service_client_id_105 , t0 . agent_id AS agent_id_106 , t0 . relanceur_id AS relanceur_id_107 , t0 . recouvreur_id AS recouvreur_id_108 , t0 . status_folder_id AS status_folder_id_109 , t0 . insurance_name_new_id AS insurance_name_new_id_110 , t0 . recovery_id AS recovery_id_111 , t0 . known_id AS known_id_112 FROM folder t0 WHERE t0 . id = ?
SELECT
t0 . id AS id_1 ,
t0 . registration AS registration_2 ,
t0 . registration_normalized AS registration_normalized_3 ,
t0 . vehicle_model AS vehicle_model_4 ,
t0 . insurance_name AS insurance_name_5 ,
t0 . appointment AS appointment_6 ,
t0 . appointment_end AS appointment_end_7 ,
t0 . status AS status_8 ,
t0 . windscreen AS windscreen_9 ,
t0 . insurance_card AS insurance_card_10 ,
t0 . vehicle_card AS vehicle_card_11 ,
t0 . created_at AS created_at_12 ,
t0 . professional AS professional_13 ,
t0 . tva_subject AS tva_subject_14 ,
t0 . sensor AS sensor_15 ,
t0 . athermal AS athermal_16 ,
t0 . camera AS camera_17 ,
t0 . glass AS glass_18 ,
t0 . sinister_date AS sinister_date_19 ,
t0 . declare_date AS declare_date_20 ,
t0 . sinister_reason AS sinister_reason_21 ,
t0 . sinister_circ AS sinister_circ_22 ,
t0 . sinister_location AS sinister_location_23 ,
t0 . travel_reason AS travel_reason_24 ,
t0 . invoice_due AS invoice_due_25 ,
t0 . deductible_amount AS deductible_amount_26 ,
t0 . verified_deductible AS verified_deductible_27 ,
t0 . insurance_number AS insurance_number_28 ,
t0 . cca AS cca_29 ,
t0 . procedure AS procedure_30 ,
t0 . signed AS signed_31 ,
t0 . signed_date AS signed_date_32 ,
t0 . file AS file_33 ,
t0 . known_by AS known_by_34 ,
t0 . gift AS gift_35 ,
t0 . adresse_pose AS adresse_pose_36 ,
t0 . task AS task_37 ,
t0 . updated_at AS updated_at_38 ,
t0 . relance_at AS relance_at_39 ,
t0 . is_paid AS is_paid_40 ,
t0 . sinister_number AS sinister_number_41 ,
t0 . is_assured AS is_assured_42 ,
t0 . is_send_folder AS is_send_folder_43 ,
t0 . is_send_invoice AS is_send_invoice_44 ,
t0 . cancellation_reason AS cancellation_reason_45 ,
t0 . cover AS cover_46 ,
t0 . status_command AS status_command_47 ,
t0 . ref AS ref_48 ,
t0 . ref_client AS ref_client_49 ,
t0 . km AS km_50 ,
t0 . member_client AS member_client_51 ,
t0 . member_garage AS member_garage_52 ,
t0 . is_gift_send AS is_gift_send_53 ,
t0 . status_updated AS status_updated_54 ,
t0 . pattern_cover AS pattern_cover_55 ,
t0 . judicial AS judicial_56 ,
t0 . relance_updated_at AS relance_updated_at_57 ,
t0 . relance_created_at AS relance_created_at_58 ,
t0 . relance_after_at AS relance_after_at_59 ,
t0 . sms_balance AS sms_balance_60 ,
t0 . brand AS brand_61 ,
t0 . mine_type AS mine_type_62 ,
t0 . serial_number AS serial_number_63 ,
t0 . wan_code AS wan_code_64 ,
t0 . audatex_code AS audatex_code_65 ,
t0 . euro_code AS euro_code_66 ,
t0 . vin_identified AS vin_identified_67 ,
t0 . sidexa_state AS sidexa_state_68 ,
t0 . sidexa_vehicle_model AS sidexa_vehicle_model_69 ,
t0 . data_updated AS data_updated_70 ,
t0 . category AS category_71 ,
t0 . department AS department_72 ,
t0 . complexity AS complexity_73 ,
t0 . repar AS repar_74 ,
t0 . marge AS marge_75 ,
t0 . appointment_update_reason AS appointment_update_reason_76 ,
t0 . closing_date AS closing_date_77 ,
t0 . planif_date AS planif_date_78 ,
t0 . gap AS gap_79 ,
t0 . offset_pose AS offset_pose_80 ,
t0 . duplicate AS duplicate_81 ,
t0 . couriers_parent_number AS couriers_parent_number_82 ,
t0 . state AS state_83 ,
t0 . quiz_sent_folder_submited AS quiz_sent_folder_submited_84 ,
t0 . prime_date AS prime_date_85 ,
t0 . insurance_card_added_at AS insurance_card_added_at_86 ,
t0 . vehicle_card_added_at AS vehicle_card_added_at_87 ,
t0 . windscreen_added_at AS windscreen_added_at_88 ,
t0 . last_agent_update_at AS last_agent_update_at_89 ,
t0 . openai_thread_id AS openai_thread_id_90 ,
t0 . vehicle_description AS vehicle_description_91 ,
t0 . has_partial_payment AS has_partial_payment_92 ,
t0 . paid_gap_amount AS paid_gap_amount_93 ,
t0 . gap_declarate_date AS gap_declarate_date_94 ,
t0 . hubspot_id AS hubspot_id_95 ,
t0 . ht_repair_order AS ht_repair_order_96 ,
t0 . task_verif_closed_date AS task_verif_closed_date_97 ,
t0 . first_signature_date AS first_signature_date_98 ,
t0 . companie_id AS companie_id_99 ,
t0 . customer_id AS customer_id_100 ,
t0 . gestionnaire_id AS gestionnaire_id_101 ,
t0 . created_by AS created_by_102 ,
t0 . updated_by AS updated_by_103 ,
t0 . technician_id AS technician_id_104 ,
t0 . service_client_id AS service_client_id_105 ,
t0 . agent_id AS agent_id_106 ,
t0 . relanceur_id AS relanceur_id_107 ,
t0 . recouvreur_id AS recouvreur_id_108 ,
t0 . status_folder_id AS status_folder_id_109 ,
t0 . insurance_name_new_id AS insurance_name_new_id_110 ,
t0 . recovery_id AS recovery_id_111 ,
t0 . known_id AS known_id_112
FROM
folder t0
WHERE
t0 . id = ?
Copy
SELECT t0 . id AS id_1 , t0 . registration AS registration_2 , t0 . registration_normalized AS registration_normalized_3 , t0 . vehicle_model AS vehicle_model_4 , t0 . insurance_name AS insurance_name_5 , t0 . appointment AS appointment_6 , t0 . appointment_end AS appointment_end_7 , t0 . status AS status_8 , t0 . windscreen AS windscreen_9 , t0 . insurance_card AS insurance_card_10 , t0 . vehicle_card AS vehicle_card_11 , t0 . created_at AS created_at_12 , t0 . professional AS professional_13 , t0 . tva_subject AS tva_subject_14 , t0 . sensor AS sensor_15 , t0 . athermal AS athermal_16 , t0 . camera AS camera_17 , t0 . glass AS glass_18 , t0 . sinister_date AS sinister_date_19 , t0 . declare_date AS declare_date_20 , t0 . sinister_reason AS sinister_reason_21 , t0 . sinister_circ AS sinister_circ_22 , t0 . sinister_location AS sinister_location_23 , t0 . travel_reason AS travel_reason_24 , t0 . invoice_due AS invoice_due_25 , t0 . deductible_amount AS deductible_amount_26 , t0 . verified_deductible AS verified_deductible_27 , t0 . insurance_number AS insurance_number_28 , t0 . cca AS cca_29 , t0 . procedure AS procedure_30 , t0 . signed AS signed_31 , t0 . signed_date AS signed_date_32 , t0 . file AS file_33 , t0 . known_by AS known_by_34 , t0 . gift AS gift_35 , t0 . adresse_pose AS adresse_pose_36 , t0 . task AS task_37 , t0 . updated_at AS updated_at_38 , t0 . relance_at AS relance_at_39 , t0 . is_paid AS is_paid_40 , t0 . sinister_number AS sinister_number_41 , t0 . is_assured AS is_assured_42 , t0 . is_send_folder AS is_send_folder_43 , t0 . is_send_invoice AS is_send_invoice_44 , t0 . cancellation_reason AS cancellation_reason_45 , t0 . cover AS cover_46 , t0 . status_command AS status_command_47 , t0 . ref AS ref_48 , t0 . ref_client AS ref_client_49 , t0 . km AS km_50 , t0 . member_client AS member_client_51 , t0 . member_garage AS member_garage_52 , t0 . is_gift_send AS is_gift_send_53 , t0 . status_updated AS status_updated_54 , t0 . pattern_cover AS pattern_cover_55 , t0 . judicial AS judicial_56 , t0 . relance_updated_at AS relance_updated_at_57 , t0 . relance_created_at AS relance_created_at_58 , t0 . relance_after_at AS relance_after_at_59 , t0 . sms_balance AS sms_balance_60 , t0 . brand AS brand_61 , t0 . mine_type AS mine_type_62 , t0 . serial_number AS serial_number_63 , t0 . wan_code AS wan_code_64 , t0 . audatex_code AS audatex_code_65 , t0 . euro_code AS euro_code_66 , t0 . vin_identified AS vin_identified_67 , t0 . sidexa_state AS sidexa_state_68 , t0 . sidexa_vehicle_model AS sidexa_vehicle_model_69 , t0 . data_updated AS data_updated_70 , t0 . category AS category_71 , t0 . department AS department_72 , t0 . complexity AS complexity_73 , t0 . repar AS repar_74 , t0 . marge AS marge_75 , t0 . appointment_update_reason AS appointment_update_reason_76 , t0 . closing_date AS closing_date_77 , t0 . planif_date AS planif_date_78 , t0 . gap AS gap_79 , t0 . offset_pose AS offset_pose_80 , t0 . duplicate AS duplicate_81 , t0 . couriers_parent_number AS couriers_parent_number_82 , t0 . state AS state_83 , t0 . quiz_sent_folder_submited AS quiz_sent_folder_submited_84 , t0 . prime_date AS prime_date_85 , t0 . insurance_card_added_at AS insurance_card_added_at_86 , t0 . vehicle_card_added_at AS vehicle_card_added_at_87 , t0 . windscreen_added_at AS windscreen_added_at_88 , t0 . last_agent_update_at AS last_agent_update_at_89 , t0 . openai_thread_id AS openai_thread_id_90 , t0 . vehicle_description AS vehicle_description_91 , t0 . has_partial_payment AS has_partial_payment_92 , t0 . paid_gap_amount AS paid_gap_amount_93 , t0 . gap_declarate_date AS gap_declarate_date_94 , t0 . hubspot_id AS hubspot_id_95 , t0 . ht_repair_order AS ht_repair_order_96 , t0 . task_verif_closed_date AS task_verif_closed_date_97 , t0 . first_signature_date AS first_signature_date_98 , t0 . companie_id AS companie_id_99 , t0 . customer_id AS customer_id_100 , t0 . gestionnaire_id AS gestionnaire_id_101 , t0 . created_by AS created_by_102 , t0 . updated_by AS updated_by_103 , t0 . technician_id AS technician_id_104 , t0 . service_client_id AS service_client_id_105 , t0 . agent_id AS agent_id_106 , t0 . relanceur_id AS relanceur_id_107 , t0 . recouvreur_id AS recouvreur_id_108 , t0 . status_folder_id AS status_folder_id_109 , t0 . insurance_name_new_id AS insurance_name_new_id_110 , t0 . recovery_id AS recovery_id_111 , t0 . known_id AS known_id_112 FROM folder t0 WHERE t0 . id = 20434 ;
Copy
9
0.54 ms
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . firstname AS firstname_3 , t0 . email AS email_4 , t0 . address AS address_5 , t0 . phone AS phone_6 , t0 . postal_code AS postal_code_7 , t0 . town AS town_8 , t0 . siret AS siret_9 , t0 . rcs AS rcs_10 , t0 . tva_number AS tva_number_11 , t0 . derogation_regime AS derogation_regime_12 , t0 . is_professional AS is_professional_13 , t0 . is_tva_subject AS is_tva_subject_14 FROM customer t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . firstname AS firstname_3 , t0 . email AS email_4 , t0 . address AS address_5 , t0 . phone AS phone_6 , t0 . postal_code AS postal_code_7 , t0 . town AS town_8 , t0 . siret AS siret_9 , t0 . rcs AS rcs_10 , t0 . tva_number AS tva_number_11 , t0 . derogation_regime AS derogation_regime_12 , t0 . is_professional AS is_professional_13 , t0 . is_tva_subject AS is_tva_subject_14 FROM customer t0 WHERE t0 . id = 23271 ;
Copy
10
0.99 ms
SELECT t0 . id AS id_1 , t0 . registration AS registration_2 , t0 . registration_normalized AS registration_normalized_3 , t0 . vehicle_model AS vehicle_model_4 , t0 . insurance_name AS insurance_name_5 , t0 . appointment AS appointment_6 , t0 . appointment_end AS appointment_end_7 , t0 . status AS status_8 , t0 . windscreen AS windscreen_9 , t0 . insurance_card AS insurance_card_10 , t0 . vehicle_card AS vehicle_card_11 , t0 . created_at AS created_at_12 , t0 . professional AS professional_13 , t0 . tva_subject AS tva_subject_14 , t0 . sensor AS sensor_15 , t0 . athermal AS athermal_16 , t0 . camera AS camera_17 , t0 . glass AS glass_18 , t0 . sinister_date AS sinister_date_19 , t0 . declare_date AS declare_date_20 , t0 . sinister_reason AS sinister_reason_21 , t0 . sinister_circ AS sinister_circ_22 , t0 . sinister_location AS sinister_location_23 , t0 . travel_reason AS travel_reason_24 , t0 . invoice_due AS invoice_due_25 , t0 . deductible_amount AS deductible_amount_26 , t0 . verified_deductible AS verified_deductible_27 , t0 . insurance_number AS insurance_number_28 , t0 . cca AS cca_29 , t0 . procedure AS procedure_30 , t0 . signed AS signed_31 , t0 . signed_date AS signed_date_32 , t0 . file AS file_33 , t0 . known_by AS known_by_34 , t0 . gift AS gift_35 , t0 . adresse_pose AS adresse_pose_36 , t0 . task AS task_37 , t0 . updated_at AS updated_at_38 , t0 . relance_at AS relance_at_39 , t0 . is_paid AS is_paid_40 , t0 . sinister_number AS sinister_number_41 , t0 . is_assured AS is_assured_42 , t0 . is_send_folder AS is_send_folder_43 , t0 . is_send_invoice AS is_send_invoice_44 , t0 . cancellation_reason AS cancellation_reason_45 , t0 . cover AS cover_46 , t0 . status_command AS status_command_47 , t0 . ref AS ref_48 , t0 . ref_client AS ref_client_49 , t0 . km AS km_50 , t0 . member_client AS member_client_51 , t0 . member_garage AS member_garage_52 , t0 . is_gift_send AS is_gift_send_53 , t0 . status_updated AS status_updated_54 , t0 . pattern_cover AS pattern_cover_55 , t0 . judicial AS judicial_56 , t0 . relance_updated_at AS relance_updated_at_57 , t0 . relance_created_at AS relance_created_at_58 , t0 . relance_after_at AS relance_after_at_59 , t0 . sms_balance AS sms_balance_60 , t0 . brand AS brand_61 , t0 . mine_type AS mine_type_62 , t0 . serial_number AS serial_number_63 , t0 . wan_code AS wan_code_64 , t0 . audatex_code AS audatex_code_65 , t0 . euro_code AS euro_code_66 , t0 . vin_identified AS vin_identified_67 , t0 . sidexa_state AS sidexa_state_68 , t0 . sidexa_vehicle_model AS sidexa_vehicle_model_69 , t0 . data_updated AS data_updated_70 , t0 . category AS category_71 , t0 . department AS department_72 , t0 . complexity AS complexity_73 , t0 . repar AS repar_74 , t0 . marge AS marge_75 , t0 . appointment_update_reason AS appointment_update_reason_76 , t0 . closing_date AS closing_date_77 , t0 . planif_date AS planif_date_78 , t0 . gap AS gap_79 , t0 . offset_pose AS offset_pose_80 , t0 . duplicate AS duplicate_81 , t0 . couriers_parent_number AS couriers_parent_number_82 , t0 . state AS state_83 , t0 . quiz_sent_folder_submited AS quiz_sent_folder_submited_84 , t0 . prime_date AS prime_date_85 , t0 . insurance_card_added_at AS insurance_card_added_at_86 , t0 . vehicle_card_added_at AS vehicle_card_added_at_87 , t0 . windscreen_added_at AS windscreen_added_at_88 , t0 . last_agent_update_at AS last_agent_update_at_89 , t0 . openai_thread_id AS openai_thread_id_90 , t0 . vehicle_description AS vehicle_description_91 , t0 . has_partial_payment AS has_partial_payment_92 , t0 . paid_gap_amount AS paid_gap_amount_93 , t0 . gap_declarate_date AS gap_declarate_date_94 , t0 . hubspot_id AS hubspot_id_95 , t0 . ht_repair_order AS ht_repair_order_96 , t0 . task_verif_closed_date AS task_verif_closed_date_97 , t0 . first_signature_date AS first_signature_date_98 , t0 . companie_id AS companie_id_99 , t0 . customer_id AS customer_id_100 , t0 . gestionnaire_id AS gestionnaire_id_101 , t0 . created_by AS created_by_102 , t0 . updated_by AS updated_by_103 , t0 . technician_id AS technician_id_104 , t0 . service_client_id AS service_client_id_105 , t0 . agent_id AS agent_id_106 , t0 . relanceur_id AS relanceur_id_107 , t0 . recouvreur_id AS recouvreur_id_108 , t0 . status_folder_id AS status_folder_id_109 , t0 . insurance_name_new_id AS insurance_name_new_id_110 , t0 . recovery_id AS recovery_id_111 , t0 . known_id AS known_id_112 FROM folder t0 WHERE t0 . id = ?
SELECT
t0 . id AS id_1 ,
t0 . registration AS registration_2 ,
t0 . registration_normalized AS registration_normalized_3 ,
t0 . vehicle_model AS vehicle_model_4 ,
t0 . insurance_name AS insurance_name_5 ,
t0 . appointment AS appointment_6 ,
t0 . appointment_end AS appointment_end_7 ,
t0 . status AS status_8 ,
t0 . windscreen AS windscreen_9 ,
t0 . insurance_card AS insurance_card_10 ,
t0 . vehicle_card AS vehicle_card_11 ,
t0 . created_at AS created_at_12 ,
t0 . professional AS professional_13 ,
t0 . tva_subject AS tva_subject_14 ,
t0 . sensor AS sensor_15 ,
t0 . athermal AS athermal_16 ,
t0 . camera AS camera_17 ,
t0 . glass AS glass_18 ,
t0 . sinister_date AS sinister_date_19 ,
t0 . declare_date AS declare_date_20 ,
t0 . sinister_reason AS sinister_reason_21 ,
t0 . sinister_circ AS sinister_circ_22 ,
t0 . sinister_location AS sinister_location_23 ,
t0 . travel_reason AS travel_reason_24 ,
t0 . invoice_due AS invoice_due_25 ,
t0 . deductible_amount AS deductible_amount_26 ,
t0 . verified_deductible AS verified_deductible_27 ,
t0 . insurance_number AS insurance_number_28 ,
t0 . cca AS cca_29 ,
t0 . procedure AS procedure_30 ,
t0 . signed AS signed_31 ,
t0 . signed_date AS signed_date_32 ,
t0 . file AS file_33 ,
t0 . known_by AS known_by_34 ,
t0 . gift AS gift_35 ,
t0 . adresse_pose AS adresse_pose_36 ,
t0 . task AS task_37 ,
t0 . updated_at AS updated_at_38 ,
t0 . relance_at AS relance_at_39 ,
t0 . is_paid AS is_paid_40 ,
t0 . sinister_number AS sinister_number_41 ,
t0 . is_assured AS is_assured_42 ,
t0 . is_send_folder AS is_send_folder_43 ,
t0 . is_send_invoice AS is_send_invoice_44 ,
t0 . cancellation_reason AS cancellation_reason_45 ,
t0 . cover AS cover_46 ,
t0 . status_command AS status_command_47 ,
t0 . ref AS ref_48 ,
t0 . ref_client AS ref_client_49 ,
t0 . km AS km_50 ,
t0 . member_client AS member_client_51 ,
t0 . member_garage AS member_garage_52 ,
t0 . is_gift_send AS is_gift_send_53 ,
t0 . status_updated AS status_updated_54 ,
t0 . pattern_cover AS pattern_cover_55 ,
t0 . judicial AS judicial_56 ,
t0 . relance_updated_at AS relance_updated_at_57 ,
t0 . relance_created_at AS relance_created_at_58 ,
t0 . relance_after_at AS relance_after_at_59 ,
t0 . sms_balance AS sms_balance_60 ,
t0 . brand AS brand_61 ,
t0 . mine_type AS mine_type_62 ,
t0 . serial_number AS serial_number_63 ,
t0 . wan_code AS wan_code_64 ,
t0 . audatex_code AS audatex_code_65 ,
t0 . euro_code AS euro_code_66 ,
t0 . vin_identified AS vin_identified_67 ,
t0 . sidexa_state AS sidexa_state_68 ,
t0 . sidexa_vehicle_model AS sidexa_vehicle_model_69 ,
t0 . data_updated AS data_updated_70 ,
t0 . category AS category_71 ,
t0 . department AS department_72 ,
t0 . complexity AS complexity_73 ,
t0 . repar AS repar_74 ,
t0 . marge AS marge_75 ,
t0 . appointment_update_reason AS appointment_update_reason_76 ,
t0 . closing_date AS closing_date_77 ,
t0 . planif_date AS planif_date_78 ,
t0 . gap AS gap_79 ,
t0 . offset_pose AS offset_pose_80 ,
t0 . duplicate AS duplicate_81 ,
t0 . couriers_parent_number AS couriers_parent_number_82 ,
t0 . state AS state_83 ,
t0 . quiz_sent_folder_submited AS quiz_sent_folder_submited_84 ,
t0 . prime_date AS prime_date_85 ,
t0 . insurance_card_added_at AS insurance_card_added_at_86 ,
t0 . vehicle_card_added_at AS vehicle_card_added_at_87 ,
t0 . windscreen_added_at AS windscreen_added_at_88 ,
t0 . last_agent_update_at AS last_agent_update_at_89 ,
t0 . openai_thread_id AS openai_thread_id_90 ,
t0 . vehicle_description AS vehicle_description_91 ,
t0 . has_partial_payment AS has_partial_payment_92 ,
t0 . paid_gap_amount AS paid_gap_amount_93 ,
t0 . gap_declarate_date AS gap_declarate_date_94 ,
t0 . hubspot_id AS hubspot_id_95 ,
t0 . ht_repair_order AS ht_repair_order_96 ,
t0 . task_verif_closed_date AS task_verif_closed_date_97 ,
t0 . first_signature_date AS first_signature_date_98 ,
t0 . companie_id AS companie_id_99 ,
t0 . customer_id AS customer_id_100 ,
t0 . gestionnaire_id AS gestionnaire_id_101 ,
t0 . created_by AS created_by_102 ,
t0 . updated_by AS updated_by_103 ,
t0 . technician_id AS technician_id_104 ,
t0 . service_client_id AS service_client_id_105 ,
t0 . agent_id AS agent_id_106 ,
t0 . relanceur_id AS relanceur_id_107 ,
t0 . recouvreur_id AS recouvreur_id_108 ,
t0 . status_folder_id AS status_folder_id_109 ,
t0 . insurance_name_new_id AS insurance_name_new_id_110 ,
t0 . recovery_id AS recovery_id_111 ,
t0 . known_id AS known_id_112
FROM
folder t0
WHERE
t0 . id = ?
Copy
SELECT t0 . id AS id_1 , t0 . registration AS registration_2 , t0 . registration_normalized AS registration_normalized_3 , t0 . vehicle_model AS vehicle_model_4 , t0 . insurance_name AS insurance_name_5 , t0 . appointment AS appointment_6 , t0 . appointment_end AS appointment_end_7 , t0 . status AS status_8 , t0 . windscreen AS windscreen_9 , t0 . insurance_card AS insurance_card_10 , t0 . vehicle_card AS vehicle_card_11 , t0 . created_at AS created_at_12 , t0 . professional AS professional_13 , t0 . tva_subject AS tva_subject_14 , t0 . sensor AS sensor_15 , t0 . athermal AS athermal_16 , t0 . camera AS camera_17 , t0 . glass AS glass_18 , t0 . sinister_date AS sinister_date_19 , t0 . declare_date AS declare_date_20 , t0 . sinister_reason AS sinister_reason_21 , t0 . sinister_circ AS sinister_circ_22 , t0 . sinister_location AS sinister_location_23 , t0 . travel_reason AS travel_reason_24 , t0 . invoice_due AS invoice_due_25 , t0 . deductible_amount AS deductible_amount_26 , t0 . verified_deductible AS verified_deductible_27 , t0 . insurance_number AS insurance_number_28 , t0 . cca AS cca_29 , t0 . procedure AS procedure_30 , t0 . signed AS signed_31 , t0 . signed_date AS signed_date_32 , t0 . file AS file_33 , t0 . known_by AS known_by_34 , t0 . gift AS gift_35 , t0 . adresse_pose AS adresse_pose_36 , t0 . task AS task_37 , t0 . updated_at AS updated_at_38 , t0 . relance_at AS relance_at_39 , t0 . is_paid AS is_paid_40 , t0 . sinister_number AS sinister_number_41 , t0 . is_assured AS is_assured_42 , t0 . is_send_folder AS is_send_folder_43 , t0 . is_send_invoice AS is_send_invoice_44 , t0 . cancellation_reason AS cancellation_reason_45 , t0 . cover AS cover_46 , t0 . status_command AS status_command_47 , t0 . ref AS ref_48 , t0 . ref_client AS ref_client_49 , t0 . km AS km_50 , t0 . member_client AS member_client_51 , t0 . member_garage AS member_garage_52 , t0 . is_gift_send AS is_gift_send_53 , t0 . status_updated AS status_updated_54 , t0 . pattern_cover AS pattern_cover_55 , t0 . judicial AS judicial_56 , t0 . relance_updated_at AS relance_updated_at_57 , t0 . relance_created_at AS relance_created_at_58 , t0 . relance_after_at AS relance_after_at_59 , t0 . sms_balance AS sms_balance_60 , t0 . brand AS brand_61 , t0 . mine_type AS mine_type_62 , t0 . serial_number AS serial_number_63 , t0 . wan_code AS wan_code_64 , t0 . audatex_code AS audatex_code_65 , t0 . euro_code AS euro_code_66 , t0 . vin_identified AS vin_identified_67 , t0 . sidexa_state AS sidexa_state_68 , t0 . sidexa_vehicle_model AS sidexa_vehicle_model_69 , t0 . data_updated AS data_updated_70 , t0 . category AS category_71 , t0 . department AS department_72 , t0 . complexity AS complexity_73 , t0 . repar AS repar_74 , t0 . marge AS marge_75 , t0 . appointment_update_reason AS appointment_update_reason_76 , t0 . closing_date AS closing_date_77 , t0 . planif_date AS planif_date_78 , t0 . gap AS gap_79 , t0 . offset_pose AS offset_pose_80 , t0 . duplicate AS duplicate_81 , t0 . couriers_parent_number AS couriers_parent_number_82 , t0 . state AS state_83 , t0 . quiz_sent_folder_submited AS quiz_sent_folder_submited_84 , t0 . prime_date AS prime_date_85 , t0 . insurance_card_added_at AS insurance_card_added_at_86 , t0 . vehicle_card_added_at AS vehicle_card_added_at_87 , t0 . windscreen_added_at AS windscreen_added_at_88 , t0 . last_agent_update_at AS last_agent_update_at_89 , t0 . openai_thread_id AS openai_thread_id_90 , t0 . vehicle_description AS vehicle_description_91 , t0 . has_partial_payment AS has_partial_payment_92 , t0 . paid_gap_amount AS paid_gap_amount_93 , t0 . gap_declarate_date AS gap_declarate_date_94 , t0 . hubspot_id AS hubspot_id_95 , t0 . ht_repair_order AS ht_repair_order_96 , t0 . task_verif_closed_date AS task_verif_closed_date_97 , t0 . first_signature_date AS first_signature_date_98 , t0 . companie_id AS companie_id_99 , t0 . customer_id AS customer_id_100 , t0 . gestionnaire_id AS gestionnaire_id_101 , t0 . created_by AS created_by_102 , t0 . updated_by AS updated_by_103 , t0 . technician_id AS technician_id_104 , t0 . service_client_id AS service_client_id_105 , t0 . agent_id AS agent_id_106 , t0 . relanceur_id AS relanceur_id_107 , t0 . recouvreur_id AS recouvreur_id_108 , t0 . status_folder_id AS status_folder_id_109 , t0 . insurance_name_new_id AS insurance_name_new_id_110 , t0 . recovery_id AS recovery_id_111 , t0 . known_id AS known_id_112 FROM folder t0 WHERE t0 . id = 20441 ;
Copy
11
0.48 ms
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . firstname AS firstname_3 , t0 . email AS email_4 , t0 . address AS address_5 , t0 . phone AS phone_6 , t0 . postal_code AS postal_code_7 , t0 . town AS town_8 , t0 . siret AS siret_9 , t0 . rcs AS rcs_10 , t0 . tva_number AS tva_number_11 , t0 . derogation_regime AS derogation_regime_12 , t0 . is_professional AS is_professional_13 , t0 . is_tva_subject AS is_tva_subject_14 FROM customer t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . firstname AS firstname_3 , t0 . email AS email_4 , t0 . address AS address_5 , t0 . phone AS phone_6 , t0 . postal_code AS postal_code_7 , t0 . town AS town_8 , t0 . siret AS siret_9 , t0 . rcs AS rcs_10 , t0 . tva_number AS tva_number_11 , t0 . derogation_regime AS derogation_regime_12 , t0 . is_professional AS is_professional_13 , t0 . is_tva_subject AS is_tva_subject_14 FROM customer t0 WHERE t0 . id = 23278 ;
Copy
12
0.98 ms
SELECT t0 . id AS id_1 , t0 . registration AS registration_2 , t0 . registration_normalized AS registration_normalized_3 , t0 . vehicle_model AS vehicle_model_4 , t0 . insurance_name AS insurance_name_5 , t0 . appointment AS appointment_6 , t0 . appointment_end AS appointment_end_7 , t0 . status AS status_8 , t0 . windscreen AS windscreen_9 , t0 . insurance_card AS insurance_card_10 , t0 . vehicle_card AS vehicle_card_11 , t0 . created_at AS created_at_12 , t0 . professional AS professional_13 , t0 . tva_subject AS tva_subject_14 , t0 . sensor AS sensor_15 , t0 . athermal AS athermal_16 , t0 . camera AS camera_17 , t0 . glass AS glass_18 , t0 . sinister_date AS sinister_date_19 , t0 . declare_date AS declare_date_20 , t0 . sinister_reason AS sinister_reason_21 , t0 . sinister_circ AS sinister_circ_22 , t0 . sinister_location AS sinister_location_23 , t0 . travel_reason AS travel_reason_24 , t0 . invoice_due AS invoice_due_25 , t0 . deductible_amount AS deductible_amount_26 , t0 . verified_deductible AS verified_deductible_27 , t0 . insurance_number AS insurance_number_28 , t0 . cca AS cca_29 , t0 . procedure AS procedure_30 , t0 . signed AS signed_31 , t0 . signed_date AS signed_date_32 , t0 . file AS file_33 , t0 . known_by AS known_by_34 , t0 . gift AS gift_35 , t0 . adresse_pose AS adresse_pose_36 , t0 . task AS task_37 , t0 . updated_at AS updated_at_38 , t0 . relance_at AS relance_at_39 , t0 . is_paid AS is_paid_40 , t0 . sinister_number AS sinister_number_41 , t0 . is_assured AS is_assured_42 , t0 . is_send_folder AS is_send_folder_43 , t0 . is_send_invoice AS is_send_invoice_44 , t0 . cancellation_reason AS cancellation_reason_45 , t0 . cover AS cover_46 , t0 . status_command AS status_command_47 , t0 . ref AS ref_48 , t0 . ref_client AS ref_client_49 , t0 . km AS km_50 , t0 . member_client AS member_client_51 , t0 . member_garage AS member_garage_52 , t0 . is_gift_send AS is_gift_send_53 , t0 . status_updated AS status_updated_54 , t0 . pattern_cover AS pattern_cover_55 , t0 . judicial AS judicial_56 , t0 . relance_updated_at AS relance_updated_at_57 , t0 . relance_created_at AS relance_created_at_58 , t0 . relance_after_at AS relance_after_at_59 , t0 . sms_balance AS sms_balance_60 , t0 . brand AS brand_61 , t0 . mine_type AS mine_type_62 , t0 . serial_number AS serial_number_63 , t0 . wan_code AS wan_code_64 , t0 . audatex_code AS audatex_code_65 , t0 . euro_code AS euro_code_66 , t0 . vin_identified AS vin_identified_67 , t0 . sidexa_state AS sidexa_state_68 , t0 . sidexa_vehicle_model AS sidexa_vehicle_model_69 , t0 . data_updated AS data_updated_70 , t0 . category AS category_71 , t0 . department AS department_72 , t0 . complexity AS complexity_73 , t0 . repar AS repar_74 , t0 . marge AS marge_75 , t0 . appointment_update_reason AS appointment_update_reason_76 , t0 . closing_date AS closing_date_77 , t0 . planif_date AS planif_date_78 , t0 . gap AS gap_79 , t0 . offset_pose AS offset_pose_80 , t0 . duplicate AS duplicate_81 , t0 . couriers_parent_number AS couriers_parent_number_82 , t0 . state AS state_83 , t0 . quiz_sent_folder_submited AS quiz_sent_folder_submited_84 , t0 . prime_date AS prime_date_85 , t0 . insurance_card_added_at AS insurance_card_added_at_86 , t0 . vehicle_card_added_at AS vehicle_card_added_at_87 , t0 . windscreen_added_at AS windscreen_added_at_88 , t0 . last_agent_update_at AS last_agent_update_at_89 , t0 . openai_thread_id AS openai_thread_id_90 , t0 . vehicle_description AS vehicle_description_91 , t0 . has_partial_payment AS has_partial_payment_92 , t0 . paid_gap_amount AS paid_gap_amount_93 , t0 . gap_declarate_date AS gap_declarate_date_94 , t0 . hubspot_id AS hubspot_id_95 , t0 . ht_repair_order AS ht_repair_order_96 , t0 . task_verif_closed_date AS task_verif_closed_date_97 , t0 . first_signature_date AS first_signature_date_98 , t0 . companie_id AS companie_id_99 , t0 . customer_id AS customer_id_100 , t0 . gestionnaire_id AS gestionnaire_id_101 , t0 . created_by AS created_by_102 , t0 . updated_by AS updated_by_103 , t0 . technician_id AS technician_id_104 , t0 . service_client_id AS service_client_id_105 , t0 . agent_id AS agent_id_106 , t0 . relanceur_id AS relanceur_id_107 , t0 . recouvreur_id AS recouvreur_id_108 , t0 . status_folder_id AS status_folder_id_109 , t0 . insurance_name_new_id AS insurance_name_new_id_110 , t0 . recovery_id AS recovery_id_111 , t0 . known_id AS known_id_112 FROM folder t0 WHERE t0 . id = ?
SELECT
t0 . id AS id_1 ,
t0 . registration AS registration_2 ,
t0 . registration_normalized AS registration_normalized_3 ,
t0 . vehicle_model AS vehicle_model_4 ,
t0 . insurance_name AS insurance_name_5 ,
t0 . appointment AS appointment_6 ,
t0 . appointment_end AS appointment_end_7 ,
t0 . status AS status_8 ,
t0 . windscreen AS windscreen_9 ,
t0 . insurance_card AS insurance_card_10 ,
t0 . vehicle_card AS vehicle_card_11 ,
t0 . created_at AS created_at_12 ,
t0 . professional AS professional_13 ,
t0 . tva_subject AS tva_subject_14 ,
t0 . sensor AS sensor_15 ,
t0 . athermal AS athermal_16 ,
t0 . camera AS camera_17 ,
t0 . glass AS glass_18 ,
t0 . sinister_date AS sinister_date_19 ,
t0 . declare_date AS declare_date_20 ,
t0 . sinister_reason AS sinister_reason_21 ,
t0 . sinister_circ AS sinister_circ_22 ,
t0 . sinister_location AS sinister_location_23 ,
t0 . travel_reason AS travel_reason_24 ,
t0 . invoice_due AS invoice_due_25 ,
t0 . deductible_amount AS deductible_amount_26 ,
t0 . verified_deductible AS verified_deductible_27 ,
t0 . insurance_number AS insurance_number_28 ,
t0 . cca AS cca_29 ,
t0 . procedure AS procedure_30 ,
t0 . signed AS signed_31 ,
t0 . signed_date AS signed_date_32 ,
t0 . file AS file_33 ,
t0 . known_by AS known_by_34 ,
t0 . gift AS gift_35 ,
t0 . adresse_pose AS adresse_pose_36 ,
t0 . task AS task_37 ,
t0 . updated_at AS updated_at_38 ,
t0 . relance_at AS relance_at_39 ,
t0 . is_paid AS is_paid_40 ,
t0 . sinister_number AS sinister_number_41 ,
t0 . is_assured AS is_assured_42 ,
t0 . is_send_folder AS is_send_folder_43 ,
t0 . is_send_invoice AS is_send_invoice_44 ,
t0 . cancellation_reason AS cancellation_reason_45 ,
t0 . cover AS cover_46 ,
t0 . status_command AS status_command_47 ,
t0 . ref AS ref_48 ,
t0 . ref_client AS ref_client_49 ,
t0 . km AS km_50 ,
t0 . member_client AS member_client_51 ,
t0 . member_garage AS member_garage_52 ,
t0 . is_gift_send AS is_gift_send_53 ,
t0 . status_updated AS status_updated_54 ,
t0 . pattern_cover AS pattern_cover_55 ,
t0 . judicial AS judicial_56 ,
t0 . relance_updated_at AS relance_updated_at_57 ,
t0 . relance_created_at AS relance_created_at_58 ,
t0 . relance_after_at AS relance_after_at_59 ,
t0 . sms_balance AS sms_balance_60 ,
t0 . brand AS brand_61 ,
t0 . mine_type AS mine_type_62 ,
t0 . serial_number AS serial_number_63 ,
t0 . wan_code AS wan_code_64 ,
t0 . audatex_code AS audatex_code_65 ,
t0 . euro_code AS euro_code_66 ,
t0 . vin_identified AS vin_identified_67 ,
t0 . sidexa_state AS sidexa_state_68 ,
t0 . sidexa_vehicle_model AS sidexa_vehicle_model_69 ,
t0 . data_updated AS data_updated_70 ,
t0 . category AS category_71 ,
t0 . department AS department_72 ,
t0 . complexity AS complexity_73 ,
t0 . repar AS repar_74 ,
t0 . marge AS marge_75 ,
t0 . appointment_update_reason AS appointment_update_reason_76 ,
t0 . closing_date AS closing_date_77 ,
t0 . planif_date AS planif_date_78 ,
t0 . gap AS gap_79 ,
t0 . offset_pose AS offset_pose_80 ,
t0 . duplicate AS duplicate_81 ,
t0 . couriers_parent_number AS couriers_parent_number_82 ,
t0 . state AS state_83 ,
t0 . quiz_sent_folder_submited AS quiz_sent_folder_submited_84 ,
t0 . prime_date AS prime_date_85 ,
t0 . insurance_card_added_at AS insurance_card_added_at_86 ,
t0 . vehicle_card_added_at AS vehicle_card_added_at_87 ,
t0 . windscreen_added_at AS windscreen_added_at_88 ,
t0 . last_agent_update_at AS last_agent_update_at_89 ,
t0 . openai_thread_id AS openai_thread_id_90 ,
t0 . vehicle_description AS vehicle_description_91 ,
t0 . has_partial_payment AS has_partial_payment_92 ,
t0 . paid_gap_amount AS paid_gap_amount_93 ,
t0 . gap_declarate_date AS gap_declarate_date_94 ,
t0 . hubspot_id AS hubspot_id_95 ,
t0 . ht_repair_order AS ht_repair_order_96 ,
t0 . task_verif_closed_date AS task_verif_closed_date_97 ,
t0 . first_signature_date AS first_signature_date_98 ,
t0 . companie_id AS companie_id_99 ,
t0 . customer_id AS customer_id_100 ,
t0 . gestionnaire_id AS gestionnaire_id_101 ,
t0 . created_by AS created_by_102 ,
t0 . updated_by AS updated_by_103 ,
t0 . technician_id AS technician_id_104 ,
t0 . service_client_id AS service_client_id_105 ,
t0 . agent_id AS agent_id_106 ,
t0 . relanceur_id AS relanceur_id_107 ,
t0 . recouvreur_id AS recouvreur_id_108 ,
t0 . status_folder_id AS status_folder_id_109 ,
t0 . insurance_name_new_id AS insurance_name_new_id_110 ,
t0 . recovery_id AS recovery_id_111 ,
t0 . known_id AS known_id_112
FROM
folder t0
WHERE
t0 . id = ?
Copy
SELECT t0 . id AS id_1 , t0 . registration AS registration_2 , t0 . registration_normalized AS registration_normalized_3 , t0 . vehicle_model AS vehicle_model_4 , t0 . insurance_name AS insurance_name_5 , t0 . appointment AS appointment_6 , t0 . appointment_end AS appointment_end_7 , t0 . status AS status_8 , t0 . windscreen AS windscreen_9 , t0 . insurance_card AS insurance_card_10 , t0 . vehicle_card AS vehicle_card_11 , t0 . created_at AS created_at_12 , t0 . professional AS professional_13 , t0 . tva_subject AS tva_subject_14 , t0 . sensor AS sensor_15 , t0 . athermal AS athermal_16 , t0 . camera AS camera_17 , t0 . glass AS glass_18 , t0 . sinister_date AS sinister_date_19 , t0 . declare_date AS declare_date_20 , t0 . sinister_reason AS sinister_reason_21 , t0 . sinister_circ AS sinister_circ_22 , t0 . sinister_location AS sinister_location_23 , t0 . travel_reason AS travel_reason_24 , t0 . invoice_due AS invoice_due_25 , t0 . deductible_amount AS deductible_amount_26 , t0 . verified_deductible AS verified_deductible_27 , t0 . insurance_number AS insurance_number_28 , t0 . cca AS cca_29 , t0 . procedure AS procedure_30 , t0 . signed AS signed_31 , t0 . signed_date AS signed_date_32 , t0 . file AS file_33 , t0 . known_by AS known_by_34 , t0 . gift AS gift_35 , t0 . adresse_pose AS adresse_pose_36 , t0 . task AS task_37 , t0 . updated_at AS updated_at_38 , t0 . relance_at AS relance_at_39 , t0 . is_paid AS is_paid_40 , t0 . sinister_number AS sinister_number_41 , t0 . is_assured AS is_assured_42 , t0 . is_send_folder AS is_send_folder_43 , t0 . is_send_invoice AS is_send_invoice_44 , t0 . cancellation_reason AS cancellation_reason_45 , t0 . cover AS cover_46 , t0 . status_command AS status_command_47 , t0 . ref AS ref_48 , t0 . ref_client AS ref_client_49 , t0 . km AS km_50 , t0 . member_client AS member_client_51 , t0 . member_garage AS member_garage_52 , t0 . is_gift_send AS is_gift_send_53 , t0 . status_updated AS status_updated_54 , t0 . pattern_cover AS pattern_cover_55 , t0 . judicial AS judicial_56 , t0 . relance_updated_at AS relance_updated_at_57 , t0 . relance_created_at AS relance_created_at_58 , t0 . relance_after_at AS relance_after_at_59 , t0 . sms_balance AS sms_balance_60 , t0 . brand AS brand_61 , t0 . mine_type AS mine_type_62 , t0 . serial_number AS serial_number_63 , t0 . wan_code AS wan_code_64 , t0 . audatex_code AS audatex_code_65 , t0 . euro_code AS euro_code_66 , t0 . vin_identified AS vin_identified_67 , t0 . sidexa_state AS sidexa_state_68 , t0 . sidexa_vehicle_model AS sidexa_vehicle_model_69 , t0 . data_updated AS data_updated_70 , t0 . category AS category_71 , t0 . department AS department_72 , t0 . complexity AS complexity_73 , t0 . repar AS repar_74 , t0 . marge AS marge_75 , t0 . appointment_update_reason AS appointment_update_reason_76 , t0 . closing_date AS closing_date_77 , t0 . planif_date AS planif_date_78 , t0 . gap AS gap_79 , t0 . offset_pose AS offset_pose_80 , t0 . duplicate AS duplicate_81 , t0 . couriers_parent_number AS couriers_parent_number_82 , t0 . state AS state_83 , t0 . quiz_sent_folder_submited AS quiz_sent_folder_submited_84 , t0 . prime_date AS prime_date_85 , t0 . insurance_card_added_at AS insurance_card_added_at_86 , t0 . vehicle_card_added_at AS vehicle_card_added_at_87 , t0 . windscreen_added_at AS windscreen_added_at_88 , t0 . last_agent_update_at AS last_agent_update_at_89 , t0 . openai_thread_id AS openai_thread_id_90 , t0 . vehicle_description AS vehicle_description_91 , t0 . has_partial_payment AS has_partial_payment_92 , t0 . paid_gap_amount AS paid_gap_amount_93 , t0 . gap_declarate_date AS gap_declarate_date_94 , t0 . hubspot_id AS hubspot_id_95 , t0 . ht_repair_order AS ht_repair_order_96 , t0 . task_verif_closed_date AS task_verif_closed_date_97 , t0 . first_signature_date AS first_signature_date_98 , t0 . companie_id AS companie_id_99 , t0 . customer_id AS customer_id_100 , t0 . gestionnaire_id AS gestionnaire_id_101 , t0 . created_by AS created_by_102 , t0 . updated_by AS updated_by_103 , t0 . technician_id AS technician_id_104 , t0 . service_client_id AS service_client_id_105 , t0 . agent_id AS agent_id_106 , t0 . relanceur_id AS relanceur_id_107 , t0 . recouvreur_id AS recouvreur_id_108 , t0 . status_folder_id AS status_folder_id_109 , t0 . insurance_name_new_id AS insurance_name_new_id_110 , t0 . recovery_id AS recovery_id_111 , t0 . known_id AS known_id_112 FROM folder t0 WHERE t0 . id = 20432 ;
Copy
13
0.50 ms
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . firstname AS firstname_3 , t0 . email AS email_4 , t0 . address AS address_5 , t0 . phone AS phone_6 , t0 . postal_code AS postal_code_7 , t0 . town AS town_8 , t0 . siret AS siret_9 , t0 . rcs AS rcs_10 , t0 . tva_number AS tva_number_11 , t0 . derogation_regime AS derogation_regime_12 , t0 . is_professional AS is_professional_13 , t0 . is_tva_subject AS is_tva_subject_14 FROM customer t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . firstname AS firstname_3 , t0 . email AS email_4 , t0 . address AS address_5 , t0 . phone AS phone_6 , t0 . postal_code AS postal_code_7 , t0 . town AS town_8 , t0 . siret AS siret_9 , t0 . rcs AS rcs_10 , t0 . tva_number AS tva_number_11 , t0 . derogation_regime AS derogation_regime_12 , t0 . is_professional AS is_professional_13 , t0 . is_tva_subject AS is_tva_subject_14 FROM customer t0 WHERE t0 . id = 23269 ;
Copy