New providers - Thai herbal compress

Inspiration - Thai herbal compress

Thai herbal compress New York
Thai herbal compress New York
Thai herbal compress New York
Thai herbal compress New York
Thai herbal compress New York
Thai herbal compress New York
Thai herbal compress New York
Thai herbal compress New York

Performance Profiler

15.78ms Page Time
2 MB Memory Peak
15 Queries
11.75ms 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.13ms 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.79ms 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.85ms 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.09ms 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.88ms 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.67ms App\Services\ServicePageService::getAggregateRating() [ServiceController.php:59]
7 SELECT ROUND(AVG(r.rating), 1) as avg_rating, COUNT(r.id) as review_count 0.7ms 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.66ms 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.39ms 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.01ms 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.69ms 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.4ms App\Core\Url::getTranslatedSlugs() [ServiceController.php:132]
-- LCP
-- FID
-- CLS
-- TTFB