{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "140.11"
},
"table": {
"table_name": "cscart_seo_names",
"access_type": "range",
"possible_keys": [
"PRIMARY",
"dispatch"
],
"key": "PRIMARY",
"used_key_parts": [
"object_id",
"type",
"dispatch",
"lang_code"
],
"key_length": "206",
"rows_examined_per_scan": 100,
"rows_produced_per_join": 100,
"filtered": "100.00",
"cost_info": {
"read_cost": "120.11",
"eval_cost": "20.00",
"prefix_cost": "140.11",
"data_read_per_join": "169K"
},
"used_columns": [
"name",
"object_id",
"type",
"dispatch",
"path",
"lang_code"
],
"attached_condition": "((`webmarco`.`cscart_seo_names`.`object_id` in (391789,265231,81619,285940,81632,271489,81662,339530,265039,265034,285937,271497,387095,81615,392212,285942,339446,271493,81639,271504,265258,81706,265031,339514,264987,265041,265261,265263,339551,271500,339521,286476,81649,264988,285945,271506,265244,265256,271496,271492,339501,151897,339499,285939,339495,339721,366887,392150,81622,392214,392215,265038,81652,271498,81697,339494,265242,339503,339531,224456,81693,339516,285938,81660,271510,359818,285943,271503,339539,285941,339447,339509,81669,271494,264989,285946,264990,271502,265232,265254,339636,285966,285970,114755,339637,339492,285968,339538,369244,271490,339506,265250,265001,265237,271505,339724,392179,339635,81628,339502)) and (`webmarco`.`cscart_seo_names`.`type` = 'p') and (`webmarco`.`cscart_seo_names`.`dispatch` = '') and (`webmarco`.`cscart_seo_names`.`lang_code` = 'en'))"
}
}
}
product_id | seo_name | seo_path |
---|---|---|
81615 | buffalo-pizza-en | 266/2404 |
81619 | bufalina-pizza-en-en | 266/2404 |
81622 | calamari-pizza-en | 266/2404 |
81628 | stuffed-trousers-en | 266/2404 |
81632 | smooth-calzone-en | 266/2404 |
81639 | pizza-capricciosa-en-en | 266/2404 |
81649 | raw-pizza-en | 266/2404 |
81652 | raw-and-grana-pizza-en | 266/2404 |
81660 | pizza-fattoria-en | 266/2404 |
81662 | pizza-funghi-en | 266/2404 |
81669 | pizza-mushrooms-and-cream-en | 266/2404 |
81693 | pizza-philadelphia-en | 266/2404 |
81697 | tuna-pizza-en | 266/2404 |
81706 | cooked-ham-pizza-en | 266/2404 |
114755 | nanotreatments-en | 266/341/342 |
151897 | argenteria-a-manerba-del-garda | 266/1907 |
224456 | car-rental-en-2 | 266/327/1695/2599 |
264987 | meso-italian-sq | 266/2373/2374 |
264988 | meso-spanish-sq | 266/2373/2374 |
264989 | meso-english-sq | 266/2373/2374 |
264990 | meso-german-sq | 266/2373/2374 |
265001 | course-physical-sq | 266/2373/2374 |
265031 | shqiperi-gjermani-sq | 266/2577/2604 |
265034 | shqiperi-itali-sq | 266/2577/2604 |
265038 | institute-of-belleza-san-francesco-it-3 | 266/1907 |
265039 | institute-of-belleza-san-francesco-it-4 | 266/1907 |
265041 | institute-of-belleza-san-francesco-it-6 | 266/1907 |
265231 | ingolstadt | 266/2577/2604 |
265232 | mannheim | 266/2577/2604 |
265237 | gottingen | 266/2577/2604 |
265242 | hannover | 266/2577/2604 |
265244 | hamburg | 266/2577/2604 |
265250 | taranto | 266/2577/2604 |
265254 | cosenza | 266/2577/2604 |
265256 | villa-san-giovanni | 266/2577/2604 |
265258 | acireale | 266/2577/2604 |
265261 | ragusa | 266/2577/2604 |
265263 | marina | 266/2577/2604 |
271489 | alfa-romeo-156 | 266/327/1695/2599 |
271490 | alfa-romeo-159 | 266/327/1695/2599 |
271492 | citroen-saxo-1 | 266/327/1695/2599 |
271493 | citroen-saxo-2 | 266/327/1695/2599 |
271494 | citroen-saxo-3 | 266/327/1695/2599 |
271496 | citroen-c3-en-2 | 266/327/1695/2599 |
271497 | citroen-xsara | 266/327/1695/2599 |
271498 | dacia-logan-en | 266/327/1695/2599 |
271500 | dacia-sandero-2020 | 266/327/1695/2599 |
271502 | kia-carens | 266/327/1695/2599 |
271503 | opel-vectra | 266/327/1695/2599 |
271504 | alfa-romeo-156-2004 | 266/327/1695/2599 |
271505 | peugeot-407 | 266/327/1695/2599 |
271506 | renault-espace-2006 | 266/327/1695/2599 |
271510 | vw-transporter | 266/327/1695/2599 |
285937 | tapparelle-blindate | 266/356 |
285938 | tapparelle | 266/356 |
285939 | serramenti-elettrici | 266/356 |
285940 | tapparelle-in-alluminio | 266/356 |
285941 | riparazione-tapparelle | 266/356 |
285942 | tapparelle-motorizzate | 266/356 |
285943 | motorizzazione-tapparelle | 266/356 |
285945 | servizio-fabbro-in-pronto-intervento | 266/356 |
285946 | pronto-intervento | 266/356 |
285966 | pronto-intervento-tapparelle | 266/356 |
285968 | riparazione-tapparelle-bloccate | 266/356 |
285970 | fabbro | 266/356 |
286476 | pastrim-pishinash | 266/356/393/1516 |
339446 | gandoil-toreno-sport-sae-5w-30-full-synthetic-4lt | 266/394/9940 |
339447 | gandoil-toreno-sport-sae-5w-30-full-synthetic-5lt | 266/394/9940 |
339492 | mpataria-bosch-s4004-60ah-540a-0092s40040 | 266/394/9942 |
339494 | mpataria-bosch-70ah | 266/394/9942 |
339495 | mpataria-smart-kleistoy-typoy-62ah-deksia | 266/394/9942 |
339499 | mpataria-smart-kleistoy-typoy-110ah-aristeri | 266/394/9942 |
339501 | mpataria-smart-kleistoy-typoy-82ah-deksia-japan | 266/394/9942 |
339502 | mpataria-smart-kleistoy-typoy-230ah-aristeri | 266/394/9942 |
339503 | mpataria-smart-kleistoy-typoy-65ah-aristeri | 266/394/9942 |
339506 | mpataria-wolf-50-ah | 266/394/9942 |
339509 | mpataria-bat44-380r-furya | 266/394/9942 |
339514 | bosch-mpataria-skafoys-fortigoy-me-khoritikotita-145ah-kai-cca-800a | 266/394/9942 |
339516 | bosch-mpataria-fortigoy-skafoys-t50800-me-khoritikotita-225ah-kai-cca-1150a | 266/394/9942 |
339521 | varta-blue-dynamic-efb-n60-60ah-kai-cca-640a-en | 266/394/9942 |
339530 | mpataria-aytokinitoy-varta-b34-12v-45ah-japan-korean-cars-en | 266/394/9942 |
339531 | varta-a13-40ah-kai-cca-330a-japan-korean-cars-en | 266/394/9942 |
339538 | mpataria-vpm-top-energy-45ah-en | 266/394/9942 |
339539 | mpataria-vpm-top-energy-60ah-en | 266/394/9942 |
339551 | mpataria-bosch-s4008-74ah-680a-0092s40080 | 266/394/9942 |
339635 | varta-silver-dynamic-d52-60ah-kai-cca-680a | 266/394/9942 |
339636 | varta-silver-dynamic-g14-95ah-kai-cca-850a-en | 266/394/9942 |
339637 | varta-blue-dynamic-efb-n95-95ah-kai-cca-850a-en | 266/394/9942 |
339721 | varta-start-stop-plus-570901076-mpataria-70ah-agm-en | 266/394/9942 |
339724 | mpataria-bosch-72ah-s4-0092s40070-ford-en | 266/394/9942 |
359818 | elettricista | 266 |
366887 | linja-1 | 266/2577 |
369244 | maglioncino-intrecciato | 266/930/932/933/953 |
387095 | shkalle-per-shtepi-druri | 266/443/1505 |
391789 | veshje-fasadash | 266/443 |
392150 | linja-shqiperi-gjermani | 266/2577 |
392179 | udhetim-ne-stamboll-me-avion-3-dite | 266/2577 |
392212 | ndertime-shtepish-private | 266/443 |
392214 | ndertime-shkollash | 266/443 |
392215 | ndertime-spitalesh | 266/443 |