Executed Queries (73)
-
select column_name as `name`, data_type as `type_name`, column_type as `type`, collation_name as `collation`, is_nullable as `nullable`, column_default as `default`, column_comment as `comment`, generation_expression as `expression`, extra as `extra` from information_schema.columns where table_schema = schema() and table_name = 'countries' order by ordinal_position ascx1 -
select count(*) as `aggregate` from `companies` where exists (select * from `posts` where `companies`.`id` = `posts`.`company_id`)x1 -
select `companies`.*, (select count(*) from `posts` where `companies`.`id` = `posts`.`company_id` and `is_active` = 1 and `is_deleted` = 0 and `archived` = 0 and `is_post_expire` = 0) as `posts_count` from `companies` where exists (select * from `posts` where `companies`.`id` = `posts`.`company_id`) order by `posts_count` desc limit 12 offset 0x1 -
select * from `employee_logo` where `employee_logo`.`user_id` in (5787, 5906, 6167, 6360, 6363, 12142, 12533, 12568, 12571, 12574, 12578, 12583)x1 -
select `country_stats` from `home_page_settings` limit 1x1 -
select * from `users` where `users`.`id` = 12574 limit 1x1 -
select * from `cities` where `cities`.`id` in (1172451) and `active` = 1x2 -
select * from `countries` where `countries`.`code` in (0) and `active` = 1x12 -
select * from `permissions`x1 -
select `roles`.*, `role_has_permissions`.`permission_id` as `pivot_permission_id`, `role_has_permissions`.`role_id` as `pivot_role_id` from `roles` inner join `role_has_permissions` on `roles`.`id` = `role_has_permissions`.`role_id` where `role_has_permissions`.`permission_id` in (1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12)x1 -
select `permissions`.*, `model_has_permissions`.`model_id` as `pivot_model_id`, `model_has_permissions`.`permission_id` as `pivot_permission_id`, `model_has_permissions`.`model_type` as `pivot_model_type` from `permissions` inner join `model_has_permissions` on `permissions`.`id` = `model_has_permissions`.`permission_id` where `model_has_permissions`.`model_id` in (12574) and `model_has_permissions`.`model_type` = 'App\Models\User'x1 -
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` in (12574) and `model_has_roles`.`model_type` = 'App\Models\User'x1 -
select * from `users` where `users`.`id` = 12568 limit 1x1 -
select * from `cities` where `cities`.`id` in (387958) and `active` = 1x1 -
select `permissions`.*, `model_has_permissions`.`model_id` as `pivot_model_id`, `model_has_permissions`.`permission_id` as `pivot_permission_id`, `model_has_permissions`.`model_type` as `pivot_model_type` from `permissions` inner join `model_has_permissions` on `permissions`.`id` = `model_has_permissions`.`permission_id` where `model_has_permissions`.`model_id` in (12568) and `model_has_permissions`.`model_type` = 'App\Models\User'x1 -
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` in (12568) and `model_has_roles`.`model_type` = 'App\Models\User'x1 -
select * from `users` where `users`.`id` = 12583 limit 1x1 -
select * from `cities` where `cities`.`id` in (1185056) and `active` = 1x1 -
select `permissions`.*, `model_has_permissions`.`model_id` as `pivot_model_id`, `model_has_permissions`.`permission_id` as `pivot_permission_id`, `model_has_permissions`.`model_type` as `pivot_model_type` from `permissions` inner join `model_has_permissions` on `permissions`.`id` = `model_has_permissions`.`permission_id` where `model_has_permissions`.`model_id` in (12583) and `model_has_permissions`.`model_type` = 'App\Models\User'x1 -
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` in (12583) and `model_has_roles`.`model_type` = 'App\Models\User'x1 -
select * from `users` where `users`.`id` = 12142 limit 1x1 -
select * from `nationality` where `nationality`.`id` in (0)x6 -
select * from `cities` where `cities`.`id` in (285787) and `active` = 1x4 -
select `permissions`.*, `model_has_permissions`.`model_id` as `pivot_model_id`, `model_has_permissions`.`permission_id` as `pivot_permission_id`, `model_has_permissions`.`model_type` as `pivot_model_type` from `permissions` inner join `model_has_permissions` on `permissions`.`id` = `model_has_permissions`.`permission_id` where `model_has_permissions`.`model_id` in (12142) and `model_has_permissions`.`model_type` = 'App\Models\User'x1 -
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` in (12142) and `model_has_roles`.`model_type` = 'App\Models\User'x1 -
select * from `users` where `users`.`id` = 12533 limit 1x1 -
select `permissions`.*, `model_has_permissions`.`model_id` as `pivot_model_id`, `model_has_permissions`.`permission_id` as `pivot_permission_id`, `model_has_permissions`.`model_type` as `pivot_model_type` from `permissions` inner join `model_has_permissions` on `permissions`.`id` = `model_has_permissions`.`permission_id` where `model_has_permissions`.`model_id` in (12533) and `model_has_permissions`.`model_type` = 'App\Models\User'x1 -
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` in (12533) and `model_has_roles`.`model_type` = 'App\Models\User'x1 -
select * from `users` where `users`.`id` = 12578 limit 1x1 -
select * from `cities` where `cities`.`id` in (1166000) and `active` = 1x1 -
select `permissions`.*, `model_has_permissions`.`model_id` as `pivot_model_id`, `model_has_permissions`.`permission_id` as `pivot_permission_id`, `model_has_permissions`.`model_type` as `pivot_model_type` from `permissions` inner join `model_has_permissions` on `permissions`.`id` = `model_has_permissions`.`permission_id` where `model_has_permissions`.`model_id` in (12578) and `model_has_permissions`.`model_type` = 'App\Models\User'x1 -
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` in (12578) and `model_has_roles`.`model_type` = 'App\Models\User'x1 -
select * from `users` where `users`.`id` = 12571 limit 1x1 -
select `permissions`.*, `model_has_permissions`.`model_id` as `pivot_model_id`, `model_has_permissions`.`permission_id` as `pivot_permission_id`, `model_has_permissions`.`model_type` as `pivot_model_type` from `permissions` inner join `model_has_permissions` on `permissions`.`id` = `model_has_permissions`.`permission_id` where `model_has_permissions`.`model_id` in (12571) and `model_has_permissions`.`model_type` = 'App\Models\User'x1 -
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` in (12571) and `model_has_roles`.`model_type` = 'App\Models\User'x1 -
select * from `users` where `users`.`id` = 5906 limit 1x1 -
select * from `cities` where `cities`.`id` in (285704) and `active` = 1x3 -
select `permissions`.*, `model_has_permissions`.`model_id` as `pivot_model_id`, `model_has_permissions`.`permission_id` as `pivot_permission_id`, `model_has_permissions`.`model_type` as `pivot_model_type` from `permissions` inner join `model_has_permissions` on `permissions`.`id` = `model_has_permissions`.`permission_id` where `model_has_permissions`.`model_id` in (5906) and `model_has_permissions`.`model_type` = 'App\Models\User'x1 -
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` in (5906) and `model_has_roles`.`model_type` = 'App\Models\User'x1 -
select * from `users` where `users`.`id` = 6363 limit 1x1 -
select `permissions`.*, `model_has_permissions`.`model_id` as `pivot_model_id`, `model_has_permissions`.`permission_id` as `pivot_permission_id`, `model_has_permissions`.`model_type` as `pivot_model_type` from `permissions` inner join `model_has_permissions` on `permissions`.`id` = `model_has_permissions`.`permission_id` where `model_has_permissions`.`model_id` in (6363) and `model_has_permissions`.`model_type` = 'App\Models\User'x1 -
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` in (6363) and `model_has_roles`.`model_type` = 'App\Models\User'x1 -
select * from `users` where `users`.`id` = 6360 limit 1x1 -
select `permissions`.*, `model_has_permissions`.`model_id` as `pivot_model_id`, `model_has_permissions`.`permission_id` as `pivot_permission_id`, `model_has_permissions`.`model_type` as `pivot_model_type` from `permissions` inner join `model_has_permissions` on `permissions`.`id` = `model_has_permissions`.`permission_id` where `model_has_permissions`.`model_id` in (6360) and `model_has_permissions`.`model_type` = 'App\Models\User'x1 -
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` in (6360) and `model_has_roles`.`model_type` = 'App\Models\User'x1 -
select * from `users` where `users`.`id` = 6167 limit 1x1 -
select `permissions`.*, `model_has_permissions`.`model_id` as `pivot_model_id`, `model_has_permissions`.`permission_id` as `pivot_permission_id`, `model_has_permissions`.`model_type` as `pivot_model_type` from `permissions` inner join `model_has_permissions` on `permissions`.`id` = `model_has_permissions`.`permission_id` where `model_has_permissions`.`model_id` in (6167) and `model_has_permissions`.`model_type` = 'App\Models\User'x1 -
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` in (6167) and `model_has_roles`.`model_type` = 'App\Models\User'x1 -
select * from `users` where `users`.`id` = 5787 limit 1x1 -
select `permissions`.*, `model_has_permissions`.`model_id` as `pivot_model_id`, `model_has_permissions`.`permission_id` as `pivot_permission_id`, `model_has_permissions`.`model_type` as `pivot_model_type` from `permissions` inner join `model_has_permissions` on `permissions`.`id` = `model_has_permissions`.`permission_id` where `model_has_permissions`.`model_id` in (5787) and `model_has_permissions`.`model_type` = 'App\Models\User'x1 -
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` in (5787) and `model_has_roles`.`model_type` = 'App\Models\User'x1