by category
by keyword
  advanced options
Search not found.
<< PrevNext >>
No rating found !
Empty shopping cart
Now in your cart
0 items
Subtotal $0

Here is your online shoppers guide which help you to shop products more efficiently.For shoppers guide please click the link below.

Do you need a help? Please click the link below and submit your message.Our support team will reach you soon.
recieve news and hot offers info
(default) 95 queries took 9 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SHOW FULL COLUMNS FROM `products`39391
2SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'utf8_general_ci';110
3SHOW FULL COLUMNS FROM `categories`550
4SHOW FULL COLUMNS FROM `ratings`880
5SHOW FULL COLUMNS FROM `order_details`990
6SHOW FULL COLUMNS FROM `orders`41411
7SHOW FULL COLUMNS FROM `members`52521
8SHOW FULL COLUMNS FROM `member_billing_informations`13131
9SHOW FULL COLUMNS FROM `member_shipping_informations`13131
10SHOW FULL COLUMNS FROM `inventories`881
11SELECT `Inventory`.* FROM `inventories` AS `Inventory` WHERE 1 = 1 LIMIT 1000
12SHOW FULL COLUMNS FROM `site_ratings`770
13SELECT `SiteRating`.* FROM `site_ratings` AS `SiteRating` WHERE `SiteRating`.`is_active` = 1 000
14SELECT `Category`.`id`, `Category`.`category_name`, `Category`.`parent_cat`, `Category`.`is_active`, `Category`.`last_updated` FROM `categories` AS `Category` WHERE `is_active` = 'Y' 20200
15SHOW FULL COLUMNS FROM `stores`47471
16SELECT `Store`.`id`, `Store`.`store_name`, `Store`.`store_url`, `Store`.`contact_name`, `Store`.`sales_representative`, `Store`.`email_address`, `Store`.`username`, `Store`.`password`, `Store`.`package_id`, `Store`.`package_name`, `Store`.`storage_space`, `Store`.`number_of_products`, `Store`.`package_price`, `Store`.`package_setup_fee`, `Store`.`template_package`, `Store`.`template_id`, `Store`.`template_package_price`, `Store`.`design_package_id`, `Store`.`design_package`, `Store`.`design_package_price`, `Store`.`active_ssl`, `Store`.`active_seo`, `Store`.`payment_gateway_id`, `Store`.`sales_tax_percentage`, `Store`.`tax_shipping`, `Store`.`currency`, `Store`.`sales_email`, `Store`.`support_email`, `Store`.`store_info_email`, `Store`.`billing_address`, `Store`.`billing_city`, `Store`.`state_id`, `Store`.`billing_zip`, `Store`.`country_id`, `Store`.`billing_phone`, `Store`.`promo_code`, `Store`.`payable_amount`, `Store`.`session_time_out`, `Store`.`company_logo`, `Store`.`company_slogan`, `Store`.`creation_date`, `Store`.`expiration_date`, `Store`.`active`, `Store`.`expired`, `Store`.`is_paid`, `Store`.`invoice_number`, `Store`.`estimate_number` FROM `stores` AS `Store` WHERE `Store`.`id` = 1 110
17SELECT `Category`.`id`, `Category`.`category_name`, `Category`.`parent_cat` FROM `categories` AS `Category` WHERE `Category`.`is_active` = 'Y' 20200
18SELECT `Category`.`id`, `Category`.`parent_cat` FROM `categories` AS `Category` WHERE `Category`.`id` = 0 000
19SELECT `Category`.`id`, `Category`.`category_name`, `Category`.`parent_cat` FROM `categories` AS `Category` WHERE `Category`.`is_active` = 'Y' 20200
20SELECT `Category`.`id`, `Category`.`parent_cat` FROM `categories` AS `Category` WHERE `Category`.`id` = 4 110
21SELECT `Category`.`id`, `Category`.`category_name`, `Category`.`parent_cat` FROM `categories` AS `Category` WHERE `Category`.`is_active` = 'Y' 20200
22SELECT `Category`.`id`, `Category`.`parent_cat` FROM `categories` AS `Category` WHERE `Category`.`id` = 4 110
23SELECT `Category`.`id`, `Category`.`category_name`, `Category`.`parent_cat` FROM `categories` AS `Category` WHERE `Category`.`is_active` = 'Y' 20200
24SELECT `Category`.`id`, `Category`.`category_name`, `Category`.`parent_cat` FROM `categories` AS `Category` WHERE `Category`.`is_active` = 'Y' 20200
25SELECT `Category`.`id`, `Category`.`parent_cat` FROM `categories` AS `Category` WHERE `Category`.`id` = 4 110
26SELECT `Category`.`id`, `Category`.`category_name`, `Category`.`parent_cat` FROM `categories` AS `Category` WHERE `Category`.`is_active` = 'Y' 20200
27SELECT `Category`.`id`, `Category`.`parent_cat` FROM `categories` AS `Category` WHERE `Category`.`id` = 4 110
28SELECT `Category`.`id`, `Category`.`category_name`, `Category`.`parent_cat` FROM `categories` AS `Category` WHERE `Category`.`is_active` = 'Y' 20200
29SELECT `Category`.`id`, `Category`.`parent_cat` FROM `categories` AS `Category` WHERE `Category`.`id` = 0 000
30SELECT `Category`.`id`, `Category`.`category_name`, `Category`.`parent_cat` FROM `categories` AS `Category` WHERE `Category`.`is_active` = 'Y' 20200
31SELECT `Category`.`id`, `Category`.`parent_cat` FROM `categories` AS `Category` WHERE `Category`.`id` = 7 110
32SELECT `Category`.`id`, `Category`.`category_name`, `Category`.`parent_cat` FROM `categories` AS `Category` WHERE `Category`.`is_active` = 'Y' 20200
33SELECT `Category`.`id`, `Category`.`category_name`, `Category`.`parent_cat` FROM `categories` AS `Category` WHERE `Category`.`is_active` = 'Y' 20200
34SELECT `Category`.`id`, `Category`.`parent_cat` FROM `categories` AS `Category` WHERE `Category`.`id` = 7 110
35SELECT `Category`.`id`, `Category`.`category_name`, `Category`.`parent_cat` FROM `categories` AS `Category` WHERE `Category`.`is_active` = 'Y' 20200
36SELECT `Category`.`id`, `Category`.`parent_cat` FROM `categories` AS `Category` WHERE `Category`.`id` = 0 000
37SELECT `Category`.`id`, `Category`.`category_name`, `Category`.`parent_cat` FROM `categories` AS `Category` WHERE `Category`.`is_active` = 'Y' 20200
38SELECT `Category`.`id`, `Category`.`parent_cat` FROM `categories` AS `Category` WHERE `Category`.`id` = 9 110
39SELECT `Category`.`id`, `Category`.`category_name`, `Category`.`parent_cat` FROM `categories` AS `Category` WHERE `Category`.`is_active` = 'Y' 20200
40SELECT `Category`.`id`, `Category`.`parent_cat` FROM `categories` AS `Category` WHERE `Category`.`id` = 9 110
41SELECT `Category`.`id`, `Category`.`category_name`, `Category`.`parent_cat` FROM `categories` AS `Category` WHERE `Category`.`is_active` = 'Y' 20200
42SELECT `Category`.`id`, `Category`.`parent_cat` FROM `categories` AS `Category` WHERE `Category`.`id` = 9 110
43SELECT `Category`.`id`, `Category`.`category_name`, `Category`.`parent_cat` FROM `categories` AS `Category` WHERE `Category`.`is_active` = 'Y' 20200
44SELECT `Category`.`id`, `Category`.`category_name`, `Category`.`parent_cat` FROM `categories` AS `Category` WHERE `Category`.`is_active` = 'Y' 20200
45SELECT `Category`.`id`, `Category`.`parent_cat` FROM `categories` AS `Category` WHERE `Category`.`id` = 9 110
46SELECT `Category`.`id`, `Category`.`category_name`, `Category`.`parent_cat` FROM `categories` AS `Category` WHERE `Category`.`is_active` = 'Y' 20200
47SELECT `Category`.`id`, `Category`.`parent_cat` FROM `categories` AS `Category` WHERE `Category`.`id` = 9 110
48SELECT `Category`.`id`, `Category`.`category_name`, `Category`.`parent_cat` FROM `categories` AS `Category` WHERE `Category`.`is_active` = 'Y' 20200
49SELECT `Category`.`id`, `Category`.`parent_cat` FROM `categories` AS `Category` WHERE `Category`.`id` = 9 110
50SELECT `Category`.`id`, `Category`.`category_name`, `Category`.`parent_cat` FROM `categories` AS `Category` WHERE `Category`.`is_active` = 'Y' 20200
51SELECT `Category`.`id`, `Category`.`parent_cat` FROM `categories` AS `Category` WHERE `Category`.`id` = 0 000
52SELECT `Category`.`id`, `Category`.`category_name`, `Category`.`parent_cat` FROM `categories` AS `Category` WHERE `Category`.`is_active` = 'Y' 20200
53SELECT `Category`.`id`, `Category`.`parent_cat` FROM `categories` AS `Category` WHERE `Category`.`id` = 14 110
54SELECT `Category`.`id`, `Category`.`category_name`, `Category`.`parent_cat` FROM `categories` AS `Category` WHERE `Category`.`is_active` = 'Y' 20200
55SELECT `Category`.`id`, `Category`.`parent_cat` FROM `categories` AS `Category` WHERE `Category`.`id` = 14 110
56SELECT `Category`.`id`, `Category`.`category_name`, `Category`.`parent_cat` FROM `categories` AS `Category` WHERE `Category`.`is_active` = 'Y' 20200
57SELECT `Category`.`id`, `Category`.`parent_cat` FROM `categories` AS `Category` WHERE `Category`.`id` = 14 110
58SELECT `Category`.`id`, `Category`.`category_name`, `Category`.`parent_cat` FROM `categories` AS `Category` WHERE `Category`.`is_active` = 'Y' 20200
59SELECT `Category`.`id`, `Category`.`parent_cat` FROM `categories` AS `Category` WHERE `Category`.`id` = 14 110
60SELECT `Category`.`id`, `Category`.`category_name`, `Category`.`parent_cat` FROM `categories` AS `Category` WHERE `Category`.`is_active` = 'Y' 20200
61SELECT `Category`.`id`, `Category`.`parent_cat` FROM `categories` AS `Category` WHERE `Category`.`id` = 14 110
62SELECT `Category`.`id`, `Category`.`category_name`, `Category`.`parent_cat` FROM `categories` AS `Category` WHERE `Category`.`is_active` = 'Y' 20200
63SELECT `Category`.`id`, `Category`.`parent_cat` FROM `categories` AS `Category` WHERE `Category`.`id` = 14 110
64SELECT `Category`.`id`, `Category`.`category_name`, `Category`.`parent_cat` FROM `categories` AS `Category` WHERE `Category`.`is_active` = 'Y' 20200
65SELECT `Category`.`id`, `Category`.`category_name`, `Category`.`parent_cat` FROM `categories` AS `Category` WHERE `Category`.`is_active` = 'Y' 20200
66SELECT `Category`.`id`, `Category`.`parent_cat` FROM `categories` AS `Category` WHERE `Category`.`id` = 14 110
67SELECT `Category`.`id`, `Category`.`category_name`, `Category`.`parent_cat` FROM `categories` AS `Category` WHERE `Category`.`is_active` = 'Y' 20200
68SELECT `Category`.`id`, `Category`.`parent_cat` FROM `categories` AS `Category` WHERE `Category`.`id` = 14 110
69SELECT `Category`.`id`, `Category`.`category_name`, `Category`.`parent_cat` FROM `categories` AS `Category` WHERE `Category`.`is_active` = 'Y' 20200
70SELECT `Category`.`id`, `Category`.`parent_cat` FROM `categories` AS `Category` WHERE `Category`.`id` = 14 110
71SELECT `Category`.`id`, `Category`.`category_name`, `Category`.`parent_cat` FROM `categories` AS `Category` WHERE `Category`.`is_active` = 'Y' 20200
72SELECT `Category`.`id`, `Category`.`parent_cat` FROM `categories` AS `Category` WHERE `Category`.`id` = 14 110
73SELECT `Category`.`id`, `Category`.`category_name`, `Category`.`parent_cat` FROM `categories` AS `Category` WHERE `Category`.`is_active` = 'Y' 20200
74SELECT `Category`.`id`, `Category`.`parent_cat` FROM `categories` AS `Category` WHERE `Category`.`id` = 14 110
75SELECT `Category`.`id`, `Category`.`category_name`, `Category`.`parent_cat` FROM `categories` AS `Category` WHERE `Category`.`is_active` = 'Y' 20200
76SELECT `Category`.`id`, `Category`.`parent_cat` FROM `categories` AS `Category` WHERE `Category`.`id` = 14 110
77SELECT `Category`.`id`, `Category`.`category_name`, `Category`.`parent_cat` FROM `categories` AS `Category` WHERE `Category`.`is_active` = 'Y' 20200
78SELECT `Category`.`id`, `Category`.`parent_cat` FROM `categories` AS `Category` WHERE `Category`.`id` = 0 000
79SELECT `Category`.`id`, `Category`.`category_name`, `Category`.`parent_cat` FROM `categories` AS `Category` WHERE `Category`.`is_active` = 'Y' 20200
80SELECT `Category`.`id`, `Category`.`category_name`, `Category`.`parent_cat` FROM `categories` AS `Category` WHERE `Category`.`is_active` = 'Y' 20200
81SELECT `Category`.`id`, `Category`.`parent_cat` FROM `categories` AS `Category` WHERE `Category`.`id` = 0 000
82SELECT `Category`.`id`, `Category`.`category_name`, `Category`.`parent_cat` FROM `categories` AS `Category` WHERE `Category`.`is_active` = 'Y' 20200
83SELECT `Category`.`id`, `Category`.`category_name`, `Category`.`parent_cat` FROM `categories` AS `Category` WHERE `Category`.`is_active` = 'Y' 20200
84SELECT `Category`.`id`, `Category`.`parent_cat` FROM `categories` AS `Category` WHERE `Category`.`id` = 0 001
85SELECT `Category`.`id`, `Category`.`category_name`, `Category`.`parent_cat` FROM `categories` AS `Category` WHERE `Category`.`is_active` = 'Y' 20200
86SELECT `Category`.`id`, `Category`.`category_name`, `Category`.`parent_cat` FROM `categories` AS `Category` WHERE `Category`.`is_active` = 'Y' 20200
87SELECT `Category`.`id`, `Category`.`parent_cat` FROM `categories` AS `Category` WHERE `Category`.`id` = 0 000
88SELECT `Category`.`id`, `Category`.`category_name`, `Category`.`parent_cat` FROM `categories` AS `Category` WHERE `Category`.`is_active` = 'Y' 20200
89SELECT `Category`.`id`, `Category`.`category_name`, `Category`.`parent_cat` FROM `categories` AS `Category` WHERE `Category`.`is_active` = 'Y' 20200
90SHOW FULL COLUMNS FROM `static_pages`551
91SELECT `StaticPage`.`id`, `StaticPage`.`page_title` FROM `static_pages` AS `StaticPage` WHERE `StaticPage`.`is_active` = 'Y' 770
92SELECT `Category`.`id`, `Category`.`category_name`, `Category`.`parent_cat`, `Category`.`is_active`, `Category`.`last_updated` FROM `categories` AS `Category` WHERE ((`Category`.`id` = 11) OR (`Category`.`parent_cat` = 11)) 110
93SELECT COUNT(*) AS `count` FROM `products` AS `Product` LEFT JOIN `categories` AS `Category` ON (`Product`.`category_id` = `Category`.`id`) WHERE (`Product`.`category_id` = 11) 110
94SELECT `Product`.*, `Product`.`id` FROM `products` AS `Product` LEFT JOIN `categories` AS `Category` ON (`Product`.`category_id` = `Category`.`id`) WHERE (`Product`.`category_id` = 11) ORDER BY `Product`.`id` DESC LIMIT 6000
95SELECT `Product`.`id`, `Product`.`type`, `Product`.`account_id`, `Product`.`sku`, `Product`.`upc`, `Product`.`product_name`, `Product`.`image`, `Product`.`image1`, `Product`.`image2`, `Product`.`image3`, `Product`.`description`, `Product`.`is_featured`, `Product`.`is_hot_offer`, `Product`.`category_id`, `Product`.`start_qty`, `Product`.`current_qty`, `Product`.`price_information`, `Product`.`price`, `Product`.`cost`, `Product`.`downloadable_product`, `Product`.`weight`, `Product`.`length`, `Product`.`width`, `Product`.`height`, `Product`.`display_dimension`, `Product`.`tax_information`, `Product`.`max_qty`, `Product`.`retail_min_qty`, `Product`.`retail_max_qty`, `Product`.`wholesale_min_qty`, `Product`.`wholesale_max_qty`, `Product`.`shipping_preferences`, `Product`.`fixed_domestic_amount`, `Product`.`fixed_international_amount`, `Product`.`handling_fee`, `Product`.`ships_separately`, `Product`.`product_options`, `Product`.`modify_date`, `Product`.`active`, `Category`.`id`, `Category`.`category_name`, `Category`.`parent_cat`, `Category`.`is_active`, `Category`.`last_updated` FROM `products` AS `Product` LEFT JOIN `categories` AS `Category` ON (`Product`.`category_id` = `Category`.`id`) WHERE `is_featured` = 'Y' ORDER BY `Product`.`id` DESC 11110