Tactical Equipment - Survivalist Equipment

Bushnell Rifle Scopes

bushnell rifle scopes for sale

UPDATED :  

Bushnell AR/6.5 Creedmoor 4.5-18X 40mm

BUSHNELL IS ADDING NEW SPECIALIZED PRODUCTS TO ITS OPTICS LINE all the time, and one of the most useful recent introductions taps into the immense popularity of the 6.5 Creedmoor cartridge.

Bushnell's new scope is called the AR/6.5 Creedmoor, and it's designed for the long-range capabilities of this excellent round. The power range is an impressive 4.5 to 18, and the scope has a reticle specifically developed for the 6.5 Creedmoor cartridge. Here's how it works.

Along the vertical crosshair are four dots below the intersection; these plus the thick part of the crosshair below the dots give five calibrated aiming points. Sighted-in at 100 yards, the dots, going down ; from the intersection, are aiming points for 200, 300, 400, and 500 yards respectively.

The top of the thick part of the stadia is for 600 yards. These points are designed to correspond pretty closely to the trajectory of full-power 6.5 Creedmoor ammo. On the range, as best as I could measure, the distance between the dots at 100 yards is 1.5, 3.7, 6.4, 9.4, and 12.7 inches for the 200- to 600-yard aiming points.

These values should be confirmed with the shooter's loads and rifle, of course. This is a clean reticle, without a lot of distracting hash marks.

The matte black scope is 12.4 inches long, weighs 21.5 ounces, and has crisp 0.25-MOA click adjustments. There are 50 MOA of adjustment for windage and elevation, which ought to be plenty for long-range shooting.

It has a side parallax adjustment from 25 yards to infinity. The lenses are fully multicoated, and the field of view is 22 feet at 100 yards at 4.5X and 7.3 feet at 18X.

The eye relief is a comfortable 3.7 inches and is relatively constant throughout the power range, although it shrinks a little at the highest powers. The reticle is in the second focal plane, which means the distances between the dots are only correct at the highest power.

However, the clever rifleman can "tweak" this to his own needs by adjusting the power, noting the distances subtended at various ranges, and then making a cheat sheet compatible with the values for his load.

Bushnell AR15 6.5 Creedmore 4.5 18x40mm scope

AR/6.5 CREEDMOOR 4.5-18X 40MM SPECIFICATIONS
MANUFACTURER Bushnell bushnell.com
MAGNIFICATION 4.5X to 18X
OBJECTIVE LENS DIAMETER 40mm
TUBE DIAMETER 1 in.
EYE RELIEF 3.7 in.
FIELD OF VIEW 22 to 7.3 ft. @ 100 yds.
ADJUSTMENT CLICKS 0.25 MOA
ELEVATION ADJUSTMENT RANGE 50 MOA
WINDAGE ADJUSTMENT RANGE 50 MOA
LENGTH 12.4 in.
WEIGHT 21.5 OZ.
FINISH Matte black

Debug Overview

App Total Time DB Queries DB Query Total Time Amazon Requests
1.6045439243317 933 0.7346 0


No Amazon API Requests Made.


App Debug - Total Time 1.6045439243317 seconds

Number Time From Start Name Description
1 0.50133013725281 Initialise Initialise FSB Function
2 0.51287508010864 App Controller Start Start of the App controller (called before the controller of every page)
3 0.58077692985535 App Controller End End of the App controller (called before the controller of every page)
4 0.58091711997986 Category Start Start of the category controller
5 0.58092093467712 Before Get Category Before getting the category information
6 0.60928392410278 After Get Category After getting the category information
7 0.60928511619568 Before Get Category List Before getting the updated category list
8 0.60958814620972 Start of getCategoryListByGroup Function Before first category groups query
9 0.60977005958557 After initial query Before first category groups query
10 0.6097719669342 Get Category List for Group Before the call to getCategoryList function
11 0.60978007316589 Start of GetCategoryList function Start of the function
12 0.60978507995605 Before getting categories Query to get specific category list
13 0.61041307449341 After getting categories Query to get specific category list
14 0.61041498184204 Before getting category custom Before call to function getCategoryCustom
15 0.61234092712402 After getting category custom After call to function getCategoryCustom
16 0.61234402656555 Before getting category custom Before call to function getCategoryCustom
17 0.62299513816833 After getting category custom After call to function getCategoryCustom
18 0.6229989528656 Before getting category custom Before call to function getCategoryCustom
19 0.62863993644714 After getting category custom After call to function getCategoryCustom
20 0.62864303588867 Before getting category custom Before call to function getCategoryCustom
21 0.63288998603821 After getting category custom After call to function getCategoryCustom
22 0.63289308547974 End of GetCategoryList function End of the function
23 0.63290214538574 Get Category List for Group Before the call to getCategoryList function
24 0.63290405273438 Start of GetCategoryList function Start of the function
25 0.6329071521759 Before getting categories Query to get specific category list
26 0.63335800170898 After getting categories Query to get specific category list
27 0.6333589553833 Before getting category custom Before call to function getCategoryCustom
28 0.63903403282166 After getting category custom After call to function getCategoryCustom
29 0.63903713226318 Before getting category custom Before call to function getCategoryCustom
30 0.64970302581787 After getting category custom After call to function getCategoryCustom
31 0.6497061252594 End of GetCategoryList function End of the function
32 0.64971303939819 Get Category List for Group Before the call to getCategoryList function
33 0.64971494674683 Start of GetCategoryList function Start of the function
34 0.64971995353699 Before getting categories Query to get specific category list
35 0.65057802200317 After getting categories Query to get specific category list
36 0.65057992935181 Before getting category custom Before call to function getCategoryCustom
37 0.65999794006348 After getting category custom After call to function getCategoryCustom
38 0.660001039505 Before getting category custom Before call to function getCategoryCustom
39 0.67747092247009 After getting category custom After call to function getCategoryCustom
40 0.67747402191162 Before getting category custom Before call to function getCategoryCustom
41 0.68350696563721 After getting category custom After call to function getCategoryCustom
42 0.68351006507874 Before getting category custom Before call to function getCategoryCustom
43 0.68954014778137 After getting category custom After call to function getCategoryCustom
44 0.68954300880432 Before getting category custom Before call to function getCategoryCustom
45 0.6959171295166 After getting category custom After call to function getCategoryCustom
46 0.69591999053955 Before getting category custom Before call to function getCategoryCustom
47 0.71800899505615 After getting category custom After call to function getCategoryCustom
48 0.71801209449768 Before getting sub category list Before call to recursive function getCategoryList
49 0.71801495552063 Start of GetCategoryList function Start of the function
50 0.71801805496216 Before getting categories Query to get specific category list
51 0.71845698356628 After getting categories Query to get specific category list
52 0.7184579372406 Before getting category custom Before call to function getCategoryCustom
53 0.72079300880432 After getting category custom After call to function getCategoryCustom
54 0.72079396247864 Before getting sub category list Before call to recursive function getCategoryList
55 0.72079610824585 Start of GetCategoryList function Start of the function
56 0.7207989692688 Before getting categories Query to get specific category list
57 0.72111201286316 After getting sub category list After call to recursive function getCategoryList
58 0.72111392021179 Before getting category custom Before call to function getCategoryCustom
59 0.72357392311096 After getting category custom After call to function getCategoryCustom
60 0.72357511520386 Before getting sub category list Before call to recursive function getCategoryList
61 0.72357702255249 Start of GetCategoryList function Start of the function
62 0.72358012199402 Before getting categories Query to get specific category list
63 0.72390604019165 After getting sub category list After call to recursive function getCategoryList
64 0.72390794754028 Before getting category custom Before call to function getCategoryCustom
65 0.72534203529358 After getting category custom After call to function getCategoryCustom
66 0.72534513473511 Before getting sub category list Before call to recursive function getCategoryList
67 0.72534608840942 Start of GetCategoryList function Start of the function
68 0.72534894943237 Before getting categories Query to get specific category list
69 0.72568511962891 After getting sub category list After call to recursive function getCategoryList
70 0.72568702697754 Before getting category custom Before call to function getCategoryCustom
71 0.72743391990662 After getting category custom After call to function getCategoryCustom
72 0.72743511199951 Before getting sub category list Before call to recursive function getCategoryList
73 0.72743701934814 Start of GetCategoryList function Start of the function
74 0.72744011878967 Before getting categories Query to get specific category list
75 0.72776198387146 After getting sub category list After call to recursive function getCategoryList
76 0.72776412963867 Before getting category custom Before call to function getCategoryCustom
77 0.73034906387329 After getting category custom After call to function getCategoryCustom
78 0.73035097122192 Before getting sub category list Before call to recursive function getCategoryList
79 0.73035192489624 Start of GetCategoryList function Start of the function
80 0.73035502433777 Before getting categories Query to get specific category list
81 0.73067498207092 After getting sub category list After call to recursive function getCategoryList
82 0.73067593574524 End of GetCategoryList function End of the function
83 0.73068594932556 After getting sub category list After call to recursive function getCategoryList
84 0.73068809509277 Before getting category custom Before call to function getCategoryCustom
85 0.73488092422485 After getting category custom After call to function getCategoryCustom
86 0.73488402366638 Before getting category custom Before call to function getCategoryCustom
87 0.73965001106262 After getting category custom After call to function getCategoryCustom
88 0.73965311050415 End of GetCategoryList function End of the function
89 0.73968410491943 Get Category List for Group Before the call to getCategoryList function
90 0.73968696594238 Start of GetCategoryList function Start of the function
91 0.73969006538391 Before getting categories Query to get specific category list
92 0.74013304710388 After getting categories Query to get specific category list
93 0.74013495445251 Before getting category custom Before call to function getCategoryCustom
94 0.74252009391785 After getting category custom After call to function getCategoryCustom
95 0.7425229549408 Before getting category custom Before call to function getCategoryCustom
96 0.74495005607605 After getting category custom After call to function getCategoryCustom
97 0.74495196342468 End of GetCategoryList function End of the function
98 0.74495911598206 Get Category List for Group Before the call to getCategoryList function
99 0.74496102333069 Start of GetCategoryList function Start of the function
100 0.74496412277222 Before getting categories Query to get specific category list
101 0.74529814720154 After getting categories Query to get specific category list
102 0.74530005455017 Before getting category custom Before call to function getCategoryCustom
103 0.75045800209045 After getting category custom After call to function getCategoryCustom
104 0.75046110153198 End of GetCategoryList function End of the function
105 0.75046801567078 End of getCategoryListByGroup Function Before return()
106 0.75047206878662 After Get Category List After getting the updated category list
107 0.75047302246094 Before Category Images Before getting the category images
108 0.7506000995636 After Category Images After getting the category images
109 0.75103712081909 Before Sub Category Check Before checking for sub category or products category
110 0.75133299827576 Before Category Products Controller Before loading the category products controller
111 0.75148892402649 Start Category Products Start of Category Products Controller
112 0.75151395797729 After Pagination Options After pagination options in Category Products Controller
113 0.75205492973328 After Cache After Cache checking in Category Products Controller
114 0.83310914039612 After Filter Options After getting filter options and SQL in Category Products Controller
115 0.83430409431458 After Counting Products After counting products in the Category Products Controller
116 0.83448791503906 After Counting Bundles After counting bundles in the Category Products Controller
117 0.83465909957886 After Counting Products After counting products in the Category Products Controller
118 0.83637809753418 After Getting Products After getting products and bundles in the Category Products Controller
119 0.83646512031555 After Pagination Links After getting pagination listing links in the Category Products Controller
120 0.83646893501282 After Getting Bundle Details After getting full details for the bundles in the Category Products Controller
121 0.92956900596619 After Getting Product Details After getting full product details in the Category Products Controller
122 0.93450093269348 After Getting Product/Bundle Reviews After getting full product/bundle customer review in the Category Products Controller
123 0.93584704399109 App_after Controller Start Start of the App_after controller (called after the controller of every page)
124 0.93593907356262 Before Get Options Before the call to getOptions in the tpl class
125 1.2780790328979 After Get Options After the call to getOptions in the tpl class
126 1.2784719467163 App_after Controller End End of the App_after controller (called after the controller of every page)
127 1.2784850597382 Before Smarty Before passing everything over to Smarty in the Category Products Controller
128 1.6045169830322 After Loading sub/product controller After checking for sub category or products category and then loading the relevant controller
129 1.6045250892639 Finalizing debug Before the debug is output to the page.
130 1.6045429706573 End of App This is the end of the app logging, final timestamp


Query Debug - 933 Database Queries. Total time 0.7346 seconds

Number Time (Seconds) Time (Milliseconds) Query
1 0.0002 0.00018405914306641
SELECT value FROM parameters WHERE `parameter` = 'BAD_BOTS_ENABLER'
2 0.0005 0.0004580020904541
SHOW TABLES LIKE 'bad_bots'
3 0.0002 0.00017189979553223
SELECT value FROM parameters WHERE `parameter` = 'STORE_WHITELISTED_IPS'
4 0.0002 0.0001671314239502
SELECT * FROM `bad_bots`
5 0.0004 0.00044703483581543
SELECT parameter, value FROM parameters
6 0.0001 0.00014805793762207
SET time_zone = 'Europe/London'
7 0.0003 0.00028395652770996
SELECT * FROM autorun ORDER BY lastrun ASC
8 0.0002 0.00015997886657715
SELECT * FROM version ORDER BY installed DESC LIMIT 1
9 0.0001 0.00010919570922852
delete from cachefiles
10 0.0002 0.00023317337036133
SELECT id FROM pages WHERE pagename = 'bushnell-rifle-scopes' LIMIT 1
11 0.0002 0.0002140998840332
SELECT id FROM products WHERE pagename = 'bushnell-rifle-scopes' AND hidden = 0 LIMIT 1
12 0.0001 0.00011992454528809
SELECT id FROM ebay_products WHERE pagename = 'bushnell-rifle-scopes'
13 0.0002 0.00016212463378906
SELECT id FROM categories WHERE pagename = 'bushnell-rifle-scopes' LIMIT 1
14 0.0009 0.00086307525634766
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-fluid'
15 0.0093 0.0092778205871582
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-fluid' AND language = 'en'
16 0.0002 0.00024294853210449
SELECT * FROM pages WHERE pagename = 'bushnell-rifle-scopes'
17 0.0053 0.0052688121795654
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
18 0.0004 0.00037384033203125
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-fluid' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
19 0.0002 0.00016999244689941
SELECT value FROM parameters WHERE parameter = 'EBAY_APP_ID' 
20 0.0002 0.00016593933105469
SELECT * FROM sideboxes_pages WHERE sidebox_id = '1'
21 0.0002 0.00017809867858887
SELECT * FROM pages WHERE id = '67'
22 0.0002 0.0001678466796875
SELECT * FROM pages WHERE id = '82'
23 0.0002 0.00019097328186035
SELECT * FROM pages WHERE id = '84'
24 0.0002 0.00016403198242188
SELECT * FROM pages WHERE id = '94'
25 0.0002 0.00017499923706055
SELECT * FROM pages WHERE id = '116'
26 0.0002 0.00023007392883301
SELECT * FROM pages WHERE id = '52'
27 0.0002 0.00017285346984863
SELECT * FROM pages WHERE id = '135'
28 0.0002 0.00016617774963379
SELECT * FROM pages WHERE id = '245'
29 0.0002 0.00017714500427246
SELECT * FROM pages WHERE id = '269'
30 0.0002 0.0002138614654541
SELECT * FROM pages WHERE id = '275'
31 0.0002 0.00019192695617676
SELECT * FROM pages WHERE id = '280'
32 0.0002 0.00023698806762695
SELECT * FROM pages WHERE id = '357'
33 0.0002 0.00015997886657715
SELECT * FROM pages WHERE id = '379'
34 0.0002 0.00015497207641602
SELECT * FROM pages WHERE id = '401'
35 0.0002 0.00016283988952637
SELECT * FROM pages WHERE id = '450'
36 0.0002 0.00016117095947266
SELECT * FROM pages WHERE id = '454'
37 0.0002 0.00018095970153809
SELECT * FROM pages WHERE id = '457'
38 0.0002 0.00017499923706055
SELECT * FROM pages WHERE id = '458'
39 0.0002 0.00016903877258301
SELECT * FROM sideboxes_pages WHERE sidebox_id = '2'
40 0.0002 0.00017809867858887
SELECT * FROM pages WHERE id = '41'
41 0.0002 0.00017285346984863
SELECT * FROM pages WHERE id = '43'
42 0.0002 0.00017189979553223
SELECT * FROM pages WHERE id = '44'
43 0.0002 0.00015783309936523
SELECT * FROM pages WHERE id = '68'
44 0.0002 0.0002291202545166
SELECT * FROM pages WHERE id = '80'
45 0.0002 0.00017309188842773
SELECT * FROM pages WHERE id = '85'
46 0.0002 0.00018787384033203
SELECT * FROM pages WHERE id = '97'
47 0.0002 0.00016999244689941
SELECT * FROM pages WHERE id = '107'
48 0.0002 0.0001678466796875
SELECT * FROM pages WHERE id = '108'
49 0.0002 0.00015616416931152
SELECT * FROM pages WHERE id = '128'
50 0.0002 0.00018095970153809
SELECT * FROM pages WHERE id = '133'
51 0.0002 0.00016903877258301
SELECT * FROM pages WHERE id = '148'
52 0.0002 0.00016999244689941
SELECT * FROM pages WHERE id = '217'
53 0.0002 0.00015497207641602
SELECT * FROM pages WHERE id = '228'
54 0.0002 0.00015997886657715
SELECT * FROM pages WHERE id = '257'
55 0.0002 0.00016403198242188
SELECT * FROM pages WHERE id = '271'
56 0.0002 0.00017380714416504
SELECT * FROM pages WHERE id = '286'
57 0.0002 0.00015902519226074
SELECT * FROM pages WHERE id = '287'
58 0.0002 0.00017380714416504
SELECT * FROM pages WHERE id = '291'
59 0.0002 0.0001680850982666
SELECT * FROM pages WHERE id = '380'
60 0.0002 0.0001671314239502
SELECT * FROM pages WHERE id = '344'
61 0.0002 0.00018906593322754
SELECT * FROM pages WHERE id = '354'
62 0.0002 0.00020694732666016
SELECT * FROM pages WHERE id = '363'
63 0.0002 0.00021195411682129
SELECT * FROM pages WHERE id = '364'
64 0.0002 0.00015592575073242
SELECT * FROM pages WHERE id = '368'
65 0.0002 0.00018405914306641
SELECT * FROM pages WHERE id = '369'
66 0.0002 0.00016212463378906
SELECT * FROM pages WHERE id = '400'
67 0.0002 0.0001680850982666
SELECT * FROM pages WHERE id = '463'
68 0.0002 0.00018215179443359
SELECT * FROM sideboxes_pages WHERE sidebox_id = '33'
69 0.0003 0.00028300285339355
SELECT * FROM pages WHERE id = '66'
70 0.0002 0.00020098686218262
SELECT * FROM pages WHERE id = '77'
71 0.0002 0.00019311904907227
SELECT * FROM pages WHERE id = '90'
72 0.0002 0.00015807151794434
SELECT * FROM pages WHERE id = '414'
73 0.0002 0.00015997886657715
SELECT * FROM pages WHERE id = '119'
74 0.0002 0.00017094612121582
SELECT * FROM pages WHERE id = '406'
75 0.0002 0.00016403198242188
SELECT * FROM pages WHERE id = '149'
76 0.0002 0.00015997886657715
SELECT * FROM pages WHERE id = '150'
77 0.0002 0.0001530647277832
SELECT * FROM pages WHERE id = '412'
78 0.0002 0.0001680850982666
SELECT * FROM pages WHERE id = '162'
79 0.0002 0.00015497207641602
SELECT * FROM pages WHERE id = '164'
80 0.0002 0.00017309188842773
SELECT * FROM pages WHERE id = '167'
81 0.0002 0.0001518726348877
SELECT * FROM pages WHERE id = '180'
82 0.0002 0.00015497207641602
SELECT * FROM pages WHERE id = '187'
83 0.0002 0.00020980834960938
SELECT * FROM pages WHERE id = '265'
84 0.0002 0.00016999244689941
SELECT * FROM pages WHERE id = '268'
85 0.0002 0.00015687942504883
SELECT * FROM pages WHERE id = '411'
86 0.0002 0.00016403198242188
SELECT * FROM pages WHERE id = '290'
87 0.0002 0.0001521110534668
SELECT * FROM pages WHERE id = '413'
88 0.0002 0.00015592575073242
SELECT * FROM pages WHERE id = '409'
89 0.0002 0.00016188621520996
SELECT * FROM pages WHERE id = '327'
90 0.0002 0.00017189979553223
SELECT * FROM pages WHERE id = '336'
91 0.0002 0.0001680850982666
SELECT * FROM pages WHERE id = '351'
92 0.0002 0.00015997886657715
SELECT * FROM pages WHERE id = '358'
93 0.0002 0.00016403198242188
SELECT * FROM pages WHERE id = '360'
94 0.0002 0.00016283988952637
SELECT * FROM pages WHERE id = '362'
95 0.0002 0.00019097328186035
SELECT * FROM pages WHERE id = '366'
96 0.0002 0.00017595291137695
SELECT * FROM pages WHERE id = '370'
97 0.0002 0.00016117095947266
SELECT * FROM pages WHERE id = '377'
98 0.0002 0.00016307830810547
SELECT * FROM pages WHERE id = '386'
99 0.0002 0.00017118453979492
SELECT * FROM pages WHERE id = '408'
100 0.0002 0.00015807151794434
SELECT * FROM pages WHERE id = '415'
101 0.0002 0.00016999244689941
SELECT * FROM pages WHERE id = '416'
102 0.0002 0.00021100044250488
SELECT * FROM pages WHERE id = '419'
103 0.0002 0.00016689300537109
SELECT * FROM pages WHERE id = '423'
104 0.0002 0.00017595291137695
SELECT * FROM pages WHERE id = '427'
105 0.0002 0.00021600723266602
SELECT * FROM pages WHERE id = '428'
106 0.0002 0.00015497207641602
SELECT * FROM pages WHERE id = '432'
107 0.0002 0.00015497207641602
SELECT * FROM pages WHERE id = '433'
108 0.0002 0.00016283988952637
SELECT * FROM pages WHERE id = '436'
109 0.0002 0.00016880035400391
SELECT * FROM pages WHERE id = '437'
110 0.0002 0.00016403198242188
SELECT * FROM pages WHERE id = '461'
111 0.0002 0.00019502639770508
SELECT * FROM pages WHERE id = '464'
112 0.0002 0.00016188621520996
SELECT * FROM sideboxes_pages WHERE sidebox_id = '34'
113 0.0002 0.00016403198242188
SELECT * FROM pages WHERE id = '74'
114 0.0002 0.00016999244689941
SELECT * FROM pages WHERE id = '137'
115 0.0002 0.00016498565673828
SELECT * FROM pages WHERE id = '145'
116 0.0002 0.00015997886657715
SELECT * FROM pages WHERE id = '156'
117 0.0002 0.00015687942504883
SELECT * FROM pages WHERE id = '407'
118 0.0002 0.00015592575073242
SELECT * FROM pages WHERE id = '410'
119 0.0002 0.00019311904907227
SELECT * FROM pages WHERE id = '266'
120 0.0003 0.00025010108947754
SELECT * FROM pages WHERE id = '316'
121 0.0002 0.00017094612121582
SELECT * FROM pages WHERE id = '332'
122 0.0002 0.00018906593322754
SELECT * FROM pages WHERE id = '334'
123 0.0002 0.00016593933105469
SELECT * FROM pages WHERE id = '367'
124 0.0002 0.00016307830810547
SELECT * FROM pages WHERE id = '387'
125 0.0002 0.00015902519226074
SELECT * FROM pages WHERE id = '389'
126 0.0002 0.00017094612121582
SELECT * FROM pages WHERE id = '397'
127 0.0002 0.00016880035400391
SELECT * FROM pages WHERE id = '449'
128 0.0002 0.00019001960754395
SELECT * FROM sideboxes_pages WHERE sidebox_id = '35'
129 0.0002 0.0002138614654541
SELECT * FROM pages WHERE id = '42'
130 0.0002 0.00016593933105469
SELECT * FROM pages WHERE id = '79'
131 0.0002 0.0001838207244873
SELECT * FROM pages WHERE id = '86'
132 0.0002 0.00015807151794434
SELECT * FROM pages WHERE id = '95'
133 0.0002 0.00017595291137695
SELECT * FROM pages WHERE id = '102'
134 0.0002 0.00015592575073242
SELECT * FROM pages WHERE id = '109'
135 0.0002 0.00023293495178223
SELECT * FROM pages WHERE id = '114'
136 0.0002 0.00020813941955566
SELECT * FROM pages WHERE id = '121'
137 0.0002 0.00021481513977051
SELECT * FROM pages WHERE id = '138'
138 0.0002 0.00016593933105469
SELECT * FROM pages WHERE id = '142'
139 0.0002 0.00020885467529297
SELECT * FROM pages WHERE id = '62'
140 0.0002 0.00015902519226074
SELECT * FROM pages WHERE id = '157'
141 0.0002 0.00016593933105469
SELECT * FROM pages WHERE id = '246'
142 0.0002 0.00022006034851074
SELECT * FROM pages WHERE id = '276'
143 0.0002 0.00019502639770508
SELECT * FROM pages WHERE id = '278'
144 0.0002 0.00022602081298828
SELECT * FROM pages WHERE id = '279'
145 0.0002 0.00017285346984863
SELECT * FROM pages WHERE id = '317'
146 0.0002 0.00017189979553223
SELECT * FROM pages WHERE id = '405'
147 0.0002 0.00018191337585449
SELECT * FROM pages WHERE id = '343'
148 0.0002 0.00016403198242188
SELECT * FROM pages WHERE id = '345'
149 0.0002 0.00020384788513184
SELECT * FROM pages WHERE id = '346'
150 0.0002 0.0001678466796875
SELECT * FROM pages WHERE id = '347'
151 0.0002 0.00017690658569336
SELECT * FROM pages WHERE id = '348'
152 0.0002 0.00016498565673828
SELECT * FROM pages WHERE id = '349'
153 0.0002 0.00016283988952637
SELECT * FROM pages WHERE id = '381'
154 0.0002 0.00017499923706055
SELECT * FROM pages WHERE id = '392'
155 0.0002 0.00015997886657715
SELECT * FROM pages WHERE id = '393'
156 0.0002 0.00016903877258301
SELECT * FROM pages WHERE id = '394'
157 0.0002 0.00016403198242188
SELECT * FROM pages WHERE id = '395'
158 0.0002 0.00017118453979492
SELECT * FROM pages WHERE id = '399'
159 0.0002 0.00017404556274414
SELECT * FROM pages WHERE id = '421'
160 0.0002 0.00015401840209961
SELECT * FROM pages WHERE id = '426'
161 0.0002 0.00016498565673828
SELECT * FROM pages WHERE id = '430'
162 0.0002 0.00015902519226074
SELECT * FROM pages WHERE id = '431'
163 0.0002 0.0001671314239502
SELECT * FROM pages WHERE id = '434'
164 0.0002 0.0001680850982666
SELECT * FROM pages WHERE id = '435'
165 0.0002 0.00017809867858887
SELECT * FROM pages WHERE id = '440'
166 0.0002 0.00017690658569336
SELECT * FROM pages WHERE id = '441'
167 0.0002 0.00017023086547852
SELECT * FROM pages WHERE id = '451'
168 0.0002 0.00015401840209961
SELECT * FROM pages WHERE id = '453'
169 0.0002 0.00015401840209961
SELECT * FROM sideboxes_pages WHERE sidebox_id = '37'
170 0.0002 0.00018501281738281
SELECT * FROM pages WHERE id = '146'
171 0.0002 0.00016093254089355
SELECT * FROM pages WHERE id = '158'
172 0.0002 0.00015592575073242
SELECT * FROM pages WHERE id = '163'
173 0.0002 0.00024890899658203
SELECT * FROM pages WHERE id = '293'
174 0.0002 0.00016093254089355
SELECT * FROM pages WHERE id = '340'
175 0.0002 0.00017499923706055
SELECT * FROM pages WHERE id = '417'
176 0.0002 0.00015592575073242
SELECT * FROM sideboxes_pages WHERE sidebox_id = '40'
177 0.0002 0.00017905235290527
SELECT * FROM pages WHERE id = '173'
178 0.0002 0.0001678466796875
SELECT * FROM pages WHERE id = '181'
179 0.0002 0.00015521049499512
SELECT * FROM pages WHERE id = '288'
180 0.0002 0.00017309188842773
SELECT * FROM pages WHERE id = '299'
181 0.0002 0.00016307830810547
SELECT * FROM pages WHERE id = '300'
182 0.0002 0.00016093254089355
SELECT * FROM pages WHERE id = '383'
183 0.0002 0.00015401840209961
SELECT * FROM pages WHERE id = '385'
184 0.0002 0.00015807151794434
SELECT * FROM pages WHERE id = '438'
185 0.0002 0.00018715858459473
SELECT * FROM pages WHERE id = '442'
186 0.0002 0.00015401840209961
SELECT * FROM sideboxes_pages WHERE sidebox_id = '38'
187 0.0003 0.00026297569274902
SELECT * FROM pages WHERE id = '103'
188 0.0002 0.00022506713867188
SELECT * FROM pages WHERE id = '134'
189 0.0002 0.00015807151794434
SELECT * FROM pages WHERE id = '139'
190 0.0002 0.00017404556274414
SELECT * FROM pages WHERE id = '143'
191 0.0002 0.0001671314239502
SELECT * FROM pages WHERE id = '234'
192 0.0002 0.00017380714416504
SELECT * FROM pages WHERE id = '248'
193 0.0002 0.00016498565673828
SELECT * FROM pages WHERE id = '260'
194 0.0002 0.00017619132995605
SELECT * FROM pages WHERE id = '398'
195 0.0002 0.00017189979553223
SELECT * FROM sideboxes_pages WHERE sidebox_id = '29'
196 0.0002 0.00017499923706055
SELECT * FROM pages WHERE id = '61'
197 0.0002 0.0001680850982666
SELECT * FROM pages WHERE id = '87'
198 0.0002 0.00017189979553223
SELECT * FROM pages WHERE id = '104'
199 0.0002 0.00023293495178223
SELECT * FROM pages WHERE id = '115'
200 0.0002 0.00015711784362793
SELECT * FROM pages WHERE id = '124'
201 0.0002 0.00016498565673828
SELECT * FROM pages WHERE id = '144'
202 0.0002 0.0001988410949707
SELECT * FROM pages WHERE id = '151'
203 0.0002 0.00015091896057129
SELECT * FROM pages WHERE id = '199'
204 0.0002 0.00016999244689941
SELECT * FROM pages WHERE id = '200'
205 0.0002 0.00015807151794434
SELECT * FROM pages WHERE id = '304'
206 0.0002 0.0001530647277832
SELECT * FROM pages WHERE id = '321'
207 0.0002 0.00015401840209961
SELECT * FROM pages WHERE id = '333'
208 0.0002 0.0001680850982666
SELECT * FROM pages WHERE id = '350'
209 0.0002 0.00016617774963379
SELECT * FROM pages WHERE id = '378'
210 0.0002 0.0001680850982666
SELECT * FROM pages WHERE id = '422'
211 0.0002 0.00019097328186035
SELECT * FROM pages WHERE id = '425'
212 0.0002 0.00015687942504883
SELECT * FROM pages WHERE id = '443'
213 0.0002 0.00015711784362793
SELECT * FROM pages WHERE id = '444'
214 0.0002 0.00016522407531738
SELECT * FROM pages WHERE id = '445'
215 0.0002 0.00015592575073242
SELECT * FROM pages WHERE id = '446'
216 0.0002 0.00015401840209961
SELECT * FROM pages WHERE id = '447'
217 0.0002 0.00015807151794434
SELECT * FROM pages WHERE id = '448'
218 0.0002 0.00016903877258301
SELECT * FROM pages WHERE id = '455'
219 0.0002 0.00017619132995605
SELECT * FROM pages WHERE id = '456'
220 0.0002 0.00015592575073242
SELECT * FROM pages WHERE id = '459'
221 0.0002 0.00017690658569336
SELECT * FROM pages WHERE id = '460'
222 0.0002 0.00015997886657715
SELECT * FROM pages WHERE id = '462'
223 0.0002 0.00015902519226074
SELECT * FROM sideboxes_pages WHERE sidebox_id = '32'
224 0.0002 0.00019216537475586
SELECT * FROM pages WHERE id = '153'
225 0.0002 0.00021600723266602
SELECT * FROM pages WHERE id = '182'
226 0.0002 0.00016093254089355
SELECT * FROM pages WHERE id = '238'
227 0.0002 0.00015497207641602
SELECT * FROM pages WHERE id = '240'
228 0.0001 0.00014996528625488
SELECT * FROM pages WHERE id = '242'
229 0.0002 0.00015783309936523
SELECT * FROM pages WHERE id = '252'
230 0.0002 0.0001530647277832
SELECT * FROM pages WHERE id = '253'
231 0.0002 0.00015020370483398
SELECT * FROM pages WHERE id = '262'
232 0.0002 0.00015091896057129
SELECT * FROM pages WHERE id = '267'
233 0.0002 0.00016307830810547
SELECT * FROM pages WHERE id = '420'
234 0.0002 0.0001518726348877
SELECT value FROM parameters WHERE parameter = 'GOOGLE_SITE_KEY' 
235 0.0001 0.00014019012451172
SELECT value FROM parameters WHERE parameter = 'GOOGLE_SECRET_KEY' 
236 0.0001 0.00012993812561035
SELECT value FROM parameters WHERE parameter = 'GOOGLE_RECAPTCHA_TYPE' 
237 0.0015 0.0014548301696777
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
238 0.0003 0.00025296211242676
SELECT * FROM categories WHERE pagename = 'bushnell-rifle-scopes'
239 0.0009 0.00088095664978027
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 = 130
240 0.0001 0.00012302398681641
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 130
241 0.0003 0.00027298927307129
SELECT id FROM categories WHERE parent_id = '130'
242 0.0008 0.00084280967712402
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (130)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
243 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 (130)
				  AND p.disabled = 0 
244 0.0002 0.00018310546875
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (130)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
245 0.0002 0.00016498565673828
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '130'
246 0.0002 0.0002439022064209
SELECT id FROM categories WHERE parent_id = '130'
247 0.0009 0.00087809562683105
SELECT p.id FROM products p, products_categories c WHERE p.id = c.product_id AND c.category_id IN (130) AND p.hidden = 0 AND p.salesrank > 0 AND (p.price > 0 OR p.parent = 1) ORDER BY p.salesrank ASC LIMIT 1
248 0.0003 0.00026607513427734
SELECT * FROM productimages WHERE product_id = '400671' ORDER BY sortorder ASC
249 0.0001 0.00011706352233887
SELECT * FROM categoryimages WHERE category_id = 130
250 0.0001 0.00014114379882812
SELECT * FROM categorygroups WHERE id = '1'
251 0.0008 0.00082206726074219
SELECT MIN(p.price) as minprice, MAX(p.price) as maxprice
		FROM products p, products_categories c
		WHERE p.id = c.product_id
		  AND c.category_id = '130'
		  AND p.offers > 0
		  AND p.hidden = 0
		  AND p.enabled = 1
		  AND p.parent = 0
		  AND p.price > 0
252 0.0001 0.00014185905456543
SELECT parent_id FROM categories WHERE id = '130'
253 0.0001 0.0001368522644043
SELECT parent_id FROM categories WHERE id = '34'
254 0.0003 0.00025105476379395
SELECT * FROM categories WHERE id = '34'
255 0.0096 0.0096220970153809
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
256 0.0001 0.00014400482177734
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 34
257 0.0003 0.00027203559875488
SELECT id FROM categories WHERE parent_id = '34'
258 0.0002 0.00022482872009277
SELECT id FROM categories WHERE parent_id = '94'
259 0.0002 0.00022697448730469
SELECT id FROM categories WHERE parent_id = '98'
260 0.0002 0.0002138614654541
SELECT id FROM categories WHERE parent_id = '99'
261 0.0002 0.0002129077911377
SELECT id FROM categories WHERE parent_id = '110'
262 0.0002 0.0002131462097168
SELECT id FROM categories WHERE parent_id = '130'
263 0.0102 0.010179996490479
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 
264 0.0002 0.00018405914306641
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (94,98,99,110,130,34)
				  AND p.disabled = 0 
265 0.0002 0.00016903877258301
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 
266 0.0002 0.00019311904907227
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '34'
267 0.0001 0.00013279914855957
SELECT parent_id FROM categories WHERE id = '130'
268 0.0001 0.0001370906829834
SELECT parent_id FROM categories WHERE id = '34'
269 0.0002 0.00016307830810547
SELECT * FROM categorygroups ORDER BY sortorder ASC
270 0.0005 0.00052309036254883
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
271 0.0005 0.00046515464782715
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
272 0.0003 0.00025010108947754
SELECT id FROM categories WHERE parent_id = '49'
273 0.0005 0.00045394897460938
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 
274 0.0002 0.00016403198242188
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (49)
				  AND p.disabled = 0 
275 0.0002 0.00015902519226074
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (49)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
276 0.0002 0.00018000602722168
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '49'
277 0.0001 0.00013399124145508
SELECT * FROM categorygroups WHERE id = '1'
278 0.0030 0.0029618740081787
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
279 0.0003 0.00027298927307129
SELECT id FROM categories WHERE parent_id = '50'
280 0.0002 0.00024294853210449
SELECT id FROM categories WHERE parent_id = '96'
281 0.0002 0.00021791458129883
SELECT id FROM categories WHERE parent_id = '97'
282 0.0002 0.0002138614654541
SELECT id FROM categories WHERE parent_id = '111'
283 0.0002 0.00021195411682129
SELECT id FROM categories WHERE parent_id = '129'
284 0.0057 0.0056731700897217
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 
285 0.0002 0.00017786026000977
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (96,97,111,129,50)
				  AND p.disabled = 0 
286 0.0002 0.00016617774963379
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (96,97,111,129,50)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
287 0.0002 0.00019502639770508
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '50'
288 0.0001 0.00013589859008789
SELECT * FROM categorygroups WHERE id = '1'
289 0.0023 0.0023069381713867
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
290 0.0003 0.00026798248291016
SELECT id FROM categories WHERE parent_id = '80'
291 0.0023 0.0023279190063477
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 
292 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 (80)
				  AND p.disabled = 0 
293 0.0002 0.00015902519226074
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (80)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
294 0.0002 0.00017309188842773
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '80'
295 0.0001 0.00013494491577148
SELECT * FROM categorygroups WHERE id = '1'
296 0.0012 0.0011699199676514
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
297 0.0003 0.00026082992553711
SELECT id FROM categories WHERE parent_id = '51'
298 0.0002 0.00021886825561523
SELECT id FROM categories WHERE parent_id = '101'
299 0.0018 0.0018179416656494
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 
300 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 (101,51)
				  AND p.disabled = 0 
301 0.0002 0.00016093254089355
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (101,51)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
302 0.0002 0.00019216537475586
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '51'
303 0.0001 0.00013494491577148
SELECT * FROM categorygroups WHERE id = '1'
304 0.0004 0.00041985511779785
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '2'  AND hidden = 0 ORDER BY sortorder ASC
305 0.0023 0.0023238658905029
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
306 0.0003 0.00026583671569824
SELECT id FROM categories WHERE parent_id = '30'
307 0.0023 0.0023190975189209
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 
308 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 (30)
				  AND p.disabled = 0 
309 0.0002 0.00015807151794434
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (30)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
310 0.0002 0.00018596649169922
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
311 0.0001 0.00013399124145508
SELECT * FROM categorygroups WHERE id = '2'
312 0.0048 0.0047690868377686
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
313 0.0003 0.00027704238891602
SELECT id FROM categories WHERE parent_id = '61'
314 0.0048 0.0048389434814453
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 
315 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 (61)
				  AND p.disabled = 0 
