LEGO The Hobbit - Hobbit 3, juego de construcción (79007) por LEGO

Precio: 146,30€
Los precios de los productos y la disponibilidad son correctos a fecha 2019-06-15 08:50:31 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 Producto

Consigue de forma segura, rápida y al mejor precio el fantástico LEGO The Hobbit - Hobbit 3, juego de construcción (79007) por LEGO.

Si tienes cualquier duda o no encuentras el juguete que buscas pídenoslo y estaremos encantados de ayudarte.
Envíanos tus comentarios o preguntas a info@juguetepia.com.

También puedes visitar la tienda de juguetes de Amazon pulsando aquí.

Descripción del Fabricante

LEGO The Hobbit - Hobbit 3, juego de construcción (79007)

Características del Producto

Incluye la Gran Águila y 5 minifiguras con armas: Aragorn, Gandalf el Blanco, Boca de Sauron y 2 orcos de Mordor. La Puerta Negra de Mordor (cerrada) mide más de 22 cm de altura, 30 cm de ancho y 7 cm de profundidad. La Gran Águila (con las alas extendidas) mide más de 19 cm.

Debug Overview

App Total Time DB Queries DB Query Total Time Amazon Requests
0.87283802032471 389 0.1870 0


No Amazon API Requests Made.


App Debug - Total Time 0.87283802032471 seconds

Number Time From Start Name Description
1 0.3337709903717 Initialise Initialise FSB Function
2 0.33614587783813 App Controller Start Start of the App controller (called before the controller of every page)
3 0.33772802352905 Start of getCategoryListByGroup Function Before first category groups query
4 0.3378529548645 After initial query Before first category groups query
5 0.33785390853882 Get Category List for Group Before the call to getCategoryList function
6 0.33785581588745 Start of GetCategoryList function Start of the function
7 0.33785891532898 Before getting categories Query to get specific category list
8 0.33803200721741 After getting categories Query to get specific category list
9 0.33803296089172 Before getting category custom Before call to function getCategoryCustom
10 0.33859300613403 After getting category custom After call to function getCategoryCustom
11 0.33859491348267 Before getting category custom Before call to function getCategoryCustom
12 0.33907890319824 After getting category custom After call to function getCategoryCustom
13 0.33907985687256 Before getting category custom Before call to function getCategoryCustom
14 0.33961081504822 After getting category custom After call to function getCategoryCustom
15 0.33961200714111 Before getting category custom Before call to function getCategoryCustom
16 0.34021496772766 After getting category custom After call to function getCategoryCustom
17 0.34021592140198 Before getting category custom Before call to function getCategoryCustom
18 0.34069895744324 After getting category custom After call to function getCategoryCustom
19 0.34069991111755 Before getting category custom Before call to function getCategoryCustom
20 0.34116697311401 After getting category custom After call to function getCategoryCustom
21 0.34116792678833 Before getting category custom Before call to function getCategoryCustom
22 0.34164595603943 After getting category custom After call to function getCategoryCustom
23 0.34164690971375 Before getting category custom Before call to function getCategoryCustom
24 0.34212398529053 After getting category custom After call to function getCategoryCustom
25 0.34212493896484 Before getting category custom Before call to function getCategoryCustom
26 0.34260892868042 After getting category custom After call to function getCategoryCustom
27 0.34260988235474 End of GetCategoryList function End of the function
28 0.34261393547058 Get Category List for Group Before the call to getCategoryList function
29 0.3426148891449 Start of GetCategoryList function Start of the function
30 0.34261584281921 Before getting categories Query to get specific category list
31 0.34271597862244 After getting categories Query to get specific category list
32 0.34271693229675 Before getting category custom Before call to function getCategoryCustom
33 0.34386491775513 After getting category custom After call to function getCategoryCustom
34 0.34386587142944 Before getting category custom Before call to function getCategoryCustom
35 0.34433603286743 After getting category custom After call to function getCategoryCustom
36 0.34433603286743 Before getting category custom Before call to function getCategoryCustom
37 0.34480690956116 After getting category custom After call to function getCategoryCustom
38 0.34480786323547 Before getting category custom Before call to function getCategoryCustom
39 0.34530401229858 After getting category custom After call to function getCategoryCustom
40 0.3453049659729 Before getting category custom Before call to function getCategoryCustom
41 0.34605884552002 After getting category custom After call to function getCategoryCustom
42 0.34606003761292 Before getting category custom Before call to function getCategoryCustom
43 0.34653282165527 After getting category custom After call to function getCategoryCustom
44 0.34653401374817 Before getting category custom Before call to function getCategoryCustom
45 0.34707283973694 After getting category custom After call to function getCategoryCustom
46 0.34707403182983 Before getting category custom Before call to function getCategoryCustom
47 0.34755897521973 After getting category custom After call to function getCategoryCustom
48 0.34755992889404 Before getting category custom Before call to function getCategoryCustom
49 0.34803986549377 After getting category custom After call to function getCategoryCustom
50 0.34804081916809 Before getting category custom Before call to function getCategoryCustom
51 0.34854197502136 After getting category custom After call to function getCategoryCustom
52 0.34854292869568 Before getting category custom Before call to function getCategoryCustom
53 0.34901785850525 After getting category custom After call to function getCategoryCustom
54 0.34901905059814 Before getting category custom Before call to function getCategoryCustom
55 0.34946990013123 After getting category custom After call to function getCategoryCustom
56 0.34947085380554 Before getting category custom Before call to function getCategoryCustom
57 0.35001993179321 After getting category custom After call to function getCategoryCustom
58 0.35001993179321 End of GetCategoryList function End of the function
59 0.35002493858337 End of getCategoryListByGroup Function Before return()
60 0.35078001022339 App Controller End End of the App controller (called before the controller of every page)
61 0.35082387924194 Product Start Start of the product info controller
62 0.35125088691711 Cache file not found Starting get product details
63 0.36717581748962 Related products Start getting related products if enabled
64 0.36717700958252 Related Products Start Before the related products are found
65 0.36717700958252 Related Products Keywords Before the related product keywords are found
66 0.367182970047 Create Keyword List Function Start of function
67 0.36741590499878 Create Keyword List Function After looping provided content - 287 keywords found
68 0.37576603889465 Create Keyword List Function After looping initial keyword list - 258 keywords remaining
69 0.37579298019409 Create Keyword List Function After reducing keyword list
70 0.37628102302551 Create Keyword List Function After selecting by scoring keywords
71 0.37628388404846 Create Keyword List Function After final loop of keywords
72 0.37628483772278 Related Products Keywords After the related product keywords are found
73 0.52355003356934 Related Products End After the related products are found
74 0.52472186088562 Start Remote Request http://svcs.ebay.com/services/search/FindingServic...
75 0.85235500335693 End Remote Request http://svcs.ebay.com/services/search/FindingServic...
76 0.85699987411499 Product End End of the product info controller (Product Info)
77 0.8571789264679 App_after Controller Start Start of the App_after controller (called after the controller of every page)
78 0.85722494125366 Before Get Options Before the call to getOptions in the tpl class
79 0.8622670173645 After Get Options After the call to getOptions in the tpl class
80 0.86235904693604 App_after Controller End End of the App_after controller (called after the controller of every page)
81 0.86236500740051 Product Info: Before Smarty Fetch Before the product.tpl template is fetched
82 0.86615681648254 Product Info: After Smarty Fetch After the product.tpl template is fetched
83 0.86615991592407 Product Info: Before Template Display Before the template is displayed
84 0.87282299995422 Product Info: After Template Display After the template is displayed
85 0.87282586097717 Finalizing debug Before the debug is output to the page.
86 0.87283802032471 End of App This is the end of the app logging, final timestamp


