First Presbyterian Church of Amarillo | Worship | Grow | Connect

CFM Mission Statement
We strive to supplement the family in nurturing children to become fully devoted followers of Jesus Christ.

We desire for each child to know:
• I need to make a wise choice based on the truth of the Bible.
• I can trust God no matter what.
• I should treat others the way I want to be treated.

Latest News: Bach's Lunch Series is Back!
Latest News: NUFF's Monthly Program: Amarillo Legacy
Latest News: Parent's Night Out
Latest News: Upcoming Preaching Schedule
Latest News: Volunteers Needed to Take Blood Pressures

(default) 38 queries took 28 ms
Nr	Query	Affected	Num. rows	Took (ms)
1	DESCRIBE `aros`	7	7	1
2	DESCRIBE `acos`	7	7	1
3	DESCRIBE `aros_acos`	7	7	1
4	DESCRIBE `page_links`	10	10	1
5	DESCRIBE `page_pages`	12	12	1
6	DESCRIBE `page_templates`	7	7	1
7	DESCRIBE `page_subtemplates`	6	6	1
8	DESCRIBE `page_elements`	7	7	1
9	DESCRIBE `page_plugins`	6	6	1
10	SELECT `Page`.`id`, `Page`.`template_id`, `Page`.`parent_id`, `Page`.`lft`, `Page`.`rght`, `Page`.`title`, `Page`.`slug`, `Page`.`url`, `Page`.`hidden`, `Page`.`deleted`, `Page`.`created`, `Page`.`modified`, `Parent`.`id`, `Parent`.`template_id`, `Parent`.`parent_id`, `Parent`.`lft`, `Parent`.`rght`, `Parent`.`title`, `Parent`.`slug`, `Parent`.`url`, `Parent`.`hidden`, `Parent`.`deleted`, `Parent`.`created`, `Parent`.`modified`, `Template`.`id`, `Template`.`title`, `Template`.`layout_file`, `Template`.`html`, `Template`.`preview_img`, `Template`.`created`, `Template`.`modified` FROM `page_pages` AS `Page` LEFT JOIN `page_pages` AS `Parent` ON (`Page`.`parent_id` = `Parent`.`id` AND `Page`.`deleted` IS NULL) LEFT JOIN `page_templates` AS `Template` ON (`Page`.`template_id` = `Template`.`id`) WHERE `Page`.`deleted` IS NULL ORDER BY `Page`.`lft` ASC	83	83	0
11	SELECT `PageLinks`.`id`, `PageLinks`.`parent_id`, `PageLinks`.`lft`, `PageLinks`.`rght`, `PageLinks`.`page_id`, `PageLinks`.`element_id`, `PageLinks`.`subtemplate_id`, `PageLinks`.`field`, `PageLinks`.`created`, `PageLinks`.`modified` FROM `page_links` AS `PageLinks` WHERE `PageLinks`.`page_id` IN (1, 2, 34, 11, 10, 9, 3, 19, 112, 48, 107, 108, 109, 20, 49, 82, 4, 13, 77, 78, 64, 55, 81, 63, 35, 62, 14, 86, 124, 129, 106, 113, 122, 128, 15, 67, 68, 73, 84, 127, 120, 121, 74, 130, 132, 89, 50, 16, 90, 91, 92, 93, 117, 17, 71, 87, 66, 72, 114, 5, 6, 53, 7, 54, 116, 52, 111, 123, 125, 126, 8, 115, 51, 65, 98, 99, 103, 104, 105, 100, 101, 102, 131) ORDER BY `PageLinks`.`lft` ASC	145	145	1
12	SELECT `Page`.`id`, `Page`.`template_id`, `Page`.`parent_id`, `Page`.`lft`, `Page`.`rght`, `Page`.`title`, `Page`.`slug`, `Page`.`url`, `Page`.`hidden`, `Page`.`deleted`, `Page`.`created`, `Page`.`modified`, `Parent`.`id`, `Parent`.`template_id`, `Parent`.`parent_id`, `Parent`.`lft`, `Parent`.`rght`, `Parent`.`title`, `Parent`.`slug`, `Parent`.`url`, `Parent`.`hidden`, `Parent`.`deleted`, `Parent`.`created`, `Parent`.`modified`, `Template`.`id`, `Template`.`title`, `Template`.`layout_file`, `Template`.`html`, `Template`.`preview_img`, `Template`.`created`, `Template`.`modified` FROM `page_pages` AS `Page` LEFT JOIN `page_pages` AS `Parent` ON (`Page`.`parent_id` = `Parent`.`id` AND `Page`.`deleted` IS NULL) LEFT JOIN `page_templates` AS `Template` ON (`Page`.`template_id` = `Template`.`id`) WHERE `Page`.`slug` = 'cfm-mission-statements' AND `Page`.`deleted` IS NULL ORDER BY `Page`.`lft` ASC LIMIT 1	1	1	0
13	SELECT `PageLinks`.`id`, `PageLinks`.`parent_id`, `PageLinks`.`lft`, `PageLinks`.`rght`, `PageLinks`.`page_id`, `PageLinks`.`element_id`, `PageLinks`.`subtemplate_id`, `PageLinks`.`field`, `PageLinks`.`created`, `PageLinks`.`modified` FROM `page_links` AS `PageLinks` WHERE `PageLinks`.`page_id` = (77) ORDER BY `PageLinks`.`lft` ASC	2	2	0
14	SELECT `Page`.`id`, `Page`.`template_id`, `Page`.`parent_id`, `Page`.`lft`, `Page`.`rght`, `Page`.`title`, `Page`.`slug`, `Page`.`url`, `Page`.`hidden`, `Page`.`deleted`, `Page`.`created`, `Page`.`modified`, `Parent`.`id`, `Parent`.`template_id`, `Parent`.`parent_id`, `Parent`.`lft`, `Parent`.`rght`, `Parent`.`title`, `Parent`.`slug`, `Parent`.`url`, `Parent`.`hidden`, `Parent`.`deleted`, `Parent`.`created`, `Parent`.`modified`, `Template`.`id`, `Template`.`title`, `Template`.`layout_file`, `Template`.`html`, `Template`.`preview_img`, `Template`.`created`, `Template`.`modified` FROM `page_pages` AS `Page` LEFT JOIN `page_pages` AS `Parent` ON (`Page`.`parent_id` = `Parent`.`id` AND `Page`.`deleted` IS NULL) LEFT JOIN `page_templates` AS `Template` ON (`Page`.`template_id` = `Template`.`id`) WHERE `Page`.`parent_id` = 77 AND `Page`.`deleted` IS NULL AND `Page`.`hidden` = 0 ORDER BY `Page`.`lft` ASC	0	0	0
15	SELECT `PageTemplate`.`id`, `PageTemplate`.`title`, `PageTemplate`.`layout_file`, `PageTemplate`.`html`, `PageTemplate`.`preview_img`, `PageTemplate`.`created`, `PageTemplate`.`modified` FROM `page_templates` AS `PageTemplate` WHERE `PageTemplate`.`id` = 1 LIMIT 1	1	1	0
16	SELECT `PageLink`.`id`, `PageLink`.`parent_id`, `PageLink`.`lft`, `PageLink`.`rght`, `PageLink`.`page_id`, `PageLink`.`element_id`, `PageLink`.`subtemplate_id`, `PageLink`.`field`, `PageLink`.`created`, `PageLink`.`modified` FROM `page_links` AS `PageLink` WHERE `PageLink`.`page_id` = 77	2	2	0
17	SELECT `PageElement`.`id`, `PageElement`.`plugin_id`, `PageElement`.`plugin_vars`, `PageElement`.`content`, `PageElement`.`deleted`, `PageElement`.`created`, `PageElement`.`modified` FROM `page_elements` AS `PageElement` WHERE `PageElement`.`id` = 64 AND `PageElement`.`deleted` IS NULL LIMIT 1	1	1	0
18	SELECT `PageElement`.`id`, `PageElement`.`plugin_id`, `PageElement`.`plugin_vars`, `PageElement`.`content`, `PageElement`.`deleted`, `PageElement`.`created`, `PageElement`.`modified` FROM `page_elements` AS `PageElement` WHERE `PageElement`.`id` = 97 AND `PageElement`.`deleted` IS NULL LIMIT 1	1	1	0
19	SELECT `Page`.`id`, `Page`.`template_id`, `Page`.`parent_id`, `Page`.`lft`, `Page`.`rght`, `Page`.`title`, `Page`.`slug`, `Page`.`url`, `Page`.`hidden`, `Page`.`deleted`, `Page`.`created`, `Page`.`modified`, `Parent`.`id`, `Parent`.`template_id`, `Parent`.`parent_id`, `Parent`.`lft`, `Parent`.`rght`, `Parent`.`title`, `Parent`.`slug`, `Parent`.`url`, `Parent`.`hidden`, `Parent`.`deleted`, `Parent`.`created`, `Parent`.`modified`, `Template`.`id`, `Template`.`title`, `Template`.`layout_file`, `Template`.`html`, `Template`.`preview_img`, `Template`.`created`, `Template`.`modified` FROM `page_pages` AS `Page` LEFT JOIN `page_pages` AS `Parent` ON (`Page`.`parent_id` = `Parent`.`id` AND `Page`.`deleted` IS NULL) LEFT JOIN `page_templates` AS `Template` ON (`Page`.`template_id` = `Template`.`id`) WHERE `Page`.`deleted` IS NULL AND `Page`.`hidden` = 0 ORDER BY `Page`.`lft` ASC	72	72	0
20	SELECT `PageLinks`.`id`, `PageLinks`.`parent_id`, `PageLinks`.`lft`, `PageLinks`.`rght`, `PageLinks`.`page_id`, `PageLinks`.`element_id`, `PageLinks`.`subtemplate_id`, `PageLinks`.`field`, `PageLinks`.`created`, `PageLinks`.`modified` FROM `page_links` AS `PageLinks` WHERE `PageLinks`.`page_id` IN (1, 2, 34, 11, 10, 9, 3, 19, 112, 48, 107, 108, 109, 20, 49, 82, 4, 13, 77, 78, 64, 55, 81, 63, 35, 62, 14, 86, 129, 128, 15, 67, 68, 73, 84, 127, 74, 130, 89, 16, 50, 90, 91, 92, 93, 117, 17, 71, 87, 66, 72, 114, 5, 6, 53, 7, 54, 116, 52, 111, 125, 8, 51, 65, 99, 103, 104, 105, 100, 101, 102, 131) ORDER BY `PageLinks`.`lft` ASC	125	125	0
21	DESCRIBE `announcement_articles`	13	13	1
22	DESCRIBE `user_users`	21	21	1
23	DESCRIBE `user_groups`	4	4	1
24	DESCRIBE `user_payment_profiles`	17	17	1
25	DESCRIBE `contribute_contributions`	11	11	1
26	DESCRIBE `contribute_line_items`	7	7	1
27	DESCRIBE `contribute_funds`	6	6	1
28	DESCRIBE `contribute_transactions`	8	8	1
29	DESCRIBE `media_files`	10	10	1
30	DESCRIBE `media_types`	4	4	1
31	DESCRIBE `tags`	5	5	1
32	DESCRIBE `media_rollers`	7	7	1
33	DESCRIBE `media_files_rollers`	6	6	1
34	DESCRIBE `media_galleries`	4	4	1
35	DESCRIBE `media_files_galleries`	6	6	1
36	DESCRIBE `media_files_tags`	5	5	1
37	SELECT COUNT(*) AS `count` FROM `announcement_articles` AS `Announcement` LEFT JOIN `user_users` AS `User` ON (`Announcement`.`user_id` = `User`.`id`) LEFT JOIN `media_files` AS `Media` ON (`Announcement`.`media_id` = `Media`.`id`) WHERE `Announcement`.`deleted` IS NULL AND `Announcement`.`start` < '2010-03-10 03:25:00'	1	1	1
38	SELECT `Announcement`.`id`, `Announcement`.`title`, `Announcement`.`slug`, `Announcement`.`link`, `Announcement`.`facebox`, `Announcement`.`homepage`, `Announcement`.`body`, `Announcement`.`user_id`, `Announcement`.`media_id`, `Announcement`.`start`, `Announcement`.`deleted`, `Announcement`.`created`, `Announcement`.`modified`, `User`.`id`, `User`.`username`, `User`.`display`, `User`.`password`, `User`.`email`, `User`.`group_id`, `User`.`disabled`, `User`.`authorize_id`, `User`.`first_name`, `User`.`mid_init`, `User`.`last_name`, `User`.`suffix`, `User`.`company`, `User`.`address1`, `User`.`address2`, `User`.`city`, `User`.`state`, `User`.`zip`, `User`.`phone`, `User`.`created`, `User`.`modified`, `Media`.`id`, `Media`.`type_id`, `Media`.`name`, `Media`.`filename`, `Media`.`size`, `Media`.`subtitle`, `Media`.`link`, `Media`.`descr`, `Media`.`created`, `Media`.`modified` FROM `announcement_articles` AS `Announcement` LEFT JOIN `user_users` AS `User` ON (`Announcement`.`user_id` = `User`.`id`) LEFT JOIN `media_files` AS `Media` ON (`Announcement`.`media_id` = `Media`.`id`) WHERE `Announcement`.`deleted` IS NULL AND `Announcement`.`start` < '2010-03-10 03:25:00' ORDER BY `Announcement`.`start` DESC LIMIT 5	5	5	1

