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

Query Metrics

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

Queries

Group similar statements

# Time Info
1 0.72 ms
SELECT t0.id AS id_1 FROM pack t0 WHERE t0.id = ?
Parameters:
[
  "7"
]
2 0.08 ms
"START TRANSACTION"
Parameters:
[]
3 1.65 ms
INSERT INTO quiz (pack_id) VALUES (?)
Parameters:
[
  7
]
4 0.08 ms
"COMMIT"
Parameters:
[]
5 1.55 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:
[
  7
]
6 0.85 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:
[
  745
]
7 0.11 ms
"START TRANSACTION"
Parameters:
[]
8 4.02 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
  "Increased government investment in education, <em> __________ </em> community-driven initiatives, has led to higher literacy rates."
  745
  1600
  376
  294
  704
]
9 0.12 ms
"COMMIT"
Parameters:
[]
10 0.97 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:
[
  417
]
11 0.06 ms
"START TRANSACTION"
Parameters:
[]
12 2.35 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 analyzed various teaching methodologies; <em> __________ </em>, researchers conducted a series of classroom experiments measuring student engagement."
  417
  1600
  663
  376
  745
]
13 0.08 ms
"COMMIT"
Parameters:
[]
14 0.52 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:
[
  458
]
15 0.04 ms
"START TRANSACTION"
Parameters:
[]
16 2.68 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 initiative was launched <em> __________ </em> increasing digital literacy among underserved communities."
  458
  1600
  376
  212
  89
]
17 0.07 ms
"COMMIT"
Parameters:
[]
18 1.38 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:
[
  663
]
19 0.06 ms
"START TRANSACTION"
Parameters:
[]
20 1.77 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 proposal aims to improve infrastructure; firstly, by increasing public investment;  __________ , by encouraging private sector participation."
  663
  1600
  745
  253
  335
]
21 0.09 ms
"COMMIT"
Parameters:
[]
22 0.50 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:
[
  171
]
23 0.05 ms
"START TRANSACTION"
Parameters:
[]
24 1.63 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
  "Many argue that remote work increases productivity; <em> __________ </em>, I believe it largely depends on the individual's work habits and discipline."
  171
  1600
  212
  786
  335
]
25 0.06 ms
"COMMIT"
Parameters:
[]
26 0.98 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:
[
  540
]
27 0.04 ms
"START TRANSACTION"
Parameters:
[]
28 2.44 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 suggest that diet affects mental health,  __________  exercise influences physical well-being."
  540
  1600
  253
  786
  335
]
29 0.06 ms
"COMMIT"
Parameters:
[]
30 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:
[
  253
]
31 0.09 ms
"START TRANSACTION"
Parameters:
[]
32 2.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 species is found  __________  dense forests in the tropical regions of South America."
  253
  1600
  458
  745
  786
]
33 0.10 ms
"COMMIT"
Parameters:
[]
34 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:
[
  786
]
35 0.08 ms
"START TRANSACTION"
Parameters:
[]
36 1.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
  " __________  fire, please use the nearest exit."
  786
  1600
  212
  335
  704
]
37 0.25 ms
"COMMIT"
Parameters:
[]
38 0.85 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:
[
  89
]
39 0.07 ms
"START TRANSACTION"
Parameters:
[]
40 1.57 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
  "Various renewable energy sources were compared; <em> __________ </em>, solar and wind power remain the most viable options for large-scale implementation."
  89
  1600
  294
  704
  376
]
41 0.14 ms
"COMMIT"
Parameters:
[]
42 1.50 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:
[
  335
]
43 0.11 ms
"START TRANSACTION"
Parameters:
[]
44 1.44 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 expansion of global trade has facilitated economic growth,  __________  greater interdependence among nations."
  335
  1600
  745
  212
  89
]
45 0.28 ms
"COMMIT"
Parameters:
[]
46 1.79 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:
[
  704
]
47 0.12 ms
"START TRANSACTION"
Parameters:
[]
48 2.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
  " __________  everyone should have the right to a safe and healthy environment."
  704
  1600
  253
  212
  294
]
49 0.12 ms
"COMMIT"
Parameters:
[]
50 2.87 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:
[
  294
]
51 0.07 ms
"START TRANSACTION"
Parameters:
[]
52 2.53 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 hotel was built  __________  the train station, making it a convenient option for travelers. ""
  294
  1600
  89
  581
  704
]
53 0.13 ms
"COMMIT"
Parameters:
[]
54 1.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:
[
  48
]
55 0.09 ms
"START TRANSACTION"
Parameters:
[]
56 1.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 method has proven effective in many scenarios,  __________  in cases involving younger participants."
  48
  1600
  458
  704
  89
]
57 0.11 ms
"COMMIT"
Parameters:
[]
58 0.38 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:
[
  622
]
59 0.17 ms
"START TRANSACTION"
Parameters:
[]
60 1.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 students reviewed the theoretical concepts.  __________ , they performed a practical experiment to reinforce their understanding.""
  622
  1600
  458
  704
  786
]
61 0.16 ms
"COMMIT"
Parameters:
[]
62 0.82 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:
[
  130
]
63 0.13 ms
"START TRANSACTION"
Parameters:
[]
64 2.77 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 did not follow the doctor's orders;  __________ , their condition worsened."
  130
  1600
  786
  704
  581
]
65 0.21 ms
"COMMIT"
Parameters:
[]
66 0.72 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:
[
  376
]
67 0.09 ms
"START TRANSACTION"
Parameters:
[]
68 2.99 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 experiment was designed to test a specific hypothesis.  __________ , only the relevant variables were manipulated.</em>"
  376
  1600
  335
  89
  540
]
69 0.12 ms
"COMMIT"
Parameters:
[]
70 1.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:
[
  7
]
71 0.21 ms
"START TRANSACTION"
Parameters:
[]
72 2.58 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 aims to reduce carbon emissions; <em> __________ </em>, companies will be required to adopt cleaner energy sources and sustainable practices."
  7
  1600
  704
  540
  212
]
73 0.10 ms
"COMMIT"
Parameters:
[]
74 0.52 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:
[
  212
]
75 0.04 ms
"START TRANSACTION"
Parameters:
[]
76 0.51 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 suggests that the problem is even more widespread than previously thought."
  212
  1600
  376
  540
  458
]
77 0.17 ms
"COMMIT"
Parameters:
[]
78 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:
[
  581
]
79 0.10 ms
"START TRANSACTION"
Parameters:
[]
80 0.44 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 analysis includes data from several countries with varying levels of economic development.</em> ""
  581
  1600
  253
  786
  458
]
81 0.10 ms
"COMMIT"
Parameters:
[]
82 1.48 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:
[
  499
]
83 0.04 ms
"START TRANSACTION"
Parameters:
[]
84 1.11 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 proposal was approved, several other projects had been initiated."
  499
  1600
  745
  294
  253
]
85 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.