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

Query Metrics

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

Queries

Group similar statements

# Time Info
1 0.70 ms
SELECT t0.id AS id_1 FROM pack t0 WHERE t0.id = ?
Parameters:
[
  "4"
]
2 0.12 ms
"START TRANSACTION"
Parameters:
[]
3 0.68 ms
INSERT INTO quiz (pack_id) VALUES (?)
Parameters:
[
  4
]
4 0.45 ms
"COMMIT"
Parameters:
[]
5 0.07 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:
[
  4
]
6 0.94 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:
[
  414
]
7 0.19 ms
"START TRANSACTION"
Parameters:
[]
8 1.65 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 reduction in greenhouse gas emissions was  __________  offset by the increase in industrial activity in other sectors."
  414
  1027
  701
  168
  127
]
9 0.10 ms
"COMMIT"
Parameters:
[]
10 0.88 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:
[
  496
]
11 0.40 ms
"START TRANSACTION"
Parameters:
[]
12 0.91 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 will take effect next year; <em> __________ </em>, the current regulations will remain in place."
  496
  1027
  701
  783
  414
]
13 0.10 ms
"COMMIT"
Parameters:
[]
14 0.23 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:
[
  45
]
15 0.10 ms
"START TRANSACTION"
Parameters:
[]
16 1.01 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 first examined the historical background of the issue;  __________ , it explored contemporary implications."
  45
  1027
  660
  701
  168
]
17 0.17 ms
"COMMIT"
Parameters:
[]
18 1.62 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:
[
  168
]
19 0.09 ms
"START TRANSACTION"
Parameters:
[]
20 0.82 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 camera captured images of the processes occurring  __________  the engine while it was in operation. ""
  168
  1027
  742
  86
  701
]
21 0.13 ms
"COMMIT"
Parameters:
[]
22 0.42 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:
[
  250
]
23 0.08 ms
"START TRANSACTION"
Parameters:
[]
24 0.56 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."
  250
  1027
  701
  168
  783
]
25 0.12 ms
"COMMIT"
Parameters:
[]
26 1.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:
[
  127
]
27 0.12 ms
"START TRANSACTION"
Parameters:
[]
28 1.00 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 researcher explained the complex theory  __________ ."
  127
  1027
  4
  783
  168
]
29 0.08 ms
"COMMIT"
Parameters:
[]
30 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:
[
  373
]
31 0.25 ms
"START TRANSACTION"
Parameters:
[]
32 0.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
  "<em>The study found a significant correlation between education and income,  __________  as between education and health.</em>"
  373
  1027
  701
  86
  783
]
33 0.06 ms
"COMMIT"
Parameters:
[]
34 1.69 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:
[
  455
]
35 0.15 ms
"START TRANSACTION"
Parameters:
[]
36 1.28 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 were unexpected.  __________ , they contradicted previous research in the field."
  455
  1027
  86
  701
  4
]
37 0.09 ms
"COMMIT"
Parameters:
[]
38 0.18 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:
[
  660
]
39 0.09 ms
"START TRANSACTION"
Parameters:
[]
40 0.54 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 examined the long-term effects of pollution on public health; <em> __________ </em>, exposure to air pollutants significantly increases respiratory diseases."
  660
  1027
  127
  619
  414
]
41 0.06 ms
"COMMIT"
Parameters:
[]
42 0.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:
[
  783
]
43 0.19 ms
"START TRANSACTION"
Parameters:
[]
44 0.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 experiment was  __________  test the hypothesis that temperature affects reaction rates."
  783
  1027
  414
  127
  4
]
45 0.06 ms
"COMMIT"
Parameters:
[]
46 1.47 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:
[
  742
]
47 0.13 ms
"START TRANSACTION"
Parameters:
[]
48 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
  "The negotiations between the two countries have been productive  __________ , yet some critical issues remain unresolved."
  742
  1027
  4
  168
  127
]
49 0.07 ms
"COMMIT"
Parameters:
[]
50 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:
[
  209
]
51 0.07 ms
"START TRANSACTION"
Parameters:
[]
52 1.54 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 environmental impacts  __________  the economic benefits of renewable energy."
  209
  1027
  86
  4
  701
]
53 0.05 ms
"COMMIT"
Parameters:
[]
54 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:
[
  619
]
55 0.10 ms
"START TRANSACTION"
Parameters:
[]
56 0.52 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 proposal was submitted  __________  a detailed budget and timeline for implementation."
  619
  1027
  168
  701
  783
]
57 0.13 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:
[
  701
]
59 0.04 ms
"START TRANSACTION"
Parameters:
[]
60 0.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
  " __________  historical records were lost due to natural disasters; how would historians reconstruct past events?""
  701
  1027
  4
  168
  414
]
61 0.06 ms
"COMMIT"
Parameters:
[]
62 0.10 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:
[
  578
]
63 0.09 ms
"START TRANSACTION"
Parameters:
[]
64 0.36 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 funding will be provided  __________  the research adheres to ethical guidelines established by the institution."
  578
  1027
  168
  619
  660
]
65 0.07 ms
"COMMIT"
Parameters:
[]
66 0.57 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:
[
  537
]
67 0.09 ms
"START TRANSACTION"
Parameters:
[]
68 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
  "He saved his money  __________  he could buy a car."
  537
  1027
  701
  4
  414
]
69 0.04 ms
"COMMIT"
Parameters:
[]
70 0.42 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:
[
  4
]
71 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:
[
  332
]
72 0.21 ms
"START TRANSACTION"
Parameters:
[]
73 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
  " __________ , the conference achieved its objectives of promoting collaboration among researchers. ""
  332
  1027
  414
  86
  619
]
74 0.05 ms
"COMMIT"
Parameters:
[]
75 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:
[
  86
]
76 0.04 ms
"START TRANSACTION"
Parameters:
[]
77 0.37 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 model is applied in a real-world scenario; adjustments may be necessary to account for or form unforeseen variables."
  86
  1027
  127
  783
  168
]
78 0.14 ms
"COMMIT"
Parameters:
[]
79 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:
[
  291
]
80 0.15 ms
"START TRANSACTION"
Parameters:
[]
81 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 government&rsquo;s new policy is  __________  aimed at reducing income inequality, but critics argue that it may have the opposite effect."
  291
  1027
  619
  127
  414
]
82 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.