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

Query Metrics

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

Queries

Group similar statements

# Time Info
1 0.85 ms
SELECT t0.id AS id_1 FROM pack t0 WHERE t0.id = ?
Parameters:
[
  "20"
]
2 1.40 ms
"START TRANSACTION"
Parameters:
[]
3 0.16 ms
INSERT INTO quiz (pack_id) VALUES (?)
Parameters:
[
  20
]
4 0.06 ms
"COMMIT"
Parameters:
[]
5 0.43 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:
[
  20
]
6 0.36 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:
[
  676
]
7 0.18 ms
"START TRANSACTION"
Parameters:
[]
8 2.43 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> urban areas tend to have higher employment rates, they also face greater environmental challenges."
  676
  1630
  799
  348
  717
]
9 0.29 ms
"COMMIT"
Parameters:
[]
10 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:
[
  430
]
11 0.56 ms
"START TRANSACTION"
Parameters:
[]
12 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
  "The findings of this research are  __________  those reported in previous studies on the same topic."
  430
  1630
  717
  348
  307
]
13 0.07 ms
"COMMIT"
Parameters:
[]
14 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:
[
  758
]
15 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:
[
  307
]
16 0.09 ms
"START TRANSACTION"
Parameters:
[]
17 0.29 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
  "Several endangered species can still be found <em> __________ </em> the protected areas of the rainforest."
  307
  1630
  348
  512
  594
]
18 0.09 ms
"COMMIT"
Parameters:
[]
19 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:
[
  389
]
20 0.65 ms
"START TRANSACTION"
Parameters:
[]
21 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 findings suggest that early childhood education, <em> __________ </em> parental involvement, positively influences long-term academic success."
  389
  1630
  348
  676
  512
]
22 1.71 ms
"COMMIT"
Parameters:
[]
23 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:
[
  348
]
24 0.06 ms
"START TRANSACTION"
Parameters:
[]
25 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 study examined various economic factors,  __________  inflation rates, employment levels, and consumer spending habits."
  348
  1630
  676
  307
  799
]
26 0.30 ms
"COMMIT"
Parameters:
[]
27 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:
[
  102
]
28 0.04 ms
"START TRANSACTION"
Parameters:
[]
29 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
  " __________  technological advancements, the last decade has seen unprecedented growth in artificial intelligence."
  102
  1630
  676
  758
  348
]
30 0.04 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:
[
  512
]
32 1.48 ms
"START TRANSACTION"
Parameters:
[]
33 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
  " __________ , let's define the key terms used in this study."
  512
  1630
  594
  348
  635
]
34 0.05 ms
"COMMIT"
Parameters:
[]
35 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:
[
  799
]
36 0.54 ms
"START TRANSACTION"
Parameters:
[]
37 0.29 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 committee held a meeting to discuss issues  __________  budget allocation for the project."
  799
  1630
  676
  758
  348
]
38 1.32 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:
[
  635
]
40 0.03 ms
"START TRANSACTION"
Parameters:
[]
41 1.72 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 evidence is conclusive."
  635
  1630
  348
  307
  717
]
42 0.08 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:
[
  225
]
44 0.07 ms
"START TRANSACTION"
Parameters:
[]
45 0.47 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
  "I'm not sure if I want to move.  __________ , I'll miss my friends."
  225
  1630
  348
  717
  676
]
46 0.26 ms
"COMMIT"
Parameters:
[]
47 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:
[
  184
]
48 0.03 ms
"START TRANSACTION"
Parameters:
[]
49 0.20 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 team will proceed with the project  __________  they receive the required resources.</em>"
  184
  1630
  676
  717
  594
]
50 0.15 ms
"COMMIT"
Parameters:
[]
51 0.84 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:
[
  594
]
52 0.35 ms
"START TRANSACTION"
Parameters:
[]
53 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
  "<em> __________ , technology is both an opportunity and a challenge for the future of work.</em>"
  594
  1630
  635
  307
  389
]
54 0.09 ms
"COMMIT"
Parameters:
[]
55 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:
[
  471
]
56 0.08 ms
"START TRANSACTION"
Parameters:
[]
57 0.26 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 factory was  __________  operational within six months of its construction."
  471
  1630
  553
  717
  512
]
58 1.23 ms
"COMMIT"
Parameters:
[]
59 0.36 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:
[
  61
]
60 0.27 ms
"START TRANSACTION"
Parameters:
[]
61 0.20 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 history, many nations were undergoing significant social and political changes."
  61
  1630
  635
  717
  553
]
62 0.05 ms
"COMMIT"
Parameters:
[]
63 0.28 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:
[
  20
]
64 0.17 ms
"START TRANSACTION"
Parameters:
[]
65 0.98 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 discussion on climate change policies is crucial;  __________  environmental issues, recent studies highlight the impact of deforestation on global temperatures."
  20
  1630
  389
  594
  717
]
66 1.00 ms
"COMMIT"
Parameters:
[]
67 0.34 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:
[
  143
]
68 2.25 ms
"START TRANSACTION"
Parameters:
[]
69 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
  "climate change is a pressing global issue.  __________  is the recent increase in devastating hurricanes."
  143
  1630
  389
  676
  307
]
70 0.35 ms
"COMMIT"
Parameters:
[]
71 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:
[
  553
]
72 1.40 ms
"START TRANSACTION"
Parameters:
[]
73 0.75 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 a controlled environment;  __________ , the results were more reliable."
  553
  1630
  676
  799
  348
]
74 0.06 ms
"COMMIT"
Parameters:
[]
75 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:
[
  266
]
76 2.29 ms
"START TRANSACTION"
Parameters:
[]
77 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 weather has a significant impact on our mood."
  266
  1630
  307
  676
  635
]
78 0.05 ms
"COMMIT"
Parameters:
[]
79 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:
[
  717
]
80 2.18 ms
"START TRANSACTION"
Parameters:
[]
81 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 plants need to be watered  __________  to stay healthy."
  717
  1630
  594
  799
  389
]
82 0.93 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.