Skip to content

Instantly share code, notes, and snippets.

@beppu

beppu/00-request-without-memcached.txt

Created February 4, 2009 08:36
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save beppu/58024 to your computer and use it in GitHub Desktop.
Save beppu/58024 to your computer and use it in GitHub Desktop.
Download ZIP
what a difference memcached makes...
Raw
00-request-without-memcached.txt
090204 0:32:28 11 Connect kohaadmin@localhost on koha
11 Query set autocommit=1
11 Query set NAMES 'utf8'
11 Query SELECT value
FROM systempreferences
WHERE variable='LibraryName'
LIMIT 1
090204 0:32:29 11 Query select * from auth_types order by authtypetext
11 Query SELECT value
FROM systempreferences
WHERE variable='intranet_includes'
LIMIT 1
11 Query SELECT * FROM language_subtag_registry WHERE type='language'
11 Query SELECT * FROM language_descriptions LEFT JOIN language_rfc4646_to_iso639 on language_rfc4646_to_iso639.rfc4646_subtag = language_descriptions.subtag WHERE type='language' AND subtag ='ar' AND language_descriptions.lang = 'en'
11 Query SELECT description FROM language_descriptions WHERE type='language' AND subtag='ar' AND lang='ar'
11 Query SELECT * FROM language_descriptions LEFT JOIN language_rfc4646_to_iso639 on language_rfc4646_to_iso639.rfc4646_subtag = language_descriptions.subtag WHERE type='language' AND subtag ='hy' AND language_descriptions.lang = 'en'
11 Query SELECT description FROM language_descriptions WHERE type='language' AND subtag='hy' AND lang='hy'
11 Query SELECT * FROM language_descriptions LEFT JOIN language_rfc4646_to_iso639 on language_rfc4646_to_iso639.rfc4646_subtag = language_descriptions.subtag WHERE type='language' AND subtag ='bg' AND language_descriptions.lang = 'en'
11 Query SELECT description FROM language_descriptions WHERE type='language' AND subtag='bg' AND lang='bg'
11 Query SELECT * FROM language_descriptions LEFT JOIN language_rfc4646_to_iso639 on language_rfc4646_to_iso639.rfc4646_subtag = language_descriptions.subtag WHERE type='language' AND subtag ='zh' AND language_descriptions.lang = 'en'
11 Query SELECT description FROM language_descriptions WHERE type='language' AND subtag='zh' AND lang='zh'
11 Query SELECT * FROM language_descriptions LEFT JOIN language_rfc4646_to_iso639 on language_rfc4646_to_iso639.rfc4646_subtag = language_descriptions.subtag WHERE type='language' AND subtag ='cs' AND language_descriptions.lang = 'en'
11 Query SELECT description FROM language_descriptions WHERE type='language' AND subtag='cs' AND lang='cs'
11 Query SELECT * FROM language_descriptions LEFT JOIN language_rfc4646_to_iso639 on language_rfc4646_to_iso639.rfc4646_subtag = language_descriptions.subtag WHERE type='language' AND subtag ='da' AND language_descriptions.lang = 'en'
11 Query SELECT description FROM language_descriptions WHERE type='language' AND subtag='da' AND lang='da'
11 Query SELECT * FROM language_descriptions LEFT JOIN language_rfc4646_to_iso639 on language_rfc4646_to_iso639.rfc4646_subtag = language_descriptions.subtag WHERE type='language' AND subtag ='nl' AND language_descriptions.lang = 'en'
11 Query SELECT description FROM language_descriptions WHERE type='language' AND subtag='nl' AND lang='nl'
11 Query SELECT * FROM language_descriptions LEFT JOIN language_rfc4646_to_iso639 on language_rfc4646_to_iso639.rfc4646_subtag = language_descriptions.subtag WHERE type='language' AND subtag ='en' AND language_descriptions.lang = 'en'
11 Query SELECT description FROM language_descriptions WHERE type='language' AND subtag='en' AND lang='en'
11 Query SELECT * FROM language_descriptions LEFT JOIN language_rfc4646_to_iso639 on language_rfc4646_to_iso639.rfc4646_subtag = language_descriptions.subtag WHERE type='language' AND subtag ='fi' AND language_descriptions.lang = 'en'
11 Query SELECT description FROM language_descriptions WHERE type='language' AND subtag='fi' AND lang='fi'
11 Query SELECT * FROM language_descriptions LEFT JOIN language_rfc4646_to_iso639 on language_rfc4646_to_iso639.rfc4646_subtag = language_descriptions.subtag WHERE type='language' AND subtag ='fr' AND language_descriptions.lang = 'en'
11 Query SELECT description FROM language_descriptions WHERE type='language' AND subtag='fr' AND lang='fr'
11 Query SELECT * FROM language_descriptions LEFT JOIN language_rfc4646_to_iso639 on language_rfc4646_to_iso639.rfc4646_subtag = language_descriptions.subtag WHERE type='language' AND subtag ='lo' AND language_descriptions.lang = 'en'
11 Query SELECT description FROM language_descriptions WHERE type='language' AND subtag='lo' AND lang='lo'
11 Query SELECT * FROM language_descriptions LEFT JOIN language_rfc4646_to_iso639 on language_rfc4646_to_iso639.rfc4646_subtag = language_descriptions.subtag WHERE type='language' AND subtag ='de' AND language_descriptions.lang = 'en'
11 Query SELECT description FROM language_descriptions WHERE type='language' AND subtag='de' AND lang='de'
11 Query SELECT * FROM language_descriptions LEFT JOIN language_rfc4646_to_iso639 on language_rfc4646_to_iso639.rfc4646_subtag = language_descriptions.subtag WHERE type='language' AND subtag ='el' AND language_descriptions.lang = 'en'
11 Query SELECT description FROM language_descriptions WHERE type='language' AND subtag='el' AND lang='el'
11 Query SELECT * FROM language_descriptions LEFT JOIN language_rfc4646_to_iso639 on language_rfc4646_to_iso639.rfc4646_subtag = language_descriptions.subtag WHERE type='language' AND subtag ='he' AND language_descriptions.lang = 'en'
11 Query SELECT description FROM language_descriptions WHERE type='language' AND subtag='he' AND lang='he'
11 Query SELECT * FROM language_descriptions LEFT JOIN language_rfc4646_to_iso639 on language_rfc4646_to_iso639.rfc4646_subtag = language_descriptions.subtag WHERE type='language' AND subtag ='hi' AND language_descriptions.lang = 'en'
11 Query SELECT description FROM language_descriptions WHERE type='language' AND subtag='hi' AND lang='hi'
11 Query SELECT * FROM language_descriptions LEFT JOIN language_rfc4646_to_iso639 on language_rfc4646_to_iso639.rfc4646_subtag = language_descriptions.subtag WHERE type='language' AND subtag ='hu' AND language_descriptions.lang = 'en'
11 Query SELECT description FROM language_descriptions WHERE type='language' AND subtag='hu' AND lang='hu'
11 Query SELECT * FROM language_descriptions LEFT JOIN language_rfc4646_to_iso639 on language_rfc4646_to_iso639.rfc4646_subtag = language_descriptions.subtag WHERE type='language' AND subtag ='id' AND language_descriptions.lang = 'en'
11 Query SELECT description FROM language_descriptions WHERE type='language' AND subtag='id' AND lang='id'
11 Query SELECT * FROM language_descriptions LEFT JOIN language_rfc4646_to_iso639 on language_rfc4646_to_iso639.rfc4646_subtag = language_descriptions.subtag WHERE type='language' AND subtag ='it' AND language_descriptions.lang = 'en'
11 Query SELECT description FROM language_descriptions WHERE type='language' AND subtag='it' AND lang='it'
11 Query SELECT * FROM language_descriptions LEFT JOIN language_rfc4646_to_iso639 on language_rfc4646_to_iso639.rfc4646_subtag = language_descriptions.subtag WHERE type='language' AND subtag ='ja' AND language_descriptions.lang = 'en'
11 Query SELECT description FROM language_descriptions WHERE type='language' AND subtag='ja' AND lang='ja'
11 Query SELECT * FROM language_descriptions LEFT JOIN language_rfc4646_to_iso639 on language_rfc4646_to_iso639.rfc4646_subtag = language_descriptions.subtag WHERE type='language' AND subtag ='ko' AND language_descriptions.lang = 'en'
11 Query SELECT description FROM language_descriptions WHERE type='language' AND subtag='ko' AND lang='ko'
11 Query SELECT * FROM language_descriptions LEFT JOIN language_rfc4646_to_iso639 on language_rfc4646_to_iso639.rfc4646_subtag = language_descriptions.subtag WHERE type='language' AND subtag ='la' AND language_descriptions.lang = 'en'
11 Query SELECT description FROM language_descriptions WHERE type='language' AND subtag='la' AND lang='la'
11 Query SELECT * FROM language_descriptions LEFT JOIN language_rfc4646_to_iso639 on language_rfc4646_to_iso639.rfc4646_subtag = language_descriptions.subtag WHERE type='language' AND subtag ='gl' AND language_descriptions.lang = 'en'
11 Query SELECT description FROM language_descriptions WHERE type='language' AND subtag='gl' AND lang='gl'
11 Query SELECT * FROM language_descriptions LEFT JOIN language_rfc4646_to_iso639 on language_rfc4646_to_iso639.rfc4646_subtag = language_descriptions.subtag WHERE type='language' AND subtag ='nb' AND language_descriptions.lang = 'en'
11 Query SELECT description FROM language_descriptions WHERE type='language' AND subtag='nb' AND lang='nb'
11 Query SELECT * FROM language_descriptions LEFT JOIN language_rfc4646_to_iso639 on language_rfc4646_to_iso639.rfc4646_subtag = language_descriptions.subtag WHERE type='language' AND subtag ='fa' AND language_descriptions.lang = 'en'
11 Query SELECT description FROM language_descriptions WHERE type='language' AND subtag='fa' AND lang='fa'
11 Query SELECT * FROM language_descriptions LEFT JOIN language_rfc4646_to_iso639 on language_rfc4646_to_iso639.rfc4646_subtag = language_descriptions.subtag WHERE type='language' AND subtag ='pl' AND language_descriptions.lang = 'en'
11 Query SELECT description FROM language_descriptions WHERE type='language' AND subtag='pl' AND lang='pl'
11 Query SELECT * FROM language_descriptions LEFT JOIN language_rfc4646_to_iso639 on language_rfc4646_to_iso639.rfc4646_subtag = language_descriptions.subtag WHERE type='language' AND subtag ='pt' AND language_descriptions.lang = 'en'
11 Query SELECT description FROM language_descriptions WHERE type='language' AND subtag='pt' AND lang='pt'
11 Query SELECT * FROM language_descriptions LEFT JOIN language_rfc4646_to_iso639 on language_rfc4646_to_iso639.rfc4646_subtag = language_descriptions.subtag WHERE type='language' AND subtag ='ro' AND language_descriptions.lang = 'en'
11 Query SELECT description FROM language_descriptions WHERE type='language' AND subtag='ro' AND lang='ro'
11 Query SELECT * FROM language_descriptions LEFT JOIN language_rfc4646_to_iso639 on language_rfc4646_to_iso639.rfc4646_subtag = language_descriptions.subtag WHERE type='language' AND subtag ='ru' AND language_descriptions.lang = 'en'
11 Query SELECT description FROM language_descriptions WHERE type='language' AND subtag='ru' AND lang='ru'
11 Query SELECT * FROM language_descriptions LEFT JOIN language_rfc4646_to_iso639 on language_rfc4646_to_iso639.rfc4646_subtag = language_descriptions.subtag WHERE type='language' AND subtag ='sr' AND language_descriptions.lang = 'en'
11 Query SELECT description FROM language_descriptions WHERE type='language' AND subtag='sr' AND lang='sr'
11 Query SELECT * FROM language_descriptions LEFT JOIN language_rfc4646_to_iso639 on language_rfc4646_to_iso639.rfc4646_subtag = language_descriptions.subtag WHERE type='language' AND subtag ='es' AND language_descriptions.lang = 'en'
11 Query SELECT description FROM language_descriptions WHERE type='language' AND subtag='es' AND lang='es'
11 Query SELECT * FROM language_descriptions LEFT JOIN language_rfc4646_to_iso639 on language_rfc4646_to_iso639.rfc4646_subtag = language_descriptions.subtag WHERE type='language' AND subtag ='sv' AND language_descriptions.lang = 'en'
11 Query SELECT description FROM language_descriptions WHERE type='language' AND subtag='sv' AND lang='sv'
11 Query SELECT * FROM language_descriptions LEFT JOIN language_rfc4646_to_iso639 on language_rfc4646_to_iso639.rfc4646_subtag = language_descriptions.subtag WHERE type='language' AND subtag ='tet' AND language_descriptions.lang = 'en'
11 Query SELECT description FROM language_descriptions WHERE type='language' AND subtag='tet' AND lang='tet'
11 Query SELECT * FROM language_descriptions LEFT JOIN language_rfc4646_to_iso639 on language_rfc4646_to_iso639.rfc4646_subtag = language_descriptions.subtag WHERE type='language' AND subtag ='th' AND language_descriptions.lang = 'en'
11 Query SELECT description FROM language_descriptions WHERE type='language' AND subtag='th' AND lang='th'
11 Query SELECT * FROM language_descriptions LEFT JOIN language_rfc4646_to_iso639 on language_rfc4646_to_iso639.rfc4646_subtag = language_descriptions.subtag WHERE type='language' AND subtag ='tr' AND language_descriptions.lang = 'en'
11 Query SELECT description FROM language_descriptions WHERE type='language' AND subtag='tr' AND lang='tr'
11 Query SELECT * FROM language_descriptions LEFT JOIN language_rfc4646_to_iso639 on language_rfc4646_to_iso639.rfc4646_subtag = language_descriptions.subtag WHERE type='language' AND subtag ='uk' AND language_descriptions.lang = 'en'
11 Query SELECT description FROM language_descriptions WHERE type='language' AND subtag='uk' AND lang='uk'
11 Query SELECT * FROM language_descriptions LEFT JOIN language_rfc4646_to_iso639 on language_rfc4646_to_iso639.rfc4646_subtag = language_descriptions.subtag WHERE type='language' AND subtag ='ur' AND language_descriptions.lang = 'en'
11 Query SELECT description FROM language_descriptions WHERE type='language' AND subtag='ur' AND lang='ur'
11 Query SELECT value
FROM systempreferences
WHERE variable='language'
LIMIT 1
11 Query SELECT description FROM language_descriptions WHERE subtag='en' AND lang='en' AND type='language'
11 Query SELECT description FROM language_descriptions WHERE subtag=NULL AND lang='en' AND type='script'
11 Query SELECT description FROM language_descriptions WHERE subtag=NULL AND lang='en' AND type='script'
11 Query SELECT description FROM language_descriptions WHERE subtag=NULL AND lang='en' AND type='region'
11 Query SELECT description FROM language_descriptions WHERE subtag=NULL AND lang='en' AND type='region'
11 Query SELECT description FROM language_descriptions WHERE subtag=NULL AND lang='en' AND type='variant'
11 Query SELECT description FROM language_descriptions WHERE subtag=NULL AND lang='en' AND type='variant'
11 Query SELECT description FROM language_descriptions WHERE subtag='en' AND lang='en' AND type='language'
11 Query SELECT value
FROM systempreferences
WHERE variable='template'
LIMIT 1
11 Query SELECT value
FROM systempreferences
WHERE variable='opacstylesheet'
LIMIT 1
11 Query SELECT value
FROM systempreferences
WHERE variable='yuipath'
LIMIT 1
11 Query SELECT value
FROM systempreferences
WHERE variable='opaccolorstylesheet'
LIMIT 1
11 Query SELECT value
FROM systempreferences
WHERE variable='opacsmallimage'
LIMIT 1
11 Query SELECT * FROM language_subtag_registry WHERE type='language'
11 Query SELECT * FROM language_descriptions LEFT JOIN language_rfc4646_to_iso639 on language_rfc4646_to_iso639.rfc4646_subtag = language_descriptions.subtag WHERE type='language' AND subtag ='ar' AND language_descriptions.lang = 'en'
11 Query SELECT description FROM language_descriptions WHERE type='language' AND subtag='ar' AND lang='ar'
11 Query SELECT * FROM language_descriptions LEFT JOIN language_rfc4646_to_iso639 on language_rfc4646_to_iso639.rfc4646_subtag = language_descriptions.subtag WHERE type='language' AND subtag ='hy' AND language_descriptions.lang = 'en'
11 Query SELECT description FROM language_descriptions WHERE type='language' AND subtag='hy' AND lang='hy'
11 Query SELECT * FROM language_descriptions LEFT JOIN language_rfc4646_to_iso639 on language_rfc4646_to_iso639.rfc4646_subtag = language_descriptions.subtag WHERE type='language' AND subtag ='bg' AND language_descriptions.lang = 'en'
11 Query SELECT description FROM language_descriptions WHERE type='language' AND subtag='bg' AND lang='bg'
11 Query SELECT * FROM language_descriptions LEFT JOIN language_rfc4646_to_iso639 on language_rfc4646_to_iso639.rfc4646_subtag = language_descriptions.subtag WHERE type='language' AND subtag ='zh' AND language_descriptions.lang = 'en'
11 Query SELECT description FROM language_descriptions WHERE type='language' AND subtag='zh' AND lang='zh'
11 Query SELECT * FROM language_descriptions LEFT JOIN language_rfc4646_to_iso639 on language_rfc4646_to_iso639.rfc4646_subtag = language_descriptions.subtag WHERE type='language' AND subtag ='cs' AND language_descriptions.lang = 'en'
11 Query SELECT description FROM language_descriptions WHERE type='language' AND subtag='cs' AND lang='cs'
11 Query SELECT * FROM language_descriptions LEFT JOIN language_rfc4646_to_iso639 on language_rfc4646_to_iso639.rfc4646_subtag = language_descriptions.subtag WHERE type='language' AND subtag ='da' AND language_descriptions.lang = 'en'
11 Query SELECT description FROM language_descriptions WHERE type='language' AND subtag='da' AND lang='da'
11 Query SELECT * FROM language_descriptions LEFT JOIN language_rfc4646_to_iso639 on language_rfc4646_to_iso639.rfc4646_subtag = language_descriptions.subtag WHERE type='language' AND subtag ='nl' AND language_descriptions.lang = 'en'
11 Query SELECT description FROM language_descriptions WHERE type='language' AND subtag='nl' AND lang='nl'
11 Query SELECT * FROM language_descriptions LEFT JOIN language_rfc4646_to_iso639 on language_rfc4646_to_iso639.rfc4646_subtag = language_descriptions.subtag WHERE type='language' AND subtag ='en' AND language_descriptions.lang = 'en'
11 Query SELECT description FROM language_descriptions WHERE type='language' AND subtag='en' AND lang='en'
11 Query SELECT * FROM language_descriptions LEFT JOIN language_rfc4646_to_iso639 on language_rfc4646_to_iso639.rfc4646_subtag = language_descriptions.subtag WHERE type='language' AND subtag ='fi' AND language_descriptions.lang = 'en'
11 Query SELECT description FROM language_descriptions WHERE type='language' AND subtag='fi' AND lang='fi'
11 Query SELECT * FROM language_descriptions LEFT JOIN language_rfc4646_to_iso639 on language_rfc4646_to_iso639.rfc4646_subtag = language_descriptions.subtag WHERE type='language' AND subtag ='fr' AND language_descriptions.lang = 'en'
11 Query SELECT description FROM language_descriptions WHERE type='language' AND subtag='fr' AND lang='fr'
11 Query SELECT * FROM language_descriptions LEFT JOIN language_rfc4646_to_iso639 on language_rfc4646_to_iso639.rfc4646_subtag = language_descriptions.subtag WHERE type='language' AND subtag ='lo' AND language_descriptions.lang = 'en'
11 Query SELECT description FROM language_descriptions WHERE type='language' AND subtag='lo' AND lang='lo'
11 Query SELECT * FROM language_descriptions LEFT JOIN language_rfc4646_to_iso639 on language_rfc4646_to_iso639.rfc4646_subtag = language_descriptions.subtag WHERE type='language' AND subtag ='de' AND language_descriptions.lang = 'en'
11 Query SELECT description FROM language_descriptions WHERE type='language' AND subtag='de' AND lang='de'
11 Query SELECT * FROM language_descriptions LEFT JOIN language_rfc4646_to_iso639 on language_rfc4646_to_iso639.rfc4646_subtag = language_descriptions.subtag WHERE type='language' AND subtag ='el' AND language_descriptions.lang = 'en'
11 Query SELECT description FROM language_descriptions WHERE type='language' AND subtag='el' AND lang='el'
11 Query SELECT * FROM language_descriptions LEFT JOIN language_rfc4646_to_iso639 on language_rfc4646_to_iso639.rfc4646_subtag = language_descriptions.subtag WHERE type='language' AND subtag ='he' AND language_descriptions.lang = 'en'
11 Query SELECT description FROM language_descriptions WHERE type='language' AND subtag='he' AND lang='he'
11 Query SELECT * FROM language_descriptions LEFT JOIN language_rfc4646_to_iso639 on language_rfc4646_to_iso639.rfc4646_subtag = language_descriptions.subtag WHERE type='language' AND subtag ='hi' AND language_descriptions.lang = 'en'
11 Query SELECT description FROM language_descriptions WHERE type='language' AND subtag='hi' AND lang='hi'
11 Query SELECT * FROM language_descriptions LEFT JOIN language_rfc4646_to_iso639 on language_rfc4646_to_iso639.rfc4646_subtag = language_descriptions.subtag WHERE type='language' AND subtag ='hu' AND language_descriptions.lang = 'en'
11 Query SELECT description FROM language_descriptions WHERE type='language' AND subtag='hu' AND lang='hu'
11 Query SELECT * FROM language_descriptions LEFT JOIN language_rfc4646_to_iso639 on language_rfc4646_to_iso639.rfc4646_subtag = language_descriptions.subtag WHERE type='language' AND subtag ='id' AND language_descriptions.lang = 'en'
11 Query SELECT description FROM language_descriptions WHERE type='language' AND subtag='id' AND lang='id'
11 Query SELECT * FROM language_descriptions LEFT JOIN language_rfc4646_to_iso639 on language_rfc4646_to_iso639.rfc4646_subtag = language_descriptions.subtag WHERE type='language' AND subtag ='it' AND language_descriptions.lang = 'en'
11 Query SELECT description FROM language_descriptions WHERE type='language' AND subtag='it' AND lang='it'
11 Query SELECT * FROM language_descriptions LEFT JOIN language_rfc4646_to_iso639 on language_rfc4646_to_iso639.rfc4646_subtag = language_descriptions.subtag WHERE type='language' AND subtag ='ja' AND language_descriptions.lang = 'en'
11 Query SELECT description FROM language_descriptions WHERE type='language' AND subtag='ja' AND lang='ja'
11 Query SELECT * FROM language_descriptions LEFT JOIN language_rfc4646_to_iso639 on language_rfc4646_to_iso639.rfc4646_subtag = language_descriptions.subtag WHERE type='language' AND subtag ='ko' AND language_descriptions.lang = 'en'
11 Query SELECT description FROM language_descriptions WHERE type='language' AND subtag='ko' AND lang='ko'
11 Query SELECT * FROM language_descriptions LEFT JOIN language_rfc4646_to_iso639 on language_rfc4646_to_iso639.rfc4646_subtag = language_descriptions.subtag WHERE type='language' AND subtag ='la' AND language_descriptions.lang = 'en'
11 Query SELECT description FROM language_descriptions WHERE type='language' AND subtag='la' AND lang='la'
11 Query SELECT * FROM language_descriptions LEFT JOIN language_rfc4646_to_iso639 on language_rfc4646_to_iso639.rfc4646_subtag = language_descriptions.subtag WHERE type='language' AND subtag ='gl' AND language_descriptions.lang = 'en'
11 Query SELECT description FROM language_descriptions WHERE type='language' AND subtag='gl' AND lang='gl'
11 Query SELECT * FROM language_descriptions LEFT JOIN language_rfc4646_to_iso639 on language_rfc4646_to_iso639.rfc4646_subtag = language_descriptions.subtag WHERE type='language' AND subtag ='nb' AND language_descriptions.lang = 'en'
11 Query SELECT description FROM language_descriptions WHERE type='language' AND subtag='nb' AND lang='nb'
11 Query SELECT * FROM language_descriptions LEFT JOIN language_rfc4646_to_iso639 on language_rfc4646_to_iso639.rfc4646_subtag = language_descriptions.subtag WHERE type='language' AND subtag ='fa' AND language_descriptions.lang = 'en'
11 Query SELECT description FROM language_descriptions WHERE type='language' AND subtag='fa' AND lang='fa'
11 Query SELECT * FROM language_descriptions LEFT JOIN language_rfc4646_to_iso639 on language_rfc4646_to_iso639.rfc4646_subtag = language_descriptions.subtag WHERE type='language' AND subtag ='pl' AND language_descriptions.lang = 'en'
11 Query SELECT description FROM language_descriptions WHERE type='language' AND subtag='pl' AND lang='pl'
11 Query SELECT * FROM language_descriptions LEFT JOIN language_rfc4646_to_iso639 on language_rfc4646_to_iso639.rfc4646_subtag = language_descriptions.subtag WHERE type='language' AND subtag ='pt' AND language_descriptions.lang = 'en'
11 Query SELECT description FROM language_descriptions WHERE type='language' AND subtag='pt' AND lang='pt'
11 Query SELECT * FROM language_descriptions LEFT JOIN language_rfc4646_to_iso639 on language_rfc4646_to_iso639.rfc4646_subtag = language_descriptions.subtag WHERE type='language' AND subtag ='ro' AND language_descriptions.lang = 'en'
11 Query SELECT description FROM language_descriptions WHERE type='language' AND subtag='ro' AND lang='ro'
11 Query SELECT * FROM language_descriptions LEFT JOIN language_rfc4646_to_iso639 on language_rfc4646_to_iso639.rfc4646_subtag = language_descriptions.subtag WHERE type='language' AND subtag ='ru' AND language_descriptions.lang = 'en'
11 Query SELECT description FROM language_descriptions WHERE type='language' AND subtag='ru' AND lang='ru'
11 Query SELECT * FROM language_descriptions LEFT JOIN language_rfc4646_to_iso639 on language_rfc4646_to_iso639.rfc4646_subtag = language_descriptions.subtag WHERE type='language' AND subtag ='sr' AND language_descriptions.lang = 'en'
11 Query SELECT description FROM language_descriptions WHERE type='language' AND subtag='sr' AND lang='sr'
11 Query SELECT * FROM language_descriptions LEFT JOIN language_rfc4646_to_iso639 on language_rfc4646_to_iso639.rfc4646_subtag = language_descriptions.subtag WHERE type='language' AND subtag ='es' AND language_descriptions.lang = 'en'
11 Query SELECT description FROM language_descriptions WHERE type='language' AND subtag='es' AND lang='es'
11 Query SELECT * FROM language_descriptions LEFT JOIN language_rfc4646_to_iso639 on language_rfc4646_to_iso639.rfc4646_subtag = language_descriptions.subtag WHERE type='language' AND subtag ='sv' AND language_descriptions.lang = 'en'
11 Query SELECT description FROM language_descriptions WHERE type='language' AND subtag='sv' AND lang='sv'
11 Query SELECT * FROM language_descriptions LEFT JOIN language_rfc4646_to_iso639 on language_rfc4646_to_iso639.rfc4646_subtag = language_descriptions.subtag WHERE type='language' AND subtag ='tet' AND language_descriptions.lang = 'en'
11 Query SELECT description FROM language_descriptions WHERE type='language' AND subtag='tet' AND lang='tet'
11 Query SELECT * FROM language_descriptions LEFT JOIN language_rfc4646_to_iso639 on language_rfc4646_to_iso639.rfc4646_subtag = language_descriptions.subtag WHERE type='language' AND subtag ='th' AND language_descriptions.lang = 'en'
11 Query SELECT description FROM language_descriptions WHERE type='language' AND subtag='th' AND lang='th'
11 Query SELECT * FROM language_descriptions LEFT JOIN language_rfc4646_to_iso639 on language_rfc4646_to_iso639.rfc4646_subtag = language_descriptions.subtag WHERE type='language' AND subtag ='tr' AND language_descriptions.lang = 'en'
11 Query SELECT description FROM language_descriptions WHERE type='language' AND subtag='tr' AND lang='tr'
11 Query SELECT * FROM language_descriptions LEFT JOIN language_rfc4646_to_iso639 on language_rfc4646_to_iso639.rfc4646_subtag = language_descriptions.subtag WHERE type='language' AND subtag ='uk' AND language_descriptions.lang = 'en'
11 Query SELECT description FROM language_descriptions WHERE type='language' AND subtag='uk' AND lang='uk'
11 Query SELECT * FROM language_descriptions LEFT JOIN language_rfc4646_to_iso639 on language_rfc4646_to_iso639.rfc4646_subtag = language_descriptions.subtag WHERE type='language' AND subtag ='ur' AND language_descriptions.lang = 'en'
11 Query SELECT description FROM language_descriptions WHERE type='language' AND subtag='ur' AND lang='ur'
11 Query SELECT description FROM language_descriptions WHERE subtag='en' AND lang='en' AND type='language'
11 Query SELECT description FROM language_descriptions WHERE subtag=NULL AND lang='en' AND type='script'
11 Query SELECT description FROM language_descriptions WHERE subtag=NULL AND lang='en' AND type='script'
11 Query SELECT description FROM language_descriptions WHERE subtag=NULL AND lang='en' AND type='region'
11 Query SELECT description FROM language_descriptions WHERE subtag=NULL AND lang='en' AND type='region'
11 Query SELECT description FROM language_descriptions WHERE subtag=NULL AND lang='en' AND type='variant'
11 Query SELECT description FROM language_descriptions WHERE subtag=NULL AND lang='en' AND type='variant'
11 Query SELECT description FROM language_descriptions WHERE subtag='en' AND lang='en' AND type='language'
11 Query SELECT value
FROM systempreferences
WHERE variable='timeout'
LIMIT 1
11 Query SELECT value
FROM systempreferences
WHERE variable='OpacMaintenance'
LIMIT 1
11 Query SELECT value
FROM systempreferences
WHERE variable='Version'
LIMIT 1
11 Query SELECT value
FROM systempreferences
WHERE variable='SessionStorage'
LIMIT 1
11 Query SELECT a_session FROM sessions WHERE id='70464cf11d5d316532ee85f10577216a'
11 Query SELECT flags FROM borrowers WHERE userid='kohaadmin'
11 Query SELECT bit, flag, defaulton FROM userflags
11 Query SELECT flag, code
FROM user_permissions
JOIN permissions USING (module_bit, code)
JOIN userflags ON (module_bit = bit)
JOIN borrowers USING (borrowernumber)
WHERE userid = 'kohaadmin'
11 Query REPLACE INTO sessions (id, a_session) VALUES('70464cf11d5d316532ee85f10577216a', '--- \n_SESSION_ATIME: 1233736349\n_SESSION_CTIME: 1233733184\n_SESSION_EXPIRE_LIST: {}\n\n_SESSION_ID: 70464cf11d5d316532ee85f10577216a\n_SESSION_REMOTE_ADDR: 127.0.0.1\nbarshelves: []\n\nbranch: NO_LIBRARY_SET\nbranchname: NO_LIBRARY_SET\ncardnumber: kohaadmin\nemailaddress: root@localhost\nfirstname: kohaadmin\nflags: 1\nid: kohaadmin\nip: 127.0.0.1\nlasttime: 1233736349\nnumber: 0\npubshelves: []\n\nsurname: kohaadmin\ntotshelves: \n bartotal: 0\n pubtotal: 0\n')
11 Query SELECT value
FROM systempreferences
WHERE variable='insecure'
LIMIT 1
11 Query select borrowernumber from borrowers where userid='kohaadmin'
11 Query select borrowernumber from borrowers where cardnumber='kohaadmin'
11 Query SELECT flag, code, description
FROM permissions
JOIN userflags ON (module_bit = bit)
11 Query SELECT value
FROM systempreferences
WHERE variable='GranularPermissions'
LIMIT 1
11 Query SELECT value
FROM systempreferences
WHERE variable='BiblioDefaultView'
LIMIT 1
11 Query SELECT value
FROM systempreferences
WHERE variable='EnhancedMessagingPreferences'
LIMIT 1
11 Query SELECT value
FROM systempreferences
WHERE variable='GoogleJackets'
LIMIT 1
11 Query SELECT value
FROM systempreferences
WHERE variable='KohaAdminEmailAddress'
LIMIT 1
11 Query SELECT value
FROM systempreferences
WHERE variable='TagsEnabled'
LIMIT 1
11 Query SELECT value
FROM systempreferences
WHERE variable='hide_marc'
LIMIT 1
11 Query SELECT value
FROM systempreferences
WHERE variable='dateformat'
LIMIT 1
11 Query SELECT value
FROM systempreferences
WHERE variable='item-level_itypes'
LIMIT 1
11 Query SELECT value
FROM systempreferences
WHERE variable='patronimages'
LIMIT 1
11 Query SELECT value
FROM systempreferences
WHERE variable='singleBranchMode'
LIMIT 1
11 Query SELECT value
FROM systempreferences
WHERE variable='AmazonContent'
LIMIT 1
11 Query SELECT value
FROM systempreferences
WHERE variable='AmazonSimilarItems'
LIMIT 1
11 Query SELECT value
FROM systempreferences
WHERE variable='AutoLocation'
LIMIT 1
11 Query SELECT value
FROM systempreferences
WHERE variable='IntranetBiblioDefaultView'
LIMIT 1
11 Query SELECT value
FROM systempreferences
WHERE variable='CircAutocompl'
LIMIT 1
11 Query SELECT value
FROM systempreferences
WHERE variable='FRBRizeEditions'
LIMIT 1
11 Query SELECT value
FROM systempreferences
WHERE variable='IndependantBranches'
LIMIT 1
11 Query SELECT value
FROM systempreferences
WHERE variable='IntranetNav'
LIMIT 1
11 Query SELECT value
FROM systempreferences
WHERE variable='IntranetmainUserblock'
LIMIT 1
11 Query SELECT value
FROM systempreferences
WHERE variable='TemplateEncoding'
LIMIT 1
11 Query SELECT value
FROM systempreferences
WHERE variable='advancedMARCEditor'
LIMIT 1
11 Query SELECT value
FROM systempreferences
WHERE variable='canreservefromotherbranches'
LIMIT 1
11 Query SELECT value
FROM systempreferences
WHERE variable='intranetcolorstylesheet'
LIMIT 1
11 Query SELECT value
FROM systempreferences
WHERE variable='intranetreadinghistory'
LIMIT 1
11 Query SELECT value
FROM systempreferences
WHERE variable='intranetstylesheet'
LIMIT 1
11 Query SELECT value
FROM systempreferences
WHERE variable='intranetuserjs'
LIMIT 1
11 Query SELECT value
FROM systempreferences
WHERE variable='noItemTypeImages'
LIMIT 1
11 Query SELECT value
FROM systempreferences
WHERE variable='suggestion'
LIMIT 1
11 Query SELECT value
FROM systempreferences
WHERE variable='virtualshelves'
LIMIT 1
11 Query SELECT value
FROM systempreferences
WHERE variable='marc'
LIMIT 1
11 Query SELECT *,timestamp AS newdate
FROM opac_news
WHERE (
expirationdate > CURRENT_DATE()
OR expirationdate IS NULL
OR expirationdate = '00-00-0000'
)
AND lang = 'koha'
ORDER BY number
11 Quit
Raw
01-request-with-memcached.txt
090204 0:32:51 13 Connect kohaadmin@localhost on koha
13 Query set autocommit=1
13 Query set NAMES 'utf8'
13 Query select * from auth_types order by authtypetext
13 Query SELECT description FROM language_descriptions WHERE subtag='en' AND lang='en' AND type='language'
13 Query SELECT description FROM language_descriptions WHERE subtag=NULL AND lang='en' AND type='script'
13 Query SELECT description FROM language_descriptions WHERE subtag=NULL AND lang='en' AND type='script'
13 Query SELECT description FROM language_descriptions WHERE subtag=NULL AND lang='en' AND type='region'
13 Query SELECT description FROM language_descriptions WHERE subtag=NULL AND lang='en' AND type='region'
13 Query SELECT description FROM language_descriptions WHERE subtag=NULL AND lang='en' AND type='variant'
13 Query SELECT description FROM language_descriptions WHERE subtag=NULL AND lang='en' AND type='variant'
13 Query SELECT description FROM language_descriptions WHERE subtag='en' AND lang='en' AND type='language'
13 Query SELECT description FROM language_descriptions WHERE subtag='en' AND lang='en' AND type='language'
13 Query SELECT description FROM language_descriptions WHERE subtag=NULL AND lang='en' AND type='script'
13 Query SELECT description FROM language_descriptions WHERE subtag=NULL AND lang='en' AND type='script'
13 Query SELECT description FROM language_descriptions WHERE subtag=NULL AND lang='en' AND type='region'
13 Query SELECT description FROM language_descriptions WHERE subtag=NULL AND lang='en' AND type='region'
13 Query SELECT description FROM language_descriptions WHERE subtag=NULL AND lang='en' AND type='variant'
13 Query SELECT description FROM language_descriptions WHERE subtag=NULL AND lang='en' AND type='variant'
13 Query SELECT description FROM language_descriptions WHERE subtag='en' AND lang='en' AND type='language'
13 Query SELECT a_session FROM sessions WHERE id='70464cf11d5d316532ee85f10577216a'
13 Query SELECT flags FROM borrowers WHERE userid='kohaadmin'
13 Query SELECT bit, flag, defaulton FROM userflags
13 Query SELECT flag, code
FROM user_permissions
JOIN permissions USING (module_bit, code)
JOIN userflags ON (module_bit = bit)
JOIN borrowers USING (borrowernumber)
WHERE userid = 'kohaadmin'
13 Query REPLACE INTO sessions (id, a_session) VALUES('70464cf11d5d316532ee85f10577216a', '--- \n_SESSION_ATIME: 1233736371\n_SESSION_CTIME: 1233733184\n_SESSION_EXPIRE_LIST: {}\n\n_SESSION_ID: 70464cf11d5d316532ee85f10577216a\n_SESSION_REMOTE_ADDR: 127.0.0.1\nbarshelves: []\n\nbranch: NO_LIBRARY_SET\nbranchname: NO_LIBRARY_SET\ncardnumber: kohaadmin\nemailaddress: root@localhost\nfirstname: kohaadmin\nflags: 1\nid: kohaadmin\nip: 127.0.0.1\nlasttime: 1233736371\nnumber: 0\npubshelves: []\n\nsurname: kohaadmin\ntotshelves: \n bartotal: 0\n pubtotal: 0\n')
13 Query select borrowernumber from borrowers where userid='kohaadmin'
13 Query select borrowernumber from borrowers where cardnumber='kohaadmin'
13 Query SELECT flag, code, description
FROM permissions
JOIN userflags ON (module_bit = bit)
13 Query SELECT *,timestamp AS newdate
FROM opac_news
WHERE (
expirationdate > CURRENT_DATE()
OR expirationdate IS NULL
OR expirationdate = '00-00-0000'
)
AND lang = 'koha'
ORDER BY number
13 Quit
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment