All Our Tags

Our full list of tags on the website is shown below. Simply click to view our products and find out more information on them.

App Total Time	DB Queries	DB Query Total Time	Amazon Requests
1.3607399463654	197	0.9702	0

App Total Time

DB Queries

DB Query Total Time

Amazon Requests

1.3607399463654

197

0.9702

No Amazon API Requests Made.

App Debug - Total Time 1.3607399463654 seconds

Number	Time From Start	Name	Description
1	0.34271097183228	Initialise	Initialise FSB Function
2	0.34526896476746	App Controller Start	Start of the App controller (called before the controller of every page)
3	0.38894200325012	Start of getCategoryListByGroup Function	Before first category groups query
4	0.38943886756897	After initial query	Before first category groups query
5	0.38943982124329	Get Category List for Group	Before the call to getCategoryList function
6	0.3894419670105	Start of GetCategoryList function	Start of the function
7	0.38944292068481	Before getting categories	Query to get specific category list
8	0.3900728225708	After getting categories	Query to get specific category list
9	0.3900740146637	Before getting category custom	Before call to function getCategoryCustom
10	0.40470099449158	After getting category custom	After call to function getCategoryCustom
11	0.40470194816589	Before getting category custom	Before call to function getCategoryCustom
12	0.4153528213501	After getting category custom	After call to function getCategoryCustom
13	0.41535496711731	Before getting category custom	Before call to function getCategoryCustom
14	0.42343497276306	After getting category custom	After call to function getCategoryCustom
15	0.42343592643738	Before getting category custom	Before call to function getCategoryCustom
16	0.42830491065979	After getting category custom	After call to function getCategoryCustom
17	0.42830586433411	Before getting category custom	Before call to function getCategoryCustom
18	0.43305587768555	After getting category custom	After call to function getCategoryCustom
19	0.43305778503418	Before getting category custom	Before call to function getCategoryCustom
20	0.43811178207397	After getting category custom	After call to function getCategoryCustom
21	0.43811392784119	End of GetCategoryList function	End of the function
22	0.43811798095703	Get Category List for Group	Before the call to getCategoryList function
23	0.43811893463135	Start of GetCategoryList function	Start of the function
24	0.43812084197998	Before getting categories	Query to get specific category list
25	0.43860077857971	End of getCategoryListByGroup Function	Before return()
26	1.1876418590546	App Controller End	End of the App controller (called before the controller of every page)
27	1.2608540058136	App_after Controller Start	Start of the App_after controller (called after the controller of every page)
28	1.2617428302765	Before Get Options	Before the call to getOptions in the tpl class
29	1.3168129920959	After Get Options	After the call to getOptions in the tpl class
30	1.3168427944183	App_after Controller End	End of the App_after controller (called after the controller of every page)
31	1.3607189655304	Finalizing debug	Before the debug is output to the page.
32	1.3607399463654	End of App	This is the end of the app logging, final timestamp

Query Debug - 197 Database Queries. Total time 0.9702 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:13:\"18.188.119.49\";}'
INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1746815964'
SELECT * FROM autorun ORDER BY lastrun ASC
SELECT * FROM version ORDER BY installed DESC LIMIT 1
SELECT id FROM pages WHERE pagename = 'tags' LIMIT 1
SELECT * FROM pages WHERE id = 51
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND language = 'en'
SELECT * FROM pages WHERE pagename = 'tags'
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 = 26
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 26
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
SELECT id FROM categories WHERE parent_id = '26'
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 
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 
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
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
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 = 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 = 28
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 28
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
SELECT id FROM categories WHERE parent_id = '28'
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 
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 
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
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
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 = 31
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 31
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31
SELECT id FROM categories WHERE parent_id = '31'
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 
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 
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
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
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-fluid2018' 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 * FROM sideboxes_pages WHERE sidebox_id = '26'
SELECT value FROM template_options WHERE templateuid = 'fsb-fluid2018' AND optionuid = 'DISPLAY_CREDIT_ICON'
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
SELECT * FROM ipgeocountries WHERE INET_ATON('18.188.119.49') >= INET_ATON(ip_start) AND INET_ATON('18.188.119.49') <= INET_ATON(ip_end)
SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
SELECT * FROM countryredirects WHERE countrycode = 'US'
SELECT * FROM pages WHERE pagename = 'tags'
SELECT COUNT(*) FROM tags t WHERE t.hidden = 0 AND t.display_alltags = 1 ORDER BY t.id 
SELECT * FROM tags t WHERE t.hidden = 0 AND t.display_alltags = 1 ORDER BY title ASC  LIMIT 0, 18
SELECT COUNT(DISTINCT(p.id)) FROM products p, product_tags t
				WHERE p.id = t.product_id
				  AND t.tag_id = '285'
				  AND p.parent_id = 0
				  AND p.enabled = 1
				  AND p.hidden = 0
SELECT COUNT(DISTINCT(p.id)) FROM products p, product_tags t
				WHERE p.id = t.product_id
				  AND t.tag_id = '285'
				  AND p.parent_id = 0
				  AND hidden = 0
				  AND enabled = 1 
SELECT p.id FROM products p, product_tags t WHERE p.id = t.product_id AND t.tag_id = '285' 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 = '1344' ORDER BY sortorder ASC
SELECT COUNT(DISTINCT(p.id)) FROM products p, product_tags t
				WHERE p.id = t.product_id
				  AND t.tag_id = '117'
				  AND p.parent_id = 0
				  AND p.enabled = 1
				  AND p.hidden = 0
SELECT COUNT(DISTINCT(p.id)) FROM products p, product_tags t
				WHERE p.id = t.product_id
				  AND t.tag_id = '117'
				  AND p.parent_id = 0
				  AND hidden = 0
				  AND enabled = 1 
SELECT p.id FROM products p, product_tags t WHERE p.id = t.product_id AND t.tag_id = '117' 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 = '1917' ORDER BY sortorder ASC
SELECT COUNT(DISTINCT(p.id)) FROM products p, product_tags t
				WHERE p.id = t.product_id
				  AND t.tag_id = '252'
				  AND p.parent_id = 0
				  AND p.enabled = 1
				  AND p.hidden = 0
SELECT COUNT(DISTINCT(p.id)) FROM products p, product_tags t
				WHERE p.id = t.product_id
				  AND t.tag_id = '252'
				  AND p.parent_id = 0
				  AND hidden = 0
				  AND enabled = 1 
SELECT p.id FROM products p, product_tags t WHERE p.id = t.product_id AND t.tag_id = '252' 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 = '822' ORDER BY sortorder ASC
SELECT COUNT(DISTINCT(p.id)) FROM products p, product_tags t
				WHERE p.id = t.product_id
				  AND t.tag_id = '3162'
				  AND p.parent_id = 0
				  AND p.enabled = 1
				  AND p.hidden = 0
SELECT COUNT(DISTINCT(p.id)) FROM products p, product_tags t
				WHERE p.id = t.product_id
				  AND t.tag_id = '3162'
				  AND p.parent_id = 0
				  AND hidden = 0
				  AND enabled = 1 
SELECT p.id FROM products p, product_tags t WHERE p.id = t.product_id AND t.tag_id = '3162' 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 = '3555' ORDER BY sortorder ASC
SELECT COUNT(DISTINCT(p.id)) FROM products p, product_tags t
				WHERE p.id = t.product_id
				  AND t.tag_id = '325'
				  AND p.parent_id = 0
				  AND p.enabled = 1
				  AND p.hidden = 0
SELECT COUNT(DISTINCT(p.id)) FROM products p, product_tags t
				WHERE p.id = t.product_id
				  AND t.tag_id = '325'
				  AND p.parent_id = 0
				  AND hidden = 0
				  AND enabled = 1 
SELECT p.id FROM products p, product_tags t WHERE p.id = t.product_id AND t.tag_id = '325' 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 = '2220' ORDER BY sortorder ASC
SELECT COUNT(DISTINCT(p.id)) FROM products p, product_tags t
				WHERE p.id = t.product_id
				  AND t.tag_id = '938'
				  AND p.parent_id = 0
				  AND p.enabled = 1
				  AND p.hidden = 0
SELECT COUNT(DISTINCT(p.id)) FROM products p, product_tags t
				WHERE p.id = t.product_id
				  AND t.tag_id = '938'
				  AND p.parent_id = 0
				  AND hidden = 0
				  AND enabled = 1 
SELECT p.id FROM products p, product_tags t WHERE p.id = t.product_id AND t.tag_id = '938' 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 = '4287' ORDER BY sortorder ASC
SELECT COUNT(DISTINCT(p.id)) FROM products p, product_tags t
				WHERE p.id = t.product_id
				  AND t.tag_id = '213'
				  AND p.parent_id = 0
				  AND p.enabled = 1
				  AND p.hidden = 0
SELECT COUNT(DISTINCT(p.id)) FROM products p, product_tags t
				WHERE p.id = t.product_id
				  AND t.tag_id = '213'
				  AND p.parent_id = 0
				  AND hidden = 0
				  AND enabled = 1 
SELECT p.id FROM products p, product_tags t WHERE p.id = t.product_id AND t.tag_id = '213' 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 = '1344' ORDER BY sortorder ASC
SELECT COUNT(DISTINCT(p.id)) FROM products p, product_tags t
				WHERE p.id = t.product_id
				  AND t.tag_id = '58'
				  AND p.parent_id = 0
				  AND p.enabled = 1
				  AND p.hidden = 0
SELECT COUNT(DISTINCT(p.id)) FROM products p, product_tags t
				WHERE p.id = t.product_id
				  AND t.tag_id = '58'
				  AND p.parent_id = 0
				  AND hidden = 0
				  AND enabled = 1 
SELECT p.id FROM products p, product_tags t WHERE p.id = t.product_id AND t.tag_id = '58' 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 = '868' ORDER BY sortorder ASC
SELECT COUNT(DISTINCT(p.id)) FROM products p, product_tags t
				WHERE p.id = t.product_id
				  AND t.tag_id = '15'
				  AND p.parent_id = 0
				  AND p.enabled = 1
				  AND p.hidden = 0
SELECT COUNT(DISTINCT(p.id)) FROM products p, product_tags t
				WHERE p.id = t.product_id
				  AND t.tag_id = '15'
				  AND p.parent_id = 0
				  AND hidden = 0
				  AND enabled = 1 
SELECT p.id FROM products p, product_tags t WHERE p.id = t.product_id AND t.tag_id = '15' 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 = '1010' ORDER BY sortorder ASC
SELECT COUNT(DISTINCT(p.id)) FROM products p, product_tags t
				WHERE p.id = t.product_id
				  AND t.tag_id = '81'
				  AND p.parent_id = 0
				  AND p.enabled = 1
				  AND p.hidden = 0
SELECT COUNT(DISTINCT(p.id)) FROM products p, product_tags t
				WHERE p.id = t.product_id
				  AND t.tag_id = '81'
				  AND p.parent_id = 0
				  AND hidden = 0
				  AND enabled = 1 
SELECT p.id FROM products p, product_tags t WHERE p.id = t.product_id AND t.tag_id = '81' 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 = '868' ORDER BY sortorder ASC
SELECT COUNT(DISTINCT(p.id)) FROM products p, product_tags t
				WHERE p.id = t.product_id
				  AND t.tag_id = '775'
				  AND p.parent_id = 0
				  AND p.enabled = 1
				  AND p.hidden = 0
SELECT COUNT(DISTINCT(p.id)) FROM products p, product_tags t
				WHERE p.id = t.product_id
				  AND t.tag_id = '775'
				  AND p.parent_id = 0
				  AND hidden = 0
				  AND enabled = 1 
SELECT p.id FROM products p, product_tags t WHERE p.id = t.product_id AND t.tag_id = '775' 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 = '4924' ORDER BY sortorder ASC
SELECT COUNT(DISTINCT(p.id)) FROM products p, product_tags t
				WHERE p.id = t.product_id
				  AND t.tag_id = '771'
				  AND p.parent_id = 0
				  AND p.enabled = 1
				  AND p.hidden = 0
SELECT COUNT(DISTINCT(p.id)) FROM products p, product_tags t
				WHERE p.id = t.product_id
				  AND t.tag_id = '771'
				  AND p.parent_id = 0
				  AND hidden = 0
				  AND enabled = 1 
SELECT p.id FROM products p, product_tags t WHERE p.id = t.product_id AND t.tag_id = '771' 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 = '1232' ORDER BY sortorder ASC
SELECT * FROM template_info WHERE templateuid = 'fsb-fluid2018'
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 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
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
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
SELECT * FROM products WHERE id = 1626
SELECT * FROM products WHERE id = 4041
SELECT * FROM products WHERE id = 4312
SELECT * FROM products WHERE id = 777
SELECT * FROM products WHERE id = 3881
SELECT * FROM products WHERE id = 4213
SELECT * FROM products WHERE id = '1626'
SELECT * FROM productimages WHERE product_id = '1626' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '1626'
SELECT * FROM productcustomimages WHERE product_id = '1626'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1626' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '1626' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '1626' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '1626' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '4041'
SELECT * FROM productimages WHERE product_id = '4041' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '4041'
SELECT * FROM productcustomimages WHERE product_id = '4041'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4041' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '4041' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '4041' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '4041' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '4312'
SELECT * FROM productimages WHERE product_id = '4312' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '4312'
SELECT * FROM productcustomimages WHERE product_id = '4312'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4312' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '4312' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '4312' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '4312' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '777'
SELECT * FROM productimages WHERE product_id = '777' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '777'
SELECT * FROM productcustomimages WHERE product_id = '777'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '777' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '777' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '777' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '777' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '3881'
SELECT * FROM productimages WHERE product_id = '3881' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '3881'
SELECT * FROM productcustomimages WHERE product_id = '3881'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3881' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '3881' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '3881' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '3881' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '4213'
SELECT * FROM productimages WHERE product_id = '4213' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '4213'
SELECT * FROM productcustomimages WHERE product_id = '4213'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4213' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '4213' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '4213' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '4213' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'header' ORDER BY sortorder ASC
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'footer' ORDER BY sortorder ASC
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND skinuid = ''
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid2018' AND imageuid = 'FB_DEFAULT_SHARE_IMAGE'
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid2018' AND imageuid = 'HEAD_LOGO'

Number	Time (Seconds)	Time (Milliseconds)	Query
1	0.0017	0.0016679763793945	SELECT parameter, value FROM parameters
2	0.0052	0.0051569938659668	SELECT * FROM `bad_bots`
3	0.0004	0.00041604042053223	SET time_zone = 'Europe/London'
4	0.0007	0.00065517425537109	SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
5	0.0006	0.00062394142150879	INSERT INTO ga_users (`isbot`, `ips`) SELECT '1', 'a:1:{i:0;s:13:\"18.188.119.49\";}'
6	0.0005	0.00051689147949219	INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1746815964'
7	0.0007	0.00070500373840332	SELECT * FROM autorun ORDER BY lastrun ASC
8	0.0004	0.00041794776916504	SELECT * FROM version ORDER BY installed DESC LIMIT 1
9	0.0012	0.0011789798736572	SELECT id FROM pages WHERE pagename = 'tags' LIMIT 1
10	0.0006	0.00064992904663086	SELECT * FROM pages WHERE id = 51
11	0.0031	0.0030531883239746	SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
12	0.0397	0.039712905883789	SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND language = 'en'
13	0.0005	0.00049805641174316	SELECT * FROM pages WHERE pagename = 'tags'
14	0.0005	0.00049400329589844	SELECT * FROM categorygroups ORDER BY sortorder ASC
15	0.0006	0.00062012672424316	SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1' AND hidden = 0 ORDER BY sortorder ASC
16	0.0055	0.0055301189422607	SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 26
17	0.0005	0.00052499771118164	SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 26
18	0.0004	0.00043606758117676	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
19	0.0005	0.00047612190246582	SELECT id FROM categories WHERE parent_id = '26'
20	0.0057	0.0056760311126709	SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c WHERE p.id = c.product_id AND c.category_id IN (26) AND p.parent_id = 0 AND p.hidden = 0 AND p.enabled = 1
21	0.0005	0.00054192543029785	SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c WHERE p.id = c.bundle_id AND c.category_id IN (26) AND p.disabled = 0
22	0.0005	0.00051498413085938	SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c WHERE cp.id = c.product_id AND c.category_id IN (26) AND c.prod_type = 'custom' AND cp.hide = 0
23	0.0004	0.00044512748718262	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
24	0.0004	0.00043416023254395	SELECT * FROM categorygroups WHERE id = '1'
25	0.0034	0.0034389495849609	SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 27
26	0.0005	0.0005340576171875	SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 27
27	0.0004	0.00043797492980957	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
28	0.0004	0.00040102005004883	SELECT id FROM categories WHERE parent_id = '27'
29	0.0037	0.0037021636962891	SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c WHERE p.id = c.product_id AND c.category_id IN (27) AND p.parent_id = 0 AND p.hidden = 0 AND p.enabled = 1
30	0.0005	0.00054407119750977	SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c WHERE p.id = c.bundle_id AND c.category_id IN (27) AND p.disabled = 0
31	0.0006	0.00061702728271484	SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c WHERE cp.id = c.product_id AND c.category_id IN (27) AND c.prod_type = 'custom' AND cp.hide = 0
32	0.0005	0.00050091743469238	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
33	0.0004	0.00043582916259766	SELECT * FROM categorygroups WHERE id = '1'
34	0.0019	0.0018548965454102	SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 28
35	0.0006	0.00060486793518066	SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 28
36	0.0005	0.00050997734069824	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
37	0.0005	0.00050497055053711	SELECT id FROM categories WHERE parent_id = '28'
38	0.0021	0.0020749568939209	SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c WHERE p.id = c.product_id AND c.category_id IN (28) AND p.parent_id = 0 AND p.hidden = 0 AND p.enabled = 1
39	0.0006	0.00064396858215332	SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c WHERE p.id = c.bundle_id AND c.category_id IN (28) AND p.disabled = 0
40	0.0007	0.00069189071655273	SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c WHERE cp.id = c.product_id AND c.category_id IN (28) AND c.prod_type = 'custom' AND cp.hide = 0
41	0.0006	0.00063085556030273	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
42	0.0005	0.00052404403686523	SELECT * FROM categorygroups WHERE id = '1'
43	0.0007	0.00069212913513184	SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 29
44	0.0006	0.00056719779968262	SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 29
45	0.0005	0.00049686431884766	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
46	0.0005	0.00047087669372559	SELECT id FROM categories WHERE parent_id = '29'
47	0.0007	0.00065898895263672	SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c WHERE p.id = c.product_id AND c.category_id IN (29) AND p.parent_id = 0 AND p.hidden = 0 AND p.enabled = 1
48	0.0006	0.00056195259094238	SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c WHERE p.id = c.bundle_id AND c.category_id IN (29) AND p.disabled = 0
49	0.0005	0.0005040168762207	SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c WHERE cp.id = c.product_id AND c.category_id IN (29) AND c.prod_type = 'custom' AND cp.hide = 0
50	0.0005	0.00045490264892578	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
51	0.0004	0.00041794776916504	SELECT * FROM categorygroups WHERE id = '1'
52	0.0006	0.00059199333190918	SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 30
53	0.0005	0.00048613548278809	SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 30
54	0.0004	0.00039887428283691	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
55	0.0004	0.00043392181396484	SELECT id FROM categories WHERE parent_id = '30'
56	0.0007	0.00065398216247559	SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c WHERE p.id = c.product_id AND c.category_id IN (30) AND p.parent_id = 0 AND p.hidden = 0 AND p.enabled = 1
57	0.0005	0.00049710273742676	SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c WHERE p.id = c.bundle_id AND c.category_id IN (30) AND p.disabled = 0
58	0.0005	0.00054097175598145	SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c WHERE cp.id = c.product_id AND c.category_id IN (30) AND c.prod_type = 'custom' AND cp.hide = 0
59	0.0006	0.0005500316619873	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
60	0.0006	0.0005638599395752	SELECT * FROM categorygroups WHERE id = '1'
61	0.0007	0.00071883201599121	SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 31
62	0.0006	0.00055503845214844	SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 31
63	0.0005	0.00046396255493164	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31
64	0.0005	0.0005340576171875	SELECT id FROM categories WHERE parent_id = '31'
65	0.0009	0.00085902214050293	SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c WHERE p.id = c.product_id AND c.category_id IN (31) AND p.parent_id = 0 AND p.hidden = 0 AND p.enabled = 1
66	0.0005	0.00051403045654297	SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c WHERE p.id = c.bundle_id AND c.category_id IN (31) AND p.disabled = 0
67	0.0005	0.00048589706420898	SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c WHERE cp.id = c.product_id AND c.category_id IN (31) AND c.prod_type = 'custom' AND cp.hide = 0
68	0.0005	0.00048208236694336	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
69	0.0004	0.00040698051452637	SELECT * FROM categorygroups WHERE id = '1'
70	0.0005	0.00047612190246582	SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '2' AND hidden = 0 ORDER BY sortorder ASC
71	0.0016	0.0016000270843506	SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
72	0.0008	0.00077676773071289	SELECT * FROM sideboxes WHERE (templateuid = 'fsb-fluid2018' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
73	0.0005	0.00050210952758789	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
74	0.0004	0.0003819465637207	SELECT * FROM sideboxes_pages WHERE sidebox_id = '26'
75	0.0010	0.001039981842041	SELECT value FROM template_options WHERE templateuid = 'fsb-fluid2018' AND optionuid = 'DISPLAY_CREDIT_ICON'
76	0.0009	0.00088214874267578	SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
77	0.7416	0.74156498908997	SELECT * FROM ipgeocountries WHERE INET_ATON('18.188.119.49') >= INET_ATON(ip_start) AND INET_ATON('18.188.119.49') <= INET_ATON(ip_end)
78	0.0011	0.001121997833252	SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
79	0.0005	0.0004570484161377	SELECT * FROM countryredirects WHERE countrycode = 'US'
80	0.0007	0.00068521499633789	SELECT * FROM pages WHERE pagename = 'tags'
81	0.0127	0.012702941894531	SELECT COUNT(*) FROM tags t WHERE t.hidden = 0 AND t.display_alltags = 1 ORDER BY t.id
82	0.0107	0.010713815689087	SELECT * FROM tags t WHERE t.hidden = 0 AND t.display_alltags = 1 ORDER BY title ASC LIMIT 0, 18
83	0.0009	0.00088691711425781	SELECT COUNT(DISTINCT(p.id)) FROM products p, product_tags t WHERE p.id = t.product_id AND t.tag_id = '285' AND p.parent_id = 0 AND p.enabled = 1 AND p.hidden = 0
84	0.0006	0.00063109397888184	SELECT COUNT(DISTINCT(p.id)) FROM products p, product_tags t WHERE p.id = t.product_id AND t.tag_id = '285' AND p.parent_id = 0 AND hidden = 0 AND enabled = 1
85	0.0006	0.00060510635375977	SELECT p.id FROM products p, product_tags t WHERE p.id = t.product_id AND t.tag_id = '285' AND p.hidden = 0 AND p.salesrank > 0 AND (p.price > 0 OR p.parent = 1) ORDER BY p.salesrank ASC LIMIT 1
86	0.0005	0.00050592422485352	SELECT * FROM productimages WHERE product_id = '1344' ORDER BY sortorder ASC
87	0.0011	0.0010621547698975	SELECT COUNT(DISTINCT(p.id)) FROM products p, product_tags t WHERE p.id = t.product_id AND t.tag_id = '117' AND p.parent_id = 0 AND p.enabled = 1 AND p.hidden = 0
88	0.0010	0.00096392631530762	SELECT COUNT(DISTINCT(p.id)) FROM products p, product_tags t WHERE p.id = t.product_id AND t.tag_id = '117' AND p.parent_id = 0 AND hidden = 0 AND enabled = 1
89	0.0011	0.0010700225830078	SELECT p.id FROM products p, product_tags t WHERE p.id = t.product_id AND t.tag_id = '117' AND p.hidden = 0 AND p.salesrank > 0 AND (p.price > 0 OR p.parent = 1) ORDER BY p.salesrank ASC LIMIT 1
90	0.0004	0.0003972053527832	SELECT * FROM productimages WHERE product_id = '1917' ORDER BY sortorder ASC
91	0.0007	0.00066685676574707	SELECT COUNT(DISTINCT(p.id)) FROM products p, product_tags t WHERE p.id = t.product_id AND t.tag_id = '252' AND p.parent_id = 0 AND p.enabled = 1 AND p.hidden = 0
92	0.0006	0.00058078765869141	SELECT COUNT(DISTINCT(p.id)) FROM products p, product_tags t WHERE p.id = t.product_id AND t.tag_id = '252' AND p.parent_id = 0 AND hidden = 0 AND enabled = 1
93	0.0006	0.00062298774719238	SELECT p.id FROM products p, product_tags t WHERE p.id = t.product_id AND t.tag_id = '252' AND p.hidden = 0 AND p.salesrank > 0 AND (p.price > 0 OR p.parent = 1) ORDER BY p.salesrank ASC LIMIT 1
94	0.0004	0.00043606758117676	SELECT * FROM productimages WHERE product_id = '822' ORDER BY sortorder ASC
95	0.0006	0.00059700012207031	SELECT COUNT(DISTINCT(p.id)) FROM products p, product_tags t WHERE p.id = t.product_id AND t.tag_id = '3162' AND p.parent_id = 0 AND p.enabled = 1 AND p.hidden = 0
96	0.0005	0.00052404403686523	SELECT COUNT(DISTINCT(p.id)) FROM products p, product_tags t WHERE p.id = t.product_id AND t.tag_id = '3162' AND p.parent_id = 0 AND hidden = 0 AND enabled = 1
97	0.0005	0.00047492980957031	SELECT p.id FROM products p, product_tags t WHERE p.id = t.product_id AND t.tag_id = '3162' AND p.hidden = 0 AND p.salesrank > 0 AND (p.price > 0 OR p.parent = 1) ORDER BY p.salesrank ASC LIMIT 1
98	0.0004	0.00044894218444824	SELECT * FROM productimages WHERE product_id = '3555' ORDER BY sortorder ASC
99	0.0007	0.00069212913513184	SELECT COUNT(DISTINCT(p.id)) FROM products p, product_tags t WHERE p.id = t.product_id AND t.tag_id = '325' AND p.parent_id = 0 AND p.enabled = 1 AND p.hidden = 0
100	0.0005	0.00052499771118164	SELECT COUNT(DISTINCT(p.id)) FROM products p, product_tags t WHERE p.id = t.product_id AND t.tag_id = '325' AND p.parent_id = 0 AND hidden = 0 AND enabled = 1
101	0.0005	0.00053977966308594	SELECT p.id FROM products p, product_tags t WHERE p.id = t.product_id AND t.tag_id = '325' AND p.hidden = 0 AND p.salesrank > 0 AND (p.price > 0 OR p.parent = 1) ORDER BY p.salesrank ASC LIMIT 1
102	0.0003	0.00034594535827637	SELECT * FROM productimages WHERE product_id = '2220' ORDER BY sortorder ASC
103	0.0006	0.00062894821166992	SELECT COUNT(DISTINCT(p.id)) FROM products p, product_tags t WHERE p.id = t.product_id AND t.tag_id = '938' AND p.parent_id = 0 AND p.enabled = 1 AND p.hidden = 0
104	0.0006	0.00055909156799316	SELECT COUNT(DISTINCT(p.id)) FROM products p, product_tags t WHERE p.id = t.product_id AND t.tag_id = '938' AND p.parent_id = 0 AND hidden = 0 AND enabled = 1
105	0.0006	0.00056719779968262	SELECT p.id FROM products p, product_tags t WHERE p.id = t.product_id AND t.tag_id = '938' AND p.hidden = 0 AND p.salesrank > 0 AND (p.price > 0 OR p.parent = 1) ORDER BY p.salesrank ASC LIMIT 1
106	0.0004	0.00035309791564941	SELECT * FROM productimages WHERE product_id = '4287' ORDER BY sortorder ASC
107	0.0006	0.00056815147399902	SELECT COUNT(DISTINCT(p.id)) FROM products p, product_tags t WHERE p.id = t.product_id AND t.tag_id = '213' AND p.parent_id = 0 AND p.enabled = 1 AND p.hidden = 0
108	0.0005	0.00047588348388672	SELECT COUNT(DISTINCT(p.id)) FROM products p, product_tags t WHERE p.id = t.product_id AND t.tag_id = '213' AND p.parent_id = 0 AND hidden = 0 AND enabled = 1
109	0.0005	0.00051116943359375	SELECT p.id FROM products p, product_tags t WHERE p.id = t.product_id AND t.tag_id = '213' AND p.hidden = 0 AND p.salesrank > 0 AND (p.price > 0 OR p.parent = 1) ORDER BY p.salesrank ASC LIMIT 1
110	0.0005	0.00052309036254883	SELECT * FROM productimages WHERE product_id = '1344' ORDER BY sortorder ASC
111	0.0018	0.0017619132995605	SELECT COUNT(DISTINCT(p.id)) FROM products p, product_tags t WHERE p.id = t.product_id AND t.tag_id = '58' AND p.parent_id = 0 AND p.enabled = 1 AND p.hidden = 0
112	0.0016	0.0016260147094727	SELECT COUNT(DISTINCT(p.id)) FROM products p, product_tags t WHERE p.id = t.product_id AND t.tag_id = '58' AND p.parent_id = 0 AND hidden = 0 AND enabled = 1
113	0.0017	0.0017440319061279	SELECT p.id FROM products p, product_tags t WHERE p.id = t.product_id AND t.tag_id = '58' AND p.hidden = 0 AND p.salesrank > 0 AND (p.price > 0 OR p.parent = 1) ORDER BY p.salesrank ASC LIMIT 1
114	0.0004	0.00044798851013184	SELECT * FROM productimages WHERE product_id = '868' ORDER BY sortorder ASC
115	0.0008	0.00084614753723145	SELECT COUNT(DISTINCT(p.id)) FROM products p, product_tags t WHERE p.id = t.product_id AND t.tag_id = '15' AND p.parent_id = 0 AND p.enabled = 1 AND p.hidden = 0
116	0.0008	0.00079894065856934	SELECT COUNT(DISTINCT(p.id)) FROM products p, product_tags t WHERE p.id = t.product_id AND t.tag_id = '15' AND p.parent_id = 0 AND hidden = 0 AND enabled = 1
117	0.0008	0.00078296661376953	SELECT p.id FROM products p, product_tags t WHERE p.id = t.product_id AND t.tag_id = '15' AND p.hidden = 0 AND p.salesrank > 0 AND (p.price > 0 OR p.parent = 1) ORDER BY p.salesrank ASC LIMIT 1
118	0.0005	0.00045108795166016	SELECT * FROM productimages WHERE product_id = '1010' ORDER BY sortorder ASC
119	0.0024	0.0023789405822754	SELECT COUNT(DISTINCT(p.id)) FROM products p, product_tags t WHERE p.id = t.product_id AND t.tag_id = '81' AND p.parent_id = 0 AND p.enabled = 1 AND p.hidden = 0
120	0.0024	0.0023651123046875	SELECT COUNT(DISTINCT(p.id)) FROM products p, product_tags t WHERE p.id = t.product_id AND t.tag_id = '81' AND p.parent_id = 0 AND hidden = 0 AND enabled = 1
121	0.0023	0.0022780895233154	SELECT p.id FROM products p, product_tags t WHERE p.id = t.product_id AND t.tag_id = '81' AND p.hidden = 0 AND p.salesrank > 0 AND (p.price > 0 OR p.parent = 1) ORDER BY p.salesrank ASC LIMIT 1
122	0.0004	0.00043511390686035	SELECT * FROM productimages WHERE product_id = '868' ORDER BY sortorder ASC
123	0.0006	0.00057697296142578	SELECT COUNT(DISTINCT(p.id)) FROM products p, product_tags t WHERE p.id = t.product_id AND t.tag_id = '775' AND p.parent_id = 0 AND p.enabled = 1 AND p.hidden = 0
124	0.0005	0.00050616264343262	SELECT COUNT(DISTINCT(p.id)) FROM products p, product_tags t WHERE p.id = t.product_id AND t.tag_id = '775' AND p.parent_id = 0 AND hidden = 0 AND enabled = 1
125	0.0005	0.00051617622375488	SELECT p.id FROM products p, product_tags t WHERE p.id = t.product_id AND t.tag_id = '775' AND p.hidden = 0 AND p.salesrank > 0 AND (p.price > 0 OR p.parent = 1) ORDER BY p.salesrank ASC LIMIT 1
126	0.0004	0.00036096572875977	SELECT * FROM productimages WHERE product_id = '4924' ORDER BY sortorder ASC
127	0.0005	0.0004889965057373	SELECT COUNT(DISTINCT(p.id)) FROM products p, product_tags t WHERE p.id = t.product_id AND t.tag_id = '771' AND p.parent_id = 0 AND p.enabled = 1 AND p.hidden = 0
128	0.0005	0.00048112869262695	SELECT COUNT(DISTINCT(p.id)) FROM products p, product_tags t WHERE p.id = t.product_id AND t.tag_id = '771' AND p.parent_id = 0 AND hidden = 0 AND enabled = 1
129	0.0005	0.00048708915710449	SELECT p.id FROM products p, product_tags t WHERE p.id = t.product_id AND t.tag_id = '771' AND p.hidden = 0 AND p.salesrank > 0 AND (p.price > 0 OR p.parent = 1) ORDER BY p.salesrank ASC LIMIT 1
130	0.0004	0.00035881996154785	SELECT * FROM productimages WHERE product_id = '1232' ORDER BY sortorder ASC
131	0.0006	0.00057888031005859	SELECT * FROM template_info WHERE templateuid = 'fsb-fluid2018'
132	0.0005	0.0004730224609375	SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_user_data'
133	0.0004	0.00036811828613281	SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_tracking_status'
134	0.0128	0.012770175933838	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
135	0.0077	0.007667064666748	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
136	0.0008	0.00082302093505859	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
137	0.0005	0.00050806999206543	SELECT * FROM products WHERE id = 1626
138	0.0004	0.00040698051452637	SELECT * FROM products WHERE id = 4041
139	0.0004	0.00039887428283691	SELECT * FROM products WHERE id = 4312
140	0.0004	0.00042510032653809	SELECT * FROM products WHERE id = 777
141	0.0004	0.00036883354187012	SELECT * FROM products WHERE id = 3881
142	0.0004	0.0003669261932373	SELECT * FROM products WHERE id = 4213
143	0.0004	0.00036001205444336	SELECT * FROM products WHERE id = '1626'
144	0.0004	0.00043892860412598	SELECT * FROM productimages WHERE product_id = '1626' ORDER BY sortorder ASC
145	0.0006	0.00055599212646484	SELECT * FROM product_image_select WHERE product_id = '1626'
146	0.0004	0.00037384033203125	SELECT * FROM productcustomimages WHERE product_id = '1626'
147	0.0008	0.00081586837768555	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1626' AND a.name = n.originalname
148	0.0006	0.000579833984375	SELECT * FROM productoffers WHERE product_id = '1626' AND merchantid = 'A1X6FK5RDHNB96'
149	0.0004	0.00036787986755371	SELECT * FROM productoffers WHERE product_id = '1626' AND price > 0 ORDER BY price ASC LIMIT 1
150	0.0004	0.00044608116149902	SELECT value FROM productattributes WHERE product_id = '1626' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
151	0.0005	0.00047707557678223	SELECT * FROM products WHERE id = '4041'
152	0.0005	0.00052189826965332	SELECT * FROM productimages WHERE product_id = '4041' ORDER BY sortorder ASC
153	0.0007	0.00066494941711426	SELECT * FROM product_image_select WHERE product_id = '4041'
154	0.0004	0.00037479400634766	SELECT * FROM productcustomimages WHERE product_id = '4041'
155	0.0011	0.0010740756988525	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4041' AND a.name = n.originalname
156	0.0005	0.0004570484161377	SELECT * FROM productoffers WHERE product_id = '4041' AND merchantid = 'A1X6FK5RDHNB96'
157	0.0004	0.00036311149597168	SELECT * FROM productoffers WHERE product_id = '4041' AND price > 0 ORDER BY price ASC LIMIT 1
158	0.0004	0.00040411949157715	SELECT value FROM productattributes WHERE product_id = '4041' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
159	0.0004	0.00043988227844238	SELECT * FROM products WHERE id = '4312'
160	0.0004	0.0004420280456543	SELECT * FROM productimages WHERE product_id = '4312' ORDER BY sortorder ASC
161	0.0005	0.00051712989807129	SELECT * FROM product_image_select WHERE product_id = '4312'
162	0.0003	0.00034785270690918	SELECT * FROM productcustomimages WHERE product_id = '4312'
163	0.0010	0.00096797943115234	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4312' AND a.name = n.originalname
164	0.0004	0.00042104721069336	SELECT * FROM productoffers WHERE product_id = '4312' AND merchantid = 'A1X6FK5RDHNB96'
165	0.0004	0.00039315223693848	SELECT * FROM productoffers WHERE product_id = '4312' AND price > 0 ORDER BY price ASC LIMIT 1
166	0.0004	0.00038719177246094	SELECT value FROM productattributes WHERE product_id = '4312' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
167	0.0005	0.00045990943908691	SELECT * FROM products WHERE id = '777'
168	0.0005	0.00045585632324219	SELECT * FROM productimages WHERE product_id = '777' ORDER BY sortorder ASC
169	0.0005	0.00053191184997559	SELECT * FROM product_image_select WHERE product_id = '777'
170	0.0004	0.00036001205444336	SELECT * FROM productcustomimages WHERE product_id = '777'
171	0.0010	0.00099587440490723	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '777' AND a.name = n.originalname
172	0.0004	0.00042510032653809	SELECT * FROM productoffers WHERE product_id = '777' AND merchantid = 'A1X6FK5RDHNB96'
173	0.0004	0.00035405158996582	SELECT * FROM productoffers WHERE product_id = '777' AND price > 0 ORDER BY price ASC LIMIT 1
174	0.0004	0.00041913986206055	SELECT value FROM productattributes WHERE product_id = '777' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
175	0.0004	0.00043082237243652	SELECT * FROM products WHERE id = '3881'
176	0.0005	0.0005040168762207	SELECT * FROM productimages WHERE product_id = '3881' ORDER BY sortorder ASC
177	0.0005	0.00053095817565918	SELECT * FROM product_image_select WHERE product_id = '3881'
178	0.0005	0.0005190372467041	SELECT * FROM productcustomimages WHERE product_id = '3881'
179	0.0020	0.0019609928131104	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3881' AND a.name = n.originalname
180	0.0005	0.00046682357788086	SELECT * FROM productoffers WHERE product_id = '3881' AND merchantid = 'A1X6FK5RDHNB96'
181	0.0004	0.00041389465332031	SELECT * FROM productoffers WHERE product_id = '3881' AND price > 0 ORDER BY price ASC LIMIT 1
182	0.0004	0.00042200088500977	SELECT value FROM productattributes WHERE product_id = '3881' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
183	0.0005	0.00050210952758789	SELECT * FROM products WHERE id = '4213'
184	0.0006	0.00059080123901367	SELECT * FROM productimages WHERE product_id = '4213' ORDER BY sortorder ASC
185	0.0007	0.00065898895263672	SELECT * FROM product_image_select WHERE product_id = '4213'
186	0.0005	0.00045990943908691	SELECT * FROM productcustomimages WHERE product_id = '4213'
187	0.0011	0.0011279582977295	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4213' AND a.name = n.originalname
188	0.0005	0.00049805641174316	SELECT * FROM productoffers WHERE product_id = '4213' AND merchantid = 'A1X6FK5RDHNB96'
189	0.0004	0.00039482116699219	SELECT * FROM productoffers WHERE product_id = '4213' AND price > 0 ORDER BY price ASC LIMIT 1
190	0.0005	0.00045895576477051	SELECT value FROM productattributes WHERE product_id = '4213' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
191	0.0008	0.00076985359191895	SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'header' ORDER BY sortorder ASC
192	0.0006	0.00064420700073242	SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'footer' ORDER BY sortorder ASC
193	0.0016	0.0015549659729004	SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND skinuid = ''
194	0.0006	0.0006411075592041	SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
195	0.0006	0.00055098533630371	SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
196	0.0006	0.00063991546630859	SELECT * FROM template_images WHERE templateuid = 'fsb-fluid2018' AND imageuid = 'FB_DEFAULT_SHARE_IMAGE'
197	0.0005	0.0005490779876709	SELECT * FROM template_images WHERE templateuid = 'fsb-fluid2018' AND imageuid = 'HEAD_LOGO'

All Our Tags

30 Sachets Mousseline De

Avec

Bambou

Céramique

De 30 Sachets Mousseline

De La

Mariage Fr

Pour

Thandeacute

Thé

Thés

Thés And Traditions

Browse Categories

Debug Overview

No Amazon API Requests Made.

App Debug - Total Time 1.3607399463654 seconds

Query Debug - 197 Database Queries. Total time 0.9702 seconds

All Our Tags

30 Sachets Mousseline De

Avec

Bambou

Céramique

De 30 Sachets Mousseline

De La

Mariage Fr

Pour

Thandeacute

Thé

Thés

Thés And Traditions

Browse Categories

Wait! We have a something for you...

Debug Overview

No Amazon API Requests Made.

App Debug - Total Time 1.3607399463654 seconds

Query Debug - 197 Database Queries. Total time 0.9702 seconds