ParentCLIP20-ParentV3

Bouton de clic pour le prix
Non Disponible Épuisé
Le prix et la disponibilité du produit sont corrects en date du 2021-07-21 13:23:54 UTC et sont sujets à changements. Toute informaiton relative au prix ou à la disponibilité affichés pour https://www.amazon.fr/ au moment de la commande sera d'application lors de l'achat de ce produit.
CERTAINS ÉLÉMENTS DE CONTENU QUI APPARAISSENT SUR CE SITE PROVIENNENT DE AMAZON SERVICES LLC. CE CONTENU EST FOURNI TEL QUEL ET EST SUJET À CHANGEMENTS OU RETRAIT À TOUT MOMENT.

Debug Overview

App Total Time DB Queries DB Query Total Time Amazon Requests
5.7326610088348 243 0.1115 0


No Amazon API Requests Made.

Total time 5.7326610088348 seconds

Number Time From Start Name Description
1 2.0551698207855 Initialise Initialise FSB Function
2 2.0573518276215 App Controller Start Start of the App controller (called before the controller of every page)
3 2.0600709915161 Start of getCategoryListByGroup Function Before first category groups query
4 2.0603268146515 After initial query Before first category groups query
5 2.0603289604187 Get Category List for Group Before the call to getCategoryList function
6 2.0603318214417 Start of GetCategoryList function Start of the function
7 2.0603358745575 Before getting categories Query to get specific category list
8 2.0606780052185 After getting categories Query to get specific category list
9 2.0606799125671 Before getting category custom Before call to function getCategoryCustom
10 2.06294298172 After getting category custom After call to function getCategoryCustom
11 2.0629448890686 Before getting category custom Before call to function getCategoryCustom
12 2.0649809837341 After getting category custom After call to function getCategoryCustom
13 2.0649828910828 Before getting category custom Before call to function getCategoryCustom
14 2.0669708251953 After getting category custom After call to function getCategoryCustom
15 2.0669729709625 Before getting category custom Before call to function getCategoryCustom
16 2.0689308643341 After getting category custom After call to function getCategoryCustom
17 2.0689330101013 Before getting category custom Before call to function getCategoryCustom
18 2.0708208084106 After getting category custom After call to function getCategoryCustom
19 2.0708229541779 Before getting category custom Before call to function getCategoryCustom
20 2.0728089809418 After getting category custom After call to function getCategoryCustom
21 2.0728108882904 End of GetCategoryList function End of the function
22 2.0728168487549 End of getCategoryListByGroup Function Before return()
23 2.4186718463898 App Controller End End of the App controller (called before the controller of every page)
24 2.4765689373016 Product Start Start of the product info controller
25 2.5034058094025 Cache file not found Starting get product details
26 2.5171549320221 Related products Start getting related products if enabled
27 2.5171568393707 Related Products Start Before the related products are found
28 2.5171580314636 Related Products Keywords Before the related product keywords are found
29 2.5171618461609 Create Keyword List Function Start of function
30 2.5171768665314 Create Keyword List Function After looping provided content - 1 keywords found
31 2.5172219276428 Create Keyword List Function After looping initial keyword list - 1 keywords remaining
32 2.5172259807587 Create Keyword List Function After reducing keyword list
33 2.517226934433 Create Keyword List Function After selecting by scoring keywords
34 2.5172309875488 Create Keyword List Function After final loop of keywords
35 2.5172328948975 Related Products Keywords After the related product keywords are found
36 2.5560510158539 Related Products End After the related products are found
37 2.5636639595032 Product End End of the product info controller (Product Info)
38 2.594465970993 App_after Controller Start Start of the App_after controller (called after the controller of every page)
39 2.5950288772583 Before Get Options Before the call to getOptions in the tpl class
40 2.6371920108795 After Get Options After the call to getOptions in the tpl class
41 2.6372599601746 App_after Controller End End of the App_after controller (called after the controller of every page)
42 2.6372888088226 Product Info: Before Smarty Fetch Before the product.tpl template is fetched
43 4.1357250213623 Product Info: After Smarty Fetch After the product.tpl template is fetched
44 4.1357300281525 Product Info: Before Template Display Before the template is displayed
45 5.7326219081879 Product Info: After Template Display After the template is displayed
46 5.7326409816742 Finalizing debug Before the debug is output to the page.
47 5.7326598167419 End of App This is the end of the app logging, final timestamp


Query Debug - 243 Database Queries. Total time 0.1115 seconds

Number Time (Seconds) Time (Milliseconds) Query
1 0.0006 0.00060486793518066
SELECT parameter, value FROM parameters
2 0.0010 0.0010340213775635
SELECT * FROM `bad_bots`
3 0.0003 0.00032997131347656
SET time_zone = 'Europe/London'
4 0.0002 0.00024890899658203
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
5 0.0020 0.0020360946655273
INSERT INTO ga_users (`isbot`, `ips`) SELECT '1', 'a:1:{i:0;s:14:\"18.205.192.201\";}'
6 0.0026 0.0025849342346191
INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1628128856'
7 0.0004 0.0003969669342041
SELECT * FROM autorun ORDER BY lastrun ASC
8 0.0004 0.0004420280456543
SELECT * FROM version ORDER BY installed DESC LIMIT 1
9 0.0007 0.00067687034606934
SELECT id FROM pages WHERE pagename = 'parentclip20-parentv3' LIMIT 1
10 0.0007 0.00065803527832031
SELECT id FROM products WHERE pagename = 'parentclip20-parentv3' AND hidden = 0 LIMIT 1
11 0.0007 0.0006868839263916
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-smoothstore'
12 0.0009 0.00093793869018555
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND language = 'fr'
13 0.0006 0.00058984756469727
SELECT * FROM pages WHERE pagename = 'parentclip20-parentv3'
14 0.0002 0.000244140625
SELECT * FROM categorygroups ORDER BY sortorder ASC
15 0.0003 0.00032186508178711
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
16 0.0002 0.00023293495178223
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
17 0.0003 0.0002748966217041
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 26
18 0.0003 0.00025105476379395
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
19 0.0003 0.00025200843811035
SELECT id FROM categories WHERE parent_id = '26'
20 0.0002 0.00022292137145996
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 
21 0.0002 0.00022792816162109
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 
22 0.0002 0.00023293495178223
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (26)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
23 0.0002 0.00021100044250488
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
24 0.0002 0.00023603439331055
SELECT * FROM categorygroups WHERE id = '1'
25 0.0003 0.00026702880859375
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
26 0.0002 0.00024986267089844
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 27
27 0.0002 0.00020503997802734
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
28 0.0002 0.00021100044250488
SELECT id FROM categories WHERE parent_id = '27'
29 0.0002 0.0002131462097168
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (27)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
30 0.0002 0.00019216537475586
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (27)
				  AND p.disabled = 0 
31 0.0002 0.00021505355834961
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (27)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
32 0.0002 0.00019502639770508
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
33 0.0002 0.00019598007202148
SELECT * FROM categorygroups WHERE id = '1'
34 0.0002 0.00018787384033203
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
35 0.0002 0.00020408630371094
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 28
36 0.0002 0.00018715858459473
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
37 0.0002 0.00020790100097656
SELECT id FROM categories WHERE parent_id = '28'
38 0.0002 0.00022792816162109
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 
39 0.0002 0.00023293495178223
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 
40 0.0002 0.00021004676818848
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (28)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
41 0.0002 0.0002138614654541
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
42 0.0002 0.00022697448730469
SELECT * FROM categorygroups WHERE id = '1'
43 0.0002 0.00023198127746582
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
44 0.0002 0.00020503997802734
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 29
45 0.0002 0.00020885467529297
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
46 0.0003 0.00025105476379395
SELECT id FROM categories WHERE parent_id = '29'
47 0.0002 0.00018692016601562
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (29)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
48 0.0002 0.0001828670501709
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (29)
				  AND p.disabled = 0 
49 0.0002 0.0001990795135498
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (29)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
50 0.0002 0.00020289421081543
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
51 0.0002 0.00020217895507812
SELECT * FROM categorygroups WHERE id = '1'
52 0.0002 0.00018596649169922
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 30
53 0.0002 0.00018596649169922
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 30
54 0.0002 0.00020384788513184
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
55 0.0002 0.0002140998840332
SELECT id FROM categories WHERE parent_id = '30'
56 0.0002 0.00019311904907227
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (30)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
57 0.0002 0.00021004676818848
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (30)
				  AND p.disabled = 0 
58 0.0002 0.00020003318786621
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (30)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
59 0.0002 0.00019288063049316
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
60 0.0002 0.00021219253540039
SELECT * FROM categorygroups WHERE id = '1'
61 0.0002 0.00019598007202148
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 31
62 0.0002 0.00017499923706055
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 31
63 0.0002 0.00020408630371094
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31
64 0.0002 0.00019717216491699
SELECT id FROM categories WHERE parent_id = '31'
65 0.0002 0.00020790100097656
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (31)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
66 0.0003 0.00026082992553711
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (31)
				  AND p.disabled = 0 
67 0.0003 0.00026297569274902
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (31)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
68 0.0002 0.00019598007202148
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
69 0.0002 0.00019407272338867
SELECT * FROM categorygroups WHERE id = '1'
70 0.0003 0.00025391578674316
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
71 0.0003 0.00025606155395508
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-smoothstore' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
72 0.0004 0.00044012069702148
SELECT value FROM parameters WHERE parameter IN('EBAY_APP_ID' , 'EBAY_TRACKING_ID','EBAY_NETWORK_ID' , 'GOOGLE_SITE_KEY' , 'GOOGLE_SECRET_KEY' ,'GOOGLE_RECAPTCHA_TYPE','EBAY_AUTH_TOKEN','EBAY_LOCALE')ORDER BY parameter ASC
73 0.0003 0.00027799606323242
SELECT * FROM sideboxes_pages WHERE sidebox_id = '26'
74 0.0008 0.00079202651977539
SELECT value FROM template_options WHERE templateuid = 'fsb-smoothstore' AND optionuid = 'DISPLAY_CREDIT_ICON'
75 0.0007 0.00070905685424805
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
76 0.0002 0.00023102760314941
SELECT * FROM ipgeocountries WHERE INET_ATON('18.205.192.201') >= INET_ATON(ip_start) AND INET_ATON('18.205.192.201') <= INET_ATON(ip_end)
77 0.0002 0.00023698806762695
SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
78 0.0002 0.0002138614654541
SELECT * FROM countryredirects WHERE countrycode = 'US'
79 0.0010 0.0010190010070801
SELECT * FROM products WHERE pagename = 'parentclip20-parentv3'
80 0.0009 0.00087714195251465
UPDATE products SET viewcount = viewcount + 1 WHERE id = 3676
81 0.0003 0.00032901763916016
SELECT * FROM manufacturers WHERE id = '175'
82 0.0006 0.0006258487701416
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '175'
83 0.0002 0.00023102760314941
SELECT filename FROM manufacturerimages WHERE manufacturer_id = '175' LIMIT 1
84 0.0007 0.00066089630126953
SELECT p.pagename, p.id FROM products p, productimages i WHERE p.id = i.product_id AND manufacturer_id = '175' ORDER BY RAND() LIMIT 1
85 0.0002 0.00021910667419434
SELECT * FROM productimages WHERE product_id = '926' ORDER BY sortorder ASC
86 0.0002 0.00022101402282715
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '175'
87 0.0005 0.00049209594726562
SELECT COUNT(DISTINCT(p.id)) FROM products p
				WHERE p.manufacturer_id = '175'
				  AND p.hidden = 0
				  AND p.enabled = 1
				  AND p.parent_id = 0 
88 0.0003 0.00025796890258789
SELECT * FROM manufacturerimages WHERE manufacturer_id = '175'
89 0.0003 0.00033187866210938
SELECT category_id FROM products_categories WHERE product_id = '3676'
90 0.0002 0.00023698806762695
SELECT * FROM categories WHERE id = '27'
91 0.0002 0.00021195411682129
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
92 0.0002 0.00016903877258301
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
93 0.0002 0.00023794174194336
SELECT id FROM categories WHERE parent_id = '27'
94 0.0002 0.00017094612121582
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (27)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
95 0.0002 0.0001678466796875
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (27)
				  AND p.disabled = 0 
96 0.0002 0.00020194053649902
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (27)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
97 0.0002 0.00019598007202148
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
98 0.0015 0.001478910446167
SELECT * FROM productimages WHERE product_id = '3676' ORDER BY sortorder ASC
99 0.0004 0.00043511390686035
SELECT * FROM product_image_select WHERE product_id = '3676'
100 0.0003 0.00029683113098145
SELECT * FROM productcustomimages WHERE product_id = '3676'
101 0.0003 0.00027799606323242
SELECT * FROM productfeeds WHERE product_id = '3676' ORDER BY item_date DESC
102 0.0013 0.0012960433959961
SELECT a.name, n.displayname, a.value, n.units, n.valuetype FROM productattributes a, productattributenames n WHERE product_id = '3676' AND a.name = n.originalname AND n.display = 1 AND n.hidden = 0
103 0.0005 0.00046992301940918
SELECT DISTINCT(pt.tag_id) FROM product_tags pt, tags t WHERE pt.tag_id = t.id AND pt.product_id = '3676' AND t.hidden = 0 AND display_product = 1
104 0.0006 0.00064706802368164
SELECT * FROM productamazoncontent WHERE product_id = '3676'
105 0.0011 0.0010950565338135
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3676' AND a.name = n.originalname
106 0.0004 0.00037407875061035
SELECT * FROM productoffers WHERE product_id = '3676' AND merchantid = 'A1X6FK5RDHNB96'
107 0.0004 0.00040698051452637
SELECT * FROM productoffers
                WHERE product_id = '3676' AND price > 0
                ORDER BY price ASC LIMIT 1
108 0.0004 0.00042390823364258
SELECT * FROM productoffers
                WHERE product_id = 3676
                ORDER BY price ASC LIMIT 1
109 0.0004 0.00039196014404297
SELECT value FROM productattributes
                WHERE product_id = '3676'
                AND name = 'ListPriceAmount'
