SELECT `group`, `data` FROM `config` WHERE `group` LIKE 'Global::%'Connection name: default
Speed: 0.697 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`.`slug` LIKE 'E25' AND `t0`.`published` = 'yes' LIMIT 1Connection name: default
Speed: 0.596 ms
Query analysis:
· Query: SIMPLE on t0 · Possible keys: slug,published · Key Used: slug · Type: range · Rows: 1 (Using index condition; 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/sched/classes/controller/index.php, line 66File: COREPATH/classes/request.php, line 476File: DOCROOT/index.php, line 142File: DOCROOT/index.php, line 239 |
SELECT `data` FROM `config` WHERE `group` = 'Sched::config' LIMIT 1Connection name: default
Speed: 2.255 ms
Query analysis:
· Query: SIMPLE on config · Possible keys: group · Key Used: group · Type: ref · Rows: 1
Call trace for this query:File: APPPATH/classes/conf.php, line 44File: APPPATH/classes/modulesingleton.php, line 29File: APPPATH/modules/sched/classes/sched.php, line 44File: APPPATH/modules/sched/classes/sched.php, line 97File: APPPATH/modules/sched/classes/controller/index.php, line 73File: COREPATH/classes/request.php, line 476File: DOCROOT/index.php, line 142File: DOCROOT/index.php, line 239 |
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`Connection name: default
Speed: 0.483 ms
Query analysis:
· Query: SIMPLE on t0 · Type: ALL · Rows: 62
Call trace for this query:File: PKGPATH/orm/classes/query.php, line 1564File: APPPATH/classes/query.php, line 19File: APPPATH/classes/modulesingleton.php, line 258File: APPPATH/modules/sched/classes/sched.php, line 52File: APPPATH/modules/sched/classes/sched.php, line 97File: APPPATH/modules/sched/classes/controller/index.php, line 73File: COREPATH/classes/request.php, line 476File: DOCROOT/index.php, line 142File: DOCROOT/index.php, line 239 |
SELECT DISTINCT `company_category` FROM `sched_exhibitors` WHERE `event_id` = '66' AND `company_category` <> '' ORDER BY `company_category` ASCConnection name: default
Speed: 1.373 ms
Query analysis:
· Query: SIMPLE on sched_exhibitors · Possible keys: fk_sched_exhibitors_event · Key Used: fk_sched_exhibitors_event · Type: ref · Rows: 80 (Using where; Using temporary; Using filesort)
Call trace for this query:File: APPPATH/modules/sched/classes/controller/index.php, line 1882File: APPPATH/modules/sched/classes/controller/index.php, line 104File: COREPATH/classes/request.php, line 476File: DOCROOT/index.php, line 142File: DOCROOT/index.php, line 239 |
SELECT DISTINCT `product_category` FROM `sched_exhibitors` WHERE `event_id` = '66' AND `product_category` <> '' ORDER BY `product_category` ASCConnection name: default
Speed: 0.834 ms
Query analysis:
· Query: SIMPLE on sched_exhibitors · Possible keys: fk_sched_exhibitors_event · Key Used: fk_sched_exhibitors_event · Type: ref · Rows: 80 (Using where; Using temporary; Using filesort)
Call trace for this query:File: APPPATH/modules/sched/classes/controller/index.php, line 1890File: APPPATH/modules/sched/classes/controller/index.php, line 104File: COREPATH/classes/request.php, line 476File: DOCROOT/index.php, line 142File: DOCROOT/index.php, line 239 |
SELECT COUNT(DISTINCT `t0`.`id`) AS count_result FROM `sched_exhibitors` AS `t0` WHERE `t0`.`published` = 'yes' AND `t0`.`event_id` = '66'Connection name: default
Speed: 0.913 ms
Query analysis:
· Query: SIMPLE on t0 · Possible keys: PRIMARY,custom_id,org_id,fk_sched_exhibitors_event · Key Used: fk_sched_exhibitors_event · Type: ref · Rows: 80 (Using where)
Call trace for this query:File: PKGPATH/orm/classes/query.php, line 1676File: APPPATH/classes/model/base.php, line 661File: APPPATH/modules/sched/classes/controller/index.php, line 1941File: APPPATH/modules/sched/classes/controller/index.php, line 104File: COREPATH/classes/request.php, line 476File: DOCROOT/index.php, line 142File: DOCROOT/index.php, line 239 |
SELECT COUNT(DISTINCT `t0`.`id`) AS count_result FROM `sched_exhibitors` AS `t0` LEFT JOIN `event_booths` AS `t1` ON (`t0`.`id` = `t1`.`exhibitor_id`) LEFT JOIN `images` AS `t2` ON (`t0`.`id` = `t2`.`foreign_key` AND `t2`.`linked_to` = 'sched_exhibitor' AND `t2`.`type` = 'logo') WHERE `t0`.`published` = 'yes' AND `t0`.`event_id` = '66'Connection name: default
Speed: 285.636 ms
Query analysis:
· Query: SIMPLE on t0 · Possible keys: fk_sched_exhibitors_event · Key Used: fk_sched_exhibitors_event · Type: ref · Rows: 80 (Using where)
· Query: SIMPLE on t1 · Possible keys: fk_event_booths_exhibitor · Key Used: fk_event_booths_exhibitor · Type: ref · Rows: 1 (Using index)
· Query: SIMPLE on t2 · Possible keys: type-foreign_key · Key Used: type-foreign_key · Type: ref · Rows: 2100 (Using where)
Call trace for this query:File: PKGPATH/orm/classes/query.php, line 1676File: APPPATH/classes/model/base.php, line 705File: APPPATH/modules/sched/classes/controller/index.php, line 1941File: APPPATH/modules/sched/classes/controller/index.php, line 104File: COREPATH/classes/request.php, line 476File: DOCROOT/index.php, line 142File: DOCROOT/index.php, line 239 |
SELECT `t0`.`data` AS `t0_c0`, `t0`.`id` AS `t0_c1`, `t0`.`custom_id` AS `t0_c2`, `t0`.`org_id` AS `t0_c3`, `t0`.`event_id` AS `t0_c4`, `t0`.`name` AS `t0_c5`, `t0`.`url` AS `t0_c6`, `t0`.`description` AS `t0_c7`, `t0`.`phone` AS `t0_c8`, `t0`.`address_1` AS `t0_c9`, `t0`.`address_2` AS `t0_c10`, `t0`.`city` AS `t0_c11`, `t0`.`zip` AS `t0_c12`, `t0`.`state` AS `t0_c13`, `t0`.`state_abbr` AS `t0_c14`, `t0`.`company_category` AS `t0_c15`, `t0`.`product_category` AS `t0_c16`, `t0`.`sponsorship_level` AS `t0_c17`, `t0`.`slug` AS `t0_c18`, `t0`.`published` AS `t0_c19`, `t0`.`deleted` AS `t0_c20`, `t0`.`created_at` AS `t0_c21`, `t0`.`updated_at` AS `t0_c22`, `t1`.`data` AS `t1_c0`, `t1`.`id` AS `t1_c1`, `t1`.`venue_id` AS `t1_c2`, `t1`.`event_id` AS `t1_c3`, `t1`.`exhibitor_id` AS `t1_c4`, `t1`.`number` AS `t1_c5`, `t1`.`name` AS `t1_c6`, `t1`.`description` AS `t1_c7`, `t1`.`price` AS `t1_c8`, `t1`.`created_at` AS `t1_c9`, `t1`.`updated_at` AS `t1_c10`, `t2`.`rel_paths` AS `t2_c0`, `t2`.`data` AS `t2_c1`, `t2`.`id` AS `t2_c2`, `t2`.`name` AS `t2_c3`, `t2`.`filename` AS `t2_c4`, `t2`.`orig_url` AS `t2_c5`, `t2`.`base_url` AS `t2_c6`, `t2`.`type` AS `t2_c7`, `t2`.`linked_to` AS `t2_c8`, `t2`.`event_code` AS `t2_c9`, `t2`.`foreign_key` AS `t2_c10`, `t2`.`extension` AS `t2_c11`, `t2`.`size` AS `t2_c12`, `t2`.`created_at` AS `t2_c13`, `t2`.`updated_at` AS `t2_c14` FROM `sched_exhibitors` AS `t0` LEFT JOIN `event_booths` AS `t1` ON (`t0`.`id` = `t1`.`exhibitor_id`) LEFT JOIN `images` AS `t2` ON (`t0`.`id` = `t2`.`foreign_key` AND `t2`.`linked_to` = 'sched_exhibitor' AND `t2`.`type` = 'logo') WHERE `t0`.`published` = 'yes' AND `t0`.`event_id` = '66' ORDER BY `t0`.`name` ASC LIMIT 1000 OFFSET 0Connection name: default
Speed: 388.692 ms
Query analysis:
· Query: SIMPLE on t0 · Possible keys: fk_sched_exhibitors_event · Key Used: fk_sched_exhibitors_event · Type: ref · Rows: 80 (Using where; Using filesort)
· Query: SIMPLE on t1 · Possible keys: fk_event_booths_exhibitor · Key Used: fk_event_booths_exhibitor · Type: ref · Rows: 1
· Query: SIMPLE on t2 · Possible keys: type-foreign_key · Key Used: type-foreign_key · Type: ref · Rows: 2100 (Using where)
Call trace for this query:File: PKGPATH/orm/classes/query.php, line 1564File: APPPATH/classes/query.php, line 19File: APPPATH/classes/model/base.php, line 754File: APPPATH/modules/sched/classes/controller/index.php, line 1941File: APPPATH/modules/sched/classes/controller/index.php, line 104File: COREPATH/classes/request.php, line 476File: DOCROOT/index.php, line 142File: DOCROOT/index.php, line 239 |
SELECT DISTINCT `exhibitors`.`id` FROM `sched_exhibitors` AS `exhibitors` JOIN `invoice_customers` AS `customers` ON (`customers`.`foreign_key` = `exhibitors`.`org_id`) JOIN `invoice_products` AS `products` ON (`products`.`customer_id` = `customers`.`id`) WHERE `products`.`type` = 'sponsorship' AND `products`.`status` = 'paid' AND `products`.`event_id` = '66' AND `exhibitors`.`event_id` = '66' AND `exhibitors`.`id` IN (1661, 1657, 1675, 1653, 1715, 1664, 1709, 1673, 1660, 1717, 1720, 1711, 1663, 1645, 1668, 1680, 1688, 1707, 1716, 1706, 1687, 1696, 1678, 1670, 1662, 1699, 1671, 1652, 1676, 1651, 1698, 1714, 1650, 1658, 1648, 1669, 1665, 1712, 1719, 1691, 1705, 1647, 1689, 1659, 1708, 1685, 1646, 1721, 1713, 1703, 1679, 1704, 1681, 1667, 1693, 1654, 1690, 1643, 1710, 1684, 1695, 1701, 1694, 1655, 1697, 1682, 1718, 1674, 1692, 1722, 1686, 1702, 1644, 1677, 1656, 1700, 1649, 1672, 1683, 1666) ORDER BY `products`.`price` DESC, `exhibitors`.`name` ASCConnection name: default
Speed: 2.144 ms
Query analysis:
· Query: SIMPLE on products · Possible keys: type_foreign,event id,fk_products_customer,type · Key Used: type_foreign · Type: ref · Rows: 14 (Using index condition; Using where; Using temporary; Using filesort)
· Query: SIMPLE on customers · Possible keys: PRIMARY,foreign_key · Key Used: PRIMARY · Type: eq_ref · Rows: 1 (Using where)
· Query: SIMPLE on exhibitors · Possible keys: PRIMARY,custom_id,org_id,fk_sched_exhibitors_event · Key Used: org_id · Type: ref · Rows: 2 (Using index condition; Using where)
Call trace for this query:File: APPPATH/modules/sched/classes/controller/index.php, line 1963File: APPPATH/modules/sched/classes/controller/index.php, line 104File: COREPATH/classes/request.php, line 476File: DOCROOT/index.php, line 142File: DOCROOT/index.php, line 239 |
SELECT `t0`.`data` AS `t0_c0`, `t0`.`id` AS `t0_c1`, `t0`.`custom_id` AS `t0_c2`, `t0`.`org_id` AS `t0_c3`, `t0`.`event_id` AS `t0_c4`, `t0`.`name` AS `t0_c5`, `t0`.`url` AS `t0_c6`, `t0`.`description` AS `t0_c7`, `t0`.`phone` AS `t0_c8`, `t0`.`address_1` AS `t0_c9`, `t0`.`address_2` AS `t0_c10`, `t0`.`city` AS `t0_c11`, `t0`.`zip` AS `t0_c12`, `t0`.`state` AS `t0_c13`, `t0`.`state_abbr` AS `t0_c14`, `t0`.`company_category` AS `t0_c15`, `t0`.`product_category` AS `t0_c16`, `t0`.`sponsorship_level` AS `t0_c17`, `t0`.`slug` AS `t0_c18`, `t0`.`published` AS `t0_c19`, `t0`.`deleted` AS `t0_c20`, `t0`.`created_at` AS `t0_c21`, `t0`.`updated_at` AS `t0_c22` FROM `sched_exhibitors` AS `t0` WHERE `t0`.`id` IN ('1659', '1682', '1715', '1691', '1704', '1686', '1677', '1717', '1713', '1672') ORDER BY FIELD (`id`, 1659, 1682, 1715, 1691, 1704, 1686, 1677, 1717, 1713, 1672) ASCConnection name: default
Speed: 0.372 ms
Query analysis:
· Query: SIMPLE on t0 · Possible keys: PRIMARY · Key Used: PRIMARY · Type: range · Rows: 10 (Using where; Using filesort)
Call trace for this query:File: PKGPATH/orm/classes/query.php, line 1564File: APPPATH/classes/query.php, line 19File: APPPATH/modules/sched/classes/controller/index.php, line 1972File: APPPATH/modules/sched/classes/controller/index.php, line 104File: 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.265 ms
Query analysis:
· Query: SIMPLE on t0 · Possible keys: PRIMARY · Key Used: PRIMARY · Type: const · Rows: 1
Call trace for this query:File: PKGPATH/orm/classes/query.php, line 1564File: APPPATH/classes/query.php, line 19File: PKGPATH/orm/classes/query.php, line 1641File: 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/sched/views/template.php, line 16File: COREPATH/classes/view.php, line 258File: COREPATH/classes/view.php, line 274File: COREPATH/classes/view.php, line 681File: APPPATH/classes/controller/base.php, line 103File: APPPATH/modules/sched/classes/controller/index.php, line 44File: 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.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: 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/sched/views/template.php, line 16File: COREPATH/classes/view.php, line 258File: COREPATH/classes/view.php, line 274File: COREPATH/classes/view.php, line 681File: APPPATH/classes/controller/base.php, line 103File: APPPATH/modules/sched/classes/controller/index.php, line 44File: 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.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: 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/sched/views/template.php, line 16File: COREPATH/classes/view.php, line 258File: COREPATH/classes/view.php, line 274File: COREPATH/classes/view.php, line 681File: APPPATH/classes/controller/base.php, line 103File: APPPATH/modules/sched/classes/controller/index.php, line 44File: 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.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 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/sched/views/template.php, line 16File: COREPATH/classes/view.php, line 258File: COREPATH/classes/view.php, line 274File: COREPATH/classes/view.php, line 681File: APPPATH/classes/controller/base.php, line 103File: APPPATH/modules/sched/classes/controller/index.php, line 44File: 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.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 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/sched/views/template.php, line 16File: COREPATH/classes/view.php, line 258File: COREPATH/classes/view.php, line 274File: COREPATH/classes/view.php, line 681File: APPPATH/classes/controller/base.php, line 103File: APPPATH/modules/sched/classes/controller/index.php, line 44File: 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.193 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/sched/views/template.php, line 16File: COREPATH/classes/view.php, line 258File: COREPATH/classes/view.php, line 274File: COREPATH/classes/view.php, line 681File: APPPATH/classes/controller/base.php, line 103File: APPPATH/modules/sched/classes/controller/index.php, line 44File: 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.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: 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/sched/views/template.php, line 16File: COREPATH/classes/view.php, line 258File: COREPATH/classes/view.php, line 274File: COREPATH/classes/view.php, line 681File: APPPATH/classes/controller/base.php, line 103File: APPPATH/modules/sched/classes/controller/index.php, line 44File: 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.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: 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/sched/views/template.php, line 19File: COREPATH/classes/view.php, line 258File: COREPATH/classes/view.php, line 274File: COREPATH/classes/view.php, line 681File: APPPATH/classes/controller/base.php, line 103File: APPPATH/modules/sched/classes/controller/index.php, line 44File: COREPATH/classes/request.php, line 478File: DOCROOT/index.php, line 142File: DOCROOT/index.php, line 239 |
SELECT id FROM `cms_menus` where extra = 'E25'Connection name: default
Speed: 0.225 ms
Query analysis:
· Query: SIMPLE on cms_menus · Type: ALL · Rows: 73 (Using where)
Call trace for this query:File: APPPATH/views/templates/conferences/t18/conference-top-menu.php, line 16File: COREPATH/classes/view.php, line 258File: COREPATH/classes/view.php, line 274File: COREPATH/classes/view.php, line 681File: COREPATH/classes/view.php, line 227File: APPPATH/modules/sched/views/sched-header.php, line 29File: COREPATH/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/sched/views/template.php, line 20File: COREPATH/classes/view.php, line 258File: COREPATH/classes/view.php, line 274File: COREPATH/classes/view.php, line 681File: APPPATH/classes/controller/base.php, line 103File: APPPATH/modules/sched/classes/controller/index.php, line 44File: 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` = '41' LIMIT 1Connection name: default
Speed: 0.210 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/conferences/t18/conference-top-menu.php, line 51File: COREPATH/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/sched/views/sched-header.php, line 29File: COREPATH/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/sched/views/template.php, line 20File: COREPATH/classes/view.php, line 258File: COREPATH/classes/view.php, line 274File: COREPATH/classes/view.php, line 681File: APPPATH/classes/controller/base.php, line 103File: APPPATH/modules/sched/classes/controller/index.php, line 44File: 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.533 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/sched/views/template.php, line 22File: COREPATH/classes/view.php, line 258File: COREPATH/classes/view.php, line 274File: COREPATH/classes/view.php, line 681File: APPPATH/classes/controller/base.php, line 103File: APPPATH/modules/sched/classes/controller/index.php, line 44File: 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.232 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/sched/views/template.php, line 22File: COREPATH/classes/view.php, line 258File: COREPATH/classes/view.php, line 274File: COREPATH/classes/view.php, line 681File: APPPATH/classes/controller/base.php, line 103File: APPPATH/modules/sched/classes/controller/index.php, line 44File: 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.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 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/sched/views/template.php, line 22File: COREPATH/classes/view.php, line 258File: COREPATH/classes/view.php, line 274File: COREPATH/classes/view.php, line 681File: APPPATH/classes/controller/base.php, line 103File: APPPATH/modules/sched/classes/controller/index.php, line 44File: 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.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 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/sched/views/template.php, line 22File: COREPATH/classes/view.php, line 258File: COREPATH/classes/view.php, line 274File: COREPATH/classes/view.php, line 681File: APPPATH/classes/controller/base.php, line 103File: APPPATH/modules/sched/classes/controller/index.php, line 44File: 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.196 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/sched/views/template.php, line 22File: COREPATH/classes/view.php, line 258File: COREPATH/classes/view.php, line 274File: COREPATH/classes/view.php, line 681File: APPPATH/classes/controller/base.php, line 103File: APPPATH/modules/sched/classes/controller/index.php, line 44File: 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.222 ms
Query analysis:
· Query: SIMPLE on t0 · Possible keys: PRIMARY · Key Used: PRIMARY · Type: const · Rows: 1
Call trace for this query:File: PKGPATH/orm/classes/query.php, line 1564File: APPPATH/classes/query.php, line 19File: PKGPATH/orm/classes/query.php, line 1641File: APPPATH/classes/model/base.php, line 941File: APPPATH/modules/cms/classes/cms.php, line 194File: APPPATH/views/templates/master/footer.php, line 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/sched/views/template.php, line 22File: COREPATH/classes/view.php, line 258File: COREPATH/classes/view.php, line 274File: COREPATH/classes/view.php, line 681File: APPPATH/classes/controller/base.php, line 103File: APPPATH/modules/sched/classes/controller/index.php, line 44File: COREPATH/classes/request.php, line 478File: DOCROOT/index.php, line 142File: DOCROOT/index.php, line 239 |
