[0.47 ms] #1 | 0.46 ms | OK | sp_get_point
SELECT * FROM `BookmarkSearches`
WHERE
Search = 'houses'
LIMIT 1
[89.59 ms] point_page: enter
[90.21 ms] #2 | 0.52 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 = 2135
ORDER BY
bsa.Sequence,
ba.Name
[90.48 ms] #3 | 0.26 ms | OK | point_page
SELECT Section FROM `BookmarkSearches` WHERE Section = 'houses' GROUP BY Section
[90.70 ms] #4 | 0.22 ms | OK | point_page
SELECT Container FROM `BookmarkSearchesSections` WHERE Container = 'houses'
[91.25 ms] #5 | 0.52 ms | OK
SELECT Search, SearchTitle FROM dafdebbf_HOMM.BookmarkSearches WHERE Level = 1 ORDER BY COALESCE(NULLIF(SearchTitle, ''), Search)
[91.60 ms] #6 | 0.26 ms | OK | getText
SELECT * FROM dafdebbf_HOMM.BookmarkTexts WHERE Point IN ('Houses','')
[92.23 ms] #7 | 0.62 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 = 'houses' ORDER BY Search
[117.28 ms] #8 | 0.55 ms | OK
SELECT Search
FROM dafdebbf_HOMM.BookmarkSearches
WHERE
Level = 1
ORDER BY Search
[117.68 ms] #9 | 0.36 ms | OK
SELECT Name, Slug
FROM dafdebbf_HOMM.BookmarkAreas
ORDER BY Sequence DESC, Name
[120.25 ms] #10 | 2.51 ms | OK
SELECT Search, SearchTitle
FROM dafdebbf_HOMM.BookmarkSearches
WHERE
Level = 0
AND LOWER(Section) = 'houses'
ORDER BY Search
