Tactical Equipment - Survivalist Equipment

Reviewed Products Specials

UPDATED :  

Debug Overview

App Total Time DB Queries DB Query Total Time Amazon Requests
1.7844638824463 891 0.9103 0


No Amazon API Requests Made.


App Debug - Total Time 1.7844638824463 seconds

Number Time From Start Name Description
1 0.43059992790222 Initialise Initialise FSB Function
2 0.43321704864502 App Controller Start Start of the App controller (called before the controller of every page)
3 0.58373785018921 App Controller End End of the App controller (called before the controller of every page)
4 0.58394885063171 Category Start Start of the category controller
5 0.58395195007324 Before Get Category Before getting the category information
6 0.59515905380249 After Get Category After getting the category information
7 0.59516096115112 Before Get Category List Before getting the updated category list
8 0.59531497955322 Start of getCategoryListByGroup Function Before first category groups query
9 0.59548902511597 After initial query Before first category groups query
10 0.5954909324646 Get Category List for Group Before the call to getCategoryList function
11 0.59549689292908 Start of GetCategoryList function Start of the function
12 0.59550094604492 Before getting categories Query to get specific category list
13 0.59616494178772 After getting categories Query to get specific category list
14 0.59616589546204 Before getting category custom Before call to function getCategoryCustom
15 0.59812998771667 After getting category custom After call to function getCategoryCustom
16 0.59813284873962 Before getting category custom Before call to function getCategoryCustom
17 0.60888290405273 After getting category custom After call to function getCategoryCustom
18 0.60888695716858 Before getting category custom Before call to function getCategoryCustom
19 0.61496996879578 After getting category custom After call to function getCategoryCustom
20 0.6149730682373 Before getting category custom Before call to function getCategoryCustom
21 0.61925101280212 After getting category custom After call to function getCategoryCustom
22 0.61925387382507 End of GetCategoryList function End of the function
23 0.6192638874054 Get Category List for Group Before the call to getCategoryList function
24 0.61926603317261 Start of GetCategoryList function Start of the function
25 0.61926984786987 Before getting categories Query to get specific category list
26 0.6197190284729 After getting categories Query to get specific category list
27 0.61971998214722 Before getting category custom Before call to function getCategoryCustom
28 0.62547492980957 After getting category custom After call to function getCategoryCustom
29 0.6254780292511 Before getting category custom Before call to function getCategoryCustom
30 0.63637685775757 After getting category custom After call to function getCategoryCustom
31 0.63637900352478 End of GetCategoryList function End of the function
32 0.63638687133789 Get Category List for Group Before the call to getCategoryList function
33 0.63638997077942 Start of GetCategoryList function Start of the function
34 0.63639402389526 Before getting categories Query to get specific category list
35 0.63731503486633 After getting categories Query to get specific category list
36 0.63731694221497 Before getting category custom Before call to function getCategoryCustom
37 0.64661502838135 After getting category custom After call to function getCategoryCustom
38 0.6466178894043 Before getting category custom Before call to function getCategoryCustom
39 0.66451907157898 After getting category custom After call to function getCategoryCustom
40 0.66452097892761 Before getting category custom Before call to function getCategoryCustom
41 0.67046999931335 After getting category custom After call to function getCategoryCustom
42 0.67047190666199 Before getting category custom Before call to function getCategoryCustom
43 0.67638492584229 After getting category custom After call to function getCategoryCustom
44 0.67638802528381 Before getting category custom Before call to function getCategoryCustom
45 0.68263387680054 After getting category custom After call to function getCategoryCustom
46 0.68263697624207 Before getting category custom Before call to function getCategoryCustom
47 0.7044460773468 After getting category custom After call to function getCategoryCustom
48 0.70444893836975 Before getting category custom Before call to function getCategoryCustom
49 0.70854187011719 After getting category custom After call to function getCategoryCustom
50 0.70854496955872 Before getting category custom Before call to function getCategoryCustom
51 0.71386790275574 After getting category custom After call to function getCategoryCustom
52 0.71387004852295 End of GetCategoryList function End of the function
53 0.71388506889343 Get Category List for Group Before the call to getCategoryList function
54 0.71388792991638 Start of GetCategoryList function Start of the function
55 0.71389102935791 Before getting categories Query to get specific category list
56 0.71430587768555 After getting categories Query to get specific category list
57 0.71430802345276 Before getting category custom Before call to function getCategoryCustom
58 0.7165789604187 After getting category custom After call to function getCategoryCustom
59 0.71658205986023 Before getting category custom Before call to function getCategoryCustom
60 0.71888494491577 After getting category custom After call to function getCategoryCustom
61 0.7188868522644 End of GetCategoryList function End of the function
62 0.71889305114746 Get Category List for Group Before the call to getCategoryList function
63 0.71889495849609 Start of GetCategoryList function Start of the function
64 0.71889805793762 Before getting categories Query to get specific category list
65 0.71920585632324 After getting categories Query to get specific category list
66 0.71920895576477 Before getting category custom Before call to function getCategoryCustom
67 0.72417998313904 After getting category custom After call to function getCategoryCustom
68 0.72418189048767 Before getting sub category list Before call to recursive function getCategoryList
69 0.72418594360352 Start of GetCategoryList function Start of the function
70 0.72418904304504 Before getting categories Query to get specific category list
71 0.72447490692139 After getting sub category list After call to recursive function getCategoryList
72 0.7244758605957 End of GetCategoryList function End of the function
73 0.72448205947876 End of getCategoryListByGroup Function Before return()
74 0.72448492050171 After Get Category List After getting the updated category list
75 0.72448587417603 Before Category Images Before getting the category images
76 0.72460794448853 After Category Images After getting the category images
77 0.72503399848938 Before Sub Category Check Before checking for sub category or products category
78 0.72527885437012 Before Category Products Controller Before loading the category products controller
79 0.72542095184326 Start Category Products Start of Category Products Controller
80 0.72544598579407 After Pagination Options After pagination options in Category Products Controller
81 0.72600507736206 After Cache After Cache checking in Category Products Controller
82 0.80901694297791 After Filter Options After getting filter options and SQL in Category Products Controller
83 0.81151604652405 After Counting Products After counting products in the Category Products Controller
84 0.8116819858551 After Counting Bundles After counting bundles in the Category Products Controller
85 0.81183385848999 After Counting Products After counting products in the Category Products Controller
86 0.81502389907837 After Getting Products After getting products and bundles in the Category Products Controller
87 0.81511402130127 After Pagination Links After getting pagination listing links in the Category Products Controller
88 0.8151159286499 After Getting Bundle Details After getting full details for the bundles in the Category Products Controller
89 1.0118849277496 After Getting Product Details After getting full product details in the Category Products Controller
90 1.0174460411072 After Getting Product/Bundle Reviews After getting full product/bundle customer review in the Category Products Controller
91 1.019031047821 App_after Controller Start Start of the App_after controller (called after the controller of every page)
92 1.0191478729248 Before Get Options Before the call to getOptions in the tpl class
93 1.455139875412 After Get Options After the call to getOptions in the tpl class
94 1.4555480480194 App_after Controller End End of the App_after controller (called after the controller of every page)
95 1.4555609226227 Before Smarty Before passing everything over to Smarty in the Category Products Controller
96 1.7844409942627 After Loading sub/product controller After checking for sub category or products category and then loading the relevant controller
97 1.7844450473785 Finalizing debug Before the debug is output to the page.
98 1.7844619750977 End of App This is the end of the app logging, final timestamp


Query Debug - 891 Database Queries. Total time 0.9103 seconds

Number Time (Seconds) Time (Milliseconds) Query
1 0.0002 0.00017619132995605
SELECT value FROM parameters WHERE `parameter` = 'BAD_BOTS_ENABLER'
2 0.0005 0.00054407119750977
SHOW TABLES LIKE 'bad_bots'
3 0.0002 0.00020599365234375
SELECT value FROM parameters WHERE `parameter` = 'STORE_WHITELISTED_IPS'
4 0.0002 0.00017380714416504
SELECT * FROM `bad_bots`
5 0.0005 0.00049018859863281
SELECT parameter, value FROM parameters
6 0.0002 0.00016593933105469
SET time_zone = 'Europe/London'
7 0.0004 0.00038790702819824
SELECT * FROM autorun ORDER BY lastrun ASC
8 0.0002 0.00016593933105469
SELECT * FROM version ORDER BY installed DESC LIMIT 1
9 0.0002 0.00021982192993164
delete from cachefiles
10 0.0002 0.00022196769714355
SELECT id FROM pages WHERE pagename = 'reviewed-products-specials' LIMIT 1
11 0.0002 0.00023198127746582
SELECT id FROM products WHERE pagename = 'reviewed-products-specials' AND hidden = 0 LIMIT 1
12 0.0001 0.00012612342834473
SELECT id FROM ebay_products WHERE pagename = 'reviewed-products-specials'
13 0.0002 0.00018405914306641
SELECT id FROM categories WHERE pagename = 'reviewed-products-specials' LIMIT 1
14 0.0010 0.00096607208251953
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-fluid'
15 0.0096 0.009598970413208
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-fluid' AND language = 'en'
16 0.0003 0.00028204917907715
SELECT * FROM pages WHERE pagename = 'reviewed-products-specials'
17 0.0051 0.0050959587097168
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
18 0.0004 0.00041794776916504
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-fluid' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
19 0.0002 0.0001988410949707
SELECT value FROM parameters WHERE parameter = 'EBAY_APP_ID' 
20 0.0002 0.00017380714416504
SELECT * FROM sideboxes_pages WHERE sidebox_id = '1'
21 0.0002 0.00018501281738281
SELECT * FROM pages WHERE id = '67'
22 0.0002 0.00017213821411133
SELECT * FROM pages WHERE id = '82'
23 0.0002 0.00018191337585449
SELECT * FROM pages WHERE id = '84'
24 0.0002 0.0001680850982666
SELECT * FROM pages WHERE id = '94'
25 0.0002 0.00017881393432617
SELECT * FROM pages WHERE id = '116'
26 0.0002 0.00023293495178223
SELECT * FROM pages WHERE id = '52'
27 0.0002 0.00017499923706055
SELECT * FROM pages WHERE id = '135'
28 0.0002 0.0001838207244873
SELECT * FROM pages WHERE id = '245'
29 0.0002 0.00018191337585449
SELECT * FROM pages WHERE id = '269'
30 0.0002 0.00021696090698242
SELECT * FROM pages WHERE id = '275'
31 0.0002 0.00019216537475586
SELECT * FROM pages WHERE id = '280'
32 0.0002 0.00023794174194336
SELECT * FROM pages WHERE id = '357'
33 0.0002 0.00016498565673828
SELECT * FROM pages WHERE id = '379'
34 0.0002 0.00015687942504883
SELECT * FROM pages WHERE id = '401'
35 0.0002 0.00016593933105469
SELECT * FROM pages WHERE id = '450'
36 0.0002 0.00016403198242188
SELECT * FROM pages WHERE id = '454'
37 0.0002 0.00018000602722168
SELECT * FROM pages WHERE id = '457'
38 0.0002 0.00018000602722168
SELECT * FROM pages WHERE id = '458'
39 0.0002 0.00017499923706055
SELECT * FROM sideboxes_pages WHERE sidebox_id = '2'
40 0.0002 0.00017881393432617
SELECT * FROM pages WHERE id = '41'
41 0.0002 0.00017619132995605
SELECT * FROM pages WHERE id = '43'
42 0.0002 0.00017690658569336
SELECT * FROM pages WHERE id = '44'
43 0.0002 0.00015997886657715
SELECT * FROM pages WHERE id = '68'
44 0.0002 0.00023317337036133
SELECT * FROM pages WHERE id = '80'
45 0.0002 0.00017499923706055
SELECT * FROM pages WHERE id = '85'
46 0.0002 0.00017714500427246
SELECT * FROM pages WHERE id = '97'
47 0.0002 0.00017404556274414
SELECT * FROM pages WHERE id = '107'
48 0.0002 0.00016903877258301
SELECT * FROM pages WHERE id = '108'
49 0.0002 0.00015902519226074
SELECT * FROM pages WHERE id = '128'
50 0.0002 0.00018405914306641
SELECT * FROM pages WHERE id = '133'
51 0.0002 0.00017189979553223
SELECT * FROM pages WHERE id = '148'
52 0.0002 0.00017380714416504
SELECT * FROM pages WHERE id = '217'
53 0.0002 0.00015711784362793
SELECT * FROM pages WHERE id = '228'
54 0.0002 0.00016403198242188
SELECT * FROM pages WHERE id = '257'
55 0.0002 0.0001680850982666
SELECT * FROM pages WHERE id = '271'
56 0.0002 0.00017905235290527
SELECT * FROM pages WHERE id = '286'
57 0.0002 0.00016093254089355
SELECT * FROM pages WHERE id = '287'
58 0.0002 0.00017690658569336
SELECT * FROM pages WHERE id = '291'
59 0.0002 0.00016999244689941
SELECT * FROM pages WHERE id = '380'
60 0.0002 0.00016903877258301
SELECT * FROM pages WHERE id = '344'
61 0.0002 0.00019717216491699
SELECT * FROM pages WHERE id = '354'
62 0.0002 0.00021505355834961
SELECT * FROM pages WHERE id = '363'
63 0.0002 0.00021600723266602
SELECT * FROM pages WHERE id = '364'
64 0.0002 0.00015997886657715
SELECT * FROM pages WHERE id = '368'
65 0.0002 0.00020313262939453
SELECT * FROM pages WHERE id = '369'
66 0.0002 0.00016403198242188
SELECT * FROM pages WHERE id = '400'
67 0.0002 0.00017309188842773
SELECT * FROM pages WHERE id = '463'
68 0.0002 0.00018787384033203
SELECT * FROM sideboxes_pages WHERE sidebox_id = '33'
69 0.0003 0.00030112266540527
SELECT * FROM pages WHERE id = '66'
70 0.0002 0.00020909309387207
SELECT * FROM pages WHERE id = '77'
71 0.0002 0.00019693374633789
SELECT * FROM pages WHERE id = '90'
72 0.0002 0.00016117095947266
SELECT * FROM pages WHERE id = '414'
73 0.0002 0.00016212463378906
SELECT * FROM pages WHERE id = '119'
74 0.0002 0.00017595291137695
SELECT * FROM pages WHERE id = '406'
75 0.0002 0.00016403198242188
SELECT * FROM pages WHERE id = '149'
76 0.0002 0.00016307830810547
SELECT * FROM pages WHERE id = '150'
77 0.0002 0.00015616416931152
SELECT * FROM pages WHERE id = '412'
78 0.0002 0.00016903877258301
SELECT * FROM pages WHERE id = '162'
79 0.0002 0.00016498565673828
SELECT * FROM pages WHERE id = '164'
80 0.0002 0.00016999244689941
SELECT * FROM pages WHERE id = '167'
81 0.0002 0.00015401840209961
SELECT * FROM pages WHERE id = '180'
82 0.0002 0.00015711784362793
SELECT * FROM pages WHERE id = '187'
83 0.0002 0.00022006034851074
SELECT * FROM pages WHERE id = '265'
84 0.0002 0.00018692016601562
SELECT * FROM pages WHERE id = '268'
85 0.0002 0.00015783309936523
SELECT * FROM pages WHERE id = '411'
86 0.0002 0.00016498565673828
SELECT * FROM pages WHERE id = '290'
87 0.0002 0.00015401840209961
SELECT * FROM pages WHERE id = '413'
88 0.0002 0.00016498565673828
SELECT * FROM pages WHERE id = '409'
89 0.0002 0.00017809867858887
SELECT * FROM pages WHERE id = '327'
90 0.0002 0.00016307830810547
SELECT * FROM pages WHERE id = '336'
91 0.0002 0.00017094612121582
SELECT * FROM pages WHERE id = '351'
92 0.0002 0.00016283988952637
SELECT * FROM pages WHERE id = '358'
93 0.0002 0.00016689300537109
SELECT * FROM pages WHERE id = '360'
94 0.0002 0.00017595291137695
SELECT * FROM pages WHERE id = '362'
95 0.0002 0.00018095970153809
SELECT * FROM pages WHERE id = '366'
96 0.0002 0.00017786026000977
SELECT * FROM pages WHERE id = '370'
97 0.0002 0.00016403198242188
SELECT * FROM pages WHERE id = '377'
98 0.0002 0.00016593933105469
SELECT * FROM pages WHERE id = '386'
99 0.0002 0.0001680850982666
SELECT * FROM pages WHERE id = '408'
100 0.0002 0.00015902519226074
SELECT * FROM pages WHERE id = '415'
101 0.0002 0.00017285346984863
SELECT * FROM pages WHERE id = '416'
102 0.0002 0.00021886825561523
SELECT * FROM pages WHERE id = '419'
103 0.0002 0.00018000602722168
SELECT * FROM pages WHERE id = '423'
104 0.0002 0.0001671314239502
SELECT * FROM pages WHERE id = '427'
105 0.0002 0.00022792816162109
SELECT * FROM pages WHERE id = '428'
106 0.0002 0.00015783309936523
SELECT * FROM pages WHERE id = '432'
107 0.0002 0.00015807151794434
SELECT * FROM pages WHERE id = '433'
108 0.0002 0.00017404556274414
SELECT * FROM pages WHERE id = '436'
109 0.0002 0.00016403198242188
SELECT * FROM pages WHERE id = '437'
110 0.0002 0.00016999244689941
SELECT * FROM pages WHERE id = '461'
111 0.0002 0.00019693374633789
SELECT * FROM pages WHERE id = '464'
112 0.0002 0.00017213821411133
SELECT * FROM sideboxes_pages WHERE sidebox_id = '34'
113 0.0002 0.00017786026000977
SELECT * FROM pages WHERE id = '74'
114 0.0002 0.00016212463378906
SELECT * FROM pages WHERE id = '137'
115 0.0002 0.00016689300537109
SELECT * FROM pages WHERE id = '145'
116 0.0002 0.00016403198242188
SELECT * FROM pages WHERE id = '156'
117 0.0002 0.00015997886657715
SELECT * FROM pages WHERE id = '407'
118 0.0002 0.00017118453979492
SELECT * FROM pages WHERE id = '410'
119 0.0002 0.00018715858459473
SELECT * FROM pages WHERE id = '266'
120 0.0002 0.00024199485778809
SELECT * FROM pages WHERE id = '316'
121 0.0002 0.00017595291137695
SELECT * FROM pages WHERE id = '332'
122 0.0002 0.00020122528076172
SELECT * FROM pages WHERE id = '334'
123 0.0002 0.00016117095947266
SELECT * FROM pages WHERE id = '367'
124 0.0002 0.00016307830810547
SELECT * FROM pages WHERE id = '387'
125 0.0002 0.00016188621520996
SELECT * FROM pages WHERE id = '389'
126 0.0002 0.00017404556274414
SELECT * FROM pages WHERE id = '397'
127 0.0002 0.0001828670501709
SELECT * FROM pages WHERE id = '449'
128 0.0002 0.00018215179443359
SELECT * FROM sideboxes_pages WHERE sidebox_id = '35'
129 0.0002 0.00021791458129883
SELECT * FROM pages WHERE id = '42'
130 0.0002 0.0001671314239502
SELECT * FROM pages WHERE id = '79'
131 0.0002 0.00018620491027832
SELECT * FROM pages WHERE id = '86'
132 0.0002 0.00016117095947266
SELECT * FROM pages WHERE id = '95'
133 0.0002 0.0001680850982666
SELECT * FROM pages WHERE id = '102'
134 0.0002 0.00015902519226074
SELECT * FROM pages WHERE id = '109'
135 0.0002 0.00024199485778809
SELECT * FROM pages WHERE id = '114'
136 0.0002 0.00023913383483887
SELECT * FROM pages WHERE id = '121'
137 0.0002 0.00021004676818848
SELECT * FROM pages WHERE id = '138'
138 0.0002 0.00016880035400391
SELECT * FROM pages WHERE id = '142'
139 0.0002 0.00021815299987793
SELECT * FROM pages WHERE id = '62'
140 0.0002 0.00017213821411133
SELECT * FROM pages WHERE id = '157'
141 0.0002 0.00017213821411133
SELECT * FROM pages WHERE id = '246'
142 0.0002 0.0002129077911377
SELECT * FROM pages WHERE id = '276'
143 0.0002 0.00019598007202148
SELECT * FROM pages WHERE id = '278'
144 0.0003 0.00025296211242676
SELECT * FROM pages WHERE id = '279'
145 0.0002 0.00017809867858887
SELECT * FROM pages WHERE id = '317'
146 0.0002 0.00016283988952637
SELECT * FROM pages WHERE id = '405'
147 0.0002 0.00018501281738281
SELECT * FROM pages WHERE id = '343'
148 0.0002 0.0001671314239502
SELECT * FROM pages WHERE id = '345'
149 0.0002 0.00022101402282715
SELECT * FROM pages WHERE id = '346'
150 0.0002 0.00017189979553223
SELECT * FROM pages WHERE id = '347'
151 0.0002 0.00017499923706055
SELECT * FROM pages WHERE id = '348'
152 0.0002 0.00016903877258301
SELECT * FROM pages WHERE id = '349'
153 0.0002 0.00016403198242188
SELECT * FROM pages WHERE id = '381'
154 0.0002 0.00018095970153809
SELECT * FROM pages WHERE id = '392'
155 0.0002 0.00016307830810547
SELECT * FROM pages WHERE id = '393'
156 0.0002 0.00016498565673828
SELECT * FROM pages WHERE id = '394'
157 0.0002 0.0001671314239502
SELECT * FROM pages WHERE id = '395'
158 0.0002 0.00017499923706055
SELECT * FROM pages WHERE id = '399'
159 0.0002 0.00017690658569336
SELECT * FROM pages WHERE id = '421'
160 0.0002 0.00015711784362793
SELECT * FROM pages WHERE id = '426'
161 0.0002 0.00015711784362793
SELECT * FROM pages WHERE id = '430'
162 0.0002 0.00016188621520996
SELECT * FROM pages WHERE id = '431'
163 0.0002 0.00016903877258301
SELECT * FROM pages WHERE id = '434'
164 0.0002 0.00017213821411133
SELECT * FROM pages WHERE id = '435'
165 0.0002 0.00018095970153809
SELECT * FROM pages WHERE id = '440'
166 0.0002 0.00017213821411133
SELECT * FROM pages WHERE id = '441'
167 0.0002 0.00017023086547852
SELECT * FROM pages WHERE id = '451'
168 0.0002 0.00016617774963379
SELECT * FROM pages WHERE id = '453'
169 0.0002 0.00016689300537109
SELECT * FROM sideboxes_pages WHERE sidebox_id = '37'
170 0.0002 0.00019097328186035
SELECT * FROM pages WHERE id = '146'
171 0.0002 0.00016212463378906
SELECT * FROM pages WHERE id = '158'
172 0.0002 0.00015807151794434
SELECT * FROM pages WHERE id = '163'
173 0.0003 0.00025606155395508
SELECT * FROM pages WHERE id = '293'
174 0.0002 0.00016593933105469
SELECT * FROM pages WHERE id = '340'
175 0.0002 0.0001680850982666
SELECT * FROM pages WHERE id = '417'
176 0.0002 0.00015807151794434
SELECT * FROM sideboxes_pages WHERE sidebox_id = '40'
177 0.0002 0.00019288063049316
SELECT * FROM pages WHERE id = '173'
178 0.0002 0.00017404556274414
SELECT * FROM pages WHERE id = '181'
179 0.0002 0.00016117095947266
SELECT * FROM pages WHERE id = '288'
180 0.0002 0.00016903877258301
SELECT * FROM pages WHERE id = '299'
181 0.0002 0.00016498565673828
SELECT * FROM pages WHERE id = '300'
182 0.0002 0.00017213821411133
SELECT * FROM pages WHERE id = '383'
183 0.0002 0.00016117095947266
SELECT * FROM pages WHERE id = '385'
184 0.0002 0.00016212463378906
SELECT * FROM pages WHERE id = '438'
185 0.0002 0.00017905235290527
SELECT * FROM pages WHERE id = '442'
186 0.0002 0.00015711784362793
SELECT * FROM sideboxes_pages WHERE sidebox_id = '38'
187 0.0003 0.00029611587524414
SELECT * FROM pages WHERE id = '103'
188 0.0002 0.00023102760314941
SELECT * FROM pages WHERE id = '134'
189 0.0002 0.00016617774963379
SELECT * FROM pages WHERE id = '139'
190 0.0002 0.00017714500427246
SELECT * FROM pages WHERE id = '143'
191 0.0002 0.00017786026000977
SELECT * FROM pages WHERE id = '234'
192 0.0002 0.00018000602722168
SELECT * FROM pages WHERE id = '248'
193 0.0002 0.00016999244689941
SELECT * FROM pages WHERE id = '260'
194 0.0002 0.00017619132995605
SELECT * FROM pages WHERE id = '398'
195 0.0002 0.00017404556274414
SELECT * FROM sideboxes_pages WHERE sidebox_id = '29'
196 0.0002 0.00018715858459473
SELECT * FROM pages WHERE id = '61'
197 0.0002 0.00017285346984863
SELECT * FROM pages WHERE id = '87'
198 0.0002 0.00017619132995605
SELECT * FROM pages WHERE id = '104'
199 0.0002 0.00022315979003906
SELECT * FROM pages WHERE id = '115'
200 0.0002 0.00016403198242188
SELECT * FROM pages WHERE id = '124'
201 0.0002 0.00017189979553223
SELECT * FROM pages WHERE id = '144'
202 0.0002 0.00020194053649902
SELECT * FROM pages WHERE id = '151'
203 0.0002 0.00015497207641602
SELECT * FROM pages WHERE id = '199'
204 0.0002 0.00016498565673828
SELECT * FROM pages WHERE id = '200'
205 0.0002 0.00017404556274414
SELECT * FROM pages WHERE id = '304'
206 0.0002 0.00015902519226074
SELECT * FROM pages WHERE id = '321'
207 0.0002 0.00015997886657715
SELECT * FROM pages WHERE id = '333'
208 0.0002 0.00017285346984863
SELECT * FROM pages WHERE id = '350'
209 0.0002 0.00015807151794434
SELECT * FROM pages WHERE id = '378'
210 0.0002 0.00017619132995605
SELECT * FROM pages WHERE id = '422'
211 0.0002 0.00020217895507812
SELECT * FROM pages WHERE id = '425'
212 0.0002 0.00016093254089355
SELECT * FROM pages WHERE id = '443'
213 0.0002 0.00016498565673828
SELECT * FROM pages WHERE id = '444'
214 0.0002 0.00016117095947266
SELECT * FROM pages WHERE id = '445'
215 0.0002 0.0001671314239502
SELECT * FROM pages WHERE id = '446'
216 0.0002 0.00016021728515625
SELECT * FROM pages WHERE id = '447'
217 0.0002 0.00015997886657715
SELECT * FROM pages WHERE id = '448'
218 0.0002 0.00017380714416504
SELECT * FROM pages WHERE id = '455'
219 0.0002 0.00017094612121582
SELECT * FROM pages WHERE id = '456'
220 0.0002 0.00016212463378906
SELECT * FROM pages WHERE id = '459'
221 0.0002 0.0001838207244873
SELECT * FROM pages WHERE id = '460'
222 0.0002 0.00016498565673828
SELECT * FROM pages WHERE id = '462'
223 0.0002 0.00016498565673828
SELECT * FROM sideboxes_pages WHERE sidebox_id = '32'
224 0.0002 0.00018882751464844
SELECT * FROM pages WHERE id = '153'
225 0.0002 0.00023698806762695
SELECT * FROM pages WHERE id = '182'
226 0.0002 0.00016498565673828
SELECT * FROM pages WHERE id = '238'
227 0.0002 0.00015807151794434
SELECT * FROM pages WHERE id = '240'
228 0.0002 0.0001530647277832
SELECT * FROM pages WHERE id = '242'
229 0.0002 0.00015687942504883
SELECT * FROM pages WHERE id = '252'
230 0.0002 0.00015687942504883
SELECT * FROM pages WHERE id = '253'
231 0.0002 0.00015711784362793
SELECT * FROM pages WHERE id = '262'
232 0.0002 0.00015592575073242
SELECT * FROM pages WHERE id = '267'
233 0.0002 0.00016689300537109
SELECT * FROM pages WHERE id = '420'
234 0.0002 0.00015902519226074
SELECT value FROM parameters WHERE parameter = 'GOOGLE_SITE_KEY' 
235 0.0001 0.00013399124145508
SELECT value FROM parameters WHERE parameter = 'GOOGLE_SECRET_KEY' 
236 0.0001 0.00014305114746094
SELECT value FROM parameters WHERE parameter = 'GOOGLE_RECAPTCHA_TYPE' 
237 0.0016 0.0015871524810791
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
238 0.0004 0.00041317939758301
SELECT * FROM categories WHERE pagename = 'reviewed-products-specials'
239 0.0022 0.002187967300415
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
240 0.0001 0.00012803077697754
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 92
241 0.0003 0.00029706954956055
SELECT id FROM categories WHERE parent_id = '92'
242 0.0021 0.0021169185638428
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 
243 0.0002 0.00016903877258301
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (92)
				  AND p.disabled = 0 
244 0.0002 0.00017309188842773
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 
245 0.0002 0.00017094612121582
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '92'
246 0.0003 0.00026893615722656
SELECT id FROM categories WHERE parent_id = '92'
247 0.0022 0.0021519660949707
SELECT p.id FROM products p, products_categories c WHERE p.id = c.product_id AND c.category_id IN (92) 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.0002 0.00024604797363281
SELECT * FROM productimages WHERE product_id = '407894' ORDER BY sortorder ASC
249 0.0001 0.00011992454528809
SELECT * FROM categoryimages WHERE category_id = 92
250 0.0001 0.00013399124145508
SELECT * FROM categorygroups WHERE id = '20'
251 0.0021 0.0021200180053711
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 = '92'
		  AND p.offers > 0
		  AND p.hidden = 0
		  AND p.enabled = 1
		  AND p.parent = 0
		  AND p.price > 0
252 0.0001 0.00014090538024902
SELECT parent_id FROM categories WHERE id = '92'
253 0.0001 0.00012707710266113
SELECT parent_id FROM categories WHERE id = '92'
254 0.0002 0.00015497207641602
SELECT * FROM categorygroups ORDER BY sortorder ASC
255 0.0006 0.00055599212646484
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
256 0.0005 0.00047111511230469
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
257 0.0002 0.00024700164794922
SELECT id FROM categories WHERE parent_id = '49'
258 0.0005 0.00045990943908691
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 
259 0.0002 0.0001530647277832
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (49)
				  AND p.disabled = 0 
260 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 (49)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
261 0.0002 0.00018906593322754
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '49'
262 0.0001 0.0001368522644043
SELECT * FROM categorygroups WHERE id = '1'
263 0.0030 0.003014087677002
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
264 0.0003 0.00026893615722656
SELECT id FROM categories WHERE parent_id = '50'
265 0.0002 0.00022292137145996
SELECT id FROM categories WHERE parent_id = '96'
266 0.0002 0.00021195411682129
SELECT id FROM categories WHERE parent_id = '97'
267 0.0002 0.00022292137145996
SELECT id FROM categories WHERE parent_id = '111'
268 0.0002 0.00021100044250488
SELECT id FROM categories WHERE parent_id = '129'
269 0.0057 0.0057418346405029
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 
270 0.0002 0.00017905235290527
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (96,97,111,129,50)
				  AND p.disabled = 0 
271 0.0002 0.00016689300537109
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (96,97,111,129,50)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
272 0.0002 0.00018501281738281
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '50'
273 0.0001 0.00013589859008789
SELECT * FROM categorygroups WHERE id = '1'
274 0.0025 0.002532958984375
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
275 0.0003 0.00026798248291016
SELECT id FROM categories WHERE parent_id = '80'
276 0.0025 0.0025238990783691
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 
277 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 
278 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 (80)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
279 0.0002 0.00017595291137695
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '80'
280 0.0001 0.00014996528625488
SELECT * FROM categorygroups WHERE id = '1'
281 0.0012 0.0011701583862305
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
282 0.0003 0.00026297569274902
SELECT id FROM categories WHERE parent_id = '51'
283 0.0002 0.00022602081298828
SELECT id FROM categories WHERE parent_id = '101'
284 0.0018 0.0018160343170166
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 
285 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 
286 0.0002 0.00016021728515625
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 
287 0.0002 0.00019502639770508
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '51'
288 0.0001 0.00013518333435059
SELECT * FROM categorygroups WHERE id = '1'
289 0.0004 0.00041890144348145
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '2'  AND hidden = 0 ORDER BY sortorder ASC
290 0.0024 0.0023829936981201
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
291 0.0003 0.00026297569274902
SELECT id FROM categories WHERE parent_id = '30'
292 0.0023 0.0023431777954102
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 
293 0.0002 0.00015401840209961
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (30)
				  AND p.disabled = 0 
294 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 
295 0.0002 0.00018191337585449
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
296 0.0001 0.00013494491577148
SELECT * FROM categorygroups WHERE id = '2'
297 0.0049 0.0048727989196777
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
298 0.0003 0.0002751350402832
SELECT id FROM categories WHERE parent_id = '61'
299 0.0050 0.0049560070037842
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 
300 0.0002 0.00016903877258301
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (61)
				  AND p.disabled = 0 
301 0.0002 0.00017094612121582
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 
302 0.0002 0.00018191337585449
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '61'
303 0.0001 0.00014495849609375
SELECT * FROM categorygroups WHERE id = '2'
304 0.0007 0.00073504447937012
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '10'  AND hidden = 0 ORDER BY sortorder ASC
305 0.0042 0.0041799545288086
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
306 0.0003 0.00026392936706543
SELECT id FROM categories WHERE parent_id = '64'
307 0.0042 0.0041530132293701
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 
308 0.0002 0.00015902519226074
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (64)
				  AND p.disabled = 0 
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 (64)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
310 0.0002 0.00016093254089355
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '64'
311 0.0001 0.0001218318939209
SELECT * FROM categorygroups WHERE id = '10'
312 0.0085 0.0084569454193115
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
313 0.0003 0.00028395652770996
SELECT id FROM categories WHERE parent_id = '65'
314 0.0084 0.0084238052368164
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 
315 0.0002 0.00017404556274414
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (65)
				  AND p.disabled = 0 
316 0.0001 0.00014591217041016
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 
317 0.0002 0.00016498565673828
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '65'
318 0.0001 0.0001218318939209
SELECT * FROM categorygroups WHERE id = '10'
319 0.0025 0.002504825592041
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
320 0.0003 0.0002589225769043
SELECT id FROM categories WHERE parent_id = '81'
321 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 (81)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
322 0.0002 0.00015997886657715
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (81)
				  AND p.disabled = 0 
323 0.0001 0.00014400482177734
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (81)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
324 0.0002 0.00015687942504883
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '81'
325 0.0001 0.0001220703125
SELECT * FROM categorygroups WHERE id = '10'
326 0.0025 0.0024838447570801
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
327 0.0003 0.00025486946105957
SELECT id FROM categories WHERE parent_id = '31'
328 0.0025 0.0024940967559814
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 
329 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 (31)
				  AND p.disabled = 0 
330 0.0002 0.0001518726348877
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 
331 0.0002 0.00016999244689941
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
332 0.0001 0.00012302398681641
SELECT * FROM categorygroups WHERE id = '10'
333 0.0023 0.0022671222686768
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
334 0.0003 0.00026106834411621
SELECT id FROM categories WHERE parent_id = '66'
335 0.0002 0.00020098686218262
SELECT id FROM categories WHERE parent_id = '131'
336 0.0028 0.0028328895568848
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 
337 0.0002 0.0001518726348877
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (131,66)
				  AND p.disabled = 0 
338 0.0001 0.00014591217041016
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 
339 0.0002 0.00015592575073242
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '66'
340 0.0001 0.00012087821960449
SELECT * FROM categorygroups WHERE id = '10'
341 0.0096 0.0095617771148682
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
342 0.0003 0.00028300285339355
SELECT id FROM categories WHERE parent_id = '34'
343 0.0002 0.0001990795135498
SELECT id FROM categories WHERE parent_id = '94'
344 0.0002 0.00019598007202148
SELECT id FROM categories WHERE parent_id = '98'
345 0.0002 0.0001981258392334
SELECT id FROM categories WHERE parent_id = '99'
346 0.0002 0.00019502639770508
SELECT id FROM categories WHERE parent_id = '110'
347 0.0002 0.00019407272338867
SELECT id FROM categories WHERE parent_id = '130'
348 0.0102 0.010166168212891
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 
349 0.0002 0.00017905235290527
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (94,98,99,110,130,34)
				  AND p.disabled = 0 
350 0.0002 0.00015616416931152
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 
351 0.0002 0.00017690658569336
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '34'
352 0.0001 0.00012898445129395
SELECT * FROM categorygroups WHERE id = '10'
353 0.0016 0.0015630722045898
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
354 0.0003 0.0002598762512207
SELECT id FROM categories WHERE parent_id = '32'
355 0.0016 0.0015838146209717
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 
356 0.0002 0.0001671314239502
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 
357 0.0001 0.00014400482177734
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (32)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
358 0.0002 0.00015902519226074
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '32'
359 0.0001 0.00012087821960449
SELECT * FROM categorygroups WHERE id = '10'
360 0.0022 0.0021858215332031
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
361 0.0003 0.00025796890258789
SELECT id FROM categories WHERE parent_id = '89'
362 0.0022 0.0022058486938477
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 
363 0.0002 0.00015115737915039
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 
364 0.0001 0.00014281272888184
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (89)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
365 0.0002 0.00016498565673828
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '89'
366 0.0001 0.0001220703125
SELECT * FROM categorygroups WHERE id = '10'
367 0.0004 0.00039005279541016
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '17'  AND hidden = 0 ORDER BY sortorder ASC
368 0.0007 0.00068306922912598
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
369 0.0002 0.00022697448730469
SELECT id FROM categories WHERE parent_id = '84'
370 0.0007 0.00070285797119141
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 
371 0.0001 0.00014305114746094
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 
372 0.0001 0.00014185905456543
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 
373 0.0002 0.00016283988952637
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '84'
374 0.0001 0.00011992454528809
SELECT * FROM categorygroups WHERE id = '17'
375 0.0007 0.00070810317993164
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
376 0.0002 0.0002291202545166
SELECT id FROM categories WHERE parent_id = '90'
377 0.0007 0.00072598457336426
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 
378 0.0001 0.00014114379882812
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 
379 0.0001 0.00013995170593262
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 
380 0.0002 0.00015091896057129
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '90'
381 0.0001 0.00011897087097168
SELECT * FROM categorygroups WHERE id = '17'
382 0.0003 0.00029587745666504
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '20'  AND hidden = 0 ORDER BY sortorder ASC
383 0.0020 0.0020358562469482
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
384 0.0002 0.00023198127746582
SELECT id FROM categories WHERE parent_id = '92'
385 0.0020 0.0020468235015869
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 
386 0.0001 0.00014209747314453
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (92)
				  AND p.disabled = 0 
387 0.0001 0.00014185905456543
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 
388 0.0002 0.00015401840209961
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '92'
389 0.0001 0.00012111663818359
SELECT * FROM categorygroups WHERE id = '20'
390 0.0003 0.0002748966217041
SELECT * FROM categories WHERE parent_id = '92'  AND hidden = 0 ORDER BY sortorder ASC
391 0.0001 0.0001060962677002
SELECT * FROM categoryimages WHERE category_id = 92
392 0.0002 0.00017285346984863
SELECT * FROM template_info WHERE templateuid = 'fsb-fluid'
393 0.0002 0.00023102760314941
SELECT * FROM categories WHERE parent_id = '92'
394 0.0342 0.034162044525146
SELECT MAX(price) as maxprice, MIN(price) as minprice FROM products WHERE enabled = 1 AND hidden = 0 AND price <> 0 
395 0.0062 0.0062129497528076
SELECT * FROM manufacturers WHERE display_filter = 1 AND merge_manufacturer_id = 0 ORDER BY name
396 0.0003 0.00029993057250977
SELECT * FROM productattributenames n WHERE hidden = 0 AND metabrowse = 1 ORDER BY n.displayname ASC
397 0.0342 0.034191131591797
SELECT MAX(price) as maxprice, MIN(price) as minprice FROM products WHERE enabled = 1 AND hidden = 0 AND price <> 0 
398 0.0061 0.0061249732971191
SELECT * FROM manufacturers WHERE display_filter = 1 AND merge_manufacturer_id = 0 ORDER BY name
399 0.0003 0.00030994415283203
SELECT * FROM productattributenames n WHERE hidden = 0 AND metabrowse = 1 AND sidebarfilter = 1 ORDER BY n.displayname ASC
400 0.0023 0.0022881031036377
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 = 92
		AND (c.prod_type = '' OR c.prod_type = 'amz')
		AND hidden = 0
		AND enabled = 1
		
		AND 1 = 1
401 0.0002 0.0001678466796875
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
		WHERE ep.id = c.product_id
		AND c.category_id = 92
		AND c.prod_type = 'ebay'
		AND hide = 1
402 0.0001 0.00014305114746094
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 = 92
			AND p.disabled = 0
			
			AND 1 = 1
403 0.0001 0.00013899803161621
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
		WHERE cp.id = c.product_id
		AND c.category_id = 92
		AND c.prod_type = 'custom'
		AND hide = 1
404 0.0031 0.0031018257141113
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 = 92
			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 = 92
		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 = 92
		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 = 92
			AND disabled = 0
			
			AND 1 = 1 ORDER BY salesrank ASC LIMIT 0, 18
405 0.0002 0.00022602081298828
SELECT * FROM products WHERE id = '407894'
406 0.0002 0.00021696090698242
SELECT * FROM productimages WHERE product_id = '407894' ORDER BY sortorder ASC
407 0.0002 0.00021696090698242
SELECT * FROM product_image_select WHERE product_id = '407894'
408 0.0001 0.0001370906829834
SELECT * FROM productcustomimages WHERE product_id = '407894'
409 0.0031 0.0031020641326904
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '407894' AND a.name = n.originalname
410 0.0002 0.00018000602722168
SELECT * FROM productoffers WHERE product_id = '407894' AND merchantid = 'ATVPDKIKX0DER'
411 0.0002 0.00018310546875
SELECT * FROM productoffers
                WHERE product_id = '407894' AND price > 0
                ORDER BY price ASC LIMIT 1
412 0.0002 0.00016093254089355
SELECT * FROM productoffers
                WHERE product_id = 407894
                ORDER BY price ASC LIMIT 1
413 0.0002 0.00021600723266602
SELECT value FROM productattributes
                WHERE product_id = '407894'
                AND name = 'ListPriceAmount'
414 0.0001 0.00013089179992676
UPDATE products SET price = '3999' WHERE id = '407894'
415 0.0002 0.00019979476928711
SELECT * FROM products WHERE id = '410606'
416 0.0002 0.00019598007202148
SELECT * FROM productimages WHERE product_id = '410606' ORDER BY sortorder ASC
417 0.0005 0.00054001808166504
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '410606' AND p.id = pi.product_id ORDER BY pi.sortorder
418 0.0002 0.00021600723266602
SELECT * FROM product_image_select WHERE product_id = '410606'
419 0.0001 0.00011897087097168
SELECT * FROM productcustomimages WHERE product_id = '410606'
420 0.0003 0.00032305717468262
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 = '410606'
                GROUP BY o.product_id
421 0.0004 0.00036311149597168
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     = '410606'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
422 0.0003 0.00025701522827148
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 410606
423 0.0036 0.0035550594329834
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '410606' AND a.name = n.originalname
424 0.0002 0.00017189979553223
SELECT * FROM productoffers WHERE product_id = '410606' AND merchantid = 'ATVPDKIKX0DER'
425 0.0002 0.00017595291137695
SELECT * FROM productoffers
                WHERE product_id = '410606' AND price > 0
                ORDER BY price ASC LIMIT 1
426 0.0002 0.00015783309936523
SELECT * FROM productoffers
                WHERE product_id = 410606
                ORDER BY price ASC LIMIT 1
427 0.0003 0.00028705596923828
SELECT value FROM productattributes
                WHERE product_id = '410606'
                AND name = 'ListPriceAmount'
428 0.0003 0.00029301643371582
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 = '410606'
                GROUP BY o.product_id
429 0.0003 0.00033903121948242
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     = '410606'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
430 0.0003 0.00026488304138184
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 410606
431 0.0004 0.00044083595275879
SELECT value FROM productattributes WHERE product_id = '410606' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
432 0.0001 0.00011897087097168
UPDATE products SET price = '12999' WHERE id = '410606'
433 0.0004 0.00038290023803711
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '410606'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Color'
                GROUP BY o.value
                ORDER BY o.value ASC
434 0.0002 0.00020694732666016
SELECT * FROM products WHERE id = '410614'
435 0.0002 0.00018906593322754
SELECT * FROM productimages WHERE product_id = '410614' ORDER BY sortorder ASC
436 0.0003 0.00031685829162598
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '410614' AND p.id = pi.product_id ORDER BY pi.sortorder
437 0.0002 0.00020790100097656
SELECT * FROM product_image_select WHERE product_id = '410614'
438 0.0001 0.00011897087097168
SELECT * FROM productcustomimages WHERE product_id = '410614'
439 0.0003 0.00026392936706543
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 = '410614'
                GROUP BY o.product_id
440 0.0004 0.00039410591125488
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     = '410614'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
441 0.0002 0.00022602081298828
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 410614
442 0.0025 0.0025351047515869
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '410614' AND a.name = n.originalname
443 0.0002 0.00018191337585449
SELECT * FROM productoffers WHERE product_id = '410614' AND merchantid = 'ATVPDKIKX0DER'
444 0.0002 0.00017404556274414
SELECT * FROM productoffers
                WHERE product_id = '410614' AND price > 0
                ORDER BY price ASC LIMIT 1
445 0.0002 0.00016093254089355
SELECT * FROM productoffers
                WHERE product_id = 410614
                ORDER BY price ASC LIMIT 1
446 0.0002 0.00024700164794922
SELECT value FROM productattributes
                WHERE product_id = '410614'
                AND name = 'ListPriceAmount'
447 0.0003 0.00026297569274902
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 = '410614'
                GROUP BY o.product_id
448 0.0004 0.00039100646972656
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     = '410614'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
449 0.0002 0.0002281665802002
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 410614
450 0.0004 0.00038409233093262
SELECT value FROM productattributes WHERE product_id = '410614' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
451 0.0001 0.00011801719665527
UPDATE products SET price = '2249' WHERE id = '410614'
452 0.0003 0.00034785270690918
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '410614'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Size'
                GROUP BY o.value
                ORDER BY o.value ASC
453 0.0004 0.00035309791564941
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '410614'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Color'
                GROUP BY o.value
                ORDER BY o.value ASC
454 0.0002 0.00021481513977051
SELECT * FROM products WHERE id = '407875'
455 0.0002 0.00019001960754395
SELECT * FROM productimages WHERE product_id = '407875' ORDER BY sortorder ASC
456 0.0002 0.00021600723266602
SELECT * FROM product_image_select WHERE product_id = '407875'
457 0.0001 0.00011706352233887
SELECT * FROM productcustomimages WHERE product_id = '407875'
458 0.0024 0.0023760795593262
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '407875' AND a.name = n.originalname
459 0.0002 0.00017094612121582
SELECT * FROM productoffers WHERE product_id = '407875' AND merchantid = 'ATVPDKIKX0DER'
460 0.0002 0.00017285346984863
SELECT * FROM productoffers
                WHERE product_id = '407875' AND price > 0
                ORDER BY price ASC LIMIT 1
461 0.0002 0.00016188621520996
SELECT * FROM productoffers
                WHERE product_id = 407875
                ORDER BY price ASC LIMIT 1
462 0.0002 0.00023794174194336
SELECT value FROM productattributes
                WHERE product_id = '407875'
                AND name = 'ListPriceAmount'
