Query time 0.00390
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.detailed_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"
],
"attached_condition": "<if>(is_not_null_compl(q_images), (`portal`.`q_images_links`.`detailed_id` = `portal`.`q_images`.`image_id`), true)"
}
},
{
"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 |
12583M-8-1.jpg |
4150 |
4000 |
N |
42852 |
32581 |
product |
44814 |
A |
1 |
|
44814 |
0 |
12583M-4-2-1.jpg |
3690 |
3853 |
N |
42831 |
32575 |
product |
44793 |
A |
2 |
|
44793 |
0 |
12583M-8-2.jpg |
3681 |
4000 |
N |
42853 |
32581 |
product |
44815 |
A |
2 |
|
44815 |
0 |
12583M-4-3-1.jpg |
6000 |
4000 |
N |
44436 |
32575 |
product |
46398 |
A |
3 |
|
46398 |
0 |
12582M-3-2.jpg |
6000 |
4000 |
N |
42747 |
32554 |
product |
44709 |
A |
10 |
|
44709 |
0 |
12583L-10-2.jpg |
4649 |
4000 |
N |
42751 |
32555 |
product |
44713 |
A |
10 |
|
44713 |
0 |
12583-L-2P-2.jpg |
4407 |
4000 |
N |
42755 |
32556 |
product |
44717 |
A |
10 |
|
44717 |
0 |
12583L-3-2.jpg |
4635 |
3793 |
N |
42759 |
32557 |
product |
44721 |
A |
10 |
|
44721 |
0 |
12583L-3P-2.jpg |
4635 |
3793 |
N |
42763 |
32558 |
product |
44725 |
A |
10 |
|
44725 |
0 |
12583L-4-2.jpg |
3690 |
3853 |
N |
42767 |
32559 |
product |
44729 |
A |
10 |
|
44729 |
0 |
12583L-5-2.jpg |
3690 |
3853 |
N |
42777 |
32560 |
product |
44739 |
A |
10 |
|
44739 |
0 |
12583L-7-2.jpg |
4487 |
4000 |
N |
42790 |
32565 |
product |
44752 |
A |
10 |
|
44752 |
0 |
12583M-5-2.jpg |
3690 |
3853 |
N |
42838 |
32577 |
product |
44800 |
A |
10 |
|
44800 |
0 |
12582M-3-2.jpg |
6000 |
4000 |
N |
44368 |
32554 |
product |
46330 |
A |
10 |
|
46330 |
0 |
12583L-10-2.jpg |
4649 |
4000 |
N |
44371 |
32555 |
product |
46333 |
A |
10 |
|
46333 |
0 |
12583-L-2P-2.jpg |
4407 |
4000 |
N |
44375 |
32556 |
product |
46337 |
A |
10 |
|
46337 |
0 |
12583L-3-2.jpg |
4635 |
3793 |
N |
44378 |
32557 |
product |
46340 |
A |
10 |
|
46340 |
0 |
12583L-3P-2.jpg |
4635 |
3793 |
N |
44382 |
32558 |
product |
46344 |
A |
10 |
|
46344 |
0 |
12583L-4-2.jpg |
3690 |
3853 |
N |
44386 |
32559 |
product |
46348 |
A |
10 |
|
46348 |
0 |
12583L-5-2.jpg |
3690 |
3853 |
N |
44390 |
32560 |
product |
46352 |
A |
10 |
|
46352 |
0 |
12583L-5P-2-1.jpg |
4255 |
4000 |
N |
44394 |
32562 |
product |
46356 |
A |
10 |
|
46356 |
0 |
12583L-7-2.jpg |
4487 |
4000 |
N |
44403 |
32565 |
product |
46365 |
A |
10 |
|
46365 |
0 |
12583L-7P-2-1.jpg |
3867 |
4000 |
N |
44405 |
32566 |
product |
46367 |
A |
10 |
|
46367 |
0 |
12583M-10-2.jpg |
4560 |
4000 |
N |
44423 |
32571 |
product |
46385 |
A |
10 |
|
46385 |
0 |
12583M-2-2.jpg |
3962 |
4000 |
N |
44426 |
32573 |
product |
46388 |
A |
10 |
|
46388 |
0 |
14002L-2-2.jpg |
6000 |
3825 |
N |
44483 |
32588 |
product |
46445 |
A |
10 |
|
46445 |
0 |
14002L-3-2.jpg |
6000 |
3682 |
N |
44490 |
32589 |
product |
46452 |
A |
10 |
|
46452 |
0 |
12583L-3-2.jpg |
4635 |
3793 |
N |
46585 |
32557 |
product |
48547 |
A |
10 |
|
48547 |
0 |
12583L-3P-2.jpg |
4635 |
3793 |
N |
46593 |
32558 |
product |
48555 |
A |
10 |
|
48555 |
0 |
12583L-5-2.jpg |
3690 |
3853 |
N |
46609 |
32560 |
product |
48571 |
A |
10 |
|
48571 |
0 |
14002L-3-2.jpg |
6000 |
3682 |
N |
46794 |
32589 |
product |
48756 |
A |
10 |
|
48756 |
0 |
12583-L-2P-3.jpg |
3962 |
4000 |
N |
42756 |
32556 |
product |
44718 |
A |
20 |
|
44718 |
0 |
12583L-3P-3.jpg |
3962 |
4000 |
N |
42764 |
32558 |
product |
44726 |
A |
20 |
|
44726 |
0 |
12583L-5-3.jpg |
6000 |
4000 |
N |
42778 |
32560 |
product |
44740 |
A |
20 |
|
44740 |
0 |
12583L-5P-3-1.jpg |
3690 |
3853 |
N |
42781 |
32562 |
product |
44743 |
A |
20 |
|
44743 |
0 |
12583L-7-3.jpg |
6000 |
4000 |
N |
42791 |
32565 |
product |
44753 |
A |
20 |
|
44753 |
0 |
12583L-7P-3-1.jpg |
4487 |
4000 |
N |
42794 |
32566 |
product |
44756 |
A |
20 |
|
44756 |
0 |
12583M-10-3.jpg |
4649 |
4000 |
N |
42813 |
32571 |
product |
44775 |
A |
20 |
|
44775 |
0 |
12583M-9-3.jpg |
6000 |
4000 |
N |
42858 |
32582 |
product |
44820 |
A |
20 |
|
44820 |
0 |
14001L-1-3.jpg |
6000 |
4000 |
N |
42862 |
32583 |
product |
44824 |
A |
20 |
|
44824 |
0 |
12583-L-2P-3.jpg |
3962 |
4000 |
N |
44376 |
32556 |
product |
46338 |
A |
20 |
|
46338 |
0 |
12583L-3P-3.jpg |
3962 |
4000 |
N |
44383 |
32558 |
product |
46345 |
A |
20 |
|
46345 |
0 |
12583L-5-3.jpg |
6000 |
4000 |
N |
44391 |
32560 |
product |
46353 |
A |
20 |
|
46353 |
0 |
12583L-6-3.jpg |
3690 |
3853 |
N |
44397 |
32563 |
product |
46359 |
A |
20 |
|
46359 |
0 |
12583L-6P-3.jpg |
3690 |
3853 |
N |
44399 |
32564 |
product |
46361 |
A |
20 |
|
46361 |
0 |
12583L-7-3.jpg |
6000 |
4000 |
N |
44404 |
32565 |
product |
46366 |
A |
20 |
|
46366 |
0 |
12583L-7P-3-1.jpg |
4487 |
4000 |
N |
44407 |
32566 |
product |
46369 |
A |
20 |
|
46369 |
0 |
12583F-8-3.jpg |
3681 |
4000 |
N |
44411 |
32567 |
product |
46373 |
A |
20 |
|
46373 |
0 |
12583L-8P-3.jpg |
3947 |
4000 |
N |
44414 |
32568 |
product |
46376 |
A |
20 |
|
46376 |
0 |
12583L-9-3.jpg |
4649 |
4000 |
N |
44418 |
32569 |
product |
46380 |
A |
20 |
|
46380 |
0 |
12583M-10-3.jpg |
4649 |
4000 |
N |
44424 |
32571 |
product |
46386 |
A |
20 |
|
46386 |
0 |
12583M-2-3.jpg |
6000 |
4000 |
N |
44428 |
32573 |
product |
46390 |
A |
20 |
|
46390 |
0 |
12583M-3-3.jpg |
6000 |
4000 |
N |
44432 |
32574 |
product |
46394 |
A |
20 |
|
46394 |
0 |
12583M-4P-3.jpg |
3690 |
3853 |
N |
44438 |
32576 |
product |
46400 |
A |
20 |
|
46400 |
0 |
12583M-5-3.jpg |
6000 |
4000 |
N |
44442 |
32577 |
product |
46404 |
A |
20 |
|
46404 |
0 |
12583M-6-3.jpg |
6000 |
4000 |
N |
44446 |
32579 |
product |
46408 |
A |
20 |
|
46408 |
0 |
14001L-1-3.jpg |
6000 |
4000 |
N |
44466 |
32583 |
product |
46428 |
A |
20 |
|
46428 |
0 |
14001L-2-3.jpg |
6000 |
4000 |
N |
44470 |
32584 |
product |
46432 |
A |
20 |
|
46432 |
0 |
14001L-3-3.jpg |
6000 |
4000 |
N |
44475 |
32585 |
product |
46437 |
A |
20 |
|
46437 |
0 |
14001L-4-3.jpg |
6000 |
4000 |
N |
44480 |
32586 |
product |
46442 |
A |
20 |
|
46442 |
0 |
14002L-3-3.jpg |
6000 |
4000 |
N |
44491 |
32589 |
product |
46453 |
A |
20 |
|
46453 |
0 |
12583-L-2P-3.jpg |
3962 |
4000 |
N |
46581 |
32556 |
product |
48543 |
A |
20 |
|
48543 |
0 |
12583L-3-3.jpg |
3962 |
4000 |
N |
46587 |
32557 |
product |
48549 |
A |
20 |
|
48549 |
0 |
12583L-3P-3.jpg |
3962 |
4000 |
N |
46595 |
32558 |
product |
48557 |
A |
20 |
|
48557 |
0 |
14001L-4-3.jpg |
6000 |
4000 |
N |
46781 |
32586 |
product |
48743 |
A |
20 |
|
48743 |
0 |
12583-L-2P-4.jpg |
6000 |
4000 |
N |
42757 |
32556 |
product |
44719 |
A |
30 |
|
44719 |
0 |
12583L-3P-4.jpg |
6000 |
4000 |
N |
42765 |
32558 |
product |
44727 |
A |
30 |
|
44727 |
0 |
12583L-4-4.jpg |
6000 |
4000 |
N |
42769 |
32559 |
product |
44731 |
A |
30 |
|
44731 |
0 |
12583L-5P-4-1.jpg |
6000 |
4000 |
N |
42782 |
32562 |
product |
44744 |
A |
30 |
|
44744 |
0 |
12583L-6-4.jpg |
6000 |
4000 |
N |
42785 |
32563 |
product |
44747 |
A |
30 |
|
44747 |
0 |
12583L-6P-4.jpg |
6000 |
4000 |
N |
42788 |
32564 |
product |
44750 |
A |
30 |
|
44750 |
0 |
12583L-7P-4-1.jpg |
6000 |
4000 |
N |
42795 |
32566 |
product |
44757 |
A |
30 |
|
44757 |
0 |
12583L-9-4.jpg |
6000 |
4000 |
N |
42807 |
32569 |
product |
44769 |
A |
30 |
|
44769 |
0 |
12583M-10-4.jpg |
6000 |
4000 |
N |
42821 |
32571 |
product |
44783 |
A |
30 |
|
44783 |
0 |
12583M-5-4.jpg |
6000 |
4000 |
N |
42843 |
32577 |
product |
44805 |
A |
30 |
|
44805 |
0 |
12583M-7-4.jpg |
6000 |
4000 |
N |
42851 |
32580 |
product |
44813 |
A |
30 |
|
44813 |
0 |
14002L-2-4.jpg |
6000 |
4000 |
N |
42881 |
32588 |
product |
44843 |
A |
30 |
|
44843 |
0 |
14002L-3-4.jpg |
6000 |
4000 |
N |
42885 |
32589 |
product |
44847 |
A |
30 |
|
44847 |
0 |
12582M-3-4.jpg |
6000 |
4000 |
N |
44370 |
32554 |
product |
46332 |
A |
30 |
|
46332 |
0 |
12583-L-2P-4.jpg |
6000 |
4000 |
N |
44377 |
32556 |
product |
46339 |
A |
30 |
|
46339 |
0 |
12583L-3P-4.jpg |
6000 |
4000 |
N |
44385 |
32558 |
product |
46347 |
A |
30 |
|
46347 |
0 |
12583L-4-4.jpg |
6000 |
4000 |
N |
44389 |
32559 |
product |
46351 |
A |
30 |
|
46351 |
0 |
12583L-5P-4-1.jpg |
6000 |
4000 |
N |
44396 |
32562 |
product |
46358 |
A |
30 |
|
46358 |
0 |
12583L-6-4.jpg |
6000 |
4000 |
N |
44398 |
32563 |
product |
46360 |
A |
30 |
|
46360 |
0 |
12583L-6P-4.jpg |
6000 |
4000 |
N |
44401 |
32564 |
product |
46363 |
A |
30 |
|
46363 |
0 |
12583L-7P-4-1.jpg |
6000 |
4000 |
N |
44408 |
32566 |
product |
46370 |
A |
30 |
|
46370 |
0 |
12583F-8-4.jpg |
6000 |
4000 |
N |
44412 |
32567 |
product |
46374 |
A |
30 |
|
46374 |
0 |
12583L-8P-4.jpg |
6000 |
4000 |
N |
44416 |
32568 |
product |
46378 |
A |
30 |
|
46378 |
0 |
12583M-1-4.jpg |
6000 |
4000 |
N |
44422 |
32570 |
product |
46384 |
A |
30 |
|
46384 |
0 |
12583M-10-4.jpg |
6000 |
4000 |
N |
44425 |
32571 |
product |
46387 |
A |
30 |
|
46387 |
0 |
12583M-2-4.jpg |
6000 |
4000 |
N |
44430 |
32573 |
product |
46392 |
A |
30 |
|
46392 |
0 |
12583M-3-4.jpg |
6000 |
4000 |
N |
44433 |
32574 |
product |
46395 |
A |
30 |
|
46395 |
0 |
12583M-4P-4.jpg |
6000 |
4000 |
N |
44440 |
32576 |
product |
46402 |
A |
30 |
|
46402 |
0 |
12583M-6-4.jpg |
6000 |
4000 |
N |
44447 |
32579 |
product |
46409 |
A |
30 |
|
46409 |
0 |
12583M-9-4.jpg |
6000 |
4000 |
N |
44464 |
32582 |
product |
46426 |
A |
30 |
|
46426 |
0 |
14001L-1-4.jpg |
6000 |
4000 |
N |
44468 |
32583 |
product |
46430 |
A |
30 |
|
46430 |
0 |
14001L-2-4.jpg |
6000 |
4000 |
N |
44472 |
32584 |
product |
46434 |
A |
30 |
|
46434 |
0 |
14001L-3-4.jpg |
6000 |
4000 |
N |
44478 |
32585 |
product |
46440 |
A |
30 |
|
46440 |
0 |
14001L-4-4.jpg |
6000 |
4000 |
N |
44482 |
32586 |
product |
46444 |
A |
30 |
|
46444 |
0 |
14002L-2-4.jpg |
6000 |
4000 |
N |
44486 |
32588 |
product |
46448 |
A |
30 |
|
46448 |
0 |
12582M-3-4.jpg |
6000 |
4000 |
N |
46569 |
32554 |
product |
48531 |
A |
30 |
|
48531 |
0 |
12583L-10-4.jpg |
6000 |
4000 |
N |
46576 |
32555 |
product |
48538 |
A |
30 |
|
48538 |
0 |
12583-L-2P-4.jpg |
6000 |
4000 |
N |
46582 |
32556 |
product |
48544 |
A |
30 |
|
48544 |
0 |
12583L-3-4.jpg |
6000 |
4000 |
N |
46589 |
32557 |
product |
48551 |
A |
30 |
|
48551 |
0 |
12583L-3P-4.jpg |
6000 |
4000 |
N |
46597 |
32558 |
product |
48559 |
A |
30 |
|
48559 |
0 |
12583L-7P-4-1.jpg |
6000 |
4000 |
N |
46644 |
32566 |
product |
48606 |
A |
30 |
|
48606 |
0 |
12583L-8P-4.jpg |
6000 |
4000 |
N |
46657 |
32568 |
product |
48619 |
A |
30 |
|
48619 |
0 |
12583M-2-4.jpg |
6000 |
4000 |
N |
46687 |
32573 |
product |
48649 |
A |
30 |
|
48649 |
0 |
14001L-1-4.jpg |
6000 |
4000 |
N |
46758 |
32583 |
product |
48720 |
A |
30 |
|
48720 |
0 |
14001L-4-4.jpg |
6000 |
4000 |
N |
46783 |
32586 |
product |
48745 |
A |
30 |
|
48745 |
0 |
12583M-6-2.jpg |
3690 |
3853 |
N |
82654 |
32579 |
product |
84597 |
A |
31 |
|
84597 |