{
"query_block": {
"select_id": 1,
"read_sorted_file": {
"filesort": {
"sort_key": "cscart_attachments.position",
"table": {
"table_name": "cscart_attachments",
"access_type": "ref",
"possible_keys": ["object_type", "type"],
"key": "object_type",
"key_length": "95",
"used_key_parts": ["object_type", "object_id"],
"ref": ["const", "const"],
"rows": 1,
"filtered": 52.88888931,
"index_condition": "cscart_attachments.object_type = 'category_icon'",
"attached_condition": "cscart_attachments.object_type <=> 'category_icon' and cscart_attachments.object_id <=> 353 and cscart_attachments.`type` = 'C' and (cscart_attachments.usergroup_ids = '' or find_in_set(0,cscart_attachments.usergroup_ids) or find_in_set(1,cscart_attachments.usergroup_ids)) and cscart_attachments.`status` = 'A'"
}
}
},
"table": {
"table_name": "cscart_attachment_descriptions",
"access_type": "eq_ref",
"possible_keys": ["PRIMARY"],
"key": "PRIMARY",
"key_length": "9",
"used_key_parts": ["attachment_id", "lang_code"],
"ref": ["ymonline_livedata.cscart_attachments.attachment_id", "const"],
"rows": 1,
"filtered": 100,
"attached_condition": "trigcond(cscart_attachment_descriptions.lang_code = 'en')"
}
}
}
attachment_id | object_type | object_id | type | position | filename | filesize | usergroup_ids | status | url | on_server | description |
---|---|---|---|---|---|---|---|---|---|---|---|
213 | category_icon | 353 | C | 100 | watches.png | 21289 | 0 | A | Y | category_icon_data |