Advertise for Do keyword advertising on Yioop!

Query Statistics

https://www.yioop.com/trending?arg=chart&period=86400&term=University+of+New+South+Wales

Total Elapsed Time for Queries: 0.04949545860290527 seconds.
SELECT LOCALE_NAME, WRITING_MODE FROM LOCALE WHERE LOCALE_TAG ='en-US'
Time: 0.002270936965942383 seconds.
SELECT ID FROM QUERY_ITEM WHERE QUERY_HASH = ?
Array ( [0] => oIf03JUELnY )
Time: 0.001780986785888672 seconds.
INSERT INTO ITEM_IMPRESSION VALUES (?, ?, ?, ?)
Array ( [0] => 2 [1] => 273609 [2] => 4 [3] => 1568775676 )
Time: 0.001151800155639648 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] => 273609 [2] => 4 )
Time: 0.001664876937866211 seconds.
SELECT B.KEYWORD AS KEYWORD, SUM(B.BID_AMOUNT) AS TOTAL_AMOUNT FROM ADVERTISEMENT A, ACCEPTED_AD_BIDS B WHERE A.ID = B.AD_ID AND B.KEYWORD = ? AND BID_DATE = ? AND A.STATUS=1 GROUP BY B.KEYWORD
Array ( [0] => [1] => 2019-09-17 )
Time: 0.002920150756835938 seconds.
SELECT B.KEYWORD AS KEYWORD, SUM(B.BID_AMOUNT) AS TOTAL_AMOUNT FROM ADVERTISEMENT A, ACCEPTED_AD_BIDS B WHERE A.ID = B.AD_ID AND B.KEYWORD IN ('') AND BID_DATE = ? AND A.STATUS=1 GROUP BY B.KEYWORD ORDER BY TOTAL_AMOUNT DESC LIMIT 1
Array ( [0] => 2019-09-17 )
Time: 0.0007350444793701172 seconds.
SELECT URL, PARENT FROM MACHINE ORDER BY NAME DESC
Time: 0.002079963684082031 seconds.
SELECT CRAWL_TIME FROM CURRENT_WEB_INDEX
Time: 0.0006349086761474609 seconds.
SELECT CRAWL_TIME FROM CURRENT_WEB_INDEX
Time: 0.0002639293670654297 seconds.
SELECT TIMESTAMP, NAME FROM CRAWL_MIXES WHERE TIMESTAMP = ?
Array ( [0] => 1565638436 )
Time: 0.0009160041809082031 seconds.
SELECT TIMESTAMP, NAME FROM CRAWL_MIXES WHERE TIMESTAMP = ?
Array ( [0] => 1565638436 )
Time: 0.0001969337463378906 seconds.
SELECT OCCURRENCES, TIMESTAMP FROM TRENDING_TERM WHERE TERM = ? AND UPDATE_PERIOD = ? AND LANGUAGE= ? ORDER BY TIMESTAMP DESC LIMIT 24
Array ( [0] => University of New South Wales [1] => 3600 [2] => en-US )
Time: 0.006827116012573242 seconds.
SELECT TERM, OCCURRENCES FROM TRENDING_TERM WHERE LANGUAGE= ? AND UPDATE_PERIOD = ? AND TIMESTAMP = (SELECT MAX(TIMESTAMP) FROM TRENDING_TERM WHERE LANGUAGE= ? AND UPDATE_PERIOD = ?) ORDER BY OCCURRENCES DESC LIMIT 50
Array ( [0] => en-US [1] => 3600 [2] => en-US [3] => 3600 )
Time: 0.008490085601806641 seconds.
SELECT TERM, OCCURRENCES FROM TRENDING_TERM WHERE LANGUAGE= ? AND UPDATE_PERIOD = ? AND TIMESTAMP = (SELECT MAX(TIMESTAMP) FROM TRENDING_TERM WHERE LANGUAGE= ? AND UPDATE_PERIOD = ?) ORDER BY OCCURRENCES DESC LIMIT 50
Array ( [0] => en-US [1] => 86400 [2] => en-US [3] => 86400 )
Time: 0.007339954376220703 seconds.
SELECT TERM, OCCURRENCES FROM TRENDING_TERM WHERE LANGUAGE= ? AND UPDATE_PERIOD = ? AND TIMESTAMP = (SELECT MAX(TIMESTAMP) FROM TRENDING_TERM WHERE LANGUAGE= ? AND UPDATE_PERIOD = ?) ORDER BY OCCURRENCES DESC LIMIT 50
Array ( [0] => en-US [1] => 604800 [2] => en-US [3] => 604800 )
Time: 0.007328033447265625 seconds.
SELECT LOCALE_ID, LOCALE_TAG, LOCALE_NAME, WRITING_MODE FROM LOCALE WHERE ACTIVE > 0
Time: 0.001828908920288086 seconds.
SELECT LOCALE_ID FROM LOCALE WHERE LOCALE_TAG = ? LIMIT 1
Array ( [0] => en-US )
Time: 0.001198053359985352 seconds.
SELECT S.LOCALE_STRING AS LOCALE_STRING, S.FOLDER_NAME AS FOLDER_NAME, S.PER_PAGE AS PER_PAGE, 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.0009510517120361328 seconds.
SELECT TRANSLATION AS SUBSEARCH_NAME FROM TRANSLATION_LOCALE WHERE TRANSLATION_ID=? AND LOCALE_ID=? LIMIT 1
Array ( [0] => 1002 [1] => 1 )
Time: 0.0004918575286865234 seconds.
SELECT TRANSLATION AS SUBSEARCH_NAME FROM TRANSLATION_LOCALE WHERE TRANSLATION_ID=? AND LOCALE_ID=? LIMIT 1
Array ( [0] => 1003 [1] => 1 )
Time: 0.0002548694610595703 seconds.
SELECT TRANSLATION AS SUBSEARCH_NAME FROM TRANSLATION_LOCALE WHERE TRANSLATION_ID=? AND LOCALE_ID=? LIMIT 1
Array ( [0] => 1004 [1] => 1 )
Time: 0.0001699924468994141 seconds.