Lawyer Free Legal Advice Journal - Notebook: Funny Attorney Client DIY Writing Pad, Diary Planner, Lined Page Note Book (Red) (Professional Law Gifts Vol 8)

Price: $6.99
Product prices and availability are accurate as of 2021-11-10 23:07:10 UTC and are subject to change. Any price and availability information displayed on https://www.amazon.com/ at the time of purchase will apply to the purchase of this product.
Availability: In Stock
In Stock.
CERTAIN CONTENT THAT APPEARS ON THIS SITE COMES FROM AMAZON SERVICES LLC. THIS CONTENT IS PROVIDED 'AS IS' AND IS SUBJECT TO CHANGE OR REMOVAL AT ANY TIME.

Debug Overview

App Total Time DB Queries DB Query Total Time Amazon Requests
0.31210589408875 214 0.0679 0


No Amazon API Requests Made.


App Debug - Total Time 0.31210589408875 seconds

Number Time From Start Name Description
1 0.2273690700531 Initialise Initialise FSB Function
2 0.22826600074768 App Controller Start Start of the App controller (called before the controller of every page)
3 0.23305797576904 Start of getCategoryListByGroup Function Before first category groups query
4 0.23321795463562 After initial query Before first category groups query
5 0.23321795463562 Get Category List for Group Before the call to getCategoryList function
6 0.23322105407715 Start of GetCategoryList function Start of the function
7 0.23322296142578 Before getting categories Query to get specific category list
8 0.23342394828796 After getting categories Query to get specific category list
9 0.23342490196228 Before getting category custom Before call to function getCategoryCustom
10 0.23484206199646 After getting category custom After call to function getCategoryCustom
11 0.23484396934509 Before getting category custom Before call to function getCategoryCustom
12 0.23603701591492 After getting category custom After call to function getCategoryCustom
13 0.23603796958923 Before getting category custom Before call to function getCategoryCustom
14 0.23730206489563 After getting category custom After call to function getCategoryCustom
15 0.23730301856995 Before getting category custom Before call to function getCategoryCustom
16 0.2383770942688 After getting category custom After call to function getCategoryCustom
17 0.23837804794312 End of GetCategoryList function End of the function
18 0.23838090896606 Get Category List for Group Before the call to getCategoryList function
19 0.23838210105896 Start of GetCategoryList function Start of the function
20 0.23838400840759 Before getting categories Query to get specific category list
21 0.23856997489929 End of getCategoryListByGroup Function Before return()
22 0.26901602745056 App Controller End End of the App controller (called before the controller of every page)
23 0.26953792572021 Product Start Start of the product info controller
24 0.27061295509338 Cache file not found Starting get product details
25 0.27522897720337 Related products Start getting related products if enabled
26 0.27522897720337 Related Products Start Before the related products are found
27 0.27522993087769 Related Products Keywords Before the related product keywords are found
28 0.2752320766449 Create Keyword List Function Start of function
29 0.27532005310059 Create Keyword List Function After looping provided content - 69 keywords found
30 0.27698588371277 Create Keyword List Function After looping initial keyword list - 63 keywords remaining
31 0.27699995040894 Create Keyword List Function After reducing keyword list
32 0.27725195884705 Create Keyword List Function After selecting by scoring keywords
33 0.27725505828857 Create Keyword List Function After final loop of keywords
34 0.27725696563721 Related Products Keywords After the related product keywords are found
35 0.28359889984131 Related Products End After the related products are found
36 0.28550791740417 Product End End of the product info controller (Product Info)
37 0.28605699539185 App_after Controller Start Start of the App_after controller (called after the controller of every page)
38 0.28631901741028 Before Get Options Before the call to getOptions in the tpl class
39 0.30183100700378 After Get Options After the call to getOptions in the tpl class
40 0.30194091796875 App_after Controller End End of the App_after controller (called after the controller of every page)
41 0.30195999145508 Product Info: Before Smarty Fetch Before the product.tpl template is fetched
42 0.30502510070801 Product Info: After Smarty Fetch After the product.tpl template is fetched
43 0.30502700805664 Product Info: Before Template Display Before the template is displayed
44 0.31209301948547 Product Info: After Template Display After the template is displayed
45 0.31209802627563 Finalizing debug Before the debug is output to the page.
46 0.31210589408875 End of App This is the end of the app logging, final timestamp


