Query time 0.14993
JSON explain
{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "190.29"
},
"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 (1660621,1663150,1664049,1658333,1658334,1664157,1658506,1657840,1657777,1658557,1661197,1662527,1658427,1658811,1658265,1663182,1658593,1660401,1658270,1663613,1659564,1658864,1657833,1662451,1661407,1659246,1663612,2099795,1660547,1660154,1659920,1659832,1658398,1658504,1661697,1661022)))",
"cost_info": {
"read_cost": "73.21",
"eval_cost": "3.60",
"prefix_cost": "76.81",
"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.36",
"eval_cost": "3.60",
"prefix_cost": "115.77",
"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.92",
"eval_cost": "3.60",
"prefix_cost": "154.29",
"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 |
| 3642880 |
1657777 |
product |
0 |
3643133 |
M |
0 |
nuca-rotire-volan-pallino-maniamall-cars.jpg |
|
177 |
177 |
3643133 |
| 3642942 |
1657833 |
product |
0 |
3643195 |
M |
0 |
suport-doza-pahar-maxi-cooler-maniamall-cars.jpg |
|
177 |
177 |
3643195 |
| 3642949 |
1657840 |
product |
0 |
3643202 |
M |
0 |
cleme-de-precizie-pentru-tester-acumulator-micro-clips-4buc-45cm-maniamall-cars.jpg |
|
177 |
177 |
3643202 |
| 3643505 |
1658265 |
product |
0 |
3643758 |
M |
0 |
autocolant-3d-crom-sport-maniamall-cars.jpg |
|
177 |
177 |
3643758 |
| 3643510 |
1658270 |
product |
0 |
3643763 |
M |
0 |
autocolant-3d-crom-bear-paw-maniamall-cars.jpg |
|
177 |
177 |
3643763 |
| 3643578 |
1658333 |
product |
0 |
3643831 |
M |
0 |
bec-tip-led-12v-soclu-pl-t10-w21x95d-2buc-alb-dispersat-maniamall-cars.jpg |
|
177 |
177 |
3643831 |
| 3643579 |
1658334 |
product |
0 |
3643832 |
M |
0 |
bec-tip-led-12v-soclu-pl-t10-w21x95d-2buc-albastru-focalizat-maniamall-cars.jpg |
|
177 |
177 |
3643832 |
| 3643644 |
1658398 |
product |
0 |
3643897 |
M |
0 |
aparatori-usi-contour-5---2buc---crom-maniamall-cars.jpg |
|
177 |
177 |
3643897 |
| 3643677 |
1658427 |
product |
0 |
3643930 |
M |
0 |
cheie-filtru-ulei-cu-colier-metalic-lampa-maniamall-cars.jpg |
|
177 |
177 |
3643930 |
| 3643758 |
1658504 |
product |
0 |
3644011 |
M |
0 |
plasa-grila-spoiler-racing-argintiu---small-2x4mm-100x33cm-maniamall-cars.jpg |
|
177 |
177 |
3644011 |
| 3643760 |
1658506 |
product |
0 |
3644013 |
M |
0 |
plasa-grila-spoiler-racing-argintiu---medium-6x12mm---100x33cm-maniamall-cars.jpg |
|
177 |
177 |
3644013 |
| 3643811 |
1658557 |
product |
0 |
3644064 |
M |
0 |
plasa-grila-spoiler-racing-negru---small-2x4mm---120x20cm-maniamall-cars.jpg |
|
177 |
177 |
3644064 |
| 3643851 |
1658593 |
product |
0 |
3644104 |
M |
0 |
kit-de-ajustare-pentru-bare-snap-4buc---f-0---14cm-maniamall-cars.jpg |
|
177 |
177 |
3644104 |
| 3644080 |
1658811 |
product |
0 |
3644333 |
M |
0 |
filtru-aer-sport-din-burete-af-4---rosu-maniamall-cars.jpg |
|
177 |
177 |
3644333 |
| 3644136 |
1658864 |
product |
0 |
3644389 |
M |
0 |
prezoane-antifurt-jante-conice-m12x15mm-4buc---tip-b-maniamall-cars.jpg |
|
177 |
177 |
3644389 |
| 3644537 |
1659246 |
product |
0 |
3644790 |
M |
0 |
bec-12v---w12w---12w-bord-soclu-sticla-w2x46d-1buc-narva--maniamall-cars.jpg |
|
177 |
177 |
3644790 |
| 3644869 |
1659564 |
product |
0 |
3645122 |
M |
0 |
buson-rezervor-camion-din-metal-cromat-cu-cheie-kamar----80mm-maniamall-cars.jpg |
|
177 |
177 |
3645122 |
| 3645142 |
1659832 |
product |
0 |
3645395 |
M |
0 |
husa-scaun-fata-masaj-cu-magneti-1buc-carpoint-maniamall-cars.jpg |
|
177 |
177 |
3645395 |
| 3645231 |
1659920 |
product |
0 |
3645484 |
M |
0 |
set-sigurante-plate-mici-10buc---4cars-maniamall-cars.jpg |
|
177 |
177 |
3645484 |
| 3645476 |
1660154 |
product |
0 |
3645729 |
M |
0 |
lampa-de-lucru-cu-neon-230v-filson-maniamall-cars.jpg |
|
177 |
177 |
3645729 |
| 3645727 |
1660401 |
product |
0 |
3645980 |
M |
0 |
filtru-motorina-oe-ford---ford-transit-maniamall-cars.jpg |
|
177 |
177 |
3645980 |
| 3645873 |
1660547 |
product |
0 |
3646126 |
M |
0 |
lampa-stop-spate-stg-oe-ford---ford-transit-maniamall-cars.jpg |
|
177 |
177 |
3646126 |
| 3645947 |
1660621 |
product |
0 |
3646200 |
M |
0 |
bec-xenon-12v---d2s---35w-original-line-1buc---6000k-maniamall-cars.jpg |
|
177 |
177 |
3646200 |
| 3646365 |
1661022 |
product |
0 |
3646618 |
M |
0 |
filtru-ulei-mahle---mercedes-e-classsprinter-vw-lt-maniamall-cars.jpg |
|
177 |
177 |
3646618 |
| 3646541 |
1661197 |
product |
0 |
3646794 |
M |
0 |
huse-scaun-hastings-12buc---negrualbastru-maniamall-cars.jpg |
|
177 |
177 |
3646794 |
| 3646754 |
1661407 |
product |
0 |
3647007 |
M |
0 |
prelata-motocicleta-basic-garage---xl---box-maniamall-cars.jpg |
|
177 |
177 |
3647007 |
| 3647044 |
1661697 |
product |
0 |
3647297 |
M |
0 |
cutii-si-carcase-pt-baterii3-buc-aa-baterie-creioncu-intrerupator-cu-capac-maniamall-cars.jpg |
|
177 |
177 |
3647297 |
| 3647793 |
1662451 |
product |
0 |
3648046 |
M |
0 |
lupa-8-dioptrii-pt-lampa-de-lucru-led---cod-10797-maniamall-cars.jpg |
|
177 |
177 |
3648046 |
| 3647869 |
1662527 |
product |
0 |
3648122 |
M |
0 |
antifon---4-buc-maniamall-cars.jpg |
|
177 |
177 |
3648122 |
| 3648492 |
1663150 |
product |
0 |
3648745 |
M |
0 |
profil-izolator-autoadeziv-pt-ferestre-si-usi-profil-e---100-m-maro-9-mm-maniamall-cars.jpg |
|
177 |
177 |
3648745 |
| 3648524 |
1663182 |
product |
0 |
3648777 |
M |
0 |
sir-de-lumini-de-craciun---alb-cald-fir-argintiu---2-m-2-x-aa-maniamall-cars.jpg |
|
177 |
177 |
3648777 |
| 3648954 |
1663612 |
product |
0 |
3649207 |
M |
0 |
mercedes-benz---carcasa-tip-cheie-briceag-cu1-buton-lama-4-piste-maniamall-cars.jpg |
|
177 |
177 |
3649207 |
| 3648955 |
1663613 |
product |
0 |
3649208 |
M |
0 |
mercedes-benz---carcasa-tip-cheie-briceag-cu-1-buton-lama-2-piste-maniamall-cars.jpg |
|
177 |
177 |
3649208 |
| 3649399 |
1664049 |
product |
0 |
3649652 |
M |
0 |
cupla-remorca-60x60mm-750kg-pentru-ax-patrat-carpoint-maniamall-cars.jpg |
|
177 |
177 |
3649652 |
| 3649507 |
1664157 |
product |
0 |
3649760 |
M |
0 |
huse-scaun-camion-dedicate-daf-xf-set-11-locuri---negrugri-maniamall-cars.jpg |
|
177 |
177 |
3649760 |
| 5161675 |
2099795 |
product |
0 |
5161928 |
M |
0 |
carlig-de-fixare-usa-semiremorca-furgon-maniamall-cars.jpg |
|
177 |
177 |
5161928 |