Really URGENT - WEBSITE SUSPENDED

geoff777 · 2008-12-19 05:58:08

My txp website has been suspended because it is causing MYSQL problems with slow queries.

I´m with Hostmonster

They won´t reactivate until I optimise my db

Optimising my db is the only option to get me back.

Some caching in the future will help but NOW it is optimising my db.

Any suggestions about adding a few extra indexes?

Help ASAP please – this is a disaster I´ve been working hard on this for months.

Thanks Geoff

Anyone else got a busy TXP installation on a decent low cost host?

Just run a check on it the results :- looking at logs now …

gaucinca_gibtext2.md_articles_expirations OK gaucinca_gibtext2.rah_sitemap OK gaucinca_gibtext2.rah_sitemap_prefs OK gaucinca_gibtext2.textpattern warning : 10 clients are using or haven't closed the table properly status : OK gaucinca_gibtext2.txp_category OK gaucinca_gibtext2.txp_css OK gaucinca_gibtext2.txp_discuss OK gaucinca_gibtext2.txp_discuss_ipban OK gaucinca_gibtext2.txp_discuss_nonce warning : 10 clients are using or haven't closed the table properly status : OK gaucinca_gibtext2.txp_file warning : 1 client is using or hasn't closed the table properly status : OK gaucinca_gibtext2.txp_form warning : 5 clients are using or haven't closed the table properly status : OK gaucinca_gibtext2.txp_hak_tinymce OK gaucinca_gibtext2.txp_image OK gaucinca_gibtext2.txp_lang OK gaucinca_gibtext2.txp_link warning : 1 client is using or hasn't closed the table properly status : OK gaucinca_gibtext2.txp_log OK gaucinca_gibtext2.txp_note OK gaucinca_gibtext2.txp_page warning : 6 clients are using or haven't closed the table properly status : OK gaucinca_gibtext2.txp_plugin OK gaucinca_gibtext2.txp_prefs warning : 8 clients are using or haven't closed the table properly status : OK gaucinca_gibtext2.txp_section warning : 1 client is using or hasn't closed the table properly status : OK gaucinca_gibtext2.txp_users OK gaucinca_gibtext2.zem_event_calendar OK gaucinca_gibtext2.zem_event_category OK gaucinca_gibtext2.zem_event_date OK

This is just one of yesterday´s MYSQL slow queries log

text/x-log 20081218-21.log
ASCII C++ program text, with very long lines, with CRLF, LF line terminators

# Thu Dec 18 21:00:25 2008
# Query_time: 2  Lock_time: 0  Rows_sent: 165  Rows_examined: 165
use gaucinca_gibtext2;
select name, val from txp_prefs where prefs_id=1

# Thu Dec 18 21:00:28 2008
# Query_time: 3  Lock_time: 1  Rows_sent: 324  Rows_examined: 1063
use gaucinca_gibtext2;
select name, data from txp_lang where lang='en-gb' AND ( event='public' OR event='common')

# Thu Dec 18 21:00:44 2008
# Query_time: 3  Lock_time: 1  Rows_sent: 1  Rows_examined: 1
use gaucinca_gibtext2;
select unix_timestamp(Posted) from textpattern where Posted <= now() and Status >= 4 order by Posted desc limit 1

# Thu Dec 18 21:00:45 2008
# Query_time: 2  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
use gaucinca_gibtext2;
update textpattern set Status=2 where ID in (select article_id from md_articles_expirations where active=1 and expiration_date <= now())

# Thu Dec 18 21:00:47 2008
# Query_time: 4  Lock_time: 1  Rows_sent: 1  Rows_examined: 5
use gaucinca_gibtext2;
select ID, Title, url_title, unix_timestamp(Posted) as uposted
  from textpattern where Posted < '2008-12-10 09:54:44' and Section = 'music-cd-sales' and Status=4 and Posted < now() order by Posted desc limit 1

# Thu Dec 18 21:00:49 2008
# Query_time: 3  Lock_time: 1  Rows_sent: 1  Rows_examined: 1
use gaucinca_gibtext2;
select Form from txp_form where name='fp_header_1'

# Thu Dec 18 21:00:49 2008
# Query_time: 3  Lock_time: 1  Rows_sent: 1  Rows_examined: 1
use gaucinca_gibtext2;
select * from txp_section where name = 'music-cd-sales' limit 1

# Thu Dec 18 21:00:53 2008
# Query_time: 4  Lock_time: 0  Rows_sent: 1  Rows_examined: 1
use gaucinca_gibtext2;
select Form from txp_form where name='fp_meta'

# Thu Dec 18 21:00:55 2008
# Query_time: 6  Lock_time: 1  Rows_sent: 1  Rows_examined: 1
use gaucinca_gibtext2;
select unix_timestamp(Posted) from textpattern where Posted <= now() and Status >= 4 order by Posted desc limit 1

# Thu Dec 18 21:00:55 2008
# Query_time: 6  Lock_time: 1  Rows_sent: 1  Rows_examined: 1
use gaucinca_gibtext2;
select user_html from txp_page where name='Music CD Sales'

# Thu Dec 18 21:00:55 2008
# Query_time: 6  Lock_time: 2  Rows_sent: 1  Rows_examined: 5
use gaucinca_gibtext2;
select ID, Title, url_title, unix_timestamp(Posted) as uposted
  from textpattern where Posted > '2008-12-10 09:54:44' and Section = 'music-cd-sales' and Status=4 and Posted < now() order by Posted asc limit 1

# Thu Dec 18 21:00:57 2008
# Query_time: 2  Lock_time: 0  Rows_sent: 1  Rows_examined: 5
use gaucinca_gibtext2;
select ID, Title, url_title, unix_timestamp(Posted) as uposted
  from textpattern where Posted < '2008-12-10 09:54:44' and Section = 'music-cd-sales' and Status=4 and Posted < now() order by Posted desc limit 1

# Thu Dec 18 21:00:58 2008
# Query_time: 3  Lock_time: 1  Rows_sent: 1  Rows_examined: 1
use gaucinca_gibtext2;
select Form from txp_form where name='fp_header_2'

# Thu Dec 18 21:00:59 2008
# Query_time: 4  Lock_time: 1  Rows_sent: 1  Rows_examined: 1
use gaucinca_gibtext2;
select Form from txp_form where name='fp_header_2'

# Thu Dec 18 21:00:59 2008
# Query_time: 6  Lock_time: 3  Rows_sent: 1  Rows_examined: 1
use gaucinca_gibtext2;
select Form from txp_form where name='fp_header_2'

# Thu Dec 18 21:01:02 2008
# Query_time: 3  Lock_time: 1  Rows_sent: 1  Rows_examined: 1
use gaucinca_gibtext2;
select Form from txp_form where name='fp_lhs'

# Thu Dec 18 21:01:02 2008
# Query_time: 3  Lock_time: 1  Rows_sent: 1  Rows_examined: 1
use gaucinca_gibtext2;
select Form from txp_form where name='fp_lhs'

# Thu Dec 18 21:01:07 2008
# Query_time: 3  Lock_time: 1  Rows_sent: 1  Rows_examined: 1
use gaucinca_gibtext2;
select name, title from txp_section where name in ('Recruitment') order by field(name, 'Recruitment')

# Thu Dec 18 21:01:08 2008
# Query_time: 4  Lock_time: 1  Rows_sent: 1  Rows_examined: 1
use gaucinca_gibtext2;
select name, title from txp_section where name in ('Recruitment') order by field(name, 'Recruitment')

# Thu Dec 18 21:01:09 2008
# Query_time: 2  Lock_time: 0  Rows_sent: 1  Rows_examined: 1
use gaucinca_gibtext2;
select name, title from txp_section where name in ('Tourist-Guide') order by field(name, 'Tourist-Guide')

# Thu Dec 18 21:01:09 2008
# Query_time: 4  Lock_time: 2  Rows_sent: 1  Rows_examined: 5
use gaucinca_gibtext2;
select ID, Title, url_title, unix_timestamp(Posted) as uposted
  from textpattern where Posted < '2008-12-10 09:54:44' and Section = 'music-cd-sales' and Status=4 and Posted < now() order by Posted desc limit 1

# Thu Dec 18 21:01:09 2008
# Query_time: 4  Lock_time: 2  Rows_sent: 1  Rows_examined: 1
use gaucinca_gibtext2;
select title from txp_section where name='diamonds-gems'

# Thu Dec 18 21:01:13 2008
# Query_time: 3  Lock_time: 1  Rows_sent: 2  Rows_examined: 4
use gaucinca_gibtext2;
select name, title from txp_section where name in ('Places-To-Stay','The-Rock-Of-Gibraltar-Tours') order by field(name, 'Places-To-Stay','The-Rock-Of-Gibraltar-Tours')

# Thu Dec 18 21:01:13 2008
# Query_time: 3  Lock_time: 1  Rows_sent: 5  Rows_examined: 10
use gaucinca_gibtext2;
select name, title from txp_section where name in ('Pubs-Cafes-Bars','Eating-Out','Take-Away-Food','Recipes','Special-Diets') order by field(name, 'Pubs-Cafes-Bars','Eating-Out','Take-Away-Food','Recipes','Special-Diets')

# Thu Dec 18 21:01:13 2008
# Query_time: 3  Lock_time: 1  Rows_sent: 5  Rows_examined: 10
use gaucinca_gibtext2;
select name, title from txp_section where name in ('Pubs-Cafes-Bars','Eating-Out','Take-Away-Food','Recipes','Special-Diets') order by field(name, 'Pubs-Cafes-Bars','Eating-Out','Take-Away-Food','Recipes','Special-Diets')

# Thu Dec 18 21:01:13 2008
# Query_time: 3  Lock_time: 1  Rows_sent: 250  Rows_examined: 624
use gaucinca_gibforum370;
SELECT threadid, title, prefixid, lastpost, replycount
  FROM thread AS thread
  WHERE forumid = 8
  AND visible = 1
  AND open <> 10
  ORDER BY dateline ASC
  LIMIT 0,250

# Thu Dec 18 21:01:23 2008
# Query_time: 4  Lock_time: 0  Rows_sent: 1  Rows_examined: 1
use gaucinca_gibtext2;
select Form from txp_form where name='fp_leaderboard_ad'

# Thu Dec 18 21:01:23 2008
# Query_time: 4  Lock_time: 0  Rows_sent: 1  Rows_examined: 1
use gaucinca_gibtext2;
select Form from txp_form where name='fp_ms_tables_top'

# Thu Dec 18 21:01:23 2008
# Query_time: 4  Lock_time: 0  Rows_sent: 1  Rows_examined: 1
use gaucinca_gibtext2;
select Form from txp_form where name='fp_ms_tables_top'

# Thu Dec 18 21:01:27 2008
# Query_time: 2  Lock_time: 0  Rows_sent: 1  Rows_examined: 1
use gaucinca_gibtext2;
select title from txp_section where name='Music-CD-Sales'

# Thu Dec 18 21:01:27 2008
# Query_time: 3  Lock_time: 1  Rows_sent: 1  Rows_examined: 6
use gaucinca_gibtext2;
select *, unix_timestamp(Posted) as uPosted from textpattern where 1=1 and Status = 4 and Posted <= now() and Section IN ('diamonds-gems') order by Posted desc limit 0, 1

# Thu Dec 18 21:01:27 2008
# Query_time: 3  Lock_time: 1  Rows_sent: 0  Rows_examined: 0
use gaucinca_gibtext2;
update textpattern set Status=2 where ID in (select article_id from md_articles_expirations where active=1 and expiration_date <= now())

# Thu Dec 18 21:01:27 2008
# Query_time: 3  Lock_time: 1  Rows_sent: 1  Rows_examined: 6
use gaucinca_gibtext2;
select *, unix_timestamp(Posted) as uPosted from textpattern where 1=1 and Status = 4 and Posted <= now() and Section IN ('diamonds-gems') order by Posted desc limit 0, 1

# Thu Dec 18 21:01:28 2008
# Query_time: 4  Lock_time: 1  Rows_sent: 1  Rows_examined: 1
use gaucinca_gibtext2;
select title from txp_section where name='Music-CD-Sales'

# Thu Dec 18 21:01:29 2008
# Query_time: 3  Lock_time: 1  Rows_sent: 1  Rows_examined: 5
use gaucinca_gibtext2;
select ID, Title, url_title, unix_timestamp(Posted) as uposted
  from textpattern where Posted > '2008-12-10 09:54:44' and Section = 'music-cd-sales' and Status=4 and Posted < now() order by Posted asc limit 1

# Thu Dec 18 21:01:30 2008
# Query_time: 3  Lock_time: 1  Rows_sent: 1  Rows_examined: 1
use gaucinca_gibtext2;
select title from txp_section where name='Diamonds-Gems'

# Thu Dec 18 21:01:33 2008
# Query_time: 4  Lock_time: 2  Rows_sent: 0  Rows_examined: 0
use gaucinca_gibforum370;
SELECT *
  FROM session
  WHERE userid = 0
  AND host = '38.99.13.124'
  AND idhash = 'f23372265384e05136b423326ec82eed'
  LIMIT 1

# Thu Dec 18 21:01:34 2008
# Query_time: 2  Lock_time: 0  Rows_sent: 1  Rows_examined: 1
use gaucinca_gibtext2;
select Form from txp_form where name='fp_ms_table_bottom'

# Thu Dec 18 21:01:35 2008
# Query_time: 3  Lock_time: 1  Rows_sent: 1  Rows_examined: 1
use gaucinca_gibtext2;
select Form from txp_form where name='fp_google_below_ms'

# Thu Dec 18 21:01:35 2008
# Query_time: 4  Lock_time: 2  Rows_sent: 0  Rows_examined: 0
use gaucinca_gibtext2;
select *, unix_timestamp(Posted) as uPosted from textpattern where 1=1 and Status = 4 and Posted <= now() and Section IN ('DVD-Rentals') and Excerpt !='' order by Posted desc limit 1, 5

# Thu Dec 18 21:01:37 2008
# Query_time: 4  Lock_time: 2  Rows_sent: 1  Rows_examined: 1
use gaucinca_gibtext2;
select Form from txp_form where name='fp_rhs_tables_top'

# Thu Dec 18 21:01:37 2008
# Query_time: 2  Lock_time: 0  Rows_sent: 1  Rows_examined: 1
use gaucinca_gibtext2;
select Form from txp_form where name='spacer_306'

# Thu Dec 18 21:01:37 2008
# Query_time: 2  Lock_time: 0  Rows_sent: 1  Rows_examined: 1
use gaucinca_gibtext2;
select Form from txp_form where name='spacer_306'

# Thu Dec 18 21:01:40 2008
# Query_time: 2  Lock_time: 0  Rows_sent: 1  Rows_examined: 1
use gaucinca_gibtext2;
select Form from txp_form where name='fp_exerpt'

# Thu Dec 18 21:01:40 2008
# Query_time: 2  Lock_time: 0  Rows_sent: 1  Rows_examined: 1
use gaucinca_gibtext2;
select Form from txp_form where name='fp_rhs_music_cd_sales_archive'

# Thu Dec 18 21:01:40 2008
# Query_time: 2  Lock_time: 0  Rows_sent: 1  Rows_examined: 1
select Form from txp_form where name='fp_rhs_music_cd_sales_archive'

# Thu Dec 18 21:01:40 2008
# Query_time: 3  Lock_time: 1  Rows_sent: 1  Rows_examined: 1
use gaucinca_gibtext2;
select Form from txp_form where name='fp_rhs_music_cd_sales_title_306'

# Thu Dec 18 21:01:42 2008
# Query_time: 2  Lock_time: 0  Rows_sent: 1  Rows_examined: 1
use gaucinca_gibtext2;
select Form from txp_form where name='fp_rhs_fashion_jewellery_title_306'

# Thu Dec 18 21:01:43 2008
# Query_time: 6  Lock_time: 1  Rows_sent: 88  Rows_examined: 88
use gaucinca_gibforum370;
SELECT title, template
  FROM template
  WHERE templateid IN (5343,5344,5346,5345,5427,5802,5458,5459,5461,5468,5467,4975,5632,5618,5619,5621,5620,5623,5625,5626,5627,4976,5631,5365,5367,5369,5371,5659,5661,5664,5665,5662,5660,5712,5713,5611,5610,5612,5616,5614,5740,5405,5404,5406,5407,4981,5259,5252,5341,5340,5227,5337,5336,5603,4973,5557,5558,5559,5801,5804,5813,5578,5579,5580,5581,5755,5818,5817,5819,5822,5247,5239,5246,5243,1065,1064,0,5394,5395,5432,5096,5105,5095,0,5099,5100,2704,5169,5173,5172)

# Thu Dec 18 21:01:47 2008
# Query_time: 2  Lock_time: 0  Rows_sent: 1  Rows_examined: 1
use gaucinca_gibtext2;
select Form from txp_form where name='fp_rhs_gold_silver_title_306'

# Thu Dec 18 21:01:48 2008
# Query_time: 2  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
use gaucinca_gibtext2;
select ID, title, authorid, unix_timestamp(Posted) as posted, section, category1, category2, url_title, excerpt, comments_count from textpattern where status=4  AND ( (section = 'DVD-Rentals') )     AND posted < now()   ORDER BY posted desc   LIMIT 31

# Thu Dec 18 21:01:48 2008
# Query_time: 2  Lock_time: 0  Rows_sent: 1  Rows_examined: 1
select Form from txp_form where name='fp_rhs_gold_silver_latest'

# Thu Dec 18 21:01:48 2008
# Query_time: 2  Lock_time: 0  Rows_sent: 1  Rows_examined: 1
use gaucinca_gibtext2;
select Form from txp_form where name='fp_rhs_gold_silver_latest'

# Thu Dec 18 21:01:51 2008
# Query_time: 2  Lock_time: 0  Rows_sent: 1  Rows_examined: 1
use gaucinca_gibtext2;
select Form from txp_form where name='fp_rhs_ipods_latest'

# Thu Dec 18 21:01:53 2008
# Query_time: 2  Lock_time: 0  Rows_sent: 1  Rows_examined: 1
use gaucinca_gibtext2;
select Form from txp_form where name='fp_rhs_mobile_phones_title_306'

# Thu Dec 18 21:01:53 2008
# Query_time: 2  Lock_time: 0  Rows_sent: 1  Rows_examined: 2
use gaucinca_gibtext2;
select ID, title, authorid, unix_timestamp(Posted) as posted, section, category1, category2, url_title, excerpt, comments_count from textpattern where status=4  AND ( (section = 'iPods') )     AND posted < now()   ORDER BY posted desc   LIMIT 31

# Thu Dec 18 21:01:53 2008
# Query_time: 3  Lock_time: 1  Rows_sent: 12  Rows_examined: 25
use gaucinca_gibforum370;
SELECT c.*, g.gname, cat.password FROM games_champs AS c, games_list AS g, games_cats AS cat
  WHERE (c.champ_gid=g.gid) AND (g.gcat=cat.c_id) AND trim(password)='' AND g.active=1

# Thu Dec 18 21:01:55 2008
# Query_time: 2  Lock_time: 0  Rows_sent: 2  Rows_examined: 4
use gaucinca_gibtext2;
select ID, title, authorid, unix_timestamp(Posted) as posted, section, category1, category2, url_title, excerpt, comments_count from textpattern where status=4  AND ( (section = 'Mobile-Phones') )     AND posted < now()   ORDER BY posted desc   LIMIT 31

# Thu Dec 18 21:01:57 2008
# Query_time: 3  Lock_time: 1  Rows_sent: 1  Rows_examined: 1
use gaucinca_gibtext2;
select Form from txp_form where name='fp_rhs_fashion_latest'

# Thu Dec 18 21:01:57 2008
# Query_time: 3  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
use gaucinca_gibforum370;
SELECT * FROM cellsettings
		WHERE userid = '3'
		LIMIT 1

# Thu Dec 18 21:01:57 2008
# Query_time: 4  Lock_time: 1  Rows_sent: 2  Rows_examined: 4
use gaucinca_gibtext2;
select ID, title, authorid, unix_timestamp(Posted) as posted, section, category1, category2, url_title, excerpt, comments_count from textpattern where status=4  AND ( (section = 'Perfume') )     AND posted < now()   ORDER BY posted desc   LIMIT 31

# Thu Dec 18 21:01:57 2008
# Query_time: 4  Lock_time: 2  Rows_sent: 1  Rows_examined: 1
use gaucinca_gibtext2;
select Form from txp_form where name='fp_rhs_flat_plasma_tvs_title_306'

# Thu Dec 18 21:01:57 2008
# Query_time: 2  Lock_time: 0  Rows_sent: 3  Rows_examined: 6
select ID, title, authorid, unix_timestamp(Posted) as posted, section, category1, category2, url_title, excerpt, comments_count from textpattern where status=4  AND ( (section = 'Fashion')  OR  (section = 'Designer-Labels')  OR  (section = 'Shoes')  OR  (section = 'Bags')  OR  (section = 'Designer-Of-The-Year') )     AND posted < now()   ORDER BY posted desc   LIMIT 31

# Thu Dec 18 21:01:57 2008
# Query_time: 2  Lock_time: 0  Rows_sent: 1  Rows_examined: 1
use gaucinca_gibtext2;
select Form from txp_form where name='fp_rhs_flat_plasma_tvs_latest'

# Thu Dec 18 21:01:57 2008
# Query_time: 4  Lock_time: 1  Rows_sent: 2  Rows_examined: 4
use gaucinca_gibtext2;
select ID, title, authorid, unix_timestamp(Posted) as posted, section, category1, category2, url_title, excerpt, comments_count from textpattern where status=4  AND ( (section = 'Perfume') )     AND posted < now()   ORDER BY posted desc   LIMIT 31

# Thu Dec 18 21:01:57 2008
# Query_time: 3  Lock_time: 1  Rows_sent: 1  Rows_examined: 1
use gaucinca_gibtext2;
select Form from txp_form where name='fp_rhs_flat_plasma_tvs_title_306'

# Thu Dec 18 21:02:00 2008
# Query_time: 3  Lock_time: 1  Rows_sent: 0  Rows_examined: 0
use gaucinca_gibforum370;
SELECT * FROM zoints_tag WHERE threadid = 93940 ORDER BY tag

# Thu Dec 18 21:02:00 2008
# Query_time: 3  Lock_time: 1  Rows_sent: 1  Rows_examined: 1
use gaucinca_gibtext2;
select Form from txp_form where name='fp_rhs_laptops_title_306'

# Thu Dec 18 21:02:00 2008
# Query_time: 3  Lock_time: 1  Rows_sent: 0  Rows_examined: 0
use gaucinca_gibtext2;
select ID, title, authorid, unix_timestamp(Posted) as posted, section, category1, category2, url_title, excerpt, comments_count from textpattern where status=4  AND ( (section = 'Flat-Plasma-TVs') )     AND posted < now()   ORDER BY posted desc   LIMIT 31

# Thu Dec 18 21:02:01 2008
# Query_time: 4  Lock_time: 2  Rows_sent: 0  Rows_examined: 0
select ID, title, authorid, unix_timestamp(Posted) as posted, section, category1, category2, url_title, excerpt, comments_count from textpattern where status=4  AND ( (section = 'Flat-Plasma-TVs') )     AND posted < now()   ORDER BY posted desc   LIMIT 31

# Thu Dec 18 21:02:02 2008
# Query_time: 5  Lock_time: 2  Rows_sent: 3  Rows_examined: 6
use gaucinca_gibtext2;
select ID, title, authorid, unix_timestamp(Posted) as posted, section, category1, category2, url_title, excerpt, comments_count from textpattern where status=4  AND ( (section = 'Fashion')  OR  (section = 'Designer-Labels')  OR  (section = 'Shoes')  OR  (section = 'Bags')  OR  (section = 'Designer-Of-The-Year') )     AND posted < now()   ORDER BY posted desc   LIMIT 31

# Thu Dec 18 21:02:02 2008
# Query_time: 3  Lock_time: 1  Rows_sent: 3  Rows_examined: 6
use gaucinca_gibtext2;
select ID, title, authorid, unix_timestamp(Posted) as posted, section, category1, category2, url_title, excerpt, comments_count from textpattern where status=4  AND ( (section = 'Fashion')  OR  (section = 'Designer-Labels')  OR  (section = 'Shoes')  OR  (section = 'Bags')  OR  (section = 'Designer-Of-The-Year') )     AND posted < now()   ORDER BY posted desc   LIMIT 31

# Thu Dec 18 21:02:03 2008
# Query_time: 3  Lock_time: 1  Rows_sent: 0  Rows_examined: 0
use gaucinca_gibforum370;
INSERT IGNORE INTO session
  (sessionhash, userid, host, idhash, lastactivity, location, styleid, languageid, loggedin, inforum, inthread, incalendar, badlocation, useragent, bypass, profileupdate)
  VALUES
  ('80fc9bdb1a6757b954b84087b1e51007', 0, '38.99.13.124', 'f23372265384e05136b423326ec82eed', 1229659285, '/forums/showthread.php?t=93940', 0, 2, 0, 4, 93940, 0, 0, 'Mozilla/5.0 (Twiceler-0.9 http://www.cuil.com/twiceler/robot.html)', 0, 0)

# Thu Dec 18 21:02:03 2008
# Query_time: 4  Lock_time: 1  Rows_sent: 0  Rows_examined: 0
use gaucinca_gibtext2;
select ID, title, authorid, unix_timestamp(Posted) as posted, section, category1, category2, url_title, excerpt, comments_count from textpattern where status=4  AND ( (section = 'Designer-Labels') )     AND posted < now()   ORDER BY posted desc   LIMIT 31

# Thu Dec 18 21:02:06 2008
# Query_time: 2  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
use gaucinca_gibtext2;
select ID, title, authorid, unix_timestamp(Posted) as posted, section, category1, category2, url_title, excerpt, comments_count from textpattern where status=4  AND ( (section = 'Laptops') )     AND posted < now()   ORDER BY posted desc   LIMIT 31

# Thu Dec 18 21:02:06 2008
# Query_time: 3  Lock_time: 1  Rows_sent: 0  Rows_examined: 0
use gaucinca_gibforum370;
UPDATE thread
		SET views = views + 1
		WHERE threadid = 93940

# Thu Dec 18 21:02:07 2008
# Query_time: 6  Lock_time: 3  Rows_sent: 0  Rows_examined: 2
use gaucinca_gibforum370;
SELECT *
  FROM session
  WHERE userid = 0
  AND host = '74.6.22.158'
  AND idhash = '93e825888b6325b45c138fca3c22afaa'
  LIMIT 1

# Thu Dec 18 21:02:09 2008
# Query_time: 2  Lock_time: 0  Rows_sent: 5  Rows_examined: 11
use gaucinca_gibtext2;
select ID, title, authorid, unix_timestamp(Posted) as posted, section, category1, category2, url_title, excerpt, comments_count from textpattern where status=4  AND ( (section = 'Games-Consoles')  OR  (section = 'Xbox')  OR  (section = 'Nintendo-Wii')  OR  (section = 'Playstation') )     AND posted < now()   ORDER BY posted desc   LIMIT 31

# Thu Dec 18 21:02:09 2008
# Query_time: 6  Lock_time: 4  Rows_sent: 0  Rows_examined: 0
use gaucinca_gibtext2;
select ID, title, authorid, unix_timestamp(Posted) as posted, section, category1, category2, url_title, excerpt, comments_count from textpattern where status=4  AND ( (section = 'Designer-Labels') )     AND posted < now()   ORDER BY posted desc   LIMIT 31

# Thu Dec 18 21:02:11 2008
# Query_time: 3  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
use gaucinca_gibtext2;
select ID, title, authorid, unix_timestamp(Posted) as posted, section, category1, category2, url_title, excerpt, comments_count from textpattern where status=4  AND ( (section = 'Cameras-Lenses') )     AND posted < now()   ORDER BY posted desc   LIMIT 31

