Tactical Equipment - Survivalist Equipment

P2M Firestorm 1-4x19 Thermal Monoculars from Sellmark Corporation

Price: Click Button for Price
Product prices and availability are accurate as of 2019-06-16 23:17:38 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

The Tactical and Survivalist shop is happy to present the fantastic P2M Firestorm 1-4x19 Thermal Monoculars today at this great price.

With so many competing tactical, combat and survival products available currently, it is wise to have a provider that you can recognize. The P2M Firestorm 1-4x19 Thermal Monoculars is certainly all that and will be a excellent buy for your combat kit or tactical ability.

We pride ourselves on providing the best quality survival gear for all your front line requirements.

For this special price, the P2M Firestorm 1-4x19 Thermal Monoculars comes highly recommended and is a favored choice with most like minded people. Sellmark Corporation have added some excellent touches and this equals improved value.

Manufacturer Description

Becoming completely aware of your surroundings, even in total darkness, is easier than ever with the Firestorm 1-4x19 Thermal Monocular. Able to detect human-sized heat signatures up to an astounding 550 yards away, the Firestorm's 384x288 sensor combines with a high-resolution 640x480 LCD display to produce vivid thermal images, ideal for aiding in hunting, wildlife observation, law enforcement search & rescue and more. Allowing full customization to fit the user's environment, the Firestorm features 3 distinct color palettes, full brightness and contrast adjustments and up to 4x zoom in 1x increments. In addition to its thermal technology, the Firestorm boasts useful features such as remote viewing for iOS and Android devices through the IR-Tracker app, hot spot tracking and video output. Included with the Firestorm 1-4x19 are USB cable, hand strap, video cable and carrying case.

Product Features

384x288 resolution 550yd detection range 4x zoom in 1x increments 3 color palettes Remote viewing through ir-tracker app

Write a Review

Debug Overview

App Total Time DB Queries DB Query Total Time Amazon Requests
5.9065270423889 789 2.7914 0


No Amazon API Requests Made.


App Debug - Total Time 5.9065270423889 seconds

Number Time From Start Name Description
1 0.41465401649475 Initialise Initialise FSB Function
2 0.42769002914429 App Controller Start Start of the App controller (called before the controller of every page)
3 0.43963122367859 Start of getCategoryListByGroup Function Before first category groups query
4 0.43984723091125 After initial query Before first category groups query
5 0.43984913825989 Get Category List for Group Before the call to getCategoryList function
6 0.43985319137573 Start of GetCategoryList function Start of the function
7 0.43985915184021 Before getting categories Query to get specific category list
8 0.44048714637756 After getting categories Query to get specific category list
9 0.4404890537262 Before getting category custom Before call to function getCategoryCustom
10 0.44257307052612 After getting category custom After call to function getCategoryCustom
11 0.4425790309906 Before getting category custom Before call to function getCategoryCustom
12 0.45394706726074 After getting category custom After call to function getCategoryCustom
13 0.45395302772522 Before getting category custom Before call to function getCategoryCustom
14 0.45968699455261 After getting category custom After call to function getCategoryCustom
15 0.45969009399414 Before getting category custom Before call to function getCategoryCustom
16 0.46389412879944 After getting category custom After call to function getCategoryCustom
17 0.46389722824097 End of GetCategoryList function End of the function
18 0.46390914916992 Get Category List for Group Before the call to getCategoryList function
19 0.46391201019287 Start of GetCategoryList function Start of the function
20 0.4639151096344 Before getting categories Query to get specific category list
21 0.46436405181885 After getting categories Query to get specific category list
22 0.46436500549316 Before getting category custom Before call to function getCategoryCustom
23 0.47004699707031 After getting category custom After call to function getCategoryCustom
24 0.47005009651184 Before getting category custom Before call to function getCategoryCustom
25 0.48086309432983 After getting category custom After call to function getCategoryCustom
26 0.48086500167847 End of GetCategoryList function End of the function
27 0.48087120056152 Get Category List for Group Before the call to getCategoryList function
28 0.48087406158447 Start of GetCategoryList function Start of the function
29 0.48087620735168 Before getting categories Query to get specific category list
30 0.48159313201904 After getting categories Query to get specific category list
31 0.48159408569336 Before getting category custom Before call to function getCategoryCustom
32 0.49085712432861 After getting category custom After call to function getCategoryCustom
33 0.49085903167725 Before getting category custom Before call to function getCategoryCustom
34 0.50843501091003 After getting category custom After call to function getCategoryCustom
35 0.50843811035156 Before getting category custom Before call to function getCategoryCustom
36 0.5144031047821 After getting category custom After call to function getCategoryCustom
37 0.51440501213074 Before getting category custom Before call to function getCategoryCustom
38 0.52039504051208 After getting category custom After call to function getCategoryCustom
39 0.5203971862793 Before getting category custom Before call to function getCategoryCustom
40 0.52668905258179 After getting category custom After call to function getCategoryCustom
41 0.52669215202332 Before getting category custom Before call to function getCategoryCustom
42 0.54894399642944 After getting category custom After call to function getCategoryCustom
43 0.54894614219666 Before getting category custom Before call to function getCategoryCustom
44 0.55307006835938 After getting category custom After call to function getCategoryCustom
45 0.5530731678009 Before getting category custom Before call to function getCategoryCustom
46 0.55770611763 After getting category custom After call to function getCategoryCustom
47 0.55770921707153 End of GetCategoryList function End of the function
48 0.55772304534912 Get Category List for Group Before the call to getCategoryList function
49 0.55772614479065 Start of GetCategoryList function Start of the function
50 0.5577290058136 Before getting categories Query to get specific category list
51 0.55814719200134 After getting categories Query to get specific category list
52 0.55814814567566 Before getting category custom Before call to function getCategoryCustom
53 0.56043815612793 After getting category custom After call to function getCategoryCustom
54 0.56044006347656 Before getting category custom Before call to function getCategoryCustom
55 0.56278514862061 After getting category custom After call to function getCategoryCustom
56 0.56278800964355 End of GetCategoryList function End of the function
57 0.56279301643372 Get Category List for Group Before the call to getCategoryList function
58 0.56279516220093 Start of GetCategoryList function Start of the function
59 0.56279802322388 Before getting categories Query to get specific category list
60 0.56310319900513 After getting categories Query to get specific category list
61 0.56310415267944 Before getting category custom Before call to function getCategoryCustom
62 0.56810116767883 After getting category custom After call to function getCategoryCustom
63 0.56810307502747 End of GetCategoryList function End of the function
64 0.56810903549194 End of getCategoryListByGroup Function Before return()
65 0.61821413040161 App Controller End End of the App controller (called before the controller of every page)
66 0.61885809898376 Product Start Start of the product info controller
67 0.61968111991882 Cache file not found Starting get product details
68 0.63986420631409 Related products Start getting related products if enabled
69 0.63986611366272 Related Products Start Before the related products are found
70 0.63986706733704 Related Products Keywords Before the related product keywords are found
71 0.63987421989441 Create Keyword List Function Start of function
72 0.64077115058899 Create Keyword List Function After looping provided content - 676 keywords found
73 0.68504905700684 Create Keyword List Function After looping initial keyword list - 622 keywords remaining
74 0.68520903587341 Create Keyword List Function After reducing keyword list
75 0.68674421310425 Create Keyword List Function After selecting by scoring keywords
76 0.68675017356873 Create Keyword List Function After final loop of keywords
77 0.68675208091736 Related Products Keywords After the related product keywords are found
78 1.182893037796 Related Products End After the related products are found
79 1.3706290721893 Start Remote Request http://svcs.ebay.com/services/search/FindingServic...
80 1.6394090652466 End Remote Request http://svcs.ebay.com/services/search/FindingServic...
81 1.8247241973877 Start Remote Request http://svcs.ebay.com/services/search/FindingServic...
82 2.1136050224304 End Remote Request http://svcs.ebay.com/services/search/FindingServic...
83 2.2961750030518 Start Remote Request http://svcs.ebay.com/services/search/FindingServic...
84 2.5456411838531 End Remote Request http://svcs.ebay.com/services/search/FindingServic...
85 2.7278912067413 Start Remote Request http://svcs.ebay.com/services/search/FindingServic...
86 2.9769802093506 End Remote Request http://svcs.ebay.com/services/search/FindingServic...
87 3.1698710918427 Start Remote Request http://svcs.ebay.com/services/search/FindingServic...
88 3.410462141037 End Remote Request http://svcs.ebay.com/services/search/FindingServic...
89 3.5988240242004 Start Remote Request http://svcs.ebay.com/services/search/FindingServic...
90 3.8475670814514 End Remote Request http://svcs.ebay.com/services/search/FindingServic...
91 4.030501127243 Start Remote Request http://svcs.ebay.com/services/search/FindingServic...
92 4.3069760799408 End Remote Request http://svcs.ebay.com/services/search/FindingServic...
93 4.4927241802216 Start Remote Request http://svcs.ebay.com/services/search/FindingServic...
94 4.8154530525208 End Remote Request http://svcs.ebay.com/services/search/FindingServic...
95 5.0200591087341 Product End End of the product info controller (Product Info)
96 5.0204710960388 App_after Controller Start Start of the App_after controller (called after the controller of every page)
97 5.0205571651459 Before Get Options Before the call to getOptions in the tpl class
98 5.4367570877075 After Get Options After the call to getOptions in the tpl class
99 5.4369561672211 App_after Controller End End of the App_after controller (called after the controller of every page)
100 5.4369699954987 Product Info: Before Smarty Fetch Before the product.tpl template is fetched
101 5.699166059494 Product Info: After Smarty Fetch After the product.tpl template is fetched
102 5.6991720199585 Product Info: Before Template Display Before the template is displayed
103 5.906503200531 Product Info: After Template Display After the template is displayed
104 5.9065091609955 Finalizing debug Before the debug is output to the page.
105 5.9065260887146 End of App This is the end of the app logging, final timestamp


Query Debug - 789 Database Queries. Total time 2.7914 seconds

Number Time (Seconds) Time (Milliseconds) Query
1 0.0002 0.00016689300537109
SELECT value FROM parameters WHERE `parameter` = 'BAD_BOTS_ENABLER'
2 0.0004 0.0004270076751709
SHOW TABLES LIKE 'bad_bots'
3 0.0002 0.00015592575073242
SELECT value FROM parameters WHERE `parameter` = 'STORE_WHITELISTED_IPS'
4 0.0002 0.00017380714416504
SELECT * FROM `bad_bots`
5 0.0005 0.00048589706420898
SELECT parameter, value FROM parameters
6 0.0001 0.00014400482177734
SET time_zone = 'Europe/London'
7 0.0005 0.00047492980957031
SELECT * FROM autorun ORDER BY lastrun ASC
8 0.0002 0.00017786026000977
SELECT * FROM version ORDER BY installed DESC LIMIT 1
9 0.0001 0.00013208389282227
delete from cachefiles
10 0.0004 0.00042200088500977
SELECT id FROM pages WHERE pagename = 'p2m-firestorm-1-4x19-thermal-monoculars' LIMIT 1
11 0.0003 0.00026297569274902
SELECT id FROM products WHERE pagename = 'p2m-firestorm-1-4x19-thermal-monoculars' AND hidden = 0 LIMIT 1
12 0.0009 0.00085091590881348
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-fluid'
13 0.0094 0.009390115737915
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-fluid' AND language = 'en'
14 0.0003 0.00031900405883789
SELECT * FROM pages WHERE pagename = 'p2m-firestorm-1-4x19-thermal-monoculars'
15 0.0002 0.00018501281738281
SELECT * FROM categorygroups ORDER BY sortorder ASC
16 0.0006 0.00056719779968262
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
17 0.0005 0.00050902366638184
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 49
18 0.0003 0.00026297569274902
SELECT id FROM categories WHERE parent_id = '49'
19 0.0005 0.00047397613525391
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.00016593933105469
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (49)
				  AND p.disabled = 0 
21 0.0002 0.00016498565673828
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (49)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
22 0.0002 0.00020909309387207
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '49'
23 0.0001 0.00013995170593262
SELECT * FROM categorygroups WHERE id = '1'
24 0.0031 0.0031089782714844
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.00030708312988281
SELECT id FROM categories WHERE parent_id = '50'
26 0.0002 0.00023388862609863
SELECT id FROM categories WHERE parent_id = '96'
27 0.0002 0.00022697448730469
SELECT id FROM categories WHERE parent_id = '97'
28 0.0002 0.00022101402282715
SELECT id FROM categories WHERE parent_id = '111'
29 0.0002 0.00021600723266602
SELECT id FROM categories WHERE parent_id = '129'
30 0.0060 0.0059778690338135
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.0002448558807373
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (96,97,111,129,50)
				  AND p.disabled = 0 
32 0.0002 0.00021100044250488
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (96,97,111,129,50)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
33 0.0002 0.00018596649169922
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '50'
34 0.0001 0.00013494491577148
SELECT * FROM categorygroups WHERE id = '1'
35 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 = 80
36 0.0003 0.00028610229492188
SELECT id FROM categories WHERE parent_id = '80'
37 0.0024 0.0023741722106934
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (80)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
38 0.0002 0.0001530647277832
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (80)
				  AND p.disabled = 0 
39 0.0002 0.00015711784362793
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.00016403198242188
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '80'
41 0.0001 0.00012803077697754
SELECT * FROM categorygroups WHERE id = '1'
42 0.0012 0.0011858940124512
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 51
43 0.0003 0.00026082992553711
SELECT id FROM categories WHERE parent_id = '51'
44 0.0002 0.00021696090698242
SELECT id FROM categories WHERE parent_id = '101'
45 0.0018 0.0018260478973389
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (101,51)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
46 0.0002 0.0001680850982666
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.00014805793762207
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.0001680850982666
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '51'
49 0.0001 0.00012516975402832
SELECT * FROM categorygroups WHERE id = '1'
50 0.0004 0.00042414665222168
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '2'  AND hidden = 0 ORDER BY sortorder ASC
51 0.0024 0.0023751258850098
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.0002 0.0002448558807373
SELECT id FROM categories WHERE parent_id = '30'
53 0.0024 0.0023849010467529
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (30)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
54 0.0002 0.00015020370483398
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.00014686584472656
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (30)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
56 0.0002 0.0001680850982666
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
57 0.0001 0.00012302398681641
SELECT * FROM categorygroups WHERE id = '2'
58 0.0049 0.0049269199371338
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.00027203559875488
SELECT id FROM categories WHERE parent_id = '61'
60 0.0049 0.0049200057983398
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (61)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
61 0.0002 0.00016689300537109
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (61)
				  AND p.disabled = 0 
62 0.0001 0.00014901161193848
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (61)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
63 0.0002 0.00016498565673828
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '61'
64 0.0001 0.00012612342834473
SELECT * FROM categorygroups WHERE id = '2'
65 0.0007 0.00065398216247559
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '10'  AND hidden = 0 ORDER BY sortorder ASC
66 0.0041 0.0041408538818359
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.00025796890258789
SELECT id FROM categories WHERE parent_id = '64'
68 0.0042 0.0041670799255371
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (64)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
69 0.0002 0.00016593933105469
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (64)
				  AND p.disabled = 0 
70 0.0001 0.00014805793762207
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (64)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
71 0.0002 0.00016403198242188
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '64'
72 0.0001 0.00012397766113281
SELECT * FROM categorygroups WHERE id = '10'
73 0.0082 0.0082309246063232
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.00029087066650391
SELECT id FROM categories WHERE parent_id = '65'
75 0.0083 0.0083210468292236
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.00017213821411133
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.00014805793762207
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.00017595291137695
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '65'
79 0.0001 0.00012898445129395
SELECT * FROM categorygroups WHERE id = '10'
80 0.0025 0.0024919509887695
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.00026202201843262
SELECT id FROM categories WHERE parent_id = '81'
82 0.0025 0.0025250911712646
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.00015115737915039
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.00014591217041016
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.00015807151794434
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '81'
86 0.0001 0.00012612342834473
SELECT * FROM categorygroups WHERE id = '10'
87 0.0025 0.0025041103363037
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.00026202201843262
SELECT id FROM categories WHERE parent_id = '31'
89 0.0025 0.0025360584259033
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.00015115737915039
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.00014615058898926
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.00016593933105469
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
93 0.0001 0.00013589859008789
SELECT * FROM categorygroups WHERE id = '10'
94 0.0023 0.0022671222686768
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.00025486946105957
SELECT id FROM categories WHERE parent_id = '66'
96 0.0002 0.00020408630371094
SELECT id FROM categories WHERE parent_id = '131'
97 0.0029 0.0028641223907471
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.00015711784362793
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.00016093254089355
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (131,66)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
100 0.0002 0.00016093254089355
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '66'
101 0.0001 0.00012397766113281
SELECT * FROM categorygroups WHERE id = '10'
102 0.0097 0.0097072124481201
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.00028395652770996
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.00020003318786621
SELECT id FROM categories WHERE parent_id = '98'
106 0.0002 0.00021481513977051
SELECT id FROM categories WHERE parent_id = '99'
107 0.0002 0.00020313262939453
SELECT id FROM categories WHERE parent_id = '110'
108 0.0002 0.0001981258392334
SELECT id FROM categories WHERE parent_id = '130'
109 0.0104 0.010447978973389
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.00018882751464844
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.00015807151794434
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.00017809867858887
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '34'
113 0.0001 0.00012707710266113
SELECT * FROM categorygroups WHERE id = '10'
114 0.0016 0.0015890598297119
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.0002601146697998
SELECT id FROM categories WHERE parent_id = '32'
116 0.0016 0.0016109943389893
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (32)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
117 0.0001 0.00014686584472656
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (32)
				  AND p.disabled = 0 
118 0.0001 0.00014305114746094
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.00016188621520996
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '32'
120 0.0001 0.00012397766113281
SELECT * FROM categorygroups WHERE id = '10'
121 0.0018 0.0018351078033447
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.00025105476379395
SELECT id FROM categories WHERE parent_id = '89'
123 0.0019 0.0018670558929443
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (89)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
124 0.0001 0.00014710426330566
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.00015401840209961
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.0001680850982666
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '89'
127 0.0001 0.00012302398681641
SELECT * FROM categorygroups WHERE id = '10'
128 0.0004 0.00039291381835938
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '17'  AND hidden = 0 ORDER BY sortorder ASC
129 0.0007 0.00068306922912598
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 84
130 0.0002 0.00023007392883301
SELECT id FROM categories WHERE parent_id = '84'
131 0.0007 0.00069689750671387
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (84)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
132 0.0001 0.00014495849609375
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (84)
				  AND p.disabled = 0 
133 0.0001 0.00014305114746094
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (84)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
134 0.0002 0.00017499923706055
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '84'
135 0.0001 0.00012397766113281
SELECT * FROM categorygroups WHERE id = '17'
136 0.0007 0.00070500373840332
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.00024104118347168
SELECT id FROM categories WHERE parent_id = '90'
138 0.0007 0.00073695182800293
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (90)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
139 0.0002 0.0001518726348877
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (90)
				  AND p.disabled = 0 
