{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "68.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": 30,
"rows_produced_per_join": 30,
"filtered": "100.00",
"index_condition": "((`portal`.`q_seo_names`.`object_id` in (41339,29354,29395,29396,30848,30922,31133,13615,13626,13652,10455,10456,1519,1520,1521,1524,1525,1526,1527,1143,1142,1141,1140,1139,1138,1137)) 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": "62.01",
"eval_cost": "6.00",
"prefix_cost": "68.01",
"data_read_per_join": "50K"
},
"used_columns": [
"name",
"object_id",
"type",
"dispatch",
"path",
"lang_code"
]
}
}
}
product_id | seo_name | seo_path |
---|---|---|
1137 | big-box-ms.-sunglasses-arrow-sunglasses-polarized-lens-true-color-film-thin-face-lens-color-leopard-frame-jx-0121-a11k | 12/604/91/93 |
1138 | big-box-ms.-sunglasses-arrow-polarized-lens-true-color-film-thin-face-lens-color-black-frame-cherry-blossom-pink-frame-jx-0122-a31k | 12/604/91/93 |
1139 | womens-box-sunglasses-arrow-polarized-true-color-film-thin-face-lens-color-black-barbie-pink-frame-color-jx-0123-a31k | 12/604/91/93 |
1140 | womens-box-sunglasses-arrow-polarized-true-color-film-thin-face-lens-color-c12-jx-0124-a11k | 12/604/91/93 |
1141 | big-box-ms.-sunglasses-arrow-polarized-true-color-film-thin-face-lens-color-black-purple-green-frame-color-jx-0125-a31k | 12/604/91/93 |
1142 | big-box-ms.-sunglasses-arrow-polarized-true-color-film-thin-face-lens-color-c3-brown-frame-color-jx-0126-a11k | 12/604/91/93 |
1143 | womens-polarized-tort-round-sunglasses-black-jx-0127-a11k | 12/604/91/93 |
1519 | marvel-avengers-sunglass-with-wallet-sgw-001 | 12/604/91 |
1520 | disney-cars-sunglass-with-wallet-sgw-002 | 12/604/91 |
1521 | disney-frozen-3d-sunglasses-wd19543 | 248 |
1524 | disney-cars-3d-sunglasses-wd19542 | 12/604/91/99 |
1525 | marvel-spiderman-3d-sunglasses-mv15383 | 12/604/91/99 |
1526 | marvel-avengers-3d-sunglasses-mv15384 | 12/604/91/99 |
1527 | marvel-captian-america-3d-sunglasses-mv15385 | 12/604/91/99 |
10455 | xiaomi-ts-brand-polarized-stainless-sun-lenses-glasses-100-uv-isolation-colorful-xiaomi-mijia-sunglasses-women-man | 12/604/91/93 |
10456 | xiaomi-mijia-ts-computer-glasses-uv400-anti-blue-light-ray-glasses-radiation-protection-red | 12/604/91/92 |
13615 | x800-tactical-goggles-army-glasses-3-lenses-kit-windproof-uv400-anti-fog-anti-scratch-for-wargame-cycling | 12/604/91 |
13626 | anti-glaring-vision-driver-uv-400-night-driving-sunglasses-brown | 12/604/91/99 |
13652 | kaleidoscope-glasses-rainbow-lens-prism-diffraction-black-by-rave-raptor | 12/604/91/99 |
29354 | ski-goggles-outdoor-double-anti-fog-big-ski-mask-glasses-skiing-snow-snowboard-goggles | 12/604/91 |
29395 | the-classic-round-polarized-sunglasses-yjmh060-3-en | 12/604/91 |
29396 | wolfbike-brand-uv400-men-women-coating-polarized-sunglasses-safety-eyewear-goggle-for-riding-red | 12/604/91 |
30848 | xiaomi-mijia-turok-steinhardt-ts-clip-anti-blue-lens-yellow-color | 12/604/91 |
30922 | xiaomi-mijia-anti-blue-light-goggles-pro-blue-ink-color | 12/604/91 |
31133 | xiaomi-mijia-anti-blue-ray-goggles-pro-transparent-white | 12/604/91/94 |
41339 | daniel-kleinpolarized-wayfarer-sunglasses-dk1087c368 | 12/604/91/93 |