{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "42.61"
},
"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": 19,
"rows_produced_per_join": 19,
"filtered": "100.00",
"index_condition": "((`portal`.`q_seo_names`.`object_id` in (14465,14466,14467,14468,14469,14470,14471,14472,14473,14474,14475,14476,14477,14478,14479,14480)) 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": "38.81",
"eval_cost": "3.80",
"prefix_cost": "42.61",
"data_read_per_join": "32K"
},
"used_columns": [
"name",
"object_id",
"type",
"dispatch",
"path",
"lang_code"
]
}
}
}
product_id | seo_name | seo_path |
---|---|---|
14465 | 1-x-nikon-auto-focus-s-dx-18-55-18-105-18-135-55-200-mm-vr-lens-bayonet-mount-ring-part | 299/412/413 |
14466 | uxcell-camera-parts-62mm-to-82mm-lens-filter-step-up-ring-adapter-black | 299/412/413 |
14467 | jjc-rr-eos-58-mm-reverse-ring-for-canon-eos-cameras | 299/412/413 |
14468 | fotga-macro-af-auto-focus-extension-tube-10mm-16mm-set-dg-for-canon-eos-m-eos-m | 299/412/413 |
14469 | replacement-cap-for-sony-alpha-nex-6-e-3.5-5.6-pz-16-50mm-oss-camera-lens-cap-center-pinch-with-string-holder-keeper-strap | 299/412/413 |
14470 | kaiser-slip-on-lens-cap-for-lenses-with-an-outside-diameter-of-90mm-206990 | 299/412/413 |
14471 | astromania-6x30-finder-scope-black-provides-an-upright-non-reversed-image | 299/412/413 |
14472 | igadgitz-lightweight-small-universal-flexible-foam-mini-tripod-for-nikon-coolpix-a-p300-p310-p330-p340-p6000-p7000-p7100-p7700-p7800-black | 190/196 |
14473 | qi-wireless-charger-power-bank-momax-20000mah-power-charger-qi-wireless-charging-pad-external-battery-for-samsung-galaxy-note-8-s8-iphone-x-8-8-plus-and-more-black | 190/194 |
14474 | piel-frama-730ka-cinema-leather-case-for-12.9-inch-ipad-pro-iforte-black | 299/412/413 |
14475 | original-xiaomi-yi-smart-webcam-wireless-control-with-app-for-smartphone | 299/389 |
14476 | wii-to-hdmi-480p-converter-for-console-nintendo-wii | 300 |
14477 | pro-evolution-soccer-2008-pc-dvd | 299/422 |
14478 | the-settlers-rise-of-an-empire-pc-dvd | 299/422 |
14479 | homefront-the-revolution-day-one-edition-xbox-one | 299/422 |
14480 | age-of-empires-ii-gold-edition | 299/422 |