| 1 | SHOW FULL COLUMNS FROM `users` | | 78 | 78 | 3 |
| 2 | SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'utf8mb4_unicode_ci'; | | 1 | 1 | 1 |
| 3 | SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'utf8mb3_general_ci'; | | 1 | 1 | 0 |
| 4 | SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'latin1_swedish_ci'; | | 1 | 1 | 0 |
| 5 | SHOW FULL COLUMNS FROM `groups` | | 6 | 6 | 3 |
| 6 | SHOW FULL COLUMNS FROM `images` | | 10 | 10 | 1 |
| 7 | SHOW FULL COLUMNS FROM `countries` | | 8 | 8 | 1 |
| 8 | SHOW FULL COLUMNS FROM `drivers` | | 92 | 92 | 2 |
| 9 | SHOW FULL COLUMNS FROM `cars` | | 29 | 29 | 1 |
| 10 | SHOW FULL COLUMNS FROM `categories` | | 75 | 75 | 2 |
| 11 | SHOW FULL COLUMNS FROM `organizations` | | 9 | 9 | 1 |
| 12 | SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'utf8mb4_0900_ai_ci'; | | 1 | 1 | 1 |
| 13 | SHOW FULL COLUMNS FROM `trips` | | 150 | 150 | 3 |
| 14 | SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'utf8mb4_bin'; | | 1 | 1 | 0 |
| 15 | SHOW FULL COLUMNS FROM `trip_checklists` | | 9 | 9 | 2 |
| 16 | SHOW FULL COLUMNS FROM `checklists` | | 8 | 8 | 1 |
| 17 | SHOW FULL COLUMNS FROM `tronsactions` | | 58 | 58 | 2 |
| 18 | SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'utf8mb3_unicode_ci'; | | 1 | 1 | 0 |
| 19 | SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'utf8mb4_general_ci'; | | 1 | 1 | 0 |
| 20 | SHOW FULL COLUMNS FROM `statistics` | | 10 | 10 | 1 |
| 21 | SHOW FULL COLUMNS FROM `messages` | | 21 | 21 | 1 |
| 22 | SHOW FULL COLUMNS FROM `audiences` | | 8 | 8 | 1 |
| 23 | SHOW FULL COLUMNS FROM `plants` | | 16 | 16 | 1 |
| 24 | SHOW FULL COLUMNS FROM `user_permissions` | | 5 | 5 | 1 |
| 25 | SHOW FULL COLUMNS FROM `dashboard_user_plants` | | 5 | 5 | 1 |
| 26 | SHOW FULL COLUMNS FROM `model_has_roles` | | 2 | 2 | 1 |
| 27 | SHOW FULL COLUMNS FROM `loc_codes` | | 3 | 3 | 1 |
| 28 | SHOW FULL COLUMNS FROM `constants` | | 7 | 7 | 1 |
| 29 | SELECT `Constant`.`constant_id`, `Constant`.`ctitle`, `Constant`.`ckey`, `Constant`.`cvalue`, `Constant`.`active`, `Constant`.`created`, `Constant`.`modified` FROM `constants` AS `Constant` WHERE `Constant`.`active` = 1 | | 4 | 4 | 0 |
| 30 | SHOW FULL COLUMNS FROM `settings` | | 7 | 7 | 1 |
| 31 | SELECT `Setting`.`setting_id`, `Setting`.`stitle`, `Setting`.`skey`, `Setting`.`svalue`, `Setting`.`active`, `Setting`.`created`, `Setting`.`modified` FROM `settings` AS `Setting` WHERE `Setting`.`active` = 1 | | 4 | 4 | 0 |
| 32 | SELECT `Constant`.`ckey`, `Constant`.`cvalue` FROM `constants` AS `Constant` WHERE `Constant`.`ckey` = 'is_otp' | | 1 | 1 | 0 |
| 33 | SHOW FULL COLUMNS FROM `trip_statuses` | | 10 | 10 | 1 |
| 34 | SELECT driver_id FROM trips WHERE ((trip_status IN ('accept','arrive','begin')) OR (trip_status LIKE 'completed' AND (trip_pay_status != 'Paid'))) AND is_delete = '0' | | 64 | 64 | 268 |
| 35 | SELECT `TripStatus`.`slug`, `TripStatus`.`name` FROM `trip_statuses` AS `TripStatus` WHERE `TripStatus`.`active` = 1 AND `TripStatus`.`is_admin_show` = 1 AND `TripStatus`.`is_delete` = 0 ORDER BY `TripStatus`.`sort_order` ASC | | 23 | 23 | 1 |
| 36 | SELECT `TripStatus`.`slug`, `TripStatus`.`name` FROM `trip_statuses` AS `TripStatus` WHERE `TripStatus`.`slug` IN ('partial_return', 'partial_returned', 'return', 'returned') AND `TripStatus`.`active` = 1 AND `TripStatus`.`is_admin_show` = 1 AND `TripStatus`.`is_delete` = 0 ORDER BY `TripStatus`.`sort_order` ASC | | 4 | 4 | 1 |
| 37 | SELECT `TripStatus`.`slug`, `TripStatus`.`filter` FROM `trip_statuses` AS `TripStatus` WHERE `TripStatus`.`active` = 1 AND `TripStatus`.`is_admin_show` = 1 AND `TripStatus`.`is_delete` = 0 ORDER BY `TripStatus`.`sort_order` ASC | | 23 | 23 | 0 |
| 38 | SELECT `ArosAcosGrep`.`_main`, `ArosAcosGrep`.`_show` FROM `aros_acos_greps` AS `ArosAcosGrep` WHERE `_show` = 1 AND `group_id` IS NULL | | 0 | 0 | 0 |
| 39 | SELECT `ArosAcosGrep`.`_sub`, `ArosAcosGrep`.`_show` FROM `aros_acos_greps` AS `ArosAcosGrep` WHERE `_show` = 1 AND `group_id` IS NULL | | 0 | 0 | 0 |
| 40 | SELECT `ArosAcosGrep`.`_show` FROM `aros_acos_greps` AS `ArosAcosGrep` WHERE `ArosAcosGrep`.`_show` = 1 AND `ArosAcosGrep`.`_menukey` = '9fdf6681f1c2d2c25a257333f415f9e0' AND `ArosAcosGrep`.`group_id` IS NULL LIMIT 1 | | 0 | 0 | 0 |
| 41 | SELECT `ArosAcosGrep`.`_show` FROM `aros_acos_greps` AS `ArosAcosGrep` WHERE `ArosAcosGrep`.`_show` = 1 AND `ArosAcosGrep`.`_menukey` = 'feb28da91779045ee797a3df58099435' AND `ArosAcosGrep`.`group_id` IS NULL LIMIT 1 | | 0 | 0 | 0 |
| 42 | SELECT city_id, city_name FROM cities WHERE city_active = '1' AND is_delete = '0' | | 1 | 1 | 0 |
| 43 | SELECT COUNT(*) AS `count` FROM `users` AS `User` LEFT JOIN `groups` AS `Group` ON (`User`.`group_id` = `Group`.`id`) LEFT JOIN `images` AS `Photo` ON (`User`.`image_id` = `Photo`.`image_id`) WHERE `User`.`is_test` = 0 AND `User`.`group_id` = 5 AND `User`.`city_id` = 1 AND `User`.`is_delete` IN (0, 1) AND `User`.`u_name` IS NOT NULL | | 1 | 1 | 1 |
| 44 | SELECT COUNT(*) AS `count` FROM `users` AS `User` LEFT JOIN `groups` AS `Group` ON (`User`.`group_id` = `Group`.`id`) LEFT JOIN `images` AS `Photo` ON (`User`.`image_id` = `Photo`.`image_id`) WHERE `User`.`is_test` = 0 AND `User`.`group_id` = 5 AND `User`.`city_id` = 1 AND `User`.`active` = 1 AND `User`.`is_delete` = (0) AND `User`.`u_name` IS NOT NULL | | 1 | 1 | 1 |
| 45 | SELECT COUNT(*) AS `count` FROM `users` AS `User` LEFT JOIN `groups` AS `Group` ON (`User`.`group_id` = `Group`.`id`) LEFT JOIN `images` AS `Photo` ON (`User`.`image_id` = `Photo`.`image_id`) WHERE `User`.`is_test` = 0 AND `User`.`group_id` = 5 AND `User`.`city_id` = 1 AND `User`.`active` = 0 AND `User`.`is_delete` = (0) AND `User`.`u_name` IS NOT NULL | | 1 | 1 | 0 |
| 46 | SELECT COUNT(*) AS `count` FROM `users` AS `User` LEFT JOIN `groups` AS `Group` ON (`User`.`group_id` = `Group`.`id`) LEFT JOIN `images` AS `Photo` ON (`User`.`image_id` = `Photo`.`image_id`) WHERE `User`.`is_test` = 0 AND `User`.`group_id` = 5 AND `User`.`city_id` = 1 AND `User`.`is_delete` = 1 AND `User`.`u_name` IS NOT NULL | | 1 | 1 | 0 |
| 47 | SELECT COUNT(*) AS `count` FROM `users` AS `User` LEFT JOIN `groups` AS `Group` ON (`User`.`group_id` = `Group`.`id`) LEFT JOIN `images` AS `Photo` ON (`User`.`image_id` = `Photo`.`image_id`) WHERE `User`.`city_id` = 1 AND `User`.`is_test` = 0 AND `User`.`group_id` = 2 AND `User`.`is_delete` IN (0, 1) AND `User`.`u_name` IS NOT NULL | | 1 | 1 | 1 |
| 48 | SELECT COUNT(*) AS `count` FROM `users` AS `User` LEFT JOIN `groups` AS `Group` ON (`User`.`group_id` = `Group`.`id`) LEFT JOIN `images` AS `Photo` ON (`User`.`image_id` = `Photo`.`image_id`) WHERE `User`.`city_id` = 1 AND `User`.`is_test` = 0 AND `User`.`group_id` = 2 AND `User`.`active` = 1 AND `User`.`is_delete` = (0) AND `User`.`u_name` IS NOT NULL | | 1 | 1 | 1 |
| 49 | SELECT COUNT(*) AS `count` FROM `users` AS `User` LEFT JOIN `groups` AS `Group` ON (`User`.`group_id` = `Group`.`id`) LEFT JOIN `images` AS `Photo` ON (`User`.`image_id` = `Photo`.`image_id`) WHERE `User`.`city_id` = 1 AND `User`.`is_test` = 0 AND `User`.`group_id` = 2 AND `User`.`active` = 0 AND `User`.`is_delete` = (0) AND `User`.`u_name` IS NOT NULL | | 1 | 1 | 0 |
| 50 | SELECT COUNT(*) AS `count` FROM `users` AS `User` LEFT JOIN `groups` AS `Group` ON (`User`.`group_id` = `Group`.`id`) LEFT JOIN `images` AS `Photo` ON (`User`.`image_id` = `Photo`.`image_id`) WHERE `User`.`city_id` = 1 AND `User`.`is_test` = 0 AND `User`.`group_id` = 2 AND `User`.`is_delete` = 1 AND `User`.`u_name` IS NOT NULL | | 1 | 1 | 1 |
| 51 | SELECT COUNT(*) AS `count` FROM `drivers` AS `Driver` LEFT JOIN `images` AS `Photo` ON (`Driver`.`image_id` = `Photo`.`image_id`) LEFT JOIN `images` AS `GITPhoto` ON (`Driver`.`git_image_id` = `GITPhoto`.`image_id`) LEFT JOIN `cars` AS `Car` ON (`Driver`.`car_id` = `Car`.`car_id`) LEFT JOIN `categories` AS `Category` ON (`Driver`.`category_id` = `Category`.`category_id`) WHERE `Driver`.`is_test` = 0 AND `Driver`.`city_id` = 1 AND `Driver`.`is_delete` IN (0, 1) AND `Driver`.`d_fname` IS NOT NULL AND `Driver`.`d_lname` IS NOT NULL | | 1 | 1 | 3 |
| 52 | SELECT COUNT(*) AS `count` FROM `drivers` AS `Driver` LEFT JOIN `images` AS `Photo` ON (`Driver`.`image_id` = `Photo`.`image_id`) LEFT JOIN `images` AS `GITPhoto` ON (`Driver`.`git_image_id` = `GITPhoto`.`image_id`) LEFT JOIN `cars` AS `Car` ON (`Driver`.`car_id` = `Car`.`car_id`) LEFT JOIN `categories` AS `Category` ON (`Driver`.`category_id` = `Category`.`category_id`) WHERE `Driver`.`is_test` = 0 AND `Driver`.`d_active` = 1 AND `Driver`.`city_id` = 1 AND `Driver`.`is_delete` = (0) AND `Driver`.`d_fname` IS NOT NULL AND `Driver`.`d_lname` IS NOT NULL | | 1 | 1 | 2 |
| 53 | SELECT COUNT(*) AS `count` FROM `drivers` AS `Driver` LEFT JOIN `images` AS `Photo` ON (`Driver`.`image_id` = `Photo`.`image_id`) LEFT JOIN `images` AS `GITPhoto` ON (`Driver`.`git_image_id` = `GITPhoto`.`image_id`) LEFT JOIN `cars` AS `Car` ON (`Driver`.`car_id` = `Car`.`car_id`) LEFT JOIN `categories` AS `Category` ON (`Driver`.`category_id` = `Category`.`category_id`) WHERE `Driver`.`is_test` = 0 AND `Driver`.`d_active` = 0 AND `Driver`.`city_id` = 1 AND `Driver`.`is_delete` = (0) AND `Driver`.`d_fname` IS NOT NULL AND `Driver`.`d_lname` IS NOT NULL | | 1 | 1 | 1 |
| 54 | SELECT COUNT(*) AS `count` FROM `drivers` AS `Driver` LEFT JOIN `images` AS `Photo` ON (`Driver`.`image_id` = `Photo`.`image_id`) LEFT JOIN `images` AS `GITPhoto` ON (`Driver`.`git_image_id` = `GITPhoto`.`image_id`) LEFT JOIN `cars` AS `Car` ON (`Driver`.`car_id` = `Car`.`car_id`) LEFT JOIN `categories` AS `Category` ON (`Driver`.`category_id` = `Category`.`category_id`) WHERE `Driver`.`is_test` = 0 AND `Driver`.`d_is_verified` = 1 AND `Driver`.`city_id` = 1 AND `Driver`.`is_delete` = (0) AND `Driver`.`d_fname` IS NOT NULL AND `Driver`.`d_lname` IS NOT NULL | | 1 | 1 | 2 |
| 55 | SELECT COUNT(*) AS `count` FROM `drivers` AS `Driver` LEFT JOIN `images` AS `Photo` ON (`Driver`.`image_id` = `Photo`.`image_id`) LEFT JOIN `images` AS `GITPhoto` ON (`Driver`.`git_image_id` = `GITPhoto`.`image_id`) LEFT JOIN `cars` AS `Car` ON (`Driver`.`car_id` = `Car`.`car_id`) LEFT JOIN `categories` AS `Category` ON (`Driver`.`category_id` = `Category`.`category_id`) WHERE `Driver`.`is_test` = 0 AND `Driver`.`d_is_verified` = 0 AND `Driver`.`city_id` = 1 AND `Driver`.`is_delete` = (0) AND `Driver`.`d_fname` IS NOT NULL AND `Driver`.`d_lname` IS NOT NULL | | 1 | 1 | 1 |
| 56 | SELECT COUNT(*) AS `count` FROM `drivers` AS `Driver` LEFT JOIN `images` AS `Photo` ON (`Driver`.`image_id` = `Photo`.`image_id`) LEFT JOIN `images` AS `GITPhoto` ON (`Driver`.`git_image_id` = `GITPhoto`.`image_id`) LEFT JOIN `cars` AS `Car` ON (`Driver`.`car_id` = `Car`.`car_id`) LEFT JOIN `categories` AS `Category` ON (`Driver`.`category_id` = `Category`.`category_id`) WHERE `Driver`.`is_test` = 0 AND `Driver`.`d_active` = 1 AND `Driver`.`d_is_verified` = 1 AND `Driver`.`d_is_available` = 1 AND `Driver`.`city_id` = 1 AND `Driver`.`is_delete` = (0) AND `Driver`.`d_fname` IS NOT NULL AND `Driver`.`d_lname` IS NOT NULL | | 1 | 1 | 1 |
| 57 | SELECT COUNT(*) AS `count` FROM `drivers` AS `Driver` LEFT JOIN `images` AS `Photo` ON (`Driver`.`image_id` = `Photo`.`image_id`) LEFT JOIN `images` AS `GITPhoto` ON (`Driver`.`git_image_id` = `GITPhoto`.`image_id`) LEFT JOIN `cars` AS `Car` ON (`Driver`.`car_id` = `Car`.`car_id`) LEFT JOIN `categories` AS `Category` ON (`Driver`.`category_id` = `Category`.`category_id`) WHERE `Driver`.`is_test` = 0 AND `Driver`.`d_active` = 1 AND `Driver`.`d_is_verified` = 1 AND `Driver`.`d_is_available` = 0 AND `Driver`.`city_id` = 1 AND `Driver`.`is_delete` = (0) AND `Driver`.`d_fname` IS NOT NULL AND `Driver`.`d_lname` IS NOT NULL | | 1 | 1 | 1 |
| 58 | SELECT COUNT(*) AS `count` FROM `drivers` AS `Driver` LEFT JOIN `images` AS `Photo` ON (`Driver`.`image_id` = `Photo`.`image_id`) LEFT JOIN `images` AS `GITPhoto` ON (`Driver`.`git_image_id` = `GITPhoto`.`image_id`) LEFT JOIN `cars` AS `Car` ON (`Driver`.`car_id` = `Car`.`car_id`) LEFT JOIN `categories` AS `Category` ON (`Driver`.`category_id` = `Category`.`category_id`) WHERE `Driver`.`is_test` = 0 AND `Driver`.`city_id` = 1 AND `Driver`.`is_delete` = 1 AND `Driver`.`d_fname` IS NOT NULL AND `Driver`.`d_lname` IS NOT NULL | | 1 | 1 | 1 |