Inspiration - Manual extraction

Manual extraction Komló
Manual extraction Budapest
Manual extraction Budapest
Manual extraction Komló
Manual extraction Komló
Manual extraction New York
Manual extraction Komló
Manual extraction Los Angeles

Performance Profiler

15.36ms Page Time
2 MB Memory Peak
15 Queries
11.9ms SQL Time
SectionTotalAvgMemoryCalls
app_setup 0.7ms 0.7ms 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.07ms 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.68ms 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 0.94ms 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.83ms 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.58ms App\Services\ServicePageService::getAggregateRating() [ServiceController.php:59]
7 SELECT ROUND(AVG(r.rating), 1) as avg_rating, COUNT(r.id) as review_count 0.59ms 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.77ms 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.63ms 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.29ms App\Services\ServicePageService::getRelatedBlogs() [ServiceController.php:66]
11 SELECT category_id FROM service_items WHERE id = ? 0.36ms 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 1.96ms 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.65ms App\Repositories\FaqRepository::getForService() [FaqService.php:69]
14 SELECT page_type, title_template, description_template, h1_template FROM seo_templates WHERE lang = ? 0.36ms App\Repositories\SeoTemplateRepository::getAllByLang() [SeoTemplateService.php:167]
15 SELECT lang, translated_slug FROM service_items_detail WHERE service_items_id = ? 0.43ms App\Core\Url::getTranslatedSlugs() [ServiceController.php:132]
-- LCP
-- FID
-- CLS
-- TTFB