{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "168.88"
},
"table": {
"table_name": "cscart_logos",
"access_type": "ALL",
"rows_examined_per_scan": 1659,
"rows_produced_per_join": 1,
"filtered": "0.08",
"cost_info": {
"read_cost": "168.75",
"eval_cost": "0.13",
"prefix_cost": "168.89",
"data_read_per_join": "350"
},
"used_columns": [
"logo_id",
"layout_id",
"style_id",
"company_id",
"type",
"storefront_id"
],
"attached_condition": "((`cscartdb`.`cscart_logos`.`company_id` = 6) and (`cscartdb`.`cscart_logos`.`layout_id` in (3,0)) and (`cscartdb`.`cscart_logos`.`style_id` in ('spice black theme','')) and (`cscartdb`.`cscart_logos`.`storefront_id` in (1,0)))"
}
}
}
logo_id | layout_id | style_id | company_id | type | storefront_id |
---|---|---|---|---|---|
39 | 0 | 6 | theme | 0 | |
40 | 0 | 6 | 0 | ||
56 | 0 | 6 | vendor_banner | 1 |