1 | SHOW FULL COLUMNS FROM `users` | | 29 | 29 | 1 |
2 | SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'latin1_swedish_ci'; | | 1 | 1 | 1 |
3 | SHOW FULL COLUMNS FROM `plans_users` | | 8 | 8 | 1 |
4 | SELECT `User`.`id`, `User`.`username`, `User`.`password`, `User`.`email`, `User`.`first_name`, `User`.`last_name`, `User`.`company_name`, `User`.`company_url`, `User`.`domain_id`, `User`.`site_id`, `User`.`slug`, `User`.`address`, `User`.`city`, `User`.`state`, `User`.`zip`, `User`.`phone`, `User`.`last_login`, `User`.`active`, `User`.`company_id`, `User`.`facebook_id`, `User`.`ad_account`, `User`.`facebook_user_id`, `User`.`stripe_customer_id`, `User`.`data`, `User`.`fields`, `User`.`newsletter`, `User`.`subdomain_id`, `User`.`created`, `User`.`modified`, (CONCAT(`User`.`first_name`, ' ', `User`.`last_name`)) AS `User__full_name`, (CONCAT(`User`.`address`, ' ', `User`.`city`, ', ', `User`.`state`, ' ', `User`.`zip`)) AS `User__address_1line`, (CONCAT(`User`.`city`, ', ', `User`.`state`, ' ', `User`.`zip`)) AS `User__address_2line`, (CONCAT(`User`.`city`, ', ', `User`.`state`)) AS `User__address_2line_nozip` FROM `users` AS `User` WHERE `User`.`id` IS NULL LIMIT 1 | | 0 | 0 | 1 |
5 | SELECT `User`.`id`, `User`.`username`, `User`.`password`, `User`.`email`, `User`.`first_name`, `User`.`last_name`, `User`.`company_name`, `User`.`company_url`, `User`.`domain_id`, `User`.`site_id`, `User`.`slug`, `User`.`address`, `User`.`city`, `User`.`state`, `User`.`zip`, `User`.`phone`, `User`.`last_login`, `User`.`active`, `User`.`company_id`, `User`.`facebook_id`, `User`.`ad_account`, `User`.`facebook_user_id`, `User`.`stripe_customer_id`, `User`.`data`, `User`.`fields`, `User`.`newsletter`, `User`.`subdomain_id`, `User`.`created`, `User`.`modified`, (CONCAT(`User`.`first_name`, ' ', `User`.`last_name`)) AS `User__full_name`, (CONCAT(`User`.`address`, ' ', `User`.`city`, ', ', `User`.`state`, ' ', `User`.`zip`)) AS `User__address_1line`, (CONCAT(`User`.`city`, ', ', `User`.`state`, ' ', `User`.`zip`)) AS `User__address_2line`, (CONCAT(`User`.`city`, ', ', `User`.`state`)) AS `User__address_2line_nozip` FROM `users` AS `User` WHERE `User`.`id` IS NULL LIMIT 1 | | 0 | 0 | 1 |