| 1 |
|
SELECT si.*, si.identifier, sid.name, sid.translated_slug, sid.seo_title, sid.seo_description,
sid.seo_keywords, sid.h1, s |
1ms |
App\Services\ServicePageService::findById() [ContentController.php:54] |
| 2 |
|
SELECT si.*, si.identifier, sid.name, sid.translated_slug, sid.seo_title, sid.seo_description,
sid.seo_keywords, sid.h1, s |
0.77ms |
App\Services\ServicePageService::findById() [ServiceController.php:38] |
| 3 |
|
SELECT h.*, hd.header, hd.subheader
FROM hero_items h
LEFT JOIN hero_items_detail hd ON hd.hero_items_id = h.id AND hd |
0.81ms |
App\Repositories\HeroRepository::findByServiceItemId() [ServiceController.php:54] |
| 4 |
|
SELECT c.id, c.name, c.slug, co.slug as country_code,
COUNT(DISTINCT l.id) as provider_count
FROM listi |
1ms |
App\Services\ServicePageService::getCityLinks() [ServiceController.php:57] |
| 5 |
|
SELECT l.id, l.name, l.brand_slug as slug, l.address as short_description,
c.id as city_id, c.name as city_name, c.slug as |
0.81ms |
App\Services\ServicePageService::getNewestProviders() [ServiceController.php:58] |
| 6 |
|
SELECT COUNT(DISTINCT l.id) as provider_count
FROM listing_services ls
INNER JOIN listings l ON l.id = ls.list |
0.57ms |
App\Services\ServicePageService::getAggregateRating() [ServiceController.php:59] |
| 7 |
|
SELECT
ROUND(AVG(r.rating), 1) as avg_rating,
COUNT(r.id) as review_count
|
0.63ms |
App\Services\ServicePageService::getAggregateRating() [ServiceController.php:59] |
| 8 |
|
SELECT r.id, r.author_name, r.author_avatar, r.rating, r.comment,
r.review_date, r.source,
l.id |
0.72ms |
App\Services\ServicePageService::getLatestReviews() [ServiceController.php:60] |
| 9 |
|
SELECT si.id, si.identifier, sid.name, sid.translated_slug
FROM service_items si
INNER JOIN service_items_deta |
0.63ms |
App\Services\ServicePageService::getRelatedServices() [ServiceController.php:61] |
| 10 |
|
SELECT b.id, b.identifier, b.featured_image, b.created_at,
bd.title, bd.slug as blog_slug
FROM blogs b
|
3.46ms |
App\Services\ServicePageService::getRelatedBlogs() [ServiceController.php:66] |
| 11 |
|
SELECT category_id FROM service_items WHERE id = ? |
0.36ms |
App\Services\ServicePageService::getInspiration() [ServiceController.php:67] |
| 12 |
|
SELECT lg.id, lg.image_path as image,
l.name as listing_name, l.brand_slug,
c.id as city_id, c.n |
2.05ms |
App\Services\ServicePageService::getInspiration() [ServiceController.php:67] |
| 13 |
|
SELECT f.*, fd.question, fd.answer
FROM faqs f
INNER JOIN faqs_detail fd ON fd.faq_id = f.id AND fd.lang = ?
|
0.65ms |
App\Repositories\FaqRepository::getForService() [FaqService.php:69] |
| 14 |
|
SELECT page_type, title_template, description_template, h1_template
FROM seo_templates
WHERE lang = ? |
0.38ms |
App\Repositories\SeoTemplateRepository::getAllByLang() [SeoTemplateService.php:167] |
| 15 |
|
SELECT lang, translated_slug FROM service_items_detail WHERE service_items_id = ? |
0.44ms |
App\Core\Url::getTranslatedSlugs() [ServiceController.php:132] |
