SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001196s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 425021 LIMIT 1 [ RunTime:0.001183s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 425021 [ RunTime:0.002331s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (659792,355343,624843,1013668,28991,792945,631640,352194,592646,834637,715799,404009,950545,1011348,336413,247813,78517,530468,1006825,926030,1038766,8993,114994,431252,393245,946935,1003579,87996,55943,209009,366216,94182,382229,553377,631586,761411,984006,646356,123092,894100,200695,143758,359220,770277,380514,462019,261211,252835,295242,162460,991736,557406,235746,1044203,164769,916209,842999,543208,543268,673570) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002938s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 425021 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000424s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 425021 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002743s ]