Tactical Equipment - Survivalist Equipment

Primary Arms 3X Compact Prism Riflescope - ACSS 5.56 Reticle PAC3X-ACSS-5.56 from Primary Arms

Price: $289.99
Product prices and availability are accurate as of 2019-06-26 00:50:40 UTC and are subject to change. Any price and availability information displayed on http://www.amazon.com/ at the time of purchase will apply to the purchase of this product.
Availability: In Stock
Usually ships in 1-2 business days
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 proud to present the fantastic Primary Arms 3X Compact Prism Riflescope - ACSS 5.56 Reticle PAC3X-ACSS-5.56 today at this low price.

With so many competing tactical, combat and survival products on offer currently, it is great to have a provider that you can recognize. The Primary Arms 3X Compact Prism Riflescope - ACSS 5.56 Reticle PAC3X-ACSS-5.56 is certainly all that and will be a sound buy for your combat equipment or tactical ability.

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

For this special price, the Primary Arms 3X Compact Prism Riflescope - ACSS 5.56 Reticle PAC3X-ACSS-5.56 comes widely recommended and is always a favored choice for many like minded people. Primary Arms have produced some nice touches and this results in great value.

Manufacturer Description

The Primary Arms 3x Compact Scope is perfect for tactical or sport shooting when you need a single, lightweight scope to do it all! It includes our trademarked ACSS

Product Features

3x Fixed Magnification ACSS 5.56/.308 Reticle Removable base 12 Brightness Settings 3 Year Warranty

Write a Review

Debug Overview

App Total Time DB Queries DB Query Total Time Amazon Requests
2.4261908531189 745 1.2871 0


No Amazon API Requests Made.


App Debug - Total Time 2.4261908531189 seconds

Number Time From Start Name Description
1 0.39125990867615 Initialise Initialise FSB Function
2 0.3988139629364 App Controller Start Start of the App controller (called before the controller of every page)
3 0.4102988243103 Start of getCategoryListByGroup Function Before first category groups query
4 0.41047596931458 After initial query Before first category groups query
5 0.41047787666321 Get Category List for Group Before the call to getCategoryList function
6 0.41048192977905 Start of GetCategoryList function Start of the function
7 0.4104859828949 Before getting categories Query to get specific category list
8 0.41110396385193 After getting categories Query to get specific category list
9 0.41110587120056 Before getting category custom Before call to function getCategoryCustom
10 0.41308784484863 After getting category custom After call to function getCategoryCustom
11 0.41308999061584 Before getting category custom Before call to function getCategoryCustom
12 0.42388200759888 After getting category custom After call to function getCategoryCustom
13 0.42388486862183 Before getting category custom Before call to function getCategoryCustom
14 0.42958188056946 After getting category custom After call to function getCategoryCustom
15 0.42958402633667 Before getting category custom Before call to function getCategoryCustom
16 0.43381690979004 After getting category custom After call to function getCategoryCustom
17 0.43381905555725 End of GetCategoryList function End of the function
18 0.43383002281189 Get Category List for Group Before the call to getCategoryList function
19 0.43383193016052 Start of GetCategoryList function Start of the function
20 0.43383502960205 Before getting categories Query to get specific category list
21 0.43429493904114 After getting categories Query to get specific category list
22 0.43429589271545 Before getting category custom Before call to function getCategoryCustom
23 0.43997383117676 After getting category custom After call to function getCategoryCustom
24 0.43997693061829 Before getting category custom Before call to function getCategoryCustom
25 0.4506139755249 After getting category custom After call to function getCategoryCustom
26 0.45061588287354 End of GetCategoryList function End of the function
27 0.45062303543091 Get Category List for Group Before the call to getCategoryList function
28 0.45062589645386 Start of GetCategoryList function Start of the function
29 0.45062899589539 Before getting categories Query to get specific category list
30 0.45139598846436 After getting categories Query to get specific category list
31 0.45139789581299 Before getting category custom Before call to function getCategoryCustom
32 0.46068596839905 After getting category custom After call to function getCategoryCustom
33 0.460688829422 Before getting category custom Before call to function getCategoryCustom
34 0.47807788848877 After getting category custom After call to function getCategoryCustom
35 0.47808003425598 Before getting category custom Before call to function getCategoryCustom
36 0.4840989112854 After getting category custom After call to function getCategoryCustom
37 0.48410201072693 Before getting category custom Before call to function getCategoryCustom
38 0.4901020526886 After getting category custom After call to function getCategoryCustom
39 0.49010491371155 Before getting category custom Before call to function getCategoryCustom
40 0.4964280128479 After getting category custom After call to function getCategoryCustom
41 0.49643087387085 Before getting category custom Before call to function getCategoryCustom
42 0.51812386512756 After getting category custom After call to function getCategoryCustom
43 0.51812696456909 Before getting category custom Before call to function getCategoryCustom
44 0.52228188514709 After getting category custom After call to function getCategoryCustom
45 0.52228403091431 Before getting category custom Before call to function getCategoryCustom
46 0.52701592445374 After getting category custom After call to function getCategoryCustom
47 0.52701902389526 End of GetCategoryList function End of the function
48 0.52703404426575 Get Category List for Group Before the call to getCategoryList function
49 0.52703595161438 Start of GetCategoryList function Start of the function
50 0.52704000473022 Before getting categories Query to get specific category list
51 0.52748084068298 After getting categories Query to get specific category list
52 0.5274829864502 Before getting category custom Before call to function getCategoryCustom
53 0.52986598014832 After getting category custom After call to function getCategoryCustom
54 0.52986788749695 Before getting category custom Before call to function getCategoryCustom
55 0.53228998184204 After getting category custom After call to function getCategoryCustom
56 0.53229188919067 End of GetCategoryList function End of the function
57 0.53229904174805 Get Category List for Group Before the call to getCategoryList function
58 0.53230094909668 Start of GetCategoryList function Start of the function
59 0.53230404853821 Before getting categories Query to get specific category list
60 0.532634973526 After getting categories Query to get specific category list
61 0.53263592720032 Before getting category custom Before call to function getCategoryCustom
62 0.53767395019531 After getting category custom After call to function getCategoryCustom
63 0.53767585754395 End of GetCategoryList function End of the function
64 0.53768301010132 End of getCategoryListByGroup Function Before return()
65 0.59131693840027 App Controller End End of the App controller (called before the controller of every page)
66 0.59198188781738 Product Start Start of the product info controller
67 0.59284496307373 Cache file not found Starting get product details
68 0.63053703308105 Related products Start getting related products if enabled
69 0.63053894042969 Related Products Start Before the related products are found
70 0.630539894104 Related Products Keywords Before the related product keywords are found
71 0.63055300712585 Create Keyword List Function Start of function
72 0.63210988044739 Create Keyword List Function After looping provided content - 1066 keywords found
73 0.70323395729065 Create Keyword List Function After looping initial keyword list - 983 keywords remaining
74 0.70353889465332 Create Keyword List Function After reducing keyword list
75 0.70465993881226 Create Keyword List Function After selecting by scoring keywords
76 0.70466589927673 Create Keyword List Function After final loop of keywords
77 0.70466804504395 Related Products Keywords After the related product keywords are found
78 0.98076295852661 Related Products End After the related products are found
79 1.1901910305023 Start Remote Request http://svcs.ebay.com/services/search/FindingServic...
80 1.3546779155731 End Remote Request http://svcs.ebay.com/services/search/FindingServic...
81 1.6072819232941 Product End End of the product info controller (Product Info)
82 1.607666015625 App_after Controller Start Start of the App_after controller (called after the controller of every page)
83 1.6077499389648 Before Get Options Before the call to getOptions in the tpl class
84 1.9491679668427 After Get Options After the call to getOptions in the tpl class
85 1.9494469165802 App_after Controller End End of the App_after controller (called after the controller of every page)
86 1.9494609832764 Product Info: Before Smarty Fetch Before the product.tpl template is fetched
87 2.223876953125 Product Info: After Smarty Fetch After the product.tpl template is fetched
88 2.2238838672638 Product Info: Before Template Display Before the template is displayed
89 2.4261689186096 Product Info: After Template Display After the template is displayed
90 2.4261748790741 Finalizing debug Before the debug is output to the page.
91 2.4261898994446 End of App This is the end of the app logging, final timestamp


Query Debug - 745 Database Queries. Total time 1.2871 seconds

Number Time (Seconds) Time (Milliseconds) Query
1 0.0002 0.00016379356384277
SELECT value FROM parameters WHERE `parameter` = 'BAD_BOTS_ENABLER'
2 0.0004 0.00042581558227539
SHOW TABLES LIKE 'bad_bots'
3 0.0002 0.00015401840209961
SELECT value FROM parameters WHERE `parameter` = 'STORE_WHITELISTED_IPS'
4 0.0002 0.00016498565673828
SELECT * FROM `bad_bots`
5 0.0004 0.00043582916259766
SELECT parameter, value FROM parameters
6 0.0001 0.00014495849609375
SET time_zone = 'Europe/London'
7 0.0003 0.00029397010803223
SELECT * FROM autorun ORDER BY lastrun ASC
8 0.0002 0.00015616416931152
SELECT * FROM version ORDER BY installed DESC LIMIT 1
9 0.0001 0.0001070499420166
delete from cachefiles
10 0.0002 0.00022101402282715
SELECT id FROM pages WHERE pagename = 'primary-arms-3x-compact-prism-riflescope-acss-556-reticle-pac3x-acss-556' LIMIT 1
11 0.0002 0.00023484230041504
SELECT id FROM products WHERE pagename = 'primary-arms-3x-compact-prism-riflescope-acss-556-reticle-pac3x-acss-556' AND hidden = 0 LIMIT 1
12 0.0008 0.00084590911865234
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-fluid'
13 0.0096 0.0096352100372314
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-fluid' AND language = 'en'
14 0.0002 0.00021910667419434
SELECT * FROM pages WHERE pagename = 'primary-arms-3x-compact-prism-riflescope-acss-556-reticle-pac3x-acss-556'
15 0.0002 0.00015902519226074
SELECT * FROM categorygroups ORDER BY sortorder ASC
16 0.0006 0.00057005882263184
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
17 0.0005 0.0004880428314209
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 49
18 0.0002 0.00024294853210449
SELECT id FROM categories WHERE parent_id = '49'
19 0.0005 0.0004730224609375
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.00015401840209961
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.00016307830810547
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.00018405914306641
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '49'
23 0.0001 0.00014710426330566
SELECT * FROM categorygroups WHERE id = '1'
24 0.0030 0.0030419826507568
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.00026917457580566
SELECT id FROM categories WHERE parent_id = '50'
26 0.0002 0.00021481513977051
SELECT id FROM categories WHERE parent_id = '96'
27 0.0002 0.0002129077911377
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.00021004676818848
SELECT id FROM categories WHERE parent_id = '129'
30 0.0058 0.0057780742645264
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.00017786026000977
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.00016689300537109
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.0001838207244873
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '50'
34 0.0001 0.00013518333435059
SELECT * FROM categorygroups WHERE id = '1'
35 0.0023 0.0023300647735596
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.00026607513427734
SELECT id FROM categories WHERE parent_id = '80'
37 0.0024 0.0023519992828369
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.00016307830810547
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.00017404556274414
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '80'
41 0.0001 0.00013303756713867
SELECT * FROM categorygroups WHERE id = '1'
42 0.0012 0.0011630058288574
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.00026702880859375
SELECT id FROM categories WHERE parent_id = '51'
44 0.0002 0.00021791458129883
SELECT id FROM categories WHERE parent_id = '101'
45 0.0018 0.001823902130127
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.00015711784362793
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (101,51)
				  AND p.disabled = 0 
47 0.0002 0.00015902519226074
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.00018095970153809
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '51'
49 0.0001 0.00013399124145508
SELECT * FROM categorygroups WHERE id = '1'
50 0.0004 0.00042891502380371
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '2'  AND hidden = 0 ORDER BY sortorder ASC
51 0.0023 0.0023338794708252
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 30
52 0.0003 0.0002589225769043
SELECT id FROM categories WHERE parent_id = '30'
53 0.0023 0.0023219585418701
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (30)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
54 0.0002 0.00015401840209961
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (30)
				  AND p.disabled = 0 
55 0.0002 0.00015902519226074
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (30)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
56 0.0002 0.00018310546875
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
57 0.0001 0.00013399124145508
SELECT * FROM categorygroups WHERE id = '2'
58 0.0048 0.0047669410705566
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.00028681755065918
SELECT id FROM categories WHERE parent_id = '61'
60 0.0048 0.0048010349273682
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.00017380714416504
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (61)
				  AND p.disabled = 0 
62 0.0002 0.00015997886657715
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.00017690658569336
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '61'
64 0.0001 0.00014281272888184
SELECT * FROM categorygroups WHERE id = '2'
65 0.0007 0.00069594383239746
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '10'  AND hidden = 0 ORDER BY sortorder ASC
66 0.0041 0.0041179656982422
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.0002748966217041
SELECT id FROM categories WHERE parent_id = '64'
68 0.0041 0.0041229724884033
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.00016307830810547
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (64)
				  AND p.disabled = 0 
70 0.0002 0.00015997886657715
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (64)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
71 0.0002 0.00017809867858887
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '64'
72 0.0001 0.00013399124145508
SELECT * FROM categorygroups WHERE id = '10'
73 0.0081 0.0081470012664795
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.00029587745666504
SELECT id FROM categories WHERE parent_id = '65'
75 0.0082 0.0081601142883301
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.00016999244689941
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (65)
				  AND p.disabled = 0 
77 0.0002 0.00015783309936523
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.00017690658569336
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '65'
79 0.0001 0.00014996528625488
SELECT * FROM categorygroups WHERE id = '10'
80 0.0025 0.0024781227111816
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.00026988983154297
SELECT id FROM categories WHERE parent_id = '81'
82 0.0025 0.0025169849395752
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.00015616416931152
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (81)
				  AND p.disabled = 0 
84 0.0002 0.00015878677368164
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.00017380714416504
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '81'
86 0.0001 0.00014495849609375
SELECT * FROM categorygroups WHERE id = '10'
87 0.0025 0.0024690628051758
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.00026702880859375
SELECT id FROM categories WHERE parent_id = '31'
89 0.0025 0.0024979114532471
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (31)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
90 0.0002 0.00015878677368164
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (31)
				  AND p.disabled = 0 
91 0.0002 0.00015997886657715
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (31)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
92 0.0002 0.00018000602722168
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
93 0.0001 0.00014591217041016
SELECT * FROM categorygroups WHERE id = '10'
94 0.0022 0.0022320747375488
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.00026512145996094
SELECT id FROM categories WHERE parent_id = '66'
96 0.0002 0.00021505355834961
SELECT id FROM categories WHERE parent_id = '131'
97 0.0028 0.0028162002563477
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.00016093254089355
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.00016999244689941
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.00017714500427246
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '66'
101 0.0002 0.0001530647277832
SELECT * FROM categorygroups WHERE id = '10'
102 0.0094 0.0093860626220703
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.00030398368835449
SELECT id FROM categories WHERE parent_id = '34'
104 0.0002 0.00021696090698242
SELECT id FROM categories WHERE parent_id = '94'
105 0.0002 0.00021505355834961
SELECT id FROM categories WHERE parent_id = '98'
106 0.0002 0.00021100044250488
SELECT id FROM categories WHERE parent_id = '99'
107 0.0002 0.00022077560424805
SELECT id FROM categories WHERE parent_id = '110'
108 0.0002 0.00021195411682129
SELECT id FROM categories WHERE parent_id = '130'
109 0.0100 0.010033845901489
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.00018310546875
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.00016689300537109
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.00019001960754395
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '34'
113 0.0001 0.00014901161193848
SELECT * FROM categorygroups WHERE id = '10'
114 0.0015 0.0015478134155273
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.00026392936706543
SELECT id FROM categories WHERE parent_id = '32'
116 0.0016 0.0015830993652344
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (32)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
117 0.0002 0.0001528263092041
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (32)
				  AND p.disabled = 0 
118 0.0002 0.00015807151794434
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.00018787384033203
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '32'
120 0.0001 0.00013494491577148
SELECT * FROM categorygroups WHERE id = '10'
121 0.0018 0.0018460750579834
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.00026202201843262
SELECT id FROM categories WHERE parent_id = '89'
123 0.0019 0.0018699169158936
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (89)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
124 0.0002 0.00015401840209961
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.00015783309936523
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.00018095970153809
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '89'
127 0.0001 0.00014209747314453
SELECT * FROM categorygroups WHERE id = '10'
128 0.0004 0.0004119873046875
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '17'  AND hidden = 0 ORDER BY sortorder ASC
129 0.0007 0.00069499015808105
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.00024509429931641
SELECT id FROM categories WHERE parent_id = '84'
131 0.0007 0.00071191787719727
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.00014877319335938
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (84)
				  AND p.disabled = 0 
133 0.0002 0.00015711784362793
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.00017809867858887
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '84'
135 0.0001 0.00013208389282227
SELECT * FROM categorygroups WHERE id = '17'
136 0.0007 0.00071191787719727
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.0002448558807373
SELECT id FROM categories WHERE parent_id = '90'
138 0.0007 0.00074100494384766
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (90)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
139 0.0001 0.00014686584472656
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (90)
				  AND p.disabled = 0 
140 0.0002 0.00015592575073242
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.00017499923706055
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '90'
142 0.0001 0.00013208389282227
SELECT * FROM categorygroups WHERE id = '17'
143 0.0003 0.00031304359436035
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '20'  AND hidden = 0 ORDER BY sortorder ASC
144 0.0020 0.0020158290863037
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 92
145 0.0003 0.00025105476379395
SELECT id FROM categories WHERE parent_id = '92'
146 0.0020 0.0020480155944824
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (92)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
147 0.0002 0.0001518726348877
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (92)
				  AND p.disabled = 0 
