Provider #211
Street 211, City
9 providers in Budapest
Register and get new clients through Locabee!
Register for free| Section | Total | Avg | Memory | Calls |
|---|---|---|---|---|
| cat_providers | 3.58ms | 3.58ms | 16.4KB | 1 |
| cat_related | 0.73ms | 0.73ms | 3.1KB | 1 |
| cat_details | 0.67ms | 0.67ms | 1.5KB | 1 |
| app_setup | 0.67ms | 0.67ms | 243.1KB | 1 |
| # | Query | Time | Caller | |
|---|---|---|---|---|
| 1 | SELECT c.id, c.name, c.slug, c.latitude, c.longitude, co.id as country_id, co.slug as country_code, | 0.79ms | App\Services\ListingPageService::findCityById() [ListingController.php:59] | |
| 2 | SELECT c.id, c.category_type_id, c.image, c.identifier, cd.name, cd.translated_slug, cd.seo_title, cd.seo_description, | 0.64ms | App\Services\ListingPageService::findCategoryById() [ListingController.php:543] | |
| 3 | SELECT DISTINCT listing_id FROM listing_promotions WHERE promotion_type = 'top_placement' AND status | 0.24ms | App\Services\ListingPageService::getBoostedAndHighlightedIds() [ListingPageService.php:861] | |
| 4 | SELECT DISTINCT listing_id FROM listing_promotions WHERE promotion_type = 'highlight' AND status | 0.6ms | App\Services\ListingPageService::getBoostedAndHighlightedIds() [ListingPageService.php:861] | |
| 5 | SELECT COUNT(DISTINCT l.id) FROM listings l INNER JOIN listing_categories lc ON lc.listing_id = l.id | 0.92ms | App\Services\ListingPageService::getProvidersByCategoryFiltered() [ListingController.php:620] | |
| 6 | SELECT DISTINCT l.id, l.name, l.brand_slug, l.image, l.address, l.phone, l.cover_image, l.city_id, (SE | 1.74ms | App\Services\ListingPageService::getProvidersByCategoryFiltered() [ListingController.php:620] | |
| 7 | SELECT si.id, sid.name, sid.translated_slug FROM service_items si JOIN service_items_detail sid ON sid.service_items | 0.71ms | App\Services\ListingPageService::getServicesInCategory() [ListingController.php:629] | |
| 8 | SELECT MIN(lso.price) as min_price, MAX(lso.price) as max_price FROM listing_servi | 0.69ms | App\Services\ListingPageService::getFilterOptionsForCategory() [ListingController.php:632] | |
| 9 | SELECT page_type, title_template, description_template, h1_template FROM seo_templates WHERE lang = ? | 0.36ms | App\Repositories\SeoTemplateRepository::getAllByLang() [SeoTemplateService.php:167] | |
| 10 | SELECT DISTINCT a.id, a.identifier, a.icon, COALESCE(ad.name, a.identifier) as name FROM amenities a | 0.27ms | App\Services\ListingPageService::getAvailableAmenitiesForCategory() [ListingController.php:651] | |
| 11 | SELECT name FROM countries WHERE slug = ? | 0.34ms | App\Services\Seo\BreadcrumbService::getCountryNameFromCode() [BreadcrumbService.php:194] | |
| 12 | SELECT lang, translated_slug FROM categories_detail WHERE categories_id = ? | 0.46ms | App\Core\Url::getTranslatedSlugs() [ListingController.php:671] |
Join thousands of users discovering the best styles.
Log in or create a new account in seconds.
Create your provider account and start growing.
Choose your preferred region and language for the best experience.