Symfony Profiler

"COMMIT"

"COMMIT";

INSERT INTO yd_leads (
  is_published, date_added, created_by,
  created_by_user, date_modified,
  modified_by, modified_by_user, checked_out,
  checked_out_by, checked_out_by_user,
  points, last_active, internal, social_cache,
  date_identified, preferred_profile_image,
  title, firstname, lastname, company,
  position, email, phone, mobile, address1,
  address2, city, state, zipcode, timezone,
  country, owner_id, stage_id
)
VALUES
  (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?
  )

INSERT INTO yd_leads (is_published, date_added, created_by, created_by_user, date_modified, modified_by, modified_by_user, checked_out, checked_out_by, checked_out_by_user, points, last_active, internal, social_cache, date_identified, preferred_profile_image, title, firstname, lastname, company, position, email, phone, mobile, address1, address2, city, state, zipcode, timezone, country, owner_id, stage_id) VALUES (1, '2026-05-26 05:51:06', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, 'a:0:{}', 'a:0:{}', NULL, 'gravatar', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO yd_ip_addresses (ip_address, ip_details)
VALUES
  (?, ?)

INSERT INTO yd_ip_addresses (ip_address, ip_details) VALUES ('216.73.217.15', 'a:10:{s:4:\"city\";s:0:\"\";s:6:\"region\";s:0:\"\";s:7:\"zipcode\";s:0:\"\";s:7:\"country\";s:0:\"\";s:8:\"latitude\";s:0:\"\";s:9:\"longitude\";s:0:\"\";s:3:\"isp\";s:0:\"\";s:12:\"organization\";s:0:\"\";s:8:\"timezone\";s:0:\"\";s:5:\"extra\";s:0:\"\";}');

SELECT
  y0_.id AS id_0,
  y0_.name AS name_1,
  y0_.description AS description_2,
  y0_.type AS type_3,
  y0_.event_type AS event_type_4,
  y0_.event_order AS event_order_5,
  y0_.properties AS properties_6,
  y0_.deleted AS deleted_7,
  y0_.trigger_date AS trigger_date_8,
  y0_.trigger_interval AS trigger_interval_9,
  y0_.trigger_interval_unit AS trigger_interval_unit_10,
  y0_.trigger_hour AS trigger_hour_11,
  y0_.trigger_restricted_start_hour AS trigger_restricted_start_hour_12,
  y0_.trigger_restricted_stop_hour AS trigger_restricted_stop_hour_13,
  y0_.trigger_restricted_dow AS trigger_restricted_dow_14,
  y0_.trigger_window AS trigger_window_15,
  y0_.trigger_mode AS trigger_mode_16,
  y0_.decision_path AS decision_path_17,
  y0_.temp_id AS temp_id_18,
  y0_.channel AS channel_19,
  y0_.channel_id AS channel_id_20,
  y0_.failed_count AS failed_count_21,
  y0_.uuid AS uuid_22,
  y1_.is_published AS is_published_23,
  y1_.date_added AS date_added_24,
  y1_.created_by AS created_by_25,
  y1_.created_by_user AS created_by_user_26,
  y1_.date_modified AS date_modified_27,
  y1_.modified_by AS modified_by_28,
  y1_.modified_by_user AS modified_by_user_29,
  y1_.checked_out AS checked_out_30,
  y1_.checked_out_by AS checked_out_by_31,
  y1_.checked_out_by_user AS checked_out_by_user_32,
  y1_.id AS id_33,
  y1_.name AS name_34,
  y1_.description AS description_35,
  y1_.publish_up AS publish_up_36,
  y1_.publish_down AS publish_down_37,
  y1_.republish_behavior AS republish_behavior_38,
  y1_.canvas_settings AS canvas_settings_39,
  y1_.allow_restart AS allow_restart_40,
  y1_.deleted AS deleted_41,
  y1_.version AS version_42,
  y1_.uuid AS uuid_43,
  y0_.redirect_event_id AS redirect_event_id_44,
  y0_.campaign_id AS campaign_id_45,
  y0_.parent_id AS parent_id_46,
  y1_.category_id AS category_id_47
FROM
  yd_campaign_events y0_
  INNER JOIN yd_campaigns y1_ ON y0_.campaign_id = y1_.id
  INNER JOIN yd_campaign_leads y2_ ON y1_.id = y2_.campaign_id
WHERE
  y1_.is_published = 1
  AND (
    y1_.publish_up IS NULL
    OR y1_.publish_up < CURRENT_TIMESTAMP
  )
  AND (
    y1_.publish_down IS NULL
    OR y1_.publish_down > CURRENT_TIMESTAMP
  )
  AND y1_.deleted IS NULL
  AND y0_.type = ?
  AND y2_.lead_id = ?
  AND y2_.manually_removed = 0
  AND (
    y0_.id NOT IN (
      SELECT
        y3_.event_id AS sclr_48
      FROM
        yd_campaign_lead_event_log y3_
      WHERE
        y3_.event_id = y0_.id
        AND y3_.lead_id = y2_.lead_id
        AND y3_.rotation = y2_.rotation
    )
  )
  AND (
    y0_.parent_id IS NULL
    OR (
      EXISTS (
        SELECT
          y4_.id
        FROM
          yd_campaign_lead_event_log y4_
        WHERE
          y4_.event_id = y0_.parent_id
          AND y4_.lead_id = y2_.lead_id
          AND y4_.rotation = y2_.rotation
          AND y4_.is_scheduled = 0
      )
    )
  )

SELECT y0_.id AS id_0, y0_.name AS name_1, y0_.description AS description_2, y0_.type AS type_3, y0_.event_type AS event_type_4, y0_.event_order AS event_order_5, y0_.properties AS properties_6, y0_.deleted AS deleted_7, y0_.trigger_date AS trigger_date_8, y0_.trigger_interval AS trigger_interval_9, y0_.trigger_interval_unit AS trigger_interval_unit_10, y0_.trigger_hour AS trigger_hour_11, y0_.trigger_restricted_start_hour AS trigger_restricted_start_hour_12, y0_.trigger_restricted_stop_hour AS trigger_restricted_stop_hour_13, y0_.trigger_restricted_dow AS trigger_restricted_dow_14, y0_.trigger_window AS trigger_window_15, y0_.trigger_mode AS trigger_mode_16, y0_.decision_path AS decision_path_17, y0_.temp_id AS temp_id_18, y0_.channel AS channel_19, y0_.channel_id AS channel_id_20, y0_.failed_count AS failed_count_21, y0_.uuid AS uuid_22, y1_.is_published AS is_published_23, y1_.date_added AS date_added_24, y1_.created_by AS created_by_25, y1_.created_by_user AS created_by_user_26, y1_.date_modified AS date_modified_27, y1_.modified_by AS modified_by_28, y1_.modified_by_user AS modified_by_user_29, y1_.checked_out AS checked_out_30, y1_.checked_out_by AS checked_out_by_31, y1_.checked_out_by_user AS checked_out_by_user_32, y1_.id AS id_33, y1_.name AS name_34, y1_.description AS description_35, y1_.publish_up AS publish_up_36, y1_.publish_down AS publish_down_37, y1_.republish_behavior AS republish_behavior_38, y1_.canvas_settings AS canvas_settings_39, y1_.allow_restart AS allow_restart_40, y1_.deleted AS deleted_41, y1_.version AS version_42, y1_.uuid AS uuid_43, y0_.redirect_event_id AS redirect_event_id_44, y0_.campaign_id AS campaign_id_45, y0_.parent_id AS parent_id_46, y1_.category_id AS category_id_47 FROM yd_campaign_events y0_ INNER JOIN yd_campaigns y1_ ON y0_.campaign_id = y1_.id INNER JOIN yd_campaign_leads y2_ ON y1_.id = y2_.campaign_id WHERE y1_.is_published = 1 AND (y1_.publish_up IS NULL OR y1_.publish_up < CURRENT_TIMESTAMP) AND (y1_.publish_down IS NULL OR y1_.publish_down > CURRENT_TIMESTAMP) AND y1_.deleted IS NULL AND y0_.type = 'page.pagehit' AND y2_.lead_id = 457975 AND y2_.manually_removed = 0 AND (y0_.id NOT IN (SELECT y3_.event_id AS sclr_48 FROM yd_campaign_lead_event_log y3_ WHERE y3_.event_id = y0_.id AND y3_.lead_id = y2_.lead_id AND y3_.rotation = y2_.rotation)) AND (y0_.parent_id IS NULL OR (EXISTS (SELECT y4_.id FROM yd_campaign_lead_event_log y4_ WHERE y4_.event_id = y0_.parent_id AND y4_.lead_id = y2_.lead_id AND y4_.rotation = y2_.rotation AND y4_.is_scheduled = 0)));

UPDATE
  yd_leads
SET
  last_active = ?
WHERE
  id = ?

UPDATE yd_leads SET last_active = '2026-05-26 05:51:06' WHERE id = 457975;

"START TRANSACTION"

"START TRANSACTION";

SELECT
  y0_.id AS id_0,
  y0_.name AS name_1,
  y0_.type AS type_2,
  y0_.properties AS properties_3,
  y1_.id AS id_4,
  y1_.name AS name_5,
  y1_.points AS points_6,
  y1_.color AS color_7
FROM
  yd_point_trigger_events y0_
  LEFT JOIN yd_point_triggers y1_ ON y0_.trigger_id = y1_.id
WHERE
  y1_.is_published = ?
  AND (
    y1_.publish_down IS NULL
    OR y1_.publish_down >= ?
  )
  AND (
    y1_.publish_up IS NULL
    OR y1_.publish_up <= ?
  )
  AND y1_.points <= 0
  AND y1_.group_id IS NULL
ORDER BY
  y0_.action_order ASC,
  y1_.points ASC

SELECT y0_.id AS id_0, y0_.name AS name_1, y0_.type AS type_2, y0_.properties AS properties_3, y1_.id AS id_4, y1_.name AS name_5, y1_.points AS points_6, y1_.color AS color_7 FROM yd_point_trigger_events y0_ LEFT JOIN yd_point_triggers y1_ ON y0_.trigger_id = y1_.id WHERE y1_.is_published = 1 AND (y1_.publish_down IS NULL OR y1_.publish_down >= '2026-05-26 05:51:06') AND (y1_.publish_up IS NULL OR y1_.publish_up <= '2026-05-26 05:51:06') AND y1_.points <= 0 AND y1_.group_id IS NULL ORDER BY y0_.action_order ASC, y1_.points ASC;

INSERT INTO yd_audit_log (
  user_id, user_name, bundle, object,
  object_id, action, details, date_added,
  ip_address
)
VALUES
  (?, ?, ?, ?, ?, ?, ?, ?, ?)

INSERT INTO yd_audit_log (user_id, user_name, bundle, object, object_id, action, details, date_added, ip_address) VALUES (0, '系统', 'lead', 'lead', '457975', 'create', 'a:1:{s:11:\"ipAddresses\";a:2:{i:0;s:0:\"\";i:1;s:13:\"216.73.217.15\";}}', '2026-05-26 05:51:06', '216.73.217.15');

INSERT INTO yd_page_hits (
  date_hit, date_left, country, region,
  city, isp, organization, code, referer,
  url, url_title, user_agent, remote_host,
  page_language, browser_languages,
  tracking_id, source, source_id, query,
  page_id, redirect_id, email_id, lead_id,
  ip_id, device_id
)
VALUES
  (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?
  )

INSERT INTO yd_page_hits (date_hit, date_left, country, region, city, isp, organization, code, referer, url, url_title, user_agent, remote_host, page_language, browser_languages, tracking_id, source, source_id, query, page_id, redirect_id, email_id, lead_id, ip_id, device_id) VALUES ('2026-05-26 05:51:06', NULL, NULL, NULL, NULL, NULL, NULL, 404, NULL, NULL, NULL, NULL, NULL, NULL, 'a:0:{}', '5ylx2ihknlxpls2n8ea6124', NULL, NULL, 'a:1:{s:8:\"page_url\";s:43:\"http://market.qiuqiutiaokong.cn/sitemap.xml\";}', NULL, NULL, NULL, NULL, 10, '19');

INSERT INTO yd_lead_event_log (
  user_id, user_name, bundle, object,
  action, object_id, date_added, properties,
  lead_id
)
VALUES
  (?, ?, ?, ?, ?, ?, ?, ?, ?)

INSERT INTO yd_lead_event_log (user_id, user_name, bundle, object, action, object_id, date_added, properties, lead_id) VALUES (NULL, NULL, 'page', 'hit', 'created_contact', 118, '2026-05-26 05:51:06', '{\"object_description\":\"http:\\/\\/market.qiuqiutiaokong.cn\\/sitemap.xml\"}', '457975');

SELECT
  y0_.is_published AS is_published_0,
  y0_.date_added AS date_added_1,
  y0_.created_by AS created_by_2,
  y0_.created_by_user AS created_by_user_3,
  y0_.date_modified AS date_modified_4,
  y0_.modified_by AS modified_by_5,
  y0_.modified_by_user AS modified_by_user_6,
  y0_.checked_out AS checked_out_7,
  y0_.checked_out_by AS checked_out_by_8,
  y0_.checked_out_by_user AS checked_out_by_user_9,
  y0_.id AS id_10,
  y0_.label AS label_11,
  y0_.alias AS alias_12,
  y0_.type AS type_13,
  y0_.field_group AS field_group_14,
  y0_.default_value AS default_value_15,
  y0_.is_required AS is_required_16,
  y0_.is_fixed AS is_fixed_17,
  y0_.is_visible AS is_visible_18,
  y0_.is_short_visible AS is_short_visible_19,
  y0_.is_listable AS is_listable_20,
  y0_.is_publicly_updatable AS is_publicly_updatable_21,
  y0_.is_unique_identifer AS is_unique_identifer_22,
  y0_.is_index AS is_index_23,
  y0_.char_length_limit AS char_length_limit_24,
  y0_.field_order AS field_order_25,
  y0_.object AS object_26,
  y0_.properties AS properties_27,
  y0_.column_is_not_created AS column_is_not_created_28,
  y0_.column_is_not_removed AS column_is_not_removed_29,
  y0_.original_is_published_value AS original_is_published_value_30,
  y0_.uuid AS uuid_31
FROM
  yd_lead_fields y0_
WHERE
  y0_.is_published = ?
  AND y0_.object = ?
ORDER BY
  y0_.field_order ASC

SELECT y0_.is_published AS is_published_0, y0_.date_added AS date_added_1, y0_.created_by AS created_by_2, y0_.created_by_user AS created_by_user_3, y0_.date_modified AS date_modified_4, y0_.modified_by AS modified_by_5, y0_.modified_by_user AS modified_by_user_6, y0_.checked_out AS checked_out_7, y0_.checked_out_by AS checked_out_by_8, y0_.checked_out_by_user AS checked_out_by_user_9, y0_.id AS id_10, y0_.label AS label_11, y0_.alias AS alias_12, y0_.type AS type_13, y0_.field_group AS field_group_14, y0_.default_value AS default_value_15, y0_.is_required AS is_required_16, y0_.is_fixed AS is_fixed_17, y0_.is_visible AS is_visible_18, y0_.is_short_visible AS is_short_visible_19, y0_.is_listable AS is_listable_20, y0_.is_publicly_updatable AS is_publicly_updatable_21, y0_.is_unique_identifer AS is_unique_identifer_22, y0_.is_index AS is_index_23, y0_.char_length_limit AS char_length_limit_24, y0_.field_order AS field_order_25, y0_.object AS object_26, y0_.properties AS properties_27, y0_.column_is_not_created AS column_is_not_created_28, y0_.column_is_not_removed AS column_is_not_removed_29, y0_.original_is_published_value AS original_is_published_value_30, y0_.uuid AS uuid_31 FROM yd_lead_fields y0_ WHERE y0_.is_published = 1 AND y0_.object = 'company' ORDER BY y0_.field_order ASC;

SELECT
  y0_.id AS id_0,
  y0_.name AS name_1,
  y0_.type AS type_2,
  y0_.repeatable AS repeatable_3,
  y0_.delta AS delta_4,
  y0_.properties AS properties_5,
  y0_.category_id AS category_id_6,
  y0_.group_id AS group_id_7
FROM
  yd_points y0_
WHERE
  y0_.is_published = ?
  AND (
    y0_.publish_down IS NULL
    OR y0_.publish_down >= ?
  )
  AND (
    y0_.publish_up IS NULL
    OR y0_.publish_up <= ?
  )
  AND y0_.type = ?

SELECT y0_.id AS id_0, y0_.name AS name_1, y0_.type AS type_2, y0_.repeatable AS repeatable_3, y0_.delta AS delta_4, y0_.properties AS properties_5, y0_.category_id AS category_id_6, y0_.group_id AS group_id_7 FROM yd_points y0_ WHERE y0_.is_published = 1 AND (y0_.publish_down IS NULL OR y0_.publish_down >= '2026-05-26 05:51:06') AND (y0_.publish_up IS NULL OR y0_.publish_up <= '2026-05-26 05:51:06') AND y0_.type = 'url.hit';

SELECT
  y0_.is_published AS is_published_0,
  y0_.date_added AS date_added_1,
  y0_.created_by AS created_by_2,
  y0_.created_by_user AS created_by_user_3,
  y0_.date_modified AS date_modified_4,
  y0_.modified_by AS modified_by_5,
  y0_.modified_by_user AS modified_by_user_6,
  y0_.checked_out AS checked_out_7,
  y0_.checked_out_by AS checked_out_by_8,
  y0_.checked_out_by_user AS checked_out_by_user_9,
  y0_.id AS id_10,
  y0_.title AS title_11,
  y0_.alias AS alias_12,
  y0_.template AS template_13,
  y0_.custom_html AS custom_html_14,
  y0_.content AS content_15,
  y0_.publish_up AS publish_up_16,
  y0_.publish_down AS publish_down_17,
  y0_.hits AS hits_18,
  y0_.unique_hits AS unique_hits_19,
  y0_.variant_hits AS variant_hits_20,
  y0_.revision AS revision_21,
  y0_.meta_description AS meta_description_22,
  y0_.head_script AS head_script_23,
  y0_.footer_script AS footer_script_24,
  y0_.redirect_type AS redirect_type_25,
  y0_.redirect_url AS redirect_url_26,
  y0_.is_preference_center AS is_preference_center_27,
  y0_.no_index AS no_index_28,
  y0_.public_preview AS public_preview_29,
  y0_.lang AS lang_30,
  y0_.variant_settings AS variant_settings_31,
  y0_.variant_start_date AS variant_start_date_32,
  y0_.uuid AS uuid_33,
  y0_.category_id AS category_id_34,
  y0_.translation_parent_id AS translation_parent_id_35,
  y0_.variant_parent_id AS variant_parent_id_36
FROM
  yd_pages y0_
WHERE
  y0_.alias = ?
  AND y0_.translation_parent_id IS NULL
  AND y0_.variant_parent_id IS NULL

SELECT y0_.is_published AS is_published_0, y0_.date_added AS date_added_1, y0_.created_by AS created_by_2, y0_.created_by_user AS created_by_user_3, y0_.date_modified AS date_modified_4, y0_.modified_by AS modified_by_5, y0_.modified_by_user AS modified_by_user_6, y0_.checked_out AS checked_out_7, y0_.checked_out_by AS checked_out_by_8, y0_.checked_out_by_user AS checked_out_by_user_9, y0_.id AS id_10, y0_.title AS title_11, y0_.alias AS alias_12, y0_.template AS template_13, y0_.custom_html AS custom_html_14, y0_.content AS content_15, y0_.publish_up AS publish_up_16, y0_.publish_down AS publish_down_17, y0_.hits AS hits_18, y0_.unique_hits AS unique_hits_19, y0_.variant_hits AS variant_hits_20, y0_.revision AS revision_21, y0_.meta_description AS meta_description_22, y0_.head_script AS head_script_23, y0_.footer_script AS footer_script_24, y0_.redirect_type AS redirect_type_25, y0_.redirect_url AS redirect_url_26, y0_.is_preference_center AS is_preference_center_27, y0_.no_index AS no_index_28, y0_.public_preview AS public_preview_29, y0_.lang AS lang_30, y0_.variant_settings AS variant_settings_31, y0_.variant_start_date AS variant_start_date_32, y0_.uuid AS uuid_33, y0_.category_id AS category_id_34, y0_.translation_parent_id AS translation_parent_id_35, y0_.variant_parent_id AS variant_parent_id_36 FROM yd_pages y0_ WHERE y0_.alias = 'sitemap.xml' AND y0_.translation_parent_id IS NULL AND y0_.variant_parent_id IS NULL;

SELECT
  t0.id AS id_1,
  t0.date_added AS date_added_2,
  t0.client_info AS client_info_3,
  t0.device AS device_4,
  t0.device_os_name AS device_os_name_5,
  t0.device_os_shortname AS device_os_shortname_6,
  t0.device_os_version AS device_os_version_7,
  t0.device_os_platform AS device_os_platform_8,
  t0.device_brand AS device_brand_9,
  t0.device_model AS device_model_10,
  t0.tracking_id AS tracking_id_11,
  t0.lead_id AS lead_id_12
FROM
  yd_lead_devices t0
WHERE
  t0.lead_id = ?
  AND t0.device = ?
  AND t0.device_brand = ?
  AND t0.device_model = ?
  AND t0.device_os_name IS NULL
LIMIT
  1

SELECT t0.id AS id_1, t0.date_added AS date_added_2, t0.client_info AS client_info_3, t0.device AS device_4, t0.device_os_name AS device_os_name_5, t0.device_os_shortname AS device_os_shortname_6, t0.device_os_version AS device_os_version_7, t0.device_os_platform AS device_os_platform_8, t0.device_brand AS device_brand_9, t0.device_model AS device_model_10, t0.tracking_id AS tracking_id_11, t0.lead_id AS lead_id_12 FROM yd_lead_devices t0 WHERE t0.lead_id = '457975' AND t0.device = '' AND t0.device_brand = '' AND t0.device_model = '' AND t0.device_os_name IS NULL LIMIT 1;

UPDATE
  yd_page_hits
SET
  country = ?,
  region = ?,
  city = ?,
  isp = ?,
  organization = ?,
  url = ?,
  user_agent = ?,
  lead_id = ?
WHERE
  id = ?

UPDATE yd_page_hits SET country = '', region = '', city = '', isp = '', organization = '', url = 'http://market.qiuqiutiaokong.cn/sitemap.xml', user_agent = 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)', lead_id = '457975' WHERE id = '118';

SELECT
  y0_.is_published AS is_published_0,
  y0_.date_added AS date_added_1,
  y0_.created_by AS created_by_2,
  y0_.created_by_user AS created_by_user_3,
  y0_.date_modified AS date_modified_4,
  y0_.modified_by AS modified_by_5,
  y0_.modified_by_user AS modified_by_user_6,
  y0_.checked_out AS checked_out_7,
  y0_.checked_out_by AS checked_out_by_8,
  y0_.checked_out_by_user AS checked_out_by_user_9,
  y0_.id AS id_10,
  y0_.label AS label_11,
  y0_.alias AS alias_12,
  y0_.type AS type_13,
  y0_.field_group AS field_group_14,
  y0_.default_value AS default_value_15,
  y0_.is_required AS is_required_16,
  y0_.is_fixed AS is_fixed_17,
  y0_.is_visible AS is_visible_18,
  y0_.is_short_visible AS is_short_visible_19,
  y0_.is_listable AS is_listable_20,
  y0_.is_publicly_updatable AS is_publicly_updatable_21,
  y0_.is_unique_identifer AS is_unique_identifer_22,
  y0_.is_index AS is_index_23,
  y0_.char_length_limit AS char_length_limit_24,
  y0_.field_order AS field_order_25,
  y0_.object AS object_26,
  y0_.properties AS properties_27,
  y0_.column_is_not_created AS column_is_not_created_28,
  y0_.column_is_not_removed AS column_is_not_removed_29,
  y0_.original_is_published_value AS original_is_published_value_30,
  y0_.uuid AS uuid_31
FROM
  yd_lead_fields y0_
WHERE
  y0_.object = ?
ORDER BY
  y0_.field_order ASC

SELECT y0_.is_published AS is_published_0, y0_.date_added AS date_added_1, y0_.created_by AS created_by_2, y0_.created_by_user AS created_by_user_3, y0_.date_modified AS date_modified_4, y0_.modified_by AS modified_by_5, y0_.modified_by_user AS modified_by_user_6, y0_.checked_out AS checked_out_7, y0_.checked_out_by AS checked_out_by_8, y0_.checked_out_by_user AS checked_out_by_user_9, y0_.id AS id_10, y0_.label AS label_11, y0_.alias AS alias_12, y0_.type AS type_13, y0_.field_group AS field_group_14, y0_.default_value AS default_value_15, y0_.is_required AS is_required_16, y0_.is_fixed AS is_fixed_17, y0_.is_visible AS is_visible_18, y0_.is_short_visible AS is_short_visible_19, y0_.is_listable AS is_listable_20, y0_.is_publicly_updatable AS is_publicly_updatable_21, y0_.is_unique_identifer AS is_unique_identifer_22, y0_.is_index AS is_index_23, y0_.char_length_limit AS char_length_limit_24, y0_.field_order AS field_order_25, y0_.object AS object_26, y0_.properties AS properties_27, y0_.column_is_not_created AS column_is_not_created_28, y0_.column_is_not_removed AS column_is_not_removed_29, y0_.original_is_published_value AS original_is_published_value_30, y0_.uuid AS uuid_31 FROM yd_lead_fields y0_ WHERE y0_.object = 'lead' ORDER BY y0_.field_order ASC;

