SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001297s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 310809 LIMIT 1 [ RunTime:0.000376s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 310809 [ RunTime:0.001763s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (861263,969427,385695,363874,577038,27737,532144,502670,360808,592464,867762,934767,468228,39109,268924,612695,33104,28747,306545,372929,940384,268780,83092,56096,784683,259617,138173,771935,656206,69746,561230,573453,707188,1006774,240618,1007123,166129,33788,191105,853871,575514,246497,966077,34943,48786,378483,895227,399142,20325,848651,956605,199299,74306,344005,450369,956538,699802,813429,585559,879440) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001086s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 310809 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000423s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 310809 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000477s ]