"sql"	"count"	"time"	"avg_avg_time"	"median_avg_time"	"sd_avg_time"	"avg_time"
"DELETE FROM webappsstore2_view WHERE scope = :scope AND key = :key"	49091	1300078380	7005.20763079705	145.823529411765	189468.43498097	26483.0290684647
"UPDATE moz_downloads SET tempPath = :tempPath, startTime = :startTime, endTime = :endTime, state = :state, referrer = :referrer, entityID = :entityID, currBytes = :currBytes, maxBytes = :maxBytes, autoResume = :autoResume WHERE id = :id"	8119	1722674	208.246570785235	151	390.325545718681	212.178100751324
"UPDATE moz_bookmarks SET lastModified = :date WHERE id = :item_id"	6179	2023460	268.14117471257	151	711.728713127675	327.473701246156
"RELEASE SAVEPOINT 'default'"	3608	1101127	341.596278775534	223.6	428.232105887816	305.190410199557
"PRAGMA page_size"	2997	163793683	3944.56822082937	362	167990.153057943	54652.5468802135
"UPDATE moz_logins SET hostname = :hostname, httpRealm = :httpRealm, formSubmitURL = :formSubmitURL, usernameField = :usernameField, passwordField = :passwordField, encryptedUsername = :encryptedUsername, encryptedPassword = :encryptedPassword, guid = :guid, encType = :encType, timeCreated = :timeCreated, timeLastUsed = :timeLastUsed, timePasswordChanged = :timePasswordChanged, timesUsed = :timesUsed WHERE id = :id"	2541	544606	221.385663660995	152	523.174923186683	214.327430145612
"INSERT INTO moz_downloads (name, source, target, tempPath, startTime, endTime, state, mimeType, preferredApplication, preferredAction) VALUES (:name, :source, :target, :tempPath, :startTime, :endTime, :state, :mimeType, :preferredApplication, :preferredAction)"	2283	482501	211.39773784349	150.666666666667	237.696490213776	211.345159877354
"INSERT INTO moz_formhistory (fieldname, value, timesUsed, firstUsed, lastUsed, guid) VALUES (:fieldname, :value, :timesUsed, :firstUsed, :lastUsed, :guid)"	1910	368443	206.728387500304	141	461.330348475737	192.902094240838
"INSERT OR REPLACE INTO webappsstore2 SELECT * FROM webappsstore2_temp WHERE scope = :scope;"	1546	18722447	3386.83150152702	247.5	59414.8656605352	12110.2503234153
"DELETE FROM moz_formhistory WHERE lastUsed <= :expireTime"	1535	1984539	1306.04683377309	184	38526.8456299385	1292.85928338762
"DELETE FROM moz_items_annos WHERE item_id = :item_id AND anno_attribute_id = (SELECT id FROM moz_anno_attributes WHERE name = :anno_name)"	1190	409107	284.29667992487	156	733.921996603909	343.787394957983
"SELECT h.id, h.url, IFNULL(b.title, h.title), h.rev_host, h.visit_count, h.last_visit_date, f.url, null, b.id, b.dateAdded, b.lastModified, b.parent, null, h.frecency, b.position, b.type, b.fk, b.guid FROM moz_bookmarks b LEFT JOIN moz_places h ON b.fk = h.id LEFT JOIN moz_favicons f ON h.favicon_id = f.id WHERE b.parent = :parent ORDER BY b.position ASC"	1038	221769	211.172245558651	147.666666666667	366.999880478681	213.650289017341
"INSERT OR IGNORE INTO moz_places (url, title, rev_host, hidden, typed, frecency, guid) VALUES (:page_url, :page_title, :rev_host, :hidden, :typed, :frecency, GENERATE_GUID()) "	974	244983	243.73906099963	179.45	259.603059536859	251.522587268994
"UPDATE moz_hosts SET permission = ?2, expireType= ?3, expireTime = ?4 WHERE id = ?1"	907	887764	730.608574640032	235	5833.74631563721	978.791620727674
"SELECT h.url FROM moz_anno_attributes n JOIN moz_annos a ON n.id = a.anno_attribute_id JOIN moz_places h ON h.id = a.place_id WHERE n.name = :anno_name"	802	102837	226.171650982861	120.366492146597	246.912504114328	128.225685785536
"UPDATE addon SET userDisabled=:userDisabled, appDisabled=:appDisabled, softDisabled=:softDisabled, pendingUninstall=:pendingUninstall, applyBackgroundUpdates=:applyBackgroundUpdates WHERE internal_id=:internal_id"	721	141207	195.745674853261	148.425	128.620834630957	195.848821081831
"PRAGMA page_count"	697	535078	769.340448625181	422	1064.29946475792	767.687230989957
"SELECT count(*) AS c FROM moz_places"	555	337972	608.958558558559	347	739.232319685248	608.958558558559
"INSERT INTO webappsstore2_temp SELECT * FROM webappsstore2 WHERE scope = :scope AND NOT EXISTS (SELECT scope, key FROM webappsstore2_temp WHERE scope = webappsstore2.scope AND key = webappsstore2.key)"	549	332095	498.890040573805	161	2365.12673811018	604.908925318761
"SELECT COUNT(1) AS numEntries FROM moz_formhistory"	534	243895	452.976325757576	192	912.176970926454	456.732209737828
"SELECT a.item_id FROM moz_anno_attributes n JOIN moz_items_annos a ON n.id = a.anno_attribute_id WHERE n.name = :anno_name"	481	4295073077	9276597.10151188	147	199604044.961872	8929465.85654886
"INSERT INTO moz_logins (hostname, httpRealm, formSubmitURL, usernameField, passwordField, encryptedUsername, encryptedPassword, guid, encType, timeCreated, timeLastUsed, timePasswordChanged, timesUsed) VALUES (:hostname, :httpRealm, :formSubmitURL, :usernameField, :passwordField, :encryptedUsername, :encryptedPassword, :guid, :encType, :timeCreated, :timeLastUsed, :timePasswordChanged, :timesUsed)"	459	99555	235.822345000042	154	264.522766405857	216.895424836601
"UPDATE moz_formhistory SET timesUsed = timesUsed + 1, lastUsed = :lastUsed WHERE id = :id"	420	75800	187.242614379085	140	194.539211739797	180.47619047619
"SELECT session FROM moz_historyvisits ORDER BY visit_date DESC "	356	72309	203.115168539326	142.5	222.072315832947	203.115168539326
"INSERT INTO moz_bookmarks (id, fk, type, parent, position, title, dateAdded, lastModified, guid) VALUES (:item_id, :page_id, :item_type, :parent, :item_index, :item_title, :date_added, :last_modified, GENERATE_GUID())"	342	748214	339.658652356482	163	720.277089437147	2187.76023391813
"DELETE FROM moz_downloads WHERE id = :id"	286	52983	206.391206493543	145	170.291924556135	185.255244755245
"DELETE FROM addon WHERE internal_id=:internal_id"	256	75754	294.112	183.5	541.669864999722	295.9140625
"SELECT ROUND(( strftime('%s','now','localtime','utc') - ( SELECT visit_date FROM moz_historyvisits ORDER BY visit_date ASC LIMIT 1 )/1000000 )/86400) AS daysOfHistory "	247	43450	176.332522386059	157.5	69.0772329352084	175.910931174089
"SELECT name, value, host, path, expiry, lastAccessed, creationTime, isSecure, isHttpOnly FROM moz_cookies WHERE baseDomain = :baseDomain"	246	49029	199.966138637191	149	143.577147948315	199.30487804878
"UPDATE moz_downloads SET state = :state WHERE state = :state_cond"	238	93876	394.436974789916	190.5	580.597598996439	394.436974789916
"DELETE FROM moz_bookmarks WHERE parent IN (:parent)"	216	57990	233.598086124402	144	541.527457038966	268.472222222222
"SELECT COUNT(1) AS numLogins FROM moz_logins WHERE (hostname = :hostname) AND (httpRealm isnull)"	202	81079	326.33117816092	175.25	443.203181732253	401.381188118812
"DELETE FROM moz_downloads WHERE state = ? OR state = ? OR state = ? OR state = ? OR state = ? OR state = ?"	197	47128	252.310966810967	140	322.55053854602	239.228426395939
"INSERT OR REPLACE INTO moz_annos (id, place_id, anno_attribute_id, mime_type, content, flags, expiration, type, dateAdded, lastModified) VALUES (:id, :fk, :name_id, :mime_type, :content, :flags, :expiration, :type, :date_added, :last_modified)"	176	32729	186.276709401709	139.5	197.27940222855	185.960227272727
"INSERT OR IGNORE INTO moz_anno_attributes (name) VALUES (:anno_name)"	148	33555	258.422875816993	147	621.955576823335	226.722972972973
"SELECT SUM(LENGTH(key) + LENGTH(value)) FROM (SELECT key, value FROM webappsstore2_temp WHERE scope GLOB :scope AND NOT ISOFFLINE(scope) UNION ALL SELECT key, value FROM webappsstore2 WHERE scope GLOB :scope AND NOT ISOFFLINE(scope) AND NOT EXISTS (SELECT scope, key FROM webappsstore2_temp WHERE scope = webappsstore2.scope AND key = webappsstore2.key))"	141	10722200	10326.2857476636	154	103022.067959828	76043.9716312057
"SELECT a.id, a.item_id, :anno_name, a.mime_type, a.content, a.flags, a.expiration, a.type FROM moz_anno_attributes n JOIN moz_items_annos a ON a.anno_attribute_id = n.id WHERE a.item_id = :item_id AND n.name = :anno_name"	126	35304	285.599616858238	167	363.100597911686	280.190476190476
"SELECT root_name, folder_id FROM moz_bookmarks_roots"	121	30977	253.354166666667	154	283.418332581005	256.00826446281
"DELETE FROM moz_hosts WHERE expireType = ?1 AND expireTime <= ?2"	115	42204	366.991304347826	194	396.635421789909	366.991304347826
"SELECT prefs.value AS value FROM prefs JOIN settings ON prefs.settingID = settings.id WHERE prefs.groupID IS NULL AND settings.name = :name"	115	23979	208.513043478261	148	237.257036026679	208.513043478261
"SELECT null, 'place:folder=' || id || '&queryType=1&type=7', title, null, null, null, null, null, null, dateAdded, lastModified, null, null FROM moz_bookmarks WHERE parent = 4 ORDER BY 3 COLLATE NOCASE ASC"	107	19464	168.614886731392	181.844660194175	44.5002267343372	181.906542056075
"SELECT id, url, title, rev_host, visit_count, guid FROM moz_places WHERE url = :page_url "	99	73001	329.166468253968	156	1005.59537573437	737.383838383838
"PRAGMA journal_mode"	97	3141770	16751.4894736842	280	158977.437517273	32389.381443299
"SELECT b.id, (SELECT id FROM moz_anno_attributes WHERE name = :anno_name) AS nameid, a.id, a.dateAdded FROM moz_bookmarks b LEFT JOIN moz_items_annos a ON a.item_id = b.id AND a.anno_attribute_id = nameid WHERE b.id = :item_id"	95	30501	298.938683127572	168	399.964505663273	321.063157894737
"SELECT f.id, f.url, length(f.data), f.expiration FROM moz_places h JOIN moz_favicons f ON h.favicon_id = f.id WHERE h.url = :page_url LIMIT 1"	71	11703	168.988720538721	148	70.6296032789777	164.830985915493
"SELECT id FROM moz_downloads WHERE source = :source"	71	27077	380.307843137255	186	618.114690924957	381.366197183099
"SELECT b.id, h.url, b.title, b.position, b.fk, b.parent, b.type, b.dateAdded, b.lastModified, b.guid, t.guid, t.parent FROM moz_bookmarks b LEFT JOIN moz_bookmarks t ON t.id = b.parent LEFT JOIN moz_places h ON h.id = b.fk WHERE b.id = :item_id"	70	12580	185.706349206349	130	227.117786602669	179.714285714286
"SELECT hostname FROM moz_disabledHosts WHERE hostname = :hostname"	67	33565	517.583333333333	193	981.442613731931	500.970149253731
"SELECT h.id, h.url, h.title AS page_title, h.rev_host, h.visit_count, h.last_visit_date, f.url, null, null, null, null, null, null AS tags , h.frecency FROM moz_places h LEFT OUTER JOIN moz_favicons f ON h.favicon_id = f.id WHERE h.hidden = 0 AND EXISTS (SELECT id FROM moz_historyvisits WHERE place_id = h.id AND visit_type NOT IN (0,4,8) LIMIT 1) AND EXISTS ( SELECT id FROM moz_historyvisits v WHERE place_id = h.id AND NOT EXISTS(SELECT id FROM moz_historyvisits WHERE from_visit = v.id AND visit_type IN (5,6)) ) ORDER BY visit_count DESC LIMIT 10"	66	9869	175.124890350877	151.216666666667	68.093065968043	149.530303030303
"INSERT OR REPLACE INTO moz_items_annos (id, item_id, anno_attribute_id, mime_type, content, flags, expiration, type, dateAdded, lastModified) VALUES (:id, :fk, :name_id, :mime_type, :content, :flags, :expiration, :type, :date_added, :last_modified)"	58	50123	952.768333333333	221.5	4417.26395734355	864.189655172414
"SELECT id, guid FROM moz_formhistory WHERE fieldname = :fieldname AND value = :value"	55	15308	280.296296296296	169.5	348.270748593169	278.327272727273
"DELETE FROM moz_formhistory"	53	17805	335.798076923077	237.5	259.861883745347	335.943396226415
"SELECT b.fk, h.url, COALESCE(b.title, h.title) AS page_title, h.rev_host, h.visit_count, h.last_visit_date, f.url, null, b.id, b.dateAdded, b.lastModified, b.parent, null AS tags , h.frecency FROM moz_bookmarks b JOIN moz_places h ON b.fk = h.id LEFT OUTER JOIN moz_favicons f ON h.favicon_id = f.id WHERE NOT EXISTS (SELECT id FROM moz_bookmarks WHERE id = b.parent AND parent = 4) ORDER BY 10 DESC"	52	9423	236.030555555556	159.122222222222	178.638611450274	181.211538461538
"DELETE FROM webappsstore2_view WHERE scope = :scope"	51	16801	354.857456140351	175.5	653.370762426399	329.43137254902
"INSERT INTO locale (name, description, creator, homepageURL) VALUES (:name, :description, :creator, :homepageURL)"	50	9452	189.04	150.5	104.674414549232	189.04
"SELECT b.id, b.guid, b.parent, b.lastModified, t.guid, t.parent FROM moz_bookmarks b JOIN moz_bookmarks t on t.id = b.parent WHERE b.fk = (SELECT id FROM moz_places WHERE url = :page_url) ORDER BY b.lastModified DESC, b.id DESC "	46	7287	180.605208333333	165.984375	69.7315050347797	158.413043478261
"SELECT value, ROUND( timesUsed / MAX(1.0, (lastUsed - firstUsed) / :timeGroupingSize) * MAX(1.0, :maxTimeGroupings - (:now - lastUsed) / :timeGroupingSize) * MAX(1.0, :agedWeight * (firstUsed < :expiryDate)) / :bucketSize , 3) AS frecency, 1 AS boundaryBonuses FROM moz_formhistory WHERE fieldname=:fieldname AND (value LIKE :valuePrefix ESCAPE '/') ORDER BY ROUND(frecency * boundaryBonuses) DESC, UPPER(value) ASC"	43	8644	201.023255813953	146	153.188723999438	201.023255813953
"UPDATE addon SET active=:active WHERE internal_id=:internal_id"	41	7703	190.878070175439	136	108.212692378241	187.878048780488
"INSERT INTO moz_hosts (id, host, type, permission, expireType, expireTime) VALUES (?1, ?2, ?3, ?4, ?5, ?6)"	38	12759	335.027777777778	163.5	673.328045123034	335.763157894737
"SELECT * FROM moz_logins WHERE (encType = :encType)"	38	12395	326.184210526316	142	470.108087356523	326.184210526316
"SELECT value, ROUND( timesUsed / MAX(1.0, (lastUsed - firstUsed) / :timeGroupingSize) * MAX(1.0, :maxTimeGroupings - (:now - lastUsed) / :timeGroupingSize) * MAX(1.0, :agedWeight * (firstUsed < :expiryDate)) / :bucketSize , 3) AS frecency, MAX(1, :prefixWeight * (value LIKE :valuePrefix ESCAPE '/') + ((value LIKE :tokenBegin0 ESCAPE '/') + (value LIKE :tokenBoundary0 ESCAPE '/')) * :boundaryWeight) AS boundaryBonuses FROM moz_formhistory WHERE fieldname=:fieldname AND (value LIKE :tokenContains0 ESCAPE '/') ORDER BY ROUND(frecency * boundaryBonuses) DESC, UPPER(value) ASC"	38	16200	421.22972972973	187	636.92257721749	426.315789473684
"SELECT b.id, k.keyword FROM moz_bookmarks b JOIN moz_keywords k ON k.id = b.keyword_id "	36	8735	242.638888888889	158.5	211.474031202453	242.638888888889
"SELECT h.id, h.url, h.title AS page_title, h.rev_host, h.visit_count, h.last_visit_date, f.url, null, null, null, null, null, null AS tags , h.frecency FROM moz_places h LEFT JOIN moz_favicons f ON h.favicon_id = f.id WHERE 1 AND hidden = 0 AND last_visit_date NOTNULL AND (( EXISTS (SELECT 1 FROM moz_historyvisits WHERE place_id = h.id AND visit_date >= :begin_time AND visit_date <= :end_time LIMIT 1) )) ORDER BY 6 DESC"	36	36735	1149.74193548387	224	4648.60270201518	1020.41666666667
"SELECT * FROM moz_logins WHERE (hostname = :hostname) AND (formSubmitURL isnull) AND (httpRealm = :httpRealm)"	34	8896	248.242424242424	149	197.551738524214	261.647058823529
"SELECT a.id, a.place_id, :anno_name, a.mime_type, a.content, a.flags, a.expiration, a.type FROM moz_anno_attributes n JOIN moz_annos a ON n.id = a.anno_attribute_id JOIN moz_places h ON h.id = a.place_id WHERE h.url = :page_url AND n.name = :anno_name"	34	7356	255.297511312217	199	160.235921046912	216.352941176471
"SELECT h.id, h.url, h.title AS page_title, h.rev_host, h.visit_count, h.last_visit_date, f.url, null, null, null, null, null, null AS tags , h.frecency FROM moz_places h LEFT JOIN moz_favicons f ON h.favicon_id = f.id WHERE 1 AND hidden = 0 AND last_visit_date NOTNULL AND (( EXISTS (SELECT 1 FROM moz_historyvisits WHERE place_id = h.id AND visit_date >= :begin_time AND visit_date <= :end_time LIMIT 1) )) ORDER BY 3 COLLATE NOCASE ASC"	34	19559	367.778333333333	290.666666666667	271.713937042864	575.264705882353
"UPDATE moz_places SET title = :page_title WHERE url = :page_url "	33	7295	230.611111111111	159	157.927119394541	221.060606060606
"DELETE FROM webappsstore2_view"	32	20239	653.25	289	1026.32735543648	632.46875
"INSERT INTO moz_historyvisits (from_visit, place_id, visit_date, visit_type, session) VALUES (:from_visit, :page_id, :visit_date, :visit_type, :session) "	29	11871	264.862962962963	224	173.16702634262	409.344827586207
"SELECT h.id, h.url, h.title AS page_title, h.rev_host, h.visit_count, h.last_visit_date, f.url, null, null, null, null, null, null AS tags , h.frecency FROM moz_places h LEFT OUTER JOIN moz_favicons f ON h.favicon_id = f.id WHERE h.hidden = 0 AND EXISTS (SELECT id FROM moz_historyvisits WHERE place_id = h.id AND visit_type NOT IN (0,4,8) LIMIT 1) AND EXISTS ( SELECT id FROM moz_historyvisits v WHERE place_id = h.id AND NOT EXISTS(SELECT id FROM moz_historyvisits WHERE from_visit = v.id AND visit_type IN (5,6)) ) ORDER BY last_visit_date DESC LIMIT 15"	29	6187	215.761111111111	152.5	152.481524971114	213.344827586207
"INSERT INTO groups (name) VALUES (:name)"	24	7132	299.782608695652	178	397.822477142956	297.166666666667
"SELECT 1 FROM moz_historyvisits "	24	11551	481.291666666667	161	1015.00072731465	481.291666666667
"SELECT * FROM moz_logins WHERE (hostname = :hostname) AND (formSubmitURL = :formSubmitURL OR formSubmitURL = '') AND (httpRealm isnull)"	23	7308	249.45	196.5	214.957149952704	317.739130434783
"SELECT value FROM engine_data WHERE engineid = :engineid AND name = :name"	23	4305	185	135	92.1101824679862	187.173913043478
"DELETE FROM webappsstore2_temp WHERE scope = :scope;"	21	4143	190.739285714286	158	97.9197752058981	197.285714285714
"DELETE FROM moz_formhistory WHERE id = :id"	20	2939	164.112433862434	138.428571428571	64.3210934147973	146.95
"SELECT null, 'place:folder=' || id || '&queryType=1&type=7', title, null, null, null, null, null, null, dateAdded, lastModified, null, null FROM moz_bookmarks WHERE parent = 4 ORDER BY 11 DESC LIMIT 10 "	20	5626	375.922619047619	204.5	339.738441424207	281.3
"UPDATE moz_downloads SET autoResume = :autoResume WHERE state = :notStarted OR state = :queued OR state = :downloading"	20	5636	281.8	180.5	317.523078315826	281.8
"INSERT INTO moz_disabledHosts (hostname) VALUES (:hostname)"	18	2728	150.733333333333	141	37.7008273245082	151.555555555556
"SELECT id, target, name, source, state, startTime, endTime, referrer, currBytes, maxBytes, state IN (?1, ?2, ?3, ?4, ?5) isActive FROM moz_downloads ORDER BY isActive DESC, endTime DESC, startTime DESC"	17	21546	1563.17307692308	367	3336.27718451616	1267.41176470588
"DELETE FROM moz_logins WHERE id = :id"	15	2040	144.083333333333	135	38.7132890620262	136
"DELETE FROM engine_data WHERE engineid = :engineid AND name = :name"	14	5006	357.571428571429	217.5	370.052951363973	357.571428571429
"INSERT INTO settings (name) VALUES (:name)"	13	5475	310.541666666667	116.5	492.421726974927	421.153846153846
"INSERT OR REPLACE INTO webappsstore2_temp(scope, key, value, secure) VALUES (:scope, :key, :value, :secure)"	13	1603364	145730.545454545	150	482326.728974948	123335.692307692
"SELECT h.id, h.url, h.title AS page_title, h.rev_host, h.visit_count, h.last_visit_date, f.url, null, null, null, null, null, (SELECT GROUP_CONCAT(t_t.title, ',') FROM moz_bookmarks b_t JOIN moz_bookmarks t_t ON t_t.id = +b_t.parent WHERE b_t.fk = h.id AND t_t.parent = 4 ) AS tags , h.frecency FROM moz_places h LEFT JOIN moz_favicons f ON h.favicon_id = f.id WHERE 1 AND hidden = 0 AND last_visit_date NOTNULL AND (( AUTOCOMPLETE_MATCH( :search_string , h.url, page_title, tags, 0, 0, 0, 0, 4, 0) )) ORDER BY 6 DESC"	13	2938	214.628571428571	223.6	24.4122251073899	226
"SELECT n.name FROM moz_anno_attributes n JOIN moz_items_annos a ON a.anno_attribute_id = n.id WHERE a.item_id = :item_id"	13	2639	215.363636363636	183	106.104922343191	203
"PRAGMA user_version"	12	4322	360.166666666667	161.5	446.011788130667	360.166666666667
"SELECT value, ROUND( timesUsed / MAX(1.0, (lastUsed - firstUsed) / :timeGroupingSize) * MAX(1.0, :maxTimeGroupings - (:now - lastUsed) / :timeGroupingSize) * MAX(1.0, :agedWeight * (firstUsed < :expiryDate)) / :bucketSize , 3) AS frecency, 1 AS boundaryBonuses FROM moz_formhistory WHERE fieldname=:fieldname ORDER BY ROUND(frecency * boundaryBonuses) DESC, UPPER(value) ASC"	12	3113	259.416666666667	275.5	104.831863939213	259.416666666667
"SELECT (SELECT title FROM moz_places WHERE favicon_id = s.favicon_id AND visit_count > 0 AND hidden = 0 ORDER BY frecency DESC LIMIT 1) AS _title, (SELECT url FROM moz_places WHERE favicon_id = s.favicon_id AND visit_count > 0 AND hidden = 0 ORDER BY frecency DESC LIMIT 1) AS _url FROM moz_places s WHERE favicon_id IS NOT NULL AND frecency != 0 AND visit_count > 0 AND hidden = 0 GROUP BY favicon_id ORDER BY MAX(frecency) DESC LIMIT ?"	11	3698	473.983333333333	197.2	537.529558102002	336.181818181818
"SELECT h.id, h.url, h.title AS page_title, h.rev_host, h.visit_count, h.last_visit_date, f.url, null, null, null, null, null, null AS tags , h.frecency FROM moz_places h LEFT JOIN moz_favicons f ON h.favicon_id = f.id WHERE 1 AND hidden = 0 AND last_visit_date NOTNULL AND (( h.url = :uri )) ORDER BY h.id ASC "	11	1818	162.053571428571	159.857142857143	14.8504306037113	165.272727272727
"SELECT place_id FROM moz_historyvisits WHERE :from_date <= visit_date AND visit_date <= :to_date EXCEPT SELECT place_id FROM moz_historyvisits WHERE visit_date < :from_date OR :to_date < visit_date"	11	2727	221	149	135.416641025639	247.909090909091
"SELECT DISTINCT location FROM addon"	10	2231	223.1	179.5	113.479758351679	223.1
"SELECT name, value, host, path, expiry, lastAccessed, creationTime, isSecure, isHttpOnly, baseDomain FROM moz_cookies WHERE baseDomain NOTNULL"	10	1853	167.75	173	46.3203518984906	185.3
"DELETE FROM moz_disabledHosts WHERE hostname = :hostname"	9	1473	157.166666666667	156.5	11.5144836329439	163.666666666667
"INSERT INTO prefs (groupID, settingID, value) VALUES (:groupID, :settingID, :value)"	9	1798	199.777777777778	105	155.513486374798	199.777777777778
"SELECT (SELECT url FROM moz_places WHERE id = :page_id) FROM moz_bookmarks b WHERE b.fk = :page_id UNION ALL SELECT (SELECT url FROM moz_places WHERE id = COALESCE(greatgrandparent.place_id, grandparent.place_id, parent.place_id) ) FROM moz_historyvisits self JOIN moz_bookmarks b ON b.fk = COALESCE(greatgrandparent.place_id, grandparent.place_id, parent.place_id) LEFT JOIN moz_historyvisits parent ON parent.id = self.from_visit LEFT JOIN moz_historyvisits grandparent ON parent.from_visit = grandparent.id AND parent.visit_type IN (5,6) LEFT JOIN moz_historyvisits greatgrandparent ON grandparent.from_visit = greatgrandparent.id AND grandparent.visit_type IN (5,6) WHERE self.visit_type IN (5,6) AND self.place_id = :page_id LIMIT 1 "	9	11100	909.285714285714	276	1001.30522557405	1233.33333333333
"SELECT count(*), (SELECT guid FROM moz_bookmarks WHERE id = :parent), (SELECT parent FROM moz_bookmarks WHERE id = :parent) FROM moz_bookmarks WHERE parent = :parent"	9	24861	2098.25	142	3934.54735854922	2762.33333333333
"DELETE FROM moz_formhistory WHERE fieldname = :fieldname"	8	1101	135.333333333333	135.5	22.2261107708929	137.625
"PRAGMA cache_size"	8	2100	262.5	177	244.897646258303	262.5
"SELECT ( SELECT url FROM moz_favicons WHERE id = s.favicon_id LIMIT 1 ) AS _favicon, ( SELECT title FROM moz_places WHERE favicon_id = s.favicon_id AND visit_count > 0 AND hidden = 0 ORDER BY frecency DESC LIMIT 1 ) AS _title, ( SELECT url FROM moz_places WHERE favicon_id = s.favicon_id AND visit_count > 0 AND hidden = 0 ORDER BY frecency DESC LIMIT 1) AS _url FROM moz_places s WHERE favicon_id IS NOT NULL AND frecency != 0 AND visit_count > 0 AND hidden = 0 GROUP BY favicon_id ORDER BY MAX(frecency) DESC LIMIT ?"	8	1705	297.75	192.75	270.576082953883	213.125
"SELECT b.fk, h.url, COALESCE(b.title, h.title), h.rev_host, h.visit_count, h.last_visit_date, f.url, null, b.id, b.dateAdded, b.lastModified, b.parent, (SELECT GROUP_CONCAT(t_t.title, ',') FROM moz_bookmarks b_t JOIN moz_bookmarks t_t ON t_t.id = +b_t.parent WHERE b_t.fk = h.id AND t_t.parent = 4 ) AS tags , h.frecency FROM moz_bookmarks b JOIN moz_places h ON b.fk = h.id LEFT JOIN moz_favicons f ON h.favicon_id = f.id WHERE b.id = :item_id "	8	1399	179.5	156.5	69.1339279948709	174.875
"SELECT h.id, (SELECT id FROM moz_anno_attributes WHERE name = :anno_name) AS nameid, a.id, a.dateAdded FROM moz_places h LEFT JOIN moz_annos a ON a.place_id = h.id AND a.anno_attribute_id = nameid WHERE h.url = :page_url"	8	1211	151.375	154	30.1990420850918	151.375
"SELECT id, parent FROM moz_bookmarks WHERE fk = (SELECT id FROM moz_places WHERE url = :page_url)"	8	1372	173.222222222222	169.666666666667	64.680983523982	171.5
"DELETE FROM moz_formhistory WHERE firstUsed >= :beginTime AND firstUsed <= :endTime"	7	1114	160.583333333333	157.75	22.1955325835328	159.142857142857
"SELECT * FROM moz_logins WHERE (hostname = :hostname) AND (httpRealm = :httpRealm)"	6	984	167.6	171	44.4893245621913	164
"SELECT id, fk, type FROM moz_bookmarks WHERE parent = :parent AND position = :item_index"	6	1193	180.9	142	68.9604959378919	198.833333333333
"SELECT id, guid FROM moz_bookmarks ORDER BY ROWID DESC LIMIT 1"	6	1924	320.666666666667	221.5	178.755326260972	320.666666666667
"SELECT id, minVersion, maxVersion FROM targetApplication WHERE addon_internal_id=:internal_id"	6	853	142.166666666667	133	40.1617562696985	142.166666666667
"UPDATE moz_bookmarks SET title = :item_title, lastModified = :date WHERE id = :item_id "	6	1163	183.5	198.25	43.1451040096092	193.833333333333
"UPDATE prefs SET value = :value WHERE id = :id"	6	1494	248	254	140.158838465507	249
"SELECT * FROM moz_logins WHERE (guid = :guid)"	5	1753	390	339	288.082164205515	350.6
"SELECT COUNT(*) FROM moz_downloads WHERE state = ? OR state = ? OR state = ? OR state = ? OR state = ? OR state = ?"	5	646	129.2	129.2	NA	129.2
"SELECT id, host, type, permission, expireType, expireTime FROM moz_hosts"	5	725	148.111111111111	140.333333333333	48.470304005343	145
"SELECT value, ROUND( timesUsed / MAX(1.0, (lastUsed - firstUsed) / :timeGroupingSize) * MAX(1.0, :maxTimeGroupings - (:now - lastUsed) / :timeGroupingSize) * MAX(1.0, :agedWeight * (firstUsed < :expiryDate)) / :bucketSize , 3) AS frecency, MAX(1, :prefixWeight * (value LIKE :valuePrefix ESCAPE '/') + ((value LIKE :tokenBegin0 ESCAPE '/') + (value LIKE :tokenBoundary0 ESCAPE '/') + (value LIKE :tokenBegin1 ESCAPE '/') + (value LIKE :tokenBoundary1 ESCAPE '/')) * :boundaryWeight) AS boundaryBonuses FROM moz_formhistory WHERE fieldname=:fieldname AND (value LIKE :tokenContains0 ESCAPE '/') AND (value LIKE :tokenContains1 ESCAPE '/') ORDER BY ROUND(frecency * boundaryBonuses) DESC, UPPER(value) ASC"	5	1891	378.2	182	305.130627764569	378.2
"DELETE FROM moz_logins"	4	6450	1612.5	589	2391.99909420273	1612.5
"SELECT 1 FROM moz_places h WHERE url = ?1 AND last_visit_date NOTNULL "	4	1289	304.5	375.5	170.475071491406	322.25
"SELECT b.fk, h.url, COALESCE(b.title, h.title) AS page_title, h.rev_host, h.visit_count, h.last_visit_date, f.url, null, b.id, b.dateAdded, b.lastModified, b.parent, (SELECT GROUP_CONCAT(t_t.title, ',') FROM moz_bookmarks b_t JOIN moz_bookmarks t_t ON t_t.id = +b_t.parent WHERE b_t.fk = b.fk AND t_t.parent = 4 ) AS tags , h.frecency FROM moz_bookmarks b JOIN moz_places h ON b.fk = h.id LEFT OUTER JOIN moz_favicons f ON h.favicon_id = f.id WHERE NOT EXISTS (SELECT id FROM moz_bookmarks WHERE id = b.parent AND parent = 4) AND (( AUTOCOMPLETE_MATCH( :search_string , h.url, page_title, tags, 0, 0, 0, 0, 4, 0) )) ORDER BY 3 COLLATE NOCASE DESC"	4	1159	289.75	243	181.345664409161	289.75
"UPDATE addon SET active=MIN(visible, 1 - userDisabled, 1 - softDisabled, 1 - appDisabled, 1 - pendingUninstall)"	4	1275	318.75	227	253.827205003719	318.75
"/* do not warn (bug 487594) */ SELECT GROUP_CONCAT(tag_title, ', ') FROM ( SELECT t.title AS tag_title FROM moz_bookmarks b JOIN moz_bookmarks t ON t.id = +b.parent WHERE b.fk = (SELECT id FROM moz_places WHERE url = :page_url) AND t.parent = :tags_folder ORDER BY t.title COLLATE NOCASE ASC ) "	3	909	303	392	166.424156900373	303
"DELETE FROM moz_cache_namespaces;"	3	667	222.333333333333	157	156.580117937538	222.333333333333
"DELETE FROM webappsstore2_view WHERE scope NOT IN (SELECT DISTINCT scope FROM webappsstore2_temp WHERE scope GLOB :scope0 UNION SELECT DISTINCT scope FROM webappsstore2 WHERE scope GLOB :scope0);"	3	1063	354.333333333333	107	431.862632480901	354.333333333333
"INSERT INTO addon VALUES (NULL, :id, :syncGUID, :location, :version, :type, :internalName, :updateURL, :updateKey, :optionsURL, :optionsType, :aboutURL, :iconURL, :icon64URL, :locale, :visible, :active, :userDisabled, :appDisabled, :pendingUninstall, :descriptor, :installDate, :updateDate, :applyBackgroundUpdates, :bootstrap, :skinnable, :size, :sourceURI, :releaseNotesURI, :softDisabled, :isForeignInstall, :hasBinaryComponents, :strictCompatibility)"	3	749	249.666666666667	177	185.030628095279	249.666666666667
"INSERT INTO locale_strings VALUES (:locale, :type, :value)"	3	1018	339.333333333333	339	98.500423010936	339.333333333333
"SELECT COUNT(1) AS numLogins FROM moz_logins WHERE (hostname = :hostname) AND (formSubmitURL isnull) AND (httpRealm = :httpRealm)"	3	429	143	155	37.4699879903904	143
"SELECT COUNT(1) AS numLogins FROM moz_logins WHERE (hostname isnull) AND (httpRealm isnull)"	3	659	219.666666666667	177	88.1211287565776	219.666666666667
"SELECT hostname FROM moz_disabledHosts"	3	419	139.666666666667	134	42.7823951332009	139.666666666667
"SELECT id FROM moz_downloads WHERE (state = :state AND LENGTH(entityID) > 0) OR autoResume != :autoResume"	3	643	214.333333333333	235	52.1664004253057	214.333333333333
"SELECT id, visit_count, typed, hidden, guid FROM moz_places WHERE url = :page_url "	3	371	120.25	120.25	14.4956890143242	123.666666666667
"SELECT n.name FROM moz_anno_attributes n JOIN moz_annos a ON a.anno_attribute_id = n.id JOIN moz_places h ON h.id = a.place_id WHERE h.url = :page_url"	3	595	198.333333333333	168	90.4009586969814	198.333333333333
"SELECT prefs.value AS value FROM prefs JOIN groups ON prefs.groupID = groups.id JOIN settings ON prefs.settingID = settings.id WHERE groups.name = :group AND settings.name = :setting"	3	3457	1152.33333333333	316	1605.19355011579	1152.33333333333
"UPDATE moz_downloads SET autoResume = :autoResume WHERE state = :state AND autoResume = :autoResume_cond"	3	640	213.333333333333	239	56.0921860274079	213.333333333333
"PRAGMA journal_mode = wal"	2	460	230	230	87.6812408671319	230
"SELECT COUNT(1) AS numLogins FROM moz_logins"	2	242	121	121	19.7989898732233	121
"SELECT b.fk, h.url, COALESCE(b.title, h.title) AS page_title, h.rev_host, h.visit_count, h.last_visit_date, f.url, null, b.id, b.dateAdded, b.lastModified, b.parent, null AS tags , h.frecency FROM moz_bookmarks b JOIN moz_places h ON b.fk = h.id LEFT OUTER JOIN moz_favicons f ON h.favicon_id = f.id WHERE NOT EXISTS (SELECT id FROM moz_bookmarks WHERE id = b.parent AND parent = 4) ORDER BY b.id ASC "	2	223	111.5	111.5	6.36396103067893	111.5
"SELECT h.id FROM moz_places h WHERE EXISTS (SELECT id FROM moz_historyvisits v WHERE v.place_id = h.id AND v.visit_date >= :from_date AND v.visit_date <= :to_date LIMIT 1)"	2	329	164.5	164.5	NA	164.5
"SELECT h.id, h.url, h.title AS page_title, h.rev_host, h.visit_count, v.visit_date, f.url, v.session, null, null, null, null, null AS tags , h.frecency FROM moz_places h JOIN moz_historyvisits v ON h.id = v.place_id LEFT JOIN moz_favicons f ON h.favicon_id = f.id WHERE 1 AND EXISTS ( SELECT id FROM moz_historyvisits v WHERE place_id = h.id AND NOT EXISTS(SELECT id FROM moz_historyvisits WHERE from_visit = v.id AND visit_type IN (5,6)) ) AND hidden = 0 AND last_visit_date NOTNULL AND (( EXISTS (SELECT 1 FROM moz_historyvisits WHERE place_id = h.id AND visit_date >= :begin_time AND visit_date <= :end_time LIMIT 1) )) ORDER BY 6 DESC LIMIT 100 "	2	846	423	423	NA	423
"SELECT id FROM prefs WHERE groupID = :groupID AND settingID = :settingID"	2	512	256	256	162.634559672906	256
"SELECT id FROM settings WHERE name = :name"	2	1008	504	504	336.582827844797	504
"SELECT null, 'place:type=0&sort=1&domain=&domainIsHost=true'||'&beginTime='||:begin_time||'&endTime='||:end_time, :localhost, :localhost, null, null, null, null, null, null, null WHERE EXISTS ( SELECT h.id FROM moz_places h JOIN moz_historyvisits v ON v.place_id = h.id WHERE h.hidden = 0 AND h.visit_count > 0 AND h.url BETWEEN 'file://' AND 'file:/~' AND hidden = 0 AND last_visit_date NOTNULL AND (( EXISTS (SELECT 1 FROM moz_historyvisits WHERE place_id = h.id AND visit_date >= :begin_time AND visit_date <= :end_time LIMIT 1) )) LIMIT 1 ) UNION ALL SELECT null, 'place:type=0&sort=1&domain='||host||'&domainIsHost=true'||'&beginTime='||:begin_time||'&endTime='||:end_time, host, host, null, null, null, null, null, null, null FROM ( SELECT get_unreversed_host(h.rev_host) AS host FROM moz_places h JOIN moz_historyvisits v ON v.place_id = h.id WHERE h.hidden = 0 AND h.rev_host <> '.' AND h.visit_count > 0 AND hidden = 0 AND last_visit_date NOTNULL AND (( EXISTS (SELECT 1 FROM moz_historyvisits WHERE place_id = h.id AND visit_date >= :begin_time AND visit_date <= :end_time LIMIT 1) )) GROUP BY h.rev_host ORDER BY host ASC ) ORDER BY 3 COLLATE NOCASE ASC"	2	273	136.5	136.5	NA	136.5
"SELECT null, 'place:type=0&sort=4&beginTime='||beginTime||'&endTime='||endTime, dayTitle, null, null, beginTime, null, null, null, null, null, null FROM (SELECT :dayTitle0 AS dayTitle, (strftime('%s','now','localtime','start of day','utc')*1000000) AS beginTime, (strftime('%s','now','localtime','start of day','+1 day','utc')*1000000) AS endTime WHERE EXISTS ( SELECT id FROM moz_historyvisits WHERE visit_date >= (strftime('%s','now','localtime','start of day','utc')*1000000) AND visit_date < (strftime('%s','now','localtime','start of day','+1 day','utc')*1000000) AND visit_type NOT IN (0,4,8) LIMIT 1 ) UNION ALL SELECT :dayTitle1 AS dayTitle, (strftime('%s','now','localtime','start of day','-1 day','utc')*1000000) AS beginTime, (strftime('%s','now','localtime','start of day','utc')*1000000) AS endTime WHERE EXISTS ( SELECT id FROM moz_historyvisits WHERE visit_date >= (strftime('%s','now','localtime','start of day','-1 day','utc')*1000000) AND visit_date < (strftime('%s','now','localtime','start of day','utc')*1000000) AND visit_type NOT IN (0,4,8) LIMIT 1 ) UNION ALL SELECT :dayTitle2 AS dayTitle, (strftime('%s','now','localtime','start of day','-7 days','utc')*1000000) AS beginTime, (strftime('%s','now','localtime','start of day','+1 day','utc')*1000000) AS endTime WHERE EXISTS ( SELECT id FROM moz_historyvisits WHERE visit_date >= (strftime('%s','now','localtime','start of day','-7 days','utc')*1000000) AND visit_date < (strftime('%s','now','localtime','start of day','-2 days','utc')*1000000) AND visit_type NOT IN (0,4,8) LIMIT 1 ) UNION ALL SELECT :dayTitle3 AS dayTitle, (strftime('%s','now','localtime','start of month','utc')*1000000) AS beginTime, (strftime('%s','now','localtime','start of day','+1 day','utc')*1000000) AS endTime WHERE EXISTS ( SELECT id FROM moz_historyvisits WHERE visit_date >= (strftime('%s','now','localtime','start of month','utc')*1000000) AND visit_date < (strftime('%s','now','localtime','start of day','-7 days','utc')*1000000) AND visit_type NOT IN (0,4,8) LIMIT 1 ) UNION ALL SELECT :dayTitle4 AS dayTitle, (strftime('%s','now','localtime','start of month','-1 months','utc')*1000000) AS beginTime, (strftime('%s','now','localtime','start of month','-0 months','utc')*1000000) AS endTime WHERE EXISTS ( SELECT id FROM moz_historyvisits WHERE visit_date >= (strftime('%s','now','localtime','start of month','-1 months','utc')*1000000) AND visit_date < (strftime('%s','now','localtime','start of month','-0 months','utc')*1000000) AND visit_type NOT IN (0,4,8) LIMIT 1 ) UNION ALL SELECT :dayTitle5 AS dayTitle, (strftime('%s','now','localtime','start of month','-2 months','utc')*1000000) AS beginTime, (strftime('%s','now','localtime','start of month','-1 months','utc')*1000000) AS endTime WHERE EXISTS ( SELECT id FROM moz_historyvisits WHERE visit_date >= (strftime('%s','now','localtime','start of month','-2 months','utc')*1000000) AND visit_date < (strftime('%s','now','localtime','start of month','-1 months','utc')*1000000) AND visit_type NOT IN (0,4,8) LIMIT 1 ) UNION ALL SELECT :dayTitle6 AS dayTitle, (strftime('%s','now','localtime','start of month','-3 months','utc')*1000000) AS beginTime, (strftime('%s','now','localtime','start of month','-2 months','utc')*1000000) AS endTime WHERE EXISTS ( SELECT id FROM moz_historyvisits WHERE visit_date >= (strftime('%s','now','localtime','start of month','-3 months','utc')*1000000) AND visit_date < (strftime('%s','now','localtime','start of month','-2 months','utc')*1000000) AND visit_type NOT IN (0,4,8) LIMIT 1 ) UNION ALL SELECT :dayTitle7 AS dayTitle, (strftime('%s','now','localtime','start of month','-4 months','utc')*1000000) AS beginTime, (strftime('%s','now','localtime','start of month','-3 months','utc')*1000000) AS endTime WHERE EXISTS ( SELECT id FROM moz_historyvisits WHERE visit_date >= (strftime('%s','now','localtime','start of month','-4 months','utc')*1000000) AND visit_date < (strftime('%s','now','localtime','start of month','-3 months','utc')*1000000) AND visit_type NOT IN (0,4,8) LIMIT 1 ) UNION ALL SELECT :dayTitle8 AS dayTitle, (strftime('%s','now','localtime','start of month','-5 months','utc')*1000000) AS beginTime, (strftime('%s','now','localtime','start of month','-4 months','utc')*1000000) AS endTime WHERE EXISTS ( SELECT id FROM moz_historyvisits WHERE visit_date >= (strftime('%s','now','localtime','start of month','-5 months','utc')*1000000) AND visit_date < (strftime('%s','now','localtime','start of month','-4 months','utc')*1000000) AND visit_type NOT IN (0,4,8) LIMIT 1 ) UNION ALL SELECT :dayTitle9 AS dayTitle, (datetime(0, 'unixepoch')*1000000) AS beginTime, (strftime('%s','now','localtime','start of month','-5 months','utc')*1000000) AS endTime WHERE EXISTS ( SELECT id FROM moz_historyvisits WHERE visit_date >= (datetime(0, 'unixepoch')*1000000) AND visit_date < (strftime('%s','now','localtime','start of month','-5 months','utc')*1000000) AND visit_type NOT IN (0,4,8) LIMIT 1 ) ) "	2	1351	675.5	675.5	668.215908221287	675.5
"SELECT value, secure FROM webappsstore2_temp WHERE scope = :scope AND key = :key"	2	953	476.5	476.5	95.4594154601839	476.5
"UPDATE moz_favicons SET guid = COALESCE(:guid, guid), data = :data, mime_type = :mime_type, expiration = :expiration WHERE id = :icon_id"	2	310	155	155	NA	155
"UPDATE targetApplication SET minVersion=:minVersion, maxVersion=:maxVersion WHERE addon_internal_id=:internal_id AND id=:id"	2	254	127	127	33.9411254969543	127
"DELETE FROM moz_bookmarks WHERE id = :item_id"	1	124	124	124	NA	124
"DELETE FROM moz_historyvisits WHERE :from_date <= visit_date AND visit_date <= :to_date"	1	129	129	129	NA	129
"DELETE FROM moz_hosts WHERE id = ?1"	1	541	541	541	NA	541
"INSERT INTO targetApplication VALUES (:internal_id, :id, :minVersion, :maxVersion)"	1	103	103	103	NA	103
"INSERT INTO targetPlatform VALUES (:internal_id, :os, :abi)"	1	109	109	109	NA	109
"PRAGMA temp_store"	1	149	149	149	NA	149
"SELECT ClientID, ItemType FROM moz_cache WHERE Key = ? ORDER BY LastFetched DESC, LastModified DESC;"	1	340	340	340	NA	340
"SELECT GroupID, ActiveClientID FROM moz_cache_groups;"	1	1592	1592	1592	NA	1592
"SELECT f.data, f.mime_type FROM moz_favicons f WHERE url = :icon_url"	1	110	110	110	NA	110
"SELECT h.id, h.url, h.title AS page_title, h.rev_host, h.visit_count, h.last_visit_date, f.url, null, null, null, null, null, null AS tags , h.frecency FROM moz_places h LEFT JOIN moz_favicons f ON h.favicon_id = f.id WHERE 1 AND hidden = 0 AND last_visit_date NOTNULL AND (( EXISTS (SELECT 1 FROM moz_historyvisits WHERE place_id = h.id AND visit_date >= :begin_time AND visit_date <= :end_time LIMIT 1) AND h.rev_host >= :domain_lower AND h.rev_host < :domain_upper )) ORDER BY 6 DESC"	1	240	240	240	NA	240
"SELECT internal_id, id, syncGUID, location, version, type, internalName, updateURL, updateKey, optionsURL, optionsType, aboutURL, iconURL, icon64URL, defaultLocale, visible, active, userDisabled, appDisabled, pendingUninstall, descriptor, installDate, updateDate, applyBackgroundUpdates, bootstrap, skinnable, size, sourceURI, releaseNotesURI, softDisabled, isForeignInstall, hasBinaryComponents, strictCompatibility FROM addon WHERE active=1 AND type<>'theme' AND bootstrap=0"	1	111	111	111	NA	111
"SELECT key, value, secure FROM webappsstore2_temp WHERE scope = :scope"	1	499	499	499	NA	499
"SELECT name FROM sqlite_master WHERE type = 'table' AND name ='moz_downloads'"	1	362	362	362	NA	362
"SELECT ns.ClientID, ns.ItemType FROM moz_cache_namespaces AS ns JOIN moz_cache_groups AS groups ON ns.ClientID = groups.ActiveClientID WHERE ns.NameSpace <= ?1 AND ?1 GLOB ns.NameSpace || '*' ORDER BY ns.NameSpace DESC, groups.ActivateTimeStamp DESC;"	1	126	126	126	NA	126
"SELECT null, 'place:type=0&sort=1&beginTime='||beginTime||'&endTime='||endTime, dayTitle, null, null, beginTime, null, null, null, null, null, null FROM (SELECT :dayTitle0 AS dayTitle, (strftime('%s','now','localtime','start of day','utc')*1000000) AS beginTime, (strftime('%s','now','localtime','start of day','+1 day','utc')*1000000) AS endTime WHERE EXISTS ( SELECT id FROM moz_historyvisits WHERE visit_date >= (strftime('%s','now','localtime','start of day','utc')*1000000) AND visit_date < (strftime('%s','now','localtime','start of day','+1 day','utc')*1000000) AND visit_type NOT IN (0,4,8) LIMIT 1 ) UNION ALL SELECT :dayTitle1 AS dayTitle, (strftime('%s','now','localtime','start of day','-1 day','utc')*1000000) AS beginTime, (strftime('%s','now','localtime','start of day','utc')*1000000) AS endTime WHERE EXISTS ( SELECT id FROM moz_historyvisits WHERE visit_date >= (strftime('%s','now','localtime','start of day','-1 day','utc')*1000000) AND visit_date < (strftime('%s','now','localtime','start of day','utc')*1000000) AND visit_type NOT IN (0,4,8) LIMIT 1 ) UNION ALL SELECT :dayTitle2 AS dayTitle, (strftime('%s','now','localtime','start of day','-7 days','utc')*1000000) AS beginTime, (strftime('%s','now','localtime','start of day','+1 day','utc')*1000000) AS endTime WHERE EXISTS ( SELECT id FROM moz_historyvisits WHERE visit_date >= (strftime('%s','now','localtime','start of day','-7 days','utc')*1000000) AND visit_date < (strftime('%s','now','localtime','start of day','-2 days','utc')*1000000) AND visit_type NOT IN (0,4,8) LIMIT 1 ) UNION ALL SELECT :dayTitle3 AS dayTitle, (strftime('%s','now','localtime','start of month','utc')*1000000) AS beginTime, (strftime('%s','now','localtime','start of day','+1 day','utc')*1000000) AS endTime WHERE EXISTS ( SELECT id FROM moz_historyvisits WHERE visit_date >= (strftime('%s','now','localtime','start of month','utc')*1000000) AND visit_date < (strftime('%s','now','localtime','start of day','-7 days','utc')*1000000) AND visit_type NOT IN (0,4,8) LIMIT 1 ) UNION ALL SELECT :dayTitle4 AS dayTitle, (strftime('%s','now','localtime','start of month','-1 months','utc')*1000000) AS beginTime, (strftime('%s','now','localtime','start of month','-0 months','utc')*1000000) AS endTime WHERE EXISTS ( SELECT id FROM moz_historyvisits WHERE visit_date >= (strftime('%s','now','localtime','start of month','-1 months','utc')*1000000) AND visit_date < (strftime('%s','now','localtime','start of month','-0 months','utc')*1000000) AND visit_type NOT IN (0,4,8) LIMIT 1 ) ) "	1	192	192	192	NA	192
"SELECT null, 'place:type=0&sort=1&domain=&domainIsHost=true', :localhost, :localhost, null, null, null, null, null, null, null WHERE EXISTS ( SELECT h.id FROM moz_places h WHERE h.hidden = 0 AND h.visit_count > 0 AND h.url BETWEEN 'file://' AND 'file:/~' LIMIT 1 ) UNION ALL SELECT null, 'place:type=0&sort=1&domain='||host||'&domainIsHost=true', host, host, null, null, null, null, null, null, null FROM ( SELECT get_unreversed_host(h.rev_host) AS host FROM moz_places h WHERE h.hidden = 0 AND h.rev_host <> '.' AND h.visit_count > 0 GROUP BY h.rev_host ORDER BY host ASC ) ORDER BY 3 COLLATE NOCASE ASC"	1	228	228	228	NA	228
"SELECT null, 'place:type=0&sort=4&beginTime='||beginTime||'&endTime='||endTime, dayTitle, null, null, beginTime, null, null, null, null, null, null FROM (SELECT :dayTitle0 AS dayTitle, (strftime('%s','now','localtime','start of day','utc')*1000000) AS beginTime, (strftime('%s','now','localtime','start of day','+1 day','utc')*1000000) AS endTime WHERE EXISTS ( SELECT id FROM moz_historyvisits WHERE visit_date >= (strftime('%s','now','localtime','start of day','utc')*1000000) AND visit_date < (strftime('%s','now','localtime','start of day','+1 day','utc')*1000000) AND visit_type NOT IN (0,4,8) LIMIT 1 ) UNION ALL SELECT :dayTitle1 AS dayTitle, (strftime('%s','now','localtime','start of day','-1 day','utc')*1000000) AS beginTime, (strftime('%s','now','localtime','start of day','utc')*1000000) AS endTime WHERE EXISTS ( SELECT id FROM moz_historyvisits WHERE visit_date >= (strftime('%s','now','localtime','start of day','-1 day','utc')*1000000) AND visit_date < (strftime('%s','now','localtime','start of day','utc')*1000000) AND visit_type NOT IN (0,4,8) LIMIT 1 ) UNION ALL SELECT :dayTitle2 AS dayTitle, (strftime('%s','now','localtime','start of day','-7 days','utc')*1000000) AS beginTime, (strftime('%s','now','localtime','start of day','+1 day','utc')*1000000) AS endTime WHERE EXISTS ( SELECT id FROM moz_historyvisits WHERE visit_date >= (strftime('%s','now','localtime','start of day','-7 days','utc')*1000000) AND visit_date < (strftime('%s','now','localtime','start of day','-2 days','utc')*1000000) AND visit_type NOT IN (0,4,8) LIMIT 1 ) UNION ALL SELECT :dayTitle3 AS dayTitle, (strftime('%s','now','localtime','start of month','utc')*1000000) AS beginTime, (strftime('%s','now','localtime','start of day','+1 day','utc')*1000000) AS endTime WHERE EXISTS ( SELECT id FROM moz_historyvisits WHERE visit_date >= (strftime('%s','now','localtime','start of month','utc')*1000000) AND visit_date < (strftime('%s','now','localtime','start of day','-7 days','utc')*1000000) AND visit_type NOT IN (0,4,8) LIMIT 1 ) UNION ALL SELECT :dayTitle4 AS dayTitle, (strftime('%s','now','localtime','start of month','-1 months','utc')*1000000) AS beginTime, (strftime('%s','now','localtime','start of month','-0 months','utc')*1000000) AS endTime WHERE EXISTS ( SELECT id FROM moz_historyvisits WHERE visit_date >= (strftime('%s','now','localtime','start of month','-1 months','utc')*1000000) AND visit_date < (strftime('%s','now','localtime','start of month','-0 months','utc')*1000000) AND visit_type NOT IN (0,4,8) LIMIT 1 ) UNION ALL SELECT :dayTitle5 AS dayTitle, (strftime('%s','now','localtime','start of month','-2 months','utc')*1000000) AS beginTime, (strftime('%s','now','localtime','start of month','-1 months','utc')*1000000) AS endTime WHERE EXISTS ( SELECT id FROM moz_historyvisits WHERE visit_date >= (strftime('%s','now','localtime','start of month','-2 months','utc')*1000000) AND visit_date < (strftime('%s','now','localtime','start of month','-1 months','utc')*1000000) AND visit_type NOT IN (0,4,8) LIMIT 1 ) ) "	1	109	109	109	NA	109
"SELECT null, 'place:type=0&sort=4&beginTime='||beginTime||'&endTime='||endTime, dayTitle, null, null, beginTime, null, null, null, null, null, null FROM (SELECT :dayTitle0 AS dayTitle, (strftime('%s','now','localtime','start of day','utc')*1000000) AS beginTime, (strftime('%s','now','localtime','start of day','+1 day','utc')*1000000) AS endTime WHERE EXISTS ( SELECT id FROM moz_historyvisits WHERE visit_date >= (strftime('%s','now','localtime','start of day','utc')*1000000) AND visit_date < (strftime('%s','now','localtime','start of day','+1 day','utc')*1000000) AND visit_type NOT IN (0,4,8) LIMIT 1 ) UNION ALL SELECT :dayTitle1 AS dayTitle, (strftime('%s','now','localtime','start of day','-1 day','utc')*1000000) AS beginTime, (strftime('%s','now','localtime','start of day','utc')*1000000) AS endTime WHERE EXISTS ( SELECT id FROM moz_historyvisits WHERE visit_date >= (strftime('%s','now','localtime','start of day','-1 day','utc')*1000000) AND visit_date < (strftime('%s','now','localtime','start of day','utc')*1000000) AND visit_type NOT IN (0,4,8) LIMIT 1 ) UNION ALL SELECT :dayTitle2 AS dayTitle, (strftime('%s','now','localtime','start of day','-7 days','utc')*1000000) AS beginTime, (strftime('%s','now','localtime','start of day','+1 day','utc')*1000000) AS endTime WHERE EXISTS ( SELECT id FROM moz_historyvisits WHERE visit_date >= (strftime('%s','now','localtime','start of day','-7 days','utc')*1000000) AND visit_date < (strftime('%s','now','localtime','start of day','-2 days','utc')*1000000) AND visit_type NOT IN (0,4,8) LIMIT 1 ) UNION ALL SELECT :dayTitle3 AS dayTitle, (strftime('%s','now','localtime','start of month','utc')*1000000) AS beginTime, (strftime('%s','now','localtime','start of day','+1 day','utc')*1000000) AS endTime WHERE EXISTS ( SELECT id FROM moz_historyvisits WHERE visit_date >= (strftime('%s','now','localtime','start of month','utc')*1000000) AND visit_date < (strftime('%s','now','localtime','start of day','-7 days','utc')*1000000) AND visit_type NOT IN (0,4,8) LIMIT 1 ) UNION ALL SELECT :dayTitle4 AS dayTitle, (strftime('%s','now','localtime','start of month','-1 months','utc')*1000000) AS beginTime, (strftime('%s','now','localtime','start of month','-0 months','utc')*1000000) AS endTime WHERE EXISTS ( SELECT id FROM moz_historyvisits WHERE visit_date >= (strftime('%s','now','localtime','start of month','-1 months','utc')*1000000) AND visit_date < (strftime('%s','now','localtime','start of month','-0 months','utc')*1000000) AND visit_type NOT IN (0,4,8) LIMIT 1 ) UNION ALL SELECT :dayTitle5 AS dayTitle, (strftime('%s','now','localtime','start of month','-2 months','utc')*1000000) AS beginTime, (strftime('%s','now','localtime','start of month','-1 months','utc')*1000000) AS endTime WHERE EXISTS ( SELECT id FROM moz_historyvisits WHERE visit_date >= (strftime('%s','now','localtime','start of month','-2 months','utc')*1000000) AND visit_date < (strftime('%s','now','localtime','start of month','-1 months','utc')*1000000) AND visit_type NOT IN (0,4,8) LIMIT 1 ) UNION ALL SELECT :dayTitle6 AS dayTitle, (strftime('%s','now','localtime','start of month','-3 months','utc')*1000000) AS beginTime, (strftime('%s','now','localtime','start of month','-2 months','utc')*1000000) AS endTime WHERE EXISTS ( SELECT id FROM moz_historyvisits WHERE visit_date >= (strftime('%s','now','localtime','start of month','-3 months','utc')*1000000) AND visit_date < (strftime('%s','now','localtime','start of month','-2 months','utc')*1000000) AND visit_type NOT IN (0,4,8) LIMIT 1 ) UNION ALL SELECT :dayTitle7 AS dayTitle, (strftime('%s','now','localtime','start of month','-4 months','utc')*1000000) AS beginTime, (strftime('%s','now','localtime','start of month','-3 months','utc')*1000000) AS endTime WHERE EXISTS ( SELECT id FROM moz_historyvisits WHERE visit_date >= (strftime('%s','now','localtime','start of month','-4 months','utc')*1000000) AND visit_date < (strftime('%s','now','localtime','start of month','-3 months','utc')*1000000) AND visit_type NOT IN (0,4,8) LIMIT 1 ) ) "	1	991	991	991	NA	991
"SELECT value, ROUND( timesUsed / MAX(1.0, (lastUsed - firstUsed) / :timeGroupingSize) * MAX(1.0, :maxTimeGroupings - (:now - lastUsed) / :timeGroupingSize) * MAX(1.0, :agedWeight * (firstUsed < :expiryDate)) / :bucketSize , 3) AS frecency, MAX(1, :prefixWeight * (value LIKE :valuePrefix ESCAPE '/') + ((value LIKE :tokenBegin0 ESCAPE '/') + (value LIKE :tokenBoundary0 ESCAPE '/') + (value LIKE :tokenBegin1 ESCAPE '/') + (value LIKE :tokenBoundary1 ESCAPE '/') + (value LIKE :tokenBegin2 ESCAPE '/') + (value LIKE :tokenBoundary2 ESCAPE '/') + (value LIKE :tokenBegin3 ESCAPE '/') + (value LIKE :tokenBoundary3 ESCAPE '/') + (value LIKE :tokenBegin4 ESCAPE '/') + (value LIKE :tokenBoundary4 ESCAPE '/') + (value LIKE :tokenBegin5 ESCAPE '/') + (value LIKE :tokenBoundary5 ESCAPE '/') + (value LIKE :tokenBegin6 ESCAPE '/') + (value LIKE :tokenBoundary6 ESCAPE '/') + (value LIKE :tokenBegin7 ESCAPE '/') + (value LIKE :tokenBoundary7 ESCAPE '/')) * :boundaryWeight) AS boundaryBonuses FROM moz_formhistory WHERE fieldname=:fieldname AND (value LIKE :tokenContains0 ESCAPE '/') AND (value LIKE :tokenContains1 ESCAPE '/') AND (value LIKE :tokenContains2 ESCAPE '/') AND (value LIKE :tokenContains3 ESCAPE '/') AND (value LIKE :tokenContains4 ESCAPE '/') AND (value LIKE :tokenContains5 ESCAPE '/') AND (value LIKE :tokenContains6 ESCAPE '/') AND (value LIKE :tokenContains7 ESCAPE '/') ORDER BY ROUND(frecency * boundaryBonuses) DESC, UPPER(value) ASC"	1	908	908	908	NA	908
"SELECT value, ROUND( timesUsed / MAX(1.0, (lastUsed - firstUsed) / :timeGroupingSize) * MAX(1.0, :maxTimeGroupings - (:now - lastUsed) / :timeGroupingSize) * MAX(1.0, :agedWeight * (firstUsed < :expiryDate)) / :bucketSize , 3) AS frecency, MAX(1, :prefixWeight * (value LIKE :valuePrefix ESCAPE '/') + ((value LIKE :tokenBegin0 ESCAPE '/') + (value LIKE :tokenBoundary0 ESCAPE '/') + (value LIKE :tokenBegin1 ESCAPE '/') + (value LIKE :tokenBoundary1 ESCAPE '/') + (value LIKE :tokenBegin2 ESCAPE '/') + (value LIKE :tokenBoundary2 ESCAPE '/')) * :boundaryWeight) AS boundaryBonuses FROM moz_formhistory WHERE fieldname=:fieldname AND (value LIKE :tokenContains0 ESCAPE '/') AND (value LIKE :tokenContains1 ESCAPE '/') AND (value LIKE :tokenContains2 ESCAPE '/') ORDER BY ROUND(frecency * boundaryBonuses) DESC, UPPER(value) ASC"	1	128	128	128	NA	128
"UPDATE moz_cache SET MetaData = ?, Flags = ?, DataSize = ?, FetchCount = ?, LastFetched = ?, LastModified = ?, ExpirationTime = ? WHERE ClientID = ? AND Key = ?;"	1	114	114	114	NA	114
"select m.url, m.title, '', '', m.rev_host, m.id FROM moz_places as m INNER JOIN ( select m.rev_host as rev_host, max(m.frecency) as frec from moz_places as m where m.typed = 1 and m.hidden = 0 group by rev_host order by max(m.frecency) desc limit 12 ) as X ON m.rev_host = X.rev_host AND m.frecency = X.frec "	1	115	115	115	NA	115