SELECT `group`, `data` FROM `config` WHERE `group` LIKE 'Global::%'Connection name: default
Speed: 0.600 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`.`start` AS `t0_c0`, `t0`.`end` AS `t0_c1`, `t0`.`data` AS `t0_c2`, `t0`.`id` AS `t0_c3`, `t0`.`parent_event_id` AS `t0_c4`, `t0`.`custom_id` AS `t0_c5`, `t0`.`venue_id` AS `t0_c6`, `t0`.`type` AS `t0_c7`, `t0`.`name` AS `t0_c8`, `t0`.`subtitle` AS `t0_c9`, `t0`.`description` AS `t0_c10`, `t0`.`applies_to` AS `t0_c11`, `t0`.`url` AS `t0_c12`, `t0`.`slug` AS `t0_c13`, `t0`.`active` AS `t0_c14`, `t0`.`published` AS `t0_c15`, `t0`.`created_at` AS `t0_c16`, `t0`.`updated_at` AS `t0_c17` FROM `event_events` AS `t0` WHERE `t0`.`id` = 5 LIMIT 1Connection name: default
Speed: 0.606 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/ondemand/classes/controller/index.php, line 13File: COREPATH/classes/request.php, line 474File: DOCROOT/index.php, line 142File: DOCROOT/index.php, line 239 |
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`.`slug` = 'new-oversight-agenda-julia-martin' LIMIT 1) 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')Connection name: default
Speed: 81.656 ms
Query analysis:
· Query: PRIMARY on <derived2> · Type: system · Rows: 1
· Query: PRIMARY on t1 · Type: ALL · Rows: 28284 (Using where)
· 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: slug · Key Used: slug · Type: ref · 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/modules/ondemand/classes/controller/index.php, line 345File: APPPATH/modules/ondemand/classes/controller/index.php, line 52File: COREPATH/classes/request.php, line 476File: DOCROOT/index.php, line 142File: DOCROOT/index.php, line 239 |
SELECT `data` FROM `config` WHERE `group` = 'Ondemand::DefaultRuleGroup' LIMIT 1Connection name: default
Speed: 0.518 ms
Query analysis:
· Query: SIMPLE on config · Possible keys: group · Key Used: group · Type: ref · Rows: 1
Call trace for this query:File: APPPATH/modules/ondemand/classes/controller/index.php, line 363File: APPPATH/modules/ondemand/classes/controller/index.php, line 52File: COREPATH/classes/request.php, line 476File: DOCROOT/index.php, line 142File: DOCROOT/index.php, line 239 |
SELECT `t0`.`rule` AS `t0_c0`, `t0`.`data` AS `t0_c1`, `t0`.`id` AS `t0_c2`, `t0`.`rulegroup_id` AS `t0_c3`, `t0`.`type` AS `t0_c4`, `t0`.`foreign_key` AS `t0_c5`, `t0`.`order` AS `t0_c6`, `t0`.`created_at` AS `t0_c7`, `t0`.`updated_at` AS `t0_c8`, `t1`.`data` AS `t1_c0`, `t1`.`id` AS `t1_c1`, `t1`.`type` AS `t1_c2`, `t1`.`linked_to` AS `t1_c3`, `t1`.`foreign_key` AS `t1_c4`, `t1`.`name` AS `t1_c5`, `t1`.`sort_order` AS `t1_c6`, `t1`.`require_login` AS `t1_c7`, `t1`.`not_in_query` AS `t1_c8`, `t1`.`user_allowed_cids` AS `t1_c9`, `t1`.`user_banned_cids` AS `t1_c10`, `t1`.`user_allowed_ids` AS `t1_c11`, `t1`.`user_banned_ids` AS `t1_c12`, `t1`.`user_allowed_groups` AS `t1_c13`, `t1`.`user_banned_groups` AS `t1_c14`, `t1`.`user_allowed_user_groups` AS `t1_c15`, `t1`.`user_banned_user_groups` AS `t1_c16`, `t1`.`invoice_event_id` AS `t1_c17`, `t1`.`invoice_product_model_id` AS `t1_c18`, `t1`.`invoice_banned_product_model_id` AS `t1_c19`, `t1`.`invoice_product_type` AS `t1_c20`, `t1`.`invoice_banned_product_type` AS `t1_c21`, `t1`.`invoice_active_subscription` AS `t1_c22`, `t1`.`user_is_org` AS `t1_c23`, `t1`.`user_is_org_admin` AS `t1_c24`, `t1`.`org_allowed_cids` AS `t1_c25`, `t1`.`org_banned_cids` AS `t1_c26`, `t1`.`org_allowed_ids` AS `t1_c27`, `t1`.`org_banned_ids` AS `t1_c28`, `t1`.`sched_is_presenter` AS `t1_c29`, `t1`.`sched_allowed_presenter_ids` AS `t1_c30`, `t1`.`sched_banned_presenter_ids` AS `t1_c31`, `t1`.`sched_is_exhibitor` AS `t1_c32`, `t1`.`sched_allowed_exhibitor_ids` AS `t1_c33`, `t1`.`sched_banned_exhibitor_ids` AS `t1_c34`, `t1`.`sched_event_id` AS `t1_c35`, `t1`.`ds_is_user` AS `t1_c36`, `t1`.`ds_is_admin` AS `t1_c37`, `t1`.`ds_is_state_contact` AS `t1_c38`, `t1`.`ds_year` AS `t1_c39`, `t1`.`created_at` AS `t1_c40`, `t1`.`updated_at` AS `t1_c41` FROM `user_rules` AS `t0` LEFT JOIN `user_rule_groups` AS `t1` ON (`t0`.`rulegroup_id` = `t1`.`id`) WHERE `t0`.`foreign_key` = '879' AND `t0`.`type` = 'Ondemand_Talk'Connection name: default
Speed: 0.498 ms
Query analysis:
· Query: SIMPLE on t0 · Possible keys: type_key · Key Used: type_key · Type: ref · Rows: 2
· Query: SIMPLE on t1 · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1
Call trace for this query:File: PKGPATH/orm/classes/query.php, line 1564File: APPPATH/classes/query.php, line 19File: APPPATH/modules/ondemand/classes/controller/index.php, line 398File: APPPATH/modules/ondemand/classes/controller/index.php, line 52File: COREPATH/classes/request.php, line 476File: DOCROOT/index.php, line 142File: DOCROOT/index.php, line 239 |
SELECT
`talks`.*,
`presenters`.`id` AS `presenter_id`, `presenters`.`first_name` AS `presenter_first_name`, `presenters`.`last_name` AS `presenter_last_name`,
`images`.`id` AS `image_id`, `images`.`name` AS `image_name`, `images`.`orig_url` AS `image_orig_url`,
`images`.`base_url` AS `image_base_url`, `images`.`rel_paths` AS `image_rel_paths`, `images`.`filename` AS `image_filename`
FROM (
SELECT COALESCE(`views`.`view_count`, 0) AS `view_count`, `talks`.*
FROM `ondemand_talks` AS `talks`
LEFT JOIN (
SELECT `talk_id`, COUNT(`id`) AS `view_count`
FROM `ondemand_views` AS `views`
GROUP BY `talk_id`
) AS `views`
ON (
`views`.`talk_id` = `talks`.`id`
)
WHERE
`id` <> 879 AND (`talks`.`tags` LIKE '%oversight,%' OR `talks`.`tags` LIKE '%agenda,%' OR `talks`.`tags` LIKE '%webinar,%' OR `talks`.`tags` LIKE '%brustein,%' OR `talks`.`tags` LIKE '%manasevit,%' OR `talks`.`tags` LIKE '%martin,%') AND `talks`.`published` = 'yes' AND
(
`talks`.`start` IS NULL OR
DATE(`talks`.`start`) <= CURDATE()
)
AND
(
`talks`.`end` IS NULL OR
DATE(`talks`.`end`) >= CURDATE()
)
ORDER BY RAND()
LIMIT 8
OFFSET 0
) AS `talks`
LEFT JOIN `ondemand_presenters_talks` AS `pivot`
ON (
`talks`.`id` = `pivot`.`talk_id`
)
LEFT JOIN `ondemand_presenters` AS `presenters`
ON (
`pivot`.`presenter_id` = `presenters`.`id`
)
LEFT JOIN `images`
ON (
`images`.`foreign_key` = `talks`.`id` AND
`images`.`linked_to` = 'ondemand_talk'
)
ORDER BY RAND()Connection name: default
Speed: 36.825 ms
Query analysis:
· Query: PRIMARY on <derived2> · Type: ALL · Rows: 8 (Using temporary; Using filesort)
· Query: PRIMARY on pivot · Possible keys: fk_ondemand_presenters_talks_talk · Key Used: fk_ondemand_presenters_talks_talk · Type: ref · Rows: 1
· Query: PRIMARY on presenters · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1
· Query: PRIMARY on images · Type: ALL · Rows: 28284 (Using where; Using join buffer (hash join))
· Query: DERIVED on talks · Possible keys: PRIMARY · Key Used: PRIMARY · Type: range · Rows: 1254 (Using where; Using temporary; Using filesort)
· Query: DERIVED on <derived3> · Possible keys: · Key Used: · Type: ref · Rows: 10
· Query: DERIVED on views · Possible keys: fk_ondemand_views_talk · Key Used: fk_ondemand_views_talk · Type: index · Rows: 2745 (Using index)
Call trace for this query:File: APPPATH/modules/ondemand/classes/repository/talk.php, line 281File: APPPATH/modules/ondemand/classes/repository/talk.php, line 200File: APPPATH/modules/ondemand/classes/repository/talk.php, line 129File: APPPATH/classes/model/base.php, line 923File: APPPATH/modules/ondemand/classes/controller/index.php, line 451File: APPPATH/modules/ondemand/classes/controller/index.php, line 52File: COREPATH/classes/request.php, line 476File: DOCROOT/index.php, line 142File: DOCROOT/index.php, line 239 |
SELECT
`talks`.*,
`presenters`.`id` AS `presenter_id`, `presenters`.`first_name` AS `presenter_first_name`, `presenters`.`last_name` AS `presenter_last_name`,
`images`.`id` AS `image_id`, `images`.`name` AS `image_name`, `images`.`orig_url` AS `image_orig_url`,
`images`.`base_url` AS `image_base_url`, `images`.`rel_paths` AS `image_rel_paths`, `images`.`filename` AS `image_filename`
FROM (
SELECT COALESCE(`views`.`view_count`, 0) AS `view_count`, `talks`.*
FROM `ondemand_talks` AS `talks`
LEFT JOIN (
SELECT `talk_id`, COUNT(`id`) AS `view_count`
FROM `ondemand_views` AS `views`
GROUP BY `talk_id`
) AS `views`
ON (
`views`.`talk_id` = `talks`.`id`
)
WHERE
`talks`.`id` NOT IN ('879') AND `talks`.`category` = 'policy' AND `talks`.`published` = 'yes' AND
(
`talks`.`start` IS NULL OR
DATE(`talks`.`start`) <= CURDATE()
)
AND
(
`talks`.`end` IS NULL OR
DATE(`talks`.`end`) >= CURDATE()
)
ORDER BY RAND()
LIMIT 8
OFFSET 0
) AS `talks`
LEFT JOIN `ondemand_presenters_talks` AS `pivot`
ON (
`talks`.`id` = `pivot`.`talk_id`
)
LEFT JOIN `ondemand_presenters` AS `presenters`
ON (
`pivot`.`presenter_id` = `presenters`.`id`
)
LEFT JOIN `images`
ON (
`images`.`foreign_key` = `talks`.`id` AND
`images`.`linked_to` = 'ondemand_talk'
)
ORDER BY RAND()Connection name: default
Speed: 32.833 ms
Query analysis:
· Query: PRIMARY on <derived2> · Type: ALL · Rows: 8 (Using temporary; Using filesort)
· Query: PRIMARY on pivot · Possible keys: fk_ondemand_presenters_talks_talk · Key Used: fk_ondemand_presenters_talks_talk · Type: ref · Rows: 1
· Query: PRIMARY on presenters · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1
· Query: PRIMARY on images · Type: ALL · Rows: 28284 (Using where; Using join buffer (hash join))
· Query: DERIVED on talks · Possible keys: PRIMARY,category · Key Used: category · Type: range · Rows: 178 (Using index condition; Using where; Using temporary; Using filesort)
· Query: DERIVED on <derived3> · Possible keys: · Key Used: · Type: ref · Rows: 10
· Query: DERIVED on views · Possible keys: fk_ondemand_views_talk · Key Used: fk_ondemand_views_talk · Type: index · Rows: 2745 (Using index)
Call trace for this query:File: APPPATH/modules/ondemand/classes/repository/talk.php, line 281File: APPPATH/modules/ondemand/classes/repository/talk.php, line 200File: APPPATH/modules/ondemand/classes/repository/talk.php, line 223File: APPPATH/modules/ondemand/classes/repository/talk.php, line 144File: APPPATH/classes/model/base.php, line 923File: APPPATH/modules/ondemand/classes/controller/index.php, line 451File: APPPATH/modules/ondemand/classes/controller/index.php, line 52File: 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.409 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/modules/ondemand/views/template.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: COREPATH/classes/response.php, line 382File: DOCROOT/index.php, line 250 |
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.241 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/modules/ondemand/views/template.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: COREPATH/classes/response.php, line 382File: DOCROOT/index.php, line 250 |
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.206 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/modules/ondemand/views/template.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: COREPATH/classes/response.php, line 382File: DOCROOT/index.php, line 250 |
SELECT `t0`.`name` AS `t0_c0`, `t0`.`items` AS `t0_c1`, `t0`.`class` AS `t0_c2`, `t0`.`before` AS `t0_c3`, `t0`.`after` AS `t0_c4`, `t0`.`css` AS `t0_c5`, `t0`.`js` AS `t0_c6`, `t0`.`main_banner` AS `t0_c7`, `t0`.`secondary_banner` AS `t0_c8`, `t0`.`background_image` AS `t0_c9`, `t0`.`background_color` AS `t0_c10`, `t0`.`extra` AS `t0_c11`, `t0`.`id` AS `t0_c12`, `t0`.`created_at` AS `t0_c13`, `t0`.`updated_at` AS `t0_c14` FROM `cms_menus` AS `t0` WHERE `t0`.`id` = 47 LIMIT 1Connection name: default
Speed: 0.191 ms
Query analysis:
· Query: SIMPLE on t0 · Possible keys: PRIMARY · Key Used: PRIMARY · Type: const · Rows: 1
Call trace for this query:File: PKGPATH/orm/classes/query.php, line 1564File: APPPATH/classes/query.php, line 19File: PKGPATH/orm/classes/query.php, line 1641File: PKGPATH/orm/classes/model.php, line 668File: APPPATH/modules/cms/classes/cms.php, line 496File: APPPATH/modules/cms/classes/cms.php, line 477File: APPPATH/views/templates/master/mobile-nav.php, line 107File: COREPATH/classes/view.php, line 258File: COREPATH/classes/view.php, line 274File: COREPATH/classes/view.php, line 681File: COREPATH/classes/view.php, line 227File: APPPATH/modules/ondemand/views/template.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: COREPATH/classes/response.php, line 382File: DOCROOT/index.php, line 250 |
SELECT `t0`.`name` AS `t0_c0`, `t0`.`items` AS `t0_c1`, `t0`.`class` AS `t0_c2`, `t0`.`before` AS `t0_c3`, `t0`.`after` AS `t0_c4`, `t0`.`css` AS `t0_c5`, `t0`.`js` AS `t0_c6`, `t0`.`main_banner` AS `t0_c7`, `t0`.`secondary_banner` AS `t0_c8`, `t0`.`background_image` AS `t0_c9`, `t0`.`background_color` AS `t0_c10`, `t0`.`extra` AS `t0_c11`, `t0`.`id` AS `t0_c12`, `t0`.`created_at` AS `t0_c13`, `t0`.`updated_at` AS `t0_c14` FROM `cms_menus` AS `t0` WHERE `t0`.`id` = 60 LIMIT 1Connection name: default
Speed: 0.191 ms
Query analysis:
· Query: SIMPLE on t0 · Possible keys: PRIMARY · Key Used: PRIMARY · Type: const · Rows: 1
Call trace for this query:File: PKGPATH/orm/classes/query.php, line 1564File: APPPATH/classes/query.php, line 19File: PKGPATH/orm/classes/query.php, line 1641File: PKGPATH/orm/classes/model.php, line 668File: APPPATH/modules/cms/classes/cms.php, line 496File: APPPATH/modules/cms/classes/cms.php, line 477File: APPPATH/views/templates/master/mobile-nav.php, line 119File: COREPATH/classes/view.php, line 258File: COREPATH/classes/view.php, line 274File: COREPATH/classes/view.php, line 681File: COREPATH/classes/view.php, line 227File: APPPATH/modules/ondemand/views/template.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: COREPATH/classes/response.php, line 382File: DOCROOT/index.php, line 250 |
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.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: 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/modules/ondemand/views/template.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: COREPATH/classes/response.php, line 382File: DOCROOT/index.php, line 250 |
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.209 ms
Query analysis:
· Query: SIMPLE on t0 · Possible keys: PRIMARY · Key Used: PRIMARY · Type: const · Rows: 1
Call trace for this query:File: PKGPATH/orm/classes/query.php, line 1564File: APPPATH/classes/query.php, line 19File: PKGPATH/orm/classes/query.php, line 1641File: PKGPATH/orm/classes/model.php, line 668File: APPPATH/modules/cms/classes/cms.php, line 496File: APPPATH/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/modules/ondemand/views/template.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: COREPATH/classes/response.php, line 382File: DOCROOT/index.php, line 250 |
SELECT `t0`.`name` AS `t0_c0`, `t0`.`items` AS `t0_c1`, `t0`.`class` AS `t0_c2`, `t0`.`before` AS `t0_c3`, `t0`.`after` AS `t0_c4`, `t0`.`css` AS `t0_c5`, `t0`.`js` AS `t0_c6`, `t0`.`main_banner` AS `t0_c7`, `t0`.`secondary_banner` AS `t0_c8`, `t0`.`background_image` AS `t0_c9`, `t0`.`background_color` AS `t0_c10`, `t0`.`extra` AS `t0_c11`, `t0`.`id` AS `t0_c12`, `t0`.`created_at` AS `t0_c13`, `t0`.`updated_at` AS `t0_c14` FROM `cms_menus` AS `t0` WHERE `t0`.`id` = 1 LIMIT 1Connection name: default
Speed: 0.209 ms
Query analysis:
· Query: SIMPLE on t0 · Possible keys: PRIMARY · Key Used: PRIMARY · Type: const · Rows: 1
Call trace for this query:File: PKGPATH/orm/classes/query.php, line 1564File: APPPATH/classes/query.php, line 19File: PKGPATH/orm/classes/query.php, line 1641File: PKGPATH/orm/classes/model.php, line 668File: APPPATH/modules/cms/classes/cms.php, line 496File: APPPATH/views/templates/master/sticky-header.php, line 128File: COREPATH/classes/view.php, line 258File: COREPATH/classes/view.php, line 274File: COREPATH/classes/view.php, line 681File: COREPATH/classes/view.php, line 227File: APPPATH/modules/ondemand/views/template.php, line 12File: COREPATH/classes/view.php, line 258File: COREPATH/classes/view.php, line 274File: COREPATH/classes/view.php, line 681File: COREPATH/classes/view.php, line 227File: COREPATH/classes/response.php, line 382File: DOCROOT/index.php, line 250 |
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.250 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/modules/ondemand/views/template.php, line 15File: COREPATH/classes/view.php, line 258File: COREPATH/classes/view.php, line 274File: COREPATH/classes/view.php, line 681File: COREPATH/classes/view.php, line 227File: COREPATH/classes/response.php, line 382File: DOCROOT/index.php, line 250 |
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.207 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/modules/ondemand/views/template.php, line 15File: COREPATH/classes/view.php, line 258File: COREPATH/classes/view.php, line 274File: COREPATH/classes/view.php, line 681File: COREPATH/classes/view.php, line 227File: COREPATH/classes/response.php, line 382File: DOCROOT/index.php, line 250 |
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.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 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/modules/ondemand/views/template.php, line 15File: COREPATH/classes/view.php, line 258File: COREPATH/classes/view.php, line 274File: COREPATH/classes/view.php, line 681File: COREPATH/classes/view.php, line 227File: COREPATH/classes/response.php, line 382File: DOCROOT/index.php, line 250 |
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.394 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/modules/ondemand/views/template.php, line 15File: COREPATH/classes/view.php, line 258File: COREPATH/classes/view.php, line 274File: COREPATH/classes/view.php, line 681File: COREPATH/classes/view.php, line 227File: COREPATH/classes/response.php, line 382File: DOCROOT/index.php, line 250 |
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: COREPATH/classes/view.php, line 258File: COREPATH/classes/view.php, line 274File: COREPATH/classes/view.php, line 681File: COREPATH/classes/view.php, line 227File: APPPATH/modules/ondemand/views/template.php, line 15File: COREPATH/classes/view.php, line 258File: COREPATH/classes/view.php, line 274File: COREPATH/classes/view.php, line 681File: COREPATH/classes/view.php, line 227File: COREPATH/classes/response.php, line 382File: DOCROOT/index.php, line 250 |
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.192 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/modules/ondemand/views/template.php, line 15File: COREPATH/classes/view.php, line 258File: COREPATH/classes/view.php, line 274File: COREPATH/classes/view.php, line 681File: COREPATH/classes/view.php, line 227File: COREPATH/classes/response.php, line 382File: DOCROOT/index.php, line 250 |
