| 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.91ms |
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.43ms |
App\Repositories\HomeRepository::findFeaturedCities() [HomeService.php:47] |
| 3 |
|
SELECT ct.id, ct.identifier,
COALESCE(ctd.name, ct.identifier) as name,
COALESCE(ctd.translate |
0.61ms |
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.34ms |
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.3ms |
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.46ms |
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 |
5.31ms |
App\Repositories\HomeRepository::findPopularServiceItems() [HomeService.php:87] |
| 8 |
|
SELECT si.id, si.identifier,
COALESCE(sid.name, si.identifier) as service_name,
COALESCE(sid.tra |
0.98ms |
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.42ms |
App\Repositories\HomeRepository::findDailyInspiration() [HomeService.php:95] |
| 10 |
|
SELECT MIN(id) as min_id, MAX(id) as max_id FROM listing_gallery |
0.24ms |
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.22ms |
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.93ms |
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
|
0.99ms |
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.46ms |
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.1ms |
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.6ms |
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.65ms |
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.52ms |
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.5ms |
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.49ms |
App\Repositories\InspirationRepository::getDailyRandomImageForBoard() [LookbookService.php:40] |
| 21 |
|
SELECT page_type, title_template, description_template, h1_template
FROM seo_templates
WHERE lang = ? |
0.37ms |
App\Repositories\SeoTemplateRepository::getAllByLang() [SeoTemplateService.php:167] |
Featured
Featured
Featured
