Skip to content

Instantly share code, notes, and snippets.

@chadidi

chadidi/posts

Created June 3, 2020 21:06
Show Gist options
  • Save chadidi/4a7366643aa1d2a39cdb4ad6e1e2767f to your computer and use it in GitHub Desktop.
Save chadidi/4a7366643aa1d2a39cdb4ad6e1e2767f to your computer and use it in GitHub Desktop.
Download ZIP
Raw
posts
{
"debug": {
"database": {
"total": 166,
"items": [
{
"connection": "mysql",
"query": "select count(*) as aggregate from `posts` left join `likes` on `posts`.`id` = `likes`.`likable_id` and `likes`.`likable_type` = 'posts' left join `comments` on `posts`.`id` = `comments`.`commentable_id` and `comments`.`commentable_type` = 'posts' where `posts`.`deleted_at` is null group by `posts`.`id`;",
"time": 6.89
},
{
"connection": "mysql",
"query": "select posts.*, count(likes.id) + count(comments.id) as total_count from `posts` left join `likes` on `posts`.`id` = `likes`.`likable_id` and `likes`.`likable_type` = 'posts' left join `comments` on `posts`.`id` = `comments`.`commentable_id` and `comments`.`commentable_type` = 'posts' where `posts`.`deleted_at` is null group by `posts`.`id` order by `total_count` desc limit 15 offset 0;",
"time": 5.97
},
{
"connection": "mysql",
"query": "select * from `users` where `users`.`id` in (4, 1) and `users`.`deleted_at` is null;",
"time": 1.95
},
{
"connection": "mysql",
"query": "select * from `pages` where `pages`.`id` in (1, 2) and `pages`.`deleted_at` is null;",
"time": 1.4
},
{
"connection": "mysql",
"query": "select * from `users` where `users`.`id` in (4, 1) and `users`.`deleted_at` is null;",
"time": 2.02
},
{
"connection": "mysql",
"query": "select * from `pages` where `pages`.`id` in (1, 2) and `pages`.`deleted_at` is null;",
"time": 1.72
},
{
"connection": "mysql",
"query": "select * from `embeds` where `embeds`.`embeddable_id` in (1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15) and `embeds`.`embeddable_type` = 'posts' and `embeds`.`deleted_at` is null;",
"time": 2.14
},
{
"connection": "mysql",
"query": "select count(*) as aggregate from `comments` where `comments`.`commentable_id` = '1' and `comments`.`commentable_id` is not null and `comments`.`commentable_type` = 'posts' and `comments`.`deleted_at` is null;",
"time": 1.57
},
{
"connection": "mysql",
"query": "select count(*) as aggregate from `users` inner join `likes` on `users`.`id` = `likes`.`user_id` where `likes`.`likable_id` = '1' and `likable_type` = 'posts' and `likes`.`deleted_at` is null and `users`.`deleted_at` is null;",
"time": 1.74
},
{
"connection": "mysql",
"query": "select * from `media` where `media`.`model_id` = '1' and `media`.`model_id` is not null and `media`.`model_type` = 'posts';",
"time": 1.48
},
{
"connection": "mysql",
"query": "select `slug` from `slugs` where `slugs`.`slugable_id` = '4' and `slugs`.`slugable_id` is not null and `slugs`.`slugable_type` = 'users' limit 1;",
"time": 6.63
},
{
"connection": "mysql",
"query": "select * from `media` where `media`.`model_id` = '4' and `media`.`model_id` is not null and `media`.`model_type` = 'users';",
"time": 2.34
},
{
"connection": "mysql",
"query": "select `roles`.*, `model_has_roles`.`model_id` as `pivot_model_id`, `model_has_roles`.`role_id` as `pivot_role_id`, `model_has_roles`.`model_type` as `pivot_model_type` from `roles` inner join `model_has_roles` on `roles`.`id` = `model_has_roles`.`role_id` where `model_has_roles`.`model_id` = '4' and `model_has_roles`.`model_type` = 'users';",
"time": 1.82
},
{
"connection": "mysql",
"query": "select `slug` from `slugs` where `slugs`.`slugable_id` = '4' and `slugs`.`slugable_id` is not null and `slugs`.`slugable_type` = 'users' limit 1;",
"time": 1.5
},
{
"connection": "mysql",
"query": "select * from `media` where `media`.`model_id` = '4' and `media`.`model_id` is not null and `media`.`model_type` = 'users';",
"time": 1.73
},
{
"connection": "mysql",
"query": "select `roles`.*, `model_has_roles`.`model_id` as `pivot_model_id`, `model_has_roles`.`role_id` as `pivot_role_id`, `model_has_roles`.`model_type` as `pivot_model_type` from `roles` inner join `model_has_roles` on `roles`.`id` = `model_has_roles`.`role_id` where `model_has_roles`.`model_id` = '4' and `model_has_roles`.`model_type` = 'users';",
"time": 1.49
},
{
"connection": "mysql",
"query": "select count(*) as aggregate from `comments` where `comments`.`commentable_id` = '2' and `comments`.`commentable_id` is not null and `comments`.`commentable_type` = 'posts' and `comments`.`deleted_at` is null;",
"time": 1.78
},
{
"connection": "mysql",
"query": "select count(*) as aggregate from `users` inner join `likes` on `users`.`id` = `likes`.`user_id` where `likes`.`likable_id` = '2' and `likable_type` = 'posts' and `likes`.`deleted_at` is null and `users`.`deleted_at` is null;",
"time": 2.04
},
{
"connection": "mysql",
"query": "select * from `media` where `media`.`model_id` = '2' and `media`.`model_id` is not null and `media`.`model_type` = 'posts';",
"time": 1.61
},
{
"connection": "mysql",
"query": "select `slug` from `slugs` where `slugs`.`slugable_id` = '1' and `slugs`.`slugable_id` is not null and `slugs`.`slugable_type` = 'users' limit 1;",
"time": 1.31
},
{
"connection": "mysql",
"query": "select * from `media` where `media`.`model_id` = '1' and `media`.`model_id` is not null and `media`.`model_type` = 'users';",
"time": 1.5
},
{
"connection": "mysql",
"query": "select `roles`.*, `model_has_roles`.`model_id` as `pivot_model_id`, `model_has_roles`.`role_id` as `pivot_role_id`, `model_has_roles`.`model_type` as `pivot_model_type` from `roles` inner join `model_has_roles` on `roles`.`id` = `model_has_roles`.`role_id` where `model_has_roles`.`model_id` = '1' and `model_has_roles`.`model_type` = 'users';",
"time": 1.96
},
{
"connection": "mysql",
"query": "select `slug` from `slugs` where `slugs`.`slugable_id` = '1' and `slugs`.`slugable_id` is not null and `slugs`.`slugable_type` = 'users' limit 1;",
"time": 1.37
},
{
"connection": "mysql",
"query": "select * from `media` where `media`.`model_id` = '1' and `media`.`model_id` is not null and `media`.`model_type` = 'users';",
"time": 1.31
},
{
"connection": "mysql",
"query": "select `roles`.*, `model_has_roles`.`model_id` as `pivot_model_id`, `model_has_roles`.`role_id` as `pivot_role_id`, `model_has_roles`.`model_type` as `pivot_model_type` from `roles` inner join `model_has_roles` on `roles`.`id` = `model_has_roles`.`role_id` where `model_has_roles`.`model_id` = '1' and `model_has_roles`.`model_type` = 'users';",
"time": 1.45
},
{
"connection": "mysql",
"query": "select count(*) as aggregate from `comments` where `comments`.`commentable_id` = '3' and `comments`.`commentable_id` is not null and `comments`.`commentable_type` = 'posts' and `comments`.`deleted_at` is null;",
"time": 1.44
},
{
"connection": "mysql",
"query": "select count(*) as aggregate from `users` inner join `likes` on `users`.`id` = `likes`.`user_id` where `likes`.`likable_id` = '3' and `likable_type` = 'posts' and `likes`.`deleted_at` is null and `users`.`deleted_at` is null;",
"time": 1.5
},
{
"connection": "mysql",
"query": "select * from `media` where `media`.`model_id` = '3' and `media`.`model_id` is not null and `media`.`model_type` = 'posts';",
"time": 1.59
},
{
"connection": "mysql",
"query": "select * from `options` where `collection_name` = 'company_size' and `key` is null limit 1;",
"time": 3.33
},
{
"connection": "mysql",
"query": "select * from `options` where `collection_name` = 'company_type' and `key` is null limit 1;",
"time": 1.81
},
{
"connection": "mysql",
"query": "select * from `options` where `collection_name` = 'industry' and `key` is null limit 1;",
"time": 1.42
},
{
"connection": "mysql",
"query": "select `slug` from `slugs` where `slugs`.`slugable_id` = '1' and `slugs`.`slugable_id` is not null and `slugs`.`slugable_type` = 'pages' limit 1;",
"time": 1.66
},
{
"connection": "mysql",
"query": "select * from `media` where `media`.`model_id` = '1' and `media`.`model_id` is not null and `media`.`model_type` = 'pages';",
"time": 1.79
},
{
"connection": "mysql",
"query": "select * from `options` where `collection_name` = 'company_size' and `key` is null limit 1;",
"time": 1.33
},
{
"connection": "mysql",
"query": "select * from `options` where `collection_name` = 'company_type' and `key` is null limit 1;",
"time": 1.45
},
{
"connection": "mysql",
"query": "select * from `options` where `collection_name` = 'industry' and `key` is null limit 1;",
"time": 1.62
},
{
"connection": "mysql",
"query": "select `slug` from `slugs` where `slugs`.`slugable_id` = '1' and `slugs`.`slugable_id` is not null and `slugs`.`slugable_type` = 'pages' limit 1;",
"time": 1.53
},
{
"connection": "mysql",
"query": "select * from `media` where `media`.`model_id` = '1' and `media`.`model_id` is not null and `media`.`model_type` = 'pages';",
"time": 1.81
},
{
"connection": "mysql",
"query": "select count(*) as aggregate from `comments` where `comments`.`commentable_id` = '4' and `comments`.`commentable_id` is not null and `comments`.`commentable_type` = 'posts' and `comments`.`deleted_at` is null;",
"time": 1.75
},
{
"connection": "mysql",
"query": "select count(*) as aggregate from `users` inner join `likes` on `users`.`id` = `likes`.`user_id` where `likes`.`likable_id` = '4' and `likable_type` = 'posts' and `likes`.`deleted_at` is null and `users`.`deleted_at` is null;",
"time": 1.65
},
{
"connection": "mysql",
"query": "select * from `media` where `media`.`model_id` = '4' and `media`.`model_id` is not null and `media`.`model_type` = 'posts';",
"time": 1.72
},
{
"connection": "mysql",
"query": "select `slug` from `slugs` where `slugs`.`slugable_id` = '1' and `slugs`.`slugable_id` is not null and `slugs`.`slugable_type` = 'users' limit 1;",
"time": 1.79
},
{
"connection": "mysql",
"query": "select `slug` from `slugs` where `slugs`.`slugable_id` = '1' and `slugs`.`slugable_id` is not null and `slugs`.`slugable_type` = 'users' limit 1;",
"time": 1.54
},
{
"connection": "mysql",
"query": "select count(*) as aggregate from `comments` where `comments`.`commentable_id` = '5' and `comments`.`commentable_id` is not null and `comments`.`commentable_type` = 'posts' and `comments`.`deleted_at` is null;",
"time": 1.53
},
{
"connection": "mysql",
"query": "select count(*) as aggregate from `users` inner join `likes` on `users`.`id` = `likes`.`user_id` where `likes`.`likable_id` = '5' and `likable_type` = 'posts' and `likes`.`deleted_at` is null and `users`.`deleted_at` is null;",
"time": 1.64
},
{
"connection": "mysql",
"query": "select * from `media` where `media`.`model_id` = '5' and `media`.`model_id` is not null and `media`.`model_type` = 'posts';",
"time": 1.64
},
{
"connection": "mysql",
"query": "select * from `options` where `collection_name` = 'company_size' and `key` is null limit 1;",
"time": 1.16
},
{
"connection": "mysql",
"query": "select * from `options` where `collection_name` = 'company_type' and `key` is null limit 1;",
"time": 1.34
},
{
"connection": "mysql",
"query": "select * from `options` where `collection_name` = 'industry' and `key` is null limit 1;",
"time": 1.22
},
{
"connection": "mysql",
"query": "select `slug` from `slugs` where `slugs`.`slugable_id` = '1' and `slugs`.`slugable_id` is not null and `slugs`.`slugable_type` = 'pages' limit 1;",
"time": 1.19
},
{
"connection": "mysql",
"query": "select * from `options` where `collection_name` = 'company_size' and `key` is null limit 1;",
"time": 1.5
},
{
"connection": "mysql",
"query": "select * from `options` where `collection_name` = 'company_type' and `key` is null limit 1;",
"time": 1.45
},
{
"connection": "mysql",
"query": "select * from `options` where `collection_name` = 'industry' and `key` is null limit 1;",
"time": 1.43
},
{
"connection": "mysql",
"query": "select `slug` from `slugs` where `slugs`.`slugable_id` = '1' and `slugs`.`slugable_id` is not null and `slugs`.`slugable_type` = 'pages' limit 1;",
"time": 2.18
},
{
"connection": "mysql",
"query": "select count(*) as aggregate from `comments` where `comments`.`commentable_id` = '6' and `comments`.`commentable_id` is not null and `comments`.`commentable_type` = 'posts' and `comments`.`deleted_at` is null;",
"time": 1.51
},
{
"connection": "mysql",
"query": "select count(*) as aggregate from `users` inner join `likes` on `users`.`id` = `likes`.`user_id` where `likes`.`likable_id` = '6' and `likable_type` = 'posts' and `likes`.`deleted_at` is null and `users`.`deleted_at` is null;",
"time": 1.68
},
{
"connection": "mysql",
"query": "select * from `media` where `media`.`model_id` = '6' and `media`.`model_id` is not null and `media`.`model_type` = 'posts';",
"time": 2.1
},
{
"connection": "mysql",
"query": "select * from `options` where `collection_name` = 'company_size' and `key` is null limit 1;",
"time": 1.31
},
{
"connection": "mysql",
"query": "select * from `options` where `collection_name` = 'company_type' and `key` is null limit 1;",
"time": 2.28
},
{
"connection": "mysql",
"query": "select * from `options` where `collection_name` = 'industry' and `key` is null limit 1;",
"time": 1.52
},
{
"connection": "mysql",
"query": "select `slug` from `slugs` where `slugs`.`slugable_id` = '1' and `slugs`.`slugable_id` is not null and `slugs`.`slugable_type` = 'pages' limit 1;",
"time": 1.41
},
{
"connection": "mysql",
"query": "select * from `options` where `collection_name` = 'company_size' and `key` is null limit 1;",
"time": 1.44
},
{
"connection": "mysql",
"query": "select * from `options` where `collection_name` = 'company_type' and `key` is null limit 1;",
"time": 1.13
},
{
"connection": "mysql",
"query": "select * from `options` where `collection_name` = 'industry' and `key` is null limit 1;",
"time": 1.1
},
{
"connection": "mysql",
"query": "select `slug` from `slugs` where `slugs`.`slugable_id` = '1' and `slugs`.`slugable_id` is not null and `slugs`.`slugable_type` = 'pages' limit 1;",
"time": 0.79
},
{
"connection": "mysql",
"query": "select count(*) as aggregate from `comments` where `comments`.`commentable_id` = '7' and `comments`.`commentable_id` is not null and `comments`.`commentable_type` = 'posts' and `comments`.`deleted_at` is null;",
"time": 1.71
},
{
"connection": "mysql",
"query": "select count(*) as aggregate from `users` inner join `likes` on `users`.`id` = `likes`.`user_id` where `likes`.`likable_id` = '7' and `likable_type` = 'posts' and `likes`.`deleted_at` is null and `users`.`deleted_at` is null;",
"time": 1.71
},
{
"connection": "mysql",
"query": "select * from `media` where `media`.`model_id` = '7' and `media`.`model_id` is not null and `media`.`model_type` = 'posts';",
"time": 1.71
},
{
"connection": "mysql",
"query": "select * from `options` where `collection_name` = 'company_size' and `key` is null limit 1;",
"time": 1.24
},
{
"connection": "mysql",
"query": "select * from `options` where `collection_name` = 'company_type' and `key` is null limit 1;",
"time": 1.52
},
{
"connection": "mysql",
"query": "select * from `options` where `collection_name` = 'industry' and `key` is null limit 1;",
"time": 0.92
},
{
"connection": "mysql",
"query": "select `slug` from `slugs` where `slugs`.`slugable_id` = '1' and `slugs`.`slugable_id` is not null and `slugs`.`slugable_type` = 'pages' limit 1;",
"time": 1.14
},
{
"connection": "mysql",
"query": "select * from `options` where `collection_name` = 'company_size' and `key` is null limit 1;",
"time": 1.26
},
{
"connection": "mysql",
"query": "select * from `options` where `collection_name` = 'company_type' and `key` is null limit 1;",
"time": 1.52
},
{
"connection": "mysql",
"query": "select * from `options` where `collection_name` = 'industry' and `key` is null limit 1;",
"time": 1.28
},
{
"connection": "mysql",
"query": "select `slug` from `slugs` where `slugs`.`slugable_id` = '1' and `slugs`.`slugable_id` is not null and `slugs`.`slugable_type` = 'pages' limit 1;",
"time": 1.25
},
{
"connection": "mysql",
"query": "select count(*) as aggregate from `comments` where `comments`.`commentable_id` = '8' and `comments`.`commentable_id` is not null and `comments`.`commentable_type` = 'posts' and `comments`.`deleted_at` is null;",
"time": 1.4
},
{
"connection": "mysql",
"query": "select count(*) as aggregate from `users` inner join `likes` on `users`.`id` = `likes`.`user_id` where `likes`.`likable_id` = '8' and `likable_type` = 'posts' and `likes`.`deleted_at` is null and `users`.`deleted_at` is null;",
"time": 1.93
},
{
"connection": "mysql",
"query": "select * from `media` where `media`.`model_id` = '8' and `media`.`model_id` is not null and `media`.`model_type` = 'posts';",
"time": 1.54
},
{
"connection": "mysql",
"query": "select * from `options` where `collection_name` = 'company_size' and `key` is null limit 1;",
"time": 1.1
},
{
"connection": "mysql",
"query": "select * from `options` where `collection_name` = 'company_type' and `key` is null limit 1;",
"time": 1.17
},
{
"connection": "mysql",
"query": "select * from `options` where `collection_name` = 'industry' and `key` is null limit 1;",
"time": 1.64
},
{
"connection": "mysql",
"query": "select `slug` from `slugs` where `slugs`.`slugable_id` = '1' and `slugs`.`slugable_id` is not null and `slugs`.`slugable_type` = 'pages' limit 1;",
"time": 1.65
},
{
"connection": "mysql",
"query": "select * from `options` where `collection_name` = 'company_size' and `key` is null limit 1;",
"time": 1.27
},
{
"connection": "mysql",
"query": "select * from `options` where `collection_name` = 'company_type' and `key` is null limit 1;",
"time": 1.08
},
{
"connection": "mysql",
"query": "select * from `options` where `collection_name` = 'industry' and `key` is null limit 1;",
"time": 1.2
},
{
"connection": "mysql",
"query": "select `slug` from `slugs` where `slugs`.`slugable_id` = '1' and `slugs`.`slugable_id` is not null and `slugs`.`slugable_type` = 'pages' limit 1;",
"time": 1.41
},
{
"connection": "mysql",
"query": "select count(*) as aggregate from `comments` where `comments`.`commentable_id` = '9' and `comments`.`commentable_id` is not null and `comments`.`commentable_type` = 'posts' and `comments`.`deleted_at` is null;",
"time": 1.62
},
{
"connection": "mysql",
"query": "select count(*) as aggregate from `users` inner join `likes` on `users`.`id` = `likes`.`user_id` where `likes`.`likable_id` = '9' and `likable_type` = 'posts' and `likes`.`deleted_at` is null and `users`.`deleted_at` is null;",
"time": 2.05
},
{
"connection": "mysql",
"query": "select * from `media` where `media`.`model_id` = '9' and `media`.`model_id` is not null and `media`.`model_type` = 'posts';",
"time": 1.59
},
{
"connection": "mysql",
"query": "select * from `options` where `collection_name` = 'company_size' and `key` is null limit 1;",
"time": 1.41
},
{
"connection": "mysql",
"query": "select * from `options` where `collection_name` = 'company_type' and `key` is null limit 1;",
"time": 1.18
},
{
"connection": "mysql",
"query": "select * from `options` where `collection_name` = 'industry' and `key` is null limit 1;",
"time": 1.16
},
{
"connection": "mysql",
"query": "select `slug` from `slugs` where `slugs`.`slugable_id` = '1' and `slugs`.`slugable_id` is not null and `slugs`.`slugable_type` = 'pages' limit 1;",
"time": 1.53
},
{
"connection": "mysql",
"query": "select * from `options` where `collection_name` = 'company_size' and `key` is null limit 1;",
"time": 1.29
},
{
"connection": "mysql",
"query": "select * from `options` where `collection_name` = 'company_type' and `key` is null limit 1;",
"time": 1.48
},
{
"connection": "mysql",
"query": "select * from `options` where `collection_name` = 'industry' and `key` is null limit 1;",
"time": 1.4
},
{
"connection": "mysql",
"query": "select `slug` from `slugs` where `slugs`.`slugable_id` = '1' and `slugs`.`slugable_id` is not null and `slugs`.`slugable_type` = 'pages' limit 1;",
"time": 1.35
},
{
"connection": "mysql",
"query": "select count(*) as aggregate from `comments` where `comments`.`commentable_id` = '10' and `comments`.`commentable_id` is not null and `comments`.`commentable_type` = 'posts' and `comments`.`deleted_at` is null;",
"time": 1.81
},
{
"connection": "mysql",
"query": "select count(*) as aggregate from `users` inner join `likes` on `users`.`id` = `likes`.`user_id` where `likes`.`likable_id` = '10' and `likable_type` = 'posts' and `likes`.`deleted_at` is null and `users`.`deleted_at` is null;",
"time": 1.72
},
{
"connection": "mysql",
"query": "select * from `media` where `media`.`model_id` = '10' and `media`.`model_id` is not null and `media`.`model_type` = 'posts';",
"time": 1.77
},
{
"connection": "mysql",
"query": "select * from `options` where `collection_name` = 'company_size' and `key` is null limit 1;",
"time": 1.28
},
{
"connection": "mysql",
"query": "select * from `options` where `collection_name` = 'company_type' and `key` is null limit 1;",
"time": 1.39
},
{
"connection": "mysql",
"query": "select * from `options` where `collection_name` = 'industry' and `key` is null limit 1;",
"time": 1.1
},
{
"connection": "mysql",
"query": "select `slug` from `slugs` where `slugs`.`slugable_id` = '1' and `slugs`.`slugable_id` is not null and `slugs`.`slugable_type` = 'pages' limit 1;",
"time": 1.5
},
{
"connection": "mysql",
"query": "select * from `options` where `collection_name` = 'company_size' and `key` is null limit 1;",
"time": 1.17
},
{
"connection": "mysql",
"query": "select * from `options` where `collection_name` = 'company_type' and `key` is null limit 1;",
"time": 1.53
},
{
"connection": "mysql",
"query": "select * from `options` where `collection_name` = 'industry' and `key` is null limit 1;",
"time": 1.39
},
{
"connection": "mysql",
"query": "select `slug` from `slugs` where `slugs`.`slugable_id` = '1' and `slugs`.`slugable_id` is not null and `slugs`.`slugable_type` = 'pages' limit 1;",
"time": 1.79
},
{
"connection": "mysql",
"query": "select count(*) as aggregate from `comments` where `comments`.`commentable_id` = '11' and `comments`.`commentable_id` is not null and `comments`.`commentable_type` = 'posts' and `comments`.`deleted_at` is null;",
"time": 1.65
},
{
"connection": "mysql",
"query": "select count(*) as aggregate from `users` inner join `likes` on `users`.`id` = `likes`.`user_id` where `likes`.`likable_id` = '11' and `likable_type` = 'posts' and `likes`.`deleted_at` is null and `users`.`deleted_at` is null;",
"time": 1.33
},
{
"connection": "mysql",
"query": "select * from `media` where `media`.`model_id` = '11' and `media`.`model_id` is not null and `media`.`model_type` = 'posts';",
"time": 1.69
},
{
"connection": "mysql",
"query": "select * from `options` where `collection_name` = 'company_size' and `key` is null limit 1;",
"time": 1.23
},
{
"connection": "mysql",
"query": "select * from `options` where `collection_name` = 'company_type' and `key` is null limit 1;",
"time": 1.25
},
{
"connection": "mysql",
"query": "select * from `options` where `collection_name` = 'industry' and `key` is null limit 1;",
"time": 1.4
},
{
"connection": "mysql",
"query": "select `slug` from `slugs` where `slugs`.`slugable_id` = '1' and `slugs`.`slugable_id` is not null and `slugs`.`slugable_type` = 'pages' limit 1;",
"time": 1.37
},
{
"connection": "mysql",
"query": "select * from `options` where `collection_name` = 'company_size' and `key` is null limit 1;",
"time": 1.2
},
{
"connection": "mysql",
"query": "select * from `options` where `collection_name` = 'company_type' and `key` is null limit 1;",
"time": 1.1
},
{
"connection": "mysql",
"query": "select * from `options` where `collection_name` = 'industry' and `key` is null limit 1;",
"time": 1.23
},
{
"connection": "mysql",
"query": "select `slug` from `slugs` where `slugs`.`slugable_id` = '1' and `slugs`.`slugable_id` is not null and `slugs`.`slugable_type` = 'pages' limit 1;",
"time": 1.43
},
{
"connection": "mysql",
"query": "select count(*) as aggregate from `comments` where `comments`.`commentable_id` = '12' and `comments`.`commentable_id` is not null and `comments`.`commentable_type` = 'posts' and `comments`.`deleted_at` is null;",
"time": 1.62
},
{
"connection": "mysql",
"query": "select count(*) as aggregate from `users` inner join `likes` on `users`.`id` = `likes`.`user_id` where `likes`.`likable_id` = '12' and `likable_type` = 'posts' and `likes`.`deleted_at` is null and `users`.`deleted_at` is null;",
"time": 1.46
},
{
"connection": "mysql",
"query": "select * from `media` where `media`.`model_id` = '12' and `media`.`model_id` is not null and `media`.`model_type` = 'posts';",
"time": 1.8
},
{
"connection": "mysql",
"query": "select * from `options` where `collection_name` = 'company_size' and `key` is null limit 1;",
"time": 1.12
},
{
"connection": "mysql",
"query": "select * from `options` where `collection_name` = 'company_type' and `key` is null limit 1;",
"time": 1.17
},
{
"connection": "mysql",
"query": "select * from `options` where `collection_name` = 'industry' and `key` is null limit 1;",
"time": 1.27
},
{
"connection": "mysql",
"query": "select `slug` from `slugs` where `slugs`.`slugable_id` = '1' and `slugs`.`slugable_id` is not null and `slugs`.`slugable_type` = 'pages' limit 1;",
"time": 1.43
},
{
"connection": "mysql",
"query": "select * from `options` where `collection_name` = 'company_size' and `key` is null limit 1;",
"time": 1.22
},
{
"connection": "mysql",
"query": "select * from `options` where `collection_name` = 'company_type' and `key` is null limit 1;",
"time": 1.17
},
{
"connection": "mysql",
"query": "select * from `options` where `collection_name` = 'industry' and `key` is null limit 1;",
"time": 1.08
},
{
"connection": "mysql",
"query": "select `slug` from `slugs` where `slugs`.`slugable_id` = '1' and `slugs`.`slugable_id` is not null and `slugs`.`slugable_type` = 'pages' limit 1;",
"time": 1.49
},
{
"connection": "mysql",
"query": "select count(*) as aggregate from `comments` where `comments`.`commentable_id` = '13' and `comments`.`commentable_id` is not null and `comments`.`commentable_type` = 'posts' and `comments`.`deleted_at` is null;",
"time": 1.87
},
{
"connection": "mysql",
"query": "select count(*) as aggregate from `users` inner join `likes` on `users`.`id` = `likes`.`user_id` where `likes`.`likable_id` = '13' and `likable_type` = 'posts' and `likes`.`deleted_at` is null and `users`.`deleted_at` is null;",
"time": 1.58
},
{
"connection": "mysql",
"query": "select * from `media` where `media`.`model_id` = '13' and `media`.`model_id` is not null and `media`.`model_type` = 'posts';",
"time": 1.68
},
{
"connection": "mysql",
"query": "select * from `options` where `collection_name` = 'company_size' and `key` is null limit 1;",
"time": 1.4
},
{
"connection": "mysql",
"query": "select * from `options` where `collection_name` = 'company_type' and `key` is null limit 1;",
"time": 1.26
},
{
"connection": "mysql",
"query": "select * from `options` where `collection_name` = 'industry' and `key` is null limit 1;",
"time": 1.03
},
{
"connection": "mysql",
"query": "select `slug` from `slugs` where `slugs`.`slugable_id` = '1' and `slugs`.`slugable_id` is not null and `slugs`.`slugable_type` = 'pages' limit 1;",
"time": 1.39
},
{
"connection": "mysql",
"query": "select * from `options` where `collection_name` = 'company_size' and `key` is null limit 1;",
"time": 1.23
},
{
"connection": "mysql",
"query": "select * from `options` where `collection_name` = 'company_type' and `key` is null limit 1;",
"time": 1.09
},
{
"connection": "mysql",
"query": "select * from `options` where `collection_name` = 'industry' and `key` is null limit 1;",
"time": 1.35
},
{
"connection": "mysql",
"query": "select `slug` from `slugs` where `slugs`.`slugable_id` = '1' and `slugs`.`slugable_id` is not null and `slugs`.`slugable_type` = 'pages' limit 1;",
"time": 1.59
},
{
"connection": "mysql",
"query": "select count(*) as aggregate from `comments` where `comments`.`commentable_id` = '14' and `comments`.`commentable_id` is not null and `comments`.`commentable_type` = 'posts' and `comments`.`deleted_at` is null;",
"time": 1.64
},
{
"connection": "mysql",
"query": "select count(*) as aggregate from `users` inner join `likes` on `users`.`id` = `likes`.`user_id` where `likes`.`likable_id` = '14' and `likable_type` = 'posts' and `likes`.`deleted_at` is null and `users`.`deleted_at` is null;",
"time": 1.37
},
{
"connection": "mysql",
"query": "select * from `media` where `media`.`model_id` = '14' and `media`.`model_id` is not null and `media`.`model_type` = 'posts';",
"time": 1.49
},
{
"connection": "mysql",
"query": "select * from `options` where `collection_name` = 'company_size' and `key` is null limit 1;",
"time": 1.25
},
{
"connection": "mysql",
"query": "select * from `options` where `collection_name` = 'company_type' and `key` is null limit 1;",
"time": 1.38
},
{
"connection": "mysql",
"query": "select * from `options` where `collection_name` = 'industry' and `key` is null limit 1;",
"time": 1.26
},
{
"connection": "mysql",
"query": "select `slug` from `slugs` where `slugs`.`slugable_id` = '1' and `slugs`.`slugable_id` is not null and `slugs`.`slugable_type` = 'pages' limit 1;",
"time": 1.27
},
{
"connection": "mysql",
"query": "select * from `options` where `collection_name` = 'company_size' and `key` is null limit 1;",
"time": 1.57
},
{
"connection": "mysql",
"query": "select * from `options` where `collection_name` = 'company_type' and `key` is null limit 1;",
"time": 1.28
},
{
"connection": "mysql",
"query": "select * from `options` where `collection_name` = 'industry' and `key` is null limit 1;",
"time": 1.28
},
{
"connection": "mysql",
"query": "select `slug` from `slugs` where `slugs`.`slugable_id` = '1' and `slugs`.`slugable_id` is not null and `slugs`.`slugable_type` = 'pages' limit 1;",
"time": 1.21
},
{
"connection": "mysql",
"query": "select count(*) as aggregate from `comments` where `comments`.`commentable_id` = '15' and `comments`.`commentable_id` is not null and `comments`.`commentable_type` = 'posts' and `comments`.`deleted_at` is null;",
"time": 2.42
},
{
"connection": "mysql",
"query": "select count(*) as aggregate from `users` inner join `likes` on `users`.`id` = `likes`.`user_id` where `likes`.`likable_id` = '15' and `likable_type` = 'posts' and `likes`.`deleted_at` is null and `users`.`deleted_at` is null;",
"time": 3.56
},
{
"connection": "mysql",
"query": "select * from `media` where `media`.`model_id` = '15' and `media`.`model_id` is not null and `media`.`model_type` = 'posts';",
"time": 2.42
},
{
"connection": "mysql",
"query": "select * from `options` where `collection_name` = 'company_size' and `key` = '1' limit 1;",
"time": 2.03
},
{
"connection": "mysql",
"query": "select * from `options` where `collection_name` = 'company_type' and `key` = '1' limit 1;",
"time": 2.05
},
{
"connection": "mysql",
"query": "select * from `options` where `collection_name` = 'industry' and `key` = '1' limit 1;",
"time": 2.32
},
{
"connection": "mysql",
"query": "select `slug` from `slugs` where `slugs`.`slugable_id` = '2' and `slugs`.`slugable_id` is not null and `slugs`.`slugable_type` = 'pages' limit 1;",
"time": 2.13
},
{
"connection": "mysql",
"query": "select * from `media` where `media`.`model_id` = '2' and `media`.`model_id` is not null and `media`.`model_type` = 'pages';",
"time": 2.7
},
{
"connection": "mysql",
"query": "select * from `options` where `collection_name` = 'company_size' and `key` = '1' limit 1;",
"time": 2.47
},
{
"connection": "mysql",
"query": "select * from `options` where `collection_name` = 'company_type' and `key` = '1' limit 1;",
"time": 3.15
},
{
"connection": "mysql",
"query": "select * from `options` where `collection_name` = 'industry' and `key` = '1' limit 1;",
"time": 2.54
},
{
"connection": "mysql",
"query": "select `slug` from `slugs` where `slugs`.`slugable_id` = '2' and `slugs`.`slugable_id` is not null and `slugs`.`slugable_type` = 'pages' limit 1;",
"time": 2.08
},
{
"connection": "mysql",
"query": "select * from `media` where `media`.`model_id` = '2' and `media`.`model_id` is not null and `media`.`model_type` = 'pages';",
"time": 2.52
}
]
},
"cache": {
"hit": {
"keys": [
"model_settings:::has_field",
"model_settings:::has_field",
"model_settings:::has_field",
"model_settings:::has_field",
"model_settings:::has_field",
"model_settings:::has_field",
"4f23c8578311437eb321f92d8c49d7e409f664d4"
],
"total": 7
},
"miss": {
"keys": [
"4f23c8578311437eb321f92d8c49d7e409f664d4"
],
"total": 1
},
"write": {
"keys": [],
"total": 0
},
"forget": {
"keys": [],
"total": 0
}
},
"profiling": [
{
"event": "request-time",
"time": 3.2941439151763916
}
],
"memory": {
"usage": 6644304,
"peak": 6644680
}
}
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment