Number |
Time (Seconds) |
Time (Milliseconds) |
Query |
1 |
0.0004 |
0.00043511390686035 |
SELECT parameter, value FROM parameters |
2 |
0.0014 |
0.00142502784729 |
SELECT * FROM `bad_bots` |
3 |
0.0004 |
0.00038814544677734 |
SET time_zone = 'Europe/London' |
4 |
0.0003 |
0.00028896331787109 |
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1 |
5 |
0.0006 |
0.00063204765319824 |
INSERT INTO ga_users (`isbot`, `ips`) SELECT '1', 'a:1:{i:0;s:13:\"3.236.147.122\";}' |
6 |
0.0005 |
0.00050806999206543 |
INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1711694744' |
7 |
0.0008 |
0.00082802772521973 |
SELECT * FROM autorun ORDER BY lastrun ASC |
8 |
0.0004 |
0.00035405158996582 |
SELECT * FROM version ORDER BY installed DESC LIMIT 1 |
9 |
0.0010 |
0.00099301338195801 |
SELECT id FROM pages WHERE pagename = 'rss' LIMIT 1 |
10 |
0.0015 |
0.0015439987182617 |
SELECT * FROM pages WHERE id = 53 |
11 |
0.0008 |
0.00077605247497559 |
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' |
12 |
0.0007 |
0.0007021427154541 |
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND language = 'en' |
13 |
0.0007 |
0.00068116188049316 |
SELECT * FROM pages WHERE pagename = 'rss' |
14 |
0.0003 |
0.00026416778564453 |
SELECT * FROM categorygroups ORDER BY sortorder ASC |
15 |
0.0005 |
0.00051999092102051 |
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1' AND hidden = 0 ORDER BY sortorder ASC |
16 |
0.0003 |
0.00029301643371582 |
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.0003 |
0.00029802322387695 |
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.0003 |
0.00030708312988281 |
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26 |
19 |
0.0003 |
0.00030612945556641 |
SELECT id FROM categories WHERE parent_id = '26' |
20 |
0.0003 |
0.00030303001403809 |
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.0003 |
0.00031399726867676 |
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.0007 |
0.00069379806518555 |
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.0003 |
0.00032210350036621 |
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26' |
24 |
0.0003 |
0.00032615661621094 |
SELECT * FROM categorygroups WHERE id = '1' |
25 |
0.0003 |
0.00030112266540527 |
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.0003 |
0.00029802322387695 |
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.0003 |
0.00031185150146484 |
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27 |
28 |
0.0003 |
0.00030398368835449 |
SELECT id FROM categories WHERE parent_id = '27' |
29 |
0.0003 |
0.00031900405883789 |
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.0003 |
0.00034213066101074 |
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.0004 |
0.00037097930908203 |
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.0003 |
0.00030398368835449 |
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27' |
33 |
0.0003 |
0.00030612945556641 |
SELECT * FROM categorygroups WHERE id = '1' |
34 |
0.0004 |
0.00037407875061035 |
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.0003 |
0.00030279159545898 |
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.0003 |
0.00032305717468262 |
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28 |
37 |
0.0003 |
0.00029802322387695 |
SELECT id FROM categories WHERE parent_id = '28' |
38 |
0.0003 |
0.00029587745666504 |
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.0003 |
0.00030684471130371 |
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.0003 |
0.00028014183044434 |
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.0003 |
0.00034689903259277 |
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28' |
42 |
0.0003 |
0.00029611587524414 |
SELECT * FROM categorygroups WHERE id = '1' |
43 |
0.0003 |
0.00030708312988281 |
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.0003 |
0.00030112266540527 |
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.0003 |
0.00034713745117188 |
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29 |
46 |
0.0003 |
0.00031518936157227 |
SELECT id FROM categories WHERE parent_id = '29' |
47 |
0.0003 |
0.00033998489379883 |
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.0003 |
0.00032591819763184 |
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.0004 |
0.00036406517028809 |
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.0004 |
0.00038290023803711 |
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29' |
51 |
0.0004 |
0.00037598609924316 |
SELECT * FROM categorygroups WHERE id = '1' |
52 |
0.0003 |
0.0003058910369873 |
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.0003 |
0.00030899047851562 |
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.0003 |
0.00029492378234863 |
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30 |
55 |
0.0004 |
0.00039005279541016 |
SELECT id FROM categories WHERE parent_id = '30' |
56 |
0.0003 |
0.00031399726867676 |
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.0004 |
0.00037503242492676 |
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.0004 |
0.00042915344238281 |
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.0003 |
0.00032496452331543 |
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30' |
60 |
0.0003 |
0.00031495094299316 |
SELECT * FROM categorygroups WHERE id = '1' |
61 |
0.0003 |
0.00030803680419922 |
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.0004 |
0.00036096572875977 |
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.0003 |
0.0003058910369873 |
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31 |
64 |
0.0003 |
0.00030684471130371 |
SELECT id FROM categories WHERE parent_id = '31' |
65 |
0.0004 |
0.00037002563476562 |
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.0003 |
0.00032615661621094 |
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.0003 |
0.00029802322387695 |
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.0003 |
0.00034093856811523 |
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31' |
69 |
0.0003 |
0.00031185150146484 |
SELECT * FROM categorygroups WHERE id = '1' |
70 |
0.0004 |
0.00040602684020996 |
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '2' AND hidden = 0 ORDER BY sortorder ASC |
71 |
0.0003 |
0.00031614303588867 |
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC |
72 |
0.0004 |
0.0003509521484375 |
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-fluid2018' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC |
73 |
0.0005 |
0.00048708915710449 |
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.0003 |
0.00034499168395996 |
SELECT * FROM sideboxes_pages WHERE sidebox_id = '26' |
75 |
0.0004 |
0.00036287307739258 |
SELECT value FROM template_options WHERE templateuid = 'fsb-fluid2018' AND optionuid = 'DISPLAY_CREDIT_ICON' |
76 |
0.0008 |
0.00076103210449219 |
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey |
77 |
0.0721 |
0.072136878967285 |
SELECT * FROM ipgeocountries WHERE INET_ATON('3.236.147.122') >= INET_ATON(ip_start) AND INET_ATON('3.236.147.122') <= INET_ATON(ip_end) |
78 |
0.0005 |
0.00053215026855469 |
SELECT * FROM ipgeolocations WHERE geoname_id = '6252001' |
79 |
0.0003 |
0.00029683113098145 |
SELECT * FROM countryredirects WHERE countrycode = 'US' |
80 |
0.0011 |
0.001115083694458 |
SELECT * FROM categories WHERE parent_id = '0' AND hidden = 0 ORDER BY sortorder ASC |
81 |
0.0003 |
0.00029492378234863 |
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 |
82 |
0.0003 |
0.0002751350402832 |
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 26 |
83 |
0.0003 |
0.00026392936706543 |
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26 |
84 |
0.0003 |
0.00028109550476074 |
SELECT id FROM categories WHERE parent_id = '26' |
85 |
0.0003 |
0.0002751350402832 |
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 |
86 |
0.0003 |
0.00029897689819336 |
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 |
87 |
0.0003 |
0.00030398368835449 |
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 |
88 |
0.0003 |
0.00031590461730957 |
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26' |
89 |
0.0003 |
0.0003049373626709 |
SELECT * FROM categorygroups WHERE id = '1' |
90 |
0.0004 |
0.00037598609924316 |
SELECT * FROM categories WHERE parent_id = '26' AND hidden = 0 ORDER BY sortorder ASC |
91 |
0.0003 |
0.00026679039001465 |
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 |
92 |
0.0003 |
0.00028896331787109 |
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 27 |
93 |
0.0003 |
0.00027704238891602 |
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27 |
94 |
0.0003 |
0.00034713745117188 |
SELECT id FROM categories WHERE parent_id = '27' |
95 |
0.0003 |
0.00028491020202637 |
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 |
96 |
0.0003 |
0.00027704238891602 |
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 |
97 |
0.0003 |
0.00027704238891602 |
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 |
98 |
0.0003 |
0.0002739429473877 |
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27' |
99 |
0.0003 |
0.0003199577331543 |
SELECT * FROM categorygroups WHERE id = '1' |
100 |
0.0007 |
0.00072789192199707 |
SELECT * FROM categories WHERE parent_id = '27' AND hidden = 0 ORDER BY sortorder ASC |
101 |
0.0003 |
0.00029993057250977 |
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 |
102 |
0.0003 |
0.00032186508178711 |
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 28 |
103 |
0.0003 |
0.00032186508178711 |
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28 |
104 |
0.0003 |
0.00034689903259277 |
SELECT id FROM categories WHERE parent_id = '28' |
105 |
0.0004 |
0.00039196014404297 |
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 |
106 |
0.0003 |
0.00034117698669434 |
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 |
107 |
0.0003 |
0.00030398368835449 |
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 |
108 |
0.0003 |
0.0002899169921875 |
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28' |
109 |
0.0003 |
0.00031590461730957 |
SELECT * FROM categorygroups WHERE id = '1' |
110 |
0.0007 |
0.0007331371307373 |
SELECT * FROM categories WHERE parent_id = '28' AND hidden = 0 ORDER BY sortorder ASC |
111 |
0.0003 |
0.00031685829162598 |
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 |
112 |
0.0003 |
0.00030899047851562 |
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 29 |
113 |
0.0003 |
0.00029683113098145 |
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29 |
114 |
0.0003 |
0.00030803680419922 |
SELECT id FROM categories WHERE parent_id = '29' |
115 |
0.0003 |
0.00028896331787109 |
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 |
116 |
0.0004 |
0.00035595893859863 |
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 |
117 |
0.0003 |
0.00033283233642578 |
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 |
118 |
0.0004 |
0.00037002563476562 |
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29' |
119 |
0.0003 |
0.00032281875610352 |
SELECT * FROM categorygroups WHERE id = '1' |
120 |
0.0008 |
0.00076889991760254 |
SELECT * FROM categories WHERE parent_id = '29' AND hidden = 0 ORDER BY sortorder ASC |
121 |
0.0003 |
0.00034308433532715 |
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 |
122 |
0.0003 |
0.00032281875610352 |
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 30 |
123 |
0.0003 |
0.00030899047851562 |
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30 |
124 |
0.0003 |
0.00033998489379883 |
SELECT id FROM categories WHERE parent_id = '30' |
125 |
0.0003 |
0.00032806396484375 |
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 |
126 |
0.0003 |
0.00031089782714844 |
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 |
127 |
0.0003 |
0.00030207633972168 |
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 |
128 |
0.0003 |
0.00033402442932129 |
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30' |
129 |
0.0003 |
0.00033187866210938 |
SELECT * FROM categorygroups WHERE id = '1' |
130 |
0.0008 |
0.00078010559082031 |
SELECT * FROM categories WHERE parent_id = '30' AND hidden = 0 ORDER BY sortorder ASC |
131 |
0.0003 |
0.0003049373626709 |
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 |
132 |
0.0003 |
0.00032997131347656 |
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 31 |
133 |
0.0003 |
0.00031805038452148 |
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31 |
134 |
0.0003 |
0.00034904479980469 |
SELECT id FROM categories WHERE parent_id = '31' |
135 |
0.0003 |
0.00032591819763184 |
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 |
136 |
0.0004 |
0.00037884712219238 |
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 |
137 |
0.0006 |
0.00063705444335938 |
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 |
138 |
0.0004 |
0.00038814544677734 |
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31' |
139 |
0.0004 |
0.0003662109375 |
SELECT * FROM categorygroups WHERE id = '1' |
140 |
0.0008 |
0.00084996223449707 |
SELECT * FROM categories WHERE parent_id = '31' AND hidden = 0 ORDER BY sortorder ASC |
141 |
0.0144 |
0.014448165893555 |
SELECT * FROM categories WHERE pagename = 'thes-verts' |
142 |
0.0130 |
0.013010025024414 |
SELECT p.* FROM products p, products_categories c WHERE p.id = c.product_id AND p.parent_id = 0 AND c.category_id = 28 AND hidden = 0 AND enabled = 1 AND (offers > 0 OR parent = 1) |
143 |
0.0003 |
0.00034499168395996 |
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '853' AND a.name = n.originalname |
144 |
0.0004 |
0.00037598609924316 |
SELECT * FROM productoffers WHERE product_id = '853' AND merchantid = 'A1X6FK5RDHNB96' |
145 |
0.0003 |
0.00029993057250977 |
SELECT * FROM productoffers
WHERE product_id = '853' AND price > 0
ORDER BY price ASC LIMIT 1 |
146 |
0.0004 |
0.00035500526428223 |
SELECT COUNT(*) FROM products WHERE parent_id = '853' |
147 |
0.0007 |
0.00073122978210449 |
SELECT * FROM manufacturers WHERE id = '220' |
148 |
0.0005 |
0.00054502487182617 |
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '220' |
149 |
0.0006 |
0.00063109397888184 |
SELECT COUNT(*) FROM productreviews WHERE product_id = '853' |
150 |
0.0009 |
0.00086593627929688 |
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '853' AND a.name = n.originalname |
151 |
0.0003 |
0.00027990341186523 |
SELECT * FROM productoffers WHERE product_id = '853' AND merchantid = 'A1X6FK5RDHNB96' |
152 |
0.0003 |
0.0002748966217041 |
SELECT * FROM productoffers
WHERE product_id = '853' AND price > 0
ORDER BY price ASC LIMIT 1 |
153 |
0.0003 |
0.00031805038452148 |
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '857' AND a.name = n.originalname |
154 |
0.0003 |
0.00031614303588867 |
SELECT * FROM productoffers WHERE product_id = '857' AND merchantid = 'A1X6FK5RDHNB96' |
155 |
0.0003 |
0.00029897689819336 |
SELECT * FROM productoffers
WHERE product_id = '857' AND price > 0
ORDER BY price ASC LIMIT 1 |
156 |
0.0004 |
0.00040197372436523 |
SELECT COUNT(*) FROM products WHERE parent_id = '857' |
157 |
0.0003 |
0.00030207633972168 |
SELECT * FROM manufacturers WHERE id = '220' |
158 |
0.0004 |
0.00037384033203125 |
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '220' |
159 |
0.0004 |
0.00037097930908203 |
SELECT COUNT(*) FROM productreviews WHERE product_id = '857' |
160 |
0.0007 |
0.00069904327392578 |
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '857' AND a.name = n.originalname |
161 |
0.0003 |
0.00031304359436035 |
SELECT * FROM productoffers WHERE product_id = '857' AND merchantid = 'A1X6FK5RDHNB96' |
162 |
0.0003 |
0.00029706954956055 |
SELECT * FROM productoffers
WHERE product_id = '857' AND price > 0
ORDER BY price ASC LIMIT 1 |
163 |
0.0004 |
0.00040793418884277 |
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '866' AND a.name = n.originalname |
164 |
0.0005 |
0.00048112869262695 |
SELECT * FROM productoffers WHERE product_id = '866' AND merchantid = 'A1X6FK5RDHNB96' |
165 |
0.0004 |
0.0003821849822998 |
SELECT * FROM productoffers
WHERE product_id = '866' AND price > 0
ORDER BY price ASC LIMIT 1 |
166 |
0.0006 |
0.00061607360839844 |
SELECT COUNT(*) FROM products WHERE parent_id = '866' |
167 |
0.0004 |
0.00041484832763672 |
SELECT * FROM manufacturers WHERE id = '226' |
168 |
0.0005 |
0.00050592422485352 |
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '226' |
169 |
0.0003 |
0.00032401084899902 |
SELECT COUNT(*) FROM productreviews WHERE product_id = '866' |
170 |
0.0003 |
0.0002598762512207 |
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '866' AND a.name = n.originalname |
171 |
0.0003 |
0.00025796890258789 |
SELECT * FROM productoffers WHERE product_id = '866' AND merchantid = 'A1X6FK5RDHNB96' |
172 |
0.0003 |
0.00025200843811035 |
SELECT * FROM productoffers
WHERE product_id = '866' AND price > 0
ORDER BY price ASC LIMIT 1 |
173 |
0.0003 |
0.0003349781036377 |
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '868' AND a.name = n.originalname |
174 |
0.0002 |
0.00023484230041504 |
SELECT * FROM productoffers WHERE product_id = '868' AND merchantid = 'A1X6FK5RDHNB96' |
175 |
0.0003 |
0.00027298927307129 |
SELECT * FROM productoffers
WHERE product_id = '868' AND price > 0
ORDER BY price ASC LIMIT 1 |
176 |
0.0003 |
0.00029778480529785 |
SELECT COUNT(*) FROM products WHERE parent_id = '868' |
177 |
0.0004 |
0.00041699409484863 |
SELECT * FROM manufacturers WHERE id = '228' |
178 |
0.0004 |
0.00037598609924316 |
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '228' |
179 |
0.0003 |
0.00029110908508301 |
SELECT COUNT(*) FROM productreviews WHERE product_id = '868' |
180 |
0.0003 |
0.0003349781036377 |
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '868' AND a.name = n.originalname |
181 |
0.0002 |
0.00024604797363281 |
SELECT * FROM productoffers WHERE product_id = '868' AND merchantid = 'A1X6FK5RDHNB96' |
182 |
0.0003 |
0.00027799606323242 |
SELECT * FROM productoffers
WHERE product_id = '868' AND price > 0
ORDER BY price ASC LIMIT 1 |
183 |
0.0002 |
0.0002439022064209 |
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '931' AND a.name = n.originalname |
184 |
0.0003 |
0.00025415420532227 |
SELECT * FROM productoffers WHERE product_id = '931' AND merchantid = 'A1X6FK5RDHNB96' |
185 |
0.0004 |
0.00042200088500977 |
SELECT * FROM productoffers
WHERE product_id = '931' AND price > 0
ORDER BY price ASC LIMIT 1 |
186 |
0.0003 |
0.00032687187194824 |
SELECT COUNT(*) FROM products WHERE parent_id = '931' |
187 |
0.0003 |
0.00034713745117188 |
SELECT * FROM manufacturers WHERE id = '250' |
188 |
0.0004 |
0.0003669261932373 |
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '250' |
189 |
0.0003 |
0.00030303001403809 |
SELECT COUNT(*) FROM productreviews WHERE product_id = '931' |
190 |
0.0003 |
0.00032806396484375 |
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '931' AND a.name = n.originalname |
191 |
0.0003 |
0.00026488304138184 |
SELECT * FROM productoffers WHERE product_id = '931' AND merchantid = 'A1X6FK5RDHNB96' |
192 |
0.0004 |
0.00041484832763672 |
SELECT * FROM productoffers
WHERE product_id = '931' AND price > 0
ORDER BY price ASC LIMIT 1 |
193 |
0.0005 |
0.00049591064453125 |
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 = '932'
GROUP BY o.product_id |
194 |
0.0008 |
0.00075221061706543 |
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 = '932'
GROUP BY n.displayname
ORDER BY n.displayname DESC |
195 |
0.0004 |
0.0003969669342041 |
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 932 |
196 |
0.0003 |
0.00033807754516602 |
SELECT COUNT(*) FROM products WHERE parent_id = '932' |
197 |
0.0005 |
0.00048494338989258 |
SELECT * FROM manufacturers WHERE id = '251' |
198 |
0.0005 |
0.00052499771118164 |
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '251' |
199 |
0.0004 |
0.00040388107299805 |
SELECT COUNT(*) FROM productreviews WHERE product_id = '932' |
200 |
0.0007 |
0.00070691108703613 |
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '932' AND a.name = n.originalname |
201 |
0.0006 |
0.00062894821166992 |
SELECT * FROM productoffers WHERE product_id = '932' AND merchantid = 'A1X6FK5RDHNB96' |
202 |
0.0005 |
0.00049805641174316 |
SELECT * FROM productoffers
WHERE product_id = '932' AND price > 0
ORDER BY price ASC LIMIT 1 |
203 |
0.0004 |
0.00043916702270508 |
SELECT * FROM productoffers
WHERE product_id = 932
ORDER BY price ASC LIMIT 1 |
204 |
0.0005 |
0.00046205520629883 |
SELECT value FROM productattributes
WHERE product_id = '932'
AND name = 'ListPriceAmount' |
205 |
0.0003 |
0.00030303001403809 |
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '970' AND a.name = n.originalname |
206 |
0.0003 |
0.00027894973754883 |
SELECT * FROM productoffers WHERE product_id = '970' AND merchantid = 'A1X6FK5RDHNB96' |
207 |
0.0003 |
0.00031089782714844 |
SELECT * FROM productoffers
WHERE product_id = '970' AND price > 0
ORDER BY price ASC LIMIT 1 |
208 |
0.0005 |
0.00049901008605957 |
SELECT COUNT(*) FROM products WHERE parent_id = '970' |
209 |
0.0006 |
0.00055885314941406 |
SELECT * FROM manufacturers WHERE id = '255' |
210 |
0.0005 |
0.00052189826965332 |
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '255' |
211 |
0.0004 |
0.00042200088500977 |
SELECT COUNT(*) FROM productreviews WHERE product_id = '970' |
212 |
0.0003 |
0.00027799606323242 |
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '970' AND a.name = n.originalname |
213 |
0.0003 |
0.00027894973754883 |
SELECT * FROM productoffers WHERE product_id = '970' AND merchantid = 'A1X6FK5RDHNB96' |
214 |
0.0003 |
0.00028514862060547 |
SELECT * FROM productoffers
WHERE product_id = '970' AND price > 0
ORDER BY price ASC LIMIT 1 |
215 |
0.0003 |
0.00032281875610352 |
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1056' AND a.name = n.originalname |
216 |
0.0003 |
0.00026297569274902 |
SELECT * FROM productoffers WHERE product_id = '1056' AND merchantid = 'A1X6FK5RDHNB96' |
217 |
0.0003 |
0.00027680397033691 |
SELECT * FROM productoffers
WHERE product_id = '1056' AND price > 0
ORDER BY price ASC LIMIT 1 |
218 |
0.0003 |
0.00033807754516602 |
SELECT COUNT(*) FROM products WHERE parent_id = '1056' |
219 |
0.0003 |
0.00030922889709473 |
SELECT * FROM manufacturers WHERE id = '251' |
220 |
0.0002 |
0.00023198127746582 |
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '251' |
221 |
0.0003 |
0.0003211498260498 |
SELECT COUNT(*) FROM productreviews WHERE product_id = '1056' |
222 |
0.0003 |
0.00031590461730957 |
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1056' AND a.name = n.originalname |
223 |
0.0003 |
0.00029587745666504 |
SELECT * FROM productoffers WHERE product_id = '1056' AND merchantid = 'A1X6FK5RDHNB96' |
224 |
0.0003 |
0.0002899169921875 |
SELECT * FROM productoffers
WHERE product_id = '1056' AND price > 0
ORDER BY price ASC LIMIT 1 |
225 |
0.0003 |
0.00031781196594238 |
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1089' AND a.name = n.originalname |
226 |
0.0003 |
0.00032186508178711 |
SELECT * FROM productoffers WHERE product_id = '1089' AND merchantid = 'A1X6FK5RDHNB96' |
227 |
0.0003 |
0.00031900405883789 |
SELECT * FROM productoffers
WHERE product_id = '1089' AND price > 0
ORDER BY price ASC LIMIT 1 |
228 |
0.0004 |
0.00036191940307617 |
SELECT COUNT(*) FROM products WHERE parent_id = '1089' |
229 |
0.0004 |
0.00040102005004883 |
SELECT * FROM manufacturers WHERE id = '272' |
230 |
0.0008 |
0.0008389949798584 |
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '272' |
231 |
0.0003 |
0.0003049373626709 |
SELECT COUNT(*) FROM productreviews WHERE product_id = '1089' |
232 |
0.0003 |
0.00027203559875488 |
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1089' AND a.name = n.originalname |
233 |
0.0003 |
0.00026917457580566 |
SELECT * FROM productoffers WHERE product_id = '1089' AND merchantid = 'A1X6FK5RDHNB96' |
234 |
0.0003 |
0.00026202201843262 |
SELECT * FROM productoffers
WHERE product_id = '1089' AND price > 0
ORDER BY price ASC LIMIT 1 |
235 |
0.0003 |
0.00030994415283203 |
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1110' AND a.name = n.originalname |
236 |
0.0003 |
0.00026893615722656 |
SELECT * FROM productoffers WHERE product_id = '1110' AND merchantid = 'A1X6FK5RDHNB96' |
237 |
0.0003 |
0.00027608871459961 |
SELECT * FROM productoffers
WHERE product_id = '1110' AND price > 0
ORDER BY price ASC LIMIT 1 |
238 |
0.0003 |
0.0003349781036377 |
SELECT COUNT(*) FROM products WHERE parent_id = '1110' |
239 |
0.0003 |
0.00030183792114258 |
SELECT * FROM manufacturers WHERE id = '255' |
240 |
0.0002 |
0.00023007392883301 |
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '255' |
241 |
0.0004 |
0.00035214424133301 |
SELECT COUNT(*) FROM productreviews WHERE product_id = '1110' |
242 |
0.0003 |
0.00028514862060547 |
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1110' AND a.name = n.originalname |
243 |
0.0003 |
0.00026202201843262 |
SELECT * FROM productoffers WHERE product_id = '1110' AND merchantid = 'A1X6FK5RDHNB96' |
244 |
0.0003 |
0.00027894973754883 |
SELECT * FROM productoffers
WHERE product_id = '1110' AND price > 0
ORDER BY price ASC LIMIT 1 |
245 |
0.0003 |
0.0003201961517334 |
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1145' AND a.name = n.originalname |
246 |
0.0003 |
0.00031113624572754 |
SELECT * FROM productoffers WHERE product_id = '1145' AND merchantid = 'A1X6FK5RDHNB96' |
247 |
0.0003 |
0.00028610229492188 |
SELECT * FROM productoffers
WHERE product_id = '1145' AND price > 0
ORDER BY price ASC LIMIT 1 |
248 |
0.0004 |
0.00040388107299805 |
SELECT COUNT(*) FROM products WHERE parent_id = '1145' |
249 |
0.0005 |
0.00046610832214355 |
SELECT * FROM manufacturers WHERE id = '279' |
250 |
0.0005 |
0.00047183036804199 |
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '279' |
251 |
0.0007 |
0.00068807601928711 |
SELECT COUNT(*) FROM productreviews WHERE product_id = '1145' |
252 |
0.0003 |
0.00027084350585938 |
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1145' AND a.name = n.originalname |
253 |
0.0003 |
0.00031399726867676 |
SELECT * FROM productoffers WHERE product_id = '1145' AND merchantid = 'A1X6FK5RDHNB96' |
254 |
0.0003 |
0.00029397010803223 |
SELECT * FROM productoffers
WHERE product_id = '1145' AND price > 0
ORDER BY price ASC LIMIT 1 |
255 |
0.0015 |
0.0014908313751221 |
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1160' AND a.name = n.originalname |
256 |
0.0005 |
0.00053000450134277 |
SELECT * FROM productoffers WHERE product_id = '1160' AND merchantid = 'A1X6FK5RDHNB96' |
257 |
0.0005 |
0.00053286552429199 |
SELECT * FROM productoffers
WHERE product_id = '1160' AND price > 0
ORDER BY price ASC LIMIT 1 |
258 |
0.0007 |
0.0006868839263916 |
SELECT COUNT(*) FROM products WHERE parent_id = '1160' |
259 |
0.0003 |
0.00030207633972168 |
SELECT * FROM manufacturers WHERE id = '255' |
260 |
0.0002 |
0.00024199485778809 |
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '255' |
261 |
0.0005 |
0.00052905082702637 |
SELECT COUNT(*) FROM productreviews WHERE product_id = '1160' |
262 |
0.0003 |
0.00028300285339355 |
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1160' AND a.name = n.originalname |
263 |
0.0003 |
0.0002748966217041 |
SELECT * FROM productoffers WHERE product_id = '1160' AND merchantid = 'A1X6FK5RDHNB96' |
264 |
0.0003 |
0.00029706954956055 |
SELECT * FROM productoffers
WHERE product_id = '1160' AND price > 0
ORDER BY price ASC LIMIT 1 |
265 |
0.0013 |
0.0013220310211182 |
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 = '1167'
GROUP BY o.product_id |
266 |
0.0033 |
0.00331711769104 |
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 = '1167'
GROUP BY n.displayname
ORDER BY n.displayname DESC |
267 |
0.0012 |
0.0012099742889404 |
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 1167 |
268 |
0.0005 |
0.00046896934509277 |
SELECT COUNT(*) FROM products WHERE parent_id = '1167' |
269 |
0.0005 |
0.00053715705871582 |
SELECT * FROM manufacturers WHERE id = '0' |
270 |
0.0007 |
0.00072693824768066 |
SELECT COUNT(*) FROM productreviews WHERE product_id = '1167' |
271 |
0.0019 |
0.0018548965454102 |
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1167' AND a.name = n.originalname |
272 |
0.0007 |
0.00070405006408691 |
SELECT * FROM productoffers WHERE product_id = '1167' AND merchantid = 'A1X6FK5RDHNB96' |
273 |
0.0005 |
0.00053000450134277 |
SELECT * FROM productoffers
WHERE product_id = '1167' AND price > 0
ORDER BY price ASC LIMIT 1 |
274 |
0.0010 |
0.0010340213775635 |
SELECT * FROM productoffers
WHERE product_id = 1167
ORDER BY price ASC LIMIT 1 |
275 |
0.0005 |
0.00050806999206543 |
SELECT value FROM productattributes
WHERE product_id = '1167'
AND name = 'ListPriceAmount' |
276 |
0.0003 |
0.00031089782714844 |
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1201' AND a.name = n.originalname |
277 |
0.0003 |
0.00027799606323242 |
SELECT * FROM productoffers WHERE product_id = '1201' AND merchantid = 'A1X6FK5RDHNB96' |
278 |
0.0003 |
0.00029110908508301 |
SELECT * FROM productoffers
WHERE product_id = '1201' AND price > 0
ORDER BY price ASC LIMIT 1 |
279 |
0.0006 |
0.00058794021606445 |
SELECT COUNT(*) FROM products WHERE parent_id = '1201' |
280 |
0.0003 |
0.00028800964355469 |
SELECT * FROM manufacturers WHERE id = '251' |
281 |
0.0002 |
0.00023198127746582 |
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '251' |
282 |
0.0004 |
0.0003960132598877 |
SELECT COUNT(*) FROM productreviews WHERE product_id = '1201' |
283 |
0.0003 |
0.00028491020202637 |
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1201' AND a.name = n.originalname |
284 |
0.0002 |
0.00024890899658203 |
SELECT * FROM productoffers WHERE product_id = '1201' AND merchantid = 'A1X6FK5RDHNB96' |
285 |
0.0003 |
0.00030112266540527 |
SELECT * FROM productoffers
WHERE product_id = '1201' AND price > 0
ORDER BY price ASC LIMIT 1 |
286 |
0.0002 |
0.0002439022064209 |
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1217' AND a.name = n.originalname |
287 |
0.0003 |
0.00028586387634277 |
SELECT * FROM productoffers WHERE product_id = '1217' AND merchantid = 'A1X6FK5RDHNB96' |
288 |
0.0003 |
0.00029182434082031 |
SELECT * FROM productoffers
WHERE product_id = '1217' AND price > 0
ORDER BY price ASC LIMIT 1 |
289 |
0.0003 |
0.00034284591674805 |
SELECT COUNT(*) FROM products WHERE parent_id = '1217' |
290 |
0.0003 |
0.00029587745666504 |
SELECT * FROM manufacturers WHERE id = '255' |
291 |
0.0003 |
0.00028014183044434 |
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '255' |
292 |
0.0003 |
0.00034499168395996 |
SELECT COUNT(*) FROM productreviews WHERE product_id = '1217' |
293 |
0.0009 |
0.00087094306945801 |
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1217' AND a.name = n.originalname |
294 |
0.0003 |
0.00028681755065918 |
SELECT * FROM productoffers WHERE product_id = '1217' AND merchantid = 'A1X6FK5RDHNB96' |
295 |
0.0003 |
0.00027680397033691 |
SELECT * FROM productoffers
WHERE product_id = '1217' AND price > 0
ORDER BY price ASC LIMIT 1 |
296 |
0.0003 |
0.00025606155395508 |
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1218' AND a.name = n.originalname |
297 |
0.0003 |
0.00025796890258789 |
SELECT * FROM productoffers WHERE product_id = '1218' AND merchantid = 'A1X6FK5RDHNB96' |
298 |
0.0003 |
0.00027203559875488 |
SELECT * FROM productoffers
WHERE product_id = '1218' AND price > 0
ORDER BY price ASC LIMIT 1 |
299 |
0.0003 |
0.00033903121948242 |
SELECT COUNT(*) FROM products WHERE parent_id = '1218' |
300 |
0.0004 |
0.00035500526428223 |
SELECT * FROM manufacturers WHERE id = '220' |
301 |
0.0003 |
0.0002899169921875 |
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '220' |
302 |
0.0005 |
0.00047111511230469 |
SELECT COUNT(*) FROM productreviews WHERE product_id = '1218' |
303 |
0.0003 |
0.00031709671020508 |
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1218' AND a.name = n.originalname |
304 |
0.0003 |
0.00029397010803223 |
SELECT * FROM productoffers WHERE product_id = '1218' AND merchantid = 'A1X6FK5RDHNB96' |
305 |
0.0003 |
0.00028395652770996 |
SELECT * FROM productoffers
WHERE product_id = '1218' AND price > 0
ORDER BY price ASC LIMIT 1 |
306 |
0.0006 |
0.00060415267944336 |
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 = '1227'
GROUP BY o.product_id |
307 |
0.0008 |
0.00083303451538086 |
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 = '1227'
GROUP BY n.displayname
ORDER BY n.displayname DESC |
308 |
0.0006 |
0.00057315826416016 |
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 1227 |
309 |
0.0004 |
0.00042605400085449 |
SELECT COUNT(*) FROM products WHERE parent_id = '1227' |
310 |
0.0003 |
0.00030708312988281 |
SELECT * FROM manufacturers WHERE id = '251' |
311 |
0.0003 |
0.00027585029602051 |
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '251' |
312 |
0.0005 |
0.00046491622924805 |
SELECT COUNT(*) FROM productreviews WHERE product_id = '1227' |
313 |
0.0009 |
0.00088000297546387 |
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1227' AND a.name = n.originalname |
314 |
0.0005 |
0.00052189826965332 |
SELECT * FROM productoffers WHERE product_id = '1227' AND merchantid = 'A1X6FK5RDHNB96' |
315 |
0.0006 |
0.00055193901062012 |
SELECT * FROM productoffers
WHERE product_id = '1227' AND price > 0
ORDER BY price ASC LIMIT 1 |
316 |
0.0007 |
0.00066995620727539 |
SELECT * FROM productoffers
WHERE product_id = 1227
ORDER BY price ASC LIMIT 1 |
317 |
0.0007 |
0.00070786476135254 |
SELECT value FROM productattributes
WHERE product_id = '1227'
AND name = 'ListPriceAmount' |
318 |
0.0003 |
0.00033020973205566 |
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1237' AND a.name = n.originalname |
319 |
0.0003 |
0.00030899047851562 |
SELECT * FROM productoffers WHERE product_id = '1237' AND merchantid = 'A1X6FK5RDHNB96' |
320 |
0.0003 |
0.00033688545227051 |
SELECT * FROM productoffers
WHERE product_id = '1237' AND price > 0
ORDER BY price ASC LIMIT 1 |
321 |
0.0005 |
0.00049710273742676 |
SELECT COUNT(*) FROM products WHERE parent_id = '1237' |
322 |
0.0006 |
0.00056600570678711 |
SELECT * FROM manufacturers WHERE id = '290' |
323 |
0.0006 |
0.00058507919311523 |
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '290' |
324 |
0.0007 |
0.00065016746520996 |
SELECT COUNT(*) FROM productreviews WHERE product_id = '1237' |
325 |
0.0003 |
0.00028300285339355 |
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1237' AND a.name = n.originalname |
326 |
0.0003 |
0.0002741813659668 |
SELECT * FROM productoffers WHERE product_id = '1237' AND merchantid = 'A1X6FK5RDHNB96' |
327 |
0.0003 |
0.00027704238891602 |
SELECT * FROM productoffers
WHERE product_id = '1237' AND price > 0
ORDER BY price ASC LIMIT 1 |
328 |
0.0003 |
0.00026893615722656 |
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1245' AND a.name = n.originalname |
329 |
0.0003 |
0.0003049373626709 |
SELECT * FROM productoffers WHERE product_id = '1245' AND merchantid = 'A1X6FK5RDHNB96' |
330 |
0.0003 |
0.00029206275939941 |
SELECT * FROM productoffers
WHERE product_id = '1245' AND price > 0
ORDER BY price ASC LIMIT 1 |
331 |
0.0006 |
0.00055098533630371 |
SELECT COUNT(*) FROM products WHERE parent_id = '1245' |
332 |
0.0003 |
0.00034308433532715 |
SELECT * FROM manufacturers WHERE id = '251' |
333 |
0.0002 |
0.00024700164794922 |
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '251' |
334 |
0.0005 |
0.00046896934509277 |
SELECT COUNT(*) FROM productreviews WHERE product_id = '1245' |
335 |
0.0003 |
0.00030899047851562 |
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1245' AND a.name = n.originalname |
336 |
0.0003 |
0.00028109550476074 |
SELECT * FROM productoffers WHERE product_id = '1245' AND merchantid = 'A1X6FK5RDHNB96' |
337 |
0.0003 |
0.00029897689819336 |
SELECT * FROM productoffers
WHERE product_id = '1245' AND price > 0
ORDER BY price ASC LIMIT 1 |
338 |
0.0003 |
0.00031113624572754 |
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1250' AND a.name = n.originalname |
339 |
0.0004 |
0.00035405158996582 |
SELECT * FROM productoffers WHERE product_id = '1250' AND merchantid = 'A1X6FK5RDHNB96' |
340 |
0.0003 |
0.00030016899108887 |
SELECT * FROM productoffers
WHERE product_id = '1250' AND price > 0
ORDER BY price ASC LIMIT 1 |
341 |
0.0005 |
0.00045919418334961 |
SELECT COUNT(*) FROM products WHERE parent_id = '1250' |
342 |
0.0003 |
0.0003199577331543 |
SELECT * FROM manufacturers WHERE id = '220' |
343 |
0.0003 |
0.00025701522827148 |
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '220' |
344 |
0.0004 |
0.00035977363586426 |
SELECT COUNT(*) FROM productreviews WHERE product_id = '1250' |
345 |
0.0003 |
0.0002601146697998 |
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1250' AND a.name = n.originalname |
346 |
0.0003 |
0.00029420852661133 |
SELECT * FROM productoffers WHERE product_id = '1250' AND merchantid = 'A1X6FK5RDHNB96' |
347 |
0.0003 |
0.00031089782714844 |
SELECT * FROM productoffers
WHERE product_id = '1250' AND price > 0
ORDER BY price ASC LIMIT 1 |
348 |
0.0003 |
0.00031113624572754 |
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1262' AND a.name = n.originalname |
349 |
0.0003 |
0.00029420852661133 |
SELECT * FROM productoffers WHERE product_id = '1262' AND merchantid = 'A1X6FK5RDHNB96' |
350 |
0.0003 |
0.00030398368835449 |
SELECT * FROM productoffers
WHERE product_id = '1262' AND price > 0
ORDER BY price ASC LIMIT 1 |
351 |
0.0004 |
0.0004270076751709 |
SELECT COUNT(*) FROM products WHERE parent_id = '1262' |
352 |
0.0005 |
0.00053000450134277 |
SELECT * FROM manufacturers WHERE id = '254' |
353 |
0.0005 |
0.00049519538879395 |
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '254' |
354 |
0.0006 |
0.00058102607727051 |
SELECT COUNT(*) FROM productreviews WHERE product_id = '1262' |
355 |
0.0003 |
0.0003359317779541 |
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1262' AND a.name = n.originalname |
356 |
0.0003 |
0.00029301643371582 |
SELECT * FROM productoffers WHERE product_id = '1262' AND merchantid = 'A1X6FK5RDHNB96' |
357 |
0.0003 |
0.00030994415283203 |
SELECT * FROM productoffers
WHERE product_id = '1262' AND price > 0
ORDER BY price ASC LIMIT 1 |
358 |
0.0015 |
0.0014669895172119 |
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1264' AND a.name = n.originalname |
359 |
0.0003 |
0.00033903121948242 |
SELECT * FROM productoffers WHERE product_id = '1264' AND merchantid = 'A1X6FK5RDHNB96' |
360 |
0.0003 |
0.00031208992004395 |
SELECT * FROM productoffers
WHERE product_id = '1264' AND price > 0
ORDER BY price ASC LIMIT 1 |
361 |
0.0007 |
0.00066089630126953 |
SELECT COUNT(*) FROM products WHERE parent_id = '1264' |
362 |
0.0035 |
0.0034768581390381 |
SELECT * FROM manufacturers WHERE id = '295' |
363 |
0.0008 |
0.00075411796569824 |
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '295' |
364 |
0.0006 |
0.00064611434936523 |
SELECT COUNT(*) FROM productreviews WHERE product_id = '1264' |
365 |
0.0003 |
0.0003361701965332 |
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1264' AND a.name = n.originalname |
366 |
0.0007 |
0.0007169246673584 |
SELECT * FROM productoffers WHERE product_id = '1264' AND merchantid = 'A1X6FK5RDHNB96' |
367 |
0.0003 |
0.0003211498260498 |
SELECT * FROM productoffers
WHERE product_id = '1264' AND price > 0
ORDER BY price ASC LIMIT 1 |
368 |
0.0008 |
0.00078701972961426 |
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4904' AND a.name = n.originalname |
369 |
0.0003 |
0.00028491020202637 |
SELECT * FROM productoffers WHERE product_id = '4904' AND merchantid = 'A1X6FK5RDHNB96' |
370 |
0.0003 |
0.00029993057250977 |
SELECT * FROM productoffers
WHERE product_id = '4904' AND price > 0
ORDER BY price ASC LIMIT 1 |
371 |
0.0004 |
0.00043797492980957 |
SELECT COUNT(*) FROM products WHERE parent_id = '4904' |
372 |
0.0005 |
0.00053787231445312 |
SELECT * FROM manufacturers WHERE id = '643' |
373 |
0.0009 |
0.00088882446289062 |
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '643' |
374 |
0.0005 |
0.00052094459533691 |
SELECT COUNT(*) FROM productreviews WHERE product_id = '4904' |
375 |
0.0003 |
0.00031495094299316 |
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4904' AND a.name = n.originalname |
376 |
0.0003 |
0.00029397010803223 |
SELECT * FROM productoffers WHERE product_id = '4904' AND merchantid = 'A1X6FK5RDHNB96' |
377 |
0.0003 |
0.00028896331787109 |
SELECT * FROM productoffers
WHERE product_id = '4904' AND price > 0
ORDER BY price ASC LIMIT 1 |
378 |
0.0007 |
0.00071287155151367 |
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 = '2836'
GROUP BY o.product_id |
379 |
0.0009 |
0.00085783004760742 |
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 = '2836'
GROUP BY n.displayname
ORDER BY n.displayname DESC |
380 |
0.0006 |
0.00056695938110352 |
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 2836 |
381 |
0.0004 |
0.00044417381286621 |
SELECT COUNT(*) FROM products WHERE parent_id = '2836' |
382 |
0.0010 |
0.00095510482788086 |
SELECT * FROM manufacturers WHERE id = '478' |
383 |
0.0007 |
0.00066590309143066 |
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '478' |
384 |
0.0006 |
0.00060296058654785 |
SELECT COUNT(*) FROM productreviews WHERE product_id = '2836' |
385 |
0.0011 |
0.0010750293731689 |
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2836' AND a.name = n.originalname |
386 |
0.0005 |
0.00054407119750977 |
SELECT * FROM productoffers WHERE product_id = '2836' AND merchantid = 'A1X6FK5RDHNB96' |
387 |
0.0005 |
0.00048494338989258 |
SELECT * FROM productoffers
WHERE product_id = '2836' AND price > 0
ORDER BY price ASC LIMIT 1 |
388 |
0.0007 |
0.00066089630126953 |
SELECT * FROM productoffers
WHERE product_id = 2836
ORDER BY price ASC LIMIT 1 |
389 |
0.0006 |
0.00055313110351562 |
SELECT value FROM productattributes
WHERE product_id = '2836'
AND name = 'ListPriceAmount' |
390 |
0.0007 |
0.00066089630126953 |
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 = '3925'
GROUP BY o.product_id |
391 |
0.0008 |
0.00083303451538086 |
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 = '3925'
GROUP BY n.displayname
ORDER BY n.displayname DESC |
392 |
0.0005 |
0.00050210952758789 |
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 3925 |
393 |
0.0007 |
0.00071001052856445 |
SELECT COUNT(*) FROM products WHERE parent_id = '3925' |
394 |
0.0008 |
0.00078105926513672 |
SELECT * FROM manufacturers WHERE id = '639' |
395 |
0.0015 |
0.0014820098876953 |
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '639' |
396 |
0.0004 |
0.00044703483581543 |
SELECT COUNT(*) FROM productreviews WHERE product_id = '3925' |
397 |
0.0003 |
0.00030016899108887 |
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3925' AND a.name = n.originalname |
398 |
0.0003 |
0.0003349781036377 |
SELECT * FROM productoffers WHERE product_id = '3925' AND merchantid = 'A1X6FK5RDHNB96' |
399 |
0.0003 |
0.00027894973754883 |
SELECT * FROM productoffers
WHERE product_id = '3925' AND price > 0
ORDER BY price ASC LIMIT 1 |
400 |
0.0003 |
0.0002899169921875 |
SELECT * FROM productoffers
WHERE product_id = 3925
ORDER BY price ASC LIMIT 1 |
401 |
0.0003 |
0.00030207633972168 |
SELECT value FROM productattributes
WHERE product_id = '3925'
AND name = 'ListPriceAmount' |
402 |
0.0007 |
0.0006561279296875 |
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 = '4474'
GROUP BY o.product_id |
403 |
0.0006 |
0.00063514709472656 |
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 = '4474'
GROUP BY n.displayname
ORDER BY n.displayname DESC |
404 |
0.0004 |
0.00044393539428711 |
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 4474 |
405 |
0.0004 |
0.00037002563476562 |
SELECT COUNT(*) FROM products WHERE parent_id = '4474' |
406 |
0.0003 |
0.00026202201843262 |
SELECT * FROM manufacturers WHERE id = '639' |
407 |
0.0003 |
0.00027990341186523 |
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '639' |
408 |
0.0004 |
0.00041890144348145 |
SELECT COUNT(*) FROM productreviews WHERE product_id = '4474' |
409 |
0.0003 |
0.00027799606323242 |
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4474' AND a.name = n.originalname |
410 |
0.0003 |
0.00025796890258789 |
SELECT * FROM productoffers WHERE product_id = '4474' AND merchantid = 'A1X6FK5RDHNB96' |
411 |
0.0004 |
0.00037908554077148 |
SELECT * FROM productoffers
WHERE product_id = '4474' AND price > 0
ORDER BY price ASC LIMIT 1 |
412 |
0.0003 |
0.00026702880859375 |
SELECT * FROM productoffers
WHERE product_id = 4474
ORDER BY price ASC LIMIT 1 |
413 |
0.0002 |
0.00024104118347168 |
SELECT value FROM productattributes
WHERE product_id = '4474'
AND name = 'ListPriceAmount' |
414 |
0.0003 |
0.0003209114074707 |
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4905' AND a.name = n.originalname |
415 |
0.0003 |
0.00029206275939941 |
SELECT * FROM productoffers WHERE product_id = '4905' AND merchantid = 'A1X6FK5RDHNB96' |
416 |
0.0003 |
0.00027012825012207 |
SELECT * FROM productoffers
WHERE product_id = '4905' AND price > 0
ORDER BY price ASC LIMIT 1 |
417 |
0.0009 |
0.00085616111755371 |
SELECT COUNT(*) FROM products WHERE parent_id = '4905' |
418 |
0.0008 |
0.0007779598236084 |
SELECT * FROM manufacturers WHERE id = '644' |
419 |
0.0006 |
0.0005640983581543 |
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '644' |
420 |
0.0004 |
0.0003669261932373 |
SELECT COUNT(*) FROM productreviews WHERE product_id = '4905' |
421 |
0.0003 |
0.00028705596923828 |
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4905' AND a.name = n.originalname |
422 |
0.0003 |
0.00031900405883789 |
SELECT * FROM productoffers WHERE product_id = '4905' AND merchantid = 'A1X6FK5RDHNB96' |
423 |
0.0003 |
0.00025701522827148 |
SELECT * FROM productoffers
WHERE product_id = '4905' AND price > 0
ORDER BY price ASC LIMIT 1 |
424 |
0.0006 |
0.00059008598327637 |
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 = '2029'
GROUP BY o.product_id |
425 |
0.0008 |
0.00079083442687988 |
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 = '2029'
GROUP BY n.displayname
ORDER BY n.displayname DESC |
426 |
0.0006 |
0.00058293342590332 |
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 2029 |
427 |
0.0004 |
0.00043296813964844 |
SELECT COUNT(*) FROM products WHERE parent_id = '2029' |
428 |
0.0004 |
0.00041604042053223 |
SELECT * FROM manufacturers WHERE id = '185' |
429 |
0.0006 |
0.00063896179199219 |
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '185' |
430 |
0.0005 |
0.00048518180847168 |
SELECT COUNT(*) FROM productreviews WHERE product_id = '2029' |
431 |
0.0003 |
0.00032615661621094 |
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2029' AND a.name = n.originalname |
432 |
0.0003 |
0.00025010108947754 |
SELECT * FROM productoffers WHERE product_id = '2029' AND merchantid = 'A1X6FK5RDHNB96' |
433 |
0.0003 |
0.00030708312988281 |
SELECT * FROM productoffers
WHERE product_id = '2029' AND price > 0
ORDER BY price ASC LIMIT 1 |
434 |
0.0004 |
0.00035190582275391 |
SELECT * FROM productoffers
WHERE product_id = 2029
ORDER BY price ASC LIMIT 1 |
435 |
0.0002 |
0.000244140625 |
SELECT value FROM productattributes
WHERE product_id = '2029'
AND name = 'ListPriceAmount' |
436 |
0.0003 |
0.0002748966217041 |
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4906' AND a.name = n.originalname |
437 |
0.0004 |
0.00035309791564941 |
SELECT * FROM productoffers WHERE product_id = '4906' AND merchantid = 'A1X6FK5RDHNB96' |
438 |
0.0003 |
0.0003199577331543 |
SELECT * FROM productoffers
WHERE product_id = '4906' AND price > 0
ORDER BY price ASC LIMIT 1 |
439 |
0.0006 |
0.00055098533630371 |
SELECT COUNT(*) FROM products WHERE parent_id = '4906' |
440 |
0.0007 |
0.00072288513183594 |
SELECT * FROM manufacturers WHERE id = '645' |
441 |
0.0006 |
0.00059795379638672 |
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '645' |
442 |
0.0004 |
0.00035405158996582 |
SELECT COUNT(*) FROM productreviews WHERE product_id = '4906' |
443 |
0.0003 |
0.00030016899108887 |
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4906' AND a.name = n.originalname |
444 |
0.0003 |
0.00026512145996094 |
SELECT * FROM productoffers WHERE product_id = '4906' AND merchantid = 'A1X6FK5RDHNB96' |
445 |
0.0003 |
0.00028109550476074 |
SELECT * FROM productoffers
WHERE product_id = '4906' AND price > 0
ORDER BY price ASC LIMIT 1 |
446 |
0.0003 |
0.00025701522827148 |
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4907' AND a.name = n.originalname |
447 |
0.0003 |
0.00026512145996094 |
SELECT * FROM productoffers WHERE product_id = '4907' AND merchantid = 'A1X6FK5RDHNB96' |
448 |
0.0003 |
0.00026893615722656 |
SELECT * FROM productoffers
WHERE product_id = '4907' AND price > 0
ORDER BY price ASC LIMIT 1 |
449 |
0.0004 |
0.00038504600524902 |
SELECT COUNT(*) FROM products WHERE parent_id = '4907' |
450 |
0.0003 |
0.00029516220092773 |
SELECT * FROM manufacturers WHERE id = '220' |
451 |
0.0002 |
0.00023984909057617 |
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '220' |
452 |
0.0004 |
0.00037789344787598 |
SELECT COUNT(*) FROM productreviews WHERE product_id = '4907' |
453 |
0.0003 |
0.00029516220092773 |
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4907' AND a.name = n.originalname |
454 |
0.0003 |
0.00027990341186523 |
SELECT * FROM productoffers WHERE product_id = '4907' AND merchantid = 'A1X6FK5RDHNB96' |
455 |
0.0003 |
0.00030303001403809 |
SELECT * FROM productoffers
WHERE product_id = '4907' AND price > 0
ORDER BY price ASC LIMIT 1 |
456 |
0.0003 |
0.00027918815612793 |
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4909' AND a.name = n.originalname |
457 |
0.0003 |
0.00027608871459961 |
SELECT * FROM productoffers WHERE product_id = '4909' AND merchantid = 'A1X6FK5RDHNB96' |
458 |
0.0003 |
0.00029206275939941 |
SELECT * FROM productoffers
WHERE product_id = '4909' AND price > 0
ORDER BY price ASC LIMIT 1 |
459 |
0.0005 |
0.00045108795166016 |
SELECT COUNT(*) FROM products WHERE parent_id = '4909' |
460 |
0.0006 |
0.00055480003356934 |
SELECT * FROM manufacturers WHERE id = '646' |
461 |
0.0006 |
0.00060391426086426 |
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '646' |
462 |
0.0004 |
0.0003969669342041 |
SELECT COUNT(*) FROM productreviews WHERE product_id = '4909' |
463 |
0.0003 |
0.00029802322387695 |
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4909' AND a.name = n.originalname |
464 |
0.0003 |
0.00029301643371582 |
SELECT * FROM productoffers WHERE product_id = '4909' AND merchantid = 'A1X6FK5RDHNB96' |
465 |
0.0003 |
0.00028896331787109 |
SELECT * FROM productoffers
WHERE product_id = '4909' AND price > 0
ORDER BY price ASC LIMIT 1 |
466 |
0.0022 |
0.0022408962249756 |
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4910' AND a.name = n.originalname |
467 |
0.0007 |
0.0006711483001709 |
SELECT * FROM productoffers WHERE product_id = '4910' AND merchantid = 'A1X6FK5RDHNB96' |
468 |
0.0008 |
0.00079011917114258 |
SELECT * FROM productoffers
WHERE product_id = '4910' AND price > 0
ORDER BY price ASC LIMIT 1 |
469 |
0.0009 |
0.00092577934265137 |
SELECT COUNT(*) FROM products WHERE parent_id = '4910' |
470 |
0.0014 |
0.0014300346374512 |
SELECT * FROM manufacturers WHERE id = '647' |
471 |
0.0007 |
0.00065207481384277 |
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '647' |
472 |
0.0006 |
0.00056314468383789 |
SELECT COUNT(*) FROM productreviews WHERE product_id = '4910' |
473 |
0.0003 |
0.00029993057250977 |
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4910' AND a.name = n.originalname |
474 |
0.0003 |
0.00027608871459961 |
SELECT * FROM productoffers WHERE product_id = '4910' AND merchantid = 'A1X6FK5RDHNB96' |
475 |
0.0003 |
0.00029301643371582 |
SELECT * FROM productoffers
WHERE product_id = '4910' AND price > 0
ORDER BY price ASC LIMIT 1 |
476 |
0.0004 |
0.00036716461181641 |
SELECT * FROM productimages WHERE product_id = '853' ORDER BY sortorder ASC |
477 |
0.0003 |
0.00026297569274902 |
SELECT * FROM product_image_select WHERE product_id = '853' |
478 |
0.0003 |
0.00029087066650391 |
SELECT * FROM productcustomimages WHERE product_id = '853' |
479 |
0.0003 |
0.00033211708068848 |
SELECT * FROM productimages WHERE product_id = '857' ORDER BY sortorder ASC |
480 |
0.0003 |
0.00026106834411621 |
SELECT * FROM product_image_select WHERE product_id = '857' |
481 |
0.0003 |
0.00026297569274902 |
SELECT * FROM productcustomimages WHERE product_id = '857' |
482 |
0.0003 |
0.00027680397033691 |
SELECT * FROM productimages WHERE product_id = '866' ORDER BY sortorder ASC |
483 |
0.0003 |
0.00029516220092773 |
SELECT * FROM product_image_select WHERE product_id = '866' |
484 |
0.0003 |
0.00029706954956055 |
SELECT * FROM productcustomimages WHERE product_id = '866' |
485 |
0.0003 |
0.00034499168395996 |
SELECT * FROM productimages WHERE product_id = '868' ORDER BY sortorder ASC |
486 |
0.0003 |
0.00026893615722656 |
SELECT * FROM product_image_select WHERE product_id = '868' |
487 |
0.0003 |
0.0002741813659668 |
SELECT * FROM productcustomimages WHERE product_id = '868' |
488 |
0.0003 |
0.00034117698669434 |
SELECT * FROM productimages WHERE product_id = '931' ORDER BY sortorder ASC |
489 |
0.0003 |
0.00026297569274902 |
SELECT * FROM product_image_select WHERE product_id = '931' |
490 |
0.0003 |
0.00027799606323242 |
SELECT * FROM productcustomimages WHERE product_id = '931' |
491 |
0.0007 |
0.00066089630126953 |
SELECT * FROM productimages WHERE product_id = '932' ORDER BY sortorder ASC |
492 |
0.0010 |
0.0010290145874023 |
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '932' AND p.id = pi.product_id ORDER BY pi.sortorder |
493 |
0.0011 |
0.0010650157928467 |
SELECT * FROM product_image_select WHERE product_id = '932' |
494 |
0.0007 |
0.00070810317993164 |
SELECT * FROM productcustomimages WHERE product_id = '932' |
495 |
0.0004 |
0.00037217140197754 |
SELECT * FROM productimages WHERE product_id = '970' ORDER BY sortorder ASC |
496 |
0.0003 |
0.00029206275939941 |
SELECT * FROM product_image_select WHERE product_id = '970' |
497 |
0.0003 |
0.00028896331787109 |
SELECT * FROM productcustomimages WHERE product_id = '970' |
498 |
0.0003 |
0.00029683113098145 |
SELECT * FROM productimages WHERE product_id = '1056' ORDER BY sortorder ASC |
499 |
0.0003 |
0.00028491020202637 |
SELECT * FROM product_image_select WHERE product_id = '1056' |
500 |
0.0003 |
0.00031399726867676 |
SELECT * FROM productcustomimages WHERE product_id = '1056' |
501 |
0.0003 |
0.00032687187194824 |
SELECT * FROM productimages WHERE product_id = '1089' ORDER BY sortorder ASC |
502 |
0.0003 |
0.00030684471130371 |
SELECT * FROM product_image_select WHERE product_id = '1089' |
503 |
0.0003 |
0.00033187866210938 |
SELECT * FROM productcustomimages WHERE product_id = '1089' |
504 |
0.0004 |
0.00035381317138672 |
SELECT * FROM productimages WHERE product_id = '1110' ORDER BY sortorder ASC |
505 |
0.0003 |
0.00026392936706543 |
SELECT * FROM product_image_select WHERE product_id = '1110' |
506 |
0.0003 |
0.00028014183044434 |
SELECT * FROM productcustomimages WHERE product_id = '1110' |
507 |
0.0004 |
0.00035500526428223 |
SELECT * FROM productimages WHERE product_id = '1145' ORDER BY sortorder ASC |
508 |
0.0003 |
0.00029611587524414 |
SELECT * FROM product_image_select WHERE product_id = '1145' |
509 |
0.0003 |
0.00027012825012207 |
SELECT * FROM productcustomimages WHERE product_id = '1145' |
510 |
0.0010 |
0.00097894668579102 |
SELECT * FROM productimages WHERE product_id = '1160' ORDER BY sortorder ASC |
511 |
0.0006 |
0.00056600570678711 |
SELECT * FROM product_image_select WHERE product_id = '1160' |
512 |
0.0004 |
0.00043416023254395 |
SELECT * FROM productcustomimages WHERE product_id = '1160' |
513 |
0.0005 |
0.00053000450134277 |
SELECT * FROM productimages WHERE product_id = '1167' ORDER BY sortorder ASC |
514 |
0.0089 |
0.0089099407196045 |
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '1167' AND p.id = pi.product_id ORDER BY pi.sortorder |
515 |
0.0006 |
0.00059390068054199 |
SELECT * FROM product_image_select WHERE product_id = '1167' |
516 |
0.0005 |
0.00051283836364746 |
SELECT * FROM productcustomimages WHERE product_id = '1167' |
517 |
0.0003 |
0.00033783912658691 |
SELECT * FROM productimages WHERE product_id = '1201' ORDER BY sortorder ASC |
518 |
0.0003 |
0.00029492378234863 |
SELECT * FROM product_image_select WHERE product_id = '1201' |
519 |
0.0003 |
0.00028419494628906 |
SELECT * FROM productcustomimages WHERE product_id = '1201' |
520 |
0.0003 |
0.00034093856811523 |
SELECT * FROM productimages WHERE product_id = '1217' ORDER BY sortorder ASC |
521 |
0.0003 |
0.00028800964355469 |
SELECT * FROM product_image_select WHERE product_id = '1217' |
522 |
0.0003 |
0.00028800964355469 |
SELECT * FROM productcustomimages WHERE product_id = '1217' |
523 |
0.0004 |
0.00035190582275391 |
SELECT * FROM productimages WHERE product_id = '1218' ORDER BY sortorder ASC |
524 |
0.0003 |
0.0002739429473877 |
SELECT * FROM product_image_select WHERE product_id = '1218' |
525 |
0.0003 |
0.00027012825012207 |
SELECT * FROM productcustomimages WHERE product_id = '1218' |
526 |
0.0005 |
0.00049400329589844 |
SELECT * FROM productimages WHERE product_id = '1227' ORDER BY sortorder ASC |
527 |
0.0007 |
0.00070810317993164 |
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '1227' AND p.id = pi.product_id ORDER BY pi.sortorder |
528 |
0.0005 |
0.00048518180847168 |
SELECT * FROM product_image_select WHERE product_id = '1227' |
529 |
0.0004 |
0.0004119873046875 |
SELECT * FROM productcustomimages WHERE product_id = '1227' |
530 |
0.0003 |
0.0003349781036377 |
SELECT * FROM productimages WHERE product_id = '1237' ORDER BY sortorder ASC |
531 |
0.0003 |
0.00028491020202637 |
SELECT * FROM product_image_select WHERE product_id = '1237' |
532 |
0.0003 |
0.00032711029052734 |
SELECT * FROM productcustomimages WHERE product_id = '1237' |
533 |
0.0003 |
0.0003199577331543 |
SELECT * FROM productimages WHERE product_id = '1245' ORDER BY sortorder ASC |
534 |
0.0003 |
0.00030803680419922 |
SELECT * FROM product_image_select WHERE product_id = '1245' |
535 |
0.0003 |
0.00029206275939941 |
SELECT * FROM productcustomimages WHERE product_id = '1245' |
536 |
0.0004 |
0.00035691261291504 |
SELECT * FROM productimages WHERE product_id = '1250' ORDER BY sortorder ASC |
537 |
0.0003 |
0.00031089782714844 |
SELECT * FROM product_image_select WHERE product_id = '1250' |
538 |
0.0003 |
0.00029301643371582 |
SELECT * FROM productcustomimages WHERE product_id = '1250' |
539 |
0.0003 |
0.00029802322387695 |
SELECT * FROM productimages WHERE product_id = '1262' ORDER BY sortorder ASC |
540 |
0.0003 |
0.00028109550476074 |
SELECT * FROM product_image_select WHERE product_id = '1262' |
541 |
0.0003 |
0.00030398368835449 |
SELECT * FROM productcustomimages WHERE product_id = '1262' |
542 |
0.0003 |
0.00029587745666504 |
SELECT * FROM productimages WHERE product_id = '1264' ORDER BY sortorder ASC |
543 |
0.0003 |
0.00028681755065918 |
SELECT * FROM product_image_select WHERE product_id = '1264' |
544 |
0.0003 |
0.00029587745666504 |
SELECT * FROM productcustomimages WHERE product_id = '1264' |
545 |
0.0004 |
0.00036001205444336 |
SELECT * FROM productimages WHERE product_id = '4904' ORDER BY sortorder ASC |
546 |
0.0003 |
0.0002901554107666 |
SELECT * FROM product_image_select WHERE product_id = '4904' |
547 |
0.0003 |
0.00030708312988281 |
SELECT * FROM productcustomimages WHERE product_id = '4904' |
548 |
0.0012 |
0.0012469291687012 |
SELECT * FROM productimages WHERE product_id = '2836' ORDER BY sortorder ASC |
549 |
0.0022 |
0.0022239685058594 |
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '2836' AND p.id = pi.product_id ORDER BY pi.sortorder |
550 |
0.0008 |
0.00081586837768555 |
SELECT * FROM product_image_select WHERE product_id = '2836' |
551 |
0.0006 |
0.00062704086303711 |
SELECT * FROM productcustomimages WHERE product_id = '2836' |
552 |
0.0003 |
0.00033020973205566 |
SELECT * FROM productimages WHERE product_id = '3925' ORDER BY sortorder ASC |
553 |
0.0008 |
0.00076580047607422 |
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '3925' AND p.id = pi.product_id ORDER BY pi.sortorder |
554 |
0.0004 |
0.00038814544677734 |
SELECT * FROM product_image_select WHERE product_id = '3925' |
555 |
0.0003 |
0.0002899169921875 |
SELECT * FROM productcustomimages WHERE product_id = '3925' |
556 |
0.0003 |
0.00031685829162598 |
SELECT * FROM productimages WHERE product_id = '4474' ORDER BY sortorder ASC |
557 |
0.0008 |
0.00080204010009766 |
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '4474' AND p.id = pi.product_id ORDER BY pi.sortorder |
558 |
0.0009 |
0.00086188316345215 |
SELECT * FROM product_image_select WHERE product_id = '4474' |
559 |
0.0004 |
0.00035405158996582 |
SELECT * FROM productcustomimages WHERE product_id = '4474' |
560 |
0.0003 |
0.00030398368835449 |
SELECT * FROM productimages WHERE product_id = '4905' ORDER BY sortorder ASC |
561 |
0.0003 |
0.0002899169921875 |
SELECT * FROM product_image_select WHERE product_id = '4905' |
562 |
0.0003 |
0.00029277801513672 |
SELECT * FROM productcustomimages WHERE product_id = '4905' |
563 |
0.0004 |
0.00036191940307617 |
SELECT * FROM productimages WHERE product_id = '2029' ORDER BY sortorder ASC |
564 |
0.0015 |
0.0014710426330566 |
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '2029' AND p.id = pi.product_id ORDER BY pi.sortorder |
565 |
0.0003 |
0.00033307075500488 |
SELECT * FROM product_image_select WHERE product_id = '2029' |
566 |
0.0003 |
0.00034999847412109 |
SELECT * FROM productcustomimages WHERE product_id = '2029' |
567 |
0.0004 |
0.0003669261932373 |
SELECT * FROM productimages WHERE product_id = '4906' ORDER BY sortorder ASC |
568 |
0.0003 |
0.00026917457580566 |
SELECT * FROM product_image_select WHERE product_id = '4906' |
569 |
0.0003 |
0.00029301643371582 |
SELECT * FROM productcustomimages WHERE product_id = '4906' |
570 |
0.0003 |
0.00030183792114258 |
SELECT * FROM productimages WHERE product_id = '4907' ORDER BY sortorder ASC |
571 |
0.0003 |
0.00032997131347656 |
SELECT * FROM product_image_select WHERE product_id = '4907' |
572 |
0.0003 |
0.00029301643371582 |
SELECT * FROM productcustomimages WHERE product_id = '4907' |
573 |
0.0003 |
0.00030183792114258 |
SELECT * FROM productimages WHERE product_id = '4909' ORDER BY sortorder ASC |
574 |
0.0003 |
0.00029110908508301 |
SELECT * FROM product_image_select WHERE product_id = '4909' |
575 |
0.0003 |
0.00033807754516602 |
SELECT * FROM productcustomimages WHERE product_id = '4909' |
576 |
0.0010 |
0.0010240077972412 |
SELECT * FROM productimages WHERE product_id = '4910' ORDER BY sortorder ASC |
577 |
0.0005 |
0.00052690505981445 |
SELECT * FROM product_image_select WHERE product_id = '4910' |
578 |
0.0004 |
0.00042486190795898 |
SELECT * FROM productcustomimages WHERE product_id = '4910' |