SHOW FULL COLUMNS FROM `speed_product` [ RunTime:0.000410s ]
SHOW FULL COLUMNS FROM `speed_product_langs` [ RunTime:0.000241s ]
SELECT COUNT(*) AS think_count FROM ( SELECT count(*) AS think_count FROM `speed_product` WHERE EXISTS ( SELECT * FROM `speed_product_langs` WHERE ( `speed_product_langs`.`product_id` = `speed_product`.`product_id` ) AND `lang` = 'en' ) GROUP BY `product_id` ) `_group_count_` [ RunTime:0.000280s ]
SELECT `product_id` FROM `speed_product` WHERE EXISTS ( SELECT * FROM `speed_product_langs` WHERE ( `speed_product_langs`.`product_id` = `speed_product`.`product_id` ) AND `lang` = 'en' ) GROUP BY `product_id` ORDER BY `product_id` DESC LIMIT 0,15 [ RunTime:0.000171s ]
SELECT p.id as main_id,`p`.`product_id`,`p`.`category_id`,`p`.`status`,`p`.`sort`,`p`.`create_time`,`p`.`cover`,`p`.`images`,`pl`.`id`,`pl`.`lang`,`pl`.`title`,`pl`.`content`,`pl`.`description` FROM `speed_product` `p` INNER JOIN `speed_product_langs` `pl` ON `p`.`product_id`=`pl`.`product_id` WHERE `p`.`product_id` IN ('20','19','18','17','16','15','14','13','12','11','10','9','8','7','6') ORDER BY `p`.`product_id` DESC,`pl`.`lang` ASC [ RunTime:0.000495s ]
