Query | Error | Affected | Num. rows | Took (ms) | Actions |
---|
SHOW FULL COLUMNS FROM `products` | | 19 | 19 | 1 | maybe slow |
SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'utf8mb3_general_ci'; | | 1 | 1 | 1 | |
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 `types` | | 5 | 5 | 3 | maybe slow |
SHOW FULL COLUMNS FROM `products_types` | | 2 | 2 | 2 | |
SHOW FULL COLUMNS FROM `options` | | 5 | 5 | 1 | maybe slow |
SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'utf8mb3_unicode_ci'; | | 1 | 1 | 1 | |
SHOW FULL COLUMNS FROM `administrators` | | 4 | 4 | 3 | maybe slow |
SELECT COUNT(*) AS `count` FROM `products` AS `Product` WHERE `Product`.`types` LIKE '%\"25\"%' AND `Product`.`language` = 'en' | | 1 | 1 | 4 | maybe slow |
SELECT `Product`.`slug`, `Product`.`title`, `Product`.`summary`, `Product`.`dir`, `Product`.`filename` FROM `products` AS `Product` WHERE `Product`.`types` LIKE '%\"25\"%' AND `Product`.`language` = 'en' ORDER BY `Product`.`created` DESC LIMIT 24 | | 24 | 24 | 7 | maybe slow |
SELECT `Type`.`title` FROM `types` AS `Type` WHERE `Type`.`id` = 25 AND `Type`.`language` = 'en' LIMIT 1 | | 1 | 1 | 1 | |
SHOW FULL COLUMNS FROM `groups` | | 3 | 3 | 1 | maybe slow |
SHOW FULL COLUMNS FROM `companies` | | 14 | 14 | 1 | maybe slow |
SELECT `Product`.`group_id`, `Product`.`subgroup_id`, `Product`.`is_popular`, `Product`.`types`, `Product`.`criteria`, `Product`.`company_id`, `Company`.`slug`, `Company`.`name`, `Group`.`id`, `Group`.`title`, `Company`.`id`, `Product`.`id` FROM `products` AS `Product` LEFT JOIN `companies` AS `Company` ON (`Product`.`company_id` = `Company`.`id`) LEFT JOIN `groups` AS `Group` ON (`Product`.`group_id` = `Group`.`id`) WHERE `Product`.`types` LIKE '%\"25\"%' AND `Product`.`language` = 'en' | | 137 | 137 | 5 | |
SELECT `Type`.`id`, `Type`.`title`, `Type`.`dir`, `Type`.`filename`, `ProductsType`.`product_id`, `ProductsType`.`type_id` FROM `types` AS `Type` JOIN `products_types` AS `ProductsType` ON (`ProductsType`.`product_id` IN (260, 261, 262, 263, 264, 265, 266, 267, 268, 269, 270, 271, 272, 273, 274, 275, 276, 277, 278, 279, 280, 281, 282, 283, 290, 291, 292, 293, 294, 295, 296, 297, 298, 299, 300, 301, 394, 412, 413, 435, 436, 439, 440, 441, 444, 539, 540, 541, 542, 543, 544, 545, 546, 547, 548, 549, 550, 551, 552, 553, 554, 555, 556, 557, 558, 559, 560, 561, 562, 563, 564, 565, 566, 567, 568, 569, 570, 571, 572, 573, 574, 575, 576, 577, 578, 579, 580, 581, 582, 583, 584, 585, 586, 587, 588, 589, 590, 591, 592, 593, 594, 595, 596, 597, 598, 599, 601, 602, 604, 605, 606, 607, 608, 609, 610, 611, 613, 754, 916, 1018, 1019, 1020, 1021, 1022, 1023, 1024, 1030, 1031, 1032, 1033, 1034, 1035, 1070, 1118, 1578, 1579, 1580) AND `ProductsType`.`type_id` = `Type`.`id`) | | 208 | 208 | 3 | |
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 `blocks` | | 3 | 3 | 1 | maybe slow |
SHOW FULL COLUMNS FROM `block_contents` | | 4 | 4 | 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` = 'after_blue_box' AND `BlockContent`.`language` = 'en' LIMIT 1 | | 1 | 1 | 1 | |
SELECT `Type`.`id`, `Type`.`title` FROM `types` AS `Type` WHERE `Type`.`language` = 'en' ORDER BY `title` ASC | | 37 | 37 | 1 | |
SHOW FULL COLUMNS FROM `company_categories` | | 3 | 3 | 1 | maybe slow |
SELECT `CompanyCategory`.`id`, `CompanyCategory`.`title` FROM `company_categories` AS `CompanyCategory` WHERE `CompanyCategory`.`language` = 'en' ORDER BY `title` ASC | | 12 | 12 | 1 | maybe slow |
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 | 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` = 'en' LIMIT 1 | | 1 | 1 | 1 | |
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 | 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` = 'en' AND `Navigation`.`key` = 'footer' AND `Link`.`language` = 'en' ORDER BY `Link`.`lft` ASC | | 8 | 8 | 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` = 'en' LIMIT 1 | | 1 | 1 | 1 | |