Tactical Equipment - Survivalist Equipment

HiViz Sig P-Series Lite Wave Rear Sight Handgun by HiViz

Price: $62.95 $36.08
Product prices and availability are accurate as of 2019-06-11 12:37:32 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.
You Save: $26.87 (43%)
Availability: In Stock
Usually ships in 24 hours
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

Our Combat Gear shop is proud to stock the beneficial HiViz Sig P-Series Lite Wave Rear Sight Handgun today at this low price.

With so many competing tactical, combat and survival products available these days, it is wise to have a name that you can trust. The HiViz Sig P-Series Lite Wave Rear Sight Handgun is certainly all that and will be a excellent purchase for your combat kit or tactical ability.

We pride ourselves to provide the highest quality survival gear for all your on the job requirements.

For this reduced price, the HiViz Sig P-Series Lite Wave Rear Sight Handgun is greatly respected and is always a popular choice for lots of like minded people. HiViz have produced some great touches and this results in better value for money.

Manufacturer Description

Hi-Viz rear sight for Sig Sauer P-Series. New lite wave rear sight design permit interchangeable colors fits all P-Series Sig handguns, other than the champions-250 the Sight's height is the same as the Sig # 8. All steel building and construction consists of lite pipes in Red, green and black. SGLW18 model.

Product Features

Interchangeable lite wave style rear sight, includes three lite pipe sets in green, Red and black Lite pipes store in lite pipe changing key Fits all p-series sig pistols except P250

Write a Review

Debug Overview

App Total Time DB Queries DB Query Total Time Amazon Requests
3.8345201015472 738 2.0237 0


No Amazon API Requests Made.


App Debug - Total Time 3.8345201015472 seconds

Number Time From Start Name Description
1 0.46926808357239 Initialise Initialise FSB Function
2 0.47167611122131 App Controller Start Start of the App controller (called before the controller of every page)
3 0.48310899734497 Start of getCategoryListByGroup Function Before first category groups query
4 0.48328113555908 After initial query Before first category groups query
5 0.4832820892334 Get Category List for Group Before the call to getCategoryList function
6 0.48328614234924 Start of GetCategoryList function Start of the function
7 0.48329210281372 Before getting categories Query to get specific category list
8 0.48391318321228 After getting categories Query to get specific category list
9 0.48391509056091 Before getting category custom Before call to function getCategoryCustom
10 0.48575615882874 After getting category custom After call to function getCategoryCustom
11 0.48575806617737 Before getting category custom Before call to function getCategoryCustom
12 0.49617314338684 After getting category custom After call to function getCategoryCustom
13 0.49617719650269 Before getting category custom Before call to function getCategoryCustom
14 0.50175809860229 After getting category custom After call to function getCategoryCustom
15 0.50176119804382 Before getting category custom Before call to function getCategoryCustom
16 0.50590205192566 After getting category custom After call to function getCategoryCustom
17 0.5059061050415 End of GetCategoryList function End of the function
18 0.50591897964478 Get Category List for Group Before the call to getCategoryList function
19 0.5059220790863 Start of GetCategoryList function Start of the function
20 0.50592517852783 Before getting categories Query to get specific category list
21 0.50635099411011 After getting categories Query to get specific category list
22 0.506352186203 Before getting category custom Before call to function getCategoryCustom
23 0.5119481086731 After getting category custom After call to function getCategoryCustom
24 0.51195216178894 Before getting category custom Before call to function getCategoryCustom
25 0.52272319793701 After getting category custom After call to function getCategoryCustom
26 0.52272605895996 End of GetCategoryList function End of the function
27 0.52273607254028 Get Category List for Group Before the call to getCategoryList function
28 0.52274012565613 Start of GetCategoryList function Start of the function
29 0.52274298667908 Before getting categories Query to get specific category list
30 0.52359008789062 After getting categories Query to get specific category list
31 0.52359199523926 Before getting category custom Before call to function getCategoryCustom
32 0.53289198875427 After getting category custom After call to function getCategoryCustom
33 0.53289604187012 Before getting category custom Before call to function getCategoryCustom
34 0.55051517486572 After getting category custom After call to function getCategoryCustom
35 0.55051898956299 Before getting category custom Before call to function getCategoryCustom
36 0.55647397041321 After getting category custom After call to function getCategoryCustom
37 0.55647706985474 Before getting category custom Before call to function getCategoryCustom
38 0.56245112419128 After getting category custom After call to function getCategoryCustom
39 0.56245398521423 Before getting category custom Before call to function getCategoryCustom
40 0.56879615783691 After getting category custom After call to function getCategoryCustom
41 0.56879997253418 Before getting category custom Before call to function getCategoryCustom
42 0.59114098548889 After getting category custom After call to function getCategoryCustom
43 0.59114503860474 Before getting category custom Before call to function getCategoryCustom
44 0.59531116485596 After getting category custom After call to function getCategoryCustom
45 0.59531402587891 Before getting category custom Before call to function getCategoryCustom
46 0.59999299049377 After getting category custom After call to function getCategoryCustom
47 0.5999960899353 End of GetCategoryList function End of the function
48 0.60001015663147 Get Category List for Group Before the call to getCategoryList function
49 0.60001301765442 Start of GetCategoryList function Start of the function
50 0.60001611709595 Before getting categories Query to get specific category list
51 0.60045003890991 After getting categories Query to get specific category list
52 0.60045218467712 Before getting category custom Before call to function getCategoryCustom
53 0.60278415679932 After getting category custom After call to function getCategoryCustom
54 0.60278606414795 Before getting category custom Before call to function getCategoryCustom
55 0.60512709617615 After getting category custom After call to function getCategoryCustom
56 0.60512900352478 End of GetCategoryList function End of the function
57 0.60513806343079 Get Category List for Group Before the call to getCategoryList function
58 0.60513997077942 Start of GetCategoryList function Start of the function
59 0.60514307022095 Before getting categories Query to get specific category list
60 0.60545206069946 After getting categories Query to get specific category list
61 0.60545301437378 Before getting category custom Before call to function getCategoryCustom
62 0.61045217514038 After getting category custom After call to function getCategoryCustom
63 0.61045503616333 End of GetCategoryList function End of the function
64 0.61046409606934 End of getCategoryListByGroup Function Before return()
65 0.66508412361145 App Controller End End of the App controller (called before the controller of every page)
66 0.6657600402832 Product Start Start of the product info controller
67 0.66679906845093 Cache file not found Starting get product details
68 0.6852560043335 Related products Start getting related products if enabled
69 0.68525815010071 Related Products Start Before the related products are found
70 0.68525910377502 Related Products Keywords Before the related product keywords are found
71 0.68526911735535 Create Keyword List Function Start of function
72 0.68608617782593 Create Keyword List Function After looping provided content - 500 keywords found
73 0.71965718269348 Create Keyword List Function After looping initial keyword list - 455 keywords remaining
74 0.71977806091309 Create Keyword List Function After reducing keyword list
75 0.72085499763489 Create Keyword List Function After selecting by scoring keywords
76 0.72086000442505 Create Keyword List Function After final loop of keywords
77 0.72086405754089 Related Products Keywords After the related product keywords are found
78 0.98484897613525 Related Products End After the related products are found
79 1.178973197937 Start Remote Request http://svcs.ebay.com/services/search/FindingServic...
80 1.4654181003571 End Remote Request http://svcs.ebay.com/services/search/FindingServic...
81 1.6767761707306 Start Remote Request http://svcs.ebay.com/services/search/FindingServic...
82 1.9605731964111 End Remote Request http://svcs.ebay.com/services/search/FindingServic...
83 2.1681311130524 Start Remote Request http://svcs.ebay.com/services/search/FindingServic...
84 2.4512281417847 End Remote Request http://svcs.ebay.com/services/search/FindingServic...
85 2.7068619728088 Product End End of the product info controller (Product Info)
86 2.7072780132294 App_after Controller Start Start of the App_after controller (called after the controller of every page)
87 2.7074081897736 Before Get Options Before the call to getOptions in the tpl class
88 3.410845041275 After Get Options After the call to getOptions in the tpl class
89 3.4111390113831 App_after Controller End End of the App_after controller (called after the controller of every page)
90 3.4111540317535 Product Info: Before Smarty Fetch Before the product.tpl template is fetched
91 3.6220030784607 Product Info: After Smarty Fetch After the product.tpl template is fetched
92 3.6220099925995 Product Info: Before Template Display Before the template is displayed
93 3.8344941139221 Product Info: After Template Display After the template is displayed
94 3.8345010280609 Finalizing debug Before the debug is output to the page.
95 3.8345191478729 End of App This is the end of the app logging, final timestamp


Query Debug - 738 Database Queries. Total time 2.0237 seconds

Number Time (Seconds) Time (Milliseconds) Query
1 0.0002 0.0001680850982666
SELECT value FROM parameters WHERE `parameter` = 'BAD_BOTS_ENABLER'
2 0.0006 0.00058484077453613
SHOW TABLES LIKE 'bad_bots'
3 0.0002 0.0002281665802002
SELECT value FROM parameters WHERE `parameter` = 'STORE_WHITELISTED_IPS'
4 0.0002 0.00017285346984863
SELECT * FROM `bad_bots`
5 0.0007 0.00074887275695801
SELECT parameter, value FROM parameters
6 0.0002 0.0001680850982666
SET time_zone = 'Europe/London'
7 0.0004 0.00038909912109375
SELECT * FROM autorun ORDER BY lastrun ASC
8 0.0001 0.00014805793762207
SELECT * FROM version ORDER BY installed DESC LIMIT 1
9 0.0001 0.00013089179992676
delete from cachefiles
10 0.0002 0.000244140625
SELECT id FROM pages WHERE pagename = 'hiviz-sig-p-series-lite-wave-rear-sight-handgun' LIMIT 1
11 0.0002 0.00023007392883301
SELECT id FROM products WHERE pagename = 'hiviz-sig-p-series-lite-wave-rear-sight-handgun' AND hidden = 0 LIMIT 1
12 0.0008 0.00076103210449219
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-fluid'
13 0.0091 0.0090839862823486
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-fluid' AND language = 'en'
14 0.0003 0.00025296211242676
SELECT * FROM pages WHERE pagename = 'hiviz-sig-p-series-lite-wave-rear-sight-handgun'
15 0.0002 0.00015592575073242
SELECT * FROM categorygroups ORDER BY sortorder ASC
16 0.0005 0.00052714347839355
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
17 0.0005 0.00046086311340332
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.0002 0.0002288818359375
SELECT id FROM categories WHERE parent_id = '49'
19 0.0004 0.00043201446533203
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.00015020370483398
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.00015115737915039
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.00018191337585449
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '49'
23 0.0001 0.00012516975402832
SELECT * FROM categorygroups WHERE id = '1'
24 0.0030 0.0029568672180176
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.00025081634521484
SELECT id FROM categories WHERE parent_id = '50'
26 0.0002 0.00020194053649902
SELECT id FROM categories WHERE parent_id = '96'
27 0.0002 0.00019693374633789
SELECT id FROM categories WHERE parent_id = '97'
28 0.0002 0.0002131462097168
SELECT id FROM categories WHERE parent_id = '111'
29 0.0002 0.0001981258392334
SELECT id FROM categories WHERE parent_id = '129'
30 0.0056 0.0056171417236328
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.00017809867858887
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.00015807151794434
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.00017404556274414
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '50'
34 0.0001 0.00012779235839844
SELECT * FROM categorygroups WHERE id = '1'
35 0.0023 0.0022640228271484
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.00028800964355469
SELECT id FROM categories WHERE parent_id = '80'
37 0.0023 0.0023019313812256
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.00015377998352051
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.0001518726348877
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.00017189979553223
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '80'
41 0.0001 0.00012898445129395
SELECT * FROM categorygroups WHERE id = '1'
42 0.0012 0.0011510848999023
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.00026082992553711
SELECT id FROM categories WHERE parent_id = '51'
44 0.0002 0.00020503997802734
SELECT id FROM categories WHERE parent_id = '101'
45 0.0018 0.0017960071563721
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.00015878677368164
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.00016093254089355
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.00017213821411133
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '51'
49 0.0001 0.00012397766113281
SELECT * FROM categorygroups WHERE id = '1'
50 0.0004 0.00040006637573242
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '2'  AND hidden = 0 ORDER BY sortorder ASC
51 0.0023 0.0023109912872314
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.00025296211242676
SELECT id FROM categories WHERE parent_id = '30'
53 0.0023 0.002302885055542
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.00015997886657715
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.00017499923706055
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
57 0.0001 0.00012803077697754
SELECT * FROM categorygroups WHERE id = '2'
58 0.0048 0.0048229694366455
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.00030183792114258
SELECT id FROM categories WHERE parent_id = '61'
60 0.0049 0.004871129989624
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.00016903877258301
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.00015592575073242
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.00018000602722168
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '61'
64 0.0001 0.00012993812561035
SELECT * FROM categorygroups WHERE id = '2'
65 0.0007 0.00066685676574707
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '10'  AND hidden = 0 ORDER BY sortorder ASC
66 0.0041 0.0040969848632812
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.00028705596923828
SELECT id FROM categories WHERE parent_id = '64'
68 0.0041 0.0041389465332031
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.00017714500427246
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.00015997886657715
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.00017404556274414
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '64'
72 0.0001 0.00013113021850586
SELECT * FROM categorygroups WHERE id = '10'
73 0.0081 0.008105993270874
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.00033903121948242
SELECT id FROM categories WHERE parent_id = '65'
75 0.0083 0.0083417892456055
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.0002129077911377
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.00016188621520996
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.00018692016601562
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '65'
79 0.0001 0.00013208389282227
SELECT * FROM categorygroups WHERE id = '10'
80 0.0025 0.0024611949920654
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.0002892017364502
SELECT id FROM categories WHERE parent_id = '81'
82 0.0025 0.0024700164794922
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.00015497207641602
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.0001521110534668
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.00016403198242188
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '81'
86 0.0001 0.00012707710266113
SELECT * FROM categorygroups WHERE id = '10'
87 0.0025 0.0024619102478027
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.00028085708618164
SELECT id FROM categories WHERE parent_id = '31'
89 0.0025 0.0025029182434082
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.00015687942504883
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.00015091896057129
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.00017213821411133
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
93 0.0001 0.00012683868408203
SELECT * FROM categorygroups WHERE id = '10'
94 0.0023 0.0022640228271484
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.0002739429473877
SELECT id FROM categories WHERE parent_id = '66'
96 0.0002 0.00020384788513184
SELECT id FROM categories WHERE parent_id = '131'
97 0.0029 0.0028581619262695
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.00016403198242188
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.00015401840209961
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.00017595291137695
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '66'
101 0.0001 0.00012803077697754
SELECT * FROM categorygroups WHERE id = '10'
102 0.0095 0.0095090866088867
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.0004 0.00039815902709961
SELECT id FROM categories WHERE parent_id = '34'
104 0.0002 0.00021100044250488
SELECT id FROM categories WHERE parent_id = '94'
105 0.0002 0.00020408630371094
SELECT id FROM categories WHERE parent_id = '98'
106 0.0002 0.00020098686218262
SELECT id FROM categories WHERE parent_id = '99'
107 0.0002 0.00021004676818848
SELECT id FROM categories WHERE parent_id = '110'
108 0.0002 0.0001990795135498
SELECT id FROM categories WHERE parent_id = '130'
109 0.0104 0.010434150695801
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.0003 0.0002589225769043
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.00016903877258301
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.00020384788513184
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '34'
113 0.0001 0.00013422966003418
SELECT * FROM categorygroups WHERE id = '10'
114 0.0016 0.0015769004821777
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.00028300285339355
SELECT id FROM categories WHERE parent_id = '32'
116 0.0016 0.0016059875488281
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.00015902519226074
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.00015091896057129
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.00016498565673828
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '32'
120 0.0001 0.00012588500976562
SELECT * FROM categorygroups WHERE id = '10'
121 0.0018 0.0018479824066162
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.00026392936706543
SELECT id FROM categories WHERE parent_id = '89'
123 0.0019 0.0018620491027832
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.0001518726348877
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.00015687942504883
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.00016999244689941
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '89'
127 0.0001 0.00012612342834473
SELECT * FROM categorygroups WHERE id = '10'
128 0.0004 0.0003972053527832
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '17'  AND hidden = 0 ORDER BY sortorder ASC
129 0.0007 0.00069403648376465
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.0002 0.00023293495178223
SELECT id FROM categories WHERE parent_id = '84'
131 0.0007 0.00070405006408691
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.00014686584472656
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.0001 0.00014805793762207
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.00017499923706055
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '84'
135 0.0001 0.00012803077697754
SELECT * FROM categorygroups WHERE id = '17'
136 0.0007 0.00069999694824219
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.00024008750915527
SELECT id FROM categories WHERE parent_id = '90'
138 0.0007 0.00072288513183594
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.00015807151794434
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.0001 0.00014495849609375
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.00015616416931152
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '90'
142 0.0001 0.0001220703125
SELECT * FROM categorygroups WHERE id = '17'
143 0.0003 0.00029420852661133
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '20'  AND hidden = 0 ORDER BY sortorder ASC
144 0.0020 0.0020179748535156
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.00025105476379395
SELECT id FROM categories WHERE parent_id = '92'
146 0.0020 0.0020320415496826
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.0001530647277832
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.00015091896057129
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.00015091896057129
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '92'
150 0.0001 0.00012707710266113
SELECT * FROM categorygroups WHERE id = '20'
151 0.0052 0.0051791667938232
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
152 0.0004 0.00040006637573242
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-fluid' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
153 0.0003 0.00028705596923828
SELECT value FROM parameters WHERE parameter = 'EBAY_APP_ID' 
154 0.0002 0.00017118453979492
SELECT * FROM sideboxes_pages WHERE sidebox_id = '1'
155 0.0002 0.00017595291137695
SELECT * FROM pages WHERE id = '67'
156 0.0002 0.00016903877258301
SELECT * FROM pages WHERE id = '82'
157 0.0002 0.00016188621520996
SELECT * FROM pages WHERE id = '84'
158 0.0001 0.00014615058898926
SELECT * FROM pages WHERE id = '94'
159 0.0002 0.00015497207641602
SELECT * FROM pages WHERE id = '116'
160 0.0002 0.00021910667419434
SELECT * FROM pages WHERE id = '52'
161 0.0002 0.00016689300537109
SELECT * FROM pages WHERE id = '135'
162 0.0002 0.00015497207641602
SELECT * FROM pages WHERE id = '245'
163 0.0002 0.00017499923706055
SELECT * FROM pages WHERE id = '269'
164 0.0002 0.00020599365234375
SELECT * FROM pages WHERE id = '275'
165 0.0002 0.00019097328186035
SELECT * FROM pages WHERE id = '280'
166 0.0002 0.00020503997802734
SELECT * FROM pages WHERE id = '357'
167 0.0001 0.00014591217041016
SELECT * FROM pages WHERE id = '379'
168 0.0001 0.00014185905456543
SELECT * FROM pages WHERE id = '401'
169 0.0002 0.00015497207641602
SELECT * FROM pages WHERE id = '450'
170 0.0002 0.0001671314239502
SELECT * FROM pages WHERE id = '454'
171 0.0002 0.00016903877258301
SELECT * FROM pages WHERE id = '457'
172 0.0002 0.00015497207641602
SELECT * FROM pages WHERE id = '458'
173 0.0002 0.0001680850982666
SELECT * FROM sideboxes_pages WHERE sidebox_id = '2'
174 0.0002 0.00016403198242188
SELECT * FROM pages WHERE id = '41'
175 0.0002 0.00016617774963379
SELECT * FROM pages WHERE id = '43'
176 0.0002 0.00018000602722168
SELECT * FROM pages WHERE id = '44'
177 0.0002 0.00015091896057129
SELECT * FROM pages WHERE id = '68'
178 0.0002 0.00021195411682129
SELECT * FROM pages WHERE id = '80'
179 0.0002 0.00016593933105469
SELECT * FROM pages WHERE id = '85'
180 0.0002 0.00015497207641602
SELECT * FROM pages WHERE id = '97'
181 0.0002 0.00017309188842773
SELECT * FROM pages WHERE id = '107'
182 0.0002 0.00015497207641602
SELECT * FROM pages WHERE id = '108'
183 0.0001 0.00013899803161621
SELECT * FROM pages WHERE id = '128'
184 0.0002 0.00017499923706055
SELECT * FROM pages WHERE id = '133'
185 0.0002 0.00016093254089355
SELECT * FROM pages WHERE id = '148'
186 0.0002 0.00016999244689941
SELECT * FROM pages WHERE id = '217'
187 0.0001 0.00014996528625488
SELECT * FROM pages WHERE id = '228'
188 0.0002 0.00016498565673828
SELECT * FROM pages WHERE id = '257'
189 0.0002 0.0001671314239502
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.00017499923706055
SELECT * FROM pages WHERE id = '291'
193 0.0002 0.00015711784362793
SELECT * FROM pages WHERE id = '380'
194 0.0002 0.00015711784362793
SELECT * FROM pages WHERE id = '344'
195 0.0002 0.00017905235290527
SELECT * FROM pages WHERE id = '354'
196 0.0002 0.0001978874206543
SELECT * FROM pages WHERE id = '363'
197 0.0002 0.00020408630371094
SELECT * FROM pages WHERE id = '364'
198 0.0001 0.00014805793762207
SELECT * FROM pages WHERE id = '368'
199 0.0002 0.00017499923706055
SELECT * FROM pages WHERE id = '369'
200 0.0001 0.00014996528625488
SELECT * FROM pages WHERE id = '400'
201 0.0002 0.00016307830810547
SELECT * FROM pages WHERE id = '463'
202 0.0002 0.00019288063049316
SELECT * FROM sideboxes_pages WHERE sidebox_id = '33'
203 0.0003 0.00030303001403809
SELECT * FROM pages WHERE id = '66'
204 0.0002 0.0001981258392334
SELECT * FROM pages WHERE id = '77'
205 0.0002 0.00020694732666016
SELECT * FROM pages WHERE id = '90'
206 0.0002 0.00015401840209961
SELECT * FROM pages WHERE id = '414'
207 0.0002 0.0001530647277832
SELECT * FROM pages WHERE id = '119'
208 0.0002 0.00017404556274414
SELECT * FROM pages WHERE id = '406'
209 0.0002 0.0001518726348877
SELECT * FROM pages WHERE id = '149'
210 0.0002 0.00015497207641602
SELECT * FROM pages WHERE id = '150'
211 0.0001 0.00014686584472656
SELECT * FROM pages WHERE id = '412'
212 0.0002 0.00016307830810547
SELECT * FROM pages WHERE id = '162'
213 0.0001 0.00014615058898926
SELECT * FROM pages WHERE id = '164'
214 0.0001 0.00014400482177734
SELECT * FROM pages WHERE id = '167'
215 0.0001 0.00014090538024902
SELECT * FROM pages WHERE id = '180'
216 0.0002 0.00016999244689941
SELECT * FROM pages WHERE id = '187'
217 0.0002 0.00020599365234375
SELECT * FROM pages WHERE id = '265'
218 0.0002 0.00015878677368164
SELECT * FROM pages WHERE id = '268'
219 0.0002 0.00015807151794434
SELECT * FROM pages WHERE id = '411'
220 0.0002 0.00015807151794434
SELECT * FROM pages WHERE id = '290'
221 0.0001 0.00014114379882812
SELECT * FROM pages WHERE id = '413'
222 0.0001 0.00014901161193848
SELECT * FROM pages WHERE id = '409'
223 0.0002 0.00015711784362793
SELECT * FROM pages WHERE id = '327'
224 0.0001 0.00014996528625488
SELECT * FROM pages WHERE id = '336'
225 0.0002 0.00015783309936523
SELECT * FROM pages WHERE id = '351'
226 0.0002 0.00015783309936523
SELECT * FROM pages WHERE id = '358'
227 0.0002 0.00017380714416504
SELECT * FROM pages WHERE id = '360'
228 0.0002 0.00015687942504883
SELECT * FROM pages WHERE id = '362'
229 0.0002 0.00016689300537109
SELECT * FROM pages WHERE id = '366'
230 0.0002 0.00016498565673828
SELECT * FROM pages WHERE id = '370'
231 0.0002 0.0001530647277832
SELECT * FROM pages WHERE id = '377'
232 0.0002 0.00017309188842773
SELECT * FROM pages WHERE id = '386'
233 0.0001 0.00014901161193848
SELECT * FROM pages WHERE id = '408'
234 0.0001 0.00014495849609375
SELECT * FROM pages WHERE id = '415'
235 0.0002 0.00018596649169922
SELECT * FROM pages WHERE id = '416'
236 0.0002 0.00020003318786621
SELECT * FROM pages WHERE id = '419'
237 0.0002 0.00016593933105469
SELECT * FROM pages WHERE id = '423'
238 0.0002 0.0001680850982666
SELECT * FROM pages WHERE id = '427'
239 0.0002 0.00018787384033203
SELECT * FROM pages WHERE id = '428'
240 0.0001 0.00014400482177734
SELECT * FROM pages WHERE id = '432'
241 0.0002 0.00015902519226074
SELECT * FROM pages WHERE id = '433'
242 0.0002 0.00016188621520996
SELECT * FROM pages WHERE id = '436'
243 0.0002 0.00015592575073242
SELECT * FROM pages WHERE id = '437'
244 0.0002 0.00015401840209961
SELECT * FROM pages WHERE id = '461'
245 0.0002 0.00018191337585449
SELECT * FROM pages WHERE id = '464'
246 0.0002 0.00015091896057129
SELECT * FROM sideboxes_pages WHERE sidebox_id = '34'
247 0.0002 0.00016403198242188
SELECT * FROM pages WHERE id = '74'
248 0.0002 0.00015497207641602
SELECT * FROM pages WHERE id = '137'
249 0.0002 0.0001518726348877
SELECT * FROM pages WHERE id = '145'
250 0.0001 0.00014996528625488
SELECT * FROM pages WHERE id = '156'
251 0.0002 0.00015807151794434
SELECT * FROM pages WHERE id = '407'
252 0.0001 0.00014281272888184
SELECT * FROM pages WHERE id = '410'
253 0.0002 0.00019097328186035
SELECT * FROM pages WHERE id = '266'
254 0.0002 0.00023102760314941
SELECT * FROM pages WHERE id = '316'
255 0.0002 0.00015377998352051
SELECT * FROM pages WHERE id = '332'
256 0.0002 0.00018692016601562
SELECT * FROM pages WHERE id = '334'
257 0.0002 0.00015115737915039
SELECT * FROM pages WHERE id = '367'
258 0.0002 0.00015997886657715
SELECT * FROM pages WHERE id = '387'
259 0.0002 0.00015497207641602
SELECT * FROM pages WHERE id = '389'
260 0.0002 0.00016188621520996
SELECT * FROM pages WHERE id = '397'
261 0.0002 0.00015711784362793
SELECT * FROM pages WHERE id = '449'
262 0.0002 0.00016403198242188
SELECT * FROM sideboxes_pages WHERE sidebox_id = '35'
263 0.0002 0.00020909309387207
SELECT * FROM pages WHERE id = '42'
264 0.0002 0.00016283988952637
SELECT * FROM pages WHERE id = '79'
265 0.0002 0.00016093254089355
SELECT * FROM pages WHERE id = '86'
266 0.0001 0.00014805793762207
SELECT * FROM pages WHERE id = '95'
267 0.0002 0.0001680850982666
SELECT * FROM pages WHERE id = '102'
268 0.0002 0.00015997886657715
SELECT * FROM pages WHERE id = '109'
269 0.0002 0.00022292137145996
SELECT * FROM pages WHERE id = '114'
270 0.0002 0.00019097328186035
SELECT * FROM pages WHERE id = '121'
271 0.0002 0.00020194053649902
SELECT * FROM pages WHERE id = '138'
272 0.0002 0.00016093254089355
SELECT * FROM pages WHERE id = '142'
273 0.0002 0.00020909309387207
SELECT * FROM pages WHERE id = '62'
274 0.0001 0.00014805793762207
SELECT * FROM pages WHERE id = '157'
275 0.0002 0.0001678466796875
SELECT * FROM pages WHERE id = '246'
276 0.0002 0.0001981258392334
SELECT * FROM pages WHERE id = '276'
277 0.0002 0.00019001960754395
SELECT * FROM pages WHERE id = '278'
278 0.0002 0.00022983551025391
SELECT * FROM pages WHERE id = '279'
279 0.0002 0.00016403198242188
SELECT * FROM pages WHERE id = '317'
280 0.0002 0.00015521049499512
SELECT * FROM pages WHERE id = '405'
281 0.0002 0.00018906593322754
SELECT * FROM pages WHERE id = '343'
282 0.0002 0.00016403198242188
SELECT * FROM pages WHERE id = '345'
283 0.0002 0.00020217895507812
SELECT * FROM pages WHERE id = '346'
284 0.0002 0.00017404556274414
SELECT * FROM pages WHERE id = '347'
285 0.0002 0.00016117095947266
SELECT * FROM pages WHERE id = '348'
286 0.0002 0.00015616416931152
SELECT * FROM pages WHERE id = '349'
287 0.0002 0.00017189979553223
SELECT * FROM pages WHERE id = '381'
288 0.0002 0.0001530647277832
SELECT * FROM pages WHERE id = '392'
289 0.0002 0.00015115737915039
SELECT * FROM pages WHERE id = '393'
290 0.0002 0.00015902519226074
SELECT * FROM pages WHERE id = '394'
291 0.0002 0.00015592575073242
SELECT * FROM pages WHERE id = '395'
292 0.0002 0.00016093254089355
SELECT * FROM pages WHERE id = '399'
293 0.0002 0.00016403198242188
SELECT * FROM pages WHERE id = '421'
294 0.0001 0.00014615058898926
SELECT * FROM pages WHERE id = '426'
295 0.0001 0.00014305114746094
SELECT * FROM pages WHERE id = '430'
296 0.0001 0.00014591217041016
SELECT * FROM pages WHERE id = '431'
297 0.0002 0.00016593933105469
SELECT * FROM pages WHERE id = '434'
298 0.0002 0.00017619132995605
SELECT * FROM pages WHERE id = '435'
299 0.0002 0.00017213821411133
SELECT * FROM pages WHERE id = '440'
300 0.0002 0.0001680850982666
SELECT * FROM pages WHERE id = '441'
301 0.0001 0.00014996528625488
SELECT * FROM pages WHERE id = '451'
302 0.0001 0.00014710426330566
SELECT * FROM pages WHERE id = '453'
303 0.0002 0.00016117095947266
SELECT * FROM sideboxes_pages WHERE sidebox_id = '37'
304 0.0002 0.00016999244689941
SELECT * FROM pages WHERE id = '146'
305 0.0001 0.00014686584472656
SELECT * FROM pages WHERE id = '158'
306 0.0001 0.00014114379882812
SELECT * FROM pages WHERE id = '163'
307 0.0002 0.00022292137145996
SELECT * FROM pages WHERE id = '293'
308 0.0002 0.00015902519226074
SELECT * FROM pages WHERE id = '340'
309 0.0002 0.00015902519226074
SELECT * FROM pages WHERE id = '417'
310 0.0001 0.00014114379882812
SELECT * FROM sideboxes_pages WHERE sidebox_id = '40'
311 0.0002 0.00017809867858887
SELECT * FROM pages WHERE id = '173'
312 0.0002 0.00015783309936523
SELECT * FROM pages WHERE id = '181'
313 0.0001 0.00014805793762207
SELECT * FROM pages WHERE id = '288'
314 0.0002 0.00017905235290527
SELECT * FROM pages WHERE id = '299'
315 0.0002 0.0001530647277832
SELECT * FROM pages WHERE id = '300'
316 0.0002 0.00016093254089355
SELECT * FROM pages WHERE id = '383'
317 0.0002 0.00015592575073242
SELECT * FROM pages WHERE id = '385'
318 0.0002 0.00015997886657715
SELECT * FROM pages WHERE id = '438'
319 0.0002 0.00016999244689941
SELECT * FROM pages WHERE id = '442'
320 0.0002 0.00015497207641602
SELECT * FROM sideboxes_pages WHERE sidebox_id = '38'
321 0.0003 0.00025105476379395
SELECT * FROM pages WHERE id = '103'
322 0.0002 0.0002288818359375
SELECT * FROM pages WHERE id = '134'
323 0.0002 0.00015687942504883
SELECT * FROM pages WHERE id = '139'
324 0.0002 0.00015616416931152
SELECT * FROM pages WHERE id = '143'
325 0.0002 0.00015616416931152
SELECT * FROM pages WHERE id = '234'
326 0.0002 0.00016903877258301
SELECT * FROM pages WHERE id = '248'
327 0.0001 0.00014615058898926
SELECT * FROM pages WHERE id = '260'
328 0.0002 0.00015687942504883
SELECT * FROM pages WHERE id = '398'
329 0.0002 0.00017595291137695
SELECT * FROM sideboxes_pages WHERE sidebox_id = '29'
330 0.0002 0.00017595291137695
SELECT * FROM pages WHERE id = '61'
331 0.0002 0.00015997886657715
SELECT * FROM pages WHERE id = '87'
332 0.0002 0.00017094612121582
SELECT * FROM pages WHERE id = '104'
333 0.0002 0.00020599365234375
SELECT * FROM pages WHERE id = '115'
334 0.0001 0.00014686584472656
SELECT * FROM pages WHERE id = '124'
335 0.0002 0.00016403198242188
SELECT * FROM pages WHERE id = '144'
336 0.0002 0.00017499923706055
SELECT * FROM pages WHERE id = '151'
337 0.0001 0.00014996528625488
SELECT * FROM pages WHERE id = '199'
338 0.0002 0.00016117095947266
SELECT * FROM pages WHERE id = '200'
339 0.0001 0.00014710426330566
SELECT * FROM pages WHERE id = '304'
340 0.0001 0.00014400482177734
SELECT * FROM pages WHERE id = '321'
341 0.0002 0.00015616416931152
SELECT * FROM pages WHERE id = '333'
342 0.0002 0.0001678466796875
SELECT * FROM pages WHERE id = '350'
343 0.0001 0.00014495849609375
SELECT * FROM pages WHERE id = '378'
344 0.0002 0.00016093254089355
SELECT * FROM pages WHERE id = '422'
345 0.0002 0.00018405914306641
SELECT * FROM pages WHERE id = '425'
346 0.0001 0.00014305114746094
SELECT * FROM pages WHERE id = '443'
347 0.0002 0.0001530647277832
SELECT * FROM pages WHERE id = '444'
348 0.0001 0.00014901161193848
SELECT * FROM pages WHERE id = '445'
349 0.0002 0.00015401840209961
SELECT * FROM pages WHERE id = '446'
350 0.0002 0.00015807151794434
SELECT * FROM pages WHERE id = '447'
351 0.0002 0.00015711784362793
SELECT * FROM pages WHERE id = '448'
352 0.0001 0.00014686584472656
SELECT * FROM pages WHERE id = '455'
353 0.0002 0.00015401840209961
SELECT * FROM pages WHERE id = '456'
354 0.0001 0.00013995170593262
SELECT * FROM pages WHERE id = '459'
355 0.0002 0.00015902519226074
SELECT * FROM pages WHERE id = '460'
356 0.0001 0.00014996528625488
SELECT * FROM pages WHERE id = '462'
357 0.0001 0.00014400482177734
SELECT * FROM sideboxes_pages WHERE sidebox_id = '32'
358 0.0002 0.00018310546875
SELECT * FROM pages WHERE id = '153'
359 0.0002 0.00021600723266602
SELECT * FROM pages WHERE id = '182'
360 0.0001 0.00014901161193848
SELECT * FROM pages WHERE id = '238'
361 0.0001 0.00014400482177734
SELECT * FROM pages WHERE id = '240'
362 0.0002 0.00015091896057129
SELECT * FROM pages WHERE id = '242'
363 0.0001 0.0001380443572998
SELECT * FROM pages WHERE id = '252'
364 0.0001 0.00014019012451172
SELECT * FROM pages WHERE id = '253'
365 0.0001 0.00014400482177734
SELECT * FROM pages WHERE id = '262'
366 0.0001 0.00014400482177734
SELECT * FROM pages WHERE id = '267'
367 0.0002 0.0001530647277832
SELECT * FROM pages WHERE id = '420'
368 0.0001 0.00014090538024902
SELECT value FROM parameters WHERE parameter = 'GOOGLE_SITE_KEY' 
369 0.0001 0.00013089179992676
SELECT value FROM parameters WHERE parameter = 'GOOGLE_SECRET_KEY' 
370 0.0001 0.00011897087097168
SELECT value FROM parameters WHERE parameter = 'GOOGLE_RECAPTCHA_TYPE' 
371 0.0015 0.0015230178833008
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
372 0.0002 0.00017905235290527
SELECT value FROM parameters WHERE parameter = 'GOOGLE_SITE_KEY' 
373 0.0001 0.00013279914855957
SELECT value FROM parameters WHERE parameter = 'GOOGLE_SECRET_KEY' 
374 0.0001 0.00011992454528809
SELECT value FROM parameters WHERE parameter = 'GOOGLE_RECAPTCHA_TYPE' 
375 0.0003 0.00029516220092773
SELECT * FROM products WHERE pagename = 'hiviz-sig-p-series-lite-wave-rear-sight-handgun'
376 0.0002 0.00017905235290527
SELECT * FROM manufacturers WHERE id = '2223'
377 0.0005 0.00048112869262695
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '2223'
378 0.0001 0.00012493133544922
SELECT filename FROM manufacturerimages WHERE manufacturer_id = '2223' LIMIT 1
379 0.0004 0.0004119873046875
SELECT pagename, id FROM products p WHERE manufacturer_id = '2223' ORDER BY RAND() LIMIT 1
380 0.0002 0.00021600723266602
SELECT * FROM productimages WHERE product_id = '404728' ORDER BY sortorder ASC
381 0.0004 0.0004119873046875
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '2223'
382 0.0004 0.00044798851013184
SELECT COUNT(DISTINCT(p.id)) FROM products p
				WHERE p.manufacturer_id = '2223'
				  AND p.hidden = 0
				  AND p.enabled = 1
				  AND p.parent_id = 0 
383 0.0001 0.00011897087097168
SELECT * FROM manufacturerimages WHERE manufacturer_id = '2223'
384 0.0001 0.00013399124145508
SELECT category_id FROM products_categories WHERE product_id = '406031'
385 0.0002 0.00021195411682129
SELECT * FROM categories WHERE id = '64'
386 0.0043 0.0042500495910645
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
387 0.0001 0.00014495849609375
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 64
388 0.0003 0.00027012825012207
SELECT id FROM categories WHERE parent_id = '64'
389 0.0043 0.0042719841003418
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 
390 0.0002 0.00018119812011719
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 
391 0.0002 0.00015401840209961
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 
392 0.0002 0.00017404556274414
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '64'
393 0.0002 0.00023698806762695
SELECT * FROM productimages WHERE product_id = '406031' ORDER BY sortorder ASC
394 0.0002 0.00020790100097656
SELECT * FROM product_image_select WHERE product_id = '406031'
395 0.0001 0.00012683868408203
SELECT * FROM productcustomimages WHERE product_id = '406031'
396 0.0001 0.00012803077697754
SELECT * FROM productfeeds WHERE product_id = '406031' ORDER BY item_date DESC
397 0.0003 0.00034809112548828
SELECT a.name, n.displayname, a.value, n.units, n.valuetype FROM productattributes a, productattributenames n WHERE product_id = '406031' AND a.name = n.originalname AND n.display = 1 AND n.hidden = 0
398 0.0003 0.00029897689819336
SELECT DISTINCT(pt.tag_id) FROM product_tags pt, tags t WHERE pt.tag_id = t.id AND pt.product_id = '406031' AND t.hidden = 0 AND display_product = 1
399 0.0002 0.00016498565673828
SELECT * FROM productamazoncontent WHERE product_id = '406031'
400 0.0029 0.002910852432251
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '406031' AND a.name = n.originalname
401 0.0002 0.00020194053649902
SELECT * FROM productoffers WHERE product_id = '406031' AND merchantid = 'ATVPDKIKX0DER'
402 0.0002 0.00022697448730469
SELECT * FROM productoffers
                WHERE product_id = '406031' AND price > 0
                ORDER BY price ASC LIMIT 1
403 0.0004 0.00042200088500977
SELECT value FROM productattributes WHERE product_id = '406031' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
404 0.0001 0.00014209747314453
UPDATE products SET price = '3608' WHERE id = '406031'
405 0.2375 0.23746085166931
SELECT *, MATCH (description, keyfeatures, title) AGAINST ('hiviz' IN BOOLEAN MODE) AS `searchrelevance` FROM products WHERE MATCH (description, keyfeatures, title) AGAINST ('hiviz' IN BOOLEAN MODE) AND 406031 <> 0 AND enabled = 1 AND hidden = 0 AND offers > 0 AND parent_id = 0 ORDER BY `searchrelevance` LIMIT 6
406 0.0004 0.00039100646972656
SELECT * FROM productimages WHERE product_id = '142052' ORDER BY sortorder ASC
407 0.0002 0.00024604797363281
SELECT * FROM product_image_select WHERE product_id = '142052'
408 0.0001 0.00012612342834473
SELECT * FROM productcustomimages WHERE product_id = '142052'
409 0.0030 0.00301194190979
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '142052' AND a.name = n.originalname
410 0.0002 0.0001990795135498
SELECT * FROM productoffers WHERE product_id = '142052' AND merchantid = 'ATVPDKIKX0DER'
411 0.0002 0.00020694732666016
SELECT * FROM productoffers
                WHERE product_id = '142052' AND price > 0
                ORDER BY price ASC LIMIT 1
