{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "67.21"
},
"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": 28,
"rows_produced_per_join": 28,
"filtered": "100.00",
"index_condition": "((`portal`.`q_seo_names`.`object_id` in (1593,1594,1595,1596,1597,1598,1599,1600,1601,1602,1603,1605,1606,1607,1610,1611,1612,1613,1614,1615,1616,1617,1618,1624,1625,1626,1627,1628)) 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": "61.61",
"eval_cost": "5.60",
"prefix_cost": "67.21",
"data_read_per_join": "47K"
},
"used_columns": [
"name",
"object_id",
"type",
"dispatch",
"path",
"lang_code"
]
}
}
}
product_id | seo_name | seo_path |
---|---|---|
1593 | disney-cars-cord-night-lamp-wd19742-16.5-x-6 | 248/393 |
1594 | disney-mickey-rodstr-cord-night-lamp-wd19729-16.5-x-6 | 248/273/276 |
1595 | marvel-spiderman-cord-night-lamp-mv15425-16.5-x-6 | 248/273/276 |
1596 | disney-mickey-rodstr-push-light-wd19733-10-x-4.2 | 248/273/276 |
1597 | disney-minnie-push-light-wd19720-10-x-4.2 | 248/393 |
1598 | marvel-spiderman-push-light-mv15429-10-x-4.2 | 248/393 |
1599 | marvel-avengers-night-lambs-mv15441-15-x-13.5 | 248/273/276 |
1600 | disney-cars-night-lambs-wd19745-15-x-13.5 | 248/273/276 |
1601 | disney-mickey-rodstr-night-lambs-wd19732-15-x-13.5 | 248/393 |
1602 | disney-minnie-night-lambs-wd19719-15-x-13.5 | 248/393 |
1603 | marvel-avengers-led-torch-mv15437-3-x-3-x-13 | 248/273/276 |
1605 | disney-mickey-rodstr-led-torch-wd19728-3-x-3-x-13 | 248/273/276 |
1606 | disney-minnie-led-torch-wd19715-3-x-3-x-13 | 248/273/276 |
1607 | disney-frozen-led-torch-wd19702-3-x-3-x-13 | 248/273/276 |
1610 | marvel-avengers-led-flash-light-mv15443b-2.5-x-2.5-x-9 | 248/393 |
1611 | marvel-avengers-led-flash-light-mv15443c-2.5-x-2.5-x-9 | 248/393 |
1612 | marvel-avengers-led-flash-light-mv15443d-2.5-x-2.5-x-9 | 248/393 |
1613 | disney-cars-led-flash-light-wd19747a-2.5-x-2.5-x-9 | 248/393 |
1614 | disney-cars-led-flash-light-wd19747b-2.5-x-2.5-x-9 | 248/393 |
1615 | disney-cars-led-flash-light-wd19747c-2.5-x-2.5-x-9 | 248/393 |
1616 | marvel-spiderman-led-flash-light-mv15430b-2.5-x-2.5-x-9 | 248/393 |
1617 | marvel-spiderman-led-flash-light-mv15430c-2.5-x-2.5-x-9 | 248/393 |
1618 | marvel-spiderman-led-flash-light-mv15430d-2.5-x-2.5-x-9 | 248/393 |
1624 | marvel-avengers-3d-lenticular-nail-cutter-tcnc-1002-one-size | 248/361/364 |
1625 | marvel-spiderman-3d-lenticular-nail-cutter-tcnc-1003-one-size | 248/361/364 |
1626 | wb-batman-3d-lenticular-nail-cutter-tcnc-1005-one-size | 248/361/364 |
1627 | disney-minnie-3d-lenticular-nail-cutter-tcnc-1008-one-size | 248/361/364 |
1628 | disney-frozen-3d-lenticular-nail-cutter-tcnc-1009-one-size | 248/361/364 |