Browse
 
Tools Add
Rss Categories
-->

How to Change a Subscription's Plan and Add-ons in Plesk 10

Reference Number: AA-01076 Created: 2012-09-20 15:57 Last Updated: 2012-10-09 08:50 0 Rating/ Voters

Changing a Subscription's Plan and Add-ons in Plesk 10 for VPS

Plesk 10.1 is not yet offered, please refer to Plesk-VPS 9.5 KB articles for existing myhosting.com services.

Click here for a video tutorial

After you have created a subscription, you can easily change the plan and add-ons associated with it.

1. Go to Subscriptions.

Image:Subscriptions.JPG

2. Click the subscriptions.

Image:Clickk.JPG

3. Click Change Plan.

Image:Chplan.JPG

4. Choose the new service plan from the menu.

Image:Alist.JPG

5. If you select "None", the subscription will be unbound from its plan and you will be given the opportunity to create a completely custom set of resources and services instead.

6. Add or remove add-ons here.

Image:Addons.JPG

  1. Click OK.

Image:Clickok.JPG

That's it! Now you know how to change a subscription's plan and add-ons.

Rss Comments
  • There are no comments for this article.
Info Add Comment
Nickname: Your Email: Subject: Comment:
Knowledge Database by: KnowledgeBase Manager Pro v6.1.0 (Built with: JS.GUI - AJAX Framework)
0.0056209564208984
SELECT `sys_settings`.`var_name`, `sys_settings`.`var_value` FROM `sys_settings`
0.00073814392089844
SELECT `languages`.`lang_id` FROM `languages` WHERE (lang = 'def')
0.0076720714569092
SELECT `languages_vars`.`language_var`, `languages_vars`.`value` FROM `languages_vars` WHERE (lang_id = 1) AND (type != 'notification')
0.0073060989379883
SELECT `languages_vars`.`language_var`, `languages_vars`.`value` FROM `languages_vars` WHERE (lang_id = 1) AND (type != 'notification')
0.00062084197998047
SELECT `sys_settings`.`var_value` FROM `sys_settings` WHERE (var_name = 'session_life_time_unlimited')
0.00070285797119141
SELECT `ac`.`auto_relate`, `ac`.`max_staff_users`, `ac`.`max_client_users`, `ac`.`name`, (SELECT COUNT(*) FROM `users` WHERE (account_id = 2) AND (ldap_user = 'Y')) AS `ldap_users_num` FROM `accounts` AS `ac` WHERE (ac.account_id = 2)
0.00070714950561523
SELECT COUNT(us.user_id) FROM `users` AS `us` WHERE (type   = 'staff') AND (active = 'Y') AND (account_id = 2) AND ((SELECT COUNT(*) FROM `users_groups` AS `ug` WHERE (ug.user_id = us.user_id)) > 0) AND (login != 'sales@web-site-scripts.com')
0.00047516822814941
SELECT COUNT(us.user_id) FROM `users` AS `us` WHERE (type   = 'client') AND (active = 'Y') AND (account_id = 2) AND ((SELECT COUNT(*) FROM `users_groups` AS `ug` WHERE (ug.user_id = us.user_id)) > 0) AND (login != 'sales@web-site-scripts.com')
0.00050497055053711
SELECT COUNT(us.user_id) FROM `users` AS `us` WHERE (account_id = 2) AND ((SELECT COUNT(*) FROM `users_groups` AS `ug` WHERE (ug.user_id = us.user_id)) = 0) AND (login != 'sales@web-site-scripts.com')
0.00065994262695312
SELECT COUNT(*) AS `count` FROM `accounts` WHERE (LOWER(name) != 'preview')
0.00089597702026367
SELECT `accounts`.`name` FROM `accounts` WHERE (LOWER(name) != 'preview') ORDER BY `account_id` ASC LIMIT 1
0.0010299682617188
SELECT `view_manage`.`view_id`, `view_manage`.`name` FROM `view_manage` WHERE (type       = 'Hosted') AND (account_id = 2)
0.001021146774292
SELECT `vm`.`view_id` AS `id`, `vm`.`name`, `vm`.`type`, `vm`.`hash`, `vm`.`settings` AS `tabs`, `vm`.`style_id` AS `styles`, `vm`.`gmt`, `vm`.`time_format`, `vm`.`date_format`, `vm`.`lang_id`, `vm`.`status`, `vm`.`access_mode`, `vm`.`voting_id` AS `voting`, `g`.`offset` AS `gmt_offset` FROM `view_manage` AS `vm`
 LEFT JOIN `gmt` AS `g` ON g.gmt_id = vm.gmt WHERE (view_id = 2)
0.00047516822814941
SELECT `votings`.`voting_id` AS `value`, `votings`.`voting_name` AS `text` FROM `votings` WHERE (account_id = 2) OR (system = 'Y') ORDER BY `voting_name` ASC
0.0034317970275879
SELECT `tpl`.`theme_id`, `tpl`.`theme_name`, `tpl`.`based_on`, `tpl`.`system`, CASE WHEN ((vm.style_id = tpl.copy_of_theme OR vm.style_id = tpl.theme_id) AND vm.account_id = 2) THEN 'Y' ELSE  'N' END AS `current` FROM `tpl_themes` AS `tpl`
 LEFT JOIN `view_manage` AS `vm` ON (vm.style_id = tpl.copy_of_theme OR vm.style_id = tpl.theme_id) AND vm.type = 'Hosted'  AND vm.account_id = 2 WHERE (tpl.account_id = 1 AND tpl.copy = 'N' AND tpl.system = 'Y') OR (tpl.account_id = 2 AND copy = 'N' AND tpl.system = 'N') ORDER BY `theme_name` ASC
0.00083780288696289
SELECT `votings`.* FROM `votings` WHERE (voting_id = 1)
0.00061297416687012
SELECT `voting_items`.`item_title` AS `title`, `voting_items`.`value` FROM `voting_items` WHERE (voting_id = 1) ORDER BY `value` DESC
0.0018000602722168
SELECT `view_styles`.* FROM `view_styles` WHERE (style_id = 4)
0.00068187713623047
SELECT `view_elements_styles`.`element_name` AS `name`, `view_elements_styles`.`element_type` AS `style` FROM `view_elements_styles` WHERE (style_id = 4) ORDER BY `element_name` ASC
0.00063109397888184
SELECT `languages`.`name` AS `text`, `languages`.`lang_id` AS `value` FROM `languages` WHERE (status = 'on') AND (lang != 'def') ORDER BY `lang_id` ASC
0.00084590911865234
SELECT `gmt`.* FROM `gmt` ORDER BY `offset` ASC
0.0007779598236084
SELECT `view_manage`.`view_id` AS `id`, `view_manage`.`hash`, `view_manage`.`status`, `view_manage`.`lang_id`, `view_manage`.`name` FROM `view_manage` WHERE (account_id = 2) AND (type = 'HOSTED') LIMIT 1
0.0010521411895752
SELECT `view_manage`.`view_id`, `view_manage`.`name` FROM `view_manage` WHERE (type       = 'Hosted') AND (account_id = 2)
0.00096893310546875
SELECT `view_manage`.`settings` FROM `view_manage` WHERE (view_id = 2)
0.00060296058654785
UPDATE `view_manage` SET `views_num` = views_num + 1, `last_view_date` = ? WHERE (view_id = 2)
0.00060820579528809
SELECT `faq_articles`.`faq_id` FROM `faq_articles` WHERE (code = 'AA-01076') AND (account_id = 2) AND (status = 'moderated')
0.0004270076751709
DROP TABLE IF EXISTS `tmp_visible_articles_20101`;
0.00040578842163086
DROP TABLE IF EXISTS `tmp_visible_articles_20101`;
0.0008549690246582
CREATE TEMPORARY TABLE `tmp_visible_articles_20101` (`faq_id` int PRIMARY KEY) ENGINE=MEMORY
0.082632064819336
INSERT INTO `tmp_visible_articles_20101` SELECT `faq`.`faq_id` AS `id` FROM `faq_articles` AS `faq` USE INDEX (`PRIMARY`) WHERE (account_id = 2) AND (freeAccess = 'Y') AND (draft = 'N') AND (status = 'moderated') AND ( `public` = 'Y' AND
                                ((public_start_date <= '2013-05-24 01:52:41' OR public_start_date IS NULL)
                                    AND
                                  (public_end_date IS NULL OR public_end_date >= '2013-05-24 01:52:41')
                                ))
0.0019040107727051
SELECT `tmp_visible_articles_20101`.`faq_id` FROM `tmp_visible_articles_20101`
0.043360948562622
SELECT `far`.`faq_id` AS `faqId`, `far`.`featured`, `far`.`question`, `far`.`views`, `far`.`rating`, `far`.`faq_date`, `far`.`status_change_date` FROM `faq_articles` AS `far`
 INNER JOIN `tmp_visible_articles_20101` AS `tmp` ON far.faq_id = tmp.faq_id WHERE (draft = 'N') AND (far.featured = 'Y') ORDER BY `far`.`status_change_date` DESC, `faqId` DESC LIMIT 10
0.0017650127410889
SELECT `fa`.`faq_id` AS `faqId`, `fa`.`question`, `fa`.`code`, `fa`.`views`, `fa`.`rating`, `fa`.`featured`, `fa`.`answer`, CASE
                                            WHEN (`public` = 'Y' AND (((public_start_date <= '2013-05-24 01:52:41') OR (public_start_date IS NULL))
                                                    AND (public_end_date IS NULL OR public_end_date >= '2013-05-24 01:52:41')))
                                            THEN 'Y'
                                            ELSE 'N'
                                        END  AS `public`, `fa`.`faq_date` AS `date`, `fa`.`status_change_date` AS `lastEditDate`, `fa`.`public_start_date` AS `publicStartDate` FROM `faq_articles` AS `fa` WHERE (fa.faq_id IN (4584,4814,4815,4816,4596,3565)) AND (fa.status = 'moderated') ORDER BY `fa`.`status_change_date` DESC, `faq_id` DESC
0.0006868839263916
SELECT `fc`.`cat_id`, `fc`.`cat_name`, `fc`.`account_id` FROM `articles_categories` AS `ac`
 LEFT JOIN `faq_categories` AS `fc` ON fc.cat_id = ac.category_id WHERE (ac.faq_id = 4584)
0.00054502487182617
SELECT `faq_categories`.`cat_name`, `faq_categories`.`cat_id`, `faq_categories`.`parent_id` FROM `faq_categories` WHERE (cat_id = 8)
0.00051689147949219
SELECT `faq_categories`.`cat_name`, `faq_categories`.`cat_id`, `faq_categories`.`parent_id` FROM `faq_categories` WHERE (cat_id = 17)
0.00049805641174316
SELECT `faq_categories`.`cat_name`, `faq_categories`.`cat_id`, `faq_categories`.`parent_id` FROM `faq_categories` WHERE (cat_id = 8)
0.00044798851013184
SELECT `faq_categories`.`cat_name`, `faq_categories`.`cat_id`, `faq_categories`.`parent_id` FROM `faq_categories` WHERE (cat_id = 35)
0.0005950927734375
SELECT `faq_categories`.`cat_name`, `faq_categories`.`cat_id`, `faq_categories`.`parent_id` FROM `faq_categories` WHERE (cat_id = 17)
0.00049805641174316
SELECT `faq_categories`.`cat_name`, `faq_categories`.`cat_id`, `faq_categories`.`parent_id` FROM `faq_categories` WHERE (cat_id = 37)
0.0005180835723877
SELECT `faq_categories`.`cat_name`, `faq_categories`.`cat_id`, `faq_categories`.`parent_id` FROM `faq_categories` WHERE (cat_id = 35)
0.00059914588928223
SELECT `faq_categories`.`cat_name`, `faq_categories`.`cat_id`, `faq_categories`.`parent_id` FROM `faq_categories` WHERE (cat_id = 206)
0.0005950927734375
SELECT `faq_categories`.`cat_name`, `faq_categories`.`cat_id`, `faq_categories`.`parent_id` FROM `faq_categories` WHERE (cat_id = 200)
0.00051403045654297
SELECT `faq_categories`.`cat_name`, `faq_categories`.`cat_id`, `faq_categories`.`parent_id` FROM `faq_categories` WHERE (cat_id = 221)
0.00074291229248047
SELECT `faq_categories`.`cat_name`, `faq_categories`.`cat_id`, `faq_categories`.`parent_id` FROM `faq_categories` WHERE (cat_id = 207)
0.00063300132751465
SELECT `faq_categories`.`cat_name`, `faq_categories`.`cat_id`, `faq_categories`.`parent_id` FROM `faq_categories` WHERE (cat_id = 354)
0.00069594383239746
SELECT `faq_categories`.`cat_name`, `faq_categories`.`cat_id`, `faq_categories`.`parent_id` FROM `faq_categories` WHERE (cat_id = 205)
0.00058817863464355
SELECT `faq_categories`.`cat_name`, `faq_categories`.`cat_id`, `faq_categories`.`parent_id` FROM `faq_categories` WHERE (cat_id = 355)
0.00099396705627441
SELECT `fc`.`cat_id`, `fc`.`cat_name`, `fc`.`account_id` FROM `articles_categories` AS `ac`
 LEFT JOIN `faq_categories` AS `fc` ON fc.cat_id = ac.category_id WHERE (ac.faq_id = 4814)
