Query time 0.00032
JSON explain
{
"query_block": {
"select_id": 1,
"read_sorted_file": {
"filesort": {
"sort_key": "cscart_images_links.position, cscart_images_links.pair_id",
"table": {
"table_name": "cscart_images_links",
"access_type": "range",
"possible_keys": ["object_id"],
"key": "object_id",
"key_length": "81",
"used_key_parts": ["object_id", "object_type", "type"],
"rows": 5,
"filtered": 100,
"index_condition": "cscart_images_links.object_type = 'logos' and cscart_images_links.`type` = 'M' and cscart_images_links.object_id in (11,437,438,439,440)"
}
}
},
"table": {
"table_name": "cscart_images",
"access_type": "eq_ref",
"possible_keys": ["PRIMARY"],
"key": "PRIMARY",
"key_length": "4",
"used_key_parts": ["image_id"],
"ref": ["ymonline_livedata.cscart_images_links.image_id"],
"rows": 1,
"filtered": 100
},
"table": {
"table_name": "cscart_common_descriptions",
"access_type": "eq_ref",
"possible_keys": ["PRIMARY"],
"key": "PRIMARY",
"key_length": "108",
"used_key_parts": ["object_id", "lang_code", "object_holder"],
"ref": ["ymonline_livedata.cscart_images.image_id", "const", "const"],
"rows": 1,
"filtered": 100,
"attached_condition": "trigcond(cscart_common_descriptions.object_holder = 'images' and cscart_common_descriptions.lang_code = 'en' and trigcond(cscart_images.image_id is not null))"
}
}
}
Result
image_id |
image_path |
image_x |
image_y |
is_high_res |
pair_id |
object_id |
object_type |
detailed_id |
type |
position |
alt |
images_image_id |
1999 |
Your_Mart_Small_Logo.png |
862 |
429 |
N |
1138 |
11 |
logos |
0 |
M |
0 |
YM Online Gift Certificate |
1999 |
12009 |
testlogin-removebg-preview__1_.png |
708 |
352 |
N |
11268 |
437 |
logos |
0 |
M |
0 |
Your Mart Online Logo |
12009 |
12010 |
Your_Mart_Fav_Icon.png |
16 |
16 |
N |
11269 |
438 |
logos |
0 |
M |
0 |
|
12010 |
12011 |
Your_Mart_Small_Logo_icyc-d5.png |
862 |
429 |
N |
11270 |
439 |
logos |
0 |
M |
0 |
Your Mart Logo |
12011 |
12012 |
Your_Mart_Small_Logo_pbpc-l1.png |
862 |
429 |
N |
11271 |
440 |
logos |
0 |
M |
0 |
|
12012 |