Symfony Profiler

SELECT
  t0.meeting_report AS meeting_report_1,
  t0.assistant_action AS assistant_action_2,
  t0.is_approved AS is_approved_3,
  t0.send_book AS send_book_4,
  t0.is_ready_for_validation AS is_ready_for_validation_5,
  t0.send_bdc_qty AS send_bdc_qty_6,
  t0.id AS id_7,
  t0.visited_by_id AS visited_by_id_8,
  t0.booking_id AS booking_id_9,
  t0.prescriber_id AS prescriber_id_10,
  t0.next_booking_id AS next_booking_id_11
FROM
  visit_report t0
WHERE
  t0.prescriber_id = ?

SELECT t0.meeting_report AS meeting_report_1, t0.assistant_action AS assistant_action_2, t0.is_approved AS is_approved_3, t0.send_book AS send_book_4, t0.is_ready_for_validation AS is_ready_for_validation_5, t0.send_bdc_qty AS send_bdc_qty_6, t0.id AS id_7, t0.visited_by_id AS visited_by_id_8, t0.booking_id AS booking_id_9, t0.prescriber_id AS prescriber_id_10, t0.next_booking_id AS next_booking_id_11 FROM visit_report t0 WHERE t0.prescriber_id = 3834;

SELECT
  t0.meeting_report AS meeting_report_1,
  t0.assistant_action AS assistant_action_2,
  t0.is_approved AS is_approved_3,
  t0.send_book AS send_book_4,
  t0.is_ready_for_validation AS is_ready_for_validation_5,
  t0.send_bdc_qty AS send_bdc_qty_6,
  t0.id AS id_7,
  t0.visited_by_id AS visited_by_id_8,
  t0.booking_id AS booking_id_9,
  t0.prescriber_id AS prescriber_id_10,
  t0.next_booking_id AS next_booking_id_11
FROM
  visit_report t0
WHERE
  t0.booking_id = ?

SELECT t0.meeting_report AS meeting_report_1, t0.assistant_action AS assistant_action_2, t0.is_approved AS is_approved_3, t0.send_book AS send_book_4, t0.is_ready_for_validation AS is_ready_for_validation_5, t0.send_bdc_qty AS send_bdc_qty_6, t0.id AS id_7, t0.visited_by_id AS visited_by_id_8, t0.booking_id AS booking_id_9, t0.prescriber_id AS prescriber_id_10, t0.next_booking_id AS next_booking_id_11 FROM visit_report t0 WHERE t0.booking_id = 329;

SELECT
  t1.begin_at AS begin_at_2,
  t1.end_at AS end_at_3,
  t1.title AS title_4,
  t1.updated_at AS updated_at_5,
  t1.is_cancelled AS is_cancelled_6,
  t1.cancellation_reason AS cancellation_reason_7,
  t1.id AS id_8,
  t1.owner_id AS owner_id_9,
  t0.method_id AS method_id_10,
  t1.type
FROM
  booking_visit_report t0
  INNER JOIN booking t1 ON t0.id = t1.id
WHERE
  t1.id = ?

SELECT t1.begin_at AS begin_at_2, t1.end_at AS end_at_3, t1.title AS title_4, t1.updated_at AS updated_at_5, t1.is_cancelled AS is_cancelled_6, t1.cancellation_reason AS cancellation_reason_7, t1.id AS id_8, t1.owner_id AS owner_id_9, t0.method_id AS method_id_10, t1.type FROM booking_visit_report t0 INNER JOIN booking t1 ON t0.id = t1.id WHERE t1.id = 329;

SELECT
  t0.username AS username_4,
  t0.roles AS roles_5,
  t0.password AS password_6,
  t0.email AS email_7,
  t0.active AS active_8,
  t0.last_connexion_date AS last_connexion_date_9,
  t0.photo_filename AS photo_filename_10,
  t0.id AS id_11,
  t0.type,
  t1.activity_start_date AS activity_start_date_12,
  t1.firstname AS firstname_13,
  t1.lastname AS lastname_14,
  t1.address AS address_15,
  t1.address2 AS address2_16,
  t1.postal_code AS postal_code_17,
  t1.city AS city_18,
  t1.phone AS phone_19,
  t1.code AS code_20,
  t1.created_at AS created_at_21,
  t1.updated_at AS updated_at_22,
  t1.archived AS archived_23,
  t1.is_displayed_in_forms AS is_displayed_in_forms_24,
  t1.country_id AS country_id_25,
  t1.main_billing_center_id AS main_billing_center_id_26,
  t2.prescriber_code AS prescriber_code_27,
  t2.point_coefficient AS point_coefficient_28,
  t2.address AS address_29,
  t2.address2 AS address2_30,
  t2.activity_start_date AS activity_start_date_31,
  t2.civility AS civility_32,
  t2.lastname AS lastname_33,
  t2.firstname AS firstname_34,
  t2.postal_code AS postal_code_35,
  t2.city AS city_36,
  t2.phone AS phone_37,
  t2.position AS position_38,
  t2.last_prescription_date AS last_prescription_date_39,
  t2.company AS company_40,
  t2.prescriber_validation_date AS prescriber_validation_date_41,
  t2.created_at AS created_at_42,
  t2.updated_at AS updated_at_43,
  t2.extranet_code AS extranet_code_44,
  t2.codial_client_code AS codial_client_code_45,
  t2.need_to_be_exported AS need_to_be_exported_46,
  t2.approved AS approved_47,
  t2.visit_date AS visit_date_48,
  t2.title AS title_49,
  t2.rpps_number AS rpps_number_50,
  t2.siren_number AS siren_number_51,
  t2.source_discovery AS source_discovery_52,
  t2.commercial_id AS commercial_id_53,
  t2.category_id AS category_id_54,
  t2.main_speciality_id AS main_speciality_id_55,
  t2.country_id AS country_id_56,
  t2.billing_center_id AS billing_center_id_57,
  t2.created_by_id AS created_by_id_58,
  t2.activity_status_id AS activity_status_id_59,
  t3.lastname AS lastname_60,
  t3.firstname AS firstname_61,
  t3.is_displayed_in_forms AS is_displayed_in_forms_62
FROM
  user t0
  LEFT JOIN commercial t1 ON t0.id = t1.id
  LEFT JOIN prescriber t2 ON t0.id = t2.id
  LEFT JOIN employee t3 ON t0.id = t3.id
WHERE
  t0.id = ?

SELECT t0.username AS username_4, t0.roles AS roles_5, t0.password AS password_6, t0.email AS email_7, t0.active AS active_8, t0.last_connexion_date AS last_connexion_date_9, t0.photo_filename AS photo_filename_10, t0.id AS id_11, t0.type, t1.activity_start_date AS activity_start_date_12, t1.firstname AS firstname_13, t1.lastname AS lastname_14, t1.address AS address_15, t1.address2 AS address2_16, t1.postal_code AS postal_code_17, t1.city AS city_18, t1.phone AS phone_19, t1.code AS code_20, t1.created_at AS created_at_21, t1.updated_at AS updated_at_22, t1.archived AS archived_23, t1.is_displayed_in_forms AS is_displayed_in_forms_24, t1.country_id AS country_id_25, t1.main_billing_center_id AS main_billing_center_id_26, t2.prescriber_code AS prescriber_code_27, t2.point_coefficient AS point_coefficient_28, t2.address AS address_29, t2.address2 AS address2_30, t2.activity_start_date AS activity_start_date_31, t2.civility AS civility_32, t2.lastname AS lastname_33, t2.firstname AS firstname_34, t2.postal_code AS postal_code_35, t2.city AS city_36, t2.phone AS phone_37, t2.position AS position_38, t2.last_prescription_date AS last_prescription_date_39, t2.company AS company_40, t2.prescriber_validation_date AS prescriber_validation_date_41, t2.created_at AS created_at_42, t2.updated_at AS updated_at_43, t2.extranet_code AS extranet_code_44, t2.codial_client_code AS codial_client_code_45, t2.need_to_be_exported AS need_to_be_exported_46, t2.approved AS approved_47, t2.visit_date AS visit_date_48, t2.title AS title_49, t2.rpps_number AS rpps_number_50, t2.siren_number AS siren_number_51, t2.source_discovery AS source_discovery_52, t2.commercial_id AS commercial_id_53, t2.category_id AS category_id_54, t2.main_speciality_id AS main_speciality_id_55, t2.country_id AS country_id_56, t2.billing_center_id AS billing_center_id_57, t2.created_by_id AS created_by_id_58, t2.activity_status_id AS activity_status_id_59, t3.lastname AS lastname_60, t3.firstname AS firstname_61, t3.is_displayed_in_forms AS is_displayed_in_forms_62 FROM user t0 LEFT JOIN commercial t1 ON t0.id = t1.id LEFT JOIN prescriber t2 ON t0.id = t2.id LEFT JOIN employee t3 ON t0.id = t3.id WHERE t0.id = 413;

SELECT
  COUNT(*)
FROM
  visit_report t0
WHERE
  t0.is_ready_for_validation = ?

SELECT COUNT(*) FROM visit_report t0 WHERE t0.is_ready_for_validation = 0;

SELECT
  t0.name AS name_1,
  t0.email AS email_2,
  t0.slug AS slug_3,
  t0.id AS id_4
FROM
  message_receiver t0
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.name AS name_1, t0.email AS email_2, t0.slug AS slug_3, t0.id AS id_4 FROM message_receiver t0 WHERE t0.slug = 'orders' LIMIT 1;

