Query | Error | Affected | Num. rows | Took (ms) | Actions |
---|
SHOW FULL COLUMNS FROM `posts` | | 10 | 10 | 1 | maybe slow |
SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'utf8mb3_unicode_ci'; | | 1 | 1 | 1 | |
SHOW FULL COLUMNS FROM `options` | | 5 | 5 | 1 | maybe slow |
SHOW FULL COLUMNS FROM `administrators` | | 4 | 4 | 1 | maybe slow |
SELECT `Post`.`id`, `Post`.`title`, `Post`.`slug`, `Post`.`summary`, `Post`.`content`, `Post`.`type`, `Post`.`filename`, `Post`.`dir`, `Post`.`language`, `Post`.`created` FROM `posts` AS `Post` WHERE `Post`.`slug` = 'a-rooftop-garden-on-the-city-bus' AND `Post`.`language` = 'en' LIMIT 1 | | 1 | 1 | 1 | |
SHOW FULL COLUMNS FROM `sites` | | 2 | 2 | 1 | maybe slow |
UPDATE `sites` AS `Site` SET `Site`.`view_count` = Site.view_count + 1 WHERE `Site`.`id` = 1 | | 1 | | 0 | |
SELECT `Site`.`view_count` FROM `sites` AS `Site` WHERE `Site`.`id` = 1 LIMIT 1 | | 1 | 1 | 0 | |
SHOW FULL COLUMNS FROM `links` | | 10 | 10 | 1 | maybe slow |
SHOW FULL COLUMNS FROM `navigations` | | 3 | 3 | 1 | maybe slow |
SELECT `Link`.`id`, `Link`.`title`, `Link`.`type`, `Link`.`object_id`, `Link`.`subject`, `Link`.`lft`, `Link`.`rght`, `Link`.`language`, `Link`.`navigation_id`, `Link`.`parent_id`, `Navigation`.`id`, `Navigation`.`name`, `Navigation`.`key` FROM `links` AS `Link` LEFT JOIN `navigations` AS `Navigation` ON (`Link`.`navigation_id` = `Navigation`.`id`) WHERE `Link`.`language` = 'en' AND `Navigation`.`key` = 'main' AND `Link`.`language` = 'en' ORDER BY `Link`.`lft` ASC | | 8 | 8 | 0 | |
SHOW FULL COLUMNS FROM `types` | | 5 | 5 | 3 | maybe slow |
SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'utf8mb3_general_ci'; | | 1 | 1 | 4 | maybe slow |
SHOW FULL COLUMNS FROM `products` | | 19 | 19 | 1 | maybe slow |
SHOW FULL COLUMNS FROM `criteria` | | 3 | 3 | 1 | maybe slow |
SHOW FULL COLUMNS FROM `products_criteria` | | 2 | 2 | 1 | maybe slow |
SHOW FULL COLUMNS FROM `products_types` | | 2 | 2 | 1 | maybe slow |
SELECT `Type`.`id`, `Type`.`title`, `Type`.`filename`, `Type`.`dir`, `Type`.`language` FROM `types` AS `Type` WHERE `Type`.`language` = 'en' ORDER BY `title` ASC | | 37 | 37 | 0 | |
SELECT `Post`.`id`, `Post`.`title`, `Post`.`slug`, `Post`.`summary`, `Post`.`content`, `Post`.`type`, `Post`.`filename`, `Post`.`dir`, `Post`.`language`, `Post`.`created` FROM `posts` AS `Post` WHERE `Post`.`type` = 'news' AND `Post`.`language` = 'en' ORDER BY `Post`.`id` DESC LIMIT 5 | | 5 | 5 | 0 | |
SELECT `Post`.`id`, `Post`.`title`, `Post`.`slug`, `Post`.`summary`, `Post`.`content`, `Post`.`type`, `Post`.`filename`, `Post`.`dir`, `Post`.`language`, `Post`.`created` FROM `posts` AS `Post` WHERE `Post`.`type` = 'curious' AND `Post`.`language` = 'en' ORDER BY `Post`.`id` DESC LIMIT 5 | | 5 | 5 | 0 | |
SHOW FULL COLUMNS FROM `blocks` | | 3 | 3 | 9 | maybe slow |
SHOW FULL COLUMNS FROM `block_contents` | | 4 | 4 | 6 | maybe slow |
SELECT `BlockContent`.`content`, `Block`.`name` FROM `block_contents` AS `BlockContent` LEFT JOIN `blocks` AS `Block` ON (`BlockContent`.`block_id` = `Block`.`id`) WHERE `Block`.`key` = 'partners' AND `BlockContent`.`language` = 'en' LIMIT 1 | | 1 | 1 | 6 | maybe slow |
SELECT `BlockContent`.`content`, `Block`.`name` FROM `block_contents` AS `BlockContent` LEFT JOIN `blocks` AS `Block` ON (`BlockContent`.`block_id` = `Block`.`id`) WHERE `Block`.`key` = 'right_sidebar' AND `BlockContent`.`language` = 'en' LIMIT 1 | | 1 | 1 | 0 | |
SELECT `BlockContent`.`content`, `Block`.`name` FROM `block_contents` AS `BlockContent` LEFT JOIN `blocks` AS `Block` ON (`BlockContent`.`block_id` = `Block`.`id`) WHERE `Block`.`key` = 'bottom' AND `BlockContent`.`language` = 'en' LIMIT 1 | | 1 | 1 | 0 | |
SELECT `Link`.`id`, `Link`.`title`, `Link`.`type`, `Link`.`object_id`, `Link`.`subject`, `Link`.`lft`, `Link`.`rght`, `Link`.`language`, `Link`.`navigation_id`, `Link`.`parent_id`, `Navigation`.`id`, `Navigation`.`name`, `Navigation`.`key` FROM `links` AS `Link` LEFT JOIN `navigations` AS `Navigation` ON (`Link`.`navigation_id` = `Navigation`.`id`) WHERE `Link`.`language` = 'en' AND `Navigation`.`key` = 'footer' AND `Link`.`language` = 'en' ORDER BY `Link`.`lft` ASC | | 8 | 8 | 0 | |
SELECT `BlockContent`.`content`, `Block`.`name` FROM `block_contents` AS `BlockContent` LEFT JOIN `blocks` AS `Block` ON (`BlockContent`.`block_id` = `Block`.`id`) WHERE `Block`.`key` = 'footer' AND `BlockContent`.`language` = 'en' LIMIT 1 | | 1 | 1 | 0 | |