{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "42.04"
},
"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": 30,
"rows_produced_per_join": 30,
"filtered": "100.00",
"cost_info": {
"read_cost": "36.04",
"eval_cost": "6.00",
"prefix_cost": "42.04",
"data_read_per_join": "50K"
},
"used_columns": [
"name",
"object_id",
"type",
"dispatch",
"path",
"lang_code"
],
"attached_condition": "((`webmarco`.`cscart_seo_names`.`object_id` in (426897,415377,388453,389558,390161,390193,390198,389507,388957,415496,389263,390209,390316,388958,390273,389359,388544,388479,389452,390257,388513,389873,390129,389532,390192,389827,388454,390243,390164,389428)) 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 |
---|---|---|
388453 | 155-65-r14-75t-brillantis2 | 6328/10437/10438 |
388454 | 155-70-r13-75t-brillantis2 | 6328/10437/10438 |
388479 | 175-70-r14-84t-brillantis2-xl | 6328/10437/10438 |
388513 | 195-55-r15-85v-brav3-3hm | 6328/10437/10438 |
388544 | 205-80-r16-104t-xl-brav-4x4 | 6328/10437/10439 |
388957 | 275-45-r19-108v-tl-xl-fr-4x4contact-no | 6328/10437/10439 |
388958 | 275-45-r19-108y-xl-4x4-sportcontact-n0-fr | 6328/10437/10439 |
389263 | 13.0-65-18-16pr-knk48-agrikultural-tyre | 6328/10437/10446 |
389359 | 420-85-r24-16.9-r24-agro10 | 6328/10437/10446 |
389428 | 7.50-16-8pr-knk50 | 6328/10437/10446 |
389452 | 9.5-32-8pr-knk50 | 6328/10437/10446 |
389507 | 235-60-r17-102h-mont-pro-ht782 | 6328/10437/10439 |
389532 | 255-60-r18-112v-xl-mont-pro-hp881 | 6328/10437/10439 |
389558 | 175-65-r15-84h-westlake-z-107 | 6328/10437/10438 |
389827 | 225-65-r17-102t-latitude-tour | 6328/10437/10439 |
389873 | 295-40-r20-110w-latitude-sport-xl | 6328/10437/10439 |
390129 | 195-55-r15-85v-sunwide-rs-one | 6328/10437/10438 |
390161 | 225-45-r17-91y-dynaxer-hp3 | 6328/10437/10438 |
390164 | 225-45-r17-94v-kormoran-uhp-verore | 6328/10437/10438 |
390192 | 245-45-zr19-102y-xl-greentrac | 6328/10437/10438 |
390193 | 245-50-r18-104w-hf330-habilead | 6328/10437/10438 |
390198 | 245-70-r16-lt-mt772-10pr-118-115q-tl-rbl-ms-ep-maxxis | 6328/10437/10439 |
390209 | 255-50-r19-107w-habilead-rs26 | 6328/10437/10438 |
390243 | 275-40-zr22-107y-xl-quest-x-greentrac | 6328/10437/10439 |
390257 | 305-70-r19.5-18pr-r329 | 6328/10437/10440 |
390273 | 315-80-r22.5-156-150l-endurace-rd2-ms-3pmsf-tl | 6328/10437/10440 |
390316 | 9.5-22-8pr-speedways-grip-king | 6328/10437/10446 |
415377 | grenlander-225-45-r17-94w-grenlander | 6328/10437/10438 |
415496 | zextour-225-45-r17-zextour-premium-ls665 | 6328/10437/10438 |
426897 | continental-185-55-r15-82t-cwc-37-11-continental | 6328/10437/10438 |