110 0.0004 0.00038599967956543
SELECT value FROM productattributes WHERE product_id = '3676' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
111 0.0002 0.00019502639770508
SELECT value FROM parameters WHERE parameter IN('EBAY_APP_ID' , 'EBAY_TRACKING_ID','EBAY_NETWORK_ID' , 'GOOGLE_SITE_KEY' , 'GOOGLE_SECRET_KEY' ,'GOOGLE_RECAPTCHA_TYPE','EBAY_AUTH_TOKEN','EBAY_LOCALE')ORDER BY parameter ASC
112 0.0080 0.0079560279846191
SELECT *, MATCH (description, title) AGAINST ('parentclip20-parentv3' IN BOOLEAN MODE) AS `searchrelevance` FROM products WHERE MATCH (description, title) AGAINST ('parentclip20-parentv3' IN BOOLEAN MODE) AND 3676 <> 0 AND enabled = 1 AND hidden = 0 AND offers > 0 AND parent_id = 0 ORDER BY `searchrelevance` LIMIT 3
113 0.0006 0.00059294700622559
SELECT *, MATCH (description, title) AGAINST ('parentclip20-parentv3' IN BOOLEAN MODE) AS `searchrelevance` FROM ebay_products WHERE MATCH (description, title) AGAINST ('parentclip20-parentv3' IN BOOLEAN MODE) AND 3676 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 3
114 0.0006 0.00058603286743164
SELECT *, MATCH (description, title) AGAINST ('parentclip20-parentv3' IN BOOLEAN MODE) AS `searchrelevance` FROM custom_products WHERE MATCH (description, title) AGAINST ('parentclip20-parentv3' IN BOOLEAN MODE) AND 3676 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 3
115 0.0015 0.0015311241149902
SELECT categories.id, COUNT(*) as productcount FROM products_categories, categories WHERE categories.id IN (SELECT category_id FROM products_categories WHERE product_id = '3676') AND products_categories.category_id = categories.id GROUP BY categories.id ORDER BY productcount ASC
116 0.0138 0.013762950897217
SELECT p.* FROM products p, products_categories pc WHERE p.parent_id = 0 AND p.id = pc.product_id AND pc.category_id = '27' AND pc.prod_type = 'amz'  AND p.id <> '3676' ORDER BY RAND()
117 0.0006 0.00058293342590332
SELECT p.* FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND pc.category_id = '27' AND pc.prod_type = 'ebay' AND p.id <> '3676' ORDER BY RAND()
118 0.0005 0.00052189826965332
SELECT p.* FROM custom_products p, products_categories pc WHERE p.id = pc.product_id AND pc.category_id = '27' AND pc.prod_type = 'custom' AND p.id <> '3676' ORDER BY RAND()
119 0.0004 0.00040507316589355
SELECT * FROM productimages WHERE product_id = '1061' ORDER BY sortorder ASC
120 0.0002 0.00021791458129883
SELECT * FROM product_image_select WHERE product_id = '1061'
121 0.0002 0.00021696090698242
SELECT * FROM productcustomimages WHERE product_id = '1061'
122 0.0002 0.00021600723266602
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1061' AND a.name = n.originalname
123 0.0004 0.00035595893859863
SELECT * FROM productoffers WHERE product_id = '1061' AND merchantid = 'A1X6FK5RDHNB96'
124 0.0005 0.00045299530029297
SELECT * FROM productoffers
                WHERE product_id = '1061' AND price > 0
                ORDER BY price ASC LIMIT 1
125 0.0002 0.00019598007202148
SELECT value FROM productattributes WHERE product_id = '1061' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
126 0.0015 0.001460075378418
SELECT * FROM productimages WHERE product_id = '884' ORDER BY sortorder ASC
127 0.0004 0.00035595893859863
SELECT * FROM product_image_select WHERE product_id = '884'
128 0.0004 0.00038003921508789
SELECT * FROM productcustomimages WHERE product_id = '884'
129 0.0015 0.0015361309051514
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '884' AND a.name = n.originalname
130 0.0004 0.00041508674621582
SELECT * FROM productoffers WHERE product_id = '884' AND merchantid = 'A1X6FK5RDHNB96'
131 0.0005 0.00045299530029297
SELECT * FROM productoffers
                WHERE product_id = '884' AND price > 0
                ORDER BY price ASC LIMIT 1
132 0.0004 0.00044083595275879
SELECT * FROM productoffers
                WHERE product_id = 884
                ORDER BY price ASC LIMIT 1
133 0.0004 0.00041604042053223
SELECT value FROM productattributes
                WHERE product_id = '884'
                AND name = 'ListPriceAmount'
134 0.0004 0.00037193298339844
SELECT value FROM productattributes WHERE product_id = '884' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
135 0.0002 0.00019693374633789
SELECT * FROM productimages WHERE product_id = '2381' ORDER BY sortorder ASC
136 0.0002 0.0001990795135498
SELECT * FROM product_image_select WHERE product_id = '2381'
137 0.0002 0.00018215179443359
SELECT * FROM productcustomimages WHERE product_id = '2381'
138 0.0002 0.00019001960754395
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2381' AND a.name = n.originalname
139 0.0005 0.00050497055053711
SELECT * FROM productoffers WHERE product_id = '2381' AND merchantid = 'A1X6FK5RDHNB96'
140 0.0004 0.00044488906860352
SELECT * FROM productoffers
                WHERE product_id = '2381' AND price > 0
                ORDER BY price ASC LIMIT 1
141 0.0004 0.00042891502380371
SELECT * FROM productoffers
                WHERE product_id = 2381
                ORDER BY price ASC LIMIT 1
142 0.0002 0.00023317337036133
SELECT value FROM productattributes
                WHERE product_id = '2381'
                AND name = 'ListPriceAmount'
143 0.0002 0.00019407272338867
SELECT value FROM productattributes WHERE product_id = '2381' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
144 0.0004 0.00037097930908203
SELECT id,asin FROM products WHERE parent_id = 3676
145 0.0002 0.00021886825561523
SELECT category_id FROM products_categories WHERE product_id = '3676'
146 0.0003 0.00029802322387695
SELECT * FROM categories WHERE id = '27'
147 0.0002 0.0001671314239502
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
148 0.0002 0.00018906593322754
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
149 0.0002 0.00017714500427246
SELECT id FROM categories WHERE parent_id = '27'
150 0.0002 0.0001978874206543
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (27)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
151 0.0002 0.00018787384033203
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (27)
				  AND p.disabled = 0 
152 0.0002 0.00022792816162109
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (27)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
153 0.0002 0.00015997886657715
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
154 0.0002 0.00017905235290527
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3676' AND a.name = n.originalname
155 0.0002 0.00020194053649902
SELECT * FROM productoffers WHERE product_id = '3676' AND merchantid = 'A1X6FK5RDHNB96'
156 0.0002 0.00018596649169922
SELECT * FROM productoffers
                WHERE product_id = '3676' AND price > 0
                ORDER BY price ASC LIMIT 1
157 0.0002 0.00018811225891113
SELECT * FROM productoffers
                WHERE product_id = 3676
                ORDER BY price ASC LIMIT 1
158 0.0002 0.00018310546875
SELECT value FROM productattributes
                WHERE product_id = '3676'
                AND name = 'ListPriceAmount'
159 0.0005 0.00051307678222656
SELECT * FROM products WHERE id = '3676'
160 0.0002 0.00023388862609863
SELECT value FROM productattributes WHERE product_id = '3676' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
161 0.0002 0.00020384788513184
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3676' AND a.name = n.originalname
162 0.0002 0.00024509429931641
SELECT * FROM productoffers WHERE product_id = '3676' AND merchantid = 'A1X6FK5RDHNB96'
163 0.0002 0.00019097328186035
SELECT * FROM productoffers
                WHERE product_id = '3676' AND price > 0
                ORDER BY price ASC LIMIT 1
164 0.0002 0.00020885467529297
SELECT * FROM productoffers
                WHERE product_id = 3676
                ORDER BY price ASC LIMIT 1
165 0.0002 0.00020790100097656
SELECT value FROM productattributes
                WHERE product_id = '3676'
                AND name = 'ListPriceAmount'
166 0.0003 0.00028109550476074
SELECT category_id FROM products_categories WHERE product_id = '3676' AND prod_type = 'amz'
167 0.0002 0.00020694732666016
SELECT parent_id FROM categories WHERE id = '27'
168 0.0002 0.00023603439331055
SELECT * FROM categories WHERE id = '27'
169 0.0002 0.00016307830810547
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
170 0.0002 0.00019979476928711
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
171 0.0002 0.00021505355834961
SELECT id FROM categories WHERE parent_id = '27'
172 0.0002 0.00020694732666016
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (27)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
173 0.0002 0.00020480155944824
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (27)
				  AND p.disabled = 0 
174 0.0002 0.00024199485778809
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (27)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
175 0.0002 0.00021505355834961
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
176 0.0005 0.00049304962158203
SELECT * FROM template_info WHERE templateuid = 'fsb-smoothstore'
177 0.0003 0.00025582313537598
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_user_data'
178 0.0002 0.0002291202545166
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_tracking_status'
179 0.0003 0.00030207633972168
SELECT * FROM pages WHERE id = 38
180 0.0056 0.0055792331695557
SELECT DISTINCT p.id FROM products p, productoffers o
            WHERE p.id IN (SELECT product_id FROM productoffers WHERE 1 ) OR p.parent_id IN (SELECT product_id FROM productoffers WHERE 1 ) AND p.parent_id = 0 LIMIT 6
181 0.0006 0.00057291984558105
UPDATE template_options SET value = 'a:10:{s:14:\"populationtype\";s:9:\"automatic\";s:12:\"productcount\";s:1:\"6\";s:12:\"maxsalesrank\";s:0:\"\";s:8:\"minprice\";s:1:\"0\";s:8:\"maxprice\";s:1:\"0\";s:9:\"minimages\";s:0:\"\";s:10:\"updatetime\";s:1:\"0\";s:13:\"selectiontype\";s:6:\"random\";s:11:\"lastupdated\";i:1628128858;s:8:\"products\";a:6:{i:0;s:10:\"790|amazon\";i:1;s:10:\"788|amazon\";i:2;s:10:\"787|amazon\";i:3;s:11:\"1287|amazon\";i:4;s:10:\"777|amazon\";i:5;s:10:\"776|amazon\";}}' WHERE id = '160'
182 0.0006 0.00061511993408203
SELECT * FROM products WHERE id = 790
183 0.0007 0.00067615509033203
SELECT * FROM products WHERE id = 788
184 0.0007 0.00071191787719727
SELECT * FROM products WHERE id = 787
185 0.0006 0.00062918663024902
SELECT * FROM products WHERE id = 1287
186 0.0006 0.00057888031005859
SELECT * FROM products WHERE id = 777
187 0.0005 0.00053691864013672
SELECT * FROM products WHERE id = 776
188 0.0004 0.00041890144348145
SELECT * FROM products WHERE id = '790'
189 0.0004 0.00039315223693848
SELECT * FROM productimages WHERE product_id = '790' ORDER BY sortorder ASC
190 0.0002 0.00021696090698242
SELECT * FROM product_image_select WHERE product_id = '790'
191 0.0002 0.00017905235290527
SELECT * FROM productcustomimages WHERE product_id = '790'
192 0.0002 0.00024199485778809
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '790' AND a.name = n.originalname
193 0.0002 0.00018787384033203
SELECT * FROM productoffers WHERE product_id = '790' AND merchantid = 'A1X6FK5RDHNB96'
194 0.0003 0.00025081634521484
SELECT * FROM productoffers
                WHERE product_id = '790' AND price > 0
                ORDER BY price ASC LIMIT 1
195 0.0003 0.00030612945556641
SELECT value FROM productattributes WHERE product_id = '790' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
196 0.0004 0.00041985511779785
SELECT * FROM products WHERE id = '788'
197 0.0002 0.0001978874206543
SELECT * FROM productimages WHERE product_id = '788' ORDER BY sortorder ASC
198 0.0003 0.00025200843811035
SELECT * FROM product_image_select WHERE product_id = '788'
199 0.0002 0.00022602081298828
SELECT * FROM productcustomimages WHERE product_id = '788'
200 0.0002 0.00019502639770508
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '788' AND a.name = n.originalname
201 0.0002 0.00021219253540039
SELECT * FROM productoffers WHERE product_id = '788' AND merchantid = 'A1X6FK5RDHNB96'
202 0.0002 0.00022697448730469
SELECT * FROM productoffers
                WHERE product_id = '788' AND price > 0
                ORDER BY price ASC LIMIT 1
203 0.0002 0.00023102760314941
SELECT value FROM productattributes WHERE product_id = '788' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
204 0.0004 0.00042200088500977
SELECT * FROM products WHERE id = '787'
205 0.0002 0.00018811225891113
SELECT * FROM productimages WHERE product_id = '787' ORDER BY sortorder ASC
206 0.0002 0.00019311904907227
SELECT * FROM product_image_select WHERE product_id = '787'
207 0.0002 0.00017809867858887
SELECT * FROM productcustomimages WHERE product_id = '787'
208 0.0002 0.0002439022064209
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '787' AND a.name = n.originalname
209 0.0002 0.00019216537475586
SELECT * FROM productoffers WHERE product_id = '787' AND merchantid = 'A1X6FK5RDHNB96'
210 0.0002 0.00021505355834961
SELECT * FROM productoffers
                WHERE product_id = '787' AND price > 0
                ORDER BY price ASC LIMIT 1
