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 = 'users')
LIMIT 1
system/core/model.php => getItem()
SELECT i.*, IFNULL(c.name, '') as city_name, IFNULL(c.id, 0) as city_id, u.nickname as inviter_nickname
FROM cms_users i
LEFT JOIN cms_geo_cities as c ON c.id = i.city
LEFT JOIN cms_users as u ON u.id = i.inviter_id
WHERE (i.id = '20796')
LIMIT 1
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/controller.php => getFieldFiltered()
SELECT i.options as options
FROM cms_controllers i
WHERE (i.name = 'messages')
LIMIT 1
system/controllers/users/model.php => getCount()
SELECT COUNT(i.id) as count
FROM cms_users_friends i
WHERE (i.user_id = '0') AND (i.friend_id = '20796') AND (i.is_mutual = '0')
system/controllers/content/model.php => get()
SELECT i.*
FROM cms_users_fields i
ORDER BY i.ordering
LIMIT 1000
system/controllers/users/model.php => get()
SELECT i.*, u.id as id, u.*
FROM cms_users_friends i
INNER JOIN cms_users as u ON u.id = i.friend_id
WHERE (i.user_id = '20796') AND (i.is_mutual = '1')
ORDER BY u.date_log desc
system/controllers/content/model.php => get()
SELECT i.*
FROM cms_content_types i
LIMIT 1000
system/controllers/content/model.php => getCount()
SELECT COUNT(i.id) as count
FROM cms_con_pages i
WHERE (i.user_id = '20796') AND ((i.is_private = 0 OR i.user_id = 0 OR (i.is_private = 1 AND EXISTS (SELECT id FROM cms_users_friends WHERE user_id=0 AND friend_id=i.user_id AND is_mutual=1)))) AND (i.is_approved = '1')
system/controllers/content/model.php => getCount()
SELECT COUNT(i.id) as count
FROM cms_con_posts i
WHERE (i.user_id = '20796') AND ((i.is_private = 0 OR i.user_id = 0 OR (i.is_private = 1 AND EXISTS (SELECT id FROM cms_users_friends WHERE user_id=0 AND friend_id=i.user_id AND is_mutual=1)))) AND (i.is_approved = '1')
system/controllers/content/model.php => getCount()
SELECT COUNT(i.id) as count
FROM cms_con_news i
WHERE (i.user_id = '20796') AND ((i.is_private = 0 OR i.user_id = 0 OR (i.is_private = 1 AND EXISTS (SELECT id FROM cms_users_friends WHERE user_id=0 AND friend_id=i.user_id AND is_mutual=1)))) AND (i.is_approved = '1')
system/controllers/content/model.php => getCount()
SELECT COUNT(i.id) as count
FROM cms_con_debati i
WHERE (i.user_id = '20796') AND ((i.is_private = 0 OR i.user_id = 0 OR (i.is_private = 1 AND EXISTS (SELECT id FROM cms_users_friends WHERE user_id=0 AND friend_id=i.user_id AND is_mutual=1)))) AND (i.is_approved = '1')
system/controllers/wall/model.php => getCount()
SELECT COUNT(i.id) as count
FROM cms_wall_entries i
WHERE (i.profile_id = '20796') AND (i.profile_type = 'user') AND (i.parent_id = '0')
system/controllers/wall/model.php => get()
SELECT i.*, COUNT(e.id) as replies_count, u.nickname as user_nickname, u.avatar as user_avatar
FROM cms_wall_entries i
LEFT JOIN cms_wall_entries as e ON e.parent_id = i.id
JOIN cms_users as u ON u.id = i.user_id
WHERE (i.profile_id = '20796') AND (i.profile_type = 'user') AND (i.parent_id = '0')
GROUP BY i.id
ORDER BY i.date_pub desc
LIMIT 0, 10
system/core/controller.php => getFieldFiltered()
SELECT i.options as options
FROM cms_controllers i
WHERE (i.name = 'markitup')
LIMIT 1
system/controllers/users/model.php => get()
SELECT i.*
FROM cms_users_tabs i
WHERE (i.is_active = '1')
ORDER BY i.ordering
system/controllers/users/model.php => getCount()
SELECT COUNT(i.id) as count
FROM cms_users_friends i
WHERE (i.user_id = '20796') AND (i.is_mutual = '1')
system/core/controller.php => getFieldFiltered()
SELECT i.options as options
FROM cms_controllers i
WHERE (i.name = 'groups')
LIMIT 1
system/controllers/groups/model.php => getCount()
SELECT COUNT(i.id) as count
FROM cms_groups i
JOIN cms_groups_members as m ON i.id = m.group_id AND m.user_id = '20796'
system/controllers/comments/model.php => getCount()
SELECT COUNT(i.id) as count
FROM cms_comments i
WHERE (i.user_id = '20796') AND (i.is_deleted IS NULL)
system/controllers/groups/model.php => get()
SELECT i.*
FROM cms_groups_members i
WHERE (i.user_id = '0')
LIMIT 1000
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','101'))
ORDER BY i.page_id, position, ordering
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
0
