{
"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 (14819,14820,14821,14822,14823,14824,14825,14826,14827,14828,14829,14830,14831,14832,14833,14834)) 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 |
---|---|---|
14819 | gear4-d3o-buckingham-case-for-ipad-pro-12.9-black | 190/551 |
14820 | galaxy-s7-edge-case-newshine-wallet-s-stand-feature-premium-wallet-case-with-stand-flip-folio-case-cover-for-samsung-galaxy-s7-edge-2016-owl-weave-galaxy-s7-edge | 190/191/418 |
14821 | peacechaosavintage-canvas-leather-messenger-traveling-briefcase-shoulder-laptop-bag | 299/383/512 |
14822 | dell-10h6f-xps-13-ultrabook-13-genuine-black-leather-attache-carry-bag | 299/383/512 |
14823 | cross-body-and-shoulder-laptop-bag-in-dark-brown-vegan-leather | 299/383/512 |
14824 | gootium-51130ka-canvas-laptop-shoulder-messenger-bag-leather-handles-for-men-and-women | 299/383/512 |
14825 | mosiso-laptop-shoulder-bag-for-13-13.3-inch-macbook-pro-macbook-air-notebook-computer-chevron-style-ultraportable-protective | 299/383/512 |
14826 | mosiso-polyester-vertical-style-water-repellent-laptop-sleeve-case-bag-cover-with-pocket-for-13-13.3-inch-macbook-pro-macbook-air-notebook-gray | 299/383/512 |
14827 | aogek-10-11-inch-laptop-sleeve-bag-premium-pu-leather-wallet-case-for-surface-3-10.8-inch-acer-one-10-10.1-inch-thinkpad-10-10.1-inch-and-more-brown | 299/383/512 |
14828 | evecase-diamond-foam-splash-and-shock-resistant-neoprene-sleeve-notebook-case-bag-for-dell-inspiron-15.6inch-dell-xps-15-laptop-chromebook-black | 299/383/512 |
14829 | puredicka-new-laptop-replacement-battery-pack-for-apple-a1309-battery-early-2011-late-2011-mid-2012-version-unibody-macbook-pro-15-12-months-warranty-li-polymer-9-cell-12896mah-95wh-7.4v | 299/383 |
14830 | bestcompu-a-20v-4.5a-90w-4pin-replacement-ac-adapter-for-dell-2001fp-r0423-adp-90fb-ultrasharp-2100fp-lse0202c2090-dell-20.1-flat-panel-tft-lcd-monitor-pa-9 | 299/383 |
14831 | solicea-65w-adapter-charger-power-cord-for-laptop-t-acer-aspire-one-cloudbook-ao1-131-ao1-431-iconia-w700-table-compatible-p-n-kp.06503.007-kp.06503.0006-pa-1650-80-pa-1650-68-pa-1700-02-adp-65mh | 299/383 |
14832 | pwr-65w-extra-long-14-ft-ac-adapter-laptop-charger-for-toshiba-portege-z830-z835-z930-z935-r700-r705-r830-r835-r935-satellite-s55-s75-u845-u845t-u845w-l455-l505-l645-l645d-l655-l655d-l675-l745-l755-l775-l855-l875-l875d-l955 | 299/383 |
14833 | zozo-extra-long-8.2ft-2.5m-usb-cable-of-ac-adapter-charger-power-supply-for-lenovo-yoga-3-pro-yoga-3-11-yoga-3-14-yoga-3-1470-yoga3-11-5y10-yoga3-14-ifi-yoga3-11-5y10-yoga-3-1470-yoga-900 | 299/383/384 |
14834 | 213349-001-laptop-power-cord-3-prong | 299/383 |