Query Statistics

https://www.yioop.com/trending?arg=chart&period=604800&term=Mar-a-Lago

Total Elapsed Time for Queries: 0.03052425384521484 seconds.

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

Time: 0.002562046051025391 seconds.

SELECT ID FROM QUERY_ITEM WHERE QUERY_HASH = ?
Array ( [0] => oIf03JUELnY )

Time: 0.0006918907165527344 seconds.

INSERT INTO ITEM_IMPRESSION VALUES (?, ?, ?, ?)
Array ( [0] => 2 [1] => 273609 [2] => 4 [3] => 1568775910 )

Time: 0.005669832229614258 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.001524925231933594 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.002195119857788086 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.0007798671722412109 seconds.

SELECT URL, PARENT FROM MACHINE ORDER BY NAME DESC

Time: 0.001901865005493164 seconds.

SELECT CRAWL_TIME FROM CURRENT_WEB_INDEX

Time: 0.001079797744750977 seconds.

SELECT CRAWL_TIME FROM CURRENT_WEB_INDEX

Time: 0.0002930164337158203 seconds.

SELECT TIMESTAMP, NAME FROM CRAWL_MIXES WHERE TIMESTAMP = ?
Array ( [0] => 1565638436 )

Time: 0.0009341239929199219 seconds.

SELECT TIMESTAMP, NAME FROM CRAWL_MIXES WHERE TIMESTAMP = ?
Array ( [0] => 1565638436 )

Time: 0.0002341270446777344 seconds.

SELECT OCCURRENCES, TIMESTAMP FROM TRENDING_TERM WHERE TERM = ? AND UPDATE_PERIOD = ? AND LANGUAGE= ? ORDER BY TIMESTAMP DESC LIMIT 7
Array ( [0] => Mar-a-Lago [1] => 86400 [2] => en-US )

Time: 0.008384943008422852 seconds.

SELECT LOCALE_ID, LOCALE_TAG, LOCALE_NAME, WRITING_MODE FROM LOCALE WHERE ACTIVE > 0

Time: 0.00178980827331543 seconds.

SELECT LOCALE_ID FROM LOCALE WHERE LOCALE_TAG = ? LIMIT 1
Array ( [0] => en-US )

Time: 0.0004730224609375 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.001045942306518555 seconds.

SELECT TRANSLATION AS SUBSEARCH_NAME FROM TRANSLATION_LOCALE WHERE TRANSLATION_ID=? AND LOCALE_ID=? LIMIT 1
Array ( [0] => 1002 [1] => 1 )

Time: 0.0005788803100585938 seconds.

SELECT TRANSLATION AS SUBSEARCH_NAME FROM TRANSLATION_LOCALE WHERE TRANSLATION_ID=? AND LOCALE_ID=? LIMIT 1
Array ( [0] => 1003 [1] => 1 )

Time: 0.0001850128173828125 seconds.

SELECT TRANSLATION AS SUBSEARCH_NAME FROM TRANSLATION_LOCALE WHERE TRANSLATION_ID=? AND LOCALE_ID=? LIMIT 1
Array ( [0] => 1004 [1] => 1 )

Time: 0.0002000331878662109 seconds.

Daily Trend Score for 'Mar-a-Lago' for Last Week

Query Statistics