Page Time: 0.1470s

Memory: 6.6152 MB (Peak: 8.0609 MB)

Queries (40, time: 0.0269s, 18.3%)

  1. SELECT cache_value
    FROM xf_permission_combination
    WHERE permission_combination_id = ?
    Params: 1
    Run Time: 0.000207
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_permission_combinationconstPRIMARYPRIMARY4const1 
  2. SELECT thread.*
    	,
    		user.gender, user.avatar_date, user.gravatar,
    		NULL AS thread_read_date,
    		0 AS thread_reply_banned,
    		0 AS thread_is_watched,
    		'' AS draft_message, NULL AS draft_extra
    FROM xf_thread AS thread
    
    		LEFT JOIN xf_user AS user ON
    			(user.user_id = thread.user_id)
    WHERE thread.thread_id = ?
    Params: 5826
    Run Time: 0.000808
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLEthreadconstPRIMARYPRIMARY4const1 
    SIMPLEuserconstPRIMARYPRIMARY4const1 
  3. SELECT node.*, forum.*
    	,
    	permission.cache_value AS node_permission_cache,
    		NULL AS forum_read_date
    FROM xf_forum AS forum
    INNER JOIN xf_node AS node ON (node.node_id = forum.node_id)
    
    	LEFT JOIN xf_permission_cache_content AS permission
    		ON (permission.permission_combination_id = 1
    			AND permission.content_type = 'node'
    			AND permission.content_id = forum.node_id)
    WHERE node.node_id = ?
    Params: 13
    Run Time: 0.000380
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLEforumconstPRIMARYPRIMARY4const1 
    SIMPLEnodeconstPRIMARYPRIMARY4const1 
    SIMPLEpermissionconstPRIMARYPRIMARY35const,const,const1 
  4. SELECT EWRporta2_articles.*, xf_thread.*, xf_post.*, xf_user.*, EWRporta2_authors.*
    FROM EWRporta2_articles
    	INNER JOIN xf_thread ON (xf_thread.thread_id = EWRporta2_articles.thread_id)
    	INNER JOIN xf_post ON (xf_post.post_id = xf_thread.first_post_id)
    	LEFT JOIN xf_user ON (xf_user.user_id = xf_thread.user_id)
    	LEFT JOIN EWRporta2_authors ON (EWRporta2_authors.user_id = xf_thread.user_id)
    WHERE EWRporta2_articles.thread_id = ?
    Params: 5826
    Run Time: 0.002349
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLE       Impossible WHERE noticed after reading const tables
  5. SELECT EWRporta2_articles.*, EWRporta2_authors.*, xf_thread.*, xf_post.*, xf_user.*
    FROM xf_thread
    	INNER JOIN xf_post ON (xf_post.post_id = xf_thread.first_post_id)
    	LEFT JOIN xf_user ON (xf_user.user_id = xf_thread.user_id)
    	LEFT JOIN EWRporta2_authors ON (EWRporta2_authors.user_id = xf_thread.user_id)
    	LEFT JOIN EWRporta2_articles ON (EWRporta2_articles.thread_id = xf_thread.thread_id)
    WHERE xf_thread.thread_id = ?
    Params: 5826
    Run Time: 0.001006
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_threadconstPRIMARYPRIMARY4const1 
    SIMPLExf_postconstPRIMARYPRIMARY4const1 
    SIMPLExf_userconstPRIMARYPRIMARY4const1 
    SIMPLEEWRporta2_authorsconstPRIMARYPRIMARY4const0unique row not found
    SIMPLEEWRporta2_articlesconstPRIMARYPRIMARY4const0unique row not found
  6. SELECT post.*
    	,
    		bb_code_parse_cache.parse_tree AS message_parsed, bb_code_parse_cache.cache_version AS message_cache_version,
    		user.*, IF(user.username IS NULL, post.username, user.username) AS username,
    		user_profile.*,
    		user_privacy.*,
    		signature_parse_cache.parse_tree AS signature_parsed, bb_code_parse_cache.cache_version AS signature_cache_version,
    		session_activity.view_date AS last_view_date,
    		0 AS like_date
    		,(select sum(count_received) from dark_postrating_count where user_id = post.user_id and rating in (1,2,4,5,6,7,8,10)) as positive_rating_count
    	
    		,(select sum(count_received) from dark_postrating_count where user_id = post.user_id and rating in (14,11,12,13)) as negative_rating_count
    	
    		,(select sum(count_received) from dark_postrating_count where user_id = post.user_id and rating in (3,9)) as neutral_rating_count
    	,
    pr_cache.rating_cache,
    pr2.rating
    FROM xf_post AS post
    
    		LEFT JOIN xf_bb_code_parse_cache AS bb_code_parse_cache ON
    			(bb_code_parse_cache.content_type = 'post' AND bb_code_parse_cache.content_id = post.post_id)
    		LEFT JOIN xf_user AS user ON
    			(user.user_id = post.user_id)
    		LEFT JOIN xf_user_profile AS user_profile ON
    			(user_profile.user_id = post.user_id)
    		LEFT JOIN xf_user_privacy AS user_privacy ON
    			(user_privacy.user_id = post.user_id)
    		LEFT JOIN xf_bb_code_parse_cache AS signature_parse_cache ON
    			(signature_parse_cache.content_type = 'signature' AND signature_parse_cache.content_id = post.user_id)
    		LEFT JOIN xf_session_activity AS session_activity ON
    			(post.user_id > 0 AND session_activity.user_id = post.user_id AND session_activity.unique_key = CAST(post.user_id AS BINARY))
    left join dark_postrating_post_cache pr_cache ON (post.post_id = pr_cache.post_id)
    left join dark_postrating pr2 on (post.post_id = pr2.post_id and pr2.user_id = 0)
    WHERE post.thread_id = ?
    	 AND (post.position >= 75 AND post.position < 100) 
    	AND (post.message_state IN ('visible'))
    ORDER BY post.position ASC, post.post_date ASC
    Params: 5826
    Run Time: 0.003351
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    PRIMARYpostrangethread_id_post_date,thread_id_positionthread_id_position8 24Using where; Using filesort
    PRIMARYbb_code_parse_cacheeq_refcontent_type_idcontent_type_id31const,packerfo_maindb.post.post_id1 
    PRIMARYusereq_refPRIMARYPRIMARY4packerfo_maindb.post.user_id1 
    PRIMARYuser_profileeq_refPRIMARYPRIMARY4packerfo_maindb.post.user_id1 
    PRIMARYuser_privacyeq_refPRIMARYPRIMARY4packerfo_maindb.post.user_id1 
    PRIMARYsignature_parse_cacheeq_refcontent_type_idcontent_type_id31const,packerfo_maindb.post.user_id1 
    PRIMARYsession_activityeq_refPRIMARYPRIMARY22packerfo_maindb.post.user_id,func1 
    PRIMARYpr_cacheeq_refPRIMARYPRIMARY4packerfo_maindb.post.post_id1 
    PRIMARYpr2eq_refpost_id_user_id,post_id_rating,user_id_ratingpost_id_user_id8packerfo_maindb.post.post_id,const1 
    DEPENDENT SUBQUERYdark_postrating_countrefuser_id_ratinguser_id_rating4packerfo_maindb.post.user_id4Using where
    DEPENDENT SUBQUERYdark_postrating_countrefuser_id_ratinguser_id_rating4packerfo_maindb.post.user_id4Using where
    DEPENDENT SUBQUERYdark_postrating_countrefuser_id_ratinguser_id_rating4packerfo_maindb.post.user_id4Using where
  7. INSERT DELAYED INTO xf_thread_view
    	(thread_id)
    VALUES
    	(?)
    Params: 5826
    Run Time: 0.000304
  8. UPDATE xf_thread SET hot_count = hot_count + 1 WHERE thread_id = 5826
    Run Time: 0.000989
  9. SELECT thread.*
    	,
    		0 AS thread_reply_banned
    FROM xf_thread AS thread
    
    WHERE thread.thread_id = ?
    Params: 5826
    Run Time: 0.000401
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLEthreadconstPRIMARYPRIMARY4const1 
  10. SELECT node.*, forum.*
    	,
    	permission.cache_value AS node_permission_cache
    FROM xf_forum AS forum
    INNER JOIN xf_node AS node ON (node.node_id = forum.node_id)
    
    	LEFT JOIN xf_permission_cache_content AS permission
    		ON (permission.permission_combination_id = 1
    			AND permission.content_type = 'node'
    			AND permission.content_id = forum.node_id)
    WHERE node.node_id = ?
    Params: 13
    Run Time: 0.000289
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLEforumconstPRIMARYPRIMARY4const1 
    SIMPLEnodeconstPRIMARYPRIMARY4const1 
    SIMPLEpermissionconstPRIMARYPRIMARY35const,const,const1 
  11. SELECT *
    FROM xf_ignore_thread
    WHERE user_id = ?
    	AND thread_id = ?
    Params: 0, 5826
    Run Time: 0.000112
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_ignore_threadrefuser_threaduser_thread8const,const1 
  12. SELECT EWRporta2_articles.*, xf_thread.*, xf_post.*, xf_user.*, EWRporta2_authors.*
    FROM EWRporta2_articles
    	INNER JOIN xf_thread ON (xf_thread.thread_id = EWRporta2_articles.thread_id)
    	INNER JOIN xf_post ON (xf_post.post_id = xf_thread.first_post_id)
    	LEFT JOIN xf_user ON (xf_user.user_id = xf_thread.user_id)
    	LEFT JOIN EWRporta2_authors ON (EWRporta2_authors.user_id = xf_thread.user_id)
    WHERE EWRporta2_articles.thread_id = ?
    Params: 5826
    Run Time: 0.000912
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLE       Impossible WHERE noticed after reading const tables
  13. SELECT EWRporta2_articles.*, EWRporta2_authors.*, xf_thread.*, xf_post.*, xf_user.*
    FROM xf_thread
    	INNER JOIN xf_post ON (xf_post.post_id = xf_thread.first_post_id)
    	LEFT JOIN xf_user ON (xf_user.user_id = xf_thread.user_id)
    	LEFT JOIN EWRporta2_authors ON (EWRporta2_authors.user_id = xf_thread.user_id)
    	LEFT JOIN EWRporta2_articles ON (EWRporta2_articles.thread_id = xf_thread.thread_id)
    WHERE xf_thread.thread_id = ?
    Params: 5826
    Run Time: 0.000690
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_threadconstPRIMARYPRIMARY4const1 
    SIMPLExf_postconstPRIMARYPRIMARY4const1 
    SIMPLExf_userconstPRIMARYPRIMARY4const1 
    SIMPLEEWRporta2_authorsconstPRIMARYPRIMARY4const0unique row not found
    SIMPLEEWRporta2_articlesconstPRIMARYPRIMARY4const0unique row not found
  14. INSERT INTO xf_session_activity
    	(user_id, unique_key, ip, controller_name, controller_action, view_state, params, view_date, robot_key)
    VALUES
    	(?, ?, ?, ?, ?, ?, ?, ?, ?)
    ON DUPLICATE KEY UPDATE
    	ip = VALUES(ip),
    	controller_name = VALUES(controller_name),
    	controller_action = VALUES(controller_action),
    	view_state = VALUES(view_state),
    	params = VALUES(params),
    	view_date = VALUES(view_date),
    	robot_key = VALUES(robot_key)
    Params: 0, 6Q4, 6Q4, XenForo_ControllerPublic_Thread, Index, valid, thread_id=5826&page=4, 1469936118,
    Run Time: 0.001042
  15. SELECT title, phrase_text
    FROM xf_phrase_compiled
    WHERE language_id = ?
    	AND title IN ('freepro_menu_tickets', 'freepro_menu_schedule', 'freepro_menu_roster', 'freepro_menu_draft')
    Params: 1
    Run Time: 0.000122
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_phrase_compiledrangePRIMARYPRIMARY106 4Using where
  16. INSERT INTO xf_bb_code_parse_cache
    	(content_type, content_id, parse_tree, cache_version, cache_date)
    VALUES (?, ?, ?, ?, ?)
    ON DUPLICATE KEY UPDATE parse_tree = VALUES(parse_tree),
    	cache_version = VALUES(cache_version),
    	cache_date = VALUES(cache_date)
    Params: post, 86641, a:2:{i:0;s:23:"Good with Rats too. ";i:1;a:4:{s:3:"tag";s:3:"url";s:6:"option";s:20:"http://imageshack.us";s:8:"original";a:2:{i:0;s:26:"[url=http://imageshack.us]";i:1;s:6:"[/url]";}s:8:"children";a:1:{i:0;a:4:{s:3:"tag";s:3:"img";s:6:"option";N;s:8:"original";a:2:{i:0;s:5:"[img]";i:1;s:6:"[/img]";}s:8:"children";a:1:{i:0;s:61:"http://img242.imageshack.us/img242/2219/yellowmongooseup2.jpg";}}}}}, 1466975802, 1469936118
    Run Time: 0.000876
  17. INSERT INTO xf_bb_code_parse_cache
    	(content_type, content_id, parse_tree, cache_version, cache_date)
    VALUES (?, ?, ?, ?, ?)
    ON DUPLICATE KEY UPDATE parse_tree = VALUES(parse_tree),
    	cache_version = VALUES(cache_version),
    	cache_date = VALUES(cache_date)
    Params: post, 86642, a:1:{i:0;s:78:"Rent the move "Willard".... and start your own Army..terrify the neighbors!";}, 1466975802, 1469936118
    Run Time: 0.000527
  18. INSERT INTO xf_bb_code_parse_cache
    	(content_type, content_id, parse_tree, cache_version, cache_date)
    VALUES (?, ?, ?, ?, ?)
    ON DUPLICATE KEY UPDATE parse_tree = VALUES(parse_tree),
    	cache_version = VALUES(cache_version),
    	cache_date = VALUES(cache_date)
    Params: post, 86643, a:1:{i:0;s:697:"Well..if you're on a budget. You could eat them... CaveRat and Taters Ingredients: 3 Young, fat CaveRats 8 Sweet potatoes 2 Tablespoons butter 1 Tablespoon sugar 1 Pinch of salt Directions: Skin the CaveRats and remove the head, tail and feet. Wash it thoroughly and remove all parasites. Peel the potatoes and boil them tender in lightly salted water along with the butter and sugar. At the same time, stew the CaveRats tenderly in a tightly covered pan with a little water. Arrange the taters around the CaveRats. Sprinkle with thyme or marjoram, or pepper, and brown in the oven. Baste often with the drippings. Serve and enjoy!!!";}, 1466975802, 1469936118
    Run Time: 0.000607
  19. INSERT INTO xf_bb_code_parse_cache
    	(content_type, content_id, parse_tree, cache_version, cache_date)
    VALUES (?, ?, ?, ?, ?)
    ON DUPLICATE KEY UPDATE parse_tree = VALUES(parse_tree),
    	cache_version = VALUES(cache_version),
    	cache_date = VALUES(cache_date)
    Params: post, 86644, a:2:{i:0;a:4:{s:3:"tag";s:4:"size";s:6:"option";s:1:"6";s:8:"original";a:2:{i:0;s:8:"[size=6]";i:1;s:7:"[/size]";}s:8:"children";a:2:{i:0;a:4:{s:3:"tag";s:1:"b";s:6:"option";N;s:8:"original";a:2:{i:0;s:3:"[b]";i:1;s:4:"[/b]";}s:8:"children";a:1:{i:0;s:21:"How to Cure Rat Meat ";}}i:1;s:1:" ";}}i:1;s:1031:" This is probably best with 9 -12 well aged rats. First you need a crock that is big enough to hold the rats you want to cure. First make the brine. For three gallons of brine, add to your crock: 1 1/2 lb. Kosher Salt, 5 oz. Sugar, 2 Tbs. Peppercorns, 1 Tbs. Whole Cloves 6 Bay Leaves, 10 Tbs. Pickling Spices, 2 Onions, Sliced , 12 Cloves Garlic, crushed, 10 Small Hot Dry Red Chiles, and enough cold pure water to make three gallons. Stir until sugar and salt are dissolved. Add rats, do not pack tightly, they need some room. A half ounce or so of Nitrate is protection against the possibility of Botulism. When the rats are in the crock, cover them with a plate, and put something on the plate heavy enough to ensure the rats will stay submerged in the brine. Tie a cloth over the top of the crock to keep out bugs. Store in a cool spot. Turn the rats every few days. A scum of white mold may form on top, but that is normal. The rats will be ready to cook in 2-3 weeks. What you don't use immediately freezes well.";}, 1466975802, 1469936118
    Run Time: 0.000635
  20. INSERT INTO xf_bb_code_parse_cache
    	(content_type, content_id, parse_tree, cache_version, cache_date)
    VALUES (?, ?, ?, ?, ?)
    ON DUPLICATE KEY UPDATE parse_tree = VALUES(parse_tree),
    	cache_version = VALUES(cache_version),
    	cache_date = VALUES(cache_date)
    Params: post, 86645, a:1:{i:0;s:34:"Is this thread about Chinese food?";}, 1466975802, 1469936118
    Run Time: 0.000529
  21. INSERT INTO xf_bb_code_parse_cache
    	(content_type, content_id, parse_tree, cache_version, cache_date)
    VALUES (?, ?, ?, ?, ?)
    ON DUPLICATE KEY UPDATE parse_tree = VALUES(parse_tree),
    	cache_version = VALUES(cache_version),
    	cache_date = VALUES(cache_date)
    Params: post, 86646, a:2:{i:0;a:4:{s:3:"tag";s:5:"quote";s:6:"option";s:20:"all about da packers";s:8:"original";a:2:{i:0;s:28:"[quote=all about da packers]";i:1;s:8:"[/quote]";}s:8:"children";a:1:{i:0;s:759:"I don't like them. New apt has them. Old one didn't. How do I deal with this problem? What I currently do: Every time I see a rat I: 1. Scream like a girl 2. Get on the closest elevated thing and stay there 3. Yell for my "mommy" and "daddy" 4. Shed a few tears 5. Finally call my mommy and daddy to come over ..... er wait, I wonder if that will ruin my rep... :P No but seriously, what do I do. Clever little buggers, found an electrical cord that leads to the counter, so now they are able to get on the kitchen counter and hide behind things you normally wouldn't suspect... Covered that up, so now they found out that the doors aren't big enough, and they can slide underneath.... And dear God, those things can friggin jump. :shock: Help. :-?";}}i:1;s:581:" You asked the right person. ;) We had a rat problem because the area we lived floods and the rats need to go somewhere. Unfortunately, it was our house. We hired an exterminator. He put out traps. $30/mo and it took about 3 or 4 months. Keep in mind, we had a lot of rats, so maybe yours will take a shorter time. The other thing is you have to get rid of places to go. We went outside and had to cut some bushes down. We found rat turds in some of the bushes, so we trimmed them so much that they couldn't live there anymore. Also, pick up a rat terrier. 8)";}, 1466975802, 1469936118
    Run Time: 0.000582
  22. INSERT INTO xf_bb_code_parse_cache
    	(content_type, content_id, parse_tree, cache_version, cache_date)
    VALUES (?, ?, ?, ?, ?)
    ON DUPLICATE KEY UPDATE parse_tree = VALUES(parse_tree),
    	cache_version = VALUES(cache_version),
    	cache_date = VALUES(cache_date)
    Params: post, 86647, a:1:{i:0;s:338:"Thats a big problem.......being an apartment building, even if you have someone come into YOUR apartment to get rid of them, they are in the others, and will return. I think what you will need to do is, make the OTHER apartments more likeable to the rats! Send each of the people in your building "Cheese Baskets" as gifts........ :wink:";}, 1466975802, 1469936118
    Run Time: 0.000586
  23. INSERT INTO xf_bb_code_parse_cache
    	(content_type, content_id, parse_tree, cache_version, cache_date)
    VALUES (?, ?, ?, ?, ?)
    ON DUPLICATE KEY UPDATE parse_tree = VALUES(parse_tree),
    	cache_version = VALUES(cache_version),
    	cache_date = VALUES(cache_date)
    Params: post, 86648, a:1:{i:0;s:13:"Get a Ferret!";}, 1466975802, 1469936118
    Run Time: 0.000503
  24. INSERT INTO xf_bb_code_parse_cache
    	(content_type, content_id, parse_tree, cache_version, cache_date)
    VALUES (?, ?, ?, ?, ?)
    ON DUPLICATE KEY UPDATE parse_tree = VALUES(parse_tree),
    	cache_version = VALUES(cache_version),
    	cache_date = VALUES(cache_date)
    Params: post, 86649, a:1:{i:0;s:66:"Q$*(@#)%*~!!! Friggin rat found a way to get on the sofa... :-?";}, 1466975802, 1469936118
    Run Time: 0.000609
  25. INSERT INTO xf_bb_code_parse_cache
    	(content_type, content_id, parse_tree, cache_version, cache_date)
    VALUES (?, ?, ?, ?, ?)
    ON DUPLICATE KEY UPDATE parse_tree = VALUES(parse_tree),
    	cache_version = VALUES(cache_version),
    	cache_date = VALUES(cache_date)
    Params: post, 86650, a:1:{i:0;s:146:"Hey AADP how bout you kill the rat in your mic and maybe next week you can discuss the Packer game not the Vikings or Bears!!!!!!!!!!!!!!!!! :P";}, 1466975802, 1469936118
    Run Time: 0.000687
  26. INSERT INTO xf_bb_code_parse_cache
    	(content_type, content_id, parse_tree, cache_version, cache_date)
    VALUES (?, ?, ?, ?, ?)
    ON DUPLICATE KEY UPDATE parse_tree = VALUES(parse_tree),
    	cache_version = VALUES(cache_version),
    	cache_date = VALUES(cache_date)
    Params: post, 86651, a:1:{i:0;s:46:"I had a lot riding on the Bears winning.... :D";}, 1466975802, 1469936118
    Run Time: 0.000644
  27. INSERT INTO xf_bb_code_parse_cache
    	(content_type, content_id, parse_tree, cache_version, cache_date)
    VALUES (?, ?, ?, ?, ?)
    ON DUPLICATE KEY UPDATE parse_tree = VALUES(parse_tree),
    	cache_version = VALUES(cache_version),
    	cache_date = VALUES(cache_date)
    Params: post, 86652, a:2:{i:0;a:4:{s:3:"tag";s:5:"quote";s:6:"option";s:20:"all about da packers";s:8:"original";a:2:{i:0;s:28:"[quote=all about da packers]";i:1;s:8:"[/quote]";}s:8:"children";a:1:{i:0;s:64:"Q$*(@#)%*~!!! Friggin rat found a way to get on the sofa... :-?";}}i:1;s:123:" Teach him how to go for "beer runs" during the game.. May pay off. You'll have a new bud to watch the Pack with...";}, 1466975802, 1469936118
    Run Time: 0.000286
  28. INSERT INTO xf_bb_code_parse_cache
    	(content_type, content_id, parse_tree, cache_version, cache_date)
    VALUES (?, ?, ?, ?, ?)
    ON DUPLICATE KEY UPDATE parse_tree = VALUES(parse_tree),
    	cache_version = VALUES(cache_version),
    	cache_date = VALUES(cache_date)
    Params: post, 86653, a:2:{i:0;a:4:{s:3:"tag";s:5:"quote";s:6:"option";s:8:"majikman";s:8:"original";a:2:{i:0;s:16:"[quote=majikman]";i:1;s:8:"[/quote]";}s:8:"children";a:2:{i:0;a:4:{s:3:"tag";s:5:"quote";s:6:"option";s:20:"all about da packers";s:8:"original";a:2:{i:0;s:28:"[quote=all about da packers]";i:1;s:8:"[/quote]";}s:8:"children";a:1:{i:0;s:64:"Q$*(@#)%*~!!! Friggin rat found a way to get on the sofa... :-?";}}i:1;s:118:" Teach him how to go for "beer runs" during the game.. May pay off. You'll have a new bud to watch the Pack with...";}}i:1;s:147:" Thats true Majic! Haven't any of you ever heard of the famous "Rat Pack?" Very few know it was actually short for "Rat Packers!" :wink: :lol:";}, 1466975802, 1469936118
    Run Time: 0.000549
  29. INSERT INTO xf_bb_code_parse_cache
    	(content_type, content_id, parse_tree, cache_version, cache_date)
    VALUES (?, ?, ?, ?, ?)
    ON DUPLICATE KEY UPDATE parse_tree = VALUES(parse_tree),
    	cache_version = VALUES(cache_version),
    	cache_date = VALUES(cache_date)
    Params: post, 86654, a:1:{i:0;s:223:"You pussy....I mean you get a cat! The best method with rat traps are the old school trap where the metal bar wacks the crap out them. The trick is use Peanut Butter as bait. They try to lick it off, then whammo...dead rat.";}, 1466975802, 1469936118
    Run Time: 0.000514
  30. INSERT INTO xf_bb_code_parse_cache
    	(content_type, content_id, parse_tree, cache_version, cache_date)
    VALUES (?, ?, ?, ?, ?)
    ON DUPLICATE KEY UPDATE parse_tree = VALUES(parse_tree),
    	cache_version = VALUES(cache_version),
    	cache_date = VALUES(cache_date)
    Params: post, 86655, a:1:{i:0;s:694:"AADP, Here are some suggestions: 1. Put warfarin (rat poison) down. You can get it at Canadian Tire. 2. Get a mean cat or a ferret. If you go this route, don't also do #1. 3. Call an exterminator and bill the shyster lanlord. However, keep in mind Toronto's downtown is infested with rats, especially the Spadina/Chinatown area. When I was working out of 901 King, there were rat traps around every entrance to the building. Rats, mice and roaches kinda come hand-in-hand with living in the cesspool that call downtown Toronto, unless you want to pay $1400/month in rent for a shoebox apartment. Personally, I'd rather move than be putting up with living with vermin. :puke:";}, 1466975802, 1469936118
    Run Time: 0.000454
  31. INSERT INTO xf_bb_code_parse_cache
    	(content_type, content_id, parse_tree, cache_version, cache_date)
    VALUES (?, ?, ?, ?, ?)
    ON DUPLICATE KEY UPDATE parse_tree = VALUES(parse_tree),
    	cache_version = VALUES(cache_version),
    	cache_date = VALUES(cache_date)
    Params: post, 86656, a:1:{i:0;s:33:"thank God i'm a country girl!! :D";}, 1466975802, 1469936118
    Run Time: 0.000504
  32. INSERT INTO xf_bb_code_parse_cache
    	(content_type, content_id, parse_tree, cache_version, cache_date)
    VALUES (?, ?, ?, ?, ?)
    ON DUPLICATE KEY UPDATE parse_tree = VALUES(parse_tree),
    	cache_version = VALUES(cache_version),
    	cache_date = VALUES(cache_date)
    Params: post, 86657, a:1:{i:0;s:2003:"Why is it that I find this thread insanely funny? I have laughed my a** off throughout all 7 pages!! Anyway, on a serious note, I would be curious as to why the landlord/priest would give you a break in rent rather than fix the problem? hmmmm...inquiring minds want to know! I would do two things. First, write a letter (for documentation) to the Landlord. It would go as follows: Dear Father, As I lay me down to sleep, I pray no rats are at my feet. Should I be bit before I wake. It's your friggin head I shall take! No actually I would write this. Dear (insert name) After countless conversations and verbal complaints, I am formally writing you to ducument my complaint regarding numerous incidences of rats investing my apartment at (insert address). Since you have failed to respond in an appropriate way, I am forced to make the following demands. I demand an exterminator to service not only my apartment but the entire building within one week. Furthermore, I demand the the exterminator continue servicing the building on a consistant schedule for the safety of all the tenants. Failure to meet my demand in a timely manner will result in some or all of the following actions on my part. 1. After one week without an exterminator, I will acquire one, have them service the building and reduce my rent paid by the amount of the exterminators services. 2. Break my lease and sue for reinstatement of my deposit on grounds of said landlord breaching contract by not keeping said rental in livable conditions. 3. Contact Human health services and file a formal civil and possible criminal complaint. 4. Contact local news agencies (TV & Print) and explain my predictament My demands are not unreasonable and as you can see the consequences are all rights I have under the laws of (insert state or providence). Should you fail to protect my right to a livable home, I will have to enforce my rights. God Bless..... All about da pack";}, 1466975802, 1469936118
    Run Time: 0.000668
  33. INSERT INTO xf_bb_code_parse_cache
    	(content_type, content_id, parse_tree, cache_version, cache_date)
    VALUES (?, ?, ?, ?, ?)
    ON DUPLICATE KEY UPDATE parse_tree = VALUES(parse_tree),
    	cache_version = VALUES(cache_version),
    	cache_date = VALUES(cache_date)
    Params: post, 86658, a:1:{i:0;s:415:"Oops! forget to tell you the second thing... The second thing I would do is have some fun while you give the landlord the week to get the exterminator. Get a pump BB gun. Trust me, I can (and have) killed squirrels from 50yds when I pump the gun up 10 times. You can shoot the gun in the city because it is not considered a firearm. One shot will easily kill the rats and it makes a sport out of it for you!";}, 1466975802, 1469936118
    Run Time: 0.000599
  34. INSERT INTO xf_bb_code_parse_cache
    	(content_type, content_id, parse_tree, cache_version, cache_date)
    VALUES (?, ?, ?, ?, ?)
    ON DUPLICATE KEY UPDATE parse_tree = VALUES(parse_tree),
    	cache_version = VALUES(cache_version),
    	cache_date = VALUES(cache_date)
    Params: post, 86659, a:1:{i:0;s:175:"Trip, First of all I loved the first letter better...LOL...I am still laughing,, But I most definately would write the second letter, you have to take some action here...";}, 1466975802, 1469936118
    Run Time: 0.000585
  35. INSERT INTO xf_bb_code_parse_cache
    	(content_type, content_id, parse_tree, cache_version, cache_date)
    VALUES (?, ?, ?, ?, ?)
    ON DUPLICATE KEY UPDATE parse_tree = VALUES(parse_tree),
    	cache_version = VALUES(cache_version),
    	cache_date = VALUES(cache_date)
    Params: post, 86660, a:1:{i:0;s:30:"I have to party with trippster";}, 1466975802, 1469936118
    Run Time: 0.000519
  36. INSERT INTO xf_bb_code_parse_cache
    	(content_type, content_id, parse_tree, cache_version, cache_date)
    VALUES (?, ?, ?, ?, ?)
    ON DUPLICATE KEY UPDATE parse_tree = VALUES(parse_tree),
    	cache_version = VALUES(cache_version),
    	cache_date = VALUES(cache_date)
    Params: post, 86661, a:2:{i:0;a:4:{s:3:"tag";s:5:"quote";s:6:"option";s:7:"tromadz";s:8:"original";a:2:{i:0;s:15:"[quote=tromadz]";i:1;s:8:"[/quote]";}s:8:"children";a:1:{i:0;s:30:"I have to party with trippster";}}i:1;s:47:" ditto!!! good stuff, tripp!!!!! :rotflmao:";}, 1466975802, 1469936118
    Run Time: 0.000371
  37. INSERT INTO xf_bb_code_parse_cache
    	(content_type, content_id, parse_tree, cache_version, cache_date)
    VALUES (?, ?, ?, ?, ?)
    ON DUPLICATE KEY UPDATE parse_tree = VALUES(parse_tree),
    	cache_version = VALUES(cache_version),
    	cache_date = VALUES(cache_date)
    Params: post, 86662, a:2:{i:0;a:4:{s:3:"tag";s:1:"b";s:6:"option";N;s:8:"original";a:2:{i:0;s:3:"[b]";i:1;s:4:"[/b]";}s:8:"children";a:1:{i:0;s:13:"The Brass Rat";}}i:1;s:898:" A man walked into a curio store and was looking around. After awhile, he chose a brass rat and brought it up to the counter. The proprietor said, that will be $10 for the brass rat and $1,000 for the story behind it. The man said, 'Thanks, but I'll just pay the $10 and pass on the story.' He purchased the brass rat and left the store. As he was walking down the street, he started noticing all sorts of rats following him. The further he walked -- the more rats followed. He walked down to the wharf and still more rats came out and followed him. So, he decided to walk out into the water, which he did -- and all the rats drowned. He returned to the store where he purchased the brass rat, and when he walked in, the proprietor said, 'Ah ha! You came back to pay the $1,000 for the story, right?' 'Nope,' replied the man, 'Just came back to see if you have any brass lawyers!'";}, 1466975802, 1469936118
    Run Time: 0.000528
  38. INSERT INTO xf_bb_code_parse_cache
    	(content_type, content_id, parse_tree, cache_version, cache_date)
    VALUES (?, ?, ?, ?, ?)
    ON DUPLICATE KEY UPDATE parse_tree = VALUES(parse_tree),
    	cache_version = VALUES(cache_version),
    	cache_date = VALUES(cache_date)
    Params: post, 86663, a:3:{i:0;a:4:{s:3:"tag";s:3:"url";s:6:"option";N;s:8:"original";a:2:{i:0;s:5:"[url]";i:1;s:6:"[/url]";}s:8:"children";a:1:{i:0;s:58:"http://www.wnbc.com/news/11089614/detail.html?dl=mainclick";}}i:1;s:245:" NEW YORK -- It's hard to believe how bad the rat problem is at a downtown fast-food restaurant. The rodents are everywhere at a Kentucky Fried Chicken/Taco Bell in Greenwich Village, on 6th Avenue and West 4th Street. See the video ";i:2;a:4:{s:3:"tag";s:3:"url";s:6:"option";N;s:8:"original";a:2:{i:0;s:5:"[url]";i:1;s:6:"[/url]";}s:8:"children";a:1:{i:0;s:38:"http://video.wnbc.com/player/?id=64901";}}}, 1466975802, 1469936118
    Run Time: 0.000468
  39. INSERT INTO xf_bb_code_parse_cache
    	(content_type, content_id, parse_tree, cache_version, cache_date)
    VALUES (?, ?, ?, ?, ?)
    ON DUPLICATE KEY UPDATE parse_tree = VALUES(parse_tree),
    	cache_version = VALUES(cache_version),
    	cache_date = VALUES(cache_date)
    Params: post, 86664, a:1:{i:0;s:211:"I will take a little rat residue over a un-happy employee who decides to hawk a Loogie in my rye and cheese sandwich any day. Alway's treat your servers with respect when ordering your meal. Raider Pride.";}, 1466975802, 1469936118
    Run Time: 0.000526
  40. INSERT INTO xf_bb_code_parse_cache
    	(content_type, content_id, parse_tree, cache_version, cache_date)
    VALUES (?, ?, ?, ?, ?)
    ON DUPLICATE KEY UPDATE parse_tree = VALUES(parse_tree),
    	cache_version = VALUES(cache_version),
    	cache_date = VALUES(cache_date)
    Params: post, 86665, a:1:{i:0;s:75:"*curls to the ground and starts shuttering* There out to get me..... :-?";}, 1466975802, 1469936118
    Run Time: 0.000591

