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

Query Metrics

82 Database Queries
7 Different statements
33.79 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 0.47 ms
SELECT t0.id AS id_1 FROM pack t0 WHERE t0.id = ?
Parameters:
[
  "8"
]
2 0.15 ms
"START TRANSACTION"
Parameters:
[]
3 0.33 ms
INSERT INTO quiz (pack_id) VALUES (?)
Parameters:
[
  8
]
4 0.08 ms
"COMMIT"
Parameters:
[]
5 1.02 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:
[
  8
]
6 2.06 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:
[
  336
]
7 0.07 ms
"START TRANSACTION"
Parameters:
[]
8 0.92 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 company's profits have increased this year, and they are expected to increase  __________  in the coming years." (Os lucros da empresa aumentaram este ano e espera-se que aumentem ainda mais nos próximos anos.)"
  336
  1287
  459
  254
  746
]
9 0.29 ms
"COMMIT"
Parameters:
[]
10 0.45 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:
[
  49
]
11 0.06 ms
"START TRANSACTION"
Parameters:
[]
12 0.29 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
  "This program is  __________  provide financial support to low-income families in urban areas."
  49
  1287
  582
  418
  746
]
13 0.07 ms
"COMMIT"
Parameters:
[]
14 0.68 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:
[
  787
]
15 0.05 ms
"START TRANSACTION"
Parameters:
[]
16 0.96 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 software update fixed previous bugs,  __________ , it introduced several new security features."
  787
  1287
  705
  254
  582
]
17 0.07 ms
"COMMIT"
Parameters:
[]
18 1.76 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:
[
  746
]
19 0.08 ms
"START TRANSACTION"
Parameters:
[]
20 0.32 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 experiment yielded positive results;  __________  these findings, the second one was inconclusive."
  746
  1287
  459
  254
  377
]
21 0.08 ms
"COMMIT"
Parameters:
[]
22 0.91 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:
[
  500
]
23 0.08 ms
"START TRANSACTION"
Parameters:
[]
24 1.88 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 underscores the importance of collaboration;  __________ , it concludes that interdisciplinary efforts lead to better outcomes. ""
  500
  1287
  787
  746
  459
]
25 0.09 ms
"COMMIT"
Parameters:
[]
26 1.67 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:
[
  582
]
27 0.09 ms
"START TRANSACTION"
Parameters:
[]
28 0.95 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
  " __________ , there is a discrepancy between the survey responses and the actual behavior of participants."
  582
  1287
  459
  541
  787
]
29 0.12 ms
"COMMIT"
Parameters:
[]
30 1.13 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:
[
  254
]
31 0.09 ms
"START TRANSACTION"
Parameters:
[]
32 0.34 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 lack of proper sanitation facilities is  __________  the spread of waterborne diseases in the region."
  254
  1287
  213
  295
  541
]
33 0.09 ms
"COMMIT"
Parameters:
[]
34 0.58 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:
[
  377
]
35 0.06 ms
"START TRANSACTION"
Parameters:
[]
36 0.92 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 novel explores the themes of love, loss, and redemption."
  377
  1287
  664
  787
  295
]
37 0.09 ms
"COMMIT"
Parameters:
[]
38 3.13 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:
[
  172
]
39 0.09 ms
"START TRANSACTION"
Parameters:
[]
40 0.38 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
  "This phenomenon is  __________  discussed in mainstream scientific literature despite its significance."
  172
  1287
  746
  254
  418
]
41 0.46 ms
"COMMIT"
Parameters:
[]
42 1.31 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:
[
  213
]
43 0.06 ms
"START TRANSACTION"
Parameters:
[]
44 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
  "Natural disasters  __________  occur in this region."
  213
  1287
  459
  295
  705
]
45 0.07 ms
"COMMIT"
Parameters:
[]
46 0.78 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:
[
  541
]
47 0.07 ms
"START TRANSACTION"
Parameters:
[]
48 0.26 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 population of the city has grown  __________  over the last two decades due to increased urbanization."
  541
  1287
  582
  213
  377
]
49 0.07 ms
"COMMIT"
Parameters:
[]
50 0.65 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:
[
  664
]
51 0.05 ms
"START TRANSACTION"
Parameters:
[]
52 0.23 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
  "This phenomenon is observed in various ecosystems,  __________  in tropical rainforests with high biodiversity."
  664
  1287
  418
  213
  254
]
53 0.06 ms
"COMMIT"
Parameters:
[]
54 0.58 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:
[
  8
]
55 0.05 ms
"START TRANSACTION"
Parameters:
[]
56 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 economic growth of the region is  __________  attributed to the expansion of the technology sector."
  8
  1287
  418
  541
  254
]
57 0.06 ms
"COMMIT"
Parameters:
[]
58 0.21 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:
[
  459
]
59 0.05 ms
"START TRANSACTION"
Parameters:
[]
60 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 w __________  implemented  __________  part of the broader institutional reforms.""
  459
  1287
  705
  295
  254
]
61 0.06 ms
"COMMIT"
Parameters:
[]
62 0.59 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:
[
  623
]
63 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:
[
  295
]
64 0.05 ms
"START TRANSACTION"
Parameters:
[]
65 0.21 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 results of the experiment will be available  __________ , allowing researchers to refine their hypotheses."
  295
  1287
  459
  746
  377
]
66 0.06 ms
"COMMIT"
Parameters:
[]
67 0.29 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:
[
  90
]
68 0.08 ms
"START TRANSACTION"
Parameters:
[]
69 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 doctor performed a thorough check-up.  __________ , she provided the patient with a list of recommendations.""
  90
  1287
  746
  377
  787
]
70 0.09 ms
"COMMIT"
Parameters:
[]
71 0.84 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:
[
  418
]
72 0.06 ms
"START TRANSACTION"
Parameters:
[]
73 0.21 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  __________  we got from the city, the quieter it became."
  418
  1287
  254
  377
  787
]
74 0.06 ms
"COMMIT"
Parameters:
[]
75 0.30 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:
[
  705
]
76 0.05 ms
"START TRANSACTION"
Parameters:
[]
77 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 current education system is failing our students."
  705
  1287
  664
  746
  49
]
78 0.19 ms
"COMMIT"
Parameters:
[]
79 1.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:
[
  131
]
80 0.07 ms
"START TRANSACTION"
Parameters:
[]
81 0.23 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 found that regular exercise can improve cardiovascular health.  __________ , it can also reduce the risk of depression."
  131
  1287
  541
  705
  459
]
82 0.06 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.