{"__meta":{"id":"X38f84d1223948e78b67bc60852feb42e","datetime":"2024-06-18 19:53:06","utime":1718711586.739661,"method":"GET","uri":"\/api\/box-booking\/list\/on-going-history?platform=android","ip":"14.1.249.179"},"php":{"version":"7.4.18","interface":"fpm-fcgi"},"messages":{"count":0,"messages":[]},"time":{"start":1718711586.2535,"end":1718711586.73969,"duration":0.4861900806427002,"duration_str":"486ms","measures":[{"label":"Booting","start":1718711586.2535,"relative_start":0,"end":1718711586.379776,"relative_end":1718711586.379776,"duration":0.12627601623535156,"duration_str":"126ms","params":[],"collector":null},{"label":"Application","start":1718711586.393824,"relative_start":0.14032411575317383,"end":1718711586.739694,"relative_end":4.0531158447265625e-6,"duration":0.3458700180053711,"duration_str":"346ms","params":[],"collector":null}]},"memory":{"peak_usage":6765528,"peak_usage_str":"6MB"},"exceptions":{"count":0,"exceptions":[]},"views":{"nb_templates":0,"templates":[]},"route":{"uri":"GET api\/box-booking\/list\/{type}","middleware":"api, openKey, auth:sanctum","controller":"App\\Http\\Controllers\\BoxBookingController@boxBookingList","namespace":null,"where":[],"as":"generated::DSX2DfA109FCPiAe","prefix":"api\/box-booking","file":"app\/Http\/Controllers\/BoxBookingController.php:79-160"},"queries":{"nb_statements":5,"nb_failed_statements":0,"accumulated_duration":0.21877999999999997,"accumulated_duration_str":"219ms","statements":[{"sql":"select * from `personal_access_tokens` where `personal_access_tokens`.`id` = '16729' limit 1","type":"query","params":[],"bindings":["16729"],"hints":null,"show_copy":false,"backtrace":[{"index":16,"namespace":null,"name":"\/vendor\/laravel\/framework\/src\/Illuminate\/Support\/Traits\/ForwardsCalls.php","line":23},{"index":19,"namespace":null,"name":"\/vendor\/laravel\/sanctum\/src\/PersonalAccessToken.php","line":64},{"index":20,"namespace":null,"name":"\/vendor\/laravel\/sanctum\/src\/Guard.php","line":66},{"index":23,"namespace":null,"name":"\/vendor\/laravel\/framework\/src\/Illuminate\/Auth\/GuardHelpers.php","line":60},{"index":24,"namespace":"middleware","name":"auth","line":63}],"duration":0.00771,"duration_str":"7.71ms","stmt_id":"\/vendor\/laravel\/framework\/src\/Illuminate\/Support\/Traits\/ForwardsCalls.php:23","connection":"zlock","start_percent":0,"width_percent":3.524},{"sql":"select * from `users` where `users`.`id` = 11026 and `users`.`deleted_at` is null limit 1","type":"query","params":[],"bindings":["11026"],"hints":null,"show_copy":false,"backtrace":[{"index":20,"namespace":null,"name":"\/vendor\/laravel\/sanctum\/src\/Guard.php","line":117},{"index":21,"namespace":null,"name":"\/vendor\/laravel\/sanctum\/src\/Guard.php","line":68},{"index":24,"namespace":null,"name":"\/vendor\/laravel\/framework\/src\/Illuminate\/Auth\/GuardHelpers.php","line":60},{"index":25,"namespace":"middleware","name":"auth","line":63},{"index":26,"namespace":"middleware","name":"auth","line":42}],"duration":0.00049,"duration_str":"490\u03bcs","stmt_id":"\/vendor\/laravel\/sanctum\/src\/Guard.php:117","connection":"zlock","start_percent":3.524,"width_percent":0.224},{"sql":"update `personal_access_tokens` set `last_used_at` = '2024-06-18 19:53:06', `personal_access_tokens`.`updated_at` = '2024-06-18 19:53:06' where `id` = 16729","type":"query","params":[],"bindings":["2024-06-18 19:53:06","2024-06-18 19:53:06","16729"],"hints":null,"show_copy":false,"backtrace":[{"index":13,"namespace":null,"name":"\/vendor\/laravel\/sanctum\/src\/Guard.php","line":76},{"index":14,"namespace":null,"name":"\/vendor\/laravel\/framework\/src\/Illuminate\/Support\/helpers.php","line":263},{"index":18,"namespace":null,"name":"\/vendor\/laravel\/framework\/src\/Illuminate\/Auth\/GuardHelpers.php","line":60},{"index":19,"namespace":"middleware","name":"auth","line":63},{"index":20,"namespace":"middleware","name":"auth","line":42}],"duration":0.00662,"duration_str":"6.62ms","stmt_id":"\/vendor\/laravel\/sanctum\/src\/Guard.php:76","connection":"zlock","start_percent":3.748,"width_percent":3.026},{"sql":"select * from `user_box_deliveries` where (`collected_at` is null and exists (select * from `users` where `user_box_deliveries`.`user_id` = `users`.`id` and `id` = 11026 and `users`.`deleted_at` is null)) order by `created_at` desc","type":"query","params":[],"bindings":["11026"],"hints":null,"show_copy":false,"backtrace":[{"index":14,"namespace":null,"name":"\/app\/Http\/Services\/BoxDeliveryService.php","line":77},{"index":15,"namespace":null,"name":"\/app\/Http\/Controllers\/BoxBookingController.php","line":131},{"index":16,"namespace":null,"name":"\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Controller.php","line":54},{"index":17,"namespace":null,"name":"\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/ControllerDispatcher.php","line":45},{"index":18,"namespace":null,"name":"\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Route.php","line":262}],"duration":0.00232,"duration_str":"2.32ms","stmt_id":"\/app\/Http\/Services\/BoxDeliveryService.php:77","connection":"zlock","start_percent":6.774,"width_percent":1.06},{"sql":"select * from `user_box_inventories` where (`collected_at` is null and exists (select * from `users` where `user_box_inventories`.`user_id` = `users`.`id` and `id` = 11026 and `users`.`deleted_at` is null)) or (`collector_num` = '+601130444340' and `collected_at` is null) order by `created_at` desc","type":"query","params":[],"bindings":["11026","+601130444340"],"hints":null,"show_copy":false,"backtrace":[{"index":14,"namespace":null,"name":"\/app\/Http\/Services\/BoxInventoryService.php","line":69},{"index":15,"namespace":null,"name":"\/app\/Http\/Controllers\/BoxBookingController.php","line":142},{"index":16,"namespace":null,"name":"\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Controller.php","line":54},{"index":17,"namespace":null,"name":"\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/ControllerDispatcher.php","line":45},{"index":18,"namespace":null,"name":"\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Route.php","line":262}],"duration":0.20163999999999999,"duration_str":"202ms","stmt_id":"\/app\/Http\/Services\/BoxInventoryService.php:69","connection":"zlock","start_percent":7.834,"width_percent":92.166}]},"models":{"data":{"App\\Models\\User":1,"Laravel\\Sanctum\\PersonalAccessToken":1},"count":2},"swiftmailer_mails":{"count":0,"mails":[]},"gate":{"count":0,"messages":[]},"session":[],"request":{"telescope":"<a href=\"https:\/\/app.zlock.com.my\/_debugbar\/telescope\/9c50df5c-254c-4a06-a05e-ff0da56a8cec\" target=\"_blank\">View in Telescope<\/a>","path_info":"\/api\/box-booking\/list\/on-going-history","status_code":"<pre class=sf-dump id=sf-dump-1269234685 data-indent-pad=\"  \"><span class=sf-dump-num>200<\/span>\n<\/pre><script>Sfdump(\"sf-dump-1269234685\", {\"maxDepth\":0})<\/script>\n","status_text":"OK","format":"html","content_type":"application\/json","request_query":"<pre class=sf-dump id=sf-dump-1401555247 data-indent-pad=\"  \"><span class=sf-dump-note>array:1<\/span> [<samp data-depth=1 class=sf-dump-expanded>\n  \"<span class=sf-dump-key>platform<\/span>\" => \"<span class=sf-dump-str title=\"7 characters\">android<\/span>\"\n<\/samp>]\n<\/pre><script>Sfdump(\"sf-dump-1401555247\", {\"maxDepth\":0})<\/script>\n","request_request":"<pre class=sf-dump id=sf-dump-1562820240 data-indent-pad=\"  \"><span class=sf-dump-note>array:1<\/span> [<samp data-depth=1 class=sf-dump-expanded>\n  \"<span class=sf-dump-key>platform<\/span>\" => \"<span class=sf-dump-str title=\"7 characters\">android<\/span>\"\n<\/samp>]\n<\/pre><script>Sfdump(\"sf-dump-1562820240\", {\"maxDepth\":0})<\/script>\n","request_headers":"<pre class=sf-dump id=sf-dump-231233309 data-indent-pad=\"  \"><span class=sf-dump-note>array:6<\/span> [<samp data-depth=1 class=sf-dump-expanded>\n  \"<span class=sf-dump-key>host<\/span>\" => <span class=sf-dump-note>array:1<\/span> [<samp data-depth=2 class=sf-dump-compact>\n    <span class=sf-dump-index>0<\/span> => \"<span class=sf-dump-str title=\"16 characters\">app.zlock.com.my<\/span>\"\n  <\/samp>]\n  \"<span class=sf-dump-key>openkey<\/span>\" => <span class=sf-dump-note>array:1<\/span> [<samp data-depth=2 class=sf-dump-compact>\n    <span class=sf-dump-index>0<\/span> => \"<span class=sf-dump-str title=\"3 characters\">web<\/span>\"\n  <\/samp>]\n  \"<span class=sf-dump-key>accept-encoding<\/span>\" => <span class=sf-dump-note>array:1<\/span> [<samp data-depth=2 class=sf-dump-compact>\n    <span class=sf-dump-index>0<\/span> => \"<span class=sf-dump-str title=\"4 characters\">gzip<\/span>\"\n  <\/samp>]\n  \"<span class=sf-dump-key>accept<\/span>\" => <span class=sf-dump-note>array:1<\/span> [<samp data-depth=2 class=sf-dump-compact>\n    <span class=sf-dump-index>0<\/span> => \"<span class=sf-dump-str title=\"16 characters\">application\/json<\/span>\"\n  <\/samp>]\n  \"<span class=sf-dump-key>user-agent<\/span>\" => <span class=sf-dump-note>array:1<\/span> [<samp data-depth=2 class=sf-dump-compact>\n    <span class=sf-dump-index>0<\/span> => \"<span class=sf-dump-str title=\"19 characters\">Dart\/2.16 (dart:io)<\/span>\"\n  <\/samp>]\n  \"<span class=sf-dump-key>authorization<\/span>\" => <span class=sf-dump-note>array:1<\/span> [<samp data-depth=2 class=sf-dump-compact>\n    <span class=sf-dump-index>0<\/span> => \"<span class=sf-dump-str title=\"53 characters\">Bearer 16729|vyi7DVPlfXVputvFOLcyZgWegTuKsElHjGOTb540<\/span>\"\n  <\/samp>]\n<\/samp>]\n<\/pre><script>Sfdump(\"sf-dump-231233309\", {\"maxDepth\":0})<\/script>\n","request_server":"<pre class=sf-dump id=sf-dump-1171230062 data-indent-pad=\"  \"><span class=sf-dump-note>array:44<\/span> [<samp data-depth=1 class=sf-dump-expanded>\n  \"<span class=sf-dump-key>PATH<\/span>\" => \"<span class=sf-dump-str title=\"364 characters\">\/opt\/bitnami\/apache\/bin:\/opt\/bitnami\/common\/bin:\/opt\/bitnami\/nami\/bin:\/usr\/local\/sbin:\/usr\/local\/bin:\/usr\/sbin:\/usr\/bin:\/sbin:\/bin:\/opt\/bitnami\/apache\/bin:\/opt\/bitnami\/apache2\/bin:\/opt\/bitnami\/common\/bin:\/opt\/bitnami\/git\/bin:\/opt\/bitnami\/gonit\/bin:\/opt\/bitnami\/mysql\/bin:\/opt\/bitnami\/php\/bin:\/opt\/bitnami\/php\/sbin:\/opt\/bitnami\/varnish\/bin:\/opt\/bitnami\/varnish\/sbin<\/span>\"\n  \"<span class=sf-dump-key>USER<\/span>\" => \"<span class=sf-dump-str title=\"6 characters\">daemon<\/span>\"\n  \"<span class=sf-dump-key>HOME<\/span>\" => \"<span class=sf-dump-str title=\"9 characters\">\/usr\/sbin<\/span>\"\n  \"<span class=sf-dump-key>SCRIPT_NAME<\/span>\" => \"<span class=sf-dump-str title=\"10 characters\">\/index.php<\/span>\"\n  \"<span class=sf-dump-key>REQUEST_URI<\/span>\" => \"<span class=sf-dump-str title=\"55 characters\">\/api\/box-booking\/list\/on-going-history?platform=android<\/span>\"\n  \"<span class=sf-dump-key>QUERY_STRING<\/span>\" => \"<span class=sf-dump-str title=\"16 characters\">platform=android<\/span>\"\n  \"<span class=sf-dump-key>REQUEST_METHOD<\/span>\" => \"<span class=sf-dump-str title=\"3 characters\">GET<\/span>\"\n  \"<span class=sf-dump-key>SERVER_PROTOCOL<\/span>\" => \"<span class=sf-dump-str title=\"8 characters\">HTTP\/1.1<\/span>\"\n  \"<span class=sf-dump-key>GATEWAY_INTERFACE<\/span>\" => \"<span class=sf-dump-str title=\"7 characters\">CGI\/1.1<\/span>\"\n  \"<span class=sf-dump-key>REDIRECT_QUERY_STRING<\/span>\" => \"<span class=sf-dump-str title=\"16 characters\">platform=android<\/span>\"\n  \"<span class=sf-dump-key>REDIRECT_URL<\/span>\" => \"<span class=sf-dump-str title=\"38 characters\">\/api\/box-booking\/list\/on-going-history<\/span>\"\n  \"<span class=sf-dump-key>REMOTE_PORT<\/span>\" => \"<span class=sf-dump-str title=\"5 characters\">20956<\/span>\"\n  \"<span class=sf-dump-key>SCRIPT_FILENAME<\/span>\" => \"<span class=sf-dump-str title=\"41 characters\">\/home\/bitnami\/htdocs\/app\/public\/index.php<\/span>\"\n  \"<span class=sf-dump-key>SERVER_ADMIN<\/span>\" => \"<span class=sf-dump-str title=\"15 characters\">you@example.com<\/span>\"\n  \"<span class=sf-dump-key>CONTEXT_DOCUMENT_ROOT<\/span>\" => \"<span class=sf-dump-str title=\"31 characters\">\/home\/bitnami\/htdocs\/app\/public<\/span>\"\n  \"<span class=sf-dump-key>CONTEXT_PREFIX<\/span>\" => \"\"\n  \"<span class=sf-dump-key>REQUEST_SCHEME<\/span>\" => \"<span class=sf-dump-str title=\"5 characters\">https<\/span>\"\n  \"<span class=sf-dump-key>DOCUMENT_ROOT<\/span>\" => \"<span class=sf-dump-str title=\"31 characters\">\/home\/bitnami\/htdocs\/app\/public<\/span>\"\n  \"<span class=sf-dump-key>REMOTE_ADDR<\/span>\" => \"<span class=sf-dump-str title=\"12 characters\">14.1.249.179<\/span>\"\n  \"<span class=sf-dump-key>SERVER_PORT<\/span>\" => \"<span class=sf-dump-str title=\"3 characters\">443<\/span>\"\n  \"<span class=sf-dump-key>SERVER_ADDR<\/span>\" => \"<span class=sf-dump-str title=\"10 characters\">10.148.0.5<\/span>\"\n  \"<span class=sf-dump-key>SERVER_NAME<\/span>\" => \"<span class=sf-dump-str title=\"16 characters\">app.zlock.com.my<\/span>\"\n  \"<span class=sf-dump-key>SERVER_SOFTWARE<\/span>\" => \"<span class=sf-dump-str title=\"35 characters\">Apache\/2.4.46 (Unix) OpenSSL\/1.1.1d<\/span>\"\n  \"<span class=sf-dump-key>SERVER_SIGNATURE<\/span>\" => \"\"\n  \"<span class=sf-dump-key>HTTP_HOST<\/span>\" => \"<span class=sf-dump-str title=\"16 characters\">app.zlock.com.my<\/span>\"\n  \"<span class=sf-dump-key>HTTP_OPENKEY<\/span>\" => \"<span class=sf-dump-str title=\"3 characters\">web<\/span>\"\n  \"<span class=sf-dump-key>HTTP_ACCEPT_ENCODING<\/span>\" => \"<span class=sf-dump-str title=\"4 characters\">gzip<\/span>\"\n  \"<span class=sf-dump-key>HTTP_ACCEPT<\/span>\" => \"<span class=sf-dump-str title=\"16 characters\">application\/json<\/span>\"\n  \"<span class=sf-dump-key>HTTP_USER_AGENT<\/span>\" => \"<span class=sf-dump-str title=\"19 characters\">Dart\/2.16 (dart:io)<\/span>\"\n  \"<span class=sf-dump-key>SSL_TLS_SNI<\/span>\" => \"<span class=sf-dump-str title=\"16 characters\">app.zlock.com.my<\/span>\"\n  \"<span class=sf-dump-key>HTTPS<\/span>\" => \"<span class=sf-dump-str title=\"2 characters\">on<\/span>\"\n  \"<span class=sf-dump-key>HTTP_AUTHORIZATION<\/span>\" => \"<span class=sf-dump-str title=\"53 characters\">Bearer 16729|vyi7DVPlfXVputvFOLcyZgWegTuKsElHjGOTb540<\/span>\"\n  \"<span class=sf-dump-key>SCRIPT_URI<\/span>\" => \"<span class=sf-dump-str title=\"62 characters\">https:\/\/app.zlock.com.my\/api\/box-booking\/list\/on-going-history<\/span>\"\n  \"<span class=sf-dump-key>SCRIPT_URL<\/span>\" => \"<span class=sf-dump-str title=\"38 characters\">\/api\/box-booking\/list\/on-going-history<\/span>\"\n  \"<span class=sf-dump-key>REDIRECT_STATUS<\/span>\" => \"<span class=sf-dump-str title=\"3 characters\">200<\/span>\"\n  \"<span class=sf-dump-key>REDIRECT_SSL_TLS_SNI<\/span>\" => \"<span class=sf-dump-str title=\"16 characters\">app.zlock.com.my<\/span>\"\n  \"<span class=sf-dump-key>REDIRECT_HTTPS<\/span>\" => \"<span class=sf-dump-str title=\"2 characters\">on<\/span>\"\n  \"<span class=sf-dump-key>REDIRECT_HTTP_AUTHORIZATION<\/span>\" => \"<span class=sf-dump-str title=\"53 characters\">Bearer 16729|vyi7DVPlfXVputvFOLcyZgWegTuKsElHjGOTb540<\/span>\"\n  \"<span class=sf-dump-key>REDIRECT_SCRIPT_URI<\/span>\" => \"<span class=sf-dump-str title=\"62 characters\">https:\/\/app.zlock.com.my\/api\/box-booking\/list\/on-going-history<\/span>\"\n  \"<span class=sf-dump-key>REDIRECT_SCRIPT_URL<\/span>\" => \"<span class=sf-dump-str title=\"38 characters\">\/api\/box-booking\/list\/on-going-history<\/span>\"\n  \"<span class=sf-dump-key>FCGI_ROLE<\/span>\" => \"<span class=sf-dump-str title=\"9 characters\">RESPONDER<\/span>\"\n  \"<span class=sf-dump-key>PHP_SELF<\/span>\" => \"<span class=sf-dump-str title=\"10 characters\">\/index.php<\/span>\"\n  \"<span class=sf-dump-key>REQUEST_TIME_FLOAT<\/span>\" => <span class=sf-dump-num>1718711586.2535<\/span>\n  \"<span class=sf-dump-key>REQUEST_TIME<\/span>\" => <span class=sf-dump-num>1718711586<\/span>\n<\/samp>]\n<\/pre><script>Sfdump(\"sf-dump-1171230062\", {\"maxDepth\":0})<\/script>\n","request_cookies":"<pre class=sf-dump id=sf-dump-1161500919 data-indent-pad=\"  \">[]\n<\/pre><script>Sfdump(\"sf-dump-1161500919\", {\"maxDepth\":0})<\/script>\n","response_headers":"<pre class=sf-dump id=sf-dump-316959693 data-indent-pad=\"  \"><span class=sf-dump-note>array:5<\/span> [<samp data-depth=1 class=sf-dump-expanded>\n  \"<span class=sf-dump-key>cache-control<\/span>\" => <span class=sf-dump-note>array:1<\/span> [<samp data-depth=2 class=sf-dump-compact>\n    <span class=sf-dump-index>0<\/span> => \"<span class=sf-dump-str title=\"17 characters\">no-cache, private<\/span>\"\n  <\/samp>]\n  \"<span class=sf-dump-key>date<\/span>\" => <span class=sf-dump-note>array:1<\/span> [<samp data-depth=2 class=sf-dump-compact>\n    <span class=sf-dump-index>0<\/span> => \"<span class=sf-dump-str title=\"29 characters\">Tue, 18 Jun 2024 11:53:06 GMT<\/span>\"\n  <\/samp>]\n  \"<span class=sf-dump-key>content-type<\/span>\" => <span class=sf-dump-note>array:1<\/span> [<samp data-depth=2 class=sf-dump-compact>\n    <span class=sf-dump-index>0<\/span> => \"<span class=sf-dump-str title=\"16 characters\">application\/json<\/span>\"\n  <\/samp>]\n  \"<span class=sf-dump-key>x-ratelimit-limit<\/span>\" => <span class=sf-dump-note>array:1<\/span> [<samp data-depth=2 class=sf-dump-compact>\n    <span class=sf-dump-index>0<\/span> => <span class=sf-dump-num>60<\/span>\n  <\/samp>]\n  \"<span class=sf-dump-key>x-ratelimit-remaining<\/span>\" => <span class=sf-dump-note>array:1<\/span> [<samp data-depth=2 class=sf-dump-compact>\n    <span class=sf-dump-index>0<\/span> => <span class=sf-dump-num>50<\/span>\n  <\/samp>]\n<\/samp>]\n<\/pre><script>Sfdump(\"sf-dump-316959693\", {\"maxDepth\":0})<\/script>\n","session_attributes":"<pre class=sf-dump id=sf-dump-373312687 data-indent-pad=\"  \">[]\n<\/pre><script>Sfdump(\"sf-dump-373312687\", {\"maxDepth\":0})<\/script>\n"}}