Buildings
The property itself - its architecture, age, character, space, setting and potential.
Property Search Settings
SQL Queries: 10 | Total: 5.77 ms
[0.69 ms] #1 | 0.69 ms | OK | sp_get_point
SELECT * FROM `BookmarkSearches`
WHERE
Search = 'buildings'
LIMIT 1
[75.47 ms] point_page: enter
[76.20 ms] #2 | 0.64 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 = 2138
ORDER BY
bsa.Sequence,
ba.Name
[76.48 ms] #3 | 0.26 ms | OK | point_page
SELECT Section FROM `BookmarkSearches` WHERE Section = 'buildings' GROUP BY Section
[76.71 ms] #4 | 0.22 ms | OK | point_page
SELECT Container FROM `BookmarkSearchesSections` WHERE Container = 'buildings'
[77.18 ms] #5 | 0.45 ms | OK
SELECT Search, SearchTitle FROM dafdebbf_HOMM.BookmarkSearches WHERE Level = 1 ORDER BY COALESCE(NULLIF(SearchTitle, ''), Search)
[77.52 ms] #6 | 0.25 ms | OK | getText
SELECT * FROM dafdebbf_HOMM.BookmarkTexts WHERE Point IN ('Buildings','')
[77.89 ms] #7 | 0.36 ms | OK | point_page
SELECT s.Search, s.SearchTitle, t.Description FROM dafdebbf_HOMM.BookmarkSearches s LEFT JOIN `BookmarkTexts` t ON t.Point = s.Search AND TextType = 2 WHERE Section = 'buildings' ORDER BY Search
[88.60 ms] #8 | 0.48 ms | OK
SELECT Search
FROM dafdebbf_HOMM.BookmarkSearches
WHERE
Level = 1
ORDER BY Search
[88.90 ms] #9 | 0.28 ms | OK
SELECT Name, Slug
FROM dafdebbf_HOMM.BookmarkAreas
ORDER BY Sequence DESC, Name
[91.10 ms] #10 | 2.15 ms | OK
SELECT Search, SearchTitle
FROM dafdebbf_HOMM.BookmarkSearches
WHERE
Level = 0
AND LOWER(Section) = 'buildings'
ORDER BY Search