Tactical Equipment - Survivalist Equipment
   

CRKT Innovation :: Field Strip Technology

CRKT knife technology

HOW KEN ONION & CRKT BROUGHT FIELD STRIP TECHNOLOGY TO MARKET

UPDATED :  

Thirty seconds

That is typically how much time the average knife buyer will look at a knife's design or its mechanism and decide whether or not to purchase that product. Understandably, they may not realize the story behind the design and mechanics that come with its production, but every new product development team has stories of "taking two steps forward and one step back."

Teams talk about concepts and engineering for hours and have bins filled with scrapped parts from design attempts that never even made production. However, with purpose, grit, inspiration, and a little luck, new designs featuring state-of-the-art technology and cutting-edge innovations are still made and brought to market, innovations such as Field Strip Technology from CRKT.

Field Strip Tech Development and Engineering

More than 10 years ago, Ken Onion, a world-renowned knlfemaker from Hawaii, was frustrated that he could not easily clean debris from his folding knife. Dirt, muck, mud, sand, dust, lint and even peanut butter caused the knife to not function properly and sanitarily boot.

Being a retired Marine, Ken thought about all the guns he easily disassembled without tools for cleaning and maintenance while in the military. He resolved to come up with a solution for this problem. That is how the concept of Field Strip Technology for knives was born.

Addressing Obstacles

Developing a knife to take apart without field tools is a formidable obstacle, so challenges arose with CRKT's innovative tech that needed to be addressed. First, the knife needed durability to hold up to constant daily use.

Second, there couldn't be any loose parts to lose when the knife wa s taken apart.

Last, the knife needed to be easy, simple and intuitive enough for anyone to disassemble and reassemble.

From this, specific questions arose in the engineering and development of Field Strip Technology:

  • How to remove the blade from the pivot for easy cleaning?
  • How to secure the front of the knife so the blade rotates freely without any teetering?
  • How to secure the pivot, stop pin, locking liners and washers ?
  • How to fasten the handles together, the back end specifically, so they don't spread apart or separate vertically during reassembly?
  • Lastly, how to make it all simple enough so that anyone can field strip their knife and put it back together without any tools?

Ken solved the first challenge by developing a hex-headed pivot tha t fit through the pivot hole in the blade and secured at the front handle. He also added an adjustment screw to the backside pivot, which eliminated excess play in the pivot area.

CRKT Field Strip Knife TechnologyWhen developing the technology, CRKT a nd Onion wanted to make sure it was simple enough that anyone could field strip the knife and reassemble it without any tools.

The security of the tolerances for proper lock engagement is critical in the production of "strip locks." Securing the stop pin may sound easy, but it had to be perfectly perpendicular for the knife to properly fit. This wa s a challenge Ken and CRKT's product development and engineering team solved with fixtures to assure the stop pin was pressed in perfectly perpendicular every time.

Securing the washers was just a matter of tooling up a custom washer that pressed fit into the aluminum of the handles.

Holding the back end of the knife together presented a security challenge in that the handles had to be secure from separating and easily returned together tightly during reassembly. After researching and testing different variations and ideas, Ken and the CRKT product development and engineering team settled on a wheel lock.

Two key components were crucial in the decision to move forward with the wheel lock: It was easily manufactured and secured the knife handles from separating while bringing the handles tightly together. The wheel lock appealed aesthetically to Ken's design. It is important to CRKT that the custom knifemaker's vision, including aesthetic appeal, is properly executed in the production model coming to market.

The most obvious challenge Ken and the CRKT team encountered was the reassembly of the knife. Early iterations were easy to take apart, but the handle halves had to align perfectly for the knife to properly reassemble.

CRKT Tough Folding Knives

ABOVE :This technology resulted from Ken Onions frustration that he couicl not easily clean debris from his folding knife.

After extensive field-testing, brainstorming and research, Ken and the CRKT discovered that the hexagon pivot needed to float freely under the pivot, which misaligned the handles, making it easy to reassemble. The handles needed not be perfectly parallel for the pivot to seat into the top handle, but squeezed on both sides to lock the lever down. Once locked, the pivot stabilizes and the knife is ready for action .

CRKT In the Marketplace

It took years and great teamwork , but Field Strip Technology is now available to the masses-with new designs to arrive in 2017. With such positive reactions, it has been exciting to dawn a new horizon of innovation with the potential to create an entire new category.

HOW IT WORKS

When the knife is in closed position, press the release lever that is located by the upper pivot. Loosen the rear wheel until you hear a distinct click. The handles should release from each other. The knife releases in three sections for easy cleaning and maintenance.

To assemble, pinch the pivot together with your index finger and thumb. You will feel it seat. Still pinching the pivot, tighten the wheel until the handles come together. Then lock the lever while you are still squeezing the pivot together.

The Homefront is now fully assembled and ready to take on any next task.

CRKT Knife instructions


Debug Overview

App Total Time DB Queries DB Query Total Time Amazon Requests
3.2405471801758 604 1.7772 0


No Amazon API Requests Made.


App Debug - Total Time 3.2405471801758 seconds

Number Time From Start Name Description
1 0.94543218612671 Initialise Initialise FSB Function
2 1.2389299869537 App Controller Start Start of the App controller (called before the controller of every page)
3 1.2959721088409 Start of getCategoryListByGroup Function Before first category groups query
4 1.2961440086365 After initial query Before first category groups query
5 1.2961452007294 Get Category List for Group Before the call to getCategoryList function
6 1.2961480617523 Start of GetCategoryList function Start of the function
7 1.2961521148682 Before getting categories Query to get specific category list
8 1.2967619895935 After getting categories Query to get specific category list
9 1.2967631816864 Before getting category custom Before call to function getCategoryCustom
10 1.2986791133881 After getting category custom After call to function getCategoryCustom
11 1.298681974411 Before getting category custom Before call to function getCategoryCustom
12 1.3412971496582 After getting category custom After call to function getCategoryCustom
13 1.3413009643555 Before getting category custom Before call to function getCategoryCustom
14 1.3473641872406 After getting category custom After call to function getCategoryCustom
15 1.3473660945892 Before getting category custom Before call to function getCategoryCustom
16 1.35169506073 After getting category custom After call to function getCategoryCustom
17 1.3516981601715 End of GetCategoryList function End of the function
18 1.3517091274261 Get Category List for Group Before the call to getCategoryList function
19 1.3517119884491 Start of GetCategoryList function Start of the function
20 1.3517150878906 Before getting categories Query to get specific category list
21 1.3521502017975 After getting categories Query to get specific category list
22 1.3521511554718 Before getting category custom Before call to function getCategoryCustom
23 1.3578741550446 After getting category custom After call to function getCategoryCustom
24 1.3578760623932 Before getting category custom Before call to function getCategoryCustom
25 1.3688821792603 After getting category custom After call to function getCategoryCustom
26 1.3688850402832 End of GetCategoryList function End of the function
27 1.3688921928406 Get Category List for Group Before the call to getCategoryList function
28 1.3688950538635 Start of GetCategoryList function Start of the function
29 1.3688981533051 Before getting categories Query to get specific category list
30 1.3696269989014 After getting categories Query to get specific category list
31 1.3696291446686 Before getting category custom Before call to function getCategoryCustom
32 1.3790380954742 After getting category custom After call to function getCategoryCustom
33 1.3790411949158 Before getting category custom Before call to function getCategoryCustom
34 1.5753819942474 After getting category custom After call to function getCategoryCustom
35 1.5753860473633 Before getting category custom Before call to function getCategoryCustom
36 1.8274850845337 After getting category custom After call to function getCategoryCustom
37 1.8274891376495 Before getting category custom Before call to function getCategoryCustom
38 1.8336951732635 After getting category custom After call to function getCategoryCustom
39 1.8336980342865 Before getting category custom Before call to function getCategoryCustom
40 1.8402500152588 After getting category custom After call to function getCategoryCustom
41 1.8402531147003 Before getting category custom Before call to function getCategoryCustom
42 1.9961130619049 After getting category custom After call to function getCategoryCustom
43 1.9961180686951 Before getting category custom Before call to function getCategoryCustom
44 2.0004110336304 After getting category custom After call to function getCategoryCustom
45 2.0004141330719 Before getting category custom Before call to function getCategoryCustom
46 2.0053231716156 After getting category custom After call to function getCategoryCustom
47 2.0053260326385 End of GetCategoryList function End of the function
48 2.0053400993347 Get Category List for Group Before the call to getCategoryList function
49 2.0053431987762 Start of GetCategoryList function Start of the function
50 2.0053470134735 Before getting categories Query to get specific category list
51 2.0057849884033 After getting categories Query to get specific category list
52 2.0057861804962 Before getting category custom Before call to function getCategoryCustom
53 2.0081009864807 After getting category custom After call to function getCategoryCustom
54 2.0081031322479 Before getting category custom Before call to function getCategoryCustom
55 2.0104119777679 After getting category custom After call to function getCategoryCustom
56 2.0104141235352 End of GetCategoryList function End of the function
57 2.0104200839996 Get Category List for Group Before the call to getCategoryList function
58 2.0104219913483 Start of GetCategoryList function Start of the function
59 2.0104250907898 Before getting categories Query to get specific category list
60 2.0107431411743 After getting categories Query to get specific category list
61 2.0107440948486 Before getting category custom Before call to function getCategoryCustom
62 2.0157871246338 After getting category custom After call to function getCategoryCustom
63 2.0157890319824 End of GetCategoryList function End of the function
64 2.0157949924469 End of getCategoryListByGroup Function Before return()
65 2.5097160339355 App Controller End End of the App controller (called before the controller of every page)
66 2.6002330780029 App_after Controller Start Start of the App_after controller (called after the controller of every page)
67 2.6003429889679 Before Get Options Before the call to getOptions in the tpl class
68 2.9153730869293 After Get Options After the call to getOptions in the tpl class
69 2.9154250621796 App_after Controller End End of the App_after controller (called after the controller of every page)
70 3.2405290603638 Finalizing debug Before the debug is output to the page.
71 3.2405459880829 End of App This is the end of the app logging, final timestamp