148 0.0002 0.00015807151794434
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (92)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
149 0.0002 0.00016093254089355
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '92'
150 0.0001 0.00013494491577148
SELECT * FROM categorygroups WHERE id = '20'
151 0.0055 0.0054879188537598
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
152 0.0004 0.00037193298339844
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-fluid' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
153 0.0002 0.0001680850982666
SELECT value FROM parameters WHERE parameter = 'EBAY_APP_ID' 
154 0.0002 0.00016307830810547
SELECT * FROM sideboxes_pages WHERE sidebox_id = '1'
155 0.0002 0.00017905235290527
SELECT * FROM pages WHERE id = '67'
156 0.0002 0.0001680850982666
SELECT * FROM pages WHERE id = '82'
157 0.0002 0.00017499923706055
SELECT * FROM pages WHERE id = '84'
158 0.0002 0.00015592575073242
SELECT * FROM pages WHERE id = '94'
159 0.0002 0.00016403198242188
SELECT * FROM pages WHERE id = '116'
160 0.0002 0.00020885467529297
SELECT * FROM pages WHERE id = '52'
161 0.0002 0.0001680850982666
SELECT * FROM pages WHERE id = '135'
162 0.0002 0.00017118453979492
SELECT * FROM pages WHERE id = '245'
163 0.0002 0.00017094612121582
SELECT * FROM pages WHERE id = '269'
164 0.0002 0.0001988410949707
SELECT * FROM pages WHERE id = '275'
165 0.0002 0.00019097328186035
SELECT * FROM pages WHERE id = '280'
166 0.0002 0.00020909309387207
SELECT * FROM pages WHERE id = '357'
167 0.0002 0.00016093254089355
SELECT * FROM pages WHERE id = '379'
168 0.0002 0.00015401840209961
SELECT * FROM pages WHERE id = '401'
169 0.0002 0.00016093254089355
SELECT * FROM pages WHERE id = '450'
170 0.0002 0.00015997886657715
SELECT * FROM pages WHERE id = '454'
171 0.0002 0.00016617774963379
SELECT * FROM pages WHERE id = '457'
172 0.0002 0.00017595291137695
SELECT * FROM pages WHERE id = '458'
173 0.0002 0.00016498565673828
SELECT * FROM sideboxes_pages WHERE sidebox_id = '2'
174 0.0002 0.00016999244689941
SELECT * FROM pages WHERE id = '41'
175 0.0002 0.00017189979553223
SELECT * FROM pages WHERE id = '43'
176 0.0002 0.00015902519226074
SELECT * FROM pages WHERE id = '44'
177 0.0002 0.00017499923706055
SELECT * FROM pages WHERE id = '68'
178 0.0002 0.00020599365234375
SELECT * FROM pages WHERE id = '80'
179 0.0002 0.00016999244689941
SELECT * FROM pages WHERE id = '85'
180 0.0002 0.00016593933105469
SELECT * FROM pages WHERE id = '97'
181 0.0002 0.00016498565673828
SELECT * FROM pages WHERE id = '107'
182 0.0002 0.0001671314239502
SELECT * FROM pages WHERE id = '108'
183 0.0001 0.00014901161193848
SELECT * FROM pages WHERE id = '128'
184 0.0002 0.00017189979553223
SELECT * FROM pages WHERE id = '133'
185 0.0002 0.00015711784362793
SELECT * FROM pages WHERE id = '148'
186 0.0002 0.0001678466796875
SELECT * FROM pages WHERE id = '217'
187 0.0002 0.00016379356384277
SELECT * FROM pages WHERE id = '228'
188 0.0002 0.00016212463378906
SELECT * FROM pages WHERE id = '257'
189 0.0002 0.00016403198242188
SELECT * FROM pages WHERE id = '271'
190 0.0002 0.00015592575073242
SELECT * FROM pages WHERE id = '286'
191 0.0002 0.00015401840209961
SELECT * FROM pages WHERE id = '287'
192 0.0002 0.00017404556274414
SELECT * FROM pages WHERE id = '291'
193 0.0002 0.00016903877258301
SELECT * FROM pages WHERE id = '380'
194 0.0002 0.00016403198242188
SELECT * FROM pages WHERE id = '344'
195 0.0002 0.00017404556274414
SELECT * FROM pages WHERE id = '354'
196 0.0002 0.00019192695617676
SELECT * FROM pages WHERE id = '363'
197 0.0002 0.00021505355834961
SELECT * FROM pages WHERE id = '364'
198 0.0002 0.00015687942504883
SELECT * FROM pages WHERE id = '368'
199 0.0002 0.00018906593322754
SELECT * FROM pages WHERE id = '369'
200 0.0002 0.00015711784362793
SELECT * FROM pages WHERE id = '400'
201 0.0002 0.00016617774963379
SELECT * FROM pages WHERE id = '463'
202 0.0002 0.00018906593322754
SELECT * FROM sideboxes_pages WHERE sidebox_id = '33'
203 0.0003 0.00025701522827148
SELECT * FROM pages WHERE id = '66'
204 0.0002 0.00020217895507812
SELECT * FROM pages WHERE id = '77'
205 0.0002 0.00019502639770508
SELECT * FROM pages WHERE id = '90'
206 0.0002 0.00016593933105469
SELECT * FROM pages WHERE id = '414'
207 0.0002 0.00016307830810547
SELECT * FROM pages WHERE id = '119'
208 0.0002 0.00016212463378906
SELECT * FROM pages WHERE id = '406'
209 0.0002 0.00016021728515625
SELECT * FROM pages WHERE id = '149'
210 0.0002 0.00015711784362793
SELECT * FROM pages WHERE id = '150'
211 0.0002 0.0001528263092041
SELECT * FROM pages WHERE id = '412'
212 0.0002 0.00017690658569336
SELECT * FROM pages WHERE id = '162'
213 0.0002 0.00015521049499512
SELECT * FROM pages WHERE id = '164'
214 0.0002 0.00015711784362793
SELECT * FROM pages WHERE id = '167'
215 0.0001 0.00014996528625488
SELECT * FROM pages WHERE id = '180'
216 0.0002 0.00015091896057129
SELECT * FROM pages WHERE id = '187'
217 0.0002 0.00020313262939453
SELECT * FROM pages WHERE id = '265'
218 0.0002 0.0001671314239502
SELECT * FROM pages WHERE id = '268'
219 0.0002 0.00015401840209961
SELECT * FROM pages WHERE id = '411'
220 0.0002 0.00016498565673828
SELECT * FROM pages WHERE id = '290'
221 0.0002 0.0001521110534668
SELECT * FROM pages WHERE id = '413'
222 0.0002 0.00015497207641602
SELECT * FROM pages WHERE id = '409'
223 0.0002 0.00017094612121582
SELECT * FROM pages WHERE id = '327'
224 0.0002 0.00016093254089355
SELECT * FROM pages WHERE id = '336'
225 0.0002 0.0001671314239502
SELECT * FROM pages WHERE id = '351'
226 0.0002 0.00015807151794434
SELECT * FROM pages WHERE id = '358'
227 0.0002 0.00016403198242188
SELECT * FROM pages WHERE id = '360'
228 0.0002 0.00017285346984863
SELECT * FROM pages WHERE id = '362'
229 0.0002 0.00016689300537109
SELECT * FROM pages WHERE id = '366'
230 0.0002 0.00017213821411133
SELECT * FROM pages WHERE id = '370'
231 0.0002 0.00016093254089355
SELECT * FROM pages WHERE id = '377'
232 0.0002 0.00016188621520996
SELECT * FROM pages WHERE id = '386'
233 0.0002 0.00016593933105469
SELECT * FROM pages WHERE id = '408'
234 0.0002 0.00015401840209961
SELECT * FROM pages WHERE id = '415'
235 0.0002 0.00017309188842773
SELECT * FROM pages WHERE id = '416'
236 0.0002 0.00019097328186035
SELECT * FROM pages WHERE id = '419'
237 0.0002 0.00016403198242188
SELECT * FROM pages WHERE id = '423'
238 0.0002 0.00017094612121582
SELECT * FROM pages WHERE id = '427'
239 0.0002 0.00019001960754395
SELECT * FROM pages WHERE id = '428'
240 0.0002 0.0001518726348877
SELECT * FROM pages WHERE id = '432'
241 0.0002 0.00015497207641602
SELECT * FROM pages WHERE id = '433'
242 0.0002 0.00016307830810547
SELECT * FROM pages WHERE id = '436'
243 0.0002 0.00015878677368164
SELECT * FROM pages WHERE id = '437'
244 0.0002 0.00016093254089355
SELECT * FROM pages WHERE id = '461'
245 0.0002 0.0001838207244873
SELECT * FROM pages WHERE id = '464'
246 0.0002 0.00016093254089355
SELECT * FROM sideboxes_pages WHERE sidebox_id = '34'
247 0.0002 0.00016403198242188
SELECT * FROM pages WHERE id = '74'
248 0.0002 0.00015687942504883
SELECT * FROM pages WHERE id = '137'
249 0.0002 0.00016999244689941
SELECT * FROM pages WHERE id = '145'
250 0.0002 0.00016117095947266
SELECT * FROM pages WHERE id = '156'
251 0.0002 0.00015997886657715
SELECT * FROM pages WHERE id = '407'
252 0.0002 0.0001521110534668
SELECT * FROM pages WHERE id = '410'
253 0.0002 0.00018405914306641
SELECT * FROM pages WHERE id = '266'
254 0.0002 0.00021815299987793
SELECT * FROM pages WHERE id = '316'
255 0.0002 0.00016617774963379
SELECT * FROM pages WHERE id = '332'
256 0.0002 0.00019001960754395
SELECT * FROM pages WHERE id = '334'
257 0.0002 0.00015592575073242
SELECT * FROM pages WHERE id = '367'
258 0.0002 0.00016307830810547
SELECT * FROM pages WHERE id = '387'
259 0.0002 0.00017309188842773
SELECT * FROM pages WHERE id = '389'
260 0.0002 0.00016689300537109
SELECT * FROM pages WHERE id = '397'
261 0.0002 0.00017094612121582
SELECT * FROM pages WHERE id = '449'
262 0.0002 0.00017499923706055
SELECT * FROM sideboxes_pages WHERE sidebox_id = '35'
263 0.0002 0.00019502639770508
SELECT * FROM pages WHERE id = '42'
264 0.0002 0.00016999244689941
SELECT * FROM pages WHERE id = '79'
265 0.0002 0.00016903877258301
SELECT * FROM pages WHERE id = '86'
266 0.0002 0.00015592575073242
SELECT * FROM pages WHERE id = '95'
267 0.0002 0.00016307830810547
SELECT * FROM pages WHERE id = '102'
268 0.0002 0.00015401840209961
SELECT * FROM pages WHERE id = '109'
269 0.0002 0.00022006034851074
SELECT * FROM pages WHERE id = '114'
270 0.0002 0.00019097328186035
SELECT * FROM pages WHERE id = '121'
271 0.0002 0.00020098686218262
SELECT * FROM pages WHERE id = '138'
272 0.0002 0.00016283988952637
SELECT * FROM pages WHERE id = '142'
273 0.0002 0.00020098686218262
SELECT * FROM pages WHERE id = '62'
274 0.0002 0.00016212463378906
SELECT * FROM pages WHERE id = '157'
275 0.0002 0.0001678466796875
SELECT * FROM pages WHERE id = '246'
276 0.0002 0.00019502639770508
SELECT * FROM pages WHERE id = '276'
277 0.0002 0.00019311904907227
SELECT * FROM pages WHERE id = '278'
278 0.0002 0.00021505355834961
SELECT * FROM pages WHERE id = '279'
279 0.0002 0.00017094612121582
SELECT * FROM pages WHERE id = '317'
280 0.0002 0.00016212463378906
SELECT * FROM pages WHERE id = '405'
281 0.0002 0.00018215179443359
SELECT * FROM pages WHERE id = '343'
282 0.0002 0.00016403198242188
SELECT * FROM pages WHERE id = '345'
283 0.0002 0.00020694732666016
SELECT * FROM pages WHERE id = '346'
284 0.0002 0.00016903877258301
SELECT * FROM pages WHERE id = '347'
285 0.0002 0.00017094612121582
SELECT * FROM pages WHERE id = '348'
286 0.0002 0.00016498565673828
SELECT * FROM pages WHERE id = '349'
287 0.0002 0.00015878677368164
SELECT * FROM pages WHERE id = '381'
288 0.0002 0.00016880035400391
SELECT * FROM pages WHERE id = '392'
289 0.0002 0.00015997886657715
SELECT * FROM pages WHERE id = '393'
290 0.0002 0.00015687942504883
SELECT * FROM pages WHERE id = '394'
291 0.0002 0.00015592575073242
SELECT * FROM pages WHERE id = '395'
292 0.0002 0.0001671314239502
SELECT * FROM pages WHERE id = '399'
293 0.0002 0.00016617774963379
SELECT * FROM pages WHERE id = '421'
294 0.0002 0.0001530647277832
SELECT * FROM pages WHERE id = '426'
295 0.0002 0.0001530647277832
SELECT * FROM pages WHERE id = '430'
296 0.0002 0.00015807151794434
SELECT * FROM pages WHERE id = '431'
297 0.0002 0.00016689300537109
SELECT * FROM pages WHERE id = '434'
298 0.0002 0.0001671314239502
SELECT * FROM pages WHERE id = '435'
299 0.0002 0.0001838207244873
SELECT * FROM pages WHERE id = '440'
300 0.0002 0.0001671314239502
SELECT * FROM pages WHERE id = '441'
301 0.0002 0.00015997886657715
SELECT * FROM pages WHERE id = '451'
302 0.0002 0.00015401840209961
SELECT * FROM pages WHERE id = '453'
303 0.0002 0.0001521110534668
SELECT * FROM sideboxes_pages WHERE sidebox_id = '37'
304 0.0002 0.00018596649169922
SELECT * FROM pages WHERE id = '146'
305 0.0002 0.00015807151794434
SELECT * FROM pages WHERE id = '158'
306 0.0002 0.0001518726348877
SELECT * FROM pages WHERE id = '163'
307 0.0002 0.00021696090698242
SELECT * FROM pages WHERE id = '293'
308 0.0002 0.00017595291137695
SELECT * FROM pages WHERE id = '340'
309 0.0002 0.00017786026000977
SELECT * FROM pages WHERE id = '417'
310 0.0002 0.00015497207641602
SELECT * FROM sideboxes_pages WHERE sidebox_id = '40'
311 0.0002 0.00017595291137695
SELECT * FROM pages WHERE id = '173'
312 0.0002 0.00016593933105469
SELECT * FROM pages WHERE id = '181'
313 0.0002 0.00015401840209961
SELECT * FROM pages WHERE id = '288'
314 0.0002 0.0001678466796875
SELECT * FROM pages WHERE id = '299'
315 0.0002 0.00016117095947266
SELECT * FROM pages WHERE id = '300'
316 0.0002 0.00016117095947266
SELECT * FROM pages WHERE id = '383'
317 0.0002 0.0001521110534668
SELECT * FROM pages WHERE id = '385'
318 0.0002 0.00015783309936523
SELECT * FROM pages WHERE id = '438'
319 0.0002 0.00016593933105469
SELECT * FROM pages WHERE id = '442'
320 0.0002 0.00016188621520996
SELECT * FROM sideboxes_pages WHERE sidebox_id = '38'
321 0.0002 0.00023484230041504
SELECT * FROM pages WHERE id = '103'
322 0.0002 0.00022482872009277
SELECT * FROM pages WHERE id = '134'
323 0.0002 0.00015687942504883
SELECT * FROM pages WHERE id = '139'
324 0.0002 0.00017404556274414
SELECT * FROM pages WHERE id = '143'
325 0.0002 0.00016903877258301
SELECT * FROM pages WHERE id = '234'
326 0.0002 0.00016903877258301
SELECT * FROM pages WHERE id = '248'
327 0.0002 0.00015711784362793
SELECT * FROM pages WHERE id = '260'
328 0.0002 0.00016498565673828
SELECT * FROM pages WHERE id = '398'
329 0.0002 0.00017404556274414
SELECT * FROM sideboxes_pages WHERE sidebox_id = '29'
330 0.0002 0.00017380714416504
SELECT * FROM pages WHERE id = '61'
331 0.0002 0.00016689300537109
SELECT * FROM pages WHERE id = '87'
332 0.0002 0.00016999244689941
SELECT * FROM pages WHERE id = '104'
333 0.0002 0.0001990795135498
SELECT * FROM pages WHERE id = '115'
334 0.0002 0.00015687942504883
SELECT * FROM pages WHERE id = '124'
335 0.0002 0.00016593933105469
SELECT * FROM pages WHERE id = '144'
336 0.0002 0.00018501281738281
SELECT * FROM pages WHERE id = '151'
337 0.0001 0.00014901161193848
SELECT * FROM pages WHERE id = '199'
338 0.0002 0.00015997886657715
SELECT * FROM pages WHERE id = '200'
339 0.0002 0.00015807151794434
SELECT * FROM pages WHERE id = '304'
340 0.0002 0.00016403198242188
SELECT * FROM pages WHERE id = '321'
341 0.0002 0.00015497207641602
SELECT * FROM pages WHERE id = '333'
342 0.0002 0.00016999244689941
SELECT * FROM pages WHERE id = '350'
343 0.0002 0.00015401840209961
SELECT * FROM pages WHERE id = '378'
344 0.0002 0.00015592575073242
SELECT * FROM pages WHERE id = '422'
345 0.0002 0.00019311904907227
SELECT * FROM pages WHERE id = '425'
346 0.0002 0.00015592575073242
SELECT * FROM pages WHERE id = '443'
347 0.0002 0.00015401840209961
SELECT * FROM pages WHERE id = '444'
348 0.0002 0.00015497207641602
SELECT * FROM pages WHERE id = '445'
349 0.0002 0.00015807151794434
SELECT * FROM pages WHERE id = '446'
350 0.0002 0.00016283988952637
SELECT * FROM pages WHERE id = '447'
351 0.0002 0.00015902519226074
SELECT * FROM pages WHERE id = '448'
352 0.0002 0.00015807151794434
SELECT * FROM pages WHERE id = '455'
353 0.0002 0.00016212463378906
SELECT * FROM pages WHERE id = '456'
354 0.0002 0.0001518726348877
SELECT * FROM pages WHERE id = '459'
355 0.0002 0.00016689300537109
SELECT * FROM pages WHERE id = '460'
356 0.0002 0.00016999244689941
SELECT * FROM pages WHERE id = '462'
357 0.0002 0.00015616416931152
SELECT * FROM sideboxes_pages WHERE sidebox_id = '32'
358 0.0002 0.00017118453979492
SELECT * FROM pages WHERE id = '153'
359 0.0002 0.00019979476928711
SELECT * FROM pages WHERE id = '182'
360 0.0002 0.00015997886657715
SELECT * FROM pages WHERE id = '238'
361 0.0002 0.00016283988952637
SELECT * FROM pages WHERE id = '240'
362 0.0001 0.00014996528625488
SELECT * FROM pages WHERE id = '242'
363 0.0001 0.00014901161193848
SELECT * FROM pages WHERE id = '252'
364 0.0001 0.00014781951904297
SELECT * FROM pages WHERE id = '253'
365 0.0002 0.00015091896057129
SELECT * FROM pages WHERE id = '262'
366 0.0001 0.00014901161193848
SELECT * FROM pages WHERE id = '267'
367 0.0002 0.00015878677368164
SELECT * FROM pages WHERE id = '420'
368 0.0001 0.00014901161193848
SELECT value FROM parameters WHERE parameter = 'GOOGLE_SITE_KEY' 
369 0.0001 0.00013017654418945
SELECT value FROM parameters WHERE parameter = 'GOOGLE_SECRET_KEY' 
370 0.0001 0.00012993812561035
SELECT value FROM parameters WHERE parameter = 'GOOGLE_RECAPTCHA_TYPE' 
371 0.0014 0.0014231204986572
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
372 0.0002 0.00017309188842773
SELECT value FROM parameters WHERE parameter = 'GOOGLE_SITE_KEY' 
373 0.0001 0.00013208389282227
SELECT value FROM parameters WHERE parameter = 'GOOGLE_SECRET_KEY' 
374 0.0001 0.00012898445129395
SELECT value FROM parameters WHERE parameter = 'GOOGLE_RECAPTCHA_TYPE' 
375 0.0003 0.00028514862060547
SELECT * FROM products WHERE pagename = 'primary-arms-3x-compact-prism-riflescope-acss-556-reticle-pac3x-acss-556'
376 0.0002 0.00020217895507812
SELECT * FROM manufacturers WHERE id = '4372'
377 0.0003 0.00031280517578125
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '4372'
378 0.0001 0.00012493133544922
SELECT filename FROM manufacturerimages WHERE manufacturer_id = '4372' LIMIT 1
379 0.0003 0.00025701522827148
SELECT pagename, id FROM products p WHERE manufacturer_id = '4372' ORDER BY RAND() LIMIT 1
380 0.0003 0.00029206275939941
SELECT * FROM productimages WHERE product_id = '406987' ORDER BY sortorder ASC
381 0.0003 0.00026082992553711
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '4372'
382 0.0003 0.0002899169921875
SELECT COUNT(DISTINCT(p.id)) FROM products p
				WHERE p.manufacturer_id = '4372'
				  AND p.hidden = 0
				  AND p.enabled = 1
				  AND p.parent_id = 0 
383 0.0001 0.00012516975402832
SELECT * FROM manufacturerimages WHERE manufacturer_id = '4372'
384 0.0002 0.00015497207641602
SELECT category_id FROM products_categories WHERE product_id = '400620'
385 0.0002 0.0002288818359375
SELECT * FROM categories WHERE id = '34'
386 0.0096 0.0096299648284912
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
387 0.0002 0.0001521110534668
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 34
388 0.0003 0.00028014183044434
SELECT id FROM categories WHERE parent_id = '34'
389 0.0002 0.00021600723266602
SELECT id FROM categories WHERE parent_id = '94'
390 0.0002 0.00021219253540039
SELECT id FROM categories WHERE parent_id = '98'
391 0.0002 0.00022101402282715
SELECT id FROM categories WHERE parent_id = '99'
392 0.0002 0.00021100044250488
SELECT id FROM categories WHERE parent_id = '110'
393 0.0002 0.00021004676818848
SELECT id FROM categories WHERE parent_id = '130'
394 0.0102 0.010154962539673
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 
395 0.0002 0.00018596649169922
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 
396 0.0002 0.00018119812011719
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 
397 0.0002 0.00019502639770508
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '34'
398 0.0004 0.00035214424133301
SELECT * FROM productimages WHERE product_id = '400620' ORDER BY sortorder ASC
399 0.0002 0.00023412704467773
SELECT * FROM product_image_select WHERE product_id = '400620'
400 0.0001 0.00013589859008789
SELECT * FROM productcustomimages WHERE product_id = '400620'
401 0.0001 0.00012302398681641
SELECT * FROM productfeeds WHERE product_id = '400620' ORDER BY item_date DESC
402 0.0004 0.00037097930908203
SELECT a.name, n.displayname, a.value, n.units, n.valuetype FROM productattributes a, productattributenames n WHERE product_id = '400620' AND a.name = n.originalname AND n.display = 1 AND n.hidden = 0
403 0.0004 0.00037002563476562
SELECT DISTINCT(pt.tag_id) FROM product_tags pt, tags t WHERE pt.tag_id = t.id AND pt.product_id = '400620' AND t.hidden = 0 AND display_product = 1
404 0.0002 0.0001530647277832
SELECT * FROM tags WHERE id = '3345'
405 0.0021 0.0021018981933594
SELECT COUNT(DISTINCT(p.id)) FROM products p, product_tags t
				WHERE p.id = t.product_id
				  AND t.tag_id = '3345'
				  AND p.parent_id = 0
				  AND p.enabled = 1
				  AND p.hidden = 0
406 0.0021 0.0020511150360107
SELECT COUNT(DISTINCT(p.id)) FROM products p, product_tags t
				WHERE p.id = t.product_id
				  AND t.tag_id = '3345'
				  AND p.parent_id = 0
				  AND hidden = 0
				  AND enabled = 1 
407 0.0021 0.0020959377288818
SELECT p.id FROM products p, product_tags t WHERE p.id = t.product_id AND t.tag_id = '3345' AND p.hidden = 0 AND p.salesrank > 0 AND (p.price > 0 OR p.parent = 1) ORDER BY p.salesrank ASC LIMIT 1
408 0.0003 0.00029301643371582
SELECT * FROM productimages WHERE product_id = '232837' ORDER BY sortorder ASC
409 0.0002 0.00018978118896484
SELECT * FROM productamazoncontent WHERE product_id = '400620'
410 0.0031 0.0031259059906006
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '400620' AND a.name = n.originalname
411 0.0002 0.00020098686218262
SELECT * FROM productoffers WHERE product_id = '400620' AND merchantid = 'ATVPDKIKX0DER'
412 0.0002 0.00022196769714355
SELECT * FROM productoffers
                WHERE product_id = '400620' AND price > 0
                ORDER BY price ASC LIMIT 1
413 0.0004 0.00044512748718262
SELECT value FROM productattributes WHERE product_id = '400620' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
414 0.0001 0.00014090538024902
UPDATE products SET price = '28999' WHERE id = '400620'
415 0.2471 0.24706315994263
SELECT *, MATCH (description, keyfeatures, title) AGAINST ('reticle' IN BOOLEAN MODE) AS `searchrelevance` FROM products WHERE MATCH (description, keyfeatures, title) AGAINST ('reticle' IN BOOLEAN MODE) AND 400620 <> 0 AND enabled = 1 AND hidden = 0 AND offers > 0 AND parent_id = 0 ORDER BY `searchrelevance` LIMIT 6
416 0.0005 0.00050711631774902
SELECT * FROM productimages WHERE product_id = '128892' ORDER BY sortorder ASC
417 0.0002 0.00023293495178223
SELECT * FROM product_image_select WHERE product_id = '128892'
418 0.0001 0.00013399124145508
SELECT * FROM productcustomimages WHERE product_id = '128892'
419 0.0025 0.0025389194488525
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '128892' AND a.name = n.originalname
420 0.0002 0.00020003318786621
SELECT * FROM productoffers WHERE product_id = '128892' AND merchantid = 'ATVPDKIKX0DER'
421 0.0002 0.00021886825561523
SELECT * FROM productoffers
                WHERE product_id = '128892' AND price > 0
                ORDER BY price ASC LIMIT 1
422 0.0004 0.00042390823364258
SELECT value FROM productattributes WHERE product_id = '128892' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
423 0.0002 0.0001518726348877
UPDATE products SET price = '14685' WHERE id = '128892'
424 0.0003 0.00032687187194824
SELECT * FROM productimages WHERE product_id = '26100' ORDER BY sortorder ASC
425 0.0002 0.00022697448730469
SELECT * FROM product_image_select WHERE product_id = '26100'
426 0.0001 0.00013303756713867
SELECT * FROM productcustomimages WHERE product_id = '26100'
427 0.0027 0.0026888847351074
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '26100' AND a.name = n.originalname
428 0.0002 0.0001981258392334
SELECT * FROM productoffers WHERE product_id = '26100' AND merchantid = 'ATVPDKIKX0DER'
429 0.0002 0.00021505355834961
SELECT * FROM productoffers
                WHERE product_id = '26100' AND price > 0
                ORDER BY price ASC LIMIT 1
430 0.0004 0.00043892860412598
SELECT value FROM productattributes WHERE product_id = '26100' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
431 0.0001 0.00013494491577148
UPDATE products SET price = '132600' WHERE id = '26100'
432 0.0003 0.00034213066101074
SELECT * FROM productimages WHERE product_id = '28249' ORDER BY sortorder ASC
433 0.0002 0.00022602081298828
SELECT * FROM product_image_select WHERE product_id = '28249'
434 0.0001 0.00014400482177734
SELECT * FROM productcustomimages WHERE product_id = '28249'
435 0.0027 0.0026581287384033
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '28249' AND a.name = n.originalname
436 0.0002 0.00020194053649902
SELECT * FROM productoffers WHERE product_id = '28249' AND merchantid = 'ATVPDKIKX0DER'
437 0.0002 0.00022506713867188
SELECT * FROM productoffers
                WHERE product_id = '28249' AND price > 0
                ORDER BY price ASC LIMIT 1
438 0.0004 0.00042915344238281
SELECT value FROM productattributes WHERE product_id = '28249' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
439 0.0001 0.00013995170593262
UPDATE products SET price = '132600' WHERE id = '28249'
440 0.0002 0.00024795532226562
SELECT * FROM productimages WHERE product_id = '131163' ORDER BY sortorder ASC
441 0.0002 0.00022292137145996
SELECT * FROM product_image_select WHERE product_id = '131163'
442 0.0001 0.00013184547424316
SELECT * FROM productcustomimages WHERE product_id = '131163'
443 0.0030 0.0029799938201904
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '131163' AND a.name = n.originalname
444 0.0002 0.00020909309387207
SELECT * FROM productoffers WHERE product_id = '131163' AND merchantid = 'ATVPDKIKX0DER'
445 0.0002 0.00023198127746582
SELECT * FROM productoffers
                WHERE product_id = '131163' AND price > 0
                ORDER BY price ASC LIMIT 1
446 0.0004 0.00040602684020996
SELECT value FROM productattributes WHERE product_id = '131163' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
447 0.0001 0.00013303756713867
UPDATE products SET price = '20362' WHERE id = '131163'
448 0.0003 0.00030684471130371
SELECT * FROM productimages WHERE product_id = '268089' ORDER BY sortorder ASC
449 0.0002 0.00022411346435547
SELECT * FROM product_image_select WHERE product_id = '268089'
450 0.0001 0.00013208389282227
SELECT * FROM productcustomimages WHERE product_id = '268089'
451 0.0037 0.0036609172821045
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '268089' AND a.name = n.originalname
452 0.0002 0.00019288063049316
SELECT * FROM productoffers WHERE product_id = '268089' AND merchantid = 'ATVPDKIKX0DER'
453 0.0002 0.0002140998840332
SELECT * FROM productoffers
                WHERE product_id = '268089' AND price > 0
                ORDER BY price ASC LIMIT 1
454 0.0004 0.00044989585876465
SELECT value FROM productattributes WHERE product_id = '268089' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
455 0.0001 0.00013613700866699
UPDATE products SET price = '9939' WHERE id = '268089'
456 0.0002 0.00024199485778809
SELECT * FROM productimages WHERE product_id = '104864' ORDER BY sortorder ASC
457 0.0002 0.00022482872009277
SELECT * FROM product_image_select WHERE product_id = '104864'
458 0.0001 0.00013303756713867
SELECT * FROM productcustomimages WHERE product_id = '104864'
459 0.0027 0.0026679039001465
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '104864' AND a.name = n.originalname
460 0.0002 0.0001988410949707
SELECT * FROM productoffers WHERE product_id = '104864' AND merchantid = 'ATVPDKIKX0DER'
461 0.0002 0.00022602081298828
SELECT * FROM productoffers
                WHERE product_id = '104864' AND price > 0
                ORDER BY price ASC LIMIT 1
462 0.0004 0.00039386749267578
SELECT value FROM productattributes WHERE product_id = '104864' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
463 0.0001 0.00013494491577148
UPDATE products SET price = '7199' WHERE id = '104864'
464 0.0002 0.00016188621520996
SELECT value FROM parameters WHERE parameter = 'EBAY_CACHE_TIME' 
465 0.0001 0.00013399124145508
SELECT value FROM parameters WHERE parameter = 'EBAY_APP_ID' 
466 0.0001 0.00013089179992676
SELECT value FROM parameters WHERE parameter = 'EBAY_TRACKING_ID' 
467 0.0001 0.00012993812561035
SELECT value FROM parameters WHERE parameter = 'EBAY_NETWORK_ID' 
468 0.0001 0.00013089179992676
SELECT value FROM parameters WHERE parameter = 'EBAY_LOCALE' 
469 0.0001 0.00013399124145508
SELECT value FROM parameters WHERE parameter = 'EBAY_AUTH_TOKEN' 
470 0.0002 0.00015997886657715
SELECT * FROM ebay_locale_details WHERE cur_code = 'USD' 
471 0.2072 0.20717096328735
SELECT * FROM ebay_products_cache WHERE cachekey = '5896717b13546a92c36ebc6a475b8e42' 
472 0.0003 0.00025010108947754
SELECT value FROM parameters WHERE parameter = 'EBAY_APP_ID' 
473 0.0001 0.0001370906829834
SELECT value FROM parameters WHERE parameter = 'EBAY_TRACKING_ID' 
474 0.0001 0.00013208389282227
SELECT value FROM parameters WHERE parameter = 'EBAY_NETWORK_ID' 
475 0.0001 0.00014305114746094
SELECT value FROM parameters WHERE parameter = 'EBAY_LOCALE' 
476 0.0001 0.00013399124145508
SELECT value FROM parameters WHERE parameter = 'EBAY_AUTH_TOKEN' 
477 0.1987 0.198734998703
SELECT * FROM ebay_products_cache WHERE cachekey = '5896717b13546a92c36ebc6a475b8e42' 
478 0.0003 0.00027585029602051
SELECT id,asin FROM products WHERE parent_id = 400620
479 0.0003 0.00034189224243164
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '400620' ORDER BY timestamp DESC
480 0.0002 0.00015902519226074
SELECT category_id FROM products_categories WHERE product_id = '400620'
481 0.0002 0.0002439022064209
SELECT * FROM categories WHERE id = '34'
482 0.0096 0.0096020698547363
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
483 0.0001 0.00014591217041016
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 34
484 0.0003 0.00028896331787109
SELECT id FROM categories WHERE parent_id = '34'
485 0.0002 0.00021791458129883
SELECT id FROM categories WHERE parent_id = '94'
486 0.0002 0.0002140998840332
SELECT id FROM categories WHERE parent_id = '98'
487 0.0002 0.00021195411682129
SELECT id FROM categories WHERE parent_id = '99'
488 0.0002 0.00020980834960938
SELECT id FROM categories WHERE parent_id = '110'
489 0.0002 0.00021600723266602
SELECT id FROM categories WHERE parent_id = '130'
490 0.0101 0.010130882263184
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 
491 0.0002 0.00018906593322754
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 
492 0.0002 0.00017285346984863
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (94,98,99,110,130,34)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
493 0.0002 0.00019502639770508
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '34'
494 0.0031 0.003119945526123
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '400620' AND a.name = n.originalname
495 0.0002 0.00020313262939453
SELECT * FROM productoffers WHERE product_id = '400620' AND merchantid = 'ATVPDKIKX0DER'
496 0.0002 0.00023102760314941
SELECT * FROM productoffers
                WHERE product_id = '400620' AND price > 0
                ORDER BY price ASC LIMIT 1
497 0.0002 0.00021791458129883
SELECT * FROM products WHERE id = '400620'
498 0.0004 0.00044798851013184
SELECT value FROM productattributes WHERE product_id = '400620' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
499 0.0001 0.00013995170593262
UPDATE products SET price = '28999' WHERE id = '400620'
500 0.0031 0.0030710697174072
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '400620' AND a.name = n.originalname
501 0.0002 0.00019407272338867
SELECT * FROM productoffers WHERE product_id = '400620' AND merchantid = 'ATVPDKIKX0DER'
502 0.0002 0.00022697448730469
SELECT * FROM productoffers
                WHERE product_id = '400620' AND price > 0
                ORDER BY price ASC LIMIT 1
503 0.0002 0.00015091896057129
SELECT category_id FROM products_categories WHERE product_id = '400620'
504 0.0001 0.00013518333435059
SELECT parent_id FROM categories WHERE id = '34'
505 0.0002 0.00021600723266602
SELECT * FROM categories WHERE id = '34'
506 0.0093 0.0092818737030029
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
507 0.0001 0.00014400482177734
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 34
508 0.0003 0.0002748966217041
SELECT id FROM categories WHERE parent_id = '34'
509 0.0002 0.00021696090698242
SELECT id FROM categories WHERE parent_id = '94'
510 0.0002 0.0002138614654541
SELECT id FROM categories WHERE parent_id = '98'
511 0.0002 0.00022387504577637
SELECT id FROM categories WHERE parent_id = '99'
512 0.0002 0.0002140998840332
SELECT id FROM categories WHERE parent_id = '110'
513 0.0002 0.00020980834960938
SELECT id FROM categories WHERE parent_id = '130'
514 0.0100 0.010032892227173
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 
515 0.0002 0.00018405914306641
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (94,98,99,110,130,34)
				  AND p.disabled = 0 
516 0.0002 0.00017905235290527
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (94,98,99,110,130,34)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
517 0.0002 0.00019097328186035
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '34'
518 0.0002 0.00018596649169922
SELECT * FROM template_info WHERE templateuid = 'fsb-fluid'
519 0.0002 0.00019001960754395
SELECT * FROM pages WHERE id = 2
520 0.0002 0.00015115737915039
SELECT * FROM pages WHERE id = 4
521 0.0001 0.00014591217041016
SELECT * FROM pages WHERE id = 12
522 0.0001 0.00014901161193848
SELECT * FROM pages WHERE id = 10
523 0.0001 0.00014805793762207
SELECT * FROM pages WHERE id = 7
524 0.0002 0.00016403198242188
SELECT * FROM pages WHERE id = 18
525 0.0002 0.00015616416931152
SELECT * FROM pages WHERE id = 28
526 0.0002 0.0001530647277832
SELECT * FROM pages WHERE id = 13
527 0.0001 0.00014591217041016
SELECT * FROM pages WHERE id = 3
528 0.0318 0.031826972961426
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
529 0.0002 0.00022697448730469
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:1561544347;s:8:\"products\";a:6:{i:2;s:6:\"398858\";i:5;s:6:\"185812\";i:12;s:6:\"247027\";i:13;s:6:\"406758\";i:14;s:6:\"130885\";i:23;s:6:\"404072\";}}' WHERE id = '175'
530 0.0005 0.00046491622924805
SELECT * FROM products WHERE id IN (398858,185812,247027,406758,130885,404072) ORDER BY FIELD(id, 398858,185812,247027,406758,130885,404072 )
531 0.0002 0.00021791458129883
SELECT * FROM productimages WHERE product_id = '398858' ORDER BY sortorder ASC
532 0.0002 0.00022196769714355
SELECT * FROM product_image_select WHERE product_id = '398858'
533 0.0001 0.00013399124145508
SELECT * FROM productcustomimages WHERE product_id = '398858'
534 0.0030 0.0030350685119629
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '398858' AND a.name = n.originalname
535 0.0002 0.00019598007202148
SELECT * FROM productoffers WHERE product_id = '398858' AND merchantid = 'ATVPDKIKX0DER'
536 0.0002 0.00021696090698242
SELECT * FROM productoffers
                WHERE product_id = '398858' AND price > 0
                ORDER BY price ASC LIMIT 1
537 0.0004 0.00042915344238281
SELECT value FROM productattributes WHERE product_id = '398858' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
538 0.0001 0.00014400482177734
UPDATE products SET price = '2999' WHERE id = '398858'
539 0.0007 0.00065398216247559
SELECT * FROM productimages WHERE product_id = '185812' ORDER BY sortorder ASC
540 0.0002 0.00023698806762695
SELECT * FROM product_image_select WHERE product_id = '185812'
541 0.0001 0.00013303756713867
SELECT * FROM productcustomimages WHERE product_id = '185812'
542 0.0021 0.0020821094512939
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '185812' AND a.name = n.originalname
543 0.0002 0.00019383430480957
SELECT * FROM productoffers WHERE product_id = '185812' AND merchantid = 'ATVPDKIKX0DER'
544 0.0002 0.00022101402282715
SELECT * FROM productoffers
                WHERE product_id = '185812' AND price > 0
                ORDER BY price ASC LIMIT 1
545 0.0004 0.00037598609924316
SELECT value FROM productattributes WHERE product_id = '185812' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
546 0.0001 0.00013494491577148
UPDATE products SET price = '314900' WHERE id = '185812'
547 0.0002 0.00021100044250488
SELECT * FROM productimages WHERE product_id = '247027' ORDER BY sortorder ASC
548 0.0002 0.00022602081298828
SELECT * FROM product_image_select WHERE product_id = '247027'
549 0.0001 0.00013208389282227
SELECT * FROM productcustomimages WHERE product_id = '247027'
550 0.0020 0.0020029544830322
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '247027' AND a.name = n.originalname
551 0.0002 0.00019216537475586
SELECT * FROM productoffers WHERE product_id = '247027' AND merchantid = 'ATVPDKIKX0DER'
552 0.0002 0.00021100044250488
SELECT * FROM productoffers
                WHERE product_id = '247027' AND price > 0
                ORDER BY price ASC LIMIT 1
553 0.0004 0.00038909912109375
SELECT value FROM productattributes WHERE product_id = '247027' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
554 0.0001 0.00013303756713867
UPDATE products SET price = '1492' WHERE id = '247027'
555 0.0002 0.00019979476928711
SELECT * FROM productimages WHERE product_id = '406758' ORDER BY sortorder ASC
556 0.0002 0.00021791458129883
SELECT * FROM product_image_select WHERE product_id = '406758'
557 0.0001 0.00012993812561035
SELECT * FROM productcustomimages WHERE product_id = '406758'
558 0.0026 0.0026259422302246
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '406758' AND a.name = n.originalname
559 0.0002 0.00018906593322754
SELECT * FROM productoffers WHERE product_id = '406758' AND merchantid = 'ATVPDKIKX0DER'
560 0.0002 0.00021815299987793
SELECT * FROM productoffers
                WHERE product_id = '406758' AND price > 0
                ORDER BY price ASC LIMIT 1
561 0.0004 0.00040006637573242
SELECT value FROM productattributes WHERE product_id = '406758' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
562 0.0001 0.00013113021850586
UPDATE products SET price = '2694' WHERE id = '406758'
563 0.0002 0.00020790100097656
SELECT * FROM productimages WHERE product_id = '130885' ORDER BY sortorder ASC
564 0.0002 0.00023078918457031
SELECT * FROM product_image_select WHERE product_id = '130885'
565 0.0001 0.00012993812561035
SELECT * FROM productcustomimages WHERE product_id = '130885'
566 0.0020 0.0019688606262207
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '130885' AND a.name = n.originalname
567 0.0002 0.00018906593322754
SELECT * FROM productoffers WHERE product_id = '130885' AND merchantid = 'ATVPDKIKX0DER'
568 0.0002 0.00020980834960938
SELECT * FROM productoffers
                WHERE product_id = '130885' AND price > 0
                ORDER BY price ASC LIMIT 1
569 0.0004 0.00037884712219238
SELECT value FROM productattributes WHERE product_id = '130885' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
570 0.0001 0.00013208389282227
UPDATE products SET price = '1521' WHERE id = '130885'
571 0.0005 0.00053787231445312
SELECT * FROM productimages WHERE product_id = '404072' ORDER BY sortorder ASC
572 0.0002 0.00023198127746582
SELECT * FROM product_image_select WHERE product_id = '404072'
573 0.0001 0.00013184547424316
SELECT * FROM productcustomimages WHERE product_id = '404072'
574 0.0022 0.0021991729736328
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '404072' AND a.name = n.originalname
575 0.0002 0.00019097328186035
SELECT * FROM productoffers WHERE product_id = '404072' AND merchantid = 'ATVPDKIKX0DER'
576 0.0002 0.00022101402282715
SELECT * FROM productoffers
                WHERE product_id = '404072' AND price > 0
                ORDER BY price ASC LIMIT 1
577 0.0004 0.00038290023803711
SELECT value FROM productattributes WHERE product_id = '404072' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
578 0.0001 0.00012993812561035
UPDATE products SET price = '22900' WHERE id = '404072'
579 0.0317 0.031696081161499
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
580 0.0002 0.00022196769714355
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:1561544347;s:8:\"products\";a:6:{i:12;s:6:\"247027\";i:13;s:6:\"406758\";i:15;s:6:\"407620\";i:17;s:6:\"131163\";i:5;s:6:\"185812\";i:10;s:6:\"414825\";}}' WHERE id = '177'
581 0.0005 0.00048303604125977
SELECT * FROM products WHERE id IN (247027,406758,407620,131163,185812,414825) ORDER BY FIELD(id, 247027,406758,407620,131163,185812,414825 )
582 0.0002 0.00022196769714355
SELECT * FROM productimages WHERE product_id = '247027' ORDER BY sortorder ASC
583 0.0002 0.00022196769714355
SELECT * FROM product_image_select WHERE product_id = '247027'
584 0.0001 0.00013303756713867
SELECT * FROM productcustomimages WHERE product_id = '247027'
585 0.0021 0.0020720958709717
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '247027' AND a.name = n.originalname
586 0.0002 0.0001981258392334
SELECT * FROM productoffers WHERE product_id = '247027' AND merchantid = 'ATVPDKIKX0DER'
587 0.0002 0.00021505355834961
SELECT * FROM productoffers
                WHERE product_id = '247027' AND price > 0
                ORDER BY price ASC LIMIT 1
588 0.0004 0.0003821849822998
SELECT value FROM productattributes WHERE product_id = '247027' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
589 0.0001 0.00013589859008789
UPDATE products SET price = '1492' WHERE id = '247027'
590 0.0002 0.00020098686218262
SELECT * FROM productimages WHERE product_id = '406758' ORDER BY sortorder ASC
591 0.0002 0.00021195411682129
SELECT * FROM product_image_select WHERE product_id = '406758'
592 0.0001 0.00012993812561035
SELECT * FROM productcustomimages WHERE product_id = '406758'
593 0.0026 0.0026390552520752
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '406758' AND a.name = n.originalname
594 0.0002 0.00019097328186035
SELECT * FROM productoffers WHERE product_id = '406758' AND merchantid = 'ATVPDKIKX0DER'
595 0.0002 0.00021100044250488
SELECT * FROM productoffers
                WHERE product_id = '406758' AND price > 0
                ORDER BY price ASC LIMIT 1
596 0.0004 0.00041723251342773
SELECT value FROM productattributes WHERE product_id = '406758' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
597 0.0001 0.00013089179992676
UPDATE products SET price = '2694' WHERE id = '406758'
598 0.0002 0.00021696090698242
SELECT * FROM productimages WHERE product_id = '407620' ORDER BY sortorder ASC
599 0.0002 0.00022983551025391
SELECT * FROM product_image_select WHERE product_id = '407620'
600 0.0001 0.00013399124145508
SELECT * FROM productcustomimages WHERE product_id = '407620'
601 0.0023 0.0022780895233154
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '407620' AND a.name = n.originalname
602 0.0002 0.00019598007202148
SELECT * FROM productoffers WHERE product_id = '407620' AND merchantid = 'ATVPDKIKX0DER'
603 0.0002 0.00022101402282715
SELECT * FROM productoffers
                WHERE product_id = '407620' AND price > 0
                ORDER BY price ASC LIMIT 1
604 0.0004 0.00038695335388184
SELECT value FROM productattributes WHERE product_id = '407620' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
605 0.0001 0.00012898445129395
UPDATE products SET price = '20323' WHERE id = '407620'
606 0.0002 0.00023293495178223
SELECT * FROM productimages WHERE product_id = '131163' ORDER BY sortorder ASC
607 0.0002 0.0002291202545166
SELECT * FROM product_image_select WHERE product_id = '131163'
608 0.0001 0.00013113021850586
SELECT * FROM productcustomimages WHERE product_id = '131163'
609 0.0025 0.0025451183319092
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '131163' AND a.name = n.originalname
610 0.0002 0.00020694732666016
SELECT * FROM productoffers WHERE product_id = '131163' AND merchantid = 'ATVPDKIKX0DER'
611 0.0002 0.00022196769714355
SELECT * FROM productoffers
                WHERE product_id = '131163' AND price > 0
                ORDER BY price ASC LIMIT 1
612 0.0004 0.00039577484130859
SELECT value FROM productattributes WHERE product_id = '131163' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
613 0.0001 0.00013089179992676
UPDATE products SET price = '20362' WHERE id = '131163'
614 0.0007 0.00065517425537109
SELECT * FROM productimages WHERE product_id = '185812' ORDER BY sortorder ASC
615 0.0002 0.00022697448730469
SELECT * FROM product_image_select WHERE product_id = '185812'
616 0.0001 0.00014305114746094
SELECT * FROM productcustomimages WHERE product_id = '185812'
617 0.0021 0.0020639896392822
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '185812' AND a.name = n.originalname
618 0.0002 0.00019097328186035
SELECT * FROM productoffers WHERE product_id = '185812' AND merchantid = 'ATVPDKIKX0DER'
619 0.0002 0.00021004676818848
SELECT * FROM productoffers
                WHERE product_id = '185812' AND price > 0
                ORDER BY price ASC LIMIT 1
620 0.0004 0.00039482116699219
SELECT value FROM productattributes WHERE product_id = '185812' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
621 0.0001 0.0001368522644043
UPDATE products SET price = '314900' WHERE id = '185812'
622 0.0002 0.00021696090698242
SELECT * FROM productimages WHERE product_id = '414825' ORDER BY sortorder ASC
623 0.0002 0.00021004676818848
SELECT * FROM product_image_select WHERE product_id = '414825'
624 0.0001 0.00013089179992676
SELECT * FROM productcustomimages WHERE product_id = '414825'
625 0.0020 0.0020320415496826
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '414825' AND a.name = n.originalname
626 0.0002 0.00019407272338867
SELECT * FROM productoffers WHERE product_id = '414825' AND merchantid = 'ATVPDKIKX0DER'
627 0.0002 0.00021505355834961
SELECT * FROM productoffers
                WHERE product_id = '414825' AND price > 0
                ORDER BY price ASC LIMIT 1
628 0.0004 0.00037598609924316
SELECT value FROM productattributes WHERE product_id = '414825' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
629 0.0001 0.00014185905456543
UPDATE products SET price = '11999' WHERE id = '414825'
630 0.0820 0.081954956054688
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
631 0.0003 0.00027298927307129
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:1561544347;s:8:\"products\";a:6:{i:3;s:6:\"290575\";i:4;s:6:\"171938\";i:5;s:6:\"185812\";i:13;s:6:\"406758\";i:14;s:6:\"130885\";i:15;s:6:\"407620\";}}' WHERE id = '181'
632 0.0005 0.00047516822814941
SELECT * FROM products WHERE id IN (290575,171938,185812,406758,130885,407620) ORDER BY FIELD(id, 290575,171938,185812,406758,130885,407620 )
633 0.0006 0.00058317184448242
SELECT * FROM productimages WHERE product_id = '290575' ORDER BY sortorder ASC
634 0.0002 0.00022196769714355
SELECT * FROM product_image_select WHERE product_id = '290575'
635 0.0001 0.0001370906829834
SELECT * FROM productcustomimages WHERE product_id = '290575'
636 0.0034 0.0034139156341553
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '290575' AND a.name = n.originalname
637 0.0002 0.0001978874206543
SELECT * FROM productoffers WHERE product_id = '290575' AND merchantid = 'ATVPDKIKX0DER'
638 0.0002 0.00023412704467773
SELECT * FROM productoffers
                WHERE product_id = '290575' AND price > 0
                ORDER BY price ASC LIMIT 1
639 0.0005 0.00045204162597656
SELECT value FROM productattributes WHERE product_id = '290575' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
640 0.0001 0.00013208389282227
UPDATE products SET price = '549500' WHERE id = '290575'
641 0.0006 0.00060486793518066
SELECT * FROM productimages WHERE product_id = '171938' ORDER BY sortorder ASC
642 0.0002 0.00022196769714355
SELECT * FROM product_image_select WHERE product_id = '171938'
643 0.0001 0.00013184547424316
SELECT * FROM productcustomimages WHERE product_id = '171938'
644 0.0025 0.002532958984375
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '171938' AND a.name = n.originalname
645 0.0002 0.00019121170043945
SELECT * FROM productoffers WHERE product_id = '171938' AND merchantid = 'ATVPDKIKX0DER'
646 0.0002 0.00022506713867188
SELECT * FROM productoffers
                WHERE product_id = '171938' AND price > 0
                ORDER BY price ASC LIMIT 1
647 0.0004 0.00040197372436523
SELECT value FROM productattributes WHERE product_id = '171938' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
648 0.0001 0.00013089179992676
UPDATE products SET price = '388900' WHERE id = '171938'
649 0.0007 0.00065207481384277
SELECT * FROM productimages WHERE product_id = '185812' ORDER BY sortorder ASC
650 0.0002 0.00022292137145996
SELECT * FROM product_image_select WHERE product_id = '185812'
651 0.0001 0.00013089179992676
SELECT * FROM productcustomimages WHERE product_id = '185812'
652 0.0021 0.0020768642425537
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '185812' AND a.name = n.originalname
653 0.0002 0.00019001960754395
SELECT * FROM productoffers WHERE product_id = '185812' AND merchantid = 'ATVPDKIKX0DER'
654 0.0002 0.00021004676818848
SELECT * FROM productoffers
                WHERE product_id = '185812' AND price > 0
                ORDER BY price ASC LIMIT 1
