{
"query_block": {
"select_id": 1,
"read_sorted_file": {
"filesort": {
"sort_key": "sd.position",
"table": {
"table_name": "sd",
"access_type": "ALL",
"possible_keys": ["section"],
"rows": 60,
"filtered": 45,
"attached_condition": "sd.section = 'A' and sd.`status` = 'A' and sd.param_5 = '11'"
}
}
},
"table": {
"table_name": "cscart_static_data_descriptions",
"access_type": "eq_ref",
"possible_keys": ["PRIMARY"],
"key": "PRIMARY",
"key_length": "9",
"used_key_parts": ["param_id", "lang_code"],
"ref": ["staging2_wesave_com.sd.param_id", "const"],
"rows": 1,
"filtered": 100,
"attached_condition": "trigcond(cscart_static_data_descriptions.lang_code = 'en')"
}
}
}
param_id | param | descr | param_2 | param_3 | param_4 | param_5 | param_6 | status | position | parent_id | id_path | class |
---|---|---|---|---|---|---|---|---|---|---|---|---|
238 | / | Home | 11 | A | 0 | 0 | 238 | |||||
240 | index.php?dispatch=companies.catalog | All Vendors | 11 | A | 20 | 0 | 240 | |||||
247 | index.php?dispatch=affiliate_merchant.view | Vendor List (A-Z) | 11 | A | 28 | 0 | 247 | |||||
241 | /featureddeals | Discounts | 11 | N | A | 30 | 0 | 241 | ||||
242 | index.php?dispatch=profiles.add | Join Us | 11 | A | 40 | 0 | 242 | |||||
243 | /contacts | Contact Us | 11 | A | 50 | 0 | 243 | |||||
244 | /faq | FAQ | 11 | A | 60 | 0 | 244 | |||||
246 | /terms-of-use | Terms of Use | 11 | A | 80 | 0 | 246 | |||||
253 | /program-policies | Program Policies | 11 | N | A | 81 | 0 | 253 | ||||
245 | /privacy-policy | Privacy Policy | 11 | A | 82 | 0 | 245 |