SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001200s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 680214 LIMIT 1 [ RunTime:0.000506s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 680214 [ RunTime:0.001445s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (695633,469120,600271,137780,319366,969475,570852,996836,875559,298996,659629,608943,21721,507575,979951,212527,604100,707309,471914,803448,565407,764363,747638,520886,401613,136057,913172,333936,235129,235547,494426,297947,986484,747251,304968,448492,788986,514752,284850,504679,529725,886966,885637,631859,573499,642188,454481,571262,1000239,684825,558447,396820,643645,289759,959914,1005374,602355,220003,238338,452183) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001092s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 680214 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000388s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 680214 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000480s ]