Calzoncillos de ropa interior para personajes de niñas y niños de entre 18 meses y 8 años

Precio: Haga clic en el botón de precio
Los precios de los productos y la disponibilidad son correctos a fecha 2019-06-15 10:20:45 UTC, pero pueden cambiar. La información de disponibilidad y el precio correctos serán los que se mostrarán en http://www.amazon.es/ cuando finalice la compra.
CIERTO CONTENIDO QUE APARECE EN ESTE SITIO VIENE DE AMAZON SERVICES LLC. ESTE CONTENIDO SE PROPORCIONA 'TAL CUAL' Y ESTÁ SUJETO A CAMBIOS O ELIMINACIONES EN CUALQUIER MOMENTO.

Descripción del Fabricante

Conjunto de pantalones con calzoncillos de personajes para niños y niñas (paquete de 3 pares). Conjunto de calzoncillos oficiales con licencia. La sensación súper suave para una máxima comodidad y un estiramiento duradero brindan un ajuste ideal. Multicolor paquete de 3 pares. Diseñado para la comodidad durante todo el día. 100% algodón. Lavable en la lavadora. Paw Patrol, Minnie Mouse Mickey Mouse, Disney Frozen, Marvel Avengers, La Guerra de las Galaxias, Teletubbies, Doc Mc Stuffin, Sofia The FirstMc Stuffin, Sofia The First

Características del Producto

Conjunto de calzoncillos con licencia oficial Sensación súper suave para una máxima comodidad 100% algodón Stretch duradero brinda un ajuste ideal Diseñado para la comodidad de todo el día

Debug Overview

App Total Time DB Queries DB Query Total Time Amazon Requests
1.0262269973755 478 0.3234 0


No Amazon API Requests Made.


App Debug - Total Time 1.0262269973755 seconds

Number Time From Start Name Description
1 0.34931397438049 Initialise Initialise FSB Function
2 0.35046911239624 App Controller Start Start of the App controller (called before the controller of every page)
3 0.35177612304688 Start of getCategoryListByGroup Function Before first category groups query
4 0.35200309753418 After initial query Before first category groups query
5 0.3520040512085 Get Category List for Group Before the call to getCategoryList function
6 0.35200595855713 Start of GetCategoryList function Start of the function
7 0.35200905799866 Before getting categories Query to get specific category list
8 0.35219597816467 After getting categories Query to get specific category list
9 0.35219717025757 Before getting category custom Before call to function getCategoryCustom
10 0.35569715499878 After getting category custom After call to function getCategoryCustom
11 0.35569906234741 Before getting category custom Before call to function getCategoryCustom
12 0.38252115249634 After getting category custom After call to function getCategoryCustom
13 0.38252401351929 Before getting category custom Before call to function getCategoryCustom
14 0.39912796020508 After getting category custom After call to function getCategoryCustom
15 0.39913010597229 Before getting category custom Before call to function getCategoryCustom
16 0.40327501296997 After getting category custom After call to function getCategoryCustom
17 0.40327715873718 Before getting category custom Before call to function getCategoryCustom
18 0.43041896820068 After getting category custom After call to function getCategoryCustom
19 0.43042206764221 Before getting category custom Before call to function getCategoryCustom
20 0.43381905555725 After getting category custom After call to function getCategoryCustom
21 0.43382096290588 Before getting category custom Before call to function getCategoryCustom
22 0.43580412864685 After getting category custom After call to function getCategoryCustom
23 0.43580603599548 Before getting category custom Before call to function getCategoryCustom
24 0.4503071308136 After getting category custom After call to function getCategoryCustom
25 0.45030999183655 Before getting category custom Before call to function getCategoryCustom
26 0.47019004821777 After getting category custom After call to function getCategoryCustom
27 0.4701931476593 End of GetCategoryList function End of the function
28 0.47020316123962 Get Category List for Group Before the call to getCategoryList function
29 0.47020506858826 Start of GetCategoryList function Start of the function
30 0.47020816802979 Before getting categories Query to get specific category list
31 0.47035503387451 After getting categories Query to get specific category list
32 0.47035598754883 Before getting category custom Before call to function getCategoryCustom
33 0.47742605209351 After getting category custom After call to function getCategoryCustom
34 0.47742795944214 Before getting category custom Before call to function getCategoryCustom
35 0.4799530506134 After getting category custom After call to function getCategoryCustom
36 0.47995495796204 Before getting category custom Before call to function getCategoryCustom
37 0.48273801803589 After getting category custom After call to function getCategoryCustom
38 0.4827401638031 Before getting category custom Before call to function getCategoryCustom
39 0.485680103302 After getting category custom After call to function getCategoryCustom
40 0.48568105697632 Before getting category custom Before call to function getCategoryCustom
41 0.48982095718384 After getting category custom After call to function getCategoryCustom
42 0.48982214927673 Before getting category custom Before call to function getCategoryCustom
43 0.4930100440979 After getting category custom After call to function getCategoryCustom
44 0.49301099777222 Before getting category custom Before call to function getCategoryCustom
45 0.49542999267578 After getting category custom After call to function getCategoryCustom
46 0.4954309463501 Before getting category custom Before call to function getCategoryCustom
47 0.4993269443512 After getting category custom After call to function getCategoryCustom
48 0.49932813644409 Before getting category custom Before call to function getCategoryCustom
49 0.5015721321106 After getting category custom After call to function getCategoryCustom
50 0.50157403945923 Before getting category custom Before call to function getCategoryCustom
51 0.50416707992554 After getting category custom After call to function getCategoryCustom
52 0.50416803359985 Before getting category custom Before call to function getCategoryCustom
53 0.50676798820496 After getting category custom After call to function getCategoryCustom
54 0.50677013397217 Before getting category custom Before call to function getCategoryCustom
55 0.50905704498291 After getting category custom After call to function getCategoryCustom
56 0.50905799865723 Before getting category custom Before call to function getCategoryCustom
57 0.51180195808411 After getting category custom After call to function getCategoryCustom
58 0.511803150177 End of GetCategoryList function End of the function
59 0.51181197166443 End of getCategoryListByGroup Function Before return()
60 0.51262617111206 App Controller End End of the App controller (called before the controller of every page)
61 0.51268315315247 Product Start Start of the product info controller
62 0.5131311416626 Cache file not found Starting get product details
63 0.535315990448 Related products Start getting related products if enabled
64 0.53531694412231 Related Products Start Before the related products are found
65 0.53531694412231 Related Products Keywords Before the related product keywords are found
66 0.53532314300537 Create Keyword List Function Start of function
67 0.53561210632324 Create Keyword List Function After looping provided content - 300 keywords found
68 0.54479694366455 Create Keyword List Function After looping initial keyword list - 280 keywords remaining
69 0.54482698440552 Create Keyword List Function After reducing keyword list
70 0.54517507553101 Create Keyword List Function After selecting by scoring keywords
71 0.54517817497253 Create Keyword List Function After final loop of keywords
72 0.54518008232117 Related Products Keywords After the related product keywords are found
73 0.62246704101562 Related Products End After the related products are found
74 0.62516808509827 Start Remote Request http://svcs.ebay.com/services/search/FindingServic...
75 0.95246005058289 End Remote Request http://svcs.ebay.com/services/search/FindingServic...
76 1.0098330974579 Product End End of the product info controller (Product Info)
77 1.0100181102753 App_after Controller Start Start of the App_after controller (called after the controller of every page)
78 1.010066986084 Before Get Options Before the call to getOptions in the tpl class
79 1.0158960819244 After Get Options After the call to getOptions in the tpl class
80 1.0160291194916 App_after Controller End End of the App_after controller (called after the controller of every page)
81 1.0160350799561 Product Info: Before Smarty Fetch Before the product.tpl template is fetched
82 1.0195081233978 Product Info: After Smarty Fetch After the product.tpl template is fetched
83 1.0195109844208 Product Info: Before Template Display Before the template is displayed
84 1.0262091159821 Product Info: After Template Display After the template is displayed
85 1.026211977005 Finalizing debug Before the debug is output to the page.
86 1.0262260437012 End of App This is the end of the app logging, final timestamp


