Tactical Equipment - Survivalist Equipment

VIPERTEK VTS-979 - 999,000,000 Stun Gun - Rechargeable with Safety Disable Pin LED Flashlight, Black from VIPERTEK

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

The Tactical and Survivalist shop is delighted to stock the fantastic VIPERTEK VTS-979 - 999,000,000 Stun Gun - Rechargeable with Safety Disable Pin LED Flashlight, Black today at this special price.

With so many competing tactical, combat and survival products available today, it is wise to have a name that you can trust. The VIPERTEK VTS-979 - 999,000,000 Stun Gun - Rechargeable with Safety Disable Pin LED Flashlight, Black is certainly all that and will be a perfect purchase for your combat gear or tactical ability.

We pride ourselves on providing the finest quality survivalist gear for all your front line requirements.

For this special price, the VIPERTEK VTS-979 - 999,000,000 Stun Gun - Rechargeable with Safety Disable Pin LED Flashlight, Black is greatly recommended and is always a favored choice amongst lots of like minded people. VIPERTEK have included some excellent touches and this equals better value.

Manufacturer Description

Safety Disable Pin: Prevents an enemy from taking this stun gun away and utilizing it on you. A strap worn around your wrist connects to a disable pin on the bottom of the system. If the stun gun is drawn from you the pin will take out, avoiding it from working. The VIPERTEK VTS-979 stun gun truly loads a punch! Just test firing this system into the air is often enough to stop an enemy. As the bright electric present pulsates in between the test prongs and produces a challenging electrical sound, an enemy with any sense at all will be dropped in his tracks. If the sight and sound doesn't stop him, a shock from this stun gun certainly will bring an enemy down! When an enemy is touched by the stun gun it will interfere with the message the brain sends to the voluntary muscles. Simply touching an enemy will deliver a high voltage shock triggering vertigo and muscle control, confusion, and disorientation bringing him to his knees and making him incapable of more aggressive activity. Due to restrictions in some states, county and city laws we do not deliver to the following places: Hawaii, Massachusetts, Michigan, Connecticut, New Jersey, Illinois, New York, Rhode Island, Wisconsin, District of Columbia, Annapolis, MD, Baltimore, MD, Chicago, IL, Philadelphia, PA, Baltimore County, MD, Crawford County, IA VIPERTEK

Product Features

Powerful Stun Gun With LED Flashlight & Safety Disable Pin Convenient Size (6.5" x 2" x 1") Internal Rechargeable Battery - No expensive batteries to buy Non-Slip Rubber Coating Lifetime Warranty

Write a Review

Debug Overview

App Total Time DB Queries DB Query Total Time Amazon Requests
3.0929889678955 762 1.9930 0


No Amazon API Requests Made.


App Debug - Total Time 3.0929889678955 seconds

Number Time From Start Name Description
1 0.37264800071716 Initialise Initialise FSB Function
2 0.38022398948669 App Controller Start Start of the App controller (called before the controller of every page)
3 0.39181804656982 Start of getCategoryListByGroup Function Before first category groups query
4 0.39200091362 After initial query Before first category groups query
5 0.39200305938721 Get Category List for Group Before the call to getCategoryList function
6 0.39200592041016 Start of GetCategoryList function Start of the function
7 0.39201092720032 Before getting categories Query to get specific category list
8 0.3926260471344 After getting categories Query to get specific category list
9 0.39262795448303 Before getting category custom Before call to function getCategoryCustom
10 0.3946168422699 After getting category custom After call to function getCategoryCustom
11 0.39461994171143 Before getting category custom Before call to function getCategoryCustom
12 0.40531206130981 After getting category custom After call to function getCategoryCustom
13 0.40531587600708 Before getting category custom Before call to function getCategoryCustom
14 0.41094398498535 After getting category custom After call to function getCategoryCustom
15 0.4109468460083 Before getting category custom Before call to function getCategoryCustom
16 0.41516089439392 After getting category custom After call to function getCategoryCustom
17 0.41516399383545 End of GetCategoryList function End of the function
18 0.41517400741577 Get Category List for Group Before the call to getCategoryList function
19 0.4151759147644 Start of GetCategoryList function Start of the function
20 0.41517901420593 Before getting categories Query to get specific category list
21 0.41563296318054 After getting categories Query to get specific category list
22 0.41563391685486 Before getting category custom Before call to function getCategoryCustom
23 0.42124891281128 After getting category custom After call to function getCategoryCustom
24 0.42125201225281 Before getting category custom Before call to function getCategoryCustom
25 0.43192601203918 After getting category custom After call to function getCategoryCustom
26 0.43192791938782 End of GetCategoryList function End of the function
27 0.43193483352661 Get Category List for Group Before the call to getCategoryList function
28 0.43193793296814 Start of GetCategoryList function Start of the function
29 0.43194103240967 Before getting categories Query to get specific category list
30 0.43267583847046 After getting categories Query to get specific category list
31 0.43267798423767 Before getting category custom Before call to function getCategoryCustom
32 0.44186687469482 After getting category custom After call to function getCategoryCustom
33 0.44186997413635 Before getting category custom Before call to function getCategoryCustom
34 0.45918297767639 After getting category custom After call to function getCategoryCustom
35 0.45918583869934 Before getting category custom Before call to function getCategoryCustom
36 0.46516489982605 After getting category custom After call to function getCategoryCustom
37 0.46516799926758 Before getting category custom Before call to function getCategoryCustom
38 0.47112894058228 After getting category custom After call to function getCategoryCustom
39 0.4711320400238 Before getting category custom Before call to function getCategoryCustom
40 0.47740888595581 After getting category custom After call to function getCategoryCustom
41 0.47741198539734 Before getting category custom Before call to function getCategoryCustom
42 0.49925398826599 After getting category custom After call to function getCategoryCustom
43 0.49925804138184 Before getting category custom Before call to function getCategoryCustom
44 0.50342488288879 After getting category custom After call to function getCategoryCustom
45 0.50342798233032 Before getting category custom Before call to function getCategoryCustom
46 0.50809001922607 After getting category custom After call to function getCategoryCustom
47 0.50809288024902 End of GetCategoryList function End of the function
48 0.50810694694519 Get Category List for Group Before the call to getCategoryList function
49 0.50810885429382 Start of GetCategoryList function Start of the function
50 0.50811290740967 Before getting categories Query to get specific category list
51 0.50855398178101 After getting categories Query to get specific category list
52 0.50855588912964 Before getting category custom Before call to function getCategoryCustom
53 0.51094388961792 After getting category custom After call to function getCategoryCustom
54 0.51094603538513 Before getting category custom Before call to function getCategoryCustom
55 0.51335000991821 After getting category custom After call to function getCategoryCustom
56 0.51335191726685 End of GetCategoryList function End of the function
57 0.51335883140564 Get Category List for Group Before the call to getCategoryList function
58 0.51336193084717 Start of GetCategoryList function Start of the function
59 0.5133650302887 Before getting categories Query to get specific category list
60 0.51369786262512 After getting categories Query to get specific category list
61 0.51370000839233 Before getting category custom Before call to function getCategoryCustom
62 0.51873397827148 After getting category custom After call to function getCategoryCustom
63 0.51873588562012 End of GetCategoryList function End of the function
64 0.51874303817749 End of getCategoryListByGroup Function Before return()
65 0.57376384735107 App Controller End End of the App controller (called before the controller of every page)
66 0.57445597648621 Product Start Start of the product info controller
67 0.57537484169006 Cache file not found Starting get product details
68 0.62420296669006 Related products Start getting related products if enabled
69 0.62420392036438 Related Products Start Before the related products are found
70 0.6242048740387 Related Products Keywords Before the related product keywords are found
71 0.62421703338623 Create Keyword List Function Start of function
72 0.62563300132751 Create Keyword List Function After looping provided content - 937 keywords found
73 0.68747591972351 Create Keyword List Function After looping initial keyword list - 863 keywords remaining
74 0.68769693374634 Create Keyword List Function After reducing keyword list
75 0.68888592720032 Create Keyword List Function After selecting by scoring keywords
76 0.68889188766479 Create Keyword List Function After final loop of keywords
77 0.68889498710632 Related Products Keywords After the related product keywords are found
78 1.6589939594269 Related Products End After the related products are found
79 1.8445780277252 Start Remote Request http://svcs.ebay.com/services/search/FindingServic...
80 2.035749912262 End Remote Request http://svcs.ebay.com/services/search/FindingServic...
81 2.2332780361176 Product End End of the product info controller (Product Info)
82 2.2336628437042 App_after Controller Start Start of the App_after controller (called after the controller of every page)
83 2.2337460517883 Before Get Options Before the call to getOptions in the tpl class
84 2.6550328731537 After Get Options After the call to getOptions in the tpl class
85 2.6552948951721 App_after Controller End End of the App_after controller (called after the controller of every page)
86 2.655308008194 Product Info: Before Smarty Fetch Before the product.tpl template is fetched
87 2.885724067688 Product Info: After Smarty Fetch After the product.tpl template is fetched
88 2.8857309818268 Product Info: Before Template Display Before the template is displayed
89 3.0929658412933 Product Info: After Template Display After the template is displayed
90 3.0929720401764 Finalizing debug Before the debug is output to the page.
91 3.0929880142212 End of App This is the end of the app logging, final timestamp


Query Debug - 762 Database Queries. Total time 1.9930 seconds

Number Time (Seconds) Time (Milliseconds) Query
1 0.0002 0.00016498565673828
SELECT value FROM parameters WHERE `parameter` = 'BAD_BOTS_ENABLER'
2 0.0004 0.0004429817199707
SHOW TABLES LIKE 'bad_bots'
3 0.0002 0.00016903877258301
SELECT value FROM parameters WHERE `parameter` = 'STORE_WHITELISTED_IPS'
4 0.0002 0.00016379356384277
SELECT * FROM `bad_bots`
5 0.0005 0.00048995018005371
SELECT parameter, value FROM parameters
6 0.0001 0.00014901161193848
SET time_zone = 'Europe/London'
7 0.0003 0.00031113624572754
SELECT * FROM autorun ORDER BY lastrun ASC
8 0.0002 0.00016188621520996
SELECT * FROM version ORDER BY installed DESC LIMIT 1
9 0.0001 0.00011086463928223
delete from cachefiles
10 0.0002 0.00022602081298828
SELECT id FROM pages WHERE pagename = 'vipertek-vts-979-999000000-stun-gun-rechargeable-with-safety-disable-pin-led-flashlight-black' LIMIT 1
11 0.0002 0.00024199485778809
SELECT id FROM products WHERE pagename = 'vipertek-vts-979-999000000-stun-gun-rechargeable-with-safety-disable-pin-led-flashlight-black' AND hidden = 0 LIMIT 1
12 0.0008 0.00083804130554199
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-fluid'
13 0.0097 0.0097260475158691
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-fluid' AND language = 'en'
14 0.0002 0.00022506713867188
SELECT * FROM pages WHERE pagename = 'vipertek-vts-979-999000000-stun-gun-rechargeable-with-safety-disable-pin-led-flashlight-black'
15 0.0002 0.00016403198242188
SELECT * FROM categorygroups ORDER BY sortorder ASC
16 0.0006 0.00055909156799316
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
17 0.0005 0.00049901008605957
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.00024890899658203
SELECT id FROM categories WHERE parent_id = '49'
19 0.0005 0.00045394897460938
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.00016188621520996
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.00016999244689941
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.00018882751464844
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '49'
23 0.0001 0.0001380443572998
SELECT * FROM categorygroups WHERE id = '1'
24 0.0030 0.002997875213623
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.00026702880859375
SELECT id FROM categories WHERE parent_id = '50'
26 0.0002 0.00023388862609863
SELECT id FROM categories WHERE parent_id = '96'
27 0.0002 0.0002140998840332
SELECT id FROM categories WHERE parent_id = '97'
28 0.0002 0.00021195411682129
SELECT id FROM categories WHERE parent_id = '111'
29 0.0002 0.00021195411682129
SELECT id FROM categories WHERE parent_id = '129'
30 0.0057 0.0056920051574707
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.00016903877258301
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (96,97,111,129,50)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
33 0.0002 0.00019598007202148
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '50'
34 0.0001 0.0001378059387207
SELECT * FROM categorygroups WHERE id = '1'
35 0.0023 0.0022928714752197
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.00026392936706543
SELECT id FROM categories WHERE parent_id = '80'
37 0.0023 0.0023219585418701
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.00015711784362793
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.00016522407531738
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.00017499923706055
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '80'
41 0.0001 0.0001370906829834
SELECT * FROM categorygroups WHERE id = '1'
42 0.0012 0.0011599063873291
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.00025582313537598
SELECT id FROM categories WHERE parent_id = '51'
44 0.0002 0.00021505355834961
SELECT id FROM categories WHERE parent_id = '101'
45 0.0018 0.0017900466918945
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.00016093254089355
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.00016498565673828
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.00018405914306641
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '51'
49 0.0002 0.0001518726348877
SELECT * FROM categorygroups WHERE id = '1'
50 0.0004 0.00042414665222168
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '2'  AND hidden = 0 ORDER BY sortorder ASC
51 0.0023 0.002284049987793
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.00027084350585938
SELECT id FROM categories WHERE parent_id = '30'
53 0.0023 0.0022871494293213
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.00015592575073242
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.00019621849060059
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
57 0.0001 0.0001380443572998
SELECT * FROM categorygroups WHERE id = '2'
58 0.0048 0.0047881603240967
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 61
59 0.0003 0.00027704238891602
SELECT id FROM categories WHERE parent_id = '61'
60 0.0048 0.0048348903656006
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.00016593933105469
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.00016689300537109
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.00018119812011719
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '61'
64 0.0001 0.0001370906829834
SELECT * FROM categorygroups WHERE id = '2'
65 0.0007 0.00066590309143066
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '10'  AND hidden = 0 ORDER BY sortorder ASC
66 0.0041 0.0040647983551025
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.00028204917907715
SELECT id FROM categories WHERE parent_id = '64'
68 0.0041 0.0040678977966309
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.00016498565673828
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.0001671314239502
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.00017905235290527
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '64'
72 0.0001 0.0001368522644043
SELECT * FROM categorygroups WHERE id = '10'
73 0.0081 0.0080530643463135
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.00029301643371582
SELECT id FROM categories WHERE parent_id = '65'
75 0.0082 0.0081560611724854
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.00017309188842773
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.00017189979553223
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.00018310546875
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '65'
79 0.0001 0.00014019012451172
SELECT * FROM categorygroups WHERE id = '10'
80 0.0025 0.0024518966674805
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.00026798248291016
SELECT id FROM categories WHERE parent_id = '81'
82 0.0025 0.0024979114532471
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.00015711784362793
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.00016403198242188
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.00017595291137695
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '81'
86 0.0001 0.00014686584472656
SELECT * FROM categorygroups WHERE id = '10'
87 0.0024 0.0024399757385254
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.00026798248291016
SELECT id FROM categories WHERE parent_id = '31'
89 0.0025 0.0024771690368652
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.00015997886657715
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.00016689300537109
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.00018310546875
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
93 0.0001 0.00014805793762207
SELECT * FROM categorygroups WHERE id = '10'
94 0.0022 0.0022130012512207
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.00026297569274902
SELECT id FROM categories WHERE parent_id = '66'
96 0.0002 0.00021696090698242
SELECT id FROM categories WHERE parent_id = '131'
97 0.0028 0.0027849674224854
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.00017905235290527
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.00018501281738281
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '66'
101 0.0001 0.0001380443572998
SELECT * FROM categorygroups WHERE id = '10'
102 0.0094 0.0093848705291748
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 34
103 0.0003 0.00030016899108887
SELECT id FROM categories WHERE parent_id = '34'
104 0.0002 0.00021815299987793
SELECT id FROM categories WHERE parent_id = '94'
105 0.0002 0.00021195411682129
SELECT id FROM categories WHERE parent_id = '98'
106 0.0002 0.00021100044250488
SELECT id FROM categories WHERE parent_id = '99'
107 0.0002 0.00021982192993164
SELECT id FROM categories WHERE parent_id = '110'
108 0.0002 0.0002129077911377
SELECT id FROM categories WHERE parent_id = '130'
109 0.0102 0.01018500328064
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (94,98,99,110,130,34)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
110 0.0002 0.00018405914306641
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.00016999244689941
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.00020408630371094
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '34'
113 0.0001 0.00013899803161621
SELECT * FROM categorygroups WHERE id = '10'
114 0.0016 0.0015552043914795
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.00027585029602051
SELECT id FROM categories WHERE parent_id = '32'
116 0.0016 0.0015799999237061
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.0001521110534668
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.00017285346984863
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.00017905235290527
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '32'
120 0.0001 0.0001368522644043
SELECT * FROM categorygroups WHERE id = '10'
121 0.0018 0.0018019676208496
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.0002601146697998
SELECT id FROM categories WHERE parent_id = '89'
123 0.0018 0.0018329620361328
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.00015497207641602
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.00016498565673828
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.0001828670501709
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '89'
127 0.0001 0.00014805793762207
SELECT * FROM categorygroups WHERE id = '10'
128 0.0004 0.00040984153747559
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '17'  AND hidden = 0 ORDER BY sortorder ASC
129 0.0007 0.00069594383239746
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.00024795532226562
SELECT id FROM categories WHERE parent_id = '84'
131 0.0007 0.0007021427154541
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.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 (84)
				  AND p.disabled = 0 
133 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 (84)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
134 0.0002 0.00018000602722168
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '84'
135 0.0001 0.00013589859008789
SELECT * FROM categorygroups WHERE id = '17'
136 0.0007 0.00069308280944824
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.000244140625
SELECT id FROM categories WHERE parent_id = '90'
138 0.0007 0.00072693824768066
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.0001 0.00014781951904297
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (90)
				  AND p.disabled = 0 
140 0.0002 0.00016307830810547
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.00018095970153809
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '90'
142 0.0001 0.00013494491577148
SELECT * FROM categorygroups WHERE id = '17'
143 0.0003 0.00031495094299316
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '20'  AND hidden = 0 ORDER BY sortorder ASC
144 0.0020 0.0020079612731934
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.0002 0.00024914741516113
SELECT id FROM categories WHERE parent_id = '92'
146 0.0020 0.0020411014556885
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.00015401840209961
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.00016188621520996
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.00016403198242188
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '92'
150 0.0001 0.0001370906829834
SELECT * FROM categorygroups WHERE id = '20'
151 0.0054 0.0053849220275879
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
152 0.0004 0.00037693977355957
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-fluid' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
153 0.0002 0.0001678466796875
SELECT value FROM parameters WHERE parameter = 'EBAY_APP_ID' 
154 0.0002 0.00016903877258301
SELECT * FROM sideboxes_pages WHERE sidebox_id = '1'
155 0.0002 0.00017690658569336
SELECT * FROM pages WHERE id = '67'
156 0.0002 0.00016999244689941
SELECT * FROM pages WHERE id = '82'
157 0.0002 0.00017309188842773
SELECT * FROM pages WHERE id = '84'
158 0.0002 0.00015687942504883
SELECT * FROM pages WHERE id = '94'
159 0.0002 0.00016593933105469
SELECT * FROM pages WHERE id = '116'
160 0.0002 0.0002131462097168
SELECT * FROM pages WHERE id = '52'
161 0.0002 0.00017809867858887
SELECT * FROM pages WHERE id = '135'
162 0.0002 0.00016999244689941
SELECT * FROM pages WHERE id = '245'
163 0.0002 0.00017309188842773
SELECT * FROM pages WHERE id = '269'
164 0.0002 0.00020003318786621
SELECT * FROM pages WHERE id = '275'
165 0.0002 0.0001981258392334
SELECT * FROM pages WHERE id = '280'
166 0.0002 0.00021505355834961
SELECT * FROM pages WHERE id = '357'
167 0.0002 0.00016093254089355
SELECT * FROM pages WHERE id = '379'
168 0.0002 0.00015497207641602
SELECT * FROM pages WHERE id = '401'
169 0.0002 0.00016188621520996
SELECT * FROM pages WHERE id = '450'
170 0.0002 0.00016188621520996
SELECT * FROM pages WHERE id = '454'
171 0.0002 0.00017786026000977
SELECT * FROM pages WHERE id = '457'
172 0.0002 0.0001671314239502
SELECT * FROM pages WHERE id = '458'
173 0.0002 0.0001680850982666
SELECT * FROM sideboxes_pages WHERE sidebox_id = '2'
174 0.0002 0.00017189979553223
SELECT * FROM pages WHERE id = '41'
175 0.0002 0.00017309188842773
SELECT * FROM pages WHERE id = '43'
176 0.0002 0.00017619132995605
SELECT * FROM pages WHERE id = '44'
177 0.0002 0.00015997886657715
SELECT * FROM pages WHERE id = '68'
178 0.0002 0.00020909309387207
SELECT * FROM pages WHERE id = '80'
179 0.0002 0.00017189979553223
SELECT * FROM pages WHERE id = '85'
180 0.0002 0.0001680850982666
SELECT * FROM pages WHERE id = '97'
181 0.0002 0.00017881393432617
SELECT * FROM pages WHERE id = '107'
182 0.0002 0.00015878677368164
SELECT * FROM pages WHERE id = '108'
183 0.0002 0.0001530647277832
SELECT * FROM pages WHERE id = '128'
184 0.0002 0.00017619132995605
SELECT * FROM pages WHERE id = '133'
185 0.0002 0.00015878677368164
SELECT * FROM pages WHERE id = '148'
186 0.0002 0.00017809867858887
SELECT * FROM pages WHERE id = '217'
187 0.0002 0.00015807151794434
SELECT * FROM pages WHERE id = '228'
188 0.0002 0.00016212463378906
SELECT * FROM pages WHERE id = '257'
189 0.0002 0.0001680850982666
SELECT * FROM pages WHERE id = '271'
190 0.0002 0.00015902519226074
SELECT * FROM pages WHERE id = '286'
191 0.0002 0.00015711784362793
SELECT * FROM pages WHERE id = '287'
192 0.0002 0.00018215179443359
SELECT * FROM pages WHERE id = '291'
193 0.0002 0.00016593933105469
SELECT * FROM pages WHERE id = '380'
194 0.0002 0.0001671314239502
SELECT * FROM pages WHERE id = '344'
195 0.0002 0.00017499923706055
SELECT * FROM pages WHERE id = '354'
196 0.0002 0.00019598007202148
SELECT * FROM pages WHERE id = '363'
197 0.0002 0.00020408630371094
SELECT * FROM pages WHERE id = '364'
198 0.0002 0.00015878677368164
SELECT * FROM pages WHERE id = '368'
199 0.0002 0.00018811225891113
SELECT * FROM pages WHERE id = '369'
200 0.0002 0.00015783309936523
SELECT * FROM pages WHERE id = '400'
201 0.0002 0.0001680850982666
SELECT * FROM pages WHERE id = '463'
202 0.0002 0.0001828670501709
SELECT * FROM sideboxes_pages WHERE sidebox_id = '33'
203 0.0003 0.0002601146697998
SELECT * FROM pages WHERE id = '66'
204 0.0002 0.00020217895507812
SELECT * FROM pages WHERE id = '77'
205 0.0002 0.00020003318786621
SELECT * FROM pages WHERE id = '90'
206 0.0002 0.00016999244689941
SELECT * FROM pages WHERE id = '414'
207 0.0002 0.00016093254089355
SELECT * FROM pages WHERE id = '119'
208 0.0002 0.00016307830810547
SELECT * FROM pages WHERE id = '406'
209 0.0002 0.00016188621520996
SELECT * FROM pages WHERE id = '149'
210 0.0002 0.00016093254089355
SELECT * FROM pages WHERE id = '150'
211 0.0002 0.0001671314239502
SELECT * FROM pages WHERE id = '412'
212 0.0002 0.0001678466796875
SELECT * FROM pages WHERE id = '162'
213 0.0002 0.00015687942504883
SELECT * FROM pages WHERE id = '164'
214 0.0002 0.00015687942504883
SELECT * FROM pages WHERE id = '167'
215 0.0002 0.0001518726348877
SELECT * FROM pages WHERE id = '180'
216 0.0002 0.00016307830810547
SELECT * FROM pages WHERE id = '187'
217 0.0002 0.00020098686218262
SELECT * FROM pages WHERE id = '265'
218 0.0002 0.0001678466796875
SELECT * FROM pages WHERE id = '268'
219 0.0002 0.00015687942504883
SELECT * FROM pages WHERE id = '411'
220 0.0002 0.00016689300537109
SELECT * FROM pages WHERE id = '290'
221 0.0002 0.00015497207641602
SELECT * FROM pages WHERE id = '413'
222 0.0002 0.00015997886657715
SELECT * FROM pages WHERE id = '409'
223 0.0002 0.00016283988952637
SELECT * FROM pages WHERE id = '327'
224 0.0002 0.00016212463378906
SELECT * FROM pages WHERE id = '336'
225 0.0002 0.0001680850982666
SELECT * FROM pages WHERE id = '351'
226 0.0002 0.00016021728515625
SELECT * FROM pages WHERE id = '358'
227 0.0002 0.00017380714416504
SELECT * FROM pages WHERE id = '360'
228 0.0002 0.00016498565673828
SELECT * FROM pages WHERE id = '362'
229 0.0002 0.00016689300537109
SELECT * FROM pages WHERE id = '366'
230 0.0002 0.00017189979553223
SELECT * FROM pages WHERE id = '370'
231 0.0002 0.00016212463378906
SELECT * FROM pages WHERE id = '377'
232 0.0002 0.00018501281738281
SELECT * FROM pages WHERE id = '386'
233 0.0002 0.00016117095947266
SELECT * FROM pages WHERE id = '408'
234 0.0002 0.00015711784362793
SELECT * FROM pages WHERE id = '415'
235 0.0002 0.00017309188842773
SELECT * FROM pages WHERE id = '416'
236 0.0002 0.00019502639770508
SELECT * FROM pages WHERE id = '419'
237 0.0002 0.00017595291137695
SELECT * FROM pages WHERE id = '423'
238 0.0002 0.00016593933105469
SELECT * FROM pages WHERE id = '427'
239 0.0002 0.00019001960754395
SELECT * FROM pages WHERE id = '428'
240 0.0002 0.00015401840209961
SELECT * FROM pages WHERE id = '432'
241 0.0002 0.00015711784362793
SELECT * FROM pages WHERE id = '433'
242 0.0002 0.00017309188842773
SELECT * FROM pages WHERE id = '436'
243 0.0002 0.00016403198242188
SELECT * FROM pages WHERE id = '437'
244 0.0002 0.00015902519226074
SELECT * FROM pages WHERE id = '461'
245 0.0002 0.00018501281738281
SELECT * FROM pages WHERE id = '464'
246 0.0002 0.00016093254089355
SELECT * FROM sideboxes_pages WHERE sidebox_id = '34'
247 0.0002 0.00017404556274414
SELECT * FROM pages WHERE id = '74'
248 0.0002 0.00016188621520996
SELECT * FROM pages WHERE id = '137'
249 0.0002 0.00016593933105469
SELECT * FROM pages WHERE id = '145'
250 0.0002 0.00016093254089355
SELECT * FROM pages WHERE id = '156'
251 0.0002 0.00016093254089355
SELECT * FROM pages WHERE id = '407'
252 0.0002 0.00015592575073242
SELECT * FROM pages WHERE id = '410'
253 0.0002 0.00019001960754395
SELECT * FROM pages WHERE id = '266'
254 0.0002 0.00021195411682129
SELECT * FROM pages WHERE id = '316'
255 0.0002 0.00016617774963379
SELECT * FROM pages WHERE id = '332'
256 0.0002 0.00019311904907227
SELECT * FROM pages WHERE id = '334'
257 0.0002 0.0001680850982666
SELECT * FROM pages WHERE id = '367'
258 0.0002 0.00016403198242188
SELECT * FROM pages WHERE id = '387'
259 0.0002 0.00016307830810547
SELECT * FROM pages WHERE id = '389'
260 0.0002 0.0001680850982666
SELECT * FROM pages WHERE id = '397'
261 0.0002 0.00017690658569336
SELECT * FROM pages WHERE id = '449'
262 0.0002 0.00018596649169922
SELECT * FROM sideboxes_pages WHERE sidebox_id = '35'
263 0.0002 0.00020003318786621
SELECT * FROM pages WHERE id = '42'
264 0.0002 0.00016307830810547
SELECT * FROM pages WHERE id = '79'
265 0.0002 0.00017094612121582
SELECT * FROM pages WHERE id = '86'
266 0.0002 0.00015807151794434
SELECT * FROM pages WHERE id = '95'
267 0.0002 0.00017595291137695
SELECT * FROM pages WHERE id = '102'
268 0.0002 0.00016093254089355
SELECT * FROM pages WHERE id = '109'
269 0.0002 0.0002138614654541
SELECT * FROM pages WHERE id = '114'
270 0.0002 0.00019598007202148
SELECT * FROM pages WHERE id = '121'
271 0.0002 0.00020313262939453
SELECT * FROM pages WHERE id = '138'
272 0.0002 0.00017595291137695
SELECT * FROM pages WHERE id = '142'
273 0.0002 0.0001990795135498
SELECT * FROM pages WHERE id = '62'
274 0.0002 0.00015902519226074
SELECT * FROM pages WHERE id = '157'
275 0.0002 0.0001680850982666
SELECT * FROM pages WHERE id = '246'
276 0.0002 0.0001988410949707
SELECT * FROM pages WHERE id = '276'
277 0.0002 0.00020623207092285
SELECT * FROM pages WHERE id = '278'
278 0.0002 0.0002129077911377
SELECT * FROM pages WHERE id = '279'
279 0.0002 0.00017213821411133
SELECT * FROM pages WHERE id = '317'
280 0.0002 0.00016307830810547
SELECT * FROM pages WHERE id = '405'
281 0.0002 0.0001978874206543
SELECT * FROM pages WHERE id = '343'
282 0.0002 0.00016903877258301
SELECT * FROM pages WHERE id = '345'
283 0.0002 0.0001978874206543
SELECT * FROM pages WHERE id = '346'
284 0.0002 0.00016903877258301
SELECT * FROM pages WHERE id = '347'
285 0.0002 0.00017189979553223
SELECT * FROM pages WHERE id = '348'
286 0.0002 0.00017595291137695
SELECT * FROM pages WHERE id = '349'
287 0.0002 0.00016212463378906
SELECT * FROM pages WHERE id = '381'
288 0.0002 0.00016093254089355
SELECT * FROM pages WHERE id = '392'
289 0.0002 0.00015902519226074
SELECT * FROM pages WHERE id = '393'
290 0.0002 0.00015902519226074
SELECT * FROM pages WHERE id = '394'
291 0.0002 0.00015807151794434
SELECT * FROM pages WHERE id = '395'
292 0.0002 0.00016999244689941
SELECT * FROM pages WHERE id = '399'
293 0.0002 0.00016593933105469
SELECT * FROM pages WHERE id = '421'
294 0.0002 0.00015401840209961
SELECT * FROM pages WHERE id = '426'
295 0.0002 0.00015401840209961
SELECT * FROM pages WHERE id = '430'
296 0.0002 0.00016498565673828
SELECT * FROM pages WHERE id = '431'
297 0.0002 0.00018000602722168
SELECT * FROM pages WHERE id = '434'
298 0.0002 0.00016999244689941
SELECT * FROM pages WHERE id = '435'
299 0.0002 0.00017404556274414
SELECT * FROM pages WHERE id = '440'
300 0.0002 0.00016903877258301
SELECT * FROM pages WHERE id = '441'
301 0.0002 0.00016117095947266
SELECT * FROM pages WHERE id = '451'
302 0.0002 0.00016498565673828
SELECT * FROM pages WHERE id = '453'
303 0.0002 0.00015687942504883
SELECT * FROM sideboxes_pages WHERE sidebox_id = '37'
304 0.0002 0.00017714500427246
SELECT * FROM pages WHERE id = '146'
305 0.0002 0.00015902519226074
SELECT * FROM pages WHERE id = '158'
306 0.0002 0.00015592575073242
SELECT * FROM pages WHERE id = '163'
307 0.0003 0.00025200843811035
SELECT * FROM pages WHERE id = '293'
308 0.0002 0.00017213821411133
SELECT * FROM pages WHERE id = '340'
309 0.0002 0.00016999244689941
SELECT * FROM pages WHERE id = '417'
310 0.0002 0.00015592575073242
SELECT * FROM sideboxes_pages WHERE sidebox_id = '40'
311 0.0002 0.00017499923706055
SELECT * FROM pages WHERE id = '173'
312 0.0002 0.00017094612121582
SELECT * FROM pages WHERE id = '181'
313 0.0002 0.00015902519226074
SELECT * FROM pages WHERE id = '288'
314 0.0002 0.00016593933105469
SELECT * FROM pages WHERE id = '299'
315 0.0002 0.00016307830810547
SELECT * FROM pages WHERE id = '300'
316 0.0002 0.00016903877258301
SELECT * FROM pages WHERE id = '383'
317 0.0002 0.00015807151794434
SELECT * FROM pages WHERE id = '385'
318 0.0002 0.0001671314239502
SELECT * FROM pages WHERE id = '438'
319 0.0002 0.00017404556274414
SELECT * FROM pages WHERE id = '442'
320 0.0002 0.00015497207641602
SELECT * FROM sideboxes_pages WHERE sidebox_id = '38'
321 0.0003 0.00026702880859375
SELECT * FROM pages WHERE id = '103'
322 0.0002 0.00023102760314941
SELECT * FROM pages WHERE id = '134'
323 0.0002 0.00016093254089355
SELECT * FROM pages WHERE id = '139'
324 0.0002 0.00016689300537109
SELECT * FROM pages WHERE id = '143'
325 0.0002 0.00016689300537109
SELECT * FROM pages WHERE id = '234'
326 0.0002 0.00018000602722168
SELECT * FROM pages WHERE id = '248'
327 0.0002 0.00015997886657715
SELECT * FROM pages WHERE id = '260'
328 0.0002 0.00016689300537109
SELECT * FROM pages WHERE id = '398'
329 0.0002 0.0001678466796875
SELECT * FROM sideboxes_pages WHERE sidebox_id = '29'
330 0.0002 0.00019383430480957
SELECT * FROM pages WHERE id = '61'
331 0.0002 0.00017309188842773
SELECT * FROM pages WHERE id = '87'
332 0.0002 0.00017309188842773
SELECT * FROM pages WHERE id = '104'
333 0.0002 0.00022602081298828
SELECT * FROM pages WHERE id = '115'
334 0.0002 0.00016307830810547
SELECT * FROM pages WHERE id = '124'
335 0.0002 0.00017809867858887
SELECT * FROM pages WHERE id = '144'
336 0.0002 0.00018692016601562
SELECT * FROM pages WHERE id = '151'
337 0.0002 0.00016212463378906
SELECT * FROM pages WHERE id = '199'
338 0.0002 0.00016999244689941
SELECT * FROM pages WHERE id = '200'
339 0.0002 0.00015902519226074
SELECT * FROM pages WHERE id = '304'
340 0.0002 0.00015807151794434
SELECT * FROM pages WHERE id = '321'
341 0.0002 0.00015592575073242
SELECT * FROM pages WHERE id = '333'
342 0.0002 0.00018501281738281
SELECT * FROM pages WHERE id = '350'
343 0.0002 0.00015687942504883
SELECT * FROM pages WHERE id = '378'
344 0.0002 0.00016093254089355
SELECT * FROM pages WHERE id = '422'
345 0.0002 0.00020003318786621
SELECT * FROM pages WHERE id = '425'
346 0.0002 0.00017285346984863
SELECT * FROM pages WHERE id = '443'
347 0.0002 0.00015997886657715
SELECT * FROM pages WHERE id = '444'
348 0.0002 0.00015592575073242
SELECT * FROM pages WHERE id = '445'
349 0.0002 0.00016403198242188
SELECT * FROM pages WHERE id = '446'
350 0.0002 0.00016903877258301
SELECT * FROM pages WHERE id = '447'
351 0.0002 0.00015902519226074
SELECT * FROM pages WHERE id = '448'
352 0.0002 0.00016117095947266
SELECT * FROM pages WHERE id = '455'
353 0.0002 0.00016617774963379
SELECT * FROM pages WHERE id = '456'
354 0.0002 0.00015497207641602
SELECT * FROM pages WHERE id = '459'
355 0.0002 0.00018215179443359
SELECT * FROM pages WHERE id = '460'
356 0.0002 0.00016307830810547
SELECT * FROM pages WHERE id = '462'
357 0.0002 0.00015902519226074
SELECT * FROM sideboxes_pages WHERE sidebox_id = '32'
358 0.0002 0.00018095970153809
SELECT * FROM pages WHERE id = '153'
359 0.0002 0.0002131462097168
SELECT * FROM pages WHERE id = '182'
360 0.0002 0.00016403198242188
SELECT * FROM pages WHERE id = '238'
361 0.0002 0.00015497207641602
SELECT * FROM pages WHERE id = '240'
362 0.0002 0.00015091896057129
SELECT * FROM pages WHERE id = '242'
363 0.0001 0.00014996528625488
SELECT * FROM pages WHERE id = '252'
364 0.0001 0.00014996528625488
SELECT * FROM pages WHERE id = '253'
365 0.0002 0.0001680850982666
SELECT * FROM pages WHERE id = '262'
366 0.0002 0.00015115737915039
SELECT * FROM pages WHERE id = '267'
367 0.0002 0.00015711784362793
SELECT * FROM pages WHERE id = '420'
368 0.0001 0.00014996528625488
SELECT value FROM parameters WHERE parameter = 'GOOGLE_SITE_KEY' 
369 0.0001 0.00013113021850586
SELECT value FROM parameters WHERE parameter = 'GOOGLE_SECRET_KEY' 
370 0.0001 0.00013113021850586
SELECT value FROM parameters WHERE parameter = 'GOOGLE_RECAPTCHA_TYPE' 
371 0.0014 0.0013940334320068
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
372 0.0002 0.00019311904907227
SELECT value FROM parameters WHERE parameter = 'GOOGLE_SITE_KEY' 
373 0.0001 0.00013494491577148
SELECT value FROM parameters WHERE parameter = 'GOOGLE_SECRET_KEY' 
374 0.0001 0.00013113021850586
SELECT value FROM parameters WHERE parameter = 'GOOGLE_RECAPTCHA_TYPE' 
375 0.0003 0.00029611587524414
SELECT * FROM products WHERE pagename = 'vipertek-vts-979-999000000-stun-gun-rechargeable-with-safety-disable-pin-led-flashlight-black'
376 0.0002 0.0001990795135498
SELECT * FROM manufacturers WHERE id = '3799'
377 0.0004 0.00038719177246094
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '3799'
378 0.0001 0.00013518333435059
SELECT filename FROM manufacturerimages WHERE manufacturer_id = '3799' LIMIT 1
379 0.0003 0.0003361701965332
SELECT pagename, id FROM products p WHERE manufacturer_id = '3799' ORDER BY RAND() LIMIT 1
380 0.0003 0.00026988983154297
SELECT * FROM productimages WHERE product_id = '248726' ORDER BY sortorder ASC
381 0.0003 0.00034403800964355
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '3799'
382 0.0004 0.00036501884460449
SELECT COUNT(DISTINCT(p.id)) FROM products p
				WHERE p.manufacturer_id = '3799'
				  AND p.hidden = 0
				  AND p.enabled = 1
				  AND p.parent_id = 0 
383 0.0001 0.00012803077697754
SELECT * FROM manufacturerimages WHERE manufacturer_id = '3799'
384 0.0001 0.00014686584472656
SELECT category_id FROM products_categories WHERE product_id = '406081'
385 0.0003 0.00026679039001465
SELECT * FROM categories WHERE id = '84'
386 0.0007 0.00068497657775879
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
387 0.0001 0.0001220703125
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 84
388 0.0003 0.00026702880859375
SELECT id FROM categories WHERE parent_id = '84'
389 0.0007 0.00069689750671387
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 
390 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 (84)
				  AND p.disabled = 0 
391 0.0002 0.00016999244689941
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 
392 0.0002 0.00018405914306641
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '84'
393 0.0002 0.00023102760314941
SELECT * FROM productimages WHERE product_id = '406081' ORDER BY sortorder ASC
394 0.0002 0.00023579597473145
SELECT * FROM product_image_select WHERE product_id = '406081'
395 0.0001 0.0001370906829834
SELECT * FROM productcustomimages WHERE product_id = '406081'
396 0.0001 0.00012493133544922
SELECT * FROM productfeeds WHERE product_id = '406081' ORDER BY item_date DESC
397 0.0003 0.00034999847412109
SELECT a.name, n.displayname, a.value, n.units, n.valuetype FROM productattributes a, productattributenames n WHERE product_id = '406081' AND a.name = n.originalname AND n.display = 1 AND n.hidden = 0
398 0.0003 0.00033378601074219
SELECT DISTINCT(pt.tag_id) FROM product_tags pt, tags t WHERE pt.tag_id = t.id AND pt.product_id = '406081' AND t.hidden = 0 AND display_product = 1
399 0.0002 0.00015401840209961
SELECT * FROM tags WHERE id = '9084'
400 0.0005 0.00051712989807129
SELECT COUNT(DISTINCT(p.id)) FROM products p, product_tags t
				WHERE p.id = t.product_id
				  AND t.tag_id = '9084'
				  AND p.parent_id = 0
				  AND p.enabled = 1
				  AND p.hidden = 0
401 0.0005 0.00051712989807129
SELECT COUNT(DISTINCT(p.id)) FROM products p, product_tags t
				WHERE p.id = t.product_id
				  AND t.tag_id = '9084'
				  AND p.parent_id = 0
				  AND hidden = 0
				  AND enabled = 1 
402 0.0005 0.00054001808166504
SELECT p.id FROM products p, product_tags t WHERE p.id = t.product_id AND t.tag_id = '9084' AND p.hidden = 0 AND p.salesrank > 0 AND (p.price > 0 OR p.parent = 1) ORDER BY p.salesrank ASC LIMIT 1
403 0.0002 0.00020790100097656
SELECT * FROM productimages WHERE product_id = '409450' ORDER BY sortorder ASC
404 0.0002 0.0001528263092041
SELECT * FROM tags WHERE id = '2540'
405 0.0007 0.00069999694824219
SELECT COUNT(DISTINCT(p.id)) FROM products p, product_tags t
				WHERE p.id = t.product_id
				  AND t.tag_id = '2540'
				  AND p.parent_id = 0
				  AND p.enabled = 1
				  AND p.hidden = 0
406 0.0007 0.00065994262695312
SELECT COUNT(DISTINCT(p.id)) FROM products p, product_tags t
				WHERE p.id = t.product_id
				  AND t.tag_id = '2540'
				  AND p.parent_id = 0
				  AND hidden = 0
				  AND enabled = 1 
407 0.0007 0.00070786476135254
SELECT p.id FROM products p, product_tags t WHERE p.id = t.product_id AND t.tag_id = '2540' AND p.hidden = 0 AND p.salesrank > 0 AND (p.price > 0 OR p.parent = 1) ORDER BY p.salesrank ASC LIMIT 1
408 0.0002 0.00020194053649902
SELECT * FROM productimages WHERE product_id = '409450' ORDER BY sortorder ASC
409 0.0334 0.033354043960571
SELECT * FROM productamazoncontent WHERE product_id = '406081'
410 0.0028 0.0028059482574463
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '406081' AND a.name = n.originalname
411 0.0002 0.00023603439331055
SELECT * FROM productoffers WHERE product_id = '406081' AND merchantid = 'ATVPDKIKX0DER'
412 0.0002 0.00022101402282715
SELECT * FROM productoffers
                WHERE product_id = '406081' AND price > 0
                ORDER BY price ASC LIMIT 1
413 0.0004 0.0003809928894043
SELECT value FROM productattributes WHERE product_id = '406081' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
414 0.0002 0.0001530647277832
UPDATE products SET price = '1398' WHERE id = '406081'
415 0.2326 0.23261594772339
SELECT *, MATCH (description, keyfeatures, title) AGAINST ('vipertek' IN BOOLEAN MODE) AS `searchrelevance` FROM products WHERE MATCH (description, keyfeatures, title) AGAINST ('vipertek' IN BOOLEAN MODE) AND 406081 <> 0 AND enabled = 1 AND hidden = 0 AND offers > 0 AND parent_id = 0 ORDER BY `searchrelevance` LIMIT 6
416 0.0003 0.00031900405883789
SELECT * FROM productimages WHERE product_id = '406132' ORDER BY sortorder ASC
417 0.0002 0.00023794174194336
SELECT * FROM product_image_select WHERE product_id = '406132'
418 0.0001 0.00012612342834473
SELECT * FROM productcustomimages WHERE product_id = '406132'
419 0.0022 0.002241849899292
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '406132' AND a.name = n.originalname
420 0.0002 0.00018906593322754
SELECT * FROM productoffers WHERE product_id = '406132' AND merchantid = 'ATVPDKIKX0DER'
421 0.0002 0.00021600723266602
SELECT * FROM productoffers
                WHERE product_id = '406132' AND price > 0
                ORDER BY price ASC LIMIT 1
422 0.0004 0.00037503242492676
SELECT value FROM productattributes WHERE product_id = '406132' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
423 0.0001 0.00013303756713867
UPDATE products SET price = '1598' WHERE id = '406132'
424 0.0002 0.00020813941955566
SELECT * FROM productimages WHERE product_id = '406135' ORDER BY sortorder ASC
425 0.0002 0.00022506713867188
SELECT * FROM product_image_select WHERE product_id = '406135'
426 0.0001 0.00012302398681641
SELECT * FROM productcustomimages WHERE product_id = '406135'
427 0.0022 0.0021500587463379
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '406135' AND a.name = n.originalname
428 0.0002 0.0001828670501709
SELECT * FROM productoffers WHERE product_id = '406135' AND merchantid = 'ATVPDKIKX0DER'
429 0.0002 0.00019502639770508
SELECT * FROM productoffers
                WHERE product_id = '406135' AND price > 0
                ORDER BY price ASC LIMIT 1
430 0.0004 0.00035595893859863
SELECT value FROM productattributes WHERE product_id = '406135' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
431 0.0001 0.00011897087097168
UPDATE products SET price = '1098' WHERE id = '406135'
432 0.0002 0.00020694732666016
SELECT * FROM productimages WHERE product_id = '406077' ORDER BY sortorder ASC
433 0.0002 0.00020909309387207
SELECT * FROM product_image_select WHERE product_id = '406077'
434 0.0001 0.00012803077697754
SELECT * FROM productcustomimages WHERE product_id = '406077'
435 0.0023 0.0023009777069092
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '406077' AND a.name = n.originalname
436 0.0002 0.00018095970153809
SELECT * FROM productoffers WHERE product_id = '406077' AND merchantid = 'ATVPDKIKX0DER'
437 0.0002 0.00019598007202148
SELECT * FROM productoffers
                WHERE product_id = '406077' AND price > 0
                ORDER BY price ASC LIMIT 1
438 0.0004 0.00038504600524902
SELECT value FROM productattributes WHERE product_id = '406077' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
439 0.0001 0.00011801719665527
UPDATE products SET price = '1098' WHERE id = '406077'
440 0.0002 0.00021600723266602
SELECT * FROM productimages WHERE product_id = '406078' ORDER BY sortorder ASC
441 0.0002 0.00021886825561523
SELECT * FROM product_image_select WHERE product_id = '406078'
442 0.0001 0.00012111663818359
SELECT * FROM productcustomimages WHERE product_id = '406078'
443 0.0028 0.0027871131896973
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '406078' AND a.name = n.originalname
444 0.0002 0.00019311904907227
SELECT * FROM productoffers WHERE product_id = '406078' AND merchantid = 'ATVPDKIKX0DER'
445 0.0002 0.0001990795135498
SELECT * FROM productoffers
                WHERE product_id = '406078' AND price > 0
                ORDER BY price ASC LIMIT 1
446 0.0004 0.00039196014404297
SELECT value FROM productattributes WHERE product_id = '406078' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
447 0.0001 0.00011682510375977
UPDATE products SET price = '998' WHERE id = '406078'
448 0.0002 0.0002140998840332
SELECT * FROM productimages WHERE product_id = '406081' ORDER BY sortorder ASC
449 0.0002 0.00020885467529297
SELECT * FROM product_image_select WHERE product_id = '406081'
450 0.0001 0.00012111663818359
SELECT * FROM productcustomimages WHERE product_id = '406081'
451 0.0023 0.0022869110107422
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '406081' AND a.name = n.originalname
452 0.0002 0.00018501281738281
SELECT * FROM productoffers WHERE product_id = '406081' AND merchantid = 'ATVPDKIKX0DER'
453 0.0002 0.00021600723266602
SELECT * FROM productoffers
                WHERE product_id = '406081' AND price > 0
                ORDER BY price ASC LIMIT 1
454 0.0004 0.00036907196044922
SELECT value FROM productattributes WHERE product_id = '406081' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
455 0.0001 0.00011992454528809
UPDATE products SET price = '1398' WHERE id = '406081'
456 0.0002 0.00021195411682129
SELECT * FROM productimages WHERE product_id = '406082' ORDER BY sortorder ASC
457 0.0002 0.00021505355834961
SELECT * FROM product_image_select WHERE product_id = '406082'
458 0.0001 0.0001218318939209
SELECT * FROM productcustomimages WHERE product_id = '406082'
459 0.0028 0.0027511119842529
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '406082' AND a.name = n.originalname
460 0.0002 0.00019001960754395
SELECT * FROM productoffers WHERE product_id = '406082' AND merchantid = 'ATVPDKIKX0DER'
461 0.0002 0.00020694732666016
SELECT * FROM productoffers
                WHERE product_id = '406082' AND price > 0
                ORDER BY price ASC LIMIT 1
462 0.0004 0.00038790702819824
SELECT value FROM productattributes WHERE product_id = '406082' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
463 0.0001 0.00012588500976562
UPDATE products SET price = '1098' WHERE id = '406082'
464 0.2333 0.23334217071533
SELECT *, MATCH (description, keyfeatures, title) AGAINST ('stun gun' IN BOOLEAN MODE) AS `searchrelevance` FROM products WHERE MATCH (description, keyfeatures, title) AGAINST ('stun gun' IN BOOLEAN MODE) AND 406081 <> 0 AND enabled = 1 AND hidden = 0 AND offers > 0 AND parent_id = 0 ORDER BY `searchrelevance` LIMIT 1
465 0.0003 0.00033307075500488
SELECT * FROM productimages WHERE product_id = '406135' ORDER BY sortorder ASC
466 0.0002 0.00023293495178223
SELECT * FROM product_image_select WHERE product_id = '406135'
467 0.0001 0.00012493133544922
SELECT * FROM productcustomimages WHERE product_id = '406135'
468 0.0022 0.0021860599517822
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '406135' AND a.name = n.originalname
469 0.0002 0.00019121170043945
SELECT * FROM productoffers WHERE product_id = '406135' AND merchantid = 'ATVPDKIKX0DER'
470 0.0002 0.00022101402282715
SELECT * FROM productoffers
                WHERE product_id = '406135' AND price > 0
                ORDER BY price ASC LIMIT 1
471 0.0004 0.00036096572875977
SELECT value FROM productattributes WHERE product_id = '406135' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
472 0.0001 0.00013399124145508
UPDATE products SET price = '1098' WHERE id = '406135'
473 0.2321 0.23210787773132
SELECT *, MATCH (description, keyfeatures, title) AGAINST ('disable pin' IN BOOLEAN MODE) AS `searchrelevance` FROM products WHERE MATCH (description, keyfeatures, title) AGAINST ('disable pin' IN BOOLEAN MODE) AND 406081 <> 0 AND enabled = 1 AND hidden = 0 AND offers > 0 AND parent_id = 0 ORDER BY `searchrelevance` LIMIT 1
474 0.0003 0.00034785270690918
SELECT * FROM productimages WHERE product_id = '406081' ORDER BY sortorder ASC
475 0.0002 0.00022602081298828
SELECT * FROM product_image_select WHERE product_id = '406081'
476 0.0001 0.00012397766113281
SELECT * FROM productcustomimages WHERE product_id = '406081'
477 0.0023 0.0022921562194824
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '406081' AND a.name = n.originalname
478 0.0002 0.00020098686218262
SELECT * FROM productoffers WHERE product_id = '406081' AND merchantid = 'ATVPDKIKX0DER'
479 0.0002 0.00021195411682129
SELECT * FROM productoffers
                WHERE product_id = '406081' AND price > 0
                ORDER BY price ASC LIMIT 1
480 0.0004 0.00037813186645508
SELECT value FROM productattributes WHERE product_id = '406081' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
481 0.0001 0.0001370906829834
UPDATE products SET price = '1398' WHERE id = '406081'
482 0.2343 0.23433303833008
SELECT *, MATCH (description, keyfeatures, title) AGAINST ('rechargeable' IN BOOLEAN MODE) AS `searchrelevance` FROM products WHERE MATCH (description, keyfeatures, title) AGAINST ('rechargeable' IN BOOLEAN MODE) AND 406081 <> 0 AND enabled = 1 AND hidden = 0 AND offers > 0 AND parent_id = 0 ORDER BY `searchrelevance` LIMIT 1
483 0.0004 0.00042891502380371
SELECT * FROM productimages WHERE product_id = '128352' ORDER BY sortorder ASC
484 0.0002 0.00023102760314941
SELECT * FROM product_image_select WHERE product_id = '128352'
485 0.0001 0.00012493133544922
SELECT * FROM productcustomimages WHERE product_id = '128352'
486 0.0026 0.0025901794433594
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '128352' AND a.name = n.originalname
487 0.0002 0.00020694732666016
SELECT * FROM productoffers WHERE product_id = '128352' AND merchantid = 'ATVPDKIKX0DER'
488 0.0002 0.00021696090698242
SELECT * FROM productoffers
                WHERE product_id = '128352' AND price > 0
                ORDER BY price ASC LIMIT 1
489 0.0004 0.00041103363037109
SELECT value FROM productattributes WHERE product_id = '128352' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
490 0.0001 0.00013399124145508
UPDATE products SET price = '7345' WHERE id = '128352'
491 0.0001 0.00014185905456543
SELECT value FROM parameters WHERE parameter = 'EBAY_CACHE_TIME' 
492 0.0001 0.00011920928955078
SELECT value FROM parameters WHERE parameter = 'EBAY_APP_ID' 
493 0.0001 0.00011706352233887
SELECT value FROM parameters WHERE parameter = 'EBAY_TRACKING_ID' 
494 0.0001 0.00011587142944336
SELECT value FROM parameters WHERE parameter = 'EBAY_NETWORK_ID' 
495 0.0001 0.00011491775512695
SELECT value FROM parameters WHERE parameter = 'EBAY_LOCALE' 
496 0.0001 0.00011396408081055
SELECT value FROM parameters WHERE parameter = 'EBAY_AUTH_TOKEN' 
497 0.0001 0.00014400482177734
SELECT * FROM ebay_locale_details WHERE cur_code = 'USD' 
498 0.1835 0.1835310459137
SELECT * FROM ebay_products_cache WHERE cachekey = '01857cbd2f2d6b1f41ebf34ee86fcb32' 
499 0.0003 0.0002748966217041
SELECT value FROM parameters WHERE parameter = 'EBAY_APP_ID' 
500 0.0001 0.00012707710266113
SELECT value FROM parameters WHERE parameter = 'EBAY_TRACKING_ID' 
501 0.0001 0.00011992454528809
SELECT value FROM parameters WHERE parameter = 'EBAY_NETWORK_ID' 
502 0.0001 0.00011801719665527
SELECT value FROM parameters WHERE parameter = 'EBAY_LOCALE' 
503 0.0001 0.00011801719665527
SELECT value FROM parameters WHERE parameter = 'EBAY_AUTH_TOKEN' 
504 0.1839 0.1839280128479
SELECT * FROM ebay_products_cache WHERE cachekey = '01857cbd2f2d6b1f41ebf34ee86fcb32' 
505 0.0003 0.00027203559875488
SELECT id,asin FROM products WHERE parent_id = 406081
506 0.0003 0.00034308433532715
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '406081' ORDER BY timestamp DESC
507 0.0002 0.00016307830810547
SELECT category_id FROM products_categories WHERE product_id = '406081'
508 0.0003 0.00026202201843262
SELECT * FROM categories WHERE id = '84'
509 0.0007 0.00074481964111328
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
510 0.0001 0.00012683868408203
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 84
511 0.0003 0.00026488304138184
SELECT id FROM categories WHERE parent_id = '84'
512 0.0007 0.00072002410888672
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 
513 0.0002 0.00016093254089355
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 
514 0.0002 0.00016498565673828
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (84)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
515 0.0002 0.00018596649169922
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '84'
516 0.0023 0.0022969245910645
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '406081' AND a.name = n.originalname
517 0.0002 0.00020408630371094
SELECT * FROM productoffers WHERE product_id = '406081' AND merchantid = 'ATVPDKIKX0DER'
518 0.0002 0.00023007392883301
SELECT * FROM productoffers
                WHERE product_id = '406081' AND price > 0
                ORDER BY price ASC LIMIT 1
519 0.0002 0.00022101402282715
SELECT * FROM products WHERE id = '406081'
520 0.0004 0.00040316581726074
SELECT value FROM productattributes WHERE product_id = '406081' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
521 0.0001 0.00014090538024902
UPDATE products SET price = '1398' WHERE id = '406081'
522 0.0023 0.0022540092468262
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '406081' AND a.name = n.originalname
523 0.0002 0.00020313262939453
SELECT * FROM productoffers WHERE product_id = '406081' AND merchantid = 'ATVPDKIKX0DER'
524 0.0002 0.00022196769714355
SELECT * FROM productoffers
                WHERE product_id = '406081' AND price > 0
                ORDER BY price ASC LIMIT 1
525 0.0002 0.0001521110534668
SELECT category_id FROM products_categories WHERE product_id = '406081'
526 0.0001 0.00013303756713867
SELECT parent_id FROM categories WHERE id = '84'
527 0.0002 0.00022315979003906
SELECT * FROM categories WHERE id = '84'
528 0.0007 0.00067710876464844
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
529 0.0001 0.00012302398681641
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 84
530 0.0002 0.00024914741516113
SELECT id FROM categories WHERE parent_id = '84'
531 0.0007 0.00071096420288086
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 
532 0.0002 0.00015711784362793
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 
533 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 (84)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
534 0.0002 0.00018095970153809
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '84'
535 0.0002 0.00018596649169922
SELECT * FROM template_info WHERE templateuid = 'fsb-fluid'
536 0.0002 0.00019621849060059
SELECT * FROM pages WHERE id = 2
537 0.0002 0.00015401840209961
SELECT * FROM pages WHERE id = 4
538 0.0002 0.00015091896057129
SELECT * FROM pages WHERE id = 12
539 0.0002 0.00015091896057129
SELECT * FROM pages WHERE id = 10
540 0.0002 0.0001528263092041
SELECT * FROM pages WHERE id = 7
541 0.0002 0.00016689300537109
SELECT * FROM pages WHERE id = 18
542 0.0002 0.00015497207641602
SELECT * FROM pages WHERE id = 28
543 0.0002 0.00015783309936523
SELECT * FROM pages WHERE id = 13
544 0.0002 0.00015592575073242
SELECT * FROM pages WHERE id = 3
545 0.0429 0.042937994003296
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
546 0.0002 0.00023698806762695
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:1560876662;s:8:\"products\";a:6:{i:1;s:6:\"398315\";i:6;s:6:\"170197\";i:11;s:6:\"402983\";i:12;s:6:\"103845\";i:15;s:6:\"414825\";i:21;s:6:\"405644\";}}' WHERE id = '175'
547 0.0005 0.0004880428314209
SELECT * FROM products WHERE id IN (398315,170197,402983,103845,414825,405644) ORDER BY FIELD(id, 398315,170197,402983,103845,414825,405644 )
548 0.0002 0.00024199485778809
SELECT * FROM productimages WHERE product_id = '398315' ORDER BY sortorder ASC
549 0.0002 0.00024294853210449
SELECT * FROM product_image_select WHERE product_id = '398315'
550 0.0001 0.00013995170593262
SELECT * FROM productcustomimages WHERE product_id = '398315'
551 0.0025 0.0025031566619873
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '398315' AND a.name = n.originalname
552 0.0002 0.00020885467529297
SELECT * FROM productoffers WHERE product_id = '398315' AND merchantid = 'ATVPDKIKX0DER'
553 0.0002 0.00021982192993164
SELECT * FROM productoffers
                WHERE product_id = '398315' AND price > 0
                ORDER BY price ASC LIMIT 1
554 0.0004 0.00039887428283691
SELECT value FROM productattributes WHERE product_id = '398315' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
555 0.0001 0.00013399124145508
UPDATE products SET price = '1999' WHERE id = '398315'
556 0.0007 0.00068402290344238
SELECT * FROM productimages WHERE product_id = '170197' ORDER BY sortorder ASC
557 0.0002 0.00024509429931641
SELECT * FROM product_image_select WHERE product_id = '170197'
558 0.0001 0.0001370906829834
SELECT * FROM productcustomimages WHERE product_id = '170197'
559 0.0032 0.0032479763031006
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '170197' AND a.name = n.originalname
560 0.0002 0.00019097328186035
SELECT * FROM productoffers WHERE product_id = '170197' AND merchantid = 'ATVPDKIKX0DER'
561 0.0002 0.00022196769714355
SELECT * FROM productoffers
                WHERE product_id = '170197' AND price > 0
                ORDER BY price ASC LIMIT 1
562 0.0004 0.00043106079101562
SELECT value FROM productattributes WHERE product_id = '170197' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
563 0.0001 0.00013208389282227
UPDATE products SET price = '324500' WHERE id = '170197'
564 0.0002 0.00021100044250488
SELECT * FROM productimages WHERE product_id = '402983' ORDER BY sortorder ASC
565 0.0002 0.00023603439331055
SELECT * FROM product_image_select WHERE product_id = '402983'
566 0.0001 0.00013279914855957
SELECT * FROM productcustomimages WHERE product_id = '402983'
567 0.0022 0.0022201538085938
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '402983' AND a.name = n.originalname
568 0.0002 0.00019311904907227
SELECT * FROM productoffers WHERE product_id = '402983' AND merchantid = 'ATVPDKIKX0DER'
569 0.0002 0.00022697448730469
SELECT * FROM productoffers
                WHERE product_id = '402983' AND price > 0
                ORDER BY price ASC LIMIT 1
570 0.0004 0.0003659725189209
SELECT value FROM productattributes WHERE product_id = '402983' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
571 0.0001 0.00013589859008789
UPDATE products SET price = '10392' WHERE id = '402983'
572 0.0002 0.00021481513977051
SELECT * FROM productimages WHERE product_id = '103845' ORDER BY sortorder ASC
573 0.0002 0.00023698806762695
SELECT * FROM product_image_select WHERE product_id = '103845'
574 0.0001 0.00013518333435059
SELECT * FROM productcustomimages WHERE product_id = '103845'
575 0.0024 0.0024020671844482
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '103845' AND a.name = n.originalname
576 0.0002 0.00019216537475586
SELECT * FROM productoffers WHERE product_id = '103845' AND merchantid = 'ATVPDKIKX0DER'
577 0.0002 0.00022196769714355
SELECT * FROM productoffers
                WHERE product_id = '103845' AND price > 0
                ORDER BY price ASC LIMIT 1
578 0.0004 0.00038719177246094
SELECT value FROM productattributes WHERE product_id = '103845' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
579 0.0001 0.00012993812561035
UPDATE products SET price = '14499' WHERE id = '103845'
580 0.0002 0.00022196769714355
SELECT * FROM productimages WHERE product_id = '414825' ORDER BY sortorder ASC
581 0.0002 0.00022792816162109
SELECT * FROM product_image_select WHERE product_id = '414825'
582 0.0001 0.00013399124145508
SELECT * FROM productcustomimages WHERE product_id = '414825'
583 0.0020 0.0019969940185547
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '414825' AND a.name = n.originalname
584 0.0002 0.0001988410949707
SELECT * FROM productoffers WHERE product_id = '414825' AND merchantid = 'ATVPDKIKX0DER'
585 0.0002 0.00022506713867188
SELECT * FROM productoffers
                WHERE product_id = '414825' AND price > 0
                ORDER BY price ASC LIMIT 1
586 0.0004 0.00038504600524902
SELECT value FROM productattributes WHERE product_id = '414825' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
587 0.0001 0.00013089179992676
UPDATE products SET price = '11999' WHERE id = '414825'
588 0.0002 0.00020003318786621
SELECT * FROM productimages WHERE product_id = '405644' ORDER BY sortorder ASC
589 0.0002 0.00022292137145996
SELECT * FROM product_image_select WHERE product_id = '405644'
590 0.0001 0.0001370906829834
SELECT * FROM productcustomimages WHERE product_id = '405644'
591 0.0034 0.0033750534057617
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '405644' AND a.name = n.originalname
592 0.0002 0.00019192695617676
SELECT * FROM productoffers WHERE product_id = '405644' AND merchantid = 'ATVPDKIKX0DER'
593 0.0002 0.00021982192993164
SELECT * FROM productoffers
                WHERE product_id = '405644' AND price > 0
                ORDER BY price ASC LIMIT 1
594 0.0004 0.0004420280456543
SELECT value FROM productattributes WHERE product_id = '405644' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
595 0.0001 0.00013113021850586
UPDATE products SET price = '63539' WHERE id = '405644'
596 0.0427 0.042656898498535
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
597 0.0002 0.00022792816162109
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:1560876662;s:8:\"products\";a:6:{i:1;s:6:\"398315\";i:2;s:6:\"398858\";i:7;s:6:\"404554\";i:8;s:6:\"412927\";i:12;s:6:\"103845\";i:17;s:6:\"406758\";}}' WHERE id = '177'
598 0.0005 0.00047397613525391
SELECT * FROM products WHERE id IN (398315,398858,404554,412927,103845,406758) ORDER BY FIELD(id, 398315,398858,404554,412927,103845,406758 )
599 0.0002 0.00023293495178223
SELECT * FROM productimages WHERE product_id = '398315' ORDER BY sortorder ASC
600 0.0002 0.00022697448730469
SELECT * FROM product_image_select WHERE product_id = '398315'
601 0.0001 0.0001380443572998
SELECT * FROM productcustomimages WHERE product_id = '398315'
602 0.0025 0.0025260448455811
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '398315' AND a.name = n.originalname
603 0.0002 0.0001990795135498
SELECT * FROM productoffers WHERE product_id = '398315' AND merchantid = 'ATVPDKIKX0DER'
604 0.0002 0.00021505355834961
SELECT * FROM productoffers
                WHERE product_id = '398315' AND price > 0
                ORDER BY price ASC LIMIT 1
605 0.0004 0.00040292739868164
SELECT value FROM productattributes WHERE product_id = '398315' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
606 0.0002 0.0001530647277832
UPDATE products SET price = '1999' WHERE id = '398315'
607 0.0002 0.00020503997802734
SELECT * FROM productimages WHERE product_id = '398858' ORDER BY sortorder ASC
608 0.0002 0.00023698806762695
SELECT * FROM product_image_select WHERE product_id = '398858'
609 0.0002 0.00021791458129883
SELECT * FROM productcustomimages WHERE product_id = '398858'
610 0.0031 0.0031030178070068
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '398858' AND a.name = n.originalname
611 0.0002 0.00019407272338867
SELECT * FROM productoffers WHERE product_id = '398858' AND merchantid = 'ATVPDKIKX0DER'
612 0.0002 0.00021696090698242
SELECT * FROM productoffers
                WHERE product_id = '398858' AND price > 0
                ORDER BY price ASC LIMIT 1
613 0.0004 0.00044512748718262
SELECT value FROM productattributes WHERE product_id = '398858' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
614 0.0001 0.00012993812561035
UPDATE products SET price = '2999' WHERE id = '398858'
615 0.0003 0.00028610229492188
SELECT * FROM productimages WHERE product_id = '404554' ORDER BY sortorder ASC
616 0.0002 0.00023984909057617
SELECT * FROM product_image_select WHERE product_id = '404554'
617 0.0001 0.00013494491577148
SELECT * FROM productcustomimages WHERE product_id = '404554'
618 0.0034 0.0034060478210449
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '404554' AND a.name = n.originalname
619 0.0002 0.00020694732666016
SELECT * FROM productoffers WHERE product_id = '404554' AND merchantid = 'ATVPDKIKX0DER'
620 0.0002 0.00022101402282715
SELECT * FROM productoffers
                WHERE product_id = '404554' AND price > 0
                ORDER BY price ASC LIMIT 1
621 0.0005 0.00045990943908691
SELECT value FROM productattributes WHERE product_id = '404554' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
622 0.0001 0.00013089179992676
UPDATE products SET price = '399999' WHERE id = '404554'
623 0.0003 0.00029683113098145
SELECT * FROM productimages WHERE product_id = '412927' ORDER BY sortorder ASC
624 0.0002 0.00022292137145996
SELECT * FROM product_image_select WHERE product_id = '412927'
625 0.0001 0.00013399124145508
SELECT * FROM productcustomimages WHERE product_id = '412927'
626 0.0037 0.0037088394165039
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '412927' AND a.name = n.originalname
627 0.0002 0.00019288063049316
SELECT * FROM productoffers WHERE product_id = '412927' AND merchantid = 'ATVPDKIKX0DER'
628 0.0002 0.0002131462097168
SELECT * FROM productoffers
                WHERE product_id = '412927' AND price > 0
                ORDER BY price ASC LIMIT 1
629 0.0005 0.00047016143798828
SELECT value FROM productattributes WHERE product_id = '412927' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
630 0.0001 0.00013303756713867
UPDATE products SET price = '199900' WHERE id = '412927'
631 0.0002 0.0002138614654541
SELECT * FROM productimages WHERE product_id = '103845' ORDER BY sortorder ASC
632 0.0002 0.00023698806762695
SELECT * FROM product_image_select WHERE product_id = '103845'
633 0.0001 0.00013518333435059
SELECT * FROM productcustomimages WHERE product_id = '103845'
634 0.0024 0.0024111270904541
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '103845' AND a.name = n.originalname
635 0.0002 0.00019407272338867
SELECT * FROM productoffers WHERE product_id = '103845' AND merchantid = 'ATVPDKIKX0DER'
636 0.0002 0.00022101402282715
SELECT * FROM productoffers
                WHERE product_id = '103845' AND price > 0
                ORDER BY price ASC LIMIT 1
637 0.0004 0.00038695335388184
SELECT value FROM productattributes WHERE product_id = '103845' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
638 0.0001 0.00013017654418945
UPDATE products SET price = '14499' WHERE id = '103845'
639 0.0002 0.00020289421081543
SELECT * FROM productimages WHERE product_id = '406758' ORDER BY sortorder ASC
640 0.0002 0.00022506713867188
SELECT * FROM product_image_select WHERE product_id = '406758'
641 0.0001 0.00013303756713867
SELECT * FROM productcustomimages WHERE product_id = '406758'
642 0.0026 0.0026230812072754
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '406758' AND a.name = n.originalname
643 0.0002 0.00019407272338867
SELECT * FROM productoffers WHERE product_id = '406758' AND merchantid = 'ATVPDKIKX0DER'
644 0.0002 0.00021600723266602
SELECT * FROM productoffers
                WHERE product_id = '406758' AND price > 0
                ORDER BY price ASC LIMIT 1
645 0.0004 0.0003969669342041
SELECT value FROM productattributes WHERE product_id = '406758' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
646 0.0001 0.00014495849609375
UPDATE products SET price = '2694' WHERE id = '406758'
647 0.1050 0.10496711730957
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
648 0.0003 0.00025796890258789
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:1560876663;s:8:\"products\";a:6:{i:0;s:6:\"414940\";i:1;s:6:\"398315\";i:4;s:6:\"290575\";i:12;s:6:\"103845\";i:13;s:6:\"370121\";i:18;s:6:\"130885\";}}' WHERE id = '181'
649 0.0005 0.00047516822814941
SELECT * FROM products WHERE id IN (414940,398315,290575,103845,370121,130885) ORDER BY FIELD(id, 414940,398315,290575,103845,370121,130885 )
650 0.0002 0.00021195411682129
SELECT * FROM productimages WHERE product_id = '414940' ORDER BY sortorder ASC
651 0.0002 0.00023484230041504
SELECT * FROM product_image_select WHERE product_id = '414940'
652 0.0001 0.0001378059387207
SELECT * FROM productcustomimages WHERE product_id = '414940'
653 0.0033 0.0032598972320557
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '414940' AND a.name = n.originalname
654 0.0002 0.0001990795135498
SELECT * FROM productoffers WHERE product_id = '414940' AND merchantid = 'ATVPDKIKX0DER'
655 0.0002 0.00023102760314941
SELECT * FROM productoffers
                WHERE product_id = '414940' AND price > 0
                ORDER BY price ASC LIMIT 1
656 0.0005 0.00045084953308105
SELECT value FROM productattributes WHERE product_id = '414940' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
657 0.0001 0.00013494491577148
UPDATE products SET price = '4490' WHERE id = '414940'
658 0.0002 0.00021696090698242
SELECT * FROM productimages WHERE product_id = '398315' ORDER BY sortorder ASC
659 0.0002 0.00022983551025391
SELECT * FROM product_image_select WHERE product_id = '398315'
660 0.0001 0.00013613700866699
SELECT * FROM productcustomimages WHERE product_id = '398315'
661 0.0025 0.0025181770324707
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '398315' AND a.name = n.originalname
662 0.0002 0.00019288063049316
SELECT * FROM productoffers WHERE product_id = '398315' AND merchantid = 'ATVPDKIKX0DER'
663 0.0002 0.00021505355834961
SELECT * FROM productoffers
                WHERE product_id = '398315' AND price > 0
                ORDER BY price ASC LIMIT 1
664 0.0004 0.00040698051452637
SELECT value FROM productattributes WHERE product_id = '398315' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
665 0.0001 0.00013089179992676
UPDATE products SET price = '1999' WHERE id = '398315'
666 0.0006 0.00060200691223145
SELECT * FROM productimages WHERE product_id = '290575' ORDER BY sortorder ASC
667 0.0002 0.00023698806762695
SELECT * FROM product_image_select WHERE product_id = '290575'
668 0.0001 0.00013613700866699
SELECT * FROM productcustomimages WHERE product_id = '290575'
669 0.0034 0.0034129619598389
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '290575' AND a.name = n.originalname
670 0.0002 0.00019311904907227
SELECT * FROM productoffers WHERE product_id = '290575' AND merchantid = 'ATVPDKIKX0DER'
671 0.0002 0.0002129077911377
SELECT * FROM productoffers
                WHERE product_id = '290575' AND price > 0
                ORDER BY price ASC LIMIT 1
672 0.0005 0.00045490264892578
SELECT value FROM productattributes WHERE product_id = '290575' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
673 0.0001 0.00013089179992676
UPDATE products SET price = '549500' WHERE id = '290575'
674 0.0002 0.00021505355834961
SELECT * FROM productimages WHERE product_id = '103845' ORDER BY sortorder ASC
675 0.0002 0.00022792816162109
SELECT * FROM product_image_select WHERE product_id = '103845'
676 0.0001 0.00013303756713867
SELECT * FROM productcustomimages WHERE product_id = '103845'
677 0.0024 0.0024199485778809
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '103845' AND a.name = n.originalname
678 0.0002 0.00019478797912598
SELECT * FROM productoffers WHERE product_id = '103845' AND merchantid = 'ATVPDKIKX0DER'
679 0.0002 0.0002129077911377
SELECT * FROM productoffers
                WHERE product_id = '103845' AND price > 0
                ORDER BY price ASC LIMIT 1
680 0.0004 0.0003960132598877
SELECT value FROM productattributes WHERE product_id = '103845' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
681 0.0001 0.00012993812561035
UPDATE products SET price = '14499' WHERE id = '103845'
682 0.0002 0.00020194053649902
SELECT * FROM productimages WHERE product_id = '370121' ORDER BY sortorder ASC
683 0.0002 0.00022220611572266
SELECT * FROM product_image_select WHERE product_id = '370121'
684 0.0001 0.00014591217041016
SELECT * FROM productcustomimages WHERE product_id = '370121'
685 0.0028 0.0027520656585693
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '370121' AND a.name = n.originalname
686 0.0002 0.00020980834960938
SELECT * FROM productoffers WHERE product_id = '370121' AND merchantid = 'ATVPDKIKX0DER'
687 0.0002 0.00021910667419434
SELECT * FROM productoffers
                WHERE product_id = '370121' AND price > 0
                ORDER BY price ASC LIMIT 1
688 0.0004 0.00040292739868164
SELECT value FROM productattributes WHERE product_id = '370121' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
689 0.0001 0.00013089179992676
UPDATE products SET price = '9899' WHERE id = '370121'
690 0.0002 0.00021004676818848
SELECT * FROM productimages WHERE product_id = '130885' ORDER BY sortorder ASC
691 0.0002 0.00022697448730469
SELECT * FROM product_image_select WHERE product_id = '130885'
692 0.0001 0.00013399124145508
SELECT * FROM productcustomimages WHERE product_id = '130885'
693 0.0020 0.0020229816436768
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '130885' AND a.name = n.originalname
694 0.0002 0.00019216537475586
SELECT * FROM productoffers WHERE product_id = '130885' AND merchantid = 'ATVPDKIKX0DER'
695 0.0002 0.00022697448730469
SELECT * FROM productoffers
                WHERE product_id = '130885' AND price > 0
                ORDER BY price ASC LIMIT 1
696 0.0004 0.00036907196044922
SELECT value FROM productattributes WHERE product_id = '130885' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
697 0.0001 0.00013089179992676
UPDATE products SET price = '1521' WHERE id = '130885'
698 0.1064 0.10639190673828
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
699 0.0002 0.00024294853210449
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:1560876663;s:8:\"products\";a:6:{i:0;s:6:\"414940\";i:1;s:6:\"398315\";i:2;s:6:\"398858\";i:5;s:6:\"171938\";i:7;s:6:\"404554\";i:8;s:6:\"412927\";}}' WHERE id = '183'
700 0.0005 0.00046896934509277
SELECT * FROM products WHERE id IN (414940,398315,398858,171938,404554,412927) ORDER BY FIELD(id, 414940,398315,398858,171938,404554,412927 )
701 0.0002 0.00021195411682129
SELECT * FROM productimages WHERE product_id = '414940' ORDER BY sortorder ASC
702 0.0002 0.00023603439331055
SELECT * FROM product_image_select WHERE product_id = '414940'
703 0.0001 0.0001380443572998
SELECT * FROM productcustomimages WHERE product_id = '414940'
704 0.0033 0.0032930374145508
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '414940' AND a.name = n.originalname
705 0.0002 0.00020098686218262
SELECT * FROM productoffers WHERE product_id = '414940' AND merchantid = 'ATVPDKIKX0DER'
706 0.0002 0.0002291202545166
SELECT * FROM productoffers
                WHERE product_id = '414940' AND price > 0
                ORDER BY price ASC LIMIT 1
707 0.0005 0.00045394897460938
SELECT value FROM productattributes WHERE product_id = '414940' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
708 0.0001 0.00013399124145508
UPDATE products SET price = '4490' WHERE id = '414940'
709 0.0002 0.00021791458129883
SELECT * FROM productimages WHERE product_id = '398315' ORDER BY sortorder ASC
710 0.0002 0.00023007392883301
SELECT * FROM product_image_select WHERE product_id = '398315'
711 0.0001 0.00013303756713867
SELECT * FROM productcustomimages WHERE product_id = '398315'
712 0.0025 0.0025191307067871
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '398315' AND a.name = n.originalname
713 0.0002 0.00019383430480957
SELECT * FROM productoffers WHERE product_id = '398315' AND merchantid = 'ATVPDKIKX0DER'
714 0.0002 0.0002129077911377
SELECT * FROM productoffers
                WHERE product_id = '398315' AND price > 0
                ORDER BY price ASC LIMIT 1
715 0.0004 0.00040817260742188
SELECT value FROM productattributes WHERE product_id = '398315' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
716 0.0001 0.00013399124145508
UPDATE products SET price = '1999' WHERE id = '398315'
717 0.0002 0.00020503997802734
SELECT * FROM productimages WHERE product_id = '398858' ORDER BY sortorder ASC
718 0.0002 0.00022602081298828
SELECT * FROM product_image_select WHERE product_id = '398858'
719 0.0001 0.00014591217041016
SELECT * FROM productcustomimages WHERE product_id = '398858'
720 0.0030 0.0030479431152344
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '398858' AND a.name = n.originalname
721 0.0002 0.00019717216491699
SELECT * FROM productoffers WHERE product_id = '398858' AND merchantid = 'ATVPDKIKX0DER'
722 0.0002 0.00022387504577637
SELECT * FROM productoffers
                WHERE product_id = '398858' AND price > 0
                ORDER BY price ASC LIMIT 1
723 0.0004 0.00043702125549316
SELECT value FROM productattributes WHERE product_id = '398858' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
724 0.0001 0.00012993812561035
UPDATE products SET price = '2999' WHERE id = '398858'
725 0.0006 0.00063204765319824
SELECT * FROM productimages WHERE product_id = '171938' ORDER BY sortorder ASC
726 0.0002 0.00024104118347168
SELECT * FROM product_image_select WHERE product_id = '171938'
727 0.0001 0.00013494491577148
SELECT * FROM productcustomimages WHERE product_id = '171938'
728 0.0026 0.0025660991668701
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '171938' AND a.name = n.originalname
729 0.0002 0.0001978874206543
SELECT * FROM productoffers WHERE product_id = '171938' AND merchantid = 'ATVPDKIKX0DER'
730 0.0002 0.00022387504577637
SELECT * FROM productoffers
                WHERE product_id = '171938' AND price > 0
                ORDER BY price ASC LIMIT 1
731 0.0004 0.00040793418884277
SELECT value FROM productattributes WHERE product_id = '171938' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
732 0.0001 0.00013399124145508
UPDATE products SET price = '389500' WHERE id = '171938'
733 0.0003 0.00028514862060547
SELECT * FROM productimages WHERE product_id = '404554' ORDER BY sortorder ASC
734 0.0002 0.00022506713867188
SELECT * FROM product_image_select WHERE product_id = '404554'
735 0.0001 0.00014185905456543
SELECT * FROM productcustomimages WHERE product_id = '404554'
736 0.0034 0.0034120082855225
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '404554' AND a.name = n.originalname
737 0.0002 0.00019407272338867
SELECT * FROM productoffers WHERE product_id = '404554' AND merchantid = 'ATVPDKIKX0DER'
738 0.0002 0.00021815299987793
SELECT * FROM productoffers
                WHERE product_id = '404554' AND price > 0
                ORDER BY price ASC LIMIT 1
739 0.0005 0.00046086311340332
SELECT value FROM productattributes WHERE product_id = '404554' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
740 0.0001 0.00012993812561035
UPDATE products SET price = '399999' WHERE id = '404554'
741 0.0003 0.00027298927307129
SELECT * FROM productimages WHERE product_id = '412927' ORDER BY sortorder ASC
742 0.0002 0.00022983551025391
SELECT * FROM product_image_select WHERE product_id = '412927'
743 0.0001 0.00013399124145508
SELECT * FROM productcustomimages WHERE product_id = '412927'
744 0.0036 0.0036301612854004
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '412927' AND a.name = n.originalname
745 0.0002 0.00019288063049316
SELECT * FROM productoffers WHERE product_id = '412927' AND merchantid = 'ATVPDKIKX0DER'
746 0.0002 0.00021195411682129
SELECT * FROM productoffers
                WHERE product_id = '412927' AND price > 0
                ORDER BY price ASC LIMIT 1
747 0.0005 0.00047111511230469
SELECT value FROM productattributes WHERE product_id = '412927' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
748 0.0001 0.00013399124145508
UPDATE products SET price = '199900' WHERE id = '412927'
749 0.0004 0.00042104721069336
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid' AND area = 'header' ORDER BY sortorder ASC
750 0.0002 0.00015807151794434
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
751 0.0001 0.0001378059387207
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
752 0.0001 0.00013399124145508
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
753 0.0001 0.00013303756713867
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
754 0.0004 0.00042510032653809
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid' AND area = 'footer' ORDER BY sortorder ASC
755 0.0001 0.00013899803161621
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
756 0.0001 0.0001370906829834
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
757 0.0001 0.00013208389282227
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
758 0.0009 0.0009150505065918
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-fluid' AND skinuid = ''
759 0.0003 0.0003359317779541
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid'
760 0.0003 0.00030994415283203
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid'
761 0.0004 0.00044608116149902
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid' AND imageuid = 'HEAD_CUSTOM_BANNER'
762 0.0003 0.00033998489379883
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid' AND imageuid = 'HEAD_CUSTOM_BANNER'