Query time 0.00270
JSON explain
{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "416.01"
},
"ordering_operation": {
"using_filesort": true,
"cost_info": {
"sort_cost": "80.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": 80,
"rows_produced_per_join": 80,
"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 ('32554','32555','32556','32557','32558','32559','32560','32562','32563','32564','32565','32566','32567','32568','32569','32570','32571','32573','32574','32575','32576','32577','32579','32580','32581','32582','32583','32584','32585','32586','32588','32589')))",
"cost_info": {
"read_cost": "128.01",
"eval_cost": "16.00",
"prefix_cost": "144.01",
"data_read_per_join": "7K"
},
"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": 80,
"filtered": "100.00",
"cost_info": {
"read_cost": "80.00",
"eval_cost": "16.00",
"prefix_cost": "240.01",
"data_read_per_join": "61K"
},
"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": 80,
"filtered": "100.00",
"cost_info": {
"read_cost": "80.00",
"eval_cost": "16.00",
"prefix_cost": "336.01",
"data_read_per_join": "47K"
},
"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 |
|
|
|
|
42852 |
32581 |
product |
44814 |
A |
1 |
|
|
0 |
|
|
|
|
42831 |
32575 |
product |
44793 |
A |
2 |
|
|
0 |
|
|
|
|
42853 |
32581 |
product |
44815 |
A |
2 |
|
|
0 |
|
|
|
|
44436 |
32575 |
product |
46398 |
A |
3 |
|
|
0 |
|
|
|
|
42747 |
32554 |
product |
44709 |
A |
10 |
|
|
0 |
|
|
|
|
42751 |
32555 |
product |
44713 |
A |
10 |
|
|
0 |
|
|
|
|
42755 |
32556 |
product |
44717 |
A |
10 |
|
|
0 |
|
|
|
|
42759 |
32557 |
product |
44721 |
A |
10 |
|
|
0 |
|
|
|
|
42763 |
32558 |
product |
44725 |
A |
10 |
|
|
0 |
|
|
|
|
42767 |
32559 |
product |
44729 |
A |
10 |
|
|
0 |
|
|
|
|
42777 |
32560 |
product |
44739 |
A |
10 |
|
|
0 |
|
|
|
|
42790 |
32565 |
product |
44752 |
A |
10 |
|
|
0 |
|
|
|
|
42838 |
32577 |
product |
44800 |
A |
10 |
|
|
0 |
|
|
|
|
44368 |
32554 |
product |
46330 |
A |
10 |
|
|
0 |
|
|
|
|
44371 |
32555 |
product |
46333 |
A |
10 |
|
|
0 |
|
|
|
|
44375 |
32556 |
product |
46337 |
A |
10 |
|
|
0 |
|
|
|
|
44378 |
32557 |
product |
46340 |
A |
10 |
|
|
0 |
|
|
|
|
44382 |
32558 |
product |
46344 |
A |
10 |
|
|
0 |
|
|
|
|
44386 |
32559 |
product |
46348 |
A |
10 |
|
|
0 |
|
|
|
|
44390 |
32560 |
product |
46352 |
A |
10 |
|
|
0 |
|
|
|
|
44394 |
32562 |
product |
46356 |
A |
10 |
|
|
0 |
|
|
|
|
44403 |
32565 |
product |
46365 |
A |
10 |
|
|
0 |
|
|
|
|
44405 |
32566 |
product |
46367 |
A |
10 |
|
|
0 |
|
|
|
|
44423 |
32571 |
product |
46385 |
A |
10 |
|
|
0 |
|
|
|
|
44426 |
32573 |
product |
46388 |
A |
10 |
|
|
0 |
|
|
|
|
44483 |
32588 |
product |
46445 |
A |
10 |
|
|
0 |
|
|
|
|
44490 |
32589 |
product |
46452 |
A |
10 |
|
|
0 |
|
|
|
|
46585 |
32557 |
product |
48547 |
A |
10 |
|
|
0 |
|
|
|
|
46593 |
32558 |
product |
48555 |
A |
10 |
|
|
0 |
|
|
|
|
46609 |
32560 |
product |
48571 |
A |
10 |
|
|
0 |
|
|
|
|
46794 |
32589 |
product |
48756 |
A |
10 |
|
|
0 |
|
|
|
|
42756 |
32556 |
product |
44718 |
A |
20 |
|
|
0 |
|
|
|
|
42764 |
32558 |
product |
44726 |
A |
20 |
|
|
0 |
|
|
|
|
42778 |
32560 |
product |
44740 |
A |
20 |
|
|
0 |
|
|
|
|
42781 |
32562 |
product |
44743 |
A |
20 |
|
|
0 |
|
|
|
|
42791 |
32565 |
product |
44753 |
A |
20 |
|
|
0 |
|
|
|
|
42794 |
32566 |
product |
44756 |
A |
20 |
|
|
0 |
|
|
|
|
42813 |
32571 |
product |
44775 |
A |
20 |
|
|
0 |
|
|
|
|
42858 |
32582 |
product |
44820 |
A |
20 |
|
|
0 |
|
|
|
|
42862 |
32583 |
product |
44824 |
A |
20 |
|
|
0 |
|
|
|
|
44376 |
32556 |
product |
46338 |
A |
20 |
|
|
0 |
|
|
|
|
44383 |
32558 |
product |
46345 |
A |
20 |
|
|
0 |
|
|
|
|
44391 |
32560 |
product |
46353 |
A |
20 |
|
|
0 |
|
|
|
|
44397 |
32563 |
product |
46359 |
A |
20 |
|
|
0 |
|
|
|
|
44399 |
32564 |
product |
46361 |
A |
20 |
|
|
0 |
|
|
|
|
44404 |
32565 |
product |
46366 |
A |
20 |
|
|
0 |
|
|
|
|
44407 |
32566 |
product |
46369 |
A |
20 |
|
|
0 |
|
|
|
|
44411 |
32567 |
product |
46373 |
A |
20 |
|
|
0 |
|
|
|
|
44414 |
32568 |
product |
46376 |
A |
20 |
|
|
0 |
|
|
|
|
44418 |
32569 |
product |
46380 |
A |
20 |
|
|
0 |
|
|
|
|
44424 |
32571 |
product |
46386 |
A |
20 |
|
|
0 |
|
|
|
|
44428 |
32573 |
product |
46390 |
A |
20 |
|
|
0 |
|
|
|
|
44432 |
32574 |
product |
46394 |
A |
20 |
|
|
0 |
|
|
|
|
44438 |
32576 |
product |
46400 |
A |
20 |
|
|
0 |
|
|
|
|
44442 |
32577 |
product |
46404 |
A |
20 |
|
|
0 |
|
|
|
|
44446 |
32579 |
product |
46408 |
A |
20 |
|
|
0 |
|
|
|
|
44466 |
32583 |
product |
46428 |
A |
20 |
|
|
0 |
|
|
|
|
44470 |
32584 |
product |
46432 |
A |
20 |
|
|
0 |
|
|
|
|
44475 |
32585 |
product |
46437 |
A |
20 |
|
|
0 |
|
|
|
|
44480 |
32586 |
product |
46442 |
A |
20 |
|
|
0 |
|
|
|
|
44491 |
32589 |
product |
46453 |
A |
20 |
|
|
0 |
|
|
|
|
46581 |
32556 |
product |
48543 |
A |
20 |
|
|
0 |
|
|
|
|
46587 |
32557 |
product |
48549 |
A |
20 |
|
|
0 |
|
|
|
|
46595 |
32558 |
product |
48557 |
A |
20 |
|
|
0 |
|
|
|
|
46781 |
32586 |
product |
48743 |
A |
20 |
|
|
0 |
|
|
|
|
42757 |
32556 |
product |
44719 |
A |
30 |
|
|
0 |
|
|
|
|
42765 |
32558 |
product |
44727 |
A |
30 |
|
|
0 |
|
|
|
|
42769 |
32559 |
product |
44731 |
A |
30 |
|
|
0 |
|
|
|
|
42782 |
32562 |
product |
44744 |
A |
30 |
|
|
0 |
|
|
|
|
42785 |
32563 |
product |
44747 |
A |
30 |
|
|
0 |
|
|
|
|
42788 |
32564 |
product |
44750 |
A |
30 |
|
|
0 |
|
|
|
|
42795 |
32566 |
product |
44757 |
A |
30 |
|
|
0 |
|
|
|
|
42807 |
32569 |
product |
44769 |
A |
30 |
|
|
0 |
|
|
|
|
42821 |
32571 |
product |
44783 |
A |
30 |
|
|
0 |
|
|
|
|
42843 |
32577 |
product |
44805 |
A |
30 |
|
|
0 |
|
|
|
|
42851 |
32580 |
product |
44813 |
A |
30 |
|
|
0 |
|
|
|
|
42881 |
32588 |
product |
44843 |
A |
30 |
|
|
0 |
|
|
|
|
42885 |
32589 |
product |
44847 |
A |
30 |
|
|
0 |
|
|
|
|
44370 |
32554 |
product |
46332 |
A |
30 |
|
|
0 |
|
|
|
|
44377 |
32556 |
product |
46339 |
A |
30 |
|
|
0 |
|
|
|
|
44385 |
32558 |
product |
46347 |
A |
30 |
|
|
0 |
|
|
|
|
44389 |
32559 |
product |
46351 |
A |
30 |
|
|
0 |
|
|
|
|
44396 |
32562 |
product |
46358 |
A |
30 |
|
|
0 |
|
|
|
|
44398 |
32563 |
product |
46360 |
A |
30 |
|
|
0 |
|
|
|
|
44401 |
32564 |
product |
46363 |
A |
30 |
|
|
0 |
|
|
|
|
44408 |
32566 |
product |
46370 |
A |
30 |
|
|
0 |
|
|
|
|
44412 |
32567 |
product |
46374 |
A |
30 |
|
|
0 |
|
|
|
|
44416 |
32568 |
product |
46378 |
A |
30 |
|
|
0 |
|
|
|
|
44422 |
32570 |
product |
46384 |
A |
30 |
|
|
0 |
|
|
|
|
44425 |
32571 |
product |
46387 |
A |
30 |
|
|
0 |
|
|
|
|
44430 |
32573 |
product |
46392 |
A |
30 |
|
|
0 |
|
|
|
|
44433 |
32574 |
product |
46395 |
A |
30 |
|
|
0 |
|
|
|
|
44440 |
32576 |
product |
46402 |
A |
30 |
|
|
0 |
|
|
|
|
44447 |
32579 |
product |
46409 |
A |
30 |
|
|
0 |
|
|
|
|
44464 |
32582 |
product |
46426 |
A |
30 |
|
|
0 |
|
|
|
|
44468 |
32583 |
product |
46430 |
A |
30 |
|
|
0 |
|
|
|
|
44472 |
32584 |
product |
46434 |
A |
30 |
|
|
0 |
|
|
|
|
44478 |
32585 |
product |
46440 |
A |
30 |
|
|
0 |
|
|
|
|
44482 |
32586 |
product |
46444 |
A |
30 |
|
|
0 |
|
|
|
|
44486 |
32588 |
product |
46448 |
A |
30 |
|
|
0 |
|
|
|
|
46569 |
32554 |
product |
48531 |
A |
30 |
|
|
0 |
|
|
|
|
46576 |
32555 |
product |
48538 |
A |
30 |
|
|
0 |
|
|
|
|
46582 |
32556 |
product |
48544 |
A |
30 |
|
|
0 |
|
|
|
|
46589 |
32557 |
product |
48551 |
A |
30 |
|
|
0 |
|
|
|
|
46597 |
32558 |
product |
48559 |
A |
30 |
|
|
0 |
|
|
|
|
46644 |
32566 |
product |
48606 |
A |
30 |
|
|
0 |
|
|
|
|
46657 |
32568 |
product |
48619 |
A |
30 |
|
|
0 |
|
|
|
|
46687 |
32573 |
product |
48649 |
A |
30 |
|
|
0 |
|
|
|
|
46758 |
32583 |
product |
48720 |
A |
30 |
|
|
0 |
|
|
|
|
46783 |
32586 |
product |
48745 |
A |
30 |
|
|
0 |
|
|
|
|
82654 |
32579 |
product |
84597 |
A |
31 |
|
|