2021 Review Course

January 27-30, 2021

Elizabeth Fox, MD

Session Title: Clinical Pharmacology and Targeted Therapies
Session Duration: 90 minutes

Due Date Reminders:
October 14, 2020
Final PowerPoint Presentation and Copyright Grid due to Ryan Wilkinson.

October 14, 2020
Self-Assessment Questions due to Ryan Wilkinson.

November 18, 2020
Submit W-9 form to Ryan Wilkinson (in order to process speaker honorarium)

Speaker Materials
You are being asked to cover sections in the content outline that were included as part of two presentations in 2019 - 'Principles of Treatment in Pediatric Oncology' and 'Clinical Pharmacology and Targeted Therapies'. Linked below are the PPTs from both presentations, for reference. You only have to focus on the areas/topics of the content outline that are assigned to you.

2019 Presentation - Principles of Treatment in Pediatric Oncology
2019 Presentation - Clinical Pharmacology and Targeted Therapies

Similiarly for the self-assessment questions, these were included as part of two different sets. Linked below are the questions from both topics. You only have to write/update questions related to the areas/topics assigned to you.

2019 Self-Assessment Questions - Principles of Treatment in Pediatric Oncology
2019 Self-Assessment Questions - Clinical Pharmacology and Targeted Therapies

General
2019 Evaluation Results (these results should be kept confidential; they are provided to help improve the talk)
Principles of Treatment in Pediatric Oncology
Clinical Pharmacology and Targeted Therapies

Content Outline by Topic with Assignments and Content Outline by Speaker with Assignments (contact Paul Harker-Murray and Cindy Neunert if you have questions about your assignment)

Question Writing Guidelines

2021 Program Schedule

ASPHO Slide Template

2019 Post Survey Results

Speaker Copyright Grid

2021 Review Course Schedule

Joomla! Debug Console

60 Queries Logged

SELECT `data` FROM `v311_session` WHERE `session_id` = '94qdvvpcuij8rkhi3hm3r63h45'
DELETE FROM `v311_session` WHERE `time` < '1732774323'
SELECT `session_id` FROM `v311_session` WHERE `session_id` = '94qdvvpcuij8rkhi3hm3r63h45' LIMIT 0, 1
INSERT INTO `v311_session` (`session_id`, `client_id`, `time`) VALUES ('94qdvvpcuij8rkhi3hm3r63h45', 0, '1732779723')
SELECT extension_id AS id, element AS "option", params, enabled FROM v311_extensions WHERE `type` = 'component' AND `element` = 'com_users'
SELECT b.id FROM v311_usergroups AS a LEFT JOIN v311_usergroups AS b ON b.lft <= a.lft AND b.rgt >= a.rgt WHERE a.id = 9
SELECT id, rules FROM `v311_viewlevels`
SELECT folder AS type, element AS name, params FROM v311_extensions WHERE enabled >= 1 AND type ='plugin' AND state >= 0 AND access IN (1,1,5) ORDER BY ordering
SELECT extension_id AS id, element AS "option", params, enabled FROM v311_extensions WHERE `type` = 'component' AND `element` = 'com_languages'
SELECT params FROM v311_modules WHERE module = 'mod_egdamcsso';
CREATE TABLE IF NOT EXISTS `v311_egd_impexiumsso` ( `id` int(11) NOT NULL auto_increment, `customer_token` text NOT NULL, `customer_id` text NOT NULL, `sso_return_url` text NOT NULL, `day` date NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=173;
SELECT `params` FROM v311_extensions WHERE `element`='com_sh404sef' AND `type`='component';
SELECT * FROM v311_languages WHERE published=1 ORDER BY ordering ASC
SELECT id,oldurl,newurl FROM `v311_sh404sef_urls` WHERE oldurl = 'http://306847.minerockhongkong.tech/meetings/review-course/2021-review-course/fox-2021' AND rank = 0;
SELECT * FROM `v311_osemsc_configuration`
SELECT * FROM `v311_osemsc_content` WHERE (type = 'joomla') AND (content_type = 'menu') AND (status = '1')
SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component FROM v311_menu AS m LEFT JOIN v311_extensions AS e ON m.component_id = e.extension_id WHERE m.published = 1 AND m.parent_id > 0 AND m.client_id = 0 ORDER BY m.lft
select `alias`,`newurl` from `v311_sh404sef_aliases` where `alias` = 'http://306847.minerockhongkong.tech/meetings/review-course/2021-review-course/fox-2021' or `alias` = 'ongkong.tech/meetings/review-course/2021-review-course/fox-2021' or `alias` = 'ongkong.tech/meetings/review-course/2021-review-course/fox-2021/' order by `alias` desc
SELECT `oldurl`, `newurl`, `dateadd` FROM v311_sh404sef_urls WHERE `oldurl`='meetings/review-course/2021-review-course/fox-2021' ORDER BY `rank`;
SELECT extension_id AS id, element AS "option", params, enabled FROM v311_extensions WHERE `type` = 'component' AND `element` = 'com_content'
SELECT id, home, template, s.params FROM v311_template_styles as s LEFT JOIN v311_extensions as e ON e.element=s.template AND e.type='template' AND e.client_id=s.client_id WHERE s.client_id = 0 AND e.enabled = 1
SELECT a.rules FROM v311_assets AS a WHERE (a.id = 1) GROUP BY a.id, a.rules, a.lft
SELECT b.rules FROM v311_assets AS a LEFT JOIN v311_assets AS b ON b.lft <= a.lft AND b.rgt >= a.rgt WHERE (a.name = 'com_content') GROUP BY b.id, b.rules, b.lft ORDER BY b.lft
SELECT a.id, a.asset_id, a.title, a.alias, a.introtext, a.fulltext, CASE WHEN badcats.id is null THEN a.state ELSE 0 END AS state, a.catid, a.created, a.created_by, a.created_by_alias, CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,contact.id as contactid,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count FROM v311_content AS a LEFT JOIN v311_categories AS c on c.id = a.catid LEFT JOIN v311_users AS u on u.id = a.created_by LEFT JOIN ( SELECT contact.user_id, MAX(contact.id) AS id, contact.language FROM v311_contact_details AS contact WHERE contact.published = 1 GROUP BY contact.user_id, contact.language) AS contact ON contact.user_id = a.created_by LEFT JOIN v311_categories as parent ON parent.id = c.parent_id LEFT JOIN v311_content_rating AS v ON a.id = v.content_id LEFT OUTER JOIN (SELECT cat.id as id FROM v311_categories AS cat JOIN v311_categories AS parent ON cat.lft BETWEEN parent.lft AND parent.rgt WHERE parent.extension = 'com_content' AND parent.published <= 0 GROUP BY cat.id) AS badcats ON badcats.id = c.id WHERE a.id = 683 AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-11-28 07:42:03') AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-11-28 07:42:03') AND (a.state = 1 OR a.state =2)
SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug FROM v311_categories as c LEFT JOIN v311_categories AS s ON (s.lft <= c.lft AND s.rgt >= c.rgt) OR (s.lft > c.lft AND s.rgt < c.rgt) LEFT JOIN (SELECT cat.id as id FROM v311_categories AS cat JOIN v311_categories AS parent ON cat.lft BETWEEN parent.lft AND parent.rgt WHERE parent.extension = 'com_content' AND parent.published != 1 GROUP BY cat.id) AS badcats ON badcats.id = c.id WHERE (c.extension='com_content' OR c.extension='system') AND c.access IN (1,1,5) AND c.published = 1 AND s.id=52 AND badcats.id is null GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version ORDER BY c.lft
SELECT extension_id AS id, element AS "option", params, enabled FROM v311_extensions WHERE `type` = 'component' AND `element` = 'com_tags'
SELECT `m`.`tag_id`,`t`.* FROM `v311_contentitem_tag_map` AS m INNER JOIN `v311_tags` AS t ON `m`.`tag_id` = `t`.`id` WHERE `m`.`type_alias` = 'com_content.article' AND `m`.`content_item_id` = 683 AND `t`.`published` = 1 AND t.access IN (1,1,5)
SELECT b.rules FROM v311_assets AS a LEFT JOIN v311_assets AS b ON b.lft <= a.lft AND b.rgt >= a.rgt WHERE (a.name = 'com_content.article.683') GROUP BY b.id, b.rules, b.lft ORDER BY b.lft
SELECT a.id, CASE WHEN CHAR_LENGTH(a.alias) != 0 THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug, CASE WHEN CHAR_LENGTH(cc.alias) != 0 THEN CONCAT_WS(':', cc.id, cc.alias) ELSE cc.id END as catslug FROM v311_content AS a LEFT JOIN v311_categories AS cc ON cc.id = a.catid WHERE a.catid = 52 AND a.state = 1 AND a.access = 1 AND (a.state = 1 OR a.state = -1) AND (publish_up = '0000-00-00 00:00:00' OR publish_up <= '2024-11-28 07:42:03') AND (publish_down = '0000-00-00 00:00:00' OR publish_down >= '2024-11-28 07:42:03') ORDER BY a.created DESC
UPDATE v311_content SET hits = hits + 1 WHERE id = 683
SELECT v311_categories.alias FROM v311_content, v311_categories WHERE v311_content.catid = v311_categories.id AND v311_content.id = 683
SELECT m.published, m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params,am.params as advancedparams, 0 as menuid, m.publish_up, m.publish_down FROM v311_modules AS m LEFT JOIN v311_extensions AS e ON e.element = m.module AND e.client_id = m.client_id LEFT JOIN v311_advancedmodules as am ON am.moduleid = m.id WHERE m.published = 1 AND e.enabled = 1 AND m.client_id = 0 AND m.access IN (1,1,5) ORDER BY m.ordering, m.id
SELECT extension_id AS id, element AS "option", params, enabled FROM v311_extensions WHERE `type` = 'component' AND `element` = 'com_advancedmodules'
SHOW FULL COLUMNS FROM `v311_content`
SELECT * FROM v311_content WHERE `id` = '683'
SELECT t.parent_id FROM v311_categories as t WHERE t.id = 52
SELECT t.parent_id FROM v311_categories as t WHERE t.id = 53
SELECT t.parent_id FROM v311_categories as t WHERE t.id = 9
SELECT t.parent_id FROM v311_categories as t WHERE t.id = 1
SELECT m.menutype FROM v311_menu AS m WHERE m.id = 953
SELECT t.parent_id FROM v311_menu as t WHERE t.id = 953
SELECT t.parent_id FROM v311_menu as t WHERE t.id = 299
SELECT t.parent_id FROM v311_menu as t WHERE t.id = 162
SELECT t.parent_id FROM v311_menu as t WHERE t.id = 1
SELECT * FROM v311_content WHERE `id` = '683'
SELECT * FROM v311_content WHERE `id` = '683'
SELECT * FROM v311_content WHERE `id` = '683'
SELECT * FROM v311_content WHERE `id` = '683'
SELECT * FROM v311_content WHERE `id` = '683'
SELECT * FROM v311_content WHERE `id` = '683'
SELECT * FROM v311_banners WHERE '2024-11-28 07:42:03' >= 'reset' AND `reset` != '0000-00-00 00:00:00' AND `reset`!=NULL AND (`checked_out` = 0 OR `checked_out` = 0)
SELECT a.id as id,a.type as type,a.name as name,a.clickurl as clickurl,a.cid as cid,a.params as params,a.custombannercode as custombannercode,a.track_impressions as track_impressions,cl.track_impressions as client_track_impressions FROM v311_banners as a LEFT JOIN v311_banner_clients AS cl ON cl.id = a.cid WHERE a.state=1 AND (CURRENT_TIMESTAMP() >= a.publish_up OR a.publish_up = '0000-00-00 00:00:00') AND (CURRENT_TIMESTAMP() <= a.publish_down OR a.publish_down = '0000-00-00 00:00:00') AND (a.imptotal = 0 OR a.impmade <= a.imptotal) AND a.catid IN (0,41) ORDER BY a.sticky DESC,a.ordering
SELECT a.id as id,a.type as type,a.name as name,a.clickurl as clickurl,a.cid as cid,a.params as params,a.custombannercode as custombannercode,a.track_impressions as track_impressions,cl.track_impressions as client_track_impressions FROM v311_banners as a LEFT JOIN v311_banner_clients AS cl ON cl.id = a.cid WHERE a.state=1 AND (CURRENT_TIMESTAMP() >= a.publish_up OR a.publish_up = '0000-00-00 00:00:00') AND (CURRENT_TIMESTAMP() <= a.publish_down OR a.publish_down = '0000-00-00 00:00:00') AND (a.imptotal = 0 OR a.impmade <= a.imptotal) AND a.catid IN (0,41) ORDER BY a.sticky DESC,a.ordering LIMIT 0, 5
SELECT `oldurl`, `dateadd` FROM v311_sh404sef_urls WHERE `newurl`='index.php?option=com_jdonation&Itemid=386&campaign_id=1&lang=en&view=donation';
SELECT `id`, `title`, `alias`, `catid`, `language` FROM v311_content WHERE `id`=683;
SELECT * FROM v311_categories WHERE parent_id > 0 and extension = 'com_content' and path = 'uncategorised' and level = 1;
SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug FROM v311_categories as c LEFT JOIN v311_categories AS s ON (s.lft <= c.lft AND s.rgt >= c.rgt) OR (s.lft > c.lft AND s.rgt < c.rgt) LEFT JOIN (SELECT cat.id as id FROM v311_categories AS cat JOIN v311_categories AS parent ON cat.lft BETWEEN parent.lft AND parent.rgt WHERE parent.extension = 'com_content' AND parent.published != 1 GROUP BY cat.id) AS badcats ON badcats.id = c.id WHERE (c.extension='com_content' OR c.extension='system') AND s.id=52 AND badcats.id is null GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version ORDER BY c.lft
SHOW FULL COLUMNS FROM `v311_sh404sef_metas`
SELECT * FROM v311_sh404sef_metas WHERE `newurl`='index.php?option=com_content&Itemid=953&id=683&lang=en&view=article';
UPDATE `v311_session` SET `data` = '__default|a:12:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1732779723;s:18:\"session.timer.last\";i:1732779723;s:17:\"session.timer.now\";i:1732779723;s:24:\"session.client.forwarded\";s:12:\"18.118.162.8\";s:22:\"session.client.browser\";s:103:\"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; [email protected])\";s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":0:{}}s:4:\"user\";O:5:\"JUser\":24:{s:9:\"\\0\\0\\0isRoot\";b:0;s:2:\"id\";i:0;s:4:\"name\";N;s:8:\"username\";N;s:5:\"email\";N;s:8:\"password\";N;s:14:\"password_clear\";s:0:\"\";s:5:\"block\";N;s:9:\"sendEmail\";i:0;s:12:\"registerDate\";N;s:13:\"lastvisitDate\";N;s:10:\"activation\";N;s:6:\"params\";N;s:6:\"groups\";a:1:{i:0;s:1:\"9\";}s:5:\"guest\";i:1;s:13:\"lastResetTime\";N;s:10:\"resetCount\";N;s:10:\"\\0\\0\\0_params\";O:9:\"JRegistry\":1:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":0:{}}s:14:\"\\0\\0\\0_authGroups\";a:2:{i:0;i:1;i:1;i:9;}s:14:\"\\0\\0\\0_authLevels\";a:3:{i:0;i:1;i:1;i:1;i:2;i:5;}s:15:\"\\0\\0\\0_authActions\";N;s:12:\"\\0\\0\\0_errorMsg\";N;s:10:\"\\0\\0\\0_errors\";a:0:{}s:3:\"aid\";i:0;}s:13:\"session.token\";s:32:\"5b76d3e656bf57ccdb8712a7b10d3328\";s:17:\"url_joomla_logout\";s:101:\"http://stage.aspho.org/index.php?option=com_users&task=user.logout&7aae635dca63b7c2e3a3fae2c3833499=1\";s:12:\"url_amc_prev\";s:86:\"http://306847.minerockhongkong.tech/meetings/review-course/2021-review-course/fox-2021\";s:8:\"oseClass\";a:9:{s:8:\"registry\";s:11:\"oseregistry\";s:3:\"msc\";s:10:\"membership\";s:4:\"user\";s:4:\"user\";s:6:\"member\";s:6:\"member\";s:7:\"payment\";s:7:\"payment\";s:6:\"remote\";s:6:\"remote\";s:3:\"lic\";s:7:\"license\";s:7:\"content\";s:7:\"content\";s:5:\"debug\";s:5:\"debug\";}}' , `time` = '1732779724' WHERE `session_id` = '94qdvvpcuij8rkhi3hm3r63h45'

41 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

7 × SELECT * FROM v311_content
5 × SELECT extension_id AS id, element AS "option", params, enabled FROM v311_extensions
4 × SELECT t.parent_id FROM v311_categories as t
4 × SELECT t.parent_id FROM v311_menu as t
2 × SELECT a.id as id,a.type as type,a.name as name,a.clickurl as clickurl,a.cid as cid,a.params as params,a.custombannercode as custombannercode,a.track_impressions as track_impressions,cl.track_impressions as client_track_impressions FROM v311_banners as a LEFT JOIN v311_banner_clients AS cl ON cl.id = a.cid
2 × SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug FROM v311_categories as c LEFT JOIN v311_categories AS s ON (s.lft <= c.lft AND s.rgt >= c.rgt) OR (s.lft > c.lft AND s.rgt < c.rgt) LEFT JOIN (SELECT cat.id as id FROM v311_categories AS cat JOIN v311_categories AS parent ON cat.lft BETWEEN parent.lft AND parent.rgt
2 × SELECT b.rules FROM v311_assets AS a LEFT JOIN v311_assets AS b ON b.lft <= a.lft AND b.rgt >= a.rgt
1 × SELECT v311_categories.alias FROM v311_content, v311_categories
1 × SELECT a.id, CASE WHEN CHAR_LENGTH(a.alias) != 0 THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug, CASE WHEN CHAR_LENGTH(cc.alias) != 0 THEN CONCAT_WS(':', cc.id, cc.alias) ELSE cc.id END as catslug FROM v311_content AS a LEFT JOIN v311_categories AS cc ON cc.id = a.catid
1 × SELECT `m`.`tag_id`,`t`.* FROM `v311_contentitem_tag_map` AS m INNER JOIN `v311_tags` AS t ON `m`.`tag_id` = `t`.`id`
1 × SELECT m.published, m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params,am.params as advancedparams, 0 as menuid, m.publish_up, m.publish_down FROM v311_modules AS m LEFT JOIN v311_extensions AS e ON e.element = m.module AND e.client_id = m.client_id LEFT JOIN v311_advancedmodules as am ON am.moduleid = m.id
1 × SELECT * FROM v311_categories
1 × SELECT * FROM v311_banners
1 × SELECT `oldurl`, `dateadd` FROM v311_sh404sef_urls
1 × SELECT a.id, a.asset_id, a.title, a.alias, a.introtext, a.fulltext, CASE WHEN badcats.id is null THEN a.state ELSE 0 END AS state, a.catid, a.created, a.created_by, a.created_by_alias, CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,contact.id as contactid,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count FROM v311_content AS a LEFT JOIN v311_categories AS c on c.id = a.catid LEFT JOIN v311_users AS u on u.id = a.created_by LEFT JOIN ( SELECT contact.user_id, MAX(contact.id) AS id, contact.language FROM v311_contact_details AS contact
1 × SELECT m.menutype FROM v311_menu AS m
1 × SELECT `id`, `title`, `alias`, `catid`, `language` FROM v311_content
1 × SELECT * FROM v311_sh404sef_metas
1 × SELECT a.rules FROM v311_assets AS a
1 × SELECT params FROM v311_modules
1 × SELECT `params` FROM v311_extensions
1 × SELECT folder AS type, element AS name, params FROM v311_extensions
1 × SELECT id, rules FROM `v311_viewlevels
1 × SELECT `session_id` FROM `v311_session`
1 × SELECT b.id FROM v311_usergroups AS a LEFT JOIN v311_usergroups AS b ON b.lft <= a.lft AND b.rgt >= a.rgt
1 × SELECT * FROM v311_languages
1 × SELECT id,oldurl,newurl FROM `v311_sh404sef_urls`
1 × SELECT `oldurl`, `newurl`, `dateadd` FROM v311_sh404sef_urls
1 × SELECT id, home, template, s.params FROM v311_template_styles as s LEFT JOIN v311_extensions as e ON e.element=s.template AND e.type='template' AND e.client_id=s.client_id
1 × select `alias`,`newurl` from `v311_sh404sef_aliases`
1 × SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component FROM v311_menu AS m LEFT JOIN v311_extensions AS e ON m.component_id = e.extension_id
1 × SELECT * FROM `v311_osemsc_configuration
1 × SELECT * FROM `v311_osemsc_content`
1 × SELECT `data` FROM `v311_session`

OTHER Tables:

1 × SHOW FULL COLUMNS FROM `v311_sh404sef_metas
1 × UPDATE `v311_session` SET `data` = '__default|a:12:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1732779723;s:18:\"session.timer.last\";i:1732779723;s:17:\"session.timer.now\";i:1732779723;s:24:\"session.client.forwarded\";s:12:\"18.118.162.8\";s:22:\"session.client.browser\";s:103:\"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; [email protected])\";s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":0:{}}s:4:\"user\";O:5:\"JUser\":24:{s:9:\"\\0\\0\\0isRoot\";b:0;s:2:\"id\";i:0;s:4:\"name\";N;s:8:\"username\";N;s:5:\"email\";N;s:8:\"password\";N;s:14:\"password_clear\";s:0:\"\";s:5:\"block\";N;s:9:\"sendEmail\";i:0;s:12:\"registerDate\";N;s:13:\"lastvisitDate\";N;s:10:\"activation\";N;s:6:\"params\";N;s:6:\"groups\";a:1:{i:0;s:1:\"9\";}s:5:\"guest\";i:1;s:13:\"lastResetTime\";N;s:10:\"resetCount\";N;s:10:\"\\0\\0\\0_params\";O:9:\"JRegistry\":1:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":0:{}}s:14:\"\\0\\0\\0_authGroups\";a:2:{i:0;i:1;i:1;i:9;}s:14:\"\\0\\0\\0_authLevels\";a:3:{i:0;i:1;i:1;i:1;i:2;i:5;}s:15:\"\\0\\0\\0_authActions\";N;s:12:\"\\0\\0\\0_errorMsg\";N;s:10:\"\\0\\0\\0_errors\";a:0:{}s:3:\"aid\";i:0;}s:13:\"session.token\";s:32:\"5b76d3e656bf57ccdb8712a7b10d3328\";s:17:\"url_joomla_logout\";s:101:\"http://stage.aspho.org/index.php?option=com_users&task=user.logout&7aae635dca63b7c2e3a3fae2c3833499=1\";s:12:\"url_amc_prev\";s:86:\"http://306847.minerockhongkong.tech/meetings/review-course/2021-review-course/fox-2021\";s:8:\"oseClass\";a:9:{s:8:\"registry\";s:11:\"oseregistry\";s:3:\"msc\";s:10:\"membership\";s:4:\"user\";s:4:\"user\";s:6:\"member\";s:6:\"member\";s:7:\"payment\";s:7:\"payment\";s:6:\"remote\";s:6:\"remote\";s:3:\"lic\";s:7:\"license\";s:7:\"content\";s:7:\"content\";s:5:\"debug\";s:5:\"debug\";}}' , `time` = '1732779724'
1 × SHOW FULL COLUMNS FROM `v311_content
1 × UPDATE v311_content SET hits = hits + 1
1 × INSERT INTO `v311_session` (`session_id`, `client_id`, `time`) VALUES ('94qdvvpcuij8rkhi3hm3r63h45', 0, '1732779723'
1 × CREATE TABLE IF NOT EXISTS `v311_egd_impexiumsso` ( `id` int(11) NOT NULL auto_increment, `customer_token` text NOT NULL, `customer_id` text NOT NULL, `sso_return_url` text NOT NULL, `day` date NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=173
1 × DELETE FROM `v311_session`

2021 Review Course

January 27-30, 2021

Elizabeth Fox, MD

Joomla! Debug Console

Session

__default

user

groups

oseClass

Profile Information

Memory Usage

Database Queries

60 Queries Logged

41 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

OTHER Tables: