0
  1. My Store
  2. Tags
  3. De La

De La

Browse Categories

Wait! We have a something for you...

Don't leave empty-handed! Simply enter your email below and we will send you a great discount on our products:

We hate spam as much as you do! Your details are never shared and you can unsubscribe at any time.

no thanks

Debug Overview

App Total Time DB Queries DB Query Total Time Amazon Requests
1.3620340824127 273 1.0595 0


No Amazon API Requests Made.


App Debug - Total Time 1.3620340824127 seconds

Number Time From Start Name Description
1 0.26047301292419 Initialise Initialise FSB Function
2 0.28713512420654 App Controller Start Start of the App controller (called before the controller of every page)
3 0.31473302841187 Start of getCategoryListByGroup Function Before first category groups query
4 0.31623220443726 After initial query Before first category groups query
5 0.31623411178589 Get Category List for Group Before the call to getCategoryList function
6 0.31623601913452 Start of GetCategoryList function Start of the function
7 0.31623816490173 Before getting categories Query to get specific category list
8 0.31675314903259 After getting categories Query to get specific category list
9 0.31675410270691 Before getting category custom Before call to function getCategoryCustom
10 0.33372902870178 After getting category custom After call to function getCategoryCustom
11 0.33373212814331 Before getting category custom Before call to function getCategoryCustom
12 0.34394717216492 After getting category custom After call to function getCategoryCustom
13 0.34395122528076 Before getting category custom Before call to function getCategoryCustom
14 0.35044121742249 After getting category custom After call to function getCategoryCustom
15 0.35044407844543 Before getting category custom Before call to function getCategoryCustom
16 0.35443115234375 After getting category custom After call to function getCategoryCustom
17 0.3544340133667 Before getting category custom Before call to function getCategoryCustom
18 0.35850405693054 After getting category custom After call to function getCategoryCustom
19 0.35850620269775 Before getting category custom Before call to function getCategoryCustom
20 0.36266613006592 After getting category custom After call to function getCategoryCustom
21 0.36266803741455 End of GetCategoryList function End of the function
22 0.36267518997192 Get Category List for Group Before the call to getCategoryList function
23 0.36267709732056 Start of GetCategoryList function Start of the function
24 0.36267805099487 Before getting categories Query to get specific category list
25 0.36315608024597 End of getCategoryListByGroup Function Before return()
26 1.1045610904694 App Controller End End of the App controller (called before the controller of every page)
27 1.2487680912018 App_after Controller Start Start of the App_after controller (called after the controller of every page)
28 1.2504420280457 Before Get Options Before the call to getOptions in the tpl class
29 1.3041701316833 After Get Options After the call to getOptions in the tpl class
30 1.3042070865631 App_after Controller End End of the App_after controller (called after the controller of every page)
31 1.3620240688324 Finalizing debug Before the debug is output to the page.
32 1.3620340824127 End of App This is the end of the app logging, final timestamp


Query Debug - 273 Database Queries. Total time 1.0595 seconds