Query Debug - 478 Database Queries. Total time 0.3234 seconds

Number Time (Seconds) Time (Milliseconds) Query
1 0.0001 6.6995620727539E-5
SELECT value FROM parameters WHERE `parameter` = 'BAD_BOTS_ENABLER'
2 0.0005 0.0005180835723877
SHOW TABLES LIKE 'bad_bots'
3 0.0002 0.00017714500427246
SELECT value FROM parameters WHERE `parameter` = 'STORE_WHITELISTED_IPS'
4 0.0002 0.00015807151794434
SELECT * FROM `bad_bots`
5 0.0002 0.00018596649169922
SELECT parameter, value FROM parameters
6 0.0002 0.00023078918457031
SET time_zone = 'Europe/London'
7 0.0001 0.00014114379882812
SELECT * FROM autorun ORDER BY lastrun ASC
8 0.0001 9.3936920166016E-5
SELECT * FROM version ORDER BY installed DESC LIMIT 1
9 0.0003 0.00033807754516602
SELECT id FROM pages WHERE pagename = 'calzoncillos-de-ropa-interior-para-personajes-de-ninas-y-ninos-de' LIMIT 1
10 0.0006 0.0006110668182373
SELECT id FROM products WHERE pagename = 'calzoncillos-de-ropa-interior-para-personajes-de-ninas-y-ninos-de' AND hidden = 0 LIMIT 1
11 0.0005 0.00052785873413086
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-fluid'
12 0.0002 0.0002140998840332
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-fluid' AND language = 'es'
13 0.0002 0.00022697448730469
SELECT * FROM pages WHERE pagename = 'calzoncillos-de-ropa-interior-para-personajes-de-ninas-y-ninos-de'
14 0.0002 0.0002129077911377
SELECT * FROM categorygroups ORDER BY sortorder ASC
15 0.0002 0.00016403198242188
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '2'  AND hidden = 0 ORDER BY sortorder ASC
16 0.0004 0.00039196014404297
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 = 70
17 0.0016 0.0016369819641113
SELECT id FROM categories WHERE parent_id = '70'
18 0.0003 0.00031805038452148
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (70)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
19 0.0008 0.00078201293945312
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (70)
				  AND p.disabled = 0 
20 0.0001 7.8916549682617E-5
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (70)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
21 0.0001 7.4148178100586E-5
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '70'
22 0.0001 0.00010800361633301
SELECT * FROM categorygroups WHERE id = '2'
23 0.0118 0.01176905632019
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
24 0.0014 0.0013790130615234
SELECT id FROM categories WHERE parent_id = '66'
25 0.0120 0.011995077133179
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (66)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
26 0.0013 0.001317024230957
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (66)
				  AND p.disabled = 0 
27 0.0001 9.0122222900391E-5
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (66)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
28 0.0001 8.392333984375E-5
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '66'
29 0.0001 8.8930130004883E-5
SELECT * FROM categorygroups WHERE id = '2'
30 0.0067 0.0066649913787842
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 = 67
31 0.0014 0.0013818740844727
SELECT id FROM categories WHERE parent_id = '67'
32 0.0068 0.0067870616912842
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (67)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
33 0.0014 0.0014030933380127
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (67)
				  AND p.disabled = 0 
34 0.0001 9.1075897216797E-5
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (67)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
35 0.0001 8.2969665527344E-5
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '67'
36 0.0001 8.4877014160156E-5
SELECT * FROM categorygroups WHERE id = '2'
37 0.0010 0.0010290145874023
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 = 56
38 0.0009 0.00094389915466309
SELECT id FROM categories WHERE parent_id = '56'
39 0.0010 0.0010139942169189
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (56)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
40 0.0008 0.00082015991210938
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (56)
				  AND p.disabled = 0 
41 0.0001 8.7976455688477E-5
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (56)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
42 0.0001 8.702278137207E-5
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '56'
43 0.0001 8.7976455688477E-5
SELECT * FROM categorygroups WHERE id = '2'
44 0.0118 0.011849880218506
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 = 59
45 0.0012 0.0012388229370117
SELECT id FROM categories WHERE parent_id = '59'
46 0.0121 0.012065172195435
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (59)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
47 0.0015 0.0015439987182617
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (59)
				  AND p.disabled = 0 
48 0.0001 0.0001060962677002
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (59)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
49 0.0001 0.00010299682617188
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '59'
50 0.0001 0.00010395050048828
SELECT * FROM categorygroups WHERE id = '2'
51 0.0009 0.00086784362792969
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
52 0.0007 0.00070786476135254
SELECT id FROM categories WHERE parent_id = '61'
53 0.0008 0.00079011917114258
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 
54 0.0006 0.00056099891662598
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 
55 0.0001 0.00010299682617188
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 
56 0.0002 0.00016283988952637
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '61'
57 0.0001 0.00010108947753906
SELECT * FROM categorygroups WHERE id = '2'
58 0.0003 0.00025701522827148
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 = 62
59 0.0006 0.00056314468383789
SELECT id FROM categories WHERE parent_id = '62'
60 0.0003 0.00025510787963867
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (62)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
61 0.0005 0.00051403045654297
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (62)
				  AND p.disabled = 0 
62 0.0001 8.5115432739258E-5
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (62)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
63 0.0001 0.00012516975402832
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '62'
64 0.0001 8.702278137207E-5
SELECT * FROM categorygroups WHERE id = '2'
65 0.0058 0.0058250427246094
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 = 68
66 0.0011 0.001115083694458
SELECT id FROM categories WHERE parent_id = '68'
67 0.0060 0.0059521198272705
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (68)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
68 0.0012 0.0011539459228516
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (68)
				  AND p.disabled = 0 
69 0.0001 0.00010585784912109
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (68)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
70 0.0001 0.00011014938354492
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '68'
71 0.0001 0.00011110305786133
SELECT * FROM categorygroups WHERE id = '2'
72 0.0084 0.0083649158477783
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 = 69
73 0.0014 0.0013890266418457
SELECT id FROM categories WHERE parent_id = '69'
74 0.0083 0.008336067199707
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (69)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
75 0.0014 0.0013511180877686
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (69)
				  AND p.disabled = 0 
76 0.0001 0.00010585784912109
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (69)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
77 0.0001 0.00010204315185547
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '69'
78 0.0001 0.00010299682617188
SELECT * FROM categorygroups WHERE id = '2'
79 0.0001 0.00011897087097168
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
80 0.0003 0.00026202201843262
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 = 29
81 0.0005 0.0005190372467041
SELECT id FROM categories WHERE parent_id = '29'
82 0.0001 0.00010991096496582
SELECT id FROM categories WHERE parent_id = '30'
83 0.0001 0.00011181831359863
SELECT id FROM categories WHERE parent_id = '31'
84 0.0001 7.2956085205078E-5
SELECT id FROM categories WHERE parent_id = '32'
85 0.0001 6.5803527832031E-5
SELECT id FROM categories WHERE parent_id = '33'
86 0.0001 0.00010299682617188
SELECT id FROM categories WHERE parent_id = '34'
87 0.0001 6.6995620727539E-5
SELECT id FROM categories WHERE parent_id = '35'
88 0.0001 6.6041946411133E-5
SELECT id FROM categories WHERE parent_id = '39'
89 0.0001 6.4849853515625E-5
SELECT id FROM categories WHERE parent_id = '41'
90 0.0001 6.5088272094727E-5
SELECT id FROM categories WHERE parent_id = '36'
91 0.0001 6.4849853515625E-5
SELECT id FROM categories WHERE parent_id = '37'
92 0.0046 0.0045938491821289
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (30,31,32,33,34,35,39,41,36,37,29)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
93 0.0005 0.00053191184997559
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (30,31,32,33,34,35,39,41,36,37,29)
				  AND p.disabled = 0 
94 0.0001 6.9856643676758E-5
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (30,31,32,33,34,35,39,41,36,37,29)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
95 0.0001 6.6041946411133E-5
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
96 0.0001 6.6041946411133E-5
SELECT * FROM categorygroups WHERE id = '1'
97 0.0005 0.0005030632019043
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 = 52
98 0.0005 0.00050210952758789
SELECT id FROM categories WHERE parent_id = '52'
99 0.0005 0.00052905082702637
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (52)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
100 0.0006 0.00064516067504883
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (52)
				  AND p.disabled = 0 
101 0.0001 9.8943710327148E-5
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (52)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
102 0.0001 8.2969665527344E-5
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '52'
103 0.0001 8.2969665527344E-5
SELECT * FROM categorygroups WHERE id = '1'
104 0.0006 0.00058698654174805
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
105 0.0006 0.00062084197998047
SELECT id FROM categories WHERE parent_id = '51'
106 0.0006 0.00058317184448242
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (51)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
107 0.0005 0.0005490779876709
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (51)
				  AND p.disabled = 0 
108 0.0001 0.00013589859008789
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (51)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
109 0.0001 0.00012707710266113
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '51'
110 0.0001 0.00010991096496582
SELECT * FROM categorygroups WHERE id = '1'
111 0.0005 0.00054383277893066
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 = 28
112 0.0009 0.00089001655578613
SELECT id FROM categories WHERE parent_id = '28'
113 0.0006 0.00055098533630371
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (28)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
114 0.0006 0.00059890747070312
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (28)
				  AND p.disabled = 0 
115 0.0001 0.00010490417480469
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (28)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
116 0.0001 8.6069107055664E-5
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
117 0.0001 8.7976455688477E-5
SELECT * FROM categorygroups WHERE id = '1'
118 0.0002 0.00018501281738281
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 = 43
119 0.0005 0.00053191184997559
SELECT id FROM categories WHERE parent_id = '43'
120 0.0001 9.0122222900391E-5
SELECT id FROM categories WHERE parent_id = '44'
121 0.0001 7.1048736572266E-5
SELECT id FROM categories WHERE parent_id = '45'
122 0.0001 7.2956085205078E-5
SELECT id FROM categories WHERE parent_id = '46'
123 0.0001 6.7949295043945E-5
SELECT id FROM categories WHERE parent_id = '47'
124 0.0020 0.0019569396972656
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (44,45,46,47,43)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
125 0.0008 0.00082516670227051
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (44,45,46,47,43)
				  AND p.disabled = 0 
126 0.0001 9.4175338745117E-5
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (44,45,46,47,43)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
127 0.0001 7.2002410888672E-5
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '43'
128 0.0001 6.9856643676758E-5
SELECT * FROM categorygroups WHERE id = '1'
129 0.0008 0.00080204010009766
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
130 0.0008 0.00076889991760254
SELECT id FROM categories WHERE parent_id = '50'
131 0.0008 0.00078701972961426
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (50)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
132 0.0005 0.00051403045654297
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (50)
				  AND p.disabled = 0 
133 0.0001 8.392333984375E-5
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (50)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
134 0.0001 8.1062316894531E-5
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '50'
135 0.0001 8.2015991210938E-5
SELECT * FROM categorygroups WHERE id = '1'
136 0.0006 0.00055384635925293
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 = 54
137 0.0005 0.00050497055053711
SELECT id FROM categories WHERE parent_id = '54'
138 0.0006 0.00057697296142578
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (54)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
139 0.0005 0.00047397613525391
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (54)
				  AND p.disabled = 0 
140 0.0001 8.4161758422852E-5
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (54)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
141 0.0001 8.0108642578125E-5
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '54'
142 0.0001 8.1062316894531E-5
SELECT * FROM categorygroups WHERE id = '1'
143 0.0013 0.0012969970703125
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 = 26
144 0.0005 0.00045895576477051
SELECT id FROM categories WHERE parent_id = '26'
145 0.0013 0.0013260841369629
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (26)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
146 0.0005 0.00049781799316406
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (26)
				  AND p.disabled = 0 
147 0.0001 8.702278137207E-5
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (26)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
148 0.0001 8.2015991210938E-5
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
149 0.0001 8.2969665527344E-5
SELECT * FROM categorygroups WHERE id = '1'
150 0.0005 0.0004580020904541
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 = 38
151 0.0005 0.00046491622924805
SELECT id FROM categories WHERE parent_id = '38'
152 0.0005 0.00049591064453125
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (38)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
153 0.0005 0.00046110153198242
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (38)
				  AND p.disabled = 0 
154 0.0001 9.9897384643555E-5
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (38)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
155 0.0001 9.8943710327148E-5
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '38'
156 0.0001 0.00010204315185547
SELECT * FROM categorygroups WHERE id = '1'
157 0.0005 0.00053715705871582
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 = 48
158 0.0006 0.00058579444885254
SELECT id FROM categories WHERE parent_id = '48'
159 0.0006 0.00056195259094238
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (48)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
160 0.0005 0.00053787231445312
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (48)
				  AND p.disabled = 0 
161 0.0001 9.8943710327148E-5
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (48)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
162 0.0001 9.2029571533203E-5
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '48'
163 0.0001 0.00010108947753906
SELECT * FROM categorygroups WHERE id = '1'
164 0.0005 0.00049710273742676
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
165 0.0007 0.00066399574279785
SELECT id FROM categories WHERE parent_id = '49'
166 0.0005 0.00052189826965332
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 
167 0.0006 0.00060892105102539
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 
168 0.0001 8.392333984375E-5
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 
169 0.0001 8.6069107055664E-5
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '49'
170 0.0001 7.1048736572266E-5
SELECT * FROM categorygroups WHERE id = '1'
171 0.0004 0.00039386749267578
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 = 55
172 0.0005 0.00054812431335449
SELECT id FROM categories WHERE parent_id = '55'
173 0.0004 0.00039505958557129
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (55)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
174 0.0006 0.00062799453735352
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (55)
				  AND p.disabled = 0 
175 0.0001 8.702278137207E-5
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (55)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
176 0.0001 8.4161758422852E-5
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '55'
177 0.0001 8.392333984375E-5
SELECT * FROM categorygroups WHERE id = '1'
178 0.0006 0.00057601928710938
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 = 27
179 0.0006 0.00056600570678711
SELECT id FROM categories WHERE parent_id = '27'
180 0.0001 8.5115432739258E-5
SELECT id FROM categories WHERE parent_id = '65'
181 0.0006 0.00063014030456543
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (65,27)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
182 0.0006 0.00055408477783203
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (65,27)
				  AND p.disabled = 0 
183 0.0001 8.702278137207E-5
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (65,27)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
184 0.0001 8.6784362792969E-5
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
185 0.0001 8.2969665527344E-5
SELECT * FROM categorygroups WHERE id = '1'
186 0.0001 7.4148178100586E-5
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
187 0.0001 7.2956085205078E-5
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-fluid' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
188 0.0001 6.7949295043945E-5
SELECT value FROM parameters WHERE parameter = 'EBAY_APP_ID' 
189 0.0001 6.4849853515625E-5
SELECT value FROM parameters WHERE parameter = 'GOOGLE_SITE_KEY' 
190 0.0001 6.2942504882812E-5
SELECT value FROM parameters WHERE parameter = 'GOOGLE_SECRET_KEY' 
191 0.0001 6.3896179199219E-5
SELECT value FROM parameters WHERE parameter = 'GOOGLE_RECAPTCHA_TYPE' 
192 0.0001 0.00010013580322266
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
193 0.0002 0.00023317337036133
SELECT * FROM products WHERE pagename = 'calzoncillos-de-ropa-interior-para-personajes-de-ninas-y-ninos-de'
194 0.0001 7.2956085205078E-5
SELECT * FROM manufacturers WHERE id = '0'
195 0.0001 0.00013494491577148
SELECT category_id FROM products_categories WHERE product_id = '27730'
196 0.0005 0.0005190372467041
SELECT * FROM categories WHERE id = '69'
197 0.0001 6.0081481933594E-5
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 = 69
198 0.0001 7.9154968261719E-5
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 69
199 0.0001 7.7009201049805E-5
SELECT id FROM categories WHERE parent_id = '69'
200 0.0001 7.6055526733398E-5
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (69)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
201 0.0001 7.7009201049805E-5
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (69)
				  AND p.disabled = 0 
202 0.0001 6.3896179199219E-5
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (69)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
203 0.0001 6.0081481933594E-5
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '69'
204 0.0001 6.3180923461914E-5
SELECT * FROM productimages WHERE product_id = '27730' ORDER BY sortorder ASC
205 0.0010 0.00097489356994629
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '27730' AND p.id = pi.product_id ORDER BY pi.sortorder
206 0.0001 8.6784362792969E-5
SELECT * FROM product_image_select WHERE product_id = '27730'
207 0.0001 6.103515625E-5
SELECT * FROM productcustomimages WHERE product_id = '27730'
208 0.0002 0.00015020370483398
SELECT * FROM productfeeds WHERE product_id = '27730' ORDER BY item_date DESC
209 0.0007 0.00068116188049316
SELECT a.name, n.displayname, a.value, n.units, n.valuetype FROM productattributes a, productattributenames n WHERE product_id = '27730' AND a.name = n.originalname AND n.display = 1 AND n.hidden = 0
210 0.0007 0.00074887275695801
SELECT DISTINCT(pt.tag_id) FROM product_tags pt, tags t WHERE pt.tag_id = t.id AND pt.product_id = '27730' AND t.hidden = 0 AND display_product = 1
211 0.0007 0.00066804885864258
SELECT * FROM productamazoncontent WHERE product_id = '27730'
212 0.0005 0.00052309036254883
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 = '27730'
                GROUP BY o.product_id
213 0.0107 0.010673046112061
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     = '27730'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
214 0.0015 0.0015230178833008
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 27730
215 0.0007 0.00068902969360352
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '27730' AND a.name = n.originalname
216 0.0002 0.00018692016601562
SELECT * FROM productoffers WHERE product_id = '27730' AND merchantid = ''
217 0.0002 0.00017380714416504
SELECT * FROM productoffers
                WHERE product_id = '27730' AND price > 0
                ORDER BY price ASC LIMIT 1
218 0.0002 0.00016498565673828
SELECT * FROM productoffers
                WHERE product_id = 27730
                ORDER BY price ASC LIMIT 1
219 0.0001 9.1075897216797E-5
SELECT value FROM productattributes
                WHERE product_id = '27730'
                AND name = 'ListPriceAmount'
