SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002118s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 140422 LIMIT 1 [ RunTime:0.000321s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 140422 [ RunTime:0.001912s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (801514,1036008,753306,504772,724569,715455,536906,833733,495633,416985,609982,300150,840678,112732,401041,828624,658180,182568,351751,930197,669163,546569,341623,879843,86974,475086,568496,657405,415911,500778,993579,46455,467052,670343,102630,536852,496123,444647,147647,124075,45187,556608,173563,177082,832448,430387,473499,251982,1003717,990837,316141,249096,351848,78375,200941,452554,155015,587703,43274,1008522) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001079s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 140422 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000359s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 140422 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000488s ]