http://romon-erp.com/api/timesheet/add-time-v2/48/1219/4 Return to referer URL

Query Metrics

53 Database Queries
23 Different statements
194.97 ms Query time
33 Invalid entities

Queries

Group similar statements

# Time Info
1 0.77 ms
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.idle_timer_timeout AS idle_timer_timeout_11, t12.id AS id_13, t12.name AS name_14, t12.surname AS surname_15, t12.entry_at AS entry_at_16, t12.exit_at AS exit_at_17, t12.birthday_at AS birthday_at_18, t12.slug AS slug_19, t12.daily_work_time AS daily_work_time_20, t12.cost_per_hour AS cost_per_hour_21, t12.personal_id AS personal_id_22, t12.created_at AS created_at_23, t12.phone_number AS phone_number_24, t12.uiid AS uiid_25, t12.profile_image AS profile_image_26, t12.user_id AS user_id_27, t0.user_position_id AS user_position_id_28 FROM user t0 LEFT JOIN worker t12 ON t12.user_id = t0.id WHERE t0.id = ?
Parameters:
[
  8
]
2 0.51 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.start_at AS start_at_3, t0.end_at AS end_at_4, t0.created_at AS created_at_5, t0.project_id AS project_id_6, t0.qr_code AS qr_code_7, t0.address AS address_8, t0.longitude AS longitude_9, t0.latitude AS latitude_10, t0.scan_distance AS scan_distance_11, t0.reward_time AS reward_time_12, t0.work_pause AS work_pause_13, t0.working_time_start AS working_time_start_14, t0.working_time_stop AS working_time_stop_15, t0.code_postal AS code_postal_16, t0.town AS town_17, t0.is_archived AS is_archived_18, t0.is_recycle AS is_recycle_19, t0.owner_id AS owner_id_20, t0.country_id AS country_id_21, t0.invoice_type_id AS invoice_type_id_22, t23.id AS id_24, t23.material_budget AS material_budget_25, t23.timesheet_budget AS timesheet_budget_26, t23.target_profit AS target_profit_27, t23.project_id AS project_id_28 FROM projects t0 LEFT JOIN project_settings t23 ON t23.project_id = t0.id WHERE t0.id = ? LIMIT 1
Parameters:
[
  "48"
]
3 0.33 ms
SELECT t0.id AS id_1, t0.project_id AS project_id_2, t0.branch_id AS branch_id_3 FROM project_branches t0 WHERE t0.project_id IN (?)
Parameters:
[
  48
]
4 0.31 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.color AS color_3 FROM project_status t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
  "in process"
]
5 0.23 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.created_at AS created_at_3, t0.branch_location_id AS branch_location_id_4 FROM branches t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
  "4"
]
6 0.35 ms
SELECT t0.id AS id_1, t0.order_nr AS order_nr_2, t0.order_description AS order_description_3, t0.order_prise AS order_prise_4, t0.order_status AS order_status_5, t0.should_end_at AS should_end_at_6, t0.is_end_at AS is_end_at_7, t0.hourly_rate AS hourly_rate_8, t0.order_at AS order_at_9, t0.project_owner_order_nr AS project_owner_order_nr_10, t0.hours_spent AS hours_spent_11, t0.cost_spent AS cost_spent_12, t0.material_budget_as_percent AS material_budget_as_percent_13, t0.timesheet_budget_as_percent AS timesheet_budget_as_percent_14, t0.target_profit_as_percent AS target_profit_as_percent_15, t0.project_id AS project_id_16, t0.contact_person_id AS contact_person_id_17, t0.author_id AS author_id_18, t0.invoice_type_id AS invoice_type_id_19, t0.order_lead_id AS order_lead_id_20, t0.order_primary_lead_id AS order_primary_lead_id_21, t0.order_branch_id AS order_branch_id_22, t0.branch_departement_id AS branch_departement_id_23 FROM project_orders t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
  "1219"
]
7 0.39 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.level AS level_3, t0.description AS description_4, t0.selectable AS selectable_5, t0.access_type_id AS access_type_id_6 FROM access_roles t0 INNER JOIN user_access_roles ON t0.id = user_access_roles.access_roles_id WHERE user_access_roles.user_id = ?
Parameters:
[
  8
]
8 0.26 ms
SELECT t0.id AS id_1, t0.name AS name_2 FROM access_types t0 WHERE t0.id = ?
Parameters:
[
  1
]
9 0.24 ms
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
Parameters:
[]
10 0.26 ms
SELECT t0.id AS id_1, t0.entry_at AS entry_at_2, t0.exit_at AS exit_at_3, t0.created_at AS created_at_4, t0.guest AS guest_5, t0.is_kpi_responsible AS is_kpi_responsible_6, t0.termination_reason AS termination_reason_7, t0.worker_id AS worker_id_8, t0.customer_id AS customer_id_9, t0.user_id AS user_id_10 FROM worker_activities t0 WHERE t0.id IN (?)
Parameters:
[
  316
]
11 0.33 ms
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
Parameters:
[]
12 0.27 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.surname AS surname_3, t0.entry_at AS entry_at_4, t0.exit_at AS exit_at_5, t0.birthday_at AS birthday_at_6, t0.slug AS slug_7, t0.daily_work_time AS daily_work_time_8, t0.cost_per_hour AS cost_per_hour_9, t0.personal_id AS personal_id_10, t0.created_at AS created_at_11, t0.phone_number AS phone_number_12, t0.uiid AS uiid_13, t0.profile_image AS profile_image_14, t0.user_id AS user_id_15 FROM worker t0 WHERE t0.id = ?
Parameters:
[
  388
]
13 2.34 ms
SELECT t0.id AS id_1, t0.year AS year_2, t0.created_at AS created_at_3, t0.transformed_at AS transformed_at_4, t0.m1_d1 AS m1_d1_5, t0.m1_d2 AS m1_d2_6, t0.m1_d3 AS m1_d3_7, t0.m1_d4 AS m1_d4_8, t0.m1_d5 AS m1_d5_9, t0.m1_d6 AS m1_d6_10, t0.m1_d7 AS m1_d7_11, t0.m1_d8 AS m1_d8_12, t0.m1_d9 AS m1_d9_13, t0.m1_d10 AS m1_d10_14, t0.m1_d11 AS m1_d11_15, t0.m1_d12 AS m1_d12_16, t0.m1_d13 AS m1_d13_17, t0.m1_d14 AS m1_d14_18, t0.m1_d15 AS m1_d15_19, t0.m1_d16 AS m1_d16_20, t0.m1_d17 AS m1_d17_21, t0.m1_d18 AS m1_d18_22, t0.m1_d19 AS m1_d19_23, t0.m1_d20 AS m1_d20_24, t0.m1_d21 AS m1_d21_25, t0.m1_d22 AS m1_d22_26, t0.m1_d23 AS m1_d23_27, t0.m1_d24 AS m1_d24_28, t0.m1_d25 AS m1_d25_29, t0.m1_d26 AS m1_d26_30, t0.m1_d27 AS m1_d27_31, t0.m1_d28 AS m1_d28_32, t0.m1_d29 AS m1_d29_33, t0.m1_d30 AS m1_d30_34, t0.m1_d31 AS m1_d31_35, t0.m2_d1 AS m2_d1_36, t0.m2_d2 AS m2_d2_37, t0.m2_d3 AS m2_d3_38, t0.m2_d4 AS m2_d4_39, t0.m2_d5 AS m2_d5_40, t0.m2_d6 AS m2_d6_41, t0.m2_d7 AS m2_d7_42, t0.m2_d8 AS m2_d8_43, t0.m2_d9 AS m2_d9_44, t0.m2_d10 AS m2_d10_45, t0.m2_d11 AS m2_d11_46, t0.m2_d12 AS m2_d12_47, t0.m2_d13 AS m2_d13_48, t0.m2_d14 AS m2_d14_49, t0.m2_d15 AS m2_d15_50, t0.m2_d16 AS m2_d16_51, t0.m2_d17 AS m2_d17_52, t0.m2_d18 AS m2_d18_53, t0.m2_d19 AS m2_d19_54, t0.m2_d20 AS m2_d20_55, t0.m2_d21 AS m2_d21_56, t0.m2_d22 AS m2_d22_57, t0.m2_d23 AS m2_d23_58, t0.m2_d24 AS m2_d24_59, t0.m2_d25 AS m2_d25_60, t0.m2_d26 AS m2_d26_61, t0.m2_d27 AS m2_d27_62, t0.m2_d28 AS m2_d28_63, t0.m2_d29 AS m2_d29_64, t0.m2_d30 AS m2_d30_65, t0.m2_d31 AS m2_d31_66, t0.m3_d1 AS m3_d1_67, t0.m3_d2 AS m3_d2_68, t0.m3_d3 AS m3_d3_69, t0.m3_d4 AS m3_d4_70, t0.m3_d5 AS m3_d5_71, t0.m3_d6 AS m3_d6_72, t0.m3_d7 AS m3_d7_73, t0.m3_d8 AS m3_d8_74, t0.m3_d9 AS m3_d9_75, t0.m3_d10 AS m3_d10_76, t0.m3_d11 AS m3_d11_77, t0.m3_d12 AS m3_d12_78, t0.m3_d13 AS m3_d13_79, t0.m3_d14 AS m3_d14_80, t0.m3_d15 AS m3_d15_81, t0.m3_d16 AS m3_d16_82, t0.m3_d17 AS m3_d17_83, t0.m3_d18 AS m3_d18_84, t0.m3_d19 AS m3_d19_85, t0.m3_d20 AS m3_d20_86, t0.m3_d21 AS m3_d21_87, t0.m3_d22 AS m3_d22_88, t0.m3_d23 AS m3_d23_89, t0.m3_d24 AS m3_d24_90, t0.m3_d25 AS m3_d25_91, t0.m3_d26 AS m3_d26_92, t0.m3_d27 AS m3_d27_93, t0.m3_d28 AS m3_d28_94, t0.m3_d29 AS m3_d29_95, t0.m3_d30 AS m3_d30_96, t0.m3_d31 AS m3_d31_97, t0.m4_d1 AS m4_d1_98, t0.m4_d2 AS m4_d2_99, t0.m4_d3 AS m4_d3_100, t0.m4_d4 AS m4_d4_101, t0.m4_d5 AS m4_d5_102, t0.m4_d6 AS m4_d6_103, t0.m4_d7 AS m4_d7_104, t0.m4_d8 AS m4_d8_105, t0.m4_d9 AS m4_d9_106, t0.m4_d10 AS m4_d10_107, t0.m4_d11 AS m4_d11_108, t0.m4_d12 AS m4_d12_109, t0.m4_d13 AS m4_d13_110, t0.m4_d14 AS m4_d14_111, t0.m4_d15 AS m4_d15_112, t0.m4_d16 AS m4_d16_113, t0.m4_d17 AS m4_d17_114, t0.m4_d18 AS m4_d18_115, t0.m4_d19 AS m4_d19_116, t0.m4_d20 AS m4_d20_117, t0.m4_d21 AS m4_d21_118, t0.m4_d22 AS m4_d22_119, t0.m4_d23 AS m4_d23_120, t0.m4_d24 AS m4_d24_121, t0.m4_d25 AS m4_d25_122, t0.m4_d26 AS m4_d26_123, t0.m4_d27 AS m4_d27_124, t0.m4_d28 AS m4_d28_125, t0.m4_d29 AS m4_d29_126, t0.m4_d30 AS m4_d30_127, t0.m4_d31 AS m4_d31_128, t0.m5_d1 AS m5_d1_129, t0.m5_d2 AS m5_d2_130, t0.m5_d3 AS m5_d3_131, t0.m5_d4 AS m5_d4_132, t0.m5_d5 AS m5_d5_133, t0.m5_d6 AS m5_d6_134, t0.m5_d7 AS m5_d7_135, t0.m5_d8 AS m5_d8_136, t0.m5_d9 AS m5_d9_137, t0.m5_d10 AS m5_d10_138, t0.m5_d11 AS m5_d11_139, t0.m5_d12 AS m5_d12_140, t0.m5_d13 AS m5_d13_141, t0.m5_d14 AS m5_d14_142, t0.m5_d15 AS m5_d15_143, t0.m5_d16 AS m5_d16_144, t0.m5_d17 AS m5_d17_145, t0.m5_d18 AS m5_d18_146, t0.m5_d19 AS m5_d19_147, t0.m5_d20 AS m5_d20_148, t0.m5_d21 AS m5_d21_149, t0.m5_d22 AS m5_d22_150, t0.m5_d23 AS m5_d23_151, t0.m5_d24 AS m5_d24_152, t0.m5_d25 AS m5_d25_153, t0.m5_d26 AS m5_d26_154, t0.m5_d27 AS m5_d27_155, t0.m5_d28 AS m5_d28_156, t0.m5_d29 AS m5_d29_157, t0.m5_d30 AS m5_d30_158, t0.m5_d31 AS m5_d31_159, t0.m6_d1 AS m6_d1_160, t0.m6_d2 AS m6_d2_161, t0.m6_d3 AS m6_d3_162, t0.m6_d4 AS m6_d4_163, t0.m6_d5 AS m6_d5_164, t0.m6_d6 AS m6_d6_165, t0.m6_d7 AS m6_d7_166, t0.m6_d8 AS m6_d8_167, t0.m6_d9 AS m6_d9_168, t0.m6_d10 AS m6_d10_169, t0.m6_d11 AS m6_d11_170, t0.m6_d12 AS m6_d12_171, t0.m6_d13 AS m6_d13_172, t0.m6_d14 AS m6_d14_173, t0.m6_d15 AS m6_d15_174, t0.m6_d16 AS m6_d16_175, t0.m6_d17 AS m6_d17_176, t0.m6_d18 AS m6_d18_177, t0.m6_d19 AS m6_d19_178, t0.m6_d20 AS m6_d20_179, t0.m6_d21 AS m6_d21_180, t0.m6_d22 AS m6_d22_181, t0.m6_d23 AS m6_d23_182, t0.m6_d24 AS m6_d24_183, t0.m6_d25 AS m6_d25_184, t0.m6_d26 AS m6_d26_185, t0.m6_d27 AS m6_d27_186, t0.m6_d28 AS m6_d28_187, t0.m6_d29 AS m6_d29_188, t0.m6_d30 AS m6_d30_189, t0.m6_d31 AS m6_d31_190, t0.m7_d1 AS m7_d1_191, t0.m7_d2 AS m7_d2_192, t0.m7_d3 AS m7_d3_193, t0.m7_d4 AS m7_d4_194, t0.m7_d5 AS m7_d5_195, t0.m7_d6 AS m7_d6_196, t0.m7_d7 AS m7_d7_197, t0.m7_d8 AS m7_d8_198, t0.m7_d9 AS m7_d9_199, t0.m7_d10 AS m7_d10_200, t0.m7_d11 AS m7_d11_201, t0.m7_d12 AS m7_d12_202, t0.m7_d13 AS m7_d13_203, t0.m7_d14 AS m7_d14_204, t0.m7_d15 AS m7_d15_205, t0.m7_d16 AS m7_d16_206, t0.m7_d17 AS m7_d17_207, t0.m7_d18 AS m7_d18_208, t0.m7_d19 AS m7_d19_209, t0.m7_d20 AS m7_d20_210, t0.m7_d21 AS m7_d21_211, t0.m7_d22 AS m7_d22_212, t0.m7_d23 AS m7_d23_213, t0.m7_d24 AS m7_d24_214, t0.m7_d25 AS m7_d25_215, t0.m7_d26 AS m7_d26_216, t0.m7_d27 AS m7_d27_217, t0.m7_d28 AS m7_d28_218, t0.m7_d29 AS m7_d29_219, t0.m7_d30 AS m7_d30_220, t0.m7_d31 AS m7_d31_221, t0.m8_d1 AS m8_d1_222, t0.m8_d2 AS m8_d2_223, t0.m8_d3 AS m8_d3_224, t0.m8_d4 AS m8_d4_225, t0.m8_d5 AS m8_d5_226, t0.m8_d6 AS m8_d6_227, t0.m8_d7 AS m8_d7_228, t0.m8_d8 AS m8_d8_229, t0.m8_d9 AS m8_d9_230, t0.m8_d10 AS m8_d10_231, t0.m8_d11 AS m8_d11_232, t0.m8_d12 AS m8_d12_233, t0.m8_d13 AS m8_d13_234, t0.m8_d14 AS m8_d14_235, t0.m8_d15 AS m8_d15_236, t0.m8_d16 AS m8_d16_237, t0.m8_d17 AS m8_d17_238, t0.m8_d18 AS m8_d18_239, t0.m8_d19 AS m8_d19_240, t0.m8_d20 AS m8_d20_241, t0.m8_d21 AS m8_d21_242, t0.m8_d22 AS m8_d22_243, t0.m8_d23 AS m8_d23_244, t0.m8_d24 AS m8_d24_245, t0.m8_d25 AS m8_d25_246, t0.m8_d26 AS m8_d26_247, t0.m8_d27 AS m8_d27_248, t0.m8_d28 AS m8_d28_249, t0.m8_d29 AS m8_d29_250, t0.m8_d30 AS m8_d30_251, t0.m8_d31 AS m8_d31_252, t0.m9_d1 AS m9_d1_253, t0.m9_d2 AS m9_d2_254, t0.m9_d3 AS m9_d3_255, t0.m9_d4 AS m9_d4_256, t0.m9_d5 AS m9_d5_257, t0.m9_d6 AS m9_d6_258, t0.m9_d7 AS m9_d7_259, t0.m9_d8 AS m9_d8_260, t0.m9_d9 AS m9_d9_261, t0.m9_d10 AS m9_d10_262, t0.m9_d11 AS m9_d11_263, t0.m9_d12 AS m9_d12_264, t0.m9_d13 AS m9_d13_265, t0.m9_d14 AS m9_d14_266, t0.m9_d15 AS m9_d15_267, t0.m9_d16 AS m9_d16_268, t0.m9_d17 AS m9_d17_269, t0.m9_d18 AS m9_d18_270, t0.m9_d19 AS m9_d19_271, t0.m9_d20 AS m9_d20_272, t0.m9_d21 AS m9_d21_273, t0.m9_d22 AS m9_d22_274, t0.m9_d23 AS m9_d23_275, t0.m9_d24 AS m9_d24_276, t0.m9_d25 AS m9_d25_277, t0.m9_d26 AS m9_d26_278, t0.m9_d27 AS m9_d27_279, t0.m9_d28 AS m9_d28_280, t0.m9_d29 AS m9_d29_281, t0.m9_d30 AS m9_d30_282, t0.m9_d31 AS m9_d31_283, t0.m10_d1 AS m10_d1_284, t0.m10_d2 AS m10_d2_285, t0.m10_d3 AS m10_d3_286, t0.m10_d4 AS m10_d4_287, t0.m10_d5 AS m10_d5_288, t0.m10_d6 AS m10_d6_289, t0.m10_d7 AS m10_d7_290, t0.m10_d8 AS m10_d8_291, t0.m10_d9 AS m10_d9_292, t0.m10_d10 AS m10_d10_293, t0.m10_d11 AS m10_d11_294, t0.m10_d12 AS m10_d12_295, t0.m10_d13 AS m10_d13_296, t0.m10_d14 AS m10_d14_297, t0.m10_d15 AS m10_d15_298, t0.m10_d16 AS m10_d16_299, t0.m10_d17 AS m10_d17_300, t0.m10_d18 AS m10_d18_301, t0.m10_d19 AS m10_d19_302, t0.m10_d20 AS m10_d20_303, t0.m10_d21 AS m10_d21_304, t0.m10_d22 AS m10_d22_305, t0.m10_d23 AS m10_d23_306, t0.m10_d24 AS m10_d24_307, t0.m10_d25 AS m10_d25_308, t0.m10_d26 AS m10_d26_309, t0.m10_d27 AS m10_d27_310, t0.m10_d28 AS m10_d28_311, t0.m10_d29 AS m10_d29_312, t0.m10_d30 AS m10_d30_313, t0.m10_d31 AS m10_d31_314, t0.m11_d1 AS m11_d1_315, t0.m11_d2 AS m11_d2_316, t0.m11_d3 AS m11_d3_317, t0.m11_d4 AS m11_d4_318, t0.m11_d5 AS m11_d5_319, t0.m11_d6 AS m11_d6_320, t0.m11_d7 AS m11_d7_321, t0.m11_d8 AS m11_d8_322, t0.m11_d9 AS m11_d9_323, t0.m11_d10 AS m11_d10_324, t0.m11_d11 AS m11_d11_325, t0.m11_d12 AS m11_d12_326, t0.m11_d13 AS m11_d13_327, t0.m11_d14 AS m11_d14_328, t0.m11_d15 AS m11_d15_329, t0.m11_d16 AS m11_d16_330, t0.m11_d17 AS m11_d17_331, t0.m11_d18 AS m11_d18_332, t0.m11_d19 AS m11_d19_333, t0.m11_d20 AS m11_d20_334, t0.m11_d21 AS m11_d21_335, t0.m11_d22 AS m11_d22_336, t0.m11_d23 AS m11_d23_337, t0.m11_d24 AS m11_d24_338, t0.m11_d25 AS m11_d25_339, t0.m11_d26 AS m11_d26_340, t0.m11_d27 AS m11_d27_341, t0.m11_d28 AS m11_d28_342, t0.m11_d29 AS m11_d29_343, t0.m11_d30 AS m11_d30_344, t0.m11_d31 AS m11_d31_345, t0.m12_d1 AS m12_d1_346, t0.m12_d2 AS m12_d2_347, t0.m12_d3 AS m12_d3_348, t0.m12_d4 AS m12_d4_349, t0.m12_d5 AS m12_d5_350, t0.m12_d6 AS m12_d6_351, t0.m12_d7 AS m12_d7_352, t0.m12_d8 AS m12_d8_353, t0.m12_d9 AS m12_d9_354, t0.m12_d10 AS m12_d10_355, t0.m12_d11 AS m12_d11_356, t0.m12_d12 AS m12_d12_357, t0.m12_d13 AS m12_d13_358, t0.m12_d14 AS m12_d14_359, t0.m12_d15 AS m12_d15_360, t0.m12_d16 AS m12_d16_361, t0.m12_d17 AS m12_d17_362, t0.m12_d18 AS m12_d18_363, t0.m12_d19 AS m12_d19_364, t0.m12_d20 AS m12_d20_365, t0.m12_d21 AS m12_d21_366, t0.m12_d22 AS m12_d22_367, t0.m12_d23 AS m12_d23_368, t0.m12_d24 AS m12_d24_369, t0.m12_d25 AS m12_d25_370, t0.m12_d26 AS m12_d26_371, t0.m12_d27 AS m12_d27_372, t0.m12_d28 AS m12_d28_373, t0.m12_d29 AS m12_d29_374, t0.m12_d30 AS m12_d30_375, t0.m12_d31 AS m12_d31_376, t0.worker_a_id AS worker_a_id_377, t0.worker_activity_id AS worker_activity_id_378, t379.id AS id_380, t379.history AS history_381, t379.created_at AS created_at_382, t379.worker_timesheet_id AS worker_timesheet_id_383 FROM worker_timesheet t0 LEFT JOIN worker_timesheet_histories t379 ON t379.worker_timesheet_id = t0.id WHERE t0.worker_activity_id = ?
Parameters:
[
  316
]
14 0.44 ms
SELECT t0.id AS id_1, t0.order_nr AS order_nr_2, t0.order_description AS order_description_3, t0.order_prise AS order_prise_4, t0.order_status AS order_status_5, t0.should_end_at AS should_end_at_6, t0.is_end_at AS is_end_at_7, t0.hourly_rate AS hourly_rate_8, t0.order_at AS order_at_9, t0.project_owner_order_nr AS project_owner_order_nr_10, t0.hours_spent AS hours_spent_11, t0.cost_spent AS cost_spent_12, t0.material_budget_as_percent AS material_budget_as_percent_13, t0.timesheet_budget_as_percent AS timesheet_budget_as_percent_14, t0.target_profit_as_percent AS target_profit_as_percent_15, t0.project_id AS project_id_16, t0.contact_person_id AS contact_person_id_17, t0.author_id AS author_id_18, t0.invoice_type_id AS invoice_type_id_19, t0.order_lead_id AS order_lead_id_20, t0.order_primary_lead_id AS order_primary_lead_id_21, t0.order_branch_id AS order_branch_id_22, t0.branch_departement_id AS branch_departement_id_23 FROM project_orders t0 INNER JOIN project_orders_worker_activities ON t0.id = project_orders_worker_activities.project_orders_id WHERE project_orders_worker_activities.worker_activities_id = ?
Parameters:
[
  316
]
15 0.32 ms
SELECT t0.id AS id_1, t0.start_at AS start_at_2, t0.end_at AS end_at_3, t0.created_at AS created_at_4, t0.forcibly_completed AS forcibly_completed_5, t0.cost_per_hour AS cost_per_hour_6, t0.can_app_check_anywhere AS can_app_check_anywhere_7, t0.worker_id AS worker_id_8, t0.project_id AS project_id_9, t0.worker_activity_id AS worker_activity_id_10 FROM worker_in_project t0 WHERE t0.worker_activity_id = ? ORDER BY t0.id DESC
Parameters:
[
  316
]
16 0.28 ms
SELECT t0.id AS id_1, t0.start_at AS start_at_2, t0.end_at AS end_at_3, t0.created_at AS created_at_4, t0.customer_id AS customer_id_5, t0.project_id AS project_id_6 FROM project_stakeholders t0 WHERE t0.id = ?
Parameters:
[
  147
]
17 0.24 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.color AS color_3 FROM project_status t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
  "in process"
]
18 0.21 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.color AS color_3 FROM project_status t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
  "in process"
]
19 0.20 ms
SELECT t0.id AS id_1, t0.start_at AS start_at_2, t0.end_at AS end_at_3, t0.created_at AS created_at_4, t0.customer_id AS customer_id_5, t0.project_id AS project_id_6 FROM project_stakeholders t0 WHERE t0.id = ?
Parameters:
[
  170
]
20 0.31 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.start_at AS start_at_3, t0.end_at AS end_at_4, t0.created_at AS created_at_5, t0.project_id AS project_id_6, t0.qr_code AS qr_code_7, t0.address AS address_8, t0.longitude AS longitude_9, t0.latitude AS latitude_10, t0.scan_distance AS scan_distance_11, t0.reward_time AS reward_time_12, t0.work_pause AS work_pause_13, t0.working_time_start AS working_time_start_14, t0.working_time_stop AS working_time_stop_15, t0.code_postal AS code_postal_16, t0.town AS town_17, t0.is_archived AS is_archived_18, t0.is_recycle AS is_recycle_19, t0.owner_id AS owner_id_20, t0.country_id AS country_id_21, t0.invoice_type_id AS invoice_type_id_22, t23.id AS id_24, t23.material_budget AS material_budget_25, t23.timesheet_budget AS timesheet_budget_26, t23.target_profit AS target_profit_27, t23.project_id AS project_id_28 FROM projects t0 LEFT JOIN project_settings t23 ON t23.project_id = t0.id WHERE t0.id = ?
Parameters:
[
  58
]
21 0.24 ms
SELECT t0.id AS id_1, t0.project_id AS project_id_2, t0.branch_id AS branch_id_3 FROM project_branches t0 WHERE t0.project_id IN (?)
Parameters:
[
  58
]
22 0.19 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.color AS color_3 FROM project_status t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
  "in process"
]
23 0.19 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.color AS color_3 FROM project_status t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
  "in process"
]
24 0.20 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.color AS color_3 FROM project_status t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
  "in process"
]
25 0.20 ms
SELECT t0.id AS id_1, t0.start_at AS start_at_2, t0.end_at AS end_at_3, t0.created_at AS created_at_4, t0.customer_id AS customer_id_5, t0.project_id AS project_id_6 FROM project_stakeholders t0 WHERE t0.id = ?
Parameters:
[
  152
]
26 0.26 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.start_at AS start_at_3, t0.end_at AS end_at_4, t0.created_at AS created_at_5, t0.project_id AS project_id_6, t0.qr_code AS qr_code_7, t0.address AS address_8, t0.longitude AS longitude_9, t0.latitude AS latitude_10, t0.scan_distance AS scan_distance_11, t0.reward_time AS reward_time_12, t0.work_pause AS work_pause_13, t0.working_time_start AS working_time_start_14, t0.working_time_stop AS working_time_stop_15, t0.code_postal AS code_postal_16, t0.town AS town_17, t0.is_archived AS is_archived_18, t0.is_recycle AS is_recycle_19, t0.owner_id AS owner_id_20, t0.country_id AS country_id_21, t0.invoice_type_id AS invoice_type_id_22, t23.id AS id_24, t23.material_budget AS material_budget_25, t23.timesheet_budget AS timesheet_budget_26, t23.target_profit AS target_profit_27, t23.project_id AS project_id_28 FROM projects t0 LEFT JOIN project_settings t23 ON t23.project_id = t0.id WHERE t0.id = ?
Parameters:
[
  53
]
27 0.25 ms
SELECT t0.id AS id_1, t0.project_id AS project_id_2, t0.branch_id AS branch_id_3 FROM project_branches t0 WHERE t0.project_id IN (?)
Parameters:
[
  53
]
28 0.21 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.color AS color_3 FROM project_status t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
  "in process"
]
29 0.19 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.color AS color_3 FROM project_status t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
  "in process"
]
30 0.21 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.color AS color_3 FROM project_status t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
  "in process"
]
31 0.19 ms
SELECT t0.id AS id_1, t0.start_at AS start_at_2, t0.end_at AS end_at_3, t0.created_at AS created_at_4, t0.customer_id AS customer_id_5, t0.project_id AS project_id_6 FROM project_stakeholders t0 WHERE t0.id = ?
Parameters:
[
  15
]
32 0.26 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.start_at AS start_at_3, t0.end_at AS end_at_4, t0.created_at AS created_at_5, t0.project_id AS project_id_6, t0.qr_code AS qr_code_7, t0.address AS address_8, t0.longitude AS longitude_9, t0.latitude AS latitude_10, t0.scan_distance AS scan_distance_11, t0.reward_time AS reward_time_12, t0.work_pause AS work_pause_13, t0.working_time_start AS working_time_start_14, t0.working_time_stop AS working_time_stop_15, t0.code_postal AS code_postal_16, t0.town AS town_17, t0.is_archived AS is_archived_18, t0.is_recycle AS is_recycle_19, t0.owner_id AS owner_id_20, t0.country_id AS country_id_21, t0.invoice_type_id AS invoice_type_id_22, t23.id AS id_24, t23.material_budget AS material_budget_25, t23.timesheet_budget AS timesheet_budget_26, t23.target_profit AS target_profit_27, t23.project_id AS project_id_28 FROM projects t0 LEFT JOIN project_settings t23 ON t23.project_id = t0.id WHERE t0.id = ?
Parameters:
[
  16
]
33 0.22 ms
SELECT t0.id AS id_1, t0.project_id AS project_id_2, t0.branch_id AS branch_id_3 FROM project_branches t0 WHERE t0.project_id IN (?)
Parameters:
[
  16
]
34 0.21 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.color AS color_3 FROM project_status t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
  "in process"
]
35 0.20 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.color AS color_3 FROM project_status t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
  "in process"
]
36 0.17 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.color AS color_3 FROM project_status t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
  "in process"
]
37 0.19 ms
SELECT t0.id AS id_1, t0.start_at AS start_at_2, t0.end_at AS end_at_3, t0.created_at AS created_at_4, t0.customer_id AS customer_id_5, t0.project_id AS project_id_6 FROM project_stakeholders t0 WHERE t0.id = ?
Parameters:
[
  136
]
38 0.28 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.start_at AS start_at_3, t0.end_at AS end_at_4, t0.created_at AS created_at_5, t0.project_id AS project_id_6, t0.qr_code AS qr_code_7, t0.address AS address_8, t0.longitude AS longitude_9, t0.latitude AS latitude_10, t0.scan_distance AS scan_distance_11, t0.reward_time AS reward_time_12, t0.work_pause AS work_pause_13, t0.working_time_start AS working_time_start_14, t0.working_time_stop AS working_time_stop_15, t0.code_postal AS code_postal_16, t0.town AS town_17, t0.is_archived AS is_archived_18, t0.is_recycle AS is_recycle_19, t0.owner_id AS owner_id_20, t0.country_id AS country_id_21, t0.invoice_type_id AS invoice_type_id_22, t23.id AS id_24, t23.material_budget AS material_budget_25, t23.timesheet_budget AS timesheet_budget_26, t23.target_profit AS target_profit_27, t23.project_id AS project_id_28 FROM projects t0 LEFT JOIN project_settings t23 ON t23.project_id = t0.id WHERE t0.id = ?
Parameters:
[
  47
]
39 0.22 ms
SELECT t0.id AS id_1, t0.project_id AS project_id_2, t0.branch_id AS branch_id_3 FROM project_branches t0 WHERE t0.project_id IN (?)
Parameters:
[
  47
]
40 0.21 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.color AS color_3 FROM project_status t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
  "in process"
]
41 0.22 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.color AS color_3 FROM project_status t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
  "in process"
]
42 0.18 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.color AS color_3 FROM project_status t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
  "in process"
]
43 0.11 ms
"START TRANSACTION"
Parameters:
[]
44 1.28 ms
UPDATE worker_timesheet SET m11_d4 = ? WHERE id = ?
Parameters:
[
  "{"info":{"role":3},"projects":[{"final":{"status":{"date":"2025-12-01 00:15:03","role":"","reason":"created","confirmed":true,"approved_by":"J. Krawczynski"},"crushable":[],"cost_per_hour":50.0},"roles":[{"role":3,"orders":{"1182":{"order":"2025-0449","branches":{"4":{"date":"2025-12-01 00:15:03","time":5.0,"adder":"J. Krawczynski","branch":"Werkstatt"}}}}}],"project":47,"orders_total":{"1182":5.0}},{"final":{"status":{"date":"2025-12-01 00:15:16","role":"","reason":"created","confirmed":true,"approved_by":"J. Krawczynski"},"crushable":[],"cost_per_hour":50.0},"roles":[{"role":3,"orders":{"53":{"order":"1060-23-0011","branches":{"4":{"date":"2025-12-01 00:15:16","time":3.25,"adder":"J. Krawczynski","branch":"Werkstatt"}}}}}],"project":16,"orders_total":{"53":3.25}},{"roles":[{"role":3,"orders":{"1219":{"order":"1046-0006","branches":{"4":{"branch":"Werkstatt","time":3.0,"date":"2025-12-01 00:16:34","adder":"J. Krawczynski"}}}}}],"final":{"status":{"date":"2025-12-01 00:16:34","role":"","confirmed":true,"approved_by":"J. Krawczynski","reason":"created"},"crushable":[],"cost_per_hour":50.0},"project":48,"orders_total":{"1219":3.0}}],"absenceShortKey":"P"}"
  393
]
45 171.53 ms
SELECT t0.id AS id_1, t0.year AS year_2, t0.created_at AS created_at_3, t0.transformed_at AS transformed_at_4, t0.m1_d1 AS m1_d1_5, t0.m1_d2 AS m1_d2_6, t0.m1_d3 AS m1_d3_7, t0.m1_d4 AS m1_d4_8, t0.m1_d5 AS m1_d5_9, t0.m1_d6 AS m1_d6_10, t0.m1_d7 AS m1_d7_11, t0.m1_d8 AS m1_d8_12, t0.m1_d9 AS m1_d9_13, t0.m1_d10 AS m1_d10_14, t0.m1_d11 AS m1_d11_15, t0.m1_d12 AS m1_d12_16, t0.m1_d13 AS m1_d13_17, t0.m1_d14 AS m1_d14_18, t0.m1_d15 AS m1_d15_19, t0.m1_d16 AS m1_d16_20, t0.m1_d17 AS m1_d17_21, t0.m1_d18 AS m1_d18_22, t0.m1_d19 AS m1_d19_23, t0.m1_d20 AS m1_d20_24, t0.m1_d21 AS m1_d21_25, t0.m1_d22 AS m1_d22_26, t0.m1_d23 AS m1_d23_27, t0.m1_d24 AS m1_d24_28, t0.m1_d25 AS m1_d25_29, t0.m1_d26 AS m1_d26_30, t0.m1_d27 AS m1_d27_31, t0.m1_d28 AS m1_d28_32, t0.m1_d29 AS m1_d29_33, t0.m1_d30 AS m1_d30_34, t0.m1_d31 AS m1_d31_35, t0.m2_d1 AS m2_d1_36, t0.m2_d2 AS m2_d2_37, t0.m2_d3 AS m2_d3_38, t0.m2_d4 AS m2_d4_39, t0.m2_d5 AS m2_d5_40, t0.m2_d6 AS m2_d6_41, t0.m2_d7 AS m2_d7_42, t0.m2_d8 AS m2_d8_43, t0.m2_d9 AS m2_d9_44, t0.m2_d10 AS m2_d10_45, t0.m2_d11 AS m2_d11_46, t0.m2_d12 AS m2_d12_47, t0.m2_d13 AS m2_d13_48, t0.m2_d14 AS m2_d14_49, t0.m2_d15 AS m2_d15_50, t0.m2_d16 AS m2_d16_51, t0.m2_d17 AS m2_d17_52, t0.m2_d18 AS m2_d18_53, t0.m2_d19 AS m2_d19_54, t0.m2_d20 AS m2_d20_55, t0.m2_d21 AS m2_d21_56, t0.m2_d22 AS m2_d22_57, t0.m2_d23 AS m2_d23_58, t0.m2_d24 AS m2_d24_59, t0.m2_d25 AS m2_d25_60, t0.m2_d26 AS m2_d26_61, t0.m2_d27 AS m2_d27_62, t0.m2_d28 AS m2_d28_63, t0.m2_d29 AS m2_d29_64, t0.m2_d30 AS m2_d30_65, t0.m2_d31 AS m2_d31_66, t0.m3_d1 AS m3_d1_67, t0.m3_d2 AS m3_d2_68, t0.m3_d3 AS m3_d3_69, t0.m3_d4 AS m3_d4_70, t0.m3_d5 AS m3_d5_71, t0.m3_d6 AS m3_d6_72, t0.m3_d7 AS m3_d7_73, t0.m3_d8 AS m3_d8_74, t0.m3_d9 AS m3_d9_75, t0.m3_d10 AS m3_d10_76, t0.m3_d11 AS m3_d11_77, t0.m3_d12 AS m3_d12_78, t0.m3_d13 AS m3_d13_79, t0.m3_d14 AS m3_d14_80, t0.m3_d15 AS m3_d15_81, t0.m3_d16 AS m3_d16_82, t0.m3_d17 AS m3_d17_83, t0.m3_d18 AS m3_d18_84, t0.m3_d19 AS m3_d19_85, t0.m3_d20 AS m3_d20_86, t0.m3_d21 AS m3_d21_87, t0.m3_d22 AS m3_d22_88, t0.m3_d23 AS m3_d23_89, t0.m3_d24 AS m3_d24_90, t0.m3_d25 AS m3_d25_91, t0.m3_d26 AS m3_d26_92, t0.m3_d27 AS m3_d27_93, t0.m3_d28 AS m3_d28_94, t0.m3_d29 AS m3_d29_95, t0.m3_d30 AS m3_d30_96, t0.m3_d31 AS m3_d31_97, t0.m4_d1 AS m4_d1_98, t0.m4_d2 AS m4_d2_99, t0.m4_d3 AS m4_d3_100, t0.m4_d4 AS m4_d4_101, t0.m4_d5 AS m4_d5_102, t0.m4_d6 AS m4_d6_103, t0.m4_d7 AS m4_d7_104, t0.m4_d8 AS m4_d8_105, t0.m4_d9 AS m4_d9_106, t0.m4_d10 AS m4_d10_107, t0.m4_d11 AS m4_d11_108, t0.m4_d12 AS m4_d12_109, t0.m4_d13 AS m4_d13_110, t0.m4_d14 AS m4_d14_111, t0.m4_d15 AS m4_d15_112, t0.m4_d16 AS m4_d16_113, t0.m4_d17 AS m4_d17_114, t0.m4_d18 AS m4_d18_115, t0.m4_d19 AS m4_d19_116, t0.m4_d20 AS m4_d20_117, t0.m4_d21 AS m4_d21_118, t0.m4_d22 AS m4_d22_119, t0.m4_d23 AS m4_d23_120, t0.m4_d24 AS m4_d24_121, t0.m4_d25 AS m4_d25_122, t0.m4_d26 AS m4_d26_123, t0.m4_d27 AS m4_d27_124, t0.m4_d28 AS m4_d28_125, t0.m4_d29 AS m4_d29_126, t0.m4_d30 AS m4_d30_127, t0.m4_d31 AS m4_d31_128, t0.m5_d1 AS m5_d1_129, t0.m5_d2 AS m5_d2_130, t0.m5_d3 AS m5_d3_131, t0.m5_d4 AS m5_d4_132, t0.m5_d5 AS m5_d5_133, t0.m5_d6 AS m5_d6_134, t0.m5_d7 AS m5_d7_135, t0.m5_d8 AS m5_d8_136, t0.m5_d9 AS m5_d9_137, t0.m5_d10 AS m5_d10_138, t0.m5_d11 AS m5_d11_139, t0.m5_d12 AS m5_d12_140, t0.m5_d13 AS m5_d13_141, t0.m5_d14 AS m5_d14_142, t0.m5_d15 AS m5_d15_143, t0.m5_d16 AS m5_d16_144, t0.m5_d17 AS m5_d17_145, t0.m5_d18 AS m5_d18_146, t0.m5_d19 AS m5_d19_147, t0.m5_d20 AS m5_d20_148, t0.m5_d21 AS m5_d21_149, t0.m5_d22 AS m5_d22_150, t0.m5_d23 AS m5_d23_151, t0.m5_d24 AS m5_d24_152, t0.m5_d25 AS m5_d25_153, t0.m5_d26 AS m5_d26_154, t0.m5_d27 AS m5_d27_155, t0.m5_d28 AS m5_d28_156, t0.m5_d29 AS m5_d29_157, t0.m5_d30 AS m5_d30_158, t0.m5_d31 AS m5_d31_159, t0.m6_d1 AS m6_d1_160, t0.m6_d2 AS m6_d2_161, t0.m6_d3 AS m6_d3_162, t0.m6_d4 AS m6_d4_163, t0.m6_d5 AS m6_d5_164, t0.m6_d6 AS m6_d6_165, t0.m6_d7 AS m6_d7_166, t0.m6_d8 AS m6_d8_167, t0.m6_d9 AS m6_d9_168, t0.m6_d10 AS m6_d10_169, t0.m6_d11 AS m6_d11_170, t0.m6_d12 AS m6_d12_171, t0.m6_d13 AS m6_d13_172, t0.m6_d14 AS m6_d14_173, t0.m6_d15 AS m6_d15_174, t0.m6_d16 AS m6_d16_175, t0.m6_d17 AS m6_d17_176, t0.m6_d18 AS m6_d18_177, t0.m6_d19 AS m6_d19_178, t0.m6_d20 AS m6_d20_179, t0.m6_d21 AS m6_d21_180, t0.m6_d22 AS m6_d22_181, t0.m6_d23 AS m6_d23_182, t0.m6_d24 AS m6_d24_183, t0.m6_d25 AS m6_d25_184, t0.m6_d26 AS m6_d26_185, t0.m6_d27 AS m6_d27_186, t0.m6_d28 AS m6_d28_187, t0.m6_d29 AS m6_d29_188, t0.m6_d30 AS m6_d30_189, t0.m6_d31 AS m6_d31_190, t0.m7_d1 AS m7_d1_191, t0.m7_d2 AS m7_d2_192, t0.m7_d3 AS m7_d3_193, t0.m7_d4 AS m7_d4_194, t0.m7_d5 AS m7_d5_195, t0.m7_d6 AS m7_d6_196, t0.m7_d7 AS m7_d7_197, t0.m7_d8 AS m7_d8_198, t0.m7_d9 AS m7_d9_199, t0.m7_d10 AS m7_d10_200, t0.m7_d11 AS m7_d11_201, t0.m7_d12 AS m7_d12_202, t0.m7_d13 AS m7_d13_203, t0.m7_d14 AS m7_d14_204, t0.m7_d15 AS m7_d15_205, t0.m7_d16 AS m7_d16_206, t0.m7_d17 AS m7_d17_207, t0.m7_d18 AS m7_d18_208, t0.m7_d19 AS m7_d19_209, t0.m7_d20 AS m7_d20_210, t0.m7_d21 AS m7_d21_211, t0.m7_d22 AS m7_d22_212, t0.m7_d23 AS m7_d23_213, t0.m7_d24 AS m7_d24_214, t0.m7_d25 AS m7_d25_215, t0.m7_d26 AS m7_d26_216, t0.m7_d27 AS m7_d27_217, t0.m7_d28 AS m7_d28_218, t0.m7_d29 AS m7_d29_219, t0.m7_d30 AS m7_d30_220, t0.m7_d31 AS m7_d31_221, t0.m8_d1 AS m8_d1_222, t0.m8_d2 AS m8_d2_223, t0.m8_d3 AS m8_d3_224, t0.m8_d4 AS m8_d4_225, t0.m8_d5 AS m8_d5_226, t0.m8_d6 AS m8_d6_227, t0.m8_d7 AS m8_d7_228, t0.m8_d8 AS m8_d8_229, t0.m8_d9 AS m8_d9_230, t0.m8_d10 AS m8_d10_231, t0.m8_d11 AS m8_d11_232, t0.m8_d12 AS m8_d12_233, t0.m8_d13 AS m8_d13_234, t0.m8_d14 AS m8_d14_235, t0.m8_d15 AS m8_d15_236, t0.m8_d16 AS m8_d16_237, t0.m8_d17 AS m8_d17_238, t0.m8_d18 AS m8_d18_239, t0.m8_d19 AS m8_d19_240, t0.m8_d20 AS m8_d20_241, t0.m8_d21 AS m8_d21_242, t0.m8_d22 AS m8_d22_243, t0.m8_d23 AS m8_d23_244, t0.m8_d24 AS m8_d24_245, t0.m8_d25 AS m8_d25_246, t0.m8_d26 AS m8_d26_247, t0.m8_d27 AS m8_d27_248, t0.m8_d28 AS m8_d28_249, t0.m8_d29 AS m8_d29_250, t0.m8_d30 AS m8_d30_251, t0.m8_d31 AS m8_d31_252, t0.m9_d1 AS m9_d1_253, t0.m9_d2 AS m9_d2_254, t0.m9_d3 AS m9_d3_255, t0.m9_d4 AS m9_d4_256, t0.m9_d5 AS m9_d5_257, t0.m9_d6 AS m9_d6_258, t0.m9_d7 AS m9_d7_259, t0.m9_d8 AS m9_d8_260, t0.m9_d9 AS m9_d9_261, t0.m9_d10 AS m9_d10_262, t0.m9_d11 AS m9_d11_263, t0.m9_d12 AS m9_d12_264, t0.m9_d13 AS m9_d13_265, t0.m9_d14 AS m9_d14_266, t0.m9_d15 AS m9_d15_267, t0.m9_d16 AS m9_d16_268, t0.m9_d17 AS m9_d17_269, t0.m9_d18 AS m9_d18_270, t0.m9_d19 AS m9_d19_271, t0.m9_d20 AS m9_d20_272, t0.m9_d21 AS m9_d21_273, t0.m9_d22 AS m9_d22_274, t0.m9_d23 AS m9_d23_275, t0.m9_d24 AS m9_d24_276, t0.m9_d25 AS m9_d25_277, t0.m9_d26 AS m9_d26_278, t0.m9_d27 AS m9_d27_279, t0.m9_d28 AS m9_d28_280, t0.m9_d29 AS m9_d29_281, t0.m9_d30 AS m9_d30_282, t0.m9_d31 AS m9_d31_283, t0.m10_d1 AS m10_d1_284, t0.m10_d2 AS m10_d2_285, t0.m10_d3 AS m10_d3_286, t0.m10_d4 AS m10_d4_287, t0.m10_d5 AS m10_d5_288, t0.m10_d6 AS m10_d6_289, t0.m10_d7 AS m10_d7_290, t0.m10_d8 AS m10_d8_291, t0.m10_d9 AS m10_d9_292, t0.m10_d10 AS m10_d10_293, t0.m10_d11 AS m10_d11_294, t0.m10_d12 AS m10_d12_295, t0.m10_d13 AS m10_d13_296, t0.m10_d14 AS m10_d14_297, t0.m10_d15 AS m10_d15_298, t0.m10_d16 AS m10_d16_299, t0.m10_d17 AS m10_d17_300, t0.m10_d18 AS m10_d18_301, t0.m10_d19 AS m10_d19_302, t0.m10_d20 AS m10_d20_303, t0.m10_d21 AS m10_d21_304, t0.m10_d22 AS m10_d22_305, t0.m10_d23 AS m10_d23_306, t0.m10_d24 AS m10_d24_307, t0.m10_d25 AS m10_d25_308, t0.m10_d26 AS m10_d26_309, t0.m10_d27 AS m10_d27_310, t0.m10_d28 AS m10_d28_311, t0.m10_d29 AS m10_d29_312, t0.m10_d30 AS m10_d30_313, t0.m10_d31 AS m10_d31_314, t0.m11_d1 AS m11_d1_315, t0.m11_d2 AS m11_d2_316, t0.m11_d3 AS m11_d3_317, t0.m11_d4 AS m11_d4_318, t0.m11_d5 AS m11_d5_319, t0.m11_d6 AS m11_d6_320, t0.m11_d7 AS m11_d7_321, t0.m11_d8 AS m11_d8_322, t0.m11_d9 AS m11_d9_323, t0.m11_d10 AS m11_d10_324, t0.m11_d11 AS m11_d11_325, t0.m11_d12 AS m11_d12_326, t0.m11_d13 AS m11_d13_327, t0.m11_d14 AS m11_d14_328, t0.m11_d15 AS m11_d15_329, t0.m11_d16 AS m11_d16_330, t0.m11_d17 AS m11_d17_331, t0.m11_d18 AS m11_d18_332, t0.m11_d19 AS m11_d19_333, t0.m11_d20 AS m11_d20_334, t0.m11_d21 AS m11_d21_335, t0.m11_d22 AS m11_d22_336, t0.m11_d23 AS m11_d23_337, t0.m11_d24 AS m11_d24_338, t0.m11_d25 AS m11_d25_339, t0.m11_d26 AS m11_d26_340, t0.m11_d27 AS m11_d27_341, t0.m11_d28 AS m11_d28_342, t0.m11_d29 AS m11_d29_343, t0.m11_d30 AS m11_d30_344, t0.m11_d31 AS m11_d31_345, t0.m12_d1 AS m12_d1_346, t0.m12_d2 AS m12_d2_347, t0.m12_d3 AS m12_d3_348, t0.m12_d4 AS m12_d4_349, t0.m12_d5 AS m12_d5_350, t0.m12_d6 AS m12_d6_351, t0.m12_d7 AS m12_d7_352, t0.m12_d8 AS m12_d8_353, t0.m12_d9 AS m12_d9_354, t0.m12_d10 AS m12_d10_355, t0.m12_d11 AS m12_d11_356, t0.m12_d12 AS m12_d12_357, t0.m12_d13 AS m12_d13_358, t0.m12_d14 AS m12_d14_359, t0.m12_d15 AS m12_d15_360, t0.m12_d16 AS m12_d16_361, t0.m12_d17 AS m12_d17_362, t0.m12_d18 AS m12_d18_363, t0.m12_d19 AS m12_d19_364, t0.m12_d20 AS m12_d20_365, t0.m12_d21 AS m12_d21_366, t0.m12_d22 AS m12_d22_367, t0.m12_d23 AS m12_d23_368, t0.m12_d24 AS m12_d24_369, t0.m12_d25 AS m12_d25_370, t0.m12_d26 AS m12_d26_371, t0.m12_d27 AS m12_d27_372, t0.m12_d28 AS m12_d28_373, t0.m12_d29 AS m12_d29_374, t0.m12_d30 AS m12_d30_375, t0.m12_d31 AS m12_d31_376, t0.worker_a_id AS worker_a_id_377, t0.worker_activity_id AS worker_activity_id_378, t379.id AS id_380, t379.history AS history_381, t379.created_at AS created_at_382, t379.worker_timesheet_id AS worker_timesheet_id_383 FROM worker_timesheet t0 LEFT JOIN worker_timesheet_histories t379 ON t379.worker_timesheet_id = t0.id
Parameters:
[]
46 0.59 ms
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
Parameters:
[]
47 2.30 ms
"COMMIT"
Parameters:
[]
48 0.33 ms
"START TRANSACTION"
Parameters:
[]
49 0.58 ms
UPDATE project_orders SET hours_spent = ?, cost_spent = ? WHERE id = ?
Parameters:
[
  423.5
  21175.0
  1219
]
50 1.68 ms
"COMMIT"
Parameters:
[]
51 2.47 ms
SELECT t0.id AS id_1, t0.year AS year_2, t0.created_at AS created_at_3, t0.transformed_at AS transformed_at_4, t0.m1_d1 AS m1_d1_5, t0.m1_d2 AS m1_d2_6, t0.m1_d3 AS m1_d3_7, t0.m1_d4 AS m1_d4_8, t0.m1_d5 AS m1_d5_9, t0.m1_d6 AS m1_d6_10, t0.m1_d7 AS m1_d7_11, t0.m1_d8 AS m1_d8_12, t0.m1_d9 AS m1_d9_13, t0.m1_d10 AS m1_d10_14, t0.m1_d11 AS m1_d11_15, t0.m1_d12 AS m1_d12_16, t0.m1_d13 AS m1_d13_17, t0.m1_d14 AS m1_d14_18, t0.m1_d15 AS m1_d15_19, t0.m1_d16 AS m1_d16_20, t0.m1_d17 AS m1_d17_21, t0.m1_d18 AS m1_d18_22, t0.m1_d19 AS m1_d19_23, t0.m1_d20 AS m1_d20_24, t0.m1_d21 AS m1_d21_25, t0.m1_d22 AS m1_d22_26, t0.m1_d23 AS m1_d23_27, t0.m1_d24 AS m1_d24_28, t0.m1_d25 AS m1_d25_29, t0.m1_d26 AS m1_d26_30, t0.m1_d27 AS m1_d27_31, t0.m1_d28 AS m1_d28_32, t0.m1_d29 AS m1_d29_33, t0.m1_d30 AS m1_d30_34, t0.m1_d31 AS m1_d31_35, t0.m2_d1 AS m2_d1_36, t0.m2_d2 AS m2_d2_37, t0.m2_d3 AS m2_d3_38, t0.m2_d4 AS m2_d4_39, t0.m2_d5 AS m2_d5_40, t0.m2_d6 AS m2_d6_41, t0.m2_d7 AS m2_d7_42, t0.m2_d8 AS m2_d8_43, t0.m2_d9 AS m2_d9_44, t0.m2_d10 AS m2_d10_45, t0.m2_d11 AS m2_d11_46, t0.m2_d12 AS m2_d12_47, t0.m2_d13 AS m2_d13_48, t0.m2_d14 AS m2_d14_49, t0.m2_d15 AS m2_d15_50, t0.m2_d16 AS m2_d16_51, t0.m2_d17 AS m2_d17_52, t0.m2_d18 AS m2_d18_53, t0.m2_d19 AS m2_d19_54, t0.m2_d20 AS m2_d20_55, t0.m2_d21 AS m2_d21_56, t0.m2_d22 AS m2_d22_57, t0.m2_d23 AS m2_d23_58, t0.m2_d24 AS m2_d24_59, t0.m2_d25 AS m2_d25_60, t0.m2_d26 AS m2_d26_61, t0.m2_d27 AS m2_d27_62, t0.m2_d28 AS m2_d28_63, t0.m2_d29 AS m2_d29_64, t0.m2_d30 AS m2_d30_65, t0.m2_d31 AS m2_d31_66, t0.m3_d1 AS m3_d1_67, t0.m3_d2 AS m3_d2_68, t0.m3_d3 AS m3_d3_69, t0.m3_d4 AS m3_d4_70, t0.m3_d5 AS m3_d5_71, t0.m3_d6 AS m3_d6_72, t0.m3_d7 AS m3_d7_73, t0.m3_d8 AS m3_d8_74, t0.m3_d9 AS m3_d9_75, t0.m3_d10 AS m3_d10_76, t0.m3_d11 AS m3_d11_77, t0.m3_d12 AS m3_d12_78, t0.m3_d13 AS m3_d13_79, t0.m3_d14 AS m3_d14_80, t0.m3_d15 AS m3_d15_81, t0.m3_d16 AS m3_d16_82, t0.m3_d17 AS m3_d17_83, t0.m3_d18 AS m3_d18_84, t0.m3_d19 AS m3_d19_85, t0.m3_d20 AS m3_d20_86, t0.m3_d21 AS m3_d21_87, t0.m3_d22 AS m3_d22_88, t0.m3_d23 AS m3_d23_89, t0.m3_d24 AS m3_d24_90, t0.m3_d25 AS m3_d25_91, t0.m3_d26 AS m3_d26_92, t0.m3_d27 AS m3_d27_93, t0.m3_d28 AS m3_d28_94, t0.m3_d29 AS m3_d29_95, t0.m3_d30 AS m3_d30_96, t0.m3_d31 AS m3_d31_97, t0.m4_d1 AS m4_d1_98, t0.m4_d2 AS m4_d2_99, t0.m4_d3 AS m4_d3_100, t0.m4_d4 AS m4_d4_101, t0.m4_d5 AS m4_d5_102, t0.m4_d6 AS m4_d6_103, t0.m4_d7 AS m4_d7_104, t0.m4_d8 AS m4_d8_105, t0.m4_d9 AS m4_d9_106, t0.m4_d10 AS m4_d10_107, t0.m4_d11 AS m4_d11_108, t0.m4_d12 AS m4_d12_109, t0.m4_d13 AS m4_d13_110, t0.m4_d14 AS m4_d14_111, t0.m4_d15 AS m4_d15_112, t0.m4_d16 AS m4_d16_113, t0.m4_d17 AS m4_d17_114, t0.m4_d18 AS m4_d18_115, t0.m4_d19 AS m4_d19_116, t0.m4_d20 AS m4_d20_117, t0.m4_d21 AS m4_d21_118, t0.m4_d22 AS m4_d22_119, t0.m4_d23 AS m4_d23_120, t0.m4_d24 AS m4_d24_121, t0.m4_d25 AS m4_d25_122, t0.m4_d26 AS m4_d26_123, t0.m4_d27 AS m4_d27_124, t0.m4_d28 AS m4_d28_125, t0.m4_d29 AS m4_d29_126, t0.m4_d30 AS m4_d30_127, t0.m4_d31 AS m4_d31_128, t0.m5_d1 AS m5_d1_129, t0.m5_d2 AS m5_d2_130, t0.m5_d3 AS m5_d3_131, t0.m5_d4 AS m5_d4_132, t0.m5_d5 AS m5_d5_133, t0.m5_d6 AS m5_d6_134, t0.m5_d7 AS m5_d7_135, t0.m5_d8 AS m5_d8_136, t0.m5_d9 AS m5_d9_137, t0.m5_d10 AS m5_d10_138, t0.m5_d11 AS m5_d11_139, t0.m5_d12 AS m5_d12_140, t0.m5_d13 AS m5_d13_141, t0.m5_d14 AS m5_d14_142, t0.m5_d15 AS m5_d15_143, t0.m5_d16 AS m5_d16_144, t0.m5_d17 AS m5_d17_145, t0.m5_d18 AS m5_d18_146, t0.m5_d19 AS m5_d19_147, t0.m5_d20 AS m5_d20_148, t0.m5_d21 AS m5_d21_149, t0.m5_d22 AS m5_d22_150, t0.m5_d23 AS m5_d23_151, t0.m5_d24 AS m5_d24_152, t0.m5_d25 AS m5_d25_153, t0.m5_d26 AS m5_d26_154, t0.m5_d27 AS m5_d27_155, t0.m5_d28 AS m5_d28_156, t0.m5_d29 AS m5_d29_157, t0.m5_d30 AS m5_d30_158, t0.m5_d31 AS m5_d31_159, t0.m6_d1 AS m6_d1_160, t0.m6_d2 AS m6_d2_161, t0.m6_d3 AS m6_d3_162, t0.m6_d4 AS m6_d4_163, t0.m6_d5 AS m6_d5_164, t0.m6_d6 AS m6_d6_165, t0.m6_d7 AS m6_d7_166, t0.m6_d8 AS m6_d8_167, t0.m6_d9 AS m6_d9_168, t0.m6_d10 AS m6_d10_169, t0.m6_d11 AS m6_d11_170, t0.m6_d12 AS m6_d12_171, t0.m6_d13 AS m6_d13_172, t0.m6_d14 AS m6_d14_173, t0.m6_d15 AS m6_d15_174, t0.m6_d16 AS m6_d16_175, t0.m6_d17 AS m6_d17_176, t0.m6_d18 AS m6_d18_177, t0.m6_d19 AS m6_d19_178, t0.m6_d20 AS m6_d20_179, t0.m6_d21 AS m6_d21_180, t0.m6_d22 AS m6_d22_181, t0.m6_d23 AS m6_d23_182, t0.m6_d24 AS m6_d24_183, t0.m6_d25 AS m6_d25_184, t0.m6_d26 AS m6_d26_185, t0.m6_d27 AS m6_d27_186, t0.m6_d28 AS m6_d28_187, t0.m6_d29 AS m6_d29_188, t0.m6_d30 AS m6_d30_189, t0.m6_d31 AS m6_d31_190, t0.m7_d1 AS m7_d1_191, t0.m7_d2 AS m7_d2_192, t0.m7_d3 AS m7_d3_193, t0.m7_d4 AS m7_d4_194, t0.m7_d5 AS m7_d5_195, t0.m7_d6 AS m7_d6_196, t0.m7_d7 AS m7_d7_197, t0.m7_d8 AS m7_d8_198, t0.m7_d9 AS m7_d9_199, t0.m7_d10 AS m7_d10_200, t0.m7_d11 AS m7_d11_201, t0.m7_d12 AS m7_d12_202, t0.m7_d13 AS m7_d13_203, t0.m7_d14 AS m7_d14_204, t0.m7_d15 AS m7_d15_205, t0.m7_d16 AS m7_d16_206, t0.m7_d17 AS m7_d17_207, t0.m7_d18 AS m7_d18_208, t0.m7_d19 AS m7_d19_209, t0.m7_d20 AS m7_d20_210, t0.m7_d21 AS m7_d21_211, t0.m7_d22 AS m7_d22_212, t0.m7_d23 AS m7_d23_213, t0.m7_d24 AS m7_d24_214, t0.m7_d25 AS m7_d25_215, t0.m7_d26 AS m7_d26_216, t0.m7_d27 AS m7_d27_217, t0.m7_d28 AS m7_d28_218, t0.m7_d29 AS m7_d29_219, t0.m7_d30 AS m7_d30_220, t0.m7_d31 AS m7_d31_221, t0.m8_d1 AS m8_d1_222, t0.m8_d2 AS m8_d2_223, t0.m8_d3 AS m8_d3_224, t0.m8_d4 AS m8_d4_225, t0.m8_d5 AS m8_d5_226, t0.m8_d6 AS m8_d6_227, t0.m8_d7 AS m8_d7_228, t0.m8_d8 AS m8_d8_229, t0.m8_d9 AS m8_d9_230, t0.m8_d10 AS m8_d10_231, t0.m8_d11 AS m8_d11_232, t0.m8_d12 AS m8_d12_233, t0.m8_d13 AS m8_d13_234, t0.m8_d14 AS m8_d14_235, t0.m8_d15 AS m8_d15_236, t0.m8_d16 AS m8_d16_237, t0.m8_d17 AS m8_d17_238, t0.m8_d18 AS m8_d18_239, t0.m8_d19 AS m8_d19_240, t0.m8_d20 AS m8_d20_241, t0.m8_d21 AS m8_d21_242, t0.m8_d22 AS m8_d22_243, t0.m8_d23 AS m8_d23_244, t0.m8_d24 AS m8_d24_245, t0.m8_d25 AS m8_d25_246, t0.m8_d26 AS m8_d26_247, t0.m8_d27 AS m8_d27_248, t0.m8_d28 AS m8_d28_249, t0.m8_d29 AS m8_d29_250, t0.m8_d30 AS m8_d30_251, t0.m8_d31 AS m8_d31_252, t0.m9_d1 AS m9_d1_253, t0.m9_d2 AS m9_d2_254, t0.m9_d3 AS m9_d3_255, t0.m9_d4 AS m9_d4_256, t0.m9_d5 AS m9_d5_257, t0.m9_d6 AS m9_d6_258, t0.m9_d7 AS m9_d7_259, t0.m9_d8 AS m9_d8_260, t0.m9_d9 AS m9_d9_261, t0.m9_d10 AS m9_d10_262, t0.m9_d11 AS m9_d11_263, t0.m9_d12 AS m9_d12_264, t0.m9_d13 AS m9_d13_265, t0.m9_d14 AS m9_d14_266, t0.m9_d15 AS m9_d15_267, t0.m9_d16 AS m9_d16_268, t0.m9_d17 AS m9_d17_269, t0.m9_d18 AS m9_d18_270, t0.m9_d19 AS m9_d19_271, t0.m9_d20 AS m9_d20_272, t0.m9_d21 AS m9_d21_273, t0.m9_d22 AS m9_d22_274, t0.m9_d23 AS m9_d23_275, t0.m9_d24 AS m9_d24_276, t0.m9_d25 AS m9_d25_277, t0.m9_d26 AS m9_d26_278, t0.m9_d27 AS m9_d27_279, t0.m9_d28 AS m9_d28_280, t0.m9_d29 AS m9_d29_281, t0.m9_d30 AS m9_d30_282, t0.m9_d31 AS m9_d31_283, t0.m10_d1 AS m10_d1_284, t0.m10_d2 AS m10_d2_285, t0.m10_d3 AS m10_d3_286, t0.m10_d4 AS m10_d4_287, t0.m10_d5 AS m10_d5_288, t0.m10_d6 AS m10_d6_289, t0.m10_d7 AS m10_d7_290, t0.m10_d8 AS m10_d8_291, t0.m10_d9 AS m10_d9_292, t0.m10_d10 AS m10_d10_293, t0.m10_d11 AS m10_d11_294, t0.m10_d12 AS m10_d12_295, t0.m10_d13 AS m10_d13_296, t0.m10_d14 AS m10_d14_297, t0.m10_d15 AS m10_d15_298, t0.m10_d16 AS m10_d16_299, t0.m10_d17 AS m10_d17_300, t0.m10_d18 AS m10_d18_301, t0.m10_d19 AS m10_d19_302, t0.m10_d20 AS m10_d20_303, t0.m10_d21 AS m10_d21_304, t0.m10_d22 AS m10_d22_305, t0.m10_d23 AS m10_d23_306, t0.m10_d24 AS m10_d24_307, t0.m10_d25 AS m10_d25_308, t0.m10_d26 AS m10_d26_309, t0.m10_d27 AS m10_d27_310, t0.m10_d28 AS m10_d28_311, t0.m10_d29 AS m10_d29_312, t0.m10_d30 AS m10_d30_313, t0.m10_d31 AS m10_d31_314, t0.m11_d1 AS m11_d1_315, t0.m11_d2 AS m11_d2_316, t0.m11_d3 AS m11_d3_317, t0.m11_d4 AS m11_d4_318, t0.m11_d5 AS m11_d5_319, t0.m11_d6 AS m11_d6_320, t0.m11_d7 AS m11_d7_321, t0.m11_d8 AS m11_d8_322, t0.m11_d9 AS m11_d9_323, t0.m11_d10 AS m11_d10_324, t0.m11_d11 AS m11_d11_325, t0.m11_d12 AS m11_d12_326, t0.m11_d13 AS m11_d13_327, t0.m11_d14 AS m11_d14_328, t0.m11_d15 AS m11_d15_329, t0.m11_d16 AS m11_d16_330, t0.m11_d17 AS m11_d17_331, t0.m11_d18 AS m11_d18_332, t0.m11_d19 AS m11_d19_333, t0.m11_d20 AS m11_d20_334, t0.m11_d21 AS m11_d21_335, t0.m11_d22 AS m11_d22_336, t0.m11_d23 AS m11_d23_337, t0.m11_d24 AS m11_d24_338, t0.m11_d25 AS m11_d25_339, t0.m11_d26 AS m11_d26_340, t0.m11_d27 AS m11_d27_341, t0.m11_d28 AS m11_d28_342, t0.m11_d29 AS m11_d29_343, t0.m11_d30 AS m11_d30_344, t0.m11_d31 AS m11_d31_345, t0.m12_d1 AS m12_d1_346, t0.m12_d2 AS m12_d2_347, t0.m12_d3 AS m12_d3_348, t0.m12_d4 AS m12_d4_349, t0.m12_d5 AS m12_d5_350, t0.m12_d6 AS m12_d6_351, t0.m12_d7 AS m12_d7_352, t0.m12_d8 AS m12_d8_353, t0.m12_d9 AS m12_d9_354, t0.m12_d10 AS m12_d10_355, t0.m12_d11 AS m12_d11_356, t0.m12_d12 AS m12_d12_357, t0.m12_d13 AS m12_d13_358, t0.m12_d14 AS m12_d14_359, t0.m12_d15 AS m12_d15_360, t0.m12_d16 AS m12_d16_361, t0.m12_d17 AS m12_d17_362, t0.m12_d18 AS m12_d18_363, t0.m12_d19 AS m12_d19_364, t0.m12_d20 AS m12_d20_365, t0.m12_d21 AS m12_d21_366, t0.m12_d22 AS m12_d22_367, t0.m12_d23 AS m12_d23_368, t0.m12_d24 AS m12_d24_369, t0.m12_d25 AS m12_d25_370, t0.m12_d26 AS m12_d26_371, t0.m12_d27 AS m12_d27_372, t0.m12_d28 AS m12_d28_373, t0.m12_d29 AS m12_d29_374, t0.m12_d30 AS m12_d30_375, t0.m12_d31 AS m12_d31_376, t0.worker_a_id AS worker_a_id_377, t0.worker_activity_id AS worker_activity_id_378, t379.id AS id_380, t379.history AS history_381, t379.created_at AS created_at_382, t379.worker_timesheet_id AS worker_timesheet_id_383 FROM worker_timesheet t0 LEFT JOIN worker_timesheet_histories t379 ON t379.worker_timesheet_id = t0.id WHERE t0.id = ?
Parameters:
[
  393
]
52 0.34 ms
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
Parameters:
[]
53 0.48 ms
SELECT t0.id AS id_1, t0.company AS company_2, t0.slug AS slug_3, t0.tel AS tel_4, t0.company_logo AS company_logo_5, t0.city AS city_6, t0.country_id AS country_id_7, t8.id AS id_9, t8.company_name AS company_name_10, t8.paired_customer_id AS paired_customer_id_11 FROM customer t0 LEFT JOIN administrative t8 ON t8.paired_customer_id = t0.id WHERE t0.id = ?
Parameters:
[
  12
]

