0 items

Former Military Spouse

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

only $19.97

Buy at Amazon

Add to Cart

Law Student Cofee Cup Gift Idea for Attorney Lawyer

only $23.99

Buy at Amazon

Add to Cart

Funny Lawyer Christmas Gift Attorney Free Legal Advice Quote - Mug

from $0.00

Buy at Amazon

Add to Cart

Debug Overview

App Total Time	DB Queries	DB Query Total Time	Amazon Requests
0.52166891098022	308	0.0836	0

No Amazon API Requests Made.

App Debug - Total Time 0.52166891098022 seconds

Number	Time From Start	Name	Description
1	0.37134695053101	Initialise	Initialise FSB Function
2	0.37171292304993	App Controller Start	Start of the App controller (called before the controller of every page)
3	0.37637400627136	Start of getCategoryListByGroup Function	Before first category groups query
4	0.37652206420898	After initial query	Before first category groups query
5	0.3765230178833	Get Category List for Group	Before the call to getCategoryList function
6	0.37652492523193	Start of GetCategoryList function	Start of the function
7	0.37652707099915	Before getting categories	Query to get specific category list
8	0.37672710418701	After getting categories	Query to get specific category list
9	0.37672805786133	Before getting category custom	Before call to function getCategoryCustom
10	0.37854409217834	After getting category custom	After call to function getCategoryCustom
11	0.37854909896851	Before getting category custom	Before call to function getCategoryCustom
12	0.37959909439087	After getting category custom	After call to function getCategoryCustom
13	0.3796010017395	Before getting category custom	Before call to function getCategoryCustom
14	0.38070201873779	After getting category custom	After call to function getCategoryCustom
15	0.38070297241211	Before getting category custom	Before call to function getCategoryCustom
16	0.38164591789246	After getting category custom	After call to function getCategoryCustom
17	0.38164710998535	End of GetCategoryList function	End of the function
18	0.38165092468262	Get Category List for Group	Before the call to getCategoryList function
19	0.38165211677551	Start of GetCategoryList function	Start of the function
20	0.38165307044983	Before getting categories	Query to get specific category list
21	0.38176298141479	End of getCategoryListByGroup Function	Before return()
22	0.41446805000305	App Controller End	End of the App controller (called before the controller of every page)
23	0.44827604293823	App_after Controller Start	Start of the App_after controller (called after the controller of every page)
24	0.44852495193481	Before Get Options	Before the call to getOptions in the tpl class
25	0.46276807785034	After Get Options	After the call to getOptions in the tpl class
26	0.4629499912262	App_after Controller End	End of the App_after controller (called after the controller of every page)
27	0.52165794372559	Finalizing debug	Before the debug is output to the page.
28	0.52166891098022	End of App	This is the end of the app logging, final timestamp

Query Debug - 308 Database Queries. Total time 0.0836 seconds


SELECT parameter, value FROM parameters
SELECT * FROM `bad_bots`
SET time_zone = 'Europe/London'
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
INSERT INTO ga_users (`isbot`, `ips`) SELECT '1', 'a:1:{i:0;s:14:\"34.239.152.207\";}'
INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1679624475'
SELECT * FROM autorun ORDER BY lastrun ASC
UPDATE autorun SET lastrun = '2023-03-24 02:21:15' WHERE id = '8'
SELECT * FROM version ORDER BY installed DESC LIMIT 1
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-fluid'
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-fluid' AND language = 'en'
SELECT * FROM pages WHERE pagename = ''
SELECT * FROM categorygroups ORDER BY sortorder ASC
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
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
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 27
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
SELECT id FROM categories WHERE parent_id = '27'
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 
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 
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
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
SELECT * FROM categorygroups WHERE id = '1'
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
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 29
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
SELECT id FROM categories WHERE parent_id = '29'
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 
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 
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
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
SELECT * FROM categorygroups WHERE id = '1'
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
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 30
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
SELECT id FROM categories WHERE parent_id = '30'
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 
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 
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
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
SELECT * FROM categorygroups WHERE id = '1'
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
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 38
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 38
SELECT id FROM categories WHERE parent_id = '38'
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 
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 
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
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '38'
SELECT * FROM categorygroups WHERE id = '1'
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '2'  AND hidden = 0 ORDER BY sortorder ASC
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-fluid' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
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
SELECT value FROM template_options WHERE templateuid = 'fsb-fluid' AND optionuid = 'DISPLAY_CREDIT_ICON'
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
SELECT * FROM ipgeocountries WHERE INET_ATON('34.239.152.207') >= INET_ATON(ip_start) AND INET_ATON('34.239.152.207') <= INET_ATON(ip_end)
SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
SELECT * FROM countryredirects WHERE countrycode = 'US'
SELECT * FROM widget_options WHERE templateid = 'fsb-fluid' ORDER BY optionid
    SELECT *
    FROM widgets_assigned
    WHERE templateuid = 'fsb-fluid'
    AND enabled = 1
    ORDER BY widgetarea, sortorder
SELECT * FROM pages WHERE pagename = ''
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
SELECT * FROM productimages WHERE product_id = '760' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '760'
SELECT * FROM productcustomimages WHERE product_id = '760'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '760' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '760' AND merchantid = 'ATVPDKIKX0DER'
SELECT * FROM productoffers
                WHERE product_id = '760' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '760' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM productimages WHERE product_id = '829' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '829'
SELECT * FROM productcustomimages WHERE product_id = '829'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '829' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '829' AND merchantid = 'ATVPDKIKX0DER'
SELECT * FROM productoffers
                WHERE product_id = '829' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '829' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM productimages WHERE product_id = '4399' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '4399'
SELECT * FROM productcustomimages WHERE product_id = '4399'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4399' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '4399' AND merchantid = 'ATVPDKIKX0DER'
SELECT * FROM productoffers
                WHERE product_id = '4399' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '4399' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM productimages WHERE product_id = '826' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '826'
SELECT * FROM productcustomimages WHERE product_id = '826'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '826' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '826' AND merchantid = 'ATVPDKIKX0DER'
SELECT * FROM productoffers
                WHERE product_id = '826' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '826' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM productimages WHERE product_id = '791' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '791'
SELECT * FROM productcustomimages WHERE product_id = '791'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '791' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '791' AND merchantid = 'ATVPDKIKX0DER'
SELECT * FROM productoffers
                WHERE product_id = '791' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '791' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM productimages WHERE product_id = '780' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '780'
SELECT * FROM productcustomimages WHERE product_id = '780'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '780' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '780' AND merchantid = 'ATVPDKIKX0DER'
SELECT * FROM productoffers
                WHERE product_id = '780' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '780' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
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
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:1679624475;s:8:\"products\";a:0:{}}' WHERE id = '8'
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
SELECT id FROM custom_products p
                WHERE hide = 0
                AND bestseller = 1
                
                LIMIT 2
SELECT id,listingtype FROM ebay_products p
                WHERE hide = 0
                
                ORDER BY soldcount DESC
                LIMIT 2
SELECT * FROM productimages WHERE product_id = '785' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '785'
SELECT * FROM productcustomimages WHERE product_id = '785'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '785' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '785' AND merchantid = 'ATVPDKIKX0DER'
SELECT * FROM productoffers
                WHERE product_id = '785' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '785' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM productimages WHERE product_id = '7838' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '7838'
SELECT * FROM productcustomimages WHERE product_id = '7838'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '7838' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '7838' AND merchantid = 'ATVPDKIKX0DER'
SELECT * FROM productoffers
                WHERE product_id = '7838' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '7838' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
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
SELECT * FROM productimages WHERE product_id = '769' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '769'
SELECT * FROM productcustomimages WHERE product_id = '769'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '769' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '769' AND merchantid = 'ATVPDKIKX0DER'
SELECT * FROM productoffers
                WHERE product_id = '769' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '769' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM productimages WHERE product_id = '824' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '824'
SELECT * FROM productcustomimages WHERE product_id = '824'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '824' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '824' AND merchantid = 'ATVPDKIKX0DER'
SELECT * FROM productoffers
                WHERE product_id = '824' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '824' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM productimages WHERE product_id = '821' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '821'
SELECT * FROM productcustomimages WHERE product_id = '821'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '821' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '821' AND merchantid = 'ATVPDKIKX0DER'
SELECT * FROM productoffers
                WHERE product_id = '821' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '821' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM productimages WHERE product_id = '788' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '788'
SELECT * FROM productcustomimages WHERE product_id = '788'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '788' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '788' AND merchantid = 'ATVPDKIKX0DER'
SELECT * FROM productoffers
                WHERE product_id = '788' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '788' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM productimages WHERE product_id = '830' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '830'
SELECT * FROM productcustomimages WHERE product_id = '830'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '830' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '830' AND merchantid = 'ATVPDKIKX0DER'
SELECT * FROM productoffers
                WHERE product_id = '830' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '830' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM productimages WHERE product_id = '761' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '761'
SELECT * FROM productcustomimages WHERE product_id = '761'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '761' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '761' AND merchantid = 'ATVPDKIKX0DER'
SELECT * FROM productoffers
                WHERE product_id = '761' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '761' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
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
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:1679624475;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'
SELECT * FROM products WHERE id = 7004
SELECT * FROM products WHERE id = 7011
SELECT * FROM products WHERE id = 7045
SELECT * FROM products WHERE id = '7004'
SELECT * FROM productimages WHERE product_id = '7004' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '7004'
SELECT * FROM productcustomimages WHERE product_id = '7004'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '7004' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '7004' AND merchantid = 'ATVPDKIKX0DER'
SELECT * FROM productoffers
                WHERE product_id = '7004' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '7004' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '7011'
SELECT * FROM productimages WHERE product_id = '7011' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '7011'
SELECT * FROM productcustomimages WHERE product_id = '7011'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '7011' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '7011' AND merchantid = 'ATVPDKIKX0DER'
SELECT * FROM productoffers
                WHERE product_id = '7011' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 7011
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '7011'
                AND name = 'ListPriceAmount'
SELECT * FROM products WHERE id = '7045'
SELECT * FROM productimages WHERE product_id = '7045' ORDER BY sortorder ASC
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
SELECT * FROM product_image_select WHERE product_id = '7045'
SELECT * FROM productcustomimages WHERE product_id = '7045'
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
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
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
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '7045' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '7045' AND merchantid = 'ATVPDKIKX0DER'
SELECT * FROM productoffers
                WHERE product_id = '7045' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 7045
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '7045'
                AND name = 'ListPriceAmount'
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
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
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
SELECT value FROM productattributes WHERE product_id = '7045' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
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
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
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
SELECT * FROM `widget_options` WHERE `optionid` = 'latestpages1'
SELECT * FROM `pages` WHERE `core` = 0 ORDER BY `created_on` DESC LIMIT 0, 5
SELECT * FROM template_info WHERE templateuid = 'fsb-fluid'
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_user_data'
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_tracking_status'
SELECT * FROM pages WHERE id = 38
SELECT * FROM categories WHERE id = '27'
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
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
SELECT id FROM categories WHERE parent_id = '27'
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 
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 
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
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
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
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
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 
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 
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
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
SELECT id FROM categories WHERE parent_id = '27'
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
SELECT * FROM productimages WHERE product_id = '770' ORDER BY sortorder ASC
SELECT * FROM categoryimages WHERE category_id = 27
SELECT * FROM categorygroups WHERE id = '1'
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
SELECT * FROM categories WHERE id = '30'
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
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
SELECT id FROM categories WHERE parent_id = '30'
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 
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 
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
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
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
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
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 
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 
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
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
SELECT id FROM categories WHERE parent_id = '30'
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
SELECT * FROM productimages WHERE product_id = '785' ORDER BY sortorder ASC
SELECT * FROM categoryimages WHERE category_id = 30
SELECT * FROM categorygroups WHERE id = '1'
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
SELECT * FROM pages WHERE id = 59
SELECT * FROM pages WHERE id = 55
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
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:1679624475;s:8:\"products\";a:0:{}}' WHERE id = '8'
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
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:1679624475;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'
SELECT * FROM products WHERE id = 7004
SELECT * FROM products WHERE id = 7011
SELECT * FROM products WHERE id = 7045
SELECT * FROM products WHERE id = '7004'
SELECT * FROM productimages WHERE product_id = '7004' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '7004'
SELECT * FROM productcustomimages WHERE product_id = '7004'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '7004' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '7004' AND merchantid = 'ATVPDKIKX0DER'
SELECT * FROM productoffers
                WHERE product_id = '7004' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '7004' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '7011'
SELECT * FROM productimages WHERE product_id = '7011' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '7011'
SELECT * FROM productcustomimages WHERE product_id = '7011'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '7011' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '7011' AND merchantid = 'ATVPDKIKX0DER'
SELECT * FROM productoffers
                WHERE product_id = '7011' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 7011
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '7011'
                AND name = 'ListPriceAmount'
SELECT * FROM products WHERE id = '7045'
SELECT * FROM productimages WHERE product_id = '7045' ORDER BY sortorder ASC
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
SELECT * FROM product_image_select WHERE product_id = '7045'
SELECT * FROM productcustomimages WHERE product_id = '7045'
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
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
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
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '7045' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '7045' AND merchantid = 'ATVPDKIKX0DER'
SELECT * FROM productoffers
                WHERE product_id = '7045' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 7045
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '7045'
                AND name = 'ListPriceAmount'
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
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
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
SELECT value FROM productattributes WHERE product_id = '7045' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
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
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
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid' AND area = 'header' ORDER BY sortorder ASC
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid' AND area = 'footer' ORDER BY sortorder ASC
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-fluid' AND skinuid = ''
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid'
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid'
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid' AND imageuid = 'FB_DEFAULT_SHARE_IMAGE'
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid' AND imageuid = 'HEAD_LOGO'
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid' AND imageuid = 'HEAD_LOGO'

Number	Time (Seconds)	Time (Milliseconds)	Query
1	0.0003	0.0002899169921875	SELECT parameter, value FROM parameters
2	0.0004	0.00040388107299805	SELECT * FROM `bad_bots`
3	0.0002	0.00016498565673828	SET time_zone = 'Europe/London'
4	0.0002	0.00018978118896484	SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
5	0.0002	0.0001988410949707	INSERT INTO ga_users (`isbot`, `ips`) SELECT '1', 'a:1:{i:0;s:14:\"34.239.152.207\";}'
6	0.0001	0.00013899803161621	INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1679624475'
7	0.0003	0.00032806396484375	SELECT * FROM autorun ORDER BY lastrun ASC
8	0.0001	0.00012898445129395	UPDATE autorun SET lastrun = '2023-03-24 02:21:15' WHERE id = '8'
9	0.0001	9.3936920166016E-5	SELECT * FROM version ORDER BY installed DESC LIMIT 1
10	0.0004	0.00039911270141602	SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-fluid'
11	0.0036	0.0035901069641113	SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-fluid' AND language = 'en'
12	0.0002	0.00021100044250488	SELECT * FROM pages WHERE pagename = ''
13	0.0001	0.0001380443572998	SELECT * FROM categorygroups ORDER BY sortorder ASC
14	0.0002	0.00018501281738281	SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1' AND hidden = 0 ORDER BY sortorder ASC
15	0.0004	0.00035786628723145	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.0005	0.00049614906311035	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.0001	0.00011706352233887	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
18	0.0001	7.2002410888672E-5	SELECT id FROM categories WHERE parent_id = '27'
19	0.0002	0.00021195411682129	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.0001	0.0001218318939209	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.0001	0.00014615058898926	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.0001	0.00010299682617188	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
23	0.0001	7.2956085205078E-5	SELECT * FROM categorygroups WHERE id = '1'
24	0.0002	0.00021505355834961	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	0.00010085105895996	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	6.0081481933594E-5	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
27	0.0001	6.8187713623047E-5	SELECT id FROM categories WHERE parent_id = '29'
28	0.0002	0.00023198127746582	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	7.3909759521484E-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.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 (29) AND c.prod_type = 'custom' AND cp.hide = 0
31	0.0001	5.9127807617188E-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.00024604797363281	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	8.8930130004883E-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.6982040405273E-5	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
36	0.0001	8.2969665527344E-5	SELECT id FROM categories WHERE parent_id = '30'
37	0.0003	0.00025796890258789	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.3909759521484E-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.392333984375E-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	6.7949295043945E-5	SELECT * FROM categorygroups WHERE id = '1'
42	0.0002	0.00017499923706055	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	8.9168548583984E-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	7.319450378418E-5	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 38
45	0.0001	6.9141387939453E-5	SELECT id FROM categories WHERE parent_id = '38'
46	0.0002	0.00016999244689941	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	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 (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	6.0081481933594E-5	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '38'
50	0.0001	6.8187713623047E-5	SELECT * FROM categorygroups WHERE id = '1'
51	0.0001	0.00010013580322266	SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '2' AND hidden = 0 ORDER BY sortorder ASC
52	0.0005	0.00045394897460938	SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
53	0.0002	0.00020599365234375	SELECT * FROM sideboxes WHERE (templateuid = 'fsb-fluid' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
54	0.0002	0.00017595291137695	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.00018405914306641	SELECT value FROM template_options WHERE templateuid = 'fsb-fluid' AND optionuid = 'DISPLAY_CREDIT_ICON'
56	0.0003	0.00028491020202637	SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
57	0.0302	0.03023099899292	SELECT * FROM ipgeocountries WHERE INET_ATON('34.239.152.207') >= INET_ATON(ip_start) AND INET_ATON('34.239.152.207') <= INET_ATON(ip_end)
58	0.0003	0.00028395652770996	SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
59	0.0001	0.00012612342834473	SELECT * FROM countryredirects WHERE countrycode = 'US'
60	0.0005	0.00047492980957031	SELECT * FROM widget_options WHERE templateid = 'fsb-fluid' ORDER BY optionid
61	0.0011	0.0011279582977295	SELECT * FROM widgets_assigned WHERE templateuid = 'fsb-fluid' AND enabled = 1 ORDER BY widgetarea, sortorder
62	0.0002	0.00015401840209961	SELECT * FROM pages WHERE pagename = ''
63	0.0011	0.0010590553283691	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.0002	0.00020098686218262	SELECT * FROM productimages WHERE product_id = '760' ORDER BY sortorder ASC
65	0.0002	0.0001981258392334	SELECT * FROM product_image_select WHERE product_id = '760'
66	0.0002	0.00017309188842773	SELECT * FROM productcustomimages WHERE product_id = '760'
67	0.0005	0.00049591064453125	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '760' AND a.name = n.originalname
68	0.0002	0.00016903877258301	SELECT * FROM productoffers WHERE product_id = '760' AND merchantid = 'ATVPDKIKX0DER'
69	0.0001	0.00013208389282227	SELECT * FROM productoffers WHERE product_id = '760' AND price > 0 ORDER BY price ASC LIMIT 1
70	0.0002	0.0001521110534668	SELECT value FROM productattributes WHERE product_id = '760' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
71	0.0001	0.00011897087097168	SELECT * FROM productimages WHERE product_id = '829' ORDER BY sortorder ASC
72	0.0001	0.00012993812561035	SELECT * FROM product_image_select WHERE product_id = '829'
73	0.0001	8.702278137207E-5	SELECT * FROM productcustomimages WHERE product_id = '829'
74	0.0005	0.00046515464782715	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '829' AND a.name = n.originalname
75	0.0001	0.00010108947753906	SELECT * FROM productoffers WHERE product_id = '829' AND merchantid = 'ATVPDKIKX0DER'
76	0.0001	0.00010895729064941	SELECT * FROM productoffers WHERE product_id = '829' AND price > 0 ORDER BY price ASC LIMIT 1
77	0.0001	0.00013303756713867	SELECT value FROM productattributes WHERE product_id = '829' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
78	0.0001	0.00011205673217773	SELECT * FROM productimages WHERE product_id = '4399' ORDER BY sortorder ASC
79	0.0001	0.00013017654418945	SELECT * FROM product_image_select WHERE product_id = '4399'
80	0.0001	8.5115432739258E-5	SELECT * FROM productcustomimages WHERE product_id = '4399'
81	0.0003	0.00034284591674805	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4399' AND a.name = n.originalname
82	0.0001	9.7036361694336E-5	SELECT * FROM productoffers WHERE product_id = '4399' AND merchantid = 'ATVPDKIKX0DER'
83	0.0001	0.0001070499420166	SELECT * FROM productoffers WHERE product_id = '4399' AND price > 0 ORDER BY price ASC LIMIT 1
84	0.0001	0.00012588500976562	SELECT value FROM productattributes WHERE product_id = '4399' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
85	0.0001	0.00011420249938965	SELECT * FROM productimages WHERE product_id = '826' ORDER BY sortorder ASC
86	0.0001	0.00013589859008789	SELECT * FROM product_image_select WHERE product_id = '826'
87	0.0001	8.702278137207E-5	SELECT * FROM productcustomimages WHERE product_id = '826'
88	0.0003	0.00031805038452148	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '826' AND a.name = n.originalname
89	0.0001	0.00010800361633301	SELECT * FROM productoffers WHERE product_id = '826' AND merchantid = 'ATVPDKIKX0DER'
90	0.0001	0.00010895729064941	SELECT * FROM productoffers WHERE product_id = '826' AND price > 0 ORDER BY price ASC LIMIT 1
91	0.0001	0.00012993812561035	SELECT value FROM productattributes WHERE product_id = '826' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
92	0.0001	0.00013518333435059	SELECT * FROM productimages WHERE product_id = '791' ORDER BY sortorder ASC
93	0.0001	0.00014209747314453	SELECT * FROM product_image_select WHERE product_id = '791'
94	0.0001	8.702278137207E-5	SELECT * FROM productcustomimages WHERE product_id = '791'
95	0.0008	0.000823974609375	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '791' AND a.name = n.originalname
96	0.0001	9.9897384643555E-5	SELECT * FROM productoffers WHERE product_id = '791' AND merchantid = 'ATVPDKIKX0DER'
97	0.0001	0.00010800361633301	SELECT * FROM productoffers WHERE product_id = '791' AND price > 0 ORDER BY price ASC LIMIT 1
98	0.0001	0.00012803077697754	SELECT value FROM productattributes WHERE product_id = '791' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
99	0.0001	0.00010299682617188	SELECT * FROM productimages WHERE product_id = '780' ORDER BY sortorder ASC
100	0.0001	0.00012683868408203	SELECT * FROM product_image_select WHERE product_id = '780'
101	0.0001	8.392333984375E-5	SELECT * FROM productcustomimages WHERE product_id = '780'
102	0.0003	0.00034689903259277	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '780' AND a.name = n.originalname
103	0.0001	0.00010204315185547	SELECT * FROM productoffers WHERE product_id = '780' AND merchantid = 'ATVPDKIKX0DER'
104	0.0001	0.0001070499420166	SELECT * FROM productoffers WHERE product_id = '780' AND price > 0 ORDER BY price ASC LIMIT 1
105	0.0001	0.0001220703125	SELECT value FROM productattributes WHERE product_id = '780' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
106	0.0002	0.00015902519226074	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
107	0.0001	0.00011897087097168	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:1679624475;s:8:\"products\";a:0:{}}' WHERE id = '8'
108	0.0002	0.00020098686218262	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
109	0.0001	7.0095062255859E-5	SELECT id FROM custom_products p WHERE hide = 0 AND bestseller = 1 LIMIT 2
110	0.0001	6.4849853515625E-5	SELECT id,listingtype FROM ebay_products p WHERE hide = 0 ORDER BY soldcount DESC LIMIT 2
111	0.0001	0.00011181831359863	SELECT * FROM productimages WHERE product_id = '785' ORDER BY sortorder ASC
112	0.0001	0.00012683868408203	SELECT * FROM product_image_select WHERE product_id = '785'
113	0.0001	8.4877014160156E-5	SELECT * FROM productcustomimages WHERE product_id = '785'
114	0.0005	0.00050592422485352	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '785' AND a.name = n.originalname
115	0.0001	9.7036361694336E-5	SELECT * FROM productoffers WHERE product_id = '785' AND merchantid = 'ATVPDKIKX0DER'
116	0.0001	0.00010800361633301	SELECT * FROM productoffers WHERE product_id = '785' AND price > 0 ORDER BY price ASC LIMIT 1
117	0.0001	0.00013399124145508	SELECT value FROM productattributes WHERE product_id = '785' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
118	0.0001	0.00010204315185547	SELECT * FROM productimages WHERE product_id = '7838' ORDER BY sortorder ASC
119	0.0001	0.00013899803161621	SELECT * FROM product_image_select WHERE product_id = '7838'
120	0.0001	8.5115432739258E-5	SELECT * FROM productcustomimages WHERE product_id = '7838'
121	0.0004	0.00035905838012695	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '7838' AND a.name = n.originalname
122	0.0001	9.5844268798828E-5	SELECT * FROM productoffers WHERE product_id = '7838' AND merchantid = 'ATVPDKIKX0DER'
123	0.0001	0.00010800361633301	SELECT * FROM productoffers WHERE product_id = '7838' AND price > 0 ORDER BY price ASC LIMIT 1
124	0.0001	0.00012397766113281	SELECT value FROM productattributes WHERE product_id = '7838' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
125	0.0007	0.0007328987121582	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
126	0.0001	0.00012397766113281	SELECT * FROM productimages WHERE product_id = '769' ORDER BY sortorder ASC
127	0.0001	0.00012898445129395	SELECT * FROM product_image_select WHERE product_id = '769'
128	0.0001	9.4890594482422E-5	SELECT * FROM productcustomimages WHERE product_id = '769'
129	0.0003	0.00029683113098145	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '769' AND a.name = n.originalname
130	0.0001	9.9897384643555E-5	SELECT * FROM productoffers WHERE product_id = '769' AND merchantid = 'ATVPDKIKX0DER'
131	0.0001	0.00010895729064941	SELECT * FROM productoffers WHERE product_id = '769' AND price > 0 ORDER BY price ASC LIMIT 1
132	0.0001	0.0001220703125	SELECT value FROM productattributes WHERE product_id = '769' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
133	0.0001	0.00010395050048828	SELECT * FROM productimages WHERE product_id = '824' ORDER BY sortorder ASC
134	0.0001	0.0001380443572998	SELECT * FROM product_image_select WHERE product_id = '824'
135	0.0001	8.392333984375E-5	SELECT * FROM productcustomimages WHERE product_id = '824'
136	0.0006	0.00056695938110352	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '824' AND a.name = n.originalname
137	0.0001	9.9897384643555E-5	SELECT * FROM productoffers WHERE product_id = '824' AND merchantid = 'ATVPDKIKX0DER'
138	0.0001	0.00012111663818359	SELECT * FROM productoffers WHERE product_id = '824' AND price > 0 ORDER BY price ASC LIMIT 1
139	0.0001	0.00014686584472656	SELECT value FROM productattributes WHERE product_id = '824' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
140	0.0001	0.00011706352233887	SELECT * FROM productimages WHERE product_id = '821' ORDER BY sortorder ASC
141	0.0001	0.00013208389282227	SELECT * FROM product_image_select WHERE product_id = '821'
142	0.0001	8.392333984375E-5	SELECT * FROM productcustomimages WHERE product_id = '821'
143	0.0004	0.00039291381835938	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '821' AND a.name = n.originalname
144	0.0001	0.00010085105895996	SELECT * FROM productoffers WHERE product_id = '821' AND merchantid = 'ATVPDKIKX0DER'
145	0.0001	0.00012493133544922	SELECT * FROM productoffers WHERE product_id = '821' AND price > 0 ORDER BY price ASC LIMIT 1
146	0.0001	0.00012493133544922	SELECT value FROM productattributes WHERE product_id = '821' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
147	0.0001	0.00011610984802246	SELECT * FROM productimages WHERE product_id = '788' ORDER BY sortorder ASC
148	0.0001	0.00012993812561035	SELECT * FROM product_image_select WHERE product_id = '788'
149	0.0001	8.392333984375E-5	SELECT * FROM productcustomimages WHERE product_id = '788'
150	0.0004	0.00042104721069336	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '788' AND a.name = n.originalname
151	0.0001	9.7036361694336E-5	SELECT * FROM productoffers WHERE product_id = '788' AND merchantid = 'ATVPDKIKX0DER'
152	0.0001	0.00010895729064941	SELECT * FROM productoffers WHERE product_id = '788' AND price > 0 ORDER BY price ASC LIMIT 1
153	0.0001	0.00012016296386719	SELECT value FROM productattributes WHERE product_id = '788' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
154	0.0001	0.00011301040649414	SELECT * FROM productimages WHERE product_id = '830' ORDER BY sortorder ASC
155	0.0001	0.00012683868408203	SELECT * FROM product_image_select WHERE product_id = '830'
156	0.0001	9.3936920166016E-5	SELECT * FROM productcustomimages WHERE product_id = '830'
157	0.0005	0.00050711631774902	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '830' AND a.name = n.originalname
158	0.0001	9.608268737793E-5	SELECT * FROM productoffers WHERE product_id = '830' AND merchantid = 'ATVPDKIKX0DER'
159	0.0001	0.0001060962677002	SELECT * FROM productoffers WHERE product_id = '830' AND price > 0 ORDER BY price ASC LIMIT 1
160	0.0001	0.00014281272888184	SELECT value FROM productattributes WHERE product_id = '830' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
161	0.0001	0.00011301040649414	SELECT * FROM productimages WHERE product_id = '761' ORDER BY sortorder ASC
162	0.0001	0.00014305114746094	SELECT * FROM product_image_select WHERE product_id = '761'
163	0.0001	8.4877014160156E-5	SELECT * FROM productcustomimages WHERE product_id = '761'
164	0.0004	0.00042200088500977	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '761' AND a.name = n.originalname
165	0.0001	9.7990036010742E-5	SELECT * FROM productoffers WHERE product_id = '761' AND merchantid = 'ATVPDKIKX0DER'
166	0.0001	0.00011110305786133	SELECT * FROM productoffers WHERE product_id = '761' AND price > 0 ORDER BY price ASC LIMIT 1
167	0.0001	0.00014400482177734	SELECT value FROM productattributes WHERE product_id = '761' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
168	0.0002	0.00020503997802734	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
169	0.0001	0.00010180473327637	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:1679624475;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'
170	0.0001	0.00011396408081055	SELECT * FROM products WHERE id = 7004
171	0.0001	0.00010395050048828	SELECT * FROM products WHERE id = 7011
172	0.0001	0.00011086463928223	SELECT * FROM products WHERE id = 7045
173	0.0001	0.00010514259338379	SELECT * FROM products WHERE id = '7004'
174	0.0001	0.00012803077697754	SELECT * FROM productimages WHERE product_id = '7004' ORDER BY sortorder ASC
175	0.0001	0.00013089179992676	SELECT * FROM product_image_select WHERE product_id = '7004'
176	0.0001	8.392333984375E-5	SELECT * FROM productcustomimages WHERE product_id = '7004'
177	0.0005	0.00051403045654297	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '7004' AND a.name = n.originalname
178	0.0001	0.00011205673217773	SELECT * FROM productoffers WHERE product_id = '7004' AND merchantid = 'ATVPDKIKX0DER'
179	0.0001	0.00010895729064941	SELECT * FROM productoffers WHERE product_id = '7004' AND price > 0 ORDER BY price ASC LIMIT 1
180	0.0001	0.00014591217041016	SELECT value FROM productattributes WHERE product_id = '7004' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
181	0.0001	0.00010991096496582	SELECT * FROM products WHERE id = '7011'
182	0.0001	9.608268737793E-5	SELECT * FROM productimages WHERE product_id = '7011' ORDER BY sortorder ASC
183	0.0001	0.00012993812561035	SELECT * FROM product_image_select WHERE product_id = '7011'
184	0.0001	9.4890594482422E-5	SELECT * FROM productcustomimages WHERE product_id = '7011'
185	0.0006	0.0005650520324707	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '7011' AND a.name = n.originalname
186	0.0001	9.5129013061523E-5	SELECT * FROM productoffers WHERE product_id = '7011' AND merchantid = 'ATVPDKIKX0DER'
187	0.0001	9.7036361694336E-5	SELECT * FROM productoffers WHERE product_id = '7011' AND price > 0 ORDER BY price ASC LIMIT 1
188	0.0001	9.2029571533203E-5	SELECT * FROM productoffers WHERE product_id = 7011 ORDER BY price ASC LIMIT 1
189	0.0001	0.00012397766113281	SELECT value FROM productattributes WHERE product_id = '7011' AND name = 'ListPriceAmount'
190	0.0001	0.0001220703125	SELECT * FROM products WHERE id = '7045'
191	0.0001	9.2029571533203E-5	SELECT * FROM productimages WHERE product_id = '7045' ORDER BY sortorder ASC
192	0.0001	0.00013399124145508	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
193	0.0001	0.00013089179992676	SELECT * FROM product_image_select WHERE product_id = '7045'
194	0.0001	8.392333984375E-5	SELECT * FROM productcustomimages WHERE product_id = '7045'
195	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
196	0.0003	0.00026917457580566	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
197	0.0001	0.00011396408081055	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
198	0.0006	0.00056314468383789	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '7045' AND a.name = n.originalname
199	0.0001	0.00010204315185547	SELECT * FROM productoffers WHERE product_id = '7045' AND merchantid = 'ATVPDKIKX0DER'
200	0.0001	9.7990036010742E-5	SELECT * FROM productoffers WHERE product_id = '7045' AND price > 0 ORDER BY price ASC LIMIT 1
201	0.0001	0.00010418891906738	SELECT * FROM productoffers WHERE product_id = 7045 ORDER BY price ASC LIMIT 1
202	0.0001	0.0001060962677002	SELECT value FROM productattributes WHERE product_id = '7045' AND name = 'ListPriceAmount'
203	0.0001	0.00012612342834473	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
204	0.0002	0.00015997886657715	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
205	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
206	0.0001	0.0001380443572998	SELECT value FROM productattributes WHERE product_id = '7045' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
207	0.0002	0.00015592575073242	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
208	0.0002	0.00015783309936523	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
209	0.0004	0.00037097930908203	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
210	0.0001	7.2002410888672E-5	SELECT * FROM `widget_options` WHERE `optionid` = 'latestpages1'
211	0.0001	0.00010800361633301	SELECT * FROM `pages` WHERE `core` = 0 ORDER BY `created_on` DESC LIMIT 0, 5
212	0.0002	0.00016307830810547	SELECT * FROM template_info WHERE templateuid = 'fsb-fluid'
213	0.0001	0.00012707710266113	SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_user_data'
214	0.0001	6.7949295043945E-5	SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_tracking_status'
215	0.0001	8.8930130004883E-5	SELECT * FROM pages WHERE id = 38
216	0.0001	8.7976455688477E-5	SELECT * FROM categories WHERE id = '27'
217	0.0002	0.00017690658569336	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
218	0.0001	8.082389831543E-5	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
219	0.0001	6.7949295043945E-5	SELECT id FROM categories WHERE parent_id = '27'
220	0.0002	0.00017094612121582	SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c WHERE p.id = c.product_id AND c.category_id IN (27) AND p.parent_id = 0 AND p.hidden = 0 AND p.enabled = 1
221	0.0001	7.9870223999023E-5	SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c WHERE p.id = c.bundle_id AND c.category_id IN (27) AND p.disabled = 0
222	0.0001	8.7976455688477E-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
223	0.0001	6.0081481933594E-5	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
224	0.0001	0.00014805793762207	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
225	0.0001	6.103515625E-5	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
226	0.0002	0.00016617774963379	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
227	0.0001	8.6069107055664E-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
228	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
229	0.0001	5.793571472168E-5	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
230	0.0001	6.2942504882812E-5	SELECT id FROM categories WHERE parent_id = '27'
231	0.0002	0.00018310546875	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
232	0.0001	0.00011205673217773	SELECT * FROM productimages WHERE product_id = '770' ORDER BY sortorder ASC
233	0.0001	0.00011587142944336	SELECT * FROM categoryimages WHERE category_id = 27
234	0.0001	8.2969665527344E-5	SELECT * FROM categorygroups WHERE id = '1'
235	0.0002	0.00019478797912598	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
236	0.0001	9.0837478637695E-5	SELECT * FROM categories WHERE id = '30'
237	0.0002	0.00023293495178223	SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 30
238	0.0001	5.9843063354492E-5	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
239	0.0001	6.2942504882812E-5	SELECT id FROM categories WHERE parent_id = '30'
240	0.0002	0.0002439022064209	SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c WHERE p.id = c.product_id AND c.category_id IN (30) AND p.parent_id = 0 AND p.hidden = 0 AND p.enabled = 1
241	0.0001	7.7009201049805E-5	SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c WHERE p.id = c.bundle_id AND c.category_id IN (30) AND p.disabled = 0
242	0.0001	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
243	0.0001	7.3909759521484E-5	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
244	0.0002	0.00022602081298828	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
245	0.0001	5.9127807617188E-5	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
246	0.0002	0.00024008750915527	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
247	0.0001	7.2002410888672E-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
248	0.0001	8.0108642578125E-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
249	0.0001	6.5803527832031E-5	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
250	0.0001	6.1988830566406E-5	SELECT id FROM categories WHERE parent_id = '30'
251	0.0003	0.0002739429473877	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
252	0.0001	0.00011801719665527	SELECT * FROM productimages WHERE product_id = '785' ORDER BY sortorder ASC
253	0.0001	6.9141387939453E-5	SELECT * FROM categoryimages WHERE category_id = 30
254	0.0001	6.8902969360352E-5	SELECT * FROM categorygroups WHERE id = '1'
255	0.0003	0.00025200843811035	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
256	0.0001	9.5129013061523E-5	SELECT * FROM pages WHERE id = 59
257	0.0001	8.5115432739258E-5	SELECT * FROM pages WHERE id = 55
258	0.0001	0.00013184547424316	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
259	0.0001	8.7976455688477E-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:1679624475;s:8:\"products\";a:0:{}}' WHERE id = '8'
260	0.0002	0.00018787384033203	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
261	0.0001	8.0108642578125E-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:1679624475;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'
262	0.0001	0.00011086463928223	SELECT * FROM products WHERE id = 7004
263	0.0001	0.00011301040649414	SELECT * FROM products WHERE id = 7011
264	0.0001	0.00010108947753906	SELECT * FROM products WHERE id = 7045
265	0.0001	0.00011897087097168	SELECT * FROM products WHERE id = '7004'
266	0.0001	0.00011515617370605	SELECT * FROM productimages WHERE product_id = '7004' ORDER BY sortorder ASC
267	0.0001	0.00013184547424316	SELECT * FROM product_image_select WHERE product_id = '7004'
268	0.0001	8.6069107055664E-5	SELECT * FROM productcustomimages WHERE product_id = '7004'
269	0.0005	0.00053095817565918	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '7004' AND a.name = n.originalname
270	0.0001	9.7990036010742E-5	SELECT * FROM productoffers WHERE product_id = '7004' AND merchantid = 'ATVPDKIKX0DER'
271	0.0001	0.00010895729064941	SELECT * FROM productoffers WHERE product_id = '7004' AND price > 0 ORDER BY price ASC LIMIT 1
272	0.0001	0.0001370906829834	SELECT value FROM productattributes WHERE product_id = '7004' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
273	0.0001	0.00010895729064941	SELECT * FROM products WHERE id = '7011'
274	0.0001	9.7990036010742E-5	SELECT * FROM productimages WHERE product_id = '7011' ORDER BY sortorder ASC
275	0.0001	0.00013899803161621	SELECT * FROM product_image_select WHERE product_id = '7011'
276	0.0001	8.6069107055664E-5	SELECT * FROM productcustomimages WHERE product_id = '7011'
277	0.0006	0.0005500316619873	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '7011' AND a.name = n.originalname
278	0.0001	9.1075897216797E-5	SELECT * FROM productoffers WHERE product_id = '7011' AND merchantid = 'ATVPDKIKX0DER'
279	0.0001	0.00010514259338379	SELECT * FROM productoffers WHERE product_id = '7011' AND price > 0 ORDER BY price ASC LIMIT 1
280	0.0001	9.2029571533203E-5	SELECT * FROM productoffers WHERE product_id = 7011 ORDER BY price ASC LIMIT 1
281	0.0001	0.0001220703125	SELECT value FROM productattributes WHERE product_id = '7011' AND name = 'ListPriceAmount'
282	0.0001	0.00011014938354492	SELECT * FROM products WHERE id = '7045'
283	0.0001	9.1075897216797E-5	SELECT * FROM productimages WHERE product_id = '7045' ORDER BY sortorder ASC
284	0.0001	0.00012993812561035	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
285	0.0001	0.00013089179992676	SELECT * FROM product_image_select WHERE product_id = '7045'
286	0.0001	8.392333984375E-5	SELECT * FROM productcustomimages WHERE product_id = '7045'
287	0.0001	0.00013995170593262	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
288	0.0002	0.00017905235290527	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
289	0.0001	0.00011110305786133	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
290	0.0006	0.00056314468383789	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '7045' AND a.name = n.originalname
291	0.0001	0.00010299682617188	SELECT * FROM productoffers WHERE product_id = '7045' AND merchantid = 'ATVPDKIKX0DER'
292	0.0001	9.7036361694336E-5	SELECT * FROM productoffers WHERE product_id = '7045' AND price > 0 ORDER BY price ASC LIMIT 1
293	0.0001	0.00010895729064941	SELECT * FROM productoffers WHERE product_id = 7045 ORDER BY price ASC LIMIT 1
294	0.0001	0.0001060962677002	SELECT value FROM productattributes WHERE product_id = '7045' AND name = 'ListPriceAmount'
295	0.0001	0.00012397766113281	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
296	0.0002	0.00015687942504883	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
297	0.0001	0.0001060962677002	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
298	0.0001	0.0001380443572998	SELECT value FROM productattributes WHERE product_id = '7045' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
299	0.0002	0.00015401840209961	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
300	0.0002	0.00015878677368164	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
301	0.0002	0.00024008750915527	SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid' AND area = 'header' ORDER BY sortorder ASC
302	0.0002	0.00016689300537109	SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid' AND area = 'footer' ORDER BY sortorder ASC
303	0.0004	0.00039005279541016	SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-fluid' AND skinuid = ''
304	0.0002	0.00024294853210449	SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid'
305	0.0002	0.00015497207641602	SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid'
306	0.0003	0.00031805038452148	SELECT * FROM template_images WHERE templateuid = 'fsb-fluid' AND imageuid = 'FB_DEFAULT_SHARE_IMAGE'
307	0.0002	0.0002138614654541	SELECT * FROM template_images WHERE templateuid = 'fsb-fluid' AND imageuid = 'HEAD_LOGO'
308	0.0001	0.00014805793762207	SELECT * FROM template_images WHERE templateuid = 'fsb-fluid' AND imageuid = 'HEAD_LOGO'

Former Military Spouse

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

Law Student Cofee Cup Gift Idea for Attorney Lawyer

Funny Lawyer Christmas Gift Attorney Free Legal Advice Quote - Mug

Best Sellers

The Iraq War: A History Just For Kids!

Good Lawyers Never Lose Their Appeal - A...

Random Products

Miss You to Pieces: A Deployment Story a...

My Potty Activity Book +45 Toilet Traini...

Make Money on Amazon Video Direct: The B...

DK Readers L4: D-Day Landings: the Story...

The Wall (Reading Rainbow Books)

I'm a Work-at-Home Mommy--You can be too...

Connect with Us!

Browse Categories

Connect with us!

Debug Overview

No Amazon API Requests Made.

App Debug - Total Time 0.52166891098022 seconds

Query Debug - 308 Database Queries. Total time 0.0836 seconds