Your cart is empty.
Product Name
We’ll notify you once it’s available at your nearest store.
You need to Sign in to view this feature
This address will be removed from this list
1 x Application (55.88%) | 1.03s |
1 x Booting (44.12%) | 813ms |
insert into `guest_users` (`ip_address`, `updated_at`, `created_at`) values ('216.73.216.167', '2025-07-20 10:10:03', '2025-07-20 10:10:03')
Bindings | |
Backtrace |
select * from `shops` where `id` = '108' limit 1
Bindings | |
Backtrace |
select * from `sellers` where (`status` = 'approved') and `sellers`.`id` = 109 limit 1
Bindings | |
Backtrace |
select * from `shops` where `id` = '108' 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 (exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and `goods_type` = 'non_perishable') or exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and `goods_type` = 'both') and `goods_type` = 'non_perishable') and exists (select * from `brands` where `products`.`brand_id` = `brands`.`id` and `status` = 1) 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 ('physical') and (`added_by` = 'seller' and `user_id` = 109)
Bindings | |
Backtrace |
select avg(rating) average, product_id from `reviews` where `delivery_man_id` is null and `reviews`.`product_id` in (19000, 19001, 19002, 19003, 19004, 19005, 19006, 19007, 19008, 19009, 19010, 19011, 19012, 19013, 19014, 19015, 19016, 19017, 19018) and `status` = 1 group by `product_id`
Bindings | |
Backtrace |
select * from `translations` where `translations`.`translationable_id` in (19000, 19001, 19002, 19003, 19004, 19005, 19006, 19007, 19008, 19009, 19010, 19011, 19012, 19013, 19014, 19015, 19016, 19017, 19018) and `translations`.`translationable_type` = 'App\\Models\\Product' and `locale` = 'en'
Bindings | |
Backtrace |
select * from `reviews` where `reviews`.`product_id` in (19000, 19001, 19002, 19003, 19004, 19005, 19006, 19007, 19008, 19009, 19010, 19011, 19012, 19013, 19014, 19015, 19016, 19017, 19018) and `delivery_man_id` is null and `status` = 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 (exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and `goods_type` = 'non_perishable') or exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and `goods_type` = 'both') and `goods_type` = 'non_perishable') and exists (select * from `brands` where `products`.`brand_id` = `brands`.`id` and `status` = 1) 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 ('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 (exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and `goods_type` = 'non_perishable') or exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and `goods_type` = 'both') and `goods_type` = 'non_perishable') and exists (select * from `brands` where `products`.`brand_id` = `brands`.`id` and `status` = 1) 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 ('physical')))
Bindings | |
Backtrace |
select `id` from `products` where (exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and `goods_type` = 'non_perishable') or exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and `goods_type` = 'both') and `goods_type` = 'non_perishable') and exists (select * from `brands` where `products`.`brand_id` = `brands`.`id` and `status` = 1) 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 ('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 (exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and `goods_type` = 'non_perishable') or exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and `goods_type` = 'both') and `goods_type` = 'non_perishable') and exists (select * from `brands` where `products`.`brand_id` = `brands`.`id` and `status` = 1) 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 ('physical'))) as `digital_product_author_count` from `authors`
Bindings | |
Backtrace |
select `id` from `products` where (exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and `goods_type` = 'non_perishable') or exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and `goods_type` = 'both') and `goods_type` = 'non_perishable') and exists (select * from `brands` where `products`.`brand_id` = `brands`.`id` and `status` = 1) 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 ('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 (exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and `goods_type` = 'non_perishable') or exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and `goods_type` = 'both') and `goods_type` = 'non_perishable') and exists (select * from `brands` where `products`.`brand_id` = `brands`.`id` and `status` = 1) 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 ('physical') and (`added_by` = 'seller' and `user_id` = 109) order by `id` desc
Bindings | |
Backtrace |
select * from `categories` where `categories`.`id` in (21, 22, 23, 24, 224)
Backtrace |
select * from `translations` where `translations`.`translationable_id` in (21, 22, 23, 24, 224) and `translations`.`translationable_type` = 'App\\Models\\Category' and `locale` = 'en'
Bindings | |
Backtrace |
select * from `reviews` where `reviews`.`product_id` in (19000, 19001, 19002, 19003, 19004, 19005, 19006, 19007, 19008, 19009, 19010, 19011, 19012, 19013, 19014, 19015, 19016, 19017, 19018) and `delivery_man_id` is null and `status` = 1
Bindings | |
Backtrace |
select avg(rating) average, product_id from `reviews` where `delivery_man_id` is null and `reviews`.`product_id` in (19000, 19001, 19002, 19003, 19004, 19005, 19006, 19007, 19008, 19009, 19010, 19011, 19012, 19013, 19014, 19015, 19016, 19017, 19018) and `status` = 1 group by `product_id`
Bindings | |
Backtrace |
select * from `sellers` where `sellers`.`id` in (109)
Backtrace |
select * from `shops` where `shops`.`seller_id` in (109)
Backtrace |
select * from `translations` where `translations`.`translationable_id` in (19000, 19001, 19002, 19003, 19004, 19005, 19006, 19007, 19008, 19009, 19010, 19011, 19012, 19013, 19014, 19015, 19016, 19017, 19018) and `translations`.`translationable_type` = 'App\\Models\\Product' and `locale` = 'en'
Bindings | |
Backtrace |
select * from `categories` where `position` = 0 and `id` in ('24', '127', '23', '126', '207', '23', '125', '205', '24', '128', '210', '23', '126', '208', '23', '124', '203', '23', '124', '203', '23', '124', '203', '224', '272', '21', '236', '21', '262', '21', '262', '21', '262', '21', '262', '21', '262', '23', '124', '203', '23', '126', '207', '23', '125', '205', '22', '120')
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 (21, 22, 23, 24, 224) and (exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and `goods_type` = 'non_perishable') or exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and `goods_type` = 'both') and `goods_type` = 'non_perishable') and exists (select * from `brands` where `products`.`brand_id` = `brands`.`id` and `status` = 1) 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 ('physical')
Bindings | |
Backtrace |
select * from `translations` where `translations`.`translationable_id` in (401, 402, 403, 404, 645, 844, 1042, 1212, 1232, 1269, 1278, 1279, 1281, 1284, 1285, 1288, 1300, 1310, 1328, 1331, 1395, 1462, 1466, 1467, 1468, 1469, 1470, 14935, 15038, 15039, 15040, 15041, 15042, 15043, 15044, 15045, 15046, 15047, 15048, 15049, 15057, 15062, 15121, 15123, 15125, 15266, 15267, 15268, 15269, 15270, 15271, 15272, 15273, 15274, 15275, 15276, 15277, 15301, 15302, 15303, 15309, 15310, 15323, 15324, 15325, 15326, 15327, 15328, 15329, 15330, 15331, 15332, 15337, 15350, 15351, 15562, 15582, 15584, 15586, 15605, 15609, 15634, 15636, 15664, 15736, 15807, 15813, 15818, 15819, 15820, 15821, 15822, 15832, 15850, 15869, 15870, 15871, 15872, 15873, 15874, 15884, 15885, 15886, 15887, 15888, 15889, 15890, 15895, 15896, 15898, 15900, 15902, 15903, 15932, 15934, 15937, 15943, 15944, 15945, 15946, 15948, 15949, 15950, 15951, 15952, 15953, 15954, 15955, 15956, 15958, 15960, 15962, 15964, 15965, 15966, 15967, 15970, 15972, 15975, 15980, 15985, 15986, 15990, 15992, 15995, 15997, 16003, 16034, 16035, 16075, 16076, 16087, 16089, 16090, 16098, 16100, 16106, 16111, 16114, 16116, 16131, 16153, 16155, 16156, 16157, 16158, 16159, 16160, 16161, 16162, 16164, 16165, 16167, 16168, 16169, 16267, 16268, 16269, 16270, 16271, 16272, 16273, 16274, 16275, 16277, 16280, 16281, 16283, 16284, 16286, 16288, 16290, 16326, 16327, 16341, 16367, 16368, 16376, 16383, 16385, 16418, 16419, 16420, 16421, 16422, 16425, 16426, 16428, 16429, 16430, 16431, 16432, 16433, 16434, 16435, 16437, 16438, 16439, 16440, 16441, 16442, 16443, 16444, 16445, 16456, 16604, 16605, 16608, 16611, 16620, 16624, 16635, 16636, 16637, 16640, 16645, 16660, 16661, 16664, 16665, 16667, 16669, 16670, 16671, 16672, 16675, 16720, 16722, 16724, 16726, 16745, 16748, 16751, 16755, 16757, 16758, 16767, 16770, 16957, 16958, 16959, 16960, 16962, 16963, 16964, 17205, 17431, 17582, 17585, 17796, 17797, 17884, 17885, 17886, 17887, 17888, 17889, 17890, 17891, 17907, 17919, 17924, 17929, 17932, 17933, 17934, 17935, 17936, 17937, 17938, 17939, 17940, 17941, 17945, 17950, 17964, 17973, 17977, 18010, 18021, 18035, 18036, 18037, 18038, 18045, 18049, 18057, 18077, 18081, 18097, 18098, 18099, 18100, 18101, 18102, 18103, 18104, 18105, 18106, 18107, 18108, 18109, 18223, 18390, 18396, 18422, 18475, 18483, 18489, 18490, 18505, 18506, 18507, 18619, 18620, 18621, 18622, 18623, 18625, 18626, 18628, 18678, 18679, 18680, 18681, 18682, 18683, 18684, 18685, 18686, 18688, 18694, 18695, 18696, 18697, 18698, 18699, 18700, 18701, 18702, 18703, 18704, 18705, 18706, 18707, 18708, 18710, 18711, 18712, 18713, 18714, 18715, 18716, 18717, 18718, 18719, 18720, 18721, 18722, 18723, 18724, 18725, 18727, 18728, 18729, 18730, 18731, 18745, 18746, 18747, 18749, 18889, 18890, 18891, 18892, 18893, 18894, 18895, 18896, 18897, 18898, 18899, 18900, 18901, 18902, 18903, 18904, 18907, 18908, 18912, 18972, 18973, 19000, 19001, 19002, 19003, 19004, 19005, 19006, 19007, 19008, 19009, 19010, 19011, 19012, 19013, 19014, 19015, 19016, 19017, 19018, 19254, 19255, 19256, 19257, 19258, 19259, 19260, 19261, 19262, 19263, 19264, 19265, 19268, 19269, 19270, 19317, 19325, 19330) and `translations`.`translationable_type` = 'App\\Models\\Product' and `locale` = 'en'
Bindings | |
Backtrace |
select * from `reviews` where `reviews`.`product_id` in (401, 402, 403, 404, 645, 844, 1042, 1212, 1232, 1269, 1278, 1279, 1281, 1284, 1285, 1288, 1300, 1310, 1328, 1331, 1395, 1462, 1466, 1467, 1468, 1469, 1470, 14935, 15038, 15039, 15040, 15041, 15042, 15043, 15044, 15045, 15046, 15047, 15048, 15049, 15057, 15062, 15121, 15123, 15125, 15266, 15267, 15268, 15269, 15270, 15271, 15272, 15273, 15274, 15275, 15276, 15277, 15301, 15302, 15303, 15309, 15310, 15323, 15324, 15325, 15326, 15327, 15328, 15329, 15330, 15331, 15332, 15337, 15350, 15351, 15562, 15582, 15584, 15586, 15605, 15609, 15634, 15636, 15664, 15736, 15807, 15813, 15818, 15819, 15820, 15821, 15822, 15832, 15850, 15869, 15870, 15871, 15872, 15873, 15874, 15884, 15885, 15886, 15887, 15888, 15889, 15890, 15895, 15896, 15898, 15900, 15902, 15903, 15932, 15934, 15937, 15943, 15944, 15945, 15946, 15948, 15949, 15950, 15951, 15952, 15953, 15954, 15955, 15956, 15958, 15960, 15962, 15964, 15965, 15966, 15967, 15970, 15972, 15975, 15980, 15985, 15986, 15990, 15992, 15995, 15997, 16003, 16034, 16035, 16075, 16076, 16087, 16089, 16090, 16098, 16100, 16106, 16111, 16114, 16116, 16131, 16153, 16155, 16156, 16157, 16158, 16159, 16160, 16161, 16162, 16164, 16165, 16167, 16168, 16169, 16267, 16268, 16269, 16270, 16271, 16272, 16273, 16274, 16275, 16277, 16280, 16281, 16283, 16284, 16286, 16288, 16290, 16326, 16327, 16341, 16367, 16368, 16376, 16383, 16385, 16418, 16419, 16420, 16421, 16422, 16425, 16426, 16428, 16429, 16430, 16431, 16432, 16433, 16434, 16435, 16437, 16438, 16439, 16440, 16441, 16442, 16443, 16444, 16445, 16456, 16604, 16605, 16608, 16611, 16620, 16624, 16635, 16636, 16637, 16640, 16645, 16660, 16661, 16664, 16665, 16667, 16669, 16670, 16671, 16672, 16675, 16720, 16722, 16724, 16726, 16745, 16748, 16751, 16755, 16757, 16758, 16767, 16770, 16957, 16958, 16959, 16960, 16962, 16963, 16964, 17205, 17431, 17582, 17585, 17796, 17797, 17884, 17885, 17886, 17887, 17888, 17889, 17890, 17891, 17907, 17919, 17924, 17929, 17932, 17933, 17934, 17935, 17936, 17937, 17938, 17939, 17940, 17941, 17945, 17950, 17964, 17973, 17977, 18010, 18021, 18035, 18036, 18037, 18038, 18045, 18049, 18057, 18077, 18081, 18097, 18098, 18099, 18100, 18101, 18102, 18103, 18104, 18105, 18106, 18107, 18108, 18109, 18223, 18390, 18396, 18422, 18475, 18483, 18489, 18490, 18505, 18506, 18507, 18619, 18620, 18621, 18622, 18623, 18625, 18626, 18628, 18678, 18679, 18680, 18681, 18682, 18683, 18684, 18685, 18686, 18688, 18694, 18695, 18696, 18697, 18698, 18699, 18700, 18701, 18702, 18703, 18704, 18705, 18706, 18707, 18708, 18710, 18711, 18712, 18713, 18714, 18715, 18716, 18717, 18718, 18719, 18720, 18721, 18722, 18723, 18724, 18725, 18727, 18728, 18729, 18730, 18731, 18745, 18746, 18747, 18749, 18889, 18890, 18891, 18892, 18893, 18894, 18895, 18896, 18897, 18898, 18899, 18900, 18901, 18902, 18903, 18904, 18907, 18908, 18912, 18972, 18973, 19000, 19001, 19002, 19003, 19004, 19005, 19006, 19007, 19008, 19009, 19010, 19011, 19012, 19013, 19014, 19015, 19016, 19017, 19018, 19254, 19255, 19256, 19257, 19258, 19259, 19260, 19261, 19262, 19263, 19264, 19265, 19268, 19269, 19270, 19317, 19325, 19330) and `delivery_man_id` is null and `status` = 1
Bindings | |
Backtrace |
select * from `categories` where `categories`.`parent_id` in (21, 22, 23, 24, 224) order by `priority` asc
Backtrace |
select * from `categories` where `categories`.`parent_id` in (119, 120, 121, 122, 123, 124, 125, 126, 127, 128, 129, 130, 131, 225, 235, 236, 262, 272, 273, 274, 279) order by `priority` asc
Backtrace |
select * from `translations` where `translations`.`translationable_id` in (203, 204, 205, 206, 207, 208, 209, 210, 211, 212, 213, 214) and `translations`.`translationable_type` = 'App\\Models\\Category' and `locale` = 'en'
Bindings | |
Backtrace |
select * from `translations` where `translations`.`translationable_id` in (119, 120, 121, 122, 123, 124, 125, 126, 127, 128, 129, 130, 131, 225, 235, 236, 262, 272, 273, 274, 279) and `translations`.`translationable_type` = 'App\\Models\\Category' and `locale` = 'en'
Bindings | |
Backtrace |
select * from `translations` where `translations`.`translationable_id` in (21, 22, 23, 24, 224) and `translations`.`translationable_type` = 'App\\Models\\Category' and `locale` = 'en'
Bindings | |
Backtrace |
select `brands`.*, (select count(*) from `products` where `brands`.`id` = `products`.`brand_id` and (exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and `goods_type` = 'non_perishable') or exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and `goods_type` = 'both') and `goods_type` = 'non_perishable') and exists (select * from `brands` where `products`.`brand_id` = `brands`.`id` and `status` = 1) 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 ('physical') and (`added_by` = 'seller' and `user_id` = 109) and (exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and `goods_type` = 'non_perishable') or exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and `goods_type` = 'both') and `goods_type` = 'non_perishable') and exists (select * from `brands` where `products`.`brand_id` = `brands`.`id` and `status` = 1) 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 ('physical')) as `brand_products_count` from `brands` where `status` = 1 and `id` in (96, 96, 96, 96, 96, 96, 96, 96, 96, 96, 96, 96, 96, 96, 96, 96, 96, 96, 96)
Bindings | |
Backtrace |
select `products`.*, (select count(*) from `order_details` where `products`.`id` = `order_details`.`product_id`) as `order_details_count` from `products` where (exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and `goods_type` = 'non_perishable') or exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and `goods_type` = 'both') and `goods_type` = 'non_perishable') and exists (select * from `brands` where `products`.`brand_id` = `brands`.`id` and `status` = 1) 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 ('physical') and `products`.`brand_id` in (96) and (exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and `goods_type` = 'non_perishable') or exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and `goods_type` = 'both') and `goods_type` = 'non_perishable') and exists (select * from `brands` where `products`.`brand_id` = `brands`.`id` and `status` = 1) 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 ('physical') and (`added_by` = 'seller' and `user_id` = 109)
Bindings | |
Backtrace |
select * from `translations` where `translations`.`translationable_id` in (19000, 19001, 19002, 19003, 19004, 19005, 19006, 19007, 19008, 19009, 19010, 19011, 19012, 19013, 19014, 19015, 19016, 19017, 19018) and `translations`.`translationable_type` = 'App\\Models\\Product' and `locale` = 'en'
Bindings | |
Backtrace |
select * from `reviews` where `reviews`.`product_id` in (19000, 19001, 19002, 19003, 19004, 19005, 19006, 19007, 19008, 19009, 19010, 19011, 19012, 19013, 19014, 19015, 19016, 19017, 19018) and `delivery_man_id` is null and `status` = 1
Bindings | |
Backtrace |
select * from `translations` where `translations`.`translationable_id` in (96) and `translations`.`translationable_type` = 'App\\Models\\Brand' and `locale` = 'en'
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 (exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and `goods_type` = 'non_perishable') or exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and `goods_type` = 'both') and `goods_type` = 'non_perishable') and exists (select * from `brands` where `products`.`brand_id` = `brands`.`id` and `status` = 1) 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 ('physical') and `product_type` = 'digital' and `id` in (19000, 19001, 19002, 19003, 19004, 19005, 19006, 19007, 19008, 19009, 19010, 19011, 19012, 19013, 19014, 19015, 19016, 19017, 19018) and (`user_id` = 109 and `added_by` = 'seller'))) 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 (exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and `goods_type` = 'non_perishable') or exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and `goods_type` = 'both') and `goods_type` = 'non_perishable') and exists (select * from `brands` where `products`.`brand_id` = `brands`.`id` and `status` = 1) 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 ('physical') and `product_type` = 'digital' and `id` in (19000, 19001, 19002, 19003, 19004, 19005, 19006, 19007, 19008, 19009, 19010, 19011, 19012, 19013, 19014, 19015, 19016, 19017, 19018) and (`user_id` = 109 and `added_by` = 'seller')))
Bindings | |
Backtrace |
select count(*) as aggregate from `products` where (exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and `goods_type` = 'non_perishable') or exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and `goods_type` = 'both') and `goods_type` = 'non_perishable') and exists (select * from `brands` where `products`.`brand_id` = `brands`.`id` and `status` = 1) 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 ('physical') and (`product_type` = 'digital') and 1 = 1 and `id` in (19000, 19001, 19002, 19003, 19004, 19005, 19006, 19007, 19008, 19009, 19010, 19011, 19012, 19013, 19014, 19015, 19016, 19017, 19018) and (`user_id` = 109 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 (exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and `goods_type` = 'non_perishable') or exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and `goods_type` = 'both') and `goods_type` = 'non_perishable') and exists (select * from `brands` where `products`.`brand_id` = `brands`.`id` and `status` = 1) 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 ('physical') and `product_type` = 'digital' and `id` in (19000, 19001, 19002, 19003, 19004, 19005, 19006, 19007, 19008, 19009, 19010, 19011, 19012, 19013, 19014, 19015, 19016, 19017, 19018) and (`user_id` = 109 and `added_by` = 'seller'))) as `digital_product_author_count` from `authors` where exists (select * 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 (exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and `goods_type` = 'non_perishable') or exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and `goods_type` = 'both') and `goods_type` = 'non_perishable') and exists (select * from `brands` where `products`.`brand_id` = `brands`.`id` and `status` = 1) 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 ('physical') and `product_type` = 'digital' and `id` in (19000, 19001, 19002, 19003, 19004, 19005, 19006, 19007, 19008, 19009, 19010, 19011, 19012, 19013, 19014, 19015, 19016, 19017, 19018) and (`user_id` = 109 and `added_by` = 'seller'))) order by `name` asc
Bindings | |
Backtrace |
select count(*) as aggregate from `products` where (exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and `goods_type` = 'non_perishable') or exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and `goods_type` = 'both') and `goods_type` = 'non_perishable') and exists (select * from `brands` where `products`.`brand_id` = `brands`.`id` and `status` = 1) 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 ('physical') and (`product_type` = 'digital') and 1 = 1 and `id` in (19000, 19001, 19002, 19003, 19004, 19005, 19006, 19007, 19008, 19009, 19010, 19011, 19012, 19013, 19014, 19015, 19016, 19017, 19018) and (`user_id` = 109 and `added_by` = 'seller')
Bindings | |
Backtrace |
select count(*) as aggregate from `orders` where (`seller_is` = 'seller' and `seller_id` = 109) and `order_type` = 'default_type'
Bindings | |
Backtrace |
select * from `shops` where `id` = '108' limit 1
Bindings | |
Backtrace |
select * from `shops` where `id` = '108' limit 1
Bindings | |
Backtrace |
select avg(`rating`) as aggregate from `reviews` where `status` = 1 and `status` = 1 and `product_id` in (19000, 19001, 19002, 19003, 19004, 19005, 19006, 19007, 19008, 19009, 19010, 19011, 19012, 19013, 19014, 19015, 19016, 19017, 19018) and `status` = 1
Bindings | |
Backtrace |
select count(*) as aggregate from `reviews` where `status` = 1 and `status` = 1 and `product_id` in (19000, 19001, 19002, 19003, 19004, 19005, 19006, 19007, 19008, 19009, 19010, 19011, 19012, 19013, 19014, 19015, 19016, 19017, 19018) and `status` = 1
Bindings | |
Backtrace |
select * from `sellers` where `sellers`.`id` = 109 limit 1
Bindings | |
Backtrace |
select * from `carts` where exists (select * from `products` where `carts`.`product_id` = `products`.`id` and (exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and `goods_type` = 'non_perishable') or exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and `goods_type` = 'both') and `goods_type` = 'non_perishable') and exists (select * from `brands` where `products`.`brand_id` = `brands`.`id` and `status` = 1) 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 ('physical') and `status` = 1) and `customer_id` = 1469902
Bindings | |
Backtrace |
select * from `storages` where `storages`.`data_type` = 'App\\Models\\Seller' and `storages`.`data_id` = 109 and `storages`.`data_id` is not null
Bindings | |
Backtrace |
select * from `delivery_zip_codes` where `zipcode` != ''
Bindings | |
Backtrace |
select * from `blog_category`
Backtrace |
select * from `news_category`
Backtrace |
select * from `video_category`
Backtrace |
select * from `carts` where exists (select * from `products` where `carts`.`product_id` = `products`.`id` and (exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and `goods_type` = 'non_perishable') or exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and `goods_type` = 'both') and `goods_type` = 'non_perishable') and exists (select * from `brands` where `products`.`brand_id` = `brands`.`id` and `status` = 1) 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 ('physical') and `status` = 1) and `customer_id` = 1469902
Bindings | |
Backtrace |
select `cart_group_id` from `carts` where exists (select * from `products` where `carts`.`product_id` = `products`.`id` and (exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and `goods_type` = 'non_perishable') or exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and `goods_type` = 'both') and `goods_type` = 'non_perishable') and exists (select * from `brands` where `products`.`brand_id` = `brands`.`id` and `status` = 1) 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 ('physical') and `status` = 1) and (`customer_id` = 1469902 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 (exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and `goods_type` = 'non_perishable') or exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and `goods_type` = 'both') and `goods_type` = 'non_perishable') and exists (select * from `brands` where `products`.`brand_id` = `brands`.`id` and `status` = 1) 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 ('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 (exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and `goods_type` = 'non_perishable') or exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and `goods_type` = 'both') and `goods_type` = 'non_perishable') and exists (select * from `brands` where `products`.`brand_id` = `brands`.`id` and `status` = 1) 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 ('physical') and `status` = 1) and (`customer_id` = 1469902 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 (exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and `goods_type` = 'non_perishable') or exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and `goods_type` = 'both') and `goods_type` = 'non_perishable') and exists (select * from `brands` where `products`.`brand_id` = `brands`.`id` and `status` = 1) 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 ('physical') and `status` = 1) and 0 = 1 and (`is_checked` = 1)
Bindings | |
Backtrace |
select * from `carts` where exists (select * from `products` where `carts`.`product_id` = `products`.`id` and (exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and `goods_type` = 'non_perishable') or exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and `goods_type` = 'both') and `goods_type` = 'non_perishable') and exists (select * from `brands` where `products`.`brand_id` = `brands`.`id` and `status` = 1) 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 ('physical') and `status` = 1) and `customer_id` = 1469902
Bindings | |
Backtrace |
select * from `flash_deals` where (`status` = 1 and `deal_type` = 'flash_deal') and date(`start_date`) <= '2025-07-20' and date(`end_date`) >= '2025-07-20' limit 1
Bindings | |
Backtrace |
select * from `carts` where exists (select * from `products` where `carts`.`product_id` = `products`.`id` and (exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and `goods_type` = 'non_perishable') or exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and `goods_type` = 'both') and `goods_type` = 'non_perishable') and exists (select * from `brands` where `products`.`brand_id` = `brands`.`id` and `status` = 1) 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 ('physical') and `status` = 1) and `customer_id` = 1469902
Bindings | |
Backtrace |
200
[]
[]
0 of 0array:22 [▼ "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" ] "accept-encoding" => array:1 [▶ 0 => "br" ] "host" => array:1 [▶ 0 => "orzanist.com" ] "pragma" => array:1 [▶ 0 => "no-cache" ] "user-agent" => array:1 [▶ 0 => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)" ] "cache-control" => array:1 [▶ 0 => "no-cache" ] "x-forwarded-for" => array:1 [▶ 0 => "216.73.216.167" ] "x-forwarded-proto" => array:1 [▶ 0 => "https" ] "x-real-ip" => array:1 [▶ 0 => "216.73.216.167" ] "x-real-port" => array:1 [▶ 0 => "62451" ] "x-forwarded-port" => array:1 [▶ 0 => "443" ] "x-port" => array:1 [▶ 0 => "443" ] "x-lscache" => array:1 [▶ 0 => "1" ] "sec-ch-ua" => array:1 [▶ 0 => ""Chromium";v="130", "HeadlessChrome";v="130", "Not?A_Brand";v="99"" ] "sec-ch-ua-mobile" => array:1 [▶ 0 => "?0" ] "sec-ch-ua-platform" => array:1 [▶ 0 => ""Windows"" ] "upgrade-insecure-requests" => array:1 [▶ 0 => "1" ] "sec-fetch-site" => array:1 [▶ 0 => "none" ] "sec-fetch-mode" => array:1 [▶ 0 => "navigate" ] "sec-fetch-user" => array:1 [▶ 0 => "?1" ] "sec-fetch-dest" => array:1 [▶ 0 => "document" ] "priority" => array:1 [▶ 0 => "u=0, i" ] ]
[]
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 => "Sun, 20 Jul 2025 04:40:03 GMT" ] "set-cookie" => array:2 [▶ 0 => "XSRF-TOKEN=eyJpdiI6IndIODdzNUVBMENxSHNEeTJ4WWJlb1E9PSIsInZhbHVlIjoiSEdSd2MxdmJtR3IrcFBHK3ZRRHNieG5TMFJTQUhCbWpjck5Jc2RkMi9zRit6d2Q1RVd5K25HOVR3Z1JXRG1ac1hoZVdNdm5ldDliVS9UYzJYNXQyR1pVMWt1MkFhSWR2dEZmQ3FsenBpTFZ5R1VGU1ZCeEk1Rm55Nk1paEpsenQiLCJtYWMiOiIxOTAyZDYyNWMzZTFlNzM0ZmZmZDM0ZWZhNmU2M2ExN2U3ZWE4MmU5NTc5MWNmMDllOGZhN2JjYTY4MTZiNWFhIiwidGFnIjoiIn0%3D; expires=Mon, 20 Jul 2026 04:40:04 GMT; Max-Age=31536000; path=/ ◀XSRF-TOKEN=eyJpdiI6IndIODdzNUVBMENxSHNEeTJ4WWJlb1E9PSIsInZhbHVlIjoiSEdSd2MxdmJtR3IrcFBHK3ZRRHNieG5TMFJTQUhCbWpjck5Jc2RkMi9zRit6d2Q1RVd5K25HOVR3Z1JXRG1ac1hoZVdNd ▶" 1 => "pureorganiczone_session=eyJpdiI6IjhsRVZNazdHdUovUlMzbHNxNHdXU0E9PSIsInZhbHVlIjoicjBVWDF4clZFK3YzUXpzN3lETTBmN2JicFNsYnRQMWxVbHdCU0JKbGc2K3BUVlBVdmZ1alBxSFIzYi9wcTNsVUw2UmVHNlh0ckpweVM3aVlMN3lvNVV4elVVd0svdStvRERZOTZSUUxMQ0JieExlQlhYdGt4ME9ZbWVaOXlhRU4iLCJtYWMiOiJiOThhODVlODkwNmM2NmQzYmVjNDdlZGI0ZjY2MWJiZmFiNmI4MGU3YjE3Y2ZjMjEzYTRiY2QwMmMwY2MwNDJjIiwidGFnIjoiIn0%3D; expires=Mon, 20 Jul 2026 04:40:04 GMT; Max-Age=31536000; path=/; httponly ◀pureorganiczone_session=eyJpdiI6IjhsRVZNazdHdUovUlMzbHNxNHdXU0E9PSIsInZhbHVlIjoicjBVWDF4clZFK3YzUXpzN3lETTBmN2JicFNsYnRQMWxVbHdCU0JKbGc2K3BUVlBVdmZ1alBxSFIzYi9w ▶" ] "Set-Cookie" => array:2 [▶ 0 => "XSRF-TOKEN=eyJpdiI6IndIODdzNUVBMENxSHNEeTJ4WWJlb1E9PSIsInZhbHVlIjoiSEdSd2MxdmJtR3IrcFBHK3ZRRHNieG5TMFJTQUhCbWpjck5Jc2RkMi9zRit6d2Q1RVd5K25HOVR3Z1JXRG1ac1hoZVdNdm5ldDliVS9UYzJYNXQyR1pVMWt1MkFhSWR2dEZmQ3FsenBpTFZ5R1VGU1ZCeEk1Rm55Nk1paEpsenQiLCJtYWMiOiIxOTAyZDYyNWMzZTFlNzM0ZmZmZDM0ZWZhNmU2M2ExN2U3ZWE4MmU5NTc5MWNmMDllOGZhN2JjYTY4MTZiNWFhIiwidGFnIjoiIn0%3D; expires=Mon, 20-Jul-2026 04:40:04 GMT; path=/ ◀XSRF-TOKEN=eyJpdiI6IndIODdzNUVBMENxSHNEeTJ4WWJlb1E9PSIsInZhbHVlIjoiSEdSd2MxdmJtR3IrcFBHK3ZRRHNieG5TMFJTQUhCbWpjck5Jc2RkMi9zRit6d2Q1RVd5K25HOVR3Z1JXRG1ac1hoZVdNd ▶" 1 => "pureorganiczone_session=eyJpdiI6IjhsRVZNazdHdUovUlMzbHNxNHdXU0E9PSIsInZhbHVlIjoicjBVWDF4clZFK3YzUXpzN3lETTBmN2JicFNsYnRQMWxVbHdCU0JKbGc2K3BUVlBVdmZ1alBxSFIzYi9wcTNsVUw2UmVHNlh0ckpweVM3aVlMN3lvNVV4elVVd0svdStvRERZOTZSUUxMQ0JieExlQlhYdGt4ME9ZbWVaOXlhRU4iLCJtYWMiOiJiOThhODVlODkwNmM2NmQzYmVjNDdlZGI0ZjY2MWJiZmFiNmI4MGU3YjE3Y2ZjMjEzYTRiY2QwMmMwY2MwNDJjIiwidGFnIjoiIn0%3D; expires=Mon, 20-Jul-2026 04:40:04 GMT; path=/; httponly ◀pureorganiczone_session=eyJpdiI6IjhsRVZNazdHdUovUlMzbHNxNHdXU0E9PSIsInZhbHVlIjoicjBVWDF4clZFK3YzUXpzN3lETTBmN2JicFNsYnRQMWxVbHdCU0JKbGc2K3BUVlBVdmZ1alBxSFIzYi9w ▶" ] ]
0 of 0array:11 [▼ "system_default_currency_info" => App\Models\Currency {#21756 ▶ #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 17:23:04" "updated_at" => "2021-06-04 18:26:38" ] #original: array:8 [▶ "id" => 3 "name" => "Indian Rupi" "symbol" => "₹" "code" => "INR" "exchange_rate" => "60" "status" => 1 "created_at" => "2020-10-15 17:23:04" "updated_at" => "2021-06-04 18:26: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" "usd" => 1 "_token" => "MaGVeMn2zvO1V51inAO6hrzPOrFWjNnhvDsZSwSc" "guest_id" => 1469902 "local" => "en" "direction" => "ltr" "_previous" => array:1 [▶ "url" => "https://orzanist.com/shopView/108" ] "_flash" => array:2 [▶ "old" => [] "new" => [] ] ]