[ Generation time: 0.2831 s ] [ 57 queries used ] [ GZIP compression enabled ]
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.59" AND expires>1219944045
SELECT id,name FROM ec3_multi_lang_language WHERE enabled="1" ORDER BY name
SELECT * FROM ec3_multi_lang_language WHERE id="es"
SELECT id FROM ec3_category LIMIT 0,1
SELECT count(*) FROM ec3_field WHERE fset="general"
SELECT id,phrase FROM ec3_multi_lang_data WHERE lang_id="es"
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 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_multi_lang_region WHERE id="1859" AND lang_id="es"
SELECT id FROM ec3_regions_category WHERE pid IN("1859")
SELECT id FROM ec3_regions_category WHERE pid IN("1860","1861")
SELECT name FROM ec3_regions_category WHERE id="1859"
SELECT id,name,descr FROM ec3_multi_lang_category WHERE lang_id="es"
SELECT id,pid,name,browsetxtbox,image,descr FROM ec3_category WHERE 1=1 ORDER BY weight DESC,name
SELECT id, browsetxtbox FROM ec3_multi_lang_category WHERE id IN(440,453,15,7,455,459,17,462,388,461,458,508,443,526,442,13,454,500,573,498,456,584,499,8,457,504,501,441,503,411,556,510,410,464,522,168,532,444,537,520,229,507,560,502,450,538,536,230,291,514,516,171,170,463,449,529,169,290,552,447,534,539,525,549,452,172,289,572,173,566,506,293,292,232,414,540,451,233,162,165,182,243,295,163,175,294,531,445,521,541,563,570,574,575,527,576,164,557,558,546,460,535,357,408,235,561,237,585,158,533,553,156,548,577,569,578,505,568,448,542,550,554,543,571,559,517,518,238,177,160,240,519,530,581,562,565,446,523,509,511,524,555,512,166,244,296,183,567,545,564,178,179,180,551,184,245,297,547,159,544,241,157,513,515) AND lang_id="es"
SELECT count(*) FROM ec3_category
SELECT catid,COUNT(*) FROM ec3_ad WHERE 1=1 AND approved="1" AND user_approved="1" AND exp_date>=NOW() AND hw_region_id IN("1859","1860","1861") GROUP BY catid
SELECT COUNT(*) FROM ec3_ad WHERE 1=1 AND approved="1" AND user_approved="1" AND exp_date>=NOW() AND hw_region_id IN("1859","1860","1861")
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 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 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("1859","1860","1861") ORDER BY RAND() LIMIT 0,12
SELECT latitude, longitude, zoom FROM ec3_regions_category WHERE id=1859
SELECT dir,UNIX_TIMESTAMP(updated) FROM ec3_modules WHERE block_capable="1" AND state="A"
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 '%,1859,%' OR rid='') AND zone='middle'
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 '%,1859,%' 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 '%,1859,%' 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 '%,1859,%' 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 '%,1859,%' OR rid='') AND zone='left1top'
UPDATE ec3_banner_ads_banner SET impressions=impressions+1 WHERE id=124
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 '%,1859,%' 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 '%,1859,%' 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 '%,1859,%' 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 '%,1859,%' 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 '%,1859,%' OR rid='') AND zone='right1top'
UPDATE ec3_banner_ads_banner SET impressions=impressions+1 WHERE id=122
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 '%,1859,%' 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 '%,1859,%' 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 '%,1859,%' OR rid='') AND zone='rightbotes'
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 '%,1859,%' OR rid='') AND zone='topsmalles'
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 '%,1859,%' OR rid='') AND zone='1es-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 '%,1859,%' OR rid='') AND zone='consortemedia728'
SELECT id, name FROM ec3_category WHERE 1=1 AND pid=0 order by weight DESC,name
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("1859","1860","1861") ORDER BY RAND() LIMIT 0,1
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 1=1 AND approved="1" AND user_approved="1" AND exp_date>=NOW() AND hw_region_id IN("1859","1860","1861") ORDER BY hits DESC LIMIT 0,10
SELECT c.id, IF(l.name, l.name, c.name) AS name, c.latitude, c.longitude, c.zoom FROM ec3_regions_category c LEFT JOIN ec3_multi_lang_region l ON (c.id=l.id) WHERE c.pid=1859 AND c.latitude<>0 AND c.longitude<>0 AND c.zoom<>0
SELECT COUNT(*) FROM ec3_user_online WHERE
(UNIX_TIMESTAMP()-UNIX_TIMESTAMP(accessdate))<300
SELECT COUNT(*) FROM ec3_session WHERE expires>1219945185
