WebController.php#202palmarhv_palmart1.25msselect `brands`.*, (selectcount(*) from `products` where `brands`.`id` = `products`.`brand_id` andexists (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
WebController.php#202palmarhv_palmart360μsselect*from `translations` where `translations`.`translationable_id` in (12, 13, 14) and `translations`.`translationable_type` ='App\\Models\\Product'and `locale` ='ps'
WebController.php#202palmarhv_palmart260μsselect*from `reviews` where `reviews`.`product_id` in (12, 13, 14) and `delivery_man_id` isnulland `status` =1
cart-manager.php#128palmarhv_palmart1.49msselect `cart_group_id` from `carts` whereexists (select*from `products` where `carts`.`product_id` = `products`.`id` andexists (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` =7650and `is_guest` =1) groupby `cart_group_id`
cart-manager.php#67palmarhv_palmart260μsselect*from `carts` whereexists (select*from `products` where `carts`.`product_id` = `products`.`id` andexists (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) and0=1
cart-manager.php#128palmarhv_palmart470μsselect `cart_group_id` from `carts` whereexists (select*from `products` where `carts`.`product_id` = `products`.`id` andexists (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` =7650and `is_guest` =1) groupby `cart_group_id`
cart-manager.php#67palmarhv_palmart220μsselect*from `carts` whereexists (select*from `products` where `carts`.`product_id` = `products`.`id` andexists (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) and0=1and (`is_checked` =1)
category-manager.php#111palmarhv_palmart570μsselect `categories`.*, (selectcount(*) from `products` where `categories`.`id` = `products`.`category_id` andexists (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 `product_count` from `categories` where `position` =0
category-manager.php#111palmarhv_palmart540μsselect `products`.*, (selectcount(*) 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, 25, 26, 27, 28, 29, 30, 31, 1328) andexists (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')
category-manager.php#111palmarhv_palmart310μsselect*from `stock_clearance_products` where `stock_clearance_products`.`product_id` in (12, 13, 14) and (`is_active` =1) and `added_by` in ('admin', 'vendor') andexists (select*from `stock_clearance_setups` where `stock_clearance_products`.`setup_id` = `stock_clearance_setups`.`id` and `is_active` =1anddate(`duration_start_date`) <='2025-06-04'anddate(`duration_end_date`) >='2025-06-04'and ((`offer_active_time` ='specific_time'andtime(`offer_active_range_start`) <='07:39:42'andtime(`offer_active_range_end`) >='07:39:42') or (`offer_active_time` ='always'and `offer_active_range_start` isnulland `offer_active_range_end` isnull)))
category-manager.php#111palmarhv_palmart260μsselect*from `translations` where `translations`.`translationable_id` in (12, 13, 14) and `translations`.`translationable_type` ='App\\Models\\Product'and `locale` ='ps'
category-manager.php#111palmarhv_palmart210μsselect*from `reviews` where `reviews`.`product_id` in (12, 13, 14) and `delivery_man_id` isnulland `status` =1
category-manager.php#111palmarhv_palmart580μsselect `categories`.*, (selectcount(*) from `products` where `categories`.`id` = `products`.`sub_category_id` andexists (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 `sub_category_product_count` from `categories` where `categories`.`parent_id` in (21, 22, 23, 24, 25, 26, 27, 28, 29, 30, 31, 1328) and `position` =1orderby `priority` asc
category-manager.php#111palmarhv_palmart1.07msselect `categories`.*, (selectcount(*) from `products` where `categories`.`id` = `products`.`sub_sub_category_id` andexists (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 `sub_sub_category_product_count` from `categories` where `categories`.`parent_id` in (1296, 1297, 1298, 1299, 1300, 1329, 1330, 1331, 1332, 1333, 1366, 1367, 1368, 1369, 1371, 1400, 1401, 1402, 1403, 1409) and `position` =2orderby `priority` asc
_footer.blade.php#111palmarhv_palmart240μsselect*from `translations` where `translations`.`translationable_id` in (1) and `translations`.`translationable_type` ='App\\Models\\FlashDeal'and `locale` ='ps'