Symfony Profiler

Query Metrics

26 Database Queries

21 Different statements

13.47 ms Query time

0 Invalid entities

32 Managed entities

Queries


SELECT t0.civility AS civility_1, t0.first_name AS first_name_2, t0.last_name AS last_name_3, t0.login AS login_4, t0.password AS password_5, t0.email AS email_6, t0.phone AS phone_7, t0.mobile_phone AS mobile_phone_8, t0.contact AS contact_9, t0.status AS status_10, t0.first_login AS first_login_11, t0.avatar AS avatar_12, t0.token AS token_13, t0.token_created_at AS token_created_at_14, t0.id AS id_15, t0.role_id AS role_id_16, t0.group_id AS group_id_17 FROM user t0 WHERE t0.id = ?
SELECT t0.name AS name_1, t0.label AS label_2, t0.id AS id_3, t4.civility AS civility_5, t4.first_name AS first_name_6, t4.last_name AS last_name_7, t4.login AS login_8, t4.password AS password_9, t4.email AS email_10, t4.phone AS phone_11, t4.mobile_phone AS mobile_phone_12, t4.contact AS contact_13, t4.status AS status_14, t4.first_login AS first_login_15, t4.avatar AS avatar_16, t4.token AS token_17, t4.token_created_at AS token_created_at_18, t4.id AS id_19, t4.role_id AS role_id_20, t4.group_id AS group_id_21, t0.parent AS parent_22 FROM role t0 LEFT JOIN user t4 ON t4.role_id = t0.id WHERE t0.id = ?
SELECT c0_.date AS date_0, c0_.first_connection_time AS first_connection_time_1, c0_.last_connection_time AS last_connection_time_2, c0_.last_action_time AS last_action_time_3, c0_.last_disconnection_time AS last_disconnection_time_4, c0_.total_duration AS total_duration_5, c0_.session_count AS session_count_6, c0_.active AS active_7, c0_.id AS id_8, c0_.user_id AS user_id_9 FROM connection_history c0_ INNER JOIN user u1_ ON c0_.user_id = u1_.id WHERE u1_.id = ? ORDER BY c0_.date DESC LIMIT 1
SELECT t0.date AS date_1, t0.first_connection_time AS first_connection_time_2, t0.last_connection_time AS last_connection_time_3, t0.last_action_time AS last_action_time_4, t0.last_disconnection_time AS last_disconnection_time_5, t0.total_duration AS total_duration_6, t0.session_count AS session_count_7, t0.active AS active_8, t0.id AS id_9, t0.user_id AS user_id_10 FROM connection_history t0 WHERE t0.user_id = ? AND t0.date = ? LIMIT 1
"START TRANSACTION"
UPDATE connection_history SET last_action_time = ? WHERE id = ?
"COMMIT"
SELECT t0.number AS number_1, t0.amc_number AS amc_number_2, t0.created_at AS created_at_3, t0.date_recall AS date_recall_4, t0.date_visit AS date_visit_5, t0.date_quotation AS date_quotation_6, t0.amount AS amount_7, t0.amo_amount AS amo_amount_8, t0.pec_amo_amount AS pec_amo_amount_9, t0.manager_amount AS manager_amount_10, t0.client_amount AS client_amount_11, t0.date_expired AS date_expired_12, t0.date_reject AS date_reject_13, t0.priority AS priority_14, t0.billing_status AS billing_status_15, t0.billing_excluded AS billing_excluded_16, t0.online AS online_17, t0.ortodontics AS ortodontics_18, t0.date_pec_requested AS date_pec_requested_19, t0.date_pec_responded AS date_pec_responded_20, t0.sms_for_patient AS sms_for_patient_21, t0.updated_at AS updated_at_22, t0.next_system_action AS next_system_action_23, t0.date_next_system_action AS date_next_system_action_24, t0.date_pec_acknowledged AS date_pec_acknowledged_25, t0.acknowledgement_reference AS acknowledgement_reference_26, t0.social_security_bases AS social_security_bases_27, t0.contract_number AS contract_number_28, t0.name_of_the_insured AS name_of_the_insured_29, t0.surname_of_the_insured AS surname_of_the_insured_30, t0.date_of_birth_of_the_insured AS date_of_birth_of_the_insured_31, t0.quotation_date_expiration AS quotation_date_expiration_32, t0.cmu_status AS cmu_status_33, t0.social_security_statement_flag AS social_security_statement_flag_34, t0.invoice_number AS invoice_number_35, t0.invoice_date AS invoice_date_36, t0.invoice_amount AS invoice_amount_37, t0.skip_auto_invoicing AS skip_auto_invoicing_38, t0.invoiced_by_fulldevis AS invoiced_by_fulldevis_39, t0.followup_status AS followup_status_40, t0.last_followup_at AS last_followup_at_41, t0.relance_count AS relance_count_42, t0.id AS id_43, t44.confirmed AS confirmed_45, t44.updated_at AS updated_at_46, t44.created_at AS created_at_47, t44.id AS id_48, t44.quotation_id AS quotation_id_49, t44.created_by_id AS created_by_id_50, t44.confirmed_by_id AS confirmed_by_id_51, t52.dre_number AS dre_number_53, t52.fse_number AS fse_number_54, t52.status_ro AS status_ro_55, t52.status_rc AS status_rc_56, t52.status_pp AS status_pp_57, t52.sent_date_ro AS sent_date_ro_58, t52.settled_date_ro AS settled_date_ro_59, t52.rejected_date_ro AS rejected_date_ro_60, t52.cancelled_date_ro AS cancelled_date_ro_61, t52.sent_date_rc AS sent_date_rc_62, t52.settled_date_rc AS settled_date_rc_63, t52.rejected_date_rc AS rejected_date_rc_64, t52.cancelled_date_rc AS cancelled_date_rc_65, t52.invoice_ro_amount AS invoice_ro_amount_66, t52.invoice_ro_paid_amount AS invoice_ro_paid_amount_67, t52.invoice_rc_amount AS invoice_rc_amount_68, t52.invoice_rc_paid_amount AS invoice_rc_paid_amount_69, t52.invoice_pp_amount AS invoice_pp_amount_70, t52.invoice_pp_paid_amount AS invoice_pp_paid_amount_71, t52.invoice_synchro_comment AS invoice_synchro_comment_72, t52.ro_label AS ro_label_73, t52.rc_label AS rc_label_74, t52.id AS id_75, t52.quotation_id AS quotation_id_76, t0.user_id AS user_id_77, t0.centre_id AS centre_id_78, t0.patient_id AS patient_id_79, t0.practitioner_id AS practitioner_id_80, t0.social_security_percentage_id AS social_security_percentage_id_81 FROM quotation t0 LEFT JOIN quotation_no_further_action t44 ON t44.quotation_id = t0.id LEFT JOIN invoicing_quotation_details t52 ON t52.quotation_id = t0.id WHERE t0.id = ?
SELECT t0.by_email AS by_email_1, t0.online AS online_2, t0.by_fax AS by_fax_3, t0.by_letter AS by_letter_4, t0.id AS id_5, t0.quotation_id AS quotation_id_6, t0.insurance_company_id AS insurance_company_id_7, t0.address_id AS address_id_8 FROM quotation_insurance_company t0 WHERE t0.quotation_id = ?
SELECT r0_.alias AS alias_0 FROM rule r0_
SELECT t0.name AS name_1, t0.finess AS finess_2, t0.login AS login_3, t0.password AS password_4, t0.address AS address_5, t0.city AS city_6, t0.postal_code AS postal_code_7, t0.phone AS phone_8, t0.fax AS fax_9, t0.email AS email_10, t0.saps_email AS saps_email_11, t0.saps_password AS saps_password_12, t0.quotation_price AS quotation_price_13, t0.estimated_price AS estimated_price_14, t0.subscription_price AS subscription_price_15, t0.billing_excluded AS billing_excluded_16, t0.subscription_excluded AS subscription_excluded_17, t0.multi_centre AS multi_centre_18, t0.invoicing AS invoicing_19, t0.bank_score AS bank_score_20, t0.status AS status_21, t0.start_date AS start_date_22, t0.enable_ocr AS enable_ocr_23, t0.email_comptable AS email_comptable_24, t0.cabinet_status AS cabinet_status_25, t0.insurance_agreement_status AS insurance_agreement_status_26, t0.id AS id_27, t28.id_externe AS id_externe_29, t28.desmos AS desmos_30, t28.veasy AS veasy_31, t28.doctolib AS doctolib_32, t28.id AS id_33, t28.centre_id AS centre_id_34, t0.creator_group_id AS creator_group_id_35, t0.group_id AS group_id_36, t0.contact_id AS contact_id_37 FROM centre t0 LEFT JOIN centre_mapping t28 ON t28.centre_id = t0.id WHERE t0.id = ?
SELECT d0_.name AS name_0, d0_.created_at AS created_at_1, d0_.visit_date AS visit_date_2, d0_.bounded_at AS bounded_at_3, d0_.signed_by_patient AS signed_by_patient_4, d0_.signed_by_centre AS signed_by_centre_5, d0_.signed_by_patient_at AS signed_by_patient_at_6, d0_.signed_by_centre_at AS signed_by_centre_at_7, d0_.refused_by_patient AS refused_by_patient_8, d0_.refused_by_patient_at AS refused_by_patient_at_9, d0_.sent_to_patient_to_sign AS sent_to_patient_to_sign_10, d0_.sent_to_patient_to_sign_at AS sent_to_patient_to_sign_at_11, d0_.id AS id_12, q1_.number AS number_13, q1_.amc_number AS amc_number_14, q1_.created_at AS created_at_15, q1_.date_recall AS date_recall_16, q1_.date_visit AS date_visit_17, q1_.date_quotation AS date_quotation_18, q1_.amount AS amount_19, q1_.amo_amount AS amo_amount_20, q1_.pec_amo_amount AS pec_amo_amount_21, q1_.manager_amount AS manager_amount_22, q1_.client_amount AS client_amount_23, q1_.date_expired AS date_expired_24, q1_.date_reject AS date_reject_25, q1_.priority AS priority_26, q1_.billing_status AS billing_status_27, q1_.billing_excluded AS billing_excluded_28, q1_.online AS online_29, q1_.ortodontics AS ortodontics_30, q1_.date_pec_requested AS date_pec_requested_31, q1_.date_pec_responded AS date_pec_responded_32, q1_.sms_for_patient AS sms_for_patient_33, q1_.updated_at AS updated_at_34, q1_.next_system_action AS next_system_action_35, q1_.date_next_system_action AS date_next_system_action_36, q1_.date_pec_acknowledged AS date_pec_acknowledged_37, q1_.acknowledgement_reference AS acknowledgement_reference_38, q1_.social_security_bases AS social_security_bases_39, q1_.contract_number AS contract_number_40, q1_.name_of_the_insured AS name_of_the_insured_41, q1_.surname_of_the_insured AS surname_of_the_insured_42, q1_.date_of_birth_of_the_insured AS date_of_birth_of_the_insured_43, q1_.quotation_date_expiration AS quotation_date_expiration_44, q1_.cmu_status AS cmu_status_45, q1_.social_security_statement_flag AS social_security_statement_flag_46, q1_.invoice_number AS invoice_number_47, q1_.invoice_date AS invoice_date_48, q1_.invoice_amount AS invoice_amount_49, q1_.skip_auto_invoicing AS skip_auto_invoicing_50, q1_.invoiced_by_fulldevis AS invoiced_by_fulldevis_51, q1_.followup_status AS followup_status_52, q1_.last_followup_at AS last_followup_at_53, q1_.relance_count AS relance_count_54, q1_.id AS id_55, d2_.name AS name_56, d2_.label AS label_57, d2_.order_by AS order_by_58, d2_.id AS id_59, d0_.user_id AS user_id_60, d0_.type_id AS type_id_61, d0_.quotation_status_id AS quotation_status_id_62, d0_.comment_id AS comment_id_63, d0_.quotation_id AS quotation_id_64, d0_.patient_id AS patient_id_65, d0_.centre_id AS centre_id_66, d0_.signed_by_centre_user_id AS signed_by_centre_user_id_67, d0_.signed_by_patient_user_id AS signed_by_patient_user_id_68, d0_.second_user_id AS second_user_id_69, q1_.user_id AS user_id_70, q1_.centre_id AS centre_id_71, q1_.patient_id AS patient_id_72, q1_.practitioner_id AS practitioner_id_73, q1_.social_security_percentage_id AS social_security_percentage_id_74 FROM document d0_ INNER JOIN quotation q1_ ON d0_.quotation_id = q1_.id INNER JOIN document_type d2_ ON d0_.type_id = d2_.id WHERE q1_.id = ? AND d2_.name = ? ORDER BY d0_.created_at DESC LIMIT 1
SELECT d0_.name AS name_0, d0_.created_at AS created_at_1, d0_.visit_date AS visit_date_2, d0_.bounded_at AS bounded_at_3, d0_.signed_by_patient AS signed_by_patient_4, d0_.signed_by_centre AS signed_by_centre_5, d0_.signed_by_patient_at AS signed_by_patient_at_6, d0_.signed_by_centre_at AS signed_by_centre_at_7, d0_.refused_by_patient AS refused_by_patient_8, d0_.refused_by_patient_at AS refused_by_patient_at_9, d0_.sent_to_patient_to_sign AS sent_to_patient_to_sign_10, d0_.sent_to_patient_to_sign_at AS sent_to_patient_to_sign_at_11, d0_.id AS id_12, q1_.number AS number_13, q1_.amc_number AS amc_number_14, q1_.created_at AS created_at_15, q1_.date_recall AS date_recall_16, q1_.date_visit AS date_visit_17, q1_.date_quotation AS date_quotation_18, q1_.amount AS amount_19, q1_.amo_amount AS amo_amount_20, q1_.pec_amo_amount AS pec_amo_amount_21, q1_.manager_amount AS manager_amount_22, q1_.client_amount AS client_amount_23, q1_.date_expired AS date_expired_24, q1_.date_reject AS date_reject_25, q1_.priority AS priority_26, q1_.billing_status AS billing_status_27, q1_.billing_excluded AS billing_excluded_28, q1_.online AS online_29, q1_.ortodontics AS ortodontics_30, q1_.date_pec_requested AS date_pec_requested_31, q1_.date_pec_responded AS date_pec_responded_32, q1_.sms_for_patient AS sms_for_patient_33, q1_.updated_at AS updated_at_34, q1_.next_system_action AS next_system_action_35, q1_.date_next_system_action AS date_next_system_action_36, q1_.date_pec_acknowledged AS date_pec_acknowledged_37, q1_.acknowledgement_reference AS acknowledgement_reference_38, q1_.social_security_bases AS social_security_bases_39, q1_.contract_number AS contract_number_40, q1_.name_of_the_insured AS name_of_the_insured_41, q1_.surname_of_the_insured AS surname_of_the_insured_42, q1_.date_of_birth_of_the_insured AS date_of_birth_of_the_insured_43, q1_.quotation_date_expiration AS quotation_date_expiration_44, q1_.cmu_status AS cmu_status_45, q1_.social_security_statement_flag AS social_security_statement_flag_46, q1_.invoice_number AS invoice_number_47, q1_.invoice_date AS invoice_date_48, q1_.invoice_amount AS invoice_amount_49, q1_.skip_auto_invoicing AS skip_auto_invoicing_50, q1_.invoiced_by_fulldevis AS invoiced_by_fulldevis_51, q1_.followup_status AS followup_status_52, q1_.last_followup_at AS last_followup_at_53, q1_.relance_count AS relance_count_54, q1_.id AS id_55, d2_.name AS name_56, d2_.label AS label_57, d2_.order_by AS order_by_58, d2_.id AS id_59, d0_.user_id AS user_id_60, d0_.type_id AS type_id_61, d0_.quotation_status_id AS quotation_status_id_62, d0_.comment_id AS comment_id_63, d0_.quotation_id AS quotation_id_64, d0_.patient_id AS patient_id_65, d0_.centre_id AS centre_id_66, d0_.signed_by_centre_user_id AS signed_by_centre_user_id_67, d0_.signed_by_patient_user_id AS signed_by_patient_user_id_68, d0_.second_user_id AS second_user_id_69, q1_.user_id AS user_id_70, q1_.centre_id AS centre_id_71, q1_.patient_id AS patient_id_72, q1_.practitioner_id AS practitioner_id_73, q1_.social_security_percentage_id AS social_security_percentage_id_74 FROM document d0_ INNER JOIN quotation q1_ ON d0_.quotation_id = q1_.id INNER JOIN document_type d2_ ON d0_.type_id = d2_.id WHERE q1_.id = ? AND d2_.name = ? ORDER BY d0_.created_at DESC LIMIT 1
SELECT d0_.name AS name_0, d0_.created_at AS created_at_1, d0_.visit_date AS visit_date_2, d0_.bounded_at AS bounded_at_3, d0_.signed_by_patient AS signed_by_patient_4, d0_.signed_by_centre AS signed_by_centre_5, d0_.signed_by_patient_at AS signed_by_patient_at_6, d0_.signed_by_centre_at AS signed_by_centre_at_7, d0_.refused_by_patient AS refused_by_patient_8, d0_.refused_by_patient_at AS refused_by_patient_at_9, d0_.sent_to_patient_to_sign AS sent_to_patient_to_sign_10, d0_.sent_to_patient_to_sign_at AS sent_to_patient_to_sign_at_11, d0_.id AS id_12, q1_.number AS number_13, q1_.amc_number AS amc_number_14, q1_.created_at AS created_at_15, q1_.date_recall AS date_recall_16, q1_.date_visit AS date_visit_17, q1_.date_quotation AS date_quotation_18, q1_.amount AS amount_19, q1_.amo_amount AS amo_amount_20, q1_.pec_amo_amount AS pec_amo_amount_21, q1_.manager_amount AS manager_amount_22, q1_.client_amount AS client_amount_23, q1_.date_expired AS date_expired_24, q1_.date_reject AS date_reject_25, q1_.priority AS priority_26, q1_.billing_status AS billing_status_27, q1_.billing_excluded AS billing_excluded_28, q1_.online AS online_29, q1_.ortodontics AS ortodontics_30, q1_.date_pec_requested AS date_pec_requested_31, q1_.date_pec_responded AS date_pec_responded_32, q1_.sms_for_patient AS sms_for_patient_33, q1_.updated_at AS updated_at_34, q1_.next_system_action AS next_system_action_35, q1_.date_next_system_action AS date_next_system_action_36, q1_.date_pec_acknowledged AS date_pec_acknowledged_37, q1_.acknowledgement_reference AS acknowledgement_reference_38, q1_.social_security_bases AS social_security_bases_39, q1_.contract_number AS contract_number_40, q1_.name_of_the_insured AS name_of_the_insured_41, q1_.surname_of_the_insured AS surname_of_the_insured_42, q1_.date_of_birth_of_the_insured AS date_of_birth_of_the_insured_43, q1_.quotation_date_expiration AS quotation_date_expiration_44, q1_.cmu_status AS cmu_status_45, q1_.social_security_statement_flag AS social_security_statement_flag_46, q1_.invoice_number AS invoice_number_47, q1_.invoice_date AS invoice_date_48, q1_.invoice_amount AS invoice_amount_49, q1_.skip_auto_invoicing AS skip_auto_invoicing_50, q1_.invoiced_by_fulldevis AS invoiced_by_fulldevis_51, q1_.followup_status AS followup_status_52, q1_.last_followup_at AS last_followup_at_53, q1_.relance_count AS relance_count_54, q1_.id AS id_55, d2_.name AS name_56, d2_.label AS label_57, d2_.order_by AS order_by_58, d2_.id AS id_59, d0_.user_id AS user_id_60, d0_.type_id AS type_id_61, d0_.quotation_status_id AS quotation_status_id_62, d0_.comment_id AS comment_id_63, d0_.quotation_id AS quotation_id_64, d0_.patient_id AS patient_id_65, d0_.centre_id AS centre_id_66, d0_.signed_by_centre_user_id AS signed_by_centre_user_id_67, d0_.signed_by_patient_user_id AS signed_by_patient_user_id_68, d0_.second_user_id AS second_user_id_69, q1_.user_id AS user_id_70, q1_.centre_id AS centre_id_71, q1_.patient_id AS patient_id_72, q1_.practitioner_id AS practitioner_id_73, q1_.social_security_percentage_id AS social_security_percentage_id_74 FROM document d0_ INNER JOIN quotation q1_ ON d0_.quotation_id = q1_.id INNER JOIN document_type d2_ ON d0_.type_id = d2_.id WHERE q1_.id = ? AND d2_.name = ? ORDER BY d0_.created_at DESC LIMIT 1
SELECT d0_.name AS name_0, d0_.created_at AS created_at_1, d0_.visit_date AS visit_date_2, d0_.bounded_at AS bounded_at_3, d0_.signed_by_patient AS signed_by_patient_4, d0_.signed_by_centre AS signed_by_centre_5, d0_.signed_by_patient_at AS signed_by_patient_at_6, d0_.signed_by_centre_at AS signed_by_centre_at_7, d0_.refused_by_patient AS refused_by_patient_8, d0_.refused_by_patient_at AS refused_by_patient_at_9, d0_.sent_to_patient_to_sign AS sent_to_patient_to_sign_10, d0_.sent_to_patient_to_sign_at AS sent_to_patient_to_sign_at_11, d0_.id AS id_12, q1_.number AS number_13, q1_.amc_number AS amc_number_14, q1_.created_at AS created_at_15, q1_.date_recall AS date_recall_16, q1_.date_visit AS date_visit_17, q1_.date_quotation AS date_quotation_18, q1_.amount AS amount_19, q1_.amo_amount AS amo_amount_20, q1_.pec_amo_amount AS pec_amo_amount_21, q1_.manager_amount AS manager_amount_22, q1_.client_amount AS client_amount_23, q1_.date_expired AS date_expired_24, q1_.date_reject AS date_reject_25, q1_.priority AS priority_26, q1_.billing_status AS billing_status_27, q1_.billing_excluded AS billing_excluded_28, q1_.online AS online_29, q1_.ortodontics AS ortodontics_30, q1_.date_pec_requested AS date_pec_requested_31, q1_.date_pec_responded AS date_pec_responded_32, q1_.sms_for_patient AS sms_for_patient_33, q1_.updated_at AS updated_at_34, q1_.next_system_action AS next_system_action_35, q1_.date_next_system_action AS date_next_system_action_36, q1_.date_pec_acknowledged AS date_pec_acknowledged_37, q1_.acknowledgement_reference AS acknowledgement_reference_38, q1_.social_security_bases AS social_security_bases_39, q1_.contract_number AS contract_number_40, q1_.name_of_the_insured AS name_of_the_insured_41, q1_.surname_of_the_insured AS surname_of_the_insured_42, q1_.date_of_birth_of_the_insured AS date_of_birth_of_the_insured_43, q1_.quotation_date_expiration AS quotation_date_expiration_44, q1_.cmu_status AS cmu_status_45, q1_.social_security_statement_flag AS social_security_statement_flag_46, q1_.invoice_number AS invoice_number_47, q1_.invoice_date AS invoice_date_48, q1_.invoice_amount AS invoice_amount_49, q1_.skip_auto_invoicing AS skip_auto_invoicing_50, q1_.invoiced_by_fulldevis AS invoiced_by_fulldevis_51, q1_.followup_status AS followup_status_52, q1_.last_followup_at AS last_followup_at_53, q1_.relance_count AS relance_count_54, q1_.id AS id_55, d2_.name AS name_56, d2_.label AS label_57, d2_.order_by AS order_by_58, d2_.id AS id_59, d0_.user_id AS user_id_60, d0_.type_id AS type_id_61, d0_.quotation_status_id AS quotation_status_id_62, d0_.comment_id AS comment_id_63, d0_.quotation_id AS quotation_id_64, d0_.patient_id AS patient_id_65, d0_.centre_id AS centre_id_66, d0_.signed_by_centre_user_id AS signed_by_centre_user_id_67, d0_.signed_by_patient_user_id AS signed_by_patient_user_id_68, d0_.second_user_id AS second_user_id_69, q1_.user_id AS user_id_70, q1_.centre_id AS centre_id_71, q1_.patient_id AS patient_id_72, q1_.practitioner_id AS practitioner_id_73, q1_.social_security_percentage_id AS social_security_percentage_id_74 FROM document d0_ INNER JOIN quotation q1_ ON d0_.quotation_id = q1_.id INNER JOIN document_type d2_ ON d0_.type_id = d2_.id WHERE q1_.id = ? AND d2_.name = ? ORDER BY d0_.created_at DESC LIMIT 1
SELECT q0_.by_email AS by_email_0, q0_.online AS online_1, q0_.by_fax AS by_fax_2, q0_.by_letter AS by_letter_3, q0_.id AS id_4, q0_.quotation_id AS quotation_id_5, q0_.insurance_company_id AS insurance_company_id_6, q0_.address_id AS address_id_7 FROM quotation_insurance_company q0_ LEFT JOIN insurance_company i1_ ON q0_.insurance_company_id = i1_.id LEFT JOIN quotation q2_ ON q0_.quotation_id = q2_.id WHERE q2_.id = ? AND i1_.type = ? ORDER BY q0_.id DESC LIMIT 1
SELECT q0_.by_email AS by_email_0, q0_.online AS online_1, q0_.by_fax AS by_fax_2, q0_.by_letter AS by_letter_3, q0_.id AS id_4, q0_.quotation_id AS quotation_id_5, q0_.insurance_company_id AS insurance_company_id_6, q0_.address_id AS address_id_7 FROM quotation_insurance_company q0_ LEFT JOIN insurance_company i1_ ON q0_.insurance_company_id = i1_.id LEFT JOIN quotation q2_ ON q0_.quotation_id = q2_.id WHERE q2_.id = ? AND i1_.type = ? ORDER BY q0_.id DESC LIMIT 1
SELECT t0.name AS name_1, t0.amc_number AS amc_number_2, t0.type AS type_3, t0.corr_civility AS corr_civility_4, t0.corr_lastname AS corr_lastname_5, t0.corr_firstname AS corr_firstname_6, t0.corr_phone AS corr_phone_7, t0.corr_email AS corr_email_8, t0.web_site AS web_site_9, t0.dynamic_pec_treatment_days AS dynamic_pec_treatment_days_10, t0.static_pec_treatment_days AS static_pec_treatment_days_11, t0.auto_mail_synchro_status AS auto_mail_synchro_status_12, t0.id AS id_13, t0.group_id AS group_id_14 FROM insurance_company t0 WHERE t0.id = ?
SELECT t0.name AS name_1, t0.amc_number AS amc_number_2, t0.type AS type_3, t0.corr_civility AS corr_civility_4, t0.corr_lastname AS corr_lastname_5, t0.corr_firstname AS corr_firstname_6, t0.corr_phone AS corr_phone_7, t0.corr_email AS corr_email_8, t0.web_site AS web_site_9, t0.dynamic_pec_treatment_days AS dynamic_pec_treatment_days_10, t0.static_pec_treatment_days AS static_pec_treatment_days_11, t0.auto_mail_synchro_status AS auto_mail_synchro_status_12, t0.id AS id_13, t0.group_id AS group_id_14 FROM insurance_company t0 WHERE t0.id = ?
SELECT t0.updated_at AS updated_at_1, t0.id AS id_2, t0.status_id AS status_id_3, t0.quotation_id AS quotation_id_4, t0.user_id AS user_id_5, t0.second_user_id AS second_user_id_6 FROM quotation_history t0 WHERE t0.quotation_id = ? ORDER BY t0.updated_at ASC
SELECT t0.name AS name_1, t0.label AS label_2, t0.sort_order AS sort_order_3, t0.final AS final_4, t0.id AS id_5 FROM quotation_status t0 WHERE t0.id = ?
SELECT q0_.created_at AS created_at_0, q0_.id AS id_1, s1_.comment AS comment_2, s1_.sort_order AS sort_order_3, s1_.is_deleted AS is_deleted_4, s1_.id AS id_5, q2_.number AS number_6, q2_.amc_number AS amc_number_7, q2_.created_at AS created_at_8, q2_.date_recall AS date_recall_9, q2_.date_visit AS date_visit_10, q2_.date_quotation AS date_quotation_11, q2_.amount AS amount_12, q2_.amo_amount AS amo_amount_13, q2_.pec_amo_amount AS pec_amo_amount_14, q2_.manager_amount AS manager_amount_15, q2_.client_amount AS client_amount_16, q2_.date_expired AS date_expired_17, q2_.date_reject AS date_reject_18, q2_.priority AS priority_19, q2_.billing_status AS billing_status_20, q2_.billing_excluded AS billing_excluded_21, q2_.online AS online_22, q2_.ortodontics AS ortodontics_23, q2_.date_pec_requested AS date_pec_requested_24, q2_.date_pec_responded AS date_pec_responded_25, q2_.sms_for_patient AS sms_for_patient_26, q2_.updated_at AS updated_at_27, q2_.next_system_action AS next_system_action_28, q2_.date_next_system_action AS date_next_system_action_29, q2_.date_pec_acknowledged AS date_pec_acknowledged_30, q2_.acknowledgement_reference AS acknowledgement_reference_31, q2_.social_security_bases AS social_security_bases_32, q2_.contract_number AS contract_number_33, q2_.name_of_the_insured AS name_of_the_insured_34, q2_.surname_of_the_insured AS surname_of_the_insured_35, q2_.date_of_birth_of_the_insured AS date_of_birth_of_the_insured_36, q2_.quotation_date_expiration AS quotation_date_expiration_37, q2_.cmu_status AS cmu_status_38, q2_.social_security_statement_flag AS social_security_statement_flag_39, q2_.invoice_number AS invoice_number_40, q2_.invoice_date AS invoice_date_41, q2_.invoice_amount AS invoice_amount_42, q2_.skip_auto_invoicing AS skip_auto_invoicing_43, q2_.invoiced_by_fulldevis AS invoiced_by_fulldevis_44, q2_.followup_status AS followup_status_45, q2_.last_followup_at AS last_followup_at_46, q2_.relance_count AS relance_count_47, q2_.id AS id_48, q0_.comment_id AS comment_id_49, q0_.quotation_id AS quotation_id_50, q0_.user_id AS user_id_51, q2_.user_id AS user_id_52, q2_.centre_id AS centre_id_53, q2_.patient_id AS patient_id_54, q2_.practitioner_id AS practitioner_id_55, q2_.social_security_percentage_id AS social_security_percentage_id_56 FROM quotation_synchro_comment q0_ INNER JOIN synchro_comment s1_ ON q0_.comment_id = s1_.id INNER JOIN quotation q2_ ON q0_.quotation_id = q2_.id WHERE q2_.id = ? AND LOWER(s1_.comment) LIKE ? ORDER BY q0_.created_at DESC LIMIT 1
SELECT t0.tooth_number AS tooth_number_1, t0.amount AS amount_2, t0.bss_amount AS bss_amount_3, t0.ccam AS ccam_4, t0.amo_amount AS amo_amount_5, t0.rc_amount AS rc_amount_6, t0.rac_amount AS rac_amount_7, t0.taux_remboursement AS taux_remboursement_8, t0.platform AS platform_9, t0.id AS id_10, t0.quotation_id AS quotation_id_11 FROM pec_quotation_details t0 WHERE t0.quotation_id = ?
SELECT t0.tooth_number AS tooth_number_1, t0.amount AS amount_2, t0.ccam AS ccam_3, t0.id AS id_4, t0.quotation_id AS quotation_id_5 FROM invoice_quotation_details t0 WHERE t0.quotation_id = ?
SELECT t0.value AS value_1, t0.id AS id_2 FROM social_security_percentage t0 WHERE t0.id = ?
SELECT t0.file_number AS file_number_1, t0.civility AS civility_2, t0.last_name AS last_name_3, t0.first_name AS first_name_4, t0.phone AS phone_5, t0.mobile_phone AS mobile_phone_6, t0.email AS email_7, t0.social_security_number AS social_security_number_8, t0.membership_number AS membership_number_9, t0.status AS status_10, t0.accept_sms AS accept_sms_11, t0.dob AS dob_12, t0.id AS id_13, t0.centre_id AS centre_id_14 FROM patient t0 WHERE t0.id = ?

#▲	Time	Info
1	0.63 ms	SELECT t0.civility AS civility_1, t0.first_name AS first_name_2, t0.last_name AS last_name_3, t0.login AS login_4, t0.password AS password_5, t0.email AS email_6, t0.phone AS phone_7, t0.mobile_phone AS mobile_phone_8, t0.contact AS contact_9, t0.status AS status_10, t0.first_login AS first_login_11, t0.avatar AS avatar_12, t0.token AS token_13, t0.token_created_at AS token_created_at_14, t0.id AS id_15, t0.role_id AS role_id_16, t0.group_id AS group_id_17 FROM user t0 WHERE t0.id = ? Parameters: [`1046`] View formatted query View runnable query Explain query SELECT t0.civility AS civility_1, t0.first_name AS first_name_2, t0.last_name AS last_name_3, t0.login AS login_4, t0.password AS password_5, t0.email AS email_6, t0.phone AS phone_7, t0.mobile_phone AS mobile_phone_8, t0.contact AS contact_9, t0.status AS status_10, t0.first_login AS first_login_11, t0.avatar AS avatar_12, t0.token AS token_13, t0.token_created_at AS token_created_at_14, t0.id AS id_15, t0.role_id AS role_id_16, t0.group_id AS group_id_17 FROM user t0 WHERE t0.id = ? SELECT t0.civility AS civility_1, t0.first_name AS first_name_2, t0.last_name AS last_name_3, t0.login AS login_4, t0.password AS password_5, t0.email AS email_6, t0.phone AS phone_7, t0.mobile_phone AS mobile_phone_8, t0.contact AS contact_9, t0.status AS status_10, t0.first_login AS first_login_11, t0.avatar AS avatar_12, t0.token AS token_13, t0.token_created_at AS token_created_at_14, t0.id AS id_15, t0.role_id AS role_id_16, t0.group_id AS group_id_17 FROM user t0 WHERE t0.id = 1046;
2	0.60 ms	SELECT t0.name AS name_1, t0.label AS label_2, t0.id AS id_3, t4.civility AS civility_5, t4.first_name AS first_name_6, t4.last_name AS last_name_7, t4.login AS login_8, t4.password AS password_9, t4.email AS email_10, t4.phone AS phone_11, t4.mobile_phone AS mobile_phone_12, t4.contact AS contact_13, t4.status AS status_14, t4.first_login AS first_login_15, t4.avatar AS avatar_16, t4.token AS token_17, t4.token_created_at AS token_created_at_18, t4.id AS id_19, t4.role_id AS role_id_20, t4.group_id AS group_id_21, t0.parent AS parent_22 FROM role t0 LEFT JOIN user t4 ON t4.role_id = t0.id WHERE t0.id = ? Parameters: [`8`] View formatted query View runnable query Explain query SELECT t0.name AS name_1, t0.label AS label_2, t0.id AS id_3, t4.civility AS civility_5, t4.first_name AS first_name_6, t4.last_name AS last_name_7, t4.login AS login_8, t4.password AS password_9, t4.email AS email_10, t4.phone AS phone_11, t4.mobile_phone AS mobile_phone_12, t4.contact AS contact_13, t4.status AS status_14, t4.first_login AS first_login_15, t4.avatar AS avatar_16, t4.token AS token_17, t4.token_created_at AS token_created_at_18, t4.id AS id_19, t4.role_id AS role_id_20, t4.group_id AS group_id_21, t0.parent AS parent_22 FROM role t0 LEFT JOIN user t4 ON t4.role_id = t0.id WHERE t0.id = ? SELECT t0.name AS name_1, t0.label AS label_2, t0.id AS id_3, t4.civility AS civility_5, t4.first_name AS first_name_6, t4.last_name AS last_name_7, t4.login AS login_8, t4.password AS password_9, t4.email AS email_10, t4.phone AS phone_11, t4.mobile_phone AS mobile_phone_12, t4.contact AS contact_13, t4.status AS status_14, t4.first_login AS first_login_15, t4.avatar AS avatar_16, t4.token AS token_17, t4.token_created_at AS token_created_at_18, t4.id AS id_19, t4.role_id AS role_id_20, t4.group_id AS group_id_21, t0.parent AS parent_22 FROM role t0 LEFT JOIN user t4 ON t4.role_id = t0.id WHERE t0.id = 8;
3	0.88 ms	SELECT c0_.date AS date_0, c0_.first_connection_time AS first_connection_time_1, c0_.last_connection_time AS last_connection_time_2, c0_.last_action_time AS last_action_time_3, c0_.last_disconnection_time AS last_disconnection_time_4, c0_.total_duration AS total_duration_5, c0_.session_count AS session_count_6, c0_.active AS active_7, c0_.id AS id_8, c0_.user_id AS user_id_9 FROM connection_history c0_ INNER JOIN user u1_ ON c0_.user_id = u1_.id WHERE u1_.id = ? ORDER BY c0_.date DESC LIMIT 1 Parameters: [`1046`] View formatted query View runnable query Explain query SELECT c0_.date AS date_0, c0_.first_connection_time AS first_connection_time_1, c0_.last_connection_time AS last_connection_time_2, c0_.last_action_time AS last_action_time_3, c0_.last_disconnection_time AS last_disconnection_time_4, c0_.total_duration AS total_duration_5, c0_.session_count AS session_count_6, c0_.active AS active_7, c0_.id AS id_8, c0_.user_id AS user_id_9 FROM connection_history c0_ INNER JOIN user u1_ ON c0_.user_id = u1_.id WHERE u1_.id = ? ORDER BY c0_.date DESC LIMIT 1 SELECT c0_.date AS date_0, c0_.first_connection_time AS first_connection_time_1, c0_.last_connection_time AS last_connection_time_2, c0_.last_action_time AS last_action_time_3, c0_.last_disconnection_time AS last_disconnection_time_4, c0_.total_duration AS total_duration_5, c0_.session_count AS session_count_6, c0_.active AS active_7, c0_.id AS id_8, c0_.user_id AS user_id_9 FROM connection_history c0_ INNER JOIN user u1_ ON c0_.user_id = u1_.id WHERE u1_.id = 1046 ORDER BY c0_.date DESC LIMIT 1;
4	0.40 ms	SELECT t0.date AS date_1, t0.first_connection_time AS first_connection_time_2, t0.last_connection_time AS last_connection_time_3, t0.last_action_time AS last_action_time_4, t0.last_disconnection_time AS last_disconnection_time_5, t0.total_duration AS total_duration_6, t0.session_count AS session_count_7, t0.active AS active_8, t0.id AS id_9, t0.user_id AS user_id_10 FROM connection_history t0 WHERE t0.user_id = ? AND t0.date = ? LIMIT 1 Parameters: [`1046 "2026-04-25"`] View formatted query View runnable query Explain query SELECT t0.date AS date_1, t0.first_connection_time AS first_connection_time_2, t0.last_connection_time AS last_connection_time_3, t0.last_action_time AS last_action_time_4, t0.last_disconnection_time AS last_disconnection_time_5, t0.total_duration AS total_duration_6, t0.session_count AS session_count_7, t0.active AS active_8, t0.id AS id_9, t0.user_id AS user_id_10 FROM connection_history t0 WHERE t0.user_id = ? AND t0.date = ? LIMIT 1 SELECT t0.date AS date_1, t0.first_connection_time AS first_connection_time_2, t0.last_connection_time AS last_connection_time_3, t0.last_action_time AS last_action_time_4, t0.last_disconnection_time AS last_disconnection_time_5, t0.total_duration AS total_duration_6, t0.session_count AS session_count_7, t0.active AS active_8, t0.id AS id_9, t0.user_id AS user_id_10 FROM connection_history t0 WHERE t0.user_id = 1046 AND t0.date = '2026-04-25' LIMIT 1;
5	0.22 ms	"START TRANSACTION" Parameters: [] View formatted query View runnable query Explain query "START TRANSACTION" "START TRANSACTION";
6	0.46 ms	UPDATE connection_history SET last_action_time = ? WHERE id = ? Parameters: [`"2026-04-25 17:49:33" 97688`] View formatted query View runnable query Explain query UPDATE connection_history SET last_action_time = ? WHERE id = ? UPDATE connection_history SET last_action_time = '2026-04-25 17:49:33' WHERE id = 97688;
7	1.38 ms	"COMMIT" Parameters: [] View formatted query View runnable query Explain query "COMMIT" "COMMIT";
8	0.74 ms	SELECT t0.number AS number_1, t0.amc_number AS amc_number_2, t0.created_at AS created_at_3, t0.date_recall AS date_recall_4, t0.date_visit AS date_visit_5, t0.date_quotation AS date_quotation_6, t0.amount AS amount_7, t0.amo_amount AS amo_amount_8, t0.pec_amo_amount AS pec_amo_amount_9, t0.manager_amount AS manager_amount_10, t0.client_amount AS client_amount_11, t0.date_expired AS date_expired_12, t0.date_reject AS date_reject_13, t0.priority AS priority_14, t0.billing_status AS billing_status_15, t0.billing_excluded AS billing_excluded_16, t0.online AS online_17, t0.ortodontics AS ortodontics_18, t0.date_pec_requested AS date_pec_requested_19, t0.date_pec_responded AS date_pec_responded_20, t0.sms_for_patient AS sms_for_patient_21, t0.updated_at AS updated_at_22, t0.next_system_action AS next_system_action_23, t0.date_next_system_action AS date_next_system_action_24, t0.date_pec_acknowledged AS date_pec_acknowledged_25, t0.acknowledgement_reference AS acknowledgement_reference_26, t0.social_security_bases AS social_security_bases_27, t0.contract_number AS contract_number_28, t0.name_of_the_insured AS name_of_the_insured_29, t0.surname_of_the_insured AS surname_of_the_insured_30, t0.date_of_birth_of_the_insured AS date_of_birth_of_the_insured_31, t0.quotation_date_expiration AS quotation_date_expiration_32, t0.cmu_status AS cmu_status_33, t0.social_security_statement_flag AS social_security_statement_flag_34, t0.invoice_number AS invoice_number_35, t0.invoice_date AS invoice_date_36, t0.invoice_amount AS invoice_amount_37, t0.skip_auto_invoicing AS skip_auto_invoicing_38, t0.invoiced_by_fulldevis AS invoiced_by_fulldevis_39, t0.followup_status AS followup_status_40, t0.last_followup_at AS last_followup_at_41, t0.relance_count AS relance_count_42, t0.id AS id_43, t44.confirmed AS confirmed_45, t44.updated_at AS updated_at_46, t44.created_at AS created_at_47, t44.id AS id_48, t44.quotation_id AS quotation_id_49, t44.created_by_id AS created_by_id_50, t44.confirmed_by_id AS confirmed_by_id_51, t52.dre_number AS dre_number_53, t52.fse_number AS fse_number_54, t52.status_ro AS status_ro_55, t52.status_rc AS status_rc_56, t52.status_pp AS status_pp_57, t52.sent_date_ro AS sent_date_ro_58, t52.settled_date_ro AS settled_date_ro_59, t52.rejected_date_ro AS rejected_date_ro_60, t52.cancelled_date_ro AS cancelled_date_ro_61, t52.sent_date_rc AS sent_date_rc_62, t52.settled_date_rc AS settled_date_rc_63, t52.rejected_date_rc AS rejected_date_rc_64, t52.cancelled_date_rc AS cancelled_date_rc_65, t52.invoice_ro_amount AS invoice_ro_amount_66, t52.invoice_ro_paid_amount AS invoice_ro_paid_amount_67, t52.invoice_rc_amount AS invoice_rc_amount_68, t52.invoice_rc_paid_amount AS invoice_rc_paid_amount_69, t52.invoice_pp_amount AS invoice_pp_amount_70, t52.invoice_pp_paid_amount AS invoice_pp_paid_amount_71, t52.invoice_synchro_comment AS invoice_synchro_comment_72, t52.ro_label AS ro_label_73, t52.rc_label AS rc_label_74, t52.id AS id_75, t52.quotation_id AS quotation_id_76, t0.user_id AS user_id_77, t0.centre_id AS centre_id_78, t0.patient_id AS patient_id_79, t0.practitioner_id AS practitioner_id_80, t0.social_security_percentage_id AS social_security_percentage_id_81 FROM quotation t0 LEFT JOIN quotation_no_further_action t44 ON t44.quotation_id = t0.id LEFT JOIN invoicing_quotation_details t52 ON t52.quotation_id = t0.id WHERE t0.id = ? Parameters: [`303241`] View formatted query View runnable query Explain query SELECT t0.number AS number_1, t0.amc_number AS amc_number_2, t0.created_at AS created_at_3, t0.date_recall AS date_recall_4, t0.date_visit AS date_visit_5, t0.date_quotation AS date_quotation_6, t0.amount AS amount_7, t0.amo_amount AS amo_amount_8, t0.pec_amo_amount AS pec_amo_amount_9, t0.manager_amount AS manager_amount_10, t0.client_amount AS client_amount_11, t0.date_expired AS date_expired_12, t0.date_reject AS date_reject_13, t0.priority AS priority_14, t0.billing_status AS billing_status_15, t0.billing_excluded AS billing_excluded_16, t0.online AS online_17, t0.ortodontics AS ortodontics_18, t0.date_pec_requested AS date_pec_requested_19, t0.date_pec_responded AS date_pec_responded_20, t0.sms_for_patient AS sms_for_patient_21, t0.updated_at AS updated_at_22, t0.next_system_action AS next_system_action_23, t0.date_next_system_action AS date_next_system_action_24, t0.date_pec_acknowledged AS date_pec_acknowledged_25, t0.acknowledgement_reference AS acknowledgement_reference_26, t0.social_security_bases AS social_security_bases_27, t0.contract_number AS contract_number_28, t0.name_of_the_insured AS name_of_the_insured_29, t0.surname_of_the_insured AS surname_of_the_insured_30, t0.date_of_birth_of_the_insured AS date_of_birth_of_the_insured_31, t0.quotation_date_expiration AS quotation_date_expiration_32, t0.cmu_status AS cmu_status_33, t0.social_security_statement_flag AS social_security_statement_flag_34, t0.invoice_number AS invoice_number_35, t0.invoice_date AS invoice_date_36, t0.invoice_amount AS invoice_amount_37, t0.skip_auto_invoicing AS skip_auto_invoicing_38, t0.invoiced_by_fulldevis AS invoiced_by_fulldevis_39, t0.followup_status AS followup_status_40, t0.last_followup_at AS last_followup_at_41, t0.relance_count AS relance_count_42, t0.id AS id_43, t44.confirmed AS confirmed_45, t44.updated_at AS updated_at_46, t44.created_at AS created_at_47, t44.id AS id_48, t44.quotation_id AS quotation_id_49, t44.created_by_id AS created_by_id_50, t44.confirmed_by_id AS confirmed_by_id_51, t52.dre_number AS dre_number_53, t52.fse_number AS fse_number_54, t52.status_ro AS status_ro_55, t52.status_rc AS status_rc_56, t52.status_pp AS status_pp_57, t52.sent_date_ro AS sent_date_ro_58, t52.settled_date_ro AS settled_date_ro_59, t52.rejected_date_ro AS rejected_date_ro_60, t52.cancelled_date_ro AS cancelled_date_ro_61, t52.sent_date_rc AS sent_date_rc_62, t52.settled_date_rc AS settled_date_rc_63, t52.rejected_date_rc AS rejected_date_rc_64, t52.cancelled_date_rc AS cancelled_date_rc_65, t52.invoice_ro_amount AS invoice_ro_amount_66, t52.invoice_ro_paid_amount AS invoice_ro_paid_amount_67, t52.invoice_rc_amount AS invoice_rc_amount_68, t52.invoice_rc_paid_amount AS invoice_rc_paid_amount_69, t52.invoice_pp_amount AS invoice_pp_amount_70, t52.invoice_pp_paid_amount AS invoice_pp_paid_amount_71, t52.invoice_synchro_comment AS invoice_synchro_comment_72, t52.ro_label AS ro_label_73, t52.rc_label AS rc_label_74, t52.id AS id_75, t52.quotation_id AS quotation_id_76, t0.user_id AS user_id_77, t0.centre_id AS centre_id_78, t0.patient_id AS patient_id_79, t0.practitioner_id AS practitioner_id_80, t0.social_security_percentage_id AS social_security_percentage_id_81 FROM quotation t0 LEFT JOIN quotation_no_further_action t44 ON t44.quotation_id = t0.id LEFT JOIN invoicing_quotation_details t52 ON t52.quotation_id = t0.id WHERE t0.id = ? SELECT t0.number AS number_1, t0.amc_number AS amc_number_2, t0.created_at AS created_at_3, t0.date_recall AS date_recall_4, t0.date_visit AS date_visit_5, t0.date_quotation AS date_quotation_6, t0.amount AS amount_7, t0.amo_amount AS amo_amount_8, t0.pec_amo_amount AS pec_amo_amount_9, t0.manager_amount AS manager_amount_10, t0.client_amount AS client_amount_11, t0.date_expired AS date_expired_12, t0.date_reject AS date_reject_13, t0.priority AS priority_14, t0.billing_status AS billing_status_15, t0.billing_excluded AS billing_excluded_16, t0.online AS online_17, t0.ortodontics AS ortodontics_18, t0.date_pec_requested AS date_pec_requested_19, t0.date_pec_responded AS date_pec_responded_20, t0.sms_for_patient AS sms_for_patient_21, t0.updated_at AS updated_at_22, t0.next_system_action AS next_system_action_23, t0.date_next_system_action AS date_next_system_action_24, t0.date_pec_acknowledged AS date_pec_acknowledged_25, t0.acknowledgement_reference AS acknowledgement_reference_26, t0.social_security_bases AS social_security_bases_27, t0.contract_number AS contract_number_28, t0.name_of_the_insured AS name_of_the_insured_29, t0.surname_of_the_insured AS surname_of_the_insured_30, t0.date_of_birth_of_the_insured AS date_of_birth_of_the_insured_31, t0.quotation_date_expiration AS quotation_date_expiration_32, t0.cmu_status AS cmu_status_33, t0.social_security_statement_flag AS social_security_statement_flag_34, t0.invoice_number AS invoice_number_35, t0.invoice_date AS invoice_date_36, t0.invoice_amount AS invoice_amount_37, t0.skip_auto_invoicing AS skip_auto_invoicing_38, t0.invoiced_by_fulldevis AS invoiced_by_fulldevis_39, t0.followup_status AS followup_status_40, t0.last_followup_at AS last_followup_at_41, t0.relance_count AS relance_count_42, t0.id AS id_43, t44.confirmed AS confirmed_45, t44.updated_at AS updated_at_46, t44.created_at AS created_at_47, t44.id AS id_48, t44.quotation_id AS quotation_id_49, t44.created_by_id AS created_by_id_50, t44.confirmed_by_id AS confirmed_by_id_51, t52.dre_number AS dre_number_53, t52.fse_number AS fse_number_54, t52.status_ro AS status_ro_55, t52.status_rc AS status_rc_56, t52.status_pp AS status_pp_57, t52.sent_date_ro AS sent_date_ro_58, t52.settled_date_ro AS settled_date_ro_59, t52.rejected_date_ro AS rejected_date_ro_60, t52.cancelled_date_ro AS cancelled_date_ro_61, t52.sent_date_rc AS sent_date_rc_62, t52.settled_date_rc AS settled_date_rc_63, t52.rejected_date_rc AS rejected_date_rc_64, t52.cancelled_date_rc AS cancelled_date_rc_65, t52.invoice_ro_amount AS invoice_ro_amount_66, t52.invoice_ro_paid_amount AS invoice_ro_paid_amount_67, t52.invoice_rc_amount AS invoice_rc_amount_68, t52.invoice_rc_paid_amount AS invoice_rc_paid_amount_69, t52.invoice_pp_amount AS invoice_pp_amount_70, t52.invoice_pp_paid_amount AS invoice_pp_paid_amount_71, t52.invoice_synchro_comment AS invoice_synchro_comment_72, t52.ro_label AS ro_label_73, t52.rc_label AS rc_label_74, t52.id AS id_75, t52.quotation_id AS quotation_id_76, t0.user_id AS user_id_77, t0.centre_id AS centre_id_78, t0.patient_id AS patient_id_79, t0.practitioner_id AS practitioner_id_80, t0.social_security_percentage_id AS social_security_percentage_id_81 FROM quotation t0 LEFT JOIN quotation_no_further_action t44 ON t44.quotation_id = t0.id LEFT JOIN invoicing_quotation_details t52 ON t52.quotation_id = t0.id WHERE t0.id = 303241;
9	0.55 ms	SELECT t0.by_email AS by_email_1, t0.online AS online_2, t0.by_fax AS by_fax_3, t0.by_letter AS by_letter_4, t0.id AS id_5, t0.quotation_id AS quotation_id_6, t0.insurance_company_id AS insurance_company_id_7, t0.address_id AS address_id_8 FROM quotation_insurance_company t0 WHERE t0.quotation_id = ? Parameters: [`303241`] View formatted query View runnable query Explain query SELECT t0.by_email AS by_email_1, t0.online AS online_2, t0.by_fax AS by_fax_3, t0.by_letter AS by_letter_4, t0.id AS id_5, t0.quotation_id AS quotation_id_6, t0.insurance_company_id AS insurance_company_id_7, t0.address_id AS address_id_8 FROM quotation_insurance_company t0 WHERE t0.quotation_id = ? SELECT t0.by_email AS by_email_1, t0.online AS online_2, t0.by_fax AS by_fax_3, t0.by_letter AS by_letter_4, t0.id AS id_5, t0.quotation_id AS quotation_id_6, t0.insurance_company_id AS insurance_company_id_7, t0.address_id AS address_id_8 FROM quotation_insurance_company t0 WHERE t0.quotation_id = 303241;
10	0.53 ms	SELECT r0_.alias AS alias_0 FROM rule r0_ Parameters: [] View formatted query View runnable query Explain query SELECT r0_.alias AS alias_0 FROM rule r0_ SELECT r0_.alias AS alias_0 FROM rule r0_;
11	0.53 ms	SELECT t0.name AS name_1, t0.finess AS finess_2, t0.login AS login_3, t0.password AS password_4, t0.address AS address_5, t0.city AS city_6, t0.postal_code AS postal_code_7, t0.phone AS phone_8, t0.fax AS fax_9, t0.email AS email_10, t0.saps_email AS saps_email_11, t0.saps_password AS saps_password_12, t0.quotation_price AS quotation_price_13, t0.estimated_price AS estimated_price_14, t0.subscription_price AS subscription_price_15, t0.billing_excluded AS billing_excluded_16, t0.subscription_excluded AS subscription_excluded_17, t0.multi_centre AS multi_centre_18, t0.invoicing AS invoicing_19, t0.bank_score AS bank_score_20, t0.status AS status_21, t0.start_date AS start_date_22, t0.enable_ocr AS enable_ocr_23, t0.email_comptable AS email_comptable_24, t0.cabinet_status AS cabinet_status_25, t0.insurance_agreement_status AS insurance_agreement_status_26, t0.id AS id_27, t28.id_externe AS id_externe_29, t28.desmos AS desmos_30, t28.veasy AS veasy_31, t28.doctolib AS doctolib_32, t28.id AS id_33, t28.centre_id AS centre_id_34, t0.creator_group_id AS creator_group_id_35, t0.group_id AS group_id_36, t0.contact_id AS contact_id_37 FROM centre t0 LEFT JOIN centre_mapping t28 ON t28.centre_id = t0.id WHERE t0.id = ? Parameters: [`125`] View formatted query View runnable query Explain query SELECT t0.name AS name_1, t0.finess AS finess_2, t0.login AS login_3, t0.password AS password_4, t0.address AS address_5, t0.city AS city_6, t0.postal_code AS postal_code_7, t0.phone AS phone_8, t0.fax AS fax_9, t0.email AS email_10, t0.saps_email AS saps_email_11, t0.saps_password AS saps_password_12, t0.quotation_price AS quotation_price_13, t0.estimated_price AS estimated_price_14, t0.subscription_price AS subscription_price_15, t0.billing_excluded AS billing_excluded_16, t0.subscription_excluded AS subscription_excluded_17, t0.multi_centre AS multi_centre_18, t0.invoicing AS invoicing_19, t0.bank_score AS bank_score_20, t0.status AS status_21, t0.start_date AS start_date_22, t0.enable_ocr AS enable_ocr_23, t0.email_comptable AS email_comptable_24, t0.cabinet_status AS cabinet_status_25, t0.insurance_agreement_status AS insurance_agreement_status_26, t0.id AS id_27, t28.id_externe AS id_externe_29, t28.desmos AS desmos_30, t28.veasy AS veasy_31, t28.doctolib AS doctolib_32, t28.id AS id_33, t28.centre_id AS centre_id_34, t0.creator_group_id AS creator_group_id_35, t0.group_id AS group_id_36, t0.contact_id AS contact_id_37 FROM centre t0 LEFT JOIN centre_mapping t28 ON t28.centre_id = t0.id WHERE t0.id = ? SELECT t0.name AS name_1, t0.finess AS finess_2, t0.login AS login_3, t0.password AS password_4, t0.address AS address_5, t0.city AS city_6, t0.postal_code AS postal_code_7, t0.phone AS phone_8, t0.fax AS fax_9, t0.email AS email_10, t0.saps_email AS saps_email_11, t0.saps_password AS saps_password_12, t0.quotation_price AS quotation_price_13, t0.estimated_price AS estimated_price_14, t0.subscription_price AS subscription_price_15, t0.billing_excluded AS billing_excluded_16, t0.subscription_excluded AS subscription_excluded_17, t0.multi_centre AS multi_centre_18, t0.invoicing AS invoicing_19, t0.bank_score AS bank_score_20, t0.status AS status_21, t0.start_date AS start_date_22, t0.enable_ocr AS enable_ocr_23, t0.email_comptable AS email_comptable_24, t0.cabinet_status AS cabinet_status_25, t0.insurance_agreement_status AS insurance_agreement_status_26, t0.id AS id_27, t28.id_externe AS id_externe_29, t28.desmos AS desmos_30, t28.veasy AS veasy_31, t28.doctolib AS doctolib_32, t28.id AS id_33, t28.centre_id AS centre_id_34, t0.creator_group_id AS creator_group_id_35, t0.group_id AS group_id_36, t0.contact_id AS contact_id_37 FROM centre t0 LEFT JOIN centre_mapping t28 ON t28.centre_id = t0.id WHERE t0.id = 125;
12	0.71 ms	SELECT d0_.name AS name_0, d0_.created_at AS created_at_1, d0_.visit_date AS visit_date_2, d0_.bounded_at AS bounded_at_3, d0_.signed_by_patient AS signed_by_patient_4, d0_.signed_by_centre AS signed_by_centre_5, d0_.signed_by_patient_at AS signed_by_patient_at_6, d0_.signed_by_centre_at AS signed_by_centre_at_7, d0_.refused_by_patient AS refused_by_patient_8, d0_.refused_by_patient_at AS refused_by_patient_at_9, d0_.sent_to_patient_to_sign AS sent_to_patient_to_sign_10, d0_.sent_to_patient_to_sign_at AS sent_to_patient_to_sign_at_11, d0_.id AS id_12, q1_.number AS number_13, q1_.amc_number AS amc_number_14, q1_.created_at AS created_at_15, q1_.date_recall AS date_recall_16, q1_.date_visit AS date_visit_17, q1_.date_quotation AS date_quotation_18, q1_.amount AS amount_19, q1_.amo_amount AS amo_amount_20, q1_.pec_amo_amount AS pec_amo_amount_21, q1_.manager_amount AS manager_amount_22, q1_.client_amount AS client_amount_23, q1_.date_expired AS date_expired_24, q1_.date_reject AS date_reject_25, q1_.priority AS priority_26, q1_.billing_status AS billing_status_27, q1_.billing_excluded AS billing_excluded_28, q1_.online AS online_29, q1_.ortodontics AS ortodontics_30, q1_.date_pec_requested AS date_pec_requested_31, q1_.date_pec_responded AS date_pec_responded_32, q1_.sms_for_patient AS sms_for_patient_33, q1_.updated_at AS updated_at_34, q1_.next_system_action AS next_system_action_35, q1_.date_next_system_action AS date_next_system_action_36, q1_.date_pec_acknowledged AS date_pec_acknowledged_37, q1_.acknowledgement_reference AS acknowledgement_reference_38, q1_.social_security_bases AS social_security_bases_39, q1_.contract_number AS contract_number_40, q1_.name_of_the_insured AS name_of_the_insured_41, q1_.surname_of_the_insured AS surname_of_the_insured_42, q1_.date_of_birth_of_the_insured AS date_of_birth_of_the_insured_43, q1_.quotation_date_expiration AS quotation_date_expiration_44, q1_.cmu_status AS cmu_status_45, q1_.social_security_statement_flag AS social_security_statement_flag_46, q1_.invoice_number AS invoice_number_47, q1_.invoice_date AS invoice_date_48, q1_.invoice_amount AS invoice_amount_49, q1_.skip_auto_invoicing AS skip_auto_invoicing_50, q1_.invoiced_by_fulldevis AS invoiced_by_fulldevis_51, q1_.followup_status AS followup_status_52, q1_.last_followup_at AS last_followup_at_53, q1_.relance_count AS relance_count_54, q1_.id AS id_55, d2_.name AS name_56, d2_.label AS label_57, d2_.order_by AS order_by_58, d2_.id AS id_59, d0_.user_id AS user_id_60, d0_.type_id AS type_id_61, d0_.quotation_status_id AS quotation_status_id_62, d0_.comment_id AS comment_id_63, d0_.quotation_id AS quotation_id_64, d0_.patient_id AS patient_id_65, d0_.centre_id AS centre_id_66, d0_.signed_by_centre_user_id AS signed_by_centre_user_id_67, d0_.signed_by_patient_user_id AS signed_by_patient_user_id_68, d0_.second_user_id AS second_user_id_69, q1_.user_id AS user_id_70, q1_.centre_id AS centre_id_71, q1_.patient_id AS patient_id_72, q1_.practitioner_id AS practitioner_id_73, q1_.social_security_percentage_id AS social_security_percentage_id_74 FROM document d0_ INNER JOIN quotation q1_ ON d0_.quotation_id = q1_.id INNER JOIN document_type d2_ ON d0_.type_id = d2_.id WHERE q1_.id = ? AND d2_.name = ? ORDER BY d0_.created_at DESC LIMIT 1 Parameters: [`303241 "insurance_doc_not_signed"`] View formatted query View runnable query Explain query SELECT d0_.name AS name_0, d0_.created_at AS created_at_1, d0_.visit_date AS visit_date_2, d0_.bounded_at AS bounded_at_3, d0_.signed_by_patient AS signed_by_patient_4, d0_.signed_by_centre AS signed_by_centre_5, d0_.signed_by_patient_at AS signed_by_patient_at_6, d0_.signed_by_centre_at AS signed_by_centre_at_7, d0_.refused_by_patient AS refused_by_patient_8, d0_.refused_by_patient_at AS refused_by_patient_at_9, d0_.sent_to_patient_to_sign AS sent_to_patient_to_sign_10, d0_.sent_to_patient_to_sign_at AS sent_to_patient_to_sign_at_11, d0_.id AS id_12, q1_.number AS number_13, q1_.amc_number AS amc_number_14, q1_.created_at AS created_at_15, q1_.date_recall AS date_recall_16, q1_.date_visit AS date_visit_17, q1_.date_quotation AS date_quotation_18, q1_.amount AS amount_19, q1_.amo_amount AS amo_amount_20, q1_.pec_amo_amount AS pec_amo_amount_21, q1_.manager_amount AS manager_amount_22, q1_.client_amount AS client_amount_23, q1_.date_expired AS date_expired_24, q1_.date_reject AS date_reject_25, q1_.priority AS priority_26, q1_.billing_status AS billing_status_27, q1_.billing_excluded AS billing_excluded_28, q1_.online AS online_29, q1_.ortodontics AS ortodontics_30, q1_.date_pec_requested AS date_pec_requested_31, q1_.date_pec_responded AS date_pec_responded_32, q1_.sms_for_patient AS sms_for_patient_33, q1_.updated_at AS updated_at_34, q1_.next_system_action AS next_system_action_35, q1_.date_next_system_action AS date_next_system_action_36, q1_.date_pec_acknowledged AS date_pec_acknowledged_37, q1_.acknowledgement_reference AS acknowledgement_reference_38, q1_.social_security_bases AS social_security_bases_39, q1_.contract_number AS contract_number_40, q1_.name_of_the_insured AS name_of_the_insured_41, q1_.surname_of_the_insured AS surname_of_the_insured_42, q1_.date_of_birth_of_the_insured AS date_of_birth_of_the_insured_43, q1_.quotation_date_expiration AS quotation_date_expiration_44, q1_.cmu_status AS cmu_status_45, q1_.social_security_statement_flag AS social_security_statement_flag_46, q1_.invoice_number AS invoice_number_47, q1_.invoice_date AS invoice_date_48, q1_.invoice_amount AS invoice_amount_49, q1_.skip_auto_invoicing AS skip_auto_invoicing_50, q1_.invoiced_by_fulldevis AS invoiced_by_fulldevis_51, q1_.followup_status AS followup_status_52, q1_.last_followup_at AS last_followup_at_53, q1_.relance_count AS relance_count_54, q1_.id AS id_55, d2_.name AS name_56, d2_.label AS label_57, d2_.order_by AS order_by_58, d2_.id AS id_59, d0_.user_id AS user_id_60, d0_.type_id AS type_id_61, d0_.quotation_status_id AS quotation_status_id_62, d0_.comment_id AS comment_id_63, d0_.quotation_id AS quotation_id_64, d0_.patient_id AS patient_id_65, d0_.centre_id AS centre_id_66, d0_.signed_by_centre_user_id AS signed_by_centre_user_id_67, d0_.signed_by_patient_user_id AS signed_by_patient_user_id_68, d0_.second_user_id AS second_user_id_69, q1_.user_id AS user_id_70, q1_.centre_id AS centre_id_71, q1_.patient_id AS patient_id_72, q1_.practitioner_id AS practitioner_id_73, q1_.social_security_percentage_id AS social_security_percentage_id_74 FROM document d0_ INNER JOIN quotation q1_ ON d0_.quotation_id = q1_.id INNER JOIN document_type d2_ ON d0_.type_id = d2_.id WHERE q1_.id = ? AND d2_.name = ? ORDER BY d0_.created_at DESC LIMIT 1 SELECT d0_.name AS name_0, d0_.created_at AS created_at_1, d0_.visit_date AS visit_date_2, d0_.bounded_at AS bounded_at_3, d0_.signed_by_patient AS signed_by_patient_4, d0_.signed_by_centre AS signed_by_centre_5, d0_.signed_by_patient_at AS signed_by_patient_at_6, d0_.signed_by_centre_at AS signed_by_centre_at_7, d0_.refused_by_patient AS refused_by_patient_8, d0_.refused_by_patient_at AS refused_by_patient_at_9, d0_.sent_to_patient_to_sign AS sent_to_patient_to_sign_10, d0_.sent_to_patient_to_sign_at AS sent_to_patient_to_sign_at_11, d0_.id AS id_12, q1_.number AS number_13, q1_.amc_number AS amc_number_14, q1_.created_at AS created_at_15, q1_.date_recall AS date_recall_16, q1_.date_visit AS date_visit_17, q1_.date_quotation AS date_quotation_18, q1_.amount AS amount_19, q1_.amo_amount AS amo_amount_20, q1_.pec_amo_amount AS pec_amo_amount_21, q1_.manager_amount AS manager_amount_22, q1_.client_amount AS client_amount_23, q1_.date_expired AS date_expired_24, q1_.date_reject AS date_reject_25, q1_.priority AS priority_26, q1_.billing_status AS billing_status_27, q1_.billing_excluded AS billing_excluded_28, q1_.online AS online_29, q1_.ortodontics AS ortodontics_30, q1_.date_pec_requested AS date_pec_requested_31, q1_.date_pec_responded AS date_pec_responded_32, q1_.sms_for_patient AS sms_for_patient_33, q1_.updated_at AS updated_at_34, q1_.next_system_action AS next_system_action_35, q1_.date_next_system_action AS date_next_system_action_36, q1_.date_pec_acknowledged AS date_pec_acknowledged_37, q1_.acknowledgement_reference AS acknowledgement_reference_38, q1_.social_security_bases AS social_security_bases_39, q1_.contract_number AS contract_number_40, q1_.name_of_the_insured AS name_of_the_insured_41, q1_.surname_of_the_insured AS surname_of_the_insured_42, q1_.date_of_birth_of_the_insured AS date_of_birth_of_the_insured_43, q1_.quotation_date_expiration AS quotation_date_expiration_44, q1_.cmu_status AS cmu_status_45, q1_.social_security_statement_flag AS social_security_statement_flag_46, q1_.invoice_number AS invoice_number_47, q1_.invoice_date AS invoice_date_48, q1_.invoice_amount AS invoice_amount_49, q1_.skip_auto_invoicing AS skip_auto_invoicing_50, q1_.invoiced_by_fulldevis AS invoiced_by_fulldevis_51, q1_.followup_status AS followup_status_52, q1_.last_followup_at AS last_followup_at_53, q1_.relance_count AS relance_count_54, q1_.id AS id_55, d2_.name AS name_56, d2_.label AS label_57, d2_.order_by AS order_by_58, d2_.id AS id_59, d0_.user_id AS user_id_60, d0_.type_id AS type_id_61, d0_.quotation_status_id AS quotation_status_id_62, d0_.comment_id AS comment_id_63, d0_.quotation_id AS quotation_id_64, d0_.patient_id AS patient_id_65, d0_.centre_id AS centre_id_66, d0_.signed_by_centre_user_id AS signed_by_centre_user_id_67, d0_.signed_by_patient_user_id AS signed_by_patient_user_id_68, d0_.second_user_id AS second_user_id_69, q1_.user_id AS user_id_70, q1_.centre_id AS centre_id_71, q1_.patient_id AS patient_id_72, q1_.practitioner_id AS practitioner_id_73, q1_.social_security_percentage_id AS social_security_percentage_id_74 FROM document d0_ INNER JOIN quotation q1_ ON d0_.quotation_id = q1_.id INNER JOIN document_type d2_ ON d0_.type_id = d2_.id WHERE q1_.id = 303241 AND d2_.name = 'insurance_doc_not_signed' ORDER BY d0_.created_at DESC LIMIT 1;
13	0.48 ms	SELECT d0_.name AS name_0, d0_.created_at AS created_at_1, d0_.visit_date AS visit_date_2, d0_.bounded_at AS bounded_at_3, d0_.signed_by_patient AS signed_by_patient_4, d0_.signed_by_centre AS signed_by_centre_5, d0_.signed_by_patient_at AS signed_by_patient_at_6, d0_.signed_by_centre_at AS signed_by_centre_at_7, d0_.refused_by_patient AS refused_by_patient_8, d0_.refused_by_patient_at AS refused_by_patient_at_9, d0_.sent_to_patient_to_sign AS sent_to_patient_to_sign_10, d0_.sent_to_patient_to_sign_at AS sent_to_patient_to_sign_at_11, d0_.id AS id_12, q1_.number AS number_13, q1_.amc_number AS amc_number_14, q1_.created_at AS created_at_15, q1_.date_recall AS date_recall_16, q1_.date_visit AS date_visit_17, q1_.date_quotation AS date_quotation_18, q1_.amount AS amount_19, q1_.amo_amount AS amo_amount_20, q1_.pec_amo_amount AS pec_amo_amount_21, q1_.manager_amount AS manager_amount_22, q1_.client_amount AS client_amount_23, q1_.date_expired AS date_expired_24, q1_.date_reject AS date_reject_25, q1_.priority AS priority_26, q1_.billing_status AS billing_status_27, q1_.billing_excluded AS billing_excluded_28, q1_.online AS online_29, q1_.ortodontics AS ortodontics_30, q1_.date_pec_requested AS date_pec_requested_31, q1_.date_pec_responded AS date_pec_responded_32, q1_.sms_for_patient AS sms_for_patient_33, q1_.updated_at AS updated_at_34, q1_.next_system_action AS next_system_action_35, q1_.date_next_system_action AS date_next_system_action_36, q1_.date_pec_acknowledged AS date_pec_acknowledged_37, q1_.acknowledgement_reference AS acknowledgement_reference_38, q1_.social_security_bases AS social_security_bases_39, q1_.contract_number AS contract_number_40, q1_.name_of_the_insured AS name_of_the_insured_41, q1_.surname_of_the_insured AS surname_of_the_insured_42, q1_.date_of_birth_of_the_insured AS date_of_birth_of_the_insured_43, q1_.quotation_date_expiration AS quotation_date_expiration_44, q1_.cmu_status AS cmu_status_45, q1_.social_security_statement_flag AS social_security_statement_flag_46, q1_.invoice_number AS invoice_number_47, q1_.invoice_date AS invoice_date_48, q1_.invoice_amount AS invoice_amount_49, q1_.skip_auto_invoicing AS skip_auto_invoicing_50, q1_.invoiced_by_fulldevis AS invoiced_by_fulldevis_51, q1_.followup_status AS followup_status_52, q1_.last_followup_at AS last_followup_at_53, q1_.relance_count AS relance_count_54, q1_.id AS id_55, d2_.name AS name_56, d2_.label AS label_57, d2_.order_by AS order_by_58, d2_.id AS id_59, d0_.user_id AS user_id_60, d0_.type_id AS type_id_61, d0_.quotation_status_id AS quotation_status_id_62, d0_.comment_id AS comment_id_63, d0_.quotation_id AS quotation_id_64, d0_.patient_id AS patient_id_65, d0_.centre_id AS centre_id_66, d0_.signed_by_centre_user_id AS signed_by_centre_user_id_67, d0_.signed_by_patient_user_id AS signed_by_patient_user_id_68, d0_.second_user_id AS second_user_id_69, q1_.user_id AS user_id_70, q1_.centre_id AS centre_id_71, q1_.patient_id AS patient_id_72, q1_.practitioner_id AS practitioner_id_73, q1_.social_security_percentage_id AS social_security_percentage_id_74 FROM document d0_ INNER JOIN quotation q1_ ON d0_.quotation_id = q1_.id INNER JOIN document_type d2_ ON d0_.type_id = d2_.id WHERE q1_.id = ? AND d2_.name = ? ORDER BY d0_.created_at DESC LIMIT 1 Parameters: [`303241 "paid_invoice"`] View formatted query View runnable query Explain query SELECT d0_.name AS name_0, d0_.created_at AS created_at_1, d0_.visit_date AS visit_date_2, d0_.bounded_at AS bounded_at_3, d0_.signed_by_patient AS signed_by_patient_4, d0_.signed_by_centre AS signed_by_centre_5, d0_.signed_by_patient_at AS signed_by_patient_at_6, d0_.signed_by_centre_at AS signed_by_centre_at_7, d0_.refused_by_patient AS refused_by_patient_8, d0_.refused_by_patient_at AS refused_by_patient_at_9, d0_.sent_to_patient_to_sign AS sent_to_patient_to_sign_10, d0_.sent_to_patient_to_sign_at AS sent_to_patient_to_sign_at_11, d0_.id AS id_12, q1_.number AS number_13, q1_.amc_number AS amc_number_14, q1_.created_at AS created_at_15, q1_.date_recall AS date_recall_16, q1_.date_visit AS date_visit_17, q1_.date_quotation AS date_quotation_18, q1_.amount AS amount_19, q1_.amo_amount AS amo_amount_20, q1_.pec_amo_amount AS pec_amo_amount_21, q1_.manager_amount AS manager_amount_22, q1_.client_amount AS client_amount_23, q1_.date_expired AS date_expired_24, q1_.date_reject AS date_reject_25, q1_.priority AS priority_26, q1_.billing_status AS billing_status_27, q1_.billing_excluded AS billing_excluded_28, q1_.online AS online_29, q1_.ortodontics AS ortodontics_30, q1_.date_pec_requested AS date_pec_requested_31, q1_.date_pec_responded AS date_pec_responded_32, q1_.sms_for_patient AS sms_for_patient_33, q1_.updated_at AS updated_at_34, q1_.next_system_action AS next_system_action_35, q1_.date_next_system_action AS date_next_system_action_36, q1_.date_pec_acknowledged AS date_pec_acknowledged_37, q1_.acknowledgement_reference AS acknowledgement_reference_38, q1_.social_security_bases AS social_security_bases_39, q1_.contract_number AS contract_number_40, q1_.name_of_the_insured AS name_of_the_insured_41, q1_.surname_of_the_insured AS surname_of_the_insured_42, q1_.date_of_birth_of_the_insured AS date_of_birth_of_the_insured_43, q1_.quotation_date_expiration AS quotation_date_expiration_44, q1_.cmu_status AS cmu_status_45, q1_.social_security_statement_flag AS social_security_statement_flag_46, q1_.invoice_number AS invoice_number_47, q1_.invoice_date AS invoice_date_48, q1_.invoice_amount AS invoice_amount_49, q1_.skip_auto_invoicing AS skip_auto_invoicing_50, q1_.invoiced_by_fulldevis AS invoiced_by_fulldevis_51, q1_.followup_status AS followup_status_52, q1_.last_followup_at AS last_followup_at_53, q1_.relance_count AS relance_count_54, q1_.id AS id_55, d2_.name AS name_56, d2_.label AS label_57, d2_.order_by AS order_by_58, d2_.id AS id_59, d0_.user_id AS user_id_60, d0_.type_id AS type_id_61, d0_.quotation_status_id AS quotation_status_id_62, d0_.comment_id AS comment_id_63, d0_.quotation_id AS quotation_id_64, d0_.patient_id AS patient_id_65, d0_.centre_id AS centre_id_66, d0_.signed_by_centre_user_id AS signed_by_centre_user_id_67, d0_.signed_by_patient_user_id AS signed_by_patient_user_id_68, d0_.second_user_id AS second_user_id_69, q1_.user_id AS user_id_70, q1_.centre_id AS centre_id_71, q1_.patient_id AS patient_id_72, q1_.practitioner_id AS practitioner_id_73, q1_.social_security_percentage_id AS social_security_percentage_id_74 FROM document d0_ INNER JOIN quotation q1_ ON d0_.quotation_id = q1_.id INNER JOIN document_type d2_ ON d0_.type_id = d2_.id WHERE q1_.id = ? AND d2_.name = ? ORDER BY d0_.created_at DESC LIMIT 1 SELECT d0_.name AS name_0, d0_.created_at AS created_at_1, d0_.visit_date AS visit_date_2, d0_.bounded_at AS bounded_at_3, d0_.signed_by_patient AS signed_by_patient_4, d0_.signed_by_centre AS signed_by_centre_5, d0_.signed_by_patient_at AS signed_by_patient_at_6, d0_.signed_by_centre_at AS signed_by_centre_at_7, d0_.refused_by_patient AS refused_by_patient_8, d0_.refused_by_patient_at AS refused_by_patient_at_9, d0_.sent_to_patient_to_sign AS sent_to_patient_to_sign_10, d0_.sent_to_patient_to_sign_at AS sent_to_patient_to_sign_at_11, d0_.id AS id_12, q1_.number AS number_13, q1_.amc_number AS amc_number_14, q1_.created_at AS created_at_15, q1_.date_recall AS date_recall_16, q1_.date_visit AS date_visit_17, q1_.date_quotation AS date_quotation_18, q1_.amount AS amount_19, q1_.amo_amount AS amo_amount_20, q1_.pec_amo_amount AS pec_amo_amount_21, q1_.manager_amount AS manager_amount_22, q1_.client_amount AS client_amount_23, q1_.date_expired AS date_expired_24, q1_.date_reject AS date_reject_25, q1_.priority AS priority_26, q1_.billing_status AS billing_status_27, q1_.billing_excluded AS billing_excluded_28, q1_.online AS online_29, q1_.ortodontics AS ortodontics_30, q1_.date_pec_requested AS date_pec_requested_31, q1_.date_pec_responded AS date_pec_responded_32, q1_.sms_for_patient AS sms_for_patient_33, q1_.updated_at AS updated_at_34, q1_.next_system_action AS next_system_action_35, q1_.date_next_system_action AS date_next_system_action_36, q1_.date_pec_acknowledged AS date_pec_acknowledged_37, q1_.acknowledgement_reference AS acknowledgement_reference_38, q1_.social_security_bases AS social_security_bases_39, q1_.contract_number AS contract_number_40, q1_.name_of_the_insured AS name_of_the_insured_41, q1_.surname_of_the_insured AS surname_of_the_insured_42, q1_.date_of_birth_of_the_insured AS date_of_birth_of_the_insured_43, q1_.quotation_date_expiration AS quotation_date_expiration_44, q1_.cmu_status AS cmu_status_45, q1_.social_security_statement_flag AS social_security_statement_flag_46, q1_.invoice_number AS invoice_number_47, q1_.invoice_date AS invoice_date_48, q1_.invoice_amount AS invoice_amount_49, q1_.skip_auto_invoicing AS skip_auto_invoicing_50, q1_.invoiced_by_fulldevis AS invoiced_by_fulldevis_51, q1_.followup_status AS followup_status_52, q1_.last_followup_at AS last_followup_at_53, q1_.relance_count AS relance_count_54, q1_.id AS id_55, d2_.name AS name_56, d2_.label AS label_57, d2_.order_by AS order_by_58, d2_.id AS id_59, d0_.user_id AS user_id_60, d0_.type_id AS type_id_61, d0_.quotation_status_id AS quotation_status_id_62, d0_.comment_id AS comment_id_63, d0_.quotation_id AS quotation_id_64, d0_.patient_id AS patient_id_65, d0_.centre_id AS centre_id_66, d0_.signed_by_centre_user_id AS signed_by_centre_user_id_67, d0_.signed_by_patient_user_id AS signed_by_patient_user_id_68, d0_.second_user_id AS second_user_id_69, q1_.user_id AS user_id_70, q1_.centre_id AS centre_id_71, q1_.patient_id AS patient_id_72, q1_.practitioner_id AS practitioner_id_73, q1_.social_security_percentage_id AS social_security_percentage_id_74 FROM document d0_ INNER JOIN quotation q1_ ON d0_.quotation_id = q1_.id INNER JOIN document_type d2_ ON d0_.type_id = d2_.id WHERE q1_.id = 303241 AND d2_.name = 'paid_invoice' ORDER BY d0_.created_at DESC LIMIT 1;
14	0.48 ms	SELECT d0_.name AS name_0, d0_.created_at AS created_at_1, d0_.visit_date AS visit_date_2, d0_.bounded_at AS bounded_at_3, d0_.signed_by_patient AS signed_by_patient_4, d0_.signed_by_centre AS signed_by_centre_5, d0_.signed_by_patient_at AS signed_by_patient_at_6, d0_.signed_by_centre_at AS signed_by_centre_at_7, d0_.refused_by_patient AS refused_by_patient_8, d0_.refused_by_patient_at AS refused_by_patient_at_9, d0_.sent_to_patient_to_sign AS sent_to_patient_to_sign_10, d0_.sent_to_patient_to_sign_at AS sent_to_patient_to_sign_at_11, d0_.id AS id_12, q1_.number AS number_13, q1_.amc_number AS amc_number_14, q1_.created_at AS created_at_15, q1_.date_recall AS date_recall_16, q1_.date_visit AS date_visit_17, q1_.date_quotation AS date_quotation_18, q1_.amount AS amount_19, q1_.amo_amount AS amo_amount_20, q1_.pec_amo_amount AS pec_amo_amount_21, q1_.manager_amount AS manager_amount_22, q1_.client_amount AS client_amount_23, q1_.date_expired AS date_expired_24, q1_.date_reject AS date_reject_25, q1_.priority AS priority_26, q1_.billing_status AS billing_status_27, q1_.billing_excluded AS billing_excluded_28, q1_.online AS online_29, q1_.ortodontics AS ortodontics_30, q1_.date_pec_requested AS date_pec_requested_31, q1_.date_pec_responded AS date_pec_responded_32, q1_.sms_for_patient AS sms_for_patient_33, q1_.updated_at AS updated_at_34, q1_.next_system_action AS next_system_action_35, q1_.date_next_system_action AS date_next_system_action_36, q1_.date_pec_acknowledged AS date_pec_acknowledged_37, q1_.acknowledgement_reference AS acknowledgement_reference_38, q1_.social_security_bases AS social_security_bases_39, q1_.contract_number AS contract_number_40, q1_.name_of_the_insured AS name_of_the_insured_41, q1_.surname_of_the_insured AS surname_of_the_insured_42, q1_.date_of_birth_of_the_insured AS date_of_birth_of_the_insured_43, q1_.quotation_date_expiration AS quotation_date_expiration_44, q1_.cmu_status AS cmu_status_45, q1_.social_security_statement_flag AS social_security_statement_flag_46, q1_.invoice_number AS invoice_number_47, q1_.invoice_date AS invoice_date_48, q1_.invoice_amount AS invoice_amount_49, q1_.skip_auto_invoicing AS skip_auto_invoicing_50, q1_.invoiced_by_fulldevis AS invoiced_by_fulldevis_51, q1_.followup_status AS followup_status_52, q1_.last_followup_at AS last_followup_at_53, q1_.relance_count AS relance_count_54, q1_.id AS id_55, d2_.name AS name_56, d2_.label AS label_57, d2_.order_by AS order_by_58, d2_.id AS id_59, d0_.user_id AS user_id_60, d0_.type_id AS type_id_61, d0_.quotation_status_id AS quotation_status_id_62, d0_.comment_id AS comment_id_63, d0_.quotation_id AS quotation_id_64, d0_.patient_id AS patient_id_65, d0_.centre_id AS centre_id_66, d0_.signed_by_centre_user_id AS signed_by_centre_user_id_67, d0_.signed_by_patient_user_id AS signed_by_patient_user_id_68, d0_.second_user_id AS second_user_id_69, q1_.user_id AS user_id_70, q1_.centre_id AS centre_id_71, q1_.patient_id AS patient_id_72, q1_.practitioner_id AS practitioner_id_73, q1_.social_security_percentage_id AS social_security_percentage_id_74 FROM document d0_ INNER JOIN quotation q1_ ON d0_.quotation_id = q1_.id INNER JOIN document_type d2_ ON d0_.type_id = d2_.id WHERE q1_.id = ? AND d2_.name = ? ORDER BY d0_.created_at DESC LIMIT 1 Parameters: [`303241 "insurance_doc_signed"`] View formatted query View runnable query Explain query SELECT d0_.name AS name_0, d0_.created_at AS created_at_1, d0_.visit_date AS visit_date_2, d0_.bounded_at AS bounded_at_3, d0_.signed_by_patient AS signed_by_patient_4, d0_.signed_by_centre AS signed_by_centre_5, d0_.signed_by_patient_at AS signed_by_patient_at_6, d0_.signed_by_centre_at AS signed_by_centre_at_7, d0_.refused_by_patient AS refused_by_patient_8, d0_.refused_by_patient_at AS refused_by_patient_at_9, d0_.sent_to_patient_to_sign AS sent_to_patient_to_sign_10, d0_.sent_to_patient_to_sign_at AS sent_to_patient_to_sign_at_11, d0_.id AS id_12, q1_.number AS number_13, q1_.amc_number AS amc_number_14, q1_.created_at AS created_at_15, q1_.date_recall AS date_recall_16, q1_.date_visit AS date_visit_17, q1_.date_quotation AS date_quotation_18, q1_.amount AS amount_19, q1_.amo_amount AS amo_amount_20, q1_.pec_amo_amount AS pec_amo_amount_21, q1_.manager_amount AS manager_amount_22, q1_.client_amount AS client_amount_23, q1_.date_expired AS date_expired_24, q1_.date_reject AS date_reject_25, q1_.priority AS priority_26, q1_.billing_status AS billing_status_27, q1_.billing_excluded AS billing_excluded_28, q1_.online AS online_29, q1_.ortodontics AS ortodontics_30, q1_.date_pec_requested AS date_pec_requested_31, q1_.date_pec_responded AS date_pec_responded_32, q1_.sms_for_patient AS sms_for_patient_33, q1_.updated_at AS updated_at_34, q1_.next_system_action AS next_system_action_35, q1_.date_next_system_action AS date_next_system_action_36, q1_.date_pec_acknowledged AS date_pec_acknowledged_37, q1_.acknowledgement_reference AS acknowledgement_reference_38, q1_.social_security_bases AS social_security_bases_39, q1_.contract_number AS contract_number_40, q1_.name_of_the_insured AS name_of_the_insured_41, q1_.surname_of_the_insured AS surname_of_the_insured_42, q1_.date_of_birth_of_the_insured AS date_of_birth_of_the_insured_43, q1_.quotation_date_expiration AS quotation_date_expiration_44, q1_.cmu_status AS cmu_status_45, q1_.social_security_statement_flag AS social_security_statement_flag_46, q1_.invoice_number AS invoice_number_47, q1_.invoice_date AS invoice_date_48, q1_.invoice_amount AS invoice_amount_49, q1_.skip_auto_invoicing AS skip_auto_invoicing_50, q1_.invoiced_by_fulldevis AS invoiced_by_fulldevis_51, q1_.followup_status AS followup_status_52, q1_.last_followup_at AS last_followup_at_53, q1_.relance_count AS relance_count_54, q1_.id AS id_55, d2_.name AS name_56, d2_.label AS label_57, d2_.order_by AS order_by_58, d2_.id AS id_59, d0_.user_id AS user_id_60, d0_.type_id AS type_id_61, d0_.quotation_status_id AS quotation_status_id_62, d0_.comment_id AS comment_id_63, d0_.quotation_id AS quotation_id_64, d0_.patient_id AS patient_id_65, d0_.centre_id AS centre_id_66, d0_.signed_by_centre_user_id AS signed_by_centre_user_id_67, d0_.signed_by_patient_user_id AS signed_by_patient_user_id_68, d0_.second_user_id AS second_user_id_69, q1_.user_id AS user_id_70, q1_.centre_id AS centre_id_71, q1_.patient_id AS patient_id_72, q1_.practitioner_id AS practitioner_id_73, q1_.social_security_percentage_id AS social_security_percentage_id_74 FROM document d0_ INNER JOIN quotation q1_ ON d0_.quotation_id = q1_.id INNER JOIN document_type d2_ ON d0_.type_id = d2_.id WHERE q1_.id = ? AND d2_.name = ? ORDER BY d0_.created_at DESC LIMIT 1 SELECT d0_.name AS name_0, d0_.created_at AS created_at_1, d0_.visit_date AS visit_date_2, d0_.bounded_at AS bounded_at_3, d0_.signed_by_patient AS signed_by_patient_4, d0_.signed_by_centre AS signed_by_centre_5, d0_.signed_by_patient_at AS signed_by_patient_at_6, d0_.signed_by_centre_at AS signed_by_centre_at_7, d0_.refused_by_patient AS refused_by_patient_8, d0_.refused_by_patient_at AS refused_by_patient_at_9, d0_.sent_to_patient_to_sign AS sent_to_patient_to_sign_10, d0_.sent_to_patient_to_sign_at AS sent_to_patient_to_sign_at_11, d0_.id AS id_12, q1_.number AS number_13, q1_.amc_number AS amc_number_14, q1_.created_at AS created_at_15, q1_.date_recall AS date_recall_16, q1_.date_visit AS date_visit_17, q1_.date_quotation AS date_quotation_18, q1_.amount AS amount_19, q1_.amo_amount AS amo_amount_20, q1_.pec_amo_amount AS pec_amo_amount_21, q1_.manager_amount AS manager_amount_22, q1_.client_amount AS client_amount_23, q1_.date_expired AS date_expired_24, q1_.date_reject AS date_reject_25, q1_.priority AS priority_26, q1_.billing_status AS billing_status_27, q1_.billing_excluded AS billing_excluded_28, q1_.online AS online_29, q1_.ortodontics AS ortodontics_30, q1_.date_pec_requested AS date_pec_requested_31, q1_.date_pec_responded AS date_pec_responded_32, q1_.sms_for_patient AS sms_for_patient_33, q1_.updated_at AS updated_at_34, q1_.next_system_action AS next_system_action_35, q1_.date_next_system_action AS date_next_system_action_36, q1_.date_pec_acknowledged AS date_pec_acknowledged_37, q1_.acknowledgement_reference AS acknowledgement_reference_38, q1_.social_security_bases AS social_security_bases_39, q1_.contract_number AS contract_number_40, q1_.name_of_the_insured AS name_of_the_insured_41, q1_.surname_of_the_insured AS surname_of_the_insured_42, q1_.date_of_birth_of_the_insured AS date_of_birth_of_the_insured_43, q1_.quotation_date_expiration AS quotation_date_expiration_44, q1_.cmu_status AS cmu_status_45, q1_.social_security_statement_flag AS social_security_statement_flag_46, q1_.invoice_number AS invoice_number_47, q1_.invoice_date AS invoice_date_48, q1_.invoice_amount AS invoice_amount_49, q1_.skip_auto_invoicing AS skip_auto_invoicing_50, q1_.invoiced_by_fulldevis AS invoiced_by_fulldevis_51, q1_.followup_status AS followup_status_52, q1_.last_followup_at AS last_followup_at_53, q1_.relance_count AS relance_count_54, q1_.id AS id_55, d2_.name AS name_56, d2_.label AS label_57, d2_.order_by AS order_by_58, d2_.id AS id_59, d0_.user_id AS user_id_60, d0_.type_id AS type_id_61, d0_.quotation_status_id AS quotation_status_id_62, d0_.comment_id AS comment_id_63, d0_.quotation_id AS quotation_id_64, d0_.patient_id AS patient_id_65, d0_.centre_id AS centre_id_66, d0_.signed_by_centre_user_id AS signed_by_centre_user_id_67, d0_.signed_by_patient_user_id AS signed_by_patient_user_id_68, d0_.second_user_id AS second_user_id_69, q1_.user_id AS user_id_70, q1_.centre_id AS centre_id_71, q1_.patient_id AS patient_id_72, q1_.practitioner_id AS practitioner_id_73, q1_.social_security_percentage_id AS social_security_percentage_id_74 FROM document d0_ INNER JOIN quotation q1_ ON d0_.quotation_id = q1_.id INNER JOIN document_type d2_ ON d0_.type_id = d2_.id WHERE q1_.id = 303241 AND d2_.name = 'insurance_doc_signed' ORDER BY d0_.created_at DESC LIMIT 1;
15	0.44 ms	SELECT d0_.name AS name_0, d0_.created_at AS created_at_1, d0_.visit_date AS visit_date_2, d0_.bounded_at AS bounded_at_3, d0_.signed_by_patient AS signed_by_patient_4, d0_.signed_by_centre AS signed_by_centre_5, d0_.signed_by_patient_at AS signed_by_patient_at_6, d0_.signed_by_centre_at AS signed_by_centre_at_7, d0_.refused_by_patient AS refused_by_patient_8, d0_.refused_by_patient_at AS refused_by_patient_at_9, d0_.sent_to_patient_to_sign AS sent_to_patient_to_sign_10, d0_.sent_to_patient_to_sign_at AS sent_to_patient_to_sign_at_11, d0_.id AS id_12, q1_.number AS number_13, q1_.amc_number AS amc_number_14, q1_.created_at AS created_at_15, q1_.date_recall AS date_recall_16, q1_.date_visit AS date_visit_17, q1_.date_quotation AS date_quotation_18, q1_.amount AS amount_19, q1_.amo_amount AS amo_amount_20, q1_.pec_amo_amount AS pec_amo_amount_21, q1_.manager_amount AS manager_amount_22, q1_.client_amount AS client_amount_23, q1_.date_expired AS date_expired_24, q1_.date_reject AS date_reject_25, q1_.priority AS priority_26, q1_.billing_status AS billing_status_27, q1_.billing_excluded AS billing_excluded_28, q1_.online AS online_29, q1_.ortodontics AS ortodontics_30, q1_.date_pec_requested AS date_pec_requested_31, q1_.date_pec_responded AS date_pec_responded_32, q1_.sms_for_patient AS sms_for_patient_33, q1_.updated_at AS updated_at_34, q1_.next_system_action AS next_system_action_35, q1_.date_next_system_action AS date_next_system_action_36, q1_.date_pec_acknowledged AS date_pec_acknowledged_37, q1_.acknowledgement_reference AS acknowledgement_reference_38, q1_.social_security_bases AS social_security_bases_39, q1_.contract_number AS contract_number_40, q1_.name_of_the_insured AS name_of_the_insured_41, q1_.surname_of_the_insured AS surname_of_the_insured_42, q1_.date_of_birth_of_the_insured AS date_of_birth_of_the_insured_43, q1_.quotation_date_expiration AS quotation_date_expiration_44, q1_.cmu_status AS cmu_status_45, q1_.social_security_statement_flag AS social_security_statement_flag_46, q1_.invoice_number AS invoice_number_47, q1_.invoice_date AS invoice_date_48, q1_.invoice_amount AS invoice_amount_49, q1_.skip_auto_invoicing AS skip_auto_invoicing_50, q1_.invoiced_by_fulldevis AS invoiced_by_fulldevis_51, q1_.followup_status AS followup_status_52, q1_.last_followup_at AS last_followup_at_53, q1_.relance_count AS relance_count_54, q1_.id AS id_55, d2_.name AS name_56, d2_.label AS label_57, d2_.order_by AS order_by_58, d2_.id AS id_59, d0_.user_id AS user_id_60, d0_.type_id AS type_id_61, d0_.quotation_status_id AS quotation_status_id_62, d0_.comment_id AS comment_id_63, d0_.quotation_id AS quotation_id_64, d0_.patient_id AS patient_id_65, d0_.centre_id AS centre_id_66, d0_.signed_by_centre_user_id AS signed_by_centre_user_id_67, d0_.signed_by_patient_user_id AS signed_by_patient_user_id_68, d0_.second_user_id AS second_user_id_69, q1_.user_id AS user_id_70, q1_.centre_id AS centre_id_71, q1_.patient_id AS patient_id_72, q1_.practitioner_id AS practitioner_id_73, q1_.social_security_percentage_id AS social_security_percentage_id_74 FROM document d0_ INNER JOIN quotation q1_ ON d0_.quotation_id = q1_.id INNER JOIN document_type d2_ ON d0_.type_id = d2_.id WHERE q1_.id = ? AND d2_.name = ? ORDER BY d0_.created_at DESC LIMIT 1 Parameters: [`303241 "quotation_signed"`] View formatted query View runnable query Explain query SELECT d0_.name AS name_0, d0_.created_at AS created_at_1, d0_.visit_date AS visit_date_2, d0_.bounded_at AS bounded_at_3, d0_.signed_by_patient AS signed_by_patient_4, d0_.signed_by_centre AS signed_by_centre_5, d0_.signed_by_patient_at AS signed_by_patient_at_6, d0_.signed_by_centre_at AS signed_by_centre_at_7, d0_.refused_by_patient AS refused_by_patient_8, d0_.refused_by_patient_at AS refused_by_patient_at_9, d0_.sent_to_patient_to_sign AS sent_to_patient_to_sign_10, d0_.sent_to_patient_to_sign_at AS sent_to_patient_to_sign_at_11, d0_.id AS id_12, q1_.number AS number_13, q1_.amc_number AS amc_number_14, q1_.created_at AS created_at_15, q1_.date_recall AS date_recall_16, q1_.date_visit AS date_visit_17, q1_.date_quotation AS date_quotation_18, q1_.amount AS amount_19, q1_.amo_amount AS amo_amount_20, q1_.pec_amo_amount AS pec_amo_amount_21, q1_.manager_amount AS manager_amount_22, q1_.client_amount AS client_amount_23, q1_.date_expired AS date_expired_24, q1_.date_reject AS date_reject_25, q1_.priority AS priority_26, q1_.billing_status AS billing_status_27, q1_.billing_excluded AS billing_excluded_28, q1_.online AS online_29, q1_.ortodontics AS ortodontics_30, q1_.date_pec_requested AS date_pec_requested_31, q1_.date_pec_responded AS date_pec_responded_32, q1_.sms_for_patient AS sms_for_patient_33, q1_.updated_at AS updated_at_34, q1_.next_system_action AS next_system_action_35, q1_.date_next_system_action AS date_next_system_action_36, q1_.date_pec_acknowledged AS date_pec_acknowledged_37, q1_.acknowledgement_reference AS acknowledgement_reference_38, q1_.social_security_bases AS social_security_bases_39, q1_.contract_number AS contract_number_40, q1_.name_of_the_insured AS name_of_the_insured_41, q1_.surname_of_the_insured AS surname_of_the_insured_42, q1_.date_of_birth_of_the_insured AS date_of_birth_of_the_insured_43, q1_.quotation_date_expiration AS quotation_date_expiration_44, q1_.cmu_status AS cmu_status_45, q1_.social_security_statement_flag AS social_security_statement_flag_46, q1_.invoice_number AS invoice_number_47, q1_.invoice_date AS invoice_date_48, q1_.invoice_amount AS invoice_amount_49, q1_.skip_auto_invoicing AS skip_auto_invoicing_50, q1_.invoiced_by_fulldevis AS invoiced_by_fulldevis_51, q1_.followup_status AS followup_status_52, q1_.last_followup_at AS last_followup_at_53, q1_.relance_count AS relance_count_54, q1_.id AS id_55, d2_.name AS name_56, d2_.label AS label_57, d2_.order_by AS order_by_58, d2_.id AS id_59, d0_.user_id AS user_id_60, d0_.type_id AS type_id_61, d0_.quotation_status_id AS quotation_status_id_62, d0_.comment_id AS comment_id_63, d0_.quotation_id AS quotation_id_64, d0_.patient_id AS patient_id_65, d0_.centre_id AS centre_id_66, d0_.signed_by_centre_user_id AS signed_by_centre_user_id_67, d0_.signed_by_patient_user_id AS signed_by_patient_user_id_68, d0_.second_user_id AS second_user_id_69, q1_.user_id AS user_id_70, q1_.centre_id AS centre_id_71, q1_.patient_id AS patient_id_72, q1_.practitioner_id AS practitioner_id_73, q1_.social_security_percentage_id AS social_security_percentage_id_74 FROM document d0_ INNER JOIN quotation q1_ ON d0_.quotation_id = q1_.id INNER JOIN document_type d2_ ON d0_.type_id = d2_.id WHERE q1_.id = ? AND d2_.name = ? ORDER BY d0_.created_at DESC LIMIT 1 SELECT d0_.name AS name_0, d0_.created_at AS created_at_1, d0_.visit_date AS visit_date_2, d0_.bounded_at AS bounded_at_3, d0_.signed_by_patient AS signed_by_patient_4, d0_.signed_by_centre AS signed_by_centre_5, d0_.signed_by_patient_at AS signed_by_patient_at_6, d0_.signed_by_centre_at AS signed_by_centre_at_7, d0_.refused_by_patient AS refused_by_patient_8, d0_.refused_by_patient_at AS refused_by_patient_at_9, d0_.sent_to_patient_to_sign AS sent_to_patient_to_sign_10, d0_.sent_to_patient_to_sign_at AS sent_to_patient_to_sign_at_11, d0_.id AS id_12, q1_.number AS number_13, q1_.amc_number AS amc_number_14, q1_.created_at AS created_at_15, q1_.date_recall AS date_recall_16, q1_.date_visit AS date_visit_17, q1_.date_quotation AS date_quotation_18, q1_.amount AS amount_19, q1_.amo_amount AS amo_amount_20, q1_.pec_amo_amount AS pec_amo_amount_21, q1_.manager_amount AS manager_amount_22, q1_.client_amount AS client_amount_23, q1_.date_expired AS date_expired_24, q1_.date_reject AS date_reject_25, q1_.priority AS priority_26, q1_.billing_status AS billing_status_27, q1_.billing_excluded AS billing_excluded_28, q1_.online AS online_29, q1_.ortodontics AS ortodontics_30, q1_.date_pec_requested AS date_pec_requested_31, q1_.date_pec_responded AS date_pec_responded_32, q1_.sms_for_patient AS sms_for_patient_33, q1_.updated_at AS updated_at_34, q1_.next_system_action AS next_system_action_35, q1_.date_next_system_action AS date_next_system_action_36, q1_.date_pec_acknowledged AS date_pec_acknowledged_37, q1_.acknowledgement_reference AS acknowledgement_reference_38, q1_.social_security_bases AS social_security_bases_39, q1_.contract_number AS contract_number_40, q1_.name_of_the_insured AS name_of_the_insured_41, q1_.surname_of_the_insured AS surname_of_the_insured_42, q1_.date_of_birth_of_the_insured AS date_of_birth_of_the_insured_43, q1_.quotation_date_expiration AS quotation_date_expiration_44, q1_.cmu_status AS cmu_status_45, q1_.social_security_statement_flag AS social_security_statement_flag_46, q1_.invoice_number AS invoice_number_47, q1_.invoice_date AS invoice_date_48, q1_.invoice_amount AS invoice_amount_49, q1_.skip_auto_invoicing AS skip_auto_invoicing_50, q1_.invoiced_by_fulldevis AS invoiced_by_fulldevis_51, q1_.followup_status AS followup_status_52, q1_.last_followup_at AS last_followup_at_53, q1_.relance_count AS relance_count_54, q1_.id AS id_55, d2_.name AS name_56, d2_.label AS label_57, d2_.order_by AS order_by_58, d2_.id AS id_59, d0_.user_id AS user_id_60, d0_.type_id AS type_id_61, d0_.quotation_status_id AS quotation_status_id_62, d0_.comment_id AS comment_id_63, d0_.quotation_id AS quotation_id_64, d0_.patient_id AS patient_id_65, d0_.centre_id AS centre_id_66, d0_.signed_by_centre_user_id AS signed_by_centre_user_id_67, d0_.signed_by_patient_user_id AS signed_by_patient_user_id_68, d0_.second_user_id AS second_user_id_69, q1_.user_id AS user_id_70, q1_.centre_id AS centre_id_71, q1_.patient_id AS patient_id_72, q1_.practitioner_id AS practitioner_id_73, q1_.social_security_percentage_id AS social_security_percentage_id_74 FROM document d0_ INNER JOIN quotation q1_ ON d0_.quotation_id = q1_.id INNER JOIN document_type d2_ ON d0_.type_id = d2_.id WHERE q1_.id = 303241 AND d2_.name = 'quotation_signed' ORDER BY d0_.created_at DESC LIMIT 1;
16	0.34 ms	SELECT q0_.by_email AS by_email_0, q0_.online AS online_1, q0_.by_fax AS by_fax_2, q0_.by_letter AS by_letter_3, q0_.id AS id_4, q0_.quotation_id AS quotation_id_5, q0_.insurance_company_id AS insurance_company_id_6, q0_.address_id AS address_id_7 FROM quotation_insurance_company q0_ LEFT JOIN insurance_company i1_ ON q0_.insurance_company_id = i1_.id LEFT JOIN quotation q2_ ON q0_.quotation_id = q2_.id WHERE q2_.id = ? AND i1_.type = ? ORDER BY q0_.id DESC LIMIT 1 Parameters: [`303241 2`] View formatted query View runnable query Explain query SELECT q0_.by_email AS by_email_0, q0_.online AS online_1, q0_.by_fax AS by_fax_2, q0_.by_letter AS by_letter_3, q0_.id AS id_4, q0_.quotation_id AS quotation_id_5, q0_.insurance_company_id AS insurance_company_id_6, q0_.address_id AS address_id_7 FROM quotation_insurance_company q0_ LEFT JOIN insurance_company i1_ ON q0_.insurance_company_id = i1_.id LEFT JOIN quotation q2_ ON q0_.quotation_id = q2_.id WHERE q2_.id = ? AND i1_.type = ? ORDER BY q0_.id DESC LIMIT 1 SELECT q0_.by_email AS by_email_0, q0_.online AS online_1, q0_.by_fax AS by_fax_2, q0_.by_letter AS by_letter_3, q0_.id AS id_4, q0_.quotation_id AS quotation_id_5, q0_.insurance_company_id AS insurance_company_id_6, q0_.address_id AS address_id_7 FROM quotation_insurance_company q0_ LEFT JOIN insurance_company i1_ ON q0_.insurance_company_id = i1_.id LEFT JOIN quotation q2_ ON q0_.quotation_id = q2_.id WHERE q2_.id = 303241 AND i1_.type = 2 ORDER BY q0_.id DESC LIMIT 1;
17	0.31 ms	SELECT q0_.by_email AS by_email_0, q0_.online AS online_1, q0_.by_fax AS by_fax_2, q0_.by_letter AS by_letter_3, q0_.id AS id_4, q0_.quotation_id AS quotation_id_5, q0_.insurance_company_id AS insurance_company_id_6, q0_.address_id AS address_id_7 FROM quotation_insurance_company q0_ LEFT JOIN insurance_company i1_ ON q0_.insurance_company_id = i1_.id LEFT JOIN quotation q2_ ON q0_.quotation_id = q2_.id WHERE q2_.id = ? AND i1_.type = ? ORDER BY q0_.id DESC LIMIT 1 Parameters: [`303241 1`] View formatted query View runnable query Explain query SELECT q0_.by_email AS by_email_0, q0_.online AS online_1, q0_.by_fax AS by_fax_2, q0_.by_letter AS by_letter_3, q0_.id AS id_4, q0_.quotation_id AS quotation_id_5, q0_.insurance_company_id AS insurance_company_id_6, q0_.address_id AS address_id_7 FROM quotation_insurance_company q0_ LEFT JOIN insurance_company i1_ ON q0_.insurance_company_id = i1_.id LEFT JOIN quotation q2_ ON q0_.quotation_id = q2_.id WHERE q2_.id = ? AND i1_.type = ? ORDER BY q0_.id DESC LIMIT 1 SELECT q0_.by_email AS by_email_0, q0_.online AS online_1, q0_.by_fax AS by_fax_2, q0_.by_letter AS by_letter_3, q0_.id AS id_4, q0_.quotation_id AS quotation_id_5, q0_.insurance_company_id AS insurance_company_id_6, q0_.address_id AS address_id_7 FROM quotation_insurance_company q0_ LEFT JOIN insurance_company i1_ ON q0_.insurance_company_id = i1_.id LEFT JOIN quotation q2_ ON q0_.quotation_id = q2_.id WHERE q2_.id = 303241 AND i1_.type = 1 ORDER BY q0_.id DESC LIMIT 1;
18	0.25 ms	SELECT t0.name AS name_1, t0.amc_number AS amc_number_2, t0.type AS type_3, t0.corr_civility AS corr_civility_4, t0.corr_lastname AS corr_lastname_5, t0.corr_firstname AS corr_firstname_6, t0.corr_phone AS corr_phone_7, t0.corr_email AS corr_email_8, t0.web_site AS web_site_9, t0.dynamic_pec_treatment_days AS dynamic_pec_treatment_days_10, t0.static_pec_treatment_days AS static_pec_treatment_days_11, t0.auto_mail_synchro_status AS auto_mail_synchro_status_12, t0.id AS id_13, t0.group_id AS group_id_14 FROM insurance_company t0 WHERE t0.id = ? Parameters: [`88`] View formatted query View runnable query Explain query SELECT t0.name AS name_1, t0.amc_number AS amc_number_2, t0.type AS type_3, t0.corr_civility AS corr_civility_4, t0.corr_lastname AS corr_lastname_5, t0.corr_firstname AS corr_firstname_6, t0.corr_phone AS corr_phone_7, t0.corr_email AS corr_email_8, t0.web_site AS web_site_9, t0.dynamic_pec_treatment_days AS dynamic_pec_treatment_days_10, t0.static_pec_treatment_days AS static_pec_treatment_days_11, t0.auto_mail_synchro_status AS auto_mail_synchro_status_12, t0.id AS id_13, t0.group_id AS group_id_14 FROM insurance_company t0 WHERE t0.id = ? SELECT t0.name AS name_1, t0.amc_number AS amc_number_2, t0.type AS type_3, t0.corr_civility AS corr_civility_4, t0.corr_lastname AS corr_lastname_5, t0.corr_firstname AS corr_firstname_6, t0.corr_phone AS corr_phone_7, t0.corr_email AS corr_email_8, t0.web_site AS web_site_9, t0.dynamic_pec_treatment_days AS dynamic_pec_treatment_days_10, t0.static_pec_treatment_days AS static_pec_treatment_days_11, t0.auto_mail_synchro_status AS auto_mail_synchro_status_12, t0.id AS id_13, t0.group_id AS group_id_14 FROM insurance_company t0 WHERE t0.id = 88;
19	0.26 ms	SELECT t0.name AS name_1, t0.amc_number AS amc_number_2, t0.type AS type_3, t0.corr_civility AS corr_civility_4, t0.corr_lastname AS corr_lastname_5, t0.corr_firstname AS corr_firstname_6, t0.corr_phone AS corr_phone_7, t0.corr_email AS corr_email_8, t0.web_site AS web_site_9, t0.dynamic_pec_treatment_days AS dynamic_pec_treatment_days_10, t0.static_pec_treatment_days AS static_pec_treatment_days_11, t0.auto_mail_synchro_status AS auto_mail_synchro_status_12, t0.id AS id_13, t0.group_id AS group_id_14 FROM insurance_company t0 WHERE t0.id = ? Parameters: [`475`] View formatted query View runnable query Explain query SELECT t0.name AS name_1, t0.amc_number AS amc_number_2, t0.type AS type_3, t0.corr_civility AS corr_civility_4, t0.corr_lastname AS corr_lastname_5, t0.corr_firstname AS corr_firstname_6, t0.corr_phone AS corr_phone_7, t0.corr_email AS corr_email_8, t0.web_site AS web_site_9, t0.dynamic_pec_treatment_days AS dynamic_pec_treatment_days_10, t0.static_pec_treatment_days AS static_pec_treatment_days_11, t0.auto_mail_synchro_status AS auto_mail_synchro_status_12, t0.id AS id_13, t0.group_id AS group_id_14 FROM insurance_company t0 WHERE t0.id = ? SELECT t0.name AS name_1, t0.amc_number AS amc_number_2, t0.type AS type_3, t0.corr_civility AS corr_civility_4, t0.corr_lastname AS corr_lastname_5, t0.corr_firstname AS corr_firstname_6, t0.corr_phone AS corr_phone_7, t0.corr_email AS corr_email_8, t0.web_site AS web_site_9, t0.dynamic_pec_treatment_days AS dynamic_pec_treatment_days_10, t0.static_pec_treatment_days AS static_pec_treatment_days_11, t0.auto_mail_synchro_status AS auto_mail_synchro_status_12, t0.id AS id_13, t0.group_id AS group_id_14 FROM insurance_company t0 WHERE t0.id = 475;
20	0.29 ms	SELECT t0.updated_at AS updated_at_1, t0.id AS id_2, t0.status_id AS status_id_3, t0.quotation_id AS quotation_id_4, t0.user_id AS user_id_5, t0.second_user_id AS second_user_id_6 FROM quotation_history t0 WHERE t0.quotation_id = ? ORDER BY t0.updated_at ASC Parameters: [`303241`] View formatted query View runnable query Explain query SELECT t0.updated_at AS updated_at_1, t0.id AS id_2, t0.status_id AS status_id_3, t0.quotation_id AS quotation_id_4, t0.user_id AS user_id_5, t0.second_user_id AS second_user_id_6 FROM quotation_history t0 WHERE t0.quotation_id = ? ORDER BY t0.updated_at ASC SELECT t0.updated_at AS updated_at_1, t0.id AS id_2, t0.status_id AS status_id_3, t0.quotation_id AS quotation_id_4, t0.user_id AS user_id_5, t0.second_user_id AS second_user_id_6 FROM quotation_history t0 WHERE t0.quotation_id = 303241 ORDER BY t0.updated_at ASC;
21	0.25 ms	SELECT t0.name AS name_1, t0.label AS label_2, t0.sort_order AS sort_order_3, t0.final AS final_4, t0.id AS id_5 FROM quotation_status t0 WHERE t0.id = ? Parameters: [`1`] View formatted query View runnable query Explain query SELECT t0.name AS name_1, t0.label AS label_2, t0.sort_order AS sort_order_3, t0.final AS final_4, t0.id AS id_5 FROM quotation_status t0 WHERE t0.id = ? SELECT t0.name AS name_1, t0.label AS label_2, t0.sort_order AS sort_order_3, t0.final AS final_4, t0.id AS id_5 FROM quotation_status t0 WHERE t0.id = 1;
22	0.50 ms	SELECT q0_.created_at AS created_at_0, q0_.id AS id_1, s1_.comment AS comment_2, s1_.sort_order AS sort_order_3, s1_.is_deleted AS is_deleted_4, s1_.id AS id_5, q2_.number AS number_6, q2_.amc_number AS amc_number_7, q2_.created_at AS created_at_8, q2_.date_recall AS date_recall_9, q2_.date_visit AS date_visit_10, q2_.date_quotation AS date_quotation_11, q2_.amount AS amount_12, q2_.amo_amount AS amo_amount_13, q2_.pec_amo_amount AS pec_amo_amount_14, q2_.manager_amount AS manager_amount_15, q2_.client_amount AS client_amount_16, q2_.date_expired AS date_expired_17, q2_.date_reject AS date_reject_18, q2_.priority AS priority_19, q2_.billing_status AS billing_status_20, q2_.billing_excluded AS billing_excluded_21, q2_.online AS online_22, q2_.ortodontics AS ortodontics_23, q2_.date_pec_requested AS date_pec_requested_24, q2_.date_pec_responded AS date_pec_responded_25, q2_.sms_for_patient AS sms_for_patient_26, q2_.updated_at AS updated_at_27, q2_.next_system_action AS next_system_action_28, q2_.date_next_system_action AS date_next_system_action_29, q2_.date_pec_acknowledged AS date_pec_acknowledged_30, q2_.acknowledgement_reference AS acknowledgement_reference_31, q2_.social_security_bases AS social_security_bases_32, q2_.contract_number AS contract_number_33, q2_.name_of_the_insured AS name_of_the_insured_34, q2_.surname_of_the_insured AS surname_of_the_insured_35, q2_.date_of_birth_of_the_insured AS date_of_birth_of_the_insured_36, q2_.quotation_date_expiration AS quotation_date_expiration_37, q2_.cmu_status AS cmu_status_38, q2_.social_security_statement_flag AS social_security_statement_flag_39, q2_.invoice_number AS invoice_number_40, q2_.invoice_date AS invoice_date_41, q2_.invoice_amount AS invoice_amount_42, q2_.skip_auto_invoicing AS skip_auto_invoicing_43, q2_.invoiced_by_fulldevis AS invoiced_by_fulldevis_44, q2_.followup_status AS followup_status_45, q2_.last_followup_at AS last_followup_at_46, q2_.relance_count AS relance_count_47, q2_.id AS id_48, q0_.comment_id AS comment_id_49, q0_.quotation_id AS quotation_id_50, q0_.user_id AS user_id_51, q2_.user_id AS user_id_52, q2_.centre_id AS centre_id_53, q2_.patient_id AS patient_id_54, q2_.practitioner_id AS practitioner_id_55, q2_.social_security_percentage_id AS social_security_percentage_id_56 FROM quotation_synchro_comment q0_ INNER JOIN synchro_comment s1_ ON q0_.comment_id = s1_.id INNER JOIN quotation q2_ ON q0_.quotation_id = q2_.id WHERE q2_.id = ? AND LOWER(s1_.comment) LIKE ? ORDER BY q0_.created_at DESC LIMIT 1 Parameters: [`303241 "%facturation%"`] View formatted query View runnable query Explain query SELECT q0_.created_at AS created_at_0, q0_.id AS id_1, s1_.comment AS comment_2, s1_.sort_order AS sort_order_3, s1_.is_deleted AS is_deleted_4, s1_.id AS id_5, q2_.number AS number_6, q2_.amc_number AS amc_number_7, q2_.created_at AS created_at_8, q2_.date_recall AS date_recall_9, q2_.date_visit AS date_visit_10, q2_.date_quotation AS date_quotation_11, q2_.amount AS amount_12, q2_.amo_amount AS amo_amount_13, q2_.pec_amo_amount AS pec_amo_amount_14, q2_.manager_amount AS manager_amount_15, q2_.client_amount AS client_amount_16, q2_.date_expired AS date_expired_17, q2_.date_reject AS date_reject_18, q2_.priority AS priority_19, q2_.billing_status AS billing_status_20, q2_.billing_excluded AS billing_excluded_21, q2_.online AS online_22, q2_.ortodontics AS ortodontics_23, q2_.date_pec_requested AS date_pec_requested_24, q2_.date_pec_responded AS date_pec_responded_25, q2_.sms_for_patient AS sms_for_patient_26, q2_.updated_at AS updated_at_27, q2_.next_system_action AS next_system_action_28, q2_.date_next_system_action AS date_next_system_action_29, q2_.date_pec_acknowledged AS date_pec_acknowledged_30, q2_.acknowledgement_reference AS acknowledgement_reference_31, q2_.social_security_bases AS social_security_bases_32, q2_.contract_number AS contract_number_33, q2_.name_of_the_insured AS name_of_the_insured_34, q2_.surname_of_the_insured AS surname_of_the_insured_35, q2_.date_of_birth_of_the_insured AS date_of_birth_of_the_insured_36, q2_.quotation_date_expiration AS quotation_date_expiration_37, q2_.cmu_status AS cmu_status_38, q2_.social_security_statement_flag AS social_security_statement_flag_39, q2_.invoice_number AS invoice_number_40, q2_.invoice_date AS invoice_date_41, q2_.invoice_amount AS invoice_amount_42, q2_.skip_auto_invoicing AS skip_auto_invoicing_43, q2_.invoiced_by_fulldevis AS invoiced_by_fulldevis_44, q2_.followup_status AS followup_status_45, q2_.last_followup_at AS last_followup_at_46, q2_.relance_count AS relance_count_47, q2_.id AS id_48, q0_.comment_id AS comment_id_49, q0_.quotation_id AS quotation_id_50, q0_.user_id AS user_id_51, q2_.user_id AS user_id_52, q2_.centre_id AS centre_id_53, q2_.patient_id AS patient_id_54, q2_.practitioner_id AS practitioner_id_55, q2_.social_security_percentage_id AS social_security_percentage_id_56 FROM quotation_synchro_comment q0_ INNER JOIN synchro_comment s1_ ON q0_.comment_id = s1_.id INNER JOIN quotation q2_ ON q0_.quotation_id = q2_.id WHERE q2_.id = ? AND LOWER(s1_.comment) LIKE ? ORDER BY q0_.created_at DESC LIMIT 1 SELECT q0_.created_at AS created_at_0, q0_.id AS id_1, s1_.comment AS comment_2, s1_.sort_order AS sort_order_3, s1_.is_deleted AS is_deleted_4, s1_.id AS id_5, q2_.number AS number_6, q2_.amc_number AS amc_number_7, q2_.created_at AS created_at_8, q2_.date_recall AS date_recall_9, q2_.date_visit AS date_visit_10, q2_.date_quotation AS date_quotation_11, q2_.amount AS amount_12, q2_.amo_amount AS amo_amount_13, q2_.pec_amo_amount AS pec_amo_amount_14, q2_.manager_amount AS manager_amount_15, q2_.client_amount AS client_amount_16, q2_.date_expired AS date_expired_17, q2_.date_reject AS date_reject_18, q2_.priority AS priority_19, q2_.billing_status AS billing_status_20, q2_.billing_excluded AS billing_excluded_21, q2_.online AS online_22, q2_.ortodontics AS ortodontics_23, q2_.date_pec_requested AS date_pec_requested_24, q2_.date_pec_responded AS date_pec_responded_25, q2_.sms_for_patient AS sms_for_patient_26, q2_.updated_at AS updated_at_27, q2_.next_system_action AS next_system_action_28, q2_.date_next_system_action AS date_next_system_action_29, q2_.date_pec_acknowledged AS date_pec_acknowledged_30, q2_.acknowledgement_reference AS acknowledgement_reference_31, q2_.social_security_bases AS social_security_bases_32, q2_.contract_number AS contract_number_33, q2_.name_of_the_insured AS name_of_the_insured_34, q2_.surname_of_the_insured AS surname_of_the_insured_35, q2_.date_of_birth_of_the_insured AS date_of_birth_of_the_insured_36, q2_.quotation_date_expiration AS quotation_date_expiration_37, q2_.cmu_status AS cmu_status_38, q2_.social_security_statement_flag AS social_security_statement_flag_39, q2_.invoice_number AS invoice_number_40, q2_.invoice_date AS invoice_date_41, q2_.invoice_amount AS invoice_amount_42, q2_.skip_auto_invoicing AS skip_auto_invoicing_43, q2_.invoiced_by_fulldevis AS invoiced_by_fulldevis_44, q2_.followup_status AS followup_status_45, q2_.last_followup_at AS last_followup_at_46, q2_.relance_count AS relance_count_47, q2_.id AS id_48, q0_.comment_id AS comment_id_49, q0_.quotation_id AS quotation_id_50, q0_.user_id AS user_id_51, q2_.user_id AS user_id_52, q2_.centre_id AS centre_id_53, q2_.patient_id AS patient_id_54, q2_.practitioner_id AS practitioner_id_55, q2_.social_security_percentage_id AS social_security_percentage_id_56 FROM quotation_synchro_comment q0_ INNER JOIN synchro_comment s1_ ON q0_.comment_id = s1_.id INNER JOIN quotation q2_ ON q0_.quotation_id = q2_.id WHERE q2_.id = 303241 AND LOWER(s1_.comment) LIKE '%facturation%' ORDER BY q0_.created_at DESC LIMIT 1;
23	0.88 ms	SELECT t0.tooth_number AS tooth_number_1, t0.amount AS amount_2, t0.bss_amount AS bss_amount_3, t0.ccam AS ccam_4, t0.amo_amount AS amo_amount_5, t0.rc_amount AS rc_amount_6, t0.rac_amount AS rac_amount_7, t0.taux_remboursement AS taux_remboursement_8, t0.platform AS platform_9, t0.id AS id_10, t0.quotation_id AS quotation_id_11 FROM pec_quotation_details t0 WHERE t0.quotation_id = ? Parameters: [`303241`] View formatted query View runnable query Explain query SELECT t0.tooth_number AS tooth_number_1, t0.amount AS amount_2, t0.bss_amount AS bss_amount_3, t0.ccam AS ccam_4, t0.amo_amount AS amo_amount_5, t0.rc_amount AS rc_amount_6, t0.rac_amount AS rac_amount_7, t0.taux_remboursement AS taux_remboursement_8, t0.platform AS platform_9, t0.id AS id_10, t0.quotation_id AS quotation_id_11 FROM pec_quotation_details t0 WHERE t0.quotation_id = ? SELECT t0.tooth_number AS tooth_number_1, t0.amount AS amount_2, t0.bss_amount AS bss_amount_3, t0.ccam AS ccam_4, t0.amo_amount AS amo_amount_5, t0.rc_amount AS rc_amount_6, t0.rac_amount AS rac_amount_7, t0.taux_remboursement AS taux_remboursement_8, t0.platform AS platform_9, t0.id AS id_10, t0.quotation_id AS quotation_id_11 FROM pec_quotation_details t0 WHERE t0.quotation_id = 303241;
24	0.77 ms	SELECT t0.tooth_number AS tooth_number_1, t0.amount AS amount_2, t0.ccam AS ccam_3, t0.id AS id_4, t0.quotation_id AS quotation_id_5 FROM invoice_quotation_details t0 WHERE t0.quotation_id = ? Parameters: [`303241`] View formatted query View runnable query Explain query SELECT t0.tooth_number AS tooth_number_1, t0.amount AS amount_2, t0.ccam AS ccam_3, t0.id AS id_4, t0.quotation_id AS quotation_id_5 FROM invoice_quotation_details t0 WHERE t0.quotation_id = ? SELECT t0.tooth_number AS tooth_number_1, t0.amount AS amount_2, t0.ccam AS ccam_3, t0.id AS id_4, t0.quotation_id AS quotation_id_5 FROM invoice_quotation_details t0 WHERE t0.quotation_id = 303241;
25	0.32 ms	SELECT t0.value AS value_1, t0.id AS id_2 FROM social_security_percentage t0 WHERE t0.id = ? Parameters: [`5`] View formatted query View runnable query Explain query SELECT t0.value AS value_1, t0.id AS id_2 FROM social_security_percentage t0 WHERE t0.id = ? SELECT t0.value AS value_1, t0.id AS id_2 FROM social_security_percentage t0 WHERE t0.id = 5;
26	0.27 ms	SELECT t0.file_number AS file_number_1, t0.civility AS civility_2, t0.last_name AS last_name_3, t0.first_name AS first_name_4, t0.phone AS phone_5, t0.mobile_phone AS mobile_phone_6, t0.email AS email_7, t0.social_security_number AS social_security_number_8, t0.membership_number AS membership_number_9, t0.status AS status_10, t0.accept_sms AS accept_sms_11, t0.dob AS dob_12, t0.id AS id_13, t0.centre_id AS centre_id_14 FROM patient t0 WHERE t0.id = ? Parameters: [`132615`] View formatted query View runnable query Explain query SELECT t0.file_number AS file_number_1, t0.civility AS civility_2, t0.last_name AS last_name_3, t0.first_name AS first_name_4, t0.phone AS phone_5, t0.mobile_phone AS mobile_phone_6, t0.email AS email_7, t0.social_security_number AS social_security_number_8, t0.membership_number AS membership_number_9, t0.status AS status_10, t0.accept_sms AS accept_sms_11, t0.dob AS dob_12, t0.id AS id_13, t0.centre_id AS centre_id_14 FROM patient t0 WHERE t0.id = ? SELECT t0.file_number AS file_number_1, t0.civility AS civility_2, t0.last_name AS last_name_3, t0.first_name AS first_name_4, t0.phone AS phone_5, t0.mobile_phone AS mobile_phone_6, t0.email AS email_7, t0.social_security_number AS social_security_number_8, t0.membership_number AS membership_number_9, t0.status AS status_10, t0.accept_sms AS accept_sms_11, t0.dob AS dob_12, t0.id AS id_13, t0.centre_id AS centre_id_14 FROM patient t0 WHERE t0.id = 132615;

