SELECT `group`, `data` FROM `config` WHERE `group` LIKE 'Global::%'Connection name: default Speed: 0.652 ms Query analysis: · Query: SIMPLE on config · Possible keys: group · Key Used: group · Type: range · Rows: 1 (Using index condition) Call trace for this query:File: APPPATH/classes/app.php, line 383File: APPPATH/classes/app.php, line 105File: APPPATH/config/event.php, line 6File: COREPATH/classes/event/instance.php, line 157File: COREPATH/classes/fuel.php, line 222File: APPPATH/bootstrap.php, line 43File: DOCROOT/index.php, line 205 |
SELECT `t0`.`id` AS `t0_c0`, `t0`.`name` AS `t0_c1`, `t0`.`description` AS `t0_c2`, `t0`.`slug` AS `t0_c3`, `t0`.`group_id` AS `t0_c4`, `t0`.`menu_id` AS `t0_c5`, `t0`.`rulegroup_id` AS `t0_c6`, `t0`.`created_at` AS `t0_c7`, `t0`.`updated_at` AS `t0_c8` FROM `blog_blogs` AS `t0` WHERE `t0`.`slug` = 'CPC' LIMIT 1Connection name: default Speed: 0.628 ms Query analysis: · Query: SIMPLE on t0 · Type: ALL · Rows: 22 (Using where) Call trace for this query:File: PKGPATH/orm/classes/query.php, line 1564File: APPPATH/classes/query.php, line 19File: PKGPATH/orm/classes/query.php, line 1641File: APPPATH/classes/controller/blogs.php, line 192File: APPPATH/classes/controller/blogs.php, line 146File: COREPATH/classes/request.php, line 476File: APPPATH/classes/controller/groups.php, line 137File: COREPATH/classes/request.php, line 476File: DOCROOT/index.php, line 142File: DOCROOT/index.php, line 239 |
SELECT `posts`.*, SUM(`combinedStats`.`count`) AS `hits`
FROM `blog_posts` AS `posts`
JOIN (
SELECT `count`, `foreign_key`
FROM `stats`
WHERE
`stats`.`type` = 'page_hit' AND
`stats`.`linked_to` = 'blog_post' AND
`stats`.`date` >= '2025-06-24'
) AS `combinedStats`
ON (
`combinedStats`.`foreign_key` = `posts`.`id` AND
`posts`.`published` = 'yes'
)
GROUP BY `foreign_key`
ORDER BY `hits` DESC
LIMIT 10Connection name: default Speed: 27.693 ms Query analysis: · Query: SIMPLE on stats · Possible keys: PRIMARY,Auto ID · Key Used: PRIMARY · Type: range · Rows: 1132 (Using where; Using temporary; Using filesort) · Query: SIMPLE on posts · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 (Using where) Call trace for this query:File: APPPATH/classes/repository/blog/post.php, line 39File: APPPATH/classes/controller/blogs.php, line 193File: APPPATH/classes/controller/blogs.php, line 146File: COREPATH/classes/request.php, line 476File: APPPATH/classes/controller/groups.php, line 137File: COREPATH/classes/request.php, line 476File: DOCROOT/index.php, line 142File: DOCROOT/index.php, line 239 |
SELECT `t0`.`id` AS `t0_c0`, `t0`.`blog_id` AS `t0_c1`, `t0`.`author` AS `t0_c2`, `t0`.`author_writer` AS `t0_c3`, `t0`.`video_embed` AS `t0_c4`, `t0`.`title` AS `t0_c5`, `t0`.`content` AS `t0_c6`, `t0`.`tags` AS `t0_c7`, `t0`.`published` AS `t0_c8`, `t0`.`accept_votes` AS `t0_c9`, `t0`.`voter_ids` AS `t0_c10`, `t0`.`accept_comments` AS `t0_c11`, `t0`.`user_id` AS `t0_c12`, `t0`.`attachment` AS `t0_c13`, `t0`.`votes` AS `t0_c14`, `t0`.`made_public` AS `t0_c15`, `t0`.`slug` AS `t0_c16`, `t0`.`created_at` AS `t0_c17`, `t0`.`updated_at` AS `t0_c18`, `t1`.`voter_ids` AS `t1_c0`, `t1`.`id` AS `t1_c1`, `t1`.`post_id` AS `t1_c2`, `t1`.`reply_to` AS `t1_c3`, `t1`.`user_id` AS `t1_c4`, `t1`.`comment` AS `t1_c5`, `t1`.`votes` AS `t1_c6`, `t1`.`created_at` AS `t1_c7`, `t1`.`updated_at` AS `t1_c8`, `t2`.`id` AS `t2_c0`, `t2`.`short_id` AS `t2_c1`, `t2`.`username` AS `t2_c2`, `t2`.`password` AS `t2_c3`, `t2`.`group` AS `t2_c4`, `t2`.`email` AS `t2_c5`, `t2`.`email_bounced` AS `t2_c6`, `t2`.`email_opt_in` AS `t2_c7`, `t2`.`approved` AS `t2_c8`, `t2`.`suspended` AS `t2_c9`, `t2`.`sea` AS `t2_c10`, `t2`.`constituent_id` AS `t2_c11`, `t2`.`group_membership` AS `t2_c12`, `t2`.`first_name` AS `t2_c13`, `t2`.`last_name` AS `t2_c14`, `t2`.`salutation` AS `t2_c15`, `t2`.`organization` AS `t2_c16`, `t2`.`title` AS `t2_c17`, `t2`.`phone_prim` AS `t2_c18`, `t2`.`address_1` AS `t2_c19`, `t2`.`address_2` AS `t2_c20`, `t2`.`city` AS `t2_c21`, `t2`.`state` AS `t2_c22`, `t2`.`state_abbr` AS `t2_c23`, `t2`.`zip` AS `t2_c24`, `t2`.`cc_email` AS `t2_c25`, `t2`.`cc_first_name` AS `t2_c26`, `t2`.`cc_last_name` AS `t2_c27`, `t2`.`phone_sec` AS `t2_c28`, `t2`.`physical_address_1` AS `t2_c29`, `t2`.`physical_address_2` AS `t2_c30`, `t2`.`physical_city` AS `t2_c31`, `t2`.`physical_zip` AS `t2_c32`, `t2`.`job_category` AS `t2_c33`, `t2`.`employer_category` AS `t2_c34`, `t2`.`org_id` AS `t2_c35`, `t2`.`org_admin` AS `t2_c36`, `t2`.`slug` AS `t2_c37`, `t2`.`merged` AS `t2_c38`, `t2`.`last_login` AS `t2_c39`, `t2`.`profile_fields` AS `t2_c40`, `t2`.`approved_at` AS `t2_c41`, `t2`.`created_at` AS `t2_c42`, `t2`.`updated_at` AS `t2_c43`, `t2`.`duplicate_state` AS `t2_c44`, `t2`.`login_hash` AS `t2_c45` FROM (SELECT `t0`.`id`, `t0`.`blog_id`, `t0`.`author`, `t0`.`author_writer`, `t0`.`video_embed`, `t0`.`title`, `t0`.`content`, `t0`.`tags`, `t0`.`published`, `t0`.`accept_votes`, `t0`.`voter_ids`, `t0`.`accept_comments`, `t0`.`user_id`, `t0`.`attachment`, `t0`.`votes`, `t0`.`made_public`, `t0`.`slug`, `t0`.`created_at`, `t0`.`updated_at` FROM `blog_posts` AS `t0` WHERE `t0`.`slug` = 'ideas-thoughts-from-the-2019-conference-to-help-plan-for-2020' AND `t0`.`blog_id` = '25' AND `t0`.`published` = 'yes' LIMIT 1) AS `t0` LEFT JOIN `blog_comments` AS `t1` ON (`t0`.`id` = `t1`.`post_id`) LEFT JOIN `users` AS `t2` ON (`t0`.`user_id` = `t2`.`id`)Connection name: default Speed: 1.071 ms Query analysis: · Query: PRIMARY on <derived2> · Type: system · Rows: 1 · Query: PRIMARY on t1 · Possible keys: fk_blog_comments_post · Key Used: fk_blog_comments_post · Type: ref · Rows: 1 · Query: PRIMARY on t2 · Possible keys: PRIMARY · Key Used: PRIMARY · Type: const · Rows: 1 · Query: DERIVED on t0 · Possible keys: fk_blog_posts_blog · Key Used: fk_blog_posts_blog · Type: ref · Rows: 1 (Using where) Call trace for this query:File: PKGPATH/orm/classes/query.php, line 1564File: APPPATH/classes/query.php, line 19File: PKGPATH/orm/classes/query.php, line 1641File: APPPATH/classes/controller/blogs.php, line 221File: APPPATH/classes/controller/blogs.php, line 146File: COREPATH/classes/request.php, line 476File: APPPATH/classes/controller/groups.php, line 137File: COREPATH/classes/request.php, line 476File: DOCROOT/index.php, line 142File: DOCROOT/index.php, line 239 |
INSERT INTO `stats`
(`date`, `type`, `count`, `page`, `linked_to`, `foreign_key`, `created_at`, `updated_at`)
VALUES ('2025-06-29', 'page_hit', 1, 'https://eseanetwork.openwebportal.com/groups/blogs/CPC/ideas-thoughts-from-the-2019-conference-to-help-plan-for-2020', 'blog_post', '680', '1751184209', '1751184209')
ON DUPLICATE KEY
UPDATE `count` = `count` + 1, `updated_at` = 1751184209Connection name: default Speed: 8.649 ms Call trace for this query:File: APPPATH/classes/repository/stat.php, line 30File: APPPATH/classes/controller/blogs.php, line 255File: APPPATH/classes/controller/blogs.php, line 146File: COREPATH/classes/request.php, line 476File: APPPATH/classes/controller/groups.php, line 137File: COREPATH/classes/request.php, line 476File: DOCROOT/index.php, line 142File: DOCROOT/index.php, line 239 |
SELECT `t0`.`name` AS `t0_c0`, `t0`.`items` AS `t0_c1`, `t0`.`class` AS `t0_c2`, `t0`.`before` AS `t0_c3`, `t0`.`after` AS `t0_c4`, `t0`.`css` AS `t0_c5`, `t0`.`js` AS `t0_c6`, `t0`.`main_banner` AS `t0_c7`, `t0`.`secondary_banner` AS `t0_c8`, `t0`.`background_image` AS `t0_c9`, `t0`.`background_color` AS `t0_c10`, `t0`.`extra` AS `t0_c11`, `t0`.`id` AS `t0_c12`, `t0`.`created_at` AS `t0_c13`, `t0`.`updated_at` AS `t0_c14` FROM `cms_menus` AS `t0` WHERE `t0`.`id` = 44 LIMIT 1Connection name: default Speed: 0.828 ms Query analysis: · Query: SIMPLE on t0 · Possible keys: PRIMARY · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: PKGPATH/orm/classes/query.php, line 1564File: APPPATH/classes/query.php, line 19File: PKGPATH/orm/classes/query.php, line 1641File: PKGPATH/orm/classes/model.php, line 668File: APPPATH/modules/cms/classes/cms.php, line 496File: APPPATH/modules/cms/classes/cms.php, line 477File: APPPATH/views/templates/master/mobile-nav.php, line 73File: COREPATH/classes/view.php, line 258File: COREPATH/classes/view.php, line 274File: COREPATH/classes/view.php, line 681File: COREPATH/classes/view.php, line 227File: APPPATH/views/templates/blog.php, line 126File: COREPATH/classes/view.php, line 258File: COREPATH/classes/view.php, line 274File: COREPATH/classes/view.php, line 681File: APPPATH/classes/controller/blogs.php, line 26File: COREPATH/classes/request.php, line 478File: APPPATH/classes/controller/groups.php, line 137File: COREPATH/classes/request.php, line 476File: DOCROOT/index.php, line 142File: DOCROOT/index.php, line 239 |
SELECT `t0`.`name` AS `t0_c0`, `t0`.`items` AS `t0_c1`, `t0`.`class` AS `t0_c2`, `t0`.`before` AS `t0_c3`, `t0`.`after` AS `t0_c4`, `t0`.`css` AS `t0_c5`, `t0`.`js` AS `t0_c6`, `t0`.`main_banner` AS `t0_c7`, `t0`.`secondary_banner` AS `t0_c8`, `t0`.`background_image` AS `t0_c9`, `t0`.`background_color` AS `t0_c10`, `t0`.`extra` AS `t0_c11`, `t0`.`id` AS `t0_c12`, `t0`.`created_at` AS `t0_c13`, `t0`.`updated_at` AS `t0_c14` FROM `cms_menus` AS `t0` WHERE `t0`.`id` = 49 LIMIT 1Connection name: default Speed: 0.934 ms Query analysis: · Query: SIMPLE on t0 · Possible keys: PRIMARY · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: PKGPATH/orm/classes/query.php, line 1564File: APPPATH/classes/query.php, line 19File: PKGPATH/orm/classes/query.php, line 1641File: PKGPATH/orm/classes/model.php, line 668File: APPPATH/modules/cms/classes/cms.php, line 496File: APPPATH/modules/cms/classes/cms.php, line 477File: APPPATH/views/templates/master/mobile-nav.php, line 84File: COREPATH/classes/view.php, line 258File: COREPATH/classes/view.php, line 274File: COREPATH/classes/view.php, line 681File: COREPATH/classes/view.php, line 227File: APPPATH/views/templates/blog.php, line 126File: COREPATH/classes/view.php, line 258File: COREPATH/classes/view.php, line 274File: COREPATH/classes/view.php, line 681File: APPPATH/classes/controller/blogs.php, line 26File: COREPATH/classes/request.php, line 478File: APPPATH/classes/controller/groups.php, line 137File: COREPATH/classes/request.php, line 476File: DOCROOT/index.php, line 142File: DOCROOT/index.php, line 239 |
SELECT `t0`.`name` AS `t0_c0`, `t0`.`items` AS `t0_c1`, `t0`.`class` AS `t0_c2`, `t0`.`before` AS `t0_c3`, `t0`.`after` AS `t0_c4`, `t0`.`css` AS `t0_c5`, `t0`.`js` AS `t0_c6`, `t0`.`main_banner` AS `t0_c7`, `t0`.`secondary_banner` AS `t0_c8`, `t0`.`background_image` AS `t0_c9`, `t0`.`background_color` AS `t0_c10`, `t0`.`extra` AS `t0_c11`, `t0`.`id` AS `t0_c12`, `t0`.`created_at` AS `t0_c13`, `t0`.`updated_at` AS `t0_c14` FROM `cms_menus` AS `t0` WHERE `t0`.`id` = 48 LIMIT 1Connection name: default Speed: 0.629 ms Query analysis: · Query: SIMPLE on t0 · Possible keys: PRIMARY · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: PKGPATH/orm/classes/query.php, line 1564File: APPPATH/classes/query.php, line 19File: PKGPATH/orm/classes/query.php, line 1641File: PKGPATH/orm/classes/model.php, line 668File: APPPATH/modules/cms/classes/cms.php, line 496File: APPPATH/modules/cms/classes/cms.php, line 477File: APPPATH/views/templates/master/mobile-nav.php, line 95File: COREPATH/classes/view.php, line 258File: COREPATH/classes/view.php, line 274File: COREPATH/classes/view.php, line 681File: COREPATH/classes/view.php, line 227File: APPPATH/views/templates/blog.php, line 126File: COREPATH/classes/view.php, line 258File: COREPATH/classes/view.php, line 274File: COREPATH/classes/view.php, line 681File: APPPATH/classes/controller/blogs.php, line 26File: COREPATH/classes/request.php, line 478File: APPPATH/classes/controller/groups.php, line 137File: COREPATH/classes/request.php, line 476File: DOCROOT/index.php, line 142File: DOCROOT/index.php, line 239 |
SELECT `t0`.`name` AS `t0_c0`, `t0`.`items` AS `t0_c1`, `t0`.`class` AS `t0_c2`, `t0`.`before` AS `t0_c3`, `t0`.`after` AS `t0_c4`, `t0`.`css` AS `t0_c5`, `t0`.`js` AS `t0_c6`, `t0`.`main_banner` AS `t0_c7`, `t0`.`secondary_banner` AS `t0_c8`, `t0`.`background_image` AS `t0_c9`, `t0`.`background_color` AS `t0_c10`, `t0`.`extra` AS `t0_c11`, `t0`.`id` AS `t0_c12`, `t0`.`created_at` AS `t0_c13`, `t0`.`updated_at` AS `t0_c14` FROM `cms_menus` AS `t0` WHERE `t0`.`id` = 47 LIMIT 1Connection name: default Speed: 0.541 ms Query analysis: · Query: SIMPLE on t0 · Possible keys: PRIMARY · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: PKGPATH/orm/classes/query.php, line 1564File: APPPATH/classes/query.php, line 19File: PKGPATH/orm/classes/query.php, line 1641File: PKGPATH/orm/classes/model.php, line 668File: APPPATH/modules/cms/classes/cms.php, line 496File: APPPATH/modules/cms/classes/cms.php, line 477File: APPPATH/views/templates/master/mobile-nav.php, line 107File: COREPATH/classes/view.php, line 258File: COREPATH/classes/view.php, line 274File: COREPATH/classes/view.php, line 681File: COREPATH/classes/view.php, line 227File: APPPATH/views/templates/blog.php, line 126File: COREPATH/classes/view.php, line 258File: COREPATH/classes/view.php, line 274File: COREPATH/classes/view.php, line 681File: APPPATH/classes/controller/blogs.php, line 26File: COREPATH/classes/request.php, line 478File: APPPATH/classes/controller/groups.php, line 137File: COREPATH/classes/request.php, line 476File: DOCROOT/index.php, line 142File: DOCROOT/index.php, line 239 |
SELECT `t0`.`name` AS `t0_c0`, `t0`.`items` AS `t0_c1`, `t0`.`class` AS `t0_c2`, `t0`.`before` AS `t0_c3`, `t0`.`after` AS `t0_c4`, `t0`.`css` AS `t0_c5`, `t0`.`js` AS `t0_c6`, `t0`.`main_banner` AS `t0_c7`, `t0`.`secondary_banner` AS `t0_c8`, `t0`.`background_image` AS `t0_c9`, `t0`.`background_color` AS `t0_c10`, `t0`.`extra` AS `t0_c11`, `t0`.`id` AS `t0_c12`, `t0`.`created_at` AS `t0_c13`, `t0`.`updated_at` AS `t0_c14` FROM `cms_menus` AS `t0` WHERE `t0`.`id` = 60 LIMIT 1Connection name: default Speed: 0.498 ms Query analysis: · Query: SIMPLE on t0 · Possible keys: PRIMARY · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: PKGPATH/orm/classes/query.php, line 1564File: APPPATH/classes/query.php, line 19File: PKGPATH/orm/classes/query.php, line 1641File: PKGPATH/orm/classes/model.php, line 668File: APPPATH/modules/cms/classes/cms.php, line 496File: APPPATH/modules/cms/classes/cms.php, line 477File: APPPATH/views/templates/master/mobile-nav.php, line 119File: COREPATH/classes/view.php, line 258File: COREPATH/classes/view.php, line 274File: COREPATH/classes/view.php, line 681File: COREPATH/classes/view.php, line 227File: APPPATH/views/templates/blog.php, line 126File: COREPATH/classes/view.php, line 258File: COREPATH/classes/view.php, line 274File: COREPATH/classes/view.php, line 681File: APPPATH/classes/controller/blogs.php, line 26File: COREPATH/classes/request.php, line 478File: APPPATH/classes/controller/groups.php, line 137File: COREPATH/classes/request.php, line 476File: DOCROOT/index.php, line 142File: DOCROOT/index.php, line 239 |
SELECT `t0`.`name` AS `t0_c0`, `t0`.`items` AS `t0_c1`, `t0`.`class` AS `t0_c2`, `t0`.`before` AS `t0_c3`, `t0`.`after` AS `t0_c4`, `t0`.`css` AS `t0_c5`, `t0`.`js` AS `t0_c6`, `t0`.`main_banner` AS `t0_c7`, `t0`.`secondary_banner` AS `t0_c8`, `t0`.`background_image` AS `t0_c9`, `t0`.`background_color` AS `t0_c10`, `t0`.`extra` AS `t0_c11`, `t0`.`id` AS `t0_c12`, `t0`.`created_at` AS `t0_c13`, `t0`.`updated_at` AS `t0_c14` FROM `cms_menus` AS `t0` WHERE `t0`.`id` = 62 LIMIT 1Connection name: default Speed: 0.477 ms Query analysis: · Query: SIMPLE on t0 · Possible keys: PRIMARY · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: PKGPATH/orm/classes/query.php, line 1564File: APPPATH/classes/query.php, line 19File: PKGPATH/orm/classes/query.php, line 1641File: PKGPATH/orm/classes/model.php, line 668File: APPPATH/modules/cms/classes/cms.php, line 496File: APPPATH/modules/cms/classes/cms.php, line 477File: APPPATH/views/templates/master/mobile-nav.php, line 130File: COREPATH/classes/view.php, line 258File: COREPATH/classes/view.php, line 274File: COREPATH/classes/view.php, line 681File: COREPATH/classes/view.php, line 227File: APPPATH/views/templates/blog.php, line 126File: COREPATH/classes/view.php, line 258File: COREPATH/classes/view.php, line 274File: COREPATH/classes/view.php, line 681File: APPPATH/classes/controller/blogs.php, line 26File: COREPATH/classes/request.php, line 478File: APPPATH/classes/controller/groups.php, line 137File: COREPATH/classes/request.php, line 476File: DOCROOT/index.php, line 142File: DOCROOT/index.php, line 239 |
SELECT `t0`.`name` AS `t0_c0`, `t0`.`items` AS `t0_c1`, `t0`.`class` AS `t0_c2`, `t0`.`before` AS `t0_c3`, `t0`.`after` AS `t0_c4`, `t0`.`css` AS `t0_c5`, `t0`.`js` AS `t0_c6`, `t0`.`main_banner` AS `t0_c7`, `t0`.`secondary_banner` AS `t0_c8`, `t0`.`background_image` AS `t0_c9`, `t0`.`background_color` AS `t0_c10`, `t0`.`extra` AS `t0_c11`, `t0`.`id` AS `t0_c12`, `t0`.`created_at` AS `t0_c13`, `t0`.`updated_at` AS `t0_c14` FROM `cms_menus` AS `t0` WHERE `t0`.`id` = 46 LIMIT 1Connection name: default Speed: 0.603 ms Query analysis: · Query: SIMPLE on t0 · Possible keys: PRIMARY · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: PKGPATH/orm/classes/query.php, line 1564File: APPPATH/classes/query.php, line 19File: PKGPATH/orm/classes/query.php, line 1641File: PKGPATH/orm/classes/model.php, line 668File: APPPATH/modules/cms/classes/cms.php, line 496File: APPPATH/modules/cms/classes/cms.php, line 477File: APPPATH/views/templates/master/mobile-nav.php, line 141File: COREPATH/classes/view.php, line 258File: COREPATH/classes/view.php, line 274File: COREPATH/classes/view.php, line 681File: COREPATH/classes/view.php, line 227File: APPPATH/views/templates/blog.php, line 126File: COREPATH/classes/view.php, line 258File: COREPATH/classes/view.php, line 274File: COREPATH/classes/view.php, line 681File: APPPATH/classes/controller/blogs.php, line 26File: COREPATH/classes/request.php, line 478File: APPPATH/classes/controller/groups.php, line 137File: COREPATH/classes/request.php, line 476File: DOCROOT/index.php, line 142File: DOCROOT/index.php, line 239 |
SELECT `t0`.`name` AS `t0_c0`, `t0`.`items` AS `t0_c1`, `t0`.`class` AS `t0_c2`, `t0`.`before` AS `t0_c3`, `t0`.`after` AS `t0_c4`, `t0`.`css` AS `t0_c5`, `t0`.`js` AS `t0_c6`, `t0`.`main_banner` AS `t0_c7`, `t0`.`secondary_banner` AS `t0_c8`, `t0`.`background_image` AS `t0_c9`, `t0`.`background_color` AS `t0_c10`, `t0`.`extra` AS `t0_c11`, `t0`.`id` AS `t0_c12`, `t0`.`created_at` AS `t0_c13`, `t0`.`updated_at` AS `t0_c14` FROM `cms_menus` AS `t0` WHERE `t0`.`id` = 1 LIMIT 1Connection name: default Speed: 0.558 ms Query analysis: · Query: SIMPLE on t0 · Possible keys: PRIMARY · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: PKGPATH/orm/classes/query.php, line 1564File: APPPATH/classes/query.php, line 19File: PKGPATH/orm/classes/query.php, line 1641File: PKGPATH/orm/classes/model.php, line 668File: APPPATH/modules/cms/classes/cms.php, line 496File: APPPATH/views/templates/master/sticky-header.php, line 128File: COREPATH/classes/view.php, line 258File: COREPATH/classes/view.php, line 274File: COREPATH/classes/view.php, line 681File: COREPATH/classes/view.php, line 227File: APPPATH/views/templates/blog.php, line 129File: COREPATH/classes/view.php, line 258File: COREPATH/classes/view.php, line 274File: COREPATH/classes/view.php, line 681File: APPPATH/classes/controller/blogs.php, line 26File: COREPATH/classes/request.php, line 478File: APPPATH/classes/controller/groups.php, line 137File: COREPATH/classes/request.php, line 476File: DOCROOT/index.php, line 142File: DOCROOT/index.php, line 239 |
SELECT `post`.*, `blog`.`name` AS `blog_name`, `blog`.`slug` AS `blog_slug` FROM `blog_blogs` AS `blog` JOIN `blog_posts` AS `post` ON (`post`.`blog_id` = `blog`.`id` AND `blog`.`id` IN (1,3,4,5,6) AND `post`.`published` = 'yes') GROUP BY `post`.`title` ORDER BY `post`.`created_at` DESC LIMIT 3Connection name: default Speed: 14.063 ms Query analysis: · Query: SIMPLE on blog · Possible keys: PRIMARY · Key Used: PRIMARY · Type: range · Rows: 5 (Using where; Using temporary; Using filesort) · Query: SIMPLE on post · Possible keys: fk_blog_posts_blog · Key Used: fk_blog_posts_blog · Type: ref · Rows: 23 (Using where) Call trace for this query:File: APPPATH/views/blog/post.php, line 20File: COREPATH/classes/view.php, line 258File: COREPATH/classes/view.php, line 274File: COREPATH/classes/view.php, line 681File: COREPATH/classes/view.php, line 227File: APPPATH/views/templates/blog.php, line 132File: COREPATH/classes/view.php, line 258File: COREPATH/classes/view.php, line 274File: COREPATH/classes/view.php, line 681File: APPPATH/classes/controller/blogs.php, line 26File: COREPATH/classes/request.php, line 478File: APPPATH/classes/controller/groups.php, line 137File: COREPATH/classes/request.php, line 476File: DOCROOT/index.php, line 142File: DOCROOT/index.php, line 239 |
SELECT `t0`.`id` AS `t0_c0`, `t0`.`name` AS `t0_c1`, `t0`.`description` AS `t0_c2`, `t0`.`slug` AS `t0_c3`, `t0`.`group_id` AS `t0_c4`, `t0`.`menu_id` AS `t0_c5`, `t0`.`rulegroup_id` AS `t0_c6`, `t0`.`created_at` AS `t0_c7`, `t0`.`updated_at` AS `t0_c8` FROM `blog_blogs` AS `t0` WHERE `t0`.`id` = '25' LIMIT 1Connection name: default Speed: 0.351 ms Query analysis: · Query: SIMPLE on t0 · Possible keys: PRIMARY · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: PKGPATH/orm/classes/query.php, line 1564File: APPPATH/classes/query.php, line 19File: PKGPATH/orm/classes/query.php, line 1641File: PKGPATH/orm/classes/belongsto.php, line 66File: PKGPATH/orm/classes/model.php, line 1232File: PKGPATH/orm/classes/model.php, line 1068File: APPPATH/views/blog/post.php, line 661File: COREPATH/classes/view.php, line 258File: COREPATH/classes/view.php, line 274File: COREPATH/classes/view.php, line 681File: COREPATH/classes/view.php, line 227File: APPPATH/views/templates/blog.php, line 132File: COREPATH/classes/view.php, line 258File: COREPATH/classes/view.php, line 274File: COREPATH/classes/view.php, line 681File: APPPATH/classes/controller/blogs.php, line 26File: COREPATH/classes/request.php, line 478File: APPPATH/classes/controller/groups.php, line 137File: COREPATH/classes/request.php, line 476File: DOCROOT/index.php, line 142File: DOCROOT/index.php, line 239 |
SELECT `t0`.`rel_paths` AS `t0_c0`, `t0`.`data` AS `t0_c1`, `t0`.`id` AS `t0_c2`, `t0`.`name` AS `t0_c3`, `t0`.`filename` AS `t0_c4`, `t0`.`orig_url` AS `t0_c5`, `t0`.`base_url` AS `t0_c6`, `t0`.`type` AS `t0_c7`, `t0`.`linked_to` AS `t0_c8`, `t0`.`event_code` AS `t0_c9`, `t0`.`foreign_key` AS `t0_c10`, `t0`.`extension` AS `t0_c11`, `t0`.`size` AS `t0_c12`, `t0`.`created_at` AS `t0_c13`, `t0`.`updated_at` AS `t0_c14` FROM `images` AS `t0` WHERE `t0`.`linked_to` = 'blog_post' AND `t0`.`foreign_key` = '680'Connection name: default Speed: 32.799 ms Query analysis: · Query: SIMPLE on t0 · Type: ALL · Rows: 28284 (Using where) Call trace for this query:File: PKGPATH/orm/classes/query.php, line 1564File: APPPATH/classes/query.php, line 19File: APPPATH/views/blog/post.php, line 722File: COREPATH/classes/view.php, line 258File: COREPATH/classes/view.php, line 274File: COREPATH/classes/view.php, line 681File: COREPATH/classes/view.php, line 227File: APPPATH/views/templates/blog.php, line 132File: COREPATH/classes/view.php, line 258File: COREPATH/classes/view.php, line 274File: COREPATH/classes/view.php, line 681File: APPPATH/classes/controller/blogs.php, line 26File: COREPATH/classes/request.php, line 478File: APPPATH/classes/controller/groups.php, line 137File: COREPATH/classes/request.php, line 476File: DOCROOT/index.php, line 142File: DOCROOT/index.php, line 239 |
SELECT `t0`.`id` AS `t0_c0`, `t0`.`short_id` AS `t0_c1`, `t0`.`username` AS `t0_c2`, `t0`.`password` AS `t0_c3`, `t0`.`group` AS `t0_c4`, `t0`.`email` AS `t0_c5`, `t0`.`email_bounced` AS `t0_c6`, `t0`.`email_opt_in` AS `t0_c7`, `t0`.`approved` AS `t0_c8`, `t0`.`suspended` AS `t0_c9`, `t0`.`sea` AS `t0_c10`, `t0`.`constituent_id` AS `t0_c11`, `t0`.`group_membership` AS `t0_c12`, `t0`.`first_name` AS `t0_c13`, `t0`.`last_name` AS `t0_c14`, `t0`.`salutation` AS `t0_c15`, `t0`.`organization` AS `t0_c16`, `t0`.`title` AS `t0_c17`, `t0`.`phone_prim` AS `t0_c18`, `t0`.`address_1` AS `t0_c19`, `t0`.`address_2` AS `t0_c20`, `t0`.`city` AS `t0_c21`, `t0`.`state` AS `t0_c22`, `t0`.`state_abbr` AS `t0_c23`, `t0`.`zip` AS `t0_c24`, `t0`.`cc_email` AS `t0_c25`, `t0`.`cc_first_name` AS `t0_c26`, `t0`.`cc_last_name` AS `t0_c27`, `t0`.`phone_sec` AS `t0_c28`, `t0`.`physical_address_1` AS `t0_c29`, `t0`.`physical_address_2` AS `t0_c30`, `t0`.`physical_city` AS `t0_c31`, `t0`.`physical_zip` AS `t0_c32`, `t0`.`job_category` AS `t0_c33`, `t0`.`employer_category` AS `t0_c34`, `t0`.`org_id` AS `t0_c35`, `t0`.`org_admin` AS `t0_c36`, `t0`.`slug` AS `t0_c37`, `t0`.`merged` AS `t0_c38`, `t0`.`last_login` AS `t0_c39`, `t0`.`profile_fields` AS `t0_c40`, `t0`.`approved_at` AS `t0_c41`, `t0`.`created_at` AS `t0_c42`, `t0`.`updated_at` AS `t0_c43`, `t0`.`duplicate_state` AS `t0_c44`, `t0`.`login_hash` AS `t0_c45` FROM `users` AS `t0` WHERE `t0`.`id` = 'F4429969-CA3E-4362-83B5-1300A2ECAF55' LIMIT 1Connection name: default Speed: 0.486 ms Query analysis: · Query: SIMPLE on t0 · Possible keys: PRIMARY · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: PKGPATH/orm/classes/query.php, line 1564File: APPPATH/classes/query.php, line 19File: PKGPATH/orm/classes/query.php, line 1641File: PKGPATH/orm/classes/belongsto.php, line 66File: PKGPATH/orm/classes/model.php, line 1232File: PKGPATH/orm/classes/model.php, line 1068File: APPPATH/views/blog/comments.php, line 16File: COREPATH/classes/view.php, line 258File: COREPATH/classes/view.php, line 274File: COREPATH/classes/view.php, line 681File: COREPATH/classes/view.php, line 227File: APPPATH/views/blog/post.php, line 834File: COREPATH/classes/view.php, line 258File: COREPATH/classes/view.php, line 274File: COREPATH/classes/view.php, line 681File: COREPATH/classes/view.php, line 227File: APPPATH/views/templates/blog.php, line 132File: COREPATH/classes/view.php, line 258File: COREPATH/classes/view.php, line 274File: COREPATH/classes/view.php, line 681File: APPPATH/classes/controller/blogs.php, line 26File: COREPATH/classes/request.php, line 478File: APPPATH/classes/controller/groups.php, line 137File: COREPATH/classes/request.php, line 476File: DOCROOT/index.php, line 142File: DOCROOT/index.php, line 239 |
SELECT `t0`.`title` AS `t0_c0`, `t0`.`folder` AS `t0_c1`, `t0`.`show_title` AS `t0_c2`, `t0`.`published` AS `t0_c3`, `t0`.`published_range` AS `t0_c4`, `t0`.`publish_start` AS `t0_c5`, `t0`.`publish_end` AS `t0_c6`, `t0`.`content` AS `t0_c7`, `t0`.`css` AS `t0_c8`, `t0`.`js` AS `t0_c9`, `t0`.`rulegroup_id` AS `t0_c10`, `t0`.`menu` AS `t0_c11`, `t0`.`widget` AS `t0_c12`, `t0`.`widget_type` AS `t0_c13`, `t0`.`created_at` AS `t0_c14`, `t0`.`updated_at` AS `t0_c15`, `t0`.`id` AS `t0_c16` FROM `cms_posts` AS `t0` WHERE `t0`.`id` = 492 LIMIT 1Connection name: default Speed: 0.306 ms Query analysis: · Query: SIMPLE on t0 · Possible keys: PRIMARY · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: PKGPATH/orm/classes/query.php, line 1564File: APPPATH/classes/query.php, line 19File: PKGPATH/orm/classes/query.php, line 1641File: APPPATH/classes/model/base.php, line 941File: APPPATH/modules/cms/classes/cms.php, line 194File: APPPATH/views/templates/master/footer.php, line 4File: COREPATH/classes/view.php, line 258File: COREPATH/classes/view.php, line 274File: COREPATH/classes/view.php, line 681File: COREPATH/classes/view.php, line 227File: APPPATH/views/templates/blog.php, line 134File: COREPATH/classes/view.php, line 258File: COREPATH/classes/view.php, line 274File: COREPATH/classes/view.php, line 681File: APPPATH/classes/controller/blogs.php, line 26File: COREPATH/classes/request.php, line 478File: APPPATH/classes/controller/groups.php, line 137File: COREPATH/classes/request.php, line 476File: DOCROOT/index.php, line 142File: DOCROOT/index.php, line 239 |
SELECT `t0`.`title` AS `t0_c0`, `t0`.`folder` AS `t0_c1`, `t0`.`show_title` AS `t0_c2`, `t0`.`published` AS `t0_c3`, `t0`.`published_range` AS `t0_c4`, `t0`.`publish_start` AS `t0_c5`, `t0`.`publish_end` AS `t0_c6`, `t0`.`content` AS `t0_c7`, `t0`.`css` AS `t0_c8`, `t0`.`js` AS `t0_c9`, `t0`.`rulegroup_id` AS `t0_c10`, `t0`.`menu` AS `t0_c11`, `t0`.`widget` AS `t0_c12`, `t0`.`widget_type` AS `t0_c13`, `t0`.`created_at` AS `t0_c14`, `t0`.`updated_at` AS `t0_c15`, `t0`.`id` AS `t0_c16` FROM `cms_posts` AS `t0` WHERE `t0`.`id` = 493 LIMIT 1Connection name: default Speed: 0.217 ms Query analysis: · Query: SIMPLE on t0 · Possible keys: PRIMARY · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: PKGPATH/orm/classes/query.php, line 1564File: APPPATH/classes/query.php, line 19File: PKGPATH/orm/classes/query.php, line 1641File: APPPATH/classes/model/base.php, line 941File: APPPATH/modules/cms/classes/cms.php, line 194File: APPPATH/views/templates/master/footer.php, line 7File: COREPATH/classes/view.php, line 258File: COREPATH/classes/view.php, line 274File: COREPATH/classes/view.php, line 681File: COREPATH/classes/view.php, line 227File: APPPATH/views/templates/blog.php, line 134File: COREPATH/classes/view.php, line 258File: COREPATH/classes/view.php, line 274File: COREPATH/classes/view.php, line 681File: APPPATH/classes/controller/blogs.php, line 26File: COREPATH/classes/request.php, line 478File: APPPATH/classes/controller/groups.php, line 137File: COREPATH/classes/request.php, line 476File: DOCROOT/index.php, line 142File: DOCROOT/index.php, line 239 |
SELECT `t0`.`title` AS `t0_c0`, `t0`.`folder` AS `t0_c1`, `t0`.`show_title` AS `t0_c2`, `t0`.`published` AS `t0_c3`, `t0`.`published_range` AS `t0_c4`, `t0`.`publish_start` AS `t0_c5`, `t0`.`publish_end` AS `t0_c6`, `t0`.`content` AS `t0_c7`, `t0`.`css` AS `t0_c8`, `t0`.`js` AS `t0_c9`, `t0`.`rulegroup_id` AS `t0_c10`, `t0`.`menu` AS `t0_c11`, `t0`.`widget` AS `t0_c12`, `t0`.`widget_type` AS `t0_c13`, `t0`.`created_at` AS `t0_c14`, `t0`.`updated_at` AS `t0_c15`, `t0`.`id` AS `t0_c16` FROM `cms_posts` AS `t0` WHERE `t0`.`id` = 494 LIMIT 1Connection name: default Speed: 0.210 ms Query analysis: · Query: SIMPLE on t0 · Possible keys: PRIMARY · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: PKGPATH/orm/classes/query.php, line 1564File: APPPATH/classes/query.php, line 19File: PKGPATH/orm/classes/query.php, line 1641File: APPPATH/classes/model/base.php, line 941File: APPPATH/modules/cms/classes/cms.php, line 194File: APPPATH/views/templates/master/footer.php, line 8File: COREPATH/classes/view.php, line 258File: COREPATH/classes/view.php, line 274File: COREPATH/classes/view.php, line 681File: COREPATH/classes/view.php, line 227File: APPPATH/views/templates/blog.php, line 134File: COREPATH/classes/view.php, line 258File: COREPATH/classes/view.php, line 274File: COREPATH/classes/view.php, line 681File: APPPATH/classes/controller/blogs.php, line 26File: COREPATH/classes/request.php, line 478File: APPPATH/classes/controller/groups.php, line 137File: COREPATH/classes/request.php, line 476File: DOCROOT/index.php, line 142File: DOCROOT/index.php, line 239 |
SELECT `t0`.`title` AS `t0_c0`, `t0`.`folder` AS `t0_c1`, `t0`.`show_title` AS `t0_c2`, `t0`.`published` AS `t0_c3`, `t0`.`published_range` AS `t0_c4`, `t0`.`publish_start` AS `t0_c5`, `t0`.`publish_end` AS `t0_c6`, `t0`.`content` AS `t0_c7`, `t0`.`css` AS `t0_c8`, `t0`.`js` AS `t0_c9`, `t0`.`rulegroup_id` AS `t0_c10`, `t0`.`menu` AS `t0_c11`, `t0`.`widget` AS `t0_c12`, `t0`.`widget_type` AS `t0_c13`, `t0`.`created_at` AS `t0_c14`, `t0`.`updated_at` AS `t0_c15`, `t0`.`id` AS `t0_c16` FROM `cms_posts` AS `t0` WHERE `t0`.`id` = 495 LIMIT 1Connection name: default Speed: 0.240 ms Query analysis: · Query: SIMPLE on t0 · Possible keys: PRIMARY · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: PKGPATH/orm/classes/query.php, line 1564File: APPPATH/classes/query.php, line 19File: PKGPATH/orm/classes/query.php, line 1641File: APPPATH/classes/model/base.php, line 941File: APPPATH/modules/cms/classes/cms.php, line 194File: APPPATH/views/templates/master/footer.php, line 9File: COREPATH/classes/view.php, line 258File: COREPATH/classes/view.php, line 274File: COREPATH/classes/view.php, line 681File: COREPATH/classes/view.php, line 227File: APPPATH/views/templates/blog.php, line 134File: COREPATH/classes/view.php, line 258File: COREPATH/classes/view.php, line 274File: COREPATH/classes/view.php, line 681File: APPPATH/classes/controller/blogs.php, line 26File: COREPATH/classes/request.php, line 478File: APPPATH/classes/controller/groups.php, line 137File: COREPATH/classes/request.php, line 476File: DOCROOT/index.php, line 142File: DOCROOT/index.php, line 239 |
SELECT `t0`.`title` AS `t0_c0`, `t0`.`folder` AS `t0_c1`, `t0`.`show_title` AS `t0_c2`, `t0`.`published` AS `t0_c3`, `t0`.`published_range` AS `t0_c4`, `t0`.`publish_start` AS `t0_c5`, `t0`.`publish_end` AS `t0_c6`, `t0`.`content` AS `t0_c7`, `t0`.`css` AS `t0_c8`, `t0`.`js` AS `t0_c9`, `t0`.`rulegroup_id` AS `t0_c10`, `t0`.`menu` AS `t0_c11`, `t0`.`widget` AS `t0_c12`, `t0`.`widget_type` AS `t0_c13`, `t0`.`created_at` AS `t0_c14`, `t0`.`updated_at` AS `t0_c15`, `t0`.`id` AS `t0_c16` FROM `cms_posts` AS `t0` WHERE `t0`.`id` = 496 LIMIT 1Connection name: default Speed: 0.244 ms Query analysis: · Query: SIMPLE on t0 · Possible keys: PRIMARY · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: PKGPATH/orm/classes/query.php, line 1564File: APPPATH/classes/query.php, line 19File: PKGPATH/orm/classes/query.php, line 1641File: APPPATH/classes/model/base.php, line 941File: APPPATH/modules/cms/classes/cms.php, line 194File: APPPATH/views/templates/master/footer.php, line 10File: COREPATH/classes/view.php, line 258File: COREPATH/classes/view.php, line 274File: COREPATH/classes/view.php, line 681File: COREPATH/classes/view.php, line 227File: APPPATH/views/templates/blog.php, line 134File: COREPATH/classes/view.php, line 258File: COREPATH/classes/view.php, line 274File: COREPATH/classes/view.php, line 681File: APPPATH/classes/controller/blogs.php, line 26File: COREPATH/classes/request.php, line 478File: APPPATH/classes/controller/groups.php, line 137File: COREPATH/classes/request.php, line 476File: DOCROOT/index.php, line 142File: DOCROOT/index.php, line 239 |
SELECT `t0`.`title` AS `t0_c0`, `t0`.`folder` AS `t0_c1`, `t0`.`show_title` AS `t0_c2`, `t0`.`published` AS `t0_c3`, `t0`.`published_range` AS `t0_c4`, `t0`.`publish_start` AS `t0_c5`, `t0`.`publish_end` AS `t0_c6`, `t0`.`content` AS `t0_c7`, `t0`.`css` AS `t0_c8`, `t0`.`js` AS `t0_c9`, `t0`.`rulegroup_id` AS `t0_c10`, `t0`.`menu` AS `t0_c11`, `t0`.`widget` AS `t0_c12`, `t0`.`widget_type` AS `t0_c13`, `t0`.`created_at` AS `t0_c14`, `t0`.`updated_at` AS `t0_c15`, `t0`.`id` AS `t0_c16` FROM `cms_posts` AS `t0` WHERE `t0`.`id` = 497 LIMIT 1Connection name: default Speed: 0.243 ms Query analysis: · Query: SIMPLE on t0 · Possible keys: PRIMARY · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: PKGPATH/orm/classes/query.php, line 1564File: APPPATH/classes/query.php, line 19File: PKGPATH/orm/classes/query.php, line 1641File: APPPATH/classes/model/base.php, line 941File: APPPATH/modules/cms/classes/cms.php, line 194File: APPPATH/views/templates/master/footer.php, line 13File: COREPATH/classes/view.php, line 258File: COREPATH/classes/view.php, line 274File: COREPATH/classes/view.php, line 681File: COREPATH/classes/view.php, line 227File: APPPATH/views/templates/blog.php, line 134File: COREPATH/classes/view.php, line 258File: COREPATH/classes/view.php, line 274File: COREPATH/classes/view.php, line 681File: APPPATH/classes/controller/blogs.php, line 26File: COREPATH/classes/request.php, line 478File: APPPATH/classes/controller/groups.php, line 137File: COREPATH/classes/request.php, line 476File: DOCROOT/index.php, line 142File: DOCROOT/index.php, line 239 |
COMMENTS
Otistene Smith
• 02/21/2019 07:58 AM
Public School Program Coordinator, Arkansas Department of Education
Facilitator/Evaluation Form- Approximately how many attendees left before the end of the session closing time. Since we have overlapping sessions and people coming in and out sometimes to replace those that left, is this a necessary question on this form?