220 0.0001 8.8930130004883E-5
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 = '27730'
                GROUP BY o.product_id
221 0.0001 8.8930130004883E-5
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     = '27730'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
222 0.0001 8.702278137207E-5
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 27730
223 0.0001 6.4849853515625E-5
SELECT value FROM productattributes WHERE product_id = '27730' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
224 0.0010 0.0010368824005127
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '27730'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Size'
                GROUP BY o.value
                ORDER BY o.value ASC
225 0.0016 0.0016238689422607
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '27730'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Color'
                GROUP BY o.value
                ORDER BY o.value ASC
226 0.0722 0.07217001914978
SELECT *, MATCH (description, keyfeatures, title) AGAINST ('para' IN BOOLEAN MODE) AS `searchrelevance` FROM products WHERE MATCH (description, keyfeatures, title) AGAINST ('para' IN BOOLEAN MODE) AND 27730 <> 0 AND enabled = 1 AND hidden = 0 AND offers > 0 AND parent_id = 0 ORDER BY `searchrelevance` LIMIT 6
227 0.0001 0.00011086463928223
SELECT * FROM productimages WHERE product_id = '733' ORDER BY sortorder ASC
228 0.0001 9.7036361694336E-5
SELECT * FROM product_image_select WHERE product_id = '733'
229 0.0001 9.2983245849609E-5
SELECT * FROM productcustomimages WHERE product_id = '733'
230 0.0001 9.2983245849609E-5
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '733' AND a.name = n.originalname
231 0.0003 0.00025200843811035
SELECT * FROM productoffers WHERE product_id = '733' AND merchantid = ''
232 0.0001 8.5830688476562E-5
SELECT value FROM productattributes WHERE product_id = '733' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
233 0.0001 0.00014996528625488
UPDATE products SET price = '11890' WHERE id = '733'
234 0.0001 8.2015991210938E-5
SELECT * FROM productimages WHERE product_id = '751' ORDER BY sortorder ASC
235 0.0001 8.392333984375E-5
SELECT * FROM product_image_select WHERE product_id = '751'
236 0.0001 6.7949295043945E-5
SELECT * FROM productcustomimages WHERE product_id = '751'
237 0.0001 0.00010395050048828
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '751' AND a.name = n.originalname
238 0.0001 0.00014996528625488
SELECT * FROM productoffers WHERE product_id = '751' AND merchantid = ''
239 0.0001 6.9141387939453E-5
SELECT value FROM productattributes WHERE product_id = '751' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
240 0.0001 0.00011801719665527
UPDATE products SET price = '5841' WHERE id = '751'
241 0.0001 7.1048736572266E-5
SELECT * FROM productimages WHERE product_id = '758' ORDER BY sortorder ASC
242 0.0001 6.8902969360352E-5
SELECT * FROM product_image_select WHERE product_id = '758'
243 0.0001 6.5803527832031E-5
SELECT * FROM productcustomimages WHERE product_id = '758'
244 0.0001 0.00010108947753906
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '758' AND a.name = n.originalname
245 0.0001 0.00014400482177734
SELECT * FROM productoffers WHERE product_id = '758' AND merchantid = ''
246 0.0001 6.8902969360352E-5
SELECT value FROM productattributes WHERE product_id = '758' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
247 0.0001 0.00011610984802246
UPDATE products SET price = '3921' WHERE id = '758'
248 0.0001 8.2015991210938E-5
SELECT * FROM productimages WHERE product_id = '823' ORDER BY sortorder ASC
249 0.0001 8.2015991210938E-5
SELECT * FROM product_image_select WHERE product_id = '823'
250 0.0001 7.3909759521484E-5
SELECT * FROM productcustomimages WHERE product_id = '823'
251 0.0001 7.6055526733398E-5
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '823' AND a.name = n.originalname
252 0.0002 0.0001981258392334
SELECT * FROM productoffers WHERE product_id = '823' AND merchantid = ''
253 0.0001 7.0095062255859E-5
SELECT value FROM productattributes WHERE product_id = '823' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
254 0.0001 0.00011706352233887
UPDATE products SET price = '5820' WHERE id = '823'
255 0.0001 7.6055526733398E-5
SELECT * FROM productimages WHERE product_id = '952' ORDER BY sortorder ASC
256 0.0001 6.8902969360352E-5
SELECT * FROM product_image_select WHERE product_id = '952'
257 0.0001 6.6995620727539E-5
SELECT * FROM productcustomimages WHERE product_id = '952'
258 0.0001 7.2956085205078E-5
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '952' AND a.name = n.originalname
259 0.0001 0.00014519691467285
SELECT * FROM productoffers WHERE product_id = '952' AND merchantid = ''
260 0.0002 0.00015807151794434
SELECT value FROM productattributes WHERE product_id = '952' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
261 0.0001 0.00012898445129395
UPDATE products SET price = '2286' WHERE id = '952'
262 0.0001 7.6055526733398E-5
SELECT * FROM productimages WHERE product_id = '963' ORDER BY sortorder ASC
263 0.0001 6.9141387939453E-5
SELECT * FROM product_image_select WHERE product_id = '963'
264 0.0001 6.6041946411133E-5
SELECT * FROM productcustomimages WHERE product_id = '963'
265 0.0001 7.6055526733398E-5
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '963' AND a.name = n.originalname
266 0.0001 0.00014114379882812
SELECT * FROM productoffers WHERE product_id = '963' AND merchantid = ''
267 0.0001 5.3167343139648E-5
SELECT value FROM productattributes WHERE product_id = '963' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
268 0.0001 0.00011301040649414
UPDATE products SET price = '9995' WHERE id = '963'
269 0.0001 9.2029571533203E-5
SELECT value FROM parameters WHERE parameter = 'EBAY_CACHE_TIME' 
270 0.0001 6.413459777832E-5
SELECT value FROM parameters WHERE parameter = 'EBAY_APP_ID' 
271 0.0001 6.1988830566406E-5
SELECT value FROM parameters WHERE parameter = 'EBAY_TRACKING_ID' 
272 0.0001 6.2942504882812E-5
SELECT value FROM parameters WHERE parameter = 'EBAY_NETWORK_ID' 
273 0.0001 9.5129013061523E-5
SELECT value FROM parameters WHERE parameter = 'EBAY_LOCALE' 
274 0.0001 6.3180923461914E-5
SELECT value FROM parameters WHERE parameter = 'EBAY_AUTH_TOKEN' 
275 0.0001 6.3180923461914E-5
SELECT * FROM ebay_locale_details WHERE cur_code = 'USD' 
276 0.0002 0.00016403198242188
SELECT * FROM ebay_products_cache WHERE cachekey = '6dd8fc2905857705efeaf34e30a4718e' 
277 0.0016 0.0015769004821777
SELECT value FROM parameters WHERE parameter = 'EBAY_APP_ID' 
278 0.0001 5.9843063354492E-5
SELECT value FROM parameters WHERE parameter = 'EBAY_TRACKING_ID' 
279 0.0001 5.793571472168E-5
SELECT value FROM parameters WHERE parameter = 'EBAY_NETWORK_ID' 
280 0.0001 5.8174133300781E-5
SELECT value FROM parameters WHERE parameter = 'EBAY_LOCALE' 
281 0.0001 5.793571472168E-5
SELECT value FROM parameters WHERE parameter = 'EBAY_AUTH_TOKEN' 
282 0.0002 0.00020003318786621
SELECT * FROM ebay_products_cache WHERE cachekey = '6dd8fc2905857705efeaf34e30a4718e' 
283 0.0006 0.00055289268493652
SELECT id,asin FROM products WHERE parent_id = 27730
284 0.0003 0.00029492378234863
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 27731
285 0.0019 0.0018789768218994
SELECT name,value FROM productoptions WHERE name="Color" AND product_id = 27731
286 0.0006 0.00056290626525879
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 27732
287 0.0007 0.00066995620727539
SELECT name,value FROM productoptions WHERE name="Color" AND product_id = 27732
288 0.0005 0.00051617622375488
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 27733
289 0.0006 0.00056910514831543
SELECT name,value FROM productoptions WHERE name="Color" AND product_id = 27733
290 0.0005 0.00050616264343262
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 27734
291 0.0006 0.00060296058654785
SELECT name,value FROM productoptions WHERE name="Color" AND product_id = 27734
292 0.0005 0.00047206878662109
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 27735
293 0.0006 0.00055098533630371
SELECT name,value FROM productoptions WHERE name="Color" AND product_id = 27735
294 0.0005 0.00046110153198242
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 27736
295 0.0005 0.00053787231445312
SELECT name,value FROM productoptions WHERE name="Color" AND product_id = 27736
296 0.0005 0.00045990943908691
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 27737
297 0.0006 0.00058102607727051
SELECT name,value FROM productoptions WHERE name="Color" AND product_id = 27737
298 0.0005 0.00047898292541504
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 27738
299 0.0005 0.00051593780517578
SELECT name,value FROM productoptions WHERE name="Color" AND product_id = 27738
300 0.0005 0.0004730224609375
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 27739
301 0.0005 0.00053811073303223
SELECT name,value FROM productoptions WHERE name="Color" AND product_id = 27739
302 0.0005 0.00053191184997559
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 27740
303 0.0006 0.00061798095703125
SELECT name,value FROM productoptions WHERE name="Color" AND product_id = 27740
304 0.0005 0.00049996376037598
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 27741
305 0.0006 0.00059604644775391
SELECT name,value FROM productoptions WHERE name="Color" AND product_id = 27741
306 0.0005 0.00051021575927734
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 27742
307 0.0006 0.00060701370239258
SELECT name,value FROM productoptions WHERE name="Color" AND product_id = 27742
308 0.0005 0.00046396255493164
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 27743
309 0.0006 0.00060486793518066
SELECT name,value FROM productoptions WHERE name="Color" AND product_id = 27743
310 0.0005 0.00045204162597656
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 27746
311 0.0006 0.00057196617126465
SELECT name,value FROM productoptions WHERE name="Color" AND product_id = 27746
312 0.0005 0.00052213668823242
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 27747
313 0.0006 0.00063490867614746
SELECT name,value FROM productoptions WHERE name="Color" AND product_id = 27747
314 0.0005 0.00045490264892578
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 27748
315 0.0006 0.00058603286743164
SELECT name,value FROM productoptions WHERE name="Color" AND product_id = 27748
316 0.0004 0.0004429817199707
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 27749
317 0.0006 0.00059103965759277
SELECT name,value FROM productoptions WHERE name="Color" AND product_id = 27749
318 0.0004 0.00044894218444824
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 27750
319 0.0006 0.00058197975158691
SELECT name,value FROM productoptions WHERE name="Color" AND product_id = 27750
320 0.0005 0.00050616264343262
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 27751
321 0.0006 0.0006098747253418
SELECT name,value FROM productoptions WHERE name="Color" AND product_id = 27751
322 0.0005 0.0004580020904541
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 27752
323 0.0006 0.00056910514831543
SELECT name,value FROM productoptions WHERE name="Color" AND product_id = 27752
324 0.0004 0.00043296813964844
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 27753
325 0.0006 0.00055813789367676
SELECT name,value FROM productoptions WHERE name="Color" AND product_id = 27753
326 0.0004 0.00041890144348145
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 27754
327 0.0006 0.00058794021606445
SELECT name,value FROM productoptions WHERE name="Color" AND product_id = 27754
328 0.0004 0.00043511390686035
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 27756
329 0.0006 0.00058102607727051
SELECT name,value FROM productoptions WHERE name="Color" AND product_id = 27756
330 0.0004 0.00042915344238281
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 27757
331 0.0006 0.00059604644775391
SELECT name,value FROM productoptions WHERE name="Color" AND product_id = 27757
332 0.0005 0.00048995018005371
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 27758
333 0.0006 0.00056910514831543
SELECT name,value FROM productoptions WHERE name="Color" AND product_id = 27758
334 0.0004 0.00043821334838867
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 27759
335 0.0006 0.00056314468383789
SELECT name,value FROM productoptions WHERE name="Color" AND product_id = 27759
336 0.0005 0.00048089027404785
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 27760
337 0.0006 0.0006251335144043
SELECT name,value FROM productoptions WHERE name="Color" AND product_id = 27760
338 0.0004 0.00043106079101562
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 27761
339 0.0005 0.00051689147949219
SELECT name,value FROM productoptions WHERE name="Color" AND product_id = 27761
340 0.0004 0.00039005279541016
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 27762
341 0.0005 0.00047802925109863
SELECT name,value FROM productoptions WHERE name="Color" AND product_id = 27762
342 0.0004 0.00042486190795898
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 27763
343 0.0005 0.00046896934509277
SELECT name,value FROM productoptions WHERE name="Color" AND product_id = 27763
344 0.0004 0.00041484832763672
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 27764
345 0.0005 0.00047707557678223
SELECT name,value FROM productoptions WHERE name="Color" AND product_id = 27764
346 0.0004 0.00043702125549316
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 27765
347 0.0005 0.00046920776367188
SELECT name,value FROM productoptions WHERE name="Color" AND product_id = 27765
348 0.0004 0.0003969669342041
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 27766
349 0.0005 0.00046801567077637
SELECT name,value FROM productoptions WHERE name="Color" AND product_id = 27766
350 0.0004 0.00039982795715332
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 27767
351 0.0005 0.00050687789916992
SELECT name,value FROM productoptions WHERE name="Color" AND product_id = 27767
352 0.0004 0.00040316581726074
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 27769
353 0.0005 0.00049614906311035
SELECT name,value FROM productoptions WHERE name="Color" AND product_id = 27769
354 0.0004 0.00037002563476562
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 27770
355 0.0005 0.0004580020904541
SELECT name,value FROM productoptions WHERE name="Color" AND product_id = 27770
356 0.0004 0.00036978721618652
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 27771
357 0.0005 0.00047206878662109
SELECT name,value FROM productoptions WHERE name="Color" AND product_id = 27771
358 0.0004 0.00037097930908203
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 27772
359 0.0005 0.00046014785766602
SELECT name,value FROM productoptions WHERE name="Color" AND product_id = 27772
360 0.0004 0.0003969669342041
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 27773
361 0.0005 0.00045895576477051
SELECT name,value FROM productoptions WHERE name="Color" AND product_id = 27773
362 0.0004 0.00039505958557129
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 27774
363 0.0005 0.00047397613525391
SELECT name,value FROM productoptions WHERE name="Color" AND product_id = 27774
364 0.0004 0.00038599967956543
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 27775
365 0.0005 0.00045895576477051
SELECT name,value FROM productoptions WHERE name="Color" AND product_id = 27775
366 0.0004 0.00037288665771484
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 27776
367 0.0005 0.00046110153198242
SELECT name,value FROM productoptions WHERE name="Color" AND product_id = 27776
368 0.0004 0.00036311149597168
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 27777
369 0.0005 0.00049781799316406
SELECT name,value FROM productoptions WHERE name="Color" AND product_id = 27777
370 0.0004 0.0003659725189209
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 27778
371 0.0005 0.00045204162597656
SELECT name,value FROM productoptions WHERE name="Color" AND product_id = 27778
372 0.0004 0.00038003921508789
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 27779
373 0.0005 0.00045204162597656
SELECT name,value FROM productoptions WHERE name="Color" AND product_id = 27779
374 0.0004 0.00035405158996582
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 27780
375 0.0004 0.00043916702270508
SELECT name,value FROM productoptions WHERE name="Color" AND product_id = 27780
376 0.0004 0.00037217140197754
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 27781
377 0.0004 0.00043201446533203
SELECT name,value FROM productoptions WHERE name="Color" AND product_id = 27781
378 0.0004 0.00036215782165527
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 27782
379 0.0004 0.00044703483581543
SELECT name,value FROM productoptions WHERE name="Color" AND product_id = 27782
380 0.0004 0.0003509521484375
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 27783
381 0.0005 0.00048398971557617
SELECT name,value FROM productoptions WHERE name="Color" AND product_id = 27783
382 0.0003 0.00033998489379883
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 27785
383 0.0004 0.00043678283691406
SELECT name,value FROM productoptions WHERE name="Color" AND product_id = 27785
384 0.0003 0.00033903121948242
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 27786
385 0.0004 0.00043296813964844
SELECT name,value FROM productoptions WHERE name="Color" AND product_id = 27786
386 0.0003 0.0002589225769043
SELECT category_id FROM products_categories WHERE product_id = '27730'
387 0.0001 0.00012898445129395
SELECT * FROM categories WHERE id = '69'
388 0.0001 0.00011897087097168
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 = 69
389 0.0001 0.00011706352233887
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 69
390 0.0001 0.00011801719665527
SELECT id FROM categories WHERE parent_id = '69'
391 0.0001 0.00012707710266113
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (69)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
392 0.0001 0.00010800361633301
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (69)
				  AND p.disabled = 0 
393 0.0001 6.6995620727539E-5
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (69)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
394 0.0001 6.3896179199219E-5
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '69'
395 0.0001 8.1062316894531E-5
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '27730' AND a.name = n.originalname
396 0.0001 6.7949295043945E-5
SELECT * FROM productoffers WHERE product_id = '27730' AND merchantid = ''
397 0.0001 6.8187713623047E-5
SELECT * FROM productoffers
                WHERE product_id = '27730' AND price > 0
                ORDER BY price ASC LIMIT 1
398 0.0001 6.4849853515625E-5
SELECT * FROM productoffers
                WHERE product_id = 27730
                ORDER BY price ASC LIMIT 1
399 0.0001 6.2942504882812E-5
SELECT value FROM productattributes
                WHERE product_id = '27730'
                AND name = 'ListPriceAmount'
400 0.0002 0.00018501281738281
SELECT * FROM products WHERE id = '27730'
401 0.0001 6.7949295043945E-5
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 = '27730'
                GROUP BY o.product_id
402 0.0001 7.5101852416992E-5
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     = '27730'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
403 0.0001 8.0108642578125E-5
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 27730
404 0.0001 6.4849853515625E-5
SELECT value FROM productattributes WHERE product_id = '27730' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
405 0.0001 7.0095062255859E-5
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '27730' AND a.name = n.originalname
406 0.0001 9.3936920166016E-5
SELECT * FROM productoffers WHERE product_id = '27730' AND merchantid = ''
407 0.0001 6.6995620727539E-5
SELECT * FROM productoffers
                WHERE product_id = '27730' AND price > 0
                ORDER BY price ASC LIMIT 1
