SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003580s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 421412 LIMIT 1 [ RunTime:0.005883s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 421412 [ RunTime:0.004698s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (251049,288795,311599,852800,290957,741884,771775,649089,497610,492551,773941,336354,624073,32740,19730,954902,744695,851279,925954,880641,376591,665138,300910,102520,305890,617391,695378,392037,680701,324842,34177,726458,68416,585006,810319,941460,849237,64367,841609,737777,428991,891754,386138,662383,448831,583630,568437,958094,673876,1026645,917585,205334,86011,589324,139768,462505,292650,634573,539255,710604) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003880s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 421412 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.007653s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 421412 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.004389s ]