SELECT `group`, `data` FROM `config` WHERE `group` LIKE 'Global::%'Connection name: default Speed: 0.722 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`.*, COUNT(`blog_id`) AS `postCount` FROM `blog_posts` JOIN `blog_blogs` ON (`blog_blogs`.`id` = `blog_posts`.`blog_id`) WHERE `blog_blogs`.`group_id` IS null GROUP BY `blog_id`Connection name: default Speed: 6.179 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) · Query: SIMPLE on blog_posts · Possible keys: fk_blog_posts_blog · Key Used: fk_blog_posts_blog · Type: ref · Rows: 23 Call trace for this query:File: APPPATH/classes/controller/blogs.php, line 664File: COREPATH/classes/request.php, line 476File: DOCROOT/index.php, line 142File: DOCROOT/index.php, line 239 |
SELECT `blog_posts`.*, COUNT(`user_id`) AS `authorCount` FROM `blog_posts` JOIN `blog_blogs` ON (`blog_blogs`.`id` = `blog_posts`.`blog_id`) WHERE `blog_blogs`.`group_id` IS null GROUP BY `user_id`Connection name: default Speed: 4.101 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) · Query: SIMPLE on blog_posts · Possible keys: fk_blog_posts_blog,fk_blog_posts_user · Key Used: fk_blog_posts_blog · Type: ref · Rows: 23 Call trace for this query:File: APPPATH/classes/controller/blogs.php, line 673File: COREPATH/classes/request.php, line 476File: DOCROOT/index.php, line 142File: DOCROOT/index.php, line 239 |
SELECT `tags` FROM `blog_posts` JOIN `blog_blogs` ON (`blog_blogs`.`id` = `blog_posts`.`blog_id`) WHERE `blog_blogs`.`group_id` IS nullConnection name: default Speed: 1.043 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) · Query: SIMPLE on blog_posts · Possible keys: fk_blog_posts_blog · Key Used: fk_blog_posts_blog · Type: ref · Rows: 23 Call trace for this query:File: APPPATH/classes/controller/blogs.php, line 680File: 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: 15.755 ms Query analysis: · Query: SIMPLE on stats · Possible keys: PRIMARY,Auto ID · Key Used: PRIMARY · Type: range · Rows: 814 (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 707File: 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.377 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.255 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.218 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.211 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.238 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.234 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.223 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.259 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 `blog_posts`.*, COUNT(`blog_id`) AS `monthCount` FROM `blog_posts` JOIN `blog_blogs` ON (`blog_blogs`.`id` = `blog_posts`.`blog_id`) WHERE `blog_blogs`.`group_id` IS null AND `blog_posts`.`created_at` BETWEEN 1257058800 AND 1259654400 ORDER BY `blog_posts`.`created_at` DESCConnection name: default Speed: 2.042 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) · 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/views/blog/archive.php, line 193File: 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 `blog_posts`.*, COUNT(`blog_id`) AS `monthCount` FROM `blog_posts` JOIN `blog_blogs` ON (`blog_blogs`.`id` = `blog_posts`.`blog_id`) WHERE `blog_blogs`.`group_id` IS null AND `blog_posts`.`created_at` BETWEEN 1259654400 AND 1262332800 ORDER BY `blog_posts`.`created_at` DESCConnection name: default Speed: 1.589 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) · 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/views/blog/archive.php, line 193File: 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 `blog_posts`.*, COUNT(`blog_id`) AS `monthCount` FROM `blog_posts` JOIN `blog_blogs` ON (`blog_blogs`.`id` = `blog_posts`.`blog_id`) WHERE `blog_blogs`.`group_id` IS null AND `blog_posts`.`created_at` BETWEEN 1262332800 AND 1265011200 ORDER BY `blog_posts`.`created_at` DESCConnection name: default Speed: 1.541 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) · 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/views/blog/archive.php, line 193File: 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 `blog_posts`.*, COUNT(`blog_id`) AS `monthCount` FROM `blog_posts` JOIN `blog_blogs` ON (`blog_blogs`.`id` = `blog_posts`.`blog_id`) WHERE `blog_blogs`.`group_id` IS null AND `blog_posts`.`created_at` BETWEEN 1265011200 AND 1267430400 ORDER BY `blog_posts`.`created_at` DESCConnection name: default Speed: 1.513 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) · 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/views/blog/archive.php, line 193File: 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 `blog_posts`.*, COUNT(`blog_id`) AS `monthCount` FROM `blog_posts` JOIN `blog_blogs` ON (`blog_blogs`.`id` = `blog_posts`.`blog_id`) WHERE `blog_blogs`.`group_id` IS null AND `blog_posts`.`created_at` BETWEEN 1267430400 AND 1270105200 ORDER BY `blog_posts`.`created_at` DESCConnection name: default Speed: 1.481 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) · 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/views/blog/archive.php, line 193File: 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 `blog_posts`.*, COUNT(`blog_id`) AS `monthCount` FROM `blog_posts` JOIN `blog_blogs` ON (`blog_blogs`.`id` = `blog_posts`.`blog_id`) WHERE `blog_blogs`.`group_id` IS null AND `blog_posts`.`created_at` BETWEEN 1270105200 AND 1272697200 ORDER BY `blog_posts`.`created_at` DESCConnection name: default Speed: 1.526 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) · 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/views/blog/archive.php, line 193File: 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 `blog_posts`.*, COUNT(`blog_id`) AS `monthCount` FROM `blog_posts` JOIN `blog_blogs` ON (`blog_blogs`.`id` = `blog_posts`.`blog_id`) WHERE `blog_blogs`.`group_id` IS null AND `blog_posts`.`created_at` BETWEEN 1272697200 AND 1275375600 ORDER BY `blog_posts`.`created_at` DESCConnection name: default Speed: 1.521 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) · 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/views/blog/archive.php, line 193File: 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 `blog_posts`.*, COUNT(`blog_id`) AS `monthCount` FROM `blog_posts` JOIN `blog_blogs` ON (`blog_blogs`.`id` = `blog_posts`.`blog_id`) WHERE `blog_blogs`.`group_id` IS null AND `blog_posts`.`created_at` BETWEEN 1275375600 AND 1277967600 ORDER BY `blog_posts`.`created_at` DESCConnection name: default Speed: 1.503 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) · 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/views/blog/archive.php, line 193File: 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 `blog_posts`.*, COUNT(`blog_id`) AS `monthCount` FROM `blog_posts` JOIN `blog_blogs` ON (`blog_blogs`.`id` = `blog_posts`.`blog_id`) WHERE `blog_blogs`.`group_id` IS null AND `blog_posts`.`created_at` BETWEEN 1277967600 AND 1280646000 ORDER BY `blog_posts`.`created_at` DESCConnection name: default Speed: 1.457 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) · 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/views/blog/archive.php, line 193File: 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 `blog_posts`.*, COUNT(`blog_id`) AS `monthCount` FROM `blog_posts` JOIN `blog_blogs` ON (`blog_blogs`.`id` = `blog_posts`.`blog_id`) WHERE `blog_blogs`.`group_id` IS null AND `blog_posts`.`created_at` BETWEEN 1280646000 AND 1283324400 ORDER BY `blog_posts`.`created_at` DESCConnection name: default Speed: 1.473 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) · 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/views/blog/archive.php, line 193File: 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 `blog_posts`.*, COUNT(`blog_id`) AS `monthCount` FROM `blog_posts` JOIN `blog_blogs` ON (`blog_blogs`.`id` = `blog_posts`.`blog_id`) WHERE `blog_blogs`.`group_id` IS null AND `blog_posts`.`created_at` BETWEEN 1283324400 AND 1285916400 ORDER BY `blog_posts`.`created_at` DESCConnection name: default Speed: 1.489 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) · 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/views/blog/archive.php, line 193File: 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 `blog_posts`.*, COUNT(`blog_id`) AS `monthCount` FROM `blog_posts` JOIN `blog_blogs` ON (`blog_blogs`.`id` = `blog_posts`.`blog_id`) WHERE `blog_blogs`.`group_id` IS null AND `blog_posts`.`created_at` BETWEEN 1285916400 AND 1288594800 ORDER BY `blog_posts`.`created_at` DESCConnection name: default Speed: 1.465 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) · 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/views/blog/archive.php, line 193File: 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 `blog_posts`.*, COUNT(`blog_id`) AS `monthCount` FROM `blog_posts` JOIN `blog_blogs` ON (`blog_blogs`.`id` = `blog_posts`.`blog_id`) WHERE `blog_blogs`.`group_id` IS null AND `blog_posts`.`created_at` BETWEEN 1288594800 AND 1291190400 ORDER BY `blog_posts`.`created_at` DESCConnection name: default Speed: 1.479 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) · 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/views/blog/archive.php, line 193File: 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 `blog_posts`.*, COUNT(`blog_id`) AS `monthCount` FROM `blog_posts` JOIN `blog_blogs` ON (`blog_blogs`.`id` = `blog_posts`.`blog_id`) WHERE `blog_blogs`.`group_id` IS null AND `blog_posts`.`created_at` BETWEEN 1291190400 AND 1293868800 ORDER BY `blog_posts`.`created_at` DESCConnection name: default Speed: 1.512 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) · 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/views/blog/archive.php, line 193File: 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 `blog_posts`.*, COUNT(`blog_id`) AS `monthCount` FROM `blog_posts` JOIN `blog_blogs` ON (`blog_blogs`.`id` = `blog_posts`.`blog_id`) WHERE `blog_blogs`.`group_id` IS null AND `blog_posts`.`created_at` BETWEEN 1293868800 AND 1296547200 ORDER BY `blog_posts`.`created_at` DESCConnection name: default Speed: 1.449 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) · 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/views/blog/archive.php, line 193File: 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 `blog_posts`.*, COUNT(`blog_id`) AS `monthCount` FROM `blog_posts` JOIN `blog_blogs` ON (`blog_blogs`.`id` = `blog_posts`.`blog_id`) WHERE `blog_blogs`.`group_id` IS null AND `blog_posts`.`created_at` BETWEEN 1296547200 AND 1298966400 ORDER BY `blog_posts`.`created_at` DESCConnection name: default Speed: 1.487 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) · 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/views/blog/archive.php, line 193File: 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 `blog_posts`.*, COUNT(`blog_id`) AS `monthCount` FROM `blog_posts` JOIN `blog_blogs` ON (`blog_blogs`.`id` = `blog_posts`.`blog_id`) WHERE `blog_blogs`.`group_id` IS null AND `blog_posts`.`created_at` BETWEEN 1298966400 AND 1301641200 ORDER BY `blog_posts`.`created_at` DESCConnection name: default Speed: 1.460 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) · 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/views/blog/archive.php, line 193File: 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 `blog_posts`.*, COUNT(`blog_id`) AS `monthCount` FROM `blog_posts` JOIN `blog_blogs` ON (`blog_blogs`.`id` = `blog_posts`.`blog_id`) WHERE `blog_blogs`.`group_id` IS null AND `blog_posts`.`created_at` BETWEEN 1301641200 AND 1304233200 ORDER BY `blog_posts`.`created_at` DESCConnection name: default Speed: 1.485 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) · 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/views/blog/archive.php, line 193File: 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 `blog_posts`.*, COUNT(`blog_id`) AS `monthCount` FROM `blog_posts` JOIN `blog_blogs` ON (`blog_blogs`.`id` = `blog_posts`.`blog_id`) WHERE `blog_blogs`.`group_id` IS null AND `blog_posts`.`created_at` BETWEEN 1304233200 AND 1306911600 ORDER BY `blog_posts`.`created_at` DESCConnection name: default Speed: 1.430 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) · 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/views/blog/archive.php, line 193File: 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 `blog_posts`.*, COUNT(`blog_id`) AS `monthCount` FROM `blog_posts` JOIN `blog_blogs` ON (`blog_blogs`.`id` = `blog_posts`.`blog_id`) WHERE `blog_blogs`.`group_id` IS null AND `blog_posts`.`created_at` BETWEEN 1306911600 AND 1309503600 ORDER BY `blog_posts`.`created_at` DESCConnection name: default Speed: 1.491 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) · 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/views/blog/archive.php, line 193File: 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 `blog_posts`.*, COUNT(`blog_id`) AS `monthCount` FROM `blog_posts` JOIN `blog_blogs` ON (`blog_blogs`.`id` = `blog_posts`.`blog_id`) WHERE `blog_blogs`.`group_id` IS null AND `blog_posts`.`created_at` BETWEEN 1309503600 AND 1312182000 ORDER BY `blog_posts`.`created_at` DESCConnection name: default Speed: 1.435 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) · 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/views/blog/archive.php, line 193File: 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 `blog_posts`.*, COUNT(`blog_id`) AS `monthCount` FROM `blog_posts` JOIN `blog_blogs` ON (`blog_blogs`.`id` = `blog_posts`.`blog_id`) WHERE `blog_blogs`.`group_id` IS null AND `blog_posts`.`created_at` BETWEEN 1312182000 AND 1314860400 ORDER BY `blog_posts`.`created_at` DESCConnection name: default Speed: 1.453 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) · 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/views/blog/archive.php, line 193File: 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 `blog_posts`.*, COUNT(`blog_id`) AS `monthCount` FROM `blog_posts` JOIN `blog_blogs` ON (`blog_blogs`.`id` = `blog_posts`.`blog_id`) WHERE `blog_blogs`.`group_id` IS null AND `blog_posts`.`created_at` BETWEEN 1314860400 AND 1317452400 ORDER BY `blog_posts`.`created_at` DESCConnection name: default Speed: 1.472 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) · 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/views/blog/archive.php, line 193File: 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 `blog_posts`.*, COUNT(`blog_id`) AS `monthCount` FROM `blog_posts` JOIN `blog_blogs` ON (`blog_blogs`.`id` = `blog_posts`.`blog_id`) WHERE `blog_blogs`.`group_id` IS null AND `blog_posts`.`created_at` BETWEEN 1317452400 AND 1320130800 ORDER BY `blog_posts`.`created_at` DESCConnection name: default Speed: 1.495 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) · 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/views/blog/archive.php, line 193File: 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 `blog_posts`.*, COUNT(`blog_id`) AS `monthCount` FROM `blog_posts` JOIN `blog_blogs` ON (`blog_blogs`.`id` = `blog_posts`.`blog_id`) WHERE `blog_blogs`.`group_id` IS null AND `blog_posts`.`created_at` BETWEEN 1320130800 AND 1322726400 ORDER BY `blog_posts`.`created_at` DESCConnection name: default Speed: 1.420 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) · 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/views/blog/archive.php, line 193File: 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 `blog_posts`.*, COUNT(`blog_id`) AS `monthCount` FROM `blog_posts` JOIN `blog_blogs` ON (`blog_blogs`.`id` = `blog_posts`.`blog_id`) WHERE `blog_blogs`.`group_id` IS null AND `blog_posts`.`created_at` BETWEEN 1322726400 AND 1325404800 ORDER BY `blog_posts`.`created_at` DESCConnection name: default Speed: 1.514 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) · 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/views/blog/archive.php, line 193File: 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 `blog_posts`.*, COUNT(`blog_id`) AS `monthCount` FROM `blog_posts` JOIN `blog_blogs` ON (`blog_blogs`.`id` = `blog_posts`.`blog_id`) WHERE `blog_blogs`.`group_id` IS null AND `blog_posts`.`created_at` BETWEEN 1325404800 AND 1328083200 ORDER BY `blog_posts`.`created_at` DESCConnection name: default Speed: 1.418 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) · 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/views/blog/archive.php, line 193File: 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 `blog_posts`.*, COUNT(`blog_id`) AS `monthCount` FROM `blog_posts` JOIN `blog_blogs` ON (`blog_blogs`.`id` = `blog_posts`.`blog_id`) WHERE `blog_blogs`.`group_id` IS null AND `blog_posts`.`created_at` BETWEEN 1328083200 AND 1330588800 ORDER BY `blog_posts`.`created_at` DESCConnection name: default Speed: 1.500 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) · 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/views/blog/archive.php, line 193File: 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 `blog_posts`.*, COUNT(`blog_id`) AS `monthCount` FROM `blog_posts` JOIN `blog_blogs` ON (`blog_blogs`.`id` = `blog_posts`.`blog_id`) WHERE `blog_blogs`.`group_id` IS null AND `blog_posts`.`created_at` BETWEEN 1330588800 AND 1333263600 ORDER BY `blog_posts`.`created_at` DESCConnection name: default Speed: 1.427 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) · 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/views/blog/archive.php, line 193File: 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 `blog_posts`.*, COUNT(`blog_id`) AS `monthCount` FROM `blog_posts` JOIN `blog_blogs` ON (`blog_blogs`.`id` = `blog_posts`.`blog_id`) WHERE `blog_blogs`.`group_id` IS null AND `blog_posts`.`created_at` BETWEEN 1333263600 AND 1335855600 ORDER BY `blog_posts`.`created_at` DESCConnection name: default Speed: 1.411 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) · 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/views/blog/archive.php, line 193File: 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 `blog_posts`.*, COUNT(`blog_id`) AS `monthCount` FROM `blog_posts` JOIN `blog_blogs` ON (`blog_blogs`.`id` = `blog_posts`.`blog_id`) WHERE `blog_blogs`.`group_id` IS null AND `blog_posts`.`created_at` BETWEEN 1335855600 AND 1338534000 ORDER BY `blog_posts`.`created_at` DESCConnection name: default Speed: 1.444 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) · 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/views/blog/archive.php, line 193File: 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 `blog_posts`.*, COUNT(`blog_id`) AS `monthCount` FROM `blog_posts` JOIN `blog_blogs` ON (`blog_blogs`.`id` = `blog_posts`.`blog_id`) WHERE `blog_blogs`.`group_id` IS null AND `blog_posts`.`created_at` BETWEEN 1338534000 AND 1341126000 ORDER BY `blog_posts`.`created_at` DESCConnection name: default Speed: 1.409 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) · 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/views/blog/archive.php, line 193File: 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 `blog_posts`.*, COUNT(`blog_id`) AS `monthCount` FROM `blog_posts` JOIN `blog_blogs` ON (`blog_blogs`.`id` = `blog_posts`.`blog_id`) WHERE `blog_blogs`.`group_id` IS null AND `blog_posts`.`created_at` BETWEEN 1341126000 AND 1343804400 ORDER BY `blog_posts`.`created_at` DESCConnection name: default Speed: 1.491 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) · 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/views/blog/archive.php, line 193File: 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 `blog_posts`.*, COUNT(`blog_id`) AS `monthCount` FROM `blog_posts` JOIN `blog_blogs` ON (`blog_blogs`.`id` = `blog_posts`.`blog_id`) WHERE `blog_blogs`.`group_id` IS null AND `blog_posts`.`created_at` BETWEEN 1343804400 AND 1346482800 ORDER BY `blog_posts`.`created_at` DESCConnection name: default Speed: 1.421 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) · 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/views/blog/archive.php, line 193File: 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 `blog_posts`.*, COUNT(`blog_id`) AS `monthCount` FROM `blog_posts` JOIN `blog_blogs` ON (`blog_blogs`.`id` = `blog_posts`.`blog_id`) WHERE `blog_blogs`.`group_id` IS null AND `blog_posts`.`created_at` BETWEEN 1346482800 AND 1349074800 ORDER BY `blog_posts`.`created_at` DESCConnection name: default Speed: 1.411 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) · 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/views/blog/archive.php, line 193File: 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 `blog_posts`.*, COUNT(`blog_id`) AS `monthCount` FROM `blog_posts` JOIN `blog_blogs` ON (`blog_blogs`.`id` = `blog_posts`.`blog_id`) WHERE `blog_blogs`.`group_id` IS null AND `blog_posts`.`created_at` BETWEEN 1349074800 AND 1351753200 ORDER BY `blog_posts`.`created_at` DESCConnection name: default Speed: 1.431 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) · 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/views/blog/archive.php, line 193File: 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 `blog_posts`.*, COUNT(`blog_id`) AS `monthCount` FROM `blog_posts` JOIN `blog_blogs` ON (`blog_blogs`.`id` = `blog_posts`.`blog_id`) WHERE `blog_blogs`.`group_id` IS null AND `blog_posts`.`created_at` BETWEEN 1351753200 AND 1354348800 ORDER BY `blog_posts`.`created_at` DESCConnection name: default Speed: 1.406 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) · 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/views/blog/archive.php, line 193File: 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 `blog_posts`.*, COUNT(`blog_id`) AS `monthCount` FROM `blog_posts` JOIN `blog_blogs` ON (`blog_blogs`.`id` = `blog_posts`.`blog_id`) WHERE `blog_blogs`.`group_id` IS null AND `blog_posts`.`created_at` BETWEEN 1354348800 AND 1357027200 ORDER BY `blog_posts`.`created_at` DESCConnection name: default Speed: 1.436 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) · 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/views/blog/archive.php, line 193File: 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 `blog_posts`.*, COUNT(`blog_id`) AS `monthCount` FROM `blog_posts` JOIN `blog_blogs` ON (`blog_blogs`.`id` = `blog_posts`.`blog_id`) WHERE `blog_blogs`.`group_id` IS null AND `blog_posts`.`created_at` BETWEEN 1357027200 AND 1359705600 ORDER BY `blog_posts`.`created_at` DESCConnection name: default Speed: 1.487 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) · 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/views/blog/archive.php, line 193File: 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 `blog_posts`.*, COUNT(`blog_id`) AS `monthCount` FROM `blog_posts` JOIN `blog_blogs` ON (`blog_blogs`.`id` = `blog_posts`.`blog_id`) WHERE `blog_blogs`.`group_id` IS null AND `blog_posts`.`created_at` BETWEEN 1359705600 AND 1362124800 ORDER BY `blog_posts`.`created_at` DESCConnection name: default Speed: 1.416 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) · 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/views/blog/archive.php, line 193File: 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 `blog_posts`.*, COUNT(`blog_id`) AS `monthCount` FROM `blog_posts` JOIN `blog_blogs` ON (`blog_blogs`.`id` = `blog_posts`.`blog_id`) WHERE `blog_blogs`.`group_id` IS null AND `blog_posts`.`created_at` BETWEEN 1362124800 AND 1364799600 ORDER BY `blog_posts`.`created_at` DESCConnection name: default Speed: 1.448 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) · 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/views/blog/archive.php, line 193File: 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 `blog_posts`.*, COUNT(`blog_id`) AS `monthCount` FROM `blog_posts` JOIN `blog_blogs` ON (`blog_blogs`.`id` = `blog_posts`.`blog_id`) WHERE `blog_blogs`.`group_id` IS null AND `blog_posts`.`created_at` BETWEEN 1364799600 AND 1367391600 ORDER BY `blog_posts`.`created_at` DESCConnection name: default Speed: 1.450 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) · 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/views/blog/archive.php, line 193File: 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 `blog_posts`.*, COUNT(`blog_id`) AS `monthCount` FROM `blog_posts` JOIN `blog_blogs` ON (`blog_blogs`.`id` = `blog_posts`.`blog_id`) WHERE `blog_blogs`.`group_id` IS null AND `blog_posts`.`created_at` BETWEEN 1367391600 AND 1370070000 ORDER BY `blog_posts`.`created_at` DESCConnection name: default Speed: 1.464 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) · 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/views/blog/archive.php, line 193File: 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 `blog_posts`.*, COUNT(`blog_id`) AS `monthCount` FROM `blog_posts` JOIN `blog_blogs` ON (`blog_blogs`.`id` = `blog_posts`.`blog_id`) WHERE `blog_blogs`.`group_id` IS null AND `blog_posts`.`created_at` BETWEEN 1370070000 AND 1372662000 ORDER BY `blog_posts`.`created_at` DESCConnection name: default Speed: 1.440 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) · 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/views/blog/archive.php, line 193File: 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 `blog_posts`.*, COUNT(`blog_id`) AS `monthCount` FROM `blog_posts` JOIN `blog_blogs` ON (`blog_blogs`.`id` = `blog_posts`.`blog_id`) WHERE `blog_blogs`.`group_id` IS null AND `blog_posts`.`created_at` BETWEEN 1372662000 AND 1375340400 ORDER BY `blog_posts`.`created_at` DESCConnection name: default Speed: 1.491 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) · 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/views/blog/archive.php, line 193File: 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 `blog_posts`.*, COUNT(`blog_id`) AS `monthCount` FROM `blog_posts` JOIN `blog_blogs` ON (`blog_blogs`.`id` = `blog_posts`.`blog_id`) WHERE `blog_blogs`.`group_id` IS null AND `blog_posts`.`created_at` BETWEEN 1375340400 AND 1378018800 ORDER BY `blog_posts`.`created_at` DESCConnection name: default Speed: 1.467 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) · 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/views/blog/archive.php, line 193File: 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 `blog_posts`.*, COUNT(`blog_id`) AS `monthCount` FROM `blog_posts` JOIN `blog_blogs` ON (`blog_blogs`.`id` = `blog_posts`.`blog_id`) WHERE `blog_blogs`.`group_id` IS null AND `blog_posts`.`created_at` BETWEEN 1378018800 AND 1380610800 ORDER BY `blog_posts`.`created_at` DESCConnection name: default Speed: 1.413 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) · 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/views/blog/archive.php, line 193File: 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 `blog_posts`.*, COUNT(`blog_id`) AS `monthCount` FROM `blog_posts` JOIN `blog_blogs` ON (`blog_blogs`.`id` = `blog_posts`.`blog_id`) WHERE `blog_blogs`.`group_id` IS null AND `blog_posts`.`created_at` BETWEEN 1380610800 AND 1383289200 ORDER BY `blog_posts`.`created_at` DESCConnection name: default Speed: 1.448 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) · 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/views/blog/archive.php, line 193File: 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 `blog_posts`.*, COUNT(`blog_id`) AS `monthCount` FROM `blog_posts` JOIN `blog_blogs` ON (`blog_blogs`.`id` = `blog_posts`.`blog_id`) WHERE `blog_blogs`.`group_id` IS null AND `blog_posts`.`created_at` BETWEEN 1383289200 AND 1385884800 ORDER BY `blog_posts`.`created_at` DESCConnection name: default Speed: 1.410 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) · 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/views/blog/archive.php, line 193File: 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 `blog_posts`.*, COUNT(`blog_id`) AS `monthCount` FROM `blog_posts` JOIN `blog_blogs` ON (`blog_blogs`.`id` = `blog_posts`.`blog_id`) WHERE `blog_blogs`.`group_id` IS null AND `blog_posts`.`created_at` BETWEEN 1385884800 AND 1388563200 ORDER BY `blog_posts`.`created_at` DESCConnection name: default Speed: 1.415 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) · 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/views/blog/archive.php, line 193File: 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 `blog_posts`.*, COUNT(`blog_id`) AS `monthCount` FROM `blog_posts` JOIN `blog_blogs` ON (`blog_blogs`.`id` = `blog_posts`.`blog_id`) WHERE `blog_blogs`.`group_id` IS null AND `blog_posts`.`created_at` BETWEEN 1388563200 AND 1391241600 ORDER BY `blog_posts`.`created_at` DESCConnection name: default Speed: 1.442 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) · 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/views/blog/archive.php, line 193File: 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 `blog_posts`.*, COUNT(`blog_id`) AS `monthCount` FROM `blog_posts` JOIN `blog_blogs` ON (`blog_blogs`.`id` = `blog_posts`.`blog_id`) WHERE `blog_blogs`.`group_id` IS null AND `blog_posts`.`created_at` BETWEEN 1391241600 AND 1393660800 ORDER BY `blog_posts`.`created_at` DESCConnection name: default Speed: 1.462 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) · 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/views/blog/archive.php, line 193File: 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 `blog_posts`.*, COUNT(`blog_id`) AS `monthCount` FROM `blog_posts` JOIN `blog_blogs` ON (`blog_blogs`.`id` = `blog_posts`.`blog_id`) WHERE `blog_blogs`.`group_id` IS null AND `blog_posts`.`created_at` BETWEEN 1393660800 AND 1396335600 ORDER BY `blog_posts`.`created_at` DESCConnection name: default Speed: 1.461 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) · 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/views/blog/archive.php, line 193File: 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 `blog_posts`.*, COUNT(`blog_id`) AS `monthCount` FROM `blog_posts` JOIN `blog_blogs` ON (`blog_blogs`.`id` = `blog_posts`.`blog_id`) WHERE `blog_blogs`.`group_id` IS null AND `blog_posts`.`created_at` BETWEEN 1396335600 AND 1398927600 ORDER BY `blog_posts`.`created_at` DESCConnection name: default Speed: 1.489 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) · 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/views/blog/archive.php, line 193File: 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 `blog_posts`.*, COUNT(`blog_id`) AS `monthCount` FROM `blog_posts` JOIN `blog_blogs` ON (`blog_blogs`.`id` = `blog_posts`.`blog_id`) WHERE `blog_blogs`.`group_id` IS null AND `blog_posts`.`created_at` BETWEEN 1398927600 AND 1401606000 ORDER BY `blog_posts`.`created_at` DESCConnection name: default Speed: 1.461 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) · 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/views/blog/archive.php, line 193File: 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 `blog_posts`.*, COUNT(`blog_id`) AS `monthCount` FROM `blog_posts` JOIN `blog_blogs` ON (`blog_blogs`.`id` = `blog_posts`.`blog_id`) WHERE `blog_blogs`.`group_id` IS null AND `blog_posts`.`created_at` BETWEEN 1401606000 AND 1404198000 ORDER BY `blog_posts`.`created_at` DESCConnection name: default Speed: 1.620 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) · 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/views/blog/archive.php, line 193File: 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 `blog_posts`.*, COUNT(`blog_id`) AS `monthCount` FROM `blog_posts` JOIN `blog_blogs` ON (`blog_blogs`.`id` = `blog_posts`.`blog_id`) WHERE `blog_blogs`.`group_id` IS null AND `blog_posts`.`created_at` BETWEEN 1404198000 AND 1406876400 ORDER BY `blog_posts`.`created_at` DESCConnection name: default Speed: 1.476 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) · 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/views/blog/archive.php, line 193File: 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 `blog_posts`.*, COUNT(`blog_id`) AS `monthCount` FROM `blog_posts` JOIN `blog_blogs` ON (`blog_blogs`.`id` = `blog_posts`.`blog_id`) WHERE `blog_blogs`.`group_id` IS null AND `blog_posts`.`created_at` BETWEEN 1406876400 AND 1409554800 ORDER BY `blog_posts`.`created_at` DESCConnection name: default Speed: 1.517 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) · 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/views/blog/archive.php, line 193File: 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 `blog_posts`.*, COUNT(`blog_id`) AS `monthCount` FROM `blog_posts` JOIN `blog_blogs` ON (`blog_blogs`.`id` = `blog_posts`.`blog_id`) WHERE `blog_blogs`.`group_id` IS null AND `blog_posts`.`created_at` BETWEEN 1409554800 AND 1412146800 ORDER BY `blog_posts`.`created_at` DESCConnection name: default Speed: 1.423 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) · 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/views/blog/archive.php, line 193File: 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 `blog_posts`.*, COUNT(`blog_id`) AS `monthCount` FROM `blog_posts` JOIN `blog_blogs` ON (`blog_blogs`.`id` = `blog_posts`.`blog_id`) WHERE `blog_blogs`.`group_id` IS null AND `blog_posts`.`created_at` BETWEEN 1412146800 AND 1414825200 ORDER BY `blog_posts`.`created_at` DESCConnection name: default Speed: 1.421 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) · 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/views/blog/archive.php, line 193File: 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 `blog_posts`.*, COUNT(`blog_id`) AS `monthCount` FROM `blog_posts` JOIN `blog_blogs` ON (`blog_blogs`.`id` = `blog_posts`.`blog_id`) WHERE `blog_blogs`.`group_id` IS null AND `blog_posts`.`created_at` BETWEEN 1414825200 AND 1417420800 ORDER BY `blog_posts`.`created_at` DESCConnection name: default Speed: 1.468 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) · 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/views/blog/archive.php, line 193File: 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 `blog_posts`.*, COUNT(`blog_id`) AS `monthCount` FROM `blog_posts` JOIN `blog_blogs` ON (`blog_blogs`.`id` = `blog_posts`.`blog_id`) WHERE `blog_blogs`.`group_id` IS null AND `blog_posts`.`created_at` BETWEEN 1417420800 AND 1420099200 ORDER BY `blog_posts`.`created_at` DESCConnection name: default Speed: 1.423 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) · 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/views/blog/archive.php, line 193File: 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 `blog_posts`.*, COUNT(`blog_id`) AS `monthCount` FROM `blog_posts` JOIN `blog_blogs` ON (`blog_blogs`.`id` = `blog_posts`.`blog_id`) WHERE `blog_blogs`.`group_id` IS null AND `blog_posts`.`created_at` BETWEEN 1420099200 AND 1422777600 ORDER BY `blog_posts`.`created_at` DESCConnection name: default Speed: 1.447 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) · 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/views/blog/archive.php, line 193File: 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 `blog_posts`.*, COUNT(`blog_id`) AS `monthCount` FROM `blog_posts` JOIN `blog_blogs` ON (`blog_blogs`.`id` = `blog_posts`.`blog_id`) WHERE `blog_blogs`.`group_id` IS null AND `blog_posts`.`created_at` BETWEEN 1422777600 AND 1425196800 ORDER BY `blog_posts`.`created_at` DESCConnection name: default Speed: 1.457 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) · 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/views/blog/archive.php, line 193File: 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 `blog_posts`.*, COUNT(`blog_id`) AS `monthCount` FROM `blog_posts` JOIN `blog_blogs` ON (`blog_blogs`.`id` = `blog_posts`.`blog_id`) WHERE `blog_blogs`.`group_id` IS null AND `blog_posts`.`created_at` BETWEEN 1425196800 AND 1427871600 ORDER BY `blog_posts`.`created_at` DESCConnection name: default Speed: 1.410 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) · 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/views/blog/archive.php, line 193File: 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 `blog_posts`.*, COUNT(`blog_id`) AS `monthCount` FROM `blog_posts` JOIN `blog_blogs` ON (`blog_blogs`.`id` = `blog_posts`.`blog_id`) WHERE `blog_blogs`.`group_id` IS null AND `blog_posts`.`created_at` BETWEEN 1427871600 AND 1430463600 ORDER BY `blog_posts`.`created_at` DESCConnection name: default Speed: 1.471 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) · 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/views/blog/archive.php, line 193File: 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 `blog_posts`.*, COUNT(`blog_id`) AS `monthCount` FROM `blog_posts` JOIN `blog_blogs` ON (`blog_blogs`.`id` = `blog_posts`.`blog_id`) WHERE `blog_blogs`.`group_id` IS null AND `blog_posts`.`created_at` BETWEEN 1430463600 AND 1433142000 ORDER BY `blog_posts`.`created_at` DESCConnection name: default Speed: 1.431 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) · 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/views/blog/archive.php, line 193File: 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 `blog_posts`.*, COUNT(`blog_id`) AS `monthCount` FROM `blog_posts` JOIN `blog_blogs` ON (`blog_blogs`.`id` = `blog_posts`.`blog_id`) WHERE `blog_blogs`.`group_id` IS null AND `blog_posts`.`created_at` BETWEEN 1433142000 AND 1435734000 ORDER BY `blog_posts`.`created_at` DESCConnection name: default Speed: 1.412 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) · 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/views/blog/archive.php, line 193File: 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 `blog_posts`.*, COUNT(`blog_id`) AS `monthCount` FROM `blog_posts` JOIN `blog_blogs` ON (`blog_blogs`.`id` = `blog_posts`.`blog_id`) WHERE `blog_blogs`.`group_id` IS null AND `blog_posts`.`created_at` BETWEEN 1435734000 AND 1438412400 ORDER BY `blog_posts`.`created_at` DESCConnection name: default Speed: 1.447 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) · 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/views/blog/archive.php, line 193File: 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 `blog_posts`.*, COUNT(`blog_id`) AS `monthCount` FROM `blog_posts` JOIN `blog_blogs` ON (`blog_blogs`.`id` = `blog_posts`.`blog_id`) WHERE `blog_blogs`.`group_id` IS null AND `blog_posts`.`created_at` BETWEEN 1438412400 AND 1441090800 ORDER BY `blog_posts`.`created_at` DESCConnection name: default Speed: 1.416 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) · 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/views/blog/archive.php, line 193File: 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 `blog_posts`.*, COUNT(`blog_id`) AS `monthCount` FROM `blog_posts` JOIN `blog_blogs` ON (`blog_blogs`.`id` = `blog_posts`.`blog_id`) WHERE `blog_blogs`.`group_id` IS null AND `blog_posts`.`created_at` BETWEEN 1441090800 AND 1443682800 ORDER BY `blog_posts`.`created_at` DESCConnection name: default Speed: 1.507 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) · 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/views/blog/archive.php, line 193File: 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 `blog_posts`.*, COUNT(`blog_id`) AS `monthCount` FROM `blog_posts` JOIN `blog_blogs` ON (`blog_blogs`.`id` = `blog_posts`.`blog_id`) WHERE `blog_blogs`.`group_id` IS null AND `blog_posts`.`created_at` BETWEEN 1443682800 AND 1446361200 ORDER BY `blog_posts`.`created_at` DESCConnection name: default Speed: 1.408 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) · 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/views/blog/archive.php, line 193File: 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 `blog_posts`.*, COUNT(`blog_id`) AS `monthCount` FROM `blog_posts` JOIN `blog_blogs` ON (`blog_blogs`.`id` = `blog_posts`.`blog_id`) WHERE `blog_blogs`.`group_id` IS null AND `blog_posts`.`created_at` BETWEEN 1446361200 AND 1448956800 ORDER BY `blog_posts`.`created_at` DESCConnection name: default Speed: 1.417 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) · 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/views/blog/archive.php, line 193File: 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 `blog_posts`.*, COUNT(`blog_id`) AS `monthCount` FROM `blog_posts` JOIN `blog_blogs` ON (`blog_blogs`.`id` = `blog_posts`.`blog_id`) WHERE `blog_blogs`.`group_id` IS null AND `blog_posts`.`created_at` BETWEEN 1448956800 AND 1451635200 ORDER BY `blog_posts`.`created_at` DESCConnection name: default Speed: 1.437 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) · 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/views/blog/archive.php, line 193File: 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 `blog_posts`.*, COUNT(`blog_id`) AS `monthCount` FROM `blog_posts` JOIN `blog_blogs` ON (`blog_blogs`.`id` = `blog_posts`.`blog_id`) WHERE `blog_blogs`.`group_id` IS null AND `blog_posts`.`created_at` BETWEEN 1451635200 AND 1454313600 ORDER BY `blog_posts`.`created_at` DESCConnection name: default Speed: 1.402 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) · 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/views/blog/archive.php, line 193File: 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 `blog_posts`.*, COUNT(`blog_id`) AS `monthCount` FROM `blog_posts` JOIN `blog_blogs` ON (`blog_blogs`.`id` = `blog_posts`.`blog_id`) WHERE `blog_blogs`.`group_id` IS null AND `blog_posts`.`created_at` BETWEEN 1454313600 AND 1456819200 ORDER BY `blog_posts`.`created_at` DESCConnection name: default Speed: 1.468 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) · 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/views/blog/archive.php, line 193File: 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 `blog_posts`.*, COUNT(`blog_id`) AS `monthCount` FROM `blog_posts` JOIN `blog_blogs` ON (`blog_blogs`.`id` = `blog_posts`.`blog_id`) WHERE `blog_blogs`.`group_id` IS null AND `blog_posts`.`created_at` BETWEEN 1456819200 AND 1459494000 ORDER BY `blog_posts`.`created_at` DESCConnection name: default Speed: 1.473 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) · 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/views/blog/archive.php, line 193File: 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 `blog_posts`.*, COUNT(`blog_id`) AS `monthCount` FROM `blog_posts` JOIN `blog_blogs` ON (`blog_blogs`.`id` = `blog_posts`.`blog_id`) WHERE `blog_blogs`.`group_id` IS null AND `blog_posts`.`created_at` BETWEEN 1459494000 AND 1462086000 ORDER BY `blog_posts`.`created_at` DESCConnection name: default Speed: 1.419 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) · 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/views/blog/archive.php, line 193File: 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 `blog_posts`.*, COUNT(`blog_id`) AS `monthCount` FROM `blog_posts` JOIN `blog_blogs` ON (`blog_blogs`.`id` = `blog_posts`.`blog_id`) WHERE `blog_blogs`.`group_id` IS null AND `blog_posts`.`created_at` BETWEEN 1462086000 AND 1464764400 ORDER BY `blog_posts`.`created_at` DESCConnection name: default Speed: 1.435 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) · 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/views/blog/archive.php, line 193File: 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 `blog_posts`.*, COUNT(`blog_id`) AS `monthCount` FROM `blog_posts` JOIN `blog_blogs` ON (`blog_blogs`.`id` = `blog_posts`.`blog_id`) WHERE `blog_blogs`.`group_id` IS null AND `blog_posts`.`created_at` BETWEEN 1464764400 AND 1467356400 ORDER BY `blog_posts`.`created_at` DESCConnection name: default Speed: 1.425 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) · 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/views/blog/archive.php, line 193File: 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 `blog_posts`.*, COUNT(`blog_id`) AS `monthCount` FROM `blog_posts` JOIN `blog_blogs` ON (`blog_blogs`.`id` = `blog_posts`.`blog_id`) WHERE `blog_blogs`.`group_id` IS null AND `blog_posts`.`created_at` BETWEEN 1467356400 AND 1470034800 ORDER BY `blog_posts`.`created_at` DESCConnection name: default Speed: 1.460 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) · 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/views/blog/archive.php, line 193File: 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 `blog_posts`.*, COUNT(`blog_id`) AS `monthCount` FROM `blog_posts` JOIN `blog_blogs` ON (`blog_blogs`.`id` = `blog_posts`.`blog_id`) WHERE `blog_blogs`.`group_id` IS null AND `blog_posts`.`created_at` BETWEEN 1470034800 AND 1472713200 ORDER BY `blog_posts`.`created_at` DESCConnection name: default Speed: 1.649 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) · 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/views/blog/archive.php, line 193File: 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 `blog_posts`.*, COUNT(`blog_id`) AS `monthCount` FROM `blog_posts` JOIN `blog_blogs` ON (`blog_blogs`.`id` = `blog_posts`.`blog_id`) WHERE `blog_blogs`.`group_id` IS null AND `blog_posts`.`created_at` BETWEEN 1472713200 AND 1475305200 ORDER BY `blog_posts`.`created_at` DESCConnection name: default Speed: 1.417 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) · 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/views/blog/archive.php, line 193File: 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 `blog_posts`.*, COUNT(`blog_id`) AS `monthCount` FROM `blog_posts` JOIN `blog_blogs` ON (`blog_blogs`.`id` = `blog_posts`.`blog_id`) WHERE `blog_blogs`.`group_id` IS null AND `blog_posts`.`created_at` BETWEEN 1475305200 AND 1477983600 ORDER BY `blog_posts`.`created_at` DESCConnection name: default Speed: 1.481 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) · 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/views/blog/archive.php, line 193File: 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 `blog_posts`.*, COUNT(`blog_id`) AS `monthCount` FROM `blog_posts` JOIN `blog_blogs` ON (`blog_blogs`.`id` = `blog_posts`.`blog_id`) WHERE `blog_blogs`.`group_id` IS null AND `blog_posts`.`created_at` BETWEEN 1477983600 AND 1480579200 ORDER BY `blog_posts`.`created_at` DESCConnection name: default Speed: 1.416 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) · 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/views/blog/archive.php, line 193File: 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 `blog_posts`.*, COUNT(`blog_id`) AS `monthCount` FROM `blog_posts` JOIN `blog_blogs` ON (`blog_blogs`.`id` = `blog_posts`.`blog_id`) WHERE `blog_blogs`.`group_id` IS null AND `blog_posts`.`created_at` BETWEEN 1480579200 AND 1483257600 ORDER BY `blog_posts`.`created_at` DESCConnection name: default Speed: 1.462 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) · 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/views/blog/archive.php, line 193File: 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 `blog_posts`.*, COUNT(`blog_id`) AS `monthCount` FROM `blog_posts` JOIN `blog_blogs` ON (`blog_blogs`.`id` = `blog_posts`.`blog_id`) WHERE `blog_blogs`.`group_id` IS null AND `blog_posts`.`created_at` BETWEEN 1483257600 AND 1485936000 ORDER BY `blog_posts`.`created_at` DESCConnection name: default Speed: 1.451 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) · 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/views/blog/archive.php, line 193File: 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 `blog_posts`.*, COUNT(`blog_id`) AS `monthCount` FROM `blog_posts` JOIN `blog_blogs` ON (`blog_blogs`.`id` = `blog_posts`.`blog_id`) WHERE `blog_blogs`.`group_id` IS null AND `blog_posts`.`created_at` BETWEEN 1485936000 AND 1488355200 ORDER BY `blog_posts`.`created_at` DESCConnection name: default Speed: 1.436 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) · 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/views/blog/archive.php, line 193File: 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 `blog_posts`.*, COUNT(`blog_id`) AS `monthCount` FROM `blog_posts` JOIN `blog_blogs` ON (`blog_blogs`.`id` = `blog_posts`.`blog_id`) WHERE `blog_blogs`.`group_id` IS null AND `blog_posts`.`created_at` BETWEEN 1488355200 AND 1491030000 ORDER BY `blog_posts`.`created_at` DESCConnection name: default Speed: 1.450 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) · 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/views/blog/archive.php, line 193File: 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 `blog_posts`.*, COUNT(`blog_id`) AS `monthCount` FROM `blog_posts` JOIN `blog_blogs` ON (`blog_blogs`.`id` = `blog_posts`.`blog_id`) WHERE `blog_blogs`.`group_id` IS null AND `blog_posts`.`created_at` BETWEEN 1491030000 AND 1493622000 ORDER BY `blog_posts`.`created_at` DESCConnection name: default Speed: 1.462 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) · 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/views/blog/archive.php, line 193File: 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 `blog_posts`.*, COUNT(`blog_id`) AS `monthCount` FROM `blog_posts` JOIN `blog_blogs` ON (`blog_blogs`.`id` = `blog_posts`.`blog_id`) WHERE `blog_blogs`.`group_id` IS null AND `blog_posts`.`created_at` BETWEEN 1493622000 AND 1496300400 ORDER BY `blog_posts`.`created_at` DESCConnection name: default Speed: 1.590 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) · 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/views/blog/archive.php, line 193File: 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 `blog_posts`.*, COUNT(`blog_id`) AS `monthCount` FROM `blog_posts` JOIN `blog_blogs` ON (`blog_blogs`.`id` = `blog_posts`.`blog_id`) WHERE `blog_blogs`.`group_id` IS null AND `blog_posts`.`created_at` BETWEEN 1496300400 AND 1498892400 ORDER BY `blog_posts`.`created_at` DESCConnection name: default Speed: 1.436 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) · 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/views/blog/archive.php, line 193File: 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 `blog_posts`.*, COUNT(`blog_id`) AS `monthCount` FROM `blog_posts` JOIN `blog_blogs` ON (`blog_blogs`.`id` = `blog_posts`.`blog_id`) WHERE `blog_blogs`.`group_id` IS null AND `blog_posts`.`created_at` BETWEEN 1498892400 AND 1501570800 ORDER BY `blog_posts`.`created_at` DESCConnection name: default Speed: 1.410 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) · 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/views/blog/archive.php, line 193File: 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 `blog_posts`.*, COUNT(`blog_id`) AS `monthCount` FROM `blog_posts` JOIN `blog_blogs` ON (`blog_blogs`.`id` = `blog_posts`.`blog_id`) WHERE `blog_blogs`.`group_id` IS null AND `blog_posts`.`created_at` BETWEEN 1501570800 AND 1504249200 ORDER BY `blog_posts`.`created_at` DESCConnection name: default Speed: 1.438 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) · 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/views/blog/archive.php, line 193File: 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 `blog_posts`.*, COUNT(`blog_id`) AS `monthCount` FROM `blog_posts` JOIN `blog_blogs` ON (`blog_blogs`.`id` = `blog_posts`.`blog_id`) WHERE `blog_blogs`.`group_id` IS null AND `blog_posts`.`created_at` BETWEEN 1504249200 AND 1506841200 ORDER BY `blog_posts`.`created_at` DESCConnection name: default Speed: 1.428 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) · 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/views/blog/archive.php, line 193File: 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 `blog_posts`.*, COUNT(`blog_id`) AS `monthCount` FROM `blog_posts` JOIN `blog_blogs` ON (`blog_blogs`.`id` = `blog_posts`.`blog_id`) WHERE `blog_blogs`.`group_id` IS null AND `blog_posts`.`created_at` BETWEEN 1506841200 AND 1509519600 ORDER BY `blog_posts`.`created_at` DESCConnection name: default Speed: 1.540 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) · 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/views/blog/archive.php, line 193File: 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 `blog_posts`.*, COUNT(`blog_id`) AS `monthCount` FROM `blog_posts` JOIN `blog_blogs` ON (`blog_blogs`.`id` = `blog_posts`.`blog_id`) WHERE `blog_blogs`.`group_id` IS null AND `blog_posts`.`created_at` BETWEEN 1509519600 AND 1512115200 ORDER BY `blog_posts`.`created_at` DESCConnection name: default Speed: 1.418 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) · 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/views/blog/archive.php, line 193File: 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 `blog_posts`.*, COUNT(`blog_id`) AS `monthCount` FROM `blog_posts` JOIN `blog_blogs` ON (`blog_blogs`.`id` = `blog_posts`.`blog_id`) WHERE `blog_blogs`.`group_id` IS null AND `blog_posts`.`created_at` BETWEEN 1512115200 AND 1514793600 ORDER BY `blog_posts`.`created_at` DESCConnection name: default Speed: 1.419 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) · 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/views/blog/archive.php, line 193File: 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 `blog_posts`.*, COUNT(`blog_id`) AS `monthCount` FROM `blog_posts` JOIN `blog_blogs` ON (`blog_blogs`.`id` = `blog_posts`.`blog_id`) WHERE `blog_blogs`.`group_id` IS null AND `blog_posts`.`created_at` BETWEEN 1514793600 AND 1517472000 ORDER BY `blog_posts`.`created_at` DESCConnection name: default Speed: 1.450 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) · 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/views/blog/archive.php, line 193File: 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 `blog_posts`.*, COUNT(`blog_id`) AS `monthCount` FROM `blog_posts` JOIN `blog_blogs` ON (`blog_blogs`.`id` = `blog_posts`.`blog_id`) WHERE `blog_blogs`.`group_id` IS null AND `blog_posts`.`created_at` BETWEEN 1517472000 AND 1519891200 ORDER BY `blog_posts`.`created_at` DESCConnection name: default Speed: 1.426 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) · 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/views/blog/archive.php, line 193File: 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 `blog_posts`.*, COUNT(`blog_id`) AS `monthCount` FROM `blog_posts` JOIN `blog_blogs` ON (`blog_blogs`.`id` = `blog_posts`.`blog_id`) WHERE `blog_blogs`.`group_id` IS null AND `blog_posts`.`created_at` BETWEEN 1519891200 AND 1522566000 ORDER BY `blog_posts`.`created_at` DESCConnection name: default Speed: 1.469 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) · 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/views/blog/archive.php, line 193File: 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 `blog_posts`.*, COUNT(`blog_id`) AS `monthCount` FROM `blog_posts` JOIN `blog_blogs` ON (`blog_blogs`.`id` = `blog_posts`.`blog_id`) WHERE `blog_blogs`.`group_id` IS null AND `blog_posts`.`created_at` BETWEEN 1522566000 AND 1525158000 ORDER BY `blog_posts`.`created_at` DESCConnection name: default Speed: 1.419 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) · 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/views/blog/archive.php, line 193File: 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 `blog_posts`.*, COUNT(`blog_id`) AS `monthCount` FROM `blog_posts` JOIN `blog_blogs` ON (`blog_blogs`.`id` = `blog_posts`.`blog_id`) WHERE `blog_blogs`.`group_id` IS null AND `blog_posts`.`created_at` BETWEEN 1525158000 AND 1527836400 ORDER BY `blog_posts`.`created_at` DESCConnection name: default Speed: 1.460 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) · 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/views/blog/archive.php, line 193File: 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 `blog_posts`.*, COUNT(`blog_id`) AS `monthCount` FROM `blog_posts` JOIN `blog_blogs` ON (`blog_blogs`.`id` = `blog_posts`.`blog_id`) WHERE `blog_blogs`.`group_id` IS null AND `blog_posts`.`created_at` BETWEEN 1527836400 AND 1530428400 ORDER BY `blog_posts`.`created_at` DESCConnection name: default Speed: 1.444 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) · 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/views/blog/archive.php, line 193File: 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 `blog_posts`.*, COUNT(`blog_id`) AS `monthCount` FROM `blog_posts` JOIN `blog_blogs` ON (`blog_blogs`.`id` = `blog_posts`.`blog_id`) WHERE `blog_blogs`.`group_id` IS null AND `blog_posts`.`created_at` BETWEEN 1530428400 AND 1533106800 ORDER BY `blog_posts`.`created_at` DESCConnection name: default Speed: 1.424 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) · 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/views/blog/archive.php, line 193File: 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 `blog_posts`.*, COUNT(`blog_id`) AS `monthCount` FROM `blog_posts` JOIN `blog_blogs` ON (`blog_blogs`.`id` = `blog_posts`.`blog_id`) WHERE `blog_blogs`.`group_id` IS null AND `blog_posts`.`created_at` BETWEEN 1533106800 AND 1535785200 ORDER BY `blog_posts`.`created_at` DESCConnection name: default Speed: 1.506 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) · 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/views/blog/archive.php, line 193File: 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 `blog_posts`.*, COUNT(`blog_id`) AS `monthCount` FROM `blog_posts` JOIN `blog_blogs` ON (`blog_blogs`.`id` = `blog_posts`.`blog_id`) WHERE `blog_blogs`.`group_id` IS null AND `blog_posts`.`created_at` BETWEEN 1535785200 AND 1538377200 ORDER BY `blog_posts`.`created_at` DESCConnection name: default Speed: 1.406 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) · 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/views/blog/archive.php, line 193File: 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 `blog_posts`.*, COUNT(`blog_id`) AS `monthCount` FROM `blog_posts` JOIN `blog_blogs` ON (`blog_blogs`.`id` = `blog_posts`.`blog_id`) WHERE `blog_blogs`.`group_id` IS null AND `blog_posts`.`created_at` BETWEEN 1538377200 AND 1541055600 ORDER BY `blog_posts`.`created_at` DESCConnection name: default Speed: 1.409 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) · 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/views/blog/archive.php, line 193File: 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 `blog_posts`.*, COUNT(`blog_id`) AS `monthCount` FROM `blog_posts` JOIN `blog_blogs` ON (`blog_blogs`.`id` = `blog_posts`.`blog_id`) WHERE `blog_blogs`.`group_id` IS null AND `blog_posts`.`created_at` BETWEEN 1541055600 AND 1543651200 ORDER BY `blog_posts`.`created_at` DESCConnection name: default Speed: 1.499 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) · 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/views/blog/archive.php, line 193File: 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 `blog_posts`.*, COUNT(`blog_id`) AS `monthCount` FROM `blog_posts` JOIN `blog_blogs` ON (`blog_blogs`.`id` = `blog_posts`.`blog_id`) WHERE `blog_blogs`.`group_id` IS null AND `blog_posts`.`created_at` BETWEEN 1543651200 AND 1546329600 ORDER BY `blog_posts`.`created_at` DESCConnection name: default Speed: 1.402 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) · 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/views/blog/archive.php, line 193File: 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 `blog_posts`.*, COUNT(`blog_id`) AS `monthCount` FROM `blog_posts` JOIN `blog_blogs` ON (`blog_blogs`.`id` = `blog_posts`.`blog_id`) WHERE `blog_blogs`.`group_id` IS null AND `blog_posts`.`created_at` BETWEEN 1546329600 AND 1549008000 ORDER BY `blog_posts`.`created_at` DESCConnection name: default Speed: 1.421 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) · 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/views/blog/archive.php, line 193File: 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 `blog_posts`.*, COUNT(`blog_id`) AS `monthCount` FROM `blog_posts` JOIN `blog_blogs` ON (`blog_blogs`.`id` = `blog_posts`.`blog_id`) WHERE `blog_blogs`.`group_id` IS null AND `blog_posts`.`created_at` BETWEEN 1549008000 AND 1551427200 ORDER BY `blog_posts`.`created_at` DESCConnection name: default Speed: 1.415 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) · 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/views/blog/archive.php, line 193File: 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 `blog_posts`.*, COUNT(`blog_id`) AS `monthCount` FROM `blog_posts` JOIN `blog_blogs` ON (`blog_blogs`.`id` = `blog_posts`.`blog_id`) WHERE `blog_blogs`.`group_id` IS null AND `blog_posts`.`created_at` BETWEEN 1551427200 AND 1554102000 ORDER BY `blog_posts`.`created_at` DESCConnection name: default Speed: 1.402 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) · 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/views/blog/archive.php, line 193File: 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 `blog_posts`.*, COUNT(`blog_id`) AS `monthCount` FROM `blog_posts` JOIN `blog_blogs` ON (`blog_blogs`.`id` = `blog_posts`.`blog_id`) WHERE `blog_blogs`.`group_id` IS null AND `blog_posts`.`created_at` BETWEEN 1554102000 AND 1556694000 ORDER BY `blog_posts`.`created_at` DESCConnection name: default Speed: 1.449 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) · 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/views/blog/archive.php, line 193File: 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 `blog_posts`.*, COUNT(`blog_id`) AS `monthCount` FROM `blog_posts` JOIN `blog_blogs` ON (`blog_blogs`.`id` = `blog_posts`.`blog_id`) WHERE `blog_blogs`.`group_id` IS null AND `blog_posts`.`created_at` BETWEEN 1556694000 AND 1559372400 ORDER BY `blog_posts`.`created_at` DESCConnection name: default Speed: 1.407 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) · 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/views/blog/archive.php, line 193File: 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 `blog_posts`.*, COUNT(`blog_id`) AS `monthCount` FROM `blog_posts` JOIN `blog_blogs` ON (`blog_blogs`.`id` = `blog_posts`.`blog_id`) WHERE `blog_blogs`.`group_id` IS null AND `blog_posts`.`created_at` BETWEEN 1559372400 AND 1561964400 ORDER BY `blog_posts`.`created_at` DESCConnection name: default Speed: 1.439 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) · 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/views/blog/archive.php, line 193File: 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 `blog_posts`.*, COUNT(`blog_id`) AS `monthCount` FROM `blog_posts` JOIN `blog_blogs` ON (`blog_blogs`.`id` = `blog_posts`.`blog_id`) WHERE `blog_blogs`.`group_id` IS null AND `blog_posts`.`created_at` BETWEEN 1561964400 AND 1564642800 ORDER BY `blog_posts`.`created_at` DESCConnection name: default Speed: 1.485 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) · 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/views/blog/archive.php, line 193File: 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 `blog_posts`.*, COUNT(`blog_id`) AS `monthCount` FROM `blog_posts` JOIN `blog_blogs` ON (`blog_blogs`.`id` = `blog_posts`.`blog_id`) WHERE `blog_blogs`.`group_id` IS null AND `blog_posts`.`created_at` BETWEEN 1564642800 AND 1567321200 ORDER BY `blog_posts`.`created_at` DESCConnection name: default Speed: 1.428 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) · 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/views/blog/archive.php, line 193File: 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 `blog_posts`.*, COUNT(`blog_id`) AS `monthCount` FROM `blog_posts` JOIN `blog_blogs` ON (`blog_blogs`.`id` = `blog_posts`.`blog_id`) WHERE `blog_blogs`.`group_id` IS null AND `blog_posts`.`created_at` BETWEEN 1567321200 AND 1569913200 ORDER BY `blog_posts`.`created_at` DESCConnection name: default Speed: 1.490 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) · 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/views/blog/archive.php, line 193File: 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 `blog_posts`.*, COUNT(`blog_id`) AS `monthCount` FROM `blog_posts` JOIN `blog_blogs` ON (`blog_blogs`.`id` = `blog_posts`.`blog_id`) WHERE `blog_blogs`.`group_id` IS null AND `blog_posts`.`created_at` BETWEEN 1569913200 AND 1572591600 ORDER BY `blog_posts`.`created_at` DESCConnection name: default Speed: 1.408 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) · 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/views/blog/archive.php, line 193File: 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 `blog_posts`.*, COUNT(`blog_id`) AS `monthCount` FROM `blog_posts` JOIN `blog_blogs` ON (`blog_blogs`.`id` = `blog_posts`.`blog_id`) WHERE `blog_blogs`.`group_id` IS null AND `blog_posts`.`created_at` BETWEEN 1572591600 AND 1575187200 ORDER BY `blog_posts`.`created_at` DESCConnection name: default Speed: 1.457 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) · 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/views/blog/archive.php, line 193File: 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 `blog_posts`.*, COUNT(`blog_id`) AS `monthCount` FROM `blog_posts` JOIN `blog_blogs` ON (`blog_blogs`.`id` = `blog_posts`.`blog_id`) WHERE `blog_blogs`.`group_id` IS null AND `blog_posts`.`created_at` BETWEEN 1575187200 AND 1577865600 ORDER BY `blog_posts`.`created_at` DESCConnection name: default Speed: 1.494 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) · 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/views/blog/archive.php, line 193File: 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 `blog_posts`.*, COUNT(`blog_id`) AS `monthCount` FROM `blog_posts` JOIN `blog_blogs` ON (`blog_blogs`.`id` = `blog_posts`.`blog_id`) WHERE `blog_blogs`.`group_id` IS null AND `blog_posts`.`created_at` BETWEEN 1577865600 AND 1580544000 ORDER BY `blog_posts`.`created_at` DESCConnection name: default Speed: 1.411 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) · 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/views/blog/archive.php, line 193File: 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 `blog_posts`.*, COUNT(`blog_id`) AS `monthCount` FROM `blog_posts` JOIN `blog_blogs` ON (`blog_blogs`.`id` = `blog_posts`.`blog_id`) WHERE `blog_blogs`.`group_id` IS null AND `blog_posts`.`created_at` BETWEEN 1580544000 AND 1583049600 ORDER BY `blog_posts`.`created_at` DESCConnection name: default Speed: 1.462 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) · 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/views/blog/archive.php, line 193File: 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 `blog_posts`.*, COUNT(`blog_id`) AS `monthCount` FROM `blog_posts` JOIN `blog_blogs` ON (`blog_blogs`.`id` = `blog_posts`.`blog_id`) WHERE `blog_blogs`.`group_id` IS null AND `blog_posts`.`created_at` BETWEEN 1583049600 AND 1585724400 ORDER BY `blog_posts`.`created_at` DESCConnection name: default Speed: 1.401 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) · 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/views/blog/archive.php, line 193File: 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 `blog_posts`.*, COUNT(`blog_id`) AS `monthCount` FROM `blog_posts` JOIN `blog_blogs` ON (`blog_blogs`.`id` = `blog_posts`.`blog_id`) WHERE `blog_blogs`.`group_id` IS null AND `blog_posts`.`created_at` BETWEEN 1585724400 AND 1588316400 ORDER BY `blog_posts`.`created_at` DESCConnection name: default Speed: 1.444 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) · 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/views/blog/archive.php, line 193File: 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 `blog_posts`.*, COUNT(`blog_id`) AS `monthCount` FROM `blog_posts` JOIN `blog_blogs` ON (`blog_blogs`.`id` = `blog_posts`.`blog_id`) WHERE `blog_blogs`.`group_id` IS null AND `blog_posts`.`created_at` BETWEEN 1588316400 AND 1590994800 ORDER BY `blog_posts`.`created_at` DESCConnection name: default Speed: 1.483 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) · 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/views/blog/archive.php, line 193File: 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 `blog_posts`.*, COUNT(`blog_id`) AS `monthCount` FROM `blog_posts` JOIN `blog_blogs` ON (`blog_blogs`.`id` = `blog_posts`.`blog_id`) WHERE `blog_blogs`.`group_id` IS null AND `blog_posts`.`created_at` BETWEEN 1590994800 AND 1593586800 ORDER BY `blog_posts`.`created_at` DESCConnection name: default Speed: 1.792 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) · 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/views/blog/archive.php, line 193File: 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 `blog_posts`.*, COUNT(`blog_id`) AS `monthCount` FROM `blog_posts` JOIN `blog_blogs` ON (`blog_blogs`.`id` = `blog_posts`.`blog_id`) WHERE `blog_blogs`.`group_id` IS null AND `blog_posts`.`created_at` BETWEEN 1593586800 AND 1596265200 ORDER BY `blog_posts`.`created_at` DESCConnection name: default Speed: 2.441 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) · 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/views/blog/archive.php, line 193File: 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 `blog_posts`.*, COUNT(`blog_id`) AS `monthCount` FROM `blog_posts` JOIN `blog_blogs` ON (`blog_blogs`.`id` = `blog_posts`.`blog_id`) WHERE `blog_blogs`.`group_id` IS null AND `blog_posts`.`created_at` BETWEEN 1596265200 AND 1598943600 ORDER BY `blog_posts`.`created_at` DESCConnection name: default Speed: 1.710 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) · 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/views/blog/archive.php, line 193File: 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 `blog_posts`.*, COUNT(`blog_id`) AS `monthCount` FROM `blog_posts` JOIN `blog_blogs` ON (`blog_blogs`.`id` = `blog_posts`.`blog_id`) WHERE `blog_blogs`.`group_id` IS null AND `blog_posts`.`created_at` BETWEEN 1598943600 AND 1601535600 ORDER BY `blog_posts`.`created_at` DESCConnection name: default Speed: 1.460 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) · 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/views/blog/archive.php, line 193File: 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 `blog_posts`.*, COUNT(`blog_id`) AS `monthCount` FROM `blog_posts` JOIN `blog_blogs` ON (`blog_blogs`.`id` = `blog_posts`.`blog_id`) WHERE `blog_blogs`.`group_id` IS null AND `blog_posts`.`created_at` BETWEEN 1601535600 AND 1604214000 ORDER BY `blog_posts`.`created_at` DESCConnection name: default Speed: 1.674 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) · 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/views/blog/archive.php, line 193File: 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 `blog_posts`.*, COUNT(`blog_id`) AS `monthCount` FROM `blog_posts` JOIN `blog_blogs` ON (`blog_blogs`.`id` = `blog_posts`.`blog_id`) WHERE `blog_blogs`.`group_id` IS null AND `blog_posts`.`created_at` BETWEEN 1604214000 AND 1606809600 ORDER BY `blog_posts`.`created_at` DESCConnection name: default Speed: 1.513 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) · 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/views/blog/archive.php, line 193File: 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 `blog_posts`.*, COUNT(`blog_id`) AS `monthCount` FROM `blog_posts` JOIN `blog_blogs` ON (`blog_blogs`.`id` = `blog_posts`.`blog_id`) WHERE `blog_blogs`.`group_id` IS null AND `blog_posts`.`created_at` BETWEEN 1606809600 AND 1609488000 ORDER BY `blog_posts`.`created_at` DESCConnection name: default Speed: 1.493 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) · 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/views/blog/archive.php, line 193File: 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 `blog_posts`.*, COUNT(`blog_id`) AS `monthCount` FROM `blog_posts` JOIN `blog_blogs` ON (`blog_blogs`.`id` = `blog_posts`.`blog_id`) WHERE `blog_blogs`.`group_id` IS null AND `blog_posts`.`created_at` BETWEEN 1609488000 AND 1612166400 ORDER BY `blog_posts`.`created_at` DESCConnection name: default Speed: 1.446 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) · 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/views/blog/archive.php, line 193File: 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 `blog_posts`.*, COUNT(`blog_id`) AS `monthCount` FROM `blog_posts` JOIN `blog_blogs` ON (`blog_blogs`.`id` = `blog_posts`.`blog_id`) WHERE `blog_blogs`.`group_id` IS null AND `blog_posts`.`created_at` BETWEEN 1612166400 AND 1614585600 ORDER BY `blog_posts`.`created_at` DESCConnection name: default Speed: 1.469 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) · 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/views/blog/archive.php, line 193File: 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 `blog_posts`.*, COUNT(`blog_id`) AS `monthCount` FROM `blog_posts` JOIN `blog_blogs` ON (`blog_blogs`.`id` = `blog_posts`.`blog_id`) WHERE `blog_blogs`.`group_id` IS null AND `blog_posts`.`created_at` BETWEEN 1614585600 AND 1617260400 ORDER BY `blog_posts`.`created_at` DESCConnection name: default Speed: 1.533 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) · 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/views/blog/archive.php, line 193File: 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 `blog_posts`.*, COUNT(`blog_id`) AS `monthCount` FROM `blog_posts` JOIN `blog_blogs` ON (`blog_blogs`.`id` = `blog_posts`.`blog_id`) WHERE `blog_blogs`.`group_id` IS null AND `blog_posts`.`created_at` BETWEEN 1617260400 AND 1619852400 ORDER BY `blog_posts`.`created_at` DESCConnection name: default Speed: 1.493 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) · 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/views/blog/archive.php, line 193File: 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 `blog_posts`.*, COUNT(`blog_id`) AS `monthCount` FROM `blog_posts` JOIN `blog_blogs` ON (`blog_blogs`.`id` = `blog_posts`.`blog_id`) WHERE `blog_blogs`.`group_id` IS null AND `blog_posts`.`created_at` BETWEEN 1619852400 AND 1622530800 ORDER BY `blog_posts`.`created_at` DESCConnection name: default Speed: 1.538 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) · 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/views/blog/archive.php, line 193File: 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 `blog_posts`.*, COUNT(`blog_id`) AS `monthCount` FROM `blog_posts` JOIN `blog_blogs` ON (`blog_blogs`.`id` = `blog_posts`.`blog_id`) WHERE `blog_blogs`.`group_id` IS null AND `blog_posts`.`created_at` BETWEEN 1622530800 AND 1625122800 ORDER BY `blog_posts`.`created_at` DESCConnection name: default Speed: 1.928 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) · 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/views/blog/archive.php, line 193File: 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 `blog_posts`.*, COUNT(`blog_id`) AS `monthCount` FROM `blog_posts` JOIN `blog_blogs` ON (`blog_blogs`.`id` = `blog_posts`.`blog_id`) WHERE `blog_blogs`.`group_id` IS null AND `blog_posts`.`created_at` BETWEEN 1625122800 AND 1627801200 ORDER BY `blog_posts`.`created_at` DESCConnection name: default Speed: 1.496 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) · 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/views/blog/archive.php, line 193File: 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 `blog_posts`.*, COUNT(`blog_id`) AS `monthCount` FROM `blog_posts` JOIN `blog_blogs` ON (`blog_blogs`.`id` = `blog_posts`.`blog_id`) WHERE `blog_blogs`.`group_id` IS null AND `blog_posts`.`created_at` BETWEEN 1627801200 AND 1630479600 ORDER BY `blog_posts`.`created_at` DESCConnection name: default Speed: 1.440 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) · 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/views/blog/archive.php, line 193File: 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 `blog_posts`.*, COUNT(`blog_id`) AS `monthCount` FROM `blog_posts` JOIN `blog_blogs` ON (`blog_blogs`.`id` = `blog_posts`.`blog_id`) WHERE `blog_blogs`.`group_id` IS null AND `blog_posts`.`created_at` BETWEEN 1630479600 AND 1633071600 ORDER BY `blog_posts`.`created_at` DESCConnection name: default Speed: 1.550 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) · 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/views/blog/archive.php, line 193File: 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 `blog_posts`.*, COUNT(`blog_id`) AS `monthCount` FROM `blog_posts` JOIN `blog_blogs` ON (`blog_blogs`.`id` = `blog_posts`.`blog_id`) WHERE `blog_blogs`.`group_id` IS null AND `blog_posts`.`created_at` BETWEEN 1633071600 AND 1635750000 ORDER BY `blog_posts`.`created_at` DESCConnection name: default Speed: 1.444 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) · 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/views/blog/archive.php, line 193File: 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 `blog_posts`.*, COUNT(`blog_id`) AS `monthCount` FROM `blog_posts` JOIN `blog_blogs` ON (`blog_blogs`.`id` = `blog_posts`.`blog_id`) WHERE `blog_blogs`.`group_id` IS null AND `blog_posts`.`created_at` BETWEEN 1635750000 AND 1638345600 ORDER BY `blog_posts`.`created_at` DESCConnection name: default Speed: 1.686 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) · 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/views/blog/archive.php, line 193File: 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 `blog_posts`.*, COUNT(`blog_id`) AS `monthCount` FROM `blog_posts` JOIN `blog_blogs` ON (`blog_blogs`.`id` = `blog_posts`.`blog_id`) WHERE `blog_blogs`.`group_id` IS null AND `blog_posts`.`created_at` BETWEEN 1638345600 AND 1641024000 ORDER BY `blog_posts`.`created_at` DESCConnection name: default Speed: 1.692 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) · 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/views/blog/archive.php, line 193File: 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 `blog_posts`.*, COUNT(`blog_id`) AS `monthCount` FROM `blog_posts` JOIN `blog_blogs` ON (`blog_blogs`.`id` = `blog_posts`.`blog_id`) WHERE `blog_blogs`.`group_id` IS null AND `blog_posts`.`created_at` BETWEEN 1641024000 AND 1643702400 ORDER BY `blog_posts`.`created_at` DESCConnection name: default Speed: 1.477 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) · 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/views/blog/archive.php, line 193File: 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 `blog_posts`.*, COUNT(`blog_id`) AS `monthCount` FROM `blog_posts` JOIN `blog_blogs` ON (`blog_blogs`.`id` = `blog_posts`.`blog_id`) WHERE `blog_blogs`.`group_id` IS null AND `blog_posts`.`created_at` BETWEEN 1643702400 AND 1646121600 ORDER BY `blog_posts`.`created_at` DESCConnection name: default Speed: 1.437 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) · 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/views/blog/archive.php, line 193File: 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 `blog_posts`.*, COUNT(`blog_id`) AS `monthCount` FROM `blog_posts` JOIN `blog_blogs` ON (`blog_blogs`.`id` = `blog_posts`.`blog_id`) WHERE `blog_blogs`.`group_id` IS null AND `blog_posts`.`created_at` BETWEEN 1646121600 AND 1648796400 ORDER BY `blog_posts`.`created_at` DESCConnection name: default Speed: 1.431 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) · 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/views/blog/archive.php, line 193File: 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 `blog_posts`.*, COUNT(`blog_id`) AS `monthCount` FROM `blog_posts` JOIN `blog_blogs` ON (`blog_blogs`.`id` = `blog_posts`.`blog_id`) WHERE `blog_blogs`.`group_id` IS null AND `blog_posts`.`created_at` BETWEEN 1648796400 AND 1651388400 ORDER BY `blog_posts`.`created_at` DESCConnection name: default Speed: 1.489 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) · 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/views/blog/archive.php, line 193File: 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 `blog_posts`.*, COUNT(`blog_id`) AS `monthCount` FROM `blog_posts` JOIN `blog_blogs` ON (`blog_blogs`.`id` = `blog_posts`.`blog_id`) WHERE `blog_blogs`.`group_id` IS null AND `blog_posts`.`created_at` BETWEEN 1651388400 AND 1654066800 ORDER BY `blog_posts`.`created_at` DESCConnection name: default Speed: 1.438 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) · 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/views/blog/archive.php, line 193File: 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 `blog_posts`.*, COUNT(`blog_id`) AS `monthCount` FROM `blog_posts` JOIN `blog_blogs` ON (`blog_blogs`.`id` = `blog_posts`.`blog_id`) WHERE `blog_blogs`.`group_id` IS null AND `blog_posts`.`created_at` BETWEEN 1654066800 AND 1656658800 ORDER BY `blog_posts`.`created_at` DESCConnection name: default Speed: 1.666 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) · 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/views/blog/archive.php, line 193File: 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 `blog_posts`.*, COUNT(`blog_id`) AS `monthCount` FROM `blog_posts` JOIN `blog_blogs` ON (`blog_blogs`.`id` = `blog_posts`.`blog_id`) WHERE `blog_blogs`.`group_id` IS null AND `blog_posts`.`created_at` BETWEEN 1656658800 AND 1659337200 ORDER BY `blog_posts`.`created_at` DESCConnection name: default Speed: 1.569 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) · 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/views/blog/archive.php, line 193File: 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 `blog_posts`.*, COUNT(`blog_id`) AS `monthCount` FROM `blog_posts` JOIN `blog_blogs` ON (`blog_blogs`.`id` = `blog_posts`.`blog_id`) WHERE `blog_blogs`.`group_id` IS null AND `blog_posts`.`created_at` BETWEEN 1659337200 AND 1662015600 ORDER BY `blog_posts`.`created_at` DESCConnection name: default Speed: 1.431 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) · 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/views/blog/archive.php, line 193File: 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 `blog_posts`.*, COUNT(`blog_id`) AS `monthCount` FROM `blog_posts` JOIN `blog_blogs` ON (`blog_blogs`.`id` = `blog_posts`.`blog_id`) WHERE `blog_blogs`.`group_id` IS null AND `blog_posts`.`created_at` BETWEEN 1662015600 AND 1664607600 ORDER BY `blog_posts`.`created_at` DESCConnection name: default Speed: 1.495 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) · 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/views/blog/archive.php, line 193File: 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 `blog_posts`.*, COUNT(`blog_id`) AS `monthCount` FROM `blog_posts` JOIN `blog_blogs` ON (`blog_blogs`.`id` = `blog_posts`.`blog_id`) WHERE `blog_blogs`.`group_id` IS null AND `blog_posts`.`created_at` BETWEEN 1664607600 AND 1667286000 ORDER BY `blog_posts`.`created_at` DESCConnection name: default Speed: 1.516 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) · 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/views/blog/archive.php, line 193File: 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 `blog_posts`.*, COUNT(`blog_id`) AS `monthCount` FROM `blog_posts` JOIN `blog_blogs` ON (`blog_blogs`.`id` = `blog_posts`.`blog_id`) WHERE `blog_blogs`.`group_id` IS null AND `blog_posts`.`created_at` BETWEEN 1667286000 AND 1669881600 ORDER BY `blog_posts`.`created_at` DESCConnection name: default Speed: 1.459 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) · 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/views/blog/archive.php, line 193File: 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 `blog_posts`.*, COUNT(`blog_id`) AS `monthCount` FROM `blog_posts` JOIN `blog_blogs` ON (`blog_blogs`.`id` = `blog_posts`.`blog_id`) WHERE `blog_blogs`.`group_id` IS null AND `blog_posts`.`created_at` BETWEEN 1669881600 AND 1672560000 ORDER BY `blog_posts`.`created_at` DESCConnection name: default Speed: 1.477 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) · 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/views/blog/archive.php, line 193File: 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 `blog_posts`.*, COUNT(`blog_id`) AS `monthCount` FROM `blog_posts` JOIN `blog_blogs` ON (`blog_blogs`.`id` = `blog_posts`.`blog_id`) WHERE `blog_blogs`.`group_id` IS null AND `blog_posts`.`created_at` BETWEEN 1672560000 AND 1675238400 ORDER BY `blog_posts`.`created_at` DESCConnection name: default Speed: 1.437 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) · 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/views/blog/archive.php, line 193File: 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 `blog_posts`.*, COUNT(`blog_id`) AS `monthCount` FROM `blog_posts` JOIN `blog_blogs` ON (`blog_blogs`.`id` = `blog_posts`.`blog_id`) WHERE `blog_blogs`.`group_id` IS null AND `blog_posts`.`created_at` BETWEEN 1675238400 AND 1677657600 ORDER BY `blog_posts`.`created_at` DESCConnection name: default Speed: 1.451 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) · 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/views/blog/archive.php, line 193File: 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 `blog_posts`.*, COUNT(`blog_id`) AS `monthCount` FROM `blog_posts` JOIN `blog_blogs` ON (`blog_blogs`.`id` = `blog_posts`.`blog_id`) WHERE `blog_blogs`.`group_id` IS null AND `blog_posts`.`created_at` BETWEEN 1677657600 AND 1680332400 ORDER BY `blog_posts`.`created_at` DESCConnection name: default Speed: 1.437 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) · 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/views/blog/archive.php, line 193File: 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 `blog_posts`.*, COUNT(`blog_id`) AS `monthCount` FROM `blog_posts` JOIN `blog_blogs` ON (`blog_blogs`.`id` = `blog_posts`.`blog_id`) WHERE `blog_blogs`.`group_id` IS null AND `blog_posts`.`created_at` BETWEEN 1680332400 AND 1682924400 ORDER BY `blog_posts`.`created_at` DESCConnection name: default Speed: 1.461 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) · 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/views/blog/archive.php, line 193File: 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 `blog_posts`.*, COUNT(`blog_id`) AS `monthCount` FROM `blog_posts` JOIN `blog_blogs` ON (`blog_blogs`.`id` = `blog_posts`.`blog_id`) WHERE `blog_blogs`.`group_id` IS null AND `blog_posts`.`created_at` BETWEEN 1682924400 AND 1685602800 ORDER BY `blog_posts`.`created_at` DESCConnection name: default Speed: 1.420 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) · 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/views/blog/archive.php, line 193File: 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 `blog_posts`.*, COUNT(`blog_id`) AS `monthCount` FROM `blog_posts` JOIN `blog_blogs` ON (`blog_blogs`.`id` = `blog_posts`.`blog_id`) WHERE `blog_blogs`.`group_id` IS null AND `blog_posts`.`created_at` BETWEEN 1685602800 AND 1688194800 ORDER BY `blog_posts`.`created_at` DESCConnection name: default Speed: 1.480 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) · 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/views/blog/archive.php, line 193File: 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 `blog_posts`.*, COUNT(`blog_id`) AS `monthCount` FROM `blog_posts` JOIN `blog_blogs` ON (`blog_blogs`.`id` = `blog_posts`.`blog_id`) WHERE `blog_blogs`.`group_id` IS null AND `blog_posts`.`created_at` BETWEEN 1688194800 AND 1690873200 ORDER BY `blog_posts`.`created_at` DESCConnection name: default Speed: 1.476 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) · 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/views/blog/archive.php, line 193File: 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 `blog_posts`.*, COUNT(`blog_id`) AS `monthCount` FROM `blog_posts` JOIN `blog_blogs` ON (`blog_blogs`.`id` = `blog_posts`.`blog_id`) WHERE `blog_blogs`.`group_id` IS null AND `blog_posts`.`created_at` BETWEEN 1690873200 AND 1693551600 ORDER BY `blog_posts`.`created_at` DESCConnection name: default Speed: 1.433 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) · 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/views/blog/archive.php, line 193File: 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 `blog_posts`.*, COUNT(`blog_id`) AS `monthCount` FROM `blog_posts` JOIN `blog_blogs` ON (`blog_blogs`.`id` = `blog_posts`.`blog_id`) WHERE `blog_blogs`.`group_id` IS null AND `blog_posts`.`created_at` BETWEEN 1693551600 AND 1696143600 ORDER BY `blog_posts`.`created_at` DESCConnection name: default Speed: 1.464 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) · 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/views/blog/archive.php, line 193File: 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 `blog_posts`.*, COUNT(`blog_id`) AS `monthCount` FROM `blog_posts` JOIN `blog_blogs` ON (`blog_blogs`.`id` = `blog_posts`.`blog_id`) WHERE `blog_blogs`.`group_id` IS null AND `blog_posts`.`created_at` BETWEEN 1696143600 AND 1698822000 ORDER BY `blog_posts`.`created_at` DESCConnection name: default Speed: 1.414 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) · 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/views/blog/archive.php, line 193File: 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 `blog_posts`.*, COUNT(`blog_id`) AS `monthCount` FROM `blog_posts` JOIN `blog_blogs` ON (`blog_blogs`.`id` = `blog_posts`.`blog_id`) WHERE `blog_blogs`.`group_id` IS null AND `blog_posts`.`created_at` BETWEEN 1698822000 AND 1701417600 ORDER BY `blog_posts`.`created_at` DESCConnection name: default Speed: 1.416 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) · 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/views/blog/archive.php, line 193File: 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 `blog_posts`.*, COUNT(`blog_id`) AS `monthCount` FROM `blog_posts` JOIN `blog_blogs` ON (`blog_blogs`.`id` = `blog_posts`.`blog_id`) WHERE `blog_blogs`.`group_id` IS null AND `blog_posts`.`created_at` BETWEEN 1701417600 AND 1704096000 ORDER BY `blog_posts`.`created_at` DESCConnection name: default Speed: 1.456 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) · 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/views/blog/archive.php, line 193File: 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 `blog_posts`.*, COUNT(`blog_id`) AS `monthCount` FROM `blog_posts` JOIN `blog_blogs` ON (`blog_blogs`.`id` = `blog_posts`.`blog_id`) WHERE `blog_blogs`.`group_id` IS null AND `blog_posts`.`created_at` BETWEEN 1704096000 AND 1706774400 ORDER BY `blog_posts`.`created_at` DESCConnection name: default Speed: 1.551 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) · 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/views/blog/archive.php, line 193File: 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 `blog_posts`.*, COUNT(`blog_id`) AS `monthCount` FROM `blog_posts` JOIN `blog_blogs` ON (`blog_blogs`.`id` = `blog_posts`.`blog_id`) WHERE `blog_blogs`.`group_id` IS null AND `blog_posts`.`created_at` BETWEEN 1706774400 AND 1709280000 ORDER BY `blog_posts`.`created_at` DESCConnection name: default Speed: 1.451 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) · 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/views/blog/archive.php, line 193File: 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 `blog_posts`.*, COUNT(`blog_id`) AS `monthCount` FROM `blog_posts` JOIN `blog_blogs` ON (`blog_blogs`.`id` = `blog_posts`.`blog_id`) WHERE `blog_blogs`.`group_id` IS null AND `blog_posts`.`created_at` BETWEEN 1709280000 AND 1711954800 ORDER BY `blog_posts`.`created_at` DESCConnection name: default Speed: 1.412 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) · 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/views/blog/archive.php, line 193File: 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 `blog_posts`.*, COUNT(`blog_id`) AS `monthCount` FROM `blog_posts` JOIN `blog_blogs` ON (`blog_blogs`.`id` = `blog_posts`.`blog_id`) WHERE `blog_blogs`.`group_id` IS null AND `blog_posts`.`created_at` BETWEEN 1711954800 AND 1714546800 ORDER BY `blog_posts`.`created_at` DESCConnection name: default Speed: 1.414 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) · 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/views/blog/archive.php, line 193File: 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 `blog_posts`.*, COUNT(`blog_id`) AS `monthCount` FROM `blog_posts` JOIN `blog_blogs` ON (`blog_blogs`.`id` = `blog_posts`.`blog_id`) WHERE `blog_blogs`.`group_id` IS null AND `blog_posts`.`created_at` BETWEEN 1714546800 AND 1717225200 ORDER BY `blog_posts`.`created_at` DESCConnection name: default Speed: 1.445 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) · 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/views/blog/archive.php, line 193File: 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 `blog_posts`.*, COUNT(`blog_id`) AS `monthCount` FROM `blog_posts` JOIN `blog_blogs` ON (`blog_blogs`.`id` = `blog_posts`.`blog_id`) WHERE `blog_blogs`.`group_id` IS null AND `blog_posts`.`created_at` BETWEEN 1717225200 AND 1719817200 ORDER BY `blog_posts`.`created_at` DESCConnection name: default Speed: 1.415 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) · 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/views/blog/archive.php, line 193File: 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 `blog_posts`.*, COUNT(`blog_id`) AS `monthCount` FROM `blog_posts` JOIN `blog_blogs` ON (`blog_blogs`.`id` = `blog_posts`.`blog_id`) WHERE `blog_blogs`.`group_id` IS null AND `blog_posts`.`created_at` BETWEEN 1719817200 AND 1722495600 ORDER BY `blog_posts`.`created_at` DESCConnection name: default Speed: 1.498 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) · 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/views/blog/archive.php, line 193File: 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 `blog_posts`.*, COUNT(`blog_id`) AS `monthCount` FROM `blog_posts` JOIN `blog_blogs` ON (`blog_blogs`.`id` = `blog_posts`.`blog_id`) WHERE `blog_blogs`.`group_id` IS null AND `blog_posts`.`created_at` BETWEEN 1722495600 AND 1725174000 ORDER BY `blog_posts`.`created_at` DESCConnection name: default Speed: 1.463 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) · 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/views/blog/archive.php, line 193File: 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 `blog_posts`.*, COUNT(`blog_id`) AS `monthCount` FROM `blog_posts` JOIN `blog_blogs` ON (`blog_blogs`.`id` = `blog_posts`.`blog_id`) WHERE `blog_blogs`.`group_id` IS null AND `blog_posts`.`created_at` BETWEEN 1725174000 AND 1727766000 ORDER BY `blog_posts`.`created_at` DESCConnection name: default Speed: 1.417 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) · 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/views/blog/archive.php, line 193File: 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 `blog_posts`.*, COUNT(`blog_id`) AS `monthCount` FROM `blog_posts` JOIN `blog_blogs` ON (`blog_blogs`.`id` = `blog_posts`.`blog_id`) WHERE `blog_blogs`.`group_id` IS null AND `blog_posts`.`created_at` BETWEEN 1727766000 AND 1730444400 ORDER BY `blog_posts`.`created_at` DESCConnection name: default Speed: 1.490 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) · 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/views/blog/archive.php, line 193File: 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 `blog_posts`.*, COUNT(`blog_id`) AS `monthCount` FROM `blog_posts` JOIN `blog_blogs` ON (`blog_blogs`.`id` = `blog_posts`.`blog_id`) WHERE `blog_blogs`.`group_id` IS null AND `blog_posts`.`created_at` BETWEEN 1730444400 AND 1733040000 ORDER BY `blog_posts`.`created_at` DESCConnection name: default Speed: 1.410 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) · 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/views/blog/archive.php, line 193File: 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 `blog_posts`.*, COUNT(`blog_id`) AS `monthCount` FROM `blog_posts` JOIN `blog_blogs` ON (`blog_blogs`.`id` = `blog_posts`.`blog_id`) WHERE `blog_blogs`.`group_id` IS null AND `blog_posts`.`created_at` BETWEEN 1733040000 AND 1735718400 ORDER BY `blog_posts`.`created_at` DESCConnection name: default Speed: 1.416 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) · 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/views/blog/archive.php, line 193File: 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 `blog_posts`.*, COUNT(`blog_id`) AS `monthCount` FROM `blog_posts` JOIN `blog_blogs` ON (`blog_blogs`.`id` = `blog_posts`.`blog_id`) WHERE `blog_blogs`.`group_id` IS null AND `blog_posts`.`created_at` BETWEEN 1735718400 AND 1738396800 ORDER BY `blog_posts`.`created_at` DESCConnection name: default Speed: 1.461 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) · 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/views/blog/archive.php, line 193File: 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 `blog_posts`.*, COUNT(`blog_id`) AS `monthCount` FROM `blog_posts` JOIN `blog_blogs` ON (`blog_blogs`.`id` = `blog_posts`.`blog_id`) WHERE `blog_blogs`.`group_id` IS null AND `blog_posts`.`created_at` BETWEEN 1738396800 AND 1740816000 ORDER BY `blog_posts`.`created_at` DESCConnection name: default Speed: 1.413 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) · 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/views/blog/archive.php, line 193File: 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 `blog_posts`.*, COUNT(`blog_id`) AS `monthCount` FROM `blog_posts` JOIN `blog_blogs` ON (`blog_blogs`.`id` = `blog_posts`.`blog_id`) WHERE `blog_blogs`.`group_id` IS null AND `blog_posts`.`created_at` BETWEEN 1740816000 AND 1743490800 ORDER BY `blog_posts`.`created_at` DESCConnection name: default Speed: 1.451 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) · 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/views/blog/archive.php, line 193File: 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 `blog_posts`.*, COUNT(`blog_id`) AS `monthCount` FROM `blog_posts` JOIN `blog_blogs` ON (`blog_blogs`.`id` = `blog_posts`.`blog_id`) WHERE `blog_blogs`.`group_id` IS null AND `blog_posts`.`created_at` BETWEEN 1743490800 AND 1746082800 ORDER BY `blog_posts`.`created_at` DESCConnection name: default Speed: 1.405 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) · 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/views/blog/archive.php, line 193File: 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 `blog_posts`.*, COUNT(`blog_id`) AS `monthCount` FROM `blog_posts` JOIN `blog_blogs` ON (`blog_blogs`.`id` = `blog_posts`.`blog_id`) WHERE `blog_blogs`.`group_id` IS null AND `blog_posts`.`created_at` BETWEEN 1746082800 AND 1748761200 ORDER BY `blog_posts`.`created_at` DESCConnection name: default Speed: 1.408 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) · 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/views/blog/archive.php, line 193File: 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 `blog_posts`.*, COUNT(`blog_id`) AS `monthCount` FROM `blog_posts` JOIN `blog_blogs` ON (`blog_blogs`.`id` = `blog_posts`.`blog_id`) WHERE `blog_blogs`.`group_id` IS null AND `blog_posts`.`created_at` BETWEEN 1748761200 AND 1751353200 ORDER BY `blog_posts`.`created_at` DESCConnection name: default Speed: 1.439 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) · 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/views/blog/archive.php, line 193File: 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` = '24' LIMIT 1Connection name: default Speed: 0.224 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.php, line 245File: 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.357 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.php, line 246File: 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.441 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.231 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.201 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.197 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.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: 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.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 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 |