SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001189s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 304010 LIMIT 1 [ RunTime:0.000383s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 304010 [ RunTime:0.001484s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (174178,458881,355814,930615,907304,176195,299569,577905,530287,598300,977042,914650,330547,269189,931421,522913,141890,568050,92234,1017139,1005378,141036,1035106,671756,985273,16037,351983,545840,679499,857048,503899,541820,506126,229455,1001044,410166,772993,211458,48268,290480,666941,12248,582096,806342,804032,265169,850546,660929,733477,715467,740390,838594,874624,217268,471550,885179,647250,798213,925723,723477) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001239s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 304010 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000391s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 304010 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000554s ]