Query Debug - 389 Database Queries. Total time 0.1870 seconds

Number Time (Seconds) Time (Milliseconds) Query
1 0.0001 0.00010800361633301
SELECT value FROM parameters WHERE `parameter` = 'BAD_BOTS_ENABLER'
2 0.0005 0.0004880428314209
SHOW TABLES LIKE 'bad_bots'
3 0.0001 0.00011396408081055
SELECT value FROM parameters WHERE `parameter` = 'STORE_WHITELISTED_IPS'
4 0.0001 0.00011706352233887
SELECT * FROM `bad_bots`
5 0.0002 0.00017499923706055
SELECT parameter, value FROM parameters
6 0.0002 0.0002140998840332
SET time_zone = 'Europe/London'
7 0.0001 0.00014400482177734
SELECT * FROM autorun ORDER BY lastrun ASC
8 0.0001 0.00010919570922852
SELECT * FROM version ORDER BY installed DESC LIMIT 1
9 0.0003 0.00029587745666504
SELECT id FROM pages WHERE pagename = 'lego-the-hobbit-hobbit-3-juego-de-construccion-79007' LIMIT 1
10 0.0019 0.0018630027770996
SELECT id FROM products WHERE pagename = 'lego-the-hobbit-hobbit-3-juego-de-construccion-79007' AND hidden = 0 LIMIT 1
11 0.0008 0.00084495544433594
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-fluid'
12 0.0002 0.00018501281738281
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-fluid' AND language = 'es'
13 0.0002 0.00022292137145996
SELECT * FROM pages WHERE pagename = 'lego-the-hobbit-hobbit-3-juego-de-construccion-79007'
14 0.0001 0.00010395050048828
SELECT * FROM categorygroups ORDER BY sortorder ASC
15 0.0002 0.0001530647277832
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '2'  AND hidden = 0 ORDER BY sortorder ASC
16 0.0001 9.0122222900391E-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 = 70
17 0.0001 6.5088272094727E-5
SELECT id FROM categories WHERE parent_id = '70'
18 0.0001 5.793571472168E-5
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.0001 5.9127807617188E-5
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 6.8187713623047E-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 5.793571472168E-5
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '70'
22 0.0001 6.0081481933594E-5
SELECT * FROM categorygroups WHERE id = '2'
23 0.0001 6.7949295043945E-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 = 66
24 0.0001 5.793571472168E-5
SELECT id FROM categories WHERE parent_id = '66'
25 0.0001 5.793571472168E-5
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.0001 5.8174133300781E-5
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 5.6982040405273E-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 5.793571472168E-5
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '66'
29 0.0001 5.9843063354492E-5
SELECT * FROM categorygroups WHERE id = '2'
30 0.0001 5.793571472168E-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 = 67
31 0.0001 6.103515625E-5
SELECT id FROM categories WHERE parent_id = '67'
32 0.0001 7.7009201049805E-5
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.0001 6.1988830566406E-5
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 5.793571472168E-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 7.4863433837891E-5
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '67'
36 0.0001 5.6982040405273E-5
SELECT * FROM categorygroups WHERE id = '2'
37 0.0001 8.702278137207E-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 = 56
38 0.0001 7.6055526733398E-5
SELECT id FROM categories WHERE parent_id = '56'
39 0.0001 7.3909759521484E-5
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.0001 7.4863433837891E-5
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 7.4863433837891E-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 7.2956085205078E-5
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '56'
43 0.0001 7.3909759521484E-5
SELECT * FROM categorygroups WHERE id = '2'
44 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 = 59
45 0.0001 5.9127807617188E-5
SELECT id FROM categories WHERE parent_id = '59'
46 0.0001 6.1988830566406E-5
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.0001 5.9127807617188E-5
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 5.8174133300781E-5
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 5.8174133300781E-5
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '59'
50 0.0001 6.3896179199219E-5
SELECT * FROM categorygroups WHERE id = '2'
51 0.0001 5.9127807617188E-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 = 61
52 0.0001 5.8174133300781E-5
SELECT id FROM categories WHERE parent_id = '61'
53 0.0001 5.9127807617188E-5
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.0001 5.9843063354492E-5
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 5.8889389038086E-5
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.0001 5.793571472168E-5
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '61'
57 0.0001 5.8889389038086E-5
SELECT * FROM categorygroups WHERE id = '2'
58 0.0001 5.9127807617188E-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 = 62
59 0.0001 5.8174133300781E-5
SELECT id FROM categories WHERE parent_id = '62'
60 0.0001 5.793571472168E-5
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.0001 5.9843063354492E-5
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 5.9843063354492E-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 5.793571472168E-5
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '62'
64 0.0001 6.6995620727539E-5
SELECT * FROM categorygroups WHERE id = '2'
65 0.0001 6.1988830566406E-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 = 68
66 0.0001 5.9127807617188E-5
SELECT id FROM categories WHERE parent_id = '68'
67 0.0001 5.8889389038086E-5
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.0001 6.2942504882812E-5
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 5.8889389038086E-5
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 5.8889389038086E-5
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '68'
71 0.0001 5.8889389038086E-5
SELECT * FROM categorygroups WHERE id = '2'
72 0.0001 5.8889389038086E-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
73 0.0001 5.793571472168E-5
SELECT id FROM categories WHERE parent_id = '69'
74 0.0001 5.793571472168E-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 
75 0.0001 5.9127807617188E-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 
76 0.0001 7.7009201049805E-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 
77 0.0001 5.9843063354492E-5
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '69'
78 0.0001 5.8889389038086E-5
SELECT * FROM categorygroups WHERE id = '2'
79 0.0001 7.8916549682617E-5
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
80 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 = 29
81 0.0001 6.0081481933594E-5
SELECT id FROM categories WHERE parent_id = '29'
82 0.0001 5.8889389038086E-5
SELECT id FROM categories WHERE parent_id = '30'
83 0.0001 5.8174133300781E-5
SELECT id FROM categories WHERE parent_id = '31'
84 0.0001 5.793571472168E-5
SELECT id FROM categories WHERE parent_id = '32'
85 0.0001 5.793571472168E-5
SELECT id FROM categories WHERE parent_id = '33'
86 0.0001 5.793571472168E-5
SELECT id FROM categories WHERE parent_id = '34'
87 0.0001 6.7949295043945E-5
SELECT id FROM categories WHERE parent_id = '35'
88 0.0001 5.9127807617188E-5
SELECT id FROM categories WHERE parent_id = '39'
89 0.0001 5.793571472168E-5
SELECT id FROM categories WHERE parent_id = '41'
90 0.0001 5.793571472168E-5
SELECT id FROM categories WHERE parent_id = '36'
91 0.0001 5.793571472168E-5
SELECT id FROM categories WHERE parent_id = '37'
92 0.0001 5.8889389038086E-5
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.0001 6.6995620727539E-5
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.0081481933594E-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.103515625E-5
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
96 0.0001 5.8889389038086E-5
SELECT * FROM categorygroups WHERE id = '1'
97 0.0001 6.103515625E-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 = 52
98 0.0001 5.793571472168E-5
SELECT id FROM categories WHERE parent_id = '52'
99 0.0001 5.8889389038086E-5
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.0001 5.9843063354492E-5
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 5.8889389038086E-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 5.8889389038086E-5
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '52'
103 0.0001 5.8889389038086E-5
SELECT * FROM categorygroups WHERE id = '1'
104 0.0001 5.8889389038086E-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 = 51
105 0.0001 5.793571472168E-5
SELECT id FROM categories WHERE parent_id = '51'
106 0.0001 5.9127807617188E-5
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.0001 5.9127807617188E-5
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 6.0081481933594E-5
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 5.9127807617188E-5
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '51'
110 0.0001 6.103515625E-5
SELECT * FROM categorygroups WHERE id = '1'
111 0.0001 5.9127807617188E-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 = 28
112 0.0001 5.8889389038086E-5
SELECT id FROM categories WHERE parent_id = '28'
113 0.0001 6.6995620727539E-5
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.0001 5.6982040405273E-5
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 7.5101852416992E-5
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 5.9127807617188E-5
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
117 0.0001 5.6982040405273E-5
SELECT * FROM categorygroups WHERE id = '1'
118 0.0001 6.8902969360352E-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 = 43
119 0.0001 5.9127807617188E-5
SELECT id FROM categories WHERE parent_id = '43'
120 0.0001 5.6028366088867E-5
SELECT id FROM categories WHERE parent_id = '44'
121 0.0001 5.6028366088867E-5
SELECT id FROM categories WHERE parent_id = '45'
122 0.0001 6.1988830566406E-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.0001 5.793571472168E-5
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.0001 5.8174133300781E-5
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 5.6982040405273E-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 5.793571472168E-5
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '43'
128 0.0001 5.9127807617188E-5
SELECT * FROM categorygroups WHERE id = '1'
129 0.0001 5.6982040405273E-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 = 50
130 0.0001 5.6982040405273E-5
SELECT id FROM categories WHERE parent_id = '50'
131 0.0001 5.6982040405273E-5
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.0001 5.6028366088867E-5
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 5.793571472168E-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 7.4863433837891E-5
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '50'
135 0.0001 5.793571472168E-5
SELECT * FROM categorygroups WHERE id = '1'
136 0.0001 5.6982040405273E-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 = 54
137 0.0001 6.8187713623047E-5
SELECT id FROM categories WHERE parent_id = '54'
138 0.0001 6.6995620727539E-5
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.0001 6.5803527832031E-5
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 7.6055526733398E-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 7.5817108154297E-5
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '54'
142 0.0001 5.793571472168E-5
SELECT * FROM categorygroups WHERE id = '1'
143 0.0001 5.793571472168E-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 = 26
144 0.0001 6.5088272094727E-5
SELECT id FROM categories WHERE parent_id = '26'
145 0.0001 6.6995620727539E-5
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.0001 5.793571472168E-5
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 5.8889389038086E-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 5.6028366088867E-5
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
149 0.0001 5.6982040405273E-5
SELECT * FROM categorygroups WHERE id = '1'
150 0.0001 5.793571472168E-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 = 38
151 0.0001 7.9870223999023E-5
SELECT id FROM categories WHERE parent_id = '38'
152 0.0001 5.6982040405273E-5
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.0001 5.6982040405273E-5
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 5.8174133300781E-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 5.6982040405273E-5
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '38'
156 0.0001 5.6982040405273E-5
SELECT * FROM categorygroups WHERE id = '1'
157 0.0001 5.6982040405273E-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 = 48
158 0.0001 5.8174133300781E-5
SELECT id FROM categories WHERE parent_id = '48'
159 0.0001 6.6995620727539E-5
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.0001 6.1988830566406E-5
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 5.9127807617188E-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 7.5101852416992E-5
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '48'
163 0.0001 5.9843063354492E-5
SELECT * FROM categorygroups WHERE id = '1'
164 0.0001 5.6982040405273E-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 = 49
165 0.0001 7.7009201049805E-5
SELECT id FROM categories WHERE parent_id = '49'
166 0.0001 5.6982040405273E-5
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.0001 5.793571472168E-5
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 5.7220458984375E-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 5.6982040405273E-5
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '49'
170 0.0001 5.6028366088867E-5
SELECT * FROM categorygroups WHERE id = '1'
171 0.0001 5.793571472168E-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 = 55
172 0.0001 5.6982040405273E-5
SELECT id FROM categories WHERE parent_id = '55'
173 0.0001 5.6982040405273E-5
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.0001 5.793571472168E-5
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 5.6982040405273E-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 5.6982040405273E-5
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '55'
177 0.0001 5.6982040405273E-5
SELECT * FROM categorygroups WHERE id = '1'
178 0.0001 5.6982040405273E-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 = 27
179 0.0001 5.6982040405273E-5
SELECT id FROM categories WHERE parent_id = '27'
180 0.0001 7.7962875366211E-5
SELECT id FROM categories WHERE parent_id = '65'
181 0.0001 5.8174133300781E-5
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.0001 6.0081481933594E-5
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 5.793571472168E-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 5.6028366088867E-5
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
185 0.0001 5.6982040405273E-5
SELECT * FROM categorygroups WHERE id = '1'
186 0.0001 6.103515625E-5
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
187 0.0001 6.2942504882812E-5
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-fluid' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
188 0.0001 6.1988830566406E-5
SELECT value FROM parameters WHERE parameter = 'EBAY_APP_ID' 
189 0.0001 6.6995620727539E-5
SELECT value FROM parameters WHERE parameter = 'GOOGLE_SITE_KEY' 
190 0.0001 6.9141387939453E-5
SELECT value FROM parameters WHERE parameter = 'GOOGLE_SECRET_KEY' 
191 0.0001 5.9127807617188E-5
SELECT value FROM parameters WHERE parameter = 'GOOGLE_RECAPTCHA_TYPE' 
192 0.0001 0.0001218318939209
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
193 0.0002 0.00021910667419434
SELECT * FROM products WHERE pagename = 'lego-the-hobbit-hobbit-3-juego-de-construccion-79007'
194 0.0001 6.6995620727539E-5
SELECT * FROM manufacturers WHERE id = '167'
195 0.0007 0.00067019462585449
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '167'
196 0.0011 0.0010669231414795
SELECT filename FROM manufacturerimages WHERE manufacturer_id = '167' LIMIT 1
197 0.0007 0.00067687034606934
SELECT pagename, id FROM products p WHERE manufacturer_id = '167' ORDER BY RAND() LIMIT 1
198 0.0002 0.000244140625
SELECT * FROM productimages WHERE product_id = '4611' ORDER BY sortorder ASC
199 0.0001 6.1988830566406E-5
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '167'
200 0.0007 0.00068187713623047
SELECT COUNT(DISTINCT(p.id)) FROM products p
				WHERE p.manufacturer_id = '167'
				  AND p.hidden = 0
				  AND p.enabled = 1
				  AND p.parent_id = 0 
