Tactical Equipment - Survivalist Equipment

AOFAR Range Finder for Hunting Archery H2 600/1000 Yards Shooting Wild Waterproof Coma Rangefinder, 6X 25mm, Range and Bow Mode, Free Battery Gift Package from AOFAR

Price: Click Button for Price
Product prices and availability are accurate as of 2019-06-14 02:02:43 UTC and are subject to change. Any price and availability information displayed on http://www.amazon.com/ at the time of purchase will apply to the purchase of this product.
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 Description

Tactical Survivalist : Combat Gear : Survival Gear : Combat Equipment is proud to bring you the famous AOFAR Range Finder for Hunting Archery H2 600/1000 Yards Shooting Wild Waterproof Coma Rangefinder, 6X 25mm, Range and Bow Mode, Free Battery Gift Package today at this great price.

With so many competing tactical, combat and survival products on offer recently, it is great to have a brand that you can recognize. The AOFAR Range Finder for Hunting Archery H2 600/1000 Yards Shooting Wild Waterproof Coma Rangefinder, 6X 25mm, Range and Bow Mode, Free Battery Gift Package is certainly all that and will be a perfect purchase for your combat gear or tactical ability.

We pride ourselves to provide the finest quality survivalist gear for all your on the job requirements.

For this great price, the AOFAR Range Finder for Hunting Archery H2 600/1000 Yards Shooting Wild Waterproof Coma Rangefinder, 6X 25mm, Range and Bow Mode, Free Battery Gift Package is greatly recommended and is a popular choice for most like minded people. AOFAR have provided some great touches and this means better value.

Product Features

High-Grade Hunting Range Finder : Adopting the latest Al technology, bow and range two modes, dust proof, fog proof, waterproof for all hunting enthusiasts. High Precision Rangefinder : Upgrade pinsensor technology. Centimeter data of display, precision of 5~300Y is +/-0.5 yards, larger than 300 yards is +/-1 yards. It can be measure up to 1000 yards. Clear Shooting Rangefinder: 6x magnification, lens is clear and easy to read; Sizes just 121x 72 x 43 mm and weight just 180g. Complete range finder: (Manufacturers direct sales, no middlemen profit margins) Including carrying pouch, free CR2 battery, high-grade portable rope, carabiner, microfiber cleaning cloth and quick start guide. Safety Shopping Experience: Provides 2 years after-sale guaranteed, Permanent Customer Support! It's Important to Share Your Shopping Experience, Engineers will Develop What You Like.

Write a Review

Debug Overview

App Total Time DB Queries DB Query Total Time Amazon Requests
2.4967861175537 764 1.3131 0


No Amazon API Requests Made.


App Debug - Total Time 2.4967861175537 seconds

Number Time From Start Name Description
1 0.43530702590942 Initialise Initialise FSB Function
2 0.43748593330383 App Controller Start Start of the App controller (called before the controller of every page)
3 0.44957399368286 Start of getCategoryListByGroup Function Before first category groups query
4 0.44976210594177 After initial query Before first category groups query
5 0.44976401329041 Get Category List for Group Before the call to getCategoryList function
6 0.44976806640625 Start of GetCategoryList function Start of the function
7 0.44977498054504 Before getting categories Query to get specific category list
8 0.45044803619385 After getting categories Query to get specific category list
9 0.45044994354248 Before getting category custom Before call to function getCategoryCustom
10 0.45248508453369 After getting category custom After call to function getCategoryCustom
11 0.45248794555664 Before getting category custom Before call to function getCategoryCustom
12 0.46314907073975 After getting category custom After call to function getCategoryCustom
13 0.4631519317627 Before getting category custom Before call to function getCategoryCustom
14 0.46871900558472 After getting category custom After call to function getCategoryCustom
15 0.46872210502625 Before getting category custom Before call to function getCategoryCustom
16 0.47291803359985 After getting category custom After call to function getCategoryCustom
17 0.47291994094849 End of GetCategoryList function End of the function
18 0.47292900085449 Get Category List for Group Before the call to getCategoryList function
19 0.47293210029602 Start of GetCategoryList function Start of the function
20 0.47293496131897 Before getting categories Query to get specific category list
21 0.4734001159668 After getting categories Query to get specific category list
22 0.47340202331543 Before getting category custom Before call to function getCategoryCustom
23 0.47894096374512 After getting category custom After call to function getCategoryCustom
24 0.47894406318665 Before getting category custom Before call to function getCategoryCustom
25 0.48949003219604 After getting category custom After call to function getCategoryCustom
26 0.48949313163757 End of GetCategoryList function End of the function
27 0.48950004577637 Get Category List for Group Before the call to getCategoryList function
28 0.48950290679932 Start of GetCategoryList function Start of the function
29 0.48950600624084 Before getting categories Query to get specific category list
30 0.49041390419006 After getting categories Query to get specific category list
31 0.49041604995728 Before getting category custom Before call to function getCategoryCustom
32 0.4996120929718 After getting category custom After call to function getCategoryCustom
33 0.49961495399475 Before getting category custom Before call to function getCategoryCustom
34 0.51663112640381 After getting category custom After call to function getCategoryCustom
35 0.51663398742676 Before getting category custom Before call to function getCategoryCustom
36 0.52256202697754 After getting category custom After call to function getCategoryCustom
37 0.52256512641907 Before getting category custom Before call to function getCategoryCustom
38 0.52856397628784 After getting category custom After call to function getCategoryCustom
39 0.52856707572937 Before getting category custom Before call to function getCategoryCustom
40 0.53484702110291 After getting category custom After call to function getCategoryCustom
41 0.53485012054443 Before getting category custom Before call to function getCategoryCustom
42 0.55640697479248 After getting category custom After call to function getCategoryCustom
43 0.55641007423401 Before getting category custom Before call to function getCategoryCustom
44 0.56054902076721 After getting category custom After call to function getCategoryCustom
45 0.56055212020874 Before getting category custom Before call to function getCategoryCustom
46 0.56520795822144 After getting category custom After call to function getCategoryCustom
47 0.56521010398865 End of GetCategoryList function End of the function
48 0.56522512435913 Get Category List for Group Before the call to getCategoryList function
49 0.56522798538208 Start of GetCategoryList function Start of the function
50 0.56523108482361 Before getting categories Query to get specific category list
51 0.56569290161133 After getting categories Query to get specific category list
52 0.56569504737854 Before getting category custom Before call to function getCategoryCustom
53 0.56806898117065 After getting category custom After call to function getCategoryCustom
54 0.56807208061218 Before getting category custom Before call to function getCategoryCustom
55 0.57049608230591 After getting category custom After call to function getCategoryCustom
56 0.57049798965454 End of GetCategoryList function End of the function
57 0.57050490379333 Get Category List for Group Before the call to getCategoryList function
58 0.57050704956055 Start of GetCategoryList function Start of the function
59 0.5705099105835 Before getting categories Query to get specific category list
60 0.57085299491882 After getting categories Query to get specific category list
61 0.57085394859314 Before getting category custom Before call to function getCategoryCustom
62 0.57585906982422 After getting category custom After call to function getCategoryCustom
63 0.57586097717285 End of GetCategoryList function End of the function
64 0.57586812973022 End of getCategoryListByGroup Function Before return()
65 0.62796401977539 App Controller End End of the App controller (called before the controller of every page)
66 0.62859106063843 Product Start Start of the product info controller
67 0.62942504882812 Cache file not found Starting get product details
68 0.68359112739563 Related products Start getting related products if enabled
69 0.68359303474426 Related Products Start Before the related products are found
70 0.68359398841858 Related Products Keywords Before the related product keywords are found
71 0.68360710144043 Create Keyword List Function Start of function
72 0.68485808372498 Create Keyword List Function After looping provided content - 673 keywords found
73 0.72791695594788 Create Keyword List Function After looping initial keyword list - 615 keywords remaining
74 0.7280809879303 Create Keyword List Function After reducing keyword list
75 0.72897100448608 Create Keyword List Function After selecting by scoring keywords
76 0.72897696495056 Create Keyword List Function After final loop of keywords
77 0.72897911071777 Related Products Keywords After the related product keywords are found
78 1.0046970844269 Related Products End After the related products are found
79 1.1873850822449 Start Remote Request http://svcs.ebay.com/services/search/FindingServic...
80 1.3392000198364 End Remote Request http://svcs.ebay.com/services/search/FindingServic...
81 1.5594050884247 Product End End of the product info controller (Product Info)
82 1.5598170757294 App_after Controller Start Start of the App_after controller (called after the controller of every page)
83 1.5599389076233 Before Get Options Before the call to getOptions in the tpl class
84 1.9720101356506 After Get Options After the call to getOptions in the tpl class
85 1.9722619056702 App_after Controller End End of the App_after controller (called after the controller of every page)
86 1.972275018692 Product Info: Before Smarty Fetch Before the product.tpl template is fetched
87 2.2927229404449 Product Info: After Smarty Fetch After the product.tpl template is fetched
88 2.2927300930023 Product Info: Before Template Display Before the template is displayed
89 2.4967639446259 Product Info: After Template Display After the template is displayed
90 2.4967699050903 Finalizing debug Before the debug is output to the page.
91 2.4967849254608 End of App This is the end of the app logging, final timestamp


Query Debug - 764 Database Queries. Total time 1.3131 seconds

Number Time (Seconds) Time (Milliseconds) Query
1 0.0002 0.00017094612121582
SELECT value FROM parameters WHERE `parameter` = 'BAD_BOTS_ENABLER'
2 0.0004 0.00042390823364258
SHOW TABLES LIKE 'bad_bots'
3 0.0002 0.00015902519226074
SELECT value FROM parameters WHERE `parameter` = 'STORE_WHITELISTED_IPS'
4 0.0002 0.00015091896057129
SELECT * FROM `bad_bots`
5 0.0005 0.00045514106750488
SELECT parameter, value FROM parameters
6 0.0001 0.00014615058898926
SET time_zone = 'Europe/London'
7 0.0003 0.00032997131347656
SELECT * FROM autorun ORDER BY lastrun ASC
8 0.0002 0.00016212463378906
SELECT * FROM version ORDER BY installed DESC LIMIT 1
9 0.0001 0.00012898445129395
delete from cachefiles
10 0.0002 0.00022697448730469
SELECT id FROM pages WHERE pagename = 'aofar-range-finder-for-hunting-archery-h2-6001000-yards-shooting-wild-waterproof-coma-rangefinder-6x-25mm-range-and-bow-mode-free-battery-gift-package' LIMIT 1
11 0.0002 0.00024509429931641
SELECT id FROM products WHERE pagename = 'aofar-range-finder-for-hunting-archery-h2-6001000-yards-shooting-wild-waterproof-coma-rangefinder-6x-25mm-range-and-bow-mode-free-battery-gift-package' AND hidden = 0 LIMIT 1
12 0.0009 0.00086593627929688
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-fluid'
13 0.0096 0.0096349716186523
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-fluid' AND language = 'en'
14 0.0003 0.00025081634521484
SELECT * FROM pages WHERE pagename = 'aofar-range-finder-for-hunting-archery-h2-6001000-yards-shooting-wild-waterproof-coma-rangefinder-6x-25mm-range-and-bow-mode-free-battery-gift-package'
15 0.0002 0.0001680850982666
SELECT * FROM categorygroups ORDER BY sortorder ASC
16 0.0006 0.00057291984558105
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
17 0.0005 0.00050902366638184
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 = 49
18 0.0003 0.00025105476379395
SELECT id FROM categories WHERE parent_id = '49'
19 0.0005 0.00047612190246582
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (49)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
20 0.0002 0.00016307830810547
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (49)
				  AND p.disabled = 0 