412 0.0004 0.00040698051452637
SELECT value FROM productattributes WHERE product_id = '142052' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
413 0.0001 0.00014305114746094
UPDATE products SET price = '2682' WHERE id = '142052'
414 0.0002 0.00020909309387207
SELECT * FROM productimages WHERE product_id = '173842' ORDER BY sortorder ASC
415 0.0002 0.00020599365234375
SELECT * FROM product_image_select WHERE product_id = '173842'
416 0.0001 0.0001220703125
SELECT * FROM productcustomimages WHERE product_id = '173842'
417 0.0024 0.0023891925811768
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '173842' AND a.name = n.originalname
418 0.0002 0.00019097328186035
SELECT * FROM productoffers WHERE product_id = '173842' AND merchantid = 'ATVPDKIKX0DER'
419 0.0002 0.00020289421081543
SELECT * FROM productoffers
                WHERE product_id = '173842' AND price > 0
                ORDER BY price ASC LIMIT 1
420 0.0004 0.00037407875061035
SELECT value FROM productattributes WHERE product_id = '173842' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
421 0.0001 0.00012111663818359
UPDATE products SET price = '5499' WHERE id = '173842'
422 0.0002 0.00019288063049316
SELECT * FROM productimages WHERE product_id = '134601' ORDER BY sortorder ASC
423 0.0002 0.00021004676818848
SELECT * FROM product_image_select WHERE product_id = '134601'
424 0.0001 0.00012397766113281
SELECT * FROM productcustomimages WHERE product_id = '134601'
425 0.0024 0.0024449825286865
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '134601' AND a.name = n.originalname
426 0.0002 0.00018596649169922
SELECT * FROM productoffers WHERE product_id = '134601' AND merchantid = 'ATVPDKIKX0DER'
427 0.0002 0.00019717216491699
SELECT * FROM productoffers
                WHERE product_id = '134601' AND price > 0
                ORDER BY price ASC LIMIT 1
428 0.0004 0.00037693977355957
SELECT value FROM productattributes WHERE product_id = '134601' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
429 0.0001 0.00013399124145508
UPDATE products SET price = '2691' WHERE id = '134601'
430 0.0002 0.00024795532226562
SELECT * FROM productimages WHERE product_id = '146781' ORDER BY sortorder ASC
431 0.0002 0.00021719932556152
SELECT * FROM product_image_select WHERE product_id = '146781'
432 0.0001 0.00012302398681641
SELECT * FROM productcustomimages WHERE product_id = '146781'
433 0.0023 0.0022900104522705
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '146781' AND a.name = n.originalname
434 0.0002 0.00018906593322754
SELECT * FROM productoffers WHERE product_id = '146781' AND merchantid = 'ATVPDKIKX0DER'
435 0.0002 0.00020098686218262
SELECT * FROM productoffers
                WHERE product_id = '146781' AND price > 0
                ORDER BY price ASC LIMIT 1
436 0.0004 0.00036907196044922
SELECT value FROM productattributes WHERE product_id = '146781' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
437 0.0001 0.00012898445129395
UPDATE products SET price = '2266' WHERE id = '146781'
438 0.0002 0.00023412704467773
SELECT * FROM productimages WHERE product_id = '264794' ORDER BY sortorder ASC
439 0.0002 0.0002129077911377
SELECT * FROM product_image_select WHERE product_id = '264794'
440 0.0001 0.00012516975402832
SELECT * FROM productcustomimages WHERE product_id = '264794'
441 0.0025 0.0025420188903809
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '264794' AND a.name = n.originalname
442 0.0002 0.00018882751464844
SELECT * FROM productoffers WHERE product_id = '264794' AND merchantid = 'ATVPDKIKX0DER'
443 0.0002 0.00022220611572266
SELECT * FROM productoffers
                WHERE product_id = '264794' AND price > 0
                ORDER BY price ASC LIMIT 1
444 0.0004 0.00039887428283691
SELECT value FROM productattributes WHERE product_id = '264794' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
445 0.0001 0.00012397766113281
UPDATE products SET price = '3195' WHERE id = '264794'
446 0.0002 0.00021481513977051
SELECT * FROM productimages WHERE product_id = '264795' ORDER BY sortorder ASC
447 0.0002 0.0002138614654541
SELECT * FROM product_image_select WHERE product_id = '264795'
448 0.0001 0.00012516975402832
SELECT * FROM productcustomimages WHERE product_id = '264795'
449 0.0032 0.0031769275665283
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '264795' AND a.name = n.originalname
450 0.0002 0.00020217895507812
SELECT * FROM productoffers WHERE product_id = '264795' AND merchantid = 'ATVPDKIKX0DER'
451 0.0002 0.00020623207092285
SELECT * FROM productoffers
                WHERE product_id = '264795' AND price > 0
                ORDER BY price ASC LIMIT 1
452 0.0004 0.00042986869812012
SELECT value FROM productattributes WHERE product_id = '264795' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
453 0.0001 0.00012493133544922
UPDATE products SET price = '3465' WHERE id = '264795'
454 0.0001 0.00014400482177734
SELECT value FROM parameters WHERE parameter = 'EBAY_CACHE_TIME' 
455 0.0001 0.00012588500976562
SELECT value FROM parameters WHERE parameter = 'EBAY_APP_ID' 
456 0.0001 0.00012993812561035
SELECT value FROM parameters WHERE parameter = 'EBAY_TRACKING_ID' 
457 0.0001 0.00012588500976562
SELECT value FROM parameters WHERE parameter = 'EBAY_NETWORK_ID' 
458 0.0001 0.00012302398681641
SELECT value FROM parameters WHERE parameter = 'EBAY_LOCALE' 
459 0.0001 0.00012087821960449
SELECT value FROM parameters WHERE parameter = 'EBAY_AUTH_TOKEN' 
460 0.0001 0.00013995170593262
SELECT * FROM ebay_locale_details WHERE cur_code = 'USD' 
461 0.1920 0.19197487831116
SELECT * FROM ebay_products_cache WHERE cachekey = '648ae9de5917ca97ed4f65fca43a4a1e' 
462 0.0002 0.00024318695068359
SELECT value FROM parameters WHERE parameter = 'EBAY_APP_ID' 
463 0.0001 0.00013399124145508
SELECT value FROM parameters WHERE parameter = 'EBAY_TRACKING_ID' 
464 0.0001 0.00012493133544922
SELECT value FROM parameters WHERE parameter = 'EBAY_NETWORK_ID' 
465 0.0001 0.0001218318939209
SELECT value FROM parameters WHERE parameter = 'EBAY_LOCALE' 
466 0.0001 0.00011992454528809
SELECT value FROM parameters WHERE parameter = 'EBAY_AUTH_TOKEN' 
467 0.2100 0.20996689796448
SELECT * FROM ebay_products_cache WHERE cachekey = '648ae9de5917ca97ed4f65fca43a4a1e' 
468 0.0003 0.0002741813659668
SELECT value FROM parameters WHERE parameter = 'EBAY_APP_ID' 
469 0.0001 0.00014185905456543
SELECT value FROM parameters WHERE parameter = 'EBAY_TRACKING_ID' 
470 0.0001 0.00013113021850586
SELECT value FROM parameters WHERE parameter = 'EBAY_NETWORK_ID' 
471 0.0001 0.00013995170593262
SELECT value FROM parameters WHERE parameter = 'EBAY_LOCALE' 
472 0.0001 0.00013208389282227
SELECT value FROM parameters WHERE parameter = 'EBAY_AUTH_TOKEN' 
473 0.2063 0.2063319683075
SELECT * FROM ebay_products_cache WHERE cachekey = '648ae9de5917ca97ed4f65fca43a4a1e' 
474 0.0003 0.00028014183044434
SELECT value FROM parameters WHERE parameter = 'EBAY_APP_ID' 
475 0.0002 0.00016403198242188
SELECT value FROM parameters WHERE parameter = 'EBAY_TRACKING_ID' 
476 0.0001 0.00014591217041016
SELECT value FROM parameters WHERE parameter = 'EBAY_NETWORK_ID' 
477 0.0001 0.00014781951904297
SELECT value FROM parameters WHERE parameter = 'EBAY_LOCALE' 
478 0.0001 0.00014400482177734
SELECT value FROM parameters WHERE parameter = 'EBAY_AUTH_TOKEN' 
479 0.1917 0.19173002243042
SELECT * FROM ebay_products_cache WHERE cachekey = '648ae9de5917ca97ed4f65fca43a4a1e' 
480 0.0281 0.028059959411621
UPDATE ebay_products_cache SET products = 'a:2:{i:0;a:13:{s:6:\"itemId\";s:12:\"273104255331\";s:11:\"viewItemURL\";s:137:\"http://rover.ebay.com/rover/1/711-53200-19255-0/1?ff3=2&toolid=10041&campid=5338345274&customid=&lgeo=1&vectorid=229466&item=273104255331\";s:10:\"galleryURL\";s:58:\"//thumbs4.ebaystatic.com/m/mZg5Fng2jBjytNPSSe2RNnw/140.jpg\";s:5:\"title\";s:59:\"NEW! HiViz Sig P-Series Lite Wave Rear Sight Handgun SGLW18\";s:11:\"listingType\";s:10:\"FixedPrice\";s:20:\"conditionDisplayName\";s:3:\"New\";s:8:\"timeLeft\";s:14:\"P17DT11H20M19S\";s:15:\"returnsAccepted\";s:4:\"true\";s:19:\"originalRetailPrice\";i:0;s:12:\"currentPrice\";s:5:\"34.84\";s:15:\"shipToLocations\";s:9:\"Worldwide\";s:12:\"handlingTime\";s:1:\"5\";s:10:\"variations\";s:5:\"false\";}i:1;s:243:\"http://rover.ebay.com/rover/1/711-53200-19255-0/1?ff3=4&toolid=10041&campid=5338345274&customid=&lgeo=1&mpre=http%3A%2F%2Fwww.ebay.com%2Fsch%2Fi.html%3F_nkw%3DHiViz%2BSig%2BP-Series%2BLite%2BWave%2BRear%2BSight%2BHandgun%26_ipg%3D10%26_pgn%3D1\";}', expiretime = '1560670601' WHERE id = '64215'
481 0.0003 0.00026488304138184
SELECT id,asin FROM products WHERE parent_id = 406031
482 0.0003 0.0003359317779541
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '406031' ORDER BY timestamp DESC
483 0.0002 0.00016498565673828
SELECT category_id FROM products_categories WHERE product_id = '406031'
484 0.0002 0.00023698806762695
SELECT * FROM categories WHERE id = '64'
485 0.0048 0.0047910213470459
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
486 0.0001 0.00014400482177734
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 64
487 0.0003 0.0002589225769043
SELECT id FROM categories WHERE parent_id = '64'
488 0.0048 0.0047638416290283
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 
489 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 (64)
				  AND p.disabled = 0 
