Tactical Equipment - Survivalist Equipment

Streamlight 44931 The Siege Lantern by Streamlight

Price: Click Button for Price
Product prices and availability are accurate as of 2019-06-24 21:07:39 UTC and are subject to change. Any price and availability information displayed on http://www.amazon.com/ at the time of purchase will apply to the purchase of this product.
Availability: Not Available Discontinued
CERTAIN CONTENT THAT APPEARS ON THIS SITE COMES FROM AMAZON SERVICES LLC. THIS CONTENT IS PROVIDED 'AS IS' AND IS SUBJECT TO CHANGE OR REMOVAL AT ANY TIME.

Product Description

Tactical Survivalist : Combat Gear : Survival Gear : Combat Equipment is happy to bring you the famous Streamlight 44931 The Siege Lantern today at this low price.

With so many competing tactical, combat and survival products on offer today, it is good to have a provider that you can recognize. The Streamlight 44931 The Siege Lantern is certainly all that and will be a great purchase for your combat gear or tactical training.

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

For this reduced price, the Streamlight 44931 The Siege Lantern is highly recommended and is a popular choice for many like minded people. Streamlight have added some excellent touches and this equals good value for money.

Manufacturer Description

The Siege Cordless Lantern, Coyote

Product Features

Flashlight Bulb Type: LED Color: Yellow, Brown

Write a Review

Debug Overview

App Total Time DB Queries DB Query Total Time Amazon Requests
2.8587870597839 760 2.1366 0


No Amazon API Requests Made.


App Debug - Total Time 2.8587870597839 seconds

Number Time From Start Name Description
1 0.48286318778992 Initialise Initialise FSB Function
2 0.498202085495 App Controller Start Start of the App controller (called before the controller of every page)
3 0.50969505310059 Start of getCategoryListByGroup Function Before first category groups query
4 0.50986218452454 After initial query Before first category groups query
5 0.50986313819885 Get Category List for Group Before the call to getCategoryList function
6 0.50987005233765 Start of GetCategoryList function Start of the function
7 0.50987410545349 Before getting categories Query to get specific category list
8 0.51047706604004 After getting categories Query to get specific category list
9 0.51047921180725 Before getting category custom Before call to function getCategoryCustom
10 0.51236009597778 After getting category custom After call to function getCategoryCustom
11 0.51236319541931 Before getting category custom Before call to function getCategoryCustom
12 0.52315807342529 After getting category custom After call to function getCategoryCustom
13 0.5231602191925 Before getting category custom Before call to function getCategoryCustom
14 0.52886509895325 After getting category custom After call to function getCategoryCustom
15 0.52886819839478 Before getting category custom Before call to function getCategoryCustom
16 0.5330491065979 After getting category custom After call to function getCategoryCustom
17 0.53305220603943 End of GetCategoryList function End of the function
18 0.53306007385254 Get Category List for Group Before the call to getCategoryList function
19 0.53306221961975 Start of GetCategoryList function Start of the function
20 0.5330650806427 Before getting categories Query to get specific category list
21 0.5334939956665 After getting categories Query to get specific category list
22 0.5334951877594 Before getting category custom Before call to function getCategoryCustom
23 0.53915309906006 After getting category custom After call to function getCategoryCustom
24 0.53915619850159 Before getting category custom Before call to function getCategoryCustom
25 0.54996609687805 After getting category custom After call to function getCategoryCustom
26 0.54996800422668 End of GetCategoryList function End of the function
27 0.54997515678406 Get Category List for Group Before the call to getCategoryList function
28 0.54997801780701 Start of GetCategoryList function Start of the function
29 0.54998111724854 Before getting categories Query to get specific category list
30 0.55078911781311 After getting categories Query to get specific category list
31 0.55079102516174 Before getting category custom Before call to function getCategoryCustom
32 0.56014609336853 After getting category custom After call to function getCategoryCustom
33 0.56014919281006 Before getting category custom Before call to function getCategoryCustom
34 0.57791900634766 After getting category custom After call to function getCategoryCustom
35 0.57792115211487 Before getting category custom Before call to function getCategoryCustom
36 0.5840220451355 After getting category custom After call to function getCategoryCustom
37 0.58402514457703 Before getting category custom Before call to function getCategoryCustom
38 0.59004306793213 After getting category custom After call to function getCategoryCustom
39 0.59004616737366 Before getting category custom Before call to function getCategoryCustom
40 0.59652018547058 After getting category custom After call to function getCategoryCustom
41 0.59652400016785 Before getting category custom Before call to function getCategoryCustom
42 0.61897706985474 After getting category custom After call to function getCategoryCustom
43 0.61898112297058 Before getting category custom Before call to function getCategoryCustom
44 0.6232922077179 After getting category custom After call to function getCategoryCustom
45 0.62329602241516 Before getting category custom Before call to function getCategoryCustom
46 0.62862300872803 After getting category custom After call to function getCategoryCustom
47 0.62862610816956 End of GetCategoryList function End of the function
48 0.62864112854004 Get Category List for Group Before the call to getCategoryList function
49 0.62864518165588 Start of GetCategoryList function Start of the function
50 0.62864804267883 Before getting categories Query to get specific category list
51 0.62914514541626 After getting categories Query to get specific category list
52 0.62914705276489 Before getting category custom Before call to function getCategoryCustom
53 0.63164710998535 After getting category custom After call to function getCategoryCustom
54 0.63164901733398 Before getting category custom Before call to function getCategoryCustom
55 0.63411712646484 After getting category custom After call to function getCategoryCustom
56 0.63411903381348 End of GetCategoryList function End of the function
57 0.63412618637085 Get Category List for Group Before the call to getCategoryList function
58 0.63412809371948 Start of GetCategoryList function Start of the function
59 0.63414621353149 Before getting categories Query to get specific category list
60 0.63449311256409 After getting categories Query to get specific category list
61 0.63449501991272 Before getting category custom Before call to function getCategoryCustom
62 0.63975405693054 After getting category custom After call to function getCategoryCustom
63 0.63975620269775 End of GetCategoryList function End of the function
64 0.63976311683655 End of getCategoryListByGroup Function Before return()
65 0.69639015197754 App Controller End End of the App controller (called before the controller of every page)
66 0.69705200195312 Product Start Start of the product info controller
67 0.69798803329468 Cache file not found Starting get product details
68 0.76509118080139 Related products Start getting related products if enabled
69 0.76509308815002 Related Products Start Before the related products are found
70 0.76509404182434 Related Products Keywords Before the related product keywords are found
71 0.76510620117188 Create Keyword List Function Start of function
72 0.7657310962677 Create Keyword List Function After looping provided content - 319 keywords found
73 0.78626799583435 Create Keyword List Function After looping initial keyword list - 286 keywords remaining
74 0.78635001182556 Create Keyword List Function After reducing keyword list
75 0.78793120384216 Create Keyword List Function After selecting by scoring keywords
76 0.78793716430664 Create Keyword List Function After final loop of keywords
77 0.78794002532959 Related Products Keywords After the related product keywords are found
78 1.868851184845 Related Products End After the related products are found
79 2.0716202259064 Start Remote Request http://svcs.ebay.com/services/search/FindingServic...
80 2.2058072090149 End Remote Request http://svcs.ebay.com/services/search/FindingServic...
81 2.4422810077667 Product End End of the product info controller (Product Info)
82 2.4426500797272 App_after Controller Start Start of the App_after controller (called after the controller of every page)
83 2.4427700042725 Before Get Options Before the call to getOptions in the tpl class
84 2.8186070919037 After Get Options After the call to getOptions in the tpl class
85 2.8188600540161 App_after Controller End End of the App_after controller (called after the controller of every page)
86 2.818873167038 Product Info: Before Smarty Fetch Before the product.tpl template is fetched
87 2.8347442150116 Product Info: After Smarty Fetch After the product.tpl template is fetched
88 2.8347501754761 Product Info: Before Template Display Before the template is displayed
89 2.8587641716003 Product Info: After Template Display After the template is displayed
90 2.8587701320648 Finalizing debug Before the debug is output to the page.
91 2.8587861061096 End of App This is the end of the app logging, final timestamp


Query Debug - 760 Database Queries. Total time 2.1366 seconds

Number Time (Seconds) Time (Milliseconds) Query
1 0.0002 0.0002129077911377
SELECT value FROM parameters WHERE `parameter` = 'BAD_BOTS_ENABLER'
2 0.0005 0.00047206878662109
SHOW TABLES LIKE 'bad_bots'
3 0.0002 0.00017595291137695
SELECT value FROM parameters WHERE `parameter` = 'STORE_WHITELISTED_IPS'
4 0.0002 0.00018906593322754
SELECT * FROM `bad_bots`
5 0.0005 0.00046491622924805
SELECT parameter, value FROM parameters
6 0.0002 0.00015592575073242
SET time_zone = 'Europe/London'
7 0.0003 0.00029706954956055
SELECT * FROM autorun ORDER BY lastrun ASC
8 0.0001 0.00014209747314453
SELECT * FROM version ORDER BY installed DESC LIMIT 1
9 0.0001 0.00012898445129395
delete from cachefiles
10 0.0002 0.00023603439331055
SELECT id FROM pages WHERE pagename = 'streamlight-44931-the-siege-lantern' LIMIT 1
11 0.0002 0.00020694732666016
SELECT id FROM products WHERE pagename = 'streamlight-44931-the-siege-lantern' AND hidden = 0 LIMIT 1
12 0.0008 0.00079798698425293
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-fluid'
13 0.0091 0.009145975112915
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-fluid' AND language = 'en'
14 0.0002 0.00024294853210449
SELECT * FROM pages WHERE pagename = 'streamlight-44931-the-siege-lantern'
15 0.0002 0.0001521110534668
SELECT * FROM categorygroups ORDER BY sortorder ASC
16 0.0005 0.00051307678222656
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
17 0.0005 0.00048494338989258
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.00023388862609863
SELECT id FROM categories WHERE parent_id = '49'
19 0.0004 0.00044989585876465
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (49)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
20 0.0002 0.00015020370483398
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (49)
				  AND p.disabled = 0 
21 0.0001 0.00014686584472656
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.00017786026000977
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '49'
23 0.0001 0.00012302398681641
SELECT * FROM categorygroups WHERE id = '1'
24 0.0031 0.0031380653381348
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.00025701522827148
SELECT id FROM categories WHERE parent_id = '50'
26 0.0002 0.00020313262939453
SELECT id FROM categories WHERE parent_id = '96'
27 0.0002 0.00020790100097656
SELECT id FROM categories WHERE parent_id = '97'
28 0.0002 0.0001990795135498
SELECT id FROM categories WHERE parent_id = '111'
29 0.0002 0.0001981258392334
SELECT id FROM categories WHERE parent_id = '129'
30 0.0058 0.0058491230010986
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.0001671314239502
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.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 (96,97,111,129,50)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
33 0.0002 0.00016689300537109
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '50'
34 0.0001 0.00012302398681641
SELECT * FROM categorygroups WHERE id = '1'
35 0.0024 0.0023820400238037
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.00025606155395508
SELECT id FROM categories WHERE parent_id = '80'
37 0.0024 0.0024070739746094
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.0001 0.00014281272888184
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.00014400482177734
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.00015401840209961
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '80'
41 0.0001 0.00012111663818359
SELECT * FROM categorygroups WHERE id = '1'
42 0.0012 0.0011780261993408
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.00025606155395508
SELECT id FROM categories WHERE parent_id = '51'
44 0.0002 0.00020384788513184
SELECT id FROM categories WHERE parent_id = '101'
45 0.0019 0.001863956451416
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.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 (101,51)
				  AND p.disabled = 0 
47 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 (101,51)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
48 0.0002 0.00016403198242188
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '51'
49 0.0001 0.00012111663818359
SELECT * FROM categorygroups WHERE id = '1'
50 0.0004 0.00040483474731445
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '2'  AND hidden = 0 ORDER BY sortorder ASC
51 0.0024 0.0023670196533203
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.00025796890258789
SELECT id FROM categories WHERE parent_id = '30'
53 0.0024 0.0023550987243652
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.0001 0.00014615058898926
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.00014209747314453
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.00016593933105469
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
57 0.0001 0.00013017654418945
SELECT * FROM categorygroups WHERE id = '2'
58 0.0049 0.0049200057983398
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.0002751350402832
SELECT id FROM categories WHERE parent_id = '61'
60 0.0049 0.0049309730529785
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.0001521110534668
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.00014400482177734
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.00016117095947266
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '61'
64 0.0001 0.0001220703125
SELECT * FROM categorygroups WHERE id = '2'
65 0.0006 0.00064206123352051
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '10'  AND hidden = 0 ORDER BY sortorder ASC
66 0.0042 0.004209041595459
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.00027203559875488
SELECT id FROM categories WHERE parent_id = '64'
68 0.0042 0.0041890144348145
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.00015616416931152
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.00014305114746094
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.00015997886657715
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '64'
72 0.0001 0.00012111663818359
SELECT * FROM categorygroups WHERE id = '10'
73 0.0084 0.0083751678466797
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.00028109550476074
SELECT id FROM categories WHERE parent_id = '65'
75 0.0084 0.0084278583526611
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.00015997886657715
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.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 (65)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
78 0.0002 0.00016307830810547
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '65'
79 0.0001 0.0001220703125
SELECT * FROM categorygroups WHERE id = '10'
80 0.0026 0.0025701522827148
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.00026416778564453
SELECT id FROM categories WHERE parent_id = '81'
82 0.0026 0.0025839805603027
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.0001518726348877
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.00014305114746094
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.00015687942504883
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '81'
86 0.0001 0.00012087821960449
SELECT * FROM categorygroups WHERE id = '10'
87 0.0025 0.0025100708007812
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.00025796890258789
SELECT id FROM categories WHERE parent_id = '31'
89 0.0025 0.0025200843811035
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.00015902519226074
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.00014710426330566
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.00016999244689941
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
93 0.0001 0.00012803077697754
SELECT * FROM categorygroups WHERE id = '10'
94 0.0023 0.0023348331451416
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 66
95 0.0003 0.0002739429473877
SELECT id FROM categories WHERE parent_id = '66'
96 0.0002 0.00021195411682129
SELECT id FROM categories WHERE parent_id = '131'
97 0.0029 0.002910852432251
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.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 
99 0.0002 0.00016307830810547
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (131,66)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
100 0.0002 0.00016379356384277
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '66'
101 0.0001 0.00012612342834473
SELECT * FROM categorygroups WHERE id = '10'
102 0.0098 0.0098299980163574
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.00030183792114258
SELECT id FROM categories WHERE parent_id = '34'
104 0.0002 0.00020503997802734
SELECT id FROM categories WHERE parent_id = '94'
105 0.0002 0.00020122528076172
SELECT id FROM categories WHERE parent_id = '98'
106 0.0002 0.00020599365234375
SELECT id FROM categories WHERE parent_id = '99'
107 0.0002 0.0001990795135498
SELECT id FROM categories WHERE parent_id = '110'
108 0.0002 0.0001990795135498
SELECT id FROM categories WHERE parent_id = '130'
109 0.0105 0.010500907897949
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.00018000602722168
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.00015783309936523
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.00017905235290527
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '34'
113 0.0001 0.00012779235839844
SELECT * FROM categorygroups WHERE id = '10'
114 0.0016 0.0016088485717773
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.0002748966217041
SELECT id FROM categories WHERE parent_id = '32'
116 0.0017 0.0016531944274902
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (32)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
117 0.0002 0.00016403198242188
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (32)
				  AND p.disabled = 0 
118 0.0002 0.00015497207641602
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.00017285346984863
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '32'
120 0.0001 0.00013494491577148
SELECT * FROM categorygroups WHERE id = '10'
121 0.0020 0.0019619464874268
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.00034594535827637
SELECT id FROM categories WHERE parent_id = '89'
123 0.0021 0.0021240711212158
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (89)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
124 0.0002 0.00023698806762695
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (89)
				  AND p.disabled = 0 
125 0.0002 0.00017690658569336
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.00020718574523926
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '89'
127 0.0001 0.0001370906829834
SELECT * FROM categorygroups WHERE id = '10'
128 0.0004 0.0004420280456543
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '17'  AND hidden = 0 ORDER BY sortorder ASC
129 0.0007 0.00074386596679688
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 84
130 0.0003 0.00026702880859375
SELECT id FROM categories WHERE parent_id = '84'
131 0.0007 0.00072908401489258
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (84)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
132 0.0001 0.00014615058898926
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (84)
				  AND p.disabled = 0 
133 0.0002 0.00018000602722168
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (84)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
134 0.0002 0.00018000602722168
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '84'
135 0.0001 0.00013399124145508
SELECT * FROM categorygroups WHERE id = '17'
136 0.0007 0.00073695182800293
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.00024986267089844
SELECT id FROM categories WHERE parent_id = '90'
138 0.0008 0.00076198577880859
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.00014805793762207
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (90)
				  AND p.disabled = 0 
140 0.0002 0.0001521110534668
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.00016689300537109
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '90'
142 0.0001 0.00013089179992676
SELECT * FROM categorygroups WHERE id = '17'
143 0.0003 0.00032591819763184
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '20'  AND hidden = 0 ORDER BY sortorder ASC
144 0.0021 0.0021240711212158
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 92
145 0.0003 0.0002589225769043
SELECT id FROM categories WHERE parent_id = '92'
146 0.0021 0.0021209716796875
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (92)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
147 0.0002 0.00016379356384277
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.00015711784362793
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.00016212463378906
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '92'
150 0.0001 0.00014305114746094
SELECT * FROM categorygroups WHERE id = '20'
151 0.0053 0.0053040981292725
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
152 0.0004 0.00039196014404297
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-fluid' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
153 0.0002 0.0001678466796875
SELECT value FROM parameters WHERE parameter = 'EBAY_APP_ID' 
154 0.0002 0.00018596649169922
SELECT * FROM sideboxes_pages WHERE sidebox_id = '1'
155 0.0002 0.00018095970153809
SELECT * FROM pages WHERE id = '67'
156 0.0002 0.0001680850982666
SELECT * FROM pages WHERE id = '82'
157 0.0002 0.00016999244689941
SELECT * FROM pages WHERE id = '84'
158 0.0002 0.00015592575073242
SELECT * FROM pages WHERE id = '94'
159 0.0002 0.00018405914306641
SELECT * FROM pages WHERE id = '116'
160 0.0002 0.00022697448730469
SELECT * FROM pages WHERE id = '52'
161 0.0002 0.00017094612121582
SELECT * FROM pages WHERE id = '135'
162 0.0002 0.00016593933105469
SELECT * FROM pages WHERE id = '245'
163 0.0002 0.00020098686218262
SELECT * FROM pages WHERE id = '269'
164 0.0002 0.00021886825561523
SELECT * FROM pages WHERE id = '275'
165 0.0002 0.00020885467529297
SELECT * FROM pages WHERE id = '280'
166 0.0002 0.00022196769714355
SELECT * FROM pages WHERE id = '357'
167 0.0002 0.00015902519226074
SELECT * FROM pages WHERE id = '379'
168 0.0002 0.00015592575073242
SELECT * FROM pages WHERE id = '401'
169 0.0002 0.00016283988952637
SELECT * FROM pages WHERE id = '450'
170 0.0002 0.00015902519226074
SELECT * FROM pages WHERE id = '454'
171 0.0002 0.00016689300537109
SELECT * FROM pages WHERE id = '457'
172 0.0002 0.00016283988952637
SELECT * FROM pages WHERE id = '458'
173 0.0002 0.00017690658569336
SELECT * FROM sideboxes_pages WHERE sidebox_id = '2'
174 0.0002 0.00017094612121582
SELECT * FROM pages WHERE id = '41'
175 0.0002 0.00017213821411133
SELECT * FROM pages WHERE id = '43'
176 0.0002 0.00015997886657715
SELECT * FROM pages WHERE id = '44'
177 0.0002 0.00015401840209961
SELECT * FROM pages WHERE id = '68'
178 0.0002 0.00023293495178223
SELECT * FROM pages WHERE id = '80'
179 0.0002 0.00017213821411133
SELECT * FROM pages WHERE id = '85'
180 0.0002 0.0001678466796875
SELECT * FROM pages WHERE id = '97'
181 0.0002 0.00016689300537109
SELECT * FROM pages WHERE id = '107'
182 0.0002 0.00017499923706055
SELECT * FROM pages WHERE id = '108'
183 0.0002 0.0001530647277832
SELECT * FROM pages WHERE id = '128'
184 0.0002 0.00019001960754395
SELECT * FROM pages WHERE id = '133'
185 0.0002 0.00015902519226074
SELECT * FROM pages WHERE id = '148'
186 0.0002 0.00016903877258301
SELECT * FROM pages WHERE id = '217'
187 0.0002 0.00017094612121582
SELECT * FROM pages WHERE id = '228'
188 0.0002 0.00016689300537109
SELECT * FROM pages WHERE id = '257'
189 0.0002 0.00017094612121582
SELECT * FROM pages WHERE id = '271'
190 0.0002 0.00015807151794434
SELECT * FROM pages WHERE id = '286'
191 0.0002 0.00015711784362793
SELECT * FROM pages WHERE id = '287'
192 0.0002 0.00018000602722168
SELECT * FROM pages WHERE id = '291'
193 0.0002 0.00017189979553223
SELECT * FROM pages WHERE id = '380'
194 0.0002 0.0001678466796875
SELECT * FROM pages WHERE id = '344'
195 0.0002 0.00018787384033203
SELECT * FROM pages WHERE id = '354'
196 0.0002 0.00021004676818848
SELECT * FROM pages WHERE id = '363'
197 0.0002 0.0001978874206543
SELECT * FROM pages WHERE id = '364'
198 0.0002 0.00016021728515625
SELECT * FROM pages WHERE id = '368'
199 0.0002 0.00018715858459473
SELECT * FROM pages WHERE id = '369'
200 0.0002 0.00015807151794434
SELECT * FROM pages WHERE id = '400'
201 0.0002 0.00017809867858887
SELECT * FROM pages WHERE id = '463'
202 0.0002 0.0001828670501709
SELECT * FROM sideboxes_pages WHERE sidebox_id = '33'
203 0.0003 0.00029802322387695
SELECT * FROM pages WHERE id = '66'
204 0.0002 0.00021100044250488
SELECT * FROM pages WHERE id = '77'
205 0.0002 0.0002131462097168
SELECT * FROM pages WHERE id = '90'
206 0.0002 0.00016498565673828
SELECT * FROM pages WHERE id = '414'
207 0.0002 0.00015902519226074
SELECT * FROM pages WHERE id = '119'
208 0.0002 0.00016617774963379
SELECT * FROM pages WHERE id = '406'
209 0.0002 0.00015997886657715
SELECT * FROM pages WHERE id = '149'
210 0.0002 0.00017023086547852
SELECT * FROM pages WHERE id = '150'
211 0.0002 0.00015902519226074
SELECT * FROM pages WHERE id = '412'
212 0.0002 0.00017404556274414
SELECT * FROM pages WHERE id = '162'
213 0.0002 0.00015997886657715
SELECT * FROM pages WHERE id = '164'
214 0.0002 0.00016093254089355
SELECT * FROM pages WHERE id = '167'
215 0.0002 0.00016093254089355
SELECT * FROM pages WHERE id = '180'
216 0.0002 0.0001530647277832
SELECT * FROM pages WHERE id = '187'
217 0.0002 0.00022101402282715
SELECT * FROM pages WHERE id = '265'
218 0.0002 0.00017213821411133
SELECT * FROM pages WHERE id = '268'
219 0.0002 0.00015497207641602
SELECT * FROM pages WHERE id = '411'
220 0.0002 0.00017499923706055
SELECT * FROM pages WHERE id = '290'
221 0.0002 0.0001530647277832
SELECT * FROM pages WHERE id = '413'
222 0.0002 0.00015497207641602
SELECT * FROM pages WHERE id = '409'
223 0.0002 0.00016093254089355
SELECT * FROM pages WHERE id = '327'
224 0.0002 0.00016093254089355
SELECT * FROM pages WHERE id = '336'
225 0.0002 0.00017881393432617
SELECT * FROM pages WHERE id = '351'
226 0.0002 0.00016093254089355
SELECT * FROM pages WHERE id = '358'
227 0.0002 0.00017690658569336
SELECT * FROM pages WHERE id = '360'
228 0.0002 0.00016593933105469
SELECT * FROM pages WHERE id = '362'
229 0.0002 0.00016689300537109
SELECT * FROM pages WHERE id = '366'
230 0.0002 0.00018715858459473
SELECT * FROM pages WHERE id = '370'
231 0.0002 0.00016283988952637
SELECT * FROM pages WHERE id = '377'
232 0.0002 0.00016307830810547
SELECT * FROM pages WHERE id = '386'
233 0.0002 0.00015711784362793
SELECT * FROM pages WHERE id = '408'
234 0.0002 0.00015497207641602
SELECT * FROM pages WHERE id = '415'
235 0.0002 0.00020217895507812
SELECT * FROM pages WHERE id = '416'
236 0.0002 0.00020790100097656
SELECT * FROM pages WHERE id = '419'
237 0.0002 0.00016617774963379
SELECT * FROM pages WHERE id = '423'
238 0.0002 0.00016403198242188
SELECT * FROM pages WHERE id = '427'
239 0.0002 0.0001981258392334
SELECT * FROM pages WHERE id = '428'
240 0.0002 0.00015401840209961
SELECT * FROM pages WHERE id = '432'
241 0.0002 0.00015497207641602
SELECT * FROM pages WHERE id = '433'
242 0.0002 0.00016498565673828
SELECT * FROM pages WHERE id = '436'
243 0.0002 0.00016522407531738
SELECT * FROM pages WHERE id = '437'
244 0.0002 0.00015902519226074
SELECT * FROM pages WHERE id = '461'
245 0.0002 0.0001988410949707
SELECT * FROM pages WHERE id = '464'
246 0.0002 0.00016212463378906
SELECT * FROM sideboxes_pages WHERE sidebox_id = '34'
247 0.0002 0.00016498565673828
SELECT * FROM pages WHERE id = '74'
248 0.0002 0.00015783309936523
SELECT * FROM pages WHERE id = '137'
249 0.0002 0.00016379356384277
SELECT * FROM pages WHERE id = '145'
250 0.0002 0.00016212463378906
SELECT * FROM pages WHERE id = '156'
251 0.0002 0.00016498565673828
SELECT * FROM pages WHERE id = '407'
252 0.0002 0.00015377998352051
SELECT * FROM pages WHERE id = '410'
253 0.0002 0.00020599365234375
SELECT * FROM pages WHERE id = '266'
254 0.0002 0.00024580955505371
SELECT * FROM pages WHERE id = '316'
255 0.0002 0.00016999244689941
SELECT * FROM pages WHERE id = '332'
256 0.0002 0.00019001960754395
SELECT * FROM pages WHERE id = '334'
257 0.0002 0.00015711784362793
SELECT * FROM pages WHERE id = '367'
258 0.0002 0.00016379356384277
SELECT * FROM pages WHERE id = '387'
259 0.0002 0.00017595291137695
SELECT * FROM pages WHERE id = '389'
260 0.0002 0.00017499923706055
SELECT * FROM pages WHERE id = '397'
261 0.0002 0.00017094612121582
SELECT * FROM pages WHERE id = '449'
262 0.0002 0.00017786026000977
SELECT * FROM sideboxes_pages WHERE sidebox_id = '35'
263 0.0002 0.00022697448730469
SELECT * FROM pages WHERE id = '42'
264 0.0002 0.00016593933105469
SELECT * FROM pages WHERE id = '79'
265 0.0002 0.00016999244689941
SELECT * FROM pages WHERE id = '86'
266 0.0002 0.00015711784362793
SELECT * FROM pages WHERE id = '95'
267 0.0002 0.00016307830810547
SELECT * FROM pages WHERE id = '102'
268 0.0002 0.00016307830810547
SELECT * FROM pages WHERE id = '109'
269 0.0002 0.00023984909057617
SELECT * FROM pages WHERE id = '114'
270 0.0002 0.00019502639770508
SELECT * FROM pages WHERE id = '121'
271 0.0002 0.00022792816162109
SELECT * FROM pages WHERE id = '138'
272 0.0002 0.00019693374633789
SELECT * FROM pages WHERE id = '142'
273 0.0002 0.00021195411682129
SELECT * FROM pages WHERE id = '62'
274 0.0002 0.00015997886657715
SELECT * FROM pages WHERE id = '157'
275 0.0002 0.00017309188842773
SELECT * FROM pages WHERE id = '246'
276 0.0002 0.0002140998840332
SELECT * FROM pages WHERE id = '276'
277 0.0002 0.00020599365234375
SELECT * FROM pages WHERE id = '278'
278 0.0002 0.00023102760314941
SELECT * FROM pages WHERE id = '279'
279 0.0002 0.00017404556274414
SELECT * FROM pages WHERE id = '317'
280 0.0002 0.00016283988952637
SELECT * FROM pages WHERE id = '405'
281 0.0002 0.00019407272338867
SELECT * FROM pages WHERE id = '343'
282 0.0002 0.00016403198242188
SELECT * FROM pages WHERE id = '345'
283 0.0002 0.00022196769714355
SELECT * FROM pages WHERE id = '346'
284 0.0002 0.00017595291137695
SELECT * FROM pages WHERE id = '347'
285 0.0002 0.00017213821411133
SELECT * FROM pages WHERE id = '348'
286 0.0002 0.0001671314239502
SELECT * FROM pages WHERE id = '349'
287 0.0002 0.00016188621520996
SELECT * FROM pages WHERE id = '381'
288 0.0002 0.00016212463378906
SELECT * FROM pages WHERE id = '392'
289 0.0002 0.00015902519226074
SELECT * FROM pages WHERE id = '393'
290 0.0002 0.00015783309936523
SELECT * FROM pages WHERE id = '394'
291 0.0002 0.00017499923706055
SELECT * FROM pages WHERE id = '395'
292 0.0002 0.00016999244689941
SELECT * FROM pages WHERE id = '399'
293 0.0002 0.0001671314239502
SELECT * FROM pages WHERE id = '421'
294 0.0002 0.0001530647277832
SELECT * FROM pages WHERE id = '426'
295 0.0002 0.00015377998352051
SELECT * FROM pages WHERE id = '430'
296 0.0002 0.0001680850982666
SELECT * FROM pages WHERE id = '431'
297 0.0002 0.00016689300537109
SELECT * FROM pages WHERE id = '434'
298 0.0002 0.00017619132995605
SELECT * FROM pages WHERE id = '435'
299 0.0002 0.00018119812011719
SELECT * FROM pages WHERE id = '440'
300 0.0002 0.00016880035400391
SELECT * FROM pages WHERE id = '441'
301 0.0002 0.0001680850982666
SELECT * FROM pages WHERE id = '451'
302 0.0002 0.00015401840209961
SELECT * FROM pages WHERE id = '453'
303 0.0002 0.00015592575073242
SELECT * FROM sideboxes_pages WHERE sidebox_id = '37'
304 0.0002 0.00017595291137695
SELECT * FROM pages WHERE id = '146'
305 0.0002 0.00015807151794434
SELECT * FROM pages WHERE id = '158'
306 0.0002 0.00016117095947266
SELECT * FROM pages WHERE id = '163'
307 0.0003 0.00025105476379395
SELECT * FROM pages WHERE id = '293'
308 0.0002 0.00016689300537109
SELECT * FROM pages WHERE id = '340'
309 0.0002 0.00018000602722168
SELECT * FROM pages WHERE id = '417'
310 0.0002 0.00016617774963379
SELECT * FROM sideboxes_pages WHERE sidebox_id = '40'
311 0.0002 0.00018000602722168
SELECT * FROM pages WHERE id = '173'
312 0.0002 0.00016903877258301
SELECT * FROM pages WHERE id = '181'
313 0.0002 0.00015616416931152
SELECT * FROM pages WHERE id = '288'
314 0.0002 0.00021791458129883
SELECT * FROM pages WHERE id = '299'
315 0.0002 0.00020098686218262
SELECT * FROM pages WHERE id = '300'
316 0.0002 0.00017309188842773
SELECT * FROM pages WHERE id = '383'
317 0.0002 0.00015521049499512
SELECT * FROM pages WHERE id = '385'
318 0.0002 0.00018095970153809
SELECT * FROM pages WHERE id = '438'
319 0.0002 0.00018692016601562
SELECT * FROM pages WHERE id = '442'
320 0.0002 0.00015711784362793
SELECT * FROM sideboxes_pages WHERE sidebox_id = '38'
321 0.0003 0.00029206275939941
SELECT * FROM pages WHERE id = '103'
322 0.0002 0.00023007392883301
SELECT * FROM pages WHERE id = '134'
323 0.0002 0.00015997886657715
SELECT * FROM pages WHERE id = '139'
324 0.0002 0.00017595291137695
SELECT * FROM pages WHERE id = '143'
325 0.0002 0.00016999244689941
SELECT * FROM pages WHERE id = '234'
326 0.0002 0.0001680850982666
SELECT * FROM pages WHERE id = '248'
327 0.0002 0.00015807151794434
SELECT * FROM pages WHERE id = '260'
328 0.0002 0.00016498565673828
SELECT * FROM pages WHERE id = '398'
329 0.0002 0.00016999244689941
SELECT * FROM sideboxes_pages WHERE sidebox_id = '29'
330 0.0002 0.00017309188842773
SELECT * FROM pages WHERE id = '61'
331 0.0002 0.00016903877258301
SELECT * FROM pages WHERE id = '87'
332 0.0002 0.00017094612121582
SELECT * FROM pages WHERE id = '104'
333 0.0002 0.00024008750915527
SELECT * FROM pages WHERE id = '115'
334 0.0002 0.00015997886657715
SELECT * FROM pages WHERE id = '124'
335 0.0002 0.0001680850982666
SELECT * FROM pages WHERE id = '144'
336 0.0002 0.00018501281738281
SELECT * FROM pages WHERE id = '151'
337 0.0002 0.00015401840209961
SELECT * FROM pages WHERE id = '199'
338 0.0002 0.00017809867858887
SELECT * FROM pages WHERE id = '200'
339 0.0002 0.00016403198242188
SELECT * FROM pages WHERE id = '304'
340 0.0002 0.0001521110534668
SELECT * FROM pages WHERE id = '321'
341 0.0002 0.00015401840209961
SELECT * FROM pages WHERE id = '333'
342 0.0002 0.00017905235290527
SELECT * FROM pages WHERE id = '350'
343 0.0002 0.00016498565673828
SELECT * FROM pages WHERE id = '378'
344 0.0002 0.00015902519226074
SELECT * FROM pages WHERE id = '422'
345 0.0002 0.00018906593322754
SELECT * FROM pages WHERE id = '425'
346 0.0002 0.00015687942504883
SELECT * FROM pages WHERE id = '443'
347 0.0002 0.00015687942504883
SELECT * FROM pages WHERE id = '444'
348 0.0002 0.00016617774963379
SELECT * FROM pages WHERE id = '445'
349 0.0002 0.00016498565673828
SELECT * FROM pages WHERE id = '446'
350 0.0002 0.00015592575073242
SELECT * FROM pages WHERE id = '447'
351 0.0002 0.00015997886657715
SELECT * FROM pages WHERE id = '448'
352 0.0002 0.00015878677368164
SELECT * FROM pages WHERE id = '455'
353 0.0002 0.00017714500427246
SELECT * FROM pages WHERE id = '456'
354 0.0002 0.0001530647277832
SELECT * FROM pages WHERE id = '459'
355 0.0002 0.00017189979553223
SELECT * FROM pages WHERE id = '460'
356 0.0002 0.00015997886657715
SELECT * FROM pages WHERE id = '462'
357 0.0002 0.00015807151794434
SELECT * FROM sideboxes_pages WHERE sidebox_id = '32'
358 0.0002 0.00019598007202148
SELECT * FROM pages WHERE id = '153'
359 0.0002 0.00021982192993164
SELECT * FROM pages WHERE id = '182'
360 0.0002 0.00016403198242188
SELECT * FROM pages WHERE id = '238'
361 0.0002 0.00015521049499512
SELECT * FROM pages WHERE id = '240'
362 0.0001 0.00014996528625488
SELECT * FROM pages WHERE id = '242'
363 0.0002 0.00016117095947266
SELECT * FROM pages WHERE id = '252'
364 0.0001 0.00014996528625488
SELECT * FROM pages WHERE id = '253'
365 0.0002 0.0001518726348877
SELECT * FROM pages WHERE id = '262'
366 0.0001 0.00014996528625488
SELECT * FROM pages WHERE id = '267'
367 0.0002 0.00015807151794434
SELECT * FROM pages WHERE id = '420'
368 0.0002 0.00016593933105469
SELECT value FROM parameters WHERE parameter = 'GOOGLE_SITE_KEY' 
369 0.0001 0.00013208389282227
SELECT value FROM parameters WHERE parameter = 'GOOGLE_SECRET_KEY' 
370 0.0001 0.00013113021850586
SELECT value FROM parameters WHERE parameter = 'GOOGLE_RECAPTCHA_TYPE' 
371 0.0015 0.0014998912811279
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
372 0.0002 0.00018191337585449
SELECT value FROM parameters WHERE parameter = 'GOOGLE_SITE_KEY' 
373 0.0001 0.00013399124145508
SELECT value FROM parameters WHERE parameter = 'GOOGLE_SECRET_KEY' 
374 0.0001 0.00013017654418945
SELECT value FROM parameters WHERE parameter = 'GOOGLE_RECAPTCHA_TYPE' 
375 0.0003 0.00029706954956055
SELECT * FROM products WHERE pagename = 'streamlight-44931-the-siege-lantern'
376 0.0002 0.00021600723266602
SELECT * FROM manufacturers WHERE id = '571'
377 0.0003 0.00027608871459961
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '571'
378 0.0001 0.00012993812561035
SELECT filename FROM manufacturerimages WHERE manufacturer_id = '571' LIMIT 1
379 0.0002 0.00023388862609863
SELECT pagename, id FROM products p WHERE manufacturer_id = '571' ORDER BY RAND() LIMIT 1
380 0.0167 0.016653060913086
SELECT * FROM productimages WHERE product_id = '408406' ORDER BY sortorder ASC
381 0.0003 0.0003058910369873
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '571'
382 0.0003 0.00028300285339355
SELECT COUNT(DISTINCT(p.id)) FROM products p
				WHERE p.manufacturer_id = '571'
				  AND p.hidden = 0
				  AND p.enabled = 1
				  AND p.parent_id = 0 
