system/core/database.php => setTimezone()
SET `time_zone` = 'Asia/Dushanbe'
system/core/database.php => setTimezone()
SET `time_zone` = '+05:00'
system/core/controller.php => getFieldFiltered()
SELECT i.options as options
FROM cms_controllers i
WHERE (i.name = 'auth')
LIMIT 1
system/controllers/widgets/model.php => get()
SELECT i.*
FROM cms_widgets_pages i
LIMIT 1000
system/controllers/widgets/model.php => get()
SELECT i.*, w.controller as controller, w.name as name
FROM cms_widgets_bind i
JOIN cms_widgets as w ON w.id = i.widget_id
WHERE (i.page_id IN ('0'))
ORDER BY i.page_id, position, ordering
system/core/user.php => get()
SELECT i.*
FROM cms_sessions_online i
WHERE (i.date_created < DATE_SUB(NOW(), INTERVAL 3 MINUTE))
LIMIT 1000
system/core/model.php => getItem()
SELECT i.*
FROM cms_menu i
WHERE (i.name = 'footer')
LIMIT 1
system/controllers/menu/model.php => get()
SELECT i.*, COUNT(childs.id) as childs_count
FROM cms_menu_items i
LEFT JOIN cms_menu_items as childs ON childs.parent_id = i.id
WHERE (i.menu_id = '3')
GROUP BY i.id
ORDER BY i.ordering asc
system/controllers/tags/model.php => get()
SELECT i.*
FROM cms_tags i
ORDER BY i.tag asc
LIMIT 10
system/controllers/tags/model.php => getMax()
SELECT i.frequency as frequency
FROM cms_tags i
ORDER BY i.frequency DESC
LIMIT 1
system/core/model.php => getItem()
SELECT i.*
FROM cms_menu i
WHERE (i.name = 'toolbar')
LIMIT 1
system/controllers/menu/model.php => get()
SELECT i.*, COUNT(childs.id) as childs_count
FROM cms_menu_items i
LEFT JOIN cms_menu_items as childs ON childs.parent_id = i.id
WHERE (i.menu_id = '4')
GROUP BY i.id
ORDER BY i.ordering asc
system/core/model.php => getItem()
SELECT i.*
FROM cms_menu i
WHERE (i.name = 'header')
LIMIT 1
system/controllers/menu/model.php => get()
SELECT i.*, COUNT(childs.id) as childs_count
FROM cms_menu_items i
LEFT JOIN cms_menu_items as childs ON childs.parent_id = i.id
WHERE (i.menu_id = '5')
GROUP BY i.id
ORDER BY i.ordering asc
system/core/model.php => getItem()
SELECT i.*
FROM cms_menu i
WHERE (i.name = 'main')
LIMIT 1
system/controllers/menu/model.php => get()
SELECT i.*, COUNT(childs.id) as childs_count
FROM cms_menu_items i
LEFT JOIN cms_menu_items as childs ON childs.parent_id = i.id
WHERE (i.menu_id = '1')
GROUP BY i.id
ORDER BY i.ordering asc