NoteDeep
select * from `sys_user` t where t.`mobile` ='15615670960'
#1370176211027804179


#消费记录
select * from iot.`consume_record` WHERE `user_id` ='1370176211027804179' and `id` = '1377053324372668438';
#订单
#SELECT * from `iot`.`order` WHERE `user_id` ='1370176211027804179' and `order_no` = '1374852464783749205';

SELECT * from `iot`.`order` WHERE `user_id` ='1370176211027804179' and `id` = '1377070912326606914'


#预约
SELECT * from `iot`.`queue_ticket` WHERE `user_id` = '1370176211027804179'
#排队
SELECT * FROM `iot`.`queue_record` WHERE `user_id` = '1370176211027804179'
#1349605176649973815 设备ID
select * FROM `iot`.`device` WHERE `id` = '1349605176649973815'

查询多次支付订单
SELECT * from (SELECT * FROM `order_pay` GROUP BY `order_id` ,pay_method HAVING ( COUNT( `order_id`) > 1) ) a where
a.order_id in (SELECT t.id from `order` t ,order_pay t1 where t.id =t1.order_id and t.project_id = '1418780707655897105')

调用待支付订单插入redis接口
curl http://localhost:8097/orderRedis/insertRedisByProjectId/1418780707655897105 -X POST -d

查询log
docker-compose logs -f --tail 1000 iot-easy

评论列表