SELECT `group`, `data` FROM `config` WHERE `group` LIKE 'Global::%'Connection name: default
Speed: 0.725 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 `blog_posts`.* FROM `blog_posts` JOIN `blog_blogs` ON (`blog_posts`.`blog_id` = `blog_blogs`.`id`) WHERE `blog_posts`.`created_at` BETWEEN 1622530800 AND 1625122800 AND `blog_blogs`.`group_id` IS null ORDER BY `blog_posts`.`created_at` DESCConnection name: default
Speed: 3.978 ms
Query analysis:
· Query: SIMPLE on blog_blogs · Possible keys: PRIMARY,fk_blog_blogs_group · Key Used: fk_blog_blogs_group · Type: ref · Rows: 9 (Using where; Using index; Using temporary; Using filesort)
· Query: SIMPLE on blog_posts · 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/classes/controller/blogs.php, line 593File: 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-23'
) 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: 19.413 ms
Query analysis:
· Query: SIMPLE on stats · Possible keys: PRIMARY,Auto ID · Key Used: PRIMARY · Type: range · Rows: 1026 (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 597File: 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.405 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: 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.228 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: 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.198 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: 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.191 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: 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.191 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: 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.189 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: 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.221 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: 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.209 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: 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` = '6' 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: APPPATH/classes/model/base.php, line 941File: APPPATH/views/blog/archive-monthly.php, line 531File: 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: 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` = '930'Connection name: default
Speed: 31.330 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/archive-monthly.php, line 539File: 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: 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` = '6' LIMIT 1Connection name: default
Speed: 0.342 ms · DUPLICATE
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/views/blog/archive-monthly.php, line 531File: 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: 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` = '929'Connection name: default
Speed: 31.446 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/archive-monthly.php, line 539File: 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: 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` = '6' LIMIT 1Connection name: default
Speed: 0.328 ms · DUPLICATE
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/views/blog/archive-monthly.php, line 531File: 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: 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` = '928'Connection name: default
Speed: 31.477 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/archive-monthly.php, line 539File: 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: 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` = '6' LIMIT 1Connection name: default
Speed: 0.402 ms · DUPLICATE
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/views/blog/archive-monthly.php, line 531File: 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: 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` = '927'Connection name: default
Speed: 31.247 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/archive-monthly.php, line 539File: 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: 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` = '6' LIMIT 1Connection name: default
Speed: 0.385 ms · DUPLICATE
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/views/blog/archive-monthly.php, line 531File: 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: 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` = '926'Connection name: default
Speed: 31.428 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/archive-monthly.php, line 539File: 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: DOCROOT/index.php, line 142File: DOCROOT/index.php, line 239 |
SELECT * FROM `blog_blogs` WHERE `id` = '6' LIMIT 1Connection name: default
Speed: 0.344 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/archive-monthly.php, line 595File: 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: 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.336 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/archive-monthly.php, line 596File: 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: 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.311 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: 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.213 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: 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.227 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: 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.195 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: 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.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 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: 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.190 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: DOCROOT/index.php, line 142File: DOCROOT/index.php, line 239 |
