0
  1. My Store
  2. Rooibos

Rooibos

Browse Categories

Wait! We have a something for you...

Don't leave empty-handed! Simply enter your email below and we will send you a great discount on our products:

We hate spam as much as you do! Your details are never shared and you can unsubscribe at any time.

no thanks

Debug Overview

App Total Time DB Queries DB Query Total Time Amazon Requests
3.0826652050018 392 1.0529 0


No Amazon API Requests Made.


App Debug - Total Time 3.0826652050018 seconds

Number Time From Start Name Description
1 1.8527810573578 Initialise Initialise FSB Function
2 1.8727030754089 App Controller Start Start of the App controller (called before the controller of every page)
3 2.5072810649872 App Controller End End of the App controller (called before the controller of every page)
4 2.5077321529388 Category Start Start of the category controller
5 2.5077381134033 Before Get Category Before getting the category information
6 2.5371870994568 After Get Category After getting the category information
7 2.5371880531311 Before Get Category List Before getting the updated category list
8 2.5375671386719 Start of getCategoryListByGroup Function Before first category groups query
9 2.5379431247711 After initial query Before first category groups query
10 2.5379450321198 Get Category List for Group Before the call to getCategoryList function
11 2.5379481315613 Start of GetCategoryList function Start of the function
12 2.5379509925842 Before getting categories Query to get specific category list
13 2.5384352207184 After getting categories Query to get specific category list
14 2.5384361743927 Before getting category custom Before call to function getCategoryCustom
15 2.5547120571136 After getting category custom After call to function getCategoryCustom
16 2.5547151565552 Before getting category custom Before call to function getCategoryCustom
17 2.5802671909332 After getting category custom After call to function getCategoryCustom
18 2.5802700519562 Before getting sub category list Before call to recursive function getCategoryList
19 2.5802721977234 Start of GetCategoryList function Start of the function
20 2.580274105072 Before getting categories Query to get specific category list
21 2.5809190273285 After getting sub category list After call to recursive function getCategoryList
22 2.5809211730957 Before getting category custom Before call to function getCategoryCustom
23 2.5896530151367 After getting category custom After call to function getCategoryCustom
24 2.5896551609039 Before getting category custom Before call to function getCategoryCustom
25 2.595418214798 After getting category custom After call to function getCategoryCustom
26 2.5954201221466 Before getting category custom Before call to function getCategoryCustom
27 2.6007971763611 After getting category custom After call to function getCategoryCustom
28 2.6007990837097 Before getting category custom Before call to function getCategoryCustom
29 2.6070520877838 After getting category custom After call to function getCategoryCustom
30 2.6070539951324 End of GetCategoryList function End of the function
31 2.6070580482483 Get Category List for Group Before the call to getCategoryList function
32 2.6070601940155 Start of GetCategoryList function Start of the function
33 2.6070621013641 Before getting categories Query to get specific category list
34 2.6076240539551 End of getCategoryListByGroup Function Before return()
35 2.6076261997223 After Get Category List After getting the updated category list
36 2.6076271533966 Before Category Images Before getting the category images
37 2.6081261634827 After Category Images After getting the category images
38 2.6100301742554 Before Sub Category Check Before checking for sub category or products category
39 2.6105601787567 Before Category Products Controller Before loading the category products controller
40 2.6111831665039 Start Category Products Start of Category Products Controller
41 2.6112031936646 After Pagination Options After pagination options in Category Products Controller
42 2.6488780975342 After Cache After Cache checking in Category Products Controller
43 2.6801850795746 After Filter Options After getting filter options and SQL in Category Products Controller
44 2.6846251487732 After Counting Products After counting products in the Category Products Controller
45 2.6852331161499 After Counting Bundles After counting bundles in the Category Products Controller
46 2.6858332157135 After Counting Products After counting products in the Category Products Controller
47 2.6964120864868 After Getting Products After getting products and bundles in the Category Products Controller
48 2.6964840888977 After Pagination Links After getting pagination listing links in the Category Products Controller
49 2.6964859962463 After Getting Bundle Details After getting full details for the bundles in the Category Products Controller
50 2.8381021022797 After Getting Product Details After getting full product details in the Category Products Controller
51 2.8463711738586 After Getting Product/Bundle Reviews After getting full product/bundle customer review in the Category Products Controller
52 2.8491191864014 App_after Controller Start Start of the App_after controller (called after the controller of every page)
53 2.8516211509705 Before Get Options Before the call to getOptions in the tpl class
54 2.9293341636658 After Get Options After the call to getOptions in the tpl class
55 2.9295341968536 App_after Controller End End of the App_after controller (called after the controller of every page)
56 2.929563999176 Before Smarty Before passing everything over to Smarty in the Category Products Controller
57 3.0826461315155 After Loading sub/product controller After checking for sub category or products category and then loading the relevant controller
58 3.08265209198 Finalizing debug Before the debug is output to the page.
59 3.0826640129089 End of App This is the end of the app logging, final timestamp


Query Debug - 392 Database Queries. Total time 1.0529 seconds

