| Query | Error | Affected | Num. rows | Took (ms) | Actions |
|---|
| SELECT COUNT(*) AS `count` FROM `products` AS `Product` WHERE `Product`.`criteria` LIKE '%\"306\"%' AND `Product`.`language` = 'bg' | | 1 | 1 | 2 | maybe slow |
| SELECT `Product`.`slug`, `Product`.`title`, `Product`.`summary`, `Product`.`dir`, `Product`.`filename` FROM `products` AS `Product` WHERE `Product`.`criteria` LIKE '%\"306\"%' AND `Product`.`language` = 'bg' ORDER BY `Product`.`created` DESC LIMIT 24, 24 | | 9 | 9 | 2 | maybe slow |
| SELECT `Criterion`.`title` FROM `criteria` AS `Criterion` WHERE `Criterion`.`id` = 306 AND `Criterion`.`language` = 'bg' LIMIT 1 | | 1 | 1 | 1 | |
| SHOW FULL COLUMNS FROM `subgroups` | | 3 | 3 | 1 | maybe slow |
| SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'utf8mb3_general_ci'; | | 1 | 1 | 1 | |
| SELECT `Product`.`group_id`, `Product`.`subgroup_id`, `Product`.`is_popular`, `Product`.`types`, `Product`.`criteria`, `Product`.`company_id`, `Company`.`slug`, `Company`.`name`, `Subgroup`.`id`, `Subgroup`.`title`, `Company`.`id`, `Product`.`id` FROM `products` AS `Product` LEFT JOIN `companies` AS `Company` ON (`Product`.`company_id` = `Company`.`id`) LEFT JOIN `subgroups` AS `Subgroup` ON (`Product`.`subgroup_id` = `Subgroup`.`id`) WHERE `Product`.`criteria` LIKE '%\"306\"%' AND `Product`.`language` = 'bg' | | 33 | 33 | 2 | maybe slow |
| SELECT `Criterion`.`id`, `Criterion`.`title`, `ProductsCriterium`.`product_id`, `ProductsCriterium`.`criterion_id` FROM `criteria` AS `Criterion` JOIN `products_criteria` AS `ProductsCriterium` ON (`ProductsCriterium`.`product_id` IN (1461, 1460, 1437, 1421, 1426, 1431, 1415, 1416, 1417, 1418, 1434, 1435, 1440, 1423, 1439, 1422, 1429, 1438, 1432, 1424, 1433, 1420, 1428, 1419, 1430, 1425, 1427, 1436, 1441, 1442, 1443, 1444, 1459) AND `ProductsCriterium`.`criterion_id` = `Criterion`.`id`) | | 33 | 33 | 2 | maybe slow |
| UPDATE `sites` AS `Site` SET `Site`.`view_count` = Site.view_count + 1 WHERE `Site`.`id` = 1 | | 1 | | 1 | maybe slow |
| SELECT `Site`.`view_count` FROM `sites` AS `Site` WHERE `Site`.`id` = 1 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` = 'after_blue_box' AND `BlockContent`.`language` = 'bg' LIMIT 1 | | 1 | 1 | 1 | |
| SELECT `Type`.`id`, `Type`.`title` FROM `types` AS `Type` WHERE `Type`.`language` = 'bg' ORDER BY `title` ASC | | 26 | 26 | 1 | |
| SELECT `CompanyCategory`.`id`, `CompanyCategory`.`title` FROM `company_categories` AS `CompanyCategory` WHERE `CompanyCategory`.`language` = 'bg' ORDER BY `title` ASC | | 12 | 12 | 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` = 'bg' AND `Navigation`.`key` = 'main' AND `Link`.`language` = 'bg' ORDER BY `Link`.`lft` ASC | | 7 | 7 | 1 | 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` = 'bg' 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` = 'right_sidebar' AND `BlockContent`.`language` = 'bg' 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` = 'bg' LIMIT 1 | | 1 | 1 | 1 | |
| 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` = 'bg' AND `Navigation`.`key` = 'footer' AND `Link`.`language` = 'bg' ORDER BY `Link`.`lft` ASC | | 6 | 6 | 1 | 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` = 'footer' AND `BlockContent`.`language` = 'bg' LIMIT 1 | | 1 | 1 | 1 | |