Database Connections

Name Service
default doctrine.dbal.default_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

Class Mapping errors
App\Entity\User
  • The mappings App\Entity\User#user_rights and App\Entity\UserRights#user are inconsistent with each other.
  • The association App\Entity\User#inventories refers to the owning side field App\Entity\Inventory#involved_by which does not exist.
App\Entity\Worker
  • The mappings App\Entity\Worker#worker_in_projects and App\Entity\WorkerInProject#worker are inconsistent with each other.
  • The mappings App\Entity\Worker#worker_activities and App\Entity\WorkerActivities#worker are inconsistent with each other.
  • The mappings App\Entity\Worker#worker_certificates and App\Entity\WorkerCertificates#worker are inconsistent with each other.
  • The association App\Entity\Worker#worker_timesheets refers to the owning side field App\Entity\WorkerTimesheet#worker which does not exist.
  • The mappings App\Entity\Worker#user_app_settings and App\Entity\UserAppSettings#worker are inconsistent with each other.
App\Entity\UserPositions No errors.
App\Entity\ProjectAddendumCosts
  • The association App\Entity\ProjectAddendumCosts#project refers to the inverse side field App\Entity\Projects#projectAddendumCosts which does not exist.
App\Entity\AccessRoles No errors.
App\Entity\WorkerTimesheetPayments
  • The association App\Entity\WorkerTimesheetPayments#project refers to the inverse side field App\Entity\Projects#workerTimesheetPayments which does not exist.
App\Entity\ProjectOrderFeedback
  • The association App\Entity\ProjectOrderFeedback#project_order refers to the inverse side field App\Entity\ProjectOrders#projectOrderFeedback which does not exist.
App\Entity\ProjectOrders
  • The mappings App\Entity\ProjectOrders#project_order_feedback and App\Entity\ProjectOrderFeedback#project_order are inconsistent with each other.
  • The mappings App\Entity\ProjectOrders#project_order_invoices and App\Entity\ProjectOrderInvoices#project_order are inconsistent with each other.
  • The association App\Entity\ProjectOrders#contact_person refers to the inverse side field App\Entity\ProjectOwnerContactPersons#projectOrders which does not exist.
  • The mappings App\Entity\ProjectOrders#project_order_extra_costs and App\Entity\ProjectOrderExtraCosts#project_order are inconsistent with each other.
  • The mappings App\Entity\ProjectOrders#project_order_expenses and App\Entity\ProjectOrderExpenses#project_order are inconsistent with each other.
  • The mappings App\Entity\ProjectOrders#project_order_expense_positions and App\Entity\ProjectOrderExpensePositions#project_order are inconsistent with each other.
  • The association App\Entity\ProjectOrders#order_branch refers to the inverse side field App\Entity\Branches#projectOrders which does not exist.
  • The association App\Entity\ProjectOrders#stock_transactions refers to the owning side field App\Entity\StockTransactions#project_order_id which does not exist.
App\Entity\UserRights
  • The association App\Entity\UserRights#user_right_module refers to the inverse side field App\Entity\UserRightModules#userRights which does not exist.
  • The association App\Entity\UserRights#user refers to the inverse side field App\Entity\User#userRights which does not exist.
App\Entity\Inventory No errors.
App\Entity\SupplierOrders
  • The association App\Entity\SupplierOrders#inventories refers to the owning side field App\Entity\Inventory#supplier_order which does not exist.
App\Entity\UserScopedItem No errors.
App\Entity\UserCalculationPermission No errors.
App\Entity\WorkerActivities
  • The association App\Entity\WorkerActivities#worker refers to the inverse side field App\Entity\Worker#workerActivities which does not exist.
  • The association App\Entity\WorkerActivities#customer refers to the inverse side field App\Entity\Customer#workerActivities which does not exist.
App\Entity\PurchaseRequest
  • The mappings App\Entity\PurchaseRequest#purchase_request_user_favorites and App\Entity\PurchaseRequestUserFavorites#purchase_request are inconsistent with each other.
  • The mappings App\Entity\PurchaseRequest#expenses and App\Entity\ProjectOrderExpenses#purchase_request are inconsistent with each other.
App\Entity\PurchaseRequestPositionHistoryRead No errors.
App\Entity\PurchaseRequestHistoryRead No errors.
App\Entity\PurchaseRequestHistories No errors.
App\Entity\PurchaseRequestUserFavorites
  • The association App\Entity\PurchaseRequestUserFavorites#purchase_request refers to the inverse side field App\Entity\PurchaseRequest#purchaseRequestUserFavorites which does not exist.