Database Connections

Name	Service
default	doctrine.dbal.default_connection

Entity Managers

Name	Service
default	doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Managed Entities

default entity manager

Class	Amount of managed objects
App\Entity\User	14
App\Entity\QuotationInsuranceCompany	2
App\Entity\InsuranceCompany	2
App\Entity\Address	2
App\Entity\Role	1
App\Entity\ConnectionHistory	1
App\Entity\Quotation	1
App\Entity\Centre	1
App\Entity\Patient	1
App\Entity\SocialSecurityPercentage	1
App\Entity\CentreGroup	1
App\Entity\CentreMapping	1
App\Entity\Document	1
App\Entity\DocumentType	1
App\Entity\QuotationHistory	1
App\Entity\QuotationStatus	1

Entities Mapping

Class	Mapping errors
App\Entity\User	No errors.
App\Entity\Role	No errors.
App\Entity\CentreGroup	No errors.
App\Entity\ConnectionHistory	No errors.
App\Entity\NotificationHistory	No errors.
App\Entity\DocumentQuotationAlert	No errors.
App\Entity\QuotationNoFurtherAction	No errors.
App\Entity\UserCentreAccessibility	No errors.
App\Entity\Centre	No errors.
App\Entity\RoleRule	No errors.
App\Entity\QuotationStatus	No errors.
App\Entity\Session	No errors.
App\Entity\Quotation	No errors.
App\Entity\InvoicingQuotationDetails	No errors.
App\Entity\Patient	No errors.
App\Entity\SocialSecurityPercentage	No errors.
App\Entity\QuotationHistory	No errors.
App\Entity\QuotationComment	No errors.
App\Entity\QuotationFreeComment	No errors.
App\Entity\QuotationSynchroComment	No errors.
App\Entity\Document	No errors.
App\Entity\QuotationInsuranceCompany	No errors.
App\Entity\Notification	No errors.
App\Entity\QuotationProcessingTime	No errors.
App\Entity\QuotationOcr	No errors.
App\Entity\InvoiceQuotationDetails	No errors.
App\Entity\InsuranceCompany	No errors.
App\Entity\Address	No errors.
App\Entity\Rule	No errors.
App\Entity\CentreMapping	No errors.
App\Entity\CentreInsuranceCompany	No errors.
App\Entity\InsuranceAgreement	No errors.
App\Entity\AutoPostmanMailerConfig	No errors.
App\Entity\DocumentType	No errors.
App\Entity\Comment	No errors.
App\Entity\InsuranceCompanyGroup	No errors.
App\Entity\Task	No errors.
App\Entity\SynchroComment	No errors.
App\Entity\PecQuotationDetails	No errors.

Symfony Profiler

GET https://editeur-dentaire.fr/quotation/303241/process/invoicing

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping