php - How to speed up MYSQL query with Multiple Join tables -

Do not get me in trouble with my questions, they move to the product results of age. I have only 13,000 records in the main table, and then link to other tables which is mainly used their inside connecting tables with a dozen or so records

I first sequencing But only when the query is used is not being included in one table and the other.

Here's my query

  SELECT product_data.id ASC, product_data.sku AS screw, product_data.barcode as barcode, product_data. Title AS title, product_data.attrib_releasedate AS attrib_releasedate, product_category_main.id AS Sreni_man_aidi, product_category_main.name AS Sreni_man_diskripshn, product_category_sub.id AS Sreni_subi_aidi, Utpad_gt_subi.am ASC Sreni_sb_deskripshn, Utpad_grahik_sb_deskrip_sort AS On_id, as product_condition.name condition_description, attrib_pegi.name aS attrib_pegi, attrib_region.name aS attrib_region, product_data.asin asin, from Utpad_deta as Product_datakcex Cex Utpad_deta on Utpadk_detaim productive category. Product_category_sub is included on category_man_id = product_category_main.id product_data. Category_sub_id = product_category_sub.id LEFT JOIN product_condition ON product_data.condition_id = = product_data.attrib_region on attrib_region.id to leave product_condition.id attrib_pegi on attrib_pegi.id = product_data.attrib_pegi Leave attrib_region WHERE title & lt; & Gt; '' And product_category_main.id = 1 Sreni_man_aidi by Category, Title