# Thu Dec 18 21:02:11 2008
# Query_time: 3  Lock_time: 0  Rows_sent: 1  Rows_examined: 1
select Form from txp_form where name='fp_rhs_shoes_latest'

# Thu Dec 18 21:02:12 2008
# Query_time: 3  Lock_time: 0  Rows_sent: 1  Rows_examined: 2
use gaucinca_gibtext2;
select ID, title, authorid, unix_timestamp(Posted) as posted, section, category1, category2, url_title, excerpt, comments_count from textpattern where status=4  AND ( (section = 'Shoes') )     AND posted < now()   ORDER BY posted desc   LIMIT 31

# Thu Dec 18 21:02:12 2008
# Query_time: 4  Lock_time: 1  Rows_sent: 1  Rows_examined: 1
use gaucinca_gibforum370;
SELECT languageid,
  phrasegroup_global AS phrasegroup_global,
  phrasegroup_threadmanage AS phrasegroup_threadmanage,
  phrasegroup_posting AS phrasegroup_posting,
  phrasegroup_showthread AS phrasegroup_showthread,
  phrasegroup_prefix AS phrasegroup_prefix,
  options AS lang_options,
  languagecode AS lang_code,
  charset AS lang_charset,
  locale AS lang_locale,
  imagesoverride AS lang_imagesoverride,
  dateoverride AS lang_dateoverride,
  timeoverride AS lang_timeoverride,
  registereddateoverride AS lang_registereddateoverride,
  calformat1override AS lang_calformat1override,
  calformat2override AS lang_calformat2override,
  logdateoverride AS lang_logdateoverride,
  decimalsep AS lang_decimalsep,
  thousandsep AS lang_thousandsep
  FROM language
  WHERE languageid = 2

# Thu Dec 18 21:02:12 2008
# Query_time: 3  Lock_time: 0  Rows_sent: 1  Rows_examined: 1
use gaucinca_gibtext2;
select Form from txp_form where name='fp_rhs_clothing_title_306'

# Thu Dec 18 21:02:13 2008
# Query_time: 2  Lock_time: 0  Rows_sent: 1  Rows_examined: 1
use gaucinca_gibtext2;
select Form from txp_form where name='fp_rhs_games_consoles_title_306'

# Thu Dec 18 21:02:13 2008
# Query_time: 5  Lock_time: 3  Rows_sent: 0  Rows_examined: 0
use gaucinca_gibtext2;
select ID, title, authorid, unix_timestamp(Posted) as posted, section, category1, category2, url_title, excerpt, comments_count from textpattern where status=4  AND ( (section = 'Cameras-Lenses') )     AND posted < now()   ORDER BY posted desc   LIMIT 31

# Thu Dec 18 21:02:13 2008
# Query_time: 2  Lock_time: 0  Rows_sent: 1  Rows_examined: 2
select ID, title, authorid, unix_timestamp(Posted) as posted, section, category1, category2, url_title, excerpt, comments_count from textpattern where status=4  AND ( (section = 'Shoes') )     AND posted < now()   ORDER BY posted desc   LIMIT 31

# Thu Dec 18 21:02:14 2008
# Query_time: 5  Lock_time: 3  Rows_sent: 1  Rows_examined: 1
use gaucinca_gibforum370;
SELECT *
		FROM style
		WHERE (styleid = 16 AND userselect = 1)
  OR styleid = 16
		ORDER BY styleid ASC
		LIMIT 1

# Thu Dec 18 21:02:14 2008
# Query_time: 2  Lock_time: 0  Rows_sent: 1  Rows_examined: 1
use gaucinca_gibtext2;
select Form from txp_form where name='fp_rhs_clothing_latest'

# Thu Dec 18 21:02:16 2008
# Query_time: 7  Lock_time: 4  Rows_sent: 1  Rows_examined: 1
use gaucinca_gibtext2;
select Form from txp_form where name='fp_rhs_shoes_latest'

# Thu Dec 18 21:02:16 2008
# Query_time: 4  Lock_time: 2  Rows_sent: 39  Rows_examined: 39
use gaucinca_gibforum370;
SELECT title, template
  FROM template
  WHERE templateid IN (5565,5566,5577,4981,5259,5252,5341,5340,5227,5337,5336,5603,4973,5557,5558,5559,5801,5804,5813,5578,5579,5580,5581,5755,5818,5817,5819,5822,5246,5243,1065,1064,0,5394,5395,5432,5096,5105,2704,5169)

# Thu Dec 18 21:02:16 2008
# Query_time: 3  Lock_time: 1  Rows_sent: 5  Rows_examined: 11
use gaucinca_gibtext2;
select ID, title, authorid, unix_timestamp(Posted) as posted, section, category1, category2, url_title, excerpt, comments_count from textpattern where status=4  AND ( (section = 'Games-Consoles')  OR  (section = 'Xbox')  OR  (section = 'Nintendo-Wii')  OR  (section = 'Playstation') )     AND posted < now()   ORDER BY posted desc   LIMIT 31

# Thu Dec 18 21:02:17 2008
# Query_time: 4  Lock_time: 1  Rows_sent: 5  Rows_examined: 11
use gaucinca_gibtext2;
select ID, title, authorid, unix_timestamp(Posted) as posted, section, category1, category2, url_title, excerpt, comments_count from textpattern where status=4  AND ( (section = 'Games-Consoles')  OR  (section = 'Xbox')  OR  (section = 'Nintendo-Wii')  OR  (section = 'Playstation') )     AND posted < now()   ORDER BY posted desc   LIMIT 31

# Thu Dec 18 21:02:17 2008
# Query_time: 4  Lock_time: 2  Rows_sent: 0  Rows_examined: 0
use gaucinca_gibtext2;
select ID, title, authorid, unix_timestamp(Posted) as posted, section, category1, category2, url_title, excerpt, comments_count from textpattern where status=4  AND ( (section = 'Gift-Shops') )     AND posted < now()   ORDER BY posted desc   LIMIT 31

# Thu Dec 18 21:02:18 2008
# Query_time: 4  Lock_time: 2  Rows_sent: 36  Rows_examined: 36
use gaucinca_gibforum370;
SELECT title, template
  FROM template
  WHERE templateid IN (4981,5259,5252,5341,5340,5227,5337,5336,5603,4973,5557,5558,5559,5801,5804,5813,5578,5579,5580,5581,5755,5818,5817,5819,5822,5246,5243,1065,1064,0,5394,5395,5432,5096,5105,2704,5169)

# Thu Dec 18 21:02:18 2008
# Query_time: 4  Lock_time: 2  Rows_sent: 3  Rows_examined: 6
use gaucinca_gibtext2;
select ID, title, authorid, unix_timestamp(Posted) as posted, section, category1, category2, url_title, excerpt, comments_count from textpattern where status=4  AND ( (section = 'Clothing')  OR  (section = 'Fashion')  OR  (section = ' Designer-Labels')  OR  (section = 'Shoes')  OR  (section = 'Bags')  OR  (section = 'Jeans-Denim')  OR  (section = 'Childrens-Clothes')  OR  (section = 'Maternity-Clothes')  OR  (section = ' Menswear')  OR  (section = 'Sportswear')  OR  (section = 'Workwear')  OR  (section = 'Curtains-Fabrics-Haberdashery')  OR  (section = 'Promotional-Clothing-Gifts-Printing')  OR  (section = 'T-Shirt-Printing')  OR  (section = 'Dry-Cleaners') )     AND posted < now()   ORDER BY posted desc   LIMIT 31

