2011-12-10

Re: Practice Final Answers - Post your answers here .

'''Originally Posted By: jnewth'''

<br>Problem 8: Show GNI is in IP.<br><br><br>Addressed in page 148 of the book and the notes of November 30th. The problem is relevant because it is a problem in IP not known to be in NP.<br><br>There is a great image of two isomorphic graphs and the permutation description at wikipedia: http://en.wikipedia.org/wiki/Graph_isomorphism<br><br>Graph isomorphism (GI)<br><br>GI, the problem of deciding if two graphs are isomorphs (ie, the nodes can be permuted without changing the edge structure to form the other graph) is in NP, because a certificate can be a description of the permutation. It is not known if GNI, that of declaring if two graphs are NOT isomorphic is in NP. It can however be stated as a problem in IP in the following way:<br><br>V: Pick i=0/1. Randomly permute the vertices of graph i to get a new graph H.<br>V: Send H to the prover P.<br>P: Identify which graph G0 or G1 the H came from. If it could have come from either, guess which one. Send the guess j back to V.<br>V: If i == j accept; else reject.<br><br>If the graphs are not the same then there exists a prover that can tell them apart, or rather there exists P such that Pr(V accepts) = 1. This is greater than 2/3, so we meet the Completeness requirement for IP. <br><br>If on the other hand the graphs are the same, the best that prover can do is guess G0 or G1, so in every case Pr[V accepts] jnewth — Sat Dec 10, 2011 6:46 pm <hr>

'''Originally Posted By: jnewth''' <br>Problem 8: Show GNI is in IP.<br><br><br>Addressed in page 148 of the book and the notes of November 30th. The problem is relevant because it is a problem in IP not known to be in NP.<br><br>There is a great image of two isomorphic graphs and the permutation description at wikipedia: http://en.wikipedia.org/wiki/Graph_isomorphism<br><br>Graph isomorphism (GI)<br><br>GI, the problem of deciding if two graphs are isomorphs (ie, the nodes can be permuted without changing the edge structure to form the other graph) is in NP, because a certificate can be a description of the permutation. It is not known if GNI, that of declaring if two graphs are NOT isomorphic is in NP. It can however be stated as a problem in IP in the following way:<br><br>V: Pick i=0/1. Randomly permute the vertices of graph i to get a new graph H.<br>V: Send H to the prover P.<br>P: Identify which graph G0 or G1 the H came from. If it could have come from either, guess which one. Send the guess j back to V.<br>V: If i == j accept; else reject.<br><br>If the graphs are not the same then there exists a prover that can tell them apart, or rather there exists P such that Pr(V accepts) = 1. This is greater than 2/3, so we meet the Completeness requirement for IP. <br><br>If on the other hand the graphs are the same, the best that prover can do is guess G0 or G1, so in every case Pr[V accepts] jnewth &mdash; Sat Dec 10, 2011 6:46 pm <hr>

Practice Final Answers - Post your answers here

&#039;&#039;&#039;Originally Posted By: jnewth&#039;&#039;&#039;

