Pokemon: Pokdex Encyclopedia ( With 1-807 pokedex detail) (English Edition)

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

Descripción del Fabricante

This comprehensive guide book is an absolute must-have for Pokémon Trainers of all ages! It's got all the facts and figures you ever wanted to know about Pokémon in one convenient, easy-to-read format. And it's the perfect reference for Trainers looking to master the world of Pokémon Go.

The Book contain all the pokedex information from 1-807 pokedex .

This is a complete list of all the Pokémon including the Mega Evolutions.
It includes:
-Name of each Pokémon
-Type of each Pokémon
-Weakness
-stat
-next evolve

I was using this as a reference for a long time and thought that this might be useful to some of you.
If you are looking for a Pokédex sort of book with a lot more information on individual Pokémon then check out my other book:

Debug Overview

App Total Time DB Queries DB Query Total Time Amazon Requests
1.0892939567566 373 0.3942 0


No Amazon API Requests Made.


App Debug - Total Time 1.0892939567566 seconds

Number Time From Start Name Description
1 0.33592891693115 Initialise Initialise FSB Function
2 0.33658385276794 App Controller Start Start of the App controller (called before the controller of every page)
3 0.33799290657043 Start of getCategoryListByGroup Function Before first category groups query
4 0.33829593658447 After initial query Before first category groups query
5 0.33829593658447 Get Category List for Group Before the call to getCategoryList function
6 0.33829784393311 Start of GetCategoryList function Start of the function
7 0.33829998970032 Before getting categories Query to get specific category list
8 0.33842206001282 After getting categories Query to get specific category list
9 0.33842301368713 Before getting category custom Before call to function getCategoryCustom
10 0.34133505821228 After getting category custom After call to function getCategoryCustom
11 0.34133696556091 Before getting category custom Before call to function getCategoryCustom
12 0.36781597137451 After getting category custom After call to function getCategoryCustom
13 0.36781907081604 Before getting category custom Before call to function getCategoryCustom
14 0.38494896888733 After getting category custom After call to function getCategoryCustom
15 0.38495302200317 Before getting category custom Before call to function getCategoryCustom
16 0.38902807235718 After getting category custom After call to function getCategoryCustom
17 0.38902997970581 Before getting category custom Before call to function getCategoryCustom
18 0.41721892356873 After getting category custom After call to function getCategoryCustom
19 0.41722202301025 Before getting category custom Before call to function getCategoryCustom
20 0.42136406898499 After getting category custom After call to function getCategoryCustom
21 0.42136597633362 Before getting category custom Before call to function getCategoryCustom
22 0.42368602752686 After getting category custom After call to function getCategoryCustom
23 0.42368793487549 Before getting category custom Before call to function getCategoryCustom
24 0.43806791305542 After getting category custom After call to function getCategoryCustom
25 0.43807101249695 Before getting category custom Before call to function getCategoryCustom
26 0.45762586593628 After getting category custom After call to function getCategoryCustom
27 0.45762896537781 End of GetCategoryList function End of the function
28 0.45763993263245 Get Category List for Group Before the call to getCategoryList function
29 0.45764303207397 Start of GetCategoryList function Start of the function
30 0.45764684677124 Before getting categories Query to get specific category list
31 0.45784306526184 After getting categories Query to get specific category list
32 0.45784401893616 Before getting category custom Before call to function getCategoryCustom
33 0.46591687202454 After getting category custom After call to function getCategoryCustom
34 0.46591997146606 Before getting category custom Before call to function getCategoryCustom
35 0.4683530330658 After getting category custom After call to function getCategoryCustom
36 0.46835494041443 Before getting category custom Before call to function getCategoryCustom
37 0.47099494934082 After getting category custom After call to function getCategoryCustom
38 0.47099590301514 Before getting category custom Before call to function getCategoryCustom
39 0.47350192070007 After getting category custom After call to function getCategoryCustom
40 0.47350406646729 Before getting category custom Before call to function getCategoryCustom
41 0.47757005691528 After getting category custom After call to function getCategoryCustom
42 0.47757196426392 Before getting category custom Before call to function getCategoryCustom
43 0.48056292533875 After getting category custom After call to function getCategoryCustom
44 0.48056507110596 Before getting category custom Before call to function getCategoryCustom
45 0.48313188552856 After getting category custom After call to function getCategoryCustom
46 0.48313403129578 Before getting category custom Before call to function getCategoryCustom
47 0.48745489120483 After getting category custom After call to function getCategoryCustom
48 0.48745703697205 Before getting category custom Before call to function getCategoryCustom
49 0.48980093002319 After getting category custom After call to function getCategoryCustom
50 0.48980283737183 Before getting category custom Before call to function getCategoryCustom
51 0.49217104911804 After getting category custom After call to function getCategoryCustom
52 0.49217295646667 Before getting category custom Before call to function getCategoryCustom
53 0.49440383911133 After getting category custom After call to function getCategoryCustom
54 0.49440598487854 Before getting category custom Before call to function getCategoryCustom
55 0.49634385108948 After getting category custom After call to function getCategoryCustom
56 0.49634504318237 Before getting category custom Before call to function getCategoryCustom
57 0.49901103973389 After getting category custom After call to function getCategoryCustom
58 0.49901294708252 End of GetCategoryList function End of the function
59 0.49902391433716 End of getCategoryListByGroup Function Before return()
60 0.49992895126343 App Controller End End of the App controller (called before the controller of every page)
61 0.49998593330383 Product Start Start of the product info controller
62 0.50044393539429 Cache file not found Starting get product details
63 0.50571489334106 Related products Start getting related products if enabled
64 0.50571584701538 Related Products Start Before the related products are found
65 0.50571584701538 Related Products Keywords Before the related product keywords are found
66 0.50572204589844 Create Keyword List Function Start of function
67 0.50601387023926 Create Keyword List Function After looping provided content - 371 keywords found
68 0.51662397384644 Create Keyword List Function After looping initial keyword list - 332 keywords remaining
69 0.5166699886322 Create Keyword List Function After reducing keyword list
70 0.51715302467346 Create Keyword List Function After selecting by scoring keywords
71 0.51715683937073 Create Keyword List Function After final loop of keywords
72 0.51715993881226 Related Products Keywords After the related product keywords are found
73 0.73265600204468 Related Products End After the related products are found
74 0.7349648475647 Start Remote Request http://svcs.ebay.com/services/search/FindingServic...
75 1.0667729377747 End Remote Request http://svcs.ebay.com/services/search/FindingServic...
76 1.070592880249 Product End End of the product info controller (Product Info)
77 1.0707869529724 App_after Controller Start Start of the App_after controller (called after the controller of every page)
78 1.0708320140839 Before Get Options Before the call to getOptions in the tpl class
79 1.0789349079132 After Get Options After the call to getOptions in the tpl class
80 1.0790798664093 App_after Controller End End of the App_after controller (called after the controller of every page)
81 1.0790870189667 Product Info: Before Smarty Fetch Before the product.tpl template is fetched
82 1.0825109481812 Product Info: After Smarty Fetch After the product.tpl template is fetched
83 1.0825140476227 Product Info: Before Template Display Before the template is displayed
84 1.089282989502 Product Info: After Template Display After the template is displayed
85 1.0892858505249 Finalizing debug Before the debug is output to the page.
86 1.0892939567566 End of App This is the end of the app logging, final timestamp


Query Debug - 373 Database Queries. Total time 0.3942 seconds

Number Time (Seconds) Time (Milliseconds) Query
1 0.0001 7.8916549682617E-5
SELECT value FROM parameters WHERE `parameter` = 'BAD_BOTS_ENABLER'
2 0.0006 0.00057792663574219
SHOW TABLES LIKE 'bad_bots'
3 0.0002 0.00015521049499512
SELECT value FROM parameters WHERE `parameter` = 'STORE_WHITELISTED_IPS'
4 0.0002 0.00015592575073242
SELECT * FROM `bad_bots`
5 0.0002 0.00022697448730469
SELECT parameter, value FROM parameters
6 0.0002 0.00023698806762695
SET time_zone = 'Europe/London'
7 0.0004 0.00041699409484863
SELECT * FROM autorun ORDER BY lastrun ASC
8 0.0001 0.00012493133544922
SELECT * FROM version ORDER BY installed DESC LIMIT 1
9 0.0002 0.00021195411682129
SELECT id FROM pages WHERE pagename = 'pokemon-pokdex-encyclopedia-with-1-807-pokedex-detail-english-edition' LIMIT 1
10 0.0002 0.00020194053649902
SELECT id FROM products WHERE pagename = 'pokemon-pokdex-encyclopedia-with-1-807-pokedex-detail-english-edition' AND hidden = 0 LIMIT 1
11 0.0005 0.00050711631774902
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-fluid'
12 0.0002 0.00021195411682129
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-fluid' AND language = 'es'
13 0.0002 0.00018501281738281
SELECT * FROM pages WHERE pagename = 'pokemon-pokdex-encyclopedia-with-1-807-pokedex-detail-english-edition'
14 0.0003 0.00029301643371582
SELECT * FROM categorygroups ORDER BY sortorder ASC
15 0.0001 9.7990036010742E-5
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '2'  AND hidden = 0 ORDER BY sortorder ASC
16 0.0003 0.00030708312988281
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 0.00012087821960449
SELECT id FROM categories WHERE parent_id = '70'
18 0.0003 0.00029993057250977
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.0019 0.001863956451416
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (70)
				  AND p.disabled = 0 
20 0.0001 7.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 (70)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
21 0.0001 7.5101852416992E-5
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '70'
22 0.0001 7.4863433837891E-5
SELECT * FROM categorygroups WHERE id = '2'
23 0.0115 0.011476039886475
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.0012 0.0011591911315918
SELECT id FROM categories WHERE parent_id = '66'
25 0.0118 0.011847019195557
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.0016 0.0015690326690674
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 0.00011301040649414
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (66)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
28 0.0001 8.2015991210938E-5
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '66'
29 0.0001 0.00012612342834473
SELECT * FROM categorygroups WHERE id = '2'
30 0.0067 0.0066900253295898
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.0017 0.001680850982666
SELECT id FROM categories WHERE parent_id = '67'
32 0.0068 0.0067660808563232
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.0015 0.001539945602417
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 0.00010108947753906
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 9.918212890625E-5
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '67'
36 0.0001 0.0001060962677002
SELECT * FROM categorygroups WHERE id = '2'
37 0.0010 0.0010499954223633
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.0010 0.00096797943115234
SELECT id FROM categories WHERE parent_id = '56'
39 0.0010 0.00099992752075195
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.0006 0.00059914588928223
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 0.00014519691467285
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 0.00010204315185547
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '56'
43 0.0001 0.00011205673217773
SELECT * FROM categorygroups WHERE id = '2'
44 0.0119 0.011914014816284
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.0016 0.0015838146209717
SELECT id FROM categories WHERE parent_id = '59'
46 0.0124 0.012394905090332
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.0018 0.0018348693847656
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (59)
				  AND p.disabled = 0 
48 0.0001 0.00010514259338379
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (59)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
49 0.0001 0.0001060962677002
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '59'
50 0.0001 0.0001070499420166
SELECT * FROM categorygroups WHERE id = '2'
51 0.0009 0.00088715553283691
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.0012 0.0012190341949463
SELECT id FROM categories WHERE parent_id = '61'
53 0.0009 0.00085186958312988
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.0008 0.00080299377441406
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (61)
				  AND p.disabled = 0 
55 0.0001 0.0001060962677002
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 8.8930130004883E-5
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '61'
57 0.0001 8.5115432739258E-5
SELECT * FROM categorygroups WHERE id = '2'
58 0.0002 0.0002281665802002
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.0008 0.00078988075256348
SELECT id FROM categories WHERE parent_id = '62'
60 0.0003 0.00025701522827148
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.0007 0.00070714950561523
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (62)
				  AND p.disabled = 0 
62 0.0001 8.702278137207E-5
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (62)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
63 0.0001 8.392333984375E-5
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '62'
64 0.0001 9.1075897216797E-5
SELECT * FROM categorygroups WHERE id = '2'
65 0.0059 0.0058701038360596
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.0010 0.001011848449707
SELECT id FROM categories WHERE parent_id = '68'
67 0.0060 0.005979061126709
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.0011 0.0010960102081299
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (68)
				  AND p.disabled = 0 
69 0.0001 0.00011396408081055
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (68)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
70 0.0001 0.00010395050048828
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '68'
71 0.0001 0.00010395050048828
SELECT * FROM categorygroups WHERE id = '2'
72 0.0081 0.0081400871276855
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.0011 0.0011298656463623
SELECT id FROM categories WHERE parent_id = '69'
74 0.0085 0.0085179805755615
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.0013 0.0013329982757568
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (69)
				  AND p.disabled = 0 
76 0.0001 0.0001060962677002
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (69)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
77 0.0001 0.00010490417480469
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '69'
78 0.0001 0.00010490417480469
SELECT * FROM categorygroups WHERE id = '2'
79 0.0001 0.00014495849609375
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
80 0.0003 0.00026416778564453
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.0008 0.00081896781921387
SELECT id FROM categories WHERE parent_id = '29'
82 0.0001 0.00011301040649414
SELECT id FROM categories WHERE parent_id = '30'
83 0.0001 0.00010395050048828
SELECT id FROM categories WHERE parent_id = '31'
84 0.0001 7.2956085205078E-5
SELECT id FROM categories WHERE parent_id = '32'
85 0.0001 6.6041946411133E-5
SELECT id FROM categories WHERE parent_id = '33'
86 0.0001 6.6041946411133E-5
SELECT id FROM categories WHERE parent_id = '34'
87 0.0001 0.00010418891906738
SELECT id FROM categories WHERE parent_id = '35'
88 0.0001 0.00012302398681641
SELECT id FROM categories WHERE parent_id = '39'
89 0.0001 7.7962875366211E-5
SELECT id FROM categories WHERE parent_id = '41'
90 0.0001 6.6041946411133E-5
SELECT id FROM categories WHERE parent_id = '36'
91 0.0001 6.6041946411133E-5
SELECT id FROM categories WHERE parent_id = '37'
92 0.0046 0.0045571327209473
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.0010 0.0010030269622803
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 0.00010299682617188
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (30,31,32,33,34,35,39,41,36,37,29)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
95 0.0001 0.00014185905456543
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
96 0.0001 0.00011086463928223
SELECT * FROM categorygroups WHERE id = '1'
97 0.0005 0.00048398971557617
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.0006 0.00056290626525879
SELECT id FROM categories WHERE parent_id = '52'
99 0.0005 0.00048184394836426
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (52)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
100 0.0006 0.00056004524230957
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 8.9883804321289E-5
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (52)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
102 0.0001 8.7976455688477E-5
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '52'
103 0.0001 9.0122222900391E-5
SELECT * FROM categorygroups WHERE id = '1'
104 0.0006 0.00060105323791504
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.0005 0.00054287910461426
SELECT id FROM categories WHERE parent_id = '51'
106 0.0006 0.00058412551879883
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (51)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
107 0.0005 0.00054311752319336
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (51)
				  AND p.disabled = 0 
108 0.0001 0.00011301040649414
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 8.7976455688477E-5
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '51'
110 0.0001 9.2983245849609E-5
SELECT * FROM categorygroups WHERE id = '1'
111 0.0004 0.00043702125549316
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.0006 0.00060296058654785
SELECT id FROM categories WHERE parent_id = '28'
113 0.0005 0.00046515464782715
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.0007 0.00067901611328125
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 8.702278137207E-5
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (28)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
116 0.0001 8.392333984375E-5
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
117 0.0001 8.2015991210938E-5
SELECT * FROM categorygroups WHERE id = '1'
118 0.0002 0.0001838207244873
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.0006 0.00057697296142578
SELECT id FROM categories WHERE parent_id = '43'
120 0.0001 8.7976455688477E-5
SELECT id FROM categories WHERE parent_id = '44'
121 0.0001 6.8187713623047E-5
SELECT id FROM categories WHERE parent_id = '45'
122 0.0001 6.6041946411133E-5
SELECT id FROM categories WHERE parent_id = '46'
123 0.0001 6.6041946411133E-5
SELECT id FROM categories WHERE parent_id = '47'
124 0.0019 0.0019049644470215
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.0007 0.00072121620178223
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (44,45,46,47,43)
				  AND p.disabled = 0 
126 0.0001 9.0122222900391E-5
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (44,45,46,47,43)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
127 0.0001 8.8930130004883E-5
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '43'
128 0.0001 9.2983245849609E-5
SELECT * FROM categorygroups WHERE id = '1'
129 0.0007 0.00074505805969238
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.0005 0.00053596496582031
SELECT id FROM categories WHERE parent_id = '50'
131 0.0008 0.00082802772521973
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (50)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
132 0.0005 0.00053000450134277
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (50)
				  AND p.disabled = 0 
133 0.0001 8.8930130004883E-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 9.0122222900391E-5
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '50'
135 0.0001 9.1791152954102E-5
SELECT * FROM categorygroups WHERE id = '1'
136 0.0006 0.00058197975158691
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 54
137 0.0005 0.00054788589477539
SELECT id FROM categories WHERE parent_id = '54'
138 0.0006 0.00056982040405273
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (54)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
139 0.0005 0.00051689147949219
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (54)
				  AND p.disabled = 0 
140 0.0001 8.9883804321289E-5
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (54)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
141 0.0001 8.7976455688477E-5
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '54'
142 0.0001 9.0122222900391E-5
SELECT * FROM categorygroups WHERE id = '1'
143 0.0013 0.0013449192047119
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.0007 0.00067996978759766
SELECT id FROM categories WHERE parent_id = '26'
145 0.0014 0.0013618469238281
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.0006 0.0005950927734375
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (26)
				  AND p.disabled = 0 
147 0.0001 8.8930130004883E-5
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (26)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
148 0.0001 8.2969665527344E-5
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
149 0.0001 8.2969665527344E-5
SELECT * FROM categorygroups WHERE id = '1'
150 0.0005 0.00048708915710449
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 38
151 0.0005 0.00047516822814941
SELECT id FROM categories WHERE parent_id = '38'
152 0.0005 0.00050020217895508
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (38)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
153 0.0005 0.00049614906311035
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 0.00011706352233887
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 8.2969665527344E-5
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '38'
156 0.0001 0.00010490417480469
SELECT * FROM categorygroups WHERE id = '1'
157 0.0005 0.00050997734069824
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.0005 0.00054693222045898
SELECT id FROM categories WHERE parent_id = '48'
159 0.0005 0.00051283836364746
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (48)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
160 0.0005 0.00047588348388672
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 8.6069107055664E-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 8.392333984375E-5
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '48'
163 0.0001 8.6069107055664E-5
SELECT * FROM categorygroups WHERE id = '1'
164 0.0005 0.00046014785766602
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.0005 0.00045585632324219
SELECT id FROM categories WHERE parent_id = '49'
166 0.0005 0.00053095817565918
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.0004 0.00044107437133789
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (49)
				  AND p.disabled = 0 
168 0.0001 8.4877014160156E-5
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (49)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
169 0.0001 8.2015991210938E-5
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '49'
170 0.0001 8.3208084106445E-5
SELECT * FROM categorygroups WHERE id = '1'
171 0.0004 0.00039196014404297
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 55
172 0.0004 0.0004279613494873
SELECT id FROM categories WHERE parent_id = '55'
173 0.0004 0.00041508674621582
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.0004 0.0003819465637207
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (55)
				  AND p.disabled = 0 
175 0.0001 8.5115432739258E-5
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (55)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
176 0.0001 8.4161758422852E-5
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '55'
177 0.0001 8.2969665527344E-5
SELECT * FROM categorygroups WHERE id = '1'
178 0.0006 0.0006110668182373
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.0004 0.00039911270141602
SELECT id FROM categories WHERE parent_id = '27'
180 0.0001 0.00010800361633301
SELECT id FROM categories WHERE parent_id = '65'
181 0.0006 0.00064897537231445
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.0004 0.00043106079101562
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 0.00011301040649414
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 0.00010180473327637
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
185 0.0001 0.00010395050048828
SELECT * FROM categorygroups WHERE id = '1'
186 0.0001 8.7976455688477E-5
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
187 0.0001 7.6055526733398E-5
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-fluid' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
188 0.0001 6.6995620727539E-5
SELECT value FROM parameters WHERE parameter = 'EBAY_APP_ID' 
189 0.0001 6.2942504882812E-5
SELECT value FROM parameters WHERE parameter = 'GOOGLE_SITE_KEY' 
190 0.0001 7.8916549682617E-5
SELECT value FROM parameters WHERE parameter = 'GOOGLE_SECRET_KEY' 
191 0.0001 7.2002410888672E-5
SELECT value FROM parameters WHERE parameter = 'GOOGLE_RECAPTCHA_TYPE' 
192 0.0001 0.00010299682617188
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
193 0.0002 0.00022506713867188
SELECT * FROM products WHERE pagename = 'pokemon-pokdex-encyclopedia-with-1-807-pokedex-detail-english-edition'
194 0.0001 7.2002410888672E-5
SELECT * FROM manufacturers WHERE id = '0'
195 0.0002 0.00016307830810547
SELECT category_id FROM products_categories WHERE product_id = '26982'
196 0.0004 0.00040388107299805
SELECT * FROM categories WHERE id = '68'
197 0.0001 6.6995620727539E-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
198 0.0001 6.1988830566406E-5
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 68
199 0.0001 6.103515625E-5
SELECT id FROM categories WHERE parent_id = '68'
200 0.0001 6.4849853515625E-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 
201 0.0001 8.082389831543E-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 
202 0.0001 6.1988830566406E-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 
203 0.0001 7.2002410888672E-5
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '68'
204 0.0001 7.9870223999023E-5
SELECT * FROM productimages WHERE product_id = '26982' ORDER BY sortorder ASC
205 0.0001 6.9856643676758E-5
SELECT * FROM product_image_select WHERE product_id = '26982'
206 0.0001 6.3896179199219E-5
SELECT * FROM productcustomimages WHERE product_id = '26982'
207 0.0001 0.00011682510375977
SELECT * FROM productfeeds WHERE product_id = '26982' ORDER BY item_date DESC
208 0.0005 0.0004570484161377
SELECT a.name, n.displayname, a.value, n.units, n.valuetype FROM productattributes a, productattributenames n WHERE product_id = '26982' AND a.name = n.originalname AND n.display = 1 AND n.hidden = 0
209 0.0005 0.00049686431884766
SELECT DISTINCT(pt.tag_id) FROM product_tags pt, tags t WHERE pt.tag_id = t.id AND pt.product_id = '26982' AND t.hidden = 0 AND display_product = 1
210 0.0003 0.00034499168395996
SELECT * FROM productamazoncontent WHERE product_id = '26982'
211 0.0011 0.0011360645294189
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '26982' AND a.name = n.originalname
212 0.0002 0.00023007392883301
SELECT * FROM productoffers WHERE product_id = '26982' AND merchantid = ''
213 0.0002 0.00015711784362793
SELECT * FROM productoffers
                WHERE product_id = '26982' AND price > 0
                ORDER BY price ASC LIMIT 1
214 0.0002 0.00016593933105469
SELECT * FROM productoffers
                WHERE product_id = 26982
                ORDER BY price ASC LIMIT 1
215 0.0002 0.00022006034851074
SELECT value FROM productattributes
                WHERE product_id = '26982'
                AND name = 'ListPriceAmount'
216 0.0003 0.00028395652770996
UPDATE products SET price = '617' WHERE id = '26982'
217 0.0671 0.067126035690308
SELECT *, MATCH (description, keyfeatures, title) AGAINST ('pokandeacutemon' IN BOOLEAN MODE) AS `searchrelevance` FROM products WHERE MATCH (description, keyfeatures, title) AGAINST ('pokandeacutemon' IN BOOLEAN MODE) AND 26982 <> 0 AND enabled = 1 AND hidden = 0 AND offers > 0 AND parent_id = 0 ORDER BY `searchrelevance` LIMIT 6
218 0.0666 0.066564083099365
SELECT *, MATCH (description, keyfeatures, title) AGAINST ('pokedex' IN BOOLEAN MODE) AS `searchrelevance` FROM products WHERE MATCH (description, keyfeatures, title) AGAINST ('pokedex' IN BOOLEAN MODE) AND 26982 <> 0 AND enabled = 1 AND hidden = 0 AND offers > 0 AND parent_id = 0 ORDER BY `searchrelevance` LIMIT 6
219 0.0001 0.00014591217041016
SELECT * FROM productimages WHERE product_id = '23882' ORDER BY sortorder ASC
220 0.0001 0.00012397766113281
SELECT * FROM product_image_select WHERE product_id = '23882'
221 0.0001 7.6055526733398E-5
SELECT * FROM productcustomimages WHERE product_id = '23882'
222 0.0018 0.0017950534820557
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '23882' AND a.name = n.originalname
223 0.0002 0.00022006034851074
SELECT * FROM productoffers WHERE product_id = '23882' AND merchantid = ''
224 0.0003 0.00029897689819336
SELECT value FROM productattributes WHERE product_id = '23882' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
225 0.0009 0.00088405609130859
UPDATE products SET price = '1899' WHERE id = '23882'
226 0.0001 0.00012516975402832
SELECT * FROM productimages WHERE product_id = '27649' ORDER BY sortorder ASC
227 0.0005 0.00050497055053711
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '27649' AND p.id = pi.product_id ORDER BY pi.sortorder
228 0.0001 0.00011110305786133
SELECT * FROM product_image_select WHERE product_id = '27649'
229 0.0001 0.00011396408081055
SELECT * FROM productcustomimages WHERE product_id = '27649'
230 0.0003 0.00033807754516602
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 = '27649'
                GROUP BY o.product_id