# Thu Dec 18 21:02:20 2008
# Query_time: 3  Lock_time: 1  Rows_sent: 3  Rows_examined: 6
use gaucinca_gibtext2;
select ID, title, authorid, unix_timestamp(Posted) as posted, section, category1, category2, url_title, excerpt, comments_count from textpattern where status=4  AND ( (section = 'Clothing')  OR  (section = 'Fashion')  OR  (section = ' Designer-Labels')  OR  (section = 'Shoes')  OR  (section = 'Bags')  OR  (section = 'Jeans-Denim')  OR  (section = 'Childrens-Clothes')  OR  (section = 'Maternity-Clothes')  OR  (section = ' Menswear')  OR  (section = 'Sportswear')  OR  (section = 'Workwear')  OR  (section = 'Curtains-Fabrics-Haberdashery')  OR  (section = 'Promotional-Clothing-Gifts-Printing')  OR  (section = 'T-Shirt-Printing')  OR  (section = 'Dry-Cleaners') )     AND posted < now()   ORDER BY posted desc   LIMIT 31

# Thu Dec 18 21:02:21 2008
# Query_time: 4  Lock_time: 2  Rows_sent: 1  Rows_examined: 1
use gaucinca_gibforum370;
SELECT template
  FROM template
  WHERE templateid = 5405

# Thu Dec 18 21:02:21 2008
# Query_time: 3  Lock_time: 1  Rows_sent: 1  Rows_examined: 1
use gaucinca_gibtext2;
select Form from txp_form where name='fp_rhs_shopping_title_306'

# Thu Dec 18 21:02:21 2008
# Query_time: 3  Lock_time: 1  Rows_sent: 1  Rows_examined: 0
use gaucinca_gibforum370;
SELECT count(userid) AS np FROM casino_texasholdem_whoisin WHERE lastcheck > 1229659306

# Thu Dec 18 21:02:22 2008
# Query_time: 4  Lock_time: 2  Rows_sent: 2  Rows_examined: 4
use gaucinca_gibtext2;
select ID, title, authorid, unix_timestamp(Posted) as posted, section, category1, category2, url_title, excerpt, comments_count from textpattern where status=4  AND ( (section = 'Bags') )     AND posted < now()   ORDER BY posted desc   LIMIT 31

# Thu Dec 18 21:02:24 2008
# Query_time: 5  Lock_time: 3  Rows_sent: 1  Rows_examined: 1
use gaucinca_gibtext2;
select Form from txp_form where name='fp_rhs_souvenir_shops_latest'

# Thu Dec 18 21:02:24 2008
# Query_time: 4  Lock_time: 2  Rows_sent: 1  Rows_examined: 1
use gaucinca_gibtext2;
select Form from txp_form where name='fp_rhs_shopping_latest'

# Thu Dec 18 21:02:24 2008
# Query_time: 2  Lock_time: 0  Rows_sent: 30  Rows_examined: 62
select ID, title, authorid, unix_timestamp(Posted) as posted, section, category1, category2, url_title, excerpt, comments_count from textpattern where status=4  AND ( (section = 'Shopping')  OR  (section = 'Supermarkets')  OR  (section = 'Fruit-Vegetables')  OR  (section = 'Cameras-Lenses')  OR  (section = 'Laptops')  OR  (section = 'Flat-Plasma-TVs')  OR  (section = 'Mobile-Phones')  OR  (section = 'iPods')  OR  (section = 'Games-Consoles')  OR  (section = 'Xbox')  OR  (section = 'Nintendo-Wii')  OR  (section = 'Playstation')  OR  (section = 'Cigars-Cigarettes')  OR  (section = 'AlcoholSales')  OR  (section = 'Jewellery')  OR  (section = 'Fashion-Jewellery')  OR  (section = 'Diamonds-Gems')  OR  (section = 'Gold-Silver')  OR  (section = 'Cosmetics')  OR  (section = 'Perfume')  OR  (section = 'DVD-Sales')  OR  (section = 'DVD-Rentals')  OR  (section = 'Mother-Baby')  OR  (section = 'Toy-Stores')  OR  (section = 'Gift-Shops')  OR  (section = 'Souvenir-Shops')  OR  (section = 'Clothing')  OR  (section = 'Fashion')  OR  (section = 'Designer-Labels')  OR  (section = 'Shoes')  OR  (section = 'Bags')  OR  (section = 'Jeans-Denim')  OR  (section = 'Childrens-Clothes')  OR  (section = 'Maternity-Clothes')  OR  (section = 'Menswear')  OR  (section = 'Sportswear')  OR  (section = 'Workwear')  OR  (section = 'Sports-Equipment')  OR  (section = 'Angling-Supplies')  OR  (section = 'Florists')  OR  (section = 'Health-Shops')  OR  (section = 'Curtains-Fabrics-Haberdashery')  OR  (section = 'Promotional-Clothing-Gifts-Printing')  OR  (section = 'T-Shirt-Printing')  OR  (section = 'Office-Supplies')  OR  (section = 'Stationery')  OR  (section = 'Printing-Services')  OR  (section = 'Dry-Cleaners')  OR  (section = 'Tool-Hire') )     AND posted < now()   ORDER BY posted desc   LIMIT 31

# Thu Dec 18 21:02:26 2008
# Query_time: 3  Lock_time: 1  Rows_sent: 0  Rows_examined: 0
use gaucinca_gibforum370;
UPDATE session
  SET lastactivity = 1229659322, location = '/pp/showphoto.php/photo/879/size/big/cat/562'
  WHERE sessionhash = '80fc9bdb1a6757b954b84087b1e51007'

# Thu Dec 18 21:02:27 2008
# Query_time: 4  Lock_time: 1  Rows_sent: 201  Rows_examined: 201
use gaucinca_costaphoto;
SELECT varname,setting FROM settings

# Thu Dec 18 21:02:27 2008
# Query_time: 3  Lock_time: 0  Rows_sent: 5  Rows_examined: 11
use gaucinca_gibtext2;
select ID, title, authorid, unix_timestamp(Posted) as posted, section, category1, category2, url_title, excerpt, comments_count from textpattern where status=4  AND ( (section = 'Jewellery')  OR  (section = 'Fashion-Jewellery')  OR  (section = 'Diamonds-Gems')  OR  (section = 'Gold-Silver') )     AND posted < now()   ORDER BY posted desc   LIMIT 31

# Thu Dec 18 21:02:27 2008
# Query_time: 3  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
select ID, title, authorid, unix_timestamp(Posted) as posted, section, category1, category2, url_title, excerpt, comments_count from textpattern where status=4  AND ( (section = 'Souvenir-Shops') )     AND posted < now()   ORDER BY posted desc   LIMIT 31

# Thu Dec 18 21:02:27 2008
# Query_time: 3  Lock_time: 0  Rows_sent: 30  Rows_examined: 62
use gaucinca_gibtext2;
select ID, title, authorid, unix_timestamp(Posted) as posted, section, category1, category2, url_title, excerpt, comments_count from textpattern where status=4  AND ( (section = 'Shopping')  OR  (section = 'Supermarkets')  OR  (section = 'Fruit-Vegetables')  OR  (section = 'Cameras-Lenses')  OR  (section = 'Laptops')  OR  (section = 'Flat-Plasma-TVs')  OR  (section = 'Mobile-Phones')  OR  (section = 'iPods')  OR  (section = 'Games-Consoles')  OR  (section = 'Xbox')  OR  (section = 'Nintendo-Wii')  OR  (section = 'Playstation')  OR  (section = 'Cigars-Cigarettes')  OR  (section = 'AlcoholSales')  OR  (section = 'Jewellery')  OR  (section = 'Fashion-Jewellery')  OR  (section = 'Diamonds-Gems')  OR  (section = 'Gold-Silver')  OR  (section = 'Cosmetics')  OR  (section = 'Perfume')  OR  (section = 'DVD-Sales')  OR  (section = 'DVD-Rentals')  OR  (section = 'Mother-Baby')  OR  (section = 'Toy-Stores')  OR  (section = 'Gift-Shops')  OR  (section = 'Souvenir-Shops')  OR  (section = 'Clothing')  OR  (section = 'Fashion')  OR  (section = 'Designer-Labels')  OR  (section = 'Shoes')  OR  (section = 'Bags')  OR  (section = 'Jeans-Denim')  OR  (section = 'Childrens-Clothes')  OR  (section = 'Maternity-Clothes')  OR  (section = 'Menswear')  OR  (section = 'Sportswear')  OR  (section = 'Workwear')  OR  (section = 'Sports-Equipment')  OR  (section = 'Angling-Supplies')  OR  (section = 'Florists')  OR  (section = 'Health-Shops')  OR  (section = 'Curtains-Fabrics-Haberdashery')  OR  (section = 'Promotional-Clothing-Gifts-Printing')  OR  (section = 'T-Shirt-Printing')  OR  (section = 'Office-Supplies')  OR  (section = 'Stationery')  OR  (section = 'Printing-Services')  OR  (section = 'Dry-Cleaners')  OR  (section = 'Tool-Hire') )     AND posted < now()   ORDER BY posted desc   LIMIT 31

# Thu Dec 18 21:02:28 2008
# Query_time: 4  Lock_time: 2  Rows_sent: 1  Rows_examined: 1
use gaucinca_gibtext2;
select Form from txp_form where name='fp_rhs_table_bottom'

# Thu Dec 18 21:02:28 2008
# Query_time: 4  Lock_time: 1  Rows_sent: 5  Rows_examined: 11
use gaucinca_gibtext2;
select ID, title, authorid, unix_timestamp(Posted) as posted, section, category1, category2, url_title, excerpt, comments_count from textpattern where status=4  AND ( (section = 'Jewellery')  OR  (section = 'Fashion-Jewellery')  OR  (section = 'Diamonds-Gems')  OR  (section = 'Gold-Silver') )     AND posted < now()   ORDER BY posted desc   LIMIT 31

# Thu Dec 18 21:02:28 2008
# Query_time: 4  Lock_time: 0  Rows_sent: 30  Rows_examined: 62
use gaucinca_gibtext2;
select ID, title, authorid, unix_timestamp(Posted) as posted, section, category1, category2, url_title, excerpt, comments_count from textpattern where status=4  AND ( (section = 'Shopping')  OR  (section = 'Supermarkets')  OR  (section = 'Fruit-Vegetables')  OR  (section = 'Cameras-Lenses')  OR  (section = 'Laptops')  OR  (section = 'Flat-Plasma-TVs')  OR  (section = 'Mobile-Phones')  OR  (section = 'iPods')  OR  (section = 'Games-Consoles')  OR  (section = 'Xbox')  OR  (section = 'Nintendo-Wii')  OR  (section = 'Playstation')  OR  (section = 'Cigars-Cigarettes')  OR  (section = 'AlcoholSales')  OR  (section = 'Jewellery')  OR  (section = 'Fashion-Jewellery')  OR  (section = 'Diamonds-Gems')  OR  (section = 'Gold-Silver')  OR  (section = 'Cosmetics')  OR  (section = 'Perfume')  OR  (section = 'DVD-Sales')  OR  (section = 'DVD-Rentals')  OR  (section = 'Mother-Baby')  OR  (section = 'Toy-Stores')  OR  (section = 'Gift-Shops')  OR  (section = 'Souvenir-Shops')  OR  (section = 'Clothing')  OR  (section = 'Fashion')  OR  (section = 'Designer-Labels')  OR  (section = 'Shoes')  OR  (section = 'Bags')  OR  (section = 'Jeans-Denim')  OR  (section = 'Childrens-Clothes')  OR  (section = 'Maternity-Clothes')  OR  (section = 'Menswear')  OR  (section = 'Sportswear')  OR  (section = 'Workwear')  OR  (section = 'Sports-Equipment')  OR  (section = 'Angling-Supplies')  OR  (section = 'Florists')  OR  (section = 'Health-Shops')  OR  (section = 'Curtains-Fabrics-Haberdashery')  OR  (section = 'Promotional-Clothing-Gifts-Printing')  OR  (section = 'T-Shirt-Printing')  OR  (section = 'Office-Supplies')  OR  (section = 'Stationery')  OR  (section = 'Printing-Services')  OR  (section = 'Dry-Cleaners')  OR  (section = 'Tool-Hire') )     AND posted < now()   ORDER BY posted desc   LIMIT 31

# Thu Dec 18 21:02:30 2008
# Query_time: 2  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
use gaucinca_gibtext2;
select ID, title, authorid, unix_timestamp(Posted) as posted, section, category1, category2, url_title, excerpt, comments_count from textpattern where status=4  AND ( (section = 'Fashion-Jewellery') )     AND posted < now()   ORDER BY posted desc   LIMIT 31

# Thu Dec 18 21:02:36 2008
# Query_time: 3  Lock_time: 0  Rows_sent: 1  Rows_examined: 1
use gaucinca_gibtext2;
select Form from txp_form where name='fp_rhs_shopping_title_306'

# Thu Dec 18 21:02:36 2008
# Query_time: 3  Lock_time: 0  Rows_sent: 104  Rows_examined: 297
use gaucinca_costaphoto;
SELECT c.id, c.description, c.catorder, c.photos, c.posts, c.catdepth,
  p.id, p.bigimage, p.cat, p.approved, p.user, p.userid, p.date, p.width, p.height,
  p2.bigimage, p2.cat, p2.storecat, p2.userid, p2.width, p2.height,
  com.username, com.id, com.date, com.photo
  FROM categories c
  LEFT JOIN photos p ON c.lastphoto=p.id
  LEFT JOIN photos p2 ON c.thumbnail=p2.id
  LEFT JOIN comments com ON com.id=c.lastpost
  ORDER BY c.catorder ASC

