| Query | Affected | Num. rows | Took (ms) | Actions |
|---|
| SELECT COUNT(*) AS `count` FROM `karajhoo_db`.`categories` AS `Category` WHERE `Category`.`id` = 43 | 1 | 1 | 0 | |
| 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=43 AND attribute_id IS NOT NULL
GROUP BY attribute_id
HAVING values_count>1 AND values_count<=100
ORDER BY sortorder ASC | 4 | 4 | 114 | 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` = 43 LIMIT 1 | 1 | 1 | 0 | |
| 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` = 43 AND `ProductsCategory`.`product_id` = `Product`.`id`) ORDER BY `Product`.`quantity`>0 DESC, `Product`.`visitcount` DESC, `Product`.`buycount` DESC, `Product`.`id` DESC LIMIT 20 | 13 | 13 | 3 | 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 (1793, 1792, 1790, 1783, 1795, 1794, 1791, 1785, 1788, 1787, 1786, 1789, 1784) AND `ProductsImage`.`image_id` = `Image`.`id`) | 13 | 13 | 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` = 43 | 1 | 1 | 2 | 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 | |
