Object GET:


Groups: alias, foreign, local, class, type, table, localTable, name, refTable, onDelete, onUpdate, deferred, deferrable, constraint, equal, cascade, owningSide, refClassRelationAlias,
RELATIONS: Users, UserGroup, Grouptypes

Email: alias, foreign, local, class, type, table, localTable, name, refTable, onDelete, onUpdate, deferred, deferrable, constraint, equal, cascade, owningSide, refClassRelationAlias,
RELATIONS: User

Phone: alias, foreign, local, class, type, table, localTable, name, refTable, onDelete, onUpdate, deferred, deferrable, constraint, equal, cascade, owningSide, refClassRelationAlias,
RELATIONS: User, AreaCode

UserGroup: alias, foreign, local, class, type, table, localTable, name, refTable, onDelete, onUpdate, deferred, deferrable, constraint, equal, cascade, owningSide, refClassRelationAlias,
RELATIONS: User, Group

from = User User, User.Groups Groups, User.Email Email, User.Phone Phone, User.UserGroup UserGroup

User

id: 2
username: tyndall
password: doctrine99
email_id: 2
Groups:
	- id: 2
	- name: Lead

	- id: 3
	- name: Documentation

	- id: 5
	- name: Mathematician

	- id: 4
	- name: Swamped


Email:
	- id: 2
	- email: tyndall@blackpulp.com

Phone:
	- id: 3
	- owner_id: 2
	- phone: 713.545.8989
	- areacode_id: 1

	- id: 4
	- owner_id: 2
	- phone: 832-593-0909
	- areacode_id: 2

	- id: 5
	- owner_id: 2
	- phone: 713.320.6709
	- areacode_id: 1


UserGroup:
	- id: 5
	- user_id: 2
	- group_id: 2

	- id: 6
	- user_id: 2
	- group_id: 3

	- id: 7
	- user_id: 2
	- group_id: 5

	- id: 8
	- user_id: 2
	- group_id: 4


User

id: 1
username: travis
password: starcat11
email_id: 1
Groups:
	- id: 1
	- name: Founder

	- id: 2
	- name: Lead

	- id: 3
	- name: Documentation

	- id: 4
	- name: Swamped


Email:
	- id: 1
	- email: travis@blackpulp.com

Phone:
	- id: 1
	- owner_id: 1
	- phone: 832-387-7604
	- areacode_id: 2

	- id: 2
	- owner_id: 1
	- phone: 281-465-8178
	- areacode_id: 3


UserGroup:
	- id: 1
	- user_id: 1
	- group_id: 1

	- id: 2
	- user_id: 1
	- group_id: 2

	- id: 3
	- user_id: 1
	- group_id: 3

	- id: 4
	- user_id: 1
	- group_id: 4






Debug Footer



SELECT u.id AS u__id, u.username AS u__username, u.password AS u__password, u.email_id AS u__email_id, g.id AS g__id, g.name AS g__name, e.id AS e__id, e.email AS e__email, p.id AS p__id, p.owner_id AS p__owner_id, p.phone AS p__phone, p.areacode_id AS p__areacode_id, u3.id AS u3__id, u3.user_id AS u3__user_id, u3.group_id AS u3__group_id FROM user u LEFT JOIN user_group u2 ON u.id = u2.user_id LEFT JOIN groups g ON g.id = u2.group_id LEFT JOIN email e ON u.email_id = e.id LEFT JOIN phone p ON u.id = p.owner_id LEFT JOIN user_group u3 ON u.id = u3.user_id WHERE u.id IN (SELECT DISTINCT u4.id FROM user u4 LEFT JOIN user_group u5 ON u4.id = u5.user_id LEFT JOIN groups g2 ON g2.id = u5.group_id LEFT JOIN email e2 ON u4.email_id = e2.id LEFT JOIN phone p2 ON u4.id = p2.owner_id LEFT JOIN user_group u6 ON u4.id = u6.user_id WHERE u4.id > '0' ORDER BY u4.username DESC LIMIT 2) AND u.id > '0' ORDER BY u.username DESC

Query time: 0.0278630256653


Total Time:  0.133906126022