PopularController.php#34mydatabase19.38msselectcount(*) as aggregate from `posts` where `status` =1and `publish_date` <='2025-07-12 03:38:00'and `content_type` ='article'and `posts`.`deleted_at` isnull
popular.blade.php#26mydatabase11.37msselect `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` =2720and `categories`.`deleted_at` isnull
Bindings
0:2720
Hints
Use SELECT * only if you need all columns from table
popular.blade.php#26mydatabase5.71msselect `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` =9997and `categories`.`deleted_at` isnull
Bindings
0:9997
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` =2980and `categories`.`deleted_at` isnull
Bindings
0:2980
Hints
Use SELECT * only if you need all columns from table
popular.blade.php#26mydatabase5.85msselect `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` =181and `categories`.`deleted_at` isnull
Bindings
0:181
Hints
Use SELECT * only if you need all columns from table
popular.blade.php#26mydatabase6.18msselect `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` =3613and `categories`.`deleted_at` isnull
Bindings
0:3613
Hints
Use SELECT * only if you need all columns from table
popular.blade.php#26mydatabase5.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` =4856and `categories`.`deleted_at` isnull
Bindings
0:4856
Hints
Use SELECT * only if you need all columns from table
popular.blade.php#26mydatabase5.95msselect `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` =1829and `categories`.`deleted_at` isnull
Bindings
0:1829
Hints
Use SELECT * only if you need all columns from table
popular.blade.php#26mydatabase5.97msselect `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` =9073and `categories`.`deleted_at` isnull
Bindings
0:9073
Hints
Use SELECT * only if you need all columns from table
popular-article.blade.php#8mydatabase6.28msselect `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` =10282and `categories`.`deleted_at` isnull
Bindings
0:10282
Hints
Use SELECT * only if you need all columns from table
popular-article.blade.php#8mydatabase5.74msselect `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` =9722and `categories`.`deleted_at` isnull
Bindings
0:9722
Hints
Use SELECT * only if you need all columns from table
popular-article.blade.php#8mydatabase5.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` =2618and `categories`.`deleted_at` isnull
Bindings
0:2618
Hints
Use SELECT * only if you need all columns from table
popular-article.blade.php#8mydatabase5.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` =10023and `categories`.`deleted_at` isnull
Bindings
0:10023
Hints
Use SELECT * only if you need all columns from table