{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "72.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": 30,
"rows_produced_per_join": 30,
"filtered": "100.00",
"index_condition": "((`portal`.`q_seo_names`.`object_id` in (2423,2424,1257,1258,1259,1260,1261,1262,1263,1264,1228,1236,1252,1253,1254,1209,1169,1170,1171,1172,1173,1174,1175,1176,1177,1178,1179,1180,1181,1182)) 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": "66.01",
"eval_cost": "6.00",
"prefix_cost": "72.01",
"data_read_per_join": "50K"
},
"used_columns": [
"name",
"object_id",
"type",
"dispatch",
"path",
"lang_code"
]
}
}
}
product_id | seo_name | seo_path |
---|---|---|
1169 | loreal-paris-true-match-super-blendable-foundation-makeup-n5.5-perfect-beige-1-fl.-oz | 2/144/100/117 |
1170 | loreal-paris-true-match-super-blendable-foundation-makeup-soft-sable-1-fl.-oz | 2/144/100/117 |
1171 | loreal-super-blendable-makeup-warm-creme-cafe-w8-1.0-fl-oz | 2/144/100/117 |
1172 | loreal-paris-white-perfect-day-cream-whitening-and-even-tone-spf17-pa-50ml | 2/144/100/117 |
1173 | loreal-paris-revitalift-anti-wrinkle-firming-day-cream-50ml | 2/10/134 |
1174 | loreal-paris-rare-flowers-cleansing-milk-dry-and-sensative-skin-200-ml | 2/10 |
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 |
1209 | trojan-magnum-xl-lubricated-condoms-12-count-canadian-packaging | 2/144/366 |
1228 | polident-paste-daily-cleanser-90ml | 2/138/140 |
1236 | burts-bees-nourishing-eyeliner-1410-midnight-gray-1.14g | 2/144/100/106 |
1252 | trojan-lubrificated-spermicide | 2/144/366 |
1253 | trojan-fire-and-ice | 2/144/366 |
1254 | trojan-magnum-thin | 2/144/366 |
1257 | olay-natural-white-beauty-box-cleansing-face-wash-100-g-fairness-day-cream-spf-24-50-g-fairness-night-cream-50-g | 2/10/134 |
1258 | olay-luminous-whip-active-moisturizer-50-ml | 2/10/134 |
1259 | olay-age-defying-advanced-gel-moisturizer-with-hyaluronic-acid-1.7-oz | 2/10/134 |
1260 | olay-eyes-eye-lifting-serum-for-sagging-skin-15-ml | 2/144/100/106 |
1261 | olay-eyes-depuffing-eye-roller-for-bags-under-eyes-0.2-fl-oz | 2/144/100/106 |
1262 | olay-micropolishing-cleansing-infusion-hydrating-glow-facial-cleanser-crushed-ginger-and-citrus-extract-150-ml | 2/10/134 |
1263 | olay-cleansing-infusion-hydrating-glow-facial-cleanser-deep-sea-kelp-and-aloe-extract | 2/10/134 |
1264 | gillette-satin-care-with-a-touch-of-olay-shave-gel-with-shea-butter-7-oz-198-g | 2/144/145 |
2423 | smart-talk-4usb-3.1a-charger | 190/193 |
2424 | super-universal-traver-charger-with-2usb-ports | 190/193 |