1
📋
SELECT h.*, hd.header, hd.subheader
FROM hero_items h
LEFT JOIN hero_items_detail hd ON hd.hero_items_id = h.i
0.99ms
App\Repositories\HomeRepository::findActiveHeroItems() [HomeService.php:39]
2
📋
SELECT c.id, c.slug, c.name as city_name, c.image,
co.id as country_id, co.name as country_name, co.slug as country_slug
0.47ms
App\Repositories\HomeRepository::findFeaturedCities() [HomeService.php:47]
3
📋
SELECT ct.id, ct.identifier,
COALESCE(ctd.name, ct.identifier) as name,
COALESCE(ctd.translate
0.56ms
App\Repositories\HomeRepository::findFeaturedCategories() [HomeService.php:55]
4
📋
SELECT l.id, l.brand_slug, l.name as salon_name, l.address, l.city_id,
ld.description,
c.name as
0.66ms
App\Repositories\HomeRepository::findTopSalons() [HomeService.php:63]
5
📋
SELECT stat_key, stat_value FROM site_stats WHERE stat_key IN ('active_salons', 'active_countries', 'active_cities')
0.37ms
App\Repositories\HomeRepository::getPublicStats() [HomeService.php:71]
6
📋
SELECT
fc.id as featured_id,
co.id as country_id, co.name as country_name, co.slug as country_slug,
0.63ms
App\Repositories\HomeRepository::findFeaturedCountriesWithCities() [HomeService.php:79]
7
📋
SELECT ls.service_item_id, COUNT(*) as cnt
FROM listing_services ls
JOIN service_items si ON si.id
4.61ms
App\Repositories\HomeRepository::findPopularServiceItems() [HomeService.php:87]
8
📋
SELECT si.id, si.identifier,
COALESCE(sid.name, si.identifier) as service_name,
COALESCE(sid.tra
1.03ms
App\Repositories\HomeRepository::findPopularServiceItems() [HomeService.php:87]
9
📋
SELECT dic.*, l.brand_slug, l.city_id, c.slug as city_slug, co.slug as country_code
FROM daily_inspiration_cache dic
0.55ms
App\Repositories\HomeRepository::findDailyInspiration() [HomeService.php:95]
10
📋
SELECT MIN(id) as min_id, MAX(id) as max_id FROM listing_gallery
0.27ms
App\Repositories\HomeRepository::getFastRandomGalleryImages() [HomeRepository.php:223]
11
📋
SELECT lg.id as listing_gallery_id, lg.listing_id, lg.image_path,
lg.service_item_id,
sid.name as servic
1.17ms
App\Repositories\HomeRepository::getFastRandomGalleryImages() [HomeRepository.php:223]
12
📋
SELECT c.id, c.identifier, c.image, cd.name, cd.translated_slug, cd.search_volume
FROM categories c
JOIN categories_de
0.97ms
App\Repositories\CategoryRepository::findPopularCategories() [HomeService.php:103]
13
📋
SELECT b.id, b.identifier, b.featured_image, b.is_featured, b.created_at,
bd.title, bd.slug, bd.body
FROM blogs b
1.1ms
App\Repositories\BlogRepository::findFeaturedBlogs() [HomeService.php:112]
14
📋
SELECT b.id, b.identifier, b.featured_image, b.is_featured, b.created_at,
bd.title, bd.slug, bd.body
FROM blo
1.42ms
App\Repositories\BlogRepository::findFeaturedBlogs() [HomeService.php:112]
15
📋
SELECT b.id, b.identifier, b.cover_image, b.sort_order,
bd.name, bd.slug, bd.intro,
(SELECT COUNT(*) FROM insp
1.45ms
App\Repositories\InspirationRepository::findPublishedBoards() [LookbookService.php:35]
16
📋
SELECT COUNT(*) as cnt
FROM inspiration_set_images isi
INNER JOIN inspiration_sets s ON isi.set_id = s.id AND s.is_approved
0.61ms
App\Repositories\InspirationRepository::getDailyRandomImageForBoard() [LookbookService.php:40]
17
📋
SELECT lg.image_path
FROM inspiration_set_images isi
INNER JOIN inspiration_sets s ON isi.set_id = s.id AND s.is_approved =
0.59ms
App\Repositories\InspirationRepository::getDailyRandomImageForBoard() [LookbookService.php:40]
18
📋
SELECT COUNT(*) as cnt
FROM inspiration_set_images isi
INNER JOIN inspiration_sets s ON isi.set_id = s.id AND s.is_approved
0.54ms
App\Repositories\InspirationRepository::getDailyRandomImageForBoard() [LookbookService.php:40]
19
📋
SELECT COUNT(*) as cnt
FROM inspiration_set_images isi
INNER JOIN inspiration_sets s ON isi.set_id = s.id AND s.is_approved
0.51ms
App\Repositories\InspirationRepository::getDailyRandomImageForBoard() [LookbookService.php:40]
20
📋
SELECT COUNT(*) as cnt
FROM inspiration_set_images isi
INNER JOIN inspiration_sets s ON isi.set_id = s.id AND s.is_approved
0.57ms
App\Repositories\InspirationRepository::getDailyRandomImageForBoard() [LookbookService.php:40]
21
📋
SELECT page_type, title_template, description_template, h1_template
FROM seo_templates
WHERE lang = ?
0.41ms
App\Repositories\SeoTemplateRepository::getAllByLang() [SeoTemplateService.php:167]