WebController.php#1557mydatabase322msselectcount(*) as aggregate from `posts` where (`deleted_at` isnulland `status` =1and `publish_date` <='2025-07-15 18:15:58'andexists (select*from `users` innerjoin `post_editor` on `users`.`id` = `post_editor`.`user_id` where `posts`.`id` = `post_editor`.`post_id` and `user_id` =56) orexists (select*from `users` innerjoin `post_english_editors` on `users`.`id` = `post_english_editors`.`user_id` where `posts`.`id` = `post_english_editors`.`post_id` and `user_id` =56)) and `posts`.`deleted_at` isnull
WebController.php#1557mydatabase1.31msselect `users`.*, `post_editor`.`post_id` as `pivot_post_id`, `post_editor`.`user_id` as `pivot_user_id`, `post_editor`.`created_at` as `pivot_created_at`, `post_editor`.`updated_at` as `pivot_updated_at` from `users` innerjoin `post_editor` on `users`.`id` = `post_editor`.`user_id` where `post_editor`.`post_id` in (2662, 2681, 2682, 2689, 2692, 2694, 2706, 2714)
Hints
Use SELECT * only if you need all columns from table
WebController.php#1557mydatabase1.23msselect `users`.*, `post_english_editors`.`post_id` as `pivot_post_id`, `post_english_editors`.`user_id` as `pivot_user_id`, `post_english_editors`.`created_at` as `pivot_created_at`, `post_english_editors`.`updated_at` as `pivot_updated_at` from `users` innerjoin `post_english_editors` on `users`.`id` = `post_english_editors`.`user_id` where `post_english_editors`.`post_id` in (2662, 2681, 2682, 2689, 2692, 2694, 2706, 2714)
Hints
Use SELECT * only if you need all columns from table
index.blade.php#115mydatabase13.23msselect `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` =2662and `categories`.`deleted_at` isnull
Bindings
0:2662
Hints
Use SELECT * only if you need all columns from table
index.blade.php#115mydatabase5.99msselect `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` =2681and `categories`.`deleted_at` isnull
Bindings
0:2681
Hints
Use SELECT * only if you need all columns from table
index.blade.php#115mydatabase6.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` =2682and `categories`.`deleted_at` isnull
Bindings
0:2682
Hints
Use SELECT * only if you need all columns from table
index.blade.php#115mydatabase5.96msselect `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` =2689and `categories`.`deleted_at` isnull
Bindings
0:2689
Hints
Use SELECT * only if you need all columns from table
index.blade.php#115mydatabase5.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` =2692and `categories`.`deleted_at` isnull
Bindings
0:2692
Hints
Use SELECT * only if you need all columns from table
index.blade.php#115mydatabase6.52msselect `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` =2694and `categories`.`deleted_at` isnull
Bindings
0:2694
Hints
Use SELECT * only if you need all columns from table
index.blade.php#115mydatabase6.3msselect `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` =2706and `categories`.`deleted_at` isnull
Bindings
0:2706
Hints
Use SELECT * only if you need all columns from table
index.blade.php#115mydatabase6.15msselect `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` =2714and `categories`.`deleted_at` isnull
Bindings
0:2714
Hints
Use SELECT * only if you need all columns from table