YFs6Yf8S

1CREATE TEMPORARY TABLE IF NOT EXISTS Helper0910912001524518044820 (usergroupID INT,StoreID INT , INDEX st (`usergroupID`) ) engine=memory AS SELECT usergroup0.* from (SELECT 156825 as usergroupID, MVStoreID as StoreID, 1 as assignmentCount FROM MVMasterEntity_AttachedStores ) usergroup0 ; /* queryTime - 0.5284 seconds */
2	
3Select usergroupID, group_concat(StoreID) as Inspects from Helper0910912001524518044820 group by usergroupID;
4	
5( StoreID ) , ( StoreID, UsergroupID ), ( UsergroupID ), ( UsergroupID, StoreID )
6	
7id  select_type table   type    possible_keys   key key_len ref rows    Extra
81   SIMPLE  AssHelper0910912001524518044820 ALL                 903452  Using filesort