316 0.0002 0.00016093254089355
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (61)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
317 0.0002 0.00017809867858887
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '61'
318 0.0001 0.00014305114746094
SELECT * FROM categorygroups WHERE id = '2'
319 0.0007 0.00068902969360352
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '10'  AND hidden = 0 ORDER BY sortorder ASC
320 0.0042 0.0041749477386475
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
321 0.0003 0.00028491020202637
SELECT id FROM categories WHERE parent_id = '64'
322 0.0042 0.0041661262512207
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 
323 0.0002 0.00016999244689941
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (64)
				  AND p.disabled = 0 
324 0.0002 0.00016093254089355
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (64)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
325 0.0002 0.00018882751464844
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '64'
326 0.0001 0.00013589859008789
SELECT * FROM categorygroups WHERE id = '10'
327 0.0082 0.0081689357757568
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
328 0.0003 0.00029182434082031
SELECT id FROM categories WHERE parent_id = '65'
329 0.0082 0.008213996887207
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 
330 0.0002 0.00018596649169922
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (65)
				  AND p.disabled = 0 
331 0.0002 0.00016188621520996
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (65)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
332 0.0002 0.00018215179443359
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '65'
333 0.0001 0.00013494491577148
SELECT * FROM categorygroups WHERE id = '10'
334 0.0025 0.0024869441986084
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
335 0.0003 0.00027298927307129
SELECT id FROM categories WHERE parent_id = '81'
336 0.0025 0.002518892288208
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 
337 0.0002 0.00016403198242188
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (81)
				  AND p.disabled = 0 
338 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 (81)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
339 0.0002 0.00017619132995605
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '81'
340 0.0001 0.00013399124145508
SELECT * FROM categorygroups WHERE id = '10'
341 0.0025 0.00248122215271
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
342 0.0003 0.00027108192443848
SELECT id FROM categories WHERE parent_id = '31'
343 0.0025 0.0025110244750977
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 
344 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 (31)
				  AND p.disabled = 0 
345 0.0002 0.00015687942504883
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 
346 0.0002 0.00019121170043945
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
347 0.0001 0.00013494491577148
SELECT * FROM categorygroups WHERE id = '10'
348 0.0023 0.0022599697113037
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
349 0.0003 0.00026798248291016
SELECT id FROM categories WHERE parent_id = '66'
350 0.0002 0.00022006034851074
SELECT id FROM categories WHERE parent_id = '131'
351 0.0028 0.0028359889984131
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 
352 0.0002 0.00016498565673828
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (131,66)
				  AND p.disabled = 0 
353 0.0002 0.00016188621520996
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (131,66)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
354 0.0002 0.00018620491027832
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '66'
355 0.0001 0.00013494491577148
SELECT * FROM categorygroups WHERE id = '10'
356 0.0094 0.0094270706176758
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 34
357 0.0003 0.00030279159545898
SELECT id FROM categories WHERE parent_id = '34'
358 0.0002 0.0002281665802002
SELECT id FROM categories WHERE parent_id = '94'
359 0.0002 0.00021815299987793
SELECT id FROM categories WHERE parent_id = '98'
360 0.0002 0.00021600723266602
SELECT id FROM categories WHERE parent_id = '99'
361 0.0002 0.00021219253540039
SELECT id FROM categories WHERE parent_id = '110'
362 0.0002 0.00022101402282715
SELECT id FROM categories WHERE parent_id = '130'
363 0.0103 0.010349988937378
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 
364 0.0002 0.00018501281738281
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 
365 0.0002 0.00016593933105469
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 
366 0.0002 0.00020384788513184
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '34'
367 0.0001 0.0001380443572998
SELECT * FROM categorygroups WHERE id = '10'
368 0.0004 0.00039005279541016
SELECT * FROM categories WHERE parent_id = '34'  AND hidden = 0 ORDER BY sortorder ASC
369 0.0007 0.00066399574279785
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 = 94
370 0.0002 0.00023889541625977
SELECT id FROM categories WHERE parent_id = '94'
371 0.0007 0.00068807601928711
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (94)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
372 0.0002 0.0001528263092041
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (94)
				  AND p.disabled = 0 
373 0.0002 0.00015807151794434
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (94)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
374 0.0002 0.00016999244689941
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '94'
375 0.0001 0.00014305114746094
SELECT * FROM categorygroups WHERE id = '10'
376 0.0003 0.00029706954956055
SELECT * FROM categories WHERE parent_id = '94'  AND hidden = 0 ORDER BY sortorder ASC
377 0.0007 0.00073409080505371
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 = 98
378 0.0002 0.00024008750915527
SELECT id FROM categories WHERE parent_id = '98'
379 0.0008 0.000762939453125
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (98)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
380 0.0001 0.00014686584472656
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (98)
				  AND p.disabled = 0 
381 0.0002 0.00015687942504883
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (98)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
382 0.0002 0.00016999244689941
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '98'
383 0.0001 0.00013494491577148
SELECT * FROM categorygroups WHERE id = '10'
384 0.0003 0.0003058910369873
SELECT * FROM categories WHERE parent_id = '98'  AND hidden = 0 ORDER BY sortorder ASC
385 0.0002 0.00022006034851074
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 = 99
386 0.0002 0.00023293495178223
SELECT id FROM categories WHERE parent_id = '99'
387 0.0002 0.00024199485778809
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (99)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
388 0.0002 0.00016307830810547
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (99)
				  AND p.disabled = 0 
389 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 (99)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
390 0.0002 0.00016903877258301
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '99'
391 0.0001 0.00013399124145508
SELECT * FROM categorygroups WHERE id = '10'
392 0.0003 0.00030684471130371
SELECT * FROM categories WHERE parent_id = '99'  AND hidden = 0 ORDER BY sortorder ASC
393 0.0004 0.00036907196044922
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 = 110
394 0.0002 0.00023794174194336
SELECT id FROM categories WHERE parent_id = '110'
395 0.0004 0.00040197372436523
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (110)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
396 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 (110)
				  AND p.disabled = 0 
397 0.0002 0.00015807151794434
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (110)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
398 0.0002 0.00016999244689941
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '110'
399 0.0001 0.00013399124145508
SELECT * FROM categorygroups WHERE id = '10'
400 0.0003 0.00030803680419922
SELECT * FROM categories WHERE parent_id = '110'  AND hidden = 0 ORDER BY sortorder ASC
401 0.0008 0.00077700614929199
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 = 130
402 0.0003 0.0002589225769043
SELECT id FROM categories WHERE parent_id = '130'
403 0.0008 0.0008080005645752
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (130)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
404 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 (130)
				  AND p.disabled = 0 
405 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 (130)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
406 0.0002 0.00015878677368164
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '130'
407 0.0001 0.00013399124145508
SELECT * FROM categorygroups WHERE id = '1'
408 0.0003 0.00029516220092773
SELECT * FROM categories WHERE parent_id = '130'  AND hidden = 0 ORDER BY sortorder ASC
409 0.0016 0.0015778541564941
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
410 0.0003 0.00025200843811035
SELECT id FROM categories WHERE parent_id = '32'
411 0.0016 0.001615047454834
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 
412 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 (32)
				  AND p.disabled = 0 
413 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 (32)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
414 0.0002 0.00018715858459473
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '32'
415 0.0001 0.00013494491577148
SELECT * FROM categorygroups WHERE id = '10'
416 0.0019 0.0018620491027832
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
417 0.0003 0.00026321411132812
SELECT id FROM categories WHERE parent_id = '89'
418 0.0019 0.0018939971923828
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 
419 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 (89)
				  AND p.disabled = 0 
420 0.0002 0.00015687942504883
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 
421 0.0002 0.00018000602722168
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '89'
422 0.0001 0.00013494491577148
SELECT * FROM categorygroups WHERE id = '10'
423 0.0004 0.00041317939758301
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '17'  AND hidden = 0 ORDER BY sortorder ASC
424 0.0007 0.00069904327392578
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
425 0.0002 0.00024604797363281
SELECT id FROM categories WHERE parent_id = '84'
426 0.0007 0.00071096420288086
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 
427 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 (84)
				  AND p.disabled = 0 
428 0.0002 0.00015711784362793
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (84)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
429 0.0002 0.00017786026000977
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '84'
430 0.0001 0.00013303756713867
SELECT * FROM categorygroups WHERE id = '17'
431 0.0007 0.00071001052856445
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
432 0.0002 0.00024700164794922
SELECT id FROM categories WHERE parent_id = '90'
433 0.0007 0.00074601173400879
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 
434 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 (90)
				  AND p.disabled = 0 
435 0.0002 0.00015401840209961
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (90)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
436 0.0002 0.00017809867858887
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '90'
437 0.0001 0.00013113021850586
SELECT * FROM categorygroups WHERE id = '17'
438 0.0003 0.00031590461730957
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '20'  AND hidden = 0 ORDER BY sortorder ASC
439 0.0021 0.0020921230316162
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
440 0.0003 0.00026988983154297
SELECT id FROM categories WHERE parent_id = '92'
441 0.0021 0.0020620822906494
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 
442 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 (92)
				  AND p.disabled = 0 
443 0.0002 0.00015902519226074
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (92)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
444 0.0002 0.00016307830810547
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '92'
445 0.0001 0.0001370906829834
SELECT * FROM categorygroups WHERE id = '20'
446 0.0001 0.00011396408081055
SELECT * FROM categoryimages WHERE category_id = 130
447 0.0002 0.00018310546875
SELECT * FROM template_info WHERE templateuid = 'fsb-fluid'
448 0.0003 0.00027894973754883
SELECT * FROM categories WHERE parent_id = '130'
449 0.0331 0.033060073852539
SELECT MAX(price) as maxprice, MIN(price) as minprice FROM products WHERE enabled = 1 AND hidden = 0 AND price <> 0 
450 0.0062 0.0062317848205566
SELECT * FROM manufacturers WHERE display_filter = 1 AND merge_manufacturer_id = 0 ORDER BY name
451 0.0003 0.00030517578125
SELECT * FROM productattributenames n WHERE hidden = 0 AND metabrowse = 1 ORDER BY n.displayname ASC
452 0.0331 0.033118963241577
SELECT MAX(price) as maxprice, MIN(price) as minprice FROM products WHERE enabled = 1 AND hidden = 0 AND price <> 0 
453 0.0062 0.006242036819458
SELECT * FROM manufacturers WHERE display_filter = 1 AND merge_manufacturer_id = 0 ORDER BY name
454 0.0003 0.00029897689819336
SELECT * FROM productattributenames n WHERE hidden = 0 AND metabrowse = 1 AND sidebarfilter = 1 ORDER BY n.displayname ASC
455 0.0010 0.00097799301147461
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
		WHERE p.id = c.product_id AND parent_id = 0
		AND c.category_id = 130
		AND (c.prod_type = '' OR c.prod_type = 'amz')
		AND hidden = 0
		AND enabled = 1
		
		AND 1 = 1
456 0.0002 0.00017404556274414
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
		WHERE ep.id = c.product_id
		AND c.category_id = 130
		AND c.prod_type = 'ebay'
		AND hide = 1
457 0.0002 0.00015497207641602
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
			WHERE p.id = c.bundle_id AND parent_id = 0
			AND c.category_id = 130
			AND p.disabled = 0
			
			AND 1 = 1
458 0.0002 0.00015401840209961
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
		WHERE cp.id = c.product_id
		AND c.category_id = 130
		AND c.prod_type = 'custom'
		AND hide = 1
459 0.0016 0.0016160011291504
SELECT DISTINCT (p.id), IF(p.salesrank <> 0, p.salesrank, 100000) AS salesrank, p.price, p.linktitle, p.pagename, 'product' AS type FROM products p, products_categories c
			WHERE p.id = c.product_id
			AND p.parent_id = 0
			AND c.category_id = 130
			AND hidden = 0
			AND enabled = 1
			
			AND 1 = 1 UNION SELECT DISTINCT (p.id), IF(p.salesrank <> 0, p.salesrank, 100000) AS salesrank, p.price, p.linktitle, p.pagename, 'ebay' AS type FROM ebay_products p, products_categories c
		WHERE p.id = c.product_id
		AND c.category_id = 130
		AND c.prod_type = 'ebay'
		AND p.hide = 1 UNION SELECT DISTINCT (p.id), IF(p.salesrank <> 0, p.salesrank, 100000) AS salesrank, p.price, p.linktitle, p.pagename, 'custom' AS type FROM custom_products p, products_categories c
		WHERE p.id = c.product_id
		AND c.category_id = 130
		AND c.prod_type = 'custom'
		AND p.hide = 1 UNION SELECT DISTINCT (p.id), IF(p.salesrank <> 0, p.salesrank, 100000) AS salesrank, p.price, p.linktitle, p.pagename, 'bundle' AS type FROM bundles p, bundle_categories c
			WHERE p.id = c.bundle_id
			AND c.category_id = 130
			AND disabled = 0
			
			AND 1 = 1 ORDER BY salesrank ASC LIMIT 0, 18
460 0.0002 0.000244140625
SELECT * FROM products WHERE id = '400671'
461 0.0003 0.00026607513427734
SELECT * FROM productimages WHERE product_id = '400671' ORDER BY sortorder ASC
462 0.0002 0.00021886825561523
SELECT * FROM product_image_select WHERE product_id = '400671'
463 0.0001 0.00013303756713867
SELECT * FROM productcustomimages WHERE product_id = '400671'
464 0.0030 0.0029640197753906
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '400671' AND a.name = n.originalname
465 0.0002 0.00020885467529297
SELECT * FROM productoffers WHERE product_id = '400671' AND merchantid = 'ATVPDKIKX0DER'
466 0.0002 0.00021696090698242
SELECT * FROM productoffers
                WHERE product_id = '400671' AND price > 0
                ORDER BY price ASC LIMIT 1
467 0.0004 0.00036191940307617
SELECT value FROM productattributes WHERE product_id = '400671' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
468 0.0001 0.00014686584472656
UPDATE products SET price = '6472' WHERE id = '400671'
469 0.0002 0.00023818016052246
SELECT * FROM products WHERE id = '152022'
470 0.0002 0.00022196769714355
SELECT * FROM productimages WHERE product_id = '152022' ORDER BY sortorder ASC
471 0.0002 0.00022315979003906
SELECT * FROM product_image_select WHERE product_id = '152022'
472 0.0001 0.00013303756713867
SELECT * FROM productcustomimages WHERE product_id = '152022'
473 0.0029 0.0029189586639404
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '152022' AND a.name = n.originalname
474 0.0002 0.00020194053649902
SELECT * FROM productoffers WHERE product_id = '152022' AND merchantid = 'ATVPDKIKX0DER'
475 0.0002 0.00021100044250488
SELECT * FROM productoffers
                WHERE product_id = '152022' AND price > 0
                ORDER BY price ASC LIMIT 1
476 0.0004 0.00042295455932617
SELECT value FROM productattributes WHERE product_id = '152022' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
477 0.0001 0.00013089179992676
UPDATE products SET price = '12729' WHERE id = '152022'
478 0.0002 0.00023794174194336
SELECT * FROM products WHERE id = '405828'
479 0.0002 0.00022101402282715
SELECT * FROM productimages WHERE product_id = '405828' ORDER BY sortorder ASC
480 0.0002 0.00022387504577637
SELECT * FROM product_image_select WHERE product_id = '405828'
481 0.0001 0.00013089179992676
SELECT * FROM productcustomimages WHERE product_id = '405828'
482 0.0034 0.0034182071685791
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '405828' AND a.name = n.originalname
483 0.0002 0.00019216537475586
SELECT * FROM productoffers WHERE product_id = '405828' AND merchantid = 'ATVPDKIKX0DER'
484 0.0002 0.00021505355834961
SELECT * FROM productoffers
                WHERE product_id = '405828' AND price > 0
                ORDER BY price ASC LIMIT 1
485 0.0005 0.00045514106750488
SELECT value FROM productattributes WHERE product_id = '405828' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
486 0.0001 0.00013089179992676
UPDATE products SET price = '12318' WHERE id = '405828'
487 0.0002 0.0002140998840332
SELECT * FROM products WHERE id = '140390'
488 0.0002 0.00018501281738281
SELECT * FROM productimages WHERE product_id = '140390' ORDER BY sortorder ASC
489 0.0003 0.0002741813659668
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '140390' AND p.id = pi.product_id ORDER BY pi.sortorder
490 0.0002 0.00021815299987793
SELECT * FROM product_image_select WHERE product_id = '140390'
491 0.0001 0.00013089179992676
SELECT * FROM productcustomimages WHERE product_id = '140390'
492 0.0002 0.00024104118347168
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 = '140390'
                GROUP BY o.product_id
493 0.0003 0.00032687187194824
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     = '140390'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
494 0.0002 0.00020718574523926
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 140390
495 0.0033 0.003262996673584
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '140390' AND a.name = n.originalname
496 0.0002 0.00018191337585449
SELECT * FROM productoffers WHERE product_id = '140390' AND merchantid = 'ATVPDKIKX0DER'
497 0.0002 0.0001978874206543
SELECT * FROM productoffers
                WHERE product_id = '140390' AND price > 0
                ORDER BY price ASC LIMIT 1
498 0.0002 0.00017404556274414
SELECT * FROM productoffers
                WHERE product_id = 140390
                ORDER BY price ASC LIMIT 1
499 0.0003 0.00029110908508301
SELECT value FROM productattributes
                WHERE product_id = '140390'
                AND name = 'ListPriceAmount'
500 0.0002 0.00023818016052246
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 = '140390'
                GROUP BY o.product_id
501 0.0003 0.00031781196594238
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     = '140390'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
502 0.0002 0.00020503997802734
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 140390
503 0.0004 0.00043606758117676
SELECT value FROM productattributes WHERE product_id = '140390' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
504 0.0003 0.00034403800964355
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '140390'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Size'
                GROUP BY o.value
                ORDER BY o.value ASC
505 0.0002 0.00021815299987793
SELECT * FROM products WHERE id = '130355'
506 0.0003 0.0002598762512207
SELECT * FROM productimages WHERE product_id = '130355' ORDER BY sortorder ASC
507 0.0002 0.00023221969604492
SELECT * FROM product_image_select WHERE product_id = '130355'
508 0.0001 0.00013089179992676
SELECT * FROM productcustomimages WHERE product_id = '130355'
509 0.0021 0.0020880699157715
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '130355' AND a.name = n.originalname
510 0.0002 0.00018501281738281
SELECT * FROM productoffers WHERE product_id = '130355' AND merchantid = 'ATVPDKIKX0DER'
511 0.0002 0.00019001960754395
SELECT * FROM productoffers
                WHERE product_id = '130355' AND price > 0
                ORDER BY price ASC LIMIT 1
512 0.0002 0.00018692016601562
SELECT * FROM productoffers
                WHERE product_id = 130355
                ORDER BY price ASC LIMIT 1
513 0.0002 0.00022602081298828
SELECT value FROM productattributes
                WHERE product_id = '130355'
                AND name = 'ListPriceAmount'
514 0.0001 0.00013303756713867
UPDATE products SET price = '16266' WHERE id = '130355'
515 0.0002 0.0002129077911377
SELECT * FROM products WHERE id = '126985'
516 0.0003 0.00026893615722656
SELECT * FROM productimages WHERE product_id = '126985' ORDER BY sortorder ASC
517 0.0002 0.00022196769714355
SELECT * FROM product_image_select WHERE product_id = '126985'
518 0.0001 0.00013113021850586
SELECT * FROM productcustomimages WHERE product_id = '126985'
519 0.0025 0.0025169849395752
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '126985' AND a.name = n.originalname
520 0.0002 0.00019097328186035
SELECT * FROM productoffers WHERE product_id = '126985' AND merchantid = 'ATVPDKIKX0DER'
521 0.0002 0.00021100044250488
SELECT * FROM productoffers
                WHERE product_id = '126985' AND price > 0
                ORDER BY price ASC LIMIT 1
522 0.0004 0.00037884712219238
SELECT value FROM productattributes WHERE product_id = '126985' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
523 0.0001 0.0001378059387207
UPDATE products SET price = '21500' WHERE id = '126985'
524 0.0002 0.00022387504577637
SELECT * FROM products WHERE id = '244452'
525 0.0002 0.00019192695617676
SELECT * FROM productimages WHERE product_id = '244452' ORDER BY sortorder ASC
526 0.0003 0.0002598762512207
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '244452' AND p.id = pi.product_id ORDER BY pi.sortorder
527 0.0002 0.00022697448730469
SELECT * FROM product_image_select WHERE product_id = '244452'
528 0.0001 0.00013208389282227
SELECT * FROM productcustomimages WHERE product_id = '244452'
529 0.0002 0.00023698806762695
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 = '244452'
                GROUP BY o.product_id
530 0.0003 0.0003349781036377
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     = '244452'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
531 0.0002 0.00021600723266602
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 244452
532 0.0022 0.0022380352020264
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '244452' AND a.name = n.originalname
533 0.0002 0.00018310546875
SELECT * FROM productoffers WHERE product_id = '244452' AND merchantid = 'ATVPDKIKX0DER'
534 0.0002 0.00019001960754395
SELECT * FROM productoffers
                WHERE product_id = '244452' AND price > 0
                ORDER BY price ASC LIMIT 1
535 0.0002 0.00017189979553223
SELECT * FROM productoffers
                WHERE product_id = 244452
                ORDER BY price ASC LIMIT 1
536 0.0003 0.00026679039001465
SELECT value FROM productattributes
                WHERE product_id = '244452'
                AND name = 'ListPriceAmount'
537 0.0002 0.00023579597473145
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 = '244452'
                GROUP BY o.product_id
538 0.0003 0.00032591819763184
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     = '244452'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
539 0.0002 0.00021505355834961
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 244452
540 0.0004 0.0003821849822998
SELECT value FROM productattributes WHERE product_id = '244452' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
541 0.0003 0.00033116340637207
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '244452'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Size'
                GROUP BY o.value
                ORDER BY o.value ASC
542 0.0003 0.00034403800964355
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '244452'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Color'
                GROUP BY o.value
                ORDER BY o.value ASC
543 0.0002 0.00021815299987793
SELECT * FROM products WHERE id = '406004'
544 0.0002 0.0002129077911377
SELECT * FROM productimages WHERE product_id = '406004' ORDER BY sortorder ASC
545 0.0002 0.00022411346435547
SELECT * FROM product_image_select WHERE product_id = '406004'
546 0.0001 0.00013899803161621
SELECT * FROM productcustomimages WHERE product_id = '406004'
547 0.0020 0.0020360946655273
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '406004' AND a.name = n.originalname
548 0.0002 0.00018191337585449
SELECT * FROM productoffers WHERE product_id = '406004' AND merchantid = 'ATVPDKIKX0DER'
549 0.0002 0.00019001960754395
SELECT * FROM productoffers
                WHERE product_id = '406004' AND price > 0
                ORDER BY price ASC LIMIT 1
550 0.0002 0.00017499923706055
SELECT * FROM productoffers
                WHERE product_id = 406004
                ORDER BY price ASC LIMIT 1
551 0.0002 0.00022220611572266
SELECT value FROM productattributes
                WHERE product_id = '406004'
                AND name = 'ListPriceAmount'
552 0.0001 0.00013208389282227
UPDATE products SET price = '5990' WHERE id = '406004'
553 0.0002 0.00020694732666016
SELECT * FROM products WHERE id = '399477'
554 0.0003 0.00026607513427734
SELECT * FROM productimages WHERE product_id = '399477' ORDER BY sortorder ASC
555 0.0002 0.00022220611572266
SELECT * FROM product_image_select WHERE product_id = '399477'
556 0.0001 0.00014185905456543
SELECT * FROM productcustomimages WHERE product_id = '399477'
557 0.0026 0.0025770664215088
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '399477' AND a.name = n.originalname
558 0.0002 0.00018215179443359
SELECT * FROM productoffers WHERE product_id = '399477' AND merchantid = 'ATVPDKIKX0DER'
559 0.0002 0.0001990795135498
SELECT * FROM productoffers
                WHERE product_id = '399477' AND price > 0
                ORDER BY price ASC LIMIT 1
560 0.0002 0.00017595291137695
SELECT * FROM productoffers
                WHERE product_id = 399477
                ORDER BY price ASC LIMIT 1
561 0.0002 0.00023317337036133
SELECT value FROM productattributes
                WHERE product_id = '399477'
                AND name = 'ListPriceAmount'
562 0.0001 0.00013017654418945
UPDATE products SET price = '16523' WHERE id = '399477'
563 0.0002 0.00022196769714355
SELECT * FROM products WHERE id = '367577'
564 0.0002 0.00023388862609863
SELECT * FROM productimages WHERE product_id = '367577' ORDER BY sortorder ASC
565 0.0002 0.00022196769714355
SELECT * FROM product_image_select WHERE product_id = '367577'
566 0.0001 0.00013089179992676
SELECT * FROM productcustomimages WHERE product_id = '367577'
567 0.0033 0.0033111572265625
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '367577' AND a.name = n.originalname
568 0.0002 0.00019478797912598
SELECT * FROM productoffers WHERE product_id = '367577' AND merchantid = 'ATVPDKIKX0DER'
569 0.0002 0.00021195411682129
SELECT * FROM productoffers
                WHERE product_id = '367577' AND price > 0
                ORDER BY price ASC LIMIT 1
570 0.0004 0.00044798851013184
SELECT value FROM productattributes WHERE product_id = '367577' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
571 0.0001 0.00012683868408203
UPDATE products SET price = '5799' WHERE id = '367577'
572 0.0002 0.0001988410949707
SELECT * FROM products WHERE id = '131949'
573 0.0002 0.00020003318786621
SELECT * FROM productimages WHERE product_id = '131949' ORDER BY sortorder ASC
574 0.0002 0.00021195411682129
SELECT * FROM product_image_select WHERE product_id = '131949'
575 0.0001 0.00011801719665527
SELECT * FROM productcustomimages WHERE product_id = '131949'
576 0.0024 0.0023758411407471
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '131949' AND a.name = n.originalname
577 0.0002 0.0001828670501709
SELECT * FROM productoffers WHERE product_id = '131949' AND merchantid = 'ATVPDKIKX0DER'
578 0.0002 0.00019407272338867
SELECT * FROM productoffers
                WHERE product_id = '131949' AND price > 0
                ORDER BY price ASC LIMIT 1
