Реклама

Планшеты в Химки



Не нашли то, что искали? Спросите об этом - Дайте бесплатное объявление и ждите звонков
№ п/пТипСтартСтопД(мс)Сообщение
1SqlTrace00:32:52:974200000:32:52:989800015sql = SELECT * FROM settings WHERE id=1
connection = server=db0;port=5432;database=buyreklama;minpoolsize=1;maxpoolsize=500;
params =
2SqlCacheTrace00:32:52:989800000:32:52:98980000sql = SELECT * FROM buyreklama.cities
connection = server=db0;port=5432;database=buyreklama;minpoolsize=1;maxpoolsize=500;
params =
3SqlTrace00:32:52:989800000:32:52:98980000LoadCatalogList данные взяты из кэша Cache
4SqlTrace00:32:52:989800000:32:53:005400015sql = SELECT id,city_id,catalog_id,title, description, keywords, h1, seotext,update_date FROM buyreklama.seo WHERE city_id in (0,587) and catalog_id in (0, 2875) and post_id=0 and apparel_id in (0, 1) and page_no in (0, 1) order by city_id desc, (catalog_id + apparel_id) desc, page_no desc
connection = server=db0;port=5432;database=buyreklama;minpoolsize=1;maxpoolsize=500;
params =
5NoteMessage00:32:53:005400000:32:53:00540000Каталог 2875 Планшеты
6SqlTrace00:32:53:005400000:32:53:021000015sql = select *,cp.id as cp_id from buyreklama.class_properties cp where cp.object_class_id =32 order by cp.table_display_order
connection = server=db0;port=5432;database=buyreklama;minpoolsize=1;maxpoolsize=500;
params =
7SqlTrace00:32:53:021000000:32:53:036600015sql = select *,cp.id as cp_id from buyreklama.class_properties cp where cp.object_class_id =32 order by cp.display_order
connection = server=db0;port=5432;database=buyreklama;minpoolsize=1;maxpoolsize=500;
params =
8SqlTrace00:32:53:036600000:32:53:03660000sql = select * from buyreklama.property_lovs plovs,buyreklama.class_properties p where plovs.property_id=p.id and plovs.property_id=8 order by plovs.display_order, plovs.display_name
connection = server=db0;port=5432;database=buyreklama;minpoolsize=1;maxpoolsize=500;
params =
9SqlTrace00:32:53:036600000:32:53:052200015sql = select * from buyreklama.property_lovs plovs,buyreklama.class_properties p where plovs.property_id=p.id and plovs.property_id=374 order by plovs.display_order, plovs.display_name
connection = server=db0;port=5432;database=buyreklama;minpoolsize=1;maxpoolsize=500;
params =
10SqlTrace00:32:53:052200000:32:53:067800015sql = select * from buyreklama.property_lovs plovs,buyreklama.class_properties p where plovs.property_id=p.id and plovs.property_id=375 order by plovs.display_order, plovs.display_name
connection = server=db0;port=5432;database=buyreklama;minpoolsize=1;maxpoolsize=500;
params =
11SqlTrace00:32:53:067800000:32:53:06780000sql = select * from buyreklama.property_lovs plovs,buyreklama.class_properties p where plovs.property_id=p.id and plovs.property_id=376 order by plovs.display_order, plovs.display_name
connection = server=db0;port=5432;database=buyreklama;minpoolsize=1;maxpoolsize=500;
params =
12SqlTrace00:32:53:067800000:32:53:083400015sql = select * from buyreklama.property_lovs plovs,buyreklama.class_properties p where plovs.property_id=p.id and plovs.property_id=377 order by plovs.display_order, plovs.display_name
connection = server=db0;port=5432;database=buyreklama;minpoolsize=1;maxpoolsize=500;
params =
13SqlTrace00:32:53:083400000:32:53:08340000sql = select * from buyreklama.property_lovs plovs,buyreklama.class_properties p where plovs.property_id=p.id and plovs.property_id=378 order by plovs.display_order, plovs.display_name
connection = server=db0;port=5432;database=buyreklama;minpoolsize=1;maxpoolsize=500;
params =
14SqlTrace00:32:53:083400000:32:53:08340000sql = select * from buyreklama.property_lovs plovs,buyreklama.class_properties p where plovs.property_id=p.id and plovs.property_id=379 order by plovs.display_order, plovs.display_name
connection = server=db0;port=5432;database=buyreklama;minpoolsize=1;maxpoolsize=500;
params =
15SqlTrace00:32:53:083400000:32:53:099000015sql = select * from buyreklama.property_lovs plovs,buyreklama.class_properties p where plovs.property_id=p.id and plovs.property_id=380 order by plovs.display_order, plovs.display_name
connection = server=db0;port=5432;database=buyreklama;minpoolsize=1;maxpoolsize=500;
params =
16SqlCacheTrace00:32:53:099000000:32:53:09900000sql = select * from buyreklama.property_lovs plovs,buyreklama.class_properties p where plovs.property_id=p.id and plovs.property_id=0 order by plovs.display_order, plovs.display_name
connection = server=db0;port=5432;database=buyreklama;minpoolsize=1;maxpoolsize=500;
params =
17SqlTrace00:32:53:099000000:32:53:09900000sql = select * from buyreklama.property_lovs plovs,buyreklama.class_properties p where plovs.property_id=p.id and plovs.property_id=381 order by plovs.display_order, plovs.display_name
connection = server=db0;port=5432;database=buyreklama;minpoolsize=1;maxpoolsize=500;
params =
18SqlTrace00:32:53:099000000:32:53:09900000sql = select * from buyreklama.property_lovs plovs,buyreklama.class_properties p where plovs.property_id=p.id and plovs.property_id=382 order by plovs.display_order, plovs.display_name
connection = server=db0;port=5432;database=buyreklama;minpoolsize=1;maxpoolsize=500;
params =
19SqlTrace00:32:53:099000000:32:53:114600015sql = select * from buyreklama.property_lovs plovs,buyreklama.class_properties p where plovs.property_id=p.id and plovs.property_id=383 order by plovs.display_order, plovs.display_name
connection = server=db0;port=5432;database=buyreklama;minpoolsize=1;maxpoolsize=500;
params =
20SqlTrace00:32:53:114600000:32:53:11460000sql = select * from buyreklama.property_lovs plovs,buyreklama.class_properties p where plovs.property_id=p.id and plovs.property_id=384 order by plovs.display_order, plovs.display_name
connection = server=db0;port=5432;database=buyreklama;minpoolsize=1;maxpoolsize=500;
params =
21SqlTrace00:32:53:114600000:32:53:11460000sql = select * from buyreklama.property_lovs plovs,buyreklama.class_properties p where plovs.property_id=p.id and plovs.property_id=385 order by plovs.display_order, plovs.display_name
connection = server=db0;port=5432;database=buyreklama;minpoolsize=1;maxpoolsize=500;
params =
22SqlTrace00:32:53:114600000:32:53:11460000sql = select * from buyreklama.property_lovs plovs,buyreklama.class_properties p where plovs.property_id=p.id and plovs.property_id=10 order by plovs.display_order, plovs.display_name
connection = server=db0;port=5432;database=buyreklama;minpoolsize=1;maxpoolsize=500;
params =
23SqlTrace00:32:53:114600000:32:53:130200015sql = SELECT * FROM class_properties WHERE object_class_id=32 ORDER by is_foreign_key DESC
connection = server=db0;port=5432;database=buyreklama;minpoolsize=1;maxpoolsize=500;
params =
24SqlTrace00:32:53:130200000:32:53:177000046sql = select main.item_name as main_item_name,main.advert_code,main.id as main_id,child.id as child_id, child.item_name as child_item_name,child.item_url as child_url,main.item_url as main_url,child.display_as_child_catalog_item as child_display_as_child,main.all_item_name as all_item_name,child.count as child_count,main.count as main_count from buyreklama.v_catalog_statistics main left outer join buyreklama.v_catalog_statistics child on child.parent_id=main.id and main.city_id=child.city_id where main.city_id=587 and main.object_id=3 and main.org_id=19 and main.display_as_main_catalog_item='Y' and (main.parent_id in (select id from apl.catalogs where item_url ='planshety' and apparel_id=1) OR main.list_parent_id in (select id from apl.catalogs where item_url ='planshety' and apparel_id=1)) order by main.display_order2, child.display_order
connection = server=db0;port=5432;database=buyreklama;minpoolsize=1;maxpoolsize=500;
params =
25SqlTrace00:32:53:177000000:32:53:17700000sql = SELECT count(id) FROM buyreklama.buyreklama_posts where 1=1 and city_id=587 AND (moderation=2 OR moderation=4 or aspxanonymouscookie='sIBFvDXH0wEkAAAAYWQ5Y2FhYWUtNmE1ZS00Y2I2LTg4NDAtOGRmY2U3YzEzZDViLBEMebc_1u7EKrSHfVSCJy7c5fNKIceapc0zDZ130FE1') and is_hide<>1 and on_object_row_id =2875
connection = server=db0;port=5432;database=buyreklama;minpoolsize=1;maxpoolsize=500;
params =
26SqlTrace00:32:53:177000000:32:53:192600015sql = SELECT update_date FROM city_portal.announcements_v ann where 1=1 and city_id=587 AND (moderation=2 OR moderation=4 or aspxanonymouscookie='sIBFvDXH0wEkAAAAYWQ5Y2FhYWUtNmE1ZS00Y2I2LTg4NDAtOGRmY2U3YzEzZDViLBEMebc_1u7EKrSHfVSCJy7c5fNKIceapc0zDZ130FE1') and apparel_id=1 and this_rubric_id =2875 order by update_date desc limit 1 offset 1*20-20
connection = server=db0;port=5432;database=buyreklama;minpoolsize=1;maxpoolsize=500;
params =
27SqlTrace00:32:53:192600000:32:53:223800031sql = SELECT * , ann_photo, c1, c2, c3, price FROM city_portal.announcements_v ann where 1=1 and city_id=587 AND (moderation=2 OR moderation=4 or aspxanonymouscookie='sIBFvDXH0wEkAAAAYWQ5Y2FhYWUtNmE1ZS00Y2I2LTg4NDAtOGRmY2U3YzEzZDViLBEMebc_1u7EKrSHfVSCJy7c5fNKIceapc0zDZ130FE1') and is_hide<>1 and apparel_id=1 and this_rubric_id =2875 and top_date>=now() order by paid_client desc,top_date desc
connection = server=db0;port=5432;database=buyreklama;minpoolsize=1;maxpoolsize=500;
params =
28SqlTrace00:32:53:223800000:32:53:239400015sql = SELECT * , ann_photo, c1, c2, c3, price FROM city_portal.announcements_v ann where 1=1 and city_id=587 AND (moderation=2 OR moderation=4 or aspxanonymouscookie='sIBFvDXH0wEkAAAAYWQ5Y2FhYWUtNmE1ZS00Y2I2LTg4NDAtOGRmY2U3YzEzZDViLBEMebc_1u7EKrSHfVSCJy7c5fNKIceapc0zDZ130FE1') and is_hide<>1 and apparel_id=1 and this_rubric_id =2875 and urgently_date>=now() order by urgently_date desc
connection = server=db0;port=5432;database=buyreklama;minpoolsize=1;maxpoolsize=500;
params =
29SqlTrace00:32:53:239400000:32:53:23940000sql = SELECT * , ann_photo, c1, c2, c3, price FROM city_portal.announcements_v ann where 1=1 and city_id=587 AND (moderation=2 OR moderation=4 or aspxanonymouscookie='sIBFvDXH0wEkAAAAYWQ5Y2FhYWUtNmE1ZS00Y2I2LTg4NDAtOGRmY2U3YzEzZDViLBEMebc_1u7EKrSHfVSCJy7c5fNKIceapc0zDZ130FE1') and is_hide<>1 and apparel_id=1 and this_rubric_id =2875 and (top_date<now() or top_date is null) ORDER BY ann_photo IS NOT NULL AND ann_photo<>'' desc, create_date::date desc,length(post_text) desc nulls last limit 20 offset 0
connection = server=db0;port=5432;database=buyreklama;minpoolsize=1;maxpoolsize=500;
params =
30SqlTrace00:32:53:239400000:32:54:48740001248sql = SELECT CASE WHEN city_id=587 THEN 1 ELSE 0 END AS city_order,* FROM city_portal.announcements_v ann WHERE
moderation=2 AND is_hide<>1 AND apparel_id=1 AND main_rubric_id=368 AND parent_id=0 AND rubric_id<>2875
ORDER BY city_order DESC,create_date::DATE DESC,length(post_text) DESC LIMIT(10)
connection = server=db0;port=5432;database=buyreklama;minpoolsize=1;maxpoolsize=500;
params =

Итого:01:5132000