QUERY: 

SHOW FULL COLUMNS FROM `jobs`

QUERY: 

SHOW INDEXES FROM `jobs`

QUERY: 

SELECT * FROM information_schema.key_column_usage AS kcu
            INNER JOIN information_schema.referential_constraints AS rc
            ON (
                kcu.CONSTRAINT_NAME = rc.CONSTRAINT_NAME
                AND kcu.CONSTRAINT_SCHEMA = rc.CONSTRAINT_SCHEMA
            )
            WHERE kcu.TABLE_SCHEMA = ? AND kcu.TABLE_NAME = ? AND rc.TABLE_NAME = ?

QUERY: 

SHOW TABLE STATUS WHERE Name = ?

QUERY: 

SHOW FULL COLUMNS FROM `users`

QUERY: 

SHOW INDEXES FROM `users`

QUERY: 

SELECT * FROM information_schema.key_column_usage AS kcu
            INNER JOIN information_schema.referential_constraints AS rc
            ON (
                kcu.CONSTRAINT_NAME = rc.CONSTRAINT_NAME
                AND kcu.CONSTRAINT_SCHEMA = rc.CONSTRAINT_SCHEMA
            )
            WHERE kcu.TABLE_SCHEMA = ? AND kcu.TABLE_NAME = ? AND rc.TABLE_NAME = ?

QUERY: 

SHOW TABLE STATUS WHERE Name = ?

QUERY: 

SELECT Jobs.id AS `Jobs__id`, Jobs.name AS `Jobs__name`, Jobs.user_id AS `Jobs__user_id`, Users.id AS `Users__id`, Users.name AS `Users__name`, UserTypes.id AS `UserTypes__id`, UserTypes.name AS `UserTypes__name`, UsersUserTypes.id AS `UsersUserTypes__id`, UsersUserTypes.user_id AS `UsersUserTypes__user_id`, UsersUserTypes.user_type_id AS `UsersUserTypes__user_type_id` FROM jobs Jobs INNER JOIN users Users ON Users.id = (Jobs.user_id) INNER JOIN user_types UserTypes ON UserTypes.name = :c0 INNER JOIN users_user_types UsersUserTypes ON (Users.id = (UsersUserTypes.user_id) AND UserTypes.id = (UsersUserTypes.user_type_id)) LIMIT 20 OFFSET 0

QUERY: 

SELECT Users.id AS `Users__id`, Users.name AS `Users__name`, UserTypes.id AS `UserTypes__id`, UserTypes.name AS `UserTypes__name`, UsersUserTypes.id AS `UsersUserTypes__id`, UsersUserTypes.user_id AS `UsersUserTypes__user_id`, UsersUserTypes.user_type_id AS `UsersUserTypes__user_type_id` FROM users Users INNER JOIN user_types UserTypes ON UserTypes.name = :c0 INNER JOIN users_user_types UsersUserTypes ON (Users.id = (UsersUserTypes.user_id) AND UserTypes.id = (UsersUserTypes.user_type_id)) WHERE Users.id in (:c1)

QUERY: 

SELECT (COUNT(*)) AS `count` FROM jobs Jobs INNER JOIN users Users ON (UserTypes.name = :c0 AND Users.id = (Jobs.user_id)) INNER JOIN user_types UserTypes ON UserTypes.name = :c1 INNER JOIN users_user_types UsersUserTypes ON (Users.id = (UsersUserTypes.user_id) AND UserTypes.id = (UsersUserTypes.user_type_id))