SELECT 
  search_phrases 
FROM 
  cscart_ab__search_motivation 
WHERE 
  category_id > 0 
  AND company_id = 0 
  AND lang_code = 'en' 
  AND TRIM(search_phrases) > ""

Query time 0.00139

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "16.72"
    },
    "table": {
      "table_name": "cscart_ab__search_motivation",
      "access_type": "ALL",
      "possible_keys": [
        "PRIMARY"
      ],
      "rows_examined_per_scan": 160,
      "rows_produced_per_join": 1,
      "filtered": "1.00",
      "cost_info": {
        "read_cost": "16.56",
        "eval_cost": "0.16",
        "prefix_cost": "16.72",
        "data_read_per_join": "51"
      },
      "used_columns": [
        "category_id",
        "company_id",
        "lang_code",
        "search_phrases"
      ],
      "attached_condition": "((`s2cart`.`cscart_ab__search_motivation`.`company_id` = 0) and (`s2cart`.`cscart_ab__search_motivation`.`category_id` > 0) and (`s2cart`.`cscart_ab__search_motivation`.`lang_code` = 'en') and (trim(`s2cart`.`cscart_ab__search_motivation`.`search_phrases`) > ''))"
    }
  }
}

Result

search_phrases
Solar DCDB, Solar DC Distribution Box, Solar DC|AC DB, GEESYS Solar DCDB,
Solar Accessories, Solar ACDB, Solar ACDB, UV Cable Ties, Solar MMS
Inverter Battery, UPS Batteries, Electric Vehicle Batteries, Lithium Ion Batteries, SMF Batteries
Automatic Voltage Stabilizer, Servo Voltage Stabilizer, Static Voltage Stabilizer
Online UPS, Home Inverters, Batteries, Battery Trolleys
UPS, Online UPS, Industrial UPS, Uninterruptible Power Supply