Tactical Equipment - Survivalist Equipment

American Defense AD-RECON STD Riflescope Optic Mount (Black, 30 mm) by American Defense Mfg

Price: $188.95
Product prices and availability are accurate as of 2019-06-15 18:03:23 UTC and are subject to change. Any price and availability information displayed on http://www.amazon.com/ at the time of purchase will apply to the purchase of this product.
Availability: Not Available - stock arriving soon
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

Our Combat Gear shop is delighted to offer the brilliant American Defense AD-RECON STD Riflescope Optic Mount (Black, 30 mm) today at this special price.

With so many competing tactical, combat and survival products available recently, it is good to have a make that you can recognize. The American Defense AD-RECON STD Riflescope Optic Mount (Black, 30 mm) is certainly all that and will be a perfect acquisition for your combat gear or tactical ability.

We pride ourselves on providing the highest quality combat gear for all your front line requirements.

For this reduced price, the American Defense AD-RECON STD Riflescope Optic Mount (Black, 30 mm) is greatly respected and is always a popular choice for lots of like minded people. American Defense Mfg have produced some nice touches and this results in better value.

Manufacturer Description

The AD-RECON mount is made for putting high power glass onto a flattop style AR-15. The cantilever throws the scope out front, enabling you of getting the right eye relief. It is precision machined from 6061 T6 aluminum and completed in hard coat T3 Mil-Spec anodize. It showcases the Patented QD Automobile Lock Lever system to accommodate both in specification and out of spec rail systems.

Product Features

Does not require proprietary tools for adjustment Can be adjusted with your finger or a flat blade screwdriver Lever can be configured to lock to the front or the rear Superior clamping surface to insure maximum rail engagement Made with pride in the U.S.A

Write a Review

Debug Overview

App Total Time DB Queries DB Query Total Time Amazon Requests
2.5364298820496 758 1.3519 0


No Amazon API Requests Made.


App Debug - Total Time 2.5364298820496 seconds

Number Time From Start Name Description
1 0.43643188476562 Initialise Initialise FSB Function
2 0.44765496253967 App Controller Start Start of the App controller (called before the controller of every page)
3 0.45887088775635 Start of getCategoryListByGroup Function Before first category groups query
4 0.4590528011322 After initial query Before first category groups query
5 0.4590539932251 Get Category List for Group Before the call to getCategoryList function
6 0.45905780792236 Start of GetCategoryList function Start of the function
7 0.45906186103821 Before getting categories Query to get specific category list
8 0.45972800254822 After getting categories Query to get specific category list
9 0.45972895622253 Before getting category custom Before call to function getCategoryCustom
10 0.46171998977661 After getting category custom After call to function getCategoryCustom
11 0.46172285079956 Before getting category custom Before call to function getCategoryCustom
12 0.47239589691162 After getting category custom After call to function getCategoryCustom
13 0.47239899635315 Before getting category custom Before call to function getCategoryCustom
14 0.47805595397949 After getting category custom After call to function getCategoryCustom
15 0.47805881500244 Before getting category custom Before call to function getCategoryCustom
16 0.48227000236511 After getting category custom After call to function getCategoryCustom
17 0.48227190971375 End of GetCategoryList function End of the function
18 0.48228192329407 Get Category List for Group Before the call to getCategoryList function
19 0.4822838306427 Start of GetCategoryList function Start of the function
20 0.48228788375854 Before getting categories Query to get specific category list
21 0.48276686668396 After getting categories Query to get specific category list
22 0.48276877403259 Before getting category custom Before call to function getCategoryCustom
23 0.48840594291687 After getting category custom After call to function getCategoryCustom
24 0.48840880393982 Before getting category custom Before call to function getCategoryCustom
25 0.49914383888245 After getting category custom After call to function getCategoryCustom
26 0.49914598464966 End of GetCategoryList function End of the function
27 0.49915289878845 Get Category List for Group Before the call to getCategoryList function
28 0.4991569519043 Start of GetCategoryList function Start of the function
29 0.49915981292725 Before getting categories Query to get specific category list
30 0.49994087219238 After getting categories Query to get specific category list
31 0.49994277954102 Before getting category custom Before call to function getCategoryCustom
32 0.50919485092163 After getting category custom After call to function getCategoryCustom
33 0.50919795036316 Before getting category custom Before call to function getCategoryCustom
34 0.52657079696655 After getting category custom After call to function getCategoryCustom
35 0.52657389640808 Before getting category custom Before call to function getCategoryCustom
36 0.53258395195007 After getting category custom After call to function getCategoryCustom
37 0.53258681297302 Before getting category custom Before call to function getCategoryCustom
38 0.53855776786804 After getting category custom After call to function getCategoryCustom
39 0.53856086730957 Before getting category custom Before call to function getCategoryCustom
40 0.54491591453552 After getting category custom After call to function getCategoryCustom
41 0.54491877555847 Before getting category custom Before call to function getCategoryCustom
42 0.56681489944458 After getting category custom After call to function getCategoryCustom
43 0.56681799888611 Before getting category custom Before call to function getCategoryCustom
44 0.57099390029907 After getting category custom After call to function getCategoryCustom
45 0.5709969997406 Before getting category custom Before call to function getCategoryCustom
46 0.57567882537842 After getting category custom After call to function getCategoryCustom
47 0.57568097114563 End of GetCategoryList function End of the function
48 0.57569599151611 Get Category List for Group Before the call to getCategoryList function
49 0.57569789886475 Start of GetCategoryList function Start of the function
50 0.57570290565491 Before getting categories Query to get specific category list
51 0.57615399360657 After getting categories Query to get specific category list
52 0.57615494728088 Before getting category custom Before call to function getCategoryCustom
53 0.57855176925659 After getting category custom After call to function getCategoryCustom
54 0.57855486869812 Before getting category custom Before call to function getCategoryCustom
55 0.58094382286072 After getting category custom After call to function getCategoryCustom
56 0.58094692230225 End of GetCategoryList function End of the function
57 0.58095288276672 Get Category List for Group Before the call to getCategoryList function
58 0.58095479011536 Start of GetCategoryList function Start of the function
59 0.5809588432312 Before getting categories Query to get specific category list
60 0.58128976821899 After getting categories Query to get specific category list
61 0.58129191398621 Before getting category custom Before call to function getCategoryCustom
62 0.58631587028503 After getting category custom After call to function getCategoryCustom
63 0.58631777763367 End of GetCategoryList function End of the function
64 0.58632493019104 End of getCategoryListByGroup Function Before return()
65 0.6409227848053 App Controller End End of the App controller (called before the controller of every page)
66 0.64159893989563 Product Start Start of the product info controller
67 0.642422914505 Cache file not found Starting get product details
68 0.67981481552124 Related products Start getting related products if enabled
69 0.67981696128845 Related Products Start Before the related products are found
70 0.67981791496277 Related Products Keywords Before the related product keywords are found
71 0.67982387542725 Create Keyword List Function Start of function
72 0.68062591552734 Create Keyword List Function After looping provided content - 590 keywords found
73 0.71851587295532 Create Keyword List Function After looping initial keyword list - 541 keywords remaining
74 0.71866178512573 Create Keyword List Function After reducing keyword list
75 0.71983695030212 Create Keyword List Function After selecting by scoring keywords
76 0.7198429107666 Create Keyword List Function After final loop of keywords
77 0.71984696388245 Related Products Keywords After the related product keywords are found
78 1.0008399486542 Related Products End After the related products are found
79 1.1871938705444 Start Remote Request http://svcs.ebay.com/services/search/FindingServic...
80 1.3225588798523 End Remote Request http://svcs.ebay.com/services/search/FindingServic...
81 1.5718069076538 Product End End of the product info controller (Product Info)
82 1.5721619129181 App_after Controller Start Start of the App_after controller (called after the controller of every page)
83 1.5722479820251 Before Get Options Before the call to getOptions in the tpl class
84 1.9970288276672 After Get Options After the call to getOptions in the tpl class
85 1.9972407817841 App_after Controller End End of the App_after controller (called after the controller of every page)
86 1.9972548484802 Product Info: Before Smarty Fetch Before the product.tpl template is fetched
87 2.3323757648468 Product Info: After Smarty Fetch After the product.tpl template is fetched
88 2.3323819637299 Product Info: Before Template Display Before the template is displayed
89 2.5364058017731 Product Info: After Template Display After the template is displayed
90 2.5364120006561 Finalizing debug Before the debug is output to the page.
91 2.5364289283752 End of App This is the end of the app logging, final timestamp


Query Debug - 758 Database Queries. Total time 1.3519 seconds

Number Time (Seconds) Time (Milliseconds) Query
1 0.0002 0.00016593933105469
SELECT value FROM parameters WHERE `parameter` = 'BAD_BOTS_ENABLER'
2 0.0004 0.00042915344238281
SHOW TABLES LIKE 'bad_bots'
3 0.0002 0.00015807151794434
SELECT value FROM parameters WHERE `parameter` = 'STORE_WHITELISTED_IPS'
4 0.0002 0.00017309188842773
SELECT * FROM `bad_bots`
5 0.0005 0.00046586990356445
SELECT parameter, value FROM parameters
6 0.0002 0.00015401840209961
SET time_zone = 'Europe/London'
7 0.0003 0.0002739429473877
SELECT * FROM autorun ORDER BY lastrun ASC
8 0.0002 0.00017404556274414
SELECT * FROM version ORDER BY installed DESC LIMIT 1
9 0.0001 0.00010991096496582
delete from cachefiles
10 0.0002 0.0002288818359375
SELECT id FROM pages WHERE pagename = 'american-defense-ad-recon-std-riflescope-optic-mount-black-30-mm' LIMIT 1
11 0.0002 0.00024604797363281
SELECT id FROM products WHERE pagename = 'american-defense-ad-recon-std-riflescope-optic-mount-black-30-mm' AND hidden = 0 LIMIT 1
12 0.0008 0.00084805488586426
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-fluid'
13 0.0094 0.0093619823455811
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-fluid' AND language = 'en'
14 0.0002 0.00022482872009277
SELECT * FROM pages WHERE pagename = 'american-defense-ad-recon-std-riflescope-optic-mount-black-30-mm'
15 0.0002 0.00016307830810547
SELECT * FROM categorygroups ORDER BY sortorder ASC
16 0.0006 0.00061702728271484
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
17 0.0005 0.00048494338989258
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 49
18 0.0003 0.00026106834411621
SELECT id FROM categories WHERE parent_id = '49'
19 0.0005 0.0004580020904541
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.00015616416931152
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.00016379356384277
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.0001990795135498
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '49'
23 0.0001 0.00013899803161621
SELECT * FROM categorygroups WHERE id = '1'
24 0.0030 0.0029940605163574
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.00026893615722656
SELECT id FROM categories WHERE parent_id = '50'
26 0.0002 0.00021791458129883
SELECT id FROM categories WHERE parent_id = '96'
27 0.0002 0.00022506713867188
SELECT id FROM categories WHERE parent_id = '97'
28 0.0002 0.0002140998840332
SELECT id FROM categories WHERE parent_id = '111'
29 0.0002 0.00021100044250488
SELECT id FROM categories WHERE parent_id = '129'
30 0.0057 0.0056848526000977
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.00017905235290527
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.00016880035400391
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.00018787384033203
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '50'
34 0.0001 0.0001380443572998
SELECT * FROM categorygroups WHERE id = '1'
35 0.0023 0.0023050308227539
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.0023 0.0023269653320312
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.00016498565673828
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.00016307830810547
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.00017690658569336
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '80'
41 0.0001 0.0001370906829834
SELECT * FROM categorygroups WHERE id = '1'
42 0.0012 0.0011570453643799
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.00026988983154297
SELECT id FROM categories WHERE parent_id = '51'
44 0.0002 0.00021886825561523
SELECT id FROM categories WHERE parent_id = '101'
45 0.0018 0.001788854598999
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.00016212463378906
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.00016379356384277
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.0001838207244873
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '51'
49 0.0001 0.0001368522644043
SELECT * FROM categorygroups WHERE id = '1'
50 0.0004 0.00044894218444824
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '2'  AND hidden = 0 ORDER BY sortorder ASC
51 0.0023 0.0022931098937988
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.0002601146697998
SELECT id FROM categories WHERE parent_id = '30'
53 0.0023 0.002316951751709
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.00015902519226074
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.00016498565673828
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.00018620491027832
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
57 0.0001 0.0001380443572998
SELECT * FROM categorygroups WHERE id = '2'
58 0.0048 0.0048239231109619
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.0002899169921875
SELECT id FROM categories WHERE parent_id = '61'
60 0.0048 0.00484299659729
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.00017404556274414
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.00016188621520996
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.00018000602722168
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '61'
64 0.0001 0.00013589859008789
SELECT * FROM categorygroups WHERE id = '2'
65 0.0007 0.00071001052856445
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '10'  AND hidden = 0 ORDER BY sortorder ASC
66 0.0041 0.0040969848632812
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.00027585029602051
SELECT id FROM categories WHERE parent_id = '64'
68 0.0041 0.0041100978851318
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.00016403198242188
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.00016188621520996
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (64)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
71 0.0002 0.00018000602722168
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '64'
72 0.0001 0.0001370906829834
SELECT * FROM categorygroups WHERE id = '10'
73 0.0081 0.008101224899292
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.00030016899108887
SELECT id FROM categories WHERE parent_id = '65'
75 0.0082 0.0081768035888672
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (65)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
76 0.0002 0.00017213821411133
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (65)
				  AND p.disabled = 0 
77 0.0002 0.00016188621520996
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (65)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
78 0.0002 0.00018215179443359
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '65'
79 0.0001 0.00014805793762207
SELECT * FROM categorygroups WHERE id = '10'
80 0.0025 0.0024778842926025
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.00027108192443848
SELECT id FROM categories WHERE parent_id = '81'
82 0.0025 0.0024998188018799
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.00015783309936523
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.00016188621520996
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.00017690658569336
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '81'
86 0.0001 0.00014400482177734
SELECT * FROM categorygroups WHERE id = '10'
87 0.0024 0.0024409294128418
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 31
88 0.0003 0.00026798248291016
SELECT id FROM categories WHERE parent_id = '31'
89 0.0025 0.0024948120117188
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (31)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
90 0.0002 0.00015997886657715
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (31)
				  AND p.disabled = 0 
91 0.0002 0.00016093254089355
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.00018191337585449
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
93 0.0001 0.00014686584472656
SELECT * FROM categorygroups WHERE id = '10'
94 0.0022 0.0022480487823486
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.00026607513427734
SELECT id FROM categories WHERE parent_id = '66'
96 0.0002 0.00021696090698242
SELECT id FROM categories WHERE parent_id = '131'
97 0.0028 0.0028338432312012
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.00016498565673828
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (131,66)
				  AND p.disabled = 0 
99 0.0002 0.00017905235290527
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (131,66)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
100 0.0002 0.00017809867858887
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '66'
101 0.0001 0.00013613700866699
SELECT * FROM categorygroups WHERE id = '10'
102 0.0094 0.0094270706176758
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 34
103 0.0003 0.00030183792114258
SELECT id FROM categories WHERE parent_id = '34'
104 0.0002 0.00021815299987793
SELECT id FROM categories WHERE parent_id = '94'
105 0.0002 0.0002140998840332
SELECT id FROM categories WHERE parent_id = '98'
106 0.0002 0.0002131462097168
SELECT id FROM categories WHERE parent_id = '99'
107 0.0002 0.00022196769714355
SELECT id FROM categories WHERE parent_id = '110'
108 0.0002 0.00021219253540039
SELECT id FROM categories WHERE parent_id = '130'
109 0.0102 0.010184049606323
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.0001838207244873
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.00017118453979492
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (94,98,99,110,130,34)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
112 0.0002 0.00020408630371094
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '34'
113 0.0001 0.0001380443572998
SELECT * FROM categorygroups WHERE id = '10'
114 0.0016 0.0015590190887451
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 32
115 0.0003 0.00027585029602051
SELECT id FROM categories WHERE parent_id = '32'
116 0.0016 0.0015850067138672
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.00016283988952637
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.00016307830810547
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (32)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
119 0.0002 0.00017905235290527
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '32'
120 0.0001 0.0001370906829834
SELECT * FROM categorygroups WHERE id = '10'
121 0.0018 0.0018110275268555
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.00026321411132812
SELECT id FROM categories WHERE parent_id = '89'
123 0.0018 0.0018432140350342
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.00015592575073242
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.00015997886657715
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.00019502639770508
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '89'
127 0.0001 0.0001380443572998
SELECT * FROM categorygroups WHERE id = '10'
128 0.0004 0.00041913986206055
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '17'  AND hidden = 0 ORDER BY sortorder ASC
129 0.0007 0.00069379806518555
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.00024890899658203
SELECT id FROM categories WHERE parent_id = '84'
131 0.0007 0.0007021427154541
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (84)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
132 0.0002 0.00015020370483398
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (84)
				  AND p.disabled = 0 
133 0.0002 0.00015997886657715
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (84)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
134 0.0002 0.00018000602722168
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '84'
135 0.0001 0.00014710426330566
SELECT * FROM categorygroups WHERE id = '17'
136 0.0007 0.00068283081054688
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.0003 0.00025582313537598
SELECT id FROM categories WHERE parent_id = '90'
138 0.0007 0.00071907043457031
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.00016498565673828
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.00017213821411133
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '90'
142 0.0001 0.00013494491577148
SELECT * FROM categorygroups WHERE id = '17'
143 0.0003 0.00031185150146484
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '20'  AND hidden = 0 ORDER BY sortorder ASC
144 0.0020 0.0019960403442383
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.00025796890258789
SELECT id FROM categories WHERE parent_id = '92'
146 0.0020 0.0020389556884766
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.0001530647277832
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.00015997886657715
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.00016498565673828
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '92'
150 0.0001 0.0001370906829834
SELECT * FROM categorygroups WHERE id = '20'
151 0.0051 0.0050930976867676
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
152 0.0004 0.00037884712219238
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-fluid' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
153 0.0002 0.00018000602722168
SELECT value FROM parameters WHERE parameter = 'EBAY_APP_ID' 
154 0.0002 0.00016522407531738
SELECT * FROM sideboxes_pages WHERE sidebox_id = '1'
155 0.0002 0.00018000602722168
SELECT * FROM pages WHERE id = '67'
156 0.0002 0.00016903877258301
SELECT * FROM pages WHERE id = '82'
157 0.0002 0.00017404556274414
SELECT * FROM pages WHERE id = '84'
158 0.0002 0.00016403198242188
SELECT * FROM pages WHERE id = '94'
159 0.0002 0.00016689300537109
SELECT * FROM pages WHERE id = '116'
160 0.0002 0.00023102760314941
SELECT * FROM pages WHERE id = '52'
161 0.0002 0.00016999244689941
SELECT * FROM pages WHERE id = '135'
162 0.0002 0.00017881393432617
SELECT * FROM pages WHERE id = '245'
163 0.0002 0.00017809867858887
SELECT * FROM pages WHERE id = '269'
164 0.0002 0.0002129077911377
SELECT * FROM pages WHERE id = '275'
165 0.0002 0.00021195411682129
SELECT * FROM pages WHERE id = '280'
166 0.0002 0.00020909309387207
SELECT * FROM pages WHERE id = '357'
167 0.0002 0.0001680850982666
SELECT * FROM pages WHERE id = '379'
168 0.0002 0.00015521049499512
SELECT * FROM pages WHERE id = '401'
169 0.0002 0.00016403198242188
SELECT * FROM pages WHERE id = '450'
170 0.0002 0.00016188621520996
SELECT * FROM pages WHERE id = '454'
171 0.0002 0.00016999244689941
SELECT * FROM pages WHERE id = '457'
172 0.0002 0.0001838207244873
SELECT * FROM pages WHERE id = '458'
173 0.0002 0.00017094612121582
SELECT * FROM sideboxes_pages WHERE sidebox_id = '2'
174 0.0002 0.00017404556274414
SELECT * FROM pages WHERE id = '41'
175 0.0002 0.00017499923706055
SELECT * FROM pages WHERE id = '43'
176 0.0002 0.00016307830810547
SELECT * FROM pages WHERE id = '44'
177 0.0002 0.00017094612121582
SELECT * FROM pages WHERE id = '68'
178 0.0002 0.00022292137145996
SELECT * FROM pages WHERE id = '80'
179 0.0002 0.00017595291137695
SELECT * FROM pages WHERE id = '85'
180 0.0002 0.0001680850982666
SELECT * FROM pages WHERE id = '97'
181 0.0002 0.0001680850982666
SELECT * FROM pages WHERE id = '107'
182 0.0002 0.00016498565673828
SELECT * FROM pages WHERE id = '108'
183 0.0002 0.0001530647277832
SELECT * FROM pages WHERE id = '128'
184 0.0002 0.00017690658569336
SELECT * FROM pages WHERE id = '133'
185 0.0002 0.00016093254089355
SELECT * FROM pages WHERE id = '148'
186 0.0002 0.00016903877258301
SELECT * FROM pages WHERE id = '217'
187 0.0002 0.0001680850982666
SELECT * FROM pages WHERE id = '228'
188 0.0002 0.00016307830810547
SELECT * FROM pages WHERE id = '257'
189 0.0002 0.0001680850982666
SELECT * FROM pages WHERE id = '271'
190 0.0002 0.00015902519226074
SELECT * FROM pages WHERE id = '286'
191 0.0002 0.00015592575073242
SELECT * FROM pages WHERE id = '287'
192 0.0002 0.00018095970153809
SELECT * FROM pages WHERE id = '291'
193 0.0002 0.00016999244689941
SELECT * FROM pages WHERE id = '380'
194 0.0002 0.00017094612121582
SELECT * FROM pages WHERE id = '344'
195 0.0002 0.00017690658569336
SELECT * FROM pages WHERE id = '354'
196 0.0002 0.00020909309387207
SELECT * FROM pages WHERE id = '363'
197 0.0002 0.0002291202545166
SELECT * FROM pages WHERE id = '364'
198 0.0002 0.00016117095947266
SELECT * FROM pages WHERE id = '368'
199 0.0002 0.00018882751464844
SELECT * FROM pages WHERE id = '369'
200 0.0002 0.00015807151794434
SELECT * FROM pages WHERE id = '400'
201 0.0002 0.00016903877258301
SELECT * FROM pages WHERE id = '463'
202 0.0002 0.00019502639770508
SELECT * FROM sideboxes_pages WHERE sidebox_id = '33'
203 0.0003 0.00025391578674316
SELECT * FROM pages WHERE id = '66'
204 0.0002 0.0002131462097168
SELECT * FROM pages WHERE id = '77'
205 0.0002 0.00021100044250488
SELECT * FROM pages WHERE id = '90'
206 0.0002 0.00017189979553223
SELECT * FROM pages WHERE id = '414'
207 0.0002 0.00016403198242188
SELECT * FROM pages WHERE id = '119'
208 0.0002 0.00016522407531738
SELECT * FROM pages WHERE id = '406'
209 0.0002 0.00016307830810547
SELECT * FROM pages WHERE id = '149'
210 0.0002 0.00016283988952637
SELECT * FROM pages WHERE id = '150'
211 0.0002 0.0001680850982666
SELECT * FROM pages WHERE id = '412'
212 0.0002 0.00017118453979492
SELECT * FROM pages WHERE id = '162'
213 0.0002 0.00015807151794434
SELECT * FROM pages WHERE id = '164'
214 0.0002 0.00015687942504883
SELECT * FROM pages WHERE id = '167'
215 0.0002 0.0001528263092041
SELECT * FROM pages WHERE id = '180'
216 0.0002 0.00015401840209961
SELECT * FROM pages WHERE id = '187'
217 0.0002 0.0002131462097168
SELECT * FROM pages WHERE id = '265'
218 0.0002 0.00016903877258301
SELECT * FROM pages WHERE id = '268'
219 0.0002 0.00015687942504883
SELECT * FROM pages WHERE id = '411'
220 0.0002 0.00016689300537109
SELECT * FROM pages WHERE id = '290'
221 0.0002 0.00015497207641602
SELECT * FROM pages WHERE id = '413'
222 0.0002 0.00015807151794434
SELECT * FROM pages WHERE id = '409'
223 0.0002 0.00016212463378906
SELECT * FROM pages WHERE id = '327'
224 0.0002 0.00015997886657715
SELECT * FROM pages WHERE id = '336'
225 0.0002 0.00017094612121582
SELECT * FROM pages WHERE id = '351'
226 0.0002 0.00015902519226074
SELECT * FROM pages WHERE id = '358'
227 0.0002 0.00017786026000977
SELECT * FROM pages WHERE id = '360'
228 0.0002 0.00016498565673828
SELECT * FROM pages WHERE id = '362'
229 0.0002 0.0001680850982666
SELECT * FROM pages WHERE id = '366'
230 0.0002 0.00017404556274414
SELECT * FROM pages WHERE id = '370'
231 0.0002 0.00016307830810547
SELECT * FROM pages WHERE id = '377'
232 0.0002 0.00017499923706055
SELECT * FROM pages WHERE id = '386'
233 0.0002 0.00015902519226074
SELECT * FROM pages WHERE id = '408'
234 0.0002 0.00015592575073242
SELECT * FROM pages WHERE id = '415'
235 0.0002 0.00017595291137695
SELECT * FROM pages WHERE id = '416'
236 0.0002 0.0002140998840332
SELECT * FROM pages WHERE id = '419'
237 0.0002 0.00018000602722168
SELECT * FROM pages WHERE id = '423'
238 0.0002 0.00016498565673828
SELECT * FROM pages WHERE id = '427'
239 0.0002 0.00019001960754395
SELECT * FROM pages WHERE id = '428'
240 0.0002 0.0001530647277832
SELECT * FROM pages WHERE id = '432'
241 0.0002 0.00015616416931152
SELECT * FROM pages WHERE id = '433'
242 0.0002 0.00017595291137695
SELECT * FROM pages WHERE id = '436'
243 0.0002 0.00016403198242188
SELECT * FROM pages WHERE id = '437'
244 0.0002 0.00015997886657715
SELECT * FROM pages WHERE id = '461'
245 0.0002 0.00018906593322754
SELECT * FROM pages WHERE id = '464'
246 0.0002 0.00016403198242188
SELECT * FROM sideboxes_pages WHERE sidebox_id = '34'
247 0.0002 0.00017619132995605
SELECT * FROM pages WHERE id = '74'
248 0.0002 0.00016093254089355
SELECT * FROM pages WHERE id = '137'
249 0.0002 0.00016498565673828
SELECT * FROM pages WHERE id = '145'
250 0.0002 0.00016188621520996
SELECT * FROM pages WHERE id = '156'
251 0.0002 0.00016307830810547
SELECT * FROM pages WHERE id = '407'
252 0.0002 0.00015616416931152
SELECT * FROM pages WHERE id = '410'
253 0.0002 0.00019192695617676
SELECT * FROM pages WHERE id = '266'
254 0.0002 0.00024199485778809
SELECT * FROM pages WHERE id = '316'
255 0.0002 0.00016903877258301
SELECT * FROM pages WHERE id = '332'
256 0.0002 0.00019693374633789
SELECT * FROM pages WHERE id = '334'
257 0.0002 0.00016999244689941
SELECT * FROM pages WHERE id = '367'
258 0.0002 0.00016498565673828
SELECT * FROM pages WHERE id = '387'
259 0.0002 0.00016379356384277
SELECT * FROM pages WHERE id = '389'
260 0.0002 0.00016999244689941
SELECT * FROM pages WHERE id = '397'
261 0.0002 0.00017213821411133
SELECT * FROM pages WHERE id = '449'
262 0.0002 0.00019097328186035
SELECT * FROM sideboxes_pages WHERE sidebox_id = '35'
263 0.0002 0.00021195411682129
SELECT * FROM pages WHERE id = '42'
264 0.0002 0.00016498565673828
SELECT * FROM pages WHERE id = '79'
265 0.0002 0.00017189979553223
SELECT * FROM pages WHERE id = '86'
266 0.0002 0.00015711784362793
SELECT * FROM pages WHERE id = '95'
267 0.0002 0.00017595291137695
SELECT * FROM pages WHERE id = '102'
268 0.0002 0.00015902519226074
SELECT * FROM pages WHERE id = '109'
269 0.0002 0.0002448558807373
SELECT * FROM pages WHERE id = '114'
270 0.0002 0.00021100044250488
SELECT * FROM pages WHERE id = '121'
271 0.0002 0.00024199485778809
SELECT * FROM pages WHERE id = '138'
272 0.0002 0.00017094612121582
SELECT * FROM pages WHERE id = '142'
273 0.0002 0.0002140998840332
SELECT * FROM pages WHERE id = '62'
274 0.0002 0.00016188621520996
SELECT * FROM pages WHERE id = '157'
275 0.0002 0.00016903877258301
SELECT * FROM pages WHERE id = '246'
276 0.0002 0.00022196769714355
SELECT * FROM pages WHERE id = '276'
277 0.0002 0.00022602081298828
SELECT * FROM pages WHERE id = '278'
278 0.0003 0.00025200843811035
SELECT * FROM pages WHERE id = '279'
279 0.0002 0.00017404556274414
SELECT * FROM pages WHERE id = '317'
280 0.0002 0.00017404556274414
SELECT * FROM pages WHERE id = '405'
281 0.0002 0.00018787384033203
SELECT * FROM pages WHERE id = '343'
282 0.0002 0.00016498565673828
SELECT * FROM pages WHERE id = '345'
283 0.0002 0.00021791458129883
SELECT * FROM pages WHERE id = '346'
284 0.0002 0.00017189979553223
SELECT * FROM pages WHERE id = '347'
285 0.0002 0.0001828670501709
SELECT * FROM pages WHERE id = '348'
286 0.0002 0.00016593933105469
SELECT * FROM pages WHERE id = '349'
287 0.0002 0.00016188621520996
SELECT * FROM pages WHERE id = '381'
288 0.0002 0.00016403198242188
SELECT * FROM pages WHERE id = '392'
289 0.0002 0.00015997886657715
SELECT * FROM pages WHERE id = '393'
290 0.0002 0.00016903877258301
SELECT * FROM pages WHERE id = '394'
291 0.0002 0.00015902519226074
SELECT * FROM pages WHERE id = '395'
292 0.0002 0.00016903877258301
SELECT * FROM pages WHERE id = '399'
293 0.0002 0.0001680850982666
SELECT * FROM pages WHERE id = '421'
294 0.0002 0.0001528263092041
SELECT * FROM pages WHERE id = '426'
295 0.0002 0.00016283988952637
SELECT * FROM pages WHERE id = '430'
296 0.0002 0.00016117095947266
SELECT * FROM pages WHERE id = '431'
297 0.0002 0.0001671314239502
SELECT * FROM pages WHERE id = '434'
298 0.0002 0.00016999244689941
SELECT * FROM pages WHERE id = '435'
299 0.0002 0.00017690658569336
SELECT * FROM pages WHERE id = '440'
300 0.0002 0.00017714500427246
SELECT * FROM pages WHERE id = '441'
301 0.0002 0.00016283988952637
SELECT * FROM pages WHERE id = '451'
302 0.0002 0.00015711784362793
SELECT * FROM pages WHERE id = '453'
303 0.0002 0.00015687942504883
SELECT * FROM sideboxes_pages WHERE sidebox_id = '37'
304 0.0002 0.00018000602722168
SELECT * FROM pages WHERE id = '146'
305 0.0002 0.00015997886657715
SELECT * FROM pages WHERE id = '158'
306 0.0002 0.00015807151794434
SELECT * FROM pages WHERE id = '163'
307 0.0003 0.00026416778564453
SELECT * FROM pages WHERE id = '293'
308 0.0002 0.00016593933105469
SELECT * FROM pages WHERE id = '340'
309 0.0002 0.0001680850982666
SELECT * FROM pages WHERE id = '417'
310 0.0002 0.00017595291137695
SELECT * FROM sideboxes_pages WHERE sidebox_id = '40'
311 0.0002 0.00017905235290527
SELECT * FROM pages WHERE id = '173'
312 0.0002 0.00017094612121582
SELECT * FROM pages WHERE id = '181'
313 0.0002 0.00015902519226074
SELECT * FROM pages WHERE id = '288'
314 0.0002 0.00016903877258301
SELECT * FROM pages WHERE id = '299'
315 0.0002 0.00017690658569336
SELECT * FROM pages WHERE id = '300'
316 0.0002 0.0001671314239502
SELECT * FROM pages WHERE id = '383'
317 0.0002 0.00015497207641602
SELECT * FROM pages WHERE id = '385'
318 0.0002 0.00015997886657715
SELECT * FROM pages WHERE id = '438'
319 0.0002 0.0001680850982666
SELECT * FROM pages WHERE id = '442'
320 0.0002 0.00015497207641602
SELECT * FROM sideboxes_pages WHERE sidebox_id = '38'
321 0.0003 0.00026702880859375
SELECT * FROM pages WHERE id = '103'
322 0.0002 0.0002448558807373
SELECT * FROM pages WHERE id = '134'
323 0.0002 0.00016283988952637
SELECT * FROM pages WHERE id = '139'
324 0.0002 0.00016999244689941
SELECT * FROM pages WHERE id = '143'
325 0.0002 0.00017905235290527
SELECT * FROM pages WHERE id = '234'
326 0.0002 0.00017094612121582
SELECT * FROM pages WHERE id = '248'
327 0.0002 0.00015902519226074
SELECT * FROM pages WHERE id = '260'
328 0.0002 0.00016593933105469
SELECT * FROM pages WHERE id = '398'
329 0.0002 0.00016999244689941
SELECT * FROM sideboxes_pages WHERE sidebox_id = '29'
330 0.0002 0.00018692016601562
SELECT * FROM pages WHERE id = '61'
331 0.0002 0.00017189979553223
SELECT * FROM pages WHERE id = '87'
332 0.0002 0.00017499923706055
SELECT * FROM pages WHERE id = '104'
333 0.0002 0.00022196769714355
SELECT * FROM pages WHERE id = '115'
334 0.0002 0.00015902519226074
SELECT * FROM pages WHERE id = '124'
335 0.0002 0.00017905235290527
SELECT * FROM pages WHERE id = '144'
336 0.0002 0.00018906593322754
SELECT * FROM pages WHERE id = '151'
337 0.0002 0.00015401840209961
SELECT * FROM pages WHERE id = '199'
338 0.0002 0.00016212463378906
SELECT * FROM pages WHERE id = '200'
339 0.0002 0.0001678466796875
SELECT * FROM pages WHERE id = '304'
340 0.0002 0.00017094612121582
SELECT * FROM pages WHERE id = '321'
341 0.0002 0.00015711784362793
SELECT * FROM pages WHERE id = '333'
342 0.0002 0.0001828670501709
SELECT * FROM pages WHERE id = '350'
343 0.0002 0.00015807151794434
SELECT * FROM pages WHERE id = '378'
344 0.0002 0.00015902519226074
SELECT * FROM pages WHERE id = '422'
345 0.0002 0.00020003318786621
SELECT * FROM pages WHERE id = '425'
346 0.0002 0.00015783309936523
SELECT * FROM pages WHERE id = '443'
347 0.0002 0.00015807151794434
SELECT * FROM pages WHERE id = '444'
348 0.0002 0.00015711784362793
SELECT * FROM pages WHERE id = '445'
349 0.0002 0.00015997886657715
SELECT * FROM pages WHERE id = '446'
350 0.0002 0.0001671314239502
SELECT * FROM pages WHERE id = '447'
351 0.0002 0.00015878677368164
SELECT * FROM pages WHERE id = '448'
352 0.0002 0.00016212463378906
SELECT * FROM pages WHERE id = '455'
353 0.0002 0.00016617774963379
SELECT * FROM pages WHERE id = '456'
354 0.0002 0.00015401840209961
SELECT * FROM pages WHERE id = '459'
355 0.0002 0.00016880035400391
SELECT * FROM pages WHERE id = '460'
356 0.0002 0.00016403198242188
SELECT * FROM pages WHERE id = '462'
357 0.0002 0.00016021728515625
SELECT * FROM sideboxes_pages WHERE sidebox_id = '32'
358 0.0002 0.00017499923706055
SELECT * FROM pages WHERE id = '153'
359 0.0002 0.00022602081298828
SELECT * FROM pages WHERE id = '182'
360 0.0002 0.00016999244689941
SELECT * FROM pages WHERE id = '238'
361 0.0002 0.00015997886657715
SELECT * FROM pages WHERE id = '240'
362 0.0002 0.0001530647277832
SELECT * FROM pages WHERE id = '242'
363 0.0002 0.0001518726348877
SELECT * FROM pages WHERE id = '252'
364 0.0002 0.00015115737915039
SELECT * FROM pages WHERE id = '253'
365 0.0002 0.0001530647277832
SELECT * FROM pages WHERE id = '262'
366 0.0002 0.00016307830810547
SELECT * FROM pages WHERE id = '267'
367 0.0002 0.00016093254089355
SELECT * FROM pages WHERE id = '420'
368 0.0002 0.0001530647277832
SELECT value FROM parameters WHERE parameter = 'GOOGLE_SITE_KEY' 
369 0.0001 0.00013303756713867
SELECT value FROM parameters WHERE parameter = 'GOOGLE_SECRET_KEY' 
370 0.0001 0.00013303756713867
SELECT value FROM parameters WHERE parameter = 'GOOGLE_RECAPTCHA_TYPE' 
371 0.0014 0.0014090538024902
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
372 0.0002 0.00017690658569336
SELECT value FROM parameters WHERE parameter = 'GOOGLE_SITE_KEY' 
373 0.0001 0.00013399124145508
SELECT value FROM parameters WHERE parameter = 'GOOGLE_SECRET_KEY' 
374 0.0001 0.00014305114746094
SELECT value FROM parameters WHERE parameter = 'GOOGLE_RECAPTCHA_TYPE' 
375 0.0003 0.00029993057250977
SELECT * FROM products WHERE pagename = 'american-defense-ad-recon-std-riflescope-optic-mount-black-30-mm'
376 0.0002 0.00020694732666016
SELECT * FROM manufacturers WHERE id = '6260'
377 0.0004 0.00039577484130859
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '6260'
378 0.0001 0.00012707710266113
SELECT filename FROM manufacturerimages WHERE manufacturer_id = '6260' LIMIT 1
379 0.0003 0.00034713745117188
SELECT pagename, id FROM products p WHERE manufacturer_id = '6260' ORDER BY RAND() LIMIT 1
380 0.0002 0.00024294853210449
SELECT * FROM productimages WHERE product_id = '399012' ORDER BY sortorder ASC
381 0.0003 0.00033688545227051
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '6260'
382 0.0004 0.0003809928894043
SELECT COUNT(DISTINCT(p.id)) FROM products p
				WHERE p.manufacturer_id = '6260'
				  AND p.hidden = 0
				  AND p.enabled = 1
				  AND p.parent_id = 0 
383 0.0001 0.00012779235839844
SELECT * FROM manufacturerimages WHERE manufacturer_id = '6260'
384 0.0001 0.00014591217041016
SELECT category_id FROM products_categories WHERE product_id = '186168'
385 0.0003 0.00025415420532227
SELECT * FROM categories WHERE id = '34'
386 0.0096 0.0095729827880859
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.0001518726348877
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.00023198127746582
SELECT id FROM categories WHERE parent_id = '94'
390 0.0002 0.00021815299987793
SELECT id FROM categories WHERE parent_id = '98'
391 0.0002 0.00021100044250488
SELECT id FROM categories WHERE parent_id = '99'
392 0.0002 0.00021195411682129
SELECT id FROM categories WHERE parent_id = '110'
393 0.0002 0.00021004676818848
SELECT id FROM categories WHERE parent_id = '130'
394 0.0101 0.010107040405273
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.00018715858459473
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.00017595291137695
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.0001981258392334
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '34'
398 0.0003 0.00033211708068848
SELECT * FROM productimages WHERE product_id = '186168' ORDER BY sortorder ASC
399 0.0002 0.00023794174194336
SELECT * FROM product_image_select WHERE product_id = '186168'
400 0.0001 0.00013899803161621
SELECT * FROM productcustomimages WHERE product_id = '186168'
401 0.0001 0.00012397766113281
SELECT * FROM productfeeds WHERE product_id = '186168' ORDER BY item_date DESC
402 0.0004 0.0003659725189209
SELECT a.name, n.displayname, a.value, n.units, n.valuetype FROM productattributes a, productattributenames n WHERE product_id = '186168' AND a.name = n.originalname AND n.display = 1 AND n.hidden = 0
403 0.0004 0.00035715103149414
SELECT DISTINCT(pt.tag_id) FROM product_tags pt, tags t WHERE pt.tag_id = t.id AND pt.product_id = '186168' AND t.hidden = 0 AND display_product = 1
404 0.0072 0.0072391033172607
SELECT * FROM productamazoncontent WHERE product_id = '186168'
405 0.0025 0.0025489330291748
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '186168' AND a.name = n.originalname
406 0.0002 0.00018501281738281
SELECT * FROM productoffers WHERE product_id = '186168' AND merchantid = 'ATVPDKIKX0DER'
407 0.0002 0.00019216537475586
SELECT * FROM productoffers
                WHERE product_id = '186168' AND price > 0
                ORDER BY price ASC LIMIT 1
408 0.0002 0.00016212463378906
SELECT * FROM productoffers
                WHERE product_id = 186168
                ORDER BY price ASC LIMIT 1
409 0.0002 0.00023102760314941
SELECT value FROM productattributes
                WHERE product_id = '186168'
                AND name = 'ListPriceAmount'
410 0.0001 0.00013995170593262
UPDATE products SET price = '18895' WHERE id = '186168'
411 0.2536 0.25356316566467
SELECT *, MATCH (description, keyfeatures, title) AGAINST ('american defense' IN BOOLEAN MODE) AS `searchrelevance` FROM products WHERE MATCH (description, keyfeatures, title) AGAINST ('american defense' IN BOOLEAN MODE) AND 186168 <> 0 AND enabled = 1 AND hidden = 0 AND offers > 0 AND parent_id = 0 ORDER BY `searchrelevance` LIMIT 6
412 0.0004 0.0003669261932373
SELECT * FROM productimages WHERE product_id = '266160' ORDER BY sortorder ASC
413 0.0002 0.00022697448730469
SELECT * FROM product_image_select WHERE product_id = '266160'
414 0.0001 0.00012516975402832
SELECT * FROM productcustomimages WHERE product_id = '266160'
415 0.0025 0.0024669170379639
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '266160' AND a.name = n.originalname
416 0.0002 0.00019311904907227
SELECT * FROM productoffers WHERE product_id = '266160' AND merchantid = 'ATVPDKIKX0DER'
417 0.0002 0.00021600723266602
SELECT * FROM productoffers
                WHERE product_id = '266160' AND price > 0
                ORDER BY price ASC LIMIT 1
418 0.0004 0.00039505958557129
SELECT value FROM productattributes WHERE product_id = '266160' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
419 0.0001 0.00013589859008789
UPDATE products SET price = '1997' WHERE id = '266160'
420 0.0002 0.00020503997802734
SELECT * FROM productimages WHERE product_id = '16779' ORDER BY sortorder ASC
421 0.0002 0.0002138614654541
SELECT * FROM product_image_select WHERE product_id = '16779'
422 0.0001 0.00012993812561035
SELECT * FROM productcustomimages WHERE product_id = '16779'
423 0.0018 0.0017561912536621
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '16779' AND a.name = n.originalname
424 0.0002 0.00020098686218262
SELECT * FROM productoffers WHERE product_id = '16779' AND merchantid = 'ATVPDKIKX0DER'
425 0.0002 0.00020599365234375
SELECT * FROM productoffers
                WHERE product_id = '16779' AND price > 0
                ORDER BY price ASC LIMIT 1
426 0.0003 0.00032305717468262
SELECT value FROM productattributes WHERE product_id = '16779' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
427 0.0001 0.00012397766113281
UPDATE products SET price = '1595' WHERE id = '16779'
428 0.0002 0.00019216537475586
SELECT * FROM productimages WHERE product_id = '132168' ORDER BY sortorder ASC
429 0.0002 0.00020790100097656
SELECT * FROM product_image_select WHERE product_id = '132168'
430 0.0001 0.00012087821960449
SELECT * FROM productcustomimages WHERE product_id = '132168'
431 0.0028 0.002755880355835
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '132168' AND a.name = n.originalname
432 0.0002 0.00018715858459473
SELECT * FROM productoffers WHERE product_id = '132168' AND merchantid = 'ATVPDKIKX0DER'
433 0.0002 0.00020217895507812
SELECT * FROM productoffers
                WHERE product_id = '132168' AND price > 0
                ORDER BY price ASC LIMIT 1
434 0.0004 0.00040411949157715
SELECT value FROM productattributes WHERE product_id = '132168' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
435 0.0001 0.00012493133544922
UPDATE products SET price = '1760' WHERE id = '132168'
436 0.0002 0.00018191337585449
SELECT * FROM productimages WHERE product_id = '34366' ORDER BY sortorder ASC
437 0.0002 0.00023984909057617
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '34366' AND p.id = pi.product_id ORDER BY pi.sortorder
438 0.0002 0.00021100044250488
SELECT * FROM product_image_select WHERE product_id = '34366'
439 0.0001 0.00013184547424316
SELECT * FROM productcustomimages WHERE product_id = '34366'
440 0.0002 0.00023984909057617
SELECT  o.product_id, MIN(o.price) as price, p.customprice
                FROM    products        p,
                        productoffers   o
                WHERE   p.id        = o.product_id
                  AND   p.parent_id = '34366'
                GROUP BY o.product_id
441 0.0003 0.00028085708618164
SELECT  n.displayname, o.name
                FROM    productoptionnames  n,
                        productoptions      o,
                        products            p
                WHERE   n.originalname  = o.name
                  AND   o.product_id    = p.id
                  AND   p.parent_id     = '34366'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
442 0.0002 0.00020194053649902
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 34366
443 0.0017 0.0017459392547607
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '34366' AND a.name = n.originalname
444 0.0002 0.00017499923706055
SELECT * FROM productoffers WHERE product_id = '34366' AND merchantid = 'ATVPDKIKX0DER'
445 0.0002 0.00017714500427246
SELECT * FROM productoffers
                WHERE product_id = '34366' AND price > 0
                ORDER BY price ASC LIMIT 1
446 0.0002 0.00017189979553223
SELECT * FROM productoffers
                WHERE product_id = 34366
                ORDER BY price ASC LIMIT 1
447 0.0002 0.00023102760314941
SELECT value FROM productattributes
                WHERE product_id = '34366'
                AND name = 'ListPriceAmount'
448 0.0002 0.00022721290588379
SELECT  o.product_id, MIN(o.price) as price, p.customprice
                FROM    products        p,
                        productoffers   o
                WHERE   p.id        = o.product_id
                  AND   p.parent_id = '34366'
                GROUP BY o.product_id
449 0.0003 0.00026583671569824
SELECT  n.displayname, o.name
                FROM    productoptionnames  n,
                        productoptions      o,
                        products            p
                WHERE   n.originalname  = o.name
                  AND   o.product_id    = p.id
                  AND   p.parent_id     = '34366'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
450 0.0002 0.00020503997802734
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 34366
451 0.0003 0.00033307075500488
SELECT value FROM productattributes WHERE product_id = '34366' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
452 0.0001 0.00011897087097168
UPDATE products SET price = '39895' WHERE id = '34366'
453 0.0003 0.00030088424682617
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '34366'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Size'
                GROUP BY o.value
                ORDER BY o.value ASC
454 0.0002 0.00022411346435547
SELECT * FROM products WHERE parent_id = '34366'
455 0.0002 0.00021886825561523
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '389156' AND a.name = n.originalname
456 0.0002 0.00017309188842773
SELECT * FROM productoffers WHERE product_id = '389156' AND merchantid = 'ATVPDKIKX0DER'
457 0.0002 0.00020313262939453
SELECT * FROM productoffers
                WHERE product_id = '389156' AND price > 0
                ORDER BY price ASC LIMIT 1
458 0.0002 0.00023603439331055
SELECT * FROM productimages WHERE product_id = '124231' ORDER BY sortorder ASC
459 0.0002 0.00020694732666016
SELECT * FROM product_image_select WHERE product_id = '124231'
460 0.0001 0.00012302398681641
SELECT * FROM productcustomimages WHERE product_id = '124231'
461 0.0027 0.0026719570159912
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '124231' AND a.name = n.originalname
462 0.0002 0.00018692016601562
SELECT * FROM productoffers WHERE product_id = '124231' AND merchantid = 'ATVPDKIKX0DER'
463 0.0002 0.00020098686218262
SELECT * FROM productoffers
                WHERE product_id = '124231' AND price > 0
                ORDER BY price ASC LIMIT 1
464 0.0004 0.00035977363586426
SELECT value FROM productattributes WHERE product_id = '124231' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
465 0.0001 0.00011992454528809
UPDATE products SET price = '5499' WHERE id = '124231'
466 0.0002 0.00018811225891113
SELECT * FROM productimages WHERE product_id = '43519' ORDER BY sortorder ASC
467 0.0002 0.00021600723266602
SELECT * FROM product_image_select WHERE product_id = '43519'
468 0.0001 0.0001220703125
SELECT * FROM productcustomimages WHERE product_id = '43519'
469 0.0027 0.0026650428771973
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '43519' AND a.name = n.originalname
470 0.0002 0.00018310546875
SELECT * FROM productoffers WHERE product_id = '43519' AND merchantid = 'ATVPDKIKX0DER'
471 0.0002 0.00019502639770508
SELECT * FROM productoffers
                WHERE product_id = '43519' AND price > 0
                ORDER BY price ASC LIMIT 1
472 0.0003 0.00032997131347656
SELECT value FROM productattributes WHERE product_id = '43519' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
473 0.0001 0.00012397766113281
UPDATE products SET price = '1330' WHERE id = '43519'
474 0.0001 0.0001378059387207
SELECT value FROM parameters WHERE parameter = 'EBAY_CACHE_TIME' 
475 0.0001 0.00011992454528809
SELECT value FROM parameters WHERE parameter = 'EBAY_APP_ID' 
476 0.0001 0.00011992454528809
SELECT value FROM parameters WHERE parameter = 'EBAY_TRACKING_ID' 
477 0.0001 0.00011992454528809
SELECT value FROM parameters WHERE parameter = 'EBAY_NETWORK_ID' 
478 0.0001 0.00011801719665527
SELECT value FROM parameters WHERE parameter = 'EBAY_LOCALE' 
479 0.0001 0.00011682510375977
SELECT value FROM parameters WHERE parameter = 'EBAY_AUTH_TOKEN' 
480 0.0001 0.00013494491577148
SELECT * FROM ebay_locale_details WHERE cur_code = 'USD' 
481 0.1843 0.1843090057373
SELECT * FROM ebay_products_cache WHERE cachekey = '49ce7842cb11c9cfc5a24ff7132de950' 
482 0.0003 0.00028300285339355
SELECT value FROM parameters WHERE parameter = 'EBAY_APP_ID' 
483 0.0001 0.00012516975402832
SELECT value FROM parameters WHERE parameter = 'EBAY_TRACKING_ID' 
484 0.0001 0.0001218318939209
SELECT value FROM parameters WHERE parameter = 'EBAY_NETWORK_ID' 
485 0.0001 0.00011992454528809
SELECT value FROM parameters WHERE parameter = 'EBAY_LOCALE' 
486 0.0001 0.00011801719665527
SELECT value FROM parameters WHERE parameter = 'EBAY_AUTH_TOKEN' 
487 0.1917 0.19171595573425
SELECT * FROM ebay_products_cache WHERE cachekey = '49ce7842cb11c9cfc5a24ff7132de950' 
488 0.0003 0.00025701522827148
SELECT id,asin FROM products WHERE parent_id = 186168
489 0.0004 0.00037693977355957
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '186168' ORDER BY timestamp DESC
490 0.0002 0.00015997886657715
SELECT category_id FROM products_categories WHERE product_id = '186168'
491 0.0003 0.0002901554107666
SELECT * FROM categories WHERE id = '34'
492 0.0111 0.011064052581787
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
493 0.0001 0.00013518333435059
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 34
494 0.0003 0.00027012825012207
SELECT id FROM categories WHERE parent_id = '34'
495 0.0002 0.00020384788513184
SELECT id FROM categories WHERE parent_id = '94'
496 0.0002 0.00020909309387207
SELECT id FROM categories WHERE parent_id = '98'
497 0.0002 0.00020003318786621
SELECT id FROM categories WHERE parent_id = '99'
498 0.0002 0.0001981258392334
SELECT id FROM categories WHERE parent_id = '110'
499 0.0002 0.00022697448730469
SELECT id FROM categories WHERE parent_id = '130'
500 0.0114 0.011400938034058
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 
501 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 
502 0.0002 0.00016498565673828
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (94,98,99,110,130,34)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
503 0.0002 0.00018882751464844
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '34'
504 0.0029 0.0028829574584961
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '186168' AND a.name = n.originalname
505 0.0002 0.00018906593322754
SELECT * FROM productoffers WHERE product_id = '186168' AND merchantid = 'ATVPDKIKX0DER'
506 0.0002 0.00021600723266602
SELECT * FROM productoffers
                WHERE product_id = '186168' AND price > 0
                ORDER BY price ASC LIMIT 1
507 0.0002 0.00016403198242188
SELECT * FROM productoffers
                WHERE product_id = 186168
                ORDER BY price ASC LIMIT 1
508 0.0002 0.00022292137145996
SELECT value FROM productattributes
                WHERE product_id = '186168'
                AND name = 'ListPriceAmount'
509 0.0002 0.00021100044250488
SELECT * FROM products WHERE id = '186168'
510 0.0001 0.00014901161193848
UPDATE products SET price = '18895' WHERE id = '186168'
511 0.0031 0.0030529499053955
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '186168' AND a.name = n.originalname
512 0.0002 0.00018191337585449
SELECT * FROM productoffers WHERE product_id = '186168' AND merchantid = 'ATVPDKIKX0DER'
513 0.0002 0.00017905235290527
SELECT * FROM productoffers
                WHERE product_id = '186168' AND price > 0
                ORDER BY price ASC LIMIT 1
514 0.0002 0.00016903877258301
SELECT * FROM productoffers
                WHERE product_id = 186168
                ORDER BY price ASC LIMIT 1
515 0.0002 0.00022602081298828
SELECT value FROM productattributes
                WHERE product_id = '186168'
                AND name = 'ListPriceAmount'
516 0.0001 0.00014591217041016
SELECT category_id FROM products_categories WHERE product_id = '186168'
517 0.0001 0.00012803077697754
SELECT parent_id FROM categories WHERE id = '34'
518 0.0002 0.00023198127746582
SELECT * FROM categories WHERE id = '34'
519 0.0104 0.010401010513306
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
520 0.0002 0.00015091896057129
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 34
521 0.0003 0.00026893615722656
SELECT id FROM categories WHERE parent_id = '34'
522 0.0002 0.00020289421081543
SELECT id FROM categories WHERE parent_id = '94'
523 0.0002 0.00020003318786621
SELECT id FROM categories WHERE parent_id = '98'
524 0.0002 0.00020909309387207
SELECT id FROM categories WHERE parent_id = '99'
525 0.0002 0.00020098686218262
SELECT id FROM categories WHERE parent_id = '110'
526 0.0002 0.0001981258392334
SELECT id FROM categories WHERE parent_id = '130'
527 0.0103 0.010308980941772
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 
528 0.0002 0.0001838207244873
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 
529 0.0002 0.00016617774963379
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 
530 0.0002 0.00018310546875
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '34'
531 0.0002 0.00017285346984863
SELECT * FROM template_info WHERE templateuid = 'fsb-fluid'
532 0.0002 0.00017499923706055
SELECT * FROM pages WHERE id = 2
533 0.0001 0.00014185905456543
SELECT * FROM pages WHERE id = 4
534 0.0001 0.00013589859008789
SELECT * FROM pages WHERE id = 12
535 0.0001 0.00013899803161621
SELECT * FROM pages WHERE id = 10
536 0.0001 0.0001380443572998
SELECT * FROM pages WHERE id = 7
537 0.0001 0.00014710426330566
SELECT * FROM pages WHERE id = 18
538 0.0002 0.00015115737915039
SELECT * FROM pages WHERE id = 28
539 0.0001 0.00014996528625488
SELECT * FROM pages WHERE id = 13
540 0.0001 0.00013589859008789
SELECT * FROM pages WHERE id = 3
541 0.0440 0.044049978256226
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
542 0.0003 0.00029492378234863
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:1560834344;s:8:\"products\";a:6:{i:2;s:6:\"407595\";i:6;s:6:\"412927\";i:7;s:6:\"409759\";i:13;s:6:\"414188\";i:5;s:6:\"404554\";i:10;s:6:\"370121\";}}' WHERE id = '175'
543 0.0005 0.00046706199645996
SELECT * FROM products WHERE id IN (407595,412927,409759,414188,404554,370121) ORDER BY FIELD(id, 407595,412927,409759,414188,404554,370121 )
544 0.0003 0.00025200843811035
SELECT * FROM productimages WHERE product_id = '407595' ORDER BY sortorder ASC
545 0.0002 0.00021505355834961
SELECT * FROM product_image_select WHERE product_id = '407595'
546 0.0001 0.00014281272888184
SELECT * FROM productcustomimages WHERE product_id = '407595'
547 0.0034 0.003425121307373
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '407595' AND a.name = n.originalname
548 0.0002 0.00018596649169922
SELECT * FROM productoffers WHERE product_id = '407595' AND merchantid = 'ATVPDKIKX0DER'
549 0.0002 0.00021791458129883
SELECT * FROM productoffers
                WHERE product_id = '407595' AND price > 0
                ORDER BY price ASC LIMIT 1
550 0.0004 0.00043106079101562
SELECT value FROM productattributes WHERE product_id = '407595' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
551 0.0001 0.0001220703125
UPDATE products SET price = '2497' WHERE id = '407595'
552 0.0003 0.0002598762512207
SELECT * FROM productimages WHERE product_id = '412927' ORDER BY sortorder ASC
553 0.0002 0.00021219253540039
SELECT * FROM product_image_select WHERE product_id = '412927'
554 0.0001 0.00012111663818359
SELECT * FROM productcustomimages WHERE product_id = '412927'
555 0.0037 0.0036849975585938
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '412927' AND a.name = n.originalname
556 0.0002 0.00018501281738281
SELECT * FROM productoffers WHERE product_id = '412927' AND merchantid = 'ATVPDKIKX0DER'
557 0.0002 0.00020694732666016
SELECT * FROM productoffers
                WHERE product_id = '412927' AND price > 0
                ORDER BY price ASC LIMIT 1
558 0.0005 0.00045895576477051
SELECT value FROM productattributes WHERE product_id = '412927' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
559 0.0001 0.00012302398681641
UPDATE products SET price = '199900' WHERE id = '412927'
560 0.0002 0.00021004676818848
SELECT * FROM productimages WHERE product_id = '409759' ORDER BY sortorder ASC
561 0.0002 0.00021505355834961
SELECT * FROM product_image_select WHERE product_id = '409759'
562 0.0001 0.0001218318939209
SELECT * FROM productcustomimages WHERE product_id = '409759'
563 0.0028 0.0028300285339355
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '409759' AND a.name = n.originalname
564 0.0002 0.00018501281738281
SELECT * FROM productoffers WHERE product_id = '409759' AND merchantid = 'ATVPDKIKX0DER'
565 0.0002 0.0002140998840332
SELECT * FROM productoffers
                WHERE product_id = '409759' AND price > 0
                ORDER BY price ASC LIMIT 1
566 0.0004 0.00039410591125488
SELECT value FROM productattributes WHERE product_id = '409759' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
567 0.0001 0.00012087821960449
UPDATE products SET price = '229000' WHERE id = '409759'
568 0.0003 0.00026988983154297
SELECT * FROM productimages WHERE product_id = '414188' ORDER BY sortorder ASC
569 0.0002 0.00020384788513184
SELECT * FROM product_image_select WHERE product_id = '414188'
570 0.0001 0.00012397766113281
SELECT * FROM productcustomimages WHERE product_id = '414188'
571 0.0026 0.0025629997253418
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '414188' AND a.name = n.originalname
572 0.0002 0.00018501281738281
SELECT * FROM productoffers WHERE product_id = '414188' AND merchantid = 'ATVPDKIKX0DER'
573 0.0002 0.00019598007202148
SELECT * FROM productoffers
                WHERE product_id = '414188' AND price > 0
                ORDER BY price ASC LIMIT 1
574 0.0004 0.00038003921508789
SELECT value FROM productattributes WHERE product_id = '414188' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
575 0.0001 0.00011897087097168
UPDATE products SET price = '9999' WHERE id = '414188'
576 0.0003 0.0002748966217041
SELECT * FROM productimages WHERE product_id = '404554' ORDER BY sortorder ASC
577 0.0002 0.00021004676818848
SELECT * FROM product_image_select WHERE product_id = '404554'
578 0.0001 0.00011992454528809
SELECT * FROM productcustomimages WHERE product_id = '404554'
579 0.0034 0.0033860206604004
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '404554' AND a.name = n.originalname
580 0.0002 0.00018501281738281
SELECT * FROM productoffers WHERE product_id = '404554' AND merchantid = 'ATVPDKIKX0DER'
581 0.0002 0.00019693374633789
SELECT * FROM productoffers
                WHERE product_id = '404554' AND price > 0
                ORDER BY price ASC LIMIT 1
582 0.0004 0.00044012069702148
SELECT value FROM productattributes WHERE product_id = '404554' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
583 0.0001 0.00011897087097168
UPDATE products SET price = '399999' WHERE id = '404554'
584 0.0002 0.00018906593322754
SELECT * FROM productimages WHERE product_id = '370121' ORDER BY sortorder ASC
585 0.0002 0.00021219253540039
SELECT * FROM product_image_select WHERE product_id = '370121'
586 0.0001 0.00012016296386719
SELECT * FROM productcustomimages WHERE product_id = '370121'
587 0.0028 0.0027701854705811
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '370121' AND a.name = n.originalname
588 0.0002 0.00018715858459473
SELECT * FROM productoffers WHERE product_id = '370121' AND merchantid = 'ATVPDKIKX0DER'
589 0.0002 0.00020718574523926
SELECT * FROM productoffers
                WHERE product_id = '370121' AND price > 0
                ORDER BY price ASC LIMIT 1
590 0.0004 0.00038814544677734
SELECT value FROM productattributes WHERE product_id = '370121' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
591 0.0001 0.00011706352233887
UPDATE products SET price = '9899' WHERE id = '370121'
592 0.0441 0.04410982131958
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
593 0.0003 0.00031614303588867
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:1560834344;s:8:\"products\";a:6:{i:1;s:6:\"398315\";i:2;s:6:\"407595\";i:8;s:6:\"408792\";i:11;s:6:\"403517\";i:12;s:6:\"414825\";i:13;s:6:\"414188\";}}' WHERE id = '177'
594 0.0005 0.0004580020904541
SELECT * FROM products WHERE id IN (398315,407595,408792,403517,414825,414188) ORDER BY FIELD(id, 398315,407595,408792,403517,414825,414188 )
595 0.0002 0.00022792816162109
SELECT * FROM productimages WHERE product_id = '398315' ORDER BY sortorder ASC
596 0.0002 0.00022697448730469
SELECT * FROM product_image_select WHERE product_id = '398315'
597 0.0001 0.00012803077697754
SELECT * FROM productcustomimages WHERE product_id = '398315'
598 0.0025 0.0025439262390137
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '398315' AND a.name = n.originalname
599 0.0002 0.0001981258392334
SELECT * FROM productoffers WHERE product_id = '398315' AND merchantid = 'ATVPDKIKX0DER'
600 0.0002 0.00020694732666016
SELECT * FROM productoffers
                WHERE product_id = '398315' AND price > 0
                ORDER BY price ASC LIMIT 1
601 0.0004 0.0003809928894043
SELECT value FROM productattributes WHERE product_id = '398315' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
602 0.0001 0.0001220703125
UPDATE products SET price = '1999' WHERE id = '398315'
603 0.0002 0.00024104118347168
SELECT * FROM productimages WHERE product_id = '407595' ORDER BY sortorder ASC
604 0.0002 0.00020885467529297
SELECT * FROM product_image_select WHERE product_id = '407595'
605 0.0001 0.00011992454528809
SELECT * FROM productcustomimages WHERE product_id = '407595'
606 0.0037 0.0036680698394775
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '407595' AND a.name = n.originalname
607 0.0002 0.00019001960754395
SELECT * FROM productoffers WHERE product_id = '407595' AND merchantid = 'ATVPDKIKX0DER'
608 0.0002 0.00019693374633789
SELECT * FROM productoffers
                WHERE product_id = '407595' AND price > 0
                ORDER BY price ASC LIMIT 1
609 0.0005 0.00048589706420898
SELECT value FROM productattributes WHERE product_id = '407595' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
610 0.0001 0.00012302398681641
UPDATE products SET price = '2497' WHERE id = '407595'
611 0.0002 0.00020503997802734
SELECT * FROM productimages WHERE product_id = '408792' ORDER BY sortorder ASC
612 0.0002 0.00021100044250488
SELECT * FROM product_image_select WHERE product_id = '408792'
613 0.0001 0.00012016296386719
SELECT * FROM productcustomimages WHERE product_id = '408792'
614 0.0041 0.0040731430053711
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '408792' AND a.name = n.originalname
615 0.0002 0.00018811225891113
SELECT * FROM productoffers WHERE product_id = '408792' AND merchantid = 'ATVPDKIKX0DER'
616 0.0002 0.00020194053649902
SELECT * FROM productoffers
                WHERE product_id = '408792' AND price > 0
                ORDER BY price ASC LIMIT 1
617 0.0004 0.00044822692871094
SELECT value FROM productattributes WHERE product_id = '408792' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
618 0.0001 0.00013184547424316
UPDATE products SET price = '13499' WHERE id = '408792'
619 0.0003 0.00026297569274902
SELECT * FROM productimages WHERE product_id = '403517' ORDER BY sortorder ASC
620 0.0002 0.00020909309387207
SELECT * FROM product_image_select WHERE product_id = '403517'
621 0.0001 0.0001220703125
SELECT * FROM productcustomimages WHERE product_id = '403517'
622 0.0035 0.0034611225128174
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '403517' AND a.name = n.originalname
623 0.0002 0.00018906593322754
SELECT * FROM productoffers WHERE product_id = '403517' AND merchantid = 'ATVPDKIKX0DER'
624 0.0002 0.00021195411682129
SELECT * FROM productoffers
                WHERE product_id = '403517' AND price > 0
                ORDER BY price ASC LIMIT 1
625 0.0004 0.00043606758117676
SELECT value FROM productattributes WHERE product_id = '403517' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
626 0.0001 0.00011992454528809
UPDATE products SET price = '6699' WHERE id = '403517'
627 0.0002 0.00020313262939453
SELECT * FROM productimages WHERE product_id = '414825' ORDER BY sortorder ASC
628 0.0002 0.00020599365234375
SELECT * FROM product_image_select WHERE product_id = '414825'
629 0.0001 0.00012397766113281
SELECT * FROM productcustomimages WHERE product_id = '414825'
630 0.0025 0.0025320053100586
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '414825' AND a.name = n.originalname
631 0.0002 0.00019502639770508
SELECT * FROM productoffers WHERE product_id = '414825' AND merchantid = 'ATVPDKIKX0DER'
632 0.0002 0.00021100044250488
SELECT * FROM productoffers
                WHERE product_id = '414825' AND price > 0
                ORDER BY price ASC LIMIT 1
633 0.0004 0.00038409233093262
SELECT value FROM productattributes WHERE product_id = '414825' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
634 0.0001 0.0001220703125
UPDATE products SET price = '11999' WHERE id = '414825'
635 0.0003 0.00028705596923828
SELECT * FROM productimages WHERE product_id = '414188' ORDER BY sortorder ASC
636 0.0002 0.00022387504577637
SELECT * FROM product_image_select WHERE product_id = '414188'
637 0.0001 0.00012588500976562
SELECT * FROM productcustomimages WHERE product_id = '414188'
638 0.0028 0.0028290748596191
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '414188' AND a.name = n.originalname
639 0.0002 0.00019097328186035
SELECT * FROM productoffers WHERE product_id = '414188' AND merchantid = 'ATVPDKIKX0DER'
640 0.0002 0.00020694732666016
SELECT * FROM productoffers
                WHERE product_id = '414188' AND price > 0
                ORDER BY price ASC LIMIT 1
641 0.0005 0.00046110153198242
SELECT value FROM productattributes WHERE product_id = '414188' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
642 0.0001 0.00011992454528809
UPDATE products SET price = '9999' WHERE id = '414188'
643 0.1078 0.10779404640198
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
644 0.0003 0.00029492378234863
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:1560834345;s:8:\"products\";a:6:{i:7;s:6:\"409759\";i:11;s:6:\"403517\";i:12;s:6:\"414825\";i:18;s:6:\"131163\";i:0;s:6:\"414940\";i:2;s:6:\"407595\";}}' WHERE id = '181'
645 0.0005 0.0004580020904541
SELECT * FROM products WHERE id IN (409759,403517,414825,131163,414940,407595) ORDER BY FIELD(id, 409759,403517,414825,131163,414940,407595 )
646 0.0004 0.00041913986206055
SELECT * FROM productimages WHERE product_id = '409759' ORDER BY sortorder ASC
647 0.0002 0.0002281665802002
SELECT * FROM product_image_select WHERE product_id = '409759'
648 0.0001 0.00012683868408203
SELECT * FROM productcustomimages WHERE product_id = '409759'
649 0.0028 0.0028448104858398
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '409759' AND a.name = n.originalname
650 0.0002 0.00019311904907227
SELECT * FROM productoffers WHERE product_id = '409759' AND merchantid = 'ATVPDKIKX0DER'
651 0.0002 0.00022482872009277
SELECT * FROM productoffers
                WHERE product_id = '409759' AND price > 0
                ORDER BY price ASC LIMIT 1
652 0.0004 0.00040388107299805
SELECT value FROM productattributes WHERE product_id = '409759' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
653 0.0001 0.00013494491577148
UPDATE products SET price = '229000' WHERE id = '409759'
654 0.0003 0.0002748966217041
SELECT * FROM productimages WHERE product_id = '403517' ORDER BY sortorder ASC
655 0.0002 0.00020694732666016
SELECT * FROM product_image_select WHERE product_id = '403517'
656 0.0001 0.00012397766113281
SELECT * FROM productcustomimages WHERE product_id = '403517'
657 0.0030 0.0029950141906738
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '403517' AND a.name = n.originalname
658 0.0002 0.00018596649169922
SELECT * FROM productoffers WHERE product_id = '403517' AND merchantid = 'ATVPDKIKX0DER'
659 0.0002 0.00020098686218262
SELECT * FROM productoffers
                WHERE product_id = '403517' AND price > 0
                ORDER BY price ASC LIMIT 1
660 0.0004 0.00041508674621582
SELECT value FROM productattributes WHERE product_id = '403517' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
661 0.0001 0.0001220703125
UPDATE products SET price = '6699' WHERE id = '403517'
662 0.0002 0.00020503997802734
SELECT * FROM productimages WHERE product_id = '414825' ORDER BY sortorder ASC
663 0.0002 0.00021600723266602
SELECT * FROM product_image_select WHERE product_id = '414825'
664 0.0001 0.00012397766113281
SELECT * FROM productcustomimages WHERE product_id = '414825'
665 0.0020 0.0020449161529541
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '414825' AND a.name = n.originalname
666 0.0002 0.00019311904907227
SELECT * FROM productoffers WHERE product_id = '414825' AND merchantid = 'ATVPDKIKX0DER'
667 0.0002 0.0002129077911377
SELECT * FROM productoffers
                WHERE product_id = '414825' AND price > 0
                ORDER BY price ASC LIMIT 1
668 0.0004 0.00037097930908203
SELECT value FROM productattributes WHERE product_id = '414825' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
669 0.0001 0.00012087821960449
UPDATE products SET price = '11999' WHERE id = '414825'
670 0.0002 0.00022602081298828
SELECT * FROM productimages WHERE product_id = '131163' ORDER BY sortorder ASC
671 0.0002 0.0002140998840332
SELECT * FROM product_image_select WHERE product_id = '131163'
672 0.0001 0.00012302398681641
SELECT * FROM productcustomimages WHERE product_id = '131163'
673 0.0026 0.0025680065155029
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '131163' AND a.name = n.originalname
674 0.0002 0.00018692016601562
SELECT * FROM productoffers WHERE product_id = '131163' AND merchantid = 'ATVPDKIKX0DER'
675 0.0002 0.00020384788513184
SELECT * FROM productoffers
                WHERE product_id = '131163' AND price > 0
                ORDER BY price ASC LIMIT 1
676 0.0004 0.00039005279541016
SELECT value FROM productattributes WHERE product_id = '131163' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
677 0.0001 0.00012087821960449
UPDATE products SET price = '20362' WHERE id = '131163'
678 0.0002 0.00017595291137695
SELECT * FROM productimages WHERE product_id = '414940' ORDER BY sortorder ASC
679 0.0002 0.00021100044250488
SELECT * FROM product_image_select WHERE product_id = '414940'
680 0.0001 0.00013113021850586
SELECT * FROM productcustomimages WHERE product_id = '414940'
681 0.0033 0.0032539367675781
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '414940' AND a.name = n.originalname
682 0.0002 0.00019502639770508
SELECT * FROM productoffers WHERE product_id = '414940' AND merchantid = 'ATVPDKIKX0DER'
683 0.0002 0.00020718574523926
SELECT * FROM productoffers
                WHERE product_id = '414940' AND price > 0
                ORDER BY price ASC LIMIT 1
684 0.0004 0.00043892860412598
SELECT value FROM productattributes WHERE product_id = '414940' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
685 0.0001 0.00011897087097168
UPDATE products SET price = '4490' WHERE id = '414940'
686 0.0002 0.0002288818359375
SELECT * FROM productimages WHERE product_id = '407595' ORDER BY sortorder ASC
687 0.0002 0.00020194053649902
SELECT * FROM product_image_select WHERE product_id = '407595'
688 0.0001 0.00013208389282227
SELECT * FROM productcustomimages WHERE product_id = '407595'
689 0.0034 0.0033531188964844
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '407595' AND a.name = n.originalname
690 0.0002 0.00018596649169922
SELECT * FROM productoffers WHERE product_id = '407595' AND merchantid = 'ATVPDKIKX0DER'
691 0.0002 0.00019502639770508
SELECT * FROM productoffers
                WHERE product_id = '407595' AND price > 0
                ORDER BY price ASC LIMIT 1
692 0.0004 0.00043702125549316
SELECT value FROM productattributes WHERE product_id = '407595' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
693 0.0001 0.00011992454528809
UPDATE products SET price = '2497' WHERE id = '407595'
694 0.1043 0.10425686836243
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
695 0.0003 0.00028705596923828
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:1560834345;s:8:\"products\";a:6:{i:8;s:6:\"408792\";i:9;s:6:\"103845\";i:0;s:6:\"414940\";i:1;s:6:\"398315\";i:2;s:6:\"407595\";i:4;s:6:\"171938\";}}' WHERE id = '183'
696 0.0005 0.00045394897460938
SELECT * FROM products WHERE id IN (408792,103845,414940,398315,407595,171938) ORDER BY FIELD(id, 408792,103845,414940,398315,407595,171938 )
697 0.0002 0.00021505355834961
SELECT * FROM productimages WHERE product_id = '408792' ORDER BY sortorder ASC
698 0.0002 0.00022697448730469
SELECT * FROM product_image_select WHERE product_id = '408792'
699 0.0001 0.00012898445129395
SELECT * FROM productcustomimages WHERE product_id = '408792'
700 0.0037 0.0037298202514648
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '408792' AND a.name = n.originalname
701 0.0002 0.00019001960754395
SELECT * FROM productoffers WHERE product_id = '408792' AND merchantid = 'ATVPDKIKX0DER'
702 0.0002 0.00021004676818848
SELECT * FROM productoffers
                WHERE product_id = '408792' AND price > 0
                ORDER BY price ASC LIMIT 1
703 0.0005 0.00045299530029297
SELECT value FROM productattributes WHERE product_id = '408792' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
704 0.0001 0.00012493133544922
UPDATE products SET price = '13499' WHERE id = '408792'
705 0.0002 0.00020003318786621
SELECT * FROM productimages WHERE product_id = '103845' ORDER BY sortorder ASC
706 0.0002 0.00020503997802734
SELECT * FROM product_image_select WHERE product_id = '103845'
707 0.0001 0.0001220703125
SELECT * FROM productcustomimages WHERE product_id = '103845'
708 0.0024 0.0024349689483643
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '103845' AND a.name = n.originalname
709 0.0002 0.00018596649169922
SELECT * FROM productoffers WHERE product_id = '103845' AND merchantid = 'ATVPDKIKX0DER'
710 0.0002 0.0001988410949707
SELECT * FROM productoffers
                WHERE product_id = '103845' AND price > 0
                ORDER BY price ASC LIMIT 1
711 0.0004 0.00038003921508789
SELECT value FROM productattributes WHERE product_id = '103845' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
712 0.0001 0.00011897087097168
UPDATE products SET price = '14499' WHERE id = '103845'
713 0.0002 0.00017881393432617
SELECT * FROM productimages WHERE product_id = '414940' ORDER BY sortorder ASC
714 0.0002 0.0002131462097168
SELECT * FROM product_image_select WHERE product_id = '414940'
715 0.0001 0.00012421607971191
SELECT * FROM productcustomimages WHERE product_id = '414940'
716 0.0033 0.0032989978790283
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '414940' AND a.name = n.originalname
717 0.0002 0.00019097328186035
SELECT * FROM productoffers WHERE product_id = '414940' AND merchantid = 'ATVPDKIKX0DER'
718 0.0002 0.00021100044250488
SELECT * FROM productoffers
                WHERE product_id = '414940' AND price > 0
                ORDER BY price ASC LIMIT 1
719 0.0004 0.00043296813964844
SELECT value FROM productattributes WHERE product_id = '414940' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
720 0.0001 0.00012111663818359
UPDATE products SET price = '4490' WHERE id = '414940'
721 0.0002 0.00020194053649902
SELECT * FROM productimages WHERE product_id = '398315' ORDER BY sortorder ASC
722 0.0002 0.00021100044250488
SELECT * FROM product_image_select WHERE product_id = '398315'
723 0.0001 0.00012302398681641
SELECT * FROM productcustomimages WHERE product_id = '398315'
724 0.0025 0.0025339126586914
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '398315' AND a.name = n.originalname
725 0.0002 0.0001838207244873
SELECT * FROM productoffers WHERE product_id = '398315' AND merchantid = 'ATVPDKIKX0DER'
726 0.0002 0.0001990795135498
SELECT * FROM productoffers
                WHERE product_id = '398315' AND price > 0
                ORDER BY price ASC LIMIT 1
727 0.0004 0.00038599967956543
SELECT value FROM productattributes WHERE product_id = '398315' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
728 0.0001 0.0001220703125
UPDATE products SET price = '1999' WHERE id = '398315'
729 0.0002 0.00023102760314941
SELECT * FROM productimages WHERE product_id = '407595' ORDER BY sortorder ASC
730 0.0002 0.00021481513977051
SELECT * FROM product_image_select WHERE product_id = '407595'
731 0.0001 0.00012302398681641
SELECT * FROM productcustomimages WHERE product_id = '407595'
732 0.0034 0.0033550262451172
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '407595' AND a.name = n.originalname
733 0.0002 0.00018715858459473
SELECT * FROM productoffers WHERE product_id = '407595' AND merchantid = 'ATVPDKIKX0DER'
734 0.0002 0.00020003318786621
SELECT * FROM productoffers
                WHERE product_id = '407595' AND price > 0
                ORDER BY price ASC LIMIT 1
735 0.0004 0.00044083595275879
SELECT value FROM productattributes WHERE product_id = '407595' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
736 0.0001 0.0001218318939209
UPDATE products SET price = '2497' WHERE id = '407595'
737 0.0006 0.00062799453735352
SELECT * FROM productimages WHERE product_id = '171938' ORDER BY sortorder ASC
738 0.0002 0.00022220611572266
SELECT * FROM product_image_select WHERE product_id = '171938'
739 0.0001 0.0001227855682373
SELECT * FROM productcustomimages WHERE product_id = '171938'
740 0.0025 0.002547025680542
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '171938' AND a.name = n.originalname
741 0.0002 0.00019192695617676
SELECT * FROM productoffers WHERE product_id = '171938' AND merchantid = 'ATVPDKIKX0DER'
742 0.0002 0.00020909309387207
SELECT * FROM productoffers
                WHERE product_id = '171938' AND price > 0
                ORDER BY price ASC LIMIT 1
743 0.0004 0.00039505958557129
SELECT value FROM productattributes WHERE product_id = '171938' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
744 0.0001 0.00012302398681641
UPDATE products SET price = '389500' WHERE id = '171938'
745 0.0004 0.00040197372436523
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid' AND area = 'header' ORDER BY sortorder ASC
746 0.0002 0.0001521110534668
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
747 0.0001 0.00012707710266113
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
748 0.0001 0.00012397766113281
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
749 0.0001 0.00012111663818359
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
750 0.0004 0.00041103363037109
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid' AND area = 'footer' ORDER BY sortorder ASC
751 0.0001 0.00012922286987305
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
752 0.0001 0.00012397766113281
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
753 0.0001 0.00012087821960449
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
754 0.0009 0.00091409683227539
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-fluid' AND skinuid = ''
755 0.0003 0.00031900405883789
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid'
756 0.0003 0.00028800964355469
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid'
757 0.0005 0.00045299530029297
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid' AND imageuid = 'HEAD_CUSTOM_BANNER'
758 0.0003 0.00033402442932129
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid' AND imageuid = 'HEAD_CUSTOM_BANNER'