Query | Affected | Num. rows | Took (ms) | Actions |
---|
SELECT `Setting`.* FROM `maydocd_v2020`.`setting` AS `Setting` WHERE 1 = 1 LIMIT 1 | 1 | 1 | 0 | |
SELECT `Company`.* FROM `maydocd_v2020`.`company` AS `Company` WHERE 1 = 1 LIMIT 1 | 1 | 1 | 0 | |
SELECT `Translate`.`key`, `Translate`.`value_vie` FROM `maydocd_v2020`.`translates` AS `Translate` WHERE 1 = 1 | 159 | 159 | 0 | |
SELECT `Menu`.*, `BlogCategory`.`slug`, `Page`.`slug` FROM `maydocd_v2020`.`menus` AS `Menu` LEFT JOIN `maydocd_v2020`.`menus` AS `ParentMenu` ON (`Menu`.`parent_id` = `ParentMenu`.`id`) left JOIN `maydocd_v2020`.`blog_categories` AS `BlogCategory` ON (`Menu`.`type` = "BlogCategory" AND `Menu`.`child` = `BlogCategory`.`id`) left JOIN `maydocd_v2020`.`pages` AS `Page` ON (`Menu`.`type` = "Page" AND `Menu`.`child` = `Page`.`id`) WHERE `Menu`.`active` = '1' ORDER BY `Menu`.`order` asc | 4 | 4 | 0 | |
SELECT `ProductCategory`.`id`, `ProductCategory`.`name_vie`, `ProductCategory`.`slug`, `ProductCategory`.`parent_id`, `ProductCategory`.`parent_id_2`, `ProductCategory`.`menu`, `ProductCategory`.`parentSlug`, `ProductCategory`.`baseSlug`, `ProductCategory`.`label`, `ProductCategory`.`old_link`, `ProductCategory`.`col_menu`, `Parent`.`slug`, (SELECT COUNT(id) FROM product_categories WHERE `product_categories`.`parent_id` = `ProductCategory`.`id` AND `product_categories`.`active`=1) AS `ProductCategory__has_sub_level_2` FROM `maydocd_v2020`.`product_categories` AS `ProductCategory` LEFT JOIN `maydocd_v2020`.`product_categories` AS `Parent` ON (`ProductCategory`.`parent_id` = `Parent`.`id`) LEFT JOIN `maydocd_v2020`.`product_categories` AS `Parent2` ON (`ProductCategory`.`parent_id_2` = `Parent2`.`id`) WHERE `ProductCategory`.`active` = '1' AND `ProductCategory`.`menu` = '1' AND ((`ProductCategory`.`parent_id_3` IS NULL) OR (`ProductCategory`.`parent_id_3` = 0)) ORDER BY `ProductCategory`.`order` asc | 257 | 257 | 8 | |
SELECT `Page`.`id`, `Page`.`name_vie`, `Page`.`slug` FROM `maydocd_v2020`.`pages` AS `Page` WHERE `active` = '1' AND `footer` = '1' AND `type` = 1 ORDER BY `order` ASC, `created` desc LIMIT 15 | 5 | 5 | 0 | |
SELECT `Page`.`id`, `Page`.`name_vie`, `Page`.`slug` FROM `maydocd_v2020`.`pages` AS `Page` WHERE `active` = '1' AND `footer` = '1' AND `type` = 2 ORDER BY `order` ASC, `created` desc LIMIT 15 | 4 | 4 | 0 | |
SELECT `Post`.`id`, `Post`.`name_vie`, `Post`.`slug`, `Post`.`image`, `Post`.`old_link`, `Post`.`type_link`, `BlogCategory`.`name_vie`, `BlogCategory`.`slug` FROM `maydocd_v2020`.`posts` AS `Post` LEFT JOIN `maydocd_v2020`.`blog_categories` AS `BlogCategory` ON (`Post`.`blog_category_id` = `BlogCategory`.`id`) LEFT JOIN `maydocd_v2020`.`users` AS `User` ON (`Post`.`user_id` = `User`.`id`) WHERE `Post`.`active` = '1' AND `Post`.`video` = '1' ORDER BY `Post`.`order` ASC, `Post`.`created` desc LIMIT 5 | 5 | 5 | 17 | maybe slow |
SELECT `Banner`.`image`, `Banner`.`title_vie`, `Banner`.`url`, `Banner`.`type` FROM `maydocd_v2020`.`banners` AS `Banner` WHERE `type` = 1 AND `active` = '1' ORDER BY `order` asc, `id` desc LIMIT 1 | 0 | 0 | 0 | |
SELECT `Area`.`id`, `Area`.`name`, `Area`.`description`, `Area`.`phone`, `Area`.`active`, `Area`.`order`, `Area`.`created`, `Area`.`modified` FROM `maydocd_v2020`.`store_area` AS `Area` WHERE `active` = '1' ORDER BY `order` asc, `id` desc | 2 | 2 | 0 | |
SELECT `Store`.`id`, `Store`.`name`, `Store`.`address`, `Store`.`area_id`, `Store`.`tels`, `Store`.`zalos`, `Store`.`mails`, `Store`.`description`, `Store`.`active`, `Store`.`order`, `Store`.`created`, `Store`.`modified` FROM `maydocd_v2020`.`stores` AS `Store` WHERE `active` = '1' ORDER BY `id` desc | 2 | 2 | 0 | |
SELECT `Post`.`id`, `Post`.`slug`, `Post`.`image`, `Post`.`name_vie`, `Post`.`created`, `Post`.`content_vie`, `Post`.`type_link`, `Post`.`old_link`, `BlogCategory`.`slug` FROM `maydocd_v2020`.`posts` AS `Post` LEFT JOIN `maydocd_v2020`.`blog_categories` AS `BlogCategory` ON (`Post`.`blog_category_id` = `BlogCategory`.`id`) LEFT JOIN `maydocd_v2020`.`users` AS `User` ON (`Post`.`user_id` = `User`.`id`) WHERE `Post`.`active` = '1' ORDER BY `Post`.`feature` desc, `Post`.`created` desc LIMIT 6 | 6 | 6 | 17 | maybe slow |
SELECT `Material`.`id`, `Material`.`image`, `Material`.`content_vie`, `Material`.`content_eng`, `Material`.`title`, `Material`.`name_vie`, `Material`.`name_eng`, `Material`.`slug`, `Material`.`home`, `Material`.`description`, `Material`.`keyword`, `Material`.`canonical`, `Material`.`product_category_id`, `Material`.`order`, `Material`.`created` FROM `maydocd_v2020`.`materials` AS `Material` WHERE `home` = 1 ORDER BY `order` asc | 49 | 49 | 1 | |
SELECT `Banner`.`image`, `Banner`.`title_vie`, `Banner`.`url`, `Banner`.`type` FROM `maydocd_v2020`.`banners` AS `Banner` WHERE `type` = 2 AND `active` = '1' ORDER BY `order` asc, `id` desc LIMIT 5 | 5 | 5 | 0 | |
SELECT `Banner`.`image`, `Banner`.`title_vie`, `Banner`.`url`, `Banner`.`type` FROM `maydocd_v2020`.`banners` AS `Banner` WHERE `type` = 3 AND `active` = '1' ORDER BY `order` asc, `id` desc LIMIT 3 | 3 | 3 | 0 | |
SELECT `ProductCategory`.`id`, `ProductCategory`.`name_vie`, `ProductCategory`.`slug`, `ProductCategory`.`old_link`, `ProductCategory`.`parentSlug`, `ProductCategory`.`baseSlug`, `ProductCategory`.`label`, `Parent`.`slug` FROM `maydocd_v2020`.`product_categories` AS `ProductCategory` LEFT JOIN `maydocd_v2020`.`product_categories` AS `Parent` ON (`ProductCategory`.`parent_id` = `Parent`.`id`) LEFT JOIN `maydocd_v2020`.`product_categories` AS `Parent2` ON (`ProductCategory`.`parent_id_2` = `Parent2`.`id`) WHERE `ProductCategory`.`active` = '1' AND `ProductCategory`.`home` = '1' ORDER BY `ProductCategory`.`feature` desc, `ProductCategory`.`order` asc | 13 | 13 | 1 | maybe slow |
SELECT `Product`.`id`, `Product`.`prices`, `Product`.`price`, `Product`.`name_vie`, `Product`.`slug`, `Product`.`type_link`, `Product`.`code`, `Product`.`image`, `Product`.`properties`, `Product`.`price_sale`, `Product`.`status`, `Product`.`old_link`, `ProductCategory`.`slug`, `ProductCategory2`.`slug`, `ProductCategory3`.`slug`, `ProductCategory`.`baseSlug`, `ProductCategory`.`baseSlugDetail`, `ProductCategory2`.`baseSlugDetail`, `ProductCategory3`.`baseSlugDetail`, `ProductCategory`.`label`, `ProductCategory2`.`label`, `ProductCategory3`.`label`, `Material`.`image`, `Material`.`id`, `Material`.`name_vie`, `Material`.`slug`, (SELECT SUM(rate) FROM product_reviews WHERE `product_reviews`.`product_id` = `Product`.`id`) AS `Product__sum_review`, (SELECT count(id) FROM product_reviews WHERE `product_reviews`.`product_id` = `Product`.`id`) AS `Product__count_review` FROM `maydocd_v2020`.`products` AS `Product` LEFT JOIN `maydocd_v2020`.`materials` AS `Material` ON (`Product`.`material_id` = `Material`.`id`) LEFT JOIN `maydocd_v2020`.`product_categories` AS `ProductCategory` ON (`Product`.`product_category_id` = `ProductCategory`.`id`) LEFT JOIN `maydocd_v2020`.`product_categories` AS `ProductCategory2` ON (`Product`.`product_category_id_2` = `ProductCategory2`.`id`) LEFT JOIN `maydocd_v2020`.`product_categories` AS `ProductCategory3` ON (`Product`.`product_category_id_3` = `ProductCategory3`.`id`) WHERE `Product`.`active` = '1' AND `Product`.`home` = '1' AND ((`Product`.`product_category_id` = 2) OR (`Product`.`product_category_id_2` = 2) OR (`Product`.`product_category_id_3` = 2)) ORDER BY `Product`.`not_feature` asc, RAND() ASC LIMIT 10 | 10 | 10 | 7 | maybe slow |
SELECT `ProductCategory`.`id`, `ProductCategory`.`name_vie`, `ProductCategory`.`slug`, `ProductCategory`.`icon`, `ProductCategory`.`image`, `ProductCategory`.`parentSlug`, `ProductCategory`.`baseSlug`, `ProductCategory`.`label`, `Parent`.`slug`, `ProductCategory`.`old_link` FROM `maydocd_v2020`.`product_categories` AS `ProductCategory` LEFT JOIN `maydocd_v2020`.`product_categories` AS `Parent` ON (`ProductCategory`.`parent_id` = `Parent`.`id`) LEFT JOIN `maydocd_v2020`.`product_categories` AS `Parent2` ON (`ProductCategory`.`parent_id_2` = `Parent2`.`id`) WHERE `ProductCategory`.`active` = '1' AND `ProductCategory`.`feature` = '1' AND `ProductCategory`.`parent_id` = 2 ORDER BY `ProductCategory`.`feature` desc, `ProductCategory`.`order` asc | 4 | 4 | 1 | maybe slow |
SELECT `Product`.`id`, `Product`.`prices`, `Product`.`price`, `Product`.`name_vie`, `Product`.`slug`, `Product`.`type_link`, `Product`.`code`, `Product`.`image`, `Product`.`properties`, `Product`.`price_sale`, `Product`.`status`, `Product`.`old_link`, `ProductCategory`.`slug`, `ProductCategory2`.`slug`, `ProductCategory3`.`slug`, `ProductCategory`.`baseSlug`, `ProductCategory`.`baseSlugDetail`, `ProductCategory2`.`baseSlugDetail`, `ProductCategory3`.`baseSlugDetail`, `ProductCategory`.`label`, `ProductCategory2`.`label`, `ProductCategory3`.`label`, `Material`.`image`, `Material`.`id`, `Material`.`name_vie`, `Material`.`slug`, (SELECT SUM(rate) FROM product_reviews WHERE `product_reviews`.`product_id` = `Product`.`id`) AS `Product__sum_review`, (SELECT count(id) FROM product_reviews WHERE `product_reviews`.`product_id` = `Product`.`id`) AS `Product__count_review` FROM `maydocd_v2020`.`products` AS `Product` LEFT JOIN `maydocd_v2020`.`materials` AS `Material` ON (`Product`.`material_id` = `Material`.`id`) LEFT JOIN `maydocd_v2020`.`product_categories` AS `ProductCategory` ON (`Product`.`product_category_id` = `ProductCategory`.`id`) LEFT JOIN `maydocd_v2020`.`product_categories` AS `ProductCategory2` ON (`Product`.`product_category_id_2` = `ProductCategory2`.`id`) LEFT JOIN `maydocd_v2020`.`product_categories` AS `ProductCategory3` ON (`Product`.`product_category_id_3` = `ProductCategory3`.`id`) WHERE `Product`.`active` = '1' AND `Product`.`home` = '1' AND ((`Product`.`product_category_id` = 1) OR (`Product`.`product_category_id_2` = 1) OR (`Product`.`product_category_id_3` = 1)) ORDER BY `Product`.`not_feature` asc, RAND() ASC LIMIT 10 | 10 | 10 | 18 | maybe slow |
SELECT `ProductCategory`.`id`, `ProductCategory`.`name_vie`, `ProductCategory`.`slug`, `ProductCategory`.`icon`, `ProductCategory`.`image`, `ProductCategory`.`parentSlug`, `ProductCategory`.`baseSlug`, `ProductCategory`.`label`, `Parent`.`slug`, `ProductCategory`.`old_link` FROM `maydocd_v2020`.`product_categories` AS `ProductCategory` LEFT JOIN `maydocd_v2020`.`product_categories` AS `Parent` ON (`ProductCategory`.`parent_id` = `Parent`.`id`) LEFT JOIN `maydocd_v2020`.`product_categories` AS `Parent2` ON (`ProductCategory`.`parent_id_2` = `Parent2`.`id`) WHERE `ProductCategory`.`active` = '1' AND `ProductCategory`.`feature` = '1' AND `ProductCategory`.`parent_id` = 1 ORDER BY `ProductCategory`.`feature` desc, `ProductCategory`.`order` asc | 5 | 5 | 1 | maybe slow |
SELECT `Product`.`id`, `Product`.`prices`, `Product`.`price`, `Product`.`name_vie`, `Product`.`slug`, `Product`.`type_link`, `Product`.`code`, `Product`.`image`, `Product`.`properties`, `Product`.`price_sale`, `Product`.`status`, `Product`.`old_link`, `ProductCategory`.`slug`, `ProductCategory2`.`slug`, `ProductCategory3`.`slug`, `ProductCategory`.`baseSlug`, `ProductCategory`.`baseSlugDetail`, `ProductCategory2`.`baseSlugDetail`, `ProductCategory3`.`baseSlugDetail`, `ProductCategory`.`label`, `ProductCategory2`.`label`, `ProductCategory3`.`label`, `Material`.`image`, `Material`.`id`, `Material`.`name_vie`, `Material`.`slug`, (SELECT SUM(rate) FROM product_reviews WHERE `product_reviews`.`product_id` = `Product`.`id`) AS `Product__sum_review`, (SELECT count(id) FROM product_reviews WHERE `product_reviews`.`product_id` = `Product`.`id`) AS `Product__count_review` FROM `maydocd_v2020`.`products` AS `Product` LEFT JOIN `maydocd_v2020`.`materials` AS `Material` ON (`Product`.`material_id` = `Material`.`id`) LEFT JOIN `maydocd_v2020`.`product_categories` AS `ProductCategory` ON (`Product`.`product_category_id` = `ProductCategory`.`id`) LEFT JOIN `maydocd_v2020`.`product_categories` AS `ProductCategory2` ON (`Product`.`product_category_id_2` = `ProductCategory2`.`id`) LEFT JOIN `maydocd_v2020`.`product_categories` AS `ProductCategory3` ON (`Product`.`product_category_id_3` = `ProductCategory3`.`id`) WHERE `Product`.`active` = '1' AND `Product`.`home` = '1' AND ((`Product`.`product_category_id` = 87) OR (`Product`.`product_category_id_2` = 87) OR (`Product`.`product_category_id_3` = 87)) ORDER BY `Product`.`not_feature` asc, RAND() ASC LIMIT 10 | 10 | 10 | 5 | maybe slow |
SELECT `ProductCategory`.`id`, `ProductCategory`.`name_vie`, `ProductCategory`.`slug`, `ProductCategory`.`icon`, `ProductCategory`.`image`, `ProductCategory`.`parentSlug`, `ProductCategory`.`baseSlug`, `ProductCategory`.`label`, `Parent`.`slug`, `ProductCategory`.`old_link` FROM `maydocd_v2020`.`product_categories` AS `ProductCategory` LEFT JOIN `maydocd_v2020`.`product_categories` AS `Parent` ON (`ProductCategory`.`parent_id` = `Parent`.`id`) LEFT JOIN `maydocd_v2020`.`product_categories` AS `Parent2` ON (`ProductCategory`.`parent_id_2` = `Parent2`.`id`) WHERE `ProductCategory`.`active` = '1' AND `ProductCategory`.`feature` = '1' AND `ProductCategory`.`parent_id` = 87 ORDER BY `ProductCategory`.`feature` desc, `ProductCategory`.`order` asc | 5 | 5 | 0 | |
SELECT `Product`.`id`, `Product`.`prices`, `Product`.`price`, `Product`.`name_vie`, `Product`.`slug`, `Product`.`type_link`, `Product`.`code`, `Product`.`image`, `Product`.`properties`, `Product`.`price_sale`, `Product`.`status`, `Product`.`old_link`, `ProductCategory`.`slug`, `ProductCategory2`.`slug`, `ProductCategory3`.`slug`, `ProductCategory`.`baseSlug`, `ProductCategory`.`baseSlugDetail`, `ProductCategory2`.`baseSlugDetail`, `ProductCategory3`.`baseSlugDetail`, `ProductCategory`.`label`, `ProductCategory2`.`label`, `ProductCategory3`.`label`, `Material`.`image`, `Material`.`id`, `Material`.`name_vie`, `Material`.`slug`, (SELECT SUM(rate) FROM product_reviews WHERE `product_reviews`.`product_id` = `Product`.`id`) AS `Product__sum_review`, (SELECT count(id) FROM product_reviews WHERE `product_reviews`.`product_id` = `Product`.`id`) AS `Product__count_review` FROM `maydocd_v2020`.`products` AS `Product` LEFT JOIN `maydocd_v2020`.`materials` AS `Material` ON (`Product`.`material_id` = `Material`.`id`) LEFT JOIN `maydocd_v2020`.`product_categories` AS `ProductCategory` ON (`Product`.`product_category_id` = `ProductCategory`.`id`) LEFT JOIN `maydocd_v2020`.`product_categories` AS `ProductCategory2` ON (`Product`.`product_category_id_2` = `ProductCategory2`.`id`) LEFT JOIN `maydocd_v2020`.`product_categories` AS `ProductCategory3` ON (`Product`.`product_category_id_3` = `ProductCategory3`.`id`) WHERE `Product`.`active` = '1' AND `Product`.`home` = '1' AND ((`Product`.`product_category_id` = 100) OR (`Product`.`product_category_id_2` = 100) OR (`Product`.`product_category_id_3` = 100)) ORDER BY `Product`.`not_feature` asc, RAND() ASC LIMIT 10 | 10 | 10 | 5 | maybe slow |
SELECT `ProductCategory`.`id`, `ProductCategory`.`name_vie`, `ProductCategory`.`slug`, `ProductCategory`.`icon`, `ProductCategory`.`image`, `ProductCategory`.`parentSlug`, `ProductCategory`.`baseSlug`, `ProductCategory`.`label`, `Parent`.`slug`, `ProductCategory`.`old_link` FROM `maydocd_v2020`.`product_categories` AS `ProductCategory` LEFT JOIN `maydocd_v2020`.`product_categories` AS `Parent` ON (`ProductCategory`.`parent_id` = `Parent`.`id`) LEFT JOIN `maydocd_v2020`.`product_categories` AS `Parent2` ON (`ProductCategory`.`parent_id_2` = `Parent2`.`id`) WHERE `ProductCategory`.`active` = '1' AND `ProductCategory`.`feature` = '1' AND `ProductCategory`.`parent_id` = 100 ORDER BY `ProductCategory`.`feature` desc, `ProductCategory`.`order` asc | 4 | 4 | 0 | |
SELECT `Product`.`id`, `Product`.`prices`, `Product`.`price`, `Product`.`name_vie`, `Product`.`slug`, `Product`.`type_link`, `Product`.`code`, `Product`.`image`, `Product`.`properties`, `Product`.`price_sale`, `Product`.`status`, `Product`.`old_link`, `ProductCategory`.`slug`, `ProductCategory2`.`slug`, `ProductCategory3`.`slug`, `ProductCategory`.`baseSlug`, `ProductCategory`.`baseSlugDetail`, `ProductCategory2`.`baseSlugDetail`, `ProductCategory3`.`baseSlugDetail`, `ProductCategory`.`label`, `ProductCategory2`.`label`, `ProductCategory3`.`label`, `Material`.`image`, `Material`.`id`, `Material`.`name_vie`, `Material`.`slug`, (SELECT SUM(rate) FROM product_reviews WHERE `product_reviews`.`product_id` = `Product`.`id`) AS `Product__sum_review`, (SELECT count(id) FROM product_reviews WHERE `product_reviews`.`product_id` = `Product`.`id`) AS `Product__count_review` FROM `maydocd_v2020`.`products` AS `Product` LEFT JOIN `maydocd_v2020`.`materials` AS `Material` ON (`Product`.`material_id` = `Material`.`id`) LEFT JOIN `maydocd_v2020`.`product_categories` AS `ProductCategory` ON (`Product`.`product_category_id` = `ProductCategory`.`id`) LEFT JOIN `maydocd_v2020`.`product_categories` AS `ProductCategory2` ON (`Product`.`product_category_id_2` = `ProductCategory2`.`id`) LEFT JOIN `maydocd_v2020`.`product_categories` AS `ProductCategory3` ON (`Product`.`product_category_id_3` = `ProductCategory3`.`id`) WHERE `Product`.`active` = '1' AND `Product`.`home` = '1' AND ((`Product`.`product_category_id` = 101) OR (`Product`.`product_category_id_2` = 101) OR (`Product`.`product_category_id_3` = 101)) ORDER BY `Product`.`not_feature` asc, RAND() ASC LIMIT 10 | 10 | 10 | 7 | maybe slow |
SELECT `ProductCategory`.`id`, `ProductCategory`.`name_vie`, `ProductCategory`.`slug`, `ProductCategory`.`icon`, `ProductCategory`.`image`, `ProductCategory`.`parentSlug`, `ProductCategory`.`baseSlug`, `ProductCategory`.`label`, `Parent`.`slug`, `ProductCategory`.`old_link` FROM `maydocd_v2020`.`product_categories` AS `ProductCategory` LEFT JOIN `maydocd_v2020`.`product_categories` AS `Parent` ON (`ProductCategory`.`parent_id` = `Parent`.`id`) LEFT JOIN `maydocd_v2020`.`product_categories` AS `Parent2` ON (`ProductCategory`.`parent_id_2` = `Parent2`.`id`) WHERE `ProductCategory`.`active` = '1' AND `ProductCategory`.`feature` = '1' AND `ProductCategory`.`parent_id` = 101 ORDER BY `ProductCategory`.`feature` desc, `ProductCategory`.`order` asc | 7 | 7 | 0 | |
SELECT `Product`.`id`, `Product`.`prices`, `Product`.`price`, `Product`.`name_vie`, `Product`.`slug`, `Product`.`type_link`, `Product`.`code`, `Product`.`image`, `Product`.`properties`, `Product`.`price_sale`, `Product`.`status`, `Product`.`old_link`, `ProductCategory`.`slug`, `ProductCategory2`.`slug`, `ProductCategory3`.`slug`, `ProductCategory`.`baseSlug`, `ProductCategory`.`baseSlugDetail`, `ProductCategory2`.`baseSlugDetail`, `ProductCategory3`.`baseSlugDetail`, `ProductCategory`.`label`, `ProductCategory2`.`label`, `ProductCategory3`.`label`, `Material`.`image`, `Material`.`id`, `Material`.`name_vie`, `Material`.`slug`, (SELECT SUM(rate) FROM product_reviews WHERE `product_reviews`.`product_id` = `Product`.`id`) AS `Product__sum_review`, (SELECT count(id) FROM product_reviews WHERE `product_reviews`.`product_id` = `Product`.`id`) AS `Product__count_review` FROM `maydocd_v2020`.`products` AS `Product` LEFT JOIN `maydocd_v2020`.`materials` AS `Material` ON (`Product`.`material_id` = `Material`.`id`) LEFT JOIN `maydocd_v2020`.`product_categories` AS `ProductCategory` ON (`Product`.`product_category_id` = `ProductCategory`.`id`) LEFT JOIN `maydocd_v2020`.`product_categories` AS `ProductCategory2` ON (`Product`.`product_category_id_2` = `ProductCategory2`.`id`) LEFT JOIN `maydocd_v2020`.`product_categories` AS `ProductCategory3` ON (`Product`.`product_category_id_3` = `ProductCategory3`.`id`) WHERE `Product`.`active` = '1' AND `Product`.`home` = '1' AND ((`Product`.`product_category_id` = 102) OR (`Product`.`product_category_id_2` = 102) OR (`Product`.`product_category_id_3` = 102)) ORDER BY `Product`.`not_feature` asc, RAND() ASC LIMIT 10 | 10 | 10 | 8 | maybe slow |
SELECT `ProductCategory`.`id`, `ProductCategory`.`name_vie`, `ProductCategory`.`slug`, `ProductCategory`.`icon`, `ProductCategory`.`image`, `ProductCategory`.`parentSlug`, `ProductCategory`.`baseSlug`, `ProductCategory`.`label`, `Parent`.`slug`, `ProductCategory`.`old_link` FROM `maydocd_v2020`.`product_categories` AS `ProductCategory` LEFT JOIN `maydocd_v2020`.`product_categories` AS `Parent` ON (`ProductCategory`.`parent_id` = `Parent`.`id`) LEFT JOIN `maydocd_v2020`.`product_categories` AS `Parent2` ON (`ProductCategory`.`parent_id_2` = `Parent2`.`id`) WHERE `ProductCategory`.`active` = '1' AND `ProductCategory`.`feature` = '1' AND `ProductCategory`.`parent_id` = 102 ORDER BY `ProductCategory`.`feature` desc, `ProductCategory`.`order` asc | 4 | 4 | 0 | |
SELECT `Product`.`id`, `Product`.`prices`, `Product`.`price`, `Product`.`name_vie`, `Product`.`slug`, `Product`.`type_link`, `Product`.`code`, `Product`.`image`, `Product`.`properties`, `Product`.`price_sale`, `Product`.`status`, `Product`.`old_link`, `ProductCategory`.`slug`, `ProductCategory2`.`slug`, `ProductCategory3`.`slug`, `ProductCategory`.`baseSlug`, `ProductCategory`.`baseSlugDetail`, `ProductCategory2`.`baseSlugDetail`, `ProductCategory3`.`baseSlugDetail`, `ProductCategory`.`label`, `ProductCategory2`.`label`, `ProductCategory3`.`label`, `Material`.`image`, `Material`.`id`, `Material`.`name_vie`, `Material`.`slug`, (SELECT SUM(rate) FROM product_reviews WHERE `product_reviews`.`product_id` = `Product`.`id`) AS `Product__sum_review`, (SELECT count(id) FROM product_reviews WHERE `product_reviews`.`product_id` = `Product`.`id`) AS `Product__count_review` FROM `maydocd_v2020`.`products` AS `Product` LEFT JOIN `maydocd_v2020`.`materials` AS `Material` ON (`Product`.`material_id` = `Material`.`id`) LEFT JOIN `maydocd_v2020`.`product_categories` AS `ProductCategory` ON (`Product`.`product_category_id` = `ProductCategory`.`id`) LEFT JOIN `maydocd_v2020`.`product_categories` AS `ProductCategory2` ON (`Product`.`product_category_id_2` = `ProductCategory2`.`id`) LEFT JOIN `maydocd_v2020`.`product_categories` AS `ProductCategory3` ON (`Product`.`product_category_id_3` = `ProductCategory3`.`id`) WHERE `Product`.`active` = '1' AND `Product`.`home` = '1' AND ((`Product`.`product_category_id` = 120) OR (`Product`.`product_category_id_2` = 120) OR (`Product`.`product_category_id_3` = 120)) ORDER BY `Product`.`not_feature` asc, RAND() ASC LIMIT 10 | 10 | 10 | 6 | maybe slow |
SELECT `ProductCategory`.`id`, `ProductCategory`.`name_vie`, `ProductCategory`.`slug`, `ProductCategory`.`icon`, `ProductCategory`.`image`, `ProductCategory`.`parentSlug`, `ProductCategory`.`baseSlug`, `ProductCategory`.`label`, `Parent`.`slug`, `ProductCategory`.`old_link` FROM `maydocd_v2020`.`product_categories` AS `ProductCategory` LEFT JOIN `maydocd_v2020`.`product_categories` AS `Parent` ON (`ProductCategory`.`parent_id` = `Parent`.`id`) LEFT JOIN `maydocd_v2020`.`product_categories` AS `Parent2` ON (`ProductCategory`.`parent_id_2` = `Parent2`.`id`) WHERE `ProductCategory`.`active` = '1' AND `ProductCategory`.`feature` = '1' AND `ProductCategory`.`parent_id` = 120 ORDER BY `ProductCategory`.`feature` desc, `ProductCategory`.`order` asc | 7 | 7 | 0 | |
SELECT `Product`.`id`, `Product`.`prices`, `Product`.`price`, `Product`.`name_vie`, `Product`.`slug`, `Product`.`type_link`, `Product`.`code`, `Product`.`image`, `Product`.`properties`, `Product`.`price_sale`, `Product`.`status`, `Product`.`old_link`, `ProductCategory`.`slug`, `ProductCategory2`.`slug`, `ProductCategory3`.`slug`, `ProductCategory`.`baseSlug`, `ProductCategory`.`baseSlugDetail`, `ProductCategory2`.`baseSlugDetail`, `ProductCategory3`.`baseSlugDetail`, `ProductCategory`.`label`, `ProductCategory2`.`label`, `ProductCategory3`.`label`, `Material`.`image`, `Material`.`id`, `Material`.`name_vie`, `Material`.`slug`, (SELECT SUM(rate) FROM product_reviews WHERE `product_reviews`.`product_id` = `Product`.`id`) AS `Product__sum_review`, (SELECT count(id) FROM product_reviews WHERE `product_reviews`.`product_id` = `Product`.`id`) AS `Product__count_review` FROM `maydocd_v2020`.`products` AS `Product` LEFT JOIN `maydocd_v2020`.`materials` AS `Material` ON (`Product`.`material_id` = `Material`.`id`) LEFT JOIN `maydocd_v2020`.`product_categories` AS `ProductCategory` ON (`Product`.`product_category_id` = `ProductCategory`.`id`) LEFT JOIN `maydocd_v2020`.`product_categories` AS `ProductCategory2` ON (`Product`.`product_category_id_2` = `ProductCategory2`.`id`) LEFT JOIN `maydocd_v2020`.`product_categories` AS `ProductCategory3` ON (`Product`.`product_category_id_3` = `ProductCategory3`.`id`) WHERE `Product`.`active` = '1' AND `Product`.`home` = '1' AND ((`Product`.`product_category_id` = 222) OR (`Product`.`product_category_id_2` = 222) OR (`Product`.`product_category_id_3` = 222)) ORDER BY `Product`.`not_feature` asc, RAND() ASC LIMIT 10 | 10 | 10 | 5 | maybe slow |
SELECT `ProductCategory`.`id`, `ProductCategory`.`name_vie`, `ProductCategory`.`slug`, `ProductCategory`.`icon`, `ProductCategory`.`image`, `ProductCategory`.`parentSlug`, `ProductCategory`.`baseSlug`, `ProductCategory`.`label`, `Parent`.`slug`, `ProductCategory`.`old_link` FROM `maydocd_v2020`.`product_categories` AS `ProductCategory` LEFT JOIN `maydocd_v2020`.`product_categories` AS `Parent` ON (`ProductCategory`.`parent_id` = `Parent`.`id`) LEFT JOIN `maydocd_v2020`.`product_categories` AS `Parent2` ON (`ProductCategory`.`parent_id_2` = `Parent2`.`id`) WHERE `ProductCategory`.`active` = '1' AND `ProductCategory`.`feature` = '1' AND `ProductCategory`.`parent_id` = 222 ORDER BY `ProductCategory`.`feature` desc, `ProductCategory`.`order` asc | 4 | 4 | 0 | |
SELECT `Product`.`id`, `Product`.`prices`, `Product`.`price`, `Product`.`name_vie`, `Product`.`slug`, `Product`.`type_link`, `Product`.`code`, `Product`.`image`, `Product`.`properties`, `Product`.`price_sale`, `Product`.`status`, `Product`.`old_link`, `ProductCategory`.`slug`, `ProductCategory2`.`slug`, `ProductCategory3`.`slug`, `ProductCategory`.`baseSlug`, `ProductCategory`.`baseSlugDetail`, `ProductCategory2`.`baseSlugDetail`, `ProductCategory3`.`baseSlugDetail`, `ProductCategory`.`label`, `ProductCategory2`.`label`, `ProductCategory3`.`label`, `Material`.`image`, `Material`.`id`, `Material`.`name_vie`, `Material`.`slug`, (SELECT SUM(rate) FROM product_reviews WHERE `product_reviews`.`product_id` = `Product`.`id`) AS `Product__sum_review`, (SELECT count(id) FROM product_reviews WHERE `product_reviews`.`product_id` = `Product`.`id`) AS `Product__count_review` FROM `maydocd_v2020`.`products` AS `Product` LEFT JOIN `maydocd_v2020`.`materials` AS `Material` ON (`Product`.`material_id` = `Material`.`id`) LEFT JOIN `maydocd_v2020`.`product_categories` AS `ProductCategory` ON (`Product`.`product_category_id` = `ProductCategory`.`id`) LEFT JOIN `maydocd_v2020`.`product_categories` AS `ProductCategory2` ON (`Product`.`product_category_id_2` = `ProductCategory2`.`id`) LEFT JOIN `maydocd_v2020`.`product_categories` AS `ProductCategory3` ON (`Product`.`product_category_id_3` = `ProductCategory3`.`id`) WHERE `Product`.`active` = '1' AND `Product`.`home` = '1' AND ((`Product`.`product_category_id` = 141) OR (`Product`.`product_category_id_2` = 141) OR (`Product`.`product_category_id_3` = 141)) ORDER BY `Product`.`not_feature` asc, RAND() ASC LIMIT 10 | 10 | 10 | 2 | maybe slow |
SELECT `ProductCategory`.`id`, `ProductCategory`.`name_vie`, `ProductCategory`.`slug`, `ProductCategory`.`icon`, `ProductCategory`.`image`, `ProductCategory`.`parentSlug`, `ProductCategory`.`baseSlug`, `ProductCategory`.`label`, `Parent`.`slug`, `ProductCategory`.`old_link` FROM `maydocd_v2020`.`product_categories` AS `ProductCategory` LEFT JOIN `maydocd_v2020`.`product_categories` AS `Parent` ON (`ProductCategory`.`parent_id` = `Parent`.`id`) LEFT JOIN `maydocd_v2020`.`product_categories` AS `Parent2` ON (`ProductCategory`.`parent_id_2` = `Parent2`.`id`) WHERE `ProductCategory`.`active` = '1' AND `ProductCategory`.`feature` = '1' AND `ProductCategory`.`parent_id` = 141 ORDER BY `ProductCategory`.`feature` desc, `ProductCategory`.`order` asc | 3 | 3 | 0 | |
SELECT `Tag`.`id`, `Tag`.`slug`, `Tag`.`tag_vie` FROM `maydocd_v2020`.`tags` AS `Tag` WHERE `home_page` = '1' AND `product_category_id` = 141 ORDER BY `order` asc LIMIT 4 | 0 | 0 | 1 | maybe slow |
SELECT `Product`.`id`, `Product`.`prices`, `Product`.`price`, `Product`.`name_vie`, `Product`.`slug`, `Product`.`type_link`, `Product`.`code`, `Product`.`image`, `Product`.`properties`, `Product`.`price_sale`, `Product`.`status`, `Product`.`old_link`, `ProductCategory`.`slug`, `ProductCategory2`.`slug`, `ProductCategory3`.`slug`, `ProductCategory`.`baseSlug`, `ProductCategory`.`baseSlugDetail`, `ProductCategory2`.`baseSlugDetail`, `ProductCategory3`.`baseSlugDetail`, `ProductCategory`.`label`, `ProductCategory2`.`label`, `ProductCategory3`.`label`, `Material`.`image`, `Material`.`id`, `Material`.`name_vie`, `Material`.`slug`, (SELECT SUM(rate) FROM product_reviews WHERE `product_reviews`.`product_id` = `Product`.`id`) AS `Product__sum_review`, (SELECT count(id) FROM product_reviews WHERE `product_reviews`.`product_id` = `Product`.`id`) AS `Product__count_review` FROM `maydocd_v2020`.`products` AS `Product` LEFT JOIN `maydocd_v2020`.`materials` AS `Material` ON (`Product`.`material_id` = `Material`.`id`) LEFT JOIN `maydocd_v2020`.`product_categories` AS `ProductCategory` ON (`Product`.`product_category_id` = `ProductCategory`.`id`) LEFT JOIN `maydocd_v2020`.`product_categories` AS `ProductCategory2` ON (`Product`.`product_category_id_2` = `ProductCategory2`.`id`) LEFT JOIN `maydocd_v2020`.`product_categories` AS `ProductCategory3` ON (`Product`.`product_category_id_3` = `ProductCategory3`.`id`) WHERE `Product`.`active` = '1' AND `Product`.`home` = '1' AND ((`Product`.`product_category_id` = 49) OR (`Product`.`product_category_id_2` = 49) OR (`Product`.`product_category_id_3` = 49)) ORDER BY `Product`.`not_feature` asc, RAND() ASC LIMIT 10 | 10 | 10 | 5 | maybe slow |
SELECT `ProductCategory`.`id`, `ProductCategory`.`name_vie`, `ProductCategory`.`slug`, `ProductCategory`.`icon`, `ProductCategory`.`image`, `ProductCategory`.`parentSlug`, `ProductCategory`.`baseSlug`, `ProductCategory`.`label`, `Parent`.`slug`, `ProductCategory`.`old_link` FROM `maydocd_v2020`.`product_categories` AS `ProductCategory` LEFT JOIN `maydocd_v2020`.`product_categories` AS `Parent` ON (`ProductCategory`.`parent_id` = `Parent`.`id`) LEFT JOIN `maydocd_v2020`.`product_categories` AS `Parent2` ON (`ProductCategory`.`parent_id_2` = `Parent2`.`id`) WHERE `ProductCategory`.`active` = '1' AND `ProductCategory`.`feature` = '1' AND `ProductCategory`.`parent_id` = 49 ORDER BY `ProductCategory`.`feature` desc, `ProductCategory`.`order` asc | 5 | 5 | 0 | |
SELECT `Product`.`id`, `Product`.`prices`, `Product`.`price`, `Product`.`name_vie`, `Product`.`slug`, `Product`.`type_link`, `Product`.`code`, `Product`.`image`, `Product`.`properties`, `Product`.`price_sale`, `Product`.`status`, `Product`.`old_link`, `ProductCategory`.`slug`, `ProductCategory2`.`slug`, `ProductCategory3`.`slug`, `ProductCategory`.`baseSlug`, `ProductCategory`.`baseSlugDetail`, `ProductCategory2`.`baseSlugDetail`, `ProductCategory3`.`baseSlugDetail`, `ProductCategory`.`label`, `ProductCategory2`.`label`, `ProductCategory3`.`label`, `Material`.`image`, `Material`.`id`, `Material`.`name_vie`, `Material`.`slug`, (SELECT SUM(rate) FROM product_reviews WHERE `product_reviews`.`product_id` = `Product`.`id`) AS `Product__sum_review`, (SELECT count(id) FROM product_reviews WHERE `product_reviews`.`product_id` = `Product`.`id`) AS `Product__count_review` FROM `maydocd_v2020`.`products` AS `Product` LEFT JOIN `maydocd_v2020`.`materials` AS `Material` ON (`Product`.`material_id` = `Material`.`id`) LEFT JOIN `maydocd_v2020`.`product_categories` AS `ProductCategory` ON (`Product`.`product_category_id` = `ProductCategory`.`id`) LEFT JOIN `maydocd_v2020`.`product_categories` AS `ProductCategory2` ON (`Product`.`product_category_id_2` = `ProductCategory2`.`id`) LEFT JOIN `maydocd_v2020`.`product_categories` AS `ProductCategory3` ON (`Product`.`product_category_id_3` = `ProductCategory3`.`id`) WHERE `Product`.`active` = '1' AND `Product`.`home` = '1' AND ((`Product`.`product_category_id` = 263) OR (`Product`.`product_category_id_2` = 263) OR (`Product`.`product_category_id_3` = 263)) ORDER BY `Product`.`not_feature` asc, RAND() ASC LIMIT 10 | 10 | 10 | 4 | maybe slow |
SELECT `ProductCategory`.`id`, `ProductCategory`.`name_vie`, `ProductCategory`.`slug`, `ProductCategory`.`icon`, `ProductCategory`.`image`, `ProductCategory`.`parentSlug`, `ProductCategory`.`baseSlug`, `ProductCategory`.`label`, `Parent`.`slug`, `ProductCategory`.`old_link` FROM `maydocd_v2020`.`product_categories` AS `ProductCategory` LEFT JOIN `maydocd_v2020`.`product_categories` AS `Parent` ON (`ProductCategory`.`parent_id` = `Parent`.`id`) LEFT JOIN `maydocd_v2020`.`product_categories` AS `Parent2` ON (`ProductCategory`.`parent_id_2` = `Parent2`.`id`) WHERE `ProductCategory`.`active` = '1' AND `ProductCategory`.`feature` = '1' AND `ProductCategory`.`parent_id` = 263 ORDER BY `ProductCategory`.`feature` desc, `ProductCategory`.`order` asc | 4 | 4 | 0 | |
SELECT `Product`.`id`, `Product`.`prices`, `Product`.`price`, `Product`.`name_vie`, `Product`.`slug`, `Product`.`type_link`, `Product`.`code`, `Product`.`image`, `Product`.`properties`, `Product`.`price_sale`, `Product`.`status`, `Product`.`old_link`, `ProductCategory`.`slug`, `ProductCategory2`.`slug`, `ProductCategory3`.`slug`, `ProductCategory`.`baseSlug`, `ProductCategory`.`baseSlugDetail`, `ProductCategory2`.`baseSlugDetail`, `ProductCategory3`.`baseSlugDetail`, `ProductCategory`.`label`, `ProductCategory2`.`label`, `ProductCategory3`.`label`, `Material`.`image`, `Material`.`id`, `Material`.`name_vie`, `Material`.`slug`, (SELECT SUM(rate) FROM product_reviews WHERE `product_reviews`.`product_id` = `Product`.`id`) AS `Product__sum_review`, (SELECT count(id) FROM product_reviews WHERE `product_reviews`.`product_id` = `Product`.`id`) AS `Product__count_review` FROM `maydocd_v2020`.`products` AS `Product` LEFT JOIN `maydocd_v2020`.`materials` AS `Material` ON (`Product`.`material_id` = `Material`.`id`) LEFT JOIN `maydocd_v2020`.`product_categories` AS `ProductCategory` ON (`Product`.`product_category_id` = `ProductCategory`.`id`) LEFT JOIN `maydocd_v2020`.`product_categories` AS `ProductCategory2` ON (`Product`.`product_category_id_2` = `ProductCategory2`.`id`) LEFT JOIN `maydocd_v2020`.`product_categories` AS `ProductCategory3` ON (`Product`.`product_category_id_3` = `ProductCategory3`.`id`) WHERE `Product`.`active` = '1' AND `Product`.`home` = '1' AND ((`Product`.`product_category_id` = 285) OR (`Product`.`product_category_id_2` = 285) OR (`Product`.`product_category_id_3` = 285)) ORDER BY `Product`.`not_feature` asc, RAND() ASC LIMIT 10 | 10 | 10 | 2 | maybe slow |
SELECT `ProductCategory`.`id`, `ProductCategory`.`name_vie`, `ProductCategory`.`slug`, `ProductCategory`.`icon`, `ProductCategory`.`image`, `ProductCategory`.`parentSlug`, `ProductCategory`.`baseSlug`, `ProductCategory`.`label`, `Parent`.`slug`, `ProductCategory`.`old_link` FROM `maydocd_v2020`.`product_categories` AS `ProductCategory` LEFT JOIN `maydocd_v2020`.`product_categories` AS `Parent` ON (`ProductCategory`.`parent_id` = `Parent`.`id`) LEFT JOIN `maydocd_v2020`.`product_categories` AS `Parent2` ON (`ProductCategory`.`parent_id_2` = `Parent2`.`id`) WHERE `ProductCategory`.`active` = '1' AND `ProductCategory`.`feature` = '1' AND `ProductCategory`.`parent_id` = 285 ORDER BY `ProductCategory`.`feature` desc, `ProductCategory`.`order` asc | 3 | 3 | 0 | |
SELECT `Tag`.`id`, `Tag`.`slug`, `Tag`.`tag_vie` FROM `maydocd_v2020`.`tags` AS `Tag` WHERE `home_page` = '1' AND `product_category_id` = 285 ORDER BY `order` asc LIMIT 4 | 0 | 0 | 0 | |
SELECT `Product`.`id`, `Product`.`prices`, `Product`.`price`, `Product`.`name_vie`, `Product`.`slug`, `Product`.`type_link`, `Product`.`code`, `Product`.`image`, `Product`.`properties`, `Product`.`price_sale`, `Product`.`status`, `Product`.`old_link`, `ProductCategory`.`slug`, `ProductCategory2`.`slug`, `ProductCategory3`.`slug`, `ProductCategory`.`baseSlug`, `ProductCategory`.`baseSlugDetail`, `ProductCategory2`.`baseSlugDetail`, `ProductCategory3`.`baseSlugDetail`, `ProductCategory`.`label`, `ProductCategory2`.`label`, `ProductCategory3`.`label`, `Material`.`image`, `Material`.`id`, `Material`.`name_vie`, `Material`.`slug`, (SELECT SUM(rate) FROM product_reviews WHERE `product_reviews`.`product_id` = `Product`.`id`) AS `Product__sum_review`, (SELECT count(id) FROM product_reviews WHERE `product_reviews`.`product_id` = `Product`.`id`) AS `Product__count_review` FROM `maydocd_v2020`.`products` AS `Product` LEFT JOIN `maydocd_v2020`.`materials` AS `Material` ON (`Product`.`material_id` = `Material`.`id`) LEFT JOIN `maydocd_v2020`.`product_categories` AS `ProductCategory` ON (`Product`.`product_category_id` = `ProductCategory`.`id`) LEFT JOIN `maydocd_v2020`.`product_categories` AS `ProductCategory2` ON (`Product`.`product_category_id_2` = `ProductCategory2`.`id`) LEFT JOIN `maydocd_v2020`.`product_categories` AS `ProductCategory3` ON (`Product`.`product_category_id_3` = `ProductCategory3`.`id`) WHERE `Product`.`active` = '1' AND `Product`.`home` = '1' AND ((`Product`.`product_category_id` = 225) OR (`Product`.`product_category_id_2` = 225) OR (`Product`.`product_category_id_3` = 225)) ORDER BY `Product`.`not_feature` asc, RAND() ASC LIMIT 10 | 10 | 10 | 3 | maybe slow |
SELECT `ProductCategory`.`id`, `ProductCategory`.`name_vie`, `ProductCategory`.`slug`, `ProductCategory`.`icon`, `ProductCategory`.`image`, `ProductCategory`.`parentSlug`, `ProductCategory`.`baseSlug`, `ProductCategory`.`label`, `Parent`.`slug`, `ProductCategory`.`old_link` FROM `maydocd_v2020`.`product_categories` AS `ProductCategory` LEFT JOIN `maydocd_v2020`.`product_categories` AS `Parent` ON (`ProductCategory`.`parent_id` = `Parent`.`id`) LEFT JOIN `maydocd_v2020`.`product_categories` AS `Parent2` ON (`ProductCategory`.`parent_id_2` = `Parent2`.`id`) WHERE `ProductCategory`.`active` = '1' AND `ProductCategory`.`feature` = '1' AND `ProductCategory`.`parent_id` = 225 ORDER BY `ProductCategory`.`feature` desc, `ProductCategory`.`order` asc | 2 | 2 | 0 | |
SELECT `Tag`.`id`, `Tag`.`slug`, `Tag`.`tag_vie` FROM `maydocd_v2020`.`tags` AS `Tag` WHERE `home_page` = '1' AND `product_category_id` = 225 ORDER BY `order` asc LIMIT 4 | 0 | 0 | 0 | |
SELECT `BlogCategory`.`id`, `BlogCategory`.`name_vie`, `BlogCategory`.`slug`, `BlogCategory`.`parent_id` FROM `maydocd_v2020`.`blog_categories` AS `BlogCategory` WHERE `active` = '1' ORDER BY `order` asc | 13 | 13 | 0 | |