408 0.0001 6.5088272094727E-5
SELECT * FROM productoffers
                WHERE product_id = 27730
                ORDER BY price ASC LIMIT 1
409 0.0001 6.2942504882812E-5
SELECT value FROM productattributes
                WHERE product_id = '27730'
                AND name = 'ListPriceAmount'
410 0.0001 6.6995620727539E-5
SELECT DISTINCT (name) FROM productoptions
411 0.0005 0.00048518180847168
SELECT * FROM productoptions WHERE product_id IN (SELECT product_id FROM productoffers WHERE product_id IN (SELECT id from products WHERE parent_id = 27730))
412 0.0012 0.0011940002441406
SELECT	o.value, o.name
			FROM	products			p,
					productoptions		o
			WHERE	p.parent_id		= 27730
			  AND	p.id			= o.product_id 
			GROUP BY o.value ORDER BY o.value ASC
413 0.0001 7.7962875366211E-5
SELECT * FROM translationsfilter
414 0.0001 6.6041946411133E-5
SELECT category_id FROM products_categories WHERE product_id = '27730'
415 0.0001 6.3896179199219E-5
SELECT parent_id FROM categories WHERE id = '69'
416 0.0001 6.9141387939453E-5
SELECT * FROM categories WHERE id = '69'
417 0.0001 6.3180923461914E-5
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 = 69
418 0.0001 6.2942504882812E-5
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 69
419 0.0001 6.3896179199219E-5
SELECT id FROM categories WHERE parent_id = '69'
420 0.0001 7.2956085205078E-5
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (69)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
421 0.0001 8.1062316894531E-5
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (69)
				  AND p.disabled = 0 
