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

Query Metrics

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

Queries

Group similar statements

# Time Info
1 0.49 ms
SELECT t0.id AS id_1 FROM pack t0 WHERE t0.id = ?
Parameters:
[
  "27"
]
2 0.08 ms
"START TRANSACTION"
Parameters:
[]
3 0.24 ms
INSERT INTO quiz (pack_id) VALUES (?)
Parameters:
[
  27
]
4 0.36 ms
"COMMIT"
Parameters:
[]
5 0.44 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:
[
  27
]
6 0.07 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:
[
  273
]
7 0.05 ms
"START TRANSACTION"
Parameters:
[]
8 0.27 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 is a bestseller."
  273
  1319
  478
  519
  724
]
9 0.06 ms
"COMMIT"
Parameters:
[]
10 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:
[
  519
]
11 0.03 ms
"START TRANSACTION"
Parameters:
[]
12 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 offers competitive salaries;  __________ , it provides excellent benefits."
  519
  1319
  683
  806
  560
]
13 0.04 ms
"COMMIT"
Parameters:
[]
14 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:
[
  150
]
15 0.06 ms
"START TRANSACTION"
Parameters:
[]
16 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 findings of this study support the hypothesis;  __________ , earlier research suggested the opposite."
  150
  1319
  765
  724
  683
]
17 0.05 ms
"COMMIT"
Parameters:
[]
18 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:
[
  683
]
19 0.05 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
  "climate change has affected many ecosystems,  __________  coral reefs, which are experiencing unprecedented bleaching."
  683
  1319
  232
  519
  642
]
21 0.05 ms
"COMMIT"
Parameters:
[]
22 0.32 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:
[
  109
]
23 0.05 ms
"START TRANSACTION"
Parameters:
[]
24 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 older model is less energy-efficient than the new one."
  109
  1319
  765
  642
  806
]
25 0.23 ms
"COMMIT"
Parameters:
[]
26 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:
[
  68
]
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 experiment was conducted in three stages, with the final stage performed  __________  the data from the initial tests were analyzed."
  68
  1319
  232
  601
  806
]
29 0.04 ms
"COMMIT"
Parameters:
[]
30 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:
[
  396
]
31 0.04 ms
"START TRANSACTION"
Parameters:
[]
32 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
  "Studies show the benefits of a balanced diet; <em> __________ </em>, regular consumption of fruits and vegetables significantly reduces the risk of chronic diseases."
  396
  1319
  560
  519
  232
]
33 0.07 ms
"COMMIT"
Parameters:
[]
34 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:
[
  191
]
35 0.04 ms
"START TRANSACTION"
Parameters:
[]
36 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 data show that early childhood education improves academic performance; <em> __________ </em>, children who attend preschool tend to achieve better results later in life."
  191
  1319
  806
  642
  765
]
37 0.07 ms
"COMMIT"
Parameters:
[]
38 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:
[
  642
]
39 0.04 ms
"START TRANSACTION"
Parameters:
[]
40 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 professor advised students to review their progress through  __________  evaluations to ensure academic goals are met."
  642
  1319
  519
  232
  724
]
41 0.04 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:
[
  27
]
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
  "The introduction of automation has led to increased productivity in manufacturing;  __________ , digital tools have revolutionized efficiency in administrative tasks."
  27
  1319
  232
  560
  765
]
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:
[
  232
]
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 study acknowledges the limitations of the sample size;  __________ , the findings contribute valuable insights to the field."
  232
  1319
  642
  478
  765
]
49 0.04 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:
[
  806
]
51 0.04 ms
"START TRANSACTION"
Parameters:
[]
52 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 scientists are conducting further research  __________  better understand the phenomenon."
  806
  1319
  642
  519
  601
]
53 0.12 ms
"COMMIT"
Parameters:
[]
54 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:
[
  355
]
55 0.04 ms
"START TRANSACTION"
Parameters:
[]
56 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 negotiations lasted  __________  both parties reached a mutually beneficial agreement."
  355
  1319
  519
  601
  560
]
57 0.27 ms
"COMMIT"
Parameters:
[]
58 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:
[
  437
]
59 0.04 ms
"START TRANSACTION"
Parameters:
[]
60 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
  "<em> __________ </em> artificial intelligence is integrated into medical diagnostics, early detection of diseases improves."
  437
  1319
  560
  519
  765
]
61 0.06 ms
"COMMIT"
Parameters:
[]
62 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:
[
  601
]
63 0.04 ms
"START TRANSACTION"
Parameters:
[]
64 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 urban areas, pollution levels were significantly higher compared to the surrounding countryside."
  601
  1319
  232
  478
  806
]
65 0.05 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:
[
  314
]
67 0.05 ms
"START TRANSACTION"
Parameters:
[]
68 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 impact of globalization on cultural identity was discussed; <em> __________ </em>, while it fosters diversity, it also leads to the erosion of local traditions."
  314
  1319
  642
  806
  560
]
69 0.10 ms
"COMMIT"
Parameters:
[]
70 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:
[
  724
]
71 0.04 ms
"START TRANSACTION"
Parameters:
[]
72 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 results from the first trial were inconclusive, but  __________  trials provided more consistent evidence."
  724
  1319
  601
  519
  232
]
73 0.04 ms
"COMMIT"
Parameters:
[]
74 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:
[
  765
]
75 0.04 ms
"START TRANSACTION"
Parameters:
[]
76 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 team faced several challenges during the project, but  __________ , they achieved their goals."
  765
  1319
  519
  232
  642
]
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:
[
  478
]
79 0.05 ms
"START TRANSACTION"
Parameters:
[]
80 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 new methodology is faster and more accurate  __________  traditional approaches."
  478
  1319
  601
  724
  232
]
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:
[
  560
]
83 0.04 ms
"START TRANSACTION"
Parameters:
[]
84 0.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 concept,  __________ , revolves around the idea of sustainable resource management."
  560
  1319
  519
  601
  232
]
85 0.08 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.