WebController.php#1557mydatabase339msselectcount(*) as aggregate from `posts` where (`deleted_at` isnulland `status` =1and `publish_date` <='2025-05-18 05:29:43'andexists (select*from `users` innerjoin `post_editor` on `users`.`id` = `post_editor`.`user_id` where `posts`.`id` = `post_editor`.`post_id` and `user_id` =88) 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` =88)) and `posts`.`deleted_at` isnull
WebController.php#1557mydatabase1.08msselect `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 (3329, 3477, 3486, 3504, 3506, 3550, 3577, 3581)
Hints
Use SELECT * only if you need all columns from table
WebController.php#1557mydatabase910μsselect `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 (3329, 3477, 3486, 3504, 3506, 3550, 3577, 3581)
Hints
Use SELECT * only if you need all columns from table
index.blade.php#115mydatabase5.95msselect `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` =3329and `categories`.`deleted_at` isnull
Bindings
0:3329
Hints
Use SELECT * only if you need all columns from table
index.blade.php#115mydatabase4.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` =3477and `categories`.`deleted_at` isnull
Bindings
0:3477
Hints
Use SELECT * only if you need all columns from table
index.blade.php#115mydatabase4.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` =3486and `categories`.`deleted_at` isnull
Bindings
0:3486
Hints
Use SELECT * only if you need all columns from table
index.blade.php#115mydatabase5.12msselect `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` =3504and `categories`.`deleted_at` isnull
Bindings
0:3504
Hints
Use SELECT * only if you need all columns from table
index.blade.php#115mydatabase4.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` =3506and `categories`.`deleted_at` isnull
Bindings
0:3506
Hints
Use SELECT * only if you need all columns from table
index.blade.php#115mydatabase4.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` =3550and `categories`.`deleted_at` isnull
Bindings
0:3550
Hints
Use SELECT * only if you need all columns from table
index.blade.php#115mydatabase5.07msselect `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` =3577and `categories`.`deleted_at` isnull
Bindings
0:3577
Hints
Use SELECT * only if you need all columns from table
index.blade.php#115mydatabase4.94msselect `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` =3581and `categories`.`deleted_at` isnull
Bindings
0:3581
Hints
Use SELECT * only if you need all columns from table