Difference: -
 
(First | Second) 2021-09-02T13:02:59-07:00. 1630612979. Edited by root.upgrade. (1263 bytes).
 
(First | Second) 2021-08-17T02:59:13-07:00. 1629194353. Edited by public.Revert to 2018-03-25T16:04:07-07:00.. (1149 bytes).
 
(First | Second) 2021-07-08T14:50:28-07:00. 1625781028. Edited by public.Revert to 2021-07-07T15:48:34-07:00.. (1149 bytes).
 
(First | Second) 2021-07-08T13:58:03-07:00. 1625777883. Edited by public.Revert to 2021-03-22T07:07:10-07:00.. (1149 bytes).
 
(First | Second) 2021-07-07T15:48:34-07:00. 1625698114. Edited by public.Revert to 2020-11-13T22:36:09-08:00.. (1149 bytes).
 
(First | Second) 2021-06-26T04:28:55-07:00. 1624706935. Edited by public.Revert to 2021-03-22T13:02:22-07:00.. (1149 bytes).
 
(First | Second) 2021-05-25T01:58:57-07:00. 1621933137. Edited by public.Revert to 2020-11-02T08:24:47-08:00.. (1149 bytes).
 
(First | Second) 2021-04-20T09:28:22-07:00. 1618936102. Edited by public.Revert to 2020-07-11T20:19:41-07:00.. (1282 bytes).
 
(First | Second) 2021-03-22T13:02:22-07:00. 1616443342. Edited by public.Revert to 2021-03-22T07:07:10-07:00.. (1149 bytes).
 
(First | Second) 2021-03-22T09:01:03-07:00. 1616428863. Edited by public.Revert to 2021-03-22T07:03:40-07:00.. (1149 bytes).
 
(First | Second) 2021-03-22T07:07:10-07:00. 1616422030. Edited by public.Revert to 2018-03-04T15:07:09-08:00.. (1149 bytes).
 
(First | Second) 2021-03-22T07:03:40-07:00. 1616421820. Edited by public.Revert to 2015-01-16T12:25:00-08:00.. (1149 bytes).
 
(First | Second) 2020-11-13T22:36:09-08:00. 1605335769. Edited by public.Revert to 2020-09-08T16:36:50-07:00.. (1149 bytes).
 
(First | Second) 2020-11-13T22:32:26-08:00. 1605335546. Edited by public.Revert to 2020-09-08T16:36:50-07:00.. (1149 bytes).
 
(First | Second) 2020-11-03T21:23:09-08:00. 1604467389. Edited by public.Revert to 2015-07-14T14:42:42-07:00.. (1149 bytes).
 
(First | Second) 2020-11-02T08:24:47-08:00. 1604334287. Edited by public.Revert to 2020-09-09T09:02:49-07:00.. (1149 bytes).
 
(First | Second) 2020-10-31T16:45:16-07:00. 1604187916. Edited by public.Revert to 2020-08-12T12:28:30-07:00.. (1263 bytes).
 
(First | Second) 2020-10-31T16:41:24-07:00. 1604187684. Edited by public.Revert to 2015-01-16T12:25:03-08:00.. (1149 bytes).
 
(First | Second) 2020-09-09T09:02:49-07:00. 1599667369. Edited by public.Revert to 2018-03-26T18:15:29-07:00.. (1149 bytes).
 
(First | Second) 2020-09-08T16:36:50-07:00. 1599608210. Edited by public.Revert to 2018-02-25T11:23:50-08:00.. (1149 bytes).
 
(First | Second) 2020-08-12T12:28:30-07:00. 1597260510. Edited by root.upgrade. (1263 bytes).
 
(First | Second) 2020-07-11T20:19:41-07:00. 1594523981. Edited by root.upgrade. (1282 bytes).
 
(First | Second) 2020-04-24T18:54:52-07:00. 1587779692. Edited by public.Revert to 2015-05-17T22:16:06-07:00.. (1149 bytes).
 
(First | Second) 2018-05-20T18:52:04-07:00. 1526867524. Edited by root.(1149 bytes).
 
(First | Second) 2018-05-13T20:14:40-07:00. 1526267680. Edited by root.(1149 bytes).
 
