| 1 |
|
SELECT attempts, last_attempt_at FROM rate_limits WHERE ip_address = ? AND action_key = ? |
0.47ms |
App\Services\Security\PersistentRateLimiter::isAllowed() [SearchController.php:186] |
| 2 |
|
UPDATE rate_limits SET attempts = attempts + 1, last_attempt_at = NOW() WHERE ip_address = ? AND action_key = ? |
2.86ms |
App\Services\Security\PersistentRateLimiter::isAllowed() [SearchController.php:186] |
| 3 |
|
SELECT attempts, last_attempt_at FROM rate_limits WHERE ip_address = ? AND action_key = ? |
0.42ms |
App\Services\Security\PersistentRateLimiter::isAllowed() [SearchController.php:212] |
| 4 |
|
SELECT c.id, c.slug, c.latitude, c.longitude,
COALESCE(cd.name, c.name) as name,
co.slug as country_code |
0.89ms |
App\Repositories\SearchRepository::searchCities() [SearchService.php:581] |
| 5 |
|
SELECT c.id, c.slug, c.latitude, c.longitude,
COALESCE(cd.name, c.name) as name,
co.slug as country_code |
0.74ms |
App\Repositories\SearchRepository::searchCities() [SearchService.php:581] |
| 6 |
|
SELECT c.id, c.slug, c.latitude, c.longitude,
COALESCE(cd.name, c.name) as name,
co.slug as country_code |
0.63ms |
App\Repositories\SearchRepository::searchCities() [SearchService.php:590] |
| 7 |
|
SELECT sid.service_items_id as id, sid.name, sid.search_tags
FROM service_items_detail sid
INNER JOIN service_items si ON s |
6.43ms |
App\Services\SearchService::loadServiceCache() [SearchService.php:756] |
| 8 |
|
SELECT cd.categories_id as id, cd.name, cd.search_tags
FROM categories_detail cd
INNER JOIN categories c ON c.id = cd.categ |
2.94ms |
App\Services\SearchService::loadServiceCache() [SearchService.php:756] |
| 9 |
|
SELECT ctd.category_types_id as id, ctd.name, ctd.search_tags
FROM category_types_detail ctd
INNER JOIN category_types ct O |
1.03ms |
App\Services\SearchService::loadServiceCache() [SearchService.php:756] |
| 10 |
|
SELECT DISTINCT listing_id
FROM listing_promotions
WHERE promotion_type = 'top_placement'
AND status |
0.4ms |
App\Repositories\SearchRepository::getBoostedListingIds() [SearchRepository.php:238] |
| 11 |
|
SELECT DISTINCT listing_id
FROM listing_promotions
WHERE promotion_type = 'highlight'
AND status = ' |
0.54ms |
App\Repositories\SearchRepository::getHighlightedListingIds() [SearchRepository.php:239] |
| 12 |
|
SELECT DISTINCT l.id, l.name, l.brand_slug, l.address, l.image, l.cover_image,
l.latitude, l.longitude,
|
0.86ms |
App\Repositories\SearchRepository::searchProviders() [SearchService.php:281] |
| 13 |
|
SELECT DISTINCT listing_id
FROM listing_promotions
WHERE promotion_type = 'top_placement'
AND status |
0.19ms |
App\Repositories\SearchRepository::getBoostedListingIds() [SearchRepository.php:238] |
| 14 |
|
SELECT DISTINCT listing_id
FROM listing_promotions
WHERE promotion_type = 'highlight'
AND status = ' |
0.33ms |
App\Repositories\SearchRepository::getHighlightedListingIds() [SearchRepository.php:239] |
| 15 |
|
SELECT DISTINCT l.id, l.name, l.brand_slug, l.address, l.image, l.cover_image,
l.latitude, l.longitude,
|
0.74ms |
App\Repositories\SearchRepository::searchProviders() [SearchService.php:384] |
| 16 |
|
SELECT si.id, si.identifier, sid.name, sid.translated_slug,
MATCH(sid.name, sid.seo_keywords, sid.search_tags)
|
16.44ms |
App\Repositories\SearchRepository::searchServices() [SearchService.php:396] |
| 17 |
|
SELECT c.id, c.slug, c.latitude, c.longitude,
COALESCE(cd.name, c.name) as name,
co.slug as country_code |
1ms |
App\Repositories\SearchRepository::searchCities() [SearchService.php:399] |
| 18 |
|
INSERT INTO search_logs
(query, normalized_query, page_type, location_city_id, location_name, filtered_date,
resu |
3.07ms |
App\Repositories\SearchRepository::logSearch() [SearchService.php:440] |
| 19 |
|
SELECT
normalized_query as query,
COUNT(*) as search_count,
SUM(CASE WHEN clicked_listing |
0.74ms |
App\Repositories\SearchRepository::getPopularSearches() [SearchController.php:429] |
| 20 |
|
SELECT page_type, title_template, description_template, h1_template
FROM seo_templates
WHERE lang = ? |
0.4ms |
App\Repositories\SeoTemplateRepository::getAllByLang() [SeoTemplateService.php:167] |