SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001412s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 415219 LIMIT 1 [ RunTime:0.000414s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 415219 [ RunTime:0.001714s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (421960,809126,264685,1038788,261128,436321,932540,329139,950255,738202,639654,767572,414955,92430,361001,250828,732481,159565,198646,371669,138491,426284,518410,620113,529803,979964,891689,232313,950195,136743,656442,854854,584732,493878,920023,38232,636918,388970,716618,777131,72693,541900,972877,892763,1012149,837675,556702,880017,192548,925446,449755,324144,928183,717293,203904,274593,437996,464233,1005574,238992) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001062s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 415219 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000353s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 415219 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000438s ]