{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "44.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": 20,
"rows_produced_per_join": 20,
"filtered": "100.00",
"index_condition": "((`portal`.`q_seo_names`.`object_id` in (14803,14804,14805,14806,14807,14808,14809,14810,14811,14812,14813,14814,14815,14816,14817,14818)) 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": "40.01",
"eval_cost": "4.00",
"prefix_cost": "44.01",
"data_read_per_join": "33K"
},
"used_columns": [
"name",
"object_id",
"type",
"dispatch",
"path",
"lang_code"
]
}
}
}
product_id | seo_name | seo_path |
---|---|---|
14803 | vorfreudea-10-pack-cable-clips-and-cord-management-drops-3m-self-adhesive-stick-on-organizer-for-car-ethernet-pc-usb-iphone-hdmi-or-desk-large-single-1-white | 300/410 |
14804 | opso-apple-mfi-certified-1m-3.3-ft-lightning-8-pin-to-usb-charging-cable-cord-for-iphone-7-6s-6-plus-se-5s-5c-5-ipad-pro-air-2-ipad-mini-4-3-2-ipod-touch-nano-white | 190/202 |
14805 | mophie-2138-usb-to-lightning-cable-3-meters-for-apple-iphone-black | 190/202 |
14806 | iluv-2-in-1-lightning-cable-with-micro-usb-white | 299/383/402 |
14807 | startech.com-usa-llp-6-ft-beige-a-to-usb-2.0-cable-m-m | 12/50/84/88 |
14808 | monoprice-50ft-super-vga-m-m-cl2-rated-for-in-wall-installation-cable-w-ferrites-gold-plated | 299/383/402 |
14809 | dust-off-disposable-compressed-gas-duster-10-oz-cans-2-pack | 299/383 |
14810 | af-pc-spray-duster-invertible-cfc-free-non-flammable-125ml-ref-sdu125d | 248/544 |
14811 | ebags-professional-slim-junior-laptop-backpack-solid-black | 299/383/512 |
14812 | weekend-shopper-slim-laptop-backpack-business-back-pack-school-bookbag-daypack-for-women-and-men-fit-up-to-15.6-inch-laptop-black | 299/383/512 |
14813 | canvas-backpack-p.ku.vdsl-augur-series-vintage-canvas-leather-backpack-hiking-daypacks-computers-laptop-backpacks-unisex-casual-rucksack-satchel-bookbag-mountaineering-bag-for-men-women | 299/383/512 |
14814 | vangoddy-bonni-extra-cushioned-backpack-for-up-to-15.6-laptops-and-10.8-tablets-vgbonnibpnblu | 299/383/512 |
14815 | tomtoc-360a-protective-laptop-sleeve-compatible-with-new-macbook-air-13.3-retina-display-2018-a1932-13-inch-new-macbook-pro-a1989-a1706-a1708-surface-pro-6-5-4-water-resistant-laptop-briefcase | 299/383/512 |
14816 | case-logic-huxton-attache-15-blue-en | 299/383/512 |
14817 | kec-laptop-case-for-macbook-pro-13-2018-2017-2016-italian-leather-cover-a1989-a1706-a1708-touch-bar-dark-blue-leather | 299/383/512 |
14818 | gear4-d3o-buckingham-case-for-ipad-9.7-pro-and-air-2-black | 190/551 |