SELECT `group`, `data` FROM `config` WHERE `group` LIKE 'Global::%'Connection name: default Speed: 0.503 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
ds_schools.id, ds_schools.code, ds_schools.lat, ds_schools.long, ds_schools.name,
ds_schools.state, ds_schools.year, ds_schools.category, ds_schools.city, ds_schools.path,
ds_demographics.grade_range_low, ds_demographics.grade_range_high, ds_demographics.urban_rural,
ds_demographics.population, ds_demographics.enrollment
FROM `ds_schools`
LEFT JOIN `ds_demographics`
ON ds_schools.code = ds_demographics.school_id
WHERE
ds_schools.published = 'yes' ORDER BY ds_schools.stateConnection name: default Speed: 8.673 ms Query analysis: · Query: SIMPLE on ds_schools · Type: ALL · Rows: 644 (Using where; Using filesort) · Query: SIMPLE on ds_demographics · Possible keys: school_id · Key Used: school_id · Type: ref · Rows: 1 Call trace for this query:File: APPPATH/modules/ds/classes/map.php, line 54File: APPPATH/modules/ds/classes/controller/index.php, line 43File: COREPATH/classes/request.php, line 476File: DOCROOT/index.php, line 142File: DOCROOT/index.php, line 239 |
SELECT COUNT(*) AS `total_rows` FROM (SELECT
ds_schools.id, ds_schools.code, ds_schools.lat, ds_schools.long, ds_schools.name,
ds_schools.state, ds_schools.year, ds_schools.category, ds_schools.city, ds_schools.path,
ds_demographics.grade_range_low, ds_demographics.grade_range_high, ds_demographics.urban_rural,
ds_demographics.population, ds_demographics.enrollment
FROM `ds_schools`
LEFT JOIN `ds_demographics`
ON ds_schools.code = ds_demographics.school_id
WHERE
ds_schools.published = 'yes' ) AS `counted_results`Connection name: default Speed: 2.587 ms Query analysis: · Query: SIMPLE on ds_schools · Type: ALL · Rows: 644 (Using where) · Query: SIMPLE on ds_demographics · Possible keys: school_id · Key Used: school_id · Type: ref · Rows: 1 (Using index) Call trace for this query:File: COREPATH/classes/db.php, line 361File: APPPATH/modules/ds/classes/map.php, line 56File: APPPATH/modules/ds/classes/controller/index.php, line 43File: COREPATH/classes/request.php, line 476File: DOCROOT/index.php, line 142File: DOCROOT/index.php, line 239 |
SELECT images.*
FROM ds_schools
JOIN (
SELECT * FROM `images`
WHERE
`type` = 'school_submitted' AND
`linked_to` = 'ds_school' AND
`foreign_key` IN ('2S7A', '7Q8H', '7C2J', '9P5Q', '2T3D', '6N2H', '9A6C', '6Y4F', '0E0X', '8Z7C', '1K8Q', '2C0D', '9E3B', '0K0A', '6V6C', '2Q8L', '3D8F', '2H1G', '4D3W', '7D7Q', '2R2S', '4Y1T', '8V4Y', '3M8Y', '9H1C', '5E6T', '4M9D', '2J8Y', '3K6B', '8X3C', '4X4A', '0K9Y', '7M3F', '2T1V', '9H4Y', '8D0M', '8Q6D', '8X8P', '4S8B', '1N0N', '0S3R', '5E1N', '6F7W', '3J8E', '5K8K', '7A6E', '1N5Z', '7P1Z', '8H3L', '2Q8C', '1L5A', '8U8U', '3Y3F', '2Q9A', '6T9T', '0M3F', '3P0L', '3Q5K', '3X0X', '3J6J', '0X0C', '8H2S', '4P7T', '9V7L', '5M1M', '1Q8A', '1H4Z', '4X9H', '8K3L', '0T8W', '5M6A', '1M3Z', '3V3W', '7P1S', '7F6B', '1S0A', '6S5Z', '2V6H', '8P6X', '8J0C', '6E3X', '4D7H', '4P7L', '5H5C', '3B1G', '6H5W', '6W0E', '3P2H', '0M7S', '1L7F', '6P3U', '9C9Z', '6Y8X', '7A9L', '9S3A', '0J2F', '3Z2B', '3U2V', '1W3E', '7K8K', '8G5G', '4G1P', '2C3N', '7D6F', '2U8H', '5P9J', '3L2Y', '7B3K', '6P0R', '2H9T', '5Y1V', '8C7W', '3W2Y', '6A7R', '9I9W', '9R4D', '6G9F', '6R3Q', '0H9Z', '4M5H', '8X3A', '0Z7Y', '4B5K', '3U6A', '4E1M', '7N5L', '2A6F', '9E1D', '5H7J', '1W9E', '0M5U', '7J6F', '2U5J', '5U2H', '2W4S', '0F5W', '6V4G', '2U2J', '9R2P', '5L5X', '8P2B', '6R0B', '5D6Q', '9K2H', '6W4N', '3F6Y', '3V1E', '1N2M', '2V9M', '9G6W', '1W1P', '0W0R', '8T3A', '5G7U', '2H0E', '2W9M', '0Q6C', '7M2R', '3Q7Q', '4V4A', '1E4Q', '6W8Q', '0Y9B', '7A5L', '1V3R', '2M1M', '0J6Q', '9P1F', '2U4S', '4L9X', '4X1F', '1T8G', '4Z2N', '6B1Q', '9N9X', '3C1S', '6E3F', '1P8M', '0F2Q', '4V5S', '5W4L', '2M4V', '0Z9P', '1Y8Q', '3M3C', '6Q4T', '4B6G', '9Y5N', '1A0P', '0R3K', '5K3Y', '7C6K', '7G9U', '5P5E', '9A4C', '8F9K', '9D4P', '0X9D', '8Z3U', '0E4F', '1A1W', '9K4Y', '0Y5C', '5C1Z', '0Y1V', '5S9F', '1S2R', '0F6Q', '4W4M', '3N0Z', '5P8U', '5P6G', '5R3T', '3W3V', '3X9W', '7H9T', '8M0Q', '7V7G', '1A4S', '6D4B', '5D8P', '0H8G', '5J4C', '8L5H', '0P8P', '4L2N', '5X9S', '5R8V', '2X2B', '6R7R', '7G9J', '4E4X', '9P4D', '5R7N', '2R3D', '4T3J', '6A6D', '6B2L', '7K7B', '5B9T', '7D4E', '2M9Y', '9F7G', '4P8A', '5P3Z', '1Y3P', '2K5J', '8G8C', '4B4N', '5I3X', '0V7B', '9P7M', '0M6W', '3C1R', '4C4B', '7Z3W', '0N9N', '5Q3C', '3Q9W', '4K5B', '2N7H', '2S8A', '9N0R', '6L4N', '2W1F', '4U0J', '7H8H', '8X0M', '8Y0Q', '3N5S', '2M6H', '2T1R', '0A7A', '7M2B', '6E9P', '0H2R', '1K8B', '4V7R', '2F9B', '4B7V', '0X4J', '8M0T', '3W1U', '4B2B', '7W0A', '7X6B', '1P4E', '6Y3E', '0T0X', '8Q3G', '3Q2R', '8M8C', '1J7X', '2E1M', '6C2R', '0W5H', '8Z1R', '8W5M', '0F3L', '0D3K', '0H5V', '2P1S', '2K1L', '4E6F', '5Z5X', '5H2Z', '6C0B', '8W7C', '2B3K', '7F5G', '3X1E', '6D8G', '0Y3Z', '0M8U', '4J1S', '1F1M', '2N0P', '7P7B', '7A6V', '1S4B', '9K9C', '4V4V', '2H7W', '7J6B', '8T6P', '1Y8Z', '5Y0B', '5Z5F', '3R9J', '6T4R', '5B1H', '0P7U', '2A1N', '3L9H', '1A5V', '9X7W', '5R5G', '1R9U', '1G0F', '9R8C', '8X5J', '3M3S', '3P7H', '9F1M', '1G8Y', '4X6U', '7N9F', '1B3C', '6V3K', '3G8C', '6M2F', '9K7F', '6I7X', '6P3D', '3J2A', '7V1L', '7A9T', '2K5G', '7D3V', '5E6E', '9D6X', '2C6V', '0P9W', '0H1W', '4Y5S', '6A3L', '7K4M', '2Z8Y', '4Q4X', '4D4C', '1E4M', '9W9Z', '5J6R', '5V9R', '1Z3D', '5Z0M', '9R3F', '1X6U', '3S4L', '2P1P', '7Q9K', '2L0F', '3K7L', '4X4Y', '8V0M', '0D9P', '6K3U', '2D0D', '4A5T', '0G3C', '5F9X', '9R9X', '8X5M', '3M4N', '7H6Z', '1L1C', '9C8U', '1J5N', '6W4L', '7M7Z', '8H0Q', '3M8V', '8V4T', '0Q4H', '4U7G', '2Z1Q', '4F6I', '9X0M', '4J3C', '3X8B', '4G6E', '8S3E', '0Z6S', '6A7P', '6L7G', '1X0U', '6S7G', '4W3M', '0D0D', '0F1E', '0W4H', '3G1J', '4J8E', '2N3S', '3M5U', '1E3D', '6J3Y', '9Q6K', '3X7S', '0M3Z', '6L5K', '7K0Q', '3C3A', '2A8B', '1N2T', '5F1J', '5D5N', '6P3J', '2K5A', '1D0S', '1S1X', '6Q4A', '7D5G', '4A9C', '7W9C', '5A2H', '5H1B', '2K3S', '7W0Z', '2R4Y', '4N7E', '6B3R', '1G4N', '2E1V', '5J3W', '3H6A', '3C3K', '1P1Z', '2Y6Q', '7E2U', '8F1V', '0N2T', '3A5A', '9S5G', '4T5H', '5E8Y', '3M6P', '2L2F', '5Q0T', '8W5H', '0V5M', '6H0B', '8B4R', '8T6Q', '8K4L', '2G3V', '9N0E', '5A3D', '3N2Q', '3K1H', '3J0F', '1P8Q', '6J5M', '3B8P', '9W5V', '9E2K', '1R2G', '8E3N', '7K7G', '5C5X', '2U5D', '0B9D', '6Y1X', '2E1H', '3G4H', '4U9P', '8W2W', '3N0D', '3S3K', '5D5Q', '7J0X', '3Z3R', '5I4C', '8A1S', '4N9G', '4T7R', '4N6D', '5B1T', '9M8F', '6J7X', '5Y4D', '2N1W', '7Z0K', '1M7C', '7L3P', '8H8A', '3Y2C', '4H9B', '5K0X', '4Q9K', '8Z2K', '5T4N', '2E2N', '9N8X', '2W7H', '3S1R', '1U5T', '8S4F', '7G3P', '4D1N', '9X5M', '2M9N', '9K6W', '0R2S', '9G7P', '1A4Y', '1U8X', '5A7N', '6D2G', '3T8Z', '3V8A', '7J9F', '1F0R', '8B8D', '4A3F', '0E9V', '0N4C', '2U8Y', '0T3F', '8B4L', '5W9H', '7B1J', '9W7G', '2E5M', '1N1X', '1T5F', '4D3Z', '0J4V', '1Z9X', '0Q6K', '9T5T', '9K6J', '7G3T', '4X1W', '7G6Z', '1B8F', '9L0V', '2K8R', '3A2A', '7V5Q', '6D2W', '6H8X', '7K7R', '0B7S', '1X9M', '2W5E', '1H5L', '5R5M', '8B4D', '5Q9C', '6M7J', '2X3D', '2W7V', '9U0X', '4X4V', '7X0Q', '8B2R', '6N9Z', '7P6T', '7W0D', '5U0N', '0Q1U', '2M4Q', '8K0M', '4V1M', '2A5D', '9G5M', '3F7W', '2P8T', '9H1F', '1V9F', '5Z3I', '8J2A', '2V2T', '8F1S', '5V2C', '3Q6S', '5Q8Y', '3S7E', '9A1W', '3Y8K', '2U7L', '8L1U', '5K8A', '1D1Z', '5X5N', '1V6C', '3W2U', '5M5Y', '7W2J', '6R3D', '5P1P', '2H9V', '0Z9Q', '2V5G', '4Z1R')
ORDER BY `data` DESC
) AS `images`
ON (
images.foreign_key = ds_schools.code
)
GROUP BY images.foreign_keyConnection name: default Speed: 35.335 ms Query analysis: · Query: SIMPLE on ds_schools · Possible keys: code · Key Used: code · Type: index · Rows: 644 (Using where; Using index; Using temporary) · Query: SIMPLE on images · Possible keys: type-foreign_key · Key Used: type-foreign_key · Type: ref · Rows: 1 (Using index condition; Using where) Call trace for this query:File: APPPATH/modules/ds/classes/map.php, line 87File: APPPATH/modules/ds/classes/controller/index.php, line 43File: COREPATH/classes/request.php, line 476File: DOCROOT/index.php, line 142File: DOCROOT/index.php, line 239 |
SELECT `year` FROM `ds_schools` ORDER BY `year` ASC LIMIT 1Connection name: default Speed: 0.302 ms Query analysis: · Query: SIMPLE on ds_schools · Key Used: year · Type: index · Rows: 1 (Using index) Call trace for this query:File: APPPATH/modules/ds/classes/map.php, line 119File: APPPATH/modules/ds/classes/controller/index.php, line 43File: COREPATH/classes/request.php, line 476File: DOCROOT/index.php, line 142File: DOCROOT/index.php, line 239 |
SELECT `year` FROM `ds_schools` ORDER BY `year` DESC LIMIT 1Connection name: default Speed: 0.145 ms Query analysis: · Query: SIMPLE on ds_schools · Key Used: year · Type: index · Rows: 1 (Backward index scan; Using index) Call trace for this query:File: APPPATH/modules/ds/classes/map.php, line 126File: APPPATH/modules/ds/classes/controller/index.php, line 43File: 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.282 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/ds/views/templates/index.php, line 279File: COREPATH/classes/view.php, line 258File: COREPATH/classes/view.php, line 274File: COREPATH/classes/view.php, line 681File: APPPATH/modules/ds/classes/controller/index.php, line 28File: 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.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 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/ds/views/templates/index.php, line 279File: COREPATH/classes/view.php, line 258File: COREPATH/classes/view.php, line 274File: COREPATH/classes/view.php, line 681File: APPPATH/modules/ds/classes/controller/index.php, line 28File: 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.194 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/ds/views/templates/index.php, line 279File: COREPATH/classes/view.php, line 258File: COREPATH/classes/view.php, line 274File: COREPATH/classes/view.php, line 681File: APPPATH/modules/ds/classes/controller/index.php, line 28File: 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.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: 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/ds/views/templates/index.php, line 279File: COREPATH/classes/view.php, line 258File: COREPATH/classes/view.php, line 274File: COREPATH/classes/view.php, line 681File: APPPATH/modules/ds/classes/controller/index.php, line 28File: 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.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: 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/ds/views/templates/index.php, line 279File: COREPATH/classes/view.php, line 258File: COREPATH/classes/view.php, line 274File: COREPATH/classes/view.php, line 681File: APPPATH/modules/ds/classes/controller/index.php, line 28File: 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.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 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/ds/views/templates/index.php, line 279File: COREPATH/classes/view.php, line 258File: COREPATH/classes/view.php, line 274File: COREPATH/classes/view.php, line 681File: APPPATH/modules/ds/classes/controller/index.php, line 28File: 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.195 ms Query analysis: · Query: SIMPLE on t0 · Possible keys: PRIMARY · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: PKGPATH/orm/classes/query.php, line 1564File: APPPATH/classes/query.php, line 19File: PKGPATH/orm/classes/query.php, line 1641File: 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/ds/views/templates/index.php, line 279File: COREPATH/classes/view.php, line 258File: COREPATH/classes/view.php, line 274File: COREPATH/classes/view.php, line 681File: APPPATH/modules/ds/classes/controller/index.php, line 28File: 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.205 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/ds/views/templates/index.php, line 282File: COREPATH/classes/view.php, line 258File: COREPATH/classes/view.php, line 274File: COREPATH/classes/view.php, line 681File: APPPATH/modules/ds/classes/controller/index.php, line 28File: 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` = 2987 LIMIT 1Connection name: default Speed: 0.239 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/modules/ds/views/templates/index.php, line 286File: COREPATH/classes/view.php, line 258File: COREPATH/classes/view.php, line 274File: COREPATH/classes/view.php, line 681File: APPPATH/modules/ds/classes/controller/index.php, line 28File: COREPATH/classes/request.php, line 478File: DOCROOT/index.php, line 142File: DOCROOT/index.php, line 239 |
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.307 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 201File: APPPATH/modules/ds/views/templates/index.php, line 286File: COREPATH/classes/view.php, line 258File: COREPATH/classes/view.php, line 274File: COREPATH/classes/view.php, line 681File: APPPATH/modules/ds/classes/controller/index.php, line 28File: COREPATH/classes/request.php, line 478File: DOCROOT/index.php, line 142File: DOCROOT/index.php, line 239 |
SELECT
ds_schools.id, ds_schools.code, ds_schools.lat, ds_schools.long, ds_schools.name,
ds_schools.state, ds_schools.year, ds_schools.category, ds_schools.city, ds_schools.path,
ds_demographics.grade_range_low, ds_demographics.grade_range_high, ds_demographics.urban_rural,
ds_demographics.population, ds_demographics.enrollment
FROM `ds_schools`
LEFT JOIN `ds_demographics`
ON ds_schools.code = ds_demographics.school_id
WHERE
ds_schools.published = 'yes' ORDER BY ds_schools.stateConnection name: default Speed: 5.976 ms · DUPLICATE Query analysis: · Query: SIMPLE on ds_schools · Type: ALL · Rows: 644 (Using where; Using filesort) · Query: SIMPLE on ds_demographics · Possible keys: school_id · Key Used: school_id · Type: ref · Rows: 1 Call trace for this query:File: APPPATH/modules/ds/classes/map.php, line 54File: APPPATH/modules/ds/views/templates/index.php, line 289File: COREPATH/classes/view.php, line 258File: COREPATH/classes/view.php, line 274File: COREPATH/classes/view.php, line 681File: APPPATH/modules/ds/classes/controller/index.php, line 28File: COREPATH/classes/request.php, line 478File: DOCROOT/index.php, line 142File: DOCROOT/index.php, line 239 |
SELECT COUNT(*) AS `total_rows` FROM (SELECT
ds_schools.id, ds_schools.code, ds_schools.lat, ds_schools.long, ds_schools.name,
ds_schools.state, ds_schools.year, ds_schools.category, ds_schools.city, ds_schools.path,
ds_demographics.grade_range_low, ds_demographics.grade_range_high, ds_demographics.urban_rural,
ds_demographics.population, ds_demographics.enrollment
FROM `ds_schools`
LEFT JOIN `ds_demographics`
ON ds_schools.code = ds_demographics.school_id
WHERE
ds_schools.published = 'yes' ) AS `counted_results`Connection name: default Speed: 2.230 ms · DUPLICATE Query analysis: · Query: SIMPLE on ds_schools · Type: ALL · Rows: 644 (Using where) · Query: SIMPLE on ds_demographics · Possible keys: school_id · Key Used: school_id · Type: ref · Rows: 1 (Using index) Call trace for this query:File: COREPATH/classes/db.php, line 361File: APPPATH/modules/ds/classes/map.php, line 56File: APPPATH/modules/ds/views/templates/index.php, line 289File: COREPATH/classes/view.php, line 258File: COREPATH/classes/view.php, line 274File: COREPATH/classes/view.php, line 681File: APPPATH/modules/ds/classes/controller/index.php, line 28File: COREPATH/classes/request.php, line 478File: DOCROOT/index.php, line 142File: DOCROOT/index.php, line 239 |
SELECT images.*
FROM ds_schools
JOIN (
SELECT * FROM `images`
WHERE
`type` = 'school_submitted' AND
`linked_to` = 'ds_school' AND
`foreign_key` IN ('2S7A', '7Q8H', '7C2J', '9P5Q', '2T3D', '6N2H', '9A6C', '6Y4F', '0E0X', '8Z7C', '1K8Q', '2C0D', '9E3B', '0K0A', '6V6C', '2Q8L', '3D8F', '2H1G', '4D3W', '7D7Q', '2R2S', '4Y1T', '8V4Y', '3M8Y', '9H1C', '5E6T', '4M9D', '2J8Y', '3K6B', '8X3C', '4X4A', '0K9Y', '7M3F', '2T1V', '9H4Y', '8D0M', '8Q6D', '8X8P', '4S8B', '1N0N', '0S3R', '5E1N', '6F7W', '3J8E', '5K8K', '7A6E', '1N5Z', '7P1Z', '8H3L', '2Q8C', '1L5A', '8U8U', '3Y3F', '2Q9A', '6T9T', '0M3F', '3P0L', '3Q5K', '3X0X', '3J6J', '0X0C', '8H2S', '4P7T', '9V7L', '5M1M', '1Q8A', '1H4Z', '4X9H', '8K3L', '0T8W', '5M6A', '1M3Z', '3V3W', '7P1S', '7F6B', '1S0A', '6S5Z', '2V6H', '8P6X', '8J0C', '6E3X', '4D7H', '4P7L', '5H5C', '3B1G', '6H5W', '6W0E', '3P2H', '0M7S', '1L7F', '6P3U', '9C9Z', '6Y8X', '7A9L', '9S3A', '0J2F', '3Z2B', '3U2V', '1W3E', '7K8K', '8G5G', '4G1P', '2C3N', '7D6F', '2U8H', '5P9J', '3L2Y', '7B3K', '6P0R', '2H9T', '5Y1V', '8C7W', '3W2Y', '6A7R', '9I9W', '9R4D', '6G9F', '6R3Q', '0H9Z', '4M5H', '8X3A', '0Z7Y', '4B5K', '3U6A', '4E1M', '7N5L', '2A6F', '9E1D', '5H7J', '1W9E', '0M5U', '7J6F', '2U5J', '5U2H', '2W4S', '0F5W', '6V4G', '2U2J', '9R2P', '5L5X', '8P2B', '6R0B', '5D6Q', '9K2H', '6W4N', '3F6Y', '3V1E', '1N2M', '2V9M', '9G6W', '1W1P', '0W0R', '8T3A', '5G7U', '2H0E', '2W9M', '0Q6C', '7M2R', '3Q7Q', '4V4A', '1E4Q', '6W8Q', '0Y9B', '7A5L', '1V3R', '2M1M', '0J6Q', '9P1F', '2U4S', '4L9X', '4X1F', '1T8G', '4Z2N', '6B1Q', '9N9X', '3C1S', '6E3F', '1P8M', '0F2Q', '4V5S', '5W4L', '2M4V', '0Z9P', '1Y8Q', '3M3C', '6Q4T', '4B6G', '9Y5N', '1A0P', '0R3K', '5K3Y', '7C6K', '7G9U', '5P5E', '9A4C', '8F9K', '9D4P', '0X9D', '8Z3U', '0E4F', '1A1W', '9K4Y', '0Y5C', '5C1Z', '0Y1V', '5S9F', '1S2R', '0F6Q', '4W4M', '3N0Z', '5P8U', '5P6G', '5R3T', '3W3V', '3X9W', '7H9T', '8M0Q', '7V7G', '1A4S', '6D4B', '5D8P', '0H8G', '5J4C', '8L5H', '0P8P', '4L2N', '5X9S', '5R8V', '2X2B', '6R7R', '7G9J', '4E4X', '9P4D', '5R7N', '2R3D', '4T3J', '6A6D', '6B2L', '7K7B', '5B9T', '7D4E', '2M9Y', '9F7G', '4P8A', '5P3Z', '1Y3P', '2K5J', '8G8C', '4B4N', '5I3X', '0V7B', '9P7M', '0M6W', '3C1R', '4C4B', '7Z3W', '0N9N', '5Q3C', '3Q9W', '4K5B', '2N7H', '2S8A', '9N0R', '6L4N', '2W1F', '4U0J', '7H8H', '8X0M', '8Y0Q', '3N5S', '2M6H', '2T1R', '0A7A', '7M2B', '6E9P', '0H2R', '1K8B', '4V7R', '2F9B', '4B7V', '0X4J', '8M0T', '3W1U', '4B2B', '7W0A', '7X6B', '1P4E', '6Y3E', '0T0X', '8Q3G', '3Q2R', '8M8C', '1J7X', '2E1M', '6C2R', '0W5H', '8Z1R', '8W5M', '0F3L', '0D3K', '0H5V', '2P1S', '2K1L', '4E6F', '5Z5X', '5H2Z', '6C0B', '8W7C', '2B3K', '7F5G', '3X1E', '6D8G', '0Y3Z', '0M8U', '4J1S', '1F1M', '2N0P', '7P7B', '7A6V', '1S4B', '9K9C', '4V4V', '2H7W', '7J6B', '8T6P', '1Y8Z', '5Y0B', '5Z5F', '3R9J', '6T4R', '5B1H', '0P7U', '2A1N', '3L9H', '1A5V', '9X7W', '5R5G', '1R9U', '1G0F', '9R8C', '8X5J', '3M3S', '3P7H', '9F1M', '1G8Y', '4X6U', '7N9F', '1B3C', '6V3K', '3G8C', '6M2F', '9K7F', '6I7X', '6P3D', '3J2A', '7V1L', '7A9T', '2K5G', '7D3V', '5E6E', '9D6X', '2C6V', '0P9W', '0H1W', '4Y5S', '6A3L', '7K4M', '2Z8Y', '4Q4X', '4D4C', '1E4M', '9W9Z', '5J6R', '5V9R', '1Z3D', '5Z0M', '9R3F', '1X6U', '3S4L', '2P1P', '7Q9K', '2L0F', '3K7L', '4X4Y', '8V0M', '0D9P', '6K3U', '2D0D', '4A5T', '0G3C', '5F9X', '9R9X', '8X5M', '3M4N', '7H6Z', '1L1C', '9C8U', '1J5N', '6W4L', '7M7Z', '8H0Q', '3M8V', '8V4T', '0Q4H', '4U7G', '2Z1Q', '4F6I', '9X0M', '4J3C', '3X8B', '4G6E', '8S3E', '0Z6S', '6A7P', '6L7G', '1X0U', '6S7G', '4W3M', '0D0D', '0F1E', '0W4H', '3G1J', '4J8E', '2N3S', '3M5U', '1E3D', '6J3Y', '9Q6K', '3X7S', '0M3Z', '6L5K', '7K0Q', '3C3A', '2A8B', '1N2T', '5F1J', '5D5N', '6P3J', '2K5A', '1D0S', '1S1X', '6Q4A', '7D5G', '4A9C', '7W9C', '5A2H', '5H1B', '2K3S', '7W0Z', '2R4Y', '4N7E', '6B3R', '1G4N', '2E1V', '5J3W', '3H6A', '3C3K', '1P1Z', '2Y6Q', '7E2U', '8F1V', '0N2T', '3A5A', '9S5G', '4T5H', '5E8Y', '3M6P', '2L2F', '5Q0T', '8W5H', '0V5M', '6H0B', '8B4R', '8T6Q', '8K4L', '2G3V', '9N0E', '5A3D', '3N2Q', '3K1H', '3J0F', '1P8Q', '6J5M', '3B8P', '9W5V', '9E2K', '1R2G', '8E3N', '7K7G', '5C5X', '2U5D', '0B9D', '6Y1X', '2E1H', '3G4H', '4U9P', '8W2W', '3N0D', '3S3K', '5D5Q', '7J0X', '3Z3R', '5I4C', '8A1S', '4N9G', '4T7R', '4N6D', '5B1T', '9M8F', '6J7X', '5Y4D', '2N1W', '7Z0K', '1M7C', '7L3P', '8H8A', '3Y2C', '4H9B', '5K0X', '4Q9K', '8Z2K', '5T4N', '2E2N', '9N8X', '2W7H', '3S1R', '1U5T', '8S4F', '7G3P', '4D1N', '9X5M', '2M9N', '9K6W', '0R2S', '9G7P', '1A4Y', '1U8X', '5A7N', '6D2G', '3T8Z', '3V8A', '7J9F', '1F0R', '8B8D', '4A3F', '0E9V', '0N4C', '2U8Y', '0T3F', '8B4L', '5W9H', '7B1J', '9W7G', '2E5M', '1N1X', '1T5F', '4D3Z', '0J4V', '1Z9X', '0Q6K', '9T5T', '9K6J', '7G3T', '4X1W', '7G6Z', '1B8F', '9L0V', '2K8R', '3A2A', '7V5Q', '6D2W', '6H8X', '7K7R', '0B7S', '1X9M', '2W5E', '1H5L', '5R5M', '8B4D', '5Q9C', '6M7J', '2X3D', '2W7V', '9U0X', '4X4V', '7X0Q', '8B2R', '6N9Z', '7P6T', '7W0D', '5U0N', '0Q1U', '2M4Q', '8K0M', '4V1M', '2A5D', '9G5M', '3F7W', '2P8T', '9H1F', '1V9F', '5Z3I', '8J2A', '2V2T', '8F1S', '5V2C', '3Q6S', '5Q8Y', '3S7E', '9A1W', '3Y8K', '2U7L', '8L1U', '5K8A', '1D1Z', '5X5N', '1V6C', '3W2U', '5M5Y', '7W2J', '6R3D', '5P1P', '2H9V', '0Z9Q', '2V5G', '4Z1R')
ORDER BY `data` DESC
) AS `images`
ON (
images.foreign_key = ds_schools.code
)
GROUP BY images.foreign_keyConnection name: default Speed: 34.569 ms · DUPLICATE Query analysis: · Query: SIMPLE on ds_schools · Possible keys: code · Key Used: code · Type: index · Rows: 644 (Using where; Using index; Using temporary) · Query: SIMPLE on images · Possible keys: type-foreign_key · Key Used: type-foreign_key · Type: ref · Rows: 1 (Using index condition; Using where) Call trace for this query:File: APPPATH/modules/ds/classes/map.php, line 87File: APPPATH/modules/ds/views/templates/index.php, line 289File: COREPATH/classes/view.php, line 258File: COREPATH/classes/view.php, line 274File: COREPATH/classes/view.php, line 681File: APPPATH/modules/ds/classes/controller/index.php, line 28File: COREPATH/classes/request.php, line 478File: DOCROOT/index.php, line 142File: DOCROOT/index.php, line 239 |
SELECT `year` FROM `ds_schools` ORDER BY `year` ASC LIMIT 1Connection name: default Speed: 0.316 ms · DUPLICATE Query analysis: · Query: SIMPLE on ds_schools · Key Used: year · Type: index · Rows: 1 (Using index) Call trace for this query:File: APPPATH/modules/ds/classes/map.php, line 119File: APPPATH/modules/ds/views/templates/index.php, line 289File: COREPATH/classes/view.php, line 258File: COREPATH/classes/view.php, line 274File: COREPATH/classes/view.php, line 681File: APPPATH/modules/ds/classes/controller/index.php, line 28File: COREPATH/classes/request.php, line 478File: DOCROOT/index.php, line 142File: DOCROOT/index.php, line 239 |
SELECT `year` FROM `ds_schools` ORDER BY `year` DESC LIMIT 1Connection name: default Speed: 0.144 ms · DUPLICATE Query analysis: · Query: SIMPLE on ds_schools · Key Used: year · Type: index · Rows: 1 (Backward index scan; Using index) Call trace for this query:File: APPPATH/modules/ds/classes/map.php, line 126File: APPPATH/modules/ds/views/templates/index.php, line 289File: COREPATH/classes/view.php, line 258File: COREPATH/classes/view.php, line 274File: COREPATH/classes/view.php, line 681File: APPPATH/modules/ds/classes/controller/index.php, line 28File: 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` = 26 LIMIT 1Connection name: default Speed: 0.309 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/ds/views/templates/index.php, line 333File: COREPATH/classes/view.php, line 258File: COREPATH/classes/view.php, line 274File: COREPATH/classes/view.php, line 681File: APPPATH/modules/ds/classes/controller/index.php, line 28File: 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` = 370 LIMIT 1Connection name: default Speed: 0.220 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/modules/ds/views/templates/index.php, line 333File: COREPATH/classes/view.php, line 258File: COREPATH/classes/view.php, line 274File: COREPATH/classes/view.php, line 681File: APPPATH/modules/ds/classes/controller/index.php, line 28File: COREPATH/classes/request.php, line 478File: DOCROOT/index.php, line 142File: DOCROOT/index.php, line 239 |
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` = '35' LIMIT 1Connection name: default Speed: 0.301 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 201File: APPPATH/modules/ds/views/templates/index.php, line 333File: COREPATH/classes/view.php, line 258File: COREPATH/classes/view.php, line 274File: COREPATH/classes/view.php, line 681File: APPPATH/modules/ds/classes/controller/index.php, line 28File: 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` = '27' LIMIT 1Connection name: default Speed: 0.208 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/model.php, line 668File: APPPATH/modules/cms/classes/cms.php, line 496File: APPPATH/modules/cms/classes/cms.php, line 237File: APPPATH/modules/ds/views/templates/index.php, line 333File: COREPATH/classes/view.php, line 258File: COREPATH/classes/view.php, line 274File: COREPATH/classes/view.php, line 681File: APPPATH/modules/ds/classes/controller/index.php, line 28File: 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` = 379 LIMIT 1Connection name: default Speed: 0.208 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: APPPATH/classes/model/base.php, line 941File: APPPATH/modules/cms/classes/cms.php, line 194File: APPPATH/modules/ds/views/templates/index.php, line 333File: COREPATH/classes/view.php, line 258File: COREPATH/classes/view.php, line 274File: COREPATH/classes/view.php, line 681File: APPPATH/modules/ds/classes/controller/index.php, line 28File: 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` = 347 LIMIT 1Connection name: default Speed: 0.226 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/modules/ds/views/templates/index.php, line 338File: COREPATH/classes/view.php, line 258File: COREPATH/classes/view.php, line 274File: COREPATH/classes/view.php, line 681File: APPPATH/modules/ds/classes/controller/index.php, line 28File: 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.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: 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/ds/views/templates/index.php, line 390File: COREPATH/classes/view.php, line 258File: COREPATH/classes/view.php, line 274File: COREPATH/classes/view.php, line 681File: APPPATH/modules/ds/classes/controller/index.php, line 28File: 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.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 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/ds/views/templates/index.php, line 390File: COREPATH/classes/view.php, line 258File: COREPATH/classes/view.php, line 274File: COREPATH/classes/view.php, line 681File: APPPATH/modules/ds/classes/controller/index.php, line 28File: 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.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 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/ds/views/templates/index.php, line 390File: COREPATH/classes/view.php, line 258File: COREPATH/classes/view.php, line 274File: COREPATH/classes/view.php, line 681File: APPPATH/modules/ds/classes/controller/index.php, line 28File: 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.194 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/ds/views/templates/index.php, line 390File: COREPATH/classes/view.php, line 258File: COREPATH/classes/view.php, line 274File: COREPATH/classes/view.php, line 681File: APPPATH/modules/ds/classes/controller/index.php, line 28File: 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.194 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/ds/views/templates/index.php, line 390File: COREPATH/classes/view.php, line 258File: COREPATH/classes/view.php, line 274File: COREPATH/classes/view.php, line 681File: APPPATH/modules/ds/classes/controller/index.php, line 28File: 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.194 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/ds/views/templates/index.php, line 390File: COREPATH/classes/view.php, line 258File: COREPATH/classes/view.php, line 274File: COREPATH/classes/view.php, line 681File: APPPATH/modules/ds/classes/controller/index.php, line 28File: COREPATH/classes/request.php, line 478File: DOCROOT/index.php, line 142File: DOCROOT/index.php, line 239 |