use [ch_spravmedika_2]
SET ANSI_NULLS ON
SET ANSI_WARNINGS ON
SET LANGUAGE Russian

declare @stat_inet_UrlReferrer varchar(max) = '';
declare @stat_inet_params varchar(max) = '';
declare @stat_inet_path varchar(250) = '/catalog';
declare @stat_inet_host varchar(250) = 'chelny.spravmedika.ru';
declare @stat_inet_ip_n bigint = 54144055253;
declare @stat_inet_ip varchar(250) = '54.144.55.253';
declare @stat_inet_session_id_n bigint = 0;
declare @stat_inet_session_id varchar(250) = '';
declare @stat_inet_brouser varchar(max) = 'CCBot/2.0 (https://commoncrawl.org/faq/)';
declare @stat_inet_referrer varchar(max) = '';

declare @blocking_flag bit;
    declare @cnt int = 
    (select count(*)
        from ch_temp.dbo.php_blocking_ip with(nolock) where block_ip = @stat_inet_ip and block_date > getdate()
    )
    
    set @blocking_flag = (case when @cnt = 0 then 0 else 1 end);

exec common.dbo.p_add_php_stat_session
      @stat_inet_referrer,
      @stat_inet_brouser,
      @stat_inet_session_id,
      @stat_inet_ip,
      @stat_inet_host,
      @stat_inet_path,
      @stat_inet_params,
      @stat_inet_UrlReferrer,
      @blocking_flag
    
    select @blocking_flag as blocking_flag

use [ch_spravmedika_2]
SET ANSI_NULLS ON
SET ANSI_WARNINGS ON
SET LANGUAGE Russian

declare @area_id int = null;
declare @firm_id int = null;
declare @translate_lang_id int = 1;

select 
  ig1.international_group_id, 
  ig1.international_group_scode,
  ig1.international_group_name,
  ig1.international_group_latin,
  ig1.igColumnNum,
  max(ig2.international_group2_latin) as international_group2_latin, 
  sum(presence_cnt) as presence_cnt,
  count(*) as ig2_cnt 
from
  (select 
     international_group2_id, 
     sum(presence_cnt) as presence_cnt
   from 
     php_a_mpn with(nolock) 
   where 
     area_id = @area_id and firm_id = isnull(@firm_id, -1)
   group by 
     international_group2_id) t
    inner join international_group2 ig2 with(nolock) on ig2.translate_lang_id       = @translate_lang_id and
                                                        ig2.international_group2_id = t.international_group2_id
    inner join international_group  ig1 with(nolock) on ig1.translate_lang_id       = @translate_lang_id and
                                                        ig1.international_group_id  = ig2.international_group_id
where
  ig1.igColumnNum > 0 and ig1.area_show_flag = cast(1 as bit) 
group by
  ig1.international_group_id, 
  ig1.international_group_scode,
  ig1.international_group_name,
  ig1.international_group_latin,
  ig1.igColumnNum  
order by
  ig1.igColumnNum asc,
  ig1.international_group_scode asc,
  ig1.international_group_name

use [ch_spravmedika_2] SET ANSI_NULLS ON SET ANSI_WARNINGS ON SET LANGUAGE Russian SET CONCAT_NULL_YIELDS_NULL ON SET ANSI_PADDING ON exec dbo.p_getNewHexId " area_id="" lang="ru"xmlns="http://www.w3.org/1999/xhtml">

Удобный поиск лекарств в приложении «Справмедика»

Ещё

Каталог

ООО «Справмедика»
423824, г. Набережные Челны, ул. Машиностроительная, 91 (IT-парк), офис B305
Политика обработки персональных данных

статистика спроса по г. :

/ сутки

Расширенная статистика

Личный кабинет для юрлиц

Вся информация на сайте - справочная.

Перед применением лекарственных препаратов консультируйтесь с врачом.

use [ch_spravmedika_2]
SET ANSI_NULLS ON
SET ANSI_WARNINGS ON
SET LANGUAGE Russian

declare @php_time float = 20340;
declare @sql_time float = 911;
declare @sql_count int = 1;
declare @user_agent varchar(250) = ':CCBot/2.0 (https://commoncrawl.org/faq/)';
declare @router_name varchar(250) = 'catalog';
declare @url varchar(2000) = 'chelny.spravmedika.ru/catalog';
declare @refferer varchar(2000) = '';
declare @ip varchar(250) = '54.144.55.253';
declare @host varchar(250) = 'chelny.spravmedika.ru';
declare @port int = 80;

exec common.dbo.p_add_php_stat_page 
  @port,
  @host,
  @ip,
  @refferer,
  @url,
  @router_name,
  @user_agent,
  @sql_count,
  @sql_time,
  @php_time
  
-- дополнительная проверка наглых парсеров
if 
  @user_agent = ':Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 6.1; WOW64; Trident/7.0; SLCC2; .NET CLR 2.0.50727; .NET CLR 3.5.30729; .NET CLR 3.0.30729; Media Center PC 6.0; .NET4.0C; .NET4.0E)'
begin
  declare @mm_cnt int = (
  select MAX(t.cnt) from (
  select 
    DATEPART(minute, tsdate) as mm,
    COUNT(*) as cnt
  from ch_temp..php_stat_page with(nolock) where IP = @ip and tsdate > dateadd(minute, -3, getdate())
  group by DATEPART(minute, tsdate)
  ) t )
  if @mm_cnt > 10 --открывает больше 10 страниц в минуту
  begin
    declare @c int = (select COUNT(*) from ch_stat..php_stat_ip_permitted with(nolock) where IP = @ip)
    if @c=0
    begin
      insert into ch_stat..php_stat_ip_permitted(IP,create_date,comment,ok_flag,ban_flag)
      values(@ip,GETDATE(),'Атоматическое добавление наглого парсера',0,1)
    end
  end
end