SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001256s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 291685 LIMIT 1 [ RunTime:0.000580s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 291685 [ RunTime:0.002431s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (354066,544702,161095,1041227,356813,887129,77459,322239,107163,494001,446945,101873,372703,1042224,976595,125601,631504,49859,988176,672250,846,350082,871332,123831,916211,158882,546698,606678,824693,556219,784798,1031962,904468,814347,1029649,287933,431007,481474,113552,889170,497930,930061,984408,1000932,83098,229978,483478,370784,668778,248434,567091,50151,180148,443656,804341,411593,892895,330394,610398,677363) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001564s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 291685 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.004584s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 291685 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000684s ]