SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001197s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 255840 LIMIT 1 [ RunTime:0.000346s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 255840 [ RunTime:0.002377s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (281575,25074,910433,571404,132693,264638,76641,102589,1018901,260277,144745,263699,466652,619849,489012,839019,49112,649416,638701,273870,672817,748275,542957,834742,342290,663082,14217,276141,248128,819128,812291,138267,269305,85722,983013,154529,148978,36457,192003,295685,92858,769173,689047,531045,208056,641636,506726,265723,942861,223904,451548,711468,334992,156477,708547,411682,233258,276118,377277,685219) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001484s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 255840 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000351s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 255840 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000589s ]