| Query | Affected | Num. rows | Took (ms) | Actions |
|---|
| SELECT *, `Provider`.`id` FROM `carehub`.`providers` AS `Provider` WHERE `Provider`.`id` = 28 LIMIT 1 | 1 | 1 | 1 | |
| SELECT *, postcode_id, `ProviderPostcode`.`provider_id` FROM `carehub`.`provider_postcodes` AS `ProviderPostcode` WHERE `ProviderPostcode`.`provider_id` = (28) | 1 | 1 | 3 | maybe slow |
| SELECT * FROM `carehub`.`postcodes` AS `Postcode` WHERE `Postcode`.`id` = 3249 | 1 | 1 | 1 | |
| SELECT *, service_id, `ProviderService`.`provider_id` FROM `carehub`.`provider_services` AS `ProviderService` WHERE `ProviderService`.`provider_id` = (28) | 30 | 30 | 3 | maybe slow |
| SELECT *, sub_category_id FROM `carehub`.`services` AS `Service` WHERE `Service`.`id` = 57 | 1 | 1 | 1 | |
| SELECT *, category_id FROM `carehub`.`sub_categories` AS `SubCategory` WHERE `SubCategory`.`id` = 20 | 1 | 1 | 1 | |
| SELECT `Category`.`id`, `Category`.`title`, `Category`.`created`, `Category`.`modified` FROM `carehub`.`categories` AS `Category` WHERE `Category`.`id` = 1 | 1 | 1 | 1 | |
| SELECT *, sub_category_id FROM `carehub`.`services` AS `Service` WHERE `Service`.`id` = 52 | 1 | 1 | 1 | |
| SELECT *, category_id FROM `carehub`.`sub_categories` AS `SubCategory` WHERE `SubCategory`.`id` = 20 | 1 | 1 | 1 | |
| SELECT `Category`.`id`, `Category`.`title`, `Category`.`created`, `Category`.`modified` FROM `carehub`.`categories` AS `Category` WHERE `Category`.`id` = 1 | 1 | 1 | 1 | |
| SELECT *, sub_category_id FROM `carehub`.`services` AS `Service` WHERE `Service`.`id` = 61 | 1 | 1 | 1 | |
| SELECT *, category_id FROM `carehub`.`sub_categories` AS `SubCategory` WHERE `SubCategory`.`id` = 21 | 1 | 1 | 1 | |
| SELECT `Category`.`id`, `Category`.`title`, `Category`.`created`, `Category`.`modified` FROM `carehub`.`categories` AS `Category` WHERE `Category`.`id` = 2 | 1 | 1 | 1 | |
| SELECT *, sub_category_id FROM `carehub`.`services` AS `Service` WHERE `Service`.`id` = 34 | 1 | 1 | 1 | |
| SELECT *, category_id FROM `carehub`.`sub_categories` AS `SubCategory` WHERE `SubCategory`.`id` = 21 | 1 | 1 | 1 | |
| SELECT `Category`.`id`, `Category`.`title`, `Category`.`created`, `Category`.`modified` FROM `carehub`.`categories` AS `Category` WHERE `Category`.`id` = 2 | 1 | 1 | 1 | |
| SELECT *, sub_category_id FROM `carehub`.`services` AS `Service` WHERE `Service`.`id` = 65 | 1 | 1 | 1 | |
| SELECT *, category_id FROM `carehub`.`sub_categories` AS `SubCategory` WHERE `SubCategory`.`id` = 21 | 1 | 1 | 1 | |
| SELECT `Category`.`id`, `Category`.`title`, `Category`.`created`, `Category`.`modified` FROM `carehub`.`categories` AS `Category` WHERE `Category`.`id` = 2 | 1 | 1 | 1 | |
| SELECT *, sub_category_id FROM `carehub`.`services` AS `Service` WHERE `Service`.`id` = 62 | 1 | 1 | 1 | |
| SELECT *, category_id FROM `carehub`.`sub_categories` AS `SubCategory` WHERE `SubCategory`.`id` = 21 | 1 | 1 | 1 | |
| SELECT `Category`.`id`, `Category`.`title`, `Category`.`created`, `Category`.`modified` FROM `carehub`.`categories` AS `Category` WHERE `Category`.`id` = 2 | 1 | 1 | 1 | |
| SELECT *, sub_category_id FROM `carehub`.`services` AS `Service` WHERE `Service`.`id` = 75 | 1 | 1 | 1 | |
| SELECT *, category_id FROM `carehub`.`sub_categories` AS `SubCategory` WHERE `SubCategory`.`id` = 7 | 1 | 1 | 1 | |
| SELECT `Category`.`id`, `Category`.`title`, `Category`.`created`, `Category`.`modified` FROM `carehub`.`categories` AS `Category` WHERE `Category`.`id` = 2 | 1 | 1 | 1 | |
| SELECT *, sub_category_id FROM `carehub`.`services` AS `Service` WHERE `Service`.`id` = 77 | 1 | 1 | 1 | |
| SELECT *, category_id FROM `carehub`.`sub_categories` AS `SubCategory` WHERE `SubCategory`.`id` = 7 | 1 | 1 | 1 | |
| SELECT `Category`.`id`, `Category`.`title`, `Category`.`created`, `Category`.`modified` FROM `carehub`.`categories` AS `Category` WHERE `Category`.`id` = 2 | 1 | 1 | 1 | |
| SELECT *, sub_category_id FROM `carehub`.`services` AS `Service` WHERE `Service`.`id` = 76 | 1 | 1 | 1 | |
| SELECT *, category_id FROM `carehub`.`sub_categories` AS `SubCategory` WHERE `SubCategory`.`id` = 7 | 1 | 1 | 1 | |
| SELECT `Category`.`id`, `Category`.`title`, `Category`.`created`, `Category`.`modified` FROM `carehub`.`categories` AS `Category` WHERE `Category`.`id` = 2 | 1 | 1 | 1 | |
| SELECT *, sub_category_id FROM `carehub`.`services` AS `Service` WHERE `Service`.`id` = 63 | 1 | 1 | 1 | |
| SELECT *, category_id FROM `carehub`.`sub_categories` AS `SubCategory` WHERE `SubCategory`.`id` = 21 | 1 | 1 | 1 | |
| SELECT `Category`.`id`, `Category`.`title`, `Category`.`created`, `Category`.`modified` FROM `carehub`.`categories` AS `Category` WHERE `Category`.`id` = 2 | 1 | 1 | 1 | |
| SELECT *, sub_category_id FROM `carehub`.`services` AS `Service` WHERE `Service`.`id` = 64 | 1 | 1 | 1 | |
| SELECT *, category_id FROM `carehub`.`sub_categories` AS `SubCategory` WHERE `SubCategory`.`id` = 21 | 1 | 1 | 1 | |
| SELECT `Category`.`id`, `Category`.`title`, `Category`.`created`, `Category`.`modified` FROM `carehub`.`categories` AS `Category` WHERE `Category`.`id` = 2 | 1 | 1 | 3 | maybe slow |
| SELECT *, sub_category_id FROM `carehub`.`services` AS `Service` WHERE `Service`.`id` = 82 | 1 | 1 | 1 | |
| SELECT *, category_id FROM `carehub`.`sub_categories` AS `SubCategory` WHERE `SubCategory`.`id` = 41 | 1 | 1 | 1 | |
| SELECT `Category`.`id`, `Category`.`title`, `Category`.`created`, `Category`.`modified` FROM `carehub`.`categories` AS `Category` WHERE `Category`.`id` = 8 | 1 | 1 | 1 | |
| SELECT *, sub_category_id FROM `carehub`.`services` AS `Service` WHERE `Service`.`id` = 81 | 1 | 1 | 1 | |
| SELECT *, category_id FROM `carehub`.`sub_categories` AS `SubCategory` WHERE `SubCategory`.`id` = 41 | 1 | 1 | 1 | |
| SELECT `Category`.`id`, `Category`.`title`, `Category`.`created`, `Category`.`modified` FROM `carehub`.`categories` AS `Category` WHERE `Category`.`id` = 8 | 1 | 1 | 1 | |
| SELECT *, sub_category_id FROM `carehub`.`services` AS `Service` WHERE `Service`.`id` = 83 | 1 | 1 | 1 | |
| SELECT *, category_id FROM `carehub`.`sub_categories` AS `SubCategory` WHERE `SubCategory`.`id` = 41 | 1 | 1 | 1 | |
| SELECT `Category`.`id`, `Category`.`title`, `Category`.`created`, `Category`.`modified` FROM `carehub`.`categories` AS `Category` WHERE `Category`.`id` = 8 | 1 | 1 | 1 | |
| SELECT *, sub_category_id FROM `carehub`.`services` AS `Service` WHERE `Service`.`id` = 4 | 1 | 1 | 1 | |
| SELECT *, category_id FROM `carehub`.`sub_categories` AS `SubCategory` WHERE `SubCategory`.`id` = 2 | 1 | 1 | 1 | |
| SELECT `Category`.`id`, `Category`.`title`, `Category`.`created`, `Category`.`modified` FROM `carehub`.`categories` AS `Category` WHERE `Category`.`id` = 1 | 1 | 1 | 1 | |
| SELECT *, sub_category_id FROM `carehub`.`services` AS `Service` WHERE `Service`.`id` = 3 | 1 | 1 | 1 | |
| SELECT *, category_id FROM `carehub`.`sub_categories` AS `SubCategory` WHERE `SubCategory`.`id` = 2 | 1 | 1 | 1 | |
| SELECT `Category`.`id`, `Category`.`title`, `Category`.`created`, `Category`.`modified` FROM `carehub`.`categories` AS `Category` WHERE `Category`.`id` = 1 | 1 | 1 | 1 | |
| SELECT *, sub_category_id FROM `carehub`.`services` AS `Service` WHERE `Service`.`id` = 33 | 1 | 1 | 1 | |
| SELECT *, category_id FROM `carehub`.`sub_categories` AS `SubCategory` WHERE `SubCategory`.`id` = 2 | 1 | 1 | 1 | |
| SELECT `Category`.`id`, `Category`.`title`, `Category`.`created`, `Category`.`modified` FROM `carehub`.`categories` AS `Category` WHERE `Category`.`id` = 1 | 1 | 1 | 1 | |
| SELECT *, sub_category_id FROM `carehub`.`services` AS `Service` WHERE `Service`.`id` = 51 | 1 | 1 | 1 | |
| SELECT *, category_id FROM `carehub`.`sub_categories` AS `SubCategory` WHERE `SubCategory`.`id` = 20 | 1 | 1 | 1 | |
| SELECT `Category`.`id`, `Category`.`title`, `Category`.`created`, `Category`.`modified` FROM `carehub`.`categories` AS `Category` WHERE `Category`.`id` = 1 | 1 | 1 | 1 | |
| SELECT *, sub_category_id FROM `carehub`.`services` AS `Service` WHERE `Service`.`id` = 50 | 1 | 1 | 1 | |
| SELECT *, category_id FROM `carehub`.`sub_categories` AS `SubCategory` WHERE `SubCategory`.`id` = 20 | 1 | 1 | 1 | |
| SELECT `Category`.`id`, `Category`.`title`, `Category`.`created`, `Category`.`modified` FROM `carehub`.`categories` AS `Category` WHERE `Category`.`id` = 1 | 1 | 1 | 1 | |
| SELECT *, sub_category_id FROM `carehub`.`services` AS `Service` WHERE `Service`.`id` = 55 | 1 | 1 | 1 | |
| SELECT *, category_id FROM `carehub`.`sub_categories` AS `SubCategory` WHERE `SubCategory`.`id` = 20 | 1 | 1 | 1 | |
| SELECT `Category`.`id`, `Category`.`title`, `Category`.`created`, `Category`.`modified` FROM `carehub`.`categories` AS `Category` WHERE `Category`.`id` = 1 | 1 | 1 | 1 | |
| SELECT *, sub_category_id FROM `carehub`.`services` AS `Service` WHERE `Service`.`id` = 56 | 1 | 1 | 1 | |
| SELECT *, category_id FROM `carehub`.`sub_categories` AS `SubCategory` WHERE `SubCategory`.`id` = 20 | 1 | 1 | 1 | |
| SELECT `Category`.`id`, `Category`.`title`, `Category`.`created`, `Category`.`modified` FROM `carehub`.`categories` AS `Category` WHERE `Category`.`id` = 1 | 1 | 1 | 1 | |
| SELECT *, sub_category_id FROM `carehub`.`services` AS `Service` WHERE `Service`.`id` = 79 | 1 | 1 | 1 | |
| SELECT *, category_id FROM `carehub`.`sub_categories` AS `SubCategory` WHERE `SubCategory`.`id` = 40 | 1 | 1 | 1 | |
| SELECT `Category`.`id`, `Category`.`title`, `Category`.`created`, `Category`.`modified` FROM `carehub`.`categories` AS `Category` WHERE `Category`.`id` = 3 | 1 | 1 | 1 | |
| SELECT *, sub_category_id FROM `carehub`.`services` AS `Service` WHERE `Service`.`id` = 78 | 1 | 1 | 1 | |
| SELECT *, category_id FROM `carehub`.`sub_categories` AS `SubCategory` WHERE `SubCategory`.`id` = 40 | 1 | 1 | 1 | |
| SELECT `Category`.`id`, `Category`.`title`, `Category`.`created`, `Category`.`modified` FROM `carehub`.`categories` AS `Category` WHERE `Category`.`id` = 3 | 1 | 1 | 1 | |
| SELECT *, sub_category_id FROM `carehub`.`services` AS `Service` WHERE `Service`.`id` = 80 | 1 | 1 | 2 | maybe slow |
| SELECT *, category_id FROM `carehub`.`sub_categories` AS `SubCategory` WHERE `SubCategory`.`id` = 40 | 1 | 1 | 1 | |
| SELECT `Category`.`id`, `Category`.`title`, `Category`.`created`, `Category`.`modified` FROM `carehub`.`categories` AS `Category` WHERE `Category`.`id` = 3 | 1 | 1 | 1 | |
| SELECT *, sub_category_id FROM `carehub`.`services` AS `Service` WHERE `Service`.`id` = 66 | 1 | 1 | 1 | |
| SELECT *, category_id FROM `carehub`.`sub_categories` AS `SubCategory` WHERE `SubCategory`.`id` = 28 | 1 | 1 | 1 | |
| SELECT `Category`.`id`, `Category`.`title`, `Category`.`created`, `Category`.`modified` FROM `carehub`.`categories` AS `Category` WHERE `Category`.`id` = 3 | 1 | 1 | 1 | |
| SELECT *, sub_category_id FROM `carehub`.`services` AS `Service` WHERE `Service`.`id` = 40 | 1 | 1 | 1 | |
| SELECT *, category_id FROM `carehub`.`sub_categories` AS `SubCategory` WHERE `SubCategory`.`id` = 28 | 1 | 1 | 1 | |
| SELECT `Category`.`id`, `Category`.`title`, `Category`.`created`, `Category`.`modified` FROM `carehub`.`categories` AS `Category` WHERE `Category`.`id` = 3 | 1 | 1 | 1 | |
| SELECT *, sub_category_id FROM `carehub`.`services` AS `Service` WHERE `Service`.`id` = 70 | 1 | 1 | 1 | |
| SELECT *, category_id FROM `carehub`.`sub_categories` AS `SubCategory` WHERE `SubCategory`.`id` = 28 | 1 | 1 | 1 | |
| SELECT `Category`.`id`, `Category`.`title`, `Category`.`created`, `Category`.`modified` FROM `carehub`.`categories` AS `Category` WHERE `Category`.`id` = 3 | 1 | 1 | 1 | |
| SELECT *, sub_category_id FROM `carehub`.`services` AS `Service` WHERE `Service`.`id` = 68 | 1 | 1 | 1 | |
| SELECT *, category_id FROM `carehub`.`sub_categories` AS `SubCategory` WHERE `SubCategory`.`id` = 28 | 1 | 1 | 1 | |
| SELECT `Category`.`id`, `Category`.`title`, `Category`.`created`, `Category`.`modified` FROM `carehub`.`categories` AS `Category` WHERE `Category`.`id` = 3 | 1 | 1 | 1 | |
| SELECT *, sub_category_id FROM `carehub`.`services` AS `Service` WHERE `Service`.`id` = 67 | 1 | 1 | 1 | |
| SELECT *, category_id FROM `carehub`.`sub_categories` AS `SubCategory` WHERE `SubCategory`.`id` = 28 | 1 | 1 | 1 | |
| SELECT `Category`.`id`, `Category`.`title`, `Category`.`created`, `Category`.`modified` FROM `carehub`.`categories` AS `Category` WHERE `Category`.`id` = 3 | 1 | 1 | 1 | |
| SELECT *, sub_category_id FROM `carehub`.`services` AS `Service` WHERE `Service`.`id` = 69 | 1 | 1 | 1 | |
| SELECT *, category_id FROM `carehub`.`sub_categories` AS `SubCategory` WHERE `SubCategory`.`id` = 28 | 1 | 1 | 1 | |
| SELECT `Category`.`id`, `Category`.`title`, `Category`.`created`, `Category`.`modified` FROM `carehub`.`categories` AS `Category` WHERE `Category`.`id` = 3 | 1 | 1 | 1 | |
49 duplicate queries run.
