[ DB ] CONNECT:[ UseTime:0.000549s ] mysql:host=127.0.0.1;port=3306;dbname=ysext.cn;charset=utf8mb4
[ SQL ] SHOW COLUMNS FROM `cmf_goods` [ RunTime:0.000871s ]
[ 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.000495s ]
[ 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.000598s ]
[ SQL ] SHOW COLUMNS FROM `cmf_order_from` [ RunTime:0.000973s ]
[ 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.000478s ]
[ 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.000369s ]
[ 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.000382s ]
[ 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.000455s ]
[ 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.000583s ]
[ 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.000357s ]
[ 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.000406s ]
[ 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.000404s ]
[ 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.000307s ]
[ 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.000269s ]
[ 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.000359s ]
[ 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.000354s ]
[ 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.000422s ]
[ 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.000326s ]
在线客服
来电咨询
微信咨询
申请代理
返回顶部
