Query time 0.00171
JSON explain
{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "228.81"
},
"ordering_operation": {
"using_filesort": true,
"cost_info": {
"sort_cost": "41.00"
},
"nested_loop": [
{
"table": {
"table_name": "q_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": 41,
"rows_produced_per_join": 41,
"filtered": "100.00",
"index_condition": "((`portal`.`q_images_links`.`object_type` = 'product') and (`portal`.`q_images_links`.`type` = 'A') and (`portal`.`q_images_links`.`object_id` in ('8501','8503','8504','8506','8507','8508','8509','8510','8511','8512','8514','8515','8516','8517','8518','8519','8521','8477','8476','8474','8377','8376','8375','8374','8368','8367','8272','8271','8270','8269','8268','8267')))",
"cost_info": {
"read_cost": "81.21",
"eval_cost": "8.20",
"prefix_cost": "89.41",
"data_read_per_join": "3K"
},
"used_columns": [
"pair_id",
"object_id",
"object_type",
"image_id",
"detailed_id",
"type",
"position"
]
}
},
{
"table": {
"table_name": "q_images",
"access_type": "eq_ref",
"possible_keys": [
"PRIMARY"
],
"key": "PRIMARY",
"used_key_parts": [
"image_id"
],
"key_length": "4",
"ref": [
"portal.q_images_links.image_id"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 41,
"filtered": "100.00",
"cost_info": {
"read_cost": "41.00",
"eval_cost": "8.20",
"prefix_cost": "138.61",
"data_read_per_join": "31K"
},
"used_columns": [
"image_id",
"image_path",
"image_x",
"image_y",
"is_high_res"
]
}
},
{
"table": {
"table_name": "q_common_descriptions",
"access_type": "eq_ref",
"possible_keys": [
"PRIMARY"
],
"key": "PRIMARY",
"used_key_parts": [
"object_id",
"lang_code",
"object_holder"
],
"key_length": "107",
"ref": [
"portal.q_images.image_id",
"const",
"const"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 41,
"filtered": "100.00",
"cost_info": {
"read_cost": "41.00",
"eval_cost": "8.20",
"prefix_cost": "187.81",
"data_read_per_join": "24K"
},
"used_columns": [
"object_id",
"description",
"lang_code",
"object_holder"
],
"attached_condition": "<if>(is_not_null_compl(q_common_descriptions), (`portal`.`q_common_descriptions`.`object_id` = `portal`.`q_images`.`image_id`), true)"
}
}
]
}
}
}
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 |
0 |
|
|
|
|
17241 |
8269 |
product |
19203 |
A |
1 |
|
|
0 |
|
|
|
|
17246 |
8271 |
product |
19208 |
A |
1 |
|
|
0 |
|
|
|
|
17252 |
8272 |
product |
19214 |
A |
1 |
|
|
0 |
|
|
|
|
17496 |
8367 |
product |
19458 |
A |
1 |
|
|
0 |
|
|
|
|
17499 |
8368 |
product |
19461 |
A |
1 |
|
|
0 |
|
|
|
|
17516 |
8374 |
product |
19478 |
A |
1 |
|
|
0 |
|
|
|
|
17518 |
8375 |
product |
19480 |
A |
1 |
|
|
0 |
|
|
|
|
17520 |
8376 |
product |
19482 |
A |
1 |
|
|
0 |
|
|
|
|
17545 |
8377 |
product |
19507 |
A |
1 |
|
|
0 |
|
|
|
|
17941 |
8476 |
product |
19903 |
A |
1 |
|
|
0 |
|
|
|
|
18290 |
8514 |
product |
20252 |
A |
1 |
|
|
0 |
|
|
|
|
18298 |
8521 |
product |
20260 |
A |
1 |
|
|
0 |
|
|
|
|
18325 |
8504 |
product |
20287 |
A |
1 |
|
|
0 |
|
|
|
|
18328 |
8510 |
product |
20290 |
A |
1 |
|
|
0 |
|
|
|
|
18330 |
8511 |
product |
20292 |
A |
1 |
|
|
0 |
|
|
|
|
18332 |
8507 |
product |
20294 |
A |
1 |
|
|
0 |
|
|
|
|
18334 |
8515 |
product |
20296 |
A |
1 |
|
|
0 |
|
|
|
|
18337 |
8508 |
product |
20299 |
A |
1 |
|
|
0 |
|
|
|
|
18344 |
8512 |
product |
20306 |
A |
1 |
|
|
0 |
|
|
|
|
18346 |
8517 |
product |
20308 |
A |
1 |
|
|
0 |
|
|
|
|
18348 |
8518 |
product |
20310 |
A |
1 |
|
|
0 |
|
|
|
|
18750 |
8270 |
product |
20712 |
A |
1 |
|
|
0 |
|
|
|
|
19342 |
8477 |
product |
21304 |
A |
1 |
|
|
0 |
|
|
|
|
19581 |
8509 |
product |
21543 |
A |
1 |
|
|
0 |
|
|
|
|
17244 |
8270 |
product |
19206 |
A |
2 |
|
|
0 |
|
|
|
|
17247 |
8271 |
product |
19209 |
A |
2 |
|
|
0 |
|
|
|
|
17521 |
8376 |
product |
19483 |
A |
2 |
|
|
0 |
|
|
|
|
18291 |
8514 |
product |
20253 |
A |
2 |
|
|
0 |
|
|
|
|
18299 |
8521 |
product |
20261 |
A |
2 |
|
|
0 |
|
|
|
|
18326 |
8504 |
product |
20288 |
A |
2 |
|
|
0 |
|
|
|
|
18331 |
8507 |
product |
20293 |
A |
2 |
|
|
0 |
|
|
|
|
18338 |
8508 |
product |
20300 |
A |
2 |
|
|
0 |
|
|
|
|
18349 |
8518 |
product |
20311 |
A |
2 |
|
|
0 |
|
|
|
|
19582 |
8509 |
product |
21544 |
A |
2 |
|
|
0 |
|
|
|
|
19584 |
8519 |
product |
21546 |
A |
2 |
|
|
0 |
|
|
|
|
17248 |
8271 |
product |
19210 |
A |
3 |
|
|
0 |
|
|
|
|
18751 |
8270 |
product |
20713 |
A |
3 |
|
|
0 |
|
|
|
|
19343 |
8477 |
product |
21305 |
A |
3 |
|
|
0 |
|
|
|
|
19585 |
8519 |
product |
21547 |
A |
3 |
|
|
0 |
|
|
|
|
17249 |
8271 |
product |
19211 |
A |
4 |
|
|
0 |
|
|
|
|
19344 |
8477 |
product |
21306 |
A |
4 |
|
|
0 |
|
|
|
|
17250 |
8271 |
product |
19212 |
A |
5 |
|
|