SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001514s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 517000 LIMIT 1 [ RunTime:0.000550s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 517000 [ RunTime:0.004648s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1032668,871754,93080,676964,35495,916423,842711,520031,732509,571040,573084,44996,129822,388604,412092,797372,991978,974039,1044659,346696,835808,616061,881791,839484,956822,937442,127225,734198,126224,497487,126127,654261,506092,111639,355729,136749,160085,387148,754579,735233,656787,873175,279173,512468,573955,537413,851370,694767,628698,302519,982432,425019,29996,140619,66600,778527,1034784,794988,320775,689356) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001140s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 517000 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000627s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 517000 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001638s ]