Debug Overview

App Total Time DB Queries DB Query Total Time Amazon Requests
0.52862477302551 302 0.1143 0


No Amazon API Requests Made.


App Debug - Total Time 0.52862477302551 seconds

Number Time From Start Name Description
1 0.29776978492737 Initialise Initialise FSB Function
2 0.29998183250427 App Controller Start Start of the App controller (called before the controller of every page)
3 0.3604838848114 App Controller End End of the App controller (called before the controller of every page)
4 0.36166191101074 Category Start Start of the category controller
5 0.36166381835938 Before Get Category Before getting the category information
6 0.36491680145264 After Get Category After getting the category information
7 0.36491799354553 Before Get Category List Before getting the updated category list
8 0.36503100395203 Start of getCategoryListByGroup Function Before first category groups query
9 0.36512899398804 After initial query Before first category groups query
10 0.36512994766235 Get Category List for Group Before the call to getCategoryList function
11 0.36513185501099 Start of GetCategoryList function Start of the function
12 0.3651340007782 Before getting categories Query to get specific category list
13 0.36529493331909 After getting categories Query to get specific category list
14 0.36529493331909 Before getting category custom Before call to function getCategoryCustom
15 0.36647891998291 After getting category custom After call to function getCategoryCustom
16 0.36648178100586 Before getting category custom Before call to function getCategoryCustom
17 0.36776995658875 After getting category custom After call to function getCategoryCustom
18 0.36777091026306 Before getting category custom Before call to function getCategoryCustom
19 0.36913585662842 After getting category custom After call to function getCategoryCustom
20 0.36913800239563 Before getting category custom Before call to function getCategoryCustom
21 0.37036395072937 After getting category custom After call to function getCategoryCustom
22 0.37036490440369 Before getting sub category list Before call to recursive function getCategoryList
23 0.370365858078 Start of GetCategoryList function Start of the function
24 0.37036800384521 Before getting categories Query to get specific category list
25 0.37049198150635 After getting sub category list After call to recursive function getCategoryList
26 0.37049198150635 End of GetCategoryList function End of the function
27 0.37049579620361 Get Category List for Group Before the call to getCategoryList function
28 0.37049698829651 Start of GetCategoryList function Start of the function
29 0.37049794197083 Before getting categories Query to get specific category list
30 0.37063097953796 End of getCategoryListByGroup Function Before return()
31 0.3706328868866 After Get Category List After getting the updated category list
32 0.3706328868866 Before Category Images Before getting the category images
33 0.37072777748108 After Category Images After getting the category images
34 0.3711678981781 Before Sub Category Check Before checking for sub category or products category
35 0.37127995491028 Before Category Products Controller Before loading the category products controller
36 0.37202095985413 Start Category Products Start of Category Products Controller
37 0.37203598022461 After Pagination Options After pagination options in Category Products Controller
38 0.37253093719482 After Cache After Cache checking in Category Products Controller
39 0.37510991096497 After Filter Options After getting filter options and SQL in Category Products Controller
40 0.37549185752869 After Counting Products After counting products in the Category Products Controller
41 0.37559485435486 After Counting Bundles After counting bundles in the Category Products Controller
42 0.3757050037384 After Counting Products After counting products in the Category Products Controller
43 0.37635278701782 After Getting Products After getting products and bundles in the Category Products Controller
44 0.37638998031616 After Pagination Links After getting pagination listing links in the Category Products Controller
45 0.37638998031616 After Getting Bundle Details After getting full details for the bundles in the Category Products Controller
46 0.39796590805054 After Getting Product Details After getting full product details in the Category Products Controller
47 0.39927983283997 After Getting Product/Bundle Reviews After getting full product/bundle customer review in the Category Products Controller
48 0.40042591094971 App_after Controller Start Start of the App_after controller (called after the controller of every page)
49 0.40071392059326 Before Get Options Before the call to getOptions in the tpl class
50 0.41878080368042 After Get Options After the call to getOptions in the tpl class
51 0.41894483566284 App_after Controller End End of the App_after controller (called after the controller of every page)
52 0.41898679733276 Before Smarty Before passing everything over to Smarty in the Category Products Controller
53 0.52861094474792 After Loading sub/product controller After checking for sub category or products category and then loading the relevant controller
54 0.52861380577087 Finalizing debug Before the debug is output to the page.
55 0.52862477302551 End of App This is the end of the app logging, final timestamp


Query Debug - 302 Database Queries. Total time 0.1143 seconds