21 0.0002 0.00016498565673828
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (49)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
22 0.0002 0.00018715858459473
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '49'
23 0.0001 0.00013899803161621
SELECT * FROM categorygroups WHERE id = '1'
24 0.0030 0.0029828548431396
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 = 50
25 0.0003 0.00028014183044434
SELECT id FROM categories WHERE parent_id = '50'
26 0.0002 0.00021696090698242
SELECT id FROM categories WHERE parent_id = '96'
27 0.0002 0.00021600723266602
SELECT id FROM categories WHERE parent_id = '97'
28 0.0002 0.0002138614654541
SELECT id FROM categories WHERE parent_id = '111'
29 0.0002 0.00022411346435547
SELECT id FROM categories WHERE parent_id = '129'
30 0.0057 0.0056641101837158
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (96,97,111,129,50)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
31 0.0002 0.00018906593322754
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (96,97,111,129,50)
				  AND p.disabled = 0 
32 0.0002 0.00016903877258301
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (96,97,111,129,50)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
33 0.0002 0.00018596649169922
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '50'
34 0.0001 0.0001380443572998
SELECT * FROM categorygroups WHERE id = '1'
35 0.0022 0.0022470951080322
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 = 80
36 0.0003 0.00028419494628906
SELECT id FROM categories WHERE parent_id = '80'
37 0.0023 0.0022759437561035
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (80)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
38 0.0002 0.00015807151794434
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (80)
				  AND p.disabled = 0 
39 0.0002 0.00016117095947266
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (80)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
40 0.0002 0.00018501281738281
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '80'
41 0.0001 0.00013899803161621
SELECT * FROM categorygroups WHERE id = '1'
42 0.0011 0.0011382102966309
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 = 51
43 0.0003 0.00026106834411621
SELECT id FROM categories WHERE parent_id = '51'
44 0.0002 0.00021815299987793
SELECT id FROM categories WHERE parent_id = '101'
45 0.0018 0.0017819404602051
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (101,51)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
46 0.0002 0.00016903877258301
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (101,51)
				  AND p.disabled = 0 
47 0.0002 0.00017189979553223
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (101,51)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
48 0.0002 0.00018715858459473
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '51'
49 0.0001 0.0001370906829834
SELECT * FROM categorygroups WHERE id = '1'
50 0.0004 0.00043392181396484
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '2'  AND hidden = 0 ORDER BY sortorder ASC
51 0.0023 0.0022540092468262
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
52 0.0003 0.0002601146697998
SELECT id FROM categories WHERE parent_id = '30'
53 0.0023 0.0022580623626709
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 
54 0.0002 0.00015687942504883
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 
55 0.0002 0.0001671314239502
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (30)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
56 0.0002 0.00018596649169922
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
57 0.0001 0.00013589859008789
SELECT * FROM categorygroups WHERE id = '2'
58 0.0047 0.0047171115875244
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 = 61
59 0.0003 0.00027704238891602
SELECT id FROM categories WHERE parent_id = '61'
60 0.0048 0.0047709941864014
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (61)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
61 0.0002 0.00016689300537109
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (61)
				  AND p.disabled = 0 
62 0.0002 0.00016307830810547
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (61)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
63 0.0002 0.00018215179443359
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '61'
64 0.0001 0.0001380443572998
SELECT * FROM categorygroups WHERE id = '2'
65 0.0007 0.00074005126953125
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '10'  AND hidden = 0 ORDER BY sortorder ASC
66 0.0041 0.0040621757507324
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 = 64
67 0.0003 0.00029110908508301
SELECT id FROM categories WHERE parent_id = '64'
68 0.0040 0.0040459632873535
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (64)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
69 0.0002 0.00017094612121582
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (64)
				  AND p.disabled = 0 
70 0.0002 0.00016212463378906
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (64)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
71 0.0002 0.00018000602722168
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '64'
72 0.0001 0.00014901161193848
SELECT * FROM categorygroups WHERE id = '10'
73 0.0079 0.0079350471496582
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 = 65
74 0.0003 0.0002899169921875
SELECT id FROM categories WHERE parent_id = '65'
75 0.0080 0.0079948902130127
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (65)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
76 0.0002 0.00017285346984863
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (65)
				  AND p.disabled = 0 
77 0.0002 0.00016307830810547
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (65)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
78 0.0002 0.00018191337585449
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '65'
79 0.0001 0.00014781951904297
SELECT * FROM categorygroups WHERE id = '10'
80 0.0024 0.0024120807647705
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 = 81
81 0.0003 0.00027108192443848
SELECT id FROM categories WHERE parent_id = '81'
82 0.0025 0.0024590492248535
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (81)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
83 0.0002 0.00016498565673828
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (81)
				  AND p.disabled = 0 
84 0.0002 0.00016188621520996
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (81)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
85 0.0002 0.00017714500427246
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '81'
86 0.0001 0.00014710426330566
SELECT * FROM categorygroups WHERE id = '10'
87 0.0024 0.0024411678314209
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
88 0.0003 0.00026988983154297
SELECT id FROM categories WHERE parent_id = '31'
89 0.0025 0.0024878978729248
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 
90 0.0002 0.0001671314239502
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 
91 0.0002 0.00016307830810547
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (31)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
92 0.0002 0.00018405914306641
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
93 0.0001 0.00014686584472656
SELECT * FROM categorygroups WHERE id = '10'
94 0.0022 0.0022008419036865
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 = 66
95 0.0003 0.00026488304138184
SELECT id FROM categories WHERE parent_id = '66'
96 0.0002 0.00022006034851074
SELECT id FROM categories WHERE parent_id = '131'
97 0.0028 0.0028069019317627
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (131,66)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
98 0.0002 0.00016522407531738
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (131,66)
				  AND p.disabled = 0 
99 0.0002 0.00016498565673828
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (131,66)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
100 0.0002 0.00018715858459473
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '66'
101 0.0001 0.0001370906829834
SELECT * FROM categorygroups WHERE id = '10'
102 0.0093 0.0092780590057373
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 = 34
103 0.0003 0.00029301643371582
SELECT id FROM categories WHERE parent_id = '34'
104 0.0002 0.00022792816162109
SELECT id FROM categories WHERE parent_id = '94'
105 0.0002 0.00021815299987793
SELECT id FROM categories WHERE parent_id = '98'
106 0.0002 0.0002140998840332
SELECT id FROM categories WHERE parent_id = '99'
107 0.0002 0.00021696090698242
SELECT id FROM categories WHERE parent_id = '110'
108 0.0002 0.00022292137145996
SELECT id FROM categories WHERE parent_id = '130'
109 0.0100 0.0099871158599854
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (94,98,99,110,130,34)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
110 0.0002 0.00018501281738281
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (94,98,99,110,130,34)
				  AND p.disabled = 0 
111 0.0002 0.00017118453979492
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (94,98,99,110,130,34)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
112 0.0002 0.00019192695617676
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '34'
113 0.0001 0.00014495849609375
SELECT * FROM categorygroups WHERE id = '10'
114 0.0015 0.0015318393707275
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 = 32
115 0.0003 0.00026702880859375
SELECT id FROM categories WHERE parent_id = '32'
116 0.0016 0.0015869140625
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (32)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
117 0.0002 0.00015401840209961
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (32)
				  AND p.disabled = 0 
118 0.0002 0.00015902519226074
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (32)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
119 0.0002 0.00017809867858887
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '32'
120 0.0001 0.00013589859008789
SELECT * FROM categorygroups WHERE id = '10'
121 0.0018 0.0017931461334229
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 = 89
122 0.0003 0.0002739429473877
SELECT id FROM categories WHERE parent_id = '89'
123 0.0018 0.0018258094787598
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (89)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
124 0.0002 0.00016307830810547
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (89)
				  AND p.disabled = 0 
125 0.0002 0.00015997886657715
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (89)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
126 0.0002 0.00018405914306641
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '89'
127 0.0001 0.0001368522644043
SELECT * FROM categorygroups WHERE id = '10'
128 0.0004 0.00043106079101562
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '17'  AND hidden = 0 ORDER BY sortorder ASC
129 0.0007 0.00067806243896484
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 = 84
130 0.0003 0.0002589225769043
SELECT id FROM categories WHERE parent_id = '84'
131 0.0007 0.00068378448486328
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (84)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
132 0.0001 0.00014996528625488
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (84)
				  AND p.disabled = 0 
133 0.0002 0.00016093254089355
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (84)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
134 0.0002 0.00018000602722168
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '84'
135 0.0001 0.00013494491577148
SELECT * FROM categorygroups WHERE id = '17'
136 0.0007 0.00070595741271973
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 = 90
137 0.0002 0.00024890899658203
SELECT id FROM categories WHERE parent_id = '90'
138 0.0007 0.00074386596679688
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (90)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
139 0.0002 0.00015091896057129
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (90)
				  AND p.disabled = 0 
140 0.0002 0.00015902519226074
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (90)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
141 0.0002 0.00016999244689941
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '90'
142 0.0001 0.00013518333435059
SELECT * FROM categorygroups WHERE id = '17'
143 0.0003 0.00032401084899902
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '20'  AND hidden = 0 ORDER BY sortorder ASC
144 0.0020 0.0019841194152832
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 = 92
145 0.0003 0.00025296211242676
SELECT id FROM categories WHERE parent_id = '92'
146 0.0020 0.002007007598877
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (92)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
147 0.0002 0.00015497207641602
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (92)
				  AND p.disabled = 0 
148 0.0002 0.00015997886657715
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (92)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
149 0.0002 0.00017690658569336
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '92'
150 0.0001 0.00013899803161621
SELECT * FROM categorygroups WHERE id = '20'
151 0.0052 0.0052001476287842
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
152 0.0004 0.00037503242492676
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-fluid' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
153 0.0002 0.00017118453979492
SELECT value FROM parameters WHERE parameter = 'EBAY_APP_ID' 
154 0.0002 0.00017905235290527
SELECT * FROM sideboxes_pages WHERE sidebox_id = '1'
155 0.0002 0.00018000602722168
SELECT * FROM pages WHERE id = '67'
156 0.0002 0.00017094612121582
SELECT * FROM pages WHERE id = '82'
157 0.0002 0.00017595291137695
SELECT * FROM pages WHERE id = '84'
158 0.0002 0.00015902519226074
SELECT * FROM pages WHERE id = '94'
159 0.0002 0.00017786026000977
SELECT * FROM pages WHERE id = '116'
160 0.0002 0.0002288818359375
SELECT * FROM pages WHERE id = '52'
161 0.0002 0.0002131462097168
SELECT * FROM pages WHERE id = '135'
162 0.0002 0.00019097328186035
SELECT * FROM pages WHERE id = '245'
163 0.0002 0.00018501281738281
SELECT * FROM pages WHERE id = '269'
164 0.0002 0.00021004676818848
SELECT * FROM pages WHERE id = '275'
165 0.0002 0.00019502639770508
SELECT * FROM pages WHERE id = '280'
166 0.0002 0.00019598007202148
SELECT * FROM pages WHERE id = '357'
167 0.0002 0.00016093254089355
SELECT * FROM pages WHERE id = '379'
168 0.0001 0.00014495849609375
SELECT * FROM pages WHERE id = '401'
169 0.0002 0.00015115737915039
SELECT * FROM pages WHERE id = '450'
170 0.0001 0.00014615058898926
SELECT * FROM pages WHERE id = '454'
171 0.0002 0.00015616416931152
SELECT * FROM pages WHERE id = '457'
172 0.0002 0.00015091896057129
SELECT * FROM pages WHERE id = '458'
173 0.0002 0.00016689300537109
SELECT * FROM sideboxes_pages WHERE sidebox_id = '2'
174 0.0002 0.00016117095947266
SELECT * FROM pages WHERE id = '41'
175 0.0002 0.00016093254089355
SELECT * FROM pages WHERE id = '43'
176 0.0001 0.00014901161193848
SELECT * FROM pages WHERE id = '44'
177 0.0001 0.00014495849609375
SELECT * FROM pages WHERE id = '68'
178 0.0002 0.00022006034851074
SELECT * FROM pages WHERE id = '80'
179 0.0002 0.00016093254089355
SELECT * FROM pages WHERE id = '85'
180 0.0002 0.00015497207641602
SELECT * FROM pages WHERE id = '97'
181 0.0002 0.0001530647277832
SELECT * FROM pages WHERE id = '107'
182 0.0001 0.00014519691467285
SELECT * FROM pages WHERE id = '108'
183 0.0002 0.00015401840209961
SELECT * FROM pages WHERE id = '128'
184 0.0002 0.00017189979553223
SELECT * FROM pages WHERE id = '133'
185 0.0001 0.00014615058898926
SELECT * FROM pages WHERE id = '148'
186 0.0002 0.00015687942504883
SELECT * FROM pages WHERE id = '217'
187 0.0001 0.00014400482177734
SELECT * FROM pages WHERE id = '228'
188 0.0001 0.00014996528625488
SELECT * FROM pages WHERE id = '257'
189 0.0002 0.00017094612121582
SELECT * FROM pages WHERE id = '271'
190 0.0001 0.00014615058898926
SELECT * FROM pages WHERE id = '286'
191 0.0001 0.00014400482177734
SELECT * FROM pages WHERE id = '287'
192 0.0002 0.00015401840209961
SELECT * FROM pages WHERE id = '291'
193 0.0002 0.00015401840209961
SELECT * FROM pages WHERE id = '380'
194 0.0002 0.0001528263092041
SELECT * FROM pages WHERE id = '344'
195 0.0002 0.00017595291137695
SELECT * FROM pages WHERE id = '354'
196 0.0002 0.00019407272338867
SELECT * FROM pages WHERE id = '363'
197 0.0002 0.00017905235290527
SELECT * FROM pages WHERE id = '364'
198 0.0001 0.00014209747314453
SELECT * FROM pages WHERE id = '368'
199 0.0002 0.00018692016601562
SELECT * FROM pages WHERE id = '369'
200 0.0001 0.00014591217041016
SELECT * FROM pages WHERE id = '400'
201 0.0002 0.00015497207641602
SELECT * FROM pages WHERE id = '463'
202 0.0002 0.00016498565673828
SELECT * FROM sideboxes_pages WHERE sidebox_id = '33'
203 0.0003 0.00027203559875488
SELECT * FROM pages WHERE id = '66'
204 0.0002 0.00019407272338867
SELECT * FROM pages WHERE id = '77'
205 0.0002 0.00018811225891113
SELECT * FROM pages WHERE id = '90'
206 0.0001 0.00014090538024902
SELECT * FROM pages WHERE id = '414'
207 0.0001 0.00014591217041016
SELECT * FROM pages WHERE id = '119'
208 0.0002 0.00015401840209961
SELECT * FROM pages WHERE id = '406'
209 0.0002 0.00016117095947266
SELECT * FROM pages WHERE id = '149'
210 0.0001 0.00014710426330566
SELECT * FROM pages WHERE id = '150'
211 0.0001 0.00014305114746094
SELECT * FROM pages WHERE id = '412'
212 0.0002 0.00016212463378906
SELECT * FROM pages WHERE id = '162'
213 0.0001 0.00014185905456543
SELECT * FROM pages WHERE id = '164'
214 0.0001 0.00014185905456543
SELECT * FROM pages WHERE id = '167'
215 0.0001 0.00014877319335938
SELECT * FROM pages WHERE id = '180'
216 0.0001 0.00013899803161621
SELECT * FROM pages WHERE id = '187'
217 0.0002 0.0001990795135498
SELECT * FROM pages WHERE id = '265'
218 0.0002 0.0001518726348877
SELECT * FROM pages WHERE id = '268'
219 0.0001 0.00013995170593262
SELECT * FROM pages WHERE id = '411'
220 0.0002 0.00015902519226074
SELECT * FROM pages WHERE id = '290'
221 0.0001 0.00014019012451172
SELECT * FROM pages WHERE id = '413'
222 0.0001 0.00014209747314453
SELECT * FROM pages WHERE id = '409'
223 0.0001 0.00014901161193848
SELECT * FROM pages WHERE id = '327'
224 0.0001 0.00014591217041016
SELECT * FROM pages WHERE id = '336'
225 0.0002 0.0001528263092041
SELECT * FROM pages WHERE id = '351'
226 0.0002 0.00015521049499512
SELECT * FROM pages WHERE id = '358'
227 0.0002 0.00016307830810547
SELECT * FROM pages WHERE id = '360'
228 0.0002 0.00015020370483398
SELECT * FROM pages WHERE id = '362'
229 0.0002 0.00015521049499512
SELECT * FROM pages WHERE id = '366'
230 0.0002 0.00015902519226074
SELECT * FROM pages WHERE id = '370'
231 0.0002 0.00016021728515625
SELECT * FROM pages WHERE id = '377'
232 0.0002 0.00015115737915039
SELECT * FROM pages WHERE id = '386'
233 0.0001 0.00014305114746094
SELECT * FROM pages WHERE id = '408'
234 0.0001 0.00013899803161621
SELECT * FROM pages WHERE id = '415'
235 0.0002 0.00016999244689941
SELECT * FROM pages WHERE id = '416'
236 0.0002 0.00018882751464844
SELECT * FROM pages WHERE id = '419'
237 0.0002 0.00016188621520996
SELECT * FROM pages WHERE id = '423'
238 0.0002 0.0001528263092041
SELECT * FROM pages WHERE id = '427'
239 0.0002 0.00018310546875
SELECT * FROM pages WHERE id = '428'
240 0.0001 0.0001370906829834
SELECT * FROM pages WHERE id = '432'
241 0.0001 0.00014591217041016
SELECT * FROM pages WHERE id = '433'
242 0.0002 0.00015997886657715
SELECT * FROM pages WHERE id = '436'
243 0.0002 0.00015401840209961
SELECT * FROM pages WHERE id = '437'
244 0.0001 0.00014400482177734
SELECT * FROM pages WHERE id = '461'
245 0.0002 0.00017380714416504
SELECT * FROM pages WHERE id = '464'
246 0.0001 0.00014615058898926
SELECT * FROM sideboxes_pages WHERE sidebox_id = '34'
247 0.0002 0.00015091896057129
SELECT * FROM pages WHERE id = '74'
248 0.0002 0.00015687942504883
SELECT * FROM pages WHERE id = '137'
249 0.0001 0.00014996528625488
SELECT * FROM pages WHERE id = '145'
250 0.0001 0.00014805793762207
SELECT * FROM pages WHERE id = '156'
251 0.0002 0.00015115737915039
SELECT * FROM pages WHERE id = '407'
252 0.0001 0.00013899803161621
SELECT * FROM pages WHERE id = '410'
253 0.0002 0.00018692016601562
SELECT * FROM pages WHERE id = '266'
254 0.0002 0.00021505355834961
SELECT * FROM pages WHERE id = '316'
255 0.0001 0.00014996528625488
SELECT * FROM pages WHERE id = '332'
256 0.0002 0.00017404556274414
SELECT * FROM pages WHERE id = '334'
257 0.0001 0.00014400482177734
SELECT * FROM pages WHERE id = '367'
258 0.0002 0.00015783309936523
SELECT * FROM pages WHERE id = '387'
259 0.0002 0.00015401840209961
SELECT * FROM pages WHERE id = '389'
260 0.0002 0.00016093254089355
SELECT * FROM pages WHERE id = '397'
261 0.0002 0.00015807151794434
SELECT * FROM pages WHERE id = '449'
262 0.0002 0.00015997886657715
SELECT * FROM sideboxes_pages WHERE sidebox_id = '35'
263 0.0002 0.00020384788513184
SELECT * FROM pages WHERE id = '42'
264 0.0001 0.00014996528625488
SELECT * FROM pages WHERE id = '79'
265 0.0002 0.00015783309936523
SELECT * FROM pages WHERE id = '86'
266 0.0001 0.00014305114746094
SELECT * FROM pages WHERE id = '95'
267 0.0002 0.00015091896057129
SELECT * FROM pages WHERE id = '102'
268 0.0001 0.00014615058898926
SELECT * FROM pages WHERE id = '109'
269 0.0002 0.00023007392883301
SELECT * FROM pages WHERE id = '114'
270 0.0002 0.00017809867858887
SELECT * FROM pages WHERE id = '121'
271 0.0002 0.00020694732666016
SELECT * FROM pages WHERE id = '138'
272 0.0002 0.00016498565673828
SELECT * FROM pages WHERE id = '142'
273 0.0002 0.00020599365234375
SELECT * FROM pages WHERE id = '62'
274 0.0001 0.00014901161193848
SELECT * FROM pages WHERE id = '157'
275 0.0002 0.00016117095947266
SELECT * FROM pages WHERE id = '246'
276 0.0002 0.00019407272338867
SELECT * FROM pages WHERE id = '276'
277 0.0002 0.00017905235290527
SELECT * FROM pages WHERE id = '278'
278 0.0002 0.00022196769714355
SELECT * FROM pages WHERE id = '279'
279 0.0002 0.00016117095947266
SELECT * FROM pages WHERE id = '317'
280 0.0001 0.00014901161193848
SELECT * FROM pages WHERE id = '405'
281 0.0002 0.00017309188842773
SELECT * FROM pages WHERE id = '343'
282 0.0001 0.00014996528625488
SELECT * FROM pages WHERE id = '345'
283 0.0002 0.00020480155944824
SELECT * FROM pages WHERE id = '346'
284 0.0002 0.00015616416931152
SELECT * FROM pages WHERE id = '347'
285 0.0002 0.00015807151794434
SELECT * FROM pages WHERE id = '348'
286 0.0001 0.00014996528625488
SELECT * FROM pages WHERE id = '349'
287 0.0001 0.00014710426330566
SELECT * FROM pages WHERE id = '381'
288 0.0001 0.00014805793762207
SELECT * FROM pages WHERE id = '392'
289 0.0002 0.00015592575073242
SELECT * FROM pages WHERE id = '393'
290 0.0001 0.00014400482177734
SELECT * FROM pages WHERE id = '394'
291 0.0001 0.00014805793762207
SELECT * FROM pages WHERE id = '395'
292 0.0002 0.00015592575073242
SELECT * FROM pages WHERE id = '399'
293 0.0002 0.0001530647277832
SELECT * FROM pages WHERE id = '421'
294 0.0001 0.00014591217041016
SELECT * FROM pages WHERE id = '426'
295 0.0001 0.00014400482177734
SELECT * FROM pages WHERE id = '430'
296 0.0001 0.00014805793762207
SELECT * FROM pages WHERE id = '431'
297 0.0002 0.00015616416931152
SELECT * FROM pages WHERE id = '434'
298 0.0002 0.00016212463378906
SELECT * FROM pages WHERE id = '435'
299 0.0002 0.00016617774963379
SELECT * FROM pages WHERE id = '440'
300 0.0002 0.0001680850982666
SELECT * FROM pages WHERE id = '441'
301 0.0001 0.00014901161193848
SELECT * FROM pages WHERE id = '451'
302 0.0001 0.00014114379882812
SELECT * FROM pages WHERE id = '453'
303 0.0001 0.00013899803161621
SELECT * FROM sideboxes_pages WHERE sidebox_id = '37'
304 0.0002 0.00016403198242188
SELECT * FROM pages WHERE id = '146'
305 0.0001 0.00014495849609375
SELECT * FROM pages WHERE id = '158'
306 0.0001 0.00014185905456543
SELECT * FROM pages WHERE id = '163'
307 0.0002 0.00022506713867188
SELECT * FROM pages WHERE id = '293'
308 0.0002 0.00015497207641602
SELECT * FROM pages WHERE id = '340'
309 0.0002 0.00015687942504883
SELECT * FROM pages WHERE id = '417'
310 0.0001 0.00013995170593262
SELECT * FROM sideboxes_pages WHERE sidebox_id = '40'
311 0.0002 0.00016903877258301
SELECT * FROM pages WHERE id = '173'
312 0.0002 0.00015711784362793
SELECT * FROM pages WHERE id = '181'
313 0.0001 0.00014400482177734
SELECT * FROM pages WHERE id = '288'
314 0.0002 0.0001521110534668
SELECT * FROM pages WHERE id = '299'
315 0.0001 0.00014805793762207
SELECT * FROM pages WHERE id = '300'
316 0.0002 0.00016307830810547
SELECT * FROM pages WHERE id = '383'
317 0.0001 0.00014305114746094
SELECT * FROM pages WHERE id = '385'
318 0.0002 0.00015711784362793
SELECT * FROM pages WHERE id = '438'
319 0.0002 0.00015807151794434
SELECT * FROM pages WHERE id = '442'
320 0.0001 0.0001370906829834
SELECT * FROM sideboxes_pages WHERE sidebox_id = '38'
321 0.0002 0.00023818016052246
SELECT * FROM pages WHERE id = '103'
322 0.0002 0.0002138614654541
SELECT * FROM pages WHERE id = '134'
323 0.0001 0.00014400482177734
SELECT * FROM pages WHERE id = '139'
324 0.0002 0.0001528263092041
SELECT * FROM pages WHERE id = '143'
325 0.0002 0.0001530647277832
SELECT * FROM pages WHERE id = '234'
326 0.0002 0.00015592575073242
SELECT * FROM pages WHERE id = '248'
327 0.0001 0.00014495849609375
SELECT * FROM pages WHERE id = '260'
328 0.0001 0.00014996528625488
SELECT * FROM pages WHERE id = '398'
329 0.0002 0.00015115737915039
SELECT * FROM sideboxes_pages WHERE sidebox_id = '29'
330 0.0002 0.00016999244689941
SELECT * FROM pages WHERE id = '61'
331 0.0002 0.00015401840209961
SELECT * FROM pages WHERE id = '87'
332 0.0002 0.00016999244689941
SELECT * FROM pages WHERE id = '104'
333 0.0002 0.00020217895507812
SELECT * FROM pages WHERE id = '115'
334 0.0001 0.00013995170593262
SELECT * FROM pages WHERE id = '124'
335 0.0002 0.0001530647277832
SELECT * FROM pages WHERE id = '144'
336 0.0002 0.00017118453979492
SELECT * FROM pages WHERE id = '151'
337 0.0002 0.0001518726348877
SELECT * FROM pages WHERE id = '199'
338 0.0002 0.00015687942504883
SELECT * FROM pages WHERE id = '200'
339 0.0001 0.00014400482177734
SELECT * FROM pages WHERE id = '304'
340 0.0001 0.00013995170593262
SELECT * FROM pages WHERE id = '321'
341 0.0001 0.00014114379882812
SELECT * FROM pages WHERE id = '333'
342 0.0002 0.00016498565673828
SELECT * FROM pages WHERE id = '350'
343 0.0002 0.00015091896057129
SELECT * FROM pages WHERE id = '378'
344 0.0001 0.00014615058898926
SELECT * FROM pages WHERE id = '422'
345 0.0002 0.00017404556274414
SELECT * FROM pages WHERE id = '425'
346 0.0001 0.00014090538024902
SELECT * FROM pages WHERE id = '443'
347 0.0001 0.00014019012451172
SELECT * FROM pages WHERE id = '444'
348 0.0001 0.00014996528625488
SELECT * FROM pages WHERE id = '445'
349 0.0002 0.0001530647277832
SELECT * FROM pages WHERE id = '446'
350 0.0001 0.00014305114746094
SELECT * FROM pages WHERE id = '447'
351 0.0001 0.00014495849609375
SELECT * FROM pages WHERE id = '448'
352 0.0001 0.00014495849609375
SELECT * FROM pages WHERE id = '455'
353 0.0002 0.00015497207641602
SELECT * FROM pages WHERE id = '456'
354 0.0002 0.0001521110534668
SELECT * FROM pages WHERE id = '459'
355 0.0002 0.00015497207641602
SELECT * FROM pages WHERE id = '460'
356 0.0001 0.00014591217041016
SELECT * FROM pages WHERE id = '462'
357 0.0001 0.00014209747314453
SELECT * FROM sideboxes_pages WHERE sidebox_id = '32'
358 0.0002 0.00016689300537109
SELECT * FROM pages WHERE id = '153'
359 0.0002 0.00019717216491699
SELECT * FROM pages WHERE id = '182'
360 0.0001 0.00014805793762207
SELECT * FROM pages WHERE id = '238'
361 0.0001 0.00014114379882812
SELECT * FROM pages WHERE id = '240'
362 0.0001 0.0001380443572998
SELECT * FROM pages WHERE id = '242'
363 0.0001 0.0001370906829834
SELECT * FROM pages WHERE id = '252'
364 0.0001 0.00013589859008789
SELECT * FROM pages WHERE id = '253'
365 0.0001 0.00014710426330566
SELECT * FROM pages WHERE id = '262'
366 0.0001 0.00014400482177734
SELECT * FROM pages WHERE id = '267'
367 0.0001 0.00014400482177734
SELECT * FROM pages WHERE id = '420'
368 0.0001 0.00013494491577148
SELECT value FROM parameters WHERE parameter = 'GOOGLE_SITE_KEY' 
369 0.0001 0.00011801719665527
SELECT value FROM parameters WHERE parameter = 'GOOGLE_SECRET_KEY' 
370 0.0001 0.00011610984802246
SELECT value FROM parameters WHERE parameter = 'GOOGLE_RECAPTCHA_TYPE' 
371 0.0013 0.0013339519500732
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
372 0.0002 0.00017499923706055
SELECT value FROM parameters WHERE parameter = 'GOOGLE_SITE_KEY' 
373 0.0001 0.00011992454528809
SELECT value FROM parameters WHERE parameter = 'GOOGLE_SECRET_KEY' 
374 0.0001 0.00012302398681641
SELECT value FROM parameters WHERE parameter = 'GOOGLE_RECAPTCHA_TYPE' 
375 0.0003 0.0002901554107666
SELECT * FROM products WHERE pagename = 'aofar-range-finder-for-hunting-archery-h2-6001000-yards-shooting-wild-waterproof-coma-rangefinder-6x-25mm-range-and-bow-mode-free-battery-gift-package'
376 0.0002 0.00022506713867188
SELECT * FROM manufacturers WHERE id = '8237'
377 0.0003 0.00026297569274902
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '8237'
378 0.0001 0.00011610984802246
SELECT filename FROM manufacturerimages WHERE manufacturer_id = '8237' LIMIT 1
379 0.0002 0.00021600723266602
SELECT pagename, id FROM products p WHERE manufacturer_id = '8237' ORDER BY RAND() LIMIT 1
380 0.0002 0.00023412704467773
SELECT * FROM productimages WHERE product_id = '414479' ORDER BY sortorder ASC
381 0.0002 0.0002140998840332
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '8237'
382 0.0002 0.00024199485778809
SELECT COUNT(DISTINCT(p.id)) FROM products p
				WHERE p.manufacturer_id = '8237'
				  AND p.hidden = 0
				  AND p.enabled = 1
				  AND p.parent_id = 0 
383 0.0001 0.00011491775512695
SELECT * FROM manufacturerimages WHERE manufacturer_id = '8237'
384 0.0001 0.00013184547424316
SELECT category_id FROM products_categories WHERE product_id = '415011'
385 0.0002 0.00019097328186035
SELECT * FROM categories WHERE id = '65'
386 0.0081 0.0081050395965576
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 = 65
387 0.0001 0.0001380443572998
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 65
388 0.0003 0.00026893615722656
SELECT id FROM categories WHERE parent_id = '65'
389 0.0080 0.0080227851867676
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (65)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
390 0.0002 0.00017404556274414
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (65)
				  AND p.disabled = 0 
391 0.0002 0.0001530647277832
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (65)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
392 0.0002 0.00018000602722168
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '65'
393 0.0002 0.00020194053649902
SELECT * FROM productimages WHERE product_id = '415011' ORDER BY sortorder ASC
394 0.0004 0.00035285949707031
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '415011' AND p.id = pi.product_id ORDER BY pi.sortorder
395 0.0002 0.00023293495178223
SELECT * FROM product_image_select WHERE product_id = '415011'
396 0.0001 0.00012707710266113
SELECT * FROM productcustomimages WHERE product_id = '415011'
397 0.0001 0.00011301040649414
SELECT * FROM productfeeds WHERE product_id = '415011' ORDER BY item_date DESC
398 0.0004 0.00037598609924316
SELECT a.name, n.displayname, a.value, n.units, n.valuetype FROM productattributes a, productattributenames n WHERE product_id = '415011' AND a.name = n.originalname AND n.display = 1 AND n.hidden = 0
399 0.0003 0.00029993057250977
SELECT DISTINCT(pt.tag_id) FROM product_tags pt, tags t WHERE pt.tag_id = t.id AND pt.product_id = '415011' AND t.hidden = 0 AND display_product = 1
400 0.0001 0.00014400482177734
SELECT * FROM tags WHERE id = '270'
401 0.0016 0.0015931129455566
SELECT COUNT(DISTINCT(p.id)) FROM products p, product_tags t
				WHERE p.id = t.product_id
				  AND t.tag_id = '270'
				  AND p.parent_id = 0
				  AND p.enabled = 1
				  AND p.hidden = 0
402 0.0015 0.0015380382537842
SELECT COUNT(DISTINCT(p.id)) FROM products p, product_tags t
				WHERE p.id = t.product_id
				  AND t.tag_id = '270'
				  AND p.parent_id = 0
				  AND hidden = 0
				  AND enabled = 1 
