File: //var/www/html/punjabcabs/storage/debugbar/ece5f80dcd689bb81986611da4786181.json
{"__meta":{"id":"ece5f80dcd689bb81986611da4786181","datetime":"2021-12-16 23:16:45","utime":1639657005.9523,"method":"GET","uri":"\/api\/user\/help","ip":"115.96.136.220"},"php":{"version":"5.6.40","interface":"apache2handler"},"messages":{"count":0,"messages":[]},"time":{"start":1639657005.815,"end":1639657005.9523,"duration":0.13730788230896,"duration_str":"137.31ms","measures":[{"label":"Booting","start":1639657005.815,"relative_start":0,"end":1639657005.9285,"relative_end":1639657005.9285,"duration":0.11346101760864,"duration_str":"113.46ms","params":[],"collector":null},{"label":"Application","start":1639657005.9182,"relative_start":0.10324096679688,"end":1639657005.9523,"relative_end":8.1062316894531e-6,"duration":0.034075021743774,"duration_str":"34.08ms","params":[],"collector":null}]},"memory":{"peak_usage":7340032,"peak_usage_str":"7MB"},"exceptions":{"count":0,"exceptions":[]},"views":{"nb_templates":0,"templates":[]},"route":{"uri":"GET api\/user\/help","middleware":"api, auth:api","controller":"App\\Http\\Controllers\\UserApiController@help_details","namespace":"App\\Http\\Controllers","prefix":"api\/user","where":[],"file":"app\/Http\/Controllers\/UserApiController.php:1520-1536"},"queries":{"nb_statements":5,"nb_failed_statements":0,"accumulated_duration":0.0027,"accumulated_duration_str":"2.7ms","statements":[{"sql":"select exists(select * from `oauth_access_tokens` where `id` = '08e0aa8566d328e02d918a43081f5d9e9fa0a6540c4a16404b00210526269c986652928fc03d128e' and `revoked` = '0') as `exists`","type":"query","params":[],"bindings":["08e0aa8566d328e02d918a43081f5d9e9fa0a6540c4a16404b00210526269c986652928fc03d128e","0"],"hints":[],"backtrace":[{"index":8,"namespace":null,"name":"\/vendor\/laravel\/passport\/src\/Bridge\/AccessTokenRepository.php","line":85},{"index":9,"namespace":null,"name":"\/vendor\/league\/oauth2-server\/src\/AuthorizationValidators\/BearerTokenValidator.php","line":65},{"index":10,"namespace":null,"name":"\/vendor\/league\/oauth2-server\/src\/ResourceServer.php","line":82},{"index":11,"namespace":null,"name":"\/vendor\/laravel\/passport\/src\/Guards\/TokenGuard.php","line":110},{"index":12,"namespace":null,"name":"\/vendor\/laravel\/passport\/src\/Guards\/TokenGuard.php","line":90},{"index":13,"namespace":null,"name":"\/vendor\/laravel\/passport\/src\/PassportServiceProvider.php","line":255},{"index":21,"namespace":"middleware","name":"localization","line":23},{"index":39,"namespace":null,"name":"\/public\/index.php","line":54}],"duration":0.00123,"duration_str":"1.23ms","stmt_id":"\/vendor\/laravel\/passport\/src\/Bridge\/AccessTokenRepository.php:85","connection":"punjabcabs"},{"sql":"select * from `users` where `users`.`id` = '55' limit 1","type":"query","params":[],"bindings":["55"],"hints":["Use <code>SELECT *<\/code> only if you need all columns from table","<code>LIMIT<\/code> without <code>ORDER BY<\/code> causes non-deterministic results, depending on the query execution plan"],"backtrace":[{"index":14,"namespace":null,"name":"\/vendor\/laravel\/passport\/src\/Guards\/TokenGuard.php","line":119},{"index":15,"namespace":null,"name":"\/vendor\/laravel\/passport\/src\/Guards\/TokenGuard.php","line":90},{"index":16,"namespace":null,"name":"\/vendor\/laravel\/passport\/src\/PassportServiceProvider.php","line":255},{"index":24,"namespace":"middleware","name":"localization","line":23},{"index":42,"namespace":null,"name":"\/public\/index.php","line":54}],"duration":0.00045,"duration_str":"450\u03bcs","stmt_id":"\/vendor\/laravel\/passport\/src\/Guards\/TokenGuard.php:119","connection":"punjabcabs"},{"sql":"select * from `oauth_access_tokens` where `oauth_access_tokens`.`id` = '08e0aa8566d328e02d918a43081f5d9e9fa0a6540c4a16404b00210526269c986652928fc03d128e' limit 1","type":"query","params":[],"bindings":["08e0aa8566d328e02d918a43081f5d9e9fa0a6540c4a16404b00210526269c986652928fc03d128e"],"hints":["Use <code>SELECT *<\/code> only if you need all columns from table","<code>LIMIT<\/code> without <code>ORDER BY<\/code> causes non-deterministic results, depending on the query execution plan"],"backtrace":[{"index":16,"namespace":null,"name":"\/vendor\/laravel\/passport\/src\/TokenRepository.php","line":18},{"index":17,"namespace":null,"name":"\/vendor\/laravel\/passport\/src\/TokenRepository.php","line":18},{"index":18,"namespace":null,"name":"\/vendor\/laravel\/passport\/src\/Guards\/TokenGuard.php","line":128},{"index":19,"namespace":null,"name":"\/vendor\/laravel\/passport\/src\/Guards\/TokenGuard.php","line":90},{"index":20,"namespace":null,"name":"\/vendor\/laravel\/passport\/src\/PassportServiceProvider.php","line":255},{"index":28,"namespace":"middleware","name":"localization","line":23},{"index":46,"namespace":null,"name":"\/public\/index.php","line":54}],"duration":0.00032,"duration_str":"320\u03bcs","stmt_id":"\/vendor\/laravel\/passport\/src\/TokenRepository.php:18","connection":"punjabcabs"},{"sql":"select exists(select * from `oauth_clients` where `id` = '2' and `revoked` = '1') as `exists`","type":"query","params":[],"bindings":["2","1"],"hints":[],"backtrace":[{"index":9,"namespace":null,"name":"\/vendor\/laravel\/passport\/src\/ClientRepository.php","line":164},{"index":10,"namespace":null,"name":"\/vendor\/laravel\/passport\/src\/ClientRepository.php","line":164},{"index":11,"namespace":null,"name":"\/vendor\/laravel\/passport\/src\/Guards\/TokenGuard.php","line":135},{"index":12,"namespace":null,"name":"\/vendor\/laravel\/passport\/src\/Guards\/TokenGuard.php","line":90},{"index":13,"namespace":null,"name":"\/vendor\/laravel\/passport\/src\/PassportServiceProvider.php","line":255},{"index":21,"namespace":"middleware","name":"localization","line":23},{"index":39,"namespace":null,"name":"\/public\/index.php","line":54}],"duration":0.00029,"duration_str":"290\u03bcs","stmt_id":"\/vendor\/laravel\/passport\/src\/ClientRepository.php:164","connection":"punjabcabs"},{"sql":"select * from `settings`","type":"query","params":[],"bindings":[],"hints":["Use <code>SELECT *<\/code> only if you need all columns from table","The <code>SELECT<\/code> statement has no <code>WHERE<\/code> clause and could examine many more rows than intended"],"backtrace":[{"index":9,"namespace":null,"name":"\/vendor\/anlutro\/l4-settings\/src\/DatabaseSettingStore.php","line":189},{"index":10,"namespace":null,"name":"\/vendor\/anlutro\/l4-settings\/src\/SettingStore.php","line":144},{"index":11,"namespace":null,"name":"\/vendor\/anlutro\/l4-settings\/src\/SettingStore.php","line":45},{"index":15,"namespace":null,"name":"\/app\/Http\/Controllers\/UserApiController.php","line":1526},{"index":16,"namespace":null,"name":"\/app\/Http\/Controllers\/UserApiController.php","line":1526},{"index":30,"namespace":"middleware","name":"localization","line":23},{"index":48,"namespace":null,"name":"\/public\/index.php","line":54}],"duration":0.00041,"duration_str":"410\u03bcs","stmt_id":"\/vendor\/anlutro\/l4-settings\/src\/DatabaseSettingStore.php:189","connection":"punjabcabs"}]},"swiftmailer_mails":{"count":0,"mails":[]},"auth":{"guards":{"account":"array:2 [\n \"name\" => \"Guest\"\n \"user\" => array:1 [\n \"guest\" => true\n ]\n]","fleet":"array:2 [\n \"name\" => \"Guest\"\n \"user\" => array:1 [\n \"guest\" => true\n ]\n]","dispatcher":"array:2 [\n \"name\" => \"Guest\"\n \"user\" => array:1 [\n \"guest\" => true\n ]\n]","provider":"array:2 [\n \"name\" => \"Guest\"\n \"user\" => array:1 [\n \"guest\" => true\n ]\n]","admin":"array:2 [\n \"name\" => \"Guest\"\n \"user\" => array:1 [\n \"guest\" => true\n ]\n]","web":"array:2 [\n \"name\" => \"Guest\"\n \"user\" => array:1 [\n \"guest\" => true\n ]\n]","api":"array:2 [\n \"name\" => \"lovedeepkhangura@gmail.com\"\n \"user\" => array:23 [\n \"id\" => 55\n \"first_name\" => \"lovedeep\"\n \"last_name\" => \"khangura\"\n \"payment_mode\" => \"CASH\"\n \"email\" => \"lovedeepkhangura@gmail.com\"\n \"mobile\" => \"+610401402766\"\n \"picture\" => \"user\/profile\/f5dafacfe331878be4f28b98a34d4d12.jpeg\"\n \"device_token\" => \"c0jppeHAuBk:APA91bHg7u1UPsQ2Q7tFmHsoWKouiQ2FFRnkQBd95fDNVgamhjA5UMfuVL6jDmCXH5VDoCPhHVB43c1kGou7YmMgMpxS9zZTRaKL1TUsNw-35td479fWmCSaJ9qXbdMiukr0XXxVrN5R\"\n \"device_id\" => \"6259273E-E361-4BCF-90D1-D6129DD0275B\"\n \"device_type\" => \"ios\"\n \"login_by\" => \"manual\"\n \"social_unique_id\" => null\n \"latitude\" => 22.57693353\n \"longitude\" => 88.46104211\n \"trip_status\" => 0\n \"stripe_cust_id\" => null\n \"wallet_balance\" => 0.0\n \"due_balance\" => 0.0\n \"due_trip\" => null\n \"rating\" => \"5.00\"\n \"cancel_points\" => 5\n \"favourite_driver\" => \"38\"\n \"otp\" => 0\n ]\n]","providerapi":"array:2 [\n \"name\" => \"Guest\"\n \"user\" => array:1 [\n \"guest\" => true\n ]\n]"},"names":"api: lovedeepkhangura@gmail.com"},"gate":{"count":0,"messages":[]},"session":[],"request":{"format":"html","content_type":"application\/json","status_text":"OK","status_code":"200","request_query":"[]","request_request":"[]","request_headers":"array:8 [\n \"authorization\" => array:1 [\n 0 => \"Bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJSUzI1NiIsImp0aSI6IjA4ZTBhYTg1NjZkMzI4ZTAyZDkxOGE0MzA4MWY1ZDllOWZhMGE2NTQwYzRhMTY0MDRiMDAyMTA1MjYyNjljOTg2NjUyOTI4ZmMwM2QxMjhlIn0.eyJhdWQiOiIyIiwianRpIjoiMDhlMGFhODU2NmQzMjhlMDJkOTE4YTQzMDgxZjVkOWU5ZmEwYTY1NDBjNGExNjQwNGIwMDIxMDUyNjI2OWM5ODY2NTI5MjhmYzAzZDEyOGUiLCJpYXQiOjE2Mzk2NTY5ODEsIm5iZiI6MTYzOTY1Njk4MSwiZXhwIjoxNjQwOTUyOTgxLCJzdWIiOiI1NSIsInNjb3BlcyI6W119.AWtugjEHUjOUjxoE_O1KJGf_do7K2kgQrBb0dUrlyRE_QQf00BAt-wFNqxkFvSKnHOJUzkpsx8B8wY4Uk4FKrwfxXFQ3o-14KC1RtWTn4eiTjC1RPJDCKQ4jK3wJa2M7mK71SduQX5fPMzd6psdDKWhW3SKS0kMyejPCsK1gSh70fVPPDqzagBz9FWE8aq-T9te1dl5xWyPEGL2YJ9QIhYXcqfH-LAaXcWdFYUu0_clwG6BW3i0E_5uyArqghTy4BCg0zy4ldF5sbDPgUcqhqX_2s82d3u6nFkezsKIVFcXwSmkOljhRSoJwyZqWu3nUQygG3qwq_8ntTvJuEh92bprFHJ5xzC4-JFM8yhiiE44nEk3TbdyDy2MlkRgEZVQzn5Q34ttcIMhf4yiZejveNMUM477k8LUBP1vDldSuYP7gWguFH5xlzZPgwDLJ4Yx6nBhQEsFa1EwYHzeJ_1IC6kVSWUQ-OQvnYi6TLS5hQMpXMDzawQpvQrsxE2pkK3K6r4YsaHKcQ-XJs4bNvY4nDgkYi8l2A35Zk3ezAU5JmDdu0YOJ5EDcwYLptjDMGBCEb9LoUp-CD3YqlR8D0HoFJyUkW1H3UxKl_ZMRZjVygFBz0QK5X7U65YddaA13ymu31vGfDKiJaT0Oay-4O7SU2qff7K0QchLzschA3HFZLtg\"\n ]\n \"host\" => array:1 [\n 0 => \"www.punjabcabs.com.au\"\n ]\n \"accept-encoding\" => array:1 [\n 0 => \"gzip, deflate, br\"\n ]\n \"connection\" => array:1 [\n 0 => \"keep-alive\"\n ]\n \"accept\" => array:1 [\n 0 => \"*\/*\"\n ]\n \"user-agent\" => array:1 [\n 0 => \"PunjabCabs\/1.3 (iPhone; iOS 15.1.1; Scale\/3.00)\"\n ]\n \"accept-language\" => array:1 [\n 0 => \"en-GB;q=1, en-IN;q=0.9, hi-IN;q=0.8, bn-IN;q=0.7\"\n ]\n \"x-requested-with\" => array:1 [\n 0 => \"XMLHttpRequest\"\n ]\n]","request_server":"array:41 [\n \"REDIRECT_SCRIPT_URL\" => \"\/api\/user\/help\"\n \"REDIRECT_SCRIPT_URI\" => \"https:\/\/www.punjabcabs.com.au\/api\/user\/help\"\n \"REDIRECT_HTTPS\" => \"on\"\n \"REDIRECT_SSL_TLS_SNI\" => \"www.punjabcabs.com.au\"\n \"REDIRECT_STATUS\" => \"200\"\n \"SCRIPT_URL\" => \"\/api\/user\/help\"\n \"SCRIPT_URI\" => \"https:\/\/www.punjabcabs.com.au\/api\/user\/help\"\n \"HTTP_AUTHORIZATION\" => \"Bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJSUzI1NiIsImp0aSI6IjA4ZTBhYTg1NjZkMzI4ZTAyZDkxOGE0MzA4MWY1ZDllOWZhMGE2NTQwYzRhMTY0MDRiMDAyMTA1MjYyNjljOTg2NjUyOTI4ZmMwM2QxMjhlIn0.eyJhdWQiOiIyIiwianRpIjoiMDhlMGFhODU2NmQzMjhlMDJkOTE4YTQzMDgxZjVkOWU5ZmEwYTY1NDBjNGExNjQwNGIwMDIxMDUyNjI2OWM5ODY2NTI5MjhmYzAzZDEyOGUiLCJpYXQiOjE2Mzk2NTY5ODEsIm5iZiI6MTYzOTY1Njk4MSwiZXhwIjoxNjQwOTUyOTgxLCJzdWIiOiI1NSIsInNjb3BlcyI6W119.AWtugjEHUjOUjxoE_O1KJGf_do7K2kgQrBb0dUrlyRE_QQf00BAt-wFNqxkFvSKnHOJUzkpsx8B8wY4Uk4FKrwfxXFQ3o-14KC1RtWTn4eiTjC1RPJDCKQ4jK3wJa2M7mK71SduQX5fPMzd6psdDKWhW3SKS0kMyejPCsK1gSh70fVPPDqzagBz9FWE8aq-T9te1dl5xWyPEGL2YJ9QIhYXcqfH-LAaXcWdFYUu0_clwG6BW3i0E_5uyArqghTy4BCg0zy4ldF5sbDPgUcqhqX_2s82d3u6nFkezsKIVFcXwSmkOljhRSoJwyZqWu3nUQygG3qwq_8ntTvJuEh92bprFHJ5xzC4-JFM8yhiiE44nEk3TbdyDy2MlkRgEZVQzn5Q34ttcIMhf4yiZejveNMUM477k8LUBP1vDldSuYP7gWguFH5xlzZPgwDLJ4Yx6nBhQEsFa1EwYHzeJ_1IC6kVSWUQ-OQvnYi6TLS5hQMpXMDzawQpvQrsxE2pkK3K6r4YsaHKcQ-XJs4bNvY4nDgkYi8l2A35Zk3ezAU5JmDdu0YOJ5EDcwYLptjDMGBCEb9LoUp-CD3YqlR8D0HoFJyUkW1H3UxKl_ZMRZjVygFBz0QK5X7U65YddaA13ymu31vGfDKiJaT0Oay-4O7SU2qff7K0QchLzschA3HFZLtg\"\n \"HTTPS\" => \"on\"\n \"SSL_TLS_SNI\" => \"www.punjabcabs.com.au\"\n \"HTTP_HOST\" => \"www.punjabcabs.com.au\"\n \"HTTP_ACCEPT_ENCODING\" => \"gzip, deflate, br\"\n \"HTTP_CONNECTION\" => \"keep-alive\"\n \"HTTP_ACCEPT\" => \"*\/*\"\n \"HTTP_USER_AGENT\" => \"PunjabCabs\/1.3 (iPhone; iOS 15.1.1; Scale\/3.00)\"\n \"HTTP_ACCEPT_LANGUAGE\" => \"en-GB;q=1, en-IN;q=0.9, hi-IN;q=0.8, bn-IN;q=0.7\"\n \"HTTP_X_REQUESTED_WITH\" => \"XMLHttpRequest\"\n \"PATH\" => \"\/sbin:\/usr\/sbin:\/bin:\/usr\/bin\"\n \"SERVER_SIGNATURE\" => \"\"\n \"SERVER_SOFTWARE\" => \"Apache\/2.4.41 (Amazon) OpenSSL\/1.0.2k-fips PHP\/5.6.40\"\n \"SERVER_NAME\" => \"www.punjabcabs.com.au\"\n \"SERVER_ADDR\" => \"172.31.40.18\"\n \"SERVER_PORT\" => \"443\"\n \"REMOTE_ADDR\" => \"115.96.136.220\"\n \"DOCUMENT_ROOT\" => \"\/var\/www\/html\/punjabcabs\/public\"\n \"REQUEST_SCHEME\" => \"https\"\n \"CONTEXT_PREFIX\" => \"\"\n \"CONTEXT_DOCUMENT_ROOT\" => \"\/var\/www\/html\/punjabcabs\/public\"\n \"SERVER_ADMIN\" => \"root@localhost\"\n \"SCRIPT_FILENAME\" => \"\/var\/www\/html\/punjabcabs\/public\/index.php\"\n \"REMOTE_PORT\" => \"56296\"\n \"REDIRECT_URL\" => \"\/api\/user\/help\"\n \"GATEWAY_INTERFACE\" => \"CGI\/1.1\"\n \"SERVER_PROTOCOL\" => \"HTTP\/1.1\"\n \"REQUEST_METHOD\" => \"GET\"\n \"QUERY_STRING\" => \"\"\n \"REQUEST_URI\" => \"\/api\/user\/help\"\n \"SCRIPT_NAME\" => \"\/index.php\"\n \"PHP_SELF\" => \"\/index.php\"\n \"REQUEST_TIME_FLOAT\" => 1639657005.815\n \"REQUEST_TIME\" => 1639657005\n]","request_cookies":"[]","response_headers":"array:2 [\n \"cache-control\" => array:1 [\n 0 => \"no-cache\"\n ]\n \"content-type\" => array:1 [\n 0 => \"application\/json\"\n ]\n]","path_info":"\/api\/user\/help","session_attributes":"[]"}}