SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001395s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 271958 LIMIT 1 [ RunTime:0.002552s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 271958 [ RunTime:0.003580s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (18640,342580,401413,526164,215314,786285,834694,175171,977181,32504,948681,1039224,426193,670380,34991,666652,534635,40885,467430,577138,833696,695045,188076,293187,379785,766122,867316,948307,586036,82538,607458,589177,442899,451745,118273,134096,146099,1024095,560467,482907,193605,910269,811646,86971,379269,592961,470907,267185,896577,393277,785342,479578,501994,548529,26541,171120,561961,672741,122065,170817) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001339s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 271958 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000638s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 271958 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000632s ]