Included Files (154, XenForo Classes: 63)

  1. index.php
  2. library/XenForo/Autoloader.php
  3. library/XenForo/Application.php
  4. library/Zend/Registry.php
  5. library/Lgpl/utf8.php
  6. library/Zend/Config.php
  7. library/config.php
  8. library/XenForo/FrontController.php
  9. library/XenForo/Dependencies/Public.php
  10. library/XenForo/Dependencies/Abstract.php
  11. library/Zend/Controller/Request/Http.php
  12. library/Zend/Controller/Request/Abstract.php
  13. library/Zend/Uri.php
  14. library/Zend/Controller/Response/Http.php
  15. library/Zend/Controller/Response/Abstract.php
  16. library/XenForo/Model/DataRegistry.php
  17. library/XenForo/Model.php
  18. library/Zend/Cache.php
  19. library/Zend/Cache/Backend/Memcached.php
  20. library/Zend/Cache/Backend/ExtendedInterface.php
  21. library/Zend/Cache/Backend/Interface.php
  22. library/Zend/Cache/Backend.php
  23. library/Zend/Cache/Core.php
  24. library/XenForo/CodeEvent.php
  25. library/XenForo/Options.php
  26. library/XenForo/Link.php
  27. library/XenForo/Template/Helper/Core.php
  28. library/FreePro/Listener.php
  29. library/bdTagMe/Listener.php
  30. library/bdTagMe/Helper/Template.php
  31. library/bdTagMe/ShippableHelper/Updater.php
  32. library/bdTagMe/Option.php
  33. library/sonnb/XenGallery/Listener.php
  34. library/EWRporta2/Listener/Init.php
  35. library/XenForo/Router.php
  36. library/XenForo/Route/Filter.php
  37. library/XenForo/Route/Interface.php
  38. library/XenForo/Route/ResponseSuffix.php
  39. library/XenForo/Route/Prefix.php
  40. library/XenForo/Route/Prefix/Threads.php
  41. library/XenForo/RouteMatch.php
  42. library/XenForo/ControllerPublic/Thread.php
  43. library/XenForo/ControllerPublic/Abstract.php
  44. library/XenForo/Controller.php
  45. library/ModerateCountry/RegisterListener.php
  46. library/EWRporta2/Widget/Listener/ArticlesMain.php
  47. library/Nobita/IgnoreThread/Listener.php
  48. library/Dark/PostRating/EventListener.php
  49. library/EWRporta2/Listener/Controller.php
  50. library/FreePro/XenForo/ControllerPublic/Thread.php
  51. library/Nobita/IgnoreThread/ControllerPublic/Thread.php
  52. library/sonnb/XenGallery/XenForo/ControllerPublic/Thread.php
  53. library/EWRporta2/ControllerPublic/Thread.php
  54. library/XenForo/Input.php
  55. library/XenForo/Session.php
  56. library/Zend/Db.php
  57. library/Zend/Db/Adapter/Mysqli.php
  58. library/Zend/Db/Adapter/Abstract.php
  59. library/Zend/Db/Select.php
  60. library/Zend/Db/Expr.php
  61. library/Zend/Db/Profiler.php
  62. library/Zend/Db/Statement/Mysqli.php
  63. library/Zend/Db/Statement.php
  64. library/Zend/Db/Statement/Interface.php
  65. library/XenForo/Helper/Ip.php
  66. library/XenForo/Visitor.php
  67. library/XenForo/Model/User.php
  68. library/ThemeHouse/JoinUserGroup/Listener/LoadClass.php
  69. library/ThemeHouse/Listener/LoadClass.php
  70. library/ThemeHouse/Listener/LoadClass/20150518.php
  71. library/Dark/TaigaChat/EventListener/Listener.php
  72. library/sonnbThreadMassActions/Listener.php
  73. library/EWRporta2/Listener/Model.php
  74. library/ThemeHouse/JoinUserGroup/Extend/XenForo/Model/User.php
  75. library/Dark/PostRating/Model/User.php
  76. library/bdTagMe/XenForo/Model/User.php
  77. library/sonnb/XenGallery/XenForo/Model/User.php
  78. library/EWRporta2/Model/User.php
  79. library/Zend/Db/Profiler/Query.php
  80. library/XenForo/Permission.php
  81. library/XenForo/Helper/Php.php
  82. library/XenForo/Phrase.php
  83. library/XenForo/Locale.php
  84. library/Sedo/DetectBrowser/Listener/Visitor.php
  85. library/Sedo/DetectBrowser/Helper/MobileDetect.php
  86. library/EWRporta2/Model/Perms.php
  87. library/ThemeHouse/JoinUserGroup/Listener/ControllerPreDispatch.php
  88. library/ThemeHouse/Listener/ControllerPreDispatch.php
  89. library/ThemeHouse/Listener/ControllerPreDispatch/20150911.php
  90. library/UnreadPostCount/Listener.php
  91. library/XenForo/ControllerHelper/ForumThreadPost.php
  92. library/XenForo/ControllerHelper/Abstract.php
  93. library/XenForo/Model/Thread.php
  94. library/Nobita/IgnoreThread/Model/Thread.php
  95. library/Dark/PostRating/Model/Thread.php
  96. library/sonnbThreadMassActions/Model/Thread.php
  97. library/UnreadPostCount/Model/Thread.php
  98. library/Dark/PostRating/Model.php
  99. library/XenForo/Model/Forum.php
  100. library/XenForo/Helper/String.php
  101. library/XenForo/Helper/Discussion.php
  102. library/XenForo/Model/Post.php
  103. library/Dark/PostRating/Model/Post.php
  104. library/sonnbThreadMassActions/Model/Post.php
  105. library/EWRporta2/Model/Post.php
  106. library/EWRporta2/Model/Articles.php
  107. library/XenForo/Model/Attachment.php
  108. library/XenForo/Model/Node.php
  109. library/Nobita/IgnoreThread/Model/Node.php
  110. library/XenForo/Route/Prefix/Categories.php
  111. library/XenForo/Route/Prefix/Forums.php
  112. library/XenForo/ControllerResponse/View.php
  113. library/XenForo/ControllerResponse/Abstract.php
  114. library/Nobita/IgnoreThread/Model/IgnoreThread.php
  115. library/XenForo/Helper/Cookie.php
  116. library/XenForo/ViewRenderer/HtmlPublic.php
  117. library/XenForo/ViewRenderer/Abstract.php
  118. library/XenForo/Template/Public.php
  119. library/XenForo/Template/Abstract.php
  120. library/XenForo/ViewPublic/Thread/View.php
  121. library/XenForo/ViewPublic/Base.php
  122. library/XenForo/View.php
  123. library/EWRporta2/Listener/ViewPublic.php
  124. library/XenForo/BbCode/Parser.php
  125. library/XenForo/BbCode/Formatter/Base.php
  126. library/EWRporta2/Listener/BbCode.php
  127. library/bdTagMe/XenForo/BbCode/Formatter/Base.php
  128. library/sonnb/XenGallery/XenForo/BbCode/Formatter/Base.php
  129. library/EWRporta2/BbCode/Formatter.php
  130. library/XenForo/ViewPublic/Helper/Message.php
  131. library/XenForo/BbCode/TextWrapper.php
  132. library/WhoHasVisited/Listener.php
  133. library/XenForo/Route/Prefix/Members.php
  134. library/bdTagMe/XenForo/Route/Prefix/Members.php
  135. library/Dark/TaigaChat/EventListener/NavigationTabs.php
  136. library/EWRporta2/Listener/NavTabs.php
  137. library/XenForo/Template/FileHandler.php
  138. library/XenForo/Helper/File.php
  139. internal_data/templates/S.7,L.1,thread_view.php
  140. library/SeparateStickyAndNormal/Listener.php
  141. library/EWRporta2/Listener/Template.php
  142. internal_data/templates/S.7,L.1,ignore_thread_tool.php
  143. internal_data/templates/S.7,L.1,page_nav.php
  144. library/XenForo/Route/Prefix/Posts.php
  145. library/XenForo/Model/Avatar.php
  146. internal_data/templates/S.7,L.1,dark_postrating_message_user_info.php
  147. internal_data/templates/S.7,L.1,dark_postrating.php
  148. internal_data/templates/S.7,L.1,bb_code_tag_quote.php
  149. library/XenForo/Helper/Criteria.php
  150. library/XenForo/Debug.php
  151. internal_data/templates/S.7,L.1,PAGE_CONTAINER.php
  152. library/FreePro/Helper.php
  153. internal_data/templates/S.7,L.1,EWRporta2_Navtabs.php
  154. library/XenForo/ViewRenderer/Json.php