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

Method
POST
HTTP Status
200
IP
11.21.0.2
Profiled on
Token
edc4bc

Query Metrics

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

Grouped Statements

Show all queries

Time▼ Count Info
171.53 ms
(87.98%) 		1 
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: 
[]
View formatted query    View runnable query    Explain query
3.98 ms
(2.04%) 		2 
"COMMIT"
Parameters: 
[]
View formatted query    View runnable query    Explain query
3.12 ms
(1.60%) 		15 
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"
]
View formatted query    View runnable query    Explain query
2.47 ms
(1.26%) 		1 
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
]
View formatted query    View runnable query    Explain query
2.34 ms
(1.20%) 		1 
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
]
View formatted query    View runnable query    Explain query
1.50 ms
(0.77%) 		4 
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: 
[]
View formatted query    View runnable query    Explain query
1.28 ms
(0.66%) 		1 
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
]
View formatted query    View runnable query    Explain query
1.25 ms
(0.64%) 		5 
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
]
View formatted query    View runnable query    Explain query
1.12 ms
(0.57%) 		4 
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
]
View formatted query    View runnable query    Explain query
1.06 ms
(0.54%) 		5 
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
]
View formatted query    View runnable query    Explain query
0.77 ms
(0.40%) 		1 
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
]
View formatted query    View runnable query    Explain query
0.58 ms
(0.30%) 		1 
UPDATE project_orders SET hours_spent = ?, cost_spent = ? WHERE id = ?
Parameters: 
[
  423.5
  21175.0
  1219
]
View formatted query    View runnable query    Explain query
0.51 ms
(0.26%) 		1 
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"
]
View formatted query    View runnable query    Explain query
0.48 ms
(0.25%) 		1 
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
]
View formatted query    View runnable query    Explain query
0.44 ms
(0.23%) 		2 
"START TRANSACTION"
Parameters: 
[]
View formatted query    View runnable query    Explain query
0.44 ms
(0.23%) 		1 
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
]
View formatted query    View runnable query    Explain query
0.39 ms
(0.20%) 		1 
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
]
View formatted query    View runnable query    Explain query
0.35 ms
(0.18%) 		1 
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"
]
View formatted query    View runnable query    Explain query
0.32 ms
(0.17%) 		1 
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
]
View formatted query    View runnable query    Explain query
0.27 ms
(0.14%) 		1 
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
]
View formatted query    View runnable query    Explain query
0.26 ms
(0.13%) 		1 
SELECT t0.id AS id_1, t0.name AS name_2 FROM access_types t0 WHERE t0.id = ?
Parameters: 
[
  1
]
View formatted query    View runnable query    Explain query
0.26 ms
(0.13%) 		1 
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
]
View formatted query    View runnable query    Explain query
0.23 ms
(0.12%) 		1 
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"
]
View formatted query    View runnable query    Explain query

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.