(default) 15 queries took 83 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1DESCRIBE `pages`24241
2DESCRIBE `media`16161
3DESCRIBE `fireplaces`24242
4DESCRIBE `slips`992
5DESCRIBE `grates`221
6DESCRIBE `grate_images`771
7DESCRIBE `bullnoses`17171
8SELECT `Page`.`id`, `Page`.`title`, `Page`.`short_title`, `Page`.`parent_id`, `Page`.`type`, `Page`.`slug`, `Page`.`is_published`, (COUNT(`ParentPage`.`id`)-1) AS depth FROM `pages` AS `Page` INNER JOIN pages AS `ParentPage` ON (`Page`.`lft` BETWEEN `ParentPage`.`lft` AND `ParentPage`.`rght`) WHERE 1 = 1 GROUP BY `Page`.`id` ORDER BY `Page`.`lft` ASC 45745739
9SELECT `Page`.`type`, `Page`.`foreign_key` FROM `pages` AS `Page` WHERE id = 53 LIMIT 1111
10SELECT `Slip`.`id`, `Slip`.`max_width`, `Slip`.`max_height`, `Slip`.`left_image_id`, `Slip`.`left_image_width`, `Slip`.`top_image_id`, `Slip`.`top_image_width`, `Slip`.`right_image_id`, `Slip`.`right_image_width`, `Page`.`id`, `Page`.`parent_id`, `Page`.`lft`, `Page`.`rght`, `Page`.`ordering`, `Page`.`type`, `Page`.`foreign_key`, `Page`.`slug`, `Page`.`title`, `Page`.`short_title`, `Page`.`content`, `Page`.`description`, `Page`.`main_image_id`, `Page`.`thumb_image_id`, `Page`.`thumb_text`, `Page`.`is_published`, `Page`.`is_locked`, `Page`.`is_for_sale`, `Page`.`is_sold`, `Page`.`show_thumbs`, `Page`.`created`, `Page`.`updated`, `Page`.`created_by`, `Page`.`updated_by` FROM `slips` AS `Slip` LEFT JOIN `pages` AS `Page` ON (`Page`.`type` = "Slip" AND `Page`.`foreign_key` = `Slip`.`id`) WHERE `Slip`.`id` = 9 LIMIT 1111
11SELECT `Page`.`id`, `Page`.`parent_id`, `Page`.`lft`, `Page`.`rght`, `Page`.`ordering`, `Page`.`type`, `Page`.`foreign_key`, `Page`.`slug`, `Page`.`title`, `Page`.`short_title`, `Page`.`content`, `Page`.`description`, `Page`.`main_image_id`, `Page`.`thumb_image_id`, `Page`.`thumb_text`, `Page`.`is_published`, `Page`.`is_locked`, `Page`.`is_for_sale`, `Page`.`is_sold`, `Page`.`show_thumbs`, `Page`.`created`, `Page`.`updated`, `Page`.`created_by`, `Page`.`updated_by` FROM `pages` AS `Page` WHERE `Page`.`type` = "Slip" AND `Page`.`foreign_key` = 9 111
12SELECT `MainImage`.`id`, `MainImage`.`model`, `MainImage`.`foreign_key`, `MainImage`.`filename`, `MainImage`.`ext`, `MainImage`.`mimetype`, `MainImage`.`filesize`, `MainImage`.`checksum`, `MainImage`.`dir`, `MainImage`.`height`, `MainImage`.`width`, `MainImage`.`description`, `MainImage`.`version`, `MainImage`.`ordering`, `MainImage`.`created`, `MainImage`.`updated` FROM `media` AS `MainImage` WHERE `MainImage`.`id` = 101 110
13SELECT `Image`.`id`, `Image`.`model`, `Image`.`foreign_key`, `Image`.`filename`, `Image`.`ext`, `Image`.`mimetype`, `Image`.`filesize`, `Image`.`checksum`, `Image`.`dir`, `Image`.`height`, `Image`.`width`, `Image`.`description`, `Image`.`version`, `Image`.`ordering`, `Image`.`created`, `Image`.`updated` FROM `media` AS `Image` WHERE model = "Page" AND `Image`.`foreign_key` = (53) ORDER BY `Image`.`ordering` ASC 002
14SELECT Page.id, Page.title, Fireplace.* FROM `fireplaces` AS `Fireplace` LEFT JOIN `pages` AS `Page` ON (type = "Fireplace" AND `Page`.`foreign_key` = `Fireplace`.`id`) WHERE `Page`.`type` = "Fireplace" ORDER BY `Page`.`ordering` ASC 12121
15SELECT `Page`.`id`, `Page`.`title`, `Page`.`short_title`, `Page`.`parent_id`, `Page`.`type`, `Page`.`slug`, `Page`.`is_published`, (COUNT(`ParentPage`.`id`)-1) AS depth FROM `pages` AS `Page` INNER JOIN pages AS `ParentPage` ON (`Page`.`lft` BETWEEN `ParentPage`.`lft` AND `ParentPage`.`rght`) WHERE 1 = 1 GROUP BY `Page`.`id` ORDER BY `Page`.`lft` ASC 45745729