| 1 |
|
SELECT c.*, cd.name, cd.translated_slug, cd.seo_title, cd.seo_description,
cd.seo_keywords, cd.h1, cd.intro_content,
|
0.96ms |
App\Services\CategoryPageService::findById() [ContentController.php:48] |
| 2 |
|
SELECT c.*, cd.name, cd.translated_slug, cd.seo_title, cd.seo_description,
cd.seo_keywords, cd.h1, cd.intro_content,
|
0.88ms |
App\Services\CategoryPageService::findById() [CategoryController.php:38] |
| 3 |
|
SELECT si.id, si.identifier, sid.name, sid.translated_slug
FROM service_items si
INNER JOIN service_items_deta |
1.02ms |
App\Services\CategoryPageService::getServicesInCategory() [CategoryController.php:53] |
| 4 |
|
SELECT c.id, c.name, c.slug, co.slug as country_code,
COUNT(l.id) as provider_count
FROM cities c
|
3.37ms |
App\Services\CategoryPageService::getCityLinks() [CategoryController.php:54] |
| 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 |
4.67ms |
App\Services\CategoryPageService::getNewestProviders() [CategoryController.php:55] |
| 6 |
|
SELECT COUNT(DISTINCT l.id) as provider_count
FROM listings l
INNER JOIN listing_categories lc ON lc.listing_i |
1.27ms |
App\Services\CategoryPageService::getAggregateRating() [CategoryController.php:56] |
| 7 |
|
SELECT
ROUND(AVG(r.rating), 1) as avg_rating,
COUNT(r.id) as review_count
|
2.55ms |
App\Services\CategoryPageService::getAggregateRating() [CategoryController.php:56] |
| 8 |
|
SELECT r.id, r.author_name, r.author_avatar, r.rating, r.comment,
r.review_date, r.source,
l.id |
1.29ms |
App\Services\CategoryPageService::getLatestReviews() [CategoryController.php:57] |
| 9 |
|
SELECT DISTINCT b.id, b.identifier, b.featured_image, b.created_at,
bd.title, bd.slug as blog_slug
FROM |
2.67ms |
App\Services\CategoryPageService::getRelatedBlogs() [CategoryController.php:58] |
| 10 |
|
SELECT * FROM categories WHERE id = ? AND storno = 'f' |
1.02ms |
App\Repositories\CategoryRepository::findById() [CategoryPageService.php:241] |
| 11 |
|
SELECT * FROM categories_detail WHERE categories_id = ? |
0.62ms |
App\Repositories\CategoryRepository::findById() [CategoryPageService.php:241] |
| 12 |
|
SELECT c.id, c.identifier, cd.name, cd.translated_slug
FROM categories c
INNER JOIN categories_detail cd ON cd |
1.23ms |
App\Services\CategoryPageService::getRelatedCategories() [CategoryController.php:59] |
| 13 |
|
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\CategoryPageService::getInspiration() [CategoryController.php:60] |
| 14 |
|
SELECT f.*, fd.question, fd.answer
FROM faqs f
INNER JOIN faqs_detail fd ON fd.faq_id = f.id AND fd.lang = ?
|
0.72ms |
App\Repositories\FaqRepository::getForCategory() [FaqService.php:58] |
| 15 |
|
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::findByCategoryId() [CategoryController.php:69] |
| 16 |
|
SELECT page_type, title_template, description_template, h1_template
FROM seo_templates
WHERE lang = ? |
0.39ms |
App\Repositories\SeoTemplateRepository::getAllByLang() [SeoTemplateService.php:167] |
| 17 |
|
SELECT lang, translated_slug FROM categories_detail WHERE categories_id = ? |
0.44ms |
App\Core\Url::getTranslatedSlugs() [CategoryController.php:128] |
