{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "35.13"
},
"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": 78,
"rows_produced_per_join": 78,
"filtered": "100.00",
"cost_info": {
"read_cost": "27.33",
"eval_cost": "7.80",
"prefix_cost": "35.13",
"data_read_per_join": "132K"
},
"used_columns": [
"name",
"object_id",
"type",
"dispatch",
"path",
"lang_code"
],
"attached_condition": "((`nuie_scalesta_net`.`cscart_seo_names`.`object_id` in (98446,98449,98450,98452,98455,98485,98486,98487,98488,98489,98491,98493,98494,98495,98503,98504,98505,98506,98507,98508,99509,99510,99513,99514,99517,99518,100789,100790,100791,100792,100793,100794,100795,100796,100797,100798,100799,100800,100801,100802,100803,100804,100805,100806,100807,100808,100809,100810,100811,100812,100813,100814,100815,100816,100817,100818,100819,100820,100821,100822,100823,100824,100825,100826,100827,100828,100829,100830,100831,100832,100833,100834,100835,100836,100837,100838,100839,100840)) and (`nuie_scalesta_net`.`cscart_seo_names`.`type` = 'p') and (`nuie_scalesta_net`.`cscart_seo_names`.`dispatch` = '') and (`nuie_scalesta_net`.`cscart_seo_names`.`lang_code` = 'en'))"
}
}
}
| product_id | seo_name | seo_path |
|---|---|---|
| 98446 | e395-p | 7184/7219 |
| 98449 | e413-m | 7184/7219 |
| 98450 | e421-p | 7184/7219 |
| 98452 | e721-p | 7184/7219 |
| 98455 | e821-p | 7184/7219 |
| 98485 | ek1510-p | 7184/7219 |
| 98486 | ek303-p | 7184/7219 |
| 98487 | ek304-p | 7184/7219 |
| 98488 | ek305-p | 7184/7219 |
| 98489 | ek307-p | 7184/7219 |
| 98491 | ek310-p | 7184/7219 |
| 98493 | ek410-p | 7184/7219 |
| 98494 | ek710-p | 7184/7219 |
| 98495 | ek810-p | 7184/7219 |
| 98503 | er02-p | 7184/7219 |
| 98504 | er03-p | 7184/7219 |
| 98505 | er07-p | 7184/7219 |
| 98506 | er08-p | 7184/7219 |
| 98507 | er407-p | 7184/7219 |
| 98508 | er807-p | 7184/7219 |
| 99509 | pdt-000600-p | 7184/7219 |
| 99510 | pdt-000601-p | 7184/7219 |
| 99513 | pdt-000731-p | 7184/7219 |
| 99514 | pdt-000732-p | 7184/7219 |
| 99517 | pdt-000735-p | 7184/7219 |
| 99518 | pdt-000736-p | 7184/7219 |
| 100789 | was219-m | 7184/7219 |
| 100790 | was219bc-m | 7184/7219 |
| 100791 | was219bco-m | 7184/7219 |
| 100792 | was219bg-m | 7184/7219 |
| 100793 | was219bn-m | 7184/7219 |
| 100794 | was219co-m | 7184/7219 |
| 100795 | was219g-m | 7184/7219 |
| 100796 | was219n-m | 7184/7219 |
| 100797 | was220-p | 7184/7219 |
| 100798 | was220b-p | 7184/7219 |
| 100799 | was220bc-m | 7184/7219 |
| 100800 | was220bco-m | 7184/7219 |
| 100801 | was220bg-m | 7184/7219 |
| 100802 | was220bn-m | 7184/7219 |
| 100803 | was220bs-p | 7184/7219 |
| 100804 | was220co-m | 7184/7219 |
| 100805 | was220f-p | 7184/7219 |
| 100806 | was220g-m | 7184/7219 |
| 100807 | was220gm-p | 7184/7219 |
| 100808 | was220ig-p | 7184/7219 |
| 100809 | was220kg-p | 7184/7219 |
| 100810 | was220m-p | 7184/7219 |
| 100811 | was220me-p | 7184/7219 |
| 100812 | was220mw-p | 7184/7219 |
| 100813 | was220n-m | 7184/7219 |
| 100814 | was220pg-p | 7184/7219 |
| 100815 | was220pw-p | 7184/7219 |
| 100816 | was220r-p | 7184/7219 |
| 100817 | was221-m | 7184/7219 |
| 100818 | was221bc-m | 7184/7219 |
| 100819 | was221bco-m | 7184/7219 |
| 100820 | was221bg-m | 7184/7219 |
| 100821 | was221bn-m | 7184/7219 |
| 100822 | was221co-m | 7184/7219 |
| 100823 | was221g-m | 7184/7219 |
| 100824 | was221n-m | 7184/7219 |
| 100825 | was222-m | 7184/7219 |
| 100826 | was222bc-m | 7184/7219 |
| 100827 | was222bco-m | 7184/7219 |
| 100828 | was222bg-m | 7184/7219 |
| 100829 | was222bn-m | 7184/7219 |
| 100830 | was222co-m | 7184/7219 |
| 100831 | was222g-m | 7184/7219 |
| 100832 | was222n-m | 7184/7219 |
| 100833 | was305-p | 7184/7219 |
| 100834 | was305bc-m | 7184/7219 |
| 100835 | was305bco-m | 7184/7219 |
| 100836 | was305bg-m | 7184/7219 |
| 100837 | was305bn-m | 7184/7219 |
| 100838 | was305co-m | 7184/7219 |
| 100839 | was305g-m | 7184/7219 |
| 100840 | was305n-m | 7184/7219 |