Symfony Profiler

Query Metrics

45 Database Queries

28 Different statements

23.12 ms Query time

9 Invalid entities

526 Managed entities

Grouped Statements

Show all queries

default connection

Time▼	Count	Info
2.95 ms (12.78%)	1	SELECT COUNT() AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.json AS json_2, p0_.startDate AS startDate_3, p0_.endDate AS endDate_4, p0_.statusUpdatedAt AS statusUpdatedAt_5, p0_.organizationDepartmentUpdatedAt AS organizationDepartmentUpdatedAt_6, p0_.isFullServiceHiring AS isFullServiceHiring_7, p0_.fillBy AS fillBy_8, p0_.numberOfHires AS numberOfHires_9, p0_.isTemplate AS isTemplate_10, p0_.isGeneralApplication AS isGeneralApplication_11, p0_.isImported AS isImported_12, p0_.archivedAt AS archivedAt_13, p0_.createdAt AS createdAt_14, p0_.updatedAt AS updatedAt_15, p0_.deletedAt AS deletedAt_16, p0_.locationTypeUpdatedAt AS locationTypeUpdatedAt_17, p1_.id AS id_18, p1_.isPrimary AS isPrimary_19, p1_.createdAt AS createdAt_20, p1_.updatedAt AS updatedAt_21, p1_.deletedAt AS deletedAt_22, l2_.id AS id_23, l2_.name AS name_24, l2_.description AS description_25, l2_.street1 AS street1_26, l2_.street2 AS street2_27, l2_.street3 AS street3_28, l2_.masterLocationId AS masterLocationId_29, l2_.postalCode AS postalCode_30, l2_.createdAt AS createdAt_31, l2_.updatedAt AS updatedAt_32, l2_.archivedAt AS archivedAt_33, l2_.deletedAt AS deletedAt_34, l2_.latitude AS latitude_35, l2_.longitude AS longitude_36 FROM Positions p0_ INNER JOIN Organizations o3_ ON p0_.organizationId = o3_.id LEFT JOIN DataPointOptions d4_ ON p0_.statusId = d4_.id INNER JOIN PositionLocations p1_ ON p0_.id = p1_.positionId AND (p1_.deletedAt IS NULL) INNER JOIN Locations l2_ ON p1_.locationId = l2_.id LEFT JOIN HiringTeamManagers h5_ ON p0_.id = h5_.positionId LEFT JOIN DataPointOptions d6_ ON p0_.locationTypeId = d6_.id WHERE o3_.id = ? AND p0_.parentId IS NULL AND p0_.isTemplate = ? AND (p0_.archivedAt IS NULL) AND (p0_.deletedAt IS NULL) AND p0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND (p1_.deletedAt IS NULL AND h5_.deletedAt IS NULL) ORDER BY p0_.id DESC, p0_.id DESC) dctrn_result) dctrn_table Parameters: [3 0 19 20 21 22 23 24 25 26 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 52 53 54 55 67 68 69 70 71 72 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 860 861 866 867 868 869 870 871 872 873 874 875 876 877 878 879 880 881 882 883 884 885 886 887 888 889 891 892 893 894 895 896 897 898 899 900 905 906 907 908 909 910 921 922 923 924 925 926 927 930 931 932 933 934 935 936 937 944 945 976 977 996 997 1000 1001 1006 1007 1008 1009 1010 1011 1012 1013 1014 1015 1024 1025 1026 1027 1028 1029 1030 1031 1036 1037 1038 1039 1040 1041 1052 1053 1058 1059 1062 1067 1068 1071 1072 1073 1074 1075 1076 1077 1078 1079 1963 1964 1965 1966 2014 2015 2016 2017 2018 2019 2022 2023 2024 2025 2026 2027] View formatted query View runnable query Explain query SELECT COUNT() AS dctrn_count FROM ( SELECT DISTINCT id_0 FROM ( SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.json AS json_2, p0_.startDate AS startDate_3, p0_.endDate AS endDate_4, p0_.statusUpdatedAt AS statusUpdatedAt_5, p0_.organizationDepartmentUpdatedAt AS organizationDepartmentUpdatedAt_6, p0_.isFullServiceHiring AS isFullServiceHiring_7, p0_.fillBy AS fillBy_8, p0_.numberOfHires AS numberOfHires_9, p0_.isTemplate AS isTemplate_10, p0_.isGeneralApplication AS isGeneralApplication_11, p0_.isImported AS isImported_12, p0_.archivedAt AS archivedAt_13, p0_.createdAt AS createdAt_14, p0_.updatedAt AS updatedAt_15, p0_.deletedAt AS deletedAt_16, p0_.locationTypeUpdatedAt AS locationTypeUpdatedAt_17, p1_.id AS id_18, p1_.isPrimary AS isPrimary_19, p1_.createdAt AS createdAt_20, p1_.updatedAt AS updatedAt_21, p1_.deletedAt AS deletedAt_22, l2_.id AS id_23, l2_.name AS name_24, l2_.description AS description_25, l2_.street1 AS street1_26, l2_.street2 AS street2_27, l2_.street3 AS street3_28, l2_.masterLocationId AS masterLocationId_29, l2_.postalCode AS postalCode_30, l2_.createdAt AS createdAt_31, l2_.updatedAt AS updatedAt_32, l2_.archivedAt AS archivedAt_33, l2_.deletedAt AS deletedAt_34, l2_.latitude AS latitude_35, l2_.longitude AS longitude_36 FROM Positions p0_ INNER JOIN Organizations o3_ ON p0_.organizationId = o3_.id LEFT JOIN DataPointOptions d4_ ON p0_.statusId = d4_.id INNER JOIN PositionLocations p1_ ON p0_.id = p1_.positionId AND (p1_.deletedAt IS NULL) INNER JOIN Locations l2_ ON p1_.locationId = l2_.id LEFT JOIN HiringTeamManagers h5_ ON p0_.id = h5_.positionId LEFT JOIN DataPointOptions d6_ ON p0_.locationTypeId = d6_.id WHERE o3_.id = ? AND p0_.parentId IS NULL AND p0_.isTemplate = ? AND (p0_.archivedAt IS NULL) AND (p0_.deletedAt IS NULL) AND p0_.id IN ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? ) AND ( p1_.deletedAt IS NULL AND h5_.deletedAt IS NULL ) ORDER BY p0_.id DESC, p0_.id DESC ) dctrn_result ) dctrn_table SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.json AS json_2, p0_.startDate AS startDate_3, p0_.endDate AS endDate_4, p0_.statusUpdatedAt AS statusUpdatedAt_5, p0_.organizationDepartmentUpdatedAt AS organizationDepartmentUpdatedAt_6, p0_.isFullServiceHiring AS isFullServiceHiring_7, p0_.fillBy AS fillBy_8, p0_.numberOfHires AS numberOfHires_9, p0_.isTemplate AS isTemplate_10, p0_.isGeneralApplication AS isGeneralApplication_11, p0_.isImported AS isImported_12, p0_.archivedAt AS archivedAt_13, p0_.createdAt AS createdAt_14, p0_.updatedAt AS updatedAt_15, p0_.deletedAt AS deletedAt_16, p0_.locationTypeUpdatedAt AS locationTypeUpdatedAt_17, p1_.id AS id_18, p1_.isPrimary AS isPrimary_19, p1_.createdAt AS createdAt_20, p1_.updatedAt AS updatedAt_21, p1_.deletedAt AS deletedAt_22, l2_.id AS id_23, l2_.name AS name_24, l2_.description AS description_25, l2_.street1 AS street1_26, l2_.street2 AS street2_27, l2_.street3 AS street3_28, l2_.masterLocationId AS masterLocationId_29, l2_.postalCode AS postalCode_30, l2_.createdAt AS createdAt_31, l2_.updatedAt AS updatedAt_32, l2_.archivedAt AS archivedAt_33, l2_.deletedAt AS deletedAt_34, l2_.latitude AS latitude_35, l2_.longitude AS longitude_36 FROM Positions p0_ INNER JOIN Organizations o3_ ON p0_.organizationId = o3_.id LEFT JOIN DataPointOptions d4_ ON p0_.statusId = d4_.id INNER JOIN PositionLocations p1_ ON p0_.id = p1_.positionId AND (p1_.deletedAt IS NULL) INNER JOIN Locations l2_ ON p1_.locationId = l2_.id LEFT JOIN HiringTeamManagers h5_ ON p0_.id = h5_.positionId LEFT JOIN DataPointOptions d6_ ON p0_.locationTypeId = d6_.id WHERE o3_.id = 3 AND p0_.parentId IS NULL AND p0_.isTemplate = 0 AND (p0_.archivedAt IS NULL) AND (p0_.deletedAt IS NULL) AND p0_.id IN (19, 20, 21, 22, 23, 24, 25, 26, 29, 30, 31, 32, 33, 34, 35, 36, 37, 38, 39, 40, 41, 42, 43, 44, 45, 46, 47, 48, 52, 53, 54, 55, 67, 68, 69, 70, 71, 72, 75, 76, 77, 78, 79, 80, 81, 82, 83, 84, 85, 86, 87, 88, 89, 90, 91, 92, 93, 94, 95, 96, 97, 98, 99, 860, 861, 866, 867, 868, 869, 870, 871, 872, 873, 874, 875, 876, 877, 878, 879, 880, 881, 882, 883, 884, 885, 886, 887, 888, 889, 891, 892, 893, 894, 895, 896, 897, 898, 899, 900, 905, 906, 907, 908, 909, 910, 921, 922, 923, 924, 925, 926, 927, 930, 931, 932, 933, 934, 935, 936, 937, 944, 945, 976, 977, 996, 997, 1000, 1001, 1006, 1007, 1008, 1009, 1010, 1011, 1012, 1013, 1014, 1015, 1024, 1025, 1026, 1027, 1028, 1029, 1030, 1031, 1036, 1037, 1038, 1039, 1040, 1041, 1052, 1053, 1058, 1059, 1062, 1067, 1068, 1071, 1072, 1073, 1074, 1075, 1076, 1077, 1078, 1079, 1963, 1964, 1965, 1966, 2014, 2015, 2016, 2017, 2018, 2019, 2022, 2023, 2024, 2025, 2026, 2027) AND (p1_.deletedAt IS NULL AND h5_.deletedAt IS NULL) ORDER BY p0_.id DESC, p0_.id DESC) dctrn_result) dctrn_table;
2.85 ms (12.31%)	1	SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0 FROM (SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.json AS json_2, p0_.startDate AS startDate_3, p0_.endDate AS endDate_4, p0_.statusUpdatedAt AS statusUpdatedAt_5, p0_.organizationDepartmentUpdatedAt AS organizationDepartmentUpdatedAt_6, p0_.isFullServiceHiring AS isFullServiceHiring_7, p0_.fillBy AS fillBy_8, p0_.numberOfHires AS numberOfHires_9, p0_.isTemplate AS isTemplate_10, p0_.isGeneralApplication AS isGeneralApplication_11, p0_.isImported AS isImported_12, p0_.archivedAt AS archivedAt_13, p0_.createdAt AS createdAt_14, p0_.updatedAt AS updatedAt_15, p0_.deletedAt AS deletedAt_16, p0_.locationTypeUpdatedAt AS locationTypeUpdatedAt_17, p1_.id AS id_18, p1_.isPrimary AS isPrimary_19, p1_.createdAt AS createdAt_20, p1_.updatedAt AS updatedAt_21, p1_.deletedAt AS deletedAt_22, l2_.id AS id_23, l2_.name AS name_24, l2_.description AS description_25, l2_.street1 AS street1_26, l2_.street2 AS street2_27, l2_.street3 AS street3_28, l2_.masterLocationId AS masterLocationId_29, l2_.postalCode AS postalCode_30, l2_.createdAt AS createdAt_31, l2_.updatedAt AS updatedAt_32, l2_.archivedAt AS archivedAt_33, l2_.deletedAt AS deletedAt_34, l2_.latitude AS latitude_35, l2_.longitude AS longitude_36, o3_.id AS id_37, o3_.name AS name_38, o3_.identifier AS identifier_39, o3_.loginSubdomain AS loginSubdomain_40, o3_.contractExpires AS contractExpires_41, o3_.telephone AS telephone_42, o3_.email AS email_43, o3_.theme AS theme_44, o3_.active AS active_45, o3_.isDemoSite AS isDemoSite_46, o3_.isARootOrganization AS isARootOrganization_47, o3_.remoteOrganizationId AS remoteOrganizationId_48, o3_.partnerArchivedAt AS partnerArchivedAt_49, o3_.createdAt AS createdAt_50, o3_.updatedAt AS updatedAt_51, o3_.deletedAt AS deletedAt_52, o3_.retainDataTo AS retainDataTo_53, o3_.lastLoginAt AS lastLoginAt_54, o3_.aiCreditLimit AS aiCreditLimit_55, o3_.aiCreditsUsed AS aiCreditsUsed_56, o3_.aiCreditResetDate AS aiCreditResetDate_57, o3_.aiCreditResetDay AS aiCreditResetDay_58, o3_.aiEnabled AS aiEnabled_59, h4_.id AS id_60, h4_.createdAt AS createdAt_61, h4_.updatedAt AS updatedAt_62, h4_.deletedAt AS deletedAt_63 FROM Positions p0_ INNER JOIN Organizations o3_ ON p0_.organizationId = o3_.id LEFT JOIN DataPointOptions d5_ ON p0_.statusId = d5_.id INNER JOIN PositionLocations p1_ ON p0_.id = p1_.positionId AND (p1_.deletedAt IS NULL) INNER JOIN Locations l2_ ON p1_.locationId = l2_.id LEFT JOIN HiringTeamManagers h4_ ON p0_.id = h4_.positionId LEFT JOIN DataPointOptions d6_ ON p0_.locationTypeId = d6_.id WHERE o3_.id = ? AND p0_.parentId IS NULL AND p0_.isTemplate = ? AND (p0_.archivedAt IS NULL) AND (p0_.deletedAt IS NULL) AND p0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND (p1_.deletedAt IS NULL AND h4_.deletedAt IS NULL)) dctrn_result_inner ORDER BY id_0 DESC, id_0 DESC) dctrn_result LIMIT 50 Parameters: [3 0 19 20 21 22 23 24 25 26 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 52 53 54 55 67 68 69 70 71 72 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 860 861 866 867 868 869 870 871 872 873 874 875 876 877 878 879 880 881 882 883 884 885 886 887 888 889 891 892 893 894 895 896 897 898 899 900 905 906 907 908 909 910 921 922 923 924 925 926 927 930 931 932 933 934 935 936 937 944 945 976 977 996 997 1000 1001 1006 1007 1008 1009 1010 1011 1012 1013 1014 1015 1024 1025 1026 1027 1028 1029 1030 1031 1036 1037 1038 1039 1040 1041 1052 1053 1058 1059 1062 1067 1068 1071 1072 1073 1074 1075 1076 1077 1078 1079 1963 1964 1965 1966 2014 2015 2016 2017 2018 2019 2022 2023 2024 2025 2026 2027] View formatted query View runnable query Explain query SELECT DISTINCT id_0 FROM ( SELECT DISTINCT id_0 FROM ( SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.json AS json_2, p0_.startDate AS startDate_3, p0_.endDate AS endDate_4, p0_.statusUpdatedAt AS statusUpdatedAt_5, p0_.organizationDepartmentUpdatedAt AS organizationDepartmentUpdatedAt_6, p0_.isFullServiceHiring AS isFullServiceHiring_7, p0_.fillBy AS fillBy_8, p0_.numberOfHires AS numberOfHires_9, p0_.isTemplate AS isTemplate_10, p0_.isGeneralApplication AS isGeneralApplication_11, p0_.isImported AS isImported_12, p0_.archivedAt AS archivedAt_13, p0_.createdAt AS createdAt_14, p0_.updatedAt AS updatedAt_15, p0_.deletedAt AS deletedAt_16, p0_.locationTypeUpdatedAt AS locationTypeUpdatedAt_17, p1_.id AS id_18, p1_.isPrimary AS isPrimary_19, p1_.createdAt AS createdAt_20, p1_.updatedAt AS updatedAt_21, p1_.deletedAt AS deletedAt_22, l2_.id AS id_23, l2_.name AS name_24, l2_.description AS description_25, l2_.street1 AS street1_26, l2_.street2 AS street2_27, l2_.street3 AS street3_28, l2_.masterLocationId AS masterLocationId_29, l2_.postalCode AS postalCode_30, l2_.createdAt AS createdAt_31, l2_.updatedAt AS updatedAt_32, l2_.archivedAt AS archivedAt_33, l2_.deletedAt AS deletedAt_34, l2_.latitude AS latitude_35, l2_.longitude AS longitude_36, o3_.id AS id_37, o3_.name AS name_38, o3_.identifier AS identifier_39, o3_.loginSubdomain AS loginSubdomain_40, o3_.contractExpires AS contractExpires_41, o3_.telephone AS telephone_42, o3_.email AS email_43, o3_.theme AS theme_44, o3_.active AS active_45, o3_.isDemoSite AS isDemoSite_46, o3_.isARootOrganization AS isARootOrganization_47, o3_.remoteOrganizationId AS remoteOrganizationId_48, o3_.partnerArchivedAt AS partnerArchivedAt_49, o3_.createdAt AS createdAt_50, o3_.updatedAt AS updatedAt_51, o3_.deletedAt AS deletedAt_52, o3_.retainDataTo AS retainDataTo_53, o3_.lastLoginAt AS lastLoginAt_54, o3_.aiCreditLimit AS aiCreditLimit_55, o3_.aiCreditsUsed AS aiCreditsUsed_56, o3_.aiCreditResetDate AS aiCreditResetDate_57, o3_.aiCreditResetDay AS aiCreditResetDay_58, o3_.aiEnabled AS aiEnabled_59, h4_.id AS id_60, h4_.createdAt AS createdAt_61, h4_.updatedAt AS updatedAt_62, h4_.deletedAt AS deletedAt_63 FROM Positions p0_ INNER JOIN Organizations o3_ ON p0_.organizationId = o3_.id LEFT JOIN DataPointOptions d5_ ON p0_.statusId = d5_.id INNER JOIN PositionLocations p1_ ON p0_.id = p1_.positionId AND (p1_.deletedAt IS NULL) INNER JOIN Locations l2_ ON p1_.locationId = l2_.id LEFT JOIN HiringTeamManagers h4_ ON p0_.id = h4_.positionId LEFT JOIN DataPointOptions d6_ ON p0_.locationTypeId = d6_.id WHERE o3_.id = ? AND p0_.parentId IS NULL AND p0_.isTemplate = ? AND (p0_.archivedAt IS NULL) AND (p0_.deletedAt IS NULL) AND p0_.id IN ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? ) AND ( p1_.deletedAt IS NULL AND h4_.deletedAt IS NULL ) ) dctrn_result_inner ORDER BY id_0 DESC, id_0 DESC ) dctrn_result LIMIT 50 SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0 FROM (SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.json AS json_2, p0_.startDate AS startDate_3, p0_.endDate AS endDate_4, p0_.statusUpdatedAt AS statusUpdatedAt_5, p0_.organizationDepartmentUpdatedAt AS organizationDepartmentUpdatedAt_6, p0_.isFullServiceHiring AS isFullServiceHiring_7, p0_.fillBy AS fillBy_8, p0_.numberOfHires AS numberOfHires_9, p0_.isTemplate AS isTemplate_10, p0_.isGeneralApplication AS isGeneralApplication_11, p0_.isImported AS isImported_12, p0_.archivedAt AS archivedAt_13, p0_.createdAt AS createdAt_14, p0_.updatedAt AS updatedAt_15, p0_.deletedAt AS deletedAt_16, p0_.locationTypeUpdatedAt AS locationTypeUpdatedAt_17, p1_.id AS id_18, p1_.isPrimary AS isPrimary_19, p1_.createdAt AS createdAt_20, p1_.updatedAt AS updatedAt_21, p1_.deletedAt AS deletedAt_22, l2_.id AS id_23, l2_.name AS name_24, l2_.description AS description_25, l2_.street1 AS street1_26, l2_.street2 AS street2_27, l2_.street3 AS street3_28, l2_.masterLocationId AS masterLocationId_29, l2_.postalCode AS postalCode_30, l2_.createdAt AS createdAt_31, l2_.updatedAt AS updatedAt_32, l2_.archivedAt AS archivedAt_33, l2_.deletedAt AS deletedAt_34, l2_.latitude AS latitude_35, l2_.longitude AS longitude_36, o3_.id AS id_37, o3_.name AS name_38, o3_.identifier AS identifier_39, o3_.loginSubdomain AS loginSubdomain_40, o3_.contractExpires AS contractExpires_41, o3_.telephone AS telephone_42, o3_.email AS email_43, o3_.theme AS theme_44, o3_.active AS active_45, o3_.isDemoSite AS isDemoSite_46, o3_.isARootOrganization AS isARootOrganization_47, o3_.remoteOrganizationId AS remoteOrganizationId_48, o3_.partnerArchivedAt AS partnerArchivedAt_49, o3_.createdAt AS createdAt_50, o3_.updatedAt AS updatedAt_51, o3_.deletedAt AS deletedAt_52, o3_.retainDataTo AS retainDataTo_53, o3_.lastLoginAt AS lastLoginAt_54, o3_.aiCreditLimit AS aiCreditLimit_55, o3_.aiCreditsUsed AS aiCreditsUsed_56, o3_.aiCreditResetDate AS aiCreditResetDate_57, o3_.aiCreditResetDay AS aiCreditResetDay_58, o3_.aiEnabled AS aiEnabled_59, h4_.id AS id_60, h4_.createdAt AS createdAt_61, h4_.updatedAt AS updatedAt_62, h4_.deletedAt AS deletedAt_63 FROM Positions p0_ INNER JOIN Organizations o3_ ON p0_.organizationId = o3_.id LEFT JOIN DataPointOptions d5_ ON p0_.statusId = d5_.id INNER JOIN PositionLocations p1_ ON p0_.id = p1_.positionId AND (p1_.deletedAt IS NULL) INNER JOIN Locations l2_ ON p1_.locationId = l2_.id LEFT JOIN HiringTeamManagers h4_ ON p0_.id = h4_.positionId LEFT JOIN DataPointOptions d6_ ON p0_.locationTypeId = d6_.id WHERE o3_.id = 3 AND p0_.parentId IS NULL AND p0_.isTemplate = 0 AND (p0_.archivedAt IS NULL) AND (p0_.deletedAt IS NULL) AND p0_.id IN (19, 20, 21, 22, 23, 24, 25, 26, 29, 30, 31, 32, 33, 34, 35, 36, 37, 38, 39, 40, 41, 42, 43, 44, 45, 46, 47, 48, 52, 53, 54, 55, 67, 68, 69, 70, 71, 72, 75, 76, 77, 78, 79, 80, 81, 82, 83, 84, 85, 86, 87, 88, 89, 90, 91, 92, 93, 94, 95, 96, 97, 98, 99, 860, 861, 866, 867, 868, 869, 870, 871, 872, 873, 874, 875, 876, 877, 878, 879, 880, 881, 882, 883, 884, 885, 886, 887, 888, 889, 891, 892, 893, 894, 895, 896, 897, 898, 899, 900, 905, 906, 907, 908, 909, 910, 921, 922, 923, 924, 925, 926, 927, 930, 931, 932, 933, 934, 935, 936, 937, 944, 945, 976, 977, 996, 997, 1000, 1001, 1006, 1007, 1008, 1009, 1010, 1011, 1012, 1013, 1014, 1015, 1024, 1025, 1026, 1027, 1028, 1029, 1030, 1031, 1036, 1037, 1038, 1039, 1040, 1041, 1052, 1053, 1058, 1059, 1062, 1067, 1068, 1071, 1072, 1073, 1074, 1075, 1076, 1077, 1078, 1079, 1963, 1964, 1965, 1966, 2014, 2015, 2016, 2017, 2018, 2019, 2022, 2023, 2024, 2025, 2026, 2027) AND (p1_.deletedAt IS NULL AND h4_.deletedAt IS NULL)) dctrn_result_inner ORDER BY id_0 DESC, id_0 DESC) dctrn_result LIMIT 50;
2.54 ms (10.98%)	3	SELECT DataPointTypes.`identifier` AS `dataPointTypeIdentifier`, COALESCE(Organizations.`id`, rootOrganization.`id`, systemRootOrganization.`id`) `organizationId`, PlanTypes.`identifier` `planTypeIdentifier`, Providers.`identifier` `providerIdentifier`, ProviderSettings.`description`, ProviderSettings.`identifier`, ProviderSettings.`label`, ProviderSettings.`aiFeatureId`, IF(ProviderSettingViewTypes.`id` IS NULL, 0, 1) `hasClientServiceViewType`, IF(OrganizationProviderSettings.`id` IS NULL, 0, 1) `hasOrganizationOverride`, COALESCE(OrganizationProviderSettings.`value`, PlanTypeProviderSettings.`value`, rootOrganizationProviderSettings.`value`, systemRootOrganizationProviderSettings.`value`) `value`, COALESCE( PlanTypeProviderSettings.`value`, rootOrganizationProviderSettings.`value`, systemRootOrganizationProviderSettings.`value` ) `defaultValue`, /* * Which level the inherited default came from, mirroring the COALESCE * above. The value alone cannot say: a UI telling a customer where a * setting comes from has to distinguish "your plan includes this" from * "this is the default for every organization", and those carry very * different weight when someone is deciding whether to override it. / CASE WHEN PlanTypeProviderSettings.`value` IS NOT NULL THEN 'plan' WHEN rootOrganizationProviderSettings.`value` IS NOT NULL THEN 'domain' WHEN systemRootOrganizationProviderSettings.`value` IS NOT NULL THEN 'system' ELSE NULL END `defaultSource` FROM `Organizations` LEFT JOIN `PlanTypes` ON PlanTypes.`id` = Organizations.`planTypeId` AND PlanTypes.`deletedAt` IS NULL JOIN `RootDomains` ON RootDomains.`id` = Organizations.`rootDomainId` JOIN `Organizations` rootOrganization ON rootOrganization.`id` = RootDomains.`mainOrganizationId` JOIN `Organizations` systemRootOrganization ON systemRootOrganization.`identifier` = ? JOIN `Providers` ON Providers.`id` = ? JOIN `ProviderSettings` ON ProviderSettings.`providerId` = Providers.`id` AND ProviderSettings.`deletedAt` IS NULL JOIN `DataPointTypes` ON DataPointTypes.`id` = ProviderSettings.`dataPointTypeId` JOIN `ViewTypes` ON ViewTypes.`identifier` = ? LEFT JOIN `ProviderSettingViewTypes` ON ProviderSettingViewTypes.`providerSettingId` = ProviderSettings.`id` AND ProviderSettingViewTypes.`viewTypeId` = ViewTypes.`id` AND ProviderSettingViewTypes.`deletedAt` IS NULL LEFT JOIN `OrganizationProviderSettings` ON OrganizationProviderSettings.`organizationId` = Organizations.`id` AND OrganizationProviderSettings.`providerSettingId` = ProviderSettings.`id` AND OrganizationProviderSettings.`deletedAt` IS NULL LEFT JOIN `PlanTypeProviderSettings` ON PlanTypeProviderSettings.`planTypeId` = PlanTypes.`id` AND PlanTypeProviderSettings.`providerSettingId` = ProviderSettings.`id` AND PlanTypeProviderSettings.`deletedAt` IS NULL LEFT JOIN `OrganizationProviderSettings` rootOrganizationProviderSettings ON rootOrganizationProviderSettings.`organizationId` = rootOrganization.`id` AND rootOrganizationProviderSettings.`providerSettingId` = ProviderSettings.`id` AND rootOrganizationProviderSettings.`deletedAt` IS NULL LEFT JOIN `OrganizationProviderSettings` systemRootOrganizationProviderSettings ON systemRootOrganizationProviderSettings.`organizationId` = systemRootOrganization.`id` AND systemRootOrganizationProviderSettings.`providerSettingId` = ProviderSettings.`id` AND systemRootOrganizationProviderSettings.`deletedAt` IS NULL WHERE Organizations.`id` = ? AND Providers.`id` = ? AND NOT (OrganizationProviderSettings.`id` IS NULL AND PlanTypeProviderSettings.`id` IS NULL AND rootOrganizationProviderSettings.`id` IS NULL AND systemRootOrganizationProviderSettings.`id` IS NULL) AND ProviderSettings.`identifier` IN (?) GROUP BY ProviderSettings.`id` Parameters: [`"EXACTHIRE" 5 "CLIENT_SERVICES" 3 5 "OPERATING_MODE"`] View formatted query View runnable query Explain query SELECT DataPointTypes.`identifier` AS `dataPointTypeIdentifier`, COALESCE( Organizations.`id`, rootOrganization.`id`, systemRootOrganization.`id` ) `organizationId`, PlanTypes.`identifier` `planTypeIdentifier`, Providers.`identifier` `providerIdentifier`, ProviderSettings.`description`, ProviderSettings.`identifier`, ProviderSettings.`label`, ProviderSettings.`aiFeatureId`, IF( ProviderSettingViewTypes.`id` IS NULL, 0, 1 ) `hasClientServiceViewType`, IF( OrganizationProviderSettings.`id` IS NULL, 0, 1 ) `hasOrganizationOverride`, COALESCE( OrganizationProviderSettings.`value`, PlanTypeProviderSettings.`value`, rootOrganizationProviderSettings.`value`, systemRootOrganizationProviderSettings.`value` ) `value`, COALESCE( PlanTypeProviderSettings.`value`, rootOrganizationProviderSettings.`value`, systemRootOrganizationProviderSettings.`value` ) `defaultValue`, / * Which level the inherited default came from, mirroring the COALESCE * above. The value alone cannot say: a UI telling a customer where a * setting comes from has to distinguish "your plan includes this" from * "this is the default for every organization", and those carry very * different weight when someone is deciding whether to override it. / CASE WHEN PlanTypeProviderSettings.`value` IS NOT NULL THEN 'plan' WHEN rootOrganizationProviderSettings.`value` IS NOT NULL THEN 'domain' WHEN systemRootOrganizationProviderSettings.`value` IS NOT NULL THEN 'system' ELSE NULL END `defaultSource` FROM `Organizations` LEFT JOIN `PlanTypes` ON PlanTypes.`id` = Organizations.`planTypeId` AND PlanTypes.`deletedAt` IS NULL JOIN `RootDomains` ON RootDomains.`id` = Organizations.`rootDomainId` JOIN `Organizations` rootOrganization ON rootOrganization.`id` = RootDomains.`mainOrganizationId` JOIN `Organizations` systemRootOrganization ON systemRootOrganization.`identifier` = ? JOIN `Providers` ON Providers.`id` = ? JOIN `ProviderSettings` ON ProviderSettings.`providerId` = Providers.`id` AND ProviderSettings.`deletedAt` IS NULL JOIN `DataPointTypes` ON DataPointTypes.`id` = ProviderSettings.`dataPointTypeId` JOIN `ViewTypes` ON ViewTypes.`identifier` = ? LEFT JOIN `ProviderSettingViewTypes` ON ProviderSettingViewTypes.`providerSettingId` = ProviderSettings.`id` AND ProviderSettingViewTypes.`viewTypeId` = ViewTypes.`id` AND ProviderSettingViewTypes.`deletedAt` IS NULL LEFT JOIN `OrganizationProviderSettings` ON OrganizationProviderSettings.`organizationId` = Organizations.`id` AND OrganizationProviderSettings.`providerSettingId` = ProviderSettings.`id` AND OrganizationProviderSettings.`deletedAt` IS NULL LEFT JOIN `PlanTypeProviderSettings` ON PlanTypeProviderSettings.`planTypeId` = PlanTypes.`id` AND PlanTypeProviderSettings.`providerSettingId` = ProviderSettings.`id` AND PlanTypeProviderSettings.`deletedAt` IS NULL LEFT JOIN `OrganizationProviderSettings` rootOrganizationProviderSettings ON rootOrganizationProviderSettings.`organizationId` = rootOrganization.`id` AND rootOrganizationProviderSettings.`providerSettingId` = ProviderSettings.`id` AND rootOrganizationProviderSettings.`deletedAt` IS NULL LEFT JOIN `OrganizationProviderSettings` systemRootOrganizationProviderSettings ON systemRootOrganizationProviderSettings.`organizationId` = systemRootOrganization.`id` AND systemRootOrganizationProviderSettings.`providerSettingId` = ProviderSettings.`id` AND systemRootOrganizationProviderSettings.`deletedAt` IS NULL WHERE Organizations.`id` = ? AND Providers.`id` = ? AND NOT ( OrganizationProviderSettings.`id` IS NULL AND PlanTypeProviderSettings.`id` IS NULL AND rootOrganizationProviderSettings.`id` IS NULL AND systemRootOrganizationProviderSettings.`id` IS NULL ) AND ProviderSettings.`identifier` IN (?) GROUP BY ProviderSettings.`id` SELECT DataPointTypes.`identifier` AS `dataPointTypeIdentifier`, COALESCE(Organizations.`id`, rootOrganization.`id`, systemRootOrganization.`id`) `organizationId`, PlanTypes.`identifier` `planTypeIdentifier`, Providers.`identifier` `providerIdentifier`, ProviderSettings.`description`, ProviderSettings.`identifier`, ProviderSettings.`label`, ProviderSettings.`aiFeatureId`, IF(ProviderSettingViewTypes.`id` IS NULL, 0, 1) `hasClientServiceViewType`, IF(OrganizationProviderSettings.`id` IS NULL, 0, 1) `hasOrganizationOverride`, COALESCE(OrganizationProviderSettings.`value`, PlanTypeProviderSettings.`value`, rootOrganizationProviderSettings.`value`, systemRootOrganizationProviderSettings.`value`) `value`, COALESCE( PlanTypeProviderSettings.`value`, rootOrganizationProviderSettings.`value`, systemRootOrganizationProviderSettings.`value` ) `defaultValue`, / * Which level the inherited default came from, mirroring the COALESCE * above. The value alone cannot say: a UI telling a customer where a * setting comes from has to distinguish "your plan includes this" from * "this is the default for every organization", and those carry very * different weight when someone is deciding whether to override it. */ CASE WHEN PlanTypeProviderSettings.`value` IS NOT NULL THEN 'plan' WHEN rootOrganizationProviderSettings.`value` IS NOT NULL THEN 'domain' WHEN systemRootOrganizationProviderSettings.`value` IS NOT NULL THEN 'system' ELSE NULL END `defaultSource` FROM `Organizations` LEFT JOIN `PlanTypes` ON PlanTypes.`id` = Organizations.`planTypeId` AND PlanTypes.`deletedAt` IS NULL JOIN `RootDomains` ON RootDomains.`id` = Organizations.`rootDomainId` JOIN `Organizations` rootOrganization ON rootOrganization.`id` = RootDomains.`mainOrganizationId` JOIN `Organizations` systemRootOrganization ON systemRootOrganization.`identifier` = 'EXACTHIRE' JOIN `Providers` ON Providers.`id` = 5 JOIN `ProviderSettings` ON ProviderSettings.`providerId` = Providers.`id` AND ProviderSettings.`deletedAt` IS NULL JOIN `DataPointTypes` ON DataPointTypes.`id` = ProviderSettings.`dataPointTypeId` JOIN `ViewTypes` ON ViewTypes.`identifier` = 'CLIENT_SERVICES' LEFT JOIN `ProviderSettingViewTypes` ON ProviderSettingViewTypes.`providerSettingId` = ProviderSettings.`id` AND ProviderSettingViewTypes.`viewTypeId` = ViewTypes.`id` AND ProviderSettingViewTypes.`deletedAt` IS NULL LEFT JOIN `OrganizationProviderSettings` ON OrganizationProviderSettings.`organizationId` = Organizations.`id` AND OrganizationProviderSettings.`providerSettingId` = ProviderSettings.`id` AND OrganizationProviderSettings.`deletedAt` IS NULL LEFT JOIN `PlanTypeProviderSettings` ON PlanTypeProviderSettings.`planTypeId` = PlanTypes.`id` AND PlanTypeProviderSettings.`providerSettingId` = ProviderSettings.`id` AND PlanTypeProviderSettings.`deletedAt` IS NULL LEFT JOIN `OrganizationProviderSettings` rootOrganizationProviderSettings ON rootOrganizationProviderSettings.`organizationId` = rootOrganization.`id` AND rootOrganizationProviderSettings.`providerSettingId` = ProviderSettings.`id` AND rootOrganizationProviderSettings.`deletedAt` IS NULL LEFT JOIN `OrganizationProviderSettings` systemRootOrganizationProviderSettings ON systemRootOrganizationProviderSettings.`organizationId` = systemRootOrganization.`id` AND systemRootOrganizationProviderSettings.`providerSettingId` = ProviderSettings.`id` AND systemRootOrganizationProviderSettings.`deletedAt` IS NULL WHERE Organizations.`id` = 3 AND Providers.`id` = 5 AND NOT (OrganizationProviderSettings.`id` IS NULL AND PlanTypeProviderSettings.`id` IS NULL AND rootOrganizationProviderSettings.`id` IS NULL AND systemRootOrganizationProviderSettings.`id` IS NULL) AND ProviderSettings.`identifier` IN ('OPERATING_MODE') GROUP BY ProviderSettings.`id`;
2.38 ms (10.28%)	2	INSERT INTO HttpLogs (type, userAgent, device, os, osVersion, routeName, url, method, status, appVersion, data, formData, IpAddress, createdAt, updatedAt, deletedAt, userId, organizationId, requestId) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) Parameters: ["REQUEST" null "" "UNK" "UNK" "get_positions" "http://localhost/api/positions?limit=50&page=1" "GET" null "1.0.0" Symfony\Component\HttpFoundation\Request {#13 __toString(): """ GET /api/positions?page=1&limit=50 HTTP/1.1\r\n Accept: /\r\n Authorization: Bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJSUzI1NiJ9.eyJpYXQiOjE3OTA2MjAwNTIsImV4cCI6MTc5MDcwNjQ1Miwicm9sZXMiOlsiUk9MRV9BRE1JTklTVFJBVE9SIl0sImlkIjo2NTcsIm9yZ2FuaXphdGlvbklkIjozLCJ0aW1lWm9uZSI6bnVsbH0.GRZkero3yfy1xUgWfi2u6ggNCYDYccBqI3V7SbmsgjoaIAlHbpRHAcYxZnD2dbKYPAarFaFeqwUMXcek_124AiHIuTuYCSZ7ohlzphsxTkFIdwS8UEv_SKnI9r84EPanmFGhkhPHCpWeGvby3bCzp_KtwRF7WjHFKP8OyJST6S7eUfAg54BcYWNUAgs3CkcrHVaPzwIeHxCYgM8EHl4__m6tFf05ZRufYeVDA-GYd6igDbWwit9yt6VhoOxWT-GuS-3h6ZPwaCF86MF16Bn6lwHROswL3F6JtvUO08Csa-vm8s7yLhhPxERdtHh1yCAATbuk5mcPGrIUIoL2lf7yNT37ZoZm_bJMeHxA43IySTW7k3teJ52q6j3MuDhc7tmtIZ3EHHY81wgwX8W5B065Hd_oGIKy6HJFozqZ5AqLQs1WAwpN6mF22G9p0gkkCuOpFdwvZyENdFKX7mV5rUmnf6IEnv_umL-1Bl0-Lk8eAg2F_wRgb-axd5dBtiPwuPOGEueDsYRD5a-bqRTtjPhakUH6_r-up04xtM1qQw0202AZRv3fYu3tqIOrIl7N0OQP-WVCm7JqvSu2RPt3-aX2QPps7B-PcOYdfmU8442EUeLFIREgJE1fU4aRKIO_um_nmsS4BiNTuxO33x3liETrdRS4iAogWLjQ6nt7tYKr-z8\r\n Host: localhost\r\n User-Agent: curl/8.5.0\r\n X-Php-Ob-Level: 0\r\n \r\n """ } "" "172.22.0.1" "2026-09-28 21:20:50" "2026-09-28 21:20:50" null 657 3 null] View formatted query View runnable query 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', 'get_positions', 'http://localhost/api/positions?limit=50&page=1', 'GET', NULL, '1.0.0', 'GET /api/positions?page=1&limit=50 HTTP/1.1 Accept: / Authorization: Bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJSUzI1NiJ9.eyJpYXQiOjE3OTA2MjAwNTIsImV4cCI6MTc5MDcwNjQ1Miwicm9sZXMiOlsiUk9MRV9BRE1JTklTVFJBVE9SIl0sImlkIjo2NTcsIm9yZ2FuaXphdGlvbklkIjozLCJ0aW1lWm9uZSI6bnVsbH0.GRZkero3yfy1xUgWfi2u6ggNCYDYccBqI3V7SbmsgjoaIAlHbpRHAcYxZnD2dbKYPAarFaFeqwUMXcek_124AiHIuTuYCSZ7ohlzphsxTkFIdwS8UEv_SKnI9r84EPanmFGhkhPHCpWeGvby3bCzp_KtwRF7WjHFKP8OyJST6S7eUfAg54BcYWNUAgs3CkcrHVaPzwIeHxCYgM8EHl4__m6tFf05ZRufYeVDA-GYd6igDbWwit9yt6VhoOxWT-GuS-3h6ZPwaCF86MF16Bn6lwHROswL3F6JtvUO08Csa-vm8s7yLhhPxERdtHh1yCAATbuk5mcPGrIUIoL2lf7yNT37ZoZm_bJMeHxA43IySTW7k3teJ52q6j3MuDhc7tmtIZ3EHHY81wgwX8W5B065Hd_oGIKy6HJFozqZ5AqLQs1WAwpN6mF22G9p0gkkCuOpFdwvZyENdFKX7mV5rUmnf6IEnv_umL-1Bl0-Lk8eAg2F_wRgb-axd5dBtiPwuPOGEueDsYRD5a-bqRTtjPhakUH6_r-up04xtM1qQw0202AZRv3fYu3tqIOrIl7N0OQP-WVCm7JqvSu2RPt3-aX2QPps7B-PcOYdfmU8442EUeLFIREgJE1fU4aRKIO_um_nmsS4BiNTuxO33x3liETrdRS4iAogWLjQ6nt7tYKr-z8 Host: localhost User-Agent: curl/8.5.0 X-Php-Ob-Level: 0 ', '', '172.22.0.1', '2026-09-28 21:20:50', '2026-09-28 21:20:50', NULL, 657, 3, NULL);
1.64 ms (7.09%)	1	SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.json AS json_2, p0_.startDate AS startDate_3, p0_.endDate AS endDate_4, p0_.statusUpdatedAt AS statusUpdatedAt_5, p0_.organizationDepartmentUpdatedAt AS organizationDepartmentUpdatedAt_6, p0_.isFullServiceHiring AS isFullServiceHiring_7, p0_.fillBy AS fillBy_8, p0_.numberOfHires AS numberOfHires_9, p0_.isTemplate AS isTemplate_10, p0_.isGeneralApplication AS isGeneralApplication_11, p0_.isImported AS isImported_12, p0_.archivedAt AS archivedAt_13, p0_.createdAt AS createdAt_14, p0_.updatedAt AS updatedAt_15, p0_.deletedAt AS deletedAt_16, p0_.locationTypeUpdatedAt AS locationTypeUpdatedAt_17, p1_.id AS id_18, p1_.isPrimary AS isPrimary_19, p1_.createdAt AS createdAt_20, p1_.updatedAt AS updatedAt_21, p1_.deletedAt AS deletedAt_22, l2_.id AS id_23, l2_.name AS name_24, l2_.description AS description_25, l2_.street1 AS street1_26, l2_.street2 AS street2_27, l2_.street3 AS street3_28, l2_.masterLocationId AS masterLocationId_29, l2_.postalCode AS postalCode_30, l2_.createdAt AS createdAt_31, l2_.updatedAt AS updatedAt_32, l2_.archivedAt AS archivedAt_33, l2_.deletedAt AS deletedAt_34, l2_.latitude AS latitude_35, l2_.longitude AS longitude_36, p0_.parentId AS parentId_37, p0_.copiedFromId AS copiedFromId_38, p0_.statusId AS statusId_39, p0_.organizationDepartmentId AS organizationDepartmentId_40, p0_.organizationId AS organizationId_41, p0_.templateId AS templateId_42, p0_.userId AS userId_43, p0_.locationTypeId AS locationTypeId_44, p1_.locationId AS locationId_45, p1_.positionId AS positionId_46, l2_.cityId AS cityId_47, l2_.stateId AS stateId_48, l2_.countryId AS countryId_49, l2_.organizationId AS organizationId_50, l2_.userId AS userId_51 FROM Positions p0_ INNER JOIN Organizations o3_ ON p0_.organizationId = o3_.id LEFT JOIN DataPointOptions d4_ ON p0_.statusId = d4_.id INNER JOIN PositionLocations p1_ ON p0_.id = p1_.positionId AND (p1_.deletedAt IS NULL) INNER JOIN Locations l2_ ON p1_.locationId = l2_.id LEFT JOIN HiringTeamManagers h5_ ON p0_.id = h5_.positionId LEFT JOIN DataPointOptions d6_ ON p0_.locationTypeId = d6_.id WHERE o3_.id = ? AND p0_.parentId IS NULL AND p0_.isTemplate = ? AND (p0_.archivedAt IS NULL) AND (p0_.deletedAt IS NULL) AND p0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND (p1_.deletedAt IS NULL AND h5_.deletedAt IS NULL) AND p0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY p0_.id DESC, p0_.id DESC Parameters: [3 0 19 20 21 22 23 24 25 26 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 52 53 54 55 67 68 69 70 71 72 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 860 861 866 867 868 869 870 871 872 873 874 875 876 877 878 879 880 881 882 883 884 885 886 887 888 889 891 892 893 894 895 896 897 898 899 900 905 906 907 908 909 910 921 922 923 924 925 926 927 930 931 932 933 934 935 936 937 944 945 976 977 996 997 1000 1001 1006 1007 1008 1009 1010 1011 1012 1013 1014 1015 1024 1025 1026 1027 1028 1029 1030 1031 1036 1037 1038 1039 1040 1041 1052 1053 1058 1059 1062 1067 1068 1071 1072 1073 1074 1075 1076 1077 1078 1079 1963 1964 1965 1966 2014 2015 2016 2017 2018 2019 2022 2023 2024 2025 2026 2027 2026 2024 2022 2018 2016 2014 1965 1963 1078 1075 1073 1071 1067 1052 1040 1038 1036 1030 1028 1026 1024 1014 1012 1010 1008 1006 1000 996 976 936 934 930 926 924 909 907 905 899 897 895 893 888 886 884 882 880 878 876 873 871] View formatted query View runnable query Explain query SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.json AS json_2, p0_.startDate AS startDate_3, p0_.endDate AS endDate_4, p0_.statusUpdatedAt AS statusUpdatedAt_5, p0_.organizationDepartmentUpdatedAt AS organizationDepartmentUpdatedAt_6, p0_.isFullServiceHiring AS isFullServiceHiring_7, p0_.fillBy AS fillBy_8, p0_.numberOfHires AS numberOfHires_9, p0_.isTemplate AS isTemplate_10, p0_.isGeneralApplication AS isGeneralApplication_11, p0_.isImported AS isImported_12, p0_.archivedAt AS archivedAt_13, p0_.createdAt AS createdAt_14, p0_.updatedAt AS updatedAt_15, p0_.deletedAt AS deletedAt_16, p0_.locationTypeUpdatedAt AS locationTypeUpdatedAt_17, p1_.id AS id_18, p1_.isPrimary AS isPrimary_19, p1_.createdAt AS createdAt_20, p1_.updatedAt AS updatedAt_21, p1_.deletedAt AS deletedAt_22, l2_.id AS id_23, l2_.name AS name_24, l2_.description AS description_25, l2_.street1 AS street1_26, l2_.street2 AS street2_27, l2_.street3 AS street3_28, l2_.masterLocationId AS masterLocationId_29, l2_.postalCode AS postalCode_30, l2_.createdAt AS createdAt_31, l2_.updatedAt AS updatedAt_32, l2_.archivedAt AS archivedAt_33, l2_.deletedAt AS deletedAt_34, l2_.latitude AS latitude_35, l2_.longitude AS longitude_36, p0_.parentId AS parentId_37, p0_.copiedFromId AS copiedFromId_38, p0_.statusId AS statusId_39, p0_.organizationDepartmentId AS organizationDepartmentId_40, p0_.organizationId AS organizationId_41, p0_.templateId AS templateId_42, p0_.userId AS userId_43, p0_.locationTypeId AS locationTypeId_44, p1_.locationId AS locationId_45, p1_.positionId AS positionId_46, l2_.cityId AS cityId_47, l2_.stateId AS stateId_48, l2_.countryId AS countryId_49, l2_.organizationId AS organizationId_50, l2_.userId AS userId_51 FROM Positions p0_ INNER JOIN Organizations o3_ ON p0_.organizationId = o3_.id LEFT JOIN DataPointOptions d4_ ON p0_.statusId = d4_.id INNER JOIN PositionLocations p1_ ON p0_.id = p1_.positionId AND (p1_.deletedAt IS NULL) INNER JOIN Locations l2_ ON p1_.locationId = l2_.id LEFT JOIN HiringTeamManagers h5_ ON p0_.id = h5_.positionId LEFT JOIN DataPointOptions d6_ ON p0_.locationTypeId = d6_.id WHERE o3_.id = ? AND p0_.parentId IS NULL AND p0_.isTemplate = ? AND (p0_.archivedAt IS NULL) AND (p0_.deletedAt IS NULL) AND p0_.id IN ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? ) AND ( p1_.deletedAt IS NULL AND h5_.deletedAt IS NULL ) AND p0_.id IN ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? ) ORDER BY p0_.id DESC, p0_.id DESC SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.json AS json_2, p0_.startDate AS startDate_3, p0_.endDate AS endDate_4, p0_.statusUpdatedAt AS statusUpdatedAt_5, p0_.organizationDepartmentUpdatedAt AS organizationDepartmentUpdatedAt_6, p0_.isFullServiceHiring AS isFullServiceHiring_7, p0_.fillBy AS fillBy_8, p0_.numberOfHires AS numberOfHires_9, p0_.isTemplate AS isTemplate_10, p0_.isGeneralApplication AS isGeneralApplication_11, p0_.isImported AS isImported_12, p0_.archivedAt AS archivedAt_13, p0_.createdAt AS createdAt_14, p0_.updatedAt AS updatedAt_15, p0_.deletedAt AS deletedAt_16, p0_.locationTypeUpdatedAt AS locationTypeUpdatedAt_17, p1_.id AS id_18, p1_.isPrimary AS isPrimary_19, p1_.createdAt AS createdAt_20, p1_.updatedAt AS updatedAt_21, p1_.deletedAt AS deletedAt_22, l2_.id AS id_23, l2_.name AS name_24, l2_.description AS description_25, l2_.street1 AS street1_26, l2_.street2 AS street2_27, l2_.street3 AS street3_28, l2_.masterLocationId AS masterLocationId_29, l2_.postalCode AS postalCode_30, l2_.createdAt AS createdAt_31, l2_.updatedAt AS updatedAt_32, l2_.archivedAt AS archivedAt_33, l2_.deletedAt AS deletedAt_34, l2_.latitude AS latitude_35, l2_.longitude AS longitude_36, p0_.parentId AS parentId_37, p0_.copiedFromId AS copiedFromId_38, p0_.statusId AS statusId_39, p0_.organizationDepartmentId AS organizationDepartmentId_40, p0_.organizationId AS organizationId_41, p0_.templateId AS templateId_42, p0_.userId AS userId_43, p0_.locationTypeId AS locationTypeId_44, p1_.locationId AS locationId_45, p1_.positionId AS positionId_46, l2_.cityId AS cityId_47, l2_.stateId AS stateId_48, l2_.countryId AS countryId_49, l2_.organizationId AS organizationId_50, l2_.userId AS userId_51 FROM Positions p0_ INNER JOIN Organizations o3_ ON p0_.organizationId = o3_.id LEFT JOIN DataPointOptions d4_ ON p0_.statusId = d4_.id INNER JOIN PositionLocations p1_ ON p0_.id = p1_.positionId AND (p1_.deletedAt IS NULL) INNER JOIN Locations l2_ ON p1_.locationId = l2_.id LEFT JOIN HiringTeamManagers h5_ ON p0_.id = h5_.positionId LEFT JOIN DataPointOptions d6_ ON p0_.locationTypeId = d6_.id WHERE o3_.id = 3 AND p0_.parentId IS NULL AND p0_.isTemplate = 0 AND (p0_.archivedAt IS NULL) AND (p0_.deletedAt IS NULL) AND p0_.id IN (19, 20, 21, 22, 23, 24, 25, 26, 29, 30, 31, 32, 33, 34, 35, 36, 37, 38, 39, 40, 41, 42, 43, 44, 45, 46, 47, 48, 52, 53, 54, 55, 67, 68, 69, 70, 71, 72, 75, 76, 77, 78, 79, 80, 81, 82, 83, 84, 85, 86, 87, 88, 89, 90, 91, 92, 93, 94, 95, 96, 97, 98, 99, 860, 861, 866, 867, 868, 869, 870, 871, 872, 873, 874, 875, 876, 877, 878, 879, 880, 881, 882, 883, 884, 885, 886, 887, 888, 889, 891, 892, 893, 894, 895, 896, 897, 898, 899, 900, 905, 906, 907, 908, 909, 910, 921, 922, 923, 924, 925, 926, 927, 930, 931, 932, 933, 934, 935, 936, 937, 944, 945, 976, 977, 996, 997, 1000, 1001, 1006, 1007, 1008, 1009, 1010, 1011, 1012, 1013, 1014, 1015, 1024, 1025, 1026, 1027, 1028, 1029, 1030, 1031, 1036, 1037, 1038, 1039, 1040, 1041, 1052, 1053, 1058, 1059, 1062, 1067, 1068, 1071, 1072, 1073, 1074, 1075, 1076, 1077, 1078, 1079, 1963, 1964, 1965, 1966, 2014, 2015, 2016, 2017, 2018, 2019, 2022, 2023, 2024, 2025, 2026, 2027) AND (p1_.deletedAt IS NULL AND h5_.deletedAt IS NULL) AND p0_.id IN (2026, 2024, 2022, 2018, 2016, 2014, 1965, 1963, 1078, 1075, 1073, 1071, 1067, 1052, 1040, 1038, 1036, 1030, 1028, 1026, 1024, 1014, 1012, 1010, 1008, 1006, 1000, 996, 976, 936, 934, 930, 926, 924, 909, 907, 905, 899, 897, 895, 893, 888, 886, 884, 882, 880, 878, 876, 873, 871) ORDER BY p0_.id DESC, p0_.id DESC;
1.18 ms (5.11%)	3	SELECT t0.id AS id_1, t0.clientRegistrationPolicy AS clientRegistrationPolicy_2, t0.identifier AS identifier_3, t0.label AS label_4, t0.description AS description_5, t0.logoUrl AS logoUrl_6, t0.endpoint AS endpoint_7, t0.credentials AS credentials_8, t0.createdAt AS createdAt_9, t0.updatedAt AS updatedAt_10, t0.deletedAt AS deletedAt_11, t12.id AS id_13, t12.status AS status_14, t12.tagline AS tagline_15, t12.overview AS overview_16, t12.logoUrl AS logoUrl_17, t12.heroMediaUrl AS heroMediaUrl_18, t12.videoUrl AS videoUrl_19, t12.links AS links_20, t12.requirementsText AS requirementsText_21, t12.connectsToLabel AS connectsToLabel_22, t12.subscriptionNote AS subscriptionNote_23, t12.accessType AS accessType_24, t12.languages AS languages_25, t12.featured AS featured_26, t12.displayOrder AS displayOrder_27, t12.deprecated AS deprecated_28, t12.createdAt AS createdAt_29, t12.updatedAt AS updatedAt_30, t12.deletedAt AS deletedAt_31, t12.providerId AS providerId_32, t12.publisherId AS publisherId_33 FROM Providers t0 LEFT JOIN ProviderListings t12 ON t12.providerId = t0.id AND ((t12.deletedAt IS NULL)) WHERE t0.identifier = ? AND ((t0.deletedAt IS NULL)) LIMIT 1 Parameters: [`"ORGANIZATION_SETTINGS"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.clientRegistrationPolicy AS clientRegistrationPolicy_2, t0.identifier AS identifier_3, t0.label AS label_4, t0.description AS description_5, t0.logoUrl AS logoUrl_6, t0.endpoint AS endpoint_7, t0.credentials AS credentials_8, t0.createdAt AS createdAt_9, t0.updatedAt AS updatedAt_10, t0.deletedAt AS deletedAt_11, t12.id AS id_13, t12.status AS status_14, t12.tagline AS tagline_15, t12.overview AS overview_16, t12.logoUrl AS logoUrl_17, t12.heroMediaUrl AS heroMediaUrl_18, t12.videoUrl AS videoUrl_19, t12.links AS links_20, t12.requirementsText AS requirementsText_21, t12.connectsToLabel AS connectsToLabel_22, t12.subscriptionNote AS subscriptionNote_23, t12.accessType AS accessType_24, t12.languages AS languages_25, t12.featured AS featured_26, t12.displayOrder AS displayOrder_27, t12.deprecated AS deprecated_28, t12.createdAt AS createdAt_29, t12.updatedAt AS updatedAt_30, t12.deletedAt AS deletedAt_31, t12.providerId AS providerId_32, t12.publisherId AS publisherId_33 FROM Providers t0 LEFT JOIN ProviderListings t12 ON t12.providerId = t0.id AND ( (t12.deletedAt IS NULL) ) WHERE t0.identifier = ? AND ( (t0.deletedAt IS NULL) ) LIMIT 1 SELECT t0.id AS id_1, t0.clientRegistrationPolicy AS clientRegistrationPolicy_2, t0.identifier AS identifier_3, t0.label AS label_4, t0.description AS description_5, t0.logoUrl AS logoUrl_6, t0.endpoint AS endpoint_7, t0.credentials AS credentials_8, t0.createdAt AS createdAt_9, t0.updatedAt AS updatedAt_10, t0.deletedAt AS deletedAt_11, t12.id AS id_13, t12.status AS status_14, t12.tagline AS tagline_15, t12.overview AS overview_16, t12.logoUrl AS logoUrl_17, t12.heroMediaUrl AS heroMediaUrl_18, t12.videoUrl AS videoUrl_19, t12.links AS links_20, t12.requirementsText AS requirementsText_21, t12.connectsToLabel AS connectsToLabel_22, t12.subscriptionNote AS subscriptionNote_23, t12.accessType AS accessType_24, t12.languages AS languages_25, t12.featured AS featured_26, t12.displayOrder AS displayOrder_27, t12.deprecated AS deprecated_28, t12.createdAt AS createdAt_29, t12.updatedAt AS updatedAt_30, t12.deletedAt AS deletedAt_31, t12.providerId AS providerId_32, t12.publisherId AS publisherId_33 FROM Providers t0 LEFT JOIN ProviderListings t12 ON t12.providerId = t0.id AND ((t12.deletedAt IS NULL)) WHERE t0.identifier = 'ORGANIZATION_SETTINGS' AND ((t0.deletedAt IS NULL)) LIMIT 1;
0.94 ms (4.05%)	1	SELECT COUNT(a0_.id) AS sclr_0, p1_.id AS id_1 FROM Applications a0_ INNER JOIN Positions p1_ ON a0_.positionId = p1_.id AND (p1_.deletedAt IS NULL) WHERE (a0_.positionId IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND a0_.submittedAt IS NOT NULL AND (a0_.templateStageId IS NULL OR a0_.templateStageId = ?)) AND (a0_.deletedAt IS NULL) GROUP BY p1_.id Parameters: [`2026 2024 2022 2018 2016 2014 1965 1963 1078 1075 1073 1071 1067 1052 1040 1038 1036 1030 1028 1026 1024 1014 1012 1010 1008 1006 1000 996 976 936 934 930 926 924 909 907 905 899 897 895 893 888 886 884 882 880 878 876 873 871 283`] View formatted query View runnable query Explain query SELECT COUNT(a0_.id) AS sclr_0, p1_.id AS id_1 FROM Applications a0_ INNER JOIN Positions p1_ ON a0_.positionId = p1_.id AND (p1_.deletedAt IS NULL) WHERE ( a0_.positionId IN ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? ) AND a0_.submittedAt IS NOT NULL AND ( a0_.templateStageId IS NULL OR a0_.templateStageId = ? ) ) AND (a0_.deletedAt IS NULL) GROUP BY p1_.id SELECT COUNT(a0_.id) AS sclr_0, p1_.id AS id_1 FROM Applications a0_ INNER JOIN Positions p1_ ON a0_.positionId = p1_.id AND (p1_.deletedAt IS NULL) WHERE (a0_.positionId IN (2026, 2024, 2022, 2018, 2016, 2014, 1965, 1963, 1078, 1075, 1073, 1071, 1067, 1052, 1040, 1038, 1036, 1030, 1028, 1026, 1024, 1014, 1012, 1010, 1008, 1006, 1000, 996, 976, 936, 934, 930, 926, 924, 909, 907, 905, 899, 897, 895, 893, 888, 886, 884, 882, 880, 878, 876, 873, 871) AND a0_.submittedAt IS NOT NULL AND (a0_.templateStageId IS NULL OR a0_.templateStageId = 283)) AND (a0_.deletedAt IS NULL) GROUP BY p1_.id;
0.87 ms (3.78%)	1	SELECT COUNT(a0_.id) AS sclr_0, p1_.id AS id_1 FROM Applications a0_ INNER JOIN Positions p1_ ON a0_.positionId = p1_.id AND (p1_.deletedAt IS NULL) WHERE (a0_.positionId IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND a0_.isDisqualified = 0 AND a0_.submittedAt IS NOT NULL AND (a0_.templateStageId IS NULL OR a0_.templateStageId = ?)) AND (a0_.deletedAt IS NULL) GROUP BY p1_.id Parameters: [`2026 2024 2022 2018 2016 2014 1965 1963 1078 1075 1073 1071 1067 1052 1040 1038 1036 1030 1028 1026 1024 1014 1012 1010 1008 1006 1000 996 976 936 934 930 926 924 909 907 905 899 897 895 893 888 886 884 882 880 878 876 873 871 283`] View formatted query View runnable query Explain query SELECT COUNT(a0_.id) AS sclr_0, p1_.id AS id_1 FROM Applications a0_ INNER JOIN Positions p1_ ON a0_.positionId = p1_.id AND (p1_.deletedAt IS NULL) WHERE ( a0_.positionId IN ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? ) AND a0_.isDisqualified = 0 AND a0_.submittedAt IS NOT NULL AND ( a0_.templateStageId IS NULL OR a0_.templateStageId = ? ) ) AND (a0_.deletedAt IS NULL) GROUP BY p1_.id SELECT COUNT(a0_.id) AS sclr_0, p1_.id AS id_1 FROM Applications a0_ INNER JOIN Positions p1_ ON a0_.positionId = p1_.id AND (p1_.deletedAt IS NULL) WHERE (a0_.positionId IN (2026, 2024, 2022, 2018, 2016, 2014, 1965, 1963, 1078, 1075, 1073, 1071, 1067, 1052, 1040, 1038, 1036, 1030, 1028, 1026, 1024, 1014, 1012, 1010, 1008, 1006, 1000, 996, 976, 936, 934, 930, 926, 924, 909, 907, 905, 899, 897, 895, 893, 888, 886, 884, 882, 880, 878, 876, 873, 871) AND a0_.isDisqualified = 0 AND a0_.submittedAt IS NOT NULL AND (a0_.templateStageId IS NULL OR a0_.templateStageId = 283)) AND (a0_.deletedAt IS NULL) GROUP BY p1_.id;
0.86 ms (3.73%)	8	SELECT t0.id AS id_1, t0.label AS label_2, t0.value AS value_3, t0.description AS description_4, t0.identifier AS identifier_5, t0.displayOrder AS displayOrder_6, t0.isLocked AS isLocked_7, t0.archivedAt AS archivedAt_8, t0.createdAt AS createdAt_9, t0.updatedAt AS updatedAt_10, t0.deletedAt AS deletedAt_11, t0.dataPointId AS dataPointId_12, t0.parentId AS parentId_13, t0.organizationId AS organizationId_14 FROM DataPointOptions t0 WHERE t0.id = ? AND ((t0.deletedAt IS NULL)) Parameters: [`5`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.label AS label_2, t0.value AS value_3, t0.description AS description_4, t0.identifier AS identifier_5, t0.displayOrder AS displayOrder_6, t0.isLocked AS isLocked_7, t0.archivedAt AS archivedAt_8, t0.createdAt AS createdAt_9, t0.updatedAt AS updatedAt_10, t0.deletedAt AS deletedAt_11, t0.dataPointId AS dataPointId_12, t0.parentId AS parentId_13, t0.organizationId AS organizationId_14 FROM DataPointOptions t0 WHERE t0.id = ? AND ( (t0.deletedAt IS NULL) ) SELECT t0.id AS id_1, t0.label AS label_2, t0.value AS value_3, t0.description AS description_4, t0.identifier AS identifier_5, t0.displayOrder AS displayOrder_6, t0.isLocked AS isLocked_7, t0.archivedAt AS archivedAt_8, t0.createdAt AS createdAt_9, t0.updatedAt AS updatedAt_10, t0.deletedAt AS deletedAt_11, t0.dataPointId AS dataPointId_12, t0.parentId AS parentId_13, t0.organizationId AS organizationId_14 FROM DataPointOptions t0 WHERE t0.id = 5 AND ((t0.deletedAt IS NULL));
0.77 ms (3.32%)	1	SELECT t0.id AS id_1, t0.locked AS locked_2, t0.createdAt AS createdAt_3, t0.updatedAt AS updatedAt_4, t0.deletedAt AS deletedAt_5, t0.permissionId AS permissionId_6, t7.id AS id_8, t7.label AS label_9, t7.description AS description_10, t7.identifier AS identifier_11, t7.visibility AS visibility_12, t7.displayOrder AS displayOrder_13, t7.createdAt AS createdAt_14, t7.updatedAt AS updatedAt_15, t7.deletedAt AS deletedAt_16, t7.subSystemId AS subSystemId_17, t7.permissionTypeId AS permissionTypeId_18, t0.roleId AS roleId_19 FROM RolePermissions t0 LEFT JOIN Permissions t7 ON t0.permissionId = t7.id AND ((t7.deletedAt IS NULL)) WHERE t0.roleId = ? AND ((t0.deletedAt IS NULL)) Parameters: [`2`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.locked AS locked_2, t0.createdAt AS createdAt_3, t0.updatedAt AS updatedAt_4, t0.deletedAt AS deletedAt_5, t0.permissionId AS permissionId_6, t7.id AS id_8, t7.label AS label_9, t7.description AS description_10, t7.identifier AS identifier_11, t7.visibility AS visibility_12, t7.displayOrder AS displayOrder_13, t7.createdAt AS createdAt_14, t7.updatedAt AS updatedAt_15, t7.deletedAt AS deletedAt_16, t7.subSystemId AS subSystemId_17, t7.permissionTypeId AS permissionTypeId_18, t0.roleId AS roleId_19 FROM RolePermissions t0 LEFT JOIN Permissions t7 ON t0.permissionId = t7.id AND ( (t7.deletedAt IS NULL) ) WHERE t0.roleId = ? AND ( (t0.deletedAt IS NULL) ) SELECT t0.id AS id_1, t0.locked AS locked_2, t0.createdAt AS createdAt_3, t0.updatedAt AS updatedAt_4, t0.deletedAt AS deletedAt_5, t0.permissionId AS permissionId_6, t7.id AS id_8, t7.label AS label_9, t7.description AS description_10, t7.identifier AS identifier_11, t7.visibility AS visibility_12, t7.displayOrder AS displayOrder_13, t7.createdAt AS createdAt_14, t7.updatedAt AS updatedAt_15, t7.deletedAt AS deletedAt_16, t7.subSystemId AS subSystemId_17, t7.permissionTypeId AS permissionTypeId_18, t0.roleId AS roleId_19 FROM RolePermissions t0 LEFT JOIN Permissions t7 ON t0.permissionId = t7.id AND ((t7.deletedAt IS NULL)) WHERE t0.roleId = 2 AND ((t0.deletedAt IS NULL));
0.55 ms (2.38%)	1	SELECT DISTINCT `Positions`.`id` FROM `Positions` WHERE `Positions`.`organizationId` = ? AND `Positions`.`deletedAt` IS NULL Parameters: [`3`] View formatted query View runnable query Explain query SELECT DISTINCT `Positions`.`id` FROM `Positions` WHERE `Positions`.`organizationId` = ? AND `Positions`.`deletedAt` IS NULL SELECT DISTINCT `Positions`.`id` FROM `Positions` WHERE `Positions`.`organizationId` = 3 AND `Positions`.`deletedAt` IS NULL ;
0.47 ms (2.04%)	1	SELECT u0_.id AS id_0, u0_.username AS username_1, u0_.password AS password_2, u0_.confirmation_token AS confirmation_token_3, u0_.password_requested_at AS password_requested_at_4, u0_.authIP AS authIP_5, u0_.enabled AS enabled_6, u0_.isLocked AS isLocked_7, u0_.isAuthy AS isAuthy_8, u0_.lastLogin AS lastLogin_9, u0_.createdAt AS createdAt_10, u0_.updatedAt AS updatedAt_11, u0_.deletedAt AS deletedAt_12, u0_.jobNotificationName AS jobNotificationName_13, u0_.jobNotificationFrequency AS jobNotificationFrequency_14, u0_.jobNotificationLastSentAt AS jobNotificationLastSentAt_15, u0_.jobNotificationSetAt AS jobNotificationSetAt_16, u0_.unsubscribeToken AS unsubscribeToken_17, u0_.jobNotificationChannel AS jobNotificationChannel_18, u0_.organizationId AS organizationId_19 FROM Users u0_ INNER JOIN OrganizationUsers o1_ ON u0_.id = o1_.userId AND (o1_.deletedAt IS NULL) WHERE (u0_.id = ?) AND (u0_.deletedAt IS NULL) LIMIT 1 Parameters: [`"657"`] View formatted query View runnable query Explain query SELECT u0_.id AS id_0, u0_.username AS username_1, u0_.password AS password_2, u0_.confirmation_token AS confirmation_token_3, u0_.password_requested_at AS password_requested_at_4, u0_.authIP AS authIP_5, u0_.enabled AS enabled_6, u0_.isLocked AS isLocked_7, u0_.isAuthy AS isAuthy_8, u0_.lastLogin AS lastLogin_9, u0_.createdAt AS createdAt_10, u0_.updatedAt AS updatedAt_11, u0_.deletedAt AS deletedAt_12, u0_.jobNotificationName AS jobNotificationName_13, u0_.jobNotificationFrequency AS jobNotificationFrequency_14, u0_.jobNotificationLastSentAt AS jobNotificationLastSentAt_15, u0_.jobNotificationSetAt AS jobNotificationSetAt_16, u0_.unsubscribeToken AS unsubscribeToken_17, u0_.jobNotificationChannel AS jobNotificationChannel_18, u0_.organizationId AS organizationId_19 FROM Users u0_ INNER JOIN OrganizationUsers o1_ ON u0_.id = o1_.userId AND (o1_.deletedAt IS NULL) WHERE (u0_.id = ?) AND (u0_.deletedAt IS NULL) LIMIT 1 SELECT u0_.id AS id_0, u0_.username AS username_1, u0_.password AS password_2, u0_.confirmation_token AS confirmation_token_3, u0_.password_requested_at AS password_requested_at_4, u0_.authIP AS authIP_5, u0_.enabled AS enabled_6, u0_.isLocked AS isLocked_7, u0_.isAuthy AS isAuthy_8, u0_.lastLogin AS lastLogin_9, u0_.createdAt AS createdAt_10, u0_.updatedAt AS updatedAt_11, u0_.deletedAt AS deletedAt_12, u0_.jobNotificationName AS jobNotificationName_13, u0_.jobNotificationFrequency AS jobNotificationFrequency_14, u0_.jobNotificationLastSentAt AS jobNotificationLastSentAt_15, u0_.jobNotificationSetAt AS jobNotificationSetAt_16, u0_.unsubscribeToken AS unsubscribeToken_17, u0_.jobNotificationChannel AS jobNotificationChannel_18, u0_.organizationId AS organizationId_19 FROM Users u0_ INNER JOIN OrganizationUsers o1_ ON u0_.id = o1_.userId AND (o1_.deletedAt IS NULL) WHERE (u0_.id = '657') AND (u0_.deletedAt IS NULL) LIMIT 1;
0.47 ms (2.03%)	1	SELECT t0.id AS id_1, t0.token AS token_2, t0.jti AS jti_3, t0.usedAt AS usedAt_4, t0.createdAt AS createdAt_5, t0.updatedAt AS updatedAt_6, t0.deletedAt AS deletedAt_7, t0.userId AS userId_8 FROM SSOTokens t0 WHERE t0.token = ? AND ((t0.deletedAt IS NULL)) LIMIT 1 Parameters: ["eyJ0eXAiOiJKV1QiLCJhbGciOiJSUzI1NiJ9.eyJpYXQiOjE3OTA2MjAwNTIsImV4cCI6MTc5MDcwNjQ1Miwicm9sZXMiOlsiUk9MRV9BRE1JTklTVFJBVE9SIl0sImlkIjo2NTcsIm9yZ2FuaXphdGlvbklkIjozLCJ0aW1lWm9uZSI6bnVsbH0.GRZkero3yfy1xUgWfi2u6ggNCYDYccBqI3V7SbmsgjoaIAlHbpRHAcYxZnD2dbKYPAarFaFeqwUMXcek_124AiHIuTuYCSZ7ohlzphsxTkFIdwS8UEv_SKnI9r84EPanmFGhkhPHCpWeGvby3bCzp_KtwRF7WjHFKP8OyJST6S7eUfAg54BcYWNUAgs3CkcrHVaPzwIeHxCYgM8EHl4__m6tFf05ZRufYeVDA-GYd6igDbWwit9yt6VhoOxWT-GuS-3h6ZPwaCF86MF16Bn6lwHROswL3F6JtvUO08Csa-vm8s7yLhhPxERdtHh1yCAATbuk5mcPGrIUIoL2lf7yNT37ZoZm_bJMeHxA43IySTW7k3teJ52q6j3MuDhc7tmtIZ3EHHY81wgwX8W5B065Hd_oGIKy6HJFozqZ5AqLQs1WAwpN6mF22G9p0gkkCuOpFdwvZyENdFKX7mV5rUmnf6IEnv_umL-1Bl0-Lk8eAg2F_wRgb-axd5dBtiPwuPOGEueDsYRD5a-bqRTtjPhakUH6_r-up04xtM1qQw0202AZRv3fYu3tqIOrIl7N0OQP-WVCm7JqvSu2RPt3-aX2QPps7B-PcOYdfmU8442EUeLFIREgJE1fU4aRKIO_um_nmsS4BiNTuxO33x3liETrdRS4iAogWLjQ6nt7tYKr-z8"] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.token AS token_2, t0.jti AS jti_3, t0.usedAt AS usedAt_4, t0.createdAt AS createdAt_5, t0.updatedAt AS updatedAt_6, t0.deletedAt AS deletedAt_7, t0.userId AS userId_8 FROM SSOTokens t0 WHERE t0.token = ? AND ( (t0.deletedAt IS NULL) ) LIMIT 1 SELECT t0.id AS id_1, t0.token AS token_2, t0.jti AS jti_3, t0.usedAt AS usedAt_4, t0.createdAt AS createdAt_5, t0.updatedAt AS updatedAt_6, t0.deletedAt AS deletedAt_7, t0.userId AS userId_8 FROM SSOTokens t0 WHERE t0.token = 'eyJ0eXAiOiJKV1QiLCJhbGciOiJSUzI1NiJ9.eyJpYXQiOjE3OTA2MjAwNTIsImV4cCI6MTc5MDcwNjQ1Miwicm9sZXMiOlsiUk9MRV9BRE1JTklTVFJBVE9SIl0sImlkIjo2NTcsIm9yZ2FuaXphdGlvbklkIjozLCJ0aW1lWm9uZSI6bnVsbH0.GRZkero3yfy1xUgWfi2u6ggNCYDYccBqI3V7SbmsgjoaIAlHbpRHAcYxZnD2dbKYPAarFaFeqwUMXcek_124AiHIuTuYCSZ7ohlzphsxTkFIdwS8UEv_SKnI9r84EPanmFGhkhPHCpWeGvby3bCzp_KtwRF7WjHFKP8OyJST6S7eUfAg54BcYWNUAgs3CkcrHVaPzwIeHxCYgM8EHl4__m6tFf05ZRufYeVDA-GYd6igDbWwit9yt6VhoOxWT-GuS-3h6ZPwaCF86MF16Bn6lwHROswL3F6JtvUO08Csa-vm8s7yLhhPxERdtHh1yCAATbuk5mcPGrIUIoL2lf7yNT37ZoZm_bJMeHxA43IySTW7k3teJ52q6j3MuDhc7tmtIZ3EHHY81wgwX8W5B065Hd_oGIKy6HJFozqZ5AqLQs1WAwpN6mF22G9p0gkkCuOpFdwvZyENdFKX7mV5rUmnf6IEnv_umL-1Bl0-Lk8eAg2F_wRgb-axd5dBtiPwuPOGEueDsYRD5a-bqRTtjPhakUH6_r-up04xtM1qQw0202AZRv3fYu3tqIOrIl7N0OQP-WVCm7JqvSu2RPt3-aX2QPps7B-PcOYdfmU8442EUeLFIREgJE1fU4aRKIO_um_nmsS4BiNTuxO33x3liETrdRS4iAogWLjQ6nt7tYKr-z8' AND ((t0.deletedAt IS NULL)) LIMIT 1;
0.47 ms (2.02%)	1	SELECT positionNote.`positionId` AS positionId FROM `PositionNotes` positionNote JOIN `Positions` position ON position.`id` = positionNote.`positionId` WHERE positionNote.`deletedAt` IS NULL AND positionNote.`positionId` IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND position.`organizationId` = ? GROUP BY positionId LIMIT 30 Parameters: [`2026 2024 2022 2018 2016 2014 1965 1963 1078 1075 1073 1071 1067 1052 1040 1038 1036 1030 1028 1026 1024 1014 1012 1010 1008 1006 1000 996 976 936 934 930 926 924 909 907 905 899 897 895 893 888 886 884 882 880 878 876 873 871 3`] View formatted query View runnable query Explain query SELECT positionNote.`positionId` AS positionId FROM `PositionNotes` positionNote JOIN `Positions` position ON position.`id` = positionNote.`positionId` WHERE positionNote.`deletedAt` IS NULL AND positionNote.`positionId` IN ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? ) AND position.`organizationId` = ? GROUP BY positionId LIMIT 30 SELECT positionNote.`positionId` AS positionId FROM `PositionNotes` positionNote JOIN `Positions` position ON position.`id` = positionNote.`positionId` WHERE positionNote.`deletedAt` IS NULL AND positionNote.`positionId` IN (2026, 2024, 2022, 2018, 2016, 2014, 1965, 1963, 1078, 1075, 1073, 1071, 1067, 1052, 1040, 1038, 1036, 1030, 1028, 1026, 1024, 1014, 1012, 1010, 1008, 1006, 1000, 996, 976, 936, 934, 930, 926, 924, 909, 907, 905, 899, 897, 895, 893, 888, 886, 884, 882, 880, 878, 876, 873, 871) AND position.`organizationId` = 3 GROUP BY positionId LIMIT 30;
0.46 ms (2.00%)	2	SELECT t0.id AS id_1, t0.username AS username_2, t0.password AS password_3, t0.confirmation_token AS confirmation_token_4, t0.password_requested_at AS password_requested_at_5, t0.authIP AS authIP_6, t0.enabled AS enabled_7, t0.isLocked AS isLocked_8, t0.isAuthy AS isAuthy_9, t0.lastLogin AS lastLogin_10, t0.createdAt AS createdAt_11, t0.updatedAt AS updatedAt_12, t0.deletedAt AS deletedAt_13, t0.jobNotificationName AS jobNotificationName_14, t0.jobNotificationFrequency AS jobNotificationFrequency_15, t0.jobNotificationLastSentAt AS jobNotificationLastSentAt_16, t0.jobNotificationSetAt AS jobNotificationSetAt_17, t0.unsubscribeToken AS unsubscribeToken_18, t0.jobNotificationChannel AS jobNotificationChannel_19, t0.organizationId AS organizationId_20 FROM Users t0 WHERE t0.id = ? Parameters: [`657`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.username AS username_2, t0.password AS password_3, t0.confirmation_token AS confirmation_token_4, t0.password_requested_at AS password_requested_at_5, t0.authIP AS authIP_6, t0.enabled AS enabled_7, t0.isLocked AS isLocked_8, t0.isAuthy AS isAuthy_9, t0.lastLogin AS lastLogin_10, t0.createdAt AS createdAt_11, t0.updatedAt AS updatedAt_12, t0.deletedAt AS deletedAt_13, t0.jobNotificationName AS jobNotificationName_14, t0.jobNotificationFrequency AS jobNotificationFrequency_15, t0.jobNotificationLastSentAt AS jobNotificationLastSentAt_16, t0.jobNotificationSetAt AS jobNotificationSetAt_17, t0.unsubscribeToken AS unsubscribeToken_18, t0.jobNotificationChannel AS jobNotificationChannel_19, t0.organizationId AS organizationId_20 FROM Users t0 WHERE t0.id = ? SELECT t0.id AS id_1, t0.username AS username_2, t0.password AS password_3, t0.confirmation_token AS confirmation_token_4, t0.password_requested_at AS password_requested_at_5, t0.authIP AS authIP_6, t0.enabled AS enabled_7, t0.isLocked AS isLocked_8, t0.isAuthy AS isAuthy_9, t0.lastLogin AS lastLogin_10, t0.createdAt AS createdAt_11, t0.updatedAt AS updatedAt_12, t0.deletedAt AS deletedAt_13, t0.jobNotificationName AS jobNotificationName_14, t0.jobNotificationFrequency AS jobNotificationFrequency_15, t0.jobNotificationLastSentAt AS jobNotificationLastSentAt_16, t0.jobNotificationSetAt AS jobNotificationSetAt_17, t0.unsubscribeToken AS unsubscribeToken_18, t0.jobNotificationChannel AS jobNotificationChannel_19, t0.organizationId AS organizationId_20 FROM Users t0 WHERE t0.id = 657;
0.44 ms (1.92%)	1	SELECT t0.id AS id_1, t0.isDefault AS isDefault_2, t0.isExpired AS isExpired_3, t0.archivedAt AS archivedAt_4, t0.createdAt AS createdAt_5, t0.updatedAt AS updatedAt_6, t0.deletedAt AS deletedAt_7, t0.userId AS userId_8, t0.organizationId AS organizationId_9 FROM OrganizationUsers t0 WHERE t0.userId = ? AND ((t0.deletedAt IS NULL)) Parameters: [`657`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.isDefault AS isDefault_2, t0.isExpired AS isExpired_3, t0.archivedAt AS archivedAt_4, t0.createdAt AS createdAt_5, t0.updatedAt AS updatedAt_6, t0.deletedAt AS deletedAt_7, t0.userId AS userId_8, t0.organizationId AS organizationId_9 FROM OrganizationUsers t0 WHERE t0.userId = ? AND ( (t0.deletedAt IS NULL) ) SELECT t0.id AS id_1, t0.isDefault AS isDefault_2, t0.isExpired AS isExpired_3, t0.archivedAt AS archivedAt_4, t0.createdAt AS createdAt_5, t0.updatedAt AS updatedAt_6, t0.deletedAt AS deletedAt_7, t0.userId AS userId_8, t0.organizationId AS organizationId_9 FROM OrganizationUsers t0 WHERE t0.userId = 657 AND ((t0.deletedAt IS NULL));
0.38 ms (1.63%)	2	SELECT t0.id AS id_1, t0.label AS label_2, t0.value AS value_3, t0.description AS description_4, t0.identifier AS identifier_5, t0.displayOrder AS displayOrder_6, t0.isLocked AS isLocked_7, t0.archivedAt AS archivedAt_8, t0.createdAt AS createdAt_9, t0.updatedAt AS updatedAt_10, t0.deletedAt AS deletedAt_11, t0.dataPointId AS dataPointId_12, t0.parentId AS parentId_13, t0.organizationId AS organizationId_14 FROM DataPointOptions t0 WHERE t0.identifier = ? LIMIT 1 Parameters: [`"ORGANIZATION_TAGS_ALL"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.label AS label_2, t0.value AS value_3, t0.description AS description_4, t0.identifier AS identifier_5, t0.displayOrder AS displayOrder_6, t0.isLocked AS isLocked_7, t0.archivedAt AS archivedAt_8, t0.createdAt AS createdAt_9, t0.updatedAt AS updatedAt_10, t0.deletedAt AS deletedAt_11, t0.dataPointId AS dataPointId_12, t0.parentId AS parentId_13, t0.organizationId AS organizationId_14 FROM DataPointOptions t0 WHERE t0.identifier = ? LIMIT 1 SELECT t0.id AS id_1, t0.label AS label_2, t0.value AS value_3, t0.description AS description_4, t0.identifier AS identifier_5, t0.displayOrder AS displayOrder_6, t0.isLocked AS isLocked_7, t0.archivedAt AS archivedAt_8, t0.createdAt AS createdAt_9, t0.updatedAt AS updatedAt_10, t0.deletedAt AS deletedAt_11, t0.dataPointId AS dataPointId_12, t0.parentId AS parentId_13, t0.organizationId AS organizationId_14 FROM DataPointOptions t0 WHERE t0.identifier = 'ORGANIZATION_TAGS_ALL' LIMIT 1;
0.36 ms (1.57%)	2	"COMMIT" Parameters: [] View formatted query View runnable query Explain query "COMMIT" "COMMIT";
0.31 ms (1.36%)	1	SELECT LocationScopes.id AS id0, LocationScopes.resourceId AS resourceId1, LocationScopes.createdAt AS createdAt2, LocationScopes.updatedAt AS updatedAt3, LocationScopes.deletedAt AS deletedAt4, LocationScopes.archivedAt AS archivedAt5, LocationScopes.locationId AS locationId6, LocationScopes.dataPointResourceId AS dataPointResourceId7, LocationScopes.userId AS userId8, LocationScopes.organizationId AS organizationId9 FROM `LocationScopes` JOIN `Locations` ON Locations.`id` = LocationScopes.`locationId` AND Locations.`deletedAt` IS NULL WHERE LocationScopes.`organizationId` = ? AND LocationScopes.`resourceId` = ? AND LocationScopes.`dataPointResourceId` = ? AND LocationScopes.`deletedAt` IS NULL Parameters: [`3 657 23`] View formatted query View runnable query Explain query SELECT LocationScopes.id AS id0, LocationScopes.resourceId AS resourceId1, LocationScopes.createdAt AS createdAt2, LocationScopes.updatedAt AS updatedAt3, LocationScopes.deletedAt AS deletedAt4, LocationScopes.archivedAt AS archivedAt5, LocationScopes.locationId AS locationId6, LocationScopes.dataPointResourceId AS dataPointResourceId7, LocationScopes.userId AS userId8, LocationScopes.organizationId AS organizationId9 FROM `LocationScopes` JOIN `Locations` ON Locations.`id` = LocationScopes.`locationId` AND Locations.`deletedAt` IS NULL WHERE LocationScopes.`organizationId` = ? AND LocationScopes.`resourceId` = ? AND LocationScopes.`dataPointResourceId` = ? AND LocationScopes.`deletedAt` IS NULL SELECT LocationScopes.id AS id0, LocationScopes.resourceId AS resourceId1, LocationScopes.createdAt AS createdAt2, LocationScopes.updatedAt AS updatedAt3, LocationScopes.deletedAt AS deletedAt4, LocationScopes.archivedAt AS archivedAt5, LocationScopes.locationId AS locationId6, LocationScopes.dataPointResourceId AS dataPointResourceId7, LocationScopes.userId AS userId8, LocationScopes.organizationId AS organizationId9 FROM `LocationScopes` JOIN `Locations` ON Locations.`id` = LocationScopes.`locationId` AND Locations.`deletedAt` IS NULL WHERE LocationScopes.`organizationId` = 3 AND LocationScopes.`resourceId` = 657 AND LocationScopes.`dataPointResourceId` = 23 AND LocationScopes.`deletedAt` IS NULL ;
0.30 ms (1.31%)	1	SELECT t0.id AS id_1, t0.label AS label_2, t0.identifier AS identifier_3, t0.sequence AS sequence_4, t0.locked AS locked_5, t0.visibility AS visibility_6, t0.createdAt AS createdAt_7, t0.updatedAt AS updatedAt_8, t0.deletedAt AS deletedAt_9, t0.organizationId AS organizationId_10, t0.masterRoleId AS masterRoleId_11 FROM Roles t0 WHERE t0.id = ? AND ((t0.deletedAt IS NULL)) Parameters: [`2`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.label AS label_2, t0.identifier AS identifier_3, t0.sequence AS sequence_4, t0.locked AS locked_5, t0.visibility AS visibility_6, t0.createdAt AS createdAt_7, t0.updatedAt AS updatedAt_8, t0.deletedAt AS deletedAt_9, t0.organizationId AS organizationId_10, t0.masterRoleId AS masterRoleId_11 FROM Roles t0 WHERE t0.id = ? AND ( (t0.deletedAt IS NULL) ) SELECT t0.id AS id_1, t0.label AS label_2, t0.identifier AS identifier_3, t0.sequence AS sequence_4, t0.locked AS locked_5, t0.visibility AS visibility_6, t0.createdAt AS createdAt_7, t0.updatedAt AS updatedAt_8, t0.deletedAt AS deletedAt_9, t0.organizationId AS organizationId_10, t0.masterRoleId AS masterRoleId_11 FROM Roles t0 WHERE t0.id = 2 AND ((t0.deletedAt IS NULL));
0.28 ms (1.23%)	2	SELECT t0.id AS id_1, t0.identifier AS identifier_2, t0.resource AS resource_3, t0.createdAt AS createdAt_4, t0.updatedAt AS updatedAt_5, t0.deletedAt AS deletedAt_6 FROM DataPointResources t0 WHERE t0.identifier = ? LIMIT 1 Parameters: [`"POSITION"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.identifier AS identifier_2, t0.resource AS resource_3, t0.createdAt AS createdAt_4, t0.updatedAt AS updatedAt_5, t0.deletedAt AS deletedAt_6 FROM DataPointResources t0 WHERE t0.identifier = ? LIMIT 1 SELECT t0.id AS id_1, t0.identifier AS identifier_2, t0.resource AS resource_3, t0.createdAt AS createdAt_4, t0.updatedAt AS updatedAt_5, t0.deletedAt AS deletedAt_6 FROM DataPointResources t0 WHERE t0.identifier = 'POSITION' LIMIT 1;
0.28 ms (1.21%)	1	SELECT r0_.id AS id_0, r0_.name AS name_1, r0_.description AS description_2, r0_.isVisible AS isVisible_3, r0_.isExportable AS isExportable_4, r0_.isSystemDefault AS isSystemDefault_5, r0_.routeUrl AS routeUrl_6, r0_.displayOrder AS displayOrder_7, r0_.filterSettings AS filterSettings_8, r0_.archivedAt AS archivedAt_9, r0_.createdAt AS createdAt_10, r0_.updatedAt AS updatedAt_11, r0_.deletedAt AS deletedAt_12, r0_.parentId AS parentId_13, r0_.reportTypeId AS reportTypeId_14, r0_.userId AS userId_15, r0_.organizationId AS organizationId_16 FROM Reports r0_ INNER JOIN ReportTypes r1_ ON r0_.reportTypeId = r1_.id AND (r1_.deletedAt IS NULL) INNER JOIN Organizations o2_ ON r0_.organizationId = o2_.id AND (o2_.deletedAt IS NULL) WHERE ((r0_.isVisible = 1 AND r0_.archivedAt IS NULL AND (o2_.identifier = ? OR o2_.id = ?) AND r0_.id = ?)) AND (r0_.deletedAt IS NULL) LIMIT 1 Parameters: [`"EXACTHIRE" 3 null`] View formatted query View runnable query Explain query SELECT r0_.id AS id_0, r0_.name AS name_1, r0_.description AS description_2, r0_.isVisible AS isVisible_3, r0_.isExportable AS isExportable_4, r0_.isSystemDefault AS isSystemDefault_5, r0_.routeUrl AS routeUrl_6, r0_.displayOrder AS displayOrder_7, r0_.filterSettings AS filterSettings_8, r0_.archivedAt AS archivedAt_9, r0_.createdAt AS createdAt_10, r0_.updatedAt AS updatedAt_11, r0_.deletedAt AS deletedAt_12, r0_.parentId AS parentId_13, r0_.reportTypeId AS reportTypeId_14, r0_.userId AS userId_15, r0_.organizationId AS organizationId_16 FROM Reports r0_ INNER JOIN ReportTypes r1_ ON r0_.reportTypeId = r1_.id AND (r1_.deletedAt IS NULL) INNER JOIN Organizations o2_ ON r0_.organizationId = o2_.id AND (o2_.deletedAt IS NULL) WHERE ( ( r0_.isVisible = 1 AND r0_.archivedAt IS NULL AND ( o2_.identifier = ? OR o2_.id = ? ) AND r0_.id = ? ) ) AND (r0_.deletedAt IS NULL) LIMIT 1 SELECT r0_.id AS id_0, r0_.name AS name_1, r0_.description AS description_2, r0_.isVisible AS isVisible_3, r0_.isExportable AS isExportable_4, r0_.isSystemDefault AS isSystemDefault_5, r0_.routeUrl AS routeUrl_6, r0_.displayOrder AS displayOrder_7, r0_.filterSettings AS filterSettings_8, r0_.archivedAt AS archivedAt_9, r0_.createdAt AS createdAt_10, r0_.updatedAt AS updatedAt_11, r0_.deletedAt AS deletedAt_12, r0_.parentId AS parentId_13, r0_.reportTypeId AS reportTypeId_14, r0_.userId AS userId_15, r0_.organizationId AS organizationId_16 FROM Reports r0_ INNER JOIN ReportTypes r1_ ON r0_.reportTypeId = r1_.id AND (r1_.deletedAt IS NULL) INNER JOIN Organizations o2_ ON r0_.organizationId = o2_.id AND (o2_.deletedAt IS NULL) WHERE ((r0_.isVisible = 1 AND r0_.archivedAt IS NULL AND (o2_.identifier = 'EXACTHIRE' OR o2_.id = 3) AND r0_.id = NULL)) AND (r0_.deletedAt IS NULL) LIMIT 1;
0.27 ms (1.18%)	1	SELECT TagScopes.id AS id0, TagScopes.resourceId AS resourceId1, TagScopes.createdAt AS createdAt2, TagScopes.updatedAt AS updatedAt3, TagScopes.deletedAt AS deletedAt4, TagScopes.archivedAt AS archivedAt5, TagScopes.dataPointId AS dataPointId6, TagScopes.dataPointOptionId AS dataPointOptionId7, TagScopes.userId AS userId8, TagScopes.organizationId AS organizationId9, TagScopes.dataPointResourceId AS dataPointResourceId10 FROM `TagScopes` JOIN `DataPointOptions` ON DataPointOptions.`id` = TagScopes.`dataPointOptionId` AND DataPointOptions.`deletedAt` IS NULL WHERE TagScopes.`organizationId` = ? AND TagScopes.`resourceId` = ? AND TagScopes.`dataPointResourceId` = ? AND TagScopes.`deletedAt` IS NULL Parameters: [`3 657 23`] View formatted query View runnable query Explain query SELECT TagScopes.id AS id0, TagScopes.resourceId AS resourceId1, TagScopes.createdAt AS createdAt2, TagScopes.updatedAt AS updatedAt3, TagScopes.deletedAt AS deletedAt4, TagScopes.archivedAt AS archivedAt5, TagScopes.dataPointId AS dataPointId6, TagScopes.dataPointOptionId AS dataPointOptionId7, TagScopes.userId AS userId8, TagScopes.organizationId AS organizationId9, TagScopes.dataPointResourceId AS dataPointResourceId10 FROM `TagScopes` JOIN `DataPointOptions` ON DataPointOptions.`id` = TagScopes.`dataPointOptionId` AND DataPointOptions.`deletedAt` IS NULL WHERE TagScopes.`organizationId` = ? AND TagScopes.`resourceId` = ? AND TagScopes.`dataPointResourceId` = ? AND TagScopes.`deletedAt` IS NULL SELECT TagScopes.id AS id0, TagScopes.resourceId AS resourceId1, TagScopes.createdAt AS createdAt2, TagScopes.updatedAt AS updatedAt3, TagScopes.deletedAt AS deletedAt4, TagScopes.archivedAt AS archivedAt5, TagScopes.dataPointId AS dataPointId6, TagScopes.dataPointOptionId AS dataPointOptionId7, TagScopes.userId AS userId8, TagScopes.organizationId AS organizationId9, TagScopes.dataPointResourceId AS dataPointResourceId10 FROM `TagScopes` JOIN `DataPointOptions` ON DataPointOptions.`id` = TagScopes.`dataPointOptionId` AND DataPointOptions.`deletedAt` IS NULL WHERE TagScopes.`organizationId` = 3 AND TagScopes.`resourceId` = 657 AND TagScopes.`dataPointResourceId` = 23 AND TagScopes.`deletedAt` IS NULL ;
0.26 ms (1.15%)	1	SELECT t0.id AS id_1, t0.createdAt AS createdAt_2, t0.updatedAt AS updatedAt_3, t0.deletedAt AS deletedAt_4, t0.roleId AS roleId_5, t0.organizationUserId AS organizationUserId_6 FROM OrganizationUserRoles t0 WHERE t0.organizationUserId = ? AND ((t0.deletedAt IS NULL)) Parameters: [`721`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.createdAt AS createdAt_2, t0.updatedAt AS updatedAt_3, t0.deletedAt AS deletedAt_4, t0.roleId AS roleId_5, t0.organizationUserId AS organizationUserId_6 FROM OrganizationUserRoles t0 WHERE t0.organizationUserId = ? AND ( (t0.deletedAt IS NULL) ) SELECT t0.id AS id_1, t0.createdAt AS createdAt_2, t0.updatedAt AS updatedAt_3, t0.deletedAt AS deletedAt_4, t0.roleId AS roleId_5, t0.organizationUserId AS organizationUserId_6 FROM OrganizationUserRoles t0 WHERE t0.organizationUserId = 721 AND ((t0.deletedAt IS NULL));
0.25 ms (1.09%)	1	SELECT Locations.id AS id, Locations.name AS name, Locations.description AS description, Locations.street1 AS street1, Locations.street2 AS street2, Locations.street3 AS street3, Locations.masterLocationId AS masterLocationId, Locations.postalCode AS postalCode, Locations.createdAt AS createdAt, Locations.updatedAt AS updatedAt, Locations.archivedAt AS archivedAt, Locations.deletedAt AS deletedAt, Locations.latitude AS latitude, Locations.longitude AS longitude, Locations.cityId AS cityId, Locations.stateId AS stateId, Locations.countryId AS countryId, Locations.organizationId AS organizationId, Locations.userId AS userId FROM Locations WHERE masterLocationId = ? AND name = ? LIMIT 1 Parameters: [`1 "All"`] View formatted query View runnable query Explain query SELECT Locations.id AS id, Locations.name AS name, Locations.description AS description, Locations.street1 AS street1, Locations.street2 AS street2, Locations.street3 AS street3, Locations.masterLocationId AS masterLocationId, Locations.postalCode AS postalCode, Locations.createdAt AS createdAt, Locations.updatedAt AS updatedAt, Locations.archivedAt AS archivedAt, Locations.deletedAt AS deletedAt, Locations.latitude AS latitude, Locations.longitude AS longitude, Locations.cityId AS cityId, Locations.stateId AS stateId, Locations.countryId AS countryId, Locations.organizationId AS organizationId, Locations.userId AS userId FROM Locations WHERE masterLocationId = ? AND name = ? LIMIT 1 SELECT Locations.id AS id, Locations.name AS name, Locations.description AS description, Locations.street1 AS street1, Locations.street2 AS street2, Locations.street3 AS street3, Locations.masterLocationId AS masterLocationId, Locations.postalCode AS postalCode, Locations.createdAt AS createdAt, Locations.updatedAt AS updatedAt, Locations.archivedAt AS archivedAt, Locations.deletedAt AS deletedAt, Locations.latitude AS latitude, Locations.longitude AS longitude, Locations.cityId AS cityId, Locations.stateId AS stateId, Locations.countryId AS countryId, Locations.organizationId AS organizationId, Locations.userId AS userId FROM Locations WHERE masterLocationId = 1 AND name = 'All' LIMIT 1;
0.22 ms (0.93%)	1	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 = ? Parameters: [`208991`] View formatted query View runnable query Explain query 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 = 208991;
0.19 ms (0.83%)	2	"START TRANSACTION" Parameters: [] View formatted query View runnable query Explain query "START TRANSACTION" "START TRANSACTION";
0.16 ms (0.70%)	1	SELECT t0.id AS id_1, t0.label AS label_2, t0.value AS value_3, t0.description AS description_4, t0.identifier AS identifier_5, t0.displayOrder AS displayOrder_6, t0.isLocked AS isLocked_7, t0.archivedAt AS archivedAt_8, t0.createdAt AS createdAt_9, t0.updatedAt AS updatedAt_10, t0.deletedAt AS deletedAt_11, t0.dataPointId AS dataPointId_12, t0.parentId AS parentId_13, t0.organizationId AS organizationId_14 FROM DataPointOptions t0 WHERE t0.identifier = ? AND ((t0.deletedAt IS NULL)) LIMIT 1 Parameters: [`"ORGANIZATION_MULTISTEP_STEP_1"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.label AS label_2, t0.value AS value_3, t0.description AS description_4, t0.identifier AS identifier_5, t0.displayOrder AS displayOrder_6, t0.isLocked AS isLocked_7, t0.archivedAt AS archivedAt_8, t0.createdAt AS createdAt_9, t0.updatedAt AS updatedAt_10, t0.deletedAt AS deletedAt_11, t0.dataPointId AS dataPointId_12, t0.parentId AS parentId_13, t0.organizationId AS organizationId_14 FROM DataPointOptions t0 WHERE t0.identifier = ? AND ( (t0.deletedAt IS NULL) ) LIMIT 1 SELECT t0.id AS id_1, t0.label AS label_2, t0.value AS value_3, t0.description AS description_4, t0.identifier AS identifier_5, t0.displayOrder AS displayOrder_6, t0.isLocked AS isLocked_7, t0.archivedAt AS archivedAt_8, t0.createdAt AS createdAt_9, t0.updatedAt AS updatedAt_10, t0.deletedAt AS deletedAt_11, t0.dataPointId AS dataPointId_12, t0.parentId AS parentId_13, t0.organizationId AS organizationId_14 FROM DataPointOptions t0 WHERE t0.identifier = 'ORGANIZATION_MULTISTEP_STEP_1' AND ((t0.deletedAt IS NULL)) LIMIT 1;

Database Connections

Name	Service
default	doctrine.dbal.default_connection
hirecentric	doctrine.dbal.hirecentric_connection

Entity Managers

Name	Service
default	doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Managed Entities

default entity manager

Class	Amount of managed objects
ExactHireApi\Entity\RolePermission	158
ExactHireApi\Entity\Permission	158
ExactHireApi\Entity\Position	60
ExactHireApi\Entity\PositionLocation	50
ExactHireApi\Entity\SubSystem	22
ExactHireApi\Entity\Location	15
ExactHireApi\Entity\DataPointOption	15
ExactHireApi\Entity\City	13
ExactHireApi\Entity\User	12
ExactHireApi\Entity\State	7
ExactHireApi\Entity\DataPoint	3
ExactHireApi\Entity\Organization	2
ExactHireApi\Entity\PermissionType	2
ExactHireApi\Entity\DataPointResource	2
ExactHireApi\Entity\OrganizationUser	1
ExactHireApi\Entity\OrganizationUserRole	1
ExactHireApi\Entity\Role	1
ExactHireApi\Entity\Provider	1
ExactHireApi\Entity\LocationScope	1
ExactHireApi\Entity\TagScope	1
ExactHireApi\Entity\Country	1

Entities Mapping

Class	Mapping errors
ExactHireApi\Entity\SSOToken	No errors.
ExactHireApi\Entity\User	No errors.
ExactHireApi\Entity\OrganizationUser	No errors.
ExactHireApi\Entity\Organization	The field ExactHireApi\Entity\Organization#loginAttempts is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity ExactHireApi\Entity\LoginAttempt#organization does not contain the required 'inversedBy="loginAttempts"' attribute.
ExactHireApi\Entity\Person	The mappings ExactHireApi\Entity\Person#dataPointAnswerPeople and ExactHireApi\Entity\DataPointAnswerPerson#person are inconsistent with each other. The mappings ExactHireApi\Entity\Person#personSignatures and ExactHireApi\Entity\PersonSignature#person are inconsistent with each other.
ExactHireApi\Entity\RemoteUser	No errors.
ExactHireApi\Entity\HttpLog	No errors.
ExactHireApi\Entity\Workflow	No errors.
ExactHireApi\Entity\WorkflowAssignment	The association ExactHireApi\Entity\WorkflowAssignment#organization refers to the inverse side field ExactHireApi\Entity\Organization#workflowAssignments which does not exist.
ExactHireApi\Entity\TaskUser	No errors.
ExactHireApi\Entity\Task	The association ExactHireApi\Entity\Task#timeType refers to the inverse side field ExactHireApi\Entity\TimeType#tasks which does not exist. The association ExactHireApi\Entity\Task#taskAction refers to the inverse side field ExactHireApi\Entity\TaskAction#tasks which does not exist. The association ExactHireApi\Entity\Task#workflowAssignment refers to the inverse side field ExactHireApi\Entity\WorkflowAssignment#tasks which does not exist.
ExactHireApi\Entity\TaskStatus	No errors.
ExactHireApi\Entity\Credential	No errors.
ExactHireApi\Entity\Report	No errors.
ExactHireApi\Entity\Export	No errors.
ExactHireApi\Entity\UserProviderMetadata	No errors.
ExactHireApi\Entity\AssignedUserApplication	No errors.
ExactHireApi\Entity\Rating	No errors.
ExactHireApi\Entity\EmailTemplate	No errors.
ExactHireApi\Entity\HiringTeamManager	No errors.
ExactHireApi\Entity\HiringTeam	No errors.
ExactHireApi\Entity\HiringTeamNotification	No errors.
ExactHireApi\Entity\OrganizationUserRole	No errors.
ExactHireApi\Entity\ScreeningSetup	No errors.
ExactHireApi\Entity\Role	No errors.
ExactHireApi\Entity\RolePermission	No errors.
ExactHireApi\Entity\TaskRole	No errors.
ExactHireApi\Entity\RoleInheritedPermissionExclusion	No errors.
ExactHireApi\Entity\RoleInheritedPermissionAddition	No errors.
ExactHireApi\Entity\Provider	No errors.
ExactHireApi\Entity\ProviderListing	No errors.
ExactHireApi\Entity\Publisher	No errors.
ExactHireApi\Entity\ProviderEndpoint	No errors.
ExactHireApi\Entity\ProviderSetting	No errors.
ExactHireApi\Entity\ProviderViewType	No errors.
ExactHireApi\Entity\OrganizationProviderStatus	No errors.
ExactHireApi\Entity\ProviderMetadata	No errors.
ExactHireApi\Entity\JobBoard	No errors.
ExactHireApi\Entity\Permission	No errors.
ExactHireApi\Entity\SubSystem	No errors.
ExactHireApi\Entity\PermissionType	No errors.
ExactHireApi\Entity\ReportType	No errors.
ExactHireApi\Entity\DataPointResource	No errors.
ExactHireApi\Entity\DataPoint	No errors.
ExactHireApi\Entity\EventResource	No errors.
ExactHireApi\Entity\LocationScope	No errors.
ExactHireApi\Entity\Location	No errors.
ExactHireApi\Entity\City	The field ExactHireApi\Entity\City#locations is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity ExactHireApi\Entity\Location#city does not contain the required 'inversedBy="locations"' attribute.
ExactHireApi\Entity\State	The field ExactHireApi\Entity\State#locations is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity ExactHireApi\Entity\Location#state does not contain the required 'inversedBy="locations"' attribute.
ExactHireApi\Entity\Country	No errors.
ExactHireApi\Entity\OrganizationLocation	No errors.
ExactHireApi\Entity\PersonLocation	No errors.
ExactHireApi\Entity\PositionLocation	No errors.
ExactHireApi\Entity\TagScope	No errors.
ExactHireApi\Entity\DataPointOption	No errors.
ExactHireApi\Entity\DataPointOptionSelection	No errors.
ExactHireApi\Entity\Position	No errors.
ExactHireApi\Entity\DataPointAnswerPosition	No errors.
ExactHireApi\Entity\PositionProviderMetadata	No errors.
ExactHireApi\Entity\PositionProviderSetting	No errors.
ExactHireApi\Entity\PositionAnalytic	No errors.
ExactHireApi\Entity\PositionView	The mappings ExactHireApi\Entity\PositionView#positionAd and ExactHireApi\Entity\Position#positionViews are inconsistent with each other.
ExactHireApi\Entity\PositionActiveHistory	No errors.
ExactHireApi\Entity\PositionStatusHistory	No errors.
ExactHireApi\Entity\JobBoardAd	The association ExactHireApi\Entity\JobBoardAd#organization refers to the inverse side field ExactHireApi\Entity\Organization#jobBoardAds which does not exist. The mappings ExactHireApi\Entity\JobBoardAd#jobBoardAdAnalytics and ExactHireApi\Entity\JobBoardAdAnalytic#jobBoardAd are inconsistent with each other.
ExactHireApi\Entity\PositionCareerSite	No errors.
ExactHireApi\Entity\ApplicationPositionAd	No errors.
ExactHireApi\Entity\DataPointTemplatePosition	No errors.
ExactHireApi\Entity\PositionRoleAssignment	The association ExactHireApi\Entity\PositionRoleAssignment#positionRole refers to the inverse side field ExactHireApi\Entity\PositionRole#positionRoles which does not exist.
ExactHireApi\Entity\Application	No errors.
ExactHireApi\Entity\PositionNote	No errors.
ExactHireApi\Entity\JobTag	No errors.

Symfony Profiler

GET http://localhost/api/positions?limit=50&page=1

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

default connection

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping