Symfony Profiler

SELECT
  count(l0_.id) AS sclr_0
FROM
  leave_application l0_
  INNER JOIN user u1_ ON l0_.user_id = u1_.id
  INNER JOIN user_manager u2_ ON u1_.id = u2_.managed_id
  INNER JOIN user u3_ ON u2_.manager_id = u3_.id
WHERE
  l0_.current_status IN (?, ?)
  AND u3_.id = ?
  AND (
    (
      u2_.permissions = ?
      OR u2_.permissions = ?
    )
  )

SELECT count(l0_.id) AS sclr_0 FROM leave_application l0_ INNER JOIN user u1_ ON l0_.user_id = u1_.id INNER JOIN user_manager u2_ ON u1_.id = u2_.managed_id INNER JOIN user u3_ ON u2_.manager_id = u3_.id WHERE l0_.current_status IN (0, 4) AND u3_.id = 3073 AND ((u2_.permissions = 0 OR u2_.permissions = 2));

SELECT
  DISTINCT e0_.id AS id_0,
  e0_.date AS date_1
FROM
  expense e0_
WHERE
  e0_.expense_report_id = ?
ORDER BY
  e0_.date DESC
LIMIT
  40

SELECT DISTINCT e0_.id AS id_0, e0_.date AS date_1 FROM expense e0_ WHERE e0_.expense_report_id = 23117 ORDER BY e0_.date DESC LIMIT 40;

SELECT
  e0_.id AS id_0,
  e0_.date AS date_1,
  e0_.justification AS justification_2,
  e0_.price AS price_3,
  e0_.price_including_tax AS price_including_tax_4,
  e0_.place AS place_5,
  e0_.currency AS currency_6,
  e0_.country AS country_7,
  e0_.file_path AS file_path_8,
  e0_.guests AS guests_9,
  e0_.nb_nights AS nb_nights_10,
  e0_.destination_from AS destination_from_11,
  e0_.destination AS destination_12,
  e0_.from_work AS from_work_13,
  e0_.round_trip AS round_trip_14,
  e0_.card_type AS card_type_15,
  e0_.distance AS distance_16,
  e0_.closed_at AS closed_at_17,
  e0_.closed_by AS closed_by_18,
  e0_.price_before_close AS price_before_close_19,
  e0_.price_including_tax_before_close AS price_including_tax_before_close_20,
  e0_.currency_before_close AS currency_before_close_21,
  e0_.manager_comment AS manager_comment_22,
  e0_.type AS type_23,
  e0_.horsepower AS horsepower_24,
  e0_.vehicle_type AS vehicle_type_25,
  e0_.created_at AS created_at_26,
  e0_.updated_at AS updated_at_27,
  e0_.expense_report_id AS expense_report_id_28
FROM
  expense e0_
WHERE
  e0_.expense_report_id = ?
  AND e0_.id IN (?, ?, ?, ?)
ORDER BY
  e0_.date DESC

SELECT e0_.id AS id_0, e0_.date AS date_1, e0_.justification AS justification_2, e0_.price AS price_3, e0_.price_including_tax AS price_including_tax_4, e0_.place AS place_5, e0_.currency AS currency_6, e0_.country AS country_7, e0_.file_path AS file_path_8, e0_.guests AS guests_9, e0_.nb_nights AS nb_nights_10, e0_.destination_from AS destination_from_11, e0_.destination AS destination_12, e0_.from_work AS from_work_13, e0_.round_trip AS round_trip_14, e0_.card_type AS card_type_15, e0_.distance AS distance_16, e0_.closed_at AS closed_at_17, e0_.closed_by AS closed_by_18, e0_.price_before_close AS price_before_close_19, e0_.price_including_tax_before_close AS price_including_tax_before_close_20, e0_.currency_before_close AS currency_before_close_21, e0_.manager_comment AS manager_comment_22, e0_.type AS type_23, e0_.horsepower AS horsepower_24, e0_.vehicle_type AS vehicle_type_25, e0_.created_at AS created_at_26, e0_.updated_at AS updated_at_27, e0_.expense_report_id AS expense_report_id_28 FROM expense e0_ WHERE e0_.expense_report_id = 23117 AND e0_.id IN (120287, 120288, 120290, 120289) ORDER BY e0_.date DESC;

SELECT
  count(DISTINCT e0_.id) AS sclr_0
FROM
  expense e0_
WHERE
  e0_.expense_report_id = ?

SELECT count(DISTINCT e0_.id) AS sclr_0 FROM expense e0_ WHERE e0_.expense_report_id = 23117;

SELECT
  t0.id AS id_1,
  t0.roles AS roles_2,
  t0.password AS password_3,
  t0.enabled AS enabled_4,
  t0.email AS email_5,
  t0.firstname AS firstname_6,
  t0.lastname AS lastname_7,
  t0.leave_balance AS leave_balance_8,
  t0.leave_balance_payslip AS leave_balance_payslip_9,
  t0.available_leave_balance_payslip AS available_leave_balance_payslip_10,
  t0.leaves_taken_since_payslip AS leaves_taken_since_payslip_11,
  t0.payslip_date AS payslip_date_12,
  t0.payslip_date2 AS payslip_date2_13,
  t0.future_leaves AS future_leaves_14,
  t0.rtt AS rtt_15,
  t0.rr AS rr_16,
  t0.rc AS rc_17,
  t0.leaves_taken_before AS leaves_taken_before_18,
  t0.avatar AS avatar_19,
  t0.vehicule_number AS vehicule_number_20,
  t0.vehicule_registration AS vehicule_registration_21,
  t0.vehicule_number_pro AS vehicule_number_pro_22,
  t0.has_pro_card AS has_pro_card_23,
  t0.home_to_work_distance_cache AS home_to_work_distance_cache_24,
  t0.home_to_work_distance_cache_update_at AS home_to_work_distance_cache_update_at_25,
  t0.schedule_type AS schedule_type_26,
  t0.color AS color_27,
  t0.theme AS theme_28,
  t0.leave_balance_update_date AS leave_balance_update_date_29,
  t0.work_region AS work_region_30,
  t0.work_country AS work_country_31,
  t0.calendar_preference AS calendar_preference_32,
  t0.job AS job_33,
  t0.last_login AS last_login_34,
  t0.job_title AS job_title_35,
  t0.phone_number AS phone_number_36,
  t0.mobile_phone_number AS mobile_phone_number_37,
  t0.linked_in AS linked_in_38,
  t0.slug AS slug_39,
  t0.created_at AS created_at_40,
  t0.updated_at AS updated_at_41,
  t0.api_id AS api_id_42,
  t0.address_city AS address_city_43,
  t0.address_zip_code AS address_zip_code_44,
  t0.address_street AS address_street_45,
  t0.address_extra AS address_extra_46,
  t0.address_country AS address_country_47,
  t0.company_id AS company_id_48,
  t49.id AS id_50,
  t49.name AS name_51,
  t49.logo AS logo_52,
  t49.logo_dark_theme AS logo_dark_theme_53,
  t49.color AS color_54,
  t49.km_price AS km_price_55,
  t49.alert_id AS alert_id_56,
  t49.furlough_leaves_enabled AS furlough_leaves_enabled_57,
  t49.sharing_leaves AS sharing_leaves_58,
  t49.vcard_enabled AS vcard_enabled_59,
  t49.saturday_leaves_enabled AS saturday_leaves_enabled_60,
  t49.linked_in AS linked_in_61,
  t49.mileage_pricing_type AS mileage_pricing_type_62,
  t49.ethics AS ethics_63,
  t49.created_at AS created_at_64,
  t49.updated_at AS updated_at_65,
  t49.api_id AS api_id_66,
  t49.address_city AS address_city_67,
  t49.address_zip_code AS address_zip_code_68,
  t49.address_street AS address_street_69,
  t49.address_extra AS address_extra_70,
  t49.address_country AS address_country_71,
  t49.hpr_group_id AS hpr_group_id_72,
  t49.bu_id AS bu_id_73,
  t0.company_card_id AS company_card_id_74,
  t0.workplace_id AS workplace_id_75,
  t76.id AS id_77,
  t76.name AS name_78,
  t76.created_at AS created_at_79,
  t76.updated_at AS updated_at_80,
  t76.api_id AS api_id_81,
  t76.address_city AS address_city_82,
  t76.address_zip_code AS address_zip_code_83,
  t76.address_street AS address_street_84,
  t76.address_extra AS address_extra_85,
  t76.address_country AS address_country_86
