Current time: 09-19-2020, 04:04 AM Hello There, Guest! (LoginRegister)

Post Reply 
 
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Help and advice greatly appreciated.
11-17-2011, 04:02 PM (This post was last modified: 11-17-2011 04:06 PM by mylemonhead.)
Post: #3
RE: Help and advice greatly appreciated.
Hi Preenam, thanks for your time. Ive added more debug info and the numbers are confusing me big time Huh Where do i look for info to find which db queries are the culprits.

Code:
<!-- W3 Total Cache: Db cache debug info:

Engine:             disk: basic

Total queries:      139

Cached queries:     112

Total query time:   0.9348

SQL info:

    # | Time (s) |    Caching (Reject reason)     |   Status   | Data size (b) | Query

    1 |   0.0006 |  disabled (Query is rejected)  | not cached |             0 | SHOW TABLES LIKE 'wp_dynamic_widgets'

    2 |   0.0008 |            enabled             | not cached |         10498 | SELECT   wp_posts.* FROM wp_posts  WHERE 1=1  AND wp_posts.post_name = 'nikon-24-70mm-f2-8g-ed-af-s-nikkor-wide-angle-zoom-lens-reviews' AND wp_posts.post_type = 'post'  ORDER BY wp_posts.post_date DESC

    3 |   0.0001 |            enabled             |   cached   |           503 | SELECT `post_parent` FROM wp_posts WHERE ID = 12807 LIMIT 1

    4 |   0.0009 |            enabled             | not cached |           789 | SELECT url FROM wp_cloakPig_cloaks WHERE cloak='nikon-24-70mm-f2-8g-ed-af-s-nikkor-wide-angle-zoom-lens-reviews' OR cloak='/nikon-24-70mm-f2-8g-ed-af-s-nikkor-wide-angle-zoom-lens-reviews' OR cloak='nikon-24-70mm-f2-8g-ed-af-s-nikkor-wide-angle-zoom-lens-reviews/' OR cloak='/nikon-24-70mm-f2-8g-ed-af-s-nikkor-wide-angle-zoom-lens-reviews/'

    5 |   0.0002 |            enabled             |   cached   |          7147 | SELECT * FROM wp_posts WHERE ID = 12807 LIMIT 1

    6 |   0.0002 |            enabled             |   cached   |         10761 | 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 ASC LIMIT 0, 1

    7 |   0.0035 |            enabled             | not cached |          6395 | 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 ('post_tag') AND tr.object_id IN (2590) ORDER BY t.name ASC

    8 |   0.0009 |  disabled (Query is rejected)  | not cached |             0 | DELETE FROM wp_t09_sb_jobs WHERE done=1

    9 |   0.0001 |            enabled             |   cached   |           513 | SELECT MAX(id) FROM wp_t09_sb_log

   10 |   0.0001 |  disabled (Query is rejected)  | not cached |             0 | DELETE FROM wp_t09_sb_log WHERE id<15785

   11 |   0.0002 |            enabled             |   cached   |         19202 | SELECT field,`data` FROM wp_t09_sb WHERE pageid=0

   12 |   0.0003 |  disabled (Query is rejected)  | not cached |             0 | UPDATE wp_t09_sb SET `data`='1' WHERE  pageid=0 AND field='nonce'

   13 |   0.0002 |            enabled             |   cached   |          3589 | SELECT pageid FROM wp_t09_sb WHERE field='post_random' AND data='1' GROUP BY pageid

   14 |   0.0001 |            enabled             |   cached   |          1741 | SELECT `field`,`data` FROM wp_t09_sb WHERE pageid=10

   15 |   0.0001 |            enabled             |   cached   |          1665 | SELECT `field`,`data` FROM wp_t09_sb WHERE pageid=12

   16 |   0.0001 |            enabled             |   cached   |          1664 | SELECT `field`,`data` FROM wp_t09_sb WHERE pageid=14

   17 |   0.0001 |            enabled             |   cached   |          1659 | SELECT `field`,`data` FROM wp_t09_sb WHERE pageid=16

   18 |   0.0001 |            enabled             |   cached   |          1734 | SELECT `field`,`data` FROM wp_t09_sb WHERE pageid=18

   19 |   0.0001 |            enabled             |   cached   |          1735 | SELECT `field`,`data` FROM wp_t09_sb WHERE pageid=20

   20 |   0.0001 |            enabled             |   cached   |          1681 | SELECT `field`,`data` FROM wp_t09_sb WHERE pageid=22

   21 |   0.0001 |            enabled             |   cached   |          1683 | SELECT `field`,`data` FROM wp_t09_sb WHERE pageid=24

   22 |   0.0001 |            enabled             |   cached   |          1668 | SELECT `field`,`data` FROM wp_t09_sb WHERE pageid=36

   23 |   0.0001 |            enabled             |   cached   |          1667 | SELECT `field`,`data` FROM wp_t09_sb WHERE pageid=40

   24 |   0.0001 |            enabled             |   cached   |          1736 | SELECT `field`,`data` FROM wp_t09_sb WHERE pageid=46

   25 |   0.0001 |            enabled             |   cached   |          1735 | SELECT `field`,`data` FROM wp_t09_sb WHERE pageid=48

   26 |   0.0001 |            enabled             |   cached   |          1665 | SELECT `field`,`data` FROM wp_t09_sb WHERE pageid=62

   27 |   0.0001 |            enabled             |   cached   |          1663 | SELECT `field`,`data` FROM wp_t09_sb WHERE pageid=64

   28 |   0.0001 |            enabled             |   cached   |          1668 | SELECT `field`,`data` FROM wp_t09_sb WHERE pageid=66

   29 |   0.0001 |            enabled             |   cached   |          1668 | SELECT `field`,`data` FROM wp_t09_sb WHERE pageid=68

   30 |   0.0001 |            enabled             |   cached   |          1667 | SELECT `field`,`data` FROM wp_t09_sb WHERE pageid=70

   31 |   0.0001 |            enabled             |   cached   |          1667 | SELECT `field`,`data` FROM wp_t09_sb WHERE pageid=72

   32 |   0.0001 |            enabled             |   cached   |          1669 | SELECT `field`,`data` FROM wp_t09_sb WHERE pageid=76

   33 |   0.0001 |            enabled             |   cached   |          1747 | SELECT `field`,`data` FROM wp_t09_sb WHERE pageid=78

   34 |   0.0001 |            enabled             |   cached   |          1740 | SELECT `field`,`data` FROM wp_t09_sb WHERE pageid=80

   35 |   0.0001 |            enabled             |   cached   |          1750 | SELECT `field`,`data` FROM wp_t09_sb WHERE pageid=82

   36 |   0.0001 |            enabled             |   cached   |          1750 | SELECT `field`,`data` FROM wp_t09_sb WHERE pageid=84

   37 |   0.0001 |            enabled             |   cached   |          1748 | SELECT `field`,`data` FROM wp_t09_sb WHERE pageid=86

   38 |   0.0001 |            enabled             |   cached   |          1748 | SELECT `field`,`data` FROM wp_t09_sb WHERE pageid=88

   39 |   0.0001 |            enabled             |   cached   |          1752 | SELECT `field`,`data` FROM wp_t09_sb WHERE pageid=90

   40 |   0.0001 |            enabled             |   cached   |          1683 | SELECT `field`,`data` FROM wp_t09_sb WHERE pageid=92

   41 |   0.0001 |            enabled             |   cached   |          1690 | SELECT `field`,`data` FROM wp_t09_sb WHERE pageid=94

   42 |   0.0001 |            enabled             |   cached   |          1662 | SELECT `field`,`data` FROM wp_t09_sb WHERE pageid=112

   43 |   0.0001 |            enabled             |   cached   |          1660 | SELECT `field`,`data` FROM wp_t09_sb WHERE pageid=114

   44 |   0.0001 |            enabled             |   cached   |          1662 | SELECT `field`,`data` FROM wp_t09_sb WHERE pageid=116

   45 |   0.0001 |            enabled             |   cached   |          1661 | SELECT `field`,`data` FROM wp_t09_sb WHERE pageid=118

   46 |   0.0001 |            enabled             |   cached   |          1662 | SELECT `field`,`data` FROM wp_t09_sb WHERE pageid=120

   47 |   0.0001 |            enabled             |   cached   |          1657 | SELECT `field`,`data` FROM wp_t09_sb WHERE pageid=122

   48 |   0.0001 |            enabled             |   cached   |          1659 | SELECT `field`,`data` FROM wp_t09_sb WHERE pageid=124

   49 |   0.0001 |            enabled             |   cached   |          1666 | SELECT `field`,`data` FROM wp_t09_sb WHERE pageid=140

   50 |   0.0001 |            enabled             |   cached   |          1666 | SELECT `field`,`data` FROM wp_t09_sb WHERE pageid=142

   51 |   0.0001 |            enabled             |   cached   |          1665 | SELECT `field`,`data` FROM wp_t09_sb WHERE pageid=144

   52 |   0.0001 |            enabled             |   cached   |          1664 | SELECT `field`,`data` FROM wp_t09_sb WHERE pageid=146

   53 |   0.0001 |            enabled             |   cached   |          1666 | SELECT `field`,`data` FROM wp_t09_sb WHERE pageid=148

   54 |   0.0001 |            enabled             |   cached   |          1663 | SELECT `field`,`data` FROM wp_t09_sb WHERE pageid=150

   55 |   0.0001 |            enabled             |   cached   |          1660 | SELECT `field`,`data` FROM wp_t09_sb WHERE pageid=152

   56 |   0.0001 |            enabled             |   cached   |          1729 | SELECT `field`,`data` FROM wp_t09_sb WHERE pageid=164

   57 |   0.0001 |            enabled             |   cached   |          1730 | SELECT `field`,`data` FROM wp_t09_sb WHERE pageid=166

   58 |   0.0001 |            enabled             |   cached   |          1734 | SELECT `field`,`data` FROM wp_t09_sb WHERE pageid=168

   59 |   0.0001 |            enabled             |   cached   |          1734 | SELECT `field`,`data` FROM wp_t09_sb WHERE pageid=170

   60 |   0.0001 |            enabled             |   cached   |          1732 | SELECT `field`,`data` FROM wp_t09_sb WHERE pageid=172

   61 |   0.0001 |            enabled             |   cached   |          1733 | SELECT `field`,`data` FROM wp_t09_sb WHERE pageid=174

   62 |   0.0001 |            enabled             |   cached   |          1735 | SELECT `field`,`data` FROM wp_t09_sb WHERE pageid=176

   63 |   0.0001 |            enabled             |   cached   |          1736 | SELECT `field`,`data` FROM wp_t09_sb WHERE pageid=178

   64 |   0.0001 |            enabled             |   cached   |          1732 | SELECT `field`,`data` FROM wp_t09_sb WHERE pageid=180

   65 |   0.0001 |            enabled             |   cached   |          1735 | SELECT `field`,`data` FROM wp_t09_sb WHERE pageid=182

   66 |   0.0001 |            enabled             |   cached   |          1817 | SELECT `field`,`data` FROM wp_t09_sb WHERE pageid=184

   67 |   0.0001 |            enabled             |   cached   |          1824 | SELECT `field`,`data` FROM wp_t09_sb WHERE pageid=186

   68 |   0.0001 |            enabled             |   cached   |          1827 | SELECT `field`,`data` FROM wp_t09_sb WHERE pageid=188

   69 |   0.0001 |            enabled             |   cached   |          1733 | SELECT `field`,`data` FROM wp_t09_sb WHERE pageid=190

   70 |   0.0001 |            enabled             |   cached   |          1732 | SELECT `field`,`data` FROM wp_t09_sb WHERE pageid=192

   71 |   0.0001 |            enabled             |   cached   |          1729 | SELECT `field`,`data` FROM wp_t09_sb WHERE pageid=194

   72 |   0.0001 |            enabled             |   cached   |          1725 | SELECT `field`,`data` FROM wp_t09_sb WHERE pageid=196

   73 |   0.0001 |            enabled             |   cached   |          1727 | SELECT `field`,`data` FROM wp_t09_sb WHERE pageid=198

   74 |   0.0001 |            enabled             |   cached   |          1728 | SELECT `field`,`data` FROM wp_t09_sb WHERE pageid=200

   75 |   0.0001 |            enabled             |   cached   |          1736 | SELECT `field`,`data` FROM wp_t09_sb WHERE pageid=202

   76 |   0.0001 |            enabled             |   cached   |          1735 | SELECT `field`,`data` FROM wp_t09_sb WHERE pageid=204

   77 |   0.0001 |            enabled             |   cached   |          1732 | SELECT `field`,`data` FROM wp_t09_sb WHERE pageid=206

   78 |   0.0001 |            enabled             |   cached   |          1808 | SELECT `field`,`data` FROM wp_t09_sb WHERE pageid=210

   79 |   0.0001 |            enabled             |   cached   |          1736 | SELECT `field`,`data` FROM wp_t09_sb WHERE pageid=214

   80 |   0.0001 |            enabled             |   cached   |          1266 | SELECT id,string,accountid FROM wp_t09_sb_jobs WHERE done=0 LIMIT 0,1

   81 |   0.0002 |  disabled (Query is rejected)  | not cached |             0 | UPDATE wp_t09_sb_jobs SET done=1 WHERE id=17176

   82 |   0.0001 |            enabled             |   cached   |          1683 | SELECT `field`,`data` FROM wp_t09_sb WHERE pageid=92

   83 |   0.0001 |            enabled             |   cached   |          5689 | SELECT content FROM wp_wpr_templates WHERE type = 'amazon'

   84 |   0.0001 |            enabled             |   cached   |          5689 | SELECT content FROM wp_wpr_templates WHERE type = 'amazon'

   85 |   0.0001 |            enabled             |   cached   |          1384 | SELECT cloak,a,id FROM wp_cloakPig_cloaks WHERE url='http://www.linkconnector.com/traffic_affiliate.php?lc=054882037831004157&amp;lcpt=0&amp;lcpf=0'

   86 |   0.0001 |            enabled             |   cached   |          1499 | SELECT cloak,a,id FROM wp_cloakPig_cloaks WHERE url='http://www.amazon.com/Sigma-800mm-Ultra-Telephoto-Cameras/dp/B0000501QH%3FSubscriptionId%3DAKIAICA22YDS2RFDD3EA%26tag%3Dwideanglemacr-20%26linkCode%3Dxm2%26camp%3D2025%26creative%3D165953%26creativeASIN%3DB0000501Q​H'

   87 |   0.0001 |            enabled             |   cached   |          1499 | SELECT cloak,a,id FROM wp_cloakPig_cloaks WHERE url='http://www.amazon.com/Sigma-800mm-Ultra-Telephoto-Cameras/dp/B0000501QH%3FSubscriptionId%3DAKIAICA22YDS2RFDD3EA%26tag%3Dwideanglemacr-20%26linkCode%3Dxm2%26camp%3D2025%26creative%3D165953%26creativeASIN%3DB0000501Q​H'

   88 |   0.0001 |            enabled             |   cached   |          1499 | SELECT cloak,a,id FROM wp_cloakPig_cloaks WHERE url='http://www.amazon.com/Sigma-800mm-Ultra-Telephoto-Cameras/dp/B0000501QH%3FSubscriptionId%3DAKIAICA22YDS2RFDD3EA%26tag%3Dwideanglemacr-20%26linkCode%3Dxm2%26camp%3D2025%26creative%3D165953%26creativeASIN%3DB0000501Q​H'

   89 |   0.1353 |            enabled             | not cached |          1332 | SELECT cloak,a,id FROM wp_cloakPig_cloaks WHERE url='http://www.amazon.com/reviews/iframe?akid=AKIAICA22YDS2RFDD3EA&alinkCode=xm2&asin=B0000501QH&atag=wideanglemacr-20&exp=2011-11-18T05%3A56%3A38Z&summary=0&truncate=5000&v=2&sig=k%2FPBUDRhB8vnP5dYASu7jTEu2Y4bQCSA69YVbEBm7HY%3D'

   90 |   0.0007 |  disabled (Query is rejected)  | not cached |             0 | INSERT IGNORE INTO `wp_cloakPig_cloaks` (`url`,`cloak`,`a`,`hits`,`type`) VALUES ('http://www.amazon.com/reviews/iframe?akid=AKIAICA22YDS2RFDD3EA&alinkCode=xm2&asin=B0000501QH&atag=wideanglemacr-20&exp=2011-11-18T05%3A56%3A38Z&summary=0&truncate=5000&v=2&sig=k%2FPBUDRhB8vnP5dYASu7jTEu2Y4bQCSA69YVbEBm7HY%3D','/hiddendeals/ju0W','<a rel=\"external nofollow\" href=\"CLOAK_FORMAT\">','0','Auto')

   91 |   0.0001 |            enabled             |   cached   |          1499 | SELECT cloak,a,id FROM wp_cloakPig_cloaks WHERE url='http://www.amazon.com/Sigma-800mm-Ultra-Telephoto-Cameras/dp/B0000501QH%3FSubscriptionId%3DAKIAICA22YDS2RFDD3EA%26tag%3Dwideanglemacr-20%26linkCode%3Dxm2%26camp%3D2025%26creative%3D165953%26creativeASIN%3DB0000501Q​H'

   92 |   0.0001 |            enabled             |   cached   |          1499 | SELECT cloak,a,id FROM wp_cloakPig_cloaks WHERE url='http://www.amazon.com/Sigma-800mm-Ultra-Telephoto-Cameras/dp/B0009JKH00%3FSubscriptionId%3DAKIAICA22YDS2RFDD3EA%26tag%3Dwideanglemacr-20%26linkCode%3Dxm2%26camp%3D2025%26creative%3D165953%26creativeASIN%3DB0009JKH0​0'

   93 |   0.0001 |            enabled             |   cached   |          1499 | SELECT cloak,a,id FROM wp_cloakPig_cloaks WHERE url='http://www.amazon.com/Sigma-800mm-Ultra-Telephoto-Cameras/dp/B0009JKH00%3FSubscriptionId%3DAKIAICA22YDS2RFDD3EA%26tag%3Dwideanglemacr-20%26linkCode%3Dxm2%26camp%3D2025%26creative%3D165953%26creativeASIN%3DB0009JKH0​0'

   94 |   0.0001 |            enabled             |   cached   |          1499 | SELECT cloak,a,id FROM wp_cloakPig_cloaks WHERE url='http://www.amazon.com/Sigma-800mm-Ultra-Telephoto-Cameras/dp/B0009JKH00%3FSubscriptionId%3DAKIAICA22YDS2RFDD3EA%26tag%3Dwideanglemacr-20%26linkCode%3Dxm2%26camp%3D2025%26creative%3D165953%26creativeASIN%3DB0009JKH0​0'

   95 |   0.1634 |            enabled             | not cached |          1332 | SELECT cloak,a,id FROM wp_cloakPig_cloaks WHERE url='http://www.amazon.com/reviews/iframe?akid=AKIAICA22YDS2RFDD3EA&alinkCode=xm2&asin=B0009JKH00&atag=wideanglemacr-20&exp=2011-11-18T05%3A56%3A39Z&summary=0&truncate=5000&v=2&sig=rJg7CubgRKpXE0c8LtZcDQ1QTaNGKSGl9%2F2oRt356Qk%3D'

   96 |   0.0007 |  disabled (Query is rejected)  | not cached |             0 | INSERT IGNORE INTO `wp_cloakPig_cloaks` (`url`,`cloak`,`a`,`hits`,`type`) VALUES ('http://www.amazon.com/reviews/iframe?akid=AKIAICA22YDS2RFDD3EA&alinkCode=xm2&asin=B0009JKH00&atag=wideanglemacr-20&exp=2011-11-18T05%3A56%3A39Z&summary=0&truncate=5000&v=2&sig=rJg7CubgRKpXE0c8LtZcDQ1QTaNGKSGl9%2F2oRt356Qk%3D','/hiddendeals/vdkQ','<a rel=\"external nofollow\" href=\"CLOAK_FORMAT\">','0','Auto')

   97 |   0.0001 |            enabled             |   cached   |          1499 | SELECT cloak,a,id FROM wp_cloakPig_cloaks WHERE url='http://www.amazon.com/Sigma-800mm-Ultra-Telephoto-Cameras/dp/B0009JKH00%3FSubscriptionId%3DAKIAICA22YDS2RFDD3EA%26tag%3Dwideanglemacr-20%26linkCode%3Dxm2%26camp%3D2025%26creative%3D165953%26creativeASIN%3DB0009JKH0​0'

   98 |   0.0001 |            enabled             |   cached   |          5689 | SELECT content FROM wp_wpr_templates WHERE type = 'amazon'

   99 |   0.0002 |            enabled             |   cached   |          5689 | SELECT content FROM wp_wpr_templates WHERE type = 'amazon'

  100 |   0.0001 |            enabled             |   cached   |          1384 | SELECT cloak,a,id FROM wp_cloakPig_cloaks WHERE url='http://www.linkconnector.com/traffic_affiliate.php?lc=054882037831004157&amp;lcpt=0&amp;lcpf=0'

  101 |   0.0001 |            enabled             |   cached   |          1499 | SELECT cloak,a,id FROM wp_cloakPig_cloaks WHERE url='http://www.amazon.com/Sigma-800mm-Ultra-Telephoto-Cameras/dp/B0000501QH%3FSubscriptionId%3DAKIAICA22YDS2RFDD3EA%26tag%3Dwideanglemacr-20%26linkCode%3Dxm2%26camp%3D2025%26creative%3D165953%26creativeASIN%3DB0000501Q​H'

  102 |   0.0001 |            enabled             |   cached   |          1499 | SELECT cloak,a,id FROM wp_cloakPig_cloaks WHERE url='http://www.amazon.com/Sigma-800mm-Ultra-Telephoto-Cameras/dp/B0000501QH%3FSubscriptionId%3DAKIAICA22YDS2RFDD3EA%26tag%3Dwideanglemacr-20%26linkCode%3Dxm2%26camp%3D2025%26creative%3D165953%26creativeASIN%3DB0000501Q​H'

  103 |   0.0001 |            enabled             |   cached   |          1499 | SELECT cloak,a,id FROM wp_cloakPig_cloaks WHERE url='http://www.amazon.com/Sigma-800mm-Ultra-Telephoto-Cameras/dp/B0000501QH%3FSubscriptionId%3DAKIAICA22YDS2RFDD3EA%26tag%3Dwideanglemacr-20%26linkCode%3Dxm2%26camp%3D2025%26creative%3D165953%26creativeASIN%3DB0000501Q​H'

  104 |   0.1583 |            enabled             | not cached |          1336 | SELECT cloak,a,id FROM wp_cloakPig_cloaks WHERE url='http://www.amazon.com/reviews/iframe?akid=AKIAICA22YDS2RFDD3EA&alinkCode=xm2&asin=B0000501QH&atag=wideanglemacr-20&exp=2011-11-18T05%3A56%3A40Z&summary=0&truncate=5000&v=2&sig=aC5qSrxvcx8WZfD6P%2Fe%2B%2FUJbfVBfQ3WrvrvA1o45t90%3D'

  105 |   0.0004 |  disabled (Query is rejected)  | not cached |             0 | INSERT IGNORE INTO `wp_cloakPig_cloaks` (`url`,`cloak`,`a`,`hits`,`type`) VALUES ('http://www.amazon.com/reviews/iframe?akid=AKIAICA22YDS2RFDD3EA&alinkCode=xm2&asin=B0000501QH&atag=wideanglemacr-20&exp=2011-11-18T05%3A56%3A40Z&summary=0&truncate=5000&v=2&sig=aC5qSrxvcx8WZfD6P%2Fe%2B%2FUJbfVBfQ3WrvrvA1o45t90%3D','/hiddendeals/5KmS','<a rel=\"external nofollow\" href=\"CLOAK_FORMAT\">','0','Auto')

  106 |   0.0001 |            enabled             |   cached   |          1499 | SELECT cloak,a,id FROM wp_cloakPig_cloaks WHERE url='http://www.amazon.com/Sigma-800mm-Ultra-Telephoto-Cameras/dp/B0000501QH%3FSubscriptionId%3DAKIAICA22YDS2RFDD3EA%26tag%3Dwideanglemacr-20%26linkCode%3Dxm2%26camp%3D2025%26creative%3D165953%26creativeASIN%3DB0000501Q​H'

  107 |   0.0001 |            enabled             |   cached   |          1499 | SELECT cloak,a,id FROM wp_cloakPig_cloaks WHERE url='http://www.amazon.com/Sigma-800mm-Ultra-Telephoto-Cameras/dp/B0009JKH00%3FSubscriptionId%3DAKIAICA22YDS2RFDD3EA%26tag%3Dwideanglemacr-20%26linkCode%3Dxm2%26camp%3D2025%26creative%3D165953%26creativeASIN%3DB0009JKH0​0'

  108 |   0.0001 |            enabled             |   cached   |          1499 | SELECT cloak,a,id FROM wp_cloakPig_cloaks WHERE url='http://www.amazon.com/Sigma-800mm-Ultra-Telephoto-Cameras/dp/B0009JKH00%3FSubscriptionId%3DAKIAICA22YDS2RFDD3EA%26tag%3Dwideanglemacr-20%26linkCode%3Dxm2%26camp%3D2025%26creative%3D165953%26creativeASIN%3DB0009JKH0​0'

  109 |   0.0001 |            enabled             |   cached   |          1499 | SELECT cloak,a,id FROM wp_cloakPig_cloaks WHERE url='http://www.amazon.com/Sigma-800mm-Ultra-Telephoto-Cameras/dp/B0009JKH00%3FSubscriptionId%3DAKIAICA22YDS2RFDD3EA%26tag%3Dwideanglemacr-20%26linkCode%3Dxm2%26camp%3D2025%26creative%3D165953%26creativeASIN%3DB0009JKH0​0'

  110 |   0.2249 |            enabled             | not cached |          1332 | SELECT cloak,a,id FROM wp_cloakPig_cloaks WHERE url='http://www.amazon.com/reviews/iframe?akid=AKIAICA22YDS2RFDD3EA&alinkCode=xm2&asin=B0009JKH00&atag=wideanglemacr-20&exp=2011-11-18T05%3A56%3A40Z&summary=0&truncate=5000&v=2&sig=wgopq97z0SWQpAANpIq6cFTtWjRw9aEDEuHIk%2B0p9hY%3D'

  111 |   0.0005 |  disabled (Query is rejected)  | not cached |             0 | INSERT IGNORE INTO `wp_cloakPig_cloaks` (`url`,`cloak`,`a`,`hits`,`type`) VALUES ('http://www.amazon.com/reviews/iframe?akid=AKIAICA22YDS2RFDD3EA&alinkCode=xm2&asin=B0009JKH00&atag=wideanglemacr-20&exp=2011-11-18T05%3A56%3A40Z&summary=0&truncate=5000&v=2&sig=wgopq97z0SWQpAANpIq6cFTtWjRw9aEDEuHIk%2B0p9hY%3D','/hiddendeals/q0Xk','<a rel=\"external nofollow\" href=\"CLOAK_FORMAT\">','0','Auto')

  112 |   0.0002 |            enabled             |   cached   |          1499 | SELECT cloak,a,id FROM wp_cloakPig_cloaks WHERE url='http://www.amazon.com/Sigma-800mm-Ultra-Telephoto-Cameras/dp/B0009JKH00%3FSubscriptionId%3DAKIAICA22YDS2RFDD3EA%26tag%3Dwideanglemacr-20%26linkCode%3Dxm2%26camp%3D2025%26creative%3D165953%26creativeASIN%3DB0009JKH0​0'

  113 |   0.0003 |  disabled (Query is rejected)  | not cached |             0 | INSERT INTO wp_t09_sb_log(url,msg,type) VALUES('http://delicious.com/Minigrovy','Posting to delicious.com/Minigrovy','1')

  114 |   0.0005 |            enabled             | not cached |          1386 | SELECT cloak,a,id FROM wp_cloakPig_cloaks WHERE url='http://www.linkconnector.com/traffic_affiliate.php?lc=054882037831004157&lcpt=0&lcpf=0'

  115 |   0.0021 |            enabled             | not cached |          9696 | SELECT p.* FROM wp_posts AS p  WHERE p.post_date < '2011-11-02 08:31:55' AND p.post_type = 'post' AND p.post_status = 'publish'  ORDER BY p.post_date DESC LIMIT 1

  116 |   0.0001 |            enabled             |   cached   |           503 | SELECT `post_parent` FROM wp_posts WHERE ID = 12807 LIMIT 1

  117 |   0.0027 |            enabled             | not cached |          8082 | SELECT p.* FROM wp_posts AS p  WHERE p.post_date > '2011-11-02 08:31:55' AND p.post_type = 'post' AND p.post_status = 'publish'  ORDER BY p.post_date ASC LIMIT 1

  118 |   0.0001 |            enabled             |   cached   |           503 | SELECT `post_parent` FROM wp_posts WHERE ID = 12807 LIMIT 1

  119 |   0.0002 |            enabled             |   cached   |           885 | SELECT DISTINCT widget_id FROM wp_dynamic_widgets
                  WHERE  maintype LIKE 'single%' OR maintype IN ('date', 'role', 'browser', 'tpl', 'wpml', 'qt')

  120 |   0.0002 |            enabled             |   cached   |          1746 | SELECT widget_id, maintype, name, value FROM wp_dynamic_widgets
                  WHERE widget_id LIKE 'text-25'
                    AND (maintype LIKE 'single%' OR maintype IN ('date', 'role', 'browser', 'tpl', 'wpml', 'qt')) ORDER BY maintype, name

  121 |   0.0002 |            enabled             |   cached   |          2015 | SELECT widget_id, maintype, name, value FROM wp_dynamic_widgets
                  WHERE widget_id LIKE 'text-23'
                    AND (maintype LIKE 'single%' OR maintype IN ('date', 'role', 'browser', 'tpl', 'wpml', 'qt')) ORDER BY maintype, name

  122 |   0.0002 |            enabled             |   cached   |          2015 | SELECT widget_id, maintype, name, value FROM wp_dynamic_widgets
                  WHERE widget_id LIKE 'text-26'
                    AND (maintype LIKE 'single%' OR maintype IN ('date', 'role', 'browser', 'tpl', 'wpml', 'qt')) ORDER BY maintype, name

  123 |   0.0002 |            enabled             |   cached   |          1746 | SELECT widget_id, maintype, name, value FROM wp_dynamic_widgets
                  WHERE widget_id LIKE 'text-15'
                    AND (maintype LIKE 'single%' OR maintype IN ('date', 'role', 'browser', 'tpl', 'wpml', 'qt')) ORDER BY maintype, name

  124 |   0.0002 |            enabled             |   cached   |          1750 | SELECT widget_id, maintype, name, value FROM wp_dynamic_widgets
                  WHERE widget_id LIKE 'execphp-3'
                    AND (maintype LIKE 'single%' OR maintype IN ('date', 'role', 'browser', 'tpl', 'wpml', 'qt')) ORDER BY maintype, name

  125 |   0.0002 |            enabled             |   cached   |          3143 | SELECT tr.object_id FROM wp_term_relationships AS tr INNER JOIN wp_term_taxonomy AS tt ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN ('nav_menu') AND tt.term_id IN ('2824') ORDER BY tr.object_id ASC

  126 |    0.001 |            enabled             |   cached   |         48124 | SELECT   wp_posts.* FROM wp_posts  WHERE 1=1  AND wp_posts.ID IN (10733,10734,10736,10737,10739,10740,10742,10743,10745,10746,10747,10748,10753,1​0754,10755,10756,10758,10759,10760,10761,10763,10764,10765,10766,10767,10768,107​69,10770,10771,10772,10773,10775,12033,12034,12035,12052,12053,12054,12055,12056​,12794,12808,13510,13511,13512,13918,15246,15270) AND wp_posts.post_type = 'nav_menu_item' AND (wp_posts.post_status = 'publish')  ORDER BY menu_order ASC

  127 |   0.0011 |            enabled             | not cached |           884 | SELECT t.term_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') AND tr.object_id IN (2590) ORDER BY t.name ASC

  128 |   0.0002 |            enabled             |   cached   |          5689 | SELECT content FROM wp_wpr_templates WHERE type = 'amazon'

  129 |   0.0002 |            enabled             |   cached   |          1386 | SELECT cloak,a,id FROM wp_cloakPig_cloaks WHERE url='http://www.linkconnector.com/traffic_affiliate.php?lc=054882037831004157&lcpt=0&lcpf=0'

  130 |   0.0005 |            enabled             | not cached |          1495 | SELECT cloak,a,id FROM wp_cloakPig_cloaks WHERE url='http://www.amazon.com/Nikon-24-70mm-2-8G-Nikkor-Angle/dp/B000VDCT3C%3FSubscriptionId%3DAKIAICA22YDS2RFDD3EA%26tag%3Dwideanglemacr-20%26linkCode%3Dxm2%26camp%3D2025%26creative%3D165953%26creativeASIN%3DB000VDCT3​C'

  131 |   0.0002 |            enabled             |   cached   |          1495 | SELECT cloak,a,id FROM wp_cloakPig_cloaks WHERE url='http://www.amazon.com/Nikon-24-70mm-2-8G-Nikkor-Angle/dp/B000VDCT3C%3FSubscriptionId%3DAKIAICA22YDS2RFDD3EA%26tag%3Dwideanglemacr-20%26linkCode%3Dxm2%26camp%3D2025%26creative%3D165953%26creativeASIN%3DB000VDCT3​C'

  132 |   0.0002 |            enabled             |   cached   |          1495 | SELECT cloak,a,id FROM wp_cloakPig_cloaks WHERE url='http://www.amazon.com/Nikon-24-70mm-2-8G-Nikkor-Angle/dp/B000VDCT3C%3FSubscriptionId%3DAKIAICA22YDS2RFDD3EA%26tag%3Dwideanglemacr-20%26linkCode%3Dxm2%26camp%3D2025%26creative%3D165953%26creativeASIN%3DB000VDCT3​C'

  133 |   0.2199 |            enabled             | not cached |          1334 | SELECT cloak,a,id FROM wp_cloakPig_cloaks WHERE url='http://www.amazon.com/reviews/iframe?akid=AKIAICA22YDS2RFDD3EA&alinkCode=xm2&asin=B000VDCT3C&atag=wideanglemacr-20&exp=2011-11-18T05%3A56%3A42Z&summary=0&truncate=5000&v=2&sig=vI9p%2BbFW7LAEIEzXlWcX50PK%2BKCYFDedoOcgykuDceo%3D'

  134 |   0.0004 |  disabled (Query is rejected)  | not cached |             0 | INSERT IGNORE INTO `wp_cloakPig_cloaks` (`url`,`cloak`,`a`,`hits`,`type`) VALUES ('http://www.amazon.com/reviews/iframe?akid=AKIAICA22YDS2RFDD3EA&alinkCode=xm2&asin=B000VDCT3C&atag=wideanglemacr-20&exp=2011-11-18T05%3A56%3A42Z&summary=0&truncate=5000&v=2&sig=vI9p%2BbFW7LAEIEzXlWcX50PK%2BKCYFDedoOcgykuDceo%3D','/hiddendeals/27oN','<a rel=\"external nofollow\" href=\"CLOAK_FORMAT\">','0','Auto')

  135 |   0.0001 |            enabled             |   cached   |          1495 | SELECT cloak,a,id FROM wp_cloakPig_cloaks WHERE url='http://www.amazon.com/Nikon-24-70mm-2-8G-Nikkor-Angle/dp/B000VDCT3C%3FSubscriptionId%3DAKIAICA22YDS2RFDD3EA%26tag%3Dwideanglemacr-20%26linkCode%3Dxm2%26camp%3D2025%26creative%3D165953%26creativeASIN%3DB000VDCT3​C'

  136 |   0.0007 |            enabled             | not cached |          4900 | SELECT * FROM wp_comments  WHERE comment_approved = '1' AND comment_post_ID = 2590 ORDER BY comment_date_gmt ASC

  137 |   0.0001 |            enabled             |   cached   |           632 | SELECT term_taxonomy_id
                    FROM wp_term_taxonomy
                    WHERE taxonomy = 'category'
                    AND term_id IN (1)

  138 |   0.0005 |  disabled (Query is rejected)  | not cached |             0 | 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, 20

  139 |   0.0002 |  disabled (Query is rejected)  | not cached |             0 | SELECT FOUND_ROWS()

-->
Find all posts by this user
Quote this message in a reply
Post Reply 


Messages In This Thread
RE: Help and advice greatly appreciated. - mylemonhead - 11-17-2011 04:02 PM

Forum Jump:


User(s) browsing this thread: 1 Guest(s)