SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001177s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 104569 LIMIT 1 [ RunTime:0.000333s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 104569 [ RunTime:0.001996s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (922541,201680,71897,28186,582049,1046738,724842,52235,459561,911028,252991,606637,554311,50051,657524,383566,695923,892332,591716,217348,576050,57195,156125,825875,413637,928650,695885,834374,720386,169430,421596,778373,285379,324252,349117,982259,525591,721479,242692,709952,777655,621559,182510,553101,271308,605175,928400,273702,1027836,355030,889382,662257,545635,769279,251510,274594,861899,29008,894361,576517) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001210s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 104569 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000407s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 104569 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000553s ]