PopularController.php#34mydatabase19.54msselectcount(*) as aggregate from `posts` where `status` =1and `publish_date` <='2025-07-23 11:14:34'and `content_type` ='article'and `posts`.`deleted_at` isnull
popular.blade.php#26mydatabase11.07msselect `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` =4207and `categories`.`deleted_at` isnull
Bindings
0:4207
Hints
Use SELECT * only if you need all columns from table
popular.blade.php#26mydatabase5.73msselect `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` =10123and `categories`.`deleted_at` isnull
Bindings
0:10123
Hints
Use SELECT * only if you need all columns from table
popular.blade.php#26mydatabase5.75msselect `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` =5538and `categories`.`deleted_at` isnull
Bindings
0:5538
Hints
Use SELECT * only if you need all columns from table
popular.blade.php#26mydatabase6.15msselect `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` =4163and `categories`.`deleted_at` isnull
Bindings
0:4163
Hints
Use SELECT * only if you need all columns from table
popular.blade.php#26mydatabase5.76msselect `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` =7860and `categories`.`deleted_at` isnull
Bindings
0:7860
Hints
Use SELECT * only if you need all columns from table
popular.blade.php#26mydatabase5.94msselect `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` =7622and `categories`.`deleted_at` isnull
Bindings
0:7622
Hints
Use SELECT * only if you need all columns from table
popular.blade.php#26mydatabase6.62msselect `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` =9776and `categories`.`deleted_at` isnull
Bindings
0:9776
Hints
Use SELECT * only if you need all columns from table
popular.blade.php#26mydatabase6.35msselect `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` =6561and `categories`.`deleted_at` isnull
Bindings
0:6561
Hints
Use SELECT * only if you need all columns from table
popular-article.blade.php#8mydatabase6.27msselect `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` =4813and `categories`.`deleted_at` isnull
Bindings
0:4813
Hints
Use SELECT * only if you need all columns from table
popular-article.blade.php#8mydatabase6.3msselect `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` =6242and `categories`.`deleted_at` isnull
Bindings
0:6242
Hints
Use SELECT * only if you need all columns from table
popular-article.blade.php#8mydatabase6.45msselect `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` =1893and `categories`.`deleted_at` isnull
Bindings
0:1893
Hints
Use SELECT * only if you need all columns from table
popular-article.blade.php#8mydatabase6.44msselect `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` =2007and `categories`.`deleted_at` isnull
Bindings
0:2007
Hints
Use SELECT * only if you need all columns from table