Skocz do zawartości
"Idzie nowe..." - o zmianach i nie tylko ×
Przeniesienie zakupów z IPS Marketplace / Moving bought items from IPS Marketplace ×
Hosting webh.pl - 20%

Bardzo duża ilość zapytań

angel554

Przez angel554
w Ogólny support IPB

 Udostępnij

Rekomendowane odpowiedzi

angel554 Współtwórca

angel554

Opublikowano
Opublikowano (edytowane)

Witam,

zauważyłem że przy przeglądaniu postów na moim forum wykonywane są GIGANTYCZNE ilości zapytań - np. przy załadowaniu kolejnej strony tematu przyciskiem "dalej" strona generuje się ponad 3 sekundy i wymagała ponad 150 zapytań! Czy nowe IPB 3.3.x jest aż tak mySQLo-żerne?!

Dodam że podana ilość zapytań jest generowana przy wyłączonych wszystkich Aplikacjach i rozszerzeniach nie będących pochodzenia IPS.

Edytowane przez angel554
angel554 Współtwórca

angel554

Opublikowano
  • Autor
Opublikowano (edytowane)

Keye wyxxxxowane.

SELECT * FROM ibf_cache_store WHERE cs_key IN ( 'useragents','bbcode','mediatag' )

SELECT * FROM ibf_sessions WHERE id='fd33a9xxxxxxxxxxxx'

SELECT m.*, m.member_id as my_member_id,p.*,pp.*,g.*,ccb.cache_content FROM ibf_members m LEFT JOIN ibf_pfields_content p ON ( p.member_id=m.member_id ) LEFT JOINibf_profile_portal pp ON ( pp.pp_member_id=m.member_id ) LEFT JOIN ibf_groups g ON ( g.g_id=m.member_group_id ) LEFT JOIN ibf_content_cache_sigs ccb ON ( ccb.cache_content_id=m.member_id ) WHERE m.member_id=2

SELECT t.*,xxx.* FROM ibf_topics t LEFT JOIN ibf_core_tags_cache xxx ON ( xxx.tag_cache_key=MD5(CONCAT('forums',';','topics',';',t.tid)) ) WHERE t.tid=127539

SELECT f.*,p.*,itemmarking.* FROM ibf_forums f LEFT JOIN ibf_permission_index p ON ( p.perm_type='forum' AND p.app='forums' AND p.perm_type_id=f.id ) LEFT JOIN ibf_core_item_markers itemmarking ON ( itemmarking.item_member_id=2 AND itemmarking.item_app='forums' AND itemmarking.item_app_key_1=f.id )

SELECT * FROM ibf_topic_ratings WHERE rating_tid=127539 and rating_member_id=2

SELECT p.*,m.member_id as mid,m.name,m.member_group_id,m.email,m.joined,m.posts, m.last_visit, m.last_activity,m.login_anonymous,m.title as member_title, m.warn_level, m.warn_lastwarn, m.members_display_name, m.members_seo_name, m.member_banned, m.has_gallery, m.has_blog, m.members_bitoptions,m.mgroup_others,pp.*,w.wl_id,rep_index.rep_rating as has_given_rep,rep_cache.rep_points, rep_cache.rep_like_cache,cca.*,ccb.cache_content as cache_content_sig, ccb.cache_updated as cache_updated_sig FROM ibf_posts p LEFT JOINibf_members m ON ( m.member_id=p.author_id ) LEFT JOIN ibf_profile_portal pp ON ( m.member_id=pp.pp_member_id ) LEFT JOIN ibf_members_warn_logs w ON ( w.wl_content_app='forums' and w.wl_content_id1=p.pid ) LEFT JOIN ibf_reputation_index rep_index ON ( rep_index.app='forums' AND rep_index.type='pid' AND rep_index.type_id=p.pid AND rep_index.member_id=2 ) LEFT JOIN ibf_reputation_cache rep_cache ON ( rep_cache.app='forums' AND rep_cache.type='pid' AND rep_cache.type_id=p.pid ) LEFT JOIN ibf_content_cache_posts cca ON ( cca.cache_content_id=p.pid ) LEFT JOIN ibf_content_cache_sigs ccb ON ( ccb.cache_content_id=m.member_id ) WHERE p.topic_id=127539 AND p.queued IN (0,1,2) ORDER BY p.pid asc LIMIT 20,20

SELECT SUM(rep_rating) as sum, COUNT(*) as count FROM ibf_reputation_index WHERE app='forums' AND type='pid' AND type_id='2209680'

SELECT r.member_id, r.rep_rating,m.members_display_name, m.members_seo_name FROM ibf_reputation_index r LEFT JOIN ibf_members m ON ( m.member_id=r.member_id ) WHERE r.app='forums' AND r.type='pid' AND r.type_id='2209680'

INSERT INTO ibf_reputation_cache (`app`,`type`,`type_id`,`rep_points`,`cache_date`,`rep_like_cache`) VALUES('forums','pid',2209680,0,1351175371,'a:2:{s:10:\"cache_data\";a:0:{}s:12:\"cache_expire\";i:1351261771;}') ON DUPLICATE KEY UPDATE app=VALUES(app),type=VALUES(type),type_id=VALUES(type_id),rep_points=VALUES(rep_points),cache_date=VALUES(cache_date),rep_like_cache=VALUES(rep_like_cache)

INSERT INTO ibf_reputation_totals (`rt_key`,`rt_app_type`,`rt_type_id`,`rt_total`) VALUES('2165814ab7332a4199fa7xxxxxxxxxxxx','a17de1b4e5015b2ca6ba5cxxxxxxxxxxxx',2209680,0) ON DUPLICATE KEY UPDATE rt_key=VALUES(rt_key),rt_app_type=VALUES(rt_app_type),rt_type_id=VALUES(rt_type_id),rt_total=VALUES(rt_total)

SELECT r.member_id, r.rep_rating,m.members_display_name, m.members_seo_name FROM ibf_reputation_index r LEFT JOIN ibf_members m ON ( m.member_id=r.member_id ) WHERE r.app='forums' AND r.type='pid' AND r.type_id='2209680'

INSERT INTO ibf_reputation_cache (`app`,`type`,`type_id`,`rep_points`,`cache_date`,`rep_like_cache`) VALUES('forums','pid',2209680,0,1351175371,'a:2:{s:10:\"cache_data\";a:0:{}s:12:\"cache_expire\";i:1351261771;}') ON DUPLICATE KEY UPDATE app=VALUES(app),type=VALUES(type),type_id=VALUES(type_id),rep_points=VALUES(rep_points),cache_date=VALUES(cache_date),rep_like_cache=VALUES(rep_like_cache)

SELECT SUM(rep_rating) as sum, COUNT(*) as count FROM ibf_reputation_index WHERE app='forums' AND type='pid' AND type_id='2209803'

SELECT r.member_id, r.rep_rating,m.members_display_name, m.members_seo_name FROM ibf_reputation_index r LEFT JOIN ibf_members m ON ( m.member_id=r.member_id ) WHERE r.app='forums' AND r.type='pid' AND r.type_id='2209803'