FROM
  user t0
  INNER JOIN company t49 ON t0.company_id = t49.id
  LEFT JOIN workplace t76 ON t0.workplace_id = t76.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.roles AS roles_2, t0.password AS password_3, t0.enabled AS enabled_4, t0.email AS email_5, t0.firstname AS firstname_6, t0.lastname AS lastname_7, t0.leave_balance AS leave_balance_8, t0.leave_balance_payslip AS leave_balance_payslip_9, t0.available_leave_balance_payslip AS available_leave_balance_payslip_10, t0.leaves_taken_since_payslip AS leaves_taken_since_payslip_11, t0.payslip_date AS payslip_date_12, t0.payslip_date2 AS payslip_date2_13, t0.future_leaves AS future_leaves_14, t0.rtt AS rtt_15, t0.rr AS rr_16, t0.rc AS rc_17, t0.leaves_taken_before AS leaves_taken_before_18, t0.avatar AS avatar_19, t0.vehicule_number AS vehicule_number_20, t0.vehicule_registration AS vehicule_registration_21, t0.vehicule_number_pro AS vehicule_number_pro_22, t0.has_pro_card AS has_pro_card_23, t0.home_to_work_distance_cache AS home_to_work_distance_cache_24, t0.home_to_work_distance_cache_update_at AS home_to_work_distance_cache_update_at_25, t0.schedule_type AS schedule_type_26, t0.color AS color_27, t0.theme AS theme_28, t0.leave_balance_update_date AS leave_balance_update_date_29, t0.work_region AS work_region_30, t0.work_country AS work_country_31, t0.calendar_preference AS calendar_preference_32, t0.job AS job_33, t0.last_login AS last_login_34, t0.job_title AS job_title_35, t0.phone_number AS phone_number_36, t0.mobile_phone_number AS mobile_phone_number_37, t0.linked_in AS linked_in_38, t0.slug AS slug_39, t0.created_at AS created_at_40, t0.updated_at AS updated_at_41, t0.api_id AS api_id_42, t0.address_city AS address_city_43, t0.address_zip_code AS address_zip_code_44, t0.address_street AS address_street_45, t0.address_extra AS address_extra_46, t0.address_country AS address_country_47, t0.company_id AS company_id_48, t49.id AS id_50, t49.name AS name_51, t49.logo AS logo_52, t49.logo_dark_theme AS logo_dark_theme_53, t49.color AS color_54, t49.km_price AS km_price_55, t49.alert_id AS alert_id_56, t49.furlough_leaves_enabled AS furlough_leaves_enabled_57, t49.sharing_leaves AS sharing_leaves_58, t49.vcard_enabled AS vcard_enabled_59, t49.saturday_leaves_enabled AS saturday_leaves_enabled_60, t49.linked_in AS linked_in_61, t49.mileage_pricing_type AS mileage_pricing_type_62, t49.ethics AS ethics_63, t49.created_at AS created_at_64, t49.updated_at AS updated_at_65, t49.api_id AS api_id_66, t49.address_city AS address_city_67, t49.address_zip_code AS address_zip_code_68, t49.address_street AS address_street_69, t49.address_extra AS address_extra_70, t49.address_country AS address_country_71, t49.hpr_group_id AS hpr_group_id_72, t49.bu_id AS bu_id_73, t0.company_card_id AS company_card_id_74, t0.workplace_id AS workplace_id_75, t76.id AS id_77, t76.name AS name_78, t76.created_at AS created_at_79, t76.updated_at AS updated_at_80, t76.api_id AS api_id_81, t76.address_city AS address_city_82, t76.address_zip_code AS address_zip_code_83, t76.address_street AS address_street_84, t76.address_extra AS address_extra_85, t76.address_country AS address_country_86 FROM user t0 INNER JOIN company t49 ON t0.company_id = t49.id LEFT JOIN workplace t76 ON t0.workplace_id = t76.id WHERE t0.id = 3073;

SELECT
  t0.id AS id_1,
  t0.permissions AS permissions_2,
  t0.created_at AS created_at_3,
  t0.manager_id AS manager_id_4,
  t0.managed_id AS managed_id_5
FROM
  user_manager t0
WHERE
  (
    (
      t0.permissions = ?
      OR t0.permissions = ?
    )
    AND t0.manager_id = ?
  )

SELECT t0.id AS id_1, t0.permissions AS permissions_2, t0.created_at AS created_at_3, t0.manager_id AS manager_id_4, t0.managed_id AS managed_id_5 FROM user_manager t0 WHERE ((t0.permissions = 0 OR t0.permissions = 2) AND t0.manager_id = 3073);

SELECT
  t0.id AS id_1,
  t0.date AS date_2,
  t0.justification AS justification_3,
  t0.price AS price_4,
  t0.price_including_tax AS price_including_tax_5,
  t0.place AS place_6,
  t0.currency AS currency_7,
  t0.country AS country_8,
  t0.file_path AS file_path_9,
  t0.guests AS guests_10,
  t0.nb_nights AS nb_nights_11,
  t0.destination_from AS destination_from_12,
  t0.destination AS destination_13,
  t0.from_work AS from_work_14,
  t0.round_trip AS round_trip_15,
  t0.card_type AS card_type_16,
  t0.distance AS distance_17,
  t0.closed_at AS closed_at_18,
  t0.closed_by AS closed_by_19,
  t0.price_before_close AS price_before_close_20,
  t0.price_including_tax_before_close AS price_including_tax_before_close_21,
  t0.currency_before_close AS currency_before_close_22,
  t0.manager_comment AS manager_comment_23,
  t0.type AS type_24,
  t0.horsepower AS horsepower_25,
  t0.vehicle_type AS vehicle_type_26,
  t0.created_at AS created_at_27,
  t0.updated_at AS updated_at_28,
  t0.expense_report_id AS expense_report_id_29
