ВНИМАНИЕ! Повторяющийся запрос – 2
select 1 from rdb$relation_fields f
where f.rdb$relation_name = 'NEWS'
and f.RDB$FIELD_NAME = 'VIEW_COUNT'
0.001 сек
select
bstart,
bend,
lesson,
(select smena from bells_ref where bells_ref.i_id = bells.tab_id) as smena
from
bells
where
tab_id in ( 1 )
order by
smena,
lesson
0.001 сек
SELECT c_id, 'content', c_type FROM content
WHERE
published = 1
and deleted = 0
AND permalink = ?
union
SELECT news_id, trim('news'), 0 FROM news WHERE
published = 1
and deleted = 0
AND permalink = ?
0.004 сек
select CONTENT from CUSTOM_BLOCK where OWNER = 6 and BLOCK_NUMBER = '1'
0.002 сек
select count(1)
from bells_ref
where use_informer = 1
and
days_of_week like '%,%,%,1,%,%,%'
0.002 сек
select first 1 1 from mainmenu where i_level > 1 and published = 1 and owner = 6
0.001 сек
select first 7 news_id,head,startdate,text from news where published = 1 and deleted = 0 and owner = '6' order by startdate DESC
0.001 сек
select * from news_comment where owner = '6' and n_id = '1624' order by date_cn
0.000 сек
select i_id
from bells_ref
where use_informer = 1
and
days_of_week like '%,%,%,1,%,%,%'
0.001 сек
select i_id, i_parent, i_name, i_link from mainmenu where published = 1 and owner = 6 order by i_sort
0.001 сек
SELECT modulename, modules_cnf_users.m_place, i_sort, modules_cnf_users.show_on
FROM modules, modules_cnf_users
WHERE modules_cnf_users.mod_id = modules.i_id and
modules_cnf_users.published = 1 and modules_cnf_users.owner = '6'
and modules.access like '%,6,%'
0.002 сек
select startdate, autor, head, c_id from content
where owner = 6
and published = 1
and deleted = 0
and c_type = 1 and startdate>current_date-7
order by startdate DESC
0.001 сек
select t_name from themes where owner = 6
0.001 сек
select 1 from RDB$RELATIONS where RDB$RELATION_NAME = 'SELF_PROPERTY'
0.001 сек
select 1 from RDB$RELATIONS where RDB$RELATION_NAME = 'SELF_PROPERTY'
0.004 сек
select last_name, first_name, middle_name from human where human_id = '108101617'
0.004 сек
select name, property_value from self_property where NAME in ('SP_URL_PD_AGREEMENT', 'SP_URL_CONFIDENTIAL_POLICY')
0.001 сек
select PROPERTY_VALUE from SELF_PROPERTY where name='ORGANIZATION_NAME'
0.001 сек
select property_value from self_property where NAME = 'POST_ADDRESS'
0.001 сек
select property_value from self_property where name = 'SHORT_ORG_NAME'
0.002 сек