App\Entity\PurchaseRequestPositions No errors.
App\Entity\Warehouses No errors.
App\Entity\StockIssue No errors.
App\Entity\StockIssuePositions No errors.
App\Entity\Projects
  • The mappings App\Entity\Projects#project_addendum_costs and App\Entity\ProjectAddendumCosts#project are inconsistent with each other.
  • The mappings App\Entity\Projects#project_expenses and App\Entity\ProjectExpense#project are inconsistent with each other.
  • The mappings App\Entity\Projects#worker_timesheet_payments and App\Entity\WorkerTimesheetPayments#project are inconsistent with each other.
App\Entity\ProjectOwner
  • The mappings App\Entity\ProjectOwner#project_owner_contact_persons and App\Entity\ProjectOwnerContactPersons#project_owner are inconsistent with each other.
App\Entity\Countries
  • The mappings App\Entity\Countries#addresses and App\Entity\Addresses#country are inconsistent with each other.
App\Entity\InvoiceType No errors.
App\Entity\ProjectSettings No errors.
App\Entity\ProjectStakeholders
  • The mappings App\Entity\ProjectStakeholders#worker_in_projects and App\Entity\WorkerInProject#project are inconsistent with each other.
  • The association App\Entity\ProjectStakeholders#workerTimesheetPayments refers to the owning side field App\Entity\WorkerTimesheetPayments#project_stakeholder which does not exist.
