Filtros

Filtros

Performance Profiler

14.61ms Page Time
2 MB Memory Peak
16 Queries
10.58ms SQL Time
SectionTotalAvgMemoryCalls
app_setup 0.71ms 0.71ms 243.1KB 1
#QueryTimeCaller
1 SELECT c.id, c.name, c.slug, c.latitude, c.longitude, co.id as country_id, co.slug as country_code, 0.77ms App\Services\ListingPageService::findCityById() [ListingController.php:59]
2 SELECT si.id, si.category_id, si.identifier, sid.name, sid.translated_slug, sid.seo_title, sid.seo_description, sid.h1, 0.63ms App\Services\ListingPageService::findServiceById() [ListingController.php:133]
3 SELECT category_id FROM service_items WHERE id = ? AND storno = 'f' 0.56ms App\Services\ListingPageService::getProviders() [ListingController.php:236]
4 SELECT DISTINCT listing_id FROM listing_promotions WHERE promotion_type = 'top_placement' AND status 0.28ms App\Services\ListingPageService::getBoostedAndHighlightedIds() [ListingPageService.php:281]
5 SELECT DISTINCT listing_id FROM listing_promotions WHERE promotion_type = 'highlight' AND status 0.68ms App\Services\ListingPageService::getBoostedAndHighlightedIds() [ListingPageService.php:281]
6 SELECT COUNT(DISTINCT l.id) FROM listing_services ls INNER JOIN listings l ON l.id = ls.listing_id A 0.85ms App\Services\ListingPageService::getProviders() [ListingController.php:236]
7 SELECT l.id, l.name, l.brand_slug, l.address, l.image, l.cover_image, l.city_id, c.name as city_name, 1.56ms App\Services\ListingPageService::getProviders() [ListingController.php:236]
8 SELECT AVG(r.rating) as avg_rating, COUNT(r.id) as review_count, COUNT(DISTIN 0.7ms App\Services\ListingPageService::getAggregateRating() [ListingController.php:245]
9 SELECT si.id, sid.name, sid.translated_slug, COUNT(DISTINCT l.id) as provider_count 1.06ms App\Services\ListingPageService::getRelatedServices() [ListingController.php:246]
10 SELECT latitude, longitude FROM cities WHERE id = ? 0.34ms App\Services\ListingPageService::getNearbyCities() [ListingController.php:252]
11 SELECT c.id, c.name, c.slug, co.slug as country_code, COUNT(DISTINCT l.id) as 0.99ms App\Services\ListingPageService::getNearbyCities() [ListingController.php:252]
12 SELECT MIN(lso.price) as min_price, MAX(lso.price) as max_price FROM listing_servi 0.63ms App\Services\ListingPageService::getFilterOptions() [ListingController.php:253]
13 SELECT DISTINCT a.id, a.identifier, a.icon, COALESCE(ad.name, a.identifier) as name FROM amenities a 0.24ms App\Services\ListingPageService::getAvailableAmenities() [ListingController.php:254]
14 SELECT name FROM countries WHERE slug = ? 0.34ms App\Services\Seo\BreadcrumbService::getCountryNameFromCode() [BreadcrumbService.php:194]
15 SELECT page_type, title_template, description_template, h1_template FROM seo_templates WHERE lang = ? 0.37ms App\Repositories\SeoTemplateRepository::getAllByLang() [SeoTemplateService.php:167]
16 SELECT lang, translated_slug FROM service_items_detail WHERE service_items_id = ? 0.57ms App\Core\Url::getTranslatedSlugs() [ListingController.php:301]
-- LCP
-- FID
-- CLS
-- TTFB