mysql commands:

1) create indexing for every field wherever you are using "where" condintion in the query. 2) "in " should not be used in the query instead use array list . 3) for fetching codes(pcode,ccode,dcode etc) use limit 1 for fast exceution of query.