SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001408s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 268242 LIMIT 1 [ RunTime:0.000437s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 268242 [ RunTime:0.002696s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (551005,102659,879984,200244,107070,661361,35264,345308,68336,958380,405878,408542,51116,879121,945293,360790,29138,572018,5413,964425,433752,517434,619567,729434,109546,1026870,675605,137544,8336,469594,540319,310022,109604,91600,429799,393083,579500,44237,18619,635316,521066,71541,151680,505523,440639,256391,397100,961091,838888,982687,876741,576933,571706,478978,631225,585154,942211,757491,287156,553957) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001147s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 268242 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000430s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 268242 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000613s ]