Learn About CAURA
 
 
29 queries took 10 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1DESCRIBE `gallery_images`551
2SELECT `User`.`id`, `User`.`first_name`, `User`.`last_name`, `User`.`company`, `User`.`phone`, `User`.`fax`, `User`.`phone_alt`, `User`.`email`, `User`.`shipping_address1`, `User`.`shipping_address2`, `User`.`shipping_city`, `User`.`shipping_state_id`, `User`.`shipping_country_id`, `User`.`shipping_zipcode`, `User`.`billing_address1`, `User`.`billing_address2`, `User`.`billing_city`, `User`.`billing_state_id`, `User`.`billing_country_id`, `User`.`billing_zipcode`, `User`.`password`, `User`.`group_id`, `User`.`date_created`, `User`.`date_modified`, `User`.`active`, `Group`.`id`, `Group`.`name`, `Group`.`linkage`, `Group`.`date_created`, `Group`.`date_modified` FROM `users` AS `User` LEFT JOIN `groups` AS `Group` ON (`User`.`group_id` = `Group`.`id`) WHERE `User`.`email` IS NULL AND `User`.`password` IS NULL AND `User`.`id` IS NULL AND `User`.`active` = 1 LIMIT 1000
3SELECT `Group`.`id`, `Group`.`name`, `Group`.`linkage`, `Group`.`date_created`, `Group`.`date_modified` FROM `groups` AS `Group` WHERE `Group`.`linkage` = 'ANONYMOUS' LIMIT 1110
4SELECT `User`.`id`, `User`.`first_name`, `User`.`last_name`, `User`.`company`, `User`.`phone`, `User`.`fax`, `User`.`phone_alt`, `User`.`email`, `User`.`shipping_address1`, `User`.`shipping_address2`, `User`.`shipping_city`, `User`.`shipping_state_id`, `User`.`shipping_country_id`, `User`.`shipping_zipcode`, `User`.`billing_address1`, `User`.`billing_address2`, `User`.`billing_city`, `User`.`billing_state_id`, `User`.`billing_country_id`, `User`.`billing_zipcode`, `User`.`password`, `User`.`group_id`, `User`.`date_created`, `User`.`date_modified`, `User`.`active` FROM `users` AS `User` WHERE `User`.`group_id` IN (3) 000
5SELECT `Access`.`id`, `Access`.`group_id`, `Access`.`controller`, `Access`.`action`, `Access`.`date_created`, `Access`.`date_modified` FROM `accesses` AS `Access` WHERE `Access`.`group_id` IN (3) 31310
6SELECT `Setting`.`id`, `Setting`.`name`, `Setting`.`value` FROM `settings` AS `Setting` WHERE 1 = 1 220
7SELECT `GalleryImage`.`id`, `GalleryImage`.`caption`, `GalleryImage`.`file`, `GalleryImage`.`date_created`, `GalleryImage`.`date_modified` FROM `gallery_images` AS `GalleryImage` WHERE `GalleryImage`.`id` = 44 LIMIT 1110
8DESCRIBE `navigations`881
9DESCRIBE `navigation_sections`21212
10DESCRIBE `groups_navigations`331
11DESCRIBE `pages`11111
12DESCRIBE `page_histories`991
13DESCRIBE `groups_pages`331
14SELECT `User`.`id`, `User`.`first_name`, `User`.`last_name`, `User`.`company`, `User`.`phone`, `User`.`fax`, `User`.`phone_alt`, `User`.`email`, `User`.`shipping_address1`, `User`.`shipping_address2`, `User`.`shipping_city`, `User`.`shipping_state_id`, `User`.`shipping_country_id`, `User`.`shipping_zipcode`, `User`.`billing_address1`, `User`.`billing_address2`, `User`.`billing_city`, `User`.`billing_state_id`, `User`.`billing_country_id`, `User`.`billing_zipcode`, `User`.`password`, `User`.`group_id`, `User`.`date_created`, `User`.`date_modified`, `User`.`active`, `Group`.`id`, `Group`.`name`, `Group`.`linkage`, `Group`.`date_created`, `Group`.`date_modified` FROM `users` AS `User` LEFT JOIN `groups` AS `Group` ON (`User`.`group_id` = `Group`.`id`) WHERE `User`.`email` IS NULL AND `User`.`password` IS NULL AND `User`.`id` IS NULL AND `User`.`active` = 1 LIMIT 1000
15SELECT `Group`.`id`, `Group`.`name`, `Group`.`linkage`, `Group`.`date_created`, `Group`.`date_modified` FROM `groups` AS `Group` WHERE `Group`.`linkage` = 'ANONYMOUS' LIMIT 1110
16SELECT `User`.`id`, `User`.`first_name`, `User`.`last_name`, `User`.`company`, `User`.`phone`, `User`.`fax`, `User`.`phone_alt`, `User`.`email`, `User`.`shipping_address1`, `User`.`shipping_address2`, `User`.`shipping_city`, `User`.`shipping_state_id`, `User`.`shipping_country_id`, `User`.`shipping_zipcode`, `User`.`billing_address1`, `User`.`billing_address2`, `User`.`billing_city`, `User`.`billing_state_id`, `User`.`billing_country_id`, `User`.`billing_zipcode`, `User`.`password`, `User`.`group_id`, `User`.`date_created`, `User`.`date_modified`, `User`.`active` FROM `users` AS `User` WHERE `User`.`group_id` IN (3) 000
17SELECT `Access`.`id`, `Access`.`group_id`, `Access`.`controller`, `Access`.`action`, `Access`.`date_created`, `Access`.`date_modified` FROM `accesses` AS `Access` WHERE `Access`.`group_id` IN (3) 31310
18SELECT `Setting`.`id`, `Setting`.`name`, `Setting`.`value` FROM `settings` AS `Setting` WHERE 1 = 1 220
19SELECT `NavigationSection`.`id`, `NavigationSection`.`name`, `NavigationSection`.`linkage`, `NavigationSection`.`style`, `NavigationSection`.`font-family`, `NavigationSection`.`image`, `NavigationSection`.`image_hover`, `NavigationSection`.`image_active`, `NavigationSection`.`font-color`, `NavigationSection`.`font-color_hover`, `NavigationSection`.`font-color_active`, `NavigationSection`.`center`, `NavigationSection`.`xcoord`, `NavigationSection`.`ycoord`, `NavigationSection`.`font-size`, `NavigationSection`.`vertical`, `NavigationSection`.`seperator`, `NavigationSection`.`date_created`, `NavigationSection`.`date_modified`, `NavigationSection`.`upper_case`, `NavigationSection`.`dropdown` FROM `navigation_sections` AS `NavigationSection` WHERE `linkage` = 'main' LIMIT 1110
20SELECT `Navigation`.`id`, `Navigation`.`label`, `Navigation`.`navigation_section_id`, `Navigation`.`url`, `Navigation`.`order`, `Navigation`.`parent_id`, `Navigation`.`date_created`, `Navigation`.`date_modified` FROM `navigations` AS `Navigation` WHERE `Navigation`.`navigation_section_id` = 1 ORDER BY `Navigation`.`order` ASC 880
21SELECT `Group`.`id`, `Group`.`name`, `Group`.`linkage`, `Group`.`date_created`, `Group`.`date_modified`, `GroupsNavigation`.`id`, `GroupsNavigation`.`navigation_id`, `GroupsNavigation`.`group_id` FROM `groups` AS `Group` LEFT JOIN `groups_navigations` AS `GroupsNavigation` ON (`GroupsNavigation`.`navigation_id` IN (1, 2, 25, 16, 22, 24, 48, 3) AND `GroupsNavigation`.`group_id` = `Group`.`id`) 31311
22SELECT `User`.`id`, `User`.`first_name`, `User`.`last_name`, `User`.`company`, `User`.`phone`, `User`.`fax`, `User`.`phone_alt`, `User`.`email`, `User`.`shipping_address1`, `User`.`shipping_address2`, `User`.`shipping_city`, `User`.`shipping_state_id`, `User`.`shipping_country_id`, `User`.`shipping_zipcode`, `User`.`billing_address1`, `User`.`billing_address2`, `User`.`billing_city`, `User`.`billing_state_id`, `User`.`billing_country_id`, `User`.`billing_zipcode`, `User`.`password`, `User`.`group_id`, `User`.`date_created`, `User`.`date_modified`, `User`.`active`, `Group`.`id`, `Group`.`name`, `Group`.`linkage`, `Group`.`date_created`, `Group`.`date_modified` FROM `users` AS `User` LEFT JOIN `groups` AS `Group` ON (`User`.`group_id` = `Group`.`id`) WHERE `User`.`email` IS NULL AND `User`.`password` IS NULL AND `User`.`id` IS NULL AND `User`.`active` = 1 LIMIT 1000
23SELECT `Group`.`id`, `Group`.`name`, `Group`.`linkage`, `Group`.`date_created`, `Group`.`date_modified` FROM `groups` AS `Group` WHERE `Group`.`linkage` = 'ANONYMOUS' LIMIT 1110
24SELECT `User`.`id`, `User`.`first_name`, `User`.`last_name`, `User`.`company`, `User`.`phone`, `User`.`fax`, `User`.`phone_alt`, `User`.`email`, `User`.`shipping_address1`, `User`.`shipping_address2`, `User`.`shipping_city`, `User`.`shipping_state_id`, `User`.`shipping_country_id`, `User`.`shipping_zipcode`, `User`.`billing_address1`, `User`.`billing_address2`, `User`.`billing_city`, `User`.`billing_state_id`, `User`.`billing_country_id`, `User`.`billing_zipcode`, `User`.`password`, `User`.`group_id`, `User`.`date_created`, `User`.`date_modified`, `User`.`active` FROM `users` AS `User` WHERE `User`.`group_id` IN (3) 000
25SELECT `Access`.`id`, `Access`.`group_id`, `Access`.`controller`, `Access`.`action`, `Access`.`date_created`, `Access`.`date_modified` FROM `accesses` AS `Access` WHERE `Access`.`group_id` IN (3) 31310
26SELECT `Setting`.`id`, `Setting`.`name`, `Setting`.`value` FROM `settings` AS `Setting` WHERE 1 = 1 220
27SELECT `NavigationSection`.`id`, `NavigationSection`.`name`, `NavigationSection`.`linkage`, `NavigationSection`.`style`, `NavigationSection`.`font-family`, `NavigationSection`.`image`, `NavigationSection`.`image_hover`, `NavigationSection`.`image_active`, `NavigationSection`.`font-color`, `NavigationSection`.`font-color_hover`, `NavigationSection`.`font-color_active`, `NavigationSection`.`center`, `NavigationSection`.`xcoord`, `NavigationSection`.`ycoord`, `NavigationSection`.`font-size`, `NavigationSection`.`vertical`, `NavigationSection`.`seperator`, `NavigationSection`.`date_created`, `NavigationSection`.`date_modified`, `NavigationSection`.`upper_case`, `NavigationSection`.`dropdown` FROM `navigation_sections` AS `NavigationSection` WHERE `linkage` = 'bottom' LIMIT 1110
28SELECT `Navigation`.`id`, `Navigation`.`label`, `Navigation`.`navigation_section_id`, `Navigation`.`url`, `Navigation`.`order`, `Navigation`.`parent_id`, `Navigation`.`date_created`, `Navigation`.`date_modified` FROM `navigations` AS `Navigation` WHERE `Navigation`.`navigation_section_id` = 2 ORDER BY `Navigation`.`order` ASC 880
29SELECT `Group`.`id`, `Group`.`name`, `Group`.`linkage`, `Group`.`date_created`, `Group`.`date_modified`, `GroupsNavigation`.`id`, `GroupsNavigation`.`navigation_id`, `GroupsNavigation`.`group_id` FROM `groups` AS `Group` LEFT JOIN `groups_navigations` AS `GroupsNavigation` ON (`GroupsNavigation`.`navigation_id` IN (11, 12, 14, 26, 28, 29, 49, 30) AND `GroupsNavigation`.`group_id` = `Group`.`id`) 31311