{
"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 (6957,6958,6959,6960,6961,6962,6963,6964,6965,6966,6967,6968,6969,6970,6971,6972,6974,6977,6978,6979,4497,4498,4499,4500,4501,4502,4503,4504,4505,4506,4507,4509)) 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 |
---|---|---|
4497 | laica-bm1004-wrist-blood-pressure-monitor | 2/432 |
4498 | spectrum-heating-pad-dv4503 | 207/379 |
4499 | infrared-hating-lamp-sn51 | 6/168 |
4500 | laica-pocket-mesh-nebulizer-ne1005 | 2/144 |
4501 | laica-automatic-arm-blood-pressure-monitor-bm2301 | 2/432 |
4502 | laica-electrical-muscle-stimulator-sport-4500-md6078 | 207/379 |
4503 | laica-facial-sauna-with-inhalator-md6062 | 2/144/549 |
4504 | laica-foot-spa-massager-pc1017 | 2/144/549 |
4505 | laica-infrared-ear-thermometer-th2002 | 2/432 |
4506 | laica-ps7002-smart-body-composition-scale | 2/432 |
4507 | laica-mechanical-personal-scale | 6/7/147/158 |
4509 | callus-remover | 2/144/145 |
6957 | baby-scale | 2/432 |
6958 | baby-scale-en | 248/393 |
6959 | ultrasonic-humidifier | 6/184 |
6960 | infrared-forehead-thermometer | 248/361/364 |
6961 | water-filter-jug-carmen | 6/438/454/455 |
6962 | digital-thermometer | 2/432 |
6963 | baby-digital-soother-thermometer | 248/393 |
6964 | mini-piston-nebulizer | 2/432 |
6965 | ultrasonic-desktop-nebulizer | 248/361/364 |
6966 | 5in1-multifunction-sterilizer | 248/393 |
6967 | electric-rechargeable-breast-pump | 248/566 |
6968 | electric-rechargeable-breast-pump-en | 248/566 |
6969 | manual-breast-pump | 248/566 |
6970 | infrared-thermometer-forehead-and-ear | 2/432 |
6971 | ultrasonic-mesh-nebulizer | 248/393 |
6972 | baby-food-blender-with-containers-and-take-away-bottle | 6/168/169 |
6974 | laica-steam-bottle-sterilizer | 248/566 |
6977 | laica-infrared-forehead-thermometr-th1001 | 248/393 |
6978 | laica-digital-bath-thermometer-th4007 | 248/393 |
6979 | powered-nasal-aspirator | 248/393 |