SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001239s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 522063 LIMIT 1 [ RunTime:0.000396s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 522063 [ RunTime:0.002373s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (715703,1023441,60104,227615,362533,935954,968965,536438,1020367,451977,429000,784851,665058,594835,332434,198695,30487,644318,331129,811312,351903,90472,425126,380679,561274,468975,307282,132902,215763,194822,468742,663285,581602,839131,327476,989749,676965,98512,310069,980316,597209,205374,108612,113501,449938,89943,287510,374248,432267,298862,55632,637683,589361,791326,488145,477110,484885,143855,621747,234231) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001018s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 522063 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000597s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 522063 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000516s ]