News

Laugh Your Way To A Better Marriage!

Announcing a marriage seminar in your area! Mark Gungor is coming to a location near you with his hilarious Laugh Your Way to a Better Marriage seminar! We hope you'll join Mark as he teaches couples how to deal with tough issues and make positive changes to their marriage.

Published on 11/01/2009

Return to home

(default) 74 queries took 156 ms
Nr	Query	Affected	Num. rows	Took (ms)
1	DESCRIBE `aros`	7	7	5
2	DESCRIBE `acos`	7	7	4
3	DESCRIBE `aros_acos`	7	7	3
4	DESCRIBE `page_links`	10	10	3
5	DESCRIBE `page_pages`	12	12	3
6	DESCRIBE `page_templates`	7	7	2
7	DESCRIBE `page_subtemplates`	6	6	4
8	DESCRIBE `page_elements`	7	7	7
9	DESCRIBE `page_plugins`	6	6	2
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	9	9	2
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, 6, 7, 4, 8, 5, 9, 11) ORDER BY `PageLinks`.`lft` ASC	10	10	0
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` = 'news' AND `Page`.`deleted` IS NULL ORDER BY `Page`.`lft` ASC LIMIT 1	1	1	1
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` = (9) ORDER BY `PageLinks`.`lft` ASC	1	1	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` = 9 AND `Page`.`deleted` IS NULL AND `Page`.`hidden` = 0 ORDER BY `Page`.`lft` ASC	0	0	1
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` = 9	1	1	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` = 4 AND `PageElement`.`deleted` IS NULL LIMIT 1	1	1	0
18	SELECT `PagePlugin`.`id`, `PagePlugin`.`title`, `PagePlugin`.`format`, `PagePlugin`.`url`, `PagePlugin`.`created`, `PagePlugin`.`modified` FROM `page_plugins` AS `PagePlugin` WHERE `PagePlugin`.`id` = 10 LIMIT 1	1	1	1
19	DESCRIBE `announcement_articles`	13	13	3
20	DESCRIBE `user_users`	21	21	4
21	DESCRIBE `user_groups`	4	4	3
22	DESCRIBE `user_payment_profiles`	17	17	2
23	DESCRIBE `contribute_contributions`	11	11	3
24	DESCRIBE `contribute_line_items`	7	7	3
25	DESCRIBE `contribute_funds`	6	6	5
26	DESCRIBE `contribute_transactions`	8	8	5
27	DESCRIBE `media_files`	10	10	6
28	DESCRIBE `media_types`	4	4	6
29	DESCRIBE `tags`	5	5	3
30	DESCRIBE `media_rollers`	10	10	3
31	DESCRIBE `media_files_rollers`	7	7	4
32	DESCRIBE `media_galleries`	4	4	2
33	DESCRIBE `media_files_galleries`	7	7	1
34	DESCRIBE `media_files_tags`	5	5	3
35	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 08:04:00' AND `Announcement`.`slug` = 'laugh-you-way-to-a-better-marriage'	1	1	1
36	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`.`authorize_id`, `User`.`username`, `User`.`display`, `User`.`password`, `User`.`email`, `User`.`group_id`, `User`.`first_name`, `User`.`mid_init`, `User`.`last_name`, `User`.`company`, `User`.`suffix`, `User`.`address1`, `User`.`address2`, `User`.`city`, `User`.`state`, `User`.`zip`, `User`.`phone`, `User`.`disabled`, `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 08:04:00' AND `Announcement`.`slug` = 'laugh-you-way-to-a-better-marriage' ORDER BY `Announcement`.`start` DESC LIMIT 10	1	1	7
37	SELECT `User`.`id`, `User`.`authorize_id`, `User`.`username`, `User`.`display`, `User`.`password`, `User`.`email`, `User`.`group_id`, `User`.`first_name`, `User`.`mid_init`, `User`.`last_name`, `User`.`company`, `User`.`suffix`, `User`.`address1`, `User`.`address2`, `User`.`city`, `User`.`state`, `User`.`zip`, `User`.`phone`, `User`.`disabled`, `User`.`created`, `User`.`modified` FROM `user_users` AS `User` WHERE `User`.`id` = 28	1	1	4
38	SELECT `UserGroup`.`id`, `UserGroup`.`name`, `UserGroup`.`created`, `UserGroup`.`modified` FROM `user_groups` AS `UserGroup` WHERE `UserGroup`.`id` = 1	1	1	0
39	SELECT `UserPaymentProfile`.`id`, `UserPaymentProfile`.`authorize_id`, `UserPaymentProfile`.`user_id`, `UserPaymentProfile`.`firstName`, `UserPaymentProfile`.`lastName`, `UserPaymentProfile`.`company`, `UserPaymentProfile`.`address`, `UserPaymentProfile`.`city`, `UserPaymentProfile`.`state`, `UserPaymentProfile`.`zip`, `UserPaymentProfile`.`country`, `UserPaymentProfile`.`phoneNumber`, `UserPaymentProfile`.`faxNumber`, `UserPaymentProfile`.`payment_method`, `UserPaymentProfile`.`acct_num`, `UserPaymentProfile`.`created`, `UserPaymentProfile`.`modified` FROM `user_payment_profiles` AS `UserPaymentProfile` WHERE `UserPaymentProfile`.`user_id` = (28)	0	0	1
40	SELECT `Media`.`id`, `Media`.`type_id`, `Media`.`name`, `Media`.`filename`, `Media`.`size`, `Media`.`subtitle`, `Media`.`link`, `Media`.`descr`, `Media`.`created`, `Media`.`modified` FROM `media_files` AS `Media` WHERE `Media`.`id` = 55	1	1	1
41	SELECT `MediaType`.`id`, `MediaType`.`title`, `MediaType`.`created`, `MediaType`.`modified` FROM `media_types` AS `MediaType` WHERE `MediaType`.`id` = 1	1	1	2
42	SELECT `Tag`.`id`, `Tag`.`tag`, `Tag`.`count`, `Tag`.`created`, `Tag`.`modified`, `MediaFilesTag`.`id`, `MediaFilesTag`.`media_id`, `MediaFilesTag`.`tag_id`, `MediaFilesTag`.`created`, `MediaFilesTag`.`modified` FROM `tags` AS `Tag` JOIN `media_files_tags` AS `MediaFilesTag` ON (`MediaFilesTag`.`media_id` = 55 AND `MediaFilesTag`.`tag_id` = `Tag`.`id`) WHERE 1 = 1	0	0	5
43	SELECT `MediaRoller`.`id`, `MediaRoller`.`title`, `MediaRoller`.`animation`, `MediaRoller`.`type`, `MediaRoller`.`speed`, `MediaRoller`.`height`, `MediaRoller`.`width`, `MediaRoller`.`timeout`, `MediaRoller`.`created`, `MediaRoller`.`modified`, `MediaFilesRoller`.`id`, `MediaFilesRoller`.`media_id`, `MediaFilesRoller`.`media_roller_id`, `MediaFilesRoller`.`order`, `MediaFilesRoller`.`link`, `MediaFilesRoller`.`created`, `MediaFilesRoller`.`modified` FROM `media_rollers` AS `MediaRoller` JOIN `media_files_rollers` AS `MediaFilesRoller` ON (`MediaFilesRoller`.`media_id` = 55 AND `MediaFilesRoller`.`media_roller_id` = `MediaRoller`.`id`) WHERE 1 = 1	1	1	1
44	SELECT `MediaGallery`.`id`, `MediaGallery`.`title`, `MediaGallery`.`created`, `MediaGallery`.`modified`, `MediaFilesGallery`.`id`, `MediaFilesGallery`.`media_id`, `MediaFilesGallery`.`media_gallery_id`, `MediaFilesGallery`.`order`, `MediaFilesGallery`.`link`, `MediaFilesGallery`.`created`, `MediaFilesGallery`.`modified` FROM `media_galleries` AS `MediaGallery` JOIN `media_files_galleries` AS `MediaFilesGallery` ON (`MediaFilesGallery`.`media_id` = 55 AND `MediaFilesGallery`.`media_gallery_id` = `MediaGallery`.`id`) WHERE 1 = 1	0	0	1
45	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`.`id` = 9 ORDER BY `Page`.`lft` ASC LIMIT 1	1	1	1
46	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` = (9) ORDER BY `PageLinks`.`lft` ASC	1	1	1
47	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	8	8	1
48	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, 6, 7, 4, 8, 5, 11) ORDER BY `PageLinks`.`lft` ASC	9	9	2
49	DESCRIBE `gallery_galleries`	9	9	3
50	DESCRIBE `gallery_categories`	11	11	2
51	DESCRIBE `gallery_items`	12	12	4
52	SELECT `Gallery`.`id`, `Gallery`.`title`, `Gallery`.`gallery_category_id`, `Gallery`.`media_id`, `Gallery`.`descr`, `Gallery`.`order`, `Gallery`.`created`, `Gallery`.`deleted`, `Gallery`.`modified`, `GalleryCategory`.`id`, `GalleryCategory`.`parent_id`, `GalleryCategory`.`lft`, `GalleryCategory`.`rght`, `GalleryCategory`.`title`, `GalleryCategory`.`media_id`, `GalleryCategory`.`descr`, `GalleryCategory`.`order`, `GalleryCategory`.`created`, `GalleryCategory`.`deleted`, `GalleryCategory`.`modified`, `Media`.`id`, `Media`.`type_id`, `Media`.`name`, `Media`.`filename`, `Media`.`size`, `Media`.`subtitle`, `Media`.`link`, `Media`.`descr`, `Media`.`created`, `Media`.`modified` FROM `gallery_galleries` AS `Gallery` LEFT JOIN `gallery_categories` AS `GalleryCategory` ON (`Gallery`.`gallery_category_id` = `GalleryCategory`.`id`) LEFT JOIN `media_files` AS `Media` ON (`Gallery`.`media_id` = `Media`.`id`) WHERE `Gallery`.`id` = 2 ORDER BY `Gallery`.`order` ASC LIMIT 1	1	1	1
53	SELECT `GalleryCategory`.`id`, `GalleryCategory`.`parent_id`, `GalleryCategory`.`lft`, `GalleryCategory`.`rght`, `GalleryCategory`.`title`, `GalleryCategory`.`media_id`, `GalleryCategory`.`descr`, `GalleryCategory`.`order`, `GalleryCategory`.`created`, `GalleryCategory`.`deleted`, `GalleryCategory`.`modified` FROM `gallery_categories` AS `GalleryCategory` WHERE `GalleryCategory`.`id` = 1	1	1	1
54	SELECT `Gallery`.`id`, `Gallery`.`title`, `Gallery`.`gallery_category_id`, `Gallery`.`media_id`, `Gallery`.`descr`, `Gallery`.`order`, `Gallery`.`created`, `Gallery`.`deleted`, `Gallery`.`modified` FROM `gallery_galleries` AS `Gallery` WHERE `Gallery`.`deleted` IS NULL AND `Gallery`.`gallery_category_id` = (1) ORDER BY `Gallery`.`order` ASC	3	3	7
55	SELECT `GalleryItem`.`id`, `GalleryItem`.`title`, `GalleryItem`.`subtitle`, `GalleryItem`.`descr`, `GalleryItem`.`gallery_id`, `GalleryItem`.`media_id`, `GalleryItem`.`link`, `GalleryItem`.`link_attr`, `GalleryItem`.`order`, `GalleryItem`.`created`, `GalleryItem`.`deleted`, `GalleryItem`.`modified` FROM `gallery_items` AS `GalleryItem` WHERE `GalleryItem`.`gallery_id` = (2) ORDER BY `GalleryItem`.`order` ASC	2	2	0
56	SELECT `Gallery`.`id`, `Gallery`.`title`, `Gallery`.`gallery_category_id`, `Gallery`.`media_id`, `Gallery`.`descr`, `Gallery`.`order`, `Gallery`.`created`, `Gallery`.`deleted`, `Gallery`.`modified` FROM `gallery_galleries` AS `Gallery` WHERE `Gallery`.`id` = 2	1	1	0
57	SELECT `Gallery`.`id`, `Gallery`.`title`, `Gallery`.`gallery_category_id`, `Gallery`.`media_id`, `Gallery`.`descr`, `Gallery`.`order`, `Gallery`.`created`, `Gallery`.`deleted`, `Gallery`.`modified` FROM `gallery_galleries` AS `Gallery` WHERE `Gallery`.`id` = 2	1	1	1
58	SELECT `Media`.`id`, `Media`.`type_id`, `Media`.`name`, `Media`.`filename`, `Media`.`size`, `Media`.`subtitle`, `Media`.`link`, `Media`.`descr`, `Media`.`created`, `Media`.`modified` FROM `media_files` AS `Media` WHERE `Media`.`id` = 30	1	1	1
59	SELECT `Media`.`id`, `Media`.`type_id`, `Media`.`name`, `Media`.`filename`, `Media`.`size`, `Media`.`subtitle`, `Media`.`link`, `Media`.`descr`, `Media`.`created`, `Media`.`modified` FROM `media_files` AS `Media` WHERE `Media`.`id` = 28	1	1	1
60	DESCRIBE `links`	6	6	4
61	SELECT COUNT(*) AS `count` FROM `links` AS `Links` WHERE 1 = 1	1	1	1
62	SELECT `Links`.`id`, `Links`.`title`, `Links`.`url`, `Links`.`order`, `Links`.`created`, `Links`.`modified` FROM `links` AS `Links` WHERE 1 = 1 ORDER BY `Links`.`order` ASC LIMIT 20	7	7	1
63	SELECT `Gallery`.`id`, `Gallery`.`title`, `Gallery`.`gallery_category_id`, `Gallery`.`media_id`, `Gallery`.`descr`, `Gallery`.`order`, `Gallery`.`created`, `Gallery`.`deleted`, `Gallery`.`modified`, `GalleryCategory`.`id`, `GalleryCategory`.`parent_id`, `GalleryCategory`.`lft`, `GalleryCategory`.`rght`, `GalleryCategory`.`title`, `GalleryCategory`.`media_id`, `GalleryCategory`.`descr`, `GalleryCategory`.`order`, `GalleryCategory`.`created`, `GalleryCategory`.`deleted`, `GalleryCategory`.`modified`, `Media`.`id`, `Media`.`type_id`, `Media`.`name`, `Media`.`filename`, `Media`.`size`, `Media`.`subtitle`, `Media`.`link`, `Media`.`descr`, `Media`.`created`, `Media`.`modified` FROM `gallery_galleries` AS `Gallery` LEFT JOIN `gallery_categories` AS `GalleryCategory` ON (`Gallery`.`gallery_category_id` = `GalleryCategory`.`id`) LEFT JOIN `media_files` AS `Media` ON (`Gallery`.`media_id` = `Media`.`id`) WHERE `Gallery`.`id` = 3 ORDER BY `Gallery`.`order` ASC LIMIT 1	1	1	1
64	SELECT `GalleryCategory`.`id`, `GalleryCategory`.`parent_id`, `GalleryCategory`.`lft`, `GalleryCategory`.`rght`, `GalleryCategory`.`title`, `GalleryCategory`.`media_id`, `GalleryCategory`.`descr`, `GalleryCategory`.`order`, `GalleryCategory`.`created`, `GalleryCategory`.`deleted`, `GalleryCategory`.`modified` FROM `gallery_categories` AS `GalleryCategory` WHERE `GalleryCategory`.`id` = 1	1	1	0
65	SELECT `Gallery`.`id`, `Gallery`.`title`, `Gallery`.`gallery_category_id`, `Gallery`.`media_id`, `Gallery`.`descr`, `Gallery`.`order`, `Gallery`.`created`, `Gallery`.`deleted`, `Gallery`.`modified` FROM `gallery_galleries` AS `Gallery` WHERE `Gallery`.`deleted` IS NULL AND `Gallery`.`gallery_category_id` = (1) ORDER BY `Gallery`.`order` ASC	3	3	0
66	SELECT `GalleryItem`.`id`, `GalleryItem`.`title`, `GalleryItem`.`subtitle`, `GalleryItem`.`descr`, `GalleryItem`.`gallery_id`, `GalleryItem`.`media_id`, `GalleryItem`.`link`, `GalleryItem`.`link_attr`, `GalleryItem`.`order`, `GalleryItem`.`created`, `GalleryItem`.`deleted`, `GalleryItem`.`modified` FROM `gallery_items` AS `GalleryItem` WHERE `GalleryItem`.`gallery_id` = (3) ORDER BY `GalleryItem`.`order` ASC	4	4	1
67	SELECT `Gallery`.`id`, `Gallery`.`title`, `Gallery`.`gallery_category_id`, `Gallery`.`media_id`, `Gallery`.`descr`, `Gallery`.`order`, `Gallery`.`created`, `Gallery`.`deleted`, `Gallery`.`modified` FROM `gallery_galleries` AS `Gallery` WHERE `Gallery`.`id` = 3	1	1	0
68	SELECT `Gallery`.`id`, `Gallery`.`title`, `Gallery`.`gallery_category_id`, `Gallery`.`media_id`, `Gallery`.`descr`, `Gallery`.`order`, `Gallery`.`created`, `Gallery`.`deleted`, `Gallery`.`modified` FROM `gallery_galleries` AS `Gallery` WHERE `Gallery`.`id` = 3	1	1	0
69	SELECT `Gallery`.`id`, `Gallery`.`title`, `Gallery`.`gallery_category_id`, `Gallery`.`media_id`, `Gallery`.`descr`, `Gallery`.`order`, `Gallery`.`created`, `Gallery`.`deleted`, `Gallery`.`modified` FROM `gallery_galleries` AS `Gallery` WHERE `Gallery`.`id` = 3	1	1	1
70	SELECT `Gallery`.`id`, `Gallery`.`title`, `Gallery`.`gallery_category_id`, `Gallery`.`media_id`, `Gallery`.`descr`, `Gallery`.`order`, `Gallery`.`created`, `Gallery`.`deleted`, `Gallery`.`modified` FROM `gallery_galleries` AS `Gallery` WHERE `Gallery`.`id` = 3	1	1	3
71	SELECT `Media`.`id`, `Media`.`type_id`, `Media`.`name`, `Media`.`filename`, `Media`.`size`, `Media`.`subtitle`, `Media`.`link`, `Media`.`descr`, `Media`.`created`, `Media`.`modified` FROM `media_files` AS `Media` WHERE `Media`.`id` = 28	1	1	0
72	SELECT `Media`.`id`, `Media`.`type_id`, `Media`.`name`, `Media`.`filename`, `Media`.`size`, `Media`.`subtitle`, `Media`.`link`, `Media`.`descr`, `Media`.`created`, `Media`.`modified` FROM `media_files` AS `Media` WHERE `Media`.`id` = 29	1	1	1
73	SELECT `Media`.`id`, `Media`.`type_id`, `Media`.`name`, `Media`.`filename`, `Media`.`size`, `Media`.`subtitle`, `Media`.`link`, `Media`.`descr`, `Media`.`created`, `Media`.`modified` FROM `media_files` AS `Media` WHERE `Media`.`id` = 30	1	1	0
74	SELECT `Media`.`id`, `Media`.`type_id`, `Media`.`name`, `Media`.`filename`, `Media`.`size`, `Media`.`subtitle`, `Media`.`link`, `Media`.`descr`, `Media`.`created`, `Media`.`modified` FROM `media_files` AS `Media` WHERE `Media`.`id` = 43	1	1	0

(default) 74 queries took 156 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, 6, 7, 4, 8, 5, 9, 11) ORDER BY `PageLinks`.`lft` ASC

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` = 9

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` = 4 AND `PageElement`.`deleted` IS NULL LIMIT 1

SELECT `PagePlugin`.`id`, `PagePlugin`.`title`, `PagePlugin`.`format`, `PagePlugin`.`url`, `PagePlugin`.`created`, `PagePlugin`.`modified` FROM `page_plugins` AS `PagePlugin` WHERE `PagePlugin`.`id` = 10 LIMIT 1

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 08:04:00' AND `Announcement`.`slug` = 'laugh-you-way-to-a-better-marriage'

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`.`authorize_id`, `User`.`username`, `User`.`display`, `User`.`password`, `User`.`email`, `User`.`group_id`, `User`.`first_name`, `User`.`mid_init`, `User`.`last_name`, `User`.`company`, `User`.`suffix`, `User`.`address1`, `User`.`address2`, `User`.`city`, `User`.`state`, `User`.`zip`, `User`.`phone`, `User`.`disabled`, `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 08:04:00' AND `Announcement`.`slug` = 'laugh-you-way-to-a-better-marriage' ORDER BY `Announcement`.`start` DESC LIMIT 10

SELECT `User`.`id`, `User`.`authorize_id`, `User`.`username`, `User`.`display`, `User`.`password`, `User`.`email`, `User`.`group_id`, `User`.`first_name`, `User`.`mid_init`, `User`.`last_name`, `User`.`company`, `User`.`suffix`, `User`.`address1`, `User`.`address2`, `User`.`city`, `User`.`state`, `User`.`zip`, `User`.`phone`, `User`.`disabled`, `User`.`created`, `User`.`modified` FROM `user_users` AS `User` WHERE `User`.`id` = 28

SELECT `UserGroup`.`id`, `UserGroup`.`name`, `UserGroup`.`created`, `UserGroup`.`modified` FROM `user_groups` AS `UserGroup` WHERE `UserGroup`.`id` = 1

SELECT `UserPaymentProfile`.`id`, `UserPaymentProfile`.`authorize_id`, `UserPaymentProfile`.`user_id`, `UserPaymentProfile`.`firstName`, `UserPaymentProfile`.`lastName`, `UserPaymentProfile`.`company`, `UserPaymentProfile`.`address`, `UserPaymentProfile`.`city`, `UserPaymentProfile`.`state`, `UserPaymentProfile`.`zip`, `UserPaymentProfile`.`country`, `UserPaymentProfile`.`phoneNumber`, `UserPaymentProfile`.`faxNumber`, `UserPaymentProfile`.`payment_method`, `UserPaymentProfile`.`acct_num`, `UserPaymentProfile`.`created`, `UserPaymentProfile`.`modified` FROM `user_payment_profiles` AS `UserPaymentProfile` WHERE `UserPaymentProfile`.`user_id` = (28)

SELECT `Media`.`id`, `Media`.`type_id`, `Media`.`name`, `Media`.`filename`, `Media`.`size`, `Media`.`subtitle`, `Media`.`link`, `Media`.`descr`, `Media`.`created`, `Media`.`modified` FROM `media_files` AS `Media` WHERE `Media`.`id` = 55

SELECT `MediaType`.`id`, `MediaType`.`title`, `MediaType`.`created`, `MediaType`.`modified` FROM `media_types` AS `MediaType` WHERE `MediaType`.`id` = 1

SELECT `Tag`.`id`, `Tag`.`tag`, `Tag`.`count`, `Tag`.`created`, `Tag`.`modified`, `MediaFilesTag`.`id`, `MediaFilesTag`.`media_id`, `MediaFilesTag`.`tag_id`, `MediaFilesTag`.`created`, `MediaFilesTag`.`modified` FROM `tags` AS `Tag` JOIN `media_files_tags` AS `MediaFilesTag` ON (`MediaFilesTag`.`media_id` = 55 AND `MediaFilesTag`.`tag_id` = `Tag`.`id`) WHERE 1 = 1

SELECT `MediaRoller`.`id`, `MediaRoller`.`title`, `MediaRoller`.`animation`, `MediaRoller`.`type`, `MediaRoller`.`speed`, `MediaRoller`.`height`, `MediaRoller`.`width`, `MediaRoller`.`timeout`, `MediaRoller`.`created`, `MediaRoller`.`modified`, `MediaFilesRoller`.`id`, `MediaFilesRoller`.`media_id`, `MediaFilesRoller`.`media_roller_id`, `MediaFilesRoller`.`order`, `MediaFilesRoller`.`link`, `MediaFilesRoller`.`created`, `MediaFilesRoller`.`modified` FROM `media_rollers` AS `MediaRoller` JOIN `media_files_rollers` AS `MediaFilesRoller` ON (`MediaFilesRoller`.`media_id` = 55 AND `MediaFilesRoller`.`media_roller_id` = `MediaRoller`.`id`) WHERE 1 = 1

SELECT `MediaGallery`.`id`, `MediaGallery`.`title`, `MediaGallery`.`created`, `MediaGallery`.`modified`, `MediaFilesGallery`.`id`, `MediaFilesGallery`.`media_id`, `MediaFilesGallery`.`media_gallery_id`, `MediaFilesGallery`.`order`, `MediaFilesGallery`.`link`, `MediaFilesGallery`.`created`, `MediaFilesGallery`.`modified` FROM `media_galleries` AS `MediaGallery` JOIN `media_files_galleries` AS `MediaFilesGallery` ON (`MediaFilesGallery`.`media_id` = 55 AND `MediaFilesGallery`.`media_gallery_id` = `MediaGallery`.`id`) WHERE 1 = 1

DESCRIBE `gallery_galleries`

DESCRIBE `gallery_categories`

DESCRIBE `gallery_items`

SELECT `Gallery`.`id`, `Gallery`.`title`, `Gallery`.`gallery_category_id`, `Gallery`.`media_id`, `Gallery`.`descr`, `Gallery`.`order`, `Gallery`.`created`, `Gallery`.`deleted`, `Gallery`.`modified`, `GalleryCategory`.`id`, `GalleryCategory`.`parent_id`, `GalleryCategory`.`lft`, `GalleryCategory`.`rght`, `GalleryCategory`.`title`, `GalleryCategory`.`media_id`, `GalleryCategory`.`descr`, `GalleryCategory`.`order`, `GalleryCategory`.`created`, `GalleryCategory`.`deleted`, `GalleryCategory`.`modified`, `Media`.`id`, `Media`.`type_id`, `Media`.`name`, `Media`.`filename`, `Media`.`size`, `Media`.`subtitle`, `Media`.`link`, `Media`.`descr`, `Media`.`created`, `Media`.`modified` FROM `gallery_galleries` AS `Gallery` LEFT JOIN `gallery_categories` AS `GalleryCategory` ON (`Gallery`.`gallery_category_id` = `GalleryCategory`.`id`) LEFT JOIN `media_files` AS `Media` ON (`Gallery`.`media_id` = `Media`.`id`) WHERE `Gallery`.`id` = 2 ORDER BY `Gallery`.`order` ASC LIMIT 1

SELECT `GalleryCategory`.`id`, `GalleryCategory`.`parent_id`, `GalleryCategory`.`lft`, `GalleryCategory`.`rght`, `GalleryCategory`.`title`, `GalleryCategory`.`media_id`, `GalleryCategory`.`descr`, `GalleryCategory`.`order`, `GalleryCategory`.`created`, `GalleryCategory`.`deleted`, `GalleryCategory`.`modified` FROM `gallery_categories` AS `GalleryCategory` WHERE `GalleryCategory`.`id` = 1

SELECT `Gallery`.`id`, `Gallery`.`title`, `Gallery`.`gallery_category_id`, `Gallery`.`media_id`, `Gallery`.`descr`, `Gallery`.`order`, `Gallery`.`created`, `Gallery`.`deleted`, `Gallery`.`modified` FROM `gallery_galleries` AS `Gallery` WHERE `Gallery`.`deleted` IS NULL AND `Gallery`.`gallery_category_id` = (1) ORDER BY `Gallery`.`order` ASC

SELECT `GalleryItem`.`id`, `GalleryItem`.`title`, `GalleryItem`.`subtitle`, `GalleryItem`.`descr`, `GalleryItem`.`gallery_id`, `GalleryItem`.`media_id`, `GalleryItem`.`link`, `GalleryItem`.`link_attr`, `GalleryItem`.`order`, `GalleryItem`.`created`, `GalleryItem`.`deleted`, `GalleryItem`.`modified` FROM `gallery_items` AS `GalleryItem` WHERE `GalleryItem`.`gallery_id` = (2) ORDER BY `GalleryItem`.`order` ASC

DESCRIBE `links`

SELECT COUNT(*) AS `count` FROM `links` AS `Links` WHERE 1 = 1

SELECT `Links`.`id`, `Links`.`title`, `Links`.`url`, `Links`.`order`, `Links`.`created`, `Links`.`modified` FROM `links` AS `Links` WHERE 1 = 1 ORDER BY `Links`.`order` ASC LIMIT 20

SELECT `Gallery`.`id`, `Gallery`.`title`, `Gallery`.`gallery_category_id`, `Gallery`.`media_id`, `Gallery`.`descr`, `Gallery`.`order`, `Gallery`.`created`, `Gallery`.`deleted`, `Gallery`.`modified` FROM `gallery_galleries` AS `Gallery` WHERE `Gallery`.`deleted` IS NULL AND `Gallery`.`gallery_category_id` = (1) ORDER BY `Gallery`.`order` ASC