| 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.9ms |
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.41ms |
App\Repositories\HomeRepository::findFeaturedCities() [HomeService.php:47] |
| 3 |
|
SELECT ct.id, ct.identifier,
COALESCE(ctd.name, ct.identifier) as name,
COALESCE(ctd.translate |
0.6ms |
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.35ms |
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.29ms |
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.47ms |
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.57ms |
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.94ms |
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.41ms |
App\Repositories\HomeRepository::findDailyInspiration() [HomeService.php:95] |
| 10 |
|
SELECT MIN(id) as min_id, MAX(id) as max_id FROM listing_gallery |
0.26ms |
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.08ms |
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.92ms |
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.01ms |
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.45ms |
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.08ms |
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.64ms |
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.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.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.52ms |
App\Repositories\InspirationRepository::getDailyRandomImageForBoard() [LookbookService.php:40] |
| 21 |
|
SELECT page_type, title_template, description_template, h1_template
FROM seo_templates
WHERE lang = ? |
0.4ms |
App\Repositories\SeoTemplateRepository::getAllByLang() [SeoTemplateService.php:167] |
Featured
Featured
Featured