231 0.0004 0.00044989585876465
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     = '27649'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
232 0.0004 0.00037598609924316
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 27649
233 0.0001 0.00014805793762207
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '27649' AND a.name = n.originalname
234 0.0002 0.0001671314239502
SELECT * FROM productoffers WHERE product_id = '27649' AND merchantid = ''
235 0.0002 0.00019407272338867
SELECT * FROM productoffers
                WHERE product_id = '27649' AND price > 0
                ORDER BY price ASC LIMIT 1
236 0.0001 0.00014495849609375
SELECT * FROM productoffers
                WHERE product_id = 27649
                ORDER BY price ASC LIMIT 1
237 0.0001 0.00010204315185547
SELECT value FROM productattributes
                WHERE product_id = '27649'
                AND name = 'ListPriceAmount'
238 0.0001 6.9856643676758E-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 = '27649'
                GROUP BY o.product_id
239 0.0001 7.0095062255859E-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     = '27649'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
240 0.0001 6.8902969360352E-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 = 27649
241 0.0001 6.8902969360352E-5
SELECT value FROM productattributes WHERE product_id = '27649' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
242 0.0001 0.00012087821960449
UPDATE products SET price = '1595' WHERE id = '27649'
243 0.0004 0.00040316581726074
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '27649'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Size'
                GROUP BY o.value
                ORDER BY o.value ASC
244 0.0708 0.070808887481689
SELECT *, MATCH (description, keyfeatures, title) AGAINST ('pokemon pokdex encyclopedia' IN BOOLEAN MODE) AS `searchrelevance` FROM products WHERE MATCH (description, keyfeatures, title) AGAINST ('pokemon pokdex encyclopedia' IN BOOLEAN MODE) AND 26982 <> 0 AND enabled = 1 AND hidden = 0 AND offers > 0 AND parent_id = 0 ORDER BY `searchrelevance` LIMIT 4
245 0.0001 0.00013303756713867
SELECT * FROM productimages WHERE product_id = '17952' ORDER BY sortorder ASC
246 0.0001 9.3221664428711E-5
SELECT * FROM product_image_select WHERE product_id = '17952'
247 0.0001 9.0122222900391E-5
SELECT * FROM productcustomimages WHERE product_id = '17952'
248 0.0001 9.8943710327148E-5
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '17952' AND a.name = n.originalname
249 0.0001 0.00012612342834473
SELECT * FROM productoffers WHERE product_id = '17952' AND merchantid = ''
250 0.0001 0.00012588500976562
SELECT value FROM productattributes WHERE product_id = '17952' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
251 0.0002 0.00018811225891113
UPDATE products SET price = '3499' WHERE id = '17952'
252 0.0001 8.2015991210938E-5
SELECT * FROM productimages WHERE product_id = '3872' ORDER BY sortorder ASC
253 0.0001 7.9154968261719E-5
SELECT * FROM product_image_select WHERE product_id = '3872'
254 0.0001 7.2956085205078E-5
SELECT * FROM productcustomimages WHERE product_id = '3872'
255 0.0001 7.7009201049805E-5
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3872' AND a.name = n.originalname
256 0.0001 7.6055526733398E-5
SELECT * FROM productoffers WHERE product_id = '3872' AND merchantid = ''
257 0.0001 7.6770782470703E-5
SELECT value FROM productattributes WHERE product_id = '3872' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
258 0.0001 0.00012087821960449
UPDATE products SET price = '4995' WHERE id = '3872'
259 0.0001 7.3909759521484E-5
SELECT * FROM productimages WHERE product_id = '5719' ORDER BY sortorder ASC
260 0.0001 7.2002410888672E-5
SELECT * FROM product_image_select WHERE product_id = '5719'
261 0.0001 7.0095062255859E-5
SELECT * FROM productcustomimages WHERE product_id = '5719'
262 0.0001 7.7962875366211E-5
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '5719' AND a.name = n.originalname
263 0.0001 7.9154968261719E-5
SELECT * FROM productoffers WHERE product_id = '5719' AND merchantid = ''
264 0.0001 7.1048736572266E-5
SELECT value FROM productattributes WHERE product_id = '5719' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
265 0.0001 0.00011682510375977
UPDATE products SET price = '6077' WHERE id = '5719'
266 0.0001 7.3909759521484E-5
SELECT * FROM productimages WHERE product_id = '19029' ORDER BY sortorder ASC
267 0.0001 7.1048736572266E-5
SELECT * FROM product_image_select WHERE product_id = '19029'
268 0.0001 7.1048736572266E-5
SELECT * FROM productcustomimages WHERE product_id = '19029'
269 0.0001 7.6055526733398E-5
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '19029' AND a.name = n.originalname
270 0.0001 7.5817108154297E-5
SELECT * FROM productoffers WHERE product_id = '19029' AND merchantid = ''
271 0.0001 7.0095062255859E-5
SELECT value FROM productattributes WHERE product_id = '19029' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
272 0.0001 0.00012707710266113
UPDATE products SET price = '1976' WHERE id = '19029'
273 0.0001 8.4877014160156E-5
SELECT value FROM parameters WHERE parameter = 'EBAY_CACHE_TIME' 
274 0.0001 7.7962875366211E-5
SELECT value FROM parameters WHERE parameter = 'EBAY_APP_ID' 
275 0.0001 7.4863433837891E-5
SELECT value FROM parameters WHERE parameter = 'EBAY_TRACKING_ID' 
276 0.0001 6.7949295043945E-5
SELECT value FROM parameters WHERE parameter = 'EBAY_NETWORK_ID' 
277 0.0001 6.6995620727539E-5
SELECT value FROM parameters WHERE parameter = 'EBAY_LOCALE' 
278 0.0001 6.6041946411133E-5
SELECT value FROM parameters WHERE parameter = 'EBAY_AUTH_TOKEN' 
279 0.0001 6.6995620727539E-5
SELECT * FROM ebay_locale_details WHERE cur_code = 'USD' 
280 0.0001 0.00013089179992676
SELECT * FROM ebay_products_cache WHERE cachekey = '6fa0480193d3454d4c46cdaa853035e9' 
281 0.0011 0.0011160373687744
SELECT value FROM parameters WHERE parameter = 'EBAY_APP_ID' 
282 0.0001 6.8902969360352E-5
SELECT value FROM parameters WHERE parameter = 'EBAY_TRACKING_ID' 
283 0.0001 6.5088272094727E-5
SELECT value FROM parameters WHERE parameter = 'EBAY_NETWORK_ID' 
284 0.0001 6.5088272094727E-5
SELECT value FROM parameters WHERE parameter = 'EBAY_LOCALE' 
285 0.0001 6.5088272094727E-5
SELECT value FROM parameters WHERE parameter = 'EBAY_AUTH_TOKEN' 
286 0.0002 0.00016307830810547
SELECT * FROM ebay_products_cache WHERE cachekey = '6fa0480193d3454d4c46cdaa853035e9' 
287 0.0003 0.00028085708618164
SELECT id,asin FROM products WHERE parent_id = 26982
288 0.0004 0.0004279613494873
SELECT category_id FROM products_categories WHERE product_id = '26982'
289 0.0001 0.00012397766113281
SELECT * FROM categories WHERE id = '68'
290 0.0001 0.00010085105895996
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
291 0.0001 0.00011396408081055
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 68
292 0.0001 9.7990036010742E-5
SELECT id FROM categories WHERE parent_id = '68'
293 0.0001 9.608268737793E-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 
294 0.0001 0.00010085105895996
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 
295 0.0001 7.1048736572266E-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 
296 0.0001 9.2983245849609E-5
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '68'
297 0.0001 6.7949295043945E-5
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '26982' AND a.name = n.originalname
298 0.0001 6.7949295043945E-5
SELECT * FROM productoffers WHERE product_id = '26982' AND merchantid = ''
299 0.0001 6.2942504882812E-5
SELECT * FROM productoffers
                WHERE product_id = '26982' AND price > 0
                ORDER BY price ASC LIMIT 1
