You need to login to view this feature
This address will be removed from this list
| 1 x Application (57.97%) | 91.86ms |
| 1 x Booting (42.02%) | 66.59ms |
english
You have saved 
select * from `business_settings` where (`type` = 'recaptcha') limit 1| Bindings |
|
| Backtrace |
|
select * from `business_settings` where (`type` = 'social_login') limit 1| Bindings |
|
| Backtrace |
|
select * from `business_settings` where (`type` = 'recaptcha') limit 1| Bindings |
|
| Backtrace |
|
select * from `business_settings` where (`type` = 'google_tag_manager_id') limit 1| Bindings |
|
| Backtrace |
|
select * from `business_settings` where (`type` = 'pixel_analytics') limit 1| Bindings |
|
| Backtrace |
|
select * from `shipping_addresses` where `id` is null limit 1| Backtrace |
|
select * from `countries`| Backtrace |
|
select * from `states` where `country_id` = 101 order by `name` asc| Bindings |
|
| Backtrace |
|
select * from `cities` where `state_id` is null order by `name` asc| Backtrace |
|
select * from `business_settings` where (`type` = 'map_api_key') limit 1| Bindings |
|
| Backtrace |
|
select * from `business_settings` where (`type` = 'announcement') limit 1| Bindings |
|
| Backtrace |
|
select `cart_group_id` from `carts` where (`customer_id` = 0 and `is_guest` = 1) group by `cart_group_id`| Bindings |
|
| Backtrace |
|
select * from `carts` where exists (select *, (select count(*) from `reviews` where `products`.`id` = `reviews`.`product_id` and `delivery_man_id` is null and `status` = 1) as `reviews_count` from `products` where `carts`.`product_id` = `products`.`id` and exists (select * from `categories` where `products`.`category_id` = `categories`.`id` and `status` = 1) and `status` = 1) and `cart_group_id` in ('guest-6MjsR-1716359425')| Bindings |
|
| Backtrace |
|
select `cart_group_id` from `carts` where (`customer_id` = 0 and `is_guest` = 1) group by `cart_group_id`| Bindings |
|
| Backtrace |
|
select * from `carts` where exists (select *, (select count(*) from `reviews` where `products`.`id` = `reviews`.`product_id` and `delivery_man_id` is null and `status` = 1) as `reviews_count` from `products` where `carts`.`product_id` = `products`.`id` and exists (select * from `categories` where `products`.`category_id` = `categories`.`id` and `status` = 1) and `status` = 1) and `cart_group_id` in ('guest-6MjsR-1716359425')| Bindings |
|
| Backtrace |
|
select * from `business_settings` where (`type` = 'currency_symbol_position') limit 1| Bindings |
|
| Backtrace |
|
select `products`.*, (select count(*) from `reviews` where `products`.`id` = `reviews`.`product_id` and `delivery_man_id` is null and `status` = 1) as `reviews_count` from `products` where `products`.`id` = 15 limit 1| Bindings |
|
| Backtrace |
|
select * from `translations` where `translations`.`translationable_id` in (15) and `translations`.`translationable_type` = 'App\Models\Product' and `locale` = 'en'| Bindings |
|
| Backtrace |
|
select * from `reviews` where `reviews`.`product_id` in (15) and `delivery_man_id` is null and `status` = 1| Bindings |
|
| Backtrace |
|
select `products`.*, (select count(*) from `reviews` where `products`.`id` = `reviews`.`product_id` and `delivery_man_id` is null and `status` = 1) as `reviews_count` from `products` where `products`.`id` = 1 limit 1| Bindings |
|
| Backtrace |
|
select * from `translations` where `translations`.`translationable_id` in (1) and `translations`.`translationable_type` = 'App\Models\Product' and `locale` = 'en'| Bindings |
|
| Backtrace |
|
select * from `reviews` where `reviews`.`product_id` in (1) and `delivery_man_id` is null and `status` = 1| Bindings |
|
| Backtrace |
|
select * from `business_settings` where (`type` = 'free_delivery_status') limit 1| Bindings |
|
| Backtrace |
|
select * from `business_settings` where (`type` = 'free_delivery_responsibility') limit 1| Bindings |
|
| Backtrace |
|
select * from `business_settings` where (`type` = 'free_delivery_over_amount') limit 1| Bindings |
|
| Backtrace |
|
select * from `business_settings` where (`type` = 'free_delivery_over_amount_seller') limit 1| Bindings |
|
| Backtrace |
|
select count(*) as aggregate from `categories` where `position` = 0 and `status` = 1| Bindings |
|
| Backtrace |
|
select * from `categories` where `position` = 0 and `status` = 1 order by `priority` asc limit 11 offset 0| Bindings |
|
| Backtrace |
|
select * from `categories` where `categories`.`parent_id` in (1, 2, 3, 4, 5, 6, 7, 8) order by `priority` asc| Backtrace |
|
select * from `categories` where `categories`.`parent_id` in (15) order by `priority` asc| Backtrace |
|
select * from `translations` where `translations`.`translationable_id` in (16) and `translations`.`translationable_type` = 'App\Models\Category' and `locale` = 'en'| Bindings |
|
| Backtrace |
|
select * from `translations` where `translations`.`translationable_id` in (15) and `translations`.`translationable_type` = 'App\Models\Category' and `locale` = 'en'| Bindings |
|
| Backtrace |
|
select * from `translations` where `translations`.`translationable_id` in (1, 2, 3, 4, 5, 6, 7, 8) and `translations`.`translationable_type` = 'App\Models\Category' and `locale` = 'en'| Bindings |
|
| Backtrace |
|
select * from `business_settings` where (`type` = 'business_mode') limit 1| Bindings |
|
| Backtrace |
|
select * from `business_settings` where (`type` = 'business_mode') limit 1| Bindings |
|
| Backtrace |
|
select `brands`.*, (select count(*) from `products` where `brands`.`id` = `products`.`brand_id` and ((`added_by` = 'admin') and exists (select * from `brands` where `products`.`brand_id` = `brands`.`id` and (`status` = 1)) and (`status` = 1) and (`request_status` = 1) or (`brand_id` is null and `status` = 1)) and (exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and (`status` = 'approved')) or ((`added_by` = 'admin' and `status` = 1))) and `product_type` in ('physical')) as `brand_products_count` from `brands` where `status` = 1 and exists (select *, (select count(*) from `reviews` where `products`.`id` = `reviews`.`product_id` and `delivery_man_id` is null and `status` = 1) as `reviews_count` from `products` where `brands`.`id` = `products`.`brand_id` and exists (select * from `categories` where `products`.`category_id` = `categories`.`id` and `status` = 1) and ((`added_by` = 'admin') and exists (select * from `brands` where `products`.`brand_id` = `brands`.`id` and (`status` = 1)) and (`status` = 1) and (`request_status` = 1) or (`brand_id` is null and `status` = 1)) and (exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and (`status` = 'approved')) or ((`added_by` = 'admin' and `status` = 1))) and `product_type` in ('physical')) order by `created_at` desc| Bindings |
|
| Backtrace |
|
select * from `translations` where `translations`.`translationable_id` in (1) and `translations`.`translationable_type` = 'App\Models\Brand' and `locale` = 'en'| Bindings |
|
| Backtrace |
|
select * from `business_settings` where (`type` = 'business_mode') limit 1| Bindings |
|
| Backtrace |
|
select count(*) as aggregate from `products` where ((`added_by` = 'admin') and exists (select * from `brands` where `products`.`brand_id` = `brands`.`id` and (`status` = 1)) and (`status` = 1) and (`request_status` = 1) or (`brand_id` is null and `status` = 1)) and (exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and (`status` = 'approved')) or ((`added_by` = 'admin' and `status` = 1))) and `product_type` in ('physical') and `discount` != 0| Bindings |
|
| Backtrace |
|
select * from `business_settings` where (`type` = 'business_mode') limit 1| Bindings |
|
| Backtrace |
|
select * from `business_settings` where (`type` = 'loader_gif') limit 1| Bindings |
|
| Backtrace |
|
select * from `flash_deals` where exists (select * from `flash_deal_products` where `flash_deals`.`id` = `flash_deal_products`.`flash_deal_id` and exists (select *, (select count(*) from `reviews` where `products`.`id` = `reviews`.`product_id` and `delivery_man_id` is null and `status` = 1) as `reviews_count` from `products` where `flash_deal_products`.`product_id` = `products`.`id` and exists (select * from `categories` where `products`.`category_id` = `categories`.`id` and `status` = 1))) and (`status` = 1 and `deal_type` = 'flash_deal') and date(`start_date`) <= '2025-05-05' and date(`end_date`) >= '2025-05-05' limit 1| Bindings |
|
| Backtrace |
|
select * from `business_settings` where (`type` = 'refund-policy') limit 1| Bindings |
|
| Backtrace |
|
select * from `business_settings` where (`type` = 'return-policy') limit 1| Bindings |
|
| Backtrace |
|
select * from `business_settings` where (`type` = 'cancellation-policy') limit 1| Bindings |
|
| Backtrace |
|
select * from `business_settings` where (`type` = 'company_phone') limit 1| Bindings |
|
| Backtrace |
|
select * from `business_settings` where (`type` = 'company_email') limit 1| Bindings |
|
| Backtrace |
|
select * from `business_settings` where (`type` = 'shop_address') limit 1| Bindings |
|
| Backtrace |
|
select * from `business_settings` where (`type` = 'whatsapp') limit 1| Bindings |
|
| Backtrace |
|
200
[]
[]
0 of 0array:16 [▼ "cookie" => array:1 [▶ 0 => "XSRF-TOKEN=eyJpdiI6ImJZSkRWazJlS1laSkZmbmxyalZ4SGc9PSIsInZhbHVlIjoiRU1hWDJ6SWROc0llUFNsWG5HTlM4b3k2Q25zZWF5UHhzY210VFpnaWI0bk5od3hma01jcExFbFJIYWZzSHZYVEFSbUU0SkQ5d0lJdXJPNTZxaEtMYXczYWJOaUxiRi9BV042Zmx3RmJ5NUFKekd4NHNxV05NUWJSK2hMUmJUT2ciLCJtYWMiOiJlZmViZjBhYWUxZmY5ODFmYWE2MDQzZmRkNmQxOTE0OWI4NGYxODE5ZWI5NzE1YzUyM2UyODM5ZGYzNzk3NDg0IiwidGFnIjoiIn0%3D; laravel_session=eyJpdiI6Im9MdFZvM1AraXJEdE9sVHR2cUg3Q3c9PSIsInZhbHVlIjoiNGFlQ25IYm5KTkYrMjRqVDVkdEs2cDVHNGh1SC9Xd3RjbW5Sc3pNUy82NnRXc0VZd0VVcllWeXAva2YwejlsWDBmM2Z0WXBKMzF3TWc1czlTOTB3VmNXZXZhVGdvcnJnWktMYmlTc1NyZ3g4dHEzMThmZnBBRDg2Wjh0WEV5NmsiLCJtYWMiOiIwZDM3NzJjMzQzY2QyODE5MWI3OTczOGU2OGZiZjFmZDVhYzVmYjlkNWRiMThkMjQ1MzI1MmIwMWRkZDg5ZWE3IiwidGFnIjoiIn0%3D ◀XSRF-TOKEN=eyJpdiI6ImJZSkRWazJlS1laSkZmbmxyalZ4SGc9PSIsInZhbHVlIjoiRU1hWDJ6SWROc0llUFNsWG5HTlM4b3k2Q25zZWF5UHhzY210VFpnaWI0bk5od3hma01jcExFbFJIYWZzSHZYVEFSbUU0S ▶" ] "accept-encoding" => array:1 [▶ 0 => "gzip, deflate, br, zstd" ] "sec-fetch-dest" => array:1 [▶ 0 => "document" ] "sec-fetch-user" => array:1 [▶ 0 => "?1" ] "sec-fetch-mode" => array:1 [▶ 0 => "navigate" ] "sec-fetch-site" => array:1 [▶ 0 => "none" ] "accept" => array:1 [▶ 0 => "text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.7" ] "user-agent" => array:1 [▶ 0 => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)" ] "upgrade-insecure-requests" => array:1 [▶ 0 => "1" ] "sec-ch-ua-platform" => array:1 [▶ 0 => ""Windows"" ] "sec-ch-ua-mobile" => array:1 [▶ 0 => "?0" ] "sec-ch-ua" => array:1 [▶ 0 => ""Chromium";v="130", "HeadlessChrome";v="130", "Not?A_Brand";v="99"" ] "cache-control" => array:1 [▶ 0 => "no-cache" ] "pragma" => array:1 [▶ 0 => "no-cache" ] "connection" => array:1 [▶ 0 => "keep-alive" ] "host" => array:1 [▶ 0 => "shankar-beta.mydemoapp.us" ] ]
0 of 0array:2 [▼ "XSRF-TOKEN" => "QXoielq61yT1D3AosYQnBSgtHC1QRSQxOkUu9UKb" "laravel_session" => "4AlkOdrfhiKj30wkWgGSwIdXiXHetyAgYQTilXir" ]
0 of 0array:5 [▼ "content-type" => array:1 [▶ 0 => "text/html; charset=UTF-8" ] "cache-control" => array:1 [▶ 0 => "no-cache, private" ] "date" => array:1 [▶ 0 => "Mon, 05 May 2025 15:54:30 GMT" ] "set-cookie" => array:2 [▶ 0 => "XSRF-TOKEN=eyJpdiI6IndjMTFhZGJsTFl0b1o5ZCtrSjBRUmc9PSIsInZhbHVlIjoiWklpcWdtRDl1RDhubWlPSGJObnhBcDhxOWdzS3BSbUh0MThkUkxLVDdMUlFMK0JDU1JKU3F3azVaZjRjeDlOaEZZYmJDRzcwclhERGwxVmJPTTFmaUlya3dzSTd0MzkrYVRqY250MFdLRTV3cERvUlA2ZHZQcG5aQ1dNVnBueEciLCJtYWMiOiI2NTUwMjQwNjMxNjhlMDNlMjdmMTE2NmM1NzJiYjYzNjg4NjM3OGI2MmQ2MmE4MDBkOGZlNDFmNWZmYmI1OTJhIiwidGFnIjoiIn0%3D; expires=Mon, 05 May 2025 17:54:30 GMT; Max-Age=7200; path=/ ◀XSRF-TOKEN=eyJpdiI6IndjMTFhZGJsTFl0b1o5ZCtrSjBRUmc9PSIsInZhbHVlIjoiWklpcWdtRDl1RDhubWlPSGJObnhBcDhxOWdzS3BSbUh0MThkUkxLVDdMUlFMK0JDU1JKU3F3azVaZjRjeDlOaEZZYmJDR ▶" 1 => "laravel_session=eyJpdiI6IklLUTgzR3JadWpJY1NpSktNUlcrZkE9PSIsInZhbHVlIjoiRnRMSCtDNUVUdGc3S3B0ZlQ2cW1KYTAzOTByNC9kTEVhaWRWdjd0RkxBM1A0WXBndUtTS0FYL2tBLzZodGdVTDB2ZGF1a2JqLzVldGs0WFJiaWlpQ3czelltRjZmaC9xRzRUbEFUa3RMRzMyYVBUR2lVZGxzSVcvZWFlc0xjY08iLCJtYWMiOiIxZjQ4M2ViYzk4NDkzNDA0MzNlNGMxOWI5MDY4YzU2ZTQ2MjY2MzY5ODBkZThjYTNhNmFmYzg0NDBmMTIxYmM1IiwidGFnIjoiIn0%3D; expires=Mon, 05 May 2025 17:54:30 GMT; Max-Age=7200; path=/; httponly ◀laravel_session=eyJpdiI6IklLUTgzR3JadWpJY1NpSktNUlcrZkE9PSIsInZhbHVlIjoiRnRMSCtDNUVUdGc3S3B0ZlQ2cW1KYTAzOTByNC9kTEVhaWRWdjd0RkxBM1A0WXBndUtTS0FYL2tBLzZodGdVTDB2 ▶" ] "Set-Cookie" => array:2 [▶ 0 => "XSRF-TOKEN=eyJpdiI6IndjMTFhZGJsTFl0b1o5ZCtrSjBRUmc9PSIsInZhbHVlIjoiWklpcWdtRDl1RDhubWlPSGJObnhBcDhxOWdzS3BSbUh0MThkUkxLVDdMUlFMK0JDU1JKU3F3azVaZjRjeDlOaEZZYmJDRzcwclhERGwxVmJPTTFmaUlya3dzSTd0MzkrYVRqY250MFdLRTV3cERvUlA2ZHZQcG5aQ1dNVnBueEciLCJtYWMiOiI2NTUwMjQwNjMxNjhlMDNlMjdmMTE2NmM1NzJiYjYzNjg4NjM3OGI2MmQ2MmE4MDBkOGZlNDFmNWZmYmI1OTJhIiwidGFnIjoiIn0%3D; expires=Mon, 05-May-2025 17:54:30 GMT; path=/ ◀XSRF-TOKEN=eyJpdiI6IndjMTFhZGJsTFl0b1o5ZCtrSjBRUmc9PSIsInZhbHVlIjoiWklpcWdtRDl1RDhubWlPSGJObnhBcDhxOWdzS3BSbUh0MThkUkxLVDdMUlFMK0JDU1JKU3F3azVaZjRjeDlOaEZZYmJDR ▶" 1 => "laravel_session=eyJpdiI6IklLUTgzR3JadWpJY1NpSktNUlcrZkE9PSIsInZhbHVlIjoiRnRMSCtDNUVUdGc3S3B0ZlQ2cW1KYTAzOTByNC9kTEVhaWRWdjd0RkxBM1A0WXBndUtTS0FYL2tBLzZodGdVTDB2ZGF1a2JqLzVldGs0WFJiaWlpQ3czelltRjZmaC9xRzRUbEFUa3RMRzMyYVBUR2lVZGxzSVcvZWFlc0xjY08iLCJtYWMiOiIxZjQ4M2ViYzk4NDkzNDA0MzNlNGMxOWI5MDY4YzU2ZTQ2MjY2MzY5ODBkZThjYTNhNmFmYzg0NDBmMTIxYmM1IiwidGFnIjoiIn0%3D; expires=Mon, 05-May-2025 17:54:30 GMT; path=/; httponly ◀laravel_session=eyJpdiI6IklLUTgzR3JadWpJY1NpSktNUlcrZkE9PSIsInZhbHVlIjoiRnRMSCtDNUVUdGc3S3B0ZlQ2cW1KYTAzOTByNC9kTEVhaWRWdjd0RkxBM1A0WXBndUtTS0FYL2tBLzZodGdVTDB2 ▶" ] ]
0 of 0array:19 [▼ "decimal_point_settings" => 0 "product_brand" => 1 "digital_product" => 0 "currency_model" => "single_currency" "language" => array:2 [▶ 0 => array:6 [▶ "id" => "1" "name" => "english" "direction" => "ltr" "code" => "en" "status" => 1 "default" => true ] 1 => array:6 [▶ "id" => 2 "name" => "Hindi" "direction" => "ltr" "code" => "in" "status" => 1 "default" => false ] ] "local" => "en" "direction" => "ltr" "system_default_currency" => 3 "system_default_currency_info" => App\Models\Currency {#3007 ▶ #connection: "mysql" #table: "currencies" #primaryKey: "id" #keyType: "int" +incrementing: true #with: [] #withCount: [] +preventsLazyLoading: false #perPage: 15 +exists: true +wasRecentlyCreated: false #escapeWhenCastingToString: false #attributes: array:8 [▶ "id" => 3 "name" => "Indian Rupi" "symbol" => "₹" "code" => "INR" "exchange_rate" => "60" "status" => 1 "created_at" => "2020-10-15 22:53:04" "updated_at" => "2021-06-04 23:56:38" ] #original: array:8 [▶ "id" => 3 "name" => "Indian Rupi" "symbol" => "₹" "code" => "INR" "exchange_rate" => "60" "status" => 1 "created_at" => "2020-10-15 22:53:04" "updated_at" => "2021-06-04 23:56:38" ] #changes: [] #casts: array:4 [▶ "id" => "integer" "status" => "boolean" "created_at" => "datetime" "updated_at" => "datetime" ] #classCastCache: [] #attributeCastCache: [] #dateFormat: null #appends: [] #dispatchesEvents: [] #observables: [] #relations: [] #touches: [] +timestamps: true +usesUniqueIds: false #hidden: [] #visible: [] #fillable: array:5 [▶ 0 => "name" 1 => "symbol" 2 => "code" 3 => "exchange_rate" 4 => "status" ] #guarded: array:1 [▶ 0 => "*" ] } "currency_code" => "INR" "currency_symbol" => "₹" "currency_exchange_rate" => "60" "_token" => "QXoielq61yT1D3AosYQnBSgtHC1QRSQxOkUu9UKb" "_flash" => array:2 [▶ "new" => [] "old" => [] ] "_previous" => array:1 [▶ "url" => "https://shankar-beta.mydemoapp.us/customer/auth/login" ] "keep_return_url" => "https://shankar-beta.mydemoapp.us/wishlists" "currency_symbol_position" => "left" "company_email" => "info@shankarmasala.com" "PHPDEBUGBAR_STACK_DATA" => [] ]
