| 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 c.id, c.category_type_id, c.image, c.identifier,
cd.name, cd.translated_slug, cd.seo_title, cd.seo_description,
|
0.56ms |
App\Services\ListingPageService::findCategoryById() [ListingController.php:543] |
| 3 |
|
SELECT DISTINCT listing_id
FROM listing_promotions
WHERE promotion_type = 'top_placement'
AND status |
0.23ms |
App\Services\ListingPageService::getBoostedAndHighlightedIds() [ListingPageService.php:861] |
| 4 |
|
SELECT DISTINCT listing_id
FROM listing_promotions
WHERE promotion_type = 'highlight'
AND status |
0.57ms |
App\Services\ListingPageService::getBoostedAndHighlightedIds() [ListingPageService.php:861] |
| 5 |
|
SELECT COUNT(DISTINCT l.id)
FROM listings l
INNER JOIN listing_categories lc ON lc.listing_id = l.id |
0.63ms |
App\Services\ListingPageService::getProvidersByCategoryFiltered() [ListingController.php:620] |
| 6 |
|
SELECT DISTINCT l.id, l.name, l.brand_slug, l.image, l.address, l.phone,
l.cover_image, l.city_id,
(SE |
1.11ms |
App\Services\ListingPageService::getProvidersByCategoryFiltered() [ListingController.php:620] |
| 7 |
|
SELECT si.id, sid.name, sid.translated_slug
FROM service_items si
JOIN service_items_detail sid ON sid.service_items |
0.87ms |
App\Services\ListingPageService::getServicesInCategory() [ListingController.php:629] |
| 8 |
|
SELECT
MIN(lso.price) as min_price,
MAX(lso.price) as max_price
FROM listing_servi |
0.64ms |
App\Services\ListingPageService::getFilterOptionsForCategory() [ListingController.php:632] |
| 9 |
|
SELECT page_type, title_template, description_template, h1_template
FROM seo_templates
WHERE lang = ? |
0.38ms |
App\Repositories\SeoTemplateRepository::getAllByLang() [SeoTemplateService.php:167] |
| 10 |
|
SELECT DISTINCT a.id, a.identifier, a.icon,
COALESCE(ad.name, a.identifier) as name
FROM amenities a
|
0.27ms |
App\Services\ListingPageService::getAvailableAmenitiesForCategory() [ListingController.php:651] |
| 11 |
|
SELECT name FROM countries WHERE slug = ? |
0.32ms |
App\Services\Seo\BreadcrumbService::getCountryNameFromCode() [BreadcrumbService.php:194] |
| 12 |
|
SELECT lang, translated_slug FROM categories_detail WHERE categories_id = ? |
0.41ms |
App\Core\Url::getTranslatedSlugs() [ListingController.php:671] |