&lt;br&gt;Problem 7: Show BPP is in Sigma-P2.&lt;br&gt;&lt;br&gt;&lt;br&gt;This proof is Sipser-Gacs presented pg 136 and the notes of November 28.&lt;br&gt;&lt;br&gt;Proof Idea:&lt;br&gt;BPP is contained in the intersection of Sigma-P2 and Pi-P2 which can be simplified to Sigma-P2 because BPP=coBPP, i.e. BPP is closed under complementation.&lt;br&gt;&lt;br&gt;If x is the language L in BPP, then there is a certificate r that causes M to accept x with some high probability. If x is not in the language, then there are a small number of certificates that will cause M to accept x erroneously. The rest of this proof uses the concept of &amp;quot;shifts&amp;quot; to show that thinking about the the sizes of these two sets of certificates (that cause M to accept x either correctly or incorrectly) can be phrased as a computation in Sigma-P2. Math ensues:&lt;br&gt;&lt;br&gt;For a language in L in BPP:&lt;br&gt;&lt;br&gt;x&amp;isin;L&amp;rArr;Pr[M(x,r)accepts]&amp;ge;1-2^-n&lt;br&gt;x&amp;notin;L&amp;rArr;Pr[M(x,r)accepts]&amp;le;2^-n&lt;br&gt;&lt;br&gt;For x of length n, Sx is the set of certificate &amp;quot;r&amp;quot; of length at most m for which M accepts .&lt;br&gt;&lt;br&gt;If x&amp;isin;L then size Sx = Pr(M(x,r) accepts correctly) * number of strings of length m &lt;br&gt;|Sx|&amp;gt;=(1-2^-n)(2^m)&lt;br&gt;&lt;br&gt;And by similar reasoning for x&amp;notin;L&lt;br&gt;&lt;br&gt;Sx = Pr(M(x, r) accepts erroneously) * number of strings of length m &lt;br&gt;|Sx| Shift: If we have a set of strings of length m and a shift string u of length m, we shift S by u by doing bitwise addition of every string in S with u, creating a new set of strings of the same size as the original set S. We generate a new set for each shift. &lt;br&gt;&lt;br&gt;Claim 1: For every set S&amp;sube;{0,1}^m with |S|&amp;le;2^(m-n) and k vectors u1,...uk, the union of all strings for each shift Proof: The shift of the set has the same number of strings as the original set, so if we add all the shifted sets together, we would get at most k|S| total strings. k*|S| strings is less than 2^m, the total possible number of strings of length m. This is because m=|r| (ie the length of a certificate) which can only be polynomial in n. The algebra is in the notes.&lt;br&gt;&lt;br&gt;Claim 2: For every set S&amp;sube;{0,1}^m with |S|&amp;ge;(1-2^-n)*(2^m), there exist u1,...,uk such that the union of all shifted sets = {0,1}^m&lt;br&gt;&lt;br&gt;(IE A big enough set with k shifts CAN generate all 2^m strings of length m)&lt;br&gt;&lt;br&gt;We want to show that there is at least SOME choice of shifts for which this is true. We do this by showing &lt;br&gt;Pr[there exists a string of length m that is not in S&#039;] jnewth &amp;mdash; Sat Dec 10, 2011 6:25 pm &lt;hr&gt;

'''Originally Posted By: jnewth''' <br>Problem 7: Show BPP is in Sigma-P2.<br><br><br>This proof is Sipser-Gacs presented pg 136 and the notes of November 28.<br><br>Proof Idea:<br>BPP is contained in the intersection of Sigma-P2 and Pi-P2 which can be simplified to Sigma-P2 because BPP=coBPP, i.e. BPP is closed under complementation.<br><br>If x is the language L in BPP, then there is a certificate r that causes M to accept x with some high probability. If x is not in the language, then there are a small number of certificates that will cause M to accept x erroneously. The rest of this proof uses the concept of &quot;shifts&quot; to show that thinking about the the sizes of these two sets of certificates (that cause M to accept x either correctly or incorrectly) can be phrased as a computation in Sigma-P2. Math ensues:<br><br>For a language in L in BPP:<br><br>x&isin;L&rArr;Pr[M(x,r)accepts]&ge;1-2^-n<br>x&notin;L&rArr;Pr[M(x,r)accepts]&le;2^-n<br><br>For x of length n, Sx is the set of certificate &quot;r&quot; of length at most m for which M accepts .<br><br>If x&isin;L then size Sx = Pr(M(x,r) accepts correctly) * number of strings of length m <br>|Sx|&gt;=(1-2^-n)*(2^m)<br><br>And by similar reasoning for x&notin;L<br><br>Sx = Pr(M(x, r) accepts erroneously) * number of strings of length m <br>|Sx| Shift: If we have a set of strings of length m and a shift string u of length m, we shift S by u by doing bitwise addition of every string in S with u, creating a new set of strings of the same size as the original set S. We generate a new set for each shift. <br><br>Claim 1: For every set S&sube;{0,1}^m with |S|&le;2^(m-n) and k vectors u1,...uk, the union of all strings for each shift Proof: The shift of the set has the same number of strings as the original set, so if we add all the shifted sets together, we would get at most k*|S| total strings. k*|S| strings is less than 2^m, the total possible number of strings of length m. This is because m=|r| (ie the length of a certificate) which can only be polynomial in n. The algebra is in the notes.<br><br>Claim 2: For every set S&sube;{0,1}^m with |S|&ge;(1-2^-n)*(2^m), there exist u1,...,uk such that the union of all shifted sets = {0,1}^m<br><br>(IE A big enough set with k shifts CAN generate all 2^m strings of length m)<br><br>We want to show that there is at least SOME choice of shifts for which this is true. We do this by showing <br>Pr[there exists a string of length m that is not in S'] jnewth &mdash; Sat Dec 10, 2011 6:25 pm <hr>

-- Practice Final Answers - Post your answers here

&#039;&#039;&#039;Originally Posted By: Nishant&#039;&#039;&#039;

Q-2) Give an NC circuit family whose member nth member, Cn, computes the parity of its n input bits.&lt;br&gt;&lt;br&gt;Sol:)&lt;br&gt;The language PARITY ={x : x has an odd number of 1s} is in NC1. The circuit&lt;br&gt;computing it has the form of a binary tree. The answer appears at the&lt;br&gt;root; the left subtree computes the parity of the first |x| /2 bits and the right&lt;br&gt;subtree computes the parity of the remaining bits. The gate at the top computes&lt;br&gt;the parity of these two bits. Clearly, unwrapping the recursion implicit in our&lt;br&gt;description gives a circuit of depth O(log n). It is also logspace uniform.

