| 1 |
|
SELECT ct.id, ct.identifier,
COALESCE(ctd.name, ct.identifier) as name,
COALESCE(ctd.translated_slug, |
0.79ms |
App\Controllers\Frontend\CategoryTypeController::findById() [CategoryTypeController.php:39] |
| 2 |
|
SELECT c.id, c.identifier,
COALESCE(cd.name, c.identifier) as name,
COALESCE(cd.translated_slu |
0.32ms |
App\Controllers\Frontend\CategoryTypeController::getCategoriesInType() [CategoryTypeController.php:51] |
| 3 |
|
SELECT c.id, c.name, c.slug, co.slug as country_code,
COUNT(DISTINCT l.id) as provider_count
FROM citie |
6.17ms |
App\Controllers\Frontend\CategoryTypeController::getCityLinks() [CategoryTypeController.php:54] |
| 4 |
|
SELECT l.id, l.name, l.brand_slug, l.city_id,
c.name as city_name, c.slug as city_slug,
co.slug |
0.29ms |
App\Controllers\Frontend\CategoryTypeController::getNewestProviders() [CategoryTypeController.php:57] |
| 5 |
|
SELECT COUNT(DISTINCT l.id) as provider_count,
COALESCE(AVG(r.rating), 0) as avg_rating,
COUNT(r |
2.67ms |
App\Controllers\Frontend\CategoryTypeController::getAggregateRating() [CategoryTypeController.php:60] |
| 6 |
|
SELECT r.id, r.rating, r.comment, r.author_name, r.review_date, r.source,
l.id as listing_id, l.name as listing_name, l.bra |
0.86ms |
App\Controllers\Frontend\CategoryTypeController::getLatestReviews() [CategoryTypeController.php:63] |
| 7 |
|
SELECT b.id, b.slug as blog_slug, b.featured_image, bd.title, b.created_at
FROM blogs b
INNER JOIN blogs_detai |
0.18ms |
App\Controllers\Frontend\CategoryTypeController::getRelatedBlogs() [CategoryTypeController.php:64] |
| 8 |
|
SELECT ct.id, ct.identifier,
COALESCE(ctd.name, ct.identifier) as name,
COALESCE(ctd.translated |
0.72ms |
App\Controllers\Frontend\CategoryTypeController::getRelatedCategoryTypes() [CategoryTypeController.php:65] |
| 9 |
|
SELECT f.id, fd.question, fd.answer
FROM faqs f
INNER JOIN faqs_detail fd ON fd.faqs_id = f.id AND fd.lang = ? |
0.17ms |
App\Controllers\Frontend\CategoryTypeController::getFaqs() [CategoryTypeController.php:66] |
| 10 |
|
SELECT lang, translated_slug FROM category_types_detail WHERE category_types_id = ? |
0.44ms |
App\Core\Url::getTranslatedSlugs() [CategoryTypeController.php:119] |