| 1 |
0.25 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.description AS description_4, t0.sort_order AS sort_order_5, t0.is_active AS is_active_6 FROM forum_category t0 WHERE t0.slug = ? AND t0.is_active = ? LIMIT 1
Parameters: [
"team-pret"
1
]
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.description AS description_4, t0.sort_order AS sort_order_5, t0.is_active AS is_active_6 FROM forum_category t0 WHERE t0.slug = 'team-pret' AND t0.is_active = 1 LIMIT 1;
|
| 2 |
3.25 ms |
SELECT f0_.id AS id_0, f0_.title AS title_1, f0_.slug AS slug_2, f0_.content AS content_3, f0_.attachment_path AS attachment_path_4, f0_.is_pinned AS is_pinned_5, f0_.is_locked AS is_locked_6, f0_.status AS status_7, f0_.view_count AS view_count_8, f0_.reply_count AS reply_count_9, f0_.last_reply_at AS last_reply_at_10, f0_.created_at AS created_at_11, f0_.updated_at AS updated_at_12, f0_.category_id AS category_id_13, f0_.user_id AS user_id_14 FROM forum_topic f0_ WHERE f0_.category_id = ? AND f0_.status = ? ORDER BY f0_.is_pinned DESC, f0_.last_reply_at DESC, f0_.created_at DESC LIMIT 20
Parameters: [
1
"approved"
]
SELECT f0_.id AS id_0, f0_.title AS title_1, f0_.slug AS slug_2, f0_.content AS content_3, f0_.attachment_path AS attachment_path_4, f0_.is_pinned AS is_pinned_5, f0_.is_locked AS is_locked_6, f0_.status AS status_7, f0_.view_count AS view_count_8, f0_.reply_count AS reply_count_9, f0_.last_reply_at AS last_reply_at_10, f0_.created_at AS created_at_11, f0_.updated_at AS updated_at_12, f0_.category_id AS category_id_13, f0_.user_id AS user_id_14 FROM forum_topic f0_ WHERE f0_.category_id = 1 AND f0_.status = 'approved' ORDER BY f0_.is_pinned DESC, f0_.last_reply_at DESC, f0_.created_at DESC LIMIT 20;
|
| 3 |
0.68 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.format AS format_3, t0.image_url AS image_url_4, t0.link_url AS link_url_5, t0.alt_text AS alt_text_6, t0.dimensions AS dimensions_7, t0.css_class AS css_class_8, t0.custom_style AS custom_style_9, t0.html_content AS html_content_10, t0.header_image AS header_image_11, t0.background_color AS background_color_12, t0.gradient_end_color AS gradient_end_color_13, t0.advert_title AS advert_title_14, t0.description AS description_15, t0.cta_text AS cta_text_16, t0.impression_count AS impression_count_17, t0.click_count AS click_count_18, t0.is_active AS is_active_19, t0.advert_target AS advert_target_20, t0.created_at AS created_at_21, t0.updated_at AS updated_at_22, t0.created_by_id AS created_by_id_23 FROM advert t0 WHERE t0.is_active = ? AND t0.advert_target = ? ORDER BY t0.created_at DESC
Parameters: [
1
"gallery"
]
SELECT t0.id AS id_1, t0.title AS title_2, t0.format AS format_3, t0.image_url AS image_url_4, t0.link_url AS link_url_5, t0.alt_text AS alt_text_6, t0.dimensions AS dimensions_7, t0.css_class AS css_class_8, t0.custom_style AS custom_style_9, t0.html_content AS html_content_10, t0.header_image AS header_image_11, t0.background_color AS background_color_12, t0.gradient_end_color AS gradient_end_color_13, t0.advert_title AS advert_title_14, t0.description AS description_15, t0.cta_text AS cta_text_16, t0.impression_count AS impression_count_17, t0.click_count AS click_count_18, t0.is_active AS is_active_19, t0.advert_target AS advert_target_20, t0.created_at AS created_at_21, t0.updated_at AS updated_at_22, t0.created_by_id AS created_by_id_23 FROM advert t0 WHERE t0.is_active = 1 AND t0.advert_target = 'gallery' ORDER BY t0.created_at DESC;
|
| 4 |
0.25 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;
|
| 5 |
0.19 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;
|
| 6 |
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: [
1780473936
1780473936
"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 <= 1780473936)) AND ((b0_.end_date IS NULL OR b0_.end_date >= 1780473936)) AND b0_.position = 'header' ORDER BY b0_.sort_order ASC;
|
| 7 |
0.52 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.format AS format_3, t0.image_url AS image_url_4, t0.link_url AS link_url_5, t0.alt_text AS alt_text_6, t0.dimensions AS dimensions_7, t0.css_class AS css_class_8, t0.custom_style AS custom_style_9, t0.html_content AS html_content_10, t0.header_image AS header_image_11, t0.background_color AS background_color_12, t0.gradient_end_color AS gradient_end_color_13, t0.advert_title AS advert_title_14, t0.description AS description_15, t0.cta_text AS cta_text_16, t0.impression_count AS impression_count_17, t0.click_count AS click_count_18, t0.is_active AS is_active_19, t0.advert_target AS advert_target_20, t0.created_at AS created_at_21, t0.updated_at AS updated_at_22, t0.created_by_id AS created_by_id_23 FROM advert t0 WHERE t0.is_active = ? AND t0.advert_target = ? ORDER BY t0.created_at DESC
Parameters: [
1
"forum"
]
SELECT t0.id AS id_1, t0.title AS title_2, t0.format AS format_3, t0.image_url AS image_url_4, t0.link_url AS link_url_5, t0.alt_text AS alt_text_6, t0.dimensions AS dimensions_7, t0.css_class AS css_class_8, t0.custom_style AS custom_style_9, t0.html_content AS html_content_10, t0.header_image AS header_image_11, t0.background_color AS background_color_12, t0.gradient_end_color AS gradient_end_color_13, t0.advert_title AS advert_title_14, t0.description AS description_15, t0.cta_text AS cta_text_16, t0.impression_count AS impression_count_17, t0.click_count AS click_count_18, t0.is_active AS is_active_19, t0.advert_target AS advert_target_20, t0.created_at AS created_at_21, t0.updated_at AS updated_at_22, t0.created_by_id AS created_by_id_23 FROM advert t0 WHERE t0.is_active = 1 AND t0.advert_target = 'forum' ORDER BY t0.created_at DESC;
|
| 8 |
0.20 ms |
SELECT t0.id AS id_1, t0.username AS username_2, t0.slug AS slug_3, t0.auth_key AS auth_key_4, t0.password_hash AS password_hash_5, t0.password_reset_token AS password_reset_token_6, t0.email AS email_7, t0.status AS status_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.verification_token AS verification_token_11, t0.role AS role_12, t0.first_name AS first_name_13, t0.last_name AS last_name_14, t0.phone AS phone_15, t0.whatsapp_number AS whatsapp_number_16, t0.website AS website_17, t0.address AS address_18, t0.bio AS bio_19, t0.profile_image AS profile_image_20, t0.avatar_path AS avatar_path_21, t0.social_links AS social_links_22, t0.two_factor_enabled AS two_factor_enabled_23, t0.two_factor_secret AS two_factor_secret_24, t0.two_factor_backup_codes AS two_factor_backup_codes_25, t0.failed_login_attempts AS failed_login_attempts_26, t0.locked_until AS locked_until_27, t0.last_failed_login AS last_failed_login_28, t0.billing_address AS billing_address_29, t0.total_points AS total_points_30, t0.is_deactivated AS is_deactivated_31, t0.deactivated_at AS deactivated_at_32, t0.referred_by AS referred_by_33, t0.is_approved AS is_approved_34, t0.approved_at AS approved_at_35, t0.approved_by AS approved_by_36 FROM user t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.username AS username_2, t0.slug AS slug_3, t0.auth_key AS auth_key_4, t0.password_hash AS password_hash_5, t0.password_reset_token AS password_reset_token_6, t0.email AS email_7, t0.status AS status_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.verification_token AS verification_token_11, t0.role AS role_12, t0.first_name AS first_name_13, t0.last_name AS last_name_14, t0.phone AS phone_15, t0.whatsapp_number AS whatsapp_number_16, t0.website AS website_17, t0.address AS address_18, t0.bio AS bio_19, t0.profile_image AS profile_image_20, t0.avatar_path AS avatar_path_21, t0.social_links AS social_links_22, t0.two_factor_enabled AS two_factor_enabled_23, t0.two_factor_secret AS two_factor_secret_24, t0.two_factor_backup_codes AS two_factor_backup_codes_25, t0.failed_login_attempts AS failed_login_attempts_26, t0.locked_until AS locked_until_27, t0.last_failed_login AS last_failed_login_28, t0.billing_address AS billing_address_29, t0.total_points AS total_points_30, t0.is_deactivated AS is_deactivated_31, t0.deactivated_at AS deactivated_at_32, t0.referred_by AS referred_by_33, t0.is_approved AS is_approved_34, t0.approved_at AS approved_at_35, t0.approved_by AS approved_by_36 FROM user t0 WHERE t0.id = 658;
|
| 9 |
0.32 ms |
SELECT g0_.id AS id_0, g0_.name AS name_1, g0_.slug AS slug_2, g0_.source_type AS source_type_3, g0_.status AS status_4, g0_.filter_config AS filter_config_5, g0_.created_at AS created_at_6, g0_.updated_at AS updated_at_7 FROM gallery g0_ WHERE g0_.slug = ? AND g0_.status = ?
Parameters: [
"top5"
10
]
SELECT g0_.id AS id_0, g0_.name AS name_1, g0_.slug AS slug_2, g0_.source_type AS source_type_3, g0_.status AS status_4, g0_.filter_config AS filter_config_5, g0_.created_at AS created_at_6, g0_.updated_at AS updated_at_7 FROM gallery g0_ WHERE g0_.slug = 'top5' AND g0_.status = 10;
|
| 10 |
0.19 ms |
SELECT g0_.id AS id_0, g0_.name AS name_1, g0_.slug AS slug_2, g0_.source_type AS source_type_3, g0_.status AS status_4, g0_.filter_config AS filter_config_5, g0_.created_at AS created_at_6, g0_.updated_at AS updated_at_7 FROM gallery g0_ WHERE g0_.slug = ? AND g0_.status = ?
Parameters: [
"top5"
10
]
SELECT g0_.id AS id_0, g0_.name AS name_1, g0_.slug AS slug_2, g0_.source_type AS source_type_3, g0_.status AS status_4, g0_.filter_config AS filter_config_5, g0_.created_at AS created_at_6, g0_.updated_at AS updated_at_7 FROM gallery g0_ WHERE g0_.slug = 'top5' AND g0_.status = 10;
|
| 11 |
0.19 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: [
1780473936
1780473936
"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 <= 1780473936)) AND ((b0_.end_date IS NULL OR b0_.end_date >= 1780473936)) AND b0_.position = 'footer' ORDER BY b0_.sort_order ASC;
|