140 0.0001 0.00014400482177734
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (90)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
141 0.0002 0.00015401840209961
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '90'
142 0.0001 0.0001220703125
SELECT * FROM categorygroups WHERE id = '17'
143 0.0003 0.00029087066650391
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '20'  AND hidden = 0 ORDER BY sortorder ASC
144 0.0020 0.0020251274108887
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.00025010108947754
SELECT id FROM categories WHERE parent_id = '92'
146 0.0021 0.0020649433135986
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (92)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
147 0.0001 0.00014686584472656
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.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 (92)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
149 0.0001 0.00014901161193848
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '92'
150 0.0001 0.00012516975402832
SELECT * FROM categorygroups WHERE id = '20'
151 0.0051 0.0051209926605225
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
152 0.0004 0.0003659725189209
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-fluid' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
153 0.0002 0.00019097328186035
SELECT value FROM parameters WHERE parameter = 'EBAY_APP_ID' 
154 0.0002 0.00015687942504883
SELECT * FROM sideboxes_pages WHERE sidebox_id = '1'
155 0.0002 0.0001671314239502
SELECT * FROM pages WHERE id = '67'
156 0.0002 0.00015902519226074
SELECT * FROM pages WHERE id = '82'
157 0.0002 0.00016117095947266
SELECT * FROM pages WHERE id = '84'
158 0.0001 0.00014400482177734
SELECT * FROM pages WHERE id = '94'
159 0.0002 0.00015401840209961
SELECT * FROM pages WHERE id = '116'
160 0.0002 0.0001981258392334
SELECT * FROM pages WHERE id = '52'
161 0.0002 0.0001680850982666
SELECT * FROM pages WHERE id = '135'
162 0.0002 0.00015592575073242
SELECT * FROM pages WHERE id = '245'
163 0.0002 0.00016188621520996
SELECT * FROM pages WHERE id = '269'
164 0.0002 0.00018501281738281
SELECT * FROM pages WHERE id = '275'
165 0.0002 0.00017714500427246
SELECT * FROM pages WHERE id = '280'
166 0.0002 0.00019097328186035
SELECT * FROM pages WHERE id = '357'
167 0.0001 0.00014805793762207
SELECT * FROM pages WHERE id = '379'
168 0.0001 0.00014185905456543
SELECT * FROM pages WHERE id = '401'
169 0.0002 0.00015091896057129
SELECT * FROM pages WHERE id = '450'
170 0.0001 0.00014805793762207
SELECT * FROM pages WHERE id = '454'
171 0.0002 0.00015711784362793
SELECT * FROM pages WHERE id = '457'
172 0.0002 0.00016188621520996
SELECT * FROM pages WHERE id = '458'
173 0.0002 0.0001530647277832
SELECT * FROM sideboxes_pages WHERE sidebox_id = '2'
174 0.0002 0.00015997886657715
SELECT * FROM pages WHERE id = '41'
175 0.0002 0.00015997886657715
SELECT * FROM pages WHERE id = '43'
176 0.0001 0.00014901161193848
SELECT * FROM pages WHERE id = '44'
177 0.0002 0.00015807151794434
SELECT * FROM pages WHERE id = '68'
178 0.0002 0.00019502639770508
SELECT * FROM pages WHERE id = '80'
179 0.0002 0.00015997886657715
SELECT * FROM pages WHERE id = '85'
180 0.0002 0.00015592575073242
SELECT * FROM pages WHERE id = '97'
181 0.0002 0.00015401840209961
SELECT * FROM pages WHERE id = '107'
182 0.0001 0.00014400482177734
SELECT * FROM pages WHERE id = '108'
183 0.0002 0.0001521110534668
SELECT * FROM pages WHERE id = '128'
184 0.0002 0.00016212463378906
SELECT * FROM pages WHERE id = '133'
185 0.0001 0.00014519691467285
SELECT * FROM pages WHERE id = '148'
186 0.0002 0.00015807151794434
SELECT * FROM pages WHERE id = '217'
187 0.0001 0.00014209747314453
SELECT * FROM pages WHERE id = '228'
188 0.0001 0.00014710426330566
SELECT * FROM pages WHERE id = '257'
189 0.0002 0.0001671314239502
SELECT * FROM pages WHERE id = '271'
190 0.0001 0.00014686584472656
SELECT * FROM pages WHERE id = '286'
191 0.0001 0.00014519691467285
SELECT * FROM pages WHERE id = '287'
192 0.0002 0.00015497207641602
SELECT * FROM pages WHERE id = '291'
193 0.0002 0.00015401840209961
SELECT * FROM pages WHERE id = '380'
194 0.0002 0.00016307830810547
SELECT * FROM pages WHERE id = '344'
195 0.0002 0.00016498565673828
SELECT * FROM pages WHERE id = '354'
196 0.0002 0.00017595291137695
SELECT * FROM pages WHERE id = '363'
197 0.0002 0.00018215179443359
SELECT * FROM pages WHERE id = '364'
198 0.0001 0.00014185905456543
SELECT * FROM pages WHERE id = '368'
199 0.0002 0.00017189979553223
SELECT * FROM pages WHERE id = '369'
200 0.0002 0.00015091896057129
SELECT * FROM pages WHERE id = '400'
201 0.0002 0.00015592575073242
SELECT * FROM pages WHERE id = '463'
202 0.0002 0.00016403198242188
SELECT * FROM sideboxes_pages WHERE sidebox_id = '33'
203 0.0002 0.00023508071899414
SELECT * FROM pages WHERE id = '66'
204 0.0002 0.00018692016601562
SELECT * FROM pages WHERE id = '77'
205 0.0002 0.00018000602722168
SELECT * FROM pages WHERE id = '90'
206 0.0001 0.00014400482177734
SELECT * FROM pages WHERE id = '414'
207 0.0001 0.00014781951904297
SELECT * FROM pages WHERE id = '119'
208 0.0001 0.00014996528625488
SELECT * FROM pages WHERE id = '406'
209 0.0001 0.00014805793762207
SELECT * FROM pages WHERE id = '149'
210 0.0001 0.00014686584472656
SELECT * FROM pages WHERE id = '150'
211 0.0001 0.00014495849609375
SELECT * FROM pages WHERE id = '412'
212 0.0002 0.00015497207641602
SELECT * FROM pages WHERE id = '162'
213 0.0001 0.00014281272888184
SELECT * FROM pages WHERE id = '164'
214 0.0001 0.00014281272888184
SELECT * FROM pages WHERE id = '167'
215 0.0001 0.0001368522644043
SELECT * FROM pages WHERE id = '180'
216 0.0001 0.0001380443572998
SELECT * FROM pages WHERE id = '187'
217 0.0002 0.00018715858459473
SELECT * FROM pages WHERE id = '265'
218 0.0002 0.00015497207641602
SELECT * FROM pages WHERE id = '268'
219 0.0001 0.00013995170593262
SELECT * FROM pages WHERE id = '411'
220 0.0001 0.00014901161193848
SELECT * FROM pages WHERE id = '290'
221 0.0001 0.00013899803161621
SELECT * FROM pages WHERE id = '413'
222 0.0001 0.00014901161193848
SELECT * FROM pages WHERE id = '409'
223 0.0001 0.00014996528625488
SELECT * FROM pages WHERE id = '327'
224 0.0001 0.00014615058898926
SELECT * FROM pages WHERE id = '336'
225 0.0002 0.0001530647277832
SELECT * FROM pages WHERE id = '351'
226 0.0001 0.00014400482177734
SELECT * FROM pages WHERE id = '358'
227 0.0001 0.00014996528625488
SELECT * FROM pages WHERE id = '360'
228 0.0002 0.00015902519226074
SELECT * FROM pages WHERE id = '362'
229 0.0002 0.00015497207641602
SELECT * FROM pages WHERE id = '366'
230 0.0002 0.00015687942504883
SELECT * FROM pages WHERE id = '370'
231 0.0001 0.00014686584472656
SELECT * FROM pages WHERE id = '377'
232 0.0001 0.00014996528625488
SELECT * FROM pages WHERE id = '386'
233 0.0001 0.00014185905456543
SELECT * FROM pages WHERE id = '408'
234 0.0001 0.00014996528625488
SELECT * FROM pages WHERE id = '415'
235 0.0002 0.00016117095947266
SELECT * FROM pages WHERE id = '416'
236 0.0002 0.00017499923706055
SELECT * FROM pages WHERE id = '419'
237 0.0002 0.00015497207641602
SELECT * FROM pages WHERE id = '423'
238 0.0002 0.00015091896057129
SELECT * FROM pages WHERE id = '427'
239 0.0002 0.00017285346984863
SELECT * FROM pages WHERE id = '428'
240 0.0001 0.00014901161193848
SELECT * FROM pages WHERE id = '432'
241 0.0001 0.00014114379882812
SELECT * FROM pages WHERE id = '433'
242 0.0002 0.00015115737915039
SELECT * FROM pages WHERE id = '436'
243 0.0001 0.00014710426330566
SELECT * FROM pages WHERE id = '437'
244 0.0001 0.00014305114746094
SELECT * FROM pages WHERE id = '461'
245 0.0002 0.00016903877258301
SELECT * FROM pages WHERE id = '464'
246 0.0001 0.00014495849609375
SELECT * FROM sideboxes_pages WHERE sidebox_id = '34'
247 0.0002 0.0001518726348877
SELECT * FROM pages WHERE id = '74'
248 0.0001 0.00014519691467285
SELECT * FROM pages WHERE id = '137'
249 0.0001 0.00014996528625488
SELECT * FROM pages WHERE id = '145'
250 0.0001 0.00014591217041016
SELECT * FROM pages WHERE id = '156'
251 0.0002 0.0001518726348877
SELECT * FROM pages WHERE id = '407'
252 0.0001 0.00014209747314453
SELECT * FROM pages WHERE id = '410'
253 0.0002 0.00017499923706055
SELECT * FROM pages WHERE id = '266'
254 0.0002 0.00020384788513184
SELECT * FROM pages WHERE id = '316'
255 0.0001 0.00014996528625488
SELECT * FROM pages WHERE id = '332'
256 0.0002 0.00017309188842773
SELECT * FROM pages WHERE id = '334'
257 0.0002 0.00015115737915039
SELECT * FROM pages WHERE id = '367'
258 0.0002 0.00015902519226074
SELECT * FROM pages WHERE id = '387'
259 0.0001 0.00014996528625488
SELECT * FROM pages WHERE id = '389'
260 0.0002 0.00015592575073242
SELECT * FROM pages WHERE id = '397'
261 0.0002 0.00015592575073242
SELECT * FROM pages WHERE id = '449'
262 0.0002 0.00016903877258301
SELECT * FROM sideboxes_pages WHERE sidebox_id = '35'
263 0.0002 0.00018405914306641
SELECT * FROM pages WHERE id = '42'
264 0.0001 0.00014805793762207
SELECT * FROM pages WHERE id = '79'
265 0.0002 0.00015878677368164
SELECT * FROM pages WHERE id = '86'
266 0.0001 0.00014400482177734
SELECT * FROM pages WHERE id = '95'
267 0.0002 0.0001521110534668
SELECT * FROM pages WHERE id = '102'
268 0.0002 0.0001530647277832
SELECT * FROM pages WHERE id = '109'
269 0.0002 0.00020194053649902
SELECT * FROM pages WHERE id = '114'
270 0.0002 0.00017404556274414
SELECT * FROM pages WHERE id = '121'
271 0.0002 0.00019192695617676
SELECT * FROM pages WHERE id = '138'
272 0.0002 0.0001521110534668
SELECT * FROM pages WHERE id = '142'
273 0.0002 0.00019216537475586
SELECT * FROM pages WHERE id = '62'
274 0.0001 0.00014591217041016
SELECT * FROM pages WHERE id = '157'
275 0.0002 0.00015497207641602
SELECT * FROM pages WHERE id = '246'
276 0.0002 0.00017809867858887
SELECT * FROM pages WHERE id = '276'
277 0.0002 0.00018095970153809
SELECT * FROM pages WHERE id = '278'
278 0.0002 0.00020384788513184
SELECT * FROM pages WHERE id = '279'
279 0.0002 0.00015878677368164
SELECT * FROM pages WHERE id = '317'
280 0.0001 0.00014901161193848
SELECT * FROM pages WHERE id = '405'
281 0.0002 0.00017094612121582
SELECT * FROM pages WHERE id = '343'
282 0.0001 0.00014710426330566
SELECT * FROM pages WHERE id = '345'
283 0.0002 0.00019383430480957
SELECT * FROM pages WHERE id = '346'
284 0.0002 0.00015687942504883
SELECT * FROM pages WHERE id = '347'
285 0.0002 0.00015997886657715
SELECT * FROM pages WHERE id = '348'
286 0.0002 0.00015091896057129
SELECT * FROM pages WHERE id = '349'
287 0.0001 0.00014710426330566
SELECT * FROM pages WHERE id = '381'
288 0.0001 0.00014901161193848
SELECT * FROM pages WHERE id = '392'
289 0.0002 0.00015497207641602
SELECT * FROM pages WHERE id = '393'
290 0.0001 0.00014400482177734
SELECT * FROM pages WHERE id = '394'
291 0.0001 0.00014209747314453
SELECT * FROM pages WHERE id = '395'
292 0.0002 0.0001530647277832
SELECT * FROM pages WHERE id = '399'
293 0.0002 0.00015115737915039
SELECT * FROM pages WHERE id = '421'
294 0.0001 0.0001380443572998
SELECT * FROM pages WHERE id = '426'
295 0.0002 0.00015115737915039
SELECT * FROM pages WHERE id = '430'
296 0.0001 0.00014495849609375
SELECT * FROM pages WHERE id = '431'
297 0.0002 0.0001528263092041
SELECT * FROM pages WHERE id = '434'
298 0.0002 0.00015497207641602
SELECT * FROM pages WHERE id = '435'
299 0.0002 0.00015902519226074
SELECT * FROM pages WHERE id = '440'
300 0.0002 0.0001528263092041
SELECT * FROM pages WHERE id = '441'
301 0.0002 0.00015592575073242
SELECT * FROM pages WHERE id = '451'
302 0.0001 0.00014185905456543
SELECT * FROM pages WHERE id = '453'
303 0.0001 0.0001370906829834
SELECT * FROM sideboxes_pages WHERE sidebox_id = '37'
304 0.0002 0.00016593933105469
SELECT * FROM pages WHERE id = '146'
305 0.0001 0.00014305114746094
SELECT * FROM pages WHERE id = '158'
306 0.0001 0.00014114379882812
SELECT * FROM pages WHERE id = '163'
307 0.0002 0.00021600723266602
SELECT * FROM pages WHERE id = '293'
308 0.0001 0.00014781951904297
SELECT * FROM pages WHERE id = '340'
309 0.0002 0.0001530647277832
SELECT * FROM pages WHERE id = '417'
310 0.0001 0.00013899803161621
SELECT * FROM sideboxes_pages WHERE sidebox_id = '40'
311 0.0002 0.00016093254089355
SELECT * FROM pages WHERE id = '173'
312 0.0002 0.00015497207641602
SELECT * FROM pages WHERE id = '181'
313 0.0001 0.00014495849609375
SELECT * FROM pages WHERE id = '288'
314 0.0002 0.0001530647277832
SELECT * FROM pages WHERE id = '299'
315 0.0001 0.00014686584472656
SELECT * FROM pages WHERE id = '300'
316 0.0001 0.00014901161193848
SELECT * FROM pages WHERE id = '383'
317 0.0001 0.00013899803161621
SELECT * FROM pages WHERE id = '385'
318 0.0002 0.00015997886657715
SELECT * FROM pages WHERE id = '438'
319 0.0002 0.00015521049499512
SELECT * FROM pages WHERE id = '442'
320 0.0001 0.0001378059387207
SELECT * FROM sideboxes_pages WHERE sidebox_id = '38'
321 0.0002 0.00022602081298828
SELECT * FROM pages WHERE id = '103'
322 0.0002 0.0002129077911377
SELECT * FROM pages WHERE id = '134'
323 0.0002 0.0001530647277832
SELECT * FROM pages WHERE id = '139'
324 0.0002 0.00015592575073242
SELECT * FROM pages WHERE id = '143'
325 0.0002 0.0001530647277832
SELECT * FROM pages WHERE id = '234'
326 0.0002 0.00015497207641602
SELECT * FROM pages WHERE id = '248'
327 0.0001 0.00014209747314453
SELECT * FROM pages WHERE id = '260'
328 0.0002 0.00015616416931152
SELECT * FROM pages WHERE id = '398'
329 0.0002 0.00016212463378906
SELECT * FROM sideboxes_pages WHERE sidebox_id = '29'
330 0.0002 0.00016188621520996
SELECT * FROM pages WHERE id = '61'
331 0.0002 0.00015497207641602
SELECT * FROM pages WHERE id = '87'
332 0.0002 0.00015711784362793
SELECT * FROM pages WHERE id = '104'
333 0.0002 0.00018501281738281
SELECT * FROM pages WHERE id = '115'
334 0.0002 0.0001518726348877
SELECT * FROM pages WHERE id = '124'
335 0.0002 0.00015687942504883
SELECT * FROM pages WHERE id = '144'
336 0.0002 0.00017094612121582
SELECT * FROM pages WHERE id = '151'
337 0.0001 0.00013995170593262
SELECT * FROM pages WHERE id = '199'
338 0.0002 0.00015616416931152
SELECT * FROM pages WHERE id = '200'
339 0.0001 0.00014305114746094
SELECT * FROM pages WHERE id = '304'
340 0.0002 0.00015020370483398
SELECT * FROM pages WHERE id = '321'
341 0.0001 0.00014185905456543
SELECT * FROM pages WHERE id = '333'
342 0.0002 0.00016498565673828
SELECT * FROM pages WHERE id = '350'
343 0.0001 0.00014185905456543
SELECT * FROM pages WHERE id = '378'
344 0.0001 0.00014495849609375
SELECT * FROM pages WHERE id = '422'
345 0.0002 0.00017213821411133
SELECT * FROM pages WHERE id = '425'
346 0.0001 0.00014495849609375
SELECT * FROM pages WHERE id = '443'
347 0.0001 0.00014400482177734
SELECT * FROM pages WHERE id = '444'
348 0.0001 0.00014114379882812
SELECT * FROM pages WHERE id = '445'
349 0.0001 0.00014805793762207
SELECT * FROM pages WHERE id = '446'
350 0.0001 0.00014281272888184
SELECT * FROM pages WHERE id = '447'
351 0.0001 0.00014591217041016
SELECT * FROM pages WHERE id = '448'
352 0.0001 0.00014686584472656
SELECT * FROM pages WHERE id = '455'
353 0.0002 0.0001528263092041
SELECT * FROM pages WHERE id = '456'
354 0.0001 0.0001380443572998
SELECT * FROM pages WHERE id = '459'
355 0.0002 0.00015497207641602
SELECT * FROM pages WHERE id = '460'
356 0.0001 0.00014591217041016
SELECT * FROM pages WHERE id = '462'
357 0.0002 0.00015115737915039
SELECT * FROM sideboxes_pages WHERE sidebox_id = '32'
358 0.0002 0.00017094612121582
SELECT * FROM pages WHERE id = '153'
359 0.0002 0.0001990795135498
SELECT * FROM pages WHERE id = '182'
360 0.0001 0.00014686584472656
SELECT * FROM pages WHERE id = '238'
361 0.0001 0.00014114379882812
SELECT * FROM pages WHERE id = '240'
362 0.0001 0.00013589859008789
SELECT * FROM pages WHERE id = '242'
363 0.0001 0.0001380443572998
SELECT * FROM pages WHERE id = '252'
364 0.0001 0.0001370906829834
SELECT * FROM pages WHERE id = '253'
365 0.0001 0.00013899803161621
SELECT * FROM pages WHERE id = '262'
366 0.0001 0.00013589859008789
SELECT * FROM pages WHERE id = '267'
367 0.0001 0.00014281272888184
SELECT * FROM pages WHERE id = '420'
368 0.0001 0.00013208389282227
SELECT value FROM parameters WHERE parameter = 'GOOGLE_SITE_KEY' 
369 0.0001 0.00012707710266113
SELECT value FROM parameters WHERE parameter = 'GOOGLE_SECRET_KEY' 
370 0.0001 0.00011992454528809
SELECT value FROM parameters WHERE parameter = 'GOOGLE_RECAPTCHA_TYPE' 
371 0.0013 0.0013480186462402
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
372 0.0002 0.00018405914306641
SELECT value FROM parameters WHERE parameter = 'GOOGLE_SITE_KEY' 
373 0.0001 0.0001220703125
SELECT value FROM parameters WHERE parameter = 'GOOGLE_SECRET_KEY' 
374 0.0001 0.00011897087097168
SELECT value FROM parameters WHERE parameter = 'GOOGLE_RECAPTCHA_TYPE' 
375 0.0003 0.00026392936706543
SELECT * FROM products WHERE pagename = 'p2m-firestorm-1-4x19-thermal-monoculars'
376 0.0002 0.00020694732666016
SELECT * FROM manufacturers WHERE id = '348'
377 0.0007 0.00073099136352539
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '348'
378 0.0001 0.00011897087097168
SELECT filename FROM manufacturerimages WHERE manufacturer_id = '348' LIMIT 1
379 0.0007 0.00066089630126953
SELECT pagename, id FROM products p WHERE manufacturer_id = '348' ORDER BY RAND() LIMIT 1
380 0.0004 0.00035285949707031
SELECT * FROM productimages WHERE product_id = '264565' ORDER BY sortorder ASC
381 0.0006 0.0006401538848877
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '348'
382 0.0007 0.00068807601928711
SELECT COUNT(DISTINCT(p.id)) FROM products p
				WHERE p.manufacturer_id = '348'
				  AND p.hidden = 0
				  AND p.enabled = 1
				  AND p.parent_id = 0 
383 0.0001 0.00013399124145508
SELECT * FROM manufacturerimages WHERE manufacturer_id = '348'
384 0.0001 0.00013494491577148
SELECT category_id FROM products_categories WHERE product_id = '414233'
385 0.0002 0.00022411346435547
SELECT * FROM categories WHERE id = '89'
386 0.0019 0.0018990039825439
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
387 0.0001 0.00012612342834473
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 89
388 0.0003 0.00025296211242676
SELECT id FROM categories WHERE parent_id = '89'
389 0.0019 0.001896858215332
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 
390 0.0002 0.00015783309936523
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (89)
				  AND p.disabled = 0 
391 0.0002 0.00016283988952637
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 
392 0.0002 0.00017213821411133
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '89'
393 0.0002 0.00023007392883301
SELECT * FROM productimages WHERE product_id = '414233' ORDER BY sortorder ASC
394 0.0002 0.0002140998840332
SELECT * FROM product_image_select WHERE product_id = '414233'
395 0.0001 0.00012397766113281
SELECT * FROM productcustomimages WHERE product_id = '414233'
396 0.0001 0.0001220703125
SELECT * FROM productfeeds WHERE product_id = '414233' ORDER BY item_date DESC
397 0.0003 0.00034999847412109
SELECT a.name, n.displayname, a.value, n.units, n.valuetype FROM productattributes a, productattributenames n WHERE product_id = '414233' AND a.name = n.originalname AND n.display = 1 AND n.hidden = 0
398 0.0003 0.00030303001403809
SELECT DISTINCT(pt.tag_id) FROM product_tags pt, tags t WHERE pt.tag_id = t.id AND pt.product_id = '414233' AND t.hidden = 0 AND display_product = 1
399 0.0001 0.00014400482177734
SELECT * FROM tags WHERE id = '4638'
400 0.0013 0.0012850761413574
SELECT COUNT(DISTINCT(p.id)) FROM products p, product_tags t
				WHERE p.id = t.product_id
				  AND t.tag_id = '4638'
				  AND p.parent_id = 0
				  AND p.enabled = 1
				  AND p.hidden = 0
401 0.0013 0.0012550354003906
SELECT COUNT(DISTINCT(p.id)) FROM products p, product_tags t
				WHERE p.id = t.product_id
				  AND t.tag_id = '4638'
				  AND p.parent_id = 0
				  AND hidden = 0
				  AND enabled = 1 
402 0.0013 0.0012879371643066
SELECT p.id FROM products p, product_tags t WHERE p.id = t.product_id AND t.tag_id = '4638' AND p.hidden = 0 AND p.salesrank > 0 AND (p.price > 0 OR p.parent = 1) ORDER BY p.salesrank ASC LIMIT 1
403 0.0003 0.0002748966217041
SELECT * FROM productimages WHERE product_id = '411671' ORDER BY sortorder ASC
404 0.0004 0.00040698051452637
SELECT * FROM productamazoncontent WHERE product_id = '414233'
405 0.0036 0.0035998821258545
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '414233' AND a.name = n.originalname
406 0.0002 0.00019216537475586
SELECT * FROM productoffers WHERE product_id = '414233' AND merchantid = 'ATVPDKIKX0DER'
407 0.0002 0.00020003318786621
SELECT * FROM productoffers
                WHERE product_id = '414233' AND price > 0
                ORDER BY price ASC LIMIT 1
408 0.0002 0.00017595291137695
SELECT * FROM productoffers
                WHERE product_id = 414233
                ORDER BY price ASC LIMIT 1
409 0.0003 0.00025606155395508
SELECT value FROM productattributes
                WHERE product_id = '414233'
                AND name = 'ListPriceAmount'
410 0.0005 0.00046896934509277
SELECT value FROM productattributes WHERE product_id = '414233' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
411 0.2327 0.2326500415802
SELECT *, MATCH (description, keyfeatures, title) AGAINST ('firestorm' IN BOOLEAN MODE) AS `searchrelevance` FROM products WHERE MATCH (description, keyfeatures, title) AGAINST ('firestorm' IN BOOLEAN MODE) AND 414233 <> 0 AND enabled = 1 AND hidden = 0 AND offers > 0 AND parent_id = 0 ORDER BY `searchrelevance` LIMIT 6
412 0.2359 0.23588585853577
SELECT *, MATCH (description, keyfeatures, title) AGAINST ('thermal' IN BOOLEAN MODE) AS `searchrelevance` FROM products WHERE MATCH (description, keyfeatures, title) AGAINST ('thermal' IN BOOLEAN MODE) AND 414233 <> 0 AND enabled = 1 AND hidden = 0 AND offers > 0 AND parent_id = 0 ORDER BY `searchrelevance` LIMIT 6
413 0.0004 0.00037693977355957
SELECT * FROM productimages WHERE product_id = '173787' ORDER BY sortorder ASC
414 0.0002 0.00023388862609863
SELECT * FROM product_image_select WHERE product_id = '173787'
415 0.0002 0.0001530647277832
SELECT * FROM productcustomimages WHERE product_id = '173787'
416 0.0019 0.0019400119781494
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '173787' AND a.name = n.originalname
417 0.0002 0.00020098686218262
SELECT * FROM productoffers WHERE product_id = '173787' AND merchantid = 'ATVPDKIKX0DER'
418 0.0002 0.00022482872009277
SELECT * FROM productoffers
                WHERE product_id = '173787' AND price > 0
                ORDER BY price ASC LIMIT 1
419 0.0004 0.00037813186645508
SELECT value FROM productattributes WHERE product_id = '173787' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
420 0.0001 0.00014996528625488
UPDATE products SET price = '1171828' WHERE id = '173787'
421 0.0006 0.00064396858215332
SELECT * FROM productimages WHERE product_id = '246245' ORDER BY sortorder ASC
422 0.0002 0.00024199485778809
SELECT * FROM product_image_select WHERE product_id = '246245'
423 0.0001 0.00013589859008789
SELECT * FROM productcustomimages WHERE product_id = '246245'
424 0.0023 0.0023419857025146
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '246245' AND a.name = n.originalname
425 0.0002 0.0001988410949707
SELECT * FROM productoffers WHERE product_id = '246245' AND merchantid = 'ATVPDKIKX0DER'
426 0.0002 0.00022196769714355
SELECT * FROM productoffers
                WHERE product_id = '246245' AND price > 0
                ORDER BY price ASC LIMIT 1
427 0.0004 0.00037288665771484
SELECT value FROM productattributes WHERE product_id = '246245' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
428 0.0001 0.00014519691467285
UPDATE products SET price = '184900' WHERE id = '246245'
429 0.0004 0.00042510032653809
SELECT * FROM productimages WHERE product_id = '171937' ORDER BY sortorder ASC
430 0.0002 0.0002288818359375
SELECT * FROM product_image_select WHERE product_id = '171937'
431 0.0001 0.00013494491577148
SELECT * FROM productcustomimages WHERE product_id = '171937'
432 0.0019 0.0018899440765381
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '171937' AND a.name = n.originalname
433 0.0002 0.00020313262939453
SELECT * FROM productoffers WHERE product_id = '171937' AND merchantid = 'ATVPDKIKX0DER'
434 0.0002 0.0002140998840332
SELECT * FROM productoffers
                WHERE product_id = '171937' AND price > 0
                ORDER BY price ASC LIMIT 1
435 0.0004 0.00036501884460449
SELECT value FROM productattributes WHERE product_id = '171937' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
436 0.0001 0.00013494491577148
UPDATE products SET price = '33121' WHERE id = '171937'
437 0.0003 0.00029397010803223
SELECT * FROM productimages WHERE product_id = '258606' ORDER BY sortorder ASC
438 0.0002 0.00022101402282715
SELECT * FROM product_image_select WHERE product_id = '258606'
439 0.0001 0.00013399124145508
SELECT * FROM productcustomimages WHERE product_id = '258606'
440 0.0030 0.0029768943786621
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '258606' AND a.name = n.originalname
441 0.0002 0.00019598007202148
SELECT * FROM productoffers WHERE product_id = '258606' AND merchantid = 'ATVPDKIKX0DER'
442 0.0002 0.00021696090698242
SELECT * FROM productoffers
                WHERE product_id = '258606' AND price > 0
                ORDER BY price ASC LIMIT 1
443 0.0002 0.00021195411682129
SELECT * FROM productoffers
                WHERE product_id = 258606
                ORDER BY price ASC LIMIT 1
444 0.0003 0.00034213066101074
SELECT value FROM productattributes WHERE product_id = '258606' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
445 0.0001 0.00013303756713867
UPDATE products SET price = '132794' WHERE id = '258606'
446 0.0006 0.00062012672424316
SELECT * FROM productimages WHERE product_id = '171938' ORDER BY sortorder ASC
447 0.0002 0.00022697448730469
SELECT * FROM product_image_select WHERE product_id = '171938'
448 0.0001 0.00014805793762207
SELECT * FROM productcustomimages WHERE product_id = '171938'
449 0.0026 0.0025761127471924
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '171938' AND a.name = n.originalname
450 0.0002 0.00021100044250488
SELECT * FROM productoffers WHERE product_id = '171938' AND merchantid = 'ATVPDKIKX0DER'
451 0.0002 0.0002291202545166
SELECT * FROM productoffers
                WHERE product_id = '171938' AND price > 0
                ORDER BY price ASC LIMIT 1
452 0.0004 0.00040102005004883
SELECT value FROM productattributes WHERE product_id = '171938' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
453 0.0001 0.00013399124145508
UPDATE products SET price = '389500' WHERE id = '171938'
454 0.0003 0.00031709671020508
SELECT * FROM productimages WHERE product_id = '263433' ORDER BY sortorder ASC
455 0.0002 0.00022101402282715
SELECT * FROM product_image_select WHERE product_id = '263433'
456 0.0001 0.00013399124145508
SELECT * FROM productcustomimages WHERE product_id = '263433'
457 0.0027 0.0027339458465576
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '263433' AND a.name = n.originalname
458 0.0002 0.00020194053649902
SELECT * FROM productoffers WHERE product_id = '263433' AND merchantid = 'ATVPDKIKX0DER'
459 0.0002 0.00023102760314941
SELECT * FROM productoffers
                WHERE product_id = '263433' AND price > 0
                ORDER BY price ASC LIMIT 1
460 0.0004 0.00043916702270508
SELECT value FROM productattributes WHERE product_id = '263433' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
461 0.0001 0.0001368522644043
UPDATE products SET price = '399500' WHERE id = '263433'
462 0.0002 0.00018191337585449
SELECT value FROM parameters WHERE parameter = 'EBAY_CACHE_TIME' 
463 0.0001 0.00013899803161621
SELECT value FROM parameters WHERE parameter = 'EBAY_APP_ID' 
464 0.0001 0.00013613700866699
SELECT value FROM parameters WHERE parameter = 'EBAY_TRACKING_ID' 
465 0.0001 0.00013303756713867
SELECT value FROM parameters WHERE parameter = 'EBAY_NETWORK_ID' 
466 0.0001 0.00013303756713867
SELECT value FROM parameters WHERE parameter = 'EBAY_LOCALE' 
467 0.0001 0.00013089179992676
SELECT value FROM parameters WHERE parameter = 'EBAY_AUTH_TOKEN' 
468 0.0002 0.00015020370483398
SELECT * FROM ebay_locale_details WHERE cur_code = 'USD' 
469 0.1855 0.18545985221863
SELECT * FROM ebay_products_cache WHERE cachekey = 'bf9bdc2ec7dd4c2161868cfda9b42655' 
470 0.0003 0.0002601146697998
SELECT value FROM parameters WHERE parameter = 'EBAY_APP_ID' 
471 0.0001 0.00014185905456543
SELECT value FROM parameters WHERE parameter = 'EBAY_TRACKING_ID' 
472 0.0001 0.00014901161193848
SELECT value FROM parameters WHERE parameter = 'EBAY_NETWORK_ID' 
473 0.0001 0.0001380443572998
SELECT value FROM parameters WHERE parameter = 'EBAY_LOCALE' 
474 0.0001 0.00013589859008789
SELECT value FROM parameters WHERE parameter = 'EBAY_AUTH_TOKEN' 
475 0.1841 0.18411207199097
SELECT * FROM ebay_products_cache WHERE cachekey = 'bf9bdc2ec7dd4c2161868cfda9b42655' 
476 0.0003 0.00030303001403809
SELECT value FROM parameters WHERE parameter = 'EBAY_APP_ID' 
477 0.0002 0.00015091896057129
SELECT value FROM parameters WHERE parameter = 'EBAY_TRACKING_ID' 
478 0.0001 0.00014901161193848
SELECT value FROM parameters WHERE parameter = 'EBAY_NETWORK_ID' 
479 0.0001 0.00013613700866699
SELECT value FROM parameters WHERE parameter = 'EBAY_LOCALE' 
480 0.0001 0.00014400482177734
SELECT value FROM parameters WHERE parameter = 'EBAY_AUTH_TOKEN' 
481 0.1816 0.18158006668091
SELECT * FROM ebay_products_cache WHERE cachekey = 'bf9bdc2ec7dd4c2161868cfda9b42655' 
482 0.0003 0.00026202201843262
SELECT value FROM parameters WHERE parameter = 'EBAY_APP_ID' 
483 0.0001 0.00012707710266113
SELECT value FROM parameters WHERE parameter = 'EBAY_TRACKING_ID' 
484 0.0001 0.0001218318939209
SELECT value FROM parameters WHERE parameter = 'EBAY_NETWORK_ID' 
485 0.0001 0.00011897087097168
SELECT value FROM parameters WHERE parameter = 'EBAY_LOCALE' 
486 0.0001 0.00012016296386719
SELECT value FROM parameters WHERE parameter = 'EBAY_AUTH_TOKEN' 
487 0.1812 0.18124890327454
SELECT * FROM ebay_products_cache WHERE cachekey = 'bf9bdc2ec7dd4c2161868cfda9b42655' 
488 0.0003 0.00027608871459961
SELECT value FROM parameters WHERE parameter = 'EBAY_APP_ID' 
489 0.0001 0.00012683868408203
SELECT value FROM parameters WHERE parameter = 'EBAY_TRACKING_ID' 
490 0.0001 0.00012111663818359
SELECT value FROM parameters WHERE parameter = 'EBAY_NETWORK_ID' 
491 0.0001 0.00011897087097168
SELECT value FROM parameters WHERE parameter = 'EBAY_LOCALE' 
492 0.0001 0.00011801719665527
SELECT value FROM parameters WHERE parameter = 'EBAY_AUTH_TOKEN' 
493 0.1919 0.19187617301941
SELECT * FROM ebay_products_cache WHERE cachekey = 'bf9bdc2ec7dd4c2161868cfda9b42655' 
494 0.0003 0.00028395652770996
SELECT value FROM parameters WHERE parameter = 'EBAY_APP_ID' 
495 0.0001 0.00012993812561035
SELECT value FROM parameters WHERE parameter = 'EBAY_TRACKING_ID' 
496 0.0001 0.00012302398681641
SELECT value FROM parameters WHERE parameter = 'EBAY_NETWORK_ID' 
497 0.0001 0.00012302398681641
SELECT value FROM parameters WHERE parameter = 'EBAY_LOCALE' 
498 0.0001 0.00012302398681641
SELECT value FROM parameters WHERE parameter = 'EBAY_AUTH_TOKEN' 
499 0.1873 0.18734216690063
SELECT * FROM ebay_products_cache WHERE cachekey = 'bf9bdc2ec7dd4c2161868cfda9b42655' 
500 0.0003 0.00028395652770996
SELECT value FROM parameters WHERE parameter = 'EBAY_APP_ID' 
501 0.0001 0.00013208389282227
SELECT value FROM parameters WHERE parameter = 'EBAY_TRACKING_ID' 
502 0.0001 0.00012397766113281
SELECT value FROM parameters WHERE parameter = 'EBAY_NETWORK_ID' 
503 0.0001 0.00012111663818359
SELECT value FROM parameters WHERE parameter = 'EBAY_LOCALE' 
504 0.0001 0.00011897087097168
SELECT value FROM parameters WHERE parameter = 'EBAY_AUTH_TOKEN' 
505 0.1819 0.18194103240967
SELECT * FROM ebay_products_cache WHERE cachekey = 'bf9bdc2ec7dd4c2161868cfda9b42655' 
506 0.0003 0.0002589225769043
SELECT value FROM parameters WHERE parameter = 'EBAY_APP_ID' 
507 0.0001 0.00012803077697754
SELECT value FROM parameters WHERE parameter = 'EBAY_TRACKING_ID' 
508 0.0001 0.0001220703125
SELECT value FROM parameters WHERE parameter = 'EBAY_NETWORK_ID' 
509 0.0001 0.00013399124145508
SELECT value FROM parameters WHERE parameter = 'EBAY_LOCALE' 
510 0.0001 0.00011992454528809
SELECT value FROM parameters WHERE parameter = 'EBAY_AUTH_TOKEN' 
511 0.1847 0.18474006652832
SELECT * FROM ebay_products_cache WHERE cachekey = 'bf9bdc2ec7dd4c2161868cfda9b42655' 
512 0.0003 0.00027012825012207
SELECT value FROM parameters WHERE parameter = 'EBAY_APP_ID' 
513 0.0001 0.0001370906829834
SELECT value FROM parameters WHERE parameter = 'EBAY_TRACKING_ID' 
514 0.0001 0.00012516975402832
SELECT value FROM parameters WHERE parameter = 'EBAY_NETWORK_ID' 
515 0.0001 0.00012016296386719
SELECT value FROM parameters WHERE parameter = 'EBAY_LOCALE' 
516 0.0001 0.00011897087097168
SELECT value FROM parameters WHERE parameter = 'EBAY_AUTH_TOKEN' 
517 0.1809 0.18092894554138
SELECT * FROM ebay_products_cache WHERE cachekey = 'bf9bdc2ec7dd4c2161868cfda9b42655' 
518 0.0002 0.00022101402282715
SELECT id FROM ebay_products WHERE itemid = '323188190358' 
519 0.0001 0.00010395050048828
SELECT id FROM ebay_products WHERE itemid = '362559295046' 
520 0.0001 9.8943710327148E-5
SELECT id FROM ebay_products WHERE itemid = '352440711334' 
521 0.0001 0.0001060962677002
SELECT id FROM ebay_products WHERE itemid = '223067218855' 
522 0.0001 9.918212890625E-5
SELECT id FROM ebay_products WHERE itemid = '303189335648' 
523 0.0001 9.608268737793E-5
SELECT id FROM ebay_products WHERE itemid = '253257691372' 
524 0.0001 9.5844268798828E-5
SELECT id FROM ebay_products WHERE itemid = '263320984997' 
525 0.0001 9.608268737793E-5
SELECT id FROM ebay_products WHERE itemid = '253257704053' 
526 0.0001 9.4890594482422E-5
SELECT id FROM ebay_products WHERE itemid = '162691218389' 
527 0.0001 9.4890594482422E-5
SELECT id FROM ebay_products WHERE itemid = '153493055828' 
528 0.0004 0.0003969669342041
UPDATE ebay_products_cache SET products = 'a:11:{i:0;a:14:{s:6:\"itemId\";s:12:\"323188190358\";s:11:\"viewItemURL\";s:137:\"http://rover.ebay.com/rover/1/711-53200-19255-0/1?ff3=2&toolid=10041&campid=5338345274&customid=&lgeo=1&vectorid=229466&item=323188190358\";s:10:\"galleryURL\";s:58:\"//thumbs3.ebaystatic.com/m/mQfieaFf_h3LGUWBEjfSrgw/140.jpg\";s:5:\"title\";s:79:\"1080P 2M 8 Pin Lightning to HDMI TV AV Adapter Cable for iPhone 6 6S 7 8 Plus X\";s:11:\"listingType\";s:10:\"FixedPrice\";s:20:\"conditionDisplayName\";s:3:\"New\";s:8:\"timeLeft\";s:14:\"P10DT23H39M28S\";s:15:\"returnsAccepted\";s:4:\"true\";s:19:\"originalRetailPrice\";i:0;s:12:\"currentPrice\";s:5:\"11.99\";s:15:\"shipToLocations\";s:9:\"Worldwide\";s:12:\"handlingTime\";s:1:\"1\";s:10:\"variations\";s:5:\"false\";s:8:\"is_exist\";i:0;}i:1;a:14:{s:6:\"itemId\";s:12:\"362559295046\";s:11:\"viewItemURL\";s:137:\"http://rover.ebay.com/rover/1/711-53200-19255-0/1?ff3=2&toolid=10041&campid=5338345274&customid=&lgeo=1&vectorid=229466&item=362559295046\";s:10:\"galleryURL\";s:58:\"//thumbs3.ebaystatic.com/m/mb2UOdFyASKzLNM0LyCf4fQ/140.jpg\";s:5:\"title\";s:79:\"1080P 2M 8 Pin Lightning to HDMI TV AV Adapter Cable for iPhone 6 6S 7 8 Plus X\";s:11:\"listingType\";s:10:\"FixedPrice\";s:20:\"conditionDisplayName\";s:8:\"Open box\";s:8:\"timeLeft\";s:13:\"P29DT8H36M35S\";s:15:\"returnsAccepted\";s:4:\"true\";s:19:\"originalRetailPrice\";i:0;s:12:\"currentPrice\";s:4:\"9.59\";s:15:\"shipToLocations\";s:9:\"Worldwide\";s:12:\"handlingTime\";s:1:\"1\";s:10:\"variations\";s:5:\"false\";s:8:\"is_exist\";i:0;}i:2;a:14:{s:6:\"itemId\";s:12:\"352440711334\";s:11:\"viewItemURL\";s:137:\"http://rover.ebay.com/rover/1/711-53200-19255-0/1?ff3=2&toolid=10041&campid=5338345274&customid=&lgeo=1&vectorid=229466&item=352440711334\";s:10:\"galleryURL\";s:58:\"//thumbs3.ebaystatic.com/m/m-9Y6w34UlCBzloJwbwhSDQ/140.jpg\";s:5:\"title\";s:76:\"1080P 2M Lightning to HDMI TV AV Adapter Cable for iPhone 5S 6 6S 7 8 Plus X\";s:11:\"listingType\";s:10:\"FixedPrice\";s:20:\"conditionDisplayName\";s:3:\"New\";s:8:\"timeLeft\";s:11:\"P3DT2H25M8S\";s:15:\"returnsAccepted\";s:4:\"true\";s:19:\"originalRetailPrice\";s:5:\"12.99\";s:12:\"currentPrice\";s:4:\"9.99\";s:15:\"shipToLocations\";s:9:\"Worldwide\";s:12:\"handlingTime\";s:1:\"1\";s:10:\"variations\";s:5:\"false\";s:8:\"is_exist\";i:0;}i:3;a:14:{s:6:\"itemId\";s:12:\"223067218855\";s:11:\"viewItemURL\";s:137:\"http://rover.ebay.com/rover/1/711-53200-19255-0/1?ff3=2&toolid=10041&campid=5338345274&customid=&lgeo=1&vectorid=229466&item=223067218855\";s:10:\"galleryURL\";s:58:\"//thumbs4.ebaystatic.com/m/mCJ5wZFg8H2N5a_OS3nG6-g/140.jpg\";s:5:\"title\";s:80:\"1080P 2M USB 3.1 Type-C To HDMI HD TV Cable Adapter for Samsung S8 LG G5 MATE 10\";s:11:\"listingType\";s:10:\"FixedPrice\";s:20:\"conditionDisplayName\";s:3:\"New\";s:8:\"timeLeft\";s:14:\"P26DT21H31M59S\";s:15:\"returnsAccepted\";s:4:\"true\";s:19:\"originalRetailPrice\";i:0;s:12:\"currentPrice\";s:5:\"10.99\";s:15:\"shipToLocations\";s:9:\"Worldwide\";s:12:\"handlingTime\";s:1:\"1\";s:10:\"variations\";s:5:\"false\";s:8:\"is_exist\";i:0;}i:4;a:14:{s:6:\"itemId\";s:12:\"303189335648\";s:11:\"viewItemURL\";s:137:\"http://rover.ebay.com/rover/1/711-53200-19255-0/1?ff3=2&toolid=10041&campid=5338345274&customid=&lgeo=1&vectorid=229466&item=303189335648\";s:10:\"galleryURL\";s:58:\"//thumbs1.ebaystatic.com/m/m2TUWnNHXiZABivHIxEVsvQ/140.jpg\";s:5:\"title\";s:79:\"1080P 2M Lightning to HDMI TV AV Adapter Cable for iPhone 6 6S 7 8 Plus X Xr Xs\";s:11:\"listingType\";s:7:\"Auction\";s:20:\"conditionDisplayName\";s:3:\"New\";s:8:\"timeLeft\";s:12:\"P3DT2H13M53S\";s:15:\"returnsAccepted\";s:4:\"true\";s:19:\"originalRetailPrice\";i:0;s:12:\"currentPrice\";s:4:\"2.25\";s:15:\"shipToLocations\";s:9:\"Worldwide\";s:12:\"handlingTime\";s:1:\"1\";s:10:\"variations\";s:5:\"false\";s:8:\"is_exist\";i:0;}i:5;a:14:{s:6:\"itemId\";s:12:\"253257691372\";s:11:\"viewItemURL\";s:137:\"http://rover.ebay.com/rover/1/711-53200-19255-0/1?ff3=2&toolid=10041&campid=5338345274&customid=&lgeo=1&vectorid=229466&item=253257691372\";s:10:\"galleryURL\";s:58:\"//thumbs1.ebaystatic.com/m/mYZPsAR9-mp3L0h8mIDVapA/140.jpg\";s:5:\"title\";s:76:\"P2M UNIVERSAL ALUMINUM PIPE HOSE CLAMP INTAKE BLACK 2\" 2.0\" - 58mm 59mm 60mm\";s:11:\"listingType\";s:10:\"FixedPrice\";s:20:\"conditionDisplayName\";s:3:\"New\";s:8:\"timeLeft\";s:14:\"P19DT14H31M36S\";s:15:\"returnsAccepted\";s:4:\"true\";s:19:\"originalRetailPrice\";i:0;s:12:\"currentPrice\";s:4:\"8.55\";s:15:\"shipToLocations\";s:9:\"Worldwide\";s:12:\"handlingTime\";s:1:\"1\";s:10:\"variations\";s:5:\"false\";s:8:\"is_exist\";i:0;}i:6;a:14:{s:6:\"itemId\";s:12:\"263320984997\";s:11:\"viewItemURL\";s:137:\"http://rover.ebay.com/rover/1/711-53200-19255-0/1?ff3=2&toolid=10041&campid=5338345274&customid=&lgeo=1&vectorid=229466&item=263320984997\";s:10:\"galleryURL\";s:58:\"//thumbs2.ebaystatic.com/m/mg5m-wYuGbHB9aw69pEnlUA/140.jpg\";s:5:\"title\";s:77:\"P2M UNIVERSAL ALUMINUM PIPE HOSE CLAMP INTAKE RED 2.5\" 2.50\" - 71mm 72mm 73mm\";s:11:\"listingType\";s:10:\"FixedPrice\";s:20:\"conditionDisplayName\";s:3:\"New\";s:8:\"timeLeft\";s:12:\"P19DT15H4M5S\";s:15:\"returnsAccepted\";s:4:\"true\";s:19:\"originalRetailPrice\";i:0;s:12:\"currentPrice\";s:4:\"8.55\";s:15:\"shipToLocations\";s:9:\"Worldwide\";s:12:\"handlingTime\";s:1:\"1\";s:10:\"variations\";s:5:\"false\";s:8:\"is_exist\";i:0;}i:7;a:14:{s:6:\"itemId\";s:12:\"253257704053\";s:11:\"viewItemURL\";s:137:\"http://rover.ebay.com/rover/1/711-53200-19255-0/1?ff3=2&toolid=10041&campid=5338345274&customid=&lgeo=1&vectorid=229466&item=253257704053\";s:10:\"galleryURL\";s:58:\"//thumbs2.ebaystatic.com/m/m8i9Sxha2kO51AC9JvLUVvQ/140.jpg\";s:5:\"title\";s:79:\"P2M UNIVERSAL ALUMINUM PIPE HOSE CLAMP INTAKE BLACK 2.5\" 2.50\" - 71mm 72mm 73mm\";s:11:\"listingType\";s:10:\"FixedPrice\";s:20:\"conditionDisplayName\";s:3:\"New\";s:8:\"timeLeft\";s:13:\"P19DT14H42M3S\";s:15:\"returnsAccepted\";s:4:\"true\";s:19:\"originalRetailPrice\";i:0;s:12:\"currentPrice\";s:4:\"8.55\";s:15:\"shipToLocations\";s:9:\"Worldwide\";s:12:\"handlingTime\";s:1:\"1\";s:10:\"variations\";s:5:\"false\";s:8:\"is_exist\";i:0;}i:8;a:14:{s:6:\"itemId\";s:12:\"162691218389\";s:11:\"viewItemURL\";s:137:\"http://rover.ebay.com/rover/1/711-53200-19255-0/1?ff3=2&toolid=10041&campid=5338345274&customid=&lgeo=1&vectorid=229466&item=162691218389\";s:10:\"galleryURL\";s:58:\"//thumbs2.ebaystatic.com/m/mzoZfSkVbSeaedoB4soXCoA/140.jpg\";s:5:\"title\";s:80:\"P2M Phase 2 Sirudua 7 Layer Exhaust Manifold Gasket 240sx S13 S14 SR20DET SR New\";s:11:\"listingType\";s:14:\"StoreInventory\";s:20:\"conditionDisplayName\";s:3:\"New\";s:8:\"timeLeft\";s:12:\"P4DT9H32M24S\";s:15:\"returnsAccepted\";s:4:\"true\";s:19:\"originalRetailPrice\";i:0;s:12:\"currentPrice\";s:5:\"15.00\";s:15:\"shipToLocations\";s:9:\"Worldwide\";s:12:\"handlingTime\";s:1:\"1\";s:10:\"variations\";s:5:\"false\";s:8:\"is_exist\";i:0;}i:9;a:14:{s:6:\"itemId\";s:12:\"153493055828\";s:11:\"viewItemURL\";s:137:\"http://rover.ebay.com/rover/1/711-53200-19255-0/1?ff3=2&toolid=10041&campid=5338345274&customid=&lgeo=1&vectorid=229466&item=153493055828\";s:10:\"galleryURL\";s:58:\"//thumbs1.ebaystatic.com/m/mKjrZTQ2xAx8OezYsoRkw-Q/140.jpg\";s:5:\"title\";s:77:\"P2M Clear Front Side Corner Lights Lamps Set Silvia 240SX S14 Zenki 95-96 New\";s:11:\"listingType\";s:14:\"StoreInventory\";s:20:\"conditionDisplayName\";s:3:\"New\";s:8:\"timeLeft\";s:14:\"P29DT14H24M10S\";s:15:\"returnsAccepted\";s:4:\"true\";s:19:\"originalRetailPrice\";i:0;s:12:\"currentPrice\";s:5:\"53.50\";s:15:\"shipToLocations\";s:9:\"Worldwide\";s:12:\"handlingTime\";s:1:\"1\";s:10:\"variations\";s:5:\"false\";s:8:\"is_exist\";i:0;}i:10;s:185:\"http://rover.ebay.com/rover/1/711-53200-19255-0/1?ff3=4&toolid=10041&campid=5338345274&customid=&lgeo=1&mpre=http%3A%2F%2Fwww.ebay.com%2Fsch%2Fi.html%3F_nkw%3DP2M%26_ipg%3D10%26_pgn%3D1\";}', expiretime = '1560756232' WHERE id = '66654'
529 0.0002 0.00015997886657715
SELECT id,asin FROM products WHERE parent_id = 414233
530 0.0003 0.00031900405883789
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '414233' ORDER BY timestamp DESC
531 0.0001 0.00014114379882812
SELECT category_id FROM products_categories WHERE product_id = '414233'
532 0.0002 0.00021195411682129
SELECT * FROM categories WHERE id = '89'
533 0.0020 0.0019669532775879
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
534 0.0001 0.0001227855682373
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 89
535 0.0003 0.00025010108947754
SELECT id FROM categories WHERE parent_id = '89'
536 0.0019 0.0018980503082275
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 
537 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 (89)
				  AND p.disabled = 0 
538 0.0002 0.00015616416931152
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 
539 0.0002 0.00017499923706055
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '89'
540 0.0036 0.0035810470581055
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '414233' AND a.name = n.originalname
541 0.0002 0.00019001960754395
SELECT * FROM productoffers WHERE product_id = '414233' AND merchantid = 'ATVPDKIKX0DER'
542 0.0002 0.00018787384033203
SELECT * FROM productoffers
                WHERE product_id = '414233' AND price > 0
                ORDER BY price ASC LIMIT 1
543 0.0002 0.00015997886657715
SELECT * FROM productoffers
                WHERE product_id = 414233
                ORDER BY price ASC LIMIT 1
544 0.0002 0.00023221969604492
SELECT value FROM productattributes
                WHERE product_id = '414233'
                AND name = 'ListPriceAmount'
545 0.0002 0.00020503997802734
SELECT * FROM products WHERE id = '414233'
546 0.0005 0.00047779083251953
SELECT value FROM productattributes WHERE product_id = '414233' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
547 0.0034 0.003432035446167
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '414233' AND a.name = n.originalname
548 0.0002 0.0001838207244873
SELECT * FROM productoffers WHERE product_id = '414233' AND merchantid = 'ATVPDKIKX0DER'
549 0.0002 0.00017690658569336
SELECT * FROM productoffers
                WHERE product_id = '414233' AND price > 0
                ORDER BY price ASC LIMIT 1
550 0.0002 0.00016188621520996
SELECT * FROM productoffers
                WHERE product_id = 414233
                ORDER BY price ASC LIMIT 1
551 0.0002 0.00023007392883301
SELECT value FROM productattributes
                WHERE product_id = '414233'
                AND name = 'ListPriceAmount'
552 0.0001 0.00013208389282227
SELECT category_id FROM products_categories WHERE product_id = '414233'
553 0.0001 0.00012111663818359
SELECT parent_id FROM categories WHERE id = '89'
554 0.0002 0.00020289421081543
SELECT * FROM categories WHERE id = '89'
555 0.0018 0.0018248558044434
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
556 0.0001 0.00012111663818359
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 89
557 0.0002 0.00024104118347168
SELECT id FROM categories WHERE parent_id = '89'
558 0.0019 0.0018761157989502
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 
559 0.0001 0.00014901161193848
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (89)
				  AND p.disabled = 0 
560 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 (89)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
561 0.0002 0.0001671314239502
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '89'
562 0.0002 0.00017189979553223
SELECT * FROM template_info WHERE templateuid = 'fsb-fluid'
563 0.0002 0.00015807151794434
SELECT * FROM pages WHERE id = 2
564 0.0001 0.0001380443572998
SELECT * FROM pages WHERE id = 4
565 0.0001 0.00013494491577148
SELECT * FROM pages WHERE id = 12
566 0.0001 0.00014996528625488
SELECT * FROM pages WHERE id = 10
567 0.0001 0.0001370906829834
SELECT * FROM pages WHERE id = 7
568 0.0001 0.00014114379882812
SELECT * FROM pages WHERE id = 18
569 0.0001 0.0001380443572998
SELECT * FROM pages WHERE id = 28
570 0.0001 0.00013899803161621
SELECT * FROM pages WHERE id = 13
571 0.0001 0.00013494491577148
SELECT * FROM pages WHERE id = 3
572 0.0436 0.043601989746094
SELECT p.id,p.parent_id, o.price FROM products p, productoffers o WHERE p.id = o.product_id AND p.parent_id = 0 AND hidden = 0 AND offers > 0 AND o.id IN (SELECT x.id FROM productoffers x WHERE x.product_id = p.id HAVING MIN(x.price)) ORDER BY p.title DESC LIMIT 24
573 0.0002 0.00023484230041504
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:1560756236;s:8:\"products\";a:6:{i:7;s:6:\"183732\";i:12;s:6:\"414825\";i:17;s:6:\"408078\";i:20;s:6:\"410949\";i:21;s:6:\"408079\";i:23;s:6:\"400044\";}}' WHERE id = '175'
574 0.0005 0.00046682357788086
SELECT * FROM products WHERE id IN (183732,414825,408078,410949,408079,400044) ORDER BY FIELD(id, 183732,414825,408078,410949,408079,400044 )
575 0.0002 0.00018405914306641
SELECT * FROM productimages WHERE product_id = '183732' ORDER BY sortorder ASC
576 0.0002 0.00020599365234375
SELECT * FROM product_image_select WHERE product_id = '183732'
577 0.0001 0.00012516975402832
SELECT * FROM productcustomimages WHERE product_id = '183732'
578 0.0027 0.0026969909667969
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '183732' AND a.name = n.originalname
579 0.0002 0.00018715858459473
SELECT * FROM productoffers WHERE product_id = '183732' AND merchantid = 'ATVPDKIKX0DER'
580 0.0002 0.0002129077911377
SELECT * FROM productoffers
                WHERE product_id = '183732' AND price > 0
                ORDER BY price ASC LIMIT 1
