{
"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 (12947,12948,12949,12950,12951,12952,12953,12954,12955,12956,12957,12958,12959,12960,12961,12962)) 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 |
---|---|---|
12947 | casio-aq-s810w-8adf | 12/95/97 |
12948 | casio-aq-s810wc-3avdf | 12/95/97 |
12949 | casio-aq-s810wc-4avdf-cn | 12/95/97 |
12950 | casio-aq-s810wc-7avdf-cn | 12/95/97 |
12951 | casio-aw-49h-1bvdf | 12/95/97 |
12952 | casio-aw-49h-7evdf | 12/95/97 |
12953 | casio-aw-48he-1avdf-cn | 12/95/97 |
12954 | casio-aw-48he-7avdf-cn | 12/95/97 |
12955 | casio-aw-48he-8avdf-cn | 12/95/97 |
12956 | casio-aw-48he-9avdf-cn | 12/95/97 |
12957 | casio-aw-80-1a2vdf | 12/95/97 |
12958 | casio-aw-80-1avdf-cn | 12/95/97 |
12959 | casio-aw-80-2bvdf-cn | 12/95/97 |
12960 | casio-aw-80-4bvdf-cn | 12/95/97 |
12961 | casio-aw-80-7a2vdf | 12/95/97 |
12962 | casio-aw-80-7avdf | 12/95/97 |