| Queries | Time | Rows |
| SELECT *
FROM (`sites`)
WHERE `domain` = 'nowplayingnashville.com' | 0.000 | 1 |
| SELECT *
FROM (`redirect_link`)
WHERE `site_id` = '71'
AND `altURL` = 'venue/detail/34021' | 0.000 | 0 |
| SELECT *
FROM (`accessibility`)
ORDER BY `name` ASC | 0.000 | 12 |
| SELECT *
FROM (`sites`)
WHERE `domain` = 'nowplayingnashville.com' | 0.000 | 1 |
| SELECT *
FROM (`sites`)
WHERE `domain` = 'nowplayingnashville.com' | 0.000 | 1 |
| INSERT INTO `visit` (`itemID`, `site_id`, `itemType`, `ip`, `referer`) VALUES (34021, '71', 'venue', '38.107.191.81', '') | 0.000 | 1 |
| SELECT *
FROM (`venue`)
WHERE `venueID` = '34021'
AND `site_id` = '71' | 0.000 | 1 |
| SELECT *
FROM (`sites`)
WHERE `id` = '71' | 0.000 | 1 |
| SELECT DISTINCT `accessibility_id`
FROM (`accessibility_to_venue`)
WHERE `venue_id` = '34021'
AND `site_id` = '71' | 0.000 | 0 |
| SELECT *
FROM (`venue`)
WHERE display > 0
AND `venueID` = '0'
AND `site_id` = '71' | 0.000 | 0 |
| SELECT *
FROM (`venue`)
WHERE display > 0
AND `parent_id` = '34021'
AND `site_id` = '71' | 0.005 | 0 |
| SELECT *
FROM (`gallery`)
WHERE `site_id` = '71'
AND `appID` = '34021'
AND `app` = 'venues'
ORDER BY `position` ASC | 0.030 | 0 |
| SELECT *
FROM (`gallery`)
WHERE `site_id` = '71'
AND `appID` = '34021'
AND `app` = 'venues'
ORDER BY `position` ASC | 0.002 | 0 |
| SELECT *
FROM (`video_link`)
WHERE `itemID` = '34021'
AND `itemType` = 'venue'
AND `site_id` = '71' | 0.001 | 0 |
| SELECT `e`.`eventID`, `e`.`name`, `e`.`description`, `e`.`venueID`, `e`.`dateBegin`, `e`.`dateEnd`, `e`.`image`
FROM (`event` AS `e`)
WHERE e.venueID = 34021
AND e.site_id = 71
AND e.display > 0
AND e.dateBegin < '2010-03-22'
AND e.dateEnd > '2010-03-22'
ORDER BY `e`.`dateBegin` DESC
LIMIT 0, 15 | 0.059 | 0 |
| SELECT `e`.`eventID`, `e`.`name`, `e`.`description`, `e`.`venueID`, `e`.`dateBegin`, `e`.`dateEnd`, `e`.`image`
FROM (`event` AS `e`)
WHERE e.venueID = 34021
AND e.site_id = 71
AND e.display > 0
AND e.dateBegin >= '2010-03-22'
ORDER BY `e`.`dateBegin` DESC
LIMIT 0, 100 | 0.061 | 0 |
| SELECT `e`.`eventID`, `e`.`name`, `e`.`description`, `e`.`venueID`, `e`.`dateBegin`, `e`.`dateEnd`, `e`.`image`
FROM (`event` AS `e`)
WHERE e.venueID = 34021
AND e.site_id = 71
AND e.display > 0
AND e.dateEnd < '2010-03-22'
ORDER BY `e`.`dateBegin` DESC
LIMIT 0, 100 | 0.059 | 1 |
| SELECT *
FROM (`modules`)
WHERE `site_id` = '71'
AND `active` = 'Y'
ORDER BY `sequence` ASC, `mod_id` ASC | 0.001 | 5 |
| SELECT *
FROM (`default_modules`) | 0.000 | 10 |
| SELECT *, IFNULL(alt_name, submod_name) as name
FROM (`submodules`)
WHERE `site_id` = '71'
AND `active` = 'Y'
ORDER BY `mod_id` ASC, `name` ASC | 0.000 | 24 |
| SELECT *
FROM (`meta_tags`)
WHERE `url` = 'venue/detail/34021'
AND `site_id` = '71' | 0.001 | 0 |
| SELECT *
FROM (`redirect_link`)
WHERE `site_id` = '71'
AND `altURL` = 'venue/detail/34021' | 0.001 | 0 |
| SELECT *
FROM (`page`)
WHERE `url` = 'venue/detail/34021'
AND `site_id` = '71' | 0.001 | 0 |
| SELECT *
FROM (`page_item`)
WHERE `page_id` = 0
AND `site_id` = '71'
ORDER BY `blockorder` ASC | 0.000 | 11 |
| SELECT *
FROM (`content`)
WHERE `content`.`site_id` = '71'
AND `content`.`id` = 'partners' | 0.000 | 1 |
| SELECT *
FROM (`content`)
WHERE `content`.`site_id` = '71'
AND `content`.`id` = 'site_credits' | 0.000 | 1 |
| SELECT *
FROM (`content`)
WHERE `content`.`site_id` = '71'
AND `content`.`id` = 'network' | 0.001 | 1 |
| SELECT *
FROM (`sites`)
WHERE `domain` = 'nowplayingnashville.com' | 0.000 | 1 |
| SELECT *
FROM (`sites`)
WHERE `id` = '71' | 0.000 | 1 |
| SELECT *
FROM (`sites`)
WHERE `domain` = 'nowplayingnashville.com' | 0.000 | 1 |
| SELECT *
FROM (`sites`)
WHERE `id` = '71' | 0.000 | 1 |
| SELECT *
FROM (`content`)
WHERE `content`.`site_id` = '71'
AND `content`.`id` = 'services_box' | 0.000 | 1 |
| SELECT *
FROM (`content`)
WHERE `content`.`site_id` = '71'
AND `content`.`id` = 'featured_section' | 0.000 | 0 |
| SELECT *
FROM (`content`)
WHERE `content`.`site_id` = '71'
AND `content`.`id` = 'featured_sections' | 0.000 | 1 |
| SELECT *
FROM (`content`)
WHERE `content`.`site_id` = '71'
AND `content`.`id` = 'featured_video' | 0.000 | 1 |
| SELECT *
FROM (`sites`)
WHERE `domain` = 'nowplayingnashville.com' | 0.000 | 1 |
| SELECT *
FROM (`sites`)
WHERE `id` = '71' | 0.000 | 1 |
| Total: 37 | 0.228 | 81 |
Live Music Tonight 
Dining Out
Video Central
Social Media
Nashville Arts & Entertainment
Visit Music City 
Make NowPlayingNashville.com
An initiative of The Community Foundation of Middle Tennessee