Query Statistics

https://www.yioop.com/p/pages

Total Elapsed Time for Queries: 0.2968540191650391 seconds.

SELECT LOCALE_NAME, WRITING_MODE FROM LOCALE WHERE LOCALE_TAG ='en-US'

Time: 0.002418994903564453 seconds.

SELECT COUNT(DISTINCT G.GROUP_ID) AS NUM FROM GROUPS G, USER_GROUP UG, USERS O WHERE G.GROUP_ID='2'

Time: 0.2840631008148193 seconds.

SELECT * FROM GROUPS G, USER_GROUP UG, USERS O WHERE G.GROUP_ID='2' LIMIT 1 OFFSET 0

Time: 0.001302957534790039 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.ENCRYPTION AS ENCRYPTION FROM 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] => 2 [:user_id] => 2 )

Time: 0.0007290840148925781 seconds.

SELECT STATUS FROM USER_GROUP WHERE USER_ID=? AND GROUP_ID=? LIMIT 1
Array ( [0] => 2 [1] => 2 )

Time: 0.0003638267517089844 seconds.

SELECT COUNT(*) AS TOTAL FROM GROUP_PAGE WHERE GROUP_ID = ? AND LOCALE_TAG= ? AND LENGTH(PAGE) > 0
Array ( [0] => 2 [1] => en-US )

Time: 0.005764961242675781 seconds.

SELECT TITLE, PAGE AS DESCRIPTION FROM GROUP_PAGE WHERE GROUP_ID = ? AND LOCALE_TAG= ? AND LENGTH(PAGE) > 0 ORDER BY LOWER(TITLE) ASC LIMIT 50 OFFSET 0
Array ( [0] => 2 [1] => en-US )

Time: 0.002211093902587891 seconds.

- Public:Page List

Public Group Page List

Query Statistics