383 0.0001 0.00012993812561035
SELECT * FROM manufacturerimages WHERE manufacturer_id = '571'
384 0.0001 0.00014901161193848
SELECT category_id FROM products_categories WHERE product_id = '408406'
385 0.0003 0.00025296211242676
SELECT * FROM categories WHERE id = '51'
386 0.0014 0.0014128684997559
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
387 0.0001 0.00012397766113281
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 51
388 0.0003 0.00027680397033691
SELECT id FROM categories WHERE parent_id = '51'
389 0.0002 0.00022602081298828
SELECT id FROM categories WHERE parent_id = '101'
390 0.0021 0.0020999908447266
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 
391 0.0002 0.00017189979553223
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 
392 0.0002 0.0001671314239502
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (101,51)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
393 0.0002 0.00018596649169922
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '51'
394 0.0002 0.0002129077911377
SELECT * FROM productimages WHERE product_id = '408406' ORDER BY sortorder ASC
395 0.0002 0.00023889541625977
SELECT * FROM product_image_select WHERE product_id = '408406'
396 0.0001 0.00013518333435059
SELECT * FROM productcustomimages WHERE product_id = '408406'
397 0.0001 0.00012397766113281
SELECT * FROM productfeeds WHERE product_id = '408406' ORDER BY item_date DESC
398 0.0004 0.00044798851013184
SELECT a.name, n.displayname, a.value, n.units, n.valuetype FROM productattributes a, productattributenames n WHERE product_id = '408406' AND a.name = n.originalname AND n.display = 1 AND n.hidden = 0
399 0.0337 0.033704042434692
SELECT DISTINCT(pt.tag_id) FROM product_tags pt, tags t WHERE pt.tag_id = t.id AND pt.product_id = '408406' AND t.hidden = 0 AND display_product = 1
400 0.0062 0.0061578750610352
SELECT * FROM productamazoncontent WHERE product_id = '408406'
401 0.0006 0.00063896179199219
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '408406' AND a.name = n.originalname
402 0.0002 0.00019192695617676
SELECT * FROM productoffers WHERE product_id = '408406' AND merchantid = 'ATVPDKIKX0DER'
403 0.0002 0.00021004676818848
SELECT * FROM productoffers
                WHERE product_id = '408406' AND price > 0
                ORDER BY price ASC LIMIT 1
404 0.0002 0.00018715858459473
SELECT * FROM productoffers
                WHERE product_id = 408406
                ORDER BY price ASC LIMIT 1
405 0.0003 0.00029802322387695
SELECT value FROM productattributes
                WHERE product_id = '408406'
                AND name = 'ListPriceAmount'
