Find your favourite categories and products
You need to Sign in to view this feature
This address will be removed from this list
1 x Application (69.84%) | 1.12s |
1 x Booting (30.16%) | 485ms |
insert into `guest_users` (`ip_address`, `updated_at`, `created_at`) values ('3.129.59.71', '2025-05-23 19:19:55', '2025-05-23 19:19:55')
Bindings |
|
Backtrace |
|
select * from `robots_meta_contents` where (`page_name` = 'categories') limit 1
Bindings |
|
Backtrace |
|
select * from `robots_meta_contents` where (`page_name` = 'default') limit 1
Bindings |
|
Backtrace |
|
select `categories`.*, (select count(*) from `products` where `categories`.`id` = `products`.`category_id` and (`status` = 1) and (`request_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 ('digital', 'physical')) as `product_count` from `categories` where `position` = 0
Bindings |
|
Backtrace |
|
select `products`.*, (select count(*) from `order_details` where `products`.`id` = `order_details`.`product_id`) as `order_details_count` from `products` where `products`.`category_id` in (4, 18) and (`status` = 1) and (`request_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 ('digital', 'physical')
Bindings |
|
Backtrace |
|
select * from `translations` where `translations`.`translationable_id` in (29, 30, 31, 32, 33, 34, 35, 36, 37, 38, 39, 40, 41, 42, 43, 44, 45, 46, 47, 48, 49, 50, 51, 52, 53, 54, 55, 56, 57, 58, 59, 60, 61, 62, 63, 64, 65, 66, 67, 68, 71, 72, 73, 74, 75, 76, 78, 79, 80, 81, 82, 83, 84, 85, 86, 87, 88, 89, 90, 91, 92, 93, 94, 95, 96, 97, 98, 99, 100, 101, 102, 103, 104, 105, 106, 107, 109, 110, 111, 112, 113, 114, 115, 116, 117, 118, 119) and `translations`.`translationable_type` = 'App\\Models\\Product' and `locale` = 'en'
Bindings |
|
Backtrace |
|
select * from `reviews` where `reviews`.`product_id` in (29, 30, 31, 32, 33, 34, 35, 36, 37, 38, 39, 40, 41, 42, 43, 44, 45, 46, 47, 48, 49, 50, 51, 52, 53, 54, 55, 56, 57, 58, 59, 60, 61, 62, 63, 64, 65, 66, 67, 68, 71, 72, 73, 74, 75, 76, 78, 79, 80, 81, 82, 83, 84, 85, 86, 87, 88, 89, 90, 91, 92, 93, 94, 95, 96, 97, 98, 99, 100, 101, 102, 103, 104, 105, 106, 107, 109, 110, 111, 112, 113, 114, 115, 116, 117, 118, 119) and `delivery_man_id` is null and `status` = 1
Bindings |
|
Backtrace |
|
select `categories`.*, (select count(*) from `products` where `categories`.`id` = `products`.`sub_category_id`) as `sub_category_product_count` from `categories` where `categories`.`parent_id` in (4, 18) and `position` = 1 order by `priority` asc
Bindings |
|
Backtrace |
|
select `categories`.*, (select count(*) from `products` where `categories`.`id` = `products`.`sub_sub_category_id`) as `sub_sub_category_product_count` from `categories` where `categories`.`parent_id` in (5, 6, 7, 8, 9, 10, 11) and `position` = 2 order by `priority` asc
Bindings |
|
Backtrace |
|
select * from `translations` where `translations`.`translationable_id` in (17) and `translations`.`translationable_type` = 'App\\Models\\Category' and `locale` = 'en'
Bindings |
|
Backtrace |
|
select * from `translations` where `translations`.`translationable_id` in (5, 6, 7, 8, 9, 10, 11) and `translations`.`translationable_type` = 'App\\Models\\Category' and `locale` = 'en'
Bindings |
|
Backtrace |
|
select * from `translations` where `translations`.`translationable_id` in (4, 18) and `translations`.`translationable_type` = 'App\\Models\\Category' and `locale` = 'en'
Bindings |
|
Backtrace |
|
select * from `currencies` where `status` = 1
Bindings |
|
Backtrace |
|
select `cart_group_id` from `carts` where exists (select * from `products` where `carts`.`product_id` = `products`.`id` and (`status` = 1) and (`request_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 ('digital', 'physical') and `status` = 1) and (`customer_id` = 17404 and `is_guest` = 1) group by `cart_group_id`
Bindings |
|
Backtrace |
|
select * from `carts` where exists (select * from `products` where `carts`.`product_id` = `products`.`id` and (`status` = 1) and (`request_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 ('digital', 'physical') and `status` = 1) and 0 = 1
Bindings |
|
Backtrace |
|
select `cart_group_id` from `carts` where exists (select * from `products` where `carts`.`product_id` = `products`.`id` and (`status` = 1) and (`request_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 ('digital', 'physical') and `status` = 1) and (`customer_id` = 17404 and `is_guest` = 1) group by `cart_group_id`
Bindings |
|
Backtrace |
|
select * from `carts` where exists (select * from `products` where `carts`.`product_id` = `products`.`id` and (`status` = 1) and (`request_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 ('digital', 'physical') and `status` = 1) and 0 = 1 and (`is_checked` = 1)
Bindings |
|
Backtrace |
|
select * from `flash_deals` where (`status` = 1 and `deal_type` = 'flash_deal') and date(`start_date`) <= '2025-05-23' and date(`end_date`) >= '2025-05-23' limit 1
Bindings |
|
Backtrace |
|
200
[]
[]
0 of 0array:15 [▼ "host" => array:1 [▶ 0 => "mappyfy.com" ] "priority" => array:1 [▶ 0 => "u=0, i" ] "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" ] ]
[]
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 => "Fri, 23 May 2025 19:19:56 GMT" ] "set-cookie" => array:2 [▶ 0 => "XSRF-TOKEN=eyJpdiI6IkFLam01NFU0TEhWK2VNZ1VsWTg4QWc9PSIsInZhbHVlIjoib0tGQWZmeFhOUHhqSzdsakxMRmxIMlg5ZWNUMi84elY2NVRqOE5CQUY1N0VDQ3lqTlRuaUx6ZG1QMjltOER5S040Q0NTVmkwRktKenhTeDUvcGw0WE1ycFgzR0ZWRHVtSkdnV0hXNGhqUXkyRzlzT2toQzZTcDQyVkRyYmIvcU4iLCJtYWMiOiIwYmRlMmUwMzVkNjI2ZjVjNDQxZGY3NzMwMmY4MmZiZTkxYmFkMzY5YzhiNjIwNjdlMzk0NTc5N2E0YzAxOWE2IiwidGFnIjoiIn0%3D; expires=Fri, 23 May 2025 20:19:57 GMT; Max-Age=3600; path=/ ◀XSRF-TOKEN=eyJpdiI6IkFLam01NFU0TEhWK2VNZ1VsWTg4QWc9PSIsInZhbHVlIjoib0tGQWZmeFhOUHhqSzdsakxMRmxIMlg5ZWNUMi84elY2NVRqOE5CQUY1N0VDQ3lqTlRuaUx6ZG1QMjltOER5S040Q0NTV ▶" 1 => "6valley1736933341_session=eyJpdiI6Im9xckVZSldDd25rSEwrSy9MK2ZPNVE9PSIsInZhbHVlIjoiZHN1WHlnMm9pOXV3b3hpbFgwejlFd1dzb1Rua1pwdDRpZ0tJcFFoUXFVRUZVYjVNYVRub25udmNkRkE4SGZ1RE5lZURQd1BnR1dDZEdZbzRFVEN1SVVDbjlEWDRGNXpGQkQ3c0VQOHducUtiY1M1K3B3TDI2VWsrWWFYTVcrZkgiLCJtYWMiOiJjYWVlNTc2NmQwOGUzOTBmYWY2OWExZGI2ZWE2MmMxNTlhYmMzOGVjYzc0NmUzZjMxMjYyOTdlYTI0OWFhMDUzIiwidGFnIjoiIn0%3D; expires=Fri, 23 May 2025 20:19:57 GMT; Max-Age=3600; path=/; httponly ◀6valley1736933341_session=eyJpdiI6Im9xckVZSldDd25rSEwrSy9MK2ZPNVE9PSIsInZhbHVlIjoiZHN1WHlnMm9pOXV3b3hpbFgwejlFd1dzb1Rua1pwdDRpZ0tJcFFoUXFVRUZVYjVNYVRub25udmNkRk ▶" ] "Set-Cookie" => array:2 [▶ 0 => "XSRF-TOKEN=eyJpdiI6IkFLam01NFU0TEhWK2VNZ1VsWTg4QWc9PSIsInZhbHVlIjoib0tGQWZmeFhOUHhqSzdsakxMRmxIMlg5ZWNUMi84elY2NVRqOE5CQUY1N0VDQ3lqTlRuaUx6ZG1QMjltOER5S040Q0NTVmkwRktKenhTeDUvcGw0WE1ycFgzR0ZWRHVtSkdnV0hXNGhqUXkyRzlzT2toQzZTcDQyVkRyYmIvcU4iLCJtYWMiOiIwYmRlMmUwMzVkNjI2ZjVjNDQxZGY3NzMwMmY4MmZiZTkxYmFkMzY5YzhiNjIwNjdlMzk0NTc5N2E0YzAxOWE2IiwidGFnIjoiIn0%3D; expires=Fri, 23-May-2025 20:19:57 GMT; path=/ ◀XSRF-TOKEN=eyJpdiI6IkFLam01NFU0TEhWK2VNZ1VsWTg4QWc9PSIsInZhbHVlIjoib0tGQWZmeFhOUHhqSzdsakxMRmxIMlg5ZWNUMi84elY2NVRqOE5CQUY1N0VDQ3lqTlRuaUx6ZG1QMjltOER5S040Q0NTV ▶" 1 => "6valley1736933341_session=eyJpdiI6Im9xckVZSldDd25rSEwrSy9MK2ZPNVE9PSIsInZhbHVlIjoiZHN1WHlnMm9pOXV3b3hpbFgwejlFd1dzb1Rua1pwdDRpZ0tJcFFoUXFVRUZVYjVNYVRub25udmNkRkE4SGZ1RE5lZURQd1BnR1dDZEdZbzRFVEN1SVVDbjlEWDRGNXpGQkQ3c0VQOHducUtiY1M1K3B3TDI2VWsrWWFYTVcrZkgiLCJtYWMiOiJjYWVlNTc2NmQwOGUzOTBmYWY2OWExZGI2ZWE2MmMxNTlhYmMzOGVjYzc0NmUzZjMxMjYyOTdlYTI0OWFhMDUzIiwidGFnIjoiIn0%3D; expires=Fri, 23-May-2025 20:19:57 GMT; path=/; httponly ◀6valley1736933341_session=eyJpdiI6Im9xckVZSldDd25rSEwrSy9MK2ZPNVE9PSIsInZhbHVlIjoiZHN1WHlnMm9pOXV3b3hpbFgwejlFd1dzb1Rua1pwdDRpZ0tJcFFoUXFVRUZVYjVNYVRub25udmNkRk ▶" ] ]
0 of 0array:11 [▼ "system_default_currency_info" => App\Models\Currency {#2120 ▶ #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 Rupee" "symbol" => "₹" "code" => "INR" "exchange_rate" => "1" "status" => 1 "created_at" => "2020-10-15 19:23:04" "updated_at" => "2025-05-08 12:50:01" ] #original: array:8 [▶ "id" => 3 "name" => "Indian Rupee" "symbol" => "₹" "code" => "INR" "exchange_rate" => "1" "status" => 1 "created_at" => "2020-10-15 19:23:04" "updated_at" => "2025-05-08 12:50:01" ] #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" => "1" "usd" => 0.016666666666667 "_token" => "emHrIPeyULGSHSMp9jTDgQ6sT2nD8Ac8ePDXAPzn" "guest_id" => 17404 "local" => "en" "direction" => "ltr" "_previous" => array:1 [▶ "url" => "https://mappyfy.com/categories" ] "_flash" => array:2 [▶ "old" => [] "new" => [] ] ]