490 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 (64)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
491 0.0002 0.00016880035400391
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '64'
492 0.0034 0.0034079551696777
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '406031' AND a.name = n.originalname
493 0.0002 0.00020194053649902
SELECT * FROM productoffers WHERE product_id = '406031' AND merchantid = 'ATVPDKIKX0DER'
494 0.0002 0.00021815299987793
SELECT * FROM productoffers
                WHERE product_id = '406031' AND price > 0
                ORDER BY price ASC LIMIT 1
495 0.0002 0.0002138614654541
SELECT * FROM products WHERE id = '406031'
496 0.0004 0.00043892860412598
SELECT value FROM productattributes WHERE product_id = '406031' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
497 0.0042 0.0042359828948975
UPDATE products SET price = '3608' WHERE id = '406031'
498 0.0036 0.003593921661377
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '406031' AND a.name = n.originalname
499 0.0002 0.00019979476928711
SELECT * FROM productoffers WHERE product_id = '406031' AND merchantid = 'ATVPDKIKX0DER'
500 0.0002 0.0002131462097168
SELECT * FROM productoffers
                WHERE product_id = '406031' AND price > 0
                ORDER BY price ASC LIMIT 1
501 0.0001 0.00014901161193848
SELECT category_id FROM products_categories WHERE product_id = '406031'
502 0.0001 0.00013494491577148
SELECT parent_id FROM categories WHERE id = '64'
503 0.0002 0.00023603439331055
SELECT * FROM categories WHERE id = '64'
504 0.0045 0.0044798851013184
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
505 0.0001 0.00012493133544922
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 64
506 0.0003 0.0002589225769043
SELECT id FROM categories WHERE parent_id = '64'
507 0.0045 0.0044708251953125
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 
508 0.0002 0.00016999244689941
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 
509 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 (64)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
510 0.0002 0.00017094612121582
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '64'
511 0.0002 0.00017499923706055
SELECT * FROM template_info WHERE templateuid = 'fsb-fluid'
512 0.0002 0.00018310546875
SELECT * FROM pages WHERE id = 2
513 0.0001 0.00014495849609375
SELECT * FROM pages WHERE id = 4
514 0.0001 0.00014591217041016
SELECT * FROM pages WHERE id = 12
515 0.0001 0.00014019012451172
SELECT * FROM pages WHERE id = 10
516 0.0001 0.00014996528625488
SELECT * FROM pages WHERE id = 7
517 0.0001 0.00014901161193848
SELECT * FROM pages WHERE id = 18
518 0.0001 0.00013995170593262
SELECT * FROM pages WHERE id = 28
519 0.0001 0.00014400482177734
SELECT * FROM pages WHERE id = 13
520 0.0001 0.00013899803161621
SELECT * FROM pages WHERE id = 3
521 0.0502 0.050194025039673
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
522 0.0003 0.00026082992553711
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:1560670603;s:8:\"products\";a:6:{i:0;s:6:\"414940\";i:8;s:6:\"412382\";i:14;s:6:\"130885\";i:17;s:6:\"408078\";i:2;s:6:\"290575\";i:10;s:6:\"414825\";}}' WHERE id = '175'
523 0.0005 0.00048089027404785
SELECT * FROM products WHERE id IN (414940,412382,130885,408078,290575,414825) ORDER BY FIELD(id, 414940,412382,130885,408078,290575,414825 )
524 0.0002 0.00022506713867188
SELECT * FROM productimages WHERE product_id = '414940' ORDER BY sortorder ASC
525 0.0002 0.00021696090698242
SELECT * FROM product_image_select WHERE product_id = '414940'
526 0.0001 0.00012707710266113
SELECT * FROM productcustomimages WHERE product_id = '414940'
527 0.0037 0.0036928653717041
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '414940' AND a.name = n.originalname
528 0.0002 0.00018191337585449
SELECT * FROM productoffers WHERE product_id = '414940' AND merchantid = 'ATVPDKIKX0DER'
529 0.0002 0.00021600723266602
SELECT * FROM productoffers
                WHERE product_id = '414940' AND price > 0
                ORDER BY price ASC LIMIT 1
530 0.0005 0.00047707557678223
SELECT value FROM productattributes WHERE product_id = '414940' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
531 0.0087 0.0087101459503174
UPDATE products SET price = '4490' WHERE id = '414940'
532 0.0002 0.00024199485778809
SELECT * FROM productimages WHERE product_id = '412382' ORDER BY sortorder ASC
533 0.0002 0.0002129077911377
SELECT * FROM product_image_select WHERE product_id = '412382'
534 0.0001 0.00012803077697754
SELECT * FROM productcustomimages WHERE product_id = '412382'
535 0.0021 0.0021219253540039
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '412382' AND a.name = n.originalname
536 0.0002 0.00020790100097656
SELECT * FROM productoffers WHERE product_id = '412382' AND merchantid = 'ATVPDKIKX0DER'
537 0.0002 0.00022506713867188
SELECT * FROM productoffers
                WHERE product_id = '412382' AND price > 0
                ORDER BY price ASC LIMIT 1
538 0.0004 0.00036001205444336
SELECT value FROM productattributes WHERE product_id = '412382' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
539 0.0001 0.00013184547424316
UPDATE products SET price = '3199' WHERE id = '412382'
540 0.0002 0.00020790100097656
SELECT * FROM productimages WHERE product_id = '130885' ORDER BY sortorder ASC
541 0.0002 0.0002140998840332
SELECT * FROM product_image_select WHERE product_id = '130885'
542 0.0001 0.00012707710266113
SELECT * FROM productcustomimages WHERE product_id = '130885'
543 0.0029 0.0028591156005859
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '130885' AND a.name = n.originalname
544 0.0002 0.00018191337585449
SELECT * FROM productoffers WHERE product_id = '130885' AND merchantid = 'ATVPDKIKX0DER'
545 0.0002 0.00020194053649902
SELECT * FROM productoffers
                WHERE product_id = '130885' AND price > 0
                ORDER BY price ASC LIMIT 1
546 0.0004 0.00039005279541016
SELECT value FROM productattributes WHERE product_id = '130885' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
547 0.0001 0.0001220703125
UPDATE products SET price = '1521' WHERE id = '130885'
548 0.0002 0.0002138614654541
SELECT * FROM productimages WHERE product_id = '408078' ORDER BY sortorder ASC
549 0.0002 0.00021004676818848
SELECT * FROM product_image_select WHERE product_id = '408078'
550 0.0001 0.00012111663818359
SELECT * FROM productcustomimages WHERE product_id = '408078'
551 0.0039 0.0039141178131104
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '408078' AND a.name = n.originalname
552 0.0002 0.00020313262939453
SELECT * FROM productoffers WHERE product_id = '408078' AND merchantid = 'ATVPDKIKX0DER'
553 0.0002 0.00020384788513184
SELECT * FROM productoffers
                WHERE product_id = '408078' AND price > 0
                ORDER BY price ASC LIMIT 1
554 0.0004 0.00041699409484863
SELECT value FROM productattributes WHERE product_id = '408078' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
555 0.0001 0.00013089179992676
UPDATE products SET price = '23352' WHERE id = '408078'
556 0.0006 0.00059199333190918
SELECT * FROM productimages WHERE product_id = '290575' ORDER BY sortorder ASC
557 0.0002 0.00023484230041504
SELECT * FROM product_image_select WHERE product_id = '290575'
558 0.0001 0.00012707710266113
SELECT * FROM productcustomimages WHERE product_id = '290575'
559 0.0042 0.0042002201080322
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '290575' AND a.name = n.originalname
560 0.0002 0.00018501281738281
SELECT * FROM productoffers WHERE product_id = '290575' AND merchantid = 'ATVPDKIKX0DER'
561 0.0002 0.00019979476928711
SELECT * FROM productoffers
                WHERE product_id = '290575' AND price > 0
                ORDER BY price ASC LIMIT 1