579 0.0003 0.00034999847412109
SELECT value FROM productattributes WHERE product_id = '131949' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
580 0.0001 0.00011682510375977
UPDATE products SET price = '11995' WHERE id = '131949'
581 0.0002 0.00020718574523926
SELECT * FROM products WHERE id = '165083'
582 0.0002 0.00016403198242188
SELECT * FROM productimages WHERE product_id = '165083' ORDER BY sortorder ASC
583 0.0003 0.00025510787963867
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '165083' AND p.id = pi.product_id ORDER BY pi.sortorder
584 0.0002 0.00020503997802734
SELECT * FROM product_image_select WHERE product_id = '165083'
585 0.0001 0.00012111663818359
SELECT * FROM productcustomimages WHERE product_id = '165083'
586 0.0002 0.00022006034851074
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 = '165083'
                GROUP BY o.product_id
587 0.0003 0.00029611587524414
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     = '165083'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
588 0.0002 0.00020503997802734
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 165083
589 0.0027 0.0026721954345703
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '165083' AND a.name = n.originalname
590 0.0002 0.00019121170043945
SELECT * FROM productoffers WHERE product_id = '165083' AND merchantid = 'ATVPDKIKX0DER'
591 0.0002 0.00017499923706055
SELECT * FROM productoffers
                WHERE product_id = '165083' AND price > 0
                ORDER BY price ASC LIMIT 1
592 0.0002 0.00015592575073242
SELECT * FROM productoffers
                WHERE product_id = 165083
                ORDER BY price ASC LIMIT 1
593 0.0002 0.00023508071899414
SELECT value FROM productattributes
                WHERE product_id = '165083'
                AND name = 'ListPriceAmount'
594 0.0002 0.00021505355834961
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 = '165083'
                GROUP BY o.product_id
595 0.0003 0.00030112266540527
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     = '165083'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
596 0.0002 0.00019001960754395
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 165083
597 0.0003 0.00033092498779297
SELECT value FROM productattributes WHERE product_id = '165083' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
598 0.0003 0.00031805038452148
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '165083'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Size'
                GROUP BY o.value
                ORDER BY o.value ASC
599 0.0002 0.00021004676818848
SELECT * FROM products WHERE id = '403107'
600 0.0002 0.00016593933105469
SELECT * FROM productimages WHERE product_id = '403107' ORDER BY sortorder ASC
601 0.0003 0.00025105476379395
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '403107' AND p.id = pi.product_id ORDER BY pi.sortorder
602 0.0002 0.00022506713867188
SELECT * FROM product_image_select WHERE product_id = '403107'
603 0.0001 0.00011992454528809
SELECT * FROM productcustomimages WHERE product_id = '403107'
604 0.0003 0.00025415420532227
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 = '403107'
                GROUP BY o.product_id
605 0.0004 0.00035595893859863
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     = '403107'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
606 0.0002 0.00023603439331055
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 403107
607 0.0021 0.002086877822876
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '403107' AND a.name = n.originalname
608 0.0002 0.00017189979553223
SELECT * FROM productoffers WHERE product_id = '403107' AND merchantid = 'ATVPDKIKX0DER'
609 0.0002 0.00017309188842773
SELECT * FROM productoffers
                WHERE product_id = '403107' AND price > 0
                ORDER BY price ASC LIMIT 1
610 0.0002 0.00015592575073242
SELECT * FROM productoffers
                WHERE product_id = 403107
                ORDER BY price ASC LIMIT 1
611 0.0002 0.00022292137145996
SELECT value FROM productattributes
                WHERE product_id = '403107'
                AND name = 'ListPriceAmount'
612 0.0003 0.0002589225769043
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 = '403107'
                GROUP BY o.product_id
613 0.0003 0.00034809112548828
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     = '403107'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
614 0.0002 0.0002138614654541
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 403107
615 0.0003 0.00034689903259277
SELECT value FROM productattributes WHERE product_id = '403107' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
616 0.0001 0.00011992454528809
UPDATE products SET price = '5498' WHERE id = '403107'
617 0.0003 0.0003352165222168
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '403107'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Size'
                GROUP BY o.value
                ORDER BY o.value ASC
618 0.0003 0.00034809112548828
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '403107'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Color'
                GROUP BY o.value
                ORDER BY o.value ASC
619 0.0002 0.00020980834960938
SELECT * FROM products WHERE id = '402938'
620 0.0002 0.00021600723266602
SELECT * FROM productimages WHERE product_id = '402938' ORDER BY sortorder ASC
621 0.0002 0.00020718574523926
SELECT * FROM product_image_select WHERE product_id = '402938'
622 0.0001 0.00011706352233887
SELECT * FROM productcustomimages WHERE product_id = '402938'
623 0.0024 0.0024318695068359
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '402938' AND a.name = n.originalname
624 0.0002 0.00018310546875
SELECT * FROM productoffers WHERE product_id = '402938' AND merchantid = 'ATVPDKIKX0DER'
625 0.0002 0.00019717216491699
SELECT * FROM productoffers
                WHERE product_id = '402938' AND price > 0
                ORDER BY price ASC LIMIT 1
626 0.0004 0.00038790702819824
SELECT value FROM productattributes WHERE product_id = '402938' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
627 0.0001 0.00011587142944336
UPDATE products SET price = '13649' WHERE id = '402938'
628 0.0002 0.0001988410949707
SELECT * FROM products WHERE id = '406005'
629 0.0002 0.00017809867858887
SELECT * FROM productimages WHERE product_id = '406005' ORDER BY sortorder ASC
630 0.0002 0.0002129077911377
SELECT * FROM product_image_select WHERE product_id = '406005'
631 0.0001 0.00011992454528809
SELECT * FROM productcustomimages WHERE product_id = '406005'
632 0.0026 0.0026240348815918
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '406005' AND a.name = n.originalname
633 0.0002 0.00018119812011719
SELECT * FROM productoffers WHERE product_id = '406005' AND merchantid = 'ATVPDKIKX0DER'
634 0.0002 0.00017404556274414
SELECT * FROM productoffers
                WHERE product_id = '406005' AND price > 0
                ORDER BY price ASC LIMIT 1
635 0.0002 0.00016212463378906
SELECT * FROM productoffers
                WHERE product_id = 406005
                ORDER BY price ASC LIMIT 1
636 0.0002 0.00021481513977051
SELECT value FROM productattributes
                WHERE product_id = '406005'
                AND name = 'ListPriceAmount'
637 0.0001 0.00011610984802246
UPDATE products SET price = '21649' WHERE id = '406005'
638 0.0002 0.00020384788513184
SELECT * FROM products WHERE id = '136658'
639 0.0003 0.00025510787963867
SELECT * FROM productimages WHERE product_id = '136658' ORDER BY sortorder ASC
640 0.0002 0.00020599365234375
SELECT * FROM product_image_select WHERE product_id = '136658'
641 0.0001 0.00011706352233887
SELECT * FROM productcustomimages WHERE product_id = '136658'
642 0.0027 0.0027270317077637
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '136658' AND a.name = n.originalname
643 0.0002 0.00017094612121582
SELECT * FROM productoffers WHERE product_id = '136658' AND merchantid = 'ATVPDKIKX0DER'
644 0.0002 0.00017118453979492
SELECT * FROM productoffers
                WHERE product_id = '136658' AND price > 0
                ORDER BY price ASC LIMIT 1
645 0.0002 0.00016593933105469
SELECT * FROM productoffers
                WHERE product_id = 136658
                ORDER BY price ASC LIMIT 1
646 0.0002 0.00021791458129883
SELECT value FROM productattributes
                WHERE product_id = '136658'
                AND name = 'ListPriceAmount'
647 0.0001 0.00011610984802246
UPDATE products SET price = '26400' WHERE id = '136658'
648 0.0002 0.00019311904907227
SELECT * FROM products WHERE id = '143998'
649 0.0002 0.0001990795135498
SELECT * FROM productimages WHERE product_id = '143998' ORDER BY sortorder ASC
650 0.0002 0.0002129077911377
SELECT * FROM product_image_select WHERE product_id = '143998'
651 0.0001 0.00011801719665527
SELECT * FROM productcustomimages WHERE product_id = '143998'
652 0.0026 0.002647876739502
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '143998' AND a.name = n.originalname
653 0.0002 0.00017809867858887
SELECT * FROM productoffers WHERE product_id = '143998' AND merchantid = 'ATVPDKIKX0DER'
654 0.0002 0.00017404556274414
SELECT * FROM productoffers
                WHERE product_id = '143998' AND price > 0
                ORDER BY price ASC LIMIT 1
655 0.0002 0.00015902519226074
SELECT * FROM productoffers
                WHERE product_id = 143998
                ORDER BY price ASC LIMIT 1
656 0.0002 0.00021600723266602
SELECT value FROM productattributes
                WHERE product_id = '143998'
                AND name = 'ListPriceAmount'
657 0.0001 0.00011396408081055
UPDATE products SET price = '12379' WHERE id = '143998'
658 0.0002 0.00021219253540039
SELECT * FROM products WHERE id = '413390'
659 0.0001 0.00014495849609375
SELECT * FROM productimages WHERE product_id = '413390' ORDER BY sortorder ASC
660 0.0002 0.0001990795135498
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '413390' AND p.id = pi.product_id ORDER BY pi.sortorder
661 0.0002 0.00020813941955566
SELECT * FROM product_image_select WHERE product_id = '413390'
662 0.0001 0.00011682510375977
SELECT * FROM productcustomimages WHERE product_id = '413390'
663 0.0002 0.00020289421081543
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 = '413390'
                GROUP BY o.product_id
664 0.0002 0.00022411346435547
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     = '413390'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
665 0.0002 0.00016999244689941
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 413390
666 0.0005 0.00048184394836426
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '413390' AND a.name = n.originalname
667 0.0002 0.00017690658569336
SELECT * FROM productoffers WHERE product_id = '413390' AND merchantid = 'ATVPDKIKX0DER'
668 0.0002 0.00017094612121582
SELECT * FROM productoffers
                WHERE product_id = '413390' AND price > 0
                ORDER BY price ASC LIMIT 1
669 0.0002 0.00015711784362793
SELECT * FROM productoffers
                WHERE product_id = 413390
                ORDER BY price ASC LIMIT 1
670 0.0002 0.00022411346435547
SELECT value FROM productattributes
                WHERE product_id = '413390'
                AND name = 'ListPriceAmount'
671 0.0002 0.00019693374633789
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 = '413390'
                GROUP BY o.product_id
672 0.0002 0.00023198127746582
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     = '413390'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
673 0.0002 0.00016999244689941
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 413390
674 0.0003 0.00033712387084961
SELECT value FROM productattributes WHERE product_id = '413390' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
675 0.0002 0.00018882751464844
SELECT * FROM products WHERE parent_id = '413390'
676 0.0003 0.00031900405883789
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '400671' ORDER BY timestamp DESC
677 0.0003 0.0002598762512207
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '152022' ORDER BY timestamp DESC
678 0.0003 0.00025391578674316
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '405828' ORDER BY timestamp DESC
679 0.0003 0.00026702880859375
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '140390' ORDER BY timestamp DESC
680 0.0003 0.00025510787963867
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '130355' ORDER BY timestamp DESC
681 0.0003 0.00025510787963867
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '126985' ORDER BY timestamp DESC
682 0.0003 0.00025105476379395
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '244452' ORDER BY timestamp DESC
683 0.0003 0.00026488304138184
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '406004' ORDER BY timestamp DESC
684 0.0003 0.00025391578674316
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '399477' ORDER BY timestamp DESC
685 0.0003 0.00025296211242676
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '367577' ORDER BY timestamp DESC
686 0.0003 0.00025200843811035
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '131949' ORDER BY timestamp DESC
687 0.0003 0.00026202201843262
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '165083' ORDER BY timestamp DESC
688 0.0003 0.00025200843811035
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '403107' ORDER BY timestamp DESC
689 0.0003 0.00025391578674316
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '402938' ORDER BY timestamp DESC
690 0.0003 0.00026202201843262
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '406005' ORDER BY timestamp DESC
691 0.0003 0.0002598762512207
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '136658' ORDER BY timestamp DESC
692 0.0003 0.00025200843811035
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '143998' ORDER BY timestamp DESC
693 0.0003 0.00025105476379395
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '413390' ORDER BY timestamp DESC
694 0.0002 0.00016188621520996
SELECT linktitle,pagename,ep.id,price,buylink,image FROM ebay_products ep, products_categories c
		WHERE ep.id = c.product_id
		AND c.category_id = 130
		AND c.prod_type = 'ebay'
		AND hide = 1
695 0.0001 0.00013399124145508
SELECT value FROM parameters WHERE parameter = 'EBAY_APP_ID' 
696 0.0001 0.00011801719665527
SELECT value FROM parameters WHERE parameter = 'EBAY_TRACKING_ID' 
697 0.0001 0.00011610984802246
SELECT value FROM parameters WHERE parameter = 'EBAY_NETWORK_ID' 
698 0.0001 0.00011515617370605
SELECT value FROM parameters WHERE parameter = 'EBAY_LOCALE' 
699 0.0001 0.00011491775512695
SELECT value FROM parameters WHERE parameter = 'EBAY_AUTH_TOKEN' 
700 0.0001 0.00012993812561035
SELECT * FROM ebay_locale_details WHERE cur_code = 'USD' 
701 0.0002 0.00017213821411133
SELECT * FROM template_info WHERE templateuid = 'fsb-fluid'
702 0.0002 0.00015711784362793
SELECT * FROM pages WHERE id = 2
703 0.0001 0.00013589859008789
SELECT * FROM pages WHERE id = 4
704 0.0001 0.00013208389282227
SELECT * FROM pages WHERE id = 12
705 0.0001 0.00013494491577148
SELECT * FROM pages WHERE id = 10
706 0.0001 0.00013399124145508
SELECT * FROM pages WHERE id = 7
707 0.0001 0.00013899803161621
SELECT * FROM pages WHERE id = 18
708 0.0001 0.00013399124145508
SELECT * FROM pages WHERE id = 28
709 0.0001 0.0001380443572998
SELECT * FROM pages WHERE id = 13
710 0.0001 0.00013089179992676
SELECT * FROM pages WHERE id = 3
711 0.0320 0.031954050064087
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
712 0.0002 0.00021219253540039
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:1561581431;s:8:\"products\";a:6:{i:4;s:6:\"171938\";i:8;s:6:\"412382\";i:9;s:6:\"414825\";i:12;s:6:\"406758\";i:14;s:6:\"407620\";i:19;s:6:\"404868\";}}' WHERE id = '175'
713 0.0004 0.00041913986206055
SELECT * FROM products WHERE id IN (171938,412382,414825,406758,407620,404868) ORDER BY FIELD(id, 171938,412382,414825,406758,407620,404868 )
714 0.0007 0.0006561279296875
SELECT * FROM productimages WHERE product_id = '171938' ORDER BY sortorder ASC
715 0.0002 0.00021600723266602
SELECT * FROM product_image_select WHERE product_id = '171938'
716 0.0001 0.0001220703125
SELECT * FROM productcustomimages WHERE product_id = '171938'
717 0.0026 0.0025558471679688
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '171938' AND a.name = n.originalname
718 0.0002 0.00018000602722168
SELECT * FROM productoffers WHERE product_id = '171938' AND merchantid = 'ATVPDKIKX0DER'
719 0.0002 0.00020790100097656
SELECT * FROM productoffers
                WHERE product_id = '171938' AND price > 0
                ORDER BY price ASC LIMIT 1
720 0.0004 0.00038504600524902
SELECT value FROM productattributes WHERE product_id = '171938' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
721 0.0001 0.00011801719665527
UPDATE products SET price = '388900' WHERE id = '171938'
722 0.0002 0.00018501281738281
SELECT * FROM productimages WHERE product_id = '412382' ORDER BY sortorder ASC
723 0.0002 0.00021100044250488
SELECT * FROM product_image_select WHERE product_id = '412382'
724 0.0001 0.00011897087097168
SELECT * FROM productcustomimages WHERE product_id = '412382'
725 0.0021 0.0020558834075928
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '412382' AND a.name = n.originalname
726 0.0002 0.00017809867858887
SELECT * FROM productoffers WHERE product_id = '412382' AND merchantid = 'ATVPDKIKX0DER'
727 0.0002 0.00019502639770508
SELECT * FROM productoffers
                WHERE product_id = '412382' AND price > 0
                ORDER BY price ASC LIMIT 1
728 0.0003 0.00032782554626465
SELECT value FROM productattributes WHERE product_id = '412382' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
729 0.0001 0.00011801719665527
UPDATE products SET price = '3199' WHERE id = '412382'
730 0.0002 0.00020289421081543
SELECT * FROM productimages WHERE product_id = '414825' ORDER BY sortorder ASC
731 0.0002 0.0001978874206543
SELECT * FROM product_image_select WHERE product_id = '414825'
732 0.0001 0.00011801719665527
SELECT * FROM productcustomimages WHERE product_id = '414825'
733 0.0020 0.0020151138305664
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '414825' AND a.name = n.originalname
734 0.0002 0.00019598007202148
SELECT * FROM productoffers WHERE product_id = '414825' AND merchantid = 'ATVPDKIKX0DER'
735 0.0002 0.0001990795135498
SELECT * FROM productoffers
                WHERE product_id = '414825' AND price > 0
                ORDER BY price ASC LIMIT 1
736 0.0004 0.00035810470581055
SELECT value FROM productattributes WHERE product_id = '414825' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
737 0.0001 0.00011491775512695
UPDATE products SET price = '11999' WHERE id = '414825'
738 0.0002 0.00019693374633789
SELECT * FROM productimages WHERE product_id = '406758' ORDER BY sortorder ASC
739 0.0002 0.0001978874206543
SELECT * FROM product_image_select WHERE product_id = '406758'
740 0.0001 0.00011706352233887
SELECT * FROM productcustomimages WHERE product_id = '406758'
741 0.0026 0.0026369094848633
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '406758' AND a.name = n.originalname
742 0.0002 0.00018811225891113
SELECT * FROM productoffers WHERE product_id = '406758' AND merchantid = 'ATVPDKIKX0DER'
743 0.0002 0.00020217895507812
SELECT * FROM productoffers
                WHERE product_id = '406758' AND price > 0
                ORDER BY price ASC LIMIT 1
744 0.0004 0.0003809928894043
SELECT value FROM productattributes WHERE product_id = '406758' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
745 0.0001 0.00012087821960449
UPDATE products SET price = '2694' WHERE id = '406758'
746 0.0002 0.00020503997802734
SELECT * FROM productimages WHERE product_id = '407620' ORDER BY sortorder ASC
747 0.0002 0.00020694732666016
SELECT * FROM product_image_select WHERE product_id = '407620'
748 0.0001 0.00011706352233887
SELECT * FROM productcustomimages WHERE product_id = '407620'
749 0.0023 0.0022721290588379
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '407620' AND a.name = n.originalname
750 0.0002 0.00018692016601562
SELECT * FROM productoffers WHERE product_id = '407620' AND merchantid = 'ATVPDKIKX0DER'
751 0.0002 0.00020289421081543
SELECT * FROM productoffers
                WHERE product_id = '407620' AND price > 0
                ORDER BY price ASC LIMIT 1
752 0.0004 0.0003669261932373
SELECT value FROM productattributes WHERE product_id = '407620' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
753 0.0001 0.0001220703125
UPDATE products SET price = '20323' WHERE id = '407620'
754 0.0003 0.00029993057250977
SELECT * FROM productimages WHERE product_id = '404868' ORDER BY sortorder ASC
755 0.0002 0.00020909309387207
SELECT * FROM product_image_select WHERE product_id = '404868'
756 0.0001 0.00011706352233887
SELECT * FROM productcustomimages WHERE product_id = '404868'
757 0.0030 0.0029828548431396
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '404868' AND a.name = n.originalname
758 0.0002 0.00017809867858887
SELECT * FROM productoffers WHERE product_id = '404868' AND merchantid = 'ATVPDKIKX0DER'
759 0.0002 0.00019407272338867
SELECT * FROM productoffers
                WHERE product_id = '404868' AND price > 0
                ORDER BY price ASC LIMIT 1
760 0.0004 0.00040078163146973
SELECT value FROM productattributes WHERE product_id = '404868' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
761 0.0001 0.00011396408081055
UPDATE products SET price = '44899' WHERE id = '404868'
762 0.0319 0.031887054443359
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
763 0.0002 0.00020909309387207
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:1561581432;s:8:\"products\";a:6:{i:1;s:6:\"398315\";i:4;s:6:\"171938\";i:8;s:6:\"412382\";i:10;s:6:\"414188\";i:13;s:6:\"130885\";i:17;s:6:\"406901\";}}' WHERE id = '177'
764 0.0004 0.00042819976806641
SELECT * FROM products WHERE id IN (398315,171938,412382,414188,130885,406901) ORDER BY FIELD(id, 398315,171938,412382,414188,130885,406901 )
765 0.0002 0.00021100044250488
SELECT * FROM productimages WHERE product_id = '398315' ORDER BY sortorder ASC
766 0.0002 0.0002129077911377
SELECT * FROM product_image_select WHERE product_id = '398315'
767 0.0001 0.00012397766113281
SELECT * FROM productcustomimages WHERE product_id = '398315'
768 0.0025 0.0025138854980469
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '398315' AND a.name = n.originalname
769 0.0002 0.0001828670501709
SELECT * FROM productoffers WHERE product_id = '398315' AND merchantid = 'ATVPDKIKX0DER'
770 0.0002 0.00020694732666016
SELECT * FROM productoffers
                WHERE product_id = '398315' AND price > 0
                ORDER BY price ASC LIMIT 1
771 0.0004 0.00037717819213867
SELECT value FROM productattributes WHERE product_id = '398315' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
772 0.0001 0.00011992454528809
UPDATE products SET price = '1999' WHERE id = '398315'
773 0.0006 0.0006251335144043
SELECT * FROM productimages WHERE product_id = '171938' ORDER BY sortorder ASC
774 0.0002 0.00021696090698242
SELECT * FROM product_image_select WHERE product_id = '171938'
775 0.0001 0.00011801719665527
SELECT * FROM productcustomimages WHERE product_id = '171938'
776 0.0025 0.0025250911712646
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '171938' AND a.name = n.originalname
777 0.0002 0.00018095970153809
SELECT * FROM productoffers WHERE product_id = '171938' AND merchantid = 'ATVPDKIKX0DER'
778 0.0002 0.00019192695617676
SELECT * FROM productoffers
                WHERE product_id = '171938' AND price > 0
                ORDER BY price ASC LIMIT 1
779 0.0004 0.00038313865661621
SELECT value FROM productattributes WHERE product_id = '171938' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
780 0.0001 0.00011610984802246
UPDATE products SET price = '388900' WHERE id = '171938'
781 0.0002 0.00018310546875
SELECT * FROM productimages WHERE product_id = '412382' ORDER BY sortorder ASC
782 0.0002 0.00019693374633789
SELECT * FROM product_image_select WHERE product_id = '412382'
783 0.0001 0.00012898445129395
SELECT * FROM productcustomimages WHERE product_id = '412382'
784 0.0021 0.00205397605896
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '412382' AND a.name = n.originalname
785 0.0002 0.00017809867858887
SELECT * FROM productoffers WHERE product_id = '412382' AND merchantid = 'ATVPDKIKX0DER'
786 0.0002 0.00019192695617676
SELECT * FROM productoffers
                WHERE product_id = '412382' AND price > 0
                ORDER BY price ASC LIMIT 1
787 0.0003 0.00031113624572754
SELECT value FROM productattributes WHERE product_id = '412382' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
788 0.0001 0.00012803077697754
UPDATE products SET price = '3199' WHERE id = '412382'
789 0.0003 0.00026702880859375
SELECT * FROM productimages WHERE product_id = '414188' ORDER BY sortorder ASC
790 0.0002 0.00020289421081543
SELECT * FROM product_image_select WHERE product_id = '414188'
791 0.0001 0.00011610984802246
SELECT * FROM productcustomimages WHERE product_id = '414188'
792 0.0026 0.0026021003723145
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '414188' AND a.name = n.originalname
793 0.0002 0.00018191337585449
SELECT * FROM productoffers WHERE product_id = '414188' AND merchantid = 'ATVPDKIKX0DER'
794 0.0002 0.00019192695617676
SELECT * FROM productoffers
                WHERE product_id = '414188' AND price > 0
                ORDER BY price ASC LIMIT 1
795 0.0004 0.0003960132598877
SELECT value FROM productattributes WHERE product_id = '414188' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
796 0.0001 0.00011610984802246
UPDATE products SET price = '9999' WHERE id = '414188'
797 0.0002 0.00018906593322754
SELECT * FROM productimages WHERE product_id = '130885' ORDER BY sortorder ASC
798 0.0002 0.00020599365234375
SELECT * FROM product_image_select WHERE product_id = '130885'
799 0.0001 0.00011706352233887
SELECT * FROM productcustomimages WHERE product_id = '130885'
800 0.0020 0.0019769668579102
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '130885' AND a.name = n.originalname
801 0.0002 0.00018692016601562
SELECT * FROM productoffers WHERE product_id = '130885' AND merchantid = 'ATVPDKIKX0DER'
802 0.0002 0.00019311904907227
SELECT * FROM productoffers
                WHERE product_id = '130885' AND price > 0
                ORDER BY price ASC LIMIT 1
803 0.0003 0.00034713745117188
SELECT value FROM productattributes WHERE product_id = '130885' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
804 0.0001 0.00011897087097168
UPDATE products SET price = '1521' WHERE id = '130885'
805 0.0002 0.00020694732666016
SELECT * FROM productimages WHERE product_id = '406901' ORDER BY sortorder ASC
806 0.0002 0.00020694732666016
SELECT * FROM product_image_select WHERE product_id = '406901'
807 0.0001 0.00011706352233887
SELECT * FROM productcustomimages WHERE product_id = '406901'
808 0.0023 0.0023219585418701
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '406901' AND a.name = n.originalname
809 0.0002 0.00018596649169922
SELECT * FROM productoffers WHERE product_id = '406901' AND merchantid = 'ATVPDKIKX0DER'
810 0.0002 0.00019311904907227
SELECT * FROM productoffers
                WHERE product_id = '406901' AND price > 0
                ORDER BY price ASC LIMIT 1