403 0.0016 0.0015978813171387
SELECT p.id FROM products p, product_tags t WHERE p.id = t.product_id AND t.tag_id = '270' AND p.hidden = 0 AND p.salesrank > 0 AND (p.price > 0 OR p.parent = 1) ORDER BY p.salesrank ASC LIMIT 1
404 0.0002 0.00024890899658203
SELECT * FROM productimages WHERE product_id = '414275' ORDER BY sortorder ASC
405 0.0001 0.00014209747314453
SELECT * FROM tags WHERE id = '3959'
406 0.0008 0.0008080005645752
SELECT COUNT(DISTINCT(p.id)) FROM products p, product_tags t
				WHERE p.id = t.product_id
				  AND t.tag_id = '3959'
				  AND p.parent_id = 0
				  AND p.enabled = 1
				  AND p.hidden = 0
407 0.0008 0.00078701972961426
SELECT COUNT(DISTINCT(p.id)) FROM products p, product_tags t
				WHERE p.id = t.product_id
				  AND t.tag_id = '3959'
				  AND p.parent_id = 0
				  AND hidden = 0
				  AND enabled = 1 
408 0.0008 0.00080990791320801
SELECT p.id FROM products p, product_tags t WHERE p.id = t.product_id AND t.tag_id = '3959' AND p.hidden = 0 AND p.salesrank > 0 AND (p.price > 0 OR p.parent = 1) ORDER BY p.salesrank ASC LIMIT 1
409 0.0004 0.00042009353637695
SELECT * FROM productimages WHERE product_id = '411183' ORDER BY sortorder ASC
410 0.0001 0.00014281272888184
SELECT * FROM tags WHERE id = '3385'
411 0.0012 0.0011501312255859
SELECT COUNT(DISTINCT(p.id)) FROM products p, product_tags t
				WHERE p.id = t.product_id
				  AND t.tag_id = '3385'
				  AND p.parent_id = 0
				  AND p.enabled = 1
				  AND p.hidden = 0
412 0.0011 0.0011091232299805
SELECT COUNT(DISTINCT(p.id)) FROM products p, product_tags t
				WHERE p.id = t.product_id
				  AND t.tag_id = '3385'
				  AND p.parent_id = 0
				  AND hidden = 0
				  AND enabled = 1 
413 0.0011 0.0011389255523682
SELECT p.id FROM products p, product_tags t WHERE p.id = t.product_id AND t.tag_id = '3385' AND p.hidden = 0 AND p.salesrank > 0 AND (p.price > 0 OR p.parent = 1) ORDER BY p.salesrank ASC LIMIT 1
414 0.0002 0.00020313262939453
SELECT * FROM productimages WHERE product_id = '412716' ORDER BY sortorder ASC
415 0.0136 0.013617992401123
SELECT * FROM productamazoncontent WHERE product_id = '415011'
416 0.0003 0.00031518936157227
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 = '415011'
                GROUP BY o.product_id
417 0.0003 0.00026392936706543
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     = '415011'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
418 0.0002 0.0001981258392334
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 415011
419 0.0005 0.00050497055053711
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '415011' AND a.name = n.originalname
420 0.0002 0.00017690658569336
SELECT * FROM productoffers WHERE product_id = '415011' AND merchantid = 'ATVPDKIKX0DER'
421 0.0002 0.00018191337585449
SELECT * FROM productoffers
                WHERE product_id = '415011' AND price > 0
                ORDER BY price ASC LIMIT 1
422 0.0002 0.00016093254089355
SELECT * FROM productoffers
                WHERE product_id = 415011
                ORDER BY price ASC LIMIT 1
423 0.0003 0.00027084350585938
SELECT value FROM productattributes
                WHERE product_id = '415011'
                AND name = 'ListPriceAmount'
424 0.0002 0.00022292137145996
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 = '415011'
                GROUP BY o.product_id
425 0.0002 0.00024700164794922
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     = '415011'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
426 0.0002 0.00019407272338867
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 415011
427 0.0004 0.00042891502380371
SELECT value FROM productattributes WHERE product_id = '415011' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
428 0.0003 0.0002598762512207
SELECT * FROM products WHERE parent_id = '415011'
429 0.0027 0.0026519298553467
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '414254' AND a.name = n.originalname
430 0.0002 0.00017499923706055
SELECT * FROM productoffers WHERE product_id = '414254' AND merchantid = 'ATVPDKIKX0DER'
431 0.0002 0.00017499923706055
SELECT * FROM productoffers
                WHERE product_id = '414254' AND price > 0
                ORDER BY price ASC LIMIT 1
432 0.0002 0.00016593933105469
SELECT * FROM productoffers
                WHERE product_id = 414254
                ORDER BY price ASC LIMIT 1
433 0.0002 0.00021600723266602
SELECT value FROM productattributes
                WHERE product_id = '414254'
                AND name = 'ListPriceAmount'
434 0.2498 0.24977993965149
SELECT *, MATCH (description, keyfeatures, title) AGAINST ('range' IN BOOLEAN MODE) AS `searchrelevance` FROM products WHERE MATCH (description, keyfeatures, title) AGAINST ('range' IN BOOLEAN MODE) AND 415011 <> 0 AND enabled = 1 AND hidden = 0 AND offers > 0 AND parent_id = 0 ORDER BY `searchrelevance` LIMIT 6
435 0.0003 0.00029993057250977
SELECT * FROM productimages WHERE product_id = '156961' ORDER BY sortorder ASC
436 0.0002 0.00022387504577637
SELECT * FROM product_image_select WHERE product_id = '156961'
437 0.0001 0.0001370906829834
SELECT * FROM productcustomimages WHERE product_id = '156961'
438 0.0017 0.0016849040985107
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '156961' AND a.name = n.originalname
439 0.0002 0.00019502639770508
SELECT * FROM productoffers WHERE product_id = '156961' AND merchantid = 'ATVPDKIKX0DER'
440 0.0002 0.00021195411682129
SELECT * FROM productoffers
                WHERE product_id = '156961' AND price > 0
                ORDER BY price ASC LIMIT 1
441 0.0003 0.00034689903259277
SELECT value FROM productattributes WHERE product_id = '156961' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
442 0.0001 0.00014209747314453
UPDATE products SET price = '36600' WHERE id = '156961'
443 0.0002 0.00020718574523926
SELECT * FROM productimages WHERE product_id = '37914' ORDER BY sortorder ASC
444 0.0002 0.00021195411682129
SELECT * FROM product_image_select WHERE product_id = '37914'
445 0.0001 0.00012016296386719
SELECT * FROM productcustomimages WHERE product_id = '37914'
446 0.0026 0.0026040077209473
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '37914' AND a.name = n.originalname
447 0.0002 0.00018596649169922
SELECT * FROM productoffers WHERE product_id = '37914' AND merchantid = 'ATVPDKIKX0DER'
448 0.0002 0.00019407272338867
SELECT * FROM productoffers
                WHERE product_id = '37914' AND price > 0
                ORDER BY price ASC LIMIT 1
449 0.0004 0.00038599967956543
SELECT value FROM productattributes WHERE product_id = '37914' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
450 0.0001 0.00013208389282227
UPDATE products SET price = '17718' WHERE id = '37914'
451 0.0002 0.00018811225891113
SELECT * FROM productimages WHERE product_id = '43519' ORDER BY sortorder ASC
452 0.0002 0.00020313262939453
SELECT * FROM product_image_select WHERE product_id = '43519'
453 0.0001 0.0001218318939209
SELECT * FROM productcustomimages WHERE product_id = '43519'
454 0.0027 0.0027179718017578
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '43519' AND a.name = n.originalname
455 0.0002 0.00018191337585449
SELECT * FROM productoffers WHERE product_id = '43519' AND merchantid = 'ATVPDKIKX0DER'
456 0.0002 0.00019502639770508
SELECT * FROM productoffers
                WHERE product_id = '43519' AND price > 0
                ORDER BY price ASC LIMIT 1
457 0.0003 0.00033807754516602
SELECT value FROM productattributes WHERE product_id = '43519' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
458 0.0001 0.00012302398681641
UPDATE products SET price = '1330' WHERE id = '43519'
459 0.0002 0.00023889541625977
SELECT * FROM productimages WHERE product_id = '134967' ORDER BY sortorder ASC
460 0.0002 0.00021600723266602
SELECT * FROM product_image_select WHERE product_id = '134967'
461 0.0001 0.00013399124145508
SELECT * FROM productcustomimages WHERE product_id = '134967'
462 0.0026 0.0025560855865479
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '134967' AND a.name = n.originalname
463 0.0002 0.00018191337585449
SELECT * FROM productoffers WHERE product_id = '134967' AND merchantid = 'ATVPDKIKX0DER'
464 0.0002 0.00020408630371094
SELECT * FROM productoffers
                WHERE product_id = '134967' AND price > 0
                ORDER BY price ASC LIMIT 1
465 0.0004 0.00038790702819824
SELECT value FROM productattributes WHERE product_id = '134967' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
466 0.0001 0.00012087821960449
UPDATE products SET price = '5185' WHERE id = '134967'
467 0.0002 0.00019192695617676
SELECT * FROM productimages WHERE product_id = '137543' ORDER BY sortorder ASC
468 0.0002 0.00022101402282715
SELECT * FROM product_image_select WHERE product_id = '137543'
469 0.0001 0.00012111663818359
SELECT * FROM productcustomimages WHERE product_id = '137543'
470 0.0034 0.0033547878265381
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '137543' AND a.name = n.originalname
471 0.0002 0.0001828670501709
SELECT * FROM productoffers WHERE product_id = '137543' AND merchantid = 'ATVPDKIKX0DER'
472 0.0002 0.00020289421081543
SELECT * FROM productoffers
                WHERE product_id = '137543' AND price > 0
                ORDER BY price ASC LIMIT 1
473 0.0004 0.00043082237243652
SELECT value FROM productattributes WHERE product_id = '137543' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
474 0.0001 0.00011920928955078
UPDATE products SET price = '2299' WHERE id = '137543'
475 0.0003 0.00030303001403809
SELECT * FROM productimages WHERE product_id = '130584' ORDER BY sortorder ASC
476 0.0002 0.00021600723266602
SELECT * FROM product_image_select WHERE product_id = '130584'
477 0.0001 0.00012087821960449
SELECT * FROM productcustomimages WHERE product_id = '130584'
478 0.0027 0.0026900768280029
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '130584' AND a.name = n.originalname
479 0.0002 0.00018906593322754
SELECT * FROM productoffers WHERE product_id = '130584' AND merchantid = 'ATVPDKIKX0DER'
480 0.0002 0.00020194053649902
SELECT * FROM productoffers
                WHERE product_id = '130584' AND price > 0
                ORDER BY price ASC LIMIT 1
481 0.0004 0.00038909912109375
SELECT value FROM productattributes WHERE product_id = '130584' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
482 0.0001 0.00012397766113281
UPDATE products SET price = '7999' WHERE id = '130584'
483 0.0001 0.00014209747314453
SELECT value FROM parameters WHERE parameter = 'EBAY_CACHE_TIME' 
484 0.0001 0.0001220703125
SELECT value FROM parameters WHERE parameter = 'EBAY_APP_ID' 
485 0.0001 0.00012016296386719
SELECT value FROM parameters WHERE parameter = 'EBAY_TRACKING_ID' 
486 0.0001 0.00011897087097168
SELECT value FROM parameters WHERE parameter = 'EBAY_NETWORK_ID' 
487 0.0001 0.00012898445129395
SELECT value FROM parameters WHERE parameter = 'EBAY_LOCALE' 
488 0.0001 0.00011992454528809
SELECT value FROM parameters WHERE parameter = 'EBAY_AUTH_TOKEN' 
489 0.0001 0.00013399124145508
SELECT * FROM ebay_locale_details WHERE cur_code = 'USD' 
490 0.1806 0.18063592910767
SELECT * FROM ebay_products_cache WHERE cachekey = 'f64360e58b442f7c94e4b98445f62f02' 
491 0.0003 0.00025796890258789
SELECT value FROM parameters WHERE parameter = 'EBAY_APP_ID' 
492 0.0001 0.00012397766113281
SELECT value FROM parameters WHERE parameter = 'EBAY_TRACKING_ID' 
493 0.0001 0.00012016296386719
SELECT value FROM parameters WHERE parameter = 'EBAY_NETWORK_ID' 
494 0.0001 0.00011897087097168
SELECT value FROM parameters WHERE parameter = 'EBAY_LOCALE' 
495 0.0001 0.00011897087097168
SELECT value FROM parameters WHERE parameter = 'EBAY_AUTH_TOKEN' 
496 0.1795 0.17949080467224
SELECT * FROM ebay_products_cache WHERE cachekey = 'f64360e58b442f7c94e4b98445f62f02' 
497 0.0003 0.00029683113098145
SELECT id,asin FROM products WHERE parent_id = 415011
498 0.0002 0.00021600723266602
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 414254
499 0.0003 0.00025677680969238
SELECT name,value FROM productoptions WHERE name="Color" AND product_id = 414254
500 0.0002 0.00019216537475586
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 414479
501 0.0002 0.00022292137145996
SELECT name,value FROM productoptions WHERE name="Color" AND product_id = 414479
502 0.0003 0.00032401084899902
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '415011' ORDER BY timestamp DESC
503 0.0002 0.0001528263092041
SELECT category_id FROM products_categories WHERE product_id = '415011'
504 0.0002 0.00018620491027832
SELECT * FROM categories WHERE id = '65'
505 0.0081 0.0081148147583008
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 = 65
506 0.0001 0.00013995170593262
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 65
507 0.0003 0.00026488304138184
SELECT id FROM categories WHERE parent_id = '65'
508 0.0080 0.0079998970031738
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (65)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
509 0.0002 0.00018596649169922
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (65)
				  AND p.disabled = 0 
510 0.0002 0.00015497207641602
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (65)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
511 0.0002 0.00017094612121582
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '65'
512 0.0005 0.00053310394287109
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '415011' AND a.name = n.originalname
513 0.0002 0.00018215179443359
SELECT * FROM productoffers WHERE product_id = '415011' AND merchantid = 'ATVPDKIKX0DER'
514 0.0002 0.00018906593322754
SELECT * FROM productoffers
                WHERE product_id = '415011' AND price > 0
                ORDER BY price ASC LIMIT 1
515 0.0002 0.00016403198242188
SELECT * FROM productoffers
                WHERE product_id = 415011
                ORDER BY price ASC LIMIT 1
516 0.0003 0.00026893615722656
SELECT value FROM productattributes
                WHERE product_id = '415011'
                AND name = 'ListPriceAmount'
517 0.0002 0.00021886825561523
SELECT * FROM products WHERE id = '415011'
518 0.0002 0.00023293495178223
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 = '415011'
                GROUP BY o.product_id
519 0.0003 0.00025701522827148
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     = '415011'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
520 0.0002 0.00019598007202148
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 415011
521 0.0004 0.00043201446533203
SELECT value FROM productattributes WHERE product_id = '415011' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
522 0.0005 0.00049519538879395
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '415011' AND a.name = n.originalname
523 0.0002 0.00017595291137695
SELECT * FROM productoffers WHERE product_id = '415011' AND merchantid = 'ATVPDKIKX0DER'
524 0.0002 0.00017905235290527
SELECT * FROM productoffers
                WHERE product_id = '415011' AND price > 0
                ORDER BY price ASC LIMIT 1
525 0.0002 0.00015997886657715
SELECT * FROM productoffers
                WHERE product_id = 415011
                ORDER BY price ASC LIMIT 1
526 0.0003 0.00026392936706543
SELECT value FROM productattributes
                WHERE product_id = '415011'
                AND name = 'ListPriceAmount'
527 0.0001 0.00013113021850586
SELECT category_id FROM products_categories WHERE product_id = '415011'
528 0.0001 0.00012016296386719
SELECT parent_id FROM categories WHERE id = '65'
529 0.0002 0.00017499923706055
SELECT * FROM categories WHERE id = '65'
530 0.0078 0.0077629089355469
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 = 65
531 0.0001 0.00014495849609375
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 65
532 0.0002 0.00024986267089844
SELECT id FROM categories WHERE parent_id = '65'
533 0.0080 0.0079710483551025
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (65)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
534 0.0002 0.00017094612121582
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (65)
				  AND p.disabled = 0 
535 0.0001 0.00014901161193848
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (65)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
536 0.0002 0.00016498565673828
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '65'
537 0.0002 0.00017213821411133
SELECT * FROM template_info WHERE templateuid = 'fsb-fluid'
538 0.0002 0.00017213821411133
SELECT * FROM pages WHERE id = 2
539 0.0001 0.00013899803161621
SELECT * FROM pages WHERE id = 4
540 0.0002 0.00015687942504883
SELECT * FROM pages WHERE id = 12
541 0.0001 0.00013899803161621
SELECT * FROM pages WHERE id = 10
542 0.0001 0.0001370906829834
SELECT * FROM pages WHERE id = 7
543 0.0001 0.00013995170593262
SELECT * FROM pages WHERE id = 18
544 0.0001 0.00013899803161621
SELECT * FROM pages WHERE id = 28
545 0.0001 0.00014305114746094
SELECT * FROM pages WHERE id = 13
546 0.0001 0.00014591217041016
SELECT * FROM pages WHERE id = 3
547 0.0427 0.042715072631836
SELECT p.id,p.parent_id, o.price FROM products p, productoffers o WHERE p.id = o.product_id AND p.parent_id = 0 AND hidden = 0 AND offers > 0 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 24
548 0.0002 0.00023818016052246
UPDATE template_options SET value = 'a:11:{s:14:\"populationtype\";s:9:\"automatic\";s:12:\"productcount\";s:1:\"6\";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\";s:0:\"\";s:10:\"updatetime\";s:5:\"86400\";s:13:\"selectiontype\";s:6:\"random\";s:11:\"lastupdated\";i:1560776169;s:8:\"products\";a:6:{i:4;s:6:\"410588\";i:8;s:6:\"183732\";i:21;s:6:\"410949\";i:5;s:6:\"404554\";i:15;s:6:\"406758\";i:17;s:6:\"408078\";}}' WHERE id = '175'
549 0.0005 0.00046706199645996
SELECT * FROM products WHERE id IN (410588,183732,410949,404554,406758,408078) ORDER BY FIELD(id, 410588,183732,410949,404554,406758,408078 )
550 0.0002 0.00021100044250488
SELECT * FROM productimages WHERE product_id = '410588' ORDER BY sortorder ASC
551 0.0002 0.00020909309387207
SELECT * FROM product_image_select WHERE product_id = '410588'
552 0.0001 0.00012493133544922
SELECT * FROM productcustomimages WHERE product_id = '410588'
553 0.0020 0.0020270347595215
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '410588' AND a.name = n.originalname
554 0.0002 0.00018596649169922
SELECT * FROM productoffers WHERE product_id = '410588' AND merchantid = 'ATVPDKIKX0DER'
555 0.0002 0.00020098686218262
SELECT * FROM productoffers
                WHERE product_id = '410588' AND price > 0
                ORDER BY price ASC LIMIT 1
556 0.0004 0.00037002563476562
SELECT value FROM productattributes WHERE product_id = '410588' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
557 0.0001 0.00012397766113281
UPDATE products SET price = '269999' WHERE id = '410588'
558 0.0002 0.00016903877258301
SELECT * FROM productimages WHERE product_id = '183732' ORDER BY sortorder ASC
559 0.0002 0.0002140998840332
SELECT * FROM product_image_select WHERE product_id = '183732'
560 0.0001 0.00013494491577148
SELECT * FROM productcustomimages WHERE product_id = '183732'
561 0.0027 0.002655029296875
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '183732' AND a.name = n.originalname
562 0.0002 0.00018215179443359
SELECT * FROM productoffers WHERE product_id = '183732' AND merchantid = 'ATVPDKIKX0DER'
563 0.0002 0.00020813941955566
SELECT * FROM productoffers
                WHERE product_id = '183732' AND price > 0
                ORDER BY price ASC LIMIT 1
564 0.0004 0.00038909912109375
SELECT value FROM productattributes WHERE product_id = '183732' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
565 0.0001 0.00012111663818359
UPDATE products SET price = '38249' WHERE id = '183732'
566 0.0002 0.00017094612121582
SELECT * FROM productimages WHERE product_id = '410949' ORDER BY sortorder ASC
567 0.0002 0.00021696090698242
SELECT * FROM product_image_select WHERE product_id = '410949'
568 0.0001 0.00012087821960449
SELECT * FROM productcustomimages WHERE product_id = '410949'
569 0.0027 0.0026760101318359
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '410949' AND a.name = n.originalname
570 0.0002 0.00018620491027832
SELECT * FROM productoffers WHERE product_id = '410949' AND merchantid = 'ATVPDKIKX0DER'
571 0.0002 0.00020098686218262
SELECT * FROM productoffers
                WHERE product_id = '410949' AND price > 0
                ORDER BY price ASC LIMIT 1
572 0.0004 0.00038909912109375
SELECT value FROM productattributes WHERE product_id = '410949' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
573 0.0001 0.00012803077697754
UPDATE products SET price = '47995' WHERE id = '410949'
574 0.0003 0.00027108192443848
SELECT * FROM productimages WHERE product_id = '404554' ORDER BY sortorder ASC
575 0.0002 0.00020599365234375
SELECT * FROM product_image_select WHERE product_id = '404554'
576 0.0001 0.00011897087097168
SELECT * FROM productcustomimages WHERE product_id = '404554'
577 0.0034 0.0033600330352783
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '404554' AND a.name = n.originalname
578 0.0002 0.00018310546875
SELECT * FROM productoffers WHERE product_id = '404554' AND merchantid = 'ATVPDKIKX0DER'
579 0.0002 0.00019621849060059
SELECT * FROM productoffers
                WHERE product_id = '404554' AND price > 0
                ORDER BY price ASC LIMIT 1
580 0.0005 0.00046300888061523
SELECT value FROM productattributes WHERE product_id = '404554' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
581 0.0001 0.00011897087097168
UPDATE products SET price = '399999' WHERE id = '404554'
582 0.0002 0.00018787384033203
SELECT * FROM productimages WHERE product_id = '406758' ORDER BY sortorder ASC
583 0.0002 0.00021600723266602
SELECT * FROM product_image_select WHERE product_id = '406758'
584 0.0001 0.00012016296386719
SELECT * FROM productcustomimages WHERE product_id = '406758'
585 0.0026 0.0026218891143799
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '406758' AND a.name = n.originalname
586 0.0002 0.00018501281738281
SELECT * FROM productoffers WHERE product_id = '406758' AND merchantid = 'ATVPDKIKX0DER'
587 0.0002 0.0001988410949707
SELECT * FROM productoffers
                WHERE product_id = '406758' AND price > 0
                ORDER BY price ASC LIMIT 1
