SELECT `group`, `data` FROM `config` WHERE `group` LIKE 'Global::%'Connection name: default Speed: 0.684 ms Query analysis: · Query: SIMPLE on config · Possible keys: group · Key Used: group · Type: range · Rows: 1 (Using index condition) Call trace for this query:File: APPPATH/classes/app.php, line 383File: APPPATH/classes/app.php, line 105File: APPPATH/config/event.php, line 6File: COREPATH/classes/event/instance.php, line 157File: COREPATH/classes/fuel.php, line 222File: APPPATH/bootstrap.php, line 43File: DOCROOT/index.php, line 205 |
SELECT `t0`.`template_id` AS `t0_c0`, `t0`.`posts` AS `t0_c1`, `t0`.`section` AS `t0_c2`, `t0`.`slug` AS `t0_c3`, `t0`.`folder` AS `t0_c4`, `t0`.`title` AS `t0_c5`, `t0`.`published` AS `t0_c6`, `t0`.`css` AS `t0_c7`, `t0`.`js` AS `t0_c8`, `t0`.`rulegroup_id` AS `t0_c9`, `t0`.`id` AS `t0_c10`, `t0`.`created_at` AS `t0_c11`, `t0`.`updated_at` AS `t0_c12` FROM `cms_pages` AS `t0` WHERE `t0`.`section` = '' AND `t0`.`slug` = 'home' AND `t0`.`published` = 1 LIMIT 1Connection name: default Speed: 0.983 ms Query analysis: · Query: SIMPLE on t0 · Type: ALL · Rows: 592 (Using where) Call trace for this query:File: PKGPATH/orm/classes/query.php, line 1564File: APPPATH/classes/query.php, line 19File: PKGPATH/orm/classes/query.php, line 1641File: APPPATH/modules/cms/classes/cms.php, line 76File: APPPATH/modules/cms/classes/controller/router.php, line 84File: APPPATH/classes/core/base.php, line 109File: DOCROOT/index.php, line 222 |
SELECT `t0`.`name` AS `t0_c0`, `t0`.`content_areas` AS `t0_c1`, `t0`.`view` AS `t0_c2`, `t0`.`id` AS `t0_c3`, `t0`.`created_at` AS `t0_c4`, `t0`.`updated_at` AS `t0_c5` FROM `cms_templates` AS `t0` WHERE `t0`.`id` = '13' LIMIT 1Connection name: default Speed: 0.421 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 102File: APPPATH/modules/cms/classes/controller/router.php, line 84File: APPPATH/classes/core/base.php, line 109File: DOCROOT/index.php, line 222 |
SELECT * FROM cms_posts WHERE id = '1238' OR id = '2087' OR id = '1209' OR id = '1211' OR id = '1212' OR id = '1210'Connection name: default Speed: 0.474 ms Query analysis: · Query: SIMPLE on cms_posts · Possible keys: PRIMARY · Key Used: PRIMARY · Type: range · Rows: 6 (Using where) Call trace for this query:File: APPPATH/modules/cms/classes/cms.php, line 164File: APPPATH/modules/cms/classes/cms.php, line 115File: APPPATH/modules/cms/classes/controller/router.php, line 84File: APPPATH/classes/core/base.php, line 109File: DOCROOT/index.php, line 222 |
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` = '1209' LIMIT 1Connection name: default Speed: 0.358 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 172File: APPPATH/modules/cms/classes/cms.php, line 115File: APPPATH/modules/cms/classes/controller/router.php, line 84File: APPPATH/classes/core/base.php, line 109File: DOCROOT/index.php, line 222 |
SELECT `t0`.`data` AS `t0_c0`, `t0`.`id` AS `t0_c1`, `t0`.`type` AS `t0_c2`, `t0`.`linked_to` AS `t0_c3`, `t0`.`foreign_key` AS `t0_c4`, `t0`.`name` AS `t0_c5`, `t0`.`sort_order` AS `t0_c6`, `t0`.`require_login` AS `t0_c7`, `t0`.`not_in_query` AS `t0_c8`, `t0`.`user_allowed_cids` AS `t0_c9`, `t0`.`user_banned_cids` AS `t0_c10`, `t0`.`user_allowed_ids` AS `t0_c11`, `t0`.`user_banned_ids` AS `t0_c12`, `t0`.`user_allowed_groups` AS `t0_c13`, `t0`.`user_banned_groups` AS `t0_c14`, `t0`.`user_allowed_user_groups` AS `t0_c15`, `t0`.`user_banned_user_groups` AS `t0_c16`, `t0`.`invoice_event_id` AS `t0_c17`, `t0`.`invoice_product_model_id` AS `t0_c18`, `t0`.`invoice_banned_product_model_id` AS `t0_c19`, `t0`.`invoice_product_type` AS `t0_c20`, `t0`.`invoice_banned_product_type` AS `t0_c21`, `t0`.`invoice_active_subscription` AS `t0_c22`, `t0`.`user_is_org` AS `t0_c23`, `t0`.`user_is_org_admin` AS `t0_c24`, `t0`.`org_allowed_cids` AS `t0_c25`, `t0`.`org_banned_cids` AS `t0_c26`, `t0`.`org_allowed_ids` AS `t0_c27`, `t0`.`org_banned_ids` AS `t0_c28`, `t0`.`sched_is_presenter` AS `t0_c29`, `t0`.`sched_allowed_presenter_ids` AS `t0_c30`, `t0`.`sched_banned_presenter_ids` AS `t0_c31`, `t0`.`sched_is_exhibitor` AS `t0_c32`, `t0`.`sched_allowed_exhibitor_ids` AS `t0_c33`, `t0`.`sched_banned_exhibitor_ids` AS `t0_c34`, `t0`.`sched_event_id` AS `t0_c35`, `t0`.`ds_is_user` AS `t0_c36`, `t0`.`ds_is_admin` AS `t0_c37`, `t0`.`ds_is_state_contact` AS `t0_c38`, `t0`.`ds_year` AS `t0_c39`, `t0`.`created_at` AS `t0_c40`, `t0`.`updated_at` AS `t0_c41` FROM `user_rule_groups` AS `t0` WHERE `t0`.`id` = '0' LIMIT 1Connection name: default Speed: 0.461 ms Query analysis: · Query: SIMPLE (no matching row in const table) Call trace for this query:File: PKGPATH/orm/classes/query.php, line 1564File: APPPATH/classes/query.php, line 19File: PKGPATH/orm/classes/query.php, line 1641File: PKGPATH/orm/classes/belongsto.php, line 66File: PKGPATH/orm/classes/model.php, line 1232File: PKGPATH/orm/classes/model.php, line 1068File: APPPATH/modules/cms/classes/cms.php, line 175File: APPPATH/modules/cms/classes/cms.php, line 115File: APPPATH/modules/cms/classes/controller/router.php, line 84File: APPPATH/classes/core/base.php, line 109File: DOCROOT/index.php, line 222 |
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` = '1210' LIMIT 1Connection name: default Speed: 0.333 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 172File: APPPATH/modules/cms/classes/cms.php, line 115File: APPPATH/modules/cms/classes/controller/router.php, line 84File: APPPATH/classes/core/base.php, line 109File: DOCROOT/index.php, line 222 |
SELECT `t0`.`data` AS `t0_c0`, `t0`.`id` AS `t0_c1`, `t0`.`type` AS `t0_c2`, `t0`.`linked_to` AS `t0_c3`, `t0`.`foreign_key` AS `t0_c4`, `t0`.`name` AS `t0_c5`, `t0`.`sort_order` AS `t0_c6`, `t0`.`require_login` AS `t0_c7`, `t0`.`not_in_query` AS `t0_c8`, `t0`.`user_allowed_cids` AS `t0_c9`, `t0`.`user_banned_cids` AS `t0_c10`, `t0`.`user_allowed_ids` AS `t0_c11`, `t0`.`user_banned_ids` AS `t0_c12`, `t0`.`user_allowed_groups` AS `t0_c13`, `t0`.`user_banned_groups` AS `t0_c14`, `t0`.`user_allowed_user_groups` AS `t0_c15`, `t0`.`user_banned_user_groups` AS `t0_c16`, `t0`.`invoice_event_id` AS `t0_c17`, `t0`.`invoice_product_model_id` AS `t0_c18`, `t0`.`invoice_banned_product_model_id` AS `t0_c19`, `t0`.`invoice_product_type` AS `t0_c20`, `t0`.`invoice_banned_product_type` AS `t0_c21`, `t0`.`invoice_active_subscription` AS `t0_c22`, `t0`.`user_is_org` AS `t0_c23`, `t0`.`user_is_org_admin` AS `t0_c24`, `t0`.`org_allowed_cids` AS `t0_c25`, `t0`.`org_banned_cids` AS `t0_c26`, `t0`.`org_allowed_ids` AS `t0_c27`, `t0`.`org_banned_ids` AS `t0_c28`, `t0`.`sched_is_presenter` AS `t0_c29`, `t0`.`sched_allowed_presenter_ids` AS `t0_c30`, `t0`.`sched_banned_presenter_ids` AS `t0_c31`, `t0`.`sched_is_exhibitor` AS `t0_c32`, `t0`.`sched_allowed_exhibitor_ids` AS `t0_c33`, `t0`.`sched_banned_exhibitor_ids` AS `t0_c34`, `t0`.`sched_event_id` AS `t0_c35`, `t0`.`ds_is_user` AS `t0_c36`, `t0`.`ds_is_admin` AS `t0_c37`, `t0`.`ds_is_state_contact` AS `t0_c38`, `t0`.`ds_year` AS `t0_c39`, `t0`.`created_at` AS `t0_c40`, `t0`.`updated_at` AS `t0_c41` FROM `user_rule_groups` AS `t0` WHERE `t0`.`id` = '0' LIMIT 1Connection name: default Speed: 0.420 ms · DUPLICATE Query analysis: · Query: SIMPLE (no matching row in const table) Call trace for this query:File: PKGPATH/orm/classes/query.php, line 1564File: APPPATH/classes/query.php, line 19File: PKGPATH/orm/classes/query.php, line 1641File: PKGPATH/orm/classes/belongsto.php, line 66File: PKGPATH/orm/classes/model.php, line 1232File: PKGPATH/orm/classes/model.php, line 1068File: APPPATH/modules/cms/classes/cms.php, line 175File: APPPATH/modules/cms/classes/cms.php, line 115File: APPPATH/modules/cms/classes/controller/router.php, line 84File: APPPATH/classes/core/base.php, line 109File: DOCROOT/index.php, line 222 |
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` = '1211' LIMIT 1Connection name: default Speed: 0.237 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 172File: APPPATH/modules/cms/classes/cms.php, line 115File: APPPATH/modules/cms/classes/controller/router.php, line 84File: APPPATH/classes/core/base.php, line 109File: DOCROOT/index.php, line 222 |
SELECT `t0`.`data` AS `t0_c0`, `t0`.`id` AS `t0_c1`, `t0`.`type` AS `t0_c2`, `t0`.`linked_to` AS `t0_c3`, `t0`.`foreign_key` AS `t0_c4`, `t0`.`name` AS `t0_c5`, `t0`.`sort_order` AS `t0_c6`, `t0`.`require_login` AS `t0_c7`, `t0`.`not_in_query` AS `t0_c8`, `t0`.`user_allowed_cids` AS `t0_c9`, `t0`.`user_banned_cids` AS `t0_c10`, `t0`.`user_allowed_ids` AS `t0_c11`, `t0`.`user_banned_ids` AS `t0_c12`, `t0`.`user_allowed_groups` AS `t0_c13`, `t0`.`user_banned_groups` AS `t0_c14`, `t0`.`user_allowed_user_groups` AS `t0_c15`, `t0`.`user_banned_user_groups` AS `t0_c16`, `t0`.`invoice_event_id` AS `t0_c17`, `t0`.`invoice_product_model_id` AS `t0_c18`, `t0`.`invoice_banned_product_model_id` AS `t0_c19`, `t0`.`invoice_product_type` AS `t0_c20`, `t0`.`invoice_banned_product_type` AS `t0_c21`, `t0`.`invoice_active_subscription` AS `t0_c22`, `t0`.`user_is_org` AS `t0_c23`, `t0`.`user_is_org_admin` AS `t0_c24`, `t0`.`org_allowed_cids` AS `t0_c25`, `t0`.`org_banned_cids` AS `t0_c26`, `t0`.`org_allowed_ids` AS `t0_c27`, `t0`.`org_banned_ids` AS `t0_c28`, `t0`.`sched_is_presenter` AS `t0_c29`, `t0`.`sched_allowed_presenter_ids` AS `t0_c30`, `t0`.`sched_banned_presenter_ids` AS `t0_c31`, `t0`.`sched_is_exhibitor` AS `t0_c32`, `t0`.`sched_allowed_exhibitor_ids` AS `t0_c33`, `t0`.`sched_banned_exhibitor_ids` AS `t0_c34`, `t0`.`sched_event_id` AS `t0_c35`, `t0`.`ds_is_user` AS `t0_c36`, `t0`.`ds_is_admin` AS `t0_c37`, `t0`.`ds_is_state_contact` AS `t0_c38`, `t0`.`ds_year` AS `t0_c39`, `t0`.`created_at` AS `t0_c40`, `t0`.`updated_at` AS `t0_c41` FROM `user_rule_groups` AS `t0` WHERE `t0`.`id` = '0' LIMIT 1Connection name: default Speed: 0.277 ms · DUPLICATE Query analysis: · Query: SIMPLE (no matching row in const table) Call trace for this query:File: PKGPATH/orm/classes/query.php, line 1564File: APPPATH/classes/query.php, line 19File: PKGPATH/orm/classes/query.php, line 1641File: PKGPATH/orm/classes/belongsto.php, line 66File: PKGPATH/orm/classes/model.php, line 1232File: PKGPATH/orm/classes/model.php, line 1068File: APPPATH/modules/cms/classes/cms.php, line 175File: APPPATH/modules/cms/classes/cms.php, line 115File: APPPATH/modules/cms/classes/controller/router.php, line 84File: APPPATH/classes/core/base.php, line 109File: DOCROOT/index.php, line 222 |
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` = '1212' LIMIT 1Connection name: default Speed: 0.228 ms Query analysis: · Query: SIMPLE on t0 · Possible keys: PRIMARY · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: PKGPATH/orm/classes/query.php, line 1564File: APPPATH/classes/query.php, line 19File: PKGPATH/orm/classes/query.php, line 1641File: APPPATH/classes/model/base.php, line 941File: APPPATH/modules/cms/classes/cms.php, line 172File: APPPATH/modules/cms/classes/cms.php, line 115File: APPPATH/modules/cms/classes/controller/router.php, line 84File: APPPATH/classes/core/base.php, line 109File: DOCROOT/index.php, line 222 |
SELECT `t0`.`data` AS `t0_c0`, `t0`.`id` AS `t0_c1`, `t0`.`type` AS `t0_c2`, `t0`.`linked_to` AS `t0_c3`, `t0`.`foreign_key` AS `t0_c4`, `t0`.`name` AS `t0_c5`, `t0`.`sort_order` AS `t0_c6`, `t0`.`require_login` AS `t0_c7`, `t0`.`not_in_query` AS `t0_c8`, `t0`.`user_allowed_cids` AS `t0_c9`, `t0`.`user_banned_cids` AS `t0_c10`, `t0`.`user_allowed_ids` AS `t0_c11`, `t0`.`user_banned_ids` AS `t0_c12`, `t0`.`user_allowed_groups` AS `t0_c13`, `t0`.`user_banned_groups` AS `t0_c14`, `t0`.`user_allowed_user_groups` AS `t0_c15`, `t0`.`user_banned_user_groups` AS `t0_c16`, `t0`.`invoice_event_id` AS `t0_c17`, `t0`.`invoice_product_model_id` AS `t0_c18`, `t0`.`invoice_banned_product_model_id` AS `t0_c19`, `t0`.`invoice_product_type` AS `t0_c20`, `t0`.`invoice_banned_product_type` AS `t0_c21`, `t0`.`invoice_active_subscription` AS `t0_c22`, `t0`.`user_is_org` AS `t0_c23`, `t0`.`user_is_org_admin` AS `t0_c24`, `t0`.`org_allowed_cids` AS `t0_c25`, `t0`.`org_banned_cids` AS `t0_c26`, `t0`.`org_allowed_ids` AS `t0_c27`, `t0`.`org_banned_ids` AS `t0_c28`, `t0`.`sched_is_presenter` AS `t0_c29`, `t0`.`sched_allowed_presenter_ids` AS `t0_c30`, `t0`.`sched_banned_presenter_ids` AS `t0_c31`, `t0`.`sched_is_exhibitor` AS `t0_c32`, `t0`.`sched_allowed_exhibitor_ids` AS `t0_c33`, `t0`.`sched_banned_exhibitor_ids` AS `t0_c34`, `t0`.`sched_event_id` AS `t0_c35`, `t0`.`ds_is_user` AS `t0_c36`, `t0`.`ds_is_admin` AS `t0_c37`, `t0`.`ds_is_state_contact` AS `t0_c38`, `t0`.`ds_year` AS `t0_c39`, `t0`.`created_at` AS `t0_c40`, `t0`.`updated_at` AS `t0_c41` FROM `user_rule_groups` AS `t0` WHERE `t0`.`id` = '0' LIMIT 1Connection name: default Speed: 0.290 ms · DUPLICATE Query analysis: · Query: SIMPLE (no matching row in const table) Call trace for this query:File: PKGPATH/orm/classes/query.php, line 1564File: APPPATH/classes/query.php, line 19File: PKGPATH/orm/classes/query.php, line 1641File: PKGPATH/orm/classes/belongsto.php, line 66File: PKGPATH/orm/classes/model.php, line 1232File: PKGPATH/orm/classes/model.php, line 1068File: APPPATH/modules/cms/classes/cms.php, line 175File: APPPATH/modules/cms/classes/cms.php, line 115File: APPPATH/modules/cms/classes/controller/router.php, line 84File: APPPATH/classes/core/base.php, line 109File: DOCROOT/index.php, line 222 |
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` = '2087' 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 172File: APPPATH/modules/cms/classes/cms.php, line 115File: APPPATH/modules/cms/classes/controller/router.php, line 84File: APPPATH/classes/core/base.php, line 109File: DOCROOT/index.php, line 222 |
SELECT `t0`.`data` AS `t0_c0`, `t0`.`id` AS `t0_c1`, `t0`.`type` AS `t0_c2`, `t0`.`linked_to` AS `t0_c3`, `t0`.`foreign_key` AS `t0_c4`, `t0`.`name` AS `t0_c5`, `t0`.`sort_order` AS `t0_c6`, `t0`.`require_login` AS `t0_c7`, `t0`.`not_in_query` AS `t0_c8`, `t0`.`user_allowed_cids` AS `t0_c9`, `t0`.`user_banned_cids` AS `t0_c10`, `t0`.`user_allowed_ids` AS `t0_c11`, `t0`.`user_banned_ids` AS `t0_c12`, `t0`.`user_allowed_groups` AS `t0_c13`, `t0`.`user_banned_groups` AS `t0_c14`, `t0`.`user_allowed_user_groups` AS `t0_c15`, `t0`.`user_banned_user_groups` AS `t0_c16`, `t0`.`invoice_event_id` AS `t0_c17`, `t0`.`invoice_product_model_id` AS `t0_c18`, `t0`.`invoice_banned_product_model_id` AS `t0_c19`, `t0`.`invoice_product_type` AS `t0_c20`, `t0`.`invoice_banned_product_type` AS `t0_c21`, `t0`.`invoice_active_subscription` AS `t0_c22`, `t0`.`user_is_org` AS `t0_c23`, `t0`.`user_is_org_admin` AS `t0_c24`, `t0`.`org_allowed_cids` AS `t0_c25`, `t0`.`org_banned_cids` AS `t0_c26`, `t0`.`org_allowed_ids` AS `t0_c27`, `t0`.`org_banned_ids` AS `t0_c28`, `t0`.`sched_is_presenter` AS `t0_c29`, `t0`.`sched_allowed_presenter_ids` AS `t0_c30`, `t0`.`sched_banned_presenter_ids` AS `t0_c31`, `t0`.`sched_is_exhibitor` AS `t0_c32`, `t0`.`sched_allowed_exhibitor_ids` AS `t0_c33`, `t0`.`sched_banned_exhibitor_ids` AS `t0_c34`, `t0`.`sched_event_id` AS `t0_c35`, `t0`.`ds_is_user` AS `t0_c36`, `t0`.`ds_is_admin` AS `t0_c37`, `t0`.`ds_is_state_contact` AS `t0_c38`, `t0`.`ds_year` AS `t0_c39`, `t0`.`created_at` AS `t0_c40`, `t0`.`updated_at` AS `t0_c41` FROM `user_rule_groups` AS `t0` WHERE `t0`.`id` = '0' LIMIT 1Connection name: default Speed: 0.287 ms · DUPLICATE Query analysis: · Query: SIMPLE (no matching row in const table) Call trace for this query:File: PKGPATH/orm/classes/query.php, line 1564File: APPPATH/classes/query.php, line 19File: PKGPATH/orm/classes/query.php, line 1641File: PKGPATH/orm/classes/belongsto.php, line 66File: PKGPATH/orm/classes/model.php, line 1232File: PKGPATH/orm/classes/model.php, line 1068File: APPPATH/modules/cms/classes/cms.php, line 175File: APPPATH/modules/cms/classes/cms.php, line 115File: APPPATH/modules/cms/classes/controller/router.php, line 84File: APPPATH/classes/core/base.php, line 109File: DOCROOT/index.php, line 222 |
SELECT `post`.*, `blog`.`name` AS `blog_name`, `blog`.`slug` AS `blog_slug` FROM `blog_blogs` AS `blog` JOIN `blog_posts` AS `post` ON (`post`.`blog_id` = `blog`.`id` AND `blog`.`id` IN (1,3,4,5,6) AND `post`.`published` = 'yes') GROUP BY `post`.`title` ORDER BY `post`.`created_at` DESC LIMIT 4Connection name: default Speed: 10.853 ms Query analysis: · Query: SIMPLE on blog · Possible keys: PRIMARY · Key Used: PRIMARY · Type: range · Rows: 5 (Using where; Using temporary; Using filesort) · Query: SIMPLE on post · Possible keys: fk_blog_posts_blog · Key Used: fk_blog_posts_blog · Type: ref · Rows: 23 (Using where) Call trace for this query:File: APPPATH/views/templates/homepagenew.php, line 14File: APPPATH/classes/controller/controller.php, line 136File: APPPATH/modules/cms/classes/controller/router.php, line 130File: APPPATH/classes/core/base.php, line 109File: DOCROOT/index.php, line 222 |
SELECT `data` FROM `config` WHERE `group` = 'Ondemand::HomeVideos' LIMIT 1Connection name: default Speed: 0.268 ms Query analysis: · Query: SIMPLE on config · Possible keys: group · Key Used: group · Type: ref · Rows: 1 Call trace for this query:File: APPPATH/views/templates/homepagenew.php, line 25File: APPPATH/classes/controller/controller.php, line 136File: APPPATH/modules/cms/classes/controller/router.php, line 130File: APPPATH/classes/core/base.php, line 109File: DOCROOT/index.php, line 222 |
SELECT `t0`.`data` AS `t0_c0`, `t0`.`id` AS `t0_c1`, `t0`.`session_id` AS `t0_c2`, `t0`.`brightcove_id` AS `t0_c3`, `t0`.`published` AS `t0_c4`, `t0`.`premium` AS `t0_c5`, `t0`.`type` AS `t0_c6`, `t0`.`title` AS `t0_c7`, `t0`.`description` AS `t0_c8`, `t0`.`contact_email` AS `t0_c9`, `t0`.`category` AS `t0_c10`, `t0`.`film_location` AS `t0_c11`, `t0`.`film_event` AS `t0_c12`, `t0`.`film_date` AS `t0_c13`, `t0`.`tags` AS `t0_c14`, `t0`.`slug` AS `t0_c15`, `t0`.`length` AS `t0_c16`, `t0`.`video_embed` AS `t0_c17`, `t0`.`clip_embed` AS `t0_c18`, `t0`.`video_download` AS `t0_c19`, `t0`.`start` AS `t0_c20`, `t0`.`end` AS `t0_c21`, `t0`.`created_at` AS `t0_c22`, `t0`.`updated_at` AS `t0_c23`, `t1`.`rel_paths` AS `t1_c0`, `t1`.`data` AS `t1_c1`, `t1`.`id` AS `t1_c2`, `t1`.`name` AS `t1_c3`, `t1`.`filename` AS `t1_c4`, `t1`.`orig_url` AS `t1_c5`, `t1`.`base_url` AS `t1_c6`, `t1`.`type` AS `t1_c7`, `t1`.`linked_to` AS `t1_c8`, `t1`.`event_code` AS `t1_c9`, `t1`.`foreign_key` AS `t1_c10`, `t1`.`extension` AS `t1_c11`, `t1`.`size` AS `t1_c12`, `t1`.`created_at` AS `t1_c13`, `t1`.`updated_at` AS `t1_c14`, `t2_through`.`presenter_id`, `t2_through`.`talk_id`, `t2`.`data` AS `t2_c0`, `t2`.`id` AS `t2_c1`, `t2`.`presenter_id` AS `t2_c2`, `t2`.`user_id` AS `t2_c3`, `t2`.`first_name` AS `t2_c4`, `t2`.`last_name` AS `t2_c5`, `t2`.`bio` AS `t2_c6`, `t2`.`slug` AS `t2_c7`, `t2`.`created_at` AS `t2_c8`, `t2`.`updated_at` AS `t2_c9`, `t3`.`rel_paths` AS `t3_c0`, `t3`.`data` AS `t3_c1`, `t3`.`id` AS `t3_c2`, `t3`.`name` AS `t3_c3`, `t3`.`filename` AS `t3_c4`, `t3`.`orig_url` AS `t3_c5`, `t3`.`base_url` AS `t3_c6`, `t3`.`type` AS `t3_c7`, `t3`.`linked_to` AS `t3_c8`, `t3`.`event_code` AS `t3_c9`, `t3`.`foreign_key` AS `t3_c10`, `t3`.`extension` AS `t3_c11`, `t3`.`size` AS `t3_c12`, `t3`.`created_at` AS `t3_c13`, `t3`.`updated_at` AS `t3_c14` FROM (SELECT `t0`.`data`, `t0`.`id`, `t0`.`session_id`, `t0`.`brightcove_id`, `t0`.`published`, `t0`.`premium`, `t0`.`type`, `t0`.`title`, `t0`.`description`, `t0`.`contact_email`, `t0`.`category`, `t0`.`film_location`, `t0`.`film_event`, `t0`.`film_date`, `t0`.`tags`, `t0`.`slug`, `t0`.`length`, `t0`.`video_embed`, `t0`.`clip_embed`, `t0`.`video_download`, `t0`.`start`, `t0`.`end`, `t0`.`created_at`, `t0`.`updated_at` FROM `ondemand_talks` AS `t0` WHERE `t0`.`published` = 'yes' AND `t0`.`id` IN (1905, 1778, 1898, 1768) LIMIT 4) AS `t0` LEFT JOIN `images` AS `t1` ON (`t0`.`id` = `t1`.`foreign_key` AND `t1`.`linked_to` = 'ondemand_talk') LEFT JOIN `ondemand_presenters_talks` AS `t2_through` ON (`t0`.`id` = `t2_through`.`talk_id`) LEFT JOIN `ondemand_presenters` AS `t2` ON (`t2_through`.`presenter_id` = `t2`.`id`) LEFT JOIN `images` AS `t3` ON (`t2`.`id` = `t3`.`foreign_key` AND `t3`.`linked_to` = 'ondemand_presenter') ORDER BY FIELD (`t0`.`id`,1905, 1778, 1898, 1768) ASCConnection name: default Speed: 76.461 ms Query analysis: · Query: PRIMARY on <derived2> · Type: ALL · Rows: 2 (Using temporary; Using filesort) · Query: PRIMARY on t1 · Type: ALL · Rows: 28284 (Using where; Using join buffer (hash join)) · Query: PRIMARY on t2_through · Possible keys: fk_ondemand_presenters_talks_talk · Key Used: fk_ondemand_presenters_talks_talk · Type: ref · Rows: 1 · Query: PRIMARY on t2 · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: PRIMARY on t3 · Type: ALL · Rows: 28284 (Using where; Using join buffer (hash join)) · Query: DERIVED on t0 · Possible keys: PRIMARY · Key Used: PRIMARY · Type: range · Rows: 4 (Using where) Call trace for this query:File: PKGPATH/orm/classes/query.php, line 1564File: APPPATH/classes/query.php, line 19File: APPPATH/views/templates/homepagenew.php, line 35File: APPPATH/classes/controller/controller.php, line 136File: APPPATH/modules/cms/classes/controller/router.php, line 130File: APPPATH/classes/core/base.php, line 109File: DOCROOT/index.php, line 222 |
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.454 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: APPPATH/classes/core/Display.php, line 71File: APPPATH/views/templates/homepagenew.php, line 1117File: APPPATH/classes/controller/controller.php, line 136File: APPPATH/modules/cms/classes/controller/router.php, line 130File: APPPATH/classes/core/base.php, line 109File: DOCROOT/index.php, line 222 |
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.230 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: APPPATH/classes/core/Display.php, line 71File: APPPATH/views/templates/homepagenew.php, line 1117File: APPPATH/classes/controller/controller.php, line 136File: APPPATH/modules/cms/classes/controller/router.php, line 130File: APPPATH/classes/core/base.php, line 109File: DOCROOT/index.php, line 222 |
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.199 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: APPPATH/classes/core/Display.php, line 71File: APPPATH/views/templates/homepagenew.php, line 1117File: APPPATH/classes/controller/controller.php, line 136File: APPPATH/modules/cms/classes/controller/router.php, line 130File: APPPATH/classes/core/base.php, line 109File: DOCROOT/index.php, line 222 |
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.208 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: APPPATH/classes/core/Display.php, line 71File: APPPATH/views/templates/homepagenew.php, line 1117File: APPPATH/classes/controller/controller.php, line 136File: APPPATH/modules/cms/classes/controller/router.php, line 130File: APPPATH/classes/core/base.php, line 109File: DOCROOT/index.php, line 222 |
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.288 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: APPPATH/classes/core/Display.php, line 71File: APPPATH/views/templates/homepagenew.php, line 1117File: APPPATH/classes/controller/controller.php, line 136File: APPPATH/modules/cms/classes/controller/router.php, line 130File: APPPATH/classes/core/base.php, line 109File: DOCROOT/index.php, line 222 |
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.200 ms Query analysis: · Query: SIMPLE on t0 · Possible keys: PRIMARY · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: PKGPATH/orm/classes/query.php, line 1564File: APPPATH/classes/query.php, line 19File: PKGPATH/orm/classes/query.php, line 1641File: 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: APPPATH/classes/core/Display.php, line 71File: APPPATH/views/templates/homepagenew.php, line 1117File: APPPATH/classes/controller/controller.php, line 136File: APPPATH/modules/cms/classes/controller/router.php, line 130File: APPPATH/classes/core/base.php, line 109File: DOCROOT/index.php, line 222 |
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.202 ms Query analysis: · Query: SIMPLE on t0 · Possible keys: PRIMARY · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: PKGPATH/orm/classes/query.php, line 1564File: APPPATH/classes/query.php, line 19File: PKGPATH/orm/classes/query.php, line 1641File: 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: APPPATH/classes/core/Display.php, line 71File: APPPATH/views/templates/homepagenew.php, line 1117File: APPPATH/classes/controller/controller.php, line 136File: APPPATH/modules/cms/classes/controller/router.php, line 130File: APPPATH/classes/core/base.php, line 109File: DOCROOT/index.php, line 222 |
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.202 ms Query analysis: · Query: SIMPLE on t0 · Possible keys: PRIMARY · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: PKGPATH/orm/classes/query.php, line 1564File: APPPATH/classes/query.php, line 19File: PKGPATH/orm/classes/query.php, line 1641File: PKGPATH/orm/classes/model.php, line 668File: APPPATH/modules/cms/classes/cms.php, line 496File: APPPATH/views/templates/master/sticky-header.php, line 128File: APPPATH/classes/core/Display.php, line 71File: APPPATH/views/templates/homepagenew.php, line 1122File: APPPATH/classes/controller/controller.php, line 136File: APPPATH/modules/cms/classes/controller/router.php, line 130File: APPPATH/classes/core/base.php, line 109File: DOCROOT/index.php, line 222 |
SELECT `t0`.`id` AS `t0_c0`, `t0`.`name` AS `t0_c1`, `t0`.`image_items` AS `t0_c2`, `t0`.`auto_scroll` AS `t0_c3`, `t0`.`speed` AS `t0_c4`, `t0`.`wait_time` AS `t0_c5`, `t0`.`change_func` AS `t0_c6`, `t0`.`post_id` AS `t0_c7`, `t0`.`width` AS `t0_c8`, `t0`.`height` AS `t0_c9`, `t0`.`js` AS `t0_c10`, `t0`.`css` AS `t0_c11`, `t0`.`created_at` AS `t0_c12`, `t0`.`updated_at` AS `t0_c13` FROM `cms_widget_slideshows` AS `t0` WHERE `t0`.`id` = 2 LIMIT 1Connection name: default Speed: 0.256 ms Query analysis: · Query: SIMPLE on t0 · Possible keys: PRIMARY · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: PKGPATH/orm/classes/query.php, line 1564File: APPPATH/classes/query.php, line 19File: PKGPATH/orm/classes/query.php, line 1641File: PKGPATH/orm/classes/model.php, line 668File: APPPATH/views/templates/homepage-slider.php, line 3File: APPPATH/classes/core/Display.php, line 71File: APPPATH/views/templates/homepagenew.php, line 1151File: APPPATH/classes/controller/controller.php, line 136File: APPPATH/modules/cms/classes/controller/router.php, line 130File: APPPATH/classes/core/base.php, line 109File: DOCROOT/index.php, line 222 |
SELECT `t0`.`rel_paths` AS `t0_c0`, `t0`.`data` AS `t0_c1`, `t0`.`id` AS `t0_c2`, `t0`.`name` AS `t0_c3`, `t0`.`filename` AS `t0_c4`, `t0`.`orig_url` AS `t0_c5`, `t0`.`base_url` AS `t0_c6`, `t0`.`type` AS `t0_c7`, `t0`.`linked_to` AS `t0_c8`, `t0`.`event_code` AS `t0_c9`, `t0`.`foreign_key` AS `t0_c10`, `t0`.`extension` AS `t0_c11`, `t0`.`size` AS `t0_c12`, `t0`.`created_at` AS `t0_c13`, `t0`.`updated_at` AS `t0_c14` FROM `images` AS `t0` WHERE `t0`.`linked_to` = 'blog_post' AND `t0`.`foreign_key` = '1079'Connection name: default Speed: 31.574 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/templates/homepagenew.php, line 1180File: APPPATH/classes/controller/controller.php, line 136File: APPPATH/modules/cms/classes/controller/router.php, line 130File: APPPATH/classes/core/base.php, line 109File: DOCROOT/index.php, line 222 |
SELECT `t0`.`rel_paths` AS `t0_c0`, `t0`.`data` AS `t0_c1`, `t0`.`id` AS `t0_c2`, `t0`.`name` AS `t0_c3`, `t0`.`filename` AS `t0_c4`, `t0`.`orig_url` AS `t0_c5`, `t0`.`base_url` AS `t0_c6`, `t0`.`type` AS `t0_c7`, `t0`.`linked_to` AS `t0_c8`, `t0`.`event_code` AS `t0_c9`, `t0`.`foreign_key` AS `t0_c10`, `t0`.`extension` AS `t0_c11`, `t0`.`size` AS `t0_c12`, `t0`.`created_at` AS `t0_c13`, `t0`.`updated_at` AS `t0_c14` FROM `images` AS `t0` WHERE `t0`.`linked_to` = 'blog_post' AND `t0`.`foreign_key` = '1078'Connection name: default Speed: 31.532 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/templates/homepagenew.php, line 1180File: APPPATH/classes/controller/controller.php, line 136File: APPPATH/modules/cms/classes/controller/router.php, line 130File: APPPATH/classes/core/base.php, line 109File: DOCROOT/index.php, line 222 |
SELECT `t0`.`rel_paths` AS `t0_c0`, `t0`.`data` AS `t0_c1`, `t0`.`id` AS `t0_c2`, `t0`.`name` AS `t0_c3`, `t0`.`filename` AS `t0_c4`, `t0`.`orig_url` AS `t0_c5`, `t0`.`base_url` AS `t0_c6`, `t0`.`type` AS `t0_c7`, `t0`.`linked_to` AS `t0_c8`, `t0`.`event_code` AS `t0_c9`, `t0`.`foreign_key` AS `t0_c10`, `t0`.`extension` AS `t0_c11`, `t0`.`size` AS `t0_c12`, `t0`.`created_at` AS `t0_c13`, `t0`.`updated_at` AS `t0_c14` FROM `images` AS `t0` WHERE `t0`.`linked_to` = 'blog_post' AND `t0`.`foreign_key` = '1076'Connection name: default Speed: 31.504 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/templates/homepagenew.php, line 1180File: APPPATH/classes/controller/controller.php, line 136File: APPPATH/modules/cms/classes/controller/router.php, line 130File: APPPATH/classes/core/base.php, line 109File: DOCROOT/index.php, line 222 |
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` = '1075'Connection name: default Speed: 31.495 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/templates/homepagenew.php, line 1180File: APPPATH/classes/controller/controller.php, line 136File: APPPATH/modules/cms/classes/controller/router.php, line 130File: APPPATH/classes/core/base.php, line 109File: DOCROOT/index.php, line 222 |
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.440 ms Query analysis: · Query: SIMPLE on t0 · Possible keys: PRIMARY · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: PKGPATH/orm/classes/query.php, line 1564File: APPPATH/classes/query.php, line 19File: PKGPATH/orm/classes/query.php, line 1641File: APPPATH/classes/model/base.php, line 941File: APPPATH/modules/cms/classes/cms.php, line 194File: APPPATH/views/templates/master/footer.php, line 4File: APPPATH/classes/core/Display.php, line 71File: APPPATH/views/templates/homepagenew.php, line 1471File: APPPATH/classes/controller/controller.php, line 136File: APPPATH/modules/cms/classes/controller/router.php, line 130File: APPPATH/classes/core/base.php, line 109File: DOCROOT/index.php, line 222 |
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.233 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: APPPATH/classes/core/Display.php, line 71File: APPPATH/views/templates/homepagenew.php, line 1471File: APPPATH/classes/controller/controller.php, line 136File: APPPATH/modules/cms/classes/controller/router.php, line 130File: APPPATH/classes/core/base.php, line 109File: DOCROOT/index.php, line 222 |
SELECT `t0`.`title` AS `t0_c0`, `t0`.`folder` AS `t0_c1`, `t0`.`show_title` AS `t0_c2`, `t0`.`published` AS `t0_c3`, `t0`.`published_range` AS `t0_c4`, `t0`.`publish_start` AS `t0_c5`, `t0`.`publish_end` AS `t0_c6`, `t0`.`content` AS `t0_c7`, `t0`.`css` AS `t0_c8`, `t0`.`js` AS `t0_c9`, `t0`.`rulegroup_id` AS `t0_c10`, `t0`.`menu` AS `t0_c11`, `t0`.`widget` AS `t0_c12`, `t0`.`widget_type` AS `t0_c13`, `t0`.`created_at` AS `t0_c14`, `t0`.`updated_at` AS `t0_c15`, `t0`.`id` AS `t0_c16` FROM `cms_posts` AS `t0` WHERE `t0`.`id` = 494 LIMIT 1Connection name: default Speed: 0.203 ms Query analysis: · Query: SIMPLE on t0 · Possible keys: PRIMARY · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: PKGPATH/orm/classes/query.php, line 1564File: APPPATH/classes/query.php, line 19File: PKGPATH/orm/classes/query.php, line 1641File: APPPATH/classes/model/base.php, line 941File: APPPATH/modules/cms/classes/cms.php, line 194File: APPPATH/views/templates/master/footer.php, line 8File: APPPATH/classes/core/Display.php, line 71File: APPPATH/views/templates/homepagenew.php, line 1471File: APPPATH/classes/controller/controller.php, line 136File: APPPATH/modules/cms/classes/controller/router.php, line 130File: APPPATH/classes/core/base.php, line 109File: DOCROOT/index.php, line 222 |
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: APPPATH/classes/core/Display.php, line 71File: APPPATH/views/templates/homepagenew.php, line 1471File: APPPATH/classes/controller/controller.php, line 136File: APPPATH/modules/cms/classes/controller/router.php, line 130File: APPPATH/classes/core/base.php, line 109File: DOCROOT/index.php, line 222 |
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.200 ms Query analysis: · Query: SIMPLE on t0 · Possible keys: PRIMARY · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: PKGPATH/orm/classes/query.php, line 1564File: APPPATH/classes/query.php, line 19File: PKGPATH/orm/classes/query.php, line 1641File: APPPATH/classes/model/base.php, line 941File: APPPATH/modules/cms/classes/cms.php, line 194File: APPPATH/views/templates/master/footer.php, line 10File: APPPATH/classes/core/Display.php, line 71File: APPPATH/views/templates/homepagenew.php, line 1471File: APPPATH/classes/controller/controller.php, line 136File: APPPATH/modules/cms/classes/controller/router.php, line 130File: APPPATH/classes/core/base.php, line 109File: DOCROOT/index.php, line 222 |
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.199 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: APPPATH/classes/core/Display.php, line 71File: APPPATH/views/templates/homepagenew.php, line 1471File: APPPATH/classes/controller/controller.php, line 136File: APPPATH/modules/cms/classes/controller/router.php, line 130File: APPPATH/classes/core/base.php, line 109File: DOCROOT/index.php, line 222 |