0.00052499771118164
SELECT `faq_categories`.`cat_name`, `faq_categories`.`cat_id`, `faq_categories`.`parent_id` FROM `faq_categories` WHERE (cat_id = 368)
0.00051999092102051
SELECT `fc`.`cat_id`, `fc`.`cat_name`, `fc`.`account_id` FROM `articles_categories` AS `ac`
 LEFT JOIN `faq_categories` AS `fc` ON fc.cat_id = ac.category_id WHERE (ac.faq_id = 4815)
0.00089383125305176
SELECT `fc`.`cat_id`, `fc`.`cat_name`, `fc`.`account_id` FROM `articles_categories` AS `ac`
 LEFT JOIN `faq_categories` AS `fc` ON fc.cat_id = ac.category_id WHERE (ac.faq_id = 4816)
0.00048089027404785
SELECT `fc`.`cat_id`, `fc`.`cat_name`, `fc`.`account_id` FROM `articles_categories` AS `ac`
 LEFT JOIN `faq_categories` AS `fc` ON fc.cat_id = ac.category_id WHERE (ac.faq_id = 4596)
0.00056719779968262
SELECT `faq_categories`.`cat_name`, `faq_categories`.`cat_id`, `faq_categories`.`parent_id` FROM `faq_categories` WHERE (cat_id = 356)
0.0006859302520752
SELECT `faq_categories`.`cat_name`, `faq_categories`.`cat_id`, `faq_categories`.`parent_id` FROM `faq_categories` WHERE (cat_id = 34)
0.0012879371643066
SELECT `fc`.`cat_id`, `fc`.`cat_name`, `fc`.`account_id` FROM `articles_categories` AS `ac`
 LEFT JOIN `faq_categories` AS `fc` ON fc.cat_id = ac.category_id WHERE (ac.faq_id = 3565)
0.0008699893951416
SELECT `faq_categories`.`cat_name`, `faq_categories`.`cat_id`, `faq_categories`.`parent_id` FROM `faq_categories` WHERE (cat_id = 284)
0.0005190372467041
SELECT `faq_categories`.`cat_name`, `faq_categories`.`cat_id`, `faq_categories`.`parent_id` FROM `faq_categories` WHERE (cat_id = 315)
0.00065994262695312
SELECT `faq_categories`.`cat_name`, `faq_categories`.`cat_id`, `faq_categories`.`parent_id` FROM `faq_categories` WHERE (cat_id = 215)
0.0004570484161377
SELECT `faq_categories`.`cat_name`, `faq_categories`.`cat_id`, `faq_categories`.`parent_id` FROM `faq_categories` WHERE (cat_id = 212)
0.049776077270508
SELECT `far`.`faq_id` AS `faqId`, `far`.`featured`, `far`.`question`, `far`.`views`, `far`.`rating`, `far`.`faq_date`, `far`.`status_change_date` FROM `faq_articles` AS `far`
 INNER JOIN `tmp_visible_articles_20101` AS `tmp` ON far.faq_id = tmp.faq_id WHERE (draft = 'N') ORDER BY `far`.`views` DESC, `faqId` DESC LIMIT 10
0.0050089359283447
SELECT `fa`.`faq_id` AS `faqId`, `fa`.`question`, `fa`.`code`, `fa`.`views`, `fa`.`rating`, `fa`.`featured`, `fa`.`answer`, CASE
                                            WHEN (`public` = 'Y' AND (((public_start_date <= '2013-05-24 01:52:41') OR (public_start_date IS NULL))
                                                    AND (public_end_date IS NULL OR public_end_date >= '2013-05-24 01:52:41')))
                                            THEN 'Y'
                                            ELSE 'N'
                                        END  AS `public`, `fa`.`faq_date` AS `date`, `fa`.`status_change_date` AS `lastEditDate`, `fa`.`public_start_date` AS `publicStartDate` FROM `faq_articles` AS `fa` WHERE (fa.faq_id IN (1064,1094,845,4584,1061,510,4614,842,698,907)) AND (fa.status = 'moderated') ORDER BY `fa`.`views` DESC, `faq_id` DESC
0.00061297416687012
SELECT `fc`.`cat_id`, `fc`.`cat_name`, `fc`.`account_id` FROM `articles_categories` AS `ac`
 LEFT JOIN `faq_categories` AS `fc` ON fc.cat_id = ac.category_id WHERE (ac.faq_id = 1064)
0.00053310394287109
SELECT `faq_categories`.`cat_name`, `faq_categories`.`cat_id`, `faq_categories`.`parent_id` FROM `faq_categories` WHERE (cat_id = 147)
0.00045299530029297
SELECT `faq_categories`.`cat_name`, `faq_categories`.`cat_id`, `faq_categories`.`parent_id` FROM `faq_categories` WHERE (cat_id = 357)
0.00088715553283691
SELECT `fc`.`cat_id`, `fc`.`cat_name`, `fc`.`account_id` FROM `articles_categories` AS `ac`
 LEFT JOIN `faq_categories` AS `fc` ON fc.cat_id = ac.category_id WHERE (ac.faq_id = 1094)
0.00055909156799316
SELECT `fc`.`cat_id`, `fc`.`cat_name`, `fc`.`account_id` FROM `articles_categories` AS `ac`
 LEFT JOIN `faq_categories` AS `fc` ON fc.cat_id = ac.category_id WHERE (ac.faq_id = 845)
0.00051498413085938
SELECT `faq_categories`.`cat_name`, `faq_categories`.`cat_id`, `faq_categories`.`parent_id` FROM `faq_categories` WHERE (cat_id = 36)
0.00050806999206543
SELECT `faq_categories`.`cat_name`, `faq_categories`.`cat_id`, `faq_categories`.`parent_id` FROM `faq_categories` WHERE (cat_id = 358)
0.00081205368041992
SELECT `fc`.`cat_id`, `fc`.`cat_name`, `fc`.`account_id` FROM `articles_categories` AS `ac`
 LEFT JOIN `faq_categories` AS `fc` ON fc.cat_id = ac.category_id WHERE (ac.faq_id = 1061)
0.00055289268493652
SELECT `fc`.`cat_id`, `fc`.`cat_name`, `fc`.`account_id` FROM `articles_categories` AS `ac`
 LEFT JOIN `faq_categories` AS `fc` ON fc.cat_id = ac.category_id WHERE (ac.faq_id = 510)
0.00071406364440918
SELECT `faq_categories`.`cat_name`, `faq_categories`.`cat_id`, `faq_categories`.`parent_id` FROM `faq_categories` WHERE (cat_id = 183)
0.00075411796569824
SELECT `faq_categories`.`cat_name`, `faq_categories`.`cat_id`, `faq_categories`.`parent_id` FROM `faq_categories` WHERE (cat_id = 182)
0.0030889511108398
SELECT `fc`.`cat_id`, `fc`.`cat_name`, `fc`.`account_id` FROM `articles_categories` AS `ac`
 LEFT JOIN `faq_categories` AS `fc` ON fc.cat_id = ac.category_id WHERE (ac.faq_id = 4614)
0.00069212913513184
SELECT `fc`.`cat_id`, `fc`.`cat_name`, `fc`.`account_id` FROM `articles_categories` AS `ac`
 LEFT JOIN `faq_categories` AS `fc` ON fc.cat_id = ac.category_id WHERE (ac.faq_id = 842)
0.00082898139953613
SELECT `fc`.`cat_id`, `fc`.`cat_name`, `fc`.`account_id` FROM `articles_categories` AS `ac`
 LEFT JOIN `faq_categories` AS `fc` ON fc.cat_id = ac.category_id WHERE (ac.faq_id = 698)
0.00049591064453125
SELECT `faq_categories`.`cat_name`, `faq_categories`.`cat_id`, `faq_categories`.`parent_id` FROM `faq_categories` WHERE (cat_id = 19)
0.00057196617126465
SELECT `faq_categories`.`cat_name`, `faq_categories`.`cat_id`, `faq_categories`.`parent_id` FROM `faq_categories` WHERE (cat_id = 9)
0.00053286552429199
SELECT `fc`.`cat_id`, `fc`.`cat_name`, `fc`.`account_id` FROM `articles_categories` AS `ac`
 LEFT JOIN `faq_categories` AS `fc` ON fc.cat_id = ac.category_id WHERE (ac.faq_id = 907)
0.00071096420288086
SELECT `faq_categories`.`cat_name`, `faq_categories`.`cat_id`, `faq_categories`.`parent_id` FROM `faq_categories` WHERE (cat_id = 142)
0.00069594383239746
SELECT `faq_categories`.`cat_name`, `faq_categories`.`cat_id`, `faq_categories`.`parent_id` FROM `faq_categories` WHERE (cat_id = 33)
0.00070405006408691
SELECT `faq_categories`.`cat_name`, `faq_categories`.`cat_id`, `faq_categories`.`parent_id` FROM `faq_categories` WHERE (cat_id = 16)
0.049180030822754
SELECT `far`.`faq_id` AS `faqId`, `far`.`featured`, `far`.`question`, `far`.`views`, `far`.`rating`, `far`.`faq_date`, `far`.`status_change_date` FROM `faq_articles` AS `far`
 INNER JOIN `tmp_visible_articles_20101` AS `tmp` ON far.faq_id = tmp.faq_id WHERE (draft = 'N') ORDER BY `far`.`rating` DESC, `faqId` DESC LIMIT 10
0.073848009109497
SELECT `fa`.`faq_id` AS `faqId`, `fa`.`question`, `fa`.`code`, `fa`.`views`, `fa`.`rating`, `fa`.`featured`, `fa`.`answer`, CASE
                                            WHEN (`public` = 'Y' AND (((public_start_date <= '2013-05-24 01:52:41') OR (public_start_date IS NULL))
                                                    AND (public_end_date IS NULL OR public_end_date >= '2013-05-24 01:52:41')))
                                            THEN 'Y'
                                            ELSE 'N'
                                        END  AS `public`, `fa`.`faq_date` AS `date`, `fa`.`status_change_date` AS `lastEditDate`, `fa`.`public_start_date` AS `publicStartDate` FROM `faq_articles` AS `fa` WHERE (fa.faq_id IN (4625,4624,4614,4610,4584,4401,994,644,642,4873)) AND (fa.status = 'moderated') ORDER BY `fa`.`rating` DESC, `faq_id` DESC
0.00067901611328125
SELECT `fc`.`cat_id`, `fc`.`cat_name`, `fc`.`account_id` FROM `articles_categories` AS `ac`
 LEFT JOIN `faq_categories` AS `fc` ON fc.cat_id = ac.category_id WHERE (ac.faq_id = 4625)
0.0021119117736816
SELECT `fc`.`cat_id`, `fc`.`cat_name`, `fc`.`account_id` FROM `articles_categories` AS `ac`
 LEFT JOIN `faq_categories` AS `fc` ON fc.cat_id = ac.category_id WHERE (ac.faq_id = 4624)
0.00098609924316406
SELECT `faq_categories`.`cat_name`, `faq_categories`.`cat_id`, `faq_categories`.`parent_id` FROM `faq_categories` WHERE (cat_id = 18)
0.00047206878662109
SELECT `faq_categories`.`cat_name`, `faq_categories`.`cat_id`, `faq_categories`.`parent_id` FROM `faq_categories` WHERE (cat_id = 47)
0.00045514106750488
SELECT `faq_categories`.`cat_name`, `faq_categories`.`cat_id`, `faq_categories`.`parent_id` FROM `faq_categories` WHERE (cat_id = 25)
0.00062394142150879
SELECT `faq_categories`.`cat_name`, `faq_categories`.`cat_id`, `faq_categories`.`parent_id` FROM `faq_categories` WHERE (cat_id = 11)
0.00073385238647461
SELECT `faq_categories`.`cat_name`, `faq_categories`.`cat_id`, `faq_categories`.`parent_id` FROM `faq_categories` WHERE (cat_id = 7)
0.00046610832214355
SELECT `faq_categories`.`cat_name`, `faq_categories`.`cat_id`, `faq_categories`.`parent_id` FROM `faq_categories` WHERE (cat_id = 66)
0.00075793266296387
SELECT `faq_categories`.`cat_name`, `faq_categories`.`cat_id`, `faq_categories`.`parent_id` FROM `faq_categories` WHERE (cat_id = 24)
0.00050592422485352
SELECT `fc`.`cat_id`, `fc`.`cat_name`, `fc`.`account_id` FROM `articles_categories` AS `ac`
 LEFT JOIN `faq_categories` AS `fc` ON fc.cat_id = ac.category_id WHERE (ac.faq_id = 4610)
0.00059294700622559
SELECT `fc`.`cat_id`, `fc`.`cat_name`, `fc`.`account_id` FROM `articles_categories` AS `ac`
 LEFT JOIN `faq_categories` AS `fc` ON fc.cat_id = ac.category_id WHERE (ac.faq_id = 4401)
0.00052189826965332
SELECT `fc`.`cat_id`, `fc`.`cat_name`, `fc`.`account_id` FROM `articles_categories` AS `ac`
 LEFT JOIN `faq_categories` AS `fc` ON fc.cat_id = ac.category_id WHERE (ac.faq_id = 994)
0.00048089027404785
SELECT `faq_categories`.`cat_name`, `faq_categories`.`cat_id`, `faq_categories`.`parent_id` FROM `faq_categories` WHERE (cat_id = 130)
0.00074601173400879
SELECT `faq_categories`.`cat_name`, `faq_categories`.`cat_id`, `faq_categories`.`parent_id` FROM `faq_categories` WHERE (cat_id = 32)
0.00054001808166504
SELECT `fc`.`cat_id`, `fc`.`cat_name`, `fc`.`account_id` FROM `articles_categories` AS `ac`
 LEFT JOIN `faq_categories` AS `fc` ON fc.cat_id = ac.category_id WHERE (ac.faq_id = 644)
0.00056099891662598
SELECT `faq_categories`.`cat_name`, `faq_categories`.`cat_id`, `faq_categories`.`parent_id` FROM `faq_categories` WHERE (cat_id = 79)
0.00078392028808594
SELECT `faq_categories`.`cat_name`, `faq_categories`.`cat_id`, `faq_categories`.`parent_id` FROM `faq_categories` WHERE (cat_id = 27)
0.00059008598327637
SELECT `faq_categories`.`cat_name`, `faq_categories`.`cat_id`, `faq_categories`.`parent_id` FROM `faq_categories` WHERE (cat_id = 12)
0.00046086311340332
SELECT `faq_categories`.`cat_name`, `faq_categories`.`cat_id`, `faq_categories`.`parent_id` FROM `faq_categories` WHERE (cat_id = 98)
0.00056815147399902
SELECT `faq_categories`.`cat_name`, `faq_categories`.`cat_id`, `faq_categories`.`parent_id` FROM `faq_categories` WHERE (cat_id = 26)
0.00054597854614258
SELECT `fc`.`cat_id`, `fc`.`cat_name`, `fc`.`account_id` FROM `articles_categories` AS `ac`
 LEFT JOIN `faq_categories` AS `fc` ON fc.cat_id = ac.category_id WHERE (ac.faq_id = 642)
0.00061321258544922
SELECT `faq_categories`.`cat_name`, `faq_categories`.`cat_id`, `faq_categories`.`parent_id` FROM `faq_categories` WHERE (cat_id = 81)
0.00053882598876953
SELECT `fc`.`cat_id`, `fc`.`cat_name`, `fc`.`account_id` FROM `articles_categories` AS `ac`
 LEFT JOIN `faq_categories` AS `fc` ON fc.cat_id = ac.category_id WHERE (ac.faq_id = 4873)
0.00060105323791504
SELECT `faq_categories`.`cat_name`, `faq_categories`.`cat_id`, `faq_categories`.`parent_id` FROM `faq_categories` WHERE (cat_id = 247)
0.00074911117553711
SELECT `faq_categories`.`cat_name`, `faq_categories`.`cat_id`, `faq_categories`.`parent_id` FROM `faq_categories` WHERE (cat_id = 246)
0.049744844436646
SELECT `far`.`faq_id` AS `faqId`, `far`.`featured`, `far`.`question`, `far`.`views`, `far`.`rating`, `far`.`faq_date`, `far`.`status_change_date` FROM `faq_articles` AS `far`
 INNER JOIN `tmp_visible_articles_20101` AS `tmp` ON far.faq_id = tmp.faq_id WHERE (draft = 'N') ORDER BY `far`.`real_creation_date` DESC, `faqId` DESC LIMIT 10
0.13518905639648
SELECT `fa`.`faq_id` AS `faqId`, `fa`.`question`, `fa`.`code`, `fa`.`views`, `fa`.`rating`, `fa`.`featured`, `fa`.`answer`, CASE
                                            WHEN (`public` = 'Y' AND (((public_start_date <= '2013-05-24 01:52:41') OR (public_start_date IS NULL))
                                                    AND (public_end_date IS NULL OR public_end_date >= '2013-05-24 01:52:41')))
                                            THEN 'Y'
                                            ELSE 'N'
                                        END  AS `public`, `fa`.`faq_date` AS `date`, `fa`.`status_change_date` AS `lastEditDate`, `fa`.`public_start_date` AS `publicStartDate` FROM `faq_articles` AS `fa` WHERE (fa.faq_id IN (4873,4872,4871,4870,4869,4865,4864,4863,4862,4861)) AND (fa.status = 'moderated') ORDER BY `fa`.`real_creation_date` DESC, `faq_id` DESC
0.00061988830566406
SELECT `fc`.`cat_id`, `fc`.`cat_name`, `fc`.`account_id` FROM `articles_categories` AS `ac`
 LEFT JOIN `faq_categories` AS `fc` ON fc.cat_id = ac.category_id WHERE (ac.faq_id = 4872)
0.00053191184997559
SELECT `fc`.`cat_id`, `fc`.`cat_name`, `fc`.`account_id` FROM `articles_categories` AS `ac`
 LEFT JOIN `faq_categories` AS `fc` ON fc.cat_id = ac.category_id WHERE (ac.faq_id = 4871)
0.00060105323791504
SELECT `faq_categories`.`cat_name`, `faq_categories`.`cat_id`, `faq_categories`.`parent_id` FROM `faq_categories` WHERE (cat_id = 371)
0.0005030632019043
SELECT `faq_categories`.`cat_name`, `faq_categories`.`cat_id`, `faq_categories`.`parent_id` FROM `faq_categories` WHERE (cat_id = 210)
0.00060105323791504
SELECT `fc`.`cat_id`, `fc`.`cat_name`, `fc`.`account_id` FROM `articles_categories` AS `ac`
 LEFT JOIN `faq_categories` AS `fc` ON fc.cat_id = ac.category_id WHERE (ac.faq_id = 4870)
0.00052499771118164
SELECT `fc`.`cat_id`, `fc`.`cat_name`, `fc`.`account_id` FROM `articles_categories` AS `ac`
 LEFT JOIN `faq_categories` AS `fc` ON fc.cat_id = ac.category_id WHERE (ac.faq_id = 4869)
0.00051593780517578
SELECT `fc`.`cat_id`, `fc`.`cat_name`, `fc`.`account_id` FROM `articles_categories` AS `ac`
 LEFT JOIN `faq_categories` AS `fc` ON fc.cat_id = ac.category_id WHERE (ac.faq_id = 4865)
0.00050902366638184
SELECT `faq_categories`.`cat_name`, `faq_categories`.`cat_id`, `faq_categories`.`parent_id` FROM `faq_categories` WHERE (cat_id = 231)
0.00054597854614258
SELECT `faq_categories`.`cat_name`, `faq_categories`.`cat_id`, `faq_categories`.`parent_id` FROM `faq_categories` WHERE (cat_id = 209)
0.00055122375488281
SELECT `fc`.`cat_id`, `fc`.`cat_name`, `fc`.`account_id` FROM `articles_categories` AS `ac`
 LEFT JOIN `faq_categories` AS `fc` ON fc.cat_id = ac.category_id WHERE (ac.faq_id = 4864)
0.00063300132751465
SELECT `fc`.`cat_id`, `fc`.`cat_name`, `fc`.`account_id` FROM `articles_categories` AS `ac`
 LEFT JOIN `faq_categories` AS `fc` ON fc.cat_id = ac.category_id WHERE (ac.faq_id = 4863)
0.00083494186401367
SELECT `faq_categories`.`cat_name`, `faq_categories`.`cat_id`, `faq_categories`.`parent_id` FROM `faq_categories` WHERE (cat_id = 312)
0.00046491622924805
SELECT `faq_categories`.`cat_name`, `faq_categories`.`cat_id`, `faq_categories`.`parent_id` FROM `faq_categories` WHERE (cat_id = 310)
0.001025915145874
SELECT `fc`.`cat_id`, `fc`.`cat_name`, `fc`.`account_id` FROM `articles_categories` AS `ac`
 LEFT JOIN `faq_categories` AS `fc` ON fc.cat_id = ac.category_id WHERE (ac.faq_id = 4862)
0.00052785873413086
SELECT `fc`.`cat_id`, `fc`.`cat_name`, `fc`.`account_id` FROM `articles_categories` AS `ac`
 LEFT JOIN `faq_categories` AS `fc` ON fc.cat_id = ac.category_id WHERE (ac.faq_id = 4861)
0.0013000965118408
SELECT `far`.`faq_id` AS `faqId`, `far`.`code`, `far`.`email`, `far`.`public` AS `public_`, `far`.`draft`, `far`.`locked`, `far`.`answer`, `far`.`lock_user_id`, `far`.`question`, `far`.`status`, `far`.`featured`, `far`.`freeAccess`, UNIX_TIMESTAMP(far.lock_date) AS `lock_date`, `far`.`author` AS `author_id`, `far`.`editor` AS `editor_id`, `far`.`faq_date` AS `date`, `far`.`rating`, `far`.`views`, `far`.`public_start_date` AS `publicStartDate_`, `far`.`public_end_date` AS `publicEndDate_`, CASE
                                                                WHEN status_change_date IS NULL OR (status_change_date <= '1970-01-01 00:00:00')
                                                                THEN faq_date
                                                                ELSE status_change_date
                                                            END  AS `lastEditDate`, CASE
                                              WHEN (`public` = 'Y' AND (((public_start_date <= '2013-05-24 01:52:41') OR (public_start_date IS NULL))
                                                    AND (public_end_date IS NULL OR public_end_date >= '2013-05-24 01:52:41')))
                                              THEN 'Y'
                                              ELSE 'N'
                                            END  AS `public`, `far`.`meta_keywords`, `far`.`meta_description`, `far`.`KEYWORD_JSGUI`, `far`.`KEYWORD_KMP`, `far`.`KEYWORD_JSGUI_URL`, `far`.`KEYWORD_KMP_URL`, CONCAT_WS(' ', us.fname,us.lname) AS `author_login`, CONCAT_WS(' ', us_e.fname,us_e.lname) AS `editor_login`, CONCAT_WS(' ', us_l.fname,us_l.lname) AS `lock_login`, (SELECT COUNT(*) FROM `faq_attachments` WHERE (faq_id = 1003)) AS `attaches` FROM `faq_articles` AS `far`
 LEFT JOIN `users` AS `us` ON far.author = us.user_id
 LEFT JOIN `users` AS `us_e` ON far.editor = us_e.user_id
 LEFT JOIN `users` AS `us_l` ON far.lock_user_id = us_l.user_id WHERE (far.faq_id = 1003) AND ( (far.`public` = 'Y' AND (((far.public_start_date <= '2013-05-24 01:52:41') OR (far.public_start_date IS NULL)) AND (far.public_end_date IS NULL OR far.public_end_date >= '2013-05-24 01:52:41')))) LIMIT 1
0.00073599815368652
SELECT `v_com`.`faq_vc_id` AS `v_com_id`, `v_com`.`visitor_subject` AS `v_com_subject`, `v_com`.`visitor_comment` AS `v_com_comment`, `v_com`.`visitor_comment_date` AS `v_com_date`, `v_com`.`nickname` AS `v_com_nick`, `v_com`.`email` AS `v_com_email`, `v_com`.`user_ip` AS `v_com_ip`, `u_com`.`faq_uc_id` AS `u_com_id`, `u_com`.`user_subject` AS `u_com_subject`, `u_com`.`user_comment` AS `u_com_comment`, `u_com`.`user_comment_date` AS `u_com_date`, CASE WHEN u_com.faq_uc_id IS NULL THEN 0 ELSE 1 END AS `nouser`, `usr`.`fname`, `usr`.`lname` FROM `faq_visitors_comments` AS `v_com`
 LEFT JOIN `faq_users_comments` AS `u_com` ON v_com.faq_vc_id = u_com.faq_vc_id
 LEFT JOIN `users` AS `usr` ON u_com.author_id = usr.user_id WHERE (v_com.faq_id = 1003) AND (v_com.comment_status != 'delete') AND (v_com.comment_status != 'new') ORDER BY `v_com_date` DESC, `u_com_date` ASC
0.00064706802368164
SELECT `faq_statistics`.`stat_id` AS `id`, `faq_statistics`.`feedback` AS `message`, `faq_statistics`.`stat_date` AS `date`, `faq_statistics`.`email`, `faq_statistics`.`rating` AS `voter` FROM `faq_statistics` WHERE (faq_id = 1003) AND (feedback NOT LIKE '')
0.00094199180603027
SELECT SQL_CALC_FOUND_ROWS `custom_fields`.`cf_id` AS `id`, `custom_fields`.`name`, `custom_fields`.`type`, `custom_fields`.`position`, `custom_fields`.`required`, `custom_fields`.`internal`, `custom_fields`.`hint`, `custom_fields`.`use_hint`, `custom_fields`.`listHeight`, `custom_fields`.`search_back`, `custom_fields`.`search_front`, `custom_fields`.`show_empty`, `custom_fields`.`WYSIWYG`, `custom_fields`.`optionsDelimiter`, `custom_fields`.`format`, `custom_fields`.`isLink` FROM `custom_fields` WHERE (account_id = 2) ORDER BY `position` ASC
0.00074315071105957
SELECT `cfa`.`cf_id`, `cfa`.`cf_o_id`, `cfa`.`value`, `cf`.`name`, `cf`.`optionsDelimiter`, `cf`.`internal`, `cf`.`type`, `cf`.`format`, `cf`.`position`, `cf`.`show_empty`, `cf`.`search_front` FROM `custom_fields_articles` AS `cfa`
 INNER JOIN `custom_fields` AS `cf` ON cf.cf_id = cfa.cf_id WHERE (cfa.faq_id = 1003) ORDER BY `cf_id` ASC
0.0005640983581543
SELECT `fc`.`cat_id`, `fc`.`cat_name`, `fc`.`account_id` FROM `articles_categories` AS `ac`
 LEFT JOIN `faq_categories` AS `fc` ON fc.cat_id = ac.category_id WHERE (ac.faq_id = 1003)
0.00078105926513672
SELECT `faq_categories`.`cat_name`, `faq_categories`.`cat_id`, `faq_categories`.`parent_id` FROM `faq_categories` WHERE (cat_id = 131)
0.0007929801940918
SELECT `fa`.`faq_id` AS `id`, `fa`.`views`, `fa`.`rating`, `fs`.`stat_id` AS `voters`, `fs`.`stat_date` AS `statDate` FROM `faq_articles` AS `fa`
 LEFT JOIN (SELECT `faq_statistics`.`faq_id`, MAX(stat_date) AS `stat_date`, COUNT(stat_id) AS `stat_id` FROM `faq_statistics` GROUP BY `faq_id`) AS `fs` ON fa.faq_id = fs.faq_id WHERE (fa.faq_id = 1003)
0.0011210441589355
SELECT SQL_CALC_FOUND_ROWS `us`.`user_id`, `us`.`allow_delete` AS `editable`, `us`.`type`, CASE WHEN (SELECT COUNT(user_id) FROM `users_groups` AS `ug` WHERE (ug.user_id = us.user_id)) > 0 THEN 'N' ELSE 'Y' END AS `unassigned`, `us`.`active`, `us`.`ldap_user`, `us`.`login`, `us`.`fname`, `us`.`lname`, `us`.`email`, CONCAT_WS(' ', us.fname,us.lname) AS `text` FROM `users` AS `us` WHERE (us.login != 'sales@web-site-scripts.com') AND (us.account_id = 2) AND (us.type = 'staff' AND us.active <> 'P' AND (SELECT COUNT(user_id) FROM `users_groups` AS `ug` WHERE (ug.user_id = us.user_id)) > 0) ORDER BY `login` ASC
0.00050497055053711
SELECT FOUND_ROWS()
0.00069499015808105
SELECT `fa`.`revision_id`, `fa`.`revision_date` AS `date`, CONCAT_WS(' ', us.fname,us.lname) AS `author`, CONCAT_WS(' ', us_e.fname,us_e.lname) AS `editor` FROM `faq_history` AS `fa`
 LEFT JOIN `users` AS `us` ON fa.author = us.user_id
 LEFT JOIN `users` AS `us_e` ON fa.editor = us_e.user_id WHERE (fa.faq_id = 1003) ORDER BY `date` DESC
0.00048685073852539
SELECT `faq_articles`.`freeAccess`, `faq_articles`.`account_id` FROM `faq_articles` WHERE (faq_id = 1003)
0.0012178421020508
SELECT DISTINCT `g`.`group_id`, `g`.`name`, `g`.`description`, `g`.`allow_delete` FROM `articles_categories` AS `ac`
 LEFT JOIN `groups_categories_permissions` AS `gcp` ON ac.category_id = gcp.category_id OR gcp.category_id = 0
 LEFT JOIN `groups` AS `g` ON g.group_id = gcp.group_id WHERE (ac.faq_id = 1003) AND (g.account_id = 2) ORDER BY `g`.`name` ASC
0.006289005279541
SELECT COUNT(*) AS `num` FROM `drafts` WHERE (account_id = 2) AND (user_id = -1) AND (question NOT LIKE '' OR answer NOT LIKE '')
0.0062389373779297
SELECT `dr`.`faq_id`, `dr`.`draft_id`, `dr`.`draft_date`, `dr`.`question`, `dr`.`answer`, `fa`.`draft`, CONCAT_WS(' ', us.fname,us.lname) AS `author_login`, CONCAT_WS(' ', us_e.fname,us_e.lname) AS `editor_login` FROM `drafts` AS `dr`
 LEFT JOIN `faq_articles` AS `fa` ON dr.faq_id = fa.faq_id
 LEFT JOIN `users` AS `us` ON fa.author = us.user_id
 LEFT JOIN `users` AS `us_e` ON fa.editor = us_e.user_id WHERE (dr.faq_id = 1003) AND (dr.user_id = -1) AND ((fa.faq_date < dr.draft_date OR fa.status_change_date < dr.draft_date))
0.00055503845214844
UPDATE `faq_articles` SET `views` = ? WHERE (faq_id = 1003)
0.00061321258544922
SELECT `terms`.`term_id`, `terms`.`term`, `terms`.`term_description` AS `description` FROM `terms` WHERE (account_id = 2)
0.00081491470336914
SELECT SQL_CALC_FOUND_ROWS `faq_attachments`.`faq_attachment_id` AS `id`, `faq_attachments`.`attach_name` AS `name`, `faq_attachments`.`file_path` AS `path`, `faq_attachments`.`mime_type` AS `type`, `faq_attachments`.`file_name` FROM `faq_attachments` WHERE (faq_id = 1003) ORDER BY `name` ASC
0.00041007995605469
SELECT FOUND_ROWS()
0.00066304206848145
SELECT `g`.`group_id` AS `gid`, `g`.`name`, `g`.`allow_delete`, `g`.`description`, `g`.`type`, (SELECT COUNT(user_id) FROM `users_groups` AS `ug` WHERE (ug.group_id = g.group_id)) AS `users_count` FROM `groups` AS `g` WHERE (account_id = 2) ORDER BY `name` ASC
0.0053591728210449
SELECT `ac`.`category_id` FROM `articles_categories` AS `ac`
 INNER JOIN `tmp_visible_articles_20101` AS `tmp` ON ac.faq_id = tmp.faq_id UNION SELECT `fc`.`cat_id` AS `category_id` FROM `faq_categories` AS `fc` WHERE (fc.`public` = 'Y') AND (fc.account_id = 2)
0.014646053314209
SELECT `fc`.`cat_id` AS `id`, `fc`.`parent_id` AS `pid`, `fc`.`cat_name` AS `text`, `fc`.`position`, `fc`.`meta_keywords`, `fc`.`meta_description`, `fc`.`public`, CASE WHEN childCount.`count` IS NULL
                                                                                 THEN 0
                                                                                 ELSE childCount.`count`
                                                                             END  AS `childCount`, CASE WHEN totalArticles.`count` IS NULL
                                                                                    THEN 0
                                                                                    ELSE totalArticles.`count`
                                                                                END  AS `totalArticles` FROM `faq_categories` AS `fc`
 LEFT JOIN (SELECT `faq_categories`.`parent_id`, COUNT(cat_id) AS `count` FROM `faq_categories` GROUP BY `parent_id`) AS `childCount` ON childCount.parent_id = fc.cat_id
 LEFT JOIN (SELECT `ac`.`category_id`, COUNT(ac.faq_id) AS `count` FROM `articles_categories` AS `ac`
 INNER JOIN `tmp_visible_articles_20101` AS `tmp` ON ac.faq_id = tmp.faq_id GROUP BY `category_id`) AS `totalArticles` ON totalArticles.category_id = fc.cat_id WHERE (fc.account_id = 2) ORDER BY `fc`.`position` ASC, `fc`.`cat_name` ASC
0.0005490779876709
SELECT `gcp`.`category_id` FROM `users_groups` AS `ug`
 LEFT JOIN `groups_permissions` AS `gp` ON gp.group_id = ug.group_id
 LEFT JOIN `groups_categories_permissions` AS `gcp` ON gcp.group_id = gp.group_id WHERE (user_id = -1) AND (gp.permission = 'ActPrmCategoryCreateEdit') AND (gp.value = '1')
0.00046277046203613
SELECT `gcp`.`category_id` FROM `users_groups` AS `ug`
 LEFT JOIN `groups_permissions` AS `gp` ON gp.group_id = ug.group_id
 LEFT JOIN `groups_categories_permissions` AS `gcp` ON gcp.group_id = gp.group_id WHERE (user_id = -1) AND (gp.permission = 'ActPrmCategoryDelete') AND (gp.value = '1')
0.00047206878662109
SELECT `gcp`.`category_id` FROM `users_groups` AS `ug`
 LEFT JOIN `groups_permissions` AS `gp` ON gp.group_id = ug.group_id
 LEFT JOIN `groups_categories_permissions` AS `gcp` ON gcp.group_id = gp.group_id WHERE (user_id = -1) AND (gp.permission = 'ActPrmArticleCreateEdit') AND (gp.value = '1')
0.00058603286743164
SELECT `gcp`.`category_id` FROM `users_groups` AS `ug`
 LEFT JOIN `groups_permissions` AS `gp` ON gp.group_id = ug.group_id
 LEFT JOIN `groups_categories_permissions` AS `gcp` ON gcp.group_id = gp.group_id WHERE (user_id = -1) AND (gp.permission = 'ActPrmArticleDelete') AND (gp.value = '1')
0.0022718906402588
SELECT `fa`.`faq_id` AS `faqId`, `fa`.`question`, `fa`.`code`, `fa`.`featured`, `fa`.`rating`, `fa`.`views`, CASE
                                                     WHEN (`public` = 'Y' AND (((public_start_date <= '2013-05-24 01:52:41') OR (public_start_date IS NULL))
                                                            AND (public_end_date IS NULL OR public_end_date >= '2013-05-24 01:52:41')))
                                                     THEN 'Y'
                                                     ELSE 'N'
                                                  END  AS `public`, `fa`.`faq_date` AS `date`, `fa`.`status_change_date` AS `lastEditDate`, `ac`.`category_id` FROM `faq_articles` AS `fa`
 INNER JOIN `tmp_visible_articles_20101` AS `tmp` ON fa.faq_id = tmp.faq_id
 LEFT JOIN `articles_categories` AS `ac` ON ac.faq_id = fa.faq_id WHERE (ac.category_id IN (8,16,32,131) ) ORDER BY `fa`.`featured` ASC, `fa`.`question` asc
0.0011270046234131
SELECT `tpl_layouts`.`layout_id`, `tpl_layouts`.`template` FROM `tpl_layouts` WHERE (theme_id = 4) AND (layout_name = 'Article')
0.0014598369598389
SELECT `lb`.`block_id`, `lbc`.`block_name`, `lbc`.`template` FROM `tpl_layouts_blocks` AS `lb`
 INNER JOIN `tpl_blocks` AS `lbc` ON lbc.block_id = lb.block_id WHERE (layout_id = 59)
0.0017261505126953
SELECT `tpl_snippets`.`template`, `tpl_snippets`.`snippet_name`, `tpl_snippets`.`block_id` FROM `tpl_snippets` WHERE (theme_id = 4)
0.00048995018005371
SELECT `languages`.`lang_id` FROM `languages` WHERE (lang = 'def')
0.0074458122253418
SELECT `languages_vars`.`language_var`, `languages_vars`.`value` FROM `languages_vars` WHERE (lang_id = 1) AND (type != 'notification')
0.0083529949188232
SELECT `languages_vars`.`language_var`, `languages_vars`.`value` FROM `languages_vars` WHERE (lang_id = 2) AND (type != 'notification')
Max Query Time:Query:
0.13518905639648
SELECT `fa`.`faq_id` AS `faqId`, `fa`.`question`, `fa`.`code`, `fa`.`views`, `fa`.`rating`, `fa`.`featured`, `fa`.`answer`, CASE
                                            WHEN (`public` = 'Y' AND (((public_start_date <= '2013-05-24 01:52:41') OR (public_start_date IS NULL))
                                                    AND (public_end_date IS NULL OR public_end_date >= '2013-05-24 01:52:41')))
                                            THEN 'Y'
                                            ELSE 'N'
                                        END  AS `public`, `fa`.`faq_date` AS `date`, `fa`.`status_change_date` AS `lastEditDate`, `fa`.`public_start_date` AS `publicStartDate` FROM `faq_articles` AS `fa` WHERE (fa.faq_id IN (4873,4872,4871,4870,4869,4865,4864,4863,4862,4861)) AND (fa.status = 'moderated') ORDER BY `fa`.`real_creation_date` DESC, `faq_id` DESC
Total SQL Time:Queries Num:
0.66447925567627
159