811 0.0003 0.0003349781036377
SELECT value FROM productattributes WHERE product_id = '406901' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
812 0.0001 0.00011706352233887
UPDATE products SET price = '395' WHERE id = '406901'
813 0.0831 0.083054065704346
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
814 0.0003 0.00025200843811035
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:1561581432;s:8:\"products\";a:6:{i:15;s:6:\"408078\";i:22;s:6:\"232841\";i:23;s:6:\"402141\";i:3;s:6:\"290575\";i:5;s:6:\"185812\";i:14;s:6:\"407620\";}}' WHERE id = '181'
815 0.0004 0.00043606758117676
SELECT * FROM products WHERE id IN (408078,232841,402141,290575,185812,407620) ORDER BY FIELD(id, 408078,232841,402141,290575,185812,407620 )
816 0.0002 0.00021195411682129
SELECT * FROM productimages WHERE product_id = '408078' ORDER BY sortorder ASC
817 0.0002 0.00021600723266602
SELECT * FROM product_image_select WHERE product_id = '408078'
818 0.0001 0.00012087821960449
SELECT * FROM productcustomimages WHERE product_id = '408078'
819 0.0024 0.0024309158325195
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '408078' AND a.name = n.originalname
820 0.0002 0.00019311904907227
SELECT * FROM productoffers WHERE product_id = '408078' AND merchantid = 'ATVPDKIKX0DER'
821 0.0002 0.0001988410949707
SELECT * FROM productoffers
                WHERE product_id = '408078' AND price > 0
                ORDER BY price ASC LIMIT 1
822 0.0003 0.00033712387084961
SELECT value FROM productattributes WHERE product_id = '408078' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
823 0.0001 0.00011801719665527
UPDATE products SET price = '24109' WHERE id = '408078'
824 0.0004 0.00041508674621582
SELECT * FROM productimages WHERE product_id = '232841' ORDER BY sortorder ASC
825 0.0002 0.00020098686218262
SELECT * FROM product_image_select WHERE product_id = '232841'
826 0.0001 0.00011682510375977
SELECT * FROM productcustomimages WHERE product_id = '232841'
827 0.0028 0.0027589797973633
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '232841' AND a.name = n.originalname
828 0.0002 0.00017881393432617
SELECT * FROM productoffers WHERE product_id = '232841' AND merchantid = 'ATVPDKIKX0DER'
829 0.0002 0.00019311904907227
SELECT * FROM productoffers
                WHERE product_id = '232841' AND price > 0
                ORDER BY price ASC LIMIT 1
830 0.0004 0.00040006637573242
SELECT value FROM productattributes WHERE product_id = '232841' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
831 0.0001 0.00011610984802246
UPDATE products SET price = '18000' WHERE id = '232841'
832 0.0003 0.00030088424682617
SELECT * FROM productimages WHERE product_id = '402141' ORDER BY sortorder ASC
833 0.0002 0.00021696090698242
SELECT * FROM product_image_select WHERE product_id = '402141'
834 0.0001 0.00011897087097168
SELECT * FROM productcustomimages WHERE product_id = '402141'
835 0.0029 0.0029258728027344
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '402141' AND a.name = n.originalname
836 0.0002 0.00017905235290527
SELECT * FROM productoffers WHERE product_id = '402141' AND merchantid = 'ATVPDKIKX0DER'
837 0.0002 0.00019311904907227
SELECT * FROM productoffers
                WHERE product_id = '402141' AND price > 0
                ORDER BY price ASC LIMIT 1
838 0.0004 0.00041103363037109
SELECT value FROM productattributes WHERE product_id = '402141' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
839 0.0001 0.00011682510375977
UPDATE products SET price = '17900' WHERE id = '402141'
840 0.0006 0.00058102607727051
SELECT * FROM productimages WHERE product_id = '290575' ORDER BY sortorder ASC
841 0.0002 0.00024509429931641
SELECT * FROM product_image_select WHERE product_id = '290575'
842 0.0001 0.00011897087097168
SELECT * FROM productcustomimages WHERE product_id = '290575'
843 0.0034 0.0033807754516602
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '290575' AND a.name = n.originalname
844 0.0002 0.00019502639770508
SELECT * FROM productoffers WHERE product_id = '290575' AND merchantid = 'ATVPDKIKX0DER'
845 0.0002 0.00020003318786621
SELECT * FROM productoffers
                WHERE product_id = '290575' AND price > 0
                ORDER BY price ASC LIMIT 1
846 0.0004 0.00042414665222168
SELECT value FROM productattributes WHERE product_id = '290575' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
847 0.0001 0.00011491775512695
UPDATE products SET price = '549500' WHERE id = '290575'
848 0.0007 0.00066494941711426
SELECT * FROM productimages WHERE product_id = '185812' ORDER BY sortorder ASC
849 0.0002 0.00021696090698242
SELECT * FROM product_image_select WHERE product_id = '185812'
850 0.0001 0.00012707710266113
SELECT * FROM productcustomimages WHERE product_id = '185812'
851 0.0021 0.0020699501037598
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '185812' AND a.name = n.originalname
852 0.0002 0.00017809867858887
SELECT * FROM productoffers WHERE product_id = '185812' AND merchantid = 'ATVPDKIKX0DER'
853 0.0002 0.00019311904907227
SELECT * FROM productoffers
                WHERE product_id = '185812' AND price > 0
                ORDER BY price ASC LIMIT 1
854 0.0004 0.00036811828613281
SELECT value FROM productattributes WHERE product_id = '185812' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
855 0.0001 0.00012111663818359
UPDATE products SET price = '314900' WHERE id = '185812'
856 0.0002 0.00019693374633789
SELECT * FROM productimages WHERE product_id = '407620' ORDER BY sortorder ASC
857 0.0002 0.00020313262939453
SELECT * FROM product_image_select WHERE product_id = '407620'
858 0.0001 0.00011801719665527
SELECT * FROM productcustomimages WHERE product_id = '407620'
859 0.0023 0.0022680759429932
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '407620' AND a.name = n.originalname
860 0.0002 0.0001838207244873
SELECT * FROM productoffers WHERE product_id = '407620' AND merchantid = 'ATVPDKIKX0DER'
861 0.0002 0.00020313262939453
SELECT * FROM productoffers
                WHERE product_id = '407620' AND price > 0
                ORDER BY price ASC LIMIT 1
862 0.0004 0.0003669261932373
SELECT value FROM productattributes WHERE product_id = '407620' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
863 0.0001 0.00012397766113281
UPDATE products SET price = '20323' WHERE id = '407620'
864 0.0825 0.082542896270752
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
865 0.0002 0.00024890899658203
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:1561581432;s:8:\"products\";a:6:{i:4;s:6:\"171938\";i:13;s:6:\"130885\";i:15;s:6:\"408078\";i:19;s:6:\"404868\";i:20;s:6:\"258602\";i:21;s:6:\"402907\";}}' WHERE id = '183'
866 0.0004 0.00044512748718262
SELECT * FROM products WHERE id IN (171938,130885,408078,404868,258602,402907) ORDER BY FIELD(id, 171938,130885,408078,404868,258602,402907 )
867 0.0006 0.00061702728271484
SELECT * FROM productimages WHERE product_id = '171938' ORDER BY sortorder ASC
868 0.0002 0.00021100044250488
SELECT * FROM product_image_select WHERE product_id = '171938'
869 0.0001 0.00012087821960449
SELECT * FROM productcustomimages WHERE product_id = '171938'
870 0.0026 0.0025570392608643
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '171938' AND a.name = n.originalname
871 0.0002 0.0001828670501709
SELECT * FROM productoffers WHERE product_id = '171938' AND merchantid = 'ATVPDKIKX0DER'
872 0.0002 0.0001990795135498
SELECT * FROM productoffers
                WHERE product_id = '171938' AND price > 0
                ORDER BY price ASC LIMIT 1
873 0.0004 0.00039792060852051
SELECT value FROM productattributes WHERE product_id = '171938' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
874 0.0001 0.00011897087097168
UPDATE products SET price = '388900' WHERE id = '171938'
875 0.0002 0.00018906593322754
SELECT * FROM productimages WHERE product_id = '130885' ORDER BY sortorder ASC
876 0.0002 0.00020790100097656
SELECT * FROM product_image_select WHERE product_id = '130885'
877 0.0001 0.00011587142944336
SELECT * FROM productcustomimages WHERE product_id = '130885'
878 0.0020 0.0019948482513428
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '130885' AND a.name = n.originalname
879 0.0002 0.00018191337585449
SELECT * FROM productoffers WHERE product_id = '130885' AND merchantid = 'ATVPDKIKX0DER'
880 0.0002 0.00019311904907227
SELECT * FROM productoffers
                WHERE product_id = '130885' AND price > 0
                ORDER BY price ASC LIMIT 1
881 0.0003 0.00034809112548828
SELECT value FROM productattributes WHERE product_id = '130885' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
882 0.0001 0.00011801719665527
UPDATE products SET price = '1521' WHERE id = '130885'
883 0.0002 0.00020313262939453
SELECT * FROM productimages WHERE product_id = '408078' ORDER BY sortorder ASC
884 0.0002 0.00020408630371094
SELECT * FROM product_image_select WHERE product_id = '408078'
885 0.0001 0.00011801719665527
SELECT * FROM productcustomimages WHERE product_id = '408078'
886 0.0024 0.0024471282958984
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '408078' AND a.name = n.originalname
887 0.0002 0.00018000602722168
SELECT * FROM productoffers WHERE product_id = '408078' AND merchantid = 'ATVPDKIKX0DER'
888 0.0002 0.00019192695617676
SELECT * FROM productoffers
                WHERE product_id = '408078' AND price > 0
                ORDER BY price ASC LIMIT 1
889 0.0003 0.00032806396484375
SELECT value FROM productattributes WHERE product_id = '408078' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
890 0.0001 0.00011420249938965
UPDATE products SET price = '24109' WHERE id = '408078'
891 0.0003 0.00029993057250977
SELECT * FROM productimages WHERE product_id = '404868' ORDER BY sortorder ASC
892 0.0002 0.0001978874206543
SELECT * FROM product_image_select WHERE product_id = '404868'
893 0.0001 0.00011610984802246
SELECT * FROM productcustomimages WHERE product_id = '404868'
894 0.0030 0.0030100345611572
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '404868' AND a.name = n.originalname
895 0.0002 0.00017786026000977
SELECT * FROM productoffers WHERE product_id = '404868' AND merchantid = 'ATVPDKIKX0DER'
896 0.0002 0.00020194053649902
SELECT * FROM productoffers
                WHERE product_id = '404868' AND price > 0
                ORDER BY price ASC LIMIT 1
897 0.0004 0.00040316581726074
SELECT value FROM productattributes WHERE product_id = '404868' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
898 0.0001 0.00011396408081055
UPDATE products SET price = '44899' WHERE id = '404868'
899 0.0003 0.00032615661621094
SELECT * FROM productimages WHERE product_id = '258602' ORDER BY sortorder ASC
900 0.0002 0.00020503997802734
SELECT * FROM product_image_select WHERE product_id = '258602'
901 0.0001 0.00011682510375977
SELECT * FROM productcustomimages WHERE product_id = '258602'
902 0.0031 0.003058910369873
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '258602' AND a.name = n.originalname
903 0.0002 0.00017905235290527
SELECT * FROM productoffers WHERE product_id = '258602' AND merchantid = 'ATVPDKIKX0DER'
904 0.0002 0.00020098686218262
SELECT * FROM productoffers
                WHERE product_id = '258602' AND price > 0
                ORDER BY price ASC LIMIT 1
905 0.0004 0.00040102005004883
SELECT value FROM productattributes WHERE product_id = '258602' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
906 0.0001 0.00011396408081055
UPDATE products SET price = '19900' WHERE id = '258602'
907 0.0002 0.00020885467529297
SELECT * FROM productimages WHERE product_id = '402907' ORDER BY sortorder ASC
908 0.0002 0.00021910667419434
SELECT * FROM product_image_select WHERE product_id = '402907'
909 0.0001 0.00011682510375977
SELECT * FROM productcustomimages WHERE product_id = '402907'
910 0.0030 0.003046989440918
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '402907' AND a.name = n.originalname
911 0.0002 0.00017905235290527
SELECT * FROM productoffers WHERE product_id = '402907' AND merchantid = 'ATVPDKIKX0DER'
912 0.0002 0.00019216537475586
SELECT * FROM productoffers
                WHERE product_id = '402907' AND price > 0
                ORDER BY price ASC LIMIT 1
913 0.0003 0.00034999847412109
SELECT value FROM productattributes WHERE product_id = '402907' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
914 0.0001 0.00011587142944336
UPDATE products SET price = '9400' WHERE id = '402907'
915 0.0004 0.00039410591125488
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid' AND area = 'header' ORDER BY sortorder ASC
916 0.0001 0.00012993812561035
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
917 0.0001 0.00012016296386719
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
918 0.0001 0.00011682510375977
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
919 0.0001 0.00011301040649414
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
920 0.0004 0.00040984153747559
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid' AND area = 'footer' ORDER BY sortorder ASC
921 0.0001 0.00012588500976562
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
922 0.0001 0.00011706352233887
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
923 0.0009 0.00088810920715332
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-fluid' AND skinuid = ''
924 0.0003 0.00031113624572754
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid'
925 0.0003 0.00028014183044434
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid'
926 0.0004 0.00036883354187012
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid' AND imageuid = 'FB_DEFAULT_SHARE_IMAGE'
927 0.0001 0.00014591217041016
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
928 0.0001 0.00011992454528809
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
929 0.0001 0.00011587142944336
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
930 0.0001 0.00011491775512695
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
931 0.0001 0.00011301040649414
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
932 0.0003 0.00032711029052734
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid' AND imageuid = 'HEAD_CUSTOM_BANNER'
933 0.0003 0.00032806396484375
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid' AND imageuid = 'HEAD_CUSTOM_BANNER'