Tactical Equipment - Survivalist Equipment

Bushnell Elite 15-45x 60mm Roof Prism PC-3 Waterproof/Fogproof Spotting Scope from Bushnell

Price: $477.24
Product prices and availability are accurate as of 2019-07-22 00:54:37 UTC and are subject to change. Any price and availability information displayed on http://www.amazon.com/ at the time of purchase will apply to the purchase of this product.
Availability: In Stock
Usually ships in 1-2 business days
CERTAIN CONTENT THAT APPEARS ON THIS SITE COMES FROM AMAZON SERVICES LLC. THIS CONTENT IS PROVIDED 'AS IS' AND IS SUBJECT TO CHANGE OR REMOVAL AT ANY TIME.

Product Description

The Tactical and Survivalist shop is proud to stock the excellent Bushnell Elite 15-45x 60mm Roof Prism PC-3 Waterproof/Fogproof Spotting Scope today at this great price.

With so many competing tactical, combat and survival products on offer recently, it is wise to have a brand that you can trust. The Bushnell Elite 15-45x 60mm Roof Prism PC-3 Waterproof/Fogproof Spotting Scope is certainly all that and will be a perfect purchase for your combat equipment or tactical ability.

We pride ourselves to provide the best quality tactical gear for all your front line requirements.

For this low price, the Bushnell Elite 15-45x 60mm Roof Prism PC-3 Waterproof/Fogproof Spotting Scope is highly recommended and is a regular choice for most like minded people. Bushnell have added some nice touches and this equals improved value.

Manufacturer Description

Delight in the view from the peak of ideal accomplishment. A Bushnell Elite Spotting Scope provides you the advantage from the World's highpoint of brightness., quality, and edge-to-edge information, whether you are birding at sea level or hunting above the timberline. Premium BaK-4 prisms and totally multi-coated lenses provide flawless color fidelity, ultra-crisp images and maximum light transmission. Water resistant building and Bushnell's RainGuard HD finishing keep things clear.The Bushnell Elite 15-45x60 finding scope offers brightness, quality, and edge-to-edge information whether you're birding at sea level or hunting above the timberline. Bushnell's 60mm and 70mm scopes are furnished with PC-3 phase-corrected BaK-4 roofing system prisms with totally multicoated optics. The Elite finding scope offers unmatched brightness


and edge-to-edge quality. Bushnell then used ED Prime Extra-Low Dispersion fluorite glass for the lens. The optics and
glass integrate to provide extra-sharp, extra-bright, fantastic color resolution and contrast even at the longest varieties, making the scope perfect for tourists, birders, backpackers, and big-game hunters. The glass also virtually removes chromatic aberration and color fringing, assisting it draw out the most unique information possible in low-light conditions. To ensure a clear view in damp conditions, the Elite scope includes Bushnell's patented RainGuard HD lens finishing. Featured on all Elite items, the special water-repellent finishing triggers water drops from rain, snow, sleet, or condensation to bead up into much smaller sized droplets. These small droplets spread less light, leading to a much clearer and brighter view. Other functions consist of an easy-to-handle, rubber-armored body; a 100-percent waterproof, shockproof, and fogproof design; a zoom eyepiece; and a protective case. Specifications Magnification: 15 to 45x Objective lens: 60mm Lens finishing: Fully multicoated Close focus: 12.2 inches RainGuard HD: Yes Exit pupil: 4(15x

), 1.3(45x)Prism glass: BaK-4 Waterproof/fogproof: Yes Other eyepieces available: Yes Field of view: 125 feet @ 1,000 feet

  • (15x), 65 feet @ 1,000 feet(
  • 45x)Length: 12.2
  • inches Weight: 26.5 ounces About
  • Bushnell Bushnell has
  • been the industry leader in high-performance sports optics for more than 50 years. The business's assisting concept is to supply the highest quality, a lot of
  • reliable, and a lot of affordable sports optics items on

    the marketplace. Bushnell item lines enhance the pleasure of every outside pursuit, including nature study, hunting, fishing, birding, and stargazing. Indoors, the business's binoculars bring the audience more detailed to the action in fast-moving sports or the arts at theaters and shows.

  • Product Features

    Quality optics with stunning HD clarity 100% quality materials used and tested extensively Beautiful design and durability built to last Spotting scope with 15 to 45x magnification and 60mm objective lens PC-3 phase-corrected BaK-4 roof prisms with fully multicoated optics ED Prime fluoride glass provides sharp, brilliant color resolution and clarity Water-repellent RainGuard HD lens coating; rubber armoring Waterproof, shockproof, and fogproof; measures 12.2 inches long

    Write a Review

    Debug Overview

    App Total Time DB Queries DB Query Total Time Amazon Requests
    7.2291009426117 808 3.2669 0


    No Amazon API Requests Made.


    App Debug - Total Time 7.2291009426117 seconds

    Number Time From Start Name Description
    1 0.42979288101196 Initialise Initialise FSB Function
    2 0.43728995323181 App Controller Start Start of the App controller (called before the controller of every page)
    3 0.44826793670654 Start of getCategoryListByGroup Function Before first category groups query
    4 0.44844603538513 After initial query Before first category groups query
    5 0.44844794273376 Get Category List for Group Before the call to getCategoryList function
    6 0.44845104217529 Start of GetCategoryList function Start of the function
    7 0.44845485687256 Before getting categories Query to get specific category list
    8 0.44900488853455 After getting categories Query to get specific category list
    9 0.44900608062744 Before getting category custom Before call to function getCategoryCustom
    10 0.45083403587341 After getting category custom After call to function getCategoryCustom
    11 0.45083689689636 Before getting category custom Before call to function getCategoryCustom
    12 0.46141290664673 After getting category custom After call to function getCategoryCustom
    13 0.46141600608826 Before getting category custom Before call to function getCategoryCustom
    14 0.46736788749695 After getting category custom After call to function getCategoryCustom
    15 0.46737003326416 Before getting category custom Before call to function getCategoryCustom
    16 0.47145891189575 After getting category custom After call to function getCategoryCustom
    17 0.47146105766296 End of GetCategoryList function End of the function
    18 0.47146987915039 Get Category List for Group Before the call to getCategoryList function
    19 0.47147297859192 Start of GetCategoryList function Start of the function
    20 0.47147607803345 Before getting categories Query to get specific category list
    21 0.47189092636108 After getting categories Query to get specific category list
    22 0.4718918800354 Before getting category custom Before call to function getCategoryCustom
    23 0.47745108604431 After getting category custom After call to function getCategoryCustom
    24 0.47745299339294 Before getting category custom Before call to function getCategoryCustom
    25 0.48815608024597 After getting category custom After call to function getCategoryCustom
    26 0.4881579875946 End of GetCategoryList function End of the function
    27 0.48816394805908 Get Category List for Group Before the call to getCategoryList function
    28 0.48816585540771 Start of GetCategoryList function Start of the function
    29 0.48816895484924 Before getting categories Query to get specific category list
    30 0.48886609077454 After getting categories Query to get specific category list
    31 0.48886704444885 Before getting category custom Before call to function getCategoryCustom
    32 0.49815607070923 After getting category custom After call to function getCategoryCustom
    33 0.49815893173218 Before getting category custom Before call to function getCategoryCustom
    34 0.51604700088501 After getting category custom After call to function getCategoryCustom
    35 0.51604890823364 Before getting category custom Before call to function getCategoryCustom
    36 0.52200293540955 After getting category custom After call to function getCategoryCustom
    37 0.52200603485107 Before getting category custom Before call to function getCategoryCustom
    38 0.52792406082153 After getting category custom After call to function getCategoryCustom
    39 0.52792596817017 Before getting category custom Before call to function getCategoryCustom
    40 0.53420805931091 After getting category custom After call to function getCategoryCustom
    41 0.53421092033386 Before getting category custom Before call to function getCategoryCustom
    42 0.55610489845276 After getting category custom After call to function getCategoryCustom
    43 0.55610799789429 Before getting category custom Before call to function getCategoryCustom
    44 0.56017994880676 After getting category custom After call to function getCategoryCustom
    45 0.5601818561554 Before getting category custom Before call to function getCategoryCustom
    46 0.56550288200378 After getting category custom After call to function getCategoryCustom
    47 0.56550598144531 End of GetCategoryList function End of the function
    48 0.56551885604858 Get Category List for Group Before the call to getCategoryList function
    49 0.56552195549011 Start of GetCategoryList function Start of the function
    50 0.56552505493164 Before getting categories Query to get specific category list
    51 0.56593799591064 After getting categories Query to get specific category list
    52 0.56593894958496 Before getting category custom Before call to function getCategoryCustom
    53 0.56822991371155 After getting category custom After call to function getCategoryCustom
    54 0.56823301315308 Before getting category custom Before call to function getCategoryCustom
    55 0.57054996490479 After getting category custom After call to function getCategoryCustom
    56 0.57055187225342 End of GetCategoryList function End of the function
    57 0.57055902481079 Get Category List for Group Before the call to getCategoryList function
    58 0.57056093215942 Start of GetCategoryList function Start of the function
    59 0.57056403160095 Before getting categories Query to get specific category list
    60 0.57086706161499 After getting categories Query to get specific category list
    61 0.57086801528931 Before getting category custom Before call to function getCategoryCustom
    62 0.57585501670837 After getting category custom After call to function getCategoryCustom
    63 0.57585692405701 End of GetCategoryList function End of the function
    64 0.57586288452148 End of getCategoryListByGroup Function Before return()
    65 0.6255190372467 App Controller End End of the App controller (called before the controller of every page)
    66 0.62612795829773 Product Start Start of the product info controller
    67 0.62695789337158 Cache file not found Starting get product details
    68 0.71069097518921 Related products Start getting related products if enabled
    69 0.71069288253784 Related Products Start Before the related products are found
    70 0.71069407463074 Related Products Keywords Before the related product keywords are found
    71 0.71070790290833 Create Keyword List Function Start of function
    72 0.71297597885132 Create Keyword List Function After looping provided content - 1530 keywords found
    73 0.81542301177979 Create Keyword List Function After looping initial keyword list - 1450 keywords remaining
    74 0.81580686569214 Create Keyword List Function After reducing keyword list
    75 0.81695795059204 Create Keyword List Function After selecting by scoring keywords
    76 0.81696391105652 Create Keyword List Function After final loop of keywords
    77 0.81696701049805 Related Products Keywords After the related product keywords are found
    78 1.3422069549561 Related Products End After the related products are found
    79 1.548593044281 Start Remote Request http://svcs.ebay.com/services/search/FindingServic...
    80 1.989767074585 End Remote Request http://svcs.ebay.com/services/search/FindingServic...
    81 2.1936089992523 Start Remote Request http://svcs.ebay.com/services/search/FindingServic...
    82 2.5139520168304 End Remote Request http://svcs.ebay.com/services/search/FindingServic...
    83 2.7193129062653 Start Remote Request http://svcs.ebay.com/services/search/FindingServic...
    84 3.0438039302826 End Remote Request http://svcs.ebay.com/services/search/FindingServic...
    85 3.2487320899963 Start Remote Request http://svcs.ebay.com/services/search/FindingServic...
    86 3.5869469642639 End Remote Request http://svcs.ebay.com/services/search/FindingServic...
    87 3.7914428710938 Start Remote Request http://svcs.ebay.com/services/search/FindingServic...
    88 4.1035089492798 End Remote Request http://svcs.ebay.com/services/search/FindingServic...
    89 4.3081560134888 Start Remote Request http://svcs.ebay.com/services/search/FindingServic...
    90 4.6116619110107 End Remote Request http://svcs.ebay.com/services/search/FindingServic...
    91 4.8170459270477 Start Remote Request http://svcs.ebay.com/services/search/FindingServic...
    92 5.1272940635681 End Remote Request http://svcs.ebay.com/services/search/FindingServic...
    93 5.332573890686 Start Remote Request http://svcs.ebay.com/services/search/FindingServic...
    94 5.6455519199371 End Remote Request http://svcs.ebay.com/services/search/FindingServic...
    95 5.8517708778381 Start Remote Request http://svcs.ebay.com/services/search/FindingServic...
    96 6.129734992981 End Remote Request http://svcs.ebay.com/services/search/FindingServic...
    97 6.3504688739777 Product End End of the product info controller (Product Info)
    98 6.3508400917053 App_after Controller Start Start of the App_after controller (called after the controller of every page)
    99 6.3509230613708 Before Get Options Before the call to getOptions in the tpl class
    100 6.7757210731506 After Get Options After the call to getOptions in the tpl class
    101 6.7759819030762 App_after Controller End End of the App_after controller (called after the controller of every page)
    102 6.7759959697723 Product Info: Before Smarty Fetch Before the product.tpl template is fetched
    103 7.0241069793701 Product Info: After Smarty Fetch After the product.tpl template is fetched
    104 7.0241138935089 Product Info: Before Template Display Before the template is displayed
    105 7.2290780544281 Product Info: After Template Display After the template is displayed
    106 7.2290830612183 Finalizing debug Before the debug is output to the page.
    107 7.2290999889374 End of App This is the end of the app logging, final timestamp


    Query Debug - 808 Database Queries. Total time 3.2669 seconds

    Number Time (Seconds) Time (Milliseconds) Query
    1 0.0002 0.00016403198242188
    SELECT value FROM parameters WHERE `parameter` = 'BAD_BOTS_ENABLER'
    2 0.0004 0.00043797492980957
    SHOW TABLES LIKE 'bad_bots'
    3 0.0001 0.00014615058898926
    SELECT value FROM parameters WHERE `parameter` = 'STORE_WHITELISTED_IPS'
    4 0.0002 0.00015687942504883
    SELECT * FROM `bad_bots`
    5 0.0004 0.0004270076751709
    SELECT parameter, value FROM parameters
    6 0.0002 0.00015902519226074
    SET time_zone = 'Europe/London'
    7 0.0003 0.00028610229492188
    SELECT * FROM autorun ORDER BY lastrun ASC
    8 0.0001 0.00014185905456543
    SELECT * FROM version ORDER BY installed DESC LIMIT 1
    9 0.0002 0.00018715858459473
    delete from cachefiles
    10 0.0002 0.00023412704467773
    SELECT id FROM pages WHERE pagename = 'bushnell-elite-15-45x-60mm-roof-prism-pc-3-waterprooffogproof-spotting-scope' LIMIT 1
    11 0.0002 0.00022006034851074
    SELECT id FROM products WHERE pagename = 'bushnell-elite-15-45x-60mm-roof-prism-pc-3-waterprooffogproof-spotting-scope' AND hidden = 0 LIMIT 1
    12 0.0008 0.0007941722869873
    SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-fluid'
    13 0.0092 0.0091769695281982
    SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-fluid' AND language = 'en'
    14 0.0002 0.0002448558807373
    SELECT * FROM pages WHERE pagename = 'bushnell-elite-15-45x-60mm-roof-prism-pc-3-waterprooffogproof-spotting-scope'
    15 0.0002 0.00016307830810547
    SELECT * FROM categorygroups ORDER BY sortorder ASC
    16 0.0005 0.00051093101501465
    SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
    17 0.0005 0.00048089027404785
    SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 49
    18 0.0002 0.00022315979003906
    SELECT id FROM categories WHERE parent_id = '49'
    19 0.0004 0.00043511390686035
    SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
    				WHERE p.id = c.product_id
    				  AND c.category_id IN (49)
    				  AND p.parent_id = 0
    				  AND p.hidden = 0
    				  AND p.enabled = 1 
    20 0.0001 0.00014281272888184
    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.00015878677368164
    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.00016903877258301
    SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '49'
    23 0.0001 0.0001218318939209
    SELECT * FROM categorygroups WHERE id = '1'
    24 0.0030 0.0030179023742676
    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.00025081634521484
    SELECT id FROM categories WHERE parent_id = '50'
    26 0.0002 0.00020098686218262
    SELECT id FROM categories WHERE parent_id = '96'
    27 0.0002 0.00020980834960938
    SELECT id FROM categories WHERE parent_id = '97'
    28 0.0002 0.0001981258392334
    SELECT id FROM categories WHERE parent_id = '111'
    29 0.0002 0.00019621849060059
    SELECT id FROM categories WHERE parent_id = '129'
    30 0.0057 0.0057449340820312
    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.00016903877258301
    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.0001521110534668
    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.0001671314239502
    SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '50'
    34 0.0001 0.00013113021850586
    SELECT * FROM categorygroups WHERE id = '1'
    35 0.0025 0.0025160312652588
    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.00025701522827148
    SELECT id FROM categories WHERE parent_id = '80'
    37 0.0025 0.0025019645690918
    SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
    				WHERE p.id = c.product_id
    				  AND c.category_id IN (80)
    				  AND p.parent_id = 0
    				  AND p.hidden = 0
    				  AND p.enabled = 1 
    38 0.0001 0.00014591217041016
    SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
    				WHERE p.id = c.bundle_id
    				  AND c.category_id IN (80)
    				  AND p.disabled = 0 
    39 0.0001 0.00014495849609375
    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.00015592575073242
    SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '80'
    41 0.0001 0.00012111663818359
    SELECT * FROM categorygroups WHERE id = '1'
    42 0.0012 0.0011630058288574
    SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 51
    43 0.0002 0.0002448558807373
    SELECT id FROM categories WHERE parent_id = '51'
    44 0.0002 0.00020217895507812
    SELECT id FROM categories WHERE parent_id = '101'
    45 0.0018 0.0017850399017334
    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.00015020370483398
    SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
    				WHERE p.id = c.bundle_id
    				  AND c.category_id IN (101,51)
    				  AND p.disabled = 0 
    47 0.0001 0.00014400482177734
    SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
    				WHERE ep.id = c.product_id
    				  AND c.category_id IN (101,51)
    				  AND c.prod_type = 'ebay'
    				  AND ep.hide = 1 
    48 0.0002 0.00016498565673828
    SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '51'
    49 0.0001 0.00013113021850586
    SELECT * FROM categorygroups WHERE id = '1'
    50 0.0004 0.00039196014404297
    SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '2'  AND hidden = 0 ORDER BY sortorder ASC
    51 0.0023 0.0023140907287598
    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.00025606155395508
    SELECT id FROM categories WHERE parent_id = '30'
    53 0.0023 0.0023109912872314
    SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
    				WHERE p.id = c.product_id
    				  AND c.category_id IN (30)
    				  AND p.parent_id = 0
    				  AND p.hidden = 0
    				  AND p.enabled = 1 
    54 0.0001 0.00014710426330566
    SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
    				WHERE p.id = c.bundle_id
    				  AND c.category_id IN (30)
    				  AND p.disabled = 0 
    55 0.0001 0.00014305114746094
    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.00016498565673828
    SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
    57 0.0001 0.00013089179992676
    SELECT * FROM categorygroups WHERE id = '2'
    58 0.0048 0.0048489570617676
    SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 61
    59 0.0003 0.0002751350402832
    SELECT id FROM categories WHERE parent_id = '61'
    60 0.0049 0.004896879196167
    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.00015711784362793
    SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
    				WHERE p.id = c.bundle_id
    				  AND c.category_id IN (61)
    				  AND p.disabled = 0 
    62 0.0001 0.00014686584472656
    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.00016188621520996
    SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '61'
    64 0.0001 0.0001218318939209
    SELECT * FROM categorygroups WHERE id = '2'
    65 0.0006 0.00063419342041016
    SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '10'  AND hidden = 0 ORDER BY sortorder ASC
    66 0.0042 0.0041639804840088
    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.0002589225769043
    SELECT id FROM categories WHERE parent_id = '64'
    68 0.0042 0.0041868686676025
    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.00015401840209961
    SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
    				WHERE p.id = c.bundle_id
    				  AND c.category_id IN (64)
    				  AND p.disabled = 0 
    70 0.0001 0.00014495849609375
    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.00016093254089355
    SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '64'
    72 0.0001 0.0001218318939209
    SELECT * FROM categorygroups WHERE id = '10'
    73 0.0085 0.0084788799285889
    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.00027799606323242
    SELECT id FROM categories WHERE parent_id = '65'
    75 0.0084 0.0084488391876221
    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.00016093254089355
    SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
    				WHERE p.id = c.bundle_id
    				  AND c.category_id IN (65)
    				  AND p.disabled = 0 
    77 0.0001 0.00014615058898926
    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.00016403198242188
    SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '65'
    79 0.0001 0.0001220703125
    SELECT * FROM categorygroups WHERE id = '10'
    80 0.0025 0.0025169849395752
    SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 81
    81 0.0003 0.0002591609954834
    SELECT id FROM categories WHERE parent_id = '81'
    82 0.0025 0.0025179386138916
    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.00015020370483398
    SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
    				WHERE p.id = c.bundle_id
    				  AND c.category_id IN (81)
    				  AND p.disabled = 0 
    84 0.0001 0.00014400482177734
    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.00015592575073242
    SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '81'
    86 0.0001 0.00012087821960449
    SELECT * FROM categorygroups WHERE id = '10'
    87 0.0025 0.0024900436401367
    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.00025701522827148
    SELECT id FROM categories WHERE parent_id = '31'
    89 0.0025 0.0024938583374023
    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.00015687942504883
    SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
    				WHERE p.id = c.bundle_id
    				  AND c.category_id IN (31)
    				  AND p.disabled = 0 
    91 0.0001 0.00014519691467285
    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.00016188621520996
    SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
    93 0.0001 0.00012087821960449
    SELECT * FROM categorygroups WHERE id = '10'
    94 0.0023 0.0022737979888916
    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.00026583671569824
    SELECT id FROM categories WHERE parent_id = '66'
    96 0.0002 0.00020194053649902
    SELECT id FROM categories WHERE parent_id = '131'
    97 0.0029 0.0028550624847412
    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.00015497207641602
    SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
    				WHERE p.id = c.bundle_id
    				  AND c.category_id IN (131,66)
    				  AND p.disabled = 0 
    99 0.0001 0.00014805793762207
    SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
    				WHERE ep.id = c.product_id
    				  AND c.category_id IN (131,66)
    				  AND c.prod_type = 'ebay'
    				  AND ep.hide = 1 
    100 0.0002 0.00015807151794434
    SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '66'
    101 0.0001 0.00012302398681641
    SELECT * FROM categorygroups WHERE id = '10'
    102 0.0096 0.0095870494842529
    SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 34
    103 0.0003 0.00028395652770996
    SELECT id FROM categories WHERE parent_id = '34'
    104 0.0002 0.00020098686218262
    SELECT id FROM categories WHERE parent_id = '94'
    105 0.0002 0.00020718574523926
    SELECT id FROM categories WHERE parent_id = '98'
    106 0.0002 0.00021696090698242
    SELECT id FROM categories WHERE parent_id = '99'
    107 0.0002 0.0001990795135498
    SELECT id FROM categories WHERE parent_id = '110'
    108 0.0002 0.00019478797912598
    SELECT id FROM categories WHERE parent_id = '130'
    109 0.0102 0.010231018066406
    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.00017499923706055
    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.0001530647277832
    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.00017499923706055
    SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '34'
    113 0.0001 0.00012397766113281
    SELECT * FROM categorygroups WHERE id = '10'
    114 0.0016 0.0015721321105957
    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.00025796890258789
    SELECT id FROM categories WHERE parent_id = '32'
    116 0.0016 0.0015871524810791
    SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
    				WHERE p.id = c.product_id
    				  AND c.category_id IN (32)
    				  AND p.parent_id = 0
    				  AND p.hidden = 0
    				  AND p.enabled = 1 
    117 0.0001 0.00014400482177734
    SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
    				WHERE p.id = c.bundle_id
    				  AND c.category_id IN (32)
    				  AND p.disabled = 0 
    118 0.0001 0.00014090538024902
    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.00015902519226074
    SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '32'
    120 0.0001 0.00012111663818359
    SELECT * FROM categorygroups WHERE id = '10'
    121 0.0022 0.0021870136260986
    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.0002 0.00024795532226562
    SELECT id FROM categories WHERE parent_id = '89'
    123 0.0022 0.0022060871124268
    SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
    				WHERE p.id = c.product_id
    				  AND c.category_id IN (89)
    				  AND p.parent_id = 0
    				  AND p.hidden = 0
    				  AND p.enabled = 1 
    124 0.0001 0.00014519691467285
    SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
    				WHERE p.id = c.bundle_id
    				  AND c.category_id IN (89)
    				  AND p.disabled = 0 
    125 0.0001 0.00014281272888184
    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.00016498565673828
    SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '89'
    127 0.0001 0.00012397766113281
    SELECT * FROM categorygroups WHERE id = '10'
    128 0.0004 0.00038909912109375
    SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '17'  AND hidden = 0 ORDER BY sortorder ASC
    129 0.0007 0.00069403648376465
    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.00023317337036133
    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.0001 0.00014209747314453
    SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
    				WHERE p.id = c.bundle_id
    				  AND c.category_id IN (84)
    				  AND p.disabled = 0 
    133 0.0001 0.00014090538024902
    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.00016283988952637
    SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '84'
    135 0.0001 0.00011992454528809
    SELECT * FROM categorygroups WHERE id = '17'
    136 0.0007 0.00070381164550781
    SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 90
    137 0.0002 0.00023102760314941
    SELECT id FROM categories WHERE parent_id = '90'
    138 0.0007 0.00073099136352539
    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.00013995170593262
    SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
    				WHERE p.id = c.bundle_id
    				  AND c.category_id IN (90)
    				  AND p.disabled = 0 
    140 0.0001 0.00014114379882812
    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.00016188621520996
    SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '90'
    142 0.0001 0.00011992454528809
    SELECT * FROM categorygroups WHERE id = '17'
    143 0.0003 0.0002899169921875
    SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '20'  AND hidden = 0 ORDER BY sortorder ASC
    144 0.0020 0.0020492076873779
    SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 92
    145 0.0002 0.00023508071899414
    SELECT id FROM categories WHERE parent_id = '92'
    146 0.0020 0.0020480155944824
    SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
    				WHERE p.id = c.product_id
    				  AND c.category_id IN (92)
    				  AND p.parent_id = 0
    				  AND p.hidden = 0
    				  AND p.enabled = 1 
    147 0.0002 0.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.0001 0.00014400482177734
    SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
    				WHERE ep.id = c.product_id
    				  AND c.category_id IN (92)
    				  AND c.prod_type = 'ebay'
    				  AND ep.hide = 1 
    149 0.0001 0.00014519691467285
    SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '92'
    150 0.0001 0.00011992454528809
    SELECT * FROM categorygroups WHERE id = '20'
    151 0.0051 0.0051329135894775
    SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
    152 0.0004 0.00036787986755371
    SELECT * FROM sideboxes WHERE (templateuid = 'fsb-fluid' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
    153 0.0002 0.00020122528076172
    SELECT value FROM parameters WHERE parameter = 'EBAY_APP_ID' 
    154 0.0002 0.00015497207641602
    SELECT * FROM sideboxes_pages WHERE sidebox_id = '1'
    155 0.0002 0.00016403198242188
    SELECT * FROM pages WHERE id = '67'
    156 0.0002 0.00015401840209961
    SELECT * FROM pages WHERE id = '82'
    157 0.0002 0.00015616416931152
    SELECT * FROM pages WHERE id = '84'
    158 0.0001 0.00014090538024902
    SELECT * FROM pages WHERE id = '94'
    159 0.0002 0.00015401840209961
    SELECT * FROM pages WHERE id = '116'
    160 0.0002 0.00019407272338867
    SELECT * FROM pages WHERE id = '52'
    161 0.0002 0.00015401840209961
    SELECT * FROM pages WHERE id = '135'
    162 0.0001 0.00014996528625488
    SELECT * FROM pages WHERE id = '245'
    163 0.0002 0.00015902519226074
    SELECT * FROM pages WHERE id = '269'
    164 0.0002 0.00020003318786621
    SELECT * FROM pages WHERE id = '275'
    165 0.0002 0.00017690658569336
    SELECT * FROM pages WHERE id = '280'
    166 0.0002 0.00018215179443359
    SELECT * FROM pages WHERE id = '357'
    167 0.0001 0.00014305114746094
    SELECT * FROM pages WHERE id = '379'
    168 0.0001 0.0001380443572998
    SELECT * FROM pages WHERE id = '401'
    169 0.0001 0.00014710426330566
    SELECT * FROM pages WHERE id = '450'
    170 0.0001 0.00014710426330566
    SELECT * FROM pages WHERE id = '454'
    171 0.0002 0.00015401840209961
    SELECT * FROM pages WHERE id = '457'
    172 0.0001 0.00014901161193848
    SELECT * FROM pages WHERE id = '458'
    173 0.0002 0.00015020370483398
    SELECT * FROM sideboxes_pages WHERE sidebox_id = '2'
    174 0.0002 0.00015902519226074
    SELECT * FROM pages WHERE id = '41'
    175 0.0002 0.0001671314239502
    SELECT * FROM pages WHERE id = '43'
    176 0.0001 0.00014781951904297
    SELECT * FROM pages WHERE id = '44'
    177 0.0001 0.00014209747314453
    SELECT * FROM pages WHERE id = '68'
    178 0.0002 0.00018906593322754
    SELECT * FROM pages WHERE id = '80'
    179 0.0002 0.00015592575073242
    SELECT * FROM pages WHERE id = '85'
    180 0.0002 0.00015091896057129
    SELECT * FROM pages WHERE id = '97'
    181 0.0002 0.00016593933105469
    SELECT * FROM pages WHERE id = '107'
    182 0.0001 0.00014495849609375
    SELECT * FROM pages WHERE id = '108'
    183 0.0001 0.00013422966003418
    SELECT * FROM pages WHERE id = '128'
    184 0.0002 0.00015807151794434
    SELECT * FROM pages WHERE id = '133'
    185 0.0001 0.00014305114746094
    SELECT * FROM pages WHERE id = '148'
    186 0.0002 0.0001528263092041
    SELECT * FROM pages WHERE id = '217'
    187 0.0001 0.00014996528625488
    SELECT * FROM pages WHERE id = '228'
    188 0.0001 0.00014591217041016
    SELECT * FROM pages WHERE id = '257'
    189 0.0002 0.00015091896057129
    SELECT * FROM pages WHERE id = '271'
    190 0.0001 0.00014400482177734
    SELECT * FROM pages WHERE id = '286'
    191 0.0001 0.00014114379882812
    SELECT * FROM pages WHERE id = '287'
    192 0.0002 0.0001530647277832
    SELECT * FROM pages WHERE id = '291'
    193 0.0002 0.00016498565673828
    SELECT * FROM pages WHERE id = '380'
    194 0.0002 0.00015401840209961
    SELECT * FROM pages WHERE id = '344'
    195 0.0002 0.00015902519226074
    SELECT * FROM pages WHERE id = '354'
    196 0.0002 0.00017404556274414
    SELECT * FROM pages WHERE id = '363'
    197 0.0002 0.00017499923706055
    SELECT * FROM pages WHERE id = '364'
    198 0.0002 0.0001528263092041
    SELECT * FROM pages WHERE id = '368'
    199 0.0002 0.00016999244689941
    SELECT * FROM pages WHERE id = '369'
    200 0.0001 0.00014114379882812
    SELECT * FROM pages WHERE id = '400'
    201 0.0002 0.0001530647277832
    SELECT * FROM pages WHERE id = '463'
    202 0.0002 0.00016212463378906
    SELECT * FROM sideboxes_pages WHERE sidebox_id = '33'
    203 0.0002 0.00024199485778809
    SELECT * FROM pages WHERE id = '66'
    204 0.0002 0.00018596649169922
    SELECT * FROM pages WHERE id = '77'
    205 0.0002 0.00017595291137695
    SELECT * FROM pages WHERE id = '90'
    206 0.0001 0.00014305114746094
    SELECT * FROM pages WHERE id = '414'
    207 0.0001 0.00014519691467285
    SELECT * FROM pages WHERE id = '119'
    208 0.0001 0.00014591217041016
    SELECT * FROM pages WHERE id = '406'
    209 0.0002 0.00015592575073242
    SELECT * FROM pages WHERE id = '149'
    210 0.0001 0.00014305114746094
    SELECT * FROM pages WHERE id = '150'
    211 0.0001 0.00013899803161621
    SELECT * FROM pages WHERE id = '412'
    212 0.0002 0.0001518726348877
    SELECT * FROM pages WHERE id = '162'
    213 0.0001 0.00014019012451172
    SELECT * FROM pages WHERE id = '164'
    214 0.0001 0.00014090538024902
    SELECT * FROM pages WHERE id = '167'
    215 0.0001 0.00014591217041016
    SELECT * FROM pages WHERE id = '180'
    216 0.0001 0.00014305114746094
    SELECT * FROM pages WHERE id = '187'
    217 0.0002 0.00018191337585449
    SELECT * FROM pages WHERE id = '265'
    218 0.0002 0.00015091896057129
    SELECT * FROM pages WHERE id = '268'
    219 0.0001 0.00013899803161621
    SELECT * FROM pages WHERE id = '411'
    220 0.0001 0.00014901161193848
    SELECT * FROM pages WHERE id = '290'
    221 0.0002 0.00015091896057129
    SELECT * FROM pages WHERE id = '413'
    222 0.0001 0.00014209747314453
    SELECT * FROM pages WHERE id = '409'
    223 0.0001 0.00014710426330566
    SELECT * FROM pages WHERE id = '327'
    224 0.0001 0.00014591217041016
    SELECT * FROM pages WHERE id = '336'
    225 0.0002 0.0001518726348877
    SELECT * FROM pages WHERE id = '351'
    226 0.0001 0.00014400482177734
    SELECT * FROM pages WHERE id = '358'
    227 0.0002 0.00016093254089355
    SELECT * FROM pages WHERE id = '360'
    228 0.0002 0.00015020370483398
    SELECT * FROM pages WHERE id = '362'
    229 0.0002 0.00015115737915039
    SELECT * FROM pages WHERE id = '366'
    230 0.0002 0.00015497207641602
    SELECT * FROM pages WHERE id = '370'
    231 0.0001 0.00014615058898926
    SELECT * FROM pages WHERE id = '377'
    232 0.0001 0.00014710426330566
    SELECT * FROM pages WHERE id = '386'
    233 0.0001 0.00014400482177734
    SELECT * FROM pages WHERE id = '408'
    234 0.0001 0.00013995170593262
    SELECT * FROM pages WHERE id = '415'
    235 0.0002 0.00015616416931152
    SELECT * FROM pages WHERE id = '416'
    236 0.0002 0.00017714500427246
    SELECT * FROM pages WHERE id = '419'
    237 0.0001 0.00014996528625488
    SELECT * FROM pages WHERE id = '423'
    238 0.0001 0.00014781951904297
    SELECT * FROM pages WHERE id = '427'
    239 0.0002 0.00017404556274414
    SELECT * FROM pages WHERE id = '428'
    240 0.0001 0.00013494491577148
    SELECT * FROM pages WHERE id = '432'
    241 0.0001 0.00014019012451172
    SELECT * FROM pages WHERE id = '433'
    242 0.0001 0.00014901161193848
    SELECT * FROM pages WHERE id = '436'
    243 0.0001 0.00014519691467285
    SELECT * FROM pages WHERE id = '437'
    244 0.0001 0.00014209747314453
    SELECT * FROM pages WHERE id = '461'
    245 0.0002 0.00016999244689941
    SELECT * FROM pages WHERE id = '464'
    246 0.0001 0.00014305114746094
    SELECT * FROM sideboxes_pages WHERE sidebox_id = '34'
    247 0.0002 0.00015091896057129
    SELECT * FROM pages WHERE id = '74'
    248 0.0001 0.00014305114746094
    SELECT * FROM pages WHERE id = '137'
    249 0.0001 0.00014781951904297
    SELECT * FROM pages WHERE id = '145'
    250 0.0002 0.0001530647277832
    SELECT * FROM pages WHERE id = '156'
    251 0.0001 0.00014591217041016
    SELECT * FROM pages WHERE id = '407'
    252 0.0001 0.0001378059387207
    SELECT * FROM pages WHERE id = '410'
    253 0.0002 0.00016999244689941
    SELECT * FROM pages WHERE id = '266'
    254 0.0002 0.00019192695617676
    SELECT * FROM pages WHERE id = '316'
    255 0.0001 0.00014805793762207
    SELECT * FROM pages WHERE id = '332'
    256 0.0002 0.00018715858459473
    SELECT * FROM pages WHERE id = '334'
    257 0.0001 0.00014495849609375
    SELECT * FROM pages WHERE id = '367'
    258 0.0001 0.00014805793762207
    SELECT * FROM pages WHERE id = '387'
    259 0.0001 0.00014615058898926
    SELECT * FROM pages WHERE id = '389'
    260 0.0002 0.0001521110534668
    SELECT * FROM pages WHERE id = '397'
    261 0.0002 0.00015401840209961
    SELECT * FROM pages WHERE id = '449'
    262 0.0002 0.00016188621520996
    SELECT * FROM sideboxes_pages WHERE sidebox_id = '35'
    263 0.0002 0.00018119812011719
    SELECT * FROM pages WHERE id = '42'
    264 0.0001 0.00014591217041016
    SELECT * FROM pages WHERE id = '79'
    265 0.0002 0.00015592575073242
    SELECT * FROM pages WHERE id = '86'
    266 0.0001 0.00014090538024902
    SELECT * FROM pages WHERE id = '95'
    267 0.0002 0.00015902519226074
    SELECT * FROM pages WHERE id = '102'
    268 0.0001 0.00014090538024902
    SELECT * FROM pages WHERE id = '109'
    269 0.0002 0.00019288063049316
    SELECT * FROM pages WHERE id = '114'
    270 0.0002 0.00017404556274414
    SELECT * FROM pages WHERE id = '121'
    271 0.0002 0.00018405914306641
    SELECT * FROM pages WHERE id = '138'
    272 0.0002 0.00015807151794434
    SELECT * FROM pages WHERE id = '142'
    273 0.0002 0.00018405914306641
    SELECT * FROM pages WHERE id = '62'
    274 0.0001 0.00014281272888184
    SELECT * FROM pages WHERE id = '157'
    275 0.0002 0.0001530647277832
    SELECT * FROM pages WHERE id = '246'
    276 0.0002 0.00017714500427246
    SELECT * FROM pages WHERE id = '276'
    277 0.0002 0.00017690658569336
    SELECT * FROM pages WHERE id = '278'
    278 0.0002 0.0001990795135498
    SELECT * FROM pages WHERE id = '279'
    279 0.0002 0.00015807151794434
    SELECT * FROM pages WHERE id = '317'
    280 0.0001 0.00014591217041016
    SELECT * FROM pages WHERE id = '405'
    281 0.0002 0.00016522407531738
    SELECT * FROM pages WHERE id = '343'
    282 0.0001 0.00014591217041016
    SELECT * FROM pages WHERE id = '345'
    283 0.0002 0.00019001960754395
    SELECT * FROM pages WHERE id = '346'
    284 0.0002 0.00015497207641602
    SELECT * FROM pages WHERE id = '347'
    285 0.0002 0.00015592575073242
    SELECT * FROM pages WHERE id = '348'
    286 0.0001 0.00014901161193848
    SELECT * FROM pages WHERE id = '349'
    287 0.0001 0.00014615058898926
    SELECT * FROM pages WHERE id = '381'
    288 0.0001 0.00014400482177734
    SELECT * FROM pages WHERE id = '392'
    289 0.0002 0.0001530647277832
    SELECT * FROM pages WHERE id = '393'
    290 0.0001 0.00014209747314453
    SELECT * FROM pages WHERE id = '394'
    291 0.0001 0.00014090538024902
    SELECT * FROM pages WHERE id = '395'
    292 0.0002 0.00015115737915039
    SELECT * FROM pages WHERE id = '399'
    293 0.0001 0.00014996528625488
    SELECT * FROM pages WHERE id = '421'
    294 0.0001 0.00013494491577148
    SELECT * FROM pages WHERE id = '426'
    295 0.0001 0.00014686584472656
    SELECT * FROM pages WHERE id = '430'
    296 0.0001 0.00014305114746094
    SELECT * FROM pages WHERE id = '431'
    297 0.0002 0.0001521110534668
    SELECT * FROM pages WHERE id = '434'
    298 0.0002 0.0001530647277832
    SELECT * FROM pages WHERE id = '435'
    299 0.0002 0.00015807151794434
    SELECT * FROM pages WHERE id = '440'
    300 0.0002 0.0001521110534668
    SELECT * FROM pages WHERE id = '441'
    301 0.0002 0.0001528263092041
    SELECT * FROM pages WHERE id = '451'
    302 0.0001 0.00013995170593262
    SELECT * FROM pages WHERE id = '453'
    303 0.0001 0.00013494491577148
    SELECT * FROM sideboxes_pages WHERE sidebox_id = '37'
    304 0.0002 0.00016379356384277
    SELECT * FROM pages WHERE id = '146'
    305 0.0001 0.00014114379882812
    SELECT * FROM pages WHERE id = '158'
    306 0.0001 0.00013589859008789
    SELECT * FROM pages WHERE id = '163'
    307 0.0002 0.00023102760314941
    SELECT * FROM pages WHERE id = '293'
    308 0.0001 0.00014710426330566
    SELECT * FROM pages WHERE id = '340'
    309 0.0002 0.0001528263092041
    SELECT * FROM pages WHERE id = '417'
    310 0.0001 0.0001370906829834
    SELECT * FROM sideboxes_pages WHERE sidebox_id = '40'
    311 0.0002 0.00016117095947266
    SELECT * FROM pages WHERE id = '173'
    312 0.0002 0.00016188621520996
    SELECT * FROM pages WHERE id = '181'
    313 0.0001 0.00014209747314453
    SELECT * FROM pages WHERE id = '288'
    314 0.0002 0.00015115737915039
    SELECT * FROM pages WHERE id = '299'
    315 0.0001 0.00014495849609375
    SELECT * FROM pages WHERE id = '300'
    316 0.0002 0.0001528263092041
    SELECT * FROM pages WHERE id = '383'
    317 0.0001 0.0001368522644043
    SELECT * FROM pages WHERE id = '385'
    318 0.0002 0.00015401840209961
    SELECT * FROM pages WHERE id = '438'
    319 0.0002 0.00015711784362793
    SELECT * FROM pages WHERE id = '442'
    320 0.0001 0.00013613700866699
    SELECT * FROM sideboxes_pages WHERE sidebox_id = '38'
    321 0.0002 0.00024008750915527
    SELECT * FROM pages WHERE id = '103'
    322 0.0002 0.00021696090698242
    SELECT * FROM pages WHERE id = '134'
    323 0.0001 0.00014495849609375
    SELECT * FROM pages WHERE id = '139'
    324 0.0002 0.0001521110534668
    SELECT * FROM pages WHERE id = '143'
    325 0.0002 0.0001530647277832
    SELECT * FROM pages WHERE id = '234'
    326 0.0002 0.0001530647277832
    SELECT * FROM pages WHERE id = '248'
    327 0.0001 0.00014185905456543
    SELECT * FROM pages WHERE id = '260'
    328 0.0002 0.00016093254089355
    SELECT * FROM pages WHERE id = '398'
    329 0.0002 0.0001521110534668
    SELECT * FROM sideboxes_pages WHERE sidebox_id = '29'
    330 0.0002 0.00016999244689941
    SELECT * FROM pages WHERE id = '61'
    331 0.0002 0.00015401840209961
    SELECT * FROM pages WHERE id = '87'
    332 0.0002 0.00015497207641602
    SELECT * FROM pages WHERE id = '104'
    333 0.0002 0.00021195411682129
    SELECT * FROM pages WHERE id = '115'
    334 0.0001 0.00014400482177734
    SELECT * FROM pages WHERE id = '124'
    335 0.0001 0.00014996528625488
    SELECT * FROM pages WHERE id = '144'
    336 0.0002 0.00016689300537109
    SELECT * FROM pages WHERE id = '151'
    337 0.0001 0.0001370906829834
    SELECT * FROM pages WHERE id = '199'
    338 0.0001 0.00014710426330566
    SELECT * FROM pages WHERE id = '200'
    339 0.0001 0.00014901161193848
    SELECT * FROM pages WHERE id = '304'
    340 0.0001 0.0001380443572998
    SELECT * FROM pages WHERE id = '321'
    341 0.0001 0.00014090538024902
    SELECT * FROM pages WHERE id = '333'
    342 0.0002 0.00016403198242188
    SELECT * FROM pages WHERE id = '350'
    343 0.0001 0.00013899803161621
    SELECT * FROM pages WHERE id = '378'
    344 0.0002 0.00015115737915039
    SELECT * FROM pages WHERE id = '422'
    345 0.0002 0.00017285346984863
    SELECT * FROM pages WHERE id = '425'
    346 0.0001 0.00014114379882812
    SELECT * FROM pages WHERE id = '443'
    347 0.0001 0.00014209747314453
    SELECT * FROM pages WHERE id = '444'
    348 0.0001 0.00013899803161621
    SELECT * FROM pages WHERE id = '445'
    349 0.0001 0.00014805793762207
    SELECT * FROM pages WHERE id = '446'
    350 0.0002 0.00015115737915039
    SELECT * FROM pages WHERE id = '447'
    351 0.0001 0.00014400482177734
    SELECT * FROM pages WHERE id = '448'
    352 0.0001 0.00014400482177734
    SELECT * FROM pages WHERE id = '455'
    353 0.0001 0.00014996528625488
    SELECT * FROM pages WHERE id = '456'
    354 0.0001 0.00013613700866699
    SELECT * FROM pages WHERE id = '459'
    355 0.0001 0.00014996528625488
    SELECT * FROM pages WHERE id = '460'
    356 0.0002 0.00015401840209961
    SELECT * FROM pages WHERE id = '462'
    357 0.0001 0.00013899803161621
    SELECT * FROM sideboxes_pages WHERE sidebox_id = '32'
    358 0.0002 0.00016593933105469
    SELECT * FROM pages WHERE id = '153'
    359 0.0002 0.00019288063049316
    SELECT * FROM pages WHERE id = '182'
    360 0.0001 0.00014591217041016
    SELECT * FROM pages WHERE id = '238'
    361 0.0001 0.00014901161193848
    SELECT * FROM pages WHERE id = '240'
    362 0.0001 0.00013613700866699
    SELECT * FROM pages WHERE id = '242'
    363 0.0001 0.00013399124145508
    SELECT * FROM pages WHERE id = '252'
    364 0.0001 0.00013303756713867
    SELECT * FROM pages WHERE id = '253'
    365 0.0001 0.00013589859008789
    SELECT * FROM pages WHERE id = '262'
    366 0.0001 0.00013399124145508
    SELECT * FROM pages WHERE id = '267'
    367 0.0001 0.00014400482177734
    SELECT * FROM pages WHERE id = '420'
    368 0.0001 0.00012993812561035
    SELECT value FROM parameters WHERE parameter = 'GOOGLE_SITE_KEY' 
    369 0.0001 0.00011610984802246
    SELECT value FROM parameters WHERE parameter = 'GOOGLE_SECRET_KEY' 
    370 0.0001 0.00011587142944336
    SELECT value FROM parameters WHERE parameter = 'GOOGLE_RECAPTCHA_TYPE' 
    371 0.0014 0.0013539791107178
    SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
    372 0.0002 0.00017189979553223
    SELECT value FROM parameters WHERE parameter = 'GOOGLE_SITE_KEY' 
    373 0.0001 0.00011706352233887
    SELECT value FROM parameters WHERE parameter = 'GOOGLE_SECRET_KEY' 
    374 0.0001 0.00011491775512695
    SELECT value FROM parameters WHERE parameter = 'GOOGLE_RECAPTCHA_TYPE' 
    375 0.0003 0.00027894973754883
    SELECT * FROM products WHERE pagename = 'bushnell-elite-15-45x-60mm-roof-prism-pc-3-waterprooffogproof-spotting-scope'
    376 0.0002 0.00020503997802734
    SELECT * FROM manufacturers WHERE id = '344'
    377 0.0010 0.0010480880737305
    SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '344'
    378 0.0001 0.00013399124145508
    SELECT filename FROM manufacturerimages WHERE manufacturer_id = '344' LIMIT 1
    379 0.0010 0.00095105171203613
    SELECT pagename, id FROM products p WHERE manufacturer_id = '344' ORDER BY RAND() LIMIT 1
    380 0.0002 0.00022602081298828
    SELECT * FROM productimages WHERE product_id = '408384' ORDER BY sortorder ASC
    381 0.0009 0.00092601776123047
    SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '344'
    382 0.0010 0.00098705291748047
    SELECT COUNT(DISTINCT(p.id)) FROM products p
    				WHERE p.manufacturer_id = '344'
    				  AND p.hidden = 0
    				  AND p.enabled = 1
    				  AND p.parent_id = 0 
    383 0.0001 0.00012588500976562
    SELECT * FROM manufacturerimages WHERE manufacturer_id = '344'
    384 0.0001 0.00013089179992676
    SELECT category_id FROM products_categories WHERE product_id = '28477'
    385 0.0002 0.00018215179443359
    SELECT * FROM categories WHERE id = '32'
    386 0.0016 0.0016179084777832
    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
    387 0.0001 0.00011992454528809
    SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 32
    388 0.0003 0.0002589225769043
    SELECT id FROM categories WHERE parent_id = '32'
    389 0.0016 0.001594066619873
    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 
    390 0.0001 0.00014996528625488
    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 
    391 0.0002 0.00015020370483398
    SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
    				WHERE ep.id = c.product_id
    				  AND c.category_id IN (32)
    				  AND c.prod_type = 'ebay'
    				  AND ep.hide = 1 
    392 0.0002 0.00016188621520996
    SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '32'
    393 0.0003 0.00031280517578125
    SELECT * FROM productimages WHERE product_id = '28477' ORDER BY sortorder ASC
    394 0.0002 0.00021791458129883
    SELECT * FROM product_image_select WHERE product_id = '28477'
    395 0.0001 0.0001220703125
    SELECT * FROM productcustomimages WHERE product_id = '28477'
    396 0.0001 0.00011110305786133
    SELECT * FROM productfeeds WHERE product_id = '28477' ORDER BY item_date DESC
    397 0.0003 0.00033807754516602
    SELECT a.name, n.displayname, a.value, n.units, n.valuetype FROM productattributes a, productattributenames n WHERE product_id = '28477' AND a.name = n.originalname AND n.display = 1 AND n.hidden = 0
    398 0.0004 0.00042200088500977
    SELECT DISTINCT(pt.tag_id) FROM product_tags pt, tags t WHERE pt.tag_id = t.id AND pt.product_id = '28477' AND t.hidden = 0 AND display_product = 1
    399 0.0001 0.00013995170593262
    SELECT * FROM tags WHERE id = '676'
    400 0.0006 0.00058102607727051
    SELECT COUNT(DISTINCT(p.id)) FROM products p, product_tags t
    				WHERE p.id = t.product_id
    				  AND t.tag_id = '676'
    				  AND p.parent_id = 0
    				  AND p.enabled = 1
    				  AND p.hidden = 0
    401 0.0006 0.00055885314941406
    SELECT COUNT(DISTINCT(p.id)) FROM products p, product_tags t
    				WHERE p.id = t.product_id
    				  AND t.tag_id = '676'
    				  AND p.parent_id = 0
    				  AND hidden = 0
    				  AND enabled = 1 
    402 0.0006 0.00060796737670898
    SELECT p.id FROM products p, product_tags t WHERE p.id = t.product_id AND t.tag_id = '676' AND p.hidden = 0 AND p.salesrank > 0 AND (p.price > 0 OR p.parent = 1) ORDER BY p.salesrank ASC LIMIT 1
    403 0.0002 0.00021791458129883
    SELECT * FROM productimages WHERE product_id = '152022' ORDER BY sortorder ASC
    404 0.0001 0.0001370906829834
    SELECT * FROM tags WHERE id = '708'
    405 0.0006 0.00059390068054199
    SELECT COUNT(DISTINCT(p.id)) FROM products p, product_tags t
    				WHERE p.id = t.product_id
    				  AND t.tag_id = '708'
    				  AND p.parent_id = 0
    				  AND p.enabled = 1
    				  AND p.hidden = 0
    406 0.0006 0.00056982040405273
    SELECT COUNT(DISTINCT(p.id)) FROM products p, product_tags t
    				WHERE p.id = t.product_id
    				  AND t.tag_id = '708'
    				  AND p.parent_id = 0
    				  AND hidden = 0
    				  AND enabled = 1 
    407 0.0006 0.00059103965759277
    SELECT p.id FROM products p, product_tags t WHERE p.id = t.product_id AND t.tag_id = '708' AND p.hidden = 0 AND p.salesrank > 0 AND (p.price > 0 OR p.parent = 1) ORDER BY p.salesrank ASC LIMIT 1
    408 0.0003 0.00025391578674316
    SELECT * FROM productimages WHERE product_id = '41748' ORDER BY sortorder ASC
    409 0.0001 0.00013995170593262
    SELECT * FROM tags WHERE id = '2972'
    410 0.0027 0.0026590824127197
    SELECT COUNT(DISTINCT(p.id)) FROM products p, product_tags t
    				WHERE p.id = t.product_id
    				  AND t.tag_id = '2972'
    				  AND p.parent_id = 0
    				  AND p.enabled = 1
    				  AND p.hidden = 0
    411 0.0026 0.0025529861450195
    SELECT COUNT(DISTINCT(p.id)) FROM products p, product_tags t
    				WHERE p.id = t.product_id
    				  AND t.tag_id = '2972'
    				  AND p.parent_id = 0
    				  AND hidden = 0
    				  AND enabled = 1 
    412 0.0026 0.0025811195373535
    SELECT p.id FROM products p, product_tags t WHERE p.id = t.product_id AND t.tag_id = '2972' AND p.hidden = 0 AND p.salesrank > 0 AND (p.price > 0 OR p.parent = 1) ORDER BY p.salesrank ASC LIMIT 1
    413 0.0004 0.00039100646972656
    SELECT * FROM productimages WHERE product_id = '79386' ORDER BY sortorder ASC
    414 0.0567 0.056720972061157
    SELECT * FROM productamazoncontent WHERE product_id = '28477'
    415 0.0020 0.0020370483398438
    SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '28477' AND a.name = n.originalname
    416 0.0002 0.00019001960754395
    SELECT * FROM productoffers WHERE product_id = '28477' AND merchantid = 'ATVPDKIKX0DER'
    417 0.0002 0.00020694732666016
    SELECT * FROM productoffers
                    WHERE product_id = '28477' AND price > 0
                    ORDER BY price ASC LIMIT 1
    418 0.0003 0.00034785270690918
    SELECT value FROM productattributes WHERE product_id = '28477' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
    419 0.0001 0.00013184547424316
    UPDATE products SET price = '47724' WHERE id = '28477'
    420 0.2366 0.23660707473755
    SELECT *, MATCH (description, keyfeatures, title) AGAINST ('bushnell' IN BOOLEAN MODE) AS `searchrelevance` FROM products WHERE MATCH (description, keyfeatures, title) AGAINST ('bushnell' IN BOOLEAN MODE) AND 28477 <> 0 AND enabled = 1 AND hidden = 0 AND offers > 0 AND parent_id = 0 ORDER BY `searchrelevance` LIMIT 6
    421 0.0004 0.00040411949157715
    SELECT * FROM productimages WHERE product_id = '28477' ORDER BY sortorder ASC
    422 0.0003 0.00029206275939941
    SELECT * FROM product_image_select WHERE product_id = '28477'
    423 0.0002 0.00015401840209961
    SELECT * FROM productcustomimages WHERE product_id = '28477'
    424 0.0020 0.0020058155059814
    SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '28477' AND a.name = n.originalname
    425 0.0002 0.00018811225891113
    SELECT * FROM productoffers WHERE product_id = '28477' AND merchantid = 'ATVPDKIKX0DER'
    426 0.0002 0.00020503997802734
    SELECT * FROM productoffers
                    WHERE product_id = '28477' AND price > 0
                    ORDER BY price ASC LIMIT 1
    427 0.0004 0.00035309791564941
    SELECT value FROM productattributes WHERE product_id = '28477' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
    428 0.0001 0.00013494491577148
    UPDATE products SET price = '47724' WHERE id = '28477'
    429 0.0002 0.00021886825561523
    SELECT * FROM productimages WHERE product_id = '131163' ORDER BY sortorder ASC
    430 0.0002 0.00020599365234375
    SELECT * FROM product_image_select WHERE product_id = '131163'
    431 0.0001 0.00011897087097168
    SELECT * FROM productcustomimages WHERE product_id = '131163'
    432 0.0026 0.0026068687438965
    SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '131163' AND a.name = n.originalname
    433 0.0002 0.00019192695617676
    SELECT * FROM productoffers WHERE product_id = '131163' AND merchantid = 'ATVPDKIKX0DER'
    434 0.0002 0.00022101402282715
    SELECT * FROM productoffers
                    WHERE product_id = '131163' AND price > 0
                    ORDER BY price ASC LIMIT 1
    435 0.0004 0.00037884712219238
    SELECT value FROM productattributes WHERE product_id = '131163' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
    436 0.0001 0.00012016296386719
    UPDATE products SET price = '19489' WHERE id = '131163'
    437 0.0002 0.00019311904907227
    SELECT * FROM productimages WHERE product_id = '97394' ORDER BY sortorder ASC
    438 0.0003 0.00027298927307129
    SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '97394' AND p.id = pi.product_id ORDER BY pi.sortorder
    439 0.0002 0.00021100044250488
    SELECT * FROM product_image_select WHERE product_id = '97394'
    440 0.0001 0.00011897087097168
    SELECT * FROM productcustomimages WHERE product_id = '97394'
    441 0.0002 0.00024700164794922
    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 = '97394'
                    GROUP BY o.product_id
    442 0.0003 0.00030803680419922
    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     = '97394'
                    GROUP BY n.displayname
                    ORDER BY n.displayname DESC
    443 0.0002 0.00020909309387207
    SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 97394
    444 0.0024 0.0023751258850098
    SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '97394' AND a.name = n.originalname
    445 0.0002 0.00016999244689941
    SELECT * FROM productoffers WHERE product_id = '97394' AND merchantid = 'ATVPDKIKX0DER'
    446 0.0002 0.00018501281738281
    SELECT * FROM productoffers
                    WHERE product_id = '97394' AND price > 0
                    ORDER BY price ASC LIMIT 1
    447 0.0002 0.00015807151794434
    SELECT * FROM productoffers
                    WHERE product_id = 97394
                    ORDER BY price ASC LIMIT 1
    448 0.0002 0.00024700164794922
    SELECT value FROM productattributes
                    WHERE product_id = '97394'
                    AND name = 'ListPriceAmount'
    449 0.0002 0.00023484230041504
    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 = '97394'
                    GROUP BY o.product_id
    450 0.0003 0.00028300285339355
    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     = '97394'
                    GROUP BY n.displayname
                    ORDER BY n.displayname DESC
    451 0.0002 0.00020217895507812
    SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 97394
    452 0.0004 0.00037002563476562
    SELECT value FROM productattributes WHERE product_id = '97394' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
    453 0.0001 0.00012111663818359
    UPDATE products SET price = '17381' WHERE id = '97394'
    454 0.0003 0.00033998489379883
    SELECT  o.value
                    FROM    products            p,
                            productoptions      o
                    WHERE   p.parent_id     = '97394'
                      AND   p.id            = o.product_id
                      AND   o.name          = 'Color'
                    GROUP BY o.value
                    ORDER BY o.value ASC
    455 0.0002 0.00024199485778809
    SELECT * FROM productimages WHERE product_id = '179950' ORDER BY sortorder ASC
    456 0.0002 0.00021100044250488
    SELECT * FROM product_image_select WHERE product_id = '179950'
    457 0.0001 0.00011992454528809
    SELECT * FROM productcustomimages WHERE product_id = '179950'
    458 0.0026 0.0025558471679688
    SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '179950' AND a.name = n.originalname
    459 0.0002 0.00019001960754395
    SELECT * FROM productoffers WHERE product_id = '179950' AND merchantid = 'ATVPDKIKX0DER'
    460 0.0002 0.00021195411682129
    SELECT * FROM productoffers
                    WHERE product_id = '179950' AND price > 0
                    ORDER BY price ASC LIMIT 1
    461 0.0003 0.00033712387084961
    SELECT value FROM productattributes WHERE product_id = '179950' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
    462 0.0001 0.00011897087097168
    UPDATE products SET price = '97299' WHERE id = '179950'
    463 0.0002 0.00020194053649902
    SELECT * FROM productimages WHERE product_id = '143998' ORDER BY sortorder ASC
    464 0.0002 0.00020098686218262
    SELECT * FROM product_image_select WHERE product_id = '143998'
    465 0.0001 0.00011897087097168
    SELECT * FROM productcustomimages WHERE product_id = '143998'
    466 0.0028 0.0027778148651123
    SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '143998' AND a.name = n.originalname
    467 0.0002 0.00019311904907227
    SELECT * FROM productoffers WHERE product_id = '143998' AND merchantid = 'ATVPDKIKX0DER'
    468 0.0002 0.00020098686218262
    SELECT * FROM productoffers
                    WHERE product_id = '143998' AND price > 0
                    ORDER BY price ASC LIMIT 1
    469 0.0004 0.00039291381835938
    SELECT value FROM productattributes WHERE product_id = '143998' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
    470 0.0001 0.00011682510375977
    UPDATE products SET price = '7772' WHERE id = '143998'
    471 0.0003 0.00031113624572754
    SELECT * FROM productimages WHERE product_id = '401776' ORDER BY sortorder ASC
    472 0.0002 0.00020885467529297
    SELECT * FROM product_image_select WHERE product_id = '401776'
    473 0.0001 0.00013899803161621
    SELECT * FROM productcustomimages WHERE product_id = '401776'
    474 0.0030 0.0030179023742676
    SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '401776' AND a.name = n.originalname
    475 0.0002 0.00018715858459473
    SELECT * FROM productoffers WHERE product_id = '401776' AND merchantid = 'ATVPDKIKX0DER'
    476 0.0002 0.00020480155944824
    SELECT * FROM productoffers
                    WHERE product_id = '401776' AND price > 0
                    ORDER BY price ASC LIMIT 1
    477 0.0004 0.00040006637573242
    SELECT value FROM productattributes WHERE product_id = '401776' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
    478 0.0001 0.00012111663818359
    UPDATE products SET price = '91500' WHERE id = '401776'
    479 0.2558 0.25576710700989
    SELECT *, MATCH (description, keyfeatures, title) AGAINST ('scope' IN BOOLEAN MODE) AS `searchrelevance` FROM products WHERE MATCH (description, keyfeatures, title) AGAINST ('scope' IN BOOLEAN MODE) AND 28477 <> 0 AND enabled = 1 AND hidden = 0 AND offers > 0 AND parent_id = 0 ORDER BY `searchrelevance` LIMIT 1
    480 0.0005 0.00046610832214355
    SELECT * FROM productimages WHERE product_id = '192125' ORDER BY sortorder ASC
    481 0.0002 0.00022006034851074
    SELECT * FROM product_image_select WHERE product_id = '192125'
    482 0.0001 0.0001218318939209
    SELECT * FROM productcustomimages WHERE product_id = '192125'
    483 0.0023 0.0022621154785156
    SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '192125' AND a.name = n.originalname
    484 0.0002 0.00020313262939453
    SELECT * FROM productoffers WHERE product_id = '192125' AND merchantid = 'ATVPDKIKX0DER'
    485 0.0002 0.00020599365234375
    SELECT * FROM productoffers
                    WHERE product_id = '192125' AND price > 0
                    ORDER BY price ASC LIMIT 1
    486 0.0004 0.00036907196044922
    SELECT value FROM productattributes WHERE product_id = '192125' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
    487 0.0001 0.00013494491577148
    UPDATE products SET price = '44999' WHERE id = '192125'
    488 0.0001 0.00014185905456543
    SELECT value FROM parameters WHERE parameter = 'EBAY_CACHE_TIME' 
    489 0.0001 0.00011897087097168
    SELECT value FROM parameters WHERE parameter = 'EBAY_APP_ID' 
    490 0.0001 0.00011706352233887
    SELECT value FROM parameters WHERE parameter = 'EBAY_TRACKING_ID' 
    491 0.0001 0.00011515617370605
    SELECT value FROM parameters WHERE parameter = 'EBAY_NETWORK_ID' 
    492 0.0001 0.00011396408081055
    SELECT value FROM parameters WHERE parameter = 'EBAY_LOCALE' 
    493 0.0001 0.00011396408081055
    SELECT value FROM parameters WHERE parameter = 'EBAY_AUTH_TOKEN' 
    494 0.0001 0.00013208389282227
    SELECT * FROM ebay_locale_details WHERE cur_code = 'USD' 
    495 0.2044 0.20435094833374
    SELECT * FROM ebay_products_cache WHERE cachekey = 'eb5390f72ad86a50918757552f43b2d9' 
    496 0.0003 0.00025677680969238
    SELECT value FROM parameters WHERE parameter = 'EBAY_APP_ID' 
    497 0.0001 0.0001227855682373
    SELECT value FROM parameters WHERE parameter = 'EBAY_TRACKING_ID' 
    498 0.0001 0.00011897087097168
    SELECT value FROM parameters WHERE parameter = 'EBAY_NETWORK_ID' 
    499 0.0001 0.00012898445129395
    SELECT value FROM parameters WHERE parameter = 'EBAY_LOCALE' 
    500 0.0001 0.00011801719665527
    SELECT value FROM parameters WHERE parameter = 'EBAY_AUTH_TOKEN' 
    501 0.2028 0.20282602310181
    SELECT * FROM ebay_products_cache WHERE cachekey = 'eb5390f72ad86a50918757552f43b2d9' 
    502 0.0003 0.0002598762512207
    SELECT value FROM parameters WHERE parameter = 'EBAY_APP_ID' 
    503 0.0001 0.00012493133544922
    SELECT value FROM parameters WHERE parameter = 'EBAY_TRACKING_ID' 
    504 0.0001 0.00011992454528809
    SELECT value FROM parameters WHERE parameter = 'EBAY_NETWORK_ID' 
    505 0.0001 0.00012898445129395
    SELECT value FROM parameters WHERE parameter = 'EBAY_LOCALE' 
    506 0.0001 0.00011992454528809
    SELECT value FROM parameters WHERE parameter = 'EBAY_AUTH_TOKEN' 
    507 0.2044 0.20438003540039
    SELECT * FROM ebay_products_cache WHERE cachekey = 'eb5390f72ad86a50918757552f43b2d9' 
    508 0.0003 0.00025510787963867
    SELECT value FROM parameters WHERE parameter = 'EBAY_APP_ID' 
    509 0.0001 0.00012493133544922
    SELECT value FROM parameters WHERE parameter = 'EBAY_TRACKING_ID' 
    510 0.0001 0.00011897087097168
    SELECT value FROM parameters WHERE parameter = 'EBAY_NETWORK_ID' 
    511 0.0001 0.00011897087097168
    SELECT value FROM parameters WHERE parameter = 'EBAY_LOCALE' 
    512 0.0001 0.00011682510375977
    SELECT value FROM parameters WHERE parameter = 'EBAY_AUTH_TOKEN' 
    513 0.2039 0.20392394065857
    SELECT * FROM ebay_products_cache WHERE cachekey = 'eb5390f72ad86a50918757552f43b2d9' 
    514 0.0003 0.00025081634521484
    SELECT value FROM parameters WHERE parameter = 'EBAY_APP_ID' 
    515 0.0001 0.00012302398681641
    SELECT value FROM parameters WHERE parameter = 'EBAY_TRACKING_ID' 
    516 0.0001 0.00012302398681641
    SELECT value FROM parameters WHERE parameter = 'EBAY_NETWORK_ID' 
    517 0.0001 0.00011897087097168
    SELECT value FROM parameters WHERE parameter = 'EBAY_LOCALE' 
    518 0.0001 0.00011706352233887
    SELECT value FROM parameters WHERE parameter = 'EBAY_AUTH_TOKEN' 
    519 0.2035 0.20351004600525
    SELECT * FROM ebay_products_cache WHERE cachekey = 'eb5390f72ad86a50918757552f43b2d9' 
    520 0.0003 0.00025296211242676
    SELECT value FROM parameters WHERE parameter = 'EBAY_APP_ID' 
    521 0.0001 0.00012302398681641
    SELECT value FROM parameters WHERE parameter = 'EBAY_TRACKING_ID' 
    522 0.0001 0.00011992454528809
    SELECT value FROM parameters WHERE parameter = 'EBAY_NETWORK_ID' 
    523 0.0001 0.00011801719665527
    SELECT value FROM parameters WHERE parameter = 'EBAY_LOCALE' 
    524 0.0001 0.00012803077697754
    SELECT value FROM parameters WHERE parameter = 'EBAY_AUTH_TOKEN' 
    525 0.2037 0.20366597175598
    SELECT * FROM ebay_products_cache WHERE cachekey = 'eb5390f72ad86a50918757552f43b2d9' 
    526 0.0002 0.00024890899658203
    SELECT value FROM parameters WHERE parameter = 'EBAY_APP_ID' 
    527 0.0001 0.0001220703125
    SELECT value FROM parameters WHERE parameter = 'EBAY_TRACKING_ID' 
    528 0.0001 0.00011801719665527
    SELECT value FROM parameters WHERE parameter = 'EBAY_NETWORK_ID' 
    529 0.0001 0.00011706352233887
    SELECT value FROM parameters WHERE parameter = 'EBAY_LOCALE' 
    530 0.0001 0.00011801719665527
    SELECT value FROM parameters WHERE parameter = 'EBAY_AUTH_TOKEN' 
    531 0.2044 0.20439720153809
    SELECT * FROM ebay_products_cache WHERE cachekey = 'eb5390f72ad86a50918757552f43b2d9' 
    532 0.0003 0.00026392936706543
    SELECT value FROM parameters WHERE parameter = 'EBAY_APP_ID' 
    533 0.0001 0.00012493133544922
    SELECT value FROM parameters WHERE parameter = 'EBAY_TRACKING_ID' 
    534 0.0001 0.00011897087097168
    SELECT value FROM parameters WHERE parameter = 'EBAY_NETWORK_ID' 
    535 0.0001 0.00011706352233887
    SELECT value FROM parameters WHERE parameter = 'EBAY_LOCALE' 
    536 0.0001 0.00011587142944336
    SELECT value FROM parameters WHERE parameter = 'EBAY_AUTH_TOKEN' 
    537 0.2043 0.20426917076111
    SELECT * FROM ebay_products_cache WHERE cachekey = 'eb5390f72ad86a50918757552f43b2d9' 
    538 0.0003 0.00025796890258789
    SELECT value FROM parameters WHERE parameter = 'EBAY_APP_ID' 
    539 0.0001 0.00012302398681641
    SELECT value FROM parameters WHERE parameter = 'EBAY_TRACKING_ID' 
    540 0.0001 0.00011897087097168
    SELECT value FROM parameters WHERE parameter = 'EBAY_NETWORK_ID' 
    541 0.0001 0.00012803077697754
    SELECT value FROM parameters WHERE parameter = 'EBAY_LOCALE' 
    542 0.0001 0.00011706352233887
    SELECT value FROM parameters WHERE parameter = 'EBAY_AUTH_TOKEN' 
    543 0.2052 0.20522904396057
    SELECT * FROM ebay_products_cache WHERE cachekey = 'eb5390f72ad86a50918757552f43b2d9' 
    544 0.0003 0.00025415420532227
    SELECT value FROM parameters WHERE parameter = 'EBAY_APP_ID' 
    545 0.0001 0.00013494491577148
    SELECT value FROM parameters WHERE parameter = 'EBAY_TRACKING_ID' 
    546 0.0001 0.00012111663818359
    SELECT value FROM parameters WHERE parameter = 'EBAY_NETWORK_ID' 
    547 0.0001 0.00011706352233887
    SELECT value FROM parameters WHERE parameter = 'EBAY_LOCALE' 
    548 0.0001 0.00011610984802246
    SELECT value FROM parameters WHERE parameter = 'EBAY_AUTH_TOKEN' 
    549 0.2046 0.20459985733032
    SELECT * FROM ebay_products_cache WHERE cachekey = 'eb5390f72ad86a50918757552f43b2d9' 
    550 0.0003 0.00032401084899902
    UPDATE ebay_products_cache SET products = 'a:2:{i:0;a:13:{s:6:\"itemId\";s:12:\"123710241567\";s:11:\"viewItemURL\";s:138:\"https://rover.ebay.com/rover/1/711-53200-19255-0/1?ff3=2&toolid=10041&campid=5338345274&customid=&lgeo=1&vectorid=229466&item=123710241567\";s:10:\"galleryURL\";s:58:\"//thumbs4.ebaystatic.com/m/mLdPmIPnHKMwdMc3k8hlstg/140.jpg\";s:5:\"title\";s:80:\"bushnell  ..ELITE......15-45  X  60 mm  zoom    spotting scope.... MADE IN JAPAN\";s:11:\"listingType\";s:14:\"StoreInventory\";s:20:\"conditionDisplayName\";s:4:\"Used\";s:8:\"timeLeft\";s:12:\"P3DT6H11M49S\";s:15:\"returnsAccepted\";s:4:\"true\";s:19:\"originalRetailPrice\";i:0;s:12:\"currentPrice\";s:6:\"299.00\";s:15:\"shipToLocations\";s:9:\"Worldwide\";s:12:\"handlingTime\";s:1:\"1\";s:10:\"variations\";s:5:\"false\";}i:1;s:215:\"https://rover.ebay.com/rover/1/711-53200-19255-0/1?ff3=4&toolid=10041&campid=5338345274&customid=&lgeo=1&mpre=http%3A%2F%2Fwww.ebay.com%2Fsch%2Fi.html%3F_nkw%3DBushnell%2BElite%2B15-45x%2B60mm%26_ipg%3D10%26_pgn%3D1\";}', expiretime = '1563781698' WHERE id = '65433'
    551 0.0002 0.00018000602722168
    SELECT id,asin FROM products WHERE parent_id = 28477
    552 0.0003 0.0003359317779541
    SELECT * FROM customerreviews WHERE approved = 1 AND productid = '28477' ORDER BY timestamp DESC
    553 0.0001 0.00013995170593262
    SELECT category_id FROM products_categories WHERE product_id = '28477'
    554 0.0002 0.00020194053649902
    SELECT * FROM categories WHERE id = '32'
    555 0.0017 0.0016841888427734
    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
    556 0.0001 0.00012397766113281
    SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 32
    557 0.0003 0.00025391578674316
    SELECT id FROM categories WHERE parent_id = '32'
    558 0.0016 0.0015981197357178
    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 
    559 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 (32)
    				  AND p.disabled = 0 
    560 0.0001 0.00014996528625488
    SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
    				WHERE ep.id = c.product_id
    				  AND c.category_id IN (32)
    				  AND c.prod_type = 'ebay'
    				  AND ep.hide = 1 
    561 0.0002 0.00016307830810547
    SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '32'
    562 0.0020 0.0019938945770264
    SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '28477' AND a.name = n.originalname
    563 0.0002 0.00020194053649902
    SELECT * FROM productoffers WHERE product_id = '28477' AND merchantid = 'ATVPDKIKX0DER'
    564 0.0002 0.00020909309387207
    SELECT * FROM productoffers
                    WHERE product_id = '28477' AND price > 0
                    ORDER BY price ASC LIMIT 1
    565 0.0002 0.00020289421081543
    SELECT * FROM products WHERE id = '28477'
    566 0.0003 0.00033402442932129
    SELECT value FROM productattributes WHERE product_id = '28477' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
    567 0.0001 0.00013184547424316
    UPDATE products SET price = '47724' WHERE id = '28477'
    568 0.0019 0.0019450187683105
    SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '28477' AND a.name = n.originalname
    569 0.0002 0.00018000602722168
    SELECT * FROM productoffers WHERE product_id = '28477' AND merchantid = 'ATVPDKIKX0DER'
    570 0.0002 0.00019383430480957
    SELECT * FROM productoffers
                    WHERE product_id = '28477' AND price > 0
                    ORDER BY price ASC LIMIT 1
    571 0.0001 0.00013422966003418
    SELECT category_id FROM products_categories WHERE product_id = '28477'
    572 0.0001 0.00011491775512695
    SELECT parent_id FROM categories WHERE id = '32'
    573 0.0002 0.00016593933105469
    SELECT * FROM categories WHERE id = '32'
    574 0.0015 0.001539945602417
    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
    575 0.0001 0.00011706352233887
    SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 32
    576 0.0002 0.00023198127746582
    SELECT id FROM categories WHERE parent_id = '32'
    577 0.0016 0.0016031265258789
    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 
    578 0.0002 0.0001521110534668
    SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
    				WHERE p.id = c.bundle_id
    				  AND c.category_id IN (32)
    				  AND p.disabled = 0 
    579 0.0001 0.00014400482177734
    SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
    				WHERE ep.id = c.product_id
    				  AND c.category_id IN (32)
    				  AND c.prod_type = 'ebay'
    				  AND ep.hide = 1 
    580 0.0002 0.00016999244689941
    SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '32'
    581 0.0002 0.00016903877258301
    SELECT * FROM template_info WHERE templateuid = 'fsb-fluid'
    582 0.0002 0.00015401840209961
    SELECT * FROM pages WHERE id = 2
    583 0.0001 0.00014996528625488
    SELECT * FROM pages WHERE id = 4
    584 0.0001 0.0001380443572998
    SELECT * FROM pages WHERE id = 12
    585 0.0001 0.0001368522644043
    SELECT * FROM pages WHERE id = 10
    586 0.0001 0.00013518333435059
    SELECT * FROM pages WHERE id = 7
    587 0.0001 0.0001380443572998
    SELECT * FROM pages WHERE id = 18
    588 0.0001 0.00013613700866699
    SELECT * FROM pages WHERE id = 28
    589 0.0001 0.00014996528625488
    SELECT * FROM pages WHERE id = 13
    590 0.0001 0.00013279914855957
    SELECT * FROM pages WHERE id = 3
    591 0.0444 0.044381141662598
    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
    592 0.0003 0.00027608871459961
    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:1563781703;s:8:\"products\";a:6:{i:0;s:6:\"414940\";i:2;s:6:\"398858\";i:4;s:6:\"415083\";i:6;s:6:\"185812\";i:10;s:6:\"409759\";i:12;s:6:\"402983\";}}' WHERE id = '175'
    593 0.0007 0.00072813034057617
    SELECT * FROM products WHERE id IN (414940,398858,415083,185812,409759,402983) ORDER BY FIELD(id, 414940,398858,415083,185812,409759,402983 )
    594 0.0002 0.00020503997802734
    SELECT * FROM productimages WHERE product_id = '414940' ORDER BY sortorder ASC
    595 0.0002 0.00020813941955566
    SELECT * FROM product_image_select WHERE product_id = '414940'
    596 0.0001 0.0001218318939209
    SELECT * FROM productcustomimages WHERE product_id = '414940'
    597 0.0033 0.0033199787139893
    SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '414940' AND a.name = n.originalname
    598 0.0002 0.00018405914306641
    SELECT * FROM productoffers WHERE product_id = '414940' AND merchantid = 'ATVPDKIKX0DER'
    599 0.0002 0.00020408630371094
    SELECT * FROM productoffers
                    WHERE product_id = '414940' AND price > 0
                    ORDER BY price ASC LIMIT 1
    600 0.0004 0.00042891502380371
    SELECT value FROM productattributes WHERE product_id = '414940' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
    601 0.0001 0.00011897087097168
    UPDATE products SET price = '4490' WHERE id = '414940'
    602 0.0002 0.00019693374633789
    SELECT * FROM productimages WHERE product_id = '398858' ORDER BY sortorder ASC
    603 0.0002 0.00022315979003906
    SELECT * FROM product_image_select WHERE product_id = '398858'
    604 0.0001 0.00011897087097168
    SELECT * FROM productcustomimages WHERE product_id = '398858'
    605 0.0031 0.003087043762207
    SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '398858' AND a.name = n.originalname
    606 0.0002 0.00018405914306641
    SELECT * FROM productoffers WHERE product_id = '398858' AND merchantid = 'ATVPDKIKX0DER'
    607 0.0002 0.00024986267089844
    SELECT * FROM productoffers
                    WHERE product_id = '398858' AND price > 0
                    ORDER BY price ASC LIMIT 1
    608 0.0004 0.00043177604675293
    SELECT value FROM productattributes WHERE product_id = '398858' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
    609 0.0001 0.00012087821960449
    UPDATE products SET price = '2999' WHERE id = '398858'
    610 0.0002 0.00016999244689941
    SELECT * FROM productimages WHERE product_id = '415083' ORDER BY sortorder ASC
    611 0.0002 0.00021815299987793
    SELECT * FROM product_image_select WHERE product_id = '415083'
    612 0.0001 0.00011920928955078
    SELECT * FROM productcustomimages WHERE product_id = '415083'
    613 0.0036 0.0035638809204102
    SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '415083' AND a.name = n.originalname
    614 0.0002 0.00019121170043945
    SELECT * FROM productoffers WHERE product_id = '415083' AND merchantid = 'ATVPDKIKX0DER'
    615 0.0002 0.00020313262939453
    SELECT * FROM productoffers
                    WHERE product_id = '415083' AND price > 0
                    ORDER BY price ASC LIMIT 1
    616 0.0004 0.00042891502380371
    SELECT value FROM productattributes WHERE product_id = '415083' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
    617 0.0002 0.00024199485778809
    UPDATE products SET price = '2299' WHERE id = '415083'
    618 0.0007 0.00067687034606934
    SELECT * FROM productimages WHERE product_id = '185812' ORDER BY sortorder ASC
    619 0.0002 0.00023007392883301
    SELECT * FROM product_image_select WHERE product_id = '185812'
    620 0.0001 0.0001218318939209
    SELECT * FROM productcustomimages WHERE product_id = '185812'
    621 0.0021 0.0021069049835205
    SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '185812' AND a.name = n.originalname
    622 0.0002 0.00018501281738281
    SELECT * FROM productoffers WHERE product_id = '185812' AND merchantid = 'ATVPDKIKX0DER'
    623 0.0002 0.00020599365234375
    SELECT * FROM productoffers
                    WHERE product_id = '185812' AND price > 0
                    ORDER BY price ASC LIMIT 1
    624 0.0004 0.00036406517028809
    SELECT value FROM productattributes WHERE product_id = '185812' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
    625 0.0001 0.00011897087097168
    UPDATE products SET price = '314900' WHERE id = '185812'
    626 0.0002 0.00020503997802734
    SELECT * FROM productimages WHERE product_id = '409759' ORDER BY sortorder ASC
    627 0.0002 0.00019979476928711
    SELECT * FROM product_image_select WHERE product_id = '409759'
    628 0.0001 0.00012803077697754
    SELECT * FROM productcustomimages WHERE product_id = '409759'
    629 0.0028 0.0027890205383301
    SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '409759' AND a.name = n.originalname
    630 0.0002 0.00018978118896484
    SELECT * FROM productoffers WHERE product_id = '409759' AND merchantid = 'ATVPDKIKX0DER'
    631 0.0002 0.0001981258392334
    SELECT * FROM productoffers
                    WHERE product_id = '409759' AND price > 0
                    ORDER BY price ASC LIMIT 1
    632 0.0004 0.00039005279541016
    SELECT value FROM productattributes WHERE product_id = '409759' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
    633 0.0001 0.00011801719665527
    UPDATE products SET price = '229000' WHERE id = '409759'
    634 0.0002 0.00020098686218262
    SELECT * FROM productimages WHERE product_id = '402983' ORDER BY sortorder ASC
    635 0.0002 0.00020194053649902
    SELECT * FROM product_image_select WHERE product_id = '402983'
    636 0.0001 0.00011801719665527
    SELECT * FROM productcustomimages WHERE product_id = '402983'
    637 0.0022 0.0022180080413818
    SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '402983' AND a.name = n.originalname
    638 0.0002 0.00018095970153809
    SELECT * FROM productoffers WHERE product_id = '402983' AND merchantid = 'ATVPDKIKX0DER'
    639 0.0002 0.00020813941955566
    SELECT * FROM productoffers
                    WHERE product_id = '402983' AND price > 0
                    ORDER BY price ASC LIMIT 1
    640 0.0003 0.00034308433532715
    SELECT value FROM productattributes WHERE product_id = '402983' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
    641 0.0001 0.00011897087097168
    UPDATE products SET price = '10396' WHERE id = '402983'
    642 0.0440 0.044014930725098
    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
    643 0.0003 0.00025606155395508
    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:1563781703;s:8:\"products\";a:6:{i:2;s:6:\"398858\";i:10;s:6:\"409759\";i:12;s:6:\"402983\";i:21;s:6:\"147874\";i:4;s:6:\"415083\";i:6;s:6:\"185812\";}}' WHERE id = '177'
    644 0.0007 0.00072002410888672
    SELECT * FROM products WHERE id IN (398858,409759,402983,147874,415083,185812) ORDER BY FIELD(id, 398858,409759,402983,147874,415083,185812 )
    645 0.0002 0.0002140998840332
    SELECT * FROM productimages WHERE product_id = '398858' ORDER BY sortorder ASC
    646 0.0002 0.00020909309387207
    SELECT * FROM product_image_select WHERE product_id = '398858'
    647 0.0001 0.00012087821960449
    SELECT * FROM productcustomimages WHERE product_id = '398858'
    648 0.0031 0.0031020641326904
    SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '398858' AND a.name = n.originalname
    649 0.0002 0.0001838207244873
    SELECT * FROM productoffers WHERE product_id = '398858' AND merchantid = 'ATVPDKIKX0DER'
    650 0.0002 0.00021719932556152
    SELECT * FROM productoffers
                    WHERE product_id = '398858' AND price > 0
                    ORDER BY price ASC LIMIT 1
    651 0.0004 0.0004119873046875
    SELECT value FROM productattributes WHERE product_id = '398858' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
    652 0.0001 0.00011801719665527
    UPDATE products SET price = '2999' WHERE id = '398858'
    653 0.0002 0.00020599365234375
    SELECT * FROM productimages WHERE product_id = '409759' ORDER BY sortorder ASC
    654 0.0002 0.00021100044250488
    SELECT * FROM product_image_select WHERE product_id = '409759'
    655 0.0001 0.00011992454528809
    SELECT * FROM productcustomimages WHERE product_id = '409759'
    656 0.0028 0.0028269290924072
    SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '409759' AND a.name = n.originalname
    657 0.0002 0.00018191337585449
    SELECT * FROM productoffers WHERE product_id = '409759' AND merchantid = 'ATVPDKIKX0DER'
    658 0.0002 0.00020098686218262
    SELECT * FROM productoffers
                    WHERE product_id = '409759' AND price > 0
                    ORDER BY price ASC LIMIT 1
    659 0.0004 0.00040411949157715
    SELECT value FROM productattributes WHERE product_id = '409759' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
    660 0.0001 0.00011992454528809
    UPDATE products SET price = '229000' WHERE id = '409759'
    661 0.0002 0.00019001960754395
    SELECT * FROM productimages WHERE product_id = '402983' ORDER BY sortorder ASC
    662 0.0002 0.00020194053649902
    SELECT * FROM product_image_select WHERE product_id = '402983'
    663 0.0001 0.00011706352233887
    SELECT * FROM productcustomimages WHERE product_id = '402983'
    664 0.0022 0.0022218227386475
    SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '402983' AND a.name = n.originalname
    665 0.0002 0.00018501281738281
    SELECT * FROM productoffers WHERE product_id = '402983' AND merchantid = 'ATVPDKIKX0DER'
    666 0.0002 0.00020003318786621
    SELECT * FROM productoffers
                    WHERE product_id = '402983' AND price > 0
                    ORDER BY price ASC LIMIT 1
    667 0.0003 0.00034213066101074
    SELECT value FROM productattributes WHERE product_id = '402983' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
    668 0.0001 0.00011801719665527
    UPDATE products SET price = '10396' WHERE id = '402983'
    669 0.0002 0.00019621849060059
    SELECT * FROM productimages WHERE product_id = '147874' ORDER BY sortorder ASC
    670 0.0002 0.00020694732666016
    SELECT * FROM product_image_select WHERE product_id = '147874'
    671 0.0001 0.00011801719665527
    SELECT * FROM productcustomimages WHERE product_id = '147874'
    672 0.0029 0.0028541088104248
    SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '147874' AND a.name = n.originalname
    673 0.0002 0.00017881393432617
    SELECT * FROM productoffers WHERE product_id = '147874' AND merchantid = 'ATVPDKIKX0DER'
    674 0.0002 0.00019097328186035
    SELECT * FROM productoffers
                    WHERE product_id = '147874' AND price > 0
                    ORDER BY price ASC LIMIT 1
    675 0.0004 0.00040292739868164
    SELECT value FROM productattributes WHERE product_id = '147874' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
    676 0.0001 0.00011706352233887
    UPDATE products SET price = '1486' WHERE id = '147874'
    677 0.0002 0.00016689300537109
    SELECT * FROM productimages WHERE product_id = '415083' ORDER BY sortorder ASC
    678 0.0002 0.00021004676818848
    SELECT * FROM product_image_select WHERE product_id = '415083'
    679 0.0001 0.00011897087097168
    SELECT * FROM productcustomimages WHERE product_id = '415083'
    680 0.0035 0.0035269260406494
    SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '415083' AND a.name = n.originalname
    681 0.0002 0.00018095970153809
    SELECT * FROM productoffers WHERE product_id = '415083' AND merchantid = 'ATVPDKIKX0DER'
    682 0.0002 0.00020003318786621
    SELECT * FROM productoffers
                    WHERE product_id = '415083' AND price > 0
                    ORDER BY price ASC LIMIT 1
    683 0.0004 0.00043892860412598
    SELECT value FROM productattributes WHERE product_id = '415083' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
    684 0.0002 0.00024294853210449
    UPDATE products SET price = '2299' WHERE id = '415083'
    685 0.0007 0.00067901611328125
    SELECT * FROM productimages WHERE product_id = '185812' ORDER BY sortorder ASC
    686 0.0002 0.00021600723266602
    SELECT * FROM product_image_select WHERE product_id = '185812'
    687 0.0001 0.00012087821960449
    SELECT * FROM productcustomimages WHERE product_id = '185812'
    688 0.0021 0.0021181106567383
    SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '185812' AND a.name = n.originalname
    689 0.0002 0.00018405914306641
    SELECT * FROM productoffers WHERE product_id = '185812' AND merchantid = 'ATVPDKIKX0DER'
    690 0.0002 0.00020289421081543
    SELECT * FROM productoffers
                    WHERE product_id = '185812' AND price > 0
                    ORDER BY price ASC LIMIT 1
    691 0.0004 0.00036406517028809
    SELECT value FROM productattributes WHERE product_id = '185812' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
    692 0.0001 0.00012087821960449
    UPDATE products SET price = '314900' WHERE id = '185812'
    693 0.1098 0.10983300209045
    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
    694 0.0003 0.00027990341186523
    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:1563781703;s:8:\"products\";a:6:{i:7;s:6:\"410588\";i:19;s:6:\"406758\";i:20;s:6:\"130885\";i:22;s:6:\"407620\";i:12;s:6:\"402983\";i:4;s:6:\"415083\";}}' WHERE id = '181'
    695 0.0007 0.00071501731872559
    SELECT * FROM products WHERE id IN (410588,406758,130885,407620,402983,415083) ORDER BY FIELD(id, 410588,406758,130885,407620,402983,415083 )
    696 0.0002 0.0001988410949707
    SELECT * FROM productimages WHERE product_id = '410588' ORDER BY sortorder ASC
    697 0.0002 0.00020790100097656
    SELECT * FROM product_image_select WHERE product_id = '410588'
    698 0.0001 0.00012302398681641
    SELECT * FROM productcustomimages WHERE product_id = '410588'
    699 0.0021 0.0020749568939209
    SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '410588' AND a.name = n.originalname
    700 0.0002 0.00019192695617676
    SELECT * FROM productoffers WHERE product_id = '410588' AND merchantid = 'ATVPDKIKX0DER'
    701 0.0002 0.00020313262939453
    SELECT * FROM productoffers
                    WHERE product_id = '410588' AND price > 0
                    ORDER BY price ASC LIMIT 1
    702 0.0004 0.00036001205444336
    SELECT value FROM productattributes WHERE product_id = '410588' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
    703 0.0001 0.00012087821960449
    UPDATE products SET price = '269999' WHERE id = '410588'
    704 0.0002 0.00019407272338867
    SELECT * FROM productimages WHERE product_id = '406758' ORDER BY sortorder ASC
    705 0.0002 0.00021600723266602
    SELECT * FROM product_image_select WHERE product_id = '406758'
    706 0.0001 0.00011801719665527
    SELECT * FROM productcustomimages WHERE product_id = '406758'
    707 0.0027 0.0026957988739014
    SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '406758' AND a.name = n.originalname
    708 0.0002 0.00019693374633789
    SELECT * FROM productoffers WHERE product_id = '406758' AND merchantid = 'ATVPDKIKX0DER'
    709 0.0002 0.0001988410949707
    SELECT * FROM productoffers
                    WHERE product_id = '406758' AND price > 0
                    ORDER BY price ASC LIMIT 1
    710 0.0004 0.00039005279541016
    SELECT value FROM productattributes WHERE product_id = '406758' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
    711 0.0001 0.00011682510375977
    UPDATE products SET price = '2695' WHERE id = '406758'
    712 0.0002 0.00018906593322754
    SELECT * FROM productimages WHERE product_id = '130885' ORDER BY sortorder ASC
    713 0.0002 0.00020694732666016
    SELECT * FROM product_image_select WHERE product_id = '130885'
    714 0.0001 0.00011801719665527
    SELECT * FROM productcustomimages WHERE product_id = '130885'
    715 0.0020 0.0020089149475098
    SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '130885' AND a.name = n.originalname
    716 0.0002 0.00019216537475586
    SELECT * FROM productoffers WHERE product_id = '130885' AND merchantid = 'ATVPDKIKX0DER'
    717 0.0002 0.0001990795135498
    SELECT * FROM productoffers
                    WHERE product_id = '130885' AND price > 0
                    ORDER BY price ASC LIMIT 1
    718 0.0003 0.00034499168395996
    SELECT value FROM productattributes WHERE product_id = '130885' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
    719 0.0001 0.00011706352233887
    UPDATE products SET price = '1521' WHERE id = '130885'
    720 0.0002 0.00020503997802734
    SELECT * FROM productimages WHERE product_id = '407620' ORDER BY sortorder ASC
    721 0.0002 0.00020194053649902
    SELECT * FROM product_image_select WHERE product_id = '407620'
    722 0.0001 0.00011897087097168
    SELECT * FROM productcustomimages WHERE product_id = '407620'
    723 0.0023 0.0022931098937988
    SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '407620' AND a.name = n.originalname
    724 0.0002 0.00017905235290527
    SELECT * FROM productoffers WHERE product_id = '407620' AND merchantid = 'ATVPDKIKX0DER'
    725 0.0002 0.00020289421081543
    SELECT * FROM productoffers
                    WHERE product_id = '407620' AND price > 0
                    ORDER BY price ASC LIMIT 1
    726 0.0004 0.00036382675170898
    SELECT value FROM productattributes WHERE product_id = '407620' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
    727 0.0001 0.00011610984802246
    UPDATE products SET price = '20323' WHERE id = '407620'
    728 0.0002 0.00018692016601562
    SELECT * FROM productimages WHERE product_id = '402983' ORDER BY sortorder ASC
    729 0.0002 0.00021696090698242
    SELECT * FROM product_image_select WHERE product_id = '402983'
    730 0.0001 0.00011992454528809
    SELECT * FROM productcustomimages WHERE product_id = '402983'
    731 0.0022 0.002241849899292
    SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '402983' AND a.name = n.originalname
    732 0.0002 0.00018000602722168
    SELECT * FROM productoffers WHERE product_id = '402983' AND merchantid = 'ATVPDKIKX0DER'
    733 0.0002 0.0001990795135498
    SELECT * FROM productoffers
                    WHERE product_id = '402983' AND price > 0
                    ORDER BY price ASC LIMIT 1
    734 0.0003 0.00034213066101074
    SELECT value FROM productattributes WHERE product_id = '402983' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
    735 0.0001 0.00011897087097168
    UPDATE products SET price = '10396' WHERE id = '402983'
    736 0.0002 0.00016617774963379
    SELECT * FROM productimages WHERE product_id = '415083' ORDER BY sortorder ASC
    737 0.0002 0.0001990795135498
    SELECT * FROM product_image_select WHERE product_id = '415083'
    738 0.0001 0.00012898445129395
    SELECT * FROM productcustomimages WHERE product_id = '415083'
    739 0.0035 0.0034928321838379
    SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '415083' AND a.name = n.originalname
    740 0.0002 0.00018191337585449
    SELECT * FROM productoffers WHERE product_id = '415083' AND merchantid = 'ATVPDKIKX0DER'
    741 0.0002 0.0001990795135498
    SELECT * FROM productoffers
                    WHERE product_id = '415083' AND price > 0
                    ORDER BY price ASC LIMIT 1
    742 0.0004 0.0004270076751709
    SELECT value FROM productattributes WHERE product_id = '415083' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
    743 0.0002 0.00024318695068359
    UPDATE products SET price = '2299' WHERE id = '415083'
    744 0.1095 0.10949206352234
    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
    745 0.0003 0.00027990341186523
    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:1563781703;s:8:\"products\";a:6:{i:2;s:6:\"398858\";i:4;s:6:\"415083\";i:7;s:6:\"410588\";i:10;s:6:\"409759\";i:14;s:6:\"403517\";i:20;s:6:\"130885\";}}' WHERE id = '183'
    746 0.0007 0.00074005126953125
    SELECT * FROM products WHERE id IN (398858,415083,410588,409759,403517,130885) ORDER BY FIELD(id, 398858,415083,410588,409759,403517,130885 )
    747 0.0002 0.00020503997802734
    SELECT * FROM productimages WHERE product_id = '398858' ORDER BY sortorder ASC
    748 0.0002 0.0002138614654541
    SELECT * FROM product_image_select WHERE product_id = '398858'
    749 0.0001 0.00013303756713867
    SELECT * FROM productcustomimages WHERE product_id = '398858'
    750 0.0031 0.0031170845031738
    SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '398858' AND a.name = n.originalname
    751 0.0002 0.00018906593322754
    SELECT * FROM productoffers WHERE product_id = '398858' AND merchantid = 'ATVPDKIKX0DER'
    752 0.0002 0.00021100044250488
    SELECT * FROM productoffers
                    WHERE product_id = '398858' AND price > 0
                    ORDER BY price ASC LIMIT 1
    753 0.0004 0.00042295455932617
    SELECT value FROM productattributes WHERE product_id = '398858' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
    754 0.0001 0.00011897087097168
    UPDATE products SET price = '2999' WHERE id = '398858'
    755 0.0002 0.0001678466796875
    SELECT * FROM productimages WHERE product_id = '415083' ORDER BY sortorder ASC
    756 0.0002 0.00020599365234375
    SELECT * FROM product_image_select WHERE product_id = '415083'
    757 0.0001 0.00011801719665527
    SELECT * FROM productcustomimages WHERE product_id = '415083'
    758 0.0035 0.0034990310668945
    SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '415083' AND a.name = n.originalname
    759 0.0002 0.0001828670501709
    SELECT * FROM productoffers WHERE product_id = '415083' AND merchantid = 'ATVPDKIKX0DER'
    760 0.0002 0.00020003318786621
    SELECT * FROM productoffers
                    WHERE product_id = '415083' AND price > 0
                    ORDER BY price ASC LIMIT 1
    761 0.0004 0.00044012069702148
    SELECT value FROM productattributes WHERE product_id = '415083' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
    762 0.0002 0.00024199485778809
    UPDATE products SET price = '2299' WHERE id = '415083'
    763 0.0002 0.00017595291137695
    SELECT * FROM productimages WHERE product_id = '410588' ORDER BY sortorder ASC
    764 0.0002 0.00020003318786621
    SELECT * FROM product_image_select WHERE product_id = '410588'
    765 0.0001 0.00013113021850586
    SELECT * FROM productcustomimages WHERE product_id = '410588'
    766 0.0021 0.0020599365234375
    SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '410588' AND a.name = n.originalname
    767 0.0002 0.00017905235290527
    SELECT * FROM productoffers WHERE product_id = '410588' AND merchantid = 'ATVPDKIKX0DER'
    768 0.0002 0.00019192695617676
    SELECT * FROM productoffers
                    WHERE product_id = '410588' AND price > 0
                    ORDER BY price ASC LIMIT 1
    769 0.0004 0.00035905838012695
    SELECT value FROM productattributes WHERE product_id = '410588' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
    770 0.0001 0.00012016296386719
    UPDATE products SET price = '269999' WHERE id = '410588'
    771 0.0002 0.00020408630371094
    SELECT * FROM productimages WHERE product_id = '409759' ORDER BY sortorder ASC
    772 0.0002 0.00020813941955566
    SELECT * FROM product_image_select WHERE product_id = '409759'
    773 0.0001 0.00011801719665527
    SELECT * FROM productcustomimages WHERE product_id = '409759'
    774 0.0028 0.0028171539306641
    SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '409759' AND a.name = n.originalname
    775 0.0002 0.00018119812011719
    SELECT * FROM productoffers WHERE product_id = '409759' AND merchantid = 'ATVPDKIKX0DER'
    776 0.0002 0.00020909309387207
    SELECT * FROM productoffers
                    WHERE product_id = '409759' AND price > 0
                    ORDER BY price ASC LIMIT 1
    777 0.0004 0.00039315223693848
    SELECT value FROM productattributes WHERE product_id = '409759' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
    778 0.0001 0.00011897087097168
    UPDATE products SET price = '229000' WHERE id = '409759'
    779 0.0003 0.00025582313537598
    SELECT * FROM productimages WHERE product_id = '403517' ORDER BY sortorder ASC
    780 0.0002 0.00022006034851074
    SELECT * FROM product_image_select WHERE product_id = '403517'
    781 0.0001 0.00012016296386719
    SELECT * FROM productcustomimages WHERE product_id = '403517'
    782 0.0030 0.0029890537261963
    SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '403517' AND a.name = n.originalname
    783 0.0002 0.00018596649169922
    SELECT * FROM productoffers WHERE product_id = '403517' AND merchantid = 'ATVPDKIKX0DER'
    784 0.0002 0.00020503997802734
    SELECT * FROM productoffers
                    WHERE product_id = '403517' AND price > 0
                    ORDER BY price ASC LIMIT 1
    785 0.0004 0.00041317939758301
    SELECT value FROM productattributes WHERE product_id = '403517' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
    786 0.0001 0.00011897087097168
    UPDATE products SET price = '6699' WHERE id = '403517'
    787 0.0002 0.00018787384033203
    SELECT * FROM productimages WHERE product_id = '130885' ORDER BY sortorder ASC
    788 0.0002 0.00020098686218262
    SELECT * FROM product_image_select WHERE product_id = '130885'
    789 0.0001 0.00011920928955078
    SELECT * FROM productcustomimages WHERE product_id = '130885'
    790 0.0020 0.0020139217376709
    SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '130885' AND a.name = n.originalname
    791 0.0002 0.0001838207244873
    SELECT * FROM productoffers WHERE product_id = '130885' AND merchantid = 'ATVPDKIKX0DER'
    792 0.0002 0.00020003318786621
    SELECT * FROM productoffers
                    WHERE product_id = '130885' AND price > 0
                    ORDER BY price ASC LIMIT 1
    793 0.0003 0.00034594535827637
    SELECT value FROM productattributes WHERE product_id = '130885' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
    794 0.0001 0.00011610984802246
    UPDATE products SET price = '1521' WHERE id = '130885'
    795 0.0004 0.00040602684020996
    SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid' AND area = 'header' ORDER BY sortorder ASC
    796 0.0001 0.00012993812561035
    SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
    797 0.0001 0.00011801719665527
    SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
    798 0.0001 0.00011920928955078
    SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
    799 0.0001 0.00011610984802246
    SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
    800 0.0004 0.00039482116699219
    SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid' AND area = 'footer' ORDER BY sortorder ASC
    801 0.0001 0.0001220703125
    SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
    802 0.0001 0.00011992454528809
    SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
    803 0.0001 0.00011491775512695
    SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
    804 0.0009 0.00092291831970215
    SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-fluid' AND skinuid = ''
    805 0.0003 0.0003049373626709
    SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid'
    806 0.0003 0.00028085708618164
    SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid'
    807 0.0004 0.00043392181396484
    SELECT * FROM template_images WHERE templateuid = 'fsb-fluid' AND imageuid = 'HEAD_CUSTOM_BANNER'
    808 0.0003 0.00033402442932129
    SELECT * FROM template_images WHERE templateuid = 'fsb-fluid' AND imageuid = 'HEAD_CUSTOM_BANNER'