Tactical Equipment - Survivalist Equipment

HIVIZ AR 15 Interchangeable Fiber Optic Sight by HIVIZ

Price: $19.22 $19.20
Product prices and availability are accurate as of 2019-06-18 22:36:43 UTC and are subject to change. Any price and availability information displayed on http://www.amazon.com/ at the time of purchase will apply to the purchase of this product.
You Save: $0.02 (0%)
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

Tactical Survivalist : Combat Gear : Survival Gear : Combat Equipment is happy to stock the valuable HIVIZ AR 15 Interchangeable Fiber Optic Sight today at this limited price.

With so many competing tactical, combat and survival products on offer today, it is great to have a brand that you can trust. The HIVIZ AR 15 Interchangeable Fiber Optic Sight is certainly all that and will be a sound buy for your combat gear or tactical training.

We pride ourselves on providing the finest quality combat gear for all your individual requirements.

For this reduced price, the HIVIZ AR 15 Interchangeable Fiber Optic Sight comes highly recommended and is a regular choice for many like minded people. HIVIZ have provided some great touches and this equals great value.

Manufacturer Description

Hi-Viz AR15 Front Sight fits the popular rifle in the U.S., is the AR and MP4 platform rifle. This sight helps make this renowned rifle more precise with an extremely brilliant Hi-Viz sight. LitePipes are made of a chemical resistant material and injection formed to accomplish optimum brightness and a consistent sight image. Set consists of four interchangeable LitePipes of numerous colors.

Product Features

Hi-Viz AR15 and MP4 front sight Fits rifles with A-frame or folding front sights Make your rifle shoot better Tested for durability Provides maximum brightness AR15 Interchangeable Sight Includes 4 LitePipes 2 red 2 green Sight adjustment tool tapered detent and carrying case for spare LitePipes Fits AR and M4 type rifles with A Frame or folding front sight HiViz recommends gunsmith installation for all dovetail sights. Due to manufacturing tolerances, some firearms may require additional fitting.

Write a Review

Debug Overview

App Total Time DB Queries DB Query Total Time Amazon Requests
2.4846529960632 753 1.3149 0


No Amazon API Requests Made.


App Debug - Total Time 2.4846529960632 seconds

Number Time From Start Name Description
1 0.45289993286133 Initialise Initialise FSB Function
2 0.4599928855896 App Controller Start Start of the App controller (called before the controller of every page)
3 0.47131299972534 Start of getCategoryListByGroup Function Before first category groups query
4 0.47148180007935 After initial query Before first category groups query
5 0.47148299217224 Get Category List for Group Before the call to getCategoryList function
6 0.47148680686951 Start of GetCategoryList function Start of the function
7 0.47149181365967 Before getting categories Query to get specific category list
8 0.47208094596863 After getting categories Query to get specific category list
9 0.47208285331726 Before getting category custom Before call to function getCategoryCustom
10 0.47396087646484 After getting category custom After call to function getCategoryCustom
11 0.47396397590637 Before getting category custom Before call to function getCategoryCustom
12 0.48496699333191 After getting category custom After call to function getCategoryCustom
13 0.48496985435486 Before getting category custom Before call to function getCategoryCustom
14 0.49078893661499 After getting category custom After call to function getCategoryCustom
15 0.49079179763794 Before getting category custom Before call to function getCategoryCustom
16 0.49505281448364 After getting category custom After call to function getCategoryCustom
17 0.49505591392517 End of GetCategoryList function End of the function
18 0.49506592750549 Get Category List for Group Before the call to getCategoryList function
19 0.49506902694702 Start of GetCategoryList function Start of the function
20 0.49507188796997 Before getting categories Query to get specific category list
21 0.49551892280579 After getting categories Query to get specific category list
22 0.49552083015442 Before getting category custom Before call to function getCategoryCustom
23 0.50127291679382 After getting category custom After call to function getCategoryCustom
24 0.50127482414246 Before getting category custom Before call to function getCategoryCustom
25 0.51230883598328 After getting category custom After call to function getCategoryCustom
26 0.51231098175049 End of GetCategoryList function End of the function
27 0.51231789588928 Get Category List for Group Before the call to getCategoryList function
28 0.51232099533081 Start of GetCategoryList function Start of the function
29 0.51232385635376 Before getting categories Query to get specific category list
30 0.51305890083313 After getting categories Query to get specific category list
31 0.51305985450745 Before getting category custom Before call to function getCategoryCustom
32 0.52250981330872 After getting category custom After call to function getCategoryCustom
33 0.52251195907593 Before getting category custom Before call to function getCategoryCustom
34 0.54038786888123 After getting category custom After call to function getCategoryCustom
35 0.54039001464844 Before getting category custom Before call to function getCategoryCustom
36 0.54645895957947 After getting category custom After call to function getCategoryCustom
37 0.5464608669281 Before getting category custom Before call to function getCategoryCustom
38 0.55248880386353 After getting category custom After call to function getCategoryCustom
39 0.55249190330505 Before getting category custom Before call to function getCategoryCustom
40 0.55886888504028 After getting category custom After call to function getCategoryCustom
41 0.5588710308075 Before getting category custom Before call to function getCategoryCustom
42 0.58127188682556 After getting category custom After call to function getCategoryCustom
43 0.58127498626709 Before getting category custom Before call to function getCategoryCustom
44 0.58543300628662 After getting category custom After call to function getCategoryCustom
45 0.58543586730957 Before getting category custom Before call to function getCategoryCustom
46 0.59009790420532 After getting category custom After call to function getCategoryCustom
47 0.59009981155396 End of GetCategoryList function End of the function
48 0.59011292457581 Get Category List for Group Before the call to getCategoryList function
49 0.59011602401733 Start of GetCategoryList function Start of the function
50 0.59011888504028 Before getting categories Query to get specific category list
51 0.59053683280945 After getting categories Query to get specific category list
52 0.59053802490234 Before getting category custom Before call to function getCategoryCustom
53 0.59284591674805 After getting category custom After call to function getCategoryCustom
54 0.59284782409668 Before getting category custom Before call to function getCategoryCustom
55 0.5951828956604 After getting category custom After call to function getCategoryCustom
56 0.59518480300903 End of GetCategoryList function End of the function
57 0.59519100189209 Get Category List for Group Before the call to getCategoryList function
58 0.59519290924072 Start of GetCategoryList function Start of the function
59 0.59519481658936 Before getting categories Query to get specific category list
60 0.5955069065094 After getting categories Query to get specific category list
61 0.59550786018372 Before getting category custom Before call to function getCategoryCustom
62 0.60059785842896 After getting category custom After call to function getCategoryCustom
63 0.60060000419617 End of GetCategoryList function End of the function
64 0.60060691833496 End of getCategoryListByGroup Function Before return()
65 0.65087294578552 App Controller End End of the App controller (called before the controller of every page)
66 0.65148997306824 Product Start Start of the product info controller
67 0.65236496925354 Cache file not found Starting get product details
68 0.70293283462524 Related products Start getting related products if enabled
69 0.70293498039246 Related Products Start Before the related products are found
70 0.70293593406677 Related Products Keywords Before the related product keywords are found
71 0.70294785499573 Create Keyword List Function Start of function
72 0.70388603210449 Create Keyword List Function After looping provided content - 566 keywords found
73 0.74181485176086 Create Keyword List Function After looping initial keyword list - 521 keywords remaining
74 0.74195194244385 Create Keyword List Function After reducing keyword list
75 0.74324703216553 Create Keyword List Function After selecting by scoring keywords
76 0.74325394630432 Create Keyword List Function After final loop of keywords
77 0.74325585365295 Related Products Keywords After the related product keywords are found
78 1.0078868865967 Related Products End After the related products are found
79 1.1997139453888 Start Remote Request http://svcs.ebay.com/services/search/FindingServic...
80 1.3197059631348 End Remote Request http://svcs.ebay.com/services/search/FindingServic...
81 1.5344948768616 Product End End of the product info controller (Product Info)
82 1.5348589420319 App_after Controller Start Start of the App_after controller (called after the controller of every page)
83 1.5349409580231 Before Get Options Before the call to getOptions in the tpl class
84 1.9579219818115 After Get Options After the call to getOptions in the tpl class
85 1.9581909179688 App_after Controller End End of the App_after controller (called after the controller of every page)
86 1.9582049846649 Product Info: Before Smarty Fetch Before the product.tpl template is fetched
87 2.2662739753723 Product Info: After Smarty Fetch After the product.tpl template is fetched
88 2.2662827968597 Product Info: Before Template Display Before the template is displayed
89 2.4846279621124 Product Info: After Template Display After the template is displayed
90 2.4846339225769 Finalizing debug Before the debug is output to the page.
91 2.484650850296 End of App This is the end of the app logging, final timestamp


Query Debug - 753 Database Queries. Total time 1.3149 seconds

Number Time (Seconds) Time (Milliseconds) Query
1 0.0002 0.00016283988952637
SELECT value FROM parameters WHERE `parameter` = 'BAD_BOTS_ENABLER'
2 0.0004 0.00044512748718262
SHOW TABLES LIKE 'bad_bots'
3 0.0002 0.00015091896057129
SELECT value FROM parameters WHERE `parameter` = 'STORE_WHITELISTED_IPS'
4 0.0001 0.00014305114746094
SELECT * FROM `bad_bots`
5 0.0005 0.00045204162597656
SELECT parameter, value FROM parameters
6 0.0002 0.00016403198242188
SET time_zone = 'Europe/London'
7 0.0004 0.00035810470581055
SELECT * FROM autorun ORDER BY lastrun ASC
8 0.0001 0.00014996528625488
SELECT * FROM version ORDER BY installed DESC LIMIT 1
9 0.0001 0.0001070499420166
delete from cachefiles
10 0.0002 0.00024509429931641
SELECT id FROM pages WHERE pagename = 'hiviz-ar-15-interchangeable-fiber-optic-sight' LIMIT 1
11 0.0002 0.00022983551025391
SELECT id FROM products WHERE pagename = 'hiviz-ar-15-interchangeable-fiber-optic-sight' AND hidden = 0 LIMIT 1
12 0.0008 0.00080013275146484
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-fluid'
13 0.0095 0.0094959735870361
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-fluid' AND language = 'en'
14 0.0003 0.00025701522827148
SELECT * FROM pages WHERE pagename = 'hiviz-ar-15-interchangeable-fiber-optic-sight'
15 0.0002 0.0001530647277832
SELECT * FROM categorygroups ORDER BY sortorder ASC
16 0.0006 0.0005500316619873
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
17 0.0005 0.00049614906311035
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.00022697448730469
SELECT id FROM categories WHERE parent_id = '49'
19 0.0005 0.00046396255493164
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.0001 0.00014686584472656
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (49)
				  AND p.disabled = 0 
