SELECT Name, Slug
FROM dafdebbf_HOMM.BookmarkAreas
ORDER BY Sequence DESC, Name
SQL Queries: 15 | Total: 18.22 ms
[0.57 ms] #1 | 0.57 ms | OK | sp_get_point
SELECT * FROM `BookmarkSearches` WHERE Search = 'b4rn' LIMIT 1
[103.71 ms] point_page: enter
[104.42 ms] #2 | 0.60 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 = 2642
ORDER BY
bsa.Sequence,
ba.Name
[104.86 ms] #3 | 0.41 ms | OK | point_page
SELECT Id AS id, Name AS name, LocationIdentifier AS RMLocation FROM `BookmarkAreas` WHERE LOWER(Slug) = 'norfolk' OR LOWER(Name) = 'norfolk'
[105.36 ms] #4 | 0.42 ms | OK | getText
SELECT * FROM dafdebbf_HOMM.BookmarkTexts WHERE Point IN ('B4RN','Broadband')
[106.52 ms] #5 | 1.09 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 = 2642
ORDER BY
bsa.Sequence,
ba.Name
[107.57 ms] #6 | 1.02 ms | OK
SELECT Name AS name, Slug AS value FROM dafdebbf_HOMM.BookmarkAreas ORDER BY Sequence DESC, Name
[114.99 ms] #7 | 7.28 ms | OK
SELECT Search, SearchTitle, Section FROM dafdebbf_HOMM.BookmarkSearches WHERE Section = 'broadband' ORDER BY Search
[115.71 ms] #8 | 0.64 ms | OK
SELECT Search, SearchTitle FROM dafdebbf_HOMM.BookmarkSearches WHERE Level = 1 ORDER BY COALESCE(NULLIF(SearchTitle, ''), Search)
[115.97 ms] sp_point_properties: BEFORE READLIST
[568.11 ms] sp_point_properties: BEFORE GET CONTENT
[568.47 ms] sp_point_properties: BEFORE END
[569.60 ms] #9 | 1.08 ms | OK
INSERT INTO BookmarkPointSearches
(
Point,
CountyId,
Tenure,
Portal,
MaxPrice,
PropertyCount,
VisitorHash,
Source
)
VALUES
(
'B4rn',
97,
'sale',
'rightmove',
0,
2,
'c2786a9017f8c5d7aba3430177b3f3afd37cbc04db0a0eab272acdf4e36791cc',
'point'
)
ON DUPLICATE KEY UPDATE
SearchCount = SearchCount + 1,
PropertyCount = VALUES(PropertyCount),
LastSeen = CURRENT_TIMESTAMP
[569.99 ms] #10 | 0.37 ms | OK
SELECT Name AS name, Slug AS value FROM dafdebbf_HOMM.BookmarkAreas ORDER BY Sequence DESC, Name
[570.63 ms] #11 | 0.47 ms | OK
SELECT Search, SearchTitle, Section FROM dafdebbf_HOMM.BookmarkSearches WHERE Section = 'broadband' ORDER BY Search
[571.26 ms] #12 | 0.53 ms | OK
SELECT Search, SearchTitle FROM dafdebbf_HOMM.BookmarkSearches WHERE Level = 1 ORDER BY COALESCE(NULLIF(SearchTitle, ''), Search)
[571.60 ms] point_page: exit
[584.37 ms] #13 | 0.49 ms | OK
SELECT Search
FROM dafdebbf_HOMM.BookmarkSearches
WHERE
Level = 1
ORDER BY Search
[584.69 ms] #14 | 0.29 ms | OK
SELECT Name, Slug
FROM dafdebbf_HOMM.BookmarkAreas
ORDER BY Sequence DESC, Name
[587.71 ms] #15 | 2.96 ms | OK
SELECT Search, SearchTitle
FROM dafdebbf_HOMM.BookmarkSearches
WHERE
Level = 0
AND LOWER(Section) = 'broadband'
ORDER BY Search