FROM
  expense t0
WHERE
  t0.expense_report_id = ?
ORDER BY
  t0.created_at DESC

SELECT t0.id AS id_1, t0.date AS date_2, t0.justification AS justification_3, t0.price AS price_4, t0.price_including_tax AS price_including_tax_5, t0.place AS place_6, t0.currency AS currency_7, t0.country AS country_8, t0.file_path AS file_path_9, t0.guests AS guests_10, t0.nb_nights AS nb_nights_11, t0.destination_from AS destination_from_12, t0.destination AS destination_13, t0.from_work AS from_work_14, t0.round_trip AS round_trip_15, t0.card_type AS card_type_16, t0.distance AS distance_17, t0.closed_at AS closed_at_18, t0.closed_by AS closed_by_19, t0.price_before_close AS price_before_close_20, t0.price_including_tax_before_close AS price_including_tax_before_close_21, t0.currency_before_close AS currency_before_close_22, t0.manager_comment AS manager_comment_23, t0.type AS type_24, t0.horsepower AS horsepower_25, t0.vehicle_type AS vehicle_type_26, t0.created_at AS created_at_27, t0.updated_at AS updated_at_28, t0.expense_report_id AS expense_report_id_29 FROM expense t0 WHERE t0.expense_report_id = 23117 ORDER BY t0.created_at DESC;

SELECT
  t0.id AS id_1,
  t0.created_at AS created_at_2,
  t0.message AS message_3,
  t0.user_id AS user_id_4,
  t0.expense_id AS expense_id_5
FROM
  expense_comment t0
WHERE
  t0.expense_id IN (?, ?, ?, ?)

SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.message AS message_3, t0.user_id AS user_id_4, t0.expense_id AS expense_id_5 FROM expense_comment t0 WHERE t0.expense_id IN (120287, 120288, 120290, 120289);

SELECT
  t0.id AS id_1,
  t0.current_status AS current_status_2,
  t0.updated_at AS updated_at_3,
  t0.total AS total_4,
  t0.manual_update_date AS manual_update_date_5,
  t0.created_at AS created_at_6,
  t0.user_id AS user_id_7
FROM
  expense_report t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.current_status AS current_status_2, t0.updated_at AS updated_at_3, t0.total AS total_4, t0.manual_update_date AS manual_update_date_5, t0.created_at AS created_at_6, t0.user_id AS user_id_7 FROM expense_report t0 WHERE t0.id = '23117';

SELECT
  t0.id AS id_1,
  t0.permissions AS permissions_2,
  t0.created_at AS created_at_3,
  t0.manager_id AS manager_id_4,
  t0.managed_id AS managed_id_5
FROM
  user_manager t0
WHERE
  t0.manager_id = ?

SELECT t0.id AS id_1, t0.permissions AS permissions_2, t0.created_at AS created_at_3, t0.manager_id AS manager_id_4, t0.managed_id AS managed_id_5 FROM user_manager t0 WHERE t0.manager_id = 3073;

SELECT
  count(e0_.id) AS sclr_0
FROM
  expense_report e0_
  INNER JOIN user u1_ ON e0_.user_id = u1_.id
  INNER JOIN user_manager u2_ ON u1_.id = u2_.managed_id
  INNER JOIN user u3_ ON u2_.manager_id = u3_.id
WHERE
  e0_.current_status = ?
  AND u3_.id = ?

SELECT count(e0_.id) AS sclr_0 FROM expense_report e0_ INNER JOIN user u1_ ON e0_.user_id = u1_.id INNER JOIN user_manager u2_ ON u1_.id = u2_.managed_id INNER JOIN user u3_ ON u2_.manager_id = u3_.id WHERE e0_.current_status = 1 AND u3_.id = 3073;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.ethics AS ethics_3,
  t0.conflict_of_interest_disclosure AS conflict_of_interest_disclosure_4,
  t0.invitation_disclosure AS invitation_disclosure_5
FROM
  bu t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.ethics AS ethics_3, t0.conflict_of_interest_disclosure AS conflict_of_interest_disclosure_4, t0.invitation_disclosure AS invitation_disclosure_5 FROM bu t0 WHERE t0.id = 5;

SELECT
  t0.id AS id_1,
  t0.created_at AS created_at_2,
  t0.status AS status_3,
  t0.message AS message_4,
  t0.user_id AS user_id_5,
  t0.expense_report_id AS expense_report_id_6
FROM
  expense_report_event t0
WHERE
  t0.expense_report_id = ?

SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.status AS status_3, t0.message AS message_4, t0.user_id AS user_id_5, t0.expense_report_id AS expense_report_id_6 FROM expense_report_event t0 WHERE t0.expense_report_id = 23117;