Skip to content

Instantly share code, notes, and snippets.

@xurizaemon

xurizaemon/gist:43d6b2ed1c1792688eef Secret

Created July 3, 2014 23:28
Show Gist options
  • Save xurizaemon/43d6b2ed1c1792688eef to your computer and use it in GitHub Desktop.
Save xurizaemon/43d6b2ed1c1792688eef to your computer and use it in GitHub Desktop.
Download ZIP
Raw
gistfile1.txt
+----+-------------+----------------------------------+--------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------------------------------------------------+---------+----------------------------------------------------------+------+----------------------------------------------------+
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
+----+-------------+----------------------------------+--------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------------------------------------------------+---------+----------------------------------------------------------+------+----------------------------------------------------+
| 1 | SIMPLE | cog | const | PRIMARY,UI_name | UI_name | 194 | const | 1 | Using index; Using temporary; Using filesort |
| 1 | SIMPLE | cov | ref | index_option_group_id_value,index_option_group_id_name | index_option_group_id_name | 391 | const,const | 1 | Using where |
| 1 | SIMPLE | civicrm_financial_account | ALL | PRIMARY | NULL | NULL | NULL | 41 | Using join buffer (Block Nested Loop) |
| 1 | SIMPLE | civicrm_entity_financial_account | ref | FK_civicrm_entity_financial_account_financial_account_id | FK_civicrm_entity_financial_account_financial_account_id | 4 | databasenamex.civicrm_financial_account.id | 2 | Using where |
| 1 | SIMPLE | civicrm_financial_type | eq_ref | PRIMARY,UI_id | PRIMARY | 4 | databasenamex.civicrm_entity_financial_account.entity_id | 1 | NULL |
| 1 | SIMPLE | civicrm_contribution | ref | PRIMARY,UI_contrib_trxn_id,UI_contrib_invoice_id,UI_contrib_payment_instrument_id,index_contribution_status,received_date,check_number,FK_civicrm_contribution_contact_id,FK_civicrm_contribution_contribution_page_id,FK_civicrm_contribution_contribution_recur_id,FK_civicrm_contribution_honor_contact_id,FK_civicrm_contribution_address_id,FK_civicrm_contribution_campaign_id,FK_civicrm_contribution_financial_type_id | FK_civicrm_contribution_financial_type_id | 5 | databasenamex.civicrm_entity_financial_account.entity_id | 4549 | Using where |
| 1 | SIMPLE | civicrm_contribution_product | ref | FK_civicrm_contribution_product_contribution_id | FK_civicrm_contribution_product_contribution_id | 4 | databasenamex.civicrm_contribution.id | 1 | NULL |
| 1 | SIMPLE | contact_a | eq_ref | PRIMARY,index_is_deleted_sort_name | PRIMARY | 4 | databasenamex.civicrm_contribution.contact_id | 1 | Using where |
| 1 | SIMPLE | civicrm_product | ALL | PRIMARY | NULL | NULL | NULL | 2 | Using where; Using join buffer (Block Nested Loop) |
| 1 | SIMPLE | civicrm_entity_batch | ref | index_entity | index_entity | 199 | const,databasenamex.civicrm_contribution.id | 1 | Using where |
| 1 | SIMPLE | civicrm_batch | eq_ref | PRIMARY | PRIMARY | 4 | databasenamex.civicrm_entity_batch.batch_id | 1 | NULL |
| 1 | SIMPLE | civicrm_note | ref | index_entity | index_entity | 198 | const,databasenamex.civicrm_contribution.id | 1 | Using where |
| 1 | SIMPLE | option_group_payment_instrument | const | UI_name | UI_name | 194 | const | 1 | Using where; Using index |
| 1 | SIMPLE | payment_instrument | ref | index_option_group_id_value,index_option_group_id_name | index_option_group_id_name | 4 | databasenamex.option_group_payment_instrument.id | 4 | Using where |
| 1 | SIMPLE | option_group_contribution_status | const | UI_name | UI_name | 194 | const | 1 | Using where; Using index |
| 1 | SIMPLE | contribution_status | ref | index_option_group_id_value,index_option_group_id_name | index_option_group_id_name | 4 | databasenamex.option_group_contribution_status.id | 4 | Using where |
+----+-------------+----------------------------------+--------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------------------------------------------------+---------+----------------------------------------------------------+------+----------------------------------------------------+
16 rows in set (0.01 sec)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment