{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "45.41"
},
"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": 21,
"rows_produced_per_join": 21,
"filtered": "100.00",
"index_condition": "((`portal`.`q_seo_names`.`object_id` in (14481,14483,14484,14485,14486,14487,14488,14489,14490,14491,14492,14493,14494,14495,14496,14497)) 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": "41.21",
"eval_cost": "4.20",
"prefix_cost": "45.41",
"data_read_per_join": "35K"
},
"used_columns": [
"name",
"object_id",
"type",
"dispatch",
"path",
"lang_code"
]
}
}
}
product_id | seo_name | seo_path |
---|---|---|
14481 | call-of-duty-black-ops-wii | 299/422 |
14483 | name | 190/197 |
14484 | tp-link-300-mbps-wireless-n-vdsl-adsl-modem-router-support-modem-only-mode-1-usb-2.0-port-uk-plug-td-w9970 | 299/385 |
14485 | microsoft-universal-foldable-bluetooth-keyboard-for-apple-ipad-iphone-android-devices-and-windows-tablets-black | 190/420 |
14486 | 3m-cord-bundlers-with-command-strips | 6/184/189 |
14487 | bluelounge-yoyo-earbuds-organizer-green | 190/386 |
14488 | monoprice-fastening-tape-0.75inch-one-wrap-hook-and-loop-fastening-tape-5-yard-roll-green | 6/184 |
14489 | dotz-reusable-cord-straps-for-cord-and-cable-management-5-count-bright-colors-dcs201an5-c | 299/383/402 |
14490 | monoprice-marker-cable-tie-4-inch-18lbs-100pcs-pack-white | 299 |
14491 | d-2-rubber-duct-cord-cover-length-5ft-color-brown-cable-protector | 299 |
14492 | vankyo-aluminum-tripod-projector-stand-adjustable-laptop-stand-multi-function-stand-computer-stand-adjustable-height-17-to | 299/383 |
14493 | mustang-low-profile-projector-mount-mv-projsp-flat-b | 299/550 |
14494 | monoprice-speaker-wall-mounting-bracket-white-set-of-2-103013 | 299 |
14495 | m231-1-2-inch-black-on-white-tape-for-p-touch-labeler | 300/375 |
14496 | elite-screens-starframe-series-100-inch-16-9-active-3d-4k-ultra-hd-fixed-frame-home-theater-projector-screen-sf100hw2 | 299 |
14497 | monoprice-dvi-d-single-link-male-to-hdmi-female-adapter | 299/383 |