SELECT
  m0_.name AS name_0,
  m0_.email AS email_1,
  m0_.slug AS slug_2,
  m0_.id AS id_3
FROM
  message_receiver m0_
ORDER BY
  m0_.name ASC

SELECT m0_.name AS name_0, m0_.email AS email_1, m0_.slug AS slug_2, m0_.id AS id_3 FROM message_receiver m0_ ORDER BY m0_.name ASC;

SELECT
  u0_.username AS username_0,
  u0_.roles AS roles_1,
  u0_.password AS password_2,
  u0_.email AS email_3,
  u0_.active AS active_4,
  u0_.last_connexion_date AS last_connexion_date_5,
  u0_.photo_filename AS photo_filename_6,
  u0_.id AS id_7,
  p1_.prescriber_code AS prescriber_code_8,
  p1_.point_coefficient AS point_coefficient_9,
  p1_.address AS address_10,
  p1_.address2 AS address2_11,
  p1_.activity_start_date AS activity_start_date_12,
  p1_.civility AS civility_13,
  p1_.lastname AS lastname_14,
  p1_.firstname AS firstname_15,
  p1_.postal_code AS postal_code_16,
  p1_.city AS city_17,
  p1_.phone AS phone_18,
  p1_.position AS position_19,
  p1_.last_prescription_date AS last_prescription_date_20,
  p1_.company AS company_21,
  p1_.prescriber_validation_date AS prescriber_validation_date_22,
  p1_.created_at AS created_at_23,
  p1_.updated_at AS updated_at_24,
  p1_.extranet_code AS extranet_code_25,
  p1_.codial_client_code AS codial_client_code_26,
  p1_.need_to_be_exported AS need_to_be_exported_27,
  p1_.approved AS approved_28,
  p1_.visit_date AS visit_date_29,
  p1_.title AS title_30,
  p1_.rpps_number AS rpps_number_31,
  p1_.siren_number AS siren_number_32,
  p1_.source_discovery AS source_discovery_33,
  u0_.type AS type_34,
  p1_.commercial_id AS commercial_id_35,
  p1_.category_id AS category_id_36,
  p1_.main_speciality_id AS main_speciality_id_37,
  p1_.country_id AS country_id_38,
  p1_.billing_center_id AS billing_center_id_39,
  p1_.created_by_id AS created_by_id_40,
  p1_.activity_status_id AS activity_status_id_41
FROM
  prescriber p1_
  INNER JOIN user u0_ ON p1_.id = u0_.id
WHERE
  p1_.approved = ?
  AND p1_.activity_status_id IS NULL

SELECT u0_.username AS username_0, u0_.roles AS roles_1, u0_.password AS password_2, u0_.email AS email_3, u0_.active AS active_4, u0_.last_connexion_date AS last_connexion_date_5, u0_.photo_filename AS photo_filename_6, u0_.id AS id_7, p1_.prescriber_code AS prescriber_code_8, p1_.point_coefficient AS point_coefficient_9, p1_.address AS address_10, p1_.address2 AS address2_11, p1_.activity_start_date AS activity_start_date_12, p1_.civility AS civility_13, p1_.lastname AS lastname_14, p1_.firstname AS firstname_15, p1_.postal_code AS postal_code_16, p1_.city AS city_17, p1_.phone AS phone_18, p1_.position AS position_19, p1_.last_prescription_date AS last_prescription_date_20, p1_.company AS company_21, p1_.prescriber_validation_date AS prescriber_validation_date_22, p1_.created_at AS created_at_23, p1_.updated_at AS updated_at_24, p1_.extranet_code AS extranet_code_25, p1_.codial_client_code AS codial_client_code_26, p1_.need_to_be_exported AS need_to_be_exported_27, p1_.approved AS approved_28, p1_.visit_date AS visit_date_29, p1_.title AS title_30, p1_.rpps_number AS rpps_number_31, p1_.siren_number AS siren_number_32, p1_.source_discovery AS source_discovery_33, u0_.type AS type_34, p1_.commercial_id AS commercial_id_35, p1_.category_id AS category_id_36, p1_.main_speciality_id AS main_speciality_id_37, p1_.country_id AS country_id_38, p1_.billing_center_id AS billing_center_id_39, p1_.created_by_id AS created_by_id_40, p1_.activity_status_id AS activity_status_id_41 FROM prescriber p1_ INNER JOIN user u0_ ON p1_.id = u0_.id WHERE p1_.approved = 0 AND p1_.activity_status_id IS NULL;

