Performance Profiler

9.18ms Page Time
2 MB Memory Peak
10 Queries
6.06ms SQL Time
SectionTotalAvgMemoryCalls
app_setup 0.63ms 0.63ms 243.1KB 1
#QueryTimeCaller
1 SELECT ct.id, ct.identifier, COALESCE(ctd.name, ct.identifier) as name, COALESCE(ctd.translated_slug, 0.8ms App\Controllers\Frontend\CategoryTypeController::findById() [CategoryTypeController.php:39]
2 SELECT c.id, c.identifier, COALESCE(cd.name, c.identifier) as name, COALESCE(cd.translated_slu 0.33ms App\Controllers\Frontend\CategoryTypeController::getCategoriesInType() [CategoryTypeController.php:51]
3 SELECT c.id, c.name, c.slug, co.slug as country_code, COUNT(DISTINCT l.id) as provider_count FROM citie 1.04ms App\Controllers\Frontend\CategoryTypeController::getCityLinks() [CategoryTypeController.php:54]
4 SELECT l.id, l.name, l.brand_slug, l.city_id, c.name as city_name, c.slug as city_slug, co.slug 0.28ms App\Controllers\Frontend\CategoryTypeController::getNewestProviders() [CategoryTypeController.php:57]
5 SELECT COUNT(DISTINCT l.id) as provider_count, COALESCE(AVG(r.rating), 0) as avg_rating, COUNT(r 1.15ms App\Controllers\Frontend\CategoryTypeController::getAggregateRating() [CategoryTypeController.php:60]
6 SELECT r.id, r.rating, r.comment, r.author_name, r.review_date, r.source, l.id as listing_id, l.name as listing_name, l.bra 0.91ms App\Controllers\Frontend\CategoryTypeController::getLatestReviews() [CategoryTypeController.php:63]
7 SELECT b.id, b.slug as blog_slug, b.featured_image, bd.title, b.created_at FROM blogs b INNER JOIN blogs_detai 0.19ms App\Controllers\Frontend\CategoryTypeController::getRelatedBlogs() [CategoryTypeController.php:64]
8 SELECT ct.id, ct.identifier, COALESCE(ctd.name, ct.identifier) as name, COALESCE(ctd.translated 0.76ms App\Controllers\Frontend\CategoryTypeController::getRelatedCategoryTypes() [CategoryTypeController.php:65]
9 SELECT f.id, fd.question, fd.answer FROM faqs f INNER JOIN faqs_detail fd ON fd.faqs_id = f.id AND fd.lang = ? 0.18ms App\Controllers\Frontend\CategoryTypeController::getFaqs() [CategoryTypeController.php:66]
10 SELECT lang, translated_slug FROM category_types_detail WHERE category_types_id = ? 0.42ms App\Core\Url::getTranslatedSlugs() [CategoryTypeController.php:119]
-- LCP
-- FID
-- CLS
-- TTFB