WebController.php#1557mydatabase264msselectcount(*) as aggregate from `posts` where (`deleted_at` isnulland `status` =1and `publish_date` <='2025-05-18 04:01:59'andexists (select*from `users` innerjoin `post_editor` on `users`.`id` = `post_editor`.`user_id` where `posts`.`id` = `post_editor`.`post_id` and `user_id` =87) 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` =87)) and `posts`.`deleted_at` isnull
WebController.php#1557mydatabase1.4msselect `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 (8468, 8469, 8475, 8482, 8483, 8485, 8491, 8500)
Hints
Use SELECT * only if you need all columns from table
WebController.php#1557mydatabase1.14msselect `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 (8468, 8469, 8475, 8482, 8483, 8485, 8491, 8500)
Hints
Use SELECT * only if you need all columns from table
index.blade.php#115mydatabase5.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` =8468and `categories`.`deleted_at` isnull
Bindings
0:8468
Hints
Use SELECT * only if you need all columns from table
index.blade.php#115mydatabase7.05msselect `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` =8469and `categories`.`deleted_at` isnull
Bindings
0:8469
Hints
Use SELECT * only if you need all columns from table
index.blade.php#115mydatabase5.82msselect `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` =8475and `categories`.`deleted_at` isnull
Bindings
0:8475
Hints
Use SELECT * only if you need all columns from table
index.blade.php#115mydatabase5.62msselect `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` =8482and `categories`.`deleted_at` isnull
Bindings
0:8482
Hints
Use SELECT * only if you need all columns from table
index.blade.php#115mydatabase5.63msselect `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` =8483and `categories`.`deleted_at` isnull
Bindings
0:8483
Hints
Use SELECT * only if you need all columns from table
index.blade.php#115mydatabase5.67msselect `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` =8485and `categories`.`deleted_at` isnull
Bindings
0:8485
Hints
Use SELECT * only if you need all columns from table
index.blade.php#115mydatabase5.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` =8491and `categories`.`deleted_at` isnull
Bindings
0:8491
Hints
Use SELECT * only if you need all columns from table
index.blade.php#115mydatabase5.66msselect `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` =8500and `categories`.`deleted_at` isnull
Bindings
0:8500
Hints
Use SELECT * only if you need all columns from table