201 0.0006 0.00058984756469727
SELECT * FROM manufacturerimages WHERE manufacturer_id = '167'
202 0.0002 0.00019693374633789
SELECT category_id FROM products_categories WHERE product_id = '1896'
203 0.0004 0.00044703483581543
SELECT * FROM categories WHERE id = '26'
204 0.0001 8.1062316894531E-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 = 26
205 0.0001 7.2956085205078E-5
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
206 0.0001 7.2002410888672E-5
SELECT id FROM categories WHERE parent_id = '26'
207 0.0001 7.2002410888672E-5
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 
208 0.0001 6.1988830566406E-5
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 
209 0.0001 5.6982040405273E-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 
210 0.0001 5.6982040405273E-5
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
211 0.0001 8.5115432739258E-5
SELECT * FROM categories WHERE id = '61'
212 0.0001 5.6982040405273E-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 = 61
213 0.0001 5.793571472168E-5
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 61
214 0.0001 5.6982040405273E-5
SELECT id FROM categories WHERE parent_id = '61'
215 0.0001 5.6982040405273E-5
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 
216 0.0001 5.8174133300781E-5
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 
217 0.0001 5.6982040405273E-5
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 
218 0.0001 5.6982040405273E-5
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '61'
219 0.0002 0.00019097328186035
SELECT * FROM productimages WHERE product_id = '1896' ORDER BY sortorder ASC
220 0.0002 0.00017189979553223
SELECT * FROM product_image_select WHERE product_id = '1896'
221 0.0004 0.00036287307739258
SELECT * FROM productcustomimages WHERE product_id = '1896'
222 0.0004 0.00043702125549316
SELECT * FROM productfeeds WHERE product_id = '1896' ORDER BY item_date DESC
223 0.0006 0.00063204765319824
SELECT a.name, n.displayname, a.value, n.units, n.valuetype FROM productattributes a, productattributenames n WHERE product_id = '1896' AND a.name = n.originalname AND n.display = 1 AND n.hidden = 0
224 0.0006 0.00062203407287598
SELECT DISTINCT(pt.tag_id) FROM product_tags pt, tags t WHERE pt.tag_id = t.id AND pt.product_id = '1896' AND t.hidden = 0 AND display_product = 1
225 0.0004 0.00035405158996582
SELECT * FROM tags WHERE id = '16'
226 0.0012 0.0011541843414307
SELECT COUNT(DISTINCT(p.id)) FROM products p, product_tags t
				WHERE p.id = t.product_id
				  AND t.tag_id = '16'
				  AND p.parent_id = 0
				  AND p.enabled = 1
				  AND p.hidden = 0
