PopularController.php#34mydatabase65.59msselectcount(*) as aggregate from `posts` where `status` =1and `publish_date` <='2025-07-14 23:11:32'and `content_type` ='article'and `posts`.`deleted_at` isnull
popular.blade.php#26mydatabase11.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` =2729and `categories`.`deleted_at` isnull
Bindings
0:2729
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` =9703and `categories`.`deleted_at` isnull
Bindings
0:9703
Hints
Use SELECT * only if you need all columns from table
popular.blade.php#26mydatabase5.77msselect `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` =5705and `categories`.`deleted_at` isnull
Bindings
0:5705
Hints
Use SELECT * only if you need all columns from table
popular.blade.php#26mydatabase5.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` =1913and `categories`.`deleted_at` isnull
Bindings
0:1913
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` =3827and `categories`.`deleted_at` isnull
Bindings
0:3827
Hints
Use SELECT * only if you need all columns from table
popular.blade.php#26mydatabase5.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` =6474and `categories`.`deleted_at` isnull
Bindings
0:6474
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` =2053and `categories`.`deleted_at` isnull
Bindings
0:2053
Hints
Use SELECT * only if you need all columns from table
popular.blade.php#26mydatabase5.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` =5202and `categories`.`deleted_at` isnull
Bindings
0:5202
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` =8881and `categories`.`deleted_at` isnull
Bindings
0:8881
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` =3177and `categories`.`deleted_at` isnull
Bindings
0:3177
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` =8285and `categories`.`deleted_at` isnull
Bindings
0:8285
Hints
Use SELECT * only if you need all columns from table
popular-article.blade.php#8mydatabase6.01msselect `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` =4131and `categories`.`deleted_at` isnull
Bindings
0:4131
Hints
Use SELECT * only if you need all columns from table