Pokémon Let's Go, Pikachu! & Pokémon Let's Go, Eevee!: Official Trainer's Guide & Pokédex - Official European English Version de MUM4J|#Multiplayer Edizioni

Precio: 21,99€
Los precios de los productos y la disponibilidad son correctos a fecha 2019-06-15 13:25:28 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

En Juguetepia.com estamos contentos de ofrecerte el fantástico Pokémon Let's Go, Pikachu! & Pokémon Let's Go, Eevee!: Official Trainer's Guide & Pokédex - Official European English Version.

Con tanta oferta en el mercado, es útil tener un fabricante en el que se puede confiar. Pokémon Let's Go, Pikachu! & Pokémon Let's Go, Eevee!: Official Trainer's Guide & Pokédex - Official European English Version será sin duda una buena compra.

Con esta oferta, el Pokémon Let's Go, Pikachu! & Pokémon Let's Go, Eevee!: Official Trainer's Guide & Pokédex - Official European English Version está ampliamente recomendado y es una de las elecciones más populares entre nuestros clientes. MUM4J|#Multiplayer Edizioni ha introducido algunas magníficas ideas, lo que hace que tenga una muy buena relación calidad/precio.

Descripción del Fabricante

The official Trainer s guide from Pokmon for the Pokmon: Let s Go, Pikachu! and Pokmon: Let s Go, Eevee! video games. Get the tips you need for each part of your journey with the step-by-step walkthrough and hints in the Pokmon: Let s Go, Pikachu! & Pokmon: Let s Go, Eevee! Official Trainer s Guide & Pokdex. From your first experiences as a Trainer and all through your adventure, this guide will help you every step of the way!

Debug Overview

App Total Time DB Queries DB Query Total Time Amazon Requests
0.85685396194458 380 0.1902 0


No Amazon API Requests Made.


App Debug - Total Time 0.85685396194458 seconds

Number Time From Start Name Description
1 0.31859612464905 Initialise Initialise FSB Function
2 0.32122611999512 App Controller Start Start of the App controller (called before the controller of every page)
3 0.32253503799438 Start of getCategoryListByGroup Function Before first category groups query
4 0.32258296012878 After initial query Before first category groups query
5 0.3225839138031 Get Category List for Group Before the call to getCategoryList function
6 0.32258605957031 Start of GetCategoryList function Start of the function
7 0.32258796691895 Before getting categories Query to get specific category list
8 0.32267594337463 After getting categories Query to get specific category list
9 0.32267713546753 Before getting category custom Before call to function getCategoryCustom
10 0.32295513153076 After getting category custom After call to function getCategoryCustom
11 0.32295608520508 Before getting category custom Before call to function getCategoryCustom
12 0.32320809364319 After getting category custom After call to function getCategoryCustom
13 0.3232090473175 Before getting category custom Before call to function getCategoryCustom
14 0.32346391677856 After getting category custom After call to function getCategoryCustom
15 0.32346510887146 Before getting category custom Before call to function getCategoryCustom
16 0.32372093200684 After getting category custom After call to function getCategoryCustom
17 0.32372212409973 Before getting category custom Before call to function getCategoryCustom
18 0.32396197319031 After getting category custom After call to function getCategoryCustom
19 0.32396292686462 Before getting category custom Before call to function getCategoryCustom
20 0.32420206069946 After getting category custom After call to function getCategoryCustom
21 0.32420301437378 Before getting category custom Before call to function getCategoryCustom
22 0.32444405555725 After getting category custom After call to function getCategoryCustom
23 0.32444500923157 Before getting category custom Before call to function getCategoryCustom
24 0.32468891143799 After getting category custom After call to function getCategoryCustom
25 0.32468891143799 Before getting category custom Before call to function getCategoryCustom
26 0.3249340057373 After getting category custom After call to function getCategoryCustom
27 0.32493495941162 End of GetCategoryList function End of the function
28 0.32493805885315 Get Category List for Group Before the call to getCategoryList function
29 0.32493996620178 Start of GetCategoryList function Start of the function
30 0.3249409198761 Before getting categories Query to get specific category list
31 0.32501792907715 After getting categories Query to get specific category list
32 0.32501912117004 Before getting category custom Before call to function getCategoryCustom
33 0.32561707496643 After getting category custom After call to function getCategoryCustom
34 0.32561802864075 Before getting category custom Before call to function getCategoryCustom
35 0.32586312294006 After getting category custom After call to function getCategoryCustom
36 0.32586407661438 Before getting category custom Before call to function getCategoryCustom
37 0.32610201835632 After getting category custom After call to function getCategoryCustom
38 0.32610297203064 Before getting category custom Before call to function getCategoryCustom
39 0.32634305953979 After getting category custom After call to function getCategoryCustom
40 0.32634401321411 Before getting category custom Before call to function getCategoryCustom
41 0.32676696777344 After getting category custom After call to function getCategoryCustom
42 0.32676792144775 Before getting category custom Before call to function getCategoryCustom
43 0.3270149230957 After getting category custom After call to function getCategoryCustom
44 0.3270161151886 Before getting category custom Before call to function getCategoryCustom
45 0.32729697227478 After getting category custom After call to function getCategoryCustom
46 0.3272979259491 Before getting category custom Before call to function getCategoryCustom
47 0.32754397392273 After getting category custom After call to function getCategoryCustom
48 0.32754492759705 Before getting category custom Before call to function getCategoryCustom
49 0.32777810096741 After getting category custom After call to function getCategoryCustom
50 0.32777810096741 Before getting category custom Before call to function getCategoryCustom
51 0.32801103591919 After getting category custom After call to function getCategoryCustom
52 0.32801198959351 Before getting category custom Before call to function getCategoryCustom
53 0.32828593254089 After getting category custom After call to function getCategoryCustom
54 0.32828712463379 Before getting category custom Before call to function getCategoryCustom
55 0.32851791381836 After getting category custom After call to function getCategoryCustom
56 0.32851910591125 Before getting category custom Before call to function getCategoryCustom
57 0.32880806922913 After getting category custom After call to function getCategoryCustom
58 0.32880902290344 End of GetCategoryList function End of the function
59 0.32881307601929 End of getCategoryListByGroup Function Before return()
60 0.32938408851624 App Controller End End of the App controller (called before the controller of every page)
61 0.329430103302 Product Start Start of the product info controller
62 0.32999205589294 Cache file not found Starting get product details
63 0.34172105789185 Related products Start getting related products if enabled
64 0.34172201156616 Related Products Start Before the related products are found
65 0.34172201156616 Related Products Keywords Before the related product keywords are found
66 0.34172797203064 Create Keyword List Function Start of function
67 0.34209108352661 Create Keyword List Function After looping provided content - 407 keywords found
68 0.35384011268616 Create Keyword List Function After looping initial keyword list - 368 keywords remaining
69 0.35388207435608 Create Keyword List Function After reducing keyword list
70 0.35425901412964 Create Keyword List Function After selecting by scoring keywords
71 0.35426211357117 Create Keyword List Function After final loop of keywords
72 0.3542640209198 Related Products Keywords After the related product keywords are found
73 0.51357507705688 Related Products End After the related products are found
74 0.51539897918701 Start Remote Request http://svcs.ebay.com/services/search/FindingServic...
75 0.8353910446167 End Remote Request http://svcs.ebay.com/services/search/FindingServic...
76 0.84032511711121 Product End End of the product info controller (Product Info)
77 0.84051394462585 App_after Controller Start Start of the App_after controller (called after the controller of every page)
78 0.84055995941162 Before Get Options Before the call to getOptions in the tpl class
79 0.84602308273315 After Get Options After the call to getOptions in the tpl class
80 0.84612798690796 App_after Controller End End of the App_after controller (called after the controller of every page)
81 0.84613490104675 Product Info: Before Smarty Fetch Before the product.tpl template is fetched
82 0.84985709190369 Product Info: After Smarty Fetch After the product.tpl template is fetched
83 0.84986090660095 Product Info: Before Template Display Before the template is displayed
84 0.85683512687683 Product Info: After Template Display After the template is displayed
85 0.85683798789978 Finalizing debug Before the debug is output to the page.
86 0.85685396194458 End of App This is the end of the app logging, final timestamp


