SELECT 
  text_up, 
  text_bottom, 
  meta_description, 
  meta_keywords, 
  meta_title as page_title, 
  h1 
FROM 
  cscart_cp_power_seo_filter_additional_text 
  LEFT JOIN cscart_cp_power_seo_filter_additional_text_description ON cscart_cp_power_seo_filter_additional_text.text_id = cscart_cp_power_seo_filter_additional_text_description.text_id 
WHERE 
  1 
  AND url = '/yedek-parcalar/sogutma-parcalari/motor-su-radyatoru/su-radyatoru-bsg-17118617905-clone-clone-clone-tr/' 
  AND status = 'A' 
  AND lang_code = 'tr'

Query time 0.00016

Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE Impossible WHERE noticed after reading const tables