588 0.0004 0.00039887428283691
SELECT value FROM productattributes WHERE product_id = '406758' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
589 0.0001 0.00012087821960449
UPDATE products SET price = '2694' WHERE id = '406758'
590 0.0002 0.00020408630371094
SELECT * FROM productimages WHERE product_id = '408078' ORDER BY sortorder ASC
591 0.0002 0.00021100044250488
SELECT * FROM product_image_select WHERE product_id = '408078'
592 0.0001 0.00013113021850586
SELECT * FROM productcustomimages WHERE product_id = '408078'
593 0.0031 0.0030529499053955
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '408078' AND a.name = n.originalname
594 0.0002 0.00018191337585449
SELECT * FROM productoffers WHERE product_id = '408078' AND merchantid = 'ATVPDKIKX0DER'
595 0.0002 0.00019502639770508
SELECT * FROM productoffers
                WHERE product_id = '408078' AND price > 0
                ORDER BY price ASC LIMIT 1
596 0.0004 0.00041389465332031
SELECT value FROM productattributes WHERE product_id = '408078' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
597 0.0001 0.0001227855682373
UPDATE products SET price = '23352' WHERE id = '408078'
598 0.0424 0.042382001876831
SELECT p.id,p.parent_id, o.price FROM products p, productoffers o WHERE p.id = o.product_id AND p.parent_id = 0 AND hidden = 0 AND offers > 0 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 24
599 0.0002 0.0002131462097168
UPDATE template_options SET value = 'a:10:{s:14:\"populationtype\";s:9:\"automatic\";s:12:\"productcount\";s:1:\"6\";s:12:\"maxsalesrank\";s:0:\"\";s:8:\"minprice\";s:1:\"0\";s:8:\"maxprice\";s:1:\"0\";s:9:\"minimages\";s:0:\"\";s:10:\"updatetime\";s:5:\"86400\";s:13:\"selectiontype\";s:6:\"random\";s:11:\"lastupdated\";i:1560776170;s:8:\"products\";a:6:{i:15;s:6:\"406758\";i:16;s:6:\"407620\";i:21;s:6:\"410949\";i:22;s:6:\"408079\";i:1;s:6:\"407595\";i:2;s:6:\"290575\";}}' WHERE id = '177'
600 0.0004 0.00043988227844238
SELECT * FROM products WHERE id IN (406758,407620,410949,408079,407595,290575) ORDER BY FIELD(id, 406758,407620,410949,408079,407595,290575 )
601 0.0002 0.0001978874206543
SELECT * FROM productimages WHERE product_id = '406758' ORDER BY sortorder ASC
602 0.0002 0.00020503997802734
SELECT * FROM product_image_select WHERE product_id = '406758'
603 0.0001 0.00011992454528809
SELECT * FROM productcustomimages WHERE product_id = '406758'
604 0.0026 0.0026288032531738
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '406758' AND a.name = n.originalname
605 0.0002 0.00018596649169922
SELECT * FROM productoffers WHERE product_id = '406758' AND merchantid = 'ATVPDKIKX0DER'
606 0.0002 0.00021195411682129
SELECT * FROM productoffers
                WHERE product_id = '406758' AND price > 0
                ORDER BY price ASC LIMIT 1
607 0.0004 0.00038790702819824
SELECT value FROM productattributes WHERE product_id = '406758' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
608 0.0001 0.0001218318939209
UPDATE products SET price = '2694' WHERE id = '406758'
609 0.0002 0.00020003318786621
SELECT * FROM productimages WHERE product_id = '407620' ORDER BY sortorder ASC
610 0.0002 0.00021791458129883
SELECT * FROM product_image_select WHERE product_id = '407620'
611 0.0001 0.00012111663818359
SELECT * FROM productcustomimages WHERE product_id = '407620'
612 0.0023 0.0022759437561035
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '407620' AND a.name = n.originalname
613 0.0002 0.00018095970153809
SELECT * FROM productoffers WHERE product_id = '407620' AND merchantid = 'ATVPDKIKX0DER'
614 0.0002 0.00019598007202148
SELECT * FROM productoffers
                WHERE product_id = '407620' AND price > 0
                ORDER BY price ASC LIMIT 1
615 0.0004 0.00037217140197754
SELECT value FROM productattributes WHERE product_id = '407620' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
616 0.0001 0.00011897087097168
UPDATE products SET price = '20323' WHERE id = '407620'
617 0.0002 0.0001680850982666
SELECT * FROM productimages WHERE product_id = '410949' ORDER BY sortorder ASC
618 0.0002 0.00021600723266602
SELECT * FROM product_image_select WHERE product_id = '410949'
619 0.0001 0.00013113021850586
SELECT * FROM productcustomimages WHERE product_id = '410949'
620 0.0027 0.002655029296875
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '410949' AND a.name = n.originalname
621 0.0002 0.00019598007202148
SELECT * FROM productoffers WHERE product_id = '410949' AND merchantid = 'ATVPDKIKX0DER'
622 0.0002 0.00020194053649902
SELECT * FROM productoffers
                WHERE product_id = '410949' AND price > 0
                ORDER BY price ASC LIMIT 1
623 0.0004 0.00039005279541016
SELECT value FROM productattributes WHERE product_id = '410949' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
624 0.0001 0.00012016296386719
UPDATE products SET price = '47995' WHERE id = '410949'
625 0.0002 0.00018405914306641
SELECT * FROM productimages WHERE product_id = '408079' ORDER BY sortorder ASC
626 0.0002 0.00021100044250488
SELECT * FROM product_image_select WHERE product_id = '408079'
627 0.0001 0.00011992454528809
SELECT * FROM productcustomimages WHERE product_id = '408079'
628 0.0032 0.0032088756561279
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '408079' AND a.name = n.originalname
629 0.0002 0.00018596649169922
SELECT * FROM productoffers WHERE product_id = '408079' AND merchantid = 'ATVPDKIKX0DER'
630 0.0002 0.00021100044250488
SELECT * FROM productoffers
                WHERE product_id = '408079' AND price > 0
                ORDER BY price ASC LIMIT 1
631 0.0004 0.00042891502380371
SELECT value FROM productattributes WHERE product_id = '408079' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
632 0.0001 0.00012516975402832
UPDATE products SET price = '20106' WHERE id = '408079'
633 0.0002 0.00023508071899414
SELECT * FROM productimages WHERE product_id = '407595' ORDER BY sortorder ASC
634 0.0002 0.00022101402282715
SELECT * FROM product_image_select WHERE product_id = '407595'
635 0.0001 0.00012087821960449
SELECT * FROM productcustomimages WHERE product_id = '407595'
636 0.0034 0.0033588409423828
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '407595' AND a.name = n.originalname
637 0.0002 0.00019407272338867
SELECT * FROM productoffers WHERE product_id = '407595' AND merchantid = 'ATVPDKIKX0DER'
638 0.0002 0.00020289421081543
SELECT * FROM productoffers
                WHERE product_id = '407595' AND price > 0
                ORDER BY price ASC LIMIT 1
639 0.0004 0.0004270076751709
SELECT value FROM productattributes WHERE product_id = '407595' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
640 0.0001 0.00012111663818359
UPDATE products SET price = '2497' WHERE id = '407595'
641 0.0006 0.00058698654174805
SELECT * FROM productimages WHERE product_id = '290575' ORDER BY sortorder ASC
642 0.0002 0.00021910667419434
SELECT * FROM product_image_select WHERE product_id = '290575'
643 0.0001 0.0001220703125
SELECT * FROM productcustomimages WHERE product_id = '290575'
644 0.0034 0.0034098625183105
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '290575' AND a.name = n.originalname
645 0.0002 0.0001838207244873
SELECT * FROM productoffers WHERE product_id = '290575' AND merchantid = 'ATVPDKIKX0DER'
646 0.0002 0.00019502639770508
SELECT * FROM productoffers
                WHERE product_id = '290575' AND price > 0
                ORDER BY price ASC LIMIT 1
647 0.0004 0.00043702125549316
SELECT value FROM productattributes WHERE product_id = '290575' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
648 0.0001 0.00011992454528809
UPDATE products SET price = '549500' WHERE id = '290575'
649 0.1041 0.10410690307617
SELECT p.id,p.parent_id, o.price 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 24
650 0.0003 0.00027990341186523
UPDATE template_options SET value = 'a:11:{s:14:\"populationtype\";s:9:\"automatic\";s:12:\"productcount\";s:1:\"6\";s:12:\"maxsalesrank\";s:0:\"\";s:8:\"minprice\";s:1:\"0\";s:8:\"maxprice\";s:1:\"0\";s:9:\"minimages\";s:1:\"1\";s:10:\"categories\";s:0:\"\";s:10:\"updatetime\";s:5:\"86400\";s:13:\"selectiontype\";s:6:\"random\";s:11:\"lastupdated\";i:1560776170;s:8:\"products\";a:6:{i:8;s:6:\"183732\";i:12;s:6:\"403517\";i:18;s:6:\"127345\";i:23;s:6:\"406901\";i:5;s:6:\"404554\";i:11;s:6:\"370121\";}}' WHERE id = '181'
651 0.0005 0.00046181678771973
SELECT * FROM products WHERE id IN (183732,403517,127345,406901,404554,370121) ORDER BY FIELD(id, 183732,403517,127345,406901,404554,370121 )
652 0.0002 0.00018000602722168
SELECT * FROM productimages WHERE product_id = '183732' ORDER BY sortorder ASC
653 0.0002 0.00022292137145996
SELECT * FROM product_image_select WHERE product_id = '183732'
654 0.0001 0.00012588500976562
SELECT * FROM productcustomimages WHERE product_id = '183732'
655 0.0027 0.0026829242706299
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '183732' AND a.name = n.originalname
656 0.0002 0.00018787384033203
SELECT * FROM productoffers WHERE product_id = '183732' AND merchantid = 'ATVPDKIKX0DER'
657 0.0002 0.00020313262939453
SELECT * FROM productoffers
                WHERE product_id = '183732' AND price > 0
                ORDER BY price ASC LIMIT 1
658 0.0004 0.00039005279541016
SELECT value FROM productattributes WHERE product_id = '183732' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
659 0.0001 0.00012397766113281
UPDATE products SET price = '38249' WHERE id = '183732'
660 0.0003 0.00026178359985352
SELECT * FROM productimages WHERE product_id = '403517' ORDER BY sortorder ASC
661 0.0002 0.0002129077911377
SELECT * FROM product_image_select WHERE product_id = '403517'
662 0.0001 0.0001220703125
SELECT * FROM productcustomimages WHERE product_id = '403517'
663 0.0030 0.0029618740081787
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '403517' AND a.name = n.originalname
664 0.0002 0.00018405914306641
SELECT * FROM productoffers WHERE product_id = '403517' AND merchantid = 'ATVPDKIKX0DER'
665 0.0002 0.00020599365234375
SELECT * FROM productoffers
                WHERE product_id = '403517' AND price > 0
                ORDER BY price ASC LIMIT 1
