[ Generation time: 0.7231 s ] [ 60 queries used ] [ GZIP compression disabled ] [ Server Load: 0.00 ]
Queries Used
SELECT settings FROM ec3_hw_settings
SELECT * FROM ec3_modules WHERE state="A" OR state="I" ORDER BY name
SELECT data FROM ec3_session WHERE session_id="38.103.63.56" AND expires>1227207603
SELECT id,name FROM ec3_multi_lang_language WHERE enabled="1" ORDER BY name
SELECT * FROM ec3_multi_lang_language WHERE id="en"
SELECT count(*) FROM ec3_field WHERE fset="vacationes"
SELECT ID,DB_F,TITLE,ERR_MSG,TYPE,INPUT,CHARS,SIZE,MIN,MAX,VALUE,REQUIRED,EDITABLE,SEARCH,SEARCH_K,ACTIVE,EXTRA,TXT FROM ec3_field WHERE fset="vacationes" ORDER BY weight
SELECT id, template_suffix, userid, category_id, region_id, postallowed FROM ec3_subdomains WHERE subdomain_name="beta.swisspanama.com"
SELECT name AS country_name, descr FROM ec3_regions_category WHERE id="492"
SELECT id FROM ec3_regions_category WHERE pid IN("492")
SELECT id FROM ec3_regions_category WHERE pid IN("493","494","495","496","497","498","499","500")
SELECT id FROM ec3_regions_category WHERE pid IN("501","502","503","504","505","506","507","508","509","510","511","512","513","514","515","596","1505","1506","1507","1508","1601","562","563","564","565","566","567","568","569","570","571","572","573","574","575","576","577","578","579","580","516","517","518","519","520","521","522","523","1646","535","536","537","538","539","540","541","542","543","544","524","525","526","527","528","529","530","531","532","533","534","592","594","595","1497","1509","1510","1647","1648","1649","1650","1651","1652","1653","1654","551","552","553","554","555","556","557","558","559","560","561","593","1096","1700","1701","1702","1703","1704","545","546","547","548","549","550","1655","1656","1657","1658")
SELECT id FROM ec3_regions_category WHERE pid IN("1091","1092","1093","1094","1095","581","582","583","584","585","586","587","588","589","590","591","1600","1087","1088","1089","1090","1097","1098","1099","1100","1101","1102","1103")
SELECT count(*) FROM ec3_category
SELECT id,pid,name,browsetxtbox,image,descr FROM ec3_category WHERE 1=1 ORDER BY weight DESC,name
LOCK TABLE ec3_ad WRITE
SELECT COUNT(*) FROM ec3_ad WHERE 1=1 AND approved="1" AND user_approved="1" AND exp_date>=NOW() AND hw_region_id IN("492","493","494","495","496","497","498","499","500","501","502","503","504","505","506","507","508","509","510","511","512","513","514","515","596","1505","1506","1507","1508","1601","562","563","564","565","566","567","568","569","570","571","572","573","574","575","576","577","578","579","580","516","517","518","519","520","521","522","523","1646","535","536","537","538","539","540","541","542","543","544","524","525","526","527","528","529","530","531","532","533","534","592","594","595","1497","1509","1510","1647","1648","1649","1650","1651","1652","1653","1654","551","552","553","554","555","556","557","558","559","560","561","593","1096","1700","1701","1702","1703","1704","545","546","547","548","549","550","1655","1656","1657","1658","1091","1092","1093","1094","1095","581","582","583","584","585","586","587","588","589","590","591","1600","1087","1088","1089","1090","1097","1098","1099","1100","1101","1102","1103")
UNLOCK TABLES
SELECT DISTINCT(db_f) FROM ec3_field WHERE fset NOT LIKE "{%"
SELECT link_id,images,catid,hw_auct_bid,hw_auct_bid_inc,hw_auct_bid_init,v_255_1,v_255_2,v_255_3,v_255_4,v_255_5,v_255_6,v_255_7,v_255_8,v_descr,v_title,d_price,hw_sold,text_1,v_255_10,v_255_11,v_255_12,v_255_13,v_255_14,v_255_15,v_255_16,v_255_17,v_255_18,v_255_19,v_255_20,v_255_21,v_255_22,v_255_23,v_255_24,v_255_25,v_255_26,v_255_27,v_255_28,v_255_29,v_255_30,v_255_31,v_255_32,v_255_33,v_255_34,v_255_35,v_255_36,v_255_37,v_255_38,v_255_39,v_255_40,v_255_41,v_255_42,v_255_43,v_255_9,v_price,v_zip,text_2,v_rent,text_3,text_4,text_5,v_255_44,v_255_45,v_255_46,v_255_47,v_255_48,v_255_49,v_255_50,v_255_51,v_255_52,v_255_53,v_255_54,v_255_55,v_255_56,dec_1,hw_av_enabled,UNIX_TIMESTAMP(hw_updated) AS ad_date FROM ec3_ad USE INDEX (PRIMARY) WHERE 1=1 AND approved="1" AND user_approved="1" AND exp_date>=NOW() AND hw_region_id IN("492","493","494","495","496","497","498","499","500","501","502","503","504","505","506","507","508","509","510","511","512","513","514","515","596","1505","1506","1507","1508","1601","562","563","564","565","566","567","568","569","570","571","572","573","574","575","576","577","578","579","580","516","517","518","519","520","521","522","523","1646","535","536","537","538","539","540","541","542","543","544","524","525","526","527","528","529","530","531","532","533","534","592","594","595","1497","1509","1510","1647","1648","1649","1650","1651","1652","1653","1654","551","552","553","554","555","556","557","558","559","560","561","593","1096","1700","1701","1702","1703","1704","545","546","547","548","549","550","1655","1656","1657","1658","1091","1092","1093","1094","1095","581","582","583","584","585","586","587","588","589","590","591","1600","1087","1088","1089","1090","1097","1098","1099","1100","1101","1102","1103") ORDER by link_id DESC LIMIT 0,10
SELECT id,username FROM ec3_user WHERE id IN("")
SELECT count(*) FROM ec3_field WHERE fset="property"
SELECT ID,DB_F,TITLE,ERR_MSG,TYPE,INPUT,CHARS,SIZE,MIN,MAX,VALUE,REQUIRED,EDITABLE,SEARCH,SEARCH_K,ACTIVE,EXTRA,TXT FROM ec3_field WHERE fset="property" ORDER BY weight
SELECT count(*) FROM ec3_field WHERE fset="projects"
SELECT ID,DB_F,TITLE,ERR_MSG,TYPE,INPUT,CHARS,SIZE,MIN,MAX,VALUE,REQUIRED,EDITABLE,SEARCH,SEARCH_K,ACTIVE,EXTRA,TXT FROM ec3_field WHERE fset="projects" ORDER BY weight
SELECT count(*) FROM ec3_field WHERE fset="general"
SELECT ID,DB_F,TITLE,ERR_MSG,TYPE,INPUT,CHARS,SIZE,MIN,MAX,VALUE,REQUIRED,EDITABLE,SEARCH,SEARCH_K,ACTIVE,EXTRA,TXT FROM ec3_field WHERE fset="general" ORDER BY weight
SELECT count(*) FROM ec3_field WHERE fset="vacationes"
SELECT ID,DB_F,TITLE,ERR_MSG,TYPE,INPUT,CHARS,SIZE,MIN,MAX,VALUE,REQUIRED,EDITABLE,SEARCH,SEARCH_K,ACTIVE,EXTRA,TXT FROM ec3_field WHERE fset="vacationes" ORDER BY weight
SELECT id FROM ec3_category WHERE pid IN("440")
SELECT id FROM ec3_category WHERE pid IN("441","442","443","464","504","527","573")
SELECT id FROM ec3_category WHERE pid IN("452","451","444","445","446","447","448","449","450","520","521","525","454","455","456","453","457","458","459","460","461","462","463","529","530")
SELECT id FROM ec3_category WHERE pid IN("531","532","533","534","535","536","537","538","539","540","541","542")
SELECT id FROM ec3_category WHERE pid IN("498")
SELECT id FROM ec3_category WHERE pid IN("499","503","500","501","502","563","581","584")
SELECT id FROM ec3_category WHERE pid IN("564","565","566","567","568","569","570","571","572")
SELECT link_id FROM ec3_ad WHERE hw_feat="1" AND catid IN ("440","441","442","443","464","504","527","573","452","451","444","445","446","447","448","449","450","520","521","525","454","455","456","453","457","458","459","460","461","462","463","529","530","531","532","533","534","535","536","537","538","539","540","541","542","498","499","503","500","501","502","563","581","584","564","565","566","567","568","569","570","571","572")
SELECT link_id,images,catid,hw_auct_bid,hw_auct_bid_inc,hw_auct_bid_init,v_255_1,v_255_2,v_255_3,v_255_4,v_255_5,v_255_6,v_255_7,v_255_8,v_descr,v_title,d_price,hw_sold,text_1,v_255_10,v_255_11,v_255_12,v_255_13,v_255_14,v_255_15,v_255_16,v_255_17,v_255_18,v_255_19,v_255_20,v_255_21,v_255_22,v_255_23,v_255_24,v_255_25,v_255_26,v_255_27,v_255_28,v_255_29,v_255_30,v_255_31,v_255_32,v_255_33,v_255_34,v_255_35,v_255_36,v_255_37,v_255_38,v_255_39,v_255_40,v_255_41,v_255_42,v_255_43,v_255_9,v_price,v_zip,text_2,v_rent,text_3,text_4,text_5,v_255_44,v_255_45,v_255_46,v_255_47,v_255_48,v_255_49,v_255_50,v_255_51,v_255_52,v_255_53,v_255_54,v_255_55,v_255_56,dec_1,hw_av_enabled FROM ec3_ad WHERE link_id IN (116375,116361,117338,118144) AND approved="1" AND user_approved="1" AND exp_date>=NOW() AND hw_region_id IN("492","493","494","495","496","497","498","499","500","501","502","503","504","505","506","507","508","509","510","511","512","513","514","515","596","1505","1506","1507","1508","1601","562","563","564","565","566","567","568","569","570","571","572","573","574","575","576","577","578","579","580","516","517","518","519","520","521","522","523","1646","535","536","537","538","539","540","541","542","543","544","524","525","526","527","528","529","530","531","532","533","534","592","594","595","1497","1509","1510","1647","1648","1649","1650","1651","1652","1653","1654","551","552","553","554","555","556","557","558","559","560","561","593","1096","1700","1701","1702","1703","1704","545","546","547","548","549","550","1655","1656","1657","1658","1091","1092","1093","1094","1095","581","582","583","584","585","586","587","588","589","590","591","1600","1087","1088","1089","1090","1097","1098","1099","1100","1101","1102","1103") ORDER BY RAND() LIMIT 0,8
SELECT latitude, longitude, zoom FROM ec3_regions_category WHERE id=492
SELECT id,html_code,banner_url,link_url FROM ec3_banner_ads_banner WHERE active="1" AND date_start<=NOW() AND date_end>=NOW() AND (max_clicks=0 OR clicks<max_clicks) AND (max_imp=0 OR impressions<max_imp) AND cid='-1' AND (rid LIKE '%,492,%' OR rid='') AND zone='middleen'
SELECT id,html_code,banner_url,link_url FROM ec3_banner_ads_banner WHERE active="1" AND date_start<=NOW() AND date_end>=NOW() AND (max_clicks=0 OR clicks<max_clicks) AND (max_imp=0 OR impressions<max_imp) AND cid='-1' AND (rid LIKE '%,492,%' OR rid='') AND zone='middle1'
SELECT id,html_code,banner_url,link_url FROM ec3_banner_ads_banner WHERE active="1" AND date_start<=NOW() AND date_end>=NOW() AND (max_clicks=0 OR clicks<max_clicks) AND (max_imp=0 OR impressions<max_imp) AND cid='-1' AND (rid LIKE '%,492,%' OR rid='') AND zone='middlefrontleft'
SELECT id,html_code,banner_url,link_url FROM ec3_banner_ads_banner WHERE active="1" AND date_start<=NOW() AND date_end>=NOW() AND (max_clicks=0 OR clicks<max_clicks) AND (max_imp=0 OR impressions<max_imp) AND cid='-1' AND (rid LIKE '%,492,%' OR rid='') AND zone='middlefrontright'
SELECT id,html_code,banner_url,link_url FROM ec3_banner_ads_banner WHERE active="1" AND date_start<=NOW() AND date_end>=NOW() AND (max_clicks=0 OR clicks<max_clicks) AND (max_imp=0 OR impressions<max_imp) AND cid='-1' AND (rid LIKE '%,492,%' OR rid='') AND zone='left1top'
SELECT id,html_code,banner_url,link_url FROM ec3_banner_ads_banner WHERE active="1" AND date_start<=NOW() AND date_end>=NOW() AND (max_clicks=0 OR clicks<max_clicks) AND (max_imp=0 OR impressions<max_imp) AND cid='-1' AND (rid LIKE '%,492,%' OR rid='') AND zone='left2bs'
SELECT id,html_code,banner_url,link_url FROM ec3_banner_ads_banner WHERE active="1" AND date_start<=NOW() AND date_end>=NOW() AND (max_clicks=0 OR clicks<max_clicks) AND (max_imp=0 OR impressions<max_imp) AND cid='-1' AND (rid LIKE '%,492,%' OR rid='') AND zone='left3ss'
SELECT id,html_code,banner_url,link_url FROM ec3_banner_ads_banner WHERE active="1" AND date_start<=NOW() AND date_end>=NOW() AND (max_clicks=0 OR clicks<max_clicks) AND (max_imp=0 OR impressions<max_imp) AND cid='-1' AND (rid LIKE '%,492,%' OR rid='') AND zone='left4so'
SELECT id,html_code,banner_url,link_url FROM ec3_banner_ads_banner WHERE active="1" AND date_start<=NOW() AND date_end>=NOW() AND (max_clicks=0 OR clicks<max_clicks) AND (max_imp=0 OR impressions<max_imp) AND cid='-1' AND (rid LIKE '%,492,%' OR rid='') AND zone='left5os'
SELECT id,html_code,banner_url,link_url FROM ec3_banner_ads_banner WHERE active="1" AND date_start<=NOW() AND date_end>=NOW() AND (max_clicks=0 OR clicks<max_clicks) AND (max_imp=0 OR impressions<max_imp) AND cid='-1' AND (rid LIKE '%,492,%' OR rid='') AND zone='left6sm'
SELECT id,html_code,banner_url,link_url FROM ec3_banner_ads_banner WHERE active="1" AND date_start<=NOW() AND date_end>=NOW() AND (max_clicks=0 OR clicks<max_clicks) AND (max_imp=0 OR impressions<max_imp) AND cid='-1' AND (rid LIKE '%,492,%' OR rid='') AND zone='leftbot'
SELECT id,html_code,banner_url,link_url FROM ec3_banner_ads_banner WHERE active="1" AND date_start<=NOW() AND date_end>=NOW() AND (max_clicks=0 OR clicks<max_clicks) AND (max_imp=0 OR impressions<max_imp) AND cid='-1' AND (rid LIKE '%,492,%' OR rid='') AND zone='right1top'
SELECT id,html_code,banner_url,link_url FROM ec3_banner_ads_banner WHERE active="1" AND date_start<=NOW() AND date_end>=NOW() AND (max_clicks=0 OR clicks<max_clicks) AND (max_imp=0 OR impressions<max_imp) AND cid='-1' AND (rid LIKE '%,492,%' OR rid='') AND zone='right2'
SELECT id,html_code,banner_url,link_url FROM ec3_banner_ads_banner WHERE active="1" AND date_start<=NOW() AND date_end>=NOW() AND (max_clicks=0 OR clicks<max_clicks) AND (max_imp=0 OR impressions<max_imp) AND cid='-1' AND (rid LIKE '%,492,%' OR rid='') AND zone='rightbot'
SELECT id,html_code,banner_url,link_url FROM ec3_banner_ads_banner WHERE active="1" AND date_start<=NOW() AND date_end>=NOW() AND (max_clicks=0 OR clicks<max_clicks) AND (max_imp=0 OR impressions<max_imp) AND cid='-1' AND (rid LIKE '%,492,%' OR rid='') AND zone='topsmall'
SELECT id,html_code,banner_url,link_url FROM ec3_banner_ads_banner WHERE active="1" AND date_start<=NOW() AND date_end>=NOW() AND (max_clicks=0 OR clicks<max_clicks) AND (max_imp=0 OR impressions<max_imp) AND cid='-1' AND (rid LIKE '%,492,%' OR rid='') AND zone='1-top728'
SELECT id,html_code,banner_url,link_url FROM ec3_banner_ads_banner WHERE active="1" AND date_start<=NOW() AND date_end>=NOW() AND (max_clicks=0 OR clicks<max_clicks) AND (max_imp=0 OR impressions<max_imp) AND cid='-1' AND (rid LIKE '%,492,%' OR rid='') AND zone='consortemedia728'
SELECT link_id FROM ec3_ad WHERE hw_feat="1" AND catid IN ("440","441","442","443","464","504","527","573","452","451","444","445","446","447","448","449","450","520","521","525","454","455","456","453","457","458","459","460","461","462","463","529","530","531","532","533","534","535","536","537","538","539","540","541","542","498","499","503","500","501","502","563","581","584","564","565","566","567","568","569","570","571","572")
SELECT link_id,images,catid,hw_auct_bid,hw_auct_bid_inc,hw_auct_bid_init,v_255_1,v_255_2,v_255_3,v_255_4,v_255_5,v_255_6,v_255_7,v_255_8,v_descr,v_title,d_price,hw_sold,text_1,v_255_10,v_255_11,v_255_12,v_255_13,v_255_14,v_255_15,v_255_16,v_255_17,v_255_18,v_255_19,v_255_20,v_255_21,v_255_22,v_255_23,v_255_24,v_255_25,v_255_26,v_255_27,v_255_28,v_255_29,v_255_30,v_255_31,v_255_32,v_255_33,v_255_34,v_255_35,v_255_36,v_255_37,v_255_38,v_255_39,v_255_40,v_255_41,v_255_42,v_255_43,v_255_9,v_price,v_zip,text_2,v_rent,text_3,text_4,text_5,v_255_44,v_255_45,v_255_46,v_255_47,v_255_48,v_255_49,v_255_50,v_255_51,v_255_52,v_255_53,v_255_54,v_255_55,v_255_56,dec_1,hw_av_enabled FROM ec3_ad WHERE link_id IN (116375,116361,117338,118144) AND approved="1" AND user_approved="1" AND exp_date>=NOW() AND hw_region_id IN("492","493","494","495","496","497","498","499","500","501","502","503","504","505","506","507","508","509","510","511","512","513","514","515","596","1505","1506","1507","1508","1601","562","563","564","565","566","567","568","569","570","571","572","573","574","575","576","577","578","579","580","516","517","518","519","520","521","522","523","1646","535","536","537","538","539","540","541","542","543","544","524","525","526","527","528","529","530","531","532","533","534","592","594","595","1497","1509","1510","1647","1648","1649","1650","1651","1652","1653","1654","551","552","553","554","555","556","557","558","559","560","561","593","1096","1700","1701","1702","1703","1704","545","546","547","548","549","550","1655","1656","1657","1658","1091","1092","1093","1094","1095","581","582","583","584","585","586","587","588","589","590","591","1600","1087","1088","1089","1090","1097","1098","1099","1100","1101","1102","1103") ORDER BY RAND() LIMIT 0,1
SELECT COUNT(*) FROM ec3_user_online WHERE
(UNIX_TIMESTAMP()-UNIX_TIMESTAMP(accessdate))<300
SELECT COUNT(*) FROM ec3_session WHERE expires>1227208743
