| 1 |
|
SELECT c.id, c.name, c.slug, c.latitude, c.longitude,
co.id as country_id, co.slug as country_code,
|
0.8ms |
App\Services\ListingPageService::findCityById() [ListingController.php:59] |
| 2 |
|
SELECT si.id, si.category_id, si.identifier,
sid.name, sid.translated_slug, sid.seo_title, sid.seo_description, sid.h1,
|
0.69ms |
App\Services\ListingPageService::findServiceById() [ListingController.php:133] |
| 3 |
|
SELECT category_id FROM service_items WHERE id = ? AND storno = 'f' |
0.39ms |
App\Services\ListingPageService::getProviders() [ListingController.php:236] |
| 4 |
|
SELECT DISTINCT listing_id
FROM listing_promotions
WHERE promotion_type = 'top_placement'
AND status |
0.23ms |
App\Services\ListingPageService::getBoostedAndHighlightedIds() [ListingPageService.php:281] |
| 5 |
|
SELECT DISTINCT listing_id
FROM listing_promotions
WHERE promotion_type = 'highlight'
AND status |
0.58ms |
App\Services\ListingPageService::getBoostedAndHighlightedIds() [ListingPageService.php:281] |
| 6 |
|
SELECT COUNT(DISTINCT l.id)
FROM listing_services ls
INNER JOIN listings l ON l.id = ls.listing_id A |
0.69ms |
App\Services\ListingPageService::getProviders() [ListingController.php:236] |
| 7 |
|
SELECT
l.id, l.name, l.brand_slug, l.address, l.image, l.cover_image, l.city_id,
c.name as city_name, |
1.34ms |
App\Services\ListingPageService::getProviders() [ListingController.php:236] |
| 8 |
|
SELECT
AVG(r.rating) as avg_rating,
COUNT(r.id) as review_count,
COUNT(DISTIN |
0.82ms |
App\Services\ListingPageService::getAggregateRating() [ListingController.php:245] |
| 9 |
|
SELECT
si.id, sid.name, sid.translated_slug,
COUNT(DISTINCT l.id) as provider_count
|
1.08ms |
App\Services\ListingPageService::getRelatedServices() [ListingController.php:246] |
| 10 |
|
SELECT latitude, longitude FROM cities WHERE id = ? |
0.36ms |
App\Services\ListingPageService::getNearbyCities() [ListingController.php:252] |
| 11 |
|
SELECT
c.id, c.name, c.slug,
co.slug as country_code,
COUNT(DISTINCT l.id) as |
1.08ms |
App\Services\ListingPageService::getNearbyCities() [ListingController.php:252] |
| 12 |
|
SELECT
MIN(lso.price) as min_price,
MAX(lso.price) as max_price
FROM listing_servi |
0.66ms |
App\Services\ListingPageService::getFilterOptions() [ListingController.php:253] |
| 13 |
|
SELECT DISTINCT a.id, a.identifier, a.icon,
COALESCE(ad.name, a.identifier) as name
FROM amenities a
|
0.25ms |
App\Services\ListingPageService::getAvailableAmenities() [ListingController.php:254] |
| 14 |
|
SELECT name FROM countries WHERE slug = ? |
0.34ms |
App\Services\Seo\BreadcrumbService::getCountryNameFromCode() [BreadcrumbService.php:194] |
| 15 |
|
SELECT page_type, title_template, description_template, h1_template
FROM seo_templates
WHERE lang = ? |
0.38ms |
App\Repositories\SeoTemplateRepository::getAllByLang() [SeoTemplateService.php:167] |
| 16 |
|
SELECT lang, translated_slug FROM service_items_detail WHERE service_items_id = ? |
0.44ms |
App\Core\Url::getTranslatedSlugs() [ListingController.php:301] |