| SELECT * FROM `sys_sessions` WHERE `id`=:id LIMIT 1 | 0.0005 sec | 1 | 1 | 17 |
| UPDATE `sys_sessions` SET `date`=UNIX_TIMESTAMP() WHERE `id`=:id | 0.0001 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.0001 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.0006 sec | 1 | 1 | 17 |
| SELECT `id` FROM `sys_modules` WHERE `name`=? AND `enabled`='1' LIMIT 1 | 0.0007 sec | 1 | 1 | 16 |
| SELECT * FROM `sys_profiles` WHERE `id` = ? LIMIT 1 | 0.0013 sec | 1 | 1 | 16 |
| SELECT `id` FROM `sys_modules` WHERE `name`=? AND `enabled`='1' LIMIT 1 | 0.0071 sec | 1 | 1 | 16 |
| SELECT `bx_persons_data`.* FROM `bx_persons_data` WHERE 1 AND `bx_persons_data`.`id` = :id | 0.001 sec | 1 | 1 | 19 |
| SELECT * FROM `sys_profiles` WHERE `content_id` = ? AND `type` = ? | 0.0044 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('change badge') AND `taa`.`Module` = :module ORDER BY `taa`.`Title` ASC | 0.0025 sec | 1 | 1 | 17 |
| SELECT `id` FROM `sys_accounts` WHERE `id` = ? LIMIT 1 | 0.0083 sec | 1 | 1 | 16 |
| SELECT * FROM `sys_accounts` WHERE `id` = ? LIMIT 1 | 0.0009 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.001 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.001 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.0014 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.0005 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.0103 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.0014 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.0063 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.0007 sec | 1 | 1 | 17 |
| 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.0041 sec | 1 | 1 | 35 |
| SELECT * FROM `msolutions_usernames_usernames` WHERE `profile_id` = ? LIMIT 1 | 0.0013 sec | 1 | 1 | 16 |
| SELECT * FROM `sys_objects_transcoder` WHERE `object` = ? | 0.0019 sec | 1 | 1 | 16 |
| SELECT * FROM `bx_persons_pictures` WHERE `id` = ? | 0.0006 sec | 1 | 1 | 16 |
| SELECT `mime_type` FROM `sys_storage_mime_types` WHERE `ext` = ? | 0.0149 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.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_transcoder` WHERE `object` = ? | 0.0002 sec | 1 | 1 | 18 |
| 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_transcoder` WHERE `object` = ? | 0.0002 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.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.0002 sec | 1 | 1 | 17 |
| SELECT * FROM `bx_persons_pictures_resized` WHERE `id` = ? | 0.0001 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.0003 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.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_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.0007 sec | 0 | 0 | 19 |
| 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.0154 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.0033 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 `count` as `count`, `sum` as `sum`, ROUND(`sum` / `count`, 2) AS `rate` FROM bx_persons_votes WHERE `object_id` = ? LIMIT 1 | 0.0004 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.0003 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('vote_view') 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 | 22 |
| SELECT `object_id` FROM `bx_persons_votes_track` WHERE `object_id` = ? AND `author_id` = ? LIMIT 1 | 0.0001 sec | 0 | 0 | 16 |
| SELECT COUNT(DISTINCT `author_id`) AS `count` FROM `bx_persons_favorites_track` WHERE `object_id`=:object_id LIMIT 1 | 0.0004 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.0003 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 `featured` FROM `bx_persons_data` WHERE `id` = ? LIMIT 1 | 0.0003 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.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('report_view') AND `taa`.`Module` = :module ORDER BY `taa`.`Title` ASC | 0.0004 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 `count` as `count` FROM bx_persons_reports WHERE `object_id` = ? LIMIT 1 | 0.0001 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.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.0001 sec | 1 | 1 | 17 |
| SELECT `menu_item_name`, IF(`active`, `menu_item_eval`, 'return \' \';') AS `menu_item_eval` FROM `aqb_advanced_menu_items` | 0.0081 sec | 17 | 17 | 16 |
| SELECT 1 FROM `sys_menu_items` WHERE `set_name` = ? AND `parent_id` != '0' LIMIT 1 | 0.0154 sec | 0 | 0 | 16 |
| SELECT * FROM `sys_menu_items` WHERE 1 AND `set_name` = :set_name ORDER BY `order` ASC | 0.0115 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.0078 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.0051 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.0136 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.0096 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.0113 sec | 1 | 1 | 17 |
| SELECT * FROM `sys_profiles` WHERE `id` = ? LIMIT 1 | 0.0105 sec | 1 | 1 | 16 |
| SELECT `id` FROM `sys_modules` WHERE `name`=? AND `enabled`='1' LIMIT 1 | 0.0069 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.0069 sec | 1 | 1 | 18 |
| SELECT * FROM `sys_profiles` WHERE `content_id` = ? AND `type` = ? | 0.0091 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.0067 sec | 0 | 0 | 17 |
| SELECT * FROM `bx_organizations_fans` WHERE `initiator` = ? AND `content` = ? | 0.001 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.0127 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.0111 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.0107 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.0051 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.0109 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.0097 sec | 0 | 0 | 16 |
| SELECT `views` FROM `bx_persons_data` WHERE `id` = ? LIMIT 1 | 0.0144 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.0113 sec | 0 | 0 | 17 |
| SELECT * FROM `msolutions_usernames_usernames` WHERE `profile_id` = ? LIMIT 1 | 0.0088 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.0064 sec | 4 | 4 | 18 |
| SELECT 0 `id`, 'Default' `title` UNION (SELECT `l`.`id`, `l`.`title` FROM `bx_events_favorites_lists` `l` INNER JOIN `bx_events_favorites_track` `t` ON `t`.`list_id` = `l`.`id` WHERE `l`.`author_id` = :author GROUP BY `l`.`id`, `l`.`title` ORDER BY `l`.`date` DESC) LIMIT 0, 6 | 0.0071 sec | 1 | 1 | 17 |
| SELECT `id` AS `id`, `author_id` AS `owner_id`, `allow_view_favorite_list_to` AS `group_id` FROM `bx_events_favorites_lists` WHERE `id`=? LIMIT 1 | 0.004 sec | 0 | 0 | 16 |
| SELECT `id` FROM `sys_modules` WHERE `name`=? AND `enabled`='1' LIMIT 1 | 0.0127 sec | 1 | 1 | 16 |
| SELECT `c`.`content` FROM `aqb_black_lists_profiles` AS `c` WHERE 1 AND `c`.`initiator` = :initiator LIMIT 0, 1000 | 0.0236 sec | 0 | 0 | 17 |
| SELECT * FROM `sys_profiles` INNER JOIN `bx_events_data` ON `bx_events_data`.`id`=`sys_profiles`.`content_id` INNER JOIN `sys_accounts` ON `sys_accounts`.`id`=`sys_profiles`.`account_id` INNER JOIN `bx_events_favorites_track` ON `bx_events_favorites_track`.`object_id`=`bx_events_data`.`id`WHERE 1 AND `sys_profiles`.`status` ='active' AND `sys_profiles`.`type` ='bx_events' AND `bx_events_data`.`status` ='active' AND `bx_events_data`.`status_admin` ='active' AND `bx_events_favorites_track`.`author_id` ='9' AND `bx_events_favorites_track`.`list_id` ='0' AND `bx_events_data`.`allow_view_to` IN(3,'c') AND '' NOT IN (SELECT `content` FROM `aqb_black_lists_profiles` WHERE `initiator`=`bx_events_data`.`author`) LIMIT 0, 33 | 0.0024 sec | 0 | 0 | 34 |
| SELECT `c`.`content` FROM `aqb_black_lists_profiles` AS `c` WHERE 1 AND `c`.`initiator` = :initiator LIMIT 0, 1000 | 0.007 sec | 0 | 0 | 17 |
| SELECT * FROM `sys_profiles` INNER JOIN `bx_events_data` ON `bx_events_data`.`id`=`sys_profiles`.`content_id` INNER JOIN `sys_accounts` ON `sys_accounts`.`id`=`sys_profiles`.`account_id` INNER JOIN `bx_events_fans` ON `bx_events_fans`.`content`=`sys_profiles`.`id`WHERE 1 AND `sys_profiles`.`status` ='active' AND `sys_profiles`.`type` ='bx_events' AND `bx_events_data`.`status` ='active' AND `bx_events_data`.`status_admin` ='active' AND `bx_events_fans`.`initiator` ='9' AND '' NOT IN (SELECT `content` FROM `aqb_black_lists_profiles` WHERE `initiator`=`bx_events_data`.`author`) LIMIT 0, 25 | 0.0083 sec | 0 | 0 | 34 |