Shower Caddy - Waterproof Mesh Storage Tote Bag Organizer Eight (8) Pocket Gift

Price: $19.99
Availability: Not Available Discontinued
CERTAIN CONTENT THAT APPEARS ON THIS SITE COMES FROM AMAZON SERVICES LLC. THIS CONTENT IS PROVIDED 'AS IS' AND IS SUBJECT TO CHANGE OR REMOVAL AT ANY TIME.

Product Features

Multi-purpose: Use for College Dorm Blue Shower Caddy, Gym toiletires, Garden tools, Bath or Beach toys, Garage car wash cleaning supplies, Workbench tools, Arts and Crafts, Picnic, or Household Chores Large Main Pocket with 6 narrow plus 2 wide side compartments. Lightweight High Quality Construction - Designed for frequent use. Place on shower head, handle or counter top Perfect for Shared, Community Bathroom Settings or Overnight Stays - Easy to Maintain Portable Bag, rugged stitched handle design Comfortable Longer Carry Handle Strap: Washing machine safe plastic nylon, Spacious center compartment, Holds up to 18 lbs Perfect gift for high school or college student, husband, gardener, military, swimmer, etc.

Debug Overview

App Total Time DB Queries DB Query Total Time Amazon Requests
0.46705889701843 267 0.0790 0


No Amazon API Requests Made.


App Debug - Total Time 0.46705889701843 seconds

Number Time From Start Name Description
1 0.3705050945282 Initialise Initialise FSB Function
2 0.37138891220093 App Controller Start Start of the App controller (called before the controller of every page)
3 0.37601590156555 Start of getCategoryListByGroup Function Before first category groups query
4 0.37617301940918 After initial query Before first category groups query
5 0.3761739730835 Get Category List for Group Before the call to getCategoryList function
6 0.37617588043213 Start of GetCategoryList function Start of the function
7 0.37617802619934 Before getting categories Query to get specific category list
8 0.37636804580688 After getting categories Query to get specific category list
9 0.3763689994812 Before getting category custom Before call to function getCategoryCustom
10 0.37784290313721 After getting category custom After call to function getCategoryCustom
11 0.37784790992737 Before getting category custom Before call to function getCategoryCustom
12 0.37905502319336 After getting category custom After call to function getCategoryCustom
13 0.37905597686768 Before getting category custom Before call to function getCategoryCustom
14 0.38032102584839 After getting category custom After call to function getCategoryCustom
15 0.38032293319702 Before getting category custom Before call to function getCategoryCustom
16 0.38138604164124 After getting category custom After call to function getCategoryCustom
17 0.38138699531555 End of GetCategoryList function End of the function
18 0.38139009475708 Get Category List for Group Before the call to getCategoryList function
19 0.38139200210571 Start of GetCategoryList function Start of the function
20 0.38139295578003 Before getting categories Query to get specific category list
21 0.381511926651 End of getCategoryListByGroup Function Before return()
22 0.41357088088989 App Controller End End of the App controller (called before the controller of every page)
23 0.41446304321289 Product Start Start of the product info controller
24 0.41518402099609 Cache file not found Starting get product details
25 0.42211604118347 Related products Start getting related products if enabled
26 0.42211699485779 Related Products Start Before the related products are found
27 0.42211699485779 Related Products Keywords Before the related product keywords are found
28 0.42212009429932 Create Keyword List Function Start of function
29 0.422199010849 Create Keyword List Function After looping provided content - 33 keywords found
30 0.42311692237854 Create Keyword List Function After looping initial keyword list - 31 keywords remaining
31 0.42312908172607 Create Keyword List Function After reducing keyword list
32 0.42318892478943 Create Keyword List Function After selecting by scoring keywords
33 0.42319107055664 Create Keyword List Function After final loop of keywords
34 0.42319297790527 Related Products Keywords After the related product keywords are found
35 0.43408608436584 Related Products End After the related products are found
36 0.43840599060059 Product End End of the product info controller (Product Info)
37 0.43893194198608 App_after Controller Start Start of the App_after controller (called after the controller of every page)
38 0.43920993804932 Before Get Options Before the call to getOptions in the tpl class
39 0.45488500595093 After Get Options After the call to getOptions in the tpl class
40 0.4550039768219 App_after Controller End End of the App_after controller (called after the controller of every page)
41 0.45502400398254 Product Info: Before Smarty Fetch Before the product.tpl template is fetched
42 0.45961999893188 Product Info: After Smarty Fetch After the product.tpl template is fetched
43 0.45962309837341 Product Info: Before Template Display Before the template is displayed
44 0.46704292297363 Product Info: After Template Display After the template is displayed
45 0.46704888343811 Finalizing debug Before the debug is output to the page.
46 0.46705889701843 End of App This is the end of the app logging, final timestamp


Query Debug - 267 Database Queries. Total time 0.0790 seconds

Number Time (Seconds) Time (Milliseconds) Query
1 0.0002 0.0002140998840332
SELECT parameter, value FROM parameters
2 0.0004 0.00036287307739258
SELECT * FROM `bad_bots`
3 0.0002 0.00015997886657715
SET time_zone = 'Europe/London'
4 0.0002 0.00020289421081543
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
5 0.0003 0.00034213066101074
INSERT INTO ga_users (`isbot`, `ips`) SELECT '1', 'a:1:{i:0;s:13:\"44.200.74.241\";}'
6 0.0007 0.00066494941711426
INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1653685701'
7 0.0004 0.00035595893859863
SELECT * FROM autorun ORDER BY lastrun ASC
8 0.0001 0.00013995170593262
SELECT * FROM version ORDER BY installed DESC LIMIT 1
9 0.0002 0.00021195411682129
SELECT id FROM pages WHERE pagename = 'shower-caddy-waterproof-mesh-storage-tote-bag-organizer-eight-8' LIMIT 1
10 0.0002 0.00024008750915527
SELECT id FROM products WHERE pagename = 'shower-caddy-waterproof-mesh-storage-tote-bag-organizer-eight-8' AND hidden = 0 LIMIT 1
11 0.0004 0.00035309791564941
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-fluid'
12 0.0037 0.0037269592285156
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-fluid' AND language = 'en'
13 0.0001 0.00014495849609375
SELECT * FROM pages WHERE pagename = 'shower-caddy-waterproof-mesh-storage-tote-bag-organizer-eight-8'
14 0.0001 0.00014686584472656
SELECT * FROM categorygroups ORDER BY sortorder ASC
15 0.0002 0.00017690658569336
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
16 0.0003 0.00027990341186523
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
17 0.0002 0.00016498565673828
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 27
18 0.0001 0.00012803077697754
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
19 0.0001 8.392333984375E-5
SELECT id FROM categories WHERE parent_id = '27'
20 0.0002 0.00022792816162109
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 
21 0.0001 0.00013399124145508
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 
22 0.0001 0.00014901161193848
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
23 0.0001 0.00011801719665527
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
24 0.0001 8.702278137207E-5
SELECT * FROM categorygroups WHERE id = '1'
25 0.0003 0.00025701522827148
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
26 0.0001 0.00010204315185547
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 29
27 0.0001 7.2002410888672E-5
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
28 0.0001 8.2969665527344E-5
SELECT id FROM categories WHERE parent_id = '29'
29 0.0003 0.00025200843811035
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 
30 0.0001 8.5115432739258E-5
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 
31 0.0001 9.7990036010742E-5
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
32 0.0001 7.3909759521484E-5
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
33 0.0001 8.392333984375E-5
SELECT * FROM categorygroups WHERE id = '1'
34 0.0003 0.00028300285339355
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
35 0.0001 9.7990036010742E-5
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 30
36 0.0001 7.2002410888672E-5
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
37 0.0001 8.2015991210938E-5
SELECT id FROM categories WHERE parent_id = '30'
38 0.0003 0.00028800964355469
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 
39 0.0001 9.7036361694336E-5
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 
40 0.0001 0.00010514259338379
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
41 0.0001 7.2956085205078E-5
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
42 0.0001 8.392333984375E-5
SELECT * FROM categorygroups WHERE id = '1'
43 0.0002 0.00017905235290527
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 = 38
44 0.0001 9.7036361694336E-5
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 38
45 0.0001 7.2002410888672E-5
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 38
46 0.0001 8.1062316894531E-5
SELECT id FROM categories WHERE parent_id = '38'
47 0.0002 0.00020503997802734
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (38)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
48 0.0001 8.392333984375E-5
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (38)
				  AND p.disabled = 0 
