Symfony Profiler

SELECT
  w0_.history AS history_0,
  w1_.id AS id_1,
  w1_.id AS id_2,
  w1_.exit_at AS exit_at_3,
  w1_.entry_at AS entry_at_4,
  w2_.year AS year_5,
  w1_.hourly_rate AS hourly_rate_6,
  w1_.daily_working_hours AS daily_working_hours_7,
  w3_.slug AS slug_8,
  CONCAT(w3_.name, ' ', w3_.surname) AS sclr_9,
  (
    CASE WHEN w1_.exit_at IS NULL
    OR w1_.exit_at > CURRENT_DATE THEN 1 ELSE 0 END
  ) AS sclr_10,
  CONCAT(p4_.company, ', ', c5_.name) AS sclr_11,
  w2_.m8_d1 AS m8_d1_12,
  w2_.m8_d2 AS m8_d2_13,
  w2_.m8_d3 AS m8_d3_14,
  w2_.m8_d4 AS m8_d4_15,
  w2_.m8_d5 AS m8_d5_16,
  w2_.m8_d6 AS m8_d6_17,
  w2_.m8_d7 AS m8_d7_18,
  w2_.m8_d8 AS m8_d8_19,
  w2_.m8_d9 AS m8_d9_20,
  w2_.m8_d10 AS m8_d10_21,
  w2_.m8_d11 AS m8_d11_22,
  w2_.m8_d12 AS m8_d12_23,
  w2_.m8_d13 AS m8_d13_24,
  w2_.m8_d14 AS m8_d14_25,
  w2_.m8_d15 AS m8_d15_26,
  w2_.m8_d16 AS m8_d16_27,
  w2_.m8_d17 AS m8_d17_28,
  w2_.m8_d18 AS m8_d18_29,
  w2_.m8_d19 AS m8_d19_30,
  w2_.m8_d20 AS m8_d20_31,
  w2_.m8_d21 AS m8_d21_32,
  w2_.m8_d22 AS m8_d22_33,
  w2_.m8_d23 AS m8_d23_34,
  w2_.m8_d24 AS m8_d24_35,
  w2_.m8_d25 AS m8_d25_36,
  w2_.m8_d26 AS m8_d26_37,
  w2_.m8_d27 AS m8_d27_38,
  w2_.m8_d28 AS m8_d28_39,
  w2_.m8_d29 AS m8_d29_40,
  w2_.m8_d30 AS m8_d30_41,
  w2_.m8_d31 AS m8_d31_42
FROM
  worker_timesheet w2_
  INNER JOIN worker_activities w1_ ON w2_.worker_activity_id = w1_.id
  LEFT JOIN worker_timesheet_histories w0_ ON w2_.id = w0_.worker_timesheet_id
  LEFT JOIN worker w3_ ON w1_.worker_id = w3_.id
  LEFT JOIN partner p4_ ON w1_.partner_id = p4_.id
  LEFT JOIN countries c5_ ON p4_.country_id = c5_.id
  LEFT JOIN worker_in_project w6_ ON w1_.id = w6_.worker_activity_id
  LEFT JOIN project_stakeholders p7_ ON w6_.project_id = p7_.id
  LEFT JOIN projects p8_ ON p7_.project_id = p8_.id
WHERE
  w2_.year = ?
  AND p8_.id = ?
GROUP BY
  w2_.id
ORDER BY
  w2_.id DESC

SELECT w0_.history AS history_0, w1_.id AS id_1, w1_.id AS id_2, w1_.exit_at AS exit_at_3, w1_.entry_at AS entry_at_4, w2_.year AS year_5, w1_.hourly_rate AS hourly_rate_6, w1_.daily_working_hours AS daily_working_hours_7, w3_.slug AS slug_8, CONCAT(w3_.name, ' ', w3_.surname) AS sclr_9, (CASE WHEN w1_.exit_at IS NULL OR w1_.exit_at > CURRENT_DATE THEN 1 ELSE 0 END) AS sclr_10, CONCAT(p4_.company, ', ', c5_.name) AS sclr_11, w2_.m8_d1 AS m8_d1_12, w2_.m8_d2 AS m8_d2_13, w2_.m8_d3 AS m8_d3_14, w2_.m8_d4 AS m8_d4_15, w2_.m8_d5 AS m8_d5_16, w2_.m8_d6 AS m8_d6_17, w2_.m8_d7 AS m8_d7_18, w2_.m8_d8 AS m8_d8_19, w2_.m8_d9 AS m8_d9_20, w2_.m8_d10 AS m8_d10_21, w2_.m8_d11 AS m8_d11_22, w2_.m8_d12 AS m8_d12_23, w2_.m8_d13 AS m8_d13_24, w2_.m8_d14 AS m8_d14_25, w2_.m8_d15 AS m8_d15_26, w2_.m8_d16 AS m8_d16_27, w2_.m8_d17 AS m8_d17_28, w2_.m8_d18 AS m8_d18_29, w2_.m8_d19 AS m8_d19_30, w2_.m8_d20 AS m8_d20_31, w2_.m8_d21 AS m8_d21_32, w2_.m8_d22 AS m8_d22_33, w2_.m8_d23 AS m8_d23_34, w2_.m8_d24 AS m8_d24_35, w2_.m8_d25 AS m8_d25_36, w2_.m8_d26 AS m8_d26_37, w2_.m8_d27 AS m8_d27_38, w2_.m8_d28 AS m8_d28_39, w2_.m8_d29 AS m8_d29_40, w2_.m8_d30 AS m8_d30_41, w2_.m8_d31 AS m8_d31_42 FROM worker_timesheet w2_ INNER JOIN worker_activities w1_ ON w2_.worker_activity_id = w1_.id LEFT JOIN worker_timesheet_histories w0_ ON w2_.id = w0_.worker_timesheet_id LEFT JOIN worker w3_ ON w1_.worker_id = w3_.id LEFT JOIN partner p4_ ON w1_.partner_id = p4_.id LEFT JOIN countries c5_ ON p4_.country_id = c5_.id LEFT JOIN worker_in_project w6_ ON w1_.id = w6_.worker_activity_id LEFT JOIN project_stakeholders p7_ ON w6_.project_id = p7_.id LEFT JOIN projects p8_ ON p7_.project_id = p8_.id WHERE w2_.year = 2026 AND p8_.id = 11 GROUP BY w2_.id ORDER BY w2_.id DESC;

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.name AS name_5,
  t0.surname AS surname_6,
  t0.login_refused AS login_refused_7,
  t0.login_refused_message AS login_refused_message_8,
  t0.invisible_since AS invisible_since_9,
  t0.is_password_updated_at AS is_password_updated_at_10,
  t0.news_last_seen_at AS news_last_seen_at_11,
  t0.idle_timer_timeout AS idle_timer_timeout_12,
  t0.notification_preferences AS notification_preferences_13,
  t0.email_signature AS email_signature_14,
  t15.id AS id_16,
  t15.name AS name_17,
  t15.surname AS surname_18,
  t15.entry_at AS entry_at_19,
  t15.exit_at AS exit_at_20,
  t15.birthday_at AS birthday_at_21,
  t15.slug AS slug_22,
  t15.daily_work_time AS daily_work_time_23,
  t15.cost_per_hour AS cost_per_hour_24,
  t15.personal_id AS personal_id_25,
  t15.created_at AS created_at_26,
  t15.phone_number AS phone_number_27,
  t15.uiid AS uiid_28,
  t15.profile_image AS profile_image_29,
  t15.email AS email_30,
  t15.user_id AS user_id_31,
  t0.user_position_id AS user_position_id_32
FROM
  user t0
  LEFT JOIN worker t15 ON t15.user_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.name AS name_5, t0.surname AS surname_6, t0.login_refused AS login_refused_7, t0.login_refused_message AS login_refused_message_8, t0.invisible_since AS invisible_since_9, t0.is_password_updated_at AS is_password_updated_at_10, t0.news_last_seen_at AS news_last_seen_at_11, t0.idle_timer_timeout AS idle_timer_timeout_12, t0.notification_preferences AS notification_preferences_13, t0.email_signature AS email_signature_14, t15.id AS id_16, t15.name AS name_17, t15.surname AS surname_18, t15.entry_at AS entry_at_19, t15.exit_at AS exit_at_20, t15.birthday_at AS birthday_at_21, t15.slug AS slug_22, t15.daily_work_time AS daily_work_time_23, t15.cost_per_hour AS cost_per_hour_24, t15.personal_id AS personal_id_25, t15.created_at AS created_at_26, t15.phone_number AS phone_number_27, t15.uiid AS uiid_28, t15.profile_image AS profile_image_29, t15.email AS email_30, t15.user_id AS user_id_31, t0.user_position_id AS user_position_id_32 FROM user t0 LEFT JOIN worker t15 ON t15.user_id = t0.id WHERE t0.id = 8;

SELECT
  t0.id AS id_1,
  t0.absence AS absence_2,
  t0.absence_short_key AS absence_short_key_3,
  t0.cost_calculate AS cost_calculate_4,
  t0.absence_color AS absence_color_5,
  t0.absence_bg_color AS absence_bg_color_6,
  t0.absence_br_color AS absence_br_color_7,
  t0.absence_icon AS absence_icon_8,
  t0.absence_color_hex AS absence_color_hex_9
FROM
  timesheet_status t0

SELECT t0.id AS id_1, t0.absence AS absence_2, t0.absence_short_key AS absence_short_key_3, t0.cost_calculate AS cost_calculate_4, t0.absence_color AS absence_color_5, t0.absence_bg_color AS absence_bg_color_6, t0.absence_br_color AS absence_br_color_7, t0.absence_icon AS absence_icon_8, t0.absence_color_hex AS absence_color_hex_9 FROM timesheet_status t0;