{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "70.61"
},
"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": 34,
"rows_produced_per_join": 34,
"filtered": "100.00",
"index_condition": "((`portal`.`q_seo_names`.`object_id` in (45784,45785,45787,45811,45812,45822,45823,45824,45825,45826,45830,45714,45715,45720,45725,45727,45733,45746,45749,45756,45764,45765,45768)) 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": "63.81",
"eval_cost": "6.80",
"prefix_cost": "70.61",
"data_read_per_join": "57K"
},
"used_columns": [
"name",
"object_id",
"type",
"dispatch",
"path",
"lang_code"
]
}
}
}
product_id | seo_name | seo_path |
---|---|---|
45714 | bestway-73x30x8.5-flocked-airbed-single-67000 | 6/7/61 |
45715 | bestway-1.91mx1.37mx22cm-horizon-airbed-67002 | 207/469/470/474 |
45720 | bestway-75x38x25-multi-max-air-couch-1seat-67277 | 207/469/470/474 |
45725 | bestway-80x60x22-premium-airbed-queen-67450n | 207/469/470/474 |
45727 | bestway-1.91mx1.37mx30cm-aeroluxe-airbed-full-67462 | 207/469/470/474 |
45733 | bestway-75x38x17-new-comfort-raised-airbed-67492 | 207/469/470/474 |
45746 | bestway-pavillo-1.88mx99cmx25cm-tritec-airbed-tw-67603 | 207/469/470/474 |
45749 | bestway-1.88mx1.09x89cm-dream-chaser-airbed-t.br-67712 | 207/469/470/474 |
45756 | bestway-1.59mx53.5cmx14cm-fortec-camping-chair-69013 | 207/469/470/474 |
45764 | bestway-33x33x29-nestair-75047 | 207/469/470/474 |
45765 | bestway-44x44x26-inflat-a-chair-75052 | 207/469/470/474 |
45768 | bestway-74x60x25-dbl-5in1-multifnctnl-couch-75056 | 207/469/470/474 |
45784 | bestway-pavillo-20l-solar-pro-shower-58224 | 207/469/470/474 |
45785 | bestway-73x30x8.5-aslepa-airbed-single-67434 | 207/469/470/474 |
45787 | bestway-pavillo-flex-choice-air-mattress-1.91x70-67617 | 207/469/470/474 |
45811 | bestway-287928-x71x49-cultiva-x3-tent-68046 | 207/469/470/474 |
45812 | bestway-2.05m-x-90cm-slumber300-sleeping-bag-68047 | 207/469/470/474 |
45822 | bestway-75x25x16.5fold-n-rest-camping-bed-68062 | 207/469/470/474 |
45823 | bestway-75x2516.5fold-n-rest-camping-bed-68065 | 207/469/470/474 |
45824 | bestway-82x30.7x18.5-fold-n-rest-alu-camp-bed-68068 | 207/469/470/474 |
45825 | bestway-50cmx50cmx72cm-fold-n-sit-chair-68069 | 207/469/470/474 |
45826 | bestway-31cmx31cmx38cm-fold-n-sit-camping-stool-68070 | 207/469/470/474 |
45830 | bestway-pavillo-1.84mx56cmx11.5-fortech-airbed-69014 | 207/469/470/474 |