{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "40.08"
},
"table": {
"table_name": "cscart_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": 89,
"rows_produced_per_join": 89,
"filtered": "100.00",
"cost_info": {
"read_cost": "31.18",
"eval_cost": "8.90",
"prefix_cost": "40.08",
"data_read_per_join": "150K"
},
"used_columns": [
"name",
"object_id",
"type",
"dispatch",
"path",
"lang_code"
],
"attached_condition": "((`nuie_scalesta_net`.`cscart_seo_names`.`object_id` in (85896,85897,85902,85884,85903,85885,85899,85890,85898,85891,85905,85887,85904,85886,85893,85895,85892,85901,85883,85889,85879,85880,85874,85875,85881,85876,85878,85873,85877,85872,85914,85915,85919,85946,85947,85912,85945,85926,85923,85928,85921,85943,85944,85942,85937,85938,85936,85934,85935,85940,85941,85933,85939,85959,85957,85931,85932,85930,85954,85953,85950,85951,85948,85909,84692,85910,85911,84957,85906,85907,84852,84751,87975,85908,84753,84860,84863,92922,92923,92924,92925,92926,92927,92928,92929,92930,92931,92932,92933)) and (`nuie_scalesta_net`.`cscart_seo_names`.`type` = 'p') and (`nuie_scalesta_net`.`cscart_seo_names`.`dispatch` = '') and (`nuie_scalesta_net`.`cscart_seo_names`.`lang_code` = 'en'))"
}
}
}| product_id | seo_name | seo_path |
|---|---|---|
| 84692 | bliss-compact-semi-flush-to-wall-toilet-pan-cistern-soft-close-seat-and-600mm-1-tap-hole-basin-and-full-pedestal-bathroom-suite | 7322/7323 |
| 84751 | harmony-semi-flush-to-wall-toilet-pan-cistern-soft-close-seat-and-500mm-1-tap-hole-basin-with-semi-pedestal-bathroom-suite | 7322/7323 |
| 84753 | ivo-toilet-pan-cistern-soft-close-seat-and-550mm-1-tap-hole-basin-with-full-pedestal-bathroom-suite | 7322/7323 |
| 84852 | lawton-compact-toilet-pan-cistern-soft-close-seat-and-550mm-1-tap-hole-basin-with-full-pedestal-bathroom-suite | 7322/7323 |
| 84860 | melbourne-toilet-pan-cistern-soft-close-seat-and-550mm-1-tap-hole-basin-with-full-pedestal-bathroom-suite | 7322/7323 |
| 84863 | melbourne-toilet-pan-cistern-soft-close-seat-and-550mm-2-tap-hole-basin-with-full-pedestal-bathroom-suite | 7322/7323 |
| 84957 | asselby-close-coupled-toilet-pan-cistern-soft-close-seat-and-500mm-1-tap-hole-basin-with-full-pedestal-bathroom-suite | 7322/7323 |
| 85872 | deco-wall-hung-400mm-unit-wc-and-tap | 7322/7327 |
| 85873 | deco-wall-hung-400mm-unit-wc-and-tap-en | 7322/7327 |
| 85874 | deco-wall-hung-400mm-unit-wc-and-tap-en-en | 7322/7327 |
| 85875 | deco-wall-hung-400mm-unit-wc-and-tap-en-en-en | 7322/7327 |
| 85876 | deco-wall-hung-400mm-unit-wc-and-tap-en-en-en-en | 7322/7327 |
| 85877 | deco-floor-standing-400mm-unit-wc-and-tap | 7322/7327 |
| 85878 | deco-floor-standing-400mm-unit-wc-and-tap-en | 7322/7327 |
| 85879 | deco-floor-standing-400mm-unit-wc-and-tap-en-en | 7322/7327 |
| 85880 | deco-floor-standing-400mm-unit-wc-and-tap-en-en-en | 7322/7327 |
| 85881 | deco-floor-standing-400mm-unit-wc-and-tap-en-en-en-en | 7322/7327 |
| 85883 | juno-wall-hung-440mm-wc-and-tap-en | 7322/7327 |
| 85884 | juno-wall-hung-440mm-wc-and-tap-en-en | 7322/7327 |
| 85885 | juno-wall-hung-440mm-wc-and-tap-en-en-en | 7322/7327 |
| 85886 | juno-wall-hung-440mm-wc-and-tap-en-en-en-en | 7322/7327 |
| 85887 | juno-wall-hung-440mm-wc-and-tap-en-en-en-en-en | 7322/7327 |
| 85889 | juno-wall-hung-440mm-wc-and-tap-en-en-en-en-en-en-en | 7322/7327 |
| 85890 | juno-wall-hung-440mm-wc-and-tap-en-en-en-en-en-en-en-en | 7322/7327 |
| 85891 | juno-wall-hung-440mm-wc-and-tap-en-en-en-en-en-en-en-en-en | 7322/7327 |
| 85892 | juno-wall-hung-440mm-wc-and-tap-en-en-en-en-en-en-en-en-en-en | 7322/7327 |
| 85893 | juno-wall-hung-440mm-wc-and-tap-en-en-en-en-en-en-en-en-en-en-en | 7322/7327 |
| 85895 | juno-floor-standing-440mm-wc-and-tap-en | 7322/7327 |
| 85896 | juno-floor-standing-440mm-wc-and-tap-en-en | 7322/7327 |
| 85897 | juno-floor-standing-440mm-wc-and-tap-en-en-en | 7322/7327 |
| 85898 | juno-floor-standing-440mm-wc-and-tap-en-en-en-en | 7322/7327 |
| 85899 | juno-floor-standing-440mm-wc-and-tap-en-en-en-en-en | 7322/7327 |
| 85901 | juno-floor-standing-440mm-wc-and-tap-en-en-en-en-en-en-en | 7322/7327 |
| 85902 | juno-floor-standing-440mm-wc-and-tap-en-en-en-en-en-en-en-en | 7322/7327 |
| 85903 | juno-floor-standing-440mm-wc-and-tap-en-en-en-en-en-en-en-en-en | 7322/7327 |
| 85904 | juno-floor-standing-440mm-wc-and-tap-en-en-en-en-en-en-en-en-en-en | 7322/7327 |
| 85905 | juno-floor-standing-440mm-wc-and-tap-en-en-en-en-en-en-en-en-en-en-en | 7322/7327 |
| 85906 | mayford-floor-standing-555mm-unit-and-wc | 7322/7327 |
| 85907 | mayford-floor-standing-555mm-unit-and-wc-en | 7322/7327 |
| 85908 | mayford-floor-standing-420mm-unit-and-wc | 7322/7327 |
| 85909 | mayford-floor-standing-480mm-unit-and-wc | 7322/7327 |
| 85910 | mayford-floor-standing-450mm-unit-and-wc | 7322/7327 |
| 85911 | mayford-wall-hung-450mm-unit-and-wc | 7322/7327 |
| 85912 | merit-wall-hung-500mm-unit-wc-and-tap | 7322/7327 |
| 85914 | merit-wall-hung-500mm-unit-wc-and-tap-en-en | 7322/7327 |
| 85915 | merit-wall-hung-500mm-unit-wc-and-tap-en-en-en | 7322/7327 |
| 85919 | merit-wall-hung-500mm-unit-wc-and-tap-en-en-en-en-en-en-en | 7322/7327 |
| 85921 | merit-slimline-wall-hung-500mm-unit-wc-and-tap | 7322/7327 |
| 85923 | merit-slimline-wall-hung-500mm-unit-wc-and-tap-en-en | 7322/7327 |
| 85926 | merit-slimline-wall-hung-500mm-unit-wc-and-tap-en-en-en-en-en | 7322/7327 |
| 85928 | merit-slimline-wall-hung-500mm-unit-wc-and-tap-en-en-en-en-en-en-en | 7322/7327 |
| 85930 | core-wall-hung-400mm-unit-tap-and-wc | 7322/7327 |
| 85931 | core-wall-hung-400mm-unit-tap-and-wc-en | 7322/7327 |
| 85932 | core-wall-hung-400mm-unit-tap-and-wc-en-en | 7322/7327 |
| 85933 | core-wall-hung-500mm-unit-tap-and-wc | 7322/7327 |
| 85934 | core-wall-hung-500mm-unit-tap-and-wc-en | 7322/7327 |
| 85935 | core-wall-hung-500mm-unit-tap-and-wc-en-en | 7322/7327 |
| 85936 | core-wall-hung-600mm-unit-tap-and-wc | 7322/7327 |
| 85937 | core-wall-hung-600mm-unit-tap-and-wc-en | 7322/7327 |
| 85938 | core-wall-hung-600mm-unit-tap-and-wc-en-en | 7322/7327 |
| 85939 | core-floor-standing-400mm-unit-tap-and-wc | 7322/7327 |
| 85940 | core-floor-standing-400mm-unit-tap-and-wc-en | 7322/7327 |
| 85941 | core-floor-standing-400mm-unit-tap-and-wc-en-en | 7322/7327 |
| 85942 | core-floor-standing-500mm-unit-tap-and-wc | 7322/7327 |
| 85943 | core-floor-standing-500mm-unit-tap-and-wc-en | 7322/7327 |
| 85944 | core-floor-standing-500mm-unit-tap-and-wc-en-en | 7322/7327 |
| 85945 | core-floor-standing-600mm-unit-tap-and-wc | 7322/7327 |
| 85946 | core-floor-standing-600mm-unit-tap-and-wc-en | 7322/7327 |
| 85947 | core-floor-standing-600mm-unit-tap-and-wc-en-en | 7322/7327 |
| 85948 | vault-wall-hung-400mm-unit-wc-and-tap | 7322/7327 |
| 85950 | vault-wall-hung-400mm-unit-wc-and-tap-en-en | 7322/7327 |
| 85951 | vault-wall-hung-400mm-unit-wc-and-tap-en-en-en | 7322/7327 |
| 85953 | vault-wall-hung-400mm-unit-wc-and-tap-en-en-en-en-en | 7322/7327 |
| 85954 | vault-floor-standing-400mm-unit-wc-and-tap | 7322/7327 |
| 85957 | vault-floor-standing-400mm-unit-wc-and-tap-en-en-en | 7322/7327 |
| 85959 | vault-floor-standing-400mm-unit-wc-and-tap-en-en-en-en-en | 7322/7327 |
| 87975 | ava-compact-rimless-toilet-pan-cistern-soft-close-seat-and-545mm-1-tap-hole-full-pedestal-basin-bathroom-suite | 7322/7323 |
| 92922 | bsz001 | 7322 |
| 92923 | bsz002 | 7322 |
| 92924 | bsz003 | 7322 |
| 92925 | bsz004 | 7322 |
| 92926 | bsz005 | 7322 |
| 92927 | bsz006 | 7322 |
| 92928 | bsz007 | 7322 |
| 92929 | bsz008 | 7322 |
| 92930 | bsz009 | 7322 |
| 92931 | bsz010 | 7322 |
| 92932 | bsz011 | 7322 |
| 92933 | bsz012 | 7322 |