{
"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 (431225,431483,431058,431207,431430,431475,431496,431086,431479,430986,431036,431282,431351,431391,431450,431223,431059,431227,431437,430716,431294,431492,430996,431278,431296,431396,431435,431460,435511,431413,430777,431367,431221,431261,431323,431331,431485,431276,431258,431307,431312,431348,431471,431382,431448,431095,431477,431499,381714,431214,431310,431375,431449,431266,431299,430728,431491,431347,431366,431436,431441,431075,431418,431489,430709,431228,431265,431321,431400,431363,431486,431189,430670,431206,431370,431374,431388,387053,430774,430779,431209,431232,431256,431257,431379,387048,430710,431179,431404,431445,430668,431293,431277,431286,431462,431317,431473,431476,431320,431390)) 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 |
---|---|---|
381714 | dhome-familjare-en | 266/2577/2578 |
387048 | suite-ekskluzive-e-pershtatshme-per-dy-tre-ose-familje-me-kater-persona-x-m2 | 266/2577/2578 |
387053 | dhome-superiore-e-pershtatshme-per-familje-me-kater-persona-x-m2 | 266/2577/2578 |
430668 | product-430668 | 266/1936/2601 |
430670 | product-430670 | 266/1936/2601 |
430709 | product-430709 | 266/1936/2601 |
430710 | product-430710 | 266/1936/2601 |
430716 | product-430716 | 266/1936/2601 |
430728 | product-430728 | 266/1936/2601 |
430774 | product-430774 | 266/1936/2601 |
430777 | product-430777 | 266/1936/2601 |
430779 | product-430779 | 266/1936/2601 |
430986 | product-430986 | 266/1936/2601 |
430996 | product-430996 | 266/1936/2601 |
431036 | product-431036 | 266/1936/2601 |
431058 | product-431058 | 266/1936/2601 |
431059 | product-431059 | 266/1936/2601 |
431075 | product-431075 | 266/1936/2601 |
431086 | product-431086 | 266/1936/2601 |
431095 | product-431095 | 266/1936/2601 |
431179 | product-431179 | 266/1936/2601 |
431189 | product-431189 | 266/1936/2601 |
431206 | product-431206 | 266/1936/2601 |
431207 | product-431207 | 266/1936/2601 |
431209 | product-431209 | 266/1936/2601 |
431214 | product-431214 | 266/1936/2601 |
431221 | product-431221 | 266/1936/2601 |
431223 | product-431223 | 266/1936/2601 |
431225 | product-431225 | 266/1936/2601 |
431227 | product-431227 | 266/1936/2601 |
431228 | product-431228 | 266/1936/2601 |
431232 | product-431232 | 266/1936/2601 |
431256 | product-431256 | 266/1936/2601 |
431257 | product-431257 | 266/1936/2601 |
431258 | product-431258 | 266/1936/2601 |
431261 | product-431261 | 266/1936/2601 |
431265 | product-431265 | 266/1936/2601 |
431266 | product-431266 | 266/1936/2601 |
431276 | product-431276 | 266/1936/2601 |
431277 | product-431277 | 266/1936/2601 |
431278 | product-431278 | 266/1936/2601 |
431282 | product-431282 | 266/1936/2601 |
431286 | product-431286 | 266/1936/2601 |
431293 | product-431293 | 266/1936/2601 |
431294 | product-431294 | 266/1936/2601 |
431296 | product-431296 | 266/1936/2601 |
431299 | product-431299 | 266/1936/2601 |
431307 | product-431307 | 266/1936/2601 |
431310 | product-431310 | 266/1936/2601 |
431312 | product-431312 | 266/1936/2601 |
431317 | product-431317 | 266/1936/2601 |
431320 | product-431320 | 266/1936/2601 |
431321 | product-431321 | 266/1936/2601 |
431323 | product-431323 | 266/1936/2601 |
431331 | product-431331 | 266/1936/2601 |
431347 | product-431347 | 266/1936/2601 |
431348 | product-431348 | 266/1936/2601 |
431351 | product-431351 | 266/1936/2601 |
431363 | product-431363 | 266/1936/2601 |
431366 | product-431366 | 266/1936/2601 |
431367 | product-431367 | 266/1936/2601 |
431370 | product-431370 | 266/1936/2601 |
431374 | product-431374 | 266/1936/2601 |
431375 | product-431375 | 266/1936/2601 |
431379 | product-431379 | 266/1936/2601 |
431382 | product-431382 | 266/1936/2601 |
431388 | product-431388 | 266/1936/2601 |
431390 | product-431390 | 266/1936/2601 |
431391 | product-431391 | 266/1936/2601 |
431396 | product-431396 | 266/1936/2601 |
431400 | product-431400 | 266/1936/2601 |
431404 | product-431404 | 266/1936/2601 |
431413 | product-431413 | 266/1936/2601 |
431418 | product-431418 | 266/1936/2601 |
431430 | product-431430 | 266/1936/2601 |
431435 | product-431435 | 266/1936/2601 |
431436 | product-431436 | 266/1936/2601 |
431437 | product-431437 | 266/1936/2601 |
431441 | product-431441 | 266/1936/2601 |
431445 | product-431445 | 266/1936/2601 |
431448 | product-431448 | 266/1936/2601 |
431449 | product-431449 | 266/1936/2601 |
431450 | product-431450 | 266/1936/2601 |
431460 | product-431460 | 266/1936/2601 |
431462 | product-431462 | 266/1936/2601 |
431471 | product-431471 | 266/1936/2601 |
431473 | product-431473 | 266/1936/2601 |
431475 | product-431475 | 266/1936/2601 |
431476 | product-431476 | 266/1936/2601 |
431477 | product-431477 | 266/1936/2601 |
431479 | product-431479 | 266/1936/2601 |
431483 | product-431483 | 266/1936/2601 |
431485 | product-431485 | 266/1936/2601 |
431486 | product-431486 | 266/1936/2601 |
431489 | product-431489 | 266/1936/2601 |
431491 | product-431491 | 266/1936/2601 |
431492 | product-431492 | 266/1936/2601 |
431496 | product-431496 | 266/1936/2601 |
431499 | product-431499 | 266/1936/2601 |
435511 | gel-uv-trasparente-optima | 266/1936/2601 |