Query Debug - 380 Database Queries. Total time 0.1902 seconds

Number Time (Seconds) Time (Milliseconds) Query
1 0.0001 7.1048736572266E-5
SELECT value FROM parameters WHERE `parameter` = 'BAD_BOTS_ENABLER'
2 0.0004 0.00041389465332031
SHOW TABLES LIKE 'bad_bots'
3 0.0000 4.0054321289062E-5
SELECT value FROM parameters WHERE `parameter` = 'STORE_WHITELISTED_IPS'
4 0.0000 3.504753112793E-5
SELECT * FROM `bad_bots`
5 0.0001 9.9897384643555E-5
SELECT parameter, value FROM parameters
6 0.0001 0.00013113021850586
SET time_zone = 'Europe/London'
7 0.0008 0.00080990791320801
SELECT * FROM autorun ORDER BY lastrun ASC
8 0.0000 3.6001205444336E-5
SELECT * FROM version ORDER BY installed DESC LIMIT 1
9 0.0021 0.0021212100982666
SELECT id FROM pages WHERE pagename = 'pokemon-lets-go-pikachu-pokemon-lets-go-eevee-official-trainers-guide-pokedex-official-european-english-version' LIMIT 1
10 0.0004 0.00035810470581055
SELECT id FROM products WHERE pagename = 'pokemon-lets-go-pikachu-pokemon-lets-go-eevee-official-trainers-guide-pokedex-official-european-english-version' AND hidden = 0 LIMIT 1
11 0.0004 0.00041580200195312
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-fluid'
12 0.0001 0.0001220703125
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-fluid' AND language = 'es'
13 0.0003 0.00025820732116699
SELECT * FROM pages WHERE pagename = 'pokemon-lets-go-pikachu-pokemon-lets-go-eevee-official-trainers-guide-pokedex-official-european-english-version'
14 0.0000 3.9100646972656E-5
SELECT * FROM categorygroups ORDER BY sortorder ASC
15 0.0001 6.5088272094727E-5
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '2'  AND hidden = 0 ORDER BY sortorder ASC
16 0.0000 3.1948089599609E-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.0000 3.6954879760742E-5
SELECT id FROM categories WHERE parent_id = '70'
18 0.0000 2.7894973754883E-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.0000 3.0994415283203E-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.0000 3.6954879760742E-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.0000 2.598762512207E-5
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '70'
22 0.0000 2.8133392333984E-5
SELECT * FROM categorygroups WHERE id = '2'
23 0.0000 2.6941299438477E-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.0000 2.8133392333984E-5
SELECT id FROM categories WHERE parent_id = '66'
25 0.0000 2.7894973754883E-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.0000 2.8133392333984E-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.0000 2.8133392333984E-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.0000 2.598762512207E-5
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '66'
29 0.0000 3.0040740966797E-5
SELECT * FROM categorygroups WHERE id = '2'
30 0.0000 2.9087066650391E-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.0000 3.0994415283203E-5
SELECT id FROM categories WHERE parent_id = '67'
32 0.0000 2.8133392333984E-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.0000 3.0994415283203E-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.0000 2.7179718017578E-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.0000 2.6941299438477E-5
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '67'
36 0.0000 2.6941299438477E-5
SELECT * FROM categorygroups WHERE id = '2'
37 0.0000 4.1961669921875E-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.0000 2.8133392333984E-5
SELECT id FROM categories WHERE parent_id = '56'
39 0.0000 2.7894973754883E-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.0000 2.7894973754883E-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.0000 2.8133392333984E-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.0000 2.6941299438477E-5
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '56'
43 0.0000 2.7894973754883E-5
SELECT * FROM categorygroups WHERE id = '2'
44 0.0000 2.7894973754883E-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.0000 2.598762512207E-5
SELECT id FROM categories WHERE parent_id = '59'
46 0.0000 2.7894973754883E-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.0000 2.7179718017578E-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.0000 3.0040740966797E-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.0000 2.6941299438477E-5
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '59'
50 0.0000 2.7894973754883E-5
SELECT * FROM categorygroups WHERE id = '2'
51 0.0000 2.7894973754883E-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.0000 2.7179718017578E-5
SELECT id FROM categories WHERE parent_id = '61'
53 0.0000 2.7894973754883E-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.0000 2.9087066650391E-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.0000 2.6941299438477E-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.0000 2.6941299438477E-5
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '61'
57 0.0000 2.8133392333984E-5
SELECT * FROM categorygroups WHERE id = '2'
58 0.0000 2.8133392333984E-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.0000 2.6941299438477E-5
SELECT id FROM categories WHERE parent_id = '62'
60 0.0000 2.7179718017578E-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.0000 2.6941299438477E-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.0000 2.8133392333984E-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.0000 2.6941299438477E-5
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '62'
64 0.0000 3.0994415283203E-5
SELECT * FROM categorygroups WHERE id = '2'
65 0.0000 2.8133392333984E-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.0000 2.6941299438477E-5
SELECT id FROM categories WHERE parent_id = '68'
67 0.0000 2.8133392333984E-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.0000 3.0040740966797E-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.0000 2.8133392333984E-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.0000 2.6941299438477E-5
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '68'
71 0.0000 2.7894973754883E-5
SELECT * FROM categorygroups WHERE id = '2'
72 0.0000 2.7894973754883E-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.0000 2.7179718017578E-5
SELECT id FROM categories WHERE parent_id = '69'
74 0.0000 2.7894973754883E-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.0000 3.1948089599609E-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.0000 2.7894973754883E-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.0000 2.8133392333984E-5
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '69'
78 0.0000 2.8133392333984E-5
SELECT * FROM categorygroups WHERE id = '2'
79 0.0000 4.2915344238281E-5
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
80 0.0000 3.1948089599609E-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.0000 3.0040740966797E-5
SELECT id FROM categories WHERE parent_id = '29'
82 0.0000 2.9802322387695E-5
SELECT id FROM categories WHERE parent_id = '30'
83 0.0000 2.6941299438477E-5
SELECT id FROM categories WHERE parent_id = '31'
84 0.0000 2.6941299438477E-5
SELECT id FROM categories WHERE parent_id = '32'
85 0.0000 2.6941299438477E-5
SELECT id FROM categories WHERE parent_id = '33'
86 0.0000 2.7179718017578E-5
SELECT id FROM categories WHERE parent_id = '34'
87 0.0000 2.6941299438477E-5
SELECT id FROM categories WHERE parent_id = '35'
88 0.0000 3.0994415283203E-5
SELECT id FROM categories WHERE parent_id = '39'
89 0.0000 2.6941299438477E-5
SELECT id FROM categories WHERE parent_id = '41'
90 0.0000 2.6941299438477E-5
SELECT id FROM categories WHERE parent_id = '36'
91 0.0000 2.7179718017578E-5
SELECT id FROM categories WHERE parent_id = '37'
92 0.0000 2.7894973754883E-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.0000 2.6941299438477E-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.0000 2.6941299438477E-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.0000 3.0040740966797E-5
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
96 0.0000 2.7894973754883E-5
SELECT * FROM categorygroups WHERE id = '1'
97 0.0000 2.8133392333984E-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.0000 2.598762512207E-5
SELECT id FROM categories WHERE parent_id = '52'
99 0.0000 2.7179718017578E-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.0000 3.0994415283203E-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.0000 2.9087066650391E-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.0000 2.8133392333984E-5
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '52'
103 0.0000 2.6941299438477E-5
SELECT * FROM categorygroups WHERE id = '1'
104 0.0000 2.9087066650391E-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.0000 2.6941299438477E-5
SELECT id FROM categories WHERE parent_id = '51'
106 0.0000 2.7179718017578E-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.0000 2.6941299438477E-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.0000 2.6941299438477E-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.0000 2.6941299438477E-5
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '51'
110 0.0000 2.7179718017578E-5
SELECT * FROM categorygroups WHERE id = '1'
111 0.0000 3.0040740966797E-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.0000 2.6941299438477E-5
SELECT id FROM categories WHERE parent_id = '28'
113 0.0000 2.6941299438477E-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.0000 2.8133392333984E-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.0000 2.6941299438477E-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.0000 2.6941299438477E-5
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
117 0.0000 2.8133392333984E-5
SELECT * FROM categorygroups WHERE id = '1'
118 0.0000 3.6954879760742E-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.0000 2.8133392333984E-5
SELECT id FROM categories WHERE parent_id = '43'
120 0.0001 6.103515625E-5
SELECT id FROM categories WHERE parent_id = '44'
121 0.0000 2.6941299438477E-5
SELECT id FROM categories WHERE parent_id = '45'
122 0.0000 2.4795532226562E-5
SELECT id FROM categories WHERE parent_id = '46'
123 0.0000 2.598762512207E-5
SELECT id FROM categories WHERE parent_id = '47'
124 0.0000 2.6941299438477E-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.0000 2.8133392333984E-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.0000 2.6941299438477E-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.0000 2.598762512207E-5
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '43'
128 0.0000 2.598762512207E-5
SELECT * FROM categorygroups WHERE id = '1'
129 0.0000 2.7894973754883E-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.0000 2.9087066650391E-5
SELECT id FROM categories WHERE parent_id = '50'
131 0.0000 2.598762512207E-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.0000 3.0040740966797E-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.0000 2.8133392333984E-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.0000 2.598762512207E-5
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '50'
135 0.0000 2.9087066650391E-5
SELECT * FROM categorygroups WHERE id = '1'
136 0.0000 4.6014785766602E-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.0000 3.504753112793E-5
SELECT id FROM categories WHERE parent_id = '54'
138 0.0000 2.6941299438477E-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.0000 3.0994415283203E-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.0000 2.6941299438477E-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.0000 2.598762512207E-5
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '54'
142 0.0000 2.6941299438477E-5
SELECT * FROM categorygroups WHERE id = '1'
143 0.0000 2.6941299438477E-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.0000 2.598762512207E-5
SELECT id FROM categories WHERE parent_id = '26'
145 0.0000 2.7179718017578E-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.0000 2.6941299438477E-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.0000 2.6941299438477E-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.0000 3.7193298339844E-5
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
149 0.0000 2.9087066650391E-5
SELECT * FROM categorygroups WHERE id = '1'
150 0.0000 2.6941299438477E-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.0000 2.6941299438477E-5
SELECT id FROM categories WHERE parent_id = '38'
152 0.0000 2.598762512207E-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.0000 2.6941299438477E-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.0000 2.6941299438477E-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.0000 2.598762512207E-5
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '38'
156 0.0000 2.6941299438477E-5
SELECT * FROM categorygroups WHERE id = '1'
157 0.0000 2.6941299438477E-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.0000 2.7179718017578E-5
SELECT id FROM categories WHERE parent_id = '48'
159 0.0000 2.598762512207E-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.0000 2.6941299438477E-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.0000 2.8133392333984E-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.0000 2.598762512207E-5
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '48'
163 0.0000 2.6941299438477E-5
SELECT * FROM categorygroups WHERE id = '1'
164 0.0000 3.6001205444336E-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 5.4836273193359E-5
SELECT id FROM categories WHERE parent_id = '49'
166 0.0000 2.6941299438477E-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.0000 2.7894973754883E-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.0000 2.598762512207E-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.0000 2.598762512207E-5
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '49'
170 0.0000 2.598762512207E-5
SELECT * FROM categorygroups WHERE id = '1'
171 0.0000 2.6941299438477E-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.0000 2.598762512207E-5
SELECT id FROM categories WHERE parent_id = '55'
173 0.0000 2.598762512207E-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.0000 2.6941299438477E-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.0000 2.598762512207E-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.0000 2.598762512207E-5
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '55'
177 0.0000 2.6941299438477E-5
SELECT * FROM categorygroups WHERE id = '1'
178 0.0000 2.7894973754883E-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.0000 2.7894973754883E-5
SELECT id FROM categories WHERE parent_id = '27'
180 0.0000 2.9087066650391E-5
SELECT id FROM categories WHERE parent_id = '65'
181 0.0000 2.6941299438477E-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.0000 2.6941299438477E-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.0000 2.6941299438477E-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.0000 2.9087066650391E-5
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
185 0.0000 2.7179718017578E-5
SELECT * FROM categorygroups WHERE id = '1'
186 0.0000 3.0994415283203E-5
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
187 0.0000 3.1948089599609E-5
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-fluid' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
188 0.0000 3.2901763916016E-5
SELECT value FROM parameters WHERE parameter = 'EBAY_APP_ID' 
189 0.0000 4.8160552978516E-5
SELECT value FROM parameters WHERE parameter = 'GOOGLE_SITE_KEY' 
190 0.0000 2.6941299438477E-5
SELECT value FROM parameters WHERE parameter = 'GOOGLE_SECRET_KEY' 
191 0.0000 2.598762512207E-5
SELECT value FROM parameters WHERE parameter = 'GOOGLE_RECAPTCHA_TYPE' 
192 0.0001 6.6041946411133E-5
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
193 0.0004 0.0003511905670166
SELECT * FROM products WHERE pagename = 'pokemon-lets-go-pikachu-pokemon-lets-go-eevee-official-trainers-guide-pokedex-official-european-english-version'
194 0.0006 0.00063204765319824
SELECT * FROM manufacturers WHERE id = '2240'
195 0.0016 0.0015928745269775
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '2240'
196 0.0003 0.00029611587524414
SELECT filename FROM manufacturerimages WHERE manufacturer_id = '2240' LIMIT 1
197 0.0002 0.00023508071899414
SELECT pagename, id FROM products p WHERE manufacturer_id = '2240' ORDER BY RAND() LIMIT 1
198 0.0003 0.00029993057250977
SELECT * FROM productimages WHERE product_id = '22985' ORDER BY sortorder ASC
199 0.0001 0.00010395050048828
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '2240'
200 0.0003 0.0002589225769043
SELECT COUNT(DISTINCT(p.id)) FROM products p
				WHERE p.manufacturer_id = '2240'
				  AND p.hidden = 0
				  AND p.enabled = 1
				  AND p.parent_id = 0 