Query Debug - 214 Database Queries. Total time 0.0679 seconds

Number Time (Seconds) Time (Milliseconds) Query
1 0.0003 0.00025010108947754
SELECT parameter, value FROM parameters
2 0.0003 0.00030612945556641
SELECT * FROM `bad_bots`
3 0.0002 0.00017714500427246
SET time_zone = 'Europe/London'
4 0.0001 0.00013303756713867
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
5 0.0002 0.00019717216491699
INSERT INTO ga_users (`isbot`, `ips`) SELECT '1', 'a:1:{i:0;s:13:\"34.228.229.51\";}'
6 0.0001 0.00013518333435059
INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1638251355'
7 0.0003 0.0003361701965332
SELECT * FROM autorun ORDER BY lastrun ASC
8 0.0001 0.00012898445129395
SELECT * FROM version ORDER BY installed DESC LIMIT 1
9 0.0002 0.0001981258392334
SELECT id FROM pages WHERE pagename = 'lawyer-free-legal-advice-journal-notebook-funny-attorney-client-diy' LIMIT 1
10 0.0002 0.00019216537475586
SELECT id FROM products WHERE pagename = 'lawyer-free-legal-advice-journal-notebook-funny-attorney-client-diy' AND hidden = 0 LIMIT 1
11 0.0004 0.00041913986206055
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-fluid'
12 0.0037 0.003709077835083
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-fluid' AND language = 'en'
13 0.0002 0.0001521110534668
SELECT * FROM pages WHERE pagename = 'lawyer-free-legal-advice-journal-notebook-funny-attorney-client-diy'
14 0.0001 0.00014901161193848
SELECT * FROM categorygroups ORDER BY sortorder ASC
15 0.0002 0.00017404556274414
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
16 0.0003 0.00026106834411621
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
17 0.0001 0.00014901161193848
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 27
18 0.0001 0.00012087821960449
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
19 0.0001 8.3208084106445E-5
SELECT id FROM categories WHERE parent_id = '27'
20 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 
21 0.0001 0.00013899803161621
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 
22 0.0001 0.00014400482177734
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
23 0.0001 0.00011587142944336
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
24 0.0001 8.4877014160156E-5
SELECT * FROM categorygroups WHERE id = '1'
25 0.0002 0.00024294853210449
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
26 0.0001 0.00010800361633301
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 29
27 0.0001 7.2956085205078E-5
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
28 0.0001 8.1062316894531E-5
SELECT id FROM categories WHERE parent_id = '29'
29 0.0003 0.00025415420532227
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 
30 0.0001 8.4161758422852E-5
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (29)
				  AND p.disabled = 0 
31 0.0001 9.7036361694336E-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
32 0.0001 8.6069107055664E-5
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
33 0.0001 8.392333984375E-5
SELECT * FROM categorygroups WHERE id = '1'
34 0.0003 0.00027704238891602
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
35 0.0001 0.00010895729064941
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 30
36 0.0001 7.1048736572266E-5
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
37 0.0001 8.2015991210938E-5
SELECT id FROM categories WHERE parent_id = '30'
38 0.0003 0.00029897689819336
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 
39 0.0001 8.4161758422852E-5
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (30)
				  AND p.disabled = 0 
