offmotorway.com is a directory for travellers searching for food, refreshments, accommodation, meeting places and other services just off the UK motorway network hence avoiding the busy motorway service stations. 

 Motorway services are fine but have you ever been driving and wished you knew the area better? You pass junction after junction looking for refreshments, somewhere to stay,  meet a friend or business acquaintance. All you want is somewhere to break a stressful motorway journey but fail to find one.

(default) 24 queries took 19 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1DESCRIBE `businesses`32321
2DESCRIBE `users`16161
3DESCRIBE `business_temps`32321
4DESCRIBE `chains`220
5DESCRIBE `options`12121
6DESCRIBE `orders`20201
7DESCRIBE `categories`220
8DESCRIBE `businesses_categories`330
9DESCRIBE `features`330
10DESCRIBE `businesses_features`331
11DESCRIBE `hotspots`660
12DESCRIBE `staticpages`550
13DESCRIBE `intros`440
14Select * from intros where page ='display' && folder = 'pages'110
15SELECT `Staticpage`.`id`, `Staticpage`.`page`, `Staticpage`.`info`, `Staticpage`.`menu_position`, `Staticpage`.`status` FROM `staticpages` AS `Staticpage` WHERE 1 = 1 440
16Select * from businesses where op_thumbnail_image = 1 && primary_image != 'NULL' && primary_image != '' && advert_end_date >=CURDATE() order by rand();001
17Select * from businesses where op_thumbnail_image != 1 && primary_image != 'NULL' && primary_image != '' && advert_end_date >=CURDATE() order by rand();001
18Select * from businesses where op_large_banner = 1 && primary_image != 'NULL' && primary_image != '' && advert_end_date >=CURDATE() order by rand();001
19Select * from staticpages where page ='home';000
20SELECT `Category`.`id`, `Category`.`category` FROM `categories` AS `Category` WHERE 1 = 1 550
21SELECT `Business`.`id`, `Business`.`user_id`, `Business`.`business_name`, `Business`.`package_id`, `Business`.`address`, `Business`.`address2`, `Business`.`town`, `Business`.`county`, `Business`.`post_code`, `Business`.`latitude`, `Business`.`longitude`, `Business`.`short_description`, `Business`.`long_description`, `Business`.`website_address`, `Business`.`status`, `Business`.`chain_id`, `Business`.`telephone`, `Business`.`email_address`, `Business`.`primary_image`, `Business`.`advert_start_date`, `Business`.`advert_end_date`, `Business`.`op_description_box`, `Business`.`op_long_description`, `Business`.`op_main_image`, `Business`.`op_link_to_company`, `Business`.`op_images`, `Business`.`op_thumbnail_image`, `Business`.`op_large_banner`, `Business`.`ip_address`, `Business`.`date_created`, `Business`.`admin_note`, `Business`.`near`, `BusinessesCategory`.`id`, `BusinessesCategory`.`business_id`, `BusinessesCategory`.`category_id` FROM `businesses` AS `Business` JOIN `businesses_categories` AS `BusinessesCategory` ON (`BusinessesCategory`.`category_id` IN (1, 2, 3, 4, 6) AND `BusinessesCategory`.`business_id` = `Business`.`id`) WHERE 1 = 1 26262
22SELECT `BusinessTemp`.`id`, `BusinessTemp`.`business_name`, `BusinessTemp`.`user_id`, `BusinessTemp`.`package_id`, `BusinessTemp`.`address`, `BusinessTemp`.`address2`, `BusinessTemp`.`town`, `BusinessTemp`.`county`, `BusinessTemp`.`post_code`, `BusinessTemp`.`longitude`, `BusinessTemp`.`latitude`, `BusinessTemp`.`short_description`, `BusinessTemp`.`long_description`, `BusinessTemp`.`website_address`, `BusinessTemp`.`status`, `BusinessTemp`.`chain_id`, `BusinessTemp`.`telephone`, `BusinessTemp`.`email_address`, `BusinessTemp`.`primary_image`, `BusinessTemp`.`advert_start_date`, `BusinessTemp`.`advert_end_date`, `BusinessTemp`.`op_description_box`, `BusinessTemp`.`op_long_description`, `BusinessTemp`.`op_main_image`, `BusinessTemp`.`op_link_to_company`, `BusinessTemp`.`op_images`, `BusinessTemp`.`op_thumbnail_image`, `BusinessTemp`.`op_large_banner`, `BusinessTemp`.`ip_address`, `BusinessTemp`.`date_created`, `BusinessTemp`.`admin_note`, `BusinessTemp`.`near`, `BusinessesCategory`.`id`, `BusinessesCategory`.`business_id`, `BusinessesCategory`.`category_id` FROM `business_temps` AS `BusinessTemp` JOIN `businesses_categories` AS `BusinessesCategory` ON (`BusinessesCategory`.`category_id` IN (1, 2, 3, 4, 6) AND `BusinessesCategory`.`business_id` = `BusinessTemp`.`id`) WHERE 1 = 1 551
23SELECT `Hotspot`.`id`, `Hotspot`.`major_road`, `Hotspot`.`junction_name`, `Hotspot`.`longitude`, `Hotspot`.`latitude`, `Hotspot`.`description` FROM `hotspots` AS `Hotspot` WHERE 1 = 1 ORDER BY `Hotspot`.`major_road` ASC, `Hotspot`.`junction_name` ASC 2602605
24SELECT `Hotspot`.`id`, `Hotspot`.`major_road`, `Hotspot`.`junction_name`, `Hotspot`.`longitude`, `Hotspot`.`latitude`, `Hotspot`.`description` FROM `hotspots` AS `Hotspot` WHERE 1 = 1 2602602