CUNY Academic Commons

/usr/sbin/mysqld, Version: 5.6.51-91.0-56-log (Percona XtraDB Cluster (GPL), Release rel91.0, Revision c714694, WSREP version 28.46, wsrep_28.46). started with:

Tcp port: 3306  Unix socket: /var/lib/mysql/mysql.sock

Time                 Id Command    Argument

# Time: 240922 12:02:30

# User@Host: commons_admin[commons_admin] @  [146.96.128.221]  Id: 1771525

# Schema: commons_wp  Last_errno: 0  Killed: 0

# Query_time: 26.144772  Lock_time: 0.000055  Rows_sent: 527  Rows_examined: 527  Rows_affected: 0

# Bytes_sent: 1399658

use commons_wp;

SET timestamp=1727020950;

SELECT option_name, option_value FROM wp_1_options WHERE autoload = 'yes';

# Time: 240922 12:03:05

# User@Host: commons_admin[commons_admin] @  [146.96.128.221]  Id: 1771897

# Schema: commons_wp  Last_errno: 0  Killed: 0

# Query_time: 27.308047  Lock_time: 0.000084  Rows_sent: 527  Rows_examined: 527  Rows_affected: 0

# Bytes_sent: 1399658

SET timestamp=1727020985;

SELECT option_name, option_value FROM wp_1_options WHERE autoload = 'yes';

# Time: 240922 12:03:21

# User@Host: commons_admin[commons_admin] @  [146.96.128.221]  Id: 1772278

# Schema: commons_wp  Last_errno: 0  Killed: 0

# Query_time: 11.389739  Lock_time: 0.000908  Rows_sent: 4  Rows_examined: 4  Rows_affected: 0

# Bytes_sent: 129548

SET timestamp=1727021001;

SELECT wp_1515_posts.* FROM wp_1515_posts WHERE ID IN (1303,1523,464,5);

# Time: 240922 19:32:22

# User@Host: commons_admin[commons_admin] @  [146.96.128.221]  Id: 2121308

# Schema: commons_wp  Last_errno: 0  Killed: 0

# Query_time: 12.805216  Lock_time: 0.000069  Rows_sent: 0  Rows_examined: 1  Rows_affected: 1

# Bytes_sent: 11

SET timestamp=1727047942;

DELETE FROM `wp_31275_options` WHERE `option_name` = 'jetpack_site_products';

# User@Host: commons_admin[commons_admin] @  [146.96.128.221]  Id: 2121424

# Schema: commons_wp  Last_errno: 0  Killed: 0

# Query_time: 12.677403  Lock_time: 0.000073  Rows_sent: 0  Rows_examined: 0  Rows_affected: 1

# Bytes_sent: 13

SET timestamp=1727047942;

INSERT INTO `wp_bp_invitations` (`user_id`, `inviter_id`, `invitee_email`, `class`, `item_id`, `secondary_item_id`, `type`, `content`, `date_modified`, `invite_sent`, `accepted`) VALUES (53210, 0, '', 'bp_groups_invitation_manager', 3306, 0, 'request', '', '2024-09-22 23:32:09', 0, 0);

# User@Host: commons_admin[commons_admin] @  [146.96.128.221]  Id: 2121397

# Schema: commons_wp  Last_errno: 0  Killed: 0

# Query_time: 11.913201  Lock_time: 0.001221  Rows_sent: 0  Rows_examined: 1  Rows_affected: 1

# Bytes_sent: 52

SET timestamp=1727047942;

UPDATE `wp_1013_options` SET `option_value` = '1727047930' WHERE `option_name` = 'wysija_last_php_cron_call';

# User@Host: commons_admin[commons_admin] @  [146.96.128.221]  Id: 2121419

# Schema: commons_wp  Last_errno: 0  Killed: 0

# Query_time: 10.980756  Lock_time: 0.000160  Rows_sent: 0  Rows_examined: 1  Rows_affected: 1

# Bytes_sent: 52

SET timestamp=1727047942;

UPDATE `wp_10500_options` SET `option_value` = 'a:3:{s:7:\"version\";s:16:\"6.3.2:1533060716\";s:11:\"old_version\";s:16:\"6.3.2:1533060716\";s:14:\"last_heartbeat\";i:1727047931;}' WHERE `option_name` = 'jetpack_options';

# User@Host: commons_admin[commons_admin] @  [146.96.128.221]  Id: 2121450

# Schema: commons_wp  Last_errno: 0  Killed: 0

# Query_time: 10.611752  Lock_time: 0.000095  Rows_sent: 0  Rows_examined: 2  Rows_affected: 1

# Bytes_sent: 52

SET timestamp=1727047942;

UPDATE `wp_34790_postmeta` SET `meta_value` = '1727047931:52607' WHERE `post_id` = 1029 AND `meta_key` = '_edit_lock';

# User@Host: commons_admin[commons_admin] @  [146.96.128.221]  Id: 2121452

# Schema: commons_wp  Last_errno: 0  Killed: 0

# Query_time: 10.565941  Lock_time: 0.000053  Rows_sent: 0  Rows_examined: 1  Rows_affected: 1

# Bytes_sent: 52

SET timestamp=1727047942;

UPDATE `wp_usermeta` SET `meta_value` = '1727047931' WHERE `user_id` = 52743 AND `meta_key` = 'wp_34828_user-settings-time';

# Time: 240922 19:32:40

# User@Host: commons_admin[commons_admin] @  [146.96.128.221]  Id: 2121502

