Alliance Retail Management Group Inc.

34 queries took 246 ms
Nr	Query	Affected	Num. rows	Took (ms)
1	DESCRIBE `users`	12	12	8
2	DESCRIBE `groups`	5	5	11
3	DESCRIBE `accesses`	6	6	9
4	DESCRIBE `provinces`	4	4	14
5	DESCRIBE `stores`	10	10	9
6	DESCRIBE `banners`	4	4	8
7	DESCRIBE `vendors`	4	4	8
8	DESCRIBE `products`	9	9	11
9	DESCRIBE `call_report_entries`	10	10	10
10	DESCRIBE `call_reports`	8	8	11
11	DESCRIBE `cycles`	6	6	15
12	DESCRIBE `cycles_products`	3	3	17
13	DESCRIBE `sa_funds_report_entries`	11	11	9
14	DESCRIBE `sa_funds_reports`	6	6	9
15	DESCRIBE `sa_funds_report_entry_cheques`	6	6	16
16	SELECT `User`.`id`, `User`.`first_name`, `User`.`last_name`, `User`.`phone`, `User`.`fax`, `User`.`province_id`, `User`.`email`, `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`, `Province`.`id`, `Province`.`name`, `Province`.`date_created`, `Province`.`date_modified` FROM `users` AS `User` LEFT JOIN `groups` AS `Group` ON (`User`.`group_id` = `Group`.`id`) LEFT JOIN `provinces` AS `Province` ON (`User`.`province_id` = `Province`.`id`) WHERE `User`.`email` IS NULL AND `User`.`password` IS NULL AND `User`.`id` IS NULL AND `User`.`active` = 1 LIMIT 1	0	0	0
17	SELECT `Group`.`id`, `Group`.`name`, `Group`.`linkage`, `Group`.`date_created`, `Group`.`date_modified` FROM `groups` AS `Group` WHERE `Group`.`linkage` = 'ANONYMOUS' LIMIT 1	1	1	0
18	SELECT `User`.`id`, `User`.`first_name`, `User`.`last_name`, `User`.`phone`, `User`.`fax`, `User`.`province_id`, `User`.`email`, `User`.`password`, `User`.`group_id`, `User`.`date_created`, `User`.`date_modified`, `User`.`active` FROM `users` AS `User` WHERE `User`.`group_id` IN (3)	0	0	0
19	SELECT `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)	21	21	0
20	SELECT `Setting`.`id`, `Setting`.`name`, `Setting`.`value` FROM `settings` AS `Setting` WHERE 1 = 1	4	4	0
21	DESCRIBE `navigations`	8	8	18
22	DESCRIBE `navigation_sections`	21	21	14
23	DESCRIBE `groups_navigations`	3	3	10
24	DESCRIBE `pages`	9	9	17
25	DESCRIBE `page_histories`	9	9	14
26	DESCRIBE `groups_pages`	3	3	8
27	SELECT `User`.`id`, `User`.`first_name`, `User`.`last_name`, `User`.`phone`, `User`.`fax`, `User`.`province_id`, `User`.`email`, `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`, `Province`.`id`, `Province`.`name`, `Province`.`date_created`, `Province`.`date_modified` FROM `users` AS `User` LEFT JOIN `groups` AS `Group` ON (`User`.`group_id` = `Group`.`id`) LEFT JOIN `provinces` AS `Province` ON (`User`.`province_id` = `Province`.`id`) WHERE `User`.`email` IS NULL AND `User`.`password` IS NULL AND `User`.`id` IS NULL AND `User`.`active` = 1 LIMIT 1	0	0	0
28	SELECT `Group`.`id`, `Group`.`name`, `Group`.`linkage`, `Group`.`date_created`, `Group`.`date_modified` FROM `groups` AS `Group` WHERE `Group`.`linkage` = 'ANONYMOUS' LIMIT 1	1	1	0
29	SELECT `User`.`id`, `User`.`first_name`, `User`.`last_name`, `User`.`phone`, `User`.`fax`, `User`.`province_id`, `User`.`email`, `User`.`password`, `User`.`group_id`, `User`.`date_created`, `User`.`date_modified`, `User`.`active` FROM `users` AS `User` WHERE `User`.`group_id` IN (3)	0	0	0
30	SELECT `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)	21	21	0
31	SELECT `Setting`.`id`, `Setting`.`name`, `Setting`.`value` FROM `settings` AS `Setting` WHERE 1 = 1	4	4	0
32	SELECT `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 1	1	1	0
33	SELECT `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	5	5	0
34	SELECT `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, 13, 15, 14) AND `GroupsNavigation`.`group_id` = `Group`.`id`)	16	16	0

34 queries took 246 ms

Query

Error

Affected

Num. rows

Took (ms)

DESCRIBE `users`

DESCRIBE `groups`

DESCRIBE `accesses`

DESCRIBE `provinces`

DESCRIBE `stores`

DESCRIBE `banners`

DESCRIBE `vendors`

DESCRIBE `products`

DESCRIBE `call_report_entries`

DESCRIBE `call_reports`

DESCRIBE `cycles`

DESCRIBE `cycles_products`

DESCRIBE `sa_funds_report_entries`

DESCRIBE `sa_funds_reports`

DESCRIBE `sa_funds_report_entry_cheques`

SELECT `User`.`id`, `User`.`first_name`, `User`.`last_name`, `User`.`phone`, `User`.`fax`, `User`.`province_id`, `User`.`email`, `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`, `Province`.`id`, `Province`.`name`, `Province`.`date_created`, `Province`.`date_modified` FROM `users` AS `User` LEFT JOIN `groups` AS `Group` ON (`User`.`group_id` = `Group`.`id`) LEFT JOIN `provinces` AS `Province` ON (`User`.`province_id` = `Province`.`id`) WHERE `User`.`email` IS NULL AND `User`.`password` IS NULL AND `User`.`id` IS NULL AND `User`.`active` = 1 LIMIT 1

SELECT `Group`.`id`, `Group`.`name`, `Group`.`linkage`, `Group`.`date_created`, `Group`.`date_modified` FROM `groups` AS `Group` WHERE `Group`.`linkage` = 'ANONYMOUS' LIMIT 1

SELECT `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)

SELECT `Setting`.`id`, `Setting`.`name`, `Setting`.`value` FROM `settings` AS `Setting` WHERE 1 = 1

DESCRIBE `navigations`

DESCRIBE `navigation_sections`

DESCRIBE `groups_navigations`

DESCRIBE `pages`

DESCRIBE `page_histories`

DESCRIBE `groups_pages`

SELECT `Group`.`id`, `Group`.`name`, `Group`.`linkage`, `Group`.`date_created`, `Group`.`date_modified` FROM `groups` AS `Group` WHERE `Group`.`linkage` = 'ANONYMOUS' LIMIT 1

SELECT `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)

SELECT `Setting`.`id`, `Setting`.`name`, `Setting`.`value` FROM `settings` AS `Setting` WHERE 1 = 1

SELECT `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 1

SELECT `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

SELECT `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, 13, 15, 14) AND `GroupsNavigation`.`group_id` = `Group`.`id`)