Query time 0.00843
JSON explain
{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "191.13"
},
"ordering_operation": {
"using_filesort": true,
"cost_info": {
"sort_cost": "36.00"
},
"nested_loop": [
{
"table": {
"table_name": "cscart_images_links",
"access_type": "range",
"possible_keys": [
"object_id"
],
"key": "object_id",
"used_key_parts": [
"object_id",
"object_type",
"type"
],
"key_length": "81",
"rows_examined_per_scan": 36,
"rows_produced_per_join": 36,
"filtered": "100.00",
"index_condition": "((`maniamall_cscart`.`cscart_images_links`.`object_type` = 'product') and (`maniamall_cscart`.`cscart_images_links`.`type` = 'M') and (`maniamall_cscart`.`cscart_images_links`.`object_id` in (480519,524885,697773,866373,1118377,697683,612103,880671,1434961,694679,822677,614913,301401,822659,613219,613221,1025388,822679,1025367,1025365,1230911,1338749,1731846,1732251,359020,1153153,1153155,1338924,1231165,1731742,1732158,1231166,1732357,1153734,1732013,1663556)))",
"cost_info": {
"read_cost": "72.41",
"eval_cost": "3.60",
"prefix_cost": "76.01",
"data_read_per_join": "3K"
},
"used_columns": [
"pair_id",
"object_id",
"object_type",
"image_id",
"detailed_id",
"type",
"position"
]
}
},
{
"table": {
"table_name": "cscart_images",
"access_type": "eq_ref",
"possible_keys": [
"PRIMARY"
],
"key": "PRIMARY",
"used_key_parts": [
"image_id"
],
"key_length": "3",
"ref": [
"maniamall_cscart.cscart_images_links.image_id"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 36,
"filtered": "100.00",
"cost_info": {
"read_cost": "35.98",
"eval_cost": "3.60",
"prefix_cost": "115.58",
"data_read_per_join": "27K"
},
"used_columns": [
"image_id",
"image_path",
"image_x",
"image_y"
],
"attached_condition": "<if>(is_not_null_compl(cscart_images), (`maniamall_cscart`.`cscart_images_links`.`image_id` = `maniamall_cscart`.`cscart_images`.`image_id`), true)"
}
},
{
"table": {
"table_name": "cscart_common_descriptions",
"access_type": "eq_ref",
"possible_keys": [
"PRIMARY"
],
"key": "PRIMARY",
"used_key_parts": [
"object_id",
"lang_code",
"object_holder"
],
"key_length": "107",
"ref": [
"maniamall_cscart.cscart_images.image_id",
"const",
"const"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 36,
"filtered": "100.00",
"cost_info": {
"read_cost": "35.94",
"eval_cost": "3.60",
"prefix_cost": "155.13",
"data_read_per_join": "21K"
},
"used_columns": [
"object_id",
"description",
"lang_code",
"object_holder"
],
"attached_condition": "<if>(is_not_null_compl(cscart_common_descriptions), (`maniamall_cscart`.`cscart_common_descriptions`.`object_id` = `maniamall_cscart`.`cscart_images`.`image_id`), true)"
}
}
]
}
}
}
Result
| pair_id |
object_id |
object_type |
image_id |
detailed_id |
type |
position |
image_path |
alt |
image_x |
image_y |
images_image_id |
| 460270 |
301401 |
product |
0 |
460507 |
M |
0 |
|
|
|
|
|
| 559117 |
359020 |
product |
0 |
559354 |
M |
0 |
|
|
|
|
|
| 769391 |
480519 |
product |
0 |
769628 |
M |
0 |
|
|
|
|
|
| 817200 |
524885 |
product |
0 |
817437 |
M |
0 |
|
|
|
|
|
| 957536 |
612103 |
product |
0 |
957773 |
M |
0 |
|
|
|
|
|
| 959300 |
613219 |
product |
0 |
959537 |
M |
0 |
|
|
|
|
|
| 959304 |
613221 |
product |
0 |
959541 |
M |
0 |
|
|
|
|
|
| 961970 |
614913 |
product |
0 |
962207 |
M |
0 |
|
|
|
|
|
| 1091851 |
694679 |
product |
0 |
1092088 |
M |
0 |
|
|
|
|
|
| 1095760 |
697683 |
product |
0 |
1095997 |
M |
0 |
|
|
|
|
|
| 1262194 |
822659 |
product |
0 |
1262431 |
M |
0 |
|
|
|
|
|
| 1262217 |
822677 |
product |
0 |
1262454 |
M |
0 |
|
|
|
|
|
| 1262221 |
822679 |
product |
0 |
1262458 |
M |
0 |
|
|
|
|
|
| 1337473 |
866373 |
product |
0 |
1337710 |
M |
0 |
|
|
|
|
|
| 1362929 |
880671 |
product |
0 |
1363166 |
M |
0 |
|
|
|
|
|
| 1580386 |
1025365 |
product |
0 |
1580623 |
M |
0 |
|
|
|
|
|
| 1580388 |
1025367 |
product |
0 |
1580625 |
M |
0 |
|
|
|
|
|
| 1580410 |
1025388 |
product |
0 |
1580647 |
M |
0 |
|
|
|
|
|
| 1764722 |
1118377 |
product |
0 |
1764961 |
M |
0 |
|
|
|
|
|
| 1856990 |
1153153 |
product |
0 |
1857242 |
M |
0 |
|
|
|
|
|
| 1856992 |
1153155 |
product |
0 |
1857244 |
M |
0 |
|
|
|
|
|
| 1859515 |
1153734 |
product |
0 |
1859767 |
M |
0 |
|
|
|
|
|
| 1990241 |
1230911 |
product |
0 |
1990493 |
M |
0 |
|
|
|
|
|
| 1990852 |
1231165 |
product |
0 |
1991104 |
M |
0 |
|
|
|
|
|
| 1990853 |
1231166 |
product |
0 |
1991105 |
M |
0 |
|
|
|
|
|
| 2251912 |
1338749 |
product |
0 |
2252164 |
M |
0 |
|
|
|
|
|
| 2252184 |
1338924 |
product |
0 |
2252436 |
M |
0 |
|
|
|
|
|
| 2581017 |
1434961 |
product |
0 |
2581270 |
M |
0 |
|
|
|
|
|
| 3373481 |
697773 |
product |
0 |
3373734 |
M |
0 |
|
|
|
|
|
| 3648898 |
1663556 |
product |
0 |
3649151 |
M |
0 |
|
|
|
|
|
| 3946704 |
1731742 |
product |
0 |
3946957 |
M |
0 |
|
|
|
|
|
| 3946878 |
1731846 |
product |
0 |
3947131 |
M |
0 |
|
|
|
|
|
| 3947127 |
1732013 |
product |
0 |
3947380 |
M |
0 |
|
|
|
|
|
| 3947349 |
1732158 |
product |
0 |
3947602 |
M |
0 |
|
|
|
|
|
| 3947488 |
1732251 |
product |
0 |
3947741 |
M |
0 |
|
|
|
|
|
| 3947673 |
1732357 |
product |
0 |
3947926 |
M |
0 |
|
|
|
|
|