Browse
 
Tools Add
Rss Categories
-->

Changing Passwords on a Linux VPS

Reference Number: AA-01152 Created: 2012-09-21 13:50 Last Updated: 2012-10-09 13:05 0 Rating/ Voters

Server Backups

myhosting.com performs regular backups of all Virtual servers for our own disaster recovery purposes.


Backups for Windows Virtuozzo Virtual Server

If you manage your Virtual Server through the control panel at https://manage.myhosting.com you have a server that is configured in our Virtuozzo environment. We keep a backup for disaster recovery purposes for our servers but for your own backup purposes you would need to order a backup plan for your server. The steps for ordering a backup service is listed below.


Backups for Classic Linux Virtual Servers

If you manage your Virtual Server account through the control panel at https://admin.myhosting.com you have a Classic Linux Server. We run full backups for all these servers once a week and differential backups every day. We keep the last two full backups on file. Should you require a server restoration we can do this for you for $50.00. All server restorations are done between business hours Monday through Friday (9:00AM - 5:00PM).


The software used for the Linux backups is Bacula


Backups for Virtuozzo Linux Virtual Servers

If you manage your Virtual Server through the control panel at https://manage.myhosting.com you have a server that is configured in our Virtuozzo environment. We keep a backup for disaster recovery purposes for our servers but for your own backup purposes you would need to order a backup plan for your server. The steps for ordering a backup service is listed below.


Ordering Backup Service for Virtuozzo Virtual Servers

To add a backup service to your Virtuozzo virtual server you would need to follow the steps outlined below.


  • Next click on the Subscriptions link under the Subscription section.
  • Click on the ID link for the server you want to setup backups for.
  • Then click on the "Resources" tab.
  • Here you will see that there are several scheduled backup plans. The dates for the backup plans indicate that they are for Saturday or Sunday but that can be edited to any day of the week. The scheduled backups are available at four times during the day six hours apart. The timing for these can't be switched so you would want to pick the plan with the time thats best for you. There are also manual backup options and this will allow you to go into your control panel and run a backup right away whenever you need to. If you want to have the system routinely do the backups you'd need a scheduled plan and not the manual one.


Once your backup plan is enabled you would then have a new option under your subscription for managing your backups. To manage the backups log into the control panel and select a subscription that has backups enabled. You would then click on the VPS Management link and this would then display for you the link for managing your backups.

Rss Comments
  • There are no comments for this article.
Info Add Comment
Nickname: Your Email: Subject: Comment:
Knowledge Management Software by: KnowledgeBase Manager Pro v6.1.0 (Built with: JS.GUI - Rich Internet Applications)
0.00465989112854
SELECT `sys_settings`.`var_name`, `sys_settings`.`var_value` FROM `sys_settings`
0.00062918663024902
SELECT `languages`.`lang_id` FROM `languages` WHERE (lang = 'def')
0.0087580680847168
SELECT `languages_vars`.`language_var`, `languages_vars`.`value` FROM `languages_vars` WHERE (lang_id = 1) AND (type != 'notification')
0.0073480606079102
SELECT `languages_vars`.`language_var`, `languages_vars`.`value` FROM `languages_vars` WHERE (lang_id = 1) AND (type != 'notification')
0.00064611434936523
SELECT `sys_settings`.`var_value` FROM `sys_settings` WHERE (var_name = 'session_life_time_unlimited')
0.00065398216247559
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.00047993659973145
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.00055503845214844
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.00049686431884766
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.00041389465332031
SELECT COUNT(*) AS `count` FROM `accounts` WHERE (LOWER(name) != 'preview')
0.0004730224609375
SELECT `accounts`.`name` FROM `accounts` WHERE (LOWER(name) != 'preview') ORDER BY `account_id` ASC LIMIT 1
0.00092506408691406
SELECT `view_manage`.`view_id`, `view_manage`.`name` FROM `view_manage` WHERE (type       = 'Hosted') AND (account_id = 2)
0.00078988075256348
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.00048589706420898
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.0034658908843994
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.00093603134155273
SELECT `votings`.* FROM `votings` WHERE (voting_id = 1)
0.00050711631774902
SELECT `voting_items`.`item_title` AS `title`, `voting_items`.`value` FROM `voting_items` WHERE (voting_id = 1) ORDER BY `value` DESC
0.00211501121521
SELECT `view_styles`.* FROM `view_styles` WHERE (style_id = 4)
0.00061821937561035
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.00062203407287598
SELECT `languages`.`name` AS `text`, `languages`.`lang_id` AS `value` FROM `languages` WHERE (status = 'on') AND (lang != 'def') ORDER BY `lang_id` ASC
0.00094485282897949
SELECT `gmt`.* FROM `gmt` ORDER BY `offset` ASC
0.00055313110351562
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.0010080337524414
SELECT `view_manage`.`view_id`, `view_manage`.`name` FROM `view_manage` WHERE (type       = 'Hosted') AND (account_id = 2)
0.00067687034606934
SELECT `view_manage`.`settings` FROM `view_manage` WHERE (view_id = 2)
0.00050592422485352
UPDATE `view_manage` SET `views_num` = views_num + 1, `last_view_date` = ? WHERE (view_id = 2)
0.00061297416687012
SELECT `faq_articles`.`faq_id` FROM `faq_articles` WHERE (code = 'AA-01152') AND (account_id = 2) AND (status = 'moderated')
0.00037097930908203
DROP TABLE IF EXISTS `tmp_visible_articles_20101`;
0.00037097930908203
DROP TABLE IF EXISTS `tmp_visible_articles_20101`;
0.00091290473937988
CREATE TEMPORARY TABLE `tmp_visible_articles_20101` (`faq_id` int PRIMARY KEY) ENGINE=MEMORY
0.10423994064331
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-23 22:50:35' OR public_start_date IS NULL)
                                    AND
                                  (public_end_date IS NULL OR public_end_date >= '2013-05-23 22:50:35')
                                ))
0.0016980171203613
SELECT `tmp_visible_articles_20101`.`faq_id` FROM `tmp_visible_articles_20101`
0.043326139450073
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.0019299983978271
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-23 22:50:35') OR (public_start_date IS NULL))
                                                    AND (public_end_date IS NULL OR public_end_date >= '2013-05-23 22:50:35')))
                                            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.00064301490783691
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.00051712989807129
SELECT `faq_categories`.`cat_name`, `faq_categories`.`cat_id`, `faq_categories`.`parent_id` FROM `faq_categories` WHERE (cat_id = 8)
0.00050997734069824
SELECT `faq_categories`.`cat_name`, `faq_categories`.`cat_id`, `faq_categories`.`parent_id` FROM `faq_categories` WHERE (cat_id = 17)
0.00080418586730957
SELECT `faq_categories`.`cat_name`, `faq_categories`.`cat_id`, `faq_categories`.`parent_id` FROM `faq_categories` WHERE (cat_id = 8)
0.00050687789916992
SELECT `faq_categories`.`cat_name`, `faq_categories`.`cat_id`, `faq_categories`.`parent_id` FROM `faq_categories` WHERE (cat_id = 35)
0.0006260871887207
SELECT `faq_categories`.`cat_name`, `faq_categories`.`cat_id`, `faq_categories`.`parent_id` FROM `faq_categories` WHERE (cat_id = 17)
0.00047206878662109
SELECT `faq_categories`.`cat_name`, `faq_categories`.`cat_id`, `faq_categories`.`parent_id` FROM `faq_categories` WHERE (cat_id = 37)
0.00066614151000977
SELECT `faq_categories`.`cat_name`, `faq_categories`.`cat_id`, `faq_categories`.`parent_id` FROM `faq_categories` WHERE (cat_id = 35)
0.00051093101501465
SELECT `faq_categories`.`cat_name`, `faq_categories`.`cat_id`, `faq_categories`.`parent_id` FROM `faq_categories` WHERE (cat_id = 206)
0.00048398971557617
SELECT `faq_categories`.`cat_name`, `faq_categories`.`cat_id`, `faq_categories`.`parent_id` FROM `faq_categories` WHERE (cat_id = 200)
0.00044989585876465
SELECT `faq_categories`.`cat_name`, `faq_categories`.`cat_id`, `faq_categories`.`parent_id` FROM `faq_categories` WHERE (cat_id = 221)
0.00071001052856445
SELECT `faq_categories`.`cat_name`, `faq_categories`.`cat_id`, `faq_categories`.`parent_id` FROM `faq_categories` WHERE (cat_id = 207)
0.00059795379638672
SELECT `faq_categories`.`cat_name`, `faq_categories`.`cat_id`, `faq_categories`.`parent_id` FROM `faq_categories` WHERE (cat_id = 354)
0.0005648136138916
SELECT `faq_categories`.`cat_name`, `faq_categories`.`cat_id`, `faq_categories`.`parent_id` FROM `faq_categories` WHERE (cat_id = 205)
0.00052213668823242
SELECT `faq_categories`.`cat_name`, `faq_categories`.`cat_id`, `faq_categories`.`parent_id` FROM `faq_categories` WHERE (cat_id = 355)
0.0005347728729248
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.00050497055053711
SELECT `faq_categories`.`cat_name`, `faq_categories`.`cat_id`, `faq_categories`.`parent_id` FROM `faq_categories` WHERE (cat_id = 368)
0.00065517425537109
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.00054502487182617
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.00054216384887695
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.00067687034606934
SELECT `faq_categories`.`cat_name`, `faq_categories`.`cat_id`, `faq_categories`.`parent_id` FROM `faq_categories` WHERE (cat_id = 356)
0.00046706199645996
SELECT `faq_categories`.`cat_name`, `faq_categories`.`cat_id`, `faq_categories`.`parent_id` FROM `faq_categories` WHERE (cat_id = 34)
0.00056791305541992
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.00072002410888672
SELECT `faq_categories`.`cat_name`, `faq_categories`.`cat_id`, `faq_categories`.`parent_id` FROM `faq_categories` WHERE (cat_id = 284)
0.00050902366638184
SELECT `faq_categories`.`cat_name`, `faq_categories`.`cat_id`, `faq_categories`.`parent_id` FROM `faq_categories` WHERE (cat_id = 315)
0.0005040168762207
SELECT `faq_categories`.`cat_name`, `faq_categories`.`cat_id`, `faq_categories`.`parent_id` FROM `faq_categories` WHERE (cat_id = 215)
0.00056004524230957
SELECT `faq_categories`.`cat_name`, `faq_categories`.`cat_id`, `faq_categories`.`parent_id` FROM `faq_categories` WHERE (cat_id = 212)
0.048933982849121
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.0035099983215332
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-23 22:50:35') OR (public_start_date IS NULL))
                                                    AND (public_end_date IS NULL OR public_end_date >= '2013-05-23 22:50:35')))
                                            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.00060486793518066
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.0006248950958252
SELECT `faq_categories`.`cat_name`, `faq_categories`.`cat_id`, `faq_categories`.`parent_id` FROM `faq_categories` WHERE (cat_id = 147)
0.00047016143798828
SELECT `faq_categories`.`cat_name`, `faq_categories`.`cat_id`, `faq_categories`.`parent_id` FROM `faq_categories` WHERE (cat_id = 357)
0.00050902366638184
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.00060510635375977
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.00058197975158691
SELECT `faq_categories`.`cat_name`, `faq_categories`.`cat_id`, `faq_categories`.`parent_id` FROM `faq_categories` WHERE (cat_id = 36)
0.00062918663024902
SELECT `faq_categories`.`cat_name`, `faq_categories`.`cat_id`, `faq_categories`.`parent_id` FROM `faq_categories` WHERE (cat_id = 358)
0.00055480003356934
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.0004889965057373
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.00053286552429199
SELECT `faq_categories`.`cat_name`, `faq_categories`.`cat_id`, `faq_categories`.`parent_id` FROM `faq_categories` WHERE (cat_id = 183)
0.00074911117553711
SELECT `faq_categories`.`cat_name`, `faq_categories`.`cat_id`, `faq_categories`.`parent_id` FROM `faq_categories` WHERE (cat_id = 182)
0.00072097778320312
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.00074982643127441
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.00084090232849121
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.00046110153198242
SELECT `faq_categories`.`cat_name`, `faq_categories`.`cat_id`, `faq_categories`.`parent_id` FROM `faq_categories` WHERE (cat_id = 19)
0.00090289115905762
SELECT `faq_categories`.`cat_name`, `faq_categories`.`cat_id`, `faq_categories`.`parent_id` FROM `faq_categories` WHERE (cat_id = 9)
0.0005030632019043
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.00076889991760254
SELECT `faq_categories`.`cat_name`, `faq_categories`.`cat_id`, `faq_categories`.`parent_id` FROM `faq_categories` WHERE (cat_id = 142)
0.0004420280456543
SELECT `faq_categories`.`cat_name`, `faq_categories`.`cat_id`, `faq_categories`.`parent_id` FROM `faq_categories` WHERE (cat_id = 33)
0.0012528896331787
SELECT `faq_categories`.`cat_name`, `faq_categories`.`cat_id`, `faq_categories`.`parent_id` FROM `faq_categories` WHERE (cat_id = 16)
0.049065113067627
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.051512002944946
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-23 22:50:35') OR (public_start_date IS NULL))
                                                    AND (public_end_date IS NULL OR public_end_date >= '2013-05-23 22:50:35')))
                                            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.0006251335144043
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.00062918663024902
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.00053095817565918
SELECT `faq_categories`.`cat_name`, `faq_categories`.`cat_id`, `faq_categories`.`parent_id` FROM `faq_categories` WHERE (cat_id = 18)
0.00049114227294922
SELECT `faq_categories`.`cat_name`, `faq_categories`.`cat_id`, `faq_categories`.`parent_id` FROM `faq_categories` WHERE (cat_id = 47)
0.00045609474182129
SELECT `faq_categories`.`cat_name`, `faq_categories`.`cat_id`, `faq_categories`.`parent_id` FROM `faq_categories` WHERE (cat_id = 25)
0.00043392181396484
SELECT `faq_categories`.`cat_name`, `faq_categories`.`cat_id`, `faq_categories`.`parent_id` FROM `faq_categories` WHERE (cat_id = 11)
0.00042200088500977
SELECT `faq_categories`.`cat_name`, `faq_categories`.`cat_id`, `faq_categories`.`parent_id` FROM `faq_categories` WHERE (cat_id = 7)
0.00081801414489746
SELECT `faq_categories`.`cat_name`, `faq_categories`.`cat_id`, `faq_categories`.`parent_id` FROM `faq_categories` WHERE (cat_id = 66)
0.00066208839416504
SELECT `faq_categories`.`cat_name`, `faq_categories`.`cat_id`, `faq_categories`.`parent_id` FROM `faq_categories` WHERE (cat_id = 24)
0.00054311752319336
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.00060415267944336
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.00043487548828125
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.00054597854614258
SELECT `faq_categories`.`cat_name`, `faq_categories`.`cat_id`, `faq_categories`.`parent_id` FROM `faq_categories` WHERE (cat_id = 130)
0.00052213668823242
SELECT `faq_categories`.`cat_name`, `faq_categories`.`cat_id`, `faq_categories`.`parent_id` FROM `faq_categories` WHERE (cat_id = 32)
0.00066685676574707
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.00073981285095215
SELECT `faq_categories`.`cat_name`, `faq_categories`.`cat_id`, `faq_categories`.`parent_id` FROM `faq_categories` WHERE (cat_id = 79)
0.0005190372467041
SELECT `faq_categories`.`cat_name`, `faq_categories`.`cat_id`, `faq_categories`.`parent_id` FROM `faq_categories` WHERE (cat_id = 27)
0.00047683715820312
SELECT `faq_categories`.`cat_name`, `faq_categories`.`cat_id`, `faq_categories`.`parent_id` FROM `faq_categories` WHERE (cat_id = 12)
0.00054311752319336
SELECT `faq_categories`.`cat_name`, `faq_categories`.`cat_id`, `faq_categories`.`parent_id` FROM `faq_categories` WHERE (cat_id = 98)
0.0008080005645752
SELECT `faq_categories`.`cat_name`, `faq_categories`.`cat_id`, `faq_categories`.`parent_id` FROM `faq_categories` WHERE (cat_id = 26)
0.00049710273742676
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.00047183036804199
SELECT `faq_categories`.`cat_name`, `faq_categories`.`cat_id`, `faq_categories`.`parent_id` FROM `faq_categories` WHERE (cat_id = 81)
0.00062704086303711
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.00049090385437012
SELECT `faq_categories`.`cat_name`, `faq_categories`.`cat_id`, `faq_categories`.`parent_id` FROM `faq_categories` WHERE (cat_id = 247)
0.00065302848815918
SELECT `faq_categories`.`cat_name`, `faq_categories`.`cat_id`, `faq_categories`.`parent_id` FROM `faq_categories` WHERE (cat_id = 246)
0.050195932388306
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.13532900810242
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-23 22:50:36') OR (public_start_date IS NULL))
                                                    AND (public_end_date IS NULL OR public_end_date >= '2013-05-23 22:50:36')))
                                            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.00060701370239258
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.00054621696472168
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.00049614906311035
SELECT `faq_categories`.`cat_name`, `faq_categories`.`cat_id`, `faq_categories`.`parent_id` FROM `faq_categories` WHERE (cat_id = 371)
0.00055503845214844
SELECT `faq_categories`.`cat_name`, `faq_categories`.`cat_id`, `faq_categories`.`parent_id` FROM `faq_categories` WHERE (cat_id = 210)
0.00050497055053711
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.00046491622924805
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.00071287155151367
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.00054502487182617
SELECT `faq_categories`.`cat_name`, `faq_categories`.`cat_id`, `faq_categories`.`parent_id` FROM `faq_categories` WHERE (cat_id = 231)
0.00053000450134277
SELECT `faq_categories`.`cat_name`, `faq_categories`.`cat_id`, `faq_categories`.`parent_id` FROM `faq_categories` WHERE (cat_id = 209)
0.00052309036254883
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.00057101249694824
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.00049805641174316
SELECT `faq_categories`.`cat_name`, `faq_categories`.`cat_id`, `faq_categories`.`parent_id` FROM `faq_categories` WHERE (cat_id = 312)
0.00044512748718262
SELECT `faq_categories`.`cat_name`, `faq_categories`.`cat_id`, `faq_categories`.`parent_id` FROM `faq_categories` WHERE (cat_id = 310)
0.00057196617126465
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.00051712989807129
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.0013079643249512
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-23 22:50:36') OR (public_start_date IS NULL))
                                                    AND (public_end_date IS NULL OR public_end_date >= '2013-05-23 22:50:36')))
                                              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 = 1079)) 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 = 1079) AND ( (far.`public` = 'Y' AND (((far.public_start_date <= '2013-05-23 22:50:36') OR (far.public_start_date IS NULL)) AND (far.public_end_date IS NULL OR far.public_end_date >= '2013-05-23 22:50:36')))) LIMIT 1
0.00079011917114258
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 = 1079) AND (v_com.comment_status != 'delete') AND (v_com.comment_status != 'new') ORDER BY `v_com_date` DESC, `u_com_date` ASC
0.00064492225646973
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 = 1079) AND (feedback NOT LIKE '')
0.0010740756988525
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.0009920597076416
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 = 1079) ORDER BY `cf_id` ASC
0.0006558895111084
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 = 1079)
0.001007080078125
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 = 1079)
0.00086593627929688
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.00045990943908691
SELECT FOUND_ROWS()
0.00075578689575195
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 = 1079) ORDER BY `date` DESC
0.0004420280456543
SELECT `faq_articles`.`freeAccess`, `faq_articles`.`account_id` FROM `faq_articles` WHERE (faq_id = 1079)
0.0011820793151855
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 = 1079) AND (g.account_id = 2) ORDER BY `g`.`name` ASC
0.0072238445281982
SELECT COUNT(*) AS `num` FROM `drafts` WHERE (account_id = 2) AND (user_id = -1) AND (question NOT LIKE '' OR answer NOT LIKE '')
0.0082569122314453
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 = 1079) AND (dr.user_id = -1) AND ((fa.faq_date < dr.draft_date OR fa.status_change_date < dr.draft_date))
0.00091099739074707
UPDATE `faq_articles` SET `views` = ? WHERE (faq_id = 1079)
0.00060391426086426
SELECT `terms`.`term_id`, `terms`.`term`, `terms`.`term_description` AS `description` FROM `terms` WHERE (account_id = 2)
0.00058794021606445
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 = 1079) ORDER BY `name` ASC
0.0004119873046875
SELECT FOUND_ROWS()
0.00061678886413574
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.0051119327545166
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.015398025512695
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.00076103210449219
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.00053095817565918
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.00072503089904785
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.00063705444335938
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.0019099712371826
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-23 22:50:36') OR (public_start_date IS NULL))
                                                            AND (public_end_date IS NULL OR public_end_date >= '2013-05-23 22:50:36')))
                                                     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,17,34,357,147) ) ORDER BY `fa`.`featured` ASC, `fa`.`question` asc
0.00058913230895996
SELECT `faq_categories`.`cat_name`, `faq_categories`.`cat_id`, `faq_categories`.`parent_id` FROM `faq_categories` WHERE (cat_id = 34)
0.00048112869262695
SELECT `faq_categories`.`cat_name`, `faq_categories`.`cat_id`, `faq_categories`.`parent_id` FROM `faq_categories` WHERE (cat_id = 357)
0.00095701217651367
SELECT `tpl_layouts`.`layout_id`, `tpl_layouts`.`template` FROM `tpl_layouts` WHERE (theme_id = 4) AND (layout_name = 'Article')
0.0013251304626465
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.0016229152679443
SELECT `tpl_snippets`.`template`, `tpl_snippets`.`snippet_name`, `tpl_snippets`.`block_id` FROM `tpl_snippets` WHERE (theme_id = 4)
0.00056099891662598
SELECT `languages`.`lang_id` FROM `languages` WHERE (lang = 'def')
0.0082879066467285
SELECT `languages_vars`.`language_var`, `languages_vars`.`value` FROM `languages_vars` WHERE (lang_id = 1) AND (type != 'notification')
0.0078980922698975
SELECT `languages_vars`.`language_var`, `languages_vars`.`value` FROM `languages_vars` WHERE (lang_id = 2) AND (type != 'notification')
Max Query Time:Query:
0.13532900810242
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-23 22:50:36') OR (public_start_date IS NULL))
                                                    AND (public_end_date IS NULL OR public_end_date >= '2013-05-23 22:50:36')))
                                            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.65752935409546
160