422 0.0001 6.413459777832E-5
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (69)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
423 0.0001 6.413459777832E-5
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '69'
424 0.0001 6.5088272094727E-5
SELECT * FROM template_info WHERE templateuid = 'fsb-fluid'
425 0.0001 7.0095062255859E-5
SELECT * FROM pages WHERE id = 52
426 0.0001 6.2942504882812E-5
SELECT * FROM pages WHERE id = 53
427 0.0001 6.5088272094727E-5
SELECT * FROM pages WHERE id = 54
428 0.0001 6.1988830566406E-5
SELECT * FROM pages WHERE id = 51
429 0.0001 6.5088272094727E-5
SELECT * FROM pages WHERE id = 52
430 0.0001 7.5817108154297E-5
SELECT * FROM pages WHERE id = 53
431 0.0001 6.6995620727539E-5
SELECT * FROM pages WHERE id = 54
432 0.0001 6.5088272094727E-5
SELECT * FROM pages WHERE id = 51
433 0.0007 0.00072884559631348
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 (p.price >= 1000 AND p.price <= 50000) 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 o.percentagesaved DESC LIMIT 4
434 0.0004 0.00043201446533203
UPDATE template_options SET value = 'a:10:{s:14:\"populationtype\";s:9:\"automatic\";s:12:\"productcount\";s:1:\"4\";s:12:\"maxsalesrank\";s:0:\"\";s:8:\"minprice\";s:2:\"10\";s:8:\"maxprice\";s:3:\"500\";s:9:\"minimages\";s:1:\"1\";s:10:\"updatetime\";s:5:\"21600\";s:13:\"selectiontype\";s:13:\"specialoffers\";s:11:\"lastupdated\";i:1560656284;s:8:\"products\";a:4:{i:0;s:4:\"2275\";i:1;s:4:\"4619\";i:2;s:3:\"955\";i:3;s:4:\"1934\";}}' WHERE id = '207'
435 0.0002 0.00024700164794922
SELECT * FROM products WHERE id IN (2275,4619,955,1934) ORDER BY FIELD(id, 2275,4619,955,1934 )
436 0.0001 7.5101852416992E-5
SELECT * FROM productimages WHERE product_id = '2275' ORDER BY sortorder ASC
437 0.0001 7.6055526733398E-5
SELECT * FROM product_image_select WHERE product_id = '2275'
438 0.0001 6.0081481933594E-5
SELECT * FROM productcustomimages WHERE product_id = '2275'
439 0.0001 9.3936920166016E-5
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2275' AND a.name = n.originalname
440 0.0001 6.2942504882812E-5
SELECT * FROM productoffers WHERE product_id = '2275' AND merchantid = ''
441 0.0001 5.793571472168E-5
SELECT value FROM productattributes WHERE product_id = '2275' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
442 0.0001 0.0001068115234375
UPDATE products SET price = '8575' WHERE id = '2275'
443 0.0001 6.4849853515625E-5
SELECT * FROM productimages WHERE product_id = '4619' ORDER BY sortorder ASC
444 0.0001 5.793571472168E-5
SELECT * FROM product_image_select WHERE product_id = '4619'
445 0.0001 5.6982040405273E-5
SELECT * FROM productcustomimages WHERE product_id = '4619'
446 0.0001 6.2942504882812E-5
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4619' AND a.name = n.originalname
447 0.0001 6.1988830566406E-5
SELECT * FROM productoffers WHERE product_id = '4619' AND merchantid = ''
448 0.0001 5.7220458984375E-5
SELECT value FROM productattributes WHERE product_id = '4619' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
449 0.0001 0.00010180473327637
UPDATE products SET price = '2993' WHERE id = '4619'
450 0.0001 6.8902969360352E-5
SELECT * FROM productimages WHERE product_id = '955' ORDER BY sortorder ASC
451 0.0001 7.4148178100586E-5
SELECT * FROM product_image_select WHERE product_id = '955'
452 0.0001 5.6982040405273E-5
SELECT * FROM productcustomimages WHERE product_id = '955'
453 0.0001 6.413459777832E-5
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '955' AND a.name = n.originalname
454 0.0001 9.3936920166016E-5
SELECT * FROM productoffers WHERE product_id = '955' AND merchantid = ''
455 0.0001 6.7949295043945E-5
SELECT value FROM productattributes WHERE product_id = '955' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
456 0.0001 0.00010204315185547
UPDATE products SET price = '7426' WHERE id = '955'
457 0.0001 5.9843063354492E-5
SELECT * FROM productimages WHERE product_id = '1934' ORDER BY sortorder ASC
458 0.0001 6.0081481933594E-5
SELECT * FROM product_image_select WHERE product_id = '1934'
459 0.0001 6.0081481933594E-5
SELECT * FROM productcustomimages WHERE product_id = '1934'
460 0.0001 6.1988830566406E-5
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1934' AND a.name = n.originalname
461 0.0001 5.9127807617188E-5
SELECT * FROM productoffers WHERE product_id = '1934' AND merchantid = ''
462 0.0001 6.7949295043945E-5
SELECT value FROM productattributes WHERE product_id = '1934' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
463 0.0001 0.00010585784912109
UPDATE products SET price = '15048' WHERE id = '1934'
464 0.0001 6.6995620727539E-5
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid' AND area = 'header' ORDER BY sortorder ASC
465 0.0001 6.7949295043945E-5
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
466 0.0001 5.6982040405273E-5
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
467 0.0001 5.6982040405273E-5
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
468 0.0001 5.6982040405273E-5
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
469 0.0001 6.413459777832E-5
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid' AND area = 'footer' ORDER BY sortorder ASC
470 0.0001 5.7220458984375E-5
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
471 0.0001 5.6982040405273E-5
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
472 0.0001 5.6028366088867E-5
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
473 0.0001 8.7976455688477E-5
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-fluid' AND skinuid = ''
474 0.0001 7.5817108154297E-5
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid'
475 0.0001 6.8187713623047E-5
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid'
476 0.0001 0.00012397766113281
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid' AND imageuid = 'HEAD_LOGO'
477 0.0001 9.7990036010742E-5
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-fluid' AND textuid = '' AND language = 'en'
478 0.0001 0.00010085105895996
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid' AND imageuid = 'HEAD_LOGO'