WebController.php#1557mydatabase239msselectcount(*) as aggregate from `posts` where (`deleted_at` isnulland `status` =1and `publish_date` <='2025-07-15 06:30:16'andexists (select*from `users` innerjoin `post_editor` on `users`.`id` = `post_editor`.`user_id` where `posts`.`id` = `post_editor`.`post_id` and `user_id` =22) 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` =22)) and `posts`.`deleted_at` isnull
WebController.php#1557mydatabase870μsselect `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 (3086, 3087, 3090, 3095, 3100, 3102, 3107, 3108)
Hints
Use SELECT * only if you need all columns from table
WebController.php#1557mydatabase760μ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 (3086, 3087, 3090, 3095, 3100, 3102, 3107, 3108)
Hints
Use SELECT * only if you need all columns from table
index.blade.php#115mydatabase10.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` =3086and `categories`.`deleted_at` isnull
Bindings
0:3086
Hints
Use SELECT * only if you need all columns from table
index.blade.php#115mydatabase8.75msselect `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` =3087and `categories`.`deleted_at` isnull
Bindings
0:3087
Hints
Use SELECT * only if you need all columns from table
index.blade.php#115mydatabase11.57msselect `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` =3090and `categories`.`deleted_at` isnull
Bindings
0:3090
Hints
Use SELECT * only if you need all columns from table
index.blade.php#115mydatabase6.47msselect `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` =3095and `categories`.`deleted_at` isnull
Bindings
0:3095
Hints
Use SELECT * only if you need all columns from table
index.blade.php#115mydatabase6.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` =3100and `categories`.`deleted_at` isnull
Bindings
0:3100
Hints
Use SELECT * only if you need all columns from table
index.blade.php#115mydatabase6.14msselect `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` =3102and `categories`.`deleted_at` isnull
Bindings
0:3102
Hints
Use SELECT * only if you need all columns from table
index.blade.php#115mydatabase5.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` =3107and `categories`.`deleted_at` isnull
Bindings
0:3107
Hints
Use SELECT * only if you need all columns from table
index.blade.php#115mydatabase5.88msselect `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` =3108and `categories`.`deleted_at` isnull
Bindings
0:3108
Hints
Use SELECT * only if you need all columns from table