[ DB ] CONNECT:[ UseTime:0.000486s ] mysql:host=127.0.0.1;dbname=beijian_shop;charset=utf8
[ SQL ] SHOW COLUMNS FROM `product` [ RunTime:0.000641s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `product` `p` INNER JOIN `product_label_relation` `pr` ON `pr`.`pid`=`p`.`id` WHERE `p`.`subject` = '10' AND `p`.`status` = 1 AND `pr`.`lid` = '28' LIMIT 1 [ RunTime:0.000392s ]
[ 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` = '10' AND `p`.`status` = 1 AND `pr`.`lid` = '28' ORDER BY `p`.`ctime` DESC LIMIT 0,32 [ RunTime:0.000349s ]
[ SQL ] SHOW COLUMNS FROM `cascade` [ RunTime:0.000388s ]
[ 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` = '10' [ RunTime:0.000346s ]
