SELECT `group`, `data` FROM `config` WHERE `group` LIKE 'Global::%'Connection name: default
Speed: 0.763 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` = 'CPC2015' LIMIT 1Connection name: default
Speed: 0.461 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: 24.255 ms
Query analysis:
· Query: SIMPLE on stats · Possible keys: PRIMARY,Auto ID · Key Used: PRIMARY · Type: range · Rows: 1184 (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` = 'keynote-topics' AND `t0`.`blog_id` = '14' 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: 0.889 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: 2
· 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: 16 (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/CPC2015/keynote-topics', 'blog_post', '277', '1751207458', '1751207458')
ON DUPLICATE KEY
UPDATE `count` = `count` + 1, `updated_at` = 1751207458Connection name: default
Speed: 5.575 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.367 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.278 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.242 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.222 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.256 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.248 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.260 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.229 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: 8.646 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` = '14' LIMIT 1Connection name: default
Speed: 0.263 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 657File: 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` = '277'Connection name: default
Speed: 32.345 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`.`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` = '1079'Connection name: default
Speed: 31.956 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 804File: 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` = '1078'Connection name: default
Speed: 31.747 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 804File: 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` = '1076'Connection name: default
Speed: 31.394 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 804File: 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` = 'A586DA7A-1ECB-42BE-9F54-BC168FEBBF72' LIMIT 1Connection name: default
Speed: 0.440 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`.`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.321 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 * FROM `blog_blogs` WHERE `id` = '24' LIMIT 1Connection name: default
Speed: 0.216 ms
Query analysis:
· Query: SIMPLE on blog_blogs · Possible keys: PRIMARY · Key Used: PRIMARY · Type: const · Rows: 1
Call trace for this query:File: APPPATH/classes/model/base.php, line 412File: APPPATH/views/blog/post.php, line 846File: 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` IS nullConnection name: default
Speed: 31.363 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 847File: 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` = '1079'Connection name: default
Speed: 31.271 ms · DUPLICATE
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 911File: 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` = '1078'Connection name: default
Speed: 31.627 ms · DUPLICATE
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 911File: 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` = '1076'Connection name: default
Speed: 31.403 ms · DUPLICATE
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 911File: 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.436 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.222 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.203 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.200 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.265 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.202 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
Beth Wooster
• 05/12/2014 09:11 AM
Federal Programs Administrator, Nebraska Department of Education
Dr. Donna Beegle was great last year! I have heard several people that were at her session talk about it months later. Her story is one that sticks with you!
Otistene Smith
• 03/26/2014 08:07 AM
Public School Program Coordinator, Arkansas Department of Education
The topic of Rigorous instruction. Dr. Robyn Jackson session was packed to the brim. Participants were verbalizing that they wanted more of this in the way of implementation. A good speaker along this topic. Racial Equity in Schools - Topic to be continued for everyone to hear.