{
"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 (3628,3629,3630,3631,3632,3633,3634,3635,3636,3637,3638,3639,3640,3641,3642,3643,3644,3645,3646,3647,3648,3649,3650,3651,3652,3653,3654,3655,3656,3657,3658,3659)) 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 |
---|---|---|
3628 | lock-and-lock-handy-breathing-glass-square-canister-3.4l | 6/438/439/442 |
3629 | lock-and-lock-handy-breathing-glass-square-canister-4.2l | 6/438/439/442 |
3630 | lock-and-lock-boroseal-ii-heat-resistant-glass-round-130ml | 6/438/476/478 |
3631 | lock-and-lock-boroseal-ii-heat-resistant-glass-round-380ml | 6/438/476/478 |
3632 | lock-and-lock-boroseal-ii-heat-resistant-glass-round-650ml | 6/438/476/478 |
3633 | lock-and-lock-boroseal-ii-heat-resistant-glass-round-950ml | 6/438/476/478 |
3634 | lock-and-lock-boroseal-ii-heat-resistant-glass-dome-style-18cm | 6/438/476/478 |
3635 | lock-and-lock-boroseal-ii-heat-resistant-glass-dome-style-21cm | 6/438/476/478 |
3636 | lock-and-lock-boroseal-ii-heat-resistant-glass-dome-style-24cm | 6/438/476/478 |
3637 | lock-and-lock-handle-spicecase-650ml-white | 6/438/479 |
3638 | lock-and-lock-dry-food-canister-3l | 6/438/479 |
3639 | lock-and-lock-dry-food-canister-5l | 6/438/479 |
3640 | lock-and-lock-microwave-cover-lid-sm | 6/438/454/455 |
3641 | lock-and-lock-microwave-cover-lid-large | 6/438/454/455 |
3642 | lock-and-lock-bottle-water-90cl | 6/438/439/442 |
3643 | lock-and-lock-smart-tray-square-s | 6/438/479 |
3644 | lock-and-lock-smart-tray-square-m | 6/438/479 |
3645 | lock-and-locksmart-tray-rectangular-m | 6/438/479 |
3646 | lock-and-lock-rice-case-w-cup-12l | 6/438/479 |
3647 | lock-and-lock-sandwich-roll-container-140ml | 6/438/476/478 |
3648 | lock-and-lock-food-container-5.1l-w-flip-lid | 6/438/479 |
3649 | lock-and-lock-bottle-water-1.2l | 6/438/439/442 |
3650 | lock-and-lock-jug-2l | 6/438/439/442 |
3651 | lock-and-lock-lunch-box-2p-set-black-bag-350ml | 6/438/476/477 |
3652 | lock-and-lock-lunch-box-2p-set-gray-bag-350ml | 6/438/476/477 |
3653 | lock-and-lock-lunch-box-2p-set-red-bag-350ml | 6/438/476/477 |
3654 | lock-and-lock-lunch-box-3pc-black-bag-and-spoon-fork-st | 6/438/476/477 |
3655 | lock-and-lock-lunch-box-3pc-gray-bag-and-spoon-fork-set | 6/438/476/477 |
3656 | lock-and-lock-lunch-box-3pc-red-bag-and-spoon-fork-set | 6/438/476/477 |
3657 | lock-and-lock-lunch-box-2p-st-stripe-bag-blue | 6/438/476/477 |
3658 | lock-and-lock-lunch-box-2pc-st-stripe-bag-red | 6/438/476/477 |
3659 | lock-and-lock-lunch-box-3pc-st-dotted-bag-blue | 6/438/476/478 |