227 0.0014 0.0014450550079346
SELECT COUNT(DISTINCT(p.id)) FROM products p, product_tags t
				WHERE p.id = t.product_id
				  AND t.tag_id = '16'
				  AND p.parent_id = 0
				  AND hidden = 0
				  AND enabled = 1 
228 0.0014 0.0014359951019287
SELECT p.id FROM products p, product_tags t WHERE p.id = t.product_id AND t.tag_id = '16' AND p.hidden = 0 AND p.salesrank > 0 AND (p.price > 0 OR p.parent = 1) ORDER BY p.salesrank ASC LIMIT 1
229 0.0003 0.00034403800964355
SELECT * FROM productimages WHERE product_id = '4956' ORDER BY sortorder ASC
230 0.0002 0.00024080276489258
SELECT * FROM productamazoncontent WHERE product_id = '1896'
231 0.0013 0.001331090927124
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1896' AND a.name = n.originalname
232 0.0001 0.00013995170593262
SELECT * FROM productoffers WHERE product_id = '1896' AND merchantid = ''
233 0.0001 0.00014114379882812
SELECT * FROM productoffers
                WHERE product_id = '1896' AND price > 0
                ORDER BY price ASC LIMIT 1
234 0.0001 0.00014591217041016
SELECT * FROM productoffers
                WHERE product_id = 1896
                ORDER BY price ASC LIMIT 1
