query_log
object(Trevi_Log_Writer_Debug_Db)#6 (4) {
["_events:private"]=>
array(63) {
[0]=>
array(5) {
["timestamp"]=>
string(25) "2010-09-03T11:58:27+02:00"
["message"]=>
string(221) "Query statement: SELECT * FROM locations WHERE `uniquestring`='block-tempo-drom' LIMIT 1
Called from: Trevi_Db_Row->_loadByQuery()
Affected rows: 1 Execution time: 0.000620126724243s Database ID: 'default' Master used: no"
["priority"]=>
int(6)
["priorityName"]=>
string(4) "INFO"
["microtime"]=>
float(1283507907.14)
}
[1]=>
array(5) {
["timestamp"]=>
string(25) "2010-09-03T11:58:27+02:00"
["message"]=>
string(770) "Query statement: SELECT SQL_CALC_FOUND_ROWS DISTINCT p.*, UNIX_TIMESTAMP(p.datum) as unixtime,
F.fid as group_pic, F.filename, F.directory, F.file_location_id, mogilefs_hash, mimetype, picturetype,
l.uniquestring,l.rid
FROM parties p
LEFT JOIN f_bilder F ON p.group_pic = F.fid
LEFT JOIN locations l on p.lid = l.lid
WHERE p.lid = '530'
AND p.datum <= '2010-09-02'
AND p.non_party = 0
AND p.geloescht = 0
AND p.freigegeben = 1
AND p.invisible = 0
AND p.existiert_fotos = 1
AND p.belongs_to_partygroup < 3
ORDER BY p.datum DESC LIMIT 0, 6
Called from: Tilllate_Location->getReports()
Affected rows: 6 Execution time: 0.00392198562622s Database ID: 'default' Master used: no"
["priority"]=>
int(6)
["priorityName"]=>
string(4) "INFO"
["microtime"]=>
float(1283507907.15)
}
[2]=>
array(5) {
["timestamp"]=>
string(25) "2010-09-03T11:58:27+02:00"
["message"]=>
string(184) "Query statement: SELECT FOUND_ROWS()
Called from: Trevi_Db_PagedQuery->_predictTotalResults()
Affected rows: 1 Execution time: 0.000198125839233s Database ID: 'default' Master used: no"
["priority"]=>
int(6)
["priorityName"]=>
string(4) "INFO"
["microtime"]=>
float(1283507907.15)
}
[3]=>
array(5) {
["timestamp"]=>
string(25) "2010-09-03T11:58:27+02:00"
["message"]=>
string(581) "Query statement: SELECT p.gid
FROM parties p
WHERE p.lid = '530'
AND p.datum >= '2010-09-03'
AND p.non_party = 0
AND p.geloescht = 0
AND p.freigegeben = 1
AND p.invisible = 0
AND p.belongs_to_partygroup < 3
ORDER BY p.datum ASC
LIMIT '0', '6'
Called from: Tilllate_Db_Query->load()
Affected rows: 0 Execution time: 0.000540971755981s Database ID: 'default' Master used: no"
["priority"]=>
int(6)
["priorityName"]=>
string(4) "INFO"
["microtime"]=>
float(1283507907.15)
}
[4]=>
array(5) {
["timestamp"]=>
string(25) "2010-09-03T11:58:27+02:00"
["message"]=>
string(511) "Query statement: SELECT SQL_CALC_FOUND_ROWS u.uid, u.username, mp.filename_small
FROM member_zu_locations ml
INNER JOIN users u ON u.uid = ml.uid
LEFT JOIN member_passfotos as mp on mp.uid=u.uid
WHERE ml.lid = '530'
AND u.gesperrt = 0
AND u.username !=''
AND u.password != ''
AND u.validiert = 0 LIMIT 0, 6
Called from: Tilllate_User_Query->getLocationFans()
Affected rows: 6 Execution time: 0.0010302066803s Database ID: 'default' Master used: no"
["priority"]=>
int(6)
["priorityName"]=>
string(4) "INFO"
["microtime"]=>
float(1283507907.16)
}
[5]=>
array(5) {
["timestamp"]=>
string(25) "2010-09-03T11:58:27+02:00"
["message"]=>
string(183) "Query statement: SELECT FOUND_ROWS()
Called from: Trevi_Db_PagedQuery->_predictTotalResults()
Affected rows: 1 Execution time: 0.00017786026001s Database ID: 'default' Master used: no"
["priority"]=>
int(6)
["priorityName"]=>
string(4) "INFO"
["microtime"]=>
float(1283507907.16)
}
[6]=>
array(5) {
["timestamp"]=>
string(25) "2010-09-03T11:58:27+02:00"
["message"]=>
string(196) "Query statement: SELECT * FROM regionen WHERE `rid`='3' LIMIT 1
Called from: Trevi_Db_Row->_loadByQuery()
Affected rows: 1 Execution time: 0.000319004058838s Database ID: 'default' Master used: no"
["priority"]=>
int(6)
["priorityName"]=>
string(4) "INFO"
["microtime"]=>
float(1283507907.16)
}
[7]=>
array(5) {
["timestamp"]=>
string(25) "2010-09-03T11:58:27+02:00"
["message"]=>
string(270) "Query statement: SELECT r.rid,r.site_id, s.site_shortdomain FROM regionen r INNER JOIN sites s ON s.site_id = r.site_id;
Called from: Tilllate_Region_Query->getRegionToSiteArray()
Affected rows: 333 Execution time: 0.0003662109375s Database ID: 'default' Master used: no"
["priority"]=>
int(6)
["priorityName"]=>
string(4) "INFO"
["microtime"]=>
float(1283507907.16)
}
[8]=>
array(5) {
["timestamp"]=>
string(25) "2010-09-03T11:58:27+02:00"
["message"]=>
string(445) "Query statement: SELECT DISTINCT fb.fid, fb.gid, fb.file_location_id, fb.filename, fb.directory, mogilefs_hash, mimetype, picturetype, size_x_new, size_y_new FROM f_bilder_to_locations fbtl LEFT JOIN f_bilder fb ON (fbtl.fid = fb.fid) WHERE fbtl.lid = '530' AND fbtl.fid != '0' AND size_x_new >= size_y_new
Called from: Tilllate_Location->getImages()
Affected rows: 2 Execution time: 0.000243902206421s Database ID: 'default' Master used: no"
["priority"]=>
int(6)
["priorityName"]=>
string(4) "INFO"
["microtime"]=>
float(1283507907.17)
}
[9]=>
array(5) {
["timestamp"]=>
string(25) "2010-09-03T11:58:27+02:00"
["message"]=>
string(204) "Query statement: SELECT * FROM fbconnect_users WHERE `uid`='735' LIMIT 1
Called from: Trevi_Db_Row->_loadByQuery()
Affected rows: 0 Execution time: 0.00727796554565s Database ID: 'default' Master used: no"
["priority"]=>
int(6)
["priorityName"]=>
string(4) "INFO"
["microtime"]=>
float(1283507907.21)
}
[10]=>
array(5) {
["timestamp"]=>
string(25) "2010-09-03T11:58:27+02:00"
["message"]=>
string(288) "Query statement: SELECT directory, filename_small, filename_big, mogilefs_hash_small, mogilefs_hash_big
FROM member_passfotos WHERE uid = '735'
Called from: Tilllate_User->getMemberPhotoData()
Affected rows: 1 Execution time: 0.000558853149414s Database ID: 'default' Master used: no"
["priority"]=>
int(6)
["priorityName"]=>
string(4) "INFO"
["microtime"]=>
float(1283507907.21)
}
[11]=>
array(5) {
["timestamp"]=>
string(25) "2010-09-03T11:58:27+02:00"
["message"]=>
string(2435) "Query statement: SELECT rid,(CASE WHEN region <> '' THEN region WHEN region_EN <> '' THEN region_EN WHEN region_FR <> '' THEN region_FR WHEN region_IT <> '' THEN region_IT WHEN region_ES <> '' THEN region_ES WHEN region_BG <> '' THEN region_BG WHEN region_TR <> '' THEN region_TR WHEN region_NL <> '' THEN region_NL WHEN region_RO <> '' THEN region_RO ELSE '' END) as region,after_timespan,after_count,after_prio,pre_timespan,
pre_count,pre_prio,aktiv,mapdata,special_timespan,special_count,mapdata_new,is_smallregion,
show_todays_events,regionhome_html,r.country_id,default_language,
(CASE WHEN artikel <> '' THEN artikel WHEN artikel_EN <> '' THEN artikel_EN WHEN artikel_FR <> '' THEN artikel_FR WHEN artikel_IT <> '' THEN artikel_IT WHEN artikel_ES <> '' THEN artikel_ES WHEN artikel_BG <> '' THEN artikel_BG WHEN artikel_TR <> '' THEN artikel_TR WHEN artikel_NL <> '' THEN artikel_NL WHEN artikel_RO <> '' THEN artikel_RO ELSE '' END) as artikel,regionen_kombination_id,region_header_image,cid,
(CASE WHEN name <> '' THEN name WHEN name_EN <> '' THEN name_EN WHEN name_FR <> '' THEN name_FR WHEN name_IT <> '' THEN name_IT WHEN name_ES <> '' THEN name_ES WHEN name_BG <> '' THEN name_BG WHEN name_TR <> '' THEN name_TR WHEN name_NL <> '' THEN name_NL WHEN name_RO <> '' THEN name_RO ELSE '' END) as name,pos,ts,(CASE WHEN state_dropdown_label <> '' THEN state_dropdown_label WHEN state_dropdown_label_EN <> '' THEN state_dropdown_label_EN WHEN state_dropdown_label_FR <> '' THEN state_dropdown_label_FR WHEN state_dropdown_label_IT <> '' THEN state_dropdown_label_IT WHEN state_dropdown_label_ES <> '' THEN state_dropdown_label_ES WHEN state_dropdown_label_BG <> '' THEN state_dropdown_label_BG WHEN state_dropdown_label_TR <> '' THEN state_dropdown_label_TR WHEN state_dropdown_label_NL <> '' THEN state_dropdown_label_NL WHEN state_dropdown_label_RO <> '' THEN state_dropdown_label_RO ELSE '' END) as state_dropdown_label,currency,isocode,phone_countrycode,
fully_covered_by_regions,country_site_id, cs.state_code
FROM regionen r
INNER JOIN countries c ON (r.country_id=c.cid)
LEFT JOIN countries_states cs ON cs.stateid=''
WHERE r.rid=''
Called from: Tilllate_User->getRegions()
Affected rows: 0 Execution time: 0.000497102737427s Database ID: 'default' Master used: no"
["priority"]=>
int(6)
["priorityName"]=>
string(4) "INFO"
["microtime"]=>
float(1283507907.21)
}
[12]=>
array(5) {
["timestamp"]=>
string(25) "2010-09-03T11:58:27+02:00"
["message"]=>
string(207) "Query statement: SELECT * FROM fbconnect_users WHERE `uid`='28906' LIMIT 1
Called from: Trevi_Db_Row->_loadByQuery()
Affected rows: 0 Execution time: 0.000590085983276s Database ID: 'default' Master used: no"
["priority"]=>
int(6)
["priorityName"]=>
string(4) "INFO"
["microtime"]=>
float(1283507907.21)
}
[13]=>
array(5) {
["timestamp"]=>
string(25) "2010-09-03T11:58:27+02:00"
["message"]=>
string(290) "Query statement: SELECT directory, filename_small, filename_big, mogilefs_hash_small, mogilefs_hash_big
FROM member_passfotos WHERE uid = '28906'
Called from: Tilllate_User->getMemberPhotoData()
Affected rows: 1 Execution time: 0.000652074813843s Database ID: 'default' Master used: no"
["priority"]=>
int(6)
["priorityName"]=>
string(4) "INFO"
["microtime"]=>
float(1283507907.22)
}
[14]=>
array(5) {
["timestamp"]=>
string(25) "2010-09-03T11:58:27+02:00"
["message"]=>
string(2434) "Query statement: SELECT rid,(CASE WHEN region <> '' THEN region WHEN region_EN <> '' THEN region_EN WHEN region_FR <> '' THEN region_FR WHEN region_IT <> '' THEN region_IT WHEN region_ES <> '' THEN region_ES WHEN region_BG <> '' THEN region_BG WHEN region_TR <> '' THEN region_TR WHEN region_NL <> '' THEN region_NL WHEN region_RO <> '' THEN region_RO ELSE '' END) as region,after_timespan,after_count,after_prio,pre_timespan,
pre_count,pre_prio,aktiv,mapdata,special_timespan,special_count,mapdata_new,is_smallregion,
show_todays_events,regionhome_html,r.country_id,default_language,
(CASE WHEN artikel <> '' THEN artikel WHEN artikel_EN <> '' THEN artikel_EN WHEN artikel_FR <> '' THEN artikel_FR WHEN artikel_IT <> '' THEN artikel_IT WHEN artikel_ES <> '' THEN artikel_ES WHEN artikel_BG <> '' THEN artikel_BG WHEN artikel_TR <> '' THEN artikel_TR WHEN artikel_NL <> '' THEN artikel_NL WHEN artikel_RO <> '' THEN artikel_RO ELSE '' END) as artikel,regionen_kombination_id,region_header_image,cid,
(CASE WHEN name <> '' THEN name WHEN name_EN <> '' THEN name_EN WHEN name_FR <> '' THEN name_FR WHEN name_IT <> '' THEN name_IT WHEN name_ES <> '' THEN name_ES WHEN name_BG <> '' THEN name_BG WHEN name_TR <> '' THEN name_TR WHEN name_NL <> '' THEN name_NL WHEN name_RO <> '' THEN name_RO ELSE '' END) as name,pos,ts,(CASE WHEN state_dropdown_label <> '' THEN state_dropdown_label WHEN state_dropdown_label_EN <> '' THEN state_dropdown_label_EN WHEN state_dropdown_label_FR <> '' THEN state_dropdown_label_FR WHEN state_dropdown_label_IT <> '' THEN state_dropdown_label_IT WHEN state_dropdown_label_ES <> '' THEN state_dropdown_label_ES WHEN state_dropdown_label_BG <> '' THEN state_dropdown_label_BG WHEN state_dropdown_label_TR <> '' THEN state_dropdown_label_TR WHEN state_dropdown_label_NL <> '' THEN state_dropdown_label_NL WHEN state_dropdown_label_RO <> '' THEN state_dropdown_label_RO ELSE '' END) as state_dropdown_label,currency,isocode,phone_countrycode,
fully_covered_by_regions,country_site_id, cs.state_code
FROM regionen r
INNER JOIN countries c ON (r.country_id=c.cid)
LEFT JOIN countries_states cs ON cs.stateid=''
WHERE r.rid=''
Called from: Tilllate_User->getRegions()
Affected rows: 0 Execution time: 0.00061297416687s Database ID: 'default' Master used: no"
["priority"]=>
int(6)
["priorityName"]=>
string(4) "INFO"
["microtime"]=>
float(1283507907.22)
}
[15]=>
array(5) {
["timestamp"]=>
string(25) "2010-09-03T11:58:27+02:00"
["message"]=>
string(205) "Query statement: SELECT * FROM fbconnect_users WHERE `uid`='37190' LIMIT 1
Called from: Trevi_Db_Row->_loadByQuery()
Affected rows: 0 Execution time: 0.0075569152832s Database ID: 'default' Master used: no"
["priority"]=>
int(6)
["priorityName"]=>
string(4) "INFO"
["microtime"]=>
float(1283507907.23)
}
[16]=>
array(5) {
["timestamp"]=>
string(25) "2010-09-03T11:58:27+02:00"
["message"]=>
string(290) "Query statement: SELECT directory, filename_small, filename_big, mogilefs_hash_small, mogilefs_hash_big
FROM member_passfotos WHERE uid = '37190'
Called from: Tilllate_User->getMemberPhotoData()
Affected rows: 1 Execution time: 0.000654935836792s Database ID: 'default' Master used: no"
["priority"]=>
int(6)
["priorityName"]=>
string(4) "INFO"
["microtime"]=>
float(1283507907.23)
}
[17]=>
array(5) {
["timestamp"]=>
string(25) "2010-09-03T11:58:27+02:00"
["message"]=>
string(2435) "Query statement: SELECT rid,(CASE WHEN region <> '' THEN region WHEN region_EN <> '' THEN region_EN WHEN region_FR <> '' THEN region_FR WHEN region_IT <> '' THEN region_IT WHEN region_ES <> '' THEN region_ES WHEN region_BG <> '' THEN region_BG WHEN region_TR <> '' THEN region_TR WHEN region_NL <> '' THEN region_NL WHEN region_RO <> '' THEN region_RO ELSE '' END) as region,after_timespan,after_count,after_prio,pre_timespan,
pre_count,pre_prio,aktiv,mapdata,special_timespan,special_count,mapdata_new,is_smallregion,
show_todays_events,regionhome_html,r.country_id,default_language,
(CASE WHEN artikel <> '' THEN artikel WHEN artikel_EN <> '' THEN artikel_EN WHEN artikel_FR <> '' THEN artikel_FR WHEN artikel_IT <> '' THEN artikel_IT WHEN artikel_ES <> '' THEN artikel_ES WHEN artikel_BG <> '' THEN artikel_BG WHEN artikel_TR <> '' THEN artikel_TR WHEN artikel_NL <> '' THEN artikel_NL WHEN artikel_RO <> '' THEN artikel_RO ELSE '' END) as artikel,regionen_kombination_id,region_header_image,cid,
(CASE WHEN name <> '' THEN name WHEN name_EN <> '' THEN name_EN WHEN name_FR <> '' THEN name_FR WHEN name_IT <> '' THEN name_IT WHEN name_ES <> '' THEN name_ES WHEN name_BG <> '' THEN name_BG WHEN name_TR <> '' THEN name_TR WHEN name_NL <> '' THEN name_NL WHEN name_RO <> '' THEN name_RO ELSE '' END) as name,pos,ts,(CASE WHEN state_dropdown_label <> '' THEN state_dropdown_label WHEN state_dropdown_label_EN <> '' THEN state_dropdown_label_EN WHEN state_dropdown_label_FR <> '' THEN state_dropdown_label_FR WHEN state_dropdown_label_IT <> '' THEN state_dropdown_label_IT WHEN state_dropdown_label_ES <> '' THEN state_dropdown_label_ES WHEN state_dropdown_label_BG <> '' THEN state_dropdown_label_BG WHEN state_dropdown_label_TR <> '' THEN state_dropdown_label_TR WHEN state_dropdown_label_NL <> '' THEN state_dropdown_label_NL WHEN state_dropdown_label_RO <> '' THEN state_dropdown_label_RO ELSE '' END) as state_dropdown_label,currency,isocode,phone_countrycode,
fully_covered_by_regions,country_site_id, cs.state_code
FROM regionen r
INNER JOIN countries c ON (r.country_id=c.cid)
LEFT JOIN countries_states cs ON cs.stateid=''
WHERE r.rid=''
Called from: Tilllate_User->getRegions()
Affected rows: 0 Execution time: 0.000609874725342s Database ID: 'default' Master used: no"
["priority"]=>
int(6)
["priorityName"]=>
string(4) "INFO"
["microtime"]=>
float(1283507907.23)
}
[18]=>
array(5) {
["timestamp"]=>
string(25) "2010-09-03T11:58:27+02:00"
["message"]=>
string(207) "Query statement: SELECT * FROM fbconnect_users WHERE `uid`='158971' LIMIT 1
Called from: Trevi_Db_Row->_loadByQuery()
Affected rows: 0 Execution time: 0.00827813148499s Database ID: 'default' Master used: no"
["priority"]=>
int(6)
["priorityName"]=>
string(4) "INFO"
["microtime"]=>
float(1283507907.24)
}
[19]=>
array(5) {
["timestamp"]=>
string(25) "2010-09-03T11:58:27+02:00"
["message"]=>
string(291) "Query statement: SELECT directory, filename_small, filename_big, mogilefs_hash_small, mogilefs_hash_big
FROM member_passfotos WHERE uid = '158971'
Called from: Tilllate_User->getMemberPhotoData()
Affected rows: 0 Execution time: 0.000799179077148s Database ID: 'default' Master used: no"
["priority"]=>
int(6)
["priorityName"]=>
string(4) "INFO"
["microtime"]=>
float(1283507907.24)
}
[20]=>
array(5) {
["timestamp"]=>
string(25) "2010-09-03T11:58:27+02:00"
["message"]=>
string(2435) "Query statement: SELECT rid,(CASE WHEN region <> '' THEN region WHEN region_EN <> '' THEN region_EN WHEN region_FR <> '' THEN region_FR WHEN region_IT <> '' THEN region_IT WHEN region_ES <> '' THEN region_ES WHEN region_BG <> '' THEN region_BG WHEN region_TR <> '' THEN region_TR WHEN region_NL <> '' THEN region_NL WHEN region_RO <> '' THEN region_RO ELSE '' END) as region,after_timespan,after_count,after_prio,pre_timespan,
pre_count,pre_prio,aktiv,mapdata,special_timespan,special_count,mapdata_new,is_smallregion,
show_todays_events,regionhome_html,r.country_id,default_language,
(CASE WHEN artikel <> '' THEN artikel WHEN artikel_EN <> '' THEN artikel_EN WHEN artikel_FR <> '' THEN artikel_FR WHEN artikel_IT <> '' THEN artikel_IT WHEN artikel_ES <> '' THEN artikel_ES WHEN artikel_BG <> '' THEN artikel_BG WHEN artikel_TR <> '' THEN artikel_TR WHEN artikel_NL <> '' THEN artikel_NL WHEN artikel_RO <> '' THEN artikel_RO ELSE '' END) as artikel,regionen_kombination_id,region_header_image,cid,
(CASE WHEN name <> '' THEN name WHEN name_EN <> '' THEN name_EN WHEN name_FR <> '' THEN name_FR WHEN name_IT <> '' THEN name_IT WHEN name_ES <> '' THEN name_ES WHEN name_BG <> '' THEN name_BG WHEN name_TR <> '' THEN name_TR WHEN name_NL <> '' THEN name_NL WHEN name_RO <> '' THEN name_RO ELSE '' END) as name,pos,ts,(CASE WHEN state_dropdown_label <> '' THEN state_dropdown_label WHEN state_dropdown_label_EN <> '' THEN state_dropdown_label_EN WHEN state_dropdown_label_FR <> '' THEN state_dropdown_label_FR WHEN state_dropdown_label_IT <> '' THEN state_dropdown_label_IT WHEN state_dropdown_label_ES <> '' THEN state_dropdown_label_ES WHEN state_dropdown_label_BG <> '' THEN state_dropdown_label_BG WHEN state_dropdown_label_TR <> '' THEN state_dropdown_label_TR WHEN state_dropdown_label_NL <> '' THEN state_dropdown_label_NL WHEN state_dropdown_label_RO <> '' THEN state_dropdown_label_RO ELSE '' END) as state_dropdown_label,currency,isocode,phone_countrycode,
fully_covered_by_regions,country_site_id, cs.state_code
FROM regionen r
INNER JOIN countries c ON (r.country_id=c.cid)
LEFT JOIN countries_states cs ON cs.stateid=''
WHERE r.rid=''
Called from: Tilllate_User->getRegions()
Affected rows: 0 Execution time: 0.000725030899048s Database ID: 'default' Master used: no"
["priority"]=>
int(6)
["priorityName"]=>
string(4) "INFO"
["microtime"]=>
float(1283507907.24)
}
[21]=>
array(5) {
["timestamp"]=>
string(25) "2010-09-03T11:58:27+02:00"
["message"]=>
string(207) "Query statement: SELECT * FROM fbconnect_users WHERE `uid`='184112' LIMIT 1
Called from: Trevi_Db_Row->_loadByQuery()
Affected rows: 0 Execution time: 0.00816082954407s Database ID: 'default' Master used: no"
["priority"]=>
int(6)
["priorityName"]=>
string(4) "INFO"
["microtime"]=>
float(1283507907.25)
}
[22]=>
array(5) {
["timestamp"]=>
string(25) "2010-09-03T11:58:27+02:00"
["message"]=>
string(291) "Query statement: SELECT directory, filename_small, filename_big, mogilefs_hash_small, mogilefs_hash_big
FROM member_passfotos WHERE uid = '184112'
Called from: Tilllate_User->getMemberPhotoData()
Affected rows: 1 Execution time: 0.000648021697998s Database ID: 'default' Master used: no"
["priority"]=>
int(6)
["priorityName"]=>
string(4) "INFO"
["microtime"]=>
float(1283507907.25)
}
[23]=>
array(5) {
["timestamp"]=>
string(25) "2010-09-03T11:58:27+02:00"
["message"]=>
string(2435) "Query statement: SELECT rid,(CASE WHEN region <> '' THEN region WHEN region_EN <> '' THEN region_EN WHEN region_FR <> '' THEN region_FR WHEN region_IT <> '' THEN region_IT WHEN region_ES <> '' THEN region_ES WHEN region_BG <> '' THEN region_BG WHEN region_TR <> '' THEN region_TR WHEN region_NL <> '' THEN region_NL WHEN region_RO <> '' THEN region_RO ELSE '' END) as region,after_timespan,after_count,after_prio,pre_timespan,
pre_count,pre_prio,aktiv,mapdata,special_timespan,special_count,mapdata_new,is_smallregion,
show_todays_events,regionhome_html,r.country_id,default_language,
(CASE WHEN artikel <> '' THEN artikel WHEN artikel_EN <> '' THEN artikel_EN WHEN artikel_FR <> '' THEN artikel_FR WHEN artikel_IT <> '' THEN artikel_IT WHEN artikel_ES <> '' THEN artikel_ES WHEN artikel_BG <> '' THEN artikel_BG WHEN artikel_TR <> '' THEN artikel_TR WHEN artikel_NL <> '' THEN artikel_NL WHEN artikel_RO <> '' THEN artikel_RO ELSE '' END) as artikel,regionen_kombination_id,region_header_image,cid,
(CASE WHEN name <> '' THEN name WHEN name_EN <> '' THEN name_EN WHEN name_FR <> '' THEN name_FR WHEN name_IT <> '' THEN name_IT WHEN name_ES <> '' THEN name_ES WHEN name_BG <> '' THEN name_BG WHEN name_TR <> '' THEN name_TR WHEN name_NL <> '' THEN name_NL WHEN name_RO <> '' THEN name_RO ELSE '' END) as name,pos,ts,(CASE WHEN state_dropdown_label <> '' THEN state_dropdown_label WHEN state_dropdown_label_EN <> '' THEN state_dropdown_label_EN WHEN state_dropdown_label_FR <> '' THEN state_dropdown_label_FR WHEN state_dropdown_label_IT <> '' THEN state_dropdown_label_IT WHEN state_dropdown_label_ES <> '' THEN state_dropdown_label_ES WHEN state_dropdown_label_BG <> '' THEN state_dropdown_label_BG WHEN state_dropdown_label_TR <> '' THEN state_dropdown_label_TR WHEN state_dropdown_label_NL <> '' THEN state_dropdown_label_NL WHEN state_dropdown_label_RO <> '' THEN state_dropdown_label_RO ELSE '' END) as state_dropdown_label,currency,isocode,phone_countrycode,
fully_covered_by_regions,country_site_id, cs.state_code
FROM regionen r
INNER JOIN countries c ON (r.country_id=c.cid)
LEFT JOIN countries_states cs ON cs.stateid=''
WHERE r.rid=''
Called from: Tilllate_User->getRegions()
Affected rows: 0 Execution time: 0.000603199005127s Database ID: 'default' Master used: no"
["priority"]=>
int(6)
["priorityName"]=>
string(4) "INFO"
["microtime"]=>
float(1283507907.25)
}
[24]=>
array(5) {
["timestamp"]=>
string(25) "2010-09-03T11:58:27+02:00"
["message"]=>
string(207) "Query statement: SELECT * FROM fbconnect_users WHERE `uid`='222664' LIMIT 1
Called from: Trevi_Db_Row->_loadByQuery()
Affected rows: 1 Execution time: 0.00142598152161s Database ID: 'default' Master used: no"
["priority"]=>
int(6)
["priorityName"]=>
string(4) "INFO"
["microtime"]=>
float(1283507907.26)
}
[25]=>
array(5) {
["timestamp"]=>
string(25) "2010-09-03T11:58:27+02:00"
["message"]=>
string(291) "Query statement: SELECT directory, filename_small, filename_big, mogilefs_hash_small, mogilefs_hash_big
FROM member_passfotos WHERE uid = '222664'
Called from: Tilllate_User->getMemberPhotoData()
Affected rows: 1 Execution time: 0.000535011291504s Database ID: 'default' Master used: no"
["priority"]=>
int(6)
["priorityName"]=>
string(4) "INFO"
["microtime"]=>
float(1283507907.26)
}
[26]=>
array(5) {
["timestamp"]=>
string(25) "2010-09-03T11:58:27+02:00"
["message"]=>
string(291) "Query statement: SELECT directory, filename_small, filename_big, mogilefs_hash_small, mogilefs_hash_big
FROM member_passfotos WHERE uid = '222664'
Called from: Tilllate_User->getMemberPhotoData()
Affected rows: 1 Execution time: 0.000643968582153s Database ID: 'default' Master used: no"
["priority"]=>
int(6)
["priorityName"]=>
string(4) "INFO"
["microtime"]=>
float(1283507907.26)
}
[27]=>
array(5) {
["timestamp"]=>
string(25) "2010-09-03T11:58:27+02:00"
["message"]=>
string(2434) "Query statement: SELECT rid,(CASE WHEN region <> '' THEN region WHEN region_EN <> '' THEN region_EN WHEN region_FR <> '' THEN region_FR WHEN region_IT <> '' THEN region_IT WHEN region_ES <> '' THEN region_ES WHEN region_BG <> '' THEN region_BG WHEN region_TR <> '' THEN region_TR WHEN region_NL <> '' THEN region_NL WHEN region_RO <> '' THEN region_RO ELSE '' END) as region,after_timespan,after_count,after_prio,pre_timespan,
pre_count,pre_prio,aktiv,mapdata,special_timespan,special_count,mapdata_new,is_smallregion,
show_todays_events,regionhome_html,r.country_id,default_language,
(CASE WHEN artikel <> '' THEN artikel WHEN artikel_EN <> '' THEN artikel_EN WHEN artikel_FR <> '' THEN artikel_FR WHEN artikel_IT <> '' THEN artikel_IT WHEN artikel_ES <> '' THEN artikel_ES WHEN artikel_BG <> '' THEN artikel_BG WHEN artikel_TR <> '' THEN artikel_TR WHEN artikel_NL <> '' THEN artikel_NL WHEN artikel_RO <> '' THEN artikel_RO ELSE '' END) as artikel,regionen_kombination_id,region_header_image,cid,
(CASE WHEN name <> '' THEN name WHEN name_EN <> '' THEN name_EN WHEN name_FR <> '' THEN name_FR WHEN name_IT <> '' THEN name_IT WHEN name_ES <> '' THEN name_ES WHEN name_BG <> '' THEN name_BG WHEN name_TR <> '' THEN name_TR WHEN name_NL <> '' THEN name_NL WHEN name_RO <> '' THEN name_RO ELSE '' END) as name,pos,ts,(CASE WHEN state_dropdown_label <> '' THEN state_dropdown_label WHEN state_dropdown_label_EN <> '' THEN state_dropdown_label_EN WHEN state_dropdown_label_FR <> '' THEN state_dropdown_label_FR WHEN state_dropdown_label_IT <> '' THEN state_dropdown_label_IT WHEN state_dropdown_label_ES <> '' THEN state_dropdown_label_ES WHEN state_dropdown_label_BG <> '' THEN state_dropdown_label_BG WHEN state_dropdown_label_TR <> '' THEN state_dropdown_label_TR WHEN state_dropdown_label_NL <> '' THEN state_dropdown_label_NL WHEN state_dropdown_label_RO <> '' THEN state_dropdown_label_RO ELSE '' END) as state_dropdown_label,currency,isocode,phone_countrycode,
fully_covered_by_regions,country_site_id, cs.state_code
FROM regionen r
INNER JOIN countries c ON (r.country_id=c.cid)
LEFT JOIN countries_states cs ON cs.stateid=''
WHERE r.rid=''
Called from: Tilllate_User->getRegions()
Affected rows: 0 Execution time: 0.00060510635376s Database ID: 'default' Master used: no"
["priority"]=>
int(6)
["priorityName"]=>
string(4) "INFO"
["microtime"]=>
float(1283507907.26)
}
[28]=>
array(5) {
["timestamp"]=>
string(25) "2010-09-03T11:58:27+02:00"
["message"]=>
string(212) "Query statement: SELECT * FROM regionen WHERE `rid`='6' AND `aktiv`='1' LIMIT 1
Called from: Trevi_Db_Row->_loadByQuery()
Affected rows: 1 Execution time: 0.000327110290527s Database ID: 'default' Master used: no"
["priority"]=>
int(6)
["priorityName"]=>
string(4) "INFO"
["microtime"]=>
float(1283507907.28)
}
[29]=>
array(5) {
["timestamp"]=>
string(25) "2010-09-03T11:58:27+02:00"
["message"]=>
string(212) "Query statement: SELECT * FROM regionen WHERE `rid`='4' AND `aktiv`='1' LIMIT 1
Called from: Trevi_Db_Row->_loadByQuery()
Affected rows: 1 Execution time: 0.000388860702515s Database ID: 'default' Master used: no"
["priority"]=>
int(6)
["priorityName"]=>
string(4) "INFO"
["microtime"]=>
float(1283507907.28)
}
[30]=>
array(5) {
["timestamp"]=>
string(25) "2010-09-03T11:58:27+02:00"
["message"]=>
string(212) "Query statement: SELECT * FROM regionen WHERE `rid`='8' AND `aktiv`='1' LIMIT 1
Called from: Trevi_Db_Row->_loadByQuery()
Affected rows: 1 Execution time: 0.000303030014038s Database ID: 'default' Master used: no"
["priority"]=>
int(6)
["priorityName"]=>
string(4) "INFO"
["microtime"]=>
float(1283507907.28)
}
[31]=>
array(5) {
["timestamp"]=>
string(25) "2010-09-03T11:58:27+02:00"
["message"]=>
string(214) "Query statement: SELECT * FROM regionen WHERE `rid`='113' AND `aktiv`='1' LIMIT 1
Called from: Trevi_Db_Row->_loadByQuery()
Affected rows: 1 Execution time: 0.000323057174683s Database ID: 'default' Master used: no"
["priority"]=>
int(6)
["priorityName"]=>
string(4) "INFO"
["microtime"]=>
float(1283507907.28)
}
[32]=>
array(5) {
["timestamp"]=>
string(25) "2010-09-03T11:58:27+02:00"
["message"]=>
string(212) "Query statement: SELECT * FROM regionen WHERE `rid`='9' AND `aktiv`='1' LIMIT 1
Called from: Trevi_Db_Row->_loadByQuery()
Affected rows: 1 Execution time: 0.000319957733154s Database ID: 'default' Master used: no"
["priority"]=>
int(6)
["priorityName"]=>
string(4) "INFO"
["microtime"]=>
float(1283507907.28)
}
[33]=>
array(5) {
["timestamp"]=>
string(25) "2010-09-03T11:58:27+02:00"
["message"]=>
string(212) "Query statement: SELECT * FROM regionen WHERE `rid`='3' AND `aktiv`='1' LIMIT 1
Called from: Trevi_Db_Row->_loadByQuery()
Affected rows: 1 Execution time: 0.000306844711304s Database ID: 'default' Master used: no"
["priority"]=>
int(6)
["priorityName"]=>
string(4) "INFO"
["microtime"]=>
float(1283507907.29)
}
[34]=>
array(5) {
["timestamp"]=>
string(25) "2010-09-03T11:58:27+02:00"
["message"]=>
string(214) "Query statement: SELECT * FROM regionen WHERE `rid`='114' AND `aktiv`='1' LIMIT 1
Called from: Trevi_Db_Row->_loadByQuery()
Affected rows: 1 Execution time: 0.000316858291626s Database ID: 'default' Master used: no"
["priority"]=>
int(6)
["priorityName"]=>
string(4) "INFO"
["microtime"]=>
float(1283507907.29)
}
[35]=>
array(5) {
["timestamp"]=>
string(25) "2010-09-03T11:58:27+02:00"
["message"]=>
string(212) "Query statement: SELECT * FROM regionen WHERE `rid`='7' AND `aktiv`='1' LIMIT 1
Called from: Trevi_Db_Row->_loadByQuery()
Affected rows: 1 Execution time: 0.000318050384521s Database ID: 'default' Master used: no"
["priority"]=>
int(6)
["priorityName"]=>
string(4) "INFO"
["microtime"]=>
float(1283507907.29)
}
[36]=>
array(5) {
["timestamp"]=>
string(25) "2010-09-03T11:58:27+02:00"
["message"]=>
string(212) "Query statement: SELECT * FROM regionen WHERE `rid`='1' AND `aktiv`='1' LIMIT 1
Called from: Trevi_Db_Row->_loadByQuery()
Affected rows: 1 Execution time: 0.000550031661987s Database ID: 'default' Master used: no"
["priority"]=>
int(6)
["priorityName"]=>
string(4) "INFO"
["microtime"]=>
float(1283507907.29)
}
[37]=>
array(5) {
["timestamp"]=>
string(25) "2010-09-03T11:58:27+02:00"
["message"]=>
string(213) "Query statement: SELECT * FROM regionen WHERE `rid`='10' AND `aktiv`='1' LIMIT 1
Called from: Trevi_Db_Row->_loadByQuery()
Affected rows: 1 Execution time: 0.000640869140625s Database ID: 'default' Master used: no"
["priority"]=>
int(6)
["priorityName"]=>
string(4) "INFO"
["microtime"]=>
float(1283507907.29)
}
[38]=>
array(5) {
["timestamp"]=>
string(25) "2010-09-03T11:58:27+02:00"
["message"]=>
string(213) "Query statement: SELECT * FROM regionen WHERE `rid`='11' AND `aktiv`='1' LIMIT 1
Called from: Trevi_Db_Row->_loadByQuery()
Affected rows: 1 Execution time: 0.000504016876221s Database ID: 'default' Master used: no"
["priority"]=>
int(6)
["priorityName"]=>
string(4) "INFO"
["microtime"]=>
float(1283507907.3)
}
[39]=>
array(5) {
["timestamp"]=>
string(25) "2010-09-03T11:58:27+02:00"
["message"]=>
string(213) "Query statement: SELECT * FROM regionen WHERE `rid`='112' AND `aktiv`='1' LIMIT 1
Called from: Trevi_Db_Row->_loadByQuery()
Affected rows: 1 Execution time: 0.00100803375244s Database ID: 'default' Master used: no"
["priority"]=>
int(6)
["priorityName"]=>
string(4) "INFO"
["microtime"]=>
float(1283507907.3)
}
[40]=>
array(5) {
["timestamp"]=>
string(25) "2010-09-03T11:58:27+02:00"
["message"]=>
string(212) "Query statement: SELECT * FROM regionen WHERE `rid`='5' AND `aktiv`='1' LIMIT 1
Called from: Trevi_Db_Row->_loadByQuery()
Affected rows: 1 Execution time: 0.000378847122192s Database ID: 'default' Master used: no"
["priority"]=>
int(6)
["priorityName"]=>
string(4) "INFO"
["microtime"]=>
float(1283507907.3)
}
[41]=>
array(5) {
["timestamp"]=>
string(25) "2010-09-03T11:58:27+02:00"
["message"]=>
string(492) "Query statement: SELECT
a.id,
a.subject_uid,
at.name,
a.params,
UNIX_TIMESTAMP(ts) AS date
FROM activities a
LEFT JOIN activities_types at ON at.id=a.activity_id
WHERE a.site_id = '1'
ORDER BY ts DESC
LIMIT '40'
Called from: Tilllate_Activity::fetchItems()
Affected rows: 40 Execution time: 0.000370025634766s Database ID: 'default' Master used: no"
["priority"]=>
int(6)
["priorityName"]=>
string(4) "INFO"
["microtime"]=>
float(1283507907.34)
}
[42]=>
array(5) {
["timestamp"]=>
string(25) "2010-09-03T11:58:27+02:00"
["message"]=>
string(1952) "Query statement: SELECT
u.uid,
u.username,
up.password_md5 as password,
u.vorletzter_login,
u.letzter_login,
u.email,
u.alterskat,
u.taetigkeit,
u.job,
u.wohnort,
u.will_mailing,
u.will_kontakt,
u.host,
u.status,
u.will_notification,
u.myalbummode,
u.ist_administrator,
u.erster_login,
u.ist_organisator,
u.pr_eintrpreis,
u.pr_getrpreis,
u.pr_ptid,
u.geschlecht,
u.anzahl_logins,
u.will_myevents,
u.vorname,
u.name,
u.funktion_in_firma,
u.strasse,
u.plz,
u.ort,
u.rid,
u.telnr,
u.telnr_carrier,
u.letzter_gewinn,
u.res,
u.mitfoto,
u.msg,
u.validiert,
u.gesperrt,
u.regselect,
u.gebdatum,
u.orgid,
u.users_ts,
u.org_valid,
u.registration_ongoing,
u.country,
u.country_stateid,
u.will_emailwerbung,
u.chat_status,
u.chat_msgwaiting,
u.site_id,
u.language,
u.bookingtoolflag,
u.datenquelle,
u.company,
u.visitedMemberpages,
u.tel_privat,
u.tel_geschaeft,
u.ist_artist,
u.mail_notification,
u.promoterzone_last_orgid,
UNIX_TIMESTAMP(u.gebdatum) as dateOfBirth,
mp.filename_small,
mp.directory,
mk.step AS karma_step,
mg.id as goldmemberId,
mg.gold_aktiv,
mo.shown_in_activities,
mo.profilevisit_visibility,
mo.hide_profile_todos,
mo.privacy_visibility,
mo.online_visibility,
mo.timfotos_visibility,
mo.favfotos_visibility,
mo.buddylist_visibility,
mo.passfoto_visibility,
mo.event_visibility,
mo.event_einladungen,
mo.contact_by,
mo.contact_by_sms,
mo.contact_by_email,
mo.allcomments_visibility,
sc.uid as online
FROM users AS u
LEFT JOIN users_password AS up ON u.uid = up.uid
LEFT JOIN member_passfotos AS mp ON u.uid = mp.uid
LEFT JOIN member_karma AS mk ON u.uid = mk.uid
LEFT JOIN member_gold AS mg ON u.uid = mg.uid
LEFT JOIN member_options AS mo ON u.uid = mo.uid
LEFT JOIN active_session_cache as sc ON (sc.uid=u.uid)
LEFT JOIN adv_jobs aj ON (aj.uid=u.uid)
WHERE `u`.`uid` = '13329652' LIMIT 1
Called from: Trevi_Db_Row->_loadByQuery()
Affected rows: 1 Execution time: 0.000496864318848s Database ID: 'default' Master used: no"
["priority"]=>
int(6)
["priorityName"]=>
string(4) "INFO"
["microtime"]=>
float(1283507907.34)
}
[43]=>
array(5) {
["timestamp"]=>
string(25) "2010-09-03T11:58:27+02:00"
["message"]=>
string(210) "Query statement: SELECT * FROM fbconnect_users WHERE `uid`='13329652' LIMIT 1
Called from: Trevi_Db_Row->_loadByQuery()
Affected rows: 0 Execution time: 0.000214099884033s Database ID: 'default' Master used: no"
["priority"]=>
int(6)
["priorityName"]=>
string(4) "INFO"
["microtime"]=>
float(1283507907.34)
}
[44]=>
array(5) {
["timestamp"]=>
string(25) "2010-09-03T11:58:27+02:00"
["message"]=>
string(293) "Query statement: SELECT directory, filename_small, filename_big, mogilefs_hash_small, mogilefs_hash_big
FROM member_passfotos WHERE uid = '13329652'
Called from: Tilllate_User->getMemberPhotoData()
Affected rows: 1 Execution time: 0.000205993652344s Database ID: 'default' Master used: no"
["priority"]=>
int(6)
["priorityName"]=>
string(4) "INFO"
["microtime"]=>
float(1283507907.34)
}
[45]=>
array(5) {
["timestamp"]=>
string(25) "2010-09-03T11:58:27+02:00"
["message"]=>
string(1952) "Query statement: SELECT
u.uid,
u.username,
up.password_md5 as password,
u.vorletzter_login,
u.letzter_login,
u.email,
u.alterskat,
u.taetigkeit,
u.job,
u.wohnort,
u.will_mailing,
u.will_kontakt,
u.host,
u.status,
u.will_notification,
u.myalbummode,
u.ist_administrator,
u.erster_login,
u.ist_organisator,
u.pr_eintrpreis,
u.pr_getrpreis,
u.pr_ptid,
u.geschlecht,
u.anzahl_logins,
u.will_myevents,
u.vorname,
u.name,
u.funktion_in_firma,
u.strasse,
u.plz,
u.ort,
u.rid,
u.telnr,
u.telnr_carrier,
u.letzter_gewinn,
u.res,
u.mitfoto,
u.msg,
u.validiert,
u.gesperrt,
u.regselect,
u.gebdatum,
u.orgid,
u.users_ts,
u.org_valid,
u.registration_ongoing,
u.country,
u.country_stateid,
u.will_emailwerbung,
u.chat_status,
u.chat_msgwaiting,
u.site_id,
u.language,
u.bookingtoolflag,
u.datenquelle,
u.company,
u.visitedMemberpages,
u.tel_privat,
u.tel_geschaeft,
u.ist_artist,
u.mail_notification,
u.promoterzone_last_orgid,
UNIX_TIMESTAMP(u.gebdatum) as dateOfBirth,
mp.filename_small,
mp.directory,
mk.step AS karma_step,
mg.id as goldmemberId,
mg.gold_aktiv,
mo.shown_in_activities,
mo.profilevisit_visibility,
mo.hide_profile_todos,
mo.privacy_visibility,
mo.online_visibility,
mo.timfotos_visibility,
mo.favfotos_visibility,
mo.buddylist_visibility,
mo.passfoto_visibility,
mo.event_visibility,
mo.event_einladungen,
mo.contact_by,
mo.contact_by_sms,
mo.contact_by_email,
mo.allcomments_visibility,
sc.uid as online
FROM users AS u
LEFT JOIN users_password AS up ON u.uid = up.uid
LEFT JOIN member_passfotos AS mp ON u.uid = mp.uid
LEFT JOIN member_karma AS mk ON u.uid = mk.uid
LEFT JOIN member_gold AS mg ON u.uid = mg.uid
LEFT JOIN member_options AS mo ON u.uid = mo.uid
LEFT JOIN active_session_cache as sc ON (sc.uid=u.uid)
LEFT JOIN adv_jobs aj ON (aj.uid=u.uid)
WHERE `u`.`uid` = '14990478' LIMIT 1
Called from: Trevi_Db_Row->_loadByQuery()
Affected rows: 1 Execution time: 0.000530004501343s Database ID: 'default' Master used: no"
["priority"]=>
int(6)
["priorityName"]=>
string(4) "INFO"
["microtime"]=>
float(1283507907.35)
}
[46]=>
array(5) {
["timestamp"]=>
string(25) "2010-09-03T11:58:27+02:00"
["message"]=>
string(210) "Query statement: SELECT * FROM fbconnect_users WHERE `uid`='14990478' LIMIT 1
Called from: Trevi_Db_Row->_loadByQuery()
Affected rows: 0 Execution time: 0.000231981277466s Database ID: 'default' Master used: no"
["priority"]=>
int(6)
["priorityName"]=>
string(4) "INFO"
["microtime"]=>
float(1283507907.35)
}
[47]=>
array(5) {
["timestamp"]=>
string(25) "2010-09-03T11:58:27+02:00"
["message"]=>
string(293) "Query statement: SELECT directory, filename_small, filename_big, mogilefs_hash_small, mogilefs_hash_big
FROM member_passfotos WHERE uid = '14990478'
Called from: Tilllate_User->getMemberPhotoData()
Affected rows: 1 Execution time: 0.000195026397705s Database ID: 'default' Master used: no"
["priority"]=>
int(6)
["priorityName"]=>
string(4) "INFO"
["microtime"]=>
float(1283507907.35)
}
[48]=>
array(5) {
["timestamp"]=>
string(25) "2010-09-03T11:58:27+02:00"
["message"]=>
string(1952) "Query statement: SELECT
u.uid,
u.username,
up.password_md5 as password,
u.vorletzter_login,
u.letzter_login,
u.email,
u.alterskat,
u.taetigkeit,
u.job,
u.wohnort,
u.will_mailing,
u.will_kontakt,
u.host,
u.status,
u.will_notification,
u.myalbummode,
u.ist_administrator,
u.erster_login,
u.ist_organisator,
u.pr_eintrpreis,
u.pr_getrpreis,
u.pr_ptid,
u.geschlecht,
u.anzahl_logins,
u.will_myevents,
u.vorname,
u.name,
u.funktion_in_firma,
u.strasse,
u.plz,
u.ort,
u.rid,
u.telnr,
u.telnr_carrier,
u.letzter_gewinn,
u.res,
u.mitfoto,
u.msg,
u.validiert,
u.gesperrt,
u.regselect,
u.gebdatum,
u.orgid,
u.users_ts,
u.org_valid,
u.registration_ongoing,
u.country,
u.country_stateid,
u.will_emailwerbung,
u.chat_status,
u.chat_msgwaiting,
u.site_id,
u.language,
u.bookingtoolflag,
u.datenquelle,
u.company,
u.visitedMemberpages,
u.tel_privat,
u.tel_geschaeft,
u.ist_artist,
u.mail_notification,
u.promoterzone_last_orgid,
UNIX_TIMESTAMP(u.gebdatum) as dateOfBirth,
mp.filename_small,
mp.directory,
mk.step AS karma_step,
mg.id as goldmemberId,
mg.gold_aktiv,
mo.shown_in_activities,
mo.profilevisit_visibility,
mo.hide_profile_todos,
mo.privacy_visibility,
mo.online_visibility,
mo.timfotos_visibility,
mo.favfotos_visibility,
mo.buddylist_visibility,
mo.passfoto_visibility,
mo.event_visibility,
mo.event_einladungen,
mo.contact_by,
mo.contact_by_sms,
mo.contact_by_email,
mo.allcomments_visibility,
sc.uid as online
FROM users AS u
LEFT JOIN users_password AS up ON u.uid = up.uid
LEFT JOIN member_passfotos AS mp ON u.uid = mp.uid
LEFT JOIN member_karma AS mk ON u.uid = mk.uid
LEFT JOIN member_gold AS mg ON u.uid = mg.uid
LEFT JOIN member_options AS mo ON u.uid = mo.uid
LEFT JOIN active_session_cache as sc ON (sc.uid=u.uid)
LEFT JOIN adv_jobs aj ON (aj.uid=u.uid)
WHERE `u`.`uid` = '14853472' LIMIT 1
Called from: Trevi_Db_Row->_loadByQuery()
Affected rows: 1 Execution time: 0.000492095947266s Database ID: 'default' Master used: no"
["priority"]=>
int(6)
["priorityName"]=>
string(4) "INFO"
["microtime"]=>
float(1283507907.35)
}
[49]=>
array(5) {
["timestamp"]=>
string(25) "2010-09-03T11:58:27+02:00"
["message"]=>
string(209) "Query statement: SELECT * FROM fbconnect_users WHERE `uid`='14853472' LIMIT 1
Called from: Trevi_Db_Row->_loadByQuery()
Affected rows: 0 Execution time: 0.00101494789124s Database ID: 'default' Master used: no"
["priority"]=>
int(6)
["priorityName"]=>
string(4) "INFO"
["microtime"]=>
float(1283507907.35)
}
[50]=>
array(5) {
["timestamp"]=>
string(25) "2010-09-03T11:58:27+02:00"
["message"]=>
string(293) "Query statement: SELECT directory, filename_small, filename_big, mogilefs_hash_small, mogilefs_hash_big
FROM member_passfotos WHERE uid = '14853472'
Called from: Tilllate_User->getMemberPhotoData()
Affected rows: 1 Execution time: 0.000624895095825s Database ID: 'default' Master used: no"
["priority"]=>
int(6)
["priorityName"]=>
string(4) "INFO"
["microtime"]=>
float(1283507907.35)
}
[51]=>
array(5) {
["timestamp"]=>
string(25) "2010-09-03T11:58:27+02:00"
["message"]=>
string(1951) "Query statement: SELECT
u.uid,
u.username,
up.password_md5 as password,
u.vorletzter_login,
u.letzter_login,
u.email,
u.alterskat,
u.taetigkeit,
u.job,
u.wohnort,
u.will_mailing,
u.will_kontakt,
u.host,
u.status,
u.will_notification,
u.myalbummode,
u.ist_administrator,
u.erster_login,
u.ist_organisator,
u.pr_eintrpreis,
u.pr_getrpreis,
u.pr_ptid,
u.geschlecht,
u.anzahl_logins,
u.will_myevents,
u.vorname,
u.name,
u.funktion_in_firma,
u.strasse,
u.plz,
u.ort,
u.rid,
u.telnr,
u.telnr_carrier,
u.letzter_gewinn,
u.res,
u.mitfoto,
u.msg,
u.validiert,
u.gesperrt,
u.regselect,
u.gebdatum,
u.orgid,
u.users_ts,
u.org_valid,
u.registration_ongoing,
u.country,
u.country_stateid,
u.will_emailwerbung,
u.chat_status,
u.chat_msgwaiting,
u.site_id,
u.language,
u.bookingtoolflag,
u.datenquelle,
u.company,
u.visitedMemberpages,
u.tel_privat,
u.tel_geschaeft,
u.ist_artist,
u.mail_notification,
u.promoterzone_last_orgid,
UNIX_TIMESTAMP(u.gebdatum) as dateOfBirth,
mp.filename_small,
mp.directory,
mk.step AS karma_step,
mg.id as goldmemberId,
mg.gold_aktiv,
mo.shown_in_activities,
mo.profilevisit_visibility,
mo.hide_profile_todos,
mo.privacy_visibility,
mo.online_visibility,
mo.timfotos_visibility,
mo.favfotos_visibility,
mo.buddylist_visibility,
mo.passfoto_visibility,
mo.event_visibility,
mo.event_einladungen,
mo.contact_by,
mo.contact_by_sms,
mo.contact_by_email,
mo.allcomments_visibility,
sc.uid as online
FROM users AS u
LEFT JOIN users_password AS up ON u.uid = up.uid
LEFT JOIN member_passfotos AS mp ON u.uid = mp.uid
LEFT JOIN member_karma AS mk ON u.uid = mk.uid
LEFT JOIN member_gold AS mg ON u.uid = mg.uid
LEFT JOIN member_options AS mo ON u.uid = mo.uid
LEFT JOIN active_session_cache as sc ON (sc.uid=u.uid)
LEFT JOIN adv_jobs aj ON (aj.uid=u.uid)
WHERE `u`.`uid` = '15010776' LIMIT 1
Called from: Trevi_Db_Row->_loadByQuery()
Affected rows: 1 Execution time: 0.00085186958313s Database ID: 'default' Master used: no"
["priority"]=>
int(6)
["priorityName"]=>
string(4) "INFO"
["microtime"]=>
float(1283507907.36)
}
[52]=>
array(5) {
["timestamp"]=>
string(25) "2010-09-03T11:58:27+02:00"
["message"]=>
string(210) "Query statement: SELECT * FROM fbconnect_users WHERE `uid`='15010776' LIMIT 1
Called from: Trevi_Db_Row->_loadByQuery()
Affected rows: 0 Execution time: 0.000550985336304s Database ID: 'default' Master used: no"
["priority"]=>
int(6)
["priorityName"]=>
string(4) "INFO"
["microtime"]=>
float(1283507907.36)
}
[53]=>
array(5) {
["timestamp"]=>
string(25) "2010-09-03T11:58:27+02:00"
["message"]=>
string(293) "Query statement: SELECT directory, filename_small, filename_big, mogilefs_hash_small, mogilefs_hash_big
FROM member_passfotos WHERE uid = '15010776'
Called from: Tilllate_User->getMemberPhotoData()
Affected rows: 1 Execution time: 0.000659942626953s Database ID: 'default' Master used: no"
["priority"]=>
int(6)
["priorityName"]=>
string(4) "INFO"
["microtime"]=>
float(1283507907.36)
}
[54]=>
array(5) {
["timestamp"]=>
string(25) "2010-09-03T11:58:27+02:00"
["message"]=>
string(1952) "Query statement: SELECT
u.uid,
u.username,
up.password_md5 as password,
u.vorletzter_login,
u.letzter_login,
u.email,
u.alterskat,
u.taetigkeit,
u.job,
u.wohnort,
u.will_mailing,
u.will_kontakt,
u.host,
u.status,
u.will_notification,
u.myalbummode,
u.ist_administrator,
u.erster_login,
u.ist_organisator,
u.pr_eintrpreis,
u.pr_getrpreis,
u.pr_ptid,
u.geschlecht,
u.anzahl_logins,
u.will_myevents,
u.vorname,
u.name,
u.funktion_in_firma,
u.strasse,
u.plz,
u.ort,
u.rid,
u.telnr,
u.telnr_carrier,
u.letzter_gewinn,
u.res,
u.mitfoto,
u.msg,
u.validiert,
u.gesperrt,
u.regselect,
u.gebdatum,
u.orgid,
u.users_ts,
u.org_valid,
u.registration_ongoing,
u.country,
u.country_stateid,
u.will_emailwerbung,
u.chat_status,
u.chat_msgwaiting,
u.site_id,
u.language,
u.bookingtoolflag,
u.datenquelle,
u.company,
u.visitedMemberpages,
u.tel_privat,
u.tel_geschaeft,
u.ist_artist,
u.mail_notification,
u.promoterzone_last_orgid,
UNIX_TIMESTAMP(u.gebdatum) as dateOfBirth,
mp.filename_small,
mp.directory,
mk.step AS karma_step,
mg.id as goldmemberId,
mg.gold_aktiv,
mo.shown_in_activities,
mo.profilevisit_visibility,
mo.hide_profile_todos,
mo.privacy_visibility,
mo.online_visibility,
mo.timfotos_visibility,
mo.favfotos_visibility,
mo.buddylist_visibility,
mo.passfoto_visibility,
mo.event_visibility,
mo.event_einladungen,
mo.contact_by,
mo.contact_by_sms,
mo.contact_by_email,
mo.allcomments_visibility,
sc.uid as online
FROM users AS u
LEFT JOIN users_password AS up ON u.uid = up.uid
LEFT JOIN member_passfotos AS mp ON u.uid = mp.uid
LEFT JOIN member_karma AS mk ON u.uid = mk.uid
LEFT JOIN member_gold AS mg ON u.uid = mg.uid
LEFT JOIN member_options AS mo ON u.uid = mo.uid
LEFT JOIN active_session_cache as sc ON (sc.uid=u.uid)
LEFT JOIN adv_jobs aj ON (aj.uid=u.uid)
WHERE `u`.`uid` = '14999036' LIMIT 1
Called from: Trevi_Db_Row->_loadByQuery()
Affected rows: 1 Execution time: 0.000491857528687s Database ID: 'default' Master used: no"
["priority"]=>
int(6)
["priorityName"]=>
string(4) "INFO"
["microtime"]=>
float(1283507907.36)
}
[55]=>
array(5) {
["timestamp"]=>
string(25) "2010-09-03T11:58:27+02:00"
["message"]=>
string(210) "Query statement: SELECT * FROM fbconnect_users WHERE `uid`='14999036' LIMIT 1
Called from: Trevi_Db_Row->_loadByQuery()
Affected rows: 0 Execution time: 0.000219821929932s Database ID: 'default' Master used: no"
["priority"]=>
int(6)
["priorityName"]=>
string(4) "INFO"
["microtime"]=>
float(1283507907.36)
}
[56]=>
array(5) {
["timestamp"]=>
string(25) "2010-09-03T11:58:27+02:00"
["message"]=>
string(293) "Query statement: SELECT directory, filename_small, filename_big, mogilefs_hash_small, mogilefs_hash_big
FROM member_passfotos WHERE uid = '14999036'
Called from: Tilllate_User->getMemberPhotoData()
Affected rows: 1 Execution time: 0.000218152999878s Database ID: 'default' Master used: no"
["priority"]=>
int(6)
["priorityName"]=>
string(4) "INFO"
["microtime"]=>
float(1283507907.36)
}
[57]=>
array(5) {
["timestamp"]=>
string(25) "2010-09-03T11:58:27+02:00"
["message"]=>
string(1952) "Query statement: SELECT
u.uid,
u.username,
up.password_md5 as password,
u.vorletzter_login,
u.letzter_login,
u.email,
u.alterskat,
u.taetigkeit,
u.job,
u.wohnort,
u.will_mailing,
u.will_kontakt,
u.host,
u.status,
u.will_notification,
u.myalbummode,
u.ist_administrator,
u.erster_login,
u.ist_organisator,
u.pr_eintrpreis,
u.pr_getrpreis,
u.pr_ptid,
u.geschlecht,
u.anzahl_logins,
u.will_myevents,
u.vorname,
u.name,
u.funktion_in_firma,
u.strasse,
u.plz,
u.ort,
u.rid,
u.telnr,
u.telnr_carrier,
u.letzter_gewinn,
u.res,
u.mitfoto,
u.msg,
u.validiert,
u.gesperrt,
u.regselect,
u.gebdatum,
u.orgid,
u.users_ts,
u.org_valid,
u.registration_ongoing,
u.country,
u.country_stateid,
u.will_emailwerbung,
u.chat_status,
u.chat_msgwaiting,
u.site_id,
u.language,
u.bookingtoolflag,
u.datenquelle,
u.company,
u.visitedMemberpages,
u.tel_privat,
u.tel_geschaeft,
u.ist_artist,
u.mail_notification,
u.promoterzone_last_orgid,
UNIX_TIMESTAMP(u.gebdatum) as dateOfBirth,
mp.filename_small,
mp.directory,
mk.step AS karma_step,
mg.id as goldmemberId,
mg.gold_aktiv,
mo.shown_in_activities,
mo.profilevisit_visibility,
mo.hide_profile_todos,
mo.privacy_visibility,
mo.online_visibility,
mo.timfotos_visibility,
mo.favfotos_visibility,
mo.buddylist_visibility,
mo.passfoto_visibility,
mo.event_visibility,
mo.event_einladungen,
mo.contact_by,
mo.contact_by_sms,
mo.contact_by_email,
mo.allcomments_visibility,
sc.uid as online
FROM users AS u
LEFT JOIN users_password AS up ON u.uid = up.uid
LEFT JOIN member_passfotos AS mp ON u.uid = mp.uid
LEFT JOIN member_karma AS mk ON u.uid = mk.uid
LEFT JOIN member_gold AS mg ON u.uid = mg.uid
LEFT JOIN member_options AS mo ON u.uid = mo.uid
LEFT JOIN active_session_cache as sc ON (sc.uid=u.uid)
LEFT JOIN adv_jobs aj ON (aj.uid=u.uid)
WHERE `u`.`uid` = '15010774' LIMIT 1
Called from: Trevi_Db_Row->_loadByQuery()
Affected rows: 1 Execution time: 0.000502824783325s Database ID: 'default' Master used: no"
["priority"]=>
int(6)
["priorityName"]=>
string(4) "INFO"
["microtime"]=>
float(1283507907.37)
}
[58]=>
array(5) {
["timestamp"]=>
string(25) "2010-09-03T11:58:27+02:00"
["message"]=>
string(210) "Query statement: SELECT * FROM fbconnect_users WHERE `uid`='15010774' LIMIT 1
Called from: Trevi_Db_Row->_loadByQuery()
Affected rows: 0 Execution time: 0.000202178955078s Database ID: 'default' Master used: no"
["priority"]=>
int(6)
["priorityName"]=>
string(4) "INFO"
["microtime"]=>
float(1283507907.37)
}
[59]=>
array(5) {
["timestamp"]=>
string(25) "2010-09-03T11:58:27+02:00"
["message"]=>
string(293) "Query statement: SELECT directory, filename_small, filename_big, mogilefs_hash_small, mogilefs_hash_big
FROM member_passfotos WHERE uid = '15010774'
Called from: Tilllate_User->getMemberPhotoData()
Affected rows: 0 Execution time: 0.000226974487305s Database ID: 'default' Master used: no"
["priority"]=>
int(6)
["priorityName"]=>
string(4) "INFO"
["microtime"]=>
float(1283507907.37)
}
[60]=>
array(5) {
["timestamp"]=>
string(25) "2010-09-03T11:58:27+02:00"
["message"]=>
string(207) "Query statement: SELECT * FROM fbconnect_users WHERE `uid`='31766' LIMIT 1
Called from: Trevi_Db_Row->_loadByQuery()
Affected rows: 0 Execution time: 0.000756025314331s Database ID: 'default' Master used: no"
["priority"]=>
int(6)
["priorityName"]=>
string(4) "INFO"
["microtime"]=>
float(1283507907.37)
}
[61]=>
array(5) {
["timestamp"]=>
string(25) "2010-09-03T11:58:27+02:00"
["message"]=>
string(290) "Query statement: SELECT directory, filename_small, filename_big, mogilefs_hash_small, mogilefs_hash_big
FROM member_passfotos WHERE uid = '31766'
Called from: Tilllate_User->getMemberPhotoData()
Affected rows: 1 Execution time: 0.000569105148315s Database ID: 'default' Master used: no"
["priority"]=>
int(6)
["priorityName"]=>
string(4) "INFO"
["microtime"]=>
float(1283507907.37)
}
[62]=>
array(5) {
["timestamp"]=>
string(25) "2010-09-03T11:58:27+02:00"
["message"]=>
string(2436) "Query statement: SELECT rid,(CASE WHEN region <> '' THEN region WHEN region_EN <> '' THEN region_EN WHEN region_FR <> '' THEN region_FR WHEN region_IT <> '' THEN region_IT WHEN region_ES <> '' THEN region_ES WHEN region_BG <> '' THEN region_BG WHEN region_TR <> '' THEN region_TR WHEN region_NL <> '' THEN region_NL WHEN region_RO <> '' THEN region_RO ELSE '' END) as region,after_timespan,after_count,after_prio,pre_timespan,
pre_count,pre_prio,aktiv,mapdata,special_timespan,special_count,mapdata_new,is_smallregion,
show_todays_events,regionhome_html,r.country_id,default_language,
(CASE WHEN artikel <> '' THEN artikel WHEN artikel_EN <> '' THEN artikel_EN WHEN artikel_FR <> '' THEN artikel_FR WHEN artikel_IT <> '' THEN artikel_IT WHEN artikel_ES <> '' THEN artikel_ES WHEN artikel_BG <> '' THEN artikel_BG WHEN artikel_TR <> '' THEN artikel_TR WHEN artikel_NL <> '' THEN artikel_NL WHEN artikel_RO <> '' THEN artikel_RO ELSE '' END) as artikel,regionen_kombination_id,region_header_image,cid,
(CASE WHEN name <> '' THEN name WHEN name_EN <> '' THEN name_EN WHEN name_FR <> '' THEN name_FR WHEN name_IT <> '' THEN name_IT WHEN name_ES <> '' THEN name_ES WHEN name_BG <> '' THEN name_BG WHEN name_TR <> '' THEN name_TR WHEN name_NL <> '' THEN name_NL WHEN name_RO <> '' THEN name_RO ELSE '' END) as name,pos,ts,(CASE WHEN state_dropdown_label <> '' THEN state_dropdown_label WHEN state_dropdown_label_EN <> '' THEN state_dropdown_label_EN WHEN state_dropdown_label_FR <> '' THEN state_dropdown_label_FR WHEN state_dropdown_label_IT <> '' THEN state_dropdown_label_IT WHEN state_dropdown_label_ES <> '' THEN state_dropdown_label_ES WHEN state_dropdown_label_BG <> '' THEN state_dropdown_label_BG WHEN state_dropdown_label_TR <> '' THEN state_dropdown_label_TR WHEN state_dropdown_label_NL <> '' THEN state_dropdown_label_NL WHEN state_dropdown_label_RO <> '' THEN state_dropdown_label_RO ELSE '' END) as state_dropdown_label,currency,isocode,phone_countrycode,
fully_covered_by_regions,country_site_id, cs.state_code
FROM regionen r
INNER JOIN countries c ON (r.country_id=c.cid)
LEFT JOIN countries_states cs ON cs.stateid=''
WHERE r.rid='1'
Called from: Tilllate_User->getRegions()
Affected rows: 1 Execution time: 0.000764131546021s Database ID: 'default' Master used: no"
["priority"]=>
int(6)
["priorityName"]=>
string(4) "INFO"
["microtime"]=>
float(1283507907.38)
}
}
["_scriptStartTime:private"]=>
float(1283507907.12)
["_filters:protected"]=>
array(0) {
}
["_formatter:protected"]=>
NULL
}
.jpg)
