Query time 0.01274
JSON explain
{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "191.71"
},
"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 (1660621,1663150,1664049,1658333,1658334,1664157,1658506,1657840,1657777,1658557,1661197,1662527,1658427,1658811,1658265,1663182,1658593,1660401,1658270,1663613,1659564,1658864,1657833,1662451,1661407,1659246,1663612,2099795,1660547,1660154,1659920,1659832,1658398,1658504,1661697,1661022)))",
"cost_info": {
"read_cost": "73.21",
"eval_cost": "3.60",
"prefix_cost": "76.81",
"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.93",
"eval_cost": "3.60",
"prefix_cost": "116.34",
"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.77",
"eval_cost": "3.60",
"prefix_cost": "155.71",
"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 |
| 3642880 |
1657777 |
product |
0 |
3643133 |
M |
0 |
|
|
|
|
|
| 3642942 |
1657833 |
product |
0 |
3643195 |
M |
0 |
|
|
|
|
|
| 3642949 |
1657840 |
product |
0 |
3643202 |
M |
0 |
|
|
|
|
|
| 3643505 |
1658265 |
product |
0 |
3643758 |
M |
0 |
|
|
|
|
|
| 3643510 |
1658270 |
product |
0 |
3643763 |
M |
0 |
|
|
|
|
|
| 3643578 |
1658333 |
product |
0 |
3643831 |
M |
0 |
|
|
|
|
|
| 3643579 |
1658334 |
product |
0 |
3643832 |
M |
0 |
|
|
|
|
|
| 3643644 |
1658398 |
product |
0 |
3643897 |
M |
0 |
|
|
|
|
|
| 3643677 |
1658427 |
product |
0 |
3643930 |
M |
0 |
|
|
|
|
|
| 3643758 |
1658504 |
product |
0 |
3644011 |
M |
0 |
|
|
|
|
|
| 3643760 |
1658506 |
product |
0 |
3644013 |
M |
0 |
|
|
|
|
|
| 3643811 |
1658557 |
product |
0 |
3644064 |
M |
0 |
|
|
|
|
|
| 3643851 |
1658593 |
product |
0 |
3644104 |
M |
0 |
|
|
|
|
|
| 3644080 |
1658811 |
product |
0 |
3644333 |
M |
0 |
|
|
|
|
|
| 3644136 |
1658864 |
product |
0 |
3644389 |
M |
0 |
|
|
|
|
|
| 3644537 |
1659246 |
product |
0 |
3644790 |
M |
0 |
|
|
|
|
|
| 3644869 |
1659564 |
product |
0 |
3645122 |
M |
0 |
|
|
|
|
|
| 3645142 |
1659832 |
product |
0 |
3645395 |
M |
0 |
|
|
|
|
|
| 3645231 |
1659920 |
product |
0 |
3645484 |
M |
0 |
|
|
|
|
|
| 3645476 |
1660154 |
product |
0 |
3645729 |
M |
0 |
|
|
|
|
|
| 3645727 |
1660401 |
product |
0 |
3645980 |
M |
0 |
|
|
|
|
|
| 3645873 |
1660547 |
product |
0 |
3646126 |
M |
0 |
|
|
|
|
|
| 3645947 |
1660621 |
product |
0 |
3646200 |
M |
0 |
|
|
|
|
|
| 3646365 |
1661022 |
product |
0 |
3646618 |
M |
0 |
|
|
|
|
|
| 3646541 |
1661197 |
product |
0 |
3646794 |
M |
0 |
|
|
|
|
|
| 3646754 |
1661407 |
product |
0 |
3647007 |
M |
0 |
|
|
|
|
|
| 3647044 |
1661697 |
product |
0 |
3647297 |
M |
0 |
|
|
|
|
|
| 3647793 |
1662451 |
product |
0 |
3648046 |
M |
0 |
|
|
|
|
|
| 3647869 |
1662527 |
product |
0 |
3648122 |
M |
0 |
|
|
|
|
|
| 3648492 |
1663150 |
product |
0 |
3648745 |
M |
0 |
|
|
|
|
|
| 3648524 |
1663182 |
product |
0 |
3648777 |
M |
0 |
|
|
|
|
|
| 3648954 |
1663612 |
product |
0 |
3649207 |
M |
0 |
|
|
|
|
|
| 3648955 |
1663613 |
product |
0 |
3649208 |
M |
0 |
|
|
|
|
|
| 3649399 |
1664049 |
product |
0 |
3649652 |
M |
0 |
|
|
|
|
|
| 3649507 |
1664157 |
product |
0 |
3649760 |
M |
0 |
|
|
|
|
|
| 5161675 |
2099795 |
product |
0 |
5161928 |
M |
0 |
|
|
|
|
|