# Thu Dec 18 21:02:37 2008
# Query_time: 3  Lock_time: 1  Rows_sent: 1  Rows_examined: 1
use gaucinca_gibtext2;
select Form from txp_form where name='fp_rhs_shopping_title_306'

# Thu Dec 18 21:02:39 2008
# Query_time: 7  Lock_time: 3  Rows_sent: 1  Rows_examined: 0
use gaucinca_costaforum;
SELECT u.username,u.homepage,u.usertitle,u.posts,u.joindate,uf.field2,s.host,t.signature,sigpic.filename,sigparsed.hasimages,avatar.avatarpath, NOT ISNULL(customavatar.filedata) AS hascustomavatar,u.avatarrevision FROM user u
  LEFT JOIN userfield uf ON uf.userid=u.userid
  LEFT JOIN session s ON s.userid=u.userid
  LEFT JOIN usertextfield t ON t.userid=u.userid
  LEFT JOIN sigpic AS sigpic ON sigpic.userid=u.userid
  LEFT JOIN sigparsed AS sigparsed ON sigparsed.userid=u.userid LEFT JOIN avatar AS avatar ON (avatar.avatarid = u.avatarid)
  LEFT JOIN customavatar AS customavatar ON (customavatar.userid = u.userid) WHERE u.userid=1 LIMIT 1

# Thu Dec 18 21:02:41 2008
# Query_time: 4  Lock_time: 2  Rows_sent: 30  Rows_examined: 62
use gaucinca_gibtext2;
select ID, title, authorid, unix_timestamp(Posted) as posted, section, category1, category2, url_title, excerpt, comments_count from textpattern where status=4  AND ( (section = 'Shopping')  OR  (section = 'Supermarkets')  OR  (section = 'Fruit-Vegetables')  OR  (section = 'Cameras-Lenses')  OR  (section = 'Laptops')  OR  (section = 'Flat-Plasma-TVs')  OR  (section = 'Mobile-Phones')  OR  (section = 'iPods')  OR  (section = 'Games-Consoles')  OR  (section = 'Xbox')  OR  (section = 'Nintendo-Wii')  OR  (section = 'Playstation')  OR  (section = 'Cigars-Cigarettes')  OR  (section = 'AlcoholSales')  OR  (section = 'Jewellery')  OR  (section = 'Fashion-Jewellery')  OR  (section = 'Diamonds-Gems')  OR  (section = 'Gold-Silver')  OR  (section = 'Cosmetics')  OR  (section = 'Perfume')  OR  (section = 'DVD-Sales')  OR  (section = 'DVD-Rentals')  OR  (section = 'Mother-Baby')  OR  (section = 'Toy-Stores')  OR  (section = 'Gift-Shops')  OR  (section = 'Souvenir-Shops')  OR  (section = 'Clothing')  OR  (section = 'Fashion')  OR  (section = 'Designer-Labels')  OR  (section = 'Shoes')  OR  (section = 'Bags')  OR  (section = 'Jeans-Denim')  OR  (section = 'Childrens-Clothes')  OR  (section = 'Maternity-Clothes')  OR  (section = 'Menswear')  OR  (section = 'Sportswear')  OR  (section = 'Workwear')  OR  (section = 'Sports-Equipment')  OR  (section = 'Angling-Supplies')  OR  (section = 'Florists')  OR  (section = 'Health-Shops')  OR  (section = 'Curtains-Fabrics-Haberdashery')  OR  (section = 'Promotional-Clothing-Gifts-Printing')  OR  (section = 'T-Shirt-Printing')  OR  (section = 'Office-Supplies')  OR  (section = 'Stationery')  OR  (section = 'Printing-Services')  OR  (section = 'Dry-Cleaners')  OR  (section = 'Tool-Hire') )     AND posted < now()   ORDER BY posted desc   LIMIT 31

# Thu Dec 18 21:02:43 2008
# Query_time: 7  Lock_time: 3  Rows_sent: 30  Rows_examined: 62
use gaucinca_gibtext2;
select ID, title, authorid, unix_timestamp(Posted) as posted, section, category1, category2, url_title, excerpt, comments_count from textpattern where status=4  AND ( (section = 'Shopping')  OR  (section = 'Supermarkets')  OR  (section = 'Fruit-Vegetables')  OR  (section = 'Cameras-Lenses')  OR  (section = 'Laptops')  OR  (section = 'Flat-Plasma-TVs')  OR  (section = 'Mobile-Phones')  OR  (section = 'iPods')  OR  (section = 'Games-Consoles')  OR  (section = 'Xbox')  OR  (section = 'Nintendo-Wii')  OR  (section = 'Playstation')  OR  (section = 'Cigars-Cigarettes')  OR  (section = 'AlcoholSales')  OR  (section = 'Jewellery')  OR  (section = 'Fashion-Jewellery')  OR  (section = 'Diamonds-Gems')  OR  (section = 'Gold-Silver')  OR  (section = 'Cosmetics')  OR  (section = 'Perfume')  OR  (section = 'DVD-Sales')  OR  (section = 'DVD-Rentals')  OR  (section = 'Mother-Baby')  OR  (section = 'Toy-Stores')  OR  (section = 'Gift-Shops')  OR  (section = 'Souvenir-Shops')  OR  (section = 'Clothing')  OR  (section = 'Fashion')  OR  (section = 'Designer-Labels')  OR  (section = 'Shoes')  OR  (section = 'Bags')  OR  (section = 'Jeans-Denim')  OR  (section = 'Childrens-Clothes')  OR  (section = 'Maternity-Clothes')  OR  (section = 'Menswear')  OR  (section = 'Sportswear')  OR  (section = 'Workwear')  OR  (section = 'Sports-Equipment')  OR  (section = 'Angling-Supplies')  OR  (section = 'Florists')  OR  (section = 'Health-Shops')  OR  (section = 'Curtains-Fabrics-Haberdashery')  OR  (section = 'Promotional-Clothing-Gifts-Printing')  OR  (section = 'T-Shirt-Printing')  OR  (section = 'Office-Supplies')  OR  (section = 'Stationery')  OR  (section = 'Printing-Services')  OR  (section = 'Dry-Cleaners')  OR  (section = 'Tool-Hire') )     AND posted < now()   ORDER BY posted desc   LIMIT 31

# Thu Dec 18 21:02:45 2008
# Query_time: 5  Lock_time: 3  Rows_sent: 1  Rows_examined: 1
use gaucinca_costaphoto;
SELECT * FROM sort WHERE sortid=1

# Thu Dec 18 21:02:45 2008
# Query_time: 5  Lock_time: 3  Rows_sent: 4  Rows_examined: 12
use gaucinca_costaphoto;
SELECT item, count(*) FROM iponline GROUP BY item

(edited code display. -Els)

Last edited by els (2008-12-19 16:56:20)

Textpattern CMS

Textpattern CMS support forum

#1 2008-12-19 05:58:08

Really URGENT - WEBSITE SUSPENDED

Board footer