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 60 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1DESCRIBE `businesses`32321
2DESCRIBE `users`16168
3DESCRIBE `business_temps`32321
4DESCRIBE `chains`227
5DESCRIBE `options`12125
6DESCRIBE `orders`202013
7DESCRIBE `categories`220
8DESCRIBE `businesses_categories`330
9DESCRIBE `features`331
10DESCRIBE `businesses_features`330
11DESCRIBE `hotspots`661
12DESCRIBE `staticpages`551
13DESCRIBE `intros`441
14Select * from intros where page ='display' && folder = 'pages'111
15SELECT `Staticpage`.`id`, `Staticpage`.`page`, `Staticpage`.`info`, `Staticpage`.`menu_position`, `Staticpage`.`status` FROM `staticpages` AS `Staticpage` WHERE 1 = 1 441
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 554
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 2602606
24SELECT `Hotspot`.`id`, `Hotspot`.`major_road`, `Hotspot`.`junction_name`, `Hotspot`.`longitude`, `Hotspot`.`latitude`, `Hotspot`.`description` FROM `hotspots` AS `Hotspot` WHERE 1 = 1 2602603