class.get_instance.NEWSFEED_CMP_Feed
Type: trigger
Called at: 0.046
Exec time: 0.000
|
No listeners
|
array (
'className' => 'NEWSFEED_CMP_Feed',
'arguments' =>
array (
0 =>
NEWSFEED_CLASS_FeedDriver::__set_state(array(
'params' =>
array (
'offset' => 0,
'length' => false,
'displayCount' => 20,
'formats' => NULL,
'feedType' => 'user',
'feedId' => '1',
'feedAutoId' => 'feed1',
'startTime' => 1760860688,
'displayType' => 'action',
'viewMore' => false,
),
'defaultParams' =>
array (
'offset' => 0,
'length' => false,
'displayCount' => 20,
'formats' => NULL,
),
'actionList' =>
array (
3227 =>
NEWSFEED_CLASS_Action::__set_state(array(
'activity' =>
array (
0 =>
NEWSFEED_BOL_Activity::__set_state(array(
'actionId' => '3227',
'userId' => '1',
'activityType' => 'subscribe',
'activityId' => '1',
'data' => '[]',
'timeStamp' => '1627264263',
'visibility' => '15',
'privacy' => 'everybody',
'status' => 'active',
'id' => '7268',
'_fieldsHash' =>
array (
'actionId' => 2985838803,
'userId' => 2212294583,
'activityType' => 1756979006,
'activityId' => 2212294583,
'data' => 223132457,
'timeStamp' => 2584064543,
'visibility' => 3510096238,
'privacy' => 193515978,
'status' => 1260321794,
),
)),
1 =>
NEWSFEED_BOL_Activity::__set_state(array(
'actionId' => '3227',
'userId' => '1',
'activityType' => 'create',
'activityId' => '1',
'data' => '[]',
'timeStamp' => '1627264263',
'visibility' => '15',
'privacy' => 'everybody',
'status' => 'active',
'id' => '7267',
'_fieldsHash' =>
array (
'actionId' => 2985838803,
'userId' => 2212294583,
'activityType' => 2413224187,
'activityId' => 2212294583,
'data' => 223132457,
'timeStamp' => 2584064543,
'visibility' => 3510096238,
'privacy' => 193515978,
'status' => 1260321794,
),
)),
),
'properties' =>
array (
'id' => '3227',
'data' =>
array (
'photoIdList' =>
array (
0 => 222,
),
'string' =>
array (
'key' => 'photo+feed_single_description',
'vars' =>
array (
'number' => 1,
'albumUrl' => 'https://www.tutorshares.com/photo/useralbum/admin/85',
'albumName' => 'Newsfeed Photos',
),
),
'status' => 'Thank you to all our new members for joining, we now have over 1,000 members on the platform. If you are a tutor please ensure you have a detailed profile, including an introduction video to enhance your credibility with students and parents. Please keep active on the platform by posting insights, adding to your profile with photos, videos and by forming connections.',
'actionDto' => NULL,
'content' =>
array (
'format' => 'image',
'vars' =>
array (
'status' => 'Thank you to all our new members for joining, we now have over 1,000 members on the platform. If you are a tutor please ensure you have a detailed profile, including an introduction video to enhance your credibility with students and parents. Please keep active on the platform by posting insights, adding to your profile with photos, videos and by forming connections.',
'image' => 'https://www.tutorshares.com/ow_userfiles/plugins/photo/photo_preview_222_60fe150722128.jpg',
'url' =>
array (
'routeName' => 'view_photo',
'vars' =>
array (
'id' => 222,
),
),
'title' => 'Thank you to all our new members for joining, we now have over 1,000 members on the platform. If you are a tutor please ensure you have a detailed profile, including an introduction video to enhance your credibility with students and parents. Please keep active on the platform by posting insights, adding to your profile with photos, videos and by forming connections.',
'info' =>
array (
'route' =>
array (
'textKey' => 'photo+album',
'label' => 'Newsfeed Photos',
'routeName' => 'photo_user_album',
'vars' =>
array (
'user' => 'admin',
'album' => '85',
),
),
),
),
),
'view' =>
array (
'iconClass' => 'ow_ic_picture',
),
),
'entityType' => 'photo_comments',
'entityId' => '222',
'pluginKey' => 'photo',
'format' => 'image',
'createTime' => '1627264263',
'userId' => '1',
),
'createActivity' =>
NEWSFEED_BOL_Activity::__set_state(array(
'actionId' => '3227',
'userId' => '1',
'activityType' => 'create',
'activityId' => '1',
'data' => '[]',
'timeStamp' => '1627264263',
'visibility' => '15',
'privacy' => 'everybody',
'status' => 'active',
'id' => '7267',
'_fieldsHash' =>
array (
'actionId' => 2985838803,
'userId' => 2212294583,
'activityType' => 2413224187,
'activityId' => 2212294583,
'data' => 223132457,
'timeStamp' => 2584064543,
'visibility' => 3510096238,
'privacy' => 193515978,
'status' => 1260321794,
),
)),
'lastActivity' =>
NEWSFEED_BOL_Activity::__set_state(array(
'actionId' => '3227',
'userId' => '1',
'activityType' => 'subscribe',
'activityId' => '1',
'data' => '[]',
'timeStamp' => '1627264263',
'visibility' => '15',
'privacy' => 'everybody',
'status' => 'active',
'id' => '7268',
'_fieldsHash' =>
array (
'actionId' => 2985838803,
'userId' => 2212294583,
'activityType' => 1756979006,
'activityId' => 2212294583,
'data' => 223132457,
'timeStamp' => 2584064543,
'visibility' => 3510096238,
'privacy' => 193515978,
'status' => 1260321794,
),
)),
'creatorIdList' =>
array (
0 => '1',
),
'feeds' =>
array (
),
)),
),
'count' => false,
'context' =>
array (
),
'formats' => NULL,
'actionIdList' =>
array (
'photo_comments:222' => '3227',
),
'service' =>
NEWSFEED_BOL_Service::__set_state(array(
'SYSTEM_ACTIVITIES' =>
array (
0 => 'create',
1 => 'subscribe',
),
'actionDao' =>
NEWSFEED_BOL_ActionDao::__set_state(array(
'dbo' =>
OW_Database::__set_state(array(
'connection' =>
PDO::__set_state(array(
)),
'affectedRows' => 1,
'queryLog' =>
array (
0 =>
array (
'query' => 'SELECT * FROM ow_base_config',
'execTime' => 0.0013799667358398438,
'params' =>
array (
),
),
1 =>
array (
'query' => 'SELECT * FROM ow_base_language',
'execTime' => 0.00024890899658203125,
'params' =>
array (
),
),
2 =>
array (
'query' => 'SELECT * FROM ow_base_plugin',
'execTime' => 0.0004169940948486328,
'params' =>
array (
),
),
3 =>
array (
'query' => 'SELECT * FROM ow_base_language ORDER BY `order` ASC LIMIT 0, 1',
'execTime' => 0.000247955322265625,
'params' =>
array (
),
),
4 =>
array (
'query' => 'SELECT * FROM ow_base_language WHERE `id` = ?',
'execTime' => 0.00025200843811035156,
'params' =>
array (
0 => 1,
),
),
5 =>
array (
'query' => 'SELECT * FROM ow_base_language',
'execTime' => 0.0001380443572998047,
'params' =>
array (
),
),
6 =>
array (
'query' => 'SET TIME_ZONE = ?',
'execTime' => 0.00010395050048828125,
'params' =>
array (
0 => '-04:00',
),
),
7 =>
array (
'query' => 'SELECT * FROM ow_base_document WHERE `uri` = \'newsfeed/3227\' AND `isStatic` = 1 LIMIT 0, 1',
'execTime' => 0.0002231597900390625,
'params' =>
array (
),
),
8 =>
array (
'query' => 'SELECT * FROM ow_base_theme WHERE `key` = \'simplicity\' LIMIT 0, 1',
'execTime' => 0.0003600120544433594,
'params' =>
array (
),
),
9 =>
array (
'query' => 'SELECT * FROM ow_base_theme_content WHERE `themeId` = 956',
'execTime' => 0.0002498626708984375,
'params' =>
array (
),
),
10 =>
array (
'query' => 'SELECT * FROM ow_base_theme_master_page WHERE `themeId` = 956',
'execTime' => 0.00018215179443359375,
'params' =>
array (
),
),
11 =>
array (
'query' => 'SELECT * FROM ow_base_theme WHERE `key` = \'match_sprintally\' LIMIT 0, 1',
'execTime' => 0.00017404556274414062,
'params' =>
array (
),
),
12 =>
array (
'query' => 'SELECT * FROM ow_base_theme WHERE `key` = \'match_sprintally\' LIMIT 0, 1',
'execTime' => 0.00013589859008789062,
'params' =>
array (
),
),
13 =>
array (
'query' => 'SELECT * FROM ow_base_theme_content WHERE `themeId` = 959',
'execTime' => 0.00020599365234375,
'params' =>
array (
),
),
14 =>
array (
'query' => 'SELECT * FROM ow_base_theme_master_page WHERE `themeId` = 959',
'execTime' => 0.000164031982421875,
'params' =>
array (
),
),
15 =>
array (
'query' => 'SELECT * FROM ow_base_document WHERE `isStatic` = 1 AND `isMobile` = 0',
'execTime' => 0.0001499652862548828,
'params' =>
array (
),
),
16 =>
array (
'query' => '
SELECT *
FROM `ow_base_menu_item`
WHERE `visibleFor` & ? AND `externalUrl` IS NULL AND `type` = ?
ORDER BY `order` ASC
LIMIT 1',
'execTime' => 0.00036787986755371094,
'params' =>
array (
0 => 1,
1 => 'main',
),
),
17 =>
array (
'query' => '
SELECT `mi`.*, `mi`.`key` AS `menu_key`, `d`.`class`, `d`.`action`, `d`.`uri`, `d`.`isStatic`
FROM `ow_base_menu_item` AS `mi`
LEFT JOIN `ow_base_document` AS `d` ON ( `mi`.`documentKey` = `d`.`key`)
WHERE `mi`.`type` = :menuType ORDER BY `mi`.`order` ASC',
'execTime' => 0.0005359649658203125,
'params' =>
array (
'menuType' => 'main',
),
),
18 =>
array (
'query' => '
SELECT `mi`.*, `mi`.`key` AS `menu_key`, `d`.`class`, `d`.`action`, `d`.`uri`, `d`.`isStatic`
FROM `ow_base_menu_item` AS `mi`
LEFT JOIN `ow_base_document` AS `d` ON ( `mi`.`documentKey` = `d`.`key`)
WHERE `mi`.`type` = :menuType ORDER BY `mi`.`order` ASC',
'execTime' => 0.0005810260772705078,
'params' =>
array (
'menuType' => 'bottom',
),
),
19 =>
array (
'query' => 'SELECT * FROM ow_newsfeed_action WHERE `id` = 3227 LIMIT 0, 1',
'execTime' => 0.0007688999176025391,
'params' =>
array (
),
),
20 =>
array (
'query' => 'SELECT activity.* FROM ow_newsfeed_activity activity
WHERE activity.actionId IN(3227)
AND activity.activityType IN ("create", "subscribe") UNION SELECT a.* FROM ( SELECT DISTINCT activity.* FROM ow_newsfeed_activity activity
INNER JOIN `ow_base_user` base_user_table_alias ON base_user_table_alias.`id` = `activity`.`userId` LEFT JOIN `ow_base_user_suspend` base_user_suspend_table_alias ON base_user_suspend_table_alias.`userId` = `base_user_table_alias`.`id`
INNER JOIN ow_newsfeed_action_feed action_feed ON activity.id=action_feed.activityId
WHERE (`base_user_suspend_table_alias`.`id` IS NULL) AND activity.actionId = 3227 AND
(
activity.status=:s
AND activity.privacy=:peb
AND action_feed.feedType=:ft
AND action_feed.feedId=:fi
AND activity.visibility & :v
)
ORDER BY activity.timeStamp DESC, activity.id DESC LIMIT 100 ) a ORDER BY 7 DESC, 1 DESC ',
'execTime' => 0.000990152359008789,
'params' =>
array (
'ft' => 'user',
'fi' => '1',
's' => 'active',
'v' => 8,
'peb' => 'everybody',
),
),
21 =>
array (
'query' => 'SELECT COUNT(DISTINCT action.id) FROM ow_newsfeed_action action
INNER JOIN ow_newsfeed_activity activity ON action.id = activity.actionId
INNER JOIN ow_newsfeed_activity cactivity ON action.id = cactivity.actionId
INNER JOIN `ow_base_user` base_user_table_alias ON base_user_table_alias.`id` = `activity`.`userId` LEFT JOIN `ow_base_user_suspend` base_user_suspend_table_alias ON base_user_suspend_table_alias.`userId` = `base_user_table_alias`.`id`
INNER JOIN ow_newsfeed_action_feed action_feed ON activity.id=action_feed.activityId
WHERE (`base_user_suspend_table_alias`.`id` IS NULL)
AND activity.status=:s
AND activity.timeStamp<:st
AND activity.privacy=:peb
AND action_feed.feedType=:ft
AND action_feed.feedId=:fi
AND activity.visibility & :v
AND cactivity.status=:s
AND cactivity.activityType=:ac
AND cactivity.privacy=:peb
AND cactivity.visibility & :v',
'execTime' => 0.003693819046020508,
'params' =>
array (
'ft' => 'user',
'fi' => '1',
's' => 'active',
'v' => 8,
'peb' => 'everybody',
'ac' => 'create',
'st' => 1760860688,
),
),
22 =>
array (
'query' => 'SELECT * FROM ow_base_avatar WHERE `userId` IN(\'1\')',
'execTime' => 0.0002911090850830078,
'params' =>
array (
),
),
23 =>
array (
'query' => 'SELECT * FROM ow_base_user WHERE `id` IN(\'1\')',
'execTime' => 0.00022792816162109375,
'params' =>
array (
),
),
24 =>
array (
'query' => 'SELECT * FROM ow_base_question WHERE `name` IN(\'realname\')',
'execTime' => 0.00028705596923828125,
'params' =>
array (
),
),
25 =>
array (
'query' => 'SELECT * FROM ow_base_question_data WHERE `userId` IN(\'1\') AND `questionName` IN(\'realname\')',
'execTime' => 0.00022792816162109375,
'params' =>
array (
),
),
26 =>
array (
'query' => 'SELECT * FROM ow_base_authorization_group',
'execTime' => 0.00022292137145996094,
'params' =>
array (
),
),
27 =>
array (
'query' => 'SELECT * FROM ow_base_authorization_moderator ORDER BY id',
'execTime' => 0.00014901161193847656,
'params' =>
array (
),
),
28 =>
array (
'query' => 'SELECT * FROM ow_base_authorization_moderator_permission',
'execTime' => 0.00014209747314453125,
'params' =>
array (
),
),
29 =>
array (
'query' => 'SELECT * FROM ow_base_authorization_action',
'execTime' => 0.0004558563232421875,
'params' =>
array (
),
),
30 =>
array (
'query' => 'SELECT * FROM ow_base_authorization_permission',
'execTime' => 0.00038886070251464844,
'params' =>
array (
),
),
31 =>
array (
'query' => 'SELECT * FROM ow_base_authorization_role ORDER BY `sortOrder` ASC',
'execTime' => 0.000164031982421875,
'params' =>
array (
),
),
32 =>
array (
'query' => 'SELECT `userId`,`name`,`custom` FROM ow_base_authorization_user_role ur
INNER JOIN ow_base_authorization_role r ON ur.roleId=r.id
WHERE ur.userId IN(\'1\') AND r.displayLabel=1
ORDER BY sortOrder DESC',
'execTime' => 0.00024509429931640625,
'params' => NULL,
),
33 =>
array (
'query' => 'SELECT `ce`.`entityType`, `ce`.`entityId`, COUNT(*) AS `count` FROM `ow_base_comment` AS `c`
LEFT JOIN `ow_base_comment_entity` AS `ce` ON ( `c`.`commentEntityId` = `ce`.`id` )
WHERE (`ce`.`entityType` = ? AND `ce`.`entityId` = ? ) GROUP BY `ce`.`id`',
'execTime' => 0.0002148151397705078,
'params' =>
array (
0 => 'photo_comments',
1 => '222',
),
),
34 =>
array (
'query' => 'SELECT * FROM ow_newsfeed_like WHERE entityType="photo_comments" AND entityId="222"',
'execTime' => 0.00015997886657714844,
'params' => NULL,
),
35 =>
array (
'query' => 'SELECT * FROM ow_base_theme WHERE `key` = \'match_sprintally\' LIMIT 0, 1',
'execTime' => 0.00026607513427734375,
'params' =>
array (
),
),
36 =>
array (
'query' => 'SELECT * FROM ow_base_place WHERE `name` = \'index\' LIMIT 0, 1',
'execTime' => 0.00020694732666015625,
'params' =>
array (
),
),
37 =>
array (
'query' => 'SELECT * FROM ow_base_component_place_cache WHERE `placeId` = \'2\' AND `entityId` = 0 LIMIT 0, 1',
'execTime' => 0.00026297569274902344,
'params' =>
array (
),
),
38 =>
array (
'query' => 'SELECT * FROM ow_base_language',
'execTime' => 0.00014901161193847656,
'params' =>
array (
),
),
39 =>
array (
'query' => 'SELECT COUNT(*) FROM ow_base_invitation WHERE `userId` = 0',
'execTime' => 0.0001709461212158203,
'params' =>
array (
),
),
40 =>
array (
'query' => 'SELECT COUNT(*) FROM ow_base_invitation WHERE `userId` = 0 AND `viewed` = 0',
'execTime' => 0.00011396408081054688,
'params' =>
array (
),
),
41 =>
array (
'query' => 'SELECT * FROM ow_base_component_place_cache WHERE `placeId` = \'2\' AND `entityId` = 0 LIMIT 0, 1',
'execTime' => 0.0001971721649169922,
'params' =>
array (
),
),
),
'debugMode' => NULL,
'isProfilerEnabled' => true,
'profiler' =>
UTIL_Profiler::__set_state(array(
'checkPoints' =>
array (
'start' => 1760860688.904975,
),
'key' => 'db',
'result' =>
array (
),
'chkCounter' => 0,
)),
'queryExecTime' => 0.0001971721649169922,
'totalQueryExecTime' => 0.016114473342895508,
'queryCount' => 42,
'useCashe' => false,
)),
)),
'followDao' =>
NEWSFEED_BOL_FollowDao::__set_state(array(
'dbo' =>
OW_Database::__set_state(array(
'connection' =>
PDO::__set_state(array(
)),
'affectedRows' => 1,
'queryLog' =>
array (
0 =>
array (
'query' => 'SELECT * FROM ow_base_config',
'execTime' => 0.0013799667358398438,
'params' =>
array (
),
),
1 =>
array (
'query' => 'SELECT * FROM ow_base_language',
'execTime' => 0.00024890899658203125,
'params' =>
array (
),
),
2 =>
array (
'query' => 'SELECT * FROM ow_base_plugin',
'execTime' => 0.0004169940948486328,
'params' =>
array (
),
),
3 =>
array (
'query' => 'SELECT * FROM ow_base_language ORDER BY `order` ASC LIMIT 0, 1',
'execTime' => 0.000247955322265625,
'params' =>
array (
),
),
4 =>
array (
'query' => 'SELECT * FROM ow_base_language WHERE `id` = ?',
'execTime' => 0.00025200843811035156,
'params' =>
array (
0 => 1,
),
),
5 =>
array (
'query' => 'SELECT * FROM ow_base_language',
'execTime' => 0.0001380443572998047,
'params' =>
array (
),
),
6 =>
array (
'query' => 'SET TIME_ZONE = ?',
'execTime' => 0.00010395050048828125,
'params' =>
array (
0 => '-04:00',
),
),
7 =>
array (
'query' => 'SELECT * FROM ow_base_document WHERE `uri` = \'newsfeed/3227\' AND `isStatic` = 1 LIMIT 0, 1',
'execTime' => 0.0002231597900390625,
'params' =>
array (
),
),
8 =>
array (
'query' => 'SELECT * FROM ow_base_theme WHERE `key` = \'simplicity\' LIMIT 0, 1',
'execTime' => 0.0003600120544433594,
'params' =>
array (
),
),
9 =>
array (
'query' => 'SELECT * FROM ow_base_theme_content WHERE `themeId` = 956',
'execTime' => 0.0002498626708984375,
'params' =>
array (
),
),
10 =>
array (
'query' => 'SELECT * FROM ow_base_theme_master_page WHERE `themeId` = 956',
'execTime' => 0.00018215179443359375,
'params' =>
array (
),
),
11 =>
array (
'query' => 'SELECT * FROM ow_base_theme WHERE `key` = \'match_sprintally\' LIMIT 0, 1',
'execTime' => 0.00017404556274414062,
'params' =>
array (
),
),
12 =>
array (
'query' => 'SELECT * FROM ow_base_theme WHERE `key` = \'match_sprintally\' LIMIT 0, 1',
'execTime' => 0.00013589859008789062,
'params' =>
array (
),
),
13 =>
array (
'query' => 'SELECT * FROM ow_base_theme_content WHERE `themeId` = 959',
'execTime' => 0.00020599365234375,
'params' =>
array (
),
),
14 =>
array (
'query' => 'SELECT * FROM ow_base_theme_master_page WHERE `themeId` = 959',
'execTime' => 0.000164031982421875,
'params' =>
array (
),
),
15 =>
array (
'query' => 'SELECT * FROM ow_base_document WHERE `isStatic` = 1 AND `isMobile` = 0',
'execTime' => 0.0001499652862548828,
'params' =>
array (
),
),
16 =>
array (
'query' => '
SELECT *
FROM `ow_base_menu_item`
WHERE `visibleFor` & ? AND `externalUrl` IS NULL AND `type` = ?
ORDER BY `order` ASC
LIMIT 1',
'execTime' => 0.00036787986755371094,
'params' =>
array (
0 => 1,
1 => 'main',
),
),
17 =>
array (
'query' => '
SELECT `mi`.*, `mi`.`key` AS `menu_key`, `d`.`class`, `d`.`action`, `d`.`uri`, `d`.`isStatic`
FROM `ow_base_menu_item` AS `mi`
LEFT JOIN `ow_base_document` AS `d` ON ( `mi`.`documentKey` = `d`.`key`)
WHERE `mi`.`type` = :menuType ORDER BY `mi`.`order` ASC',
'execTime' => 0.0005359649658203125,
'params' =>
array (
'menuType' => 'main',
),
),
18 =>
array (
'query' => '
SELECT `mi`.*, `mi`.`key` AS `menu_key`, `d`.`class`, `d`.`action`, `d`.`uri`, `d`.`isStatic`
FROM `ow_base_menu_item` AS `mi`
LEFT JOIN `ow_base_document` AS `d` ON ( `mi`.`documentKey` = `d`.`key`)
WHERE `mi`.`type` = :menuType ORDER BY `mi`.`order` ASC',
'execTime' => 0.0005810260772705078,
'params' =>
array (
'menuType' => 'bottom',
),
),
19 =>
array (
'query' => 'SELECT * FROM ow_newsfeed_action WHERE `id` = 3227 LIMIT 0, 1',
'execTime' => 0.0007688999176025391,
'params' =>
array (
),
),
20 =>
array (
'query' => 'SELECT activity.* FROM ow_newsfeed_activity activity
WHERE activity.actionId IN(3227)
AND activity.activityType IN ("create", "subscribe") UNION SELECT a.* FROM ( SELECT DISTINCT activity.* FROM ow_newsfeed_activity activity
INNER JOIN `ow_base_user` base_user_table_alias ON base_user_table_alias.`id` = `activity`.`userId` LEFT JOIN `ow_base_user_suspend` base_user_suspend_table_alias ON base_user_suspend_table_alias.`userId` = `base_user_table_alias`.`id`
INNER JOIN ow_newsfeed_action_feed action_feed ON activity.id=action_feed.activityId
WHERE (`base_user_suspend_table_alias`.`id` IS NULL) AND activity.actionId = 3227 AND
(
activity.status=:s
AND activity.privacy=:peb
AND action_feed.feedType=:ft
AND action_feed.feedId=:fi
AND activity.visibility & :v
)
ORDER BY activity.timeStamp DESC, activity.id DESC LIMIT 100 ) a ORDER BY 7 DESC, 1 DESC ',
'execTime' => 0.000990152359008789,
'params' =>
array (
'ft' => 'user',
'fi' => '1',
's' => 'active',
'v' => 8,
'peb' => 'everybody',
),
),
21 =>
array (
'query' => 'SELECT COUNT(DISTINCT action.id) FROM ow_newsfeed_action action
INNER JOIN ow_newsfeed_activity activity ON action.id = activity.actionId
INNER JOIN ow_newsfeed_activity cactivity ON action.id = cactivity.actionId
INNER JOIN `ow_base_user` base_user_table_alias ON base_user_table_alias.`id` = `activity`.`userId` LEFT JOIN `ow_base_user_suspend` base_user_suspend_table_alias ON base_user_suspend_table_alias.`userId` = `base_user_table_alias`.`id`
INNER JOIN ow_newsfeed_action_feed action_feed ON activity.id=action_feed.activityId
WHERE (`base_user_suspend_table_alias`.`id` IS NULL)
AND activity.status=:s
AND activity.timeStamp<:st
AND activity.privacy=:peb
AND action_feed.feedType=:ft
AND action_feed.feedId=:fi
AND activity.visibility & :v
AND cactivity.status=:s
AND cactivity.activityType=:ac
AND cactivity.privacy=:peb
AND cactivity.visibility & :v',
'execTime' => 0.003693819046020508,
'params' =>
array (
'ft' => 'user',
'fi' => '1',
's' => 'active',
'v' => 8,
'peb' => 'everybody',
'ac' => 'create',
'st' => 1760860688,
),
),
22 =>
array (
'query' => 'SELECT * FROM ow_base_avatar WHERE `userId` IN(\'1\')',
'execTime' => 0.0002911090850830078,
'params' =>
array (
),
),
23 =>
array (
'query' => 'SELECT * FROM ow_base_user WHERE `id` IN(\'1\')',
'execTime' => 0.00022792816162109375,
'params' =>
array (
),
),
24 =>
array (
'query' => 'SELECT * FROM ow_base_question WHERE `name` IN(\'realname\')',
'execTime' => 0.00028705596923828125,
'params' =>
array (
),
),
25 =>
array (
'query' => 'SELECT * FROM ow_base_question_data WHERE `userId` IN(\'1\') AND `questionName` IN(\'realname\')',
'execTime' => 0.00022792816162109375,
'params' =>
array (
),
),
26 =>
array (
'query' => 'SELECT * FROM ow_base_authorization_group',
'execTime' => 0.00022292137145996094,
'params' =>
array (
),
),
27 =>
array (
'query' => 'SELECT * FROM ow_base_authorization_moderator ORDER BY id',
'execTime' => 0.00014901161193847656,
'params' =>
array (
),
),
28 =>
array (
'query' => 'SELECT * FROM ow_base_authorization_moderator_permission',
'execTime' => 0.00014209747314453125,
'params' =>
array (
),
),
29 =>
array (
'query' => 'SELECT * FROM ow_base_authorization_action',
'execTime' => 0.0004558563232421875,
'params' =>
array (
),
),
30 =>
array (
'query' => 'SELECT * FROM ow_base_authorization_permission',
'execTime' => 0.00038886070251464844,
'params' =>
array (
),
),
31 =>
array (
'query' => 'SELECT * FROM ow_base_authorization_role ORDER BY `sortOrder` ASC',
'execTime' => 0.000164031982421875,
'params' =>
array (
),
),
32 =>
array (
'query' => 'SELECT `userId`,`name`,`custom` FROM ow_base_authorization_user_role ur
INNER JOIN ow_base_authorization_role r ON ur.roleId=r.id
WHERE ur.userId IN(\'1\') AND r.displayLabel=1
ORDER BY sortOrder DESC',
'execTime' => 0.00024509429931640625,
'params' => NULL,
),
33 =>
array (
'query' => 'SELECT `ce`.`entityType`, `ce`.`entityId`, COUNT(*) AS `count` FROM `ow_base_comment` AS `c`
LEFT JOIN `ow_base_comment_entity` AS `ce` ON ( `c`.`commentEntityId` = `ce`.`id` )
WHERE (`ce`.`entityType` = ? AND `ce`.`entityId` = ? ) GROUP BY `ce`.`id`',
'execTime' => 0.0002148151397705078,
'params' =>
array (
0 => 'photo_comments',
1 => '222',
),
),
34 =>
array (
'query' => 'SELECT * FROM ow_newsfeed_like WHERE entityType="photo_comments" AND entityId="222"',
'execTime' => 0.00015997886657714844,
'params' => NULL,
),
35 =>
array (
'query' => 'SELECT * FROM ow_base_theme WHERE `key` = \'match_sprintally\' LIMIT 0, 1',
'execTime' => 0.00026607513427734375,
'params' =>
array (
),
),
36 =>
array (
'query' => 'SELECT * FROM ow_base_place WHERE `name` = \'index\' LIMIT 0, 1',
'execTime' => 0.00020694732666015625,
'params' =>
array (
),
),
37 =>
array (
'query' => 'SELECT * FROM ow_base_component_place_cache WHERE `placeId` = \'2\' AND `entityId` = 0 LIMIT 0, 1',
'execTime' => 0.00026297569274902344,
'params' =>
array (
),
),
38 =>
array (
'query' => 'SELECT * FROM ow_base_language',
'execTime' => 0.00014901161193847656,
'params' =>
array (
),
),
39 =>
array (
'query' => 'SELECT COUNT(*) FROM ow_base_invitation WHERE `userId` = 0',
'execTime' => 0.0001709461212158203,
'params' =>
array (
),
),
40 =>
array (
'query' => 'SELECT COUNT(*) FROM ow_base_invitation WHERE `userId` = 0 AND `viewed` = 0',
'execTime' => 0.00011396408081054688,
'params' =>
array (
),
),
41 =>
array (
'query' => 'SELECT * FROM ow_base_component_place_cache WHERE `placeId` = \'2\' AND `entityId` = 0 LIMIT 0, 1',
'execTime' => 0.0001971721649169922,
'params' =>
array (
),
),
),
'debugMode' => NULL,
'isProfilerEnabled' => true,
'profiler' =>
UTIL_Profiler::__set_state(array(
'checkPoints' =>
array (
'start' => 1760860688.904975,
),
'key' => 'db',
'result' =>
array (
),
'chkCounter' => 0,
)),
'queryExecTime' => 0.0001971721649169922,
'totalQueryExecTime' => 0.016114473342895508,
'queryCount' => 42,
'useCashe' => false,
)),
)),
'actionFeedDao' =>
NEWSFEED_BOL_ActionFeedDao::__set_state(array(
'dbo' =>
OW_Database::__set_state(array(
'connection' =>
PDO::__set_state(array(
)),
'affectedRows' => 1,
'queryLog' =>
array (
0 =>
array (
'query' => 'SELECT * FROM ow_base_config',
'execTime' => 0.0013799667358398438,
'params' =>
array (
),
),
1 =>
array (
'query' => 'SELECT * FROM ow_base_language',
'execTime' => 0.00024890899658203125,
'params' =>
array (
),
),
2 =>
array (
'query' => 'SELECT * FROM ow_base_plugin',
'execTime' => 0.0004169940948486328,
'params' =>
array (
),
),
3 =>
array (
'query' => 'SELECT * FROM ow_base_language ORDER BY `order` ASC LIMIT 0, 1',
'execTime' => 0.000247955322265625,
'params' =>
array (
),
),
4 =>
array (
'query' => 'SELECT * FROM ow_base_language WHERE `id` = ?',
'execTime' => 0.00025200843811035156,
'params' =>
array (
0 => 1,
),
),
5 =>
array (
'query' => 'SELECT * FROM ow_base_language',
'execTime' => 0.0001380443572998047,
'params' =>
array (
),
),
6 =>
array (
'query' => 'SET TIME_ZONE = ?',
'execTime' => 0.00010395050048828125,
'params' =>
array (
0 => '-04:00',
),
),
7 =>
array (
'query' => 'SELECT * FROM ow_base_document WHERE `uri` = \'newsfeed/3227\' AND `isStatic` = 1 LIMIT 0, 1',
'execTime' => 0.0002231597900390625,
'params' =>
array (
),
),
8 =>
array (
'query' => 'SELECT * FROM ow_base_theme WHERE `key` = \'simplicity\' LIMIT 0, 1',
'execTime' => 0.0003600120544433594,
'params' =>
array (
),
),
9 =>
array (
'query' => 'SELECT * FROM ow_base_theme_content WHERE `themeId` = 956',
'execTime' => 0.0002498626708984375,
'params' =>
array (
),
),
10 =>
array (
'query' => 'SELECT * FROM ow_base_theme_master_page WHERE `themeId` = 956',
'execTime' => 0.00018215179443359375,
'params' =>
array (
),
),
11 =>
array (
'query' => 'SELECT * FROM ow_base_theme WHERE `key` = \'match_sprintally\' LIMIT 0, 1',
'execTime' => 0.00017404556274414062,
'params' =>
array (
),
),
12 =>
array (
'query' => 'SELECT * FROM ow_base_theme WHERE `key` = \'match_sprintally\' LIMIT 0, 1',
'execTime' => 0.00013589859008789062,
'params' =>
array (
),
),
13 =>
array (
'query' => 'SELECT * FROM ow_base_theme_content WHERE `themeId` = 959',
'execTime' => 0.00020599365234375,
'params' =>
array (
),
),
14 =>
array (
'query' => 'SELECT * FROM ow_base_theme_master_page WHERE `themeId` = 959',
'execTime' => 0.000164031982421875,
'params' =>
array (
),
),
15 =>
array (
'query' => 'SELECT * FROM ow_base_document WHERE `isStatic` = 1 AND `isMobile` = 0',
'execTime' => 0.0001499652862548828,
'params' =>
array (
),
),
16 =>
array (
'query' => '
SELECT *
FROM `ow_base_menu_item`
WHERE `visibleFor` & ? AND `externalUrl` IS NULL AND `type` = ?
ORDER BY `order` ASC
LIMIT 1',
'execTime' => 0.00036787986755371094,
'params' =>
array (
0 => 1,
1 => 'main',
),
),
17 =>
array (
'query' => '
SELECT `mi`.*, `mi`.`key` AS `menu_key`, `d`.`class`, `d`.`action`, `d`.`uri`, `d`.`isStatic`
FROM `ow_base_menu_item` AS `mi`
LEFT JOIN `ow_base_document` AS `d` ON ( `mi`.`documentKey` = `d`.`key`)
WHERE `mi`.`type` = :menuType ORDER BY `mi`.`order` ASC',
'execTime' => 0.0005359649658203125,
'params' =>
array (
'menuType' => 'main',
),
),
18 =>
array (
'query' => '
SELECT `mi`.*, `mi`.`key` AS `menu_key`, `d`.`class`, `d`.`action`, `d`.`uri`, `d`.`isStatic`
FROM `ow_base_menu_item` AS `mi`
LEFT JOIN `ow_base_document` AS `d` ON ( `mi`.`documentKey` = `d`.`key`)
WHERE `mi`.`type` = :menuType ORDER BY `mi`.`order` ASC',
'execTime' => 0.0005810260772705078,
'params' =>
array (
'menuType' => 'bottom',
),
),
19 =>
array (
'query' => 'SELECT * FROM ow_newsfeed_action WHERE `id` = 3227 LIMIT 0, 1',
'execTime' => 0.0007688999176025391,
'params' =>
array (
),
),
20 =>
array (
'query' => 'SELECT activity.* FROM ow_newsfeed_activity activity
WHERE activity.actionId IN(3227)
AND activity.activityType IN ("create", "subscribe") UNION SELECT a.* FROM ( SELECT DISTINCT activity.* FROM ow_newsfeed_activity activity
INNER JOIN `ow_base_user` base_user_table_alias ON base_user_table_alias.`id` = `activity`.`userId` LEFT JOIN `ow_base_user_suspend` base_user_suspend_table_alias ON base_user_suspend_table_alias.`userId` = `base_user_table_alias`.`id`
INNER JOIN ow_newsfeed_action_feed action_feed ON activity.id=action_feed.activityId
WHERE (`base_user_suspend_table_alias`.`id` IS NULL) AND activity.actionId = 3227 AND
(
activity.status=:s
AND activity.privacy=:peb
AND action_feed.feedType=:ft
AND action_feed.feedId=:fi
AND activity.visibility & :v
)
ORDER BY activity.timeStamp DESC, activity.id DESC LIMIT 100 ) a ORDER BY 7 DESC, 1 DESC ',
'execTime' => 0.000990152359008789,
'params' =>
array (
'ft' => 'user',
'fi' => '1',
's' => 'active',
'v' => 8,
'peb' => 'everybody',
),
),
21 =>
array (
'query' => 'SELECT COUNT(DISTINCT action.id) FROM ow_newsfeed_action action
INNER JOIN ow_newsfeed_activity activity ON action.id = activity.actionId
INNER JOIN ow_newsfeed_activity cactivity ON action.id = cactivity.actionId
INNER JOIN `ow_base_user` base_user_table_alias ON base_user_table_alias.`id` = `activity`.`userId` LEFT JOIN `ow_base_user_suspend` base_user_suspend_table_alias ON base_user_suspend_table_alias.`userId` = `base_user_table_alias`.`id`
INNER JOIN ow_newsfeed_action_feed action_feed ON activity.id=action_feed.activityId
WHERE (`base_user_suspend_table_alias`.`id` IS NULL)
AND activity.status=:s
AND activity.timeStamp<:st
AND activity.privacy=:peb
AND action_feed.feedType=:ft
AND action_feed.feedId=:fi
AND activity.visibility & :v
AND cactivity.status=:s
AND cactivity.activityType=:ac
AND cactivity.privacy=:peb
AND cactivity.visibility & :v',
'execTime' => 0.003693819046020508,
'params' =>
array (
'ft' => 'user',
'fi' => '1',
's' => 'active',
'v' => 8,
'peb' => 'everybody',
'ac' => 'create',
'st' => 1760860688,
),
),
22 =>
array (
'query' => 'SELECT * FROM ow_base_avatar WHERE `userId` IN(\'1\')',
'execTime' => 0.0002911090850830078,
'params' =>
array (
),
),
23 =>
array (
'query' => 'SELECT * FROM ow_base_user WHERE `id` IN(\'1\')',
'execTime' => 0.00022792816162109375,
'params' =>
array (
),
),
24 =>
array (
'query' => 'SELECT * FROM ow_base_question WHERE `name` IN(\'realname\')',
'execTime' => 0.00028705596923828125,
'params' =>
array (
),
),
25 =>
array (
'query' => 'SELECT * FROM ow_base_question_data WHERE `userId` IN(\'1\') AND `questionName` IN(\'realname\')',
'execTime' => 0.00022792816162109375,
'params' =>
array (
),
),
26 =>
array (
'query' => 'SELECT * FROM ow_base_authorization_group',
'execTime' => 0.00022292137145996094,
'params' =>
array (
),
),
27 =>
array (
'query' => 'SELECT * FROM ow_base_authorization_moderator ORDER BY id',
'execTime' => 0.00014901161193847656,
'params' =>
array (
),
),
28 =>
array (
'query' => 'SELECT * FROM ow_base_authorization_moderator_permission',
'execTime' => 0.00014209747314453125,
'params' =>
array (
),
),
29 =>
array (
'query' => 'SELECT * FROM ow_base_authorization_action',
'execTime' => 0.0004558563232421875,
'params' =>
array (
),
),
30 =>
array (
'query' => 'SELECT * FROM ow_base_authorization_permission',
'execTime' => 0.00038886070251464844,
'params' =>
array (
),
),
31 =>
array (
'query' => 'SELECT * FROM ow_base_authorization_role ORDER BY `sortOrder` ASC',
'execTime' => 0.000164031982421875,
'params' =>
array (
),
),
32 =>
array (
'query' => 'SELECT `userId`,`name`,`custom` FROM ow_base_authorization_user_role ur
INNER JOIN ow_base_authorization_role r ON ur.roleId=r.id
WHERE ur.userId IN(\'1\') AND r.displayLabel=1
ORDER BY sortOrder DESC',
'execTime' => 0.00024509429931640625,
'params' => NULL,
),
33 =>
array (
'query' => 'SELECT `ce`.`entityType`, `ce`.`entityId`, COUNT(*) AS `count` FROM `ow_base_comment` AS `c`
LEFT JOIN `ow_base_comment_entity` AS `ce` ON ( `c`.`commentEntityId` = `ce`.`id` )
WHERE (`ce`.`entityType` = ? AND `ce`.`entityId` = ? ) GROUP BY `ce`.`id`',
'execTime' => 0.0002148151397705078,
'params' =>
array (
0 => 'photo_comments',
1 => '222',
),
),
34 =>
array (
'query' => 'SELECT * FROM ow_newsfeed_like WHERE entityType="photo_comments" AND entityId="222"',
'execTime' => 0.00015997886657714844,
'params' => NULL,
),
35 =>
array (
'query' => 'SELECT * FROM ow_base_theme WHERE `key` = \'match_sprintally\' LIMIT 0, 1',
'execTime' => 0.00026607513427734375,
'params' =>
array (
),
),
36 =>
array (
'query' => 'SELECT * FROM ow_base_place WHERE `name` = \'index\' LIMIT 0, 1',
'execTime' => 0.00020694732666015625,
'params' =>
array (
),
),
37 =>
array (
'query' => 'SELECT * FROM ow_base_component_place_cache WHERE `placeId` = \'2\' AND `entityId` = 0 LIMIT 0, 1',
'execTime' => 0.00026297569274902344,
'params' =>
array (
),
),
38 =>
array (
'query' => 'SELECT * FROM ow_base_language',
'execTime' => 0.00014901161193847656,
'params' =>
array (
),
),
39 =>
array (
'query' => 'SELECT COUNT(*) FROM ow_base_invitation WHERE `userId` = 0',
'execTime' => 0.0001709461212158203,
'params' =>
array (
),
),
40 =>
array (
'query' => 'SELECT COUNT(*) FROM ow_base_invitation WHERE `userId` = 0 AND `viewed` = 0',
'execTime' => 0.00011396408081054688,
'params' =>
array (
),
),
41 =>
array (
'query' => 'SELECT * FROM ow_base_component_place_cache WHERE `placeId` = \'2\' AND `entityId` = 0 LIMIT 0, 1',
'execTime' => 0.0001971721649169922,
'params' =>
array (
),
),
),
'debugMode' => NULL,
'isProfilerEnabled' => true,
'profiler' =>
UTIL_Profiler::__set_state(array(
'checkPoints' =>
array (
'start' => 1760860688.904975,
),
'key' => 'db',
'result' =>
array (
),
'chkCounter' => 0,
)),
'queryExecTime' => 0.0001971721649169922,
'totalQueryExecTime' => 0.016114473342895508,
'queryCount' => 42,
'useCashe' => false,
)),
)),
'likeDao' =>
NEWSFEED_BOL_LikeDao::__set_state(array(
'dbo' =>
OW_Database::__set_state(array(
'connection' =>
PDO::__set_state(array(
)),
'affectedRows' => 1,
'queryLog' =>
array (
0 =>
array (
'query' => 'SELECT * FROM ow_base_config',
'execTime' => 0.0013799667358398438,
'params' =>
array (
),
),
1 =>
array (
'query' => 'SELECT * FROM ow_base_language',
'execTime' => 0.00024890899658203125,
'params' =>
array (
),
),
2 =>
array (
'query' => 'SELECT * FROM ow_base_plugin',
'execTime' => 0.0004169940948486328,
'params' =>
array (
),
),
3 =>
array (
'query' => 'SELECT * FROM ow_base_language ORDER BY `order` ASC LIMIT 0, 1',
'execTime' => 0.000247955322265625,
'params' =>
array (
),
),
4 =>
array (
'query' => 'SELECT * FROM ow_base_language WHERE `id` = ?',
'execTime' => 0.00025200843811035156,
'params' =>
array (
0 => 1,
),
),
5 =>
array (
'query' => 'SELECT * FROM ow_base_language',
'execTime' => 0.0001380443572998047,
'params' =>
array (
),
),
6 =>
array (
'query' => 'SET TIME_ZONE = ?',
'execTime' => 0.00010395050048828125,
'params' =>
array (
0 => '-04:00',
),
),
7 =>
array (
'query' => 'SELECT * FROM ow_base_document WHERE `uri` = \'newsfeed/3227\' AND `isStatic` = 1 LIMIT 0, 1',
'execTime' => 0.0002231597900390625,
'params' =>
array (
),
),
8 =>
array (
'query' => 'SELECT * FROM ow_base_theme WHERE `key` = \'simplicity\' LIMIT 0, 1',
'execTime' => 0.0003600120544433594,
'params' =>
array (
),
),
9 =>
array (
'query' => 'SELECT * FROM ow_base_theme_content WHERE `themeId` = 956',
'execTime' => 0.0002498626708984375,
'params' =>
array (
),
),
10 =>
array (
'query' => 'SELECT * FROM ow_base_theme_master_page WHERE `themeId` = 956',
'execTime' => 0.00018215179443359375,
'params' =>
array (
),
),
11 =>
array (
'query' => 'SELECT * FROM ow_base_theme WHERE `key` = \'match_sprintally\' LIMIT 0, 1',
'execTime' => 0.00017404556274414062,
'params' =>
array (
),
),
12 =>
array (
'query' => 'SELECT * FROM ow_base_theme WHERE `key` = \'match_sprintally\' LIMIT 0, 1',
'execTime' => 0.00013589859008789062,
'params' =>
array (
),
),
13 =>
array (
'query' => 'SELECT * FROM ow_base_theme_content WHERE `themeId` = 959',
'execTime' => 0.00020599365234375,
'params' =>
array (
),
),
14 =>
array (
'query' => 'SELECT * FROM ow_base_theme_master_page WHERE `themeId` = 959',
'execTime' => 0.000164031982421875,
'params' =>
array (
),
),
15 =>
array (
'query' => 'SELECT * FROM ow_base_document WHERE `isStatic` = 1 AND `isMobile` = 0',
'execTime' => 0.0001499652862548828,
'params' =>
array (
),
),
16 =>
array (
'query' => '
SELECT *
FROM `ow_base_menu_item`
WHERE `visibleFor` & ? AND `externalUrl` IS NULL AND `type` = ?
ORDER BY `order` ASC
LIMIT 1',
'execTime' => 0.00036787986755371094,
'params' =>
array (
0 => 1,
1 => 'main',
),
),
17 =>
array (
'query' => '
SELECT `mi`.*, `mi`.`key` AS `menu_key`, `d`.`class`, `d`.`action`, `d`.`uri`, `d`.`isStatic`
FROM `ow_base_menu_item` AS `mi`
LEFT JOIN `ow_base_document` AS `d` ON ( `mi`.`documentKey` = `d`.`key`)
WHERE `mi`.`type` = :menuType ORDER BY `mi`.`order` ASC',
'execTime' => 0.0005359649658203125,
'params' =>
array (
'menuType' => 'main',
),
),
18 =>
array (
'query' => '
SELECT `mi`.*, `mi`.`key` AS `menu_key`, `d`.`class`, `d`.`action`, `d`.`uri`, `d`.`isStatic`
FROM `ow_base_menu_item` AS `mi`
LEFT JOIN `ow_base_document` AS `d` ON ( `mi`.`documentKey` = `d`.`key`)
WHERE `mi`.`type` = :menuType ORDER BY `mi`.`order` ASC',
'execTime' => 0.0005810260772705078,
'params' =>
array (
'menuType' => 'bottom',
),
),
19 =>
array (
'query' => 'SELECT * FROM ow_newsfeed_action WHERE `id` = 3227 LIMIT 0, 1',
'execTime' => 0.0007688999176025391,
'params' =>
array (
),
),
20 =>
array (
'query' => 'SELECT activity.* FROM ow_newsfeed_activity activity
WHERE activity.actionId IN(3227)
AND activity.activityType IN ("create", "subscribe") UNION SELECT a.* FROM ( SELECT DISTINCT activity.* FROM ow_newsfeed_activity activity
INNER JOIN `ow_base_user` base_user_table_alias ON base_user_table_alias.`id` = `activity`.`userId` LEFT JOIN `ow_base_user_suspend` base_user_suspend_table_alias ON base_user_suspend_table_alias.`userId` = `base_user_table_alias`.`id`
INNER JOIN ow_newsfeed_action_feed action_feed ON activity.id=action_feed.activityId
WHERE (`base_user_suspend_table_alias`.`id` IS NULL) AND activity.actionId = 3227 AND
(
activity.status=:s
AND activity.privacy=:peb
AND action_feed.feedType=:ft
AND action_feed.feedId=:fi
AND activity.visibility & :v
)
ORDER BY activity.timeStamp DESC, activity.id DESC LIMIT 100 ) a ORDER BY 7 DESC, 1 DESC ',
'execTime' => 0.000990152359008789,
'params' =>
array (
'ft' => 'user',
'fi' => '1',
's' => 'active',
'v' => 8,
'peb' => 'everybody',
),
),
21 =>
array (
'query' => 'SELECT COUNT(DISTINCT action.id) FROM ow_newsfeed_action action
INNER JOIN ow_newsfeed_activity activity ON action.id = activity.actionId
INNER JOIN ow_newsfeed_activity cactivity ON action.id = cactivity.actionId
INNER JOIN `ow_base_user` base_user_table_alias ON base_user_table_alias.`id` = `activity`.`userId` LEFT JOIN `ow_base_user_suspend` base_user_suspend_table_alias ON base_user_suspend_table_alias.`userId` = `base_user_table_alias`.`id`
INNER JOIN ow_newsfeed_action_feed action_feed ON activity.id=action_feed.activityId
WHERE (`base_user_suspend_table_alias`.`id` IS NULL)
AND activity.status=:s
AND activity.timeStamp<:st
AND activity.privacy=:peb
AND action_feed.feedType=:ft
AND action_feed.feedId=:fi
AND activity.visibility & :v
AND cactivity.status=:s
AND cactivity.activityType=:ac
AND cactivity.privacy=:peb
AND cactivity.visibility & :v',
'execTime' => 0.003693819046020508,
'params' =>
array (
'ft' => 'user',
'fi' => '1',
's' => 'active',
'v' => 8,
'peb' => 'everybody',
'ac' => 'create',
'st' => 1760860688,
),
),
22 =>
array (
'query' => 'SELECT * FROM ow_base_avatar WHERE `userId` IN(\'1\')',
'execTime' => 0.0002911090850830078,
'params' =>
array (
),
),
23 =>
array (
'query' => 'SELECT * FROM ow_base_user WHERE `id` IN(\'1\')',
'execTime' => 0.00022792816162109375,
'params' =>
array (
),
),
24 =>
array (
'query' => 'SELECT * FROM ow_base_question WHERE `name` IN(\'realname\')',
'execTime' => 0.00028705596923828125,
'params' =>
array (
),
),
25 =>
array (
'query' => 'SELECT * FROM ow_base_question_data WHERE `userId` IN(\'1\') AND `questionName` IN(\'realname\')',
'execTime' => 0.00022792816162109375,
'params' =>
array (
),
),
26 =>
array (
'query' => 'SELECT * FROM ow_base_authorization_group',
'execTime' => 0.00022292137145996094,
'params' =>
array (
),
),
27 =>
array (
'query' => 'SELECT * FROM ow_base_authorization_moderator ORDER BY id',
'execTime' => 0.00014901161193847656,
'params' =>
array (
),
),
28 =>
array (
'query' => 'SELECT * FROM ow_base_authorization_moderator_permission',
'execTime' => 0.00014209747314453125,
'params' =>
array (
),
),
29 =>
array (
'query' => 'SELECT * FROM ow_base_authorization_action',
'execTime' => 0.0004558563232421875,
'params' =>
array (
),
),
30 =>
array (
'query' => 'SELECT * FROM ow_base_authorization_permission',
'execTime' => 0.00038886070251464844,
'params' =>
array (
),
),
31 =>
array (
'query' => 'SELECT * FROM ow_base_authorization_role ORDER BY `sortOrder` ASC',
'execTime' => 0.000164031982421875,
'params' =>
array (
),
),
32 =>
array (
'query' => 'SELECT `userId`,`name`,`custom` FROM ow_base_authorization_user_role ur
INNER JOIN ow_base_authorization_role r ON ur.roleId=r.id
WHERE ur.userId IN(\'1\') AND r.displayLabel=1
ORDER BY sortOrder DESC',
'execTime' => 0.00024509429931640625,
'params' => NULL,
),
33 =>
array (
'query' => 'SELECT `ce`.`entityType`, `ce`.`entityId`, COUNT(*) AS `count` FROM `ow_base_comment` AS `c`
LEFT JOIN `ow_base_comment_entity` AS `ce` ON ( `c`.`commentEntityId` = `ce`.`id` )
WHERE (`ce`.`entityType` = ? AND `ce`.`entityId` = ? ) GROUP BY `ce`.`id`',
'execTime' => 0.0002148151397705078,
'params' =>
array (
0 => 'photo_comments',
1 => '222',
),
),
34 =>
array (
'query' => 'SELECT * FROM ow_newsfeed_like WHERE entityType="photo_comments" AND entityId="222"',
'execTime' => 0.00015997886657714844,
'params' => NULL,
),
35 =>
array (
'query' => 'SELECT * FROM ow_base_theme WHERE `key` = \'match_sprintally\' LIMIT 0, 1',
'execTime' => 0.00026607513427734375,
'params' =>
array (
),
),
36 =>
array (
'query' => 'SELECT * FROM ow_base_place WHERE `name` = \'index\' LIMIT 0, 1',
'execTime' => 0.00020694732666015625,
'params' =>
array (
),
),
37 =>
array (
'query' => 'SELECT * FROM ow_base_component_place_cache WHERE `placeId` = \'2\' AND `entityId` = 0 LIMIT 0, 1',
'execTime' => 0.00026297569274902344,
'params' =>
array (
),
),
38 =>
array (
'query' => 'SELECT * FROM ow_base_language',
'execTime' => 0.00014901161193847656,
'params' =>
array (
),
),
39 =>
array (
'query' => 'SELECT COUNT(*) FROM ow_base_invitation WHERE `userId` = 0',
'execTime' => 0.0001709461212158203,
'params' =>
array (
),
),
40 =>
array (
'query' => 'SELECT COUNT(*) FROM ow_base_invitation WHERE `userId` = 0 AND `viewed` = 0',
'execTime' => 0.00011396408081054688,
'params' =>
array (
),
),
41 =>
array (
'query' => 'SELECT * FROM ow_base_component_place_cache WHERE `placeId` = \'2\' AND `entityId` = 0 LIMIT 0, 1',
'execTime' => 0.0001971721649169922,
'params' =>
array (
),
),
),
'debugMode' => NULL,
'isProfilerEnabled' => true,
'profiler' =>
UTIL_Profiler::__set_state(array(
'checkPoints' =>
array (
'start' => 1760860688.904975,
),
'key' => 'db',
'result' =>
array (
),
'chkCounter' => 0,
)),
'queryExecTime' => 0.0001971721649169922,
'totalQueryExecTime' => 0.016114473342895508,
'queryCount' => 42,
'useCashe' => false,
)),
)),
'statusDao' =>
NEWSFEED_BOL_StatusDao::__set_state(array(
'dbo' =>
OW_Database::__set_state(array(
'connection' =>
PDO::__set_state(array(
)),
'affectedRows' => 1,
'queryLog' =>
array (
0 =>
array (
'query' => 'SELECT * FROM ow_base_config',
'execTime' => 0.0013799667358398438,
'params' =>
array (
),
),
1 =>
array (
'query' => 'SELECT * FROM ow_base_language',
'execTime' => 0.00024890899658203125,
'params' =>
array (
),
),
2 =>
array (
'query' => 'SELECT * FROM ow_base_plugin',
'execTime' => 0.0004169940948486328,
'params' =>
array (
),
),
3 =>
array (
'query' => 'SELECT * FROM ow_base_language ORDER BY `order` ASC LIMIT 0, 1',
'execTime' => 0.000247955322265625,
'params' =>
array (
),
),
4 =>
array (
'query' => 'SELECT * FROM ow_base_language WHERE `id` = ?',
'execTime' => 0.00025200843811035156,
'params' =>
array (
0 => 1,
),
),
5 =>
array (
'query' => 'SELECT * FROM ow_base_language',
'execTime' => 0.0001380443572998047,
'params' =>
array (
),
),
6 =>
array (
'query' => 'SET TIME_ZONE = ?',
'execTime' => 0.00010395050048828125,
'params' =>
array (
0 => '-04:00',
),
),
7 =>
array (
'query' => 'SELECT * FROM ow_base_document WHERE `uri` = \'newsfeed/3227\' AND `isStatic` = 1 LIMIT 0, 1',
'execTime' => 0.0002231597900390625,
'params' =>
array (
),
),
8 =>
array (
'query' => 'SELECT * FROM ow_base_theme WHERE `key` = \'simplicity\' LIMIT 0, 1',
'execTime' => 0.0003600120544433594,
'params' =>
array (
),
),
9 =>
array (
'query' => 'SELECT * FROM ow_base_theme_content WHERE `themeId` = 956',
'execTime' => 0.0002498626708984375,
'params' =>
array (
),
),
10 =>
array (
'query' => 'SELECT * FROM ow_base_theme_master_page WHERE `themeId` = 956',
'execTime' => 0.00018215179443359375,
'params' =>
array (
),
),
11 =>
array (
'query' => 'SELECT * FROM ow_base_theme WHERE `key` = \'match_sprintally\' LIMIT 0, 1',
'execTime' => 0.00017404556274414062,
'params' =>
array (
),
),
12 =>
array (
'query' => 'SELECT * FROM ow_base_theme WHERE `key` = \'match_sprintally\' LIMIT 0, 1',
'execTime' => 0.00013589859008789062,
'params' =>
array (
),
),
13 =>
array (
'query' => 'SELECT * FROM ow_base_theme_content WHERE `themeId` = 959',
'execTime' => 0.00020599365234375,
'params' =>
array (
),
),
14 =>
array (
'query' => 'SELECT * FROM ow_base_theme_master_page WHERE `themeId` = 959',
'execTime' => 0.000164031982421875,
'params' =>
array (
),
),
15 =>
array (
'query' => 'SELECT * FROM ow_base_document WHERE `isStatic` = 1 AND `isMobile` = 0',
'execTime' => 0.0001499652862548828,
'params' =>
array (
),
),
16 =>
array (
'query' => '
SELECT *
FROM `ow_base_menu_item`
WHERE `visibleFor` & ? AND `externalUrl` IS NULL AND `type` = ?
ORDER BY `order` ASC
LIMIT 1',
'execTime' => 0.00036787986755371094,
'params' =>
array (
0 => 1,
1 => 'main',
),
),
17 =>
array (
'query' => '
SELECT `mi`.*, `mi`.`key` AS `menu_key`, `d`.`class`, `d`.`action`, `d`.`uri`, `d`.`isStatic`
FROM `ow_base_menu_item` AS `mi`
LEFT JOIN `ow_base_document` AS `d` ON ( `mi`.`documentKey` = `d`.`key`)
WHERE `mi`.`type` = :menuType ORDER BY `mi`.`order` ASC',
'execTime' => 0.0005359649658203125,
'params' =>
array (
'menuType' => 'main',
),
),
18 =>
array (
'query' => '
SELECT `mi`.*, `mi`.`key` AS `menu_key`, `d`.`class`, `d`.`action`, `d`.`uri`, `d`.`isStatic`
FROM `ow_base_menu_item` AS `mi`
LEFT JOIN `ow_base_document` AS `d` ON ( `mi`.`documentKey` = `d`.`key`)
WHERE `mi`.`type` = :menuType ORDER BY `mi`.`order` ASC',
'execTime' => 0.0005810260772705078,
'params' =>
array (
'menuType' => 'bottom',
),
),
19 =>
array (
'query' => 'SELECT * FROM ow_newsfeed_action WHERE `id` = 3227 LIMIT 0, 1',
'execTime' => 0.0007688999176025391,
'params' =>
array (
),
),
20 =>
array (
'query' => 'SELECT activity.* FROM ow_newsfeed_activity activity
WHERE activity.actionId IN(3227)
AND activity.activityType IN ("create", "subscribe") UNION SELECT a.* FROM ( SELECT DISTINCT activity.* FROM ow_newsfeed_activity activity
INNER JOIN `ow_base_user` base_user_table_alias ON base_user_table_alias.`id` = `activity`.`userId` LEFT JOIN `ow_base_user_suspend` base_user_suspend_table_alias ON base_user_suspend_table_alias.`userId` = `base_user_table_alias`.`id`
INNER JOIN ow_newsfeed_action_feed action_feed ON activity.id=action_feed.activityId
WHERE (`base_user_suspend_table_alias`.`id` IS NULL) AND activity.actionId = 3227 AND
(
activity.status=:s
AND activity.privacy=:peb
AND action_feed.feedType=:ft
AND action_feed.feedId=:fi
AND activity.visibility & :v
)
ORDER BY activity.timeStamp DESC, activity.id DESC LIMIT 100 ) a ORDER BY 7 DESC, 1 DESC ',
'execTime' => 0.000990152359008789,
'params' =>
array (
'ft' => 'user',
'fi' => '1',
's' => 'active',
'v' => 8,
'peb' => 'everybody',
),
),
21 =>
array (
'query' => 'SELECT COUNT(DISTINCT action.id) FROM ow_newsfeed_action action
INNER JOIN ow_newsfeed_activity activity ON action.id = activity.actionId
INNER JOIN ow_newsfeed_activity cactivity ON action.id = cactivity.actionId
INNER JOIN `ow_base_user` base_user_table_alias ON base_user_table_alias.`id` = `activity`.`userId` LEFT JOIN `ow_base_user_suspend` base_user_suspend_table_alias ON base_user_suspend_table_alias.`userId` = `base_user_table_alias`.`id`
INNER JOIN ow_newsfeed_action_feed action_feed ON activity.id=action_feed.activityId
WHERE (`base_user_suspend_table_alias`.`id` IS NULL)
AND activity.status=:s
AND activity.timeStamp<:st
AND activity.privacy=:peb
AND action_feed.feedType=:ft
AND action_feed.feedId=:fi
AND activity.visibility & :v
AND cactivity.status=:s
AND cactivity.activityType=:ac
AND cactivity.privacy=:peb
AND cactivity.visibility & :v',
'execTime' => 0.003693819046020508,
'params' =>
array (
'ft' => 'user',
'fi' => '1',
's' => 'active',
'v' => 8,
'peb' => 'everybody',
'ac' => 'create',
'st' => 1760860688,
),
),
22 =>
array (
'query' => 'SELECT * FROM ow_base_avatar WHERE `userId` IN(\'1\')',
'execTime' => 0.0002911090850830078,
'params' =>
array (
),
),
23 =>
array (
'query' => 'SELECT * FROM ow_base_user WHERE `id` IN(\'1\')',
'execTime' => 0.00022792816162109375,
'params' =>
array (
),
),
24 =>
array (
'query' => 'SELECT * FROM ow_base_question WHERE `name` IN(\'realname\')',
'execTime' => 0.00028705596923828125,
'params' =>
array (
),
),
25 =>
array (
'query' => 'SELECT * FROM ow_base_question_data WHERE `userId` IN(\'1\') AND `questionName` IN(\'realname\')',
'execTime' => 0.00022792816162109375,
'params' =>
array (
),
),
26 =>
array (
'query' => 'SELECT * FROM ow_base_authorization_group',
'execTime' => 0.00022292137145996094,
'params' =>
array (
),
),
27 =>
array (
'query' => 'SELECT * FROM ow_base_authorization_moderator ORDER BY id',
'execTime' => 0.00014901161193847656,
'params' =>
array (
),
),
28 =>
array (
'query' => 'SELECT * FROM ow_base_authorization_moderator_permission',
'execTime' => 0.00014209747314453125,
'params' =>
array (
),
),
29 =>
array (
'query' => 'SELECT * FROM ow_base_authorization_action',
'execTime' => 0.0004558563232421875,
'params' =>
array (
),
),
30 =>
array (
'query' => 'SELECT * FROM ow_base_authorization_permission',
'execTime' => 0.00038886070251464844,
'params' =>
array (
),
),
31 =>
array (
'query' => 'SELECT * FROM ow_base_authorization_role ORDER BY `sortOrder` ASC',
'execTime' => 0.000164031982421875,
'params' =>
array (
),
),
32 =>
array (
'query' => 'SELECT `userId`,`name`,`custom` FROM ow_base_authorization_user_role ur
INNER JOIN ow_base_authorization_role r ON ur.roleId=r.id
WHERE ur.userId IN(\'1\') AND r.displayLabel=1
ORDER BY sortOrder DESC',
'execTime' => 0.00024509429931640625,
'params' => NULL,
),
33 =>
array (
'query' => 'SELECT `ce`.`entityType`, `ce`.`entityId`, COUNT(*) AS `count` FROM `ow_base_comment` AS `c`
LEFT JOIN `ow_base_comment_entity` AS `ce` ON ( `c`.`commentEntityId` = `ce`.`id` )
WHERE (`ce`.`entityType` = ? AND `ce`.`entityId` = ? ) GROUP BY `ce`.`id`',
'execTime' => 0.0002148151397705078,
'params' =>
array (
0 => 'photo_comments',
1 => '222',
),
),
34 =>
array (
'query' => 'SELECT * FROM ow_newsfeed_like WHERE entityType="photo_comments" AND entityId="222"',
'execTime' => 0.00015997886657714844,
'params' => NULL,
),
35 =>
array (
'query' => 'SELECT * FROM ow_base_theme WHERE `key` = \'match_sprintally\' LIMIT 0, 1',
'execTime' => 0.00026607513427734375,
'params' =>
array (
),
),
36 =>
array (
'query' => 'SELECT * FROM ow_base_place WHERE `name` = \'index\' LIMIT 0, 1',
'execTime' => 0.00020694732666015625,
'params' =>
array (
),
),
37 =>
array (
'query' => 'SELECT * FROM ow_base_component_place_cache WHERE `placeId` = \'2\' AND `entityId` = 0 LIMIT 0, 1',
'execTime' => 0.00026297569274902344,
'params' =>
array (
),
),
38 =>
array (
'query' => 'SELECT * FROM ow_base_language',
'execTime' => 0.00014901161193847656,
'params' =>
array (
),
),
39 =>
array (
'query' => 'SELECT COUNT(*) FROM ow_base_invitation WHERE `userId` = 0',
'execTime' => 0.0001709461212158203,
'params' =>
array (
),
),
40 =>
array (
'query' => 'SELECT COUNT(*) FROM ow_base_invitation WHERE `userId` = 0 AND `viewed` = 0',
'execTime' => 0.00011396408081054688,
'params' =>
array (
),
),
41 =>
array (
'query' => 'SELECT * FROM ow_base_component_place_cache WHERE `placeId` = \'2\' AND `entityId` = 0 LIMIT 0, 1',
'execTime' => 0.0001971721649169922,
'params' =>
array (
),
),
),
'debugMode' => NULL,
'isProfilerEnabled' => true,
'profiler' =>
UTIL_Profiler::__set_state(array(
'checkPoints' =>
array (
'start' => 1760860688.904975,
),
'key' => 'db',
'result' =>
array (
),
'chkCounter' => 0,
)),
'queryExecTime' => 0.0001971721649169922,
'totalQueryExecTime' => 0.016114473342895508,
'queryCount' => 42,
'useCashe' => false,
)),
)),
'activityDao' =>
NEWSFEED_BOL_ActivityDao::__set_state(array(
'dbo' =>
OW_Database::__set_state(array(
'connection' =>
PDO::__set_state(array(
)),
'affectedRows' => 1,
'queryLog' =>
array (
0 =>
array (
'query' => 'SELECT * FROM ow_base_config',
'execTime' => 0.0013799667358398438,
'params' =>
array (
),
),
1 =>
array (
'query' => 'SELECT * FROM ow_base_language',
'execTime' => 0.00024890899658203125,
'params' =>
array (
),
),
2 =>
array (
'query' => 'SELECT * FROM ow_base_plugin',
'execTime' => 0.0004169940948486328,
'params' =>
array (
),
),
3 =>
array (
'query' => 'SELECT * FROM ow_base_language ORDER BY `order` ASC LIMIT 0, 1',
'execTime' => 0.000247955322265625,
'params' =>
array (
),
),
4 =>
array (
'query' => 'SELECT * FROM ow_base_language WHERE `id` = ?',
'execTime' => 0.00025200843811035156,
'params' =>
array (
0 => 1,
),
),
5 =>
array (
'query' => 'SELECT * FROM ow_base_language',
'execTime' => 0.0001380443572998047,
'params' =>
array (
),
),
6 =>
array (
'query' => 'SET TIME_ZONE = ?',
'execTime' => 0.00010395050048828125,
'params' =>
array (
0 => '-04:00',
),
),
7 =>
array (
'query' => 'SELECT * FROM ow_base_document WHERE `uri` = \'newsfeed/3227\' AND `isStatic` = 1 LIMIT 0, 1',
'execTime' => 0.0002231597900390625,
'params' =>
array (
),
),
8 =>
array (
'query' => 'SELECT * FROM ow_base_theme WHERE `key` = \'simplicity\' LIMIT 0, 1',
'execTime' => 0.0003600120544433594,
'params' =>
array (
),
),
9 =>
array (
'query' => 'SELECT * FROM ow_base_theme_content WHERE `themeId` = 956',
'execTime' => 0.0002498626708984375,
'params' =>
array (
),
),
10 =>
array (
'query' => 'SELECT * FROM ow_base_theme_master_page WHERE `themeId` = 956',
'execTime' => 0.00018215179443359375,
'params' =>
array (
),
),
11 =>
array (
'query' => 'SELECT * FROM ow_base_theme WHERE `key` = \'match_sprintally\' LIMIT 0, 1',
'execTime' => 0.00017404556274414062,
'params' =>
array (
),
),
12 =>
array (
'query' => 'SELECT * FROM ow_base_theme WHERE `key` = \'match_sprintally\' LIMIT 0, 1',
'execTime' => 0.00013589859008789062,
'params' =>
array (
),
),
13 =>
array (
'query' => 'SELECT * FROM ow_base_theme_content WHERE `themeId` = 959',
'execTime' => 0.00020599365234375,
'params' =>
array (
),
),
14 =>
array (
'query' => 'SELECT * FROM ow_base_theme_master_page WHERE `themeId` = 959',
'execTime' => 0.000164031982421875,
'params' =>
array (
),
),
15 =>
array (
'query' => 'SELECT * FROM ow_base_document WHERE `isStatic` = 1 AND `isMobile` = 0',
'execTime' => 0.0001499652862548828,
'params' =>
array (
),
),
16 =>
array (
'query' => '
SELECT *
FROM `ow_base_menu_item`
WHERE `visibleFor` & ? AND `externalUrl` IS NULL AND `type` = ?
ORDER BY `order` ASC
LIMIT 1',
'execTime' => 0.00036787986755371094,
'params' =>
array (
0 => 1,
1 => 'main',
),
),
17 =>
array (
'query' => '
SELECT `mi`.*, `mi`.`key` AS `menu_key`, `d`.`class`, `d`.`action`, `d`.`uri`, `d`.`isStatic`
FROM `ow_base_menu_item` AS `mi`
LEFT JOIN `ow_base_document` AS `d` ON ( `mi`.`documentKey` = `d`.`key`)
WHERE `mi`.`type` = :menuType ORDER BY `mi`.`order` ASC',
'execTime' => 0.0005359649658203125,
'params' =>
array (
'menuType' => 'main',
),
),
18 =>
array (
'query' => '
SELECT `mi`.*, `mi`.`key` AS `menu_key`, `d`.`class`, `d`.`action`, `d`.`uri`, `d`.`isStatic`
FROM `ow_base_menu_item` AS `mi`
LEFT JOIN `ow_base_document` AS `d` ON ( `mi`.`documentKey` = `d`.`key`)
WHERE `mi`.`type` = :menuType ORDER BY `mi`.`order` ASC',
'execTime' => 0.0005810260772705078,
'params' =>
array (
'menuType' => 'bottom',
),
),
19 =>
array (
'query' => 'SELECT * FROM ow_newsfeed_action WHERE `id` = 3227 LIMIT 0, 1',
'execTime' => 0.0007688999176025391,
'params' =>
array (
),
),
20 =>
array (
'query' => 'SELECT activity.* FROM ow_newsfeed_activity activity
WHERE activity.actionId IN(3227)
AND activity.activityType IN ("create", "subscribe") UNION SELECT a.* FROM ( SELECT DISTINCT activity.* FROM ow_newsfeed_activity activity
INNER JOIN `ow_base_user` base_user_table_alias ON base_user_table_alias.`id` = `activity`.`userId` LEFT JOIN `ow_base_user_suspend` base_user_suspend_table_alias ON base_user_suspend_table_alias.`userId` = `base_user_table_alias`.`id`
INNER JOIN ow_newsfeed_action_feed action_feed ON activity.id=action_feed.activityId
WHERE (`base_user_suspend_table_alias`.`id` IS NULL) AND activity.actionId = 3227 AND
(
activity.status=:s
AND activity.privacy=:peb
AND action_feed.feedType=:ft
AND action_feed.feedId=:fi
AND activity.visibility & :v
)
ORDER BY activity.timeStamp DESC, activity.id DESC LIMIT 100 ) a ORDER BY 7 DESC, 1 DESC ',
'execTime' => 0.000990152359008789,
'params' =>
array (
'ft' => 'user',
'fi' => '1',
's' => 'active',
'v' => 8,
'peb' => 'everybody',
),
),
21 =>
array (
'query' => 'SELECT COUNT(DISTINCT action.id) FROM ow_newsfeed_action action
INNER JOIN ow_newsfeed_activity activity ON action.id = activity.actionId
INNER JOIN ow_newsfeed_activity cactivity ON action.id = cactivity.actionId
INNER JOIN `ow_base_user` base_user_table_alias ON base_user_table_alias.`id` = `activity`.`userId` LEFT JOIN `ow_base_user_suspend` base_user_suspend_table_alias ON base_user_suspend_table_alias.`userId` = `base_user_table_alias`.`id`
INNER JOIN ow_newsfeed_action_feed action_feed ON activity.id=action_feed.activityId
WHERE (`base_user_suspend_table_alias`.`id` IS NULL)
AND activity.status=:s
AND activity.timeStamp<:st
AND activity.privacy=:peb
AND action_feed.feedType=:ft
AND action_feed.feedId=:fi
AND activity.visibility & :v
AND cactivity.status=:s
AND cactivity.activityType=:ac
AND cactivity.privacy=:peb
AND cactivity.visibility & :v',
'execTime' => 0.003693819046020508,
'params' =>
array (
'ft' => 'user',
'fi' => '1',
's' => 'active',
'v' => 8,
'peb' => 'everybody',
'ac' => 'create',
'st' => 1760860688,
),
),
22 =>
array (
'query' => 'SELECT * FROM ow_base_avatar WHERE `userId` IN(\'1\')',
'execTime' => 0.0002911090850830078,
'params' =>
array (
),
),
23 =>
array (
'query' => 'SELECT * FROM ow_base_user WHERE `id` IN(\'1\')',
'execTime' => 0.00022792816162109375,
'params' =>
array (
),
),
24 =>
array (
'query' => 'SELECT * FROM ow_base_question WHERE `name` IN(\'realname\')',
'execTime' => 0.00028705596923828125,
'params' =>
array (
),
),
25 =>
array (
'query' => 'SELECT * FROM ow_base_question_data WHERE `userId` IN(\'1\') AND `questionName` IN(\'realname\')',
'execTime' => 0.00022792816162109375,
'params' =>
array (
),
),
26 =>
array (
'query' => 'SELECT * FROM ow_base_authorization_group',
'execTime' => 0.00022292137145996094,
'params' =>
array (
),
),
27 =>
array (
'query' => 'SELECT * FROM ow_base_authorization_moderator ORDER BY id',
'execTime' => 0.00014901161193847656,
'params' =>
array (
),
),
28 =>
array (
'query' => 'SELECT * FROM ow_base_authorization_moderator_permission',
'execTime' => 0.00014209747314453125,
'params' =>
array (
),
),
29 =>
array (
'query' => 'SELECT * FROM ow_base_authorization_action',
'execTime' => 0.0004558563232421875,
'params' =>
array (
),
),
30 =>
array (
'query' => 'SELECT * FROM ow_base_authorization_permission',
'execTime' => 0.00038886070251464844,
'params' =>
array (
),
),
31 =>
array (
'query' => 'SELECT * FROM ow_base_authorization_role ORDER BY `sortOrder` ASC',
'execTime' => 0.000164031982421875,
'params' =>
array (
),
),
32 =>
array (
'query' => 'SELECT `userId`,`name`,`custom` FROM ow_base_authorization_user_role ur
INNER JOIN ow_base_authorization_role r ON ur.roleId=r.id
WHERE ur.userId IN(\'1\') AND r.displayLabel=1
ORDER BY sortOrder DESC',
'execTime' => 0.00024509429931640625,
'params' => NULL,
),
33 =>
array (
'query' => 'SELECT `ce`.`entityType`, `ce`.`entityId`, COUNT(*) AS `count` FROM `ow_base_comment` AS `c`
LEFT JOIN `ow_base_comment_entity` AS `ce` ON ( `c`.`commentEntityId` = `ce`.`id` )
WHERE (`ce`.`entityType` = ? AND `ce`.`entityId` = ? ) GROUP BY `ce`.`id`',
'execTime' => 0.0002148151397705078,
'params' =>
array (
0 => 'photo_comments',
1 => '222',
),
),
34 =>
array (
'query' => 'SELECT * FROM ow_newsfeed_like WHERE entityType="photo_comments" AND entityId="222"',
'execTime' => 0.00015997886657714844,
'params' => NULL,
),
35 =>
array (
'query' => 'SELECT * FROM ow_base_theme WHERE `key` = \'match_sprintally\' LIMIT 0, 1',
'execTime' => 0.00026607513427734375,
'params' =>
array (
),
),
36 =>
array (
'query' => 'SELECT * FROM ow_base_place WHERE `name` = \'index\' LIMIT 0, 1',
'execTime' => 0.00020694732666015625,
'params' =>
array (
),
),
37 =>
array (
'query' => 'SELECT * FROM ow_base_component_place_cache WHERE `placeId` = \'2\' AND `entityId` = 0 LIMIT 0, 1',
'execTime' => 0.00026297569274902344,
'params' =>
array (
),
),
38 =>
array (
'query' => 'SELECT * FROM ow_base_language',
'execTime' => 0.00014901161193847656,
'params' =>
array (
),
),
39 =>
array (
'query' => 'SELECT COUNT(*) FROM ow_base_invitation WHERE `userId` = 0',
'execTime' => 0.0001709461212158203,
'params' =>
array (
),
),
40 =>
array (
'query' => 'SELECT COUNT(*) FROM ow_base_invitation WHERE `userId` = 0 AND `viewed` = 0',
'execTime' => 0.00011396408081054688,
'params' =>
array (
),
),
41 =>
array (
'query' => 'SELECT * FROM ow_base_component_place_cache WHERE `placeId` = \'2\' AND `entityId` = 0 LIMIT 0, 1',
'execTime' => 0.0001971721649169922,
'params' =>
array (
),
),
),
'debugMode' => NULL,
'isProfilerEnabled' => true,
'profiler' =>
UTIL_Profiler::__set_state(array(
'checkPoints' =>
array (
'start' => 1760860688.904975,
),
'key' => 'db',
'result' =>
array (
),
'chkCounter' => 0,
)),
'queryExecTime' => 0.0001971721649169922,
'totalQueryExecTime' => 0.016114473342895508,
'queryCount' => 42,
'useCashe' => false,
)),
)),
'actionSetDao' =>
NEWSFEED_BOL_ActionSetDao::__set_state(array(
'dbo' =>
OW_Database::__set_state(array(
'connection' =>
PDO::__set_state(array(
)),
'affectedRows' => 1,
'queryLog' =>
array (
0 =>
array (
'query' => 'SELECT * FROM ow_base_config',
'execTime' => 0.0013799667358398438,
'params' =>
array (
),
),
1 =>
array (
'query' => 'SELECT * FROM ow_base_language',
'execTime' => 0.00024890899658203125,
'params' =>
array (
),
),
2 =>
array (
'query' => 'SELECT * FROM ow_base_plugin',
'execTime' => 0.0004169940948486328,
'params' =>
array (
),
),
3 =>
array (
'query' => 'SELECT * FROM ow_base_language ORDER BY `order` ASC LIMIT 0, 1',
'execTime' => 0.000247955322265625,
'params' =>
array (
),
),
4 =>
array (
'query' => 'SELECT * FROM ow_base_language WHERE `id` = ?',
'execTime' => 0.00025200843811035156,
'params' =>
array (
0 => 1,
),
),
5 =>
array (
'query' => 'SELECT * FROM ow_base_language',
'execTime' => 0.0001380443572998047,
'params' =>
array (
),
),
6 =>
array (
'query' => 'SET TIME_ZONE = ?',
'execTime' => 0.00010395050048828125,
'params' =>
array (
0 => '-04:00',
),
),
7 =>
array (
'query' => 'SELECT * FROM ow_base_document WHERE `uri` = \'newsfeed/3227\' AND `isStatic` = 1 LIMIT 0, 1',
'execTime' => 0.0002231597900390625,
'params' =>
array (
),
),
8 =>
array (
'query' => 'SELECT * FROM ow_base_theme WHERE `key` = \'simplicity\' LIMIT 0, 1',
'execTime' => 0.0003600120544433594,
'params' =>
array (
),
),
9 =>
array (
'query' => 'SELECT * FROM ow_base_theme_content WHERE `themeId` = 956',
'execTime' => 0.0002498626708984375,
'params' =>
array (
),
),
10 =>
array (
'query' => 'SELECT * FROM ow_base_theme_master_page WHERE `themeId` = 956',
'execTime' => 0.00018215179443359375,
'params' =>
array (
),
),
11 =>
array (
'query' => 'SELECT * FROM ow_base_theme WHERE `key` = \'match_sprintally\' LIMIT 0, 1',
'execTime' => 0.00017404556274414062,
'params' =>
array (
),
),
12 =>
array (
'query' => 'SELECT * FROM ow_base_theme WHERE `key` = \'match_sprintally\' LIMIT 0, 1',
'execTime' => 0.00013589859008789062,
'params' =>
array (
),
),
13 =>
array (
'query' => 'SELECT * FROM ow_base_theme_content WHERE `themeId` = 959',
'execTime' => 0.00020599365234375,
'params' =>
array (
),
),
14 =>
array (
'query' => 'SELECT * FROM ow_base_theme_master_page WHERE `themeId` = 959',
'execTime' => 0.000164031982421875,
'params' =>
array (
),
),
15 =>
array (
'query' => 'SELECT * FROM ow_base_document WHERE `isStatic` = 1 AND `isMobile` = 0',
'execTime' => 0.0001499652862548828,
'params' =>
array (
),
),
16 =>
array (
'query' => '
SELECT *
FROM `ow_base_menu_item`
WHERE `visibleFor` & ? AND `externalUrl` IS NULL AND `type` = ?
ORDER BY `order` ASC
LIMIT 1',
'execTime' => 0.00036787986755371094,
'params' =>
array (
0 => 1,
1 => 'main',
),
),
17 =>
array (
'query' => '
SELECT `mi`.*, `mi`.`key` AS `menu_key`, `d`.`class`, `d`.`action`, `d`.`uri`, `d`.`isStatic`
FROM `ow_base_menu_item` AS `mi`
LEFT JOIN `ow_base_document` AS `d` ON ( `mi`.`documentKey` = `d`.`key`)
WHERE `mi`.`type` = :menuType ORDER BY `mi`.`order` ASC',
'execTime' => 0.0005359649658203125,
'params' =>
array (
'menuType' => 'main',
),
),
18 =>
array (
'query' => '
SELECT `mi`.*, `mi`.`key` AS `menu_key`, `d`.`class`, `d`.`action`, `d`.`uri`, `d`.`isStatic`
FROM `ow_base_menu_item` AS `mi`
LEFT JOIN `ow_base_document` AS `d` ON ( `mi`.`documentKey` = `d`.`key`)
WHERE `mi`.`type` = :menuType ORDER BY `mi`.`order` ASC',
'execTime' => 0.0005810260772705078,
'params' =>
array (
'menuType' => 'bottom',
),
),
19 =>
array (
'query' => 'SELECT * FROM ow_newsfeed_action WHERE `id` = 3227 LIMIT 0, 1',
'execTime' => 0.0007688999176025391,
'params' =>
array (
),
),
20 =>
array (
'query' => 'SELECT activity.* FROM ow_newsfeed_activity activity
WHERE activity.actionId IN(3227)
AND activity.activityType IN ("create", "subscribe") UNION SELECT a.* FROM ( SELECT DISTINCT activity.* FROM ow_newsfeed_activity activity
INNER JOIN `ow_base_user` base_user_table_alias ON base_user_table_alias.`id` = `activity`.`userId` LEFT JOIN `ow_base_user_suspend` base_user_suspend_table_alias ON base_user_suspend_table_alias.`userId` = `base_user_table_alias`.`id`
INNER JOIN ow_newsfeed_action_feed action_feed ON activity.id=action_feed.activityId
WHERE (`base_user_suspend_table_alias`.`id` IS NULL) AND activity.actionId = 3227 AND
(
activity.status=:s
AND activity.privacy=:peb
AND action_feed.feedType=:ft
AND action_feed.feedId=:fi
AND activity.visibility & :v
)
ORDER BY activity.timeStamp DESC, activity.id DESC LIMIT 100 ) a ORDER BY 7 DESC, 1 DESC ',
'execTime' => 0.000990152359008789,
'params' =>
array (
'ft' => 'user',
'fi' => '1',
's' => 'active',
'v' => 8,
'peb' => 'everybody',
),
),
21 =>
array (
'query' => 'SELECT COUNT(DISTINCT action.id) FROM ow_newsfeed_action action
INNER JOIN ow_newsfeed_activity activity ON action.id = activity.actionId
INNER JOIN ow_newsfeed_activity cactivity ON action.id = cactivity.actionId
INNER JOIN `ow_base_user` base_user_table_alias ON base_user_table_alias.`id` = `activity`.`userId` LEFT JOIN `ow_base_user_suspend` base_user_suspend_table_alias ON base_user_suspend_table_alias.`userId` = `base_user_table_alias`.`id`
INNER JOIN ow_newsfeed_action_feed action_feed ON activity.id=action_feed.activityId
WHERE (`base_user_suspend_table_alias`.`id` IS NULL)
AND activity.status=:s
AND activity.timeStamp<:st
AND activity.privacy=:peb
AND action_feed.feedType=:ft
AND action_feed.feedId=:fi
AND activity.visibility & :v
AND cactivity.status=:s
AND cactivity.activityType=:ac
AND cactivity.privacy=:peb
AND cactivity.visibility & :v',
'execTime' => 0.003693819046020508,
'params' =>
array (
'ft' => 'user',
'fi' => '1',
's' => 'active',
'v' => 8,
'peb' => 'everybody',
'ac' => 'create',
'st' => 1760860688,
),
),
22 =>
array (
'query' => 'SELECT * FROM ow_base_avatar WHERE `userId` IN(\'1\')',
'execTime' => 0.0002911090850830078,
'params' =>
array (
),
),
23 =>
array (
'query' => 'SELECT * FROM ow_base_user WHERE `id` IN(\'1\')',
'execTime' => 0.00022792816162109375,
'params' =>
array (
),
),
24 =>
array (
'query' => 'SELECT * FROM ow_base_question WHERE `name` IN(\'realname\')',
'execTime' => 0.00028705596923828125,
'params' =>
array (
),
),
25 =>
array (
'query' => 'SELECT * FROM ow_base_question_data WHERE `userId` IN(\'1\') AND `questionName` IN(\'realname\')',
'execTime' => 0.00022792816162109375,
'params' =>
array (
),
),
26 =>
array (
'query' => 'SELECT * FROM ow_base_authorization_group',
'execTime' => 0.00022292137145996094,
'params' =>
array (
),
),
27 =>
array (
'query' => 'SELECT * FROM ow_base_authorization_moderator ORDER BY id',
'execTime' => 0.00014901161193847656,
'params' =>
array (
),
),
28 =>
array (
'query' => 'SELECT * FROM ow_base_authorization_moderator_permission',
'execTime' => 0.00014209747314453125,
'params' =>
array (
),
),
29 =>
array (
'query' => 'SELECT * FROM ow_base_authorization_action',
'execTime' => 0.0004558563232421875,
'params' =>
array (
),
),
30 =>
array (
'query' => 'SELECT * FROM ow_base_authorization_permission',
'execTime' => 0.00038886070251464844,
'params' =>
array (
),
),
31 =>
array (
'query' => 'SELECT * FROM ow_base_authorization_role ORDER BY `sortOrder` ASC',
'execTime' => 0.000164031982421875,
'params' =>
array (
),
),
32 =>
array (
'query' => 'SELECT `userId`,`name`,`custom` FROM ow_base_authorization_user_role ur
INNER JOIN ow_base_authorization_role r ON ur.roleId=r.id
WHERE ur.userId IN(\'1\') AND r.displayLabel=1
ORDER BY sortOrder DESC',
'execTime' => 0.00024509429931640625,
'params' => NULL,
),
33 =>
array (
'query' => 'SELECT `ce`.`entityType`, `ce`.`entityId`, COUNT(*) AS `count` FROM `ow_base_comment` AS `c`
LEFT JOIN `ow_base_comment_entity` AS `ce` ON ( `c`.`commentEntityId` = `ce`.`id` )
WHERE (`ce`.`entityType` = ? AND `ce`.`entityId` = ? ) GROUP BY `ce`.`id`',
'execTime' => 0.0002148151397705078,
'params' =>
array (
0 => 'photo_comments',
1 => '222',
),
),
34 =>
array (
'query' => 'SELECT * FROM ow_newsfeed_like WHERE entityType="photo_comments" AND entityId="222"',
'execTime' => 0.00015997886657714844,
'params' => NULL,
),
35 =>
array (
'query' => 'SELECT * FROM ow_base_theme WHERE `key` = \'match_sprintally\' LIMIT 0, 1',
'execTime' => 0.00026607513427734375,
'params' =>
array (
),
),
36 =>
array (
'query' => 'SELECT * FROM ow_base_place WHERE `name` = \'index\' LIMIT 0, 1',
'execTime' => 0.00020694732666015625,
'params' =>
array (
),
),
37 =>
array (
'query' => 'SELECT * FROM ow_base_component_place_cache WHERE `placeId` = \'2\' AND `entityId` = 0 LIMIT 0, 1',
'execTime' => 0.00026297569274902344,
'params' =>
array (
),
),
38 =>
array (
'query' => 'SELECT * FROM ow_base_language',
'execTime' => 0.00014901161193847656,
'params' =>
array (
),
),
39 =>
array (
'query' => 'SELECT COUNT(*) FROM ow_base_invitation WHERE `userId` = 0',
'execTime' => 0.0001709461212158203,
'params' =>
array (
),
),
40 =>
array (
'query' => 'SELECT COUNT(*) FROM ow_base_invitation WHERE `userId` = 0 AND `viewed` = 0',
'execTime' => 0.00011396408081054688,
'params' =>
array (
),
),
41 =>
array (
'query' => 'SELECT * FROM ow_base_component_place_cache WHERE `placeId` = \'2\' AND `entityId` = 0 LIMIT 0, 1',
'execTime' => 0.0001971721649169922,
'params' =>
array (
),
),
),
'debugMode' => NULL,
'isProfilerEnabled' => true,
'profiler' =>
UTIL_Profiler::__set_state(array(
'checkPoints' =>
array (
'start' => 1760860688.904975,
),
'key' => 'db',
'result' =>
array (
),
'chkCounter' => 0,
)),
'queryExecTime' => 0.0001971721649169922,
'totalQueryExecTime' => 0.016114473342895508,
'queryCount' => 42,
'useCashe' => false,
)),
)),
'cronCommandDao' =>
NEWSFEED_BOL_CronCommandDao::__set_state(array(
'dbo' =>
OW_Database::__set_state(array(
'connection' =>
PDO::__set_state(array(
)),
'affectedRows' => 1,
'queryLog' =>
array (
0 =>
array (
'query' => 'SELECT * FROM ow_base_config',
'execTime' => 0.0013799667358398438,
'params' =>
array (
),
),
1 =>
array (
'query' => 'SELECT * FROM ow_base_language',
'execTime' => 0.00024890899658203125,
'params' =>
array (
),
),
2 =>
array (
'query' => 'SELECT * FROM ow_base_plugin',
'execTime' => 0.0004169940948486328,
'params' =>
array (
),
),
3 =>
array (
'query' => 'SELECT * FROM ow_base_language ORDER BY `order` ASC LIMIT 0, 1',
'execTime' => 0.000247955322265625,
'params' =>
array (
),
),
4 =>
array (
'query' => 'SELECT * FROM ow_base_language WHERE `id` = ?',
'execTime' => 0.00025200843811035156,
'params' =>
array (
0 => 1,
),
),
5 =>
array (
'query' => 'SELECT * FROM ow_base_language',
'execTime' => 0.0001380443572998047,
'params' =>
array (
),
),
6 =>
array (
'query' => 'SET TIME_ZONE = ?',
'execTime' => 0.00010395050048828125,
'params' =>
array (
0 => '-04:00',
),
),
7 =>
array (
'query' => 'SELECT * FROM ow_base_document WHERE `uri` = \'newsfeed/3227\' AND `isStatic` = 1 LIMIT 0, 1',
'execTime' => 0.0002231597900390625,
'params' =>
array (
),
),
8 =>
array (
'query' => 'SELECT * FROM ow_base_theme WHERE `key` = \'simplicity\' LIMIT 0, 1',
'execTime' => 0.0003600120544433594,
'params' =>
array (
),
),
9 =>
array (
'query' => 'SELECT * FROM ow_base_theme_content WHERE `themeId` = 956',
'execTime' => 0.0002498626708984375,
'params' =>
array (
),
),
10 =>
array (
'query' => 'SELECT * FROM ow_base_theme_master_page WHERE `themeId` = 956',
'execTime' => 0.00018215179443359375,
'params' =>
array (
),
),
11 =>
array (
'query' => 'SELECT * FROM ow_base_theme WHERE `key` = \'match_sprintally\' LIMIT 0, 1',
'execTime' => 0.00017404556274414062,
'params' =>
array (
),
),
12 =>
array (
'query' => 'SELECT * FROM ow_base_theme WHERE `key` = \'match_sprintally\' LIMIT 0, 1',
'execTime' => 0.00013589859008789062,
'params' =>
array (
),
),
13 =>
array (
'query' => 'SELECT * FROM ow_base_theme_content WHERE `themeId` = 959',
'execTime' => 0.00020599365234375,
'params' =>
array (
),
),
14 =>
array (
'query' => 'SELECT * FROM ow_base_theme_master_page WHERE `themeId` = 959',
'execTime' => 0.000164031982421875,
'params' =>
array (
),
),
15 =>
array (
'query' => 'SELECT * FROM ow_base_document WHERE `isStatic` = 1 AND `isMobile` = 0',
'execTime' => 0.0001499652862548828,
'params' =>
array (
),
),
16 =>
array (
'query' => '
SELECT *
FROM `ow_base_menu_item`
WHERE `visibleFor` & ? AND `externalUrl` IS NULL AND `type` = ?
ORDER BY `order` ASC
LIMIT 1',
'execTime' => 0.00036787986755371094,
'params' =>
array (
0 => 1,
1 => 'main',
),
),
17 =>
array (
'query' => '
SELECT `mi`.*, `mi`.`key` AS `menu_key`, `d`.`class`, `d`.`action`, `d`.`uri`, `d`.`isStatic`
FROM `ow_base_menu_item` AS `mi`
LEFT JOIN `ow_base_document` AS `d` ON ( `mi`.`documentKey` = `d`.`key`)
WHERE `mi`.`type` = :menuType ORDER BY `mi`.`order` ASC',
'execTime' => 0.0005359649658203125,
'params' =>
array (
'menuType' => 'main',
),
),
18 =>
array (
'query' => '
SELECT `mi`.*, `mi`.`key` AS `menu_key`, `d`.`class`, `d`.`action`, `d`.`uri`, `d`.`isStatic`
FROM `ow_base_menu_item` AS `mi`
LEFT JOIN `ow_base_document` AS `d` ON ( `mi`.`documentKey` = `d`.`key`)
WHERE `mi`.`type` = :menuType ORDER BY `mi`.`order` ASC',
'execTime' => 0.0005810260772705078,
'params' =>
array (
'menuType' => 'bottom',
),
),
19 =>
array (
'query' => 'SELECT * FROM ow_newsfeed_action WHERE `id` = 3227 LIMIT 0, 1',
'execTime' => 0.0007688999176025391,
'params' =>
array (
),
),
20 =>
array (
'query' => 'SELECT activity.* FROM ow_newsfeed_activity activity
WHERE activity.actionId IN(3227)
AND activity.activityType IN ("create", "subscribe") UNION SELECT a.* FROM ( SELECT DISTINCT activity.* FROM ow_newsfeed_activity activity
INNER JOIN `ow_base_user` base_user_table_alias ON base_user_table_alias.`id` = `activity`.`userId` LEFT JOIN `ow_base_user_suspend` base_user_suspend_table_alias ON base_user_suspend_table_alias.`userId` = `base_user_table_alias`.`id`
INNER JOIN ow_newsfeed_action_feed action_feed ON activity.id=action_feed.activityId
WHERE (`base_user_suspend_table_alias`.`id` IS NULL) AND activity.actionId = 3227 AND
(
activity.status=:s
AND activity.privacy=:peb
AND action_feed.feedType=:ft
AND action_feed.feedId=:fi
AND activity.visibility & :v
)
ORDER BY activity.timeStamp DESC, activity.id DESC LIMIT 100 ) a ORDER BY 7 DESC, 1 DESC ',
'execTime' => 0.000990152359008789,
'params' =>
array (
'ft' => 'user',
'fi' => '1',
's' => 'active',
'v' => 8,
'peb' => 'everybody',
),
),
21 =>
array (
'query' => 'SELECT COUNT(DISTINCT action.id) FROM ow_newsfeed_action action
INNER JOIN ow_newsfeed_activity activity ON action.id = activity.actionId
INNER JOIN ow_newsfeed_activity cactivity ON action.id = cactivity.actionId
INNER JOIN `ow_base_user` base_user_table_alias ON base_user_table_alias.`id` = `activity`.`userId` LEFT JOIN `ow_base_user_suspend` base_user_suspend_table_alias ON base_user_suspend_table_alias.`userId` = `base_user_table_alias`.`id`
INNER JOIN ow_newsfeed_action_feed action_feed ON activity.id=action_feed.activityId
WHERE (`base_user_suspend_table_alias`.`id` IS NULL)
AND activity.status=:s
AND activity.timeStamp<:st
AND activity.privacy=:peb
AND action_feed.feedType=:ft
AND action_feed.feedId=:fi
AND activity.visibility & :v
AND cactivity.status=:s
AND cactivity.activityType=:ac
AND cactivity.privacy=:peb
AND cactivity.visibility & :v',
'execTime' => 0.003693819046020508,
'params' =>
array (
'ft' => 'user',
'fi' => '1',
's' => 'active',
'v' => 8,
'peb' => 'everybody',
'ac' => 'create',
'st' => 1760860688,
),
),
22 =>
array (
'query' => 'SELECT * FROM ow_base_avatar WHERE `userId` IN(\'1\')',
'execTime' => 0.0002911090850830078,
'params' =>
array (
),
),
23 =>
array (
'query' => 'SELECT * FROM ow_base_user WHERE `id` IN(\'1\')',
'execTime' => 0.00022792816162109375,
'params' =>
array (
),
),
24 =>
array (
'query' => 'SELECT * FROM ow_base_question WHERE `name` IN(\'realname\')',
'execTime' => 0.00028705596923828125,
'params' =>
array (
),
),
25 =>
array (
'query' => 'SELECT * FROM ow_base_question_data WHERE `userId` IN(\'1\') AND `questionName` IN(\'realname\')',
'execTime' => 0.00022792816162109375,
'params' =>
array (
),
),
26 =>
array (
'query' => 'SELECT * FROM ow_base_authorization_group',
'execTime' => 0.00022292137145996094,
'params' =>
array (
),
),
27 =>
array (
'query' => 'SELECT * FROM ow_base_authorization_moderator ORDER BY id',
'execTime' => 0.00014901161193847656,
'params' =>
array (
),
),
28 =>
array (
'query' => 'SELECT * FROM ow_base_authorization_moderator_permission',
'execTime' => 0.00014209747314453125,
'params' =>
array (
),
),
29 =>
array (
'query' => 'SELECT * FROM ow_base_authorization_action',
'execTime' => 0.0004558563232421875,
'params' =>
array (
),
),
30 =>
array (
'query' => 'SELECT * FROM ow_base_authorization_permission',
'execTime' => 0.00038886070251464844,
'params' =>
array (
),
),
31 =>
array (
'query' => 'SELECT * FROM ow_base_authorization_role ORDER BY `sortOrder` ASC',
'execTime' => 0.000164031982421875,
'params' =>
array (
),
),
32 =>
array (
'query' => 'SELECT `userId`,`name`,`custom` FROM ow_base_authorization_user_role ur
INNER JOIN ow_base_authorization_role r ON ur.roleId=r.id
WHERE ur.userId IN(\'1\') AND r.displayLabel=1
ORDER BY sortOrder DESC',
'execTime' => 0.00024509429931640625,
'params' => NULL,
),
33 =>
array (
'query' => 'SELECT `ce`.`entityType`, `ce`.`entityId`, COUNT(*) AS `count` FROM `ow_base_comment` AS `c`
LEFT JOIN `ow_base_comment_entity` AS `ce` ON ( `c`.`commentEntityId` = `ce`.`id` )
WHERE (`ce`.`entityType` = ? AND `ce`.`entityId` = ? ) GROUP BY `ce`.`id`',
'execTime' => 0.0002148151397705078,
'params' =>
array (
0 => 'photo_comments',
1 => '222',
),
),
34 =>
array (
'query' => 'SELECT * FROM ow_newsfeed_like WHERE entityType="photo_comments" AND entityId="222"',
'execTime' => 0.00015997886657714844,
'params' => NULL,
),
35 =>
array (
'query' => 'SELECT * FROM ow_base_theme WHERE `key` = \'match_sprintally\' LIMIT 0, 1',
'execTime' => 0.00026607513427734375,
'params' =>
array (
),
),
36 =>
array (
'query' => 'SELECT * FROM ow_base_place WHERE `name` = \'index\' LIMIT 0, 1',
'execTime' => 0.00020694732666015625,
'params' =>
array (
),
),
37 =>
array (
'query' => 'SELECT * FROM ow_base_component_place_cache WHERE `placeId` = \'2\' AND `entityId` = 0 LIMIT 0, 1',
'execTime' => 0.00026297569274902344,
'params' =>
array (
),
),
38 =>
array (
'query' => 'SELECT * FROM ow_base_language',
'execTime' => 0.00014901161193847656,
'params' =>
array (
),
),
39 =>
array (
'query' => 'SELECT COUNT(*) FROM ow_base_invitation WHERE `userId` = 0',
'execTime' => 0.0001709461212158203,
'params' =>
array (
),
),
40 =>
array (
'query' => 'SELECT COUNT(*) FROM ow_base_invitation WHERE `userId` = 0 AND `viewed` = 0',
'execTime' => 0.00011396408081054688,
'params' =>
array (
),
),
41 =>
array (
'query' => 'SELECT * FROM ow_base_component_place_cache WHERE `placeId` = \'2\' AND `entityId` = 0 LIMIT 0, 1',
'execTime' => 0.0001971721649169922,
'params' =>
array (
),
),
),
'debugMode' => NULL,
'isProfilerEnabled' => true,
'profiler' =>
UTIL_Profiler::__set_state(array(
'checkPoints' =>
array (
'start' => 1760860688.904975,
),
'key' => 'db',
'result' =>
array (
),
'chkCounter' => 0,
)),
'queryExecTime' => 0.0001971721649169922,
'totalQueryExecTime' => 0.016114473342895508,
'queryCount' => 42,
'useCashe' => false,
)),
)),
'privacy' =>
array (
),
)),
)),
1 => 'user',
2 => '1',
),
)
|
TUTORAdmin uploaded 1 new photo to Newsfeed Photos albumThank you to all our new members for joining, we now have over 1,000 members on the platform. If you are a tutor please ensure you have a detailed profile, including an introduction video to enhance your credibility with students and parents. Please keep active on the platform by posting insights, adding to your profile with photos, videos and by forming connections.Thank you to all our new members for joining, we now have over 1,000 members on the platform. If you are a tutor please ensure you have a detailed profile, including an introduction video to enhance your credibility with students and parents. Please keep active on the platform by posting insights, a...See more
Jul 25 '210 0