Query time 0.00347
JSON explain
{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "404.81"
},
"ordering_operation": {
"using_filesort": true,
"cost_info": {
"sort_cost": "71.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": 71,
"rows_produced_per_join": 71,
"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 ('6415','6416','6417','6418','6419','6420','6421','6422','6423','6424','6425','6426','6427','6428','6429','6430','6431','6432','6433','6434','6435','6436','6437','6438','6439','6440','6441','6442','6443','6444','6445','6446','6447','6448','6449','6450','6451','6452','6453','6454','6456','6457','6458','6459','6460','6461','6462','6463','6464','6465','6466','6467','6468','6469','6470','6471','6472','6473','6474','6475','6476','6477','6478','6479')))",
"cost_info": {
"read_cost": "149.21",
"eval_cost": "14.20",
"prefix_cost": "163.41",
"data_read_per_join": "6K"
},
"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": 71,
"filtered": "100.00",
"cost_info": {
"read_cost": "71.00",
"eval_cost": "14.20",
"prefix_cost": "248.61",
"data_read_per_join": "54K"
},
"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": 71,
"filtered": "100.00",
"cost_info": {
"read_cost": "71.00",
"eval_cost": "14.20",
"prefix_cost": "333.81",
"data_read_per_join": "42K"
},
"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 |
|
|
|
|
12860 |
6469 |
product |
14822 |
A |
1 |
|
|
0 |
|
|
|
|
13475 |
6423 |
product |
15437 |
A |
10 |
|
|
0 |
|
|
|
|
13476 |
6424 |
product |
15438 |
A |
10 |
|
|
0 |
|
|
|
|
13478 |
6425 |
product |
15440 |
A |
10 |
|
|
0 |
|
|
|
|
13480 |
6426 |
product |
15442 |
A |
10 |
|
|
0 |
|
|
|
|
13481 |
6427 |
product |
15443 |
A |
10 |
|
|
0 |
|
|
|
|
13482 |
6428 |
product |
15444 |
A |
10 |
|
|
0 |
|
|
|
|
13483 |
6431 |
product |
15445 |
A |
10 |
|
|
0 |
|
|
|
|
13485 |
6441 |
product |
15447 |
A |
10 |
|
|
0 |
|
|
|
|
13486 |
6442 |
product |
15448 |
A |
10 |
|
|
0 |
|
|
|
|
13487 |
6443 |
product |
15449 |
A |
10 |
|
|
0 |
|
|
|
|
13488 |
6444 |
product |
15450 |
A |
10 |
|
|
0 |
|
|
|
|
13490 |
6445 |
product |
15452 |
A |
10 |
|
|
0 |
|
|
|
|
13492 |
6446 |
product |
15454 |
A |
10 |
|
|
0 |
|
|
|
|
13495 |
6447 |
product |
15457 |
A |
10 |
|
|
0 |
|
|
|
|
13497 |
6448 |
product |
15459 |
A |
10 |
|
|
0 |
|
|
|
|
13500 |
6452 |
product |
15462 |
A |
10 |
|
|
0 |
|
|
|
|
13505 |
6453 |
product |
15467 |
A |
10 |
|
|
0 |
|
|
|
|
13506 |
6454 |
product |
15468 |
A |
10 |
|
|
0 |
|
|
|
|
13510 |
6456 |
product |
15472 |
A |
10 |
|
|
0 |
|
|
|
|
13514 |
6458 |
product |
15476 |
A |
10 |
|
|
0 |
|
|
|
|
13515 |
6459 |
product |
15477 |
A |
10 |
|
|
0 |
|
|
|
|
13516 |
6460 |
product |
15478 |
A |
10 |
|
|
0 |
|
|
|
|
13518 |
6461 |
product |
15480 |
A |
10 |
|
|
0 |
|
|
|
|
13519 |
6462 |
product |
15481 |
A |
10 |
|
|
0 |
|
|
|
|
13520 |
6463 |
product |
15482 |
A |
10 |
|
|
0 |
|
|
|
|
13521 |
6464 |
product |
15483 |
A |
10 |
|
|
0 |
|
|
|
|
15889 |
6457 |
product |
17851 |
A |
11 |
|
|
0 |
|
|
|
|
13477 |
6424 |
product |
15439 |
A |
20 |
|
|
0 |
|
|
|
|
13479 |
6425 |
product |
15441 |
A |
20 |
|
|
0 |
|
|
|
|
13484 |
6431 |
product |
15446 |
A |
20 |
|
|
0 |
|
|
|
|
13489 |
6444 |
product |
15451 |
A |
20 |
|
|
0 |
|
|
|
|
13491 |
6445 |
product |
15453 |
A |
20 |
|
|
0 |
|
|
|
|
13493 |
6446 |
product |
15455 |
A |
20 |
|
|
0 |
|
|
|
|
13496 |
6447 |
product |
15458 |
A |
20 |
|
|
0 |
|
|
|
|
13498 |
6448 |
product |
15460 |
A |
20 |
|
|
0 |
|
|
|
|
13501 |
6452 |
product |
15463 |
A |
20 |
|
|
0 |
|
|
|
|
13507 |
6454 |
product |
15469 |
A |
20 |
|
|
0 |
|
|
|
|
13511 |
6456 |
product |
15473 |
A |
20 |
|
|
0 |
|
|
|
|
13517 |
6460 |
product |
15479 |
A |
20 |
|
|
0 |
|
|
|
|
13494 |
6446 |
product |
15456 |
A |
30 |
|
|
0 |
|
|
|
|
13499 |
6448 |
product |
15461 |
A |
30 |
|
|
0 |
|
|
|
|
13502 |
6452 |
product |
15464 |
A |
30 |
|
|
0 |
|
|
|
|
13508 |
6454 |
product |
15470 |
A |
30 |
|
|
0 |
|
|
|
|
13512 |
6456 |
product |
15474 |
A |
30 |
|
|
0 |
|
|
|
|
13503 |
6452 |
product |
15465 |
A |
40 |
|
|
0 |
|
|
|
|
13504 |
6452 |
product |
15466 |
A |
50 |
|
|