(default) 38 queries took 28 ms

Query

Error

Affected

Num. rows

Took (ms)

DESCRIBE `aros`

DESCRIBE `acos`

DESCRIBE `aros_acos`

DESCRIBE `page_links`

DESCRIBE `page_pages`

DESCRIBE `page_templates`

DESCRIBE `page_subtemplates`

DESCRIBE `page_elements`

DESCRIBE `page_plugins`

SELECT `Page`.`id`, `Page`.`template_id`, `Page`.`parent_id`, `Page`.`lft`, `Page`.`rght`, `Page`.`title`, `Page`.`slug`, `Page`.`url`, `Page`.`hidden`, `Page`.`deleted`, `Page`.`created`, `Page`.`modified`, `Parent`.`id`, `Parent`.`template_id`, `Parent`.`parent_id`, `Parent`.`lft`, `Parent`.`rght`, `Parent`.`title`, `Parent`.`slug`, `Parent`.`url`, `Parent`.`hidden`, `Parent`.`deleted`, `Parent`.`created`, `Parent`.`modified`, `Template`.`id`, `Template`.`title`, `Template`.`layout_file`, `Template`.`html`, `Template`.`preview_img`, `Template`.`created`, `Template`.`modified` FROM `page_pages` AS `Page` LEFT JOIN `page_pages` AS `Parent` ON (`Page`.`parent_id` = `Parent`.`id` AND `Page`.`deleted` IS NULL) LEFT JOIN `page_templates` AS `Template` ON (`Page`.`template_id` = `Template`.`id`) WHERE `Page`.`deleted` IS NULL ORDER BY `Page`.`lft` ASC

SELECT `PageLinks`.`id`, `PageLinks`.`parent_id`, `PageLinks`.`lft`, `PageLinks`.`rght`, `PageLinks`.`page_id`, `PageLinks`.`element_id`, `PageLinks`.`subtemplate_id`, `PageLinks`.`field`, `PageLinks`.`created`, `PageLinks`.`modified` FROM `page_links` AS `PageLinks` WHERE `PageLinks`.`page_id` IN (1, 2, 34, 11, 10, 9, 3, 19, 112, 48, 107, 108, 109, 20, 49, 82, 4, 13, 77, 78, 64, 55, 81, 63, 35, 62, 14, 86, 124, 129, 106, 113, 122, 128, 15, 67, 68, 73, 84, 127, 120, 121, 74, 130, 132, 89, 50, 16, 90, 91, 92, 93, 117, 17, 71, 87, 66, 72, 114, 5, 6, 53, 7, 54, 116, 52, 111, 123, 125, 126, 8, 115, 51, 65, 98, 99, 103, 104, 105, 100, 101, 102, 131) ORDER BY `PageLinks`.`lft` ASC

145

SELECT `PageTemplate`.`id`, `PageTemplate`.`title`, `PageTemplate`.`layout_file`, `PageTemplate`.`html`, `PageTemplate`.`preview_img`, `PageTemplate`.`created`, `PageTemplate`.`modified` FROM `page_templates` AS `PageTemplate` WHERE `PageTemplate`.`id` = 1 LIMIT 1

SELECT `PageLink`.`id`, `PageLink`.`parent_id`, `PageLink`.`lft`, `PageLink`.`rght`, `PageLink`.`page_id`, `PageLink`.`element_id`, `PageLink`.`subtemplate_id`, `PageLink`.`field`, `PageLink`.`created`, `PageLink`.`modified` FROM `page_links` AS `PageLink` WHERE `PageLink`.`page_id` = 77

SELECT `PageElement`.`id`, `PageElement`.`plugin_id`, `PageElement`.`plugin_vars`, `PageElement`.`content`, `PageElement`.`deleted`, `PageElement`.`created`, `PageElement`.`modified` FROM `page_elements` AS `PageElement` WHERE `PageElement`.`id` = 64 AND `PageElement`.`deleted` IS NULL LIMIT 1

SELECT `PageLinks`.`id`, `PageLinks`.`parent_id`, `PageLinks`.`lft`, `PageLinks`.`rght`, `PageLinks`.`page_id`, `PageLinks`.`element_id`, `PageLinks`.`subtemplate_id`, `PageLinks`.`field`, `PageLinks`.`created`, `PageLinks`.`modified` FROM `page_links` AS `PageLinks` WHERE `PageLinks`.`page_id` IN (1, 2, 34, 11, 10, 9, 3, 19, 112, 48, 107, 108, 109, 20, 49, 82, 4, 13, 77, 78, 64, 55, 81, 63, 35, 62, 14, 86, 129, 128, 15, 67, 68, 73, 84, 127, 74, 130, 89, 16, 50, 90, 91, 92, 93, 117, 17, 71, 87, 66, 72, 114, 5, 6, 53, 7, 54, 116, 52, 111, 125, 8, 51, 65, 99, 103, 104, 105, 100, 101, 102, 131) ORDER BY `PageLinks`.`lft` ASC

