[ DB ] CONNECT:[ UseTime:0.000430s ] mysql:host=127.0.0.1;port=3306;dbname=ysext.cn;charset=utf8mb4
[ SQL ] SHOW COLUMNS FROM `cmf_goods` [ RunTime:0.000799s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `cmf_goods` WHERE `service_type` = 1 AND `type` = 2 AND `status` = 1 AND `delete_time` = 0 [ RunTime:0.000426s ]
[ SQL ] SELECT * FROM `cmf_goods` WHERE `service_type` = 1 AND `type` = 2 AND `status` = 1 AND `delete_time` = 0 ORDER BY `is_hot` DESC LIMIT 0,16 [ RunTime:0.000987s ]
[ SQL ] SHOW COLUMNS FROM `cmf_order_from` [ RunTime:0.006626s ]
[ SQL ] SELECT COUNT(`of`.`id`) AS tp_count FROM `cmf_order_from` `of` LEFT JOIN `cmf_goods_info` `gi` ON `gi`.`id`=`of`.`object_id` LEFT JOIN `cmf_goods` `g` ON `g`.`id`=`gi`.`goods_id` WHERE `g`.`id` = 3 AND `of`.`type` = 2 AND `of`.`status` > 0 [ RunTime:0.001018s ]
[ SQL ] SELECT COUNT(`of`.`id`) AS tp_count FROM `cmf_order_from` `of` LEFT JOIN `cmf_goods_info` `gi` ON `gi`.`id`=`of`.`object_id` LEFT JOIN `cmf_goods` `g` ON `g`.`id`=`gi`.`goods_id` WHERE `g`.`id` = 21 AND `of`.`type` = 2 AND `of`.`status` > 0 [ RunTime:0.000403s ]
[ SQL ] SELECT COUNT(`of`.`id`) AS tp_count FROM `cmf_order_from` `of` LEFT JOIN `cmf_goods_info` `gi` ON `gi`.`id`=`of`.`object_id` LEFT JOIN `cmf_goods` `g` ON `g`.`id`=`gi`.`goods_id` WHERE `g`.`id` = 23 AND `of`.`type` = 2 AND `of`.`status` > 0 [ RunTime:0.000438s ]
[ SQL ] SELECT COUNT(`of`.`id`) AS tp_count FROM `cmf_order_from` `of` LEFT JOIN `cmf_goods_info` `gi` ON `gi`.`id`=`of`.`object_id` LEFT JOIN `cmf_goods` `g` ON `g`.`id`=`gi`.`goods_id` WHERE `g`.`id` = 5 AND `of`.`type` = 2 AND `of`.`status` > 0 [ RunTime:0.000372s ]
[ SQL ] SELECT COUNT(`of`.`id`) AS tp_count FROM `cmf_order_from` `of` LEFT JOIN `cmf_goods_info` `gi` ON `gi`.`id`=`of`.`object_id` LEFT JOIN `cmf_goods` `g` ON `g`.`id`=`gi`.`goods_id` WHERE `g`.`id` = 20 AND `of`.`type` = 2 AND `of`.`status` > 0 [ RunTime:0.000402s ]
[ SQL ] SELECT COUNT(`of`.`id`) AS tp_count FROM `cmf_order_from` `of` LEFT JOIN `cmf_goods_info` `gi` ON `gi`.`id`=`of`.`object_id` LEFT JOIN `cmf_goods` `g` ON `g`.`id`=`gi`.`goods_id` WHERE `g`.`id` = 22 AND `of`.`type` = 2 AND `of`.`status` > 0 [ RunTime:0.000388s ]
[ SQL ] SELECT COUNT(`of`.`id`) AS tp_count FROM `cmf_order_from` `of` LEFT JOIN `cmf_goods_info` `gi` ON `gi`.`id`=`of`.`object_id` LEFT JOIN `cmf_goods` `g` ON `g`.`id`=`gi`.`goods_id` WHERE `g`.`id` = 26 AND `of`.`type` = 2 AND `of`.`status` > 0 [ RunTime:0.000435s ]
[ SQL ] SELECT COUNT(`of`.`id`) AS tp_count FROM `cmf_order_from` `of` LEFT JOIN `cmf_goods_info` `gi` ON `gi`.`id`=`of`.`object_id` LEFT JOIN `cmf_goods` `g` ON `g`.`id`=`gi`.`goods_id` WHERE `g`.`id` = 27 AND `of`.`type` = 2 AND `of`.`status` > 0 [ RunTime:0.000376s ]
[ SQL ] SELECT COUNT(`of`.`id`) AS tp_count FROM `cmf_order_from` `of` LEFT JOIN `cmf_goods_info` `gi` ON `gi`.`id`=`of`.`object_id` LEFT JOIN `cmf_goods` `g` ON `g`.`id`=`gi`.`goods_id` WHERE `g`.`id` = 30 AND `of`.`type` = 2 AND `of`.`status` > 0 [ RunTime:0.000360s ]
[ SQL ] SELECT COUNT(`of`.`id`) AS tp_count FROM `cmf_order_from` `of` LEFT JOIN `cmf_goods_info` `gi` ON `gi`.`id`=`of`.`object_id` LEFT JOIN `cmf_goods` `g` ON `g`.`id`=`gi`.`goods_id` WHERE `g`.`id` = 31 AND `of`.`type` = 2 AND `of`.`status` > 0 [ RunTime:0.000394s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `cmf_goods` WHERE `service_type` = 1 AND `type` = 2 AND `status` = 1 AND `delete_time` = 0 AND `is_hot` > 0 [ RunTime:0.000522s ]
[ SQL ] SELECT * FROM `cmf_goods` WHERE `service_type` = 1 AND `type` = 2 AND `status` = 1 AND `delete_time` = 0 AND `is_hot` > 0 ORDER BY `is_hot` DESC LIMIT 0,5 [ RunTime:0.000482s ]
[ SQL ] SELECT COUNT(`of`.`id`) AS tp_count FROM `cmf_order_from` `of` LEFT JOIN `cmf_goods_info` `gi` ON `gi`.`id`=`of`.`object_id` LEFT JOIN `cmf_goods` `g` ON `g`.`id`=`gi`.`goods_id` WHERE `g`.`id` = 3 AND `of`.`type` = 2 AND `of`.`status` > 0 [ RunTime:0.000388s ]
[ SQL ] SELECT COUNT(`of`.`id`) AS tp_count FROM `cmf_order_from` `of` LEFT JOIN `cmf_goods_info` `gi` ON `gi`.`id`=`of`.`object_id` LEFT JOIN `cmf_goods` `g` ON `g`.`id`=`gi`.`goods_id` WHERE `g`.`id` = 21 AND `of`.`type` = 2 AND `of`.`status` > 0 [ RunTime:0.000362s ]
[ SQL ] SELECT COUNT(`of`.`id`) AS tp_count FROM `cmf_order_from` `of` LEFT JOIN `cmf_goods_info` `gi` ON `gi`.`id`=`of`.`object_id` LEFT JOIN `cmf_goods` `g` ON `g`.`id`=`gi`.`goods_id` WHERE `g`.`id` = 23 AND `of`.`type` = 2 AND `of`.`status` > 0 [ RunTime:0.000369s ]