681fc57c55abe: GET https://alpha-woody.usserviceanimalsbeta.org/ at 2025-05-10 09:30:36 pm by 3.143.212.252
Database Queries
6 duplicated queries found.
Total 31 items.
| Time | Duration | Type | Duplicated | Query |
|---|---|---|---|---|
| 21:30:36.354 | 0.3 ms | SELECT | 3 | SELECT * FROM `trk_sess` WHERE `session_value`='gpkr5ookih09n98no5qhe66iie' |
| 21:30:36.354 | 0.2 ms | SELECT | 1 | SELECT * FROM `visitor_tracking` WHERE `trk_sess_id`=0 |
| 21:30:36.355 | 0.2 ms | SELECT | 3 | SELECT * FROM `visitor` WHERE `click_id`='9ec9b869069d4e54947b67979b17b332' |
| 21:30:36.355 | 0.2 ms | SELECT | 1 | SELECT * FROM `visitor` WHERE (`click_id`='9ec9b869069d4e54947b67979b17b332') AND (DATE(created_at) < '2025-05-10' AND first_return_at IS NULL ) |
| 21:30:36.356 | 0.1 ms | SELECT | 3 | SELECT * FROM `visitor` WHERE `click_id`='9ec9b869069d4e54947b67979b17b332' |
| 21:30:36.356 | 0.2 ms | SELECT | 3 | SELECT * FROM `trk_sess` WHERE `session_value`='gpkr5ookih09n98no5qhe66iie' |
| 21:30:36.356 | 0.2 ms | SELECT | 1 | SELECT * FROM `visitor_tracking` WHERE (`click_id`='9ec9b869069d4e54947b67979b17b332') AND (`trk_sess_id`=0) |
| 21:30:36.357 | 3.2 ms | INSERT | 1 | 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 | 0.3 ms | SELECT | 3 | SELECT * FROM `visitor` WHERE `click_id`='9ec9b869069d4e54947b67979b17b332' |
| 21:30:36.364 | 0.2 ms | SELECT | 1 | SELECT * FROM `outbound_whitelist` WHERE NOT (`site_name` IS NULL) |
| 21:30:36.364 | 0.4 ms | SHOW | 1 | SHOW FULL COLUMNS FROM `outbound_whitelist` |
| 21:30:36.364 | 0.4 ms | SELECT | 1 | 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 | 0.3 ms | SELECT | 1 | SELECT * FROM `trk_site_pages` WHERE `page_name`='/' |
| 21:30:36.366 | 0.3 ms | SHOW | 1 | SHOW FULL COLUMNS FROM `trk_site_pages` |
| 21:30:36.366 | 0.3 ms | SELECT | 1 | 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 | 0.2 ms | SELECT | 3 | SELECT * FROM `trk_sess` WHERE `session_value`='gpkr5ookih09n98no5qhe66iie' |
| 21:30:36.367 | 0.4 ms | SHOW | 1 | SHOW FULL COLUMNS FROM `trk_sess` |
| 21:30:36.368 | 0.2 ms | SELECT | 1 | 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 | 3.4 ms | INSERT | 1 | 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 | 0.4 ms | SHOW | 1 | SHOW FULL COLUMNS FROM `trk_pages` |
| 21:30:36.415 | 0.3 ms | SELECT | 1 | 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 | 3.2 ms | INSERT | 1 | 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 | 0.3 ms | SELECT | 1 | SELECT * FROM `carts` WHERE (`status`=0) AND (`session_id`='gpkr5ookih09n98no5qhe66iie') |
| 21:30:36.420 | 0.4 ms | SHOW | 1 | SHOW FULL COLUMNS FROM `carts` |
| 21:30:36.420 | 0.3 ms | SELECT | 1 | 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 | 0.3 ms | SELECT | 1 | SELECT * FROM `partners` WHERE `slug` = 'ussa' |
| 21:30:36.463 | 0.4 ms | SHOW | 1 | SHOW FULL COLUMNS FROM `partners` |
| 21:30:36.463 | 0.2 ms | SELECT | 1 | 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 | 0.2 ms | SELECT | 1 | SELECT * FROM `site_text` WHERE (`text_tag`='homepage-title') AND (`lang`='en-US') AND (`partner_id`=1) |
| 21:30:36.464 | 0.3 ms | SHOW | 1 | SHOW FULL COLUMNS FROM `site_text` |
| 21:30:36.464 | 0.3 ms | SELECT | 1 | 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' |