[ DB ] CONNECT:[ UseTime:0.000765s ] mysql:host=127.0.0.1;port=3306;dbname=ysext.cn;charset=utf8mb4
[ SQL ] SHOW COLUMNS FROM `cmf_goods` [ RunTime:0.002105s ]
[ 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.002473s ]
[ 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.001025s ]
[ SQL ] SHOW COLUMNS FROM `cmf_order_from` [ RunTime:0.001492s ]
[ 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.001184s ]
[ 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.001042s ]
[ 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.001001s ]
[ 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.001199s ]
[ 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.001174s ]
[ 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.001208s ]
[ 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.001046s ]
[ 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.001062s ]
[ 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.000862s ]
[ 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.001060s ]
[ 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.000637s ]
[ 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.001179s ]
[ 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.000876s ]
[ 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.001186s ]
[ 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.001111s ]
在线客服
来电咨询
微信咨询
申请代理
返回顶部