App\Entity\Qualification No errors.
App\Entity\Certificates No errors.
App\Entity\ProjectExpense
  • The association App\Entity\ProjectExpense#project refers to the inverse side field App\Entity\Projects#projectExpenses which does not exist.
App\Entity\ProjectBranches
  • The association App\Entity\ProjectBranches#branch refers to the inverse side field App\Entity\Branches#projectBranches which does not exist.
App\Entity\Branches
  • The mappings App\Entity\Branches#project_branches and App\Entity\ProjectBranches#branch are inconsistent with each other.
  • The mappings App\Entity\Branches#project_orders and App\Entity\ProjectOrders#order_branch are inconsistent with each other.
  • The mappings App\Entity\Branches#branch_departements and App\Entity\BranchDepartements#branch are inconsistent with each other.
App\Entity\WorkerInProject
  • The association App\Entity\WorkerInProject#worker refers to the inverse side field App\Entity\Worker#workerInProjects which does not exist.
  • The association App\Entity\WorkerInProject#project refers to the inverse side field App\Entity\ProjectStakeholders#workerInProjects which does not exist.
App\Entity\ProjectStatus
  • The association App\Entity\ProjectStatus#workerInProjects refers to the owning side field App\Entity\WorkerInProject#status which does not exist.
App\Entity\Locations No errors.
App\Entity\BranchDepartements
  • The association App\Entity\BranchDepartements#branch refers to the inverse side field App\Entity\Branches#branchDepartements which does not exist.
