Newsletter Signup
Top Ten Toxic Threats 2013

Top Ten Toxic Threats 2013

(default) 11 queries took 32 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT `SiteReport`.`id`, `SiteReport`.`name`, `SiteReport`.`report_year`, `SiteReport`.`intro_text`, `SiteReport`.`image`, `SiteReport`.`map`, `SiteReport`.`short_title`, `SiteReport`.`thumbnail`, `SiteReport`.`attachment`, `SiteReport`.`attachment_filename`, `SiteReport`.`attachment_mime`, `SiteReport`.`active` FROM `site_reports` AS `SiteReport` WHERE `active` = 1 ORDER BY `report_year` DESC LIMIT 1111
2SELECT `SiteLink`.`id`, `SiteLink`.`site_report_id`, `SiteLink`.`link_text`, `SiteLink`.`link_url` FROM `site_links` AS `SiteLink` WHERE `SiteLink`.`site_report_id` = (18) 000
3SELECT `ProjectsReports`.`id`, `ProjectsReports`.`site_report_id`, `ProjectsReports`.`weight`, `ProjectsReports`.`title`, `ProjectsReports`.`subtitle`, `ProjectsReports`.`image`, `ProjectsReports`.`description` FROM `projects_reports` AS `ProjectsReports` WHERE `ProjectsReports`.`site_report_id` = (18) ORDER BY `ProjectsReports`.`weight` ASC 10103
4SELECT `GalleryImage`.`id`, `GalleryImage`.`gallery_id`, `GalleryImage`.`image`, `GalleryImage`.`title`, `GalleryImage`.`description`, `GalleryImage`.`weight`, `GalleryImage`.`mime`, `GalleryImage`.`is_title` FROM `gallery_images` AS `GalleryImage` WHERE `GalleryImage`.`gallery_id` = (18) ORDER BY weight ASC 17171
5SELECT `DynpageCategory`.`id`, `DynpageCategory`.`parent_category`, `DynpageCategory`.`title`, `DynpageCategory`.`url`, `DynpageCategory`.`weight`, `ParentCategory`.`id`, `ParentCategory`.`parent_category`, `ParentCategory`.`title`, `ParentCategory`.`url`, `ParentCategory`.`weight` FROM `dynpage_categories` AS `DynpageCategory` LEFT JOIN `dynpage_categories` AS `ParentCategory` ON (`DynpageCategory`.`parent_category` = `ParentCategory`.`id`) WHERE `DynpageCategory`.`title` = '2013' ORDER BY `DynpageCategory`.`weight` ASC, `ParentCategory`.`weight` ASC LIMIT 1110
6SELECT `DynpageCategory`.`id`, `DynpageCategory`.`parent_category`, `DynpageCategory`.`title`, `DynpageCategory`.`url`, `DynpageCategory`.`weight`, `ParentCategory`.`id`, `ParentCategory`.`parent_category`, `ParentCategory`.`title`, `ParentCategory`.`url`, `ParentCategory`.`weight` FROM `dynpage_categories` AS `DynpageCategory` LEFT JOIN `dynpage_categories` AS `ParentCategory` ON (`DynpageCategory`.`parent_category` = `ParentCategory`.`id`) WHERE `DynpageCategory`.`parent_category` = 61 ORDER BY `DynpageCategory`.`weight` ASC, `ParentCategory`.`weight` ASC 441
7SELECT `SiteReport`.`id`, `SiteReport`.`name`, `SiteReport`.`report_year`, `SiteReport`.`intro_text`, `SiteReport`.`image`, `SiteReport`.`map`, `SiteReport`.`short_title`, `SiteReport`.`thumbnail`, `SiteReport`.`attachment`, `SiteReport`.`attachment_filename`, `SiteReport`.`attachment_mime`, `SiteReport`.`active` FROM `site_reports` AS `SiteReport` WHERE `active` = 1 ORDER BY `report_year` DESC 771
8SELECT `SiteLink`.`id`, `SiteLink`.`site_report_id`, `SiteLink`.`link_text`, `SiteLink`.`link_url` FROM `site_links` AS `SiteLink` WHERE `SiteLink`.`site_report_id` IN (18, 17, 16, 15, 14, 13, 1) 000
9SELECT `ProjectsReports`.`id`, `ProjectsReports`.`site_report_id`, `ProjectsReports`.`weight`, `ProjectsReports`.`title`, `ProjectsReports`.`subtitle`, `ProjectsReports`.`image`, `ProjectsReports`.`description` FROM `projects_reports` AS `ProjectsReports` WHERE `ProjectsReports`.`site_report_id` IN (18, 17, 16, 15, 14, 13, 1) ORDER BY `ProjectsReports`.`weight` ASC 707021
10SELECT `GalleryImage`.`id`, `GalleryImage`.`gallery_id`, `GalleryImage`.`image`, `GalleryImage`.`title`, `GalleryImage`.`description`, `GalleryImage`.`weight`, `GalleryImage`.`mime`, `GalleryImage`.`is_title` FROM `gallery_images` AS `GalleryImage` WHERE `GalleryImage`.`gallery_id` IN (18, 17, 16, 15, 14, 13, 1) ORDER BY weight ASC 3483483
11SELECT `Dynpage`.`id`, `Dynpage`.`site_report_id`, `Dynpage`.`dynpage_category_id`, `Dynpage`.`weight`, `Dynpage`.`title`, `Dynpage`.`seo_title`, `Dynpage`.`content`, `Dynpage`.`side_content`, `Dynpage`.`access`, `Dynpage`.`modified`, `Dynpage`.`lang`, `Dynpage`.`ip`, `Dynpage`.`revision`, `Dynpage`.`accessed`, `Dynpage`.`window_title`, `Dynpage`.`keywords`, `Dynpage`.`description`, `Dynpage`.`image`, `Dynpage`.`image_legend`, `DynpageCategory`.`id`, `DynpageCategory`.`parent_category`, `DynpageCategory`.`title`, `DynpageCategory`.`url`, `DynpageCategory`.`weight`, `SiteReport`.`id`, `SiteReport`.`name`, `SiteReport`.`report_year`, `SiteReport`.`intro_text`, `SiteReport`.`image`, `SiteReport`.`map`, `SiteReport`.`short_title`, `SiteReport`.`thumbnail`, `SiteReport`.`attachment`, `SiteReport`.`attachment_filename`, `SiteReport`.`attachment_mime`, `SiteReport`.`active` FROM `dynpages` AS `Dynpage` LEFT JOIN `dynpage_categories` AS `DynpageCategory` ON (`Dynpage`.`dynpage_category_id` = `DynpageCategory`.`id`) LEFT JOIN `site_reports` AS `SiteReport` ON (`Dynpage`.`site_report_id` = `SiteReport`.`id`) WHERE `Dynpage`.`seo_title` = '2012-fact-sheets' LIMIT 1111
(projects) 0 query took ms
NrQueryErrorAffectedNum. rowsTook (ms)