Symfony Profiler

Query Metrics

21 Database Queries

21 Different statements

17.40 ms Query time

0 Invalid entities

14 Managed entities

Grouped Statements

Show all queries

default connection

Time▼	Count	Info
1.40 ms (8.06%)	1	SELECT d0_.id AS id_0, d0_.inv_user_reference AS inv_user_reference_1, d0_.inv_delay AS inv_delay_2, d0_.inv_is_monitored AS inv_is_monitored_3, d0_.inv_accepted_at AS inv_accepted_at_4, d0_.inv_predicted_delivered_at AS inv_predicted_delivered_at_5, d0_.inv_net_ref AS inv_net_ref_6, d0_.inv_has_priority AS inv_has_priority_7, d0_.inv_priority_deadline AS inv_priority_deadline_8, d0_.inv_accepted_at AS inv_accepted_at_9, d0_.etat AS etat_10, d1_.prest_grp_label AS prest_grp_label_11, d1_.prest_grp_form_type AS prest_grp_form_type_12, d2_.user_first_name AS user_first_name_13, d2_.user_last_name AS user_last_name_14, d3_.phys_sub_last_name AS phys_sub_last_name_15, d3_.phys_sub_first_name AS phys_sub_first_name_16, d4_.order_ordered_at AS order_ordered_at_17, d5_.id AS id_18, d5_.est_validated_at AS est_validated_at_19, d6_.prop_sub_visited_at AS prop_sub_visited_at_20, d7_.id AS id_21, d8_.id AS id_22 FROM dyna_investigation d0_ INNER JOIN dyna_physical_subject d3_ ON d0_.req_physical_subject_id = d3_.id INNER JOIN dyna_prest_grp d1_ ON d0_.req_prest_grp_id = d1_.id INNER JOIN dyna_record d9_ ON d0_.record_id = d9_.id LEFT JOIN dyna_estimation d5_ ON d0_.estimation_id = d5_.id INNER JOIN dyna_order d4_ ON d9_.order_id = d4_.id INNER JOIN dyna_user d2_ ON d4_.user_id = d2_.id INNER JOIN dyna_department d10_ ON d2_.department_id = d10_.id INNER JOIN dyna_branch d11_ ON d10_.branch_id = d11_.id INNER JOIN dyna_corporation d12_ ON d11_.corporation_id = d12_.id LEFT JOIN dyna_property_subject d6_ ON d0_.id = d6_.propSubReqInvestigation LEFT JOIN dyna_attachment d7_ ON d0_.id = d7_.att_investigation_id AND (d7_.att_file_name LIKE '%lettre_de_mission%') LEFT JOIN dyna_attachment d8_ ON d0_.id = d8_.att_investigation_id AND (d8_.att_file_name LIKE '%devis%') WHERE d4_.order_ordered_at IS NOT NULL AND (d0_.inv_is_cancelled IS NULL OR d0_.inv_is_cancelled = 0) AND d0_.inv_delivered_at IS NULL AND ((d0_.inv_is_waiting IS NULL OR d0_.inv_is_waiting = 0)) AND d5_.est_validated_at IS NULL AND d2_.id = 132 ORDER BY d0_.id DESC Parameters: [] View formatted query View runnable query Explain query SELECT d0_.id AS id_0, d0_.inv_user_reference AS inv_user_reference_1, d0_.inv_delay AS inv_delay_2, d0_.inv_is_monitored AS inv_is_monitored_3, d0_.inv_accepted_at AS inv_accepted_at_4, d0_.inv_predicted_delivered_at AS inv_predicted_delivered_at_5, d0_.inv_net_ref AS inv_net_ref_6, d0_.inv_has_priority AS inv_has_priority_7, d0_.inv_priority_deadline AS inv_priority_deadline_8, d0_.inv_accepted_at AS inv_accepted_at_9, d0_.etat AS etat_10, d1_.prest_grp_label AS prest_grp_label_11, d1_.prest_grp_form_type AS prest_grp_form_type_12, d2_.user_first_name AS user_first_name_13, d2_.user_last_name AS user_last_name_14, d3_.phys_sub_last_name AS phys_sub_last_name_15, d3_.phys_sub_first_name AS phys_sub_first_name_16, d4_.order_ordered_at AS order_ordered_at_17, d5_.id AS id_18, d5_.est_validated_at AS est_validated_at_19, d6_.prop_sub_visited_at AS prop_sub_visited_at_20, d7_.id AS id_21, d8_.id AS id_22 FROM dyna_investigation d0_ INNER JOIN dyna_physical_subject d3_ ON d0_.req_physical_subject_id = d3_.id INNER JOIN dyna_prest_grp d1_ ON d0_.req_prest_grp_id = d1_.id INNER JOIN dyna_record d9_ ON d0_.record_id = d9_.id LEFT JOIN dyna_estimation d5_ ON d0_.estimation_id = d5_.id INNER JOIN dyna_order d4_ ON d9_.order_id = d4_.id INNER JOIN dyna_user d2_ ON d4_.user_id = d2_.id INNER JOIN dyna_department d10_ ON d2_.department_id = d10_.id INNER JOIN dyna_branch d11_ ON d10_.branch_id = d11_.id INNER JOIN dyna_corporation d12_ ON d11_.corporation_id = d12_.id LEFT JOIN dyna_property_subject d6_ ON d0_.id = d6_.propSubReqInvestigation LEFT JOIN dyna_attachment d7_ ON d0_.id = d7_.att_investigation_id AND ( d7_.att_file_name LIKE '%lettre_de_mission%' ) LEFT JOIN dyna_attachment d8_ ON d0_.id = d8_.att_investigation_id AND (d8_.att_file_name LIKE '%devis%') WHERE d4_.order_ordered_at IS NOT NULL AND ( d0_.inv_is_cancelled IS NULL OR d0_.inv_is_cancelled = 0 ) AND d0_.inv_delivered_at IS NULL AND ( ( d0_.inv_is_waiting IS NULL OR d0_.inv_is_waiting = 0 ) ) AND d5_.est_validated_at IS NULL AND d2_.id = 132 ORDER BY d0_.id DESC SELECT d0_.id AS id_0, d0_.inv_user_reference AS inv_user_reference_1, d0_.inv_delay AS inv_delay_2, d0_.inv_is_monitored AS inv_is_monitored_3, d0_.inv_accepted_at AS inv_accepted_at_4, d0_.inv_predicted_delivered_at AS inv_predicted_delivered_at_5, d0_.inv_net_ref AS inv_net_ref_6, d0_.inv_has_priority AS inv_has_priority_7, d0_.inv_priority_deadline AS inv_priority_deadline_8, d0_.inv_accepted_at AS inv_accepted_at_9, d0_.etat AS etat_10, d1_.prest_grp_label AS prest_grp_label_11, d1_.prest_grp_form_type AS prest_grp_form_type_12, d2_.user_first_name AS user_first_name_13, d2_.user_last_name AS user_last_name_14, d3_.phys_sub_last_name AS phys_sub_last_name_15, d3_.phys_sub_first_name AS phys_sub_first_name_16, d4_.order_ordered_at AS order_ordered_at_17, d5_.id AS id_18, d5_.est_validated_at AS est_validated_at_19, d6_.prop_sub_visited_at AS prop_sub_visited_at_20, d7_.id AS id_21, d8_.id AS id_22 FROM dyna_investigation d0_ INNER JOIN dyna_physical_subject d3_ ON d0_.req_physical_subject_id = d3_.id INNER JOIN dyna_prest_grp d1_ ON d0_.req_prest_grp_id = d1_.id INNER JOIN dyna_record d9_ ON d0_.record_id = d9_.id LEFT JOIN dyna_estimation d5_ ON d0_.estimation_id = d5_.id INNER JOIN dyna_order d4_ ON d9_.order_id = d4_.id INNER JOIN dyna_user d2_ ON d4_.user_id = d2_.id INNER JOIN dyna_department d10_ ON d2_.department_id = d10_.id INNER JOIN dyna_branch d11_ ON d10_.branch_id = d11_.id INNER JOIN dyna_corporation d12_ ON d11_.corporation_id = d12_.id LEFT JOIN dyna_property_subject d6_ ON d0_.id = d6_.propSubReqInvestigation LEFT JOIN dyna_attachment d7_ ON d0_.id = d7_.att_investigation_id AND (d7_.att_file_name LIKE '%lettre_de_mission%') LEFT JOIN dyna_attachment d8_ ON d0_.id = d8_.att_investigation_id AND (d8_.att_file_name LIKE '%devis%') WHERE d4_.order_ordered_at IS NOT NULL AND (d0_.inv_is_cancelled IS NULL OR d0_.inv_is_cancelled = 0) AND d0_.inv_delivered_at IS NULL AND ((d0_.inv_is_waiting IS NULL OR d0_.inv_is_waiting = 0)) AND d5_.est_validated_at IS NULL AND d2_.id = 132 ORDER BY d0_.id DESC;
1.31 ms (7.53%)	1	SELECT d0_.id AS id_0, d0_.inv_user_reference AS inv_user_reference_1, d0_.inv_delay AS inv_delay_2, d0_.inv_is_monitored AS inv_is_monitored_3, d0_.inv_accepted_at AS inv_accepted_at_4, d0_.inv_predicted_delivered_at AS inv_predicted_delivered_at_5, d0_.inv_net_ref AS inv_net_ref_6, d0_.inv_has_priority AS inv_has_priority_7, d0_.inv_priority_deadline AS inv_priority_deadline_8, d0_.inv_accepted_at AS inv_accepted_at_9, d0_.etat AS etat_10, d1_.prest_grp_label AS prest_grp_label_11, d1_.prest_grp_form_type AS prest_grp_form_type_12, d2_.user_first_name AS user_first_name_13, d2_.user_last_name AS user_last_name_14, d3_.phys_sub_last_name AS phys_sub_last_name_15, d3_.phys_sub_first_name AS phys_sub_first_name_16, d4_.order_ordered_at AS order_ordered_at_17, d5_.id AS id_18, d5_.est_validated_at AS est_validated_at_19, d6_.prop_sub_visited_at AS prop_sub_visited_at_20, d7_.id AS id_21, d8_.id AS id_22 FROM dyna_investigation d0_ INNER JOIN dyna_physical_subject d3_ ON d0_.req_physical_subject_id = d3_.id INNER JOIN dyna_prest_grp d1_ ON d0_.req_prest_grp_id = d1_.id INNER JOIN dyna_record d9_ ON d0_.record_id = d9_.id LEFT JOIN dyna_estimation d5_ ON d0_.estimation_id = d5_.id INNER JOIN dyna_order d4_ ON d9_.order_id = d4_.id INNER JOIN dyna_user d2_ ON d4_.user_id = d2_.id INNER JOIN dyna_department d10_ ON d2_.department_id = d10_.id INNER JOIN dyna_branch d11_ ON d10_.branch_id = d11_.id INNER JOIN dyna_corporation d12_ ON d11_.corporation_id = d12_.id LEFT JOIN dyna_property_subject d6_ ON d0_.id = d6_.propSubReqInvestigation LEFT JOIN dyna_attachment d7_ ON d0_.id = d7_.att_investigation_id AND (d7_.att_file_name LIKE '%lettre_de_mission%') LEFT JOIN dyna_attachment d8_ ON d0_.id = d8_.att_investigation_id AND (d8_.att_file_name LIKE '%devis%') WHERE d4_.order_ordered_at IS NOT NULL AND (d0_.inv_is_cancelled IS NULL OR d0_.inv_is_cancelled = 0) AND d0_.inv_delivered_at IS NULL AND ((d0_.inv_is_waiting IS NULL OR d0_.inv_is_waiting = 0)) AND d2_.id = 132 ORDER BY d0_.id DESC Parameters: [] View formatted query View runnable query Explain query SELECT d0_.id AS id_0, d0_.inv_user_reference AS inv_user_reference_1, d0_.inv_delay AS inv_delay_2, d0_.inv_is_monitored AS inv_is_monitored_3, d0_.inv_accepted_at AS inv_accepted_at_4, d0_.inv_predicted_delivered_at AS inv_predicted_delivered_at_5, d0_.inv_net_ref AS inv_net_ref_6, d0_.inv_has_priority AS inv_has_priority_7, d0_.inv_priority_deadline AS inv_priority_deadline_8, d0_.inv_accepted_at AS inv_accepted_at_9, d0_.etat AS etat_10, d1_.prest_grp_label AS prest_grp_label_11, d1_.prest_grp_form_type AS prest_grp_form_type_12, d2_.user_first_name AS user_first_name_13, d2_.user_last_name AS user_last_name_14, d3_.phys_sub_last_name AS phys_sub_last_name_15, d3_.phys_sub_first_name AS phys_sub_first_name_16, d4_.order_ordered_at AS order_ordered_at_17, d5_.id AS id_18, d5_.est_validated_at AS est_validated_at_19, d6_.prop_sub_visited_at AS prop_sub_visited_at_20, d7_.id AS id_21, d8_.id AS id_22 FROM dyna_investigation d0_ INNER JOIN dyna_physical_subject d3_ ON d0_.req_physical_subject_id = d3_.id INNER JOIN dyna_prest_grp d1_ ON d0_.req_prest_grp_id = d1_.id INNER JOIN dyna_record d9_ ON d0_.record_id = d9_.id LEFT JOIN dyna_estimation d5_ ON d0_.estimation_id = d5_.id INNER JOIN dyna_order d4_ ON d9_.order_id = d4_.id INNER JOIN dyna_user d2_ ON d4_.user_id = d2_.id INNER JOIN dyna_department d10_ ON d2_.department_id = d10_.id INNER JOIN dyna_branch d11_ ON d10_.branch_id = d11_.id INNER JOIN dyna_corporation d12_ ON d11_.corporation_id = d12_.id LEFT JOIN dyna_property_subject d6_ ON d0_.id = d6_.propSubReqInvestigation LEFT JOIN dyna_attachment d7_ ON d0_.id = d7_.att_investigation_id AND ( d7_.att_file_name LIKE '%lettre_de_mission%' ) LEFT JOIN dyna_attachment d8_ ON d0_.id = d8_.att_investigation_id AND (d8_.att_file_name LIKE '%devis%') WHERE d4_.order_ordered_at IS NOT NULL AND ( d0_.inv_is_cancelled IS NULL OR d0_.inv_is_cancelled = 0 ) AND d0_.inv_delivered_at IS NULL AND ( ( d0_.inv_is_waiting IS NULL OR d0_.inv_is_waiting = 0 ) ) AND d2_.id = 132 ORDER BY d0_.id DESC SELECT d0_.id AS id_0, d0_.inv_user_reference AS inv_user_reference_1, d0_.inv_delay AS inv_delay_2, d0_.inv_is_monitored AS inv_is_monitored_3, d0_.inv_accepted_at AS inv_accepted_at_4, d0_.inv_predicted_delivered_at AS inv_predicted_delivered_at_5, d0_.inv_net_ref AS inv_net_ref_6, d0_.inv_has_priority AS inv_has_priority_7, d0_.inv_priority_deadline AS inv_priority_deadline_8, d0_.inv_accepted_at AS inv_accepted_at_9, d0_.etat AS etat_10, d1_.prest_grp_label AS prest_grp_label_11, d1_.prest_grp_form_type AS prest_grp_form_type_12, d2_.user_first_name AS user_first_name_13, d2_.user_last_name AS user_last_name_14, d3_.phys_sub_last_name AS phys_sub_last_name_15, d3_.phys_sub_first_name AS phys_sub_first_name_16, d4_.order_ordered_at AS order_ordered_at_17, d5_.id AS id_18, d5_.est_validated_at AS est_validated_at_19, d6_.prop_sub_visited_at AS prop_sub_visited_at_20, d7_.id AS id_21, d8_.id AS id_22 FROM dyna_investigation d0_ INNER JOIN dyna_physical_subject d3_ ON d0_.req_physical_subject_id = d3_.id INNER JOIN dyna_prest_grp d1_ ON d0_.req_prest_grp_id = d1_.id INNER JOIN dyna_record d9_ ON d0_.record_id = d9_.id LEFT JOIN dyna_estimation d5_ ON d0_.estimation_id = d5_.id INNER JOIN dyna_order d4_ ON d9_.order_id = d4_.id INNER JOIN dyna_user d2_ ON d4_.user_id = d2_.id INNER JOIN dyna_department d10_ ON d2_.department_id = d10_.id INNER JOIN dyna_branch d11_ ON d10_.branch_id = d11_.id INNER JOIN dyna_corporation d12_ ON d11_.corporation_id = d12_.id LEFT JOIN dyna_property_subject d6_ ON d0_.id = d6_.propSubReqInvestigation LEFT JOIN dyna_attachment d7_ ON d0_.id = d7_.att_investigation_id AND (d7_.att_file_name LIKE '%lettre_de_mission%') LEFT JOIN dyna_attachment d8_ ON d0_.id = d8_.att_investigation_id AND (d8_.att_file_name LIKE '%devis%') WHERE d4_.order_ordered_at IS NOT NULL AND (d0_.inv_is_cancelled IS NULL OR d0_.inv_is_cancelled = 0) AND d0_.inv_delivered_at IS NULL AND ((d0_.inv_is_waiting IS NULL OR d0_.inv_is_waiting = 0)) AND d2_.id = 132 ORDER BY d0_.id DESC;
1.09 ms (6.26%)	1	SELECT d0_.id AS id_0, d0_.inv_user_reference AS inv_user_reference_1, d0_.inv_delay AS inv_delay_2, d0_.inv_is_monitored AS inv_is_monitored_3, d0_.inv_accepted_at AS inv_accepted_at_4, d0_.inv_predicted_delivered_at AS inv_predicted_delivered_at_5, d0_.inv_net_ref AS inv_net_ref_6, d0_.inv_has_priority AS inv_has_priority_7, d0_.inv_priority_deadline AS inv_priority_deadline_8, d0_.inv_accepted_at AS inv_accepted_at_9, d0_.etat AS etat_10, d1_.prest_grp_label AS prest_grp_label_11, d1_.prest_grp_form_type AS prest_grp_form_type_12, d2_.user_first_name AS user_first_name_13, d2_.user_last_name AS user_last_name_14, d3_.phys_sub_last_name AS phys_sub_last_name_15, d3_.phys_sub_first_name AS phys_sub_first_name_16, d4_.order_ordered_at AS order_ordered_at_17, d5_.id AS id_18, d5_.est_validated_at AS est_validated_at_19, d6_.prop_sub_visited_at AS prop_sub_visited_at_20, d7_.id AS id_21, d8_.id AS id_22 FROM dyna_investigation d0_ INNER JOIN dyna_physical_subject d3_ ON d0_.req_physical_subject_id = d3_.id INNER JOIN dyna_prest_grp d1_ ON d0_.req_prest_grp_id = d1_.id INNER JOIN dyna_import d9_ ON d0_.import_id = d9_.id LEFT JOIN dyna_estimation d5_ ON d0_.estimation_id = d5_.id INNER JOIN dyna_order d4_ ON d9_.order_id = d4_.id INNER JOIN dyna_user d2_ ON d4_.user_id = d2_.id INNER JOIN dyna_department d10_ ON d2_.department_id = d10_.id INNER JOIN dyna_branch d11_ ON d10_.branch_id = d11_.id INNER JOIN dyna_corporation d12_ ON d11_.corporation_id = d12_.id LEFT JOIN dyna_property_subject d6_ ON d0_.id = d6_.propSubReqInvestigation LEFT JOIN dyna_attachment d7_ ON d0_.id = d7_.att_investigation_id AND (d7_.att_file_name LIKE '%lettre_de_mission%') LEFT JOIN dyna_attachment d8_ ON d0_.id = d8_.att_investigation_id AND (d8_.att_file_name LIKE '%devis%') WHERE d4_.order_ordered_at IS NOT NULL AND (d0_.inv_is_cancelled IS NULL OR d0_.inv_is_cancelled = 0) AND d0_.inv_delivered_at IS NULL AND ((d0_.inv_is_waiting IS NULL OR d0_.inv_is_waiting = 0)) AND d2_.id = 132 ORDER BY d0_.id DESC Parameters: [] View formatted query View runnable query Explain query SELECT d0_.id AS id_0, d0_.inv_user_reference AS inv_user_reference_1, d0_.inv_delay AS inv_delay_2, d0_.inv_is_monitored AS inv_is_monitored_3, d0_.inv_accepted_at AS inv_accepted_at_4, d0_.inv_predicted_delivered_at AS inv_predicted_delivered_at_5, d0_.inv_net_ref AS inv_net_ref_6, d0_.inv_has_priority AS inv_has_priority_7, d0_.inv_priority_deadline AS inv_priority_deadline_8, d0_.inv_accepted_at AS inv_accepted_at_9, d0_.etat AS etat_10, d1_.prest_grp_label AS prest_grp_label_11, d1_.prest_grp_form_type AS prest_grp_form_type_12, d2_.user_first_name AS user_first_name_13, d2_.user_last_name AS user_last_name_14, d3_.phys_sub_last_name AS phys_sub_last_name_15, d3_.phys_sub_first_name AS phys_sub_first_name_16, d4_.order_ordered_at AS order_ordered_at_17, d5_.id AS id_18, d5_.est_validated_at AS est_validated_at_19, d6_.prop_sub_visited_at AS prop_sub_visited_at_20, d7_.id AS id_21, d8_.id AS id_22 FROM dyna_investigation d0_ INNER JOIN dyna_physical_subject d3_ ON d0_.req_physical_subject_id = d3_.id INNER JOIN dyna_prest_grp d1_ ON d0_.req_prest_grp_id = d1_.id INNER JOIN dyna_import d9_ ON d0_.import_id = d9_.id LEFT JOIN dyna_estimation d5_ ON d0_.estimation_id = d5_.id INNER JOIN dyna_order d4_ ON d9_.order_id = d4_.id INNER JOIN dyna_user d2_ ON d4_.user_id = d2_.id INNER JOIN dyna_department d10_ ON d2_.department_id = d10_.id INNER JOIN dyna_branch d11_ ON d10_.branch_id = d11_.id INNER JOIN dyna_corporation d12_ ON d11_.corporation_id = d12_.id LEFT JOIN dyna_property_subject d6_ ON d0_.id = d6_.propSubReqInvestigation LEFT JOIN dyna_attachment d7_ ON d0_.id = d7_.att_investigation_id AND ( d7_.att_file_name LIKE '%lettre_de_mission%' ) LEFT JOIN dyna_attachment d8_ ON d0_.id = d8_.att_investigation_id AND (d8_.att_file_name LIKE '%devis%') WHERE d4_.order_ordered_at IS NOT NULL AND ( d0_.inv_is_cancelled IS NULL OR d0_.inv_is_cancelled = 0 ) AND d0_.inv_delivered_at IS NULL AND ( ( d0_.inv_is_waiting IS NULL OR d0_.inv_is_waiting = 0 ) ) AND d2_.id = 132 ORDER BY d0_.id DESC SELECT d0_.id AS id_0, d0_.inv_user_reference AS inv_user_reference_1, d0_.inv_delay AS inv_delay_2, d0_.inv_is_monitored AS inv_is_monitored_3, d0_.inv_accepted_at AS inv_accepted_at_4, d0_.inv_predicted_delivered_at AS inv_predicted_delivered_at_5, d0_.inv_net_ref AS inv_net_ref_6, d0_.inv_has_priority AS inv_has_priority_7, d0_.inv_priority_deadline AS inv_priority_deadline_8, d0_.inv_accepted_at AS inv_accepted_at_9, d0_.etat AS etat_10, d1_.prest_grp_label AS prest_grp_label_11, d1_.prest_grp_form_type AS prest_grp_form_type_12, d2_.user_first_name AS user_first_name_13, d2_.user_last_name AS user_last_name_14, d3_.phys_sub_last_name AS phys_sub_last_name_15, d3_.phys_sub_first_name AS phys_sub_first_name_16, d4_.order_ordered_at AS order_ordered_at_17, d5_.id AS id_18, d5_.est_validated_at AS est_validated_at_19, d6_.prop_sub_visited_at AS prop_sub_visited_at_20, d7_.id AS id_21, d8_.id AS id_22 FROM dyna_investigation d0_ INNER JOIN dyna_physical_subject d3_ ON d0_.req_physical_subject_id = d3_.id INNER JOIN dyna_prest_grp d1_ ON d0_.req_prest_grp_id = d1_.id INNER JOIN dyna_import d9_ ON d0_.import_id = d9_.id LEFT JOIN dyna_estimation d5_ ON d0_.estimation_id = d5_.id INNER JOIN dyna_order d4_ ON d9_.order_id = d4_.id INNER JOIN dyna_user d2_ ON d4_.user_id = d2_.id INNER JOIN dyna_department d10_ ON d2_.department_id = d10_.id INNER JOIN dyna_branch d11_ ON d10_.branch_id = d11_.id INNER JOIN dyna_corporation d12_ ON d11_.corporation_id = d12_.id LEFT JOIN dyna_property_subject d6_ ON d0_.id = d6_.propSubReqInvestigation LEFT JOIN dyna_attachment d7_ ON d0_.id = d7_.att_investigation_id AND (d7_.att_file_name LIKE '%lettre_de_mission%') LEFT JOIN dyna_attachment d8_ ON d0_.id = d8_.att_investigation_id AND (d8_.att_file_name LIKE '%devis%') WHERE d4_.order_ordered_at IS NOT NULL AND (d0_.inv_is_cancelled IS NULL OR d0_.inv_is_cancelled = 0) AND d0_.inv_delivered_at IS NULL AND ((d0_.inv_is_waiting IS NULL OR d0_.inv_is_waiting = 0)) AND d2_.id = 132 ORDER BY d0_.id DESC;
1.08 ms (6.18%)	1	SELECT d0_.id AS id_0, d0_.inv_user_reference AS inv_user_reference_1, d0_.inv_delay AS inv_delay_2, d0_.inv_is_monitored AS inv_is_monitored_3, d0_.inv_delivered_at AS inv_delivered_at_4, d0_.inv_net_ref AS inv_net_ref_5, d1_.prest_grp_label AS prest_grp_label_6, d1_.prest_grp_form_type AS prest_grp_form_type_7, d2_.user_first_name AS user_first_name_8, d2_.user_last_name AS user_last_name_9, d3_.corp_sub_corporate_name AS corp_sub_corporate_name_10, d3_.corp_sub_rcs AS corp_sub_rcs_11, d4_.report_has_been_downloaded AS report_has_been_downloaded_12, d5_.order_ordered_at AS order_ordered_at_13, d4_.report_is_available AS report_is_available_14, d6_.bill_is_available AS bill_is_available_15, d6_.bill_bl_is_available AS bill_bl_is_available_16, d0_.inv_report_unread AS inv_report_unread_17, d7_.inv_net_ref AS inv_net_ref_18, d8_.prop_sub_visited_at AS prop_sub_visited_at_19, d9_.id AS id_20, d10_.id AS id_21 FROM dyna_investigation d0_ INNER JOIN dyna_prest_grp d1_ ON d0_.req_prest_grp_id = d1_.id INNER JOIN dyna_record d11_ ON d0_.record_id = d11_.id LEFT JOIN dyna_report d4_ ON d0_.report_id = d4_.id LEFT JOIN dyna_bill d6_ ON d0_.bill_id = d6_.id LEFT JOIN dyna_investigation d7_ ON d0_.inv_couple_investigation_id = d7_.id INNER JOIN dyna_order d5_ ON d11_.order_id = d5_.id INNER JOIN dyna_user d2_ ON d5_.user_id = d2_.id INNER JOIN dyna_department d12_ ON d2_.department_id = d12_.id INNER JOIN dyna_branch d13_ ON d12_.branch_id = d13_.id INNER JOIN dyna_corporation d14_ ON d13_.corporation_id = d14_.id LEFT JOIN dyna_property_subject d8_ ON d0_.id = d8_.propSubReqInvestigation INNER JOIN dyna_corporation_subject d3_ ON d0_.req_corporation_subject_id = d3_.id LEFT JOIN dyna_attachment d9_ ON d0_.id = d9_.att_investigation_id AND (d9_.att_file_name LIKE '%lettre_de_mission%') LEFT JOIN dyna_attachment d10_ ON d0_.id = d10_.att_investigation_id AND (d10_.att_file_name LIKE '%devis%') WHERE d0_.inv_delivered_at IS NOT NULL AND d5_.order_ordered_at IS NOT NULL AND (d0_.inv_is_cancelled IS NULL OR d0_.inv_is_cancelled = 0) AND d2_.id = 132 ORDER BY d0_.inv_delivered_at DESC LIMIT 5 Parameters: [] View formatted query View runnable query Explain query SELECT d0_.id AS id_0, d0_.inv_user_reference AS inv_user_reference_1, d0_.inv_delay AS inv_delay_2, d0_.inv_is_monitored AS inv_is_monitored_3, d0_.inv_delivered_at AS inv_delivered_at_4, d0_.inv_net_ref AS inv_net_ref_5, d1_.prest_grp_label AS prest_grp_label_6, d1_.prest_grp_form_type AS prest_grp_form_type_7, d2_.user_first_name AS user_first_name_8, d2_.user_last_name AS user_last_name_9, d3_.corp_sub_corporate_name AS corp_sub_corporate_name_10, d3_.corp_sub_rcs AS corp_sub_rcs_11, d4_.report_has_been_downloaded AS report_has_been_downloaded_12, d5_.order_ordered_at AS order_ordered_at_13, d4_.report_is_available AS report_is_available_14, d6_.bill_is_available AS bill_is_available_15, d6_.bill_bl_is_available AS bill_bl_is_available_16, d0_.inv_report_unread AS inv_report_unread_17, d7_.inv_net_ref AS inv_net_ref_18, d8_.prop_sub_visited_at AS prop_sub_visited_at_19, d9_.id AS id_20, d10_.id AS id_21 FROM dyna_investigation d0_ INNER JOIN dyna_prest_grp d1_ ON d0_.req_prest_grp_id = d1_.id INNER JOIN dyna_record d11_ ON d0_.record_id = d11_.id LEFT JOIN dyna_report d4_ ON d0_.report_id = d4_.id LEFT JOIN dyna_bill d6_ ON d0_.bill_id = d6_.id LEFT JOIN dyna_investigation d7_ ON d0_.inv_couple_investigation_id = d7_.id INNER JOIN dyna_order d5_ ON d11_.order_id = d5_.id INNER JOIN dyna_user d2_ ON d5_.user_id = d2_.id INNER JOIN dyna_department d12_ ON d2_.department_id = d12_.id INNER JOIN dyna_branch d13_ ON d12_.branch_id = d13_.id INNER JOIN dyna_corporation d14_ ON d13_.corporation_id = d14_.id LEFT JOIN dyna_property_subject d8_ ON d0_.id = d8_.propSubReqInvestigation INNER JOIN dyna_corporation_subject d3_ ON d0_.req_corporation_subject_id = d3_.id LEFT JOIN dyna_attachment d9_ ON d0_.id = d9_.att_investigation_id AND ( d9_.att_file_name LIKE '%lettre_de_mission%' ) LEFT JOIN dyna_attachment d10_ ON d0_.id = d10_.att_investigation_id AND ( d10_.att_file_name LIKE '%devis%' ) WHERE d0_.inv_delivered_at IS NOT NULL AND d5_.order_ordered_at IS NOT NULL AND ( d0_.inv_is_cancelled IS NULL OR d0_.inv_is_cancelled = 0 ) AND d2_.id = 132 ORDER BY d0_.inv_delivered_at DESC LIMIT 5 SELECT d0_.id AS id_0, d0_.inv_user_reference AS inv_user_reference_1, d0_.inv_delay AS inv_delay_2, d0_.inv_is_monitored AS inv_is_monitored_3, d0_.inv_delivered_at AS inv_delivered_at_4, d0_.inv_net_ref AS inv_net_ref_5, d1_.prest_grp_label AS prest_grp_label_6, d1_.prest_grp_form_type AS prest_grp_form_type_7, d2_.user_first_name AS user_first_name_8, d2_.user_last_name AS user_last_name_9, d3_.corp_sub_corporate_name AS corp_sub_corporate_name_10, d3_.corp_sub_rcs AS corp_sub_rcs_11, d4_.report_has_been_downloaded AS report_has_been_downloaded_12, d5_.order_ordered_at AS order_ordered_at_13, d4_.report_is_available AS report_is_available_14, d6_.bill_is_available AS bill_is_available_15, d6_.bill_bl_is_available AS bill_bl_is_available_16, d0_.inv_report_unread AS inv_report_unread_17, d7_.inv_net_ref AS inv_net_ref_18, d8_.prop_sub_visited_at AS prop_sub_visited_at_19, d9_.id AS id_20, d10_.id AS id_21 FROM dyna_investigation d0_ INNER JOIN dyna_prest_grp d1_ ON d0_.req_prest_grp_id = d1_.id INNER JOIN dyna_record d11_ ON d0_.record_id = d11_.id LEFT JOIN dyna_report d4_ ON d0_.report_id = d4_.id LEFT JOIN dyna_bill d6_ ON d0_.bill_id = d6_.id LEFT JOIN dyna_investigation d7_ ON d0_.inv_couple_investigation_id = d7_.id INNER JOIN dyna_order d5_ ON d11_.order_id = d5_.id INNER JOIN dyna_user d2_ ON d5_.user_id = d2_.id INNER JOIN dyna_department d12_ ON d2_.department_id = d12_.id INNER JOIN dyna_branch d13_ ON d12_.branch_id = d13_.id INNER JOIN dyna_corporation d14_ ON d13_.corporation_id = d14_.id LEFT JOIN dyna_property_subject d8_ ON d0_.id = d8_.propSubReqInvestigation INNER JOIN dyna_corporation_subject d3_ ON d0_.req_corporation_subject_id = d3_.id LEFT JOIN dyna_attachment d9_ ON d0_.id = d9_.att_investigation_id AND (d9_.att_file_name LIKE '%lettre_de_mission%') LEFT JOIN dyna_attachment d10_ ON d0_.id = d10_.att_investigation_id AND (d10_.att_file_name LIKE '%devis%') WHERE d0_.inv_delivered_at IS NOT NULL AND d5_.order_ordered_at IS NOT NULL AND (d0_.inv_is_cancelled IS NULL OR d0_.inv_is_cancelled = 0) AND d2_.id = 132 ORDER BY d0_.inv_delivered_at DESC LIMIT 5;
1.07 ms (6.13%)	1	SELECT d0_.id AS id_0, d0_.inv_user_reference AS inv_user_reference_1, d0_.inv_delay AS inv_delay_2, d0_.inv_is_monitored AS inv_is_monitored_3, d0_.inv_delivered_at AS inv_delivered_at_4, d0_.inv_net_ref AS inv_net_ref_5, d1_.prest_grp_label AS prest_grp_label_6, d1_.prest_grp_form_type AS prest_grp_form_type_7, d2_.user_first_name AS user_first_name_8, d2_.user_last_name AS user_last_name_9, d3_.report_has_been_downloaded AS report_has_been_downloaded_10, d4_.order_ordered_at AS order_ordered_at_11, d3_.report_is_available AS report_is_available_12, d5_.bill_is_available AS bill_is_available_13, d5_.bill_bl_is_available AS bill_bl_is_available_14, d0_.inv_report_unread AS inv_report_unread_15, d6_.inv_net_ref AS inv_net_ref_16, d7_.prop_sub_visited_at AS prop_sub_visited_at_17, d8_.id AS id_18, d9_.id AS id_19 FROM dyna_investigation d0_ LEFT JOIN dyna_report d3_ ON d0_.report_id = d3_.id LEFT JOIN dyna_bill d5_ ON d0_.bill_id = d5_.id LEFT JOIN dyna_investigation d6_ ON d0_.inv_couple_investigation_id = d6_.id INNER JOIN dyna_prest_grp d1_ ON d0_.req_prest_grp_id = d1_.id INNER JOIN dyna_record d10_ ON d0_.record_id = d10_.id INNER JOIN dyna_order d4_ ON d10_.order_id = d4_.id INNER JOIN dyna_user d2_ ON d4_.user_id = d2_.id INNER JOIN dyna_department d11_ ON d2_.department_id = d11_.id INNER JOIN dyna_branch d12_ ON d11_.branch_id = d12_.id INNER JOIN dyna_corporation d13_ ON d12_.corporation_id = d13_.id LEFT JOIN dyna_property_subject d7_ ON d0_.id = d7_.propSubReqInvestigation LEFT JOIN dyna_attachment d8_ ON d0_.id = d8_.att_investigation_id AND (d8_.att_file_name LIKE '%lettre_de_mission%') LEFT JOIN dyna_attachment d9_ ON d0_.id = d9_.att_investigation_id AND (d9_.att_file_name LIKE '%devis%') WHERE d0_.inv_delivered_at IS NOT NULL AND d4_.order_ordered_at IS NOT NULL AND (d0_.inv_is_cancelled IS NULL OR d0_.inv_is_cancelled = 0) AND d0_.inv_zone_defined IS NOT NULL AND d2_.id = 132 ORDER BY d0_.inv_delivered_at DESC Parameters: [] View formatted query View runnable query Explain query SELECT d0_.id AS id_0, d0_.inv_user_reference AS inv_user_reference_1, d0_.inv_delay AS inv_delay_2, d0_.inv_is_monitored AS inv_is_monitored_3, d0_.inv_delivered_at AS inv_delivered_at_4, d0_.inv_net_ref AS inv_net_ref_5, d1_.prest_grp_label AS prest_grp_label_6, d1_.prest_grp_form_type AS prest_grp_form_type_7, d2_.user_first_name AS user_first_name_8, d2_.user_last_name AS user_last_name_9, d3_.report_has_been_downloaded AS report_has_been_downloaded_10, d4_.order_ordered_at AS order_ordered_at_11, d3_.report_is_available AS report_is_available_12, d5_.bill_is_available AS bill_is_available_13, d5_.bill_bl_is_available AS bill_bl_is_available_14, d0_.inv_report_unread AS inv_report_unread_15, d6_.inv_net_ref AS inv_net_ref_16, d7_.prop_sub_visited_at AS prop_sub_visited_at_17, d8_.id AS id_18, d9_.id AS id_19 FROM dyna_investigation d0_ LEFT JOIN dyna_report d3_ ON d0_.report_id = d3_.id LEFT JOIN dyna_bill d5_ ON d0_.bill_id = d5_.id LEFT JOIN dyna_investigation d6_ ON d0_.inv_couple_investigation_id = d6_.id INNER JOIN dyna_prest_grp d1_ ON d0_.req_prest_grp_id = d1_.id INNER JOIN dyna_record d10_ ON d0_.record_id = d10_.id INNER JOIN dyna_order d4_ ON d10_.order_id = d4_.id INNER JOIN dyna_user d2_ ON d4_.user_id = d2_.id INNER JOIN dyna_department d11_ ON d2_.department_id = d11_.id INNER JOIN dyna_branch d12_ ON d11_.branch_id = d12_.id INNER JOIN dyna_corporation d13_ ON d12_.corporation_id = d13_.id LEFT JOIN dyna_property_subject d7_ ON d0_.id = d7_.propSubReqInvestigation LEFT JOIN dyna_attachment d8_ ON d0_.id = d8_.att_investigation_id AND ( d8_.att_file_name LIKE '%lettre_de_mission%' ) LEFT JOIN dyna_attachment d9_ ON d0_.id = d9_.att_investigation_id AND (d9_.att_file_name LIKE '%devis%') WHERE d0_.inv_delivered_at IS NOT NULL AND d4_.order_ordered_at IS NOT NULL AND ( d0_.inv_is_cancelled IS NULL OR d0_.inv_is_cancelled = 0 ) AND d0_.inv_zone_defined IS NOT NULL AND d2_.id = 132 ORDER BY d0_.inv_delivered_at DESC SELECT d0_.id AS id_0, d0_.inv_user_reference AS inv_user_reference_1, d0_.inv_delay AS inv_delay_2, d0_.inv_is_monitored AS inv_is_monitored_3, d0_.inv_delivered_at AS inv_delivered_at_4, d0_.inv_net_ref AS inv_net_ref_5, d1_.prest_grp_label AS prest_grp_label_6, d1_.prest_grp_form_type AS prest_grp_form_type_7, d2_.user_first_name AS user_first_name_8, d2_.user_last_name AS user_last_name_9, d3_.report_has_been_downloaded AS report_has_been_downloaded_10, d4_.order_ordered_at AS order_ordered_at_11, d3_.report_is_available AS report_is_available_12, d5_.bill_is_available AS bill_is_available_13, d5_.bill_bl_is_available AS bill_bl_is_available_14, d0_.inv_report_unread AS inv_report_unread_15, d6_.inv_net_ref AS inv_net_ref_16, d7_.prop_sub_visited_at AS prop_sub_visited_at_17, d8_.id AS id_18, d9_.id AS id_19 FROM dyna_investigation d0_ LEFT JOIN dyna_report d3_ ON d0_.report_id = d3_.id LEFT JOIN dyna_bill d5_ ON d0_.bill_id = d5_.id LEFT JOIN dyna_investigation d6_ ON d0_.inv_couple_investigation_id = d6_.id INNER JOIN dyna_prest_grp d1_ ON d0_.req_prest_grp_id = d1_.id INNER JOIN dyna_record d10_ ON d0_.record_id = d10_.id INNER JOIN dyna_order d4_ ON d10_.order_id = d4_.id INNER JOIN dyna_user d2_ ON d4_.user_id = d2_.id INNER JOIN dyna_department d11_ ON d2_.department_id = d11_.id INNER JOIN dyna_branch d12_ ON d11_.branch_id = d12_.id INNER JOIN dyna_corporation d13_ ON d12_.corporation_id = d13_.id LEFT JOIN dyna_property_subject d7_ ON d0_.id = d7_.propSubReqInvestigation LEFT JOIN dyna_attachment d8_ ON d0_.id = d8_.att_investigation_id AND (d8_.att_file_name LIKE '%lettre_de_mission%') LEFT JOIN dyna_attachment d9_ ON d0_.id = d9_.att_investigation_id AND (d9_.att_file_name LIKE '%devis%') WHERE d0_.inv_delivered_at IS NOT NULL AND d4_.order_ordered_at IS NOT NULL AND (d0_.inv_is_cancelled IS NULL OR d0_.inv_is_cancelled = 0) AND d0_.inv_zone_defined IS NOT NULL AND d2_.id = 132 ORDER BY d0_.inv_delivered_at DESC;
1.06 ms (6.10%)	1	SELECT d0_.id AS id_0, d0_.inv_user_reference AS inv_user_reference_1, d0_.inv_delay AS inv_delay_2, d0_.inv_is_monitored AS inv_is_monitored_3, d0_.inv_accepted_at AS inv_accepted_at_4, d0_.inv_predicted_delivered_at AS inv_predicted_delivered_at_5, d0_.inv_net_ref AS inv_net_ref_6, d0_.inv_has_priority AS inv_has_priority_7, d0_.inv_priority_deadline AS inv_priority_deadline_8, d0_.inv_accepted_at AS inv_accepted_at_9, d0_.etat AS etat_10, d1_.prest_grp_label AS prest_grp_label_11, d1_.prest_grp_form_type AS prest_grp_form_type_12, d2_.user_first_name AS user_first_name_13, d2_.user_last_name AS user_last_name_14, d3_.corp_sub_corporate_name AS corp_sub_corporate_name_15, d3_.corp_sub_rcs AS corp_sub_rcs_16, d4_.order_ordered_at AS order_ordered_at_17, d5_.id AS id_18, d5_.est_validated_at AS est_validated_at_19, d6_.prop_sub_visited_at AS prop_sub_visited_at_20, d7_.id AS id_21, d8_.id AS id_22 FROM dyna_investigation d0_ INNER JOIN dyna_corporation_subject d3_ ON d0_.req_corporation_subject_id = d3_.id INNER JOIN dyna_prest_grp d1_ ON d0_.req_prest_grp_id = d1_.id INNER JOIN dyna_record d9_ ON d0_.record_id = d9_.id LEFT JOIN dyna_estimation d5_ ON d0_.estimation_id = d5_.id INNER JOIN dyna_order d4_ ON d9_.order_id = d4_.id INNER JOIN dyna_user d2_ ON d4_.user_id = d2_.id INNER JOIN dyna_department d10_ ON d2_.department_id = d10_.id INNER JOIN dyna_branch d11_ ON d10_.branch_id = d11_.id INNER JOIN dyna_corporation d12_ ON d11_.corporation_id = d12_.id LEFT JOIN dyna_property_subject d6_ ON d0_.id = d6_.propSubReqInvestigation LEFT JOIN dyna_attachment d7_ ON d0_.id = d7_.att_investigation_id AND (d7_.att_file_name LIKE '%lettre_de_mission%') LEFT JOIN dyna_attachment d8_ ON d0_.id = d8_.att_investigation_id AND (d8_.att_file_name LIKE '%devis%') WHERE d4_.order_ordered_at IS NOT NULL AND (d0_.inv_is_cancelled IS NULL OR d0_.inv_is_cancelled = 0) AND d0_.inv_delivered_at IS NULL AND ((d0_.inv_is_waiting IS NULL OR d0_.inv_is_waiting = 0)) AND d5_.est_validated_at IS NULL AND d2_.id = 132 ORDER BY d0_.id DESC Parameters: [] View formatted query View runnable query Explain query SELECT d0_.id AS id_0, d0_.inv_user_reference AS inv_user_reference_1, d0_.inv_delay AS inv_delay_2, d0_.inv_is_monitored AS inv_is_monitored_3, d0_.inv_accepted_at AS inv_accepted_at_4, d0_.inv_predicted_delivered_at AS inv_predicted_delivered_at_5, d0_.inv_net_ref AS inv_net_ref_6, d0_.inv_has_priority AS inv_has_priority_7, d0_.inv_priority_deadline AS inv_priority_deadline_8, d0_.inv_accepted_at AS inv_accepted_at_9, d0_.etat AS etat_10, d1_.prest_grp_label AS prest_grp_label_11, d1_.prest_grp_form_type AS prest_grp_form_type_12, d2_.user_first_name AS user_first_name_13, d2_.user_last_name AS user_last_name_14, d3_.corp_sub_corporate_name AS corp_sub_corporate_name_15, d3_.corp_sub_rcs AS corp_sub_rcs_16, d4_.order_ordered_at AS order_ordered_at_17, d5_.id AS id_18, d5_.est_validated_at AS est_validated_at_19, d6_.prop_sub_visited_at AS prop_sub_visited_at_20, d7_.id AS id_21, d8_.id AS id_22 FROM dyna_investigation d0_ INNER JOIN dyna_corporation_subject d3_ ON d0_.req_corporation_subject_id = d3_.id INNER JOIN dyna_prest_grp d1_ ON d0_.req_prest_grp_id = d1_.id INNER JOIN dyna_record d9_ ON d0_.record_id = d9_.id LEFT JOIN dyna_estimation d5_ ON d0_.estimation_id = d5_.id INNER JOIN dyna_order d4_ ON d9_.order_id = d4_.id INNER JOIN dyna_user d2_ ON d4_.user_id = d2_.id INNER JOIN dyna_department d10_ ON d2_.department_id = d10_.id INNER JOIN dyna_branch d11_ ON d10_.branch_id = d11_.id INNER JOIN dyna_corporation d12_ ON d11_.corporation_id = d12_.id LEFT JOIN dyna_property_subject d6_ ON d0_.id = d6_.propSubReqInvestigation LEFT JOIN dyna_attachment d7_ ON d0_.id = d7_.att_investigation_id AND ( d7_.att_file_name LIKE '%lettre_de_mission%' ) LEFT JOIN dyna_attachment d8_ ON d0_.id = d8_.att_investigation_id AND (d8_.att_file_name LIKE '%devis%') WHERE d4_.order_ordered_at IS NOT NULL AND ( d0_.inv_is_cancelled IS NULL OR d0_.inv_is_cancelled = 0 ) AND d0_.inv_delivered_at IS NULL AND ( ( d0_.inv_is_waiting IS NULL OR d0_.inv_is_waiting = 0 ) ) AND d5_.est_validated_at IS NULL AND d2_.id = 132 ORDER BY d0_.id DESC SELECT d0_.id AS id_0, d0_.inv_user_reference AS inv_user_reference_1, d0_.inv_delay AS inv_delay_2, d0_.inv_is_monitored AS inv_is_monitored_3, d0_.inv_accepted_at AS inv_accepted_at_4, d0_.inv_predicted_delivered_at AS inv_predicted_delivered_at_5, d0_.inv_net_ref AS inv_net_ref_6, d0_.inv_has_priority AS inv_has_priority_7, d0_.inv_priority_deadline AS inv_priority_deadline_8, d0_.inv_accepted_at AS inv_accepted_at_9, d0_.etat AS etat_10, d1_.prest_grp_label AS prest_grp_label_11, d1_.prest_grp_form_type AS prest_grp_form_type_12, d2_.user_first_name AS user_first_name_13, d2_.user_last_name AS user_last_name_14, d3_.corp_sub_corporate_name AS corp_sub_corporate_name_15, d3_.corp_sub_rcs AS corp_sub_rcs_16, d4_.order_ordered_at AS order_ordered_at_17, d5_.id AS id_18, d5_.est_validated_at AS est_validated_at_19, d6_.prop_sub_visited_at AS prop_sub_visited_at_20, d7_.id AS id_21, d8_.id AS id_22 FROM dyna_investigation d0_ INNER JOIN dyna_corporation_subject d3_ ON d0_.req_corporation_subject_id = d3_.id INNER JOIN dyna_prest_grp d1_ ON d0_.req_prest_grp_id = d1_.id INNER JOIN dyna_record d9_ ON d0_.record_id = d9_.id LEFT JOIN dyna_estimation d5_ ON d0_.estimation_id = d5_.id INNER JOIN dyna_order d4_ ON d9_.order_id = d4_.id INNER JOIN dyna_user d2_ ON d4_.user_id = d2_.id INNER JOIN dyna_department d10_ ON d2_.department_id = d10_.id INNER JOIN dyna_branch d11_ ON d10_.branch_id = d11_.id INNER JOIN dyna_corporation d12_ ON d11_.corporation_id = d12_.id LEFT JOIN dyna_property_subject d6_ ON d0_.id = d6_.propSubReqInvestigation LEFT JOIN dyna_attachment d7_ ON d0_.id = d7_.att_investigation_id AND (d7_.att_file_name LIKE '%lettre_de_mission%') LEFT JOIN dyna_attachment d8_ ON d0_.id = d8_.att_investigation_id AND (d8_.att_file_name LIKE '%devis%') WHERE d4_.order_ordered_at IS NOT NULL AND (d0_.inv_is_cancelled IS NULL OR d0_.inv_is_cancelled = 0) AND d0_.inv_delivered_at IS NULL AND ((d0_.inv_is_waiting IS NULL OR d0_.inv_is_waiting = 0)) AND d5_.est_validated_at IS NULL AND d2_.id = 132 ORDER BY d0_.id DESC;
1.04 ms (6.00%)	1	SELECT d0_.id AS id_0, d0_.inv_user_reference AS inv_user_reference_1, d0_.inv_delay AS inv_delay_2, d0_.inv_is_monitored AS inv_is_monitored_3, d0_.inv_delivered_at AS inv_delivered_at_4, d0_.inv_net_ref AS inv_net_ref_5, d1_.prest_grp_label AS prest_grp_label_6, d1_.prest_grp_form_type AS prest_grp_form_type_7, d2_.user_first_name AS user_first_name_8, d2_.user_last_name AS user_last_name_9, d3_.phys_sub_last_name AS phys_sub_last_name_10, d3_.phys_sub_first_name AS phys_sub_first_name_11, d4_.report_has_been_downloaded AS report_has_been_downloaded_12, d5_.order_ordered_at AS order_ordered_at_13, d4_.report_is_available AS report_is_available_14, d6_.bill_is_available AS bill_is_available_15, d6_.bill_bl_is_available AS bill_bl_is_available_16, d0_.inv_report_unread AS inv_report_unread_17, d7_.inv_net_ref AS inv_net_ref_18, d8_.id AS id_19, d9_.id AS id_20, d10_.prop_sub_visited_at AS prop_sub_visited_at_21 FROM dyna_investigation d0_ INNER JOIN dyna_physical_subject d3_ ON d0_.req_physical_subject_id = d3_.id LEFT JOIN dyna_report d4_ ON d0_.report_id = d4_.id LEFT JOIN dyna_bill d6_ ON d0_.bill_id = d6_.id LEFT JOIN dyna_investigation d7_ ON d0_.inv_couple_investigation_id = d7_.id INNER JOIN dyna_prest_grp d1_ ON d0_.req_prest_grp_id = d1_.id INNER JOIN dyna_record d11_ ON d0_.record_id = d11_.id INNER JOIN dyna_order d5_ ON d11_.order_id = d5_.id INNER JOIN dyna_user d2_ ON d5_.user_id = d2_.id INNER JOIN dyna_department d12_ ON d2_.department_id = d12_.id INNER JOIN dyna_branch d13_ ON d12_.branch_id = d13_.id INNER JOIN dyna_corporation d14_ ON d13_.corporation_id = d14_.id LEFT JOIN dyna_attachment d8_ ON d0_.id = d8_.att_investigation_id AND (d8_.att_file_name LIKE '%lettre_de_mission%') LEFT JOIN dyna_attachment d9_ ON d0_.id = d9_.att_investigation_id AND (d9_.att_file_name LIKE '%devis%') LEFT JOIN dyna_property_subject d10_ ON d0_.id = d10_.propSubReqInvestigation WHERE d0_.inv_delivered_at IS NOT NULL AND d5_.order_ordered_at IS NOT NULL AND (d0_.inv_is_cancelled IS NULL OR d0_.inv_is_cancelled = 0) AND d2_.id = 132 ORDER BY d0_.inv_delivered_at DESC LIMIT 5 Parameters: [] View formatted query View runnable query Explain query SELECT d0_.id AS id_0, d0_.inv_user_reference AS inv_user_reference_1, d0_.inv_delay AS inv_delay_2, d0_.inv_is_monitored AS inv_is_monitored_3, d0_.inv_delivered_at AS inv_delivered_at_4, d0_.inv_net_ref AS inv_net_ref_5, d1_.prest_grp_label AS prest_grp_label_6, d1_.prest_grp_form_type AS prest_grp_form_type_7, d2_.user_first_name AS user_first_name_8, d2_.user_last_name AS user_last_name_9, d3_.phys_sub_last_name AS phys_sub_last_name_10, d3_.phys_sub_first_name AS phys_sub_first_name_11, d4_.report_has_been_downloaded AS report_has_been_downloaded_12, d5_.order_ordered_at AS order_ordered_at_13, d4_.report_is_available AS report_is_available_14, d6_.bill_is_available AS bill_is_available_15, d6_.bill_bl_is_available AS bill_bl_is_available_16, d0_.inv_report_unread AS inv_report_unread_17, d7_.inv_net_ref AS inv_net_ref_18, d8_.id AS id_19, d9_.id AS id_20, d10_.prop_sub_visited_at AS prop_sub_visited_at_21 FROM dyna_investigation d0_ INNER JOIN dyna_physical_subject d3_ ON d0_.req_physical_subject_id = d3_.id LEFT JOIN dyna_report d4_ ON d0_.report_id = d4_.id LEFT JOIN dyna_bill d6_ ON d0_.bill_id = d6_.id LEFT JOIN dyna_investigation d7_ ON d0_.inv_couple_investigation_id = d7_.id INNER JOIN dyna_prest_grp d1_ ON d0_.req_prest_grp_id = d1_.id INNER JOIN dyna_record d11_ ON d0_.record_id = d11_.id INNER JOIN dyna_order d5_ ON d11_.order_id = d5_.id INNER JOIN dyna_user d2_ ON d5_.user_id = d2_.id INNER JOIN dyna_department d12_ ON d2_.department_id = d12_.id INNER JOIN dyna_branch d13_ ON d12_.branch_id = d13_.id INNER JOIN dyna_corporation d14_ ON d13_.corporation_id = d14_.id LEFT JOIN dyna_attachment d8_ ON d0_.id = d8_.att_investigation_id AND ( d8_.att_file_name LIKE '%lettre_de_mission%' ) LEFT JOIN dyna_attachment d9_ ON d0_.id = d9_.att_investigation_id AND (d9_.att_file_name LIKE '%devis%') LEFT JOIN dyna_property_subject d10_ ON d0_.id = d10_.propSubReqInvestigation WHERE d0_.inv_delivered_at IS NOT NULL AND d5_.order_ordered_at IS NOT NULL AND ( d0_.inv_is_cancelled IS NULL OR d0_.inv_is_cancelled = 0 ) AND d2_.id = 132 ORDER BY d0_.inv_delivered_at DESC LIMIT 5 SELECT d0_.id AS id_0, d0_.inv_user_reference AS inv_user_reference_1, d0_.inv_delay AS inv_delay_2, d0_.inv_is_monitored AS inv_is_monitored_3, d0_.inv_delivered_at AS inv_delivered_at_4, d0_.inv_net_ref AS inv_net_ref_5, d1_.prest_grp_label AS prest_grp_label_6, d1_.prest_grp_form_type AS prest_grp_form_type_7, d2_.user_first_name AS user_first_name_8, d2_.user_last_name AS user_last_name_9, d3_.phys_sub_last_name AS phys_sub_last_name_10, d3_.phys_sub_first_name AS phys_sub_first_name_11, d4_.report_has_been_downloaded AS report_has_been_downloaded_12, d5_.order_ordered_at AS order_ordered_at_13, d4_.report_is_available AS report_is_available_14, d6_.bill_is_available AS bill_is_available_15, d6_.bill_bl_is_available AS bill_bl_is_available_16, d0_.inv_report_unread AS inv_report_unread_17, d7_.inv_net_ref AS inv_net_ref_18, d8_.id AS id_19, d9_.id AS id_20, d10_.prop_sub_visited_at AS prop_sub_visited_at_21 FROM dyna_investigation d0_ INNER JOIN dyna_physical_subject d3_ ON d0_.req_physical_subject_id = d3_.id LEFT JOIN dyna_report d4_ ON d0_.report_id = d4_.id LEFT JOIN dyna_bill d6_ ON d0_.bill_id = d6_.id LEFT JOIN dyna_investigation d7_ ON d0_.inv_couple_investigation_id = d7_.id INNER JOIN dyna_prest_grp d1_ ON d0_.req_prest_grp_id = d1_.id INNER JOIN dyna_record d11_ ON d0_.record_id = d11_.id INNER JOIN dyna_order d5_ ON d11_.order_id = d5_.id INNER JOIN dyna_user d2_ ON d5_.user_id = d2_.id INNER JOIN dyna_department d12_ ON d2_.department_id = d12_.id INNER JOIN dyna_branch d13_ ON d12_.branch_id = d13_.id INNER JOIN dyna_corporation d14_ ON d13_.corporation_id = d14_.id LEFT JOIN dyna_attachment d8_ ON d0_.id = d8_.att_investigation_id AND (d8_.att_file_name LIKE '%lettre_de_mission%') LEFT JOIN dyna_attachment d9_ ON d0_.id = d9_.att_investigation_id AND (d9_.att_file_name LIKE '%devis%') LEFT JOIN dyna_property_subject d10_ ON d0_.id = d10_.propSubReqInvestigation WHERE d0_.inv_delivered_at IS NOT NULL AND d5_.order_ordered_at IS NOT NULL AND (d0_.inv_is_cancelled IS NULL OR d0_.inv_is_cancelled = 0) AND d2_.id = 132 ORDER BY d0_.inv_delivered_at DESC LIMIT 5;
1.04 ms (5.99%)	1	SELECT d0_.id AS id_0, d0_.inv_user_reference AS inv_user_reference_1, d0_.inv_delay AS inv_delay_2, d0_.inv_is_monitored AS inv_is_monitored_3, d0_.inv_accepted_at AS inv_accepted_at_4, d0_.inv_predicted_delivered_at AS inv_predicted_delivered_at_5, d0_.inv_net_ref AS inv_net_ref_6, d0_.inv_has_priority AS inv_has_priority_7, d0_.inv_priority_deadline AS inv_priority_deadline_8, d0_.inv_accepted_at AS inv_accepted_at_9, d0_.etat AS etat_10, d1_.prest_grp_label AS prest_grp_label_11, d1_.prest_grp_form_type AS prest_grp_form_type_12, d2_.user_first_name AS user_first_name_13, d2_.user_last_name AS user_last_name_14, d3_.corp_sub_corporate_name AS corp_sub_corporate_name_15, d3_.corp_sub_rcs AS corp_sub_rcs_16, d4_.order_ordered_at AS order_ordered_at_17, d5_.id AS id_18, d5_.est_validated_at AS est_validated_at_19, d6_.prop_sub_visited_at AS prop_sub_visited_at_20, d7_.id AS id_21, d8_.id AS id_22 FROM dyna_investigation d0_ INNER JOIN dyna_corporation_subject d3_ ON d0_.req_corporation_subject_id = d3_.id INNER JOIN dyna_prest_grp d1_ ON d0_.req_prest_grp_id = d1_.id INNER JOIN dyna_record d9_ ON d0_.record_id = d9_.id LEFT JOIN dyna_estimation d5_ ON d0_.estimation_id = d5_.id INNER JOIN dyna_order d4_ ON d9_.order_id = d4_.id INNER JOIN dyna_user d2_ ON d4_.user_id = d2_.id INNER JOIN dyna_department d10_ ON d2_.department_id = d10_.id INNER JOIN dyna_branch d11_ ON d10_.branch_id = d11_.id INNER JOIN dyna_corporation d12_ ON d11_.corporation_id = d12_.id LEFT JOIN dyna_property_subject d6_ ON d0_.id = d6_.propSubReqInvestigation LEFT JOIN dyna_attachment d7_ ON d0_.id = d7_.att_investigation_id AND (d7_.att_file_name LIKE '%lettre_de_mission%') LEFT JOIN dyna_attachment d8_ ON d0_.id = d8_.att_investigation_id AND (d8_.att_file_name LIKE '%devis%') WHERE d4_.order_ordered_at IS NOT NULL AND (d0_.inv_is_cancelled IS NULL OR d0_.inv_is_cancelled = 0) AND d0_.inv_delivered_at IS NULL AND ((d0_.inv_is_waiting IS NULL OR d0_.inv_is_waiting = 0)) AND d2_.id = 132 ORDER BY d0_.id DESC Parameters: [] View formatted query View runnable query Explain query SELECT d0_.id AS id_0, d0_.inv_user_reference AS inv_user_reference_1, d0_.inv_delay AS inv_delay_2, d0_.inv_is_monitored AS inv_is_monitored_3, d0_.inv_accepted_at AS inv_accepted_at_4, d0_.inv_predicted_delivered_at AS inv_predicted_delivered_at_5, d0_.inv_net_ref AS inv_net_ref_6, d0_.inv_has_priority AS inv_has_priority_7, d0_.inv_priority_deadline AS inv_priority_deadline_8, d0_.inv_accepted_at AS inv_accepted_at_9, d0_.etat AS etat_10, d1_.prest_grp_label AS prest_grp_label_11, d1_.prest_grp_form_type AS prest_grp_form_type_12, d2_.user_first_name AS user_first_name_13, d2_.user_last_name AS user_last_name_14, d3_.corp_sub_corporate_name AS corp_sub_corporate_name_15, d3_.corp_sub_rcs AS corp_sub_rcs_16, d4_.order_ordered_at AS order_ordered_at_17, d5_.id AS id_18, d5_.est_validated_at AS est_validated_at_19, d6_.prop_sub_visited_at AS prop_sub_visited_at_20, d7_.id AS id_21, d8_.id AS id_22 FROM dyna_investigation d0_ INNER JOIN dyna_corporation_subject d3_ ON d0_.req_corporation_subject_id = d3_.id INNER JOIN dyna_prest_grp d1_ ON d0_.req_prest_grp_id = d1_.id INNER JOIN dyna_record d9_ ON d0_.record_id = d9_.id LEFT JOIN dyna_estimation d5_ ON d0_.estimation_id = d5_.id INNER JOIN dyna_order d4_ ON d9_.order_id = d4_.id INNER JOIN dyna_user d2_ ON d4_.user_id = d2_.id INNER JOIN dyna_department d10_ ON d2_.department_id = d10_.id INNER JOIN dyna_branch d11_ ON d10_.branch_id = d11_.id INNER JOIN dyna_corporation d12_ ON d11_.corporation_id = d12_.id LEFT JOIN dyna_property_subject d6_ ON d0_.id = d6_.propSubReqInvestigation LEFT JOIN dyna_attachment d7_ ON d0_.id = d7_.att_investigation_id AND ( d7_.att_file_name LIKE '%lettre_de_mission%' ) LEFT JOIN dyna_attachment d8_ ON d0_.id = d8_.att_investigation_id AND (d8_.att_file_name LIKE '%devis%') WHERE d4_.order_ordered_at IS NOT NULL AND ( d0_.inv_is_cancelled IS NULL OR d0_.inv_is_cancelled = 0 ) AND d0_.inv_delivered_at IS NULL AND ( ( d0_.inv_is_waiting IS NULL OR d0_.inv_is_waiting = 0 ) ) AND d2_.id = 132 ORDER BY d0_.id DESC SELECT d0_.id AS id_0, d0_.inv_user_reference AS inv_user_reference_1, d0_.inv_delay AS inv_delay_2, d0_.inv_is_monitored AS inv_is_monitored_3, d0_.inv_accepted_at AS inv_accepted_at_4, d0_.inv_predicted_delivered_at AS inv_predicted_delivered_at_5, d0_.inv_net_ref AS inv_net_ref_6, d0_.inv_has_priority AS inv_has_priority_7, d0_.inv_priority_deadline AS inv_priority_deadline_8, d0_.inv_accepted_at AS inv_accepted_at_9, d0_.etat AS etat_10, d1_.prest_grp_label AS prest_grp_label_11, d1_.prest_grp_form_type AS prest_grp_form_type_12, d2_.user_first_name AS user_first_name_13, d2_.user_last_name AS user_last_name_14, d3_.corp_sub_corporate_name AS corp_sub_corporate_name_15, d3_.corp_sub_rcs AS corp_sub_rcs_16, d4_.order_ordered_at AS order_ordered_at_17, d5_.id AS id_18, d5_.est_validated_at AS est_validated_at_19, d6_.prop_sub_visited_at AS prop_sub_visited_at_20, d7_.id AS id_21, d8_.id AS id_22 FROM dyna_investigation d0_ INNER JOIN dyna_corporation_subject d3_ ON d0_.req_corporation_subject_id = d3_.id INNER JOIN dyna_prest_grp d1_ ON d0_.req_prest_grp_id = d1_.id INNER JOIN dyna_record d9_ ON d0_.record_id = d9_.id LEFT JOIN dyna_estimation d5_ ON d0_.estimation_id = d5_.id INNER JOIN dyna_order d4_ ON d9_.order_id = d4_.id INNER JOIN dyna_user d2_ ON d4_.user_id = d2_.id INNER JOIN dyna_department d10_ ON d2_.department_id = d10_.id INNER JOIN dyna_branch d11_ ON d10_.branch_id = d11_.id INNER JOIN dyna_corporation d12_ ON d11_.corporation_id = d12_.id LEFT JOIN dyna_property_subject d6_ ON d0_.id = d6_.propSubReqInvestigation LEFT JOIN dyna_attachment d7_ ON d0_.id = d7_.att_investigation_id AND (d7_.att_file_name LIKE '%lettre_de_mission%') LEFT JOIN dyna_attachment d8_ ON d0_.id = d8_.att_investigation_id AND (d8_.att_file_name LIKE '%devis%') WHERE d4_.order_ordered_at IS NOT NULL AND (d0_.inv_is_cancelled IS NULL OR d0_.inv_is_cancelled = 0) AND d0_.inv_delivered_at IS NULL AND ((d0_.inv_is_waiting IS NULL OR d0_.inv_is_waiting = 0)) AND d2_.id = 132 ORDER BY d0_.id DESC;
1.04 ms (5.97%)	1	SELECT d0_.id AS id_0, d0_.inv_user_reference AS inv_user_reference_1, d0_.inv_delay AS inv_delay_2, d0_.inv_is_monitored AS inv_is_monitored_3, d0_.inv_delivered_at AS inv_delivered_at_4, d0_.inv_net_ref AS inv_net_ref_5, d1_.prest_grp_label AS prest_grp_label_6, d1_.prest_grp_form_type AS prest_grp_form_type_7, d2_.user_first_name AS user_first_name_8, d2_.user_last_name AS user_last_name_9, d3_.phys_sub_last_name AS phys_sub_last_name_10, d3_.phys_sub_first_name AS phys_sub_first_name_11, d4_.report_has_been_downloaded AS report_has_been_downloaded_12, d5_.order_ordered_at AS order_ordered_at_13, d4_.report_is_available AS report_is_available_14, d6_.bill_is_available AS bill_is_available_15, d6_.bill_bl_is_available AS bill_bl_is_available_16, d0_.inv_report_unread AS inv_report_unread_17, d7_.inv_net_ref AS inv_net_ref_18, d8_.prop_sub_visited_at AS prop_sub_visited_at_19, d9_.id AS id_20, d10_.id AS id_21 FROM dyna_investigation d0_ INNER JOIN dyna_physical_subject d3_ ON d0_.req_physical_subject_id = d3_.id INNER JOIN dyna_prest_grp d1_ ON d0_.req_prest_grp_id = d1_.id LEFT JOIN dyna_report d4_ ON d0_.report_id = d4_.id LEFT JOIN dyna_bill d6_ ON d0_.bill_id = d6_.id LEFT JOIN dyna_investigation d7_ ON d0_.inv_couple_investigation_id = d7_.id INNER JOIN dyna_import d11_ ON d0_.import_id = d11_.id INNER JOIN dyna_order d5_ ON d11_.order_id = d5_.id INNER JOIN dyna_user d2_ ON d5_.user_id = d2_.id INNER JOIN dyna_department d12_ ON d2_.department_id = d12_.id INNER JOIN dyna_branch d13_ ON d12_.branch_id = d13_.id INNER JOIN dyna_corporation d14_ ON d13_.corporation_id = d14_.id LEFT JOIN dyna_property_subject d8_ ON d0_.id = d8_.propSubReqInvestigation LEFT JOIN dyna_attachment d9_ ON d0_.id = d9_.att_investigation_id AND (d9_.att_file_name LIKE '%lettre_de_mission%') LEFT JOIN dyna_attachment d10_ ON d0_.id = d10_.att_investigation_id AND (d10_.att_file_name LIKE '%devis%') WHERE d0_.inv_delivered_at IS NOT NULL AND (d0_.inv_is_cancelled IS NULL OR d0_.inv_is_cancelled = 0) AND d2_.id = 132 ORDER BY d0_.inv_delivered_at DESC LIMIT 5 Parameters: [] View formatted query View runnable query Explain query SELECT d0_.id AS id_0, d0_.inv_user_reference AS inv_user_reference_1, d0_.inv_delay AS inv_delay_2, d0_.inv_is_monitored AS inv_is_monitored_3, d0_.inv_delivered_at AS inv_delivered_at_4, d0_.inv_net_ref AS inv_net_ref_5, d1_.prest_grp_label AS prest_grp_label_6, d1_.prest_grp_form_type AS prest_grp_form_type_7, d2_.user_first_name AS user_first_name_8, d2_.user_last_name AS user_last_name_9, d3_.phys_sub_last_name AS phys_sub_last_name_10, d3_.phys_sub_first_name AS phys_sub_first_name_11, d4_.report_has_been_downloaded AS report_has_been_downloaded_12, d5_.order_ordered_at AS order_ordered_at_13, d4_.report_is_available AS report_is_available_14, d6_.bill_is_available AS bill_is_available_15, d6_.bill_bl_is_available AS bill_bl_is_available_16, d0_.inv_report_unread AS inv_report_unread_17, d7_.inv_net_ref AS inv_net_ref_18, d8_.prop_sub_visited_at AS prop_sub_visited_at_19, d9_.id AS id_20, d10_.id AS id_21 FROM dyna_investigation d0_ INNER JOIN dyna_physical_subject d3_ ON d0_.req_physical_subject_id = d3_.id INNER JOIN dyna_prest_grp d1_ ON d0_.req_prest_grp_id = d1_.id LEFT JOIN dyna_report d4_ ON d0_.report_id = d4_.id LEFT JOIN dyna_bill d6_ ON d0_.bill_id = d6_.id LEFT JOIN dyna_investigation d7_ ON d0_.inv_couple_investigation_id = d7_.id INNER JOIN dyna_import d11_ ON d0_.import_id = d11_.id INNER JOIN dyna_order d5_ ON d11_.order_id = d5_.id INNER JOIN dyna_user d2_ ON d5_.user_id = d2_.id INNER JOIN dyna_department d12_ ON d2_.department_id = d12_.id INNER JOIN dyna_branch d13_ ON d12_.branch_id = d13_.id INNER JOIN dyna_corporation d14_ ON d13_.corporation_id = d14_.id LEFT JOIN dyna_property_subject d8_ ON d0_.id = d8_.propSubReqInvestigation LEFT JOIN dyna_attachment d9_ ON d0_.id = d9_.att_investigation_id AND ( d9_.att_file_name LIKE '%lettre_de_mission%' ) LEFT JOIN dyna_attachment d10_ ON d0_.id = d10_.att_investigation_id AND ( d10_.att_file_name LIKE '%devis%' ) WHERE d0_.inv_delivered_at IS NOT NULL AND ( d0_.inv_is_cancelled IS NULL OR d0_.inv_is_cancelled = 0 ) AND d2_.id = 132 ORDER BY d0_.inv_delivered_at DESC LIMIT 5 SELECT d0_.id AS id_0, d0_.inv_user_reference AS inv_user_reference_1, d0_.inv_delay AS inv_delay_2, d0_.inv_is_monitored AS inv_is_monitored_3, d0_.inv_delivered_at AS inv_delivered_at_4, d0_.inv_net_ref AS inv_net_ref_5, d1_.prest_grp_label AS prest_grp_label_6, d1_.prest_grp_form_type AS prest_grp_form_type_7, d2_.user_first_name AS user_first_name_8, d2_.user_last_name AS user_last_name_9, d3_.phys_sub_last_name AS phys_sub_last_name_10, d3_.phys_sub_first_name AS phys_sub_first_name_11, d4_.report_has_been_downloaded AS report_has_been_downloaded_12, d5_.order_ordered_at AS order_ordered_at_13, d4_.report_is_available AS report_is_available_14, d6_.bill_is_available AS bill_is_available_15, d6_.bill_bl_is_available AS bill_bl_is_available_16, d0_.inv_report_unread AS inv_report_unread_17, d7_.inv_net_ref AS inv_net_ref_18, d8_.prop_sub_visited_at AS prop_sub_visited_at_19, d9_.id AS id_20, d10_.id AS id_21 FROM dyna_investigation d0_ INNER JOIN dyna_physical_subject d3_ ON d0_.req_physical_subject_id = d3_.id INNER JOIN dyna_prest_grp d1_ ON d0_.req_prest_grp_id = d1_.id LEFT JOIN dyna_report d4_ ON d0_.report_id = d4_.id LEFT JOIN dyna_bill d6_ ON d0_.bill_id = d6_.id LEFT JOIN dyna_investigation d7_ ON d0_.inv_couple_investigation_id = d7_.id INNER JOIN dyna_import d11_ ON d0_.import_id = d11_.id INNER JOIN dyna_order d5_ ON d11_.order_id = d5_.id INNER JOIN dyna_user d2_ ON d5_.user_id = d2_.id INNER JOIN dyna_department d12_ ON d2_.department_id = d12_.id INNER JOIN dyna_branch d13_ ON d12_.branch_id = d13_.id INNER JOIN dyna_corporation d14_ ON d13_.corporation_id = d14_.id LEFT JOIN dyna_property_subject d8_ ON d0_.id = d8_.propSubReqInvestigation LEFT JOIN dyna_attachment d9_ ON d0_.id = d9_.att_investigation_id AND (d9_.att_file_name LIKE '%lettre_de_mission%') LEFT JOIN dyna_attachment d10_ ON d0_.id = d10_.att_investigation_id AND (d10_.att_file_name LIKE '%devis%') WHERE d0_.inv_delivered_at IS NOT NULL AND (d0_.inv_is_cancelled IS NULL OR d0_.inv_is_cancelled = 0) AND d2_.id = 132 ORDER BY d0_.inv_delivered_at DESC LIMIT 5;
1.01 ms (5.80%)	1	SELECT d0_.id AS id_0, d0_.inv_user_reference AS inv_user_reference_1, d0_.inv_delay AS inv_delay_2, d0_.inv_is_monitored AS inv_is_monitored_3, d0_.inv_accepted_at AS inv_accepted_at_4, d0_.inv_predicted_delivered_at AS inv_predicted_delivered_at_5, d0_.inv_net_ref AS inv_net_ref_6, d0_.inv_has_priority AS inv_has_priority_7, d0_.inv_priority_deadline AS inv_priority_deadline_8, d0_.inv_accepted_at AS inv_accepted_at_9, d0_.etat AS etat_10, d1_.prest_grp_label AS prest_grp_label_11, d1_.prest_grp_form_type AS prest_grp_form_type_12, d2_.user_first_name AS user_first_name_13, d2_.user_last_name AS user_last_name_14, d3_.phys_sub_last_name AS phys_sub_last_name_15, d3_.phys_sub_first_name AS phys_sub_first_name_16, d4_.order_ordered_at AS order_ordered_at_17, d5_.id AS id_18, d5_.est_validated_at AS est_validated_at_19, d6_.prop_sub_visited_at AS prop_sub_visited_at_20, d7_.id AS id_21, d8_.id AS id_22 FROM dyna_investigation d0_ INNER JOIN dyna_physical_subject d3_ ON d0_.req_physical_subject_id = d3_.id INNER JOIN dyna_prest_grp d1_ ON d0_.req_prest_grp_id = d1_.id INNER JOIN dyna_import d9_ ON d0_.import_id = d9_.id LEFT JOIN dyna_estimation d5_ ON d0_.estimation_id = d5_.id INNER JOIN dyna_order d4_ ON d9_.order_id = d4_.id INNER JOIN dyna_user d2_ ON d4_.user_id = d2_.id INNER JOIN dyna_department d10_ ON d2_.department_id = d10_.id INNER JOIN dyna_branch d11_ ON d10_.branch_id = d11_.id INNER JOIN dyna_corporation d12_ ON d11_.corporation_id = d12_.id LEFT JOIN dyna_property_subject d6_ ON d0_.id = d6_.propSubReqInvestigation LEFT JOIN dyna_attachment d7_ ON d0_.id = d7_.att_investigation_id AND (d7_.att_file_name LIKE '%lettre_de_mission%') LEFT JOIN dyna_attachment d8_ ON d0_.id = d8_.att_investigation_id AND (d8_.att_file_name LIKE '%devis%') WHERE d4_.order_ordered_at IS NOT NULL AND (d0_.inv_is_cancelled IS NULL OR d0_.inv_is_cancelled = 0) AND d0_.inv_delivered_at IS NULL AND ((d0_.inv_is_waiting IS NULL OR d0_.inv_is_waiting = 0)) AND d5_.est_validated_at IS NULL AND d2_.id = 132 ORDER BY d0_.id DESC Parameters: [] View formatted query View runnable query Explain query SELECT d0_.id AS id_0, d0_.inv_user_reference AS inv_user_reference_1, d0_.inv_delay AS inv_delay_2, d0_.inv_is_monitored AS inv_is_monitored_3, d0_.inv_accepted_at AS inv_accepted_at_4, d0_.inv_predicted_delivered_at AS inv_predicted_delivered_at_5, d0_.inv_net_ref AS inv_net_ref_6, d0_.inv_has_priority AS inv_has_priority_7, d0_.inv_priority_deadline AS inv_priority_deadline_8, d0_.inv_accepted_at AS inv_accepted_at_9, d0_.etat AS etat_10, d1_.prest_grp_label AS prest_grp_label_11, d1_.prest_grp_form_type AS prest_grp_form_type_12, d2_.user_first_name AS user_first_name_13, d2_.user_last_name AS user_last_name_14, d3_.phys_sub_last_name AS phys_sub_last_name_15, d3_.phys_sub_first_name AS phys_sub_first_name_16, d4_.order_ordered_at AS order_ordered_at_17, d5_.id AS id_18, d5_.est_validated_at AS est_validated_at_19, d6_.prop_sub_visited_at AS prop_sub_visited_at_20, d7_.id AS id_21, d8_.id AS id_22 FROM dyna_investigation d0_ INNER JOIN dyna_physical_subject d3_ ON d0_.req_physical_subject_id = d3_.id INNER JOIN dyna_prest_grp d1_ ON d0_.req_prest_grp_id = d1_.id INNER JOIN dyna_import d9_ ON d0_.import_id = d9_.id LEFT JOIN dyna_estimation d5_ ON d0_.estimation_id = d5_.id INNER JOIN dyna_order d4_ ON d9_.order_id = d4_.id INNER JOIN dyna_user d2_ ON d4_.user_id = d2_.id INNER JOIN dyna_department d10_ ON d2_.department_id = d10_.id INNER JOIN dyna_branch d11_ ON d10_.branch_id = d11_.id INNER JOIN dyna_corporation d12_ ON d11_.corporation_id = d12_.id LEFT JOIN dyna_property_subject d6_ ON d0_.id = d6_.propSubReqInvestigation LEFT JOIN dyna_attachment d7_ ON d0_.id = d7_.att_investigation_id AND ( d7_.att_file_name LIKE '%lettre_de_mission%' ) LEFT JOIN dyna_attachment d8_ ON d0_.id = d8_.att_investigation_id AND (d8_.att_file_name LIKE '%devis%') WHERE d4_.order_ordered_at IS NOT NULL AND ( d0_.inv_is_cancelled IS NULL OR d0_.inv_is_cancelled = 0 ) AND d0_.inv_delivered_at IS NULL AND ( ( d0_.inv_is_waiting IS NULL OR d0_.inv_is_waiting = 0 ) ) AND d5_.est_validated_at IS NULL AND d2_.id = 132 ORDER BY d0_.id DESC SELECT d0_.id AS id_0, d0_.inv_user_reference AS inv_user_reference_1, d0_.inv_delay AS inv_delay_2, d0_.inv_is_monitored AS inv_is_monitored_3, d0_.inv_accepted_at AS inv_accepted_at_4, d0_.inv_predicted_delivered_at AS inv_predicted_delivered_at_5, d0_.inv_net_ref AS inv_net_ref_6, d0_.inv_has_priority AS inv_has_priority_7, d0_.inv_priority_deadline AS inv_priority_deadline_8, d0_.inv_accepted_at AS inv_accepted_at_9, d0_.etat AS etat_10, d1_.prest_grp_label AS prest_grp_label_11, d1_.prest_grp_form_type AS prest_grp_form_type_12, d2_.user_first_name AS user_first_name_13, d2_.user_last_name AS user_last_name_14, d3_.phys_sub_last_name AS phys_sub_last_name_15, d3_.phys_sub_first_name AS phys_sub_first_name_16, d4_.order_ordered_at AS order_ordered_at_17, d5_.id AS id_18, d5_.est_validated_at AS est_validated_at_19, d6_.prop_sub_visited_at AS prop_sub_visited_at_20, d7_.id AS id_21, d8_.id AS id_22 FROM dyna_investigation d0_ INNER JOIN dyna_physical_subject d3_ ON d0_.req_physical_subject_id = d3_.id INNER JOIN dyna_prest_grp d1_ ON d0_.req_prest_grp_id = d1_.id INNER JOIN dyna_import d9_ ON d0_.import_id = d9_.id LEFT JOIN dyna_estimation d5_ ON d0_.estimation_id = d5_.id INNER JOIN dyna_order d4_ ON d9_.order_id = d4_.id INNER JOIN dyna_user d2_ ON d4_.user_id = d2_.id INNER JOIN dyna_department d10_ ON d2_.department_id = d10_.id INNER JOIN dyna_branch d11_ ON d10_.branch_id = d11_.id INNER JOIN dyna_corporation d12_ ON d11_.corporation_id = d12_.id LEFT JOIN dyna_property_subject d6_ ON d0_.id = d6_.propSubReqInvestigation LEFT JOIN dyna_attachment d7_ ON d0_.id = d7_.att_investigation_id AND (d7_.att_file_name LIKE '%lettre_de_mission%') LEFT JOIN dyna_attachment d8_ ON d0_.id = d8_.att_investigation_id AND (d8_.att_file_name LIKE '%devis%') WHERE d4_.order_ordered_at IS NOT NULL AND (d0_.inv_is_cancelled IS NULL OR d0_.inv_is_cancelled = 0) AND d0_.inv_delivered_at IS NULL AND ((d0_.inv_is_waiting IS NULL OR d0_.inv_is_waiting = 0)) AND d5_.est_validated_at IS NULL AND d2_.id = 132 ORDER BY d0_.id DESC;
1.00 ms (5.73%)	1	SELECT d0_.id AS id_0, d0_.inv_user_reference AS inv_user_reference_1, d0_.inv_delay AS inv_delay_2, d0_.inv_is_monitored AS inv_is_monitored_3, d0_.inv_accepted_at AS inv_accepted_at_4, d0_.inv_predicted_delivered_at AS inv_predicted_delivered_at_5, d0_.inv_net_ref AS inv_net_ref_6, d0_.inv_has_priority AS inv_has_priority_7, d0_.inv_priority_deadline AS inv_priority_deadline_8, d0_.inv_accepted_at AS inv_accepted_at_9, d0_.etat AS etat_10, d1_.prest_grp_label AS prest_grp_label_11, d1_.prest_grp_form_type AS prest_grp_form_type_12, d2_.user_first_name AS user_first_name_13, d2_.user_last_name AS user_last_name_14, d3_.order_ordered_at AS order_ordered_at_15, d4_.id AS id_16, d4_.est_validated_at AS est_validated_at_17, d0_.inv_zone_defined AS inv_zone_defined_18, d0_.inv_spf_code AS inv_spf_code_19, d5_.prop_sub_visited_at AS prop_sub_visited_at_20, d6_.id AS id_21, d7_.id AS id_22 FROM dyna_investigation d0_ INNER JOIN dyna_prest_grp d1_ ON d0_.req_prest_grp_id = d1_.id INNER JOIN dyna_record d8_ ON d0_.record_id = d8_.id LEFT JOIN dyna_estimation d4_ ON d0_.estimation_id = d4_.id INNER JOIN dyna_order d3_ ON d8_.order_id = d3_.id INNER JOIN dyna_user d2_ ON d3_.user_id = d2_.id INNER JOIN dyna_department d9_ ON d2_.department_id = d9_.id INNER JOIN dyna_branch d10_ ON d9_.branch_id = d10_.id INNER JOIN dyna_corporation d11_ ON d10_.corporation_id = d11_.id LEFT JOIN dyna_property_subject d5_ ON d0_.id = d5_.propSubReqInvestigation LEFT JOIN dyna_attachment d6_ ON d0_.id = d6_.att_investigation_id AND (d6_.att_file_name LIKE '%lettre_de_mission%') LEFT JOIN dyna_attachment d7_ ON d0_.id = d7_.att_investigation_id AND (d7_.att_file_name LIKE '%devis%') WHERE d3_.order_ordered_at IS NOT NULL AND (d0_.inv_is_cancelled IS NULL OR d0_.inv_is_cancelled = 0) AND d0_.inv_delivered_at IS NULL AND d0_.inv_zone_defined IS NOT NULL AND ((d0_.inv_is_waiting IS NULL OR d0_.inv_is_waiting = 0)) AND d2_.id = 132 AND d2_.id = 132 ORDER BY d0_.id DESC Parameters: [] View formatted query View runnable query Explain query SELECT d0_.id AS id_0, d0_.inv_user_reference AS inv_user_reference_1, d0_.inv_delay AS inv_delay_2, d0_.inv_is_monitored AS inv_is_monitored_3, d0_.inv_accepted_at AS inv_accepted_at_4, d0_.inv_predicted_delivered_at AS inv_predicted_delivered_at_5, d0_.inv_net_ref AS inv_net_ref_6, d0_.inv_has_priority AS inv_has_priority_7, d0_.inv_priority_deadline AS inv_priority_deadline_8, d0_.inv_accepted_at AS inv_accepted_at_9, d0_.etat AS etat_10, d1_.prest_grp_label AS prest_grp_label_11, d1_.prest_grp_form_type AS prest_grp_form_type_12, d2_.user_first_name AS user_first_name_13, d2_.user_last_name AS user_last_name_14, d3_.order_ordered_at AS order_ordered_at_15, d4_.id AS id_16, d4_.est_validated_at AS est_validated_at_17, d0_.inv_zone_defined AS inv_zone_defined_18, d0_.inv_spf_code AS inv_spf_code_19, d5_.prop_sub_visited_at AS prop_sub_visited_at_20, d6_.id AS id_21, d7_.id AS id_22 FROM dyna_investigation d0_ INNER JOIN dyna_prest_grp d1_ ON d0_.req_prest_grp_id = d1_.id INNER JOIN dyna_record d8_ ON d0_.record_id = d8_.id LEFT JOIN dyna_estimation d4_ ON d0_.estimation_id = d4_.id INNER JOIN dyna_order d3_ ON d8_.order_id = d3_.id INNER JOIN dyna_user d2_ ON d3_.user_id = d2_.id INNER JOIN dyna_department d9_ ON d2_.department_id = d9_.id INNER JOIN dyna_branch d10_ ON d9_.branch_id = d10_.id INNER JOIN dyna_corporation d11_ ON d10_.corporation_id = d11_.id LEFT JOIN dyna_property_subject d5_ ON d0_.id = d5_.propSubReqInvestigation LEFT JOIN dyna_attachment d6_ ON d0_.id = d6_.att_investigation_id AND ( d6_.att_file_name LIKE '%lettre_de_mission%' ) LEFT JOIN dyna_attachment d7_ ON d0_.id = d7_.att_investigation_id AND (d7_.att_file_name LIKE '%devis%') WHERE d3_.order_ordered_at IS NOT NULL AND ( d0_.inv_is_cancelled IS NULL OR d0_.inv_is_cancelled = 0 ) AND d0_.inv_delivered_at IS NULL AND d0_.inv_zone_defined IS NOT NULL AND ( ( d0_.inv_is_waiting IS NULL OR d0_.inv_is_waiting = 0 ) ) AND d2_.id = 132 AND d2_.id = 132 ORDER BY d0_.id DESC SELECT d0_.id AS id_0, d0_.inv_user_reference AS inv_user_reference_1, d0_.inv_delay AS inv_delay_2, d0_.inv_is_monitored AS inv_is_monitored_3, d0_.inv_accepted_at AS inv_accepted_at_4, d0_.inv_predicted_delivered_at AS inv_predicted_delivered_at_5, d0_.inv_net_ref AS inv_net_ref_6, d0_.inv_has_priority AS inv_has_priority_7, d0_.inv_priority_deadline AS inv_priority_deadline_8, d0_.inv_accepted_at AS inv_accepted_at_9, d0_.etat AS etat_10, d1_.prest_grp_label AS prest_grp_label_11, d1_.prest_grp_form_type AS prest_grp_form_type_12, d2_.user_first_name AS user_first_name_13, d2_.user_last_name AS user_last_name_14, d3_.order_ordered_at AS order_ordered_at_15, d4_.id AS id_16, d4_.est_validated_at AS est_validated_at_17, d0_.inv_zone_defined AS inv_zone_defined_18, d0_.inv_spf_code AS inv_spf_code_19, d5_.prop_sub_visited_at AS prop_sub_visited_at_20, d6_.id AS id_21, d7_.id AS id_22 FROM dyna_investigation d0_ INNER JOIN dyna_prest_grp d1_ ON d0_.req_prest_grp_id = d1_.id INNER JOIN dyna_record d8_ ON d0_.record_id = d8_.id LEFT JOIN dyna_estimation d4_ ON d0_.estimation_id = d4_.id INNER JOIN dyna_order d3_ ON d8_.order_id = d3_.id INNER JOIN dyna_user d2_ ON d3_.user_id = d2_.id INNER JOIN dyna_department d9_ ON d2_.department_id = d9_.id INNER JOIN dyna_branch d10_ ON d9_.branch_id = d10_.id INNER JOIN dyna_corporation d11_ ON d10_.corporation_id = d11_.id LEFT JOIN dyna_property_subject d5_ ON d0_.id = d5_.propSubReqInvestigation LEFT JOIN dyna_attachment d6_ ON d0_.id = d6_.att_investigation_id AND (d6_.att_file_name LIKE '%lettre_de_mission%') LEFT JOIN dyna_attachment d7_ ON d0_.id = d7_.att_investigation_id AND (d7_.att_file_name LIKE '%devis%') WHERE d3_.order_ordered_at IS NOT NULL AND (d0_.inv_is_cancelled IS NULL OR d0_.inv_is_cancelled = 0) AND d0_.inv_delivered_at IS NULL AND d0_.inv_zone_defined IS NOT NULL AND ((d0_.inv_is_waiting IS NULL OR d0_.inv_is_waiting = 0)) AND d2_.id = 132 AND d2_.id = 132 ORDER BY d0_.id DESC;
0.94 ms (5.41%)	1	SELECT d0_.id AS id_0, d0_.inv_user_reference AS inv_user_reference_1, d0_.inv_delay AS inv_delay_2, d0_.inv_is_monitored AS inv_is_monitored_3, d0_.inv_accepted_at AS inv_accepted_at_4, d0_.inv_predicted_delivered_at AS inv_predicted_delivered_at_5, d0_.inv_net_ref AS inv_net_ref_6, d0_.inv_has_priority AS inv_has_priority_7, d0_.inv_priority_deadline AS inv_priority_deadline_8, d0_.inv_accepted_at AS inv_accepted_at_9, d0_.etat AS etat_10, d1_.prest_grp_label AS prest_grp_label_11, d1_.prest_grp_form_type AS prest_grp_form_type_12, d2_.user_first_name AS user_first_name_13, d2_.user_last_name AS user_last_name_14, d3_.order_ordered_at AS order_ordered_at_15, d4_.id AS id_16, d4_.est_validated_at AS est_validated_at_17, d0_.inv_zone_defined AS inv_zone_defined_18, d0_.inv_spf_code AS inv_spf_code_19, d5_.prop_sub_visited_at AS prop_sub_visited_at_20, d6_.id AS id_21, d7_.id AS id_22 FROM dyna_investigation d0_ INNER JOIN dyna_prest_grp d1_ ON d0_.req_prest_grp_id = d1_.id INNER JOIN dyna_record d8_ ON d0_.record_id = d8_.id LEFT JOIN dyna_estimation d4_ ON d0_.estimation_id = d4_.id INNER JOIN dyna_order d3_ ON d8_.order_id = d3_.id INNER JOIN dyna_user d2_ ON d3_.user_id = d2_.id INNER JOIN dyna_department d9_ ON d2_.department_id = d9_.id INNER JOIN dyna_branch d10_ ON d9_.branch_id = d10_.id INNER JOIN dyna_corporation d11_ ON d10_.corporation_id = d11_.id LEFT JOIN dyna_property_subject d5_ ON d0_.id = d5_.propSubReqInvestigation LEFT JOIN dyna_attachment d6_ ON d0_.id = d6_.att_investigation_id AND (d6_.att_file_name LIKE '%lettre_de_mission%') LEFT JOIN dyna_attachment d7_ ON d0_.id = d7_.att_investigation_id AND (d7_.att_file_name LIKE '%devis%') WHERE d3_.order_ordered_at IS NOT NULL AND (d0_.inv_is_cancelled IS NULL OR d0_.inv_is_cancelled = 0) AND d0_.inv_delivered_at IS NULL AND d0_.inv_zone_defined IS NOT NULL AND ((d0_.inv_is_waiting IS NULL OR d0_.inv_is_waiting = 0)) AND d2_.id = 132 AND d4_.est_validated_at IS NULL AND d2_.id = 132 ORDER BY d0_.id DESC Parameters: [] View formatted query View runnable query Explain query SELECT d0_.id AS id_0, d0_.inv_user_reference AS inv_user_reference_1, d0_.inv_delay AS inv_delay_2, d0_.inv_is_monitored AS inv_is_monitored_3, d0_.inv_accepted_at AS inv_accepted_at_4, d0_.inv_predicted_delivered_at AS inv_predicted_delivered_at_5, d0_.inv_net_ref AS inv_net_ref_6, d0_.inv_has_priority AS inv_has_priority_7, d0_.inv_priority_deadline AS inv_priority_deadline_8, d0_.inv_accepted_at AS inv_accepted_at_9, d0_.etat AS etat_10, d1_.prest_grp_label AS prest_grp_label_11, d1_.prest_grp_form_type AS prest_grp_form_type_12, d2_.user_first_name AS user_first_name_13, d2_.user_last_name AS user_last_name_14, d3_.order_ordered_at AS order_ordered_at_15, d4_.id AS id_16, d4_.est_validated_at AS est_validated_at_17, d0_.inv_zone_defined AS inv_zone_defined_18, d0_.inv_spf_code AS inv_spf_code_19, d5_.prop_sub_visited_at AS prop_sub_visited_at_20, d6_.id AS id_21, d7_.id AS id_22 FROM dyna_investigation d0_ INNER JOIN dyna_prest_grp d1_ ON d0_.req_prest_grp_id = d1_.id INNER JOIN dyna_record d8_ ON d0_.record_id = d8_.id LEFT JOIN dyna_estimation d4_ ON d0_.estimation_id = d4_.id INNER JOIN dyna_order d3_ ON d8_.order_id = d3_.id INNER JOIN dyna_user d2_ ON d3_.user_id = d2_.id INNER JOIN dyna_department d9_ ON d2_.department_id = d9_.id INNER JOIN dyna_branch d10_ ON d9_.branch_id = d10_.id INNER JOIN dyna_corporation d11_ ON d10_.corporation_id = d11_.id LEFT JOIN dyna_property_subject d5_ ON d0_.id = d5_.propSubReqInvestigation LEFT JOIN dyna_attachment d6_ ON d0_.id = d6_.att_investigation_id AND ( d6_.att_file_name LIKE '%lettre_de_mission%' ) LEFT JOIN dyna_attachment d7_ ON d0_.id = d7_.att_investigation_id AND (d7_.att_file_name LIKE '%devis%') WHERE d3_.order_ordered_at IS NOT NULL AND ( d0_.inv_is_cancelled IS NULL OR d0_.inv_is_cancelled = 0 ) AND d0_.inv_delivered_at IS NULL AND d0_.inv_zone_defined IS NOT NULL AND ( ( d0_.inv_is_waiting IS NULL OR d0_.inv_is_waiting = 0 ) ) AND d2_.id = 132 AND d4_.est_validated_at IS NULL AND d2_.id = 132 ORDER BY d0_.id DESC SELECT d0_.id AS id_0, d0_.inv_user_reference AS inv_user_reference_1, d0_.inv_delay AS inv_delay_2, d0_.inv_is_monitored AS inv_is_monitored_3, d0_.inv_accepted_at AS inv_accepted_at_4, d0_.inv_predicted_delivered_at AS inv_predicted_delivered_at_5, d0_.inv_net_ref AS inv_net_ref_6, d0_.inv_has_priority AS inv_has_priority_7, d0_.inv_priority_deadline AS inv_priority_deadline_8, d0_.inv_accepted_at AS inv_accepted_at_9, d0_.etat AS etat_10, d1_.prest_grp_label AS prest_grp_label_11, d1_.prest_grp_form_type AS prest_grp_form_type_12, d2_.user_first_name AS user_first_name_13, d2_.user_last_name AS user_last_name_14, d3_.order_ordered_at AS order_ordered_at_15, d4_.id AS id_16, d4_.est_validated_at AS est_validated_at_17, d0_.inv_zone_defined AS inv_zone_defined_18, d0_.inv_spf_code AS inv_spf_code_19, d5_.prop_sub_visited_at AS prop_sub_visited_at_20, d6_.id AS id_21, d7_.id AS id_22 FROM dyna_investigation d0_ INNER JOIN dyna_prest_grp d1_ ON d0_.req_prest_grp_id = d1_.id INNER JOIN dyna_record d8_ ON d0_.record_id = d8_.id LEFT JOIN dyna_estimation d4_ ON d0_.estimation_id = d4_.id INNER JOIN dyna_order d3_ ON d8_.order_id = d3_.id INNER JOIN dyna_user d2_ ON d3_.user_id = d2_.id INNER JOIN dyna_department d9_ ON d2_.department_id = d9_.id INNER JOIN dyna_branch d10_ ON d9_.branch_id = d10_.id INNER JOIN dyna_corporation d11_ ON d10_.corporation_id = d11_.id LEFT JOIN dyna_property_subject d5_ ON d0_.id = d5_.propSubReqInvestigation LEFT JOIN dyna_attachment d6_ ON d0_.id = d6_.att_investigation_id AND (d6_.att_file_name LIKE '%lettre_de_mission%') LEFT JOIN dyna_attachment d7_ ON d0_.id = d7_.att_investigation_id AND (d7_.att_file_name LIKE '%devis%') WHERE d3_.order_ordered_at IS NOT NULL AND (d0_.inv_is_cancelled IS NULL OR d0_.inv_is_cancelled = 0) AND d0_.inv_delivered_at IS NULL AND d0_.inv_zone_defined IS NOT NULL AND ((d0_.inv_is_waiting IS NULL OR d0_.inv_is_waiting = 0)) AND d2_.id = 132 AND d4_.est_validated_at IS NULL AND d2_.id = 132 ORDER BY d0_.id DESC;
0.79 ms (4.55%)	1	SELECT t0.id AS id_1, t0.username AS username_2, t0.user_password AS user_password_3, t0.user_civility AS user_civility_4, t0.user_last_name AS user_last_name_5, t0.user_first_name AS user_first_name_6, t0.user_email_address AS user_email_address_7, t0.user_phone_number AS user_phone_number_8, t0.user_fax_number AS user_fax_number_9, t0.user_title AS user_title_10, t0.user_is_active AS user_is_active_11, t0.user_comment AS user_comment_12, t0.user_created_at AS user_created_at_13, t0.user_deactivated_at AS user_deactivated_at_14, t0.user_reactivated_at AS user_reactivated_at_15, t0.user_gems_interlocutor AS user_gems_interlocutor_16, t0.user_has_accepted_terms AS user_has_accepted_terms_17, t0.user_role AS user_role_18, t0.user_last_update_from_gems AS user_last_update_from_gems_19, t0.user_last_connected_at AS user_last_connected_at_20, t0.user_tour_to_not_show AS user_tour_to_not_show_21, t0.user_type AS user_type_22, t0.user_address1 AS user_address1_23, t0.user_address2 AS user_address2_24, t0.user_address3 AS user_address3_25, t0.user_postal_code AS user_postal_code_26, t0.user_city AS user_city_27, t0.user_cedex AS user_cedex_28, t0.user_country AS user_country_29, t0.user_phone_number2 AS user_phone_number2_30, t0.user_email_address2 AS user_email_address2_31, t0.is_archived AS is_archived_32, t0.has_tdet_access AS has_tdet_access_33, t0.has_ooftop_access AS has_ooftop_access_34, t0.ooftop_token AS ooftop_token_35, t0.ooftop_token_valid_until AS ooftop_token_valid_until_36, t0.has_db_auth AS has_db_auth_37, t0.google_authenticator_secret AS google_authenticator_secret_38, t0.token AS token_39, t0.jazmin_id AS jazmin_id_40, t0.avatar_id AS avatar_id_41, t0.department_id AS department_id_42, t0.persona_id AS persona_id_43 FROM dyna_user t0 WHERE t0.id = ? Parameters: [`132`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.username AS username_2, t0.user_password AS user_password_3, t0.user_civility AS user_civility_4, t0.user_last_name AS user_last_name_5, t0.user_first_name AS user_first_name_6, t0.user_email_address AS user_email_address_7, t0.user_phone_number AS user_phone_number_8, t0.user_fax_number AS user_fax_number_9, t0.user_title AS user_title_10, t0.user_is_active AS user_is_active_11, t0.user_comment AS user_comment_12, t0.user_created_at AS user_created_at_13, t0.user_deactivated_at AS user_deactivated_at_14, t0.user_reactivated_at AS user_reactivated_at_15, t0.user_gems_interlocutor AS user_gems_interlocutor_16, t0.user_has_accepted_terms AS user_has_accepted_terms_17, t0.user_role AS user_role_18, t0.user_last_update_from_gems AS user_last_update_from_gems_19, t0.user_last_connected_at AS user_last_connected_at_20, t0.user_tour_to_not_show AS user_tour_to_not_show_21, t0.user_type AS user_type_22, t0.user_address1 AS user_address1_23, t0.user_address2 AS user_address2_24, t0.user_address3 AS user_address3_25, t0.user_postal_code AS user_postal_code_26, t0.user_city AS user_city_27, t0.user_cedex AS user_cedex_28, t0.user_country AS user_country_29, t0.user_phone_number2 AS user_phone_number2_30, t0.user_email_address2 AS user_email_address2_31, t0.is_archived AS is_archived_32, t0.has_tdet_access AS has_tdet_access_33, t0.has_ooftop_access AS has_ooftop_access_34, t0.ooftop_token AS ooftop_token_35, t0.ooftop_token_valid_until AS ooftop_token_valid_until_36, t0.has_db_auth AS has_db_auth_37, t0.google_authenticator_secret AS google_authenticator_secret_38, t0.token AS token_39, t0.jazmin_id AS jazmin_id_40, t0.avatar_id AS avatar_id_41, t0.department_id AS department_id_42, t0.persona_id AS persona_id_43 FROM dyna_user t0 WHERE t0.id = ? SELECT t0.id AS id_1, t0.username AS username_2, t0.user_password AS user_password_3, t0.user_civility AS user_civility_4, t0.user_last_name AS user_last_name_5, t0.user_first_name AS user_first_name_6, t0.user_email_address AS user_email_address_7, t0.user_phone_number AS user_phone_number_8, t0.user_fax_number AS user_fax_number_9, t0.user_title AS user_title_10, t0.user_is_active AS user_is_active_11, t0.user_comment AS user_comment_12, t0.user_created_at AS user_created_at_13, t0.user_deactivated_at AS user_deactivated_at_14, t0.user_reactivated_at AS user_reactivated_at_15, t0.user_gems_interlocutor AS user_gems_interlocutor_16, t0.user_has_accepted_terms AS user_has_accepted_terms_17, t0.user_role AS user_role_18, t0.user_last_update_from_gems AS user_last_update_from_gems_19, t0.user_last_connected_at AS user_last_connected_at_20, t0.user_tour_to_not_show AS user_tour_to_not_show_21, t0.user_type AS user_type_22, t0.user_address1 AS user_address1_23, t0.user_address2 AS user_address2_24, t0.user_address3 AS user_address3_25, t0.user_postal_code AS user_postal_code_26, t0.user_city AS user_city_27, t0.user_cedex AS user_cedex_28, t0.user_country AS user_country_29, t0.user_phone_number2 AS user_phone_number2_30, t0.user_email_address2 AS user_email_address2_31, t0.is_archived AS is_archived_32, t0.has_tdet_access AS has_tdet_access_33, t0.has_ooftop_access AS has_ooftop_access_34, t0.ooftop_token AS ooftop_token_35, t0.ooftop_token_valid_until AS ooftop_token_valid_until_36, t0.has_db_auth AS has_db_auth_37, t0.google_authenticator_secret AS google_authenticator_secret_38, t0.token AS token_39, t0.jazmin_id AS jazmin_id_40, t0.avatar_id AS avatar_id_41, t0.department_id AS department_id_42, t0.persona_id AS persona_id_43 FROM dyna_user t0 WHERE t0.id = 132;
0.62 ms (3.55%)	1	SELECT d0_.id AS id_0 FROM dyna_investigation d0_ INNER JOIN dyna_record d1_ ON d0_.record_id = d1_.id INNER JOIN dyna_order d2_ ON d1_.order_id = d2_.id INNER JOIN dyna_user d3_ ON d2_.user_id = d3_.id LEFT JOIN dyna_report d4_ ON d0_.report_id = d4_.id INNER JOIN dyna_department d5_ ON d3_.department_id = d5_.id INNER JOIN dyna_branch d6_ ON d5_.branch_id = d6_.id INNER JOIN dyna_corporation d7_ ON d6_.corporation_id = d7_.id WHERE d0_.inv_delivered_at IS NOT NULL AND (d0_.inv_is_cancelled IS NULL OR d0_.inv_is_cancelled = 0) AND d4_.report_downloaded_at IS NULL AND d4_.report_is_available = 1 AND d4_.report_has_been_downloaded <> 1 AND d3_.id = 132 Parameters: [] View formatted query View runnable query Explain query SELECT d0_.id AS id_0 FROM dyna_investigation d0_ INNER JOIN dyna_record d1_ ON d0_.record_id = d1_.id INNER JOIN dyna_order d2_ ON d1_.order_id = d2_.id INNER JOIN dyna_user d3_ ON d2_.user_id = d3_.id LEFT JOIN dyna_report d4_ ON d0_.report_id = d4_.id INNER JOIN dyna_department d5_ ON d3_.department_id = d5_.id INNER JOIN dyna_branch d6_ ON d5_.branch_id = d6_.id INNER JOIN dyna_corporation d7_ ON d6_.corporation_id = d7_.id WHERE d0_.inv_delivered_at IS NOT NULL AND ( d0_.inv_is_cancelled IS NULL OR d0_.inv_is_cancelled = 0 ) AND d4_.report_downloaded_at IS NULL AND d4_.report_is_available = 1 AND d4_.report_has_been_downloaded <> 1 AND d3_.id = 132 SELECT d0_.id AS id_0 FROM dyna_investigation d0_ INNER JOIN dyna_record d1_ ON d0_.record_id = d1_.id INNER JOIN dyna_order d2_ ON d1_.order_id = d2_.id INNER JOIN dyna_user d3_ ON d2_.user_id = d3_.id LEFT JOIN dyna_report d4_ ON d0_.report_id = d4_.id INNER JOIN dyna_department d5_ ON d3_.department_id = d5_.id INNER JOIN dyna_branch d6_ ON d5_.branch_id = d6_.id INNER JOIN dyna_corporation d7_ ON d6_.corporation_id = d7_.id WHERE d0_.inv_delivered_at IS NOT NULL AND (d0_.inv_is_cancelled IS NULL OR d0_.inv_is_cancelled = 0) AND d4_.report_downloaded_at IS NULL AND d4_.report_is_available = 1 AND d4_.report_has_been_downloaded <> 1 AND d3_.id = 132;
0.60 ms (3.45%)	1	SELECT d0_.id AS id_0 FROM dyna_investigation d0_ INNER JOIN dyna_import d1_ ON d0_.import_id = d1_.id INNER JOIN dyna_order d2_ ON d1_.order_id = d2_.id INNER JOIN dyna_user d3_ ON d2_.user_id = d3_.id LEFT JOIN dyna_report d4_ ON d0_.report_id = d4_.id INNER JOIN dyna_department d5_ ON d3_.department_id = d5_.id INNER JOIN dyna_branch d6_ ON d5_.branch_id = d6_.id INNER JOIN dyna_corporation d7_ ON d6_.corporation_id = d7_.id WHERE d0_.inv_delivered_at IS NOT NULL AND (d0_.inv_is_cancelled IS NULL OR d0_.inv_is_cancelled = 0) AND d4_.report_downloaded_at IS NULL AND d4_.report_is_available = 1 AND d4_.report_has_been_downloaded <> 1 AND d3_.id = 132 Parameters: [] View formatted query View runnable query Explain query SELECT d0_.id AS id_0 FROM dyna_investigation d0_ INNER JOIN dyna_import d1_ ON d0_.import_id = d1_.id INNER JOIN dyna_order d2_ ON d1_.order_id = d2_.id INNER JOIN dyna_user d3_ ON d2_.user_id = d3_.id LEFT JOIN dyna_report d4_ ON d0_.report_id = d4_.id INNER JOIN dyna_department d5_ ON d3_.department_id = d5_.id INNER JOIN dyna_branch d6_ ON d5_.branch_id = d6_.id INNER JOIN dyna_corporation d7_ ON d6_.corporation_id = d7_.id WHERE d0_.inv_delivered_at IS NOT NULL AND ( d0_.inv_is_cancelled IS NULL OR d0_.inv_is_cancelled = 0 ) AND d4_.report_downloaded_at IS NULL AND d4_.report_is_available = 1 AND d4_.report_has_been_downloaded <> 1 AND d3_.id = 132 SELECT d0_.id AS id_0 FROM dyna_investigation d0_ INNER JOIN dyna_import d1_ ON d0_.import_id = d1_.id INNER JOIN dyna_order d2_ ON d1_.order_id = d2_.id INNER JOIN dyna_user d3_ ON d2_.user_id = d3_.id LEFT JOIN dyna_report d4_ ON d0_.report_id = d4_.id INNER JOIN dyna_department d5_ ON d3_.department_id = d5_.id INNER JOIN dyna_branch d6_ ON d5_.branch_id = d6_.id INNER JOIN dyna_corporation d7_ ON d6_.corporation_id = d7_.id WHERE d0_.inv_delivered_at IS NOT NULL AND (d0_.inv_is_cancelled IS NULL OR d0_.inv_is_cancelled = 0) AND d4_.report_downloaded_at IS NULL AND d4_.report_is_available = 1 AND d4_.report_has_been_downloaded <> 1 AND d3_.id = 132;
0.54 ms (3.09%)	1	SELECT t0.id AS id_1, t0.pers_name AS pers_name_2, t0.pers_is_default AS pers_is_default_3, t0.pers_catalog AS pers_catalog_4, t0.pers_user_manual AS pers_user_manual_5, t0.pers_report_example_file1 AS pers_report_example_file1_6, t0.pers_report_example_name1 AS pers_report_example_name1_7, t0.pers_report_example_file2 AS pers_report_example_file2_8, t0.pers_report_example_name2 AS pers_report_example_name2_9, t0.pers_report_example_file3 AS pers_report_example_file3_10, t0.pers_report_example_name3 AS pers_report_example_name3_11, t0.prest_forward_codes AS prest_forward_codes_12, t0.pers_user_advanced_manual AS pers_user_advanced_manual_13, t0.tour_id AS tour_id_14, t0.prest_menu_id AS prest_menu_id_15 FROM dyna_persona t0 WHERE t0.id = ? Parameters: [`7`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.pers_name AS pers_name_2, t0.pers_is_default AS pers_is_default_3, t0.pers_catalog AS pers_catalog_4, t0.pers_user_manual AS pers_user_manual_5, t0.pers_report_example_file1 AS pers_report_example_file1_6, t0.pers_report_example_name1 AS pers_report_example_name1_7, t0.pers_report_example_file2 AS pers_report_example_file2_8, t0.pers_report_example_name2 AS pers_report_example_name2_9, t0.pers_report_example_file3 AS pers_report_example_file3_10, t0.pers_report_example_name3 AS pers_report_example_name3_11, t0.prest_forward_codes AS prest_forward_codes_12, t0.pers_user_advanced_manual AS pers_user_advanced_manual_13, t0.tour_id AS tour_id_14, t0.prest_menu_id AS prest_menu_id_15 FROM dyna_persona t0 WHERE t0.id = ? SELECT t0.id AS id_1, t0.pers_name AS pers_name_2, t0.pers_is_default AS pers_is_default_3, t0.pers_catalog AS pers_catalog_4, t0.pers_user_manual AS pers_user_manual_5, t0.pers_report_example_file1 AS pers_report_example_file1_6, t0.pers_report_example_name1 AS pers_report_example_name1_7, t0.pers_report_example_file2 AS pers_report_example_file2_8, t0.pers_report_example_name2 AS pers_report_example_name2_9, t0.pers_report_example_file3 AS pers_report_example_file3_10, t0.pers_report_example_name3 AS pers_report_example_name3_11, t0.prest_forward_codes AS prest_forward_codes_12, t0.pers_user_advanced_manual AS pers_user_advanced_manual_13, t0.tour_id AS tour_id_14, t0.prest_menu_id AS prest_menu_id_15 FROM dyna_persona t0 WHERE t0.id = 7;
0.39 ms (2.25%)	1	SELECT t0.id AS id_1, t0.feat_name AS feat_name_2, t0.feat_description AS feat_description_3, t0.feat_code AS feat_code_4 FROM dyna_feature t0 INNER JOIN dyna_features_personas ON t0.id = dyna_features_personas.feature_id WHERE dyna_features_personas.persona_id = ? Parameters: [`7`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.feat_name AS feat_name_2, t0.feat_description AS feat_description_3, t0.feat_code AS feat_code_4 FROM dyna_feature t0 INNER JOIN dyna_features_personas ON t0.id = dyna_features_personas.feature_id WHERE dyna_features_personas.persona_id = ? SELECT t0.id AS id_1, t0.feat_name AS feat_name_2, t0.feat_description AS feat_description_3, t0.feat_code AS feat_code_4 FROM dyna_feature t0 INNER JOIN dyna_features_personas ON t0.id = dyna_features_personas.feature_id WHERE dyna_features_personas.persona_id = 7;
0.37 ms (2.13%)	1	SELECT t0.id AS id_1, t0.bran_name AS bran_name_2, t0.bran_gems_mnemonique AS bran_gems_mnemonique_3, t0.bran_is_billable AS bran_is_billable_4, t0.bran_siret_number AS bran_siret_number_5, t0.bran_address1 AS bran_address1_6, t0.bran_address2 AS bran_address2_7, t0.bran_address3 AS bran_address3_8, t0.bran_address4 AS bran_address4_9, t0.bran_postal_code AS bran_postal_code_10, t0.bran_city AS bran_city_11, t0.bran_country AS bran_country_12, t0.bran_phone_number AS bran_phone_number_13, t0.bran_fax_number AS bran_fax_number_14, t0.bran_email_address AS bran_email_address_15, t0.bran_is_active AS bran_is_active_16, t0.bran_is_web_client AS bran_is_web_client_17, t0.bran_db_auth AS bran_db_auth_18, t0.bran_comment AS bran_comment_19, t0.bran_created_at AS bran_created_at_20, t0.bran_deactivated_at AS bran_deactivated_at_21, t0.bran_reactivated_at AS bran_reactivated_at_22, t0.bran_last_update_from_gems AS bran_last_update_from_gems_23, t0.bran_representative AS bran_representative_24, t0.bran_bill_id AS bran_bill_id_25, t0.bran_custom_label AS bran_custom_label_26, t0.bran_phone_number2 AS bran_phone_number2_27, t0.bran_jaz_id AS bran_jaz_id_28, t0.bran_comment_facturation AS bran_comment_facturation_29, t0.corporation_id AS corporation_id_30, t0.parent_branch_id AS parent_branch_id_31, t0.branchorderrefregex_id AS branchorderrefregex_id_32 FROM dyna_branch t0 WHERE t0.id = ? Parameters: [`71`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.bran_name AS bran_name_2, t0.bran_gems_mnemonique AS bran_gems_mnemonique_3, t0.bran_is_billable AS bran_is_billable_4, t0.bran_siret_number AS bran_siret_number_5, t0.bran_address1 AS bran_address1_6, t0.bran_address2 AS bran_address2_7, t0.bran_address3 AS bran_address3_8, t0.bran_address4 AS bran_address4_9, t0.bran_postal_code AS bran_postal_code_10, t0.bran_city AS bran_city_11, t0.bran_country AS bran_country_12, t0.bran_phone_number AS bran_phone_number_13, t0.bran_fax_number AS bran_fax_number_14, t0.bran_email_address AS bran_email_address_15, t0.bran_is_active AS bran_is_active_16, t0.bran_is_web_client AS bran_is_web_client_17, t0.bran_db_auth AS bran_db_auth_18, t0.bran_comment AS bran_comment_19, t0.bran_created_at AS bran_created_at_20, t0.bran_deactivated_at AS bran_deactivated_at_21, t0.bran_reactivated_at AS bran_reactivated_at_22, t0.bran_last_update_from_gems AS bran_last_update_from_gems_23, t0.bran_representative AS bran_representative_24, t0.bran_bill_id AS bran_bill_id_25, t0.bran_custom_label AS bran_custom_label_26, t0.bran_phone_number2 AS bran_phone_number2_27, t0.bran_jaz_id AS bran_jaz_id_28, t0.bran_comment_facturation AS bran_comment_facturation_29, t0.corporation_id AS corporation_id_30, t0.parent_branch_id AS parent_branch_id_31, t0.branchorderrefregex_id AS branchorderrefregex_id_32 FROM dyna_branch t0 WHERE t0.id = ? SELECT t0.id AS id_1, t0.bran_name AS bran_name_2, t0.bran_gems_mnemonique AS bran_gems_mnemonique_3, t0.bran_is_billable AS bran_is_billable_4, t0.bran_siret_number AS bran_siret_number_5, t0.bran_address1 AS bran_address1_6, t0.bran_address2 AS bran_address2_7, t0.bran_address3 AS bran_address3_8, t0.bran_address4 AS bran_address4_9, t0.bran_postal_code AS bran_postal_code_10, t0.bran_city AS bran_city_11, t0.bran_country AS bran_country_12, t0.bran_phone_number AS bran_phone_number_13, t0.bran_fax_number AS bran_fax_number_14, t0.bran_email_address AS bran_email_address_15, t0.bran_is_active AS bran_is_active_16, t0.bran_is_web_client AS bran_is_web_client_17, t0.bran_db_auth AS bran_db_auth_18, t0.bran_comment AS bran_comment_19, t0.bran_created_at AS bran_created_at_20, t0.bran_deactivated_at AS bran_deactivated_at_21, t0.bran_reactivated_at AS bran_reactivated_at_22, t0.bran_last_update_from_gems AS bran_last_update_from_gems_23, t0.bran_representative AS bran_representative_24, t0.bran_bill_id AS bran_bill_id_25, t0.bran_custom_label AS bran_custom_label_26, t0.bran_phone_number2 AS bran_phone_number2_27, t0.bran_jaz_id AS bran_jaz_id_28, t0.bran_comment_facturation AS bran_comment_facturation_29, t0.corporation_id AS corporation_id_30, t0.parent_branch_id AS parent_branch_id_31, t0.branchorderrefregex_id AS branchorderrefregex_id_32 FROM dyna_branch t0 WHERE t0.id = 71;
0.36 ms (2.04%)	1	SELECT d0_.id AS id_0, d0_.is_default AS is_default_1, d0_.created_at AS created_at_2, d0_.updated_at AS updated_at_3, d0_.is_active AS is_active_4, d0_.content AS content_5, d0_.title AS title_6 FROM dyna_cms d0_ INNER JOIN dyna_cms_persona d2_ ON d0_.id = d2_.cms_id INNER JOIN dyna_persona d1_ ON d1_.id = d2_.persona_id WHERE d1_.id = ? AND d0_.is_active = 1 Parameters: [`7`] View formatted query View runnable query Explain query SELECT d0_.id AS id_0, d0_.is_default AS is_default_1, d0_.created_at AS created_at_2, d0_.updated_at AS updated_at_3, d0_.is_active AS is_active_4, d0_.content AS content_5, d0_.title AS title_6 FROM dyna_cms d0_ INNER JOIN dyna_cms_persona d2_ ON d0_.id = d2_.cms_id INNER JOIN dyna_persona d1_ ON d1_.id = d2_.persona_id WHERE d1_.id = ? AND d0_.is_active = 1 SELECT d0_.id AS id_0, d0_.is_default AS is_default_1, d0_.created_at AS created_at_2, d0_.updated_at AS updated_at_3, d0_.is_active AS is_active_4, d0_.content AS content_5, d0_.title AS title_6 FROM dyna_cms d0_ INNER JOIN dyna_cms_persona d2_ ON d0_.id = d2_.cms_id INNER JOIN dyna_persona d1_ ON d1_.id = d2_.persona_id WHERE d1_.id = 7 AND d0_.is_active = 1;
0.34 ms (1.95%)	1	SELECT d0_.id AS id_0, d0_.is_default AS is_default_1, d0_.created_at AS created_at_2, d0_.updated_at AS updated_at_3, d0_.is_active AS is_active_4, d0_.content AS content_5, d0_.title AS title_6 FROM dyna_cms d0_ INNER JOIN dyna_cms_branch d2_ ON d0_.id = d2_.cms_id INNER JOIN dyna_branch d1_ ON d1_.id = d2_.branch_id WHERE d1_.id = ? AND d0_.is_active = 1 Parameters: [`71`] View formatted query View runnable query Explain query SELECT d0_.id AS id_0, d0_.is_default AS is_default_1, d0_.created_at AS created_at_2, d0_.updated_at AS updated_at_3, d0_.is_active AS is_active_4, d0_.content AS content_5, d0_.title AS title_6 FROM dyna_cms d0_ INNER JOIN dyna_cms_branch d2_ ON d0_.id = d2_.cms_id INNER JOIN dyna_branch d1_ ON d1_.id = d2_.branch_id WHERE d1_.id = ? AND d0_.is_active = 1 SELECT d0_.id AS id_0, d0_.is_default AS is_default_1, d0_.created_at AS created_at_2, d0_.updated_at AS updated_at_3, d0_.is_active AS is_active_4, d0_.content AS content_5, d0_.title AS title_6 FROM dyna_cms d0_ INNER JOIN dyna_cms_branch d2_ ON d0_.id = d2_.cms_id INNER JOIN dyna_branch d1_ ON d1_.id = d2_.branch_id WHERE d1_.id = 71 AND d0_.is_active = 1;
0.32 ms (1.83%)	1	SELECT t0.id AS id_1, t0.dep_name AS dep_name_2, t0.dep_is_active AS dep_is_active_3, t0.dep_created_at AS dep_created_at_4, t0.dep_deactivated_at AS dep_deactivated_at_5, t0.dep_reactivated_at AS dep_reactivated_at_6, t0.dep_jaz_id AS dep_jaz_id_7, t0.branch_id AS branch_id_8 FROM dyna_department t0 WHERE t0.id = ? Parameters: [`36`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.dep_name AS dep_name_2, t0.dep_is_active AS dep_is_active_3, t0.dep_created_at AS dep_created_at_4, t0.dep_deactivated_at AS dep_deactivated_at_5, t0.dep_reactivated_at AS dep_reactivated_at_6, t0.dep_jaz_id AS dep_jaz_id_7, t0.branch_id AS branch_id_8 FROM dyna_department t0 WHERE t0.id = ? SELECT t0.id AS id_1, t0.dep_name AS dep_name_2, t0.dep_is_active AS dep_is_active_3, t0.dep_created_at AS dep_created_at_4, t0.dep_deactivated_at AS dep_deactivated_at_5, t0.dep_reactivated_at AS dep_reactivated_at_6, t0.dep_jaz_id AS dep_jaz_id_7, t0.branch_id AS branch_id_8 FROM dyna_department t0 WHERE t0.id = 36;

Database Connections

Name	Service
default	doctrine.dbal.default_connection
jazmin	doctrine.dbal.jazmin_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\Feature	7
App\Entity\User	1
App\Entity\Department	1
App\Entity\Persona	1
App\Entity\Branch	1
App\Entity\Corporation	1
App\Entity\Cms	1
App\Entity\PrestMenu	1

Entities Mapping

Class	Mapping errors
App\Entity\User	No errors.
App\Entity\Avatar	No errors.
App\Entity\Department	No errors.
App\Entity\Persona	No errors.
App\Entity\Order	No errors.
App\Entity\Comment	No errors.
App\Entity\Action	No errors.
App\Entity\Alert	No errors.
App\Entity\TourStep	No errors.
App\Entity\Branch	No errors.
App\Entity\Corporation	No errors.
App\Entity\BranchOrderRefRegex	No errors.
App\Entity\ImportModel	No errors.
App\Entity\PrestGrpBranch	No errors.
App\Entity\CustomField	No errors.
App\Entity\PrestGrp	No errors.
App\Entity\BranchBill	No errors.
App\Entity\Cms	No errors.
App\Entity\Investigation	No errors.
App\Entity\PhysicalSubject	No errors.
App\Entity\Record	No errors.
App\Entity\Estimation	No errors.
App\Entity\PropertySubject	No errors.
App\Entity\Attachment	No errors.
App\Entity\CorporationSubject	No errors.
App\Entity\Import	No errors.
App\Entity\Report	No errors.
App\Entity\Bill	No errors.
App\Entity\Tour	No errors.
App\Entity\PrestMenu	No errors.
App\Entity\Feature	No errors.
App\Entity\PersonaPrestGrp	No errors.

Symfony Profiler

GET https://dev-extranet.dynaslux.lu/

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

default connection

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping