{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "26.61"
},
"table": {
"table_name": "cscart_seo_names",
"access_type": "range",
"possible_keys": [
"PRIMARY",
"dispatch"
],
"key": "PRIMARY",
"used_key_parts": [
"object_id",
"type",
"dispatch",
"lang_code",
"company_id"
],
"key_length": "210",
"rows_examined_per_scan": 38,
"rows_produced_per_join": 38,
"filtered": "100.00",
"index_condition": "((`zdrowy_db`.`cscart_seo_names`.`object_id` in (2718,680,679,681,682,2821,2822,976,975,2598,977,2599,1009,1010,289,2831,2670,335,2832)) and (`zdrowy_db`.`cscart_seo_names`.`type` = 'p') and (`zdrowy_db`.`cscart_seo_names`.`dispatch` = '') and (`zdrowy_db`.`cscart_seo_names`.`lang_code` = 'ru') and ((`zdrowy_db`.`cscart_seo_names`.`company_id` = 1) or (`zdrowy_db`.`cscart_seo_names`.`company_id` = 0)))",
"cost_info": {
"read_cost": "22.81",
"eval_cost": "3.80",
"prefix_cost": "26.61",
"data_read_per_join": "64K"
},
"used_columns": [
"name",
"object_id",
"company_id",
"type",
"dispatch",
"path",
"lang_code"
]
}
}
}
| product_id | seo_name | seo_path |
|---|---|---|
| 289 | 100-ml-stakan-100-ml-100-4000-stp | 290/293/584 |
| 335 | 200-ml-stakan-prozrachnyy-eko-200-ml-pp-stp-100-3000-sht | 290/293/584 |
| 679 | nozh-165-belyy-introplastik-100-2000 | 290/293/582 |
| 680 | nozh-165-prozrachnyy-introplastik-100-2000 | 290/293/582 |
| 681 | nozh-185-chernyy-48-2016 | 290/293/582 |
| 682 | nozhi-stolovye | 290/292 |
| 975 | razmeshivatel-12-sm-belyy-500-12000-rossiya | 290/293/583 |
| 976 | razmeshivatel-derevyan-dlya-kofe-140mm-1000sht-up | 290/575 |
| 977 | razmeshivatel-derevyannyy-180-mm-1000sht-up | 290/575 |
| 1009 | ryumki-kristal-100ml-6sht-77001 | 290/292 |
| 1010 | ryumki-kristall-50ml.-6sht | 290/292 |
| 2598 | razmeshivatel-derevyan-v-bumage-140mm-500sht-upak | 290/575 |
| 2599 | razmeshivatel-derevyan-v-bumage-180mm-500sht-upak | 290/575 |
| 2670 | stakan-kristall-cvet-prozr-200ml-ozlp-vzlp-h50-1000 | 290/293/584 |
| 2718 | nabor-posudy-5-premium-lozhka-vilka-nozh-zubochistka-salfetka-1-300 | 290/595 |
| 2821 | razmeshivateli-dlya-napitkov-bambukovyy-14-sm-1000-sht-up | 290/575 |
| 2822 | razmeshivateli-dlya-napitkov-bambukovyy-18-sm-1000-sht-up | 290/575 |
| 2831 | stakan-100-ml-10-sht-nabor-po-pyatdesyat-1-250 | 290/292 |
| 2832 | stakan-200-ml-belyy-prozrachnyy-10-sht-nabor-na-troih-1-140 | 290/292 |