| Queries | Time | Rows |
| SELECT *
FROM (`sites`)
WHERE `domain` = 'artshound.com' | 0.000 | 1 |
| SELECT *
FROM (`redirect_link`)
WHERE `site_id` = '49'
AND `altURL` = 'venue/detail/242' | 0.000 | 0 |
| SELECT *
FROM (`accessibility`)
ORDER BY `name` ASC | 0.000 | 12 |
| SELECT *
FROM (`sites`)
WHERE `domain` = 'artshound.com' | 0.000 | 1 |
| SELECT *
FROM (`sites`)
WHERE `domain` = 'artshound.com' | 0.000 | 1 |
| INSERT INTO `visit` (`itemID`, `site_id`, `itemType`, `ip`, `referer`) VALUES (242, '49', 'venue', '38.107.191.90', '') | 0.000 | 1 |
| SELECT *
FROM (`venue`)
WHERE `venueID` = '242'
AND `site_id` = '49' | 0.000 | 1 |
| SELECT *
FROM (`sites`)
WHERE `id` = '49' | 0.000 | 1 |
| SELECT DISTINCT `accessibility_id`
FROM (`accessibility_to_venue`)
WHERE `venue_id` = '242'
AND `site_id` = '49' | 0.000 | 0 |
| SELECT *
FROM (`venue`)
WHERE display > 0
AND `venueID` = '0'
AND `site_id` = '49' | 0.002 | 0 |
| SELECT *
FROM (`venue`)
WHERE display > 0
AND `parent_id` = '242'
AND `site_id` = '49' | 0.005 | 0 |
| SELECT *
FROM (`gallery`)
WHERE `site_id` = '49'
AND `appID` = '242'
AND `app` = 'venues'
ORDER BY `position` ASC | 0.028 | 0 |
| SELECT *
FROM (`gallery`)
WHERE `site_id` = '49'
AND `appID` = '242'
AND `app` = 'venues'
ORDER BY `position` ASC | 0.000 | 0 |
| SELECT *
FROM (`video_link`)
WHERE `itemID` = '242'
AND `itemType` = 'venue'
AND `site_id` = '49' | 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 = 242
AND e.site_id = 49
AND e.display > 0
AND e.dateBegin < '2010-03-09'
AND e.dateEnd > '2010-03-09'
ORDER BY `e`.`dateBegin` DESC
LIMIT 0, 15 | 0.036 | 1 |
| SELECT `e`.`eventID`, `e`.`name`, `e`.`description`, `e`.`venueID`, `e`.`dateBegin`, `e`.`dateEnd`, `e`.`image`
FROM (`event` AS `e`)
WHERE e.venueID = 242
AND e.site_id = 49
AND e.display > 0
AND e.dateBegin >= '2010-03-09'
ORDER BY `e`.`dateBegin` DESC
LIMIT 0, 100 | 0.037 | 2 |
| SELECT `e`.`eventID`, `e`.`name`, `e`.`description`, `e`.`venueID`, `e`.`dateBegin`, `e`.`dateEnd`, `e`.`image`
FROM (`event` AS `e`)
WHERE e.venueID = 242
AND e.site_id = 49
AND e.display > 0
AND e.dateEnd < '2010-03-09'
ORDER BY `e`.`dateBegin` DESC
LIMIT 0, 100 | 0.038 | 34 |
| SELECT *
FROM (`modules`)
WHERE `site_id` = '49'
AND `active` = 'Y'
ORDER BY `sequence` ASC, `mod_id` ASC | 0.000 | 5 |
| SELECT *
FROM (`default_modules`) | 0.000 | 9 |
| SELECT *, IFNULL(alt_name, submod_name) as name
FROM (`submodules`)
WHERE `site_id` = '49'
AND `active` = 'Y'
ORDER BY `mod_id` ASC, `name` ASC | 0.000 | 22 |
| SELECT *
FROM (`meta_tags`)
WHERE `url` = 'venue/detail/242'
AND `site_id` = '49' | 0.001 | 0 |
| SELECT *
FROM (`redirect_link`)
WHERE `site_id` = '49'
AND `altURL` = 'venue/detail/242' | 0.002 | 0 |
| SELECT *
FROM (`page`)
WHERE `url` = 'venue/detail/242'
AND `site_id` = '49' | 0.000 | 0 |
| SELECT *
FROM (`page_item`)
WHERE `page_id` = 0
AND `site_id` = '49'
ORDER BY `blockorder` ASC | 0.002 | 9 |
| SELECT *
FROM (`content`)
WHERE `content`.`site_id` = '49'
AND `content`.`id` = 'partners' | 0.000 | 1 |
| SELECT *
FROM (`content`)
WHERE `content`.`site_id` = '49'
AND `content`.`id` = 'site_credits' | 0.000 | 1 |
| SELECT *
FROM (`content`)
WHERE `content`.`site_id` = '49'
AND `content`.`id` = 'network' | 0.000 | 1 |
| SELECT *
FROM (`sites`)
WHERE `domain` = 'artshound.com' | 0.000 | 1 |
| SELECT *
FROM (`sites`)
WHERE `id` = '49' | 0.000 | 1 |
| SELECT *
FROM (`sites`)
WHERE `domain` = 'artshound.com' | 0.000 | 1 |
| SELECT *
FROM (`sites`)
WHERE `id` = '49' | 0.000 | 1 |
| SELECT *
FROM (`sites`)
WHERE `domain` = 'artshound.com' | 0.000 | 1 |
| SELECT *
FROM (`sites`)
WHERE `id` = '49' | 0.000 | 1 |
| SELECT *
FROM (`sites`)
WHERE `domain` = 'artshound.com' | 0.000 | 1 |
| SELECT *
FROM (`sites`)
WHERE `id` = '49' | 0.000 | 1 |
| SELECT *
FROM (`sites`)
WHERE `domain` = 'artshound.com' | 0.000 | 1 |
| SELECT *
FROM (`submodules`)
WHERE `site_id` = '49'
AND `mod_id` = '1'
AND `submod_id` = '1'
AND `active` = 'Y' | 0.000 | 1 |
| SELECT *
FROM (`content`)
WHERE `content`.`site_id` = '49'
AND `content`.`id` = 'featured_section' | 0.000 | 0 |
| SELECT *
FROM (`content`)
WHERE `content`.`site_id` = '49'
AND `content`.`id` = 'featured_sections' | 0.000 | 1 |
| SELECT *
FROM (`sites`)
WHERE `domain` = 'artshound.com' | 0.000 | 1 |
| SELECT *
FROM (`sites`)
WHERE `id` = '49' | 0.000 | 1 |
| Total: 41 | 0.158 | 116 |
Sign Up for ArtsHound E-Minders
News & Reviews
Promote Your Own Event
