Log Messages

Total 33 items.

Time	Level	Category	Message

21:30:36.352	info	yii\web\Session::open	Session started
21:30:36.353	info	yii\db\Connection::open	Opening DB connection: mysql:host=127.0.0.1;port=3306;dbname=ussa
21:30:36.354	info	yii\db\Command::query	SELECT * FROM `trk_sess` WHERE `session_value`='gpkr5ookih09n98no5qhe66iie'
21:30:36.354	info	yii\db\Command::query	SELECT * FROM `visitor_tracking` WHERE `trk_sess_id`=0
21:30:36.355	info	yii\db\Command::query	SELECT * FROM `visitor` WHERE `click_id`='9ec9b869069d4e54947b67979b17b332'
21:30:36.355	info	yii\db\Command::query	SELECT * FROM `visitor` WHERE (`click_id`='9ec9b869069d4e54947b67979b17b332') AND (DATE(created_at) < '2025-05-10' AND first_return_at IS NULL )
21:30:36.356	info	yii\db\Command::query	SELECT * FROM `visitor` WHERE `click_id`='9ec9b869069d4e54947b67979b17b332'
21:30:36.356	info	yii\db\Command::query	SELECT * FROM `trk_sess` WHERE `session_value`='gpkr5ookih09n98no5qhe66iie'
21:30:36.356	info	yii\db\Command::query	SELECT * FROM `visitor_tracking` WHERE (`click_id`='9ec9b869069d4e54947b67979b17b332') AND (`trk_sess_id`=0)
21:30:36.357	info	yii\db\Command::execute	INSERT INTO `visitor_tracking` (`click_id`, `trk_sess_id`, `is_new_user`, `created_at`, `updated_at`) VALUES ('9ec9b869069d4e54947b67979b17b332', NULL, 1, '2025-05-10 21:30:36', '2025-05-10 21:30:36')
21:30:36.363	info	yii\db\Command::query	SELECT * FROM `visitor` WHERE `click_id`='9ec9b869069d4e54947b67979b17b332'
21:30:36.364	info	yii\db\Command::query	SELECT * FROM `outbound_whitelist` WHERE NOT (`site_name` IS NULL)
21:30:36.364	info	yii\db\Command::query	SHOW FULL COLUMNS FROM `outbound_whitelist`
21:30:36.364	info	yii\db\Command::query	SELECT `kcu`.`CONSTRAINT_NAME` AS `constraint_name`, `kcu`.`COLUMN_NAME` AS `column_name`, `kcu`.`REFERENCED_TABLE_NAME` AS `referenced_table_name`, `kcu`.`REFERENCED_COLUMN_NAME` AS `referenced_column_name` FROM `information_schema`.`REFERENTIAL_CONSTRAINTS` AS `rc` JOIN `information_schema`.`KEY_COLUMN_USAGE` AS `kcu` ON ( `kcu`.`CONSTRAINT_CATALOG` = `rc`.`CONSTRAINT_CATALOG` OR (`kcu`.`CONSTRAINT_CATALOG` IS NULL AND `rc`.`CONSTRAINT_CATALOG` IS NULL) ) AND `kcu`.`CONSTRAINT_SCHEMA` = `rc`.`CONSTRAINT_SCHEMA` AND `kcu`.`CONSTRAINT_NAME` = `rc`.`CONSTRAINT_NAME` WHERE `rc`.`CONSTRAINT_SCHEMA` = database() AND `kcu`.`TABLE_SCHEMA` = database() AND `rc`.`TABLE_NAME` = 'outbound_whitelist' AND `kcu`.`TABLE_NAME` = 'outbound_whitelist'
21:30:36.365	info	yii\db\Command::query	SELECT * FROM `trk_site_pages` WHERE `page_name`='/'
21:30:36.366	info	yii\db\Command::query	SHOW FULL COLUMNS FROM `trk_site_pages`
21:30:36.366	info	yii\db\Command::query	SELECT `kcu`.`CONSTRAINT_NAME` AS `constraint_name`, `kcu`.`COLUMN_NAME` AS `column_name`, `kcu`.`REFERENCED_TABLE_NAME` AS `referenced_table_name`, `kcu`.`REFERENCED_COLUMN_NAME` AS `referenced_column_name` FROM `information_schema`.`REFERENTIAL_CONSTRAINTS` AS `rc` JOIN `information_schema`.`KEY_COLUMN_USAGE` AS `kcu` ON ( `kcu`.`CONSTRAINT_CATALOG` = `rc`.`CONSTRAINT_CATALOG` OR (`kcu`.`CONSTRAINT_CATALOG` IS NULL AND `rc`.`CONSTRAINT_CATALOG` IS NULL) ) AND `kcu`.`CONSTRAINT_SCHEMA` = `rc`.`CONSTRAINT_SCHEMA` AND `kcu`.`CONSTRAINT_NAME` = `rc`.`CONSTRAINT_NAME` WHERE `rc`.`CONSTRAINT_SCHEMA` = database() AND `kcu`.`TABLE_SCHEMA` = database() AND `rc`.`TABLE_NAME` = 'trk_site_pages' AND `kcu`.`TABLE_NAME` = 'trk_site_pages'
21:30:36.367	info	yii\db\Command::query	SELECT * FROM `trk_sess` WHERE `session_value`='gpkr5ookih09n98no5qhe66iie'
21:30:36.367	info	yii\db\Command::query	SHOW FULL COLUMNS FROM `trk_sess`
21:30:36.367	info	yii\db\Command::query	SELECT `kcu`.`CONSTRAINT_NAME` AS `constraint_name`, `kcu`.`COLUMN_NAME` AS `column_name`, `kcu`.`REFERENCED_TABLE_NAME` AS `referenced_table_name`, `kcu`.`REFERENCED_COLUMN_NAME` AS `referenced_column_name` FROM `information_schema`.`REFERENTIAL_CONSTRAINTS` AS `rc` JOIN `information_schema`.`KEY_COLUMN_USAGE` AS `kcu` ON ( `kcu`.`CONSTRAINT_CATALOG` = `rc`.`CONSTRAINT_CATALOG` OR (`kcu`.`CONSTRAINT_CATALOG` IS NULL AND `rc`.`CONSTRAINT_CATALOG` IS NULL) ) AND `kcu`.`CONSTRAINT_SCHEMA` = `rc`.`CONSTRAINT_SCHEMA` AND `kcu`.`CONSTRAINT_NAME` = `rc`.`CONSTRAINT_NAME` WHERE `rc`.`CONSTRAINT_SCHEMA` = database() AND `kcu`.`TABLE_SCHEMA` = database() AND `rc`.`TABLE_NAME` = 'trk_sess' AND `kcu`.`TABLE_NAME` = 'trk_sess'
21:30:36.410	info	yii\db\Command::execute	INSERT INTO `trk_sess` (`session_value`, `ip_addr`, `reg_variant`, `who_variant`, `funnel`, `user_agent_header`, `entry_date`, `last_action`, `tracking_data`) VALUES ('gpkr5ookih09n98no5qhe66iie', '3.143.212.252', 'ALC-O', 'SELF', 'PO', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; [email protected])', '2025-05-10 21:30:36', '2025-05-10 21:30:36', 'a:7:{s:6:\"source\";N;s:6:\"medium\";N;s:8:\"campaign\";N;s:7:\"adgroup\";N;s:7:\"keyword\";N;s:8:\"adnumber\";N;s:6:\"mailer\";N;}')
21:30:36.414	info	yii\db\Command::query	SHOW FULL COLUMNS FROM `trk_pages`
21:30:36.415	info	yii\db\Command::query	SELECT `kcu`.`CONSTRAINT_NAME` AS `constraint_name`, `kcu`.`COLUMN_NAME` AS `column_name`, `kcu`.`REFERENCED_TABLE_NAME` AS `referenced_table_name`, `kcu`.`REFERENCED_COLUMN_NAME` AS `referenced_column_name` FROM `information_schema`.`REFERENTIAL_CONSTRAINTS` AS `rc` JOIN `information_schema`.`KEY_COLUMN_USAGE` AS `kcu` ON ( `kcu`.`CONSTRAINT_CATALOG` = `rc`.`CONSTRAINT_CATALOG` OR (`kcu`.`CONSTRAINT_CATALOG` IS NULL AND `rc`.`CONSTRAINT_CATALOG` IS NULL) ) AND `kcu`.`CONSTRAINT_SCHEMA` = `rc`.`CONSTRAINT_SCHEMA` AND `kcu`.`CONSTRAINT_NAME` = `rc`.`CONSTRAINT_NAME` WHERE `rc`.`CONSTRAINT_SCHEMA` = database() AND `kcu`.`TABLE_SCHEMA` = database() AND `rc`.`TABLE_NAME` = 'trk_pages' AND `kcu`.`TABLE_NAME` = 'trk_pages'
21:30:36.416	info	yii\db\Command::execute	INSERT INTO `trk_pages` (`sess_id`, `page_id`, `url_params`, `cookie`, `access_date`, `referrer_domain`, `referrer_params`, `reg_variant`, `who_variant`, `funnel`) VALUES (1683502, 5347, '', '{\"IP-10-0-144-198_SID\":\"gpkr5ookih09n98no5qhe66iie\",\"rv\":\"6760719167d3d3702110e8e95de32f3a28a465a4fe126b0089570dd7da46d49ea:2:{i:0;s:2:\\\"rv\\\";i:1;s:5:\\\"ALC-O\\\";}\",\"ux\":\"cfe291bc7bcb1be9fd5c40ea5cf2deaffad6c9e67e4b9eff61b59a89cee115fda:2:{i:0;s:2:\\\"ux\\\";i:1;s:8:\\\"ST42-LP0\\\";}\",\"visitor_id\":\"1a08da513580094157581dbc307d171ba2d987e59c947f3823c30ed9168c4fe0a:2:{i:0;s:10:\\\"visitor_id\\\";i:1;s:32:\\\"9ec9b869069d4e54947b67979b17b332\\\";}\",\"pg1\":\"e02a02ce376125286c63ce13b6fdef5d65afffcd2b1b4be1946f70ba83f1d3a1a:2:{i:0;s:3:\\\"pg1\\\";i:1;i:1;}\"}', '2025-05-10 21:30:36', NULL, NULL, 'ALC-O', 'SELF', 'PO')
21:30:36.419	info	yii\db\Command::query	SELECT * FROM `carts` WHERE (`status`=0) AND (`session_id`='gpkr5ookih09n98no5qhe66iie')
21:30:36.420	info	yii\db\Command::query	SHOW FULL COLUMNS FROM `carts`
21:30:36.420	info	yii\db\Command::query	SELECT `kcu`.`CONSTRAINT_NAME` AS `constraint_name`, `kcu`.`COLUMN_NAME` AS `column_name`, `kcu`.`REFERENCED_TABLE_NAME` AS `referenced_table_name`, `kcu`.`REFERENCED_COLUMN_NAME` AS `referenced_column_name` FROM `information_schema`.`REFERENTIAL_CONSTRAINTS` AS `rc` JOIN `information_schema`.`KEY_COLUMN_USAGE` AS `kcu` ON ( `kcu`.`CONSTRAINT_CATALOG` = `rc`.`CONSTRAINT_CATALOG` OR (`kcu`.`CONSTRAINT_CATALOG` IS NULL AND `rc`.`CONSTRAINT_CATALOG` IS NULL) ) AND `kcu`.`CONSTRAINT_SCHEMA` = `rc`.`CONSTRAINT_SCHEMA` AND `kcu`.`CONSTRAINT_NAME` = `rc`.`CONSTRAINT_NAME` WHERE `rc`.`CONSTRAINT_SCHEMA` = database() AND `kcu`.`TABLE_SCHEMA` = database() AND `rc`.`TABLE_NAME` = 'carts' AND `kcu`.`TABLE_NAME` = 'carts'
21:30:36.462	info	yii\db\Command::query	SELECT * FROM `partners` WHERE `slug` = 'ussa'
21:30:36.463	info	yii\db\Command::query	SHOW FULL COLUMNS FROM `partners`
21:30:36.463	info	yii\db\Command::query	SELECT `kcu`.`CONSTRAINT_NAME` AS `constraint_name`, `kcu`.`COLUMN_NAME` AS `column_name`, `kcu`.`REFERENCED_TABLE_NAME` AS `referenced_table_name`, `kcu`.`REFERENCED_COLUMN_NAME` AS `referenced_column_name` FROM `information_schema`.`REFERENTIAL_CONSTRAINTS` AS `rc` JOIN `information_schema`.`KEY_COLUMN_USAGE` AS `kcu` ON ( `kcu`.`CONSTRAINT_CATALOG` = `rc`.`CONSTRAINT_CATALOG` OR (`kcu`.`CONSTRAINT_CATALOG` IS NULL AND `rc`.`CONSTRAINT_CATALOG` IS NULL) ) AND `kcu`.`CONSTRAINT_SCHEMA` = `rc`.`CONSTRAINT_SCHEMA` AND `kcu`.`CONSTRAINT_NAME` = `rc`.`CONSTRAINT_NAME` WHERE `rc`.`CONSTRAINT_SCHEMA` = database() AND `kcu`.`TABLE_SCHEMA` = database() AND `rc`.`TABLE_NAME` = 'partners' AND `kcu`.`TABLE_NAME` = 'partners'
21:30:36.464	info	yii\db\Command::query	SELECT * FROM `site_text` WHERE (`text_tag`='homepage-title') AND (`lang`='en-US') AND (`partner_id`=1)
21:30:36.464	info	yii\db\Command::query	SHOW FULL COLUMNS FROM `site_text`
21:30:36.464	info	yii\db\Command::query	SELECT `kcu`.`CONSTRAINT_NAME` AS `constraint_name`, `kcu`.`COLUMN_NAME` AS `column_name`, `kcu`.`REFERENCED_TABLE_NAME` AS `referenced_table_name`, `kcu`.`REFERENCED_COLUMN_NAME` AS `referenced_column_name` FROM `information_schema`.`REFERENTIAL_CONSTRAINTS` AS `rc` JOIN `information_schema`.`KEY_COLUMN_USAGE` AS `kcu` ON ( `kcu`.`CONSTRAINT_CATALOG` = `rc`.`CONSTRAINT_CATALOG` OR (`kcu`.`CONSTRAINT_CATALOG` IS NULL AND `rc`.`CONSTRAINT_CATALOG` IS NULL) ) AND `kcu`.`CONSTRAINT_SCHEMA` = `rc`.`CONSTRAINT_SCHEMA` AND `kcu`.`CONSTRAINT_NAME` = `rc`.`CONSTRAINT_NAME` WHERE `rc`.`CONSTRAINT_SCHEMA` = database() AND `kcu`.`TABLE_SCHEMA` = database() AND `rc`.`TABLE_NAME` = 'site_text' AND `kcu`.`TABLE_NAME` = 'site_text'