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

Query Metrics

81 Database Queries
7 Different statements
16.20 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 3.89 ms
SELECT t0.id AS id_1 FROM pack t0 WHERE t0.id = ?
Parameters:
[
  "37"
]
2 0.09 ms
"START TRANSACTION"
Parameters:
[]
3 0.22 ms
INSERT INTO quiz (pack_id) VALUES (?)
Parameters:
[
  37
]
4 0.07 ms
"COMMIT"
Parameters:
[]
5 0.59 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:
[
  37
]
6 0.35 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:
[
  611
]
7 0.05 ms
"START TRANSACTION"
Parameters:
[]
8 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 heavy rainfall, the event was postponed until next week."
  611
  1614
  365
  160
  201
]
9 0.05 ms
"COMMIT"
Parameters:
[]
10 0.22 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:
[
  242
]
11 0.04 ms
"START TRANSACTION"
Parameters:
[]
12 0.90 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 collected was incomplete;  __________ , it was enough to draw some preliminary conclusions."
  242
  1614
  775
  78
  365
]
13 0.07 ms
"COMMIT"
Parameters:
[]
14 0.22 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:
[
  488
]
15 0.04 ms
"START TRANSACTION"
Parameters:
[]
16 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 novel received mixed reviews from critics;  __________ , it became a bestseller within weeks of its release."
  488
  1614
  201
  529
  365
]
17 0.05 ms
"COMMIT"
Parameters:
[]
18 0.11 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:
[
  734
]
19 0.05 ms
"START TRANSACTION"
Parameters:
[]
20 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
  "His argument was well-structured,  __________  lacking sufficient evidence to support his claims."
  734
  1614
  611
  529
  365
]
21 0.05 ms
"COMMIT"
Parameters:
[]
22 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:
[
  529
]
23 0.04 ms
"START TRANSACTION"
Parameters:
[]
24 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 impact of air pollution on marine biodiversity is  __________  discussed in policy-making debates."
  529
  1614
  365
  611
  775
]
25 0.04 ms
"COMMIT"
Parameters:
[]
26 0.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:
[
  406
]
27 0.04 ms
"START TRANSACTION"
Parameters:
[]
28 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 project requires two essential components,  __________  time and financial resources."
  406
  1614
  160
  201
  734
]
29 0.04 ms
"COMMIT"
Parameters:
[]
30 0.22 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:
[
  37
]
31 0.04 ms
"START TRANSACTION"
Parameters:
[]
32 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 optimistic view presented in the first half of the book, the ending is rather pessimistic."
  37
  1614
  78
  365
  611
]
33 0.30 ms
"COMMIT"
Parameters:
[]
34 0.22 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:
[
  447
]
35 0.06 ms
"START TRANSACTION"
Parameters:
[]
36 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
  " __________  we had more time, we could conduct a more thorough analysis."
  447
  1614
  652
  201
  365
]
37 0.04 ms
"COMMIT"
Parameters:
[]
38 0.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:
[
  693
]
39 0.04 ms
"START TRANSACTION"
Parameters:
[]
40 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 experiment does not produce consistent data, the variables will be adjusted accordingly."
  693
  1614
  611
  160
  529
]
41 0.05 ms
"COMMIT"
Parameters:
[]
42 0.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:
[
  160
]
43 0.03 ms
"START TRANSACTION"
Parameters:
[]
44 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 results indicate that biodiversity enhances ecosystem stability,  __________  diversity in workplaces improves organizational performance."
  160
  1614
  611
  365
  201
]
45 0.05 ms
"COMMIT"
Parameters:
[]
46 0.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:
[
  570
]
47 0.04 ms
"START TRANSACTION"
Parameters:
[]
48 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 patient's symptoms were  __________  mild at first, but they worsened over time."
  570
  1614
  734
  160
  611
]
49 0.04 ms
"COMMIT"
Parameters:
[]
50 0.25 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:
[
  78
]
51 0.04 ms
"START TRANSACTION"
Parameters:
[]
52 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
  "Although  __________  historians dispute the accuracy of the newly discovered manuscript, most agree on its historical significance."
  78
  1614
  529
  160
  734
]
53 0.06 ms
"COMMIT"
Parameters:
[]
54 0.35 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:
[
  775
]
55 0.04 ms
"START TRANSACTION"
Parameters:
[]
56 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 lack of government support contributed to the project's failure."
  775
  1614
  365
  78
  201
]
57 0.04 ms
"COMMIT"
Parameters:
[]
58 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:
[
  365
]
59 0.04 ms
"START TRANSACTION"
Parameters:
[]
60 1.03 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
  "Data collected  __________  the designated parameters was excluded from the final analysis to maintain accuracy."
  365
  1614
  201
  652
  611
]
61 0.06 ms
"COMMIT"
Parameters:
[]
62 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:
[
  201
]
63 0.04 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
  "<em> __________ , the company exceeded its annual revenue goals despite the economic downturn.</em>"
  201
  1614
  78
  160
  734
]
65 0.38 ms
"COMMIT"
Parameters:
[]
66 0.25 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:
[
  324
]
67 0.05 ms
"START TRANSACTION"
Parameters:
[]
68 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
  "Researchers documented the migration patterns of animals living in habitats  __________ ."
  324
  1614
  611
  775
  734
]
69 0.06 ms
"COMMIT"
Parameters:
[]
70 0.25 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:
[
  283
]
71 0.05 ms
"START TRANSACTION"
Parameters:
[]
72 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 results indicated that students who attended <em> __________ </em> review sessions performed better on final exams."
  283
  1614
  160
  201
  611
]
73 0.05 ms
"COMMIT"
Parameters:
[]
74 0.44 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:
[
  119
]
75 0.05 ms
"START TRANSACTION"
Parameters:
[]
76 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 speech covered many important topics;  __________ , it emphasized the urgency of addressing climate change. ""
  119
  1614
  611
  734
  775
]
77 0.05 ms
"COMMIT"
Parameters:
[]
78 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:
[
  652
]
79 0.04 ms
"START TRANSACTION"
Parameters:
[]
80 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 two regions differ greatly  __________  their cultural and economic characteristics."
  652
  1614
  734
  160
  775
]
81 0.04 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.