SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002103s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 338580 LIMIT 1 [ RunTime:0.000405s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 338580 [ RunTime:0.005148s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (858458,1014059,44557,169587,571446,930287,402747,968626,401393,654011,1014127,632407,975542,813521,664163,560850,432785,737687,837067,826533,766570,42943,95634,653526,520620,598175,862606,153957,774376,615048,552332,422782,928197,232421,306210,415724,932085,310772,535049,50867,752015,458597,585232,800265,161594,254876,362636,735787,547695,738794,667576,883164,881201,12069,713767,252186,514405,798138,601329,296244) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001049s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 338580 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000374s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 338580 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000614s ]