Query time 0.01382
JSON explain
{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "188.38"
},
"ordering_operation": {
"using_filesort": true,
"cost_info": {
"sort_cost": "36.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": 36,
"rows_produced_per_join": 36,
"filtered": "100.00",
"index_condition": "((`maniamall_cscart`.`cscart_images_links`.`object_type` = 'product') and (`maniamall_cscart`.`cscart_images_links`.`type` = 'M') and (`maniamall_cscart`.`cscart_images_links`.`object_id` in (480519,524885,697773,866373,1118377,697683,612103,880671,1434961,694679,822677,614913,301401,822659,613219,613221,1025388,822679,1025367,1025365,1230911,1338749,1731846,1732251,359020,1153153,1153155,1338924,1231165,1731742,1732158,1231166,1732357,1153734,1732013,1663556)))",
"cost_info": {
"read_cost": "72.18",
"eval_cost": "3.60",
"prefix_cost": "75.78",
"data_read_per_join": "3K"
},
"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": "3",
"ref": [
"maniamall_cscart.cscart_images_links.detailed_id"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 36,
"filtered": "100.00",
"cost_info": {
"read_cost": "35.22",
"eval_cost": "3.60",
"prefix_cost": "114.60",
"data_read_per_join": "27K"
},
"used_columns": [
"image_id",
"image_path",
"image_x",
"image_y"
],
"attached_condition": "<if>(is_not_null_compl(cscart_images), (`maniamall_cscart`.`cscart_images_links`.`detailed_id` = `maniamall_cscart`.`cscart_images`.`image_id`), true)"
}
},
{
"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": "107",
"ref": [
"maniamall_cscart.cscart_images.image_id",
"const",
"const"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 36,
"filtered": "100.00",
"cost_info": {
"read_cost": "34.18",
"eval_cost": "3.60",
"prefix_cost": "152.38",
"data_read_per_join": "21K"
},
"used_columns": [
"object_id",
"description",
"lang_code",
"object_holder"
],
"attached_condition": "<if>(is_not_null_compl(cscart_common_descriptions), (`maniamall_cscart`.`cscart_common_descriptions`.`object_id` = `maniamall_cscart`.`cscart_images`.`image_id`), true)"
}
}
]
}
}
}
Result
| pair_id |
object_id |
object_type |
image_id |
detailed_id |
type |
position |
image_path |
alt |
image_x |
image_y |
images_image_id |
| 460270 |
301401 |
product |
0 |
460507 |
M |
0 |
plasa-de-depozitare-durabila-cu-crlige-60-x-60-cm-lungime-ntinsa-.jpg |
|
800 |
667 |
460507 |
| 559117 |
359020 |
product |
0 |
559354 |
M |
0 |
organizator-auto-pentru-spatarul-scaunului-din-fata-al-masinii-.jpg |
|
620 |
620 |
559354 |
| 769391 |
480519 |
product |
0 |
769628 |
M |
0 |
super-windscreen-repair-kit-cars-accessories-smile-gadgets-plastic-water_606_4000x.progressive.jpg |
|
800 |
800 |
769628 |
| 817200 |
524885 |
product |
0 |
817437 |
M |
0 |
priza-remorca-auto-cu-adaptor-inclus-pentru-7-sau-13-pini-.jpg |
|
800 |
600 |
817437 |
| 957536 |
612103 |
product |
0 |
957773 |
M |
0 |
filtru-aer-tuning-cu-carcasa-rosie-maniacars.jpg |
|
600 |
600 |
957773 |
| 959300 |
613219 |
product |
0 |
959537 |
M |
0 |
invertor-220v-12v-20a-240w-cu-ventilator-maniacars.jpg |
|
800 |
533 |
959537 |
| 959304 |
613221 |
product |
0 |
959541 |
M |
0 |
invertor-220v-12v-30a-360w-cu-ventilator-maniacars.jpg |
|
800 |
533 |
959541 |
| 961970 |
614913 |
product |
0 |
962207 |
M |
0 |
ridicator-tensiune-pentru-fir-neon-maniacars.jpg |
|
800 |
600 |
962207 |
| 1091851 |
694679 |
product |
0 |
1092088 |
M |
0 |
kit-cablaj-carlig-remorca-7-pini-maniacars.jpg |
|
235 |
235 |
1092088 |
| 1095760 |
697683 |
product |
0 |
1095997 |
M |
0 |
releu-4-pini-40a-12v-maniacars.jpg |
|
1492 |
1542 |
1095997 |
| 1262194 |
822659 |
product |
0 |
1262431 |
M |
0 |
priza-remorca-auto-blow-cu-7-pini-1224v-culoare-argintiu-.jpg |
|
800 |
600 |
1262431 |
| 1262217 |
822677 |
product |
0 |
1262454 |
M |
0 |
adaptor-priza-bricheta-blow-3xusb-52a-protectie-la-supratensiune-.jpg |
|
800 |
600 |
1262454 |
| 1262221 |
822679 |
product |
0 |
1262458 |
M |
0 |
vesta-cu-doua-dungi-reflectorizante-omologata-european-culoare-portocaliu-.jpg |
|
800 |
600 |
1262458 |
| 1337473 |
866373 |
product |
0 |
1337710 |
M |
0 |
incarcator-auto-wireless-cu-suport-inchideredeschidere-automata-incarcare-prin-inductie-electromagnetica-brat-reglabil-negru-.jpg |
|
1280 |
850 |
1337710 |
| 1362929 |
880671 |
product |
0 |
1363166 |
M |
0 |
priza-bricheta-auto-tripla-12v24v-cu-port-usb-.jpg |
|
1280 |
850 |
1363166 |
| 1580386 |
1025365 |
product |
0 |
1580623 |
M |
0 |
cablu-frana-2m15mm---mto-bsp0758-.jpg |
|
568 |
282 |
1580623 |
| 1580388 |
1025367 |
product |
0 |
1580625 |
M |
0 |
cablu-frana-2m15mm---mto-bsp0763-.jpg |
|
566 |
216 |
1580625 |
| 1580410 |
1025388 |
product |
0 |
1580647 |
M |
0 |
camasa-frana-fata-l75---mto-r500332-.jpg |
|
761 |
871 |
1580647 |
| 1764722 |
1118377 |
product |
0 |
1764961 |
M |
0 |
covoras-husa-auto-de-protectie-bancheta-sau-portbagaj-pentru-transport-animale-144x144-cm-.jpg |
|
666 |
500 |
1764961 |
| 1856990 |
1153153 |
product |
0 |
1857242 |
M |
0 |
set-chei-pentru-demontare-radio-auto-blaupunkt-phillips-compatibil-opel-2-buc-.jpg |
|
800 |
600 |
1857242 |
| 1856992 |
1153155 |
product |
0 |
1857244 |
M |
0 |
set-chei-pentru-demontare-radio-auto-compatibil-vw-audi-2-buc-.jpg |
|
800 |
600 |
1857244 |
| 1859515 |
1153734 |
product |
0 |
1859767 |
M |
0 |
tester-de-presiune-analogic-pt-pneuri---gbz-55779-brico-decohome.jpg |
|
1600 |
1600 |
1859767 |
| 1990241 |
1230911 |
product |
0 |
1990493 |
M |
0 |
parasolar-auto-universal-retractabil-pentru-parbriz-sau-luneta-protectie-uv-150x65-cm-gri-.jpg |
|
500 |
500 |
1990493 |
| 1990852 |
1231165 |
product |
0 |
1991104 |
M |
0 |
camera-auto-165-175-18514-.png |
|
682 |
455 |
1991104 |
| 1990853 |
1231166 |
product |
0 |
1991105 |
M |
0 |
camera-auto-600-65016-.png |
|
682 |
455 |
1991105 |
| 2251912 |
1338749 |
product |
0 |
2252164 |
M |
0 |
set-huse-scaune-fataspate-art210fs-super-soft---diverse-culori-.jpg |
|
600 |
600 |
2252164 |
| 2252184 |
1338924 |
product |
0 |
2252436 |
M |
0 |
suport-telefon-cu-incarcator-wireless-s5-2in1-.jpg |
|
800 |
800 |
2252436 |
| 2581017 |
1434961 |
product |
0 |
2581270 |
M |
0 |
antena-auto-ornamentala-universala-tip-rechin-din-plastic-15x55x7cm-culoare-alb-.jpg |
|
500 |
500 |
2581270 |
| 3373481 |
697773 |
product |
0 |
3373734 |
M |
0 |
bk14300.png |
|
800 |
800 |
3373734 |
| 3648898 |
1663556 |
product |
0 |
3649151 |
M |
0 |
opel--chevrolet---carcasa-tip-cheie-briceag-cu-3-butoane-maniamall-cars.jpg |
|
177 |
177 |
3649151 |
| 3946704 |
1731742 |
product |
0 |
3946957 |
M |
0 |
Abtibild-reflectorizant-5cm-X-40-T078-MRA36-150621-4.jpg |
Abtibild reflectorizant 5cm X 40 T078 MRA36-150621-4 |
600 |
600 |
3946957 |
| 3946878 |
1731846 |
product |
0 |
3947131 |
M |
0 |
Eleron-portbagaj---haion-universal-negru-lucios-COD--UNIV-091-MRA36-040621-19.jpg |
Eleron portbagaj / haion universal negru lucios COD: UNIV-091 MRA36-040621-19 |
1200 |
1200 |
3947131 |
| 3947127 |
1732013 |
product |
0 |
3947380 |
M |
0 |
Set-2-becuri-halogen-H7-Osram-Cool-Blue-Intense-12V--55W-MRA36-120421-1.jpg |
Set 2 becuri halogen H7 Osram Cool Blue Intense 12V, 55W MRA36-120421-1 |
555 |
555 |
3947380 |
| 3947349 |
1732158 |
product |
0 |
3947602 |
M |
0 |
Lada-frigorifica-termoelectrica-capacitate-21L-tensiune-alimentare-12V-putere-48W-cu-adaptor-220V-Breckner-Germany-BK87829-MRA36-220221-10.png |
Lada frigorifica termoelectrica capacitate 21L tensiune alimentare 12V putere 48W cu adaptor 220V Breckner Germany BK87829 MRA36-220221-10 |
1200 |
1200 |
3947602 |
| 3947488 |
1732251 |
product |
0 |
3947741 |
M |
0 |
Rola-cheder-cu-adeziv-4-5-metri-COD--508802-045-MRA36-270121-2.png |
Rola cheder cu adeziv 4.5 metri COD: 508802/045 MRA36-270121-2 |
507 |
269 |
3947741 |
| 3947673 |
1732357 |
product |
0 |
3947926 |
M |
0 |
Prelata-moto-atv--marimea-S-1-7-0-6-0-8m-MRA36-041220-1.jpg |
Prelata moto/atv, marimea S 1.7*0.6*0.8m MRA36-041220-1 |
1000 |
774 |
3947926 |