235 0.0002 0.00020790100097656
SELECT value FROM productattributes
                WHERE product_id = '1896'
                AND name = 'ListPriceAmount'
236 0.0003 0.00031900405883789
UPDATE products SET price = '14630' WHERE id = '1896'
237 0.0674 0.067446947097778
SELECT *, MATCH (description, keyfeatures, title) AGAINST ('hobbit' IN BOOLEAN MODE) AS `searchrelevance` FROM products WHERE MATCH (description, keyfeatures, title) AGAINST ('hobbit' IN BOOLEAN MODE) AND 1896 <> 0 AND enabled = 1 AND hidden = 0 AND offers > 0 AND parent_id = 0 ORDER BY `searchrelevance` LIMIT 6
238 0.0004 0.00042295455932617
SELECT * FROM productimages WHERE product_id = '6070' ORDER BY sortorder ASC
239 0.0002 0.00015592575073242
SELECT * FROM product_image_select WHERE product_id = '6070'
240 0.0009 0.00090384483337402
SELECT * FROM productcustomimages WHERE product_id = '6070'
241 0.0018 0.0018019676208496
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '6070' AND a.name = n.originalname
242 0.0002 0.00021696090698242
SELECT * FROM productoffers WHERE product_id = '6070' AND merchantid = ''
243 0.0003 0.00029611587524414
SELECT value FROM productattributes WHERE product_id = '6070' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
244 0.0003 0.00031709671020508
UPDATE products SET price = '13810' WHERE id = '6070'
245 0.0675 0.067528009414673
SELECT *, MATCH (description, keyfeatures, title) AGAINST ('lego' IN BOOLEAN MODE) AS `searchrelevance` FROM products WHERE MATCH (description, keyfeatures, title) AGAINST ('lego' IN BOOLEAN MODE) AND 1896 <> 0 AND enabled = 1 AND hidden = 0 AND offers > 0 AND parent_id = 0 ORDER BY `searchrelevance` LIMIT 5
246 0.0001 0.00014781951904297
SELECT * FROM productimages WHERE product_id = '733' ORDER BY sortorder ASC
247 0.0001 0.00012612342834473
SELECT * FROM product_image_select WHERE product_id = '733'
248 0.0001 0.00011301040649414
SELECT * FROM productcustomimages WHERE product_id = '733'
249 0.0001 0.00011897087097168
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '733' AND a.name = n.originalname
250 0.0001 0.00011205673217773
SELECT * FROM productoffers WHERE product_id = '733' AND merchantid = ''
251 0.0001 0.00011301040649414
SELECT value FROM productattributes WHERE product_id = '733' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
252 0.0002 0.00019192695617676
UPDATE products SET price = '11890' WHERE id = '733'
253 0.0001 7.4863433837891E-5
SELECT * FROM productimages WHERE product_id = '866' ORDER BY sortorder ASC
254 0.0001 7.5101852416992E-5
SELECT * FROM product_image_select WHERE product_id = '866'
255 0.0001 6.1988830566406E-5
SELECT * FROM productcustomimages WHERE product_id = '866'
256 0.0016 0.0016000270843506
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '866' AND a.name = n.originalname
257 0.0002 0.00023794174194336
SELECT * FROM productoffers WHERE product_id = '866' AND merchantid = ''
258 0.0004 0.00036501884460449
SELECT value FROM productattributes WHERE product_id = '866' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
259 0.0004 0.00036716461181641
UPDATE products SET price = '4828' WHERE id = '866'
260 0.0001 0.00011515617370605
SELECT * FROM productimages WHERE product_id = '963' ORDER BY sortorder ASC
261 0.0001 9.4175338745117E-5
SELECT * FROM product_image_select WHERE product_id = '963'
262 0.0001 9.8943710327148E-5
SELECT * FROM productcustomimages WHERE product_id = '963'
263 0.0011 0.0010850429534912
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '963' AND a.name = n.originalname
264 0.0002 0.00022387504577637
SELECT * FROM productoffers WHERE product_id = '963' AND merchantid = ''
265 0.0003 0.00032496452331543
SELECT value FROM productattributes WHERE product_id = '963' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
266 0.0001 0.0001380443572998
UPDATE products SET price = '9995' WHERE id = '963'
267 0.0001 0.00010800361633301
SELECT * FROM productimages WHERE product_id = '1170' ORDER BY sortorder ASC
268 0.0001 9.3936920166016E-5
SELECT * FROM product_image_select WHERE product_id = '1170'
269 0.0001 9.6797943115234E-5
SELECT * FROM productcustomimages WHERE product_id = '1170'
270 0.0001 0.00010395050048828
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1170' AND a.name = n.originalname
271 0.0001 0.00010395050048828
SELECT * FROM productoffers WHERE product_id = '1170' AND merchantid = ''
272 0.0001 8.4877014160156E-5
SELECT value FROM productattributes WHERE product_id = '1170' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
273 0.0001 0.00014686584472656
UPDATE products SET price = '6354' WHERE id = '1170'
274 0.0001 8.702278137207E-5
SELECT * FROM productimages WHERE product_id = '1276' ORDER BY sortorder ASC
275 0.0001 7.2002410888672E-5
SELECT * FROM product_image_select WHERE product_id = '1276'
276 0.0001 7.1048736572266E-5
SELECT * FROM productcustomimages WHERE product_id = '1276'
277 0.0001 8.5115432739258E-5
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1276' AND a.name = n.originalname
278 0.0001 7.5817108154297E-5
SELECT * FROM productoffers WHERE product_id = '1276' AND merchantid = ''
279 0.0001 6.9141387939453E-5
SELECT value FROM productattributes WHERE product_id = '1276' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
280 0.0001 0.00011396408081055
UPDATE products SET price = '4500' WHERE id = '1276'
281 0.0001 6.7949295043945E-5
SELECT value FROM parameters WHERE parameter = 'EBAY_CACHE_TIME' 
282 0.0001 6.3896179199219E-5
SELECT value FROM parameters WHERE parameter = 'EBAY_APP_ID' 
283 0.0001 6.2942504882812E-5
SELECT value FROM parameters WHERE parameter = 'EBAY_TRACKING_ID' 
284 0.0001 6.3896179199219E-5
SELECT value FROM parameters WHERE parameter = 'EBAY_NETWORK_ID' 
285 0.0001 6.1988830566406E-5
SELECT value FROM parameters WHERE parameter = 'EBAY_LOCALE' 
286 0.0001 6.1988830566406E-5
SELECT value FROM parameters WHERE parameter = 'EBAY_AUTH_TOKEN' 
287 0.0001 6.2942504882812E-5
SELECT * FROM ebay_locale_details WHERE cur_code = 'USD' 
288 0.0002 0.0001678466796875
SELECT * FROM ebay_products_cache WHERE cachekey = '3681fc129397725f45d31f30ae1711dc' 
289 0.0001 5.0067901611328E-5
SELECT value FROM parameters WHERE parameter = 'EBAY_APP_ID' 
290 0.0001 5.8889389038086E-5
SELECT value FROM parameters WHERE parameter = 'EBAY_TRACKING_ID' 
291 0.0001 5.6982040405273E-5
SELECT value FROM parameters WHERE parameter = 'EBAY_NETWORK_ID' 
292 0.0001 7.2002410888672E-5
SELECT value FROM parameters WHERE parameter = 'EBAY_LOCALE' 
293 0.0001 5.8889389038086E-5
SELECT value FROM parameters WHERE parameter = 'EBAY_AUTH_TOKEN' 
294 0.0002 0.0002129077911377
SELECT * FROM ebay_products_cache WHERE cachekey = '3681fc129397725f45d31f30ae1711dc' 
295 0.0004 0.00037002563476562
SELECT id,asin FROM products WHERE parent_id = 1896
296 0.0004 0.0003669261932373
SELECT category_id FROM products_categories WHERE product_id = '1896'
297 0.0002 0.00015091896057129
SELECT * FROM categories WHERE id = '26'
298 0.0001 0.00013279914855957
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
299 0.0001 0.00013613700866699
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
300 0.0001 0.0001218318939209
SELECT id FROM categories WHERE parent_id = '26'
301 0.0001 0.00010800361633301
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 
302 0.0001 6.6995620727539E-5
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 
303 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 (26)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
304 0.0001 9.1075897216797E-5
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
305 0.0001 7.1048736572266E-5
SELECT * FROM categories WHERE id = '61'
306 0.0001 6.3896179199219E-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 = 61
307 0.0001 6.8902969360352E-5
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 61
308 0.0001 6.3896179199219E-5
SELECT id FROM categories WHERE parent_id = '61'
309 0.0001 6.3896179199219E-5
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 
310 0.0001 6.413459777832E-5
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 
311 0.0001 6.3180923461914E-5
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 
312 0.0001 6.2942504882812E-5
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '61'
313 0.0001 7.0095062255859E-5
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1896' AND a.name = n.originalname
314 0.0001 7.9154968261719E-5
SELECT * FROM productoffers WHERE product_id = '1896' AND merchantid = ''
315 0.0001 6.9141387939453E-5
SELECT * FROM productoffers
                WHERE product_id = '1896' AND price > 0
                ORDER BY price ASC LIMIT 1
