New providers - Construction waste removal

Inspiration - Construction waste removal

Construction waste removal Budapest
Construction waste removal Budapest
Construction waste removal Pécs
Construction waste removal Szeged
Construction waste removal Szeged
Construction waste removal New York
Construction waste removal Szeged
Construction waste removal Komló

Performance Profiler

17.1ms Page Time
2 MB Memory Peak
15 Queries
13.12ms SQL Time
SectionTotalAvgMemoryCalls
app_setup 0.65ms 0.65ms 243.1KB 1
#QueryTimeCaller
1 SELECT si.*, si.identifier, sid.name, sid.translated_slug, sid.seo_title, sid.seo_description, sid.seo_keywords, sid.h1, s 1.26ms App\Services\ServicePageService::findById() [ContentController.php:54]
2 SELECT si.*, si.identifier, sid.name, sid.translated_slug, sid.seo_title, sid.seo_description, sid.seo_keywords, sid.h1, s 0.76ms App\Services\ServicePageService::findById() [ServiceController.php:38]
3 SELECT h.*, hd.header, hd.subheader FROM hero_items h LEFT JOIN hero_items_detail hd ON hd.hero_items_id = h.id AND hd 0.73ms App\Repositories\HeroRepository::findByServiceItemId() [ServiceController.php:54]
4 SELECT c.id, c.name, c.slug, co.slug as country_code, COUNT(DISTINCT l.id) as provider_count FROM listi 1.07ms App\Services\ServicePageService::getCityLinks() [ServiceController.php:57]
5 SELECT l.id, l.name, l.brand_slug as slug, l.address as short_description, c.id as city_id, c.name as city_name, c.slug as 0.82ms App\Services\ServicePageService::getNewestProviders() [ServiceController.php:58]
6 SELECT COUNT(DISTINCT l.id) as provider_count FROM listing_services ls INNER JOIN listings l ON l.id = ls.list 0.6ms App\Services\ServicePageService::getAggregateRating() [ServiceController.php:59]
7 SELECT ROUND(AVG(r.rating), 1) as avg_rating, COUNT(r.id) as review_count 0.63ms App\Services\ServicePageService::getAggregateRating() [ServiceController.php:59]
8 SELECT r.id, r.author_name, r.author_avatar, r.rating, r.comment, r.review_date, r.source, l.id 0.71ms App\Services\ServicePageService::getLatestReviews() [ServiceController.php:60]
9 SELECT si.id, si.identifier, sid.name, sid.translated_slug FROM service_items si INNER JOIN service_items_deta 0.86ms App\Services\ServicePageService::getRelatedServices() [ServiceController.php:61]
10 SELECT b.id, b.identifier, b.featured_image, b.created_at, bd.title, bd.slug as blog_slug FROM blogs b 1.33ms App\Services\ServicePageService::getRelatedBlogs() [ServiceController.php:66]
11 SELECT category_id FROM service_items WHERE id = ? 0.53ms App\Services\ServicePageService::getInspiration() [ServiceController.php:67]
12 SELECT lg.id, lg.image_path as image, l.name as listing_name, l.brand_slug, c.id as city_id, c.n 2.2ms App\Services\ServicePageService::getInspiration() [ServiceController.php:67]
13 SELECT f.*, fd.question, fd.answer FROM faqs f INNER JOIN faqs_detail fd ON fd.faq_id = f.id AND fd.lang = ? 0.81ms App\Repositories\FaqRepository::getForService() [FaqService.php:69]
14 SELECT page_type, title_template, description_template, h1_template FROM seo_templates WHERE lang = ? 0.39ms App\Repositories\SeoTemplateRepository::getAllByLang() [SeoTemplateService.php:167]
15 SELECT lang, translated_slug FROM service_items_detail WHERE service_items_id = ? 0.42ms App\Core\Url::getTranslatedSlugs() [ServiceController.php:132]
-- LCP
-- FID
-- CLS
-- TTFB