{
"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 (9805,9806,9807,9808,9809,9810,9811,9812,9813,9814,9815,9816,9817,9818,9819,9820)) 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 |
---|---|---|
9805 | olloclip-4-in-1-lens-with-pendant-silver-lens-black-clip-for-iphone-6-6plus | 190/429 |
9806 | otl-on-ear-junior-headphone-batman-the-brave-and-the-bold | 190/200 |
9807 | wonder-woman-tween-on-ear-headphone | 190/200 |
9808 | superman-on-ear-headphones-man-of-steel-superman-logo | 190/200 |
9809 | hello-kitty-apple-junior-on-ear-headphone-dotty-kitty | 301 |
9810 | hello-kitty-apple-junior-on-ear-headphone-unicon-kitty | 301 |
9811 | hello-kitty-on-ear-folding-headphone-kitty-see-lover | 190/386 |
9812 | hello-kitty-on-ear-folding-headphone-couture-kitty | 190/386 |
9813 | otl-on-ear-folding-headphone-lol-glam-club | 190/386 |
9814 | otl-on-ear-folding-headphone-lol-multi-club | 190/386 |
9815 | otl-on-ear-junior-headphone-pokeball | 190/386 |
9816 | otl-on-ear-junior-headphone-pikachu-face-pattern | 190/386 |
9817 | panzerglass-screen-protector-privacy-for-ipad-mini-4 | 190/192 |
9818 | panzerglass-for-ipad-pro-12.9 | 190/192 |
9819 | panzerglass-apple-watch-series-4-40mm | 190/192 |
9820 | panzerglass-apple-watch-series-4-44mm-en | 190/192 |