| Query | Affected | Num. rows | Took (ms) | Actions |
|---|
| SELECT *, `Provider`.`id` FROM `carehub`.`providers` AS `Provider` WHERE `Provider`.`id` = 348 LIMIT 1 | 1 | 1 | 1 | |
| SELECT *, postcode_id, `ProviderPostcode`.`provider_id` FROM `carehub`.`provider_postcodes` AS `ProviderPostcode` WHERE `ProviderPostcode`.`provider_id` = (348) | 18 | 18 | 3 | maybe slow |
| SELECT * FROM `carehub`.`postcodes` AS `Postcode` WHERE `Postcode`.`id` = 17 | 1 | 1 | 1 | |
| SELECT * FROM `carehub`.`postcodes` AS `Postcode` WHERE `Postcode`.`id` = 2 | 1 | 1 | 1 | |
| SELECT * FROM `carehub`.`postcodes` AS `Postcode` WHERE `Postcode`.`id` = 7 | 1 | 1 | 1 | |
| SELECT * FROM `carehub`.`postcodes` AS `Postcode` WHERE `Postcode`.`id` = 22 | 1 | 1 | 1 | |
| SELECT * FROM `carehub`.`postcodes` AS `Postcode` WHERE `Postcode`.`id` = 24 | 1 | 1 | 1 | |
| SELECT * FROM `carehub`.`postcodes` AS `Postcode` WHERE `Postcode`.`id` = 9 | 1 | 1 | 1 | |
| SELECT * FROM `carehub`.`postcodes` AS `Postcode` WHERE `Postcode`.`id` = 25 | 1 | 1 | 1 | |
| SELECT * FROM `carehub`.`postcodes` AS `Postcode` WHERE `Postcode`.`id` = 33 | 1 | 1 | 1 | |
| SELECT * FROM `carehub`.`postcodes` AS `Postcode` WHERE `Postcode`.`id` = 28 | 1 | 1 | 1 | |
| SELECT * FROM `carehub`.`postcodes` AS `Postcode` WHERE `Postcode`.`id` = 5 | 1 | 1 | 1 | |
| SELECT * FROM `carehub`.`postcodes` AS `Postcode` WHERE `Postcode`.`id` = 30 | 1 | 1 | 1 | |
| SELECT * FROM `carehub`.`postcodes` AS `Postcode` WHERE `Postcode`.`id` = 31 | 1 | 1 | 1 | |
| SELECT * FROM `carehub`.`postcodes` AS `Postcode` WHERE `Postcode`.`id` = 38 | 1 | 1 | 1 | |
| SELECT * FROM `carehub`.`postcodes` AS `Postcode` WHERE `Postcode`.`id` = 34 | 1 | 1 | 1 | |
| SELECT * FROM `carehub`.`postcodes` AS `Postcode` WHERE `Postcode`.`id` = 32 | 1 | 1 | 1 | |
| SELECT * FROM `carehub`.`postcodes` AS `Postcode` WHERE `Postcode`.`id` = 2953 | 1 | 1 | 1 | |
| SELECT * FROM `carehub`.`postcodes` AS `Postcode` WHERE `Postcode`.`id` = 2954 | 1 | 1 | 1 | |
| SELECT * FROM `carehub`.`postcodes` AS `Postcode` WHERE `Postcode`.`id` = 14 | 1 | 1 | 1 | |
| SELECT *, service_id, `ProviderService`.`provider_id` FROM `carehub`.`provider_services` AS `ProviderService` WHERE `ProviderService`.`provider_id` = (348) | 34 | 34 | 3 | maybe slow |
| SELECT *, sub_category_id FROM `carehub`.`services` AS `Service` WHERE `Service`.`id` = 141 | 1 | 1 | 1 | |
| SELECT *, category_id FROM `carehub`.`sub_categories` AS `SubCategory` WHERE `SubCategory`.`id` = 42 | 1 | 1 | 1 | |
| SELECT `Category`.`id`, `Category`.`title`, `Category`.`created`, `Category`.`modified` FROM `carehub`.`categories` AS `Category` WHERE `Category`.`id` = 4 | 1 | 1 | 1 | |
| SELECT *, sub_category_id FROM `carehub`.`services` AS `Service` WHERE `Service`.`id` = 142 | 1 | 1 | 1 | |
| SELECT *, category_id FROM `carehub`.`sub_categories` AS `SubCategory` WHERE `SubCategory`.`id` = 42 | 1 | 1 | 1 | |
| SELECT `Category`.`id`, `Category`.`title`, `Category`.`created`, `Category`.`modified` FROM `carehub`.`categories` AS `Category` WHERE `Category`.`id` = 4 | 1 | 1 | 1 | |
| SELECT *, sub_category_id FROM `carehub`.`services` AS `Service` WHERE `Service`.`id` = 91 | 1 | 1 | 1 | |
| SELECT *, category_id FROM `carehub`.`sub_categories` AS `SubCategory` WHERE `SubCategory`.`id` = 32 | 1 | 1 | 1 | |
| SELECT `Category`.`id`, `Category`.`title`, `Category`.`created`, `Category`.`modified` FROM `carehub`.`categories` AS `Category` WHERE `Category`.`id` = 4 | 1 | 1 | 1 | |
| SELECT *, sub_category_id FROM `carehub`.`services` AS `Service` WHERE `Service`.`id` = 202 | 1 | 1 | 1 | |
| SELECT *, category_id FROM `carehub`.`sub_categories` AS `SubCategory` WHERE `SubCategory`.`id` = 53 | 1 | 1 | 1 | |
| SELECT `Category`.`id`, `Category`.`title`, `Category`.`created`, `Category`.`modified` FROM `carehub`.`categories` AS `Category` WHERE `Category`.`id` = 4 | 1 | 1 | 1 | |
| SELECT *, sub_category_id FROM `carehub`.`services` AS `Service` WHERE `Service`.`id` = 180 | 1 | 1 | 1 | |
| SELECT *, category_id FROM `carehub`.`sub_categories` AS `SubCategory` WHERE `SubCategory`.`id` = 50 | 1 | 1 | 1 | |
| SELECT `Category`.`id`, `Category`.`title`, `Category`.`created`, `Category`.`modified` FROM `carehub`.`categories` AS `Category` WHERE `Category`.`id` = 4 | 1 | 1 | 1 | |
| SELECT *, sub_category_id FROM `carehub`.`services` AS `Service` WHERE `Service`.`id` = 201 | 1 | 1 | 1 | |
| SELECT *, category_id FROM `carehub`.`sub_categories` AS `SubCategory` WHERE `SubCategory`.`id` = 36 | 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` = 143 | 1 | 1 | 1 | |
| SELECT *, category_id FROM `carehub`.`sub_categories` AS `SubCategory` WHERE `SubCategory`.`id` = 43 | 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` = 144 | 1 | 1 | 1 | |
| SELECT *, category_id FROM `carehub`.`sub_categories` AS `SubCategory` WHERE `SubCategory`.`id` = 43 | 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` = 181 | 1 | 1 | 1 | |
| SELECT *, category_id FROM `carehub`.`sub_categories` AS `SubCategory` WHERE `SubCategory`.`id` = 39 | 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` = 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` = 18 | 1 | 1 | 1 | |
| SELECT *, category_id FROM `carehub`.`sub_categories` AS `SubCategory` WHERE `SubCategory`.`id` = 15 | 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` = 145 | 1 | 1 | 1 | |
| SELECT *, category_id FROM `carehub`.`sub_categories` AS `SubCategory` WHERE `SubCategory`.`id` = 44 | 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` = 146 | 1 | 1 | 1 | |
| SELECT *, category_id FROM `carehub`.`sub_categories` AS `SubCategory` WHERE `SubCategory`.`id` = 44 | 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` = 182 | 1 | 1 | 1 | |
| SELECT *, category_id FROM `carehub`.`sub_categories` AS `SubCategory` WHERE `SubCategory`.`id` = 38 | 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` = 48 | 1 | 1 | 1 | |
| SELECT *, category_id FROM `carehub`.`sub_categories` AS `SubCategory` WHERE `SubCategory`.`id` = 19 | 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` = 49 | 1 | 1 | 1 | |
| SELECT *, category_id FROM `carehub`.`sub_categories` AS `SubCategory` WHERE `SubCategory`.`id` = 19 | 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` = 261 | 1 | 1 | 1 | |
| SELECT *, category_id FROM `carehub`.`sub_categories` AS `SubCategory` WHERE `SubCategory`.`id` = 57 | 1 | 1 | 1 | |
| SELECT `Category`.`id`, `Category`.`title`, `Category`.`created`, `Category`.`modified` FROM `carehub`.`categories` AS `Category` WHERE `Category`.`id` = 11 | 1 | 1 | 1 | |
| SELECT *, sub_category_id FROM `carehub`.`services` AS `Service` WHERE `Service`.`id` = 218 | 1 | 1 | 1 | |
| SELECT *, category_id FROM `carehub`.`sub_categories` AS `SubCategory` WHERE `SubCategory`.`id` = 57 | 1 | 1 | 1 | |
| SELECT `Category`.`id`, `Category`.`title`, `Category`.`created`, `Category`.`modified` FROM `carehub`.`categories` AS `Category` WHERE `Category`.`id` = 11 | 1 | 1 | 1 | |
| SELECT *, sub_category_id FROM `carehub`.`services` AS `Service` WHERE `Service`.`id` = 220 | 1 | 1 | 1 | |
| SELECT *, category_id FROM `carehub`.`sub_categories` AS `SubCategory` WHERE `SubCategory`.`id` = 57 | 1 | 1 | 1 | |
| SELECT `Category`.`id`, `Category`.`title`, `Category`.`created`, `Category`.`modified` FROM `carehub`.`categories` AS `Category` WHERE `Category`.`id` = 11 | 1 | 1 | 1 | |
| SELECT *, sub_category_id FROM `carehub`.`services` AS `Service` WHERE `Service`.`id` = 260 | 1 | 1 | 1 | |
| SELECT *, category_id FROM `carehub`.`sub_categories` AS `SubCategory` WHERE `SubCategory`.`id` = 56 | 1 | 1 | 1 | |
| SELECT `Category`.`id`, `Category`.`title`, `Category`.`created`, `Category`.`modified` FROM `carehub`.`categories` AS `Category` WHERE `Category`.`id` = 11 | 1 | 1 | 1 | |
| SELECT *, sub_category_id FROM `carehub`.`services` AS `Service` WHERE `Service`.`id` = 215 | 1 | 1 | 1 | |
| SELECT *, category_id FROM `carehub`.`sub_categories` AS `SubCategory` WHERE `SubCategory`.`id` = 56 | 1 | 1 | 1 | |
| SELECT `Category`.`id`, `Category`.`title`, `Category`.`created`, `Category`.`modified` FROM `carehub`.`categories` AS `Category` WHERE `Category`.`id` = 11 | 1 | 1 | 1 | |
| SELECT *, sub_category_id FROM `carehub`.`services` AS `Service` WHERE `Service`.`id` = 216 | 1 | 1 | 1 | |
| SELECT *, category_id FROM `carehub`.`sub_categories` AS `SubCategory` WHERE `SubCategory`.`id` = 56 | 1 | 1 | 1 | |
| SELECT `Category`.`id`, `Category`.`title`, `Category`.`created`, `Category`.`modified` FROM `carehub`.`categories` AS `Category` WHERE `Category`.`id` = 11 | 1 | 1 | 1 | |
| SELECT *, sub_category_id FROM `carehub`.`services` AS `Service` WHERE `Service`.`id` = 262 | 1 | 1 | 1 | |
| SELECT *, category_id FROM `carehub`.`sub_categories` AS `SubCategory` WHERE `SubCategory`.`id` = 58 | 1 | 1 | 1 | |
| SELECT `Category`.`id`, `Category`.`title`, `Category`.`created`, `Category`.`modified` FROM `carehub`.`categories` AS `Category` WHERE `Category`.`id` = 11 | 1 | 1 | 1 | |
| SELECT *, sub_category_id FROM `carehub`.`services` AS `Service` WHERE `Service`.`id` = 221 | 1 | 1 | 1 | |
| SELECT *, category_id FROM `carehub`.`sub_categories` AS `SubCategory` WHERE `SubCategory`.`id` = 58 | 1 | 1 | 1 | |
| SELECT `Category`.`id`, `Category`.`title`, `Category`.`created`, `Category`.`modified` FROM `carehub`.`categories` AS `Category` WHERE `Category`.`id` = 11 | 1 | 1 | 1 | |
| SELECT *, sub_category_id FROM `carehub`.`services` AS `Service` WHERE `Service`.`id` = 223 | 1 | 1 | 1 | |
| SELECT *, category_id FROM `carehub`.`sub_categories` AS `SubCategory` WHERE `SubCategory`.`id` = 58 | 1 | 1 | 1 | |
| SELECT `Category`.`id`, `Category`.`title`, `Category`.`created`, `Category`.`modified` FROM `carehub`.`categories` AS `Category` WHERE `Category`.`id` = 11 | 1 | 1 | 1 | |
| SELECT *, sub_category_id FROM `carehub`.`services` AS `Service` WHERE `Service`.`id` = 186 | 1 | 1 | 1 | |
| SELECT *, category_id FROM `carehub`.`sub_categories` AS `SubCategory` WHERE `SubCategory`.`id` = 52 | 1 | 1 | 1 | |
| SELECT `Category`.`id`, `Category`.`title`, `Category`.`created`, `Category`.`modified` FROM `carehub`.`categories` AS `Category` WHERE `Category`.`id` = 4 | 1 | 1 | 1 | |
| SELECT *, sub_category_id FROM `carehub`.`services` AS `Service` WHERE `Service`.`id` = 154 | 1 | 1 | 1 | |
| SELECT *, category_id FROM `carehub`.`sub_categories` AS `SubCategory` WHERE `SubCategory`.`id` = 32 | 1 | 1 | 1 | |
| SELECT `Category`.`id`, `Category`.`title`, `Category`.`created`, `Category`.`modified` FROM `carehub`.`categories` AS `Category` WHERE `Category`.`id` = 4 | 1 | 1 | 1 | |
| SELECT *, sub_category_id FROM `carehub`.`services` AS `Service` WHERE `Service`.`id` = 135 | 1 | 1 | 1 | |
| SELECT *, category_id FROM `carehub`.`sub_categories` AS `SubCategory` WHERE `SubCategory`.`id` = 32 | 1 | 1 | 1 | |
| SELECT `Category`.`id`, `Category`.`title`, `Category`.`created`, `Category`.`modified` FROM `carehub`.`categories` AS `Category` WHERE `Category`.`id` = 4 | 1 | 1 | 1 | |
| SELECT *, sub_category_id FROM `carehub`.`services` AS `Service` WHERE `Service`.`id` = 204 | 1 | 1 | 1 | |
| SELECT *, category_id FROM `carehub`.`sub_categories` AS `SubCategory` WHERE `SubCategory`.`id` = 6 | 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` = 155 | 1 | 1 | 1 | |
| SELECT *, category_id FROM `carehub`.`sub_categories` AS `SubCategory` WHERE `SubCategory`.`id` = 6 | 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` = 136 | 1 | 1 | 1 | |
| SELECT *, category_id FROM `carehub`.`sub_categories` AS `SubCategory` WHERE `SubCategory`.`id` = 6 | 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` = 197 | 1 | 1 | 1 | |
| SELECT *, category_id FROM `carehub`.`sub_categories` AS `SubCategory` WHERE `SubCategory`.`id` = 6 | 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` = 19 | 1 | 1 | 1 | |
| SELECT *, category_id FROM `carehub`.`sub_categories` AS `SubCategory` WHERE `SubCategory`.`id` = 15 | 1 | 1 | 1 | |
| SELECT `Category`.`id`, `Category`.`title`, `Category`.`created`, `Category`.`modified` FROM `carehub`.`categories` AS `Category` WHERE `Category`.`id` = 8 | 1 | 1 | 1 | |
47 duplicate queries run.