463 0.0001 0.00012993812561035
UPDATE products SET price = '2997' WHERE id = '407875'
464 0.0002 0.00019598007202148
SELECT * FROM products WHERE id = '410601'
465 0.0002 0.00024104118347168
SELECT * FROM productimages WHERE product_id = '410601' ORDER BY sortorder ASC
466 0.0003 0.0003349781036377
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '410601' AND p.id = pi.product_id ORDER BY pi.sortorder
467 0.0002 0.00021815299987793
SELECT * FROM product_image_select WHERE product_id = '410601'
468 0.0001 0.00011897087097168
SELECT * FROM productcustomimages WHERE product_id = '410601'
469 0.0003 0.0002598762512207
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 = '410601'
                GROUP BY o.product_id
470 0.0003 0.00029492378234863
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     = '410601'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
471 0.0002 0.00023102760314941
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 410601
472 0.0032 0.0031898021697998
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '410601' AND a.name = n.originalname
473 0.0002 0.00017499923706055
SELECT * FROM productoffers WHERE product_id = '410601' AND merchantid = 'ATVPDKIKX0DER'
474 0.0002 0.00017595291137695
SELECT * FROM productoffers
                WHERE product_id = '410601' AND price > 0
                ORDER BY price ASC LIMIT 1
475 0.0002 0.00016093254089355
SELECT * FROM productoffers
                WHERE product_id = 410601
                ORDER BY price ASC LIMIT 1
476 0.0003 0.00027704238891602
SELECT value FROM productattributes
                WHERE product_id = '410601'
                AND name = 'ListPriceAmount'
477 0.0003 0.00025701522827148
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 = '410601'
                GROUP BY o.product_id
478 0.0003 0.00028800964355469
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     = '410601'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
479 0.0002 0.0002288818359375
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 410601
480 0.0004 0.0004119873046875
SELECT value FROM productattributes WHERE product_id = '410601' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
481 0.0001 0.00011610984802246
UPDATE products SET price = '9999' WHERE id = '410601'
482 0.0003 0.00032711029052734
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '410601'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Color'
                GROUP BY o.value
                ORDER BY o.value ASC
483 0.0002 0.00020599365234375
SELECT * FROM products WHERE id = '410613'
484 0.0002 0.00015997886657715
SELECT * FROM productimages WHERE product_id = '410613' ORDER BY sortorder ASC
485 0.0002 0.00020980834960938
SELECT * FROM product_image_select WHERE product_id = '410613'
486 0.0001 0.00011801719665527
SELECT * FROM productcustomimages WHERE product_id = '410613'
487 0.0025 0.0025441646575928
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '410613' AND a.name = n.originalname
488 0.0002 0.00017189979553223
SELECT * FROM productoffers WHERE product_id = '410613' AND merchantid = 'ATVPDKIKX0DER'
489 0.0002 0.00017309188842773
SELECT * FROM productoffers
                WHERE product_id = '410613' AND price > 0
                ORDER BY price ASC LIMIT 1
490 0.0002 0.00016188621520996
SELECT * FROM productoffers
                WHERE product_id = 410613
                ORDER BY price ASC LIMIT 1
491 0.0003 0.00026798248291016
SELECT value FROM productattributes
                WHERE product_id = '410613'
                AND name = 'ListPriceAmount'
492 0.0001 0.00011777877807617
UPDATE products SET price = '490' WHERE id = '410613'
493 0.0002 0.00019288063049316
SELECT * FROM products WHERE id = '410619'
494 0.0003 0.00026607513427734
SELECT * FROM productimages WHERE product_id = '410619' ORDER BY sortorder ASC
495 0.0626 0.062562942504883
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '410619' AND p.id = pi.product_id ORDER BY pi.sortorder
496 0.0003 0.00031518936157227
SELECT * FROM product_image_select WHERE product_id = '410619'
497 0.0001 0.00012898445129395
SELECT * FROM productcustomimages WHERE product_id = '410619'
498 0.0003 0.0002901554107666
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 = '410619'
                GROUP BY o.product_id
499 0.0003 0.00032997131347656
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     = '410619'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
500 0.0002 0.00020790100097656
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 410619
501 0.0036 0.0035879611968994
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '410619' AND a.name = n.originalname
502 0.0002 0.00018000602722168
SELECT * FROM productoffers WHERE product_id = '410619' AND merchantid = 'ATVPDKIKX0DER'
503 0.0002 0.00018620491027832
SELECT * FROM productoffers
                WHERE product_id = '410619' AND price > 0
                ORDER BY price ASC LIMIT 1
504 0.0002 0.00016903877258301
SELECT * FROM productoffers
                WHERE product_id = 410619
                ORDER BY price ASC LIMIT 1
505 0.0003 0.00028300285339355
SELECT value FROM productattributes
                WHERE product_id = '410619'
                AND name = 'ListPriceAmount'
506 0.0002 0.00022697448730469
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 = '410619'
                GROUP BY o.product_id
507 0.0003 0.00029206275939941
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     = '410619'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
508 0.0002 0.00021004676818848
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 410619
509 0.0004 0.0004420280456543
SELECT value FROM productattributes WHERE product_id = '410619' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
510 0.0003 0.00033712387084961
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '410619'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Color'
                GROUP BY o.value
                ORDER BY o.value ASC
511 0.0002 0.00023388862609863
SELECT * FROM products WHERE id = '413553'
512 0.0002 0.0001521110534668
SELECT * FROM productimages WHERE product_id = '413553' ORDER BY sortorder ASC
513 0.0003 0.00032281875610352
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '413553' AND p.id = pi.product_id ORDER BY pi.sortorder
514 0.0003 0.00027799606323242
SELECT * FROM product_image_select WHERE product_id = '413553'
515 0.0002 0.00015115737915039
SELECT * FROM productcustomimages WHERE product_id = '413553'
516 0.0003 0.00025105476379395
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 = '413553'
                GROUP BY o.product_id
517 0.0003 0.00033712387084961
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     = '413553'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
518 0.0002 0.00023508071899414
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 413553
519 0.0007 0.00071597099304199
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '413553' AND a.name = n.originalname
520 0.0002 0.00019502639770508
SELECT * FROM productoffers WHERE product_id = '413553' AND merchantid = 'ATVPDKIKX0DER'
521 0.0002 0.0001981258392334
SELECT * FROM productoffers
                WHERE product_id = '413553' AND price > 0
                ORDER BY price ASC LIMIT 1
522 0.0002 0.00018310546875
SELECT * FROM productoffers
                WHERE product_id = 413553
                ORDER BY price ASC LIMIT 1
523 0.0003 0.00027799606323242
SELECT value FROM productattributes
                WHERE product_id = '413553'
                AND name = 'ListPriceAmount'
524 0.0003 0.00025701522827148
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 = '413553'
                GROUP BY o.product_id
525 0.0003 0.00033092498779297
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     = '413553'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
526 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 = 413553
527 0.0004 0.00044393539428711
SELECT value FROM productattributes WHERE product_id = '413553' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
528 0.0003 0.00034999847412109
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '413553'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Size'
                GROUP BY o.value
                ORDER BY o.value ASC
529 0.0002 0.00022315979003906
SELECT * FROM products WHERE id = '408322'
530 0.0002 0.00024604797363281
SELECT * FROM productimages WHERE product_id = '408322' ORDER BY sortorder ASC
531 0.0002 0.00023198127746582
SELECT * FROM product_image_select WHERE product_id = '408322'
532 0.0001 0.00013399124145508
SELECT * FROM productcustomimages WHERE product_id = '408322'
533 0.0028 0.0027589797973633
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '408322' AND a.name = n.originalname
534 0.0002 0.00018811225891113
SELECT * FROM productoffers WHERE product_id = '408322' AND merchantid = 'ATVPDKIKX0DER'
535 0.0002 0.00019621849060059
SELECT * FROM productoffers
                WHERE product_id = '408322' AND price > 0
                ORDER BY price ASC LIMIT 1
536 0.0002 0.00018119812011719
SELECT * FROM productoffers
                WHERE product_id = 408322
                ORDER BY price ASC LIMIT 1
537 0.0003 0.00028109550476074
SELECT value FROM productattributes
                WHERE product_id = '408322'
                AND name = 'ListPriceAmount'
538 0.0001 0.00014400482177734
UPDATE products SET price = '3920' WHERE id = '408322'
539 0.0002 0.00021600723266602
SELECT * FROM products WHERE id = '407501'
540 0.0002 0.0001990795135498
SELECT * FROM productimages WHERE product_id = '407501' ORDER BY sortorder ASC
541 0.0002 0.00023484230041504
SELECT * FROM product_image_select WHERE product_id = '407501'
542 0.0001 0.00013494491577148
SELECT * FROM productcustomimages WHERE product_id = '407501'
543 0.0029 0.0029041767120361
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '407501' AND a.name = n.originalname
544 0.0002 0.00020003318786621
SELECT * FROM productoffers WHERE product_id = '407501' AND merchantid = 'ATVPDKIKX0DER'
545 0.0002 0.00022006034851074
SELECT * FROM productoffers
                WHERE product_id = '407501' AND price > 0
                ORDER BY price ASC LIMIT 1
546 0.0004 0.00040483474731445
SELECT value FROM productattributes WHERE product_id = '407501' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
547 0.0001 0.00013899803161621
UPDATE products SET price = '2999' WHERE id = '407501'
548 0.0002 0.00022101402282715
SELECT * FROM products WHERE id = '405008'
549 0.0003 0.00029087066650391
SELECT * FROM productimages WHERE product_id = '405008' ORDER BY sortorder ASC
550 0.0002 0.00022482872009277
SELECT * FROM product_image_select WHERE product_id = '405008'
551 0.0001 0.00013399124145508
SELECT * FROM productcustomimages WHERE product_id = '405008'
552 0.0024 0.0023868083953857
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '405008' AND a.name = n.originalname
553 0.0002 0.00020503997802734
SELECT * FROM productoffers WHERE product_id = '405008' AND merchantid = 'ATVPDKIKX0DER'
554 0.0002 0.00022101402282715
SELECT * FROM productoffers
                WHERE product_id = '405008' AND price > 0
                ORDER BY price ASC LIMIT 1
555 0.0004 0.00035500526428223
SELECT value FROM productattributes WHERE product_id = '405008' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
556 0.0001 0.00013494491577148
UPDATE products SET price = '17900' WHERE id = '405008'
557 0.0002 0.00022697448730469
SELECT * FROM products WHERE id = '407172'
558 0.0003 0.00025606155395508
SELECT * FROM productimages WHERE product_id = '407172' ORDER BY sortorder ASC
559 0.0002 0.00022101402282715
SELECT * FROM product_image_select WHERE product_id = '407172'
560 0.0001 0.00013399124145508
SELECT * FROM productcustomimages WHERE product_id = '407172'
561 0.0341 0.034052133560181
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '407172' AND a.name = n.originalname
562 0.0002 0.00023102760314941
SELECT * FROM productoffers WHERE product_id = '407172' AND merchantid = 'ATVPDKIKX0DER'
563 0.0002 0.00021195411682129
SELECT * FROM productoffers
                WHERE product_id = '407172' AND price > 0
                ORDER BY price ASC LIMIT 1
564 0.0002 0.00020790100097656
SELECT * FROM productoffers
                WHERE product_id = 407172
                ORDER BY price ASC LIMIT 1
565 0.0002 0.00023388862609863
SELECT value FROM productattributes
                WHERE product_id = '407172'
                AND name = 'ListPriceAmount'
566 0.0002 0.00015091896057129
UPDATE products SET price = '18568' WHERE id = '407172'
567 0.0002 0.00021100044250488
SELECT * FROM products WHERE id = '406764'
568 0.0003 0.00029802322387695
SELECT * FROM productimages WHERE product_id = '406764' ORDER BY sortorder ASC
569 0.0002 0.00022602081298828
SELECT * FROM product_image_select WHERE product_id = '406764'
570 0.0001 0.00013399124145508
SELECT * FROM productcustomimages WHERE product_id = '406764'
571 0.0029 0.0029170513153076
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '406764' AND a.name = n.originalname
572 0.0002 0.00018596649169922
SELECT * FROM productoffers WHERE product_id = '406764' AND merchantid = 'ATVPDKIKX0DER'
573 0.0002 0.00020313262939453
SELECT * FROM productoffers
                WHERE product_id = '406764' AND price > 0
                ORDER BY price ASC LIMIT 1
574 0.0002 0.00017690658569336
SELECT * FROM productoffers
                WHERE product_id = 406764
                ORDER BY price ASC LIMIT 1
575 0.0002 0.00021815299987793
SELECT value FROM productattributes
                WHERE product_id = '406764'
                AND name = 'ListPriceAmount'
576 0.0001 0.00013303756713867
UPDATE products SET price = '12995' WHERE id = '406764'
577 0.0002 0.00021100044250488
SELECT * FROM products WHERE id = '407878'
578 0.0002 0.00022315979003906
SELECT * FROM productimages WHERE product_id = '407878' ORDER BY sortorder ASC
579 0.0004 0.00040721893310547
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '407878' AND p.id = pi.product_id ORDER BY pi.sortorder
580 0.0002 0.00022387504577637
SELECT * FROM product_image_select WHERE product_id = '407878'
581 0.0001 0.00013303756713867
SELECT * FROM productcustomimages WHERE product_id = '407878'
582 0.0003 0.0003199577331543
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 = '407878'
                GROUP BY o.product_id
583 0.0005 0.00045299530029297
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     = '407878'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
584 0.0003 0.0002748966217041
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 407878
585 0.0024 0.0024259090423584
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '407878' AND a.name = n.originalname
586 0.0002 0.00018095970153809
SELECT * FROM productoffers WHERE product_id = '407878' AND merchantid = 'ATVPDKIKX0DER'
587 0.0002 0.0001981258392334
SELECT * FROM productoffers
                WHERE product_id = '407878' AND price > 0
                ORDER BY price ASC LIMIT 1
588 0.0002 0.00018882751464844
SELECT * FROM productoffers
                WHERE product_id = 407878
                ORDER BY price ASC LIMIT 1
589 0.0003 0.00026297569274902
SELECT value FROM productattributes
                WHERE product_id = '407878'
                AND name = 'ListPriceAmount'
590 0.0003 0.00030303001403809
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 = '407878'
                GROUP BY o.product_id
591 0.0004 0.00044894218444824
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     = '407878'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
592 0.0003 0.00026297569274902
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 407878
593 0.0004 0.00039196014404297
SELECT value FROM productattributes WHERE product_id = '407878' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
594 0.0001 0.00014710426330566
UPDATE products SET price = '6151' WHERE id = '407878'
595 0.0004 0.00038814544677734
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '407878'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Size'
                GROUP BY o.value
                ORDER BY o.value ASC
596 0.0004 0.00038790702819824
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '407878'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Color'
                GROUP BY o.value
                ORDER BY o.value ASC
597 0.0002 0.0002288818359375
SELECT * FROM products WHERE id = '406859'
598 0.0002 0.00023889541625977
SELECT * FROM productimages WHERE product_id = '406859' ORDER BY sortorder ASC
599 0.0002 0.00022292137145996
SELECT * FROM product_image_select WHERE product_id = '406859'
600 0.0001 0.00013494491577148
SELECT * FROM productcustomimages WHERE product_id = '406859'
601 0.0023 0.0023388862609863
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '406859' AND a.name = n.originalname
602 0.0002 0.00019502639770508
SELECT * FROM productoffers WHERE product_id = '406859' AND merchantid = 'ATVPDKIKX0DER'
603 0.0002 0.00021815299987793
SELECT * FROM productoffers
                WHERE product_id = '406859' AND price > 0
                ORDER BY price ASC LIMIT 1
604 0.0004 0.00037598609924316
SELECT value FROM productattributes WHERE product_id = '406859' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
605 0.0001 0.00013399124145508
UPDATE products SET price = '9657' WHERE id = '406859'
606 0.0002 0.00021195411682129
SELECT * FROM products WHERE id = '411907'
607 0.0002 0.00018477439880371
SELECT * FROM productimages WHERE product_id = '411907' ORDER BY sortorder ASC
608 0.0002 0.00023007392883301
SELECT * FROM product_image_select WHERE product_id = '411907'
609 0.0001 0.00013494491577148
SELECT * FROM productcustomimages WHERE product_id = '411907'
610 0.0019 0.0019149780273438
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '411907' AND a.name = n.originalname
611 0.0002 0.00019717216491699
SELECT * FROM productoffers WHERE product_id = '411907' AND merchantid = 'ATVPDKIKX0DER'
612 0.0002 0.00022101402282715
SELECT * FROM productoffers
                WHERE product_id = '411907' AND price > 0
                ORDER BY price ASC LIMIT 1
613 0.0004 0.00037217140197754
SELECT value FROM productattributes WHERE product_id = '411907' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
614 0.0001 0.00013589859008789
UPDATE products SET price = '2687' WHERE id = '411907'
615 0.0002 0.00020909309387207
SELECT * FROM products WHERE id = '409003'
616 0.0002 0.00024104118347168
SELECT * FROM productimages WHERE product_id = '409003' ORDER BY sortorder ASC
617 0.0002 0.00022721290588379
SELECT * FROM product_image_select WHERE product_id = '409003'
618 0.0001 0.00014495849609375
SELECT * FROM productcustomimages WHERE product_id = '409003'
619 0.0031 0.0031321048736572
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '409003' AND a.name = n.originalname
620 0.0002 0.00018787384033203
SELECT * FROM productoffers WHERE product_id = '409003' AND merchantid = 'ATVPDKIKX0DER'
621 0.0002 0.00019502639770508
SELECT * FROM productoffers
                WHERE product_id = '409003' AND price > 0
                ORDER BY price ASC LIMIT 1
622 0.0002 0.00018501281738281
SELECT * FROM productoffers
                WHERE product_id = 409003
                ORDER BY price ASC LIMIT 1
623 0.0003 0.00025200843811035
SELECT value FROM productattributes
                WHERE product_id = '409003'
                AND name = 'ListPriceAmount'
624 0.0001 0.00013399124145508
UPDATE products SET price = '24999' WHERE id = '409003'
625 0.0002 0.00022006034851074
SELECT * FROM products WHERE id = '400814'
626 0.0003 0.00029683113098145
SELECT * FROM productimages WHERE product_id = '400814' ORDER BY sortorder ASC
627 0.0002 0.00023794174194336
SELECT * FROM product_image_select WHERE product_id = '400814'
628 0.0001 0.00013303756713867
SELECT * FROM productcustomimages WHERE product_id = '400814'
629 0.0024 0.0024271011352539
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '400814' AND a.name = n.originalname
630 0.0002 0.00020408630371094
SELECT * FROM productoffers WHERE product_id = '400814' AND merchantid = 'ATVPDKIKX0DER'
631 0.0002 0.00021815299987793
SELECT * FROM productoffers
                WHERE product_id = '400814' AND price > 0
                ORDER BY price ASC LIMIT 1
632 0.0004 0.00039291381835938
SELECT value FROM productattributes WHERE product_id = '400814' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
633 0.0001 0.00013518333435059
UPDATE products SET price = '21849' WHERE id = '400814'
634 0.0003 0.00034689903259277
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '407894' ORDER BY timestamp DESC
635 0.0003 0.00028896331787109
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '410606' ORDER BY timestamp DESC
636 0.0003 0.00028204917907715
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '410614' ORDER BY timestamp DESC
637 0.0003 0.00028896331787109
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '407875' ORDER BY timestamp DESC
638 0.0003 0.00028085708618164
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '410601' ORDER BY timestamp DESC
639 0.0003 0.00028109550476074
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '410613' ORDER BY timestamp DESC
640 0.0003 0.00028896331787109
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '410619' ORDER BY timestamp DESC
641 0.0003 0.00027704238891602
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '413553' ORDER BY timestamp DESC
642 0.0003 0.00027608871459961
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '408322' ORDER BY timestamp DESC
643 0.0003 0.00029993057250977
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '407501' ORDER BY timestamp DESC
644 0.0003 0.00028610229492188
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '405008' ORDER BY timestamp DESC
645 0.0003 0.00027608871459961
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '407172' ORDER BY timestamp DESC
646 0.0003 0.00027990341186523
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '406764' ORDER BY timestamp DESC
647 0.0003 0.00028896331787109
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '407878' ORDER BY timestamp DESC
648 0.0003 0.00027608871459961
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '406859' ORDER BY timestamp DESC
649 0.0003 0.00027608871459961
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '411907' ORDER BY timestamp DESC
650 0.0003 0.0002899169921875
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '409003' ORDER BY timestamp DESC
651 0.0003 0.00027990341186523
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '400814' ORDER BY timestamp DESC
652 0.0002 0.00019001960754395
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 = 92
		AND c.prod_type = 'ebay'
		AND hide = 1
653 0.0002 0.00015091896057129
SELECT value FROM parameters WHERE parameter = 'EBAY_APP_ID' 
654 0.0001 0.00014400482177734
SELECT value FROM parameters WHERE parameter = 'EBAY_TRACKING_ID' 
655 0.0001 0.00013494491577148
SELECT value FROM parameters WHERE parameter = 'EBAY_NETWORK_ID' 
656 0.0001 0.00013303756713867
SELECT value FROM parameters WHERE parameter = 'EBAY_LOCALE' 
657 0.0001 0.00013208389282227
SELECT value FROM parameters WHERE parameter = 'EBAY_AUTH_TOKEN' 
658 0.0002 0.00015020370483398
SELECT * FROM ebay_locale_details WHERE cur_code = 'USD' 
659 0.0002 0.0001990795135498
SELECT * FROM template_info WHERE templateuid = 'fsb-fluid'
660 0.0002 0.00019001960754395
SELECT * FROM pages WHERE id = 2
661 0.0002 0.00016880035400391
SELECT * FROM pages WHERE id = 4
662 0.0002 0.0001528263092041
SELECT * FROM pages WHERE id = 12
663 0.0002 0.00015592575073242
SELECT * FROM pages WHERE id = 10
664 0.0002 0.0001528263092041
SELECT * FROM pages WHERE id = 7
665 0.0002 0.00015377998352051
SELECT * FROM pages WHERE id = 18
666 0.0002 0.0001518726348877
SELECT * FROM pages WHERE id = 28
667 0.0002 0.0001678466796875
SELECT * FROM pages WHERE id = 13
668 0.0002 0.0001518726348877
SELECT * FROM pages WHERE id = 3
669 0.0438 0.043766021728516
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
670 0.0003 0.00028204917907715
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:1563783503;s:8:\"products\";a:6:{i:2;s:6:\"398858\";i:5;s:6:\"170197\";i:16;s:6:\"414321\";i:3;s:6:\"407595\";i:9;s:6:\"410950\";i:10;s:6:\"409759\";}}' WHERE id = '175'
671 0.0005 0.00051307678222656
SELECT * FROM products WHERE id IN (398858,170197,414321,407595,410950,409759) ORDER BY FIELD(id, 398858,170197,414321,407595,410950,409759 )
672 0.0002 0.00023293495178223
SELECT * FROM productimages WHERE product_id = '398858' ORDER BY sortorder ASC
673 0.0002 0.00023412704467773
SELECT * FROM product_image_select WHERE product_id = '398858'
674 0.0001 0.00013899803161621
SELECT * FROM productcustomimages WHERE product_id = '398858'
675 0.0031 0.0030930042266846
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '398858' AND a.name = n.originalname
676 0.0002 0.00020194053649902
SELECT * FROM productoffers WHERE product_id = '398858' AND merchantid = 'ATVPDKIKX0DER'
677 0.0002 0.00023198127746582
SELECT * FROM productoffers
                WHERE product_id = '398858' AND price > 0
                ORDER BY price ASC LIMIT 1
678 0.0004 0.00043296813964844
SELECT value FROM productattributes WHERE product_id = '398858' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
679 0.0001 0.00014615058898926
UPDATE products SET price = '2999' WHERE id = '398858'
680 0.0007 0.0006868839263916
SELECT * FROM productimages WHERE product_id = '170197' ORDER BY sortorder ASC
681 0.0002 0.00023698806762695
SELECT * FROM product_image_select WHERE product_id = '170197'
682 0.0001 0.00013613700866699
SELECT * FROM productcustomimages WHERE product_id = '170197'
683 0.0036 0.0036001205444336
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '170197' AND a.name = n.originalname
684 0.0003 0.00027108192443848
SELECT * FROM productoffers WHERE product_id = '170197' AND merchantid = 'ATVPDKIKX0DER'
685 0.0002 0.00023198127746582
SELECT * FROM productoffers
                WHERE product_id = '170197' AND price > 0
                ORDER BY price ASC LIMIT 1
