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