| 1 |
|
SELECT c.id, c.name, c.slug, c.latitude, c.longitude,
co.id as country_id, co.slug as country_code,
|
0.96ms |
App\Services\ListingPageService::findCityById() [ListingController.php:59] |
| 2 |
|
SELECT
l.id, l.name, l.brand_slug, l.address, l.phone, l.whatsapp, l.website,
l.image, l.cover_image, |
1.21ms |
App\Services\ProviderPageService::findById() [ListingController.php:385] |
| 3 |
|
SELECT
si.id, si.identifier,
sid.name, sid.translated_slug,
ls.created_at
|
0.64ms |
App\Services\ProviderPageService::getServices() [ListingController.php:404] |
| 4 |
|
SELECT
lso.id, lso.name, lso.description, lso.price, lso.currency,
lso.duration_minutes, lso.image, l |
0.66ms |
App\Services\ProviderPageService::getServiceOfferings() [ListingController.php:405] |
| 5 |
|
SELECT
id, listing_id, image_path, description, sort_order,
media_type, video_thumbnail
|
0.51ms |
App\Services\ProviderPageService::getGallery() [ListingController.php:406] |
| 6 |
|
SELECT COUNT(*) FROM reviews
WHERE listing_id = ? AND status = 'approved' |
0.43ms |
App\Services\ProviderPageService::getReviews() [ListingController.php:407] |
| 7 |
|
SELECT
r.id, r.user_id, r.author_name, r.author_avatar, r.rating,
r.title, r.comment, r.review_date, |
0.26ms |
App\Services\ProviderPageService::getReviews() [ListingController.php:407] |
| 8 |
|
SELECT
ROUND(AVG(rating), 1) as avg_rating,
COUNT(*) as review_count,
SUM(CAS |
0.8ms |
App\Services\ProviderPageService::getAggregateRating() [ListingController.php:408] |
| 9 |
|
SELECT
l.id, l.name, l.brand_slug, l.address, l.image,
c.id as city_id, c.slug as city_slug,
|
1.36ms |
App\Services\ProviderPageService::getSimilarProviders() [ListingController.php:409] |
| 10 |
|
SELECT amenity_key FROM listing_amenities WHERE listing_id = ? |
0.42ms |
App\Services\ProviderPageService::getAmenities() [ListingController.php:415] |
| 11 |
|
SELECT day_of_week, open_time, close_time
FROM listing_hours
WHERE listing_id = ?
ORDER |
0.39ms |
App\Services\ProviderPageService::getOpeningHours() [ListingController.php:416] |
| 12 |
|
SELECT page_type, title_template, description_template, h1_template
FROM seo_templates
WHERE lang = ? |
0.52ms |
App\Repositories\SeoTemplateRepository::getAllByLang() [SeoTemplateService.php:167] |
| 13 |
|
SELECT tier
FROM listing_subscriptions
WHERE listing_id = ?
AND status = 'active'
|
0.5ms |
App\Repositories\SubscriptionRepository::getTier() [ListingController.php:495] |