SELECT
  u0_.username AS username_0,
  u0_.roles AS roles_1,
  u0_.password AS password_2,
  u0_.email AS email_3,
  u0_.active AS active_4,
  u0_.last_connexion_date AS last_connexion_date_5,
  u0_.photo_filename AS photo_filename_6,
  u0_.id AS id_7,
  p1_.prescriber_code AS prescriber_code_8,
  p1_.point_coefficient AS point_coefficient_9,
  p1_.address AS address_10,
  p1_.address2 AS address2_11,
  p1_.activity_start_date AS activity_start_date_12,
  p1_.civility AS civility_13,
  p1_.lastname AS lastname_14,
  p1_.firstname AS firstname_15,
  p1_.postal_code AS postal_code_16,
  p1_.city AS city_17,
  p1_.phone AS phone_18,
  p1_.position AS position_19,
  p1_.last_prescription_date AS last_prescription_date_20,
  p1_.company AS company_21,
  p1_.prescriber_validation_date AS prescriber_validation_date_22,
  p1_.created_at AS created_at_23,
  p1_.updated_at AS updated_at_24,
  p1_.extranet_code AS extranet_code_25,
  p1_.codial_client_code AS codial_client_code_26,
  p1_.need_to_be_exported AS need_to_be_exported_27,
  p1_.approved AS approved_28,
  p1_.visit_date AS visit_date_29,
  p1_.title AS title_30,
  p1_.rpps_number AS rpps_number_31,
  p1_.siren_number AS siren_number_32,
  p1_.source_discovery AS source_discovery_33,
  u0_.type AS type_34,
  p1_.commercial_id AS commercial_id_35,
  p1_.category_id AS category_id_36,
  p1_.main_speciality_id AS main_speciality_id_37,
  p1_.country_id AS country_id_38,
  p1_.billing_center_id AS billing_center_id_39,
  p1_.created_by_id AS created_by_id_40,
  p1_.activity_status_id AS activity_status_id_41
FROM
  prescriber p1_
  INNER JOIN user u0_ ON p1_.id = u0_.id
  INNER JOIN prescriber_activity_status p2_ ON p1_.activity_status_id = p2_.id
WHERE
  p1_.approved = ?
  AND p2_.slug = ?
ORDER BY
  p1_.created_at ASC

SELECT u0_.username AS username_0, u0_.roles AS roles_1, u0_.password AS password_2, u0_.email AS email_3, u0_.active AS active_4, u0_.last_connexion_date AS last_connexion_date_5, u0_.photo_filename AS photo_filename_6, u0_.id AS id_7, p1_.prescriber_code AS prescriber_code_8, p1_.point_coefficient AS point_coefficient_9, p1_.address AS address_10, p1_.address2 AS address2_11, p1_.activity_start_date AS activity_start_date_12, p1_.civility AS civility_13, p1_.lastname AS lastname_14, p1_.firstname AS firstname_15, p1_.postal_code AS postal_code_16, p1_.city AS city_17, p1_.phone AS phone_18, p1_.position AS position_19, p1_.last_prescription_date AS last_prescription_date_20, p1_.company AS company_21, p1_.prescriber_validation_date AS prescriber_validation_date_22, p1_.created_at AS created_at_23, p1_.updated_at AS updated_at_24, p1_.extranet_code AS extranet_code_25, p1_.codial_client_code AS codial_client_code_26, p1_.need_to_be_exported AS need_to_be_exported_27, p1_.approved AS approved_28, p1_.visit_date AS visit_date_29, p1_.title AS title_30, p1_.rpps_number AS rpps_number_31, p1_.siren_number AS siren_number_32, p1_.source_discovery AS source_discovery_33, u0_.type AS type_34, p1_.commercial_id AS commercial_id_35, p1_.category_id AS category_id_36, p1_.main_speciality_id AS main_speciality_id_37, p1_.country_id AS country_id_38, p1_.billing_center_id AS billing_center_id_39, p1_.created_by_id AS created_by_id_40, p1_.activity_status_id AS activity_status_id_41 FROM prescriber p1_ INNER JOIN user u0_ ON p1_.id = u0_.id INNER JOIN prescriber_activity_status p2_ ON p1_.activity_status_id = p2_.id WHERE p1_.approved = 0 AND p2_.slug = 'new' ORDER BY p1_.created_at ASC;

SELECT
  COUNT(i0_.id) AS sclr_0
FROM
  invoice i0_
WHERE
  i0_.prescriber_validation_user_id IS NULL

SELECT COUNT(i0_.id) AS sclr_0 FROM invoice i0_ WHERE i0_.prescriber_validation_user_id IS NULL;

SELECT
  COUNT(*)
FROM
  visit_report t0
WHERE
  t0.is_approved = ?

SELECT COUNT(*) FROM visit_report t0 WHERE t0.is_approved = 0;

SELECT
  COUNT(*)
FROM
  visit_report t0
WHERE
  t0.is_ready_for_validation = ?
  AND t0.is_approved = ?

SELECT COUNT(*) FROM visit_report t0 WHERE t0.is_ready_for_validation = 1 AND t0.is_approved = 0;