| 1 |
1.49 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.thumbnail AS thumbnail_3, t0.seo_title AS seo_title_4, t0.slug AS slug_5, t0.brief AS brief_6, t0.content AS content_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9 FROM page t0 WHERE t0.slug = ? LIMIT 1
SELECT t0.id AS id_1, t0.title AS title_2, t0.thumbnail AS thumbnail_3, t0.seo_title AS seo_title_4, t0.slug AS slug_5, t0.brief AS brief_6, t0.content AS content_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9 FROM page t0 WHERE t0.slug = 'home' LIMIT 1;
|
| 2 |
1.10 ms |
SELECT t0.id AS id_1, t0.first_name AS first_name_2, t0.last_name AS last_name_3, t0.postal_code AS postal_code_4, t0.client_photo AS client_photo_5, t0.before_work_photo AS before_work_photo_6, t0.after_work_photo AS after_work_photo_7, t0.work_types AS work_types_8, t0.google_review_online AS google_review_online_9, t0.agency_concerned AS agency_concerned_10, t0.rating AS rating_11, t0.review_source AS review_source_12, t0.publish_online AS publish_online_13, t0.month AS month_14, t0.position AS position_15, t0.created_at AS created_at_16, t0.location_id AS location_id_17 FROM client t0 WHERE t0.publish_online = ? ORDER BY t0.created_at DESC LIMIT 10
SELECT t0.id AS id_1, t0.first_name AS first_name_2, t0.last_name AS last_name_3, t0.postal_code AS postal_code_4, t0.client_photo AS client_photo_5, t0.before_work_photo AS before_work_photo_6, t0.after_work_photo AS after_work_photo_7, t0.work_types AS work_types_8, t0.google_review_online AS google_review_online_9, t0.agency_concerned AS agency_concerned_10, t0.rating AS rating_11, t0.review_source AS review_source_12, t0.publish_online AS publish_online_13, t0.month AS month_14, t0.position AS position_15, t0.created_at AS created_at_16, t0.location_id AS location_id_17 FROM client t0 WHERE t0.publish_online = 1 ORDER BY t0.created_at DESC LIMIT 10;
|
| 3 |
0.76 ms |
SELECT b0_.id AS id_0, b0_.title AS title_1, b0_.position AS position_2, b0_.slug AS slug_3, b0_.photo AS photo_4, b0_.banner AS banner_5, b0_.brief AS brief_6, b0_.content AS content_7, b0_.seo_title AS seo_title_8, b0_.seo_desc AS seo_desc_9, b0_.bgbanner AS bgbanner_10, b0_.published AS published_11 FROM business b0_ WHERE b0_.published = 1 ORDER BY b0_.position ASC LIMIT 5
SELECT b0_.id AS id_0, b0_.title AS title_1, b0_.position AS position_2, b0_.slug AS slug_3, b0_.photo AS photo_4, b0_.banner AS banner_5, b0_.brief AS brief_6, b0_.content AS content_7, b0_.seo_title AS seo_title_8, b0_.seo_desc AS seo_desc_9, b0_.bgbanner AS bgbanner_10, b0_.published AS published_11 FROM business b0_ WHERE b0_.published = 1 ORDER BY b0_.position ASC LIMIT 5;
|
| 4 |
0.76 ms |
SELECT t0.id AS id_1, t0.type AS type_2, t0.data AS data_3, t0.position AS position_4, t0.page_id AS page_id_5 FROM section t0 WHERE t0.page_id = ? ORDER BY t0.position ASC
SELECT t0.id AS id_1, t0.type AS type_2, t0.data AS data_3, t0.position AS position_4, t0.page_id AS page_id_5 FROM section t0 WHERE t0.page_id = 8 ORDER BY t0.position ASC;
|
| 5 |
0.97 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.image AS image_4, t0.country_name AS country_name_5, t0.zip_code AS zip_code_6, t0.phone AS phone_7, t0.email AS email_8, t0.address AS address_9, t0.published AS published_10 FROM location t0 WHERE t0.published = ?
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.image AS image_4, t0.country_name AS country_name_5, t0.zip_code AS zip_code_6, t0.phone AS phone_7, t0.email AS email_8, t0.address AS address_9, t0.published AS published_10 FROM location t0 WHERE t0.published = 1;
|
| 6 |
0.38 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.image AS image_4, t0.country_name AS country_name_5, t0.zip_code AS zip_code_6, t0.phone AS phone_7, t0.email AS email_8, t0.address AS address_9, t0.published AS published_10 FROM location t0 WHERE t0.published = ?
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.image AS image_4, t0.country_name AS country_name_5, t0.zip_code AS zip_code_6, t0.phone AS phone_7, t0.email AS email_8, t0.address AS address_9, t0.published AS published_10 FROM location t0 WHERE t0.published = 1;
|
| 7 |
0.46 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.basic_info AS basic_info_3, t0.position AS position_4, t0.image AS image_5, t0.created_at AS created_at_6, t0.published AS published_7 FROM team_member t0 WHERE t0.published = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.basic_info AS basic_info_3, t0.position AS position_4, t0.image AS image_5, t0.created_at AS created_at_6, t0.published AS published_7 FROM team_member t0 WHERE t0.published = 1;
|
| 8 |
0.45 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.logo AS logo_4, t0.website AS website_5, t0.email AS email_6, t0.created_at AS created_at_7, t0.published AS published_8 FROM partner t0 WHERE t0.published = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.logo AS logo_4, t0.website AS website_5, t0.email AS email_6, t0.created_at AS created_at_7, t0.published AS published_8 FROM partner t0 WHERE t0.published = 1;
|