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

Query time 0.00080

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

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
75 185 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:5999:"21077,20800,20801,20802,20713,20712,20784,20745,20871,20780,20781,20808,20678,20679,20790,20793,20726,20728,20985,20823,20828,20760,20723,20785,20720,20752,20869,20830,20742,20743,20740,20859,20750,20775,20815,20744,20778,20773,20753,20758,20837,20977,20955,20989,20994,20840,20734,20862,20731,20789,20855,20833,20872,20844,20960,20959,20954,20718,20765,20822,20797,20861,20851,20832,20852,20853,20866,20826,20709,20953,20867,20868,20958,20719,20970,20774,20978,20735,20983,20766,20748,20806,20858,20824,20717,20809,20831,20749,20835,20963,20761,20777,20847,20979,20730,20812,20796,20818,20945,20946,20938,20937,20932,20920,20923,20924,20927,20928,20929,20725,20947,20948,20950,20930,20899,20900,20901,20902,20907,20908,20910,20878,20879,20881,20882,20884,20918,21071,21068,21066,21055,21054,21041,21040,21034,21033,21027,21025,21018,21007,21002,20995,20998,21076,21067,21039,21030,21029,21016,21012,21011,21010,21008,66077,66076,66075,66074,66073,66072,66071,66070,66069,66068,66067,66066,66065,66064,66063,66062,66061,66060,66059,66058,66057,66056,66055,66054,66053,66052,66051,66050,66049,66048,66047,66046,66045,66044,66043,66042,66041,66040,66039,66038,66037,66036,66035,66034,66033,66032,66031,66030,66029,66028,66027,66026,66025,66024,66023,66022,66021,66020,66019,66018,66017,66016,66015,66014,66013,66012,66011,66010,66009,66008,66007,66006,66005,66004,66003,66002,66001,66000,65999,65998,65997,65996,65995,65994,63686,63687,63688,63689,63690,63691,63692,63693,63694,63695,63696,63697,63698,63699,63700,63701,63702,63703,63704,63705,63706,63707,63708,63709,63710,63711,63712,63713,63714,63715,63716,63717,63718,63719,63720,63721,63722,63723,63724,63725,63726,63727,63728,63729,63730,63731,63732,63733,63734,63735,63736,63737,63738,63739,63740,63741,63742,63743,63744,63745,63746,63747,63748,63749,63750,63751,63752,63753,63754,63755,63756,63757,63758,63759,63760,63761,63762,63763,63764,63765,63766,63767,63768,63769,63770,63771,63772,63773,63774,63775,63776,63777,63778,63779,63780,63781,63782,63783,63784,63785,63786,63787,63788,63789,63790,63791,63792,63793,63794,63795,63796,63797,63798,63799,63800,63801,63802,63803,63804,63805,63806,63807,63808,63809,63810,63811,63812,63813,63814,63815,63816,63817,63818,63819,63820,63821,63822,63823,63824,63825,63826,63827,63828,63829,63830,63831,63832,63833,63834,63835,63836,63837,63838,63839,63840,63841,63842,63843,63844,63845,63846,63847,63848,63849,63850,63851,63852,63853,63854,63855,63856,63857,63858,63859,63860,63861,63862,63863,63864,63865,63866,63867,63868,63869,63870,63871,63872,63873,63874,63875,63876,63877,63878,63879,63880,63881,63882,63883,63884,63885,63886,63887,63888,63889,63890,63891,63892,63893,63894,63895,63896,63897,63898,63899,63900,63901,63902,63903,63904,63905,63906,63907,63908,63909,63910,63912,63913,63914,63915,63916,63917,63918,63919,63920,63921,63922,63923,63924,63925,63926,63927,63928,63929,63930,63931,63932,63933,63934,63935,63936,63937,63938,63939,63940,63941,63942,63943,63944,63945,63946,63948,63949,63950,63951,63952,63953,63954,63955,63956,63957,63958,63959,63960,63961,63962,63963,63964,63965,63966,63967,63968,63969,63970,63971,63972,63973,63974,63975,63976,63977,63978,63979,63980,63981,63982,63983,63984,63985,63986,63987,63989,63990,63991,63992,63993,63994,63995,63996,63997,63998,63999,64000,64001,64002,64003,64004,64005,64006,64007,64008,64009,64010,64011,64012,64013,64014,64015,64016,64017,64018,64019,64020,64021,64022,64023,64024,64025,64026,64027,64028,64029,64030,64031,64032,64033,64034,64035,64036,64037,64038,64039,64040,64041,64042,64043,64044,64045,64046,64047,64048,64049,64050,64051,64052,64053,64054,64055,64056,64057,64058,64059,64060,64061,64062,64063,64064,64065,64066,64067,64068,64069,64070,64071,64072,64073,64074,64075,64076,64077,64078,64079,64080,64081,64082,64083,64084,64085,64086,64087,64088,64089,64090,64091,64092,64093,64094,64095,64096,64097,64098,64099,64100,64101,64102,64103,64104,64105,64106,64107,64108,64109,64110,64111,64112,64113,64114,64115,64116,64117,64118,64119,64120,64121,64122,64123,64124,64125,64126,64127,64128,64129,64130,64131,64132,64133,64134,64135,64136,64137,64138,64139,64140,64141,64142,64143,64144,64145,64146,64147,64148,64149,64150,64151,64152,64153,64154,64155,64156,64157,64158,64159,64160,64161,64162,64163,64164,64165,64166,64167,64168,64169,64170,64171,64172,64173,64174,64175,64176,64177,64178,64179,64180,64181,64182,64183,64184,64185,64186,64187,64188,64189,64190,64191,64192,64193,64194,64195,64196,64197,64198,64199,64200,64201,64202,64203,64204,64205,64206,64207,64208,64209,64210,64211,64212,64213,64214,64215,64216,64217,64218,64219,64220,64221,64222,64223,64224,64225,64226,64227,64228,64229,64230,64231,64232,64233,64234,64235,64236,64237,64238,64239,64240,64241,64242,64243,64244,64245,64246,64247,64248,64249,64250,64251,64252,64253,64254,64255,64256,64257,64258,64259,64260,64261,64262,64263,64264,64265,64266,64267,64268,64269,64270,64271,64272,64273,64274,64275,64276,64277,64278,64279,64280,64281,64282,64283,64284,64285,64286,64287,64288,64289,64290,64291,64292,64293,64294,64295,64296,64297,64298,64299,64300,64301,64302,64303,64304,64305,64306,64307,64308,64309,64310,64311,64312,64313,64314,64315,64316,64317,64318,64319,64320,64321,64322,64323,64324,64325,64326,64327,64328,64329,64330,64331,64332,64333,64334,64335,64336,64337,64338,64339,64340,64341,64342,64343,64344,64345,64346,64347,64348,64349,64350,64351,64352,64353,64354,64355,64356,64357,64358,64359,64360,64361,64362,64363,64364,64365,64366,64367,64368,64369,64370,64371,64372,64373,64374,64375,64376,64377,64378,64379,64380,64381,64382,64383,64384,64385,64386,64387,64388,64389,64390,64391,64392,64393,64394,64395,64396,64397,64398,64399,64400,64401,64402,64403,64404,64405,64406,64407,64408,64409,64410,64411,64412,64413,64414,64415,64416,64417,64418,64419,64420,64421,64422,64423,64424,64425,64426,64427,64428,64429,64430,64431,64432,64433,64434,64435,64436,64437,64438,64439,64440,64441,64442,64443,64444,64445,64446,64447,64448,64449,64450,64451";}}} 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 1724817600 0 N N catalog products=21077,20800,20801,20802,20713,20712,20784,20745,20871,20780,20781,20808,20678,20679,20790,20793,20726,20728,20985,20823,20828,20760,20723,20785,20720,20752,20869,20830,20742,20743,20740,20859,20750,20775,20815,20744,20778,20773,20753,20758,20837,20977,20955,20989,20994,20840,20734,20862,20731,20789,20855,20833,20872,20844,20960,20959,20954,20718,20765,20822,20797,20861,20851,20832,20852,20853,20866,20826,20709,20953,20867,20868,20958,20719,20970,20774,20978,20735,20983,20766,20748,20806,20858,20824,20717,20809,20831,20749,20835,20963,20761,20777,20847,20979,20730,20812,20796,20818,20945,20946,20938,20937,20932,20920,20923,20924,20927,20928,20929,20725,20947,20948,20950,20930,20899,20900,20901,20902,20907,20908,20910,20878,20879,20881,20882,20884,20918,21071,21068,21066,21055,21054,21041,21040,21034,21033,21027,21025,21018,21007,21002,20995,20998,21076,21067,21039,21030,21029,21016,21012,21011,21010,21008,66077,66076,66075,66074,66073,66072,66071,66070,66069,66068,66067,66066,66065,66064,66063,66062,66061,66060,66059,66058,66057,66056,66055,66054,66053,66052,66051,66050,66049,66048,66047,66046,66045,66044,66043,66042,66041,66040,66039,66038,66037,66036,66035,66034,66033,66032,66031,66030,66029,66028,66027,66026,66025,66024,66023,66022,66021,66020,66019,66018,66017,66016,66015,66014,66013,66012,66011,66010,66009,66008,66007,66006,66005,66004,66003,66002,66001,66000,65999,65998,65997,65996,65995,65994,63686,63687,63688,63689,63690,63691,63692,63693,63694,63695,63696,63697,63698,63699,63700,63701,63702,63703,63704,63705,63706,63707,63708,63709,63710,63711,63712,63713,63714,63715,63716,63717,63718,63719,63720,63721,63722,63723,63724,63725,63726,63727,63728,63729,63730,63731,63732,63733,63734,63735,63736,63737,63738,63739,63740,63741,63742,63743,63744,63745,63746,63747,63748,63749,63750,63751,63752,63753,63754,63755,63756,63757,63758,63759,63760,63761,63762,63763,63764,63765,63766,63767,63768,63769,63770,63771,63772,63773,63774,63775,63776,63777,63778,63779,63780,63781,63782,63783,63784,63785,63786,63787,63788,63789,63790,63791,63792,63793,63794,63795,63796,63797,63798,63799,63800,63801,63802,63803,63804,63805,63806,63807,63808,63809,63810,63811,63812,63813,63814,63815,63816,63817,63818,63819,63820,63821,63822,63823,63824,63825,63826,63827,63828,63829,63830,63831,63832,63833,63834,63835,63836,63837,63838,63839,63840,63841,63842,63843,63844,63845,63846,63847,63848,63849,63850,63851,63852,63853,63854,63855,63856,63857,63858,63859,63860,63861,63862,63863,63864,63865,63866,63867,63868,63869,63870,63871,63872,63873,63874,63875,63876,63877,63878,63879,63880,63881,63882,63883,63884,63885,63886,63887,63888,63889,63890,63891,63892,63893,63894,63895,63896,63897,63898,63899,63900,63901,63902,63903,63904,63905,63906,63907,63908,63909,63910,63912,63913,63914,63915,63916,63917,63918,63919,63920,63921,63922,63923,63924,63925,63926,63927,63928,63929,63930,63931,63932,63933,63934,63935,63936,63937,63938,63939,63940,63941,63942,63943,63944,63945,63946,63948,63949,63950,63951,63952,63953,63954,63955,63956,63957,63958,63959,63960,63961,63962,63963,63964,63965,63966,63967,63968,63969,63970,63971,63972,63973,63974,63975,63976,63977,63978,63979,63980,63981,63982,63983,63984,63985,63986,63987,63989,63990,63991,63992,63993,63994,63995,63996,63997,63998,63999,64000,64001,64002,64003,64004,64005,64006,64007,64008,64009,64010,64011,64012,64013,64014,64015,64016,64017,64018,64019,64020,64021,64022,64023,64024,64025,64026,64027,64028,64029,64030,64031,64032,64033,64034,64035,64036,64037,64038,64039,64040,64041,64042,64043,64044,64045,64046,64047,64048,64049,64050,64051,64052,64053,64054,64055,64056,64057,64058,64059,64060,64061,64062,64063,64064,64065,64066,64067,64068,64069,64070,64071,64072,64073,64074,64075,64076,64077,64078,64079,64080,64081,64082,64083,64084,64085,64086,64087,64088,64089,64090,64091,64092,64093,64094,64095,64096,64097,64098,64099,64100,64101,64102,64103,64104,64105,64106,64107,64108,64109,64110,64111,64112,64113,64114,64115,64116,64117,64118,64119,64120,64121,64122,64123,64124,64125,64126,64127,64128,64129,64130,64131,64132,64133,64134,64135,64136,64137,64138,64139,64140,64141,64142,64143,64144,64145,64146,64147,64148,64149,64150,64151,64152,64153,64154,64155,64156,64157,64158,64159,64160,64161,64162,64163,64164,64165,64166,64167,64168,64169,64170,64171,64172,64173,64174,64175,64176,64177,64178,64179,64180,64181,64182,64183,64184,64185,64186,64187,64188,64189,64190,64191,64192,64193,64194,64195,64196,64197,64198,64199,64200,64201,64202,64203,64204,64205,64206,64207,64208,64209,64210,64211,64212,64213,64214,64215,64216,64217,64218,64219,64220,64221,64222,64223,64224,64225,64226,64227,64228,64229,64230,64231,64232,64233,64234,64235,64236,64237,64238,64239,64240,64241,64242,64243,64244,64245,64246,64247,64248,64249,64250,64251,64252,64253,64254,64255,64256,64257,64258,64259,64260,64261,64262,64263,64264,64265,64266,64267,64268,64269,64270,64271,64272,64273,64274,64275,64276,64277,64278,64279,64280,64281,64282,64283,64284,64285,64286,64287,64288,64289,64290,64291,64292,64293,64294,64295,64296,64297,64298,64299,64300,64301,64302,64303,64304,64305,64306,64307,64308,64309,64310,64311,64312,64313,64314,64315,64316,64317,64318,64319,64320,64321,64322,64323,64324,64325,64326,64327,64328,64329,64330,64331,64332,64333,64334,64335,64336,64337,64338,64339,64340,64341,64342,64343,64344,64345,64346,64347,64348,64349,64350,64351,64352,64353,64354,64355,64356,64357,64358,64359,64360,64361,64362,64363,64364,64365,64366,64367,64368,64369,64370,64371,64372,64373,64374,64375,64376,64377,64378,64379,64380,64381,64382,64383,64384,64385,64386,64387,64388,64389,64390,64391,64392,64393,64394,64395,64396,64397,64398,64399,64400,64401,64402,64403,64404,64405,64406,64407,64408,64409,64410,64411,64412,64413,64414,64415,64416,64417,64418,64419,64420,64421,64422,64423,64424,64425,64426,64427,64428,64429,64430,64431,64432,64433,64434,64435,64436,64437,64438,64439,64440,64441,64442,64443,64444,64445,64446,64447,64448,64449,64450,64451 A 0 1 0