SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001161s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 451082 LIMIT 1 [ RunTime:0.000344s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 451082 [ RunTime:0.001641s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (193050,294046,727776,687078,432099,628934,966834,98978,632007,503980,587138,879408,952506,725411,797118,975081,46518,813190,240924,964859,444075,34776,754172,180949,969526,464121,857215,716438,843225,899429,230354,818242,581815,351258,1045194,284301,89275,932650,115709,995802,927398,929498,1012207,308861,719765,324530,599264,485645,16847,359861,356303,468432,422995,740207,505249,892319,594216,910538,13734,864947) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002550s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 451082 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000382s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 451082 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000620s ]