Symfony Profiler

INSERT INTO HttpLogs (
  type, userAgent, device, os, osVersion,
  routeName, url, method, status, appVersion,
  data, formData, IpAddress, createdAt,
  updatedAt, deletedAt, userId, organizationId,
  requestId
)
VALUES
  (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?
  )

INSERT INTO HttpLogs (type, userAgent, device, os, osVersion, routeName, url, method, status, appVersion, data, formData, IpAddress, createdAt, updatedAt, deletedAt, userId, organizationId, requestId) VALUES ('REQUEST', NULL, '', 'UNK', 'UNK', 'frontend', 'http://andrew.dev.exacthire.ngrok.app/sitemap.xml', 'GET', NULL, '1.0.0', 'GET /sitemap.xml HTTP/1.1
Accept:            */*
Accept-Encoding:   gzip, br, zstd, deflate
Host:              andrew.dev.exacthire.ngrok.app
Referer:           http://andrew.dev.exacthire.ngrok.app/sitemap.xml
User-Agent:        Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
X-Forwarded-For:   216.73.216.77
X-Forwarded-Host:  andrew.dev.exacthire.ngrok.app
X-Forwarded-Proto: https
X-Php-Ob-Level:    0

', '', '216.73.216.77', '2026-09-28 20:41:40', '2026-09-28 20:41:40', NULL, NULL, NULL, NULL);

SELECT
  c0_.id AS id_0,
  c0_.name AS name_1,
  c0_.subdomain AS subdomain_2,
  c0_.theme AS theme_3,
  c0_.title AS title_4,
  c0_.description AS description_5,
  c0_.footer AS footer_6,
  c0_.displayMap AS displayMap_7,
  c0_.useLocation AS useLocation_8,
  c0_.corporateUrl AS corporateUrl_9,
  c0_.thankYouPageHtml AS thankYouPageHtml_10,
  c0_.headerJavascript AS headerJavascript_11,
  c0_.bodyHtml AS bodyHtml_12,
  c0_.archivedAt AS archivedAt_13,
  c0_.createdAt AS createdAt_14,
  c0_.updatedAt AS updatedAt_15,
  c0_.deletedAt AS deletedAt_16,
  c0_.internalTitle AS internalTitle_17,
  c0_.internalDescription AS internalDescription_18,
  c0_.jobAlertEnabled AS jobAlertEnabled_19,
  c0_.jobAlertName AS jobAlertName_20,
  c0_.jobAlertDescription AS jobAlertDescription_21,
  c0_.jobAlertButtonText AS jobAlertButtonText_22,
  c0_.generalApplicationText AS generalApplicationText_23,
  c0_.generalApplicationButtonText AS generalApplicationButtonText_24,
  c0_.generalApplicationPosition AS generalApplicationPosition_25,
  c1_.id AS id_26,
  c1_.label AS label_27,
  c1_.identifier AS identifier_28,
  c1_.createdAt AS createdAt_29,
  c1_.updatedAt AS updatedAt_30,
  c1_.deletedAt AS deletedAt_31,
  o2_.id AS id_32,
  o2_.name AS name_33,
  o2_.identifier AS identifier_34,
  o2_.loginSubdomain AS loginSubdomain_35,
  o2_.contractExpires AS contractExpires_36,
  o2_.telephone AS telephone_37,
  o2_.email AS email_38,
  o2_.theme AS theme_39,
  o2_.active AS active_40,
  o2_.isDemoSite AS isDemoSite_41,
  o2_.isARootOrganization AS isARootOrganization_42,
  o2_.remoteOrganizationId AS remoteOrganizationId_43,
  o2_.partnerArchivedAt AS partnerArchivedAt_44,
  o2_.createdAt AS createdAt_45,
  o2_.updatedAt AS updatedAt_46,
  o2_.deletedAt AS deletedAt_47,
  o2_.retainDataTo AS retainDataTo_48,
  o2_.lastLoginAt AS lastLoginAt_49,
  o2_.aiCreditLimit AS aiCreditLimit_50,
  o2_.aiCreditsUsed AS aiCreditsUsed_51,
  o2_.aiCreditResetDate AS aiCreditResetDate_52,
  o2_.aiCreditResetDay AS aiCreditResetDay_53,
  o2_.aiEnabled AS aiEnabled_54,
  p3_.id AS id_55,
  p3_.identifier AS identifier_56,
  p3_.name AS name_57,
  p3_.description AS description_58,
  p3_.displayOrder AS displayOrder_59,
  p3_.createdAt AS createdAt_60,
  p3_.updatedAt AS updatedAt_61,
  p3_.deletedAt AS deletedAt_62,
  c0_.careerSiteDisplayTypeId AS careerSiteDisplayTypeId_63,
  c0_.organizationId AS organizationId_64,
  o2_.parentId AS parentId_65,
  o2_.rootDomainId AS rootDomainId_66,
  o2_.planTypeId AS planTypeId_67,
  o2_.lastLoginUserId AS lastLoginUserId_68,
  o2_.aiCreditPlanId AS aiCreditPlanId_69,
  p3_.defaultAiCreditPlanId AS defaultAiCreditPlanId_70
FROM
  CareerSites c0_
  LEFT JOIN CareerSiteDisplayTypes c1_ ON c0_.careerSiteDisplayTypeId = c1_.id
  AND (c1_.deletedAt IS NULL)
  LEFT JOIN Organizations o2_ ON c0_.organizationId = o2_.id
  AND (o2_.deletedAt IS NULL)
  LEFT JOIN PlanTypes p3_ ON o2_.planTypeId = p3_.id
  AND (p3_.deletedAt IS NULL)
WHERE
  (c0_.subdomain = ?)
  AND (c0_.deletedAt IS NULL)
LIMIT
  1

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.subdomain AS subdomain_2, c0_.theme AS theme_3, c0_.title AS title_4, c0_.description AS description_5, c0_.footer AS footer_6, c0_.displayMap AS displayMap_7, c0_.useLocation AS useLocation_8, c0_.corporateUrl AS corporateUrl_9, c0_.thankYouPageHtml AS thankYouPageHtml_10, c0_.headerJavascript AS headerJavascript_11, c0_.bodyHtml AS bodyHtml_12, c0_.archivedAt AS archivedAt_13, c0_.createdAt AS createdAt_14, c0_.updatedAt AS updatedAt_15, c0_.deletedAt AS deletedAt_16, c0_.internalTitle AS internalTitle_17, c0_.internalDescription AS internalDescription_18, c0_.jobAlertEnabled AS jobAlertEnabled_19, c0_.jobAlertName AS jobAlertName_20, c0_.jobAlertDescription AS jobAlertDescription_21, c0_.jobAlertButtonText AS jobAlertButtonText_22, c0_.generalApplicationText AS generalApplicationText_23, c0_.generalApplicationButtonText AS generalApplicationButtonText_24, c0_.generalApplicationPosition AS generalApplicationPosition_25, c1_.id AS id_26, c1_.label AS label_27, c1_.identifier AS identifier_28, c1_.createdAt AS createdAt_29, c1_.updatedAt AS updatedAt_30, c1_.deletedAt AS deletedAt_31, o2_.id AS id_32, o2_.name AS name_33, o2_.identifier AS identifier_34, o2_.loginSubdomain AS loginSubdomain_35, o2_.contractExpires AS contractExpires_36, o2_.telephone AS telephone_37, o2_.email AS email_38, o2_.theme AS theme_39, o2_.active AS active_40, o2_.isDemoSite AS isDemoSite_41, o2_.isARootOrganization AS isARootOrganization_42, o2_.remoteOrganizationId AS remoteOrganizationId_43, o2_.partnerArchivedAt AS partnerArchivedAt_44, o2_.createdAt AS createdAt_45, o2_.updatedAt AS updatedAt_46, o2_.deletedAt AS deletedAt_47, o2_.retainDataTo AS retainDataTo_48, o2_.lastLoginAt AS lastLoginAt_49, o2_.aiCreditLimit AS aiCreditLimit_50, o2_.aiCreditsUsed AS aiCreditsUsed_51, o2_.aiCreditResetDate AS aiCreditResetDate_52, o2_.aiCreditResetDay AS aiCreditResetDay_53, o2_.aiEnabled AS aiEnabled_54, p3_.id AS id_55, p3_.identifier AS identifier_56, p3_.name AS name_57, p3_.description AS description_58, p3_.displayOrder AS displayOrder_59, p3_.createdAt AS createdAt_60, p3_.updatedAt AS updatedAt_61, p3_.deletedAt AS deletedAt_62, c0_.careerSiteDisplayTypeId AS careerSiteDisplayTypeId_63, c0_.organizationId AS organizationId_64, o2_.parentId AS parentId_65, o2_.rootDomainId AS rootDomainId_66, o2_.planTypeId AS planTypeId_67, o2_.lastLoginUserId AS lastLoginUserId_68, o2_.aiCreditPlanId AS aiCreditPlanId_69, p3_.defaultAiCreditPlanId AS defaultAiCreditPlanId_70 FROM CareerSites c0_ LEFT JOIN CareerSiteDisplayTypes c1_ ON c0_.careerSiteDisplayTypeId = c1_.id AND (c1_.deletedAt IS NULL) LEFT JOIN Organizations o2_ ON c0_.organizationId = o2_.id AND (o2_.deletedAt IS NULL) LEFT JOIN PlanTypes p3_ ON o2_.planTypeId = p3_.id AND (p3_.deletedAt IS NULL) WHERE (c0_.subdomain = 'andrew') AND (c0_.deletedAt IS NULL) LIMIT 1;

"COMMIT"

"COMMIT";

"START TRANSACTION"

"START TRANSACTION";

SELECT
  t0.id AS id_1,
  t0.type AS type_2,
  t0.userAgent AS userAgent_3,
  t0.device AS device_4,
  t0.os AS os_5,
  t0.osVersion AS osVersion_6,
  t0.routeName AS routeName_7,
  t0.url AS url_8,
  t0.method AS method_9,
  t0.status AS status_10,
  t0.appVersion AS appVersion_11,
  t0.data AS data_12,
  t0.formData AS formData_13,
  t0.IpAddress AS IpAddress_14,
  t0.createdAt AS createdAt_15,
  t0.updatedAt AS updatedAt_16,
  t0.deletedAt AS deletedAt_17,
  t0.userId AS userId_18,
  t0.organizationId AS organizationId_19,
  t0.requestId AS requestId_20
FROM
  HttpLogs t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.type AS type_2, t0.userAgent AS userAgent_3, t0.device AS device_4, t0.os AS os_5, t0.osVersion AS osVersion_6, t0.routeName AS routeName_7, t0.url AS url_8, t0.method AS method_9, t0.status AS status_10, t0.appVersion AS appVersion_11, t0.data AS data_12, t0.formData AS formData_13, t0.IpAddress AS IpAddress_14, t0.createdAt AS createdAt_15, t0.updatedAt AS updatedAt_16, t0.deletedAt AS deletedAt_17, t0.userId AS userId_18, t0.organizationId AS organizationId_19, t0.requestId AS requestId_20 FROM HttpLogs t0 WHERE t0.id = 208885;