SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001293s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 320811 LIMIT 1 [ RunTime:0.000412s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 320811 [ RunTime:0.002029s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (522998,160810,653882,916113,787592,818396,197534,261000,745801,315678,527746,868513,822394,702738,400869,885151,437482,1047000,381605,165856,866121,691786,238180,839305,580592,673135,855200,347816,552355,724768,168316,973909,200632,847503,831408,241083,698908,750280,522984,132916,771696,714366,271022,865265,627911,19342,24989,908899,39900,668222,693227,227286,879316,654700,512010,12251,800570,170055,905322,232049) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001026s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 320811 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000353s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 320811 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000609s ]