Number Time (Seconds) Time (Milliseconds) Query
1 0.0012 0.0012309551239014 
SELECT parameter, value FROM parameters
2 0.0074 0.007436990737915 
SELECT * FROM `bad_bots`
3 0.0005 0.00052404403686523 
SET time_zone = 'Europe/London'
4 0.0033 0.0032799243927002 
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
5 0.0045 0.0045199394226074 
INSERT INTO ga_users (`isbot`, `ips`) SELECT '1', 'a:1:{i:0;s:14:\"18.117.154.188\";}'
6 0.0038 0.0037779808044434 
INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1733373218'
7 0.0048 0.004784107208252 
SELECT * FROM autorun ORDER BY lastrun ASC
8 0.0011 0.0011231899261475 
UPDATE autorun SET lastrun = '2024-12-05 04:33:38' WHERE id = '13'
9 0.0014 0.0013561248779297 
SELECT * FROM version ORDER BY installed DESC LIMIT 1
10 0.0045 0.0044519901275635 
SELECT id FROM pages WHERE pagename = 'rooibos' LIMIT 1
11 0.0048 0.004770040512085 
SELECT id FROM products WHERE pagename = 'rooibos' AND hidden = 0 LIMIT 1
12 0.0028 0.0028069019317627 
SELECT id FROM ebay_products WHERE pagename = 'rooibos'
13 0.0027 0.0026829242706299 
SELECT id FROM custom_products WHERE pagename = 'rooibos'
14 0.0026 0.0026419162750244 
SELECT id FROM categories WHERE pagename = 'rooibos' LIMIT 1
15 0.0034 0.0034458637237549 
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
16 0.0293 0.029325008392334 
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND language = 'en'
17 0.0008 0.00078511238098145 
SELECT * FROM pages WHERE pagename = 'rooibos'
18 0.0062 0.0062470436096191 
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
19 0.0038 0.003774881362915 
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-fluid2018' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
20 0.0011 0.0011458396911621 
SELECT value FROM parameters WHERE parameter IN('EBAY_APP_ID' , 'EBAY_TRACKING_ID','EBAY_NETWORK_ID' , 'GOOGLE_SITE_KEY' , 'GOOGLE_SECRET_KEY' ,'GOOGLE_RECAPTCHA_TYPE','EBAY_AUTH_TOKEN','EBAY_LOCALE')ORDER BY parameter ASC
21 0.0029 0.0028548240661621 
SELECT * FROM sideboxes_pages WHERE sidebox_id = '26'
22 0.0028 0.0028269290924072 
SELECT value FROM template_options WHERE templateuid = 'fsb-fluid2018' AND optionuid = 'DISPLAY_CREDIT_ICON'
23 0.0018 0.001835823059082 
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
24 0.5741 0.57407402992249 
SELECT * FROM ipgeocountries WHERE INET_ATON('18.117.154.188') >= INET_ATON(ip_start) AND INET_ATON('18.117.154.188') <= INET_ATON(ip_end)
25 0.0028 0.0028259754180908 
SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
26 0.0015 0.0015280246734619 
SELECT * FROM countryredirects WHERE countrycode = 'US'
27 0.0007 0.00066399574279785 
SELECT * FROM categories WHERE pagename = 'rooibos'
28 0.0052 0.0051500797271729 
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 27
29 0.0014 0.0013642311096191 
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
30 0.0005 0.00051498413085938 
SELECT id FROM categories WHERE parent_id = '27'
31 0.0052 0.0051548480987549 
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (27)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1
32 0.0022 0.0021870136260986 
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (27)
				  AND p.disabled = 0
33 0.0006 0.00063490867614746 
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (27)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
34 0.0020 0.0019819736480713 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
35 0.0005 0.00049710273742676 
SELECT id FROM categories WHERE parent_id = '27'
36 0.0008 0.00078916549682617 
SELECT p.id FROM products p, products_categories c WHERE p.id = c.product_id AND c.category_id IN (27) AND p.hidden = 0 AND p.salesrank > 0 AND (p.price > 0 OR p.parent = 1) ORDER BY p.salesrank ASC LIMIT 1
37 0.0014 0.0014448165893555 
SELECT * FROM productimages WHERE product_id = '862' ORDER BY sortorder ASC
38 0.0012 0.0011899471282959 
SELECT * FROM categoryimages WHERE category_id = 27
39 0.0012 0.0011909008026123 
SELECT * FROM categorygroups WHERE id = '1'
40 0.0060 0.0059888362884521 
SELECT MIN(p.price) as minprice, MAX(p.price) as maxprice
		FROM products p, products_categories c
		WHERE p.id = c.product_id
		  AND c.category_id = '27'
		  AND p.offers > 0
		  AND p.hidden = 0
		  AND p.enabled = 1
		  AND p.parent = 0
		  AND p.price > 0
41 0.0005 0.00050687789916992 
SELECT parent_id FROM categories WHERE id = '27'
42 0.0004 0.00036501884460449 
SELECT parent_id FROM categories WHERE id = '27'
43 0.0004 0.00036501884460449 
SELECT * FROM categorygroups ORDER BY sortorder ASC
44 0.0005 0.00046586990356445 
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
45 0.0053 0.0053310394287109 
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 26
46 0.0006 0.0005791187286377 
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 26
47 0.0005 0.00047111511230469 
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
48 0.0005 0.00046014785766602 
SELECT id FROM categories WHERE parent_id = '26'
49 0.0067 0.0066699981689453 
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (26)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1
50 0.0007 0.00074005126953125 
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (26)
				  AND p.disabled = 0
51 0.0006 0.0006101131439209 
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (26)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
52 0.0007 0.00065088272094727 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
53 0.0006 0.00064206123352051 
SELECT * FROM categorygroups WHERE id = '1'
54 0.0101 0.010111093521118 
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 27
55 0.0015 0.001539945602417 
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 27
56 0.0009 0.00093913078308105 
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
57 0.0011 0.0010561943054199 
SELECT id FROM categories WHERE parent_id = '27'
58 0.0089 0.0089199542999268 
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (27)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1
59 0.0009 0.00094795227050781 
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (27)
				  AND p.disabled = 0
60 0.0008 0.00079989433288574 
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (27)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
61 0.0006 0.00058412551879883 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
62 0.0005 0.00051999092102051 
SELECT * FROM categorygroups WHERE id = '1'
63 0.0006 0.00063514709472656 
SELECT * FROM categories WHERE parent_id = '27'  AND hidden = 0 ORDER BY sortorder ASC
64 0.0021 0.0021469593048096 
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 28
65 0.0006 0.00062203407287598 
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 28
66 0.0005 0.0005030632019043 
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
67 0.0005 0.00054407119750977 
SELECT id FROM categories WHERE parent_id = '28'
68 0.0022 0.0022239685058594 
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (28)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1
69 0.0008 0.00075793266296387 
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (28)
				  AND p.disabled = 0
70 0.0007 0.00071501731872559 
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (28)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
71 0.0005 0.00052809715270996 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
72 0.0006 0.00058794021606445 
SELECT * FROM categorygroups WHERE id = '1'
73 0.0008 0.00079584121704102 
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 29
74 0.0006 0.00061416625976562 
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 29
75 0.0005 0.00051116943359375 
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
76 0.0005 0.00049114227294922 
SELECT id FROM categories WHERE parent_id = '29'
77 0.0009 0.00086712837219238 
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (29)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1
78 0.0006 0.00059294700622559 
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (29)
				  AND p.disabled = 0
79 0.0007 0.0006861686706543 
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (29)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
80 0.0006 0.00055909156799316 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
81 0.0005 0.00051999092102051 
SELECT * FROM categorygroups WHERE id = '1'
82 0.0007 0.00070619583129883 
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 30
83 0.0006 0.00058197975158691 
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 30
84 0.0005 0.00045895576477051 
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
85 0.0005 0.00049185752868652 
SELECT id FROM categories WHERE parent_id = '30'
86 0.0008 0.00079202651977539 
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (30)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1
87 0.0005 0.00051999092102051 
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (30)
				  AND p.disabled = 0
