Performance Profiler

17.7ms Page Time
2 MB Memory Peak
10 Queries
14.33ms SQL Time
SectionTotalAvgMemoryCalls
app_setup 0.8ms 0.8ms 242.5KB 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.57ms 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 7.33ms 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.29ms 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 2.96ms 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.9ms 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.2ms 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.69ms 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.17ms 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