SELECT 
  * 
FROM 
  cscart_mobile_admin_app_stores 
WHERE 
  type = 'C'

Query time 0.00066

Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE cscart_mobile_admin_app_stores ALL 2 Using where

Result

company_id type access_id url home_page_content url_for_twitter url_for_facebook logo_url favicon_url url_on_appstore url_on_googleplay geolocation only_req_profile_fields show_product_code use_for_phones use_for_tablets send_order_status_push push_subscribers_android push_subscribers_ios plan_display_name repo_revision
1 C FCGHRL https://ecommerce.entekhabgroup.ir/index.php?dispatch=twigmo.post home_page_blocks N N N Y Y Y 0 0 Ultimate 1511867155