New providers - Linux system administration

Inspiration - Linux system administration

Linux system administration Pécs
Linux system administration Los Angeles
Linux system administration Komló
Linux system administration Budapest
Linux system administration Szeged
Linux system administration New York
Linux system administration Budapest
Linux system administration Budapest

Performance Profiler

16.17ms Page Time
2 MB Memory Peak
15 Queries
12.43ms SQL Time
SectionTotalAvgMemoryCalls
app_setup 0.64ms 0.64ms 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.01ms 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.78ms 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.71ms 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.06ms 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.85ms 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.65ms 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.87ms 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.76ms 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.31ms App\Services\ServicePageService::getRelatedBlogs() [ServiceController.php:66]
11 SELECT category_id FROM service_items WHERE id = ? 0.35ms 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.99ms 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.66ms App\Repositories\FaqRepository::getForService() [FaqService.php:69]
14 SELECT page_type, title_template, description_template, h1_template FROM seo_templates WHERE lang = ? 0.4ms 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