Provider #1173
Dog training & EducationStreet 1173, City
29 providers in New York
Street 1173, City
Street 165, City
Street 3165, City
Street 1167, City
Street 4167, City
Street 2169, City
Street 171, City
Street 3171, City
Street 1179, City
Street 3177, City
Street 177, City
Street 4179, City
Register and get new clients through Locabee!
Register for free| Section | Total | Avg | Memory | Calls |
|---|---|---|---|---|
| app_setup | 0.68ms | 0.68ms | 242.5KB | 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, | 1.03ms | App\Services\ListingPageService::findCityById() [ListingController.php:59] | |
| 2 | SELECT ct.id, ct.identifier, ctd.name, ctd.translated_slug, ctd.search_tags, ctd.seo_title, ctd | 0.61ms | App\Services\ListingPageService::findCategoryTypeById() [ListingController.php:749] | |
| 3 | SELECT c.id, c.identifier, c.image, cd.name, cd.translated_slug, cd.seo_description FROM categories c JOIN categories_detail | 0.77ms | App\Repositories\CategoryTypeRepository::getCategoriesForType() [ListingController.php:767] | |
| 4 | SELECT COUNT(DISTINCT l.id) FROM listings l WHERE l.city_id = ? | 2.04ms | App\Repositories\ProviderRepository::findByCategoryTypeFiltered() [ListingController.php:832] | |
| 5 | SELECT DISTINCT l.id, l.name, l.brand_slug, l.image, l.address, l.phone, l.city_id, ci.slug as city_slug, co.slug as country_co | 3.82ms | App\Repositories\ProviderRepository::findByCategoryTypeFiltered() [ListingController.php:832] | |
| 6 | SELECT MIN(lso.price) as min_price, MAX(lso.price) as max_price FROM listing_service_offerings | 0.75ms | App\Repositories\ProviderRepository::getFilterOptionsForCategoryType() [ListingController.php:841] | |
| 7 | SELECT DISTINCT a.id, a.identifier, a.icon, COALESCE(ad.name, a.identifier) as name FROM amenities a | 0.3ms | App\Repositories\ProviderRepository::getAvailableAmenitiesForCategoryType() [ListingController.php:844] | |
| 8 | SELECT name FROM countries WHERE slug = ? | 0.35ms | App\Services\Seo\BreadcrumbService::getCountryNameFromCode() [BreadcrumbService.php:194] | |
| 9 | SELECT lang, translated_slug FROM category_types_detail WHERE category_types_id = ? | 0.43ms | App\Core\Url::getTranslatedSlugs() [ListingController.php:898] |
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.