SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001173s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 69180 LIMIT 1 [ RunTime:0.000309s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 69180 [ RunTime:0.001582s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (688540,425304,877651,52227,824554,941143,914117,602000,774661,885568,486802,595751,466544,139291,209965,699928,156643,200334,6557,575151,750045,169659,27528,959716,1012048,252485,465133,955648,750989,389952,142937,63140,553727,928556,12929,108075,326644,190284,858130,142301,964937,15887,217675,144595,321283,324753,894117,330992,658111,825445,361224,258949,725536,350420,922766,884367,8962,357911,431990,803792) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000995s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 69180 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000368s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 69180 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000543s ]