Executed Queries (13)
-
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 * from `companies` where `id` = '254' limit 1x1 -
select * from `countries` where `countries`.`code` in (0) and `active` = 1x2 -
select `id`, `name` from `cities` where `id` = 285704 and `active` = 1 limit 1x1 -
select count(*) as `aggregate` from `posts` where `company_id` = 254 and `is_deleted` = 0 and `is_active` = 1 and `is_post_expire` = 0 and `archived` = 0x1 -
select * from `users` where `users`.`id` = 6167 limit 1x1 -
select * from `nationality` where `nationality`.`id` in (0)x1 -
select * from `cities` where `cities`.`id` in (285704) and `active` = 1x1 -
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 (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