| Queries | Time | Rows |
| SELECT *
FROM (`sites`)
WHERE `domain` = 'inlandarts.com' | 0.000 | 1 |
| SELECT *
FROM (`redirect_link`)
WHERE `site_id` = '47'
AND `altURL` = 'venue/detail/343' | 0.000 | 0 |
| SELECT *
FROM (`accessibility`)
ORDER BY `name` ASC | 0.000 | 12 |
| SELECT *
FROM (`sites`)
WHERE `domain` = 'inlandarts.com' | 0.000 | 1 |
| SELECT *
FROM (`sites`)
WHERE `domain` = 'inlandarts.com' | 0.000 | 1 |
| INSERT INTO `visit` (`itemID`, `site_id`, `itemType`, `ip`, `referer`) VALUES (343, '47', 'venue', '38.107.191.83', '') | 0.000 | 1 |
| SELECT *
FROM (`venue`)
WHERE `venueID` = '343'
AND `site_id` = '47' | 0.000 | 1 |
| SELECT *
FROM (`sites`)
WHERE `id` = '47' | 0.000 | 1 |
| SELECT DISTINCT `accessibility_id`
FROM (`accessibility_to_venue`)
WHERE `venue_id` = '343'
AND `site_id` = '47' | 0.000 | 0 |
| SELECT *
FROM (`venue`)
WHERE display > 0
AND `venueID` = '0'
AND `site_id` = '47' | 0.000 | 0 |
| SELECT *
FROM (`venue`)
WHERE display > 0
AND `parent_id` = '343'
AND `site_id` = '47' | 0.003 | 0 |
| SELECT *
FROM (`gallery`)
WHERE `site_id` = '47'
AND `appID` = '343'
AND `app` = 'venues'
ORDER BY `position` ASC | 0.025 | 0 |
| SELECT *
FROM (`gallery`)
WHERE `site_id` = '47'
AND `appID` = '343'
AND `app` = 'venues'
ORDER BY `position` ASC | 0.000 | 0 |
| SELECT *
FROM (`video_link`)
WHERE `itemID` = '343'
AND `itemType` = 'venue'
AND `site_id` = '47' | 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 = 343
AND e.site_id = 47
AND e.display > 0
AND e.dateBegin < '2010-03-15'
AND e.dateEnd > '2010-03-15'
ORDER BY `e`.`dateBegin` DESC
LIMIT 0, 15 | 0.009 | 0 |
| SELECT `e`.`eventID`, `e`.`name`, `e`.`description`, `e`.`venueID`, `e`.`dateBegin`, `e`.`dateEnd`, `e`.`image`
FROM (`event` AS `e`)
WHERE e.venueID = 343
AND e.site_id = 47
AND e.display > 0
AND e.dateBegin >= '2010-03-15'
ORDER BY `e`.`dateBegin` DESC
LIMIT 0, 100 | 0.011 | 0 |
| SELECT `e`.`eventID`, `e`.`name`, `e`.`description`, `e`.`venueID`, `e`.`dateBegin`, `e`.`dateEnd`, `e`.`image`
FROM (`event` AS `e`)
WHERE e.venueID = 343
AND e.site_id = 47
AND e.display > 0
AND e.dateEnd < '2010-03-15'
ORDER BY `e`.`dateBegin` DESC
LIMIT 0, 100 | 0.012 | 4 |
| SELECT *
FROM (`modules`)
WHERE `site_id` = '47'
AND `active` = 'Y'
ORDER BY `sequence` ASC, `mod_id` ASC | 0.000 | 6 |
| SELECT *
FROM (`default_modules`) | 0.000 | 9 |
| SELECT *, IFNULL(alt_name, submod_name) as name
FROM (`submodules`)
WHERE `site_id` = '47'
AND `active` = 'Y'
ORDER BY `mod_id` ASC, `name` ASC | 0.000 | 35 |
| SELECT *
FROM (`meta_tags`)
WHERE `url` = 'venue/detail/343'
AND `site_id` = '47' | 0.000 | 0 |
| SELECT *
FROM (`redirect_link`)
WHERE `site_id` = '47'
AND `altURL` = 'venue/detail/343' | 0.000 | 0 |
| SELECT *
FROM (`page`)
WHERE `url` = 'venue/detail/343'
AND `site_id` = '47' | 0.000 | 0 |
| SELECT *
FROM (`page_item`)
WHERE `page_id` = 0
AND `site_id` = '47'
ORDER BY `blockorder` ASC | 0.000 | 9 |
| SELECT *
FROM (`content`)
WHERE `content`.`site_id` = '47'
AND `content`.`id` = 'partners' | 0.000 | 1 |
| SELECT *
FROM (`content`)
WHERE `content`.`site_id` = '47'
AND `content`.`id` = 'site_credits' | 0.000 | 1 |
| SELECT *
FROM (`content`)
WHERE `content`.`site_id` = '47'
AND `content`.`id` = 'network' | 0.000 | 1 |
| SELECT *
FROM (`sites`)
WHERE `domain` = 'inlandarts.com' | 0.000 | 1 |
| SELECT *
FROM (`sites`)
WHERE `id` = '47' | 0.000 | 1 |
| SELECT *
FROM (`sites`)
WHERE `domain` = 'inlandarts.com' | 0.000 | 1 |
| SELECT *
FROM (`sites`)
WHERE `id` = '47' | 0.000 | 1 |
| SELECT *
FROM (`sites`)
WHERE `domain` = 'inlandarts.com' | 0.000 | 1 |
| SELECT *
FROM (`sites`)
WHERE `id` = '47' | 0.000 | 1 |
| SELECT *
FROM (`sites`)
WHERE `domain` = 'inlandarts.com' | 0.000 | 1 |
| SELECT *
FROM (`sites`)
WHERE `id` = '47' | 0.000 | 1 |
| SELECT *
FROM (`sites`)
WHERE `domain` = 'inlandarts.com' | 0.000 | 1 |
| SELECT *
FROM (`submodules`)
WHERE `site_id` = '47'
AND `mod_id` = '1'
AND `submod_id` = '1'
AND `active` = 'Y' | 0.000 | 1 |
| SELECT *
FROM (`content`)
WHERE `content`.`site_id` = '47'
AND `content`.`id` = 'esavers_signup' | 0.000 | 1 |
| SELECT *
FROM (`content`)
WHERE `content`.`site_id` = '47'
AND `content`.`id` = 'featured_sections' | 0.000 | 1 |
| SELECT *
FROM (`content`)
WHERE `content`.`site_id` = '47'
AND `content`.`id` = 'featured_video' | 0.000 | 1 |
| SELECT *
FROM (`sites`)
WHERE `domain` = 'inlandarts.com' | 0.000 | 1 |
| SELECT *
FROM (`sites`)
WHERE `id` = '47' | 0.000 | 1 |
| Total: 42 | 0.070 | 99 |