21 0.0001 0.00014996528625488
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.00017285346984863
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '49'
23 0.0001 0.00012493133544922
SELECT * FROM categorygroups WHERE id = '1'
24 0.0031 0.003140926361084
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.00026583671569824
SELECT id FROM categories WHERE parent_id = '50'
26 0.0002 0.00020599365234375
SELECT id FROM categories WHERE parent_id = '96'
27 0.0002 0.0001990795135498
SELECT id FROM categories WHERE parent_id = '97'
28 0.0002 0.00020003318786621
SELECT id FROM categories WHERE parent_id = '111'
29 0.0002 0.00020480155944824
SELECT id FROM categories WHERE parent_id = '129'
30 0.0060 0.0059859752655029
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.00019001960754395
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.00015878677368164
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.00017595291137695
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '50'
34 0.0001 0.00012493133544922
SELECT * FROM categorygroups WHERE id = '1'
35 0.0024 0.0024271011352539
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.00026798248291016
SELECT id FROM categories WHERE parent_id = '80'
37 0.0024 0.0024309158325195
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.00016403198242188
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.0001 0.00014591217041016
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.00015997886657715
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '80'
41 0.0001 0.00012516975402832
SELECT * FROM categorygroups WHERE id = '1'
42 0.0012 0.0012171268463135
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.00027084350585938
SELECT id FROM categories WHERE parent_id = '51'
44 0.0002 0.00020599365234375
SELECT id FROM categories WHERE parent_id = '101'
45 0.0019 0.0018620491027832
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (101,51)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
46 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 (101,51)
				  AND p.disabled = 0 
47 0.0001 0.00014901161193848
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (101,51)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
48 0.0002 0.0001678466796875
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '51'
49 0.0001 0.00012493133544922
SELECT * FROM categorygroups WHERE id = '1'
50 0.0004 0.00042319297790527
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '2'  AND hidden = 0 ORDER BY sortorder ASC
51 0.0024 0.002418041229248
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.00025105476379395
SELECT id FROM categories WHERE parent_id = '30'
53 0.0024 0.0023751258850098
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.00015091896057129
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.0001 0.00014710426330566
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.0001680850982666
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
57 0.0001 0.00013518333435059
SELECT * FROM categorygroups WHERE id = '2'
58 0.0050 0.0050170421600342
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.00026917457580566
SELECT id FROM categories WHERE parent_id = '61'
60 0.0050 0.0050492286682129
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.00015902519226074
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.0001 0.00014805793762207
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (61)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
63 0.0002 0.00016593933105469
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '61'
64 0.0001 0.00013589859008789
SELECT * FROM categorygroups WHERE id = '2'
65 0.0007 0.00067305564880371
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '10'  AND hidden = 0 ORDER BY sortorder ASC
66 0.0042 0.0041968822479248
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.00026392936706543
SELECT id FROM categories WHERE parent_id = '64'
68 0.0043 0.0042741298675537
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.00016593933105469
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.0001 0.00014805793762207
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (64)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
71 0.0002 0.00018000602722168
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '64'
72 0.0001 0.00012588500976562
SELECT * FROM categorygroups WHERE id = '10'
73 0.0084 0.0083999633789062
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.00028204917907715
SELECT id FROM categories WHERE parent_id = '65'
75 0.0085 0.0084669589996338
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.00016593933105469
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.00015020370483398
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.00018000602722168
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '65'
79 0.0001 0.00012803077697754
SELECT * FROM categorygroups WHERE id = '10'
80 0.0025 0.0025439262390137
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.0002739429473877
SELECT id FROM categories WHERE parent_id = '81'
82 0.0026 0.0025701522827148
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.00015091896057129
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.0001 0.00014710426330566
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.00016903877258301
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '81'
86 0.0001 0.00012516975402832
SELECT * FROM categorygroups WHERE id = '10'
87 0.0025 0.0025169849395752
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.00027203559875488
SELECT id FROM categories WHERE parent_id = '31'
89 0.0026 0.0025510787963867
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.00015091896057129
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.0001 0.00014400482177734
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.00017595291137695
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
93 0.0001 0.00012683868408203
SELECT * FROM categorygroups WHERE id = '10'
94 0.0023 0.0023109912872314
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 66
95 0.0003 0.00025701522827148
SELECT id FROM categories WHERE parent_id = '66'
96 0.0002 0.00021481513977051
SELECT id FROM categories WHERE parent_id = '131'
97 0.0029 0.0028910636901855
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.00015783309936523
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.0001 0.00014805793762207
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (131,66)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
100 0.0002 0.00015902519226074
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '66'
101 0.0001 0.00012397766113281
SELECT * FROM categorygroups WHERE id = '10'
102 0.0098 0.0097770690917969
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.00028610229492188
SELECT id FROM categories WHERE parent_id = '34'
104 0.0002 0.00020480155944824
SELECT id FROM categories WHERE parent_id = '94'
105 0.0002 0.00021100044250488
SELECT id FROM categories WHERE parent_id = '98'
106 0.0002 0.00020098686218262
SELECT id FROM categories WHERE parent_id = '99'
107 0.0002 0.00019693374633789
SELECT id FROM categories WHERE parent_id = '110'
108 0.0002 0.00019693374633789
SELECT id FROM categories WHERE parent_id = '130'
109 0.0105 0.010540008544922
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.00017690658569336
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.00015521049499512
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.00017786026000977
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.0015921592712402
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.00026106834411621
SELECT id FROM categories WHERE parent_id = '32'
116 0.0016 0.0016279220581055
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.0001 0.00014591217041016
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.0001 0.00014400482177734
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.00017309188842773
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '32'
120 0.0001 0.00012493133544922
SELECT * FROM categorygroups WHERE id = '10'
121 0.0019 0.0018589496612549
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.00025200843811035
SELECT id FROM categories WHERE parent_id = '89'
123 0.0019 0.001878023147583
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.0001 0.00014901161193848
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.0001 0.00014495849609375
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (89)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
126 0.0002 0.0001678466796875
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '89'
127 0.0001 0.00012397766113281
SELECT * FROM categorygroups WHERE id = '10'
128 0.0004 0.00039386749267578
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.00023198127746582
SELECT id FROM categories WHERE parent_id = '84'
131 0.0007 0.00069999694824219
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.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 
133 0.0001 0.00014400482177734
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.00016403198242188
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '84'
135 0.0001 0.0001220703125
SELECT * FROM categorygroups WHERE id = '17'
136 0.0007 0.00071096420288086
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.00023412704467773
SELECT id FROM categories WHERE parent_id = '90'
138 0.0007 0.00074100494384766
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.00014185905456543
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (90)
				  AND p.disabled = 0 
140 0.0001 0.00014209747314453
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.00015401840209961
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '90'
142 0.0001 0.00012111663818359
SELECT * FROM categorygroups WHERE id = '17'
143 0.0003 0.00029802322387695
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '20'  AND hidden = 0 ORDER BY sortorder ASC
144 0.0021 0.0020718574523926
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.00024104118347168
SELECT id FROM categories WHERE parent_id = '92'
146 0.0021 0.0020809173583984
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.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 (92)
				  AND p.disabled = 0 
148 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 (92)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
149 0.0002 0.00015521049499512
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '92'
150 0.0001 0.00012803077697754
SELECT * FROM categorygroups WHERE id = '20'
151 0.0053 0.0052540302276611
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
152 0.0004 0.00037407875061035
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-fluid' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
153 0.0002 0.00019311904907227
SELECT value FROM parameters WHERE parameter = 'EBAY_APP_ID' 
154 0.0002 0.00015711784362793
SELECT * FROM sideboxes_pages WHERE sidebox_id = '1'
155 0.0002 0.00017809867858887
SELECT * FROM pages WHERE id = '67'
156 0.0002 0.00015783309936523
SELECT * FROM pages WHERE id = '82'
157 0.0002 0.00015902519226074
SELECT * FROM pages WHERE id = '84'
158 0.0001 0.00014209747314453
SELECT * FROM pages WHERE id = '94'
159 0.0002 0.00015687942504883
SELECT * FROM pages WHERE id = '116'
160 0.0002 0.00020813941955566
SELECT * FROM pages WHERE id = '52'
161 0.0002 0.0001671314239502
SELECT * FROM pages WHERE id = '135'
162 0.0002 0.0001528263092041
SELECT * FROM pages WHERE id = '245'
163 0.0002 0.00016093254089355
SELECT * FROM pages WHERE id = '269'
164 0.0002 0.00018596649169922
SELECT * FROM pages WHERE id = '275'
165 0.0002 0.00019717216491699
SELECT * FROM pages WHERE id = '280'
166 0.0002 0.0001978874206543
SELECT * FROM pages WHERE id = '357'
167 0.0001 0.00014519691467285
SELECT * FROM pages WHERE id = '379'
168 0.0001 0.00013899803161621
SELECT * FROM pages WHERE id = '401'
169 0.0002 0.0001518726348877
SELECT * FROM pages WHERE id = '450'
170 0.0001 0.00014805793762207
SELECT * FROM pages WHERE id = '454'
171 0.0002 0.0001530647277832
SELECT * FROM pages WHERE id = '457'
172 0.0001 0.00014996528625488
SELECT * FROM pages WHERE id = '458'
173 0.0002 0.0001528263092041
SELECT * FROM sideboxes_pages WHERE sidebox_id = '2'
174 0.0002 0.00016188621520996
SELECT * FROM pages WHERE id = '41'
175 0.0002 0.00016117095947266
SELECT * FROM pages WHERE id = '43'
176 0.0001 0.00014686584472656
SELECT * FROM pages WHERE id = '44'
177 0.0002 0.00015687942504883
SELECT * FROM pages WHERE id = '68'
178 0.0002 0.00020813941955566
SELECT * FROM pages WHERE id = '80'
179 0.0002 0.00015997886657715
SELECT * FROM pages WHERE id = '85'
180 0.0002 0.00015401840209961
SELECT * FROM pages WHERE id = '97'
181 0.0002 0.00015592575073242
SELECT * FROM pages WHERE id = '107'
182 0.0002 0.00015497207641602
SELECT * FROM pages WHERE id = '108'
183 0.0001 0.0001380443572998
SELECT * FROM pages WHERE id = '128'
184 0.0002 0.00017094612121582
SELECT * FROM pages WHERE id = '133'
185 0.0001 0.00014591217041016
SELECT * FROM pages WHERE id = '148'
186 0.0002 0.00015592575073242
SELECT * FROM pages WHERE id = '217'
187 0.0001 0.00013995170593262
SELECT * FROM pages WHERE id = '228'
188 0.0002 0.00015687942504883
SELECT * FROM pages WHERE id = '257'
189 0.0002 0.00015497207641602
SELECT * FROM pages WHERE id = '271'
190 0.0001 0.00014400482177734
SELECT * FROM pages WHERE id = '286'
191 0.0001 0.00014185905456543
SELECT * FROM pages WHERE id = '287'
192 0.0002 0.00015592575073242
SELECT * FROM pages WHERE id = '291'
193 0.0002 0.0001530647277832
SELECT * FROM pages WHERE id = '380'
194 0.0002 0.00016379356384277
SELECT * FROM pages WHERE id = '344'
195 0.0002 0.00016498565673828
SELECT * FROM pages WHERE id = '354'
196 0.0002 0.00018811225891113
SELECT * FROM pages WHERE id = '363'
197 0.0002 0.00019502639770508
SELECT * FROM pages WHERE id = '364'
198 0.0001 0.00014400482177734
SELECT * FROM pages WHERE id = '368'
199 0.0002 0.00018787384033203
SELECT * FROM pages WHERE id = '369'
200 0.0001 0.00014615058898926
SELECT * FROM pages WHERE id = '400'
201 0.0002 0.00015497207641602
SELECT * FROM pages WHERE id = '463'
202 0.0002 0.00016498565673828
SELECT * FROM sideboxes_pages WHERE sidebox_id = '33'
203 0.0002 0.0002439022064209
SELECT * FROM pages WHERE id = '66'
204 0.0002 0.00021004676818848
SELECT * FROM pages WHERE id = '77'
205 0.0002 0.00018906593322754
SELECT * FROM pages WHERE id = '90'
206 0.0001 0.00014400482177734
SELECT * FROM pages WHERE id = '414'
207 0.0001 0.00014686584472656
SELECT * FROM pages WHERE id = '119'
208 0.0001 0.00014901161193848
SELECT * FROM pages WHERE id = '406'
209 0.0001 0.00014805793762207
SELECT * FROM pages WHERE id = '149'
210 0.0002 0.00015687942504883
SELECT * FROM pages WHERE id = '150'
211 0.0001 0.00014185905456543
SELECT * FROM pages WHERE id = '412'
212 0.0002 0.00015401840209961
SELECT * FROM pages WHERE id = '162'
213 0.0001 0.00014185905456543
SELECT * FROM pages WHERE id = '164'
214 0.0001 0.00014281272888184
SELECT * FROM pages WHERE id = '167'
215 0.0001 0.00013589859008789
SELECT * FROM pages WHERE id = '180'
216 0.0001 0.00014805793762207
SELECT * FROM pages WHERE id = '187'
217 0.0002 0.00019192695617676
SELECT * FROM pages WHERE id = '265'
218 0.0002 0.0001518726348877
SELECT * FROM pages WHERE id = '268'
219 0.0001 0.00014090538024902
SELECT * FROM pages WHERE id = '411'
220 0.0002 0.0001518726348877
SELECT * FROM pages WHERE id = '290'
221 0.0002 0.00015115737915039
SELECT * FROM pages WHERE id = '413'
222 0.0001 0.00014305114746094
SELECT * FROM pages WHERE id = '409'
223 0.0001 0.00014901161193848
SELECT * FROM pages WHERE id = '327'
224 0.0001 0.00014686584472656
SELECT * FROM pages WHERE id = '336'
225 0.0002 0.00015401840209961
SELECT * FROM pages WHERE id = '351'
226 0.0001 0.00014495849609375
SELECT * FROM pages WHERE id = '358'
227 0.0002 0.00015592575073242
SELECT * FROM pages WHERE id = '360'
228 0.0002 0.0001528263092041
SELECT * FROM pages WHERE id = '362'
229 0.0002 0.00015497207641602
SELECT * FROM pages WHERE id = '366'
230 0.0002 0.00015902519226074
SELECT * FROM pages WHERE id = '370'
231 0.0001 0.00014686584472656
SELECT * FROM pages WHERE id = '377'
232 0.0001 0.00014710426330566
SELECT * FROM pages WHERE id = '386'
233 0.0001 0.00014996528625488
SELECT * FROM pages WHERE id = '408'
234 0.0001 0.00014209747314453
SELECT * FROM pages WHERE id = '415'
235 0.0002 0.00016093254089355
SELECT * FROM pages WHERE id = '416'
236 0.0002 0.00018811225891113
SELECT * FROM pages WHERE id = '419'
237 0.0002 0.00015401840209961
SELECT * FROM pages WHERE id = '423'
238 0.0002 0.0001530647277832
SELECT * FROM pages WHERE id = '427'
239 0.0002 0.00018596649169922
SELECT * FROM pages WHERE id = '428'
240 0.0001 0.00013899803161621
SELECT * FROM pages WHERE id = '432'
241 0.0001 0.00014305114746094
SELECT * FROM pages WHERE id = '433'
242 0.0001 0.00014901161193848
SELECT * FROM pages WHERE id = '436'
243 0.0001 0.00014805793762207
SELECT * FROM pages WHERE id = '437'
244 0.0001 0.00014400482177734
SELECT * FROM pages WHERE id = '461'
245 0.0002 0.00018000602722168
SELECT * FROM pages WHERE id = '464'
246 0.0001 0.00014591217041016
SELECT * FROM sideboxes_pages WHERE sidebox_id = '34'
247 0.0002 0.0001530647277832
SELECT * FROM pages WHERE id = '74'
248 0.0001 0.00014400482177734
SELECT * FROM pages WHERE id = '137'
249 0.0001 0.00014805793762207
SELECT * FROM pages WHERE id = '145'
250 0.0002 0.00015401840209961
SELECT * FROM pages WHERE id = '156'
251 0.0001 0.00014901161193848
SELECT * FROM pages WHERE id = '407'
252 0.0001 0.00014114379882812
SELECT * FROM pages WHERE id = '410'
253 0.0002 0.00017309188842773
SELECT * FROM pages WHERE id = '266'
254 0.0002 0.0002129077911377
SELECT * FROM pages WHERE id = '316'
255 0.0001 0.00014901161193848
SELECT * FROM pages WHERE id = '332'
256 0.0002 0.00019097328186035
SELECT * FROM pages WHERE id = '334'
257 0.0001 0.00014400482177734
SELECT * FROM pages WHERE id = '367'
258 0.0001 0.00014901161193848
SELECT * FROM pages WHERE id = '387'
259 0.0001 0.00014805793762207
SELECT * FROM pages WHERE id = '389'
260 0.0002 0.00015497207641602
SELECT * FROM pages WHERE id = '397'
261 0.0002 0.00016403198242188
SELECT * FROM pages WHERE id = '449'
262 0.0002 0.00016283988952637
SELECT * FROM sideboxes_pages WHERE sidebox_id = '35'
263 0.0002 0.0001990795135498
SELECT * FROM pages WHERE id = '42'
264 0.0001 0.00014805793762207
SELECT * FROM pages WHERE id = '79'
265 0.0002 0.00015902519226074
SELECT * FROM pages WHERE id = '86'
266 0.0001 0.00014209747314453
SELECT * FROM pages WHERE id = '95'
267 0.0002 0.00015997886657715
SELECT * FROM pages WHERE id = '102'
268 0.0001 0.00014209747314453
SELECT * FROM pages WHERE id = '109'
269 0.0002 0.00021910667419434
SELECT * FROM pages WHERE id = '114'
270 0.0002 0.00018811225891113
SELECT * FROM pages WHERE id = '121'
271 0.0002 0.00020503997802734
SELECT * FROM pages WHERE id = '138'
272 0.0002 0.00016093254089355
SELECT * FROM pages WHERE id = '142'
273 0.0002 0.00019598007202148
SELECT * FROM pages WHERE id = '62'
274 0.0001 0.00014495849609375
SELECT * FROM pages WHERE id = '157'
275 0.0002 0.00015592575073242
SELECT * FROM pages WHERE id = '246'
276 0.0002 0.00019192695617676
SELECT * FROM pages WHERE id = '276'
277 0.0002 0.00019502639770508
SELECT * FROM pages WHERE id = '278'
278 0.0002 0.00021505355834961
SELECT * FROM pages WHERE id = '279'
279 0.0002 0.00016093254089355
SELECT * FROM pages WHERE id = '317'
280 0.0001 0.00014805793762207
SELECT * FROM pages WHERE id = '405'
281 0.0002 0.00017213821411133
SELECT * FROM pages WHERE id = '343'
282 0.0002 0.00015997886657715
SELECT * FROM pages WHERE id = '345'
283 0.0002 0.00019288063049316
SELECT * FROM pages WHERE id = '346'
284 0.0002 0.00015807151794434
SELECT * FROM pages WHERE id = '347'
285 0.0002 0.00015902519226074
SELECT * FROM pages WHERE id = '348'
286 0.0001 0.00014901161193848
SELECT * FROM pages WHERE id = '349'
287 0.0001 0.00014686584472656
SELECT * FROM pages WHERE id = '381'
288 0.0001 0.00014901161193848
SELECT * FROM pages WHERE id = '392'
289 0.0001 0.00014495849609375
SELECT * FROM pages WHERE id = '393'
290 0.0001 0.00014209747314453
SELECT * FROM pages WHERE id = '394'
291 0.0001 0.00014305114746094
SELECT * FROM pages WHERE id = '395'
292 0.0002 0.0001528263092041
SELECT * FROM pages WHERE id = '399'
293 0.0002 0.0001530647277832
SELECT * FROM pages WHERE id = '421'
294 0.0001 0.00014090538024902
SELECT * FROM pages WHERE id = '426'
295 0.0001 0.00013995170593262
SELECT * FROM pages WHERE id = '430'
296 0.0001 0.00014305114746094
SELECT * FROM pages WHERE id = '431'
297 0.0002 0.0001530647277832
SELECT * FROM pages WHERE id = '434'
298 0.0002 0.00015401840209961
SELECT * FROM pages WHERE id = '435'
299 0.0002 0.00016021728515625
SELECT * FROM pages WHERE id = '440'
300 0.0002 0.00015592575073242
SELECT * FROM pages WHERE id = '441'
301 0.0001 0.00014495849609375
SELECT * FROM pages WHERE id = '451'
302 0.0001 0.00013995170593262
SELECT * FROM pages WHERE id = '453'
303 0.0001 0.00014019012451172
SELECT * FROM sideboxes_pages WHERE sidebox_id = '37'
304 0.0002 0.00016617774963379
SELECT * FROM pages WHERE id = '146'
305 0.0002 0.00015497207641602
SELECT * FROM pages WHERE id = '158'
306 0.0001 0.00014209747314453
SELECT * FROM pages WHERE id = '163'
307 0.0002 0.00023913383483887
SELECT * FROM pages WHERE id = '293'
308 0.0002 0.0001518726348877
SELECT * FROM pages WHERE id = '340'
309 0.0002 0.00015592575073242
SELECT * FROM pages WHERE id = '417'
310 0.0001 0.00014877319335938
SELECT * FROM sideboxes_pages WHERE sidebox_id = '40'
311 0.0002 0.0001680850982666
SELECT * FROM pages WHERE id = '173'
312 0.0002 0.00015521049499512
SELECT * FROM pages WHERE id = '181'
313 0.0001 0.00014209747314453
SELECT * FROM pages WHERE id = '288'
314 0.0002 0.00015091896057129
SELECT * FROM pages WHERE id = '299'
315 0.0001 0.00014710426330566
SELECT * FROM pages WHERE id = '300'
316 0.0002 0.00016403198242188
SELECT * FROM pages WHERE id = '383'
317 0.0001 0.00014090538024902
SELECT * FROM pages WHERE id = '385'
318 0.0002 0.0001530647277832
SELECT * FROM pages WHERE id = '438'
319 0.0002 0.00015711784362793
SELECT * FROM pages WHERE id = '442'
320 0.0001 0.0001380443572998
SELECT * FROM sideboxes_pages WHERE sidebox_id = '38'
321 0.0003 0.00025606155395508
SELECT * FROM pages WHERE id = '103'
322 0.0002 0.00021791458129883
SELECT * FROM pages WHERE id = '134'
323 0.0001 0.00014400482177734
SELECT * FROM pages WHERE id = '139'
324 0.0002 0.00015401840209961
SELECT * FROM pages WHERE id = '143'
325 0.0002 0.00015401840209961
SELECT * FROM pages WHERE id = '234'
326 0.0002 0.00016403198242188
SELECT * FROM pages WHERE id = '248'
327 0.0001 0.00014495849609375
SELECT * FROM pages WHERE id = '260'
328 0.0002 0.0001530647277832
SELECT * FROM pages WHERE id = '398'
329 0.0002 0.0001521110534668
SELECT * FROM sideboxes_pages WHERE sidebox_id = '29'
330 0.0002 0.00017309188842773
SELECT * FROM pages WHERE id = '61'
331 0.0002 0.00015616416931152
SELECT * FROM pages WHERE id = '87'
332 0.0002 0.00015997886657715
SELECT * FROM pages WHERE id = '104'
333 0.0002 0.00021982192993164
SELECT * FROM pages WHERE id = '115'
334 0.0001 0.00014185905456543
SELECT * FROM pages WHERE id = '124'
335 0.0002 0.00015401840209961
SELECT * FROM pages WHERE id = '144'
336 0.0002 0.00018191337585449
SELECT * FROM pages WHERE id = '151'
337 0.0001 0.00014400482177734
SELECT * FROM pages WHERE id = '199'
338 0.0002 0.00015616416931152
SELECT * FROM pages WHERE id = '200'
339 0.0001 0.00014305114746094
SELECT * FROM pages WHERE id = '304'
340 0.0001 0.00013899803161621
SELECT * FROM pages WHERE id = '321'
341 0.0001 0.00014090538024902
SELECT * FROM pages WHERE id = '333'
342 0.0002 0.00017499923706055
SELECT * FROM pages WHERE id = '350'
343 0.0001 0.00014090538024902
SELECT * FROM pages WHERE id = '378'
344 0.0001 0.00014400482177734
SELECT * FROM pages WHERE id = '422'
345 0.0002 0.00017499923706055
SELECT * FROM pages WHERE id = '425'
346 0.0001 0.00014114379882812
SELECT * FROM pages WHERE id = '443'
347 0.0001 0.00014114379882812
SELECT * FROM pages WHERE id = '444'
348 0.0001 0.00014185905456543
SELECT * FROM pages WHERE id = '445'
349 0.0001 0.00014877319335938
SELECT * FROM pages WHERE id = '446'
350 0.0001 0.00014114379882812
SELECT * FROM pages WHERE id = '447'
351 0.0001 0.00014495849609375
SELECT * FROM pages WHERE id = '448'
352 0.0001 0.00014495849609375
SELECT * FROM pages WHERE id = '455'
353 0.0002 0.00015997886657715
SELECT * FROM pages WHERE id = '456'
354 0.0001 0.00014019012451172
SELECT * FROM pages WHERE id = '459'
355 0.0002 0.00015592575073242
SELECT * FROM pages WHERE id = '460'
356 0.0001 0.00014591217041016
SELECT * FROM pages WHERE id = '462'
357 0.0001 0.00014185905456543
SELECT * FROM sideboxes_pages WHERE sidebox_id = '32'
358 0.0002 0.00016903877258301
SELECT * FROM pages WHERE id = '153'
359 0.0002 0.00021815299987793
SELECT * FROM pages WHERE id = '182'
360 0.0001 0.00014781951904297
SELECT * FROM pages WHERE id = '238'
361 0.0001 0.00014090538024902
SELECT * FROM pages WHERE id = '240'
362 0.0001 0.00013613700866699
SELECT * FROM pages WHERE id = '242'
363 0.0001 0.00013589859008789
SELECT * FROM pages WHERE id = '252'
364 0.0001 0.00013518333435059
SELECT * FROM pages WHERE id = '253'
365 0.0001 0.00014281272888184
SELECT * FROM pages WHERE id = '262'
366 0.0001 0.0001368522644043
SELECT * FROM pages WHERE id = '267'
367 0.0001 0.00014376640319824
SELECT * FROM pages WHERE id = '420'
368 0.0001 0.00013399124145508
SELECT value FROM parameters WHERE parameter = 'GOOGLE_SITE_KEY' 
369 0.0001 0.00011801719665527
SELECT value FROM parameters WHERE parameter = 'GOOGLE_SECRET_KEY' 
370 0.0001 0.00011706352233887
SELECT value FROM parameters WHERE parameter = 'GOOGLE_RECAPTCHA_TYPE' 
371 0.0014 0.0014140605926514
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
372 0.0002 0.00016999244689941
SELECT value FROM parameters WHERE parameter = 'GOOGLE_SITE_KEY' 
373 0.0001 0.00012516975402832
SELECT value FROM parameters WHERE parameter = 'GOOGLE_SECRET_KEY' 
374 0.0001 0.00011801719665527
SELECT value FROM parameters WHERE parameter = 'GOOGLE_RECAPTCHA_TYPE' 
375 0.0003 0.00027894973754883
SELECT * FROM products WHERE pagename = 'hiviz-ar-15-interchangeable-fiber-optic-sight'
376 0.0002 0.00020909309387207
SELECT * FROM manufacturers WHERE id = '2223'
377 0.0005 0.00047397613525391
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '2223'
378 0.0001 0.00012803077697754
SELECT filename FROM manufacturerimages WHERE manufacturer_id = '2223' LIMIT 1
379 0.0004 0.00040388107299805
SELECT pagename, id FROM products p WHERE manufacturer_id = '2223' ORDER BY RAND() LIMIT 1
380 0.0002 0.00020694732666016
SELECT * FROM productimages WHERE product_id = '404728' ORDER BY sortorder ASC
381 0.0004 0.00040292739868164
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '2223'
382 0.0004 0.00042891502380371
SELECT COUNT(DISTINCT(p.id)) FROM products p
				WHERE p.manufacturer_id = '2223'
				  AND p.hidden = 0
				  AND p.enabled = 1
				  AND p.parent_id = 0 
383 0.0001 0.00011682510375977
SELECT * FROM manufacturerimages WHERE manufacturer_id = '2223'
384 0.0001 0.00013113021850586
SELECT category_id FROM products_categories WHERE product_id = '402670'
385 0.0002 0.00023412704467773
SELECT * FROM categories WHERE id = '66'
386 0.0024 0.002410888671875
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
387 0.0001 0.00012302398681641
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 66
388 0.0003 0.00025391578674316
SELECT id FROM categories WHERE parent_id = '66'
389 0.0002 0.00021696090698242
SELECT id FROM categories WHERE parent_id = '131'
390 0.0029 0.0029239654541016
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 
391 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 (131,66)
				  AND p.disabled = 0 
392 0.0002 0.00015401840209961
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (131,66)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
393 0.0002 0.00016307830810547
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '66'
394 0.0002 0.00018906593322754
SELECT * FROM productimages WHERE product_id = '402670' ORDER BY sortorder ASC
395 0.0002 0.00022101402282715
SELECT * FROM product_image_select WHERE product_id = '402670'
396 0.0001 0.00012683868408203
SELECT * FROM productcustomimages WHERE product_id = '402670'
397 0.0001 0.00011301040649414
SELECT * FROM productfeeds WHERE product_id = '402670' ORDER BY item_date DESC
398 0.0003 0.00034594535827637
SELECT a.name, n.displayname, a.value, n.units, n.valuetype FROM productattributes a, productattributenames n WHERE product_id = '402670' AND a.name = n.originalname AND n.display = 1 AND n.hidden = 0
399 0.0253 0.025296926498413
SELECT DISTINCT(pt.tag_id) FROM product_tags pt, tags t WHERE pt.tag_id = t.id AND pt.product_id = '402670' AND t.hidden = 0 AND display_product = 1
400 0.0002 0.00018787384033203
SELECT * FROM tags WHERE id = '5462'
401 0.0005 0.00053095817565918
SELECT COUNT(DISTINCT(p.id)) FROM products p, product_tags t
				WHERE p.id = t.product_id
				  AND t.tag_id = '5462'
				  AND p.parent_id = 0
				  AND p.enabled = 1
				  AND p.hidden = 0
402 0.0005 0.00049805641174316
SELECT COUNT(DISTINCT(p.id)) FROM products p, product_tags t
				WHERE p.id = t.product_id
				  AND t.tag_id = '5462'
				  AND p.parent_id = 0
				  AND hidden = 0
				  AND enabled = 1 
403 0.0005 0.00053310394287109
SELECT p.id FROM products p, product_tags t WHERE p.id = t.product_id AND t.tag_id = '5462' AND p.hidden = 0 AND p.salesrank > 0 AND (p.price > 0 OR p.parent = 1) ORDER BY p.salesrank ASC LIMIT 1
404 0.0004 0.00040698051452637
SELECT * FROM productimages WHERE product_id = '129319' ORDER BY sortorder ASC
405 0.0002 0.00016307830810547
SELECT * FROM tags WHERE id = '3843'
406 0.0009 0.00087785720825195
SELECT COUNT(DISTINCT(p.id)) FROM products p, product_tags t
				WHERE p.id = t.product_id
				  AND t.tag_id = '3843'
				  AND p.parent_id = 0
				  AND p.enabled = 1
				  AND p.hidden = 0
