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

Query Metrics

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

Queries

Group similar statements

# Time Info
1 0.12 ms
SELECT t0.id AS id_1 FROM pack t0 WHERE t0.id = ?
Parameters:
[
  "9"
]
2 0.09 ms
"START TRANSACTION"
Parameters:
[]
3 0.22 ms
INSERT INTO quiz (pack_id) VALUES (?)
Parameters:
[
  9
]
4 0.07 ms
"COMMIT"
Parameters:
[]
5 1.31 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:
[
  9
]
6 0.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:
[
  296
]
7 0.05 ms
"START TRANSACTION"
Parameters:
[]
8 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
  "<em> __________  traditional methods, this new approach uses advanced technology to improve efficiency.</em>"
  296
  1301
  460
  419
  747
]
9 0.06 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:
[
  337
]
11 0.04 ms
"START TRANSACTION"
Parameters:
[]
12 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 population in urban areas has grown rapidly,  __________  the need for improved infrastructure has become urgent."
  337
  1301
  419
  706
  583
]
13 0.05 ms
"COMMIT"
Parameters:
[]
14 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:
[
  255
]
15 0.04 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 report provides detailed information  __________  the effects of climate change on agriculture."
  255
  1301
  747
  501
  583
]
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:
[
  214
]
19 0.03 ms
"START TRANSACTION"
Parameters:
[]
20 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 study found that increased physical activity improves mental health.  __________ , a sedentary lifestyle is linked to higher rates of depression."
  214
  1301
  788
  583
  337
]
21 0.06 ms
"COMMIT"
Parameters:
[]
22 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:
[
  378
]
23 0.05 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
  "Advanced technologies improve productivity;  __________ , they can displace workers in traditional industries."
  378
  1301
  665
  460
  747
]
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:
[
  419
]
27 0.04 ms
"START TRANSACTION"
Parameters:
[]
28 0.50 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  __________  improved productivity, although no official data has been released."
  419
  1301
  788
  501
  747
]
29 0.23 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:
[
  624
]
31 0.03 ms
"START TRANSACTION"
Parameters:
[]
32 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 decision was made  __________  the analysis of current market trends."
  624
  1301
  419
  337
  460
]
33 0.04 ms
"COMMIT"
Parameters:
[]
34 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:
[
  747
]
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 negotiations between the two countries were complex, but <em> __________ </em>, they reached a mutually beneficial agreement."
  747
  1301
  706
  788
  501
]
37 0.04 ms
"COMMIT"
Parameters:
[]
38 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:
[
  132
]
39 0.04 ms
"START TRANSACTION"
Parameters:
[]
40 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 study highlights the negative effects of prolonged screen time; <em> __________ </em>, excessive use of digital devices can impair sleep quality and cognitive development."
  132
  1301
  460
  542
  501
]
41 0.07 ms
"COMMIT"
Parameters:
[]
42 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:
[
  501
]
43 0.04 ms
"START TRANSACTION"
Parameters:
[]
44 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
  "Researchers have found that earthquakes of such magnitude  __________  occur in this region."
  501
  1301
  419
  788
  460
]
45 0.04 ms
"COMMIT"
Parameters:
[]
46 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:
[
  788
]
47 0.04 ms
"START TRANSACTION"
Parameters:
[]
48 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 symptoms of the two diseases are quite similar, presenting  __________ ."
  788
  1301
  337
  419
  460
]
49 0.04 ms
"COMMIT"
Parameters:
[]
50 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:
[
  173
]
51 0.04 ms
"START TRANSACTION"
Parameters:
[]
52 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 university conducts a <em> __________ </em> review of its curriculum to ensure academic excellence."
  173
  1301
  665
  542
  460
]
53 0.04 ms
"COMMIT"
Parameters:
[]
54 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:
[
  9
]
55 0.04 ms
"START TRANSACTION"
Parameters:
[]
56 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 road was closed temporarily  __________  a major accident earlier in the day. ""
  9
  1301
  706
  501
  419
]
57 0.06 ms
"COMMIT"
Parameters:
[]
58 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:
[
  706
]
59 0.06 ms
"START TRANSACTION"
Parameters:
[]
60 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
  "climate change mitigation efforts will be effective <em> __________ </em> international cooperation is maintained over time."
  706
  1301
  788
  542
  747
]
61 0.31 ms
"COMMIT"
Parameters:
[]
62 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:
[
  460
]
63 0.05 ms
"START TRANSACTION"
Parameters:
[]
64 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 new educational program is  __________  enhance students' critical thinking skills through interactive learning."
  460
  1301
  542
  337
  747
]
65 0.04 ms
"COMMIT"
Parameters:
[]
66 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:
[
  542
]
67 0.03 ms
"START TRANSACTION"
Parameters:
[]
68 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 satellite image captured a highway running  __________  the coastline, illustrating the impact of infrastructure on coastal ecosystems."
  542
  1301
  460
  706
  788
]
69 0.04 ms
"COMMIT"
Parameters:
[]
70 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:
[
  50
]
71 0.04 ms
"START TRANSACTION"
Parameters:
[]
72 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 company invested in employee training programs, and it upgraded its technological infrastructure <em> __________ </em>."
  50
  1301
  747
  706
  419
]
73 0.04 ms
"COMMIT"
Parameters:
[]
74 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:
[
  91
]
75 0.04 ms
"START TRANSACTION"
Parameters:
[]
76 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
  "We need to conserve energy  __________  future generations can enjoy a healthy planet."
  91
  1301
  337
  419
  788
]
77 0.04 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:
[
  583
]
79 0.04 ms
"START TRANSACTION"
Parameters:
[]
80 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 cost of implementing the new policy was estimated at  __________  $50 million."
  583
  1301
  706
  337
  542
]
81 0.04 ms
"COMMIT"
Parameters:
[]
82 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:
[
  665
]
83 0.04 ms
"START TRANSACTION"
Parameters:
[]
84 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 first electric vehicles were introduced in the early 2000s, and  __________ , battery technology has improved dramatically."
  665
  1301
  337
  583
  501
]
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.