666 0.0004 0.00040912628173828
SELECT value FROM productattributes WHERE product_id = '403517' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
667 0.0001 0.00012087821960449
UPDATE products SET price = '6699' WHERE id = '403517'
668 0.0003 0.00029611587524414
SELECT * FROM productimages WHERE product_id = '127345' ORDER BY sortorder ASC
669 0.0002 0.00020480155944824
SELECT * FROM product_image_select WHERE product_id = '127345'
670 0.0001 0.00012016296386719
SELECT * FROM productcustomimages WHERE product_id = '127345'
671 0.0026 0.0026299953460693
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '127345' AND a.name = n.originalname
672 0.0002 0.00018191337585449
SELECT * FROM productoffers WHERE product_id = '127345' AND merchantid = 'ATVPDKIKX0DER'
673 0.0002 0.00019407272338867
SELECT * FROM productoffers
                WHERE product_id = '127345' AND price > 0
                ORDER BY price ASC LIMIT 1
674 0.0004 0.00038409233093262
SELECT value FROM productattributes WHERE product_id = '127345' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
675 0.0001 0.00013303756713867
UPDATE products SET price = '21963' WHERE id = '127345'
676 0.0002 0.00019288063049316
SELECT * FROM productimages WHERE product_id = '406901' ORDER BY sortorder ASC
677 0.0002 0.00021505355834961
SELECT * FROM product_image_select WHERE product_id = '406901'
678 0.0001 0.00012087821960449
SELECT * FROM productcustomimages WHERE product_id = '406901'
679 0.0023 0.0023379325866699
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '406901' AND a.name = n.originalname
680 0.0002 0.00018191337585449
SELECT * FROM productoffers WHERE product_id = '406901' AND merchantid = 'ATVPDKIKX0DER'
681 0.0002 0.00019383430480957
SELECT * FROM productoffers
                WHERE product_id = '406901' AND price > 0
                ORDER BY price ASC LIMIT 1
682 0.0003 0.00034093856811523
SELECT value FROM productattributes WHERE product_id = '406901' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
683 0.0001 0.00012993812561035
UPDATE products SET price = '395' WHERE id = '406901'
684 0.0003 0.00026893615722656
SELECT * FROM productimages WHERE product_id = '404554' ORDER BY sortorder ASC
685 0.0002 0.00020408630371094
SELECT * FROM product_image_select WHERE product_id = '404554'
686 0.0001 0.00012016296386719
SELECT * FROM productcustomimages WHERE product_id = '404554'
687 0.0033 0.0033349990844727
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '404554' AND a.name = n.originalname
688 0.0002 0.00018215179443359
SELECT * FROM productoffers WHERE product_id = '404554' AND merchantid = 'ATVPDKIKX0DER'
689 0.0002 0.00019502639770508
SELECT * FROM productoffers
                WHERE product_id = '404554' AND price > 0
                ORDER BY price ASC LIMIT 1
690 0.0004 0.00044488906860352
SELECT value FROM productattributes WHERE product_id = '404554' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
691 0.0001 0.00011992454528809
UPDATE products SET price = '399999' WHERE id = '404554'
692 0.0002 0.00018620491027832
SELECT * FROM productimages WHERE product_id = '370121' ORDER BY sortorder ASC
693 0.0002 0.00021791458129883
SELECT * FROM product_image_select WHERE product_id = '370121'
694 0.0001 0.00012087821960449
SELECT * FROM productcustomimages WHERE product_id = '370121'
695 0.0027 0.0027461051940918
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '370121' AND a.name = n.originalname
696 0.0002 0.00018596649169922
SELECT * FROM productoffers WHERE product_id = '370121' AND merchantid = 'ATVPDKIKX0DER'
697 0.0002 0.00020098686218262
SELECT * FROM productoffers
                WHERE product_id = '370121' AND price > 0
                ORDER BY price ASC LIMIT 1
698 0.0004 0.00039219856262207
SELECT value FROM productattributes WHERE product_id = '370121' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
699 0.0001 0.00011992454528809
UPDATE products SET price = '9899' WHERE id = '370121'
700 0.1037 0.10365414619446
SELECT p.id,p.parent_id, o.price 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 24
701 0.0003 0.00026607513427734
UPDATE template_options SET value = 'a:10:{s:14:\"populationtype\";s:9:\"automatic\";s:12:\"productcount\";s:1:\"6\";s:12:\"maxsalesrank\";s:0:\"\";s:8:\"minprice\";s:1:\"0\";s:8:\"maxprice\";s:1:\"0\";s:9:\"minimages\";s:1:\"1\";s:10:\"updatetime\";s:5:\"86400\";s:13:\"selectiontype\";s:6:\"random\";s:11:\"lastupdated\";i:1560776170;s:8:\"products\";a:6:{i:11;s:6:\"370121\";i:17;s:6:\"408078\";i:19;s:6:\"405644\";i:20;s:6:\"131163\";i:21;s:6:\"410949\";i:5;s:6:\"404554\";}}' WHERE id = '183'
702 0.0005 0.00048089027404785
SELECT * FROM products WHERE id IN (370121,408078,405644,131163,410949,404554) ORDER BY FIELD(id, 370121,408078,405644,131163,410949,404554 )
703 0.0002 0.00020194053649902
SELECT * FROM productimages WHERE product_id = '370121' ORDER BY sortorder ASC
704 0.0002 0.00020885467529297
SELECT * FROM product_image_select WHERE product_id = '370121'
705 0.0001 0.0001220703125
SELECT * FROM productcustomimages WHERE product_id = '370121'
706 0.0028 0.0027909278869629
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '370121' AND a.name = n.originalname
707 0.0002 0.00019598007202148
SELECT * FROM productoffers WHERE product_id = '370121' AND merchantid = 'ATVPDKIKX0DER'
708 0.0002 0.00022292137145996
SELECT * FROM productoffers
                WHERE product_id = '370121' AND price > 0
                ORDER BY price ASC LIMIT 1
709 0.0004 0.0003960132598877
SELECT value FROM productattributes WHERE product_id = '370121' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
710 0.0001 0.0001218318939209
UPDATE products SET price = '9899' WHERE id = '370121'
711 0.0002 0.00020098686218262
SELECT * FROM productimages WHERE product_id = '408078' ORDER BY sortorder ASC
712 0.0002 0.00021600723266602
SELECT * FROM product_image_select WHERE product_id = '408078'
713 0.0001 0.0001220703125
SELECT * FROM productcustomimages WHERE product_id = '408078'
714 0.0031 0.0030801296234131
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '408078' AND a.name = n.originalname
715 0.0002 0.00018310546875
SELECT * FROM productoffers WHERE product_id = '408078' AND merchantid = 'ATVPDKIKX0DER'
716 0.0002 0.00019502639770508
SELECT * FROM productoffers
                WHERE product_id = '408078' AND price > 0
                ORDER BY price ASC LIMIT 1
717 0.0004 0.00041890144348145
SELECT value FROM productattributes WHERE product_id = '408078' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
718 0.0001 0.0001227855682373
UPDATE products SET price = '23352' WHERE id = '408078'
719 0.0002 0.00018000602722168
SELECT * FROM productimages WHERE product_id = '405644' ORDER BY sortorder ASC
720 0.0002 0.00021696090698242
SELECT * FROM product_image_select WHERE product_id = '405644'
721 0.0001 0.00011992454528809
SELECT * FROM productcustomimages WHERE product_id = '405644'
722 0.0034 0.0033669471740723
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '405644' AND a.name = n.originalname
723 0.0002 0.00018310546875
SELECT * FROM productoffers WHERE product_id = '405644' AND merchantid = 'ATVPDKIKX0DER'
724 0.0002 0.00019502639770508
SELECT * FROM productoffers
                WHERE product_id = '405644' AND price > 0
                ORDER BY price ASC LIMIT 1
725 0.0004 0.00043678283691406
SELECT value FROM productattributes WHERE product_id = '405644' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
726 0.0001 0.00012087821960449
UPDATE products SET price = '63539' WHERE id = '405644'
727 0.0002 0.00021719932556152
SELECT * FROM productimages WHERE product_id = '131163' ORDER BY sortorder ASC
728 0.0002 0.00021100044250488
SELECT * FROM product_image_select WHERE product_id = '131163'
729 0.0001 0.00012993812561035
SELECT * FROM productcustomimages WHERE product_id = '131163'
730 0.0026 0.0025529861450195
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '131163' AND a.name = n.originalname
731 0.0002 0.00018405914306641
SELECT * FROM productoffers WHERE product_id = '131163' AND merchantid = 'ATVPDKIKX0DER'
732 0.0002 0.00021004676818848
SELECT * FROM productoffers
                WHERE product_id = '131163' AND price > 0
                ORDER BY price ASC LIMIT 1
733 0.0004 0.00038385391235352
SELECT value FROM productattributes WHERE product_id = '131163' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
734 0.0001 0.00011801719665527
UPDATE products SET price = '20362' WHERE id = '131163'
735 0.0002 0.0001680850982666
SELECT * FROM productimages WHERE product_id = '410949' ORDER BY sortorder ASC
736 0.0002 0.00021195411682129
SELECT * FROM product_image_select WHERE product_id = '410949'
737 0.0001 0.0001218318939209
SELECT * FROM productcustomimages WHERE product_id = '410949'
738 0.0027 0.0026700496673584
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '410949' AND a.name = n.originalname
739 0.0002 0.00019216537475586
SELECT * FROM productoffers WHERE product_id = '410949' AND merchantid = 'ATVPDKIKX0DER'
740 0.0002 0.00020217895507812
SELECT * FROM productoffers
                WHERE product_id = '410949' AND price > 0
                ORDER BY price ASC LIMIT 1
741 0.0004 0.00038886070251465
SELECT value FROM productattributes WHERE product_id = '410949' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
742 0.0001 0.00011920928955078
UPDATE products SET price = '47995' WHERE id = '410949'
743 0.0003 0.00027585029602051
SELECT * FROM productimages WHERE product_id = '404554' ORDER BY sortorder ASC
744 0.0002 0.00020694732666016
SELECT * FROM product_image_select WHERE product_id = '404554'
745 0.0001 0.00011992454528809
SELECT * FROM productcustomimages WHERE product_id = '404554'
746 0.0033 0.0033369064331055
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '404554' AND a.name = n.originalname
747 0.0002 0.00018405914306641
SELECT * FROM productoffers WHERE product_id = '404554' AND merchantid = 'ATVPDKIKX0DER'
748 0.0002 0.00019693374633789
SELECT * FROM productoffers
                WHERE product_id = '404554' AND price > 0
                ORDER BY price ASC LIMIT 1
749 0.0004 0.00044417381286621
SELECT value FROM productattributes WHERE product_id = '404554' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
750 0.0001 0.00012803077697754
UPDATE products SET price = '399999' WHERE id = '404554'
751 0.0004 0.00040411949157715
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid' AND area = 'header' ORDER BY sortorder ASC
752 0.0001 0.00013279914855957
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
753 0.0001 0.00013208389282227
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
754 0.0001 0.0001220703125
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
755 0.0001 0.00011897087097168
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
756 0.0004 0.00039410591125488
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid' AND area = 'footer' ORDER BY sortorder ASC
757 0.0001 0.00013613700866699
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
758 0.0001 0.00011992454528809
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
759 0.0001 0.00011682510375977
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
760 0.0009 0.00090599060058594
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-fluid' AND skinuid = ''
761 0.0003 0.0003049373626709
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid'
762 0.0003 0.00028204917907715
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid'
763 0.0004 0.00042319297790527
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid' AND imageuid = 'HEAD_CUSTOM_BANNER'
764 0.0004 0.0003509521484375
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid' AND imageuid = 'HEAD_CUSTOM_BANNER'