[ SQL ] SHOW COLUMNS FROM `product` [ RunTime:0.002137s ]
[ SQL ] SELECT `p`.*,c.name as cate_name FROM `product` `p` INNER JOIN `cate` `c` ON `c`.`id`=`p`.`cate_id` WHERE ( `p`.`title` LIKE '%Rape%' OR `p`.`tag_text` LIKE '%Rape%' OR `c`.`name` LIKE '%Rape%' ) ORDER BY `p`.`id` DESC LIMIT 340,20 [ RunTime:0.038749s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `product` `p` INNER JOIN `cate` `c` ON `c`.`id`=`p`.`cate_id` WHERE ( `p`.`title` LIKE '%Rape%' OR `p`.`tag_text` LIKE '%Rape%' OR `c`.`name` LIKE '%Rape%' ) LIMIT 1 [ RunTime:0.017065s ]
[ SQL ] SELECT `keyword`,count(id) AS `count` FROM `search_log` GROUP BY `keyword` ORDER BY count(id) desc LIMIT 20 [ RunTime:0.001458s ]
[ SQL ] SELECT `keyword` FROM `search_log` WHERE `user_id` = 5651 GROUP BY `keyword` ORDER BY `add_time` DESC LIMIT 10 [ RunTime:0.000491s ]