MySQL [br_sms]> set @s = ‘SELECT id, vendor, channel_id, notify_id, send_to, encrypted_send_to, send_by, content_type, template_key, extroInfo, notify_type, request_id, system_id, send_Channel_time, send_channel_result, message_id, send_num, send_vendor_num, origin, is_valid, created_by, created_at, updated_by, updated_at, content, send_channel_response, json_info FROM notify_result_2021 WHERE id = ?’;
Query OK, 0 rows affected (0.00 sec)
MySQL [br_sms]>
MySQL [br_sms]> prepare stmt2 from @s;
Query OK, 0 rows affected (0.00 sec)
MySQL [br_sms]> set @c=null;
Query OK, 0 rows affected (0.00 sec)
MySQL [br_sms]> execute stmt2 using @c;
Empty set (16.62 sec)
MySQL [br_sms]>
MySQL [br_sms]>
MySQL [br_sms]> set @c=31194373;
Query OK, 0 rows affected (0.00 sec)
MySQL [br_sms]> execute stmt2 using @c;
±---------±-------±-----------±----------±------------±------------------±--------±-------------±-------------------±-------------±------------±---------------------------------±----------±--------------------±--------------------±-------------------±---------±----------------±-------±---------±-----------±--------------------±-----------±--------------------±-----------------------------------------------------------------------------------------------------------------±----------------------------------------------------------------------------------------------------------------------------------------------------------±----------+
| id | vendor | channel_id | notify_id | send_to | encrypted_send_to | send_by | content_type | template_key | extroInfo | notify_type | request_id | system_id | send_Channel_time | send_channel_result | message_id | send_num | send_vendor_num | origin | is_valid | created_by | created_at | updated_by | updated_at | content | send_channel_response | json_info |
±---------±-------±-----------±----------±------------±------------------±--------±-------------±-------------------±-------------±------------±---------------------------------±----------±--------------------±--------------------±-------------------±---------±----------------±-------±---------±-----------±--------------------±-----------±--------------------±-----------------------------------------------------------------------------------------------------------------±----------------------------------------------------------------------------------------------------------------------------------------------------------±----------+
| 31194373 | 29 | 2401 | 15424234 | 14411161122 | | | 2401 | 元知测试模板 | 未知错误 | 1 | 3a20d9e8606b41c3a26ab1b432473f76 | 1125 | 2021-06-01 22:04:49 | 1 | 210601220448782820 | 1 | 1 | | 1 | 0 | 2021-06-01 22:04:49 | 0 | 2021-06-01 22:04:49 | 【美团民宿】分享入住美团民宿的体验,可返2.04元房费哦!戳 打开美团 回TD退订 | {“code”:“F0100”,“desc”:“未知错误”,“uid”:“3f1857d618434d3b8b905f4a87475c01”,“result”:[{“status”:“F0100”,“phone”:“14411161122”,“desc”:“未知错误”}]} | NULL |
±---------±-------±-----------±----------±------------±------------------±--------±-------------±-------------------±-------------±------------±---------------------------------±----------±--------------------±--------------------±-------------------±---------±----------------±-------±---------±-----------±--------------------±-----------±--------------------±-----------------------------------------------------------------------------------------------------------------±----------------------------------------------------------------------------------------------------------------------------------------------------------±----------+
1 row in set (0.01 sec)
MySQL [br_sms]>
以上是tidb里执行的情况,null的时候执行16秒