App\Entity\ProjectOwnerContactPersons
  • The association App\Entity\ProjectOwnerContactPersons#project_owner refers to the inverse side field App\Entity\ProjectOwner#projectOwnerContactPersons which does not exist.
  • The association App\Entity\ProjectOwnerContactPersons#position refers to the inverse side field App\Entity\ContactPersonPositions#projectOwnerContactPersons which does not exist.
App\Entity\ProjectOrderInvoices
  • The association App\Entity\ProjectOrderInvoices#project_order refers to the inverse side field App\Entity\ProjectOrders#projectOrderInvoices which does not exist.
  • The mappings App\Entity\ProjectOrderInvoices#project_order_invoice_positions and App\Entity\ProjectOrderInvoicePositions#project_order_invoice are inconsistent with each other.
App\Entity\ProjectOrderExtraCosts
  • The association App\Entity\ProjectOrderExtraCosts#project_order refers to the inverse side field App\Entity\ProjectOrders#projectOrderExtraCosts which does not exist.
App\Entity\ProjectOrderUndertakings No errors.
App\Entity\ProjectOrderExpenses
  • The association App\Entity\ProjectOrderExpenses#project_order refers to the inverse side field App\Entity\ProjectOrders#projectOrderExpenses which does not exist.
  • The mappings App\Entity\ProjectOrderExpenses#project_order_expense_positions and App\Entity\ProjectOrderExpensePositions#project_order_expense are inconsistent with each other.
  • The association App\Entity\ProjectOrderExpenses#purchase_request refers to the inverse side field App\Entity\PurchaseRequest#expense which does not exist.