INSERT INTO ibf_reputation_cache (`app`,`type`,`type_id`,`rep_points`,`cache_date`,`rep_like_cache`) VALUES('forums','pid',2209803,0,1351175371,'a:2:{s:10:\"cache_data\";a:0:{}s:12:\"cache_expire\";i:1351261771;}') ON DUPLICATE KEY UPDATE app=VALUES(app),type=VALUES(type),type_id=VALUES(type_id),rep_points=VALUES(rep_points),cache_date=VALUES(cache_date),rep_like_cache=VALUES(rep_like_cache)

INSERT INTO ibf_reputation_totals (`rt_key`,`rt_app_type`,`rt_type_id`,`rt_total`) VALUES('bc1da551ec3959179f1xxxxxxxxxxxx','a17de1b4e5015b2ca6ba5cbxxxxxxxxxxxx',2209803,0) ON DUPLICATE KEY UPDATE rt_key=VALUES(rt_key),rt_app_type=VALUES(rt_app_type),rt_type_id=VALUES(rt_type_id),rt_total=VALUES(rt_total)

SELECT r.member_id, r.rep_rating,m.members_display_name, m.members_seo_name FROM ibf_reputation_index r LEFT JOIN ibf_members m ON ( m.member_id=r.member_id ) WHERE r.app='forums' AND r.type='pid' AND r.type_id='2209803'

INSERT INTO ibf_reputation_cache (`app`,`type`,`type_id`,`rep_points`,`cache_date`,`rep_like_cache`) VALUES('forums','pid',2209803,0,1351175371,'a:2:{s:10:\"cache_data\";a:0:{}s:12:\"cache_expire\";i:1351261771;}') ON DUPLICATE KEY UPDATE app=VALUES(app),type=VALUES(type),type_id=VALUES(type_id),rep_points=VALUES(rep_points),cache_date=VALUES(cache_date),rep_like_cache=VALUES(rep_like_cache)

SELECT SUM(rep_rating) as sum, COUNT(*) as count FROM ibf_reputation_index WHERE app='forums' AND type='pid' AND type_id='2209927'

SELECT r.member_id, r.rep_rating,m.members_display_name, m.members_seo_name FROM ibf_reputation_index r LEFT JOIN ibf_members m ON ( m.member_id=r.member_id ) WHERE r.app='forums' AND r.type='pid' AND r.type_id='2209927'

INSERT INTO ibf_reputation_cache (`app`,`type`,`type_id`,`rep_points`,`cache_date`,`rep_like_cache`) VALUES('forums','pid',2209927,0,1351175371,'a:2:{s:10:\"cache_data\";a:0:{}s:12:\"cache_expire\";i:1351261771;}') ON DUPLICATE KEY UPDATE app=VALUES(app),type=VALUES(type),type_id=VALUES(type_id),rep_points=VALUES(rep_points),cache_date=VALUES(cache_date),rep_like_cache=VALUES(rep_like_cache)

INSERT INTO ibf_reputation_totals (`rt_key`,`rt_app_type`,`rt_type_id`,`rt_total`) VALUES('76bd24f2333bf9aabxxxxxxxxxxxx','a17de1b4e5015b2ca6bxxxxxxxxxxxx',2209927,0) ON DUPLICATE KEY UPDATE rt_key=VALUES(rt_key),rt_app_type=VALUES(rt_app_type),rt_type_id=VALUES(rt_type_id),rt_total=VALUES(rt_total)

SELECT r.member_id, r.rep_rating,m.members_display_name, m.members_seo_name FROM ibf_reputation_index r LEFT JOIN ibf_members m ON ( m.member_id=r.member_id ) WHERE r.app='forums' AND r.type='pid' AND r.type_id='2209927'

INSERT INTO ibf_reputation_cache (`app`,`type`,`type_id`,`rep_points`,`cache_date`,`rep_like_cache`) VALUES('forums','pid',2209927,0,1351175371,'a:2:{s:10:\"cache_data\";a:0:{}s:12:\"cache_expire\";i:1351261771;}') ON DUPLICATE KEY UPDATE app=VALUES(app),type=VALUES(type),type_id=VALUES(type_id),rep_points=VALUES(rep_points),cache_date=VALUES(cache_date),rep_like_cache=VALUES(rep_like_cache)

SELECT SUM(rep_rating) as sum, COUNT(*) as count FROM ibf_reputation_index WHERE app='forums' AND type='pid' AND type_id='2210136'

SELECT r.member_id, r.rep_rating,m.members_display_name, m.members_seo_name FROM ibf_reputation_index r LEFT JOIN ibf_members m ON ( m.member_id=r.member_id ) WHERE r.app='forums' AND r.type='pid' AND r.type_id='2210136'

INSERT INTO ibf_reputation_cache (`app`,`type`,`type_id`,`rep_points`,`cache_date`,`rep_like_cache`) VALUES('forums','pid',2210136,0,1351175371,'a:2:{s:10:\"cache_data\";a:0:{}s:12:\"cache_expire\";i:1351261771;}') ON DUPLICATE KEY UPDATE app=VALUES(app),type=VALUES(type),type_id=VALUES(type_id),rep_points=VALUES(rep_points),cache_date=VALUES(cache_date),rep_like_cache=VALUES(rep_like_cache)

INSERT INTO ibf_reputation_totals (`rt_key`,`rt_app_type`,`rt_type_id`,`rt_total`) VALUES('4a124856804a09ff72xxxxxxxxxxxx','a17de1b4e5015b2ca6ba5cxxxxxxxxxxxx',2210136,0) ON DUPLICATE KEY UPDATE rt_key=VALUES(rt_key),rt_app_type=VALUES(rt_app_type),rt_type_id=VALUES(rt_type_id),rt_total=VALUES(rt_total)

SELECT r.member_id, r.rep_rating,m.members_display_name, m.members_seo_name FROM ibf_reputation_index r LEFT JOIN ibf_members m ON ( m.member_id=r.member_id ) WHERE r.app='forums' AND r.type='pid' AND r.type_id='2210136'

INSERT INTO ibf_reputation_cache (`app`,`type`,`type_id`,`rep_points`,`cache_date`,`rep_like_cache`) VALUES('forums','pid',2210136,0,1351175371,'a:2:{s:10:\"cache_data\";a:0:{}s:12:\"cache_expire\";i:1351261771;}') ON DUPLICATE KEY UPDATE app=VALUES(app),type=VALUES(type),type_id=VALUES(type_id),rep_points=VALUES(rep_points),cache_date=VALUES(cache_date),rep_like_cache=VALUES(rep_like_cache)

SELECT SUM(rep_rating) as sum, COUNT(*) as count FROM ibf_reputation_index WHERE app='forums' AND type='pid' AND type_id='2212736'

SELECT r.member_id, r.rep_rating,m.members_display_name, m.members_seo_name FROM ibf_reputation_index r LEFT JOIN ibf_members m ON ( m.member_id=r.member_id ) WHERE r.app='forums' AND r.type='pid' AND r.type_id='2212736'

INSERT INTO ibf_reputation_cache (`app`,`type`,`type_id`,`rep_points`,`cache_date`,`rep_like_cache`) VALUES('forums','pid',2212736,0,1351175371,'a:2:{s:10:\"cache_data\";a:0:{}s:12:\"cache_expire\";i:1351261771;}') ON DUPLICATE KEY UPDATE app=VALUES(app),type=VALUES(type),type_id=VALUES(type_id),rep_points=VALUES(rep_points),cache_date=VALUES(cache_date),rep_like_cache=VALUES(rep_like_cache)

