{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "81.01"
},
"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": 35,
"rows_produced_per_join": 35,
"filtered": "100.00",
"index_condition": "((`portal`.`q_seo_names`.`object_id` in (9581,9582,9583,9584,9585,9586,9587,9588,9589,9590,9591,9592,9593,9594,9595,9596,9597,9598,9599,9600,9601,9602,9603,9604,9605,9606,9607,9608,9609,9610,9611,9612)) 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": "74.01",
"eval_cost": "7.00",
"prefix_cost": "81.01",
"data_read_per_join": "59K"
},
"used_columns": [
"name",
"object_id",
"type",
"dispatch",
"path",
"lang_code"
]
}
}
}
product_id | seo_name | seo_path |
---|---|---|
9581 | benaw-glow-in-the-dark-hardcase-new-macbook-pro-13inches-magenta | 299/383 |
9582 | benaw-glow-in-the-dark-hardcase-new-macbook-pro-13.3-turquoise | 299/383 |
9583 | benaw-lifesaver-keyboard-for-macbook-air-11-13-and-pro-13-13r-15-15r-russian | 299/383 |
9584 | benaw-lifesaver-touchbar-keyboard-cover-transparent | 299/383 |
9585 | kanex-chargesync-usb-type-a-to-lightning-cable | 190/202 |
9586 | kanex-3-port-car-charger | 190/199 |
9587 | kanex-3-port-car-charger-en | 190/199 |
9588 | kanex-gopower-shareable-car-charger | 190/199 |
9589 | kanex-ultraslim-mini-multi-sync-premium-bluetooth-keyboard-sync-4-devices | 299/383 |
9590 | kanex-usb-c-to-usb-2-0-charging-cable | 190/202 |
9591 | kanex-apple-certified-premium-lightning-to-usb-cable-with-durabraid-fiber | 190/202 |
9592 | kate-spade-new-york-gift-set-ring-stand-and-protective-hardshell-case-scallop-rose-gold-glitter-clear-for-iphone-xs-x | 190/195 |
9593 | kate-spade-new-york-gift-set-ring-stand-and-protective-hardshell-case-scallop-rose-gold-glitter-clear-for-iphone-xr | 190/195 |
9594 | kate-spade-new-york-gift-set-ring-stand-and-protective-hardshell-case-scallop-rose-gold-glitter-clear-for-iphone-xs-max | 190/191 |
9595 | kate-spade-new-york-gift-set-ring-stand-and-protective-hardshell-case-scallop-mermaid-glitter-clear-for-iphone-xs-x | 190/195 |
9596 | kate-spade-new-york-gift-set-ring-stand-and-protective-hardshell-case-scallop-mermaid-glitter-clear-for-iphone-xr | 190/195 |
9597 | kate-spade-new-york-gift-set-ring-stand-and-protective-hardshell-case-scallop-mermaid-glitter-clear-for-iphone-xs-max | 190/195 |
9598 | kate-spade-new-york-folio-hardcase-for-ipad-air-2-black-glitter | 190/191/419 |
9599 | kate-spade-new-york-folio-hardcase-for-ipad-air-2-metallic-gold | 190/191/419 |
9600 | kate-spade-new-york-folio-hardcase-for-ipad-mini-4-photographic-roses | 190/191 |
9601 | kate-spade-new-york-folio-hardcase-for-ipad-mini-4-rose-jade-glitter | 190/191 |
9602 | kate-spade-new-york-hybrid-hardshell-case-photographic-roses-for-iphone-6-6s | 190/191 |
9603 | kate-spade-new-york-wrap-case-for-iphone-8-7-saffiano-black | 190/191/418 |
9604 | kate-spade-new-york-wrap-case-for-iphone-8-7-saffiano-rose-gold | 190/191/418 |
9605 | kate-spade-new-york-liquid-glitter-is-my-favorite-color-gold-case-for-iphone-8-7-plus | 190/191 |
9606 | kate-spade-new-york-liquid-glitter-case-favorite-things-gold-for-iphone-8-7 | 190/191 |
9607 | kate-spade-new-york-protective-clear-glitter-case-for-iphone-7-plus-multi-glitter | 190/191/418 |
9608 | kate-spade-new-york-protective-hardshell-case-charlotte-stripe-gold-glitter-clear-for-iphone-xs-x | 190/191/418 |
9609 | kate-spade-new-york-protective-hardshell-case-charlotte-stripe-white-glitter-clear-fro-iphone-xs-x | 190/191/418 |
9610 | kate-spade-new-york-protective-hardshell-case-large-blossom-multi-gold-foil-with-gems-for-iphone-xs-x | 190/191/418 |
9611 | kate-spade-new-york-protective-hardshell-case-stripe-2-white-gold-for-iphone-xs-x | 190/191/418 |
9612 | kate-spade-new-york-liquid-glitter-case-good-times-gold-for-iphone-xs-x | 190/191 |