| SELECT * FROM `sys_sessions` WHERE `id`=:id LIMIT 1 | 0.0293 sec | 1 | 1 | 17 |
| UPDATE `sys_sessions` SET `date`=UNIX_TIMESTAMP() WHERE `id`=:id | 0.0025 sec | 0 | 0 | 1 |
| SELECT `date` FROM `sys_sessions` WHERE `id` = :id AND `data` = :data AND `user_id` = :user_id AND `ttl` = :ttl AND `date` > UNIX_TIMESTAMP() - 30 | 0.0032 sec | 1 | 1 | 17 |
| SELECT `uri`, `param_name`, `param_value` FROM `sys_seo_links` WHERE `uri` = 'jethro' AND `module` = :module AND `page_uri` = :page_uri | 0.0236 sec | 1 | 1 | 17 |
| SELECT * FROM `sys_profiles` WHERE `id` = ? LIMIT 1 | 0.0144 sec | 1 | 1 | 16 |
| SELECT `id` FROM `sys_modules` WHERE `name`=? AND `enabled`='1' LIMIT 1 | 0.0023 sec | 1 | 1 | 16 |
| SELECT `c`.*, `p`.`account_id`, `p`.`id` AS `profile_id`, `a`.`email` AS `profile_email`, `a`.`active` AS `profile_last_active`, `a`.`ip` AS `profile_ip`, `p`.`status` AS `profile_status` FROM `bx_persons_data` AS `c` INNER JOIN `sys_profiles` AS `p` ON (`p`.`content_id` = `c`.`id` AND `p`.`type` = :type) INNER JOIN `sys_accounts` AS `a` ON (`p`.`account_id` = `a`.`id`) WHERE `c`.`id` = :id | 0.023 sec | 1 | 1 | 35 |
| SELECT
`taa`.`ID` AS `id`,
`taa`.`Module` AS `module`,
`taa`.`Name` AS `name`,
`taa`.`Title` AS `title`,
`taa`.`Countable` AS `countable`,
`taa`.`DisabledForLevels` AS `disabled_for_levels`
FROM `sys_acl_actions` AS `taa`
WHERE 1 AND `taa`.`Name` IN('edit any entry') AND `taa`.`Module` = :module ORDER BY `taa`.`Title` ASC | 0.005 sec | 1 | 1 | 17 |
| SELECT
`tam`.`IDAction` AS `id`,
`taa`.`Name` AS `name`,
`taa`.`Title` AS `title`,
`tam`.`AllowedCount` AS `allowed_count`,
`tam`.`AllowedPeriodLen` AS `allowed_period_len`,
UNIX_TIMESTAMP(`tam`.`AllowedPeriodStart`) as `allowed_period_start`,
UNIX_TIMESTAMP(`tam`.`AllowedPeriodEnd`) as `allowed_period_end`,
`tam`.`AdditionalParamValue` AS `additional_param_value`
FROM `sys_acl_actions` AS `taa`
LEFT JOIN `sys_acl_matrix` AS `tam` ON `tam`.`IDAction` = `taa`.`ID` AND `tam`.`IDLevel` = ?
WHERE `taa`.`ID` = ? | 0.0004 sec | 1 | 1 | 17 |
| SELECT `id` FROM `sys_accounts` WHERE `id` = ? LIMIT 1 | 0.0061 sec | 1 | 1 | 16 |
| SELECT * FROM `sys_accounts` WHERE `id` = ? LIMIT 1 | 0.0002 sec | 1 | 1 | 17 |
| SELECT * FROM `msolutions_usernames_usernames` WHERE `profile_id` = ? LIMIT 1 | 0.0148 sec | 1 | 1 | 16 |
| SELECT * FROM `sys_profiles` WHERE `content_id` = ? AND `type` = ? | 0.0092 sec | 1 | 1 | 16 |
| SELECT * FROM `sys_profiles_conn_friends` WHERE `initiator` = ? AND `content` = ? | 0.0088 sec | 0 | 0 | 16 |
| SELECT * FROM `sys_profiles_conn_friends` WHERE `initiator` = ? AND `content` = ? | 0.0051 sec | 0 | 0 | 16 |
| SELECT
`taa`.`ID` AS `id`,
`taa`.`Module` AS `module`,
`taa`.`Name` AS `name`,
`taa`.`Title` AS `title`,
`taa`.`Countable` AS `countable`,
`taa`.`DisabledForLevels` AS `disabled_for_levels`
FROM `sys_acl_actions` AS `taa`
WHERE 1 AND `taa`.`Name` IN('change badge') AND `taa`.`Module` = :module ORDER BY `taa`.`Title` ASC | 0.0089 sec | 1 | 1 | 17 |
|
SELECT `sys_acl_levels_members`.`IDLevel` as `id`,
`sys_acl_levels`.`Name` AS `name`,
`sys_acl_levels`.`QuotaSize` AS `quota_size`,
`sys_acl_levels`.`QuotaNumber` AS `quota_number`,
`sys_acl_levels`.`QuotaMaxFileSize` AS `quota_max_file_size`,
`sys_acl_levels`.`PasswordExpired` AS `password_expired`,
UNIX_TIMESTAMP(`sys_acl_levels_members`.`DateStarts`) as `date_starts`,
UNIX_TIMESTAMP(`sys_acl_levels_members`.`DateExpires`) as `date_expires`,
`sys_acl_levels_members`.`State` AS `state`,
`sys_acl_levels_members`.`TransactionID` AS `transaction_id`,
`sys_profiles`.`status`
FROM `sys_acl_levels_members`
RIGHT JOIN `sys_profiles` ON `sys_acl_levels_members`.IDMember = `sys_profiles`.`id`
AND (`sys_acl_levels_members`.DateStarts IS NULL OR `sys_acl_levels_members`.DateStarts <= FROM_UNIXTIME(?))
AND (`sys_acl_levels_members`.DateExpires IS NULL OR `sys_acl_levels_members`.DateExpires > FROM_UNIXTIME(?))
LEFT JOIN `sys_acl_levels` ON `sys_acl_levels_members`.IDLevel = `sys_acl_levels`.ID
WHERE `sys_profiles`.`id` = ?
ORDER BY `sys_acl_levels_members`.DateStarts DESC
LIMIT 1 | 0.0075 sec | 1 | 1 | 18 |
|
SELECT `sys_acl_levels_members`.`IDLevel` as `id`,
`sys_acl_levels`.`Name` AS `name`,
`sys_acl_levels`.`QuotaSize` AS `quota_size`,
`sys_acl_levels`.`QuotaNumber` AS `quota_number`,
`sys_acl_levels`.`QuotaMaxFileSize` AS `quota_max_file_size`,
`sys_acl_levels`.`PasswordExpired` AS `password_expired`,
UNIX_TIMESTAMP(`sys_acl_levels_members`.`DateStarts`) as `date_starts`,
UNIX_TIMESTAMP(`sys_acl_levels_members`.`DateExpires`) as `date_expires`,
`sys_acl_levels_members`.`State` AS `state`,
`sys_acl_levels_members`.`TransactionID` AS `transaction_id`,
`sys_profiles`.`status`
FROM `sys_acl_levels_members`
RIGHT JOIN `sys_profiles` ON `sys_acl_levels_members`.IDMember = `sys_profiles`.`id`
AND (`sys_acl_levels_members`.DateStarts IS NULL OR `sys_acl_levels_members`.DateStarts <= FROM_UNIXTIME(?))
AND (`sys_acl_levels_members`.DateExpires IS NULL OR `sys_acl_levels_members`.DateExpires > FROM_UNIXTIME(?))
LEFT JOIN `sys_acl_levels` ON `sys_acl_levels_members`.IDLevel = `sys_acl_levels`.ID
WHERE `sys_profiles`.`id` = ?
ORDER BY `sys_acl_levels_members`.DateStarts DESC
LIMIT 1 | 0.0075 sec | 1 | 1 | 18 |
| SELECT
`tam`.`IDAction` AS `id`,
`taa`.`Name` AS `name`,
`taa`.`Title` AS `title`,
`tam`.`AllowedCount` AS `allowed_count`,
`tam`.`AllowedPeriodLen` AS `allowed_period_len`,
UNIX_TIMESTAMP(`tam`.`AllowedPeriodStart`) as `allowed_period_start`,
UNIX_TIMESTAMP(`tam`.`AllowedPeriodEnd`) as `allowed_period_end`,
`tam`.`AdditionalParamValue` AS `additional_param_value`
FROM `sys_acl_actions` AS `taa`
LEFT JOIN `sys_acl_matrix` AS `tam` ON `tam`.`IDAction` = `taa`.`ID` AND `tam`.`IDLevel` = ?
WHERE `taa`.`ID` = ? | 0.01 sec | 1 | 1 | 17 |
| SELECT `id` AS `id`, `author` AS `owner_id`, `allow_view_to` AS `group_id` FROM `bx_persons_data` WHERE `id`=? LIMIT 1 | 0.0056 sec | 1 | 1 | 16 |
| SELECT
`taa`.`ID` AS `id`,
`taa`.`Module` AS `module`,
`taa`.`Name` AS `name`,
`taa`.`Title` AS `title`,
`taa`.`Countable` AS `countable`,
`taa`.`DisabledForLevels` AS `disabled_for_levels`
FROM `sys_acl_actions` AS `taa`
WHERE 1 AND `taa`.`Name` IN('view entry') AND `taa`.`Module` = :module ORDER BY `taa`.`Title` ASC | 0.0108 sec | 1 | 1 | 17 |
| SELECT
`tam`.`IDAction` AS `id`,
`taa`.`Name` AS `name`,
`taa`.`Title` AS `title`,
`tam`.`AllowedCount` AS `allowed_count`,
`tam`.`AllowedPeriodLen` AS `allowed_period_len`,
UNIX_TIMESTAMP(`tam`.`AllowedPeriodStart`) as `allowed_period_start`,
UNIX_TIMESTAMP(`tam`.`AllowedPeriodEnd`) as `allowed_period_end`,
`tam`.`AdditionalParamValue` AS `additional_param_value`
FROM `sys_acl_actions` AS `taa`
LEFT JOIN `sys_acl_matrix` AS `tam` ON `tam`.`IDAction` = `taa`.`ID` AND `tam`.`IDLevel` = ?
WHERE `taa`.`ID` = ? | 0.0097 sec | 1 | 1 | 17 |
| SELECT * FROM `msolutions_usernames_usernames` WHERE `profile_id` = ? LIMIT 1 | 0.0177 sec | 1 | 1 | 16 |
| SELECT * FROM `sys_objects_transcoder` WHERE `object` = ? | 0.0061 sec | 1 | 1 | 16 |
| SELECT * FROM `bx_persons_pictures` WHERE `id` = ? | 0.0056 sec | 1 | 1 | 16 |
| SELECT `mime_type` FROM `sys_storage_mime_types` WHERE `ext` = ? | 0.0028 sec | 1 | 1 | 16 |
| SELECT `file_id` FROM `sys_transcoder_images_files` WHERE `transcoder_object` = ? AND `handler` = ? LIMIT 1 | 0.0003 sec | 1 | 1 | 16 |
| SELECT * FROM `bx_persons_pictures_resized` WHERE `id` = ? | 0.0004 sec | 1 | 1 | 16 |
| SELECT * FROM `bx_persons_pictures` WHERE `id` = ? | 0.0023 sec | 1 | 1 | 16 |
| SELECT `file_id` FROM `sys_transcoder_images_files` WHERE `transcoder_object` = ? AND `handler` = ? LIMIT 1 | 0.0028 sec | 1 | 1 | 16 |
| SELECT * FROM `bx_persons_pictures_resized` WHERE `id` = ? | 0.0086 sec | 1 | 1 | 16 |
| SELECT `atime` FROM `sys_transcoder_images_files` WHERE `transcoder_object` = :obj AND `handler` = :hndl AND `atime` > :ts LIMIT 1 | 0.0057 sec | 1 | 1 | 17 |
| SELECT * FROM `bx_persons_pictures_resized` WHERE `id` = ? | 0.0061 sec | 1 | 1 | 17 |
| SELECT * FROM `sys_objects_transcoder` WHERE `object` = ? | 0.0005 sec | 1 | 1 | 16 |
| SELECT * FROM `bx_persons_pictures` WHERE `id` = ? | 0.0051 sec | 1 | 1 | 16 |
| SELECT `mime_type` FROM `sys_storage_mime_types` WHERE `ext` = ? | 0.0067 sec | 1 | 1 | 16 |
| SELECT `file_id` FROM `sys_transcoder_images_files` WHERE `transcoder_object` = ? AND `handler` = ? LIMIT 1 | 0.0039 sec | 1 | 1 | 16 |
| SELECT * FROM `bx_persons_pictures_resized` WHERE `id` = ? | 0.0002 sec | 1 | 1 | 16 |
| SELECT * FROM `bx_persons_pictures` WHERE `id` = ? | 0.0043 sec | 1 | 1 | 16 |
| SELECT `file_id` FROM `sys_transcoder_images_files` WHERE `transcoder_object` = ? AND `handler` = ? LIMIT 1 | 0.0003 sec | 1 | 1 | 16 |
| SELECT * FROM `bx_persons_pictures_resized` WHERE `id` = ? | 0.002 sec | 1 | 1 | 16 |
| SELECT `atime` FROM `sys_transcoder_images_files` WHERE `transcoder_object` = :obj AND `handler` = :hndl AND `atime` > :ts LIMIT 1 | 0.008 sec | 1 | 1 | 17 |
| SELECT * FROM `bx_persons_pictures_resized` WHERE `id` = ? | 0.0073 sec | 1 | 1 | 16 |
| SELECT * FROM `sys_objects_transcoder` WHERE `object` = ? | 0.0092 sec | 1 | 1 | 16 |
| SELECT * FROM `bx_persons_pictures` WHERE `id` = ? | 0.0023 sec | 1 | 1 | 16 |
| SELECT `mime_type` FROM `sys_storage_mime_types` WHERE `ext` = ? | 0.0005 sec | 1 | 1 | 16 |
| SELECT `file_id` FROM `sys_transcoder_images_files` WHERE `transcoder_object` = ? AND `handler` = ? LIMIT 1 | 0.0004 sec | 1 | 1 | 16 |
| SELECT * FROM `bx_persons_pictures_resized` WHERE `id` = ? | 0.0003 sec | 1 | 1 | 16 |
| SELECT * FROM `bx_persons_pictures` WHERE `id` = ? | 0.0008 sec | 1 | 1 | 16 |
| SELECT `file_id` FROM `sys_transcoder_images_files` WHERE `transcoder_object` = ? AND `handler` = ? LIMIT 1 | 0.0003 sec | 1 | 1 | 16 |
| SELECT * FROM `bx_persons_pictures_resized` WHERE `id` = ? | 0.0005 sec | 1 | 1 | 16 |
| SELECT `atime` FROM `sys_transcoder_images_files` WHERE `transcoder_object` = :obj AND `handler` = :hndl AND `atime` > :ts LIMIT 1 | 0.0004 sec | 1 | 1 | 17 |
| SELECT * FROM `bx_persons_pictures_resized` WHERE `id` = ? | 0.0004 sec | 1 | 1 | 16 |
| SELECT `uri`, `param_name`, `param_value` FROM `sys_seo_links` WHERE `param_value` = '4' AND `module` = :module AND `page_uri` = :page_uri | 0.0004 sec | 1 | 1 | 17 |
| SELECT
`tp`.`id`
FROM `sys_profiles` AS `tp`
INNER JOIN `sys_accounts` AS `ta` ON `tp`.`account_id`=`ta`.`id`
INNER JOIN `sys_sessions` AS `ts` ON `tp`.`account_id`=`ts`.`user_id`
WHERE
`tp`.`id` = ? AND
`ta`.`profile_id`=`tp`.`id` AND
`ts`.`date` > (UNIX_TIMESTAMP() - 60 * ?)
LIMIT 1 | 0.0004 sec | 0 | 0 | 16 |
| SELECT * FROM `msolutions_usernames_usernames` WHERE `profile_id` = ? LIMIT 1 | 0.0003 sec | 1 | 1 | 16 |
| SELECT `c`.*, `p`.`account_id`, `p`.`id` AS `profile_id`, `a`.`email` AS `profile_email`, `a`.`active` AS `profile_last_active`, `a`.`ip` AS `profile_ip`, `p`.`status` AS `profile_status` FROM `bx_persons_data` AS `c` INNER JOIN `sys_profiles` AS `p` ON (`p`.`content_id` = `c`.`id` AND `p`.`type` = :type) INNER JOIN `sys_accounts` AS `a` ON (`p`.`account_id` = `a`.`id`) WHERE `c`.`id` = :id | 0.0004 sec | 0 | 0 | 19 |
| SELECT 1 FROM `sys_menu_items` WHERE `set_name` = ? AND `parent_id` != '0' LIMIT 1 | 0.0028 sec | 0 | 0 | 16 |
| SELECT * FROM `sys_menu_items` WHERE 1 AND `set_name` = :set_name ORDER BY `order` ASC | 0.0012 sec | 24 | 24 | 18 |
| SELECT
`taa`.`ID` AS `id`,
`taa`.`Module` AS `module`,
`taa`.`Name` AS `name`,
`taa`.`Title` AS `title`,
`taa`.`Countable` AS `countable`,
`taa`.`DisabledForLevels` AS `disabled_for_levels`
FROM `sys_acl_actions` AS `taa`
WHERE 1 AND `taa`.`Name` IN('set acl level') AND `taa`.`Module` = :module ORDER BY `taa`.`Title` ASC | 0.0008 sec | 1 | 1 | 17 |
| SELECT
`tam`.`IDAction` AS `id`,
`taa`.`Name` AS `name`,
`taa`.`Title` AS `title`,
`tam`.`AllowedCount` AS `allowed_count`,
`tam`.`AllowedPeriodLen` AS `allowed_period_len`,
UNIX_TIMESTAMP(`tam`.`AllowedPeriodStart`) as `allowed_period_start`,
UNIX_TIMESTAMP(`tam`.`AllowedPeriodEnd`) as `allowed_period_end`,
`tam`.`AdditionalParamValue` AS `additional_param_value`
FROM `sys_acl_actions` AS `taa`
LEFT JOIN `sys_acl_matrix` AS `tam` ON `tam`.`IDAction` = `taa`.`ID` AND `tam`.`IDLevel` = ?
WHERE `taa`.`ID` = ? | 0.011 sec | 1 | 1 | 17 |
| SELECT `count` as `count`, `sum` as `sum`, ROUND(`sum` / `count`, 2) AS `rate` FROM bx_persons_votes WHERE `object_id` = ? LIMIT 1 | 0.0015 sec | 0 | 0 | 16 |
| SELECT
`taa`.`ID` AS `id`,
`taa`.`Module` AS `module`,
`taa`.`Name` AS `name`,
`taa`.`Title` AS `title`,
`taa`.`Countable` AS `countable`,
`taa`.`DisabledForLevels` AS `disabled_for_levels`
FROM `sys_acl_actions` AS `taa`
WHERE 1 AND `taa`.`Name` IN('vote') AND `taa`.`Module` = :module ORDER BY `taa`.`Title` ASC | 0.001 sec | 1 | 1 | 17 |
| SELECT
`tam`.`IDAction` AS `id`,
`taa`.`Name` AS `name`,
`taa`.`Title` AS `title`,
`tam`.`AllowedCount` AS `allowed_count`,
`tam`.`AllowedPeriodLen` AS `allowed_period_len`,
UNIX_TIMESTAMP(`tam`.`AllowedPeriodStart`) as `allowed_period_start`,
UNIX_TIMESTAMP(`tam`.`AllowedPeriodEnd`) as `allowed_period_end`,
`tam`.`AdditionalParamValue` AS `additional_param_value`
FROM `sys_acl_actions` AS `taa`
LEFT JOIN `sys_acl_matrix` AS `tam` ON `tam`.`IDAction` = `taa`.`ID` AND `tam`.`IDLevel` = ?
WHERE `taa`.`ID` = ? | 0.0064 sec | 1 | 1 | 17 |
| SELECT
`taa`.`ID` AS `id`,
`taa`.`Module` AS `module`,
`taa`.`Name` AS `name`,
`taa`.`Title` AS `title`,
`taa`.`Countable` AS `countable`,
`taa`.`DisabledForLevels` AS `disabled_for_levels`
FROM `sys_acl_actions` AS `taa`
WHERE 1 AND `taa`.`Name` IN('vote_view') AND `taa`.`Module` = :module ORDER BY `taa`.`Title` ASC | 0.0011 sec | 1 | 1 | 23 |
| SELECT
`tam`.`IDAction` AS `id`,
`taa`.`Name` AS `name`,
`taa`.`Title` AS `title`,
`tam`.`AllowedCount` AS `allowed_count`,
`tam`.`AllowedPeriodLen` AS `allowed_period_len`,
UNIX_TIMESTAMP(`tam`.`AllowedPeriodStart`) as `allowed_period_start`,
UNIX_TIMESTAMP(`tam`.`AllowedPeriodEnd`) as `allowed_period_end`,
`tam`.`AdditionalParamValue` AS `additional_param_value`
FROM `sys_acl_actions` AS `taa`
LEFT JOIN `sys_acl_matrix` AS `tam` ON `tam`.`IDAction` = `taa`.`ID` AND `tam`.`IDLevel` = ?
WHERE `taa`.`ID` = ? | 0.0004 sec | 1 | 1 | 17 |
| SELECT `object_id` FROM `bx_persons_votes_track` WHERE `object_id` = ? AND `author_id` = ? LIMIT 1 | 0.0126 sec | 0 | 0 | 16 |
| SELECT COUNT(DISTINCT `author_id`) AS `count` FROM `bx_persons_favorites_track` WHERE `object_id`=:object_id LIMIT 1 | 0.0093 sec | 1 | 1 | 17 |
| SELECT
`taa`.`ID` AS `id`,
`taa`.`Module` AS `module`,
`taa`.`Name` AS `name`,
`taa`.`Title` AS `title`,
`taa`.`Countable` AS `countable`,
`taa`.`DisabledForLevels` AS `disabled_for_levels`
FROM `sys_acl_actions` AS `taa`
WHERE 1 AND `taa`.`Name` IN('favorite') AND `taa`.`Module` = :module ORDER BY `taa`.`Title` ASC | 0.0006 sec | 1 | 1 | 17 |
| SELECT
`tam`.`IDAction` AS `id`,
`taa`.`Name` AS `name`,
`taa`.`Title` AS `title`,
`tam`.`AllowedCount` AS `allowed_count`,
`tam`.`AllowedPeriodLen` AS `allowed_period_len`,
UNIX_TIMESTAMP(`tam`.`AllowedPeriodStart`) as `allowed_period_start`,
UNIX_TIMESTAMP(`tam`.`AllowedPeriodEnd`) as `allowed_period_end`,
`tam`.`AdditionalParamValue` AS `additional_param_value`
FROM `sys_acl_actions` AS `taa`
LEFT JOIN `sys_acl_matrix` AS `tam` ON `tam`.`IDAction` = `taa`.`ID` AND `tam`.`IDLevel` = ?
WHERE `taa`.`ID` = ? | 0.0112 sec | 1 | 1 | 17 |
| SELECT `featured` FROM `bx_persons_data` WHERE `id` = ? LIMIT 1 | 0.0006 sec | 1 | 1 | 16 |
| SELECT
`taa`.`ID` AS `id`,
`taa`.`Module` AS `module`,
`taa`.`Name` AS `name`,
`taa`.`Title` AS `title`,
`taa`.`Countable` AS `countable`,
`taa`.`DisabledForLevels` AS `disabled_for_levels`
FROM `sys_acl_actions` AS `taa`
WHERE 1 AND `taa`.`Name` IN('feature') AND `taa`.`Module` = :module ORDER BY `taa`.`Title` ASC | 0.0108 sec | 1 | 1 | 17 |
| SELECT
`tam`.`IDAction` AS `id`,
`taa`.`Name` AS `name`,
`taa`.`Title` AS `title`,
`tam`.`AllowedCount` AS `allowed_count`,
`tam`.`AllowedPeriodLen` AS `allowed_period_len`,
UNIX_TIMESTAMP(`tam`.`AllowedPeriodStart`) as `allowed_period_start`,
UNIX_TIMESTAMP(`tam`.`AllowedPeriodEnd`) as `allowed_period_end`,
`tam`.`AdditionalParamValue` AS `additional_param_value`
FROM `sys_acl_actions` AS `taa`
LEFT JOIN `sys_acl_matrix` AS `tam` ON `tam`.`IDAction` = `taa`.`ID` AND `tam`.`IDLevel` = ?
WHERE `taa`.`ID` = ? | 0.0048 sec | 1 | 1 | 17 |
| SELECT
`taa`.`ID` AS `id`,
`taa`.`Module` AS `module`,
`taa`.`Name` AS `name`,
`taa`.`Title` AS `title`,
`taa`.`Countable` AS `countable`,
`taa`.`DisabledForLevels` AS `disabled_for_levels`
FROM `sys_acl_actions` AS `taa`
WHERE 1 AND `taa`.`Name` IN('report_view') AND `taa`.`Module` = :module ORDER BY `taa`.`Title` ASC | 0.0027 sec | 1 | 1 | 17 |
| SELECT
`tam`.`IDAction` AS `id`,
`taa`.`Name` AS `name`,
`taa`.`Title` AS `title`,
`tam`.`AllowedCount` AS `allowed_count`,
`tam`.`AllowedPeriodLen` AS `allowed_period_len`,
UNIX_TIMESTAMP(`tam`.`AllowedPeriodStart`) as `allowed_period_start`,
UNIX_TIMESTAMP(`tam`.`AllowedPeriodEnd`) as `allowed_period_end`,
`tam`.`AdditionalParamValue` AS `additional_param_value`
FROM `sys_acl_actions` AS `taa`
LEFT JOIN `sys_acl_matrix` AS `tam` ON `tam`.`IDAction` = `taa`.`ID` AND `tam`.`IDLevel` = ?
WHERE `taa`.`ID` = ? | 0.0029 sec | 1 | 1 | 17 |
| SELECT `count` as `count` FROM bx_persons_reports WHERE `object_id` = ? LIMIT 1 | 0.0012 sec | 0 | 0 | 16 |
| SELECT
`taa`.`ID` AS `id`,
`taa`.`Module` AS `module`,
`taa`.`Name` AS `name`,
`taa`.`Title` AS `title`,
`taa`.`Countable` AS `countable`,
`taa`.`DisabledForLevels` AS `disabled_for_levels`
FROM `sys_acl_actions` AS `taa`
WHERE 1 AND `taa`.`Name` IN('report') AND `taa`.`Module` = :module ORDER BY `taa`.`Title` ASC | 0.011 sec | 1 | 1 | 17 |
| SELECT
`tam`.`IDAction` AS `id`,
`taa`.`Name` AS `name`,
`taa`.`Title` AS `title`,
`tam`.`AllowedCount` AS `allowed_count`,
`tam`.`AllowedPeriodLen` AS `allowed_period_len`,
UNIX_TIMESTAMP(`tam`.`AllowedPeriodStart`) as `allowed_period_start`,
UNIX_TIMESTAMP(`tam`.`AllowedPeriodEnd`) as `allowed_period_end`,
`tam`.`AdditionalParamValue` AS `additional_param_value`
FROM `sys_acl_actions` AS `taa`
LEFT JOIN `sys_acl_matrix` AS `tam` ON `tam`.`IDAction` = `taa`.`ID` AND `tam`.`IDLevel` = ?
WHERE `taa`.`ID` = ? | 0.0008 sec | 1 | 1 | 17 |
| SELECT `menu_item_name`, IF(`active`, `menu_item_eval`, 'return \' \';') AS `menu_item_eval` FROM `aqb_advanced_menu_items` | 0.0085 sec | 17 | 17 | 16 |
| SELECT 1 FROM `sys_menu_items` WHERE `set_name` = ? AND `parent_id` != '0' LIMIT 1 | 0.0009 sec | 0 | 0 | 16 |
| SELECT * FROM `sys_menu_items` WHERE 1 AND `set_name` = :set_name ORDER BY `order` ASC | 0.0008 sec | 10 | 10 | 18 |
| SELECT
`tal`.`ID` AS `id`,
`tal`.`Name` AS `name`,
`tal`.`Icon` AS `icon`,
`tal`.`Description` AS `description`,
`tal`.`Active` AS `active`,
`tal`.`Purchasable` AS `purchasable`,
`tal`.`Removable` AS `removable`,
`tal`.`QuotaSize` AS `quota_size`,
`tal`.`QuotaNumber` AS `quota_number`,
`tal`.`QuotaMaxFileSize` AS `quota_max_file_size`,
`tal`.`PasswordExpired` AS `password_expired`,
`tal`.`PasswordExpiredNotify` AS `password_expired_notify`,
`tal`.`Order` AS `order`
FROM `sys_acl_levels` AS `tal`
WHERE 1 AND `tal`.`ID`=:id ORDER BY `tal`.`Order` ASC LIMIT 1 | 0.0002 sec | 1 | 1 | 18 |
| SELECT `sc`.`id`, `sc`.`id`, `sc`.`text`, `sc`.`color`, `sc`.`fontcolor`, `sc`.`is_icon_only`, `sc`.`icon`, `soc`.`id` AS `badge_id`
FROM `sys_badges` AS `sc`INNER JOIN `sys_badges2objects` `soc` ON `sc`.`id` = `soc`.`badge_id` AND `soc`.`object_id` = :object_id
WHERE 1 AND `sc`.`module` = :module ORDER BY `sc`.`added` ASC | 0.0002 sec | 0 | 0 | 17 |
| SELECT COUNT(`c`.`id`) FROM `sys_profiles_conn_friends` AS `c` INNER JOIN `sys_profiles` `p` ON `p`.`id` = `c`.`initiator` AND `p`.`status` = 'active' WHERE 1 AND `c`.`content` = 9 AND `c`.`mutual` = '1' | 0.0002 sec | 1 | 1 | 16 |
| SELECT COUNT(`c`.`id`) FROM `sys_profiles_conn_subscriptions` AS `c` INNER JOIN `sys_profiles` `p` ON `p`.`id` = `c`.`initiator` AND `p`.`status` = 'active' WHERE 1 AND `c`.`content` = 9 | 0.0002 sec | 1 | 1 | 16 |
| SELECT `c`.`initiator` FROM `sys_profiles_conn_subscriptions` AS `c` INNER JOIN `sys_profiles` `p` ON `p`.`id` = `c`.`initiator` AND `p`.`status` = 'active' WHERE 1 AND `c`.`content` = :content LIMIT 0, 5 | 0.0002 sec | 1 | 1 | 17 |
| SELECT * FROM `sys_profiles` WHERE `id` = ? LIMIT 1 | 0.0001 sec | 1 | 1 | 16 |
| SELECT `id` FROM `sys_modules` WHERE `name`=? AND `enabled`='1' LIMIT 1 | 0.0001 sec | 1 | 1 | 16 |
| SELECT `id` FROM `sys_modules` WHERE `name`=? AND `enabled`='1' LIMIT 1 | 0.0002 sec | 1 | 1 | 16 |
| SELECT `c`.*, `p`.`account_id`, `p`.`id` AS `profile_id`, `a`.`email` AS `profile_email`, `a`.`active` AS `profile_last_active`, `a`.`ip` AS `profile_ip`, `p`.`status` AS `profile_status` FROM `bx_organizations_data` AS `c` INNER JOIN `sys_profiles` AS `p` ON (`p`.`content_id` = `c`.`id` AND `p`.`type` = :type) INNER JOIN `sys_accounts` AS `a` ON (`p`.`account_id` = `a`.`id`) WHERE `c`.`id` = :id | 0.0004 sec | 1 | 1 | 18 |
| SELECT * FROM `sys_profiles` WHERE `content_id` = ? AND `type` = ? | 0.0003 sec | 1 | 1 | 16 |
| SELECT `ti`.* FROM `bx_organizations_invites` AS `ti` WHERE 1 AND `ti`.`invited_profile_id`=:invited_pid AND `ti`.`group_profile_id`=:context_pid | 0.0001 sec | 0 | 0 | 17 |
| SELECT * FROM `bx_organizations_fans` WHERE `initiator` = ? AND `content` = ? | 0.0002 sec | 0 | 0 | 16 |
| SELECT
`taa`.`ID` AS `id`,
`taa`.`Module` AS `module`,
`taa`.`Name` AS `name`,
`taa`.`Title` AS `title`,
`taa`.`Countable` AS `countable`,
`taa`.`DisabledForLevels` AS `disabled_for_levels`
FROM `sys_acl_actions` AS `taa`
WHERE 1 AND `taa`.`Name` IN('view entry') AND `taa`.`Module` = :module ORDER BY `taa`.`Title` ASC | 0.0002 sec | 1 | 1 | 17 |
| SELECT
`tam`.`IDAction` AS `id`,
`taa`.`Name` AS `name`,
`taa`.`Title` AS `title`,
`tam`.`AllowedCount` AS `allowed_count`,
`tam`.`AllowedPeriodLen` AS `allowed_period_len`,
UNIX_TIMESTAMP(`tam`.`AllowedPeriodStart`) as `allowed_period_start`,
UNIX_TIMESTAMP(`tam`.`AllowedPeriodEnd`) as `allowed_period_end`,
`tam`.`AdditionalParamValue` AS `additional_param_value`
FROM `sys_acl_actions` AS `taa`
LEFT JOIN `sys_acl_matrix` AS `tam` ON `tam`.`IDAction` = `taa`.`ID` AND `tam`.`IDLevel` = ?
WHERE `taa`.`ID` = ? | 0.0002 sec | 1 | 1 | 17 |
| SELECT
`taa`.`ID` AS `id`,
`taa`.`Module` AS `module`,
`taa`.`Name` AS `name`,
`taa`.`Title` AS `title`,
`taa`.`Countable` AS `countable`,
`taa`.`DisabledForLevels` AS `disabled_for_levels`
FROM `sys_acl_actions` AS `taa`
WHERE 1 AND `taa`.`Name` IN('edit any entry') AND `taa`.`Module` = :module ORDER BY `taa`.`Title` ASC | 0.0002 sec | 1 | 1 | 17 |
| SELECT
`tam`.`IDAction` AS `id`,
`taa`.`Name` AS `name`,
`taa`.`Title` AS `title`,
`tam`.`AllowedCount` AS `allowed_count`,
`tam`.`AllowedPeriodLen` AS `allowed_period_len`,
UNIX_TIMESTAMP(`tam`.`AllowedPeriodStart`) as `allowed_period_start`,
UNIX_TIMESTAMP(`tam`.`AllowedPeriodEnd`) as `allowed_period_end`,
`tam`.`AdditionalParamValue` AS `additional_param_value`
FROM `sys_acl_actions` AS `taa`
LEFT JOIN `sys_acl_matrix` AS `tam` ON `tam`.`IDAction` = `taa`.`ID` AND `tam`.`IDLevel` = ?
WHERE `taa`.`ID` = ? | 0.0002 sec | 1 | 1 | 17 |
| SELECT `id` AS `id`, `author` AS `owner_id`, `allow_view_to` AS `group_id` FROM `bx_organizations_data` WHERE `id`=? LIMIT 1 | 0.0001 sec | 1 | 1 | 16 |
| SELECT
`tp`.`id`
FROM `sys_profiles` AS `tp`
INNER JOIN `sys_accounts` AS `ta` ON `tp`.`account_id`=`ta`.`id`
INNER JOIN `sys_sessions` AS `ts` ON `tp`.`account_id`=`ts`.`user_id`
WHERE
`tp`.`id` = ? AND
`ta`.`profile_id`=`tp`.`id` AND
`ts`.`date` > (UNIX_TIMESTAMP() - 60 * ?)
LIMIT 1 | 0.0002 sec | 0 | 0 | 16 |
| SELECT `views` FROM `bx_persons_data` WHERE `id` = ? LIMIT 1 | 0.0002 sec | 1 | 1 | 16 |
| SELECT `sc`.`id`, `sc`.`id`, `sc`.`text`, `sc`.`color`, `sc`.`fontcolor`, `sc`.`is_icon_only`, `sc`.`icon`, `soc`.`id` AS `badge_id`
FROM `sys_badges` AS `sc`INNER JOIN `sys_badges2objects` `soc` ON `sc`.`id` = `soc`.`badge_id` AND `soc`.`object_id` = :object_id
WHERE 1 AND `sc`.`module` = :module ORDER BY `sc`.`added` ASC | 0.0002 sec | 0 | 0 | 17 |
| SELECT `date` FROM `bx_persons_views_track` WHERE `object_id` = :object_id AND `viewer_id` = '0' AND `viewer_nip` = :viewer_nip ORDER BY `date` DESC LIMIT 1 | 0.0002 sec | 0 | 0 | 17 |
| INSERT IGNORE INTO `bx_persons_views_track` SET `object_id` = ?, `viewer_id` = ?, `viewer_nip` = ?, `date` = ? | 0.0001 sec | 1 | 1 | 0 |
| UPDATE `bx_persons_data` SET `views` = `views` + 1 WHERE `id` = ? | 0.0001 sec | 1 | 1 | 0 |
| SELECT * FROM `bx_persons_pictures` WHERE `id` = ? | 0.0001 sec | 1 | 1 | 16 |
| SELECT * FROM `bx_persons_pictures` WHERE `id` = ? | 0.0001 sec | 1 | 1 | 16 |
| SELECT `mime_type` FROM `sys_storage_mime_types` WHERE `ext` = ? | 0.0001 sec | 1 | 1 | 16 |
| SELECT `file_id` FROM `sys_transcoder_images_files` WHERE `transcoder_object` = ? AND `handler` = ? LIMIT 1 | 0.0001 sec | 1 | 1 | 16 |
| SELECT * FROM `bx_persons_pictures_resized` WHERE `id` = ? | 0.0001 sec | 1 | 1 | 16 |
| SELECT * FROM `bx_persons_pictures` WHERE `id` = ? | 0.0001 sec | 1 | 1 | 16 |
| SELECT `file_id` FROM `sys_transcoder_images_files` WHERE `transcoder_object` = ? AND `handler` = ? LIMIT 1 | 0.0001 sec | 1 | 1 | 16 |
| SELECT * FROM `bx_persons_pictures_resized` WHERE `id` = ? | 0.0001 sec | 1 | 1 | 16 |
| SELECT `atime` FROM `sys_transcoder_images_files` WHERE `transcoder_object` = :obj AND `handler` = :hndl AND `atime` > :ts LIMIT 1 | 0.0001 sec | 1 | 1 | 17 |
| SELECT * FROM `bx_persons_pictures_resized` WHERE `id` = ? | 0.0001 sec | 1 | 1 | 16 |
| SELECT * FROM `sys_objects_metatags` WHERE `object` = ? | 0.0002 sec | 1 | 1 | 16 |
| SELECT * FROM `bx_persons_pictures` WHERE `id` = ? | 0.0002 sec | 1 | 1 | 16 |
| SELECT `keyword` FROM `bx_persons_meta_keywords` WHERE `object_id` = ? ORDER BY CHAR_LENGTH(`keyword`) DESC LIMIT ? | 0.0001 sec | 0 | 0 | 16 |
| SELECT * FROM `bx_persons_meta_locations` WHERE `object_id` = ? | 0.0001 sec | 0 | 0 | 16 |
| SELECT * FROM `bx_persons_pictures` WHERE `id` = ? | 0.0001 sec | 1 | 1 | 16 |
| SELECT `mime_type` FROM `sys_storage_mime_types` WHERE `ext` = ? | 0.0001 sec | 1 | 1 | 16 |
| SELECT `file_id` FROM `sys_transcoder_images_files` WHERE `transcoder_object` = ? AND `handler` = ? LIMIT 1 | 0.0001 sec | 1 | 1 | 16 |
| SELECT * FROM `bx_persons_pictures_resized` WHERE `id` = ? | 0.0025 sec | 1 | 1 | 16 |
| SELECT * FROM `bx_persons_pictures` WHERE `id` = ? | 0.0003 sec | 1 | 1 | 16 |
| SELECT `file_id` FROM `sys_transcoder_images_files` WHERE `transcoder_object` = ? AND `handler` = ? LIMIT 1 | 0.0002 sec | 1 | 1 | 16 |
| SELECT * FROM `bx_persons_pictures_resized` WHERE `id` = ? | 0.0002 sec | 1 | 1 | 16 |
| SELECT `atime` FROM `sys_transcoder_images_files` WHERE `transcoder_object` = :obj AND `handler` = :hndl AND `atime` > :ts LIMIT 1 | 0.0001 sec | 1 | 1 | 17 |
| SELECT * FROM `bx_persons_pictures_resized` WHERE `id` = ? | 0.0001 sec | 1 | 1 | 16 |
| SELECT * FROM `sys_pages_blocks` WHERE `object` = :object AND `cell_id` = :cell_id AND `active` = 1 ORDER BY `order` ASC | 0.0004 sec | 1 | 1 | 18 |
| SELECT * FROM `sys_pages_blocks` WHERE `object` = :object AND `cell_id` = :cell_id AND `active` = 1 ORDER BY `order` ASC | 0.0002 sec | 0 | 0 | 22 |
| SELECT * FROM `sys_pages_blocks` WHERE `object` = :object AND `cell_id` = :cell_id AND `active` = 1 ORDER BY `order` ASC | 0.0002 sec | 0 | 0 | 18 |
| SELECT * FROM `sys_pages_blocks` WHERE `object` = :object AND `cell_id` = :cell_id AND `active` = 1 ORDER BY `order` ASC | 0.0002 sec | 0 | 0 | 18 |