406 0.0004 0.0004429817199707
SELECT value FROM productattributes WHERE product_id = '408406' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
407 0.2355 0.23549699783325
SELECT *, MATCH (description, keyfeatures, title) AGAINST ('streamlight' IN BOOLEAN MODE) AS `searchrelevance` FROM products WHERE MATCH (description, keyfeatures, title) AGAINST ('streamlight' IN BOOLEAN MODE) AND 408406 <> 0 AND enabled = 1 AND hidden = 0 AND offers > 0 AND parent_id = 0 ORDER BY `searchrelevance` LIMIT 6
408 0.0004 0.0003509521484375
SELECT * FROM productimages WHERE product_id = '407540' ORDER BY sortorder ASC
409 0.0002 0.00023913383483887
SELECT * FROM product_image_select WHERE product_id = '407540'
410 0.0001 0.0001370906829834
SELECT * FROM productcustomimages WHERE product_id = '407540'
411 0.0028 0.0028469562530518
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '407540' AND a.name = n.originalname
412 0.0002 0.00020599365234375
SELECT * FROM productoffers WHERE product_id = '407540' AND merchantid = 'ATVPDKIKX0DER'
413 0.0002 0.00023007392883301
SELECT * FROM productoffers
                WHERE product_id = '407540' AND price > 0
                ORDER BY price ASC LIMIT 1
414 0.0004 0.00040888786315918
SELECT value FROM productattributes WHERE product_id = '407540' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
415 0.0002 0.0001521110534668
UPDATE products SET price = '31620' WHERE id = '407540'
416 0.0002 0.00024294853210449
SELECT * FROM productimages WHERE product_id = '407566' ORDER BY sortorder ASC
417 0.0002 0.00022411346435547
SELECT * FROM product_image_select WHERE product_id = '407566'
418 0.0001 0.0001370906829834
SELECT * FROM productcustomimages WHERE product_id = '407566'
419 0.0031 0.0030801296234131
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '407566' AND a.name = n.originalname
420 0.0002 0.00019001960754395
SELECT * FROM productoffers WHERE product_id = '407566' AND merchantid = 'ATVPDKIKX0DER'
421 0.0002 0.00021100044250488
SELECT * FROM productoffers
                WHERE product_id = '407566' AND price > 0
                ORDER BY price ASC LIMIT 1
422 0.0004 0.00043988227844238
SELECT value FROM productattributes WHERE product_id = '407566' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
423 0.0001 0.00013017654418945
UPDATE products SET price = '11400' WHERE id = '407566'
424 0.0002 0.00016212463378906
SELECT * FROM productimages WHERE product_id = '415056' ORDER BY sortorder ASC
425 0.0003 0.00032877922058105
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '415056' AND p.id = pi.product_id ORDER BY pi.sortorder
426 0.0002 0.00024199485778809
SELECT * FROM product_image_select WHERE product_id = '415056'
427 0.0001 0.0001368522644043
SELECT * FROM productcustomimages WHERE product_id = '415056'
428 0.0003 0.0002591609954834
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 = '415056'
                GROUP BY o.product_id
429 0.0003 0.00027203559875488
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     = '415056'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
430 0.0002 0.00022506713867188
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 415056
431 0.0005 0.00050592422485352
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '415056' AND a.name = n.originalname
432 0.0002 0.00018000602722168
SELECT * FROM productoffers WHERE product_id = '415056' AND merchantid = 'ATVPDKIKX0DER'
433 0.0002 0.00019001960754395
SELECT * FROM productoffers
                WHERE product_id = '415056' AND price > 0
                ORDER BY price ASC LIMIT 1
434 0.0002 0.00018692016601562
SELECT * FROM productoffers
                WHERE product_id = 415056
                ORDER BY price ASC LIMIT 1
435 0.0003 0.00027585029602051
SELECT value FROM productattributes
                WHERE product_id = '415056'
                AND name = 'ListPriceAmount'
436 0.0003 0.00025010108947754
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 = '415056'
                GROUP BY o.product_id
437 0.0003 0.00025701522827148
SELECT  n.displayname, o.name
                FROM    productoptionnames  n,
                        productoptions      o,
                        products            p
                WHERE   n.originalname  = o.name
                  AND   o.product_id    = p.id
                  AND   p.parent_id     = '415056'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
438 0.0002 0.00020599365234375
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 415056
439 0.0004 0.00040602684020996
SELECT value FROM productattributes WHERE product_id = '415056' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
440 0.0001 0.00014781951904297
UPDATE products SET price = '5039' WHERE id = '415056'
441 0.0003 0.00025510787963867
SELECT * FROM products WHERE parent_id = '415056'
442 0.0242 0.024200916290283
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '406125' AND a.name = n.originalname
443 0.0003 0.00030517578125
SELECT * FROM productoffers WHERE product_id = '406125' AND merchantid = 'ATVPDKIKX0DER'
444 0.0002 0.00022482872009277
SELECT * FROM productoffers
                WHERE product_id = '406125' AND price > 0
                ORDER BY price ASC LIMIT 1
445 0.2448 0.24482893943787
SELECT *, MATCH (description, keyfeatures, title) AGAINST ('44931 the siege' IN BOOLEAN MODE) AS `searchrelevance` FROM products WHERE MATCH (description, keyfeatures, title) AGAINST ('44931 the siege' IN BOOLEAN MODE) AND 408406 <> 0 AND enabled = 1 AND hidden = 0 AND offers > 0 AND parent_id = 0 ORDER BY `searchrelevance` LIMIT 3
446 0.2423 0.24232196807861
SELECT *, MATCH (description, keyfeatures, title) AGAINST ('siege lantern' IN BOOLEAN MODE) AS `searchrelevance` FROM products WHERE MATCH (description, keyfeatures, title) AGAINST ('siege lantern' IN BOOLEAN MODE) AND 408406 <> 0 AND enabled = 1 AND hidden = 0 AND offers > 0 AND parent_id = 0 ORDER BY `searchrelevance` LIMIT 3
447 0.3043 0.30428695678711
SELECT *, MATCH (description, keyfeatures, title) AGAINST ('combat' IN BOOLEAN MODE) AS `searchrelevance` FROM products WHERE MATCH (description, keyfeatures, title) AGAINST ('combat' IN BOOLEAN MODE) AND 408406 <> 0 AND enabled = 1 AND hidden = 0 AND offers > 0 AND parent_id = 0 ORDER BY `searchrelevance` LIMIT 3
448 0.0003 0.00033092498779297
SELECT * FROM productimages WHERE product_id = '406132' ORDER BY sortorder ASC
449 0.0002 0.00023102760314941
SELECT * FROM product_image_select WHERE product_id = '406132'
450 0.0001 0.00012397766113281
SELECT * FROM productcustomimages WHERE product_id = '406132'
451 0.0026 0.0026228427886963
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '406132' AND a.name = n.originalname
452 0.0002 0.0001988410949707
SELECT * FROM productoffers WHERE product_id = '406132' AND merchantid = 'ATVPDKIKX0DER'
453 0.0002 0.00021219253540039
SELECT * FROM productoffers
                WHERE product_id = '406132' AND price > 0
                ORDER BY price ASC LIMIT 1
454 0.0004 0.00042486190795898
SELECT value FROM productattributes WHERE product_id = '406132' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
455 0.0001 0.00014495849609375
UPDATE products SET price = '1598' WHERE id = '406132'
456 0.0004 0.00036907196044922
SELECT * FROM productimages WHERE product_id = '129319' ORDER BY sortorder ASC
457 0.0002 0.00021195411682129
SELECT * FROM product_image_select WHERE product_id = '129319'
458 0.0001 0.00011992454528809
SELECT * FROM productcustomimages WHERE product_id = '129319'
459 0.0021 0.0020639896392822
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '129319' AND a.name = n.originalname
460 0.0002 0.00018715858459473
SELECT * FROM productoffers WHERE product_id = '129319' AND merchantid = 'ATVPDKIKX0DER'
461 0.0002 0.00020003318786621
SELECT * FROM productoffers
                WHERE product_id = '129319' AND price > 0
                ORDER BY price ASC LIMIT 1
462 0.0003 0.00034284591674805
SELECT value FROM productattributes WHERE product_id = '129319' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
463 0.0001 0.0001378059387207
UPDATE products SET price = '4796' WHERE id = '129319'
464 0.0003 0.00025510787963867
SELECT * FROM productimages WHERE product_id = '137032' ORDER BY sortorder ASC
465 0.0002 0.00020503997802734
SELECT * FROM product_image_select WHERE product_id = '137032'
466 0.0001 0.00011801719665527
SELECT * FROM productcustomimages WHERE product_id = '137032'
467 0.0039 0.0038599967956543
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '137032' AND a.name = n.originalname
468 0.0002 0.00018811225891113
SELECT * FROM productoffers WHERE product_id = '137032' AND merchantid = 'ATVPDKIKX0DER'
469 0.0002 0.00021815299987793
SELECT * FROM productoffers
                WHERE product_id = '137032' AND price > 0
                ORDER BY price ASC LIMIT 1
470 0.0004 0.00043487548828125
SELECT value FROM productattributes WHERE product_id = '137032' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
471 0.0001 0.00012302398681641
UPDATE products SET price = '3995' WHERE id = '137032'
472 0.0002 0.00015377998352051
SELECT value FROM parameters WHERE parameter = 'EBAY_CACHE_TIME' 
473 0.0001 0.00012588500976562
SELECT value FROM parameters WHERE parameter = 'EBAY_APP_ID' 
474 0.0001 0.00012302398681641
SELECT value FROM parameters WHERE parameter = 'EBAY_TRACKING_ID' 
475 0.0001 0.00012302398681641
SELECT value FROM parameters WHERE parameter = 'EBAY_NETWORK_ID' 
476 0.0001 0.00011897087097168
SELECT value FROM parameters WHERE parameter = 'EBAY_LOCALE' 
477 0.0001 0.00011610984802246
SELECT value FROM parameters WHERE parameter = 'EBAY_AUTH_TOKEN' 
478 0.0001 0.00013208389282227
SELECT * FROM ebay_locale_details WHERE cur_code = 'USD' 
479 0.2007 0.2007110118866
SELECT * FROM ebay_products_cache WHERE cachekey = 'bbc9b22aec750e60137e9b05407f2301' 
480 0.0003 0.00025296211242676
SELECT value FROM parameters WHERE parameter = 'EBAY_APP_ID' 
481 0.0001 0.00013399124145508
SELECT value FROM parameters WHERE parameter = 'EBAY_TRACKING_ID' 
482 0.0001 0.0001220703125
SELECT value FROM parameters WHERE parameter = 'EBAY_NETWORK_ID' 
483 0.0001 0.00012087821960449
SELECT value FROM parameters WHERE parameter = 'EBAY_LOCALE' 
484 0.0001 0.00012707710266113
SELECT value FROM parameters WHERE parameter = 'EBAY_AUTH_TOKEN' 
485 0.1998 0.19984698295593
SELECT * FROM ebay_products_cache WHERE cachekey = 'bbc9b22aec750e60137e9b05407f2301' 
486 0.0003 0.00033402442932129
SELECT id,asin FROM products WHERE parent_id = 408406
487 0.0002 0.00020194053649902
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 408407
488 0.0200 0.020049810409546
SELECT name,value FROM productoptions WHERE name="Color" AND product_id = 408407
489 0.0002 0.00021791458129883
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 408408
490 0.0003 0.00026297569274902
SELECT name,value FROM productoptions WHERE name="Color" AND product_id = 408408
491 0.0002 0.00016999244689941
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 408409
492 0.0002 0.00023198127746582
SELECT name,value FROM productoptions WHERE name="Color" AND product_id = 408409
493 0.0002 0.00017786026000977
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 408410
494 0.0002 0.00023889541625977
SELECT name,value FROM productoptions WHERE name="Color" AND product_id = 408410
495 0.0002 0.0001518726348877
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 408411
496 0.0002 0.00023198127746582
SELECT name,value FROM productoptions WHERE name="Color" AND product_id = 408411
497 0.0002 0.0001530647277832
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 408412
498 0.0002 0.00023007392883301
SELECT name,value FROM productoptions WHERE name="Color" AND product_id = 408412
499 0.0003 0.00032806396484375
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '408406' ORDER BY timestamp DESC
500 0.0001 0.00013899803161621
SELECT category_id FROM products_categories WHERE product_id = '408406'
501 0.0002 0.00023913383483887
SELECT * FROM categories WHERE id = '51'
502 0.0013 0.0012800693511963
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
503 0.0001 0.00012707710266113
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 51
504 0.0002 0.00024986267089844
SELECT id FROM categories WHERE parent_id = '51'
505 0.0002 0.00020599365234375
SELECT id FROM categories WHERE parent_id = '101'
506 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 (101,51)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
507 0.0002 0.00015020370483398
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (101,51)
				  AND p.disabled = 0 
508 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 (101,51)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
509 0.0002 0.00016903877258301
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '51'
510 0.0006 0.00056099891662598
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '408406' AND a.name = n.originalname
511 0.0002 0.00017595291137695
SELECT * FROM productoffers WHERE product_id = '408406' AND merchantid = 'ATVPDKIKX0DER'
512 0.0002 0.00018191337585449
SELECT * FROM productoffers
                WHERE product_id = '408406' AND price > 0
                ORDER BY price ASC LIMIT 1
513 0.0002 0.00016689300537109
SELECT * FROM productoffers
                WHERE product_id = 408406
                ORDER BY price ASC LIMIT 1
514 0.0003 0.00027203559875488
SELECT value FROM productattributes
                WHERE product_id = '408406'
                AND name = 'ListPriceAmount'
515 0.0002 0.0001990795135498
SELECT * FROM products WHERE id = '408406'
516 0.0004 0.00043487548828125
SELECT value FROM productattributes WHERE product_id = '408406' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
517 0.0005 0.00053000450134277
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '408406' AND a.name = n.originalname
518 0.0002 0.00017023086547852
SELECT * FROM productoffers WHERE product_id = '408406' AND merchantid = 'ATVPDKIKX0DER'
519 0.0002 0.00018405914306641
SELECT * FROM productoffers
                WHERE product_id = '408406' AND price > 0
                ORDER BY price ASC LIMIT 1
520 0.0002 0.00015711784362793
SELECT * FROM productoffers
                WHERE product_id = 408406
                ORDER BY price ASC LIMIT 1
521 0.0003 0.00026607513427734
SELECT value FROM productattributes
                WHERE product_id = '408406'
                AND name = 'ListPriceAmount'
522 0.0001 0.00012898445129395
SELECT category_id FROM products_categories WHERE product_id = '408406'
523 0.0001 0.00011992454528809
SELECT parent_id FROM categories WHERE id = '51'
524 0.0002 0.00020694732666016
SELECT * FROM categories WHERE id = '51'
525 0.0012 0.0011560916900635
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
526 0.0001 0.00011396408081055
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 51
527 0.0002 0.00023198127746582
SELECT id FROM categories WHERE parent_id = '51'
528 0.0002 0.00020599365234375
SELECT id FROM categories WHERE parent_id = '101'
529 0.0018 0.0018191337585449
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 
530 0.0001 0.00014805793762207
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 
531 0.0002 0.0001530647277832
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (101,51)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
532 0.0002 0.00017404556274414
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '51'
533 0.0002 0.00016903877258301
SELECT * FROM template_info WHERE templateuid = 'fsb-fluid'
534 0.0002 0.00015401840209961
SELECT * FROM pages WHERE id = 2
535 0.0001 0.00013995170593262
SELECT * FROM pages WHERE id = 4
536 0.0001 0.00013113021850586
SELECT * FROM pages WHERE id = 12
537 0.0001 0.00013399124145508
SELECT * FROM pages WHERE id = 10
538 0.0001 0.00013089179992676
SELECT * FROM pages WHERE id = 7
539 0.0001 0.0001370906829834
SELECT * FROM pages WHERE id = 18
540 0.0001 0.0001370906829834
SELECT * FROM pages WHERE id = 28
541 0.0002 0.00015091896057129
SELECT * FROM pages WHERE id = 13
542 0.0001 0.00013089179992676
SELECT * FROM pages WHERE id = 3
543 0.0314 0.031392097473145
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
544 0.0002 0.00023508071899414
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:1561491282;s:8:\"products\";a:6:{i:3;s:6:\"185812\";i:5;s:6:\"415016\";i:16;s:6:\"402907\";i:19;s:6:\"414989\";i:21;s:6:\"383185\";i:4;s:6:\"412927\";}}' WHERE id = '175'
545 0.0005 0.00045490264892578
SELECT * FROM products WHERE id IN (185812,415016,402907,414989,383185,412927) ORDER BY FIELD(id, 185812,415016,402907,414989,383185,412927 )
546 0.0007 0.00068187713623047
SELECT * FROM productimages WHERE product_id = '185812' ORDER BY sortorder ASC
547 0.0002 0.00021982192993164
SELECT * FROM product_image_select WHERE product_id = '185812'
548 0.0001 0.00012516975402832
SELECT * FROM productcustomimages WHERE product_id = '185812'
549 0.0021 0.0021131038665771
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '185812' AND a.name = n.originalname
550 0.0002 0.00018310546875
SELECT * FROM productoffers WHERE product_id = '185812' AND merchantid = 'ATVPDKIKX0DER'
551 0.0002 0.00022196769714355
SELECT * FROM productoffers
                WHERE product_id = '185812' AND price > 0
                ORDER BY price ASC LIMIT 1
552 0.0004 0.0003960132598877
SELECT value FROM productattributes WHERE product_id = '185812' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
553 0.0001 0.00012707710266113
UPDATE products SET price = '314900' WHERE id = '185812'
554 0.0002 0.00019502639770508
SELECT * FROM productimages WHERE product_id = '415016' ORDER BY sortorder ASC
555 0.0002 0.00020098686218262
SELECT * FROM product_image_select WHERE product_id = '415016'
556 0.0001 0.00011920928955078
SELECT * FROM productcustomimages WHERE product_id = '415016'
557 0.0028 0.0027937889099121
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '415016' AND a.name = n.originalname
558 0.0002 0.00017905235290527
SELECT * FROM productoffers WHERE product_id = '415016' AND merchantid = 'ATVPDKIKX0DER'
559 0.0002 0.00020194053649902
SELECT * FROM productoffers
                WHERE product_id = '415016' AND price > 0
                ORDER BY price ASC LIMIT 1
560 0.0004 0.00037312507629395
SELECT value FROM productattributes WHERE product_id = '415016' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
561 0.0001 0.00011897087097168
UPDATE products SET price = '8899' WHERE id = '415016'
562 0.0002 0.00021195411682129
SELECT * FROM productimages WHERE product_id = '402907' ORDER BY sortorder ASC
563 0.0002 0.0002140998840332
SELECT * FROM product_image_select WHERE product_id = '402907'
564 0.0001 0.00011897087097168
SELECT * FROM productcustomimages WHERE product_id = '402907'
565 0.0030 0.0030109882354736
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '402907' AND a.name = n.originalname
566 0.0002 0.00017786026000977
SELECT * FROM productoffers WHERE product_id = '402907' AND merchantid = 'ATVPDKIKX0DER'
567 0.0002 0.00019097328186035
SELECT * FROM productoffers
                WHERE product_id = '402907' AND price > 0
                ORDER BY price ASC LIMIT 1
568 0.0004 0.00035500526428223
SELECT value FROM productattributes WHERE product_id = '402907' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
569 0.0002 0.0002131462097168
UPDATE products SET price = '9400' WHERE id = '402907'
570 0.0002 0.00018501281738281
SELECT * FROM productimages WHERE product_id = '414989' ORDER BY sortorder ASC
571 0.0002 0.00020790100097656
SELECT * FROM product_image_select WHERE product_id = '414989'
572 0.0001 0.00011801719665527
SELECT * FROM productcustomimages WHERE product_id = '414989'
573 0.0026 0.0025789737701416
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '414989' AND a.name = n.originalname
574 0.0002 0.00018119812011719
SELECT * FROM productoffers WHERE product_id = '414989' AND merchantid = 'ATVPDKIKX0DER'
575 0.0002 0.00019407272338867
SELECT * FROM productoffers
                WHERE product_id = '414989' AND price > 0
                ORDER BY price ASC LIMIT 1
576 0.0004 0.00039005279541016
SELECT value FROM productattributes WHERE product_id = '414989' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
577 0.0001 0.00011992454528809
UPDATE products SET price = '49900' WHERE id = '414989'
578 0.0002 0.00022006034851074
SELECT * FROM productimages WHERE product_id = '383185' ORDER BY sortorder ASC
579 0.0002 0.00020289421081543
SELECT * FROM product_image_select WHERE product_id = '383185'
580 0.0001 0.00012898445129395
SELECT * FROM productcustomimages WHERE product_id = '383185'
581 0.0028 0.0028440952301025
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '383185' AND a.name = n.originalname
582 0.0002 0.00017905235290527
SELECT * FROM productoffers WHERE product_id = '383185' AND merchantid = 'ATVPDKIKX0DER'
583 0.0002 0.00019097328186035
SELECT * FROM productoffers
                WHERE product_id = '383185' AND price > 0
                ORDER BY price ASC LIMIT 1
584 0.0004 0.00042200088500977
SELECT value FROM productattributes WHERE product_id = '383185' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
585 0.0001 0.00013017654418945
UPDATE products SET price = '11900' WHERE id = '383185'
586 0.0003 0.0002601146697998
SELECT * FROM productimages WHERE product_id = '412927' ORDER BY sortorder ASC
587 0.0002 0.00020599365234375
SELECT * FROM product_image_select WHERE product_id = '412927'
588 0.0001 0.00011682510375977
SELECT * FROM productcustomimages WHERE product_id = '412927'
589 0.0037 0.0036840438842773
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '412927' AND a.name = n.originalname
590 0.0002 0.00018191337585449
SELECT * FROM productoffers WHERE product_id = '412927' AND merchantid = 'ATVPDKIKX0DER'
591 0.0002 0.00019311904907227
SELECT * FROM productoffers
                WHERE product_id = '412927' AND price > 0
                ORDER BY price ASC LIMIT 1
592 0.0005 0.00046014785766602
SELECT value FROM productattributes WHERE product_id = '412927' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
593 0.0001 0.00011897087097168
UPDATE products SET price = '199900' WHERE id = '412927'
594 0.0316 0.031589984893799
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
595 0.0002 0.00020194053649902
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:1561491282;s:8:\"products\";a:6:{i:2;s:6:\"171938\";i:5;s:6:\"415016\";i:10;s:6:\"406758\";i:14;s:6:\"404868\";i:17;s:6:\"232841\";i:18;s:6:\"402141\";}}' WHERE id = '177'
596 0.0004 0.00042891502380371
SELECT * FROM products WHERE id IN (171938,415016,406758,404868,232841,402141) ORDER BY FIELD(id, 171938,415016,406758,404868,232841,402141 )
597 0.0006 0.00062990188598633
SELECT * FROM productimages WHERE product_id = '171938' ORDER BY sortorder ASC
598 0.0002 0.00022101402282715
SELECT * FROM product_image_select WHERE product_id = '171938'
599 0.0001 0.00013184547424316
SELECT * FROM productcustomimages WHERE product_id = '171938'
600 0.0026 0.0025620460510254
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '171938' AND a.name = n.originalname
601 0.0002 0.00018000602722168
SELECT * FROM productoffers WHERE product_id = '171938' AND merchantid = 'ATVPDKIKX0DER'
602 0.0002 0.00021004676818848
SELECT * FROM productoffers
                WHERE product_id = '171938' AND price > 0
                ORDER BY price ASC LIMIT 1
603 0.0004 0.00038695335388184
SELECT value FROM productattributes WHERE product_id = '171938' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
604 0.0001 0.00011706352233887
UPDATE products SET price = '388900' WHERE id = '171938'
605 0.0002 0.0001990795135498
SELECT * FROM productimages WHERE product_id = '415016' ORDER BY sortorder ASC
606 0.0002 0.0002131462097168
SELECT * FROM product_image_select WHERE product_id = '415016'
607 0.0001 0.00011777877807617
SELECT * FROM productcustomimages WHERE product_id = '415016'
608 0.0028 0.0027890205383301
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '415016' AND a.name = n.originalname
609 0.0002 0.00017881393432617
SELECT * FROM productoffers WHERE product_id = '415016' AND merchantid = 'ATVPDKIKX0DER'
610 0.0002 0.00019407272338867
SELECT * FROM productoffers
                WHERE product_id = '415016' AND price > 0
                ORDER BY price ASC LIMIT 1
611 0.0004 0.00037407875061035
SELECT value FROM productattributes WHERE product_id = '415016' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
612 0.0001 0.00012898445129395
UPDATE products SET price = '8899' WHERE id = '415016'
613 0.0002 0.00018811225891113
SELECT * FROM productimages WHERE product_id = '406758' ORDER BY sortorder ASC
614 0.0002 0.00021100044250488
SELECT * FROM product_image_select WHERE product_id = '406758'
615 0.0001 0.00011801719665527
SELECT * FROM productcustomimages WHERE product_id = '406758'
616 0.0027 0.0026500225067139
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '406758' AND a.name = n.originalname
617 0.0002 0.00017809867858887
SELECT * FROM productoffers WHERE product_id = '406758' AND merchantid = 'ATVPDKIKX0DER'
618 0.0002 0.00019311904907227
SELECT * FROM productoffers
                WHERE product_id = '406758' AND price > 0
                ORDER BY price ASC LIMIT 1
619 0.0004 0.00040507316589355
SELECT value FROM productattributes WHERE product_id = '406758' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
620 0.0001 0.00011491775512695
UPDATE products SET price = '2694' WHERE id = '406758'
621 0.0003 0.0002899169921875
SELECT * FROM productimages WHERE product_id = '404868' ORDER BY sortorder ASC
622 0.0002 0.00020599365234375
SELECT * FROM product_image_select WHERE product_id = '404868'
623 0.0001 0.00012803077697754
SELECT * FROM productcustomimages WHERE product_id = '404868'
624 0.0030 0.0029969215393066
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '404868' AND a.name = n.originalname
625 0.0002 0.00018000602722168
SELECT * FROM productoffers WHERE product_id = '404868' AND merchantid = 'ATVPDKIKX0DER'
626 0.0002 0.00019097328186035
SELECT * FROM productoffers
                WHERE product_id = '404868' AND price > 0
                ORDER BY price ASC LIMIT 1
627 0.0004 0.00041294097900391
SELECT value FROM productattributes WHERE product_id = '404868' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
628 0.0001 0.00011801719665527
UPDATE products SET price = '44899' WHERE id = '404868'
629 0.0004 0.00040507316589355
SELECT * FROM productimages WHERE product_id = '232841' ORDER BY sortorder ASC
630 0.0002 0.00021195411682129
SELECT * FROM product_image_select WHERE product_id = '232841'
631 0.0001 0.00011801719665527
SELECT * FROM productcustomimages WHERE product_id = '232841'
632 0.0028 0.0027790069580078
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '232841' AND a.name = n.originalname
633 0.0002 0.00019478797912598
SELECT * FROM productoffers WHERE product_id = '232841' AND merchantid = 'ATVPDKIKX0DER'
634 0.0002 0.00019311904907227
SELECT * FROM productoffers
                WHERE product_id = '232841' AND price > 0
                ORDER BY price ASC LIMIT 1
635 0.0004 0.00039100646972656
SELECT value FROM productattributes WHERE product_id = '232841' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
636 0.0001 0.00011610984802246
UPDATE products SET price = '20662' WHERE id = '232841'
637 0.0003 0.00030899047851562
SELECT * FROM productimages WHERE product_id = '402141' ORDER BY sortorder ASC
638 0.0002 0.00020503997802734
SELECT * FROM product_image_select WHERE product_id = '402141'
639 0.0001 0.00011706352233887
SELECT * FROM productcustomimages WHERE product_id = '402141'
640 0.0029 0.0029201507568359
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '402141' AND a.name = n.originalname
641 0.0002 0.00018596649169922
SELECT * FROM productoffers WHERE product_id = '402141' AND merchantid = 'ATVPDKIKX0DER'
642 0.0002 0.00020503997802734
SELECT * FROM productoffers
                WHERE product_id = '402141' AND price > 0
                ORDER BY price ASC LIMIT 1
643 0.0004 0.00040006637573242
SELECT value FROM productattributes WHERE product_id = '402141' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
644 0.0001 0.00011706352233887
UPDATE products SET price = '17900' WHERE id = '402141'
645 0.0802 0.080155849456787
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
646 0.0003 0.00029683113098145
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:1561491282;s:8:\"products\";a:6:{i:6;s:6:\"408792\";i:8;s:6:\"103845\";i:9;s:6:\"247027\";i:21;s:6:\"383185\";i:0;s:6:\"414940\";i:2;s:6:\"171938\";}}' WHERE id = '181'
647 0.0005 0.0004570484161377
SELECT * FROM products WHERE id IN (408792,103845,247027,383185,414940,171938) ORDER BY FIELD(id, 408792,103845,247027,383185,414940,171938 )
648 0.0002 0.0002129077911377
SELECT * FROM productimages WHERE product_id = '408792' ORDER BY sortorder ASC
649 0.0002 0.00021886825561523
SELECT * FROM product_image_select WHERE product_id = '408792'
650 0.0001 0.0001220703125
SELECT * FROM productcustomimages WHERE product_id = '408792'
651 0.0040 0.0039939880371094
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '408792' AND a.name = n.originalname
652 0.0003 0.0002601146697998
SELECT * FROM productoffers WHERE product_id = '408792' AND merchantid = 'ATVPDKIKX0DER'
653 0.0002 0.00022387504577637
SELECT * FROM productoffers
                WHERE product_id = '408792' AND price > 0
                ORDER BY price ASC LIMIT 1
654 0.0005 0.00046086311340332
SELECT value FROM productattributes WHERE product_id = '408792' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
655 0.0001 0.00012707710266113
UPDATE products SET price = '13499' WHERE id = '408792'
656 0.0002 0.0001978874206543
SELECT * FROM productimages WHERE product_id = '103845' ORDER BY sortorder ASC
657 0.0002 0.00024294853210449
SELECT * FROM product_image_select WHERE product_id = '103845'
658 0.0001 0.00014185905456543
SELECT * FROM productcustomimages WHERE product_id = '103845'
659 0.0268 0.026776075363159
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '103845' AND a.name = n.originalname
660 0.0003 0.00028491020202637
SELECT * FROM productoffers WHERE product_id = '103845' AND merchantid = 'ATVPDKIKX0DER'
661 0.0002 0.00023317337036133
SELECT * FROM productoffers
                WHERE product_id = '103845' AND price > 0
                ORDER BY price ASC LIMIT 1
662 0.0005 0.00045299530029297
SELECT value FROM productattributes WHERE product_id = '103845' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
663 0.0002 0.00015687942504883
UPDATE products SET price = '11327' WHERE id = '103845'
664 0.0003 0.00025010108947754
SELECT * FROM productimages WHERE product_id = '247027' ORDER BY sortorder ASC
665 0.0003 0.00028085708618164
SELECT * FROM product_image_select WHERE product_id = '247027'
666 0.0002 0.00016307830810547
SELECT * FROM productcustomimages WHERE product_id = '247027'
667 0.0028 0.0027718544006348
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '247027' AND a.name = n.originalname
668 0.0003 0.0002741813659668
SELECT * FROM productoffers WHERE product_id = '247027' AND merchantid = 'ATVPDKIKX0DER'
669 0.0002 0.000244140625
SELECT * FROM productoffers
                WHERE product_id = '247027' AND price > 0
                ORDER BY price ASC LIMIT 1