686 0.0005 0.00054192543029785
SELECT value FROM productattributes WHERE product_id = '170197' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
687 0.0002 0.00015711784362793
UPDATE products SET price = '324500' WHERE id = '170197'
688 0.0003 0.00026297569274902
SELECT * FROM productimages WHERE product_id = '414321' ORDER BY sortorder ASC
689 0.0003 0.00026607513427734
SELECT * FROM product_image_select WHERE product_id = '414321'
690 0.0001 0.00014114379882812
SELECT * FROM productcustomimages WHERE product_id = '414321'
691 0.0033 0.0032830238342285
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '414321' AND a.name = n.originalname
692 0.0003 0.0002591609954834
SELECT * FROM productoffers WHERE product_id = '414321' AND merchantid = 'ATVPDKIKX0DER'
693 0.0002 0.00024795532226562
SELECT * FROM productoffers
                WHERE product_id = '414321' AND price > 0
                ORDER BY price ASC LIMIT 1
694 0.0005 0.00047993659973145
SELECT value FROM productattributes WHERE product_id = '414321' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
695 0.0001 0.00014495849609375
UPDATE products SET price = '9999' WHERE id = '414321'
696 0.0003 0.00027608871459961
SELECT * FROM productimages WHERE product_id = '407595' ORDER BY sortorder ASC
697 0.0003 0.00025701522827148
SELECT * FROM product_image_select WHERE product_id = '407595'
698 0.0001 0.0001380443572998
SELECT * FROM productcustomimages WHERE product_id = '407595'
699 0.0045 0.0044741630554199
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '407595' AND a.name = n.originalname
700 0.0003 0.00028395652770996
SELECT * FROM productoffers WHERE product_id = '407595' AND merchantid = 'ATVPDKIKX0DER'
701 0.0003 0.0002589225769043
SELECT * FROM productoffers
                WHERE product_id = '407595' AND price > 0
                ORDER BY price ASC LIMIT 1
702 0.0006 0.0006108283996582
SELECT value FROM productattributes WHERE product_id = '407595' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
703 0.0002 0.00018310546875
UPDATE products SET price = '2497' WHERE id = '407595'
704 0.0003 0.00032615661621094
SELECT * FROM productimages WHERE product_id = '410950' ORDER BY sortorder ASC
705 0.0003 0.00026702880859375
SELECT * FROM product_image_select WHERE product_id = '410950'
706 0.0001 0.00014901161193848
SELECT * FROM productcustomimages WHERE product_id = '410950'
707 0.0041 0.0040628910064697
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '410950' AND a.name = n.originalname
708 0.0003 0.00025582313537598
SELECT * FROM productoffers WHERE product_id = '410950' AND merchantid = 'ATVPDKIKX0DER'
709 0.0003 0.00027012825012207
SELECT * FROM productoffers
                WHERE product_id = '410950' AND price > 0
                ORDER BY price ASC LIMIT 1
710 0.0005 0.00054788589477539
SELECT value FROM productattributes WHERE product_id = '410950' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
711 0.0002 0.00015091896057129
UPDATE products SET price = '241603' WHERE id = '410950'
712 0.0003 0.00026798248291016
SELECT * FROM productimages WHERE product_id = '409759' ORDER BY sortorder ASC
713 0.0003 0.00026202201843262
SELECT * FROM product_image_select WHERE product_id = '409759'
714 0.0001 0.00014591217041016
SELECT * FROM productcustomimages WHERE product_id = '409759'
715 0.0037 0.0037269592285156
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '409759' AND a.name = n.originalname
716 0.0002 0.00021910667419434
SELECT * FROM productoffers WHERE product_id = '409759' AND merchantid = 'ATVPDKIKX0DER'
717 0.0002 0.00024318695068359
SELECT * FROM productoffers
                WHERE product_id = '409759' AND price > 0
                ORDER BY price ASC LIMIT 1
718 0.0005 0.00053215026855469
SELECT value FROM productattributes WHERE product_id = '409759' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
719 0.0002 0.0001680850982666
UPDATE products SET price = '229000' WHERE id = '409759'
720 0.0435 0.043461084365845
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
721 0.0002 0.00024104118347168
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:1563783503;s:8:\"products\";a:6:{i:2;s:6:\"398858\";i:16;s:6:\"414321\";i:18;s:6:\"415052\";i:19;s:6:\"406758\";i:0;s:6:\"414940\";i:6;s:6:\"185812\";}}' WHERE id = '177'
722 0.0005 0.00046992301940918
SELECT * FROM products WHERE id IN (398858,414321,415052,406758,414940,185812) ORDER BY FIELD(id, 398858,414321,415052,406758,414940,185812 )
723 0.0002 0.00020289421081543
SELECT * FROM productimages WHERE product_id = '398858' ORDER BY sortorder ASC
724 0.0002 0.00020694732666016
SELECT * FROM product_image_select WHERE product_id = '398858'
725 0.0001 0.00012111663818359
SELECT * FROM productcustomimages WHERE product_id = '398858'
726 0.0031 0.00307297706604
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '398858' AND a.name = n.originalname
727 0.0002 0.00018692016601562
SELECT * FROM productoffers WHERE product_id = '398858' AND merchantid = 'ATVPDKIKX0DER'
728 0.0002 0.0002131462097168
SELECT * FROM productoffers
                WHERE product_id = '398858' AND price > 0
                ORDER BY price ASC LIMIT 1
729 0.0004 0.00040888786315918
SELECT value FROM productattributes WHERE product_id = '398858' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
730 0.0001 0.00011801719665527
UPDATE products SET price = '2999' WHERE id = '398858'
731 0.0002 0.0002288818359375
SELECT * FROM productimages WHERE product_id = '414321' ORDER BY sortorder ASC
732 0.0002 0.00020503997802734
SELECT * FROM product_image_select WHERE product_id = '414321'
733 0.0001 0.00011801719665527
SELECT * FROM productcustomimages WHERE product_id = '414321'
734 0.0025 0.0025300979614258
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '414321' AND a.name = n.originalname
735 0.0002 0.00018191337585449
SELECT * FROM productoffers WHERE product_id = '414321' AND merchantid = 'ATVPDKIKX0DER'
736 0.0002 0.00019502639770508
SELECT * FROM productoffers
                WHERE product_id = '414321' AND price > 0
                ORDER BY price ASC LIMIT 1
737 0.0004 0.00037193298339844
SELECT value FROM productattributes WHERE product_id = '414321' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
738 0.0001 0.00011491775512695
UPDATE products SET price = '9999' WHERE id = '414321'
739 0.0002 0.0001990795135498
SELECT * FROM productimages WHERE product_id = '415052' ORDER BY sortorder ASC
740 0.0002 0.00020694732666016
SELECT * FROM product_image_select WHERE product_id = '415052'
741 0.0001 0.00011897087097168
SELECT * FROM productcustomimages WHERE product_id = '415052'
742 0.0026 0.0026240348815918
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '415052' AND a.name = n.originalname
743 0.0002 0.00018000602722168
SELECT * FROM productoffers WHERE product_id = '415052' AND merchantid = 'ATVPDKIKX0DER'
744 0.0002 0.00019216537475586
SELECT * FROM productoffers
                WHERE product_id = '415052' AND price > 0
                ORDER BY price ASC LIMIT 1
745 0.0004 0.00037193298339844
SELECT value FROM productattributes WHERE product_id = '415052' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
746 0.0001 0.00012803077697754
UPDATE products SET price = '6999' WHERE id = '415052'
747 0.0002 0.0001838207244873
SELECT * FROM productimages WHERE product_id = '406758' ORDER BY sortorder ASC
748 0.0002 0.00020503997802734
SELECT * FROM product_image_select WHERE product_id = '406758'
749 0.0001 0.00011801719665527
SELECT * FROM productcustomimages WHERE product_id = '406758'
750 0.0026 0.0026459693908691
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '406758' AND a.name = n.originalname
751 0.0002 0.00018501281738281
SELECT * FROM productoffers WHERE product_id = '406758' AND merchantid = 'ATVPDKIKX0DER'
752 0.0002 0.0001978874206543
SELECT * FROM productoffers
                WHERE product_id = '406758' AND price > 0
                ORDER BY price ASC LIMIT 1
753 0.0004 0.00039100646972656
SELECT value FROM productattributes WHERE product_id = '406758' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
754 0.0001 0.00011682510375977
UPDATE products SET price = '2695' WHERE id = '406758'
755 0.0002 0.00017189979553223
SELECT * FROM productimages WHERE product_id = '414940' ORDER BY sortorder ASC
756 0.0002 0.00020599365234375
SELECT * FROM product_image_select WHERE product_id = '414940'
757 0.0001 0.00011992454528809
SELECT * FROM productcustomimages WHERE product_id = '414940'
758 0.0033 0.0033178329467773
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '414940' AND a.name = n.originalname
759 0.0002 0.00017905235290527
SELECT * FROM productoffers WHERE product_id = '414940' AND merchantid = 'ATVPDKIKX0DER'
760 0.0002 0.00019407272338867
SELECT * FROM productoffers
                WHERE product_id = '414940' AND price > 0
                ORDER BY price ASC LIMIT 1
761 0.0004 0.00043892860412598
SELECT value FROM productattributes WHERE product_id = '414940' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
762 0.0001 0.00011587142944336
UPDATE products SET price = '4490' WHERE id = '414940'
763 0.0007 0.00067019462585449
SELECT * FROM productimages WHERE product_id = '185812' ORDER BY sortorder ASC
764 0.0002 0.00021886825561523
SELECT * FROM product_image_select WHERE product_id = '185812'
765 0.0001 0.00011801719665527
SELECT * FROM productcustomimages WHERE product_id = '185812'
766 0.0021 0.0020840167999268
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '185812' AND a.name = n.originalname
767 0.0002 0.00019407272338867
SELECT * FROM productoffers WHERE product_id = '185812' AND merchantid = 'ATVPDKIKX0DER'
768 0.0002 0.00020289421081543
SELECT * FROM productoffers
                WHERE product_id = '185812' AND price > 0
                ORDER BY price ASC LIMIT 1
769 0.0004 0.00035309791564941
SELECT value FROM productattributes WHERE product_id = '185812' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
770 0.0001 0.00011706352233887
UPDATE products SET price = '314900' WHERE id = '185812'
771 0.1089 0.10889291763306
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
772 0.0003 0.00026702880859375
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:1563783503;s:8:\"products\";a:6:{i:4;s:6:\"415083\";i:9;s:6:\"410950\";i:10;s:6:\"409759\";i:16;s:6:\"414321\";i:19;s:6:\"406758\";i:23;s:6:\"408078\";}}' WHERE id = '181'
773 0.0007 0.00073099136352539
SELECT * FROM products WHERE id IN (415083,410950,409759,414321,406758,408078) ORDER BY FIELD(id, 415083,410950,409759,414321,406758,408078 )
774 0.0002 0.00020194053649902
SELECT * FROM productimages WHERE product_id = '415083' ORDER BY sortorder ASC
775 0.0002 0.00021100044250488
SELECT * FROM product_image_select WHERE product_id = '415083'
776 0.0001 0.00012302398681641
SELECT * FROM productcustomimages WHERE product_id = '415083'
777 0.0035 0.0035300254821777
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '415083' AND a.name = n.originalname
778 0.0002 0.00018501281738281
SELECT * FROM productoffers WHERE product_id = '415083' AND merchantid = 'ATVPDKIKX0DER'
779 0.0002 0.00020694732666016
SELECT * FROM productoffers
                WHERE product_id = '415083' AND price > 0
                ORDER BY price ASC LIMIT 1