49 0.0001 9.918212890625E-5
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (38)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
50 0.0001 7.2956085205078E-5
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '38'
51 0.0001 8.392333984375E-5
SELECT * FROM categorygroups WHERE id = '1'
52 0.0001 0.00011014938354492
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '2'  AND hidden = 0 ORDER BY sortorder ASC
53 0.0005 0.0005028247833252
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
54 0.0002 0.00020408630371094
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-fluid' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
55 0.0002 0.00017404556274414
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
56 0.0002 0.00020599365234375
SELECT value FROM template_options WHERE templateuid = 'fsb-fluid' AND optionuid = 'DISPLAY_CREDIT_ICON'
57 0.0003 0.00032711029052734
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
58 0.0294 0.029381036758423
SELECT * FROM ipgeocountries WHERE INET_ATON('44.200.74.241') >= INET_ATON(ip_start) AND INET_ATON('44.200.74.241') <= INET_ATON(ip_end)
59 0.0003 0.00025820732116699
SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
60 0.0001 0.00014114379882812
SELECT * FROM countryredirects WHERE countrycode = 'US'
61 0.0002 0.00019288063049316
SELECT * FROM products WHERE pagename = 'shower-caddy-waterproof-mesh-storage-tote-bag-organizer-eight-8'
62 0.0002 0.00016093254089355
UPDATE products SET viewcount = viewcount + 1 WHERE id = 4252
63 0.0001 0.00011992454528809
SELECT * FROM manufacturers WHERE id = '169'
64 0.0002 0.00019192695617676
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '169'
65 0.0001 0.00012493133544922
SELECT filename FROM manufacturerimages WHERE manufacturer_id = '169' LIMIT 1
66 0.0003 0.00029802322387695
SELECT p.pagename, p.id FROM products p, productimages i WHERE p.id = i.product_id AND manufacturer_id = '169' ORDER BY RAND() LIMIT 1
67 0.0006 0.0006258487701416
SELECT * FROM productimages WHERE product_id = '735' ORDER BY sortorder ASC
68 0.0002 0.00015616416931152
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '169'
69 0.0002 0.00018310546875
SELECT COUNT(DISTINCT(p.id)) FROM products p
				WHERE p.manufacturer_id = '169'
				  AND p.hidden = 0
				  AND p.enabled = 1
				  AND p.parent_id = 0 
70 0.0001 7.3909759521484E-5
SELECT * FROM manufacturerimages WHERE manufacturer_id = '169'
71 0.0001 9.7036361694336E-5
SELECT category_id FROM products_categories WHERE product_id = '4252'
72 0.0001 0.00010013580322266
SELECT * FROM categories WHERE id = '29'
73 0.0002 0.00023317337036133
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.0001 7.2002410888672E-5
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
75 0.0001 7.9870223999023E-5
SELECT id FROM categories WHERE parent_id = '29'
76 0.0002 0.00024700164794922
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 
77 0.0001 9.0122222900391E-5
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 
78 0.0001 0.0001070499420166
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
79 0.0001 7.1048736572266E-5
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
80 0.0002 0.0001521110534668
SELECT * FROM productimages WHERE product_id = '4252' ORDER BY sortorder ASC
81 0.0002 0.00018095970153809
SELECT * FROM product_image_select WHERE product_id = '4252'
82 0.0001 0.00014305114746094
SELECT * FROM productcustomimages WHERE product_id = '4252'
83 0.0001 0.0001380443572998
SELECT * FROM productfeeds WHERE product_id = '4252' ORDER BY item_date DESC
84 0.0002 0.00023102760314941
SELECT a.name, n.displayname, a.value, n.units, n.valuetype FROM productattributes a, productattributenames n WHERE product_id = '4252' AND a.name = n.originalname AND n.display = 1 AND n.hidden = 0
85 0.0004 0.00043201446533203
SELECT DISTINCT(pt.tag_id) FROM product_tags pt, tags t WHERE pt.tag_id = t.id AND pt.product_id = '4252' AND t.hidden = 0 AND display_product = 1
86 0.0008 0.00082588195800781
SELECT * FROM productamazoncontent WHERE product_id = '4252'
87 0.0005 0.0005180835723877
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4252' AND a.name = n.originalname
88 0.0001 0.00014591217041016
SELECT * FROM productoffers WHERE product_id = '4252' AND merchantid = 'ATVPDKIKX0DER'
89 0.0001 0.00011086463928223
SELECT * FROM productoffers
                WHERE product_id = '4252' AND price > 0
                ORDER BY price ASC LIMIT 1
90 0.0001 0.00011897087097168
SELECT * FROM productoffers
                WHERE product_id = 4252
                ORDER BY price ASC LIMIT 1