App\Entity\ProjectOrderExpensePositions
  • The association App\Entity\ProjectOrderExpensePositions#project_order_expense refers to the inverse side field App\Entity\ProjectOrderExpenses#projectOrderExpensePositions which does not exist.
  • The association App\Entity\ProjectOrderExpensePositions#project_order refers to the inverse side field App\Entity\ProjectOrders#projectOrderExpensePositions which does not exist.
  • The association App\Entity\ProjectOrderExpensePositions#stock refers to the inverse side field App\Entity\Stocks#projectOrderExpensePositions which does not exist.
App\Entity\StockTransactions
  • The association App\Entity\StockTransactions#stock refers to the inverse side field App\Entity\Stocks#stockTransactions which does not exist.
  • The mappings App\Entity\StockTransactions#project_order and App\Entity\ProjectOrders#stock_transactions are inconsistent with each other.
App\Entity\AccessTypes No errors.
App\Entity\TimesheetStatus No errors.
App\Entity\Customer
  • The mappings App\Entity\Customer#worker_activities and App\Entity\WorkerActivities#customer are inconsistent with each other.
  • The mappings App\Entity\Customer#customer_certificates and App\Entity\CustomerCertificates#customer are inconsistent with each other.
App\Entity\WorkerTimesheet
  • The mappings App\Entity\WorkerTimesheet#worker_a and App\Entity\Worker#worker_timesheets are inconsistent with each other.
App\Entity\Timesheets
  • The mappings App\Entity\Timesheets#m1 and App\Entity\TimesheetM1#timesheet are inconsistent with each other.
  • The mappings App\Entity\Timesheets#m2 and App\Entity\TimesheetM2#timesheet are inconsistent with each other.
  • The mappings App\Entity\Timesheets#m3 and App\Entity\TimesheetM3#timesheet are inconsistent with each other.
  • The mappings App\Entity\Timesheets#m4 and App\Entity\TimesheetM4#timesheet are inconsistent with each other.
  • The mappings App\Entity\Timesheets#m5 and App\Entity\TimesheetM5#timesheet are inconsistent with each other.
  • The mappings App\Entity\Timesheets#m6 and App\Entity\TimesheetM6#timesheet are inconsistent with each other.
  • The mappings App\Entity\Timesheets#m7 and App\Entity\TimesheetM7#timesheet are inconsistent with each other.
  • The mappings App\Entity\Timesheets#m8 and App\Entity\TimesheetM8#timesheet are inconsistent with each other.
  • The mappings App\Entity\Timesheets#m9 and App\Entity\TimesheetM9#timesheet are inconsistent with each other.
  • The mappings App\Entity\Timesheets#m10 and App\Entity\TimesheetM10#timesheet are inconsistent with each other.
  • The mappings App\Entity\Timesheets#m11 and App\Entity\TimesheetM11#timesheet are inconsistent with each other.
  • The mappings App\Entity\Timesheets#m12 and App\Entity\TimesheetM12#timesheet are inconsistent with each other.
App\Entity\WorkerCertificates
  • The association App\Entity\WorkerCertificates#worker refers to the inverse side field App\Entity\Worker#workerCertificates which does not exist.
  • The mappings App\Entity\WorkerCertificates#worker_certificate_histories and App\Entity\WorkerCertificateHistories#worker_certificate are inconsistent with each other.
App\Entity\UserAppSettings
  • The association App\Entity\UserAppSettings#worker refers to the inverse side field App\Entity\Worker#userAppSettings which does not exist.
App\Entity\WorkerTimesheetHistories No errors.
App\Entity\ProjectStakeholdersTimesheet No errors.
App\Entity\Administrative No errors.
App\Entity\CustomerCertificates
  • The association App\Entity\CustomerCertificates#customer refers to the inverse side field App\Entity\Customer#customerCertificates which does not exist.
  • The mappings App\Entity\CustomerCertificates#customer_certificate_histories and App\Entity\CustomerCertificateHistories#customer_certificate are inconsistent with each other.