SQL Queries: 19 | Total: 19.02 ms
[0.68 ms] #1 | 0.68 ms | OK | sp_get_point
SELECT * FROM `BookmarkSearches`
WHERE
Search = 'history'
LIMIT 1
[109.31 ms] point_page: enter
[110.34 ms] #2 | 0.88 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 = 7980
ORDER BY
bsa.Sequence,
ba.Name
[110.84 ms] #3 | 0.46 ms | OK | point_page
SELECT Section FROM `BookmarkSearches` WHERE Section = 'history' GROUP BY Section
[111.40 ms] #4 | 0.54 ms | OK | point_page
SELECT Container FROM `BookmarkSearchesSections` WHERE Container = 'history'
[111.95 ms] #5 | 0.50 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 = 7980
ORDER BY
bsa.Sequence,
ba.Name
[112.81 ms] #6 | 0.80 ms | OK
SELECT Search, SearchTitle FROM dafdebbf_HOMM.BookmarkSearches WHERE Level = 1 ORDER BY COALESCE(NULLIF(SearchTitle, ''), Search)
[113.94 ms] #7 | 1.02 ms | OK
SELECT Search, SearchTitle, Section FROM dafdebbf_HOMM.BookmarkSearches WHERE Section = 'history' ORDER BY Search
[114.71 ms] #8 | 0.52 ms | OK
SELECT Name AS name, Slug AS value FROM dafdebbf_HOMM.BookmarkAreas ORDER BY Sequence DESC, Name
[119.12 ms] #9 | 4.03 ms | OK | point_page
SELECT s.*, sec.Description AS SectionDescription FROM dafdebbf_HOMM.BookmarkSearches s LEFT JOIN dafdebbf_HOMM.BookmarkSearchesSections sec ON sec.Section = s.Section WHERE s.Section = 'history' ORDER BY Search
[119.88 ms] #10 | 0.46 ms | OK | point_page
SELECT Id AS id, Name AS name, LocationIdentifier AS RMLocation FROM `BookmarkAreas` WHERE LOWER(Slug) = 'surrey' OR LOWER(Name) = 'surrey'
[120.41 ms] #11 | 0.40 ms | OK | getText
SELECT * FROM dafdebbf_HOMM.BookmarkTexts WHERE Point IN ('History','Buildings')
[120.98 ms] #12 | 0.50 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 = 7980
ORDER BY
bsa.Sequence,
ba.Name
[121.72 ms] #13 | 0.69 ms | OK
SELECT Search, SearchTitle FROM dafdebbf_HOMM.BookmarkSearches WHERE Level = 1 ORDER BY COALESCE(NULLIF(SearchTitle, ''), Search)
[122.89 ms] #14 | 1.02 ms | OK
SELECT Search, SearchTitle, Section FROM dafdebbf_HOMM.BookmarkSearches WHERE Section = 'history' ORDER BY Search
[123.58 ms] #15 | 0.42 ms | OK
SELECT Name AS name, Slug AS value FROM dafdebbf_HOMM.BookmarkAreas ORDER BY Sequence DESC, Name
[124.23 ms] sp_point_properties: BEFORE READLIST
[126.32 ms] #16 | 2.04 ms | OK
INSERT INTO BookmarkPointSearches
(
Point,
CountyId,
Tenure,
Portal,
MaxPrice,
PropertyCount,
VisitorHash,
Source
)
VALUES
(
'History',
124,
'sale',
'rightmove',
0,
0,
'c2786a9017f8c5d7aba3430177b3f3afd37cbc04db0a0eab272acdf4e36791cc',
'point'
)
ON DUPLICATE KEY UPDATE
SearchCount = SearchCount + 1,
PropertyCount = VALUES(PropertyCount),
LastSeen = CURRENT_TIMESTAMP
[126.34 ms] point_page: exit
[144.75 ms] #17 | 0.60 ms | OK
SELECT Search
FROM dafdebbf_HOMM.BookmarkSearches
WHERE
Level = 1
ORDER BY Search
[145.15 ms] #18 | 0.37 ms | OK
SELECT Name, Slug
FROM dafdebbf_HOMM.BookmarkAreas
ORDER BY Sequence DESC, Name
[148.29 ms] #19 | 3.09 ms | OK
SELECT Search, SearchTitle
FROM dafdebbf_HOMM.BookmarkSearches
WHERE
Level = 0
AND LOWER(Section) = 'history'
ORDER BY Search