'''Originally Posted By: Nishant''' Q-2) Give an NC circuit family whose member nth member, Cn, computes the parity of its n input bits.<br><br>Sol:)<br>The language PARITY ={x : x has an odd number of 1s} is in NC1. The circuit<br>computing it has the form of a binary tree. The answer appears at the<br>root; the left subtree computes the parity of the first |x| /2 bits and the right<br>subtree computes the parity of the remaining bits. The gate at the top computes<br>the parity of these two bits. Clearly, unwrapping the recursion implicit in our<br>description gives a circuit of depth O(log n). It is also logspace uniform.
2011-12-13

-- Practice Final Answers - Post your answers here

&#039;&#039;&#039;Originally Posted By: cwong&#039;&#039;&#039;

'''Originally Posted By: cwong'''

-- Practice Final Answers - Post your answers here

&#039;&#039;&#039;Originally Posted By: Jay_Reynolds_Freeman&#039;&#039;&#039;

Problem 5 -- submitted by Jay Freeman:&lt;br&gt;&lt;br&gt;Give the randomized p-time algorithm for 2SAT and explain how its running time is determined.&lt;br&gt;&lt;br&gt;This matter is described in the lecture of 23 November, slides 3 through 5. The basic idea is to start with any (random) assignment of variables and repeat the following N times:&lt;br&gt;&lt;br&gt;If the formula is satisfied&lt;br&gt; emit &amp;quot;Satisfied&amp;quot;&lt;br&gt;Else&lt;br&gt; take any unsatisfied clause, and flip one of its literals (randomly chosen)&lt;br&gt;&lt;br&gt;After N repetitions, emit, &amp;quot;Probably not satisfiable.&amp;quot;&lt;br&gt;&lt;br&gt;The key is to pick the number of literals to get a decent probability of finding a satisfying combination of literal assignments, if indeed there is one.&lt;br&gt;&lt;br&gt;For 2SAT, it turns out that N = 2 * n**2, where n is the number of literals, will make that probability 0.5. The proof involves setting up recurrence relations in t(i), the expected number of &amp;quot;flip&amp;quot; steps to obtain a solution when we start with i literals incorrect. t(0) = 0 (of course), t( i ) Jay_Reynolds_Freeman &amp;mdash; Tue Dec 13, 2011 2:31 am &lt;hr&gt;

'''Originally Posted By: Jay_Reynolds_Freeman''' Problem 5 -- submitted by Jay Freeman:<br><br>Give the randomized p-time algorithm for 2SAT and explain how its running time is determined.<br><br>This matter is described in the lecture of 23 November, slides 3 through 5. The basic idea is to start with any (random) assignment of variables and repeat the following N times:<br><br>If the formula is satisfied<br> emit &quot;Satisfied&quot;<br>Else<br> take any unsatisfied clause, and flip one of its literals (randomly chosen)<br><br>After N repetitions, emit, &quot;Probably not satisfiable.&quot;<br><br>The key is to pick the number of literals to get a decent probability of finding a satisfying combination of literal assignments, if indeed there is one.<br><br>For 2SAT, it turns out that N = 2 * n**2, where n is the number of literals, will make that probability 0.5. The proof involves setting up recurrence relations in t(i), the expected number of &quot;flip&quot; steps to obtain a solution when we start with i literals incorrect. t(0) = 0 (of course), t( i ) Jay_Reynolds_Freeman &mdash; Tue Dec 13, 2011 2:31 am <hr>

-- Practice Final Answers - Post your answers here

&#039;&#039;&#039;Originally Posted By: stang&#039;&#039;&#039;

Question #3: Consider the language {a,k,a_1,...a_n|a is the k-th smallest a_i}. Show this is in BPP.&lt;br&gt;&lt;br&gt;Answer:&lt;br&gt; By using the proof given in the class notes (Nov 21) about PTM, we can say that finding the k-th smallest number can be simulated on PTMs. After finding the k-th smallest element, we can verify it with given a in the question #3. Since BPP is the language that is declared by the class of language decided by PTM(s) in O(T(n)) time, hence BPP = U_c BPTIME(n^c). &lt;br&gt; Thus, with the proofs from both, the language is in BPP.

'''Originally Posted By: stang''' Question #3: Consider the language {ใ€ˆa,k,ใ€ˆa_1,...a_nใ€‰ใ€‰|a is the k-th smallest a_i}. Show this is in BPP.<br><br>Answer:<br> By using the proof given in the class notes (Nov 21) about PTM, we can say that finding the k-th smallest number can be simulated on PTMs. After finding the k-th smallest element, we can verify it with given a in the question #3. Since BPP is the language that is declared by the class of language decided by PTM(s) in O(T(n)) time, hence BPP = U_c BPTIME(n^c). <br> Thus, with the proofs from both, the language is in BPP.

-- Practice Final Answers - Post your answers here

&#039;&#039;&#039;Originally Posted By: sctice&#039;&#039;&#039;

I apologize for posting this so late in the game. I&#039;m not sure whether I was supposed to do 4 or 6, so I&#039;ll start with 4.&lt;br&gt;&lt;br&gt;Question 4: State Markov&#039;s Theorem and prove it.&lt;br&gt;&lt;br&gt;I&#039;m assuming this question is referring to Markov&#039;s inequality, which is defined and proven here: http://www.cs.sjsu.edu/faculty/pollett/ ... ml#%285%29. I&#039;ll go ahead and write it out. The theorem says that any nonnegative random variable X satisfies Pr(X &amp;gt;= k * E[X]) http://saravananthirumuruganathan.wordp ... qualities/.&lt;br&gt;&lt;br&gt;Question 6: State Chernoff bounds.&lt;br&gt;&lt;br&gt;Chernoff bounds are defined (and proved on the following slide) here: http://www.cs.sjsu.edu/faculty/pollett/ ... ml#%288%29. The bounds are useful (among other reasons) because they provide guarantees on error reduction for repeated trials, even when (as with BPP) both false positives and false negatives are possible.

'''Originally Posted By: sctice''' I apologize for posting this so late in the game. I'm not sure whether I was supposed to do 4 or 6, so I'll start with 4.<br><br>Question 4: State Markov's Theorem and prove it.<br><br>I'm assuming this question is referring to Markov's inequality, which is defined and proven here: http://www.cs.sjsu.edu/faculty/pollett/ ... ml#%285%29. I'll go ahead and write it out. The theorem says that any nonnegative random variable X satisfies Pr(X &gt;= k * E[X]) http://saravananthirumuruganathan.wordp ... qualities/.<br><br>Question 6: State Chernoff bounds.<br><br>Chernoff bounds are defined (and proved on the following slide) here: http://www.cs.sjsu.edu/faculty/pollett/ ... ml#%288%29. The bounds are useful (among other reasons) because they provide guarantees on error reduction for repeated trials, even when (as with BPP) both false positives and false negatives are possible.
X

 

Query Statistics

https://yioop.com/thread/3313

Total Elapsed Time for Queries: 0.04296207427978516 seconds.
SELECT LOCALE_NAME, WRITING_MODE FROM LOCALE WHERE LOCALE_TAG ='en-US'
Time: 0.0001609325408935547 seconds.
SELECT COALESCE(MAX(UPDATE_TIMESTAMP), 0) AS MOST_RECENT FROM ITEM_IMPRESSION_SUMMARY WHERE USER_ID = 2 AND ITEM_TYPE = 3 AND ITEM_ID IN (SELECT GROUP_ID FROM USER_GROUP WHERE USER_ID = 2 AND STATUS = 1) AND UPDATE_PERIOD = -4
Time: 0.00037384033203125 seconds.
DELETE FROM ITEM_IMPRESSION_SUMMARY WHERE USER_ID=? AND ITEM_ID=? AND ITEM_TYPE=? AND UPDATE_PERIOD = -4
Array ( [0] => 2 [1] => 3313 [2] => 1 )
Time: 0.003468036651611328 seconds.
INSERT INTO ITEM_IMPRESSION_SUMMARY VALUES (?, ?, ?, -4, ?, 0, -1, -1) ON CONFLICT DO NOTHING
Array ( [0] => 2 [1] => 3313 [2] => 1 [3] => 1789983507 )
Time: 0.002187967300415039 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] => 3313 [2] => 1 )
Time: 0.0001018047332763672 seconds.
DELETE FROM ITEM_IMPRESSION_SUMMARY WHERE USER_ID=? AND ITEM_ID=? AND ITEM_TYPE=? AND UPDATE_PERIOD = -4
Array ( [0] => 2 [1] => 247 [2] => 3 )
Time: 0.002132892608642578 seconds.
INSERT INTO ITEM_IMPRESSION_SUMMARY VALUES (?, ?, ?, -4, ?, 0, -1, -1) ON CONFLICT DO NOTHING
Array ( [0] => 2 [1] => 247 [2] => 3 [3] => 1789983507 )
Time: 0.002160072326660156 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] => 247 [2] => 3 )
Time: 7.200241088867188E-5 seconds.
SELECT COUNT(GI.ID) AS NUM FROM GROUP_ITEM GI WHERE GI.GROUP_ID IN (SELECT GROUP_ID FROM USER_GROUP WHERE USER_ID = ? AND STATUS = 1) AND GI.TITLE NOT LIKE ? AND GI.PUBDATE > ?
Array ( [0] => 2 [1] => %2% [2] => 1789983498 )
Time: 0.0002899169921875 seconds.
SELECT PARENT_ID FROM GROUP_ITEM WHERE GROUP_ID=? AND USER_ID=? AND TITLE=? LIMIT 1
Array ( [0] => -1 [1] => 2 [2] => 2-4 )
Time: 9.512901306152344E-5 seconds.
SELECT PARENT_ID FROM GROUP_ITEM WHERE GROUP_ID=? AND USER_ID=? AND TITLE=? LIMIT 1
Array ( [0] => -1 [1] => 2 [2] => 2-37 )
Time: 3.910064697265625E-5 seconds.
SELECT PARENT_ID FROM GROUP_ITEM WHERE GROUP_ID=? AND USER_ID=? AND TITLE=? LIMIT 1
Array ( [0] => -1 [1] => 2 [2] => 2-202 )
Time: 3.290176391601562E-5 seconds.
SELECT PARENT_ID FROM GROUP_ITEM WHERE GROUP_ID=? AND USER_ID=? AND TITLE=? LIMIT 1
Array ( [0] => -1 [1] => 2 [2] => 2-687 )
Time: 3.099441528320312E-5 seconds.
SELECT PARENT_ID FROM GROUP_ITEM WHERE GROUP_ID=? AND USER_ID=? AND TITLE=? LIMIT 1
Array ( [0] => -1 [1] => 2 [2] => 2-1115 )
Time: 4.315376281738281E-5 seconds.
SELECT PARENT_ID FROM GROUP_ITEM WHERE GROUP_ID=? AND USER_ID=? AND TITLE=? LIMIT 1
Array ( [0] => -1 [1] => 2 [2] => 2-1138 )
Time: 5.412101745605469E-5 seconds.
SELECT PARENT_ID FROM GROUP_ITEM WHERE GROUP_ID=? AND USER_ID=? AND TITLE=? LIMIT 1
Array ( [0] => -1 [1] => 2 [2] => 2-1140 )
Time: 3.290176391601562E-5 seconds.
SELECT PARENT_ID FROM GROUP_ITEM WHERE GROUP_ID=? AND USER_ID=? AND TITLE=? LIMIT 1
Array ( [0] => -1 [1] => 2 [2] => 2-1149 )
Time: 3.194808959960938E-5 seconds.
SELECT PARENT_ID FROM GROUP_ITEM WHERE GROUP_ID=? AND USER_ID=? AND TITLE=? LIMIT 1
Array ( [0] => -1 [1] => 2 [2] => 2-1152 )
Time: 3.099441528320312E-5 seconds.
SELECT * FROM GROUP_ITEM WHERE ID=? LIMIT 1
Array ( [0] => 3313 )
Time: 0.0002360343933105469 seconds.
SELECT OPTIONS FROM SOCIAL_GROUPS WHERE GROUP_ID = ?
Array ( [0] => 247 )
Time: 5.888938903808594E-5 seconds.
SELECT COUNT(DISTINCT GI.ID) AS NUM FROM GROUP_ITEM GI, SOCIAL_GROUPS G, USER_GROUP UG, USERS O WHERE GI.PARENT_ID='3313' AND NOT LOWER(group_name) LIKE LOWER('Personal$%') AND (UG.USER_ID='2' OR G.REGISTER_TYPE IN ('4','3') ) AND GI.USER_ID=O.USER_ID AND GI.GROUP_ID=G.GROUP_ID AND GI.GROUP_ID=UG.GROUP_ID AND (( G.MEMBER_ACCESS IN ('2','3','4', '5')) OR (G.OWNER_ID = UG.USER_ID OR UG.USER_ID = '1'))
Time: 0.0005841255187988281 seconds.
SELECT DISTINCT GI.ID AS ID, GI.PARENT_ID AS PARENT_ID, GI.GROUP_ID AS GROUP_ID, GI.TITLE AS TITLE, GI.DESCRIPTION AS DESCRIPTION, GI.FLAG AS FLAG, GI.PUBDATE AS PUBDATE, GI.EDIT_DATE AS EDIT_DATE, G.OWNER_ID AS OWNER_ID, G.MEMBER_ACCESS AS MEMBER_ACCESS, G.GROUP_NAME AS GROUP_NAME, P.USER_NAME AS USER_NAME, P.USER_ID AS USER_ID, GI.TYPE AS TYPE, GI.UPS AS UPS, GI.DOWNS AS DOWNS, G.VOTE_ACCESS AS VOTE_ACCESS FROM GROUP_ITEM GI, SOCIAL_GROUPS G, USER_GROUP UG, USERS P WHERE GI.PARENT_ID='3313' AND NOT LOWER(group_name) LIKE LOWER('Personal$%') AND (UG.USER_ID='2' OR G.REGISTER_TYPE IN ('4','3') ) AND GI.GROUP_ID=G.GROUP_ID AND GI.GROUP_ID=UG.GROUP_ID AND (( G.MEMBER_ACCESS IN ('2','3','4', '5')) OR (G.OWNER_ID = UG.USER_ID OR UG.USER_ID = '1')) AND GI.PARENT_ID NOT IN (SELECT DISCUSS_THREAD FROM GROUP_PAGE WHERE TITLE LIKE '%$$%' AND DISCUSS_THREAD IS NOT NULL) AND P.USER_ID = GI.USER_ID ORDER BY GI.PUBDATE ASC LIMIT 10 OFFSET 0
Time: 0.02658700942993164 seconds.
SELECT OPTIONS FROM SOCIAL_GROUPS WHERE GROUP_ID = ?
Array ( [0] => 247 )
Time: 0.0003960132598876953 seconds.
SELECT OPTIONS FROM SOCIAL_GROUPS WHERE GROUP_ID = ?
Array ( [0] => 247 )
Time: 0.0001311302185058594 seconds.
SELECT OPTIONS FROM SOCIAL_GROUPS WHERE GROUP_ID = ?
Array ( [0] => 247 )
Time: 0.000125885009765625 seconds.
SELECT OPTIONS FROM SOCIAL_GROUPS WHERE GROUP_ID = ?
Array ( [0] => 247 )
Time: 0.0001299381256103516 seconds.
SELECT OPTIONS FROM SOCIAL_GROUPS WHERE GROUP_ID = ?
Array ( [0] => 247 )
Time: 0.0001530647277832031 seconds.
SELECT OPTIONS FROM SOCIAL_GROUPS WHERE GROUP_ID = ?
Array ( [0] => 247 )
Time: 8.893013000488281E-5 seconds.
SELECT OPTIONS FROM SOCIAL_GROUPS WHERE GROUP_ID = ?
Array ( [0] => 247 )
Time: 4.911422729492188E-5 seconds.
SELECT * FROM GROUP_ITEM WHERE ID=? LIMIT 1
Array ( [0] => 3313 )
Time: 0.00026702880859375 seconds.
SELECT OPTIONS FROM SOCIAL_GROUPS WHERE GROUP_ID = ?
Array ( [0] => 247 )
Time: 8.702278137207031E-5 seconds.
SELECT STATUS FROM USERS WHERE USER_ID = ?
Array ( [0] => 2 )
Time: 0.0001230239868164062 seconds.
SELECT USER_NAME FROM USERS WHERE USER_ID = ?
Array ( [0] => 2 )
Time: 6.29425048828125E-5 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.0002279281616210938 seconds.
SELECT COUNT(DISTINCT G.GROUP_ID) AS NUM FROM USER_GROUP UG, SOCIAL_GROUPS G WHERE UG.USER_ID = ? AND UG.GROUP_ID = G.GROUP_ID AND ( UG.STATUS = 1 OR UG.STATUS = 5)
Array ( [0] => 2 )
Time: 0.0003650188446044922 seconds.
SELECT G.GROUP_ID AS GROUP_ID FROM SOCIAL_GROUPS G WHERE G.GROUP_NAME = ?
Array ( [0] => Personal$2 )
Time: 0.0001480579376220703 seconds.
SELECT USER_ID FROM USER_GROUP WHERE GROUP_ID = ?
Array ( [0] => -1 )
Time: 6.604194641113281E-5 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] => 247 [:user_id] => 2 )
Time: 0.0001828670501708984 seconds.
SELECT RENDER_ENGINE FROM SOCIAL_GROUPS WHERE GROUP_ID = ?
Array ( [0] => -2 )
Time: 0.0001771450042724609 seconds.
SELECT RENDER_ENGINE FROM SOCIAL_GROUPS WHERE GROUP_ID = ?
Array ( [0] => 247 )
Time: 7.796287536621094E-5 seconds.
SELECT RENDER_ENGINE FROM SOCIAL_GROUPS WHERE GROUP_ID = ?
Array ( [0] => 247 )
Time: 0.0001749992370605469 seconds.
SELECT RENDER_ENGINE FROM SOCIAL_GROUPS WHERE GROUP_ID = ?
Array ( [0] => 247 )
Time: 0.0002810955047607422 seconds.
SELECT RENDER_ENGINE FROM SOCIAL_GROUPS WHERE GROUP_ID = ?
Array ( [0] => 247 )
Time: 9.608268737792969E-5 seconds.
SELECT RENDER_ENGINE FROM SOCIAL_GROUPS WHERE GROUP_ID = ?
Array ( [0] => 247 )
Time: 5.793571472167969E-5 seconds.
SELECT RENDER_ENGINE FROM SOCIAL_GROUPS WHERE GROUP_ID = ?
Array ( [0] => 247 )
Time: 8.606910705566406E-5 seconds.
SELECT RENDER_ENGINE FROM SOCIAL_GROUPS WHERE GROUP_ID = ?
Array ( [0] => 247 )
Time: 7.104873657226562E-5 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] => 247 [:user_id] => 2 )
Time: 0.0004220008850097656 seconds.
SELECT STATUS FROM USER_GROUP WHERE USER_ID=? AND GROUP_ID=? LIMIT 1
Array ( [0] => 2 [1] => 247 )
Time: 0.0001089572906494141 seconds.