201 0.0002 0.00017213821411133
SELECT * FROM manufacturerimages WHERE manufacturer_id = '2240'
202 0.0001 0.00014090538024902
SELECT category_id FROM products_categories WHERE product_id = '22985'
203 0.0003 0.00033903121948242
SELECT * FROM categories WHERE id = '68'
204 0.0001 9.2983245849609E-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
205 0.0001 8.9883804321289E-5
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 68
206 0.0001 9.7990036010742E-5
SELECT id FROM categories WHERE parent_id = '68'
207 0.0001 6.103515625E-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 
208 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 (68)
				  AND p.disabled = 0 
209 0.0001 6.103515625E-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 
210 0.0001 5.8889389038086E-5
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '68'
211 0.0001 6.2942504882812E-5
SELECT * FROM productimages WHERE product_id = '22985' ORDER BY sortorder ASC
212 0.0002 0.0001981258392334
SELECT * FROM product_image_select WHERE product_id = '22985'
213 0.0013 0.0012581348419189
SELECT * FROM productcustomimages WHERE product_id = '22985'
214 0.0002 0.00023603439331055
SELECT * FROM productfeeds WHERE product_id = '22985' ORDER BY item_date DESC
215 0.0003 0.00029206275939941
SELECT a.name, n.displayname, a.value, n.units, n.valuetype FROM productattributes a, productattributenames n WHERE product_id = '22985' AND a.name = n.originalname AND n.display = 1 AND n.hidden = 0
216 0.0004 0.00036811828613281
SELECT DISTINCT(pt.tag_id) FROM product_tags pt, tags t WHERE pt.tag_id = t.id AND pt.product_id = '22985' AND t.hidden = 0 AND display_product = 1
217 0.0002 0.00019693374633789
SELECT * FROM productamazoncontent WHERE product_id = '22985'
218 0.0016 0.0016419887542725
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '22985' AND a.name = n.originalname
219 0.0002 0.00018596649169922
SELECT * FROM productoffers WHERE product_id = '22985' AND merchantid = ''
220 0.0014 0.0013551712036133
SELECT * FROM productoffers
                WHERE product_id = '22985' AND price > 0
                ORDER BY price ASC LIMIT 1
221 0.0003 0.00027799606323242
SELECT * FROM productoffers
                WHERE product_id = 22985
                ORDER BY price ASC LIMIT 1
222 0.0004 0.00038003921508789
SELECT value FROM productattributes
                WHERE product_id = '22985'
                AND name = 'ListPriceAmount'
223 0.0001 0.00013208389282227
UPDATE products SET price = '2199' WHERE id = '22985'
224 0.0680 0.067965984344482
SELECT *, MATCH (description, keyfeatures, title) AGAINST ('official' IN BOOLEAN MODE) AS `searchrelevance` FROM products WHERE MATCH (description, keyfeatures, title) AGAINST ('official' IN BOOLEAN MODE) AND 22985 <> 0 AND enabled = 1 AND hidden = 0 AND offers > 0 AND parent_id = 0 ORDER BY `searchrelevance` LIMIT 6
225 0.0001 0.00010895729064941
SELECT * FROM productimages WHERE product_id = '23173' ORDER BY sortorder ASC
226 0.0001 9.4175338745117E-5
SELECT * FROM product_image_select WHERE product_id = '23173'
227 0.0001 9.2029571533203E-5
SELECT * FROM productcustomimages WHERE product_id = '23173'
228 0.0015 0.0014801025390625
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '23173' AND a.name = n.originalname
229 0.0007 0.00074481964111328
SELECT * FROM productoffers WHERE product_id = '23173' AND merchantid = ''
230 0.0003 0.00030303001403809
SELECT value FROM productattributes WHERE product_id = '23173' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
231 0.0002 0.00015902519226074
UPDATE products SET price = '2504' WHERE id = '23173'
232 0.0001 9.3936920166016E-5
SELECT * FROM productimages WHERE product_id = '22223' ORDER BY sortorder ASC
233 0.0001 9.2983245849609E-5
SELECT * FROM product_image_select WHERE product_id = '22223'
234 0.0001 9.2983245849609E-5
SELECT * FROM productcustomimages WHERE product_id = '22223'
235 0.0017 0.0017461776733398
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '22223' AND a.name = n.originalname
236 0.0011 0.0010528564453125
SELECT * FROM productoffers WHERE product_id = '22223' AND merchantid = ''
237 0.0003 0.00026082992553711
SELECT value FROM productattributes WHERE product_id = '22223' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
238 0.0002 0.00018596649169922
UPDATE products SET price = '1919' WHERE id = '22223'
239 0.0001 9.8943710327148E-5
SELECT * FROM productimages WHERE product_id = '22445' ORDER BY sortorder ASC
240 0.0001 9.3936920166016E-5
SELECT * FROM product_image_select WHERE product_id = '22445'
241 0.0001 9.2029571533203E-5
SELECT * FROM productcustomimages WHERE product_id = '22445'
242 0.0001 9.9897384643555E-5
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '22445' AND a.name = n.originalname
243 0.0002 0.00019598007202148
SELECT * FROM productoffers WHERE product_id = '22445' AND merchantid = ''
244 0.0008 0.00081801414489746
SELECT value FROM productattributes WHERE product_id = '22445' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
245 0.0001 0.00014615058898926
UPDATE products SET price = '2150' WHERE id = '22445'
246 0.0001 9.2983245849609E-5
SELECT * FROM productimages WHERE product_id = '23600' ORDER BY sortorder ASC
247 0.0001 9.5129013061523E-5
SELECT * FROM product_image_select WHERE product_id = '23600'
248 0.0001 0.00012803077697754
SELECT * FROM productcustomimages WHERE product_id = '23600'
249 0.0022 0.0021650791168213
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '23600' AND a.name = n.originalname
250 0.0003 0.00026893615722656
SELECT * FROM productoffers WHERE product_id = '23600' AND merchantid = ''
251 0.0005 0.00049495697021484
SELECT value FROM productattributes WHERE product_id = '23600' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
252 0.0006 0.00061202049255371
UPDATE products SET price = '3866' WHERE id = '23600'
253 0.0001 9.3936920166016E-5
SELECT * FROM productimages WHERE product_id = '29097' ORDER BY sortorder ASC
254 0.0006 0.00058293342590332
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '29097' AND p.id = pi.product_id ORDER BY pi.sortorder
255 0.0001 8.7976455688477E-5
SELECT * FROM product_image_select WHERE product_id = '29097'
256 0.0001 9.3936920166016E-5
SELECT * FROM productcustomimages WHERE product_id = '29097'
257 0.0003 0.00032305717468262
SELECT  o.product_id, MIN(o.price) as price, p.customprice
                FROM    products        p,
                        productoffers   o
                WHERE   p.id        = o.product_id
                  AND   p.parent_id = '29097'
                GROUP BY o.product_id
258 0.0014 0.0014419555664062
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     = '29097'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
259 0.0004 0.00037288665771484
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 29097
260 0.0001 0.00011491775512695
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '29097' AND a.name = n.originalname
261 0.0003 0.00026607513427734
SELECT * FROM productoffers WHERE product_id = '29097' AND merchantid = ''
262 0.0002 0.00018596649169922
SELECT * FROM productoffers
                WHERE product_id = '29097' AND price > 0
                ORDER BY price ASC LIMIT 1
263 0.0011 0.0011270046234131
SELECT * FROM productoffers
                WHERE product_id = 29097
                ORDER BY price ASC LIMIT 1
264 0.0001 8.7976455688477E-5
SELECT value FROM productattributes
                WHERE product_id = '29097'
                AND name = 'ListPriceAmount'
265 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 = '29097'
                GROUP BY o.product_id
266 0.0001 9.5844268798828E-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     = '29097'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
267 0.0001 9.4890594482422E-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 = 29097
268 0.0004 0.00038313865661621
SELECT value FROM productattributes WHERE product_id = '29097' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
269 0.0002 0.00015115737915039
UPDATE products SET price = '1990' WHERE id = '29097'
270 0.0004 0.00044107437133789
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '29097'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Size'
                GROUP BY o.value
                ORDER BY o.value ASC
