PopularController.php#34mydatabase36.04msselectcount(*) as aggregate from `posts` where `status` =1and `publish_date` <='2025-07-19 21:03:49'and `content_type` ='article'and `posts`.`deleted_at` isnull
popular.blade.php#26mydatabase11.81msselect `categories`.*, `category_post`.`post_id` as `pivot_post_id`, `category_post`.`category_id` as `pivot_category_id`, `category_post`.`created_at` as `pivot_created_at`, `category_post`.`updated_at` as `pivot_updated_at` from `categories` innerjoin `category_post` on `categories`.`id` = `category_post`.`category_id` where `category_post`.`post_id` =6870and `categories`.`deleted_at` isnull
Bindings
0:6870
Hints
Use SELECT * only if you need all columns from table
popular.blade.php#26mydatabase5.68msselect `categories`.*, `category_post`.`post_id` as `pivot_post_id`, `category_post`.`category_id` as `pivot_category_id`, `category_post`.`created_at` as `pivot_created_at`, `category_post`.`updated_at` as `pivot_updated_at` from `categories` innerjoin `category_post` on `categories`.`id` = `category_post`.`category_id` where `category_post`.`post_id` =9817and `categories`.`deleted_at` isnull
Bindings
0:9817
Hints
Use SELECT * only if you need all columns from table
popular.blade.php#26mydatabase5.59msselect `categories`.*, `category_post`.`post_id` as `pivot_post_id`, `category_post`.`category_id` as `pivot_category_id`, `category_post`.`created_at` as `pivot_created_at`, `category_post`.`updated_at` as `pivot_updated_at` from `categories` innerjoin `category_post` on `categories`.`id` = `category_post`.`category_id` where `category_post`.`post_id` =6357and `categories`.`deleted_at` isnull
Bindings
0:6357
Hints
Use SELECT * only if you need all columns from table
popular.blade.php#26mydatabase5.68msselect `categories`.*, `category_post`.`post_id` as `pivot_post_id`, `category_post`.`category_id` as `pivot_category_id`, `category_post`.`created_at` as `pivot_created_at`, `category_post`.`updated_at` as `pivot_updated_at` from `categories` innerjoin `category_post` on `categories`.`id` = `category_post`.`category_id` where `category_post`.`post_id` =1122and `categories`.`deleted_at` isnull
Bindings
0:1122
Hints
Use SELECT * only if you need all columns from table
popular.blade.php#26mydatabase5.64msselect `categories`.*, `category_post`.`post_id` as `pivot_post_id`, `category_post`.`category_id` as `pivot_category_id`, `category_post`.`created_at` as `pivot_created_at`, `category_post`.`updated_at` as `pivot_updated_at` from `categories` innerjoin `category_post` on `categories`.`id` = `category_post`.`category_id` where `category_post`.`post_id` =8163and `categories`.`deleted_at` isnull
Bindings
0:8163
Hints
Use SELECT * only if you need all columns from table
popular.blade.php#26mydatabase5.58msselect `categories`.*, `category_post`.`post_id` as `pivot_post_id`, `category_post`.`category_id` as `pivot_category_id`, `category_post`.`created_at` as `pivot_created_at`, `category_post`.`updated_at` as `pivot_updated_at` from `categories` innerjoin `category_post` on `categories`.`id` = `category_post`.`category_id` where `category_post`.`post_id` =5906and `categories`.`deleted_at` isnull
Bindings
0:5906
Hints
Use SELECT * only if you need all columns from table
popular.blade.php#26mydatabase5.64msselect `categories`.*, `category_post`.`post_id` as `pivot_post_id`, `category_post`.`category_id` as `pivot_category_id`, `category_post`.`created_at` as `pivot_created_at`, `category_post`.`updated_at` as `pivot_updated_at` from `categories` innerjoin `category_post` on `categories`.`id` = `category_post`.`category_id` where `category_post`.`post_id` =6997and `categories`.`deleted_at` isnull
Bindings
0:6997
Hints
Use SELECT * only if you need all columns from table
popular.blade.php#26mydatabase5.66msselect `categories`.*, `category_post`.`post_id` as `pivot_post_id`, `category_post`.`category_id` as `pivot_category_id`, `category_post`.`created_at` as `pivot_created_at`, `category_post`.`updated_at` as `pivot_updated_at` from `categories` innerjoin `category_post` on `categories`.`id` = `category_post`.`category_id` where `category_post`.`post_id` =7215and `categories`.`deleted_at` isnull
Bindings
0:7215
Hints
Use SELECT * only if you need all columns from table
popular-article.blade.php#8mydatabase5.56msselect `categories`.*, `category_post`.`post_id` as `pivot_post_id`, `category_post`.`category_id` as `pivot_category_id`, `category_post`.`created_at` as `pivot_created_at`, `category_post`.`updated_at` as `pivot_updated_at` from `categories` innerjoin `category_post` on `categories`.`id` = `category_post`.`category_id` where `category_post`.`post_id` =4511and `categories`.`deleted_at` isnull
Bindings
0:4511
Hints
Use SELECT * only if you need all columns from table
popular-article.blade.php#8mydatabase5.59msselect `categories`.*, `category_post`.`post_id` as `pivot_post_id`, `category_post`.`category_id` as `pivot_category_id`, `category_post`.`created_at` as `pivot_created_at`, `category_post`.`updated_at` as `pivot_updated_at` from `categories` innerjoin `category_post` on `categories`.`id` = `category_post`.`category_id` where `category_post`.`post_id` =7339and `categories`.`deleted_at` isnull
Bindings
0:7339
Hints
Use SELECT * only if you need all columns from table
popular-article.blade.php#8mydatabase5.63msselect `categories`.*, `category_post`.`post_id` as `pivot_post_id`, `category_post`.`category_id` as `pivot_category_id`, `category_post`.`created_at` as `pivot_created_at`, `category_post`.`updated_at` as `pivot_updated_at` from `categories` innerjoin `category_post` on `categories`.`id` = `category_post`.`category_id` where `category_post`.`post_id` =4820and `categories`.`deleted_at` isnull
Bindings
0:4820
Hints
Use SELECT * only if you need all columns from table
popular-article.blade.php#8mydatabase5.52msselect `categories`.*, `category_post`.`post_id` as `pivot_post_id`, `category_post`.`category_id` as `pivot_category_id`, `category_post`.`created_at` as `pivot_created_at`, `category_post`.`updated_at` as `pivot_updated_at` from `categories` innerjoin `category_post` on `categories`.`id` = `category_post`.`category_id` where `category_post`.`post_id` =6558and `categories`.`deleted_at` isnull
Bindings
0:6558
Hints
Use SELECT * only if you need all columns from table