How AllCity Barter Works - AllCity Barter - A Las Vegas Barter and Trade Exchange

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/allcity/",
	"/home/httpd/htdocs/barter21/app/tmp/cache//exchange/allcity/persistent/",
	"/home/httpd/htdocs/barter21/app/tmp/cache//exchange/allcity/models/"
)
$dir	=	"/home/httpd/htdocs/barter21/app/tmp/cache//exchange/allcity/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/allcity/",
	"/home/httpd/htdocs/barter21/app/tmp/cache//exchange/allcity/persistent/",
	"/home/httpd/htdocs/barter21/app/tmp/cache//exchange/allcity/models/"
)
$dir	=	"/home/httpd/htdocs/barter21/app/tmp/cache//exchange/allcity/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/allcity/",
	"/home/httpd/htdocs/barter21/app/tmp/cache//exchange/allcity/persistent/",
	"/home/httpd/htdocs/barter21/app/tmp/cache//exchange/allcity/models/"
)
$dir	=	"/home/httpd/htdocs/barter21/app/tmp/cache//exchange/allcity/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

How AllCity Barter Works

After joining AllCity Barter, you will be credited AllCityTradeDollars for products or services you personally sell. Then use your AllCityTradeDollars to purchase products or services from other members nationwide.

The process is extremely simple. With today’s web-based technology, all buying and selling transactions are completed real-time on our state-of-the-art website. The online transaction will be immediately approved or denied based off the availability of AllCityTradeDollars in your account.

Sales Tax, Tips and Shipping Costs when using AllCity Barter MUST Be Paid In Cash!

Sales Tax, Tips and Shipping are always paid by the buyer and ALWAYS paid in cash. All Taxes and Shipping arrangements including your payment method needs to be discussed by the buyer and seller BEFORE the purchase is completed. As a general rule of business, you should always have Taxes and Shipping paid up front, before shipping out items.

Unread Messages
[close]

(default) 39 queries took 223 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	2
4	DESCRIBE `businesses`	92	92	17
5	DESCRIBE `exchanges`	74	74	2
6	DESCRIBE `regions`	35	35	1
7	DESCRIBE `currencies`	4	4	1
8	DESCRIBE `processors`	5	5	1
9	DESCRIBE `notes`	8	8	4
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	9
14	SELECT `Banlist`.`id`, `Banlist`.`created` FROM `banlist` AS `Banlist` WHERE `Banlist`.`id` = '38.107.179.241' 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` = 'allcity' LIMIT 1	1	1	20
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` = (71) ORDER BY `name` ASC	2	2	19
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` = 5871 LIMIT 1	1	1	19
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` = (5871) ORDER BY created DESC	0	0	1
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` = 5871 AND `BusinessesUser`.`user_id` = `User`.`id`) WHERE 1 = 1 ORDER BY username ASC	1	1	3
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` = 5871 AND `BusinessesCategory`.`category_id` = `Category`.`id`) WHERE 1 = 1 ORDER BY name ASC	2	2	2
21	SELECT CONCAT(parent,'.',name) FROM `permissions` AS `Permission` WHERE 1 = 1	54	54	8
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	1
23	select concat(parent,'.',name), value from users_permissions inner join permissions on permission_id = id where user_id = 1	0	0	8
24	DESCRIBE `items`	24	24	18
25	DESCRIBE `photos`	7	7	1
26	DESCRIBE `items_photos`	3	3	3
27	DESCRIBE `items_categories`	2	2	1
28	DESCRIBE `items_primary`	6	6	2
29	DESCRIBE `items_secondary`	6	6	1
30	DESCRIBE `items_leftrail`	6	6	2
31	SELECT `Banlist`.`id`, `Banlist`.`created` FROM `banlist` AS `Banlist` WHERE `Banlist`.`id` = '38.107.179.241' 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` = 'allcity' LIMIT 1	1	1	21
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` = (71) ORDER BY `name` ASC	2	2	4
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` = 5871 LIMIT 1	1	1	22
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` = (5871) ORDER BY created DESC	0	0	0
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` = 5871 AND `BusinessesUser`.`user_id` = `User`.`id`) WHERE 1 = 1 ORDER BY username ASC	1	1	0
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` = 5871 AND `BusinessesCategory`.`category_id` = `Category`.`id`) WHERE 1 = 1 ORDER BY name ASC	2	2	6
38	SELECT CONCAT(parent,'.',name) FROM `permissions` AS `Permission` WHERE 1 = 1	54	54	0
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` = 71 ORDER BY rand() ASC LIMIT 5	0	0	9

(default) 39 queries took 223 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.241' 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` = 'allcity' 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` = (71) 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` = 5871 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` = (5871) 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` = 5871 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` = 5871 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.241' 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` = 71 ORDER BY rand() ASC LIMIT 5