271 0.0004 0.00037288665771484
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '29097'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Color'
                GROUP BY o.value
                ORDER BY o.value ASC
272 0.0710 0.070962905883789
SELECT *, MATCH (description, keyfeatures, title) AGAINST ('pokémon lets go' IN BOOLEAN MODE) AS `searchrelevance` FROM products WHERE MATCH (description, keyfeatures, title) AGAINST ('pokémon lets go' IN BOOLEAN MODE) AND 22985 <> 0 AND enabled = 1 AND hidden = 0 AND offers > 0 AND parent_id = 0 ORDER BY `searchrelevance` LIMIT 1
273 0.0001 0.00011992454528809
SELECT * FROM productimages WHERE product_id = '17952' ORDER BY sortorder ASC
274 0.0001 9.7036361694336E-5
SELECT * FROM product_image_select WHERE product_id = '17952'
275 0.0001 9.7990036010742E-5
SELECT * FROM productcustomimages WHERE product_id = '17952'
276 0.0001 0.00010180473327637
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '17952' AND a.name = n.originalname
277 0.0001 0.00010204315185547
SELECT * FROM productoffers WHERE product_id = '17952' AND merchantid = ''
278 0.0001 9.608268737793E-5
SELECT value FROM productattributes WHERE product_id = '17952' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
279 0.0002 0.00020194053649902
UPDATE products SET price = '3499' WHERE id = '17952'
280 0.0001 8.7976455688477E-5
SELECT value FROM parameters WHERE parameter = 'EBAY_CACHE_TIME' 
281 0.0001 8.4877014160156E-5
SELECT value FROM parameters WHERE parameter = 'EBAY_APP_ID' 
282 0.0001 8.3208084106445E-5
SELECT value FROM parameters WHERE parameter = 'EBAY_TRACKING_ID' 
283 0.0001 9.3221664428711E-5
SELECT value FROM parameters WHERE parameter = 'EBAY_NETWORK_ID' 
284 0.0001 9.2029571533203E-5
SELECT value FROM parameters WHERE parameter = 'EBAY_LOCALE' 
285 0.0001 8.2969665527344E-5
SELECT value FROM parameters WHERE parameter = 'EBAY_AUTH_TOKEN' 
286 0.0001 8.392333984375E-5
SELECT * FROM ebay_locale_details WHERE cur_code = 'USD' 
287 0.0002 0.00023484230041504
SELECT * FROM ebay_products_cache WHERE cachekey = 'c20f3dd27f7f698f6318bf69d69de338' 
288 0.0004 0.00040912628173828
SELECT value FROM parameters WHERE parameter = 'EBAY_APP_ID' 
289 0.0001 9.2029571533203E-5
SELECT value FROM parameters WHERE parameter = 'EBAY_TRACKING_ID' 
290 0.0001 7.4863433837891E-5
SELECT value FROM parameters WHERE parameter = 'EBAY_NETWORK_ID' 
291 0.0001 7.2956085205078E-5
SELECT value FROM parameters WHERE parameter = 'EBAY_LOCALE' 
292 0.0001 7.2956085205078E-5
SELECT value FROM parameters WHERE parameter = 'EBAY_AUTH_TOKEN' 
293 0.0001 0.0001368522644043
SELECT * FROM ebay_products_cache WHERE cachekey = 'c20f3dd27f7f698f6318bf69d69de338' 
294 0.0003 0.00026297569274902
SELECT id,asin FROM products WHERE parent_id = 22985
295 0.0014 0.0013689994812012
SELECT category_id FROM products_categories WHERE product_id = '22985'
296 0.0001 9.2029571533203E-5
SELECT * FROM categories WHERE id = '68'
297 0.0001 7.9870223999023E-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
298 0.0001 7.9870223999023E-5
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 68
299 0.0001 7.8916549682617E-5
SELECT id FROM categories WHERE parent_id = '68'
300 0.0001 7.6770782470703E-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 
301 0.0001 8.0108642578125E-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 
302 0.0001 7.9154968261719E-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 
303 0.0001 0.00010299682617188
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '68'
304 0.0001 8.8930130004883E-5
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '22985' AND a.name = n.originalname
305 0.0001 8.702278137207E-5
SELECT * FROM productoffers WHERE product_id = '22985' AND merchantid = ''
306 0.0001 8.9883804321289E-5
SELECT * FROM productoffers
                WHERE product_id = '22985' AND price > 0
                ORDER BY price ASC LIMIT 1