40 0.0001 9.608268737793E-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
41 0.0001 7.9870223999023E-5
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
42 0.0001 8.4161758422852E-5
SELECT * FROM categorygroups WHERE id = '1'
43 0.0002 0.00019216537475586
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
44 0.0001 9.5129013061523E-5
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 38
45 0.0001 7.0810317993164E-5
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 38
46 0.0001 8.1062316894531E-5
SELECT id FROM categories WHERE parent_id = '38'
47 0.0002 0.00018715858459473
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 
48 0.0001 8.2015991210938E-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 
49 0.0001 0.00010800361633301
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (38)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
50 0.0001 8.9883804321289E-5
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '38'
51 0.0001 8.4161758422852E-5
SELECT * FROM categorygroups WHERE id = '1'
52 0.0002 0.00017690658569336
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '2'  AND hidden = 0 ORDER BY sortorder ASC
53 0.0005 0.00051498413085938
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
54 0.0002 0.00020003318786621
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-fluid' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
55 0.0002 0.00018501281738281
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
56 0.0002 0.00020718574523926
SELECT value FROM template_options WHERE templateuid = 'fsb-fluid' AND optionuid = 'DISPLAY_CREDIT_ICON'
57 0.0003 0.00033903121948242
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
58 0.0277 0.027674913406372
SELECT * FROM ipgeocountries WHERE INET_ATON('34.228.229.51') >= INET_ATON(ip_start) AND INET_ATON('34.228.229.51') <= INET_ATON(ip_end)
59 0.0003 0.00028705596923828
SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
60 0.0001 0.00012803077697754
SELECT * FROM countryredirects WHERE countrycode = 'US'
61 0.0002 0.00017905235290527
SELECT * FROM products WHERE pagename = 'lawyer-free-legal-advice-journal-notebook-funny-attorney-client-diy'
62 0.0006 0.00055718421936035
UPDATE products SET viewcount = viewcount + 1 WHERE id = 7826
63 0.0003 0.0003361701965332
SELECT * FROM manufacturers WHERE id = '325'
64 0.0005 0.00047397613525391
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '325'
65 0.0001 0.00011587142944336
SELECT filename FROM manufacturerimages WHERE manufacturer_id = '325' LIMIT 1
66 0.0003 0.00025796890258789
SELECT p.pagename, p.id FROM products p, productimages i WHERE p.id = i.product_id AND manufacturer_id = '325' ORDER BY RAND() LIMIT 1
67 0.0001 0.00012993812561035
SELECT * FROM productimages WHERE product_id = '7840' ORDER BY sortorder ASC
68 0.0002 0.00017213821411133
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '325'
69 0.0002 0.00017905235290527
SELECT COUNT(DISTINCT(p.id)) FROM products p
				WHERE p.manufacturer_id = '325'
				  AND p.hidden = 0
				  AND p.enabled = 1
				  AND p.parent_id = 0 
70 0.0001 8.2015991210938E-5
SELECT * FROM manufacturerimages WHERE manufacturer_id = '325'
71 0.0001 8.3208084106445E-5
SELECT category_id FROM products_categories WHERE product_id = '7826'
72 0.0001 0.00010919570922852
SELECT * FROM productimages WHERE product_id = '7826' ORDER BY sortorder ASC
73 0.0002 0.0001678466796875
SELECT * FROM product_image_select WHERE product_id = '7826'
74 0.0001 0.00013613700866699
SELECT * FROM productcustomimages WHERE product_id = '7826'
75 0.0001 0.00013899803161621
SELECT * FROM productfeeds WHERE product_id = '7826' ORDER BY item_date DESC
76 0.0002 0.00021696090698242
SELECT a.name, n.displayname, a.value, n.units, n.valuetype FROM productattributes a, productattributenames n WHERE product_id = '7826' AND a.name = n.originalname AND n.display = 1 AND n.hidden = 0
77 0.0002 0.00020098686218262
SELECT DISTINCT(pt.tag_id) FROM product_tags pt, tags t WHERE pt.tag_id = t.id AND pt.product_id = '7826' AND t.hidden = 0 AND display_product = 1
78 0.0004 0.00035214424133301
SELECT * FROM productamazoncontent WHERE product_id = '7826'
79 0.0004 0.00039505958557129
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '7826' AND a.name = n.originalname
80 0.0001 0.00014591217041016
SELECT * FROM productoffers WHERE product_id = '7826' AND merchantid = 'ATVPDKIKX0DER'
81 0.0001 0.00012302398681641
SELECT * FROM productoffers
                WHERE product_id = '7826' AND price > 0
                ORDER BY price ASC LIMIT 1
