{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "3.05"
},
"table": {
"table_name": "cscart_ab__video_gallery",
"access_type": "ALL",
"possible_keys": [
"status",
"product_id"
],
"rows_examined_per_scan": 28,
"rows_produced_per_join": 5,
"filtered": "20.00",
"cost_info": {
"read_cost": "2.49",
"eval_cost": "0.56",
"prefix_cost": "3.05",
"data_read_per_join": "537"
},
"used_columns": [
"video_id",
"product_id",
"status",
"storefront_id"
],
"attached_condition": "((`test_uchur_k`.`cscart_ab__video_gallery`.`product_id` in (18516,51007,51004,51005,51010,51008,51012,51013,51011,51015,51006,51021,51016,51024,51017,51019,51018,51022,51014,51045,51422,51025,51440,51424,51029,51442,51429,51060,51436,51430,51433,51027,51063,51020,51067,51423,51431,51435,51028,51031,51062,51042,51441,51432,51434,51030,51032,51033,51425,51026,51035,51059,51069,51070,51038,51066,51023,51041,51056,51040,51050,51065,51039,51052,51009,51034,51426,51036,51037,51068,51061,51064,51055,51058,51071)) and (`test_uchur_k`.`cscart_ab__video_gallery`.`status` = 'A') and (`test_uchur_k`.`cscart_ab__video_gallery`.`storefront_id` in (1,0)))"
}
}
}