New providers - Statutory financial audit

Inspiration - Statutory financial audit

Statutory financial audit New York
Statutory financial audit Komló
Statutory financial audit Szeged
Statutory financial audit Komló
Statutory financial audit Budapest
Statutory financial audit Komló
Statutory financial audit Los Angeles
Statutory financial audit New York

Performance Profiler

17.62ms Page Time
2 MB Memory Peak
15 Queries
13.65ms SQL Time
SectionTotalAvgMemoryCalls
app_setup 0.75ms 0.75ms 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.29ms 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.82ms 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.02ms 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.79ms 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.59ms App\Services\ServicePageService::getAggregateRating() [ServiceController.php:59]
7 SELECT ROUND(AVG(r.rating), 1) as avg_rating, COUNT(r.id) as review_count 0.84ms 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.74ms 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.65ms 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.45ms 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 2.82ms 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.78ms App\Repositories\FaqRepository::getForService() [FaqService.php:69]
14 SELECT page_type, title_template, description_template, h1_template FROM seo_templates WHERE lang = ? 0.38ms 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