Number Time (Seconds) Time (Milliseconds) Query
1 0.0021 0.002133846282959 
SELECT parameter, value FROM parameters
2 0.0070 0.0070099830627441 
SELECT * FROM `bad_bots`
3 0.0004 0.00040912628173828 
SET time_zone = 'Europe/London'
4 0.0026 0.0026159286499023 
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
5 0.0035 0.0034799575805664 
INSERT INTO ga_users (`isbot`, `ips`) SELECT '1', 'a:1:{i:0;s:14:\"18.222.153.154\";}'
6 0.0038 0.0038111209869385 
INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1746983295'
7 0.0043 0.0042519569396973 
SELECT * FROM autorun ORDER BY lastrun ASC
8 0.0007 0.00068092346191406 
UPDATE autorun SET lastrun = '2025-05-11 17:08:15' WHERE id = '16'
9 0.0009 0.0008552074432373 
SELECT * FROM version ORDER BY installed DESC LIMIT 1
10 0.0035 0.0034680366516113 
SELECT id FROM pages WHERE pagename = 'tag' LIMIT 1
11 0.0036 0.0036427974700928 
SELECT id FROM products WHERE pagename = 'tag' AND hidden = 0 LIMIT 1
12 0.0032 0.0031800270080566 
SELECT id FROM ebay_products WHERE pagename = 'tag'
13 0.0029 0.0029270648956299 
SELECT id FROM custom_products WHERE pagename = 'tag'
14 0.0023 0.0022940635681152 
SELECT id FROM categories WHERE pagename = 'tag' LIMIT 1
15 0.0020 0.0019881725311279 
SELECT id FROM manufacturers WHERE pagename = 'tag' LIMIT 1
16 0.0021 0.0020599365234375 
SELECT id FROM bundles WHERE pagename = 'tag' LIMIT 1
17 0.0055 0.0054829120635986 
SELECT id FROM tags WHERE pagename = 'de-la' LIMIT 1
18 0.0025 0.002547025680542 
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
19 0.0239 0.023885011672974 
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND language = 'en'
20 0.0006 0.00063705444335938 
SELECT * FROM pages WHERE pagename = 'tag'
21 0.0015 0.0014870166778564 
SELECT * FROM categorygroups ORDER BY sortorder ASC
22 0.0005 0.00050115585327148 
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
23 0.0062 0.0062189102172852 
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 26
24 0.0005 0.00049805641174316 
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 26
25 0.0014 0.0013859272003174 
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
26 0.0005 0.00045394897460938 
SELECT id FROM categories WHERE parent_id = '26'
27 0.0054 0.0053911209106445 
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (26)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1
28 0.0005 0.0004889965057373 
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (26)
				  AND p.disabled = 0
29 0.0005 0.00047802925109863 
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (26)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
30 0.0015 0.0015439987182617 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
31 0.0004 0.00040388107299805 
SELECT * FROM categorygroups WHERE id = '1'
32 0.0034 0.0034208297729492 
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
33 0.0005 0.0004889965057373 
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 27
34 0.0004 0.00039792060852051 
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
35 0.0004 0.00037884712219238 
SELECT id FROM categories WHERE parent_id = '27'
36 0.0035 0.0035169124603271 
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
37 0.0005 0.00047588348388672 
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (27)
				  AND p.disabled = 0
38 0.0005 0.00049710273742676 
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
39 0.0005 0.00047993659973145 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
40 0.0005 0.0004730224609375 
SELECT * FROM categorygroups WHERE id = '1'
41 0.0014 0.0013508796691895 
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 28
42 0.0005 0.00049901008605957 
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 28
43 0.0005 0.00050806999206543 
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
44 0.0005 0.00048494338989258 
SELECT id FROM categories WHERE parent_id = '28'
45 0.0015 0.0015478134155273 
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (28)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1
46 0.0005 0.00048494338989258 
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (28)
				  AND p.disabled = 0
47 0.0005 0.00051784515380859 
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (28)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
48 0.0005 0.00054812431335449 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
49 0.0005 0.00046992301940918 
SELECT * FROM categorygroups WHERE id = '1'
50 0.0005 0.00054287910461426 
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
51 0.0004 0.00043511390686035 
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 29
52 0.0004 0.00036501884460449 
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
53 0.0004 0.00036191940307617 
SELECT id FROM categories WHERE parent_id = '29'
54 0.0006 0.00057196617126465 
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
55 0.0004 0.00041103363037109 
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
56 0.0005 0.00046396255493164 
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
57 0.0004 0.00041604042053223 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
58 0.0004 0.00036907196044922 
SELECT * FROM categorygroups WHERE id = '1'
59 0.0005 0.00053787231445312 
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
60 0.0004 0.0004429817199707 
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 30
61 0.0004 0.00035309791564941 
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
62 0.0004 0.00037193298339844 
SELECT id FROM categories WHERE parent_id = '30'
63 0.0006 0.00061297416687012 
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
64 0.0004 0.00044918060302734 
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
65 0.0005 0.00045204162597656 
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
66 0.0004 0.00041913986206055 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
67 0.0004 0.00038003921508789 
SELECT * FROM categorygroups WHERE id = '1'
68 0.0006 0.00055813789367676 
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 31
69 0.0004 0.0004119873046875 
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 31
70 0.0004 0.00036811828613281 
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31
71 0.0004 0.00037717819213867 
SELECT id FROM categories WHERE parent_id = '31'
72 0.0006 0.00064301490783691 
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (31)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1
73 0.0005 0.00047612190246582 
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (31)
				  AND p.disabled = 0
74 0.0005 0.00047016143798828 
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (31)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
75 0.0004 0.0004270076751709 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
76 0.0004 0.00036382675170898 
SELECT * FROM categorygroups WHERE id = '1'
77 0.0005 0.00046706199645996 
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '2'  AND hidden = 0 ORDER BY sortorder ASC
78 0.0014 0.0014309883117676 
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
79 0.0017 0.0017228126525879 
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-fluid2018' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
80 0.0005 0.00052809715270996 
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
81 0.0012 0.0012490749359131 
SELECT * FROM sideboxes_pages WHERE sidebox_id = '26'
82 0.0011 0.0010900497436523 
SELECT value FROM template_options WHERE templateuid = 'fsb-fluid2018' AND optionuid = 'DISPLAY_CREDIT_ICON'
83 0.0009 0.0008690357208252 
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
84 0.7293 0.72928595542908 
SELECT * FROM ipgeocountries WHERE INET_ATON('18.222.153.154') >= INET_ATON(ip_start) AND INET_ATON('18.222.153.154') <= INET_ATON(ip_end)
85 0.0021 0.0020871162414551 
SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
86 0.0013 0.0013270378112793 
SELECT * FROM countryredirects WHERE countrycode = 'US'
87 0.0097 0.0096521377563477 
SELECT * FROM tags WHERE pagename = 'de-la'
88 0.0157 0.015733957290649 
SELECT MAX(price) as maxprice, MIN(price) as minprice FROM products WHERE enabled = 1 AND hidden = 0 AND price <> 0
89 0.0031 0.0030930042266846 
SELECT * FROM manufacturers WHERE display_filter = 1 AND merge_manufacturer_id = 0 ORDER BY name
90 0.0030 0.0030291080474854 
SELECT * FROM productattributenames n WHERE hidden = 0 AND metabrowse = 1 ORDER BY n.displayname ASC
91 0.0084 0.0083551406860352 
SELECT MAX(price) as maxprice, MIN(price) as minprice FROM products WHERE enabled = 1 AND hidden = 0 AND price <> 0
92 0.0030 0.0029881000518799 
SELECT * FROM manufacturers WHERE display_filter = 1 AND merge_manufacturer_id = 0 ORDER BY name
93 0.0009 0.00094294548034668 
SELECT * FROM productattributenames n WHERE hidden = 0 AND metabrowse = 1 AND sidebarfilter = 1 ORDER BY n.displayname ASC
94 0.0036 0.0036020278930664 
SELECT COUNT(DISTINCT(p.id)) FROM products p, product_tags t WHERE p.id = t.product_id AND parent_id = 0 AND t.tag_id = '938' AND hidden = 0 AND enabled = 1  AND 1 = 1
95 0.0031 0.003140926361084 
SELECT DISTINCT(p.id), p.*, IF(p.salesrank <> 0, p.salesrank, 100000) AS salesrank FROM products p, product_tags t WHERE p.id = t.product_id AND p.parent_id = 0 AND t.tag_id = '938' AND hidden = 0 AND enabled = 1  AND 1 = 1 ORDER BY salesrank ASC LIMIT 18, 18
96 0.0024 0.0023758411407471 
SELECT * FROM productimages WHERE product_id = '4247' ORDER BY sortorder ASC
97 0.0010 0.0010089874267578 
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '4247' AND p.id = pi.product_id ORDER BY pi.sortorder
98 0.0024 0.0024089813232422 
SELECT * FROM product_image_select WHERE product_id = '4247'
99 0.0020 0.0019941329956055 
SELECT * FROM productcustomimages WHERE product_id = '4247'
100 0.0025 0.0024640560150146 
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 = '4247'
                GROUP BY o.product_id
