PopularController.php#34mydatabase131msselectcount(*) as aggregate from `posts` where `status` =1and `publish_date` <='2025-07-06 06:35:16'and `content_type` ='article'and `posts`.`deleted_at` isnull
popular.blade.php#26mydatabase11.49msselect `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` =1624and `categories`.`deleted_at` isnull
Bindings
0:1624
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` =6692and `categories`.`deleted_at` isnull
Bindings
0:6692
Hints
Use SELECT * only if you need all columns from table
popular.blade.php#26mydatabase5.88msselect `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` =111and `categories`.`deleted_at` isnull
Bindings
0:111
Hints
Use SELECT * only if you need all columns from table
popular.blade.php#26mydatabase5.8msselect `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` =4785and `categories`.`deleted_at` isnull
Bindings
0:4785
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` =8355and `categories`.`deleted_at` isnull
Bindings
0:8355
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` =7560and `categories`.`deleted_at` isnull
Bindings
0:7560
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` =6080and `categories`.`deleted_at` isnull
Bindings
0:6080
Hints
Use SELECT * only if you need all columns from table
popular.blade.php#26mydatabase5.91msselect `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` =7887and `categories`.`deleted_at` isnull
Bindings
0:7887
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` =6281and `categories`.`deleted_at` isnull
Bindings
0:6281
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` =5460and `categories`.`deleted_at` isnull
Bindings
0:5460
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` =4721and `categories`.`deleted_at` isnull
Bindings
0:4721
Hints
Use SELECT * only if you need all columns from table
popular-article.blade.php#8mydatabase5.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` =3897and `categories`.`deleted_at` isnull
Bindings
0:3897
Hints
Use SELECT * only if you need all columns from table