SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001257s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 401999 LIMIT 1 [ RunTime:0.000377s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 401999 [ RunTime:0.001835s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (657107,497836,898206,1044182,410905,134818,105955,663264,423866,640764,926212,105214,750817,1043402,941869,955109,401330,797605,31029,811313,367966,350849,438,472564,659450,262402,799169,873132,743190,154929,709859,421690,255521,308356,648597,750988,186050,737858,536282,245644,953709,114981,758563,402851,224847,726481,654418,496257,577881,572316,209283,1043526,150985,984393,487392,741167,337865,399471,446286,583357) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001240s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 401999 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000474s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 401999 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000644s ]