Query Metrics
32
Database Queries
24
Different statements
17.05 ms
Query time
0
Invalid entities
26
Managed entities
Grouped Statements
default connection
| Time▼ | Count | Info |
|---|---|---|
|
2.82 ms (16.53%) |
4 |
SELECT t0.id AS id_1, t0.prest_grp_code AS prest_grp_code_2, t0.prest_grp_label AS prest_grp_label_3, t0.prest_grp_description AS prest_grp_description_4, t0.prest_grp_tarif AS prest_grp_tarif_5, t0.prest_grp_is_put_forward AS prest_grp_is_put_forward_6, t0.prest_grp_form_type AS prest_grp_form_type_7, t0.prest_grp_not_in_menu AS prest_grp_not_in_menu_8, t0.prest_grp_delay_normal AS prest_grp_delay_normal_9, t0.prest_grp_delay_fast AS prest_grp_delay_fast_10, t0.prest_grp_delay_max AS prest_grp_delay_max_11, t0.prest_grp_range AS prest_grp_range_12, t0.prest_grp_sub_range AS prest_grp_sub_range_13, t0.prest_grp_price_normal_min AS prest_grp_price_normal_min_14, t0.prest_grp_price_normal_max AS prest_grp_price_normal_max_15, t0.prest_grp_price_fast_min AS prest_grp_price_fast_min_16, t0.prest_grp_price_fast_max AS prest_grp_price_fast_max_17, t0.prest_grp_code_unitaire AS prest_grp_code_unitaire_18, t0.prest_grp_cgv_id AS prest_grp_cgv_id_19 FROM dyna_prest_grp t0 WHERE t0.id = ?
Parameters:
[
11
]
|
|
1.52 ms (8.93%) |
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:
[] |
|
1.46 ms (8.57%) |
5 |
SELECT t0.id AS id_1, t0.prest_grp_label AS prest_grp_label_2, t0.prest_grp_description AS prest_grp_description_3, t0.persona_id AS persona_id_4, t0.prest_grp_id AS prest_grp_id_5 FROM dyna_persona_prest_grp t0 WHERE t0.prest_grp_id = ? AND t0.persona_id = ? LIMIT 1
Parameters:
[ 11 7 ] |
|
1.12 ms (6.57%) |
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:
[] |
|
0.99 ms (5.82%) |
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:
[] |
|
0.97 ms (5.66%) |
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
]
|
|
0.96 ms (5.61%) |
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:
[] |
|
0.73 ms (4.26%) |
2 |
SELECT d0_.id AS id_0, d0_.prest_grp_bran_delay_normal AS prest_grp_bran_delay_normal_1, d0_.prest_grp_bran_delay_fast AS prest_grp_bran_delay_fast_2, d0_.prest_grp_bran_delay_max AS prest_grp_bran_delay_max_3, d0_.prest_grp_bran_price_nor_min AS prest_grp_bran_price_nor_min_4, d0_.prest_grp_bran_price_nor_max AS prest_grp_bran_price_nor_max_5, d0_.prest_grp_bran_price_fast_min AS prest_grp_bran_price_fast_min_6, d0_.prest_grp_bran_price_fast_max AS prest_grp_bran_price_fast_max_7, d0_.prest_grp_bran_label AS prest_grp_bran_label_8, d0_.prest_grp_bran_description AS prest_grp_bran_description_9, d0_.prest_grp_id AS prest_grp_id_10, d0_.branch_id AS branch_id_11 FROM dyna_prest_grp_branch d0_ INNER JOIN dyna_prest_grp d1_ ON d0_.prest_grp_id = d1_.id WHERE d0_.branch_id = ? AND d1_.id = ? LIMIT 1
Parameters:
[ 71 11 ] |
|
0.61 ms (3.60%) |
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:
[] |
|
0.61 ms (3.57%) |
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:
[] |
|
0.55 ms (3.20%) |
1 |
SELECT d0_.prest_menu_name AS prest_menu_name_0, d1_.prest_menu_name AS prest_menu_name_1 FROM dyna_prest_menu d0_ INNER JOIN dyna_prest_menu d1_ ON d0_.prest_menu_parent = d1_.id INNER JOIN dyna_prest_menu d2_ ON d1_.prest_menu_parent = d2_.id INNER JOIN dyna_prest_menu_prest_grp d3_ ON d0_.id = d3_.prestMenu WHERE d3_.prestGrp = 11 AND d2_.persona_id = 7 LIMIT 1
Parameters:
[] |
|
0.51 ms (2.99%) |
1 |
SELECT d0_.prest_menu_name AS prest_menu_name_0 FROM dyna_prest_menu d0_ INNER JOIN dyna_prest_menu_prest_grp d1_ ON d0_.id = d1_.prestMenu INNER JOIN dyna_prest_menu d2_ ON d0_.prest_menu_parent = d2_.id WHERE d1_.prestGrp = 11 AND d2_.persona_id = 7 LIMIT 1
Parameters:
[] |
|
0.48 ms (2.79%) |
1 |
SELECT d0_.id AS id_0, d0_.rec_in_cart AS rec_in_cart_1, d0_.rec_source AS rec_source_2, d0_.order_id AS order_id_3 FROM dyna_record d0_ INNER JOIN dyna_order d1_ ON d0_.order_id = d1_.id WHERE d1_.id = 1175 AND d0_.rec_in_cart = 1 ORDER BY d0_.id ASC
Parameters:
[] |
|
0.44 ms (2.60%) |
1 |
SELECT t0.id AS id_1, t0.inv_gems_enq_code AS inv_gems_enq_code_2, t0.inv_user_reference AS inv_user_reference_3, t0.inv_type AS inv_type_4, t0.inv_created_at AS inv_created_at_5, t0.inv_delay AS inv_delay_6, t0.inv_predicted_delivered_at AS inv_predicted_delivered_at_7, t0.inv_delivered_at AS inv_delivered_at_8, t0.inv_result AS inv_result_9, t0.inv_result_details AS inv_result_details_10, t0.inv_stat_result AS inv_stat_result_11, t0.inv_is_monitored AS inv_is_monitored_12, t0.inv_net_ref AS inv_net_ref_13, t0.inv_is_cancelled AS inv_is_cancelled_14, t0.inv_has_priority AS inv_has_priority_15, t0.inv_priority_deadline AS inv_priority_deadline_16, t0.inv_report_unread AS inv_report_unread_17, t0.inv_spf_code AS inv_spf_code_18, t0.inv_zone_defined AS inv_zone_defined_19, t0.inv_montant_encours AS inv_montant_encours_20, t0.inv_forfait_max_recherche AS inv_forfait_max_recherche_21, t0.inv_is_waiting AS inv_is_waiting_22, t0.inv_accepted_at AS inv_accepted_at_23, t0.etat AS etat_24, t0.record_id AS record_id_25, t0.import_id AS import_id_26, t0.req_physical_subject_id AS req_physical_subject_id_27, t0.req_corporation_subject_id AS req_corporation_subject_id_28, t0.req_prest_grp_id AS req_prest_grp_id_29, t0.contest_parent_id AS contest_parent_id_30, t0.report_id AS report_id_31, t0.bill_id AS bill_id_32, t0.estimation_id AS estimation_id_33, t0.inv_supp_parent AS inv_supp_parent_34, t0.inv_update_parent AS inv_update_parent_35, t0.inv_couple_investigation_id AS inv_couple_investigation_id_36 FROM dyna_investigation t0 WHERE t0.record_id = ? ORDER BY t0.inv_created_at ASC
Parameters:
[
1229
]
|
|
0.37 ms (2.17%) |
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
]
|
|
0.35 ms (2.04%) |
1 |
SELECT t0.id AS id_1, t0.order_ordered_at AS order_ordered_at_2, t0.order_billed_to AS order_billed_to_3, t0.order_created_at AS order_created_at_4, t0.order_storage AS order_storage_5, t0.user_id AS user_id_6, t0.import_id AS import_id_7 FROM dyna_order t0 WHERE t0.user_id = ? AND t0.order_ordered_at IS NULL LIMIT 1
Parameters:
[
132
]
|
|
0.34 ms (2.02%) |
1 |
SELECT t0.id AS id_1, t0.prest_grp_code AS prest_grp_code_2, t0.prest_grp_label AS prest_grp_label_3, t0.prest_grp_description AS prest_grp_description_4, t0.prest_grp_tarif AS prest_grp_tarif_5, t0.prest_grp_is_put_forward AS prest_grp_is_put_forward_6, t0.prest_grp_form_type AS prest_grp_form_type_7, t0.prest_grp_not_in_menu AS prest_grp_not_in_menu_8, t0.prest_grp_delay_normal AS prest_grp_delay_normal_9, t0.prest_grp_delay_fast AS prest_grp_delay_fast_10, t0.prest_grp_delay_max AS prest_grp_delay_max_11, t0.prest_grp_range AS prest_grp_range_12, t0.prest_grp_sub_range AS prest_grp_sub_range_13, t0.prest_grp_price_normal_min AS prest_grp_price_normal_min_14, t0.prest_grp_price_normal_max AS prest_grp_price_normal_max_15, t0.prest_grp_price_fast_min AS prest_grp_price_fast_min_16, t0.prest_grp_price_fast_max AS prest_grp_price_fast_max_17, t0.prest_grp_code_unitaire AS prest_grp_code_unitaire_18, t0.prest_grp_cgv_id AS prest_grp_cgv_id_19 FROM dyna_prest_grp t0 INNER JOIN dyna_prest_grp_children ON t0.id = dyna_prest_grp_children.prest_grp_id_child WHERE dyna_prest_grp_children.prest_grp_id_parent = ?
Parameters:
[
11
]
|
|
0.34 ms (2.00%) |
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
]
|
|
0.34 ms (1.97%) |
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
]
|
|
0.33 ms (1.96%) |
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
]
|
|
0.33 ms (1.94%) |
1 |
SELECT t0.id AS id_1, t0.prest_menu_prest_grp_position AS prest_menu_prest_grp_position_2, t0.prestMenu AS prestMenu_3, t0.prestGrp AS prestGrp_4 FROM dyna_prest_menu_prest_grp t0 WHERE t0.prestMenu = ? ORDER BY t0.prest_menu_prest_grp_position ASC
Parameters:
[
4
]
|
|
0.31 ms (1.81%) |
1 |
SELECT t0.id AS id_1, t0.prest_combo_code AS prest_combo_code_2, t0.prest_combo_label AS prest_combo_label_3, t0.prest_combo_cgv_id AS prest_combo_cgv_id_4 FROM dyna_prest_combo t0 WHERE t0.prest_combo_code = ? LIMIT 1
Parameters:
[
"A"
]
|
|
0.29 ms (1.72%) |
1 |
SELECT t0.id AS id_1, t0.rec_in_cart AS rec_in_cart_2, t0.rec_source AS rec_source_3, t0.order_id AS order_id_4 FROM dyna_record t0 WHERE t0.order_id = ? AND t0.rec_in_cart IS NULL LIMIT 1
Parameters:
[
1175
]
|
|
0.28 ms (1.65%) |
1 |
SELECT t0.id AS id_1, t0.prest_menu_name AS prest_menu_name_2, t0.prest_menu_description AS prest_menu_description_3, t0.prest_menu_put_forward AS prest_menu_put_forward_4, t0.prest_menu_type AS prest_menu_type_5, t0.prest_menu_child_position AS prest_menu_child_position_6, t0.prest_menu_parent AS prest_menu_parent_7, t0.persona_id AS persona_id_8 FROM dyna_prest_menu t0 WHERE t0.id = ?
Parameters:
[
4
]
|
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\PrestMenuPrestGrp | 4 |
| App\Entity\PrestGrp | 4 |
| App\Entity\User | 1 |
| App\Entity\Department | 1 |
| App\Entity\Persona | 1 |
| App\Entity\Branch | 1 |
| App\Entity\Corporation | 1 |
| App\Entity\PrestMenu | 1 |
| App\Entity\Cgv | 1 |
| App\Entity\Order | 1 |
| App\Entity\Record | 1 |
| App\Entity\Investigation | 1 |
| App\Entity\PhysicalSubject | 1 |