91 0.0001 0.00011396408081055
SELECT value FROM productattributes
                WHERE product_id = '4252'
                AND name = 'ListPriceAmount'
92 0.0002 0.0001528263092041
SELECT value FROM productattributes WHERE product_id = '4252' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
93 0.0002 0.00018405914306641
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
94 0.0008 0.00083112716674805
SELECT *, MATCH (description, title) AGAINST ('bag organizer eight' IN BOOLEAN MODE) AS `searchrelevance` FROM products WHERE MATCH (description, title) AGAINST ('bag organizer eight' IN BOOLEAN MODE) AND 4252 <> 0 AND enabled = 1 AND hidden = 0 AND offers > 0 AND parent_id = 0 ORDER BY `searchrelevance` LIMIT 3
95 0.0002 0.00016188621520996
SELECT *, MATCH (description, title) AGAINST ('bag organizer eight' IN BOOLEAN MODE) AS `searchrelevance` FROM ebay_products WHERE MATCH (description, title) AGAINST ('bag organizer eight' IN BOOLEAN MODE) AND 4252 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 3
96 0.0001 0.00012898445129395
SELECT *, MATCH (description, title) AGAINST ('bag organizer eight' IN BOOLEAN MODE) AS `searchrelevance` FROM custom_products WHERE MATCH (description, title) AGAINST ('bag organizer eight' IN BOOLEAN MODE) AND 4252 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 3
97 0.0008 0.00075721740722656
SELECT *, MATCH (description, title) AGAINST ('shower caddy waterproof' IN BOOLEAN MODE) AS `searchrelevance` FROM products WHERE MATCH (description, title) AGAINST ('shower caddy waterproof' IN BOOLEAN MODE) AND 4252 <> 0 AND enabled = 1 AND hidden = 0 AND offers > 0 AND parent_id = 0 ORDER BY `searchrelevance` LIMIT 3
98 0.0001 0.00013899803161621
SELECT *, MATCH (description, title) AGAINST ('shower caddy waterproof' IN BOOLEAN MODE) AS `searchrelevance` FROM ebay_products WHERE MATCH (description, title) AGAINST ('shower caddy waterproof' IN BOOLEAN MODE) AND 4252 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 3
99 0.0001 0.0001220703125
SELECT *, MATCH (description, title) AGAINST ('shower caddy waterproof' IN BOOLEAN MODE) AS `searchrelevance` FROM custom_products WHERE MATCH (description, title) AGAINST ('shower caddy waterproof' IN BOOLEAN MODE) AND 4252 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 3
100 0.0001 0.00012302398681641
SELECT * FROM productimages WHERE product_id = '7855' ORDER BY sortorder ASC
101 0.0001 0.0001370906829834
SELECT * FROM product_image_select WHERE product_id = '7855'
102 0.0001 0.00010108947753906
SELECT * FROM productcustomimages WHERE product_id = '7855'
103 0.0007 0.00066685676574707
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '7855' AND a.name = n.originalname
104 0.0001 0.00011014938354492
SELECT * FROM productoffers WHERE product_id = '7855' AND merchantid = 'ATVPDKIKX0DER'
105 0.0001 0.00012397766113281
SELECT * FROM productoffers
                WHERE product_id = '7855' AND price > 0
                ORDER BY price ASC LIMIT 1
106 0.0001 0.0001380443572998
SELECT value FROM productattributes WHERE product_id = '7855' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
107 0.0007 0.00072884559631348
SELECT *, MATCH (description, title) AGAINST ('waterproof mesh storage' IN BOOLEAN MODE) AS `searchrelevance` FROM products WHERE MATCH (description, title) AGAINST ('waterproof mesh storage' IN BOOLEAN MODE) AND 4252 <> 0 AND enabled = 1 AND hidden = 0 AND offers > 0 AND parent_id = 0 ORDER BY `searchrelevance` LIMIT 2
108 0.0001 0.0001380443572998
SELECT *, MATCH (description, title) AGAINST ('waterproof mesh storage' IN BOOLEAN MODE) AS `searchrelevance` FROM ebay_products WHERE MATCH (description, title) AGAINST ('waterproof mesh storage' IN BOOLEAN MODE) AND 4252 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 2
109 0.0001 0.00014114379882812
SELECT *, MATCH (description, title) AGAINST ('waterproof mesh storage' IN BOOLEAN MODE) AS `searchrelevance` FROM custom_products WHERE MATCH (description, title) AGAINST ('waterproof mesh storage' IN BOOLEAN MODE) AND 4252 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 2
110 0.0002 0.00023508071899414
SELECT categories.id, COUNT(*) as productcount FROM products_categories, categories WHERE categories.id IN (SELECT category_id FROM products_categories WHERE product_id = '4252') AND products_categories.category_id = categories.id GROUP BY categories.id ORDER BY productcount ASC
111 0.0006 0.00062417984008789
SELECT p.* FROM products p, products_categories pc WHERE p.parent_id = 0 AND p.id = pc.product_id AND pc.category_id = '29' AND pc.prod_type = 'amz'  AND p.id <> '4252' ORDER BY RAND()
112 0.0001 0.00014591217041016
SELECT p.* FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND pc.category_id = '29' AND pc.prod_type = 'ebay' AND p.id <> '4252' ORDER BY RAND()
113 0.0001 0.00011515617370605
SELECT p.* FROM custom_products p, products_categories pc WHERE p.id = pc.product_id AND pc.category_id = '29' AND pc.prod_type = 'custom' AND p.id <> '4252' ORDER BY RAND()
114 0.0003 0.00034689903259277
SELECT * FROM productimages WHERE product_id = '765' ORDER BY sortorder ASC
115 0.0001 0.00014805793762207
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '765' AND p.id = pi.product_id ORDER BY pi.sortorder
116 0.0001 0.0001368522644043
SELECT * FROM product_image_select WHERE product_id = '765'
117 0.0001 0.00011301040649414
SELECT * FROM productcustomimages WHERE product_id = '765'
118 0.0002 0.00016021728515625
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 = '765'
                GROUP BY o.product_id
119 0.0003 0.00026893615722656
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     = '765'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
120 0.0001 0.00012993812561035
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 765
121 0.0002 0.0001838207244873
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '765' AND a.name = n.originalname
122 0.0001 0.00011682510375977
SELECT * FROM productoffers WHERE product_id = '765' AND merchantid = 'ATVPDKIKX0DER'
123 0.0001 0.00011706352233887
SELECT * FROM productoffers
                WHERE product_id = '765' AND price > 0
                ORDER BY price ASC LIMIT 1
124 0.0001 9.7990036010742E-5
SELECT * FROM productoffers
                WHERE product_id = 765
                ORDER BY price ASC LIMIT 1
125 0.0001 0.00010895729064941
SELECT value FROM productattributes
                WHERE product_id = '765'
                AND name = 'ListPriceAmount'
126 0.0002 0.00016498565673828
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 = '765'
                GROUP BY o.product_id
127 0.0002 0.00019001960754395
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     = '765'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
128 0.0001 0.00012493133544922
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 765
129 0.0001 0.00013995170593262
SELECT value FROM productattributes WHERE product_id = '765' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
130 0.0002 0.00018000602722168
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '765'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Color'
                GROUP BY o.value
                ORDER BY o.value ASC
131 0.0001 0.00011205673217773
SELECT * FROM productimages WHERE product_id = '828' ORDER BY sortorder ASC
132 0.0001 0.00013518333435059
SELECT * FROM product_image_select WHERE product_id = '828'
133 0.0001 9.7990036010742E-5
SELECT * FROM productcustomimages WHERE product_id = '828'
134 0.0008 0.00082516670227051
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '828' AND a.name = n.originalname
135 0.0001 9.9897384643555E-5
SELECT * FROM productoffers WHERE product_id = '828' AND merchantid = 'ATVPDKIKX0DER'
136 0.0001 0.0001070499420166
SELECT * FROM productoffers
                WHERE product_id = '828' AND price > 0
                ORDER BY price ASC LIMIT 1
137 0.0001 0.00010180473327637
SELECT * FROM productoffers
                WHERE product_id = 828
                ORDER BY price ASC LIMIT 1
138 0.0001 0.00011301040649414
SELECT value FROM productattributes
                WHERE product_id = '828'
                AND name = 'ListPriceAmount'
139 0.0001 0.00014615058898926
SELECT value FROM productattributes WHERE product_id = '828' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
140 0.0001 8.392333984375E-5
SELECT id,asin FROM products WHERE parent_id = 4252
141 0.0001 8.392333984375E-5
SELECT category_id FROM products_categories WHERE product_id = '4252'
142 0.0001 9.3936920166016E-5
SELECT * FROM categories WHERE id = '29'
143 0.0002 0.00023007392883301
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
144 0.0001 6.9856643676758E-5
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
145 0.0001 7.7962875366211E-5
SELECT id FROM categories WHERE parent_id = '29'
146 0.0003 0.00025391578674316
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 
147 0.0001 9.4890594482422E-5
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 
148 0.0001 9.4890594482422E-5
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
149 0.0001 7.0095062255859E-5
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
150 0.0003 0.00028896331787109
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4252' AND a.name = n.originalname
151 0.0001 9.7036361694336E-5
SELECT * FROM productoffers WHERE product_id = '4252' AND merchantid = 'ATVPDKIKX0DER'
152 0.0001 0.00010585784912109
SELECT * FROM productoffers
                WHERE product_id = '4252' AND price > 0
                ORDER BY price ASC LIMIT 1
153 0.0001 0.00010895729064941
SELECT * FROM productoffers
                WHERE product_id = 4252
                ORDER BY price ASC LIMIT 1
154 0.0001 0.00011801719665527
SELECT value FROM productattributes
                WHERE product_id = '4252'
                AND name = 'ListPriceAmount'
155 0.0001 0.00011491775512695
SELECT * FROM products WHERE id = '4252'
156 0.0001 0.00012993812561035
SELECT value FROM productattributes WHERE product_id = '4252' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
157 0.0003 0.00028705596923828
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4252' AND a.name = n.originalname
158 0.0001 9.608268737793E-5
SELECT * FROM productoffers WHERE product_id = '4252' AND merchantid = 'ATVPDKIKX0DER'
159 0.0001 0.00010514259338379
SELECT * FROM productoffers
                WHERE product_id = '4252' AND price > 0
                ORDER BY price ASC LIMIT 1
160 0.0001 0.00010991096496582
SELECT * FROM productoffers
                WHERE product_id = 4252
                ORDER BY price ASC LIMIT 1
161 0.0001 0.00011801719665527
SELECT value FROM productattributes
                WHERE product_id = '4252'
                AND name = 'ListPriceAmount'
162 0.0001 8.9883804321289E-5
SELECT category_id FROM products_categories WHERE product_id = '4252' AND prod_type = 'amz'
163 0.0001 7.7009201049805E-5
SELECT parent_id FROM categories WHERE id = '29'
164 0.0001 9.0122222900391E-5
SELECT * FROM categories WHERE id = '29'
165 0.0002 0.00022506713867188
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
166 0.0001 6.7949295043945E-5
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
167 0.0001 7.7009201049805E-5
SELECT id FROM categories WHERE parent_id = '29'
168 0.0003 0.00025796890258789
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 
169 0.0001 8.392333984375E-5
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 
170 0.0001 9.2983245849609E-5
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
171 0.0001 6.9141387939453E-5
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
172 0.0001 0.00014901161193848
SELECT * FROM template_info WHERE templateuid = 'fsb-fluid'
173 0.0001 0.00013303756713867
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_user_data'
174 0.0001 8.7976455688477E-5
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_tracking_status'
175 0.0001 0.00010085105895996
SELECT * FROM pages WHERE id = 38
176 0.0001 9.1075897216797E-5
SELECT * FROM categories WHERE id = '27'
177 0.0002 0.00018191337585449
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
178 0.0001 6.9856643676758E-5
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
179 0.0001 7.7962875366211E-5
SELECT id FROM categories WHERE parent_id = '27'
180 0.0002 0.00020599365234375
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 
181 0.0001 9.2983245849609E-5
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 
182 0.0001 9.608268737793E-5
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
183 0.0001 6.9856643676758E-5
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
184 0.0002 0.00017118453979492
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
185 0.0001 6.8187713623047E-5
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
186 0.0002 0.00018692016601562
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 
187 0.0001 8.1062316894531E-5
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 
188 0.0001 0.0001070499420166
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
189 0.0001 7.6055526733398E-5
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
190 0.0001 7.7009201049805E-5
SELECT id FROM categories WHERE parent_id = '27'
191 0.0002 0.00020289421081543
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
192 0.0001 0.00011801719665527
SELECT * FROM productimages WHERE product_id = '819' ORDER BY sortorder ASC
193 0.0001 0.00012111663818359
SELECT * FROM categoryimages WHERE category_id = 27
194 0.0001 8.3208084106445E-5
SELECT * FROM categorygroups WHERE id = '1'
195 0.0002 0.00020813941955566
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
196 0.0001 8.9883804321289E-5
SELECT * FROM categories WHERE id = '30'
197 0.0003 0.0002748966217041
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
198 0.0001 6.8187713623047E-5
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
199 0.0001 7.7009201049805E-5
SELECT id FROM categories WHERE parent_id = '30'
200 0.0003 0.00028109550476074
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 
201 0.0001 8.2969665527344E-5
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 
202 0.0001 0.00010585784912109
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
203 0.0001 7.5101852416992E-5
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
204 0.0003 0.00026202201843262
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
205 0.0001 6.6995620727539E-5
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
206 0.0003 0.00027704238891602
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 
207 0.0001 7.8916549682617E-5
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 
208 0.0001 9.2029571533203E-5
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
209 0.0002 0.00018596649169922
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
210 0.0001 7.7962875366211E-5
SELECT id FROM categories WHERE parent_id = '30'
211 0.0003 0.00029397010803223
SELECT p.id FROM products p, products_categories c WHERE p.id = c.product_id AND c.category_id IN (30) AND p.hidden = 0 AND p.salesrank > 0 AND (p.price > 0 OR p.parent = 1) ORDER BY p.salesrank ASC LIMIT 1
212 0.0001 0.00012803077697754
SELECT * FROM productimages WHERE product_id = '785' ORDER BY sortorder ASC
213 0.0001 7.9154968261719E-5
SELECT * FROM categoryimages WHERE category_id = 30
214 0.0001 8.0108642578125E-5
SELECT * FROM categorygroups WHERE id = '1'
215 0.0003 0.0003058910369873
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 = '30'
		  AND p.offers > 0
		  AND p.hidden = 0
		  AND p.enabled = 1
		  AND p.parent = 0
		  AND p.price > 0
216 0.0001 9.608268737793E-5
SELECT * FROM pages WHERE id = 59
217 0.0001 9.7036361694336E-5
SELECT * FROM pages WHERE id = 55
218 0.0001 0.00014090538024902
SELECT DISTINCT p.id FROM products p, productoffers o
            WHERE p.id IN (SELECT DISTINCT(pc.product_id) FROM products_categories pc WHERE pc.product_id = p.id AND pc.category_id IN (32)) AND p.parent_id = 0
219 0.0006 0.00055789947509766
UPDATE template_options SET value = 'a:11:{s:14:\"populationtype\";s:9:\"automatic\";s:12:\"productcount\";s:0:\"\";s:12:\"maxsalesrank\";s:0:\"\";s:8:\"minprice\";s:1:\"0\";s:8:\"maxprice\";s:1:\"0\";s:9:\"minimages\";s:0:\"\";s:10:\"categories\";a:1:{i:0;s:2:\"32\";}s:10:\"updatetime\";s:1:\"0\";s:13:\"selectiontype\";s:6:\"random\";s:11:\"lastupdated\";i:1653685701;s:8:\"products\";a:0:{}}' WHERE id = '8'
220 0.0002 0.00024795532226562
SELECT DISTINCT p.id FROM products p, productoffers o
            WHERE p.id IN (SELECT DISTINCT(pc.product_id) FROM products_categories pc WHERE pc.product_id = p.id AND pc.category_id IN (38)) AND p.parent_id = 0 LIMIT 3
221 0.0001 0.00011491775512695
UPDATE template_options SET value = 'a:10:{s:14:\"populationtype\";s:9:\"automatic\";s:12:\"productcount\";s:1:\"3\";s:12:\"maxsalesrank\";s:0:\"\";s:8:\"minprice\";s:1:\"0\";s:8:\"maxprice\";s:1:\"0\";s:9:\"minimages\";s:0:\"\";s:10:\"categories\";a:1:{i:0;s:2:\"38\";}s:13:\"selectiontype\";s:6:\"random\";s:11:\"lastupdated\";i:1653685701;s:8:\"products\";a:3:{i:0;s:11:\"7004|amazon\";i:1;s:11:\"7011|amazon\";i:2;s:11:\"7045|amazon\";}}' WHERE id = '16'
222 0.0001 0.00012111663818359
SELECT * FROM products WHERE id = 7004
223 0.0001 0.00011205673217773
SELECT * FROM products WHERE id = 7011
224 0.0001 0.00011181831359863
SELECT * FROM products WHERE id = 7045
225 0.0001 0.00011205673217773
SELECT * FROM products WHERE id = '7004'
226 0.0001 0.00012707710266113
SELECT * FROM productimages WHERE product_id = '7004' ORDER BY sortorder ASC
227 0.0001 0.0001370906829834
SELECT * FROM product_image_select WHERE product_id = '7004'
228 0.0001 0.00010991096496582
SELECT * FROM productcustomimages WHERE product_id = '7004'
229 0.0005 0.00049901008605957
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '7004' AND a.name = n.originalname
230 0.0001 0.00010490417480469
SELECT * FROM productoffers WHERE product_id = '7004' AND merchantid = 'ATVPDKIKX0DER'
231 0.0001 0.00011801719665527
SELECT * FROM productoffers
                WHERE product_id = '7004' AND price > 0
                ORDER BY price ASC LIMIT 1
232 0.0002 0.00015592575073242
SELECT value FROM productattributes WHERE product_id = '7004' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
233 0.0001 0.00011515617370605
SELECT * FROM products WHERE id = '7011'
234 0.0001 0.0001070499420166
SELECT * FROM productimages WHERE product_id = '7011' ORDER BY sortorder ASC
235 0.0001 0.00013518333435059
SELECT * FROM product_image_select WHERE product_id = '7011'
236 0.0001 0.00010895729064941
SELECT * FROM productcustomimages WHERE product_id = '7011'
237 0.0006 0.00055909156799316
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '7011' AND a.name = n.originalname
238 0.0001 9.8943710327148E-5
SELECT * FROM productoffers WHERE product_id = '7011' AND merchantid = 'ATVPDKIKX0DER'
239 0.0001 0.0001068115234375
SELECT * FROM productoffers
                WHERE product_id = '7011' AND price > 0
                ORDER BY price ASC LIMIT 1
240 0.0001 0.00011491775512695
SELECT * FROM productoffers
                WHERE product_id = 7011
                ORDER BY price ASC LIMIT 1
241 0.0001 0.00012683868408203
SELECT value FROM productattributes
                WHERE product_id = '7011'
                AND name = 'ListPriceAmount'
242 0.0001 0.00011396408081055
SELECT * FROM products WHERE id = '7045'
243 0.0001 0.00010585784912109
SELECT * FROM productimages WHERE product_id = '7045' ORDER BY sortorder ASC
244 0.0001 0.00014400482177734
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '7045' AND p.id = pi.product_id ORDER BY pi.sortorder
245 0.0001 0.00013589859008789
SELECT * FROM product_image_select WHERE product_id = '7045'
246 0.0001 9.7036361694336E-5
SELECT * FROM productcustomimages WHERE product_id = '7045'
247 0.0001 0.00014901161193848
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 = '7045'
                GROUP BY o.product_id
248 0.0002 0.00018596649169922
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     = '7045'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
249 0.0001 0.00011396408081055
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 7045
250 0.0005 0.00052499771118164
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '7045' AND a.name = n.originalname
251 0.0001 0.00010991096496582
SELECT * FROM productoffers WHERE product_id = '7045' AND merchantid = 'ATVPDKIKX0DER'
252 0.0001 0.00011396408081055
SELECT * FROM productoffers
                WHERE product_id = '7045' AND price > 0
                ORDER BY price ASC LIMIT 1
253 0.0001 0.00012111663818359
SELECT * FROM productoffers
                WHERE product_id = 7045
                ORDER BY price ASC LIMIT 1
254 0.0001 0.00011396408081055
SELECT value FROM productattributes
                WHERE product_id = '7045'
                AND name = 'ListPriceAmount'
255 0.0002 0.0001518726348877
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 = '7045'
                GROUP BY o.product_id
256 0.0002 0.00017285346984863
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     = '7045'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
257 0.0001 0.00011396408081055
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 7045
258 0.0002 0.00015521049499512
SELECT value FROM productattributes WHERE product_id = '7045' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
259 0.0002 0.00016307830810547
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '7045'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Size'
                GROUP BY o.value
                ORDER BY o.value ASC
260 0.0001 0.00014996528625488
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '7045'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Color'
                GROUP BY o.value
                ORDER BY o.value ASC
261 0.0002 0.0002439022064209
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid' AND area = 'header' ORDER BY sortorder ASC
262 0.0002 0.00017499923706055
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid' AND area = 'footer' ORDER BY sortorder ASC
263 0.0004 0.00038409233093262
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-fluid' AND skinuid = ''
264 0.0002 0.00022792816162109
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid'
265 0.0001 0.00014495849609375
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid'
266 0.0003 0.00025820732116699
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid' AND imageuid = 'HEAD_LOGO'
267 0.0002 0.00016283988952637
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid' AND imageuid = 'HEAD_LOGO'