{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "67.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": 28,
"rows_produced_per_join": 28,
"filtered": "100.00",
"index_condition": "((`portal`.`q_seo_names`.`object_id` in (1145,1144,1136,1135,1134,1090,1089,1088,1087,1086,1084,1083,1081,1013,1012,921,761,760,759,758,757,756,739,738,737,736,735,734)) 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": "61.61",
"eval_cost": "5.60",
"prefix_cost": "67.21",
"data_read_per_join": "47K"
},
"used_columns": [
"name",
"object_id",
"type",
"dispatch",
"path",
"lang_code"
]
}
}
}
product_id | seo_name | seo_path |
---|---|---|
734 | ladies-pouch-ice-cream | 12/13/38/83 |
735 | ladies-coin-holder-101 | 12/13/38/83 |
736 | ladies-pouch-zip | 12/13/38/83 |
737 | ladies-coin-holder | 12/13/38/83 |
738 | ladies-coin-holder-en | 12/13/38/83 |
739 | ladies-coin-holder-en-2 | 12/13/38/83 |
756 | forever-young-ladies-wallet-brown | 12/13/38/83 |
757 | forever-young-ladies-collection-card-holder-black | 12/13/38/83 |
758 | forever-young-ladies-collection-pink-pouch | 12/13/38/83 |
759 | forever-young-collection-ladies-hand-bag | 12/13/38/83 |
760 | forever-young-collection-ladies-pouch-pink | 12/13/38/83 |
761 | prettyzyz-collection-ladies-hand-bag-light-biscuit-color | 12/13/38/83 |
921 | charhoden-for-mom-necklace-open-heart-necklace-pendant-for-women-girls-necklace-xl001-rose-gold-with-gift-box | 12/13/44/46/293 |
1012 | fashionable-multi-design-bracelet-5-pcs-set-j40kk-assorted-color | 12/13/44/46/294 |
1013 | womens-alloy-with-diamond-and-carved-12-pieces-ring-set-j30kk | 12/13/44/46/296 |
1081 | women-sleeve-less-red-maxi-dress-large-size-l-jx-0046l-a02k | 12/13/14/16 |
1083 | women-sleeve-less-black-maxi-dress-size-extra-large-black-jx-0048xl-a02k | 12/13/14/16 |
1084 | women-sleeve-less-blue-maxi-dress-large-size-l-jx-0049l-a02k | 12/13/14/16 |
1086 | women-sleeve-less-maxi-dress-size-l-black-jx-0051l-a02k | 12/13/14/16 |
1087 | women-sleeveless-maxi-dress-red-size-extra-largejx-0052xl-a02k | 12/13/14/16 |
1088 | women-sleeve-less-maxi-dress-blue-size-extra-large-jx-0053xl-a02k | 12/13/14/16 |
1089 | women-sleeveless-maxi-dress-blue-size-medium-jx-0054m-a02k | 12/13/14/16 |
1090 | embroidered-gold-letter-queen-baseball-cap-flat-base-jx-0083-a60c | 12/13/44 |
1134 | embroidered-white-letter-king-design-baseball-cap-for-unisex-jx-0084-a60c | 12/13/44 |
1135 | embroidered-gold-letter-king-flat-base-baseball-cap-for-unisex-jx-0085-a60c | 12/13/44 |
1136 | embroidered-white-letter-queen-baseball-cap-for-unisex-jx-0086-a60c | 12/13/44 |
1144 | new-designer-womens-fashion-high-end-hand-woven-satin-knitting-knot-wedding-socialite-handbag-clutch-blue-jx-0155-a24k | 12/13/38/40 |
1145 | new-designer-womens-fashion-high-end-hand-woven-satin-knitting-knot-wedding-socialite-handbag-clutch-pink-jx-0156-a24k | 12/13/38/40 |