{
"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 (9789,9790,9791,9792,9793,9794,9795,9796,9797,9798,9799,9800,9801,9802,9803,9804)) 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 |
---|---|---|
9789 | native-union-night-cable-kv-type-a-to-type-c-3m-zebra | 190/202 |
9790 | native-union-night-cable-xl-3m-lighting-cosmos | 190/202 |
9791 | olloclip-active-lens-telephoto-ultra-wide-black-black-for-iphone-6-6plus | 299/412/413 |
9792 | olloclip-4-in-1-lens-with-pendant-rose-gold-for-iphone-6s-6s-plus | 190/429 |
9793 | olloclip-pivot-grip-universal-black-red | 190/195 |
9794 | olloclip-3-in-1-lens-with-pendant-and-stand-black-black-for-iphone-8-7-8-7-plus | 190/429 |
9795 | olloclip-macro-lens-black-black-for-iphone-8-7-8-7-plus | 190/195 |
9796 | olloclip-active-lens-telephoto-ultra-wide-for-iphone-8-8-plus-and-7-7-plus | 190/429 |
9797 | olloclip-core-lens-ollocase-for-iphone-7-7-plus-with-2-cases | 190/429 |
9798 | olloclip-filmers-kit-for-iphone-8-7-8-7-plus-core-active-pivot-bundle | 299/401 |
9799 | olloclip-mobile-photography-box-set-for-iphone-x | 299/412/415 |
9800 | olloclip-multi-device-clip-with-wide-angle-macro-intro-lenses | 190/195 |
9801 | olloclip-fisheye-super-wide-macro-essential-lenses-for-iphone-xr | 190/429 |
9802 | olloclip-fisheye-super-wide-macro-essential-lenses-for-iphone-xs-x | 190/429 |
9803 | olloclip-fisheye-super-wide-macro-essential-lenses-for-iphone-xs-max | 190/429 |
9804 | olloclip-4-in-1-lens-with-pendant-gold-lens-white-clip-for-iphone-6-6plus | 190/429 |