Query time 0.00415
JSON explain
{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "458.21"
},
"ordering_operation": {
"using_filesort": true,
"cost_info": {
"sort_cost": "79.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": 79,
"rows_produced_per_join": 79,
"filtered": "100.00",
"index_condition": "((`webmarco`.`cscart_images_links`.`object_type` = 'product') and (`webmarco`.`cscart_images_links`.`type` = 'M') and (`webmarco`.`cscart_images_links`.`object_id` in (431687,431688,431689,431690,431691,431692,431693,431694,431695,431696,431697,414514,414516,414517,414518,414519,414520,414521,414393,414394,414395,414396,414397,414398,414399,431514,431515,431518,431521,431524,431527,431532,431535,431530,431531,414329,414330,414331,414332,414333,414334,396078,396079,396080,396081,396082,396083,396084,396085,396044,396045,396046,396047,396048,396049,396050,431552,431553,431554,431555,431556,431557,431558,431559,431560,414335,414336,414337,414338,414339,414340,414341,414429,414430,414431,414432,414433,414434,414435)))",
"cost_info": {
"read_cost": "173.81",
"eval_cost": "15.80",
"prefix_cost": "189.61",
"data_read_per_join": "7K"
},
"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": "4",
"ref": [
"webmarco.cscart_images_links.detailed_id"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 79,
"filtered": "100.00",
"cost_info": {
"read_cost": "79.00",
"eval_cost": "15.80",
"prefix_cost": "284.41",
"data_read_per_join": "60K"
},
"used_columns": [
"image_id",
"image_path",
"image_x",
"image_y",
"is_high_res"
]
}
},
{
"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": "108",
"ref": [
"webmarco.cscart_images.image_id",
"const",
"const"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 79,
"filtered": "100.00",
"cost_info": {
"read_cost": "79.00",
"eval_cost": "15.80",
"prefix_cost": "379.21",
"data_read_per_join": "46K"
},
"used_columns": [
"object_id",
"description",
"lang_code",
"object_holder"
]
}
}
]
}
}
}
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 |
Untitled_design_-_2023-04-28T140728.205.png |
600 |
600 |
N |
3649415 |
396044 |
product |
1361700 |
M |
0 |
|
1361700 |
0 |
Untitled_design_-_2023-04-28T140728.205.png |
600 |
600 |
N |
3649449 |
396045 |
product |
1361700 |
M |
0 |
|
1361700 |
0 |
Untitled_design_-_2023-04-28T140728.205.png |
600 |
600 |
N |
3649450 |
396046 |
product |
1361700 |
M |
0 |
|
1361700 |
0 |
Untitled_design_-_2023-04-28T140728.205.png |
600 |
600 |
N |
3649451 |
396047 |
product |
1361700 |
M |
0 |
|
1361700 |
0 |
Untitled_design_-_2023-04-28T140728.205.png |
600 |
600 |
N |
3649452 |
396048 |
product |
1361700 |
M |
0 |
|
1361700 |
0 |
Untitled_design_-_2023-04-28T140728.205.png |
600 |
600 |
N |
3649453 |
396049 |
product |
1361700 |
M |
0 |
|
1361700 |
0 |
Untitled_design_-_2023-04-28T140728.205.png |
600 |
600 |
N |
3649454 |
396050 |
product |
1361700 |
M |
0 |
|
1361700 |
0 |
Untitled_design_-_2023-04-28T145817.109.png |
600 |
600 |
N |
3649712 |
396078 |
product |
1361714 |
M |
0 |
|
1361714 |
0 |
Untitled_design_-_2023-04-28T145817.109.png |
600 |
600 |
N |
3649746 |
396079 |
product |
1361714 |
M |
0 |
|
1361714 |
0 |
Untitled_design_-_2023-04-28T145817.109.png |
600 |
600 |
N |
3649747 |
396080 |
product |
1361714 |
M |
0 |
|
1361714 |
0 |
Untitled_design_-_2023-04-28T145817.109.png |
600 |
600 |
N |
3649748 |
396081 |
product |
1361714 |
M |
0 |
|
1361714 |
0 |
Untitled_design_-_2023-04-28T145817.109.png |
600 |
600 |
N |
3649749 |
396082 |
product |
1361714 |
M |
0 |
|
1361714 |
0 |
Untitled_design_-_2023-04-28T145817.109.png |
600 |
600 |
N |
3649750 |
396083 |
product |
1361714 |
M |
0 |
|
1361714 |
0 |
Untitled_design_-_2023-04-28T145817.109.png |
600 |
600 |
N |
3649751 |
396084 |
product |
1361714 |
M |
0 |
|
1361714 |
0 |
Untitled_design_-_2023-04-28T145817.109.png |
600 |
600 |
N |
3649752 |
396085 |
product |
1361714 |
M |
0 |
|
1361714 |
0 |
Untitled_design_-_2023-05-01T153457.648.png |
600 |
600 |
N |
3781743 |
414329 |
product |
1492609 |
M |
0 |
|
1492609 |
0 |
Untitled_design_-_2023-05-01T153457.648.png |
600 |
600 |
N |
3781744 |
414330 |
product |
1492609 |
M |
0 |
|
1492609 |
0 |
Untitled_design_-_2023-05-01T153457.648.png |
600 |
600 |
N |
3781745 |
414331 |
product |
1492609 |
M |
0 |
|
1492609 |
0 |
Untitled_design_-_2023-05-01T153457.648.png |
600 |
600 |
N |
3781746 |
414332 |
product |
1492609 |
M |
0 |
|
1492609 |
0 |
Untitled_design_-_2023-05-01T153457.648.png |
600 |
600 |
N |
3781747 |
414333 |
product |
1492609 |
M |
0 |
|
1492609 |
0 |
Untitled_design_-_2023-05-01T153457.648.png |
600 |
600 |
N |
3781748 |
414334 |
product |
1492609 |
M |
0 |
|
1492609 |
0 |
Untitled_design_-_2023-05-01T154044.604.png |
600 |
600 |
N |
3781749 |
414335 |
product |
1492610 |
M |
0 |
|
1492610 |
0 |
Untitled_design_-_2023-05-01T154044.604.png |
600 |
600 |
N |
3781750 |
414336 |
product |
1492610 |
M |
0 |
|
1492610 |
0 |
Untitled_design_-_2023-05-01T154044.604.png |
600 |
600 |
N |
3781751 |
414337 |
product |
1492610 |
M |
0 |
|
1492610 |
0 |
Untitled_design_-_2023-05-01T154044.604.png |
600 |
600 |
N |
3781752 |
414338 |
product |
1492610 |
M |
0 |
|
1492610 |
0 |
Untitled_design_-_2023-05-01T154044.604.png |
600 |
600 |
N |
3781753 |
414339 |
product |
1492610 |
M |
0 |
|
1492610 |
0 |
Untitled_design_-_2023-05-01T154044.604.png |
600 |
600 |
N |
3781754 |
414340 |
product |
1492610 |
M |
0 |
|
1492610 |
0 |
Untitled_design_-_2023-05-01T154044.604.png |
600 |
600 |
N |
3781755 |
414341 |
product |
1492610 |
M |
0 |
|
1492610 |
0 |
Untitled_design_-_2023-05-01T163705.950.png |
600 |
600 |
N |
3781871 |
414393 |
product |
1492627 |
M |
0 |
|
1492627 |
0 |
Untitled_design_-_2023-05-01T163705.950.png |
600 |
600 |
N |
3781893 |
414394 |
product |
1492627 |
M |
0 |
|
1492627 |
0 |
Untitled_design_-_2023-05-01T163705.950.png |
600 |
600 |
N |
3781894 |
414395 |
product |
1492627 |
M |
0 |
|
1492627 |
0 |
Untitled_design_-_2023-05-01T163705.950.png |
600 |
600 |
N |
3781895 |
414396 |
product |
1492627 |
M |
0 |
|
1492627 |
0 |
Untitled_design_-_2023-05-01T163705.950.png |
600 |
600 |
N |
3781896 |
414397 |
product |
1492627 |
M |
0 |
|
1492627 |
0 |
Untitled_design_-_2023-05-01T163705.950.png |
600 |
600 |
N |
3781897 |
414398 |
product |
1492627 |
M |
0 |
|
1492627 |
0 |
Untitled_design_-_2023-05-01T163705.950.png |
600 |
600 |
N |
3781898 |
414399 |
product |
1492627 |
M |
0 |
|
1492627 |
0 |
Untitled_design_-_2023-05-01T173528.709.png |
600 |
600 |
N |
3781932 |
414429 |
product |
1492641 |
M |
0 |
|
1492641 |
0 |
Untitled_design_-_2023-05-01T173528.709.png |
600 |
600 |
N |
3781954 |
414430 |
product |
1492641 |
M |
0 |
|
1492641 |
0 |
Untitled_design_-_2023-05-01T173528.709.png |
600 |
600 |
N |
3781955 |
414431 |
product |
1492641 |
M |
0 |
|
1492641 |
0 |
Untitled_design_-_2023-05-01T173528.709.png |
600 |
600 |
N |
3781956 |
414432 |
product |
1492641 |
M |
0 |
|
1492641 |
0 |
Untitled_design_-_2023-05-01T173528.709.png |
600 |
600 |
N |
3781957 |
414433 |
product |
1492641 |
M |
0 |
|
1492641 |
0 |
Untitled_design_-_2023-05-01T173528.709.png |
600 |
600 |
N |
3781958 |
414434 |
product |
1492641 |
M |
0 |
|
1492641 |
0 |
Untitled_design_-_2023-05-01T173528.709.png |
600 |
600 |
N |
3781959 |
414435 |
product |
1492641 |
M |
0 |
|
1492641 |
0 |
Untitled_design_-_2023-05-01T184856.624.png |
600 |
600 |
N |
3782096 |
414514 |
product |
1492687 |
M |
0 |
|
1492687 |
0 |
Untitled_design_-_2023-05-01T184856.624.png |
600 |
600 |
N |
3782112 |
414516 |
product |
1492687 |
M |
0 |
|
1492687 |
0 |
Untitled_design_-_2023-05-01T184856.624.png |
600 |
600 |
N |
3782113 |
414517 |
product |
1492687 |
M |
0 |
|
1492687 |
0 |
Untitled_design_-_2023-05-01T184856.624.png |
600 |
600 |
N |
3782114 |
414518 |
product |
1492687 |
M |
0 |
|
1492687 |
0 |
Untitled_design_-_2023-05-01T184856.624.png |
600 |
600 |
N |
3782115 |
414519 |
product |
1492687 |
M |
0 |
|
1492687 |
0 |
Untitled_design_-_2023-05-01T184856.624.png |
600 |
600 |
N |
3782116 |
414520 |
product |
1492687 |
M |
0 |
|
1492687 |
0 |
Untitled_design_-_2023-05-01T184856.624.png |
600 |
600 |
N |
3782117 |
414521 |
product |
1492687 |
M |
0 |
|
1492687 |
0 |
produts_img_600__3__q4w0-d6.png |
600 |
600 |
N |
3870861 |
431514 |
product |
1543459 |
M |
0 |
|
1543459 |
0 |
produts_img_600__2__ow8y-qm.png |
600 |
600 |
N |
3870880 |
431531 |
product |
1543460 |
M |
0 |
|
1543460 |
0 |
produts_img_600__1__ijl5-gm.png |
600 |
600 |
N |
3870902 |
431530 |
product |
1543461 |
M |
0 |
|
1543461 |
0 |
produts_img_600__3__q4w0-d6.png |
600 |
600 |
N |
3870910 |
431515 |
product |
1543459 |
M |
0 |
|
1543459 |
0 |
produts_img_600__3__q4w0-d6.png |
600 |
600 |
N |
3870913 |
431518 |
product |
1543459 |
M |
0 |
|
1543459 |
0 |
produts_img_600__3__q4w0-d6.png |
600 |
600 |
N |
3870916 |
431521 |
product |
1543459 |
M |
0 |
|
1543459 |
0 |
produts_img_600__3__q4w0-d6.png |
600 |
600 |
N |
3870919 |
431524 |
product |
1543459 |
M |
0 |
|
1543459 |
0 |
produts_img_600__3__q4w0-d6.png |
600 |
600 |
N |
3870922 |
431527 |
product |
1543459 |
M |
0 |
|
1543459 |
0 |
produts_img_600__3__q4w0-d6.png |
600 |
600 |
N |
3870927 |
431532 |
product |
1543459 |
M |
0 |
|
1543459 |
0 |
produts_img_600__3__q4w0-d6.png |
600 |
600 |
N |
3870930 |
431535 |
product |
1543459 |
M |
0 |
|
1543459 |
0 |
produts_img_600__5__jigw-5r.png |
600 |
600 |
N |
3871144 |
431552 |
product |
1543472 |
M |
0 |
|
1543472 |
0 |
produts_img_600__5__jigw-5r.png |
600 |
600 |
N |
3871145 |
431553 |
product |
1543472 |
M |
0 |
|
1543472 |
0 |
produts_img_600__5__jigw-5r.png |
600 |
600 |
N |
3871146 |
431554 |
product |
1543472 |
M |
0 |
|
1543472 |
0 |
produts_img_600__5__jigw-5r.png |
600 |
600 |
N |
3871147 |
431555 |
product |
1543472 |
M |
0 |
|
1543472 |
0 |
produts_img_600__5__jigw-5r.png |
600 |
600 |
N |
3871148 |
431556 |
product |
1543472 |
M |
0 |
|
1543472 |
0 |
produts_img_600__5__jigw-5r.png |
600 |
600 |
N |
3871149 |
431557 |
product |
1543472 |
M |
0 |
|
1543472 |
0 |
produts_img_600__5__jigw-5r.png |
600 |
600 |
N |
3871150 |
431558 |
product |
1543472 |
M |
0 |
|
1543472 |
0 |
produts_img_600__5__jigw-5r.png |
600 |
600 |
N |
3871151 |
431559 |
product |
1543472 |
M |
0 |
|
1543472 |
0 |
produts_img_600__5__jigw-5r.png |
600 |
600 |
N |
3871152 |
431560 |
product |
1543472 |
M |
0 |
|
1543472 |
0 |
produts_img_600__22_.png |
600 |
600 |
N |
3871476 |
431687 |
product |
1543506 |
M |
0 |
|
1543506 |
0 |
produts_img_600__22_.png |
600 |
600 |
N |
3871488 |
431688 |
product |
1543506 |
M |
0 |
|
1543506 |
0 |
produts_img_600__22_.png |
600 |
600 |
N |
3871489 |
431689 |
product |
1543506 |
M |
0 |
|
1543506 |
0 |
produts_img_600__22_.png |
600 |
600 |
N |
3871490 |
431690 |
product |
1543506 |
M |
0 |
|
1543506 |
0 |
produts_img_600__22_.png |
600 |
600 |
N |
3871491 |
431691 |
product |
1543506 |
M |
0 |
|
1543506 |
0 |
produts_img_600__22_.png |
600 |
600 |
N |
3871492 |
431692 |
product |
1543506 |
M |
0 |
|
1543506 |
0 |
produts_img_600__22_.png |
600 |
600 |
N |
3871493 |
431693 |
product |
1543506 |
M |
0 |
|
1543506 |
0 |
produts_img_600__22_.png |
600 |
600 |
N |
3871494 |
431694 |
product |
1543506 |
M |
0 |
|
1543506 |
0 |
produts_img_600__22_.png |
600 |
600 |
N |
3871495 |
431695 |
product |
1543506 |
M |
0 |
|
1543506 |
0 |
produts_img_600__22_.png |
600 |
600 |
N |
3871496 |
431696 |
product |
1543506 |
M |
0 |
|
1543506 |
0 |
produts_img_600__22_.png |
600 |
600 |
N |
3871497 |
431697 |
product |
1543506 |
M |
0 |
|
1543506 |