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

Query Metrics

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

Queries

Group similar statements

# Time Info
1 2.26 ms
SELECT t0.id AS id_1 FROM pack t0 WHERE t0.id = ?
Parameters:
[
  "8"
]
2 0.20 ms
"START TRANSACTION"
Parameters:
[]
3 0.29 ms
INSERT INTO quiz (pack_id) VALUES (?)
Parameters:
[
  8
]
4 0.09 ms
"COMMIT"
Parameters:
[]
5 0.53 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 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:
[
  582
]
7 0.04 ms
"START TRANSACTION"
Parameters:
[]
8 0.87 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 problem,  __________ , arises from a misunderstanding of the software's functionality. ""
  582
  1606
  377
  459
  541
]
9 0.18 ms
"COMMIT"
Parameters:
[]
10 0.26 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
]
11 0.21 ms
"START TRANSACTION"
Parameters:
[]
12 0.42 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
  1606
  295
  418
  787
]
13 0.43 ms
"COMMIT"
Parameters:
[]
14 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:
[
  500
]
15 0.21 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 project faced numerous challenges;  __________ , it was nearly abandoned due to budget constraints."
  500
  1606
  582
  787
  541
]
17 0.14 ms
"COMMIT"
Parameters:
[]
18 1.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:
[
  459
]
19 0.12 ms
"START TRANSACTION"
Parameters:
[]
20 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 researchers analyzed the data  __________  thoroughly  __________  possible to ensure accuracy.""
  459
  1606
  418
  787
  582
]
21 0.05 ms
"COMMIT"
Parameters:
[]
22 1.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:
[
  131
]
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 experiment was a success.  __________ , the results were even better than expected."
  131
  1606
  295
  213
  254
]
25 0.04 ms
"COMMIT"
Parameters:
[]
26 0.90 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
]
27 1.14 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
]
28 0.06 ms
"START TRANSACTION"
Parameters:
[]
29 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
  "In historical records, such extreme weather patterns were  __________  documented before the 20th century."
  172
  1606
  295
  459
  418
]
30 0.06 ms
"COMMIT"
Parameters:
[]
31 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:
[
  418
]
32 0.04 ms
"START TRANSACTION"
Parameters:
[]
33 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 journey was  __________  than we expected."
  418
  1606
  746
  254
  787
]
34 0.04 ms
"COMMIT"
Parameters:
[]
35 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:
[
  336
]
36 0.07 ms
"START TRANSACTION"
Parameters:
[]
37 0.24 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
  ""climate change is a serious threat to our planet, and  __________  so in coastal regions." (A mudança climática é uma ameaça séria ao nosso planeta, e ainda mais nas regiões costeiras.)"
  336
  1606
  746
  541
  49
]
38 0.05 ms
"COMMIT"
Parameters:
[]
39 0.41 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
]
40 0.05 ms
"START TRANSACTION"
Parameters:
[]
41 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 book discusses the causes of the war.  __________ , it explores the consequences for the affected regions.""
  90
  1606
  746
  254
  787
]
42 0.04 ms
"COMMIT"
Parameters:
[]
43 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:
[
  49
]
44 0.05 ms
"START TRANSACTION"
Parameters:
[]
45 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 training sessions are  __________  prepare employees for leadership roles within the organization."
  49
  1606
  664
  459
  418
]
46 0.24 ms
"COMMIT"
Parameters:
[]
47 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:
[
  664
]
48 0.05 ms
"START TRANSACTION"
Parameters:
[]
49 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 company has invested in multiple renewable energy sources,  __________  solar and wind power."
  664
  1606
  254
  295
  459
]
50 0.04 ms
"COMMIT"
Parameters:
[]
51 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:
[
  705
]
52 0.04 ms
"START TRANSACTION"
Parameters:
[]
53 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
  " __________ , social media has changed the way we communicate."
  705
  1606
  418
  254
  49
]
54 0.04 ms
"COMMIT"
Parameters:
[]
55 0.95 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
]
56 0.04 ms
"START TRANSACTION"
Parameters:
[]
57 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 effectiveness of the intervention was  __________  dependent on the participants’ level of engagement."
  8
  1606
  705
  582
  664
]
58 0.04 ms
"COMMIT"
Parameters:
[]
59 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:
[
  295
]
60 0.05 ms
"START TRANSACTION"
Parameters:
[]
61 0.81 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
  "As more evidence emerges, historians may  __________  revise their understanding of early civilizations."
  295
  1606
  664
  787
  746
]
62 0.06 ms
"COMMIT"
Parameters:
[]
63 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:
[
  213
]
64 0.06 ms
"START TRANSACTION"
Parameters:
[]
65 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
  "Patients  __________  report side effects from this medication."
  213
  1606
  418
  582
  541
]
66 0.04 ms
"COMMIT"
Parameters:
[]
67 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:
[
  746
]
68 0.04 ms
"START TRANSACTION"
Parameters:
[]
69 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 bustling city life, the countryside offers peace and tranquility."
  746
  1606
  213
  582
  377
]
70 0.07 ms
"COMMIT"
Parameters:
[]
71 1.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:
[
  254
]
72 0.04 ms
"START TRANSACTION"
Parameters:
[]
73 1.04 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 rapid urbanization of the area is  __________  the loss of natural habitats for local wildlife."
  254
  1606
  541
  459
  49
]
74 0.08 ms
"COMMIT"
Parameters:
[]
75 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:
[
  787
]
76 0.04 ms
"START TRANSACTION"
Parameters:
[]
77 12.85 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 method improves accuracy,  __________ , it significantly reduces processing time."
  787
  1606
  582
  746
  541
]
78 0.14 ms
"COMMIT"
Parameters:
[]
79 0.08 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
]
80 0.12 ms
"START TRANSACTION"
Parameters:
[]
81 15.79 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 time required to complete the project was  __________  shorter than initially anticipated."
  541
  1606
  787
  418
  254
]
82 0.27 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.