670 0.0005 0.00051379203796387
SELECT value FROM productattributes WHERE product_id = '247027' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
671 0.0002 0.00016212463378906
UPDATE products SET price = '1492' WHERE id = '247027'
672 0.0003 0.00028109550476074
SELECT * FROM productimages WHERE product_id = '383185' ORDER BY sortorder ASC
673 0.0003 0.00026392936706543
SELECT * FROM product_image_select WHERE product_id = '383185'
674 0.0001 0.00013899803161621
SELECT * FROM productcustomimages WHERE product_id = '383185'
675 0.0040 0.0039849281311035
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '383185' AND a.name = n.originalname
676 0.0002 0.00024700164794922
SELECT * FROM productoffers WHERE product_id = '383185' AND merchantid = 'ATVPDKIKX0DER'
677 0.0002 0.00024199485778809
SELECT * FROM productoffers
                WHERE product_id = '383185' AND price > 0
                ORDER BY price ASC LIMIT 1
678 0.0005 0.00053906440734863
SELECT value FROM productattributes WHERE product_id = '383185' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
679 0.0001 0.00014305114746094
UPDATE products SET price = '11900' WHERE id = '383185'
680 0.0002 0.00021600723266602
SELECT * FROM productimages WHERE product_id = '414940' ORDER BY sortorder ASC
681 0.0003 0.00025391578674316
SELECT * FROM product_image_select WHERE product_id = '414940'
682 0.0001 0.00014090538024902
SELECT * FROM productcustomimages WHERE product_id = '414940'
683 0.0046 0.0045568943023682
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '414940' AND a.name = n.originalname
684 0.0003 0.00025486946105957
SELECT * FROM productoffers WHERE product_id = '414940' AND merchantid = 'ATVPDKIKX0DER'
685 0.0003 0.00026702880859375
SELECT * FROM productoffers
                WHERE product_id = '414940' AND price > 0
                ORDER BY price ASC LIMIT 1
686 0.0006 0.00058603286743164
SELECT value FROM productattributes WHERE product_id = '414940' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
687 0.0001 0.00014805793762207
UPDATE products SET price = '4490' WHERE id = '414940'
688 0.0008 0.00080990791320801
SELECT * FROM productimages WHERE product_id = '171938' ORDER BY sortorder ASC
689 0.0003 0.00029301643371582
SELECT * FROM product_image_select WHERE product_id = '171938'
690 0.0001 0.00014996528625488
SELECT * FROM productcustomimages WHERE product_id = '171938'
691 0.0035 0.0034959316253662
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '171938' AND a.name = n.originalname
692 0.0002 0.00023818016052246
SELECT * FROM productoffers WHERE product_id = '171938' AND merchantid = 'ATVPDKIKX0DER'
693 0.0002 0.00023722648620605
SELECT * FROM productoffers
                WHERE product_id = '171938' AND price > 0
                ORDER BY price ASC LIMIT 1
694 0.0007 0.00071096420288086
SELECT value FROM productattributes WHERE product_id = '171938' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
695 0.0002 0.0001680850982666
UPDATE products SET price = '388900' WHERE id = '171938'
696 0.0814 0.081367969512939
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
697 0.0003 0.00026297569274902
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:1561491283;s:8:\"products\";a:6:{i:1;s:6:\"398858\";i:2;s:6:\"171938\";i:4;s:6:\"412927\";i:17;s:6:\"232841\";i:22;s:6:\"169659\";i:9;s:6:\"247027\";}}' WHERE id = '183'
698 0.0005 0.00046396255493164
SELECT * FROM products WHERE id IN (398858,171938,412927,232841,169659,247027) ORDER BY FIELD(id, 398858,171938,412927,232841,169659,247027 )
699 0.0002 0.00022387504577637
SELECT * FROM productimages WHERE product_id = '398858' ORDER BY sortorder ASC
700 0.0002 0.00020503997802734
SELECT * FROM product_image_select WHERE product_id = '398858'
701 0.0001 0.00012302398681641
SELECT * FROM productcustomimages WHERE product_id = '398858'
702 0.0031 0.0030918121337891
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '398858' AND a.name = n.originalname
703 0.0002 0.00018215179443359
SELECT * FROM productoffers WHERE product_id = '398858' AND merchantid = 'ATVPDKIKX0DER'
704 0.0002 0.00021886825561523
SELECT * FROM productoffers
                WHERE product_id = '398858' AND price > 0
                ORDER BY price ASC LIMIT 1
705 0.0004 0.00041580200195312
SELECT value FROM productattributes WHERE product_id = '398858' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
706 0.0001 0.00011801719665527
UPDATE products SET price = '2999' WHERE id = '398858'
707 0.0006 0.00063204765319824
SELECT * FROM productimages WHERE product_id = '171938' ORDER BY sortorder ASC
708 0.0002 0.0002131462097168
SELECT * FROM product_image_select WHERE product_id = '171938'
709 0.0001 0.00011801719665527
SELECT * FROM productcustomimages WHERE product_id = '171938'
710 0.0026 0.0025620460510254
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '171938' AND a.name = n.originalname
711 0.0002 0.00017905235290527
SELECT * FROM productoffers WHERE product_id = '171938' AND merchantid = 'ATVPDKIKX0DER'
712 0.0002 0.00019311904907227
SELECT * FROM productoffers
                WHERE product_id = '171938' AND price > 0
                ORDER BY price ASC LIMIT 1
713 0.0004 0.00039005279541016
SELECT value FROM productattributes WHERE product_id = '171938' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
714 0.0001 0.00011587142944336
UPDATE products SET price = '388900' WHERE id = '171938'
715 0.0003 0.00025200843811035
SELECT * FROM productimages WHERE product_id = '412927' ORDER BY sortorder ASC
716 0.0002 0.00021505355834961
SELECT * FROM product_image_select WHERE product_id = '412927'
717 0.0001 0.00011992454528809
SELECT * FROM productcustomimages WHERE product_id = '412927'
718 0.0036 0.0035719871520996
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '412927' AND a.name = n.originalname
719 0.0002 0.00018906593322754
SELECT * FROM productoffers WHERE product_id = '412927' AND merchantid = 'ATVPDKIKX0DER'
720 0.0002 0.00019216537475586
SELECT * FROM productoffers
                WHERE product_id = '412927' AND price > 0
                ORDER BY price ASC LIMIT 1
721 0.0004 0.0004420280456543
SELECT value FROM productattributes WHERE product_id = '412927' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
722 0.0001 0.00011610984802246
UPDATE products SET price = '199900' WHERE id = '412927'
723 0.0004 0.00041317939758301
SELECT * FROM productimages WHERE product_id = '232841' ORDER BY sortorder ASC
724 0.0002 0.00021004676818848
SELECT * FROM product_image_select WHERE product_id = '232841'
725 0.0001 0.00011897087097168
SELECT * FROM productcustomimages WHERE product_id = '232841'
726 0.0028 0.0028080940246582
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '232841' AND a.name = n.originalname
727 0.0002 0.00017905235290527
SELECT * FROM productoffers WHERE product_id = '232841' AND merchantid = 'ATVPDKIKX0DER'
728 0.0002 0.00020194053649902
SELECT * FROM productoffers
                WHERE product_id = '232841' AND price > 0
                ORDER BY price ASC LIMIT 1
729 0.0004 0.00039196014404297
SELECT value FROM productattributes WHERE product_id = '232841' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
730 0.0001 0.00011491775512695
UPDATE products SET price = '20662' WHERE id = '232841'
731 0.0002 0.00018692016601562
SELECT * FROM productimages WHERE product_id = '169659' ORDER BY sortorder ASC
732 0.0002 0.00020599365234375
SELECT * FROM product_image_select WHERE product_id = '169659'
733 0.0001 0.00011897087097168
SELECT * FROM productcustomimages WHERE product_id = '169659'
734 0.0023 0.0022711753845215
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '169659' AND a.name = n.originalname
735 0.0002 0.00017714500427246
SELECT * FROM productoffers WHERE product_id = '169659' AND merchantid = 'ATVPDKIKX0DER'
736 0.0002 0.00019383430480957
SELECT * FROM productoffers
                WHERE product_id = '169659' AND price > 0
                ORDER BY price ASC LIMIT 1
737 0.0004 0.0003509521484375
SELECT value FROM productattributes WHERE product_id = '169659' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
738 0.0001 0.00011610984802246
UPDATE products SET price = '10900' WHERE id = '169659'
739 0.0002 0.00023508071899414
SELECT * FROM productimages WHERE product_id = '247027' ORDER BY sortorder ASC
740 0.0002 0.00020813941955566
SELECT * FROM product_image_select WHERE product_id = '247027'
741 0.0001 0.00012493133544922
SELECT * FROM productcustomimages WHERE product_id = '247027'
742 0.0021 0.0020589828491211
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '247027' AND a.name = n.originalname
743 0.0002 0.00017809867858887
SELECT * FROM productoffers WHERE product_id = '247027' AND merchantid = 'ATVPDKIKX0DER'
744 0.0002 0.00019407272338867
SELECT * FROM productoffers
                WHERE product_id = '247027' AND price > 0
                ORDER BY price ASC LIMIT 1
745 0.0004 0.00035905838012695
SELECT value FROM productattributes WHERE product_id = '247027' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
746 0.0001 0.00012683868408203
UPDATE products SET price = '1492' WHERE id = '247027'
747 0.0004 0.00040388107299805
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid' AND area = 'header' ORDER BY sortorder ASC
748 0.0001 0.00012993812561035
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
749 0.0001 0.00013113021850586
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
750 0.0001 0.00011801719665527
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
751 0.0001 0.00011420249938965
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
752 0.0004 0.0003969669342041
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid' AND area = 'footer' ORDER BY sortorder ASC
753 0.0001 0.00013399124145508
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
754 0.0001 0.00011610984802246
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
755 0.0001 0.00011491775512695
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
756 0.0009 0.00090813636779785
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-fluid' AND skinuid = ''
757 0.0003 0.00029778480529785
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid'
758 0.0003 0.00028705596923828
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid'
759 0.0003 0.00032711029052734
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid' AND imageuid = 'HEAD_CUSTOM_BANNER'
760 0.0003 0.00030899047851562
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid' AND imageuid = 'HEAD_CUSTOM_BANNER'