Master Graphics
CAD SolutionsManufacturing DivisionAEC DivisionEducation Division
 
Imaging
Visualization and Workflow Management
StudioMGI
DataWorksMGI
 
43 queries took 30 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1DESCRIBE `providers`441
2DESCRIBE `pages`25251
3DESCRIBE `users`10101
4DESCRIBE `groups`771
5DESCRIBE `permissions`441
6DESCRIBE `headers`991
7DESCRIBE `templates`331
8DESCRIBE `tags`221
9DESCRIBE `documents`991
10DESCRIBE `logos`881
11SELECT `Page`.`id`, `Page`.`user_id`, `Page`.`parent_id`, `Page`.`lft`, `Page`.`rght`, `Page`.`is_container`, `Page`.`is_locked`, `Page`.`slug`, `Page`.`fullslug`, `Page`.`template_id`, `Page`.`header_id`, `Page`.`tag_id`, `Page`.`title`, `Page`.`alttitle`, `Page`.`header`, `Page`.`content`, `Page`.`keywords`, `Page`.`description`, `Page`.`showAd`, `Page`.`showBlog`, `Page`.`content_replacement`, `Page`.`classlink`, `Page`.`related`, `Page`.`created`, `Page`.`modified`, `Provider`.`id`, `Provider`.`type_id`, `Provider`.`title`, `Provider`.`data`, `Template`.`id`, `Template`.`title`, `Template`.`filename` FROM `pages` AS `Page` LEFT JOIN `providers` AS `Provider` ON (`Page`.`content_replacement`=`Provider`.`id`) LEFT JOIN `templates` AS `Template` ON (`Page`.`template_id`=`Template`.`id`) WHERE `Page`.`fullslug` = 'home' LIMIT 1111
12SELECT `Provider`.`id`, `Provider`.`type_id`, `Provider`.`title`, `Provider`.`data` FROM `providers` AS `Provider` WHERE `Provider`.`id` = 0 000
13SELECT `Template`.`id`, `Template`.`title`, `Template`.`filename` FROM `templates` AS `Template` WHERE `Template`.`id` = 1 110
14SELECT `Document`.`id`, `Document`.`user_id`, `Document`.`sort`, `Document`.`filename`, `Document`.`filesize`, `Document`.`title`, `Document`.`description`, `Document`.`created`, `Document`.`modified` FROM `documents` AS `Document` JOIN `pages_documents` ON (`pages_documents`.`page_id` = 1 AND `pages_documents`.`document_id`=`Document`.`id`) WHERE 1 = 1 001
15SELECT `Logo`.`id`, `Logo`.`user_id`, `Logo`.`sort`, `Logo`.`link_id`, `Logo`.`title`, `Logo`.`filename`, `Logo`.`created`, `Logo`.`modified` FROM `logos` AS `Logo` JOIN `pages_logos` ON (`pages_logos`.`page_id` = 1 AND `pages_logos`.`logo_id`=`Logo`.`id`) WHERE 1 = 1 111
16SELECT `Link`.`id`, `Link`.`user_id`, `Link`.`parent_id`, `Link`.`lft`, `Link`.`rght`, `Link`.`is_container`, `Link`.`is_locked`, `Link`.`slug`, `Link`.`fullslug`, `Link`.`template_id`, `Link`.`header_id`, `Link`.`tag_id`, `Link`.`title`, `Link`.`alttitle`, `Link`.`header`, `Link`.`content`, `Link`.`keywords`, `Link`.`description`, `Link`.`showAd`, `Link`.`showBlog`, `Link`.`content_replacement`, `Link`.`classlink`, `Link`.`related`, `Link`.`created`, `Link`.`modified` FROM `pages` AS `Link` WHERE `Link`.`id` = 29 110
17SELECT `Header`.`title`, `Header`.`filename` FROM `headers` AS `Header` WHERE `Header`.`id` = 0 LIMIT 1000
18 SELECT Header.title, Header.filename FROM headers AS Header LEFT JOIN headers_tags ON Header.id = headers_tags.header_id WHERE Header.template_id = 2 AND headers_tags.tag_id = 1 ORDER BY RAND(NOW()) LIMIT 1000
19 SELECT Header.id, Header.title, Header.filename FROM headers AS Header LEFT JOIN headers_tags ON Header.id = headers_tags.header_id WHERE Header.template_id = 2 ORDER BY RAND(NOW()) LIMIT 1114
20SELECT `Page`.`id` FROM `pages` AS `Page` WHERE `slug` = 'vertical' LIMIT 1110
21SELECT `Page`.`title`, `Page`.`fullslug`, `Page`.`header` FROM `pages` AS `Page` WHERE `Page`.`parent_id` = 50 330
22SELECT `Page`.`id` FROM `pages` AS `Page` WHERE `Page`.`slug` = 'primary' LIMIT 1110
23SELECT `Page`.`id`, `Page`.`fullslug`, `Page`.`slug`, `Page`.`title`, `Page`.`parent_id` FROM `pages` AS `Page` WHERE `Page`.`parent_id` = 42 ORDER BY `lft` ASC 991
24SELECT `Page`.`id` FROM `pages` AS `Page` WHERE `Page`.`slug` = 'software' LIMIT 1110
25SELECT `Page`.`id`, `Page`.`fullslug`, `Page`.`slug`, `Page`.`title`, `Page`.`parent_id` FROM `pages` AS `Page` WHERE `Page`.`parent_id` = 9 ORDER BY `lft` ASC 881
26SELECT `Page`.`id` FROM `pages` AS `Page` WHERE `Page`.`slug` = 'hardware' LIMIT 1110
27SELECT `Page`.`id`, `Page`.`fullslug`, `Page`.`slug`, `Page`.`title`, `Page`.`parent_id` FROM `pages` AS `Page` WHERE `Page`.`parent_id` = 8 ORDER BY `lft` ASC 881
28SELECT `Page`.`id` FROM `pages` AS `Page` WHERE `Page`.`slug` = 'training' LIMIT 1110
29SELECT `Page`.`id`, `Page`.`fullslug`, `Page`.`slug`, `Page`.`title`, `Page`.`parent_id` FROM `pages` AS `Page` WHERE `Page`.`parent_id` = 29 ORDER BY `lft` ASC 661
30SELECT `Page`.`id` FROM `pages` AS `Page` WHERE `Page`.`slug` = 'support' LIMIT 1110
31SELECT `Page`.`id`, `Page`.`fullslug`, `Page`.`slug`, `Page`.`title`, `Page`.`parent_id` FROM `pages` AS `Page` WHERE `Page`.`parent_id` = 12 ORDER BY `lft` ASC 881
32SELECT `Page`.`id` FROM `pages` AS `Page` WHERE `Page`.`slug` = 'services' LIMIT 1110
33SELECT `Page`.`id`, `Page`.`fullslug`, `Page`.`slug`, `Page`.`title`, `Page`.`parent_id` FROM `pages` AS `Page` WHERE `Page`.`parent_id` = 11 ORDER BY `lft` ASC 661
34SELECT `Page`.`id` FROM `pages` AS `Page` WHERE `Page`.`slug` = 'promotions' LIMIT 1111
35SELECT `Page`.`id`, `Page`.`fullslug`, `Page`.`slug`, `Page`.`title`, `Page`.`parent_id` FROM `pages` AS `Page` WHERE `Page`.`parent_id` = 365 ORDER BY `lft` ASC 441
36SELECT `Page`.`id` FROM `pages` AS `Page` WHERE `Page`.`slug` = 'events' LIMIT 1111
37SELECT `Page`.`id`, `Page`.`fullslug`, `Page`.`slug`, `Page`.`title`, `Page`.`parent_id` FROM `pages` AS `Page` WHERE `Page`.`parent_id` = 30 ORDER BY `lft` ASC 331
38SELECT `Page`.`id` FROM `pages` AS `Page` WHERE `Page`.`slug` = 'e-store' LIMIT 1110
39SELECT `Page`.`id`, `Page`.`fullslug`, `Page`.`slug`, `Page`.`title`, `Page`.`parent_id` FROM `pages` AS `Page` WHERE `Page`.`parent_id` = 31 ORDER BY `lft` ASC 001
40SELECT `Page`.`id` FROM `pages` AS `Page` WHERE `Page`.`slug` = 'help' LIMIT 1110
41SELECT `Page`.`id`, `Page`.`fullslug`, `Page`.`slug`, `Page`.`title`, `Page`.`parent_id` FROM `pages` AS `Page` WHERE `Page`.`parent_id` = 484 ORDER BY `lft` ASC 001
42SELECT `Page`.`id` FROM `pages` AS `Page` WHERE `Page`.`slug` = 'secondary' LIMIT 1110
43SELECT `Page`.`id`, `Page`.`fullslug`, `Page`.`slug`, `Page`.`title`, `Page`.`parent_id` FROM `pages` AS `Page` WHERE `Page`.`parent_id` = 44 ORDER BY `lft` ASC 551