| 1 |
|
SELECT c.id, c.name, c.slug, c.latitude, c.longitude,
co.id as country_id, co.slug as country_code,
|
0.85ms |
App\Services\ListingPageService::findCityById() [ListingController.php:59] |
| 2 |
|
SELECT ct.id, ct.identifier,
ctd.name, ctd.translated_slug, ctd.search_tags,
ctd.seo_title, ctd |
0.55ms |
App\Services\ListingPageService::findCategoryTypeById() [ListingController.php:749] |
| 3 |
|
SELECT c.id, c.identifier, c.image, cd.name, cd.translated_slug, cd.seo_description
FROM categories c
JOIN categories_detail |
0.93ms |
App\Repositories\CategoryTypeRepository::getCategoriesForType() [ListingController.php:767] |
| 4 |
|
SELECT COUNT(DISTINCT l.id)
FROM listings l
WHERE l.city_id = ?
|
2.18ms |
App\Repositories\ProviderRepository::findByCategoryTypeFiltered() [ListingController.php:832] |
| 5 |
|
SELECT DISTINCT l.id, l.name, l.brand_slug, l.image, l.address, l.phone,
l.city_id, ci.slug as city_slug, co.slug as country_co |
4.33ms |
App\Repositories\ProviderRepository::findByCategoryTypeFiltered() [ListingController.php:832] |
| 6 |
|
SELECT
MIN(lso.price) as min_price,
MAX(lso.price) as max_price
FROM listing_service_offerings |
0.93ms |
App\Repositories\ProviderRepository::getFilterOptionsForCategoryType() [ListingController.php:841] |
| 7 |
|
SELECT DISTINCT a.id, a.identifier, a.icon,
COALESCE(ad.name, a.identifier) as name
FROM amenities a
|
0.31ms |
App\Repositories\ProviderRepository::getAvailableAmenitiesForCategoryType() [ListingController.php:844] |
| 8 |
|
SELECT name FROM countries WHERE slug = ? |
0.5ms |
App\Services\Seo\BreadcrumbService::getCountryNameFromCode() [BreadcrumbService.php:194] |
| 9 |
|
SELECT lang, translated_slug FROM category_types_detail WHERE category_types_id = ? |
0.47ms |
App\Core\Url::getTranslatedSlugs() [ListingController.php:898] |