407 0.0008 0.00084304809570312
SELECT COUNT(DISTINCT(p.id)) FROM products p, product_tags t
				WHERE p.id = t.product_id
				  AND t.tag_id = '3843'
				  AND p.parent_id = 0
				  AND hidden = 0
				  AND enabled = 1 
408 0.0009 0.00087308883666992
SELECT p.id FROM products p, product_tags t WHERE p.id = t.product_id AND t.tag_id = '3843' AND p.hidden = 0 AND p.salesrank > 0 AND (p.price > 0 OR p.parent = 1) ORDER BY p.salesrank ASC LIMIT 1
409 0.0002 0.00020289421081543
SELECT * FROM productimages WHERE product_id = '109864' ORDER BY sortorder ASC
410 0.0002 0.00015497207641602
SELECT * FROM tags WHERE id = '3613'
411 0.0007 0.0007319450378418
SELECT COUNT(DISTINCT(p.id)) FROM products p, product_tags t
				WHERE p.id = t.product_id
				  AND t.tag_id = '3613'
				  AND p.parent_id = 0
				  AND p.enabled = 1
				  AND p.hidden = 0
412 0.0007 0.00069189071655273
SELECT COUNT(DISTINCT(p.id)) FROM products p, product_tags t
				WHERE p.id = t.product_id
				  AND t.tag_id = '3613'
				  AND p.parent_id = 0
				  AND hidden = 0
				  AND enabled = 1 
413 0.0007 0.00073909759521484
SELECT p.id FROM products p, product_tags t WHERE p.id = t.product_id AND t.tag_id = '3613' AND p.hidden = 0 AND p.salesrank > 0 AND (p.price > 0 OR p.parent = 1) ORDER BY p.salesrank ASC LIMIT 1
414 0.0002 0.00023293495178223
SELECT * FROM productimages WHERE product_id = '407894' ORDER BY sortorder ASC
415 0.0031 0.0031170845031738
SELECT * FROM productamazoncontent WHERE product_id = '402670'
416 0.0023 0.0023360252380371
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '402670' AND a.name = n.originalname
417 0.0002 0.00020813941955566
SELECT * FROM productoffers WHERE product_id = '402670' AND merchantid = 'ATVPDKIKX0DER'
418 0.0002 0.00022292137145996
SELECT * FROM productoffers
                WHERE product_id = '402670' AND price > 0
                ORDER BY price ASC LIMIT 1
419 0.0004 0.00040102005004883
SELECT value FROM productattributes WHERE product_id = '402670' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
420 0.0001 0.00014591217041016
UPDATE products SET price = '1920' WHERE id = '402670'
421 0.2350 0.23498296737671
SELECT *, MATCH (description, keyfeatures, title) AGAINST ('hiviz' IN BOOLEAN MODE) AS `searchrelevance` FROM products WHERE MATCH (description, keyfeatures, title) AGAINST ('hiviz' IN BOOLEAN MODE) AND 402670 <> 0 AND enabled = 1 AND hidden = 0 AND offers > 0 AND parent_id = 0 ORDER BY `searchrelevance` LIMIT 6
422 0.0003 0.00027894973754883
SELECT * FROM productimages WHERE product_id = '93211' ORDER BY sortorder ASC
423 0.0003 0.00029110908508301
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '93211' AND p.id = pi.product_id ORDER BY pi.sortorder
424 0.0002 0.00022721290588379
SELECT * FROM product_image_select WHERE product_id = '93211'
425 0.0002 0.00015497207641602
SELECT * FROM productcustomimages WHERE product_id = '93211'
426 0.0003 0.00028491020202637
SELECT  o.product_id, MIN(o.price) as price, p.customprice
                FROM    products        p,
                        productoffers   o
                WHERE   p.id        = o.product_id
                  AND   p.parent_id = '93211'
                GROUP BY o.product_id
427 0.0003 0.00033283233642578
SELECT  n.displayname, o.name
                FROM    productoptionnames  n,
                        productoptions      o,
                        products            p
                WHERE   n.originalname  = o.name
                  AND   o.product_id    = p.id
                  AND   p.parent_id     = '93211'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
428 0.0002 0.0002439022064209
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 93211
429 0.0026 0.0025880336761475
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '93211' AND a.name = n.originalname
430 0.0002 0.00019001960754395
SELECT * FROM productoffers WHERE product_id = '93211' AND merchantid = 'ATVPDKIKX0DER'
431 0.0002 0.0002131462097168
SELECT * FROM productoffers
                WHERE product_id = '93211' AND price > 0
                ORDER BY price ASC LIMIT 1
432 0.0002 0.00018191337585449
SELECT * FROM productoffers
                WHERE product_id = 93211
                ORDER BY price ASC LIMIT 1
433 0.0003 0.0002748966217041
SELECT value FROM productattributes
                WHERE product_id = '93211'
                AND name = 'ListPriceAmount'
434 0.0003 0.00026988983154297
SELECT  o.product_id, MIN(o.price) as price, p.customprice
                FROM    products        p,
                        productoffers   o
                WHERE   p.id        = o.product_id
                  AND   p.parent_id = '93211'
                GROUP BY o.product_id
435 0.0003 0.00031590461730957
SELECT  n.displayname, o.name
                FROM    productoptionnames  n,
                        productoptions      o,
                        products            p
                WHERE   n.originalname  = o.name
                  AND   o.product_id    = p.id
                  AND   p.parent_id     = '93211'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
436 0.0002 0.00022602081298828
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 93211
437 0.0004 0.00040507316589355
SELECT value FROM productattributes WHERE product_id = '93211' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
438 0.0002 0.00015616416931152
UPDATE products SET price = '2679' WHERE id = '93211'
439 0.0003 0.00034880638122559
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '93211'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Color'
                GROUP BY o.value
                ORDER BY o.value ASC
440 0.0002 0.000244140625
SELECT * FROM productimages WHERE product_id = '142052' ORDER BY sortorder ASC
441 0.0002 0.00023221969604492
SELECT * FROM product_image_select WHERE product_id = '142052'
442 0.0001 0.0001380443572998
SELECT * FROM productcustomimages WHERE product_id = '142052'
443 0.0030 0.0030231475830078
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '142052' AND a.name = n.originalname
444 0.0002 0.0001978874206543
SELECT * FROM productoffers WHERE product_id = '142052' AND merchantid = 'ATVPDKIKX0DER'
445 0.0002 0.00021696090698242
SELECT * FROM productoffers
                WHERE product_id = '142052' AND price > 0
                ORDER BY price ASC LIMIT 1
446 0.0004 0.00043702125549316
SELECT value FROM productattributes WHERE product_id = '142052' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
447 0.0001 0.0001368522644043
UPDATE products SET price = '2682' WHERE id = '142052'
448 0.0002 0.00020790100097656
SELECT * FROM productimages WHERE product_id = '173842' ORDER BY sortorder ASC
449 0.0002 0.0002291202545166
SELECT * FROM product_image_select WHERE product_id = '173842'
450 0.0001 0.00014495849609375
SELECT * FROM productcustomimages WHERE product_id = '173842'
451 0.0024 0.0024330615997314
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '173842' AND a.name = n.originalname
452 0.0002 0.0001978874206543
SELECT * FROM productoffers WHERE product_id = '173842' AND merchantid = 'ATVPDKIKX0DER'
453 0.0002 0.00021910667419434
SELECT * FROM productoffers
                WHERE product_id = '173842' AND price > 0
                ORDER BY price ASC LIMIT 1
454 0.0004 0.00040006637573242
SELECT value FROM productattributes WHERE product_id = '173842' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
455 0.0001 0.00013613700866699
UPDATE products SET price = '5499' WHERE id = '173842'
456 0.0002 0.00020599365234375
SELECT * FROM productimages WHERE product_id = '134601' ORDER BY sortorder ASC
457 0.0002 0.00023698806762695
SELECT * FROM product_image_select WHERE product_id = '134601'
458 0.0001 0.00013589859008789
SELECT * FROM productcustomimages WHERE product_id = '134601'
459 0.0027 0.0026919841766357
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '134601' AND a.name = n.originalname
460 0.0002 0.00021100044250488
SELECT * FROM productoffers WHERE product_id = '134601' AND merchantid = 'ATVPDKIKX0DER'
461 0.0002 0.00023102760314941
SELECT * FROM productoffers
                WHERE product_id = '134601' AND price > 0
                ORDER BY price ASC LIMIT 1
462 0.0004 0.00043296813964844
SELECT value FROM productattributes WHERE product_id = '134601' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
463 0.0001 0.00014805793762207
UPDATE products SET price = '2595' WHERE id = '134601'
464 0.0003 0.00026893615722656
SELECT * FROM productimages WHERE product_id = '146781' ORDER BY sortorder ASC
465 0.0002 0.0002291202545166
SELECT * FROM product_image_select WHERE product_id = '146781'
466 0.0001 0.0001370906829834
SELECT * FROM productcustomimages WHERE product_id = '146781'
467 0.0023 0.0023179054260254
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '146781' AND a.name = n.originalname
468 0.0002 0.00020694732666016
SELECT * FROM productoffers WHERE product_id = '146781' AND merchantid = 'ATVPDKIKX0DER'
469 0.0002 0.00022315979003906
SELECT * FROM productoffers
                WHERE product_id = '146781' AND price > 0
                ORDER BY price ASC LIMIT 1
470 0.0004 0.00040602684020996
SELECT value FROM productattributes WHERE product_id = '146781' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
471 0.0001 0.00013399124145508
UPDATE products SET price = '2253' WHERE id = '146781'
472 0.0002 0.00022006034851074
SELECT * FROM productimages WHERE product_id = '171987' ORDER BY sortorder ASC
473 0.0002 0.00022983551025391
SELECT * FROM product_image_select WHERE product_id = '171987'
474 0.0001 0.00013899803161621
SELECT * FROM productcustomimages WHERE product_id = '171987'
475 0.0026 0.0025930404663086
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '171987' AND a.name = n.originalname
476 0.0002 0.00019693374633789
SELECT * FROM productoffers WHERE product_id = '171987' AND merchantid = 'ATVPDKIKX0DER'
477 0.0002 0.00022411346435547
SELECT * FROM productoffers
                WHERE product_id = '171987' AND price > 0
                ORDER BY price ASC LIMIT 1
478 0.0003 0.00033092498779297
SELECT value FROM productattributes WHERE product_id = '171987' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
479 0.0001 0.00013589859008789
UPDATE products SET price = '2522' WHERE id = '171987'
480 0.0002 0.00017404556274414
SELECT value FROM parameters WHERE parameter = 'EBAY_CACHE_TIME' 
481 0.0001 0.0001378059387207
SELECT value FROM parameters WHERE parameter = 'EBAY_APP_ID' 
482 0.0001 0.00013399124145508
SELECT value FROM parameters WHERE parameter = 'EBAY_TRACKING_ID' 
483 0.0001 0.00013208389282227
SELECT value FROM parameters WHERE parameter = 'EBAY_NETWORK_ID' 
484 0.0001 0.00013208389282227
SELECT value FROM parameters WHERE parameter = 'EBAY_LOCALE' 
485 0.0001 0.00012993812561035
SELECT value FROM parameters WHERE parameter = 'EBAY_AUTH_TOKEN' 
486 0.0002 0.0001518726348877
SELECT * FROM ebay_locale_details WHERE cur_code = 'USD' 
487 0.1896 0.18957996368408
SELECT * FROM ebay_products_cache WHERE cachekey = 'cab502bfbb97640096a487231aa674e3' 
488 0.0003 0.00025296211242676
SELECT value FROM parameters WHERE parameter = 'EBAY_APP_ID' 
489 0.0001 0.00014185905456543
SELECT value FROM parameters WHERE parameter = 'EBAY_TRACKING_ID' 
490 0.0001 0.0001370906829834
SELECT value FROM parameters WHERE parameter = 'EBAY_NETWORK_ID' 
491 0.0001 0.00013399124145508
SELECT value FROM parameters WHERE parameter = 'EBAY_LOCALE' 
492 0.0001 0.00013399124145508
SELECT value FROM parameters WHERE parameter = 'EBAY_AUTH_TOKEN' 
493 0.1932 0.1931688785553
SELECT * FROM ebay_products_cache WHERE cachekey = 'cab502bfbb97640096a487231aa674e3' 
494 0.0003 0.00028896331787109
SELECT id,asin FROM products WHERE parent_id = 402670
495 0.0003 0.00032997131347656
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '402670' ORDER BY timestamp DESC
496 0.0001 0.00014591217041016
SELECT category_id FROM products_categories WHERE product_id = '402670'
497 0.0003 0.00025606155395508
SELECT * FROM categories WHERE id = '66'
498 0.0025 0.0024609565734863
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
499 0.0001 0.00012397766113281
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 66
500 0.0003 0.00026297569274902
SELECT id FROM categories WHERE parent_id = '66'
501 0.0002 0.00020909309387207
SELECT id FROM categories WHERE parent_id = '131'
502 0.0030 0.0030109882354736
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 
503 0.0002 0.00020790100097656
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 
504 0.0002 0.00015878677368164
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 
505 0.0002 0.0001680850982666
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '66'
506 0.0023 0.0023000240325928
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '402670' AND a.name = n.originalname
507 0.0002 0.00019598007202148
SELECT * FROM productoffers WHERE product_id = '402670' AND merchantid = 'ATVPDKIKX0DER'
508 0.0002 0.00021505355834961
SELECT * FROM productoffers
                WHERE product_id = '402670' AND price > 0
                ORDER BY price ASC LIMIT 1
509 0.0002 0.0002131462097168
SELECT * FROM products WHERE id = '402670'
510 0.0004 0.00037693977355957
SELECT value FROM productattributes WHERE product_id = '402670' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
511 0.0001 0.00013303756713867
UPDATE products SET price = '1920' WHERE id = '402670'
512 0.0023 0.0022609233856201
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '402670' AND a.name = n.originalname
513 0.0002 0.00019502639770508
SELECT * FROM productoffers WHERE product_id = '402670' AND merchantid = 'ATVPDKIKX0DER'
514 0.0002 0.0001981258392334
SELECT * FROM productoffers
                WHERE product_id = '402670' AND price > 0
                ORDER BY price ASC LIMIT 1
515 0.0001 0.00013589859008789
SELECT category_id FROM products_categories WHERE product_id = '402670'
516 0.0001 0.00012087821960449
SELECT parent_id FROM categories WHERE id = '66'
517 0.0002 0.00019621849060059
SELECT * FROM categories WHERE id = '66'
518 0.0023 0.0023200511932373
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
519 0.0001 0.0001220703125
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 66
520 0.0002 0.00024294853210449
SELECT id FROM categories WHERE parent_id = '66'
521 0.0002 0.00020694732666016
SELECT id FROM categories WHERE parent_id = '131'
522 0.0029 0.0029070377349854
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 
523 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 (131,66)
				  AND p.disabled = 0 
524 0.0002 0.00016093254089355
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (131,66)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
525 0.0002 0.00016403198242188
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '66'
526 0.0002 0.00017094612121582
SELECT * FROM template_info WHERE templateuid = 'fsb-fluid'
527 0.0002 0.00016903877258301
SELECT * FROM pages WHERE id = 2
528 0.0001 0.00014185905456543
SELECT * FROM pages WHERE id = 4
529 0.0001 0.00013399124145508
SELECT * FROM pages WHERE id = 12
530 0.0001 0.0001380443572998
SELECT * FROM pages WHERE id = 10
531 0.0001 0.00013494491577148
SELECT * FROM pages WHERE id = 7
532 0.0001 0.00013995170593262
SELECT * FROM pages WHERE id = 18
533 0.0001 0.00014710426330566
SELECT * FROM pages WHERE id = 28
534 0.0001 0.00014305114746094
SELECT * FROM pages WHERE id = 13
535 0.0001 0.00013303756713867
SELECT * FROM pages WHERE id = 3
536 0.0420 0.041957139968872
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
537 0.0002 0.00023984909057617
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:1560927636;s:8:\"products\";a:6:{i:0;s:6:\"414940\";i:5;s:6:\"170197\";i:6;s:6:\"404554\";i:16;s:6:\"414188\";i:18;s:6:\"130885\";i:19;s:6:\"147874\";}}' WHERE id = '175'
538 0.0005 0.00045108795166016
SELECT * FROM products WHERE id IN (414940,170197,404554,414188,130885,147874) ORDER BY FIELD(id, 414940,170197,404554,414188,130885,147874 )
539 0.0002 0.00019502639770508
SELECT * FROM productimages WHERE product_id = '414940' ORDER BY sortorder ASC
540 0.0002 0.00021505355834961
SELECT * FROM product_image_select WHERE product_id = '414940'
541 0.0001 0.00012803077697754
SELECT * FROM productcustomimages WHERE product_id = '414940'
542 0.0034 0.0034139156341553
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '414940' AND a.name = n.originalname
543 0.0003 0.00025701522827148
SELECT * FROM productoffers WHERE product_id = '414940' AND merchantid = 'ATVPDKIKX0DER'
544 0.0003 0.00025296211242676
SELECT * FROM productoffers
                WHERE product_id = '414940' AND price > 0
                ORDER BY price ASC LIMIT 1
545 0.0005 0.00045204162597656
SELECT value FROM productattributes WHERE product_id = '414940' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
546 0.0001 0.00012612342834473
UPDATE products SET price = '4490' WHERE id = '414940'
547 0.0007 0.00068283081054688
SELECT * FROM productimages WHERE product_id = '170197' ORDER BY sortorder ASC
548 0.0002 0.00022792816162109
SELECT * FROM product_image_select WHERE product_id = '170197'
549 0.0001 0.00012493133544922
SELECT * FROM productcustomimages WHERE product_id = '170197'
550 0.0033 0.003281831741333
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '170197' AND a.name = n.originalname
551 0.0003 0.00028014183044434
SELECT * FROM productoffers WHERE product_id = '170197' AND merchantid = 'ATVPDKIKX0DER'
552 0.0002 0.00020194053649902
SELECT * FROM productoffers
                WHERE product_id = '170197' AND price > 0
                ORDER BY price ASC LIMIT 1
553 0.0004 0.00043010711669922
SELECT value FROM productattributes WHERE product_id = '170197' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
554 0.0001 0.0001220703125
UPDATE products SET price = '324500' WHERE id = '170197'
555 0.0003 0.00027203559875488
SELECT * FROM productimages WHERE product_id = '404554' ORDER BY sortorder ASC
556 0.0002 0.00021100044250488
SELECT * FROM product_image_select WHERE product_id = '404554'
557 0.0001 0.00013184547424316
SELECT * FROM productcustomimages WHERE product_id = '404554'
558 0.0034 0.0033740997314453
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '404554' AND a.name = n.originalname
559 0.0002 0.00018596649169922
SELECT * FROM productoffers WHERE product_id = '404554' AND merchantid = 'ATVPDKIKX0DER'
560 0.0002 0.0001990795135498
SELECT * FROM productoffers
                WHERE product_id = '404554' AND price > 0
                ORDER BY price ASC LIMIT 1
561 0.0005 0.00046896934509277
SELECT value FROM productattributes WHERE product_id = '404554' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
562 0.0001 0.00011992454528809
UPDATE products SET price = '399999' WHERE id = '404554'
563 0.0003 0.00026607513427734
SELECT * FROM productimages WHERE product_id = '414188' ORDER BY sortorder ASC
564 0.0002 0.00022506713867188
SELECT * FROM product_image_select WHERE product_id = '414188'
565 0.0001 0.0001220703125
SELECT * FROM productcustomimages WHERE product_id = '414188'
566 0.0026 0.0025978088378906
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '414188' AND a.name = n.originalname
567 0.0002 0.00019311904907227
SELECT * FROM productoffers WHERE product_id = '414188' AND merchantid = 'ATVPDKIKX0DER'
568 0.0002 0.00019693374633789
SELECT * FROM productoffers
                WHERE product_id = '414188' AND price > 0
                ORDER BY price ASC LIMIT 1
569 0.0004 0.00038480758666992
SELECT value FROM productattributes WHERE product_id = '414188' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
570 0.0001 0.00011801719665527
UPDATE products SET price = '9999' WHERE id = '414188'
571 0.0002 0.00020408630371094
SELECT * FROM productimages WHERE product_id = '130885' ORDER BY sortorder ASC
572 0.0002 0.0002131462097168
SELECT * FROM product_image_select WHERE product_id = '130885'
573 0.0001 0.00012087821960449
SELECT * FROM productcustomimages WHERE product_id = '130885'
574 0.0020 0.0019958019256592
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '130885' AND a.name = n.originalname
575 0.0002 0.0001838207244873
SELECT * FROM productoffers WHERE product_id = '130885' AND merchantid = 'ATVPDKIKX0DER'
576 0.0002 0.00019693374633789
SELECT * FROM productoffers
                WHERE product_id = '130885' AND price > 0
                ORDER BY price ASC LIMIT 1
577 0.0004 0.00035405158996582
SELECT value FROM productattributes WHERE product_id = '130885' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
578 0.0001 0.00011992454528809
UPDATE products SET price = '1521' WHERE id = '130885'
579 0.0002 0.00018787384033203
SELECT * FROM productimages WHERE product_id = '147874' ORDER BY sortorder ASC
580 0.0002 0.0002129077911377
SELECT * FROM product_image_select WHERE product_id = '147874'
581 0.0001 0.00013184547424316
SELECT * FROM productcustomimages WHERE product_id = '147874'
582 0.0028 0.0028128623962402
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '147874' AND a.name = n.originalname
583 0.0002 0.0001981258392334
SELECT * FROM productoffers WHERE product_id = '147874' AND merchantid = 'ATVPDKIKX0DER'
584 0.0002 0.0001990795135498
SELECT * FROM productoffers
                WHERE product_id = '147874' AND price > 0
                ORDER BY price ASC LIMIT 1
585 0.0004 0.00040006637573242
SELECT value FROM productattributes WHERE product_id = '147874' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
586 0.0001 0.00011992454528809
UPDATE products SET price = '599' WHERE id = '147874'
587 0.0417 0.041720867156982
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
588 0.0002 0.00024700164794922
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:1560927636;s:8:\"products\";a:6:{i:6;s:6:\"404554\";i:18;s:6:\"130885\";i:4;s:6:\"171938\";i:8;s:6:\"412927\";i:9;s:6:\"409759\";i:11;s:6:\"370121\";}}' WHERE id = '177'
589 0.0005 0.00045299530029297
SELECT * FROM products WHERE id IN (404554,130885,171938,412927,409759,370121) ORDER BY FIELD(id, 404554,130885,171938,412927,409759,370121 )
590 0.0003 0.00029110908508301
SELECT * FROM productimages WHERE product_id = '404554' ORDER BY sortorder ASC
591 0.0002 0.00022196769714355
SELECT * FROM product_image_select WHERE product_id = '404554'
592 0.0001 0.00012707710266113
SELECT * FROM productcustomimages WHERE product_id = '404554'
593 0.0034 0.0033650398254395
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '404554' AND a.name = n.originalname
594 0.0002 0.00019407272338867
SELECT * FROM productoffers WHERE product_id = '404554' AND merchantid = 'ATVPDKIKX0DER'
595 0.0002 0.00020909309387207
SELECT * FROM productoffers
                WHERE product_id = '404554' AND price > 0
                ORDER BY price ASC LIMIT 1
596 0.0005 0.00046205520629883
SELECT value FROM productattributes WHERE product_id = '404554' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
597 0.0001 0.0001220703125
UPDATE products SET price = '399999' WHERE id = '404554'
598 0.0002 0.00020623207092285
SELECT * FROM productimages WHERE product_id = '130885' ORDER BY sortorder ASC
599 0.0002 0.0002140998840332
SELECT * FROM product_image_select WHERE product_id = '130885'
600 0.0001 0.00012111663818359
SELECT * FROM productcustomimages WHERE product_id = '130885'
601 0.0020 0.0019898414611816
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '130885' AND a.name = n.originalname
602 0.0002 0.00018405914306641
SELECT * FROM productoffers WHERE product_id = '130885' AND merchantid = 'ATVPDKIKX0DER'
603 0.0002 0.00019693374633789
SELECT * FROM productoffers
                WHERE product_id = '130885' AND price > 0
                ORDER BY price ASC LIMIT 1
604 0.0004 0.00036191940307617
SELECT value FROM productattributes WHERE product_id = '130885' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
605 0.0001 0.00011992454528809
UPDATE products SET price = '1521' WHERE id = '130885'
606 0.0006 0.00063896179199219
SELECT * FROM productimages WHERE product_id = '171938' ORDER BY sortorder ASC
607 0.0002 0.0002291202545166
SELECT * FROM product_image_select WHERE product_id = '171938'
608 0.0001 0.00012087821960449
SELECT * FROM productcustomimages WHERE product_id = '171938'
609 0.0025 0.0025429725646973
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '171938' AND a.name = n.originalname
610 0.0002 0.00019001960754395
SELECT * FROM productoffers WHERE product_id = '171938' AND merchantid = 'ATVPDKIKX0DER'
611 0.0002 0.00020813941955566
SELECT * FROM productoffers
                WHERE product_id = '171938' AND price > 0
                ORDER BY price ASC LIMIT 1
612 0.0004 0.0003969669342041
SELECT value FROM productattributes WHERE product_id = '171938' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
613 0.0001 0.00012087821960449
UPDATE products SET price = '389500' WHERE id = '171938'
614 0.0003 0.0002589225769043
SELECT * FROM productimages WHERE product_id = '412927' ORDER BY sortorder ASC
615 0.0002 0.00021195411682129
SELECT * FROM product_image_select WHERE product_id = '412927'
616 0.0001 0.00012302398681641
SELECT * FROM productcustomimages WHERE product_id = '412927'
617 0.0036 0.0035810470581055
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '412927' AND a.name = n.originalname
618 0.0002 0.00018405914306641
SELECT * FROM productoffers WHERE product_id = '412927' AND merchantid = 'ATVPDKIKX0DER'
619 0.0002 0.00020503997802734
SELECT * FROM productoffers
                WHERE product_id = '412927' AND price > 0
                ORDER BY price ASC LIMIT 1
620 0.0004 0.0004429817199707
SELECT value FROM productattributes WHERE product_id = '412927' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
621 0.0001 0.00012111663818359
UPDATE products SET price = '199900' WHERE id = '412927'
622 0.0002 0.00020885467529297
SELECT * FROM productimages WHERE product_id = '409759' ORDER BY sortorder ASC
623 0.0002 0.00022482872009277
SELECT * FROM product_image_select WHERE product_id = '409759'
624 0.0001 0.0001220703125
SELECT * FROM productcustomimages WHERE product_id = '409759'
625 0.0028 0.0027890205383301
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '409759' AND a.name = n.originalname
626 0.0002 0.00018715858459473
SELECT * FROM productoffers WHERE product_id = '409759' AND merchantid = 'ATVPDKIKX0DER'
627 0.0002 0.00020098686218262
SELECT * FROM productoffers
                WHERE product_id = '409759' AND price > 0
                ORDER BY price ASC LIMIT 1
628 0.0004 0.00040388107299805
SELECT value FROM productattributes WHERE product_id = '409759' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
629 0.0001 0.00012397766113281
UPDATE products SET price = '229000' WHERE id = '409759'
630 0.0002 0.00018811225891113
SELECT * FROM productimages WHERE product_id = '370121' ORDER BY sortorder ASC
631 0.0002 0.00020790100097656
SELECT * FROM product_image_select WHERE product_id = '370121'
632 0.0001 0.00012111663818359
SELECT * FROM productcustomimages WHERE product_id = '370121'
633 0.0028 0.0028159618377686
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '370121' AND a.name = n.originalname
634 0.0002 0.00019001960754395
SELECT * FROM productoffers WHERE product_id = '370121' AND merchantid = 'ATVPDKIKX0DER'
635 0.0002 0.00021195411682129
SELECT * FROM productoffers
                WHERE product_id = '370121' AND price > 0
                ORDER BY price ASC LIMIT 1
636 0.0004 0.00039100646972656
SELECT value FROM productattributes WHERE product_id = '370121' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
637 0.0001 0.00012016296386719
UPDATE products SET price = '9899' WHERE id = '370121'
638 0.1080 0.10796284675598
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
639 0.0003 0.00026893615722656
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:1560927636;s:8:\"products\";a:6:{i:1;s:6:\"398315\";i:3;s:6:\"290575\";i:4;s:6:\"171938\";i:6;s:6:\"404554\";i:7;s:6:\"410950\";i:10;s:6:\"408792\";}}' WHERE id = '181'
640 0.0005 0.00047087669372559
SELECT * FROM products WHERE id IN (398315,290575,171938,404554,410950,408792) ORDER BY FIELD(id, 398315,290575,171938,404554,410950,408792 )
641 0.0002 0.00022506713867188
SELECT * FROM productimages WHERE product_id = '398315' ORDER BY sortorder ASC
642 0.0002 0.00023198127746582
SELECT * FROM product_image_select WHERE product_id = '398315'
643 0.0001 0.00013113021850586
SELECT * FROM productcustomimages WHERE product_id = '398315'
644 0.0032 0.0032079219818115
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '398315' AND a.name = n.originalname
645 0.0002 0.0001978874206543
SELECT * FROM productoffers WHERE product_id = '398315' AND merchantid = 'ATVPDKIKX0DER'
646 0.0002 0.0002140998840332
SELECT * FROM productoffers
                WHERE product_id = '398315' AND price > 0
                ORDER BY price ASC LIMIT 1
647 0.0004 0.00044488906860352
SELECT value FROM productattributes WHERE product_id = '398315' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
648 0.0001 0.00012516975402832
UPDATE products SET price = '1999' WHERE id = '398315'
649 0.0006 0.00060820579528809
SELECT * FROM productimages WHERE product_id = '290575' ORDER BY sortorder ASC
650 0.0002 0.00023007392883301
SELECT * FROM product_image_select WHERE product_id = '290575'
651 0.0001 0.00012302398681641
SELECT * FROM productcustomimages WHERE product_id = '290575'
652 0.0037 0.0037238597869873
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '290575' AND a.name = n.originalname
653 0.0003 0.00025010108947754
SELECT * FROM productoffers WHERE product_id = '290575' AND merchantid = 'ATVPDKIKX0DER'
654 0.0002 0.00021195411682129
SELECT * FROM productoffers
                WHERE product_id = '290575' AND price > 0
                ORDER BY price ASC LIMIT 1
655 0.0005 0.00047492980957031
SELECT value FROM productattributes WHERE product_id = '290575' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
656 0.0001 0.00012302398681641
UPDATE products SET price = '549500' WHERE id = '290575'
657 0.0006 0.00064182281494141
SELECT * FROM productimages WHERE product_id = '171938' ORDER BY sortorder ASC
658 0.0002 0.00021600723266602
SELECT * FROM product_image_select WHERE product_id = '171938'
659 0.0001 0.0001218318939209
SELECT * FROM productcustomimages WHERE product_id = '171938'
660 0.0029 0.0028910636901855
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '171938' AND a.name = n.originalname
661 0.0002 0.00020599365234375
SELECT * FROM productoffers WHERE product_id = '171938' AND merchantid = 'ATVPDKIKX0DER'
662 0.0002 0.00021815299987793
SELECT * FROM productoffers
                WHERE product_id = '171938' AND price > 0
                ORDER BY price ASC LIMIT 1