101 0.0039 0.0038681030273438 
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     = '4247'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
102 0.0011 0.0010571479797363 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 4247
103 0.0024 0.0024120807647705 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4247' AND a.name = n.originalname
104 0.0030 0.0029661655426025 
SELECT * FROM productoffers WHERE product_id = '4247' AND merchantid = 'A1X6FK5RDHNB96'
105 0.0023 0.0022649765014648 
SELECT * FROM productoffers
                WHERE product_id = '4247' AND price > 0
                ORDER BY price ASC LIMIT 1
106 0.0012 0.001162052154541 
SELECT * FROM productoffers
                WHERE product_id = 4247
                ORDER BY price ASC LIMIT 1
107 0.0014 0.0014398097991943 
SELECT value FROM productattributes
                WHERE product_id = '4247'
                AND name = 'ListPriceAmount'
108 0.0015 0.0014529228210449 
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 = '4247'
                GROUP BY o.product_id
109 0.0011 0.0011169910430908 
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     = '4247'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
110 0.0006 0.00057816505432129 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 4247
111 0.0007 0.00072193145751953 
SELECT value FROM productattributes WHERE product_id = '4247' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
112 0.0008 0.00081205368041992 
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '4247'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Size'
                GROUP BY o.value
                ORDER BY o.value ASC
113 0.0006 0.00062894821166992 
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '4247'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Color'
                GROUP BY o.value
                ORDER BY o.value ASC
114 0.0006 0.00055980682373047 
SELECT * FROM productimages WHERE product_id = '4213' ORDER BY sortorder ASC
115 0.0009 0.00086593627929688 
SELECT * FROM product_image_select WHERE product_id = '4213'
116 0.0005 0.00046586990356445 
SELECT * FROM productcustomimages WHERE product_id = '4213'
117 0.0017 0.0016779899597168 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4213' AND a.name = n.originalname
118 0.0006 0.00057101249694824 
SELECT * FROM productoffers WHERE product_id = '4213' AND merchantid = 'A1X6FK5RDHNB96'
119 0.0005 0.00051593780517578 
SELECT * FROM productoffers
                WHERE product_id = '4213' AND price > 0
                ORDER BY price ASC LIMIT 1
120 0.0006 0.00058603286743164 
SELECT value FROM productattributes WHERE product_id = '4213' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
121 0.0006 0.00061392784118652 
SELECT * FROM productimages WHERE product_id = '4061' ORDER BY sortorder ASC
122 0.0007 0.00069093704223633 
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '4061' AND p.id = pi.product_id ORDER BY pi.sortorder
123 0.0008 0.00084114074707031 
SELECT * FROM product_image_select WHERE product_id = '4061'
124 0.0006 0.00060296058654785 
SELECT * FROM productcustomimages WHERE product_id = '4061'
125 0.0006 0.00057005882263184 
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 = '4061'
                GROUP BY o.product_id
126 0.0007 0.00069093704223633 
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     = '4061'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
127 0.0004 0.00042486190795898 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 4061
128 0.0011 0.0010719299316406 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4061' AND a.name = n.originalname
129 0.0005 0.00045514106750488 
SELECT * FROM productoffers WHERE product_id = '4061' AND merchantid = 'A1X6FK5RDHNB96'
130 0.0004 0.00040507316589355 
SELECT * FROM productoffers
                WHERE product_id = '4061' AND price > 0
                ORDER BY price ASC LIMIT 1
131 0.0003 0.00033879280090332 
SELECT * FROM productoffers
                WHERE product_id = 4061
                ORDER BY price ASC LIMIT 1
132 0.0005 0.00045585632324219 
SELECT value FROM productattributes
                WHERE product_id = '4061'
                AND name = 'ListPriceAmount'
133 0.0004 0.00043320655822754 
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 = '4061'
                GROUP BY o.product_id
134 0.0007 0.00068783760070801 
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     = '4061'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
135 0.0005 0.0004580020904541 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 4061
136 0.0008 0.00078415870666504 
SELECT value FROM productattributes WHERE product_id = '4061' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
137 0.0005 0.00050687789916992 
SELECT * FROM products WHERE parent_id = '4061'
138 0.0007 0.00069594383239746 
SELECT * FROM productimages WHERE product_id = '3881' ORDER BY sortorder ASC
139 0.0007 0.00073099136352539 
SELECT * FROM product_image_select WHERE product_id = '3881'
140 0.0005 0.00054693222045898 
SELECT * FROM productcustomimages WHERE product_id = '3881'
141 0.0015 0.0014610290527344 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3881' AND a.name = n.originalname
142 0.0008 0.00075578689575195 
SELECT * FROM productoffers WHERE product_id = '3881' AND merchantid = 'A1X6FK5RDHNB96'
143 0.0005 0.00049686431884766 
SELECT * FROM productoffers
                WHERE product_id = '3881' AND price > 0
                ORDER BY price ASC LIMIT 1
144 0.0005 0.00052809715270996 
SELECT value FROM productattributes WHERE product_id = '3881' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
145 0.0006 0.00063395500183105 
SELECT * FROM productimages WHERE product_id = '3047' ORDER BY sortorder ASC
146 0.0006 0.00063395500183105 
SELECT * FROM product_image_select WHERE product_id = '3047'
147 0.0005 0.00053906440734863 
SELECT * FROM productcustomimages WHERE product_id = '3047'
148 0.0011 0.0011370182037354 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3047' AND a.name = n.originalname
149 0.0005 0.00048589706420898 
SELECT * FROM productoffers WHERE product_id = '3047' AND merchantid = 'A1X6FK5RDHNB96'
150 0.0004 0.00038599967956543 
SELECT * FROM productoffers
                WHERE product_id = '3047' AND price > 0
                ORDER BY price ASC LIMIT 1
151 0.0004 0.0003819465637207 
SELECT * FROM productoffers
                WHERE product_id = 3047
                ORDER BY price ASC LIMIT 1
152 0.0004 0.00040006637573242 
SELECT value FROM productattributes
                WHERE product_id = '3047'
                AND name = 'ListPriceAmount'
153 0.0004 0.0003960132598877 
SELECT value FROM productattributes WHERE product_id = '3047' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
154 0.0006 0.00055503845214844 
SELECT * FROM productimages WHERE product_id = '2695' ORDER BY sortorder ASC
155 0.0007 0.00067400932312012 
SELECT * FROM product_image_select WHERE product_id = '2695'
156 0.0004 0.00043511390686035 
SELECT * FROM productcustomimages WHERE product_id = '2695'
157 0.0010 0.0010411739349365 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2695' AND a.name = n.originalname
158 0.0005 0.00049090385437012 
SELECT * FROM productoffers WHERE product_id = '2695' AND merchantid = 'A1X6FK5RDHNB96'
159 0.0004 0.00037407875061035 
SELECT * FROM productoffers
                WHERE product_id = '2695' AND price > 0
                ORDER BY price ASC LIMIT 1
160 0.0004 0.00037193298339844 
SELECT * FROM productoffers
                WHERE product_id = 2695
                ORDER BY price ASC LIMIT 1
161 0.0006 0.00056004524230957 
SELECT value FROM productattributes
                WHERE product_id = '2695'
                AND name = 'ListPriceAmount'
162 0.0005 0.00054597854614258 
SELECT value FROM productattributes WHERE product_id = '2695' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
163 0.0006 0.00058817863464355 
SELECT * FROM productimages WHERE product_id = '1007' ORDER BY sortorder ASC
164 0.0006 0.00058603286743164 
SELECT * FROM product_image_select WHERE product_id = '1007'
165 0.0004 0.00038313865661621 
SELECT * FROM productcustomimages WHERE product_id = '1007'
166 0.0011 0.0011100769042969 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1007' AND a.name = n.originalname
167 0.0005 0.00048995018005371 
SELECT * FROM productoffers WHERE product_id = '1007' AND merchantid = 'A1X6FK5RDHNB96'
168 0.0004 0.0004429817199707 
SELECT * FROM productoffers
                WHERE product_id = '1007' AND price > 0
                ORDER BY price ASC LIMIT 1
169 0.0006 0.0005800724029541 
SELECT value FROM productattributes WHERE product_id = '1007' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
170 0.0009 0.00087904930114746 
SELECT * FROM productimages WHERE product_id = '1634' ORDER BY sortorder ASC
171 0.0006 0.00060606002807617 
SELECT * FROM product_image_select WHERE product_id = '1634'
172 0.0005 0.000518798828125 
SELECT * FROM productcustomimages WHERE product_id = '1634'
173 0.0009 0.00094985961914062 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1634' AND a.name = n.originalname
174 0.0006 0.00059008598327637 
SELECT * FROM productoffers WHERE product_id = '1634' AND merchantid = 'A1X6FK5RDHNB96'
175 0.0005 0.00053811073303223 
SELECT * FROM productoffers
                WHERE product_id = '1634' AND price > 0
                ORDER BY price ASC LIMIT 1
176 0.0004 0.00037598609924316 
SELECT * FROM productoffers
                WHERE product_id = 1634
                ORDER BY price ASC LIMIT 1
177 0.0004 0.00035715103149414 
SELECT value FROM productattributes
                WHERE product_id = '1634'
                AND name = 'ListPriceAmount'
178 0.0005 0.00045299530029297 
SELECT value FROM productattributes WHERE product_id = '1634' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
179 0.0005 0.00046586990356445 
SELECT * FROM productimages WHERE product_id = '1097' ORDER BY sortorder ASC
180 0.0006 0.00061988830566406 
SELECT * FROM product_image_select WHERE product_id = '1097'
181 0.0004 0.00039792060852051 
SELECT * FROM productcustomimages WHERE product_id = '1097'
182 0.0010 0.00095605850219727 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1097' AND a.name = n.originalname
183 0.0005 0.00047588348388672 
SELECT * FROM productoffers WHERE product_id = '1097' AND merchantid = 'A1X6FK5RDHNB96'
184 0.0004 0.00036883354187012 
SELECT * FROM productoffers
                WHERE product_id = '1097' AND price > 0
                ORDER BY price ASC LIMIT 1
185 0.0004 0.00038385391235352 
SELECT * FROM productoffers
                WHERE product_id = 1097
                ORDER BY price ASC LIMIT 1
186 0.0004 0.00037503242492676 
SELECT value FROM productattributes
                WHERE product_id = '1097'
                AND name = 'ListPriceAmount'
187 0.0005 0.00046110153198242 
SELECT value FROM productattributes WHERE product_id = '1097' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
188 0.0005 0.00054192543029785 
SELECT * FROM productimages WHERE product_id = '1062' ORDER BY sortorder ASC
189 0.0006 0.00061988830566406 
SELECT * FROM product_image_select WHERE product_id = '1062'
190 0.0004 0.00042104721069336 
SELECT * FROM productcustomimages WHERE product_id = '1062'
191 0.0010 0.0010402202606201 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1062' AND a.name = n.originalname
192 0.0005 0.00050497055053711 
SELECT * FROM productoffers WHERE product_id = '1062' AND merchantid = 'A1X6FK5RDHNB96'
193 0.0004 0.00044012069702148 
SELECT * FROM productoffers
                WHERE product_id = '1062' AND price > 0
                ORDER BY price ASC LIMIT 1
194 0.0005 0.00046586990356445 
SELECT * FROM productoffers
                WHERE product_id = 1062
                ORDER BY price ASC LIMIT 1
195 0.0005 0.00051784515380859 
SELECT value FROM productattributes
                WHERE product_id = '1062'
                AND name = 'ListPriceAmount'
196 0.0005 0.00049090385437012 
SELECT value FROM productattributes WHERE product_id = '1062' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
197 0.0020 0.0020089149475098 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4247' ORDER BY timestamp DESC
198 0.0004 0.00038814544677734 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4213' ORDER BY timestamp DESC
199 0.0004 0.0003969669342041 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4061' ORDER BY timestamp DESC
200 0.0004 0.0004429817199707 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3881' ORDER BY timestamp DESC
201 0.0004 0.00036478042602539 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3047' ORDER BY timestamp DESC
202 0.0003 0.00031304359436035 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2695' ORDER BY timestamp DESC
203 0.0004 0.00037598609924316 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1007' ORDER BY timestamp DESC
204 0.0003 0.00033998489379883 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1634' ORDER BY timestamp DESC
205 0.0004 0.00036096572875977 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1097' ORDER BY timestamp DESC
206 0.0003 0.0003049373626709 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1062' ORDER BY timestamp DESC
207 0.0017 0.001708984375 
SELECT * FROM template_info WHERE templateuid = 'fsb-fluid2018'
208 0.0013 0.0012500286102295 
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_user_data'
209 0.0004 0.00038313865661621 
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_tracking_status'
210 0.0135 0.01354193687439 
SELECT p.id,p.parent_id, o.price,p.asin FROM products p, productoffers o WHERE p.id = o.product_id AND p.parent_id = 0 AND hidden = 0 AND offers > 0 AND (SELECT COUNT(pi.id) FROM productimages pi WHERE pi.product_id = p.id) > 1 AND o.id IN (SELECT x.id FROM productoffers x WHERE x.product_id = p.id HAVING MIN(x.price)) ORDER BY p.title DESC LIMIT 6
211 0.0017 0.0017280578613281 
SELECT p.id,p.price,p.listingtype FROM ebay_products p WHERE hide = 0 AND (SELECT COUNT(pi.id) FROM ebay_prod_images pi WHERE pi.prodid = p.id) > 1 ORDER BY p.title DESC LIMIT 6
212 0.0006 0.00055694580078125 
SELECT p.id,p.price,p.currency FROM custom_products p WHERE hide = 0 AND orginalprice > 0 AND (SELECT COUNT(pi.id) FROM productcustomimages pi WHERE pi.product_id = p.id) > 1 ORDER BY p.title DESC LIMIT 6
213 0.0005 0.00054097175598145 
SELECT * FROM products WHERE id = 1626
214 0.0004 0.00040292739868164 
SELECT * FROM products WHERE id = 4041
215 0.0004 0.00038409233093262 
SELECT * FROM products WHERE id = 4312
216 0.0004 0.00044107437133789 
SELECT * FROM products WHERE id = 777
217 0.0004 0.00042510032653809 
SELECT * FROM products WHERE id = 3881
218 0.0004 0.00039196014404297 
SELECT * FROM products WHERE id = 4213
219 0.0005 0.00048613548278809 
SELECT * FROM products WHERE id = '1626'
220 0.0006 0.00056219100952148 
SELECT * FROM productimages WHERE product_id = '1626' ORDER BY sortorder ASC
221 0.0006 0.0005791187286377 
SELECT * FROM product_image_select WHERE product_id = '1626'
222 0.0005 0.0005190372467041 
SELECT * FROM productcustomimages WHERE product_id = '1626'
223 0.0009 0.00089097023010254 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1626' AND a.name = n.originalname
224 0.0005 0.00053596496582031 
SELECT * FROM productoffers WHERE product_id = '1626' AND merchantid = 'A1X6FK5RDHNB96'
225 0.0004 0.00040507316589355 
SELECT * FROM productoffers
                WHERE product_id = '1626' AND price > 0
                ORDER BY price ASC LIMIT 1
226 0.0006 0.00058197975158691 
SELECT value FROM productattributes WHERE product_id = '1626' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
227 0.0005 0.00053000450134277 
SELECT * FROM products WHERE id = '4041'
228 0.0004 0.00044107437133789 
SELECT * FROM productimages WHERE product_id = '4041' ORDER BY sortorder ASC
229 0.0005 0.00054383277893066 
SELECT * FROM product_image_select WHERE product_id = '4041'
230 0.0004 0.00035786628723145 
SELECT * FROM productcustomimages WHERE product_id = '4041'
231 0.0010 0.00097918510437012 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4041' AND a.name = n.originalname
232 0.0004 0.00043296813964844 
SELECT * FROM productoffers WHERE product_id = '4041' AND merchantid = 'A1X6FK5RDHNB96'
233 0.0004 0.00038504600524902 
SELECT * FROM productoffers
                WHERE product_id = '4041' AND price > 0
                ORDER BY price ASC LIMIT 1
234 0.0004 0.00038909912109375 
SELECT value FROM productattributes WHERE product_id = '4041' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
235 0.0005 0.00046992301940918 
SELECT * FROM products WHERE id = '4312'
236 0.0004 0.0004119873046875 
SELECT * FROM productimages WHERE product_id = '4312' ORDER BY sortorder ASC
237 0.0006 0.00060296058654785 
SELECT * FROM product_image_select WHERE product_id = '4312'
238 0.0004 0.00035500526428223 
SELECT * FROM productcustomimages WHERE product_id = '4312'
239 0.0010 0.00097107887268066 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4312' AND a.name = n.originalname
240 0.0004 0.00038909912109375 
SELECT * FROM productoffers WHERE product_id = '4312' AND merchantid = 'A1X6FK5RDHNB96'
241 0.0007 0.00069689750671387 
SELECT * FROM productoffers
                WHERE product_id = '4312' AND price > 0
                ORDER BY price ASC LIMIT 1
242 0.0004 0.00044417381286621 
SELECT value FROM productattributes WHERE product_id = '4312' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
243 0.0005 0.00045895576477051 
SELECT * FROM products WHERE id = '777'
244 0.0005 0.00045895576477051 
SELECT * FROM productimages WHERE product_id = '777' ORDER BY sortorder ASC
245 0.0006 0.00060510635375977 
SELECT * FROM product_image_select WHERE product_id = '777'
246 0.0004 0.00037503242492676 
SELECT * FROM productcustomimages WHERE product_id = '777'
247 0.0011 0.0010759830474854 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '777' AND a.name = n.originalname
248 0.0005 0.00047087669372559 
SELECT * FROM productoffers WHERE product_id = '777' AND merchantid = 'A1X6FK5RDHNB96'
249 0.0004 0.00043416023254395 
SELECT * FROM productoffers
                WHERE product_id = '777' AND price > 0
                ORDER BY price ASC LIMIT 1
250 0.0007 0.0006711483001709 
SELECT value FROM productattributes WHERE product_id = '777' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
251 0.0007 0.00069212913513184 
SELECT * FROM products WHERE id = '3881'
252 0.0006 0.00061416625976562 
SELECT * FROM productimages WHERE product_id = '3881' ORDER BY sortorder ASC
253 0.0006 0.00060677528381348 
SELECT * FROM product_image_select WHERE product_id = '3881'
254 0.0005 0.0005190372467041 
SELECT * FROM productcustomimages WHERE product_id = '3881'
255 0.0011 0.0011260509490967 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3881' AND a.name = n.originalname
256 0.0005 0.00047492980957031 
SELECT * FROM productoffers WHERE product_id = '3881' AND merchantid = 'A1X6FK5RDHNB96'
257 0.0004 0.00041604042053223 
SELECT * FROM productoffers
                WHERE product_id = '3881' AND price > 0
                ORDER BY price ASC LIMIT 1
258 0.0004 0.00041890144348145 
SELECT value FROM productattributes WHERE product_id = '3881' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
259 0.0005 0.00051403045654297 
SELECT * FROM products WHERE id = '4213'
260 0.0005 0.00047898292541504 
SELECT * FROM productimages WHERE product_id = '4213' ORDER BY sortorder ASC
261 0.0007 0.00068092346191406 
SELECT * FROM product_image_select WHERE product_id = '4213'
262 0.0004 0.00037407875061035 
SELECT * FROM productcustomimages WHERE product_id = '4213'
263 0.0011 0.0010888576507568 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4213' AND a.name = n.originalname
264 0.0006 0.00060009956359863 
SELECT * FROM productoffers WHERE product_id = '4213' AND merchantid = 'A1X6FK5RDHNB96'
265 0.0005 0.0004580020904541 
SELECT * FROM productoffers
                WHERE product_id = '4213' AND price > 0
                ORDER BY price ASC LIMIT 1
266 0.0005 0.00049710273742676 
SELECT value FROM productattributes WHERE product_id = '4213' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
267 0.0019 0.0019102096557617 
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'header' ORDER BY sortorder ASC
268 0.0007 0.00071001052856445 
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'footer' ORDER BY sortorder ASC
269 0.0022 0.0021731853485107 
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND skinuid = ''
270 0.0015 0.0015308856964111 
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
271 0.0005 0.00052499771118164 
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
272 0.0016 0.0016000270843506 
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid2018' AND imageuid = 'FB_DEFAULT_SHARE_IMAGE'
273 0.0012 0.0012400150299072 
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid2018' AND imageuid = 'HEAD_LOGO'