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

Query time 0.00078

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` = 404) and (`cscartdb`.`cscart_promotions`.`status` = 'A') and (`cscartdb`.`cscart_promotions`.`zone` = 'catalog') and (`cscartdb`.`cscart_promotions`.`from_date` <= 1727029429) and (`cscartdb`.`cscart_promotions`.`to_date` >= 1727029429))"
    }
  }
}

Result

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
68 404 a:3:{s:3:"set";s:3:"any";s:9:"set_value";i:1;s:10:"conditions";a:1:{i:0;a:3:{s:8:"operator";s:2:"in";s:9:"condition";s:8:"products";s:5:"value";s:2297:"57947,57946,63685,62970,57940,57936,57935,57934,57930,57929,57928,57911,57912,57913,57914,57915,57916,57917,57918,57919,57920,57922,57923,57924,57927,62917,63649,63650,63660,63661,63684,63671,63672,62676,63626,63627,63628,63460,63461,63462,63463,63464,63465,63466,63467,63468,63459,63458,63472,63473,63474,63475,63476,63477,63478,63479,63480,63471,63470,63483,63484,63485,63486,63487,63488,63489,63490,63491,63482,63481,63584,63585,63586,63587,63588,63589,63590,63591,63592,63583,63582,63494,63495,63496,63497,63498,63499,63500,63501,63502,63493,63492,63570,63571,63572,63573,63574,63575,63576,63577,63578,63579,63580,63581,63562,63563,63564,63565,63566,63567,63569,63559,63560,63561,63568,63634,63635,63636,63633,63629,63630,63631,63632,63595,63596,63597,63598,63599,63600,63601,63602,63603,63594,63593,63527,63528,63529,63530,63531,63532,63533,63534,63535,63526,63525,63606,63607,63608,63609,63610,63611,63612,63613,63614,63605,63604,63653,63654,63655,63656,63657,63658,63652,63648,63651,63617,63618,63619,63620,63621,63622,63623,63624,63625,63616,63615,63505,63506,63507,63508,63509,63510,63511,63512,63513,63504,63503,63664,63665,63666,63667,63668,63669,63663,63659,63662,63639,63640,63641,63642,63643,63644,63645,63646,63647,63638,63637,63675,63676,63677,63678,63679,63680,63674,63670,63673,63516,63517,63518,63519,63520,63521,63522,63523,63524,63515,63514,62992,62993,62994,62995,62996,62997,62998,62999,63000,62991,62990,62954,62955,62956,62957,62958,62959,62960,62961,62962,62963,62964,62965,62968,62969,62971,62972,62973,62974,62975,62976,62977,62978,62979,62980,62981,62982,62983,62984,62985,62986,62987,62988,62989,63001,63002,63003,63004,63005,63006,63007,63008,63009,63010,63011,63015,63016,63017,63018,63019,63020,63021,63022,63023,63024,63025,63029,63369,63371,63372,63373,63374,63375,63376,63377,63378,63379,63380,63381,63383,63384,63385,63386,63387,63388,63389,63390,63391,63392,63393,63394,63395,63396,63397,63398,63399,63400,63401,63402,63403,63404,63405,63406,63407,63408,63409,63410,63411,63412,63413,63414,63415,63416,63417,63418,63419,63420,63421,63422,63423,63424,63425,63426,63427,63428,63429,63430,63431,63432,63433,63434,63435,63436,63437,63438,63439,63440,63441,63442,63443,63444,63445,63446,63447,63448,63449,63450,63451,63452,63453,63454,63455,63456,63457,63682,63683";}}} a:1:{i:0;a:3:{s:5:"bonus";s:16:"product_discount";s:14:"discount_bonus";s:13:"by_percentage";s:14:"discount_value";s:2:"25";}} 1727755199 1723780800 0 N N catalog products=57947,57946,63685,62970,57940,57936,57935,57934,57930,57929,57928,57911,57912,57913,57914,57915,57916,57917,57918,57919,57920,57922,57923,57924,57927,62917,63649,63650,63660,63661,63684,63671,63672,62676,63626,63627,63628,63460,63461,63462,63463,63464,63465,63466,63467,63468,63459,63458,63472,63473,63474,63475,63476,63477,63478,63479,63480,63471,63470,63483,63484,63485,63486,63487,63488,63489,63490,63491,63482,63481,63584,63585,63586,63587,63588,63589,63590,63591,63592,63583,63582,63494,63495,63496,63497,63498,63499,63500,63501,63502,63493,63492,63570,63571,63572,63573,63574,63575,63576,63577,63578,63579,63580,63581,63562,63563,63564,63565,63566,63567,63569,63559,63560,63561,63568,63634,63635,63636,63633,63629,63630,63631,63632,63595,63596,63597,63598,63599,63600,63601,63602,63603,63594,63593,63527,63528,63529,63530,63531,63532,63533,63534,63535,63526,63525,63606,63607,63608,63609,63610,63611,63612,63613,63614,63605,63604,63653,63654,63655,63656,63657,63658,63652,63648,63651,63617,63618,63619,63620,63621,63622,63623,63624,63625,63616,63615,63505,63506,63507,63508,63509,63510,63511,63512,63513,63504,63503,63664,63665,63666,63667,63668,63669,63663,63659,63662,63639,63640,63641,63642,63643,63644,63645,63646,63647,63638,63637,63675,63676,63677,63678,63679,63680,63674,63670,63673,63516,63517,63518,63519,63520,63521,63522,63523,63524,63515,63514,62992,62993,62994,62995,62996,62997,62998,62999,63000,62991,62990,62954,62955,62956,62957,62958,62959,62960,62961,62962,62963,62964,62965,62968,62969,62971,62972,62973,62974,62975,62976,62977,62978,62979,62980,62981,62982,62983,62984,62985,62986,62987,62988,62989,63001,63002,63003,63004,63005,63006,63007,63008,63009,63010,63011,63015,63016,63017,63018,63019,63020,63021,63022,63023,63024,63025,63029,63369,63371,63372,63373,63374,63375,63376,63377,63378,63379,63380,63381,63383,63384,63385,63386,63387,63388,63389,63390,63391,63392,63393,63394,63395,63396,63397,63398,63399,63400,63401,63402,63403,63404,63405,63406,63407,63408,63409,63410,63411,63412,63413,63414,63415,63416,63417,63418,63419,63420,63421,63422,63423,63424,63425,63426,63427,63428,63429,63430,63431,63432,63433,63434,63435,63436,63437,63438,63439,63440,63441,63442,63443,63444,63445,63446,63447,63448,63449,63450,63451,63452,63453,63454,63455,63456,63457,63682,63683 A 0 1 0