https://install.oceanexpert.org/group

Query Metrics

4 Database Queries
4 Different statements
4.51 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
1.90 ms
(42.12%)
1
SELECT g0_.id_group AS id_group_0, g0_.groupname AS groupname_1, g0_.id_parentgroup AS id_parentgroup_2, g0_.group_order AS group_order_3 FROM groups g0_ ORDER BY g0_.id_parentgroup ASC, g0_.group_order ASC
Parameters:
[]
1.10 ms
(24.37%)
1
SELECT t0.id_ind AS id_ind_1, t0.title AS title_2, t0.fname AS fname_3, t0.mname AS mname_4, t0.sname AS sname_5, t0.identifier AS identifier_6, t0.reg_type AS reg_type_7, t0.use_inst_addr AS use_inst_addr_8, t0.private_address AS private_address_9, t0.addr_1 AS addr_1_10, t0.addr_2 AS addr_2_11, t0.city AS city_12, t0.state AS state_13, t0.postcode AS postcode_14, t0.country_code AS country_code_15, t0.id_nationality AS id_nationality_16, t0.gender AS gender_17, t0.tel AS tel_18, t0.fax AS fax_19, t0.email1 AS email1_20, t0.email2 AS email2_21, t0.email3 AS email3_22, t0.emailtouse AS emailtouse_23, t0.url1 AS url1_24, t0.url1Valid AS url1Valid_25, t0.url2 AS url2_26, t0.url2Valid AS url2Valid_27, t0.url3 AS url3_28, t0.url3Valid AS url3Valid_29, t0.urlsChecked AS urlsChecked_30, t0.linkedin AS linkedin_31, t0.facebook AS facebook_32, t0.twitter AS twitter_33, t0.flickr AS flickr_34, t0.other AS other_35, t0.degree AS degree_36, t0.activeng AS activeng_37, t0.activother AS activother_38, t0.jobtitle AS jobtitle_39, t0.dept AS dept_40, t0.studyregion AS studyregion_41, t0.languages AS languages_42, t0.skills AS skills_43, t0.comments AS comments_44, t0.do_not_invite AS do_not_invite_45, t0.do_no_invite_by AS do_no_invite_by_46, t0.do_no_invite_on AS do_no_invite_on_47, t0.admin_comments AS admin_comments_48, t0.id_imagefile AS id_imagefile_49, t0.id_imagefile_full AS id_imagefile_full_50, t0.receive_mail AS receive_mail_51, t0.member_alert AS member_alert_52, t0.cit_alert AS cit_alert_53, t0.f_date_ent AS f_date_ent_54, t0.l_date_upd AS l_date_upd_55, t0.created_by AS created_by_56, t0.last_edit_by AS last_edit_by_57, t0.quality_checked_by AS quality_checked_by_58, t0.quality_checked_date AS quality_checked_date_59, t0.quality_checked AS quality_checked_60, t0.is_global AS is_global_61, t0.status AS status_62, t0.statusLastChanged AS statusLastChanged_63, t0.deceased AS deceased_64, t0.deceased_date AS deceased_date_65, t0.retired AS retired_66, t0.retired_date AS retired_date_67, t0.id AS id_68 FROM indiv t0 WHERE t0.id_ind = ? LIMIT 1
Parameters:
[
  "anon."
]
0.76 ms
(16.95%)
1
SELECT g0_.id_group AS id_group_0, g0_.groupname AS groupname_1, g0_.id_parentgroup AS id_parentgroup_2, g0_.group_order AS group_order_3 FROM groups g0_ WHERE g0_.id_group = ?
Parameters:
[
  29
]
0.75 ms
(16.56%)
1
SELECT g0_.groupname AS groupname_0, g0_.description AS description_1, g0_.id_parentgroup AS id_parentgroup_2, g0_.group_order AS group_order_3, g0_.has_site AS has_site_4, g0_.url AS url_5, g0_.official_body AS official_body_6, g0_.id_mstemplate AS id_mstemplate_7, g0_.id_group AS id_group_8 FROM groups g0_ WHERE g0_.id_group = ?
Parameters:
[
  29
]

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
OceanExpertBundle\Entity\Groups No errors.
OceanExpertBundle\Entity\Indiv No errors.