88 0.0006 0.00060200691223145 
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (30)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
89 0.0006 0.00064706802368164 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
90 0.0005 0.00048089027404785 
SELECT * FROM categorygroups WHERE id = '1'
91 0.0015 0.0014982223510742 
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 31
92 0.0006 0.00056600570678711 
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 31
93 0.0005 0.0004880428314209 
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31
94 0.0005 0.00050902366638184 
SELECT id FROM categories WHERE parent_id = '31'
95 0.0009 0.000885009765625 
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (31)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1
96 0.0006 0.0005650520324707 
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (31)
				  AND p.disabled = 0
97 0.0006 0.0006108283996582 
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (31)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
98 0.0005 0.0005180835723877 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
99 0.0005 0.00052094459533691 
SELECT * FROM categorygroups WHERE id = '1'
100 0.0006 0.00055217742919922 
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '2'  AND hidden = 0 ORDER BY sortorder ASC
101 0.0005 0.00048995018005371 
SELECT * FROM categoryimages WHERE category_id = 27
102 0.0019 0.0018777847290039 
SELECT * FROM template_info WHERE templateuid = 'fsb-fluid2018'
103 0.0005 0.00051593780517578 
SELECT * FROM categories WHERE parent_id = '27'
104 0.0151 0.015082120895386 
SELECT MAX(price) as maxprice, MIN(price) as minprice FROM products WHERE enabled = 1 AND hidden = 0 AND price <> 0
105 0.0033 0.0033271312713623 
SELECT * FROM manufacturers WHERE display_filter = 1 AND merge_manufacturer_id = 0 ORDER BY name
106 0.0027 0.0027060508728027 
SELECT * FROM productattributenames n WHERE hidden = 0 AND metabrowse = 1 ORDER BY n.displayname ASC
107 0.0075 0.007498025894165 
SELECT MAX(price) as maxprice, MIN(price) as minprice FROM products WHERE enabled = 1 AND hidden = 0 AND price <> 0
108 0.0019 0.0018889904022217 
SELECT * FROM manufacturers WHERE display_filter = 1 AND merge_manufacturer_id = 0 ORDER BY name
109 0.0005 0.00054502487182617 
SELECT * FROM productattributenames n WHERE hidden = 0 AND metabrowse = 1 AND sidebarfilter = 1 ORDER BY n.displayname ASC
110 0.0039 0.0038549900054932 
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
		WHERE p.id = c.product_id AND parent_id = 0
		AND c.category_id = 27
		AND (c.prod_type = '' OR c.prod_type = 'amz')
		AND hidden = 0
		AND enabled = 1
		
		AND 1 = 1
111 0.0006 0.00056290626525879 
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
		WHERE ep.id = c.product_id
		AND c.category_id = 27
		AND c.prod_type = 'ebay'
		AND hide = 0
112 0.0006 0.0005950927734375 
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
			WHERE p.id = c.bundle_id AND parent_id = 0
			AND c.category_id = 27
			AND p.disabled = 0
			
			AND 1 = 1
113 0.0006 0.00059008598327637 
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
		WHERE cp.id = c.product_id
		AND c.category_id = 27
		AND c.prod_type = 'custom'
		AND hide = 0
114 0.0105 0.010540008544922 
SELECT DISTINCT (p.id), IF(p.salesrank <> 0, p.salesrank, 100000) AS salesrank, p.price, p.linktitle, p.pagename, 'product' AS type FROM products p, products_categories c
			WHERE p.id = c.product_id
			AND p.parent_id = 0
			AND c.category_id = 27
			AND hidden = 0
			AND enabled = 1
			
			AND 1 = 1 UNION SELECT DISTINCT (p.id), IF(p.salesrank <> 0, p.salesrank, 100000) AS salesrank, p.price, p.linktitle, p.pagename, 'ebay' AS type FROM ebay_products p, products_categories c
		WHERE p.id = c.product_id
		AND c.category_id = 27
		AND c.prod_type = 'ebay'
		AND p.hide = 0 UNION SELECT DISTINCT (p.id), IF(p.salesrank <> 0, p.salesrank, 100000) AS salesrank, p.price, p.linktitle, p.pagename, 'custom' AS type FROM custom_products p, products_categories c
		WHERE p.id = c.product_id
		AND c.category_id = 27
		AND c.prod_type = 'custom'
		AND p.hide = 0 UNION SELECT DISTINCT (p.id), IF(p.salesrank <> 0, p.salesrank, 100000) AS salesrank, p.price, p.linktitle, p.pagename, 'bundle' AS type FROM bundles p, bundle_categories c
			WHERE p.id = c.bundle_id
			AND c.category_id = 27
			AND disabled = 0
			
			AND 1 = 1 ORDER BY salesrank ASC LIMIT 36, 18
115 0.0008 0.00080299377441406 
SELECT * FROM products WHERE id = '1267'
116 0.0009 0.00091695785522461 
SELECT * FROM productimages WHERE product_id = '1267' ORDER BY sortorder ASC
117 0.0017 0.0017499923706055 
SELECT * FROM product_image_select WHERE product_id = '1267'
118 0.0013 0.0012741088867188 
SELECT * FROM productcustomimages WHERE product_id = '1267'
119 0.0019 0.0019071102142334 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1267' AND a.name = n.originalname
120 0.0014 0.0014150142669678 
SELECT * FROM productoffers WHERE product_id = '1267' AND merchantid = 'A1X6FK5RDHNB96'
121 0.0005 0.00048518180847168 
SELECT * FROM productoffers
                WHERE product_id = '1267' AND price > 0
                ORDER BY price ASC LIMIT 1
122 0.0005 0.00047397613525391 
SELECT * FROM productoffers
                WHERE product_id = 1267
                ORDER BY price ASC LIMIT 1
123 0.0006 0.00060319900512695 
SELECT value FROM productattributes
                WHERE product_id = '1267'
                AND name = 'ListPriceAmount'
124 0.0006 0.00057816505432129 
SELECT value FROM productattributes WHERE product_id = '1267' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
125 0.0006 0.00063896179199219 
SELECT * FROM products WHERE id = '858'
126 0.0009 0.00089716911315918 
SELECT * FROM productimages WHERE product_id = '858' ORDER BY sortorder ASC
127 0.0007 0.00068807601928711 
SELECT * FROM product_image_select WHERE product_id = '858'
128 0.0006 0.00062298774719238 
SELECT * FROM productcustomimages WHERE product_id = '858'
129 0.0011 0.001147985458374 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '858' AND a.name = n.originalname
130 0.0006 0.00063490867614746 
SELECT * FROM productoffers WHERE product_id = '858' AND merchantid = 'A1X6FK5RDHNB96'
131 0.0006 0.00055599212646484 
SELECT * FROM productoffers
                WHERE product_id = '858' AND price > 0
                ORDER BY price ASC LIMIT 1
132 0.0006 0.00059318542480469 
SELECT value FROM productattributes WHERE product_id = '858' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
133 0.0007 0.00071310997009277 
SELECT * FROM products WHERE id = '1159'
134 0.0005 0.00053501129150391 
SELECT * FROM productimages WHERE product_id = '1159' ORDER BY sortorder ASC
135 0.0007 0.00069785118103027 
SELECT * FROM product_image_select WHERE product_id = '1159'
136 0.0005 0.00049901008605957 
SELECT * FROM productcustomimages WHERE product_id = '1159'
137 0.0012 0.0011899471282959 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1159' AND a.name = n.originalname
138 0.0006 0.00055789947509766 
SELECT * FROM productoffers WHERE product_id = '1159' AND merchantid = 'A1X6FK5RDHNB96'
139 0.0005 0.00046205520629883 
SELECT * FROM productoffers
                WHERE product_id = '1159' AND price > 0
                ORDER BY price ASC LIMIT 1
140 0.0005 0.00046491622924805 
SELECT value FROM productattributes WHERE product_id = '1159' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
141 0.0006 0.0005950927734375 
SELECT * FROM products WHERE id = '3954'
142 0.0006 0.00057601928710938 
SELECT * FROM productimages WHERE product_id = '3954' ORDER BY sortorder ASC
143 0.0004 0.00043797492980957 
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '3954' AND p.id = pi.product_id ORDER BY pi.sortorder
144 0.0006 0.0006248950958252 
SELECT * FROM product_image_select WHERE product_id = '3954'
145 0.0004 0.00042486190795898 
SELECT * FROM productcustomimages WHERE product_id = '3954'
146 0.0006 0.00058102607727051 
SELECT  o.product_id, MIN(o.price) as price, p.customprice
                FROM    products        p,
                        productoffers   o
                WHERE   p.id        = o.product_id
                  AND   p.parent_id = '3954'
                GROUP BY o.product_id
147 0.0027 0.0027191638946533 
SELECT  n.displayname, o.name
                FROM    productoptionnames  n,
                        productoptions      o,
                        products            p
                WHERE   n.originalname  = o.name
                  AND   o.product_id    = p.id
                  AND   p.parent_id     = '3954'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
148 0.0005 0.00048112869262695 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 3954
149 0.0012 0.0012328624725342 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3954' AND a.name = n.originalname
150 0.0004 0.00043487548828125 
SELECT * FROM productoffers WHERE product_id = '3954' AND merchantid = 'A1X6FK5RDHNB96'
151 0.0004 0.00041794776916504 
SELECT * FROM productoffers
                WHERE product_id = '3954' AND price > 0
                ORDER BY price ASC LIMIT 1
152 0.0004 0.00040292739868164 
SELECT * FROM productoffers
                WHERE product_id = 3954
                ORDER BY price ASC LIMIT 1
153 0.0004 0.00042986869812012 
SELECT value FROM productattributes
                WHERE product_id = '3954'
                AND name = 'ListPriceAmount'
154 0.0005 0.00046896934509277 
SELECT  o.product_id, MIN(o.price) as price, p.customprice
                FROM    products        p,
                        productoffers   o
                WHERE   p.id        = o.product_id
                  AND   p.parent_id = '3954'
                GROUP BY o.product_id
155 0.0006 0.00061511993408203 
SELECT  n.displayname, o.name
                FROM    productoptionnames  n,
                        productoptions      o,
                        products            p
                WHERE   n.originalname  = o.name
                  AND   o.product_id    = p.id
                  AND   p.parent_id     = '3954'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
156 0.0023 0.0023391246795654 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 3954
157 0.0013 0.0013217926025391 
SELECT value FROM productattributes WHERE product_id = '3954' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
158 0.0007 0.00074911117553711 
SELECT * FROM products WHERE parent_id = '3954'
159 0.0010 0.0010359287261963 
SELECT * FROM products WHERE id = '4766'
160 0.0012 0.0012319087982178 
SELECT * FROM productimages WHERE product_id = '4766' ORDER BY sortorder ASC
161 0.0013 0.0012829303741455 
SELECT * FROM product_image_select WHERE product_id = '4766'
162 0.0008 0.00080394744873047 
SELECT * FROM productcustomimages WHERE product_id = '4766'
163 0.0030 0.0029900074005127 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4766' AND a.name = n.originalname
164 0.0009 0.00090909004211426 
SELECT * FROM productoffers WHERE product_id = '4766' AND merchantid = 'A1X6FK5RDHNB96'
165 0.0007 0.00069093704223633 
SELECT * FROM productoffers
                WHERE product_id = '4766' AND price > 0
                ORDER BY price ASC LIMIT 1
166 0.0006 0.00058078765869141 
SELECT * FROM productoffers
                WHERE product_id = 4766
                ORDER BY price ASC LIMIT 1
167 0.0007 0.0006859302520752 
SELECT value FROM productattributes
                WHERE product_id = '4766'
                AND name = 'ListPriceAmount'
168 0.0008 0.00082683563232422 
SELECT value FROM productattributes WHERE product_id = '4766' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
169 0.0011 0.0010740756988525 
SELECT * FROM products WHERE id = '1232'
170 0.0009 0.00094294548034668 
SELECT * FROM productimages WHERE product_id = '1232' ORDER BY sortorder ASC
171 0.0014 0.0014200210571289 
SELECT * FROM product_image_select WHERE product_id = '1232'
172 0.0007 0.00073099136352539 
SELECT * FROM productcustomimages WHERE product_id = '1232'
173 0.0015 0.0014631748199463 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1232' AND a.name = n.originalname
174 0.0008 0.00078701972961426 
SELECT * FROM productoffers WHERE product_id = '1232' AND merchantid = 'A1X6FK5RDHNB96'
175 0.0006 0.00062918663024902 
SELECT * FROM productoffers
                WHERE product_id = '1232' AND price > 0
                ORDER BY price ASC LIMIT 1
176 0.0007 0.0007319450378418 
SELECT value FROM productattributes WHERE product_id = '1232' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
177 0.0009 0.00085997581481934 
SELECT * FROM products WHERE id = '1164'
178 0.0007 0.00071597099304199 
SELECT * FROM productimages WHERE product_id = '1164' ORDER BY sortorder ASC
179 0.0010 0.00099587440490723 
SELECT * FROM product_image_select WHERE product_id = '1164'
180 0.0006 0.0006110668182373 
SELECT * FROM productcustomimages WHERE product_id = '1164'
181 0.0020 0.0019550323486328 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1164' AND a.name = n.originalname
182 0.0007 0.0007331371307373 
SELECT * FROM productoffers WHERE product_id = '1164' AND merchantid = 'A1X6FK5RDHNB96'
183 0.0006 0.00062108039855957 
SELECT * FROM productoffers
                WHERE product_id = '1164' AND price > 0
                ORDER BY price ASC LIMIT 1
184 0.0006 0.00060796737670898 
SELECT value FROM productattributes WHERE product_id = '1164' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
185 0.0007 0.00069093704223633 
SELECT * FROM products WHERE id = '4758'
186 0.0007 0.00065994262695312 
SELECT * FROM productimages WHERE product_id = '4758' ORDER BY sortorder ASC
187 0.0009 0.00088810920715332 
SELECT * FROM product_image_select WHERE product_id = '4758'
188 0.0005 0.00054216384887695 
SELECT * FROM productcustomimages WHERE product_id = '4758'
189 0.0012 0.0011718273162842 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4758' AND a.name = n.originalname
190 0.0006 0.00064182281494141 
SELECT * FROM productoffers WHERE product_id = '4758' AND merchantid = 'A1X6FK5RDHNB96'
191 0.0005 0.00049996376037598 
SELECT * FROM productoffers
                WHERE product_id = '4758' AND price > 0
                ORDER BY price ASC LIMIT 1
192 0.0005 0.00046801567077637 
SELECT * FROM productoffers
                WHERE product_id = 4758
                ORDER BY price ASC LIMIT 1
193 0.0005 0.00053310394287109 
SELECT value FROM productattributes
                WHERE product_id = '4758'
                AND name = 'ListPriceAmount'
194 0.0006 0.00058817863464355 
SELECT value FROM productattributes WHERE product_id = '4758' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
195 0.0007 0.0007169246673584 
SELECT * FROM products WHERE id = '4756'
196 0.0007 0.00067901611328125 
SELECT * FROM productimages WHERE product_id = '4756' ORDER BY sortorder ASC
197 0.0009 0.00086402893066406 
SELECT * FROM product_image_select WHERE product_id = '4756'
198 0.0005 0.00048708915710449 
SELECT * FROM productcustomimages WHERE product_id = '4756'
199 0.0014 0.0013539791107178 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4756' AND a.name = n.originalname
200 0.0006 0.00055599212646484 
SELECT * FROM productoffers WHERE product_id = '4756' AND merchantid = 'A1X6FK5RDHNB96'
201 0.0004 0.00041604042053223 
SELECT * FROM productoffers
                WHERE product_id = '4756' AND price > 0
                ORDER BY price ASC LIMIT 1
202 0.0005 0.00045490264892578 
SELECT * FROM productoffers
                WHERE product_id = 4756
                ORDER BY price ASC LIMIT 1
203 0.0004 0.00044107437133789 
SELECT value FROM productattributes
                WHERE product_id = '4756'
                AND name = 'ListPriceAmount'
204 0.0006 0.0006248950958252 
SELECT value FROM productattributes WHERE product_id = '4756' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
205 0.0006 0.00063610076904297 
SELECT * FROM products WHERE id = '1087'
206 0.0006 0.00055313110351562 
SELECT * FROM productimages WHERE product_id = '1087' ORDER BY sortorder ASC
207 0.0008 0.000762939453125 
SELECT * FROM product_image_select WHERE product_id = '1087'
208 0.0005 0.00046205520629883 
SELECT * FROM productcustomimages WHERE product_id = '1087'
209 0.0011 0.0010888576507568 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1087' AND a.name = n.originalname
210 0.0006 0.00060701370239258 
SELECT * FROM productoffers WHERE product_id = '1087' AND merchantid = 'A1X6FK5RDHNB96'
211 0.0005 0.00052213668823242 
SELECT * FROM productoffers
                WHERE product_id = '1087' AND price > 0
                ORDER BY price ASC LIMIT 1
212 0.0005 0.0005488395690918 
SELECT value FROM productattributes WHERE product_id = '1087' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
213 0.0007 0.00066113471984863 
SELECT * FROM products WHERE id = '4011'
214 0.0006 0.00062704086303711 
SELECT * FROM productimages WHERE product_id = '4011' ORDER BY sortorder ASC
215 0.0007 0.00067496299743652 
SELECT * FROM product_image_select WHERE product_id = '4011'
216 0.0005 0.00050115585327148 
SELECT * FROM productcustomimages WHERE product_id = '4011'
217 0.0014 0.0013988018035889 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4011' AND a.name = n.originalname
218 0.0007 0.00069808959960938 
SELECT * FROM productoffers WHERE product_id = '4011' AND merchantid = 'A1X6FK5RDHNB96'
219 0.0005 0.00050091743469238 
SELECT * FROM productoffers
                WHERE product_id = '4011' AND price > 0
                ORDER BY price ASC LIMIT 1
220 0.0008 0.000823974609375 
SELECT value FROM productattributes WHERE product_id = '4011' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
221 0.0007 0.00065398216247559 
SELECT * FROM products WHERE id = '4614'
222 0.0008 0.00083804130554199 
SELECT * FROM productimages WHERE product_id = '4614' ORDER BY sortorder ASC
223 0.0014 0.0013599395751953 
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '4614' AND p.id = pi.product_id ORDER BY pi.sortorder
224 0.0009 0.0009150505065918 
SELECT * FROM product_image_select WHERE product_id = '4614'
225 0.0005 0.00050711631774902 
SELECT * FROM productcustomimages WHERE product_id = '4614'
226 0.0008 0.0007932186126709 
SELECT  o.product_id, MIN(o.price) as price, p.customprice
                FROM    products        p,
                        productoffers   o
                WHERE   p.id        = o.product_id
                  AND   p.parent_id = '4614'
                GROUP BY o.product_id
227 0.0011 0.0011401176452637 
SELECT  n.displayname, o.name
                FROM    productoptionnames  n,
                        productoptions      o,
                        products            p
                WHERE   n.originalname  = o.name
                  AND   o.product_id    = p.id
                  AND   p.parent_id     = '4614'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
228 0.0006 0.00059795379638672 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 4614
229 0.0010 0.00098896026611328 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4614' AND a.name = n.originalname
230 0.0005 0.00046300888061523 
SELECT * FROM productoffers WHERE product_id = '4614' AND merchantid = 'A1X6FK5RDHNB96'
231 0.0004 0.00043797492980957 
SELECT * FROM productoffers
                WHERE product_id = '4614' AND price > 0
                ORDER BY price ASC LIMIT 1
232 0.0004 0.00040602684020996 
SELECT * FROM productoffers
                WHERE product_id = 4614
                ORDER BY price ASC LIMIT 1
233 0.0005 0.00050783157348633 
SELECT value FROM productattributes
                WHERE product_id = '4614'
                AND name = 'ListPriceAmount'
234 0.0006 0.00059103965759277 
SELECT  o.product_id, MIN(o.price) as price, p.customprice
                FROM    products        p,
                        productoffers   o
                WHERE   p.id        = o.product_id
                  AND   p.parent_id = '4614'
                GROUP BY o.product_id
235 0.0011 0.0011231899261475 
SELECT  n.displayname, o.name
                FROM    productoptionnames  n,
                        productoptions      o,
                        products            p
                WHERE   n.originalname  = o.name
                  AND   o.product_id    = p.id
                  AND   p.parent_id     = '4614'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
236 0.0006 0.00057315826416016 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 4614
237 0.0006 0.00059604644775391 
SELECT value FROM productattributes WHERE product_id = '4614' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
238 0.0009 0.00090503692626953 
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '4614'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Size'
                GROUP BY o.value
                ORDER BY o.value ASC
239 0.0008 0.00081801414489746 
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '4614'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Color'
                GROUP BY o.value
                ORDER BY o.value ASC
240 0.0005 0.00046300888061523 
SELECT * FROM products WHERE id = '3646'
241 0.0006 0.0005950927734375 
SELECT * FROM productimages WHERE product_id = '3646' ORDER BY sortorder ASC
242 0.0006 0.00063705444335938 
SELECT * FROM product_image_select WHERE product_id = '3646'
243 0.0005 0.00047612190246582 
SELECT * FROM productcustomimages WHERE product_id = '3646'
244 0.0012 0.0011670589447021 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3646' AND a.name = n.originalname
245 0.0005 0.00053191184997559 
SELECT * FROM productoffers WHERE product_id = '3646' AND merchantid = 'A1X6FK5RDHNB96'
246 0.0004 0.00044584274291992 
SELECT * FROM productoffers
                WHERE product_id = '3646' AND price > 0
                ORDER BY price ASC LIMIT 1
247 0.0004 0.00043821334838867 
SELECT * FROM productoffers
                WHERE product_id = 3646
                ORDER BY price ASC LIMIT 1
248 0.0004 0.00040888786315918 
SELECT value FROM productattributes
                WHERE product_id = '3646'
                AND name = 'ListPriceAmount'
249 0.0005 0.00049304962158203 
SELECT value FROM productattributes WHERE product_id = '3646' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
250 0.0006 0.00055480003356934 
SELECT * FROM products WHERE id = '975'
251 0.0006 0.00055098533630371 
SELECT * FROM productimages WHERE product_id = '975' ORDER BY sortorder ASC
252 0.0007 0.00067996978759766 
SELECT * FROM product_image_select WHERE product_id = '975'
253 0.0004 0.00041580200195312 
SELECT * FROM productcustomimages WHERE product_id = '975'
254 0.0009 0.00085115432739258 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '975' AND a.name = n.originalname
255 0.0006 0.0005650520324707 
SELECT * FROM productoffers WHERE product_id = '975' AND merchantid = 'A1X6FK5RDHNB96'
256 0.0005 0.00045108795166016 
SELECT * FROM productoffers
                WHERE product_id = '975' AND price > 0
                ORDER BY price ASC LIMIT 1
257 0.0004 0.00044989585876465 
SELECT value FROM productattributes WHERE product_id = '975' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
258 0.0006 0.00059199333190918 
SELECT * FROM products WHERE id = '1006'
259 0.0006 0.00055098533630371 
SELECT * FROM productimages WHERE product_id = '1006' ORDER BY sortorder ASC
260 0.0007 0.0006568431854248 
SELECT * FROM product_image_select WHERE product_id = '1006'
261 0.0004 0.00041794776916504 
SELECT * FROM productcustomimages WHERE product_id = '1006'
262 0.0013 0.0012969970703125 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1006' AND a.name = n.originalname
263 0.0006 0.00060486793518066 
SELECT * FROM productoffers WHERE product_id = '1006' AND merchantid = 'A1X6FK5RDHNB96'
264 0.0004 0.0004279613494873 
SELECT * FROM productoffers
                WHERE product_id = '1006' AND price > 0
                ORDER BY price ASC LIMIT 1
265 0.0004 0.00037908554077148 
SELECT * FROM productoffers
                WHERE product_id = 1006
                ORDER BY price ASC LIMIT 1
266 0.0005 0.00049901008605957 
SELECT value FROM productattributes
                WHERE product_id = '1006'
                AND name = 'ListPriceAmount'
267 0.0004 0.00043702125549316 
SELECT value FROM productattributes WHERE product_id = '1006' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
268 0.0006 0.00062203407287598 
SELECT * FROM products WHERE id = '1244'
269 0.0005 0.00053095817565918 
SELECT * FROM productimages WHERE product_id = '1244' ORDER BY sortorder ASC
270 0.0005 0.00048112869262695 
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '1244' AND p.id = pi.product_id ORDER BY pi.sortorder
271 0.0006 0.0006251335144043 
SELECT * FROM product_image_select WHERE product_id = '1244'
272 0.0004 0.00041007995605469 
SELECT * FROM productcustomimages WHERE product_id = '1244'
273 0.0005 0.00051498413085938 
SELECT  o.product_id, MIN(o.price) as price, p.customprice
                FROM    products        p,
                        productoffers   o
                WHERE   p.id        = o.product_id
                  AND   p.parent_id = '1244'
                GROUP BY o.product_id
274 0.0007 0.00072097778320312 
SELECT  n.displayname, o.name
                FROM    productoptionnames  n,
                        productoptions      o,
                        products            p
                WHERE   n.originalname  = o.name
                  AND   o.product_id    = p.id
                  AND   p.parent_id     = '1244'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
275 0.0005 0.00047206878662109 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 1244
276 0.0010 0.00099587440490723 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1244' AND a.name = n.originalname
277 0.0005 0.00045680999755859 
SELECT * FROM productoffers WHERE product_id = '1244' AND merchantid = 'A1X6FK5RDHNB96'
278 0.0004 0.00044798851013184 
SELECT * FROM productoffers
                WHERE product_id = '1244' AND price > 0
                ORDER BY price ASC LIMIT 1
279 0.0004 0.0004270076751709 
SELECT * FROM productoffers
                WHERE product_id = 1244
                ORDER BY price ASC LIMIT 1
280 0.0004 0.00044608116149902 
SELECT value FROM productattributes
                WHERE product_id = '1244'
                AND name = 'ListPriceAmount'
281 0.0004 0.00044512748718262 
SELECT  o.product_id, MIN(o.price) as price, p.customprice
                FROM    products        p,
                        productoffers   o
                WHERE   p.id        = o.product_id
                  AND   p.parent_id = '1244'
                GROUP BY o.product_id
282 0.0006 0.00063800811767578 
SELECT  n.displayname, o.name
                FROM    productoptionnames  n,
                        productoptions      o,
                        products            p
                WHERE   n.originalname  = o.name
                  AND   o.product_id    = p.id
                  AND   p.parent_id     = '1244'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
283 0.0004 0.00039815902709961 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 1244
284 0.0006 0.00063300132751465 
SELECT value FROM productattributes WHERE product_id = '1244' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
285 0.0005 0.00046300888061523 
SELECT * FROM products WHERE parent_id = '1244'
286 0.0006 0.00060415267944336 
SELECT * FROM products WHERE id = '939'
287 0.0005 0.00052499771118164 
SELECT * FROM productimages WHERE product_id = '939' ORDER BY sortorder ASC
288 0.0007 0.00066781044006348 
SELECT * FROM product_image_select WHERE product_id = '939'
289 0.0005 0.00047111511230469 
SELECT * FROM productcustomimages WHERE product_id = '939'
290 0.0009 0.00087094306945801 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '939' AND a.name = n.originalname
291 0.0005 0.00050497055053711 
SELECT * FROM productoffers WHERE product_id = '939' AND merchantid = 'A1X6FK5RDHNB96'
292 0.0004 0.00039887428283691 
SELECT * FROM productoffers
                WHERE product_id = '939' AND price > 0
                ORDER BY price ASC LIMIT 1
293 0.0005 0.00050902366638184 
SELECT * FROM productoffers
                WHERE product_id = 939
                ORDER BY price ASC LIMIT 1
294 0.0004 0.0004429817199707 
SELECT value FROM productattributes
                WHERE product_id = '939'
                AND name = 'ListPriceAmount'
295 0.0005 0.00050210952758789 
SELECT value FROM productattributes WHERE product_id = '939' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
296 0.0006 0.00063610076904297 
SELECT * FROM products WHERE id = '1277'
297 0.0006 0.00064277648925781 
SELECT * FROM productimages WHERE product_id = '1277' ORDER BY sortorder ASC
298 0.0008 0.00076198577880859 
SELECT * FROM product_image_select WHERE product_id = '1277'
299 0.0005 0.00046706199645996 
SELECT * FROM productcustomimages WHERE product_id = '1277'
300 0.0013 0.0012898445129395 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1277' AND a.name = n.originalname
301 0.0006 0.00055384635925293 
SELECT * FROM productoffers WHERE product_id = '1277' AND merchantid = 'A1X6FK5RDHNB96'
302 0.0005 0.0004878044128418 
SELECT * FROM productoffers
                WHERE product_id = '1277' AND price > 0
                ORDER BY price ASC LIMIT 1
303 0.0004 0.00041699409484863 
SELECT * FROM productoffers
                WHERE product_id = 1277
                ORDER BY price ASC LIMIT 1
304 0.0005 0.00045490264892578 
SELECT value FROM productattributes
                WHERE product_id = '1277'
                AND name = 'ListPriceAmount'
305 0.0005 0.00049400329589844 
SELECT value FROM productattributes WHERE product_id = '1277' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
306 0.0017 0.0017468929290771 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1267' ORDER BY timestamp DESC
307 0.0004 0.00042510032653809 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '858' ORDER BY timestamp DESC
308 0.0004 0.00036907196044922 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1159' ORDER BY timestamp DESC
309 0.0004 0.00040102005004883 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3954' ORDER BY timestamp DESC
310 0.0003 0.00033879280090332 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4766' ORDER BY timestamp DESC
311 0.0004 0.00039291381835938 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1232' ORDER BY timestamp DESC
312 0.0003 0.00032615661621094 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1164' ORDER BY timestamp DESC
313 0.0004 0.00044894218444824 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4758' ORDER BY timestamp DESC
314 0.0004 0.00035214424133301 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4756' ORDER BY timestamp DESC
315 0.0004 0.00037598609924316 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1087' ORDER BY timestamp DESC
316 0.0004 0.00036001205444336 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4011' ORDER BY timestamp DESC
317 0.0004 0.00035214424133301 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4614' ORDER BY timestamp DESC
318 0.0004 0.00035381317138672 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3646' ORDER BY timestamp DESC
319 0.0004 0.00036787986755371 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '975' ORDER BY timestamp DESC
320 0.0004 0.00037097930908203 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1006' ORDER BY timestamp DESC
321 0.0004 0.00035285949707031 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1244' ORDER BY timestamp DESC
322 0.0004 0.00036001205444336 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '939' ORDER BY timestamp DESC
323 0.0004 0.00035595893859863 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1277' ORDER BY timestamp DESC
324 0.0006 0.00063800811767578 
SELECT linktitle,pagename,ep.id,price,buylink,image FROM ebay_products ep, products_categories c
		WHERE ep.id = c.product_id
		AND c.category_id = 27
		AND c.prod_type = 'ebay'
		AND hide = 0
325 0.0006 0.00059986114501953 
SELECT value FROM parameters WHERE parameter IN('EBAY_APP_ID' , 'EBAY_TRACKING_ID','EBAY_NETWORK_ID' , 'GOOGLE_SITE_KEY' , 'GOOGLE_SECRET_KEY' ,'GOOGLE_RECAPTCHA_TYPE','EBAY_AUTH_TOKEN','EBAY_LOCALE')ORDER BY parameter ASC
326 0.0006 0.00061297416687012 
SELECT * FROM template_info WHERE templateuid = 'fsb-fluid2018'
327 0.0019 0.0018949508666992 
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_user_data'
328 0.0005 0.0005490779876709 
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_tracking_status'
329 0.0169 0.01686692237854 
SELECT p.id,p.parent_id, o.price,p.asin FROM products p, productoffers o WHERE p.id = o.product_id AND p.parent_id = 0 AND hidden = 0 AND offers > 0 AND (SELECT COUNT(pi.id) FROM productimages pi WHERE pi.product_id = p.id) > 1 AND o.id IN (SELECT x.id FROM productoffers x WHERE x.product_id = p.id HAVING MIN(x.price)) ORDER BY p.title DESC LIMIT 6
330 0.0019 0.0019011497497559 
SELECT p.id,p.price,p.listingtype FROM ebay_products p WHERE hide = 0 AND (SELECT COUNT(pi.id) FROM ebay_prod_images pi WHERE pi.prodid = p.id) > 1 ORDER BY p.title DESC LIMIT 6
331 0.0006 0.00062108039855957 
SELECT p.id,p.price,p.currency FROM custom_products p WHERE hide = 0 AND orginalprice > 0 AND (SELECT COUNT(pi.id) FROM productcustomimages pi WHERE pi.product_id = p.id) > 1 ORDER BY p.title DESC LIMIT 6
332 0.0006 0.00062704086303711 
SELECT * FROM products WHERE id = 1626
333 0.0007 0.00065493583679199 
SELECT * FROM products WHERE id = 4041
334 0.0006 0.00059318542480469 
SELECT * FROM products WHERE id = 4312
335 0.0006 0.00062203407287598 
SELECT * FROM products WHERE id = 777
336 0.0006 0.00063204765319824 
SELECT * FROM products WHERE id = 3881
337 0.0006 0.00059795379638672 
SELECT * FROM products WHERE id = 4213
338 0.0007 0.0007169246673584 
SELECT * FROM products WHERE id = '1626'
339 0.0005 0.00051403045654297 
SELECT * FROM productimages WHERE product_id = '1626' ORDER BY sortorder ASC
340 0.0007 0.00066685676574707 
SELECT * FROM product_image_select WHERE product_id = '1626'
341 0.0005 0.0004889965057373 
SELECT * FROM productcustomimages WHERE product_id = '1626'
342 0.0010 0.0010151863098145 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1626' AND a.name = n.originalname
343 0.0006 0.00058102607727051 
SELECT * FROM productoffers WHERE product_id = '1626' AND merchantid = 'A1X6FK5RDHNB96'
344 0.0006 0.00063705444335938 
SELECT * FROM productoffers
                WHERE product_id = '1626' AND price > 0
                ORDER BY price ASC LIMIT 1