INSERT INTO yd_lead_ips_xref (lead_id, ip_id)
VALUES
  (?, ?)

INSERT INTO yd_lead_ips_xref (lead_id, ip_id) VALUES ('457975', 10);

INSERT INTO yd_lead_devices (
  date_added, client_info, device, device_os_name,
  device_os_shortname, device_os_version,
  device_os_platform, device_brand,
  device_model, tracking_id, lead_id
)
VALUES
  (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

INSERT INTO yd_lead_devices (date_added, client_info, device, device_os_name, device_os_shortname, device_os_version, device_os_platform, device_brand, device_model, tracking_id, lead_id) VALUES ('2026-05-26 05:51:06', 'N;', '', NULL, NULL, NULL, NULL, '', '', '5ylx2ihknlxpls2n8ea6124', '457975');

SELECT
  y0_.id AS id_0,
  y0_.event_type AS event_type_1,
  y0_.webhook_id AS webhook_id_2
FROM
  yd_webhook_events y0_
  LEFT JOIN yd_webhooks y1_ ON y0_.webhook_id = y1_.id
WHERE
  y0_.event_type = ?
  AND y1_.is_published = ?

SELECT y0_.id AS id_0, y0_.event_type AS event_type_1, y0_.webhook_id AS webhook_id_2 FROM yd_webhook_events y0_ LEFT JOIN yd_webhooks y1_ ON y0_.webhook_id = y1_.id WHERE y0_.event_type = 'mautic.page_on_hit' AND y1_.is_published = 1;

SELECT
  y0_.id AS id_0,
  y0_.name AS name_1,
  y0_.description AS description_2,
  y0_.is_missing AS is_missing_3,
  y0_.bundle AS bundle_4,
  y0_.version AS version_5,
  y0_.author AS author_6
FROM
  yd_plugins y0_
ORDER BY
  y0_.name ASC

SELECT y0_.id AS id_0, y0_.name AS name_1, y0_.description AS description_2, y0_.is_missing AS is_missing_3, y0_.bundle AS bundle_4, y0_.version AS version_5, y0_.author AS author_6 FROM yd_plugins y0_ ORDER BY y0_.name ASC;

SELECT
  y0_.id AS id_0,
  y0_.name AS name_1,
  y0_.is_published AS is_published_2,
  y0_.supported_features AS supported_features_3,
  y0_.api_keys AS api_keys_4,
  y0_.feature_settings AS feature_settings_5,
  y0_.plugin_id AS plugin_id_6
FROM
  yd_plugin_integration_settings y0_
  INNER JOIN yd_plugins y1_ ON y0_.plugin_id = y1_.id

SELECT y0_.id AS id_0, y0_.name AS name_1, y0_.is_published AS is_published_2, y0_.supported_features AS supported_features_3, y0_.api_keys AS api_keys_4, y0_.feature_settings AS feature_settings_5, y0_.plugin_id AS plugin_id_6 FROM yd_plugin_integration_settings y0_ INNER JOIN yd_plugins y1_ ON y0_.plugin_id = y1_.id;

SELECT
  y0_.id AS id_0,
  y0_.name AS name_1,
  y0_.is_published AS is_published_2,
  y0_.supported_features AS supported_features_3,
  y0_.api_keys AS api_keys_4,
  y0_.feature_settings AS feature_settings_5,
  y0_.plugin_id AS plugin_id_6
FROM
  yd_plugin_integration_settings y0_
WHERE
  y0_.name = ?
LIMIT
  1

SELECT y0_.id AS id_0, y0_.name AS name_1, y0_.is_published AS is_published_2, y0_.supported_features AS supported_features_3, y0_.api_keys AS api_keys_4, y0_.feature_settings AS feature_settings_5, y0_.plugin_id AS plugin_id_6 FROM yd_plugin_integration_settings y0_ WHERE y0_.name = 'grapesjsbuilder' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.ip_address AS ip_address_2,
  t0.ip_details AS ip_details_3
FROM
  yd_ip_addresses t0
WHERE
  t0.ip_address = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.ip_address AS ip_address_2, t0.ip_details AS ip_details_3 FROM yd_ip_addresses t0 WHERE t0.ip_address = '216.73.217.15' LIMIT 1;

SELECT
  y0_.id AS id_0,
  y0_.name AS name_1,
  y0_.is_published AS is_published_2,
  y0_.supported_features AS supported_features_3,
  y0_.api_keys AS api_keys_4,
  y0_.feature_settings AS feature_settings_5,
  y0_.plugin_id AS plugin_id_6
FROM
  yd_plugin_integration_settings y0_

SELECT y0_.id AS id_0, y0_.name AS name_1, y0_.is_published AS is_published_2, y0_.supported_features AS supported_features_3, y0_.api_keys AS api_keys_4, y0_.feature_settings AS feature_settings_5, y0_.plugin_id AS plugin_id_6 FROM yd_plugin_integration_settings y0_;

SELECT
  t0.id AS id_1,
  t0.date_added AS date_added_2,
  t0.client_info AS client_info_3,
  t0.device AS device_4,
  t0.device_os_name AS device_os_name_5,
  t0.device_os_shortname AS device_os_shortname_6,
  t0.device_os_version AS device_os_version_7,
  t0.device_os_platform AS device_os_platform_8,
  t0.device_brand AS device_brand_9,
  t0.device_model AS device_model_10,
  t0.tracking_id AS tracking_id_11,
  t0.lead_id AS lead_id_12
FROM
  yd_lead_devices t0
WHERE
  t0.tracking_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.date_added AS date_added_2, t0.client_info AS client_info_3, t0.device AS device_4, t0.device_os_name AS device_os_name_5, t0.device_os_shortname AS device_os_shortname_6, t0.device_os_version AS device_os_version_7, t0.device_os_platform AS device_os_platform_8, t0.device_brand AS device_brand_9, t0.device_model AS device_model_10, t0.tracking_id AS tracking_id_11, t0.lead_id AS lead_id_12 FROM yd_lead_devices t0 WHERE t0.tracking_id = '5ylx2ihknlxpls2n8ea6124' LIMIT 1;

SELECT
  u.is_unique
FROM
  (
    SELECT
      (
        NOT EXISTS (
          SELECT
            null
          FROM
            yd_page_hits h
          WHERE
            h.lead_id = 457975
        )
      ) is_unique
  ) u

SELECT u.is_unique FROM (SELECT (NOT EXISTS (SELECT null FROM yd_page_hits h WHERE h.lead_id = 457975)) is_unique) u;

SELECT
  f.id,
  f.label,
  f.alias,
  f.type,
  f.field_group as "group",
  f.object,
  f.is_fixed,
  f.properties,
  f.default_value
FROM
  yd_lead_fields f
WHERE
  (f.is_published = ?)
  AND (object = ?)
ORDER BY
  f.field_order asc

SELECT f.id, f.label, f.alias, f.type, f.field_group as "group", f.object, f.is_fixed, f.properties, f.default_value FROM yd_lead_fields f WHERE (f.is_published = 1) AND (object = 'lead') ORDER BY f.field_order asc;