[ Generation time: 0.5432 s ] [ 46 queries used ] [ GZIP compression disabled ] [ Server Load: 0.01 ]
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>1227205766
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="lot"
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="lot" ORDER BY weight
SELECT id, template_suffix, userid, category_id, region_id, postallowed FROM ec3_subdomains WHERE subdomain_name="beta.swisspanama.com"
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="{user_fields}" ORDER BY weight
SELECT id FROM ec3_category WHERE pid IN("459")
SELECT COUNT(DISTINCT(fset)) FROM ec3_category WHERE id IN("459")
SELECT name AS country_name, descr FROM ec3_regions_category WHERE id="316"
SELECT id FROM ec3_regions_category WHERE pid IN("316")
SELECT id FROM ec3_regions_category WHERE pid IN("327","326","325","324","323","322","317","320","321","328")
SELECT id FROM ec3_regions_category WHERE pid IN("339","338","374","335","334","376","434","377","452","454","460","479","1115","1153","1156","1297","1501","383","384","385","387","388","389","390","444","1157","1855","378","379","380","381","382","437","438","439","450","1242","1243","1244","1245","1246","1247","1255","1256","1257","1258","395","396","398","465","472","474","1217","1218","1219","391","392","393","394","1158","1159","1160","476","1659","403","404","1259","1260","399","400","401","402","451","1261","1262","1263","445","405","406","407","408","409","1264","1265","410","411","412","448","449","599","600","1266","1267","1268","1269","1270","1271")
SELECT id FROM ec3_regions_category WHERE pid IN("340","341","342","343","344","345","346","347","348","349","350","426","352","353","354","355","356","358","359","360","361","362","363","364","365","367","368","369","432","371","1425","413","415","416","417","418","419","420","421","422","423","424","425","427","428","429","430","431","433","435","436","440","441","442","443","446","447","453","455","456","457","458","459","461","463","464","466","467","468","469","470","471","1413","478","482","483","484","750","751","752","753","754","755","768","1104","1105","1106","1107","1108","1109","1110","1111","1112","1113","1114","1116","1117","1118","1119","1120","1121","1122","1123","1124","1125","1126","1127","1128","1129","1130","1131","1132","1133","1134","1135","1136","1137","1138","1139","1140","1141","1142","1143","1144","1145","1146","1147","1148","1149","1150","1151","1152","1154","1155","1161","1162","1163","1164","1165","1166","1167","1168","1169","1170","1171","1172","1173","1174","1175","1176","1177","1178","1179","1180","1181","1182","1183","1184","1185","1186","1187","1188","1189","1190","1191","1192","1193","1194","1195","1196","1197","1198","1199","1200","1201","1202","1203","1204","1205","1206","1207","1208","1209","1210","1211","1212","1213","1214","1215","1216","1220","1412","1222","1223","1224","1225","1226","1227","1228","1229","1230","1231","1232","1233","1234","1235","1236","1237","1238","1239","1240","1241","1249","1250","1251","1252","1253","1254","1272","1273","1274","1275","1276","1277","1278","1279","1280","1281","1282","1283","1284","1285","1286","1287","1288","1289","1290","1291","1292","1293","1294","1295","1296","1298","1299","1300","1301","1302","1303","1304","1305","1306","1307","1308","1309","1310","1311","1312","1313","1314","1315","1316","1317","1318","1319","1320","1321","1322","1323","1324","1325","1326","1327","1328","1329","1330","1331","1332","1333","1334","1335","1336","1337","1338","1349","1350","1351","1352","1353","1354","1355","1356","1357","1358","1359","1360","1404","1405","1406","1407","1408","1409","1410","1411","1415","1420","1429","1430","1431","1432","1433","1434","1435","1436","1437","1438","1439","1440","1441","1442","1443","1444","1445","1446","1447","1448","1449","1450","1451","1452","1453","1454","1455","1456","1457","1458","1459","1460","1461","1462","1463","1464","1465","1466","1467","1468","1469","1470","1471","1472","1473","1474","1475","1476","1477","1478","1479","1480","1481","1482","1483","1484","1485","1486","1487","1488","1489","1490","1491","1492","1493","1494","1495","1496","1498","1499","1500","1511","1512","1513","1514","1515","1517","1599","1711","1712","1856","1857","1858")
SELECT id FROM ec3_category WHERE id IN("459") AND fset="lot"
LOCK TABLE ec3_ad AS l WRITE
SELECT COUNT(*) FROM ec3_ad l WHERE 1 AND (1=1) AND l.approved="1" AND l.user_approved="1" AND l.exp_date>=NOW() AND hw_region_id IN("316","327","326","325","324","323","322","317","320","321","328","339","338","374","335","334","376","434","377","452","454","460","479","1115","1153","1156","1297","1501","383","384","385","387","388","389","390","444","1157","1855","378","379","380","381","382","437","438","439","450","1242","1243","1244","1245","1246","1247","1255","1256","1257","1258","395","396","398","465","472","474","1217","1218","1219","391","392","393","394","1158","1159","1160","476","1659","403","404","1259","1260","399","400","401","402","451","1261","1262","1263","445","405","406","407","408","409","1264","1265","410","411","412","448","449","599","600","1266","1267","1268","1269","1270","1271","340","341","342","343","344","345","346","347","348","349","350","426","352","353","354","355","356","358","359","360","361","362","363","364","365","367","368","369","432","371","1425","413","415","416","417","418","419","420","421","422","423","424","425","427","428","429","430","431","433","435","436","440","441","442","443","446","447","453","455","456","457","458","459","461","463","464","466","467","468","469","470","471","1413","478","482","483","484","750","751","752","753","754","755","768","1104","1105","1106","1107","1108","1109","1110","1111","1112","1113","1114","1116","1117","1118","1119","1120","1121","1122","1123","1124","1125","1126","1127","1128","1129","1130","1131","1132","1133","1134","1135","1136","1137","1138","1139","1140","1141","1142","1143","1144","1145","1146","1147","1148","1149","1150","1151","1152","1154","1155","1161","1162","1163","1164","1165","1166","1167","1168","1169","1170","1171","1172","1173","1174","1175","1176","1177","1178","1179","1180","1181","1182","1183","1184","1185","1186","1187","1188","1189","1190","1191","1192","1193","1194","1195","1196","1197","1198","1199","1200","1201","1202","1203","1204","1205","1206","1207","1208","1209","1210","1211","1212","1213","1214","1215","1216","1220","1412","1222","1223","1224","1225","1226","1227","1228","1229","1230","1231","1232","1233","1234","1235","1236","1237","1238","1239","1240","1241","1249","1250","1251","1252","1253","1254","1272","1273","1274","1275","1276","1277","1278","1279","1280","1281","1282","1283","1284","1285","1286","1287","1288","1289","1290","1291","1292","1293","1294","1295","1296","1298","1299","1300","1301","1302","1303","1304","1305","1306","1307","1308","1309","1310","1311","1312","1313","1314","1315","1316","1317","1318","1319","1320","1321","1322","1323","1324","1325","1326","1327","1328","1329","1330","1331","1332","1333","1334","1335","1336","1337","1338","1349","1350","1351","1352","1353","1354","1355","1356","1357","1358","1359","1360","1404","1405","1406","1407","1408","1409","1410","1411","1415","1420","1429","1430","1431","1432","1433","1434","1435","1436","1437","1438","1439","1440","1441","1442","1443","1444","1445","1446","1447","1448","1449","1450","1451","1452","1453","1454","1455","1456","1457","1458","1459","1460","1461","1462","1463","1464","1465","1466","1467","1468","1469","1470","1471","1472","1473","1474","1475","1476","1477","1478","1479","1480","1481","1482","1483","1484","1485","1486","1487","1488","1489","1490","1491","1492","1493","1494","1495","1496","1498","1499","1500","1511","1512","1513","1514","1515","1517","1599","1711","1712","1856","1857","1858") AND l.catid IN("459")
UNLOCK TABLES
SELECT latitude, longitude, zoom FROM ec3_regions_category WHERE id=316
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 LIKE '%,459,%' OR cid='') AND (rid LIKE '%,316,%' 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 LIKE '%,459,%' OR cid='') AND (rid LIKE '%,316,%' 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 LIKE '%,459,%' OR cid='') AND (rid LIKE '%,316,%' 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 LIKE '%,459,%' OR cid='') AND (rid LIKE '%,316,%' 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 LIKE '%,459,%' OR cid='') AND (rid LIKE '%,316,%' 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 LIKE '%,459,%' OR cid='') AND (rid LIKE '%,316,%' 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 LIKE '%,459,%' OR cid='') AND (rid LIKE '%,316,%' 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 LIKE '%,459,%' OR cid='') AND (rid LIKE '%,316,%' 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 LIKE '%,459,%' OR cid='') AND (rid LIKE '%,316,%' 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 LIKE '%,459,%' OR cid='') AND (rid LIKE '%,316,%' 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 LIKE '%,459,%' OR cid='') AND (rid LIKE '%,316,%' 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 LIKE '%,459,%' OR cid='') AND (rid LIKE '%,316,%' 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 LIKE '%,459,%' OR cid='') AND (rid LIKE '%,316,%' OR rid='') AND zone='consortemedia728'
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("316","327","326","325","324","323","322","317","320","321","328","339","338","374","335","334","376","434","377","452","454","460","479","1115","1153","1156","1297","1501","383","384","385","387","388","389","390","444","1157","1855","378","379","380","381","382","437","438","439","450","1242","1243","1244","1245","1246","1247","1255","1256","1257","1258","395","396","398","465","472","474","1217","1218","1219","391","392","393","394","1158","1159","1160","476","1659","403","404","1259","1260","399","400","401","402","451","1261","1262","1263","445","405","406","407","408","409","1264","1265","410","411","412","448","449","599","600","1266","1267","1268","1269","1270","1271","340","341","342","343","344","345","346","347","348","349","350","426","352","353","354","355","356","358","359","360","361","362","363","364","365","367","368","369","432","371","1425","413","415","416","417","418","419","420","421","422","423","424","425","427","428","429","430","431","433","435","436","440","441","442","443","446","447","453","455","456","457","458","459","461","463","464","466","467","468","469","470","471","1413","478","482","483","484","750","751","752","753","754","755","768","1104","1105","1106","1107","1108","1109","1110","1111","1112","1113","1114","1116","1117","1118","1119","1120","1121","1122","1123","1124","1125","1126","1127","1128","1129","1130","1131","1132","1133","1134","1135","1136","1137","1138","1139","1140","1141","1142","1143","1144","1145","1146","1147","1148","1149","1150","1151","1152","1154","1155","1161","1162","1163","1164","1165","1166","1167","1168","1169","1170","1171","1172","1173","1174","1175","1176","1177","1178","1179","1180","1181","1182","1183","1184","1185","1186","1187","1188","1189","1190","1191","1192","1193","1194","1195","1196","1197","1198","1199","1200","1201","1202","1203","1204","1205","1206","1207","1208","1209","1210","1211","1212","1213","1214","1215","1216","1220","1412","1222","1223","1224","1225","1226","1227","1228","1229","1230","1231","1232","1233","1234","1235","1236","1237","1238","1239","1240","1241","1249","1250","1251","1252","1253","1254","1272","1273","1274","1275","1276","1277","1278","1279","1280","1281","1282","1283","1284","1285","1286","1287","1288","1289","1290","1291","1292","1293","1294","1295","1296","1298","1299","1300","1301","1302","1303","1304","1305","1306","1307","1308","1309","1310","1311","1312","1313","1314","1315","1316","1317","1318","1319","1320","1321","1322","1323","1324","1325","1326","1327","1328","1329","1330","1331","1332","1333","1334","1335","1336","1337","1338","1349","1350","1351","1352","1353","1354","1355","1356","1357","1358","1359","1360","1404","1405","1406","1407","1408","1409","1410","1411","1415","1420","1429","1430","1431","1432","1433","1434","1435","1436","1437","1438","1439","1440","1441","1442","1443","1444","1445","1446","1447","1448","1449","1450","1451","1452","1453","1454","1455","1456","1457","1458","1459","1460","1461","1462","1463","1464","1465","1466","1467","1468","1469","1470","1471","1472","1473","1474","1475","1476","1477","1478","1479","1480","1481","1482","1483","1484","1485","1486","1487","1488","1489","1490","1491","1492","1493","1494","1495","1496","1498","1499","1500","1511","1512","1513","1514","1515","1517","1599","1711","1712","1856","1857","1858") 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>1227206906