562 0.0005 0.00046396255493164
SELECT value FROM productattributes WHERE product_id = '290575' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
563 0.0001 0.00013089179992676
UPDATE products SET price = '549500' WHERE id = '290575'
564 0.0002 0.00020790100097656
SELECT * FROM productimages WHERE product_id = '414825' ORDER BY sortorder ASC
565 0.0002 0.00021719932556152
SELECT * FROM product_image_select WHERE product_id = '414825'
566 0.0001 0.00012493133544922
SELECT * FROM productcustomimages WHERE product_id = '414825'
567 0.0031 0.0030949115753174
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '414825' AND a.name = n.originalname
568 0.0002 0.00019288063049316
SELECT * FROM productoffers WHERE product_id = '414825' AND merchantid = 'ATVPDKIKX0DER'
569 0.0002 0.00022602081298828
SELECT * FROM productoffers
                WHERE product_id = '414825' AND price > 0
                ORDER BY price ASC LIMIT 1
570 0.0004 0.00038599967956543
SELECT value FROM productattributes WHERE product_id = '414825' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
571 0.0001 0.00013208389282227
UPDATE products SET price = '11999' WHERE id = '414825'
572 0.0446 0.044616937637329
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
573 0.0003 0.00025606155395508
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:1560670603;s:8:\"products\";a:6:{i:1;s:6:\"398315\";i:8;s:6:\"412382\";i:10;s:6:\"414825\";i:11;s:6:\"407831\";i:15;s:6:\"147874\";i:22;s:6:\"400044\";}}' WHERE id = '177'
574 0.0005 0.00047898292541504
SELECT * FROM products WHERE id IN (398315,412382,414825,407831,147874,400044) ORDER BY FIELD(id, 398315,412382,414825,407831,147874,400044 )
575 0.0002 0.00023913383483887
SELECT * FROM productimages WHERE product_id = '398315' ORDER BY sortorder ASC
576 0.0002 0.00021910667419434
SELECT * FROM product_image_select WHERE product_id = '398315'
577 0.0001 0.00012397766113281
SELECT * FROM productcustomimages WHERE product_id = '398315'
578 0.0030 0.0029811859130859
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '398315' AND a.name = n.originalname
579 0.0002 0.00019001960754395
SELECT * FROM productoffers WHERE product_id = '398315' AND merchantid = 'ATVPDKIKX0DER'
580 0.0002 0.00021791458129883
SELECT * FROM productoffers
                WHERE product_id = '398315' AND price > 0
                ORDER BY price ASC LIMIT 1
581 0.0004 0.0004420280456543
SELECT value FROM productattributes WHERE product_id = '398315' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
582 0.0001 0.00013399124145508
UPDATE products SET price = '1999' WHERE id = '398315'
583 0.0002 0.0002129077911377
SELECT * FROM productimages WHERE product_id = '412382' ORDER BY sortorder ASC
584 0.0002 0.0002129077911377
SELECT * FROM product_image_select WHERE product_id = '412382'
585 0.0001 0.00012493133544922
SELECT * FROM productcustomimages WHERE product_id = '412382'
586 0.0025 0.0024869441986084
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '412382' AND a.name = n.originalname
587 0.0002 0.00019407272338867
SELECT * FROM productoffers WHERE product_id = '412382' AND merchantid = 'ATVPDKIKX0DER'
588 0.0002 0.00021600723266602
SELECT * FROM productoffers
                WHERE product_id = '412382' AND price > 0
                ORDER BY price ASC LIMIT 1
589 0.0003 0.00034809112548828
SELECT value FROM productattributes WHERE product_id = '412382' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
590 0.0433 0.043252944946289
UPDATE products SET price = '3199' WHERE id = '412382'
591 0.0003 0.0003058910369873
SELECT * FROM productimages WHERE product_id = '414825' ORDER BY sortorder ASC
592 0.0002 0.00022506713867188
SELECT * FROM product_image_select WHERE product_id = '414825'
593 0.0001 0.00012707710266113
SELECT * FROM productcustomimages WHERE product_id = '414825'
594 0.0022 0.0021951198577881
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '414825' AND a.name = n.originalname
595 0.0002 0.00019693374633789
SELECT * FROM productoffers WHERE product_id = '414825' AND merchantid = 'ATVPDKIKX0DER'
596 0.0002 0.00022292137145996
SELECT * FROM productoffers
                WHERE product_id = '414825' AND price > 0
                ORDER BY price ASC LIMIT 1
597 0.0004 0.00042295455932617
SELECT value FROM productattributes WHERE product_id = '414825' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
598 0.0001 0.00013899803161621
UPDATE products SET price = '11999' WHERE id = '414825'
599 0.0002 0.00020599365234375
SELECT * FROM productimages WHERE product_id = '407831' ORDER BY sortorder ASC
600 0.0002 0.00021004676818848
SELECT * FROM product_image_select WHERE product_id = '407831'
601 0.0001 0.00012683868408203
SELECT * FROM productcustomimages WHERE product_id = '407831'
602 0.0039 0.0039300918579102
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '407831' AND a.name = n.originalname
603 0.0002 0.00019407272338867
SELECT * FROM productoffers WHERE product_id = '407831' AND merchantid = 'ATVPDKIKX0DER'
604 0.0002 0.00022101402282715
SELECT * FROM productoffers
                WHERE product_id = '407831' AND price > 0
                ORDER BY price ASC LIMIT 1
605 0.0005 0.00052905082702637
SELECT value FROM productattributes WHERE product_id = '407831' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
606 0.0001 0.00012898445129395
UPDATE products SET price = '1293' WHERE id = '407831'
607 0.0002 0.00021791458129883
SELECT * FROM productimages WHERE product_id = '147874' ORDER BY sortorder ASC
608 0.0002 0.00021195411682129
SELECT * FROM product_image_select WHERE product_id = '147874'
609 0.0001 0.00012302398681641
SELECT * FROM productcustomimages WHERE product_id = '147874'
610 0.0033 0.0032930374145508
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '147874' AND a.name = n.originalname
611 0.0002 0.00020003318786621
SELECT * FROM productoffers WHERE product_id = '147874' AND merchantid = 'ATVPDKIKX0DER'
612 0.0002 0.00022101402282715
SELECT * FROM productoffers
                WHERE product_id = '147874' AND price > 0
                ORDER BY price ASC LIMIT 1
613 0.0004 0.00044989585876465
SELECT value FROM productattributes WHERE product_id = '147874' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
614 0.0001 0.00012898445129395
UPDATE products SET price = '599' WHERE id = '147874'
615 0.0002 0.00024795532226562
SELECT * FROM productimages WHERE product_id = '400044' ORDER BY sortorder ASC
616 0.0002 0.00021481513977051
SELECT * FROM product_image_select WHERE product_id = '400044'
617 0.0001 0.00012302398681641
SELECT * FROM productcustomimages WHERE product_id = '400044'
618 0.0034 0.0033669471740723
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '400044' AND a.name = n.originalname
619 0.0002 0.00020194053649902
SELECT * FROM productoffers WHERE product_id = '400044' AND merchantid = 'ATVPDKIKX0DER'
620 0.0002 0.00021696090698242
SELECT * FROM productoffers
                WHERE product_id = '400044' AND price > 0
                ORDER BY price ASC LIMIT 1
621 0.0005 0.00048112869262695
SELECT value FROM productattributes WHERE product_id = '400044' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
622 0.0001 0.00012707710266113
UPDATE products SET price = '16091' WHERE id = '400044'
623 0.1075 0.10754013061523
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
624 0.0003 0.0003049373626709
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:1560670603;s:8:\"products\";a:6:{i:7;s:6:\"403517\";i:10;s:6:\"414825\";i:16;s:6:\"407620\";i:17;s:6:\"408078\";i:19;s:6:\"131163\";i:23;s:6:\"406913\";}}' WHERE id = '181'
625 0.0005 0.00048112869262695
SELECT * FROM products WHERE id IN (403517,414825,407620,408078,131163,406913) ORDER BY FIELD(id, 403517,414825,407620,408078,131163,406913 )
626 0.0003 0.00030207633972168
SELECT * FROM productimages WHERE product_id = '403517' ORDER BY sortorder ASC
627 0.0002 0.00021719932556152
SELECT * FROM product_image_select WHERE product_id = '403517'
628 0.0001 0.00012898445129395
SELECT * FROM productcustomimages WHERE product_id = '403517'
629 0.0034 0.0033979415893555
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '403517' AND a.name = n.originalname
630 0.0002 0.00019097328186035
SELECT * FROM productoffers WHERE product_id = '403517' AND merchantid = 'ATVPDKIKX0DER'
631 0.0002 0.00020980834960938
SELECT * FROM productoffers
                WHERE product_id = '403517' AND price > 0
                ORDER BY price ASC LIMIT 1
632 0.0005 0.00048279762268066
SELECT value FROM productattributes WHERE product_id = '403517' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
633 0.0001 0.00014019012451172
UPDATE products SET price = '6699' WHERE id = '403517'
634 0.0002 0.00021696090698242
SELECT * FROM productimages WHERE product_id = '414825' ORDER BY sortorder ASC
635 0.0002 0.0002131462097168
SELECT * FROM product_image_select WHERE product_id = '414825'
636 0.0001 0.00012516975402832
SELECT * FROM productcustomimages WHERE product_id = '414825'
637 0.0026 0.0026199817657471
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '414825' AND a.name = n.originalname
638 0.0002 0.00019717216491699
SELECT * FROM productoffers WHERE product_id = '414825' AND merchantid = 'ATVPDKIKX0DER'
639 0.0002 0.0002129077911377
SELECT * FROM productoffers
                WHERE product_id = '414825' AND price > 0
                ORDER BY price ASC LIMIT 1
640 0.0004 0.00041604042053223
SELECT value FROM productattributes WHERE product_id = '414825' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
641 0.1066 0.10658884048462
UPDATE products SET price = '11999' WHERE id = '414825'
642 0.0004 0.00035214424133301
SELECT * FROM productimages WHERE product_id = '407620' ORDER BY sortorder ASC
643 0.0002 0.00022292137145996
SELECT * FROM product_image_select WHERE product_id = '407620'
644 0.0001 0.00013113021850586
SELECT * FROM productcustomimages WHERE product_id = '407620'
645 0.0026 0.0025920867919922
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '407620' AND a.name = n.originalname
646 0.0002 0.00019717216491699
SELECT * FROM productoffers WHERE product_id = '407620' AND merchantid = 'ATVPDKIKX0DER'
647 0.0002 0.0002129077911377
SELECT * FROM productoffers
                WHERE product_id = '407620' AND price > 0
                ORDER BY price ASC LIMIT 1