82 0.0001 0.0001380443572998
SELECT value FROM productattributes WHERE product_id = '7826' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
83 0.0002 0.00017189979553223
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
84 0.0010 0.00095582008361816
SELECT *, MATCH (description, title) AGAINST ('diary planner lined' IN BOOLEAN MODE) AS `searchrelevance` FROM products WHERE MATCH (description, title) AGAINST ('diary planner lined' IN BOOLEAN MODE) AND 7826 <> 0 AND enabled = 1 AND hidden = 0 AND offers > 0 AND parent_id = 0 ORDER BY `searchrelevance` LIMIT 3
85 0.0002 0.00015401840209961
SELECT *, MATCH (description, title) AGAINST ('diary planner lined' IN BOOLEAN MODE) AS `searchrelevance` FROM ebay_products WHERE MATCH (description, title) AGAINST ('diary planner lined' IN BOOLEAN MODE) AND 7826 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 3
86 0.0001 0.00014519691467285
SELECT *, MATCH (description, title) AGAINST ('diary planner lined' IN BOOLEAN MODE) AS `searchrelevance` FROM custom_products WHERE MATCH (description, title) AGAINST ('diary planner lined' IN BOOLEAN MODE) AND 7826 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 3
87 0.0001 0.00011992454528809
SELECT * FROM productimages WHERE product_id = '7847' ORDER BY sortorder ASC
88 0.0001 0.0001380443572998
SELECT * FROM product_image_select WHERE product_id = '7847'
89 0.0001 0.00010108947753906
SELECT * FROM productcustomimages WHERE product_id = '7847'
90 0.0013 0.0013120174407959
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '7847' AND a.name = n.originalname
91 0.0002 0.00020003318786621
SELECT * FROM productoffers WHERE product_id = '7847' AND merchantid = 'ATVPDKIKX0DER'
92 0.0002 0.00020909309387207
SELECT * FROM productoffers
                WHERE product_id = '7847' AND price > 0
                ORDER BY price ASC LIMIT 1
93 0.0002 0.00017118453979492
SELECT value FROM productattributes WHERE product_id = '7847' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
94 0.0001 0.00011301040649414
SELECT * FROM productimages WHERE product_id = '7836' ORDER BY sortorder ASC
95 0.0002 0.00018000602722168
SELECT * FROM product_image_select WHERE product_id = '7836'
96 0.0001 9.918212890625E-5
SELECT * FROM productcustomimages WHERE product_id = '7836'
97 0.0005 0.00045418739318848
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '7836' AND a.name = n.originalname
98 0.0001 0.00010418891906738
SELECT * FROM productoffers WHERE product_id = '7836' AND merchantid = 'ATVPDKIKX0DER'
99 0.0001 0.00013208389282227
SELECT * FROM productoffers
                WHERE product_id = '7836' AND price > 0
                ORDER BY price ASC LIMIT 1
100 0.0001 0.0001380443572998
SELECT value FROM productattributes WHERE product_id = '7836' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
101 0.0001 0.0001220703125
SELECT * FROM productimages WHERE product_id = '7833' ORDER BY sortorder ASC
102 0.0001 0.00013113021850586
SELECT * FROM product_image_select WHERE product_id = '7833'
103 0.0001 0.00010204315185547
SELECT * FROM productcustomimages WHERE product_id = '7833'
104 0.0004 0.0003659725189209
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '7833' AND a.name = n.originalname
105 0.0001 0.00010514259338379
SELECT * FROM productoffers WHERE product_id = '7833' AND merchantid = 'ATVPDKIKX0DER'
106 0.0001 0.00012111663818359
SELECT * FROM productoffers
                WHERE product_id = '7833' AND price > 0
                ORDER BY price ASC LIMIT 1
107 0.0001 0.0001380443572998
SELECT value FROM productattributes WHERE product_id = '7833' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
108 0.0001 8.7976455688477E-5
SELECT id,asin FROM products WHERE parent_id = 7826
109 0.0001 7.9870223999023E-5
SELECT category_id FROM products_categories WHERE product_id = '7826'
110 0.0004 0.00037097930908203
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '7826' AND a.name = n.originalname
111 0.0001 0.0001070499420166
SELECT * FROM productoffers WHERE product_id = '7826' AND merchantid = 'ATVPDKIKX0DER'
112 0.0001 0.0001380443572998
SELECT * FROM productoffers
                WHERE product_id = '7826' AND price > 0
                ORDER BY price ASC LIMIT 1
113 0.0001 0.00013208389282227
SELECT * FROM products WHERE id = '7826'
114 0.0001 0.00013279914855957
SELECT value FROM productattributes WHERE product_id = '7826' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
115 0.0004 0.00035810470581055
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '7826' AND a.name = n.originalname
116 0.0001 0.00011205673217773
SELECT * FROM productoffers WHERE product_id = '7826' AND merchantid = 'ATVPDKIKX0DER'
117 0.0001 0.00011992454528809
SELECT * FROM productoffers
                WHERE product_id = '7826' AND price > 0
                ORDER BY price ASC LIMIT 1
118 0.0001 0.00010204315185547
SELECT category_id FROM products_categories WHERE product_id = '7826' AND prod_type = 'amz'
119 0.0002 0.00016593933105469
SELECT * FROM template_info WHERE templateuid = 'fsb-fluid'
120 0.0001 0.00012898445129395
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_user_data'
121 0.0001 8.1062316894531E-5
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_tracking_status'
122 0.0001 0.00011897087097168
SELECT * FROM pages WHERE id = 38
123 0.0001 9.9897384643555E-5
SELECT * FROM categories WHERE id = '27'
124 0.0002 0.00019216537475586
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
125 0.0001 7.2002410888672E-5
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
126 0.0001 7.8916549682617E-5
SELECT id FROM categories WHERE parent_id = '27'
127 0.0002 0.00020790100097656
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 
128 0.0001 8.7976455688477E-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 
129 0.0001 0.00011801719665527
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
130 0.0001 7.2956085205078E-5
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
131 0.0002 0.00017094612121582
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
132 0.0001 7.0095062255859E-5
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
133 0.0002 0.00018811225891113
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 
134 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 
135 0.0001 0.00010991096496582
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
136 0.0001 6.9141387939453E-5
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
137 0.0001 8.1062316894531E-5
SELECT id FROM categories WHERE parent_id = '27'
138 0.0002 0.00022101402282715
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
139 0.0001 0.00012612342834473
SELECT * FROM productimages WHERE product_id = '819' ORDER BY sortorder ASC
140 0.0001 0.0001220703125
SELECT * FROM categoryimages WHERE category_id = 27
141 0.0001 8.702278137207E-5
SELECT * FROM categorygroups WHERE id = '1'
142 0.0002 0.00023794174194336
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
143 0.0001 9.2029571533203E-5
SELECT * FROM categories WHERE id = '30'
144 0.0003 0.00028204917907715
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
145 0.0001 6.8187713623047E-5
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
146 0.0001 8.1062316894531E-5
SELECT id FROM categories WHERE parent_id = '30'
147 0.0003 0.00027799606323242
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 
148 0.0001 8.7976455688477E-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 
149 0.0001 9.5129013061523E-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
150 0.0001 6.8187713623047E-5
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
151 0.0003 0.0002739429473877
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
152 0.0001 6.8187713623047E-5
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
153 0.0003 0.00030922889709473
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 
154 0.0001 9.1075897216797E-5
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (30)
				  AND p.disabled = 0 
155 0.0001 9.5129013061523E-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
156 0.0001 8.392333984375E-5
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
157 0.0001 9.608268737793E-5
SELECT id FROM categories WHERE parent_id = '30'
158 0.0003 0.00030612945556641
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
159 0.0001 0.00012612342834473
SELECT * FROM productimages WHERE product_id = '831' ORDER BY sortorder ASC
160 0.0001 8.2015991210938E-5
SELECT * FROM categoryimages WHERE category_id = 30
161 0.0001 7.9154968261719E-5
SELECT * FROM categorygroups WHERE id = '1'
162 0.0003 0.00029802322387695
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
163 0.0001 9.2983245849609E-5
SELECT * FROM pages WHERE id = 59
164 0.0001 9.8943710327148E-5
SELECT * FROM pages WHERE id = 55
165 0.0002 0.0001521110534668
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
166 0.0001 0.0001220703125
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:1638251355;s:8:\"products\";a:0:{}}' WHERE id = '8'
167 0.0002 0.00022482872009277
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
168 0.0001 0.00010085105895996
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:1638251355;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'
169 0.0001 0.00013899803161621
SELECT * FROM products WHERE id = 7004
170 0.0001 0.00011301040649414
SELECT * FROM products WHERE id = 7011
171 0.0001 0.00011396408081055
SELECT * FROM products WHERE id = 7045
172 0.0001 0.00011610984802246
SELECT * FROM products WHERE id = '7004'
173 0.0001 0.00013017654418945
SELECT * FROM productimages WHERE product_id = '7004' ORDER BY sortorder ASC
174 0.0001 0.00014400482177734
SELECT * FROM product_image_select WHERE product_id = '7004'
175 0.0001 0.00010085105895996
SELECT * FROM productcustomimages WHERE product_id = '7004'
176 0.0005 0.00049090385437012
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '7004' AND a.name = n.originalname
177 0.0001 0.00010895729064941
SELECT * FROM productoffers WHERE product_id = '7004' AND merchantid = 'ATVPDKIKX0DER'
178 0.0001 0.00011992454528809
SELECT * FROM productoffers
                WHERE product_id = '7004' AND price > 0
                ORDER BY price ASC LIMIT 1
179 0.0002 0.00021100044250488
SELECT value FROM productattributes WHERE product_id = '7004' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
180 0.0001 0.00013589859008789
SELECT * FROM products WHERE id = '7011'
181 0.0001 0.00010895729064941
SELECT * FROM productimages WHERE product_id = '7011' ORDER BY sortorder ASC
182 0.0001 0.00013422966003418
SELECT * FROM product_image_select WHERE product_id = '7011'
183 0.0001 0.00012922286987305
SELECT * FROM productcustomimages WHERE product_id = '7011'
184 0.0005 0.00052881240844727
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '7011' AND a.name = n.originalname
185 0.0001 9.8943710327148E-5
SELECT * FROM productoffers WHERE product_id = '7011' AND merchantid = 'ATVPDKIKX0DER'
186 0.0001 0.00011301040649414
SELECT * FROM productoffers
                WHERE product_id = '7011' AND price > 0
                ORDER BY price ASC LIMIT 1
187 0.0001 0.00010895729064941
SELECT * FROM productoffers
                WHERE product_id = 7011
                ORDER BY price ASC LIMIT 1
188 0.0001 0.00011897087097168
SELECT value FROM productattributes
                WHERE product_id = '7011'
                AND name = 'ListPriceAmount'
189 0.0001 0.0001220703125
SELECT * FROM products WHERE id = '7045'
190 0.0001 0.00010180473327637
SELECT * FROM productimages WHERE product_id = '7045' ORDER BY sortorder ASC
191 0.0002 0.00015401840209961
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
192 0.0001 0.0001370906829834
SELECT * FROM product_image_select WHERE product_id = '7045'
193 0.0001 0.00010395050048828
SELECT * FROM productcustomimages WHERE product_id = '7045'
194 0.0001 0.00014114379882812
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
195 0.0002 0.00024795532226562
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
196 0.0001 0.00012111663818359
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
197 0.0005 0.00054097175598145
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '7045' AND a.name = n.originalname
198 0.0001 0.00010395050048828
SELECT * FROM productoffers WHERE product_id = '7045' AND merchantid = 'ATVPDKIKX0DER'
199 0.0001 0.00011396408081055
SELECT * FROM productoffers
                WHERE product_id = '7045' AND price > 0
                ORDER BY price ASC LIMIT 1
200 0.0001 0.00011706352233887
SELECT * FROM productoffers
                WHERE product_id = 7045
                ORDER BY price ASC LIMIT 1
201 0.0001 0.0001218318939209
SELECT value FROM productattributes
                WHERE product_id = '7045'
                AND name = 'ListPriceAmount'
202 0.0002 0.0001530647277832
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
203 0.0002 0.00017309188842773
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
204 0.0001 0.00011706352233887
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 7045
205 0.0001 0.00013995170593262
SELECT value FROM productattributes WHERE product_id = '7045' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
206 0.0002 0.00015997886657715
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
207 0.0002 0.00015091896057129
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
208 0.0003 0.00025296211242676
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid' AND area = 'header' ORDER BY sortorder ASC
209 0.0002 0.00017285346984863
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid' AND area = 'footer' ORDER BY sortorder ASC
210 0.0004 0.00039887428283691
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-fluid' AND skinuid = ''
211 0.0002 0.00023007392883301
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid'
212 0.0001 0.00014495849609375
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid'
213 0.0002 0.0001978874206543
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid' AND imageuid = 'HEAD_LOGO'
214 0.0001 0.0001368522644043
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid' AND imageuid = 'HEAD_LOGO'