PopularController.php#34mydatabase86.27msselectcount(*) as aggregate from `posts` where `status` =1and `publish_date` <='2025-07-05 06:23:06'and `content_type` ='article'and `posts`.`deleted_at` isnull
popular.blade.php#26mydatabase19.6msselect `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` =5995and `categories`.`deleted_at` isnull
Bindings
0:5995
Hints
Use SELECT * only if you need all columns from table
popular.blade.php#26mydatabase5.93msselect `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` =6645and `categories`.`deleted_at` isnull
Bindings
0:6645
Hints
Use SELECT * only if you need all columns from table
popular.blade.php#26mydatabase5.82msselect `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` =825and `categories`.`deleted_at` isnull
Bindings
0:825
Hints
Use SELECT * only if you need all columns from table
popular.blade.php#26mydatabase5.72msselect `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` =7955and `categories`.`deleted_at` isnull
Bindings
0:7955
Hints
Use SELECT * only if you need all columns from table
popular.blade.php#26mydatabase5.7msselect `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` =6002and `categories`.`deleted_at` isnull
Bindings
0:6002
Hints
Use SELECT * only if you need all columns from table
popular.blade.php#26mydatabase5.57msselect `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` =6861and `categories`.`deleted_at` isnull
Bindings
0:6861
Hints
Use SELECT * only if you need all columns from table
popular.blade.php#26mydatabase5.69msselect `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` =10222and `categories`.`deleted_at` isnull
Bindings
0:10222
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` =10194and `categories`.`deleted_at` isnull
Bindings
0:10194
Hints
Use SELECT * only if you need all columns from table
popular-article.blade.php#8mydatabase5.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` =8120and `categories`.`deleted_at` isnull
Bindings
0:8120
Hints
Use SELECT * only if you need all columns from table
popular-article.blade.php#8mydatabase5.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` =2808and `categories`.`deleted_at` isnull
Bindings
0:2808
Hints
Use SELECT * only if you need all columns from table
popular-article.blade.php#8mydatabase5.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` =8451and `categories`.`deleted_at` isnull
Bindings
0:8451
Hints
Use SELECT * only if you need all columns from table
popular-article.blade.php#8mydatabase5.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` =1778and `categories`.`deleted_at` isnull
Bindings
0:1778
Hints
Use SELECT * only if you need all columns from table