Query Debug - 604 Database Queries. Total time 1.7772 seconds

Number Time (Seconds) Time (Milliseconds) Query
1 0.0002 0.000244140625
SELECT value FROM parameters WHERE `parameter` = 'BAD_BOTS_ENABLER'
2 0.0005 0.00048017501831055
SHOW TABLES LIKE 'bad_bots'
3 0.0002 0.00016403198242188
SELECT value FROM parameters WHERE `parameter` = 'STORE_WHITELISTED_IPS'
4 0.0640 0.064033031463623
SELECT * FROM `bad_bots`
5 0.0707 0.070701122283936
SELECT parameter, value FROM parameters
6 0.0002 0.00019407272338867
SET time_zone = 'Europe/London'
7 0.0003 0.00030684471130371
SELECT * FROM autorun ORDER BY lastrun ASC
8 0.0002 0.00015091896057129
SELECT * FROM version ORDER BY installed DESC LIMIT 1
9 0.0001 0.00010299682617188
delete from cachefiles
10 0.0003 0.00028395652770996
SELECT id FROM pages WHERE pagename = 'crkt-innovation-field-strip-technology' LIMIT 1
11 0.0002 0.00017786026000977
SELECT * FROM pages WHERE id = 349
12 0.0096 0.0095949172973633
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-fluid'
13 0.0463 0.046345949172974
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-fluid' AND language = 'en'
14 0.0003 0.00029110908508301
SELECT * FROM pages WHERE pagename = 'crkt-innovation-field-strip-technology'
15 0.0002 0.00015592575073242
SELECT * FROM categorygroups ORDER BY sortorder ASC
16 0.0006 0.00057005882263184
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
17 0.0005 0.00051403045654297
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.00023484230041504
SELECT id FROM categories WHERE parent_id = '49'
19 0.0005 0.00046110153198242
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.00014591217041016
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.0001530647277832
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.00017714500427246
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '49'
23 0.0001 0.00013494491577148
SELECT * FROM categorygroups WHERE id = '1'
24 0.0348 0.03482985496521
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.00030899047851562
SELECT id FROM categories WHERE parent_id = '50'
26 0.0002 0.00021004676818848
SELECT id FROM categories WHERE parent_id = '96'
27 0.0002 0.00020098686218262
SELECT id FROM categories WHERE parent_id = '97'
28 0.0002 0.0001988410949707
SELECT id FROM categories WHERE parent_id = '111'
29 0.0002 0.00021100044250488
SELECT id FROM categories WHERE parent_id = '129'
30 0.0058 0.0058178901672363
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.0002129077911377
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.00015997886657715
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.00017499923706055
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '50'
34 0.0001 0.00013089179992676
SELECT * FROM categorygroups WHERE id = '1'
35 0.0025 0.002547025680542
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.00026106834411621
SELECT id FROM categories WHERE parent_id = '80'
37 0.0026 0.0025551319122314
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (80)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
38 0.0002 0.00016212463378906
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.00014996528625488
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.00016093254089355
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '80'
41 0.0001 0.00012493133544922
SELECT * FROM categorygroups WHERE id = '1'
42 0.0012 0.0012049674987793
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 51
43 0.0003 0.00025105476379395
SELECT id FROM categories WHERE parent_id = '51'
44 0.0002 0.00020408630371094
SELECT id FROM categories WHERE parent_id = '101'
45 0.0018 0.0018270015716553
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.00015592575073242
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (101,51)
				  AND p.disabled = 0 
47 0.0002 0.00015115737915039
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.00022697448730469
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '51'
49 0.0002 0.00016689300537109
SELECT * FROM categorygroups WHERE id = '1'
50 0.0004 0.00040888786315918
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '2'  AND hidden = 0 ORDER BY sortorder ASC
51 0.0024 0.002439022064209
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.00025582313537598
SELECT id FROM categories WHERE parent_id = '30'
53 0.0023 0.0023200511932373
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (30)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
54 0.0002 0.00015401840209961
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (30)
				  AND p.disabled = 0 
55 0.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 (30)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
56 0.0002 0.00018191337585449
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
57 0.0001 0.00012683868408203
SELECT * FROM categorygroups WHERE id = '2'
58 0.0050 0.0049979686737061
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.00026702880859375
SELECT id FROM categories WHERE parent_id = '61'
60 0.0049 0.0048928260803223
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.00015997886657715
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (61)
				  AND p.disabled = 0 
62 0.0002 0.0002131462097168
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.00020194053649902
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '61'
64 0.0002 0.00015997886657715
SELECT * FROM categorygroups WHERE id = '2'
65 0.0006 0.00064492225646973
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '10'  AND hidden = 0 ORDER BY sortorder ASC
66 0.0043 0.0042951107025146
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.00026798248291016
SELECT id FROM categories WHERE parent_id = '64'
68 0.0041 0.0041348934173584
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.00015902519226074
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (64)
				  AND p.disabled = 0 
70 0.0002 0.00016212463378906
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.0001671314239502
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '64'
72 0.0001 0.00012707710266113
SELECT * FROM categorygroups WHERE id = '10'
73 0.1867 0.18673205375671
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.00034904479980469
SELECT id FROM categories WHERE parent_id = '65'
75 0.0085 0.0084869861602783
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.00017809867858887
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (65)
				  AND p.disabled = 0 
77 0.0002 0.00015592575073242
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.00018095970153809
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '65'
79 0.0001 0.00013184547424316
SELECT * FROM categorygroups WHERE id = '10'
80 0.2484 0.24837899208069
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.0004 0.00036001205444336
SELECT id FROM categories WHERE parent_id = '81'
82 0.0026 0.0026190280914307
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.00015902519226074
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (81)
				  AND p.disabled = 0 
84 0.0002 0.00015711784362793
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.00016903877258301
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '81'
86 0.0001 0.00013589859008789
SELECT * FROM categorygroups WHERE id = '10'
87 0.0026 0.0025889873504639
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.00026297569274902
SELECT id FROM categories WHERE parent_id = '31'
89 0.0026 0.0026237964630127
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.00016593933105469
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.00014901161193848
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (31)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
92 0.0002 0.00016999244689941
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
93 0.0001 0.00014281272888184
SELECT * FROM categorygroups WHERE id = '10'
94 0.0023 0.0023200511932373
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.00025796890258789
SELECT id FROM categories WHERE parent_id = '66'
96 0.0002 0.00020408630371094
SELECT id FROM categories WHERE parent_id = '131'
97 0.0030 0.0030338764190674
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.0001838207244873
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (131,66)
				  AND p.disabled = 0 
99 0.0002 0.00015091896057129
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.00016307830810547
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '66'
101 0.0001 0.00012397766113281
SELECT * FROM categorygroups WHERE id = '10'
102 0.1427 0.14265394210815
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.0004 0.00040411949157715
SELECT id FROM categories WHERE parent_id = '34'
104 0.0002 0.00021195411682129
SELECT id FROM categories WHERE parent_id = '94'
105 0.0002 0.00023293495178223
SELECT id FROM categories WHERE parent_id = '98'
106 0.0002 0.00020194053649902
SELECT id FROM categories WHERE parent_id = '99'
107 0.0002 0.0001978874206543
SELECT id FROM categories WHERE parent_id = '110'
108 0.0002 0.0001981258392334
SELECT id FROM categories WHERE parent_id = '130'
109 0.0108 0.010792016983032
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.00018906593322754
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (94,98,99,110,130,34)
				  AND p.disabled = 0 
111 0.0002 0.00017595291137695
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (94,98,99,110,130,34)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
112 0.0002 0.00024795532226562
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '34'
113 0.0002 0.0001518726348877
SELECT * FROM categorygroups WHERE id = '10'
114 0.0017 0.0017280578613281
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.00027704238891602
SELECT id FROM categories WHERE parent_id = '32'
116 0.0016 0.0016059875488281
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.00014901161193848
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.00014805793762207
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.00016403198242188
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '32'
120 0.0001 0.00012588500976562
SELECT * FROM categorygroups WHERE id = '10'
121 0.0020 0.0019769668579102
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 89
122 0.0003 0.00026202201843262
SELECT id FROM categories WHERE parent_id = '89'
123 0.0020 0.0019829273223877
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (89)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
124 0.0002 0.00015091896057129
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.00014901161193848
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.00016999244689941
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '89'
127 0.0001 0.00012588500976562
SELECT * FROM categorygroups WHERE id = '10'
128 0.0004 0.0004119873046875
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '17'  AND hidden = 0 ORDER BY sortorder ASC
129 0.0007 0.00069308280944824
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.0002439022064209
SELECT id FROM categories WHERE parent_id = '84'
131 0.0007 0.00068902969360352
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (84)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
132 0.0002 0.00015592575073242
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.00014901161193848
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.0001671314239502
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '84'
135 0.0001 0.00012397766113281
SELECT * FROM categorygroups WHERE id = '17'
136 0.0007 0.00069594383239746
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.00023603439331055
SELECT id FROM categories WHERE parent_id = '90'
138 0.0007 0.0007171630859375
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.00014400482177734
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.00014495849609375
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.00015592575073242
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '90'
142 0.0001 0.0001218318939209
SELECT * FROM categorygroups WHERE id = '17'
143 0.0003 0.0003049373626709
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '20'  AND hidden = 0 ORDER BY sortorder ASC
144 0.0021 0.0020699501037598
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.00024294853210449
SELECT id FROM categories WHERE parent_id = '92'
146 0.0021 0.0020549297332764
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (92)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
147 0.0001 0.00014901161193848
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.00014686584472656
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (92)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
149 0.0002 0.00015997886657715
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '92'
150 0.0001 0.00012493133544922
SELECT * FROM categorygroups WHERE id = '20'
151 0.0054 0.0053579807281494
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
152 0.0004 0.00037407875061035
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-fluid' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
153 0.0002 0.00019717216491699
SELECT value FROM parameters WHERE parameter = 'EBAY_APP_ID' 
154 0.0002 0.00015807151794434
SELECT * FROM sideboxes_pages WHERE sidebox_id = '1'
155 0.0002 0.0001680850982666
SELECT * FROM pages WHERE id = '67'
156 0.0002 0.0001680850982666
SELECT * FROM pages WHERE id = '82'
157 0.0002 0.00015878677368164
SELECT * FROM pages WHERE id = '84'
158 0.0001 0.00014281272888184
SELECT * FROM pages WHERE id = '94'
159 0.0002 0.00015497207641602
SELECT * FROM pages WHERE id = '116'
160 0.0002 0.00020289421081543
SELECT * FROM pages WHERE id = '52'
161 0.0002 0.00015807151794434
SELECT * FROM pages WHERE id = '135'
162 0.0002 0.00016617774963379
SELECT * FROM pages WHERE id = '245'
163 0.0002 0.0001680850982666
SELECT * FROM pages WHERE id = '269'
164 0.0002 0.00018596649169922
SELECT * FROM pages WHERE id = '275'
165 0.0002 0.0002131462097168
SELECT * FROM pages WHERE id = '280'
166 0.0002 0.00018596649169922
SELECT * FROM pages WHERE id = '357'
167 0.0002 0.00015497207641602
SELECT * FROM pages WHERE id = '379'
168 0.0001 0.00014305114746094
SELECT * FROM pages WHERE id = '401'
169 0.0002 0.00015091896057129
SELECT * FROM pages WHERE id = '450'
170 0.0001 0.00014805793762207
SELECT * FROM pages WHERE id = '454'
171 0.0002 0.00015592575073242
SELECT * FROM pages WHERE id = '457'
172 0.0001 0.00014996528625488
SELECT * FROM pages WHERE id = '458'
173 0.0002 0.00015711784362793
SELECT * FROM sideboxes_pages WHERE sidebox_id = '2'
174 0.0157 0.015696048736572
SELECT * FROM pages WHERE id = '41'
175 0.0002 0.00021100044250488
SELECT * FROM pages WHERE id = '43'
176 0.0003 0.00032615661621094
SELECT * FROM pages WHERE id = '44'
177 0.0003 0.00029301643371582
SELECT * FROM pages WHERE id = '68'
178 0.0002 0.0001981258392334
SELECT * FROM pages WHERE id = '80'
179 0.0002 0.0001680850982666
SELECT * FROM pages WHERE id = '85'
180 0.0002 0.00015377998352051
SELECT * FROM pages WHERE id = '97'
181 0.0002 0.00015997886657715
SELECT * FROM pages WHERE id = '107'
182 0.0001 0.00014710426330566
SELECT * FROM pages WHERE id = '108'
183 0.0001 0.00014090538024902
SELECT * FROM pages WHERE id = '128'
184 0.0002 0.00016903877258301
SELECT * FROM pages WHERE id = '133'
185 0.0002 0.0001521110534668
SELECT * FROM pages WHERE id = '148'
186 0.0002 0.00016093254089355
SELECT * FROM pages WHERE id = '217'
187 0.0001 0.00014305114746094
SELECT * FROM pages WHERE id = '228'
188 0.0001 0.00014686584472656
SELECT * FROM pages WHERE id = '257'
189 0.0002 0.00015592575073242
SELECT * FROM pages WHERE id = '271'
190 0.0002 0.00015711784362793
SELECT * FROM pages WHERE id = '286'
191 0.0001 0.00014495849609375
SELECT * FROM pages WHERE id = '287'
192 0.0002 0.0001530647277832
SELECT * FROM pages WHERE id = '291'
193 0.0002 0.0001530647277832
SELECT * FROM pages WHERE id = '380'
194 0.0002 0.00015902519226074
SELECT * FROM pages WHERE id = '344'
195 0.0002 0.00015616416931152
SELECT * FROM pages WHERE id = '354'
196 0.0002 0.0001828670501709
SELECT * FROM pages WHERE id = '363'
197 0.0002 0.00018215179443359
SELECT * FROM pages WHERE id = '364'
198 0.0001 0.00014281272888184
SELECT * FROM pages WHERE id = '368'
199 0.0002 0.00017404556274414
SELECT * FROM pages WHERE id = '369'
200 0.0001 0.00014400482177734
SELECT * FROM pages WHERE id = '400'
201 0.0002 0.00016999244689941
SELECT * FROM pages WHERE id = '463'
202 0.0002 0.00017213821411133
SELECT * FROM sideboxes_pages WHERE sidebox_id = '33'
203 0.0003 0.00025010108947754
SELECT * FROM pages WHERE id = '66'
204 0.0003 0.00028395652770996
SELECT * FROM pages WHERE id = '77'
205 0.0002 0.00019407272338867
SELECT * FROM pages WHERE id = '90'
206 0.0001 0.00014591217041016
SELECT * FROM pages WHERE id = '414'
207 0.0001 0.00014805793762207
SELECT * FROM pages WHERE id = '119'
208 0.0001 0.00014901161193848
SELECT * FROM pages WHERE id = '406'
209 0.0001 0.00014996528625488
SELECT * FROM pages WHERE id = '149'
210 0.0001 0.00014185905456543
SELECT * FROM pages WHERE id = '150'
211 0.0002 0.0001530647277832
SELECT * FROM pages WHERE id = '412'
212 0.0002 0.00015687942504883
SELECT * FROM pages WHERE id = '162'
213 0.0001 0.00014209747314453
SELECT * FROM pages WHERE id = '164'
214 0.0001 0.00014400482177734
SELECT * FROM pages WHERE id = '167'
215 0.0001 0.0001370906829834
SELECT * FROM pages WHERE id = '180'
216 0.0001 0.00013995170593262
SELECT * FROM pages WHERE id = '187'
217 0.0002 0.00019598007202148
SELECT * FROM pages WHERE id = '265'
218 0.0002 0.00015401840209961
SELECT * FROM pages WHERE id = '268'
219 0.0001 0.00014019012451172
SELECT * FROM pages WHERE id = '411'
220 0.0001 0.00014805793762207
SELECT * FROM pages WHERE id = '290'
221 0.0001 0.00014090538024902
SELECT * FROM pages WHERE id = '413'
222 0.0001 0.00014209747314453
SELECT * FROM pages WHERE id = '409'
223 0.0002 0.00015497207641602
SELECT * FROM pages WHERE id = '327'
224 0.0001 0.00014996528625488
SELECT * FROM pages WHERE id = '336'
225 0.0002 0.0001530647277832
SELECT * FROM pages WHERE id = '351'
226 0.0002 0.0001518726348877
SELECT * FROM pages WHERE id = '358'
227 0.0002 0.00015091896057129
SELECT * FROM pages WHERE id = '360'
228 0.0002 0.0001528263092041
SELECT * FROM pages WHERE id = '362'
229 0.0002 0.0001530647277832
SELECT * FROM pages WHERE id = '366'
230 0.0002 0.00016498565673828
SELECT * FROM pages WHERE id = '370'
231 0.0001 0.00014996528625488
SELECT * FROM pages WHERE id = '377'
232 0.0001 0.00014591217041016
SELECT * FROM pages WHERE id = '386'
233 0.0001 0.00014305114746094
SELECT * FROM pages WHERE id = '408'
234 0.0002 0.00015997886657715
SELECT * FROM pages WHERE id = '415'
235 0.0002 0.00016498565673828
SELECT * FROM pages WHERE id = '416'
236 0.0002 0.00018000602722168
SELECT * FROM pages WHERE id = '419'
237 0.0002 0.00015401840209961
SELECT * FROM pages WHERE id = '423'
238 0.0002 0.0001521110534668
SELECT * FROM pages WHERE id = '427'
239 0.0002 0.00017285346984863
SELECT * FROM pages WHERE id = '428'
240 0.0002 0.0001521110534668
SELECT * FROM pages WHERE id = '432'
241 0.0001 0.00014305114746094
SELECT * FROM pages WHERE id = '433'
242 0.0002 0.00015091896057129
SELECT * FROM pages WHERE id = '436'
243 0.0001 0.00014591217041016
SELECT * FROM pages WHERE id = '437'
244 0.0001 0.00013995170593262
SELECT * FROM pages WHERE id = '461'
245 0.0002 0.0001678466796875
SELECT * FROM pages WHERE id = '464'
246 0.0002 0.00015997886657715
SELECT * FROM sideboxes_pages WHERE sidebox_id = '34'
247 0.0002 0.00015711784362793
SELECT * FROM pages WHERE id = '74'
248 0.0001 0.00014686584472656
SELECT * FROM pages WHERE id = '137'
249 0.0001 0.00014710426330566
SELECT * FROM pages WHERE id = '145'
250 0.0002 0.0001521110534668
SELECT * FROM pages WHERE id = '156'
251 0.0002 0.00015807151794434
SELECT * FROM pages WHERE id = '407'
252 0.0001 0.00014281272888184
SELECT * FROM pages WHERE id = '410'
253 0.0002 0.00017499923706055
SELECT * FROM pages WHERE id = '266'
254 0.0002 0.00019407272338867
SELECT * FROM pages WHERE id = '316'
255 0.0001 0.00014901161193848
SELECT * FROM pages WHERE id = '332'
256 0.0002 0.00017690658569336
SELECT * FROM pages WHERE id = '334'
257 0.0002 0.00015401840209961
SELECT * FROM pages WHERE id = '367'
258 0.0002 0.0001521110534668
SELECT * FROM pages WHERE id = '387'
259 0.0001 0.00014805793762207
SELECT * FROM pages WHERE id = '389'
260 0.0002 0.00015401840209961
SELECT * FROM pages WHERE id = '397'
261 0.0002 0.00015711784362793
SELECT * FROM pages WHERE id = '449'
262 0.0002 0.00017189979553223
SELECT * FROM sideboxes_pages WHERE sidebox_id = '35'
263 0.0002 0.00019097328186035
SELECT * FROM pages WHERE id = '42'
264 0.0001 0.00014996528625488
SELECT * FROM pages WHERE id = '79'
265 0.0002 0.00015997886657715
SELECT * FROM pages WHERE id = '86'
266 0.0001 0.00014400482177734
SELECT * FROM pages WHERE id = '95'
267 0.0002 0.00015401840209961
SELECT * FROM pages WHERE id = '102'
268 0.0002 0.00015401840209961
SELECT * FROM pages WHERE id = '109'
269 0.0002 0.00021100044250488
SELECT * FROM pages WHERE id = '114'
270 0.0002 0.00017690658569336
SELECT * FROM pages WHERE id = '121'
271 0.0002 0.00018596649169922
SELECT * FROM pages WHERE id = '138'
272 0.0002 0.00015401840209961
SELECT * FROM pages WHERE id = '142'
273 0.0002 0.0001981258392334
SELECT * FROM pages WHERE id = '62'
274 0.0001 0.00014805793762207
SELECT * FROM pages WHERE id = '157'
275 0.0002 0.00015783309936523
SELECT * FROM pages WHERE id = '246'
276 0.0002 0.00018596649169922
SELECT * FROM pages WHERE id = '276'
277 0.0002 0.00017905235290527
SELECT * FROM pages WHERE id = '278'
278 0.0002 0.00020384788513184
SELECT * FROM pages WHERE id = '279'
279 0.0002 0.00016188621520996
SELECT * FROM pages WHERE id = '317'
280 0.0002 0.00015091896057129
SELECT * FROM pages WHERE id = '405'
281 0.0002 0.00017118453979492
SELECT * FROM pages WHERE id = '343'
282 0.0002 0.00015091896057129
SELECT * FROM pages WHERE id = '345'
283 0.0002 0.00019001960754395
SELECT * FROM pages WHERE id = '346'
284 0.0002 0.00015807151794434
SELECT * FROM pages WHERE id = '347'
285 0.0002 0.00015902519226074
SELECT * FROM pages WHERE id = '348'
286 0.0002 0.00015020370483398
SELECT * FROM pages WHERE id = '349'
287 0.0001 0.00014901161193848
SELECT * FROM pages WHERE id = '381'
288 0.0001 0.00014996528625488
SELECT * FROM pages WHERE id = '392'
289 0.0002 0.00015592575073242
SELECT * FROM pages WHERE id = '393'
290 0.0001 0.00014400482177734
SELECT * FROM pages WHERE id = '394'
291 0.0001 0.00014400482177734
SELECT * FROM pages WHERE id = '395'
292 0.0002 0.00015902519226074
SELECT * FROM pages WHERE id = '399'
293 0.0002 0.0001530647277832
SELECT * FROM pages WHERE id = '421'
294 0.0001 0.00013899803161621
SELECT * FROM pages WHERE id = '426'
295 0.0002 0.0001530647277832
SELECT * FROM pages WHERE id = '430'
296 0.0001 0.00014305114746094
SELECT * FROM pages WHERE id = '431'
297 0.0002 0.00015687942504883
SELECT * FROM pages WHERE id = '434'
298 0.0002 0.00015401840209961
SELECT * FROM pages WHERE id = '435'
299 0.0002 0.00015902519226074
SELECT * FROM pages WHERE id = '440'
300 0.0002 0.00015902519226074
SELECT * FROM pages WHERE id = '441'
301 0.0002 0.00015807151794434
SELECT * FROM pages WHERE id = '451'
302 0.0001 0.00014185905456543
SELECT * FROM pages WHERE id = '453'
303 0.0001 0.00013899803161621
SELECT * FROM sideboxes_pages WHERE sidebox_id = '37'
304 0.0002 0.0001680850982666
SELECT * FROM pages WHERE id = '146'
305 0.0001 0.00014781951904297
SELECT * FROM pages WHERE id = '158'
306 0.0001 0.00014090538024902
SELECT * FROM pages WHERE id = '163'
307 0.0002 0.00021600723266602
SELECT * FROM pages WHERE id = '293'
308 0.0001 0.00014877319335938
SELECT * FROM pages WHERE id = '340'
309 0.0002 0.00015401840209961
SELECT * FROM pages WHERE id = '417'
310 0.0001 0.00013899803161621
SELECT * FROM sideboxes_pages WHERE sidebox_id = '40'
311 0.0002 0.00016307830810547
SELECT * FROM pages WHERE id = '173'
312 0.0002 0.00016498565673828
SELECT * FROM pages WHERE id = '181'
313 0.0001 0.00014615058898926
SELECT * FROM pages WHERE id = '288'
314 0.0002 0.0001518726348877
SELECT * FROM pages WHERE id = '299'
315 0.0002 0.0001530647277832
SELECT * FROM pages WHERE id = '300'
316 0.0001 0.00014710426330566
SELECT * FROM pages WHERE id = '383'
317 0.0001 0.00014019012451172
SELECT * FROM pages WHERE id = '385'
318 0.0002 0.00015497207641602
SELECT * FROM pages WHERE id = '438'
319 0.0002 0.0001521110534668
SELECT * FROM pages WHERE id = '442'
320 0.0001 0.00014209747314453
SELECT * FROM sideboxes_pages WHERE sidebox_id = '38'
321 0.0002 0.00022101402282715
SELECT * FROM pages WHERE id = '103'
322 0.0002 0.00020599365234375
SELECT * FROM pages WHERE id = '134'
323 0.0002 0.00015401840209961
SELECT * FROM pages WHERE id = '139'
324 0.0002 0.00015711784362793
SELECT * FROM pages WHERE id = '143'
325 0.0002 0.00015497207641602
SELECT * FROM pages WHERE id = '234'
326 0.0002 0.00015687942504883
SELECT * FROM pages WHERE id = '248'
327 0.0001 0.00014805793762207
SELECT * FROM pages WHERE id = '260'
328 0.0002 0.00015115737915039
SELECT * FROM pages WHERE id = '398'
329 0.0002 0.00016283988952637
SELECT * FROM sideboxes_pages WHERE sidebox_id = '29'
330 0.0002 0.00016307830810547
SELECT * FROM pages WHERE id = '61'
331 0.0002 0.00015902519226074
SELECT * FROM pages WHERE id = '87'
332 0.0002 0.00015592575073242
SELECT * FROM pages WHERE id = '104'
333 0.0002 0.00019097328186035
SELECT * FROM pages WHERE id = '115'
334 0.0001 0.00014996528625488
SELECT * FROM pages WHERE id = '124'
335 0.0002 0.00015997886657715
SELECT * FROM pages WHERE id = '144'
336 0.0002 0.00017380714416504
SELECT * FROM pages WHERE id = '151'
337 0.0001 0.0001370906829834
SELECT * FROM pages WHERE id = '199'
338 0.0001 0.00014901161193848
SELECT * FROM pages WHERE id = '200'
339 0.0001 0.00014400482177734
SELECT * FROM pages WHERE id = '304'
340 0.0002 0.00015115737915039
SELECT * FROM pages WHERE id = '321'
341 0.0001 0.00014615058898926
SELECT * FROM pages WHERE id = '333'
342 0.0002 0.00015401840209961
SELECT * FROM pages WHERE id = '350'
343 0.0001 0.00014615058898926
SELECT * FROM pages WHERE id = '378'
344 0.0001 0.00014710426330566
SELECT * FROM pages WHERE id = '422'
345 0.0002 0.00017094612121582
SELECT * FROM pages WHERE id = '425'
346 0.0002 0.0001521110534668
SELECT * FROM pages WHERE id = '443'
347 0.0001 0.00014400482177734
SELECT * FROM pages WHERE id = '444'
348 0.0001 0.00014400482177734
SELECT * FROM pages WHERE id = '445'
349 0.0001 0.00014281272888184
SELECT * FROM pages WHERE id = '446'
350 0.0001 0.00014185905456543
SELECT * FROM pages WHERE id = '447'
351 0.0001 0.00014591217041016
SELECT * FROM pages WHERE id = '448'
352 0.0002 0.00015616416931152
SELECT * FROM pages WHERE id = '455'
353 0.0002 0.00015115737915039
SELECT * FROM pages WHERE id = '456'
354 0.0001 0.00013899803161621
SELECT * FROM pages WHERE id = '459'
355 0.0002 0.00015616416931152
SELECT * FROM pages WHERE id = '460'
356 0.0001 0.00014519691467285
SELECT * FROM pages WHERE id = '462'
357 0.0001 0.00014114379882812
SELECT * FROM sideboxes_pages WHERE sidebox_id = '32'
358 0.0002 0.00017595291137695
SELECT * FROM pages WHERE id = '153'
359 0.0002 0.00018906593322754
SELECT * FROM pages WHERE id = '182'
360 0.0001 0.00014710426330566
SELECT * FROM pages WHERE id = '238'
361 0.0001 0.00014209747314453
SELECT * FROM pages WHERE id = '240'
362 0.0001 0.0001370906829834
SELECT * FROM pages WHERE id = '242'
363 0.0001 0.00013589859008789
SELECT * FROM pages WHERE id = '252'
364 0.0001 0.00014781951904297
SELECT * FROM pages WHERE id = '253'
365 0.0001 0.00013995170593262
SELECT * FROM pages WHERE id = '262'
366 0.0001 0.00013613700866699
SELECT * FROM pages WHERE id = '267'
367 0.0001 0.00014591217041016
SELECT * FROM pages WHERE id = '420'
368 0.0001 0.00012993812561035
SELECT value FROM parameters WHERE parameter = 'GOOGLE_SITE_KEY' 
369 0.0001 0.00012016296386719
SELECT value FROM parameters WHERE parameter = 'GOOGLE_SECRET_KEY' 
370 0.0001 0.00012779235839844
SELECT value FROM parameters WHERE parameter = 'GOOGLE_RECAPTCHA_TYPE' 
371 0.4121 0.41207003593445
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
372 0.0004 0.00035190582275391
SELECT * FROM pages WHERE pagename = 'crkt-innovation-field-strip-technology'
373 0.0891 0.08909797668457
SELECT * FROM template_info WHERE templateuid = 'fsb-fluid'
374 0.0003 0.00028491020202637
SELECT * FROM pages WHERE id = 2
375 0.0002 0.00017881393432617
SELECT * FROM pages WHERE id = 4
376 0.0002 0.00016999244689941
SELECT * FROM pages WHERE id = 12
377 0.0002 0.00015497207641602
SELECT * FROM pages WHERE id = 10
378 0.0001 0.00014495849609375
SELECT * FROM pages WHERE id = 7
379 0.0002 0.00015711784362793
SELECT * FROM pages WHERE id = 18
380 0.0001 0.00014209747314453
SELECT * FROM pages WHERE id = 28
381 0.0001 0.00014400482177734
SELECT * FROM pages WHERE id = 13
382 0.0001 0.00013613700866699
SELECT * FROM pages WHERE id = 3
383 0.0271 0.027101039886475
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
384 0.0003 0.00026607513427734
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:1563377780;s:8:\"products\";a:6:{i:0;s:6:\"398858\";i:1;s:6:\"410588\";i:3;s:6:\"414321\";i:4;s:6:\"131163\";i:6;s:6:\"404868\";i:21;s:6:\"104029\";}}' WHERE id = '175'
385 0.0005 0.00046205520629883
SELECT * FROM products WHERE id IN (398858,410588,414321,131163,404868,104029) ORDER BY FIELD(id, 398858,410588,414321,131163,404868,104029 )
386 0.0002 0.00020790100097656
SELECT * FROM productimages WHERE product_id = '398858' ORDER BY sortorder ASC
387 0.0002 0.00022196769714355
SELECT * FROM product_image_select WHERE product_id = '398858'
388 0.0001 0.00012612342834473
SELECT * FROM productcustomimages WHERE product_id = '398858'
389 0.0031 0.003101110458374
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '398858' AND a.name = n.originalname
390 0.0002 0.00019192695617676
SELECT * FROM productoffers WHERE product_id = '398858' AND merchantid = 'ATVPDKIKX0DER'
391 0.0002 0.00021505355834961
SELECT * FROM productoffers
                WHERE product_id = '398858' AND price > 0
                ORDER BY price ASC LIMIT 1
392 0.0004 0.00042915344238281
SELECT value FROM productattributes WHERE product_id = '398858' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
393 0.0001 0.00012397766113281
UPDATE products SET price = '2999' WHERE id = '398858'
394 0.0002 0.00018692016601562
SELECT * FROM productimages WHERE product_id = '410588' ORDER BY sortorder ASC
395 0.0002 0.00021004676818848
SELECT * FROM product_image_select WHERE product_id = '410588'
396 0.0001 0.0001380443572998
SELECT * FROM productcustomimages WHERE product_id = '410588'
397 0.0020 0.0020229816436768
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '410588' AND a.name = n.originalname
398 0.0002 0.00018692016601562
SELECT * FROM productoffers WHERE product_id = '410588' AND merchantid = 'ATVPDKIKX0DER'
399 0.0002 0.00020408630371094
SELECT * FROM productoffers
                WHERE product_id = '410588' AND price > 0
                ORDER BY price ASC LIMIT 1
400 0.0004 0.00035905838012695
SELECT value FROM productattributes WHERE product_id = '410588' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
401 0.0003 0.00025510787963867
UPDATE products SET price = '269999' WHERE id = '410588'
402 0.0003 0.0002741813659668
SELECT * FROM productimages WHERE product_id = '414321' ORDER BY sortorder ASC
403 0.0002 0.0002129077911377
SELECT * FROM product_image_select WHERE product_id = '414321'
404 0.0001 0.00012302398681641
SELECT * FROM productcustomimages WHERE product_id = '414321'
405 0.0025 0.002485990524292
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '414321' AND a.name = n.originalname
406 0.0002 0.00018501281738281
SELECT * FROM productoffers WHERE product_id = '414321' AND merchantid = 'ATVPDKIKX0DER'
407 0.0002 0.00020098686218262
SELECT * FROM productoffers
                WHERE product_id = '414321' AND price > 0
                ORDER BY price ASC LIMIT 1
