SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001223s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 490308 LIMIT 1 [ RunTime:0.000470s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 490308 [ RunTime:0.001936s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (849704,529615,474439,523905,431527,489992,837017,984785,151166,204175,464560,366303,157606,633352,766524,985759,270213,773772,299318,1017992,235381,964802,694775,30144,821543,815515,707960,870451,62600,392108,96626,125250,366975,356704,708302,831236,947842,254264,1038513,815237,548531,560534,1044187,422923,183923,123974,982971,642668,1036591,91510,71519,473764,484001,576017,19221,582663,205253,947281,928412,1006738) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001073s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 490308 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000437s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 490308 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001277s ]