655 0.0004 0.00037312507629395
SELECT value FROM productattributes WHERE product_id = '185812' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
656 0.0002 0.0001530647277832
UPDATE products SET price = '314900' WHERE id = '185812'
657 0.0002 0.00020098686218262
SELECT * FROM productimages WHERE product_id = '406758' ORDER BY sortorder ASC
658 0.0002 0.00022196769714355
SELECT * FROM product_image_select WHERE product_id = '406758'
659 0.0001 0.00013089179992676
SELECT * FROM productcustomimages WHERE product_id = '406758'
660 0.0026 0.0026249885559082
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '406758' AND a.name = n.originalname
661 0.0002 0.00018978118896484
SELECT * FROM productoffers WHERE product_id = '406758' AND merchantid = 'ATVPDKIKX0DER'
662 0.0002 0.00021004676818848
SELECT * FROM productoffers
                WHERE product_id = '406758' AND price > 0
                ORDER BY price ASC LIMIT 1
663 0.0004 0.00041007995605469
SELECT value FROM productattributes WHERE product_id = '406758' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
664 0.0001 0.00013089179992676
UPDATE products SET price = '2694' WHERE id = '406758'
665 0.0002 0.00020408630371094
SELECT * FROM productimages WHERE product_id = '130885' ORDER BY sortorder ASC
666 0.0002 0.00021791458129883
SELECT * FROM product_image_select WHERE product_id = '130885'
667 0.0001 0.00014519691467285
SELECT * FROM productcustomimages WHERE product_id = '130885'
668 0.0020 0.0019741058349609
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '130885' AND a.name = n.originalname
669 0.0002 0.00019001960754395
SELECT * FROM productoffers WHERE product_id = '130885' AND merchantid = 'ATVPDKIKX0DER'
670 0.0002 0.00020885467529297
SELECT * FROM productoffers
                WHERE product_id = '130885' AND price > 0
                ORDER BY price ASC LIMIT 1
671 0.0004 0.00036478042602539
SELECT value FROM productattributes WHERE product_id = '130885' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
672 0.0001 0.00013303756713867
UPDATE products SET price = '1521' WHERE id = '130885'
673 0.0002 0.0002140998840332
SELECT * FROM productimages WHERE product_id = '407620' ORDER BY sortorder ASC
674 0.0002 0.00021719932556152
SELECT * FROM product_image_select WHERE product_id = '407620'
675 0.0001 0.00013089179992676
SELECT * FROM productcustomimages WHERE product_id = '407620'
676 0.0023 0.0022737979888916
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '407620' AND a.name = n.originalname
677 0.0002 0.0001988410949707
SELECT * FROM productoffers WHERE product_id = '407620' AND merchantid = 'ATVPDKIKX0DER'
678 0.0002 0.00022101402282715
SELECT * FROM productoffers
                WHERE product_id = '407620' AND price > 0
                ORDER BY price ASC LIMIT 1
679 0.0004 0.00039505958557129
SELECT value FROM productattributes WHERE product_id = '407620' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
680 0.0001 0.00013184547424316
UPDATE products SET price = '20323' WHERE id = '407620'
681 0.0816 0.08160400390625
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
682 0.0003 0.00026893615722656
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:1561544347;s:8:\"products\";a:6:{i:0;s:6:\"414940\";i:3;s:6:\"290575\";i:10;s:6:\"414825\";i:13;s:6:\"406758\";i:16;s:6:\"408078\";i:19;s:6:\"406901\";}}' WHERE id = '183'
683 0.0005 0.00045394897460938
SELECT * FROM products WHERE id IN (414940,290575,414825,406758,408078,406901) ORDER BY FIELD(id, 414940,290575,414825,406758,408078,406901 )
684 0.0002 0.00020313262939453
SELECT * FROM productimages WHERE product_id = '414940' ORDER BY sortorder ASC
685 0.0002 0.00023198127746582
SELECT * FROM product_image_select WHERE product_id = '414940'
686 0.0001 0.00013589859008789
SELECT * FROM productcustomimages WHERE product_id = '414940'
687 0.0033 0.0032570362091064
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '414940' AND a.name = n.originalname
688 0.0002 0.00019383430480957
SELECT * FROM productoffers WHERE product_id = '414940' AND merchantid = 'ATVPDKIKX0DER'
689 0.0002 0.00023198127746582
SELECT * FROM productoffers
                WHERE product_id = '414940' AND price > 0
                ORDER BY price ASC LIMIT 1
690 0.0005 0.00045394897460938
SELECT value FROM productattributes WHERE product_id = '414940' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
691 0.0001 0.00013208389282227
UPDATE products SET price = '4490' WHERE id = '414940'
692 0.0006 0.00057411193847656
SELECT * FROM productimages WHERE product_id = '290575' ORDER BY sortorder ASC
693 0.0002 0.00022387504577637
SELECT * FROM product_image_select WHERE product_id = '290575'
694 0.0001 0.00013089179992676
SELECT * FROM productcustomimages WHERE product_id = '290575'
695 0.0034 0.0034060478210449
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '290575' AND a.name = n.originalname
696 0.0002 0.00019598007202148
SELECT * FROM productoffers WHERE product_id = '290575' AND merchantid = 'ATVPDKIKX0DER'
697 0.0002 0.00021791458129883
SELECT * FROM productoffers
                WHERE product_id = '290575' AND price > 0
                ORDER BY price ASC LIMIT 1
698 0.0005 0.0004570484161377
SELECT value FROM productattributes WHERE product_id = '290575' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
699 0.0001 0.00013089179992676
UPDATE products SET price = '549500' WHERE id = '290575'
700 0.0002 0.00021505355834961
SELECT * FROM productimages WHERE product_id = '414825' ORDER BY sortorder ASC
701 0.0002 0.00022602081298828
SELECT * FROM product_image_select WHERE product_id = '414825'
702 0.0001 0.00013303756713867
SELECT * FROM productcustomimages WHERE product_id = '414825'
703 0.0020 0.0020370483398438
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '414825' AND a.name = n.originalname
704 0.0002 0.00019407272338867
SELECT * FROM productoffers WHERE product_id = '414825' AND merchantid = 'ATVPDKIKX0DER'
705 0.0002 0.00021696090698242
SELECT * FROM productoffers
                WHERE product_id = '414825' AND price > 0
                ORDER BY price ASC LIMIT 1
706 0.0004 0.00038886070251465
SELECT value FROM productattributes WHERE product_id = '414825' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
707 0.0001 0.00013089179992676
UPDATE products SET price = '11999' WHERE id = '414825'
708 0.0002 0.00020098686218262
SELECT * FROM productimages WHERE product_id = '406758' ORDER BY sortorder ASC
709 0.0002 0.00022292137145996
SELECT * FROM product_image_select WHERE product_id = '406758'
710 0.0001 0.00013089179992676
SELECT * FROM productcustomimages WHERE product_id = '406758'
711 0.0026 0.0026371479034424
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '406758' AND a.name = n.originalname
712 0.0002 0.00018978118896484
SELECT * FROM productoffers WHERE product_id = '406758' AND merchantid = 'ATVPDKIKX0DER'
713 0.0002 0.00022006034851074
SELECT * FROM productoffers
                WHERE product_id = '406758' AND price > 0
                ORDER BY price ASC LIMIT 1
714 0.0004 0.00040102005004883
SELECT value FROM productattributes WHERE product_id = '406758' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
715 0.0001 0.00013208389282227
UPDATE products SET price = '2694' WHERE id = '406758'
716 0.0002 0.00021600723266602
SELECT * FROM productimages WHERE product_id = '408078' ORDER BY sortorder ASC
717 0.0002 0.00022602081298828
SELECT * FROM product_image_select WHERE product_id = '408078'
718 0.0001 0.00013089179992676
SELECT * FROM productcustomimages WHERE product_id = '408078'
719 0.0024 0.0023949146270752
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '408078' AND a.name = n.originalname
720 0.0002 0.00019097328186035
SELECT * FROM productoffers WHERE product_id = '408078' AND merchantid = 'ATVPDKIKX0DER'
721 0.0002 0.00021600723266602
SELECT * FROM productoffers
                WHERE product_id = '408078' AND price > 0
                ORDER BY price ASC LIMIT 1
722 0.0003 0.00034594535827637
SELECT value FROM productattributes WHERE product_id = '408078' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
723 0.0001 0.00012898445129395
UPDATE products SET price = '24109' WHERE id = '408078'
724 0.0002 0.00020909309387207
SELECT * FROM productimages WHERE product_id = '406901' ORDER BY sortorder ASC
725 0.0002 0.00022292137145996
SELECT * FROM product_image_select WHERE product_id = '406901'
726 0.0001 0.00013089179992676
SELECT * FROM productcustomimages WHERE product_id = '406901'
727 0.0023 0.0023009777069092
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '406901' AND a.name = n.originalname
728 0.0002 0.00019097328186035
SELECT * FROM productoffers WHERE product_id = '406901' AND merchantid = 'ATVPDKIKX0DER'
729 0.0002 0.00021886825561523
SELECT * FROM productoffers
                WHERE product_id = '406901' AND price > 0
                ORDER BY price ASC LIMIT 1
730 0.0004 0.00035190582275391
SELECT value FROM productattributes WHERE product_id = '406901' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
731 0.0001 0.00013113021850586
UPDATE products SET price = '395' WHERE id = '406901'
732 0.0004 0.00042891502380371
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid' AND area = 'header' ORDER BY sortorder ASC
733 0.0001 0.00014376640319824
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
734 0.0001 0.00013399124145508
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
735 0.0001 0.00013113021850586
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
736 0.0001 0.00013494491577148
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
737 0.0004 0.00040698051452637
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid' AND area = 'footer' ORDER BY sortorder ASC
738 0.0001 0.00013399124145508
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
739 0.0001 0.00014305114746094
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
740 0.0001 0.00013089179992676
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
741 0.0009 0.00091004371643066
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-fluid' AND skinuid = ''
742 0.0003 0.00031614303588867
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid'
743 0.0003 0.00030303001403809
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid'
744 0.0005 0.0004580020904541
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid' AND imageuid = 'HEAD_CUSTOM_BANNER'
745 0.0003 0.00031495094299316
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid' AND imageuid = 'HEAD_CUSTOM_BANNER'