ProductController.php#112texmith_dev_pilot_mart1.34msselect `categories`.`id`, `categories`.`name`, `categories`.`slug`, `categories`.`display_name`, `categories`.`category_id`, `category_product`.`product_id` as `pivot_product_id`, `category_product`.`category_id` as `pivot_category_id` from `categories` innerjoin `category_product` on `categories`.`id` = `category_product`.`category_id` where `category_product`.`product_id` in (192)
ProductController.php#115texmith_dev_pilot_mart910μsselect*from `shop_metas` where `shop_metas`.`metable_id` in (192) and `shop_metas`.`metable_type` ='Takshak\\Ashop\\Models\\Shop\\Product'
ProductController.php#116texmith_dev_pilot_mart1.27msselect `id`, (selectcount(*) from `reviews` where `products`.`id` = `reviews`.`reviewable_id` and `reviews`.`reviewable_type` ='Takshak\\Ashop\\Models\\Shop\\Product') as `reviews_count` from `products` where `products`.`id` in (192)
AppLayout.php#41texmith_dev_pilot_mart1.2msselect*from `categories` where ((`featured` =1) or (`is_top` =1)) and `status` =1orderby `created_at` desc limit 10
CartService.php#26texmith_dev_pilot_mart810μsselect*from `shop_metas` where `shop_metas`.`metable_id` in (126, 217) and `shop_metas`.`metable_type` ='Takshak\\Ashop\\Models\\Shop\\Product'
CartService.php#26texmith_dev_pilot_mart690μsselect `users`.*, `wishlist_items`.`product_id` as `pivot_product_id`, `wishlist_items`.`user_id` as `pivot_user_id`, `wishlist_items`.`created_at` as `pivot_created_at`, `wishlist_items`.`updated_at` as `pivot_updated_at` from `users` innerjoin `wishlist_items` on `users`.`id` = `wishlist_items`.`user_id` where `wishlist_items`.`user_id` isnulland `wishlist_items`.`product_id` in (126, 217)
CartService.php#26texmith_dev_pilot_mart740μsselect `categories`.`id`, `category_product`.`product_id` as `pivot_product_id`, `category_product`.`category_id` as `pivot_category_id` from `categories` innerjoin `category_product` on `categories`.`id` = `category_product`.`category_id` where `category_product`.`product_id` in (126, 217)
ReviewModelTrait.php#13texmith_dev_pilot_mart1.09msselect `id`, (selectavg(`reviews`.`rating`) from `reviews` where `products`.`id` = `reviews`.`reviewable_id` and `reviews`.`reviewable_type` ='Takshak\\Ashop\\Models\\Shop\\Product') as `reviews_avg_rating` from `products` where `products`.`id` in (192)
show.blade.php#142texmith_dev_pilot_mart1.11msselect `users`.*, `wishlist_items`.`product_id` as `pivot_product_id`, `wishlist_items`.`user_id` as `pivot_user_id`, `wishlist_items`.`created_at` as `pivot_created_at`, `wishlist_items`.`updated_at` as `pivot_updated_at` from `users` innerjoin `wishlist_items` on `users`.`id` = `wishlist_items`.`user_id` where `wishlist_items`.`product_id` =192and `wishlist_items`.`user_id` isnull
Reviews.php#69texmith_dev_pilot_mart740μsselectavg(`rating`) as aggregate from `reviews` where `status` =1and `reviewable_type` ='Takshak\\Ashop\\Models\\Shop\\Product'and `reviewable_id` =192
Reviews.php#81texmith_dev_pilot_mart890μsselectcount(*) as aggregate from `reviews` where `status` =1and `reviewable_type` ='Takshak\\Ashop\\Models\\Shop\\Product'and `reviewable_id` =192
ReviewsStats.php#43texmith_dev_pilot_mart940μsselectavg(`rating`) as aggregate from `reviews` where `status` =1and `reviewable_type` ='Takshak\\Ashop\\Models\\Shop\\Product'and `reviewable_id` =192
ReviewsStats.php#55texmith_dev_pilot_mart830μsselectcount(*) as aggregate from `reviews` where `status` =1and `reviewable_type` ='Takshak\\Ashop\\Models\\Shop\\Product'and `reviewable_id` =192
ProductsGroup.php#60texmith_dev_pilot_mart2.77msselect `products`.*, (selectcount(*) from `reviews` where `products`.`id` = `reviews`.`reviewable_id` and `reviews`.`reviewable_type` ='Takshak\\Ashop\\Models\\Shop\\Product') as `reviews_count`, (selectavg(`reviews`.`rating`) from `reviews` where `products`.`id` = `reviews`.`reviewable_id` and `reviews`.`reviewable_type` ='Takshak\\Ashop\\Models\\Shop\\Product') as `reviews_avg_rating` from `products` where `products`.`status` =1andexists (select*from `categories` innerjoin `category_product` on `categories`.`id` = `category_product`.`category_id` where `products`.`id` = `category_product`.`product_id` and (`categories`.`id` in (127) or `categories`.`name` in (127) or `categories`.`slug` in (127))) and `product_id` isnullorderby `created_at` desc limit 10
ProductsGroup.php#60texmith_dev_pilot_mart750μsselect `users`.`id`, `users`.`name`, `wishlist_items`.`product_id` as `pivot_product_id`, `wishlist_items`.`user_id` as `pivot_user_id`, `wishlist_items`.`created_at` as `pivot_created_at`, `wishlist_items`.`updated_at` as `pivot_updated_at` from `users` innerjoin `wishlist_items` on `users`.`id` = `wishlist_items`.`user_id` where `wishlist_items`.`user_id` isnulland `wishlist_items`.`product_id` in (187, 188, 189, 191, 192, 193, 194, 195, 196, 197)