You need to Sign in to view this feature
This address will be removed from this list
1 x Application (74.11%) | 1.24s |
1 x Booting (25.89%) | 432ms |
insert into `guest_users` (`ip_address`, `updated_at`, `created_at`) values ('3.16.165.149', '2025-05-21 07:03:15', '2025-05-21 07:03:15')
Bindings |
|
Backtrace |
|
select * from `shops` where `id` = '10' limit 1
Bindings |
|
Backtrace |
|
select * from `sellers` where (`status` = 'approved') and `sellers`.`id` = 16 limit 1
Bindings |
|
Backtrace |
|
select * from `shops` where `id` = '10' limit 1
Bindings |
|
Backtrace |
|
select `products`.*, (select count(*) from `reviews` where `products`.`id` = `reviews`.`product_id` and `status` = 1) as `reviews_count` from `products` where (`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 (`added_by` = 'seller' and `user_id` = 16)
Bindings |
|
Backtrace |
|
select `publishing_houses`.*, (select count(*) from `digital_product_publishing_houses` where `publishing_houses`.`id` = `digital_product_publishing_houses`.`publishing_house_id` and exists (select * from `products` where `digital_product_publishing_houses`.`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'))) as `publishing_house_products_count` from `publishing_houses` where exists (select * from `digital_product_publishing_houses` where `publishing_houses`.`id` = `digital_product_publishing_houses`.`publishing_house_id` and exists (select * from `products` where `digital_product_publishing_houses`.`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')))
Bindings |
|
Backtrace |
|
select `id` from `products` where (`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 (`product_type` = 'digital') and 1 = 1
Bindings |
|
Backtrace |
|
select `authors`.*, (select count(*) from `digital_product_authors` where `authors`.`id` = `digital_product_authors`.`author_id` and exists (select * from `products` where `digital_product_authors`.`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'))) as `digital_product_author_count` from `authors`
Bindings |
|
Backtrace |
|
select `id` from `products` where (`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 (`product_type` = 'digital') and 1 = 1
Bindings |
|
Backtrace |
|
select `products`.*, (select count(*) from `reviews` where `products`.`id` = `reviews`.`product_id` and `status` = 1) as `reviews_count`, (select sum(`order_details`.`qty`) from `order_details` where `products`.`id` = `order_details`.`product_id`) as `order_details_sum_qty`, (select count(*) from `order_details` where `products`.`id` = `order_details`.`product_id`) as `order_details_count`, (select count(*) from `reviews` where `products`.`id` = `reviews`.`product_id` and `status` = 1) as `reviews_count`, (select count(*) from `wishlists` where `products`.`id` = `wishlists`.`product_id`) as `wish_list_count`, (select avg(`reviews`.`rating`) from `reviews` where `products`.`id` = `reviews`.`product_id` and `status` = 1) as `reviews_avg_rating` from `products` where (`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 (`added_by` = 'seller' and `user_id` = 16) order by `id` desc, `id` desc
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 and 0 = 1
Bindings |
|
Backtrace |
|
select `brands`.*, (select count(*) from `products` where `brands`.`id` = `products`.`brand_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 (`added_by` = 'seller' and `user_id` = 16) 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 `brand_products_count` from `brands` where `status` = 1 and 0 = 1
Bindings |
|
Backtrace |
|
select `publishing_houses`.*, (select count(*) from `digital_product_publishing_houses` where `publishing_houses`.`id` = `digital_product_publishing_houses`.`publishing_house_id` and exists (select * from `products` where `digital_product_publishing_houses`.`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 `product_type` = 'digital' and (`user_id` = 16 and `added_by` = 'seller'))) as `publishing_house_products_count` from `publishing_houses`
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `products` where (`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 (`product_type` = 'digital') and 1 = 1 and (`user_id` = 16 and `added_by` = 'seller')
Bindings |
|
Backtrace |
|
select `authors`.*, (select count(*) from `digital_product_authors` where `authors`.`id` = `digital_product_authors`.`author_id` and exists (select * from `products` where `digital_product_authors`.`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 `product_type` = 'digital' and (`user_id` = 16 and `added_by` = 'seller'))) as `digital_product_author_count` from `authors` order by `name` asc
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `products` where (`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 (`product_type` = 'digital') and 1 = 1 and (`user_id` = 16 and `added_by` = 'seller')
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `orders` where (`seller_is` = 'seller' and `seller_id` = 16) and `order_type` = 'default_type'
Bindings |
|
Backtrace |
|
select * from `shops` where `id` = '10' limit 1
Bindings |
|
Backtrace |
|
select * from `shops` where `id` = '10' limit 1
Bindings |
|
Backtrace |
|
select avg(`rating`) as aggregate from `reviews` where `status` = 1 and `status` = 1 and 0 = 1 and `status` = 1
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `reviews` where `status` = 1 and `status` = 1 and 0 = 1 and `status` = 1
Bindings |
|
Backtrace |
|
select * from `sellers` where `sellers`.`id` = 16 limit 1
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `stock_clearance_products` where (`is_active` = 1) and `added_by` in ('admin', 'vendor') and exists (select * from `stock_clearance_setups` where `stock_clearance_products`.`setup_id` = `stock_clearance_setups`.`id` and `is_active` = 1 and date(`duration_start_date`) <= '2025-05-21' and date(`duration_end_date`) >= '2025-05-21' and ((`offer_active_time` = 'specific_time' and time(`offer_active_range_start`) <= '07:03:15' and time(`offer_active_range_end`) >= '07:03:15') or (`offer_active_time` = 'always' and `offer_active_range_start` is null and `offer_active_range_end` is null))) and (`shop_id` = '10')
Bindings |
|
Backtrace |
|
select * from `stock_clearance_setups` where (`shop_id` = '10') limit 1
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` = 16697 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` = 16697 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-21' and date(`end_date`) >= '2025-05-21' 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 => "Wed, 21 May 2025 07:03:15 GMT" ] "set-cookie" => array:2 [▶ 0 => "XSRF-TOKEN=eyJpdiI6IkN6NmFHTUZ1VVludnBqU2JpalBnbEE9PSIsInZhbHVlIjoiS1dyUU5SL3BvdHRnTGsrRGt1eFB3WENVMWxLUTRzWUJhNlhKRmVwTnNpTGMzOGFVTDVQZCtuUTRjWmVBN003OVMvOVJ6dkV2WURTVnVtNUhua05Uc1RzK1Q0WGlmQS9zc2t6N2lsWE05RjVqU00raHEveVlrWVlSQ08wR29LbUQiLCJtYWMiOiI4Njc1MzgzNTcwYTU5MDRjMGU4NDkwODVkZjM4MTA4ZmY2YzY2YThhMmZhZTliNzNkNzM1MjNlNTE5MGFkY2I2IiwidGFnIjoiIn0%3D; expires=Wed, 21 May 2025 08:03:16 GMT; Max-Age=3600; path=/ ◀XSRF-TOKEN=eyJpdiI6IkN6NmFHTUZ1VVludnBqU2JpalBnbEE9PSIsInZhbHVlIjoiS1dyUU5SL3BvdHRnTGsrRGt1eFB3WENVMWxLUTRzWUJhNlhKRmVwTnNpTGMzOGFVTDVQZCtuUTRjWmVBN003OVMvOVJ6d ▶" 1 => "6valley1736933341_session=eyJpdiI6Im9yN054ajN6dVY4aGZvbmpVcVFnMWc9PSIsInZhbHVlIjoiWEJWbjJWMlFGNTJTV3FEWU53d2VCOW1tZ1h5N0FFNDJoZndwVlFmSERaNlJuZytOTlBaaEx6RlZDL1N6ejlFTjRITGxzOEVTOEVURlR3dCt6N1dEWkhxRm9wSmJKQ0RBeGZwMWpZdzI5YlE3azNBNVROV1FHLzlzVWxCVjFFTHYiLCJtYWMiOiJmOTFiNzYyOTdiOTkxMTk0ZGU0Nzc2ZTkyMjliYjJiMjFhNDAwMjM4M2M3MmY3MmMxNTE3MmFjZTE1OTQzZjdjIiwidGFnIjoiIn0%3D; expires=Wed, 21 May 2025 08:03:16 GMT; Max-Age=3600; path=/; httponly ◀6valley1736933341_session=eyJpdiI6Im9yN054ajN6dVY4aGZvbmpVcVFnMWc9PSIsInZhbHVlIjoiWEJWbjJWMlFGNTJTV3FEWU53d2VCOW1tZ1h5N0FFNDJoZndwVlFmSERaNlJuZytOTlBaaEx6RlZDL1 ▶" ] "Set-Cookie" => array:2 [▶ 0 => "XSRF-TOKEN=eyJpdiI6IkN6NmFHTUZ1VVludnBqU2JpalBnbEE9PSIsInZhbHVlIjoiS1dyUU5SL3BvdHRnTGsrRGt1eFB3WENVMWxLUTRzWUJhNlhKRmVwTnNpTGMzOGFVTDVQZCtuUTRjWmVBN003OVMvOVJ6dkV2WURTVnVtNUhua05Uc1RzK1Q0WGlmQS9zc2t6N2lsWE05RjVqU00raHEveVlrWVlSQ08wR29LbUQiLCJtYWMiOiI4Njc1MzgzNTcwYTU5MDRjMGU4NDkwODVkZjM4MTA4ZmY2YzY2YThhMmZhZTliNzNkNzM1MjNlNTE5MGFkY2I2IiwidGFnIjoiIn0%3D; expires=Wed, 21-May-2025 08:03:16 GMT; path=/ ◀XSRF-TOKEN=eyJpdiI6IkN6NmFHTUZ1VVludnBqU2JpalBnbEE9PSIsInZhbHVlIjoiS1dyUU5SL3BvdHRnTGsrRGt1eFB3WENVMWxLUTRzWUJhNlhKRmVwTnNpTGMzOGFVTDVQZCtuUTRjWmVBN003OVMvOVJ6d ▶" 1 => "6valley1736933341_session=eyJpdiI6Im9yN054ajN6dVY4aGZvbmpVcVFnMWc9PSIsInZhbHVlIjoiWEJWbjJWMlFGNTJTV3FEWU53d2VCOW1tZ1h5N0FFNDJoZndwVlFmSERaNlJuZytOTlBaaEx6RlZDL1N6ejlFTjRITGxzOEVTOEVURlR3dCt6N1dEWkhxRm9wSmJKQ0RBeGZwMWpZdzI5YlE3azNBNVROV1FHLzlzVWxCVjFFTHYiLCJtYWMiOiJmOTFiNzYyOTdiOTkxMTk0ZGU0Nzc2ZTkyMjliYjJiMjFhNDAwMjM4M2M3MmY3MmMxNTE3MmFjZTE1OTQzZjdjIiwidGFnIjoiIn0%3D; expires=Wed, 21-May-2025 08:03:16 GMT; path=/; httponly ◀6valley1736933341_session=eyJpdiI6Im9yN054ajN6dVY4aGZvbmpVcVFnMWc9PSIsInZhbHVlIjoiWEJWbjJWMlFGNTJTV3FEWU53d2VCOW1tZ1h5N0FFNDJoZndwVlFmSERaNlJuZytOTlBaaEx6RlZDL1 ▶" ] ]
0 of 0array:12 [▼ "system_default_currency_info" => App\Models\Currency {#2123 ▶ #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" => "77CEJUB5tkaDZO83q9Pj6G21Y1MF8S54HAQV3Z7h" "guest_id" => 16697 "local" => "en" "direction" => "ltr" "toastr::messages" => array:1 [▶ 0 => array:4 [▶ "type" => "warning" "title" => null "message" => "Not found" "options" => [] ] ] "_flash" => array:2 [▶ "new" => [] "old" => array:1 [▶ 0 => "toastr::messages" ] ] "_previous" => array:1 [▶ "url" => "https://mappyfy.com/shopView/10" ] ]