Query Metrics
4
Database Queries
4
Different statements
3.43 ms
Query time
0
Invalid entities
Queries
#▲ | 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. |