| Query | Affected | Num. rows | Took (ms) | Actions |
|---|
| SELECT COUNT(*) AS `count` FROM `karajhoo_db`.`categories` AS `Category` WHERE `Category`.`id` = 38 | 1 | 1 | 1 | |
| SELECT attribute_id, name, COUNT(DISTINCT value)-1 AS values_count, GROUP_CONCAT(DISTINCT products_attributes.`value` ORDER BY `value` SEPARATOR '|') AS `values`
FROM `products_categories`
LEFT JOIN products_attributes
ON products_categories.product_id=products_attributes.product_id
LEFT JOIN attributes
ON products_attributes.attribute_id=attributes.id
WHERE category_id=38 AND attribute_id IS NOT NULL
GROUP BY attribute_id
HAVING values_count>1 AND values_count<=100
ORDER BY sortorder ASC | 5 | 5 | 149 | maybe slow |
| SELECT `Category`.`id`, `Category`.`name`, `Category`.`url`, `Category`.`page_title`, `Category`.`article_title`, `Category`.`parent_id`, `Category`.`image`, `Category`.`homerollover`, `Category`.`description` FROM `karajhoo_db`.`categories` AS `Category` WHERE `Category`.`id` = 38 LIMIT 1 | 1 | 1 | 1 | |
| SELECT `Product`.`id`, `Product`.`model`, `Product`.`url`, `Product`.`page_title`, `Product`.`article_title`, `Product`.`oldprice`, `Product`.`newprice`, `Product`.`pricebase`, `Product`.`pricechangetype`, `Product`.`pricechangeamount`, `Product`.`quantity`, `Product`.`shipping`, `Product`.`manufacture_id`, `Product`.`sortorder`, `Product`.`availabletodate`, `Product`.`length`, `Product`.`width`, `Product`.`height`, `Product`.`weight`, `Product`.`points`, `Product`.`body`, `Product`.`visitcount`, `Product`.`buycount`, `Product`.`description`, `Product`.`newproduct`, `Product`.`popularproduct`, `Product`.`specialproduct`, `ProductsCategory`.`id`, `ProductsCategory`.`product_id`, `ProductsCategory`.`category_id` FROM `karajhoo_db`.`products` AS `Product` JOIN `karajhoo_db`.`products_categories` AS `ProductsCategory` ON (`ProductsCategory`.`category_id` = 38 AND `ProductsCategory`.`product_id` = `Product`.`id`) ORDER BY `Product`.`quantity`>0 DESC, `Product`.`visitcount` DESC, `Product`.`buycount` DESC, `Product`.`id` DESC LIMIT 20 | 20 | 20 | 12 | maybe slow |
| SELECT `Image`.`id`, `Image`.`name`, `ProductsImage`.`id`, `ProductsImage`.`product_id`, `ProductsImage`.`image_id` FROM `karajhoo_db`.`images` AS `Image` JOIN `karajhoo_db`.`products_images` AS `ProductsImage` ON (`ProductsImage`.`product_id` IN (1762, 1766, 1781, 1764, 1782, 1776, 1763, 1780, 1778, 1779, 1775, 1771, 1770, 1769, 1765, 1777, 1768, 1773, 1774, 1772) AND `ProductsImage`.`image_id` = `Image`.`id`) | 20 | 20 | 2 | maybe slow |
| SELECT COUNT(*) AS `count` FROM `karajhoo_db`.`products` AS `Product` LEFT JOIN `karajhoo_db`.`manufactures` AS `Manufacture` ON (`Product`.`manufacture_id` = `Manufacture`.`id`) LEFT JOIN `products_categories` `ProductsCategory` ON `ProductsCategory`.`product_id`=`Product`.`id` WHERE `ProductsCategory`.`category_id` = 38 | 1 | 1 | 3 | maybe slow |
| SELECT `Category`.`id`, `Category`.`name`, `Category`.`url`, `Category`.`page_title`, `Category`.`article_title`, `Category`.`parent_id`, `Category`.`image`, `Category`.`homerollover`, `Category`.`description` FROM `karajhoo_db`.`categories` AS `Category` WHERE 1 = 1 | 43 | 43 | 1 | |
