{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "46.81"
},
"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": 22,
"rows_produced_per_join": 22,
"filtered": "100.00",
"index_condition": "((`portal`.`q_seo_names`.`object_id` in (45888,45889,45890,45891,45892,45893,45894,45895,45896,45897,45898,45899,45900,45901,45902,45903)) 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": "42.41",
"eval_cost": "4.40",
"prefix_cost": "46.81",
"data_read_per_join": "37K"
},
"used_columns": [
"name",
"object_id",
"type",
"dispatch",
"path",
"lang_code"
]
}
}
}
product_id | seo_name | seo_path |
---|---|---|
45888 | zoook-metal-body-bluetooth-speaker-with-5w-output-and-1800mah-battery.-tf-card-support-chrome | 190/424 |
45889 | zoook-30w-ipx5-bluetooth-speaker-system-battery-of-5000mah-mic-aux-input-black | 190/424 |
45890 | zoook-10w-voice-control-e-ink-led-bluetooth-speaker-system-with-built-in-mic-aux-usb-tf-input-black | 190/424 |
45891 | zoook-compact-bluetooth-speaker-5w-crisp-elegant-sound-with-usb-tf-mic-grey | 190/424 |
45892 | zoook-aluminum-body-leather-cover-premium-ultra-small-6w-bluetooth-speaker-with-deep-bass-and-long-playing-time-free-carrying-pouch-black | 190/424 |
45893 | zoook-5-in-1-indoor-outdoor-bluetooth-speaker-with-masculine-looks.-supports-tf-card-fm-radio-aux-in-.controls-on-board-black | 190/424 |
45894 | zoook-disco-dancer-bluetooth-speaker-with-led-lights-disco-dancer-blackblue | 190/424 |
45895 | zoook-award-winning-50w-ipx5-bluetooth-speaker-system-battery-of-5200mah-mic-aux-input-blackyellow | 190/424 |
45896 | zoook-award-winning-60w-ipx5-bluetooth-speaker-system-mic-aux-tf-input-with-built-in-10000mah-powerbank-black | 190/424 |
45897 | zoook-zp-pbs5a-mobile-portable-charger-5000mah-polymer-ultra-slim-black | 190/194 |
45898 | zoook-mobile-portable-charger-5000mah-polymer-ultra-slim-black | 190/194 |
45899 | zoook-zp-pbs10e-worlds-smallest-superfast-10000mah-polymer-power-bank-navy-blue | 190/194 |
45900 | zoook-zp-pbs10-mobile-portable-charger-10000mah-polymer-ultra-slim-rubberized-finish-2a-input-and-3.1a-output-blackgrey | 190/194 |
45901 | zoook-zp-pbs10c-mobile-portable-charger-10000mah-polymer-triple-usb-with-lcd-display-ultra-sleek-black | 190/194 |
45902 | zoook-zp-pbs10f-ultra-slim-fast-charging-qi-supported-wireless-10-000-mah-power-bank-with-2-usb-ports-supports-2.1a-output-with-digital-number-display-polymer-black | 190/194 |
45903 | zoook-zp-pb10da-mobile-portable-charger-10000mah-compact-2a-input-and-2.1a-output-white | 190/194 |