663 0.0004 0.00041103363037109
SELECT value FROM productattributes WHERE product_id = '171938' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
664 0.0001 0.00012302398681641
UPDATE products SET price = '389500' WHERE id = '171938'
665 0.0003 0.00027203559875488
SELECT * FROM productimages WHERE product_id = '404554' ORDER BY sortorder ASC
666 0.0002 0.00020790100097656
SELECT * FROM product_image_select WHERE product_id = '404554'
667 0.0001 0.0001220703125
SELECT * FROM productcustomimages WHERE product_id = '404554'
668 0.0036 0.0036249160766602
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '404554' AND a.name = n.originalname
669 0.0002 0.00019001960754395
SELECT * FROM productoffers WHERE product_id = '404554' AND merchantid = 'ATVPDKIKX0DER'
670 0.0002 0.0001978874206543
SELECT * FROM productoffers
                WHERE product_id = '404554' AND price > 0
                ORDER BY price ASC LIMIT 1
671 0.0005 0.00049710273742676
SELECT value FROM productattributes WHERE product_id = '404554' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
672 0.0001 0.00012683868408203
UPDATE products SET price = '399999' WHERE id = '404554'
673 0.0003 0.00026488304138184
SELECT * FROM productimages WHERE product_id = '410950' ORDER BY sortorder ASC
674 0.0002 0.00022006034851074
SELECT * FROM product_image_select WHERE product_id = '410950'
675 0.0001 0.00012707710266113
SELECT * FROM productcustomimages WHERE product_id = '410950'
676 0.0031 0.0031299591064453
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '410950' AND a.name = n.originalname
677 0.0002 0.00018715858459473
SELECT * FROM productoffers WHERE product_id = '410950' AND merchantid = 'ATVPDKIKX0DER'
678 0.0002 0.0001990795135498
SELECT * FROM productoffers
                WHERE product_id = '410950' AND price > 0
                ORDER BY price ASC LIMIT 1
679 0.0005 0.00046992301940918
SELECT value FROM productattributes WHERE product_id = '410950' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
680 0.0002 0.00015115737915039
UPDATE products SET price = '399999' WHERE id = '410950'
681 0.0002 0.00020408630371094
SELECT * FROM productimages WHERE product_id = '408792' ORDER BY sortorder ASC
682 0.0002 0.00020599365234375
SELECT * FROM product_image_select WHERE product_id = '408792'
683 0.0001 0.00013089179992676
SELECT * FROM productcustomimages WHERE product_id = '408792'
684 0.0036 0.0036380290985107
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '408792' AND a.name = n.originalname
685 0.0002 0.00018596649169922
SELECT * FROM productoffers WHERE product_id = '408792' AND merchantid = 'ATVPDKIKX0DER'
686 0.0002 0.00020790100097656
SELECT * FROM productoffers
                WHERE product_id = '408792' AND price > 0
                ORDER BY price ASC LIMIT 1
687 0.0004 0.00043916702270508
SELECT value FROM productattributes WHERE product_id = '408792' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
688 0.0001 0.00011992454528809
UPDATE products SET price = '13499' WHERE id = '408792'
689 0.1035 0.10347890853882
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
690 0.0003 0.00028109550476074
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:1560927636;s:8:\"products\";a:6:{i:1;s:6:\"398315\";i:12;s:6:\"403517\";i:0;s:6:\"414940\";i:3;s:6:\"290575\";i:4;s:6:\"171938\";i:17;s:6:\"406758\";}}' WHERE id = '183'
691 0.0005 0.00048208236694336
SELECT * FROM products WHERE id IN (398315,403517,414940,290575,171938,406758) ORDER BY FIELD(id, 398315,403517,414940,290575,171938,406758 )
692 0.0002 0.00022482872009277
SELECT * FROM productimages WHERE product_id = '398315' ORDER BY sortorder ASC
693 0.0002 0.00022006034851074
SELECT * FROM product_image_select WHERE product_id = '398315'
694 0.0001 0.00012898445129395
SELECT * FROM productcustomimages WHERE product_id = '398315'
695 0.0026 0.0026168823242188
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '398315' AND a.name = n.originalname
696 0.0002 0.00018692016601562
SELECT * FROM productoffers WHERE product_id = '398315' AND merchantid = 'ATVPDKIKX0DER'
697 0.0002 0.00022292137145996
SELECT * FROM productoffers
                WHERE product_id = '398315' AND price > 0
                ORDER BY price ASC LIMIT 1
698 0.0004 0.00039196014404297
SELECT value FROM productattributes WHERE product_id = '398315' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
699 0.0001 0.00012612342834473
UPDATE products SET price = '1999' WHERE id = '398315'
700 0.0003 0.00026082992553711
SELECT * FROM productimages WHERE product_id = '403517' ORDER BY sortorder ASC
701 0.0002 0.00022602081298828
SELECT * FROM product_image_select WHERE product_id = '403517'
702 0.0001 0.0001227855682373
SELECT * FROM productcustomimages WHERE product_id = '403517'
703 0.0030 0.0030410289764404
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '403517' AND a.name = n.originalname
704 0.0002 0.00019001960754395
SELECT * FROM productoffers WHERE product_id = '403517' AND merchantid = 'ATVPDKIKX0DER'
705 0.0002 0.0001990795135498
SELECT * FROM productoffers
                WHERE product_id = '403517' AND price > 0
                ORDER BY price ASC LIMIT 1
706 0.0004 0.00042319297790527
SELECT value FROM productattributes WHERE product_id = '403517' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
707 0.0001 0.00012087821960449
UPDATE products SET price = '6699' WHERE id = '403517'
708 0.0002 0.00017809867858887
SELECT * FROM productimages WHERE product_id = '414940' ORDER BY sortorder ASC
709 0.0002 0.00021195411682129
SELECT * FROM product_image_select WHERE product_id = '414940'
710 0.0001 0.00012302398681641
SELECT * FROM productcustomimages WHERE product_id = '414940'
711 0.0033 0.0033230781555176
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '414940' AND a.name = n.originalname
712 0.0002 0.00019502639770508
SELECT * FROM productoffers WHERE product_id = '414940' AND merchantid = 'ATVPDKIKX0DER'
713 0.0002 0.00021004676818848
SELECT * FROM productoffers
                WHERE product_id = '414940' AND price > 0
                ORDER BY price ASC LIMIT 1
714 0.0004 0.0004420280456543
SELECT value FROM productattributes WHERE product_id = '414940' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
715 0.0001 0.00011992454528809
UPDATE products SET price = '4490' WHERE id = '414940'
716 0.0006 0.00059390068054199
SELECT * FROM productimages WHERE product_id = '290575' ORDER BY sortorder ASC
717 0.0002 0.00022506713867188
SELECT * FROM product_image_select WHERE product_id = '290575'
718 0.0001 0.00012421607971191
SELECT * FROM productcustomimages WHERE product_id = '290575'
719 0.0034 0.0034148693084717
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '290575' AND a.name = n.originalname
720 0.0002 0.00018906593322754
SELECT * FROM productoffers WHERE product_id = '290575' AND merchantid = 'ATVPDKIKX0DER'
721 0.0002 0.0001988410949707
SELECT * FROM productoffers
                WHERE product_id = '290575' AND price > 0
                ORDER BY price ASC LIMIT 1
722 0.0004 0.00042986869812012
SELECT value FROM productattributes WHERE product_id = '290575' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
723 0.0001 0.00013089179992676
UPDATE products SET price = '549500' WHERE id = '290575'
724 0.0006 0.00061607360839844
SELECT * FROM productimages WHERE product_id = '171938' ORDER BY sortorder ASC
725 0.0002 0.00023007392883301
SELECT * FROM product_image_select WHERE product_id = '171938'
726 0.0001 0.00012493133544922
SELECT * FROM productcustomimages WHERE product_id = '171938'
727 0.0025 0.0025339126586914
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '171938' AND a.name = n.originalname
728 0.0002 0.00020003318786621
SELECT * FROM productoffers WHERE product_id = '171938' AND merchantid = 'ATVPDKIKX0DER'
729 0.0002 0.00021004676818848
SELECT * FROM productoffers
                WHERE product_id = '171938' AND price > 0
                ORDER BY price ASC LIMIT 1
730 0.0004 0.00038886070251465
SELECT value FROM productattributes WHERE product_id = '171938' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
731 0.0001 0.0001220703125
UPDATE products SET price = '389500' WHERE id = '171938'
732 0.0002 0.0001990795135498
SELECT * FROM productimages WHERE product_id = '406758' ORDER BY sortorder ASC
733 0.0002 0.00021696090698242
SELECT * FROM product_image_select WHERE product_id = '406758'
734 0.0001 0.00012302398681641
SELECT * FROM productcustomimages WHERE product_id = '406758'
735 0.0027 0.0026559829711914
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '406758' AND a.name = n.originalname
736 0.0002 0.00018787384033203
SELECT * FROM productoffers WHERE product_id = '406758' AND merchantid = 'ATVPDKIKX0DER'
737 0.0002 0.00020503997802734
SELECT * FROM productoffers
                WHERE product_id = '406758' AND price > 0
                ORDER BY price ASC LIMIT 1
738 0.0004 0.0003972053527832
SELECT value FROM productattributes WHERE product_id = '406758' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
739 0.0001 0.00012302398681641
UPDATE products SET price = '2694' WHERE id = '406758'
740 0.0004 0.0003969669342041
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid' AND area = 'header' ORDER BY sortorder ASC
741 0.0001 0.00014305114746094
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
742 0.0001 0.00012707710266113
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
743 0.0001 0.00012302398681641
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
744 0.0001 0.00011992454528809
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
745 0.0004 0.00040006637573242
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid' AND area = 'footer' ORDER BY sortorder ASC
746 0.0001 0.00012898445129395
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
747 0.0001 0.0001218318939209
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
748 0.0001 0.00011897087097168
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
749 0.0009 0.00093197822570801
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-fluid' AND skinuid = ''
750 0.0003 0.00031781196594238
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid'
751 0.0003 0.0002899169921875
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid'
752 0.0004 0.00042295455932617
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid' AND imageuid = 'HEAD_CUSTOM_BANNER'
753 0.0003 0.00033688545227051
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid' AND imageuid = 'HEAD_CUSTOM_BANNER'