| 1 |
0.34 ms |
SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.slug AS slug_2, s0_.created_at AS created_at_3, s0_.updated_at AS updated_at_4 FROM service s0_ ORDER BY s0_.name ASC
SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.slug AS slug_2, s0_.created_at AS created_at_3, s0_.updated_at AS updated_at_4 FROM service s0_ ORDER BY s0_.name ASC;
|
| 2 |
0.21 ms |
SELECT a0_.id AS id_0, a0_.name AS name_1, a0_.slug AS slug_2, a0_.created_at AS created_at_3, a0_.updated_at AS updated_at_4 FROM area a0_ ORDER BY a0_.name ASC
SELECT a0_.id AS id_0, a0_.name AS name_1, a0_.slug AS slug_2, a0_.created_at AS created_at_3, a0_.updated_at AS updated_at_4 FROM area a0_ ORDER BY a0_.name ASC;
|
| 3 |
0.26 ms |
SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.slug AS slug_2, s0_.created_at AS created_at_3, s0_.updated_at AS updated_at_4 FROM service s0_ ORDER BY s0_.name ASC
SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.slug AS slug_2, s0_.created_at AS created_at_3, s0_.updated_at AS updated_at_4 FROM service s0_ ORDER BY s0_.name ASC;
|
| 4 |
0.24 ms |
SELECT b0_.id AS id_0, b0_.name AS name_1, b0_.position AS position_2, b0_.image_path AS image_path_3, b0_.link_url AS link_url_4, b0_.start_date AS start_date_5, b0_.end_date AS end_date_6, b0_.is_active AS is_active_7, b0_.click_count AS click_count_8, b0_.view_count AS view_count_9, b0_.sort_order AS sort_order_10, b0_.created_at AS created_at_11 FROM banner b0_ WHERE b0_.is_active = 1 AND ((b0_.start_date IS NULL OR b0_.start_date <= ?)) AND ((b0_.end_date IS NULL OR b0_.end_date >= ?)) AND b0_.position = ? ORDER BY b0_.sort_order ASC
Parameters: [
1780470596
1780470596
"header"
]
SELECT b0_.id AS id_0, b0_.name AS name_1, b0_.position AS position_2, b0_.image_path AS image_path_3, b0_.link_url AS link_url_4, b0_.start_date AS start_date_5, b0_.end_date AS end_date_6, b0_.is_active AS is_active_7, b0_.click_count AS click_count_8, b0_.view_count AS view_count_9, b0_.sort_order AS sort_order_10, b0_.created_at AS created_at_11 FROM banner b0_ WHERE b0_.is_active = 1 AND ((b0_.start_date IS NULL OR b0_.start_date <= 1780470596)) AND ((b0_.end_date IS NULL OR b0_.end_date >= 1780470596)) AND b0_.position = 'header' ORDER BY b0_.sort_order ASC;
|
| 5 |
0.19 ms |
SELECT t0.rate AS rate_1, t0.rate_type AS rate_type_2, t0.availability_notes AS availability_notes_3, t0.is_visible AS is_visible_4, t0.created_at AS created_at_5, t0.profile_id AS profile_id_6, t0.service_id AS service_id_7 FROM profile_service t0 WHERE t0.service_id = ?
SELECT t0.rate AS rate_1, t0.rate_type AS rate_type_2, t0.availability_notes AS availability_notes_3, t0.is_visible AS is_visible_4, t0.created_at AS created_at_5, t0.profile_id AS profile_id_6, t0.service_id AS service_id_7 FROM profile_service t0 WHERE t0.service_id = 3;
|
| 6 |
0.22 ms |
SELECT t0.rate AS rate_1, t0.rate_type AS rate_type_2, t0.availability_notes AS availability_notes_3, t0.is_visible AS is_visible_4, t0.created_at AS created_at_5, t0.profile_id AS profile_id_6, t0.service_id AS service_id_7 FROM profile_service t0 WHERE t0.service_id = ?
SELECT t0.rate AS rate_1, t0.rate_type AS rate_type_2, t0.availability_notes AS availability_notes_3, t0.is_visible AS is_visible_4, t0.created_at AS created_at_5, t0.profile_id AS profile_id_6, t0.service_id AS service_id_7 FROM profile_service t0 WHERE t0.service_id = 1;
|
| 7 |
0.17 ms |
SELECT t0.rate AS rate_1, t0.rate_type AS rate_type_2, t0.availability_notes AS availability_notes_3, t0.is_visible AS is_visible_4, t0.created_at AS created_at_5, t0.profile_id AS profile_id_6, t0.service_id AS service_id_7 FROM profile_service t0 WHERE t0.service_id = ?
SELECT t0.rate AS rate_1, t0.rate_type AS rate_type_2, t0.availability_notes AS availability_notes_3, t0.is_visible AS is_visible_4, t0.created_at AS created_at_5, t0.profile_id AS profile_id_6, t0.service_id AS service_id_7 FROM profile_service t0 WHERE t0.service_id = 4;
|
| 8 |
0.16 ms |
SELECT t0.rate AS rate_1, t0.rate_type AS rate_type_2, t0.availability_notes AS availability_notes_3, t0.is_visible AS is_visible_4, t0.created_at AS created_at_5, t0.profile_id AS profile_id_6, t0.service_id AS service_id_7 FROM profile_service t0 WHERE t0.service_id = ?
SELECT t0.rate AS rate_1, t0.rate_type AS rate_type_2, t0.availability_notes AS availability_notes_3, t0.is_visible AS is_visible_4, t0.created_at AS created_at_5, t0.profile_id AS profile_id_6, t0.service_id AS service_id_7 FROM profile_service t0 WHERE t0.service_id = 2;
|
| 9 |
0.18 ms |
SELECT b0_.id AS id_0, b0_.name AS name_1, b0_.position AS position_2, b0_.image_path AS image_path_3, b0_.link_url AS link_url_4, b0_.start_date AS start_date_5, b0_.end_date AS end_date_6, b0_.is_active AS is_active_7, b0_.click_count AS click_count_8, b0_.view_count AS view_count_9, b0_.sort_order AS sort_order_10, b0_.created_at AS created_at_11 FROM banner b0_ WHERE b0_.is_active = 1 AND ((b0_.start_date IS NULL OR b0_.start_date <= ?)) AND ((b0_.end_date IS NULL OR b0_.end_date >= ?)) AND b0_.position = ? ORDER BY b0_.sort_order ASC
Parameters: [
1780470596
1780470596
"footer"
]
SELECT b0_.id AS id_0, b0_.name AS name_1, b0_.position AS position_2, b0_.image_path AS image_path_3, b0_.link_url AS link_url_4, b0_.start_date AS start_date_5, b0_.end_date AS end_date_6, b0_.is_active AS is_active_7, b0_.click_count AS click_count_8, b0_.view_count AS view_count_9, b0_.sort_order AS sort_order_10, b0_.created_at AS created_at_11 FROM banner b0_ WHERE b0_.is_active = 1 AND ((b0_.start_date IS NULL OR b0_.start_date <= 1780470596)) AND ((b0_.end_date IS NULL OR b0_.end_date >= 1780470596)) AND b0_.position = 'footer' ORDER BY b0_.sort_order ASC;
|