{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "14.01"
},
"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": 20,
"rows_produced_per_join": 20,
"filtered": "100.00",
"index_condition": "((`softwarepirmam_hewadelivard_cscart_4`.`cscart_seo_names`.`object_id` in (10447,10460,10400,10397,10399,10403,10402,10401,10404,10356,10351,10368,10009,10012,10474,10420,10387,10354,10428,10453)) and (`softwarepirmam_hewadelivard_cscart_4`.`cscart_seo_names`.`type` = 'p') and (`softwarepirmam_hewadelivard_cscart_4`.`cscart_seo_names`.`dispatch` = '') and (`softwarepirmam_hewadelivard_cscart_4`.`cscart_seo_names`.`lang_code` = 'en'))",
"cost_info": {
"read_cost": "12.01",
"eval_cost": "2.00",
"prefix_cost": "14.01",
"data_read_per_join": "33K"
},
"used_columns": [
"name",
"object_id",
"type",
"dispatch",
"path",
"lang_code"
]
}
}
}
| product_id | seo_name | seo_path |
|---|---|---|
| 10009 | hausberg-electric-toaster-machine | 372/466/573 |
| 10012 | hausberg-electric-mixer-hb-4120ng | 372/466/574 |
| 10351 | hausberg-hb-29-hair-dryer | 577/473/474 |
| 10354 | hausberg-hb-32rz-hair-straightener | 577/473/475 |
| 10356 | hausberg-hb-33rz-hair-straightener | 577/473/475 |
| 10368 | hausberg-hb-6011ab-kitchen-scale | 372 |
| 10387 | hausberg-hb-7825ng-steam-iron | 372/587 |
| 10397 | hausberg-hb-2029gr-handheld-vacuum-cleaner | 372/384 |
| 10399 | hausberg-hb-2035ab-handheld-vacuum-cleaner | 372/384 |
| 10400 | hausberg-hb-2890ng-portable-carpet-washer-vacuum-cleaner | 372/384 |
| 10401 | hausberg-hb-2835au-drum-vacuum-cleaner | 372/384 |
| 10402 | hausberg-hb-2837in-drum-vacuum-cleaner | 372/384 |
| 10403 | hausberg-hb-2820rs-bagless-vacuum-cleaner | 372/384 |
| 10404 | hausberg-hb-2823au-bagless-vacuum-cleaner | 372/384 |
| 10420 | hausberg-hb-7675ng-hand-blender | 372/466/574 |
| 10428 | hausberg-hb-2365-electric-fryer | 372/466/467 |
| 10447 | hausberg-hb-80rz-electric-epilator-for-smooth-and-long-lasting-hair-removal | 577/578 |
| 10453 | hausberg-hb-8565ng-radiant-electric-heater-for-efficient-indoor-heating | 372/566/597 |
| 10460 | hausberg-hb-8810ng-carbon-electric-heater-for-fast-and-efficient-heating | 372/566/597 |
| 10474 | hausberg-hbh02f-universal-tv-wall-mount-bracket-for-secure-viewing | 166/423 |