https://dev.oceanexpert.org/event/347

Query Metrics

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

Queries

Group similar statements

# Time Info
1 1.23 ms
SELECT t0.id_eventtype AS id_eventtype_1, t0.title AS title_2, t0.shorttitle AS shorttitle_3, t0.summary AS summary_4, t0.start_on AS start_on_5, t0.end_on AS end_on_6, t0.address AS address_7, t0.city AS city_8, t0.state AS state_9, t0.postcode AS postcode_10, t0.id_country AS id_country_11, t0.id_inst AS id_inst_12, t0.use_inst_addr AS use_inst_addr_13, t0.notes AS notes_14, t0.website AS website_15, t0.redirect_website AS redirect_website_16, t0.keywords AS keywords_17, t0.created_by AS created_by_18, t0.created_at AS created_at_19, t0.updated_at AS updated_at_20, t0.last_edit_by AS last_edit_by_21, t0.is_public AS is_public_22, t0.is_open AS is_open_23, t0.show_travel AS show_travel_24, t0.email_people AS email_people_25, t0.id_contact AS id_contact_26, t0.reg_online AS reg_online_27, t0.status AS status_28, t0.id_event AS id_event_29 FROM events t0 WHERE t0.id_event = ? AND t0.status = ? LIMIT 1
Parameters:
[
  "347"
  1
]
2 0.61 ms
SELECT t0.eventtype_name AS eventtype_name_1, t0.id_eventtype AS id_eventtype_2 FROM eventtypes t0 WHERE t0.id_eventtype = ? LIMIT 1
Parameters:
[
  1
]
3 0.82 ms
SELECT t0.id_event AS id_event_1, t0.filename AS filename_2, t0.type AS type_3, t0.path AS path_4, t0.created_by AS created_by_5, t0.created_at AS created_at_6, t0.deleted AS deleted_7, t0.id AS id_8 FROM event_files t0 WHERE t0.id_event = ? LIMIT 1
Parameters:
[
  "347"
]
4 0.78 ms
SELECT t0.parent_id AS parent_id_1, t0.inst_type_id AS inst_type_id_2, t0.inst_name AS inst_name_3, t0.inst_name_eng AS inst_name_eng_4, t0.inst_address AS inst_address_5, t0.addr_2 AS addr_2_6, t0.city AS city_7, t0.state AS state_8, t0.postcode AS postcode_9, t0.country_code AS country_code_10, t0.acronym AS acronym_11, t0.inst_tel AS inst_tel_12, t0.inst_fax AS inst_fax_13, t0.inst_email AS inst_email_14, t0.inst_url AS inst_url_15, t0.inst_logo AS inst_logo_16, t0.edmo_code AS edmo_code_17, t0.activities AS activities_18, t0.inst_region AS inst_region_19, t0.popularity AS popularity_20, t0.activated AS activated_21, t0.f_date_entered AS f_date_entered_22, t0.l_date_updated AS l_date_updated_23, t0.created_by AS created_by_24, t0.last_edit_by AS last_edit_by_25, t0.id_inst AS id_inst_26 FROM institutions t0 WHERE t0.id_inst = ? LIMIT 1
Parameters:
[
  9786
]

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\Events No errors.
OceanExpertBundle\Entity\Eventtypes No errors.
OceanExpertBundle\Entity\EventFiles No errors.
OceanExpertBundle\Entity\Institutions No errors.