SELECT Name, Slug
FROM dafdebbf_HOMM.BookmarkAreas
ORDER BY Sequence DESC, Name
SQL Queries: 15 | Total: 32.05 ms
[0.46 ms] #1 | 0.46 ms | OK | sp_get_point
SELECT * FROM `BookmarkSearches` WHERE Search = 'brsk' LIMIT 1
[98.86 ms] point_page: enter
[100.44 ms] #2 | 1.46 ms | OK
SELECT
ba.Id,
ba.Name,
ba.LegacyAreaId,
bsa.Sequence,
ba.LocationIdentifier
FROM BookmarkSearchAreas bsa
INNER JOIN BookmarkAreas ba
ON ba.Id = bsa.AreaId
WHERE bsa.SearchId = 2644
ORDER BY
bsa.Sequence,
ba.Name
[100.89 ms] #3 | 0.43 ms | OK | point_page
SELECT Id AS id, Name AS name, LocationIdentifier AS RMLocation FROM `BookmarkAreas` WHERE LOWER(Slug) = 'greatermanchester' OR LOWER(Name) = 'greatermanchester'
[102.50 ms] #4 | 1.54 ms | OK | getText
SELECT * FROM dafdebbf_HOMM.BookmarkTexts WHERE Point IN ('brsk','Broadband')
[102.94 ms] #5 | 0.37 ms | OK
SELECT
ba.Id,
ba.Name,
ba.LegacyAreaId,
bsa.Sequence,
ba.LocationIdentifier
FROM BookmarkSearchAreas bsa
INNER JOIN BookmarkAreas ba
ON ba.Id = bsa.AreaId
WHERE bsa.SearchId = 2644
ORDER BY
bsa.Sequence,
ba.Name
[103.28 ms] #6 | 0.31 ms | OK
SELECT Name AS name, Slug AS value FROM dafdebbf_HOMM.BookmarkAreas ORDER BY Sequence DESC, Name
[103.80 ms] #7 | 0.38 ms | OK
SELECT Search, SearchTitle, Section FROM dafdebbf_HOMM.BookmarkSearches WHERE Section = 'broadband' ORDER BY Search
[104.33 ms] #8 | 0.44 ms | OK
SELECT Search, SearchTitle FROM dafdebbf_HOMM.BookmarkSearches WHERE Level = 1 ORDER BY COALESCE(NULLIF(SearchTitle, ''), Search)
[104.49 ms] sp_point_properties: BEFORE READLIST
[906.13 ms] sp_point_properties: BEFORE GET CONTENT
[906.41 ms] sp_point_properties: BEFORE END
[910.43 ms] #9 | 3.98 ms | OK
INSERT INTO BookmarkPointSearches
(
Point,
CountyId,
Tenure,
Portal,
MaxPrice,
PropertyCount,
VisitorHash,
Source
)
VALUES
(
'Brsk',
58,
'sale',
'rightmove',
0,
3,
'c2786a9017f8c5d7aba3430177b3f3afd37cbc04db0a0eab272acdf4e36791cc',
'point'
)
ON DUPLICATE KEY UPDATE
SearchCount = SearchCount + 1,
PropertyCount = VALUES(PropertyCount),
LastSeen = CURRENT_TIMESTAMP
[910.88 ms] #10 | 0.43 ms | OK
SELECT Name AS name, Slug AS value FROM dafdebbf_HOMM.BookmarkAreas ORDER BY Sequence DESC, Name
[911.55 ms] #11 | 0.55 ms | OK
SELECT Search, SearchTitle, Section FROM dafdebbf_HOMM.BookmarkSearches WHERE Section = 'broadband' ORDER BY Search
[912.27 ms] #12 | 0.63 ms | OK
SELECT Search, SearchTitle FROM dafdebbf_HOMM.BookmarkSearches WHERE Level = 1 ORDER BY COALESCE(NULLIF(SearchTitle, ''), Search)
[912.43 ms] point_page: exit
[961.65 ms] #13 | 11.69 ms | OK
SELECT Search
FROM dafdebbf_HOMM.BookmarkSearches
WHERE
Level = 1
ORDER BY Search
[966.90 ms] #14 | 5.20 ms | OK
SELECT Name, Slug
FROM dafdebbf_HOMM.BookmarkAreas
ORDER BY Sequence DESC, Name
[971.19 ms] #15 | 4.17 ms | OK
SELECT Search, SearchTitle
FROM dafdebbf_HOMM.BookmarkSearches
WHERE
Level = 0
AND LOWER(Section) = 'broadband'
ORDER BY Search
