Sell Your Home on Barter! - Barter Trading Floor - Great Trade Solutions, Inc.

Code | Context

$boot	=	true
$shellPaths	=	null
$localePaths	=	null
$vendorPaths	=	null
$pluginPaths	=	null
$helperPaths	=	null
$viewPaths	=	null
$componentPaths	=	null
$controllerPaths	=	null
$behaviorPaths	=	null
$modelPaths	=	null
$cache_dirs	=	array(
	"/home/httpd/htdocs/barter21/app/tmp/cache//exchange/gts/",
	"/home/httpd/htdocs/barter21/app/tmp/cache//exchange/gts/persistent/",
	"/home/httpd/htdocs/barter21/app/tmp/cache//exchange/gts/models/"
)
$dir	=	"/home/httpd/htdocs/barter21/app/tmp/cache//exchange/gts/models/"
$cache	=	false


                if (empty($cache['settings'])) {
                    trigger_error('Cache not configured properly. Please check Cache::config(); in APP/config/core.php', E_USER_WARNING);

Configure::__loadBootstrap() - CORE/cake/libs/configure.php, line 663
Configure::getInstance() - CORE/cake/libs/configure.php, line 137
require - CORE/cake/bootstrap.php, line 43
[main] - APP/webroot/index.php, line 78

Code | Context

$boot	=	true
$shellPaths	=	null
$localePaths	=	null
$vendorPaths	=	null
$pluginPaths	=	null
$helperPaths	=	null
$viewPaths	=	null
$componentPaths	=	null
$controllerPaths	=	null
$behaviorPaths	=	null
$modelPaths	=	null
$cache_dirs	=	array(
	"/home/httpd/htdocs/barter21/app/tmp/cache//exchange/gts/",
	"/home/httpd/htdocs/barter21/app/tmp/cache//exchange/gts/persistent/",
	"/home/httpd/htdocs/barter21/app/tmp/cache//exchange/gts/models/"
)
$dir	=	"/home/httpd/htdocs/barter21/app/tmp/cache//exchange/gts/models/"
$cache	=	false
$duration	=	"+10 seconds"
$prefix	=	null
$path	=	null

array_merge - [internal], line ??
Configure::__loadBootstrap() - CORE/cake/libs/configure.php, line 684
Configure::getInstance() - CORE/cake/libs/configure.php, line 137
require - CORE/cake/bootstrap.php, line 43
[main] - APP/webroot/index.php, line 78

Code | Context

$boot	=	true
$shellPaths	=	null
$localePaths	=	null
$vendorPaths	=	null
$pluginPaths	=	null
$helperPaths	=	null
$viewPaths	=	null
$componentPaths	=	null
$controllerPaths	=	null
$behaviorPaths	=	null
$modelPaths	=	null
$cache_dirs	=	array(
	"/home/httpd/htdocs/barter21/app/tmp/cache//exchange/gts/",
	"/home/httpd/htdocs/barter21/app/tmp/cache//exchange/gts/persistent/",
	"/home/httpd/htdocs/barter21/app/tmp/cache//exchange/gts/models/"
)
$dir	=	"/home/httpd/htdocs/barter21/app/tmp/cache//exchange/gts/models/"
$cache	=	false
$duration	=	"+10 seconds"
$prefix	=	null
$path	=	null

array_merge - [internal], line ??
Configure::__loadBootstrap() - CORE/cake/libs/configure.php, line 691
Configure::getInstance() - CORE/cake/libs/configure.php, line 137
require - CORE/cake/bootstrap.php, line 43
[main] - APP/webroot/index.php, line 78

Trading Floor

You must be logged in to view Trading Floor item details.

Forgot your password?

Unread Messages
[close]

(default) 84 queries took 1716 ms
Nr	Query	Affected	Num. rows	Took (ms)
1	DESCRIBE `items`	24	24	1
2	DESCRIBE `users`	19	19	1
3	DESCRIBE `permissions`	5	5	1
4	DESCRIBE `users_permissions`	3	3	1
5	DESCRIBE `businesses`	92	92	3
6	DESCRIBE `exchanges`	74	74	2
7	DESCRIBE `regions`	35	35	1
8	DESCRIBE `currencies`	4	4	1
9	DESCRIBE `processors`	5	5	1
10	DESCRIBE `notes`	8	8	35
11	DESCRIBE `categories`	3	3	4
12	DESCRIBE `businesses_users`	2	2	2
13	DESCRIBE `businesses_categories`	2	2	1
14	DESCRIBE `photos`	7	7	2
15	DESCRIBE `items_photos`	3	3	1
16	DESCRIBE `items_categories`	2	2	0
17	DESCRIBE `items_primary`	6	6	1
18	DESCRIBE `items_secondary`	6	6	1
19	DESCRIBE `items_leftrail`	6	6	1
20	DESCRIBE `banlist`	2	2	38
21	SELECT `Banlist`.`id`, `Banlist`.`created` FROM `banlist` AS `Banlist` WHERE `Banlist`.`id` = '38.107.179.242' LIMIT 1	0	0	46
22	SELECT `Exchange`.`id`, `Exchange`.`name`, `Exchange`.`shortname`, `Exchange`.`status`, `Exchange`.`httpd`, `Exchange`.`emails`, `Exchange`.`messenger`, `Exchange`.`daily_emails`, `Exchange`.`monthly_fees`, `Exchange`.`annual_fees`, `Exchange`.`monthly_statements`, `Exchange`.`monthly_backups`, `Exchange`.`past_due`, `Exchange`.`late_fees`, `Exchange`.`description`, `Exchange`.`created`, `Exchange`.`network`, `Exchange`.`domain`, `Exchange`.`domain_aliases`, `Exchange`.`messenger_reply`, `Exchange`.`page_title_suffix`, `Exchange`.`page_description`, `Exchange`.`credit`, `Exchange`.`credit_limit`, `Exchange`.`balance`, `Exchange`.`barter21_cash_fee`, `Exchange`.`barter21_barter_fee`, `Exchange`.`barter21_monthly_fee_max`, `Exchange`.`barter21_monthly_fee_min`, `Exchange`.`barter21_monthly_barter_fee_max`, `Exchange`.`barter21_monthly_barter_fee_min`, `Exchange`.`barter21_buyer_fee`, `Exchange`.`barter21_seller_fee`, `Exchange`.`default_currency`, `Exchange`.`default_business_seller_cash_fee`, `Exchange`.`default_business_seller_barter_fee`, `Exchange`.`default_business_buyer_cash_fee`, `Exchange`.`default_business_buyer_barter_fee`, `Exchange`.`default_business_credit_limit`, `Exchange`.`collections_minimum`, `Exchange`.`barter_fee_tax`, `Exchange`.`cash_fee_tax`, `Exchange`.`signup_cash_fee`, `Exchange`.`signup_barter_fee`, `Exchange`.`monthly_admin_cash_fee`, `Exchange`.`monthly_admin_barter_fee`, `Exchange`.`annual_renewal_cash_fee`, `Exchange`.`annual_renewal_barter_fee`, `Exchange`.`statement_grace_period`, `Exchange`.`late_fee`, `Exchange`.`late_fee_grace_period`, `Exchange`.`late_fee_minimum`, `Exchange`.`owner`, `Exchange`.`reconcile`, `Exchange`.`timezone`, `Exchange`.`language`, `Exchange`.`locale`, `Exchange`.`google_analytics_account`, `Exchange`.`skin`, `Exchange`.`theme`, `Exchange`.`theme_params`, `Exchange`.`tax_rate`, `Exchange`.`annual_fee_setting`, `Exchange`.`monlthy_fee_setting`, `Exchange`.`mailchimp_api_key`, `Exchange`.`mailchimp_list_id`, `Exchange`.`default_trading_floor_view`, `Exchange`.`default_daily_email_view`, `Exchange`.`default_role_id`, `Exchange`.`required_ein`, `Exchange`.`required_payment`, `Exchange`.`accepts_eft`, `Exchange`.`accepts_cc`, `Exchange`.`allowable_credit_card_types`, `Owner`.`id`, `Owner`.`name`, `Owner`.`owner` FROM `exchanges` AS `Exchange` LEFT JOIN `businesses` AS `Owner` ON (`Exchange`.`owner` = `Owner`.`id`) WHERE `Exchange`.`shortname` = 'gts' LIMIT 1	1	1	88
23	SELECT `Region`.`id`, `Region`.`name`, `Region`.`shortname`, `Region`.`description`, `Region`.`exchange_id`, `Region`.`timezone`, `Region`.`language`, `Region`.`locale`, `Region`.`currency_id`, `Region`.`processor_currency`, `Region`.`domain`, `Region`.`theme`, `Region`.`skin`, `Region`.`theme_params`, `Region`.`cash_fee_tax`, `Region`.`barter_fee_tax`, `Region`.`collections_minimum`, `Region`.`signup_cash_fee`, `Region`.`signup_barter_fee`, `Region`.`monthly_admin_cash_fee`, `Region`.`monthly_admin_barter_fee`, `Region`.`annual_renewal_cash_fee`, `Region`.`annual_renewal_barter_fee`, `Region`.`statement_grace_period`, `Region`.`late_fee`, `Region`.`late_fee_minimum`, `Region`.`late_fee_grace_period`, `Region`.`default_business_seller_cash_fee`, `Region`.`default_business_seller_barter_fee`, `Region`.`default_business_buyer_cash_fee`, `Region`.`default_business_buyer_barter_fee`, `Region`.`default_business_credit_limit`, `Region`.`operations_account`, `Region`.`store_approval`, `Region`.`store_autobuy` FROM `regions` AS `Region` WHERE `Region`.`exchange_id` = (41) ORDER BY `name` ASC	1	1	197
24	SELECT `Business`.`id`, `Business`.`display_id`, `Business`.`created`, `Business`.`modified`, `Business`.`active`, `Business`.`visible`, `Business`.`local_sell`, `Business`.`local_buy`, `Business`.`buy_hold`, `Business`.`sell_hold`, `Business`.`broker_managed`, `Business`.`reciprocal_account`, `Business`.`process_annual_fees`, `Business`.`spend_down`, `Business`.`name`, `Business`.`region_id`, `Business`.`photo_id`, `Business`.`exchange_id`, `Business`.`broker`, `Business`.`salesperson`, `Business`.`owner`, `Business`.`contact`, `Business`.`shortname`, `Business`.`description`, `Business`.`comment`, `Business`.`cash_credit`, `Business`.`credit`, `Business`.`credit_limit`, `Business`.`balance`, `Business`.`cash_due`, `Business`.`past_due`, `Business`.`monthly_cash`, `Business`.`monthly_barter`, `Business`.`annual_cash`, `Business`.`annual_barter`, `Business`.`ein`, `Business`.`ssn`, `Business`.`payment_method`, `Business`.`credit_card_type`, `Business`.`credit_card_number`, `Business`.`credit_card_expiration`, `Business`.`credit_card_security_code`, `Business`.`credit_card_security_code_backup`, `Business`.`echeck_checkname`, `Business`.`echeck_routing_number`, `Business`.`echeck_account_number`, `Business`.`echeck_account_class`, `Business`.`echeck_account_type`, `Business`.`echeck_bank_name`, `Business`.`billing_firstname`, `Business`.`billing_lastname`, `Business`.`billing_address1`, `Business`.`billing_city`, `Business`.`billing_state`, `Business`.`billing_zip`, `Business`.`billing_country`, `Business`.`billing_email`, `Business`.`barter_buyer_fee`, `Business`.`barter_seller_fee`, `Business`.`cash_buyer_fee`, `Business`.`cash_seller_fee`, `Business`.`email`, `Business`.`address1`, `Business`.`address2`, `Business`.`city`, `Business`.`state`, `Business`.`zipcode`, `Business`.`country`, `Business`.`phone1`, `Business`.`phone2`, `Business`.`fax1`, `Business`.`fax2`, `Business`.`url`, `Business`.`referral`, `Business`.`w9_name`, `Business`.`w9_business_name`, `Business`.`w9_business_type`, `Business`.`w9_address1`, `Business`.`w9_address2`, `Business`.`w9_country`, `Business`.`w9_city`, `Business`.`w9_state`, `Business`.`w9_zipcode`, `Business`.`w9_id`, `Business`.`w9_remote_info`, `Business`.`mailing_address1`, `Business`.`mailing_address2`, `Business`.`mailing_country`, `Business`.`mailing_city`, `Business`.`mailing_state`, `Business`.`mailing_zipcode`, `Business`.`phone3`, `Exchange`.`id`, `Exchange`.`name`, `Exchange`.`shortname`, `Exchange`.`status`, `Exchange`.`httpd`, `Exchange`.`emails`, `Exchange`.`messenger`, `Exchange`.`daily_emails`, `Exchange`.`monthly_fees`, `Exchange`.`annual_fees`, `Exchange`.`monthly_statements`, `Exchange`.`monthly_backups`, `Exchange`.`past_due`, `Exchange`.`late_fees`, `Exchange`.`description`, `Exchange`.`created`, `Exchange`.`network`, `Exchange`.`domain`, `Exchange`.`domain_aliases`, `Exchange`.`messenger_reply`, `Exchange`.`page_title_suffix`, `Exchange`.`page_description`, `Exchange`.`credit`, `Exchange`.`credit_limit`, `Exchange`.`balance`, `Exchange`.`barter21_cash_fee`, `Exchange`.`barter21_barter_fee`, `Exchange`.`barter21_monthly_fee_max`, `Exchange`.`barter21_monthly_fee_min`, `Exchange`.`barter21_monthly_barter_fee_max`, `Exchange`.`barter21_monthly_barter_fee_min`, `Exchange`.`barter21_buyer_fee`, `Exchange`.`barter21_seller_fee`, `Exchange`.`default_currency`, `Exchange`.`default_business_seller_cash_fee`, `Exchange`.`default_business_seller_barter_fee`, `Exchange`.`default_business_buyer_cash_fee`, `Exchange`.`default_business_buyer_barter_fee`, `Exchange`.`default_business_credit_limit`, `Exchange`.`collections_minimum`, `Exchange`.`barter_fee_tax`, `Exchange`.`cash_fee_tax`, `Exchange`.`signup_cash_fee`, `Exchange`.`signup_barter_fee`, `Exchange`.`monthly_admin_cash_fee`, `Exchange`.`monthly_admin_barter_fee`, `Exchange`.`annual_renewal_cash_fee`, `Exchange`.`annual_renewal_barter_fee`, `Exchange`.`statement_grace_period`, `Exchange`.`late_fee`, `Exchange`.`late_fee_grace_period`, `Exchange`.`late_fee_minimum`, `Exchange`.`owner`, `Exchange`.`reconcile`, `Exchange`.`timezone`, `Exchange`.`language`, `Exchange`.`locale`, `Exchange`.`google_analytics_account`, `Exchange`.`skin`, `Exchange`.`theme`, `Exchange`.`theme_params`, `Exchange`.`tax_rate`, `Exchange`.`annual_fee_setting`, `Exchange`.`monlthy_fee_setting`, `Exchange`.`mailchimp_api_key`, `Exchange`.`mailchimp_list_id`, `Exchange`.`default_trading_floor_view`, `Exchange`.`default_daily_email_view`, `Exchange`.`default_role_id`, `Exchange`.`required_ein`, `Exchange`.`required_payment`, `Exchange`.`accepts_eft`, `Exchange`.`accepts_cc`, `Exchange`.`allowable_credit_card_types`, `Region`.`id`, `Region`.`name`, `Region`.`shortname`, `Region`.`description`, `Region`.`exchange_id`, `Region`.`timezone`, `Region`.`language`, `Region`.`locale`, `Region`.`currency_id`, `Region`.`processor_currency`, `Region`.`domain`, `Region`.`theme`, `Region`.`skin`, `Region`.`theme_params`, `Region`.`cash_fee_tax`, `Region`.`barter_fee_tax`, `Region`.`collections_minimum`, `Region`.`signup_cash_fee`, `Region`.`signup_barter_fee`, `Region`.`monthly_admin_cash_fee`, `Region`.`monthly_admin_barter_fee`, `Region`.`annual_renewal_cash_fee`, `Region`.`annual_renewal_barter_fee`, `Region`.`statement_grace_period`, `Region`.`late_fee`, `Region`.`late_fee_minimum`, `Region`.`late_fee_grace_period`, `Region`.`default_business_seller_cash_fee`, `Region`.`default_business_seller_barter_fee`, `Region`.`default_business_buyer_cash_fee`, `Region`.`default_business_buyer_barter_fee`, `Region`.`default_business_credit_limit`, `Region`.`operations_account`, `Region`.`store_approval`, `Region`.`store_autobuy`, `Owner`.`id`, `Owner`.`username`, `Owner`.`password`, `Owner`.`role_id`, `Owner`.`status`, `Owner`.`firstname`, `Owner`.`lastname`, `Owner`.`email`, `Owner`.`address1`, `Owner`.`address2`, `Owner`.`city`, `Owner`.`state`, `Owner`.`zipcode`, `Owner`.`phone1`, `Owner`.`phone2`, `Owner`.`fax1`, `Owner`.`fax2`, `Owner`.`lastlogin_remote_info`, `Owner`.`apikey`, `Contact`.`id`, `Contact`.`username`, `Contact`.`password`, `Contact`.`role_id`, `Contact`.`status`, `Contact`.`firstname`, `Contact`.`lastname`, `Contact`.`email`, `Contact`.`address1`, `Contact`.`address2`, `Contact`.`city`, `Contact`.`state`, `Contact`.`zipcode`, `Contact`.`phone1`, `Contact`.`phone2`, `Contact`.`fax1`, `Contact`.`fax2`, `Contact`.`lastlogin_remote_info`, `Contact`.`apikey`, `Salesperson`.`id`, `Salesperson`.`username`, `Salesperson`.`password`, `Salesperson`.`role_id`, `Salesperson`.`status`, `Salesperson`.`firstname`, `Salesperson`.`lastname`, `Salesperson`.`email`, `Salesperson`.`address1`, `Salesperson`.`address2`, `Salesperson`.`city`, `Salesperson`.`state`, `Salesperson`.`zipcode`, `Salesperson`.`phone1`, `Salesperson`.`phone2`, `Salesperson`.`fax1`, `Salesperson`.`fax2`, `Salesperson`.`lastlogin_remote_info`, `Salesperson`.`apikey`, `Broker`.`id`, `Broker`.`username`, `Broker`.`password`, `Broker`.`role_id`, `Broker`.`status`, `Broker`.`firstname`, `Broker`.`lastname`, `Broker`.`email`, `Broker`.`address1`, `Broker`.`address2`, `Broker`.`city`, `Broker`.`state`, `Broker`.`zipcode`, `Broker`.`phone1`, `Broker`.`phone2`, `Broker`.`fax1`, `Broker`.`fax2`, `Broker`.`lastlogin_remote_info`, `Broker`.`apikey` FROM `businesses` AS `Business` LEFT JOIN `exchanges` AS `Exchange` ON (`Business`.`exchange_id` = `Exchange`.`id`) LEFT JOIN `regions` AS `Region` ON (`Business`.`region_id` = `Region`.`id`) LEFT JOIN `users` AS `Owner` ON (`Business`.`owner` = `Owner`.`id`) LEFT JOIN `users` AS `Contact` ON (`Business`.`contact` = `Contact`.`id`) LEFT JOIN `users` AS `Salesperson` ON (`Business`.`salesperson` = `Salesperson`.`id`) LEFT JOIN `users` AS `Broker` ON (`Business`.`broker` = `Broker`.`id`) WHERE `Business`.`id` = 3251 LIMIT 1	1	1	41
25	SELECT `Note`.`id`, `Note`.`user_id`, `Note`.`business_id`, `Note`.`update_id`, `Note`.`created`, `Note`.`modified`, `Note`.`body`, `Note`.`status` FROM `notes` AS `Note` WHERE `Note`.`business_id` = (3251) ORDER BY created DESC	1	1	1
26	SELECT `User`.`id`, `User`.`username`, `User`.`password`, `User`.`role_id`, `User`.`status`, `User`.`firstname`, `User`.`lastname`, `User`.`email`, `User`.`address1`, `User`.`address2`, `User`.`city`, `User`.`state`, `User`.`zipcode`, `User`.`phone1`, `User`.`phone2`, `User`.`fax1`, `User`.`fax2`, `User`.`lastlogin_remote_info`, `User`.`apikey`, `BusinessesUser`.`business_id`, `BusinessesUser`.`user_id` FROM `users` AS `User` JOIN `businesses_users` AS `BusinessesUser` ON (`BusinessesUser`.`business_id` = 3251 AND `BusinessesUser`.`user_id` = `User`.`id`) WHERE 1 = 1 ORDER BY username ASC	1	1	36
27	SELECT `Category`.`id`, `Category`.`name`, `Category`.`parent`, `BusinessesCategory`.`business_id`, `BusinessesCategory`.`category_id` FROM `categories` AS `Category` JOIN `businesses_categories` AS `BusinessesCategory` ON (`BusinessesCategory`.`business_id` = 3251 AND `BusinessesCategory`.`category_id` = `Category`.`id`) WHERE 1 = 1 ORDER BY name ASC	2	2	32
28	SELECT CONCAT(parent,'.',name) FROM `permissions` AS `Permission` WHERE 1 = 1	54	54	0
29	select concat(p.parent,'.',p.name) from users as u inner join roles_permissions as rp on u.role_id = rp.role_id inner join permissions as p on p.id = rp.permission_id where u.id = 1	0	0	0
30	select concat(parent,'.',name), value from users_permissions inner join permissions on permission_id = id where user_id = 1	0	0	0
31	SELECT `Item`.`id`, `Item`.`approval`, `Item`.`exchange_id`, `Item`.`currency_id`, `Item`.`stop`, `Item`.`created`, `Item`.`lastmodified`, `Item`.`emailed`, `Item`.`sorted`, `Item`.`name`, `Item`.`shortname`, `Item`.`description`, `Item`.`location`, `Item`.`zip`, `Item`.`barter`, `Item`.`inventory`, `Item`.`business_id`, `Item`.`original_business_id`, `Item`.`user_id`, `Item`.`shippable`, `Item`.`shipping_cost`, `Item`.`shipping_description`, `Item`.`condition`, `Item`.`contact`, `User`.`id`, `User`.`username`, `User`.`password`, `User`.`role_id`, `User`.`status`, `User`.`firstname`, `User`.`lastname`, `User`.`email`, `User`.`address1`, `User`.`address2`, `User`.`city`, `User`.`state`, `User`.`zipcode`, `User`.`phone1`, `User`.`phone2`, `User`.`fax1`, `User`.`fax2`, `User`.`lastlogin_remote_info`, `User`.`apikey`, `Business`.`id`, `Business`.`display_id`, `Business`.`created`, `Business`.`modified`, `Business`.`active`, `Business`.`visible`, `Business`.`local_sell`, `Business`.`local_buy`, `Business`.`buy_hold`, `Business`.`sell_hold`, `Business`.`broker_managed`, `Business`.`reciprocal_account`, `Business`.`process_annual_fees`, `Business`.`spend_down`, `Business`.`name`, `Business`.`region_id`, `Business`.`photo_id`, `Business`.`exchange_id`, `Business`.`broker`, `Business`.`salesperson`, `Business`.`owner`, `Business`.`contact`, `Business`.`shortname`, `Business`.`description`, `Business`.`comment`, `Business`.`cash_credit`, `Business`.`credit`, `Business`.`credit_limit`, `Business`.`balance`, `Business`.`cash_due`, `Business`.`past_due`, `Business`.`monthly_cash`, `Business`.`monthly_barter`, `Business`.`annual_cash`, `Business`.`annual_barter`, `Business`.`ein`, `Business`.`ssn`, `Business`.`payment_method`, `Business`.`credit_card_type`, `Business`.`credit_card_number`, `Business`.`credit_card_expiration`, `Business`.`credit_card_security_code`, `Business`.`credit_card_security_code_backup`, `Business`.`echeck_checkname`, `Business`.`echeck_routing_number`, `Business`.`echeck_account_number`, `Business`.`echeck_account_class`, `Business`.`echeck_account_type`, `Business`.`echeck_bank_name`, `Business`.`billing_firstname`, `Business`.`billing_lastname`, `Business`.`billing_address1`, `Business`.`billing_city`, `Business`.`billing_state`, `Business`.`billing_zip`, `Business`.`billing_country`, `Business`.`billing_email`, `Business`.`barter_buyer_fee`, `Business`.`barter_seller_fee`, `Business`.`cash_buyer_fee`, `Business`.`cash_seller_fee`, `Business`.`email`, `Business`.`address1`, `Business`.`address2`, `Business`.`city`, `Business`.`state`, `Business`.`zipcode`, `Business`.`country`, `Business`.`phone1`, `Business`.`phone2`, `Business`.`fax1`, `Business`.`fax2`, `Business`.`url`, `Business`.`referral`, `Business`.`w9_name`, `Business`.`w9_business_name`, `Business`.`w9_business_type`, `Business`.`w9_address1`, `Business`.`w9_address2`, `Business`.`w9_country`, `Business`.`w9_city`, `Business`.`w9_state`, `Business`.`w9_zipcode`, `Business`.`w9_id`, `Business`.`w9_remote_info`, `Business`.`mailing_address1`, `Business`.`mailing_address2`, `Business`.`mailing_country`, `Business`.`mailing_city`, `Business`.`mailing_state`, `Business`.`mailing_zipcode`, `Business`.`phone3` FROM `items` AS `Item` LEFT JOIN `users` AS `User` ON (`Item`.`user_id` = `User`.`id`) LEFT JOIN `businesses` AS `Business` ON (`Item`.`business_id` = `Business`.`id`) WHERE `Item`.`id` = 4281 LIMIT 1	1	1	80
32	SELECT `Photo`.`id`, `Photo`.`created`, `Photo`.`lastmodified`, `Photo`.`filename`, `Photo`.`protected`, `Photo`.`type`, `Photo`.`mongoid`, `ItemsPhoto`.`item_id`, `ItemsPhoto`.`photo_id`, `ItemsPhoto`.`position` FROM `photos` AS `Photo` JOIN `items_photos` AS `ItemsPhoto` ON (`ItemsPhoto`.`item_id` = 4281 AND `ItemsPhoto`.`photo_id` = `Photo`.`id`) WHERE 1 = 1 ORDER BY position ASC	3	3	30
33	SELECT `Category`.`id`, `Category`.`name`, `Category`.`parent`, `ItemsCategory`.`item_id`, `ItemsCategory`.`category_id` FROM `categories` AS `Category` JOIN `items_categories` AS `ItemsCategory` ON (`ItemsCategory`.`item_id` = 4281 AND `ItemsCategory`.`category_id` = `Category`.`id`) WHERE 1 = 1 ORDER BY name ASC	2	2	1
34	SELECT `Item`.`id`, `Item`.`approval`, `Item`.`exchange_id`, `Item`.`currency_id`, `Item`.`stop`, `Item`.`created`, `Item`.`lastmodified`, `Item`.`emailed`, `Item`.`sorted`, `Item`.`name`, `Item`.`shortname`, `Item`.`description`, `Item`.`location`, `Item`.`zip`, `Item`.`barter`, `Item`.`inventory`, `Item`.`business_id`, `Item`.`original_business_id`, `Item`.`user_id`, `Item`.`shippable`, `Item`.`shipping_cost`, `Item`.`shipping_description`, `Item`.`condition`, `Item`.`contact`, `User`.`id`, `User`.`username`, `User`.`password`, `User`.`role_id`, `User`.`status`, `User`.`firstname`, `User`.`lastname`, `User`.`email`, `User`.`address1`, `User`.`address2`, `User`.`city`, `User`.`state`, `User`.`zipcode`, `User`.`phone1`, `User`.`phone2`, `User`.`fax1`, `User`.`fax2`, `User`.`lastlogin_remote_info`, `User`.`apikey`, `Business`.`id`, `Business`.`display_id`, `Business`.`created`, `Business`.`modified`, `Business`.`active`, `Business`.`visible`, `Business`.`local_sell`, `Business`.`local_buy`, `Business`.`buy_hold`, `Business`.`sell_hold`, `Business`.`broker_managed`, `Business`.`reciprocal_account`, `Business`.`process_annual_fees`, `Business`.`spend_down`, `Business`.`name`, `Business`.`region_id`, `Business`.`photo_id`, `Business`.`exchange_id`, `Business`.`broker`, `Business`.`salesperson`, `Business`.`owner`, `Business`.`contact`, `Business`.`shortname`, `Business`.`description`, `Business`.`comment`, `Business`.`cash_credit`, `Business`.`credit`, `Business`.`credit_limit`, `Business`.`balance`, `Business`.`cash_due`, `Business`.`past_due`, `Business`.`monthly_cash`, `Business`.`monthly_barter`, `Business`.`annual_cash`, `Business`.`annual_barter`, `Business`.`ein`, `Business`.`ssn`, `Business`.`payment_method`, `Business`.`credit_card_type`, `Business`.`credit_card_number`, `Business`.`credit_card_expiration`, `Business`.`credit_card_security_code`, `Business`.`credit_card_security_code_backup`, `Business`.`echeck_checkname`, `Business`.`echeck_routing_number`, `Business`.`echeck_account_number`, `Business`.`echeck_account_class`, `Business`.`echeck_account_type`, `Business`.`echeck_bank_name`, `Business`.`billing_firstname`, `Business`.`billing_lastname`, `Business`.`billing_address1`, `Business`.`billing_city`, `Business`.`billing_state`, `Business`.`billing_zip`, `Business`.`billing_country`, `Business`.`billing_email`, `Business`.`barter_buyer_fee`, `Business`.`barter_seller_fee`, `Business`.`cash_buyer_fee`, `Business`.`cash_seller_fee`, `Business`.`email`, `Business`.`address1`, `Business`.`address2`, `Business`.`city`, `Business`.`state`, `Business`.`zipcode`, `Business`.`country`, `Business`.`phone1`, `Business`.`phone2`, `Business`.`fax1`, `Business`.`fax2`, `Business`.`url`, `Business`.`referral`, `Business`.`w9_name`, `Business`.`w9_business_name`, `Business`.`w9_business_type`, `Business`.`w9_address1`, `Business`.`w9_address2`, `Business`.`w9_country`, `Business`.`w9_city`, `Business`.`w9_state`, `Business`.`w9_zipcode`, `Business`.`w9_id`, `Business`.`w9_remote_info`, `Business`.`mailing_address1`, `Business`.`mailing_address2`, `Business`.`mailing_country`, `Business`.`mailing_city`, `Business`.`mailing_state`, `Business`.`mailing_zipcode`, `Business`.`phone3` FROM `items` AS `Item` LEFT JOIN `users` AS `User` ON (`Item`.`user_id` = `User`.`id`) LEFT JOIN `businesses` AS `Business` ON (`Item`.`business_id` = `Business`.`id`) WHERE `Item`.`id` = 4281 LIMIT 1	1	1	30
35	SELECT `Photo`.`id`, `Photo`.`created`, `Photo`.`lastmodified`, `Photo`.`filename`, `Photo`.`protected`, `Photo`.`type`, `Photo`.`mongoid`, `ItemsPhoto`.`item_id`, `ItemsPhoto`.`photo_id`, `ItemsPhoto`.`position` FROM `photos` AS `Photo` JOIN `items_photos` AS `ItemsPhoto` ON (`ItemsPhoto`.`item_id` = 4281 AND `ItemsPhoto`.`photo_id` = `Photo`.`id`) WHERE 1 = 1 ORDER BY position ASC	3	3	28
36	SELECT `Category`.`id`, `Category`.`name`, `Category`.`parent`, `ItemsCategory`.`item_id`, `ItemsCategory`.`category_id` FROM `categories` AS `Category` JOIN `items_categories` AS `ItemsCategory` ON (`ItemsCategory`.`item_id` = 4281 AND `ItemsCategory`.`category_id` = `Category`.`id`) WHERE 1 = 1 ORDER BY name ASC	2	2	1
37	SELECT `Business`.`id`, `Business`.`display_id`, `Business`.`created`, `Business`.`modified`, `Business`.`active`, `Business`.`visible`, `Business`.`local_sell`, `Business`.`local_buy`, `Business`.`buy_hold`, `Business`.`sell_hold`, `Business`.`broker_managed`, `Business`.`reciprocal_account`, `Business`.`process_annual_fees`, `Business`.`spend_down`, `Business`.`name`, `Business`.`region_id`, `Business`.`photo_id`, `Business`.`exchange_id`, `Business`.`broker`, `Business`.`salesperson`, `Business`.`owner`, `Business`.`contact`, `Business`.`shortname`, `Business`.`description`, `Business`.`comment`, `Business`.`cash_credit`, `Business`.`credit`, `Business`.`credit_limit`, `Business`.`balance`, `Business`.`cash_due`, `Business`.`past_due`, `Business`.`monthly_cash`, `Business`.`monthly_barter`, `Business`.`annual_cash`, `Business`.`annual_barter`, `Business`.`ein`, `Business`.`ssn`, `Business`.`payment_method`, `Business`.`credit_card_type`, `Business`.`credit_card_number`, `Business`.`credit_card_expiration`, `Business`.`credit_card_security_code`, `Business`.`credit_card_security_code_backup`, `Business`.`echeck_checkname`, `Business`.`echeck_routing_number`, `Business`.`echeck_account_number`, `Business`.`echeck_account_class`, `Business`.`echeck_account_type`, `Business`.`echeck_bank_name`, `Business`.`billing_firstname`, `Business`.`billing_lastname`, `Business`.`billing_address1`, `Business`.`billing_city`, `Business`.`billing_state`, `Business`.`billing_zip`, `Business`.`billing_country`, `Business`.`billing_email`, `Business`.`barter_buyer_fee`, `Business`.`barter_seller_fee`, `Business`.`cash_buyer_fee`, `Business`.`cash_seller_fee`, `Business`.`email`, `Business`.`address1`, `Business`.`address2`, `Business`.`city`, `Business`.`state`, `Business`.`zipcode`, `Business`.`country`, `Business`.`phone1`, `Business`.`phone2`, `Business`.`fax1`, `Business`.`fax2`, `Business`.`url`, `Business`.`referral`, `Business`.`w9_name`, `Business`.`w9_business_name`, `Business`.`w9_business_type`, `Business`.`w9_address1`, `Business`.`w9_address2`, `Business`.`w9_country`, `Business`.`w9_city`, `Business`.`w9_state`, `Business`.`w9_zipcode`, `Business`.`w9_id`, `Business`.`w9_remote_info`, `Business`.`mailing_address1`, `Business`.`mailing_address2`, `Business`.`mailing_country`, `Business`.`mailing_city`, `Business`.`mailing_state`, `Business`.`mailing_zipcode`, `Business`.`phone3`, `Exchange`.`id`, `Exchange`.`name`, `Exchange`.`shortname`, `Exchange`.`status`, `Exchange`.`httpd`, `Exchange`.`emails`, `Exchange`.`messenger`, `Exchange`.`daily_emails`, `Exchange`.`monthly_fees`, `Exchange`.`annual_fees`, `Exchange`.`monthly_statements`, `Exchange`.`monthly_backups`, `Exchange`.`past_due`, `Exchange`.`late_fees`, `Exchange`.`description`, `Exchange`.`created`, `Exchange`.`network`, `Exchange`.`domain`, `Exchange`.`domain_aliases`, `Exchange`.`messenger_reply`, `Exchange`.`page_title_suffix`, `Exchange`.`page_description`, `Exchange`.`credit`, `Exchange`.`credit_limit`, `Exchange`.`balance`, `Exchange`.`barter21_cash_fee`, `Exchange`.`barter21_barter_fee`, `Exchange`.`barter21_monthly_fee_max`, `Exchange`.`barter21_monthly_fee_min`, `Exchange`.`barter21_monthly_barter_fee_max`, `Exchange`.`barter21_monthly_barter_fee_min`, `Exchange`.`barter21_buyer_fee`, `Exchange`.`barter21_seller_fee`, `Exchange`.`default_currency`, `Exchange`.`default_business_seller_cash_fee`, `Exchange`.`default_business_seller_barter_fee`, `Exchange`.`default_business_buyer_cash_fee`, `Exchange`.`default_business_buyer_barter_fee`, `Exchange`.`default_business_credit_limit`, `Exchange`.`collections_minimum`, `Exchange`.`barter_fee_tax`, `Exchange`.`cash_fee_tax`, `Exchange`.`signup_cash_fee`, `Exchange`.`signup_barter_fee`, `Exchange`.`monthly_admin_cash_fee`, `Exchange`.`monthly_admin_barter_fee`, `Exchange`.`annual_renewal_cash_fee`, `Exchange`.`annual_renewal_barter_fee`, `Exchange`.`statement_grace_period`, `Exchange`.`late_fee`, `Exchange`.`late_fee_grace_period`, `Exchange`.`late_fee_minimum`, `Exchange`.`owner`, `Exchange`.`reconcile`, `Exchange`.`timezone`, `Exchange`.`language`, `Exchange`.`locale`, `Exchange`.`google_analytics_account`, `Exchange`.`skin`, `Exchange`.`theme`, `Exchange`.`theme_params`, `Exchange`.`tax_rate`, `Exchange`.`annual_fee_setting`, `Exchange`.`monlthy_fee_setting`, `Exchange`.`mailchimp_api_key`, `Exchange`.`mailchimp_list_id`, `Exchange`.`default_trading_floor_view`, `Exchange`.`default_daily_email_view`, `Exchange`.`default_role_id`, `Exchange`.`required_ein`, `Exchange`.`required_payment`, `Exchange`.`accepts_eft`, `Exchange`.`accepts_cc`, `Exchange`.`allowable_credit_card_types`, `Region`.`id`, `Region`.`name`, `Region`.`shortname`, `Region`.`description`, `Region`.`exchange_id`, `Region`.`timezone`, `Region`.`language`, `Region`.`locale`, `Region`.`currency_id`, `Region`.`processor_currency`, `Region`.`domain`, `Region`.`theme`, `Region`.`skin`, `Region`.`theme_params`, `Region`.`cash_fee_tax`, `Region`.`barter_fee_tax`, `Region`.`collections_minimum`, `Region`.`signup_cash_fee`, `Region`.`signup_barter_fee`, `Region`.`monthly_admin_cash_fee`, `Region`.`monthly_admin_barter_fee`, `Region`.`annual_renewal_cash_fee`, `Region`.`annual_renewal_barter_fee`, `Region`.`statement_grace_period`, `Region`.`late_fee`, `Region`.`late_fee_minimum`, `Region`.`late_fee_grace_period`, `Region`.`default_business_seller_cash_fee`, `Region`.`default_business_seller_barter_fee`, `Region`.`default_business_buyer_cash_fee`, `Region`.`default_business_buyer_barter_fee`, `Region`.`default_business_credit_limit`, `Region`.`operations_account`, `Region`.`store_approval`, `Region`.`store_autobuy`, `Owner`.`id`, `Owner`.`username`, `Owner`.`password`, `Owner`.`role_id`, `Owner`.`status`, `Owner`.`firstname`, `Owner`.`lastname`, `Owner`.`email`, `Owner`.`address1`, `Owner`.`address2`, `Owner`.`city`, `Owner`.`state`, `Owner`.`zipcode`, `Owner`.`phone1`, `Owner`.`phone2`, `Owner`.`fax1`, `Owner`.`fax2`, `Owner`.`lastlogin_remote_info`, `Owner`.`apikey`, `Contact`.`id`, `Contact`.`username`, `Contact`.`password`, `Contact`.`role_id`, `Contact`.`status`, `Contact`.`firstname`, `Contact`.`lastname`, `Contact`.`email`, `Contact`.`address1`, `Contact`.`address2`, `Contact`.`city`, `Contact`.`state`, `Contact`.`zipcode`, `Contact`.`phone1`, `Contact`.`phone2`, `Contact`.`fax1`, `Contact`.`fax2`, `Contact`.`lastlogin_remote_info`, `Contact`.`apikey`, `Salesperson`.`id`, `Salesperson`.`username`, `Salesperson`.`password`, `Salesperson`.`role_id`, `Salesperson`.`status`, `Salesperson`.`firstname`, `Salesperson`.`lastname`, `Salesperson`.`email`, `Salesperson`.`address1`, `Salesperson`.`address2`, `Salesperson`.`city`, `Salesperson`.`state`, `Salesperson`.`zipcode`, `Salesperson`.`phone1`, `Salesperson`.`phone2`, `Salesperson`.`fax1`, `Salesperson`.`fax2`, `Salesperson`.`lastlogin_remote_info`, `Salesperson`.`apikey`, `Broker`.`id`, `Broker`.`username`, `Broker`.`password`, `Broker`.`role_id`, `Broker`.`status`, `Broker`.`firstname`, `Broker`.`lastname`, `Broker`.`email`, `Broker`.`address1`, `Broker`.`address2`, `Broker`.`city`, `Broker`.`state`, `Broker`.`zipcode`, `Broker`.`phone1`, `Broker`.`phone2`, `Broker`.`fax1`, `Broker`.`fax2`, `Broker`.`lastlogin_remote_info`, `Broker`.`apikey` FROM `businesses` AS `Business` LEFT JOIN `exchanges` AS `Exchange` ON (`Business`.`exchange_id` = `Exchange`.`id`) LEFT JOIN `regions` AS `Region` ON (`Business`.`region_id` = `Region`.`id`) LEFT JOIN `users` AS `Owner` ON (`Business`.`owner` = `Owner`.`id`) LEFT JOIN `users` AS `Contact` ON (`Business`.`contact` = `Contact`.`id`) LEFT JOIN `users` AS `Salesperson` ON (`Business`.`salesperson` = `Salesperson`.`id`) LEFT JOIN `users` AS `Broker` ON (`Business`.`broker` = `Broker`.`id`) WHERE `Business`.`id` = 4097 LIMIT 1	1	1	23
38	SELECT `Note`.`id`, `Note`.`user_id`, `Note`.`business_id`, `Note`.`update_id`, `Note`.`created`, `Note`.`modified`, `Note`.`body`, `Note`.`status` FROM `notes` AS `Note` WHERE `Note`.`business_id` = (4097) ORDER BY created DESC	0	0	4
39	SELECT `User`.`id`, `User`.`username`, `User`.`password`, `User`.`role_id`, `User`.`status`, `User`.`firstname`, `User`.`lastname`, `User`.`email`, `User`.`address1`, `User`.`address2`, `User`.`city`, `User`.`state`, `User`.`zipcode`, `User`.`phone1`, `User`.`phone2`, `User`.`fax1`, `User`.`fax2`, `User`.`lastlogin_remote_info`, `User`.`apikey`, `BusinessesUser`.`business_id`, `BusinessesUser`.`user_id` FROM `users` AS `User` JOIN `businesses_users` AS `BusinessesUser` ON (`BusinessesUser`.`business_id` = 4097 AND `BusinessesUser`.`user_id` = `User`.`id`) WHERE 1 = 1 ORDER BY username ASC	1	1	3
40	SELECT `Category`.`id`, `Category`.`name`, `Category`.`parent`, `BusinessesCategory`.`business_id`, `BusinessesCategory`.`category_id` FROM `categories` AS `Category` JOIN `businesses_categories` AS `BusinessesCategory` ON (`BusinessesCategory`.`business_id` = 4097 AND `BusinessesCategory`.`category_id` = `Category`.`id`) WHERE 1 = 1 ORDER BY name ASC	6	6	14
41	SELECT `Currency`.`id`, `Currency`.`modified`, `Currency`.`value`, `Currency`.`name` FROM `currencies` AS `Currency` WHERE `Currency`.`id` = 'USD' LIMIT 1	1	1	1
42	SELECT `Currency`.`id`, `Currency`.`modified`, `Currency`.`value`, `Currency`.`name` FROM `currencies` AS `Currency` WHERE `Currency`.`id` = 'USD' LIMIT 1	1	1	0
43	SELECT `Currency`.`id`, `Currency`.`modified`, `Currency`.`value`, `Currency`.`name` FROM `currencies` AS `Currency` WHERE `Currency`.`id` = 'USD' LIMIT 1	1	1	0
44	SELECT `Currency`.`id`, `Currency`.`modified`, `Currency`.`value`, `Currency`.`name` FROM `currencies` AS `Currency` WHERE `Currency`.`id` = 'USD' LIMIT 1	1	1	0
45	SELECT COUNT(*) AS `count` FROM `items` AS `Item` LEFT JOIN `users` AS `User` ON (`Item`.`user_id` = `User`.`id`) LEFT JOIN `businesses` AS `Business` ON (`Item`.`business_id` = `Business`.`id`) INNER JOIN `exchanges` AS `Exchange` ON (`Business`.`exchange_id` = `Exchange`.`id`) WHERE `business_id` = 4097 AND `inventory` > 0 AND `stop` >= '2012-02-22 23:09:06' AND `Item`.`exchange_id` IN (0, 41) AND `Business`.`exchange_id` = 41 AND `Exchange`.`status` <> 'Stand Alone'	1	1	42
46	SELECT `Item`.`id`, `Item`.`approval`, `Item`.`exchange_id`, `Item`.`currency_id`, `Item`.`stop`, `Item`.`created`, `Item`.`lastmodified`, `Item`.`emailed`, `Item`.`sorted`, `Item`.`name`, `Item`.`shortname`, `Item`.`description`, `Item`.`location`, `Item`.`zip`, `Item`.`barter`, `Item`.`inventory`, `Item`.`business_id`, `Item`.`original_business_id`, `Item`.`user_id`, `Item`.`shippable`, `Item`.`shipping_cost`, `Item`.`shipping_description`, `Item`.`condition`, `Item`.`contact`, `User`.`id`, `User`.`username`, `User`.`password`, `User`.`role_id`, `User`.`status`, `User`.`firstname`, `User`.`lastname`, `User`.`email`, `User`.`address1`, `User`.`address2`, `User`.`city`, `User`.`state`, `User`.`zipcode`, `User`.`phone1`, `User`.`phone2`, `User`.`fax1`, `User`.`fax2`, `User`.`lastlogin_remote_info`, `User`.`apikey`, `Business`.`id`, `Business`.`display_id`, `Business`.`created`, `Business`.`modified`, `Business`.`active`, `Business`.`visible`, `Business`.`local_sell`, `Business`.`local_buy`, `Business`.`buy_hold`, `Business`.`sell_hold`, `Business`.`broker_managed`, `Business`.`reciprocal_account`, `Business`.`process_annual_fees`, `Business`.`spend_down`, `Business`.`name`, `Business`.`region_id`, `Business`.`photo_id`, `Business`.`exchange_id`, `Business`.`broker`, `Business`.`salesperson`, `Business`.`owner`, `Business`.`contact`, `Business`.`shortname`, `Business`.`description`, `Business`.`comment`, `Business`.`cash_credit`, `Business`.`credit`, `Business`.`credit_limit`, `Business`.`balance`, `Business`.`cash_due`, `Business`.`past_due`, `Business`.`monthly_cash`, `Business`.`monthly_barter`, `Business`.`annual_cash`, `Business`.`annual_barter`, `Business`.`ein`, `Business`.`ssn`, `Business`.`payment_method`, `Business`.`credit_card_type`, `Business`.`credit_card_number`, `Business`.`credit_card_expiration`, `Business`.`credit_card_security_code`, `Business`.`credit_card_security_code_backup`, `Business`.`echeck_checkname`, `Business`.`echeck_routing_number`, `Business`.`echeck_account_number`, `Business`.`echeck_account_class`, `Business`.`echeck_account_type`, `Business`.`echeck_bank_name`, `Business`.`billing_firstname`, `Business`.`billing_lastname`, `Business`.`billing_address1`, `Business`.`billing_city`, `Business`.`billing_state`, `Business`.`billing_zip`, `Business`.`billing_country`, `Business`.`billing_email`, `Business`.`barter_buyer_fee`, `Business`.`barter_seller_fee`, `Business`.`cash_buyer_fee`, `Business`.`cash_seller_fee`, `Business`.`email`, `Business`.`address1`, `Business`.`address2`, `Business`.`city`, `Business`.`state`, `Business`.`zipcode`, `Business`.`country`, `Business`.`phone1`, `Business`.`phone2`, `Business`.`fax1`, `Business`.`fax2`, `Business`.`url`, `Business`.`referral`, `Business`.`w9_name`, `Business`.`w9_business_name`, `Business`.`w9_business_type`, `Business`.`w9_address1`, `Business`.`w9_address2`, `Business`.`w9_country`, `Business`.`w9_city`, `Business`.`w9_state`, `Business`.`w9_zipcode`, `Business`.`w9_id`, `Business`.`w9_remote_info`, `Business`.`mailing_address1`, `Business`.`mailing_address2`, `Business`.`mailing_country`, `Business`.`mailing_city`, `Business`.`mailing_state`, `Business`.`mailing_zipcode`, `Business`.`phone3`, `Exchange`.`id`, `Exchange`.`name`, `Exchange`.`shortname`, `Exchange`.`status`, `Exchange`.`httpd`, `Exchange`.`emails`, `Exchange`.`messenger`, `Exchange`.`daily_emails`, `Exchange`.`monthly_fees`, `Exchange`.`annual_fees`, `Exchange`.`monthly_statements`, `Exchange`.`monthly_backups`, `Exchange`.`past_due`, `Exchange`.`late_fees`, `Exchange`.`description`, `Exchange`.`created`, `Exchange`.`network`, `Exchange`.`domain`, `Exchange`.`domain_aliases`, `Exchange`.`messenger_reply`, `Exchange`.`page_title_suffix`, `Exchange`.`page_description`, `Exchange`.`credit`, `Exchange`.`credit_limit`, `Exchange`.`balance`, `Exchange`.`barter21_cash_fee`, `Exchange`.`barter21_barter_fee`, `Exchange`.`barter21_monthly_fee_max`, `Exchange`.`barter21_monthly_fee_min`, `Exchange`.`barter21_monthly_barter_fee_max`, `Exchange`.`barter21_monthly_barter_fee_min`, `Exchange`.`barter21_buyer_fee`, `Exchange`.`barter21_seller_fee`, `Exchange`.`default_currency`, `Exchange`.`default_business_seller_cash_fee`, `Exchange`.`default_business_seller_barter_fee`, `Exchange`.`default_business_buyer_cash_fee`, `Exchange`.`default_business_buyer_barter_fee`, `Exchange`.`default_business_credit_limit`, `Exchange`.`collections_minimum`, `Exchange`.`barter_fee_tax`, `Exchange`.`cash_fee_tax`, `Exchange`.`signup_cash_fee`, `Exchange`.`signup_barter_fee`, `Exchange`.`monthly_admin_cash_fee`, `Exchange`.`monthly_admin_barter_fee`, `Exchange`.`annual_renewal_cash_fee`, `Exchange`.`annual_renewal_barter_fee`, `Exchange`.`statement_grace_period`, `Exchange`.`late_fee`, `Exchange`.`late_fee_grace_period`, `Exchange`.`late_fee_minimum`, `Exchange`.`owner`, `Exchange`.`reconcile`, `Exchange`.`timezone`, `Exchange`.`language`, `Exchange`.`locale`, `Exchange`.`google_analytics_account`, `Exchange`.`skin`, `Exchange`.`theme`, `Exchange`.`theme_params`, `Exchange`.`tax_rate`, `Exchange`.`annual_fee_setting`, `Exchange`.`monlthy_fee_setting`, `Exchange`.`mailchimp_api_key`, `Exchange`.`mailchimp_list_id`, `Exchange`.`default_trading_floor_view`, `Exchange`.`default_daily_email_view`, `Exchange`.`default_role_id`, `Exchange`.`required_ein`, `Exchange`.`required_payment`, `Exchange`.`accepts_eft`, `Exchange`.`accepts_cc`, `Exchange`.`allowable_credit_card_types` FROM `items` AS `Item` LEFT JOIN `users` AS `User` ON (`Item`.`user_id` = `User`.`id`) LEFT JOIN `businesses` AS `Business` ON (`Item`.`business_id` = `Business`.`id`) INNER JOIN `exchanges` AS `Exchange` ON (`Business`.`exchange_id` = `Exchange`.`id`) WHERE `business_id` = 4097 AND `inventory` > 0 AND `stop` >= '2012-02-22 23:09:06' AND `Item`.`exchange_id` IN (0, 41) AND `Business`.`exchange_id` = 41 AND `Exchange`.`status` <> 'Stand Alone' ORDER BY RAND() ASC LIMIT 3	1	1	68
47	SELECT `Photo`.`id`, `Photo`.`created`, `Photo`.`lastmodified`, `Photo`.`filename`, `Photo`.`protected`, `Photo`.`type`, `Photo`.`mongoid`, `ItemsPhoto`.`item_id`, `ItemsPhoto`.`photo_id`, `ItemsPhoto`.`position` FROM `photos` AS `Photo` JOIN `items_photos` AS `ItemsPhoto` ON (`ItemsPhoto`.`item_id` = 9687 AND `ItemsPhoto`.`photo_id` = `Photo`.`id`) WHERE 1 = 1 ORDER BY position ASC	2	2	4
48	SELECT `Category`.`id`, `Category`.`name`, `Category`.`parent`, `ItemsCategory`.`item_id`, `ItemsCategory`.`category_id` FROM `categories` AS `Category` JOIN `items_categories` AS `ItemsCategory` ON (`ItemsCategory`.`item_id` = 9687 AND `ItemsCategory`.`category_id` = `Category`.`id`) WHERE 1 = 1 ORDER BY name ASC	1	1	11
49	SELECT `Currency`.`id`, `Currency`.`modified`, `Currency`.`value`, `Currency`.`name` FROM `currencies` AS `Currency` WHERE `Currency`.`id` = 'USD' LIMIT 1	1	1	18
50	SELECT `Currency`.`id`, `Currency`.`modified`, `Currency`.`value`, `Currency`.`name` FROM `currencies` AS `Currency` WHERE `Currency`.`id` = 'USD' LIMIT 1	1	1	17
51	SELECT COUNT(*) AS `count` FROM `items` AS `Item` LEFT JOIN `users` AS `User` ON (`Item`.`user_id` = `User`.`id`) LEFT JOIN `businesses` AS `Business` ON (`Item`.`business_id` = `Business`.`id`) INNER JOIN `exchanges` AS `Exchange` ON (`Business`.`exchange_id` = `Exchange`.`id`) LEFT JOIN `items_categories` AS `ItemsCategories` ON (`ItemsCategories`.`item_id` = `Item`.`id`) INNER JOIN `categories` AS `FilterCategory` ON (`FilterCategory`.`id` = `ItemsCategories`.`category_id`) WHERE `inventory` > 0 AND `stop` >= '2012-02-22 23:09:06' AND `Item`.`exchange_id` IN (0, 41) AND `Business`.`exchange_id` = 41 AND `Exchange`.`status` <> 'Stand Alone' AND `business_id` != 4097 AND `FilterCategory`.`id` IN (396, 398)	1	1	75
52	SELECT `Item`.`id`, `Item`.`approval`, `Item`.`exchange_id`, `Item`.`currency_id`, `Item`.`stop`, `Item`.`created`, `Item`.`lastmodified`, `Item`.`emailed`, `Item`.`sorted`, `Item`.`name`, `Item`.`shortname`, `Item`.`description`, `Item`.`location`, `Item`.`zip`, `Item`.`barter`, `Item`.`inventory`, `Item`.`business_id`, `Item`.`original_business_id`, `Item`.`user_id`, `Item`.`shippable`, `Item`.`shipping_cost`, `Item`.`shipping_description`, `Item`.`condition`, `Item`.`contact`, `User`.`id`, `User`.`username`, `User`.`password`, `User`.`role_id`, `User`.`status`, `User`.`firstname`, `User`.`lastname`, `User`.`email`, `User`.`address1`, `User`.`address2`, `User`.`city`, `User`.`state`, `User`.`zipcode`, `User`.`phone1`, `User`.`phone2`, `User`.`fax1`, `User`.`fax2`, `User`.`lastlogin_remote_info`, `User`.`apikey`, `Business`.`id`, `Business`.`display_id`, `Business`.`created`, `Business`.`modified`, `Business`.`active`, `Business`.`visible`, `Business`.`local_sell`, `Business`.`local_buy`, `Business`.`buy_hold`, `Business`.`sell_hold`, `Business`.`broker_managed`, `Business`.`reciprocal_account`, `Business`.`process_annual_fees`, `Business`.`spend_down`, `Business`.`name`, `Business`.`region_id`, `Business`.`photo_id`, `Business`.`exchange_id`, `Business`.`broker`, `Business`.`salesperson`, `Business`.`owner`, `Business`.`contact`, `Business`.`shortname`, `Business`.`description`, `Business`.`comment`, `Business`.`cash_credit`, `Business`.`credit`, `Business`.`credit_limit`, `Business`.`balance`, `Business`.`cash_due`, `Business`.`past_due`, `Business`.`monthly_cash`, `Business`.`monthly_barter`, `Business`.`annual_cash`, `Business`.`annual_barter`, `Business`.`ein`, `Business`.`ssn`, `Business`.`payment_method`, `Business`.`credit_card_type`, `Business`.`credit_card_number`, `Business`.`credit_card_expiration`, `Business`.`credit_card_security_code`, `Business`.`credit_card_security_code_backup`, `Business`.`echeck_checkname`, `Business`.`echeck_routing_number`, `Business`.`echeck_account_number`, `Business`.`echeck_account_class`, `Business`.`echeck_account_type`, `Business`.`echeck_bank_name`, `Business`.`billing_firstname`, `Business`.`billing_lastname`, `Business`.`billing_address1`, `Business`.`billing_city`, `Business`.`billing_state`, `Business`.`billing_zip`, `Business`.`billing_country`, `Business`.`billing_email`, `Business`.`barter_buyer_fee`, `Business`.`barter_seller_fee`, `Business`.`cash_buyer_fee`, `Business`.`cash_seller_fee`, `Business`.`email`, `Business`.`address1`, `Business`.`address2`, `Business`.`city`, `Business`.`state`, `Business`.`zipcode`, `Business`.`country`, `Business`.`phone1`, `Business`.`phone2`, `Business`.`fax1`, `Business`.`fax2`, `Business`.`url`, `Business`.`referral`, `Business`.`w9_name`, `Business`.`w9_business_name`, `Business`.`w9_business_type`, `Business`.`w9_address1`, `Business`.`w9_address2`, `Business`.`w9_country`, `Business`.`w9_city`, `Business`.`w9_state`, `Business`.`w9_zipcode`, `Business`.`w9_id`, `Business`.`w9_remote_info`, `Business`.`mailing_address1`, `Business`.`mailing_address2`, `Business`.`mailing_country`, `Business`.`mailing_city`, `Business`.`mailing_state`, `Business`.`mailing_zipcode`, `Business`.`phone3`, `Exchange`.`id`, `Exchange`.`name`, `Exchange`.`shortname`, `Exchange`.`status`, `Exchange`.`httpd`, `Exchange`.`emails`, `Exchange`.`messenger`, `Exchange`.`daily_emails`, `Exchange`.`monthly_fees`, `Exchange`.`annual_fees`, `Exchange`.`monthly_statements`, `Exchange`.`monthly_backups`, `Exchange`.`past_due`, `Exchange`.`late_fees`, `Exchange`.`description`, `Exchange`.`created`, `Exchange`.`network`, `Exchange`.`domain`, `Exchange`.`domain_aliases`, `Exchange`.`messenger_reply`, `Exchange`.`page_title_suffix`, `Exchange`.`page_description`, `Exchange`.`credit`, `Exchange`.`credit_limit`, `Exchange`.`balance`, `Exchange`.`barter21_cash_fee`, `Exchange`.`barter21_barter_fee`, `Exchange`.`barter21_monthly_fee_max`, `Exchange`.`barter21_monthly_fee_min`, `Exchange`.`barter21_monthly_barter_fee_max`, `Exchange`.`barter21_monthly_barter_fee_min`, `Exchange`.`barter21_buyer_fee`, `Exchange`.`barter21_seller_fee`, `Exchange`.`default_currency`, `Exchange`.`default_business_seller_cash_fee`, `Exchange`.`default_business_seller_barter_fee`, `Exchange`.`default_business_buyer_cash_fee`, `Exchange`.`default_business_buyer_barter_fee`, `Exchange`.`default_business_credit_limit`, `Exchange`.`collections_minimum`, `Exchange`.`barter_fee_tax`, `Exchange`.`cash_fee_tax`, `Exchange`.`signup_cash_fee`, `Exchange`.`signup_barter_fee`, `Exchange`.`monthly_admin_cash_fee`, `Exchange`.`monthly_admin_barter_fee`, `Exchange`.`annual_renewal_cash_fee`, `Exchange`.`annual_renewal_barter_fee`, `Exchange`.`statement_grace_period`, `Exchange`.`late_fee`, `Exchange`.`late_fee_grace_period`, `Exchange`.`late_fee_minimum`, `Exchange`.`owner`, `Exchange`.`reconcile`, `Exchange`.`timezone`, `Exchange`.`language`, `Exchange`.`locale`, `Exchange`.`google_analytics_account`, `Exchange`.`skin`, `Exchange`.`theme`, `Exchange`.`theme_params`, `Exchange`.`tax_rate`, `Exchange`.`annual_fee_setting`, `Exchange`.`monlthy_fee_setting`, `Exchange`.`mailchimp_api_key`, `Exchange`.`mailchimp_list_id`, `Exchange`.`default_trading_floor_view`, `Exchange`.`default_daily_email_view`, `Exchange`.`default_role_id`, `Exchange`.`required_ein`, `Exchange`.`required_payment`, `Exchange`.`accepts_eft`, `Exchange`.`accepts_cc`, `Exchange`.`allowable_credit_card_types`, `ItemsCategories`.`item_id`, `ItemsCategories`.`category_id`, `FilterCategory`.`id`, `FilterCategory`.`name`, `FilterCategory`.`parent` FROM `items` AS `Item` LEFT JOIN `users` AS `User` ON (`Item`.`user_id` = `User`.`id`) LEFT JOIN `businesses` AS `Business` ON (`Item`.`business_id` = `Business`.`id`) INNER JOIN `exchanges` AS `Exchange` ON (`Business`.`exchange_id` = `Exchange`.`id`) LEFT JOIN `items_categories` AS `ItemsCategories` ON (`ItemsCategories`.`item_id` = `Item`.`id`) INNER JOIN `categories` AS `FilterCategory` ON (`FilterCategory`.`id` = `ItemsCategories`.`category_id`) WHERE `inventory` > 0 AND `stop` >= '2012-02-22 23:09:06' AND `Item`.`exchange_id` IN (0, 41) AND `Business`.`exchange_id` = 41 AND `Exchange`.`status` <> 'Stand Alone' AND `business_id` != 4097 AND `FilterCategory`.`id` IN (396, 398) ORDER BY RAND() ASC LIMIT 3	0	0	140
53	DESCRIBE `logins`	8	8	72
54	DESCRIBE `commissions`	6	6	1
55	DESCRIBE `roles`	5	5	1
56	SELECT `Banlist`.`id`, `Banlist`.`created` FROM `banlist` AS `Banlist` WHERE `Banlist`.`id` = '38.107.179.242' LIMIT 1	0	0	35
57	SELECT `Exchange`.`id`, `Exchange`.`name`, `Exchange`.`shortname`, `Exchange`.`status`, `Exchange`.`httpd`, `Exchange`.`emails`, `Exchange`.`messenger`, `Exchange`.`daily_emails`, `Exchange`.`monthly_fees`, `Exchange`.`annual_fees`, `Exchange`.`monthly_statements`, `Exchange`.`monthly_backups`, `Exchange`.`past_due`, `Exchange`.`late_fees`, `Exchange`.`description`, `Exchange`.`created`, `Exchange`.`network`, `Exchange`.`domain`, `Exchange`.`domain_aliases`, `Exchange`.`messenger_reply`, `Exchange`.`page_title_suffix`, `Exchange`.`page_description`, `Exchange`.`credit`, `Exchange`.`credit_limit`, `Exchange`.`balance`, `Exchange`.`barter21_cash_fee`, `Exchange`.`barter21_barter_fee`, `Exchange`.`barter21_monthly_fee_max`, `Exchange`.`barter21_monthly_fee_min`, `Exchange`.`barter21_monthly_barter_fee_max`, `Exchange`.`barter21_monthly_barter_fee_min`, `Exchange`.`barter21_buyer_fee`, `Exchange`.`barter21_seller_fee`, `Exchange`.`default_currency`, `Exchange`.`default_business_seller_cash_fee`, `Exchange`.`default_business_seller_barter_fee`, `Exchange`.`default_business_buyer_cash_fee`, `Exchange`.`default_business_buyer_barter_fee`, `Exchange`.`default_business_credit_limit`, `Exchange`.`collections_minimum`, `Exchange`.`barter_fee_tax`, `Exchange`.`cash_fee_tax`, `Exchange`.`signup_cash_fee`, `Exchange`.`signup_barter_fee`, `Exchange`.`monthly_admin_cash_fee`, `Exchange`.`monthly_admin_barter_fee`, `Exchange`.`annual_renewal_cash_fee`, `Exchange`.`annual_renewal_barter_fee`, `Exchange`.`statement_grace_period`, `Exchange`.`late_fee`, `Exchange`.`late_fee_grace_period`, `Exchange`.`late_fee_minimum`, `Exchange`.`owner`, `Exchange`.`reconcile`, `Exchange`.`timezone`, `Exchange`.`language`, `Exchange`.`locale`, `Exchange`.`google_analytics_account`, `Exchange`.`skin`, `Exchange`.`theme`, `Exchange`.`theme_params`, `Exchange`.`tax_rate`, `Exchange`.`annual_fee_setting`, `Exchange`.`monlthy_fee_setting`, `Exchange`.`mailchimp_api_key`, `Exchange`.`mailchimp_list_id`, `Exchange`.`default_trading_floor_view`, `Exchange`.`default_daily_email_view`, `Exchange`.`default_role_id`, `Exchange`.`required_ein`, `Exchange`.`required_payment`, `Exchange`.`accepts_eft`, `Exchange`.`accepts_cc`, `Exchange`.`allowable_credit_card_types`, `Owner`.`id`, `Owner`.`name`, `Owner`.`owner` FROM `exchanges` AS `Exchange` LEFT JOIN `businesses` AS `Owner` ON (`Exchange`.`owner` = `Owner`.`id`) WHERE `Exchange`.`shortname` = 'gts' LIMIT 1	1	1	34
58	SELECT `Region`.`id`, `Region`.`name`, `Region`.`shortname`, `Region`.`description`, `Region`.`exchange_id`, `Region`.`timezone`, `Region`.`language`, `Region`.`locale`, `Region`.`currency_id`, `Region`.`processor_currency`, `Region`.`domain`, `Region`.`theme`, `Region`.`skin`, `Region`.`theme_params`, `Region`.`cash_fee_tax`, `Region`.`barter_fee_tax`, `Region`.`collections_minimum`, `Region`.`signup_cash_fee`, `Region`.`signup_barter_fee`, `Region`.`monthly_admin_cash_fee`, `Region`.`monthly_admin_barter_fee`, `Region`.`annual_renewal_cash_fee`, `Region`.`annual_renewal_barter_fee`, `Region`.`statement_grace_period`, `Region`.`late_fee`, `Region`.`late_fee_minimum`, `Region`.`late_fee_grace_period`, `Region`.`default_business_seller_cash_fee`, `Region`.`default_business_seller_barter_fee`, `Region`.`default_business_buyer_cash_fee`, `Region`.`default_business_buyer_barter_fee`, `Region`.`default_business_credit_limit`, `Region`.`operations_account`, `Region`.`store_approval`, `Region`.`store_autobuy` FROM `regions` AS `Region` WHERE `Region`.`exchange_id` = (41) ORDER BY `name` ASC	1	1	27
59	SELECT `Business`.`id`, `Business`.`display_id`, `Business`.`created`, `Business`.`modified`, `Business`.`active`, `Business`.`visible`, `Business`.`local_sell`, `Business`.`local_buy`, `Business`.`buy_hold`, `Business`.`sell_hold`, `Business`.`broker_managed`, `Business`.`reciprocal_account`, `Business`.`process_annual_fees`, `Business`.`spend_down`, `Business`.`name`, `Business`.`region_id`, `Business`.`photo_id`, `Business`.`exchange_id`, `Business`.`broker`, `Business`.`salesperson`, `Business`.`owner`, `Business`.`contact`, `Business`.`shortname`, `Business`.`description`, `Business`.`comment`, `Business`.`cash_credit`, `Business`.`credit`, `Business`.`credit_limit`, `Business`.`balance`, `Business`.`cash_due`, `Business`.`past_due`, `Business`.`monthly_cash`, `Business`.`monthly_barter`, `Business`.`annual_cash`, `Business`.`annual_barter`, `Business`.`ein`, `Business`.`ssn`, `Business`.`payment_method`, `Business`.`credit_card_type`, `Business`.`credit_card_number`, `Business`.`credit_card_expiration`, `Business`.`credit_card_security_code`, `Business`.`credit_card_security_code_backup`, `Business`.`echeck_checkname`, `Business`.`echeck_routing_number`, `Business`.`echeck_account_number`, `Business`.`echeck_account_class`, `Business`.`echeck_account_type`, `Business`.`echeck_bank_name`, `Business`.`billing_firstname`, `Business`.`billing_lastname`, `Business`.`billing_address1`, `Business`.`billing_city`, `Business`.`billing_state`, `Business`.`billing_zip`, `Business`.`billing_country`, `Business`.`billing_email`, `Business`.`barter_buyer_fee`, `Business`.`barter_seller_fee`, `Business`.`cash_buyer_fee`, `Business`.`cash_seller_fee`, `Business`.`email`, `Business`.`address1`, `Business`.`address2`, `Business`.`city`, `Business`.`state`, `Business`.`zipcode`, `Business`.`country`, `Business`.`phone1`, `Business`.`phone2`, `Business`.`fax1`, `Business`.`fax2`, `Business`.`url`, `Business`.`referral`, `Business`.`w9_name`, `Business`.`w9_business_name`, `Business`.`w9_business_type`, `Business`.`w9_address1`, `Business`.`w9_address2`, `Business`.`w9_country`, `Business`.`w9_city`, `Business`.`w9_state`, `Business`.`w9_zipcode`, `Business`.`w9_id`, `Business`.`w9_remote_info`, `Business`.`mailing_address1`, `Business`.`mailing_address2`, `Business`.`mailing_country`, `Business`.`mailing_city`, `Business`.`mailing_state`, `Business`.`mailing_zipcode`, `Business`.`phone3`, `Exchange`.`id`, `Exchange`.`name`, `Exchange`.`shortname`, `Exchange`.`status`, `Exchange`.`httpd`, `Exchange`.`emails`, `Exchange`.`messenger`, `Exchange`.`daily_emails`, `Exchange`.`monthly_fees`, `Exchange`.`annual_fees`, `Exchange`.`monthly_statements`, `Exchange`.`monthly_backups`, `Exchange`.`past_due`, `Exchange`.`late_fees`, `Exchange`.`description`, `Exchange`.`created`, `Exchange`.`network`, `Exchange`.`domain`, `Exchange`.`domain_aliases`, `Exchange`.`messenger_reply`, `Exchange`.`page_title_suffix`, `Exchange`.`page_description`, `Exchange`.`credit`, `Exchange`.`credit_limit`, `Exchange`.`balance`, `Exchange`.`barter21_cash_fee`, `Exchange`.`barter21_barter_fee`, `Exchange`.`barter21_monthly_fee_max`, `Exchange`.`barter21_monthly_fee_min`, `Exchange`.`barter21_monthly_barter_fee_max`, `Exchange`.`barter21_monthly_barter_fee_min`, `Exchange`.`barter21_buyer_fee`, `Exchange`.`barter21_seller_fee`, `Exchange`.`default_currency`, `Exchange`.`default_business_seller_cash_fee`, `Exchange`.`default_business_seller_barter_fee`, `Exchange`.`default_business_buyer_cash_fee`, `Exchange`.`default_business_buyer_barter_fee`, `Exchange`.`default_business_credit_limit`, `Exchange`.`collections_minimum`, `Exchange`.`barter_fee_tax`, `Exchange`.`cash_fee_tax`, `Exchange`.`signup_cash_fee`, `Exchange`.`signup_barter_fee`, `Exchange`.`monthly_admin_cash_fee`, `Exchange`.`monthly_admin_barter_fee`, `Exchange`.`annual_renewal_cash_fee`, `Exchange`.`annual_renewal_barter_fee`, `Exchange`.`statement_grace_period`, `Exchange`.`late_fee`, `Exchange`.`late_fee_grace_period`, `Exchange`.`late_fee_minimum`, `Exchange`.`owner`, `Exchange`.`reconcile`, `Exchange`.`timezone`, `Exchange`.`language`, `Exchange`.`locale`, `Exchange`.`google_analytics_account`, `Exchange`.`skin`, `Exchange`.`theme`, `Exchange`.`theme_params`, `Exchange`.`tax_rate`, `Exchange`.`annual_fee_setting`, `Exchange`.`monlthy_fee_setting`, `Exchange`.`mailchimp_api_key`, `Exchange`.`mailchimp_list_id`, `Exchange`.`default_trading_floor_view`, `Exchange`.`default_daily_email_view`, `Exchange`.`default_role_id`, `Exchange`.`required_ein`, `Exchange`.`required_payment`, `Exchange`.`accepts_eft`, `Exchange`.`accepts_cc`, `Exchange`.`allowable_credit_card_types`, `Region`.`id`, `Region`.`name`, `Region`.`shortname`, `Region`.`description`, `Region`.`exchange_id`, `Region`.`timezone`, `Region`.`language`, `Region`.`locale`, `Region`.`currency_id`, `Region`.`processor_currency`, `Region`.`domain`, `Region`.`theme`, `Region`.`skin`, `Region`.`theme_params`, `Region`.`cash_fee_tax`, `Region`.`barter_fee_tax`, `Region`.`collections_minimum`, `Region`.`signup_cash_fee`, `Region`.`signup_barter_fee`, `Region`.`monthly_admin_cash_fee`, `Region`.`monthly_admin_barter_fee`, `Region`.`annual_renewal_cash_fee`, `Region`.`annual_renewal_barter_fee`, `Region`.`statement_grace_period`, `Region`.`late_fee`, `Region`.`late_fee_minimum`, `Region`.`late_fee_grace_period`, `Region`.`default_business_seller_cash_fee`, `Region`.`default_business_seller_barter_fee`, `Region`.`default_business_buyer_cash_fee`, `Region`.`default_business_buyer_barter_fee`, `Region`.`default_business_credit_limit`, `Region`.`operations_account`, `Region`.`store_approval`, `Region`.`store_autobuy`, `Owner`.`id`, `Owner`.`username`, `Owner`.`password`, `Owner`.`role_id`, `Owner`.`status`, `Owner`.`firstname`, `Owner`.`lastname`, `Owner`.`email`, `Owner`.`address1`, `Owner`.`address2`, `Owner`.`city`, `Owner`.`state`, `Owner`.`zipcode`, `Owner`.`phone1`, `Owner`.`phone2`, `Owner`.`fax1`, `Owner`.`fax2`, `Owner`.`lastlogin_remote_info`, `Owner`.`apikey`, `Contact`.`id`, `Contact`.`username`, `Contact`.`password`, `Contact`.`role_id`, `Contact`.`status`, `Contact`.`firstname`, `Contact`.`lastname`, `Contact`.`email`, `Contact`.`address1`, `Contact`.`address2`, `Contact`.`city`, `Contact`.`state`, `Contact`.`zipcode`, `Contact`.`phone1`, `Contact`.`phone2`, `Contact`.`fax1`, `Contact`.`fax2`, `Contact`.`lastlogin_remote_info`, `Contact`.`apikey`, `Salesperson`.`id`, `Salesperson`.`username`, `Salesperson`.`password`, `Salesperson`.`role_id`, `Salesperson`.`status`, `Salesperson`.`firstname`, `Salesperson`.`lastname`, `Salesperson`.`email`, `Salesperson`.`address1`, `Salesperson`.`address2`, `Salesperson`.`city`, `Salesperson`.`state`, `Salesperson`.`zipcode`, `Salesperson`.`phone1`, `Salesperson`.`phone2`, `Salesperson`.`fax1`, `Salesperson`.`fax2`, `Salesperson`.`lastlogin_remote_info`, `Salesperson`.`apikey`, `Broker`.`id`, `Broker`.`username`, `Broker`.`password`, `Broker`.`role_id`, `Broker`.`status`, `Broker`.`firstname`, `Broker`.`lastname`, `Broker`.`email`, `Broker`.`address1`, `Broker`.`address2`, `Broker`.`city`, `Broker`.`state`, `Broker`.`zipcode`, `Broker`.`phone1`, `Broker`.`phone2`, `Broker`.`fax1`, `Broker`.`fax2`, `Broker`.`lastlogin_remote_info`, `Broker`.`apikey` FROM `businesses` AS `Business` LEFT JOIN `exchanges` AS `Exchange` ON (`Business`.`exchange_id` = `Exchange`.`id`) LEFT JOIN `regions` AS `Region` ON (`Business`.`region_id` = `Region`.`id`) LEFT JOIN `users` AS `Owner` ON (`Business`.`owner` = `Owner`.`id`) LEFT JOIN `users` AS `Contact` ON (`Business`.`contact` = `Contact`.`id`) LEFT JOIN `users` AS `Salesperson` ON (`Business`.`salesperson` = `Salesperson`.`id`) LEFT JOIN `users` AS `Broker` ON (`Business`.`broker` = `Broker`.`id`) WHERE `Business`.`id` = 3251 LIMIT 1	1	1	50
60	SELECT `Note`.`id`, `Note`.`user_id`, `Note`.`business_id`, `Note`.`update_id`, `Note`.`created`, `Note`.`modified`, `Note`.`body`, `Note`.`status` FROM `notes` AS `Note` WHERE `Note`.`business_id` = (3251) ORDER BY created DESC	1	1	27
61	SELECT `User`.`id`, `User`.`username`, `User`.`password`, `User`.`role_id`, `User`.`status`, `User`.`firstname`, `User`.`lastname`, `User`.`email`, `User`.`address1`, `User`.`address2`, `User`.`city`, `User`.`state`, `User`.`zipcode`, `User`.`phone1`, `User`.`phone2`, `User`.`fax1`, `User`.`fax2`, `User`.`lastlogin_remote_info`, `User`.`apikey`, `BusinessesUser`.`business_id`, `BusinessesUser`.`user_id` FROM `users` AS `User` JOIN `businesses_users` AS `BusinessesUser` ON (`BusinessesUser`.`business_id` = 3251 AND `BusinessesUser`.`user_id` = `User`.`id`) WHERE 1 = 1 ORDER BY username ASC	1	1	20
62	SELECT `Category`.`id`, `Category`.`name`, `Category`.`parent`, `BusinessesCategory`.`business_id`, `BusinessesCategory`.`category_id` FROM `categories` AS `Category` JOIN `businesses_categories` AS `BusinessesCategory` ON (`BusinessesCategory`.`business_id` = 3251 AND `BusinessesCategory`.`category_id` = `Category`.`id`) WHERE 1 = 1 ORDER BY name ASC	2	2	53
63	SELECT CONCAT(parent,'.',name) FROM `permissions` AS `Permission` WHERE 1 = 1	54	54	7
64	SELECT `Banlist`.`id`, `Banlist`.`created` FROM `banlist` AS `Banlist` WHERE `Banlist`.`id` = '38.107.179.242' LIMIT 1	0	0	1
65	SELECT `Exchange`.`id`, `Exchange`.`name`, `Exchange`.`shortname`, `Exchange`.`status`, `Exchange`.`httpd`, `Exchange`.`emails`, `Exchange`.`messenger`, `Exchange`.`daily_emails`, `Exchange`.`monthly_fees`, `Exchange`.`annual_fees`, `Exchange`.`monthly_statements`, `Exchange`.`monthly_backups`, `Exchange`.`past_due`, `Exchange`.`late_fees`, `Exchange`.`description`, `Exchange`.`created`, `Exchange`.`network`, `Exchange`.`domain`, `Exchange`.`domain_aliases`, `Exchange`.`messenger_reply`, `Exchange`.`page_title_suffix`, `Exchange`.`page_description`, `Exchange`.`credit`, `Exchange`.`credit_limit`, `Exchange`.`balance`, `Exchange`.`barter21_cash_fee`, `Exchange`.`barter21_barter_fee`, `Exchange`.`barter21_monthly_fee_max`, `Exchange`.`barter21_monthly_fee_min`, `Exchange`.`barter21_monthly_barter_fee_max`, `Exchange`.`barter21_monthly_barter_fee_min`, `Exchange`.`barter21_buyer_fee`, `Exchange`.`barter21_seller_fee`, `Exchange`.`default_currency`, `Exchange`.`default_business_seller_cash_fee`, `Exchange`.`default_business_seller_barter_fee`, `Exchange`.`default_business_buyer_cash_fee`, `Exchange`.`default_business_buyer_barter_fee`, `Exchange`.`default_business_credit_limit`, `Exchange`.`collections_minimum`, `Exchange`.`barter_fee_tax`, `Exchange`.`cash_fee_tax`, `Exchange`.`signup_cash_fee`, `Exchange`.`signup_barter_fee`, `Exchange`.`monthly_admin_cash_fee`, `Exchange`.`monthly_admin_barter_fee`, `Exchange`.`annual_renewal_cash_fee`, `Exchange`.`annual_renewal_barter_fee`, `Exchange`.`statement_grace_period`, `Exchange`.`late_fee`, `Exchange`.`late_fee_grace_period`, `Exchange`.`late_fee_minimum`, `Exchange`.`owner`, `Exchange`.`reconcile`, `Exchange`.`timezone`, `Exchange`.`language`, `Exchange`.`locale`, `Exchange`.`google_analytics_account`, `Exchange`.`skin`, `Exchange`.`theme`, `Exchange`.`theme_params`, `Exchange`.`tax_rate`, `Exchange`.`annual_fee_setting`, `Exchange`.`monlthy_fee_setting`, `Exchange`.`mailchimp_api_key`, `Exchange`.`mailchimp_list_id`, `Exchange`.`default_trading_floor_view`, `Exchange`.`default_daily_email_view`, `Exchange`.`default_role_id`, `Exchange`.`required_ein`, `Exchange`.`required_payment`, `Exchange`.`accepts_eft`, `Exchange`.`accepts_cc`, `Exchange`.`allowable_credit_card_types`, `Owner`.`id`, `Owner`.`name`, `Owner`.`owner` FROM `exchanges` AS `Exchange` LEFT JOIN `businesses` AS `Owner` ON (`Exchange`.`owner` = `Owner`.`id`) WHERE `Exchange`.`shortname` = 'gts' LIMIT 1	1	1	29
66	SELECT `Region`.`id`, `Region`.`name`, `Region`.`shortname`, `Region`.`description`, `Region`.`exchange_id`, `Region`.`timezone`, `Region`.`language`, `Region`.`locale`, `Region`.`currency_id`, `Region`.`processor_currency`, `Region`.`domain`, `Region`.`theme`, `Region`.`skin`, `Region`.`theme_params`, `Region`.`cash_fee_tax`, `Region`.`barter_fee_tax`, `Region`.`collections_minimum`, `Region`.`signup_cash_fee`, `Region`.`signup_barter_fee`, `Region`.`monthly_admin_cash_fee`, `Region`.`monthly_admin_barter_fee`, `Region`.`annual_renewal_cash_fee`, `Region`.`annual_renewal_barter_fee`, `Region`.`statement_grace_period`, `Region`.`late_fee`, `Region`.`late_fee_minimum`, `Region`.`late_fee_grace_period`, `Region`.`default_business_seller_cash_fee`, `Region`.`default_business_seller_barter_fee`, `Region`.`default_business_buyer_cash_fee`, `Region`.`default_business_buyer_barter_fee`, `Region`.`default_business_credit_limit`, `Region`.`operations_account`, `Region`.`store_approval`, `Region`.`store_autobuy` FROM `regions` AS `Region` WHERE `Region`.`exchange_id` = (41) ORDER BY `name` ASC	1	1	25
67	SELECT `Business`.`id`, `Business`.`display_id`, `Business`.`created`, `Business`.`modified`, `Business`.`active`, `Business`.`visible`, `Business`.`local_sell`, `Business`.`local_buy`, `Business`.`buy_hold`, `Business`.`sell_hold`, `Business`.`broker_managed`, `Business`.`reciprocal_account`, `Business`.`process_annual_fees`, `Business`.`spend_down`, `Business`.`name`, `Business`.`region_id`, `Business`.`photo_id`, `Business`.`exchange_id`, `Business`.`broker`, `Business`.`salesperson`, `Business`.`owner`, `Business`.`contact`, `Business`.`shortname`, `Business`.`description`, `Business`.`comment`, `Business`.`cash_credit`, `Business`.`credit`, `Business`.`credit_limit`, `Business`.`balance`, `Business`.`cash_due`, `Business`.`past_due`, `Business`.`monthly_cash`, `Business`.`monthly_barter`, `Business`.`annual_cash`, `Business`.`annual_barter`, `Business`.`ein`, `Business`.`ssn`, `Business`.`payment_method`, `Business`.`credit_card_type`, `Business`.`credit_card_number`, `Business`.`credit_card_expiration`, `Business`.`credit_card_security_code`, `Business`.`credit_card_security_code_backup`, `Business`.`echeck_checkname`, `Business`.`echeck_routing_number`, `Business`.`echeck_account_number`, `Business`.`echeck_account_class`, `Business`.`echeck_account_type`, `Business`.`echeck_bank_name`, `Business`.`billing_firstname`, `Business`.`billing_lastname`, `Business`.`billing_address1`, `Business`.`billing_city`, `Business`.`billing_state`, `Business`.`billing_zip`, `Business`.`billing_country`, `Business`.`billing_email`, `Business`.`barter_buyer_fee`, `Business`.`barter_seller_fee`, `Business`.`cash_buyer_fee`, `Business`.`cash_seller_fee`, `Business`.`email`, `Business`.`address1`, `Business`.`address2`, `Business`.`city`, `Business`.`state`, `Business`.`zipcode`, `Business`.`country`, `Business`.`phone1`, `Business`.`phone2`, `Business`.`fax1`, `Business`.`fax2`, `Business`.`url`, `Business`.`referral`, `Business`.`w9_name`, `Business`.`w9_business_name`, `Business`.`w9_business_type`, `Business`.`w9_address1`, `Business`.`w9_address2`, `Business`.`w9_country`, `Business`.`w9_city`, `Business`.`w9_state`, `Business`.`w9_zipcode`, `Business`.`w9_id`, `Business`.`w9_remote_info`, `Business`.`mailing_address1`, `Business`.`mailing_address2`, `Business`.`mailing_country`, `Business`.`mailing_city`, `Business`.`mailing_state`, `Business`.`mailing_zipcode`, `Business`.`phone3`, `Exchange`.`id`, `Exchange`.`name`, `Exchange`.`shortname`, `Exchange`.`status`, `Exchange`.`httpd`, `Exchange`.`emails`, `Exchange`.`messenger`, `Exchange`.`daily_emails`, `Exchange`.`monthly_fees`, `Exchange`.`annual_fees`, `Exchange`.`monthly_statements`, `Exchange`.`monthly_backups`, `Exchange`.`past_due`, `Exchange`.`late_fees`, `Exchange`.`description`, `Exchange`.`created`, `Exchange`.`network`, `Exchange`.`domain`, `Exchange`.`domain_aliases`, `Exchange`.`messenger_reply`, `Exchange`.`page_title_suffix`, `Exchange`.`page_description`, `Exchange`.`credit`, `Exchange`.`credit_limit`, `Exchange`.`balance`, `Exchange`.`barter21_cash_fee`, `Exchange`.`barter21_barter_fee`, `Exchange`.`barter21_monthly_fee_max`, `Exchange`.`barter21_monthly_fee_min`, `Exchange`.`barter21_monthly_barter_fee_max`, `Exchange`.`barter21_monthly_barter_fee_min`, `Exchange`.`barter21_buyer_fee`, `Exchange`.`barter21_seller_fee`, `Exchange`.`default_currency`, `Exchange`.`default_business_seller_cash_fee`, `Exchange`.`default_business_seller_barter_fee`, `Exchange`.`default_business_buyer_cash_fee`, `Exchange`.`default_business_buyer_barter_fee`, `Exchange`.`default_business_credit_limit`, `Exchange`.`collections_minimum`, `Exchange`.`barter_fee_tax`, `Exchange`.`cash_fee_tax`, `Exchange`.`signup_cash_fee`, `Exchange`.`signup_barter_fee`, `Exchange`.`monthly_admin_cash_fee`, `Exchange`.`monthly_admin_barter_fee`, `Exchange`.`annual_renewal_cash_fee`, `Exchange`.`annual_renewal_barter_fee`, `Exchange`.`statement_grace_period`, `Exchange`.`late_fee`, `Exchange`.`late_fee_grace_period`, `Exchange`.`late_fee_minimum`, `Exchange`.`owner`, `Exchange`.`reconcile`, `Exchange`.`timezone`, `Exchange`.`language`, `Exchange`.`locale`, `Exchange`.`google_analytics_account`, `Exchange`.`skin`, `Exchange`.`theme`, `Exchange`.`theme_params`, `Exchange`.`tax_rate`, `Exchange`.`annual_fee_setting`, `Exchange`.`monlthy_fee_setting`, `Exchange`.`mailchimp_api_key`, `Exchange`.`mailchimp_list_id`, `Exchange`.`default_trading_floor_view`, `Exchange`.`default_daily_email_view`, `Exchange`.`default_role_id`, `Exchange`.`required_ein`, `Exchange`.`required_payment`, `Exchange`.`accepts_eft`, `Exchange`.`accepts_cc`, `Exchange`.`allowable_credit_card_types`, `Region`.`id`, `Region`.`name`, `Region`.`shortname`, `Region`.`description`, `Region`.`exchange_id`, `Region`.`timezone`, `Region`.`language`, `Region`.`locale`, `Region`.`currency_id`, `Region`.`processor_currency`, `Region`.`domain`, `Region`.`theme`, `Region`.`skin`, `Region`.`theme_params`, `Region`.`cash_fee_tax`, `Region`.`barter_fee_tax`, `Region`.`collections_minimum`, `Region`.`signup_cash_fee`, `Region`.`signup_barter_fee`, `Region`.`monthly_admin_cash_fee`, `Region`.`monthly_admin_barter_fee`, `Region`.`annual_renewal_cash_fee`, `Region`.`annual_renewal_barter_fee`, `Region`.`statement_grace_period`, `Region`.`late_fee`, `Region`.`late_fee_minimum`, `Region`.`late_fee_grace_period`, `Region`.`default_business_seller_cash_fee`, `Region`.`default_business_seller_barter_fee`, `Region`.`default_business_buyer_cash_fee`, `Region`.`default_business_buyer_barter_fee`, `Region`.`default_business_credit_limit`, `Region`.`operations_account`, `Region`.`store_approval`, `Region`.`store_autobuy`, `Owner`.`id`, `Owner`.`username`, `Owner`.`password`, `Owner`.`role_id`, `Owner`.`status`, `Owner`.`firstname`, `Owner`.`lastname`, `Owner`.`email`, `Owner`.`address1`, `Owner`.`address2`, `Owner`.`city`, `Owner`.`state`, `Owner`.`zipcode`, `Owner`.`phone1`, `Owner`.`phone2`, `Owner`.`fax1`, `Owner`.`fax2`, `Owner`.`lastlogin_remote_info`, `Owner`.`apikey`, `Contact`.`id`, `Contact`.`username`, `Contact`.`password`, `Contact`.`role_id`, `Contact`.`status`, `Contact`.`firstname`, `Contact`.`lastname`, `Contact`.`email`, `Contact`.`address1`, `Contact`.`address2`, `Contact`.`city`, `Contact`.`state`, `Contact`.`zipcode`, `Contact`.`phone1`, `Contact`.`phone2`, `Contact`.`fax1`, `Contact`.`fax2`, `Contact`.`lastlogin_remote_info`, `Contact`.`apikey`, `Salesperson`.`id`, `Salesperson`.`username`, `Salesperson`.`password`, `Salesperson`.`role_id`, `Salesperson`.`status`, `Salesperson`.`firstname`, `Salesperson`.`lastname`, `Salesperson`.`email`, `Salesperson`.`address1`, `Salesperson`.`address2`, `Salesperson`.`city`, `Salesperson`.`state`, `Salesperson`.`zipcode`, `Salesperson`.`phone1`, `Salesperson`.`phone2`, `Salesperson`.`fax1`, `Salesperson`.`fax2`, `Salesperson`.`lastlogin_remote_info`, `Salesperson`.`apikey`, `Broker`.`id`, `Broker`.`username`, `Broker`.`password`, `Broker`.`role_id`, `Broker`.`status`, `Broker`.`firstname`, `Broker`.`lastname`, `Broker`.`email`, `Broker`.`address1`, `Broker`.`address2`, `Broker`.`city`, `Broker`.`state`, `Broker`.`zipcode`, `Broker`.`phone1`, `Broker`.`phone2`, `Broker`.`fax1`, `Broker`.`fax2`, `Broker`.`lastlogin_remote_info`, `Broker`.`apikey` FROM `businesses` AS `Business` LEFT JOIN `exchanges` AS `Exchange` ON (`Business`.`exchange_id` = `Exchange`.`id`) LEFT JOIN `regions` AS `Region` ON (`Business`.`region_id` = `Region`.`id`) LEFT JOIN `users` AS `Owner` ON (`Business`.`owner` = `Owner`.`id`) LEFT JOIN `users` AS `Contact` ON (`Business`.`contact` = `Contact`.`id`) LEFT JOIN `users` AS `Salesperson` ON (`Business`.`salesperson` = `Salesperson`.`id`) LEFT JOIN `users` AS `Broker` ON (`Business`.`broker` = `Broker`.`id`) WHERE `Business`.`id` = 3251 LIMIT 1	1	1	64
68	SELECT `Note`.`id`, `Note`.`user_id`, `Note`.`business_id`, `Note`.`update_id`, `Note`.`created`, `Note`.`modified`, `Note`.`body`, `Note`.`status` FROM `notes` AS `Note` WHERE `Note`.`business_id` = (3251) ORDER BY created DESC	1	1	1
69	SELECT `User`.`id`, `User`.`username`, `User`.`password`, `User`.`role_id`, `User`.`status`, `User`.`firstname`, `User`.`lastname`, `User`.`email`, `User`.`address1`, `User`.`address2`, `User`.`city`, `User`.`state`, `User`.`zipcode`, `User`.`phone1`, `User`.`phone2`, `User`.`fax1`, `User`.`fax2`, `User`.`lastlogin_remote_info`, `User`.`apikey`, `BusinessesUser`.`business_id`, `BusinessesUser`.`user_id` FROM `users` AS `User` JOIN `businesses_users` AS `BusinessesUser` ON (`BusinessesUser`.`business_id` = 3251 AND `BusinessesUser`.`user_id` = `User`.`id`) WHERE 1 = 1 ORDER BY username ASC	1	1	84
70	SELECT `Category`.`id`, `Category`.`name`, `Category`.`parent`, `BusinessesCategory`.`business_id`, `BusinessesCategory`.`category_id` FROM `categories` AS `Category` JOIN `businesses_categories` AS `BusinessesCategory` ON (`BusinessesCategory`.`business_id` = 3251 AND `BusinessesCategory`.`category_id` = `Category`.`id`) WHERE 1 = 1 ORDER BY name ASC	2	2	49
71	SELECT CONCAT(parent,'.',name) FROM `permissions` AS `Permission` WHERE 1 = 1	54	54	0
72	SELECT `ItemLeftrail`.`item_id`, `ItemLeftrail`.`exchange_id`, `ItemLeftrail`.`created`, `ItemLeftrail`.`lastupdated`, `ItemLeftrail`.`position`, `ItemLeftrail`.`live`, `Item`.`id`, `Item`.`approval`, `Item`.`exchange_id`, `Item`.`currency_id`, `Item`.`stop`, `Item`.`created`, `Item`.`lastmodified`, `Item`.`emailed`, `Item`.`sorted`, `Item`.`name`, `Item`.`shortname`, `Item`.`description`, `Item`.`location`, `Item`.`zip`, `Item`.`barter`, `Item`.`inventory`, `Item`.`business_id`, `Item`.`original_business_id`, `Item`.`user_id`, `Item`.`shippable`, `Item`.`shipping_cost`, `Item`.`shipping_description`, `Item`.`condition`, `Item`.`contact` FROM `items_leftrail` AS `ItemLeftrail` LEFT JOIN `items` AS `Item` ON (`ItemLeftrail`.`item_id` = `Item`.`id`) WHERE `ItemLeftrail`.`exchange_id` = 41 ORDER BY rand() ASC LIMIT 5	4	4	1
73	SELECT `Item`.`id`, `Item`.`approval`, `Item`.`exchange_id`, `Item`.`currency_id`, `Item`.`stop`, `Item`.`created`, `Item`.`lastmodified`, `Item`.`emailed`, `Item`.`sorted`, `Item`.`name`, `Item`.`shortname`, `Item`.`description`, `Item`.`location`, `Item`.`zip`, `Item`.`barter`, `Item`.`inventory`, `Item`.`business_id`, `Item`.`original_business_id`, `Item`.`user_id`, `Item`.`shippable`, `Item`.`shipping_cost`, `Item`.`shipping_description`, `Item`.`condition`, `Item`.`contact` FROM `items` AS `Item` WHERE `Item`.`id` = 4281	1	1	1
74	SELECT `User`.`id`, `User`.`username`, `User`.`password`, `User`.`role_id`, `User`.`status`, `User`.`firstname`, `User`.`lastname`, `User`.`email`, `User`.`address1`, `User`.`address2`, `User`.`city`, `User`.`state`, `User`.`zipcode`, `User`.`phone1`, `User`.`phone2`, `User`.`fax1`, `User`.`fax2`, `User`.`lastlogin_remote_info`, `User`.`apikey` FROM `users` AS `User` WHERE `User`.`id` = 3820	1	1	0
75	SELECT `Photo`.`id`, `Photo`.`created`, `Photo`.`lastmodified`, `Photo`.`filename`, `Photo`.`protected`, `Photo`.`type`, `Photo`.`mongoid`, `ItemsPhoto`.`item_id`, `ItemsPhoto`.`photo_id`, `ItemsPhoto`.`position` FROM `photos` AS `Photo` JOIN `items_photos` AS `ItemsPhoto` ON (`ItemsPhoto`.`item_id` = 4281 AND `ItemsPhoto`.`photo_id` = `Photo`.`id`) WHERE 1 = 1 ORDER BY position ASC	3	3	0
76	SELECT `Item`.`id`, `Item`.`approval`, `Item`.`exchange_id`, `Item`.`currency_id`, `Item`.`stop`, `Item`.`created`, `Item`.`lastmodified`, `Item`.`emailed`, `Item`.`sorted`, `Item`.`name`, `Item`.`shortname`, `Item`.`description`, `Item`.`location`, `Item`.`zip`, `Item`.`barter`, `Item`.`inventory`, `Item`.`business_id`, `Item`.`original_business_id`, `Item`.`user_id`, `Item`.`shippable`, `Item`.`shipping_cost`, `Item`.`shipping_description`, `Item`.`condition`, `Item`.`contact` FROM `items` AS `Item` WHERE `Item`.`id` = 4303	1	1	1
77	SELECT `User`.`id`, `User`.`username`, `User`.`password`, `User`.`role_id`, `User`.`status`, `User`.`firstname`, `User`.`lastname`, `User`.`email`, `User`.`address1`, `User`.`address2`, `User`.`city`, `User`.`state`, `User`.`zipcode`, `User`.`phone1`, `User`.`phone2`, `User`.`fax1`, `User`.`fax2`, `User`.`lastlogin_remote_info`, `User`.`apikey` FROM `users` AS `User` WHERE `User`.`id` = 3843	1	1	0
78	SELECT `Photo`.`id`, `Photo`.`created`, `Photo`.`lastmodified`, `Photo`.`filename`, `Photo`.`protected`, `Photo`.`type`, `Photo`.`mongoid`, `ItemsPhoto`.`item_id`, `ItemsPhoto`.`photo_id`, `ItemsPhoto`.`position` FROM `photos` AS `Photo` JOIN `items_photos` AS `ItemsPhoto` ON (`ItemsPhoto`.`item_id` = 4303 AND `ItemsPhoto`.`photo_id` = `Photo`.`id`) WHERE 1 = 1 ORDER BY position ASC	2	2	0
79	SELECT `Item`.`id`, `Item`.`approval`, `Item`.`exchange_id`, `Item`.`currency_id`, `Item`.`stop`, `Item`.`created`, `Item`.`lastmodified`, `Item`.`emailed`, `Item`.`sorted`, `Item`.`name`, `Item`.`shortname`, `Item`.`description`, `Item`.`location`, `Item`.`zip`, `Item`.`barter`, `Item`.`inventory`, `Item`.`business_id`, `Item`.`original_business_id`, `Item`.`user_id`, `Item`.`shippable`, `Item`.`shipping_cost`, `Item`.`shipping_description`, `Item`.`condition`, `Item`.`contact` FROM `items` AS `Item` WHERE `Item`.`id` = 2331	1	1	1
80	SELECT `User`.`id`, `User`.`username`, `User`.`password`, `User`.`role_id`, `User`.`status`, `User`.`firstname`, `User`.`lastname`, `User`.`email`, `User`.`address1`, `User`.`address2`, `User`.`city`, `User`.`state`, `User`.`zipcode`, `User`.`phone1`, `User`.`phone2`, `User`.`fax1`, `User`.`fax2`, `User`.`lastlogin_remote_info`, `User`.`apikey` FROM `users` AS `User` WHERE `User`.`id` = 2777	1	1	0
81	SELECT `Photo`.`id`, `Photo`.`created`, `Photo`.`lastmodified`, `Photo`.`filename`, `Photo`.`protected`, `Photo`.`type`, `Photo`.`mongoid`, `ItemsPhoto`.`item_id`, `ItemsPhoto`.`photo_id`, `ItemsPhoto`.`position` FROM `photos` AS `Photo` JOIN `items_photos` AS `ItemsPhoto` ON (`ItemsPhoto`.`item_id` = 2331 AND `ItemsPhoto`.`photo_id` = `Photo`.`id`) WHERE 1 = 1 ORDER BY position ASC	3	3	1
82	SELECT `Item`.`id`, `Item`.`approval`, `Item`.`exchange_id`, `Item`.`currency_id`, `Item`.`stop`, `Item`.`created`, `Item`.`lastmodified`, `Item`.`emailed`, `Item`.`sorted`, `Item`.`name`, `Item`.`shortname`, `Item`.`description`, `Item`.`location`, `Item`.`zip`, `Item`.`barter`, `Item`.`inventory`, `Item`.`business_id`, `Item`.`original_business_id`, `Item`.`user_id`, `Item`.`shippable`, `Item`.`shipping_cost`, `Item`.`shipping_description`, `Item`.`condition`, `Item`.`contact` FROM `items` AS `Item` WHERE `Item`.`id` = 9687	1	1	1
83	SELECT `User`.`id`, `User`.`username`, `User`.`password`, `User`.`role_id`, `User`.`status`, `User`.`firstname`, `User`.`lastname`, `User`.`email`, `User`.`address1`, `User`.`address2`, `User`.`city`, `User`.`state`, `User`.`zipcode`, `User`.`phone1`, `User`.`phone2`, `User`.`fax1`, `User`.`fax2`, `User`.`lastlogin_remote_info`, `User`.`apikey` FROM `users` AS `User` WHERE `User`.`id` = 2777	1	1	0
84	SELECT `Photo`.`id`, `Photo`.`created`, `Photo`.`lastmodified`, `Photo`.`filename`, `Photo`.`protected`, `Photo`.`type`, `Photo`.`mongoid`, `ItemsPhoto`.`item_id`, `ItemsPhoto`.`photo_id`, `ItemsPhoto`.`position` FROM `photos` AS `Photo` JOIN `items_photos` AS `ItemsPhoto` ON (`ItemsPhoto`.`item_id` = 9687 AND `ItemsPhoto`.`photo_id` = `Photo`.`id`) WHERE 1 = 1 ORDER BY position ASC	2	2	1

(default) 84 queries took 1716 ms

Query

Error

Affected

Num. rows

Took (ms)

DESCRIBE `items`

DESCRIBE `users`

DESCRIBE `permissions`

DESCRIBE `users_permissions`

DESCRIBE `businesses`

DESCRIBE `exchanges`

DESCRIBE `regions`

DESCRIBE `currencies`

DESCRIBE `processors`

DESCRIBE `notes`

DESCRIBE `categories`

DESCRIBE `businesses_users`

DESCRIBE `businesses_categories`

DESCRIBE `photos`

DESCRIBE `items_photos`

DESCRIBE `items_categories`

DESCRIBE `items_primary`

DESCRIBE `items_secondary`

DESCRIBE `items_leftrail`

DESCRIBE `banlist`

SELECT `Banlist`.`id`, `Banlist`.`created` FROM `banlist` AS `Banlist` WHERE `Banlist`.`id` = '38.107.179.242' LIMIT 1

SELECT `Exchange`.`id`, `Exchange`.`name`, `Exchange`.`shortname`, `Exchange`.`status`, `Exchange`.`httpd`, `Exchange`.`emails`, `Exchange`.`messenger`, `Exchange`.`daily_emails`, `Exchange`.`monthly_fees`, `Exchange`.`annual_fees`, `Exchange`.`monthly_statements`, `Exchange`.`monthly_backups`, `Exchange`.`past_due`, `Exchange`.`late_fees`, `Exchange`.`description`, `Exchange`.`created`, `Exchange`.`network`, `Exchange`.`domain`, `Exchange`.`domain_aliases`, `Exchange`.`messenger_reply`, `Exchange`.`page_title_suffix`, `Exchange`.`page_description`, `Exchange`.`credit`, `Exchange`.`credit_limit`, `Exchange`.`balance`, `Exchange`.`barter21_cash_fee`, `Exchange`.`barter21_barter_fee`, `Exchange`.`barter21_monthly_fee_max`, `Exchange`.`barter21_monthly_fee_min`, `Exchange`.`barter21_monthly_barter_fee_max`, `Exchange`.`barter21_monthly_barter_fee_min`, `Exchange`.`barter21_buyer_fee`, `Exchange`.`barter21_seller_fee`, `Exchange`.`default_currency`, `Exchange`.`default_business_seller_cash_fee`, `Exchange`.`default_business_seller_barter_fee`, `Exchange`.`default_business_buyer_cash_fee`, `Exchange`.`default_business_buyer_barter_fee`, `Exchange`.`default_business_credit_limit`, `Exchange`.`collections_minimum`, `Exchange`.`barter_fee_tax`, `Exchange`.`cash_fee_tax`, `Exchange`.`signup_cash_fee`, `Exchange`.`signup_barter_fee`, `Exchange`.`monthly_admin_cash_fee`, `Exchange`.`monthly_admin_barter_fee`, `Exchange`.`annual_renewal_cash_fee`, `Exchange`.`annual_renewal_barter_fee`, `Exchange`.`statement_grace_period`, `Exchange`.`late_fee`, `Exchange`.`late_fee_grace_period`, `Exchange`.`late_fee_minimum`, `Exchange`.`owner`, `Exchange`.`reconcile`, `Exchange`.`timezone`, `Exchange`.`language`, `Exchange`.`locale`, `Exchange`.`google_analytics_account`, `Exchange`.`skin`, `Exchange`.`theme`, `Exchange`.`theme_params`, `Exchange`.`tax_rate`, `Exchange`.`annual_fee_setting`, `Exchange`.`monlthy_fee_setting`, `Exchange`.`mailchimp_api_key`, `Exchange`.`mailchimp_list_id`, `Exchange`.`default_trading_floor_view`, `Exchange`.`default_daily_email_view`, `Exchange`.`default_role_id`, `Exchange`.`required_ein`, `Exchange`.`required_payment`, `Exchange`.`accepts_eft`, `Exchange`.`accepts_cc`, `Exchange`.`allowable_credit_card_types`, `Owner`.`id`, `Owner`.`name`, `Owner`.`owner` FROM `exchanges` AS `Exchange` LEFT JOIN `businesses` AS `Owner` ON (`Exchange`.`owner` = `Owner`.`id`) WHERE `Exchange`.`shortname` = 'gts' LIMIT 1

SELECT `Region`.`id`, `Region`.`name`, `Region`.`shortname`, `Region`.`description`, `Region`.`exchange_id`, `Region`.`timezone`, `Region`.`language`, `Region`.`locale`, `Region`.`currency_id`, `Region`.`processor_currency`, `Region`.`domain`, `Region`.`theme`, `Region`.`skin`, `Region`.`theme_params`, `Region`.`cash_fee_tax`, `Region`.`barter_fee_tax`, `Region`.`collections_minimum`, `Region`.`signup_cash_fee`, `Region`.`signup_barter_fee`, `Region`.`monthly_admin_cash_fee`, `Region`.`monthly_admin_barter_fee`, `Region`.`annual_renewal_cash_fee`, `Region`.`annual_renewal_barter_fee`, `Region`.`statement_grace_period`, `Region`.`late_fee`, `Region`.`late_fee_minimum`, `Region`.`late_fee_grace_period`, `Region`.`default_business_seller_cash_fee`, `Region`.`default_business_seller_barter_fee`, `Region`.`default_business_buyer_cash_fee`, `Region`.`default_business_buyer_barter_fee`, `Region`.`default_business_credit_limit`, `Region`.`operations_account`, `Region`.`store_approval`, `Region`.`store_autobuy` FROM `regions` AS `Region` WHERE `Region`.`exchange_id` = (41) ORDER BY `name` ASC

197

SELECT `Business`.`id`, `Business`.`display_id`, `Business`.`created`, `Business`.`modified`, `Business`.`active`, `Business`.`visible`, `Business`.`local_sell`, `Business`.`local_buy`, `Business`.`buy_hold`, `Business`.`sell_hold`, `Business`.`broker_managed`, `Business`.`reciprocal_account`, `Business`.`process_annual_fees`, `Business`.`spend_down`, `Business`.`name`, `Business`.`region_id`, `Business`.`photo_id`, `Business`.`exchange_id`, `Business`.`broker`, `Business`.`salesperson`, `Business`.`owner`, `Business`.`contact`, `Business`.`shortname`, `Business`.`description`, `Business`.`comment`, `Business`.`cash_credit`, `Business`.`credit`, `Business`.`credit_limit`, `Business`.`balance`, `Business`.`cash_due`, `Business`.`past_due`, `Business`.`monthly_cash`, `Business`.`monthly_barter`, `Business`.`annual_cash`, `Business`.`annual_barter`, `Business`.`ein`, `Business`.`ssn`, `Business`.`payment_method`, `Business`.`credit_card_type`, `Business`.`credit_card_number`, `Business`.`credit_card_expiration`, `Business`.`credit_card_security_code`, `Business`.`credit_card_security_code_backup`, `Business`.`echeck_checkname`, `Business`.`echeck_routing_number`, `Business`.`echeck_account_number`, `Business`.`echeck_account_class`, `Business`.`echeck_account_type`, `Business`.`echeck_bank_name`, `Business`.`billing_firstname`, `Business`.`billing_lastname`, `Business`.`billing_address1`, `Business`.`billing_city`, `Business`.`billing_state`, `Business`.`billing_zip`, `Business`.`billing_country`, `Business`.`billing_email`, `Business`.`barter_buyer_fee`, `Business`.`barter_seller_fee`, `Business`.`cash_buyer_fee`, `Business`.`cash_seller_fee`, `Business`.`email`, `Business`.`address1`, `Business`.`address2`, `Business`.`city`, `Business`.`state`, `Business`.`zipcode`, `Business`.`country`, `Business`.`phone1`, `Business`.`phone2`, `Business`.`fax1`, `Business`.`fax2`, `Business`.`url`, `Business`.`referral`, `Business`.`w9_name`, `Business`.`w9_business_name`, `Business`.`w9_business_type`, `Business`.`w9_address1`, `Business`.`w9_address2`, `Business`.`w9_country`, `Business`.`w9_city`, `Business`.`w9_state`, `Business`.`w9_zipcode`, `Business`.`w9_id`, `Business`.`w9_remote_info`, `Business`.`mailing_address1`, `Business`.`mailing_address2`, `Business`.`mailing_country`, `Business`.`mailing_city`, `Business`.`mailing_state`, `Business`.`mailing_zipcode`, `Business`.`phone3`, `Exchange`.`id`, `Exchange`.`name`, `Exchange`.`shortname`, `Exchange`.`status`, `Exchange`.`httpd`, `Exchange`.`emails`, `Exchange`.`messenger`, `Exchange`.`daily_emails`, `Exchange`.`monthly_fees`, `Exchange`.`annual_fees`, `Exchange`.`monthly_statements`, `Exchange`.`monthly_backups`, `Exchange`.`past_due`, `Exchange`.`late_fees`, `Exchange`.`description`, `Exchange`.`created`, `Exchange`.`network`, `Exchange`.`domain`, `Exchange`.`domain_aliases`, `Exchange`.`messenger_reply`, `Exchange`.`page_title_suffix`, `Exchange`.`page_description`, `Exchange`.`credit`, `Exchange`.`credit_limit`, `Exchange`.`balance`, `Exchange`.`barter21_cash_fee`, `Exchange`.`barter21_barter_fee`, `Exchange`.`barter21_monthly_fee_max`, `Exchange`.`barter21_monthly_fee_min`, `Exchange`.`barter21_monthly_barter_fee_max`, `Exchange`.`barter21_monthly_barter_fee_min`, `Exchange`.`barter21_buyer_fee`, `Exchange`.`barter21_seller_fee`, `Exchange`.`default_currency`, `Exchange`.`default_business_seller_cash_fee`, `Exchange`.`default_business_seller_barter_fee`, `Exchange`.`default_business_buyer_cash_fee`, `Exchange`.`default_business_buyer_barter_fee`, `Exchange`.`default_business_credit_limit`, `Exchange`.`collections_minimum`, `Exchange`.`barter_fee_tax`, `Exchange`.`cash_fee_tax`, `Exchange`.`signup_cash_fee`, `Exchange`.`signup_barter_fee`, `Exchange`.`monthly_admin_cash_fee`, `Exchange`.`monthly_admin_barter_fee`, `Exchange`.`annual_renewal_cash_fee`, `Exchange`.`annual_renewal_barter_fee`, `Exchange`.`statement_grace_period`, `Exchange`.`late_fee`, `Exchange`.`late_fee_grace_period`, `Exchange`.`late_fee_minimum`, `Exchange`.`owner`, `Exchange`.`reconcile`, `Exchange`.`timezone`, `Exchange`.`language`, `Exchange`.`locale`, `Exchange`.`google_analytics_account`, `Exchange`.`skin`, `Exchange`.`theme`, `Exchange`.`theme_params`, `Exchange`.`tax_rate`, `Exchange`.`annual_fee_setting`, `Exchange`.`monlthy_fee_setting`, `Exchange`.`mailchimp_api_key`, `Exchange`.`mailchimp_list_id`, `Exchange`.`default_trading_floor_view`, `Exchange`.`default_daily_email_view`, `Exchange`.`default_role_id`, `Exchange`.`required_ein`, `Exchange`.`required_payment`, `Exchange`.`accepts_eft`, `Exchange`.`accepts_cc`, `Exchange`.`allowable_credit_card_types`, `Region`.`id`, `Region`.`name`, `Region`.`shortname`, `Region`.`description`, `Region`.`exchange_id`, `Region`.`timezone`, `Region`.`language`, `Region`.`locale`, `Region`.`currency_id`, `Region`.`processor_currency`, `Region`.`domain`, `Region`.`theme`, `Region`.`skin`, `Region`.`theme_params`, `Region`.`cash_fee_tax`, `Region`.`barter_fee_tax`, `Region`.`collections_minimum`, `Region`.`signup_cash_fee`, `Region`.`signup_barter_fee`, `Region`.`monthly_admin_cash_fee`, `Region`.`monthly_admin_barter_fee`, `Region`.`annual_renewal_cash_fee`, `Region`.`annual_renewal_barter_fee`, `Region`.`statement_grace_period`, `Region`.`late_fee`, `Region`.`late_fee_minimum`, `Region`.`late_fee_grace_period`, `Region`.`default_business_seller_cash_fee`, `Region`.`default_business_seller_barter_fee`, `Region`.`default_business_buyer_cash_fee`, `Region`.`default_business_buyer_barter_fee`, `Region`.`default_business_credit_limit`, `Region`.`operations_account`, `Region`.`store_approval`, `Region`.`store_autobuy`, `Owner`.`id`, `Owner`.`username`, `Owner`.`password`, `Owner`.`role_id`, `Owner`.`status`, `Owner`.`firstname`, `Owner`.`lastname`, `Owner`.`email`, `Owner`.`address1`, `Owner`.`address2`, `Owner`.`city`, `Owner`.`state`, `Owner`.`zipcode`, `Owner`.`phone1`, `Owner`.`phone2`, `Owner`.`fax1`, `Owner`.`fax2`, `Owner`.`lastlogin_remote_info`, `Owner`.`apikey`, `Contact`.`id`, `Contact`.`username`, `Contact`.`password`, `Contact`.`role_id`, `Contact`.`status`, `Contact`.`firstname`, `Contact`.`lastname`, `Contact`.`email`, `Contact`.`address1`, `Contact`.`address2`, `Contact`.`city`, `Contact`.`state`, `Contact`.`zipcode`, `Contact`.`phone1`, `Contact`.`phone2`, `Contact`.`fax1`, `Contact`.`fax2`, `Contact`.`lastlogin_remote_info`, `Contact`.`apikey`, `Salesperson`.`id`, `Salesperson`.`username`, `Salesperson`.`password`, `Salesperson`.`role_id`, `Salesperson`.`status`, `Salesperson`.`firstname`, `Salesperson`.`lastname`, `Salesperson`.`email`, `Salesperson`.`address1`, `Salesperson`.`address2`, `Salesperson`.`city`, `Salesperson`.`state`, `Salesperson`.`zipcode`, `Salesperson`.`phone1`, `Salesperson`.`phone2`, `Salesperson`.`fax1`, `Salesperson`.`fax2`, `Salesperson`.`lastlogin_remote_info`, `Salesperson`.`apikey`, `Broker`.`id`, `Broker`.`username`, `Broker`.`password`, `Broker`.`role_id`, `Broker`.`status`, `Broker`.`firstname`, `Broker`.`lastname`, `Broker`.`email`, `Broker`.`address1`, `Broker`.`address2`, `Broker`.`city`, `Broker`.`state`, `Broker`.`zipcode`, `Broker`.`phone1`, `Broker`.`phone2`, `Broker`.`fax1`, `Broker`.`fax2`, `Broker`.`lastlogin_remote_info`, `Broker`.`apikey` FROM `businesses` AS `Business` LEFT JOIN `exchanges` AS `Exchange` ON (`Business`.`exchange_id` = `Exchange`.`id`) LEFT JOIN `regions` AS `Region` ON (`Business`.`region_id` = `Region`.`id`) LEFT JOIN `users` AS `Owner` ON (`Business`.`owner` = `Owner`.`id`) LEFT JOIN `users` AS `Contact` ON (`Business`.`contact` = `Contact`.`id`) LEFT JOIN `users` AS `Salesperson` ON (`Business`.`salesperson` = `Salesperson`.`id`) LEFT JOIN `users` AS `Broker` ON (`Business`.`broker` = `Broker`.`id`) WHERE `Business`.`id` = 3251 LIMIT 1

SELECT `Note`.`id`, `Note`.`user_id`, `Note`.`business_id`, `Note`.`update_id`, `Note`.`created`, `Note`.`modified`, `Note`.`body`, `Note`.`status` FROM `notes` AS `Note` WHERE `Note`.`business_id` = (3251) ORDER BY created DESC

SELECT `User`.`id`, `User`.`username`, `User`.`password`, `User`.`role_id`, `User`.`status`, `User`.`firstname`, `User`.`lastname`, `User`.`email`, `User`.`address1`, `User`.`address2`, `User`.`city`, `User`.`state`, `User`.`zipcode`, `User`.`phone1`, `User`.`phone2`, `User`.`fax1`, `User`.`fax2`, `User`.`lastlogin_remote_info`, `User`.`apikey`, `BusinessesUser`.`business_id`, `BusinessesUser`.`user_id` FROM `users` AS `User` JOIN `businesses_users` AS `BusinessesUser` ON (`BusinessesUser`.`business_id` = 3251 AND `BusinessesUser`.`user_id` = `User`.`id`) WHERE 1 = 1 ORDER BY username ASC

SELECT `Category`.`id`, `Category`.`name`, `Category`.`parent`, `BusinessesCategory`.`business_id`, `BusinessesCategory`.`category_id` FROM `categories` AS `Category` JOIN `businesses_categories` AS `BusinessesCategory` ON (`BusinessesCategory`.`business_id` = 3251 AND `BusinessesCategory`.`category_id` = `Category`.`id`) WHERE 1 = 1 ORDER BY name ASC

SELECT CONCAT(parent,'.',name) FROM `permissions` AS `Permission` WHERE 1 = 1

select concat(p.parent,'.',p.name) from users as u inner join roles_permissions as rp on u.role_id = rp.role_id inner join permissions as p on p.id = rp.permission_id where u.id = 1

select concat(parent,'.',name), value from users_permissions inner join permissions on permission_id = id where user_id = 1

SELECT `Photo`.`id`, `Photo`.`created`, `Photo`.`lastmodified`, `Photo`.`filename`, `Photo`.`protected`, `Photo`.`type`, `Photo`.`mongoid`, `ItemsPhoto`.`item_id`, `ItemsPhoto`.`photo_id`, `ItemsPhoto`.`position` FROM `photos` AS `Photo` JOIN `items_photos` AS `ItemsPhoto` ON (`ItemsPhoto`.`item_id` = 4281 AND `ItemsPhoto`.`photo_id` = `Photo`.`id`) WHERE 1 = 1 ORDER BY position ASC

SELECT `Category`.`id`, `Category`.`name`, `Category`.`parent`, `ItemsCategory`.`item_id`, `ItemsCategory`.`category_id` FROM `categories` AS `Category` JOIN `items_categories` AS `ItemsCategory` ON (`ItemsCategory`.`item_id` = 4281 AND `ItemsCategory`.`category_id` = `Category`.`id`) WHERE 1 = 1 ORDER BY name ASC

SELECT `User`.`id`, `User`.`username`, `User`.`password`, `User`.`role_id`, `User`.`status`, `User`.`firstname`, `User`.`lastname`, `User`.`email`, `User`.`address1`, `User`.`address2`, `User`.`city`, `User`.`state`, `User`.`zipcode`, `User`.`phone1`, `User`.`phone2`, `User`.`fax1`, `User`.`fax2`, `User`.`lastlogin_remote_info`, `User`.`apikey`, `BusinessesUser`.`business_id`, `BusinessesUser`.`user_id` FROM `users` AS `User` JOIN `businesses_users` AS `BusinessesUser` ON (`BusinessesUser`.`business_id` = 4097 AND `BusinessesUser`.`user_id` = `User`.`id`) WHERE 1 = 1 ORDER BY username ASC

SELECT `Category`.`id`, `Category`.`name`, `Category`.`parent`, `BusinessesCategory`.`business_id`, `BusinessesCategory`.`category_id` FROM `categories` AS `Category` JOIN `businesses_categories` AS `BusinessesCategory` ON (`BusinessesCategory`.`business_id` = 4097 AND `BusinessesCategory`.`category_id` = `Category`.`id`) WHERE 1 = 1 ORDER BY name ASC

SELECT `Currency`.`id`, `Currency`.`modified`, `Currency`.`value`, `Currency`.`name` FROM `currencies` AS `Currency` WHERE `Currency`.`id` = 'USD' LIMIT 1

SELECT `Item`.`id`, `Item`.`approval`, `Item`.`exchange_id`, `Item`.`currency_id`, `Item`.`stop`, `Item`.`created`, `Item`.`lastmodified`, `Item`.`emailed`, `Item`.`sorted`, `Item`.`name`, `Item`.`shortname`, `Item`.`description`, `Item`.`location`, `Item`.`zip`, `Item`.`barter`, `Item`.`inventory`, `Item`.`business_id`, `Item`.`original_business_id`, `Item`.`user_id`, `Item`.`shippable`, `Item`.`shipping_cost`, `Item`.`shipping_description`, `Item`.`condition`, `Item`.`contact`, `User`.`id`, `User`.`username`, `User`.`password`, `User`.`role_id`, `User`.`status`, `User`.`firstname`, `User`.`lastname`, `User`.`email`, `User`.`address1`, `User`.`address2`, `User`.`city`, `User`.`state`, `User`.`zipcode`, `User`.`phone1`, `User`.`phone2`, `User`.`fax1`, `User`.`fax2`, `User`.`lastlogin_remote_info`, `User`.`apikey`, `Business`.`id`, `Business`.`display_id`, `Business`.`created`, `Business`.`modified`, `Business`.`active`, `Business`.`visible`, `Business`.`local_sell`, `Business`.`local_buy`, `Business`.`buy_hold`, `Business`.`sell_hold`, `Business`.`broker_managed`, `Business`.`reciprocal_account`, `Business`.`process_annual_fees`, `Business`.`spend_down`, `Business`.`name`, `Business`.`region_id`, `Business`.`photo_id`, `Business`.`exchange_id`, `Business`.`broker`, `Business`.`salesperson`, `Business`.`owner`, `Business`.`contact`, `Business`.`shortname`, `Business`.`description`, `Business`.`comment`, `Business`.`cash_credit`, `Business`.`credit`, `Business`.`credit_limit`, `Business`.`balance`, `Business`.`cash_due`, `Business`.`past_due`, `Business`.`monthly_cash`, `Business`.`monthly_barter`, `Business`.`annual_cash`, `Business`.`annual_barter`, `Business`.`ein`, `Business`.`ssn`, `Business`.`payment_method`, `Business`.`credit_card_type`, `Business`.`credit_card_number`, `Business`.`credit_card_expiration`, `Business`.`credit_card_security_code`, `Business`.`credit_card_security_code_backup`, `Business`.`echeck_checkname`, `Business`.`echeck_routing_number`, `Business`.`echeck_account_number`, `Business`.`echeck_account_class`, `Business`.`echeck_account_type`, `Business`.`echeck_bank_name`, `Business`.`billing_firstname`, `Business`.`billing_lastname`, `Business`.`billing_address1`, `Business`.`billing_city`, `Business`.`billing_state`, `Business`.`billing_zip`, `Business`.`billing_country`, `Business`.`billing_email`, `Business`.`barter_buyer_fee`, `Business`.`barter_seller_fee`, `Business`.`cash_buyer_fee`, `Business`.`cash_seller_fee`, `Business`.`email`, `Business`.`address1`, `Business`.`address2`, `Business`.`city`, `Business`.`state`, `Business`.`zipcode`, `Business`.`country`, `Business`.`phone1`, `Business`.`phone2`, `Business`.`fax1`, `Business`.`fax2`, `Business`.`url`, `Business`.`referral`, `Business`.`w9_name`, `Business`.`w9_business_name`, `Business`.`w9_business_type`, `Business`.`w9_address1`, `Business`.`w9_address2`, `Business`.`w9_country`, `Business`.`w9_city`, `Business`.`w9_state`, `Business`.`w9_zipcode`, `Business`.`w9_id`, `Business`.`w9_remote_info`, `Business`.`mailing_address1`, `Business`.`mailing_address2`, `Business`.`mailing_country`, `Business`.`mailing_city`, `Business`.`mailing_state`, `Business`.`mailing_zipcode`, `Business`.`phone3`, `Exchange`.`id`, `Exchange`.`name`, `Exchange`.`shortname`, `Exchange`.`status`, `Exchange`.`httpd`, `Exchange`.`emails`, `Exchange`.`messenger`, `Exchange`.`daily_emails`, `Exchange`.`monthly_fees`, `Exchange`.`annual_fees`, `Exchange`.`monthly_statements`, `Exchange`.`monthly_backups`, `Exchange`.`past_due`, `Exchange`.`late_fees`, `Exchange`.`description`, `Exchange`.`created`, `Exchange`.`network`, `Exchange`.`domain`, `Exchange`.`domain_aliases`, `Exchange`.`messenger_reply`, `Exchange`.`page_title_suffix`, `Exchange`.`page_description`, `Exchange`.`credit`, `Exchange`.`credit_limit`, `Exchange`.`balance`, `Exchange`.`barter21_cash_fee`, `Exchange`.`barter21_barter_fee`, `Exchange`.`barter21_monthly_fee_max`, `Exchange`.`barter21_monthly_fee_min`, `Exchange`.`barter21_monthly_barter_fee_max`, `Exchange`.`barter21_monthly_barter_fee_min`, `Exchange`.`barter21_buyer_fee`, `Exchange`.`barter21_seller_fee`, `Exchange`.`default_currency`, `Exchange`.`default_business_seller_cash_fee`, `Exchange`.`default_business_seller_barter_fee`, `Exchange`.`default_business_buyer_cash_fee`, `Exchange`.`default_business_buyer_barter_fee`, `Exchange`.`default_business_credit_limit`, `Exchange`.`collections_minimum`, `Exchange`.`barter_fee_tax`, `Exchange`.`cash_fee_tax`, `Exchange`.`signup_cash_fee`, `Exchange`.`signup_barter_fee`, `Exchange`.`monthly_admin_cash_fee`, `Exchange`.`monthly_admin_barter_fee`, `Exchange`.`annual_renewal_cash_fee`, `Exchange`.`annual_renewal_barter_fee`, `Exchange`.`statement_grace_period`, `Exchange`.`late_fee`, `Exchange`.`late_fee_grace_period`, `Exchange`.`late_fee_minimum`, `Exchange`.`owner`, `Exchange`.`reconcile`, `Exchange`.`timezone`, `Exchange`.`language`, `Exchange`.`locale`, `Exchange`.`google_analytics_account`, `Exchange`.`skin`, `Exchange`.`theme`, `Exchange`.`theme_params`, `Exchange`.`tax_rate`, `Exchange`.`annual_fee_setting`, `Exchange`.`monlthy_fee_setting`, `Exchange`.`mailchimp_api_key`, `Exchange`.`mailchimp_list_id`, `Exchange`.`default_trading_floor_view`, `Exchange`.`default_daily_email_view`, `Exchange`.`default_role_id`, `Exchange`.`required_ein`, `Exchange`.`required_payment`, `Exchange`.`accepts_eft`, `Exchange`.`accepts_cc`, `Exchange`.`allowable_credit_card_types` FROM `items` AS `Item` LEFT JOIN `users` AS `User` ON (`Item`.`user_id` = `User`.`id`) LEFT JOIN `businesses` AS `Business` ON (`Item`.`business_id` = `Business`.`id`) INNER JOIN `exchanges` AS `Exchange` ON (`Business`.`exchange_id` = `Exchange`.`id`) WHERE `business_id` = 4097 AND `inventory` > 0 AND `stop` >= '2012-02-22 23:09:06' AND `Item`.`exchange_id` IN (0, 41) AND `Business`.`exchange_id` = 41 AND `Exchange`.`status` <> 'Stand Alone' ORDER BY RAND() ASC LIMIT 3

SELECT `Photo`.`id`, `Photo`.`created`, `Photo`.`lastmodified`, `Photo`.`filename`, `Photo`.`protected`, `Photo`.`type`, `Photo`.`mongoid`, `ItemsPhoto`.`item_id`, `ItemsPhoto`.`photo_id`, `ItemsPhoto`.`position` FROM `photos` AS `Photo` JOIN `items_photos` AS `ItemsPhoto` ON (`ItemsPhoto`.`item_id` = 9687 AND `ItemsPhoto`.`photo_id` = `Photo`.`id`) WHERE 1 = 1 ORDER BY position ASC

SELECT `Category`.`id`, `Category`.`name`, `Category`.`parent`, `ItemsCategory`.`item_id`, `ItemsCategory`.`category_id` FROM `categories` AS `Category` JOIN `items_categories` AS `ItemsCategory` ON (`ItemsCategory`.`item_id` = 9687 AND `ItemsCategory`.`category_id` = `Category`.`id`) WHERE 1 = 1 ORDER BY name ASC

SELECT `Currency`.`id`, `Currency`.`modified`, `Currency`.`value`, `Currency`.`name` FROM `currencies` AS `Currency` WHERE `Currency`.`id` = 'USD' LIMIT 1

SELECT COUNT(*) AS `count` FROM `items` AS `Item` LEFT JOIN `users` AS `User` ON (`Item`.`user_id` = `User`.`id`) LEFT JOIN `businesses` AS `Business` ON (`Item`.`business_id` = `Business`.`id`) INNER JOIN `exchanges` AS `Exchange` ON (`Business`.`exchange_id` = `Exchange`.`id`) LEFT JOIN `items_categories` AS `ItemsCategories` ON (`ItemsCategories`.`item_id` = `Item`.`id`) INNER JOIN `categories` AS `FilterCategory` ON (`FilterCategory`.`id` = `ItemsCategories`.`category_id`) WHERE `inventory` > 0 AND `stop` >= '2012-02-22 23:09:06' AND `Item`.`exchange_id` IN (0, 41) AND `Business`.`exchange_id` = 41 AND `Exchange`.`status` <> 'Stand Alone' AND `business_id` != 4097 AND `FilterCategory`.`id` IN (396, 398)

SELECT `Item`.`id`, `Item`.`approval`, `Item`.`exchange_id`, `Item`.`currency_id`, `Item`.`stop`, `Item`.`created`, `Item`.`lastmodified`, `Item`.`emailed`, `Item`.`sorted`, `Item`.`name`, `Item`.`shortname`, `Item`.`description`, `Item`.`location`, `Item`.`zip`, `Item`.`barter`, `Item`.`inventory`, `Item`.`business_id`, `Item`.`original_business_id`, `Item`.`user_id`, `Item`.`shippable`, `Item`.`shipping_cost`, `Item`.`shipping_description`, `Item`.`condition`, `Item`.`contact`, `User`.`id`, `User`.`username`, `User`.`password`, `User`.`role_id`, `User`.`status`, `User`.`firstname`, `User`.`lastname`, `User`.`email`, `User`.`address1`, `User`.`address2`, `User`.`city`, `User`.`state`, `User`.`zipcode`, `User`.`phone1`, `User`.`phone2`, `User`.`fax1`, `User`.`fax2`, `User`.`lastlogin_remote_info`, `User`.`apikey`, `Business`.`id`, `Business`.`display_id`, `Business`.`created`, `Business`.`modified`, `Business`.`active`, `Business`.`visible`, `Business`.`local_sell`, `Business`.`local_buy`, `Business`.`buy_hold`, `Business`.`sell_hold`, `Business`.`broker_managed`, `Business`.`reciprocal_account`, `Business`.`process_annual_fees`, `Business`.`spend_down`, `Business`.`name`, `Business`.`region_id`, `Business`.`photo_id`, `Business`.`exchange_id`, `Business`.`broker`, `Business`.`salesperson`, `Business`.`owner`, `Business`.`contact`, `Business`.`shortname`, `Business`.`description`, `Business`.`comment`, `Business`.`cash_credit`, `Business`.`credit`, `Business`.`credit_limit`, `Business`.`balance`, `Business`.`cash_due`, `Business`.`past_due`, `Business`.`monthly_cash`, `Business`.`monthly_barter`, `Business`.`annual_cash`, `Business`.`annual_barter`, `Business`.`ein`, `Business`.`ssn`, `Business`.`payment_method`, `Business`.`credit_card_type`, `Business`.`credit_card_number`, `Business`.`credit_card_expiration`, `Business`.`credit_card_security_code`, `Business`.`credit_card_security_code_backup`, `Business`.`echeck_checkname`, `Business`.`echeck_routing_number`, `Business`.`echeck_account_number`, `Business`.`echeck_account_class`, `Business`.`echeck_account_type`, `Business`.`echeck_bank_name`, `Business`.`billing_firstname`, `Business`.`billing_lastname`, `Business`.`billing_address1`, `Business`.`billing_city`, `Business`.`billing_state`, `Business`.`billing_zip`, `Business`.`billing_country`, `Business`.`billing_email`, `Business`.`barter_buyer_fee`, `Business`.`barter_seller_fee`, `Business`.`cash_buyer_fee`, `Business`.`cash_seller_fee`, `Business`.`email`, `Business`.`address1`, `Business`.`address2`, `Business`.`city`, `Business`.`state`, `Business`.`zipcode`, `Business`.`country`, `Business`.`phone1`, `Business`.`phone2`, `Business`.`fax1`, `Business`.`fax2`, `Business`.`url`, `Business`.`referral`, `Business`.`w9_name`, `Business`.`w9_business_name`, `Business`.`w9_business_type`, `Business`.`w9_address1`, `Business`.`w9_address2`, `Business`.`w9_country`, `Business`.`w9_city`, `Business`.`w9_state`, `Business`.`w9_zipcode`, `Business`.`w9_id`, `Business`.`w9_remote_info`, `Business`.`mailing_address1`, `Business`.`mailing_address2`, `Business`.`mailing_country`, `Business`.`mailing_city`, `Business`.`mailing_state`, `Business`.`mailing_zipcode`, `Business`.`phone3`, `Exchange`.`id`, `Exchange`.`name`, `Exchange`.`shortname`, `Exchange`.`status`, `Exchange`.`httpd`, `Exchange`.`emails`, `Exchange`.`messenger`, `Exchange`.`daily_emails`, `Exchange`.`monthly_fees`, `Exchange`.`annual_fees`, `Exchange`.`monthly_statements`, `Exchange`.`monthly_backups`, `Exchange`.`past_due`, `Exchange`.`late_fees`, `Exchange`.`description`, `Exchange`.`created`, `Exchange`.`network`, `Exchange`.`domain`, `Exchange`.`domain_aliases`, `Exchange`.`messenger_reply`, `Exchange`.`page_title_suffix`, `Exchange`.`page_description`, `Exchange`.`credit`, `Exchange`.`credit_limit`, `Exchange`.`balance`, `Exchange`.`barter21_cash_fee`, `Exchange`.`barter21_barter_fee`, `Exchange`.`barter21_monthly_fee_max`, `Exchange`.`barter21_monthly_fee_min`, `Exchange`.`barter21_monthly_barter_fee_max`, `Exchange`.`barter21_monthly_barter_fee_min`, `Exchange`.`barter21_buyer_fee`, `Exchange`.`barter21_seller_fee`, `Exchange`.`default_currency`, `Exchange`.`default_business_seller_cash_fee`, `Exchange`.`default_business_seller_barter_fee`, `Exchange`.`default_business_buyer_cash_fee`, `Exchange`.`default_business_buyer_barter_fee`, `Exchange`.`default_business_credit_limit`, `Exchange`.`collections_minimum`, `Exchange`.`barter_fee_tax`, `Exchange`.`cash_fee_tax`, `Exchange`.`signup_cash_fee`, `Exchange`.`signup_barter_fee`, `Exchange`.`monthly_admin_cash_fee`, `Exchange`.`monthly_admin_barter_fee`, `Exchange`.`annual_renewal_cash_fee`, `Exchange`.`annual_renewal_barter_fee`, `Exchange`.`statement_grace_period`, `Exchange`.`late_fee`, `Exchange`.`late_fee_grace_period`, `Exchange`.`late_fee_minimum`, `Exchange`.`owner`, `Exchange`.`reconcile`, `Exchange`.`timezone`, `Exchange`.`language`, `Exchange`.`locale`, `Exchange`.`google_analytics_account`, `Exchange`.`skin`, `Exchange`.`theme`, `Exchange`.`theme_params`, `Exchange`.`tax_rate`, `Exchange`.`annual_fee_setting`, `Exchange`.`monlthy_fee_setting`, `Exchange`.`mailchimp_api_key`, `Exchange`.`mailchimp_list_id`, `Exchange`.`default_trading_floor_view`, `Exchange`.`default_daily_email_view`, `Exchange`.`default_role_id`, `Exchange`.`required_ein`, `Exchange`.`required_payment`, `Exchange`.`accepts_eft`, `Exchange`.`accepts_cc`, `Exchange`.`allowable_credit_card_types`, `ItemsCategories`.`item_id`, `ItemsCategories`.`category_id`, `FilterCategory`.`id`, `FilterCategory`.`name`, `FilterCategory`.`parent` FROM `items` AS `Item` LEFT JOIN `users` AS `User` ON (`Item`.`user_id` = `User`.`id`) LEFT JOIN `businesses` AS `Business` ON (`Item`.`business_id` = `Business`.`id`) INNER JOIN `exchanges` AS `Exchange` ON (`Business`.`exchange_id` = `Exchange`.`id`) LEFT JOIN `items_categories` AS `ItemsCategories` ON (`ItemsCategories`.`item_id` = `Item`.`id`) INNER JOIN `categories` AS `FilterCategory` ON (`FilterCategory`.`id` = `ItemsCategories`.`category_id`) WHERE `inventory` > 0 AND `stop` >= '2012-02-22 23:09:06' AND `Item`.`exchange_id` IN (0, 41) AND `Business`.`exchange_id` = 41 AND `Exchange`.`status` <> 'Stand Alone' AND `business_id` != 4097 AND `FilterCategory`.`id` IN (396, 398) ORDER BY RAND() ASC LIMIT 3

140

DESCRIBE `logins`

DESCRIBE `commissions`

DESCRIBE `roles`

SELECT `Banlist`.`id`, `Banlist`.`created` FROM `banlist` AS `Banlist` WHERE `Banlist`.`id` = '38.107.179.242' LIMIT 1

SELECT CONCAT(parent,'.',name) FROM `permissions` AS `Permission` WHERE 1 = 1

SELECT `Banlist`.`id`, `Banlist`.`created` FROM `banlist` AS `Banlist` WHERE `Banlist`.`id` = '38.107.179.242' LIMIT 1

SELECT CONCAT(parent,'.',name) FROM `permissions` AS `Permission` WHERE 1 = 1

SELECT `ItemLeftrail`.`item_id`, `ItemLeftrail`.`exchange_id`, `ItemLeftrail`.`created`, `ItemLeftrail`.`lastupdated`, `ItemLeftrail`.`position`, `ItemLeftrail`.`live`, `Item`.`id`, `Item`.`approval`, `Item`.`exchange_id`, `Item`.`currency_id`, `Item`.`stop`, `Item`.`created`, `Item`.`lastmodified`, `Item`.`emailed`, `Item`.`sorted`, `Item`.`name`, `Item`.`shortname`, `Item`.`description`, `Item`.`location`, `Item`.`zip`, `Item`.`barter`, `Item`.`inventory`, `Item`.`business_id`, `Item`.`original_business_id`, `Item`.`user_id`, `Item`.`shippable`, `Item`.`shipping_cost`, `Item`.`shipping_description`, `Item`.`condition`, `Item`.`contact` FROM `items_leftrail` AS `ItemLeftrail` LEFT JOIN `items` AS `Item` ON (`ItemLeftrail`.`item_id` = `Item`.`id`) WHERE `ItemLeftrail`.`exchange_id` = 41 ORDER BY rand() ASC LIMIT 5

SELECT `Photo`.`id`, `Photo`.`created`, `Photo`.`lastmodified`, `Photo`.`filename`, `Photo`.`protected`, `Photo`.`type`, `Photo`.`mongoid`, `ItemsPhoto`.`item_id`, `ItemsPhoto`.`photo_id`, `ItemsPhoto`.`position` FROM `photos` AS `Photo` JOIN `items_photos` AS `ItemsPhoto` ON (`ItemsPhoto`.`item_id` = 4303 AND `ItemsPhoto`.`photo_id` = `Photo`.`id`) WHERE 1 = 1 ORDER BY position ASC

SELECT `Photo`.`id`, `Photo`.`created`, `Photo`.`lastmodified`, `Photo`.`filename`, `Photo`.`protected`, `Photo`.`type`, `Photo`.`mongoid`, `ItemsPhoto`.`item_id`, `ItemsPhoto`.`photo_id`, `ItemsPhoto`.`position` FROM `photos` AS `Photo` JOIN `items_photos` AS `ItemsPhoto` ON (`ItemsPhoto`.`item_id` = 2331 AND `ItemsPhoto`.`photo_id` = `Photo`.`id`) WHERE 1 = 1 ORDER BY position ASC

SELECT `Photo`.`id`, `Photo`.`created`, `Photo`.`lastmodified`, `Photo`.`filename`, `Photo`.`protected`, `Photo`.`type`, `Photo`.`mongoid`, `ItemsPhoto`.`item_id`, `ItemsPhoto`.`photo_id`, `ItemsPhoto`.`position` FROM `photos` AS `Photo` JOIN `items_photos` AS `ItemsPhoto` ON (`ItemsPhoto`.`item_id` = 9687 AND `ItemsPhoto`.`photo_id` = `Photo`.`id`) WHERE 1 = 1 ORDER BY position ASC

Trading Floor $(".Store .View .search .text input").focus(function () { if($(this).attr('value') == 'Search') { $(this).attr('value', ''); } }); $(".Store .View .search .text input").blur(function () { if(!$(this).attr('value')) { $(this).attr('value', 'Search'); } });

Forgot your password?

Trading Floor