345 0.0006 0.00058293342590332 
SELECT value FROM productattributes WHERE product_id = '1626' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
346 0.0007 0.00072407722473145 
SELECT * FROM products WHERE id = '4041'
347 0.0006 0.0005648136138916 
SELECT * FROM productimages WHERE product_id = '4041' ORDER BY sortorder ASC
348 0.0009 0.00085115432739258 
SELECT * FROM product_image_select WHERE product_id = '4041'
349 0.0005 0.0004889965057373 
SELECT * FROM productcustomimages WHERE product_id = '4041'
350 0.0013 0.0013041496276855 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4041' AND a.name = n.originalname
351 0.0006 0.0005800724029541 
SELECT * FROM productoffers WHERE product_id = '4041' AND merchantid = 'A1X6FK5RDHNB96'
352 0.0006 0.00059199333190918 
SELECT * FROM productoffers
                WHERE product_id = '4041' AND price > 0
                ORDER BY price ASC LIMIT 1
353 0.0006 0.00055217742919922 
SELECT value FROM productattributes WHERE product_id = '4041' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
354 0.0007 0.00066900253295898 
SELECT * FROM products WHERE id = '4312'
355 0.0006 0.00063300132751465 
SELECT * FROM productimages WHERE product_id = '4312' ORDER BY sortorder ASC
356 0.0007 0.00073099136352539 
SELECT * FROM product_image_select WHERE product_id = '4312'
357 0.0006 0.00055098533630371 
SELECT * FROM productcustomimages WHERE product_id = '4312'
358 0.0012 0.0012130737304688 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4312' AND a.name = n.originalname
359 0.0006 0.00060606002807617 
SELECT * FROM productoffers WHERE product_id = '4312' AND merchantid = 'A1X6FK5RDHNB96'
360 0.0007 0.00068283081054688 
SELECT * FROM productoffers
                WHERE product_id = '4312' AND price > 0
                ORDER BY price ASC LIMIT 1
361 0.0006 0.00055980682373047 
SELECT value FROM productattributes WHERE product_id = '4312' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
362 0.0007 0.00074601173400879 
SELECT * FROM products WHERE id = '777'
363 0.0007 0.00071310997009277 
SELECT * FROM productimages WHERE product_id = '777' ORDER BY sortorder ASC
364 0.0008 0.00077199935913086 
SELECT * FROM product_image_select WHERE product_id = '777'
365 0.0005 0.00051617622375488 
SELECT * FROM productcustomimages WHERE product_id = '777'
366 0.0012 0.001237154006958 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '777' AND a.name = n.originalname
367 0.0008 0.00076198577880859 
SELECT * FROM productoffers WHERE product_id = '777' AND merchantid = 'A1X6FK5RDHNB96'
368 0.0006 0.00058412551879883 
SELECT * FROM productoffers
                WHERE product_id = '777' AND price > 0
                ORDER BY price ASC LIMIT 1
369 0.0012 0.0012130737304688 
SELECT value FROM productattributes WHERE product_id = '777' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
370 0.0012 0.0011789798736572 
SELECT * FROM products WHERE id = '3881'
371 0.0014 0.0013530254364014 
SELECT * FROM productimages WHERE product_id = '3881' ORDER BY sortorder ASC
372 0.0017 0.0017080307006836 
SELECT * FROM product_image_select WHERE product_id = '3881'
373 0.0010 0.00099396705627441 
SELECT * FROM productcustomimages WHERE product_id = '3881'
374 0.0030 0.0030031204223633 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3881' AND a.name = n.originalname
375 0.0011 0.0011088848114014 
SELECT * FROM productoffers WHERE product_id = '3881' AND merchantid = 'A1X6FK5RDHNB96'
376 0.0010 0.00095009803771973 
SELECT * FROM productoffers
                WHERE product_id = '3881' AND price > 0
                ORDER BY price ASC LIMIT 1
377 0.0010 0.0010190010070801 
SELECT value FROM productattributes WHERE product_id = '3881' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
378 0.0012 0.0012280941009521 
SELECT * FROM products WHERE id = '4213'
379 0.0011 0.0011229515075684 
SELECT * FROM productimages WHERE product_id = '4213' ORDER BY sortorder ASC
380 0.0017 0.001662015914917 
SELECT * FROM product_image_select WHERE product_id = '4213'
381 0.0009 0.00089502334594727 
SELECT * FROM productcustomimages WHERE product_id = '4213'
382 0.0014 0.0013761520385742 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4213' AND a.name = n.originalname
383 0.0006 0.00063419342041016 
SELECT * FROM productoffers WHERE product_id = '4213' AND merchantid = 'A1X6FK5RDHNB96'
384 0.0005 0.00053691864013672 
SELECT * FROM productoffers
                WHERE product_id = '4213' AND price > 0
                ORDER BY price ASC LIMIT 1
385 0.0005 0.00054383277893066 
SELECT value FROM productattributes WHERE product_id = '4213' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
386 0.0026 0.0025770664215088 
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'header' ORDER BY sortorder ASC
387 0.0010 0.0009610652923584 
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'footer' ORDER BY sortorder ASC
388 0.0032 0.0032439231872559 
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND skinuid = ''
389 0.0022 0.0022339820861816 
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
390 0.0009 0.00093197822570801 
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
391 0.0009 0.00089907646179199 
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid2018' AND imageuid = 'FB_DEFAULT_SHARE_IMAGE'
392 0.0013 0.001305103302002 
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid2018' AND imageuid = 'HEAD_LOGO'