ProductController.php#112texmith_dev_pilot_mart2.91msselect `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 (165)
ProductController.php#115texmith_dev_pilot_mart2.13msselect*from `shop_metas` where `shop_metas`.`metable_id` in (165) and `shop_metas`.`metable_type` ='Takshak\\Ashop\\Models\\Shop\\Product'
ProductController.php#116texmith_dev_pilot_mart2.49msselect `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 (165)
AppLayout.php#41texmith_dev_pilot_mart1.2msselect*from `categories` where ((`featured` =1) or (`is_top` =1)) and `status` =1orderby `created_at` desc limit 10
ReviewModelTrait.php#13texmith_dev_pilot_mart1.27msselect `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 (165)
show.blade.php#142texmith_dev_pilot_mart3.75msselect `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` =165and `wishlist_items`.`user_id` isnull
Reviews.php#69texmith_dev_pilot_mart940μsselectavg(`rating`) as aggregate from `reviews` where `status` =1and `reviewable_type` ='Takshak\\Ashop\\Models\\Shop\\Product'and `reviewable_id` =165
Reviews.php#81texmith_dev_pilot_mart990μsselectcount(*) as aggregate from `reviews` where `status` =1and `reviewable_type` ='Takshak\\Ashop\\Models\\Shop\\Product'and `reviewable_id` =165
ReviewsStats.php#43texmith_dev_pilot_mart1.46msselectavg(`rating`) as aggregate from `reviews` where `status` =1and `reviewable_type` ='Takshak\\Ashop\\Models\\Shop\\Product'and `reviewable_id` =165
ReviewsStats.php#55texmith_dev_pilot_mart1.24msselectcount(*) as aggregate from `reviews` where `status` =1and `reviewable_type` ='Takshak\\Ashop\\Models\\Shop\\Product'and `reviewable_id` =165
ProductsGroup.php#60texmith_dev_pilot_mart3.93msselect `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_mart1.15msselect `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)