780 0.0004 0.00044393539428711
SELECT value FROM productattributes WHERE product_id = '415083' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
781 0.0002 0.00024700164794922
UPDATE products SET price = '2299' WHERE id = '415083'
782 0.0003 0.00025486946105957
SELECT * FROM productimages WHERE product_id = '410950' ORDER BY sortorder ASC
783 0.0002 0.00020003318786621
SELECT * FROM product_image_select WHERE product_id = '410950'
784 0.0001 0.00011897087097168
SELECT * FROM productcustomimages WHERE product_id = '410950'
785 0.0031 0.0031259059906006
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '410950' AND a.name = n.originalname
786 0.0002 0.00018095970153809
SELECT * FROM productoffers WHERE product_id = '410950' AND merchantid = 'ATVPDKIKX0DER'
787 0.0002 0.00019407272338867
SELECT * FROM productoffers
                WHERE product_id = '410950' AND price > 0
                ORDER BY price ASC LIMIT 1
788 0.0004 0.0004119873046875
SELECT value FROM productattributes WHERE product_id = '410950' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
789 0.0001 0.00011801719665527
UPDATE products SET price = '241603' WHERE id = '410950'
790 0.0002 0.00020194053649902
SELECT * FROM productimages WHERE product_id = '409759' ORDER BY sortorder ASC
791 0.0002 0.00020408630371094
SELECT * FROM product_image_select WHERE product_id = '409759'
792 0.0001 0.00011777877807617
SELECT * FROM productcustomimages WHERE product_id = '409759'
793 0.0028 0.0028269290924072
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '409759' AND a.name = n.originalname
794 0.0002 0.0001828670501709
SELECT * FROM productoffers WHERE product_id = '409759' AND merchantid = 'ATVPDKIKX0DER'
795 0.0002 0.00021100044250488
SELECT * FROM productoffers
                WHERE product_id = '409759' AND price > 0
                ORDER BY price ASC LIMIT 1
796 0.0004 0.0003960132598877
SELECT value FROM productattributes WHERE product_id = '409759' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
797 0.0001 0.00011801719665527
UPDATE products SET price = '229000' WHERE id = '409759'
798 0.0002 0.00021100044250488
SELECT * FROM productimages WHERE product_id = '414321' ORDER BY sortorder ASC
799 0.0002 0.00021600723266602
SELECT * FROM product_image_select WHERE product_id = '414321'
800 0.0001 0.00011897087097168
SELECT * FROM productcustomimages WHERE product_id = '414321'
801 0.0025 0.002547025680542
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '414321' AND a.name = n.originalname
802 0.0002 0.00019001960754395
SELECT * FROM productoffers WHERE product_id = '414321' AND merchantid = 'ATVPDKIKX0DER'
803 0.0002 0.00019717216491699
SELECT * FROM productoffers
                WHERE product_id = '414321' AND price > 0
                ORDER BY price ASC LIMIT 1
804 0.0004 0.00037503242492676
SELECT value FROM productattributes WHERE product_id = '414321' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
805 0.0001 0.00011491775512695
UPDATE products SET price = '9999' WHERE id = '414321'
806 0.0002 0.00018095970153809
SELECT * FROM productimages WHERE product_id = '406758' ORDER BY sortorder ASC
807 0.0002 0.00021600723266602
SELECT * FROM product_image_select WHERE product_id = '406758'
808 0.0001 0.00011801719665527
SELECT * FROM productcustomimages WHERE product_id = '406758'
809 0.0027 0.002655029296875
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '406758' AND a.name = n.originalname
810 0.0002 0.00018501281738281
SELECT * FROM productoffers WHERE product_id = '406758' AND merchantid = 'ATVPDKIKX0DER'
811 0.0002 0.00020098686218262
SELECT * FROM productoffers
                WHERE product_id = '406758' AND price > 0
                ORDER BY price ASC LIMIT 1
812 0.0004 0.00038003921508789
SELECT value FROM productattributes WHERE product_id = '406758' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
813 0.0001 0.00012898445129395
UPDATE products SET price = '2695' WHERE id = '406758'
814 0.0002 0.00020003318786621
SELECT * FROM productimages WHERE product_id = '408078' ORDER BY sortorder ASC
815 0.0002 0.00020503997802734
SELECT * FROM product_image_select WHERE product_id = '408078'
816 0.0001 0.00011706352233887
SELECT * FROM productcustomimages WHERE product_id = '408078'
817 0.0024 0.0024240016937256
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '408078' AND a.name = n.originalname
818 0.0002 0.00018405914306641
SELECT * FROM productoffers WHERE product_id = '408078' AND merchantid = 'ATVPDKIKX0DER'
819 0.0002 0.00020194053649902
SELECT * FROM productoffers
                WHERE product_id = '408078' AND price > 0
                ORDER BY price ASC LIMIT 1
820 0.0003 0.00032901763916016
SELECT value FROM productattributes WHERE product_id = '408078' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
821 0.0002 0.00015115737915039
UPDATE products SET price = '22933' WHERE id = '408078'
822 0.1100 0.11004996299744
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
823 0.0003 0.00030899047851562
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:1563783503;s:8:\"products\";a:6:{i:0;s:6:\"414940\";i:1;s:6:\"398315\";i:5;s:6:\"170197\";i:8;s:6:\"404554\";i:9;s:6:\"410950\";i:13;s:6:\"370121\";}}' WHERE id = '183'
824 0.0005 0.0004889965057373
SELECT * FROM products WHERE id IN (414940,398315,170197,404554,410950,370121) ORDER BY FIELD(id, 414940,398315,170197,404554,410950,370121 )
825 0.0002 0.00019288063049316
SELECT * FROM productimages WHERE product_id = '414940' ORDER BY sortorder ASC
826 0.0002 0.00020503997802734
SELECT * FROM product_image_select WHERE product_id = '414940'
827 0.0001 0.00012397766113281
SELECT * FROM productcustomimages WHERE product_id = '414940'
828 0.0033 0.0033278465270996
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '414940' AND a.name = n.originalname
829 0.0002 0.00019598007202148
SELECT * FROM productoffers WHERE product_id = '414940' AND merchantid = 'ATVPDKIKX0DER'
830 0.0002 0.00020503997802734
SELECT * FROM productoffers
                WHERE product_id = '414940' AND price > 0
                ORDER BY price ASC LIMIT 1
831 0.0005 0.00046396255493164
SELECT value FROM productattributes WHERE product_id = '414940' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
832 0.0001 0.00012111663818359
UPDATE products SET price = '4490' WHERE id = '414940'
833 0.0002 0.00020313262939453
SELECT * FROM productimages WHERE product_id = '398315' ORDER BY sortorder ASC
834 0.0002 0.0002138614654541
SELECT * FROM product_image_select WHERE product_id = '398315'
835 0.0001 0.00012087821960449
SELECT * FROM productcustomimages WHERE product_id = '398315'
836 0.0026 0.002561092376709
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '398315' AND a.name = n.originalname
837 0.0002 0.0001978874206543
SELECT * FROM productoffers WHERE product_id = '398315' AND merchantid = 'ATVPDKIKX0DER'
838 0.0002 0.0001990795135498
SELECT * FROM productoffers
                WHERE product_id = '398315' AND price > 0
                ORDER BY price ASC LIMIT 1
839 0.0004 0.00040006637573242
SELECT value FROM productattributes WHERE product_id = '398315' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
840 0.0001 0.0001218318939209
UPDATE products SET price = '1999' WHERE id = '398315'
841 0.0007 0.00069189071655273
SELECT * FROM productimages WHERE product_id = '170197' ORDER BY sortorder ASC
842 0.0002 0.00022101402282715
SELECT * FROM product_image_select WHERE product_id = '170197'
843 0.0001 0.0001220703125
SELECT * FROM productcustomimages WHERE product_id = '170197'
844 0.0033 0.003309965133667
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '170197' AND a.name = n.originalname
845 0.0002 0.00019407272338867
SELECT * FROM productoffers WHERE product_id = '170197' AND merchantid = 'ATVPDKIKX0DER'
846 0.0002 0.0001990795135498
SELECT * FROM productoffers
                WHERE product_id = '170197' AND price > 0
                ORDER BY price ASC LIMIT 1
847 0.0004 0.00042891502380371
SELECT value FROM productattributes WHERE product_id = '170197' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
848 0.0001 0.00012397766113281
UPDATE products SET price = '324500' WHERE id = '170197'
849 0.0003 0.00028705596923828
SELECT * FROM productimages WHERE product_id = '404554' ORDER BY sortorder ASC
850 0.0002 0.00021600723266602
SELECT * FROM product_image_select WHERE product_id = '404554'
851 0.0001 0.00013113021850586
SELECT * FROM productcustomimages WHERE product_id = '404554'
852 0.0034 0.0034091472625732
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '404554' AND a.name = n.originalname
853 0.0002 0.00019192695617676
SELECT * FROM productoffers WHERE product_id = '404554' AND merchantid = 'ATVPDKIKX0DER'
854 0.0002 0.0001981258392334
SELECT * FROM productoffers
                WHERE product_id = '404554' AND price > 0
                ORDER BY price ASC LIMIT 1
855 0.0004 0.00044894218444824
SELECT value FROM productattributes WHERE product_id = '404554' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
856 0.0001 0.00011920928955078
UPDATE products SET price = '375926' WHERE id = '404554'
857 0.0003 0.00025200843811035
SELECT * FROM productimages WHERE product_id = '410950' ORDER BY sortorder ASC
858 0.0002 0.00021815299987793
SELECT * FROM product_image_select WHERE product_id = '410950'
859 0.0001 0.00012302398681641
SELECT * FROM productcustomimages WHERE product_id = '410950'
860 0.0031 0.0031039714813232
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '410950' AND a.name = n.originalname
861 0.0002 0.00018906593322754
SELECT * FROM productoffers WHERE product_id = '410950' AND merchantid = 'ATVPDKIKX0DER'
862 0.0002 0.00019693374633789
SELECT * FROM productoffers
                WHERE product_id = '410950' AND price > 0
                ORDER BY price ASC LIMIT 1
863 0.0004 0.00042200088500977
SELECT value FROM productattributes WHERE product_id = '410950' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
864 0.0001 0.00012016296386719
UPDATE products SET price = '241603' WHERE id = '410950'
865 0.0002 0.00019097328186035
SELECT * FROM productimages WHERE product_id = '370121' ORDER BY sortorder ASC
866 0.0002 0.00020790100097656
SELECT * FROM product_image_select WHERE product_id = '370121'
867 0.0001 0.00012993812561035
SELECT * FROM productcustomimages WHERE product_id = '370121'
868 0.0028 0.0028011798858643
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '370121' AND a.name = n.originalname
869 0.0002 0.00020098686218262
SELECT * FROM productoffers WHERE product_id = '370121' AND merchantid = 'ATVPDKIKX0DER'
870 0.0002 0.00020408630371094
SELECT * FROM productoffers
                WHERE product_id = '370121' AND price > 0
                ORDER BY price ASC LIMIT 1
871 0.0004 0.00038909912109375
SELECT value FROM productattributes WHERE product_id = '370121' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
872 0.0001 0.00011706352233887
UPDATE products SET price = '12979' WHERE id = '370121'
873 0.0004 0.00040388107299805
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid' AND area = 'header' ORDER BY sortorder ASC
874 0.0001 0.00013089179992676
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
875 0.0001 0.00012111663818359
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
876 0.0001 0.00011897087097168
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
877 0.0001 0.00011587142944336
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
878 0.0004 0.00039196014404297
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid' AND area = 'footer' ORDER BY sortorder ASC
879 0.0001 0.00012302398681641
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
880 0.0001 0.00012087821960449
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
881 0.0009 0.0009150505065918
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-fluid' AND skinuid = ''
882 0.0003 0.00031399726867676
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid'
883 0.0003 0.00030088424682617
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid'
884 0.0004 0.00038695335388184
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid' AND imageuid = 'FB_DEFAULT_SHARE_IMAGE'
885 0.0001 0.00014114379882812
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
886 0.0001 0.00011992454528809
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
887 0.0001 0.00013017654418945
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
888 0.0001 0.00011801719665527
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
889 0.0001 0.00011491775512695
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
890 0.0004 0.00036096572875977
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid' AND imageuid = 'HEAD_CUSTOM_BANNER'
891 0.0003 0.0003349781036377
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid' AND imageuid = 'HEAD_CUSTOM_BANNER'