SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001264s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 510706 LIMIT 1 [ RunTime:0.000368s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 510706 [ RunTime:0.001740s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (604783,131189,407800,185195,12911,767372,78062,791028,710153,629700,1022548,802265,766060,365858,553832,225252,624272,534820,317643,443648,827486,610215,600816,21058,257278,474066,647619,462131,650038,145452,342849,356273,831776,856172,320292,435071,365534,667884,529833,532461,496212,460408,1010114,908639,432925,121360,265878,29174,855016,931582,560857,624842,620611,322474,708903,953082,480669,668062,540338,1010550) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001066s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 510706 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000437s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 510706 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000562s ]