GET https://teap.wab.com.br/newQuizWithPack/30

Query Metrics

85 Database Queries
7 Different statements
16.76 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 0.42 ms
SELECT t0.id AS id_1 FROM pack t0 WHERE t0.id = ?
Parameters:
[
  "30"
]
2 0.12 ms
"START TRANSACTION"
Parameters:
[]
3 0.23 ms
INSERT INTO quiz (pack_id) VALUES (?)
Parameters:
[
  30
]
4 0.08 ms
"COMMIT"
Parameters:
[]
5 0.29 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.category AS category_4, t0.pack_id AS pack_id_5 FROM term t0 WHERE t0.pack_id = ?
Parameters:
[
  30
]
6 0.07 ms
SELECT t0.id AS id_1, t0.decription AS decription_2, t0.term_id AS term_id_3 FROM term_case t0 WHERE t0.term_id = ?
Parameters:
[
  604
]
7 0.04 ms
"START TRANSACTION"
Parameters:
[]
8 0.27 ms
INSERT INTO quiz_item (is_correct, date_time, ask, term_id, quiz_id, wrong_a_id, wrong_b_id, wrong_c_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  null
  null
  "The use of artificial intelligence is increasing in medicine, <em> __________ </em> its application in legal fields remains limited."
  604
  1052
  112
  727
  809
]
9 0.05 ms
"COMMIT"
Parameters:
[]
10 0.23 ms
SELECT t0.id AS id_1, t0.decription AS decription_2, t0.term_id AS term_id_3 FROM term_case t0 WHERE t0.term_id = ?
Parameters:
[
  276
]
11 0.05 ms
"START TRANSACTION"
Parameters:
[]
12 0.18 ms
INSERT INTO quiz_item (is_correct, date_time, ask, term_id, quiz_id, wrong_a_id, wrong_b_id, wrong_c_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  null
  null
  "The experiment was designed to test causation  __________  mere correlation between the two variables."
  276
  1052
  112
  399
  768
]
13 0.05 ms
"COMMIT"
Parameters:
[]
14 0.03 ms
SELECT t0.id AS id_1, t0.decription AS decription_2, t0.term_id AS term_id_3 FROM term_case t0 WHERE t0.term_id = ?
Parameters:
[
  809
]
15 0.05 ms
"START TRANSACTION"
Parameters:
[]
16 0.16 ms
INSERT INTO quiz_item (is_correct, date_time, ask, term_id, quiz_id, wrong_a_id, wrong_b_id, wrong_c_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  null
  null
  "The research methodology was adjusted  __________  feedback from previous studies on the subject."
  809
  1052
  604
  768
  645
]
17 0.04 ms
"COMMIT"
Parameters:
[]
18 0.04 ms
SELECT t0.id AS id_1, t0.decription AS decription_2, t0.term_id AS term_id_3 FROM term_case t0 WHERE t0.term_id = ?
Parameters:
[
  153
]
19 0.03 ms
"START TRANSACTION"
Parameters:
[]
20 0.14 ms
INSERT INTO quiz_item (is_correct, date_time, ask, term_id, quiz_id, wrong_a_id, wrong_b_id, wrong_c_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  null
  null
  " __________ , he became a vegetarian."
  153
  1052
  481
  645
  399
]
21 0.04 ms
"COMMIT"
Parameters:
[]
22 0.28 ms
SELECT t0.id AS id_1, t0.decription AS decription_2, t0.term_id AS term_id_3 FROM term_case t0 WHERE t0.term_id = ?
Parameters:
[
  358
]
23 0.04 ms
"START TRANSACTION"
Parameters:
[]
24 0.17 ms
INSERT INTO quiz_item (is_correct, date_time, ask, term_id, quiz_id, wrong_a_id, wrong_b_id, wrong_c_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  null
  null
  "The study included a diverse sample  __________  the findings could be generalized to a larger population."
  358
  1052
  71
  112
  399
]
25 0.04 ms
"COMMIT"
Parameters:
[]
26 0.03 ms
SELECT t0.id AS id_1, t0.decription AS decription_2, t0.term_id AS term_id_3 FROM term_case t0 WHERE t0.term_id = ?
Parameters:
[
  71
]
27 0.03 ms
"START TRANSACTION"
Parameters:
[]
28 0.15 ms
INSERT INTO quiz_item (is_correct, date_time, ask, term_id, quiz_id, wrong_a_id, wrong_b_id, wrong_c_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  null
  null
  "<em> __________ , the conference will include several workshops on advanced technology.</em> ""
  71
  1052
  809
  481
  112
]
29 0.08 ms
"COMMIT"
Parameters:
[]
30 0.04 ms
SELECT t0.id AS id_1, t0.decription AS decription_2, t0.term_id AS term_id_3 FROM term_case t0 WHERE t0.term_id = ?
Parameters:
[
  112
]
31 0.04 ms
"START TRANSACTION"
Parameters:
[]
32 0.13 ms
INSERT INTO quiz_item (is_correct, date_time, ask, term_id, quiz_id, wrong_a_id, wrong_b_id, wrong_c_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  null
  null
  "The grant was awarded  __________  the project would be completed within the stipulated timeframe."
  112
  1052
  71
  809
  563
]
33 0.04 ms
"COMMIT"
Parameters:
[]
34 0.24 ms
SELECT t0.id AS id_1, t0.decription AS decription_2, t0.term_id AS term_id_3 FROM term_case t0 WHERE t0.term_id = ?
Parameters:
[
  194
]
35 0.04 ms
"START TRANSACTION"
Parameters:
[]
36 0.14 ms
INSERT INTO quiz_item (is_correct, date_time, ask, term_id, quiz_id, wrong_a_id, wrong_b_id, wrong_c_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  null
  null
  "The diameter of the planet is  __________  twice that of Earth, making it one of the largest in the solar system."
  194
  1052
  809
  399
  563
]
37 0.11 ms
"COMMIT"
Parameters:
[]
38 0.04 ms
SELECT t0.id AS id_1, t0.decription AS decription_2, t0.term_id AS term_id_3 FROM term_case t0 WHERE t0.term_id = ?
Parameters:
[
  645
]
39 0.04 ms
"START TRANSACTION"
Parameters:
[]
40 0.25 ms
INSERT INTO quiz_item (is_correct, date_time, ask, term_id, quiz_id, wrong_a_id, wrong_b_id, wrong_c_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  null
  null
  "Teachers play a vital role in student development;  __________ , parents contribute significantly to their academic success. ""
  645
  1052
  563
  727
  71
]
41 0.06 ms
"COMMIT"
Parameters:
[]
42 0.04 ms
SELECT t0.id AS id_1, t0.decription AS decription_2, t0.term_id AS term_id_3 FROM term_case t0 WHERE t0.term_id = ?
Parameters:
[
  522
]
43 0.04 ms
"START TRANSACTION"
Parameters:
[]
44 0.33 ms
INSERT INTO quiz_item (is_correct, date_time, ask, term_id, quiz_id, wrong_a_id, wrong_b_id, wrong_c_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  null
  null
  "The researcher highlighted the similarities  __________  differences between the two case studies."
  522
  1052
  809
  645
  481
]
45 0.05 ms
"COMMIT"
Parameters:
[]
46 0.51 ms
SELECT t0.id AS id_1, t0.decription AS decription_2, t0.term_id AS term_id_3 FROM term_case t0 WHERE t0.term_id = ?
Parameters:
[
  727
]
47 1.90 ms
"START TRANSACTION"
Parameters:
[]
48 0.19 ms
INSERT INTO quiz_item (is_correct, date_time, ask, term_id, quiz_id, wrong_a_id, wrong_b_id, wrong_c_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  null
  null
  "The experiment was unsuccessful  __________  there was a flaw in the design."
  727
  1052
  809
  481
  563
]
49 0.05 ms
"COMMIT"
Parameters:
[]
50 0.04 ms
SELECT t0.id AS id_1, t0.decription AS decription_2, t0.term_id AS term_id_3 FROM term_case t0 WHERE t0.term_id = ?
Parameters:
[
  440
]
51 1.67 ms
"START TRANSACTION"
Parameters:
[]
52 0.22 ms
INSERT INTO quiz_item (is_correct, date_time, ask, term_id, quiz_id, wrong_a_id, wrong_b_id, wrong_c_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  null
  null
  "The findings confirm the hypothesis;  __________ , they open new avenues for further investigation."
  440
  1052
  645
  481
  399
]
53 0.06 ms
"COMMIT"
Parameters:
[]
54 0.03 ms
SELECT t0.id AS id_1, t0.decription AS decription_2, t0.term_id AS term_id_3 FROM term_case t0 WHERE t0.term_id = ?
Parameters:
[
  235
]
55 0.04 ms
"START TRANSACTION"
Parameters:
[]
56 0.15 ms
INSERT INTO quiz_item (is_correct, date_time, ask, term_id, quiz_id, wrong_a_id, wrong_b_id, wrong_c_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  null
  null
  "The data were collected over a two-year period and  __________  compared to historical trends for validation."
  235
  1052
  112
  399
  768
]
57 0.04 ms
"COMMIT"
Parameters:
[]
58 1.20 ms
SELECT t0.id AS id_1, t0.decription AS decription_2, t0.term_id AS term_id_3 FROM term_case t0 WHERE t0.term_id = ?
Parameters:
[
  317
]
59 0.10 ms
"START TRANSACTION"
Parameters:
[]
60 0.17 ms
INSERT INTO quiz_item (is_correct, date_time, ask, term_id, quiz_id, wrong_a_id, wrong_b_id, wrong_c_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  null
  null
  " __________  she arrived at the conference, the keynote speech had already started."
  317
  1052
  112
  645
  809
]
61 1.75 ms
"COMMIT"
Parameters:
[]
62 0.05 ms
SELECT t0.id AS id_1, t0.decription AS decription_2, t0.term_id AS term_id_3 FROM term_case t0 WHERE t0.term_id = ?
Parameters:
[
  481
]
63 0.05 ms
"START TRANSACTION"
Parameters:
[]
64 0.16 ms
INSERT INTO quiz_item (is_correct, date_time, ask, term_id, quiz_id, wrong_a_id, wrong_b_id, wrong_c_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  null
  null
  " __________  the deadline, the team worked overtime to finalize the project. ""
  481
  1052
  645
  563
  399
]
65 0.05 ms
"COMMIT"
Parameters:
[]
66 0.04 ms
SELECT t0.id AS id_1, t0.decription AS decription_2, t0.term_id AS term_id_3 FROM term_case t0 WHERE t0.term_id = ?
Parameters:
[
  30
]
67 1.00 ms
"START TRANSACTION"
Parameters:
[]
68 0.22 ms
INSERT INTO quiz_item (is_correct, date_time, ask, term_id, quiz_id, wrong_a_id, wrong_b_id, wrong_c_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  null
  null
  "The government introduced two key policies: firstly, tax incentives for green energy projects;  __________ , stricter regulations on industrial emissions."
  30
  1052
  727
  399
  112
]
69 0.04 ms
"COMMIT"
Parameters:
[]
70 0.27 ms
SELECT t0.id AS id_1, t0.decription AS decription_2, t0.term_id AS term_id_3 FROM term_case t0 WHERE t0.term_id = ?
Parameters:
[
  768
]
71 0.63 ms
"START TRANSACTION"
Parameters:
[]
72 0.17 ms
INSERT INTO quiz_item (is_correct, date_time, ask, term_id, quiz_id, wrong_a_id, wrong_b_id, wrong_c_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  null
  null
  "The resources were not  __________  to meet the demands of the experimental procedures."
  768
  1052
  645
  563
  604
]
73 0.04 ms
"COMMIT"
Parameters:
[]
74 0.04 ms
SELECT t0.id AS id_1, t0.decription AS decription_2, t0.term_id AS term_id_3 FROM term_case t0 WHERE t0.term_id = ?
Parameters:
[
  686
]
75 0.04 ms
"START TRANSACTION"
Parameters:
[]
76 0.20 ms
INSERT INTO quiz_item (is_correct, date_time, ask, term_id, quiz_id, wrong_a_id, wrong_b_id, wrong_c_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  null
  null
  "The new policy has had a positive impact on the environment,  __________  reducing carbon emissions."
  686
  1052
  71
  645
  522
]
77 0.04 ms
"COMMIT"
Parameters:
[]
78 0.04 ms
SELECT t0.id AS id_1, t0.decription AS decription_2, t0.term_id AS term_id_3 FROM term_case t0 WHERE t0.term_id = ?
Parameters:
[
  399
]
79 0.03 ms
"START TRANSACTION"
Parameters:
[]
80 0.14 ms
INSERT INTO quiz_item (is_correct, date_time, ask, term_id, quiz_id, wrong_a_id, wrong_b_id, wrong_c_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  null
  null
  ""The speaker reminded the audience that,  __________ , perseverance is necessary to achieve long-term goals.""
  399
  1052
  604
  727
  768
]
81 0.04 ms
"COMMIT"
Parameters:
[]
82 0.04 ms
SELECT t0.id AS id_1, t0.decription AS decription_2, t0.term_id AS term_id_3 FROM term_case t0 WHERE t0.term_id = ?
Parameters:
[
  563
]
83 0.05 ms
"START TRANSACTION"
Parameters:
[]
84 0.15 ms
INSERT INTO quiz_item (is_correct, date_time, ask, term_id, quiz_id, wrong_a_id, wrong_b_id, wrong_c_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  null
  null
  "The first phase of the experiment focused on data collection;  __________ , the team prepared the necessary tools for analysis."
  563
  1052
  71
  768
  604
]
85 0.05 ms
"COMMIT"
Parameters:
[]

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\Pack No errors.
App\Entity\Term No errors.
App\Entity\Quiz No errors.
App\Entity\QuizItem No errors.
App\Entity\TermCase No errors.