| 1 |
0.64 ms |
SELECT t0.id AS id_1, t0.route AS route_2, t0.meta_title AS meta_title_3, t0.meta_description AS meta_description_4, t0.meta_keywords AS meta_keywords_5, t0.canonical_url AS canonical_url_6, t0.created_at AS created_at_7, t0.created_by AS created_by_8, t0.updated_at AS updated_at_9, t0.updated_by AS updated_by_10 FROM seo_meta t0 WHERE t0.route = ? LIMIT 1
Parameters: [
"app_home"
]
SELECT t0.id AS id_1, t0.route AS route_2, t0.meta_title AS meta_title_3, t0.meta_description AS meta_description_4, t0.meta_keywords AS meta_keywords_5, t0.canonical_url AS canonical_url_6, t0.created_at AS created_at_7, t0.created_by AS created_by_8, t0.updated_at AS updated_at_9, t0.updated_by AS updated_by_10 FROM seo_meta t0 WHERE t0.route = 'app_home' LIMIT 1;
|
| 2 |
0.70 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.featured_image AS featured_image_3, t0.published_status AS published_status_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.created_by AS created_by_7, t0.updated_by AS updated_by_8, t0.slug AS slug_9, t0.short_description AS short_description_10, t0.content AS content_11, t0.meta_title AS meta_title_12, t0.meta_description AS meta_description_13, t0.meta_keywords AS meta_keywords_14, t0.featured_icon AS featured_icon_15, t0.featured AS featured_16 FROM our_services t0 WHERE t0.featured = ? AND t0.published_status = ? ORDER BY t0.created_at DESC LIMIT 3
SELECT t0.id AS id_1, t0.title AS title_2, t0.featured_image AS featured_image_3, t0.published_status AS published_status_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.created_by AS created_by_7, t0.updated_by AS updated_by_8, t0.slug AS slug_9, t0.short_description AS short_description_10, t0.content AS content_11, t0.meta_title AS meta_title_12, t0.meta_description AS meta_description_13, t0.meta_keywords AS meta_keywords_14, t0.featured_icon AS featured_icon_15, t0.featured AS featured_16 FROM our_services t0 WHERE t0.featured = 1 AND t0.published_status = 1 ORDER BY t0.created_at DESC LIMIT 3;
|
| 3 |
0.85 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.client_name AS client_name_3, t0.featured_image AS featured_image_4, t0.content AS content_5, t0.visuals AS visuals_6, t0.testimonials AS testimonials_7, t0.published_status AS published_status_8, t0.created_at AS created_at_9, t0.created_by AS created_by_10, t0.updated_at AS updated_at_11, t0.updated_by AS updated_by_12, t0.meta_title AS meta_title_13, t0.meta_description AS meta_description_14, t0.meta_keywords AS meta_keywords_15, t0.slug AS slug_16, t0.featured AS featured_17 FROM case_study t0 WHERE t0.featured = ? AND t0.published_status = ? ORDER BY t0.created_at DESC LIMIT 3
SELECT t0.id AS id_1, t0.title AS title_2, t0.client_name AS client_name_3, t0.featured_image AS featured_image_4, t0.content AS content_5, t0.visuals AS visuals_6, t0.testimonials AS testimonials_7, t0.published_status AS published_status_8, t0.created_at AS created_at_9, t0.created_by AS created_by_10, t0.updated_at AS updated_at_11, t0.updated_by AS updated_by_12, t0.meta_title AS meta_title_13, t0.meta_description AS meta_description_14, t0.meta_keywords AS meta_keywords_15, t0.slug AS slug_16, t0.featured AS featured_17 FROM case_study t0 WHERE t0.featured = 1 AND t0.published_status = 1 ORDER BY t0.created_at DESC LIMIT 3;
|
| 4 |
0.80 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.content AS content_3, t0.featured_image AS featured_image_4, t0.published_status AS published_status_5, t0.created_at AS created_at_6, t0.created_by AS created_by_7, t0.updated_at AS updated_at_8, t0.updated_by AS updated_by_9, t0.meta_title AS meta_title_10, t0.meta_description AS meta_description_11, t0.meta_keywords AS meta_keywords_12, t0.slug AS slug_13, t0.short_description AS short_description_14, t0.author_id AS author_id_15 FROM blog t0 WHERE t0.published_status = ? ORDER BY t0.created_at DESC LIMIT 2
SELECT t0.id AS id_1, t0.title AS title_2, t0.content AS content_3, t0.featured_image AS featured_image_4, t0.published_status AS published_status_5, t0.created_at AS created_at_6, t0.created_by AS created_by_7, t0.updated_at AS updated_at_8, t0.updated_by AS updated_by_9, t0.meta_title AS meta_title_10, t0.meta_description AS meta_description_11, t0.meta_keywords AS meta_keywords_12, t0.slug AS slug_13, t0.short_description AS short_description_14, t0.author_id AS author_id_15 FROM blog t0 WHERE t0.published_status = 1 ORDER BY t0.created_at DESC LIMIT 2;
|
| 5 |
0.67 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.logo AS logo_3, t0.published_status AS published_status_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.created_by AS created_by_7, t0.updated_by AS updated_by_8 FROM our_clients t0 WHERE t0.published_status = ? ORDER BY t0.created_at DESC LIMIT 5
SELECT t0.id AS id_1, t0.name AS name_2, t0.logo AS logo_3, t0.published_status AS published_status_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.created_by AS created_by_7, t0.updated_by AS updated_by_8 FROM our_clients t0 WHERE t0.published_status = 1 ORDER BY t0.created_at DESC LIMIT 5;
|
| 6 |
230.44 ms |
SELECT COUNT(*) FROM our_clients t0
SELECT COUNT(*) FROM our_clients t0;
|
| 7 |
0.78 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.created_at AS created_at_3, t0.created_by AS created_by_4, t0.updated_at AS updated_at_5, t0.updated_by AS updated_by_6, t0.slug AS slug_7 FROM category t0 INNER JOIN blog_category ON t0.id = blog_category.category_id WHERE blog_category.blog_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.created_at AS created_at_3, t0.created_by AS created_by_4, t0.updated_at AS updated_at_5, t0.updated_by AS updated_by_6, t0.slug AS slug_7 FROM category t0 INNER JOIN blog_category ON t0.id = blog_category.category_id WHERE blog_category.blog_id = 9;
|
| 8 |
0.47 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.created_at AS created_at_3, t0.created_by AS created_by_4, t0.updated_at AS updated_at_5, t0.updated_by AS updated_by_6, t0.slug AS slug_7 FROM category t0 INNER JOIN blog_category ON t0.id = blog_category.category_id WHERE blog_category.blog_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.created_at AS created_at_3, t0.created_by AS created_by_4, t0.updated_at AS updated_at_5, t0.updated_by AS updated_by_6, t0.slug AS slug_7 FROM category t0 INNER JOIN blog_category ON t0.id = blog_category.category_id WHERE blog_category.blog_id = 8;
|