INSERT INTO ibf_reputation_totals (`rt_key`,`rt_app_type`,`rt_type_id`,`rt_total`) VALUES('60c8861fc768e6c2099bxxxxxxxxxxxx','a17de1b4e5015b2ca6baxxxxxxxxxxxx',2212736,0) ON DUPLICATE KEY UPDATE rt_key=VALUES(rt_key),rt_app_type=VALUES(rt_app_type),rt_type_id=VALUES(rt_type_id),rt_total=VALUES(rt_total)

SELECT r.member_id, r.rep_rating,m.members_display_name, m.members_seo_name FROM ibf_reputation_index r LEFT JOIN ibf_members m ON ( m.member_id=r.member_id ) WHERE r.app='forums' AND r.type='pid' AND r.type_id='2212736'

INSERT INTO ibf_reputation_cache (`app`,`type`,`type_id`,`rep_points`,`cache_date`,`rep_like_cache`) VALUES('forums','pid',2212736,0,1351175371,'a:2:{s:10:\"cache_data\";a:0:{}s:12:\"cache_expire\";i:1351261771;}') ON DUPLICATE KEY UPDATE app=VALUES(app),type=VALUES(type),type_id=VALUES(type_id),rep_points=VALUES(rep_points),cache_date=VALUES(cache_date),rep_like_cache=VALUES(rep_like_cache)

SELECT SUM(rep_rating) as sum, COUNT(*) as count FROM ibf_reputation_index WHERE app='forums' AND type='pid' AND type_id='2212806'

SELECT r.member_id, r.rep_rating,m.members_display_name, m.members_seo_name FROM ibf_reputation_index r LEFT JOIN ibf_members m ON ( m.member_id=r.member_id ) WHERE r.app='forums' AND r.type='pid' AND r.type_id='2212806'

INSERT INTO ibf_reputation_cache (`app`,`type`,`type_id`,`rep_points`,`cache_date`,`rep_like_cache`) VALUES('forums','pid',2212806,0,1351175371,'a:2:{s:10:\"cache_data\";a:0:{}s:12:\"cache_expire\";i:1351261771;}') ON DUPLICATE KEY UPDATE app=VALUES(app),type=VALUES(type),type_id=VALUES(type_id),rep_points=VALUES(rep_points),cache_date=VALUES(cache_date),rep_like_cache=VALUES(rep_like_cache)

INSERT INTO ibf_reputation_totals (`rt_key`,`rt_app_type`,`rt_type_id`,`rt_total`) VALUES('be5f2575014112656e1xxxxxxxxxxxx','a17de1b4e5015b2ca6ba5cxxxxxxxxxxxx',2212806,0) ON DUPLICATE KEY UPDATE rt_key=VALUES(rt_key),rt_app_type=VALUES(rt_app_type),rt_type_id=VALUES(rt_type_id),rt_total=VALUES(rt_total)

SELECT r.member_id, r.rep_rating,m.members_display_name, m.members_seo_name FROM ibf_reputation_index r LEFT JOIN ibf_members m ON ( m.member_id=r.member_id ) WHERE r.app='forums' AND r.type='pid' AND r.type_id='2212806'

INSERT INTO ibf_reputation_cache (`app`,`type`,`type_id`,`rep_points`,`cache_date`,`rep_like_cache`) VALUES('forums','pid',2212806,0,1351175371,'a:2:{s:10:\"cache_data\";a:0:{}s:12:\"cache_expire\";i:1351261771;}') ON DUPLICATE KEY UPDATE app=VALUES(app),type=VALUES(type),type_id=VALUES(type_id),rep_points=VALUES(rep_points),cache_date=VALUES(cache_date),rep_like_cache=VALUES(rep_like_cache)

SELECT SUM(rep_rating) as sum, COUNT(*) as count FROM ibf_reputation_index WHERE app='forums' AND type='pid' AND type_id='2212905'

SELECT r.member_id, r.rep_rating,m.members_display_name, m.members_seo_name FROM ibf_reputation_index r LEFT JOIN ibf_members m ON ( m.member_id=r.member_id ) WHERE r.app='forums' AND r.type='pid' AND r.type_id='2212905'

INSERT INTO ibf_reputation_cache (`app`,`type`,`type_id`,`rep_points`,`cache_date`,`rep_like_cache`) VALUES('forums','pid',2212905,0,1351175371,'a:2:{s:10:\"cache_data\";a:0:{}s:12:\"cache_expire\";i:1351261771;}') ON DUPLICATE KEY UPDATE app=VALUES(app),type=VALUES(type),type_id=VALUES(type_id),rep_points=VALUES(rep_points),cache_date=VALUES(cache_date),rep_like_cache=VALUES(rep_like_cache)

INSERT INTO ibf_reputation_totals (`rt_key`,`rt_app_type`,`rt_type_id`,`rt_total`) VALUES('2e7ddaf9a4128xxxxxxxxxxxx','a17de1b4e5015b2ca6b6xxxxxxxxxxxx',2212905,0) ON DUPLICATE KEY UPDATE rt_key=VALUES(rt_key),rt_app_type=VALUES(rt_app_type),rt_type_id=VALUES(rt_type_id),rt_total=VALUES(rt_total)

SELECT r.member_id, r.rep_rating,m.members_display_name, m.members_seo_name FROM ibf_reputation_index r LEFT JOIN ibf_members m ON ( m.member_id=r.member_id ) WHERE r.app='forums' AND r.type='pid' AND r.type_id='2212905'

INSERT INTO ibf_reputation_cache (`app`,`type`,`type_id`,`rep_points`,`cache_date`,`rep_like_cache`) VALUES('forums','pid',2212905,0,1351175371,'a:2:{s:10:\"cache_data\";a:0:{}s:12:\"cache_expire\";i:1351261771;}') ON DUPLICATE KEY UPDATE app=VALUES(app),type=VALUES(type),type_id=VALUES(type_id),rep_points=VALUES(rep_points),cache_date=VALUES(cache_date),rep_like_cache=VALUES(rep_like_cache)

SELECT SUM(rep_rating) as sum, COUNT(*) as count FROM ibf_reputation_index WHERE app='forums' AND type='pid' AND type_id='2220411'

SELECT r.member_id, r.rep_rating,m.members_display_name, m.members_seo_name FROM ibf_reputation_index r LEFT JOIN ibf_members m ON ( m.member_id=r.member_id ) WHERE r.app='forums' AND r.type='pid' AND r.type_id='2220411'

INSERT INTO ibf_reputation_cache (`app`,`type`,`type_id`,`rep_points`,`cache_date`,`rep_like_cache`) VALUES('forums','pid',2220411,0,1351175371,'a:2:{s:10:\"cache_data\";a:0:{}s:12:\"cache_expire\";i:1351261771;}') ON DUPLICATE KEY UPDATE app=VALUES(app),type=VALUES(type),type_id=VALUES(type_id),rep_points=VALUES(rep_points),cache_date=VALUES(cache_date),rep_like_cache=VALUES(rep_like_cache)

INSERT INTO ibf_reputation_totals (`rt_key`,`rt_app_type`,`rt_type_id`,`rt_total`) VALUES('11c0861472d1862d70xxxxxxxxxxxx','a17de1b4e5015b2ca6ba5cxxxxxxxxxxxx',2220411,0) ON DUPLICATE KEY UPDATE rt_key=VALUES(rt_key),rt_app_type=VALUES(rt_app_type),rt_type_id=VALUES(rt_type_id),rt_total=VALUES(rt_total)

SELECT r.member_id, r.rep_rating,m.members_display_name, m.members_seo_name FROM ibf_reputation_index r LEFT JOIN ibf_members m ON ( m.member_id=r.member_id ) WHERE r.app='forums' AND r.type='pid' AND r.type_id='2220411'

INSERT INTO ibf_reputation_cache (`app`,`type`,`type_id`,`rep_points`,`cache_date`,`rep_like_cache`) VALUES('forums','pid',2220411,0,1351175371,'a:2:{s:10:\"cache_data\";a:0:{}s:12:\"cache_expire\";i:1351261771;}') ON DUPLICATE KEY UPDATE app=VALUES(app),type=VALUES(type),type_id=VALUES(type_id),rep_points=VALUES(rep_points),cache_date=VALUES(cache_date),rep_like_cache=VALUES(rep_like_cache)

SELECT SUM(rep_rating) as sum, COUNT(*) as count FROM ibf_reputation_index WHERE app='forums' AND type='pid' AND type_id='2220424'

SELECT r.member_id, r.rep_rating,m.members_display_name, m.members_seo_name FROM ibf_reputation_index r LEFT JOIN ibf_members m ON ( m.member_id=r.member_id ) WHERE r.app='forums' AND r.type='pid' AND r.type_id='2220424'

INSERT INTO ibf_reputation_cache (`app`,`type`,`type_id`,`rep_points`,`cache_date`,`rep_like_cache`) VALUES('forums','pid',2220424,0,1351175371,'a:2:{s:10:\"cache_data\";a:0:{}s:12:\"cache_expire\";i:1351261771;}') ON DUPLICATE KEY UPDATE app=VALUES(app),type=VALUES(type),type_id=VALUES(type_id),rep_points=VALUES(rep_points),cache_date=VALUES(cache_date),rep_like_cache=VALUES(rep_like_cache)

INSERT INTO ibf_reputation_totals (`rt_key`,`rt_app_type`,`rt_type_id`,`rt_total`) VALUES('cc38f9ee6085xxxxxxxxxxxx','a17de1b4e5015bcxxxxxxxxxxxx',2220424,0) ON DUPLICATE KEY UPDATE rt_key=VALUES(rt_key),rt_app_type=VALUES(rt_app_type),rt_type_id=VALUES(rt_type_id),rt_total=VALUES(rt_total)

SELECT r.member_id, r.rep_rating,m.members_display_name, m.members_seo_name FROM ibf_reputation_index r LEFT JOIN ibf_members m ON ( m.member_id=r.member_id ) WHERE r.app='forums' AND r.type='pid' AND r.type_id='2220424'

INSERT INTO ibf_reputation_cache (`app`,`type`,`type_id`,`rep_points`,`cache_date`,`rep_like_cache`) VALUES('forums','pid',2220424,0,1351175371,'a:2:{s:10:\"cache_data\";a:0:{}s:12:\"cache_expire\";i:1351261771;}') ON DUPLICATE KEY UPDATE app=VALUES(app),type=VALUES(type),type_id=VALUES(type_id),rep_points=VALUES(rep_points),cache_date=VALUES(cache_date),rep_like_cache=VALUES(rep_like_cache)

SELECT SUM(rep_rating) as sum, COUNT(*) as count FROM ibf_reputation_index WHERE app='forums' AND type='pid' AND type_id='2220472'

SELECT r.member_id, r.rep_rating,m.members_display_name, m.members_seo_name FROM ibf_reputation_index r LEFT JOIN ibf_members m ON ( m.member_id=r.member_id ) WHERE r.app='forums' AND r.type='pid' AND r.type_id='2220472'

INSERT INTO ibf_reputation_cache (`app`,`type`,`type_id`,`rep_points`,`cache_date`,`rep_like_cache`) VALUES('forums','pid',2220472,0,1351175371,'a:2:{s:10:\"cache_data\";a:0:{}s:12:\"cache_expire\";i:1351261771;}') ON DUPLICATE KEY UPDATE app=VALUES(app),type=VALUES(type),type_id=VALUES(type_id),rep_points=VALUES(rep_points),cache_date=VALUES(cache_date),rep_like_cache=VALUES(rep_like_cache)

INSERT INTO ibf_reputation_totals (`rt_key`,`rt_app_type`,`rt_type_id`,`rt_total`) VALUES('837875e84530xxxxxxxxxxxx','a17de1b4e5015b2ca6ba5cbxxxxxxxxxxxx',2220472,0) ON DUPLICATE KEY UPDATE rt_key=VALUES(rt_key),rt_app_type=VALUES(rt_app_type),rt_type_id=VALUES(rt_type_id),rt_total=VALUES(rt_total)

SELECT r.member_id, r.rep_rating,m.members_display_name, m.members_seo_name FROM ibf_reputation_index r LEFT JOIN ibf_members m ON ( m.member_id=r.member_id ) WHERE r.app='forums' AND r.type='pid' AND r.type_id='2220472'

INSERT INTO ibf_reputation_cache (`app`,`type`,`type_id`,`rep_points`,`cache_date`,`rep_like_cache`) VALUES('forums','pid',2220472,0,1351175371,'a:2:{s:10:\"cache_data\";a:0:{}s:12:\"cache_expire\";i:1351261771;}') ON DUPLICATE KEY UPDATE app=VALUES(app),type=VALUES(type),type_id=VALUES(type_id),rep_points=VALUES(rep_points),cache_date=VALUES(cache_date),rep_like_cache=VALUES(rep_like_cache)

SELECT SUM(rep_rating) as sum, COUNT(*) as count FROM ibf_reputation_index WHERE app='forums' AND type='pid' AND type_id='2220507'

SELECT r.member_id, r.rep_rating,m.members_display_name, m.members_seo_name FROM ibf_reputation_index r LEFT JOIN ibf_members m ON ( m.member_id=r.member_id ) WHERE r.app='forums' AND r.type='pid' AND r.type_id='2220507'

INSERT INTO ibf_reputation_cache (`app`,`type`,`type_id`,`rep_points`,`cache_date`,`rep_like_cache`) VALUES('forums','pid',2220507,0,1351175371,'a:2:{s:10:\"cache_data\";a:0:{}s:12:\"cache_expire\";i:1351261771;}') ON DUPLICATE KEY UPDATE app=VALUES(app),type=VALUES(type),type_id=VALUES(type_id),rep_points=VALUES(rep_points),cache_date=VALUES(cache_date),rep_like_cache=VALUES(rep_like_cache)

INSERT INTO ibf_reputation_totals (`rt_key`,`rt_app_type`,`rt_type_id`,`rt_total`) VALUES('3e623cf959e3xxxxxxxxxxxx','a17de1b4e5015b2ca6baxxxxxxxxxxxx',2220507,0) ON DUPLICATE KEY UPDATE rt_key=VALUES(rt_key),rt_app_type=VALUES(rt_app_type),rt_type_id=VALUES(rt_type_id),rt_total=VALUES(rt_total)

SELECT r.member_id, r.rep_rating,m.members_display_name, m.members_seo_name FROM ibf_reputation_index r LEFT JOIN ibf_members m ON ( m.member_id=r.member_id ) WHERE r.app='forums' AND r.type='pid' AND r.type_id='2220507'

INSERT INTO ibf_reputation_cache (`app`,`type`,`type_id`,`rep_points`,`cache_date`,`rep_like_cache`) VALUES('forums','pid',2220507,0,1351175371,'a:2:{s:10:\"cache_data\";a:0:{}s:12:\"cache_expire\";i:1351261771;}') ON DUPLICATE KEY UPDATE app=VALUES(app),type=VALUES(type),type_id=VALUES(type_id),rep_points=VALUES(rep_points),cache_date=VALUES(cache_date),rep_like_cache=VALUES(rep_like_cache)

SELECT SUM(rep_rating) as sum, COUNT(*) as count FROM ibf_reputation_index WHERE app='forums' AND type='pid' AND type_id='2220520'

SELECT r.member_id, r.rep_rating,m.members_display_name, m.members_seo_name FROM ibf_reputation_index r LEFT JOIN ibf_members m ON ( m.member_id=r.member_id ) WHERE r.app='forums' AND r.type='pid' AND r.type_id='2220520'

INSERT INTO ibf_reputation_cache (`app`,`type`,`type_id`,`rep_points`,`cache_date`,`rep_like_cache`) VALUES('forums','pid',2220520,0,1351175371,'a:2:{s:10:\"cache_data\";a:0:{}s:12:\"cache_expire\";i:1351261771;}') ON DUPLICATE KEY UPDATE app=VALUES(app),type=VALUES(type),type_id=VALUES(type_id),rep_points=VALUES(rep_points),cache_date=VALUES(cache_date),rep_like_cache=VALUES(rep_like_cache)

INSERT INTO ibf_reputation_totals (`rt_key`,`rt_app_type`,`rt_type_id`,`rt_total`) VALUES('b680d5dd42c196xxxxxxxxxxxx','a17de1b4e5015b2ca6ba5cxxxxxxxxxxxx',2220520,0) ON DUPLICATE KEY UPDATE rt_key=VALUES(rt_key),rt_app_type=VALUES(rt_app_type),rt_type_id=VALUES(rt_type_id),rt_total=VALUES(rt_total)

SELECT r.member_id, r.rep_rating,m.members_display_name, m.members_seo_name FROM ibf_reputation_index r LEFT JOIN ibf_members m ON ( m.member_id=r.member_id ) WHERE r.app='forums' AND r.type='pid' AND r.type_id='2220520'

INSERT INTO ibf_reputation_cache (`app`,`type`,`type_id`,`rep_points`,`cache_date`,`rep_like_cache`) VALUES('forums','pid',2220520,0,1351175371,'a:2:{s:10:\"cache_data\";a:0:{}s:12:\"cache_expire\";i:1351261771;}') ON DUPLICATE KEY UPDATE app=VALUES(app),type=VALUES(type),type_id=VALUES(type_id),rep_points=VALUES(rep_points),cache_date=VALUES(cache_date),rep_like_cache=VALUES(rep_like_cache)

SELECT SUM(rep_rating) as sum, COUNT(*) as count FROM ibf_reputation_index WHERE app='forums' AND type='pid' AND type_id='2221304'

SELECT r.member_id, r.rep_rating,m.members_display_name, m.members_seo_name FROM ibf_reputation_index r LEFT JOIN ibf_members m ON ( m.member_id=r.member_id ) WHERE r.app='forums' AND r.type='pid' AND r.type_id='2221304'

INSERT INTO ibf_reputation_cache (`app`,`type`,`type_id`,`rep_points`,`cache_date`,`rep_like_cache`) VALUES('forums','pid',2221304,0,1351175371,'a:2:{s:10:\"cache_data\";a:0:{}s:12:\"cache_expire\";i:1351261771;}') ON DUPLICATE KEY UPDATE app=VALUES(app),type=VALUES(type),type_id=VALUES(type_id),rep_points=VALUES(rep_points),cache_date=VALUES(cache_date),rep_like_cache=VALUES(rep_like_cache)

INSERT INTO ibf_reputation_totals (`rt_key`,`rt_app_type`,`rt_type_id`,`rt_total`) VALUES('abcc057b36d2c9xxxxxxxxxxxx','a17de1b4e5015b2ca6ba5cxxxxxxxxxxxx',2221304,0) ON DUPLICATE KEY UPDATE rt_key=VALUES(rt_key),rt_app_type=VALUES(rt_app_type),rt_type_id=VALUES(rt_type_id),rt_total=VALUES(rt_total)

SELECT r.member_id, r.rep_rating,m.members_display_name, m.members_seo_name FROM ibf_reputation_index r LEFT JOIN ibf_members m ON ( m.member_id=r.member_id ) WHERE r.app='forums' AND r.type='pid' AND r.type_id='2221304'

INSERT INTO ibf_reputation_cache (`app`,`type`,`type_id`,`rep_points`,`cache_date`,`rep_like_cache`) VALUES('forums','pid',2221304,0,1351175371,'a:2:{s:10:\"cache_data\";a:0:{}s:12:\"cache_expire\";i:1351261771;}') ON DUPLICATE KEY UPDATE app=VALUES(app),type=VALUES(type),type_id=VALUES(type_id),rep_points=VALUES(rep_points),cache_date=VALUES(cache_date),rep_like_cache=VALUES(rep_like_cache)

SELECT SUM(rep_rating) as sum, COUNT(*) as count FROM ibf_reputation_index WHERE app='forums' AND type='pid' AND type_id='2221988'

SELECT r.member_id, r.rep_rating,m.members_display_name, m.members_seo_name FROM ibf_reputation_index r LEFT JOIN ibf_members m ON ( m.member_id=r.member_id ) WHERE r.app='forums' AND r.type='pid' AND r.type_id='2221988'

INSERT INTO ibf_reputation_cache (`app`,`type`,`type_id`,`rep_points`,`cache_date`,`rep_like_cache`) VALUES('forums','pid',2221988,0,1351175371,'a:2:{s:10:\"cache_data\";a:0:{}s:12:\"cache_expire\";i:1351261771;}') ON DUPLICATE KEY UPDATE app=VALUES(app),type=VALUES(type),type_id=VALUES(type_id),rep_points=VALUES(rep_points),cache_date=VALUES(cache_date),rep_like_cache=VALUES(rep_like_cache)

INSERT INTO ibf_reputation_totals (`rt_key`,`rt_app_type`,`rt_type_id`,`rt_total`) VALUES('280fd156be2480df9bxxxxxxxxxxxx','a17de1b4e5015b2ca6bxxxxxxxxxxxx',2221988,0) ON DUPLICATE KEY UPDATE rt_key=VALUES(rt_key),rt_app_type=VALUES(rt_app_type),rt_type_id=VALUES(rt_type_id),rt_total=VALUES(rt_total)

SELECT r.member_id, r.rep_rating,m.members_display_name, m.members_seo_name FROM ibf_reputation_index r LEFT JOIN ibf_members m ON ( m.member_id=r.member_id ) WHERE r.app='forums' AND r.type='pid' AND r.type_id='2221988'

INSERT INTO ibf_reputation_cache (`app`,`type`,`type_id`,`rep_points`,`cache_date`,`rep_like_cache`) VALUES('forums','pid',2221988,0,1351175371,'a:2:{s:10:\"cache_data\";a:0:{}s:12:\"cache_expire\";i:1351261771;}') ON DUPLICATE KEY UPDATE app=VALUES(app),type=VALUES(type),type_id=VALUES(type_id),rep_points=VALUES(rep_points),cache_date=VALUES(cache_date),rep_like_cache=VALUES(rep_like_cache)

SELECT SUM(rep_rating) as sum, COUNT(*) as count FROM ibf_reputation_index WHERE app='forums' AND type='pid' AND type_id='2222068'

SELECT r.member_id, r.rep_rating,m.members_display_name, m.members_seo_name FROM ibf_reputation_index r LEFT JOIN ibf_members m ON ( m.member_id=r.member_id ) WHERE r.app='forums' AND r.type='pid' AND r.type_id='2222068'

INSERT INTO ibf_reputation_cache (`app`,`type`,`type_id`,`rep_points`,`cache_date`,`rep_like_cache`) VALUES('forums','pid',2222068,1,1351175371,'a:2:{s:10:\"cache_data\";a:6:{s:2:\"id\";s:7:\"2222068\";s:4:\"type\";s:3:\"pid\";s:3:\"app\";s:6:\"forums\";s:5:\"count\";i:1;s:11:\"memberNames\";a:1:{i:89288;a:2:{s:1:\"n\";s:4:\"LukC\";s:1:\"s\";s:4:\"lukc\";}}s:9:\"memberIds\";a:1:{i:0;s:5:\"89288\";}}s:12:\"cache_expire\";i:1351261771;}') ON DUPLICATE KEY UPDATE app=VALUES(app),type=VALUES(type),type_id=VALUES(type_id),rep_points=VALUES(rep_points),cache_date=VALUES(cache_date),rep_like_cache=VALUES(rep_like_cache)

INSERT INTO ibf_reputation_totals (`rt_key`,`rt_app_type`,`rt_type_id`,`rt_total`) VALUES('9211f59839xxxxxxxxxxxx','a17de1b4e5015b2ca6ba5cb6xxxxxxxxxxxx',2222068,1) ON DUPLICATE KEY UPDATE rt_key=VALUES(rt_key),rt_app_type=VALUES(rt_app_type),rt_type_id=VALUES(rt_type_id),rt_total=VALUES(rt_total)

SELECT r.member_id, r.rep_rating,m.members_display_name, m.members_seo_name FROM ibf_reputation_index r LEFT JOIN ibf_members m ON ( m.member_id=r.member_id ) WHERE r.app='forums' AND r.type='pid' AND r.type_id='2222068'

INSERT INTO ibf_reputation_cache (`app`,`type`,`type_id`,`rep_points`,`cache_date`,`rep_like_cache`) VALUES('forums','pid',2222068,1,1351175371,'a:2:{s:10:\"cache_data\";a:6:{s:3:\"app\";s:6:\"forums\";s:4:\"type\";s:3:\"pid\";s:2:\"id\";s:7:\"2222068\";s:5:\"count\";i:1;s:11:\"memberNames\";a:1:{i:89288;a:2:{s:1:\"n\";s:4:\"LukC\";s:1:\"s\";s:4:\"lukc\";}}s:9:\"memberIds\";a:1:{i:0;s:5:\"89288\";}}s:12:\"cache_expire\";i:1351261771;}') ON DUPLICATE KEY UPDATE app=VALUES(app),type=VALUES(type),type_id=VALUES(type_id),rep_points=VALUES(rep_points),cache_date=VALUES(cache_date),rep_like_cache=VALUES(rep_like_cache)

SELECT SUM(rep_rating) as sum, COUNT(*) as count FROM ibf_reputation_index WHERE app='forums' AND type='pid' AND type_id='2222166'

SELECT r.member_id, r.rep_rating,m.members_display_name, m.members_seo_name FROM ibf_reputation_index r LEFT JOIN ibf_members m ON ( m.member_id=r.member_id ) WHERE r.app='forums' AND r.type='pid' AND r.type_id='2222166'

INSERT INTO ibf_reputation_cache (`app`,`type`,`type_id`,`rep_points`,`cache_date`,`rep_like_cache`) VALUES('forums','pid',2222166,0,1351175371,'a:2:{s:10:\"cache_data\";a:0:{}s:12:\"cache_expire\";i:1351261771;}') ON DUPLICATE KEY UPDATE app=VALUES(app),type=VALUES(type),type_id=VALUES(type_id),rep_points=VALUES(rep_points),cache_date=VALUES(cache_date),rep_like_cache=VALUES(rep_like_cache)

INSERT INTO ibf_reputation_totals (`rt_key`,`rt_app_type`,`rt_type_id`,`rt_total`) VALUES('e186008d6d759xxxxxxxxxxxx','a17de1b4e5015b2ca6ba5xxxxxxxxxxxx',2222166,0) ON DUPLICATE KEY UPDATE rt_key=VALUES(rt_key),rt_app_type=VALUES(rt_app_type),rt_type_id=VALUES(rt_type_id),rt_total=VALUES(rt_total)

SELECT r.member_id, r.rep_rating,m.members_display_name, m.members_seo_name FROM ibf_reputation_index r LEFT JOIN ibf_members m ON ( m.member_id=r.member_id ) WHERE r.app='forums' AND r.type='pid' AND r.type_id='2222166'

INSERT INTO ibf_reputation_cache (`app`,`type`,`type_id`,`rep_points`,`cache_date`,`rep_like_cache`) VALUES('forums','pid',2222166,0,1351175371,'a:2:{s:10:\"cache_data\";a:0:{}s:12:\"cache_expire\";i:1351261771;}') ON DUPLICATE KEY UPDATE app=VALUES(app),type=VALUES(type),type_id=VALUES(type_id),rep_points=VALUES(rep_points),cache_date=VALUES(cache_date),rep_like_cache=VALUES(rep_like_cache)

SELECT SUM(rep_rating) as sum, COUNT(*) as count FROM ibf_reputation_index WHERE app='forums' AND type='pid' AND type_id='2222826'

SELECT r.member_id, r.rep_rating,m.members_display_name, m.members_seo_name FROM ibf_reputation_index r LEFT JOIN ibf_members m ON ( m.member_id=r.member_id ) WHERE r.app='forums' AND r.type='pid' AND r.type_id='2222826'

INSERT INTO ibf_reputation_cache (`app`,`type`,`type_id`,`rep_points`,`cache_date`,`rep_like_cache`) VALUES('forums','pid',2222826,0,1351175371,'a:2:{s:10:\"cache_data\";a:0:{}s:12:\"cache_expire\";i:1351261771;}') ON DUPLICATE KEY UPDATE app=VALUES(app),type=VALUES(type),type_id=VALUES(type_id),rep_points=VALUES(rep_points),cache_date=VALUES(cache_date),rep_like_cache=VALUES(rep_like_cache)

INSERT INTO ibf_reputation_totals (`rt_key`,`rt_app_type`,`rt_type_id`,`rt_total`) VALUES('b5ee81e6c4be6b87xxxxxxxxxxxx','a17de1b4e5015b2ca6bxxxxxxxxxxxx',2222826,0) ON DUPLICATE KEY UPDATE rt_key=VALUES(rt_key),rt_app_type=VALUES(rt_app_type),rt_type_id=VALUES(rt_type_id),rt_total=VALUES(rt_total)

SELECT r.member_id, r.rep_rating,m.members_display_name, m.members_seo_name FROM ibf_reputation_index r LEFT JOIN ibf_members m ON ( m.member_id=r.member_id ) WHERE r.app='forums' AND r.type='pid' AND r.type_id='2222826'

INSERT INTO ibf_reputation_cache (`app`,`type`,`type_id`,`rep_points`,`cache_date`,`rep_like_cache`) VALUES('forums','pid',2222826,0,1351175371,'a:2:{s:10:\"cache_data\";a:0:{}s:12:\"cache_expire\";i:1351261771;}') ON DUPLICATE KEY UPDATE app=VALUES(app),type=VALUES(type),type_id=VALUES(type_id),rep_points=VALUES(rep_points),cache_date=VALUES(cache_date),rep_like_cache=VALUES(rep_like_cache)

SELECT SUM(rep_rating) as sum, COUNT(*) as count FROM ibf_reputation_index WHERE app='forums' AND type='pid' AND type_id='2235381'

SELECT r.member_id, r.rep_rating,m.members_display_name, m.members_seo_name FROM ibf_reputation_index r LEFT JOIN ibf_members m ON ( m.member_id=r.member_id ) WHERE r.app='forums' AND r.type='pid' AND r.type_id='2235381'

INSERT INTO ibf_reputation_cache (`app`,`type`,`type_id`,`rep_points`,`cache_date`,`rep_like_cache`) VALUES('forums','pid',2235381,0,1351175371,'a:2:{s:10:\"cache_data\";a:0:{}s:12:\"cache_expire\";i:1351261771;}') ON DUPLICATE KEY UPDATE app=VALUES(app),type=VALUES(type),type_id=VALUES(type_id),rep_points=VALUES(rep_points),cache_date=VALUES(cache_date),rep_like_cache=VALUES(rep_like_cache)

INSERT INTO ibf_reputation_totals (`rt_key`,`rt_app_type`,`rt_type_id`,`rt_total`) VALUES('fafd0cb046f919d1xxxxxxxxxxxx','a17de1b4e5015b2ca6ba5xxxxxxxxxxxx',2235381,0) ON DUPLICATE KEY UPDATE rt_key=VALUES(rt_key),rt_app_type=VALUES(rt_app_type),rt_type_id=VALUES(rt_type_id),rt_total=VALUES(rt_total)

SELECT r.member_id, r.rep_rating,m.members_display_name, m.members_seo_name FROM ibf_reputation_index r LEFT JOIN ibf_members m ON ( m.member_id=r.member_id ) WHERE r.app='forums' AND r.type='pid' AND r.type_id='2235381'

INSERT INTO ibf_reputation_cache (`app`,`type`,`type_id`,`rep_points`,`cache_date`,`rep_like_cache`) VALUES('forums','pid',2235381,0,1351175371,'a:2:{s:10:\"cache_data\";a:0:{}s:12:\"cache_expire\";i:1351261771;}') ON DUPLICATE KEY UPDATE app=VALUES(app),type=VALUES(type),type_id=VALUES(type_id),rep_points=VALUES(rep_points),cache_date=VALUES(cache_date),rep_like_cache=VALUES(rep_like_cache)

SELECT SUM(rep_rating) as sum, COUNT(*) as count FROM ibf_reputation_index WHERE app='forums' AND type='pid' AND type_id='2326213'

SELECT r.member_id, r.rep_rating,m.members_display_name, m.members_seo_name FROM ibf_reputation_index r LEFT JOIN ibf_members m ON ( m.member_id=r.member_id ) WHERE r.app='forums' AND r.type='pid' AND r.type_id='2326213'

INSERT INTO ibf_reputation_cache (`app`,`type`,`type_id`,`rep_points`,`cache_date`,`rep_like_cache`) VALUES('forums','pid',2326213,0,1351175371,'a:2:{s:10:\"cache_data\";a:0:{}s:12:\"cache_expire\";i:1351261771;}') ON DUPLICATE KEY UPDATE app=VALUES(app),type=VALUES(type),type_id=VALUES(type_id),rep_points=VALUES(rep_points),cache_date=VALUES(cache_date),rep_like_cache=VALUES(rep_like_cache)

INSERT INTO ibf_reputation_totals (`rt_key`,`rt_app_type`,`rt_type_id`,`rt_total`) VALUES('26a328d66d47905xxxxxxxxxxxx','a17de1b4e5015b2ca6bxxxxxxxxxxxx',2326213,0) ON DUPLICATE KEY UPDATE rt_key=VALUES(rt_key),rt_app_type=VALUES(rt_app_type),rt_type_id=VALUES(rt_type_id),rt_total=VALUES(rt_total)

SELECT r.member_id, r.rep_rating,m.members_display_name, m.members_seo_name FROM ibf_reputation_index r LEFT JOIN ibf_members m ON ( m.member_id=r.member_id ) WHERE r.app='forums' AND r.type='pid' AND r.type_id='2326213'

INSERT INTO ibf_reputation_cache (`app`,`type`,`type_id`,`rep_points`,`cache_date`,`rep_like_cache`) VALUES('forums','pid',2326213,0,1351175371,'a:2:{s:10:\"cache_data\";a:0:{}s:12:\"cache_expire\";i:1351261771;}') ON DUPLICATE KEY UPDATE app=VALUES(app),type=VALUES(type),type_id=VALUES(type_id),rep_points=VALUES(rep_points),cache_date=VALUES(cache_date),rep_like_cache=VALUES(rep_like_cache)

SELECT SUM(rep_rating) as sum, COUNT(*) as count FROM ibf_reputation_index WHERE app='forums' AND type='pid' AND type_id='2326250'

SELECT r.member_id, r.rep_rating,m.members_display_name, m.members_seo_name FROM ibf_reputation_index r LEFT JOIN ibf_members m ON ( m.member_id=r.member_id ) WHERE r.app='forums' AND r.type='pid' AND r.type_id='2326250'

INSERT INTO ibf_reputation_cache (`app`,`type`,`type_id`,`rep_points`,`cache_date`,`rep_like_cache`) VALUES('forums','pid',2326250,0,1351175371,'a:2:{s:10:\"cache_data\";a:0:{}s:12:\"cache_expire\";i:1351261771;}') ON DUPLICATE KEY UPDATE app=VALUES(app),type=VALUES(type),type_id=VALUES(type_id),rep_points=VALUES(rep_points),cache_date=VALUES(cache_date),rep_like_cache=VALUES(rep_like_cache)

INSERT INTO ibf_reputation_totals (`rt_key`,`rt_app_type`,`rt_type_id`,`rt_total`) VALUES('fb564a0802bb8d6xxxxxxxxxxxx','a17de1b4e5015b2ca6baxxxxxxxxxxxx',2326250,0) ON DUPLICATE KEY UPDATE rt_key=VALUES(rt_key),rt_app_type=VALUES(rt_app_type),rt_type_id=VALUES(rt_type_id),rt_total=VALUES(rt_total)

SELECT r.member_id, r.rep_rating,m.members_display_name, m.members_seo_name FROM ibf_reputation_index r LEFT JOIN ibf_members m ON ( m.member_id=r.member_id ) WHERE r.app='forums' AND r.type='pid' AND r.type_id='2326250'

INSERT INTO ibf_reputation_cache (`app`,`type`,`type_id`,`rep_points`,`cache_date`,`rep_like_cache`) VALUES('forums','pid',2326250,0,1351175371,'a:2:{s:10:\"cache_data\";a:0:{}s:12:\"cache_expire\";i:1351261771;}') ON DUPLICATE KEY UPDATE app=VALUES(app),type=VALUES(type),type_id=VALUES(type_id),rep_points=VALUES(rep_points),cache_date=VALUES(cache_date),rep_like_cache=VALUES(rep_like_cache)

SELECT s.*, s.id as row_session_id,m.* FROM ibf_sessions s LEFT JOIN ibf_members m ON ( m.member_id=s.member_id ) WHERE s.id='fd33a90ba2xxxxxxxxxxxxc' OR (s.current_appcomponent='forums' AND s.running_time > 1351174471 AND s.in_error=0 AND s.location_1_type='topic' AND s.location_1_id=127539)

SELECT * FROM ibf_core_like_cache WHERE like_cache_id='c9da099xxxxxxxxxxxx'

SELECT * FROM ibf_core_like WHERE like_id='7dfe9174xxxxxxxxxxxx' AND like_visible=1

SELECT m.*, m.member_id as my_member_id,p.*,pp.*,g.*,ccb.cache_content FROM ibf_members m LEFT JOIN ibf_pfields_content p ON ( p.member_id=m.member_id ) LEFT JOINibf_profile_portal pp ON ( pp.pp_member_id=m.member_id ) LEFT JOIN ibf_groups g ON ( g.g_id=m.member_group_id ) LEFT JOIN ibf_content_cache_sigs ccb ON ( ccb.cache_content_id=m.member_id ) WHERE m.member_id=43422

SELECT member_id, dp3_pb_info, dp3_pb_disabled FROM ibf_members WHERE member_id IN (74304,43422)

SELECT * FROM ibf_core_editor_autosave WHERE eas_key='e91642d3xxxxxxxxxxxx'

SELECT s.s_id, s_enable, s.s_items, s.s_align, s.s_sep, s.s_rotate,i.* FROM ibf_dp3_adv_sections s LEFT JOIN ibf_permission_index i ON ( i.app='advadverts' AND i.perm_type_id=s.s_id ) WHERE i.perm_view REGEXP ',4,|\\*' AND s.s_code = "mp_top"

UPDATE ibf_dp3_adv_adverts SET a_views = a_views + 1 WHERE a_id = 1

INSERT INTO ibf_dp3_adv_views (`v_mid`,`v_aid`,`v_time`,`v_ip`,`v_browser`,`v_os`,`v_country`,`v_dua`) VALUES(2,1,1351175373,'178.235.20.46','chrome','windowsnt','PL','Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.4 (KHTML, like Gecko) Chrome/22.0.1229.94 Safari/537.4')

SELECT s.s_id, s_enable, s.s_items, s.s_align, s.s_sep, s.s_rotate,i.* FROM ibf_dp3_adv_sections s LEFT JOIN ibf_permission_index i ON ( i.app='advadverts' AND i.perm_type_id=s.s_id ) WHERE i.perm_view REGEXP ',4,|\\*' AND s.s_code = "allp_footer"

SELECT s.s_id, s_enable, s.s_items, s.s_align, s.s_sep, s.s_rotate,i.* FROM ibf_dp3_adv_sections s LEFT JOIN ibf_permission_index i ON ( i.app='advadverts' AND i.perm_type_id=s.s_id ) WHERE i.perm_view REGEXP ',4,|\\*' AND s.s_code = "tv_afr"

SELECT s.s_id, s_enable, s.s_items, s.s_align, s.s_sep, s.s_rotate,i.* FROM ibf_dp3_adv_sections s LEFT JOIN ibf_permission_index i ON ( i.app='advadverts' AND i.perm_type_id=s.s_id ) WHERE i.perm_view REGEXP ',4,|\\*' AND s.s_code = "tv_ufr"

SELECT s.s_id, s_enable, s.s_items, s.s_align, s.s_sep, s.s_rotate,i.* FROM ibf_dp3_adv_sections s LEFT JOIN ibf_permission_index i ON ( i.app='advadverts' AND i.perm_type_id=s.s_id ) WHERE i.perm_view REGEXP ',4,|\\*' AND s.s_code = "tv_awt"

SELECT t.*,p.pid, p.start_date as poll_start_date, p.choices, p.starter_id as poll_starter_id, p.votes, p.poll_question, p.poll_only, p.poll_view_voters FROM ibf_topics t LEFT JOIN ibf_polls p ON ( p.tid=t.tid ) WHERE t.tid=127539

SELECT aa.id, aa.keywords, aa.url, aa.count, aa.type, aa.type_id, aa.second_type_id,t.title as topic_title, t.tid as topic_id, t.title_seo FROM ibf_dp3_ass_search_visitors aa LEFT JOIN ibf_topics t ON ( t.tid = aa.type_id ) WHERE aa.type_id = 127539 AND aa.type = "showtopic" ORDER BY aa.date DESC LIMIT 0,10

SELECT aa.id, aa.keywords, aa.url, aa.count, aa.type, aa.type_id, aa.second_type_id,t.title as topic_title, t.tid as topic_id, t.title_seo FROM ibf_dp3_ass_search_visitors aa LEFT JOIN ibf_topics t ON ( t.tid = aa.type_id ) WHERE ( aa.type_id IN (173,174,215,218,48) OR aa.second_type_id IN (173,174,215,218,48) ) AND ( aa.type = "showforum" OR aa.type = "showtopic" ) ORDER BY aa.date DESC LIMIT 0,10

SELECT blog_id FROM ibf_blog_blogs WHERE FIND_IN_SET(2, blog_authorized_users)

SELECT blog_id FROM ibf_blog_blogs WHERE FIND_IN_SET(2, blog_authorized_users)

SELECT blog_id FROM ibf_blog_blogs WHERE FIND_IN_SET(2, blog_authorized_users)

SELECT * FROM ibf_blog_this WHERE bt_app='forums' AND bt_id1=127539

SHUTDOWN: UPDATE ibf_topics SET views=views+1 WHERE tid=127539

Edytowane przez angel554
Gość
Ten temat został zamknięty. Brak możliwości dodania odpowiedzi.
 Udostępnij
Tematy

  • Ostatnio przeglądający   0 użytkowników

    • Brak zarejestrowanych użytkowników przeglądających tę stronę.
×
×
  • Dodaj nową pozycję...

Powiadomienie o plikach cookie

Umieściliśmy na Twoim urządzeniu pliki cookie, aby pomóc Ci usprawnić przeglądanie strony. Możesz dostosować ustawienia plików cookie, w przeciwnym wypadku zakładamy, że wyrażasz na to zgodę.