At BC Colleges, we want to acknowledge the successes of our colleges, especially excellence in teaching and community building. We celebrate the many milestones, projects, collaborations and announcements from our colleges on our website, in our monthly newsletter, and throughout our social media channels.
Read about the latest news and activities happening at colleges throughout BC in this month’s What’s New at BC Colleges? e-newsletter.
College of the Rockies’ commencement ceremony will be extra special this year, as graduates from 2020 and 2021 have been invited to take part in the ceremony.
Darius Brons-Cooney’s summer job helping heavy-duty mechanics at Fabrite turned out to be life-changing, solidifying his decision to become a heavy-duty equipment technician. With that settled, he couldn’t wait to get started.
College of the Rockies will once again be offering a tuition-free Women in Trades Sampler program.
Growing up, Ann Swansburg was surrounded by entrepreneurs. Inspired by their passion, perseverance, and resilience, she was motivated to forge her own enterprising path.
College of the Rockies will launch its third-annual Giving Tuesday campaign on November 30, 2021. Aimed at encouraging local businesses, organizations, and individuals to give back to the community they love, this year’s campaign will focus on the Dean’s Health Education Technology Fund and the Cranbrook Rotary Centennial Bursary.
College of the Rockies will host a virtual Open House during the week of November 15 to 19, with a chance to win a $700 tuition voucher.
College of the Rockies will be launching work-integrated learning (WIL) as a component of many of their programs in summer 2022 and is inviting the regional business community to take part in the first phase, co-operative education.
On-campus instruction returns, with provincially mandated safety measures in place. After many months of alternative delivery, College of the Rockies’ is looking forward to welcoming students back to campus again, starting September 7.
Two virtual Commencement ceremonies held to honour graduates. Close to 900 College of the Rockies graduates were celebrated during a pair of virtual Commencement ceremonies on Friday, June 25.
Donated garden sheds were constructed by College’s Introduction to Construction students Two Cranbrook organizations, the Cranbrook Food Bank and Community Connections (organizers of the Community Garden) received the gift of a garden shed, thanks to students in College of the Rockies’ Introduction to Construction program.
No post data.
No querystring data.
| Query | Affected | Num. rows | Took (ms) | Actions |
|---|---|---|---|---|
| SELECT `BootstrapInstance`.`id`, `BootstrapInstance`.`name`, `BootstrapInstance`.`slug` FROM `bccolleges_database`.`prototype_instances` AS `BootstrapInstance` WHERE 1 = 1 | 8 | 8 | 0 | |
| SELECT `Permission`.`id`, `Permission`.`plugin`, `Permission`.`controller`, `Permission`.`action`, `Permission`.`resource_id`, `Permission`.`description`, `Permission`.`created`, `Permission`.`modified`, `Permission`.`deleted`, `Permission`.`deleted_date`, (CONCAT_WS(':', NULLIF(`Permission`.`plugin`, ''), NULLIF(`Permission`.`controller`, ''), NULLIF(`Permission`.`action`, ''), NULLIF(`Permission`.`resource_id`, ''))) AS `Permission__name` FROM `bccolleges_database`.`permissions` AS `Permission` WHERE `Permission`.`deleted` = '0' ORDER BY `Permission`.`plugin` ASC, `Permission`.`controller` ASC, `Permission`.`action` ASC, `Permission`.`resource_id` ASC | 79 | 79 | 0 | |
| SELECT `Group`.`id`, `Group`.`name`, `Group`.`created`, `Group`.`modified`, `Group`.`login_redirect`, `Group`.`rank`, `Group`.`deleted`, `Group`.`deleted_date` FROM `bccolleges_database`.`groups` AS `Group` WHERE `Group`.`name` = 'Unregistered' AND `Group`.`deleted` = '0' ORDER BY `Group`.`rank` ASC, `Group`.`id` ASC, `Group`.`rank` ASC LIMIT 1 | 0 | 0 | 0 | |
| SELECT `BlogTag`.`id`, `BlogTag`.`name`, `BlogTag`.`slug`, `BlogTag`.`created`, `BlogTag`.`modified`, `BlogTag`.`deleted`, `BlogTag`.`deleted_date` FROM `bccolleges_database`.`blog_tags` AS `BlogTag` WHERE `BlogTag`.`slug` = 'college-of-the-rockies-skilled-workforce' AND `BlogTag`.`deleted` = '0' LIMIT 1 | 1 | 1 | 0 | |
| SELECT `BlogTag`.`id`, `BlogTag`.`name`, `BlogTag`.`slug`, `BlogTag`.`created`, `BlogTag`.`modified`, `BlogTag`.`deleted`, `BlogTag`.`deleted_date` FROM `bccolleges_database`.`blog_tags` AS `BlogTag` WHERE `BlogTag`.`slug` = 'college-of-the-rockies-skilled-workforce' AND `BlogTag`.`deleted` = '0' LIMIT 1 | 1 | 1 | 0 | |
| SELECT `BlogPost`.`id`, `BlogPost`.`user_id`, `BlogPost`.`author`, `BlogPost`.`title`, `BlogPost`.`slug`, `BlogPost`.`url`, `BlogPost`.`summary`, `BlogPost`.`body`, `BlogPost`.`allow_commenting`, `BlogPost`.`sticky`, `BlogPost`.`created`, `BlogPost`.`modified`, `BlogPost`.`deleted`, `BlogPost`.`deleted_date`, `BlogPost`.`rank`, `User`.`id`, `User`.`email_address`, `User`.`password`, `User`.`active`, `User`.`created`, `User`.`modified`, `User`.`first_name`, `User`.`last_name`, `User`.`company_name`, `User`.`address`, `User`.`address_two`, `User`.`city`, `User`.`province_state`, `User`.`postal_zip`, `User`.`phone`, `User`.`fax`, `User`.`website`, `User`.`country_id`, `User`.`last_login`, `User`.`admin_menu_order`, `User`.`deleted`, `User`.`deleted_date`, (CONCAT(`User`.`first_name`, ' ', `User`.`last_name`)) AS `User__full_name`, (IF( `User`.`first_name` != '' AND `User`.`last_name` != '' AND `User`.`email_address` != '', CONCAT(`User`.`last_name`, ', ', `User`.`first_name`, ' ', `User`.`email_address`) , IF(`User`.`first_name` != '' AND `User`.`email_address` != '', CONCAT(`User`.`first_name`, ' ', `User`.`email_address`) , IF(`User`.`last_name` != '' AND `User`.`email_address` != '', CONCAT(`User`.`last_name`, ' ', `User`.`email_address`) , `User`.`email_address` )))) AS `User__surname_firstname_email`, `PublishingInformation`.`id`, `PublishingInformation`.`created`, `PublishingInformation`.`modified`, `PublishingInformation`.`model`, `PublishingInformation`.`foreign_key`, `PublishingInformation`.`start`, `PublishingInformation`.`end`, `PublishingInformation`.`published` FROM `bccolleges_database`.`blog_posts` AS `BlogPost` INNER JOIN `bccolleges_database`.`blog_post_tags` AS `BlogPostTags` ON (`BlogPost`.`id` = `BlogPostTags`.`blog_post_id`) INNER JOIN `bccolleges_database`.`blog_tags` AS `BlogTag` ON (`BlogPostTags`.`blog_tag_id` = `BlogTag`.`id`) LEFT JOIN `bccolleges_database`.`users` AS `User` ON (`BlogPost`.`user_id` = `User`.`id`) LEFT JOIN `bccolleges_database`.`publishing_information` AS `PublishingInformation` ON (`PublishingInformation`.`foreign_key` = `BlogPost`.`id` AND `PublishingInformation`.`model` = 'BlogPost') WHERE `BlogPostTags`.`blog_tag_id` = '22' AND `BlogPost`.`deleted` = '0' AND `PublishingInformation`.`published` = '1' AND `PublishingInformation`.`start` <= '2022-05-17 00:24:33' AND ((`PublishingInformation`.`end` IS NULL) OR (`PublishingInformation`.`end` > '2022-05-17 00:24:33')) GROUP BY `BlogPost`.`id` ORDER BY `BlogPost`.`sticky` desc, `PublishingInformation`.`start` DESC LIMIT 10 | 10 | 10 | 2 | maybe slow |
| SELECT `Image`.`id`, `Image`.`model`, `Image`.`foreign_key`, `Image`.`dirname`, `Image`.`basename`, `Image`.`checksum`, `Image`.`alternative`, `Image`.`group`, `Image`.`created`, `Image`.`modified`, `Image`.`rank`, `Image`.`deleted`, `Image`.`deleted_date`, (CONCAT_WS("/", dirname, basename)) AS `Image__path` FROM `bccolleges_database`.`attachments` AS `Image` WHERE `Image`.`model` = 'BlogPost' AND `Image`.`group` = 'Image' AND `Image`.`foreign_key` IN (15972, 15982, 15958, 15943, 15938, 15934, 15917, 15910, 15901, 15883) ORDER BY `Image`.`rank` ASC, `Image`.`id` ASC | 0 | 0 | 0 | |
| SELECT `MetaValue`.`id`, `MetaValue`.`created`, `MetaValue`.`modified`, `MetaValue`.`model`, `MetaValue`.`foreign_key`, `MetaValue`.`meta_key_id`, `MetaValue`.`val` FROM `bccolleges_database`.`meta_values` AS `MetaValue` WHERE `MetaValue`.`model` = 'BlogPost' AND `MetaValue`.`foreign_key` IN (15972, 15982, 15958, 15943, 15938, 15934, 15917, 15910, 15901, 15883) | 0 | 0 | 0 | |
| SELECT `BlogCategory`.`id`, `BlogCategory`.`parent_id`, `BlogCategory`.`lft`, `BlogCategory`.`rght`, `BlogCategory`.`name`, `BlogCategory`.`slug`, `BlogCategory`.`created`, `BlogCategory`.`modified`, `BlogCategory`.`deleted`, `BlogCategory`.`deleted_date`, `BlogPostCategory`.`id`, `BlogPostCategory`.`blog_category_id`, `BlogPostCategory`.`blog_post_id` FROM `bccolleges_database`.`blog_categories` AS `BlogCategory` JOIN `bccolleges_database`.`blog_post_categories` AS `BlogPostCategory` ON (`BlogPostCategory`.`blog_post_id` IN (15972, 15982, 15958, 15943, 15938, 15934, 15917, 15910, 15901, 15883) AND `BlogPostCategory`.`blog_category_id` = `BlogCategory`.`id`) | 10 | 10 | 0 | |
| SELECT `BlogTag`.`id`, `BlogTag`.`name`, `BlogTag`.`slug`, `BlogTag`.`created`, `BlogTag`.`modified`, `BlogTag`.`deleted`, `BlogTag`.`deleted_date`, `BlogPostTag`.`id`, `BlogPostTag`.`blog_tag_id`, `BlogPostTag`.`blog_post_id` FROM `bccolleges_database`.`blog_tags` AS `BlogTag` JOIN `bccolleges_database`.`blog_post_tags` AS `BlogPostTag` ON (`BlogPostTag`.`blog_post_id` IN (15972, 15982, 15958, 15943, 15938, 15934, 15917, 15910, 15901, 15883) AND `BlogPostTag`.`blog_tag_id` = `BlogTag`.`id`) | 10 | 10 | 1 | maybe slow |
| SELECT COUNT(*) AS `count` FROM `bccolleges_database`.`blog_posts` AS `BlogPost` INNER JOIN `bccolleges_database`.`blog_post_tags` AS `BlogPostTags` ON (`BlogPost`.`id` = `BlogPostTags`.`blog_post_id`) INNER JOIN `bccolleges_database`.`blog_tags` AS `BlogTag` ON (`BlogPostTags`.`blog_tag_id` = `BlogTag`.`id`) LEFT JOIN `bccolleges_database`.`users` AS `User` ON (`BlogPost`.`user_id` = `User`.`id`) LEFT JOIN `bccolleges_database`.`publishing_information` AS `PublishingInformation` ON (`PublishingInformation`.`foreign_key` = `BlogPost`.`id` AND `PublishingInformation`.`model` = 'BlogPost') WHERE `BlogPostTags`.`blog_tag_id` = '22' AND `BlogPost`.`deleted` = '0' AND `PublishingInformation`.`published` = '1' AND `PublishingInformation`.`start` <= '2022-05-17 00:24:33' AND ((`PublishingInformation`.`end` IS NULL) OR (`PublishingInformation`.`end` > '2022-05-17 00:24:33')) GROUP BY `BlogPost`.`id` LIMIT 10 | 10 | 10 | 1 | maybe slow |
| SELECT `Page`.`id`, `Page`.`created`, `Page`.`modified`, `Page`.`internal_name`, `Page`.`title`, `Page`.`page_heading`, `Page`.`content`, `Page`.`slug`, `Page`.`path`, `Page`.`parent_id`, `Page`.`lft`, `Page`.`rght`, `Page`.`layout`, `Page`.`plugin`, `Page`.`controller`, `Page`.`action`, `Page`.`extra`, `Page`.`protected`, `Page`.`exclude_sitemap`, `Page`.`deleted`, `Page`.`deleted_date`, `Page`.`password`, `Page`.`published`, `Page`.`extra_header_code`, `Page`.`extra_footer_code`, `Page`.`override_title_format`, `Page`.`super_admin`, (CONCAT_WS('/', NULLIF(`Page`.`plugin`, ''), NULLIF(`Page`.`controller`, ''), NULLIF(`Page`.`action`, ''), NULLIF(`Page`.`extra`, ''))) AS `Page__action_map` FROM `bccolleges_database`.`pages` AS `Page` WHERE `controller` = 'blog_posts' AND `action` = 'index' AND `Page`.`deleted` = '0' LIMIT 1 | 1 | 1 | 0 | |
| SELECT `CustomFieldValue`.`id`, `CustomFieldValue`.`foreign_key`, `CustomFieldValue`.`model`, `CustomFieldValue`.`custom_field_id`, `CustomFieldValue`.`key`, `CustomFieldValue`.`val`, `CustomFieldValue`.`type` FROM `bccolleges_database`.`custom_field_values` AS `CustomFieldValue` WHERE `CustomFieldValue`.`model` = 'Page' AND `CustomFieldValue`.`foreign_key` = (14) | 1 | 1 | 0 | |
| SELECT `MetaValue`.`id`, `MetaValue`.`created`, `MetaValue`.`modified`, `MetaValue`.`model`, `MetaValue`.`foreign_key`, `MetaValue`.`meta_key_id`, `MetaValue`.`val` FROM `bccolleges_database`.`meta_values` AS `MetaValue` WHERE `MetaValue`.`model` = 'Page' AND `MetaValue`.`foreign_key` = (14) | 5 | 5 | 0 | |
| SELECT `MetaKey`.`id`, `MetaKey`.`created`, `MetaKey`.`modified`, `MetaKey`.`name`, `MetaKey`.`type`, `MetaKey`.`default`, `MetaKey`.`rank`, `MetaKey`.`allow_default` FROM `bccolleges_database`.`meta_keys` AS `MetaKey` WHERE `MetaKey`.`name` = 'og:image' ORDER BY `MetaKey`.`rank` ASC LIMIT 1 | 1 | 1 | 0 | |
| SELECT `Setting`.`id`, `Setting`.`created`, `Setting`.`modified`, `Setting`.`key`, `Setting`.`value`, `Setting`.`title`, `Setting`.`description`, `Setting`.`type`, `Setting`.`editable`, `Setting`.`super_admin`, `Setting`.`options`, `Setting`.`method`, `Setting`.`display`, (REPLACE(CONCAT(UPPER(SUBSTRING(SUBSTRING_INDEX(`Setting`.`key`, '.', -1), 1, 1)), LOWER(SUBSTRING(SUBSTRING_INDEX(`Setting`.`key`, '.', -1) FROM 2))), '_', ' ')) AS `Setting__tinyMceOption` FROM `bccolleges_database`.`settings` AS `Setting` WHERE `Setting`.`key` = 'Blog.commenting_disabled' LIMIT 1 | 1 | 1 | 0 | |
| SELECT `CmsPlugin`.`id`, `CmsPlugin`.`created`, `CmsPlugin`.`modified`, `CmsPlugin`.`name`, `CmsPlugin`.`alias`, `CmsPlugin`.`slug`, `CmsPlugin`.`description`, `CmsPlugin`.`active`, `CmsPlugin`.`layout`, `CmsPlugin`.`theme`, `CmsPlugin`.`internal`, `CmsPlugin`.`schema_version`, `CmsPlugin`.`core` FROM `bccolleges_database`.`installed_plugins` AS `CmsPlugin` WHERE `name` = 'Responsive' LIMIT 1 | 1 | 1 | 0 | |
| SELECT `AttachmentVersion`.`id`, `AttachmentVersion`.`created`, `AttachmentVersion`.`modified`, `AttachmentVersion`.`model`, `AttachmentVersion`.`foreign_key`, `AttachmentVersion`.`group`, `AttachmentVersion`.`name`, `AttachmentVersion`.`type`, `AttachmentVersion`.`convert`, `AttachmentVersion`.`width`, `AttachmentVersion`.`height`, `AttachmentVersion`.`bgcolour`, `AttachmentVersion`.`gravity`, `AttachmentVersion`.`deleted`, `AttachmentVersion`.`deleted_date` FROM `bccolleges_database`.`attachment_versions` AS `AttachmentVersion` WHERE `AttachmentVersion`.`deleted` = '0' | 89 | 89 | 0 | |
| SELECT `Setting`.`key`, (REPLACE(CONCAT(UPPER(SUBSTRING(SUBSTRING_INDEX(`Setting`.`key`, '.', -1), 1, 1)), LOWER(SUBSTRING(SUBSTRING_INDEX(`Setting`.`key`, '.', -1) FROM 2))), '_', ' ')) AS `Setting__tinyMceOption` FROM `bccolleges_database`.`settings` AS `Setting` WHERE `Setting`.`key` LIKE 'Site.Contact.%' AND `Setting`.`value` != '' | 7 | 7 | 0 | |
| SELECT `ContentBlock`.`id`, `ContentBlock`.`name` FROM `bccolleges_database`.`content_blocks` AS `ContentBlock` LEFT JOIN `bccolleges_database`.`publishing_information` AS `PublishingInformation` ON (`PublishingInformation`.`foreign_key` = `ContentBlock`.`id` AND `PublishingInformation`.`model` = 'ContentBlock') WHERE `ContentBlock`.`deleted` = '0' AND `PublishingInformation`.`published` = '1' AND `PublishingInformation`.`start` <= '2022-05-17 00:24:33' AND ((`PublishingInformation`.`end` IS NULL) OR (`PublishingInformation`.`end` > '2022-05-17 00:24:33')) | 1 | 1 | 0 | |
| SELECT `EmailForm`.`id`, `EmailForm`.`name` FROM `bccolleges_database`.`email_forms` AS `EmailForm` LEFT JOIN `bccolleges_database`.`publishing_information` AS `PublishingInformation` ON (`PublishingInformation`.`foreign_key` = `EmailForm`.`id` AND `PublishingInformation`.`model` = 'EmailForm') WHERE `EmailForm`.`super_admin` = '0' AND `PublishingInformation`.`published` = '1' AND `PublishingInformation`.`start` <= '2022-05-17 00:24:33' AND ((`PublishingInformation`.`end` IS NULL) OR (`PublishingInformation`.`end` > '2022-05-17 00:24:33')) AND `EmailForm`.`deleted` = '0' ORDER BY `PublishingInformation`.`start` DESC | 2 | 2 | 0 | |
| SELECT `Gallery`.`id`, `Gallery`.`name` FROM `bccolleges_database`.`galleries` AS `Gallery` LEFT JOIN `bccolleges_database`.`publishing_information` AS `PublishingInformation` ON (`PublishingInformation`.`foreign_key` = `Gallery`.`id` AND `PublishingInformation`.`model` = 'Gallery') WHERE `PublishingInformation`.`published` = '1' AND `PublishingInformation`.`start` <= '2022-05-17 00:24:33' AND ((`PublishingInformation`.`end` IS NULL) OR (`PublishingInformation`.`end` > '2022-05-17 00:24:33')) AND `Gallery`.`deleted` = '0' ORDER BY `PublishingInformation`.`start` DESC | 5 | 5 | 0 | |
| SELECT `PrototypeInstance`.`id`, `PrototypeInstance`.`name`, `PrototypeInstance`.`description`, `PrototypeInstance`.`slug`, `PrototypeInstance`.`created`, `PrototypeInstance`.`modified`, `PrototypeInstance`.`use_categories`, `PrototypeInstance`.`public`, `PrototypeInstance`.`footer_text`, `PrototypeInstance`.`layout`, `PrototypeInstance`.`item_order`, `PrototypeInstance`.`allow_instance_view`, `PrototypeInstance`.`allow_category_views`, `PrototypeInstance`.`allow_item_views`, `PrototypeInstance`.`item_image_type`, `PrototypeInstance`.`item_document_type`, `PrototypeInstance`.`category_image_type`, `PrototypeInstance`.`category_document_type`, `PrototypeInstance`.`item_summary_pagination`, `PrototypeInstance`.`item_summary_pagination_limit`, `PrototypeInstance`.`use_featured_items`, `PrototypeInstance`.`all_items_featured`, `PrototypeInstance`.`number_of_featured_items`, `PrototypeInstance`.`autoload_featured_items_in_layouts`, `PrototypeInstance`.`deleted`, `PrototypeInstance`.`deleted_date`, `PrototypeInstance`.`name_field_label`, `PrototypeInstance`.`head_title`, `PrototypeInstance`.`category_changefreq`, `PrototypeInstance`.`item_changefreq`, `PublishingInformation`.`id`, `PublishingInformation`.`created`, `PublishingInformation`.`modified`, `PublishingInformation`.`model`, `PublishingInformation`.`foreign_key`, `PublishingInformation`.`start`, `PublishingInformation`.`end`, `PublishingInformation`.`published` FROM `bccolleges_database`.`prototype_instances` AS `PrototypeInstance` LEFT JOIN `bccolleges_database`.`publishing_information` AS `PublishingInformation` ON (`PublishingInformation`.`foreign_key` = `PrototypeInstance`.`id` AND `PublishingInformation`.`model` = 'PrototypeInstance') WHERE `PrototypeInstance`.`deleted` = '0' | 7 | 7 | 0 | |
| SELECT `MetaValue`.`id`, `MetaValue`.`created`, `MetaValue`.`modified`, `MetaValue`.`model`, `MetaValue`.`foreign_key`, `MetaValue`.`meta_key_id`, `MetaValue`.`val` FROM `bccolleges_database`.`meta_values` AS `MetaValue` WHERE `MetaValue`.`model` = 'PrototypeInstance' AND `MetaValue`.`foreign_key` IN (2, 3, 4, 5, 6, 7, 8) | 35 | 35 | 0 | |
| SELECT `HeaderSlideshowImage`.`id`, `HeaderSlideshowImage`.`model`, `HeaderSlideshowImage`.`foreign_key`, `HeaderSlideshowImage`.`dirname`, `HeaderSlideshowImage`.`basename`, `HeaderSlideshowImage`.`checksum`, `HeaderSlideshowImage`.`alternative`, `HeaderSlideshowImage`.`group`, `HeaderSlideshowImage`.`created`, `HeaderSlideshowImage`.`modified`, `HeaderSlideshowImage`.`rank`, `HeaderSlideshowImage`.`deleted`, `HeaderSlideshowImage`.`deleted_date`, (CONCAT_WS("/", dirname, basename)) AS `HeaderSlideshowImage__path` FROM `bccolleges_database`.`attachments` AS `HeaderSlideshowImage` WHERE `model` = 'InstalledPlugin' AND `foreign_key` = 28 AND `group` = 'Header Slideshow' ORDER BY `HeaderSlideshowImage`.`rank` ASC, `HeaderSlideshowImage`.`rank` ASC | 5 | 5 | 0 | |
| SELECT `CustomFieldValue`.`id`, `CustomFieldValue`.`foreign_key`, `CustomFieldValue`.`model`, `CustomFieldValue`.`custom_field_id`, `CustomFieldValue`.`key`, `CustomFieldValue`.`val`, `CustomFieldValue`.`type` FROM `bccolleges_database`.`custom_field_values` AS `CustomFieldValue` WHERE `CustomFieldValue`.`model` = 'HeaderSlideshowImage' AND `CustomFieldValue`.`foreign_key` IN (728, 179, 729, 176, 180) | 0 | 0 | 0 | |
| SELECT `Setting`.`id`, `Setting`.`created`, `Setting`.`modified`, `Setting`.`key`, `Setting`.`value`, `Setting`.`title`, `Setting`.`description`, `Setting`.`type`, `Setting`.`editable`, `Setting`.`super_admin`, `Setting`.`options`, `Setting`.`method`, `Setting`.`display`, (REPLACE(CONCAT(UPPER(SUBSTRING(SUBSTRING_INDEX(`Setting`.`key`, '.', -1), 1, 1)), LOWER(SUBSTRING(SUBSTRING_INDEX(`Setting`.`key`, '.', -1) FROM 2))), '_', ' ')) AS `Setting__tinyMceOption` FROM `bccolleges_database`.`settings` AS `Setting` WHERE `Setting`.`key` = 'Site.Google.gtm_association_code' LIMIT 1 | 1 | 1 | 0 | |
| SELECT `Image`.`id`, `Image`.`model`, `Image`.`foreign_key`, `Image`.`dirname`, `Image`.`basename`, `Image`.`checksum`, `Image`.`alternative`, `Image`.`group`, `Image`.`created`, `Image`.`modified`, `Image`.`rank`, `Image`.`deleted`, `Image`.`deleted_date`, (CONCAT_WS("/", dirname, basename)) AS `Image__path` FROM `bccolleges_database`.`attachments` AS `Image` WHERE `Image`.`model` = 'Setting' AND `Image`.`group` = 'Image' AND `Image`.`foreign_key` = (64) ORDER BY `Image`.`rank` ASC, `Image`.`id` ASC | 0 | 0 | 0 | |
| SELECT `Document`.`id`, `Document`.`model`, `Document`.`foreign_key`, `Document`.`dirname`, `Document`.`basename`, `Document`.`checksum`, `Document`.`alternative`, `Document`.`group`, `Document`.`created`, `Document`.`modified`, `Document`.`rank`, `Document`.`deleted`, `Document`.`deleted_date`, (CONCAT_WS("/", dirname, basename)) AS `Document__path` FROM `bccolleges_database`.`attachments` AS `Document` WHERE `Document`.`model` = 'Setting' AND `Document`.`group` = 'Document' AND `Document`.`foreign_key` = (64) ORDER BY `Document`.`rank` ASC | 0 | 0 | 0 | |
| SELECT `Setting`.`id`, `Setting`.`created`, `Setting`.`modified`, `Setting`.`key`, `Setting`.`value`, `Setting`.`title`, `Setting`.`description`, `Setting`.`type`, `Setting`.`editable`, `Setting`.`super_admin`, `Setting`.`options`, `Setting`.`method`, `Setting`.`display`, (REPLACE(CONCAT(UPPER(SUBSTRING(SUBSTRING_INDEX(`Setting`.`key`, '.', -1), 1, 1)), LOWER(SUBSTRING(SUBSTRING_INDEX(`Setting`.`key`, '.', -1) FROM 2))), '_', ' ')) AS `Setting__tinyMceOption` FROM `bccolleges_database`.`settings` AS `Setting` WHERE `Setting`.`key` = 'Site.Bing.verification_code' LIMIT 1 | 1 | 1 | 0 | |
| SELECT `Image`.`id`, `Image`.`model`, `Image`.`foreign_key`, `Image`.`dirname`, `Image`.`basename`, `Image`.`checksum`, `Image`.`alternative`, `Image`.`group`, `Image`.`created`, `Image`.`modified`, `Image`.`rank`, `Image`.`deleted`, `Image`.`deleted_date`, (CONCAT_WS("/", dirname, basename)) AS `Image__path` FROM `bccolleges_database`.`attachments` AS `Image` WHERE `Image`.`model` = 'Setting' AND `Image`.`group` = 'Image' AND `Image`.`foreign_key` = (21) ORDER BY `Image`.`rank` ASC, `Image`.`id` ASC | 0 | 0 | 0 | |
| SELECT `Document`.`id`, `Document`.`model`, `Document`.`foreign_key`, `Document`.`dirname`, `Document`.`basename`, `Document`.`checksum`, `Document`.`alternative`, `Document`.`group`, `Document`.`created`, `Document`.`modified`, `Document`.`rank`, `Document`.`deleted`, `Document`.`deleted_date`, (CONCAT_WS("/", dirname, basename)) AS `Document__path` FROM `bccolleges_database`.`attachments` AS `Document` WHERE `Document`.`model` = 'Setting' AND `Document`.`group` = 'Document' AND `Document`.`foreign_key` = (21) ORDER BY `Document`.`rank` ASC | 0 | 0 | 0 | |
| SELECT `Setting`.`id`, `Setting`.`created`, `Setting`.`modified`, `Setting`.`key`, `Setting`.`value`, `Setting`.`title`, `Setting`.`description`, `Setting`.`type`, `Setting`.`editable`, `Setting`.`super_admin`, `Setting`.`options`, `Setting`.`method`, `Setting`.`display`, (REPLACE(CONCAT(UPPER(SUBSTRING(SUBSTRING_INDEX(`Setting`.`key`, '.', -1), 1, 1)), LOWER(SUBSTRING(SUBSTRING_INDEX(`Setting`.`key`, '.', -1) FROM 2))), '_', ' ')) AS `Setting__tinyMceOption` FROM `bccolleges_database`.`settings` AS `Setting` WHERE `Setting`.`key` = 'ReCaptcha.invisible' LIMIT 1 | 1 | 1 | 0 | |
| SELECT `Image`.`id`, `Image`.`model`, `Image`.`foreign_key`, `Image`.`dirname`, `Image`.`basename`, `Image`.`checksum`, `Image`.`alternative`, `Image`.`group`, `Image`.`created`, `Image`.`modified`, `Image`.`rank`, `Image`.`deleted`, `Image`.`deleted_date`, (CONCAT_WS("/", dirname, basename)) AS `Image__path` FROM `bccolleges_database`.`attachments` AS `Image` WHERE `Image`.`model` = 'Setting' AND `Image`.`group` = 'Image' AND `Image`.`foreign_key` = (65) ORDER BY `Image`.`rank` ASC, `Image`.`id` ASC | 0 | 0 | 0 | |
| SELECT `Document`.`id`, `Document`.`model`, `Document`.`foreign_key`, `Document`.`dirname`, `Document`.`basename`, `Document`.`checksum`, `Document`.`alternative`, `Document`.`group`, `Document`.`created`, `Document`.`modified`, `Document`.`rank`, `Document`.`deleted`, `Document`.`deleted_date`, (CONCAT_WS("/", dirname, basename)) AS `Document__path` FROM `bccolleges_database`.`attachments` AS `Document` WHERE `Document`.`model` = 'Setting' AND `Document`.`group` = 'Document' AND `Document`.`foreign_key` = (65) ORDER BY `Document`.`rank` ASC | 0 | 0 | 0 | |
| SELECT `Group`.`id`, `Group`.`name`, `Group`.`created`, `Group`.`modified`, `Group`.`login_redirect`, `Group`.`rank`, `Group`.`deleted`, `Group`.`deleted_date` FROM `bccolleges_database`.`groups` AS `Group` WHERE `Group`.`name` = 'Unregistered' AND `Group`.`deleted` = '0' ORDER BY `Group`.`rank` ASC, `Group`.`id` ASC, `Group`.`rank` ASC LIMIT 1 | 0 | 0 | 0 | |
| SELECT `Setting`.`id`, `Setting`.`created`, `Setting`.`modified`, `Setting`.`key`, `Setting`.`value`, `Setting`.`title`, `Setting`.`description`, `Setting`.`type`, `Setting`.`editable`, `Setting`.`super_admin`, `Setting`.`options`, `Setting`.`method`, `Setting`.`display`, (REPLACE(CONCAT(UPPER(SUBSTRING(SUBSTRING_INDEX(`Setting`.`key`, '.', -1), 1, 1)), LOWER(SUBSTRING(SUBSTRING_INDEX(`Setting`.`key`, '.', -1) FROM 2))), '_', ' ')) AS `Setting__tinyMceOption` FROM `bccolleges_database`.`settings` AS `Setting` WHERE `Setting`.`key` = 'Social_Media.twitter' LIMIT 1 | 1 | 1 | 0 | |
| SELECT `Image`.`id`, `Image`.`model`, `Image`.`foreign_key`, `Image`.`dirname`, `Image`.`basename`, `Image`.`checksum`, `Image`.`alternative`, `Image`.`group`, `Image`.`created`, `Image`.`modified`, `Image`.`rank`, `Image`.`deleted`, `Image`.`deleted_date`, (CONCAT_WS("/", dirname, basename)) AS `Image__path` FROM `bccolleges_database`.`attachments` AS `Image` WHERE `Image`.`model` = 'Setting' AND `Image`.`group` = 'Image' AND `Image`.`foreign_key` = (45) ORDER BY `Image`.`rank` ASC, `Image`.`id` ASC | 0 | 0 | 0 | |
| SELECT `Document`.`id`, `Document`.`model`, `Document`.`foreign_key`, `Document`.`dirname`, `Document`.`basename`, `Document`.`checksum`, `Document`.`alternative`, `Document`.`group`, `Document`.`created`, `Document`.`modified`, `Document`.`rank`, `Document`.`deleted`, `Document`.`deleted_date`, (CONCAT_WS("/", dirname, basename)) AS `Document__path` FROM `bccolleges_database`.`attachments` AS `Document` WHERE `Document`.`model` = 'Setting' AND `Document`.`group` = 'Document' AND `Document`.`foreign_key` = (45) ORDER BY `Document`.`rank` ASC | 0 | 0 | 0 | |
| SELECT `Setting`.`id`, `Setting`.`created`, `Setting`.`modified`, `Setting`.`key`, `Setting`.`value`, `Setting`.`title`, `Setting`.`description`, `Setting`.`type`, `Setting`.`editable`, `Setting`.`super_admin`, `Setting`.`options`, `Setting`.`method`, `Setting`.`display`, (REPLACE(CONCAT(UPPER(SUBSTRING(SUBSTRING_INDEX(`Setting`.`key`, '.', -1), 1, 1)), LOWER(SUBSTRING(SUBSTRING_INDEX(`Setting`.`key`, '.', -1) FROM 2))), '_', ' ')) AS `Setting__tinyMceOption` FROM `bccolleges_database`.`settings` AS `Setting` WHERE `Setting`.`key` = 'Social_Media.twitter' LIMIT 1 | 1 | 1 | 0 | |
| SELECT `Image`.`id`, `Image`.`model`, `Image`.`foreign_key`, `Image`.`dirname`, `Image`.`basename`, `Image`.`checksum`, `Image`.`alternative`, `Image`.`group`, `Image`.`created`, `Image`.`modified`, `Image`.`rank`, `Image`.`deleted`, `Image`.`deleted_date`, (CONCAT_WS("/", dirname, basename)) AS `Image__path` FROM `bccolleges_database`.`attachments` AS `Image` WHERE `Image`.`model` = 'Setting' AND `Image`.`group` = 'Image' AND `Image`.`foreign_key` = (45) ORDER BY `Image`.`rank` ASC, `Image`.`id` ASC | 0 | 0 | 0 | |
| SELECT `Document`.`id`, `Document`.`model`, `Document`.`foreign_key`, `Document`.`dirname`, `Document`.`basename`, `Document`.`checksum`, `Document`.`alternative`, `Document`.`group`, `Document`.`created`, `Document`.`modified`, `Document`.`rank`, `Document`.`deleted`, `Document`.`deleted_date`, (CONCAT_WS("/", dirname, basename)) AS `Document__path` FROM `bccolleges_database`.`attachments` AS `Document` WHERE `Document`.`model` = 'Setting' AND `Document`.`group` = 'Document' AND `Document`.`foreign_key` = (45) ORDER BY `Document`.`rank` ASC | 0 | 0 | 0 | |
| SELECT `Setting`.`id`, `Setting`.`created`, `Setting`.`modified`, `Setting`.`key`, `Setting`.`value`, `Setting`.`title`, `Setting`.`description`, `Setting`.`type`, `Setting`.`editable`, `Setting`.`super_admin`, `Setting`.`options`, `Setting`.`method`, `Setting`.`display`, (REPLACE(CONCAT(UPPER(SUBSTRING(SUBSTRING_INDEX(`Setting`.`key`, '.', -1), 1, 1)), LOWER(SUBSTRING(SUBSTRING_INDEX(`Setting`.`key`, '.', -1) FROM 2))), '_', ' ')) AS `Setting__tinyMceOption` FROM `bccolleges_database`.`settings` AS `Setting` WHERE `Setting`.`key` = 'Social_Media.instagram' LIMIT 1 | 1 | 1 | 0 | |
| SELECT `Image`.`id`, `Image`.`model`, `Image`.`foreign_key`, `Image`.`dirname`, `Image`.`basename`, `Image`.`checksum`, `Image`.`alternative`, `Image`.`group`, `Image`.`created`, `Image`.`modified`, `Image`.`rank`, `Image`.`deleted`, `Image`.`deleted_date`, (CONCAT_WS("/", dirname, basename)) AS `Image__path` FROM `bccolleges_database`.`attachments` AS `Image` WHERE `Image`.`model` = 'Setting' AND `Image`.`group` = 'Image' AND `Image`.`foreign_key` = (46) ORDER BY `Image`.`rank` ASC, `Image`.`id` ASC | 0 | 0 | 0 | |
| SELECT `Document`.`id`, `Document`.`model`, `Document`.`foreign_key`, `Document`.`dirname`, `Document`.`basename`, `Document`.`checksum`, `Document`.`alternative`, `Document`.`group`, `Document`.`created`, `Document`.`modified`, `Document`.`rank`, `Document`.`deleted`, `Document`.`deleted_date`, (CONCAT_WS("/", dirname, basename)) AS `Document__path` FROM `bccolleges_database`.`attachments` AS `Document` WHERE `Document`.`model` = 'Setting' AND `Document`.`group` = 'Document' AND `Document`.`foreign_key` = (46) ORDER BY `Document`.`rank` ASC | 0 | 0 | 0 | |
| SELECT `Setting`.`id`, `Setting`.`created`, `Setting`.`modified`, `Setting`.`key`, `Setting`.`value`, `Setting`.`title`, `Setting`.`description`, `Setting`.`type`, `Setting`.`editable`, `Setting`.`super_admin`, `Setting`.`options`, `Setting`.`method`, `Setting`.`display`, (REPLACE(CONCAT(UPPER(SUBSTRING(SUBSTRING_INDEX(`Setting`.`key`, '.', -1), 1, 1)), LOWER(SUBSTRING(SUBSTRING_INDEX(`Setting`.`key`, '.', -1) FROM 2))), '_', ' ')) AS `Setting__tinyMceOption` FROM `bccolleges_database`.`settings` AS `Setting` WHERE `Setting`.`key` = 'Social_Media.instagram' LIMIT 1 | 1 | 1 | 0 | |
| SELECT `Image`.`id`, `Image`.`model`, `Image`.`foreign_key`, `Image`.`dirname`, `Image`.`basename`, `Image`.`checksum`, `Image`.`alternative`, `Image`.`group`, `Image`.`created`, `Image`.`modified`, `Image`.`rank`, `Image`.`deleted`, `Image`.`deleted_date`, (CONCAT_WS("/", dirname, basename)) AS `Image__path` FROM `bccolleges_database`.`attachments` AS `Image` WHERE `Image`.`model` = 'Setting' AND `Image`.`group` = 'Image' AND `Image`.`foreign_key` = (46) ORDER BY `Image`.`rank` ASC, `Image`.`id` ASC | 0 | 0 | 0 | |
| SELECT `Document`.`id`, `Document`.`model`, `Document`.`foreign_key`, `Document`.`dirname`, `Document`.`basename`, `Document`.`checksum`, `Document`.`alternative`, `Document`.`group`, `Document`.`created`, `Document`.`modified`, `Document`.`rank`, `Document`.`deleted`, `Document`.`deleted_date`, (CONCAT_WS("/", dirname, basename)) AS `Document__path` FROM `bccolleges_database`.`attachments` AS `Document` WHERE `Document`.`model` = 'Setting' AND `Document`.`group` = 'Document' AND `Document`.`foreign_key` = (46) ORDER BY `Document`.`rank` ASC | 0 | 0 | 0 | |
| SELECT `Setting`.`id`, `Setting`.`created`, `Setting`.`modified`, `Setting`.`key`, `Setting`.`value`, `Setting`.`title`, `Setting`.`description`, `Setting`.`type`, `Setting`.`editable`, `Setting`.`super_admin`, `Setting`.`options`, `Setting`.`method`, `Setting`.`display`, (REPLACE(CONCAT(UPPER(SUBSTRING(SUBSTRING_INDEX(`Setting`.`key`, '.', -1), 1, 1)), LOWER(SUBSTRING(SUBSTRING_INDEX(`Setting`.`key`, '.', -1) FROM 2))), '_', ' ')) AS `Setting__tinyMceOption` FROM `bccolleges_database`.`settings` AS `Setting` WHERE `Setting`.`key` = 'Social_Media.facebook' LIMIT 1 | 1 | 1 | 0 | |
| SELECT `Image`.`id`, `Image`.`model`, `Image`.`foreign_key`, `Image`.`dirname`, `Image`.`basename`, `Image`.`checksum`, `Image`.`alternative`, `Image`.`group`, `Image`.`created`, `Image`.`modified`, `Image`.`rank`, `Image`.`deleted`, `Image`.`deleted_date`, (CONCAT_WS("/", dirname, basename)) AS `Image__path` FROM `bccolleges_database`.`attachments` AS `Image` WHERE `Image`.`model` = 'Setting' AND `Image`.`group` = 'Image' AND `Image`.`foreign_key` = (44) ORDER BY `Image`.`rank` ASC, `Image`.`id` ASC | 0 | 0 | 0 | |
| SELECT `Document`.`id`, `Document`.`model`, `Document`.`foreign_key`, `Document`.`dirname`, `Document`.`basename`, `Document`.`checksum`, `Document`.`alternative`, `Document`.`group`, `Document`.`created`, `Document`.`modified`, `Document`.`rank`, `Document`.`deleted`, `Document`.`deleted_date`, (CONCAT_WS("/", dirname, basename)) AS `Document__path` FROM `bccolleges_database`.`attachments` AS `Document` WHERE `Document`.`model` = 'Setting' AND `Document`.`group` = 'Document' AND `Document`.`foreign_key` = (44) ORDER BY `Document`.`rank` ASC | 0 | 0 | 0 | |
| SELECT `Setting`.`id`, `Setting`.`created`, `Setting`.`modified`, `Setting`.`key`, `Setting`.`value`, `Setting`.`title`, `Setting`.`description`, `Setting`.`type`, `Setting`.`editable`, `Setting`.`super_admin`, `Setting`.`options`, `Setting`.`method`, `Setting`.`display`, (REPLACE(CONCAT(UPPER(SUBSTRING(SUBSTRING_INDEX(`Setting`.`key`, '.', -1), 1, 1)), LOWER(SUBSTRING(SUBSTRING_INDEX(`Setting`.`key`, '.', -1) FROM 2))), '_', ' ')) AS `Setting__tinyMceOption` FROM `bccolleges_database`.`settings` AS `Setting` WHERE `Setting`.`key` = 'Social_Media.facebook' LIMIT 1 | 1 | 1 | 0 | |
| SELECT `Image`.`id`, `Image`.`model`, `Image`.`foreign_key`, `Image`.`dirname`, `Image`.`basename`, `Image`.`checksum`, `Image`.`alternative`, `Image`.`group`, `Image`.`created`, `Image`.`modified`, `Image`.`rank`, `Image`.`deleted`, `Image`.`deleted_date`, (CONCAT_WS("/", dirname, basename)) AS `Image__path` FROM `bccolleges_database`.`attachments` AS `Image` WHERE `Image`.`model` = 'Setting' AND `Image`.`group` = 'Image' AND `Image`.`foreign_key` = (44) ORDER BY `Image`.`rank` ASC, `Image`.`id` ASC | 0 | 0 | 0 | |
| SELECT `Document`.`id`, `Document`.`model`, `Document`.`foreign_key`, `Document`.`dirname`, `Document`.`basename`, `Document`.`checksum`, `Document`.`alternative`, `Document`.`group`, `Document`.`created`, `Document`.`modified`, `Document`.`rank`, `Document`.`deleted`, `Document`.`deleted_date`, (CONCAT_WS("/", dirname, basename)) AS `Document__path` FROM `bccolleges_database`.`attachments` AS `Document` WHERE `Document`.`model` = 'Setting' AND `Document`.`group` = 'Document' AND `Document`.`foreign_key` = (44) ORDER BY `Document`.`rank` ASC | 0 | 0 | 0 | |
| SELECT `Setting`.`id`, `Setting`.`created`, `Setting`.`modified`, `Setting`.`key`, `Setting`.`value`, `Setting`.`title`, `Setting`.`description`, `Setting`.`type`, `Setting`.`editable`, `Setting`.`super_admin`, `Setting`.`options`, `Setting`.`method`, `Setting`.`display`, (REPLACE(CONCAT(UPPER(SUBSTRING(SUBSTRING_INDEX(`Setting`.`key`, '.', -1), 1, 1)), LOWER(SUBSTRING(SUBSTRING_INDEX(`Setting`.`key`, '.', -1) FROM 2))), '_', ' ')) AS `Setting__tinyMceOption` FROM `bccolleges_database`.`settings` AS `Setting` WHERE `Setting`.`key` = 'Social_Media.linkedin' LIMIT 1 | 1 | 1 | 0 | |
| SELECT `Image`.`id`, `Image`.`model`, `Image`.`foreign_key`, `Image`.`dirname`, `Image`.`basename`, `Image`.`checksum`, `Image`.`alternative`, `Image`.`group`, `Image`.`created`, `Image`.`modified`, `Image`.`rank`, `Image`.`deleted`, `Image`.`deleted_date`, (CONCAT_WS("/", dirname, basename)) AS `Image__path` FROM `bccolleges_database`.`attachments` AS `Image` WHERE `Image`.`model` = 'Setting' AND `Image`.`group` = 'Image' AND `Image`.`foreign_key` = (43) ORDER BY `Image`.`rank` ASC, `Image`.`id` ASC | 0 | 0 | 0 | |
| SELECT `Document`.`id`, `Document`.`model`, `Document`.`foreign_key`, `Document`.`dirname`, `Document`.`basename`, `Document`.`checksum`, `Document`.`alternative`, `Document`.`group`, `Document`.`created`, `Document`.`modified`, `Document`.`rank`, `Document`.`deleted`, `Document`.`deleted_date`, (CONCAT_WS("/", dirname, basename)) AS `Document__path` FROM `bccolleges_database`.`attachments` AS `Document` WHERE `Document`.`model` = 'Setting' AND `Document`.`group` = 'Document' AND `Document`.`foreign_key` = (43) ORDER BY `Document`.`rank` ASC | 0 | 0 | 0 | |
| SELECT `Setting`.`id`, `Setting`.`created`, `Setting`.`modified`, `Setting`.`key`, `Setting`.`value`, `Setting`.`title`, `Setting`.`description`, `Setting`.`type`, `Setting`.`editable`, `Setting`.`super_admin`, `Setting`.`options`, `Setting`.`method`, `Setting`.`display`, (REPLACE(CONCAT(UPPER(SUBSTRING(SUBSTRING_INDEX(`Setting`.`key`, '.', -1), 1, 1)), LOWER(SUBSTRING(SUBSTRING_INDEX(`Setting`.`key`, '.', -1) FROM 2))), '_', ' ')) AS `Setting__tinyMceOption` FROM `bccolleges_database`.`settings` AS `Setting` WHERE `Setting`.`key` = 'Social_Media.linkedin' LIMIT 1 | 1 | 1 | 0 | |
| SELECT `Image`.`id`, `Image`.`model`, `Image`.`foreign_key`, `Image`.`dirname`, `Image`.`basename`, `Image`.`checksum`, `Image`.`alternative`, `Image`.`group`, `Image`.`created`, `Image`.`modified`, `Image`.`rank`, `Image`.`deleted`, `Image`.`deleted_date`, (CONCAT_WS("/", dirname, basename)) AS `Image__path` FROM `bccolleges_database`.`attachments` AS `Image` WHERE `Image`.`model` = 'Setting' AND `Image`.`group` = 'Image' AND `Image`.`foreign_key` = (43) ORDER BY `Image`.`rank` ASC, `Image`.`id` ASC | 0 | 0 | 0 | |
| SELECT `Document`.`id`, `Document`.`model`, `Document`.`foreign_key`, `Document`.`dirname`, `Document`.`basename`, `Document`.`checksum`, `Document`.`alternative`, `Document`.`group`, `Document`.`created`, `Document`.`modified`, `Document`.`rank`, `Document`.`deleted`, `Document`.`deleted_date`, (CONCAT_WS("/", dirname, basename)) AS `Document__path` FROM `bccolleges_database`.`attachments` AS `Document` WHERE `Document`.`model` = 'Setting' AND `Document`.`group` = 'Document' AND `Document`.`foreign_key` = (43) ORDER BY `Document`.`rank` ASC | 0 | 0 | 0 | |
| SELECT `NavigationMenuItem`.`id`, `NavigationMenuItem`.`created`, `NavigationMenuItem`.`modified`, `NavigationMenuItem`.`name`, `NavigationMenuItem`.`parent_id`, `NavigationMenuItem`.`lft`, `NavigationMenuItem`.`rght`, `NavigationMenuItem`.`navigation_menu_id`, `NavigationMenuItem`.`url`, `NavigationMenuItem`.`target_page`, `NavigationMenuItem`.`rank`, `NavigationMenuItem`.`foreign_model`, `NavigationMenuItem`.`foreign_key`, `NavigationMenuItem`.`new_window`, `NavigationMenuItem`.`foreign_plugin`, `NavigationMenuItem`.`deleted`, `NavigationMenuItem`.`deleted_date`, `PublishingInformation`.`id`, `PublishingInformation`.`created`, `PublishingInformation`.`modified`, `PublishingInformation`.`model`, `PublishingInformation`.`foreign_key`, `PublishingInformation`.`start`, `PublishingInformation`.`end`, `PublishingInformation`.`published` FROM `bccolleges_database`.`navigation_menu_items` AS `NavigationMenuItem` LEFT JOIN `bccolleges_database`.`publishing_information` AS `PublishingInformation` ON (`PublishingInformation`.`foreign_key` = `NavigationMenuItem`.`id` AND `PublishingInformation`.`model` = 'NavigationMenuItem') WHERE `NavigationMenuItem`.`navigation_menu_id` = 1 AND `NavigationMenuItem`.`deleted` = '0' ORDER BY `NavigationMenuItem`.`lft` ASC | 28 | 28 | 0 | |
| SELECT `PublishingInformation`.`id`, `PublishingInformation`.`created`, `PublishingInformation`.`modified`, `PublishingInformation`.`model`, `PublishingInformation`.`foreign_key`, `PublishingInformation`.`start`, `PublishingInformation`.`end`, `PublishingInformation`.`published` FROM `bccolleges_database`.`publishing_information` AS `PublishingInformation` WHERE `model` = 'NavigationMenuItem' AND `foreign_key` = 1 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `PublishingInformation`.`id`, `PublishingInformation`.`created`, `PublishingInformation`.`modified`, `PublishingInformation`.`model`, `PublishingInformation`.`foreign_key`, `PublishingInformation`.`start`, `PublishingInformation`.`end`, `PublishingInformation`.`published` FROM `bccolleges_database`.`publishing_information` AS `PublishingInformation` WHERE `model` = 'NavigationMenuItem' AND `foreign_key` = 2 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `PublishingInformation`.`id`, `PublishingInformation`.`created`, `PublishingInformation`.`modified`, `PublishingInformation`.`model`, `PublishingInformation`.`foreign_key`, `PublishingInformation`.`start`, `PublishingInformation`.`end`, `PublishingInformation`.`published` FROM `bccolleges_database`.`publishing_information` AS `PublishingInformation` WHERE `model` = 'NavigationMenuItem' AND `foreign_key` = 3 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `PublishingInformation`.`id`, `PublishingInformation`.`created`, `PublishingInformation`.`modified`, `PublishingInformation`.`model`, `PublishingInformation`.`foreign_key`, `PublishingInformation`.`start`, `PublishingInformation`.`end`, `PublishingInformation`.`published` FROM `bccolleges_database`.`publishing_information` AS `PublishingInformation` WHERE `model` = 'NavigationMenuItem' AND `foreign_key` = 37 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `PublishingInformation`.`id`, `PublishingInformation`.`created`, `PublishingInformation`.`modified`, `PublishingInformation`.`model`, `PublishingInformation`.`foreign_key`, `PublishingInformation`.`start`, `PublishingInformation`.`end`, `PublishingInformation`.`published` FROM `bccolleges_database`.`publishing_information` AS `PublishingInformation` WHERE `model` = 'NavigationMenuItem' AND `foreign_key` = 21 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `PublishingInformation`.`id`, `PublishingInformation`.`created`, `PublishingInformation`.`modified`, `PublishingInformation`.`model`, `PublishingInformation`.`foreign_key`, `PublishingInformation`.`start`, `PublishingInformation`.`end`, `PublishingInformation`.`published` FROM `bccolleges_database`.`publishing_information` AS `PublishingInformation` WHERE `model` = 'NavigationMenuItem' AND `foreign_key` = 22 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `PublishingInformation`.`id`, `PublishingInformation`.`created`, `PublishingInformation`.`modified`, `PublishingInformation`.`model`, `PublishingInformation`.`foreign_key`, `PublishingInformation`.`start`, `PublishingInformation`.`end`, `PublishingInformation`.`published` FROM `bccolleges_database`.`publishing_information` AS `PublishingInformation` WHERE `model` = 'NavigationMenuItem' AND `foreign_key` = 24 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `PublishingInformation`.`id`, `PublishingInformation`.`created`, `PublishingInformation`.`modified`, `PublishingInformation`.`model`, `PublishingInformation`.`foreign_key`, `PublishingInformation`.`start`, `PublishingInformation`.`end`, `PublishingInformation`.`published` FROM `bccolleges_database`.`publishing_information` AS `PublishingInformation` WHERE `model` = 'NavigationMenuItem' AND `foreign_key` = 25 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `PublishingInformation`.`id`, `PublishingInformation`.`created`, `PublishingInformation`.`modified`, `PublishingInformation`.`model`, `PublishingInformation`.`foreign_key`, `PublishingInformation`.`start`, `PublishingInformation`.`end`, `PublishingInformation`.`published` FROM `bccolleges_database`.`publishing_information` AS `PublishingInformation` WHERE `model` = 'NavigationMenuItem' AND `foreign_key` = 35 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `PublishingInformation`.`id`, `PublishingInformation`.`created`, `PublishingInformation`.`modified`, `PublishingInformation`.`model`, `PublishingInformation`.`foreign_key`, `PublishingInformation`.`start`, `PublishingInformation`.`end`, `PublishingInformation`.`published` FROM `bccolleges_database`.`publishing_information` AS `PublishingInformation` WHERE `model` = 'NavigationMenuItem' AND `foreign_key` = 4 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `PublishingInformation`.`id`, `PublishingInformation`.`created`, `PublishingInformation`.`modified`, `PublishingInformation`.`model`, `PublishingInformation`.`foreign_key`, `PublishingInformation`.`start`, `PublishingInformation`.`end`, `PublishingInformation`.`published` FROM `bccolleges_database`.`publishing_information` AS `PublishingInformation` WHERE `model` = 'NavigationMenuItem' AND `foreign_key` = 14 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `PublishingInformation`.`id`, `PublishingInformation`.`created`, `PublishingInformation`.`modified`, `PublishingInformation`.`model`, `PublishingInformation`.`foreign_key`, `PublishingInformation`.`start`, `PublishingInformation`.`end`, `PublishingInformation`.`published` FROM `bccolleges_database`.`publishing_information` AS `PublishingInformation` WHERE `model` = 'NavigationMenuItem' AND `foreign_key` = 38 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `PublishingInformation`.`id`, `PublishingInformation`.`created`, `PublishingInformation`.`modified`, `PublishingInformation`.`model`, `PublishingInformation`.`foreign_key`, `PublishingInformation`.`start`, `PublishingInformation`.`end`, `PublishingInformation`.`published` FROM `bccolleges_database`.`publishing_information` AS `PublishingInformation` WHERE `model` = 'NavigationMenuItem' AND `foreign_key` = 15 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `PublishingInformation`.`id`, `PublishingInformation`.`created`, `PublishingInformation`.`modified`, `PublishingInformation`.`model`, `PublishingInformation`.`foreign_key`, `PublishingInformation`.`start`, `PublishingInformation`.`end`, `PublishingInformation`.`published` FROM `bccolleges_database`.`publishing_information` AS `PublishingInformation` WHERE `model` = 'NavigationMenuItem' AND `foreign_key` = 16 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `PublishingInformation`.`id`, `PublishingInformation`.`created`, `PublishingInformation`.`modified`, `PublishingInformation`.`model`, `PublishingInformation`.`foreign_key`, `PublishingInformation`.`start`, `PublishingInformation`.`end`, `PublishingInformation`.`published` FROM `bccolleges_database`.`publishing_information` AS `PublishingInformation` WHERE `model` = 'NavigationMenuItem' AND `foreign_key` = 17 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `PublishingInformation`.`id`, `PublishingInformation`.`created`, `PublishingInformation`.`modified`, `PublishingInformation`.`model`, `PublishingInformation`.`foreign_key`, `PublishingInformation`.`start`, `PublishingInformation`.`end`, `PublishingInformation`.`published` FROM `bccolleges_database`.`publishing_information` AS `PublishingInformation` WHERE `model` = 'NavigationMenuItem' AND `foreign_key` = 18 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `PublishingInformation`.`id`, `PublishingInformation`.`created`, `PublishingInformation`.`modified`, `PublishingInformation`.`model`, `PublishingInformation`.`foreign_key`, `PublishingInformation`.`start`, `PublishingInformation`.`end`, `PublishingInformation`.`published` FROM `bccolleges_database`.`publishing_information` AS `PublishingInformation` WHERE `model` = 'NavigationMenuItem' AND `foreign_key` = 19 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `PublishingInformation`.`id`, `PublishingInformation`.`created`, `PublishingInformation`.`modified`, `PublishingInformation`.`model`, `PublishingInformation`.`foreign_key`, `PublishingInformation`.`start`, `PublishingInformation`.`end`, `PublishingInformation`.`published` FROM `bccolleges_database`.`publishing_information` AS `PublishingInformation` WHERE `model` = 'NavigationMenuItem' AND `foreign_key` = 5 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `PublishingInformation`.`id`, `PublishingInformation`.`created`, `PublishingInformation`.`modified`, `PublishingInformation`.`model`, `PublishingInformation`.`foreign_key`, `PublishingInformation`.`start`, `PublishingInformation`.`end`, `PublishingInformation`.`published` FROM `bccolleges_database`.`publishing_information` AS `PublishingInformation` WHERE `model` = 'NavigationMenuItem' AND `foreign_key` = 26 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `PublishingInformation`.`id`, `PublishingInformation`.`created`, `PublishingInformation`.`modified`, `PublishingInformation`.`model`, `PublishingInformation`.`foreign_key`, `PublishingInformation`.`start`, `PublishingInformation`.`end`, `PublishingInformation`.`published` FROM `bccolleges_database`.`publishing_information` AS `PublishingInformation` WHERE `model` = 'NavigationMenuItem' AND `foreign_key` = 36 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `PublishingInformation`.`id`, `PublishingInformation`.`created`, `PublishingInformation`.`modified`, `PublishingInformation`.`model`, `PublishingInformation`.`foreign_key`, `PublishingInformation`.`start`, `PublishingInformation`.`end`, `PublishingInformation`.`published` FROM `bccolleges_database`.`publishing_information` AS `PublishingInformation` WHERE `model` = 'NavigationMenuItem' AND `foreign_key` = 27 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `PublishingInformation`.`id`, `PublishingInformation`.`created`, `PublishingInformation`.`modified`, `PublishingInformation`.`model`, `PublishingInformation`.`foreign_key`, `PublishingInformation`.`start`, `PublishingInformation`.`end`, `PublishingInformation`.`published` FROM `bccolleges_database`.`publishing_information` AS `PublishingInformation` WHERE `model` = 'NavigationMenuItem' AND `foreign_key` = 28 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `PublishingInformation`.`id`, `PublishingInformation`.`created`, `PublishingInformation`.`modified`, `PublishingInformation`.`model`, `PublishingInformation`.`foreign_key`, `PublishingInformation`.`start`, `PublishingInformation`.`end`, `PublishingInformation`.`published` FROM `bccolleges_database`.`publishing_information` AS `PublishingInformation` WHERE `model` = 'NavigationMenuItem' AND `foreign_key` = 31 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `PublishingInformation`.`id`, `PublishingInformation`.`created`, `PublishingInformation`.`modified`, `PublishingInformation`.`model`, `PublishingInformation`.`foreign_key`, `PublishingInformation`.`start`, `PublishingInformation`.`end`, `PublishingInformation`.`published` FROM `bccolleges_database`.`publishing_information` AS `PublishingInformation` WHERE `model` = 'NavigationMenuItem' AND `foreign_key` = 30 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `PublishingInformation`.`id`, `PublishingInformation`.`created`, `PublishingInformation`.`modified`, `PublishingInformation`.`model`, `PublishingInformation`.`foreign_key`, `PublishingInformation`.`start`, `PublishingInformation`.`end`, `PublishingInformation`.`published` FROM `bccolleges_database`.`publishing_information` AS `PublishingInformation` WHERE `model` = 'NavigationMenuItem' AND `foreign_key` = 6 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `PublishingInformation`.`id`, `PublishingInformation`.`created`, `PublishingInformation`.`modified`, `PublishingInformation`.`model`, `PublishingInformation`.`foreign_key`, `PublishingInformation`.`start`, `PublishingInformation`.`end`, `PublishingInformation`.`published` FROM `bccolleges_database`.`publishing_information` AS `PublishingInformation` WHERE `model` = 'NavigationMenuItem' AND `foreign_key` = 34 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `PublishingInformation`.`id`, `PublishingInformation`.`created`, `PublishingInformation`.`modified`, `PublishingInformation`.`model`, `PublishingInformation`.`foreign_key`, `PublishingInformation`.`start`, `PublishingInformation`.`end`, `PublishingInformation`.`published` FROM `bccolleges_database`.`publishing_information` AS `PublishingInformation` WHERE `model` = 'NavigationMenuItem' AND `foreign_key` = 32 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `PublishingInformation`.`id`, `PublishingInformation`.`created`, `PublishingInformation`.`modified`, `PublishingInformation`.`model`, `PublishingInformation`.`foreign_key`, `PublishingInformation`.`start`, `PublishingInformation`.`end`, `PublishingInformation`.`published` FROM `bccolleges_database`.`publishing_information` AS `PublishingInformation` WHERE `model` = 'NavigationMenuItem' AND `foreign_key` = 33 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `PrototypeInstance`.`id`, `PrototypeInstance`.`name`, `PrototypeInstance`.`description`, `PrototypeInstance`.`slug`, `PrototypeInstance`.`created`, `PrototypeInstance`.`modified`, `PrototypeInstance`.`use_categories`, `PrototypeInstance`.`public`, `PrototypeInstance`.`footer_text`, `PrototypeInstance`.`layout`, `PrototypeInstance`.`item_order`, `PrototypeInstance`.`allow_instance_view`, `PrototypeInstance`.`allow_category_views`, `PrototypeInstance`.`allow_item_views`, `PrototypeInstance`.`item_image_type`, `PrototypeInstance`.`item_document_type`, `PrototypeInstance`.`category_image_type`, `PrototypeInstance`.`category_document_type`, `PrototypeInstance`.`item_summary_pagination`, `PrototypeInstance`.`item_summary_pagination_limit`, `PrototypeInstance`.`use_featured_items`, `PrototypeInstance`.`all_items_featured`, `PrototypeInstance`.`number_of_featured_items`, `PrototypeInstance`.`autoload_featured_items_in_layouts`, `PrototypeInstance`.`deleted`, `PrototypeInstance`.`deleted_date`, `PrototypeInstance`.`name_field_label`, `PrototypeInstance`.`head_title`, `PrototypeInstance`.`category_changefreq`, `PrototypeInstance`.`item_changefreq`, `PublishingInformation`.`id`, `PublishingInformation`.`created`, `PublishingInformation`.`modified`, `PublishingInformation`.`model`, `PublishingInformation`.`foreign_key`, `PublishingInformation`.`start`, `PublishingInformation`.`end`, `PublishingInformation`.`published` FROM `bccolleges_database`.`prototype_instances` AS `PrototypeInstance` LEFT JOIN `bccolleges_database`.`publishing_information` AS `PublishingInformation` ON (`PublishingInformation`.`foreign_key` = `PrototypeInstance`.`id` AND `PublishingInformation`.`model` = 'PrototypeInstance') WHERE `PrototypeInstance`.`id` = 7 AND `PrototypeInstance`.`deleted` = '0' LIMIT 1 | 1 | 1 | 0 | |
| SELECT `MetaValue`.`id`, `MetaValue`.`created`, `MetaValue`.`modified`, `MetaValue`.`model`, `MetaValue`.`foreign_key`, `MetaValue`.`meta_key_id`, `MetaValue`.`val` FROM `bccolleges_database`.`meta_values` AS `MetaValue` WHERE `MetaValue`.`model` = 'PrototypeInstance' AND `MetaValue`.`foreign_key` = (7) | 5 | 5 | 0 | |
| SELECT `PrototypeItem`.`id`, `PrototypeItem`.`name`, `PrototypeItem`.`rank`, `PrototypeItem`.`created`, `PrototypeItem`.`modified`, `PrototypeItem`.`slug`, `PrototypeItem`.`prototype_instance_id`, `PrototypeItem`.`featured`, `PrototypeItem`.`deleted`, `PrototypeItem`.`deleted_date`, `PrototypeItem`.`head_title`, `PublishingInformation`.`id`, `PublishingInformation`.`created`, `PublishingInformation`.`modified`, `PublishingInformation`.`model`, `PublishingInformation`.`foreign_key`, `PublishingInformation`.`start`, `PublishingInformation`.`end`, `PublishingInformation`.`published` FROM `bccolleges_database`.`prototype_items` AS `PrototypeItem` LEFT JOIN `bccolleges_database`.`publishing_information` AS `PublishingInformation` ON (`PublishingInformation`.`foreign_key` = `PrototypeItem`.`id` AND `PublishingInformation`.`model` = 'PrototypeItem') WHERE `PrototypeItem`.`prototype_instance_id` = 7 AND `PublishingInformation`.`published` = '1' AND `PublishingInformation`.`start` <= '2022-05-17 00:24:33' AND ((`PublishingInformation`.`end` IS NULL) OR (`PublishingInformation`.`end` > '2022-05-17 00:24:33')) AND `PrototypeItem`.`deleted` = '0' ORDER BY rand() ASC, `PrototypeItem`.`rank` ASC LIMIT 1 | 1 | 1 | 0 | |
| SELECT `Image`.`id`, `Image`.`model`, `Image`.`foreign_key`, `Image`.`dirname`, `Image`.`basename`, `Image`.`checksum`, `Image`.`alternative`, `Image`.`group`, `Image`.`created`, `Image`.`modified`, `Image`.`rank`, `Image`.`deleted`, `Image`.`deleted_date`, (CONCAT_WS("/", dirname, basename)) AS `Image__path` FROM `bccolleges_database`.`attachments` AS `Image` WHERE `Image`.`model` = 'PrototypeItem' AND `Image`.`group` = 'Image' AND `Image`.`foreign_key` = (29) ORDER BY `Image`.`rank` ASC, `Image`.`id` ASC | 0 | 0 | 0 | |
| SELECT `Document`.`id`, `Document`.`model`, `Document`.`foreign_key`, `Document`.`dirname`, `Document`.`basename`, `Document`.`checksum`, `Document`.`alternative`, `Document`.`group`, `Document`.`created`, `Document`.`modified`, `Document`.`rank`, `Document`.`deleted`, `Document`.`deleted_date`, (CONCAT_WS("/", dirname, basename)) AS `Document__path` FROM `bccolleges_database`.`attachments` AS `Document` WHERE `Document`.`model` = 'PrototypeItem' AND `Document`.`group` = 'Document' AND `Document`.`foreign_key` = (29) ORDER BY `Document`.`rank` ASC | 0 | 0 | 0 | |
| SELECT `CustomFieldValue`.`id`, `CustomFieldValue`.`foreign_key`, `CustomFieldValue`.`model`, `CustomFieldValue`.`custom_field_id`, `CustomFieldValue`.`key`, `CustomFieldValue`.`val`, `CustomFieldValue`.`type` FROM `bccolleges_database`.`custom_field_values` AS `CustomFieldValue` WHERE `CustomFieldValue`.`model` = 'PrototypeItem' AND `CustomFieldValue`.`foreign_key` = (29) | 1 | 1 | 0 | |
| SELECT `MetaValue`.`id`, `MetaValue`.`created`, `MetaValue`.`modified`, `MetaValue`.`model`, `MetaValue`.`foreign_key`, `MetaValue`.`meta_key_id`, `MetaValue`.`val` FROM `bccolleges_database`.`meta_values` AS `MetaValue` WHERE `MetaValue`.`model` = 'PrototypeItem' AND `MetaValue`.`foreign_key` = (29) | 5 | 5 | 0 | |
| SELECT `Setting`.`id`, `Setting`.`created`, `Setting`.`modified`, `Setting`.`key`, `Setting`.`value`, `Setting`.`title`, `Setting`.`description`, `Setting`.`type`, `Setting`.`editable`, `Setting`.`super_admin`, `Setting`.`options`, `Setting`.`method`, `Setting`.`display`, (REPLACE(CONCAT(UPPER(SUBSTRING(SUBSTRING_INDEX(`Setting`.`key`, '.', -1), 1, 1)), LOWER(SUBSTRING(SUBSTRING_INDEX(`Setting`.`key`, '.', -1) FROM 2))), '_', ' ')) AS `Setting__tinyMceOption` FROM `bccolleges_database`.`settings` AS `Setting` WHERE `Setting`.`key` = 'Social_Media.twitter' LIMIT 1 | 1 | 1 | 0 | |
| SELECT `Image`.`id`, `Image`.`model`, `Image`.`foreign_key`, `Image`.`dirname`, `Image`.`basename`, `Image`.`checksum`, `Image`.`alternative`, `Image`.`group`, `Image`.`created`, `Image`.`modified`, `Image`.`rank`, `Image`.`deleted`, `Image`.`deleted_date`, (CONCAT_WS("/", dirname, basename)) AS `Image__path` FROM `bccolleges_database`.`attachments` AS `Image` WHERE `Image`.`model` = 'Setting' AND `Image`.`group` = 'Image' AND `Image`.`foreign_key` = (45) ORDER BY `Image`.`rank` ASC, `Image`.`id` ASC | 0 | 0 | 0 | |
| SELECT `Document`.`id`, `Document`.`model`, `Document`.`foreign_key`, `Document`.`dirname`, `Document`.`basename`, `Document`.`checksum`, `Document`.`alternative`, `Document`.`group`, `Document`.`created`, `Document`.`modified`, `Document`.`rank`, `Document`.`deleted`, `Document`.`deleted_date`, (CONCAT_WS("/", dirname, basename)) AS `Document__path` FROM `bccolleges_database`.`attachments` AS `Document` WHERE `Document`.`model` = 'Setting' AND `Document`.`group` = 'Document' AND `Document`.`foreign_key` = (45) ORDER BY `Document`.`rank` ASC | 0 | 0 | 0 | |
| SELECT `Setting`.`id`, `Setting`.`created`, `Setting`.`modified`, `Setting`.`key`, `Setting`.`value`, `Setting`.`title`, `Setting`.`description`, `Setting`.`type`, `Setting`.`editable`, `Setting`.`super_admin`, `Setting`.`options`, `Setting`.`method`, `Setting`.`display`, (REPLACE(CONCAT(UPPER(SUBSTRING(SUBSTRING_INDEX(`Setting`.`key`, '.', -1), 1, 1)), LOWER(SUBSTRING(SUBSTRING_INDEX(`Setting`.`key`, '.', -1) FROM 2))), '_', ' ')) AS `Setting__tinyMceOption` FROM `bccolleges_database`.`settings` AS `Setting` WHERE `Setting`.`key` = 'Social_Media.twitter' LIMIT 1 | 1 | 1 | 0 | |
| SELECT `Image`.`id`, `Image`.`model`, `Image`.`foreign_key`, `Image`.`dirname`, `Image`.`basename`, `Image`.`checksum`, `Image`.`alternative`, `Image`.`group`, `Image`.`created`, `Image`.`modified`, `Image`.`rank`, `Image`.`deleted`, `Image`.`deleted_date`, (CONCAT_WS("/", dirname, basename)) AS `Image__path` FROM `bccolleges_database`.`attachments` AS `Image` WHERE `Image`.`model` = 'Setting' AND `Image`.`group` = 'Image' AND `Image`.`foreign_key` = (45) ORDER BY `Image`.`rank` ASC, `Image`.`id` ASC | 0 | 0 | 0 | |
| SELECT `Document`.`id`, `Document`.`model`, `Document`.`foreign_key`, `Document`.`dirname`, `Document`.`basename`, `Document`.`checksum`, `Document`.`alternative`, `Document`.`group`, `Document`.`created`, `Document`.`modified`, `Document`.`rank`, `Document`.`deleted`, `Document`.`deleted_date`, (CONCAT_WS("/", dirname, basename)) AS `Document__path` FROM `bccolleges_database`.`attachments` AS `Document` WHERE `Document`.`model` = 'Setting' AND `Document`.`group` = 'Document' AND `Document`.`foreign_key` = (45) ORDER BY `Document`.`rank` ASC | 0 | 0 | 0 | |
| SELECT `Setting`.`id`, `Setting`.`created`, `Setting`.`modified`, `Setting`.`key`, `Setting`.`value`, `Setting`.`title`, `Setting`.`description`, `Setting`.`type`, `Setting`.`editable`, `Setting`.`super_admin`, `Setting`.`options`, `Setting`.`method`, `Setting`.`display`, (REPLACE(CONCAT(UPPER(SUBSTRING(SUBSTRING_INDEX(`Setting`.`key`, '.', -1), 1, 1)), LOWER(SUBSTRING(SUBSTRING_INDEX(`Setting`.`key`, '.', -1) FROM 2))), '_', ' ')) AS `Setting__tinyMceOption` FROM `bccolleges_database`.`settings` AS `Setting` WHERE `Setting`.`key` = 'Social_Media.instagram' LIMIT 1 | 1 | 1 | 0 | |
| SELECT `Image`.`id`, `Image`.`model`, `Image`.`foreign_key`, `Image`.`dirname`, `Image`.`basename`, `Image`.`checksum`, `Image`.`alternative`, `Image`.`group`, `Image`.`created`, `Image`.`modified`, `Image`.`rank`, `Image`.`deleted`, `Image`.`deleted_date`, (CONCAT_WS("/", dirname, basename)) AS `Image__path` FROM `bccolleges_database`.`attachments` AS `Image` WHERE `Image`.`model` = 'Setting' AND `Image`.`group` = 'Image' AND `Image`.`foreign_key` = (46) ORDER BY `Image`.`rank` ASC, `Image`.`id` ASC | 0 | 0 | 0 | |
| SELECT `Document`.`id`, `Document`.`model`, `Document`.`foreign_key`, `Document`.`dirname`, `Document`.`basename`, `Document`.`checksum`, `Document`.`alternative`, `Document`.`group`, `Document`.`created`, `Document`.`modified`, `Document`.`rank`, `Document`.`deleted`, `Document`.`deleted_date`, (CONCAT_WS("/", dirname, basename)) AS `Document__path` FROM `bccolleges_database`.`attachments` AS `Document` WHERE `Document`.`model` = 'Setting' AND `Document`.`group` = 'Document' AND `Document`.`foreign_key` = (46) ORDER BY `Document`.`rank` ASC | 0 | 0 | 0 | |
| SELECT `Setting`.`id`, `Setting`.`created`, `Setting`.`modified`, `Setting`.`key`, `Setting`.`value`, `Setting`.`title`, `Setting`.`description`, `Setting`.`type`, `Setting`.`editable`, `Setting`.`super_admin`, `Setting`.`options`, `Setting`.`method`, `Setting`.`display`, (REPLACE(CONCAT(UPPER(SUBSTRING(SUBSTRING_INDEX(`Setting`.`key`, '.', -1), 1, 1)), LOWER(SUBSTRING(SUBSTRING_INDEX(`Setting`.`key`, '.', -1) FROM 2))), '_', ' ')) AS `Setting__tinyMceOption` FROM `bccolleges_database`.`settings` AS `Setting` WHERE `Setting`.`key` = 'Social_Media.instagram' LIMIT 1 | 1 | 1 | 0 | |
| SELECT `Image`.`id`, `Image`.`model`, `Image`.`foreign_key`, `Image`.`dirname`, `Image`.`basename`, `Image`.`checksum`, `Image`.`alternative`, `Image`.`group`, `Image`.`created`, `Image`.`modified`, `Image`.`rank`, `Image`.`deleted`, `Image`.`deleted_date`, (CONCAT_WS("/", dirname, basename)) AS `Image__path` FROM `bccolleges_database`.`attachments` AS `Image` WHERE `Image`.`model` = 'Setting' AND `Image`.`group` = 'Image' AND `Image`.`foreign_key` = (46) ORDER BY `Image`.`rank` ASC, `Image`.`id` ASC | 0 | 0 | 0 | |
| SELECT `Document`.`id`, `Document`.`model`, `Document`.`foreign_key`, `Document`.`dirname`, `Document`.`basename`, `Document`.`checksum`, `Document`.`alternative`, `Document`.`group`, `Document`.`created`, `Document`.`modified`, `Document`.`rank`, `Document`.`deleted`, `Document`.`deleted_date`, (CONCAT_WS("/", dirname, basename)) AS `Document__path` FROM `bccolleges_database`.`attachments` AS `Document` WHERE `Document`.`model` = 'Setting' AND `Document`.`group` = 'Document' AND `Document`.`foreign_key` = (46) ORDER BY `Document`.`rank` ASC | 0 | 0 | 0 | |
| SELECT `Setting`.`id`, `Setting`.`created`, `Setting`.`modified`, `Setting`.`key`, `Setting`.`value`, `Setting`.`title`, `Setting`.`description`, `Setting`.`type`, `Setting`.`editable`, `Setting`.`super_admin`, `Setting`.`options`, `Setting`.`method`, `Setting`.`display`, (REPLACE(CONCAT(UPPER(SUBSTRING(SUBSTRING_INDEX(`Setting`.`key`, '.', -1), 1, 1)), LOWER(SUBSTRING(SUBSTRING_INDEX(`Setting`.`key`, '.', -1) FROM 2))), '_', ' ')) AS `Setting__tinyMceOption` FROM `bccolleges_database`.`settings` AS `Setting` WHERE `Setting`.`key` = 'Social_Media.facebook' LIMIT 1 | 1 | 1 | 0 | |
| SELECT `Image`.`id`, `Image`.`model`, `Image`.`foreign_key`, `Image`.`dirname`, `Image`.`basename`, `Image`.`checksum`, `Image`.`alternative`, `Image`.`group`, `Image`.`created`, `Image`.`modified`, `Image`.`rank`, `Image`.`deleted`, `Image`.`deleted_date`, (CONCAT_WS("/", dirname, basename)) AS `Image__path` FROM `bccolleges_database`.`attachments` AS `Image` WHERE `Image`.`model` = 'Setting' AND `Image`.`group` = 'Image' AND `Image`.`foreign_key` = (44) ORDER BY `Image`.`rank` ASC, `Image`.`id` ASC | 0 | 0 | 0 | |
| SELECT `Document`.`id`, `Document`.`model`, `Document`.`foreign_key`, `Document`.`dirname`, `Document`.`basename`, `Document`.`checksum`, `Document`.`alternative`, `Document`.`group`, `Document`.`created`, `Document`.`modified`, `Document`.`rank`, `Document`.`deleted`, `Document`.`deleted_date`, (CONCAT_WS("/", dirname, basename)) AS `Document__path` FROM `bccolleges_database`.`attachments` AS `Document` WHERE `Document`.`model` = 'Setting' AND `Document`.`group` = 'Document' AND `Document`.`foreign_key` = (44) ORDER BY `Document`.`rank` ASC | 0 | 0 | 0 | |
| SELECT `Setting`.`id`, `Setting`.`created`, `Setting`.`modified`, `Setting`.`key`, `Setting`.`value`, `Setting`.`title`, `Setting`.`description`, `Setting`.`type`, `Setting`.`editable`, `Setting`.`super_admin`, `Setting`.`options`, `Setting`.`method`, `Setting`.`display`, (REPLACE(CONCAT(UPPER(SUBSTRING(SUBSTRING_INDEX(`Setting`.`key`, '.', -1), 1, 1)), LOWER(SUBSTRING(SUBSTRING_INDEX(`Setting`.`key`, '.', -1) FROM 2))), '_', ' ')) AS `Setting__tinyMceOption` FROM `bccolleges_database`.`settings` AS `Setting` WHERE `Setting`.`key` = 'Social_Media.facebook' LIMIT 1 | 1 | 1 | 0 | |
| SELECT `Image`.`id`, `Image`.`model`, `Image`.`foreign_key`, `Image`.`dirname`, `Image`.`basename`, `Image`.`checksum`, `Image`.`alternative`, `Image`.`group`, `Image`.`created`, `Image`.`modified`, `Image`.`rank`, `Image`.`deleted`, `Image`.`deleted_date`, (CONCAT_WS("/", dirname, basename)) AS `Image__path` FROM `bccolleges_database`.`attachments` AS `Image` WHERE `Image`.`model` = 'Setting' AND `Image`.`group` = 'Image' AND `Image`.`foreign_key` = (44) ORDER BY `Image`.`rank` ASC, `Image`.`id` ASC | 0 | 0 | 0 | |
| SELECT `Document`.`id`, `Document`.`model`, `Document`.`foreign_key`, `Document`.`dirname`, `Document`.`basename`, `Document`.`checksum`, `Document`.`alternative`, `Document`.`group`, `Document`.`created`, `Document`.`modified`, `Document`.`rank`, `Document`.`deleted`, `Document`.`deleted_date`, (CONCAT_WS("/", dirname, basename)) AS `Document__path` FROM `bccolleges_database`.`attachments` AS `Document` WHERE `Document`.`model` = 'Setting' AND `Document`.`group` = 'Document' AND `Document`.`foreign_key` = (44) ORDER BY `Document`.`rank` ASC | 0 | 0 | 0 | |
| SELECT `Setting`.`id`, `Setting`.`created`, `Setting`.`modified`, `Setting`.`key`, `Setting`.`value`, `Setting`.`title`, `Setting`.`description`, `Setting`.`type`, `Setting`.`editable`, `Setting`.`super_admin`, `Setting`.`options`, `Setting`.`method`, `Setting`.`display`, (REPLACE(CONCAT(UPPER(SUBSTRING(SUBSTRING_INDEX(`Setting`.`key`, '.', -1), 1, 1)), LOWER(SUBSTRING(SUBSTRING_INDEX(`Setting`.`key`, '.', -1) FROM 2))), '_', ' ')) AS `Setting__tinyMceOption` FROM `bccolleges_database`.`settings` AS `Setting` WHERE `Setting`.`key` = 'Social_Media.linkedin' LIMIT 1 | 1 | 1 | 0 | |
| SELECT `Image`.`id`, `Image`.`model`, `Image`.`foreign_key`, `Image`.`dirname`, `Image`.`basename`, `Image`.`checksum`, `Image`.`alternative`, `Image`.`group`, `Image`.`created`, `Image`.`modified`, `Image`.`rank`, `Image`.`deleted`, `Image`.`deleted_date`, (CONCAT_WS("/", dirname, basename)) AS `Image__path` FROM `bccolleges_database`.`attachments` AS `Image` WHERE `Image`.`model` = 'Setting' AND `Image`.`group` = 'Image' AND `Image`.`foreign_key` = (43) ORDER BY `Image`.`rank` ASC, `Image`.`id` ASC | 0 | 0 | 0 | |
| SELECT `Document`.`id`, `Document`.`model`, `Document`.`foreign_key`, `Document`.`dirname`, `Document`.`basename`, `Document`.`checksum`, `Document`.`alternative`, `Document`.`group`, `Document`.`created`, `Document`.`modified`, `Document`.`rank`, `Document`.`deleted`, `Document`.`deleted_date`, (CONCAT_WS("/", dirname, basename)) AS `Document__path` FROM `bccolleges_database`.`attachments` AS `Document` WHERE `Document`.`model` = 'Setting' AND `Document`.`group` = 'Document' AND `Document`.`foreign_key` = (43) ORDER BY `Document`.`rank` ASC | 0 | 0 | 0 | |
| SELECT `Setting`.`id`, `Setting`.`created`, `Setting`.`modified`, `Setting`.`key`, `Setting`.`value`, `Setting`.`title`, `Setting`.`description`, `Setting`.`type`, `Setting`.`editable`, `Setting`.`super_admin`, `Setting`.`options`, `Setting`.`method`, `Setting`.`display`, (REPLACE(CONCAT(UPPER(SUBSTRING(SUBSTRING_INDEX(`Setting`.`key`, '.', -1), 1, 1)), LOWER(SUBSTRING(SUBSTRING_INDEX(`Setting`.`key`, '.', -1) FROM 2))), '_', ' ')) AS `Setting__tinyMceOption` FROM `bccolleges_database`.`settings` AS `Setting` WHERE `Setting`.`key` = 'Social_Media.linkedin' LIMIT 1 | 1 | 1 | 0 | |
| SELECT `Image`.`id`, `Image`.`model`, `Image`.`foreign_key`, `Image`.`dirname`, `Image`.`basename`, `Image`.`checksum`, `Image`.`alternative`, `Image`.`group`, `Image`.`created`, `Image`.`modified`, `Image`.`rank`, `Image`.`deleted`, `Image`.`deleted_date`, (CONCAT_WS("/", dirname, basename)) AS `Image__path` FROM `bccolleges_database`.`attachments` AS `Image` WHERE `Image`.`model` = 'Setting' AND `Image`.`group` = 'Image' AND `Image`.`foreign_key` = (43) ORDER BY `Image`.`rank` ASC, `Image`.`id` ASC | 0 | 0 | 0 | |
| SELECT `Document`.`id`, `Document`.`model`, `Document`.`foreign_key`, `Document`.`dirname`, `Document`.`basename`, `Document`.`checksum`, `Document`.`alternative`, `Document`.`group`, `Document`.`created`, `Document`.`modified`, `Document`.`rank`, `Document`.`deleted`, `Document`.`deleted_date`, (CONCAT_WS("/", dirname, basename)) AS `Document__path` FROM `bccolleges_database`.`attachments` AS `Document` WHERE `Document`.`model` = 'Setting' AND `Document`.`group` = 'Document' AND `Document`.`foreign_key` = (43) ORDER BY `Document`.`rank` ASC | 0 | 0 | 0 | |
| SELECT `Setting`.`id`, `Setting`.`created`, `Setting`.`modified`, `Setting`.`key`, `Setting`.`value`, `Setting`.`title`, `Setting`.`description`, `Setting`.`type`, `Setting`.`editable`, `Setting`.`super_admin`, `Setting`.`options`, `Setting`.`method`, `Setting`.`display`, (REPLACE(CONCAT(UPPER(SUBSTRING(SUBSTRING_INDEX(`Setting`.`key`, '.', -1), 1, 1)), LOWER(SUBSTRING(SUBSTRING_INDEX(`Setting`.`key`, '.', -1) FROM 2))), '_', ' ')) AS `Setting__tinyMceOption` FROM `bccolleges_database`.`settings` AS `Setting` WHERE `Setting`.`key` = 'Site.Contact.address' LIMIT 1 | 1 | 1 | 0 | |
| SELECT `Image`.`id`, `Image`.`model`, `Image`.`foreign_key`, `Image`.`dirname`, `Image`.`basename`, `Image`.`checksum`, `Image`.`alternative`, `Image`.`group`, `Image`.`created`, `Image`.`modified`, `Image`.`rank`, `Image`.`deleted`, `Image`.`deleted_date`, (CONCAT_WS("/", dirname, basename)) AS `Image__path` FROM `bccolleges_database`.`attachments` AS `Image` WHERE `Image`.`model` = 'Setting' AND `Image`.`group` = 'Image' AND `Image`.`foreign_key` = (9) ORDER BY `Image`.`rank` ASC, `Image`.`id` ASC | 0 | 0 | 0 | |
| SELECT `Document`.`id`, `Document`.`model`, `Document`.`foreign_key`, `Document`.`dirname`, `Document`.`basename`, `Document`.`checksum`, `Document`.`alternative`, `Document`.`group`, `Document`.`created`, `Document`.`modified`, `Document`.`rank`, `Document`.`deleted`, `Document`.`deleted_date`, (CONCAT_WS("/", dirname, basename)) AS `Document__path` FROM `bccolleges_database`.`attachments` AS `Document` WHERE `Document`.`model` = 'Setting' AND `Document`.`group` = 'Document' AND `Document`.`foreign_key` = (9) ORDER BY `Document`.`rank` ASC | 0 | 0 | 0 | |
| SELECT `Setting`.`id`, `Setting`.`created`, `Setting`.`modified`, `Setting`.`key`, `Setting`.`value`, `Setting`.`title`, `Setting`.`description`, `Setting`.`type`, `Setting`.`editable`, `Setting`.`super_admin`, `Setting`.`options`, `Setting`.`method`, `Setting`.`display`, (REPLACE(CONCAT(UPPER(SUBSTRING(SUBSTRING_INDEX(`Setting`.`key`, '.', -1), 1, 1)), LOWER(SUBSTRING(SUBSTRING_INDEX(`Setting`.`key`, '.', -1) FROM 2))), '_', ' ')) AS `Setting__tinyMceOption` FROM `bccolleges_database`.`settings` AS `Setting` WHERE `Setting`.`key` = 'Site.Contact.city' LIMIT 1 | 1 | 1 | 0 | |
| SELECT `Image`.`id`, `Image`.`model`, `Image`.`foreign_key`, `Image`.`dirname`, `Image`.`basename`, `Image`.`checksum`, `Image`.`alternative`, `Image`.`group`, `Image`.`created`, `Image`.`modified`, `Image`.`rank`, `Image`.`deleted`, `Image`.`deleted_date`, (CONCAT_WS("/", dirname, basename)) AS `Image__path` FROM `bccolleges_database`.`attachments` AS `Image` WHERE `Image`.`model` = 'Setting' AND `Image`.`group` = 'Image' AND `Image`.`foreign_key` = (10) ORDER BY `Image`.`rank` ASC, `Image`.`id` ASC | 0 | 0 | 0 | |
| SELECT `Document`.`id`, `Document`.`model`, `Document`.`foreign_key`, `Document`.`dirname`, `Document`.`basename`, `Document`.`checksum`, `Document`.`alternative`, `Document`.`group`, `Document`.`created`, `Document`.`modified`, `Document`.`rank`, `Document`.`deleted`, `Document`.`deleted_date`, (CONCAT_WS("/", dirname, basename)) AS `Document__path` FROM `bccolleges_database`.`attachments` AS `Document` WHERE `Document`.`model` = 'Setting' AND `Document`.`group` = 'Document' AND `Document`.`foreign_key` = (10) ORDER BY `Document`.`rank` ASC | 0 | 0 | 0 | |
| SELECT `Setting`.`id`, `Setting`.`created`, `Setting`.`modified`, `Setting`.`key`, `Setting`.`value`, `Setting`.`title`, `Setting`.`description`, `Setting`.`type`, `Setting`.`editable`, `Setting`.`super_admin`, `Setting`.`options`, `Setting`.`method`, `Setting`.`display`, (REPLACE(CONCAT(UPPER(SUBSTRING(SUBSTRING_INDEX(`Setting`.`key`, '.', -1), 1, 1)), LOWER(SUBSTRING(SUBSTRING_INDEX(`Setting`.`key`, '.', -1) FROM 2))), '_', ' ')) AS `Setting__tinyMceOption` FROM `bccolleges_database`.`settings` AS `Setting` WHERE `Setting`.`key` = 'Site.Contact.province_state' LIMIT 1 | 1 | 1 | 0 | |
| SELECT `Image`.`id`, `Image`.`model`, `Image`.`foreign_key`, `Image`.`dirname`, `Image`.`basename`, `Image`.`checksum`, `Image`.`alternative`, `Image`.`group`, `Image`.`created`, `Image`.`modified`, `Image`.`rank`, `Image`.`deleted`, `Image`.`deleted_date`, (CONCAT_WS("/", dirname, basename)) AS `Image__path` FROM `bccolleges_database`.`attachments` AS `Image` WHERE `Image`.`model` = 'Setting' AND `Image`.`group` = 'Image' AND `Image`.`foreign_key` = (11) ORDER BY `Image`.`rank` ASC, `Image`.`id` ASC | 0 | 0 | 0 | |
| SELECT `Document`.`id`, `Document`.`model`, `Document`.`foreign_key`, `Document`.`dirname`, `Document`.`basename`, `Document`.`checksum`, `Document`.`alternative`, `Document`.`group`, `Document`.`created`, `Document`.`modified`, `Document`.`rank`, `Document`.`deleted`, `Document`.`deleted_date`, (CONCAT_WS("/", dirname, basename)) AS `Document__path` FROM `bccolleges_database`.`attachments` AS `Document` WHERE `Document`.`model` = 'Setting' AND `Document`.`group` = 'Document' AND `Document`.`foreign_key` = (11) ORDER BY `Document`.`rank` ASC | 0 | 0 | 0 | |
| SELECT `Setting`.`id`, `Setting`.`created`, `Setting`.`modified`, `Setting`.`key`, `Setting`.`value`, `Setting`.`title`, `Setting`.`description`, `Setting`.`type`, `Setting`.`editable`, `Setting`.`super_admin`, `Setting`.`options`, `Setting`.`method`, `Setting`.`display`, (REPLACE(CONCAT(UPPER(SUBSTRING(SUBSTRING_INDEX(`Setting`.`key`, '.', -1), 1, 1)), LOWER(SUBSTRING(SUBSTRING_INDEX(`Setting`.`key`, '.', -1) FROM 2))), '_', ' ')) AS `Setting__tinyMceOption` FROM `bccolleges_database`.`settings` AS `Setting` WHERE `Setting`.`key` = 'Site.Contact.postal_zip' LIMIT 1 | 1 | 1 | 0 | |
| SELECT `Image`.`id`, `Image`.`model`, `Image`.`foreign_key`, `Image`.`dirname`, `Image`.`basename`, `Image`.`checksum`, `Image`.`alternative`, `Image`.`group`, `Image`.`created`, `Image`.`modified`, `Image`.`rank`, `Image`.`deleted`, `Image`.`deleted_date`, (CONCAT_WS("/", dirname, basename)) AS `Image__path` FROM `bccolleges_database`.`attachments` AS `Image` WHERE `Image`.`model` = 'Setting' AND `Image`.`group` = 'Image' AND `Image`.`foreign_key` = (12) ORDER BY `Image`.`rank` ASC, `Image`.`id` ASC | 0 | 0 | 0 | |
| SELECT `Document`.`id`, `Document`.`model`, `Document`.`foreign_key`, `Document`.`dirname`, `Document`.`basename`, `Document`.`checksum`, `Document`.`alternative`, `Document`.`group`, `Document`.`created`, `Document`.`modified`, `Document`.`rank`, `Document`.`deleted`, `Document`.`deleted_date`, (CONCAT_WS("/", dirname, basename)) AS `Document__path` FROM `bccolleges_database`.`attachments` AS `Document` WHERE `Document`.`model` = 'Setting' AND `Document`.`group` = 'Document' AND `Document`.`foreign_key` = (12) ORDER BY `Document`.`rank` ASC | 0 | 0 | 0 | |
| SELECT `Setting`.`id`, `Setting`.`created`, `Setting`.`modified`, `Setting`.`key`, `Setting`.`value`, `Setting`.`title`, `Setting`.`description`, `Setting`.`type`, `Setting`.`editable`, `Setting`.`super_admin`, `Setting`.`options`, `Setting`.`method`, `Setting`.`display`, (REPLACE(CONCAT(UPPER(SUBSTRING(SUBSTRING_INDEX(`Setting`.`key`, '.', -1), 1, 1)), LOWER(SUBSTRING(SUBSTRING_INDEX(`Setting`.`key`, '.', -1) FROM 2))), '_', ' ')) AS `Setting__tinyMceOption` FROM `bccolleges_database`.`settings` AS `Setting` WHERE `Setting`.`key` = 'Site.Contact.phone' LIMIT 1 | 1 | 1 | 0 | |
| SELECT `Image`.`id`, `Image`.`model`, `Image`.`foreign_key`, `Image`.`dirname`, `Image`.`basename`, `Image`.`checksum`, `Image`.`alternative`, `Image`.`group`, `Image`.`created`, `Image`.`modified`, `Image`.`rank`, `Image`.`deleted`, `Image`.`deleted_date`, (CONCAT_WS("/", dirname, basename)) AS `Image__path` FROM `bccolleges_database`.`attachments` AS `Image` WHERE `Image`.`model` = 'Setting' AND `Image`.`group` = 'Image' AND `Image`.`foreign_key` = (14) ORDER BY `Image`.`rank` ASC, `Image`.`id` ASC | 0 | 0 | 0 | |
| SELECT `Document`.`id`, `Document`.`model`, `Document`.`foreign_key`, `Document`.`dirname`, `Document`.`basename`, `Document`.`checksum`, `Document`.`alternative`, `Document`.`group`, `Document`.`created`, `Document`.`modified`, `Document`.`rank`, `Document`.`deleted`, `Document`.`deleted_date`, (CONCAT_WS("/", dirname, basename)) AS `Document__path` FROM `bccolleges_database`.`attachments` AS `Document` WHERE `Document`.`model` = 'Setting' AND `Document`.`group` = 'Document' AND `Document`.`foreign_key` = (14) ORDER BY `Document`.`rank` ASC | 0 | 0 | 0 | |
| SELECT `NavigationMenuItem`.`id`, `NavigationMenuItem`.`created`, `NavigationMenuItem`.`modified`, `NavigationMenuItem`.`name`, `NavigationMenuItem`.`parent_id`, `NavigationMenuItem`.`lft`, `NavigationMenuItem`.`rght`, `NavigationMenuItem`.`navigation_menu_id`, `NavigationMenuItem`.`url`, `NavigationMenuItem`.`target_page`, `NavigationMenuItem`.`rank`, `NavigationMenuItem`.`foreign_model`, `NavigationMenuItem`.`foreign_key`, `NavigationMenuItem`.`new_window`, `NavigationMenuItem`.`foreign_plugin`, `NavigationMenuItem`.`deleted`, `NavigationMenuItem`.`deleted_date`, `PublishingInformation`.`id`, `PublishingInformation`.`created`, `PublishingInformation`.`modified`, `PublishingInformation`.`model`, `PublishingInformation`.`foreign_key`, `PublishingInformation`.`start`, `PublishingInformation`.`end`, `PublishingInformation`.`published` FROM `bccolleges_database`.`navigation_menu_items` AS `NavigationMenuItem` LEFT JOIN `bccolleges_database`.`publishing_information` AS `PublishingInformation` ON (`PublishingInformation`.`foreign_key` = `NavigationMenuItem`.`id` AND `PublishingInformation`.`model` = 'NavigationMenuItem') WHERE `NavigationMenuItem`.`navigation_menu_id` = 2 AND `NavigationMenuItem`.`deleted` = '0' ORDER BY `NavigationMenuItem`.`lft` ASC | 4 | 4 | 0 | |
| SELECT `Group`.`id`, `Group`.`name`, `Group`.`created`, `Group`.`modified`, `Group`.`login_redirect`, `Group`.`rank`, `Group`.`deleted`, `Group`.`deleted_date` FROM `bccolleges_database`.`groups` AS `Group` WHERE `Group`.`name` = 'Unregistered' AND `Group`.`deleted` = '0' ORDER BY `Group`.`rank` ASC, `Group`.`id` ASC, `Group`.`rank` ASC LIMIT 1 | 0 | 0 | 0 | |
| SELECT `CmsPlugin`.`id`, `CmsPlugin`.`created`, `CmsPlugin`.`modified`, `CmsPlugin`.`name`, `CmsPlugin`.`alias`, `CmsPlugin`.`slug`, `CmsPlugin`.`description`, `CmsPlugin`.`active`, `CmsPlugin`.`layout`, `CmsPlugin`.`theme`, `CmsPlugin`.`internal`, `CmsPlugin`.`schema_version`, `CmsPlugin`.`core` FROM `bccolleges_database`.`installed_plugins` AS `CmsPlugin` WHERE `name` = 'Responsive' LIMIT 1 | 1 | 1 | 0 |
Peak Memory Use 34.62 MB
| Message | Memory use |
|---|---|
| Component initialization | 12.13 MB |
| Controller action start | 14.33 MB |
| Controller render start | 17.75 MB |
| View render complete | 25.09 MB |
Total Request Time: 363 (ms)
| Message | Time in ms | Graph |
|---|---|---|
| Core Processing (Derived from $_SERVER["REQUEST_TIME"]) | 68.02 | |
| Component initialization and startup | 10.08 | |
| Controller action | 24.23 | |
| Render Controller Action | 141.73 | |
| » Rendering View | 129.99 | |
| » » Rendering APP/Plugin/Blog/View/BlogPosts/index.ctp | 4.91 | |
| » » Rendering APP/View/Layouts/default.ctp | 96.03 | |
| » » » Rendering APP/View/Elements/layout/header.ctp | 50.44 | |
| » » » » Rendering APP/View/Elements/gtm_head.ctp | 0.25 | |
| » » » » Rendering CORE/working/lib/Cms/Plugin/Blog/View/Elements/metas.ctp | 0.22 | |
| » » » » Rendering APP/View/Elements/gtm_body.ctp | 0.16 | |
| » » » » Rendering APP/View/Elements/svg/twitter.ctp | 0.16 | |
| » » » » Rendering APP/View/Elements/svg/instagram.ctp | 0.20 | |
| » » » » Rendering APP/View/Elements/svg/facebook.ctp | 0.15 | |
| » » » » Rendering APP/View/Elements/svg/linkedin.ctp | 0.16 | |
| » » » Rendering APP/View/Elements/layout/default-sidebar.ctp | 4.62 | |
| » » » Rendering APP/View/Elements/layout/footer.ctp | 34.98 | |
| » » » » Rendering APP/View/Elements/enews.ctp | 1.43 | |
| » » » » Rendering APP/View/Elements/svg/twitter.ctp #2 | 0.17 | |
| » » » » Rendering APP/View/Elements/svg/instagram.ctp #2 | 0.25 | |
| » » » » Rendering APP/View/Elements/svg/facebook.ctp #2 | 0.16 | |
| » » » » Rendering APP/View/Elements/svg/linkedin.ctp #2 | 0.16 |
| Time | Message |
|---|---|
| 2022-05-17 00:24:33 | Array ( [successful_login] => false ) |
| 2022-05-17 00:24:33 | Array ( [successful_login] => false ) |
| 2022-05-17 00:24:33 | Array ( [successful_login] => false ) |
