| Query | Error | Affected | Num. rows | Took (ms) | Actions |
|---|
| SHOW FULL COLUMNS FROM `pages` | | 12 | 12 | 1 | maybe slow |
| SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'latin1_swedish_ci'; | | 1 | 1 | 1 | |
| SHOW FULL COLUMNS FROM `page_fields` | | 4 | 4 | 1 | maybe slow |
| SELECT `Page`.`id`, `Page`.`title`, `Page`.`desc`, `Page`.`content`, `Page`.`slug`, `Page`.`full_width`, `Page`.`template`, `Page`.`menu`, `Page`.`menu_title`, `Page`.`created_by`, `Page`.`added_on`, `Page`.`last_updated` FROM `pages` AS `Page` WHERE 1 = 1 | | 3 | 3 | 0 | |
| SELECT `PageField`.`id`, `PageField`.`page_id`, `PageField`.`value`, `PageField`.`value_description` FROM `page_fields` AS `PageField` WHERE `PageField`.`page_id` IN (1, 2, 3) | | 5 | 5 | 0 | |
| SELECT `Page`.`id`, `Page`.`title`, `Page`.`desc`, `Page`.`content`, `Page`.`slug`, `Page`.`full_width`, `Page`.`template`, `Page`.`menu`, `Page`.`menu_title`, `Page`.`created_by`, `Page`.`added_on`, `Page`.`last_updated` FROM `pages` AS `Page` WHERE `Page`.`menu` = 1 | | 1 | 1 | 0 | |
| SELECT `PageField`.`id`, `PageField`.`page_id`, `PageField`.`value`, `PageField`.`value_description` FROM `page_fields` AS `PageField` WHERE `PageField`.`page_id` = (2) | | 5 | 5 | 0 | |
| SELECT `Page`.`id`, `Page`.`title`, `Page`.`desc`, `Page`.`content`, `Page`.`slug`, `Page`.`full_width`, `Page`.`template`, `Page`.`menu`, `Page`.`menu_title`, `Page`.`created_by`, `Page`.`added_on`, `Page`.`last_updated` FROM `pages` AS `Page` WHERE `Page`.`slug` = 'contact' LIMIT 1 | | 1 | 1 | 1 | |
| SELECT `PageField`.`id`, `PageField`.`page_id`, `PageField`.`value`, `PageField`.`value_description` FROM `page_fields` AS `PageField` WHERE `PageField`.`page_id` = (2) | | 5 | 5 | 0 | |