648 0.0004 0.00043010711669922
SELECT value FROM productattributes WHERE product_id = '407620' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
649 0.0001 0.00013303756713867
UPDATE products SET price = '20024' WHERE id = '407620'
650 0.0002 0.00022101402282715
SELECT * FROM productimages WHERE product_id = '408078' ORDER BY sortorder ASC
651 0.0002 0.0002129077911377
SELECT * FROM product_image_select WHERE product_id = '408078'
652 0.0001 0.00013589859008789
SELECT * FROM productcustomimages WHERE product_id = '408078'
653 0.0034 0.0034468173980713
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '408078' AND a.name = n.originalname
654 0.0002 0.00019383430480957
SELECT * FROM productoffers WHERE product_id = '408078' AND merchantid = 'ATVPDKIKX0DER'
655 0.0002 0.00022101402282715
SELECT * FROM productoffers
                WHERE product_id = '408078' AND price > 0
                ORDER BY price ASC LIMIT 1
656 0.0005 0.00047087669372559
SELECT value FROM productattributes WHERE product_id = '408078' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
657 0.0001 0.00012898445129395
UPDATE products SET price = '23352' WHERE id = '408078'
658 0.0003 0.00025105476379395
SELECT * FROM productimages WHERE product_id = '131163' ORDER BY sortorder ASC
659 0.0002 0.0002129077911377
SELECT * FROM product_image_select WHERE product_id = '131163'
660 0.0001 0.00012302398681641
SELECT * FROM productcustomimages WHERE product_id = '131163'
661 0.0028 0.0028150081634521
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '131163' AND a.name = n.originalname
662 0.0002 0.0001988410949707
SELECT * FROM productoffers WHERE product_id = '131163' AND merchantid = 'ATVPDKIKX0DER'
663 0.0002 0.00022292137145996
SELECT * FROM productoffers
                WHERE product_id = '131163' AND price > 0
                ORDER BY price ASC LIMIT 1
664 0.0004 0.00043416023254395
SELECT value FROM productattributes WHERE product_id = '131163' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
665 0.0001 0.00012516975402832
UPDATE products SET price = '20363' WHERE id = '131163'
666 0.0002 0.00019121170043945
SELECT * FROM productimages WHERE product_id = '406913' ORDER BY sortorder ASC
667 0.0002 0.00021004676818848
SELECT * FROM product_image_select WHERE product_id = '406913'
668 0.0001 0.00012302398681641
SELECT * FROM productcustomimages WHERE product_id = '406913'
669 0.0029 0.0029008388519287
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '406913' AND a.name = n.originalname
670 0.0002 0.0001981258392334
SELECT * FROM productoffers WHERE product_id = '406913' AND merchantid = 'ATVPDKIKX0DER'
671 0.0002 0.00020694732666016
SELECT * FROM productoffers
                WHERE product_id = '406913' AND price > 0
                ORDER BY price ASC LIMIT 1
672 0.0004 0.00044107437133789
SELECT value FROM productattributes WHERE product_id = '406913' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
673 0.0001 0.00012397766113281
UPDATE products SET price = '1499' WHERE id = '406913'
674 0.1080 0.10796189308167
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
675 0.0003 0.00028300285339355
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:1560670603;s:8:\"products\";a:6:{i:0;s:6:\"414940\";i:7;s:6:\"403517\";i:9;s:6:\"412945\";i:10;s:6:\"414825\";i:11;s:6:\"407831\";i:15;s:6:\"147874\";}}' WHERE id = '183'
676 0.0005 0.00050592422485352
SELECT * FROM products WHERE id IN (414940,403517,412945,414825,407831,147874) ORDER BY FIELD(id, 414940,403517,412945,414825,407831,147874 )
677 0.0002 0.00020289421081543
SELECT * FROM productimages WHERE product_id = '414940' ORDER BY sortorder ASC
678 0.0002 0.00021505355834961
SELECT * FROM product_image_select WHERE product_id = '414940'
679 0.0001 0.00012707710266113
SELECT * FROM productcustomimages WHERE product_id = '414940'
680 0.0038 0.0038480758666992
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '414940' AND a.name = n.originalname
681 0.0002 0.00019598007202148
SELECT * FROM productoffers WHERE product_id = '414940' AND merchantid = 'ATVPDKIKX0DER'
682 0.0002 0.00021505355834961
SELECT * FROM productoffers
                WHERE product_id = '414940' AND price > 0
                ORDER BY price ASC LIMIT 1
683 0.0006 0.0005650520324707
SELECT value FROM productattributes WHERE product_id = '414940' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
684 0.0001 0.00013995170593262
UPDATE products SET price = '4490' WHERE id = '414940'
685 0.0003 0.00028586387634277
SELECT * FROM productimages WHERE product_id = '403517' ORDER BY sortorder ASC
686 0.0002 0.00021100044250488
SELECT * FROM product_image_select WHERE product_id = '403517'
687 0.0001 0.00012588500976562
SELECT * FROM productcustomimages WHERE product_id = '403517'
688 0.0034 0.0033910274505615
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '403517' AND a.name = n.originalname
689 0.0002 0.00019383430480957
SELECT * FROM productoffers WHERE product_id = '403517' AND merchantid = 'ATVPDKIKX0DER'
690 0.0002 0.00020408630371094
SELECT * FROM productoffers
                WHERE product_id = '403517' AND price > 0
                ORDER BY price ASC LIMIT 1
691 0.0004 0.00042605400085449
SELECT value FROM productattributes WHERE product_id = '403517' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
692 0.1047 0.10472989082336
UPDATE products SET price = '6699' WHERE id = '403517'
693 0.0003 0.00033116340637207
SELECT * FROM productimages WHERE product_id = '412945' ORDER BY sortorder ASC
694 0.0002 0.00023913383483887
SELECT * FROM product_image_select WHERE product_id = '412945'
695 0.0001 0.00012993812561035
SELECT * FROM productcustomimages WHERE product_id = '412945'
696 0.0033 0.0032961368560791
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '412945' AND a.name = n.originalname
697 0.0002 0.00019693374633789
SELECT * FROM productoffers WHERE product_id = '412945' AND merchantid = 'ATVPDKIKX0DER'
698 0.0002 0.00023603439331055
SELECT * FROM productoffers
                WHERE product_id = '412945' AND price > 0
                ORDER BY price ASC LIMIT 1
699 0.0005 0.00045204162597656
SELECT value FROM productattributes WHERE product_id = '412945' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
700 0.0001 0.00013399124145508
UPDATE products SET price = '3199' WHERE id = '412945'
701 0.0002 0.00022506713867188
SELECT * FROM productimages WHERE product_id = '414825' ORDER BY sortorder ASC
702 0.0002 0.00020694732666016
SELECT * FROM product_image_select WHERE product_id = '414825'
703 0.0001 0.00012493133544922
SELECT * FROM productcustomimages WHERE product_id = '414825'
704 0.0021 0.0021491050720215
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '414825' AND a.name = n.originalname
705 0.0002 0.00019288063049316
SELECT * FROM productoffers WHERE product_id = '414825' AND merchantid = 'ATVPDKIKX0DER'
706 0.0002 0.00022697448730469
SELECT * FROM productoffers
                WHERE product_id = '414825' AND price > 0
                ORDER BY price ASC LIMIT 1
707 0.0004 0.00040698051452637
SELECT value FROM productattributes WHERE product_id = '414825' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
708 0.0001 0.00012397766113281
UPDATE products SET price = '11999' WHERE id = '414825'
709 0.0002 0.00020790100097656
SELECT * FROM productimages WHERE product_id = '407831' ORDER BY sortorder ASC
710 0.0002 0.0002140998840332
SELECT * FROM product_image_select WHERE product_id = '407831'
711 0.0001 0.00013113021850586
SELECT * FROM productcustomimages WHERE product_id = '407831'
712 0.0039 0.0039389133453369
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '407831' AND a.name = n.originalname
713 0.0002 0.0001838207244873
SELECT * FROM productoffers WHERE product_id = '407831' AND merchantid = 'ATVPDKIKX0DER'
714 0.0002 0.00022315979003906
SELECT * FROM productoffers
                WHERE product_id = '407831' AND price > 0
                ORDER BY price ASC LIMIT 1
715 0.0005 0.00048112869262695
SELECT value FROM productattributes WHERE product_id = '407831' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
716 0.0001 0.00012803077697754
UPDATE products SET price = '1293' WHERE id = '407831'
717 0.0002 0.0001990795135498
SELECT * FROM productimages WHERE product_id = '147874' ORDER BY sortorder ASC
718 0.0002 0.00020980834960938
SELECT * FROM product_image_select WHERE product_id = '147874'
719 0.0001 0.00012803077697754
SELECT * FROM productcustomimages WHERE product_id = '147874'
720 0.0036 0.0035679340362549
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '147874' AND a.name = n.originalname
721 0.0002 0.00019288063049316
SELECT * FROM productoffers WHERE product_id = '147874' AND merchantid = 'ATVPDKIKX0DER'
722 0.0002 0.00021505355834961
SELECT * FROM productoffers
                WHERE product_id = '147874' AND price > 0
                ORDER BY price ASC LIMIT 1
723 0.0004 0.00040292739868164
SELECT value FROM productattributes WHERE product_id = '147874' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
724 0.0001 0.00012803077697754
UPDATE products SET price = '599' WHERE id = '147874'
725 0.0004 0.0004119873046875
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid' AND area = 'header' ORDER BY sortorder ASC
726 0.0001 0.0001378059387207
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
727 0.0001 0.00012493133544922
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
728 0.0001 0.00012302398681641
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
729 0.0001 0.00013303756713867
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
730 0.0004 0.00040602684020996
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid' AND area = 'footer' ORDER BY sortorder ASC
731 0.0001 0.00012803077697754
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
732 0.0001 0.00011992454528809
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
733 0.0001 0.00012493133544922
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
734 0.0009 0.00094699859619141
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-fluid' AND skinuid = ''
735 0.0003 0.00030803680419922
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid'
736 0.0003 0.00029706954956055
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid'
737 0.0005 0.00048398971557617
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid' AND imageuid = 'HEAD_CUSTOM_BANNER'
738 0.0003 0.00032305717468262
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid' AND imageuid = 'HEAD_CUSTOM_BANNER'