SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001153s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 54141 LIMIT 1 [ RunTime:0.001317s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 54141 [ RunTime:0.001639s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (143265,142923,592242,476222,904548,380996,992590,250771,799813,408301,429706,531393,619978,218728,168114,224962,90263,754247,28207,159113,884122,676186,819985,595166,1010275,442891,390427,896287,623314,626153,757314,352372,630900,947902,175024,26314,543169,643803,109299,57165,28210,584682,620352,1025413,216090,1047395,618440,493214,953801,358145,640771,415525,635790,401669,436740,578321,562113,714573,853720,703690) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001000s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 54141 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000367s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 54141 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000552s ]