[ DB ] CONNECT:[ UseTime:0.000493s ] mysql:host=127.0.0.1;dbname=beijian_shop;charset=utf8
[ SQL ] SHOW COLUMNS FROM `product` [ RunTime:0.000697s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `product` `p` INNER JOIN `product_label_relation` `pr` ON `pr`.`pid`=`p`.`id` WHERE `p`.`subject` = '9' AND `p`.`status` = 1 AND `pr`.`lid` = '20' LIMIT 1 [ RunTime:0.000381s ]
[ SQL ] SELECT `p`.`id`,`p`.`title`,`p`.`coverimg`,`p`.`desc` FROM `product` `p` INNER JOIN `product_label_relation` `pr` ON `pr`.`pid`=`p`.`id` WHERE `p`.`subject` = '9' AND `p`.`status` = 1 AND `pr`.`lid` = '20' ORDER BY `p`.`ctime` DESC LIMIT 0,32 [ RunTime:0.000373s ]
[ SQL ] SHOW COLUMNS FROM `cascade` [ RunTime:0.000394s ]
[ SQL ] SELECT DISTINCT `c`.`id`,`c`.`name` FROM `cascade` `c` INNER JOIN `product_label_relation` `pr` ON `pr`.`lid`=`c`.`id` INNER JOIN `product` `p` ON `p`.`id`=`pr`.`pid` WHERE `p`.`status` = 1 AND `p`.`subject` = '9' [ RunTime:0.000347s ]
