Query | Affected | Num. rows | Took (ms) | Actions |
---|
SELECT `Menu`.*, `ProductCategory`.`slug`, `Page`.`slug`, `BlogCategory`.`slug` FROM `chophutung_db`.`menus` AS `Menu` left JOIN `chophutung_db`.`product_categories` AS `ProductCategory` ON (`Menu`.`type` = "ProductCategory" AND `Menu`.`child` = `ProductCategory`.`id`) left JOIN `chophutung_db`.`blog_categories` AS `BlogCategory` ON (`Menu`.`type` = "BlogCategory" AND `Menu`.`child` = `BlogCategory`.`id`) left JOIN `chophutung_db`.`pages` AS `Page` ON (`Menu`.`type` = "Page" AND `Menu`.`child` = `Page`.`id`) LEFT JOIN `chophutung_db`.`menus` AS `ParentMenu` ON (`Menu`.`parent_id` = `ParentMenu`.`id`) WHERE `Menu`.`active` = '1' ORDER BY `Menu`.`order` asc | 13 | 13 | 5 | maybe slow |
SELECT `Post`.`name_vie`, `Post`.`slug`, `Post`.`footer`, `Post`.`help` FROM `chophutung_db`.`posts` AS `Post` WHERE `Post`.`active` = '1' AND `Post`.`help` = '1' ORDER BY `Post`.`order` asc, `Post`.`created` desc LIMIT 5 | 5 | 5 | 6 | maybe slow |
SELECT `Post`.`name_vie`, `Post`.`slug`, `Post`.`footer`, `Post`.`help` FROM `chophutung_db`.`posts` AS `Post` WHERE `Post`.`active` = '1' AND `Post`.`footer` = '1' ORDER BY `Post`.`order` asc, `Post`.`created` desc LIMIT 5 | 5 | 5 | 3 | maybe slow |
SELECT `Post`.`id`, `Post`.`title`, `Post`.`name_vie`, `Post`.`name_eng`, `Post`.`slug`, `Post`.`description`, `Post`.`keyword`, `Post`.`content_eng`, `Post`.`content_vie`, `Post`.`active`, `Post`.`feature`, `Post`.`left_sidebar`, `Post`.`help`, `Post`.`footer`, `Post`.`canonical`, `Post`.`views`, `Post`.`order`, `Post`.`image`, `Post`.`comment`, `Post`.`blog_category_id`, `Post`.`blog_category_id_2`, `Post`.`blog_category_id_3`, `Post`.`blog_category_id_4`, `Post`.`user_id`, `Post`.`created` FROM `chophutung_db`.`posts` AS `Post` WHERE `Post`.`active` = '1' AND `Post`.`left_sidebar` = '1' AND `Post`.`help` = '0' AND `Post`.`footer` = '0' ORDER BY `Post`.`order` asc, `Post`.`created` desc LIMIT 5 | 5 | 5 | 2 | maybe slow |
SELECT `ProductCategory`.`id`, `ProductCategory`.`name_eng`, `ProductCategory`.`title`, `ProductCategory`.`name_vie`, `ProductCategory`.`slug`, `ProductCategory`.`description`, `ProductCategory`.`keyword`, `ProductCategory`.`introduction_eng`, `ProductCategory`.`introduction_vie`, `ProductCategory`.`active`, `ProductCategory`.`home_page`, `ProductCategory`.`order`, `ProductCategory`.`image`, `ProductCategory`.`image_home`, `ProductCategory`.`image_icon`, `ProductCategory`.`parent_id`, `ProductCategory`.`parent_id_2`, `ProductCategory`.`parent_id_3`, `ProductCategory`.`property_category_id`, `ProductCategory`.`rght`, `ProductCategory`.`lft`, `ProductCategory`.`created`, (SELECT COUNT(*) FROM product_categories WHERE `product_categories`.`parent_id` = `ProductCategory`.`id`) AS `ProductCategory__have_sub`, (SELECT COUNT(*) FROM product_categories WHERE `product_categories`.`parent_id` IN (SELECT id FROM product_categories WHERE `product_categories`.`parent_id` = `ProductCategory`.`id`)) AS `ProductCategory__have_sub_2`, (SELECT COUNT(*) FROM products WHERE `products`.`product_category_id` IN (SELECT id FROM product_categories WHERE `product_categories`.`parent_id` IN (SELECT id FROM product_categories WHERE `product_categories`.`parent_id` = `ProductCategory`.`id`)) OR `products`.`product_category_id` IN (SELECT id FROM product_categories WHERE `product_categories`.`parent_id` = `ProductCategory`.`id`) OR `products`.`product_category_id` = `ProductCategory`.`id`) AS `ProductCategory__count_products` FROM `chophutung_db`.`product_categories` AS `ProductCategory` WHERE `active` = '1' ORDER BY `order` asc | 68 | 68 | 775 | maybe slow |
SELECT `Banner`.`id`, `Banner`.`image`, `Banner`.`title`, `Banner`.`caption`, `Banner`.`button_text`, `Banner`.`small_caption`, `Banner`.`url`, `Banner`.`type`, `Banner`.`order`, `Banner`.`active`, `Banner`.`created` FROM `chophutung_db`.`banners` AS `Banner` WHERE `Banner`.`active` = '1' AND `Banner`.`type` = 3 ORDER BY `order` asc, `created` desc LIMIT 4294967295 | 10 | 10 | 1 | maybe slow |
SELECT `Banner`.`id`, `Banner`.`image`, `Banner`.`title`, `Banner`.`caption`, `Banner`.`button_text`, `Banner`.`small_caption`, `Banner`.`url`, `Banner`.`type`, `Banner`.`order`, `Banner`.`active`, `Banner`.`created` FROM `chophutung_db`.`banners` AS `Banner` WHERE `Banner`.`active` = '1' AND `Banner`.`type` = 2 ORDER BY `order` asc, `created` desc LIMIT 4294967295 | 2 | 2 | 0 | |
SELECT `Support`.`id`, `Support`.`nick_name`, `Support`.`name`, `Support`.`phone`, `Support`.`active`, `Support`.`type`, `Support`.`created` FROM `chophutung_db`.`supports` AS `Support` WHERE `active` = '1' ORDER BY `type` desc | 0 | 0 | 0 | |
SELECT `Manufacture`.`id`, `Manufacture`.`name`, `Manufacture`.`title`, `Manufacture`.`slug`, `Manufacture`.`active`, `Manufacture`.`order`, `Manufacture`.`content`, `Manufacture`.`description`, `Manufacture`.`keyword`, `Manufacture`.`parent_id`, `Manufacture`.`tag_id`, `Manufacture`.`rght`, `Manufacture`.`lft`, `Manufacture`.`created` FROM `chophutung_db`.`manufactures` AS `Manufacture` WHERE `slug` = 'hd-county' LIMIT 1 | 1 | 1 | 4 | maybe slow |
SELECT `Product`.`id`, `Product`.`rate`, `Product`.`count_rate`, `Product`.`name_vie`, `Product`.`slug`, `Product`.`price`, `Product`.`price_sale`, `Product`.`created`, `Product`.`image`, `Product`.`image_default`, `Product`.`product_category_id`, `Product`.`content_vie` FROM `chophutung_db`.`products` AS `Product` WHERE `Product`.`active` = '1' AND ((`Product`.`manufacture_id` = 70) OR (`Product`.`manufacture_id_2` = 70)) ORDER BY `order` asc, `created` desc LIMIT 16 | 3 | 3 | 27 | maybe slow |
SELECT COUNT(*) AS `count` FROM `chophutung_db`.`products` AS `Product` WHERE `Product`.`active` = '1' AND ((`Product`.`manufacture_id` = 70) OR (`Product`.`manufacture_id_2` = 70)) | 1 | 1 | 7 | maybe slow |
SELECT `Manufacture`.`id`, `Manufacture`.`name`, `Manufacture`.`slug` FROM `chophutung_db`.`manufactures` AS `Manufacture` WHERE `active` = '1' AND `parent_id` = 70 ORDER BY `order` asc | 0 | 0 | 3 | maybe slow |