Skip to content

Instantly share code, notes, and snippets.

@ameyawebonise

ameyawebonise/gist:1fb60e1996005fd5fa3b

Created July 22, 2015 14:29
Show Gist options
  • Save ameyawebonise/1fb60e1996005fd5fa3b to your computer and use it in GitHub Desktop.
Save ameyawebonise/1fb60e1996005fd5fa3b 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 | filtered | Extra |
+----+--------------+--------------------------+-------------+-----------------------------------------------------------------------+---------------------------------------------------+---------+------------------------------------------------------------------------+------+----------+----------------------------------------------------------------------------------------------+
| 1 | PRIMARY | <derived2> | system | NULL | NULL | NULL | NULL | 1 | 100.00 | NULL |
| 2 | DERIVED | USER_MEMBERSHIPS | const | PRIMARY,USER_MEMBERSHIPS_GRP_ID | PRIMARY | 8 | const,const | 1 | 100.00 | NULL |
| 2 | DERIVED | USERS | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | NULL |
| 2 | DERIVED | INDIVIDUALS | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | Using index |
| 2 | DERIVED | PERSONAL_INFO | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | Using index |
| 2 | DERIVED | TRACKER_CUSTOM_DASHBOARD | ref | PRIMARY,USR_ID,TC_DASHBORARD_TRACKER_FK | PRIMARY | 4 | const | 1 | 100.00 | Using where |
| 2 | DERIVED | TRACKER_CUSTOM | eq_ref | PRIMARY | PRIMARY | 4 | demo.TRACKER_CUSTOM_DASHBOARD.trCTM_MainID | 1 | 100.00 | Using index |
| 2 | DERIVED | <derived3> | ref | <auto_key0> | <auto_key0> | 4 | const | 10 | 100.00 | NULL |
| 3 | DERIVED | TRACKER_CUSTOM_ITEMS | ref | PRIMARY,TRACKER_CUSTOM_ITEMS_GROUP_FK1,ITEM_STATUS | TRACKER_CUSTOM_ITEMS_GROUP_FK1 | 4 | const | 20 | 100.00 | Using where |
| 3 | DERIVED | <derived4> | ref | <auto_key0> | <auto_key0> | 4 | demo.TRACKER_CUSTOM_ITEMS.trCTM_ItemID | 11 | 100.00 | Using index |
| 3 | DERIVED | TRACKER_CUSTOM_DATA | ref | TRACKER_CUSTOM_DATA_USR_ID_TRCTM_ITEM_ID,FK_tracker_custom_data1 | TRACKER_CUSTOM_DATA_USR_ID_TRCTM_ITEM_ID | 10 | TRACKER_CUSTOM_DASHBOARD.USR_ID,demo.TRACKER_CUSTOM_ITEMS.trCTM_ItemID | 1 | 100.00 | NULL |
| 4 | DERIVED | TRACKER_CUSTOM_ITEMS | index_merge | TRACKER_CUSTOM_ITEMS_GROUP_FK1,ITEMS_ALL_TRACKERS | TRACKER_CUSTOM_ITEMS_GROUP_FK1,ITEMS_ALL_TRACKERS | 4,2 | NULL | 14 | 78.57 | Using intersect(TRACKER_CUSTOM_ITEMS_GROUP_FK1,ITEMS_ALL_TRACKERS); Using where; Using index |
| 4 | DERIVED | TRACKER_CUSTOM_DASHBOARD | ref | TRACKER_CUSTOM_DASHBOARD_GRP_ID | TRACKER_CUSTOM_DASHBOARD_GRP_ID | 4 | const | 30 | 100.00 | Using index |
| 5 | UNION | TRACKER_CUSTOM_ITEMS | index_merge | PRIMARY,TRACKER_CUSTOM_ITEMS_GROUP_FK1,ITEMS_ALL_TRACKERS,ITEM_STATUS | TRACKER_CUSTOM_ITEMS_GROUP_FK1,ITEMS_ALL_TRACKERS | 4,2 | NULL | 6 | 83.33 | Using intersect(TRACKER_CUSTOM_ITEMS_GROUP_FK1,ITEMS_ALL_TRACKERS); Using where |
| 5 | UNION | LABEL_ITEMS | ref | PRIMARY,LABLE_ITEMS_LABLES_FK1 | PRIMARY | 4 | demo.TRACKER_CUSTOM_ITEMS.trCTM_ItemID | 1 | 100.00 | Using index |
| 5 | UNION | USER_LABELS | ref | USER_LABELS_LABELS_FK1 | USER_LABELS_LABELS_FK1 | 4 | demo.LABEL_ITEMS.LBL_ID | 2 | 100.00 | Using index |
| 6 | UNION | TRACKER_CUSTOM_ITEMS | index_merge | PRIMARY,TRACKER_CUSTOM_ITEMS_GROUP_FK1,ITEMS_ALL_TRACKERS,ITEM_STATUS | TRACKER_CUSTOM_ITEMS_GROUP_FK1,ITEMS_ALL_TRACKERS | 4,2 | NULL | 6 | 83.33 | Using intersect(TRACKER_CUSTOM_ITEMS_GROUP_FK1,ITEMS_ALL_TRACKERS); Using where |
| 6 | UNION | TRACKER_ITEMS | ref | PRIMARY,TRAKCER_ITEMS_TRACKER_FK1 | PRIMARY | 4 | demo.TRACKER_CUSTOM_ITEMS.trCTM_ItemID | 1 | 100.00 | Using index |
| 6 | UNION | TRACKER_CUSTOM_DASHBOARD | ref | TC_DASHBORARD_TRACKER_FK | TC_DASHBORARD_TRACKER_FK | 4 | demo.TRACKER_ITEMS.trCTM_MainID | 10 | 100.00 | Using index |
| NULL | UNION RESULT | <union4,5,6> | ALL | NULL | NULL | NULL | NULL | NULL | NULL | Using temporary |
+----+--------------+--------------------------+-------------+-----------------------------------------------------------------------+---------------------------------------------------+---------+------------------------------------------------------------------------+------+----------+----------------------------------------------------------------------------------------------+
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment