{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "99.21"
},
"table": {
"table_name": "q_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": 48,
"rows_produced_per_join": 48,
"filtered": "100.00",
"index_condition": "((`portal`.`q_seo_names`.`object_id` in (40744,40745,40758,40759,40761,40768,40769,40770,40776,40788,40789,40790,40791,40792,40793,40794,40795,40796,40809,40821,40827,40828,40829,40830,40831,40832,40833,40834,40835,40836,40837,40839)) and (`portal`.`q_seo_names`.`type` = 'p') and (`portal`.`q_seo_names`.`dispatch` = '') and (`portal`.`q_seo_names`.`lang_code` = 'en'))",
"cost_info": {
"read_cost": "89.61",
"eval_cost": "9.60",
"prefix_cost": "99.21",
"data_read_per_join": "81K"
},
"used_columns": [
"name",
"object_id",
"type",
"dispatch",
"path",
"lang_code"
]
}
}
}
product_id | seo_name | seo_path |
---|---|---|
40744 | intex-my-sea-friends-pool-57482np | 207/469/615 |
40745 | intex-beach-wave-swim-center-pool-57495np | 207/469/615 |
40758 | intex-yellow-duck-ride-on-57556np | 207/469/615 |
40759 | intex-swan-ride-on-57557np | 207/469/615 |
40761 | intex-unicorn-ride-on-57561np | 207/469/615 |
40768 | intex-kickboard-pool-school-step-3-58167ee | 207/469/615 |
40769 | intex-kickboard-pool-school-step-3-58167eu | 207/469/615 |
40770 | intex-color-whirl-tube-58202eu | 207/469/615 |
40776 | intex-canopy-island-58292eu | 207/469/615 |
40788 | intex-winnie-the-pooh-baby-pool-58415np | 207/469/615 |
40789 | intex-crystal-blue-pool-58426np | 207/469/615 |
40790 | intex-soft-side-pool-58431np | 207/469/615 |
40791 | intex-cool-dots-pool-58439np | 207/469/615 |
40792 | intex-crystal-blue-pool-58446np | 207/469/615 |
40793 | intex-watermelon-pool-58448np | 207/469/615 |
40794 | intex-cool-dots-pool-58449np | 207/469/615 |
40795 | intex-frozen-swim-center-pool-58469np | 207/469/615 |
40796 | intex-8ft-x-18in-deep-blue-sea-snapset-pool-58472np | 207/469/615 |
40809 | intex-large-deluxe-arm-bands-58641np | 207/469/615 |
40821 | intex-pineapple-mat-58761eu | 207/469/615 |
40827 | intex-hotdog-mat-58771eu | 207/469/615 |
40828 | intex-french-fries-float-58775eu | 207/469/615 |
40829 | intex-potato-chips-float-58776eu | 207/469/615 |
40830 | intex-berry-pink-splash-float-58777eu | 207/469/615 |
40831 | intex-popcorn-mat-58779eu | 207/469/615 |
40832 | intex-hamburger-island-58780eu | 207/469/615 |
40833 | intex-palm-leaf-mat-58782eu | 207/469/615 |
40834 | intex-red-rose-mat-58783eu | 207/469/615 |
40835 | intex-angel-wings-mat-58786eu | 207/469/615 |
40836 | intex-pink-daisy-flower-mat-58787eu | 207/469/615 |
40837 | intex-king-kool-lounges-58802eu | 207/469/615 |
40839 | intex-tote-n-float-wave-mats-58807eu | 207/469/615 |