Queries by type:
select10 80392.92%
delete8227.07%
and10.01%
Total: 11 626 queries
Queries by pattern:
#Qty%Query
1179515.439532083262%select id,message,message_lid,save_statistic,url_redirect,test from b_stop_list where active={}and test={}and(site_id={}or site_id is{}or length(site_id)<={})and(date_start<=now()or date_start is{})and(date_end>=now()or date_end is{})and((((mask_1&{})=ip_1 and(mask_2&{})=ip_2 and(mask_3&{})=ip_3 and(mask_4&{})=ip_4)or(ip_1 is{}and ip_2 is{}and ip_3 is{}and ip_4 is{}))and(upper({})like concat({},upper(user_agent),{})or length(user_agent)<={}or user_agent is{})and({}={}or user_agent_is_null<>{})and(upper({})like concat({},upper(url_from),{})or length(url_from)<={}or url_from is{})and(upper({})like concat({},upper(url_to),{})or length(url_to)<={}or url_to is{}));
2174915.04386719422%select vv.*,c.title as channel_title,v.*,date_format(v.date_start,{})date_start,date_format(v.date_end,{})date_end,unix_timestamp(v.date_end)-unix_timestamp(v.date_start)period from(select v.channel_id,v.id,count(q.id)questions,if((c.vote_single={}),(if(v.id=vv.active_vote_id,{})),(if(v.active={}and v.date_start<=now()and now()<=v.date_end,{})))lamp from b_vote v inner join b_vote_channel c on(c.id=v.channel_id)left join b_vote_question q on(q.vote_id=v.id)left join(select vvv.channel_id,max(vvv.id)as active_vote_id from b_vote vvv,b_vote_channel ccc where vvv.channel_id=ccc.id and ccc.vote_single={}and vvv.active={}and now()>=vvv.date_start and vvv.date_end>=now()group by vvv.channel_id)vv on(vv.channel_id=v.channel_id)where({}={}and(((v.id={}and v.id is not{}))))group by v.channel_id,v.id)vv inner join b_vote_channel c on(c.id=vv.channel_id)inner join b_vote v on(v.id=vv.id)order by v.id desc;
3164114.114914846035%select distinct b.type_sid,b.id banner_id,b.weight banner_weight,b.shows_for_visitor,b.fix_click,b.fix_show,b.keywords banner_keywords,date_format(b.date_show_first,{})date_show_first,date_format(b.date_show_from,{})date_show_from,date_format(b.date_show_to,{})date_show_to,b.flyuniform flyuniform,b.max_show_count max_show_count,b.show_count show_count,c.id contract_id,c.weight contract_weight,c.keywords contract_keywords from b_adv_type t inner join b_adv_banner b on(b.active={}and b.type_sid=t.sid and b.status_sid={}and(b.for_new_guest is{}or b.for_new_guest={})and(ifnull(b.max_show_count,{})>ifnull(b.show_count,{})or ifnull(b.max_show_count,{})={})and(ifnull(b.max_click_count,{})>ifnull(b.click_count,{})or ifnull(b.max_click_count,{})={})and(ifnull(b.max_visitor_count,{})>ifnull(b.visitor_count,{})or ifnull(b.max_visitor_count,{})={})and(b.date_show_from<=now()or b.date_show_from is{}or length(b.date_show_from)<={})and(b.date_show_to>=now()or b.date_show_to is{}or length(b.date_show_to)<={}))inner join b_adv_banner_2_site bs on(bs.banner_id=b.id and bs.site_id={})inner join b_adv_contract c on(c.id=b.contract_id and c.active={}and(ifnull(c.max_show_count,{})>ifnull(c.show_count,{})or ifnull(c.max_show_count,{})={})and(ifnull(c.max_click_count,{})>ifnull(c.click_count,{})or ifnull(c.max_click_count,{})={})and(ifnull(c.max_visitor_count,{})>ifnull(c.visitor_count,{})or ifnull(c.max_visitor_count,{})={})and(c.date_show_from<=now()or c.date_show_from is{}or length(c.date_show_from)<={})and(c.date_show_to>=now()or c.date_show_to is{}or length(c.date_show_to)<={}))inner join b_adv_contract_2_site cs on(cs.contract_id=b.contract_id and cs.site_id={})inner join b_adv_contract_2_type ct on(ct.contract_id=c.id and(ct.type_sid={}or ct.type_sid=t.sid))inner join b_adv_banner_2_weekday bw on(bw.banner_id=b.id and bw.c_weekday={}and bw.c_hour={})inner join b_adv_contract_2_weekday cw on(cw.contract_id=c.id and cw.c_weekday={}and cw.c_hour={})left join b_adv_banner_2_group ug1 on((ug1.banner_id=b.id and ug1.group_id in({})and ug1.group_id<>{}))left join b_adv_banner_2_page bp1 on(bp1.banner_id=b.id and bp1.show_on_page={})left join b_adv_banner_2_page bp2 on(bp2.banner_id=b.id and bp2.show_on_page={}and{}like concat(bp2.page,{}))left join b_adv_contract_2_page cp1 on(cp1.contract_id=c.id and cp1.show_on_page={})left join b_adv_contract_2_page cp2 on(cp2.contract_id=c.id and cp2.show_on_page={}and{}like concat(cp2.page,{}))left join b_adv_banner_2_stat_adv ba on ba.banner_id=b.id left join b_adv_banner_2_country bc on bc.banner_id=b.id and(((b.stat_type is{}or length(b.stat_type)={}or b.stat_type={})and bc.country_id={})or(b.stat_type={}and bc.country_id={}and bc.region={})or(b.stat_type={}and bc.city_id={}))where t.active={}and(b.stat_count is{}or b.stat_count={}or bc.banner_id is not{})and bp2.id is{}and cp2.id is{}and(bp1.id is{}or{}like concat(bp1.page,{}))and(cp1.id is{}or{}like concat(cp1.page,{}))and(ba.stat_adv_id is{}or ba.stat_adv_id={})and(bc.country_id is{}or bc.country_id={})and((b.show_user_group={}and ug1.group_id is not{})or(b.show_user_group<>{}and ug1.group_id is{}))order by b.type_sid desc,c.id desc;
4163814.089110614141%select vv.*,c.title as channel_title,v.*,date_format(v.date_start,{})date_start,date_format(v.date_end,{})date_end,unix_timestamp(v.date_end)-unix_timestamp(v.date_start)period from(select v.channel_id,v.id,count(q.id)questions,if((c.vote_single={}),(if(v.id=vv.active_vote_id,{})),(if(v.active={}and v.date_start<=now()and now()<=v.date_end,{})))lamp from b_vote v inner join b_vote_channel c on(c.id=v.channel_id)left join b_vote_question q on(q.vote_id=v.id)left join(select vvv.channel_id,max(vvv.id)as active_vote_id from b_vote vvv,b_vote_channel ccc where vvv.channel_id=ccc.id and ccc.vote_single={}and vvv.active={}and now()>=vvv.date_start and vvv.date_end>=now()and((ccc.id={}and ccc.id is not{}))group by vvv.channel_id)vv on(vv.channel_id=v.channel_id)where({}={}and(((v.channel_id={}and v.channel_id is not{})))and((v.active={}and now()>=v.date_start and now()<=v.date_end)))group by v.channel_id,v.id)vv inner join b_vote_channel c on(c.id=vv.channel_id)inner join b_vote v on(v.id=vv.id)order by v.id desc;
58477.285394804748%select*from b_sec_virus where sent={};
68217.061758128333%delete from b_sec_virus where timestamp_x<={};
77756.6660932392912%select be.id as id,be.name as name,be.tags as tags,be.preview_text as preview_text,be.preview_picture as preview_picture,be.detail_picture as detail_picture,if(extract(hour_second from be.active_from)>{},date_format(be.active_from,{}),date_format(be.active_from,{}))as date_active_from,if(extract(hour_second from be.active_from)>{},date_format(be.active_from,{}),date_format(be.active_from,{}))as active_from,be.show_counter as show_counter,be.created_by as created_by,concat({},uc.login,{},ifnull(uc.name,{}),{},ifnull(uc.last_name,{}))as created_user_name,be.iblock_id as iblock_id,be.iblock_section_id as iblock_section_id,b.detail_page_url as detail_page_url,be.detail_text as detail_text,be.detail_text_type as detail_text_type,be.preview_text_type as preview_text_type,fps0.*,l.dir as lang_dir,be.sort as sort,be.code as code,be.xml_id as external_id,b.iblock_type_id as iblock_type_id,b.code as iblock_code,b.xml_id as iblock_external_id,b.lid as lid from b_iblock b inner join b_lang l on b.lid=l.lid inner join b_iblock_element be on be.iblock_id=b.id inner join b_iblock_element_prop_s1 fps0 on fps0.iblock_element_id=be.id inner join(select distinct b.id from b_iblock b inner join b_iblock_site bs on bs.iblock_id=b.id inner join b_iblock_group ibg on ibg.iblock_id=b.id where((((bs.site_id={}))))and((ibg.group_id in({})and ibg.permission>={}and(ibg.permission={}or b.active={})))and((((b.id={})))))bb on bb.id=be.iblock_id left join b_user uc on uc.id=be.created_by where{}={}and(((((be.iblock_id={}))))and((((be.active={}))))and(((fps0.property_8 is{}or not(fps0.property_8={})))))and(((be.wf_status_id={}and be.wf_parent_element_id is{})))order by be.active_from desc,be.sort asc,be.id desc limit{};
85544.7651814897643%select vv.*,c.title as channel_title,v.*,date_format(v.date_start,{})date_start,date_format(v.date_end,{})date_end,unix_timestamp(v.date_end)-unix_timestamp(v.date_start)period from(select v.channel_id,v.id,count(q.id)questions,if((c.vote_single={}),(if(v.id=vv.active_vote_id,{})),(if(v.active={}and v.date_start<=now()and now()<=v.date_end,{})))lamp from b_vote v inner join b_vote_channel c on(c.id=v.channel_id)left join b_vote_question q on(q.vote_id=v.id)left join(select vvv.channel_id,max(vvv.id)as active_vote_id from b_vote vvv,b_vote_channel ccc where vvv.channel_id=ccc.id and ccc.vote_single={}and vvv.active={}and now()>=vvv.date_start and vvv.date_end>=now()group by vvv.channel_id)vv on(vv.channel_id=v.channel_id)where({}={}and(((v.id={}and v.id is not{})))and(v.active={}))group by v.channel_id,v.id)vv inner join b_vote_channel c on(c.id=vv.channel_id)inner join b_vote v on(v.id=vv.id)order by v.id desc;
95364.6103560984001%select be.id as id,date_format(be.timestamp_x,{})as timestamp_x,be.modified_by as modified_by,date_format(be.date_create,{})as date_create,be.created_by as created_by,be.iblock_id as iblock_id,be.iblock_section_id as iblock_section_id,be.active as active,if(extract(hour_second from be.active_from)>{},date_format(be.active_from,{}),date_format(be.active_from,{}))as active_from,if(extract(hour_second from be.active_to)>{},date_format(be.active_to,{}),date_format(be.active_to,{}))as active_to,if(extract(hour_second from be.active_from)>{},date_format(be.active_from,{}),date_format(be.active_from,{}))as date_active_from,if(extract(hour_second from be.active_to)>{},date_format(be.active_to,{}),date_format(be.active_to,{}))as date_active_to,be.sort as sort,be.name as name,be.preview_picture as preview_picture,be.preview_text as preview_text,be.preview_text_type as preview_text_type,be.detail_picture as detail_picture,be.detail_text as detail_text,be.detail_text_type as detail_text_type,be.searchable_content as searchable_content,be.wf_status_id as wf_status_id,be.wf_parent_element_id as wf_parent_element_id,be.wf_last_history_id as wf_last_history_id,be.wf_new as wf_new,if(be.wf_date_lock is{},if(date_add(be.wf_date_lock,interval{}minute)<now(),{},if(be.wf_locked_by={})))as lock_status,be.wf_locked_by as wf_locked_by,date_format(be.wf_date_lock,{})as wf_date_lock,be.wf_comments as wf_comments,be.in_sections as in_sections,be.show_counter as show_counter,be.show_counter_start as show_counter_start,be.code as code,be.tags as tags,be.xml_id as xml_id,be.xml_id as external_id,be.tmp_id as tmp_id,concat({},u.login,{},ifnull(u.name,{}),{},ifnull(u.last_name,{}))as user_name,concat({},ul.login,{},ifnull(ul.name,{}),{},ifnull(ul.last_name,{}))as locked_user_name,concat({},uc.login,{},ifnull(uc.name,{}),{},ifnull(uc.last_name,{}))as created_user_name,l.dir as lang_dir,b.lid as lid,b.iblock_type_id as iblock_type_id,b.code as iblock_code,b.name as iblock_name,b.xml_id as iblock_external_id,b.detail_page_url as detail_page_url,b.list_page_url as list_page_url,date_format(be.date_create,{})as created_date,if(be.wf_status_id={})as bp_published from b_iblock b inner join b_lang l on b.lid=l.lid inner join b_iblock_element be on be.iblock_id=b.id inner join(select distinct b.id from b_iblock b inner join b_iblock_group ibg on ibg.iblock_id=b.id where((ibg.group_id in({})and ibg.permission>={}and(ibg.permission={}or b.active={}))))bb on bb.id=be.iblock_id left join b_user u on u.id=be.modified_by left join b_user ul on ul.id=be.wf_locked_by left join b_user uc on uc.id=be.created_by where{}={}and(((((be.id={}))))and(((be.active_to>=now()or be.active_to is{})and(be.active_from<=now()or be.active_from is{})))and((((be.active={})))))and(((be.wf_status_id={}and be.wf_parent_element_id is{})));
103963.406158610012%select be.id as id,be.name as name,b.detail_page_url as detail_page_url,fps0.property_3 as property_rayting_value,fps0.description_3 as property_rayting_description,concat(be.id,{})as property_rayting_value_id,l.dir as lang_dir,be.code as code,be.xml_id as external_id,be.iblock_section_id as iblock_section_id,b.iblock_type_id as iblock_type_id,be.iblock_id as iblock_id,b.code as iblock_code,b.xml_id as iblock_external_id,b.lid as lid from b_iblock b inner join b_lang l on b.lid=l.lid inner join b_iblock_element be on be.iblock_id=b.id inner join b_iblock_element_prop_s1 fps0 on fps0.iblock_element_id=be.id where{}={}and(((((be.iblock_id={}))))and((((be.active_from>{})))))and(((be.wf_status_id={}and be.wf_parent_element_id is{})))order by fps0.property_3 desc;
112862.4600034405643%select count({})as c from b_iblock b inner join b_lang l on b.lid=l.lid inner join b_iblock_element be on be.iblock_id=b.id inner join b_iblock_element_prop_s1 fps0 on fps0.iblock_element_id=be.id inner join(select distinct b.id from b_iblock b inner join b_iblock_site bs on bs.iblock_id=b.id inner join b_iblock_group ibg on ibg.iblock_id=b.id where((((bs.site_id={}))))and((ibg.group_id in({})and ibg.permission>={}and(ibg.permission={}or b.active={})))and((((b.id={})))))bb on bb.id=be.iblock_id left join b_user uc on uc.id=be.created_by where{}={}and(((((be.iblock_id={}))))and((((be.active={}))))and(((fps0.property_8 is{}or not(fps0.property_8={})))))and(((be.wf_status_id={}and be.wf_parent_element_id is{})));
121231.0579735076553%select be.id as id,be.name as name,be.tags as tags,be.preview_text as preview_text,be.preview_picture as preview_picture,be.detail_text as detail_text,be.detail_picture as detail_picture,if(extract(hour_second from be.active_from)>{},date_format(be.active_from,{}),date_format(be.active_from,{}))as date_active_from,if(extract(hour_second from be.active_from)>{},date_format(be.active_from,{}),date_format(be.active_from,{}))as active_from,be.show_counter as show_counter,concat({},uc.login,{},ifnull(uc.name,{}),{},ifnull(uc.last_name,{}))as created_user_name,be.iblock_id as iblock_id,be.iblock_section_id as iblock_section_id,b.detail_page_url as detail_page_url,be.detail_text_type as detail_text_type,be.preview_text_type as preview_text_type,fps0.*,l.dir as lang_dir,be.sort as sort,be.code as code,be.xml_id as external_id,b.iblock_type_id as iblock_type_id,b.code as iblock_code,b.xml_id as iblock_external_id,b.lid as lid from b_iblock b inner join b_lang l on b.lid=l.lid inner join b_iblock_element be on be.iblock_id=b.id inner join b_iblock_element_prop_s1 fps0 on fps0.iblock_element_id=be.id inner join(select distinct b.id from b_iblock b inner join b_iblock_site bs on bs.iblock_id=b.id inner join b_iblock_group ibg on ibg.iblock_id=b.id where((((bs.site_id={}))))and((ibg.group_id in({})and ibg.permission>={}and(ibg.permission={}or b.active={})))and((((b.id={})))))bb on bb.id=be.iblock_id inner join(select distinct bse.iblock_element_id from b_iblock_section_element bse inner join b_iblock_section bs on bse.iblock_section_id=bs.id where((bs.code in({}))))bes on bes.iblock_element_id=be.id left join b_user uc on uc.id=be.created_by where{}={}and(((((be.iblock_id={}))))and((((be.active={})))))and(((be.wf_status_id={}and be.wf_parent_element_id is{})))order by be.active_from desc,be.sort asc,be.id desc limit{};
131231.0579735076553%select count({})as c from b_iblock b inner join b_lang l on b.lid=l.lid inner join b_iblock_element be on be.iblock_id=b.id inner join b_iblock_element_prop_s1 fps0 on fps0.iblock_element_id=be.id inner join(select distinct b.id from b_iblock b inner join b_iblock_site bs on bs.iblock_id=b.id inner join b_iblock_group ibg on ibg.iblock_id=b.id where((((bs.site_id={}))))and((ibg.group_id in({})and ibg.permission>={}and(ibg.permission={}or b.active={})))and((((b.id={})))))bb on bb.id=be.iblock_id inner join(select distinct bse.iblock_element_id from b_iblock_section_element bse inner join b_iblock_section bs on bse.iblock_section_id=bs.id where((bs.code in({}))))bes on bes.iblock_element_id=be.id left join b_user uc on uc.id=be.created_by where{}={}and(((((be.iblock_id={}))))and((((be.active={})))))and(((be.wf_status_id={}and be.wf_parent_element_id is{})));
14670.57629451230002%select be.id as id,be.name as name,be.tags as tags,be.preview_text as preview_text,be.preview_picture as preview_picture,be.detail_picture as detail_picture,if(extract(hour_second from be.active_from)>{},date_format(be.active_from,{}),date_format(be.active_from,{}))as date_active_from,if(extract(hour_second from be.active_from)>{},date_format(be.active_from,{}),date_format(be.active_from,{}))as active_from,be.show_counter as show_counter,be.created_by as created_by,concat({},uc.login,{},ifnull(uc.name,{}),{},ifnull(uc.last_name,{}))as created_user_name,be.iblock_id as iblock_id,be.iblock_section_id as iblock_section_id,b.detail_page_url as detail_page_url,be.detail_text as detail_text,be.detail_text_type as detail_text_type,be.preview_text_type as preview_text_type,fps0.*,l.dir as lang_dir,be.sort as sort,be.code as code,be.xml_id as external_id,b.iblock_type_id as iblock_type_id,b.code as iblock_code,b.xml_id as iblock_external_id,b.lid as lid from b_iblock b inner join b_lang l on b.lid=l.lid inner join b_iblock_element be on be.iblock_id=b.id inner join b_iblock_element_prop_s1 fps0 on fps0.iblock_element_id=be.id inner join(select distinct b.id from b_iblock b inner join b_iblock_site bs on bs.iblock_id=b.id inner join b_iblock_group ibg on ibg.iblock_id=b.id where((((bs.site_id={}))))and((ibg.group_id in({})and ibg.permission>={}and(ibg.permission={}or b.active={})))and((((b.id={})))))bb on bb.id=be.iblock_id left join b_user uc on uc.id=be.created_by where{}={}and(((((be.iblock_id={}))))and((((be.active={}))))and((((be.tags like{}))or((be.tags like{}))or((be.tags like{})))))and(((be.wf_status_id={}and be.wf_parent_element_id is{})))order by be.active_from desc,be.sort asc,be.id desc limit{};
15670.57629451230002%select count({})as c from b_iblock b inner join b_lang l on b.lid=l.lid inner join b_iblock_element be on be.iblock_id=b.id inner join b_iblock_element_prop_s1 fps0 on fps0.iblock_element_id=be.id inner join(select distinct b.id from b_iblock b inner join b_iblock_site bs on bs.iblock_id=b.id inner join b_iblock_group ibg on ibg.iblock_id=b.id where((((bs.site_id={}))))and((ibg.group_id in({})and ibg.permission>={}and(ibg.permission={}or b.active={})))and((((b.id={})))))bb on bb.id=be.iblock_id left join b_user uc on uc.id=be.created_by where{}={}and(((((be.iblock_id={}))))and((((be.active={}))))and((((be.tags like{}))or((be.tags like{}))or((be.tags like{})))))and(((be.wf_status_id={}and be.wf_parent_element_id is{})));
16580.49888181661793%select`t1`.`friend_id`,`t1`.`status`,`t2`.`id`,`t2`.`name`,`t2`.`login`,`t2`.`last_name`,`t2`.`personal_birthday`,`t2`.`personal_city`,`t2`.`personal_photo`from`b_snetwork_user_relations`as t1 inner join`b_user`as t2 on`t1`.`friend_id`=`t2`.`id`where(t1.`user_id`={})and(t1.`status`={}or t1.`status`={})union select`t1`.`friend_id`,`t1`.`status`,`t2`.`id`,`t2`.`name`,`t2`.`login`,`t2`.`last_name`,`t2`.`personal_birthday`,`t2`.`personal_city`,`t2`.`personal_photo`from`b_snetwork_user_relations`as t1 inner join`b_user`as t2 on`t1`.`user_id`=`t2`.`id`where(t1.`friend_id`={})and(t1.`status`={}or t1.`status`={});
17510.43867194219852%select be.id as id,be.tags as tags,be.preview_text as preview_text,be.preview_picture as preview_picture,be.detail_picture as detail_picture,if(extract(hour_second from be.active_from)>{},date_format(be.active_from,{}),date_format(be.active_from,{}))as date_active_from,if(extract(hour_second from be.active_from)>{},date_format(be.active_from,{}),date_format(be.active_from,{}))as active_from,be.show_counter as show_counter,b.name as iblock_name,be.created_by as created_by,concat({},uc.login,{},ifnull(uc.name,{}),{},ifnull(uc.last_name,{}))as created_user_name,be.iblock_id as iblock_id,be.iblock_section_id as iblock_section_id,be.name as name,b.detail_page_url as detail_page_url,be.detail_text as detail_text,be.detail_text_type as detail_text_type,be.preview_text_type as preview_text_type,fps0.*,l.dir as lang_dir,be.sort as sort,be.code as code,be.xml_id as external_id,b.iblock_type_id as iblock_type_id,b.code as iblock_code,b.xml_id as iblock_external_id,b.lid as lid from b_iblock b inner join b_lang l on b.lid=l.lid inner join b_iblock_element be on be.iblock_id=b.id inner join b_iblock_element_prop_s1 fps0 on fps0.iblock_element_id=be.id inner join(select distinct b.id from b_iblock b inner join b_iblock_site bs on bs.iblock_id=b.id inner join b_iblock_group ibg on ibg.iblock_id=b.id where((((bs.site_id={}))))and((ibg.group_id in({})and ibg.permission>={}and(ibg.permission={}or b.active={})))and((((b.id={})))))bb on bb.id=be.iblock_id left join b_user uc on uc.id=be.created_by where{}={}and(((((be.iblock_id={}))))and((((be.active={}))))and((((fps0.property_8={})))))and(((be.wf_status_id={}and be.wf_parent_element_id is{})))order by be.active_from desc,be.sort asc,be.id desc limit{};
18190.16342680199553%select be.id as id,be.name as name,be.tags as tags,be.preview_text as preview_text,be.preview_picture as preview_picture,be.detail_picture as detail_picture,if(extract(hour_second from be.active_from)>{},date_format(be.active_from,{}),date_format(be.active_from,{}))as date_active_from,if(extract(hour_second from be.active_from)>{},date_format(be.active_from,{}),date_format(be.active_from,{}))as active_from,be.show_counter as show_counter,be.created_by as created_by,concat({},uc.login,{},ifnull(uc.name,{}),{},ifnull(uc.last_name,{}))as created_user_name,be.iblock_id as iblock_id,be.iblock_section_id as iblock_section_id,b.detail_page_url as detail_page_url,be.detail_text as detail_text,be.detail_text_type as detail_text_type,be.preview_text_type as preview_text_type,fps0.*,l.dir as lang_dir,be.sort as sort,be.code as code,be.xml_id as external_id,b.iblock_type_id as iblock_type_id,b.code as iblock_code,b.xml_id as iblock_external_id,b.lid as lid from b_iblock b inner join b_lang l on b.lid=l.lid inner join b_iblock_element be on be.iblock_id=b.id inner join b_iblock_element_prop_s1 fps0 on fps0.iblock_element_id=be.id inner join(select distinct b.id from b_iblock b inner join b_iblock_site bs on bs.iblock_id=b.id inner join b_iblock_group ibg on ibg.iblock_id=b.id where((((bs.site_id={}))))and((ibg.group_id in({})and ibg.permission>={}and(ibg.permission={}or b.active={})))and((((b.id={})))))bb on bb.id=be.iblock_id left join b_user uc on uc.id=be.created_by where{}={}and(((((be.iblock_id={}))))and((((be.active={})))))and(((be.wf_status_id={}and be.wf_parent_element_id is{})))order by be.active_from desc,be.sort asc,be.id desc limit{};
19180.15482539136418%select count({})as c from b_iblock b inner join b_lang l on b.lid=l.lid inner join b_iblock_element be on be.iblock_id=b.id inner join b_iblock_element_prop_s1 fps0 on fps0.iblock_element_id=be.id inner join(select distinct b.id from b_iblock b inner join b_iblock_site bs on bs.iblock_id=b.id inner join b_iblock_group ibg on ibg.iblock_id=b.id where((((bs.site_id={}))))and((ibg.group_id in({})and ibg.permission>={}and(ibg.permission={}or b.active={})))and((((b.id={})))))bb on bb.id=be.iblock_id left join b_user uc on uc.id=be.created_by where{}={}and(((((be.iblock_id={}))))and((((be.active={})))))and(((be.wf_status_id={}and be.wf_parent_element_id is{})));
2070.060209874419405%select be.id as id,be.preview_picture as preview_picture,be.name as name,concat({},uc.login,{},ifnull(uc.name,{}),{},ifnull(uc.last_name,{}))as created_user_name,if(extract(hour_second from be.active_from)>{},date_format(be.active_from,{}),date_format(be.active_from,{}))as date_active_from,be.tags as tags,be.show_counter as show_counter,be.detail_text as detail_text,be.iblock_section_id as iblock_section_id,fpv0.value as property_photo_author_value,fpv0.id as property_photo_author_value_id,fpv1.value as property_rayting_value,fpv1.id as property_rayting_value_id,fpv2.value as property_author_url_value,fpv2.id as property_author_url_value_id,fpv3.value as property_photo_author_url_value,fpv3.id as property_photo_author_url_value_id,fpv4.value as property_col_comments_value,fpv4.id as property_col_comments_value_id,be.detail_text_type as detail_text_type from b_iblock b inner join b_lang l on b.lid=l.lid inner join b_iblock_element be on be.iblock_id=b.id left join b_iblock_property fp0 on fp0.iblock_id=b.id and fp0.code={}left join b_iblock_property fp1 on fp1.iblock_id=b.id and fp1.code={}left join b_iblock_property fp2 on fp2.iblock_id=b.id and fp2.code={}left join b_iblock_property fp3 on fp3.iblock_id=b.id and fp3.code={}left join b_iblock_property fp4 on fp4.iblock_id=b.id and fp4.code={}left join b_iblock_element_property fpv0 on fpv0.iblock_property_id=fp0.id and fpv0.iblock_element_id=be.id left join b_iblock_element_property fpv1 on fpv1.iblock_property_id=fp1.id and fpv1.iblock_element_id=be.id left join b_iblock_element_property fpv2 on fpv2.iblock_property_id=fp2.id and fpv2.iblock_element_id=be.id left join b_iblock_element_property fpv3 on fpv3.iblock_property_id=fp3.id and fpv3.iblock_element_id=be.id left join b_iblock_element_property fpv4 on fpv4.iblock_property_id=fp4.id and fpv4.iblock_element_id=be.id inner join(select distinct bse.iblock_element_id from b_iblock_section_element bse inner join b_iblock_section bs on bse.iblock_section_id=bs.id where((bs.id in({}))))bes on bes.iblock_element_id=be.id left join b_user uc on uc.id=be.created_by where{}={}and(((((be.iblock_id={}))))and((((be.id={})))))and(((be.wf_status_id={}and be.wf_parent_element_id is{})))order by be.id asc limit{};
Total: 20 patterns