SELECT cache_value FROM xf_permission_combination WHERE permission_combination_id = ?
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_permission_combination | const | PRIMARY | PRIMARY | 4 | const | 1 |
SELECT `xf_user`.* FROM `xf_user` WHERE (`xf_user`.`user_id` = 66822) LIMIT 1
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_user | const | PRIMARY | PRIMARY | 4 | const | 1 |
SELECT `xf_payment_profile`.*, `xf_payment_provider_Provider_1`.* FROM `xf_payment_profile` INNER JOIN `xf_payment_provider` AS `xf_payment_provider_Provider_1` ON (`xf_payment_provider_Provider_1`.`provider_id` = `xf_payment_profile`.`provider_id`) LEFT JOIN `xf_addon` AS `xf_addon_AddOn_2` ON (`xf_addon_AddOn_2`.`addon_id` = `xf_payment_provider_Provider_1`.`addon_id`) WHERE (`xf_payment_profile`.`active` = 1) AND ((`xf_addon_AddOn_2`.`active` = 1) OR (`xf_payment_provider_Provider_1`.`addon_id` = '')) ORDER BY `xf_payment_profile`.`title` ASC
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_payment_profile | ALL | 3 | Using where; Using filesort | ||||
SIMPLE | xf_payment_provider_Provider_1 | eq_ref | PRIMARY | PRIMARY | 27 | cbwd_congdonmrnr.xf_payment_profile.provider_id | 1 | |
SIMPLE | xf_addon_AddOn_2 | eq_ref | PRIMARY | PRIMARY | 52 | cbwd_congdonmrnr.xf_payment_provider_Provider_1.addon_id | 1 | Using where |
SELECT view_date FROM xf_session_activity WHERE user_id = ? AND unique_key = ?