We have over 30+ years experience in the towing industry! We are the experts! Towing Experts...
Lifetime Guarantee
We are the only hitch company online that offers you a Lifetime Guarantee on all of the products that we offer. Lifetime Hitch Guarantee...
Secure Shopping
This site is tested and certified daily to pass the HACKER SAFE Security Scan.
110% Price Protection
Find the exact same product bought from us for a lower price on another web site, we will refund you 110% of the difference between the lower price and our price. 110% Price Protection...
Easy Returns
If you need to exchange a product that you ordered from us please contact us via our toll-free telephone number to work out the exchange - without any hassles or headaches. Easy Returns...
Knowledgeable Support
Call toll-free 866.308.9054 for expert advice on everything we offer.
Phone Sales: Orders taken 24 hours a day. Everyday.
Array
(
[0] => Array
(
[total_queries] => 22
[total_query_time] => 0.072216
[1] => Array
(
[query] => SHOW TABLES FROM `figaro_ecommerce`;
[result] => Resource id #18
[query_time] => 0.002535
[error] =>
[rows] => 79
[fields] => 1
[insert_id] =>
)
[2] => Array
(
[query] => SELECT `iq_user_vehicles`.`vehicle_id` FROM `iq_user_vehicles` WHERE user_id =
[result] =>
[query_time] => 0.001973
[error] => You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
[rows] =>
[fields] =>
[insert_id] =>
)
[3] => Array
(
[query] => SELECT `figaro_group_products`.`product_id` FROM `figaro_group_products` WHERE group_id = 116
[result] => Resource id #29
[query_time] => 0.003083
[error] =>
[rows] => 12
[fields] => 1
[insert_id] =>
)
[4] => Array
(
[query] => SELECT DISTINCT `iq_vehicles`.`year` FROM `iq_vehicles` WHERE 1 = 1 ORDER BY year DESC
[result] => Resource id #31
[query_time] => 0.002105
[error] =>
[rows] => 48
[fields] => 1
[insert_id] =>
)
[5] => Array
(
[query] => SELECT `figaro_product_prices`.`list_price`, `figaro_product_prices`.`your_price` FROM `figaro_product_prices` WHERE product_id IN (4792,4793,4794,4795,4796,4797,4798,4799,4800,4801,4802,4803) AND store_id = 2
[result] => Resource id #32
[query_time] => 0.004789
[error] =>
[rows] => 12
[fields] => 2
[insert_id] =>
)
[6] => Array
(
[query] => SELECT `figaro_product_images`.`id`, `figaro_product_images`.`product_id`, `figaro_product_images`.`image`, `figaro_product_images`.`primary_image` FROM `figaro_product_images` WHERE product_id = 4792
[result] => Resource id #33
[query_time] => 0.004731
[error] =>
[rows] => 1
[fields] => 4
[insert_id] =>
)
[7] => Array
(
[query] => SELECT `figaro_product_prices`.`list_price`, `figaro_product_prices`.`your_price`, `figaro_product_prices`.`bundle_savings` FROM `figaro_product_prices` WHERE product_id = 4792 AND store_id = 2
[result] => Resource id #34
[query_time] => 0.004706
[error] =>
[rows] => 1
[fields] => 3
[insert_id] =>
)
[8] => Array
(
[query] => select p.id,
p.partnumber,
p.name,
pt.id AS type_id,
pt.name AS type_name,
p.description,
p.created,
p.updated,
pw.weight,
pb.id AS brand_id,
b.name AS brand_name,
g.name AS group_name,
gp.group_id AS group_id,
AVG(pr.review_score) AS average_score
from figaro_products p
left join figaro_product_types pt on pt.id = p.product_type_id
left join figaro_product_weights pw on pw.product_id = p.id
left join figaro_product_brands pb on pb.product_id= p.id
left join figaro_brands b on b.id = pb.brand_id
left join figaro_product_reviews pr on pr.partnumber = p.partnumber
left join figaro_group_products gp on gp.product_id = p.id
left join figaro_groups g on g.id = gp.group_id
where p.id = 4792
GROUP BY p.id
[result] => Resource id #35
[query_time] => 0.012887
[error] =>
[rows] => 1
[fields] => 14
[insert_id] =>
)
[9] => Array
(
[query] => SELECT `figaro_products`.`product_type_id` FROM `figaro_products` WHERE id = 4792
[result] => Resource id #36
[query_time] => 0.005075
[error] =>
[rows] => 1
[fields] => 1
[insert_id] =>
)
[10] => Array
(
[query] => SELECT `figaro_product_type_specifications`.`id`, `figaro_product_type_specifications`.`product_type_id`, `figaro_product_type_specifications`.`rank`, `figaro_product_type_specifications`.`name`, `figaro_product_type_specifications`.`default_value`, `figaro_product_type_specifications`.`snapshot` FROM `figaro_product_type_specifications` WHERE product_type_id = 26 ORDER BY rank ASC
[result] => Resource id #37
[query_time] => 0.003963
[error] =>
[rows] => 2
[fields] => 6
[insert_id] =>
)
[11] => Array
(
[query] => SELECT `figaro_product_specifications`.`id`, `figaro_product_specifications`.`product_id`, `figaro_product_specifications`.`product_type_specification_id`, `figaro_product_specifications`.`value`, `figaro_product_specifications`.`created`, `figaro_product_specifications`.`updated` FROM `figaro_product_specifications` WHERE product_id = 4792
[result] => Resource id #38
[query_time] => 0.002026
[error] =>
[rows] => 8
[fields] => 6
[insert_id] =>
)
[12] => Array
(
[query] => SELECT `figaro_product_type_features`.`id`, `figaro_product_type_features`.`product_type_id`, `figaro_product_type_features`.`rank`, `figaro_product_type_features`.`feature`, `figaro_product_type_features`.`snapshot`, `figaro_product_type_features`.`created`, `figaro_product_type_features`.`updated` FROM `figaro_product_type_features` WHERE product_type_id = 26 ORDER BY rank ASC
[result] => Resource id #39
[query_time] => 0.001348
[error] =>
[rows] => 0
[fields] => 7
[insert_id] =>
)
[13] => Array
(
[query] => SELECT `figaro_product_features`.`id`, `figaro_product_features`.`product_id`, `figaro_product_features`.`rank`, `figaro_product_features`.`feature`, `figaro_product_features`.`created`, `figaro_product_features`.`updated` FROM `figaro_product_features` WHERE product_id = 4792 ORDER BY rank ASC
[result] => Resource id #40
[query_time] => 0.00223
[error] =>
[rows] => 3
[fields] => 6
[insert_id] =>
)
[14] => Array
(
[query] => SELECT `figaro_product_type_included`.`id`, `figaro_product_type_included`.`product_type_id`, `figaro_product_type_included`.`rank`, `figaro_product_type_included`.`value`, `figaro_product_type_included`.`created`, `figaro_product_type_included`.`updated` FROM `figaro_product_type_included` WHERE product_type_id = 26 ORDER BY rank ASC
[result] => Resource id #41
[query_time] => 0.001491
[error] =>
[rows] => 0
[fields] => 6
[insert_id] =>
)
[15] => Array
(
[query] => SELECT `figaro_product_included`.`id`, `figaro_product_included`.`product_id`, `figaro_product_included`.`rank`, `figaro_product_included`.`value`, `figaro_product_included`.`created`, `figaro_product_included`.`updated` FROM `figaro_product_included` WHERE product_id = 4792 ORDER BY rank ASC
[result] => Resource id #42
[query_time] => 0.002038
[error] =>
[rows] => 0
[fields] => 6
[insert_id] =>
)
[16] => Array
(
[query] => SELECT `figaro_product_type_not_included`.`id`, `figaro_product_type_not_included`.`product_type_id`, `figaro_product_type_not_included`.`rank`, `figaro_product_type_not_included`.`value`, `figaro_product_type_not_included`.`created`, `figaro_product_type_not_included`.`updated` FROM `figaro_product_type_not_included` WHERE product_type_id = 26 ORDER BY rank ASC
[result] => Resource id #43
[query_time] => 0.001515
[error] =>
[rows] => 0
[fields] => 6
[insert_id] =>
)
[17] => Array
(
[query] => SELECT `figaro_product_not_included`.`id`, `figaro_product_not_included`.`product_id`, `figaro_product_not_included`.`rank`, `figaro_product_not_included`.`value`, `figaro_product_not_included`.`created`, `figaro_product_not_included`.`updated` FROM `figaro_product_not_included` WHERE product_id = 4792 ORDER BY rank ASC
[result] => Resource id #44
[query_time] => 0.002321
[error] =>
[rows] => 0
[fields] => 6
[insert_id] =>
)
[18] => Array
(
[query] => SELECT `figaro_product_footnotes`.`id`, `figaro_product_footnotes`.`product_id`, `figaro_product_footnotes`.`rank`, `figaro_product_footnotes`.`footnote`, `figaro_product_footnotes`.`created`, `figaro_product_footnotes`.`updated` FROM `figaro_product_footnotes` WHERE product_id = 4792 ORDER BY rank ASC
[result] => Resource id #45
[query_time] => 0.003182
[error] =>
[rows] => 1
[fields] => 6
[insert_id] =>
)
[19] => Array
(
[query] => select sql_no_cache user_id, product_id, quantity, bundle_id from figaro_user_carts where user_id = order by id
[result] =>
[query_time] => 0.002806
[error] => You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'order by id' at line 1
[rows] =>
[fields] =>
[insert_id] =>
)
[20] => Array
(
[query] => SELECT `figaro_product_prices`.`product_id`, `figaro_product_prices`.`list_price`, `figaro_product_prices`.`your_price`, `figaro_product_prices`.`bundle_savings` FROM `figaro_product_prices` WHERE product_id IN () AND store_id = 2
[result] =>
[query_time] => 0.00253
[error] => You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND store_id = 2' at line 1
[rows] =>
[fields] =>
[insert_id] =>
)
[21] => Array
(
[query] => select sql_no_cache * from figaro_orders_live where user_id =
[result] =>
[query_time] => 0.00227
[error] => You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
[rows] =>
[fields] =>
[insert_id] =>
)
[22] => Array
(
[query] => select sql_no_cache promo_id from figaro_user_promos where user_id =
[result] =>
[query_time] => 0.002612
[error] => You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
[rows] =>
[fields] =>
[insert_id] =>
)
)
)
)
Add just $150.00 worth of merchandise to receive FREE UPS GROUND shipping!
