SELECT z.`train_num`,z.`train_basemode`, z.`train_brake`, z.train_drag,z.`train_shock`,

         b.`dict_text` AS basemode,a.`dict_text` AS brake ,c.`dict_text` AS traintype,d.dict_text AS machinetype,          e.dict_text AS traindrag,  f.dict_text AS trainshock   FROM t_b_train  z INNER JOIN t_sys_dictionary a ON   z.`train_brake`  = a.`id` INNER JOIN t_sys_dictionary b  ON  z.`train_basemode`=b.`id` INNER JOIN t_sys_dictionary c  ON  z.`train_type`=c.`id` INNER JOIN t_sys_dictionary d  ON z.machine_type = d.`id` INNER JOIN t_sys_dictionary e  ON z.train_drag = e.`id` INNER JOIN t_sys_dictionary f  ON z.train_shock = f.`id`