(First | Second) 2018-05-11T15:23:35-07:00. 1526077415. Edited by root.(1149 bytes).
 
(First | Second) 2018-05-07T00:48:04-07:00. 1525679284. Edited by root.(1149 bytes).
 
(First | Second) 2018-03-26T18:15:29-07:00. 1522113329. Edited by root.(1149 bytes).
 
(First | Second) 2018-03-25T16:04:07-07:00. 1522019047. Edited by root.(1149 bytes).
 
(First | Second) 2018-03-04T15:07:09-08:00. 1520204829. Edited by root.(1149 bytes).
 
(First | Second) 2018-02-25T11:23:50-08:00. 1519586630. Edited by root.(1149 bytes).
 
(First | Second) 2018-01-28T20:22:13-08:00. 1517199733. Edited by root.(1149 bytes).
 
(First | Second) 2017-05-18T13:11:47-07:00. 1495138307. Edited by root.(1149 bytes).
 
(First | Second) 2017-03-27T08:47:03-07:00. 1490629623. Edited by root.(1149 bytes).
 
(First | Second) 2016-09-23T19:03:40-07:00. 1474682620. Edited by root.(1149 bytes).
 
(First | Second) 2015-10-20T14:24:38-07:00. 1445376278. Edited by root.(1149 bytes).
 
(First | Second) 2015-07-20T20:57:48-07:00. 1437451068. Edited by root.(1149 bytes).
 
(First | Second) 2015-07-20T08:29:42-07:00. 1437406182. Edited by root.(1149 bytes).
 
(First | Second) 2015-07-20T08:24:08-07:00. 1437405848. Edited by root.(1149 bytes).
 
(First | Second) 2015-07-14T15:31:23-07:00. 1436913083. Edited by root.(1149 bytes).
 
(First | Second) 2015-07-14T14:42:42-07:00. 1436910162. Edited by root.(1149 bytes).
 
(First | Second) 2015-05-19T10:47:03-07:00. 1432057623. Edited by root.(1149 bytes).
 
(First | Second) 2015-05-18T14:42:13-07:00. 1431985333. Edited by root.(1149 bytes).
 
(First | Second) 2015-05-17T22:16:07-07:00. 1431926167. Edited by root.(1149 bytes).
 
(First | Second) 2015-05-17T22:16:06-07:00. 1431926166. Edited by root.(1149 bytes).
 
(First | Second) 2015-05-17T12:46:54-07:00. 1431892014. Edited by root.(1149 bytes).
 
(First | Second) 2015-05-17T11:20:59-07:00. 1431886859. Edited by root.(1149 bytes).
 
(First | Second) 2015-05-14T12:41:30-07:00. 1431632490. Edited by root.(1149 bytes).
 
(First | Second) 2015-05-14T12:27:16-07:00. 1431631636. Edited by root.(1149 bytes).
 
(First | Second) 2015-04-23T16:55:45-07:00. 1429833345. Edited by root.(1149 bytes).
 
X

 

Query Statistics

https://www.yioop.com/group/3/Database_Setup?arg=history&page_id=261

