"sql"	"count"	"time"	"avg_avg_time"	"median_avg_time"	"sd_avg_time"	"avg_time"
"SELECT domain, partial_data, complete_data FROM moz_classifier"	72990	19692721	243.714920987867	157.15763546798	4350.67583896575	269.800260309631
"DELETE FROM moz_classifier WHERE table_id=?1 AND chunk_id=?2"	57036	16701456	253.626385978235	197.316666666667	480.99114044737	292.823059120555
"UPDATE moz_places SET title = :page_title WHERE id = :page_id "	27922	6087471	222.996113997744	156.633333333333	291.533896981801	218.017011675381
"pragma wal_checkpoint "	24190	8254015	278.728888314332	165.666666666667	703.483339725254	341.215998346424
"SELECT h.url, h.title, f.url, EXISTS(SELECT 1 FROM moz_bookmarks WHERE fk = h.id) AS bookmarked, ( SELECT title FROM moz_bookmarks WHERE fk = h.id AND title NOTNULL ORDER BY lastModified DESC LIMIT 1 ) AS btitle, ( SELECT GROUP_CONCAT(t.title, ',') FROM moz_bookmarks b JOIN moz_bookmarks t ON t.id = +b.parent AND t.parent = :parent WHERE b.fk = h.id ) AS tags, h.visit_count, h.typed, h.id, :query_type, t.open_count FROM moz_places h LEFT JOIN moz_favicons f ON f.id = h.favicon_id LEFT JOIN moz_openpages_temp t ON t.url = h.url WHERE h.frecency <> 0 AND AUTOCOMPLETE_MATCH(:searchString, h.url, IFNULL(btitle, h.title), tags, h.visit_count, h.typed, bookmarked, t.open_count, :matchBehavior, :searchBehavior) ORDER BY h.frecency DESC, h.id DESC LIMIT :maxResults"	19150	6461594	471.017282886779	224.407407407407	1276.12470962754	337.420052219321
"UPDATE moz_places SET frecency = CALCULATE_FRECENCY(:page_id) WHERE id = :page_id"	15800	3749074	205.937037016451	155	282.89117458458	237.283164556962
"/* do not warn (bug 659740 - SQLite may ignore index if few visits exist) */SELECT ROUND((strftime('%s','now','localtime','utc') - v.visit_date/1000000)/86400), IFNULL(r.visit_type, v.visit_type), v.visit_date FROM moz_historyvisits v LEFT JOIN moz_historyvisits r ON r.id = v.from_visit AND v.visit_type BETWEEN 5 AND 6 WHERE v.place_id = :page_id ORDER BY v.visit_date DESC "	14767	4425316	7113.75362204656	152.5	101115.108202541	299.676034401029
"SELECT * FROM moz_classifier WHERE domain=?1 AND table_id=?2 AND chunk_id=?3"	10935	2656065	221.810674813301	171	219.17590745751	242.895747599451
"UPDATE moz_places SET frecency = CALCULATE_FRECENCY(id) WHERE frecency < 0"	8002	18779550	906.966588651334	359	16458.6184362329	2346.85703574106
"SELECT 1 FROM moz_places h WHERE url = ?1 AND last_visit_date NOTNULL "	7265	1791972	230.689841397462	156.366666666667	282.329049653178	246.658224363386
"ANALYZE moz_places"	6743	19522552	750.392223420166	206.717948717949	20678.7869238707	2895.2323891443
"INSERT OR REPLACE INTO moz_classifier VALUES (?1, ?2, ?3, ?4, ?5, ?6)"	5668	1430348	271.87319946288	164	1618.47870623346	252.354975299929
"UPDATE moz_places SET frecency = ROUND(frecency * .975) WHERE frecency > 0"	5539	52930520	781.926653120601	278	20567.2102462043	9555.97039176747
"SELECT h.id, h.favicon_id, h.guid, (SELECT h.url FROM moz_bookmarks b WHERE b.fk = h.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 = h.id LIMIT 1 ) FROM moz_places h WHERE h.url = :page_url"	4479	2963390	430.942866658129	209.25	917.980804773562	661.618664880554
"DELETE FROM moz_classifier WHERE id=?1"	4344	1170316	254.316281275166	169.416666666667	422.011355327068	269.409760589319
"ANALYZE moz_historyvisits"	3158	20286963	1149.07086391536	157.769230769231	35570.7267137884	6423.99081697277
"DELETE FROM addon"	2771	789248	285.328832255611	193	674.726493651486	284.824251172862
"INSERT INTO moz_cookies (baseDomain, name, value, host, path, expiry, lastAccessed, creationTime, isSecure, isHttpOnly) VALUES (:baseDomain, :name, :value, :host, :path, :expiry, :lastAccessed, :creationTime, :isSecure, :isHttpOnly)"	2326	745306	368.901531654442	180	771.982562444713	320.423903697334
"DELETE FROM moz_cookies WHERE name = :name AND host = :host AND path = :path"	2149	813205	566.854048765816	182	4396.76132028022	378.410888785482
"INSERT INTO expiration_notify (v_id, url, guid, visit_date, expected_results) SELECT v.id, h.url, h.guid, v.visit_date, :limit_visits FROM moz_historyvisits v JOIN moz_places h ON h.id = v.place_id WHERE (SELECT COUNT(*) FROM moz_places) > :max_uris AND visit_date < strftime('%s','now','localtime','start of day','-7 days','utc') * 1000000 ORDER BY v.visit_date ASC LIMIT :limit_visits"	1701	550540	318.909327680194	187	587.824436366599	323.656672545561
"INSERT INTO moz_historyvisits (from_visit, place_id, visit_date, visit_type, session) VALUES (:from_visit, :page_id, :visit_date, :visit_type, :session) "	1523	339840	221.463408288931	168	284.903460767144	223.138542350624
"DELETE FROM moz_subs WHERE table_id=?1 AND chunk_id=?2"	1368	356895	222.774390732724	155	400.849564763507	260.888157894737
"VACUUM"	1315	1967872	1497.49885844749	499	8927.94623150271	1496.48060836502
"SELECT name, value, host, path, expiry, lastAccessed, creationTime, isSecure, isHttpOnly, baseDomain FROM moz_cookies WHERE baseDomain NOTNULL"	1123	187584	174.582617754402	143.285714285714	132.645505115202	167.038290293856
"INSERT INTO moz_places (url, title, rev_host, hidden, typed, guid) VALUES (:url, :title, :rev_host, :hidden, :typed, :guid) "	1065	279471	232.15032769815	166.5	307.883799359107	262.414084507042
"DELETE FROM moz_favicons WHERE id IN ( SELECT f.id FROM moz_favicons f LEFT JOIN moz_places h ON f.id = h.favicon_id WHERE h.favicon_id IS NULL LIMIT :limit_favicons )"	968	2015491	2241.52596868579	187.5	52410.4524809755	2082.11880165289
"DELETE FROM moz_annos WHERE id in ( SELECT a.id FROM moz_annos a LEFT JOIN moz_places h ON a.place_id = h.id WHERE h.id IS NULL LIMIT :limit_annos )"	908	342884	340.845945783855	184.5	743.635808837825	377.625550660793
"SELECT id, title, hidden, typed, guid FROM moz_places WHERE url = :page_url "	882	178489	198.014411480945	146	237.052203944123	202.368480725624
"UPDATE moz_cookies SET lastAccessed = :lastAccessed WHERE name = :name AND host = :host AND path = :path"	780	272183	334.415885850914	170	631.187926183495	348.952564102564
"SELECT id, expiration, data, mime_type FROM moz_favicons WHERE url = :icon_url"	681	125908	182.754380707763	144	167.023337763852	184.886930983847
"SELECT * FROM moz_classifier WHERE domain=?1"	663	120682	181.855156791023	138	178.114264803041	182.024132730015
"/* do not warn (bug 487789) */ SELECT h.url, h.title, f.url, EXISTS(SELECT 1 FROM moz_bookmarks WHERE fk = h.id) AS bookmarked, ( SELECT title FROM moz_bookmarks WHERE fk = h.id AND title NOTNULL ORDER BY lastModified DESC LIMIT 1 ) AS btitle, ( SELECT GROUP_CONCAT(t.title, ',') FROM moz_bookmarks b JOIN moz_bookmarks t ON t.id = +b.parent AND t.parent = :parent WHERE b.fk = h.id ) AS tags, h.visit_count, h.typed, h.id, :query_type, t.open_count FROM ( SELECT ROUND( MAX(use_count) * (1 + (input = :search_string)), 1 ) AS rank, place_id FROM moz_inputhistory WHERE input BETWEEN :search_string AND :search_string || X'FFFF' GROUP BY place_id ) AS i JOIN moz_places h ON h.id = i.place_id LEFT JOIN moz_favicons f ON f.id = h.favicon_id LEFT JOIN moz_openpages_temp t ON t.url = h.url WHERE AUTOCOMPLETE_MATCH(NULL, h.url, IFNULL(btitle, h.title), tags, h.visit_count, h.typed, bookmarked, t.open_count, :matchBehavior, :searchBehavior) ORDER BY rank DESC, h.frecency DESC "	571	195018	336.081923558897	195	502.861029238207	341.53765323993
"INSERT OR REPLACE INTO moz_subs VALUES (?1, ?2, ?3, ?4, ?5, ?6, ?7)"	537	145190	234.217412558797	160.5	407.841911041985	270.372439478585
"DELETE FROM moz_inputhistory WHERE place_id IN ( SELECT i.place_id FROM moz_inputhistory i LEFT JOIN moz_places h ON h.id = i.place_id WHERE h.id IS NULL LIMIT :limit_inputhistory )"	533	3675375	4378.75830267729	206.5	74398.1517928	6895.63789868668
"UPDATE moz_formhistory SET guid = :newGUID WHERE guid = :oldGUID"	530	147110	462.835842893572	202.5	813.281620908377	277.566037735849
"INSERT OR REPLACE INTO moz_inputhistory SELECT h.id, IFNULL(i.input, :input_text), IFNULL(i.use_count, 0) * .9 + 1 FROM moz_places h LEFT JOIN moz_inputhistory i ON i.place_id = h.id AND i.input = :input_text WHERE url = :page_url "	451	150514	349.309991809992	153	2414.31847716695	333.733924611973
"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 7"	414	149577	286.931328816111	163.875	620.075020800817	361.297101449275
"INSERT INTO expiration_notify (p_id, url, guid, visit_date, expected_results) SELECT h.id, h.url, h.guid, h.last_visit_date, :limit_uris FROM moz_places h LEFT JOIN moz_historyvisits v ON h.id = v.place_id LEFT JOIN moz_bookmarks b ON h.id = b.fk WHERE h.last_visit_date IS NULL AND v.id IS NULL AND b.id IS NULL AND frecency <> -1 LIMIT :limit_uris"	407	4297298931	12492054.8238857	180	231568769.156815	10558474.031941
"SELECT (SELECT COUNT(*) FROM moz_places), (SELECT SUBSTR(stat,1,LENGTH(stat)-2) FROM sqlite_stat1 WHERE idx = 'moz_places_url_uniqueindex')"	407	190540	445.081964117092	187	1202.54278673913	468.157248157248
"DELETE FROM moz_subs WHERE table_id=?1 AND add_chunk_id=?2"	387	119188	297.433682528409	162.5	442.621631151153	307.979328165375
"SELECT * FROM moz_subs WHERE table_id=?1 AND add_chunk_id=?2"	365	71553	182.056898632029	140.5	197.899442452554	196.035616438356
"SELECT typed, hidden, visit_count, (SELECT count(*) FROM moz_historyvisits WHERE place_id = :page_id), EXISTS ( SELECT 1 FROM moz_bookmarks WHERE fk = :page_id AND NOT EXISTS( SELECT 1 FROM moz_items_annos a JOIN moz_anno_attributes n ON a.anno_attribute_id = n.id WHERE n.name = :anno_name AND a.item_id = parent ) ), (url > 'place:' AND url < 'place;') FROM moz_places WHERE id = :page_id "	327	118298	230.549165120594	147.875	489.333228133628	361.767584097859
"SELECT b.id FROM moz_bookmarks b JOIN moz_places h on h.id = b.fk WHERE h.url = :url AND NOT EXISTS( SELECT 1 FROM moz_items_annos a JOIN moz_anno_attributes n ON a.anno_attribute_id = n.id WHERE a.item_id = b.parent AND n.name = :name ) "	326	66922	205.994028230185	150	199.465621567151	205.282208588957
"PRAGMA integrity_check(1)"	325	203495	625.925696594427	270	983.367919427288	626.138461538462
"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"	304	81579	267.35406360424	147.5	618.439851168705	268.351973684211
"UPDATE moz_places SET title = :title, hidden = :hidden, typed = :typed, guid = :guid WHERE id = :page_id "	292	55343	189.883465085639	138	222.987539373912	189.530821917808
"SELECT h.url, h.title, f.url, EXISTS(SELECT 1 FROM moz_bookmarks WHERE fk = h.id) AS bookmarked, ( SELECT title FROM moz_bookmarks WHERE fk = h.id AND title NOTNULL ORDER BY lastModified DESC LIMIT 1 ) AS btitle, ( SELECT GROUP_CONCAT(t.title, ',') FROM moz_bookmarks b JOIN moz_bookmarks t ON t.id = +b.parent AND t.parent = :parent WHERE b.fk = h.id ) AS tags, h.visit_count, h.typed, h.id, :query_type, t.open_count FROM moz_places h LEFT JOIN moz_favicons f ON f.id = h.favicon_id LEFT JOIN moz_openpages_temp t ON t.url = h.url WHERE h.frecency <> 0 AND AUTOCOMPLETE_MATCH(:searchString, h.url, IFNULL(btitle, h.title), tags, h.visit_count, h.typed, bookmarked, t.open_count, :matchBehavior, :searchBehavior) AND +h.visit_count > 0 ORDER BY h.frecency DESC, h.id DESC LIMIT :maxResults"	214	51981	458.018571281326	265.75	557.484243564269	242.901869158878
"DELETE FROM moz_places WHERE id IN ( SELECT p_id FROM expiration_notify WHERE p_id NOTNULL )"	191	1660198	10794.492872807	173	121711.344744137	8692.13612565445
"ANALYZE moz_bookmarks"	188	128566	683.86170212766	199.5	4376.78339169038	683.86170212766
"SELECT addon_internal_id, url, width, height, thumbnailURL, thumbnailWidth, thumbnailHeight, caption FROM screenshot ORDER BY addon_internal_id, num"	163	35630	219.3625	143	370.699894513679	218.588957055215
"UPDATE moz_places SET guid = :guid WHERE url = :page_url"	162	57989	306.927775628627	199	224.520779040354	357.956790123457
"SELECT name, add_chunks, sub_chunks FROM moz_tables"	159	56008	327.978116246499	195	359.501068776985	352.251572327044
"SELECT id FROM moz_tables WHERE name = ?1"	157	84985	528.023648648649	177	1909.67889288402	541.305732484076
"/* do not warn (bug 599936) */ SELECT visit_type type, visit_date date FROM moz_historyvisits WHERE place_id = (SELECT id FROM moz_places WHERE url = :url) ORDER BY date DESC LIMIT 10"	150	26988	181.520115995116	165.1	73.6064220718499	179.92
"SELECT f.data, f.mime_type FROM moz_favicons f WHERE url = :icon_url"	150	35507	252.392877492877	148	408.948739869186	236.713333333333
"DELETE FROM moz_historyvisits WHERE id IN ( SELECT v_id FROM expiration_notify WHERE v_id NOTNULL )"	142	78368	375.903156565657	210	507.825456517085	551.887323943662
"INSERT OR REPLACE INTO moz_favicons (id, url, data, mime_type, expiration, guid) VALUES ((SELECT id FROM moz_favicons WHERE url = :icon_url), :icon_url, :data, :mime_type, :expiration, COALESCE(:guid, (SELECT guid FROM moz_favicons WHERE url = :icon_url), GENERATE_GUID()))"	139	36657	263.6875	147.5	849.498403062393	263.719424460432
"SELECT count(*) FROM moz_keywords "	137	49063	358.124087591241	158	988.684311756073	358.124087591241
"SELECT addon_internal_id, id, minVersion, maxVersion FROM targetApplication WHERE addon_internal_id=:internal_id"	126	20545	163.055555555556	139.5	84.237312925383	163.055555555556
"SELECT addon_internal_id, name, url FROM developer ORDER BY addon_internal_id, num"	115	21837	189.886956521739	138	138.063662230057	189.886956521739
"DELETE FROM moz_annos WHERE expiration = :expire_with_history AND NOT EXISTS (SELECT id FROM moz_historyvisits WHERE place_id = moz_annos.place_id LIMIT 1)"	114	39473	352.557755775578	166	826.468874333465	346.254385964912
"SELECT id, name, description, creator, homepageURL FROM locale WHERE id=:id"	113	25721	226.109090909091	151	353.009501534276	227.619469026549
"SELECT url, title, frecency FROM moz_places WHERE guid = :guid"	110	20684	183.979090605985	166	80.0768975652531	188.036363636364
"UPDATE moz_places SET favicon_id = :icon_id WHERE id = :page_id"	97	16935	171.697318007663	143	105.416384099678	174.587628865979
"SELECT addon_internal_id, type, minVersion, maxVersion, appID, appMinVersion, appMaxVersion FROM compatibility_override ORDER BY addon_internal_id, num"	91	13897	152.714285714286	132	61.9713707582041	152.714285714286
"SELECT addon_locale.locale, locale.id, locale.name, locale.description, locale.creator, locale.homepageURL FROM addon_locale JOIN locale ON addon_locale.locale_id=locale.id WHERE addon_internal_id=:internal_id"	91	19163	211.674157303371	157	228.301474096349	210.582417582418
"SELECT h.url, h.title, f.url, EXISTS(SELECT 1 FROM moz_bookmarks WHERE fk = h.id) AS bookmarked, ( SELECT title FROM moz_bookmarks WHERE fk = h.id AND title NOTNULL ORDER BY lastModified DESC LIMIT 1 ) AS btitle, ( SELECT GROUP_CONCAT(t.title, ',') FROM moz_bookmarks b JOIN moz_bookmarks t ON t.id = +b.parent AND t.parent = :parent WHERE b.fk = h.id ) AS tags, h.visit_count, h.typed, h.id, :query_type, t.open_count FROM moz_places h LEFT JOIN moz_favicons f ON f.id = h.favicon_id LEFT JOIN moz_openpages_temp t ON t.url = h.url WHERE h.frecency <> 0 AND AUTOCOMPLETE_MATCH(:searchString, h.url, IFNULL(btitle, h.title), tags, h.visit_count, h.typed, bookmarked, t.open_count, :matchBehavior, :searchBehavior) AND bookmarked ORDER BY h.frecency DESC, h.id DESC LIMIT :maxResults"	89	12420	227.960930735931	110.137987012987	311.847507730825	139.550561797753
"INSERT INTO moz_places (url, rev_host, hidden, favicon_id, frecency, guid) VALUES (:page_url, :rev_host, 1, :favicon_id, 0, GENERATE_GUID()) "	80	20299	252.474025974026	176	212.237188815893	253.7375
"SELECT locale_id, type, value FROM locale_strings WHERE locale_id=:id"	75	15436	206.798611111111	157	164.306195174411	205.813333333333
"ANALYZE moz_inputhistory"	70	190549	3137.49576271186	203	21500.4559738382	2722.12857142857
"UPDATE moz_places SET visit_count = (SELECT count(*) FROM moz_historyvisits WHERE place_id = moz_places.id AND visit_type NOT IN (0,4,7,8)), last_visit_date = (SELECT MAX(visit_date) FROM moz_historyvisits WHERE place_id = moz_places.id) WHERE id IN ( SELECT h.id FROM moz_places h WHERE visit_count <> (SELECT count(*) FROM moz_historyvisits v WHERE v.place_id = h.id AND visit_type NOT IN (0,4,7,8)) OR last_visit_date <> (SELECT MAX(visit_date) FROM moz_historyvisits v WHERE v.place_id = h.id) )"	70	20836	297.657142857143	218.5	227.16806558296	297.657142857143
"SELECT h.url, h.title, f.url, EXISTS(SELECT 1 FROM moz_bookmarks WHERE fk = h.id) AS bookmarked, ( SELECT title FROM moz_bookmarks WHERE fk = h.id AND title NOTNULL ORDER BY lastModified DESC LIMIT 1 ) AS btitle, ( SELECT GROUP_CONCAT(t.title, ',') FROM moz_bookmarks b JOIN moz_bookmarks t ON t.id = +b.parent AND t.parent = :parent WHERE b.fk = h.id ) AS tags, h.visit_count, h.typed, h.id, :query_type, t.open_count FROM moz_places h LEFT JOIN moz_favicons f ON f.id = h.favicon_id LEFT JOIN moz_openpages_temp t ON t.url = h.url WHERE h.frecency <> 0 AND AUTOCOMPLETE_MATCH(:searchString, h.url, IFNULL(btitle, h.title), tags, h.visit_count, h.typed, bookmarked, t.open_count, :matchBehavior, :searchBehavior) AND h.typed = 1 ORDER BY h.frecency DESC, h.id DESC LIMIT :maxResults"	67	38419	503.413636363636	227.75	594.65357688509	573.417910447761
"UPDATE moz_tables SET add_chunks=?1, sub_chunks=?2 WHERE id=?3"	61	22271	368.574404761905	216	511.575522352611	365.098360655738
"/* do not warn (bug 487787) */ SELECT (SELECT REPLACE(url, '%s', :query_string) FROM moz_places WHERE id = b.fk) AS search_url, h.title, IFNULL(f.url, (SELECT f.url FROM moz_places JOIN moz_favicons f ON f.id = favicon_id WHERE rev_host = (SELECT rev_host FROM moz_places WHERE id = b.fk) ORDER BY frecency DESC LIMIT 1) ), 1, b.title, NULL, h.visit_count, h.typed, IFNULL(h.id, b.fk), :query_type, t.open_count FROM moz_keywords k JOIN moz_bookmarks b ON b.keyword_id = k.id LEFT JOIN moz_places h ON h.url = search_url LEFT JOIN moz_favicons f ON f.id = h.favicon_id LEFT JOIN moz_openpages_temp t ON t.url = search_url WHERE LOWER(k.keyword) = LOWER(:keyword) ORDER BY h.frecency DESC "	59	18528	326.833333333333	186	374.886340073703	314.033898305085
"SELECT os, abi FROM targetPlatform WHERE addon_internal_id=:internal_id"	58	15090	260.172413793103	168.5	391.915544873343	260.172413793103
"DELETE FROM moz_anno_attributes WHERE id IN ( SELECT n.id FROM moz_anno_attributes n LEFT JOIN moz_annos a ON n.id = a.anno_attribute_id LEFT JOIN moz_items_annos t ON n.id = t.anno_attribute_id WHERE a.anno_attribute_id IS NULL AND t.anno_attribute_id IS NULL LIMIT :limit_annos)"	50	13830	279.428571428571	159	338.172293365379	276.6
"UPDATE moz_openpages_temp SET open_count = open_count - 1 WHERE url = :page_url"	49	11766	230.346846846847	161	160.54861758548	240.122448979592
"SELECT internal_id, id, type, name, version, creator, creatorURL, description, fullDescription, developerComments, eula, iconURL, homepageURL, supportURL, contributionURL, contributionAmount, averageRating, reviewCount, reviewURL, totalDownloads, weeklyDownloads, dailyUsers, sourceURI, repositoryStatus, size, updateDate FROM addon"	47	9130	198.779069767442	142	118.180970102433	194.255319148936
"DELETE FROM moz_items_annos WHERE (expiration = :expire_days AND :expire_days_time > MAX(lastModified, dateAdded)) OR (expiration = :expire_weeks AND :expire_weeks_time > MAX(lastModified, dateAdded)) OR (expiration = :expire_months AND :expire_months_time > MAX(lastModified, dateAdded))"	41	69277	1985.86979166667	186	9209.47213088956	1689.68292682927
"SELECT count(*) FROM moz_places"	41	9470	230.975609756098	175	167.433641751722	230.975609756098
"PRAGMA page_size"	40	11170	265.441176470588	176	402.005215643572	279.25
"DELETE FROM moz_cookies WHERE baseDomain ISNULL"	33	8153	247.060606060606	160	202.103924286792	247.060606060606
"INSERT INTO addon VALUES (NULL, :id, :type, :name, :version, :creator, :creatorURL, :description, :fullDescription, :developerComments, :eula, :iconURL, :homepageURL, :supportURL, :contributionURL, :contributionAmount, :averageRating, :reviewCount, :reviewURL, :totalDownloads, :weeklyDownloads, :dailyUsers, :sourceURI, :repositoryStatus, :size, :updateDate)"	32	7432	183.384615384615	147.5	91.9412056725896	232.25
"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 visible=1 AND id=:id"	31	8893	286.870967741935	147	456.843791095343	286.870967741935
"DELETE FROM moz_items_annos WHERE id IN ( SELECT a.id FROM moz_items_annos a LEFT JOIN moz_bookmarks b ON a.item_id = b.id WHERE b.id IS NULL LIMIT :limit_annos )"	29	7646	263.655172413793	165	251.182812745457	263.655172413793
"DELETE FROM expiration_notify"	28	5667	188.369791666667	164	83.2628644756739	202.392857142857
"SELECT guid FROM moz_places WHERE url = :page_url"	27	6569	197.052083333333	195.75	84.0087896360322	243.296296296296
"UPDATE moz_inputhistory SET use_count = use_count * .975"	27	18791	695.962962962963	181	1795.23140744245	695.962962962963
"INSERT OR REPLACE INTO moz_openpages_temp (url, open_count) VALUES (:page_url, IFNULL((SELECT open_count + 1 FROM moz_openpages_temp WHERE url = :page_url ), 1))"	26	5164	199.630434782609	166	104.890442561329	198.615384615385
"UPDATE moz_places SET hidden = 0 WHERE id = :page_id AND frecency <> 0"	26	27593	661.803571428571	153.75	1957.78893585262	1061.26923076923
"SELECT * FROM moz_places WHERE visit_count > 1 AND typed = 1 ORDER BY frecency DESC"	25	15507	620.28	315	718.386416445449	620.28
"SELECT COUNT(1) as n FROM moz_places WHERE title LIKE :tag"	25	4633	185.32	185.32	NA	185.32
"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 "	25	58719	1786.49166666667	211	4200.13219837722	2348.76
"SELECT f.url FROM moz_places h JOIN moz_favicons f ON h.favicon_id = f.id WHERE h.url = :page_url"	25	6260	242.045454545455	185	157.242072181936	250.4
"UPDATE moz_places SET frecency = (CASE WHEN url BETWEEN 'place:' AND 'place;' THEN 0 WHEN id IN (SELECT b.fk FROM moz_bookmarks b JOIN moz_bookmarks bp ON bp.id = b.parent JOIN moz_items_annos a ON a.item_id = bp.id JOIN moz_anno_attributes n ON n.id = a.anno_attribute_id WHERE b.fk = moz_places.id AND visit_count = 0 AND n.name = :anno_name) THEN 0 ELSE -1 END) "	24	8514	350.130434782609	232	278.815726755443	354.75
"SELECT * FROM moz_inputhistory JOIN moz_places ON id = place_id WHERE input NOT NULL ORDER BY use_count DESC"	22	14058	639	262.5	775.442362231299	639
"SELECT fieldname name, value FROM moz_formhistory WHERE guid = :guid"	22	6612	329.410714285714	170.5	549.488518818114	300.545454545455
"SELECT count(*) FROM moz_bookmarks b JOIN moz_bookmarks t ON t.id = b.parent AND t.parent <> :tags_folder WHERE b.type = :type_bookmark "	19	27993	1473.31578947368	181	4900.89129141755	1473.31578947368
"SELECT id, url, title, frecency FROM moz_places ORDER BY frecency DESC LIMIT :limit"	19	3711	173.833333333333	174	58.0813605595155	195.315789473684
"DELETE FROM moz_historyvisits WHERE id IN (SELECT id FROM moz_historyvisits v WHERE NOT EXISTS (SELECT id FROM moz_places WHERE id = v.place_id LIMIT 1) )"	18	3424	190.222222222222	151	99.4298780729151	190.222222222222
"SELECT url, guid, MAX(visit_date) AS visit_date, MAX(IFNULL(MIN(p_id, 1), MIN(v_id, 0))) AS whole_entry, expected_results FROM expiration_notify GROUP BY url"	18	16504	921.178571428571	178	2208.4624969138	916.888888888889
"DELETE FROM moz_places WHERE id IN ( SELECT h.id FROM moz_places h LEFT JOIN moz_historyvisits v ON h.id = v.place_id LEFT JOIN moz_bookmarks b ON h.id = b.fk WHERE h.last_visit_date IS NULL AND v.id IS NULL AND b.id IS NULL LIMIT :limit_uris )"	17	40220	2365.88235294118	399	7155.0673379287	2365.88235294118
"SELECT moz_places.url, moz_bookmarks.title FROM moz_bookmarks JOIN moz_places ON moz_places.id = fk WHERE moz_bookmarks.title NOT NULL ORDER BY frecency DESC LIMIT 100"	17	10211	600.647058823529	288	713.11385321494	600.647058823529
"SELECT ROUND(( SELECT count(*) FROM moz_bookmarks b JOIN moz_bookmarks t ON t.id = b.parent AND t.parent <> :tags_folder AND t.parent > :places_root WHERE b.type = :type_bookmark ) * 100 / ( SELECT count(*) FROM moz_bookmarks b JOIN moz_bookmarks t ON t.id = b.parent AND t.parent <> :tags_folder WHERE b.type = :type_bookmark )) "	15	1502472	100164.8	161	387226.19384286	100164.8
"SELECT id, session, visit_date FROM moz_historyvisits WHERE place_id = (SELECT id FROM moz_places WHERE url = :page_url) ORDER BY visit_date DESC "	14	3486	249	192	193.392784846719	249
"SELECT visit_type type, visit_date date FROM moz_historyvisits WHERE place_id = :id ORDER BY visit_date DESC LIMIT 10"	14	3727	357.886363636364	169.272727272727	421.259428616556	266.214285714286
"SELECT * FROM moz_places WHERE visit_count > 1 ORDER BY last_visit_date DESC LIMIT 100"	11	1934	175.818181818182	162	56.7852413604419	175.818181818182
"SELECT guid FROM moz_formhistory WHERE guid = :guid LIMIT 1"	10	5441	544.1	288	612.534706499694	544.1
"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 visible=1"	10	2690	269	127	362.416273855846	269
"SELECT visit_type type, visit_date date FROM moz_historyvisits WHERE place_id = (SELECT id from moz_places WHERE url = :id) ORDER BY visit_date DESC LIMIT 10"	10	3217	409.98	230.4	500.715090645369	321.7
"SELECT guid FROM moz_formhistory WHERE fieldname = :name AND value = :value"	9	1253	139.222222222222	121	47.7775516790516	139.222222222222
"UPDATE moz_bookmarks SET guid = :guid WHERE id = :item_id"	9	11123	1235.88888888889	1235.88888888889	NA	1235.88888888889
"UPDATE moz_formhistory SET timesUsed=:timesUsed, lastUsed=:lastUsed WHERE id=:id"	9	2001	210.785714285714	210.785714285714	29.3954390464693	222.333333333333
"SELECT t.url, t.url, NULL, NULL, NULL, NULL, NULL, NULL, NULL, :query_type, t.open_count, NULL FROM moz_openpages_temp t LEFT JOIN moz_places h ON h.url = t.url WHERE h.id IS NULL AND AUTOCOMPLETE_MATCH(:searchString, t.url, t.url, NULL, NULL, NULL, NULL, t.open_count, :matchBehavior, :searchBehavior) ORDER BY t.ROWID DESC LIMIT :maxResults "	7	1566	223.714285714286	160	145.435798304858	223.714285714286
"PRAGMA user_version"	6	3466	577.666666666667	125	714.756368748587	577.666666666667
"DELETE FROM moz_annos WHERE (expiration = :expire_days AND :expire_days_time > MAX(lastModified, dateAdded)) OR (expiration = :expire_weeks AND :expire_weeks_time > MAX(lastModified, dateAdded)) OR (expiration = :expire_months AND :expire_months_time > MAX(lastModified, dateAdded))"	5	8324	1664.8	161	3404.61748218504	1664.8
"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 visible=1 AND type IN (?1)"	5	4602	920.4	156	1699.54796931419	920.4
"DELETE FROM moz_cookies"	4	1381	345.25	227	293.027160288371	345.25
"SELECT COUNT(*) as num_visits, strftime('%H', visit_date/1000/1000, 'unixepoch', 'localtime') as hour FROM moz_historyvisits v LEFT JOIN moz_places h ON v.place_id = h.id WHERE v.visit_type NOT IN (0, 4) GROUP BY hour ORDER BY hour ASC"	4	1952	488	518	127.491176165255	488
"SELECT count,SUM(match0) as count0 FROM (SELECT count,(title LIKE :left0 OR title LIKE :right0 OR LOWER(title) = :token0) as match0 FROM (SELECT *, (SELECT COUNT(1) FROM moz_places) as count FROM moz_places) WHERE (title LIKE :left0 OR title LIKE :right0 OR LOWER(title) = :token0))"	4	670	168	169	1.73205080756888	167.5
"SELECT id,title, tags, url, frecency, rev_host,is_bookmark,last_visit_date,(word_0 * :idf0) + (url_0 * :idf0) + (tag_0 * :idf0) as score FROM (SELECT id, title, tags, url, frecency, rev_host, is_bookmark, last_visit_date,(title LIKE :left0) OR (title LIKE :right0) OR (CASE LOWER(title) WHEN :word0 THEN 1 ELSE 0 END) as word_0 , (url LIKE :submatch0) as url_0 , (tags LIKE :submatch0) as tag_0 FROM (SELECT * FROM (SELECT * FROM (SELECT p.id as id, 1 as is_bookmark, p.title as title, p.url as url, p.frecency as frecency, p.rev_host as rev_host, p.last_visit_date as last_visit_date, GROUP_CONCAT(tag) as tags FROM (SELECT t.title as tag, b.fk as place_id FROM (SELECT * FROM moz_bookmarks WHERE parent = :rowid) t JOIN (SELECT * FROM moz_bookmarks WHERE type=1) b ON b.parent=t.id) r JOIN moz_places p ON p.id=r.place_id GROUP BY p.id) UNION SELECT * FROM (SELECT p.id as id, 1 as is_bookmark, b.title as title, p.url as url, p.frecency as frecency, p.rev_host as rev_host, p.last_visit_date as last_visit_date, '' as tags FROM (SELECT * FROM moz_bookmarks WHERE title is not null and fk is not null) b JOIN moz_places p on p.id = b.fk WHERE p.url LIKE 'http%' AND p.title is not null AND p.last_visit_date is not null GROUP BY p.id) UNION SELECT id, 0 as is_bookmark, title, url, frecency, rev_host, last_visit_date, '' as tags FROM moz_places WHERE title is not null) GROUP BY id) WHERE (title LIKE :submatch0 OR url LIKE :submatch0 OR tags LIKE :submatch0) AND frecency > 250) ORDER BY is_bookmark DESC,score DESC,frecency DESC LIMIT 0,100"	4	2109	532.5	543	18.1865334794732	527.25
"SELECT rev_host as rev_host, SUM(visit_count) as visits FROM moz_places GROUP BY rev_host ORDER BY SUM(visit_count) DESC LIMIT 10"	4	1022	255.5	164.5	206.198124789404	255.5
"CREATE TEMP TABLE expiration_notify ( id INTEGER PRIMARY KEY , v_id INTEGER , p_id INTEGER , url TEXT NOT NULL , guid TEXT NOT NULL , visit_date INTEGER , expected_results INTEGER NOT NULL ) "	3	473	157.666666666667	141	67.5598500097013	157.666666666667
"DELETE FROM moz_inputhistory WHERE use_count < .01"	3	519	173	194	52.7351874937408	173
"INSERT INTO screenshot (addon_internal_id, num, url, width, height, thumbnailURL, thumbnailWidth, thumbnailHeight, caption) VALUES (:addon_internal_id, :num, :url, :width, :height, :thumbnailURL, :thumbnailWidth, :thumbnailHeight, :caption)"	3	673	194.25	194.25	127.632774004172	224.333333333333
"REINDEX"	3	5952	1984	2641	1640.34112305947	1984
"SELECT count,SUM(match0) as count0,SUM(match1) as count1,SUM(match2) as count2,SUM(match3) as count3,SUM(match4) as count4 FROM (SELECT count,(title LIKE :left0 OR title LIKE :right0 OR LOWER(title) = :token0) as match0,(title LIKE :left1 OR title LIKE :right1 OR LOWER(title) = :token1) as match1,(title LIKE :left2 OR title LIKE :right2 OR LOWER(title) = :token2) as match2,(title LIKE :left3 OR title LIKE :right3 OR LOWER(title) = :token3) as match3,(title LIKE :left4 OR title LIKE :right4 OR LOWER(title) = :token4) as match4 FROM (SELECT *, (SELECT COUNT(1) FROM moz_places) as count FROM moz_places) WHERE (title LIKE :left0 OR title LIKE :right0 OR LOWER(title) = :token0) OR (title LIKE :left1 OR title LIKE :right1 OR LOWER(title) = :token1) OR (title LIKE :left2 OR title LIKE :right2 OR LOWER(title) = :token2) OR (title LIKE :left3 OR title LIKE :right3 OR LOWER(title) = :token3) OR (title LIKE :left4 OR title LIKE :right4 OR LOWER(title) = :token4))"	3	1335	445	445	NA	445
"SELECT fieldname name, value FROM moz_formhistory ORDER BY 1.0 * (lastUsed - (SELECT lastUsed FROM moz_formhistory ORDER BY lastUsed ASC LIMIT 1)) / ((SELECT lastUsed FROM moz_formhistory ORDER BY lastUsed DESC LIMIT 1) - (SELECT lastUsed FROM moz_formhistory ORDER BY lastUsed ASC LIMIT 1)) * timesUsed / (SELECT timesUsed FROM moz_formhistory ORDER BY timesUsed DESC LIMIT 1) DESC LIMIT 500"	3	436	145.333333333333	145	3.51188458428425	145.333333333333
"SELECT id AS item_id FROM moz_bookmarks WHERE guid = :guid"	3	1404	468	229	465.094614030307	468
"SELECT id,title, tags, url, frecency, rev_host,is_bookmark,last_visit_date,(word_0 * :idf0) + (url_0 * :idf0) + (tag_0 * :idf0) + (word_1 * :idf1) + (url_1 * :idf1) + (tag_1 * :idf1) + (word_2 * :idf2) + (url_2 * :idf2) + (tag_2 * :idf2) + (word_3 * :idf3) + (url_3 * :idf3) + (tag_3 * :idf3) + (word_4 * :idf4) + (url_4 * :idf4) + (tag_4 * :idf4) as score FROM (SELECT id, title, tags, url, frecency, rev_host, is_bookmark, last_visit_date,(title LIKE :left0) OR (title LIKE :right0) OR (CASE LOWER(title) WHEN :word0 THEN 1 ELSE 0 END) as word_0 , (url LIKE :submatch0) as url_0 , (tags LIKE :submatch0) as tag_0 , (title LIKE :left1) OR (title LIKE :right1) OR (CASE LOWER(title) WHEN :word1 THEN 1 ELSE 0 END) as word_1 , (url LIKE :submatch1) as url_1 , (tags LIKE :submatch1) as tag_1 , (title LIKE :left2) OR (title LIKE :right2) OR (CASE LOWER(title) WHEN :word2 THEN 1 ELSE 0 END) as word_2 , (url LIKE :submatch2) as url_2 , (tags LIKE :submatch2) as tag_2 , (title LIKE :left3) OR (title LIKE :right3) OR (CASE LOWER(title) WHEN :word3 THEN 1 ELSE 0 END) as word_3 , (url LIKE :submatch3) as url_3 , (tags LIKE :submatch3) as tag_3 , (title LIKE :left4) OR (title LIKE :right4) OR (CASE LOWER(title) WHEN :word4 THEN 1 ELSE 0 END) as word_4 , (url LIKE :submatch4) as url_4 , (tags LIKE :submatch4) as tag_4 FROM (SELECT * FROM (SELECT * FROM (SELECT p.id as id, 1 as is_bookmark, p.title as title, p.url as url, p.frecency as frecency, p.rev_host as rev_host, p.last_visit_date as last_visit_date, GROUP_CONCAT(tag) as tags FROM (SELECT t.title as tag, b.fk as place_id FROM (SELECT * FROM moz_bookmarks WHERE parent = :rowid) t JOIN (SELECT * FROM moz_bookmarks WHERE type=1) b ON b.parent=t.id) r JOIN moz_places p ON p.id=r.place_id GROUP BY p.id) UNION SELECT * FROM (SELECT p.id as id, 1 as is_bookmark, b.title as title, p.url as url, p.frecency as frecency, p.rev_host as rev_host, p.last_visit_date as last_visit_date, '' as tags FROM (SELECT * FROM moz_bookmarks WHERE title is not null and fk is not null) b JOIN moz_places p on p.id = b.fk WHERE p.url LIKE 'http%' AND p.title is not null AND p.last_visit_date is not null GROUP BY p.id) UNION SELECT id, 0 as is_bookmark, title, url, frecency, rev_host, last_visit_date, '' as tags FROM moz_places WHERE title is not null) GROUP BY id) WHERE (title LIKE :submatch0 OR url LIKE :submatch0 OR tags LIKE :submatch0 OR title LIKE :submatch1 OR url LIKE :submatch1 OR tags LIKE :submatch1 OR title LIKE :submatch2 OR url LIKE :submatch2 OR tags LIKE :submatch2 OR title LIKE :submatch3 OR url LIKE :submatch3 OR tags LIKE :submatch3 OR title LIKE :submatch4 OR url LIKE :submatch4 OR tags LIKE :submatch4) AND frecency > 250) ORDER BY is_bookmark DESC,score DESC,frecency DESC LIMIT 0,100"	3	1516	505.333333333333	505.333333333333	NA	505.333333333333
"SELECT count(*) FROM moz_bookmarks WHERE TYPE = :type_folder AND parent NOT IN (0, :places_root, :tags_folder) "	2	842	421	421	449.719912834644	421
"SELECT count,SUM(match0) as count0,SUM(match1) as count1,SUM(match2) as count2,SUM(match3) as count3,SUM(match4) as count4,SUM(match5) as count5,SUM(match6) as count6,SUM(match7) as count7,SUM(match8) as count8,SUM(match9) as count9,SUM(match10) as count10,SUM(match11) as count11 FROM (SELECT count,(title LIKE :left0 OR title LIKE :right0 OR LOWER(title) = :token0) as match0,(title LIKE :left1 OR title LIKE :right1 OR LOWER(title) = :token1) as match1,(title LIKE :left2 OR title LIKE :right2 OR LOWER(title) = :token2) as match2,(title LIKE :left3 OR title LIKE :right3 OR LOWER(title) = :token3) as match3,(title LIKE :left4 OR title LIKE :right4 OR LOWER(title) = :token4) as match4,(title LIKE :left5 OR title LIKE :right5 OR LOWER(title) = :token5) as match5,(title LIKE :left6 OR title LIKE :right6 OR LOWER(title) = :token6) as match6,(title LIKE :left7 OR title LIKE :right7 OR LOWER(title) = :token7) as match7,(title LIKE :left8 OR title LIKE :right8 OR LOWER(title) = :token8) as match8,(title LIKE :left9 OR title LIKE :right9 OR LOWER(title) = :token9) as match9,(title LIKE :left10 OR title LIKE :right10 OR LOWER(title) = :token10) as match10,(title LIKE :left11 OR title LIKE :right11 OR LOWER(title) = :token11) as match11 FROM (SELECT *, (SELECT COUNT(1) FROM moz_places) as count FROM moz_places) WHERE (title LIKE :left0 OR title LIKE :right0 OR LOWER(title) = :token0) OR (title LIKE :left1 OR title LIKE :right1 OR LOWER(title) = :token1) OR (title LIKE :left2 OR title LIKE :right2 OR LOWER(title) = :token2) OR (title LIKE :left3 OR title LIKE :right3 OR LOWER(title) = :token3) OR (title LIKE :left4 OR title LIKE :right4 OR LOWER(title) = :token4) OR (title LIKE :left5 OR title LIKE :right5 OR LOWER(title) = :token5) OR (title LIKE :left6 OR title LIKE :right6 OR LOWER(title) = :token6) OR (title LIKE :left7 OR title LIKE :right7 OR LOWER(title) = :token7) OR (title LIKE :left8 OR title LIKE :right8 OR LOWER(title) = :token8) OR (title LIKE :left9 OR title LIKE :right9 OR LOWER(title) = :token9) OR (title LIKE :left10 OR title LIKE :right10 OR LOWER(title) = :token10) OR (title LIKE :left11 OR title LIKE :right11 OR LOWER(title) = :token11))"	2	2521	1260.5	1260.5	NA	1260.5
"SELECT f.url, (SELECT title FROM moz_places WHERE favicon_id = s.favicon_id AND frecency != 0 AND visit_count > 0 AND typed = 1 ORDER BY frecency DESC LIMIT 1) AS _title ,(SELECT url FROM moz_places WHERE favicon_id = s.favicon_id AND frecency != 0 AND visit_count > 0 AND typed = 1 ORDER BY frecency DESC LIMIT 1) AS _url FROM moz_places s JOIN moz_favicons f ON f.id = s.favicon_id WHERE favicon_id NOT NULL AND frecency != 0 AND visit_count > 0 AND typed = 1 AND _url NOT IN () GROUP BY favicon_id ORDER BY MAX(frecency) DESC LIMIT 60"	2	904	452	452	357.796031280393	452
"SELECT id,title, tags, url, frecency, rev_host,is_bookmark,last_visit_date,(word_0 * :idf0) + (url_0 * :idf0) + (tag_0 * :idf0) + (word_1 * :idf1) + (url_1 * :idf1) + (tag_1 * :idf1) + (word_2 * :idf2) + (url_2 * :idf2) + (tag_2 * :idf2) + (word_3 * :idf3) + (url_3 * :idf3) + (tag_3 * :idf3) + (word_4 * :idf4) + (url_4 * :idf4) + (tag_4 * :idf4) + (word_5 * :idf5) + (url_5 * :idf5) + (tag_5 * :idf5) + (word_6 * :idf6) + (url_6 * :idf6) + (tag_6 * :idf6) + (word_7 * :idf7) + (url_7 * :idf7) + (tag_7 * :idf7) + (word_8 * :idf8) + (url_8 * :idf8) + (tag_8 * :idf8) + (word_9 * :idf9) + (url_9 * :idf9) + (tag_9 * :idf9) + (word_10 * :idf10) + (url_10 * :idf10) + (tag_10 * :idf10) + (word_11 * :idf11) + (url_11 * :idf11) + (tag_11 * :idf11) as score FROM (SELECT id, title, tags, url, frecency, rev_host, is_bookmark, last_visit_date,(title LIKE :left0) OR (title LIKE :right0) OR (CASE LOWER(title) WHEN :word0 THEN 1 ELSE 0 END) as word_0 , (url LIKE :submatch0) as url_0 , (tags LIKE :submatch0) as tag_0 , (title LIKE :left1) OR (title LIKE :right1) OR (CASE LOWER(title) WHEN :word1 THEN 1 ELSE 0 END) as word_1 , (url LIKE :submatch1) as url_1 , (tags LIKE :submatch1) as tag_1 , (title LIKE :left2) OR (title LIKE :right2) OR (CASE LOWER(title) WHEN :word2 THEN 1 ELSE 0 END) as word_2 , (url LIKE :submatch2) as url_2 , (tags LIKE :submatch2) as tag_2 , (title LIKE :left3) OR (title LIKE :right3) OR (CASE LOWER(title) WHEN :word3 THEN 1 ELSE 0 END) as word_3 , (url LIKE :submatch3) as url_3 , (tags LIKE :submatch3) as tag_3 , (title LIKE :left4) OR (title LIKE :right4) OR (CASE LOWER(title) WHEN :word4 THEN 1 ELSE 0 END) as word_4 , (url LIKE :submatch4) as url_4 , (tags LIKE :submatch4) as tag_4 , (title LIKE :left5) OR (title LIKE :right5) OR (CASE LOWER(title) WHEN :word5 THEN 1 ELSE 0 END) as word_5 , (url LIKE :submatch5) as url_5 , (tags LIKE :submatch5) as tag_5 , (title LIKE :left6) OR (title LIKE :right6) OR (CASE LOWER(title) WHEN :word6 THEN 1 ELSE 0 END) as word_6 , (url LIKE :submatch6) as url_6 , (tags LIKE :submatch6) as tag_6 , (title LIKE :left7) OR (title LIKE :right7) OR (CASE LOWER(title) WHEN :word7 THEN 1 ELSE 0 END) as word_7 , (url LIKE :submatch7) as url_7 , (tags LIKE :submatch7) as tag_7 , (title LIKE :left8) OR (title LIKE :right8) OR (CASE LOWER(title) WHEN :word8 THEN 1 ELSE 0 END) as word_8 , (url LIKE :submatch8) as url_8 , (tags LIKE :submatch8) as tag_8 , (title LIKE :left9) OR (title LIKE :right9) OR (CASE LOWER(title) WHEN :word9 THEN 1 ELSE 0 END) as word_9 , (url LIKE :submatch9) as url_9 , (tags LIKE :submatch9) as tag_9 , (title LIKE :left10) OR (title LIKE :right10) OR (CASE LOWER(title) WHEN :word10 THEN 1 ELSE 0 END) as word_10 , (url LIKE :submatch10) as url_10 , (tags LIKE :submatch10) as tag_10 , (title LIKE :left11) OR (title LIKE :right11) OR (CASE LOWER(title) WHEN :word11 THEN 1 ELSE 0 END) as word_11 , (url LIKE :submatch11) as url_11 , (tags LIKE :submatch11) as tag_11 FROM (SELECT * FROM (SELECT * FROM (SELECT p.id as id, 1 as is_bookmark, p.title as title, p.url as url, p.frecency as frecency, p.rev_host as rev_host, p.last_visit_date as last_visit_date, GROUP_CONCAT(tag) as tags FROM (SELECT t.title as tag, b.fk as place_id FROM (SELECT * FROM moz_bookmarks WHERE parent = :rowid) t JOIN (SELECT * FROM moz_bookmarks WHERE type=1) b ON b.parent=t.id) r JOIN moz_places p ON p.id=r.place_id GROUP BY p.id) UNION SELECT * FROM (SELECT p.id as id, 1 as is_bookmark, b.title as title, p.url as url, p.frecency as frecency, p.rev_host as rev_host, p.last_visit_date as last_visit_date, '' as tags FROM (SELECT * FROM moz_bookmarks WHERE title is not null and fk is not null) b JOIN moz_places p on p.id = b.fk WHERE p.url LIKE 'http%' AND p.title is not null AND p.last_visit_date is not null GROUP BY p.id) UNION SELECT id, 0 as is_bookmark, title, url, frecency, rev_host, last_visit_date, '' as tags FROM moz_places WHERE title is not null) GROUP BY id) WHERE (title LIKE :submatch0 OR url LIKE :submatch0 OR tags LIKE :submatch0 OR title LIKE :submatch1 OR url LIKE :submatch1 OR tags LIKE :submatch1 OR title LIKE :submatch2 OR url LIKE :submatch2 OR tags LIKE :submatch2 OR title LIKE :submatch3 OR url LIKE :submatch3 OR tags LIKE :submatch3 OR title LIKE :submatch4 OR url LIKE :submatch4 OR tags LIKE :submatch4 OR title LIKE :submatch5 OR url LIKE :submatch5 OR tags LIKE :submatch5 OR title LIKE :submatch6 OR url LIKE :submatch6 OR tags LIKE :submatch6 OR title LIKE :submatch7 OR url LIKE :submatch7 OR tags LIKE :submatch7 OR title LIKE :submatch8 OR url LIKE :submatch8 OR tags LIKE :submatch8 OR title LIKE :submatch9 OR url LIKE :submatch9 OR tags LIKE :submatch9 OR title LIKE :submatch10 OR url LIKE :submatch10 OR tags LIKE :submatch10 OR title LIKE :submatch11 OR url LIKE :submatch11 OR tags LIKE :submatch11) AND frecency > 250) ORDER BY is_bookmark DESC,score DESC,frecency DESC LIMIT 0,100"	2	1578	789	789	NA	789
"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 visible=1 AND type IN (?1,?2,?3,?4)"	2	847	423.5	423.5	427.799602617861	423.5
"UPDATE moz_bookmarks SET title = :new_title WHERE id = (SELECT folder_id FROM moz_bookmarks_roots WHERE root_name = :root_name)"	2	590	295	295	227.688383542068	295
"UPDATE moz_places SET favicon_id = NULL WHERE id IN ( SELECT id FROM moz_places h WHERE favicon_id NOT NULL AND NOT EXISTS (SELECT id FROM moz_favicons WHERE id = h.favicon_id LIMIT 1) )"	2	436	218	218	0	218
"SELECT * FROM moz_keywords"	1	204	204	204	NA	204
"SELECT MetaData, Generation, Flags, DataSize, FetchCount, LastFetched, LastModified, ExpirationTime, ItemType FROM moz_cache WHERE ClientID = ? AND Key = ?;"	1	301	301	301	NA	301
"SELECT ROUND(( SELECT count(*) FROM moz_bookmarks b JOIN moz_bookmarks t ON t.id = b.parent AND t.parent = :tags_folder ) * 100 / ( SELECT count(*) FROM moz_bookmarks b JOIN moz_bookmarks t ON t.id = b.parent AND t.parent <> :tags_folder WHERE b.type = :type_bookmark )) "	1	144820	144820	144820	NA	144820
"SELECT count(*) FROM moz_bookmarks WHERE parent = :tags_folder "	1	269	269	269	NA	269
"SELECT count,SUM(match0) as count0,SUM(match1) as count1 FROM (SELECT count,(title LIKE :left0 OR title LIKE :right0 OR LOWER(title) = :token0) as match0,(title LIKE :left1 OR title LIKE :right1 OR LOWER(title) = :token1) as match1 FROM (SELECT *, (SELECT COUNT(1) FROM moz_places) as count FROM moz_places) WHERE (title LIKE :left0 OR title LIKE :right0 OR LOWER(title) = :token0) OR (title LIKE :left1 OR title LIKE :right1 OR LOWER(title) = :token1))"	1	312	312	312	NA	312
"SELECT count,SUM(match0) as count0,SUM(match1) as count1,SUM(match2) as count2 FROM (SELECT count,(title LIKE :left0 OR title LIKE :right0 OR LOWER(title) = :token0) as match0,(title LIKE :left1 OR title LIKE :right1 OR LOWER(title) = :token1) as match1,(title LIKE :left2 OR title LIKE :right2 OR LOWER(title) = :token2) as match2 FROM (SELECT *, (SELECT COUNT(1) FROM moz_places) as count FROM moz_places) WHERE (title LIKE :left0 OR title LIKE :right0 OR LOWER(title) = :token0) OR (title LIKE :left1 OR title LIKE :right1 OR LOWER(title) = :token1) OR (title LIKE :left2 OR title LIKE :right2 OR LOWER(title) = :token2))"	1	259	259	259	NA	259
"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 14"	1	110	110	110	NA	110
"SELECT h.url, h.title, f.url, EXISTS(SELECT 1 FROM moz_bookmarks WHERE fk = h.id) AS bookmarked, ( SELECT title FROM moz_bookmarks WHERE fk = h.id AND title NOTNULL ORDER BY lastModified DESC LIMIT 1 ) AS btitle, ( SELECT GROUP_CONCAT(t.title, ',') FROM moz_bookmarks b JOIN moz_bookmarks t ON t.id = +b.parent AND t.parent = :parent WHERE b.fk = h.id ) AS tags, h.visit_count, h.typed, h.id, :query_type, t.open_count FROM moz_places h LEFT JOIN moz_favicons f ON f.id = h.favicon_id LEFT JOIN moz_openpages_temp t ON t.url = h.url WHERE h.frecency <> 0 AND AUTOCOMPLETE_MATCH(:searchString, h.url, IFNULL(btitle, h.title), tags, h.visit_count, h.typed, bookmarked, t.open_count, :matchBehavior, :searchBehavior) AND tags IS NOT NULL ORDER BY h.frecency DESC, h.id DESC LIMIT :maxResults"	1	146	146	146	NA	146
"SELECT id, target, name, source, state, startTime, endTime, referrer, currBytes, maxBytes, state IN (?1, ?2, ?3, ?4, ?5) AS isActive FROM moz_downloads ORDER BY isActive DESC, endTime DESC, startTime DESC, id ASC"	1	123	123	123	NA	123
"SELECT id,title, tags, url, frecency, rev_host,is_bookmark,last_visit_date,(word_0 * :idf0) + (url_0 * :idf0) + (tag_0 * :idf0) + (word_1 * :idf1) + (url_1 * :idf1) + (tag_1 * :idf1) + (word_2 * :idf2) + (url_2 * :idf2) + (tag_2 * :idf2) as score FROM (SELECT id, title, tags, url, frecency, rev_host, is_bookmark, last_visit_date,(title LIKE :left0) OR (title LIKE :right0) OR (CASE LOWER(title) WHEN :word0 THEN 1 ELSE 0 END) as word_0 , (url LIKE :submatch0) as url_0 , (tags LIKE :submatch0) as tag_0 , (title LIKE :left1) OR (title LIKE :right1) OR (CASE LOWER(title) WHEN :word1 THEN 1 ELSE 0 END) as word_1 , (url LIKE :submatch1) as url_1 , (tags LIKE :submatch1) as tag_1 , (title LIKE :left2) OR (title LIKE :right2) OR (CASE LOWER(title) WHEN :word2 THEN 1 ELSE 0 END) as word_2 , (url LIKE :submatch2) as url_2 , (tags LIKE :submatch2) as tag_2 FROM (SELECT * FROM (SELECT * FROM (SELECT p.id as id, 1 as is_bookmark, p.title as title, p.url as url, p.frecency as frecency, p.rev_host as rev_host, p.last_visit_date as last_visit_date, GROUP_CONCAT(tag) as tags FROM (SELECT t.title as tag, b.fk as place_id FROM (SELECT * FROM moz_bookmarks WHERE parent = :rowid) t JOIN (SELECT * FROM moz_bookmarks WHERE type=1) b ON b.parent=t.id) r JOIN moz_places p ON p.id=r.place_id GROUP BY p.id) UNION SELECT * FROM (SELECT p.id as id, 1 as is_bookmark, b.title as title, p.url as url, p.frecency as frecency, p.rev_host as rev_host, p.last_visit_date as last_visit_date, '' as tags FROM (SELECT * FROM moz_bookmarks WHERE title is not null and fk is not null) b JOIN moz_places p on p.id = b.fk WHERE p.url LIKE 'http%' AND p.title is not null AND p.last_visit_date is not null GROUP BY p.id) UNION SELECT id, 0 as is_bookmark, title, url, frecency, rev_host, last_visit_date, '' as tags FROM moz_places WHERE title is not null) GROUP BY id) WHERE (title LIKE :submatch0 OR url LIKE :submatch0 OR tags LIKE :submatch0 OR title LIKE :submatch1 OR url LIKE :submatch1 OR tags LIKE :submatch1 OR title LIKE :submatch2 OR url LIKE :submatch2 OR tags LIKE :submatch2) AND frecency > 250) ORDER BY is_bookmark DESC,score DESC,frecency DESC LIMIT 0,100"	1	383	383	383	NA	383
"SELECT id,title, tags, url, frecency, rev_host,is_bookmark,last_visit_date,(word_0 * :idf0) + (url_0 * :idf0) + (tag_0 * :idf0) + (word_1 * :idf1) + (url_1 * :idf1) + (tag_1 * :idf1) as score FROM (SELECT id, title, tags, url, frecency, rev_host, is_bookmark, last_visit_date,(title LIKE :left0) OR (title LIKE :right0) OR (CASE LOWER(title) WHEN :word0 THEN 1 ELSE 0 END) as word_0 , (url LIKE :submatch0) as url_0 , (tags LIKE :submatch0) as tag_0 , (title LIKE :left1) OR (title LIKE :right1) OR (CASE LOWER(title) WHEN :word1 THEN 1 ELSE 0 END) as word_1 , (url LIKE :submatch1) as url_1 , (tags LIKE :submatch1) as tag_1 FROM (SELECT * FROM (SELECT * FROM (SELECT p.id as id, 1 as is_bookmark, p.title as title, p.url as url, p.frecency as frecency, p.rev_host as rev_host, p.last_visit_date as last_visit_date, GROUP_CONCAT(tag) as tags FROM (SELECT t.title as tag, b.fk as place_id FROM (SELECT * FROM moz_bookmarks WHERE parent = :rowid) t JOIN (SELECT * FROM moz_bookmarks WHERE type=1) b ON b.parent=t.id) r JOIN moz_places p ON p.id=r.place_id GROUP BY p.id) UNION SELECT * FROM (SELECT p.id as id, 1 as is_bookmark, b.title as title, p.url as url, p.frecency as frecency, p.rev_host as rev_host, p.last_visit_date as last_visit_date, '' as tags FROM (SELECT * FROM moz_bookmarks WHERE title is not null and fk is not null) b JOIN moz_places p on p.id = b.fk WHERE p.url LIKE 'http%' AND p.title is not null AND p.last_visit_date is not null GROUP BY p.id) UNION SELECT id, 0 as is_bookmark, title, url, frecency, rev_host, last_visit_date, '' as tags FROM moz_places WHERE title is not null) GROUP BY id) WHERE (title LIKE :submatch0 OR url LIKE :submatch0 OR tags LIKE :submatch0 OR title LIKE :submatch1 OR url LIKE :submatch1 OR tags LIKE :submatch1) AND frecency > 250) ORDER BY is_bookmark DESC,score DESC,frecency DESC LIMIT 0,100"	1	674	674	674	NA	674
"SELECT url FROM moz_places WHERE last_visit_date > :cutoff_date ORDER BY frecency DESC LIMIT :max_results"	1	200	200	200	NA	200
"UPDATE moz_places SET frecency = (CASE WHEN url BETWEEN 'place:' AND 'place;' THEN 0 WHEN id IN (SELECT b.fk FROM moz_bookmarks b JOIN moz_bookmarks bp ON bp.id = b.parent JOIN moz_items_annos a ON a.item_id = bp.id JOIN moz_anno_attributes n ON n.id = a.anno_attribute_id WHERE b.fk = moz_places.id AND visit_count = 0 AND n.name = :anno_name) THEN 0 ELSE -1 END) WHERE id IN(13293,18222,18223,18224,18225,18226,18227,18228,18229,18231,18232,18235,18236,18237,18253,18254,18255,18256,18257,18258,18260,18261,18262,18263,18264,18265,18266,18267,18268,18269)"	1	166	166	166	NA	166
"UPDATE moz_places SET frecency = (CASE WHEN url BETWEEN 'place:' AND 'place;' THEN 0 WHEN id IN (SELECT b.fk FROM moz_bookmarks b JOIN moz_bookmarks bp ON bp.id = b.parent JOIN moz_items_annos a ON a.item_id = bp.id JOIN moz_anno_attributes n ON n.id = a.anno_attribute_id WHERE b.fk = moz_places.id AND visit_count = 0 AND n.name = :anno_name) THEN 0 ELSE -1 END) WHERE id IN(14926,12809,22400)"	1	143	143	143	NA	143
"UPDATE moz_places SET frecency = (CASE WHEN url BETWEEN 'place:' AND 'place;' THEN 0 WHEN id IN (SELECT b.fk FROM moz_bookmarks b JOIN moz_bookmarks bp ON bp.id = b.parent JOIN moz_items_annos a ON a.item_id = bp.id JOIN moz_anno_attributes n ON n.id = a.anno_attribute_id WHERE b.fk = moz_places.id AND visit_count = 0 AND n.name = :anno_name) THEN 0 ELSE -1 END) WHERE id IN(237)"	1	183	183	183	NA	183