408 0.0004 0.00042510032653809
SELECT value FROM productattributes WHERE product_id = '414321' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
409 0.0002 0.00015592575073242
UPDATE products SET price = '9999' WHERE id = '414321'
410 0.0003 0.00026202201843262
SELECT * FROM productimages WHERE product_id = '131163' ORDER BY sortorder ASC
411 0.0002 0.00022697448730469
SELECT * FROM product_image_select WHERE product_id = '131163'
412 0.0001 0.00012612342834473
SELECT * FROM productcustomimages WHERE product_id = '131163'
413 0.0025 0.0025370121002197
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '131163' AND a.name = n.originalname
414 0.0002 0.00019001960754395
SELECT * FROM productoffers WHERE product_id = '131163' AND merchantid = 'ATVPDKIKX0DER'
415 0.0002 0.00020694732666016
SELECT * FROM productoffers
                WHERE product_id = '131163' AND price > 0
                ORDER BY price ASC LIMIT 1
416 0.0004 0.0003812313079834
SELECT value FROM productattributes WHERE product_id = '131163' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
417 0.0001 0.00012302398681641
UPDATE products SET price = '18946' WHERE id = '131163'
418 0.0003 0.0003211498260498
SELECT * FROM productimages WHERE product_id = '404868' ORDER BY sortorder ASC
419 0.0002 0.00021004676818848
SELECT * FROM product_image_select WHERE product_id = '404868'
420 0.0001 0.00012302398681641
SELECT * FROM productcustomimages WHERE product_id = '404868'
421 0.0030 0.0029990673065186
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '404868' AND a.name = n.originalname
422 0.0002 0.00018310546875
SELECT * FROM productoffers WHERE product_id = '404868' AND merchantid = 'ATVPDKIKX0DER'
423 0.0002 0.00020694732666016
SELECT * FROM productoffers
                WHERE product_id = '404868' AND price > 0
                ORDER BY price ASC LIMIT 1
424 0.0004 0.00040602684020996
SELECT value FROM productattributes WHERE product_id = '404868' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
425 0.0001 0.00012087821960449
UPDATE products SET price = '46999' WHERE id = '404868'
426 0.0003 0.00025701522827148
SELECT * FROM productimages WHERE product_id = '104029' ORDER BY sortorder ASC
427 0.0002 0.00022196769714355
SELECT * FROM product_image_select WHERE product_id = '104029'
428 0.0001 0.00012302398681641
SELECT * FROM productcustomimages WHERE product_id = '104029'
429 0.0031 0.0030701160430908
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '104029' AND a.name = n.originalname
430 0.0002 0.00018715858459473
SELECT * FROM productoffers WHERE product_id = '104029' AND merchantid = 'ATVPDKIKX0DER'
431 0.0002 0.00020408630371094
SELECT * FROM productoffers
                WHERE product_id = '104029' AND price > 0
                ORDER BY price ASC LIMIT 1
432 0.0004 0.00041913986206055
SELECT value FROM productattributes WHERE product_id = '104029' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
433 0.0001 0.00012803077697754
UPDATE products SET price = '9700' WHERE id = '104029'
434 0.0086 0.0086309909820557
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
435 0.0002 0.00022101402282715
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:1563377780;s:8:\"products\";a:6:{i:1;s:6:\"410588\";i:6;s:6:\"404868\";i:7;s:6:\"402058\";i:12;s:6:\"267285\";i:14;s:6:\"123223\";i:23;s:6:\"412561\";}}' WHERE id = '177'
436 0.0004 0.00042009353637695
SELECT * FROM products WHERE id IN (410588,404868,402058,267285,123223,412561) ORDER BY FIELD(id, 410588,404868,402058,267285,123223,412561 )
437 0.0002 0.00020503997802734
SELECT * FROM productimages WHERE product_id = '410588' ORDER BY sortorder ASC
438 0.0002 0.00020503997802734
SELECT * FROM product_image_select WHERE product_id = '410588'
439 0.0001 0.00012397766113281
SELECT * FROM productcustomimages WHERE product_id = '410588'
440 0.0020 0.0020439624786377
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '410588' AND a.name = n.originalname
441 0.0002 0.00018811225891113
SELECT * FROM productoffers WHERE product_id = '410588' AND merchantid = 'ATVPDKIKX0DER'
442 0.0002 0.00020694732666016
SELECT * FROM productoffers
                WHERE product_id = '410588' AND price > 0
                ORDER BY price ASC LIMIT 1
443 0.0004 0.00036311149597168
SELECT value FROM productattributes WHERE product_id = '410588' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
444 0.0001 0.00012397766113281
UPDATE products SET price = '269999' WHERE id = '410588'
445 0.0003 0.00029397010803223
SELECT * FROM productimages WHERE product_id = '404868' ORDER BY sortorder ASC
446 0.0002 0.00022220611572266
SELECT * FROM product_image_select WHERE product_id = '404868'
447 0.0001 0.00012397766113281
SELECT * FROM productcustomimages WHERE product_id = '404868'
448 0.0030 0.0029850006103516
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '404868' AND a.name = n.originalname
449 0.0002 0.00019001960754395
SELECT * FROM productoffers WHERE product_id = '404868' AND merchantid = 'ATVPDKIKX0DER'
450 0.0002 0.0001988410949707
SELECT * FROM productoffers
                WHERE product_id = '404868' AND price > 0
                ORDER BY price ASC LIMIT 1
451 0.0004 0.00041604042053223
SELECT value FROM productattributes WHERE product_id = '404868' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
452 0.0001 0.00012111663818359
UPDATE products SET price = '46999' WHERE id = '404868'
453 0.0003 0.00028395652770996
SELECT * FROM productimages WHERE product_id = '402058' ORDER BY sortorder ASC
454 0.0002 0.00020313262939453
SELECT * FROM product_image_select WHERE product_id = '402058'
455 0.0001 0.00013208389282227
SELECT * FROM productcustomimages WHERE product_id = '402058'
456 0.0029 0.0028560161590576
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '402058' AND a.name = n.originalname
457 0.0002 0.00019598007202148
SELECT * FROM productoffers WHERE product_id = '402058' AND merchantid = 'ATVPDKIKX0DER'
458 0.0002 0.00020408630371094
SELECT * FROM productoffers
                WHERE product_id = '402058' AND price > 0
                ORDER BY price ASC LIMIT 1
459 0.0003 0.00034689903259277
SELECT value FROM productattributes WHERE product_id = '402058' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
460 0.0001 0.00013279914855957
UPDATE products SET price = '19900' WHERE id = '402058'
461 0.0004 0.00037407875061035
SELECT * FROM productimages WHERE product_id = '267285' ORDER BY sortorder ASC
462 0.0002 0.00021910667419434
SELECT * FROM product_image_select WHERE product_id = '267285'
463 0.0001 0.00012302398681641
SELECT * FROM productcustomimages WHERE product_id = '267285'
464 0.0025 0.0024960041046143
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '267285' AND a.name = n.originalname
465 0.0002 0.00018596649169922
SELECT * FROM productoffers WHERE product_id = '267285' AND merchantid = 'ATVPDKIKX0DER'
466 0.0002 0.0001978874206543
SELECT * FROM productoffers
                WHERE product_id = '267285' AND price > 0
                ORDER BY price ASC LIMIT 1
467 0.0004 0.00037598609924316
SELECT value FROM productattributes WHERE product_id = '267285' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
468 0.0001 0.00012087821960449
UPDATE products SET price = '7999' WHERE id = '267285'
469 0.0003 0.00031685829162598
SELECT * FROM productimages WHERE product_id = '123223' ORDER BY sortorder ASC
470 0.0002 0.00020980834960938
SELECT * FROM product_image_select WHERE product_id = '123223'
471 0.0001 0.00013303756713867
SELECT * FROM productcustomimages WHERE product_id = '123223'
472 0.0027 0.0027179718017578
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '123223' AND a.name = n.originalname
473 0.0002 0.0001990795135498
SELECT * FROM productoffers WHERE product_id = '123223' AND merchantid = 'ATVPDKIKX0DER'
474 0.0002 0.0001988410949707
SELECT * FROM productoffers
                WHERE product_id = '123223' AND price > 0
                ORDER BY price ASC LIMIT 1
475 0.0004 0.00038599967956543
SELECT value FROM productattributes WHERE product_id = '123223' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
476 0.0001 0.00011801719665527
UPDATE products SET price = '19661' WHERE id = '123223'
477 0.0002 0.00018787384033203
SELECT * FROM productimages WHERE product_id = '412561' ORDER BY sortorder ASC
478 0.0002 0.00021100044250488
SELECT * FROM product_image_select WHERE product_id = '412561'
479 0.0001 0.00012111663818359
SELECT * FROM productcustomimages WHERE product_id = '412561'
480 0.0030 0.0030319690704346
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '412561' AND a.name = n.originalname
481 0.0002 0.00018596649169922
SELECT * FROM productoffers WHERE product_id = '412561' AND merchantid = 'ATVPDKIKX0DER'
482 0.0002 0.00020098686218262
SELECT * FROM productoffers
                WHERE product_id = '412561' AND price > 0
                ORDER BY price ASC LIMIT 1
483 0.0005 0.00046110153198242
SELECT value FROM productattributes WHERE product_id = '412561' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
484 0.0001 0.00012302398681641
UPDATE products SET price = '3499' WHERE id = '412561'
485 0.0236 0.023575067520142
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
486 0.0002 0.00022411346435547
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:1563377780;s:8:\"products\";a:6:{i:0;s:6:\"398858\";i:7;s:6:\"402058\";i:12;s:6:\"267285\";i:21;s:6:\"128892\";i:22;s:6:\"412561\";i:4;s:6:\"131163\";}}' WHERE id = '181'
487 0.0004 0.00041484832763672
SELECT * FROM products WHERE id IN (398858,402058,267285,128892,412561,131163) ORDER BY FIELD(id, 398858,402058,267285,128892,412561,131163 )
488 0.0002 0.00020599365234375
SELECT * FROM productimages WHERE product_id = '398858' ORDER BY sortorder ASC
489 0.0002 0.00020694732666016
SELECT * FROM product_image_select WHERE product_id = '398858'
490 0.0001 0.00012302398681641
SELECT * FROM productcustomimages WHERE product_id = '398858'
491 0.0030 0.0030429363250732
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '398858' AND a.name = n.originalname
492 0.0002 0.00019693374633789
SELECT * FROM productoffers WHERE product_id = '398858' AND merchantid = 'ATVPDKIKX0DER'
493 0.0002 0.00022506713867188
SELECT * FROM productoffers
                WHERE product_id = '398858' AND price > 0
                ORDER BY price ASC LIMIT 1
494 0.0004 0.00040912628173828
SELECT value FROM productattributes WHERE product_id = '398858' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
495 0.0001 0.00011897087097168
UPDATE products SET price = '2999' WHERE id = '398858'
496 0.0003 0.00028204917907715
SELECT * FROM productimages WHERE product_id = '402058' ORDER BY sortorder ASC
497 0.0002 0.00021505355834961
SELECT * FROM product_image_select WHERE product_id = '402058'
498 0.0001 0.00012302398681641
SELECT * FROM productcustomimages WHERE product_id = '402058'
499 0.0029 0.0028591156005859
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '402058' AND a.name = n.originalname
500 0.0002 0.00019407272338867
SELECT * FROM productoffers WHERE product_id = '402058' AND merchantid = 'ATVPDKIKX0DER'
501 0.0002 0.0001988410949707
SELECT * FROM productoffers
                WHERE product_id = '402058' AND price > 0
                ORDER BY price ASC LIMIT 1
502 0.0004 0.00035810470581055
SELECT value FROM productattributes WHERE product_id = '402058' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
503 0.0001 0.00011992454528809
UPDATE products SET price = '19900' WHERE id = '402058'
504 0.0003 0.00033998489379883
SELECT * FROM productimages WHERE product_id = '267285' ORDER BY sortorder ASC
505 0.0002 0.00020909309387207
SELECT * FROM product_image_select WHERE product_id = '267285'
506 0.0001 0.00013279914855957
SELECT * FROM productcustomimages WHERE product_id = '267285'
507 0.0025 0.0024900436401367
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '267285' AND a.name = n.originalname
508 0.0002 0.00018405914306641
SELECT * FROM productoffers WHERE product_id = '267285' AND merchantid = 'ATVPDKIKX0DER'
509 0.0002 0.00020599365234375
SELECT * FROM productoffers
                WHERE product_id = '267285' AND price > 0
                ORDER BY price ASC LIMIT 1
510 0.0004 0.00036501884460449
SELECT value FROM productattributes WHERE product_id = '267285' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
511 0.0001 0.00012111663818359
UPDATE products SET price = '7999' WHERE id = '267285'
512 0.0004 0.00040006637573242
SELECT * FROM productimages WHERE product_id = '128892' ORDER BY sortorder ASC
513 0.0002 0.00021505355834961
SELECT * FROM product_image_select WHERE product_id = '128892'
514 0.0001 0.0001220703125
SELECT * FROM productcustomimages WHERE product_id = '128892'
515 0.1179 0.11791610717773
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '128892' AND a.name = n.originalname
516 0.0003 0.00028300285339355
SELECT * FROM productoffers WHERE product_id = '128892' AND merchantid = 'ATVPDKIKX0DER'
517 0.0002 0.00024914741516113
SELECT * FROM productoffers
                WHERE product_id = '128892' AND price > 0
                ORDER BY price ASC LIMIT 1
518 0.0004 0.0003809928894043
SELECT value FROM productattributes WHERE product_id = '128892' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
519 0.0001 0.00014710426330566
UPDATE products SET price = '12482' WHERE id = '128892'
520 0.0002 0.00019598007202148
SELECT * FROM productimages WHERE product_id = '412561' ORDER BY sortorder ASC
521 0.0002 0.00023007392883301
SELECT * FROM product_image_select WHERE product_id = '412561'
522 0.0001 0.0001380443572998
SELECT * FROM productcustomimages WHERE product_id = '412561'
523 0.0031 0.003108024597168
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '412561' AND a.name = n.originalname
524 0.0002 0.0001990795135498
SELECT * FROM productoffers WHERE product_id = '412561' AND merchantid = 'ATVPDKIKX0DER'
525 0.0002 0.00021910667419434
SELECT * FROM productoffers
                WHERE product_id = '412561' AND price > 0
                ORDER BY price ASC LIMIT 1
526 0.0005 0.00047802925109863
SELECT value FROM productattributes WHERE product_id = '412561' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
527 0.0001 0.0001368522644043
UPDATE products SET price = '3499' WHERE id = '412561'
528 0.0002 0.00023984909057617
SELECT * FROM productimages WHERE product_id = '131163' ORDER BY sortorder ASC
529 0.0003 0.00026512145996094
SELECT * FROM product_image_select WHERE product_id = '131163'
530 0.0001 0.00013899803161621
SELECT * FROM productcustomimages WHERE product_id = '131163'
531 0.0025 0.0025460720062256
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '131163' AND a.name = n.originalname
532 0.0002 0.00020718574523926
SELECT * FROM productoffers WHERE product_id = '131163' AND merchantid = 'ATVPDKIKX0DER'
533 0.0002 0.00022101402282715
SELECT * FROM productoffers
                WHERE product_id = '131163' AND price > 0
                ORDER BY price ASC LIMIT 1
534 0.0004 0.0003960132598877
SELECT value FROM productattributes WHERE product_id = '131163' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
535 0.0001 0.00013518333435059
UPDATE products SET price = '18946' WHERE id = '131163'
536 0.0238 0.023812055587769
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
537 0.0003 0.00025701522827148
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:1563377780;s:8:\"products\";a:6:{i:12;s:6:\"267285\";i:13;s:6:\"328526\";i:17;s:6:\"182782\";i:22;s:6:\"412561\";i:1;s:6:\"410588\";i:3;s:6:\"414321\";}}' WHERE id = '183'
538 0.0005 0.00045990943908691
SELECT * FROM products WHERE id IN (267285,328526,182782,412561,410588,414321) ORDER BY FIELD(id, 267285,328526,182782,412561,410588,414321 )
539 0.0004 0.00038599967956543
SELECT * FROM productimages WHERE product_id = '267285' ORDER BY sortorder ASC
540 0.0002 0.00022292137145996
SELECT * FROM product_image_select WHERE product_id = '267285'
541 0.0001 0.00013613700866699
SELECT * FROM productcustomimages WHERE product_id = '267285'
542 0.0026 0.0025689601898193
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '267285' AND a.name = n.originalname
543 0.0002 0.0001978874206543
SELECT * FROM productoffers WHERE product_id = '267285' AND merchantid = 'ATVPDKIKX0DER'
544 0.0002 0.00021696090698242
SELECT * FROM productoffers
                WHERE product_id = '267285' AND price > 0
                ORDER BY price ASC LIMIT 1
545 0.0004 0.00041317939758301
SELECT value FROM productattributes WHERE product_id = '267285' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
546 0.0001 0.0001380443572998
UPDATE products SET price = '7999' WHERE id = '267285'
547 0.0003 0.00025296211242676
SELECT * FROM productimages WHERE product_id = '328526' ORDER BY sortorder ASC
548 0.0002 0.00021696090698242
SELECT * FROM product_image_select WHERE product_id = '328526'
549 0.0001 0.00013613700866699
SELECT * FROM productcustomimages WHERE product_id = '328526'
550 0.0019 0.0018751621246338
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '328526' AND a.name = n.originalname
551 0.0002 0.00020694732666016
SELECT * FROM productoffers WHERE product_id = '328526' AND merchantid = 'ATVPDKIKX0DER'
552 0.0002 0.0002140998840332
SELECT * FROM productoffers
                WHERE product_id = '328526' AND price > 0
                ORDER BY price ASC LIMIT 1
553 0.0004 0.00036716461181641
SELECT value FROM productattributes WHERE product_id = '328526' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
554 0.0001 0.00013399124145508
UPDATE products SET price = '9999' WHERE id = '328526'
555 0.0004 0.00041413307189941
SELECT * FROM productimages WHERE product_id = '182782' ORDER BY sortorder ASC
556 0.0002 0.0002288818359375
SELECT * FROM product_image_select WHERE product_id = '182782'
557 0.0001 0.00013494491577148
SELECT * FROM productcustomimages WHERE product_id = '182782'
558 0.0028 0.0028119087219238
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '182782' AND a.name = n.originalname
559 0.0002 0.00019097328186035
SELECT * FROM productoffers WHERE product_id = '182782' AND merchantid = 'ATVPDKIKX0DER'
560 0.0002 0.0002288818359375
SELECT * FROM productoffers
                WHERE product_id = '182782' AND price > 0
                ORDER BY price ASC LIMIT 1
561 0.0004 0.00042986869812012
SELECT value FROM productattributes WHERE product_id = '182782' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
562 0.0001 0.00013399124145508
UPDATE products SET price = '11520' WHERE id = '182782'
563 0.0002 0.00024580955505371
SELECT * FROM productimages WHERE product_id = '412561' ORDER BY sortorder ASC
564 0.0002 0.00022196769714355
SELECT * FROM product_image_select WHERE product_id = '412561'
565 0.0001 0.00013494491577148
SELECT * FROM productcustomimages WHERE product_id = '412561'
566 0.0030 0.0030028820037842
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '412561' AND a.name = n.originalname
567 0.0002 0.00019311904907227
SELECT * FROM productoffers WHERE product_id = '412561' AND merchantid = 'ATVPDKIKX0DER'
568 0.0002 0.00021815299987793
SELECT * FROM productoffers
                WHERE product_id = '412561' AND price > 0
                ORDER BY price ASC LIMIT 1
569 0.0005 0.00045585632324219
SELECT value FROM productattributes WHERE product_id = '412561' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
570 0.0001 0.00013399124145508
UPDATE products SET price = '3499' WHERE id = '412561'
571 0.0002 0.00019598007202148
SELECT * FROM productimages WHERE product_id = '410588' ORDER BY sortorder ASC
572 0.0002 0.00022602081298828
SELECT * FROM product_image_select WHERE product_id = '410588'
573 0.0001 0.00013995170593262
SELECT * FROM productcustomimages WHERE product_id = '410588'
574 0.0020 0.0020308494567871
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '410588' AND a.name = n.originalname
575 0.0002 0.00019502639770508
SELECT * FROM productoffers WHERE product_id = '410588' AND merchantid = 'ATVPDKIKX0DER'
576 0.0002 0.00022006034851074
SELECT * FROM productoffers
                WHERE product_id = '410588' AND price > 0
                ORDER BY price ASC LIMIT 1
577 0.0004 0.00038695335388184
SELECT value FROM productattributes WHERE product_id = '410588' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
578 0.0001 0.00013303756713867
UPDATE products SET price = '269999' WHERE id = '410588'
579 0.0002 0.00023198127746582
SELECT * FROM productimages WHERE product_id = '414321' ORDER BY sortorder ASC
580 0.0002 0.00022697448730469
SELECT * FROM product_image_select WHERE product_id = '414321'
581 0.0001 0.00014400482177734
SELECT * FROM productcustomimages WHERE product_id = '414321'
582 0.0025 0.0024890899658203
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '414321' AND a.name = n.originalname
583 0.0002 0.00019311904907227
SELECT * FROM productoffers WHERE product_id = '414321' AND merchantid = 'ATVPDKIKX0DER'
584 0.0002 0.00022315979003906
SELECT * FROM productoffers
                WHERE product_id = '414321' AND price > 0
                ORDER BY price ASC LIMIT 1
585 0.0004 0.0003969669342041
SELECT value FROM productattributes WHERE product_id = '414321' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
586 0.0001 0.00013303756713867
UPDATE products SET price = '9999' WHERE id = '414321'
587 0.0004 0.00043892860412598
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid' AND area = 'header' ORDER BY sortorder ASC
588 0.0001 0.00014805793762207
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
589 0.0001 0.0001368522644043
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
590 0.0001 0.00013494491577148
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
591 0.0004 0.00042605400085449
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid' AND area = 'footer' ORDER BY sortorder ASC
592 0.0001 0.00013899803161621
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
593 0.0001 0.00013518333435059
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
594 0.0010 0.00097107887268066
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-fluid' AND skinuid = ''
595 0.0003 0.00033903121948242
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid'
596 0.0003 0.00030112266540527
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid'
597 0.0004 0.00037503242492676
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid' AND imageuid = 'FB_DEFAULT_SHARE_IMAGE'
598 0.0001 0.00013613700866699
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
599 0.0002 0.00022411346435547
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
600 0.0001 0.00012683868408203
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
601 0.0001 0.00012302398681641
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
602 0.0001 0.0001220703125
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
603 0.0003 0.00034785270690918
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid' AND imageuid = 'HEAD_CUSTOM_BANNER'
604 0.0003 0.00033402442932129
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid' AND imageuid = 'HEAD_CUSTOM_BANNER'