Performance Profiling

Total processing time: 28 ms; Peak memory: 11.444 MB. Show Profiling Timeline

总计9条数据

Time	Duration	Category	Info

13:40:11.411	2.2 ms	yii\db\Command::query	SELECT * FROM "global"."vw_user_login" WHERE "id"=5083
13:40:11.409	1.9 ms	yii\db\Connection::open	Opening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta
13:40:11.414	1.0 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_punch" WHERE ("day_at"='1970-01-01') AND ("user_id" IS NULL)
13:40:11.416	1.0 ms	yii\db\Command::query	SELECT "ps".* FROM "a57be577deb434"."tbl_punch_strategies" "ps" LEFT JOIN "a57be577deb434"."tbl_punch_strategy_resource_rels" "psrr" ON psrr.punch_strategy_id = ps.id WHERE "psrr"."user_id" IS NULL GROUP BY "ps"."id"
13:40:11.419	0.8 ms	yii\db\Command::query	INSERT INTO "a57be577deb434"."tbl_punch" ("user_id", "day_at", "strategy_time_on", "strategy_time_off", "strategy_distance", "strategy_punch_type", "strategy_time_on_overdue", "strategy_time_off_overdue", "strategy_work_hour", "strategy_option_away_need_not_verify", "strategy_option_away_need_not_title", "strategy_option_away_need_photo", "need_work", "in_is_absent", "out_is_absent", "actual_in_is_absent", "actual_out_is_absent", "absent_value", "strategy_lng", "strategy_lat") VALUES (NULL, '1970-01-01', '09:00', '18:00', 200, 1, 60, 60, NULL, FALSE, FALSE, FALSE, TRUE, TRUE, TRUE, TRUE, TRUE, 1, '116.289321', '39.960179') RETURNING "day_at", "user_id"
13:40:11.416	0.4 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_legal_holidays" "lh" WHERE "edate"='1970-01-01'
13:40:11.415	0.4 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_punch" WHERE ("day_at"='1970-01-01') AND ("user_id" IS NULL)
13:40:11.418	0.3 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_punch_strategy_schedules" WHERE ("edate"='1970-01-01') AND ("punch_strategy_id"=1)
13:40:11.418	0.3 ms	yii\db\Command::query	SELECT "psr".* FROM "a57be577deb434"."tbl_punch_strategy_points" "psr" WHERE "psr"."punch_strategy_id"=1