Demo'd HW2 on Phone

  1. Duy Truong
  2. Fabian Schumann
  3. Tim Pissazcyk
  4. Farjahan Hossain
  5. Swathi Kotturu
  6. Michael Singh
  7. Phuc Vu
  8. Jiahui Kuang
  9. Duc Nguyen
  10. Quang Pham
  11. Dima Dimov
  12. Brandon Cruz
  13. Travis Volkmann
  14. Jia Sheng Cui
  15. Michael Ho
  16. Kenan Ozdamar
  17. Brian Lopes
  18. Ramya Shenoy
  19. Charmi Shah
  20. Karan Khare
  21. Shuang Wu
  22. Quang Pham
X

 

Query Statistics

https://www.yioop.com/group/19/Hw2?noredirect=true

Total Elapsed Time for Queries: 0.01454067230224609 seconds.
SELECT LOCALE_NAME, WRITING_MODE FROM LOCALE WHERE LOCALE_TAG ='en-US'
Time: 0.0003979206085205078 seconds.
DELETE FROM ITEM_IMPRESSION_SUMMARY WHERE USER_ID=? AND ITEM_ID=? AND ITEM_TYPE=? AND UPDATE_PERIOD = -4
Array ( [0] => 2 [1] => 206 [2] => 2 )
Time: 0.003638982772827148 seconds.
INSERT INTO ITEM_IMPRESSION_SUMMARY VALUES (?, ?, ?, -4, ?, 0, -1, -1) ON CONFLICT DO NOTHING
Array ( [0] => 2 [1] => 206 [2] => 2 [3] => 1789997480 )
Time: 0.002305030822753906 seconds.
UPDATE ITEM_IMPRESSION_SUMMARY SET NUM_VIEWS = NUM_VIEWS + 1 WHERE USER_ID=? AND ITEM_ID=? AND ITEM_TYPE=? AND UPDATE_PERIOD = -2 AND UPDATE_TIMESTAMP = 0
Array ( [0] => 2 [1] => 206 [2] => 2 )
Time: 0.0001108646392822266 seconds.
DELETE FROM ITEM_IMPRESSION_SUMMARY WHERE USER_ID=? AND ITEM_ID=? AND ITEM_TYPE=? AND UPDATE_PERIOD = -4
Array ( [0] => 2 [1] => 19 [2] => 3 )
Time: 0.002084970474243164 seconds.
INSERT INTO ITEM_IMPRESSION_SUMMARY VALUES (?, ?, ?, -4, ?, 0, -1, -1) ON CONFLICT DO NOTHING
Array ( [0] => 2 [1] => 19 [2] => 3 [3] => 1789997480 )
Time: 0.002202033996582031 seconds.
UPDATE ITEM_IMPRESSION_SUMMARY SET NUM_VIEWS = NUM_VIEWS + 1 WHERE USER_ID=? AND ITEM_ID=? AND ITEM_TYPE=? AND UPDATE_PERIOD = -2 AND UPDATE_TIMESTAMP = 0
Array ( [0] => 2 [1] => 19 [2] => 3 )
Time: 0.0001261234283447266 seconds.
SELECT ID FROM GROUP_PAGE WHERE GROUP_ID = ? AND TITLE=? AND LOCALE_TAG= ?
Array ( [0] => 19 [1] => Hw2 [2] => en-US )
Time: 0.0002069473266601562 seconds.
SELECT ID, PAGE, DISCUSS_THREAD, LAST_MODIFIED FROM GROUP_PAGE WHERE GROUP_ID = ? AND TITLE = ? AND LOCALE_TAG = ?
Array ( [0] => 19 [1] => Hw2 [2] => en-US )
Time: 0.0001730918884277344 seconds.
SELECT ID, PAGE, DISCUSS_THREAD, LAST_MODIFIED FROM GROUP_PAGE WHERE GROUP_ID = ? AND TITLE = ? AND LOCALE_TAG = ?
Array ( [0] => 19 [1] => [2] => en-US )
Time: 0.0001318454742431641 seconds.
SELECT ID, PAGE, DISCUSS_THREAD, LAST_MODIFIED FROM GROUP_PAGE WHERE GROUP_ID = ? AND TITLE = ? AND LOCALE_TAG = ?
Array ( [0] => 19 [1] => [2] => en-US )
Time: 5.698204040527344E-5 seconds.
SELECT COUNT(DISTINCT LINK_TYPE_ID) AS NUM FROM GROUP_PAGE_LINK WHERE TO_ID = ? OR FROM_ID = ?
Array ( [0] => 206 [1] => 206 )
Time: 0.0002999305725097656 seconds.
SELECT LOCALE_ID, LOCALE_TAG, LOCALE_NAME, WRITING_MODE FROM LOCALE WHERE ACTIVE > 0
Time: 0.0003449916839599609 seconds.
SELECT STATUS FROM USERS WHERE USER_ID = ?
Array ( [0] => 2 )
Time: 0.0004141330718994141 seconds.
SELECT * FROM VISITOR WHERE ADDRESS = :address AND PAGE_NAME = :page_name LIMIT 1
Array ( [:address] => 216.73.216.124 [:page_name] => forbidden_time_out )
Time: 0.0004320144653320312 seconds.
SELECT STATUS FROM USER_GROUP WHERE USER_ID=? AND GROUP_ID=? AND STATUS=?
Array ( [0] => 2 [1] => 19 [2] => 5 )
Time: 0.0001988410949707031 seconds.
SELECT G.GROUP_ID AS GROUP_ID, G.GROUP_NAME AS GROUP_NAME, G.OWNER_ID AS OWNER_ID, O.USER_NAME AS OWNER, REGISTER_TYPE, UG.STATUS AS STATUS, G.MEMBER_ACCESS AS MEMBER_ACCESS, G.VOTE_ACCESS AS VOTE_ACCESS, G.POST_LIFETIME AS POST_LIFETIME, UG.JOIN_DATE AS JOIN_DATE, G.OPTIONS AS OPTIONS, G.RENDER_ENGINE AS RENDER_ENGINE, G.GROUP_THEME AS GROUP_THEME, G.PAGE_HEADER AS PAGE_HEADER, G.PAGE_FOOTER AS PAGE_FOOTER FROM SOCIAL_GROUPS G, USERS O, USER_GROUP UG WHERE (UG.USER_ID = :user_id) AND UG.GROUP_ID= :group_id AND UG.GROUP_ID=G.GROUP_ID AND OWNER_ID = O.USER_ID LIMIT 1
Array ( [:group_id] => 19 [:user_id] => 2 )
Time: 0.0004498958587646484 seconds.
SELECT G.GROUP_ID AS GROUP_ID, G.GROUP_NAME AS GROUP_NAME, G.OWNER_ID AS OWNER_ID, O.USER_NAME AS OWNER, REGISTER_TYPE, UG.STATUS AS STATUS, G.MEMBER_ACCESS AS MEMBER_ACCESS, G.VOTE_ACCESS AS VOTE_ACCESS, G.POST_LIFETIME AS POST_LIFETIME, UG.JOIN_DATE AS JOIN_DATE, G.OPTIONS AS OPTIONS, G.RENDER_ENGINE AS RENDER_ENGINE, G.GROUP_THEME AS GROUP_THEME, G.PAGE_HEADER AS PAGE_HEADER, G.PAGE_FOOTER AS PAGE_FOOTER FROM SOCIAL_GROUPS G, USERS O, USER_GROUP UG WHERE (UG.USER_ID = :user_id OR G.REGISTER_TYPE IN (3,4)) AND UG.GROUP_ID= :group_id AND UG.GROUP_ID=G.GROUP_ID AND OWNER_ID = O.USER_ID LIMIT 1
Array ( [:group_id] => 19 [:user_id] => 2 )
Time: 0.0004429817199707031 seconds.
SELECT STATUS FROM USER_GROUP WHERE USER_ID=? AND GROUP_ID=? LIMIT 1
Array ( [0] => 2 [1] => 19 )
Time: 0.0001289844512939453 seconds.
SELECT STATUS FROM USER_GROUP WHERE USER_ID=? AND GROUP_ID=? AND STATUS=?
Array ( [0] => 2 [1] => 19 [2] => 1 )
Time: 0.0001370906829833984 seconds.
SELECT STATUS FROM USER_GROUP WHERE USER_ID=? AND GROUP_ID=? AND STATUS=?
Array ( [0] => 2 [1] => 19 [2] => 5 )
Time: 5.197525024414062E-5 seconds.
SELECT G.GROUP_ID AS GROUP_ID FROM SOCIAL_GROUPS G WHERE G.GROUP_NAME = ?
Array ( [0] => Personal$2 )
Time: 0.0002050399780273438 seconds.