Executed Queries (15)

• 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 asc x1
• select * from `companies` where `id` = '616' limit 1 x1
• select * from `countries` where `countries`.`code` in (0) and `active` = 1 x2
• select `id`, `name` from `cities` where `id` = 1172451 and `active` = 1 limit 1 x1
• select count(*) as `aggregate` from `posts` where `company_id` = 616 and `is_deleted` = 0 and `is_active` = 1 and `is_post_expire` = 0 and `archived` = 0 x1
• select `id`, `skill` from `employee_skills` order by `skill` asc x1
• select `id`, `name` from `post_types` where `active` = 1 order by JSON_UNQUOTE(JSON_EXTRACT(IF(JSON_VALID(name), name, JSON_OBJECT('en', name)), '$.en')) ASC x1
• select `id`, `name` from `cities` where `active` = 1 order by JSON_UNQUOTE(JSON_EXTRACT(IF(JSON_VALID(name), name, JSON_OBJECT('en', name)), '$.en')) ASC limit 50 x1
• select * from `users` where `users`.`id` = 12571 limit 1 x1
• select * from `cities` where `cities`.`id` in (1172451) and `active` = 1 x1
• 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 (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