PopularController.php#34mydatabase82.21msselectcount(*) as aggregate from `posts` where `status` =1and `publish_date` <='2025-07-05 02:02:59'and `content_type` ='article'and `posts`.`deleted_at` isnull
popular.blade.php#26mydatabase21.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` =10244and `categories`.`deleted_at` isnull
Bindings
0:10244
Hints
Use SELECT * only if you need all columns from table
popular.blade.php#26mydatabase5.34msselect `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` =7105and `categories`.`deleted_at` isnull
Bindings
0:7105
Hints
Use SELECT * only if you need all columns from table
popular.blade.php#26mydatabase5.31msselect `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` =5955and `categories`.`deleted_at` isnull
Bindings
0:5955
Hints
Use SELECT * only if you need all columns from table
popular.blade.php#26mydatabase5.43msselect `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` =3166and `categories`.`deleted_at` isnull
Bindings
0:3166
Hints
Use SELECT * only if you need all columns from table
popular.blade.php#26mydatabase5.03msselect `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` =436and `categories`.`deleted_at` isnull
Bindings
0:436
Hints
Use SELECT * only if you need all columns from table
popular.blade.php#26mydatabase6.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` =4823and `categories`.`deleted_at` isnull
Bindings
0:4823
Hints
Use SELECT * only if you need all columns from table
popular.blade.php#26mydatabase4.84msselect `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` =2125and `categories`.`deleted_at` isnull
Bindings
0:2125
Hints
Use SELECT * only if you need all columns from table
popular.blade.php#26mydatabase4.78msselect `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` =8647and `categories`.`deleted_at` isnull
Bindings
0:8647
Hints
Use SELECT * only if you need all columns from table
popular-article.blade.php#8mydatabase5.22msselect `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` =2018and `categories`.`deleted_at` isnull
Bindings
0:2018
Hints
Use SELECT * only if you need all columns from table
popular-article.blade.php#8mydatabase5.4msselect `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` =1127and `categories`.`deleted_at` isnull
Bindings
0:1127
Hints
Use SELECT * only if you need all columns from table
popular-article.blade.php#8mydatabase5.9msselect `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` =10334and `categories`.`deleted_at` isnull
Bindings
0:10334
Hints
Use SELECT * only if you need all columns from table
popular-article.blade.php#8mydatabase5.61msselect `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` =9015and `categories`.`deleted_at` isnull
Bindings
0:9015
Hints
Use SELECT * only if you need all columns from table