Benefits of Barter

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

Top 10 Reasons to Barter with

1.   INCREASE SALES ... will promote your company through our network and affiliates. You’ll reach new customers with our sales force. Our members choose to patronize other members, instead of paying cash outside of the network.

2.   CONSERVE CASH ... Reduce cash costs by paying for them with revenue generated by new barter sales. When you purchase something using , it will be paid for with new sales . . . new sales that would not have happened without us!

3.   INCREASE EFFICIENCY ... Fill idle time and sell excess inventory. Our trade brokers match you with businesses and individuals looking for your goods and services and, in return, you’ll have access to goods and services locally and worldwide!

4.   BARTER SALES LEAD TO CASH SALES ... Do a good job, and you will be referred to cash-paying affiliates, friends and family. Growing your company will be linked to referrals from your satisfied customers!

5.   WHOLESALE BUYING POWER ... Using barter, the real cost of the products and services is the wholesale cost of your trade dollars earned. Making sales with built-in profits makes the expense of your purchases more economical on trade!

6.   NO BAD DEBTS ... We remove the hassle of billing and collections. Call us or use our on-line authorization system to get approval before providing the goods or services.

7.   EASY ACCOUNTING ... works like a bank, providing control, keeping records, and supporting an administration for your barter activities. You need not keep track of the dollars traded. provides you with an easy-to-read detailed monthly statement. We make it simple for you!

8.   NO INTEREST CREDIT LINE ... Apply for a no-interest barter line of credit. We offer your company the chance to buy goods and services at 0% interest!

9.    EMPLOYEE INCENTIVES ... Offer trade dollars as an employee benefit. You could offer your employees vacations, dental, or optical services, health club memberships, restaurant vouchers and so much more!

10.    IMPROVE YOUR LIFESTYLE ... Indulge in a more luxurious life-style with the barter you earn. Send your kids to camp, go to the spa, take a limousine for dinner and a show ALL ON BARTER ... the opportunities are endless!

Copyright © 2012 · Terms & Conditions · Privacy · IRS Information

Unread Messages
[close]

(default) 51 queries took 164 ms
Nr	Query	Affected	Num. rows	Took (ms)
1	DESCRIBE `users`	19	19	1
2	DESCRIBE `permissions`	5	5	1
3	DESCRIBE `users_permissions`	3	3	1
4	DESCRIBE `businesses`	92	92	3
5	DESCRIBE `exchanges`	74	74	2
6	DESCRIBE `regions`	35	35	2
7	DESCRIBE `currencies`	4	4	1
8	DESCRIBE `processors`	5	5	1
9	DESCRIBE `notes`	8	8	1
10	DESCRIBE `categories`	3	3	1
11	DESCRIBE `businesses_users`	2	2	1
12	DESCRIBE `businesses_categories`	2	2	1
13	DESCRIBE `banlist`	2	2	0
14	SELECT `Banlist`.`id`, `Banlist`.`created` FROM `banlist` AS `Banlist` WHERE `Banlist`.`id` = '38.107.179.243' LIMIT 1	0	0	0
15	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	11
16	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	1
17	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	4
18	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	0
19	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	0
20	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	0
21	SELECT CONCAT(parent,'.',name) FROM `permissions` AS `Permission` WHERE 1 = 1	54	54	0
22	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
23	select concat(parent,'.',name), value from users_permissions inner join permissions on permission_id = id where user_id = 1	0	0	0
24	DESCRIBE `items`	24	24	9
25	DESCRIBE `photos`	7	7	10
26	DESCRIBE `items_photos`	3	3	10
27	DESCRIBE `items_categories`	2	2	1
28	DESCRIBE `items_primary`	6	6	1
29	DESCRIBE `items_secondary`	6	6	1
30	DESCRIBE `items_leftrail`	6	6	1
31	SELECT `Banlist`.`id`, `Banlist`.`created` FROM `banlist` AS `Banlist` WHERE `Banlist`.`id` = '38.107.179.243' LIMIT 1	0	0	10
32	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	14
33	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	20
34	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	26
35	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
36	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	7
37	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	2
38	SELECT CONCAT(parent,'.',name) FROM `permissions` AS `Permission` WHERE 1 = 1	54	54	3
39	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
40	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	0
41	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
42	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
43	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	0
44	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
45	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	0
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` FROM `items` AS `Item` WHERE `Item`.`id` = 2331	1	1	0
47	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
48	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	0
49	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	0
50	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	4
51	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	11

(default) 51 queries took 164 ms

Query

Error

Affected

Num. rows

Took (ms)

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

SELECT `Banlist`.`id`, `Banlist`.`created` FROM `banlist` AS `Banlist` WHERE `Banlist`.`id` = '38.107.179.243' 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

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

DESCRIBE `items`

DESCRIBE `photos`

DESCRIBE `items_photos`

DESCRIBE `items_categories`

DESCRIBE `items_primary`

DESCRIBE `items_secondary`

DESCRIBE `items_leftrail`

SELECT `Banlist`.`id`, `Banlist`.`created` FROM `banlist` AS `Banlist` WHERE `Banlist`.`id` = '38.107.179.243' 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 `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

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 `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 `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` = 4303 AND `ItemsPhoto`.`photo_id` = `Photo`.`id`) WHERE 1 = 1 ORDER BY position ASC