Former Military Spouse

Supreme Court Judge Scalia Quote Attorney Mug - Lawyer Cofee Cup Law G...

only $19.97

Law Student Cofee Cup Gift Idea for Attorney Lawyer

only $23.99

Funny Lawyer Christmas Gift Attorney Free Legal Advice Quote - Mug

from $0.00

We provide you the best products at the best prices on the web. Take a look at our categories for the widest range available, and shop online safe in the knowledge that all orders are 100% secure - guaranteed!

Debug Overview

App Total Time DB Queries DB Query Total Time Amazon Requests
0.42095708847046 309 0.1196 0


No Amazon API Requests Made.


App Debug - Total Time 0.42095708847046 seconds

Number Time From Start Name Description
1 0.22885417938232 Initialise Initialise FSB Function
2 0.22954106330872 App Controller Start Start of the App controller (called before the controller of every page)
3 0.24253702163696 Start of getCategoryListByGroup Function Before first category groups query
4 0.24306011199951 After initial query Before first category groups query
5 0.24306011199951 Get Category List for Group Before the call to getCategoryList function
6 0.24306201934814 Start of GetCategoryList function Start of the function
7 0.24306511878967 Before getting categories Query to get specific category list
8 0.24361705780029 After getting categories Query to get specific category list
9 0.24361801147461 Before getting category custom Before call to function getCategoryCustom
10 0.24728608131409 After getting category custom After call to function getCategoryCustom
11 0.24729108810425 Before getting category custom Before call to function getCategoryCustom
12 0.24831509590149 After getting category custom After call to function getCategoryCustom
13 0.24831700325012 Before getting category custom Before call to function getCategoryCustom
14 0.24939608573914 After getting category custom After call to function getCategoryCustom
15 0.24939703941345 Before getting category custom Before call to function getCategoryCustom
16 0.25031900405884 After getting category custom After call to function getCategoryCustom
17 0.25032114982605 End of GetCategoryList function End of the function
18 0.250324010849 Get Category List for Group Before the call to getCategoryList function
19 0.25032520294189 Start of GetCategoryList function Start of the function
20 0.25032615661621 Before getting categories Query to get specific category list
21 0.25043201446533 End of getCategoryListByGroup Function Before return()
22 0.2861590385437 App Controller End End of the App controller (called before the controller of every page)
23 0.33194708824158 App_after Controller Start Start of the App_after controller (called after the controller of every page)
24 0.33261108398438 Before Get Options Before the call to getOptions in the tpl class
25 0.3575451374054 After Get Options After the call to getOptions in the tpl class
26 0.35771107673645 App_after Controller End End of the App_after controller (called after the controller of every page)
27 0.42094922065735 Finalizing debug Before the debug is output to the page.
28 0.42095708847046 End of App This is the end of the app logging, final timestamp


Query Debug - 309 Database Queries. Total time 0.1196 seconds

