Yioop - PHP Search EngineYioop - PHP Search Engine

Query Statistics

https://yioop.com/

Total Elapsed Time for Queries: 0.002871990203857422 seconds.
SELECT LOCALE_NAME, WRITING_MODE FROM LOCALE WHERE LOCALE_TAG ='en-US'
Time: 0.0001709461212158203 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] => 2 [:user_id] => 2 )
Time: 0.0005879402160644531 seconds.
SELECT STATUS FROM USER_GROUP WHERE USER_ID=? AND GROUP_ID=? LIMIT 1
Array ( [0] => 2 [1] => 2 )
Time: 0.0002329349517822266 seconds.
SELECT CRAWL_TIME FROM CURRENT_WEB_INDEX
Time: 0.0001790523529052734 seconds.
SELECT CRAWL_TIME FROM CURRENT_WEB_INDEX
Time: 3.004074096679688E-5 seconds.
SELECT TIMESTAMP, NAME FROM CRAWL_MIXES WHERE TIMESTAMP = ?
Array ( [0] => 1702631344 )
Time: 6.29425048828125E-5 seconds.
SELECT COUNT(*) AS ALLOWED FROM ACTIVITY A, USER_ROLE UR, ROLE_ACTIVITY RA WHERE UR.USER_ID = ? AND (UR.EXPIRES = -2 OR UR.EXPIRES > 1789983366) AND UR.ROLE_ID=RA.ROLE_ID AND A.METHOD_NAME = ? AND RA.ACTIVITY_ID = A.ACTIVITY_ID
Array ( [0] => 2 [1] => resultsEditor )
Time: 0.0003459453582763672 seconds.
SELECT LOCALE_ID, LOCALE_TAG, LOCALE_NAME, WRITING_MODE FROM LOCALE WHERE ACTIVE > 0
Time: 0.0002532005310058594 seconds.
SELECT LOCALE_ID FROM LOCALE WHERE LOCALE_TAG = ? LIMIT 1
Array ( [0] => en-US )
Time: 0.0002379417419433594 seconds.
SELECT S.LOCALE_STRING AS LOCALE_STRING, S.FOLDER_NAME AS FOLDER_NAME, S.PER_PAGE AS PER_PAGE, S.DEFAULT_QUERY AS DEFAULT_QUERY, S.INDEX_IDENTIFIER AS INDEX_IDENTIFIER, T.TRANSLATION_ID AS TRANSLATION_ID FROM SUBSEARCH S, TRANSLATION T WHERE T.IDENTIFIER_STRING = S.LOCALE_STRING
Time: 0.0003399848937988281 seconds.
SELECT TRANSLATION AS SUBSEARCH_NAME FROM TRANSLATION_LOCALE WHERE TRANSLATION_ID=? AND LOCALE_ID=? LIMIT 1
Array ( [0] => 1002 [1] => 1 )
Time: 0.0001850128173828125 seconds.
SELECT TRANSLATION AS SUBSEARCH_NAME FROM TRANSLATION_LOCALE WHERE TRANSLATION_ID=? AND LOCALE_ID=? LIMIT 1
Array ( [0] => 1003 [1] => 1 )
Time: 0.0001430511474609375 seconds.
SELECT TRANSLATION AS SUBSEARCH_NAME FROM TRANSLATION_LOCALE WHERE TRANSLATION_ID=? AND LOCALE_ID=? LIMIT 1
Array ( [0] => 1004 [1] => 1 )
Time: 3.886222839355469E-5 seconds.
SELECT TRANSLATION AS SUBSEARCH_NAME FROM TRANSLATION_LOCALE WHERE TRANSLATION_ID=? AND LOCALE_ID=? LIMIT 1
Array ( [0] => 1005 [1] => 1 )
Time: 4.00543212890625E-5 seconds.
SELECT TRANSLATION AS SUBSEARCH_NAME FROM TRANSLATION_LOCALE WHERE TRANSLATION_ID=? AND LOCALE_ID=? LIMIT 1
Array ( [0] => 1782099971 [1] => 1 )
Time: 2.408027648925781E-5 seconds.