307 0.0001 7.2002410888672E-5
SELECT * FROM productoffers
                WHERE product_id = 22985
                ORDER BY price ASC LIMIT 1
308 0.0001 7.7962875366211E-5
SELECT value FROM productattributes
                WHERE product_id = '22985'
                AND name = 'ListPriceAmount'
309 0.0003 0.00027108192443848
SELECT * FROM products WHERE id = '22985'
310 0.0002 0.00017595291137695
UPDATE products SET price = '2199' WHERE id = '22985'
311 0.0001 9.9897384643555E-5
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '22985' AND a.name = n.originalname
312 0.0001 6.8902969360352E-5
SELECT * FROM productoffers WHERE product_id = '22985' AND merchantid = ''
313 0.0001 6.6995620727539E-5
SELECT * FROM productoffers
                WHERE product_id = '22985' AND price > 0
                ORDER BY price ASC LIMIT 1
314 0.0001 6.3180923461914E-5
SELECT * FROM productoffers
                WHERE product_id = 22985
                ORDER BY price ASC LIMIT 1
315 0.0001 8.2969665527344E-5
SELECT value FROM productattributes
                WHERE product_id = '22985'
                AND name = 'ListPriceAmount'
316 0.0001 6.6995620727539E-5
SELECT category_id FROM products_categories WHERE product_id = '22985'
317 0.0001 6.1988830566406E-5
SELECT parent_id FROM categories WHERE id = '68'
318 0.0001 6.7949295043945E-5
SELECT * FROM categories WHERE id = '68'
319 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
320 0.0001 6.1988830566406E-5
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 68
321 0.0001 6.103515625E-5
SELECT id FROM categories WHERE parent_id = '68'
322 0.0001 8.3208084106445E-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 
323 0.0001 9.2029571533203E-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 
324 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 (68)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
325 0.0001 6.103515625E-5
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '68'
326 0.0001 6.9856643676758E-5
SELECT * FROM template_info WHERE templateuid = 'fsb-fluid'
327 0.0001 7.3909759521484E-5
SELECT * FROM pages WHERE id = 52
328 0.0001 6.5803527832031E-5
SELECT * FROM pages WHERE id = 53
329 0.0001 6.6995620727539E-5
SELECT * FROM pages WHERE id = 54
330 0.0001 6.6995620727539E-5
SELECT * FROM pages WHERE id = 51
331 0.0001 8.2015991210938E-5
SELECT * FROM pages WHERE id = 52
332 0.0001 6.8187713623047E-5
SELECT * FROM pages WHERE id = 53
333 0.0001 6.3896179199219E-5
SELECT * FROM pages WHERE id = 54
334 0.0001 6.6041946411133E-5
SELECT * FROM pages WHERE id = 51
335 0.0001 6.6041946411133E-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
336 0.0002 0.00019311904907227
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:1560655497;s:8:\"products\";a:4:{i:0;s:4:\"4619\";i:1;s:3:\"955\";i:2;s:4:\"1934\";i:3;s:3:\"758\";}}' WHERE id = '207'
337 0.0001 8.702278137207E-5
SELECT * FROM products WHERE id IN (4619,955,1934,758) ORDER BY FIELD(id, 4619,955,1934,758 )
338 0.0001 6.9141387939453E-5
SELECT * FROM productimages WHERE product_id = '4619' ORDER BY sortorder ASC
339 0.0001 6.413459777832E-5
SELECT * FROM product_image_select WHERE product_id = '4619'
340 0.0001 9.0122222900391E-5
SELECT * FROM productcustomimages WHERE product_id = '4619'
341 0.0001 7.0095062255859E-5
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4619' AND a.name = n.originalname
342 0.0001 6.8187713623047E-5
SELECT * FROM productoffers WHERE product_id = '4619' AND merchantid = ''
343 0.0001 6.2942504882812E-5
SELECT value FROM productattributes WHERE product_id = '4619' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
344 0.0001 0.00012993812561035
UPDATE products SET price = '2993' WHERE id = '4619'
345 0.0001 6.6041946411133E-5
SELECT * FROM productimages WHERE product_id = '955' ORDER BY sortorder ASC
346 0.0001 6.1988830566406E-5
SELECT * FROM product_image_select WHERE product_id = '955'
347 0.0001 6.103515625E-5
SELECT * FROM productcustomimages WHERE product_id = '955'
348 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
349 0.0001 6.5088272094727E-5
SELECT * FROM productoffers WHERE product_id = '955' AND merchantid = ''
350 0.0001 9.2029571533203E-5
SELECT value FROM productattributes WHERE product_id = '955' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
351 0.0002 0.00016188621520996
UPDATE products SET price = '7426' WHERE id = '955'
352 0.0001 0.00010395050048828
SELECT * FROM productimages WHERE product_id = '1934' ORDER BY sortorder ASC
353 0.0001 9.7036361694336E-5
SELECT * FROM product_image_select WHERE product_id = '1934'
354 0.0001 0.0001070499420166
SELECT * FROM productcustomimages WHERE product_id = '1934'
355 0.0001 0.00010490417480469
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1934' AND a.name = n.originalname
356 0.0001 6.8187713623047E-5
SELECT * FROM productoffers WHERE product_id = '1934' AND merchantid = ''
357 0.0001 6.5088272094727E-5
SELECT value FROM productattributes WHERE product_id = '1934' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
358 0.0001 0.00011301040649414
UPDATE products SET price = '15048' WHERE id = '1934'
359 0.0001 7.9154968261719E-5
SELECT * FROM productimages WHERE product_id = '758' ORDER BY sortorder ASC
360 0.0001 6.6995620727539E-5
SELECT * FROM product_image_select WHERE product_id = '758'
361 0.0001 6.3180923461914E-5
SELECT * FROM productcustomimages WHERE product_id = '758'
362 0.0001 7.0095062255859E-5
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '758' AND a.name = n.originalname
363 0.0001 6.9856643676758E-5
SELECT * FROM productoffers WHERE product_id = '758' AND merchantid = ''
364 0.0001 6.5088272094727E-5
SELECT value FROM productattributes WHERE product_id = '758' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
365 0.0001 0.00011301040649414
UPDATE products SET price = '3921' WHERE id = '758'
366 0.0001 7.2002410888672E-5
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid' AND area = 'header' ORDER BY sortorder ASC
367 0.0001 6.6995620727539E-5
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
368 0.0001 6.3896179199219E-5
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
369 0.0001 7.2002410888672E-5
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
370 0.0001 6.5088272094727E-5
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
371 0.0001 7.9870223999023E-5
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid' AND area = 'footer' ORDER BY sortorder ASC
372 0.0001 6.5088272094727E-5
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
373 0.0001 6.4849853515625E-5
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
374 0.0001 6.3896179199219E-5
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
375 0.0001 0.00010085105895996
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-fluid' AND skinuid = ''
376 0.0001 8.9168548583984E-5
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid'
377 0.0001 8.1062316894531E-5
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid'
378 0.0001 0.00013208389282227
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid' AND imageuid = 'HEAD_LOGO'
379 0.0001 0.00010490417480469
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-fluid' AND textuid = '' AND language = 'en'
380 0.0001 0.00010800361633301
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid' AND imageuid = 'HEAD_LOGO'