Number Time (Seconds) Time (Milliseconds) Query
1 0.0007 0.0006561279296875
SELECT parameter, value FROM parameters
2 0.0011 0.0010759830474854
SELECT * FROM `bad_bots`
3 0.0004 0.00039982795715332
SET time_zone = 'Europe/London'
4 0.0003 0.00034189224243164
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
5 0.0011 0.0010750293731689
INSERT INTO ga_users (`isbot`, `ips`) SELECT '1', 'a:1:{i:0;s:13:\"18.207.238.28\";}'
6 0.0009 0.00089812278747559
INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1674924008'
7 0.0028 0.0027930736541748
SELECT * FROM autorun ORDER BY lastrun ASC
8 0.0003 0.00033807754516602
UPDATE autorun SET lastrun = '2023-01-28 16:40:08' WHERE id = '9'
9 0.0001 8.6069107055664E-5
SELECT * FROM version ORDER BY installed DESC LIMIT 1
10 0.0008 0.00076007843017578
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-fluid'
11 0.0111 0.011056900024414
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-fluid' AND language = 'en'
12 0.0007 0.00072813034057617
SELECT * FROM pages WHERE pagename = ''
13 0.0005 0.00051188468933105
SELECT * FROM categorygroups ORDER BY sortorder ASC
14 0.0005 0.00053691864013672
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
15 0.0015 0.001460075378418
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
16 0.0004 0.00035595893859863
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 27
17 0.0003 0.00031399726867676
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
18 0.0001 7.7009201049805E-5
SELECT id FROM categories WHERE parent_id = '27'
19 0.0002 0.00024795532226562
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 
20 0.0003 0.0003349781036377
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 
21 0.0004 0.00036001205444336
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
22 0.0003 0.0003209114074707
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
23 0.0001 8.1062316894531E-5
SELECT * FROM categorygroups WHERE id = '1'
24 0.0002 0.00020313262939453
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
25 0.0001 9.7036361694336E-5
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 29
26 0.0001 7.0095062255859E-5
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
27 0.0001 6.5803527832031E-5
SELECT id FROM categories WHERE parent_id = '29'
28 0.0002 0.00020408630371094
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 
29 0.0001 8.702278137207E-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 
30 0.0001 8.5115432739258E-5
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
31 0.0001 5.793571472168E-5
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
32 0.0001 6.7949295043945E-5
SELECT * FROM categorygroups WHERE id = '1'
33 0.0002 0.00023579597473145
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
34 0.0001 9.5129013061523E-5
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 30
35 0.0001 5.793571472168E-5
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
36 0.0001 6.3896179199219E-5
SELECT id FROM categories WHERE parent_id = '30'
37 0.0002 0.0002448558807373
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 
38 0.0001 7.2956085205078E-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 
39 0.0001 8.2969665527344E-5
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
40 0.0001 5.8889389038086E-5
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
41 0.0001 8.1062316894531E-5
SELECT * FROM categorygroups WHERE id = '1'
42 0.0002 0.00015902519226074
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
43 0.0001 9.6797943115234E-5
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 38
44 0.0001 5.8174133300781E-5
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 38
45 0.0001 6.5088272094727E-5
SELECT id FROM categories WHERE parent_id = '38'
46 0.0002 0.00015997886657715
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 
47 0.0001 8.9883804321289E-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 
48 0.0001 8.2969665527344E-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
49 0.0001 5.8174133300781E-5
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '38'
50 0.0001 6.6995620727539E-5
SELECT * FROM categorygroups WHERE id = '1'
51 0.0001 9.7036361694336E-5
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '2'  AND hidden = 0 ORDER BY sortorder ASC
52 0.0011 0.0011210441589355
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
53 0.0006 0.00056004524230957
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-fluid' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
54 0.0002 0.00018596649169922
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
55 0.0002 0.00019097328186035
SELECT value FROM template_options WHERE templateuid = 'fsb-fluid' AND optionuid = 'DISPLAY_CREDIT_ICON'
56 0.0005 0.00049996376037598
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
57 0.0306 0.030575037002563
SELECT * FROM ipgeocountries WHERE INET_ATON('18.207.238.28') >= INET_ATON(ip_start) AND INET_ATON('18.207.238.28') <= INET_ATON(ip_end)
58 0.0007 0.00068092346191406
SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
59 0.0003 0.00030207633972168
SELECT * FROM countryredirects WHERE countrycode = 'US'
60 0.0006 0.00058603286743164
SELECT * FROM widget_options WHERE templateid = 'fsb-fluid' ORDER BY optionid
61 0.0006 0.00055193901062012
    SELECT *
    FROM widgets_assigned
    WHERE templateuid = 'fsb-fluid'
    AND enabled = 1
    ORDER BY widgetarea, sortorder
62 0.0001 0.00012588500976562
SELECT * FROM pages WHERE pagename = ''
63 0.0010 0.0010170936584473
SELECT p.* FROM products p
                WHERE enabled = 1
                  AND parent_id = 0
                  AND hidden = 0
                  AND offers > 0
                  AND salesrank <> 0
                  AND p.id IN (SELECT product_id FROM products_categories)
                ORDER BY RAND() LIMIT 6
64 0.0023 0.0022540092468262
SELECT * FROM productimages WHERE product_id = '761' ORDER BY sortorder ASC
65 0.0009 0.00085186958312988
SELECT * FROM product_image_select WHERE product_id = '761'
66 0.0004 0.00039982795715332
SELECT * FROM productcustomimages WHERE product_id = '761'
67 0.0017 0.0016591548919678
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '761' AND a.name = n.originalname
68 0.0004 0.00035500526428223
SELECT * FROM productoffers WHERE product_id = '761' AND merchantid = 'ATVPDKIKX0DER'
69 0.0001 0.00014495849609375
SELECT * FROM productoffers
                WHERE product_id = '761' AND price > 0
                ORDER BY price ASC LIMIT 1
70 0.0001 0.00013899803161621
SELECT value FROM productattributes WHERE product_id = '761' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
71 0.0006 0.00059795379638672
SELECT * FROM productimages WHERE product_id = '7004' ORDER BY sortorder ASC
72 0.0002 0.0001518726348877
SELECT * FROM product_image_select WHERE product_id = '7004'
73 0.0001 9.1075897216797E-5
SELECT * FROM productcustomimages WHERE product_id = '7004'
74 0.0031 0.0030829906463623
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '7004' AND a.name = n.originalname
75 0.0001 0.00011992454528809
SELECT * FROM productoffers WHERE product_id = '7004' AND merchantid = 'ATVPDKIKX0DER'
76 0.0001 0.00012707710266113
SELECT * FROM productoffers
                WHERE product_id = '7004' AND price > 0
                ORDER BY price ASC LIMIT 1
77 0.0001 0.00014996528625488
SELECT value FROM productattributes WHERE product_id = '7004' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
78 0.0001 0.00011587142944336
SELECT * FROM productimages WHERE product_id = '814' ORDER BY sortorder ASC
79 0.0001 0.00013995170593262
SELECT * FROM product_image_select WHERE product_id = '814'
80 0.0001 8.7976455688477E-5
SELECT * FROM productcustomimages WHERE product_id = '814'
81 0.0010 0.0010049343109131
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '814' AND a.name = n.originalname
82 0.0004 0.00043702125549316
SELECT * FROM productoffers WHERE product_id = '814' AND merchantid = 'ATVPDKIKX0DER'
83 0.0001 0.00011897087097168
SELECT * FROM productoffers
                WHERE product_id = '814' AND price > 0
                ORDER BY price ASC LIMIT 1
84 0.0001 0.0001380443572998
SELECT value FROM productattributes WHERE product_id = '814' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
85 0.0002 0.00015401840209961
SELECT * FROM productimages WHERE product_id = '788' ORDER BY sortorder ASC
86 0.0001 0.00014114379882812
SELECT * FROM product_image_select WHERE product_id = '788'
87 0.0001 9.9897384643555E-5
SELECT * FROM productcustomimages WHERE product_id = '788'
88 0.0004 0.00042200088500977
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '788' AND a.name = n.originalname
89 0.0003 0.00031685829162598
SELECT * FROM productoffers WHERE product_id = '788' AND merchantid = 'ATVPDKIKX0DER'
90 0.0001 0.00011587142944336
SELECT * FROM productoffers
                WHERE product_id = '788' AND price > 0
                ORDER BY price ASC LIMIT 1
91 0.0001 0.00012397766113281
SELECT value FROM productattributes WHERE product_id = '788' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
92 0.0005 0.00048089027404785
UPDATE products SET price = '1399' WHERE id = '788'
93 0.0001 0.00011897087097168
SELECT * FROM productimages WHERE product_id = '750' ORDER BY sortorder ASC
94 0.0001 0.00013017654418945
SELECT * FROM product_image_select WHERE product_id = '750'
95 0.0001 0.00010299682617188
SELECT * FROM productcustomimages WHERE product_id = '750'
96 0.0006 0.00061321258544922
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '750' AND a.name = n.originalname
97 0.0001 0.00010085105895996
SELECT * FROM productoffers WHERE product_id = '750' AND merchantid = 'ATVPDKIKX0DER'
98 0.0001 0.00010991096496582
SELECT * FROM productoffers
                WHERE product_id = '750' AND price > 0
                ORDER BY price ASC LIMIT 1
99 0.0001 0.00014209747314453
SELECT value FROM productattributes WHERE product_id = '750' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
100 0.0001 0.0001220703125
SELECT * FROM productimages WHERE product_id = '801' ORDER BY sortorder ASC
101 0.0001 0.00012803077697754
SELECT * FROM product_image_select WHERE product_id = '801'
102 0.0001 8.6069107055664E-5
SELECT * FROM productcustomimages WHERE product_id = '801'
103 0.0005 0.00049805641174316
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '801' AND a.name = n.originalname
104 0.0001 0.00010013580322266
SELECT * FROM productoffers WHERE product_id = '801' AND merchantid = 'ATVPDKIKX0DER'
105 0.0001 0.00010895729064941
SELECT * FROM productoffers
                WHERE product_id = '801' AND price > 0
                ORDER BY price ASC LIMIT 1
106 0.0001 0.00013399124145508
SELECT value FROM productattributes WHERE product_id = '801' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
107 0.0004 0.00040602684020996
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
108 0.0001 0.00013089179992676
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:1674924008;s:8:\"products\";a:0:{}}' WHERE id = '8'
109 0.0002 0.00018191337585449
SELECT p.* FROM products p
                    WHERE enabled = 1
                      AND parent_id = 0
                      AND hidden = 0
                      AND offers > 0
                      AND salesrank <> 0
                      
                    ORDER BY salesrank ASC LIMIT 2
110 0.0001 6.5088272094727E-5
SELECT id FROM custom_products p
                WHERE hide = 0
                AND bestseller = 1
                
                LIMIT 2
111 0.0001 6.5088272094727E-5
SELECT id,listingtype FROM ebay_products p
                WHERE hide = 0
                
                ORDER BY soldcount DESC
                LIMIT 2
112 0.0001 0.00011301040649414
SELECT * FROM productimages WHERE product_id = '7837' ORDER BY sortorder ASC
113 0.0001 0.00014114379882812
SELECT * FROM product_image_select WHERE product_id = '7837'
114 0.0001 8.7976455688477E-5
SELECT * FROM productcustomimages WHERE product_id = '7837'
115 0.0003 0.00032401084899902
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '7837' AND a.name = n.originalname
116 0.0001 9.8943710327148E-5
SELECT * FROM productoffers WHERE product_id = '7837' AND merchantid = 'ATVPDKIKX0DER'
117 0.0001 0.00010895729064941
SELECT * FROM productoffers
                WHERE product_id = '7837' AND price > 0
                ORDER BY price ASC LIMIT 1
118 0.0001 0.00012683868408203
SELECT value FROM productattributes WHERE product_id = '7837' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
119 0.0001 0.00011801719665527
SELECT * FROM productimages WHERE product_id = '812' ORDER BY sortorder ASC
120 0.0001 0.00012803077697754
SELECT * FROM product_image_select WHERE product_id = '812'
121 0.0001 8.5115432739258E-5
SELECT * FROM productcustomimages WHERE product_id = '812'
122 0.0004 0.00042891502380371
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '812' AND a.name = n.originalname
123 0.0001 9.8228454589844E-5
SELECT * FROM productoffers WHERE product_id = '812' AND merchantid = 'ATVPDKIKX0DER'
124 0.0001 0.00010991096496582
SELECT * FROM productoffers
                WHERE product_id = '812' AND price > 0
                ORDER BY price ASC LIMIT 1
125 0.0001 0.00014114379882812
SELECT value FROM productattributes WHERE product_id = '812' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
126 0.0011 0.0010888576507568
SELECT  p.*, o.price + o.amountsaved as originalprice FROM products p, productoffers o
                    WHERE   p.id        = o.product_id
                      AND   p.parent_id = 0
                      AND   p.enabled   = 1
                      AND   p.hidden    = 0
                      AND   offers > 0
                      AND   o.percentagesaved > 0
                      AND   o.price > 200
                      AND   p.id IN (SELECT product_id FROM products_categories )
                      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, p.salesrank DESC LIMIT 6
127 0.0002 0.0001530647277832
SELECT * FROM productimages WHERE product_id = '769' ORDER BY sortorder ASC
128 0.0001 0.00013399124145508
SELECT * FROM product_image_select WHERE product_id = '769'
129 0.0001 8.702278137207E-5
SELECT * FROM productcustomimages WHERE product_id = '769'
130 0.0003 0.00029397010803223
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '769' AND a.name = n.originalname
131 0.0001 0.00010204315185547
SELECT * FROM productoffers WHERE product_id = '769' AND merchantid = 'ATVPDKIKX0DER'
132 0.0001 0.00011086463928223
SELECT * FROM productoffers
                WHERE product_id = '769' AND price > 0
                ORDER BY price ASC LIMIT 1
133 0.0001 0.00014209747314453
SELECT value FROM productattributes WHERE product_id = '769' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
134 0.0001 0.00011706352233887
SELECT * FROM productimages WHERE product_id = '821' ORDER BY sortorder ASC
135 0.0001 0.00013589859008789
SELECT * FROM product_image_select WHERE product_id = '821'
136 0.0001 8.5830688476562E-5
SELECT * FROM productcustomimages WHERE product_id = '821'
137 0.0004 0.00036501884460449
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '821' AND a.name = n.originalname
138 0.0001 0.00011396408081055
SELECT * FROM productoffers WHERE product_id = '821' AND merchantid = 'ATVPDKIKX0DER'
139 0.0001 0.00011205673217773
SELECT * FROM productoffers
                WHERE product_id = '821' AND price > 0
                ORDER BY price ASC LIMIT 1
140 0.0001 0.00012588500976562
SELECT value FROM productattributes WHERE product_id = '821' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
141 0.0001 9.7990036010742E-5
SELECT * FROM productimages WHERE product_id = '823' ORDER BY sortorder ASC
142 0.0001 0.00013017654418945
SELECT * FROM product_image_select WHERE product_id = '823'
143 0.0001 9.608268737793E-5
SELECT * FROM productcustomimages WHERE product_id = '823'
144 0.0004 0.0004270076751709
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '823' AND a.name = n.originalname
145 0.0001 9.608268737793E-5
SELECT * FROM productoffers WHERE product_id = '823' AND merchantid = 'ATVPDKIKX0DER'
146 0.0001 0.00010895729064941
SELECT * FROM productoffers
                WHERE product_id = '823' AND price > 0
                ORDER BY price ASC LIMIT 1
147 0.0001 0.00013017654418945
SELECT value FROM productattributes WHERE product_id = '823' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
148 0.0001 0.00012397766113281
SELECT * FROM productimages WHERE product_id = '830' ORDER BY sortorder ASC
149 0.0001 0.00012803077697754
SELECT * FROM product_image_select WHERE product_id = '830'
150 0.0001 8.392333984375E-5
SELECT * FROM productcustomimages WHERE product_id = '830'
151 0.0005 0.00054001808166504
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '830' AND a.name = n.originalname
152 0.0001 9.7990036010742E-5
SELECT * FROM productoffers WHERE product_id = '830' AND merchantid = 'ATVPDKIKX0DER'
153 0.0001 0.00011706352233887
SELECT * FROM productoffers
                WHERE product_id = '830' AND price > 0
                ORDER BY price ASC LIMIT 1
154 0.0001 0.00013208389282227
SELECT value FROM productattributes WHERE product_id = '830' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
155 0.0001 0.00012993812561035
SELECT * FROM productimages WHERE product_id = '788' ORDER BY sortorder ASC
156 0.0001 0.00013899803161621
SELECT * FROM product_image_select WHERE product_id = '788'
157 0.0001 8.702278137207E-5
SELECT * FROM productcustomimages WHERE product_id = '788'
158 0.0004 0.00039911270141602
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '788' AND a.name = n.originalname
159 0.0001 9.8943710327148E-5
SELECT * FROM productoffers WHERE product_id = '788' AND merchantid = 'ATVPDKIKX0DER'
160 0.0001 0.00010991096496582
SELECT * FROM productoffers
                WHERE product_id = '788' AND price > 0
                ORDER BY price ASC LIMIT 1
161 0.0001 0.0001220703125
SELECT value FROM productattributes WHERE product_id = '788' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
162 0.0001 0.00011110305786133
SELECT * FROM productimages WHERE product_id = '761' ORDER BY sortorder ASC
163 0.0001 0.00012993812561035
SELECT * FROM product_image_select WHERE product_id = '761'
164 0.0001 8.5115432739258E-5
SELECT * FROM productcustomimages WHERE product_id = '761'
165 0.0004 0.00044703483581543
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '761' AND a.name = n.originalname
166 0.0001 9.918212890625E-5
SELECT * FROM productoffers WHERE product_id = '761' AND merchantid = 'ATVPDKIKX0DER'
167 0.0001 0.0001070499420166
SELECT * FROM productoffers
                WHERE product_id = '761' AND price > 0
                ORDER BY price ASC LIMIT 1
168 0.0001 0.00013089179992676
SELECT value FROM productattributes WHERE product_id = '761' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
169 0.0002 0.0002131462097168
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
170 0.0001 9.608268737793E-5
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:1674924008;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'
171 0.0001 0.00010895729064941
SELECT * FROM products WHERE id = 7004
172 0.0001 0.00011706352233887
SELECT * FROM products WHERE id = 7011
173 0.0001 0.00010585784912109
SELECT * FROM products WHERE id = 7045
174 0.0001 0.00010395050048828
SELECT * FROM products WHERE id = '7004'
175 0.0001 0.00011610984802246
SELECT * FROM productimages WHERE product_id = '7004' ORDER BY sortorder ASC
176 0.0001 0.00013089179992676
SELECT * FROM product_image_select WHERE product_id = '7004'
177 0.0001 9.7990036010742E-5
SELECT * FROM productcustomimages WHERE product_id = '7004'
178 0.0005 0.00051307678222656
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '7004' AND a.name = n.originalname
179 0.0001 9.7036361694336E-5
SELECT * FROM productoffers WHERE product_id = '7004' AND merchantid = 'ATVPDKIKX0DER'
180 0.0001 0.00010800361633301
SELECT * FROM productoffers
                WHERE product_id = '7004' AND price > 0
                ORDER BY price ASC LIMIT 1
181 0.0001 0.00013494491577148
SELECT value FROM productattributes WHERE product_id = '7004' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
182 0.0001 0.00011897087097168
SELECT * FROM products WHERE id = '7011'
183 0.0001 9.8943710327148E-5
SELECT * FROM productimages WHERE product_id = '7011' ORDER BY sortorder ASC
184 0.0001 0.00014281272888184
SELECT * FROM product_image_select WHERE product_id = '7011'
185 0.0001 8.6069107055664E-5
SELECT * FROM productcustomimages WHERE product_id = '7011'
186 0.0008 0.00076389312744141
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '7011' AND a.name = n.originalname
187 0.0001 0.00011205673217773
SELECT * FROM productoffers WHERE product_id = '7011' AND merchantid = 'ATVPDKIKX0DER'
188 0.0001 0.00010013580322266
SELECT * FROM productoffers
                WHERE product_id = '7011' AND price > 0
                ORDER BY price ASC LIMIT 1
189 0.0001 9.2983245849609E-5
SELECT * FROM productoffers
                WHERE product_id = 7011
                ORDER BY price ASC LIMIT 1
190 0.0001 0.00011205673217773
SELECT value FROM productattributes
                WHERE product_id = '7011'
                AND name = 'ListPriceAmount'
191 0.0001 0.00010991096496582
SELECT * FROM products WHERE id = '7045'
192 0.0001 0.00010299682617188
SELECT * FROM productimages WHERE product_id = '7045' ORDER BY sortorder ASC
193 0.0002 0.00018000602722168
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
194 0.0002 0.00016212463378906
SELECT * FROM product_image_select WHERE product_id = '7045'
195 0.0001 9.2983245849609E-5
SELECT * FROM productcustomimages WHERE product_id = '7045'
196 0.0001 0.00013399124145508
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
197 0.0007 0.00066208839416504
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
198 0.0001 0.00011706352233887
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
199 0.0006 0.00057387351989746
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '7045' AND a.name = n.originalname
200 0.0001 9.2983245849609E-5
SELECT * FROM productoffers WHERE product_id = '7045' AND merchantid = 'ATVPDKIKX0DER'
201 0.0001 9.8943710327148E-5
SELECT * FROM productoffers
                WHERE product_id = '7045' AND price > 0
                ORDER BY price ASC LIMIT 1
202 0.0001 0.00010418891906738
SELECT * FROM productoffers
                WHERE product_id = 7045
                ORDER BY price ASC LIMIT 1
203 0.0001 0.00011110305786133
SELECT value FROM productattributes
                WHERE product_id = '7045'
                AND name = 'ListPriceAmount'
204 0.0001 0.00012707710266113
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
205 0.0002 0.00015807151794434
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
206 0.0001 0.00010800361633301
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
207 0.0001 0.00014710426330566
SELECT value FROM productattributes WHERE product_id = '7045' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
208 0.0002 0.00015115737915039
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
209 0.0002 0.00015497207641602
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
210 0.0005 0.00053215026855469
SELECT	m.*, COUNT(p.id) as productcount FROM manufacturers m, products p
				WHERE	m.id = p.manufacturer_id
				  AND	m.merge_manufacturer_id = 0
				  AND	p.parent_id	= 0
				  AND	p.enabled	= 1
				  AND	p.hidden	= 0
				  AND   offers > 0
				  AND	m.display_homepage	= 1
				  AND	m.id IN (SELECT manufacturer_id FROM manufacturerimages)
				GROUP BY m.id HAVING COUNT(p.id) > 0 ORDER BY COUNT(p.id) DESC LIMIT 8
211 0.0001 7.1048736572266E-5
SELECT * FROM `widget_options` WHERE `optionid` = 'latestpages1'
212 0.0001 0.0001068115234375
SELECT * FROM `pages` WHERE `core` = 0 ORDER BY `created_on` DESC LIMIT 0, 5
213 0.0005 0.00054502487182617
SELECT * FROM template_info WHERE templateuid = 'fsb-fluid'
214 0.0005 0.00053811073303223
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_user_data'
215 0.0001 7.3909759521484E-5
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_tracking_status'
216 0.0001 0.00010514259338379
SELECT * FROM pages WHERE id = 38
217 0.0001 9.608268737793E-5
SELECT * FROM categories WHERE id = '27'
218 0.0002 0.00017786026000977
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 6.6041946411133E-5
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
220 0.0001 6.6041946411133E-5
SELECT id FROM categories WHERE parent_id = '27'
221 0.0002 0.0001671314239502
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 
222 0.0001 7.8201293945312E-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 
223 0.0001 8.702278137207E-5
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
224 0.0001 8.1062316894531E-5
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
225 0.0002 0.0001521110534668
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
226 0.0001 7.2002410888672E-5
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
227 0.0002 0.00017690658569336
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 
228 0.0001 7.2956085205078E-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 
229 0.0001 8.2969665527344E-5
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
230 0.0001 5.8889389038086E-5
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
231 0.0001 6.5088272094727E-5
SELECT id FROM categories WHERE parent_id = '27'
232 0.0002 0.00021100044250488
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
233 0.0001 0.00011992454528809
SELECT * FROM productimages WHERE product_id = '798' ORDER BY sortorder ASC
234 0.0005 0.00053787231445312
SELECT * FROM categoryimages WHERE category_id = 27
235 0.0001 7.7009201049805E-5
SELECT * FROM categorygroups WHERE id = '1'
236 0.0002 0.00019288063049316
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
237 0.0001 9.2029571533203E-5
SELECT * FROM categories WHERE id = '30'
238 0.0002 0.00022411346435547
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 6.1988830566406E-5
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
240 0.0001 6.4849853515625E-5
SELECT id FROM categories WHERE parent_id = '30'
241 0.0003 0.00025296211242676
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 
242 0.0001 8.5830688476562E-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 
243 0.0001 8.702278137207E-5
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
244 0.0001 7.0095062255859E-5
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
245 0.0002 0.00021576881408691
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
246 0.0001 6.0081481933594E-5
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
247 0.0002 0.0002448558807373
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 
248 0.0001 7.2956085205078E-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 
249 0.0001 8.1777572631836E-5
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
250 0.0001 5.8174133300781E-5
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
251 0.0001 6.413459777832E-5
SELECT id FROM categories WHERE parent_id = '30'
252 0.0003 0.00025415420532227
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
253 0.0001 0.00010895729064941
SELECT * FROM productimages WHERE product_id = '812' ORDER BY sortorder ASC
254 0.0001 8.2015991210938E-5
SELECT * FROM categoryimages WHERE category_id = 30
255 0.0001 7.1048736572266E-5
SELECT * FROM categorygroups WHERE id = '1'
256 0.0002 0.00024008750915527
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
257 0.0001 8.4877014160156E-5
SELECT * FROM pages WHERE id = 59
258 0.0001 8.6069107055664E-5
SELECT * FROM pages WHERE id = 55
259 0.0001 0.00014305114746094
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
260 0.0001 8.392333984375E-5
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:1674924008;s:8:\"products\";a:0:{}}' WHERE id = '8'
261 0.0002 0.0001990795135498
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
262 0.0001 7.9154968261719E-5
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:1674924008;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'
263 0.0001 0.00011086463928223
SELECT * FROM products WHERE id = 7004
264 0.0001 0.0001070499420166
SELECT * FROM products WHERE id = 7011
265 0.0001 0.00010299682617188
SELECT * FROM products WHERE id = 7045
266 0.0001 0.00011491775512695
SELECT * FROM products WHERE id = '7004'
267 0.0001 0.00011491775512695
SELECT * FROM productimages WHERE product_id = '7004' ORDER BY sortorder ASC
268 0.0001 0.00013303756713867
SELECT * FROM product_image_select WHERE product_id = '7004'
269 0.0001 0.00010299682617188
SELECT * FROM productcustomimages WHERE product_id = '7004'
270 0.0005 0.00051379203796387
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '7004' AND a.name = n.originalname
271 0.0001 0.00010108947753906
SELECT * FROM productoffers WHERE product_id = '7004' AND merchantid = 'ATVPDKIKX0DER'
272 0.0001 0.00011110305786133
SELECT * FROM productoffers
                WHERE product_id = '7004' AND price > 0
                ORDER BY price ASC LIMIT 1
273 0.0002 0.00016093254089355
SELECT value FROM productattributes WHERE product_id = '7004' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
274 0.0001 0.00011301040649414
SELECT * FROM products WHERE id = '7011'
275 0.0001 0.00010085105895996
SELECT * FROM productimages WHERE product_id = '7011' ORDER BY sortorder ASC
276 0.0001 0.00013208389282227
SELECT * FROM product_image_select WHERE product_id = '7011'
277 0.0001 8.6784362792969E-5
SELECT * FROM productcustomimages WHERE product_id = '7011'
278 0.0006 0.00056695938110352
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '7011' AND a.name = n.originalname
279 0.0001 9.3936920166016E-5
SELECT * FROM productoffers WHERE product_id = '7011' AND merchantid = 'ATVPDKIKX0DER'
280 0.0001 9.7990036010742E-5
SELECT * FROM productoffers
                WHERE product_id = '7011' AND price > 0
                ORDER BY price ASC LIMIT 1
281 0.0001 9.5129013061523E-5
SELECT * FROM productoffers
                WHERE product_id = 7011
                ORDER BY price ASC LIMIT 1
282 0.0001 0.00011301040649414
SELECT value FROM productattributes
                WHERE product_id = '7011'
                AND name = 'ListPriceAmount'
283 0.0001 0.00011301040649414
SELECT * FROM products WHERE id = '7045'
284 0.0001 9.5129013061523E-5
SELECT * FROM productimages WHERE product_id = '7045' ORDER BY sortorder ASC
285 0.0001 0.00014400482177734
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
286 0.0001 0.00013399124145508
SELECT * FROM product_image_select WHERE product_id = '7045'
287 0.0001 8.7976455688477E-5
SELECT * FROM productcustomimages WHERE product_id = '7045'
288 0.0001 0.00013303756713867
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
289 0.0002 0.00016093254089355
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
290 0.0001 0.00010991096496582
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
291 0.0006 0.00057888031005859
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '7045' AND a.name = n.originalname
292 0.0001 9.5129013061523E-5
SELECT * FROM productoffers WHERE product_id = '7045' AND merchantid = 'ATVPDKIKX0DER'
293 0.0001 9.9897384643555E-5
SELECT * FROM productoffers
                WHERE product_id = '7045' AND price > 0
                ORDER BY price ASC LIMIT 1
294 0.0001 9.8943710327148E-5
SELECT * FROM productoffers
                WHERE product_id = 7045
                ORDER BY price ASC LIMIT 1
295 0.0001 0.00010919570922852
SELECT value FROM productattributes
                WHERE product_id = '7045'
                AND name = 'ListPriceAmount'
296 0.0001 0.00012493133544922
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
297 0.0002 0.00018596649169922
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
298 0.0001 0.00010895729064941
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
299 0.0001 0.00013995170593262
SELECT value FROM productattributes WHERE product_id = '7045' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
300 0.0001 0.00014400482177734
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
301 0.0001 0.00014901161193848
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
302 0.0005 0.00050616264343262
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid' AND area = 'header' ORDER BY sortorder ASC
303 0.0002 0.00017786026000977
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid' AND area = 'footer' ORDER BY sortorder ASC
304 0.0060 0.0060288906097412
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-fluid' AND skinuid = ''
305 0.0005 0.0004570484161377
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid'
306 0.0002 0.00015497207641602
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid'
307 0.0001 0.00014686584472656
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid' AND imageuid = 'FB_DEFAULT_SHARE_IMAGE'
308 0.0001 0.00014495849609375
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid' AND imageuid = 'HEAD_LOGO'
309 0.0001 0.00012612342834473
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid' AND imageuid = 'HEAD_LOGO'