ProductRepository.php#131alphastore2.57msselect*from `products` where (`added_by` ='admin') 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 `slug` ='t-shirt-and-bermuda-shorts-set-with-label' limit 1
ProductRepository.php#131alphastore960μsselect*from `stock_clearance_products` where `stock_clearance_products`.`product_id` in (4297) 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-26'anddate(`duration_end_date`) >='2025-06-26'and ((`offer_active_time` ='specific_time'andtime(`offer_active_range_start`) <='01:26:45'andtime(`offer_active_range_end`) >='01:26:45') or (`offer_active_time` ='always'and `offer_active_range_start` isnulland `offer_active_range_end` isnull)))
ProductRepository.php#131alphastore810μsselect*from `translations` where `translations`.`translationable_id` in (4297) and `translations`.`translationable_type` ='App\\Models\\Product'and `locale` ='sy'
ProductRepository.php#352alphastore1.59msselectcount(*) as aggregate from `products` where (`added_by` ='admin') 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` ='admin') and `user_id` =0and `id` notin (4297)
ProductRepository.php#352alphastore980μsselect*from `products` where (`added_by` ='admin') 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` ='admin') and `user_id` =0and `id` notin (4297) orderby `id` desc limit 5offset0
ProductRepository.php#352alphastore600μsselect*from `translations` where `translations`.`translationable_id` in (4345, 4346, 4347, 4348, 4349) and `translations`.`translationable_type` ='App\\Models\\Product'and `locale` ='sy'
ProductRepository.php#352alphastore390μsselect*from `reviews` where `reviews`.`product_id` in (4345, 4346, 4347, 4348, 4349) and `delivery_man_id` isnulland `status` =1
ProductRepository.php#352alphastore1.29msselectcount(*) as aggregate from `products` where (`added_by` ='admin') 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` ='admin') and `user_id` =0
ProductRepository.php#352alphastore1.07msselect `products`.*, (selectcount(*) from `reviews` where `products`.`id` = `reviews`.`product_id` and `status` =1and `status` =1) as `reviews_count` from `products` where (`added_by` ='admin') 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` ='admin') and `user_id` =0 limit 25offset0
ProductRepository.php#352alphastore1.42msselectcount(*) as aggregate from `products` where (`added_by` ='admin') 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 (`category_id` =1) and `id` notin (4297)
ProductRepository.php#352alphastore940μsselect*from `products` where (`added_by` ='admin') 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 (`category_id` =1) and `id` notin (4297) limit 12offset0
product-manager.php#2389alphastore1.11msselect*from `carts` whereexists (select*from `products` where `carts`.`product_id` = `products`.`id` and (`added_by` ='admin') 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` =36932and `is_guest` =1)
cart-manager.php#130alphastore1.02msselect `cart_group_id` from `carts` whereexists (select*from `products` where `carts`.`product_id` = `products`.`id` and (`added_by` ='admin') 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` =36932and `is_guest` =1) groupby `cart_group_id`
cart-manager.php#69alphastore800μsselect*from `carts` whereexists (select*from `products` where `carts`.`product_id` = `products`.`id` and (`added_by` ='admin') 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) and0=1
product-manager.php#2389alphastore910μsselect*from `carts` whereexists (select*from `products` where `carts`.`product_id` = `products`.`id` and (`added_by` ='admin') 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` =36932and `is_guest` =1)
cart-manager.php#130alphastore750μsselect `cart_group_id` from `carts` whereexists (select*from `products` where `carts`.`product_id` = `products`.`id` and (`added_by` ='admin') 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` =36932and `is_guest` =1) groupby `cart_group_id`
cart-manager.php#69alphastore470μsselect*from `carts` whereexists (select*from `products` where `carts`.`product_id` = `products`.`id` and (`added_by` ='admin') 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) and0=1and (`is_checked` =1)