{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "79.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": 34,
"rows_produced_per_join": 34,
"filtered": "100.00",
"index_condition": "((`portal`.`q_seo_names`.`object_id` in (34239,34249,34250,34262,34349,34469,34487,34538,2464,2465,2466,2467,2469,1175,1176,1177,1178,1179,1180,1181,1182,1183,1184,1191,1011,1010,1009,999,998,997,975,958)) 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": "72.81",
"eval_cost": "6.80",
"prefix_cost": "79.61",
"data_read_per_join": "57K"
},
"used_columns": [
"name",
"object_id",
"type",
"dispatch",
"path",
"lang_code"
]
}
}
}
product_id | seo_name | seo_path |
---|---|---|
958 | loreal-paris-elvive-total-repair-5-protein-recharge-leave-in-conditioner-treatment-and-heat-protectant-5.1-ounce | 2/11/131 |
975 | the-body-shop-banana-truly-nourishing-shampoo-400-ml | 2/11/130 |
997 | neutrogena-t-gel-shampoo-4.4-fl-oz-130-ml | 2/11/130 |
998 | neutrogena-t-gel-therapeutic-shampoo-extra-strength-6-fl-oz-177-ml | 2/11/130 |
999 | neutrogena-t-gel-therapeutic-shampoo-extra-strength-250ml | 2/11/130 |
1009 | batiste-floral-and-flirty-blush-instant-hair-refresh-dry-shampoo-200-ml | 2/11/130 |
1010 | batiste-dry-shampoo-200ml | 2/11/130 |
1011 | batiste-coconut-and-exotic-tropical-dry-shampoo-200-ml | 2/11/130 |
1175 | loreal-paris-elvive-arginine-resist-x3-shampoo-pack-of-2-pieces-2-x-400ml | 2/11 |
1176 | loreal-paris-elvive-oil-shampoo-dry-hair-pack-of-2-pieces-2-x-400ml | 2/11 |
1177 | loreal-paris-elvive-smooth-intense-shampoo-pack-of-2-pieces-2-x-400ml | 2/11/130 |
1178 | loreal-paris-elvive-arginine-resist-x3-anti-hair-fall-shampoo-400-ml | 2/11/130 |
1179 | loreal-paris-elvive-extraordinary-oil-conditioner-for-normal-hair-with-tendancy-to-dry-400-ml | 2/11/131 |
1180 | loreal-paris-elvive-smooth-intense-conditioner-400-ml | 2/11/131 |
1181 | loreal-paris-elvive-extraordinary-oil-shampoo-dry-to-very-dry-400-ml | 2/11/130 |
1182 | loreal-paris-elvive-extraordinary-oil-shampoo-normal-to-dry-400-ml | 2/11/130 |
1183 | loreal-elvive-oil-shampoo-dry-hair-400ml-conditioner-400ml-dry-hair | 2/11/130 |
1184 | loreal-elvive-oil-shampoo-very-dry-hair-400ml-conditioner-400-dry-hair | 2/11 |
1191 | loreal-paris-hair-expertise-extraordinary-clay-pre-shampoo-treatment-mask-150-ml | 2/11 |
2464 | belux-exta-care-silky-softness-2in1-shampoo-and-conditioner | 2/11/130 |
2465 | belux-extensive-protection-keratin-power-nutri-repair-shampoo | 2/11/130 |
2466 | belux-400-ml-revitalizing-shampoo | 2/11/130 |
2467 | belux-vit-e-amino-acids-for-colored-hair | 2/11/130 |
2469 | belux-400-ml-2-in-1-shampoo-and-shower-gel | 2/11/130 |
34239 | dove-daily-moisture-2in1-shampoo-and-conditioner-250ml-en | 2/11/130 |
34249 | godrej-expert-rich-creme-hair-color-20-gm-and-20-ml-natural-black | 2/11/132 |
34250 | godrej-expert-rich-creme-hair-color-20-gm-and-20-ml-dark-brown | 2/11/132 |
34262 | saeed-ghani-tarchup-oil-100ml | 2/11 |
34349 | loreal-hair-paste-txt-03-studio-line-75ml | 2/11/133 |
34469 | loxo-high-quality-cold-wind-rechargeable-wireless-hair-dryer | 2/11/523 |
34487 | the-beard-shaper-facial-hair-shaping-tool-stainless-steel | 2/11/523 |
34538 | mens-rogaine-hair-re-growth-treatment-foam-60-g | 2/11/133 |