# Schema: commons_wp  Last_errno: 0  Killed: 0

# Query_time: 22.338631  Lock_time: 4.425414  Rows_sent: 0  Rows_examined: 1  Rows_affected: 1

# Bytes_sent: 52

SET timestamp=1727047960;

UPDATE `wp_usermeta` SET `meta_value` = '1727047937' WHERE `user_id` = 52743 AND `meta_key` = 'wp_34828_user-settings-time';

# User@Host: commons_admin[commons_admin] @  [146.96.128.221]  Id: 2121308

# Schema: commons_wp  Last_errno: 0  Killed: 0

# Query_time: 17.910073  Lock_time: 0.000124  Rows_sent: 0  Rows_examined: 0  Rows_affected: 1

# Bytes_sent: 13

SET timestamp=1727047960;

INSERT INTO `wp_31275_options` (`option_name`, `option_value`, `autoload`) VALUES ('jetpack_site_products', 'a:0:{}', 'yes') ON DUPLICATE KEY UPDATE `option_name` = VALUES(`option_name`), `option_value` = VALUES(`option_value`), `autoload` = VALUES(`autoload`);

# User@Host: commons_admin[commons_admin] @  [146.96.128.221]  Id: 2121538

# Schema: commons_yourls  Last_errno: 0  Killed: 0

# Query_time: 17.908355  Lock_time: 0.000156  Rows_sent: 0  Rows_examined: 0  Rows_affected: 1

# Bytes_sent: 14

use commons_yourls;

SET timestamp=1727047960;

INSERT INTO `yourls_log` (click_time, shorturl, referrer, user_agent, ip_address, country_code) VALUES ('2024-09-22 23:32:22', 'wli0142', 'direct', 'Mozilla/5.0 (Linux; Android 5.0) AppleWebKit/537.36 (KHTML, like Gecko) Mobile Safari/537.36 (compatible; Bytespider; spider-feedback@bytedance.com)', '47.128.96.202', 'CA');

# User@Host: commons_admin[commons_admin] @  [146.96.128.221]  Id: 2121424

# Schema: commons_wp  Last_errno: 0  Killed: 0

# Query_time: 17.821663  Lock_time: 0.000054  Rows_sent: 0  Rows_examined: 0  Rows_affected: 1

# Bytes_sent: 14

use commons_wp;

SET timestamp=1727047960;

INSERT INTO `wp_bp_notifications` (`user_id`, `item_id`, `secondary_item_id`, `component_name`, `component_action`, `date_notified`, `is_new`) VALUES (9781, 3306, 53210, 'groups', 'new_membership_request', '2024-09-22 23:32:22', 1);

# User@Host: commons_admin[commons_admin] @  [146.96.128.221]  Id:    97

# Schema: commons_wp  Last_errno: 0  Killed: 0

# Query_time: 17.567096  Lock_time: 0.000064  Rows_sent: 0  Rows_examined: 1  Rows_affected: 1

# Bytes_sent: 52

SET timestamp=1727047960;

UPDATE wp_cavalcade_jobs SET status = 'waiting', nextrun = '2024-09-23 23:32:07' WHERE id = '3334438';

# Time: 240923 15:21:24

# User@Host: commons_admin[commons_admin] @  [146.96.128.221]  Id: 3086325

# Schema: commons_openlabdev  Last_errno: 0  Killed: 0

# Query_time: 31.991515  Lock_time: 0.000179  Rows_sent: 296  Rows_examined: 296  Rows_affected: 0

# Bytes_sent: 107359

use commons_openlabdev;

SET timestamp=1727119284;

SELECT option_name, option_value FROM wp_options WHERE autoload = 'yes';

# Time: 240924 11:58:06

# User@Host: commons_admin[commons_admin] @  [146.96.128.221]  Id: 4095991

# Schema: commons_wp  Last_errno: 0  Killed: 0

# Query_time: 13.110795  Lock_time: 0.000069  Rows_sent: 527  Rows_examined: 527  Rows_affected: 0

# Bytes_sent: 1399658

use commons_wp;

SET timestamp=1727193486;

SELECT option_name, option_value FROM wp_1_options WHERE autoload = 'yes';

/usr/sbin/mysqld, Version: 5.6.51-91.0-56-log (Percona XtraDB Cluster (GPL), Release rel91.0, Revision c714694, WSREP version 28.46, wsrep_28.46). started with:

Tcp port: 3306  Unix socket: /var/lib/mysql/mysql.sock

Time                 Id Command    Argument

# Time: 240924 13:56:15

# User@Host: commons_admin[commons_admin] @  [146.96.128.221]  Id:   662

# Schema: commons_wp  Last_errno: 0  Killed: 0

# Query_time: 14.143203  Lock_time: 0.000139  Rows_sent: 2  Rows_examined: 621876  Rows_affected: 0

# Bytes_sent: 100

use commons_wp;

SET timestamp=1727200575;

SELECT DISTINCT a.id  FROM wp_bp_activity a  WHERE  

( 

	( 

		( 

			a.user_id = '22407' 

			AND 

			a.hide_sitewide = 0

		)

		OR 

		( 

			a.component = 'friends' 

			AND 

			a.secondary_item_id = '22407'

		)

	)

)

 AND a.is_spam = 0 AND a.type NOT IN ('last_activity') AND a.date_recorded <= '2024-09-24 17:56:01' ORDER BY a.date_recorded DESC, a.id DESC LIMIT 0, 21;