211 0.0002 0.00020408630371094
SELECT value FROM productattributes WHERE product_id = '787' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
212 0.0004 0.00041007995605469
SELECT * FROM products WHERE id = '1287'
213 0.0004 0.00039196014404297
SELECT * FROM productimages WHERE product_id = '1287' ORDER BY sortorder ASC
214 0.0002 0.00017881393432617
SELECT * FROM product_image_select WHERE product_id = '1287'
215 0.0002 0.00018405914306641
SELECT * FROM productcustomimages WHERE product_id = '1287'
216 0.0002 0.00020384788513184
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1287' AND a.name = n.originalname
217 0.0002 0.00022697448730469
SELECT * FROM productoffers WHERE product_id = '1287' AND merchantid = 'A1X6FK5RDHNB96'
218 0.0002 0.00020194053649902
SELECT * FROM productoffers
                WHERE product_id = '1287' AND price > 0
                ORDER BY price ASC LIMIT 1
219 0.0003 0.00034880638122559
SELECT value FROM productattributes WHERE product_id = '1287' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
220 0.0004 0.00039315223693848
SELECT * FROM products WHERE id = '777'
221 0.0002 0.00018191337585449
SELECT * FROM productimages WHERE product_id = '777' ORDER BY sortorder ASC
222 0.0002 0.00018596649169922
SELECT * FROM product_image_select WHERE product_id = '777'
223 0.0002 0.00018501281738281
SELECT * FROM productcustomimages WHERE product_id = '777'
224 0.0002 0.00019097328186035
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '777' AND a.name = n.originalname
225 0.0002 0.00020503997802734
SELECT * FROM productoffers WHERE product_id = '777' AND merchantid = 'A1X6FK5RDHNB96'
226 0.0003 0.00026798248291016
SELECT * FROM productoffers
                WHERE product_id = '777' AND price > 0
                ORDER BY price ASC LIMIT 1
227 0.0003 0.00032806396484375
SELECT value FROM productattributes WHERE product_id = '777' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
228 0.0004 0.00041103363037109
SELECT * FROM products WHERE id = '776'
229 0.0004 0.00042605400085449
SELECT * FROM productimages WHERE product_id = '776' ORDER BY sortorder ASC
230 0.0002 0.00019192695617676
SELECT * FROM product_image_select WHERE product_id = '776'
231 0.0002 0.00018191337585449
SELECT * FROM productcustomimages WHERE product_id = '776'
232 0.0002 0.00020980834960938
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '776' AND a.name = n.originalname
233 0.0003 0.00025582313537598
SELECT * FROM productoffers WHERE product_id = '776' AND merchantid = 'A1X6FK5RDHNB96'
234 0.0002 0.00022697448730469
SELECT * FROM productoffers
                WHERE product_id = '776' AND price > 0
                ORDER BY price ASC LIMIT 1
235 0.0002 0.00021481513977051
SELECT value FROM productattributes WHERE product_id = '776' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
236 0.0003 0.00033402442932129
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND area = 'header' ORDER BY sortorder ASC
237 0.0003 0.00030899047851562
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND area = 'footer' ORDER BY sortorder ASC
238 0.0005 0.00054287910461426
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND skinuid = ''
239 0.0004 0.00042414665222168
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-smoothstore'
240 0.0004 0.00042009353637695
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-smoothstore'
241 0.0003 0.0003359317779541
SELECT * FROM template_images WHERE templateuid = 'fsb-smoothstore' AND imageuid = 'HEAD_LOGO'
242 0.0005 0.00048208236694336
SELECT * FROM template_images WHERE templateuid = 'fsb-smoothstore' AND imageuid = 'HEAD_LOGO'
243 0.0004 0.00043106079101562
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND textuid = 'SIDEBAR_BASKET_TITLE' AND language = 'en'