Provider #1264
Reservar cita
| Section | Total | Avg | Memory | Calls |
|---|---|---|---|---|
| app_setup | 0.72ms | 0.72ms | 243.1KB | 1 |
| # | Query | Time | Caller | |
|---|---|---|---|---|
| 1 | SELECT c.id, c.name, c.slug, c.latitude, c.longitude, co.id as country_id, co.slug as country_code, | 0.79ms | 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.15ms | App\Services\ProviderPageService::findById() [ListingController.php:385] | |
| 3 | SELECT si.id, si.identifier, sid.name, sid.translated_slug, ls.created_at | 0.69ms | 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.55ms | 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.24ms | App\Services\ProviderPageService::getReviews() [ListingController.php:407] | |
| 8 | SELECT ROUND(AVG(rating), 1) as avg_rating, COUNT(*) as review_count, SUM(CAS | 0.58ms | 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.27ms | App\Services\ProviderPageService::getSimilarProviders() [ListingController.php:409] | |
| 10 | SELECT amenity_key FROM listing_amenities WHERE listing_id = ? | 0.38ms | App\Services\ProviderPageService::getAmenities() [ListingController.php:415] | |
| 11 | SELECT day_of_week, open_time, close_time FROM listing_hours WHERE listing_id = ? ORDER | 0.38ms | App\Services\ProviderPageService::getOpeningHours() [ListingController.php:416] | |
| 12 | SELECT page_type, title_template, description_template, h1_template FROM seo_templates WHERE lang = ? | 0.4ms | App\Repositories\SeoTemplateRepository::getAllByLang() [SeoTemplateService.php:167] | |
| 13 | SELECT tier FROM listing_subscriptions WHERE listing_id = ? AND status = 'active' | 0.41ms | App\Repositories\SubscriptionRepository::getTier() [ListingController.php:495] |
Inicia sesión o regístrate.
Crea tu cuenta de proveedor.
Elige tu región preferida.