316 0.0001 6.6995620727539E-5
SELECT * FROM productoffers
                WHERE product_id = 1896
                ORDER BY price ASC LIMIT 1
317 0.0001 6.1988830566406E-5
SELECT value FROM productattributes
                WHERE product_id = '1896'
                AND name = 'ListPriceAmount'
318 0.0002 0.00019311904907227
SELECT * FROM products WHERE id = '1896'
319 0.0001 0.00013279914855957
UPDATE products SET price = '14630' WHERE id = '1896'
320 0.0001 7.4148178100586E-5
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1896' AND a.name = n.originalname
321 0.0001 6.6995620727539E-5
SELECT * FROM productoffers WHERE product_id = '1896' AND merchantid = ''
322 0.0001 6.4849853515625E-5
SELECT * FROM productoffers
                WHERE product_id = '1896' AND price > 0
                ORDER BY price ASC LIMIT 1
323 0.0001 6.6995620727539E-5
SELECT * FROM productoffers
                WHERE product_id = 1896
                ORDER BY price ASC LIMIT 1
324 0.0001 6.2942504882812E-5
SELECT value FROM productattributes
                WHERE product_id = '1896'
                AND name = 'ListPriceAmount'
325 0.0001 6.5088272094727E-5
SELECT category_id FROM products_categories WHERE product_id = '1896'
326 0.0001 6.2942504882812E-5
SELECT parent_id FROM categories WHERE id = '26'
327 0.0001 6.5803527832031E-5
SELECT * FROM categories WHERE id = '26'
328 0.0001 6.2942504882812E-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 = 26
329 0.0001 6.6995620727539E-5
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
330 0.0001 6.6041946411133E-5
SELECT id FROM categories WHERE parent_id = '26'
331 0.0001 6.413459777832E-5
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 
332 0.0001 6.2942504882812E-5
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 
333 0.0001 6.2942504882812E-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 
334 0.0001 6.2942504882812E-5
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
335 0.0001 7.2956085205078E-5
SELECT * FROM template_info WHERE templateuid = 'fsb-fluid'
336 0.0001 7.1048736572266E-5
SELECT * FROM pages WHERE id = 52
337 0.0001 7.0810317993164E-5
SELECT * FROM pages WHERE id = 53
338 0.0001 6.8902969360352E-5
SELECT * FROM pages WHERE id = 54
339 0.0001 7.2002410888672E-5
SELECT * FROM pages WHERE id = 51
340 0.0001 7.0095062255859E-5
SELECT * FROM pages WHERE id = 52
341 0.0001 6.6041946411133E-5
SELECT * FROM pages WHERE id = 53
342 0.0001 6.7949295043945E-5
SELECT * FROM pages WHERE id = 54
343 0.0001 6.5803527832031E-5
SELECT * FROM pages WHERE id = 51
344 0.0001 6.8187713623047E-5
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
345 0.0003 0.00025105476379395
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:1560652212;s:8:\"products\";a:4:{i:0;s:3:\"955\";i:1;s:4:\"1934\";i:2;s:3:\"758\";i:3;s:4:\"1322\";}}' WHERE id = '207'
346 0.0001 0.00010418891906738
SELECT * FROM products WHERE id IN (955,1934,758,1322) ORDER BY FIELD(id, 955,1934,758,1322 )
347 0.0001 6.7949295043945E-5
SELECT * FROM productimages WHERE product_id = '955' ORDER BY sortorder ASC
348 0.0001 7.1048736572266E-5
SELECT * FROM product_image_select WHERE product_id = '955'
349 0.0001 6.5088272094727E-5
SELECT * FROM productcustomimages WHERE product_id = '955'
350 0.0001 7.2956085205078E-5
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '955' AND a.name = n.originalname
351 0.0001 6.6995620727539E-5
SELECT * FROM productoffers WHERE product_id = '955' AND merchantid = ''
352 0.0001 6.4849853515625E-5
SELECT value FROM productattributes WHERE product_id = '955' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
353 0.0001 0.00011706352233887
UPDATE products SET price = '7426' WHERE id = '955'
354 0.0001 6.7949295043945E-5
SELECT * FROM productimages WHERE product_id = '1934' ORDER BY sortorder ASC
355 0.0001 7.1048736572266E-5
SELECT * FROM product_image_select WHERE product_id = '1934'
356 0.0001 6.6041946411133E-5
SELECT * FROM productcustomimages WHERE product_id = '1934'
357 0.0001 7.0095062255859E-5
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1934' AND a.name = n.originalname
358 0.0001 6.7949295043945E-5
SELECT * FROM productoffers WHERE product_id = '1934' AND merchantid = ''
359 0.0001 6.6995620727539E-5
SELECT value FROM productattributes WHERE product_id = '1934' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
360 0.0001 0.00011301040649414
UPDATE products SET price = '15048' WHERE id = '1934'
361 0.0001 7.1048736572266E-5
SELECT * FROM productimages WHERE product_id = '758' ORDER BY sortorder ASC
362 0.0001 6.6041946411133E-5
SELECT * FROM product_image_select WHERE product_id = '758'
363 0.0001 6.2942504882812E-5
SELECT * FROM productcustomimages WHERE product_id = '758'
364 0.0001 7.2956085205078E-5
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '758' AND a.name = n.originalname
365 0.0001 6.6995620727539E-5
SELECT * FROM productoffers WHERE product_id = '758' AND merchantid = ''
366 0.0001 6.5088272094727E-5
SELECT value FROM productattributes WHERE product_id = '758' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
367 0.0001 0.00010991096496582
UPDATE products SET price = '3921' WHERE id = '758'
368 0.0001 6.8902969360352E-5
SELECT * FROM productimages WHERE product_id = '1322' ORDER BY sortorder ASC
369 0.0001 6.9141387939453E-5
SELECT * FROM product_image_select WHERE product_id = '1322'
370 0.0001 6.8902969360352E-5
SELECT * FROM productcustomimages WHERE product_id = '1322'
371 0.0001 6.9856643676758E-5
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1322' AND a.name = n.originalname
372 0.0001 6.6995620727539E-5
SELECT * FROM productoffers WHERE product_id = '1322' AND merchantid = ''
373 0.0001 6.6041946411133E-5
SELECT value FROM productattributes WHERE product_id = '1322' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
374 0.0001 0.00011706352233887
UPDATE products SET price = '10808' WHERE id = '1322'
375 0.0001 7.1048736572266E-5
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid' AND area = 'header' ORDER BY sortorder ASC
376 0.0001 6.1988830566406E-5
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
377 0.0001 6.103515625E-5
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
378 0.0001 5.9843063354492E-5
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
379 0.0001 6.103515625E-5
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
380 0.0001 6.8902969360352E-5
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid' AND area = 'footer' ORDER BY sortorder ASC
381 0.0001 0.00010204315185547
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
382 0.0001 6.1988830566406E-5
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
383 0.0001 6.1988830566406E-5
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
384 0.0001 8.5830688476562E-5
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-fluid' AND skinuid = ''
385 0.0001 7.8916549682617E-5
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid'
386 0.0001 7.4863433837891E-5
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid'
387 0.0001 0.00013899803161621
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid' AND imageuid = 'HEAD_LOGO'
388 0.0001 6.9856643676758E-5
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-fluid' AND textuid = '' AND language = 'en'
389 0.0001 7.2002410888672E-5
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid' AND imageuid = 'HEAD_LOGO'