Query Metrics
226
Database Queries
24
Different statements
124.02 ms
Query time
0
Invalid entities
Queries
#▲ | Time | Info |
---|---|---|
1 | 0.84 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:
[ "126" 1 ] |
2 | 0.47 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:
[
3
]
|
3 | 0.58 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:
[
"126"
]
|
4 | 0.49 ms |
SELECT t0.country AS country_1, t0.postcode_pos AS postcode_pos_2, t0.postcode_spacer AS postcode_spacer_3, t0.country_code AS country_code_4, t0.latitude AS latitude_5, t0.longitude AS longitude_6, t0.id_country AS id_country_7 FROM countries t0 WHERE t0.id_country = ? LIMIT 1
Parameters:
[
114
]
|
5 | 0.81 ms |
SELECT i0_.id_ind AS id_ind_0, i0_.title AS title_1, i0_.fname AS fname_2, i0_.sname AS sname_3 FROM event_contacts e1_ LEFT JOIN indiv i0_ ON (i0_.id_ind = e1_.id_ind) WHERE e1_.id_event = ? AND i0_.sname IS NOT NULL ORDER BY i0_.sname ASC
Parameters:
[
"126"
]
|
6 | 0.57 ms |
SELECT i0_.id_ind AS id_ind_0, i0_.title AS title_1, i0_.fname AS fname_2, i0_.sname AS sname_3 FROM event_staff e1_ LEFT JOIN indiv i0_ ON (i0_.id_ind = e1_.id_ind) WHERE e1_.id_event = ? ORDER BY i0_.sname ASC
Parameters:
[
"126"
]
|
7 | 1.56 ms |
SELECT count(e0_.id_ind) AS sclr_0, e0_.status AS status_1 FROM event_participants e0_ WHERE e0_.id_event = ? GROUP BY e0_.status
Parameters:
[
"126"
]
|
8 | 1.11 ms |
SELECT t0.id_event AS id_event_1, t0.id_agendaitem AS id_agendaitem_2, t0.title AS title_3, t0.parent_idevent AS parent_idevent_4, t0.notes AS notes_5, t0.required_actions AS required_actions_6, t0.agenda_order AS agenda_order_7, t0.id AS id_8 FROM event_agendaitems t0 WHERE t0.id_event = ? LIMIT 1
Parameters:
[
"126"
]
|
9 | 6.62 ms |
SELECT e0_.id_agendaitem AS id_agendaitem_0, e0_.id AS id_1, e0_.title AS title_2, e0_.parent_idevent AS parent_idevent_3, e0_.agenda_order AS agenda_order_4, e0_.notes AS notes_5, e0_.required_actions AS required_actions_6 FROM event_agendaitems e0_ WHERE e0_.id_event = ? ORDER BY e0_.agenda_order ASC
Parameters:
[
"126"
]
|
10 | 1.39 ms |
SELECT d0_.title AS title_0, d0_.id_doc AS id_doc_1, d0_.doc_code AS doc_code_2 FROM agendaitem_documents a1_ LEFT JOIN documents d0_ ON (d0_.id_doc = a1_.id_doc) WHERE a1_.id_event = ? AND a1_.id_agendaitem = ?
Parameters:
[ "126" "10.14" ] |
11 | 0.50 ms |
SELECT d0_.title AS title_0, d0_.id_doc AS id_doc_1, d0_.doc_code AS doc_code_2 FROM agendaitem_documents a1_ LEFT JOIN documents d0_ ON (d0_.id_doc = a1_.id_doc) WHERE a1_.id_event = ? AND a1_.id_agendaitem = ?
Parameters:
[ "126" "10.15" ] |
12 | 0.46 ms |
SELECT d0_.title AS title_0, d0_.id_doc AS id_doc_1, d0_.doc_code AS doc_code_2 FROM agendaitem_documents a1_ LEFT JOIN documents d0_ ON (d0_.id_doc = a1_.id_doc) WHERE a1_.id_event = ? AND a1_.id_agendaitem = ?
Parameters:
[ "126" "10.2" ] |
13 | 0.43 ms |
SELECT d0_.title AS title_0, d0_.id_doc AS id_doc_1, d0_.doc_code AS doc_code_2 FROM agendaitem_documents a1_ LEFT JOIN documents d0_ ON (d0_.id_doc = a1_.id_doc) WHERE a1_.id_event = ? AND a1_.id_agendaitem = ?
Parameters:
[ "126" "10.3" ] |
14 | 0.41 ms |
SELECT d0_.title AS title_0, d0_.id_doc AS id_doc_1, d0_.doc_code AS doc_code_2 FROM agendaitem_documents a1_ LEFT JOIN documents d0_ ON (d0_.id_doc = a1_.id_doc) WHERE a1_.id_event = ? AND a1_.id_agendaitem = ?
Parameters:
[ "126" "10.4" ] |
15 | 0.39 ms |
SELECT d0_.title AS title_0, d0_.id_doc AS id_doc_1, d0_.doc_code AS doc_code_2 FROM agendaitem_documents a1_ LEFT JOIN documents d0_ ON (d0_.id_doc = a1_.id_doc) WHERE a1_.id_event = ? AND a1_.id_agendaitem = ?
Parameters:
[ "126" "10.5" ] |
16 | 0.41 ms |
SELECT d0_.title AS title_0, d0_.id_doc AS id_doc_1, d0_.doc_code AS doc_code_2 FROM agendaitem_documents a1_ LEFT JOIN documents d0_ ON (d0_.id_doc = a1_.id_doc) WHERE a1_.id_event = ? AND a1_.id_agendaitem = ?
Parameters:
[ "126" "10.6" ] |
17 | 0.41 ms |
SELECT d0_.title AS title_0, d0_.id_doc AS id_doc_1, d0_.doc_code AS doc_code_2 FROM agendaitem_documents a1_ LEFT JOIN documents d0_ ON (d0_.id_doc = a1_.id_doc) WHERE a1_.id_event = ? AND a1_.id_agendaitem = ?
Parameters:
[ "126" "10.7" ] |
18 | 0.50 ms |
SELECT d0_.title AS title_0, d0_.id_doc AS id_doc_1, d0_.doc_code AS doc_code_2 FROM agendaitem_documents a1_ LEFT JOIN documents d0_ ON (d0_.id_doc = a1_.id_doc) WHERE a1_.id_event = ? AND a1_.id_agendaitem = ?
Parameters:
[ "126" "10.8" ] |
19 | 0.39 ms |
SELECT d0_.title AS title_0, d0_.id_doc AS id_doc_1, d0_.doc_code AS doc_code_2 FROM agendaitem_documents a1_ LEFT JOIN documents d0_ ON (d0_.id_doc = a1_.id_doc) WHERE a1_.id_event = ? AND a1_.id_agendaitem = ?
Parameters:
[ "126" "10.9" ] |
20 | 3.11 ms |
SELECT d0_.title AS title_0, d0_.id_doc AS id_doc_1, d0_.doc_code AS doc_code_2 FROM agendaitem_documents a1_ LEFT JOIN documents d0_ ON (d0_.id_doc = a1_.id_doc) WHERE a1_.id_event = ? AND a1_.id_agendaitem = ?
Parameters:
[ "126" "2" ] |
21 | 0.51 ms |
SELECT d0_.title AS title_0, d0_.id_doc AS id_doc_1, d0_.doc_code AS doc_code_2 FROM agendaitem_documents a1_ LEFT JOIN documents d0_ ON (d0_.id_doc = a1_.id_doc) WHERE a1_.id_event = ? AND a1_.id_agendaitem = ?
Parameters:
[ "126" "2.1" ] |
22 | 0.46 ms |
SELECT d0_.title AS title_0, d0_.id_doc AS id_doc_1, d0_.doc_code AS doc_code_2 FROM agendaitem_documents a1_ LEFT JOIN documents d0_ ON (d0_.id_doc = a1_.id_doc) WHERE a1_.id_event = ? AND a1_.id_agendaitem = ?
Parameters:
[ "126" "2.2" ] |
23 | 0.46 ms |
SELECT d0_.title AS title_0, d0_.id_doc AS id_doc_1, d0_.doc_code AS doc_code_2 FROM agendaitem_documents a1_ LEFT JOIN documents d0_ ON (d0_.id_doc = a1_.id_doc) WHERE a1_.id_event = ? AND a1_.id_agendaitem = ?
Parameters:
[ "126" "2.3" ] |
24 | 0.45 ms |
SELECT d0_.title AS title_0, d0_.id_doc AS id_doc_1, d0_.doc_code AS doc_code_2 FROM agendaitem_documents a1_ LEFT JOIN documents d0_ ON (d0_.id_doc = a1_.id_doc) WHERE a1_.id_event = ? AND a1_.id_agendaitem = ?
Parameters:
[ "126" "2.4" ] |
25 | 0.42 ms |
SELECT d0_.title AS title_0, d0_.id_doc AS id_doc_1, d0_.doc_code AS doc_code_2 FROM agendaitem_documents a1_ LEFT JOIN documents d0_ ON (d0_.id_doc = a1_.id_doc) WHERE a1_.id_event = ? AND a1_.id_agendaitem = ?
Parameters:
[ "126" "2.5" ] |
26 | 0.47 ms |
SELECT d0_.title AS title_0, d0_.id_doc AS id_doc_1, d0_.doc_code AS doc_code_2 FROM agendaitem_documents a1_ LEFT JOIN documents d0_ ON (d0_.id_doc = a1_.id_doc) WHERE a1_.id_event = ? AND a1_.id_agendaitem = ?
Parameters:
[ "126" "3" ] |
27 | 0.43 ms |
SELECT d0_.title AS title_0, d0_.id_doc AS id_doc_1, d0_.doc_code AS doc_code_2 FROM agendaitem_documents a1_ LEFT JOIN documents d0_ ON (d0_.id_doc = a1_.id_doc) WHERE a1_.id_event = ? AND a1_.id_agendaitem = ?
Parameters:
[ "126" "3.1" ] |
28 | 0.42 ms |
SELECT d0_.title AS title_0, d0_.id_doc AS id_doc_1, d0_.doc_code AS doc_code_2 FROM agendaitem_documents a1_ LEFT JOIN documents d0_ ON (d0_.id_doc = a1_.id_doc) WHERE a1_.id_event = ? AND a1_.id_agendaitem = ?
Parameters:
[ "126" "3.2" ] |
29 | 0.44 ms |
SELECT d0_.title AS title_0, d0_.id_doc AS id_doc_1, d0_.doc_code AS doc_code_2 FROM agendaitem_documents a1_ LEFT JOIN documents d0_ ON (d0_.id_doc = a1_.id_doc) WHERE a1_.id_event = ? AND a1_.id_agendaitem = ?
Parameters:
[ "126" "3.3" ] |
30 | 0.41 ms |
SELECT d0_.title AS title_0, d0_.id_doc AS id_doc_1, d0_.doc_code AS doc_code_2 FROM agendaitem_documents a1_ LEFT JOIN documents d0_ ON (d0_.id_doc = a1_.id_doc) WHERE a1_.id_event = ? AND a1_.id_agendaitem = ?
Parameters:
[ "126" "3.4" ] |
31 | 0.43 ms |
SELECT d0_.title AS title_0, d0_.id_doc AS id_doc_1, d0_.doc_code AS doc_code_2 FROM agendaitem_documents a1_ LEFT JOIN documents d0_ ON (d0_.id_doc = a1_.id_doc) WHERE a1_.id_event = ? AND a1_.id_agendaitem = ?
Parameters:
[ "126" "3.5" ] |
32 | 0.44 ms |
SELECT d0_.title AS title_0, d0_.id_doc AS id_doc_1, d0_.doc_code AS doc_code_2 FROM agendaitem_documents a1_ LEFT JOIN documents d0_ ON (d0_.id_doc = a1_.id_doc) WHERE a1_.id_event = ? AND a1_.id_agendaitem = ?
Parameters:
[ "126" "4" ] |
33 | 0.41 ms |
SELECT d0_.title AS title_0, d0_.id_doc AS id_doc_1, d0_.doc_code AS doc_code_2 FROM agendaitem_documents a1_ LEFT JOIN documents d0_ ON (d0_.id_doc = a1_.id_doc) WHERE a1_.id_event = ? AND a1_.id_agendaitem = ?
Parameters:
[ "126" "4.1" ] |
34 | 0.42 ms |
SELECT d0_.title AS title_0, d0_.id_doc AS id_doc_1, d0_.doc_code AS doc_code_2 FROM agendaitem_documents a1_ LEFT JOIN documents d0_ ON (d0_.id_doc = a1_.id_doc) WHERE a1_.id_event = ? AND a1_.id_agendaitem = ?
Parameters:
[ "126" "4.2" ] |
35 | 0.40 ms |
SELECT d0_.title AS title_0, d0_.id_doc AS id_doc_1, d0_.doc_code AS doc_code_2 FROM agendaitem_documents a1_ LEFT JOIN documents d0_ ON (d0_.id_doc = a1_.id_doc) WHERE a1_.id_event = ? AND a1_.id_agendaitem = ?
Parameters:
[ "126" "4.3" ] |
36 | 0.44 ms |
SELECT d0_.title AS title_0, d0_.id_doc AS id_doc_1, d0_.doc_code AS doc_code_2 FROM agendaitem_documents a1_ LEFT JOIN documents d0_ ON (d0_.id_doc = a1_.id_doc) WHERE a1_.id_event = ? AND a1_.id_agendaitem = ?
Parameters:
[ "126" "4.4" ] |
37 | 0.44 ms |
SELECT d0_.title AS title_0, d0_.id_doc AS id_doc_1, d0_.doc_code AS doc_code_2 FROM agendaitem_documents a1_ LEFT JOIN documents d0_ ON (d0_.id_doc = a1_.id_doc) WHERE a1_.id_event = ? AND a1_.id_agendaitem = ?
Parameters:
[ "126" "5" ] |
38 | 0.44 ms |
SELECT d0_.title AS title_0, d0_.id_doc AS id_doc_1, d0_.doc_code AS doc_code_2 FROM agendaitem_documents a1_ LEFT JOIN documents d0_ ON (d0_.id_doc = a1_.id_doc) WHERE a1_.id_event = ? AND a1_.id_agendaitem = ?
Parameters:
[ "126" "5.1" ] |
39 | 0.45 ms |
SELECT d0_.title AS title_0, d0_.id_doc AS id_doc_1, d0_.doc_code AS doc_code_2 FROM agendaitem_documents a1_ LEFT JOIN documents d0_ ON (d0_.id_doc = a1_.id_doc) WHERE a1_.id_event = ? AND a1_.id_agendaitem = ?
Parameters:
[ "126" "5.2" ] |
40 | 0.43 ms |
SELECT d0_.title AS title_0, d0_.id_doc AS id_doc_1, d0_.doc_code AS doc_code_2 FROM agendaitem_documents a1_ LEFT JOIN documents d0_ ON (d0_.id_doc = a1_.id_doc) WHERE a1_.id_event = ? AND a1_.id_agendaitem = ?
Parameters:
[ "126" "5.3" ] |
41 | 0.44 ms |
SELECT d0_.title AS title_0, d0_.id_doc AS id_doc_1, d0_.doc_code AS doc_code_2 FROM agendaitem_documents a1_ LEFT JOIN documents d0_ ON (d0_.id_doc = a1_.id_doc) WHERE a1_.id_event = ? AND a1_.id_agendaitem = ?
Parameters:
[ "126" "5.4" ] |
42 | 0.46 ms |
SELECT d0_.title AS title_0, d0_.id_doc AS id_doc_1, d0_.doc_code AS doc_code_2 FROM agendaitem_documents a1_ LEFT JOIN documents d0_ ON (d0_.id_doc = a1_.id_doc) WHERE a1_.id_event = ? AND a1_.id_agendaitem = ?
Parameters:
[ "126" "5.5" ] |
43 | 0.44 ms |
SELECT d0_.title AS title_0, d0_.id_doc AS id_doc_1, d0_.doc_code AS doc_code_2 FROM agendaitem_documents a1_ LEFT JOIN documents d0_ ON (d0_.id_doc = a1_.id_doc) WHERE a1_.id_event = ? AND a1_.id_agendaitem = ?
Parameters:
[ "126" "5.6" ] |
44 | 0.47 ms |
SELECT d0_.title AS title_0, d0_.id_doc AS id_doc_1, d0_.doc_code AS doc_code_2 FROM agendaitem_documents a1_ LEFT JOIN documents d0_ ON (d0_.id_doc = a1_.id_doc) WHERE a1_.id_event = ? AND a1_.id_agendaitem = ?
Parameters:
[ "126" "5.7" ] |
45 | 0.41 ms |
SELECT d0_.title AS title_0, d0_.id_doc AS id_doc_1, d0_.doc_code AS doc_code_2 FROM agendaitem_documents a1_ LEFT JOIN documents d0_ ON (d0_.id_doc = a1_.id_doc) WHERE a1_.id_event = ? AND a1_.id_agendaitem = ?
Parameters:
[ "126" "5.8" ] |
46 | 0.38 ms |
SELECT d0_.title AS title_0, d0_.id_doc AS id_doc_1, d0_.doc_code AS doc_code_2 FROM agendaitem_documents a1_ LEFT JOIN documents d0_ ON (d0_.id_doc = a1_.id_doc) WHERE a1_.id_event = ? AND a1_.id_agendaitem = ?
Parameters:
[ "126" "6" ] |
47 | 0.45 ms |
SELECT d0_.title AS title_0, d0_.id_doc AS id_doc_1, d0_.doc_code AS doc_code_2 FROM agendaitem_documents a1_ LEFT JOIN documents d0_ ON (d0_.id_doc = a1_.id_doc) WHERE a1_.id_event = ? AND a1_.id_agendaitem = ?
Parameters:
[ "126" "6.1" ] |
48 | 0.43 ms |
SELECT d0_.title AS title_0, d0_.id_doc AS id_doc_1, d0_.doc_code AS doc_code_2 FROM agendaitem_documents a1_ LEFT JOIN documents d0_ ON (d0_.id_doc = a1_.id_doc) WHERE a1_.id_event = ? AND a1_.id_agendaitem = ?
Parameters:
[ "126" "6.2" ] |
49 | 0.43 ms |
SELECT d0_.title AS title_0, d0_.id_doc AS id_doc_1, d0_.doc_code AS doc_code_2 FROM agendaitem_documents a1_ LEFT JOIN documents d0_ ON (d0_.id_doc = a1_.id_doc) WHERE a1_.id_event = ? AND a1_.id_agendaitem = ?
Parameters:
[ "126" "6.3" ] |
50 | 0.44 ms |
SELECT d0_.title AS title_0, d0_.id_doc AS id_doc_1, d0_.doc_code AS doc_code_2 FROM agendaitem_documents a1_ LEFT JOIN documents d0_ ON (d0_.id_doc = a1_.id_doc) WHERE a1_.id_event = ? AND a1_.id_agendaitem = ?
Parameters:
[ "126" "6.4" ] |
51 | 0.47 ms |
SELECT d0_.title AS title_0, d0_.id_doc AS id_doc_1, d0_.doc_code AS doc_code_2 FROM agendaitem_documents a1_ LEFT JOIN documents d0_ ON (d0_.id_doc = a1_.id_doc) WHERE a1_.id_event = ? AND a1_.id_agendaitem = ?
Parameters:
[ "126" "6.5" ] |
52 | 0.44 ms |
SELECT d0_.title AS title_0, d0_.id_doc AS id_doc_1, d0_.doc_code AS doc_code_2 FROM agendaitem_documents a1_ LEFT JOIN documents d0_ ON (d0_.id_doc = a1_.id_doc) WHERE a1_.id_event = ? AND a1_.id_agendaitem = ?
Parameters:
[ "126" "6.6" ] |
53 | 0.46 ms |
SELECT d0_.title AS title_0, d0_.id_doc AS id_doc_1, d0_.doc_code AS doc_code_2 FROM agendaitem_documents a1_ LEFT JOIN documents d0_ ON (d0_.id_doc = a1_.id_doc) WHERE a1_.id_event = ? AND a1_.id_agendaitem = ?
Parameters:
[ "126" "7" ] |
54 | 0.43 ms |
SELECT d0_.title AS title_0, d0_.id_doc AS id_doc_1, d0_.doc_code AS doc_code_2 FROM agendaitem_documents a1_ LEFT JOIN documents d0_ ON (d0_.id_doc = a1_.id_doc) WHERE a1_.id_event = ? AND a1_.id_agendaitem = ?
Parameters:
[ "126" "7.1" ] |
55 | 0.43 ms |
SELECT d0_.title AS title_0, d0_.id_doc AS id_doc_1, d0_.doc_code AS doc_code_2 FROM agendaitem_documents a1_ LEFT JOIN documents d0_ ON (d0_.id_doc = a1_.id_doc) WHERE a1_.id_event = ? AND a1_.id_agendaitem = ?
Parameters:
[ "126" "7.2" ] |
56 | 0.46 ms |
SELECT d0_.title AS title_0, d0_.id_doc AS id_doc_1, d0_.doc_code AS doc_code_2 FROM agendaitem_documents a1_ LEFT JOIN documents d0_ ON (d0_.id_doc = a1_.id_doc) WHERE a1_.id_event = ? AND a1_.id_agendaitem = ?
Parameters:
[ "126" "7.3" ] |
57 | 0.45 ms |
SELECT d0_.title AS title_0, d0_.id_doc AS id_doc_1, d0_.doc_code AS doc_code_2 FROM agendaitem_documents a1_ LEFT JOIN documents d0_ ON (d0_.id_doc = a1_.id_doc) WHERE a1_.id_event = ? AND a1_.id_agendaitem = ?
Parameters:
[ "126" "7.4" ] |
58 | 0.44 ms |
SELECT d0_.title AS title_0, d0_.id_doc AS id_doc_1, d0_.doc_code AS doc_code_2 FROM agendaitem_documents a1_ LEFT JOIN documents d0_ ON (d0_.id_doc = a1_.id_doc) WHERE a1_.id_event = ? AND a1_.id_agendaitem = ?
Parameters:
[ "126" "8" ] |
59 | 0.45 ms |
SELECT d0_.title AS title_0, d0_.id_doc AS id_doc_1, d0_.doc_code AS doc_code_2 FROM agendaitem_documents a1_ LEFT JOIN documents d0_ ON (d0_.id_doc = a1_.id_doc) WHERE a1_.id_event = ? AND a1_.id_agendaitem = ?
Parameters:
[ "126" "8.1" ] |
60 | 0.48 ms |
SELECT d0_.title AS title_0, d0_.id_doc AS id_doc_1, d0_.doc_code AS doc_code_2 FROM agendaitem_documents a1_ LEFT JOIN documents d0_ ON (d0_.id_doc = a1_.id_doc) WHERE a1_.id_event = ? AND a1_.id_agendaitem = ?
Parameters:
[ "126" "8.2" ] |
61 | 0.43 ms |
SELECT d0_.title AS title_0, d0_.id_doc AS id_doc_1, d0_.doc_code AS doc_code_2 FROM agendaitem_documents a1_ LEFT JOIN documents d0_ ON (d0_.id_doc = a1_.id_doc) WHERE a1_.id_event = ? AND a1_.id_agendaitem = ?
Parameters:
[ "126" "8.3" ] |
62 | 0.47 ms |
SELECT d0_.title AS title_0, d0_.id_doc AS id_doc_1, d0_.doc_code AS doc_code_2 FROM agendaitem_documents a1_ LEFT JOIN documents d0_ ON (d0_.id_doc = a1_.id_doc) WHERE a1_.id_event = ? AND a1_.id_agendaitem = ?
Parameters:
[ "126" "8.4" ] |
63 | 0.55 ms |
SELECT d0_.title AS title_0, d0_.id_doc AS id_doc_1, d0_.doc_code AS doc_code_2 FROM agendaitem_documents a1_ LEFT JOIN documents d0_ ON (d0_.id_doc = a1_.id_doc) WHERE a1_.id_event = ? AND a1_.id_agendaitem = ?
Parameters:
[ "126" "8.5" ] |
64 | 0.46 ms |
SELECT d0_.title AS title_0, d0_.id_doc AS id_doc_1, d0_.doc_code AS doc_code_2 FROM agendaitem_documents a1_ LEFT JOIN documents d0_ ON (d0_.id_doc = a1_.id_doc) WHERE a1_.id_event = ? AND a1_.id_agendaitem = ?
Parameters:
[ "126" "8.6" ] |
65 | 0.46 ms |
SELECT d0_.title AS title_0, d0_.id_doc AS id_doc_1, d0_.doc_code AS doc_code_2 FROM agendaitem_documents a1_ LEFT JOIN documents d0_ ON (d0_.id_doc = a1_.id_doc) WHERE a1_.id_event = ? AND a1_.id_agendaitem = ?
Parameters:
[ "126" "8.7" ] |
66 | 0.45 ms |
SELECT d0_.title AS title_0, d0_.id_doc AS id_doc_1, d0_.doc_code AS doc_code_2 FROM agendaitem_documents a1_ LEFT JOIN documents d0_ ON (d0_.id_doc = a1_.id_doc) WHERE a1_.id_event = ? AND a1_.id_agendaitem = ?
Parameters:
[ "126" "8.8" ] |
67 | 0.43 ms |
SELECT d0_.title AS title_0, d0_.id_doc AS id_doc_1, d0_.doc_code AS doc_code_2 FROM agendaitem_documents a1_ LEFT JOIN documents d0_ ON (d0_.id_doc = a1_.id_doc) WHERE a1_.id_event = ? AND a1_.id_agendaitem = ?
Parameters:
[ "126" "9" ] |
68 | 0.50 ms |
SELECT d0_.title AS title_0, d0_.id_doc AS id_doc_1, d0_.doc_code AS doc_code_2 FROM agendaitem_documents a1_ LEFT JOIN documents d0_ ON (d0_.id_doc = a1_.id_doc) WHERE a1_.id_event = ? AND a1_.id_agendaitem = ?
Parameters:
[ "126" "9.1" ] |
69 | 0.48 ms |
SELECT d0_.title AS title_0, d0_.id_doc AS id_doc_1, d0_.doc_code AS doc_code_2 FROM agendaitem_documents a1_ LEFT JOIN documents d0_ ON (d0_.id_doc = a1_.id_doc) WHERE a1_.id_event = ? AND a1_.id_agendaitem = ?
Parameters:
[ "126" "9.2" ] |
70 | 0.48 ms |
SELECT d0_.title AS title_0, d0_.id_doc AS id_doc_1, d0_.doc_code AS doc_code_2 FROM agendaitem_documents a1_ LEFT JOIN documents d0_ ON (d0_.id_doc = a1_.id_doc) WHERE a1_.id_event = ? AND a1_.id_agendaitem = ?
Parameters:
[ "126" "9.3" ] |
71 | 0.47 ms |
SELECT d0_.title AS title_0, d0_.id_doc AS id_doc_1, d0_.doc_code AS doc_code_2 FROM agendaitem_documents a1_ LEFT JOIN documents d0_ ON (d0_.id_doc = a1_.id_doc) WHERE a1_.id_event = ? AND a1_.id_agendaitem = ?
Parameters:
[ "126" "9.4" ] |
72 | 0.44 ms |
SELECT d0_.title AS title_0, d0_.id_doc AS id_doc_1, d0_.doc_code AS doc_code_2 FROM agendaitem_documents a1_ LEFT JOIN documents d0_ ON (d0_.id_doc = a1_.id_doc) WHERE a1_.id_event = ? AND a1_.id_agendaitem = ?
Parameters:
[ "126" "9.5" ] |
73 | 0.43 ms |
SELECT d0_.title AS title_0, d0_.id_doc AS id_doc_1, d0_.doc_code AS doc_code_2 FROM agendaitem_documents a1_ LEFT JOIN documents d0_ ON (d0_.id_doc = a1_.id_doc) WHERE a1_.id_event = ? AND a1_.id_agendaitem = ?
Parameters:
[ "126" "9.6" ] |
74 | 0.44 ms |
SELECT d0_.title AS title_0, d0_.id_doc AS id_doc_1, d0_.doc_code AS doc_code_2 FROM agendaitem_documents a1_ LEFT JOIN documents d0_ ON (d0_.id_doc = a1_.id_doc) WHERE a1_.id_event = ? AND a1_.id_agendaitem = ?
Parameters:
[ "126" "0" ] |
75 | 0.43 ms |
SELECT d0_.title AS title_0, d0_.id_doc AS id_doc_1, d0_.doc_code AS doc_code_2 FROM agendaitem_documents a1_ LEFT JOIN documents d0_ ON (d0_.id_doc = a1_.id_doc) WHERE a1_.id_event = ? AND a1_.id_agendaitem = ?
Parameters:
[ "126" "0.1" ] |
76 | 0.47 ms |
SELECT d0_.title AS title_0, d0_.id_doc AS id_doc_1, d0_.doc_code AS doc_code_2 FROM agendaitem_documents a1_ LEFT JOIN documents d0_ ON (d0_.id_doc = a1_.id_doc) WHERE a1_.id_event = ? AND a1_.id_agendaitem = ?
Parameters:
[ "126" "0.2" ] |
77 | 0.38 ms |
SELECT d0_.title AS title_0, d0_.id_doc AS id_doc_1, d0_.doc_code AS doc_code_2 FROM agendaitem_documents a1_ LEFT JOIN documents d0_ ON (d0_.id_doc = a1_.id_doc) WHERE a1_.id_event = ? AND a1_.id_agendaitem = ?
Parameters:
[ "126" "1" ] |
78 | 0.46 ms |
SELECT d0_.title AS title_0, d0_.id_doc AS id_doc_1, d0_.doc_code AS doc_code_2 FROM agendaitem_documents a1_ LEFT JOIN documents d0_ ON (d0_.id_doc = a1_.id_doc) WHERE a1_.id_event = ? AND a1_.id_agendaitem = ?
Parameters:
[ "126" "1.1" ] |
79 | 0.47 ms |
SELECT d0_.title AS title_0, d0_.id_doc AS id_doc_1, d0_.doc_code AS doc_code_2 FROM agendaitem_documents a1_ LEFT JOIN documents d0_ ON (d0_.id_doc = a1_.id_doc) WHERE a1_.id_event = ? AND a1_.id_agendaitem = ?
Parameters:
[ "126" "1.2" ] |
80 | 0.44 ms |
SELECT d0_.title AS title_0, d0_.id_doc AS id_doc_1, d0_.doc_code AS doc_code_2 FROM agendaitem_documents a1_ LEFT JOIN documents d0_ ON (d0_.id_doc = a1_.id_doc) WHERE a1_.id_event = ? AND a1_.id_agendaitem = ?
Parameters:
[ "126" "1.3" ] |
81 | 0.44 ms |
SELECT d0_.title AS title_0, d0_.id_doc AS id_doc_1, d0_.doc_code AS doc_code_2 FROM agendaitem_documents a1_ LEFT JOIN documents d0_ ON (d0_.id_doc = a1_.id_doc) WHERE a1_.id_event = ? AND a1_.id_agendaitem = ?
Parameters:
[ "126" "1.4" ] |
82 | 0.41 ms |
SELECT d0_.title AS title_0, d0_.id_doc AS id_doc_1, d0_.doc_code AS doc_code_2 FROM agendaitem_documents a1_ LEFT JOIN documents d0_ ON (d0_.id_doc = a1_.id_doc) WHERE a1_.id_event = ? AND a1_.id_agendaitem = ?
Parameters:
[ "126" "1.5" ] |
83 | 0.43 ms |
SELECT d0_.title AS title_0, d0_.id_doc AS id_doc_1, d0_.doc_code AS doc_code_2 FROM agendaitem_documents a1_ LEFT JOIN documents d0_ ON (d0_.id_doc = a1_.id_doc) WHERE a1_.id_event = ? AND a1_.id_agendaitem = ?
Parameters:
[ "126" "1.6" ] |
84 | 0.43 ms |
SELECT d0_.title AS title_0, d0_.id_doc AS id_doc_1, d0_.doc_code AS doc_code_2 FROM agendaitem_documents a1_ LEFT JOIN documents d0_ ON (d0_.id_doc = a1_.id_doc) WHERE a1_.id_event = ? AND a1_.id_agendaitem = ?
Parameters:
[ "126" "10" ] |
85 | 0.42 ms |
SELECT d0_.title AS title_0, d0_.id_doc AS id_doc_1, d0_.doc_code AS doc_code_2 FROM agendaitem_documents a1_ LEFT JOIN documents d0_ ON (d0_.id_doc = a1_.id_doc) WHERE a1_.id_event = ? AND a1_.id_agendaitem = ?
Parameters:
[ "126" "10.1" ] |
86 | 0.43 ms |
SELECT d0_.title AS title_0, d0_.id_doc AS id_doc_1, d0_.doc_code AS doc_code_2 FROM agendaitem_documents a1_ LEFT JOIN documents d0_ ON (d0_.id_doc = a1_.id_doc) WHERE a1_.id_event = ? AND a1_.id_agendaitem = ?
Parameters:
[ "126" "10.10" ] |
87 | 0.43 ms |
SELECT d0_.title AS title_0, d0_.id_doc AS id_doc_1, d0_.doc_code AS doc_code_2 FROM agendaitem_documents a1_ LEFT JOIN documents d0_ ON (d0_.id_doc = a1_.id_doc) WHERE a1_.id_event = ? AND a1_.id_agendaitem = ?
Parameters:
[ "126" "10.11" ] |
88 | 0.41 ms |
SELECT d0_.title AS title_0, d0_.id_doc AS id_doc_1, d0_.doc_code AS doc_code_2 FROM agendaitem_documents a1_ LEFT JOIN documents d0_ ON (d0_.id_doc = a1_.id_doc) WHERE a1_.id_event = ? AND a1_.id_agendaitem = ?
Parameters:
[ "126" "10.12" ] |
89 | 0.39 ms |
SELECT d0_.title AS title_0, d0_.id_doc AS id_doc_1, d0_.doc_code AS doc_code_2 FROM agendaitem_documents a1_ LEFT JOIN documents d0_ ON (d0_.id_doc = a1_.id_doc) WHERE a1_.id_event = ? AND a1_.id_agendaitem = ?
Parameters:
[ "126" "10.13" ] |
90 | 0.68 ms |
SELECT a0_.id_agendaitem AS id_agendaitem_0, d1_.doc_code AS doc_code_1, d1_.title AS title_2, d1_.id_doc AS id_doc_3, d1_.author_text AS author_text_4, d1_.updated_at AS updated_at_5 FROM agendaitem_documents a0_ LEFT JOIN documents d1_ ON (d1_.id_doc = a0_.id_doc) WHERE a0_.id_event = ? ORDER BY a0_.id_agendaitem ASC
Parameters:
[
"126"
]
|
91 | 0.79 ms |
SELECT e0_.id_agendaitem AS id_agendaitem_0, d1_.doc_code AS doc_code_1, d1_.title AS title_2, d1_.id_doc AS id_doc_3, d1_.author_text AS author_text_4, d1_.updated_at AS updated_at_5 FROM event_presentations e0_ LEFT JOIN documents d1_ ON (d1_.id_doc = e0_.id_doc) WHERE e0_.id_event = ? ORDER BY e0_.id_agendaitem ASC
Parameters:
[
"126"
]
|
92 | 0.60 ms |
SELECT d0_.doc_code AS doc_code_0, d0_.title AS title_1, d0_.id_doc AS id_doc_2, d0_.author_text AS author_text_3, d0_.updated_at AS updated_at_4, e1_.id_agendaitem AS id_agendaitem_5 FROM event_backgrounddocs e1_ LEFT JOIN documents d0_ ON (d0_.id_doc = e1_.id_doc) WHERE e1_.id_event = ? ORDER BY e1_.id_agendaitem ASC
Parameters:
[
126
]
|
93 | 0.56 ms |
SELECT d0_.doc_code AS doc_code_0, d0_.title AS title_1, d0_.id_doc AS id_doc_2, d0_.author_text AS author_text_3, d0_.updated_at AS updated_at_4 FROM event_otherdocs e1_ LEFT JOIN documents d0_ ON (d0_.id_doc = e1_.id_doc) WHERE e1_.id_event = ? ORDER BY e1_.ordering ASC
Parameters:
[
"126"
]
|
94 | 0.51 ms |
SELECT d0_.doc_code AS doc_code_0, d0_.title AS title_1, d0_.id_doc AS id_doc_2, d0_.author_text AS author_text_3, d0_.updated_at AS updated_at_4 FROM event_reports e1_ LEFT JOIN documents d0_ ON (d0_.id_doc = e1_.id_doc) WHERE e1_.id_event = ?
Parameters:
[
"126"
]
|
95 | 2.06 ms |
SELECT e0_.id_role AS id_role_0, e0_.id_ind AS id_ind_1, i1_.id_ind AS id_ind_2, i1_.title AS title_3, i1_.fname AS fname_4, i1_.sname AS sname_5, i1_.tel AS tel_6, e2_.role AS role_7, i1_.use_inst_addr AS use_inst_addr_8, c3_.country AS country_9, e2_.role AS role_10, e2_.ordering AS ordering_11, e0_.status AS status_12, e0_.accommodation AS accommodation_13, i1_.tel AS tel_14 FROM event_participants e0_ LEFT JOIN indiv i1_ ON (i1_.id_ind = e0_.id_ind) LEFT JOIN countries c3_ ON (c3_.id_country = i1_.country_code) LEFT JOIN event_participantroles e2_ ON (e0_.id_role = e2_.id_role AND e0_.id_event = e2_.id_event) WHERE e0_.id_event = ? ORDER BY e2_.ordering ASC, i1_.sname ASC
Parameters:
[
"126"
]
|
96 | 0.64 ms |
SELECT c0_.country AS country_0 FROM countries c0_ LEFT JOIN institutions i1_ ON (c0_.id_country = i1_.country_code) LEFT JOIN indiv_institution i2_ ON (i2_.id_inst = i1_.id_inst) WHERE i2_.id_ind = ?
Parameters:
[
12551
]
|
97 | 0.48 ms |
SELECT c0_.country AS country_0 FROM countries c0_ LEFT JOIN institutions i1_ ON (c0_.id_country = i1_.country_code) LEFT JOIN indiv_institution i2_ ON (i2_.id_inst = i1_.id_inst) WHERE i2_.id_ind = ?
Parameters:
[
5478
]
|
98 | 0.41 ms |
SELECT c0_.country AS country_0 FROM countries c0_ LEFT JOIN institutions i1_ ON (c0_.id_country = i1_.country_code) LEFT JOIN indiv_institution i2_ ON (i2_.id_inst = i1_.id_inst) WHERE i2_.id_ind = ?
Parameters:
[
13027
]
|
99 | 0.43 ms |
SELECT c0_.country AS country_0 FROM countries c0_ LEFT JOIN institutions i1_ ON (c0_.id_country = i1_.country_code) LEFT JOIN indiv_institution i2_ ON (i2_.id_inst = i1_.id_inst) WHERE i2_.id_ind = ?
Parameters:
[
14328
]
|
100 | 0.43 ms |
SELECT c0_.country AS country_0 FROM countries c0_ LEFT JOIN institutions i1_ ON (c0_.id_country = i1_.country_code) LEFT JOIN indiv_institution i2_ ON (i2_.id_inst = i1_.id_inst) WHERE i2_.id_ind = ?
Parameters:
[
14286
]
|
101 | 0.40 ms |
SELECT c0_.country AS country_0 FROM countries c0_ LEFT JOIN institutions i1_ ON (c0_.id_country = i1_.country_code) LEFT JOIN indiv_institution i2_ ON (i2_.id_inst = i1_.id_inst) WHERE i2_.id_ind = ?
Parameters:
[
14289
]
|
102 | 0.40 ms |
SELECT c0_.country AS country_0 FROM countries c0_ LEFT JOIN institutions i1_ ON (c0_.id_country = i1_.country_code) LEFT JOIN indiv_institution i2_ ON (i2_.id_inst = i1_.id_inst) WHERE i2_.id_ind = ?
Parameters:
[
14337
]
|
103 | 0.40 ms |
SELECT c0_.country AS country_0 FROM countries c0_ LEFT JOIN institutions i1_ ON (c0_.id_country = i1_.country_code) LEFT JOIN indiv_institution i2_ ON (i2_.id_inst = i1_.id_inst) WHERE i2_.id_ind = ?
Parameters:
[
14336
]
|
104 | 0.43 ms |
SELECT c0_.country AS country_0 FROM countries c0_ LEFT JOIN institutions i1_ ON (c0_.id_country = i1_.country_code) LEFT JOIN indiv_institution i2_ ON (i2_.id_inst = i1_.id_inst) WHERE i2_.id_ind = ?
Parameters:
[
14395
]
|
105 | 0.44 ms |
SELECT c0_.country AS country_0 FROM countries c0_ LEFT JOIN institutions i1_ ON (c0_.id_country = i1_.country_code) LEFT JOIN indiv_institution i2_ ON (i2_.id_inst = i1_.id_inst) WHERE i2_.id_ind = ?
Parameters:
[
14304
]
|
106 | 0.41 ms |
SELECT c0_.country AS country_0 FROM countries c0_ LEFT JOIN institutions i1_ ON (c0_.id_country = i1_.country_code) LEFT JOIN indiv_institution i2_ ON (i2_.id_inst = i1_.id_inst) WHERE i2_.id_ind = ?
Parameters:
[
14285
]
|
107 | 0.41 ms |
SELECT c0_.country AS country_0 FROM countries c0_ LEFT JOIN institutions i1_ ON (c0_.id_country = i1_.country_code) LEFT JOIN indiv_institution i2_ ON (i2_.id_inst = i1_.id_inst) WHERE i2_.id_ind = ?
Parameters:
[
14295
]
|
108 | 0.43 ms |
SELECT c0_.country AS country_0 FROM countries c0_ LEFT JOIN institutions i1_ ON (c0_.id_country = i1_.country_code) LEFT JOIN indiv_institution i2_ ON (i2_.id_inst = i1_.id_inst) WHERE i2_.id_ind = ?
Parameters:
[
12968
]
|
109 | 0.41 ms |
SELECT c0_.country AS country_0 FROM countries c0_ LEFT JOIN institutions i1_ ON (c0_.id_country = i1_.country_code) LEFT JOIN indiv_institution i2_ ON (i2_.id_inst = i1_.id_inst) WHERE i2_.id_ind = ?
Parameters:
[
11743
]
|
110 | 0.43 ms |
SELECT c0_.country AS country_0 FROM countries c0_ LEFT JOIN institutions i1_ ON (c0_.id_country = i1_.country_code) LEFT JOIN indiv_institution i2_ ON (i2_.id_inst = i1_.id_inst) WHERE i2_.id_ind = ?
Parameters:
[
14318
]
|
111 | 0.44 ms |
SELECT c0_.country AS country_0 FROM countries c0_ LEFT JOIN institutions i1_ ON (c0_.id_country = i1_.country_code) LEFT JOIN indiv_institution i2_ ON (i2_.id_inst = i1_.id_inst) WHERE i2_.id_ind = ?
Parameters:
[
14381
]
|
112 | 0.40 ms |
SELECT c0_.country AS country_0 FROM countries c0_ LEFT JOIN institutions i1_ ON (c0_.id_country = i1_.country_code) LEFT JOIN indiv_institution i2_ ON (i2_.id_inst = i1_.id_inst) WHERE i2_.id_ind = ?
Parameters:
[
14331
]
|
113 | 0.49 ms |
SELECT c0_.country AS country_0 FROM countries c0_ LEFT JOIN institutions i1_ ON (c0_.id_country = i1_.country_code) LEFT JOIN indiv_institution i2_ ON (i2_.id_inst = i1_.id_inst) WHERE i2_.id_ind = ?
Parameters:
[
14330
]
|
114 | 0.46 ms |
SELECT c0_.country AS country_0 FROM countries c0_ LEFT JOIN institutions i1_ ON (c0_.id_country = i1_.country_code) LEFT JOIN indiv_institution i2_ ON (i2_.id_inst = i1_.id_inst) WHERE i2_.id_ind = ?
Parameters:
[
14385
]
|
115 | 0.41 ms |
SELECT c0_.country AS country_0 FROM countries c0_ LEFT JOIN institutions i1_ ON (c0_.id_country = i1_.country_code) LEFT JOIN indiv_institution i2_ ON (i2_.id_inst = i1_.id_inst) WHERE i2_.id_ind = ?
Parameters:
[
14319
]
|
116 | 0.41 ms |
SELECT c0_.country AS country_0 FROM countries c0_ LEFT JOIN institutions i1_ ON (c0_.id_country = i1_.country_code) LEFT JOIN indiv_institution i2_ ON (i2_.id_inst = i1_.id_inst) WHERE i2_.id_ind = ?
Parameters:
[
12005
]
|
117 | 0.43 ms |
SELECT c0_.country AS country_0 FROM countries c0_ LEFT JOIN institutions i1_ ON (c0_.id_country = i1_.country_code) LEFT JOIN indiv_institution i2_ ON (i2_.id_inst = i1_.id_inst) WHERE i2_.id_ind = ?
Parameters:
[
14321
]
|
118 | 0.39 ms |
SELECT c0_.country AS country_0 FROM countries c0_ LEFT JOIN institutions i1_ ON (c0_.id_country = i1_.country_code) LEFT JOIN indiv_institution i2_ ON (i2_.id_inst = i1_.id_inst) WHERE i2_.id_ind = ?
Parameters:
[
14338
]
|
119 | 0.40 ms |
SELECT c0_.country AS country_0 FROM countries c0_ LEFT JOIN institutions i1_ ON (c0_.id_country = i1_.country_code) LEFT JOIN indiv_institution i2_ ON (i2_.id_inst = i1_.id_inst) WHERE i2_.id_ind = ?
Parameters:
[
14386
]
|
120 | 0.39 ms |
SELECT c0_.country AS country_0 FROM countries c0_ LEFT JOIN institutions i1_ ON (c0_.id_country = i1_.country_code) LEFT JOIN indiv_institution i2_ ON (i2_.id_inst = i1_.id_inst) WHERE i2_.id_ind = ?
Parameters:
[
14398
]
|
121 | 0.39 ms |
SELECT c0_.country AS country_0 FROM countries c0_ LEFT JOIN institutions i1_ ON (c0_.id_country = i1_.country_code) LEFT JOIN indiv_institution i2_ ON (i2_.id_inst = i1_.id_inst) WHERE i2_.id_ind = ?
Parameters:
[
13265
]
|
122 | 0.39 ms |
SELECT c0_.country AS country_0 FROM countries c0_ LEFT JOIN institutions i1_ ON (c0_.id_country = i1_.country_code) LEFT JOIN indiv_institution i2_ ON (i2_.id_inst = i1_.id_inst) WHERE i2_.id_ind = ?
Parameters:
[
14384
]
|
123 | 0.41 ms |
SELECT c0_.country AS country_0 FROM countries c0_ LEFT JOIN institutions i1_ ON (c0_.id_country = i1_.country_code) LEFT JOIN indiv_institution i2_ ON (i2_.id_inst = i1_.id_inst) WHERE i2_.id_ind = ?
Parameters:
[
14326
]
|
124 | 0.39 ms |
SELECT c0_.country AS country_0 FROM countries c0_ LEFT JOIN institutions i1_ ON (c0_.id_country = i1_.country_code) LEFT JOIN indiv_institution i2_ ON (i2_.id_inst = i1_.id_inst) WHERE i2_.id_ind = ?
Parameters:
[
12929
]
|
125 | 0.44 ms |
SELECT c0_.country AS country_0 FROM countries c0_ LEFT JOIN institutions i1_ ON (c0_.id_country = i1_.country_code) LEFT JOIN indiv_institution i2_ ON (i2_.id_inst = i1_.id_inst) WHERE i2_.id_ind = ?
Parameters:
[
14390
]
|
126 | 0.42 ms |
SELECT c0_.country AS country_0 FROM countries c0_ LEFT JOIN institutions i1_ ON (c0_.id_country = i1_.country_code) LEFT JOIN indiv_institution i2_ ON (i2_.id_inst = i1_.id_inst) WHERE i2_.id_ind = ?
Parameters:
[
14394
]
|
127 | 0.40 ms |
SELECT c0_.country AS country_0 FROM countries c0_ LEFT JOIN institutions i1_ ON (c0_.id_country = i1_.country_code) LEFT JOIN indiv_institution i2_ ON (i2_.id_inst = i1_.id_inst) WHERE i2_.id_ind = ?
Parameters:
[
14391
]
|
128 | 0.40 ms |
SELECT c0_.country AS country_0 FROM countries c0_ LEFT JOIN institutions i1_ ON (c0_.id_country = i1_.country_code) LEFT JOIN indiv_institution i2_ ON (i2_.id_inst = i1_.id_inst) WHERE i2_.id_ind = ?
Parameters:
[
14325
]
|
129 | 0.47 ms |
SELECT c0_.country AS country_0 FROM countries c0_ LEFT JOIN institutions i1_ ON (c0_.id_country = i1_.country_code) LEFT JOIN indiv_institution i2_ ON (i2_.id_inst = i1_.id_inst) WHERE i2_.id_ind = ?
Parameters:
[
14301
]
|
130 | 0.45 ms |
SELECT c0_.country AS country_0 FROM countries c0_ LEFT JOIN institutions i1_ ON (c0_.id_country = i1_.country_code) LEFT JOIN indiv_institution i2_ ON (i2_.id_inst = i1_.id_inst) WHERE i2_.id_ind = ?
Parameters:
[
14343
]
|
131 | 0.43 ms |
SELECT c0_.country AS country_0 FROM countries c0_ LEFT JOIN institutions i1_ ON (c0_.id_country = i1_.country_code) LEFT JOIN indiv_institution i2_ ON (i2_.id_inst = i1_.id_inst) WHERE i2_.id_ind = ?
Parameters:
[
12078
]
|
132 | 0.41 ms |
SELECT c0_.country AS country_0 FROM countries c0_ LEFT JOIN institutions i1_ ON (c0_.id_country = i1_.country_code) LEFT JOIN indiv_institution i2_ ON (i2_.id_inst = i1_.id_inst) WHERE i2_.id_ind = ?
Parameters:
[
14339
]
|
133 | 0.42 ms |
SELECT c0_.country AS country_0 FROM countries c0_ LEFT JOIN institutions i1_ ON (c0_.id_country = i1_.country_code) LEFT JOIN indiv_institution i2_ ON (i2_.id_inst = i1_.id_inst) WHERE i2_.id_ind = ?
Parameters:
[
14400
]
|
134 | 0.39 ms |
SELECT c0_.country AS country_0 FROM countries c0_ LEFT JOIN institutions i1_ ON (c0_.id_country = i1_.country_code) LEFT JOIN indiv_institution i2_ ON (i2_.id_inst = i1_.id_inst) WHERE i2_.id_ind = ?
Parameters:
[
14369
]
|
135 | 0.41 ms |
SELECT c0_.country AS country_0 FROM countries c0_ LEFT JOIN institutions i1_ ON (c0_.id_country = i1_.country_code) LEFT JOIN indiv_institution i2_ ON (i2_.id_inst = i1_.id_inst) WHERE i2_.id_ind = ?
Parameters:
[
14294
]
|
136 | 0.44 ms |
SELECT c0_.country AS country_0 FROM countries c0_ LEFT JOIN institutions i1_ ON (c0_.id_country = i1_.country_code) LEFT JOIN indiv_institution i2_ ON (i2_.id_inst = i1_.id_inst) WHERE i2_.id_ind = ?
Parameters:
[
14387
]
|
137 | 0.40 ms |
SELECT c0_.country AS country_0 FROM countries c0_ LEFT JOIN institutions i1_ ON (c0_.id_country = i1_.country_code) LEFT JOIN indiv_institution i2_ ON (i2_.id_inst = i1_.id_inst) WHERE i2_.id_ind = ?
Parameters:
[
14352
]
|
138 | 0.44 ms |
SELECT c0_.country AS country_0 FROM countries c0_ LEFT JOIN institutions i1_ ON (c0_.id_country = i1_.country_code) LEFT JOIN indiv_institution i2_ ON (i2_.id_inst = i1_.id_inst) WHERE i2_.id_ind = ?
Parameters:
[
14375
]
|
139 | 0.41 ms |
SELECT c0_.country AS country_0 FROM countries c0_ LEFT JOIN institutions i1_ ON (c0_.id_country = i1_.country_code) LEFT JOIN indiv_institution i2_ ON (i2_.id_inst = i1_.id_inst) WHERE i2_.id_ind = ?
Parameters:
[
14350
]
|
140 | 0.42 ms |
SELECT c0_.country AS country_0 FROM countries c0_ LEFT JOIN institutions i1_ ON (c0_.id_country = i1_.country_code) LEFT JOIN indiv_institution i2_ ON (i2_.id_inst = i1_.id_inst) WHERE i2_.id_ind = ?
Parameters:
[
14388
]
|
141 | 0.39 ms |
SELECT c0_.country AS country_0 FROM countries c0_ LEFT JOIN institutions i1_ ON (c0_.id_country = i1_.country_code) LEFT JOIN indiv_institution i2_ ON (i2_.id_inst = i1_.id_inst) WHERE i2_.id_ind = ?
Parameters:
[
14340
]
|
142 | 0.40 ms |
SELECT c0_.country AS country_0 FROM countries c0_ LEFT JOIN institutions i1_ ON (c0_.id_country = i1_.country_code) LEFT JOIN indiv_institution i2_ ON (i2_.id_inst = i1_.id_inst) WHERE i2_.id_ind = ?
Parameters:
[
14349
]
|
143 | 0.43 ms |
SELECT c0_.country AS country_0 FROM countries c0_ LEFT JOIN institutions i1_ ON (c0_.id_country = i1_.country_code) LEFT JOIN indiv_institution i2_ ON (i2_.id_inst = i1_.id_inst) WHERE i2_.id_ind = ?
Parameters:
[
14366
]
|
144 | 0.43 ms |
SELECT c0_.country AS country_0 FROM countries c0_ LEFT JOIN institutions i1_ ON (c0_.id_country = i1_.country_code) LEFT JOIN indiv_institution i2_ ON (i2_.id_inst = i1_.id_inst) WHERE i2_.id_ind = ?
Parameters:
[
14380
]
|
145 | 0.43 ms |
SELECT c0_.country AS country_0 FROM countries c0_ LEFT JOIN institutions i1_ ON (c0_.id_country = i1_.country_code) LEFT JOIN indiv_institution i2_ ON (i2_.id_inst = i1_.id_inst) WHERE i2_.id_ind = ?
Parameters:
[
14344
]
|
146 | 0.42 ms |
SELECT c0_.country AS country_0 FROM countries c0_ LEFT JOIN institutions i1_ ON (c0_.id_country = i1_.country_code) LEFT JOIN indiv_institution i2_ ON (i2_.id_inst = i1_.id_inst) WHERE i2_.id_ind = ?
Parameters:
[
14355
]
|
147 | 0.41 ms |
SELECT c0_.country AS country_0 FROM countries c0_ LEFT JOIN institutions i1_ ON (c0_.id_country = i1_.country_code) LEFT JOIN indiv_institution i2_ ON (i2_.id_inst = i1_.id_inst) WHERE i2_.id_ind = ?
Parameters:
[
14290
]
|
148 | 0.46 ms |
SELECT c0_.country AS country_0 FROM countries c0_ LEFT JOIN institutions i1_ ON (c0_.id_country = i1_.country_code) LEFT JOIN indiv_institution i2_ ON (i2_.id_inst = i1_.id_inst) WHERE i2_.id_ind = ?
Parameters:
[
14393
]
|
149 | 0.46 ms |
SELECT c0_.country AS country_0 FROM countries c0_ LEFT JOIN institutions i1_ ON (c0_.id_country = i1_.country_code) LEFT JOIN indiv_institution i2_ ON (i2_.id_inst = i1_.id_inst) WHERE i2_.id_ind = ?
Parameters:
[
14341
]
|
150 | 0.44 ms |
SELECT c0_.country AS country_0 FROM countries c0_ LEFT JOIN institutions i1_ ON (c0_.id_country = i1_.country_code) LEFT JOIN indiv_institution i2_ ON (i2_.id_inst = i1_.id_inst) WHERE i2_.id_ind = ?
Parameters:
[
14358
]
|
151 | 0.42 ms |
SELECT c0_.country AS country_0 FROM countries c0_ LEFT JOIN institutions i1_ ON (c0_.id_country = i1_.country_code) LEFT JOIN indiv_institution i2_ ON (i2_.id_inst = i1_.id_inst) WHERE i2_.id_ind = ?
Parameters:
[
14351
]
|
152 | 0.66 ms |
SELECT c0_.country AS country_0 FROM countries c0_ LEFT JOIN institutions i1_ ON (c0_.id_country = i1_.country_code) LEFT JOIN indiv_institution i2_ ON (i2_.id_inst = i1_.id_inst) WHERE i2_.id_ind = ?
Parameters:
[
14361
]
|
153 | 0.42 ms |
SELECT c0_.country AS country_0 FROM countries c0_ LEFT JOIN institutions i1_ ON (c0_.id_country = i1_.country_code) LEFT JOIN indiv_institution i2_ ON (i2_.id_inst = i1_.id_inst) WHERE i2_.id_ind = ?
Parameters:
[
14378
]
|
154 | 0.42 ms |
SELECT c0_.country AS country_0 FROM countries c0_ LEFT JOIN institutions i1_ ON (c0_.id_country = i1_.country_code) LEFT JOIN indiv_institution i2_ ON (i2_.id_inst = i1_.id_inst) WHERE i2_.id_ind = ?
Parameters:
[
8923
]
|
155 | 0.45 ms |
SELECT e0_.role AS role_0, e0_.id_role AS id_role_1, e0_.ppt_ordering AS ppt_ordering_2 FROM event_participantroles e0_ WHERE e0_.id_event = ? ORDER BY e0_.ordering ASC
Parameters:
[
"126"
]
|
156 | 0.75 ms |
SELECT e0_.id_role AS id_role_0, e0_.id_ind AS id_ind_1, i1_.id_ind AS id_ind_2, i1_.title AS title_3, i1_.fname AS fname_4, i1_.sname AS sname_5, i1_.use_inst_addr AS use_inst_addr_6, i1_.tel AS tel_7, e2_.role AS role_8, c3_.country AS country_9, e2_.role AS role_10, e2_.ordering AS ordering_11, e0_.status AS status_12, e0_.accommodation AS accommodation_13, i1_.tel AS tel_14 FROM event_participants e0_ LEFT JOIN indiv i1_ ON (i1_.id_ind = e0_.id_ind) LEFT JOIN indiv_institution i4_ ON (i4_.id_ind = i1_.id_ind) LEFT JOIN institutions i5_ ON (i5_.id_inst = i4_.id_inst) LEFT JOIN countries c3_ ON (c3_.id_country = i1_.country_code) LEFT JOIN event_participantroles e2_ ON (e0_.id_role = e2_.id_role AND e0_.id_event = e2_.id_event) WHERE e0_.id_event = ? AND e0_.id_role = ? ORDER BY i1_.sname ASC
Parameters:
[ "126" 7 ] |
157 | 0.90 ms |
SELECT e0_.id_role AS id_role_0, e0_.id_ind AS id_ind_1, i1_.id_ind AS id_ind_2, i1_.title AS title_3, i1_.fname AS fname_4, i1_.sname AS sname_5, i1_.use_inst_addr AS use_inst_addr_6, i1_.tel AS tel_7, e2_.role AS role_8, c3_.country AS country_9, e2_.role AS role_10, e2_.ordering AS ordering_11, e0_.status AS status_12, e0_.accommodation AS accommodation_13, i1_.tel AS tel_14 FROM event_participants e0_ LEFT JOIN indiv i1_ ON (i1_.id_ind = e0_.id_ind) LEFT JOIN indiv_institution i4_ ON (i4_.id_ind = i1_.id_ind) LEFT JOIN institutions i5_ ON (i5_.id_inst = i4_.id_inst) LEFT JOIN countries c3_ ON (c3_.id_country = i1_.country_code) LEFT JOIN event_participantroles e2_ ON (e0_.id_role = e2_.id_role AND e0_.id_event = e2_.id_event) WHERE e0_.id_event = ? AND e0_.id_role = ? ORDER BY i1_.sname ASC
Parameters:
[ "126" 2 ] |
158 | 0.43 ms |
SELECT c0_.country AS country_0 FROM countries c0_ LEFT JOIN institutions i1_ ON (c0_.id_country = i1_.country_code) LEFT JOIN indiv_institution i2_ ON (i2_.id_inst = i1_.id_inst) WHERE i2_.id_ind = ?
Parameters:
[
12551
]
|
159 | 0.45 ms |
SELECT c0_.country AS country_0 FROM countries c0_ LEFT JOIN institutions i1_ ON (c0_.id_country = i1_.country_code) LEFT JOIN indiv_institution i2_ ON (i2_.id_inst = i1_.id_inst) WHERE i2_.id_ind = ?
Parameters:
[
5478
]
|
160 | 0.41 ms |
SELECT c0_.country AS country_0 FROM countries c0_ LEFT JOIN institutions i1_ ON (c0_.id_country = i1_.country_code) LEFT JOIN indiv_institution i2_ ON (i2_.id_inst = i1_.id_inst) WHERE i2_.id_ind = ?
Parameters:
[
13027
]
|
161 | 0.89 ms |
SELECT e0_.id_role AS id_role_0, e0_.id_ind AS id_ind_1, i1_.id_ind AS id_ind_2, i1_.title AS title_3, i1_.fname AS fname_4, i1_.sname AS sname_5, i1_.use_inst_addr AS use_inst_addr_6, i1_.tel AS tel_7, e2_.role AS role_8, c3_.country AS country_9, e2_.role AS role_10, e2_.ordering AS ordering_11, e0_.status AS status_12, e0_.accommodation AS accommodation_13, i1_.tel AS tel_14 FROM event_participants e0_ LEFT JOIN indiv i1_ ON (i1_.id_ind = e0_.id_ind) LEFT JOIN indiv_institution i4_ ON (i4_.id_ind = i1_.id_ind) LEFT JOIN institutions i5_ ON (i5_.id_inst = i4_.id_inst) LEFT JOIN countries c3_ ON (c3_.id_country = i1_.country_code) LEFT JOIN event_participantroles e2_ ON (e0_.id_role = e2_.id_role AND e0_.id_event = e2_.id_event) WHERE e0_.id_event = ? AND e0_.id_role = ? ORDER BY i1_.sname ASC
Parameters:
[ "126" 3 ] |
162 | 0.45 ms |
SELECT c0_.country AS country_0 FROM countries c0_ LEFT JOIN institutions i1_ ON (c0_.id_country = i1_.country_code) LEFT JOIN indiv_institution i2_ ON (i2_.id_inst = i1_.id_inst) WHERE i2_.id_ind = ?
Parameters:
[
14328
]
|
163 | 0.43 ms |
SELECT c0_.country AS country_0 FROM countries c0_ LEFT JOIN institutions i1_ ON (c0_.id_country = i1_.country_code) LEFT JOIN indiv_institution i2_ ON (i2_.id_inst = i1_.id_inst) WHERE i2_.id_ind = ?
Parameters:
[
14286
]
|
164 | 0.45 ms |
SELECT c0_.country AS country_0 FROM countries c0_ LEFT JOIN institutions i1_ ON (c0_.id_country = i1_.country_code) LEFT JOIN indiv_institution i2_ ON (i2_.id_inst = i1_.id_inst) WHERE i2_.id_ind = ?
Parameters:
[
14289
]
|
165 | 0.43 ms |
SELECT c0_.country AS country_0 FROM countries c0_ LEFT JOIN institutions i1_ ON (c0_.id_country = i1_.country_code) LEFT JOIN indiv_institution i2_ ON (i2_.id_inst = i1_.id_inst) WHERE i2_.id_ind = ?
Parameters:
[
14337
]
|
166 | 2.42 ms |
SELECT e0_.id_role AS id_role_0, e0_.id_ind AS id_ind_1, i1_.id_ind AS id_ind_2, i1_.title AS title_3, i1_.fname AS fname_4, i1_.sname AS sname_5, i1_.use_inst_addr AS use_inst_addr_6, i1_.tel AS tel_7, e2_.role AS role_8, c3_.country AS country_9, e2_.role AS role_10, e2_.ordering AS ordering_11, e0_.status AS status_12, e0_.accommodation AS accommodation_13, i1_.tel AS tel_14 FROM event_participants e0_ LEFT JOIN indiv i1_ ON (i1_.id_ind = e0_.id_ind) LEFT JOIN indiv_institution i4_ ON (i4_.id_ind = i1_.id_ind) LEFT JOIN institutions i5_ ON (i5_.id_inst = i4_.id_inst) LEFT JOIN countries c3_ ON (c3_.id_country = i1_.country_code) LEFT JOIN event_participantroles e2_ ON (e0_.id_role = e2_.id_role AND e0_.id_event = e2_.id_event) WHERE e0_.id_event = ? AND e0_.id_role = ? ORDER BY i1_.sname ASC
Parameters:
[ "126" 4 ] |
167 | 0.50 ms |
SELECT c0_.country AS country_0 FROM countries c0_ LEFT JOIN institutions i1_ ON (c0_.id_country = i1_.country_code) LEFT JOIN indiv_institution i2_ ON (i2_.id_inst = i1_.id_inst) WHERE i2_.id_ind = ?
Parameters:
[
14336
]
|
168 | 0.45 ms |
SELECT c0_.country AS country_0 FROM countries c0_ LEFT JOIN institutions i1_ ON (c0_.id_country = i1_.country_code) LEFT JOIN indiv_institution i2_ ON (i2_.id_inst = i1_.id_inst) WHERE i2_.id_ind = ?
Parameters:
[
14395
]
|
169 | 0.45 ms |
SELECT c0_.country AS country_0 FROM countries c0_ LEFT JOIN institutions i1_ ON (c0_.id_country = i1_.country_code) LEFT JOIN indiv_institution i2_ ON (i2_.id_inst = i1_.id_inst) WHERE i2_.id_ind = ?
Parameters:
[
14304
]
|
170 | 1.37 ms |
SELECT e0_.id_role AS id_role_0, e0_.id_ind AS id_ind_1, i1_.id_ind AS id_ind_2, i1_.title AS title_3, i1_.fname AS fname_4, i1_.sname AS sname_5, i1_.use_inst_addr AS use_inst_addr_6, i1_.tel AS tel_7, e2_.role AS role_8, c3_.country AS country_9, e2_.role AS role_10, e2_.ordering AS ordering_11, e0_.status AS status_12, e0_.accommodation AS accommodation_13, i1_.tel AS tel_14 FROM event_participants e0_ LEFT JOIN indiv i1_ ON (i1_.id_ind = e0_.id_ind) LEFT JOIN indiv_institution i4_ ON (i4_.id_ind = i1_.id_ind) LEFT JOIN institutions i5_ ON (i5_.id_inst = i4_.id_inst) LEFT JOIN countries c3_ ON (c3_.id_country = i1_.country_code) LEFT JOIN event_participantroles e2_ ON (e0_.id_role = e2_.id_role AND e0_.id_event = e2_.id_event) WHERE e0_.id_event = ? AND e0_.id_role = ? ORDER BY i1_.sname ASC
Parameters:
[ "126" 5 ] |
171 | 0.47 ms |
SELECT c0_.country AS country_0 FROM countries c0_ LEFT JOIN institutions i1_ ON (c0_.id_country = i1_.country_code) LEFT JOIN indiv_institution i2_ ON (i2_.id_inst = i1_.id_inst) WHERE i2_.id_ind = ?
Parameters:
[
14285
]
|
172 | 0.48 ms |
SELECT c0_.country AS country_0 FROM countries c0_ LEFT JOIN institutions i1_ ON (c0_.id_country = i1_.country_code) LEFT JOIN indiv_institution i2_ ON (i2_.id_inst = i1_.id_inst) WHERE i2_.id_ind = ?
Parameters:
[
14295
]
|
173 | 0.47 ms |
SELECT c0_.country AS country_0 FROM countries c0_ LEFT JOIN institutions i1_ ON (c0_.id_country = i1_.country_code) LEFT JOIN indiv_institution i2_ ON (i2_.id_inst = i1_.id_inst) WHERE i2_.id_ind = ?
Parameters:
[
12968
]
|
174 | 0.44 ms |
SELECT c0_.country AS country_0 FROM countries c0_ LEFT JOIN institutions i1_ ON (c0_.id_country = i1_.country_code) LEFT JOIN indiv_institution i2_ ON (i2_.id_inst = i1_.id_inst) WHERE i2_.id_ind = ?
Parameters:
[
11743
]
|
175 | 0.42 ms |
SELECT c0_.country AS country_0 FROM countries c0_ LEFT JOIN institutions i1_ ON (c0_.id_country = i1_.country_code) LEFT JOIN indiv_institution i2_ ON (i2_.id_inst = i1_.id_inst) WHERE i2_.id_ind = ?
Parameters:
[
14318
]
|
176 | 0.44 ms |
SELECT c0_.country AS country_0 FROM countries c0_ LEFT JOIN institutions i1_ ON (c0_.id_country = i1_.country_code) LEFT JOIN indiv_institution i2_ ON (i2_.id_inst = i1_.id_inst) WHERE i2_.id_ind = ?
Parameters:
[
14381
]
|
177 | 0.44 ms |
SELECT c0_.country AS country_0 FROM countries c0_ LEFT JOIN institutions i1_ ON (c0_.id_country = i1_.country_code) LEFT JOIN indiv_institution i2_ ON (i2_.id_inst = i1_.id_inst) WHERE i2_.id_ind = ?
Parameters:
[
14331
]
|
178 | 0.41 ms |
SELECT c0_.country AS country_0 FROM countries c0_ LEFT JOIN institutions i1_ ON (c0_.id_country = i1_.country_code) LEFT JOIN indiv_institution i2_ ON (i2_.id_inst = i1_.id_inst) WHERE i2_.id_ind = ?
Parameters:
[
14330
]
|
179 | 0.46 ms |
SELECT c0_.country AS country_0 FROM countries c0_ LEFT JOIN institutions i1_ ON (c0_.id_country = i1_.country_code) LEFT JOIN indiv_institution i2_ ON (i2_.id_inst = i1_.id_inst) WHERE i2_.id_ind = ?
Parameters:
[
14385
]
|
180 | 0.44 ms |
SELECT c0_.country AS country_0 FROM countries c0_ LEFT JOIN institutions i1_ ON (c0_.id_country = i1_.country_code) LEFT JOIN indiv_institution i2_ ON (i2_.id_inst = i1_.id_inst) WHERE i2_.id_ind = ?
Parameters:
[
14319
]
|
181 | 0.45 ms |
SELECT c0_.country AS country_0 FROM countries c0_ LEFT JOIN institutions i1_ ON (c0_.id_country = i1_.country_code) LEFT JOIN indiv_institution i2_ ON (i2_.id_inst = i1_.id_inst) WHERE i2_.id_ind = ?
Parameters:
[
12005
]
|
182 | 0.43 ms |
SELECT c0_.country AS country_0 FROM countries c0_ LEFT JOIN institutions i1_ ON (c0_.id_country = i1_.country_code) LEFT JOIN indiv_institution i2_ ON (i2_.id_inst = i1_.id_inst) WHERE i2_.id_ind = ?
Parameters:
[
14321
]
|
183 | 0.44 ms |
SELECT c0_.country AS country_0 FROM countries c0_ LEFT JOIN institutions i1_ ON (c0_.id_country = i1_.country_code) LEFT JOIN indiv_institution i2_ ON (i2_.id_inst = i1_.id_inst) WHERE i2_.id_ind = ?
Parameters:
[
14338
]
|
184 | 2.28 ms |
SELECT c0_.country AS country_0 FROM countries c0_ LEFT JOIN institutions i1_ ON (c0_.id_country = i1_.country_code) LEFT JOIN indiv_institution i2_ ON (i2_.id_inst = i1_.id_inst) WHERE i2_.id_ind = ?
Parameters:
[
14386
]
|
185 | 0.55 ms |
SELECT c0_.country AS country_0 FROM countries c0_ LEFT JOIN institutions i1_ ON (c0_.id_country = i1_.country_code) LEFT JOIN indiv_institution i2_ ON (i2_.id_inst = i1_.id_inst) WHERE i2_.id_ind = ?
Parameters:
[
14398
]
|
186 | 0.45 ms |
SELECT c0_.country AS country_0 FROM countries c0_ LEFT JOIN institutions i1_ ON (c0_.id_country = i1_.country_code) LEFT JOIN indiv_institution i2_ ON (i2_.id_inst = i1_.id_inst) WHERE i2_.id_ind = ?
Parameters:
[
13265
]
|
187 | 0.45 ms |
SELECT c0_.country AS country_0 FROM countries c0_ LEFT JOIN institutions i1_ ON (c0_.id_country = i1_.country_code) LEFT JOIN indiv_institution i2_ ON (i2_.id_inst = i1_.id_inst) WHERE i2_.id_ind = ?
Parameters:
[
14384
]
|
188 | 0.43 ms |
SELECT c0_.country AS country_0 FROM countries c0_ LEFT JOIN institutions i1_ ON (c0_.id_country = i1_.country_code) LEFT JOIN indiv_institution i2_ ON (i2_.id_inst = i1_.id_inst) WHERE i2_.id_ind = ?
Parameters:
[
14326
]
|
189 | 0.43 ms |
SELECT c0_.country AS country_0 FROM countries c0_ LEFT JOIN institutions i1_ ON (c0_.id_country = i1_.country_code) LEFT JOIN indiv_institution i2_ ON (i2_.id_inst = i1_.id_inst) WHERE i2_.id_ind = ?
Parameters:
[
12929
]
|
190 | 0.45 ms |
SELECT c0_.country AS country_0 FROM countries c0_ LEFT JOIN institutions i1_ ON (c0_.id_country = i1_.country_code) LEFT JOIN indiv_institution i2_ ON (i2_.id_inst = i1_.id_inst) WHERE i2_.id_ind = ?
Parameters:
[
14390
]
|
191 | 0.48 ms |
SELECT c0_.country AS country_0 FROM countries c0_ LEFT JOIN institutions i1_ ON (c0_.id_country = i1_.country_code) LEFT JOIN indiv_institution i2_ ON (i2_.id_inst = i1_.id_inst) WHERE i2_.id_ind = ?
Parameters:
[
14394
]
|
192 | 0.45 ms |
SELECT c0_.country AS country_0 FROM countries c0_ LEFT JOIN institutions i1_ ON (c0_.id_country = i1_.country_code) LEFT JOIN indiv_institution i2_ ON (i2_.id_inst = i1_.id_inst) WHERE i2_.id_ind = ?
Parameters:
[
14391
]
|
193 | 0.42 ms |
SELECT c0_.country AS country_0 FROM countries c0_ LEFT JOIN institutions i1_ ON (c0_.id_country = i1_.country_code) LEFT JOIN indiv_institution i2_ ON (i2_.id_inst = i1_.id_inst) WHERE i2_.id_ind = ?
Parameters:
[
14325
]
|
194 | 0.44 ms |
SELECT c0_.country AS country_0 FROM countries c0_ LEFT JOIN institutions i1_ ON (c0_.id_country = i1_.country_code) LEFT JOIN indiv_institution i2_ ON (i2_.id_inst = i1_.id_inst) WHERE i2_.id_ind = ?
Parameters:
[
14301
]
|
195 | 0.43 ms |
SELECT c0_.country AS country_0 FROM countries c0_ LEFT JOIN institutions i1_ ON (c0_.id_country = i1_.country_code) LEFT JOIN indiv_institution i2_ ON (i2_.id_inst = i1_.id_inst) WHERE i2_.id_ind = ?
Parameters:
[
14343
]
|
196 | 2.06 ms |
SELECT e0_.id_role AS id_role_0, e0_.id_ind AS id_ind_1, i1_.id_ind AS id_ind_2, i1_.title AS title_3, i1_.fname AS fname_4, i1_.sname AS sname_5, i1_.use_inst_addr AS use_inst_addr_6, i1_.tel AS tel_7, e2_.role AS role_8, c3_.country AS country_9, e2_.role AS role_10, e2_.ordering AS ordering_11, e0_.status AS status_12, e0_.accommodation AS accommodation_13, i1_.tel AS tel_14 FROM event_participants e0_ LEFT JOIN indiv i1_ ON (i1_.id_ind = e0_.id_ind) LEFT JOIN indiv_institution i4_ ON (i4_.id_ind = i1_.id_ind) LEFT JOIN institutions i5_ ON (i5_.id_inst = i4_.id_inst) LEFT JOIN countries c3_ ON (c3_.id_country = i1_.country_code) LEFT JOIN event_participantroles e2_ ON (e0_.id_role = e2_.id_role AND e0_.id_event = e2_.id_event) WHERE e0_.id_event = ? AND e0_.id_role = ? ORDER BY i1_.sname ASC
Parameters:
[ "126" 6 ] |
197 | 0.45 ms |
SELECT c0_.country AS country_0 FROM countries c0_ LEFT JOIN institutions i1_ ON (c0_.id_country = i1_.country_code) LEFT JOIN indiv_institution i2_ ON (i2_.id_inst = i1_.id_inst) WHERE i2_.id_ind = ?
Parameters:
[
12078
]
|
198 | 0.46 ms |
SELECT c0_.country AS country_0 FROM countries c0_ LEFT JOIN institutions i1_ ON (c0_.id_country = i1_.country_code) LEFT JOIN indiv_institution i2_ ON (i2_.id_inst = i1_.id_inst) WHERE i2_.id_ind = ?
Parameters:
[
14339
]
|
199 | 0.48 ms |
SELECT c0_.country AS country_0 FROM countries c0_ LEFT JOIN institutions i1_ ON (c0_.id_country = i1_.country_code) LEFT JOIN indiv_institution i2_ ON (i2_.id_inst = i1_.id_inst) WHERE i2_.id_ind = ?
Parameters:
[
14400
]
|
200 | 0.47 ms |
SELECT c0_.country AS country_0 FROM countries c0_ LEFT JOIN institutions i1_ ON (c0_.id_country = i1_.country_code) LEFT JOIN indiv_institution i2_ ON (i2_.id_inst = i1_.id_inst) WHERE i2_.id_ind = ?
Parameters:
[
14369
]
|
201 | 0.50 ms |
SELECT c0_.country AS country_0 FROM countries c0_ LEFT JOIN institutions i1_ ON (c0_.id_country = i1_.country_code) LEFT JOIN indiv_institution i2_ ON (i2_.id_inst = i1_.id_inst) WHERE i2_.id_ind = ?
Parameters:
[
14294
]
|
202 | 0.44 ms |
SELECT c0_.country AS country_0 FROM countries c0_ LEFT JOIN institutions i1_ ON (c0_.id_country = i1_.country_code) LEFT JOIN indiv_institution i2_ ON (i2_.id_inst = i1_.id_inst) WHERE i2_.id_ind = ?
Parameters:
[
14387
]
|
203 | 0.42 ms |
SELECT c0_.country AS country_0 FROM countries c0_ LEFT JOIN institutions i1_ ON (c0_.id_country = i1_.country_code) LEFT JOIN indiv_institution i2_ ON (i2_.id_inst = i1_.id_inst) WHERE i2_.id_ind = ?
Parameters:
[
14352
]
|
204 | 0.43 ms |
SELECT c0_.country AS country_0 FROM countries c0_ LEFT JOIN institutions i1_ ON (c0_.id_country = i1_.country_code) LEFT JOIN indiv_institution i2_ ON (i2_.id_inst = i1_.id_inst) WHERE i2_.id_ind = ?
Parameters:
[
14375
]
|
205 | 0.44 ms |
SELECT c0_.country AS country_0 FROM countries c0_ LEFT JOIN institutions i1_ ON (c0_.id_country = i1_.country_code) LEFT JOIN indiv_institution i2_ ON (i2_.id_inst = i1_.id_inst) WHERE i2_.id_ind = ?
Parameters:
[
14350
]
|
206 | 0.42 ms |
SELECT c0_.country AS country_0 FROM countries c0_ LEFT JOIN institutions i1_ ON (c0_.id_country = i1_.country_code) LEFT JOIN indiv_institution i2_ ON (i2_.id_inst = i1_.id_inst) WHERE i2_.id_ind = ?
Parameters:
[
14388
]
|
207 | 0.41 ms |
SELECT c0_.country AS country_0 FROM countries c0_ LEFT JOIN institutions i1_ ON (c0_.id_country = i1_.country_code) LEFT JOIN indiv_institution i2_ ON (i2_.id_inst = i1_.id_inst) WHERE i2_.id_ind = ?
Parameters:
[
14340
]
|
208 | 0.43 ms |
SELECT c0_.country AS country_0 FROM countries c0_ LEFT JOIN institutions i1_ ON (c0_.id_country = i1_.country_code) LEFT JOIN indiv_institution i2_ ON (i2_.id_inst = i1_.id_inst) WHERE i2_.id_ind = ?
Parameters:
[
14349
]
|
209 | 0.94 ms |
SELECT c0_.country AS country_0 FROM countries c0_ LEFT JOIN institutions i1_ ON (c0_.id_country = i1_.country_code) LEFT JOIN indiv_institution i2_ ON (i2_.id_inst = i1_.id_inst) WHERE i2_.id_ind = ?
Parameters:
[
14366
]
|
210 | 0.46 ms |
SELECT c0_.country AS country_0 FROM countries c0_ LEFT JOIN institutions i1_ ON (c0_.id_country = i1_.country_code) LEFT JOIN indiv_institution i2_ ON (i2_.id_inst = i1_.id_inst) WHERE i2_.id_ind = ?
Parameters:
[
14380
]
|
211 | 0.42 ms |
SELECT c0_.country AS country_0 FROM countries c0_ LEFT JOIN institutions i1_ ON (c0_.id_country = i1_.country_code) LEFT JOIN indiv_institution i2_ ON (i2_.id_inst = i1_.id_inst) WHERE i2_.id_ind = ?
Parameters:
[
14344
]
|
212 | 0.43 ms |
SELECT c0_.country AS country_0 FROM countries c0_ LEFT JOIN institutions i1_ ON (c0_.id_country = i1_.country_code) LEFT JOIN indiv_institution i2_ ON (i2_.id_inst = i1_.id_inst) WHERE i2_.id_ind = ?
Parameters:
[
14355
]
|
213 | 0.45 ms |
SELECT c0_.country AS country_0 FROM countries c0_ LEFT JOIN institutions i1_ ON (c0_.id_country = i1_.country_code) LEFT JOIN indiv_institution i2_ ON (i2_.id_inst = i1_.id_inst) WHERE i2_.id_ind = ?
Parameters:
[
14290
]
|
214 | 0.41 ms |
SELECT c0_.country AS country_0 FROM countries c0_ LEFT JOIN institutions i1_ ON (c0_.id_country = i1_.country_code) LEFT JOIN indiv_institution i2_ ON (i2_.id_inst = i1_.id_inst) WHERE i2_.id_ind = ?
Parameters:
[
14393
]
|
215 | 0.42 ms |
SELECT c0_.country AS country_0 FROM countries c0_ LEFT JOIN institutions i1_ ON (c0_.id_country = i1_.country_code) LEFT JOIN indiv_institution i2_ ON (i2_.id_inst = i1_.id_inst) WHERE i2_.id_ind = ?
Parameters:
[
14341
]
|
216 | 0.43 ms |
SELECT c0_.country AS country_0 FROM countries c0_ LEFT JOIN institutions i1_ ON (c0_.id_country = i1_.country_code) LEFT JOIN indiv_institution i2_ ON (i2_.id_inst = i1_.id_inst) WHERE i2_.id_ind = ?
Parameters:
[
14358
]
|
217 | 0.40 ms |
SELECT c0_.country AS country_0 FROM countries c0_ LEFT JOIN institutions i1_ ON (c0_.id_country = i1_.country_code) LEFT JOIN indiv_institution i2_ ON (i2_.id_inst = i1_.id_inst) WHERE i2_.id_ind = ?
Parameters:
[
14351
]
|
218 | 0.42 ms |
SELECT c0_.country AS country_0 FROM countries c0_ LEFT JOIN institutions i1_ ON (c0_.id_country = i1_.country_code) LEFT JOIN indiv_institution i2_ ON (i2_.id_inst = i1_.id_inst) WHERE i2_.id_ind = ?
Parameters:
[
14361
]
|
219 | 0.41 ms |
SELECT c0_.country AS country_0 FROM countries c0_ LEFT JOIN institutions i1_ ON (c0_.id_country = i1_.country_code) LEFT JOIN indiv_institution i2_ ON (i2_.id_inst = i1_.id_inst) WHERE i2_.id_ind = ?
Parameters:
[
14378
]
|
220 | 0.42 ms |
SELECT c0_.country AS country_0 FROM countries c0_ LEFT JOIN institutions i1_ ON (c0_.id_country = i1_.country_code) LEFT JOIN indiv_institution i2_ ON (i2_.id_inst = i1_.id_inst) WHERE i2_.id_ind = ?
Parameters:
[
8923
]
|
221 | 0.69 ms |
SELECT e0_.id_role AS id_role_0, e0_.id_ind AS id_ind_1, i1_.id_ind AS id_ind_2, i1_.title AS title_3, i1_.fname AS fname_4, i1_.sname AS sname_5, i1_.use_inst_addr AS use_inst_addr_6, i1_.tel AS tel_7, e2_.role AS role_8, c3_.country AS country_9, e2_.role AS role_10, e2_.ordering AS ordering_11, e0_.status AS status_12, e0_.accommodation AS accommodation_13, i1_.tel AS tel_14 FROM event_participants e0_ LEFT JOIN indiv i1_ ON (i1_.id_ind = e0_.id_ind) LEFT JOIN indiv_institution i4_ ON (i4_.id_ind = i1_.id_ind) LEFT JOIN institutions i5_ ON (i5_.id_inst = i4_.id_inst) LEFT JOIN countries c3_ ON (c3_.id_country = i1_.country_code) LEFT JOIN event_participantroles e2_ ON (e0_.id_role = e2_.id_role AND e0_.id_event = e2_.id_event) WHERE e0_.id_event = ? AND e0_.id_role IS NULL ORDER BY i1_.sname ASC
Parameters:
[
"126"
]
|
222 | 0.69 ms |
SELECT e0_.id_group AS id_group_0, g1_.groupname AS groupname_1 FROM event_groups e0_ LEFT JOIN groups g1_ ON (g1_.id_group = e0_.id_group) WHERE e0_.id_event = ? ORDER BY g1_.groupname ASC
Parameters:
[
"126"
]
|
223 | 0.63 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 = ? LIMIT 1
Parameters:
[
"126"
]
|
224 | 0.75 ms |
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:
[
19594
]
|
225 | 0.63 ms |
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:
[
11819
]
|
226 | 0.80 ms |
SELECT g0_.groupname AS groupname_0, e1_.id_label AS id_label_1 FROM event_labels e1_ LEFT JOIN groups g0_ ON (g0_.id_group = e1_.id_group) WHERE e1_.id_event = ? ORDER BY g0_.groupname ASC
Parameters:
[
"126"
]
|
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\Countries | No errors. |
OceanExpertBundle\Entity\EventContacts | No errors. |
OceanExpertBundle\Entity\Indiv | No errors. |
OceanExpertBundle\Entity\EventStaff | No errors. |
OceanExpertBundle\Entity\EventParticipants | No errors. |
OceanExpertBundle\Entity\EventAgendaitems | No errors. |
OceanExpertBundle\Entity\AgendaitemDocuments | No errors. |
OceanExpertBundle\Entity\Documents | No errors. |
OceanExpertBundle\Entity\EventPresentations | No errors. |
OceanExpertBundle\Entity\EventBackgrounddocs | No errors. |
OceanExpertBundle\Entity\EventOtherdocs | No errors. |
OceanExpertBundle\Entity\EventReports | No errors. |
OceanExpertBundle\Entity\EventParticipantroles | No errors. |
OceanExpertBundle\Entity\Institutions | No errors. |
OceanExpertBundle\Entity\IndivInstitution | No errors. |
OceanExpertBundle\Entity\EventGroups | No errors. |
OceanExpertBundle\Entity\Groups | No errors. |
OceanExpertBundle\Entity\EventLabels | No errors. |