Total Elapsed Time for Queries: 0.0115818977355957 seconds.
SELECT LOCALE_NAME, WRITING_MODE FROM LOCALE WHERE LOCALE_TAG ='en-US'
Time: 0.0002539157867431641 seconds.
DELETE FROM ITEM_IMPRESSION_SUMMARY WHERE USER_ID=? AND ITEM_ID=? AND ITEM_TYPE=? AND UPDATE_PERIOD = -4
Array ( [0] => 2 [1] => 261 [2] => 2 )
Time: 0.002205133438110352 seconds.
INSERT INTO ITEM_IMPRESSION_SUMMARY VALUES (?, ?, ?, -4, ?, 0, -1, -1) ON CONFLICT DO NOTHING
Array ( [0] => 2 [1] => 261 [2] => 2 [3] => 1789988914 )
Time: 0.002162933349609375 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] => 261 [2] => 2 )
Time: 0.0001020431518554688 seconds.
DELETE FROM ITEM_IMPRESSION_SUMMARY WHERE USER_ID=? AND ITEM_ID=? AND ITEM_TYPE=? AND UPDATE_PERIOD = -4
Array ( [0] => 2 [1] => 3 [2] => 3 )
Time: 0.002035140991210938 seconds.
INSERT INTO ITEM_IMPRESSION_SUMMARY VALUES (?, ?, ?, -4, ?, 0, -1, -1) ON CONFLICT DO NOTHING
Array ( [0] => 2 [1] => 3 [2] => 3 [3] => 1789988914 )
Time: 0.00223994255065918 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] => 3 [2] => 3 )
Time: 7.295608520507812E-5 seconds.
SELECT ID, PAGE, DISCUSS_THREAD, LAST_MODIFIED FROM GROUP_PAGE WHERE GROUP_ID = ? AND TITLE = ? AND LOCALE_TAG = ?
Array ( [0] => 3 [1] => Database_Setup [2] => en-US )
Time: 0.0001718997955322266 seconds.
SELECT GROUP_ID, LOCALE_TAG, TITLE AS PAGE_NAME, DISCUSS_THREAD, LAST_MODIFIED FROM GROUP_PAGE WHERE ID = ?
Array ( [0] => 261 )
Time: 7.605552673339844E-5 seconds.
SELECT COUNT(*) AS TOTAL, MAX(TITLE) AS PAGE_NAME FROM GROUP_PAGE_HISTORY WHERE PAGE_ID = ?
Array ( [0] => 261 )
Time: 0.0002288818359375 seconds.
SELECT H.PUBDATE AS PUBDATE, U.USER_NAME AS USER_NAME, LENGTH(H.PAGE) AS PAGE_LEN, H.EDIT_COMMENT AS EDIT_REASON FROM GROUP_PAGE_HISTORY H, USERS U WHERE H.PAGE_ID = ? AND U.USER_ID= H.EDITOR_ID ORDER BY PUBDATE DESC LIMIT 50 OFFSET 0
Array ( [0] => 261 )
Time: 0.00026702880859375 seconds.
SELECT ID FROM GROUP_PAGE WHERE GROUP_ID = ? AND TITLE=? AND LOCALE_TAG= ?
Array ( [0] => 3 [1] => Database_Setup [2] => en-US )
Time: 8.58306884765625E-5 seconds.
SELECT GROUP_ID, LOCALE_TAG, TITLE AS PAGE_NAME, DISCUSS_THREAD, LAST_MODIFIED FROM GROUP_PAGE WHERE ID = ?
Array ( [0] => 261 )
Time: 6.008148193359375E-5 seconds.
SELECT ID, PAGE, DISCUSS_THREAD, LAST_MODIFIED FROM GROUP_PAGE WHERE GROUP_ID = ? AND TITLE = ? AND LOCALE_TAG = ?
Array ( [0] => 3 [1] => Database_Setup [2] => en-US )
Time: 6.389617919921875E-5 seconds.
SELECT COUNT(DISTINCT LINK_TYPE_ID) AS NUM FROM GROUP_PAGE_LINK WHERE TO_ID = ? OR FROM_ID = ?
Array ( [0] => 261 [1] => 261 )
Time: 0.0001380443572998047 seconds.
SELECT LOCALE_ID, LOCALE_TAG, LOCALE_NAME, WRITING_MODE FROM LOCALE WHERE ACTIVE > 0
Time: 0.0002591609954833984 seconds.
SELECT STATUS FROM USERS WHERE USER_ID = ?
Array ( [0] => 2 )
Time: 0.000209808349609375 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.0002720355987548828 seconds.
SELECT STATUS FROM USER_GROUP WHERE USER_ID=? AND GROUP_ID=? AND STATUS=?
Array ( [0] => 2 [1] => 3 [2] => 5 )
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) AND UG.GROUP_ID= :group_id AND UG.GROUP_ID=G.GROUP_ID AND OWNER_ID = O.USER_ID LIMIT 1
Array ( [:group_id] => 3 [:user_id] => 2 )
Time: 0.0003662109375 seconds.
SELECT G.GROUP_ID AS GROUP_ID FROM SOCIAL_GROUPS G WHERE G.GROUP_NAME = ?
Array ( [0] => Personal$2 )
Time: 0.0001399517059326172 seconds.