https://hmsdcportal2.ctssys.com/api/committees?page=3

Method
GET
HTTP Status
200
IP
209.97.144.149
Profiled on
Token
62f325

Query Metrics

1 Database Queries
1 Different statements
2.63 ms Query time
0 Invalid entities

Queries

Group similar statements

#▲ Time Info
1 2.63 ms 
SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.type AS type_2, c0_.description AS description_3, c0_.time_note AS time_note_4, c0_.members AS members_5, c0_.chair_name AS chair_name_6, c0_.chair_email AS chair_email_7, c0_.chair_phone AS chair_phone_8, c0_.staff_liaison_name AS staff_liaison_name_9, c0_.staff_liaison_email AS staff_liaison_email_10, c0_.staff_liaison_phone AS staff_liaison_phone_11, c0_.staff_phone_extension AS staff_phone_extension_12, c0_.new_member_email_template AS new_member_email_template_13, c0_.start_date AS start_date_14, c0_.start_hour AS start_hour_15, c0_.start_minute AS start_minute_16, c0_.end_date AS end_date_17, c0_.end_hour AS end_hour_18, c0_.meridiem_start AS meridiem_start_19, c0_.meridiem_end AS meridiem_end_20, c0_.end_minute AS end_minute_21, c0_.is_all_day AS is_all_day_22, c0_.is_repeat AS is_repeat_23, c0_.repeat_type AS repeat_type_24, c0_.meeting_link AS meeting_link_25, c0_.repeat_options AS repeat_options_26, c0_.deleted AS deleted_27, c0_.sequence AS sequence_28, c0_.status AS status_29, u1_.id AS id_30, u1_.email AS email_31, u1_.roles AS roles_32, u1_.password AS password_33, u1_.first_name AS first_name_34, u1_.last_name AS last_name_35, u1_.phone_number AS phone_number_36, u1_.membership_level AS membership_level_37, u1_.is_ambassador AS is_ambassador_38, u1_.reset_hash AS reset_hash_39, u1_.reset_hash_expire AS reset_hash_expire_40, u1_.title AS title_41, u1_.phone_ext AS phone_ext_42, u1_.mobile AS mobile_43, u1_.contact_type AS contact_type_44, u1_.department AS department_45, u1_.fax AS fax_46, u1_.user_type AS user_type_47, u1_.last_login AS last_login_48, u1_.is_new AS is_new_49, u1_.internal AS internal_50, u1_.username AS username_51, u1_.accepted_terms AS accepted_terms_52, u1_.accepted_terms_time AS accepted_terms_time_53, u1_.ambassador_assigned_date AS ambassador_assigned_date_54, u1_.request_status AS request_status_55, u1_.user_accepted_terms2 AS user_accepted_terms2_56, u1_.user_accepted_terms_time2 AS user_accepted_terms_time2_57, u1_.download_nda_time AS download_nda_time_58, m2_.id AS id_59, m2_.name AS name_60, m2_.first_name AS first_name_61, m2_.last_name AS last_name_62, m2_.email AS email_63, m2_.phone AS phone_64, m2_.fei AS fei_65, m2_.street AS street_66, m2_.city AS city_67, m2_.state AS state_68, m2_.zip AS zip_69, m2_.industry AS industry_70, m2_.ethnicity AS ethnicity_71, m2_.external_id AS external_id_72, m2_.revenue AS revenue_73, m2_.type AS type_74, m2_.gender AS gender_75, m2_.business_type AS business_type_76, m2_.business_structure AS business_structure_77, m2_.geographic_market AS geographic_market_78, m2_.description AS description_79, m2_.naics AS naics_80, m2_.nigp AS nigp_81, m2_.keywords AS keywords_82, m2_.certifications AS certifications_83, m2_.certification_entity AS certification_entity_84, m2_.certification_type AS certification_type_85, m2_.certification_date AS certification_date_86, m2_.year_established AS year_established_87, m2_.qualify_status AS qualify_status_88, m2_.website AS website_89, m2_.employees AS employees_90, m2_.status AS status_91, m2_.revenue_class AS revenue_class_92, m2_.rating AS rating_93, m2_.your_industry AS your_industry_94, m2_.professional_licenses AS professional_licenses_95, m2_.dba AS dba_96, m2_.created_at AS created_at_97, m2_.modified_at AS modified_at_98, m2_.senate AS senate_99, m2_.house_of_representatives AS house_of_representatives_100, m2_.congressional AS congressional_101, m2_.commissioner AS commissioner_102, m2_.school_board AS school_board_103, m2_.city_council AS city_council_104, m2_.deleted AS deleted_105, u3_.id AS id_106, u3_.email AS email_107, u3_.roles AS roles_108, u3_.password AS password_109, u3_.first_name AS first_name_110, u3_.last_name AS last_name_111, u3_.phone_number AS phone_number_112, u3_.membership_level AS membership_level_113, u3_.is_ambassador AS is_ambassador_114, u3_.reset_hash AS reset_hash_115, u3_.reset_hash_expire AS reset_hash_expire_116, u3_.title AS title_117, u3_.phone_ext AS phone_ext_118, u3_.mobile AS mobile_119, u3_.contact_type AS contact_type_120, u3_.department AS department_121, u3_.fax AS fax_122, u3_.user_type AS user_type_123, u3_.last_login AS last_login_124, u3_.is_new AS is_new_125, u3_.internal AS internal_126, u3_.username AS username_127, u3_.accepted_terms AS accepted_terms_128, u3_.accepted_terms_time AS accepted_terms_time_129, u3_.ambassador_assigned_date AS ambassador_assigned_date_130, u3_.request_status AS request_status_131, u3_.user_accepted_terms2 AS user_accepted_terms2_132, u3_.user_accepted_terms_time2 AS user_accepted_terms_time2_133, u3_.download_nda_time AS download_nda_time_134, u4_.id AS id_135, u4_.email AS email_136, u4_.roles AS roles_137, u4_.password AS password_138, u4_.first_name AS first_name_139, u4_.last_name AS last_name_140, u4_.phone_number AS phone_number_141, u4_.membership_level AS membership_level_142, u4_.is_ambassador AS is_ambassador_143, u4_.reset_hash AS reset_hash_144, u4_.reset_hash_expire AS reset_hash_expire_145, u4_.title AS title_146, u4_.phone_ext AS phone_ext_147, u4_.mobile AS mobile_148, u4_.contact_type AS contact_type_149, u4_.department AS department_150, u4_.fax AS fax_151, u4_.user_type AS user_type_152, u4_.last_login AS last_login_153, u4_.is_new AS is_new_154, u4_.internal AS internal_155, u4_.username AS username_156, u4_.accepted_terms AS accepted_terms_157, u4_.accepted_terms_time AS accepted_terms_time_158, u4_.ambassador_assigned_date AS ambassador_assigned_date_159, u4_.request_status AS request_status_160, u4_.user_accepted_terms2 AS user_accepted_terms2_161, u4_.user_accepted_terms_time2 AS user_accepted_terms_time2_162, u4_.download_nda_time AS download_nda_time_163, m5_.id AS id_164, m5_.name AS name_165, m5_.first_name AS first_name_166, m5_.last_name AS last_name_167, m5_.email AS email_168, m5_.phone AS phone_169, m5_.fei AS fei_170, m5_.street AS street_171, m5_.city AS city_172, m5_.state AS state_173, m5_.zip AS zip_174, m5_.industry AS industry_175, m5_.ethnicity AS ethnicity_176, m5_.external_id AS external_id_177, m5_.revenue AS revenue_178, m5_.type AS type_179, m5_.gender AS gender_180, m5_.business_type AS business_type_181, m5_.business_structure AS business_structure_182, m5_.geographic_market AS geographic_market_183, m5_.description AS description_184, m5_.naics AS naics_185, m5_.nigp AS nigp_186, m5_.keywords AS keywords_187, m5_.certifications AS certifications_188, m5_.certification_entity AS certification_entity_189, m5_.certification_type AS certification_type_190, m5_.certification_date AS certification_date_191, m5_.year_established AS year_established_192, m5_.qualify_status AS qualify_status_193, m5_.website AS website_194, m5_.employees AS employees_195, m5_.status AS status_196, m5_.revenue_class AS revenue_class_197, m5_.rating AS rating_198, m5_.your_industry AS your_industry_199, m5_.professional_licenses AS professional_licenses_200, m5_.dba AS dba_201, m5_.created_at AS created_at_202, m5_.modified_at AS modified_at_203, m5_.senate AS senate_204, m5_.house_of_representatives AS house_of_representatives_205, m5_.congressional AS congressional_206, m5_.commissioner AS commissioner_207, m5_.school_board AS school_board_208, m5_.city_council AS city_council_209, m5_.deleted AS deleted_210, u6_.id AS id_211, u6_.email AS email_212, u6_.roles AS roles_213, u6_.password AS password_214, u6_.first_name AS first_name_215, u6_.last_name AS last_name_216, u6_.phone_number AS phone_number_217, u6_.membership_level AS membership_level_218, u6_.is_ambassador AS is_ambassador_219, u6_.reset_hash AS reset_hash_220, u6_.reset_hash_expire AS reset_hash_expire_221, u6_.title AS title_222, u6_.phone_ext AS phone_ext_223, u6_.mobile AS mobile_224, u6_.contact_type AS contact_type_225, u6_.department AS department_226, u6_.fax AS fax_227, u6_.user_type AS user_type_228, u6_.last_login AS last_login_229, u6_.is_new AS is_new_230, u6_.internal AS internal_231, u6_.username AS username_232, u6_.accepted_terms AS accepted_terms_233, u6_.accepted_terms_time AS accepted_terms_time_234, u6_.ambassador_assigned_date AS ambassador_assigned_date_235, u6_.request_status AS request_status_236, u6_.user_accepted_terms2 AS user_accepted_terms2_237, u6_.user_accepted_terms_time2 AS user_accepted_terms_time2_238, u6_.download_nda_time AS download_nda_time_239, c7_.id AS id_240, c7_.name AS name_241, c7_.type AS type_242, c7_.description AS description_243, c7_.time_note AS time_note_244, c7_.members AS members_245, c7_.chair_name AS chair_name_246, c7_.chair_email AS chair_email_247, c7_.chair_phone AS chair_phone_248, c7_.staff_liaison_name AS staff_liaison_name_249, c7_.staff_liaison_email AS staff_liaison_email_250, c7_.staff_liaison_phone AS staff_liaison_phone_251, c7_.staff_phone_extension AS staff_phone_extension_252, c7_.new_member_email_template AS new_member_email_template_253, c7_.start_date AS start_date_254, c7_.start_hour AS start_hour_255, c7_.start_minute AS start_minute_256, c7_.end_date AS end_date_257, c7_.end_hour AS end_hour_258, c7_.meridiem_start AS meridiem_start_259, c7_.meridiem_end AS meridiem_end_260, c7_.end_minute AS end_minute_261, c7_.is_all_day AS is_all_day_262, c7_.is_repeat AS is_repeat_263, c7_.repeat_type AS repeat_type_264, c7_.meeting_link AS meeting_link_265, c7_.repeat_options AS repeat_options_266, c7_.deleted AS deleted_267, c7_.sequence AS sequence_268, c7_.status AS status_269, c0_.chair_id AS chair_id_270, c0_.staff_liaison_id AS staff_liaison_id_271, c0_.parent_id AS parent_id_272, u1_.member_id AS member_id_273, u1_.ambassador_id AS ambassador_id_274, u3_.member_id AS member_id_275, u3_.ambassador_id AS ambassador_id_276, u4_.member_id AS member_id_277, u4_.ambassador_id AS ambassador_id_278, u6_.member_id AS member_id_279, u6_.ambassador_id AS ambassador_id_280, c7_.chair_id AS chair_id_281, c7_.staff_liaison_id AS staff_liaison_id_282, c7_.parent_id AS parent_id_283 FROM committee c0_ LEFT JOIN `user` u1_ ON c0_.chair_id = u1_.id LEFT JOIN member m2_ ON u1_.member_id = m2_.id LEFT JOIN `user` u3_ ON u1_.ambassador_id = u3_.id LEFT JOIN `user` u4_ ON c0_.staff_liaison_id = u4_.id LEFT JOIN member m5_ ON u4_.member_id = m5_.id LEFT JOIN `user` u6_ ON u4_.ambassador_id = u6_.id LEFT JOIN committee c7_ ON c0_.parent_id = c7_.id ORDER BY c0_.id ASC LIMIT 20 OFFSET 40
Parameters: 
[]
View formatted query    View runnable query    Explain query

Database Connections

Name Service
default doctrine.dbal.default_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

Class Mapping errors
App\Entity\Committee No errors.
App\Entity\User No errors.
App\Entity\Member No errors.