Skip to content

Instantly share code, notes, and snippets.

@chadidi
Created June 3, 2020 21:10
Show Gist options
  • Save chadidi/d80c324fcea7b4ed4e1f3deaaa024b2f to your computer and use it in GitHub Desktop.
Save chadidi/d80c324fcea7b4ed4e1f3deaaa024b2f to your computer and use it in GitHub Desktop.
[2020-06-03 21:09:38] local.INFO: select count(*) as aggregate from `posts` left join `likes` on `posts`.`id` = `likes`.`likable_id` and `likes`.`likable_type` = ? left join `comments` on `posts`.`id` = `comments`.`commentable_id` and `comments`.`commentable_type` = ? where `posts`.`deleted_at` is null group by `posts`.`id` ["posts","posts"]
[2020-06-03 21:09:38] local.INFO: 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` = ? left join `comments` on `posts`.`id` = `comments`.`commentable_id` and `comments`.`commentable_type` = ? where `posts`.`deleted_at` is null group by `posts`.`id` order by `total_count` desc limit 15 offset 0 ["posts","posts"]
[2020-06-03 21:09:38] local.INFO: select * from `users` where `users`.`id` in (4, 1) and `users`.`deleted_at` is null
[2020-06-03 21:09:38] local.INFO: select * from `pages` where `pages`.`id` in (1, 2) and `pages`.`deleted_at` is null
[2020-06-03 21:09:38] local.INFO: select * from `users` where `users`.`id` in (4, 1) and `users`.`deleted_at` is null
[2020-06-03 21:09:38] local.INFO: select * from `pages` where `pages`.`id` in (1, 2) and `pages`.`deleted_at` is null
[2020-06-03 21:09:38] local.INFO: 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` = ? and `embeds`.`deleted_at` is null ["posts"]
[2020-06-03 21:09:39] local.INFO: select count(*) as aggregate from `comments` where `comments`.`commentable_id` = ? and `comments`.`commentable_id` is not null and `comments`.`commentable_type` = ? and `comments`.`deleted_at` is null [1,"posts"]
[2020-06-03 21:09:39] local.INFO: select count(*) as aggregate from `users` inner join `likes` on `users`.`id` = `likes`.`user_id` where `likes`.`likable_id` = ? and `likable_type` = ? and `likes`.`deleted_at` is null and `users`.`deleted_at` is null [1,"posts"]
[2020-06-03 21:09:39] local.INFO: select * from `media` where `media`.`model_id` = ? and `media`.`model_id` is not null and `media`.`model_type` = ? [1,"posts"]
[2020-06-03 21:09:39] local.INFO: select `slug` from `slugs` where `slugs`.`slugable_id` = ? and `slugs`.`slugable_id` is not null and `slugs`.`slugable_type` = ? limit 1 [4,"users"]
[2020-06-03 21:09:39] local.INFO: select * from `media` where `media`.`model_id` = ? and `media`.`model_id` is not null and `media`.`model_type` = ? [4,"users"]
[2020-06-03 21:09:39] local.INFO: 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` = ? and `model_has_roles`.`model_type` = ? [4,"users"]
[2020-06-03 21:09:39] local.INFO: select `slug` from `slugs` where `slugs`.`slugable_id` = ? and `slugs`.`slugable_id` is not null and `slugs`.`slugable_type` = ? limit 1 [4,"users"]
[2020-06-03 21:09:39] local.INFO: select * from `media` where `media`.`model_id` = ? and `media`.`model_id` is not null and `media`.`model_type` = ? [4,"users"]
[2020-06-03 21:09:39] local.INFO: 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` = ? and `model_has_roles`.`model_type` = ? [4,"users"]
[2020-06-03 21:09:39] local.INFO: select count(*) as aggregate from `comments` where `comments`.`commentable_id` = ? and `comments`.`commentable_id` is not null and `comments`.`commentable_type` = ? and `comments`.`deleted_at` is null [2,"posts"]
[2020-06-03 21:09:39] local.INFO: select count(*) as aggregate from `users` inner join `likes` on `users`.`id` = `likes`.`user_id` where `likes`.`likable_id` = ? and `likable_type` = ? and `likes`.`deleted_at` is null and `users`.`deleted_at` is null [2,"posts"]
[2020-06-03 21:09:39] local.INFO: select * from `media` where `media`.`model_id` = ? and `media`.`model_id` is not null and `media`.`model_type` = ? [2,"posts"]
[2020-06-03 21:09:39] local.INFO: select `slug` from `slugs` where `slugs`.`slugable_id` = ? and `slugs`.`slugable_id` is not null and `slugs`.`slugable_type` = ? limit 1 [1,"users"]
[2020-06-03 21:09:39] local.INFO: select * from `media` where `media`.`model_id` = ? and `media`.`model_id` is not null and `media`.`model_type` = ? [1,"users"]
[2020-06-03 21:09:39] local.INFO: 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` = ? and `model_has_roles`.`model_type` = ? [1,"users"]
[2020-06-03 21:09:39] local.INFO: select `slug` from `slugs` where `slugs`.`slugable_id` = ? and `slugs`.`slugable_id` is not null and `slugs`.`slugable_type` = ? limit 1 [1,"users"]
[2020-06-03 21:09:39] local.INFO: select * from `media` where `media`.`model_id` = ? and `media`.`model_id` is not null and `media`.`model_type` = ? [1,"users"]
[2020-06-03 21:09:39] local.INFO: 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` = ? and `model_has_roles`.`model_type` = ? [1,"users"]
[2020-06-03 21:09:39] local.INFO: select count(*) as aggregate from `comments` where `comments`.`commentable_id` = ? and `comments`.`commentable_id` is not null and `comments`.`commentable_type` = ? and `comments`.`deleted_at` is null [3,"posts"]
[2020-06-03 21:09:39] local.INFO: select count(*) as aggregate from `users` inner join `likes` on `users`.`id` = `likes`.`user_id` where `likes`.`likable_id` = ? and `likable_type` = ? and `likes`.`deleted_at` is null and `users`.`deleted_at` is null [3,"posts"]
[2020-06-03 21:09:39] local.INFO: select * from `media` where `media`.`model_id` = ? and `media`.`model_id` is not null and `media`.`model_type` = ? [3,"posts"]
[2020-06-03 21:09:39] local.INFO: select * from `options` where `collection_name` = ? and `key` is null limit 1 ["company_size"]
[2020-06-03 21:09:39] local.INFO: select * from `options` where `collection_name` = ? and `key` is null limit 1 ["company_type"]
[2020-06-03 21:09:39] local.INFO: select * from `options` where `collection_name` = ? and `key` is null limit 1 ["industry"]
[2020-06-03 21:09:39] local.INFO: select `slug` from `slugs` where `slugs`.`slugable_id` = ? and `slugs`.`slugable_id` is not null and `slugs`.`slugable_type` = ? limit 1 [1,"pages"]
[2020-06-03 21:09:39] local.INFO: select * from `media` where `media`.`model_id` = ? and `media`.`model_id` is not null and `media`.`model_type` = ? [1,"pages"]
[2020-06-03 21:09:39] local.INFO: select * from `options` where `collection_name` = ? and `key` is null limit 1 ["company_size"]
[2020-06-03 21:09:39] local.INFO: select * from `options` where `collection_name` = ? and `key` is null limit 1 ["company_type"]
[2020-06-03 21:09:39] local.INFO: select * from `options` where `collection_name` = ? and `key` is null limit 1 ["industry"]
[2020-06-03 21:09:39] local.INFO: select `slug` from `slugs` where `slugs`.`slugable_id` = ? and `slugs`.`slugable_id` is not null and `slugs`.`slugable_type` = ? limit 1 [1,"pages"]
[2020-06-03 21:09:39] local.INFO: select * from `media` where `media`.`model_id` = ? and `media`.`model_id` is not null and `media`.`model_type` = ? [1,"pages"]
[2020-06-03 21:09:39] local.INFO: select count(*) as aggregate from `comments` where `comments`.`commentable_id` = ? and `comments`.`commentable_id` is not null and `comments`.`commentable_type` = ? and `comments`.`deleted_at` is null [4,"posts"]
[2020-06-03 21:09:39] local.INFO: select count(*) as aggregate from `users` inner join `likes` on `users`.`id` = `likes`.`user_id` where `likes`.`likable_id` = ? and `likable_type` = ? and `likes`.`deleted_at` is null and `users`.`deleted_at` is null [4,"posts"]
[2020-06-03 21:09:39] local.INFO: select * from `media` where `media`.`model_id` = ? and `media`.`model_id` is not null and `media`.`model_type` = ? [4,"posts"]
[2020-06-03 21:09:39] local.INFO: select `slug` from `slugs` where `slugs`.`slugable_id` = ? and `slugs`.`slugable_id` is not null and `slugs`.`slugable_type` = ? limit 1 [1,"users"]
[2020-06-03 21:09:39] local.INFO: select `slug` from `slugs` where `slugs`.`slugable_id` = ? and `slugs`.`slugable_id` is not null and `slugs`.`slugable_type` = ? limit 1 [1,"users"]
[2020-06-03 21:09:39] local.INFO: select count(*) as aggregate from `comments` where `comments`.`commentable_id` = ? and `comments`.`commentable_id` is not null and `comments`.`commentable_type` = ? and `comments`.`deleted_at` is null [5,"posts"]
[2020-06-03 21:09:39] local.INFO: select count(*) as aggregate from `users` inner join `likes` on `users`.`id` = `likes`.`user_id` where `likes`.`likable_id` = ? and `likable_type` = ? and `likes`.`deleted_at` is null and `users`.`deleted_at` is null [5,"posts"]
[2020-06-03 21:09:39] local.INFO: select * from `media` where `media`.`model_id` = ? and `media`.`model_id` is not null and `media`.`model_type` = ? [5,"posts"]
[2020-06-03 21:09:39] local.INFO: select * from `options` where `collection_name` = ? and `key` is null limit 1 ["company_size"]
[2020-06-03 21:09:39] local.INFO: select * from `options` where `collection_name` = ? and `key` is null limit 1 ["company_type"]
[2020-06-03 21:09:39] local.INFO: select * from `options` where `collection_name` = ? and `key` is null limit 1 ["industry"]
[2020-06-03 21:09:39] local.INFO: select `slug` from `slugs` where `slugs`.`slugable_id` = ? and `slugs`.`slugable_id` is not null and `slugs`.`slugable_type` = ? limit 1 [1,"pages"]
[2020-06-03 21:09:39] local.INFO: select * from `options` where `collection_name` = ? and `key` is null limit 1 ["company_size"]
[2020-06-03 21:09:39] local.INFO: select * from `options` where `collection_name` = ? and `key` is null limit 1 ["company_type"]
[2020-06-03 21:09:39] local.INFO: select * from `options` where `collection_name` = ? and `key` is null limit 1 ["industry"]
[2020-06-03 21:09:39] local.INFO: select `slug` from `slugs` where `slugs`.`slugable_id` = ? and `slugs`.`slugable_id` is not null and `slugs`.`slugable_type` = ? limit 1 [1,"pages"]
[2020-06-03 21:09:39] local.INFO: select count(*) as aggregate from `comments` where `comments`.`commentable_id` = ? and `comments`.`commentable_id` is not null and `comments`.`commentable_type` = ? and `comments`.`deleted_at` is null [6,"posts"]
[2020-06-03 21:09:39] local.INFO: select count(*) as aggregate from `users` inner join `likes` on `users`.`id` = `likes`.`user_id` where `likes`.`likable_id` = ? and `likable_type` = ? and `likes`.`deleted_at` is null and `users`.`deleted_at` is null [6,"posts"]
[2020-06-03 21:09:39] local.INFO: select * from `media` where `media`.`model_id` = ? and `media`.`model_id` is not null and `media`.`model_type` = ? [6,"posts"]
[2020-06-03 21:09:39] local.INFO: select * from `options` where `collection_name` = ? and `key` is null limit 1 ["company_size"]
[2020-06-03 21:09:39] local.INFO: select * from `options` where `collection_name` = ? and `key` is null limit 1 ["company_type"]
[2020-06-03 21:09:39] local.INFO: select * from `options` where `collection_name` = ? and `key` is null limit 1 ["industry"]
[2020-06-03 21:09:39] local.INFO: select `slug` from `slugs` where `slugs`.`slugable_id` = ? and `slugs`.`slugable_id` is not null and `slugs`.`slugable_type` = ? limit 1 [1,"pages"]
[2020-06-03 21:09:39] local.INFO: select * from `options` where `collection_name` = ? and `key` is null limit 1 ["company_size"]
[2020-06-03 21:09:39] local.INFO: select * from `options` where `collection_name` = ? and `key` is null limit 1 ["company_type"]
[2020-06-03 21:09:39] local.INFO: select * from `options` where `collection_name` = ? and `key` is null limit 1 ["industry"]
[2020-06-03 21:09:39] local.INFO: select `slug` from `slugs` where `slugs`.`slugable_id` = ? and `slugs`.`slugable_id` is not null and `slugs`.`slugable_type` = ? limit 1 [1,"pages"]
[2020-06-03 21:09:39] local.INFO: select count(*) as aggregate from `comments` where `comments`.`commentable_id` = ? and `comments`.`commentable_id` is not null and `comments`.`commentable_type` = ? and `comments`.`deleted_at` is null [7,"posts"]
[2020-06-03 21:09:39] local.INFO: select count(*) as aggregate from `users` inner join `likes` on `users`.`id` = `likes`.`user_id` where `likes`.`likable_id` = ? and `likable_type` = ? and `likes`.`deleted_at` is null and `users`.`deleted_at` is null [7,"posts"]
[2020-06-03 21:09:39] local.INFO: select * from `media` where `media`.`model_id` = ? and `media`.`model_id` is not null and `media`.`model_type` = ? [7,"posts"]
[2020-06-03 21:09:39] local.INFO: select * from `options` where `collection_name` = ? and `key` is null limit 1 ["company_size"]
[2020-06-03 21:09:39] local.INFO: select * from `options` where `collection_name` = ? and `key` is null limit 1 ["company_type"]
[2020-06-03 21:09:39] local.INFO: select * from `options` where `collection_name` = ? and `key` is null limit 1 ["industry"]
[2020-06-03 21:09:39] local.INFO: select `slug` from `slugs` where `slugs`.`slugable_id` = ? and `slugs`.`slugable_id` is not null and `slugs`.`slugable_type` = ? limit 1 [1,"pages"]
[2020-06-03 21:09:39] local.INFO: select * from `options` where `collection_name` = ? and `key` is null limit 1 ["company_size"]
[2020-06-03 21:09:39] local.INFO: select * from `options` where `collection_name` = ? and `key` is null limit 1 ["company_type"]
[2020-06-03 21:09:39] local.INFO: select * from `options` where `collection_name` = ? and `key` is null limit 1 ["industry"]
[2020-06-03 21:09:39] local.INFO: select `slug` from `slugs` where `slugs`.`slugable_id` = ? and `slugs`.`slugable_id` is not null and `slugs`.`slugable_type` = ? limit 1 [1,"pages"]
[2020-06-03 21:09:39] local.INFO: select count(*) as aggregate from `comments` where `comments`.`commentable_id` = ? and `comments`.`commentable_id` is not null and `comments`.`commentable_type` = ? and `comments`.`deleted_at` is null [8,"posts"]
[2020-06-03 21:09:39] local.INFO: select count(*) as aggregate from `users` inner join `likes` on `users`.`id` = `likes`.`user_id` where `likes`.`likable_id` = ? and `likable_type` = ? and `likes`.`deleted_at` is null and `users`.`deleted_at` is null [8,"posts"]
[2020-06-03 21:09:39] local.INFO: select * from `media` where `media`.`model_id` = ? and `media`.`model_id` is not null and `media`.`model_type` = ? [8,"posts"]
[2020-06-03 21:09:39] local.INFO: select * from `options` where `collection_name` = ? and `key` is null limit 1 ["company_size"]
[2020-06-03 21:09:39] local.INFO: select * from `options` where `collection_name` = ? and `key` is null limit 1 ["company_type"]
[2020-06-03 21:09:39] local.INFO: select * from `options` where `collection_name` = ? and `key` is null limit 1 ["industry"]
[2020-06-03 21:09:39] local.INFO: select `slug` from `slugs` where `slugs`.`slugable_id` = ? and `slugs`.`slugable_id` is not null and `slugs`.`slugable_type` = ? limit 1 [1,"pages"]
[2020-06-03 21:09:39] local.INFO: select * from `options` where `collection_name` = ? and `key` is null limit 1 ["company_size"]
[2020-06-03 21:09:39] local.INFO: select * from `options` where `collection_name` = ? and `key` is null limit 1 ["company_type"]
[2020-06-03 21:09:39] local.INFO: select * from `options` where `collection_name` = ? and `key` is null limit 1 ["industry"]
[2020-06-03 21:09:39] local.INFO: select `slug` from `slugs` where `slugs`.`slugable_id` = ? and `slugs`.`slugable_id` is not null and `slugs`.`slugable_type` = ? limit 1 [1,"pages"]
[2020-06-03 21:09:39] local.INFO: select count(*) as aggregate from `comments` where `comments`.`commentable_id` = ? and `comments`.`commentable_id` is not null and `comments`.`commentable_type` = ? and `comments`.`deleted_at` is null [9,"posts"]
[2020-06-03 21:09:39] local.INFO: select count(*) as aggregate from `users` inner join `likes` on `users`.`id` = `likes`.`user_id` where `likes`.`likable_id` = ? and `likable_type` = ? and `likes`.`deleted_at` is null and `users`.`deleted_at` is null [9,"posts"]
[2020-06-03 21:09:39] local.INFO: select * from `media` where `media`.`model_id` = ? and `media`.`model_id` is not null and `media`.`model_type` = ? [9,"posts"]
[2020-06-03 21:09:39] local.INFO: select * from `options` where `collection_name` = ? and `key` is null limit 1 ["company_size"]
[2020-06-03 21:09:39] local.INFO: select * from `options` where `collection_name` = ? and `key` is null limit 1 ["company_type"]
[2020-06-03 21:09:39] local.INFO: select * from `options` where `collection_name` = ? and `key` is null limit 1 ["industry"]
[2020-06-03 21:09:39] local.INFO: select `slug` from `slugs` where `slugs`.`slugable_id` = ? and `slugs`.`slugable_id` is not null and `slugs`.`slugable_type` = ? limit 1 [1,"pages"]
[2020-06-03 21:09:39] local.INFO: select * from `options` where `collection_name` = ? and `key` is null limit 1 ["company_size"]
[2020-06-03 21:09:39] local.INFO: select * from `options` where `collection_name` = ? and `key` is null limit 1 ["company_type"]
[2020-06-03 21:09:39] local.INFO: select * from `options` where `collection_name` = ? and `key` is null limit 1 ["industry"]
[2020-06-03 21:09:39] local.INFO: select `slug` from `slugs` where `slugs`.`slugable_id` = ? and `slugs`.`slugable_id` is not null and `slugs`.`slugable_type` = ? limit 1 [1,"pages"]
[2020-06-03 21:09:39] local.INFO: select count(*) as aggregate from `comments` where `comments`.`commentable_id` = ? and `comments`.`commentable_id` is not null and `comments`.`commentable_type` = ? and `comments`.`deleted_at` is null [10,"posts"]
[2020-06-03 21:09:39] local.INFO: select count(*) as aggregate from `users` inner join `likes` on `users`.`id` = `likes`.`user_id` where `likes`.`likable_id` = ? and `likable_type` = ? and `likes`.`deleted_at` is null and `users`.`deleted_at` is null [10,"posts"]
[2020-06-03 21:09:39] local.INFO: select * from `media` where `media`.`model_id` = ? and `media`.`model_id` is not null and `media`.`model_type` = ? [10,"posts"]
[2020-06-03 21:09:39] local.INFO: select * from `options` where `collection_name` = ? and `key` is null limit 1 ["company_size"]
[2020-06-03 21:09:39] local.INFO: select * from `options` where `collection_name` = ? and `key` is null limit 1 ["company_type"]
[2020-06-03 21:09:39] local.INFO: select * from `options` where `collection_name` = ? and `key` is null limit 1 ["industry"]
[2020-06-03 21:09:39] local.INFO: select `slug` from `slugs` where `slugs`.`slugable_id` = ? and `slugs`.`slugable_id` is not null and `slugs`.`slugable_type` = ? limit 1 [1,"pages"]
[2020-06-03 21:09:39] local.INFO: select * from `options` where `collection_name` = ? and `key` is null limit 1 ["company_size"]
[2020-06-03 21:09:39] local.INFO: select * from `options` where `collection_name` = ? and `key` is null limit 1 ["company_type"]
[2020-06-03 21:09:39] local.INFO: select * from `options` where `collection_name` = ? and `key` is null limit 1 ["industry"]
[2020-06-03 21:09:39] local.INFO: select `slug` from `slugs` where `slugs`.`slugable_id` = ? and `slugs`.`slugable_id` is not null and `slugs`.`slugable_type` = ? limit 1 [1,"pages"]
[2020-06-03 21:09:39] local.INFO: select count(*) as aggregate from `comments` where `comments`.`commentable_id` = ? and `comments`.`commentable_id` is not null and `comments`.`commentable_type` = ? and `comments`.`deleted_at` is null [11,"posts"]
[2020-06-03 21:09:39] local.INFO: select count(*) as aggregate from `users` inner join `likes` on `users`.`id` = `likes`.`user_id` where `likes`.`likable_id` = ? and `likable_type` = ? and `likes`.`deleted_at` is null and `users`.`deleted_at` is null [11,"posts"]
[2020-06-03 21:09:39] local.INFO: select * from `media` where `media`.`model_id` = ? and `media`.`model_id` is not null and `media`.`model_type` = ? [11,"posts"]
[2020-06-03 21:09:39] local.INFO: select * from `options` where `collection_name` = ? and `key` is null limit 1 ["company_size"]
[2020-06-03 21:09:39] local.INFO: select * from `options` where `collection_name` = ? and `key` is null limit 1 ["company_type"]
[2020-06-03 21:09:39] local.INFO: select * from `options` where `collection_name` = ? and `key` is null limit 1 ["industry"]
[2020-06-03 21:09:39] local.INFO: select `slug` from `slugs` where `slugs`.`slugable_id` = ? and `slugs`.`slugable_id` is not null and `slugs`.`slugable_type` = ? limit 1 [1,"pages"]
[2020-06-03 21:09:39] local.INFO: select * from `options` where `collection_name` = ? and `key` is null limit 1 ["company_size"]
[2020-06-03 21:09:40] local.INFO: select * from `options` where `collection_name` = ? and `key` is null limit 1 ["company_type"]
[2020-06-03 21:09:40] local.INFO: select * from `options` where `collection_name` = ? and `key` is null limit 1 ["industry"]
[2020-06-03 21:09:40] local.INFO: select `slug` from `slugs` where `slugs`.`slugable_id` = ? and `slugs`.`slugable_id` is not null and `slugs`.`slugable_type` = ? limit 1 [1,"pages"]
[2020-06-03 21:09:40] local.INFO: select count(*) as aggregate from `comments` where `comments`.`commentable_id` = ? and `comments`.`commentable_id` is not null and `comments`.`commentable_type` = ? and `comments`.`deleted_at` is null [12,"posts"]
[2020-06-03 21:09:40] local.INFO: select count(*) as aggregate from `users` inner join `likes` on `users`.`id` = `likes`.`user_id` where `likes`.`likable_id` = ? and `likable_type` = ? and `likes`.`deleted_at` is null and `users`.`deleted_at` is null [12,"posts"]
[2020-06-03 21:09:40] local.INFO: select * from `media` where `media`.`model_id` = ? and `media`.`model_id` is not null and `media`.`model_type` = ? [12,"posts"]
[2020-06-03 21:09:40] local.INFO: select * from `options` where `collection_name` = ? and `key` is null limit 1 ["company_size"]
[2020-06-03 21:09:40] local.INFO: select * from `options` where `collection_name` = ? and `key` is null limit 1 ["company_type"]
[2020-06-03 21:09:40] local.INFO: select * from `options` where `collection_name` = ? and `key` is null limit 1 ["industry"]
[2020-06-03 21:09:40] local.INFO: select `slug` from `slugs` where `slugs`.`slugable_id` = ? and `slugs`.`slugable_id` is not null and `slugs`.`slugable_type` = ? limit 1 [1,"pages"]
[2020-06-03 21:09:40] local.INFO: select * from `options` where `collection_name` = ? and `key` is null limit 1 ["company_size"]
[2020-06-03 21:09:40] local.INFO: select * from `options` where `collection_name` = ? and `key` is null limit 1 ["company_type"]
[2020-06-03 21:09:40] local.INFO: select * from `options` where `collection_name` = ? and `key` is null limit 1 ["industry"]
[2020-06-03 21:09:40] local.INFO: select `slug` from `slugs` where `slugs`.`slugable_id` = ? and `slugs`.`slugable_id` is not null and `slugs`.`slugable_type` = ? limit 1 [1,"pages"]
[2020-06-03 21:09:40] local.INFO: select count(*) as aggregate from `comments` where `comments`.`commentable_id` = ? and `comments`.`commentable_id` is not null and `comments`.`commentable_type` = ? and `comments`.`deleted_at` is null [13,"posts"]
[2020-06-03 21:09:40] local.INFO: select count(*) as aggregate from `users` inner join `likes` on `users`.`id` = `likes`.`user_id` where `likes`.`likable_id` = ? and `likable_type` = ? and `likes`.`deleted_at` is null and `users`.`deleted_at` is null [13,"posts"]
[2020-06-03 21:09:40] local.INFO: select * from `media` where `media`.`model_id` = ? and `media`.`model_id` is not null and `media`.`model_type` = ? [13,"posts"]
[2020-06-03 21:09:40] local.INFO: select * from `options` where `collection_name` = ? and `key` is null limit 1 ["company_size"]
[2020-06-03 21:09:40] local.INFO: select * from `options` where `collection_name` = ? and `key` is null limit 1 ["company_type"]
[2020-06-03 21:09:40] local.INFO: select * from `options` where `collection_name` = ? and `key` is null limit 1 ["industry"]
[2020-06-03 21:09:40] local.INFO: select `slug` from `slugs` where `slugs`.`slugable_id` = ? and `slugs`.`slugable_id` is not null and `slugs`.`slugable_type` = ? limit 1 [1,"pages"]
[2020-06-03 21:09:40] local.INFO: select * from `options` where `collection_name` = ? and `key` is null limit 1 ["company_size"]
[2020-06-03 21:09:40] local.INFO: select * from `options` where `collection_name` = ? and `key` is null limit 1 ["company_type"]
[2020-06-03 21:09:40] local.INFO: select * from `options` where `collection_name` = ? and `key` is null limit 1 ["industry"]
[2020-06-03 21:09:40] local.INFO: select `slug` from `slugs` where `slugs`.`slugable_id` = ? and `slugs`.`slugable_id` is not null and `slugs`.`slugable_type` = ? limit 1 [1,"pages"]
[2020-06-03 21:09:40] local.INFO: select count(*) as aggregate from `comments` where `comments`.`commentable_id` = ? and `comments`.`commentable_id` is not null and `comments`.`commentable_type` = ? and `comments`.`deleted_at` is null [14,"posts"]
[2020-06-03 21:09:40] local.INFO: select count(*) as aggregate from `users` inner join `likes` on `users`.`id` = `likes`.`user_id` where `likes`.`likable_id` = ? and `likable_type` = ? and `likes`.`deleted_at` is null and `users`.`deleted_at` is null [14,"posts"]
[2020-06-03 21:09:40] local.INFO: select * from `media` where `media`.`model_id` = ? and `media`.`model_id` is not null and `media`.`model_type` = ? [14,"posts"]
[2020-06-03 21:09:40] local.INFO: select * from `options` where `collection_name` = ? and `key` is null limit 1 ["company_size"]
[2020-06-03 21:09:40] local.INFO: select * from `options` where `collection_name` = ? and `key` is null limit 1 ["company_type"]
[2020-06-03 21:09:40] local.INFO: select * from `options` where `collection_name` = ? and `key` is null limit 1 ["industry"]
[2020-06-03 21:09:40] local.INFO: select `slug` from `slugs` where `slugs`.`slugable_id` = ? and `slugs`.`slugable_id` is not null and `slugs`.`slugable_type` = ? limit 1 [1,"pages"]
[2020-06-03 21:09:40] local.INFO: select * from `options` where `collection_name` = ? and `key` is null limit 1 ["company_size"]
[2020-06-03 21:09:40] local.INFO: select * from `options` where `collection_name` = ? and `key` is null limit 1 ["company_type"]
[2020-06-03 21:09:40] local.INFO: select * from `options` where `collection_name` = ? and `key` is null limit 1 ["industry"]
[2020-06-03 21:09:40] local.INFO: select `slug` from `slugs` where `slugs`.`slugable_id` = ? and `slugs`.`slugable_id` is not null and `slugs`.`slugable_type` = ? limit 1 [1,"pages"]
[2020-06-03 21:09:40] local.INFO: select count(*) as aggregate from `comments` where `comments`.`commentable_id` = ? and `comments`.`commentable_id` is not null and `comments`.`commentable_type` = ? and `comments`.`deleted_at` is null [15,"posts"]
[2020-06-03 21:09:40] local.INFO: select count(*) as aggregate from `users` inner join `likes` on `users`.`id` = `likes`.`user_id` where `likes`.`likable_id` = ? and `likable_type` = ? and `likes`.`deleted_at` is null and `users`.`deleted_at` is null [15,"posts"]
[2020-06-03 21:09:40] local.INFO: select * from `media` where `media`.`model_id` = ? and `media`.`model_id` is not null and `media`.`model_type` = ? [15,"posts"]
[2020-06-03 21:09:40] local.INFO: select * from `options` where `collection_name` = ? and `key` = ? limit 1 ["company_size","1"]
[2020-06-03 21:09:40] local.INFO: select * from `options` where `collection_name` = ? and `key` = ? limit 1 ["company_type","1"]
[2020-06-03 21:09:40] local.INFO: select * from `options` where `collection_name` = ? and `key` = ? limit 1 ["industry","1"]
[2020-06-03 21:09:40] local.INFO: select `slug` from `slugs` where `slugs`.`slugable_id` = ? and `slugs`.`slugable_id` is not null and `slugs`.`slugable_type` = ? limit 1 [2,"pages"]
[2020-06-03 21:09:40] local.INFO: select * from `media` where `media`.`model_id` = ? and `media`.`model_id` is not null and `media`.`model_type` = ? [2,"pages"]
[2020-06-03 21:09:40] local.INFO: select * from `options` where `collection_name` = ? and `key` = ? limit 1 ["company_size","1"]
[2020-06-03 21:09:40] local.INFO: select * from `options` where `collection_name` = ? and `key` = ? limit 1 ["company_type","1"]
[2020-06-03 21:09:40] local.INFO: select * from `options` where `collection_name` = ? and `key` = ? limit 1 ["industry","1"]
[2020-06-03 21:09:40] local.INFO: select `slug` from `slugs` where `slugs`.`slugable_id` = ? and `slugs`.`slugable_id` is not null and `slugs`.`slugable_type` = ? limit 1 [2,"pages"]
[2020-06-03 21:09:40] local.INFO: select * from `media` where `media`.`model_id` = ? and `media`.`model_id` is not null and `media`.`model_type` = ? [2,"pages"]
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment