API tools faq
paste
Advertisement
iceq

Untitled

iceq
Nov 1st, 2011
130
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 28.91 KB | None | 0 0
raw download clone embed print report
  1.  
  2. # Tue Oct 25 23:17:59 2011
  3. # Query_time: 3.567532  Lock_time: 0.000182 Rows_sent: 17  Rows_examined: 167
  4. use tollabor_alrasid;
  5. SELECT SQL_CALC_FOUND_ROWS  wp_posts.* FROM wp_posts  WHERE 1=1  AND wp_posts.post_type = 'post' AND (wp_posts.post_status = 'publish')  ORDER BY wp_posts.post_date DESC LIMIT 0, 17
  6.  
  7. # Tue Oct 25 23:35:36 2011
  8. # Query_time: 3.473326  Lock_time: 1.218284 Rows_sent: 1  Rows_examined: 2
  9. use tollabor_alrasidcinema;
  10. SELECT   wp_posts.* FROM wp_posts  WHERE 1=1  AND YEAR(wp_posts.post_date)='2010' AND MONTH(wp_posts.post_date)='12' AND DAYOFMONTH(wp_posts.post_date)='5' AND wp_posts.post_name = 'the-social-network' AND wp_posts.post_type = 'post'  ORDER BY wp_posts.post_date DESC
  11.  
  12. # Tue Oct 25 23:36:47 2011
  13. # Query_time: 5.683313  Lock_time: 0.289262 Rows_sent: 0  Rows_examined: 4
  14. use tollabor_alrasid;
  15. SELECT t.*, tt.* FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON tt.term_id = t.term_id INNER JOIN wp_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN ('nav_menu') AND tr.object_id IN (1303) ORDER BY t.name ASC
  16.  
  17. # Tue Oct 25 23:36:50 2011
  18. # Query_time: 2.443840  Lock_time: 0.468938 Rows_sent: 5  Rows_examined: 15
  19. use tollabor_alrasid;
  20. SELECT SQL_CALC_FOUND_ROWS  wp_posts.*, yarpp.score FROM wp_posts  join wp_yarpp_related_cache as yarpp on wp_posts.ID = yarpp.ID WHERE 1=1  AND yarpp.score >= 3 and yarpp.reference_ID = 1303 AND wp_posts.post_type IN ('post', 'page')  ORDER BY yarpp.score DESC  limit 5
  21.  
  22. # Tue Oct 25 23:40:37 2011
  23. # Query_time: 2.793199  Lock_time: 1.534205 Rows_sent: 1  Rows_examined: 1
  24. use tollabor_alrasid;
  25. SELECT p.* FROM wp_posts AS p  WHERE p.post_date < '2010-08-26 03:17:47' AND p.post_type = 'post' AND p.post_status = 'publish'  ORDER BY p.post_date DESC LIMIT 1
  26.  
  27. # Wed Oct 26 01:31:20 2011
  28. # Query_time: 2.239297  Lock_time: 0.000033 Rows_sent: 4  Rows_examined: 8
  29. use tollabor_alrasid;
  30. SELECT * FROM wp_comments  WHERE comment_approved = '1' AND comment_post_ID = 57 ORDER BY comment_date_gmt ASC
  31.  
  32. # Wed Oct 26 03:26:27 2011
  33. # Query_time: 4.697040  Lock_time: 2.592753 Rows_sent: 1  Rows_examined: 1
  34. use tollabor_alrasid;
  35. SELECT ID, post_name, post_parent FROM wp_posts WHERE post_name = 'hosting-arabic-blogs' AND (post_type = 'page' OR post_type = 'attachment')
  36.  
  37. # Wed Oct 26 07:18:08 2011
  38. # Query_time: 2.475166  Lock_time: 0.000126 Rows_sent: 23  Rows_examined: 46
  39. use tollabor_alrasidcinema;
  40. SELECT * FROM wp_comments  WHERE comment_approved = '1' AND comment_post_ID = 14 ORDER BY comment_date_gmt ASC
  41.  
  42. # Wed Oct 26 07:47:37 2011
  43. # Query_time: 2.467617  Lock_time: 0.000127 Rows_sent: 0  Rows_examined: 305
  44. use tollabor_alrasidcinema;
  45. SELECT comment_post_ID FROM wp_comments WHERE LCASE(comment_author_email) = 'kini1688@aol.com' AND comment_subscribe='Y' AND comment_approved = '1' GROUP BY comment_post_ID
  46.  
  47. # Sun Oct 16 17:28:38 2011
  48. # Query_time: 3.417827  Lock_time: 0.000153 Rows_sent: 1  Rows_examined: 206
  49. use tollabor_alrasid;
  50. SELECT post_modified_gmt FROM wp_posts WHERE post_status = 'publish' AND post_type IN ('post', 'page', 'attachment') ORDER BY post_modified_gmt DESC LIMIT 1
  51.  
  52. # Sun Oct 16 17:42:49 2011
  53. # Query_time: 2.310940  Lock_time: 0.000090 Rows_sent: 17  Rows_examined: 17
  54. use tollabor_alrasidcinema;
  55. SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (219)
  56.  
  57.  
  58. # Sun Oct 16 17:54:21 2011
  59. # Query_time: 3.961766  Lock_time: 0.000350 Rows_sent: 9  Rows_examined: 62
  60. use tollabor_alrasidcinema;
  61. SELECT SQL_CALC_FOUND_ROWS  wp_posts.* FROM wp_posts  WHERE 1=1  AND wp_posts.post_type = 'post' AND (wp_posts.post_status = 'publish')  ORDER BY wp_posts.post_date DESC LIMIT 0, 9
  62.  
  63.  
  64. # Sun Oct 16 21:28:04 2011
  65. # Query_time: 4.588382  Lock_time: 0.000242 Rows_sent: 17  Rows_examined: 306
  66. use tollabor_alrasid;
  67. SELECT SQL_CALC_FOUND_ROWS  wp_posts.* FROM wp_posts  INNER JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id) WHERE 1=1  AND ( wp_term_relationships.term_taxonomy_id IN (1) ) AND wp_posts.post_type = 'post' AND (wp_posts.post_status = 'publish') GROUP BY wp_posts.ID ORDER BY wp_posts.post_date DESC LIMIT 0, 17
  68.  
  69. # Sun Oct 16 21:33:18 2011
  70. # Query_time: 3.556733  Lock_time: 1.861742 Rows_sent: 17  Rows_examined: 165
  71. use tollabor_alrasid;
  72. SELECT SQL_CALC_FOUND_ROWS  wp_posts.* FROM wp_posts  WHERE 1=1  AND wp_posts.post_type = 'post' AND (wp_posts.post_status = 'publish')  ORDER BY wp_posts.post_date DESC LIMIT 85, 17
  73.  
  74. # Sun Oct 16 21:42:21 2011
  75. # Query_time: 2.333092  Lock_time: 0.312374 Rows_sent: 0  Rows_examined: 1
  76. use tollabor_alrasidcinema;
  77. UPDATE `wp_options` SET `option_value` = 'a:13:{i:1318822496;a:1:{s:16:\"w3_pgcache_prime\";a:1:{s:32:\"40cd750bba9870f18aada2478b24840a\";a:3:{s:8:\"schedule\";s:16:\"w3_pgcache_prime\";s:4:\"args\";a:0:{}s:8:\"interval\";i:907;}}}i:1318822718;a:1:{s:16:\"w3_pgcache_prime\";a:1:{s:32:\"d63aca0b7e6237c7964320bd7fc95644\";a:2:{s:8:\"schedule\";b:0;s:4:\"args\";a:1:{i:0;i:7;}}}}i:1318823403;a:1:{s:16:\"w3_pgcache_prime\";a:1:{s:32:\"40cd750bba9870f18aada2478b24840a\";a:3:{s:8:\"schedule\";s:16:\"w3_pgcache_prime\";s:4:\"args\";a:0:{}s:8:\"interval\";i:907;}}}i:1318823434;a:1:{s:18:\"w3_pgcache_cleanup\";a:1:{s:32:\"40cd750bba9870f18aada2478b24840a\";a:3:{s:8:\"schedule\";s:18:\"w3_pgcache_cleanup\";s:4:\"args\";a:0:{}s:8:\"interval\";i:3600;}}}i:1318833968;a:1:{s:16:\"wp_update_themes\";a:1:{s:32:\"40cd750bba9870f18aada2478b24840a\";a:3:{s:8:\"schedule\";s:10:\"twicedaily\";s:4:\"args\";a:0:{}s:8:\"interval\";i:43200;}}}i:1318843334;a:1:{s:17:\"wp_update_plugins\";a:1:{s:32:\"40cd750bba9870f18aada2478b24840a\";a:3:{s:8:\"schedule\";s:10:\"twicedaily\";s:4:\"args\";a:0:{}s:8:\"interval\";i:43200;}}}i:1318847559;a:1:{s:16:\"wp_version_check\";a:1:{s:32:\"40cd750bba9870f18aada2478b24840a\";a:3:{s:8:\"schedule\";s:10:\"twicedaily\";s:4:\"args\";a:0:{}s:8:\"interval\";i:43200;}}}i:1318849298;a:1:{s:24:\"akismet_scheduled_delete\";a:1:{s:32:\"40cd750bba9870f18aada2478b24840a\";a:3:{s:8:\"schedule\";s:5:\"daily\";s:4:\"args\";a:0:{}s:8:\"interval\";i:86400;}}}i:1318875976;a:1:{s:19:\"wp_scheduled_delete\";a:1:{s:32:\"40cd750bba9870f18aada2478b24840a\";a:3:{s:8:\"schedule\";s:5:\"daily\";s:4:\"args\";a:0:{}s:8:\"interval\";i:86400;}}}i:1318899383;a:1:{s:21:\"dbmanager_cron_backup\";a:1:{s:32:\"40cd750bba9870f18aada2478b24840a\";a:3:{s:8:\"schedule\";s:16:\"dbmanager_backup\";s:4:\"args\";a:0:{}s:8:\"interval\";i:1209600;}}}i:1318950834;a:1:{s:19:\"publish_future_post\";a:1:{s:32:\"b92ae6a519d57a812bf09a7d229675e0\";a:2:{s:8:\"schedule\";b:0;s:4:\"args\";a:1:{i:0;i:1494;}}}}i:1318985783;a:1:{s:23:\"dbmanager_cron_optimize\";a:1:{s:32:\"40cd750bba9870f18aada2478b24840a\";a:3:{s:8:\"schedule\";s:18:\"dbmanager_optimize\";s:4:\"args\";a:0:{}s:8:\"interval\";i:259200;}}}s:7:\"version\";i:2;}' WHERE `option_name` = 'cron'
  78.  
  79. # Sun Oct 16 21:47:58 2011
  80. # Query_time: 2.656229  Lock_time: 1.586456 Rows_sent: 1013  Rows_examined: 1071
  81. use tollabor_alrasid;
  82. SELECT option_name, option_value FROM wp_options WHERE autoload = 'yes'
  83.  
  84.  
  85. # Mon Oct 17 01:18:43 2011
  86. # Query_time: 3.431384  Lock_time: 0.000169 Rows_sent: 5  Rows_examined: 15
  87. use tollabor_alrasid;
  88. SELECT SQL_CALC_FOUND_ROWS  wp_posts.*, yarpp.score FROM wp_posts  join wp_yarpp_related_cache as yarpp on wp_posts.ID = yarpp.ID WHERE 1=1  AND yarpp.score >= 3 and yarpp.reference_ID = 1641 AND wp_posts.post_type IN ('post', 'page')  ORDER BY yarpp.score DESC  limit 5
  89.  
  90. # Mon Oct 17 01:22:36 2011
  91. # Query_time: 5.810652  Lock_time: 0.000157 Rows_sent: 17  Rows_examined: 165
  92. use tollabor_alrasid;
  93. SELECT SQL_CALC_FOUND_ROWS  wp_posts.* FROM wp_posts  WHERE 1=1  AND wp_posts.post_type = 'post' AND (wp_posts.post_status = 'publish')  ORDER BY wp_posts.post_date DESC LIMIT 51, 17
  94.  
  95. # Mon Oct 17 01:33:59 2011
  96. # Query_time: 2.655076  Lock_time: 1.144795 Rows_sent: 1  Rows_examined: 1
  97. use tollabor_wrd2;
  98. SELECT   wp_posts.* FROM wp_posts  WHERE 1=1  AND wp_posts.post_type = 'post' AND (wp_posts.post_status = 'publish')  ORDER BY wp_posts.post_date DESC LIMIT 0, 10
  99.  
  100. # Mon Oct 17 01:37:55 2011
  101. # Query_time: 6.015999  Lock_time: 0.018962 Rows_sent: 10  Rows_examined: 37
  102. use tollabor_armedia;
  103. SELECT SQL_CALC_FOUND_ROWS  wp_posts.* FROM wp_posts  WHERE 1=1  AND wp_posts.post_type = 'post' AND ((  (  (  ( 1=1 )  )  )  ) AND wp_posts.post_status = 'publish')  ORDER BY wp_posts.post_date DESC LIMIT 0, 10
  104.  
  105. # Mon Oct 17 01:39:44 2011
  106. # Query_time: 6.223136  Lock_time: 0.000218 Rows_sent: 1  Rows_examined: 22
  107. use tollabor_3areda;
  108. SELECT post_modified_gmt FROM wp_posts WHERE post_status = 'publish' AND post_type IN ('post', 'page', 'attachment') ORDER BY post_modified_gmt DESC LIMIT 1
  109.  
  110. # Mon Oct 17 01:39:51 2011
  111. # Query_time: 2.933817  Lock_time: 1.594476 Rows_sent: 1  Rows_examined: 1
  112. use tollabor_3areda;
  113. SELECT * from wp_petitions where `petition` = 21
  114.  
  115. # Mon Oct 17 01:39:54 2011
  116. # Query_time: 2.575465  Lock_time: 0.435048 Rows_sent: 2  Rows_examined: 4
  117. use tollabor_3areda;
  118. SELECT * FROM wp_petition_fields WHERE `petition` = '21' ORDER by ts
  119.  
  120.  
  121. # Mon Oct 17 01:41:20 2011
  122. # Query_time: 2.266775  Lock_time: 0.000120 Rows_sent: 25  Rows_examined: 25
  123. use tollabor_alrasid;
  124. SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (1694,1294,1303,1711,24)
  125.  
  126. # Mon Oct 17 01:41:51 2011
  127. # Query_time: 2.490808  Lock_time: 0.182153 Rows_sent: 7  Rows_examined: 7
  128. use tollabor_armedia;
  129. SELECT option_name, option_value FROM wp_options WHERE option_name LIKE 'scoper_%'
  130.  
  131. # Mon Oct 17 01:41:55 2011
  132. # Query_time: 3.149972  Lock_time: 0.736519 Rows_sent: 0  Rows_examined: 0
  133. use tollabor_armedia;
  134. SELECT option_value FROM wp_options WHERE option_name = 'sideposts_settings' LIMIT 1
  135.  
  136. # Mon Oct 17 01:42:13 2011
  137. # Query_time: 2.523493  Lock_time: 0.000100 Rows_sent: 1  Rows_examined: 13
  138. use tollabor_armedia;
  139. SELECT meta_id FROM wp_postmeta WHERE meta_key = 'views' AND post_id = 491
  140.  
  141. # Mon Oct 17 01:43:14 2011
  142. # Query_time: 4.364446  Lock_time: 3.218843 Rows_sent: 1  Rows_examined: 2
  143. use tollabor_armedia;
  144. SELECT   wp_posts.* FROM wp_posts  WHERE 1=1  AND (   ( wp_posts.post_status = 'publish' AND (  (  (  ( 1=1 )  )  )  ) ) OR  ( wp_posts.post_status = 'future' AND (  (  (  ( 1=2 )  )  )  ) ) )  AND YEAR(wp_posts.post_date)='2011' AND MONTH(wp_posts.post_date)='3' AND wp_posts.post_name = 'eyal-zisser-on-shams-radio' AND wp_posts.post_type = 'post'  ORDER BY wp_posts.post_date DESC
  145.  
  146. # Mon Oct 17 01:43:21 2011
  147. # Query_time: 4.539279  Lock_time: 0.000133 Rows_sent: 10  Rows_examined: 10
  148. use tollabor_armedia;
  149. SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (470)
  150.  
  151. # Mon Oct 17 01:43:33 2011
  152. # Query_time: 12.449571  Lock_time: 0.088203 Rows_sent: 1  Rows_examined: 1
  153. use tollabor_armedia;
  154. SELECT p.* FROM wp_posts AS p  WHERE 1=1 AND p.post_date < '2011-03-29 13:33:49' AND p.post_type = 'post' AND (  (  (  ( 1=1 )  )  )  ) AND p.post_status = 'publish'  ORDER BY p.post_date DESC LIMIT 1
  155.  
  156. # Mon Oct 17 01:43:35 2011
  157. # Query_time: 6.554455  Lock_time: 4.906086 Rows_sent: 1  Rows_examined: 8
  158. use tollabor_alrasid;
  159. SELECT meta_id FROM wp_postmeta WHERE meta_key = 'views' AND post_id = 1402
  160.  
  161. # Mon Oct 17 01:43:35 2011
  162. # Query_time: 6.556216  Lock_time: 4.907137 Rows_sent: 1  Rows_examined: 8
  163. SELECT meta_id FROM wp_postmeta WHERE meta_key = 'views' AND post_id = 1402
  164.  
  165. # Mon Oct 17 01:43:39 2011
  166. # Query_time: 4.881463  Lock_time: 0.000226 Rows_sent: 19  Rows_examined: 19
  167. use tollabor_armedia;
  168. SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (194,123)
  169.  
  170. # Mon Oct 17 01:43:39 2011
  171. # Query_time: 4.105930  Lock_time: 0.000110 Rows_sent: 0  Rows_examined: 8
  172. use tollabor_alrasid;
  173. UPDATE `wp_postmeta` SET `meta_value` = '5748' WHERE `post_id` = '1402' AND `meta_key` = 'views'
  174.  
  175. # Mon Oct 17 01:43:39 2011
  176. # Query_time: 4.107718  Lock_time: 0.751701 Rows_sent: 0  Rows_examined: 8
  177. use tollabor_alrasid;
  178. UPDATE `wp_postmeta` SET `meta_value` = '5748' WHERE `post_id` = '1402' AND `meta_key` = 'views'
  179.  
  180. # Mon Oct 17 01:49:14 2011
  181. # Query_time: 4.087929  Lock_time: 0.000175 Rows_sent: 5  Rows_examined: 72
  182. use tollabor_alrasidcinema;
  183. SELECT DISTINCT post_author, COUNT(ID) AS count FROM wp_posts WHERE post_type = "post" AND (post_status = 'publish') GROUP BY post_author
  184.  
  185. # Mon Oct 17 01:50:48 2011
  186. # Query_time: 3.513772  Lock_time: 0.000161 Rows_sent: 12  Rows_examined: 70
  187. use tollabor_armedia;
  188. SELECT SQL_CALC_FOUND_ROWS  wp_posts.* FROM wp_posts  INNER JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id) WHERE 1=1  AND ( wp_term_relationships.term_taxonomy_id IN (4) ) AND wp_posts.post_type = 'post' AND ((  (  (  ( 1=1 )  )  )  ) AND wp_posts.post_status = 'publish') GROUP BY wp_posts.ID ORDER BY wp_posts.post_date DESC LIMIT 0, 12
  189.  
  190. # Mon Oct 17 01:55:04 2011
  191. # Query_time: 2.487180  Lock_time: 0.000196 Rows_sent: 1  Rows_examined: 1
  192. use tollabor_i3blog;
  193. SHOW TABLES LIKE 'wp_ti_audio_playlist_manager'
  194.  
  195.  
  196. # Mon Oct 17 00:04:47 2011
  197. # Query_time: 4.427052  Lock_time: 2.250982 Rows_sent: 154  Rows_examined: 185
  198. use tollabor_wrd2;
  199. SELECT option_name, option_value FROM wp_options WHERE autoload = 'yes'
  200.  
  201. # Mon Oct 17 00:07:22 2011
  202. # Query_time: 2.331575  Lock_time: 0.000149 Rows_sent: 0  Rows_examined: 0
  203. use tollabor_alrasidcinema;
  204. SELECT option_value FROM wp_options WHERE option_name = 'akismet_comment_nonce' LIMIT 1
  205.  
  206. # Mon Oct 17 00:08:34 2011
  207. # Query_time: 3.618045  Lock_time: 1.934180 Rows_sent: 154  Rows_examined: 185
  208. use tollabor_wrd2;
  209. SELECT option_name, option_value FROM wp_options WHERE autoload = 'yes'
  210.  
  211. # Mon Oct 17 00:08:40 2011
  212. # Query_time: 3.215170  Lock_time: 1.396382 Rows_sent: 1  Rows_examined: 1
  213. use tollabor_wrd2;
  214. SELECT * FROM wp_users WHERE ID = 1 LIMIT 1
  215.  
  216. # Mon Oct 17 00:08:49 2011
  217. # Query_time: 2.547618  Lock_time: 0.799247 Rows_sent: 1  Rows_examined: 1
  218. use tollabor_wrd2;
  219. SELECT * FROM wp_comments  WHERE comment_approved = '1' ORDER BY comment_date_gmt DESC LIMIT 5
  220.  
  221. # Mon Oct 17 00:14:12 2011
  222. # Query_time: 7.350614  Lock_time: 0.000141 Rows_sent: 1  Rows_examined: 82
  223. use tollabor_alrasidcinema;
  224. SELECT post_modified_gmt FROM wp_posts WHERE post_status = 'publish' AND post_type IN ('post', 'page', 'attachment') ORDER BY post_modified_gmt DESC LIMIT 1
  225.  
  226. # Mon Oct 17 00:14:29 2011
  227. # Query_time: 2.402928  Lock_time: 0.000151 Rows_sent: 1  Rows_examined: 22
  228. use tollabor_3areda;
  229. SELECT post_modified_gmt FROM wp_posts WHERE post_status = 'publish' AND post_type IN ('post', 'page', 'attachment') ORDER BY post_modified_gmt DESC LIMIT 1
  230.  
  231. # Mon Oct 17 00:14:34 2011
  232. # Query_time: 3.634313  Lock_time: 0.000051 Rows_sent: 23  Rows_examined: 4585
  233. use tollabor_3areda;
  234. SELECT `name`,`comment`,`fields`,`keep_private` from wp_petition_signatures WHERE `confirm`='' AND `petition` = '21' ORDER BY `time`
  235.  
  236. # Mon Oct 17 00:29:33 2011
  237. # Query_time: 8.638294  Lock_time: 0.016929 Rows_sent: 17  Rows_examined: 165
  238. use tollabor_alrasid;
  239. SELECT SQL_CALC_FOUND_ROWS  wp_posts.* FROM wp_posts  WHERE 1=1  AND wp_posts.post_type = 'post' AND (wp_posts.post_status = 'publish')  ORDER BY wp_posts.post_date DESC LIMIT 0, 17
  240.  
  241. # Mon Oct 17 00:29:39 2011
  242. # Query_time: 2.471159  Lock_time: 0.000169 Rows_sent: 6  Rows_examined: 12
  243. use tollabor_3areda;
  244. SELECT * FROM wp_posts  WHERE (post_type = 'page' AND post_status = 'publish')     ORDER BY menu_order, post_title ASC
  245.  
  246. # Mon Oct 17 00:32:41 2011
  247. # Query_time: 2.941994  Lock_time: 1.824651 Rows_sent: 1  Rows_examined: 1
  248. use tollabor_alrasid;
  249. SELECT * FROM wp_posts WHERE ID = 1540 LIMIT 1
  250.  
  251. # Mon Oct 17 00:32:48 2011
  252. # Query_time: 2.549629  Lock_time: 0.466555 Rows_sent: 0  Rows_examined: 0
  253. use tollabor_alrasid;
  254. SELECT t.*, tt.*, tr.object_id FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON tt.term_id = t.term_id INNER JOIN wp_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN ('category', 'post_tag', 'post_format') AND tr.object_id IN (1461) ORDER BY t.name ASC
  255.  
  256. # Mon Oct 17 00:37:18 2011
  257. # Query_time: 2.865584  Lock_time: 0.170372 Rows_sent: 17  Rows_examined: 140
  258. use tollabor_alrasid;
  259. SELECT SQL_CALC_FOUND_ROWS  wp_posts.* FROM wp_posts  INNER JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id) WHERE 1=1  AND ( wp_term_relationships.term_taxonomy_id IN (3) ) AND wp_posts.post_type = 'post' AND (wp_posts.post_status = 'publish') GROUP BY wp_posts.ID ORDER BY wp_posts.post_date DESC LIMIT 0, 17
  260.  
  261. # Mon Oct 17 00:37:22 2011
  262. # Query_time: 2.208194  Lock_time: 0.613201 Rows_sent: 1  Rows_examined: 1
  263. use tollabor_alrasid;
  264. SELECT p.* FROM wp_posts AS p  WHERE p.post_date < '2011-06-19 05:08:50' AND p.post_type = 'page' AND p.post_status = 'publish'  ORDER BY p.post_date DESC LIMIT 1
  265.  
  266. # Mon Oct 17 00:38:32 2011
  267. # Query_time: 2.304840  Lock_time: 0.685009 Rows_sent: 0  Rows_examined: 1
  268. use tollabor_armedia;
  269. UPDATE `wp_options` SET `option_value` = 'a:10:{i:1318833371;a:1:{s:16:\"w3_pgcache_prime\";a:1:{s:32:\"40cd750bba9870f18aada2478b24840a\";a:3:{s:8:\"schedule\";s:16:\"w3_pgcache_prime\";s:4:\"args\";a:0:{}s:8:\"interval\";i:907;}}}i:1318834120;a:1:{s:16:\"w3_pgcache_prime\";a:1:{s:32:\"d63aca0b7e6237c7964320bd7fc95644\";a:2:{s:8:\"schedule\";b:0;s:4:\"args\";a:1:{i:0;i:7;}}}}i:1318834225;a:1:{s:18:\"w3_pgcache_cleanup\";a:1:{s:32:\"40cd750bba9870f18aada2478b24840a\";a:3:{s:8:\"schedule\";s:18:\"w3_pgcache_cleanup\";s:4:\"args\";a:0:{}s:8:\"interval\";i:3600;}}}i:1318834278;a:1:{s:16:\"w3_pgcache_prime\";a:1:{s:32:\"40cd750bba9870f18aada2478b24840a\";a:3:{s:8:\"schedule\";s:16:\"w3_pgcache_prime\";s:4:\"args\";a:0:{}s:8:\"interval\";i:907;}}}i:1318847745;a:3:{s:16:\"wp_version_check\";a:1:{s:32:\"40cd750bba9870f18aada2478b24840a\";a:3:{s:8:\"schedule\";s:10:\"twicedaily\";s:4:\"args\";a:0:{}s:8:\"interval\";i:43200;}}s:17:\"wp_update_plugins\";a:1:{s:32:\"40cd750bba9870f18aada2478b24840a\";a:3:{s:8:\"schedule\";s:10:\"twicedaily\";s:4:\"args\";a:0:{}s:8:\"interval\";i:43200;}}s:16:\"wp_update_themes\";a:1:{s:32:\"40cd750bba9870f18aada2478b24840a\";a:3:{s:8:\"schedule\";s:10:\"twicedaily\";s:4:\"args\";a:0:{}s:8:\"interval\";i:43200;}}}i:1318857905;a:1:{s:19:\"wp_scheduled_delete\";a:1:{s:32:\"40cd750bba9870f18aada2478b24840a\";a:3:{s:8:\"schedule\";s:5:\"daily\";s:4:\"args\";a:0:{}s:8:\"interval\";i:86400;}}}i:1318899359;a:1:{s:21:\"dbmanager_cron_backup\";a:1:{s:32:\"40cd750bba9870f18aada2478b24840a\";a:3:{s:8:\"schedule\";s:16:\"dbmanager_backup\";s:4:\"args\";a:0:{}s:8:\"interval\";i:1209600;}}}i:1318904594;a:1:{s:24:\"akismet_scheduled_delete\";a:1:{s:32:\"40cd750bba9870f18aada2478b24840a\";a:3:{s:8:\"schedule\";s:5:\"daily\";s:4:\"args\";a:0:{}s:8:\"interval\";i:86400;}}}i:1318985759;a:1:{s:23:\"dbmanager_cron_optimize\";a:1:{s:32:\"40cd750bba9870f18aada2478b24840a\";a:3:{s:8:\"schedule\";s:18:\"dbmanager_optimize\";s:4:\"args\";a:0:{}s:8:\"interval\";i:259200;}}}s:7:\"version\";i:2;}' WHERE `option_name` = 'cron'
  270.  
  271. # Mon Oct 17 00:38:32 2011
  272. # Query_time: 2.451985  Lock_time: 0.830378 Rows_sent: 2  Rows_examined: 4
  273. use tollabor_3areda;
  274. SELECT name,hide FROM wp_petition_fields WHERE petition = '16' ORDER BY ts
  275.  
  276. # Mon Oct 17 00:40:06 2011
  277. # Query_time: 2.354155  Lock_time: 0.654863 Rows_sent: 1  Rows_examined: 1
  278. use tollabor_alrasid;
  279. SELECT wp_term_taxonomy.term_id
  280.   FROM wp_term_taxonomy
  281.   INNER JOIN wp_terms USING (term_id)
  282.   WHERE taxonomy = 'category'
  283.   AND wp_terms.slug IN ('personal')
  284.  
  285. # Mon Oct 17 00:40:06 2011
  286. # Query_time: 3.667402  Lock_time: 1.425354 Rows_sent: 69  Rows_examined: 69
  287. use tollabor_alrasid;
  288. SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (1923,1891,1735,1526,1525,1523,1353,1324,1288,1281,1280,607,52,109)
  289.  
  290. # Mon Oct 17 00:40:11 2011
  291. # Query_time: 4.263413  Lock_time: 0.003870 Rows_sent: 17  Rows_examined: 306
  292. use tollabor_alrasid;
  293. SELECT SQL_CALC_FOUND_ROWS  wp_posts.* FROM wp_posts  INNER JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id) WHERE 1=1  AND ( wp_term_relationships.term_taxonomy_id IN (1) ) AND wp_posts.post_type = 'post' AND (wp_posts.post_status = 'publish') GROUP BY wp_posts.ID ORDER BY wp_posts.post_date DESC LIMIT 0, 17
  294.  
  295. # Mon Oct 17 00:44:02 2011
  296. # Query_time: 2.565829  Lock_time: 0.006326 Rows_sent: 9  Rows_examined: 62
  297. use tollabor_alrasidcinema;
  298. SELECT SQL_CALC_FOUND_ROWS  wp_posts.* FROM wp_posts  WHERE 1=1  AND wp_posts.post_type = 'post' AND (wp_posts.post_status = 'publish')  ORDER BY wp_posts.post_date DESC LIMIT 0, 9
  299.  
  300. # Mon Oct 17 00:46:39 2011
  301. # Query_time: 3.554080  Lock_time: 0.536808 Rows_sent: 5  Rows_examined: 165
  302. use tollabor_alrasid;
  303. SELECT SQL_CALC_FOUND_ROWS  wp_posts.* FROM wp_posts  WHERE 1=1  AND YEAR(wp_posts.post_date)='2011' AND MONTH(wp_posts.post_date)='10' AND wp_posts.post_type = 'post' AND (wp_posts.post_status = 'publish')  ORDER BY wp_posts.post_date DESC LIMIT 0, 17
  304.  
  305. # Mon Oct 17 00:46:42 2011
  306. # Query_time: 2.610583  Lock_time: 1.079699 Rows_sent: 15  Rows_examined: 75
  307. use tollabor_alrasid;
  308. SELECT t.*, tt.*, tr.object_id FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON tt.term_id = t.term_id INNER JOIN wp_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN ('category', 'post_tag', 'post_format') AND tr.object_id IN (1996, 2003, 1999, 1985, 1982) ORDER BY t.name ASC
  309.  
  310. # Mon Oct 17 00:52:46 2011
  311. # Query_time: 2.740619  Lock_time: 0.098695 Rows_sent: 1  Rows_examined: 1
  312. use tollabor_armedia;
  313. SELECT option_value FROM wp_options WHERE option_name = 'diff_posts_per_page' LIMIT 1
  314.  
  315. # Mon Oct 17 00:52:46 2011
  316. # Query_time: 2.733804  Lock_time: 0.080206 Rows_sent: 12  Rows_examined: 37
  317. use tollabor_armedia;
  318. SELECT SQL_CALC_FOUND_ROWS  wp_posts.* FROM wp_posts  WHERE 1=1  AND wp_posts.post_type = 'post' AND ((  (  (  ( 1=1 )  )  )  ) AND wp_posts.post_status = 'publish')  ORDER BY wp_posts.post_date DESC LIMIT 0, 12
  319.  
  320. # Mon Oct 17 00:55:48 2011
  321. # Query_time: 3.801893  Lock_time: 0.000125 Rows_sent: 5  Rows_examined: 72
  322. use tollabor_alrasidcinema;
  323. SELECT DISTINCT post_author, COUNT(ID) AS count FROM wp_posts WHERE post_type = "post" AND (post_status = 'publish') GROUP BY post_author
  324.  
  325. # Mon Oct 17 00:57:14 2011
  326. # Query_time: 3.164630  Lock_time: 2.161079 Rows_sent: 0  Rows_examined: 0
  327. use tollabor_alrasid;
  328. SELECT option_value FROM wp_options WHERE option_name = 'gallery_plus_link2full' LIMIT 1
  329.  
  330. # Mon Oct 17 00:57:18 2011
  331. # Query_time: 2.501671  Lock_time: 1.317981 Rows_sent: 1  Rows_examined: 2
  332. use tollabor_alrasid;
  333. SELECT   wp_posts.* FROM wp_posts  WHERE 1=1  AND YEAR(wp_posts.post_date)='2009' AND MONTH(wp_posts.post_date)='6' AND wp_posts.post_name = 'marriage_vacation' AND wp_posts.post_type = 'post'  ORDER BY wp_posts.post_date DESC
  334.  
  335. # Mon Oct 17 00:57:26 2011
  336. # Query_time: 3.098790  Lock_time: 0.925768 Rows_sent: 1  Rows_examined: 1
  337. use tollabor_alrasid;
  338. SELECT p.* FROM wp_posts AS p  WHERE p.post_date > '2009-06-24 13:18:20' AND p.post_type = 'post' AND p.post_status = 'publish'  ORDER BY p.post_date ASC LIMIT 1
  339.  
  340. # Mon Oct 17 00:58:20 2011
  341. # Query_time: 14.023221  Lock_time: 0.000159 Rows_sent: 17  Rows_examined: 165
  342. use tollabor_alrasid;
  343. SELECT SQL_CALC_FOUND_ROWS  wp_posts.* FROM wp_posts  WHERE 1=1  AND wp_posts.post_type = 'post' AND (wp_posts.post_status = 'publish')  ORDER BY wp_posts.post_date DESC LIMIT 0, 17
  344.  
  345.  
  346. # Sun Oct 16 23:12:31 2011
  347. # Query_time: 2.113970  Lock_time: 0.000086 Rows_sent: 0  Rows_examined: 0
  348. use tollabor_alrasid;
  349. SELECT option_value FROM wp_options WHERE option_name = 'pppm_pt_head_site' LIMIT 1
  350.  
  351. # Sun Oct 16 23:15:41 2011
  352. # Query_time: 2.317332  Lock_time: 0.143581 Rows_sent: 0  Rows_examined: 0
  353. use tollabor_alrasidcinema;
  354. SELECT option_value FROM wp_options WHERE option_name = 'pagelist_settings' LIMIT 1
  355.  
  356. # Sun Oct 16 23:18:25 2011
  357. # Query_time: 4.619100  Lock_time: 2.347249 Rows_sent: 1  Rows_examined: 2
  358. use tollabor_alrasid;
  359. SELECT   wp_posts.* FROM wp_posts  WHERE 1=1  AND YEAR(wp_posts.post_date)='2007' AND MONTH(wp_posts.post_date)='12' AND wp_posts.post_name = 'worlds_biggest_hole' AND wp_posts.post_type = 'post'  ORDER BY wp_posts.post_date DESC
  360.  
  361. # Sun Oct 16 23:30:30 2011
  362. # Query_time: 2.506950  Lock_time: 0.062752 Rows_sent: 1  Rows_examined: 1
  363. use tollabor_3areda;
  364. SHOW COLUMNS FROM wp_petition_signatures LIKE 'fields'
  365.  
  366. # Sun Oct 16 23:42:52 2011
  367. # Query_time: 8.400874  Lock_time: 2.838341 Rows_sent: 1  Rows_examined: 2
  368. use tollabor_alrasidcinema;
  369. SELECT   wp_posts.* FROM wp_posts  WHERE 1=1  AND YEAR(wp_posts.post_date)='2011' AND MONTH(wp_posts.post_date)='8' AND DAYOFMONTH(wp_posts.post_date)='8' AND wp_posts.post_name = 'ajami-2010' AND wp_posts.post_type = 'post'  ORDER BY wp_posts.post_date DESC
  370.  
  371. # Sun Oct 16 23:44:14 2011
  372. # Query_time: 11.784507  Lock_time: 0.050252 Rows_sent: 1  Rows_examined: 206
  373. use tollabor_alrasid;
  374. SELECT post_modified_gmt FROM wp_posts WHERE post_status = 'publish' AND post_type IN ('post', 'page', 'attachment') ORDER BY post_modified_gmt DESC LIMIT 1
  375.  
  376. # Sun Oct 16 23:48:40 2011
  377. # Query_time: 2.701157  Lock_time: 0.183363 Rows_sent: 1  Rows_examined: 1
  378. use tollabor_alrasidcinema;
  379. SELECT p.* FROM wp_posts AS p  WHERE p.post_date < '2011-10-12 14:45:29' AND p.post_type = 'post' AND p.post_status = 'publish'  ORDER BY p.post_date DESC LIMIT 1
  380.  
  381. # Sun Oct 16 23:48:50 2011
  382. # Query_time: 3.593272  Lock_time: 0.961085 Rows_sent: 1  Rows_examined: 261
  383. use tollabor_alrasidcinema;
  384. SELECT rating_username, rating_rating, rating_ip FROM wp_ratings WHERE rating_postid = 1493
  385.  
  386. # Sun Oct 16 23:48:50 2011
  387. # Query_time: 4.295367  Lock_time: 1.272591 Rows_sent: 0  Rows_examined: 0
  388. use tollabor_alrasidcinema;
  389. SELECT option_value FROM wp_options WHERE option_name = 'pagelist_settings' LIMIT 1
  390.  
  391. # Sun Oct 16 23:48:57 2011
  392. # Query_time: 3.588442  Lock_time: 2.193939 Rows_sent: 0  Rows_examined: 1
  393. use tollabor_alrasidcinema;
  394. UPDATE `wp_options` SET `option_value` = 'a:12:{i:1318830634;a:1:{s:18:\"w3_pgcache_cleanup\";a:1:{s:32:\"40cd750bba9870f18aada2478b24840a\";a:3:{s:8:\"schedule\";s:18:\"w3_pgcache_cleanup\";s:4:\"args\";a:0:{}s:8:\"interval\";i:3600;}}}i:1318830659;a:1:{s:16:\"w3_pgcache_prime\";a:1:{s:32:\"40cd750bba9870f18aada2478b24840a\";a:3:{s:8:\"schedule\";s:16:\"w3_pgcache_prime\";s:4:\"args\";a:0:{}s:8:\"interval\";i:907;}}}i:1318831440;a:1:{s:16:\"w3_pgcache_prime\";a:1:{s:32:\"d63aca0b7e6237c7964320bd7fc95644\";a:2:{s:8:\"schedule\";b:0;s:4:\"args\";a:1:{i:0;i:7;}}}}i:1318833968;a:1:{s:16:\"wp_update_themes\";a:1:{s:32:\"40cd750bba9870f18aada2478b24840a\";a:3:{s:8:\"schedule\";s:10:\"twicedaily\";s:4:\"args\";a:0:{}s:8:\"interval\";i:43200;}}}i:1318843334;a:1:{s:17:\"wp_update_plugins\";a:1:{s:32:\"40cd750bba9870f18aada2478b24840a\";a:3:{s:8:\"schedule\";s:10:\"twicedaily\";s:4:\"args\";a:0:{}s:8:\"interval\";i:43200;}}}i:1318847559;a:1:{s:16:\"wp_version_check\";a:1:{s:32:\"40cd750bba9870f18aada2478b24840a\";a:3:{s:8:\"schedule\";s:10:\"twicedaily\";s:4:\"args\";a:0:{}s:8:\"interval\";i:43200;}}}i:1318849298;a:1:{s:24:\"akismet_scheduled_delete\";a:1:{s:32:\"40cd750bba9870f18aada2478b24840a\";a:3:{s:8:\"schedule\";s:5:\"daily\";s:4:\"args\";a:0:{}s:8:\"interval\";i:86400;}}}i:1318875976;a:1:{s:19:\"wp_scheduled_delete\";a:1:{s:32:\"40cd750bba9870f18aada2478b24840a\";a:3:{s:8:\"schedule\";s:5:\"daily\";s:4:\"args\";a:0:{}s:8:\"interval\";i:86400;}}}i:1318899383;a:1:{s:21:\"dbmanager_cron_backup\";a:1:{s:32:\"40cd750bba9870f18aada2478b24840a\";a:3:{s:8:\"schedule\";s:16:\"dbmanager_backup\";s:4:\"args\";a:0:{}s:8:\"interval\";i:1209600;}}}i:1318950834;a:1:{s:19:\"publish_future_post\";a:1:{s:32:\"b92ae6a519d57a812bf09a7d229675e0\";a:2:{s:8:\"schedule\";b:0;s:4:\"args\";a:1:{i:0;i:1494;}}}}i:1318985783;a:1:{s:23:\"dbmanager_cron_optimize\";a:1:{s:32:\"40cd750bba9870f18aada2478b24840a\";a:3:{s:8:\"schedule\";s:18:\"dbmanager_optimize\";s:4:\"args\";a:0:{}s:8:\"interval\";i:259200;}}}s:7:\"version\";i:2;}' WHERE `option_name` = 'cron'
  395.  
  396. # Sun Oct 16 23:48:57 2011
  397. # Query_time: 3.810518  Lock_time: 2.275532 Rows_sent: 10  Rows_examined: 50
  398. use tollabor_alrasidcinema;
  399. SELECT t.*, tt.*, tr.object_id FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON tt.term_id = t.term_id INNER JOIN wp_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN ('category', 'post_tag', 'post_format') AND tr.object_id IN (1144, 48, 1207, 1397) ORDER BY t.name ASC
  400.  
  401. # Sun Oct 16 23:54:28 2011
  402. # Query_time: 3.738299  Lock_time: 1.828356 Rows_sent: 541  Rows_examined: 604
  403. use tollabor_3areda;
  404. SELECT option_name, option_value FROM wp_options WHERE autoload = 'yes'
  405.  
  406. # Sun Oct 16 23:55:18 2011
  407. # Query_time: 6.053033  Lock_time: 0.000080 Rows_sent: 12  Rows_examined: 37
  408. use tollabor_armedia;
  409. SELECT SQL_CALC_FOUND_ROWS  wp_posts.* FROM wp_posts  WHERE 1=1  AND wp_posts.post_type = 'post' AND ((  (  (  ( 1=1 )  )  )  ) AND wp_posts.post_status = 'publish')  ORDER BY wp_posts.post_date DESC LIMIT 0, 12
  410.  
  411.  
  412. # Sun Oct 16 22:06:18 2011
  413. # Query_time: 2.707279  Lock_time: 0.000138 Rows_sent: 48  Rows_examined: 48
  414. use tollabor_alrasidcinema;
  415. SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (35,49,37,58)
  416.  
  417. # Sun Oct 16 22:53:52 2011
  418. # Query_time: 3.419119  Lock_time: 0.000147 Rows_sent: 9  Rows_examined: 62
  419. use tollabor_alrasidcinema;
  420. SELECT SQL_CALC_FOUND_ROWS  wp_posts.* FROM wp_posts  WHERE 1=1  AND wp_posts.post_type = 'post' AND (wp_posts.post_status = 'publish')  ORDER BY wp_posts.post_date DESC LIMIT 0, 9
  421.  
  422.  
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!