300 0.0001 6.413459777832E-5
SELECT * FROM productoffers
                WHERE product_id = 26982
                ORDER BY price ASC LIMIT 1
301 0.0001 6.103515625E-5
SELECT value FROM productattributes
                WHERE product_id = '26982'
                AND name = 'ListPriceAmount'
302 0.0002 0.00018692016601562
SELECT * FROM products WHERE id = '26982'
303 0.0001 0.00012922286987305
UPDATE products SET price = '617' WHERE id = '26982'
304 0.0001 6.6041946411133E-5
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '26982' AND a.name = n.originalname
305 0.0001 6.6041946411133E-5
SELECT * FROM productoffers WHERE product_id = '26982' AND merchantid = ''
306 0.0001 9.2029571533203E-5
SELECT * FROM productoffers
                WHERE product_id = '26982' AND price > 0
                ORDER BY price ASC LIMIT 1
307 0.0001 6.3896179199219E-5
SELECT * FROM productoffers
                WHERE product_id = 26982
                ORDER BY price ASC LIMIT 1
308 0.0001 6.0081481933594E-5
SELECT value FROM productattributes
                WHERE product_id = '26982'
                AND name = 'ListPriceAmount'
309 0.0001 6.1988830566406E-5
SELECT category_id FROM products_categories WHERE product_id = '26982'
310 0.0001 5.9843063354492E-5
SELECT parent_id FROM categories WHERE id = '68'
311 0.0001 6.6041946411133E-5
SELECT * FROM categories WHERE id = '68'
312 0.0001 6.0796737670898E-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
313 0.0001 6.103515625E-5
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 68
314 0.0001 6.0081481933594E-5
SELECT id FROM categories WHERE parent_id = '68'
315 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 
316 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 
317 0.0001 6.1988830566406E-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 
318 0.0001 5.9843063354492E-5
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '68'
319 0.0001 8.0108642578125E-5
SELECT * FROM template_info WHERE templateuid = 'fsb-fluid'
320 0.0001 7.2002410888672E-5
SELECT * FROM pages WHERE id = 52
321 0.0001 6.8902969360352E-5
SELECT * FROM pages WHERE id = 53
322 0.0001 6.6995620727539E-5
SELECT * FROM pages WHERE id = 54
323 0.0001 6.6995620727539E-5
SELECT * FROM pages WHERE id = 51
324 0.0001 6.7949295043945E-5
SELECT * FROM pages WHERE id = 52
325 0.0001 6.8902969360352E-5
SELECT * FROM pages WHERE id = 53
326 0.0001 7.9154968261719E-5
SELECT * FROM pages WHERE id = 54
327 0.0001 6.2942504882812E-5
SELECT * FROM pages WHERE id = 51
328 0.0007 0.00072884559631348
SELECT p.id,p.parent_id, o.price FROM products p, productoffers o WHERE p.id = o.product_id AND p.parent_id = 0 AND hidden = 0 AND offers > 0 AND (p.price >= 1000 AND p.price <= 50000) AND (SELECT COUNT(pi.id) FROM productimages pi WHERE pi.product_id = p.id) > 1 AND o.id IN (SELECT x.id FROM productoffers x WHERE x.product_id = p.id HAVING MIN(x.price)) ORDER BY o.percentagesaved DESC LIMIT 4
329 0.0021 0.0020618438720703
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:1560654952;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'
330 0.0004 0.00035786628723145
SELECT * FROM products WHERE id IN (4619,955,1934,758) ORDER BY FIELD(id, 4619,955,1934,758 )
331 0.0001 9.5129013061523E-5
SELECT * FROM productimages WHERE product_id = '4619' ORDER BY sortorder ASC
332 0.0001 7.9870223999023E-5
SELECT * FROM product_image_select WHERE product_id = '4619'
333 0.0001 6.6995620727539E-5
SELECT * FROM productcustomimages WHERE product_id = '4619'
334 0.0001 7.2956085205078E-5
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4619' AND a.name = n.originalname
335 0.0001 6.6995620727539E-5
SELECT * FROM productoffers WHERE product_id = '4619' AND merchantid = ''
336 0.0001 6.2942504882812E-5
SELECT value FROM productattributes WHERE product_id = '4619' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
337 0.0001 0.00013017654418945
UPDATE products SET price = '2993' WHERE id = '4619'
338 0.0001 8.6069107055664E-5
SELECT * FROM productimages WHERE product_id = '955' ORDER BY sortorder ASC
339 0.0001 6.7949295043945E-5
SELECT * FROM product_image_select WHERE product_id = '955'
340 0.0001 6.2942504882812E-5
SELECT * FROM productcustomimages WHERE product_id = '955'
341 0.0001 7.7009201049805E-5
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '955' AND a.name = n.originalname
342 0.0001 6.4849853515625E-5
SELECT * FROM productoffers WHERE product_id = '955' AND merchantid = ''
343 0.0001 6.3180923461914E-5
SELECT value FROM productattributes WHERE product_id = '955' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
344 0.0001 0.00011086463928223
UPDATE products SET price = '7426' WHERE id = '955'
345 0.0001 6.5803527832031E-5
SELECT * FROM productimages WHERE product_id = '1934' ORDER BY sortorder ASC
346 0.0001 6.6041946411133E-5
SELECT * FROM product_image_select WHERE product_id = '1934'
347 0.0001 6.6041946411133E-5
SELECT * FROM productcustomimages WHERE product_id = '1934'
348 0.0001 7.1048736572266E-5
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1934' AND a.name = n.originalname
349 0.0001 8.3208084106445E-5
SELECT * FROM productoffers WHERE product_id = '1934' AND merchantid = ''
350 0.0001 6.2942504882812E-5
SELECT value FROM productattributes WHERE product_id = '1934' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
351 0.0001 0.00011086463928223
UPDATE products SET price = '15048' WHERE id = '1934'
352 0.0001 6.9856643676758E-5
SELECT * FROM productimages WHERE product_id = '758' ORDER BY sortorder ASC
353 0.0001 6.2942504882812E-5
SELECT * FROM product_image_select WHERE product_id = '758'
354 0.0001 6.103515625E-5
SELECT * FROM productcustomimages WHERE product_id = '758'
355 0.0001 7.7962875366211E-5
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '758' AND a.name = n.originalname
356 0.0001 6.413459777832E-5
SELECT * FROM productoffers WHERE product_id = '758' AND merchantid = ''
357 0.0001 6.1988830566406E-5
SELECT value FROM productattributes WHERE product_id = '758' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
358 0.0001 0.0001070499420166
UPDATE products SET price = '3921' WHERE id = '758'
359 0.0001 8.4877014160156E-5
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid' AND area = 'header' ORDER BY sortorder ASC
360 0.0001 6.3180923461914E-5
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
361 0.0001 6.103515625E-5
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
362 0.0001 6.103515625E-5
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
363 0.0001 6.1988830566406E-5
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
364 0.0001 6.9141387939453E-5
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid' AND area = 'footer' ORDER BY sortorder ASC
365 0.0001 6.1988830566406E-5
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
366 0.0001 6.1988830566406E-5
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
367 0.0001 6.103515625E-5
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
368 0.0001 9.3936920166016E-5
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-fluid' AND skinuid = ''
369 0.0001 0.00010895729064941
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid'
370 0.0001 7.5101852416992E-5
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid'
371 0.0001 9.8943710327148E-5
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid' AND imageuid = 'HEAD_LOGO'
372 0.0001 0.00011205673217773
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-fluid' AND textuid = '' AND language = 'en'
373 0.0001 0.00013184547424316
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid' AND imageuid = 'HEAD_LOGO'