{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "46.81"
},
"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": 22,
"rows_produced_per_join": 22,
"filtered": "100.00",
"index_condition": "((`portal`.`q_seo_names`.`object_id` in (32877,32878,30350,14312,14348,15787,16532,16533,16536,16541,16542,16543,16553,16554,16555,16556)) 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": "42.41",
"eval_cost": "4.40",
"prefix_cost": "46.81",
"data_read_per_join": "37K"
},
"used_columns": [
"name",
"object_id",
"type",
"dispatch",
"path",
"lang_code"
]
}
}
}
product_id | seo_name | seo_path |
---|---|---|
14312 | acunion-20mm-watch-clasp-band-with-butterfly-deployant-buckle-leather-watch-strap-for-men-women-brown | 12/95/97 |
14348 | topwell-black-pocket-watch-roman-pattern-steampunk-retro-vintage-quartz-roman-numerals-pocket-watch | 12/95/97 |
15787 | the-unemployed-philosophers-guild-lewis-carroll-alice-in-wonderland-unisex-analog-watch | 12/95/97 |
16532 | calvin-klein-pure-womens-quartz-watch-k4w2sxk6 | 12/95/96 |
16533 | sinobi-men-leather-strap-watches-unisex-multifunction-date-chronograph-watch-stopwatch-rose-gold-for-men | 12/95/97 |
16536 | fq-043-classic-golden-stainless-steel-male-female-crystals-quartz-wrist-watches-for-man-woman-gold | 12/95/97 |
16541 | empress-stella-automatic-semi-skeleton-dial-leather-band-watch-gold-white-brown-empem2104 | 12/95/96 |
16542 | bertha-madeline-mop-bracelet-watch-gold-bthbr7102 | 12/95/96 |
16543 | timex-world-time-white-dial-mens-watch-t2n613 | 12/95/96 |
16553 | sinobi-crystal-women-lady-black-quartz-leather-wrist-quartz-watch-cool-snb023 | 12/95/96 |
16554 | white-globe-dial-automaitc-self-wind-weel-chronometer-moon-phase-womens-mens-brown-silver-wrist-watch | 12/95/96 |
16555 | womens-rhinestone-accented-large-face-bracelet-watch-in-gold-tone-jade-lebaum-jb202729g | 12/95/96 |
16556 | caravelle-new-york-womens-44l133-stainless-steel-swarovski-crystal-accented-watch | 12/95/96 |
30350 | y-and-d-womens-a-line-hollow-out-short-sleeve-floral-patchwork-flower-decor-solid-color-dress-pink-color | 12/95/96 |
32877 | creative-mesh-band-womens-gold-watch-s15036l-2 | 12/95/96 |
32878 | creative-mesh-band-womens-rose-watch-s15036l-3 | 12/95/96 |