№ п/п | Тип | Старт | Стоп | Д(мс) | Сообщение |
1 | SqlTrace | 17:08:38:3760000 | 17:08:38:3916000 | 15 | sql = SELECT * FROM settings WHERE id=1 connection = server=db1;port=6432;database=buyreklama;minpoolsize=1;maxpoolsize=500; params =
|
2 | SqlCacheTrace | 17:08:38:4072000 | 17:08:38:4072000 | 0 | sql = SELECT * FROM buyreklama.cities connection = server=db0;port=5432;database=buyreklama;minpoolsize=1;maxpoolsize=500; params =
|
3 | SqlTrace | 17:08:38:4072000 | 17:08:38:4072000 | 0 | LoadCatalogList данные взяты из кэша Cache |
4 | SqlTrace | 17:08:38:4072000 | 17:08:38:4072000 | 0 | sql = 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, 1761) 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=db1;port=6432;database=buyreklama;minpoolsize=1;maxpoolsize=500; params =
|
5 | NoteMessage | 17:08:38:4072000 | 17:08:38:4072000 | 0 | Каталог 1761 Дополнительный заработок |
6 | SqlCacheTrace | 17:08:38:4072000 | 17:08:38:4072000 | 0 | sql = select *,cp.id as cp_id from buyreklama.class_properties cp where cp.object_class_id =0 order by cp.table_display_order connection = server=db0;port=5432;database=buyreklama;minpoolsize=1;maxpoolsize=500; params =
|
7 | SqlCacheTrace | 17:08:38:4072000 | 17:08:38:4072000 | 0 | sql = select *,cp.id as cp_id from buyreklama.class_properties cp where cp.object_class_id =0 order by cp.display_order connection = server=db0;port=5432;database=buyreklama;minpoolsize=1;maxpoolsize=500; params =
|
8 | SqlCacheTrace | 17:08:38:4072000 | 17:08:38:4072000 | 0 | sql = 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 =
|
9 | SqlCacheTrace | 17:08:38:4072000 | 17:08:38:4072000 | 0 | sql = SELECT * FROM class_properties WHERE object_class_id=0 ORDER by is_foreign_key DESC connection = server=db0;port=5432;database=buyreklama;minpoolsize=1;maxpoolsize=500; params =
|
10 | SqlTrace | 17:08:38:4072000 | 17:08:38:4540000 | 46 | sql = 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 ='dopolnitelnyj-zarabotok' and apparel_id=1) OR main.list_parent_id in (select id from apl.catalogs where item_url ='dopolnitelnyj-zarabotok' and apparel_id=1)) order by main.display_order2, child.display_order connection = server=db1;port=6432;database=buyreklama;minpoolsize=1;maxpoolsize=500; params =
|