SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001179s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 546141 LIMIT 1 [ RunTime:0.000336s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 546141 [ RunTime:0.001569s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (904391,67087,251230,198632,286573,151570,1024210,433949,160460,798714,663840,271818,390858,553785,25434,92290,31043,343163,209349,751976,187692,453111,610972,105430,792419,939842,584924,68083,904767,422035,842700,597575,52474,840788,279278,990155,283538,451758,285421,795614,415014,890487,904588,568628,318102,648535,7975,273062,492249,232434,268172,462281,437388,499912,332562,173259,911135,335612,910516,923813) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001016s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 546141 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000364s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 546141 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000474s ]