Number Time (Seconds) Time (Milliseconds) Query
1 0.0003 0.00032901763916016
SELECT parameter, value FROM parameters
2 0.0010 0.0010199546813965
SELECT * FROM `bad_bots`
3 0.0002 0.00017094612121582
SET time_zone = 'Europe/London'
4 0.0002 0.00021696090698242
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
5 0.0007 0.00065493583679199
INSERT INTO ga_users (`isbot`, `ips`) SELECT '1', 'a:1:{i:0;s:13:\"3.231.230.177\";}'
6 0.0006 0.00057387351989746
INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1628149002'
7 0.0004 0.00039982795715332
SELECT * FROM autorun ORDER BY lastrun ASC
8 0.0004 0.00038385391235352
UPDATE autorun SET lastrun = '2021-08-05 07:36:42' WHERE id = '16'
9 0.0001 0.0001070499420166
SELECT * FROM version ORDER BY installed DESC LIMIT 1
10 0.0002 0.00018501281738281
SELECT id FROM pages WHERE pagename = 'lawyer-gift-mugs' LIMIT 1
11 0.0004 0.00042295455932617
SELECT id FROM products WHERE pagename = 'lawyer-gift-mugs' AND hidden = 0 LIMIT 1
12 0.0004 0.00037503242492676
SELECT id FROM ebay_products WHERE pagename = 'lawyer-gift-mugs'
13 0.0001 0.00014615058898926
SELECT id FROM custom_products WHERE pagename = 'lawyer-gift-mugs'
14 0.0004 0.0003969669342041
SELECT id FROM categories WHERE pagename = 'lawyer-gift-mugs' LIMIT 1
15 0.0004 0.00040006637573242
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-fluid'
16 0.0057 0.0057339668273926
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-fluid' AND language = 'en'
17 0.0002 0.00015997886657715
SELECT * FROM pages WHERE pagename = 'lawyer-gift-mugs'
18 0.0009 0.00091886520385742
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
19 0.0005 0.00047802925109863
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-fluid' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
20 0.0002 0.00022196769714355
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
21 0.0002 0.00021815299987793
SELECT value FROM template_options WHERE templateuid = 'fsb-fluid' AND optionuid = 'DISPLAY_CREDIT_ICON'
22 0.0004 0.00037717819213867
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
23 0.0489 0.048918962478638
SELECT * FROM ipgeocountries WHERE INET_ATON('3.231.230.177') >= INET_ATON(ip_start) AND INET_ATON('3.231.230.177') <= INET_ATON(ip_end)
24 0.0009 0.00091791152954102
SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
25 0.0004 0.00037598609924316
SELECT * FROM countryredirects WHERE countrycode = 'US'
26 0.0002 0.0001988410949707
SELECT * FROM categories WHERE pagename = 'lawyer-gift-mugs'
27 0.0004 0.00036382675170898
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
28 0.0001 0.00014495849609375
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 38
29 0.0001 9.9897384643555E-5
SELECT id FROM categories WHERE parent_id = '38'
30 0.0003 0.00026082992553711
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 
31 0.0002 0.00015711784362793
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 
32 0.0001 0.00011110305786133
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (38)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
33 0.0001 0.0001220703125
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '38'
34 0.0001 8.8930130004883E-5
SELECT id FROM categories WHERE parent_id = '38'
35 0.0003 0.00026798248291016
SELECT p.id FROM products p, products_categories c WHERE p.id = c.product_id AND c.category_id IN (38) AND p.hidden = 0 AND p.salesrank > 0 AND (p.price > 0 OR p.parent = 1) ORDER BY p.salesrank ASC LIMIT 1
36 0.0006 0.00061583518981934
SELECT * FROM productimages WHERE product_id = '7004' ORDER BY sortorder ASC
37 0.0001 0.00014996528625488
SELECT * FROM categoryimages WHERE category_id = 38
38 0.0001 0.00012803077697754
SELECT * FROM categorygroups WHERE id = '1'
39 0.0002 0.00023722648620605
SELECT MIN(p.price) as minprice, MAX(p.price) as maxprice
		FROM products p, products_categories c
		WHERE p.id = c.product_id
		  AND c.category_id = '38'
		  AND p.offers > 0
		  AND p.hidden = 0
		  AND p.enabled = 1
		  AND p.parent = 0
		  AND p.price > 0
40 0.0001 8.702278137207E-5
SELECT parent_id FROM categories WHERE id = '38'
41 0.0001 9.5129013061523E-5
SELECT parent_id FROM categories WHERE id = '38'
42 0.0001 8.702278137207E-5
SELECT * FROM categorygroups ORDER BY sortorder ASC
43 0.0001 0.00013589859008789
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
44 0.0002 0.00020599365234375
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
45 0.0001 0.00011205673217773
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 27
46 0.0001 7.2002410888672E-5
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
47 0.0001 9.0122222900391E-5
SELECT id FROM categories WHERE parent_id = '27'
48 0.0002 0.00023913383483887
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 
49 0.0001 8.6784362792969E-5
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 
50 0.0001 0.00011420249938965
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
51 0.0001 7.1048736572266E-5
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
52 0.0001 8.3208084106445E-5
SELECT * FROM categorygroups WHERE id = '1'
53 0.0003 0.0002589225769043
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
54 0.0001 0.0001060962677002
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 29
55 0.0001 6.9856643676758E-5
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
56 0.0001 8.8930130004883E-5
SELECT id FROM categories WHERE parent_id = '29'
57 0.0003 0.00028896331787109
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 
58 0.0001 9.1075897216797E-5
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 
59 0.0001 0.00010514259338379
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
60 0.0001 7.2002410888672E-5
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
61 0.0001 8.392333984375E-5
SELECT * FROM categorygroups WHERE id = '1'
62 0.0003 0.0003199577331543
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
63 0.0001 0.00010108947753906
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 30
64 0.0001 8.1062316894531E-5
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
65 0.0001 8.2015991210938E-5
SELECT id FROM categories WHERE parent_id = '30'
66 0.0003 0.00032186508178711
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 
67 0.0001 8.8930130004883E-5
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 
68 0.0001 0.00010108947753906
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
69 0.0001 8.392333984375E-5
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
70 0.0001 8.2969665527344E-5
SELECT * FROM categorygroups WHERE id = '1'
71 0.0002 0.0001978874206543
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
72 0.0001 0.00010204315185547
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 38
73 0.0002 0.00017881393432617
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 38
74 0.0001 8.2969665527344E-5
SELECT id FROM categories WHERE parent_id = '38'
75 0.0002 0.00022506713867188
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 
76 0.0001 8.4161758422852E-5
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (38)
				  AND p.disabled = 0 
77 0.0001 9.8943710327148E-5
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (38)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
78 0.0001 7.1048736572266E-5
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '38'
79 0.0001 9.4890594482422E-5
SELECT * FROM categorygroups WHERE id = '1'
80 0.0001 0.00011491775512695
SELECT * FROM categories WHERE parent_id = '38'  AND hidden = 0 ORDER BY sortorder ASC
81 0.0001 0.00012397766113281
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '2'  AND hidden = 0 ORDER BY sortorder ASC
82 0.0001 8.702278137207E-5
SELECT * FROM categoryimages WHERE category_id = 38
83 0.0004 0.00040507316589355
SELECT * FROM template_info WHERE templateuid = 'fsb-fluid'
84 0.0001 0.00010108947753906
SELECT * FROM categories WHERE parent_id = '38'
85 0.0005 0.00051188468933105
SELECT MAX(price) as maxprice, MIN(price) as minprice FROM products WHERE enabled = 1 AND hidden = 0 AND price <> 0 
86 0.0005 0.0005030632019043
SELECT * FROM manufacturers WHERE display_filter = 1 AND merge_manufacturer_id = 0 ORDER BY name
87 0.0002 0.0001978874206543
SELECT * FROM productattributenames n WHERE hidden = 0 AND metabrowse = 1 ORDER BY n.displayname ASC
88 0.0005 0.00051093101501465
SELECT MAX(price) as maxprice, MIN(price) as minprice FROM products WHERE enabled = 1 AND hidden = 0 AND price <> 0 
89 0.0005 0.00048494338989258
SELECT * FROM manufacturers WHERE display_filter = 1 AND merge_manufacturer_id = 0 ORDER BY name
90 0.0001 0.00013399124145508
SELECT * FROM productattributenames n WHERE hidden = 0 AND metabrowse = 1 AND sidebarfilter = 1 ORDER BY n.displayname ASC
91 0.0003 0.00025296211242676
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
		WHERE p.id = c.product_id AND parent_id = 0
		AND c.category_id = 38
		AND (c.prod_type = '' OR c.prod_type = 'amz')
		AND hidden = 0
		AND enabled = 1
		
		AND 1 = 1
92 0.0001 0.00010895729064941
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
		WHERE ep.id = c.product_id
		AND c.category_id = 38
		AND c.prod_type = 'ebay'
		AND hide = 0
93 0.0001 8.8930130004883E-5
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
			WHERE p.id = c.bundle_id AND parent_id = 0
			AND c.category_id = 38
			AND p.disabled = 0
			
			AND 1 = 1
94 0.0001 0.00010013580322266
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
		WHERE cp.id = c.product_id
		AND c.category_id = 38
		AND c.prod_type = 'custom'
		AND hide = 0
95 0.0006 0.00059390068054199
SELECT DISTINCT (p.id), IF(p.salesrank <> 0, p.salesrank, 100000) AS salesrank, p.price, p.linktitle, p.pagename, 'product' AS type FROM products p, products_categories c
			WHERE p.id = c.product_id
			AND p.parent_id = 0
			AND c.category_id = 38
			AND hidden = 0
			AND enabled = 1
			
			AND 1 = 1 UNION SELECT DISTINCT (p.id), IF(p.salesrank <> 0, p.salesrank, 100000) AS salesrank, p.price, p.linktitle, p.pagename, 'ebay' AS type FROM ebay_products p, products_categories c
		WHERE p.id = c.product_id
		AND c.category_id = 38
		AND c.prod_type = 'ebay'
		AND p.hide = 0 UNION SELECT DISTINCT (p.id), IF(p.salesrank <> 0, p.salesrank, 100000) AS salesrank, p.price, p.linktitle, p.pagename, 'custom' AS type FROM custom_products p, products_categories c
		WHERE p.id = c.product_id
		AND c.category_id = 38
		AND c.prod_type = 'custom'
		AND p.hide = 0 UNION SELECT DISTINCT (p.id), IF(p.salesrank <> 0, p.salesrank, 100000) AS salesrank, p.price, p.linktitle, p.pagename, 'bundle' AS type FROM bundles p, bundle_categories c
			WHERE p.id = c.bundle_id
			AND c.category_id = 38
			AND disabled = 0
			
			AND 1 = 1 ORDER BY salesrank ASC LIMIT 0, 18
96 0.0002 0.00015401840209961
SELECT * FROM products WHERE id = '7004'
97 0.0001 0.00014281272888184
SELECT * FROM productimages WHERE product_id = '7004' ORDER BY sortorder ASC
98 0.0002 0.00020098686218262
SELECT * FROM product_image_select WHERE product_id = '7004'
99 0.0002 0.00015711784362793
SELECT * FROM productcustomimages WHERE product_id = '7004'
100 0.0008 0.00076794624328613
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '7004' AND a.name = n.originalname
101 0.0002 0.00018095970153809
SELECT * FROM productoffers WHERE product_id = '7004' AND merchantid = 'ATVPDKIKX0DER'
102 0.0001 0.00012683868408203
SELECT * FROM productoffers
                WHERE product_id = '7004' AND price > 0
                ORDER BY price ASC LIMIT 1
103 0.0002 0.00016403198242188
SELECT value FROM productattributes WHERE product_id = '7004' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
104 0.0001 0.00014209747314453
SELECT * FROM products WHERE id = '6999'
105 0.0004 0.00039911270141602
SELECT * FROM productimages WHERE product_id = '6999' ORDER BY sortorder ASC
106 0.0002 0.00015997886657715
SELECT * FROM product_image_select WHERE product_id = '6999'
107 0.0001 0.00010395050048828
SELECT * FROM productcustomimages WHERE product_id = '6999'
108 0.0010 0.0010039806365967
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '6999' AND a.name = n.originalname
109 0.0001 0.00011491775512695
SELECT * FROM productoffers WHERE product_id = '6999' AND merchantid = 'ATVPDKIKX0DER'
110 0.0001 0.00014185905456543
SELECT * FROM productoffers
                WHERE product_id = '6999' AND price > 0
                ORDER BY price ASC LIMIT 1
111 0.0002 0.00017595291137695
SELECT value FROM productattributes WHERE product_id = '6999' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
112 0.0001 0.00012803077697754
SELECT * FROM products WHERE id = '7007'
113 0.0001 0.00014090538024902
SELECT * FROM productimages WHERE product_id = '7007' ORDER BY sortorder ASC
114 0.0001 0.00014686584472656
SELECT * FROM product_image_select WHERE product_id = '7007'
115 0.0001 0.00010204315185547
SELECT * FROM productcustomimages WHERE product_id = '7007'
116 0.0013 0.0012650489807129
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '7007' AND a.name = n.originalname
117 0.0001 0.00011491775512695
SELECT * FROM productoffers WHERE product_id = '7007' AND merchantid = 'ATVPDKIKX0DER'
118 0.0001 0.00012707710266113
SELECT * FROM productoffers
                WHERE product_id = '7007' AND price > 0
                ORDER BY price ASC LIMIT 1
119 0.0002 0.00016403198242188
SELECT value FROM productattributes WHERE product_id = '7007' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
120 0.0002 0.00016498565673828
SELECT * FROM products WHERE id = '7045'
121 0.0001 0.00011587142944336
SELECT * FROM productimages WHERE product_id = '7045' ORDER BY sortorder ASC
122 0.0002 0.00015711784362793
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '7045' AND p.id = pi.product_id ORDER BY pi.sortorder
123 0.0002 0.0001530647277832
SELECT * FROM product_image_select WHERE product_id = '7045'
124 0.0001 0.0001070499420166
SELECT * FROM productcustomimages WHERE product_id = '7045'
125 0.0001 0.00014877319335938
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 = '7045'
                GROUP BY o.product_id
126 0.0003 0.0002899169921875
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     = '7045'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
127 0.0001 0.00012803077697754
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 7045
128 0.0004 0.00038719177246094
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '7045' AND a.name = n.originalname
129 0.0001 9.918212890625E-5
SELECT * FROM productoffers WHERE product_id = '7045' AND merchantid = 'ATVPDKIKX0DER'
130 0.0001 0.00011706352233887
SELECT * FROM productoffers
                WHERE product_id = '7045' AND price > 0
                ORDER BY price ASC LIMIT 1
131 0.0001 0.00010800361633301
SELECT * FROM productoffers
                WHERE product_id = 7045
                ORDER BY price ASC LIMIT 1
132 0.0001 0.00011014938354492
SELECT value FROM productattributes
                WHERE product_id = '7045'
                AND name = 'ListPriceAmount'
133 0.0001 0.00014305114746094
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 = '7045'
                GROUP BY o.product_id
134 0.0002 0.00020098686218262
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     = '7045'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
135 0.0001 0.00013208389282227
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 7045
136 0.0001 0.00013399124145508
SELECT value FROM productattributes WHERE product_id = '7045' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
137 0.0002 0.00017595291137695
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '7045'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Size'
                GROUP BY o.value
                ORDER BY o.value ASC
138 0.0002 0.00015902519226074
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '7045'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Color'
                GROUP BY o.value
                ORDER BY o.value ASC
139 0.0001 0.00012493133544922
SELECT * FROM products WHERE id = '7006'
140 0.0001 0.00011491775512695
SELECT * FROM productimages WHERE product_id = '7006' ORDER BY sortorder ASC
141 0.0001 0.00014495849609375
SELECT * FROM product_image_select WHERE product_id = '7006'
142 0.0001 0.00011301040649414
SELECT * FROM productcustomimages WHERE product_id = '7006'
143 0.0005 0.00052714347839355
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '7006' AND a.name = n.originalname
144 0.0001 0.00010490417480469
SELECT * FROM productoffers WHERE product_id = '7006' AND merchantid = 'ATVPDKIKX0DER'
145 0.0001 0.00010895729064941
SELECT * FROM productoffers
                WHERE product_id = '7006' AND price > 0
                ORDER BY price ASC LIMIT 1
146 0.0002 0.00015616416931152
SELECT * FROM productoffers
                WHERE product_id = 7006
                ORDER BY price ASC LIMIT 1
147 0.0002 0.0001530647277832
SELECT value FROM productattributes
                WHERE product_id = '7006'
                AND name = 'ListPriceAmount'
148 0.0001 0.00012302398681641
SELECT * FROM products WHERE id = '6997'
149 0.0001 0.00012803077697754
SELECT * FROM productimages WHERE product_id = '6997' ORDER BY sortorder ASC
150 0.0002 0.00017094612121582
SELECT * FROM product_image_select WHERE product_id = '6997'
151 0.0001 0.00010585784912109
SELECT * FROM productcustomimages WHERE product_id = '6997'
152 0.0008 0.00076699256896973
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '6997' AND a.name = n.originalname
153 0.0001 0.0001070499420166
SELECT * FROM productoffers WHERE product_id = '6997' AND merchantid = 'ATVPDKIKX0DER'
154 0.0001 0.00011396408081055
SELECT * FROM productoffers
                WHERE product_id = '6997' AND price > 0
                ORDER BY price ASC LIMIT 1
155 0.0001 0.00010895729064941
SELECT * FROM productoffers
                WHERE product_id = 6997
                ORDER BY price ASC LIMIT 1
156 0.0001 0.0001368522644043
SELECT value FROM productattributes
                WHERE product_id = '6997'
                AND name = 'ListPriceAmount'
157 0.0001 0.00013113021850586
SELECT * FROM products WHERE id = '6998'
158 0.0001 0.00012993812561035
SELECT * FROM productimages WHERE product_id = '6998' ORDER BY sortorder ASC
159 0.0002 0.00015997886657715
SELECT * FROM product_image_select WHERE product_id = '6998'
160 0.0001 0.00010514259338379
SELECT * FROM productcustomimages WHERE product_id = '6998'
161 0.0006 0.00057697296142578
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '6998' AND a.name = n.originalname
162 0.0001 0.00010013580322266
SELECT * FROM productoffers WHERE product_id = '6998' AND merchantid = 'ATVPDKIKX0DER'
163 0.0001 0.00013613700866699
SELECT * FROM productoffers
                WHERE product_id = '6998' AND price > 0
                ORDER BY price ASC LIMIT 1
164 0.0001 0.00010395050048828
SELECT * FROM productoffers
                WHERE product_id = 6998
                ORDER BY price ASC LIMIT 1
165 0.0001 0.00013589859008789
SELECT value FROM productattributes
                WHERE product_id = '6998'
                AND name = 'ListPriceAmount'
166 0.0002 0.00015091896057129
SELECT * FROM products WHERE id = '6996'
167 0.0001 0.00012707710266113
SELECT * FROM productimages WHERE product_id = '6996' ORDER BY sortorder ASC
168 0.0001 0.00014400482177734
SELECT * FROM product_image_select WHERE product_id = '6996'
169 0.0001 0.00010895729064941
SELECT * FROM productcustomimages WHERE product_id = '6996'
170 0.0008 0.00076913833618164
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '6996' AND a.name = n.originalname
171 0.0001 0.00010991096496582
SELECT * FROM productoffers WHERE product_id = '6996' AND merchantid = 'ATVPDKIKX0DER'
172 0.0001 0.00012683868408203
SELECT * FROM productoffers
                WHERE product_id = '6996' AND price > 0
                ORDER BY price ASC LIMIT 1
173 0.0001 0.0001068115234375
SELECT * FROM productoffers
                WHERE product_id = 6996
                ORDER BY price ASC LIMIT 1
174 0.0001 0.00011801719665527
SELECT value FROM productattributes
                WHERE product_id = '6996'
                AND name = 'ListPriceAmount'
175 0.0001 0.00014281272888184
SELECT * FROM products WHERE id = '7011'
176 0.0001 0.00012898445129395
SELECT * FROM productimages WHERE product_id = '7011' ORDER BY sortorder ASC
177 0.0001 0.00014591217041016
SELECT * FROM product_image_select WHERE product_id = '7011'
178 0.0001 0.00011396408081055
SELECT * FROM productcustomimages WHERE product_id = '7011'
179 0.0009 0.00085997581481934
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '7011' AND a.name = n.originalname
180 0.0001 0.00010800361633301
SELECT * FROM productoffers WHERE product_id = '7011' AND merchantid = 'ATVPDKIKX0DER'
181 0.0001 0.00012707710266113
SELECT * FROM productoffers
                WHERE product_id = '7011' AND price > 0
                ORDER BY price ASC LIMIT 1
182 0.0001 0.00010085105895996
SELECT * FROM productoffers
                WHERE product_id = 7011
                ORDER BY price ASC LIMIT 1
183 0.0001 0.00013995170593262
SELECT value FROM productattributes
                WHERE product_id = '7011'
                AND name = 'ListPriceAmount'
184 0.0001 0.00012707710266113
SELECT * FROM products WHERE id = '6750'
185 0.0001 0.00013017654418945
SELECT * FROM productimages WHERE product_id = '6750' ORDER BY sortorder ASC
186 0.0001 0.00014686584472656
SELECT * FROM product_image_select WHERE product_id = '6750'
187 0.0001 0.00011205673217773
SELECT * FROM productcustomimages WHERE product_id = '6750'
188 0.0004 0.0003659725189209
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '6750' AND a.name = n.originalname
189 0.0001 0.00010514259338379
SELECT * FROM productoffers WHERE product_id = '6750' AND merchantid = 'ATVPDKIKX0DER'
190 0.0001 0.00011301040649414
SELECT * FROM productoffers
                WHERE product_id = '6750' AND price > 0
                ORDER BY price ASC LIMIT 1
191 0.0001 0.00010085105895996
SELECT * FROM productoffers
                WHERE product_id = 6750
                ORDER BY price ASC LIMIT 1
192 0.0001 0.00012803077697754
SELECT value FROM productattributes
                WHERE product_id = '6750'
                AND name = 'ListPriceAmount'
193 0.0001 0.00014185905456543
SELECT value FROM productattributes WHERE product_id = '6750' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
194 0.0004 0.00041818618774414
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '7004' ORDER BY timestamp DESC
195 0.0001 8.2969665527344E-5
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '6999' ORDER BY timestamp DESC
196 0.0001 8.6069107055664E-5
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '7007' ORDER BY timestamp DESC
197 0.0001 8.2969665527344E-5
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '7045' ORDER BY timestamp DESC
198 0.0001 8.392333984375E-5
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '7006' ORDER BY timestamp DESC
199 0.0001 7.8916549682617E-5
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '6997' ORDER BY timestamp DESC
200 0.0001 9.2983245849609E-5
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '6998' ORDER BY timestamp DESC
201 0.0001 7.9870223999023E-5
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '6996' ORDER BY timestamp DESC
202 0.0001 7.9870223999023E-5
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '7011' ORDER BY timestamp DESC
203 0.0001 7.8916549682617E-5
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '6750' ORDER BY timestamp DESC
204 0.0001 0.00012612342834473
SELECT linktitle,pagename,ep.id,price,buylink,image FROM ebay_products ep, products_categories c
		WHERE ep.id = c.product_id
		AND c.category_id = 38
		AND c.prod_type = 'ebay'
		AND hide = 0
205 0.0002 0.0001828670501709
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
206 0.0001 0.00011610984802246
SELECT * FROM template_info WHERE templateuid = 'fsb-fluid'
207 0.0001 0.00014114379882812
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_user_data'
208 0.0001 8.5115432739258E-5
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_tracking_status'
209 0.0001 0.00012087821960449
SELECT * FROM pages WHERE id = 38
210 0.0001 0.00010800361633301
SELECT * FROM categories WHERE id = '27'
211 0.0002 0.0002448558807373
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
212 0.0001 7.4148178100586E-5
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
213 0.0001 8.7976455688477E-5
SELECT id FROM categories WHERE parent_id = '27'
214 0.0002 0.00021910667419434
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 
215 0.0001 9.5844268798828E-5
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 
216 0.0001 0.00012993812561035
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
217 0.0001 7.5101852416992E-5
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
218 0.0002 0.00019407272338867
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
219 0.0001 7.3909759521484E-5
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
220 0.0002 0.00020909309387207
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 
221 0.0001 8.8930130004883E-5
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 
222 0.0001 0.00010800361633301
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
223 0.0001 7.2002410888672E-5
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
224 0.0001 9.0837478637695E-5
SELECT id FROM categories WHERE parent_id = '27'
225 0.0002 0.00023198127746582
SELECT p.id FROM products p, products_categories c WHERE p.id = c.product_id AND c.category_id IN (27) AND p.hidden = 0 AND p.salesrank > 0 AND (p.price > 0 OR p.parent = 1) ORDER BY p.salesrank ASC LIMIT 1
226 0.0004 0.00038695335388184
SELECT * FROM productimages WHERE product_id = '819' ORDER BY sortorder ASC
227 0.0001 8.9168548583984E-5
SELECT * FROM categoryimages WHERE category_id = 27
228 0.0001 9.3221664428711E-5
SELECT * FROM categorygroups WHERE id = '1'
229 0.0003 0.00025010108947754
SELECT MIN(p.price) as minprice, MAX(p.price) as maxprice
		FROM products p, products_categories c
		WHERE p.id = c.product_id
		  AND c.category_id = '27'
		  AND p.offers > 0
		  AND p.hidden = 0
		  AND p.enabled = 1
		  AND p.parent = 0
		  AND p.price > 0
230 0.0001 0.00010108947753906
SELECT * FROM categories WHERE id = '30'
231 0.0003 0.00030899047851562
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
232 0.0001 6.7949295043945E-5
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
233 0.0001 7.7962875366211E-5
SELECT id FROM categories WHERE parent_id = '30'
234 0.0003 0.00033402442932129
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 
235 0.0001 8.8930130004883E-5
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 
236 0.0001 0.00010085105895996
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
237 0.0001 8.392333984375E-5
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
238 0.0003 0.00029802322387695
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
239 0.0001 7.0095062255859E-5
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
240 0.0003 0.00032305717468262
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 
241 0.0001 8.4877014160156E-5
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 
242 0.0001 0.00010800361633301
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
243 0.0001 7.2002410888672E-5
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
244 0.0001 8.1062316894531E-5
SELECT id FROM categories WHERE parent_id = '30'
245 0.0003 0.00034308433532715
SELECT p.id FROM products p, products_categories c WHERE p.id = c.product_id AND c.category_id IN (30) AND p.hidden = 0 AND p.salesrank > 0 AND (p.price > 0 OR p.parent = 1) ORDER BY p.salesrank ASC LIMIT 1
246 0.0001 0.00014209747314453
SELECT * FROM productimages WHERE product_id = '812' ORDER BY sortorder ASC
247 0.0001 8.702278137207E-5
SELECT * FROM categoryimages WHERE category_id = 30
248 0.0001 8.2969665527344E-5
SELECT * FROM categorygroups WHERE id = '1'
249 0.0003 0.0003349781036377
SELECT MIN(p.price) as minprice, MAX(p.price) as maxprice
		FROM products p, products_categories c
		WHERE p.id = c.product_id
		  AND c.category_id = '30'
		  AND p.offers > 0
		  AND p.hidden = 0
		  AND p.enabled = 1
		  AND p.parent = 0
		  AND p.price > 0
250 0.0001 0.00010514259338379
SELECT * FROM pages WHERE id = 59
251 0.0001 0.0001070499420166
SELECT * FROM pages WHERE id = 55
252 0.0002 0.00017499923706055
SELECT DISTINCT p.id FROM products p, productoffers o
            WHERE p.id IN (SELECT DISTINCT(pc.product_id) FROM products_categories pc WHERE pc.product_id = p.id AND pc.category_id IN (32)) AND p.parent_id = 0
253 0.0001 0.00013613700866699
UPDATE template_options SET value = 'a:11:{s:14:\"populationtype\";s:9:\"automatic\";s:12:\"productcount\";s:0:\"\";s:12:\"maxsalesrank\";s:0:\"\";s:8:\"minprice\";s:1:\"0\";s:8:\"maxprice\";s:1:\"0\";s:9:\"minimages\";s:0:\"\";s:10:\"categories\";a:1:{i:0;s:2:\"32\";}s:10:\"updatetime\";s:1:\"0\";s:13:\"selectiontype\";s:6:\"random\";s:11:\"lastupdated\";i:1628149003;s:8:\"products\";a:0:{}}' WHERE id = '8'
254 0.0002 0.00024509429931641
SELECT DISTINCT p.id FROM products p, productoffers o
            WHERE p.id IN (SELECT DISTINCT(pc.product_id) FROM products_categories pc WHERE pc.product_id = p.id AND pc.category_id IN (38)) AND p.parent_id = 0 LIMIT 3
255 0.0001 0.00011396408081055
UPDATE template_options SET value = 'a:10:{s:14:\"populationtype\";s:9:\"automatic\";s:12:\"productcount\";s:1:\"3\";s:12:\"maxsalesrank\";s:0:\"\";s:8:\"minprice\";s:1:\"0\";s:8:\"maxprice\";s:1:\"0\";s:9:\"minimages\";s:0:\"\";s:10:\"categories\";a:1:{i:0;s:2:\"38\";}s:13:\"selectiontype\";s:6:\"random\";s:11:\"lastupdated\";i:1628149003;s:8:\"products\";a:3:{i:0;s:11:\"7004|amazon\";i:1;s:11:\"7011|amazon\";i:2;s:11:\"7045|amazon\";}}' WHERE id = '16'
256 0.0001 0.00013279914855957
SELECT * FROM products WHERE id = 7004
257 0.0001 0.00012302398681641
SELECT * FROM products WHERE id = 7011
258 0.0001 0.00012707710266113
SELECT * FROM products WHERE id = 7045
259 0.0001 0.00011301040649414
SELECT * FROM products WHERE id = '7004'
260 0.0001 0.00014781951904297
SELECT * FROM productimages WHERE product_id = '7004' ORDER BY sortorder ASC
261 0.0001 0.00014901161193848
SELECT * FROM product_image_select WHERE product_id = '7004'
262 0.0001 0.0001070499420166
SELECT * FROM productcustomimages WHERE product_id = '7004'
263 0.0007 0.00073409080505371
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '7004' AND a.name = n.originalname
264 0.0001 0.00012493133544922
SELECT * FROM productoffers WHERE product_id = '7004' AND merchantid = 'ATVPDKIKX0DER'
265 0.0001 0.0001368522644043
SELECT * FROM productoffers
                WHERE product_id = '7004' AND price > 0
                ORDER BY price ASC LIMIT 1
266 0.0002 0.00016307830810547
SELECT value FROM productattributes WHERE product_id = '7004' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
267 0.0001 0.00013089179992676
SELECT * FROM products WHERE id = '7011'
268 0.0001 0.00011587142944336
SELECT * FROM productimages WHERE product_id = '7011' ORDER BY sortorder ASC
269 0.0001 0.00014305114746094
SELECT * FROM product_image_select WHERE product_id = '7011'
270 0.0001 0.00011491775512695
SELECT * FROM productcustomimages WHERE product_id = '7011'
271 0.0006 0.00064802169799805
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '7011' AND a.name = n.originalname
272 0.0001 0.00011086463928223
SELECT * FROM productoffers WHERE product_id = '7011' AND merchantid = 'ATVPDKIKX0DER'
273 0.0001 0.00011301040649414
SELECT * FROM productoffers
                WHERE product_id = '7011' AND price > 0
                ORDER BY price ASC LIMIT 1
274 0.0001 0.00010514259338379
SELECT * FROM productoffers
                WHERE product_id = 7011
                ORDER BY price ASC LIMIT 1
275 0.0001 0.00014209747314453
SELECT value FROM productattributes
                WHERE product_id = '7011'
                AND name = 'ListPriceAmount'
276 0.0001 0.00011897087097168
SELECT * FROM products WHERE id = '7045'
277 0.0001 0.00012683868408203
SELECT * FROM productimages WHERE product_id = '7045' ORDER BY sortorder ASC
278 0.0002 0.0001521110534668
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '7045' AND p.id = pi.product_id ORDER BY pi.sortorder
279 0.0001 0.00014996528625488
SELECT * FROM product_image_select WHERE product_id = '7045'
280 0.0001 0.00010585784912109
SELECT * FROM productcustomimages WHERE product_id = '7045'
281 0.0001 0.00014805793762207
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 = '7045'
                GROUP BY o.product_id
282 0.0002 0.00021004676818848
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     = '7045'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
283 0.0002 0.0001518726348877
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 7045
284 0.0004 0.0003659725189209
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '7045' AND a.name = n.originalname
285 0.0001 0.00010991096496582
SELECT * FROM productoffers WHERE product_id = '7045' AND merchantid = 'ATVPDKIKX0DER'
286 0.0001 0.00011420249938965
SELECT * FROM productoffers
                WHERE product_id = '7045' AND price > 0
                ORDER BY price ASC LIMIT 1
287 0.0001 0.00010800361633301
SELECT * FROM productoffers
                WHERE product_id = 7045
                ORDER BY price ASC LIMIT 1
288 0.0001 0.00011706352233887
SELECT value FROM productattributes
                WHERE product_id = '7045'
                AND name = 'ListPriceAmount'
289 0.0001 0.00014591217041016
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 = '7045'
                GROUP BY o.product_id
290 0.0002 0.00020599365234375
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     = '7045'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
291 0.0001 0.00012397766113281
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 7045
292 0.0001 0.00013613700866699
SELECT value FROM productattributes WHERE product_id = '7045' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
293 0.0002 0.00015902519226074
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '7045'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Size'
                GROUP BY o.value
                ORDER BY o.value ASC
294 0.0002 0.00017094612121582
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '7045'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Color'
                GROUP BY o.value
                ORDER BY o.value ASC
295 0.0003 0.00029516220092773
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid' AND area = 'header' ORDER BY sortorder ASC
296 0.0002 0.00021696090698242
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid' AND area = 'footer' ORDER BY sortorder ASC
297 0.0011 0.0011320114135742
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-fluid' AND skinuid = ''
298 0.0003 0.00025200843811035
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid'
299 0.0002 0.00017309188842773
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid'
300 0.0004 0.00035715103149414
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid' AND imageuid = 'FB_DEFAULT_SHARE_IMAGE'
301 0.0004 0.00035405158996582
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid' AND imageuid = 'HEAD_LOGO'
302 0.0002 0.00021910667419434
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid' AND imageuid = 'HEAD_LOGO'