581 0.0004 0.00038695335388184
SELECT value FROM productattributes WHERE product_id = '183732' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
582 0.0001 0.00012397766113281
UPDATE products SET price = '38249' WHERE id = '183732'
583 0.0002 0.0002140998840332
SELECT * FROM productimages WHERE product_id = '414825' ORDER BY sortorder ASC
584 0.0002 0.00020909309387207
SELECT * FROM product_image_select WHERE product_id = '414825'
585 0.0001 0.00012087821960449
SELECT * FROM productcustomimages WHERE product_id = '414825'
586 0.0020 0.002047061920166
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '414825' AND a.name = n.originalname
587 0.0002 0.00019311904907227
SELECT * FROM productoffers WHERE product_id = '414825' AND merchantid = 'ATVPDKIKX0DER'
588 0.0002 0.00021100044250488
SELECT * FROM productoffers
                WHERE product_id = '414825' AND price > 0
                ORDER BY price ASC LIMIT 1
589 0.0004 0.00036907196044922
SELECT value FROM productattributes WHERE product_id = '414825' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
590 0.0001 0.00011897087097168
UPDATE products SET price = '11999' WHERE id = '414825'
591 0.0002 0.00020503997802734
SELECT * FROM productimages WHERE product_id = '408078' ORDER BY sortorder ASC
592 0.0002 0.00020813941955566
SELECT * FROM product_image_select WHERE product_id = '408078'
593 0.0001 0.00013089179992676
SELECT * FROM productcustomimages WHERE product_id = '408078'
594 0.0031 0.00307297706604
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '408078' AND a.name = n.originalname
595 0.0002 0.0001828670501709
SELECT * FROM productoffers WHERE product_id = '408078' AND merchantid = 'ATVPDKIKX0DER'
596 0.0002 0.00019598007202148
SELECT * FROM productoffers
                WHERE product_id = '408078' AND price > 0
                ORDER BY price ASC LIMIT 1
597 0.0004 0.00041508674621582
SELECT value FROM productattributes WHERE product_id = '408078' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
598 0.0001 0.0001220703125
UPDATE products SET price = '23352' WHERE id = '408078'
599 0.0002 0.00017118453979492
SELECT * FROM productimages WHERE product_id = '410949' ORDER BY sortorder ASC
600 0.0002 0.00020408630371094
SELECT * FROM product_image_select WHERE product_id = '410949'
601 0.0001 0.00012016296386719
SELECT * FROM productcustomimages WHERE product_id = '410949'
602 0.0027 0.0026729106903076
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '410949' AND a.name = n.originalname
603 0.0002 0.00018501281738281
SELECT * FROM productoffers WHERE product_id = '410949' AND merchantid = 'ATVPDKIKX0DER'
604 0.0002 0.00020003318786621
SELECT * FROM productoffers
                WHERE product_id = '410949' AND price > 0
                ORDER BY price ASC LIMIT 1
605 0.0004 0.0003960132598877
SELECT value FROM productattributes WHERE product_id = '410949' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
606 0.0001 0.00011801719665527
UPDATE products SET price = '47995' WHERE id = '410949'
607 0.0002 0.00017404556274414
SELECT * FROM productimages WHERE product_id = '408079' ORDER BY sortorder ASC
608 0.0002 0.0001990795135498
SELECT * FROM product_image_select WHERE product_id = '408079'
609 0.0001 0.00013399124145508
SELECT * FROM productcustomimages WHERE product_id = '408079'
610 0.0032 0.0032148361206055
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '408079' AND a.name = n.originalname
611 0.0002 0.00019001960754395
SELECT * FROM productoffers WHERE product_id = '408079' AND merchantid = 'ATVPDKIKX0DER'
612 0.0002 0.00020098686218262
SELECT * FROM productoffers
                WHERE product_id = '408079' AND price > 0
                ORDER BY price ASC LIMIT 1
613 0.0004 0.00038909912109375
SELECT value FROM productattributes WHERE product_id = '408079' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
614 0.0001 0.0001220703125
UPDATE products SET price = '20106' WHERE id = '408079'
615 0.0002 0.00021505355834961
SELECT * FROM productimages WHERE product_id = '400044' ORDER BY sortorder ASC
616 0.0002 0.00020694732666016
SELECT * FROM product_image_select WHERE product_id = '400044'
617 0.0001 0.00012111663818359
SELECT * FROM productcustomimages WHERE product_id = '400044'
618 0.0028 0.0027928352355957
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '400044' AND a.name = n.originalname
619 0.0002 0.00018596649169922
SELECT * FROM productoffers WHERE product_id = '400044' AND merchantid = 'ATVPDKIKX0DER'
620 0.0002 0.0002140998840332
SELECT * FROM productoffers
                WHERE product_id = '400044' AND price > 0
                ORDER BY price ASC LIMIT 1
621 0.0004 0.00040602684020996
SELECT value FROM productattributes WHERE product_id = '400044' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
622 0.0001 0.00011920928955078
UPDATE products SET price = '16091' WHERE id = '400044'
623 0.0434 0.043381929397583
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
624 0.0002 0.0002281665802002
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:1560756236;s:8:\"products\";a:6:{i:2;s:6:\"290575\";i:7;s:6:\"183732\";i:9;s:6:\"103845\";i:10;s:6:\"370121\";i:12;s:6:\"414825\";i:13;s:6:\"407831\";}}' WHERE id = '177'
625 0.0004 0.0004270076751709
SELECT * FROM products WHERE id IN (290575,183732,103845,370121,414825,407831) ORDER BY FIELD(id, 290575,183732,103845,370121,414825,407831 )
626 0.0006 0.00058388710021973
SELECT * FROM productimages WHERE product_id = '290575' ORDER BY sortorder ASC
627 0.0002 0.00023102760314941
SELECT * FROM product_image_select WHERE product_id = '290575'
628 0.0001 0.00012683868408203
SELECT * FROM productcustomimages WHERE product_id = '290575'
629 0.0034 0.0034480094909668
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '290575' AND a.name = n.originalname
630 0.0002 0.00019693374633789
SELECT * FROM productoffers WHERE product_id = '290575' AND merchantid = 'ATVPDKIKX0DER'
631 0.0002 0.00020503997802734
SELECT * FROM productoffers
                WHERE product_id = '290575' AND price > 0
                ORDER BY price ASC LIMIT 1
632 0.0004 0.00043010711669922
SELECT value FROM productattributes WHERE product_id = '290575' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
633 0.0001 0.0001220703125
UPDATE products SET price = '549500' WHERE id = '290575'
634 0.0002 0.00017595291137695
SELECT * FROM productimages WHERE product_id = '183732' ORDER BY sortorder ASC
635 0.0002 0.00021004676818848
SELECT * FROM product_image_select WHERE product_id = '183732'
636 0.0001 0.00012087821960449
SELECT * FROM productcustomimages WHERE product_id = '183732'
637 0.0027 0.0026829242706299
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '183732' AND a.name = n.originalname
638 0.0002 0.00018405914306641
SELECT * FROM productoffers WHERE product_id = '183732' AND merchantid = 'ATVPDKIKX0DER'
639 0.0002 0.00019717216491699
SELECT * FROM productoffers
                WHERE product_id = '183732' AND price > 0
                ORDER BY price ASC LIMIT 1
640 0.0004 0.0003809928894043
SELECT value FROM productattributes WHERE product_id = '183732' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
641 0.0001 0.00012707710266113
UPDATE products SET price = '38249' WHERE id = '183732'
642 0.0002 0.00020003318786621
SELECT * FROM productimages WHERE product_id = '103845' ORDER BY sortorder ASC
643 0.0002 0.00020909309387207
SELECT * FROM product_image_select WHERE product_id = '103845'
644 0.0001 0.00012016296386719
SELECT * FROM productcustomimages WHERE product_id = '103845'
645 0.0024 0.0024209022521973
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '103845' AND a.name = n.originalname
646 0.0002 0.00018310546875
SELECT * FROM productoffers WHERE product_id = '103845' AND merchantid = 'ATVPDKIKX0DER'
647 0.0002 0.0001978874206543
SELECT * FROM productoffers
                WHERE product_id = '103845' AND price > 0
                ORDER BY price ASC LIMIT 1
648 0.0004 0.00036787986755371
SELECT value FROM productattributes WHERE product_id = '103845' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
649 0.0001 0.00012111663818359
UPDATE products SET price = '11900' WHERE id = '103845'
650 0.0002 0.00018811225891113
SELECT * FROM productimages WHERE product_id = '370121' ORDER BY sortorder ASC
651 0.0002 0.0002129077911377
SELECT * FROM product_image_select WHERE product_id = '370121'
652 0.0001 0.00012111663818359
SELECT * FROM productcustomimages WHERE product_id = '370121'
653 0.0027 0.0027470588684082
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '370121' AND a.name = n.originalname
654 0.0002 0.00018692016601562
SELECT * FROM productoffers WHERE product_id = '370121' AND merchantid = 'ATVPDKIKX0DER'
655 0.0002 0.00020194053649902
SELECT * FROM productoffers
                WHERE product_id = '370121' AND price > 0
                ORDER BY price ASC LIMIT 1
656 0.0004 0.00039505958557129
SELECT value FROM productattributes WHERE product_id = '370121' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
657 0.0001 0.00011897087097168
UPDATE products SET price = '9899' WHERE id = '370121'
658 0.0002 0.00020098686218262
SELECT * FROM productimages WHERE product_id = '414825' ORDER BY sortorder ASC
659 0.0002 0.0001990795135498
SELECT * FROM product_image_select WHERE product_id = '414825'
660 0.0001 0.00013279914855957
SELECT * FROM productcustomimages WHERE product_id = '414825'
661 0.0020 0.0020401477813721
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '414825' AND a.name = n.originalname
662 0.0002 0.00019097328186035
SELECT * FROM productoffers WHERE product_id = '414825' AND merchantid = 'ATVPDKIKX0DER'
663 0.0002 0.00021195411682129
SELECT * FROM productoffers
                WHERE product_id = '414825' AND price > 0
                ORDER BY price ASC LIMIT 1
664 0.0004 0.00036501884460449
SELECT value FROM productattributes WHERE product_id = '414825' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
665 0.0001 0.00012087821960449
UPDATE products SET price = '11999' WHERE id = '414825'
666 0.0002 0.00019598007202148
SELECT * FROM productimages WHERE product_id = '407831' ORDER BY sortorder ASC
667 0.0002 0.00020003318786621
SELECT * FROM product_image_select WHERE product_id = '407831'
668 0.0001 0.00012087821960449
SELECT * FROM productcustomimages WHERE product_id = '407831'
669 0.0035 0.0035009384155273
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '407831' AND a.name = n.originalname
670 0.0002 0.00018310546875
SELECT * FROM productoffers WHERE product_id = '407831' AND merchantid = 'ATVPDKIKX0DER'
671 0.0002 0.00019598007202148
SELECT * FROM productoffers
                WHERE product_id = '407831' AND price > 0
                ORDER BY price ASC LIMIT 1
672 0.0004 0.0004429817199707
SELECT value FROM productattributes WHERE product_id = '407831' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
673 0.0001 0.00012111663818359
UPDATE products SET price = '1293' WHERE id = '407831'
674 0.1054 0.10536599159241
SELECT p.id,p.parent_id, o.price FROM products p, productoffers o WHERE p.id = o.product_id AND p.parent_id = 0 AND hidden = 0 AND offers > 0 AND (SELECT COUNT(pi.id) FROM productimages pi WHERE pi.product_id = p.id) > 1 AND o.id IN (SELECT x.id FROM productoffers x WHERE x.product_id = p.id HAVING MIN(x.price)) ORDER BY p.title DESC LIMIT 24
675 0.0003 0.00028491020202637
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:1560756236;s:8:\"products\";a:6:{i:0;s:6:\"398315\";i:15;s:6:\"406758\";i:23;s:6:\"400044\";i:4;s:6:\"410588\";i:5;s:6:\"412927\";i:9;s:6:\"103845\";}}' WHERE id = '181'
676 0.0005 0.0004730224609375
SELECT * FROM products WHERE id IN (398315,406758,400044,410588,412927,103845) ORDER BY FIELD(id, 398315,406758,400044,410588,412927,103845 )
677 0.0002 0.00022101402282715
SELECT * FROM productimages WHERE product_id = '398315' ORDER BY sortorder ASC
678 0.0002 0.00022315979003906
SELECT * FROM product_image_select WHERE product_id = '398315'
679 0.0001 0.00012803077697754
SELECT * FROM productcustomimages WHERE product_id = '398315'
680 0.0025 0.0025179386138916
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '398315' AND a.name = n.originalname
681 0.0002 0.00019693374633789
SELECT * FROM productoffers WHERE product_id = '398315' AND merchantid = 'ATVPDKIKX0DER'
682 0.0002 0.00020599365234375
SELECT * FROM productoffers
                WHERE product_id = '398315' AND price > 0
                ORDER BY price ASC LIMIT 1
683 0.0004 0.00038290023803711
SELECT value FROM productattributes WHERE product_id = '398315' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
684 0.0001 0.00012302398681641
UPDATE products SET price = '1999' WHERE id = '398315'
685 0.0002 0.0001981258392334
SELECT * FROM productimages WHERE product_id = '406758' ORDER BY sortorder ASC
686 0.0002 0.00020503997802734
SELECT * FROM product_image_select WHERE product_id = '406758'
687 0.0001 0.00012111663818359
SELECT * FROM productcustomimages WHERE product_id = '406758'
688 0.0027 0.002687931060791
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '406758' AND a.name = n.originalname
689 0.0002 0.00018501281738281
SELECT * FROM productoffers WHERE product_id = '406758' AND merchantid = 'ATVPDKIKX0DER'
690 0.0002 0.00020003318786621
SELECT * FROM productoffers
                WHERE product_id = '406758' AND price > 0
                ORDER BY price ASC LIMIT 1
691 0.0004 0.00039005279541016
SELECT value FROM productattributes WHERE product_id = '406758' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
692 0.0001 0.00012302398681641
UPDATE products SET price = '2694' WHERE id = '406758'
693 0.0002 0.0002140998840332
SELECT * FROM productimages WHERE product_id = '400044' ORDER BY sortorder ASC
694 0.0002 0.00021696090698242
SELECT * FROM product_image_select WHERE product_id = '400044'
695 0.0001 0.0001218318939209
SELECT * FROM productcustomimages WHERE product_id = '400044'
696 0.0028 0.0027918815612793
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '400044' AND a.name = n.originalname
697 0.0002 0.00018620491027832
SELECT * FROM productoffers WHERE product_id = '400044' AND merchantid = 'ATVPDKIKX0DER'
698 0.0002 0.00021219253540039
SELECT * FROM productoffers
                WHERE product_id = '400044' AND price > 0
                ORDER BY price ASC LIMIT 1
699 0.0004 0.00040793418884277
SELECT value FROM productattributes WHERE product_id = '400044' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
700 0.0001 0.00011801719665527
UPDATE products SET price = '16091' WHERE id = '400044'
701 0.0002 0.00017905235290527
SELECT * FROM productimages WHERE product_id = '410588' ORDER BY sortorder ASC
702 0.0002 0.00021600723266602
SELECT * FROM product_image_select WHERE product_id = '410588'
703 0.0001 0.0001220703125
SELECT * FROM productcustomimages WHERE product_id = '410588'
704 0.0020 0.0020210742950439
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '410588' AND a.name = n.originalname
705 0.0002 0.00018191337585449
SELECT * FROM productoffers WHERE product_id = '410588' AND merchantid = 'ATVPDKIKX0DER'
706 0.0002 0.00019598007202148
SELECT * FROM productoffers
                WHERE product_id = '410588' AND price > 0
                ORDER BY price ASC LIMIT 1
707 0.0004 0.00036501884460449
SELECT value FROM productattributes WHERE product_id = '410588' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
708 0.0001 0.00012087821960449
UPDATE products SET price = '269999' WHERE id = '410588'
709 0.0003 0.00025296211242676
SELECT * FROM productimages WHERE product_id = '412927' ORDER BY sortorder ASC
710 0.0002 0.00020503997802734
SELECT * FROM product_image_select WHERE product_id = '412927'
711 0.0001 0.00012087821960449
SELECT * FROM productcustomimages WHERE product_id = '412927'
712 0.0037 0.0036540031433105
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '412927' AND a.name = n.originalname
713 0.0002 0.00018501281738281
SELECT * FROM productoffers WHERE product_id = '412927' AND merchantid = 'ATVPDKIKX0DER'
714 0.0002 0.00020599365234375
SELECT * FROM productoffers
                WHERE product_id = '412927' AND price > 0
                ORDER BY price ASC LIMIT 1
715 0.0004 0.00044012069702148
SELECT value FROM productattributes WHERE product_id = '412927' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
716 0.0001 0.00011992454528809
UPDATE products SET price = '199900' WHERE id = '412927'
717 0.0002 0.00019383430480957
SELECT * FROM productimages WHERE product_id = '103845' ORDER BY sortorder ASC
718 0.0002 0.00021910667419434
SELECT * FROM product_image_select WHERE product_id = '103845'
719 0.0001 0.0001220703125
SELECT * FROM productcustomimages WHERE product_id = '103845'
720 0.0024 0.0024118423461914
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '103845' AND a.name = n.originalname
721 0.0002 0.00018692016601562
SELECT * FROM productoffers WHERE product_id = '103845' AND merchantid = 'ATVPDKIKX0DER'
722 0.0002 0.0001978874206543
SELECT * FROM productoffers
                WHERE product_id = '103845' AND price > 0
                ORDER BY price ASC LIMIT 1
723 0.0004 0.00036787986755371
SELECT value FROM productattributes WHERE product_id = '103845' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
724 0.0001 0.00011801719665527
UPDATE products SET price = '11900' WHERE id = '103845'
725 0.1051 0.10514283180237
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
726 0.0003 0.00026988983154297
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:1560756236;s:8:\"products\";a:6:{i:0;s:6:\"398315\";i:2;s:6:\"290575\";i:5;s:6:\"412927\";i:8;s:6:\"408792\";i:11;s:6:\"403517\";i:12;s:6:\"414825\";}}' WHERE id = '183'
727 0.0005 0.00047898292541504
SELECT * FROM products WHERE id IN (398315,290575,412927,408792,403517,414825) ORDER BY FIELD(id, 398315,290575,412927,408792,403517,414825 )
728 0.0002 0.00022602081298828
SELECT * FROM productimages WHERE product_id = '398315' ORDER BY sortorder ASC
729 0.0002 0.00021505355834961
SELECT * FROM product_image_select WHERE product_id = '398315'
730 0.0001 0.00012612342834473
SELECT * FROM productcustomimages WHERE product_id = '398315'
731 0.0025 0.0025298595428467
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '398315' AND a.name = n.originalname
732 0.0002 0.00018501281738281
SELECT * FROM productoffers WHERE product_id = '398315' AND merchantid = 'ATVPDKIKX0DER'
733 0.0002 0.00020384788513184
SELECT * FROM productoffers
                WHERE product_id = '398315' AND price > 0
                ORDER BY price ASC LIMIT 1
734 0.0004 0.00039196014404297
SELECT value FROM productattributes WHERE product_id = '398315' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
735 0.0001 0.00012683868408203
UPDATE products SET price = '1999' WHERE id = '398315'
736 0.0006 0.00057697296142578
SELECT * FROM productimages WHERE product_id = '290575' ORDER BY sortorder ASC
737 0.0002 0.00023484230041504
SELECT * FROM product_image_select WHERE product_id = '290575'
738 0.0001 0.00012397766113281
SELECT * FROM productcustomimages WHERE product_id = '290575'
739 0.0034 0.0034301280975342
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '290575' AND a.name = n.originalname
740 0.0002 0.00019407272338867
SELECT * FROM productoffers WHERE product_id = '290575' AND merchantid = 'ATVPDKIKX0DER'
741 0.0002 0.0001990795135498
SELECT * FROM productoffers
                WHERE product_id = '290575' AND price > 0
                ORDER BY price ASC LIMIT 1
742 0.0004 0.00042414665222168
SELECT value FROM productattributes WHERE product_id = '290575' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
743 0.0001 0.00011897087097168
UPDATE products SET price = '549500' WHERE id = '290575'
744 0.0003 0.00026297569274902
SELECT * FROM productimages WHERE product_id = '412927' ORDER BY sortorder ASC
745 0.0002 0.00021195411682129
SELECT * FROM product_image_select WHERE product_id = '412927'
746 0.0001 0.00012087821960449
SELECT * FROM productcustomimages WHERE product_id = '412927'
747 0.0036 0.0036439895629883
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '412927' AND a.name = n.originalname
748 0.0002 0.00018405914306641
SELECT * FROM productoffers WHERE product_id = '412927' AND merchantid = 'ATVPDKIKX0DER'
749 0.0002 0.00019598007202148
SELECT * FROM productoffers
                WHERE product_id = '412927' AND price > 0
                ORDER BY price ASC LIMIT 1
750 0.0004 0.00044894218444824
SELECT value FROM productattributes WHERE product_id = '412927' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
751 0.0001 0.00011992454528809
UPDATE products SET price = '199900' WHERE id = '412927'
752 0.0002 0.00019717216491699
SELECT * FROM productimages WHERE product_id = '408792' ORDER BY sortorder ASC
753 0.0002 0.00021004676818848
SELECT * FROM product_image_select WHERE product_id = '408792'
754 0.0001 0.00012111663818359
SELECT * FROM productcustomimages WHERE product_id = '408792'
755 0.0036 0.0036358833312988
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '408792' AND a.name = n.originalname
756 0.0002 0.00018692016601562
SELECT * FROM productoffers WHERE product_id = '408792' AND merchantid = 'ATVPDKIKX0DER'
757 0.0002 0.00020313262939453
SELECT * FROM productoffers
                WHERE product_id = '408792' AND price > 0
                ORDER BY price ASC LIMIT 1
758 0.0004 0.00043797492980957
SELECT value FROM productattributes WHERE product_id = '408792' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
759 0.0001 0.00012397766113281
UPDATE products SET price = '13499' WHERE id = '408792'
760 0.0003 0.00025486946105957
SELECT * FROM productimages WHERE product_id = '403517' ORDER BY sortorder ASC
761 0.0002 0.00021791458129883
SELECT * FROM product_image_select WHERE product_id = '403517'
762 0.0001 0.0001218318939209
SELECT * FROM productcustomimages WHERE product_id = '403517'
763 0.0030 0.0029590129852295
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '403517' AND a.name = n.originalname
764 0.0002 0.00018215179443359
SELECT * FROM productoffers WHERE product_id = '403517' AND merchantid = 'ATVPDKIKX0DER'
765 0.0002 0.00019478797912598
SELECT * FROM productoffers
                WHERE product_id = '403517' AND price > 0
                ORDER BY price ASC LIMIT 1
766 0.0004 0.00041484832763672
SELECT value FROM productattributes WHERE product_id = '403517' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
767 0.0001 0.0001220703125
UPDATE products SET price = '6699' WHERE id = '403517'
768 0.0002 0.0001988410949707
SELECT * FROM productimages WHERE product_id = '414825' ORDER BY sortorder ASC
769 0.0002 0.00020313262939453
SELECT * FROM product_image_select WHERE product_id = '414825'
770 0.0001 0.00012111663818359
SELECT * FROM productcustomimages WHERE product_id = '414825'
771 0.0020 0.0020339488983154
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '414825' AND a.name = n.originalname
772 0.0002 0.00019478797912598
SELECT * FROM productoffers WHERE product_id = '414825' AND merchantid = 'ATVPDKIKX0DER'
773 0.0002 0.00021004676818848
SELECT * FROM productoffers
                WHERE product_id = '414825' AND price > 0
                ORDER BY price ASC LIMIT 1
774 0.0004 0.00035786628723145
SELECT value FROM productattributes WHERE product_id = '414825' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
775 0.0001 0.00012016296386719
UPDATE products SET price = '11999' WHERE id = '414825'
776 0.0004 0.00040102005004883
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid' AND area = 'header' ORDER BY sortorder ASC
777 0.0001 0.00013303756713867
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
778 0.0001 0.0001220703125
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
779 0.0001 0.0001220703125
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
780 0.0001 0.00012016296386719
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
781 0.0004 0.00039982795715332
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid' AND area = 'footer' ORDER BY sortorder ASC
782 0.0001 0.00013399124145508
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
783 0.0001 0.00012302398681641
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
784 0.0001 0.00011801719665527
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
785 0.0009 0.00090217590332031
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-fluid' AND skinuid = ''
786 0.0003 0.0003211498260498
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid'
787 0.0003 0.00028681755065918
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid'
788 0.0004 0.00044608116149902
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid' AND imageuid = 'HEAD_CUSTOM_BANNER'
789 0.0003 0.00032305717468262
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid' AND imageuid = 'HEAD_CUSTOM_BANNER'