SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001261s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 141014 LIMIT 1 [ RunTime:0.000402s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 141014 [ RunTime:0.003667s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (897267,706098,887252,267473,524167,614295,986848,42695,420623,757632,418655,468842,162027,541452,453631,281817,192544,80370,616647,3628,139094,173596,47149,315396,412033,758390,947254,749092,50850,217886,33912,986829,373886,1006492,174518,58619,942030,1022786,468187,268494,902867,136400,853853,783322,930826,289643,512550,133740,54006,484244,974503,472469,371066,609307,222547,532142,300085,32769,1041036,684672) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001485s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 141014 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000384s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 141014 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000618s ]