XVII. kerület - Rákosmente

Find the best providers near XVII. kerület - Rákosmente

0 providers

No providers yet

There are no registered providers in this district yet. Check back soon or browse nearby areas.

Section

Total

Avg

Memory

Calls

app_setup

0.69ms

243.1KB

Query

Time

Caller

SELECT c.id, c.name, c.slug, c.latitude, c.longitude, co.id as country_id, co.slug as country_code,

0.84ms

App\Services\ListingPageService::findCityById() [ListingController.php:59]

SELECT ct.id, ct.identifier, ctd.name, ctd.translated_slug, ctd.search_tags, ctd.seo_title, ctd

0.65ms

App\Services\ListingPageService::findCategoryTypeByIdentifier() [ListingController.php:109]

SELECT d.*, c.name AS city_name, c.slug AS city_slug, co.slug AS country_code, co.name AS country_name FROM districts

0.63ms

App\Repositories\DistrictRepository::findBySlugWithDetail() [DistrictPageService.php:28]

SELECT * FROM districts_detail WHERE districts_id = ? AND lang = ?

0.38ms

App\Repositories\DistrictRepository::findBySlugWithDetail() [DistrictPageService.php:28]

SELECT COUNT(*) FROM listings WHERE district_id = ? AND status = 'active' AND storno = 'f'

0.54ms

App\Repositories\DistrictRepository::countListingsInDistrict() [DistrictPageService.php:38]

SELECT l.id, l.name, l.brand_slug, l.cover_image, l.rating_avg AS avg_rating, l.review_count, l.address, l.cit

0.25ms

App\Repositories\DistrictRepository::getListingsInDistrict() [DistrictPageService.php:43]

SELECT d.id, d.name, d.slug FROM districts d WHERE d.city_id = ? AND d.id != ? AND d.storno = 'f' ORDER BY d.so

0.65ms

App\Repositories\DistrictRepository::getSiblingDistricts() [DistrictPageService.php:58]

SELECT name FROM countries WHERE slug = ?

0.34ms

App\Services\Seo\BreadcrumbService::getCountryNameFromCode() [BreadcrumbService.php:194]