{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "76.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": 32,
"rows_produced_per_join": 32,
"filtered": "100.00",
"index_condition": "((`portal`.`q_seo_names`.`object_id` in (1559,1560,1561,1562,1563,1564,1565,1566,1567,1568,1569,1570,1571,1572,1573,1574,1577,1578,1579,1580,1581,1582,1583,1584,1585,1586,1587,1588,1589,1590,1591,1592)) 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": "70.41",
"eval_cost": "6.40",
"prefix_cost": "76.81",
"data_read_per_join": "54K"
},
"used_columns": [
"name",
"object_id",
"type",
"dispatch",
"path",
"lang_code"
]
}
}
}
product_id | seo_name | seo_path |
---|---|---|
1559 | marvel-spiderman-eva-bags-tc-5682-product-size-must-be-in-12-inches-only | 248/544/546 |
1560 | wb-batman-eva-bags-tc-5683-product-size-must-be-in-12-inches-only | 248/544/546 |
1561 | wb-superman-eva-bags-tc-5684-product-size-must-be-in-12-inches-only | 248/544/546 |
1562 | disney-cars-drwastring-bag-wd19485-drawstring-bag-40-x-30-cm | 248 |
1563 | disney-mickey-drwastring-bag-wd19481-drawstring-bag-40-x-30-cm | 248 |
1564 | disney-minnie-drwastring-bag-wd19482-drawstring-bag-40-x-30-cm | 248 |
1565 | disney-mickey-drwastring-bag-wd19483-drawstring-bag-40-x-30-cm | 248 |
1566 | disney-frozen-drwastring-bag-wd19486-drawstring-bag-40-x-30-cm | 248 |
1567 | marvel-spiderman-drwastring-bag-mv15363-drawstring-bag-40-x-30-cm | 248/544/546 |
1568 | disney-minnie-kids-shoulder-bag-tcsb-002-one-piece | 248/278/290 |
1569 | disney-princess-kids-shoulder-bag-tcsb-005-one-piece | 248/278/290 |
1570 | disney-minnie-kids-hand-bag-tcsb-101-one-piece | 248/278/290 |
1571 | cnn-ppg-kids-hand-bag-tcsb-103-one-piece | 248/278/290 |
1572 | cnn-ppg-kids-hand-bag-tcsb-1004-one-piece | 248/278/290 |
1573 | disney-princess-kids-hand-bag-tcsb-1005-one-piece | 248/278/290 |
1574 | disney-sofia-kids-hand-bag-tcsb-1006-one-piece | 248/278/290 |
1577 | disney-minnie-night-stand-lamb-wd19717-15-x-7-cm | 248/393 |
1578 | marvel-avengers-night-stand-lamb-mv15439-15-x-7-cm | 248/393 |
1579 | disney-frozen-night-stand-lamb-wd19704-15-x-7-cm | 248/393 |
1580 | disney-cars-night-stand-lamb-wd19743-15-x-7-cm | 248/393 |
1581 | disney-mickey-rodstr-night-stand-lamb-wd19730-15-x-7-cm | 248/273/276 |
1582 | marvel-avengers-lava-lamb-mv15237-4.5-x-4.5-x-15 | 248/273/276 |
1583 | disney-cars-lava-lamb-wd19063-4.5-x-4.5-x-15 | 248/273/276 |
1584 | disney-frozen-lava-lamb-wd19062-4.5-x-4.5-x-15 | 248/273/276 |
1585 | marvel-spiderman-lava-lamb-mv15423-4.5-x-4.5-x-15 | 248/273/276 |
1586 | marvel-avengers-desk-lamb-mv15440-18-x-9 | 248/393 |
1587 | disney-cars-desk-lamb-wd19744-18-x-9 | 248/273/276 |
1588 | disney-frozen-desk-lamb-wd19705-18-x-9 | 248 |
1589 | disney-mickey-rodstr-desk-lamb-wd19731-18-x-9 | 248/273/276 |
1590 | disney-minnie-desk-lamb-wd19718-18-x-9 | 248/393 |
1591 | marvel-spiderman-desk-lamb-mv15427-18-x-9 | 248/393 |
1592 | marvel-avengers-cord-night-lamp-mv15438-16.5-x-6 | 248/393 |