| Query | Affected | Num. rows | Took (ms) | Actions |
|---|
| SELECT `Language`.`id`, `Language`.`alias` FROM `qqrice_test`.`booster_languages` AS `Language` WHERE `Language`.`enabled` = '1' | 3 | 3 | 0 | |
| SELECT `ProductType`.`sorting`, `ProductType`.`slug`, (`ProductTypeLang`.`title`) AS `ProductType__title` FROM `qqrice_test`.`booster_product_types` AS `ProductType` INNER JOIN `qqrice_test`.`booster_product_type_languages` AS `ProductTypeLang` ON (((`ProductTypeLang`.`type_id` = `ProductType`.`id`) AND (`ProductTypeLang`.`alias` = 'zho'))) WHERE `ProductType`.`enabled` = '1' ORDER BY `ProductType`.`sorting` asc | 9 | 9 | 0 | |
| SELECT `Setting`.`slug`, `Setting`.`value` FROM `qqrice_test`.`booster_settings` AS `Setting` WHERE `Setting`.`slug` IN ('social-link-facebook', 'social-link-instagram', 'social-link-youtube', 'social-link-whatsapp', 'social-link-wechat') | 5 | 5 | 0 | |
| SELECT `Product`.`id`, `Product`.`product_number`, `Product`.`channel_type_id`, `Product`.`path`, `Product`.`inventory`, `Product`.`preorder_maximum_inventory`, `Product`.`catering_service_min_qty`, `Product`.`sale_price`, `Product`.`promote_price`, `Product`.`net_weight`, `Product`.`calorie`, `Product`.`path_mascot`, `Product`.`product_type_id`, (`ProductDLang`.`title`) AS `Product__title`, (`ProductDLang`.`origin`) AS `Product__origin`, (`ProductDLang`.`ingredients`) AS `Product__ingredients`, (`ProductDLang`.`preservation`) AS `Product__preservation`, (`ProductDLang`.`nutrition`) AS `Product__nutrition`, (`ProductDLang`.`edible`) AS `Product__edible`, (`ProductDLang`.`description`) AS `Product__description`, (`ProductT`.`slug`) AS `Product__type_slug` FROM `qqrice_test`.`booster_products` AS `Product` INNER JOIN `qqrice_test`.`booster_product_languages` AS `ProductDLang` ON (((`ProductDLang`.`product_id` = `Product`.`id`) AND (`ProductDLang`.`alias` = 'zho'))) INNER JOIN `qqrice_test`.`booster_product_types` AS `ProductT` ON (`ProductT`.`id` = `Product`.`product_type_id`) WHERE `Product`.`enabled` = '1' AND `Product`.`product_number` = 'DF001C' ORDER BY (`ProductDLang`.`title`) asc LIMIT 1 | 1 | 1 | 0 | |
| SELECT ProductComment.*, Member.name, `ProductComment`.`id` FROM `qqrice_test`.`booster_product_comments` AS `ProductComment` LEFT JOIN `qqrice_test`.`booster_members` AS `Member` ON (`Member`.`id` = `ProductComment`.`member_id`) WHERE `ProductComment`.`product_id` = 25 | 0 | 0 | 0 | |
| SELECT `ProductImage`.`id`, `ProductImage`.`path` FROM `qqrice_test`.`booster_product_images` AS `ProductImage` WHERE `ProductImage`.`product_id` = 25 ORDER BY `ProductImage`.`id` asc | 1 | 1 | 0 | |
| SELECT `Product`.`id`, `Product`.`product_number`, `Product`.`path`, `Product`.`inventory`, `Product`.`sale_price`, `Product`.`promote_price`, `Product`.`net_weight`, `Product`.`calorie`, (`ProductRLang`.`title`) AS `Product__title` FROM `qqrice_test`.`booster_products` AS `Product` INNER JOIN `qqrice_test`.`booster_product_languages` AS `ProductRLang` ON (((`ProductRLang`.`product_id` = `Product`.`id`) AND (`ProductRLang`.`alias` = 'zho'))) WHERE `Product`.`enabled` = '1' AND `Product`.`product_number` != 'DF001C' AND `Product`.`product_type_id` = 2 AND `Product`.`channel_type_id` IN (1, 3, 4, 5) ORDER BY rand() ASC LIMIT 3 | 3 | 3 | 1 | maybe slow |
