SELECT 
  * 
FROM 
  cscart_promotions 
WHERE 
  company_id = 179 
  AND status = "A" 
  AND zone = "catalog" 
  AND from_date <= 1727022209 
  AND to_date >= 1727022209

Query time 0.00072

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "8.70"
    },
    "table": {
      "table_name": "cscart_promotions",
      "access_type": "ALL",
      "rows_examined_per_scan": 46,
      "rows_produced_per_join": 1,
      "filtered": "2.17",
      "cost_info": {
        "read_cost": "8.60",
        "eval_cost": "0.10",
        "prefix_cost": "8.70",
        "data_read_per_join": "88"
      },
      "used_columns": [
        "promotion_id",
        "company_id",
        "conditions",
        "bonuses",
        "to_date",
        "from_date",
        "priority",
        "stop",
        "stop_other_rules",
        "zone",
        "conditions_hash",
        "status",
        "number_of_usages",
        "users_conditions_hash",
        "is_unlimited",
        "limitations_use"
      ],
      "attached_condition": "((`cscartdb`.`cscart_promotions`.`company_id` = 179) and (`cscartdb`.`cscart_promotions`.`status` = 'A') and (`cscartdb`.`cscart_promotions`.`zone` = 'catalog') and (`cscartdb`.`cscart_promotions`.`from_date` <= 1727022209) and (`cscartdb`.`cscart_promotions`.`to_date` >= 1727022209))"
    }
  }
}