125

DESCRIBE `announcement_articles`

DESCRIBE `user_users`

DESCRIBE `user_groups`

DESCRIBE `user_payment_profiles`

DESCRIBE `contribute_contributions`

DESCRIBE `contribute_line_items`

DESCRIBE `contribute_funds`

DESCRIBE `contribute_transactions`

DESCRIBE `media_files`

DESCRIBE `media_types`

DESCRIBE `tags`

DESCRIBE `media_rollers`

DESCRIBE `media_files_rollers`

DESCRIBE `media_galleries`

DESCRIBE `media_files_galleries`

DESCRIBE `media_files_tags`

SELECT COUNT(*) AS `count` FROM `announcement_articles` AS `Announcement` LEFT JOIN `user_users` AS `User` ON (`Announcement`.`user_id` = `User`.`id`) LEFT JOIN `media_files` AS `Media` ON (`Announcement`.`media_id` = `Media`.`id`) WHERE `Announcement`.`deleted` IS NULL AND `Announcement`.`start` < '2010-03-10 03:25:00'

SELECT `Announcement`.`id`, `Announcement`.`title`, `Announcement`.`slug`, `Announcement`.`link`, `Announcement`.`facebox`, `Announcement`.`homepage`, `Announcement`.`body`, `Announcement`.`user_id`, `Announcement`.`media_id`, `Announcement`.`start`, `Announcement`.`deleted`, `Announcement`.`created`, `Announcement`.`modified`, `User`.`id`, `User`.`username`, `User`.`display`, `User`.`password`, `User`.`email`, `User`.`group_id`, `User`.`disabled`, `User`.`authorize_id`, `User`.`first_name`, `User`.`mid_init`, `User`.`last_name`, `User`.`suffix`, `User`.`company`, `User`.`address1`, `User`.`address2`, `User`.`city`, `User`.`state`, `User`.`zip`, `User`.`phone`, `User`.`created`, `User`.`modified`, `Media`.`id`, `Media`.`type_id`, `Media`.`name`, `Media`.`filename`, `Media`.`size`, `Media`.`subtitle`, `Media`.`link`, `Media`.`descr`, `Media`.`created`, `Media`.`modified` FROM `announcement_articles` AS `Announcement` LEFT JOIN `user_users` AS `User` ON (`Announcement`.`user_id` = `User`.`id`) LEFT JOIN `media_files` AS `Media` ON (`Announcement`.`media_id` = `Media`.`id`) WHERE `Announcement`.`deleted` IS NULL AND `Announcement`.`start` < '2010-03-10 03:25:00' ORDER BY `Announcement`.`start` DESC LIMIT 5

Weekly Events

Sunday Schedule

Contact Us