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

Query Metrics

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

Queries

Group similar statements

# Time Info
1 0.59 ms
SELECT t0.id AS id_1 FROM pack t0 WHERE t0.id = ?
Parameters:
[
  "4"
]
2 0.08 ms
"START TRANSACTION"
Parameters:
[]
3 1.40 ms
INSERT INTO quiz (pack_id) VALUES (?)
Parameters:
[
  4
]
4 0.10 ms
"COMMIT"
Parameters:
[]
5 0.64 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.53 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
]
7 0.04 ms
"START TRANSACTION"
Parameters:
[]
8 5.49 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 economic recovery has been slow  __________ , but experts predict improvement in the coming months."
  742
  1280
  4
  168
  86
]
9 0.11 ms
"COMMIT"
Parameters:
[]
10 0.39 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
]
11 0.07 ms
"START TRANSACTION"
Parameters:
[]
12 7.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 findings suggest that early childhood education has lasting benefits; <em> __________ </em>, children who attend preschool tend to perform better academically in later years."
  660
  1280
  783
  4
  127
]
13 0.16 ms
"COMMIT"
Parameters:
[]
14 0.33 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
]
15 0.07 ms
"START TRANSACTION"
Parameters:
[]
16 6.79 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 provided networking opportunities  __________  informative keynote sessions."
  209
  1280
  742
  168
  660
]
17 0.10 ms
"COMMIT"
Parameters:
[]
18 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:
[
  496
]
19 0.04 ms
"START TRANSACTION"
Parameters:
[]
20 9.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
  "The experiment's final results will be published in the next quarter; <em> __________ </em>, researchers will continue collecting data."
  496
  1280
  414
  660
  168
]
21 0.11 ms
"COMMIT"
Parameters:
[]
22 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:
[
  414
]
23 0.13 ms
"START TRANSACTION"
Parameters:
[]
24 1.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
  "The reduction in greenhouse gas emissions was  __________  offset by the increase in industrial activity in other sectors."
  414
  1280
  4
  86
  168
]
25 0.08 ms
"COMMIT"
Parameters:
[]
26 0.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:
[
  168
]
27 0.10 ms
"START TRANSACTION"
Parameters:
[]
28 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 camera captured images of the processes occurring  __________  the engine while it was in operation. ""
  168
  1280
  701
  127
  783
]
29 0.05 ms
"COMMIT"
Parameters:
[]
30 0.43 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
]
31 0.08 ms
"START TRANSACTION"
Parameters:
[]
32 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 financial aid package, the university provides mentorship programs for new students."
  619
  1280
  783
  168
  660
]
33 0.08 ms
"COMMIT"
Parameters:
[]
34 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:
[
  291
]
35 0.09 ms
"START TRANSACTION"
Parameters:
[]
36 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 company  __________  complies with environmental regulations, yet investigations have revealed multiple violations."
  291
  1280
  86
  168
  127
]
37 0.23 ms
"COMMIT"
Parameters:
[]
38 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:
[
  4
]
39 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:
[
  127
]
40 0.07 ms
"START TRANSACTION"
Parameters:
[]
41 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 report analyzes the data  __________ , revealing some interesting patterns."
  127
  1280
  701
  168
  660
]
42 0.10 ms
"COMMIT"
Parameters:
[]
43 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:
[
  455
]
44 0.09 ms
"START TRANSACTION"
Parameters:
[]
45 0.97 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 indicate a strong correlation between the variables.  __________ , they suggest a causal relationship."
  455
  1280
  742
  660
  86
]
46 0.13 ms
"COMMIT"
Parameters:
[]
47 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:
[
  86
]
48 0.07 ms
"START TRANSACTION"
Parameters:
[]
49 0.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
  " __________  we reduce carbon emissions by half; the environmental benefits would become apparent within a decade."
  86
  1280
  168
  742
  127
]
50 0.16 ms
"COMMIT"
Parameters:
[]
51 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:
[
  332
]
52 0.09 ms
"START TRANSACTION"
Parameters:
[]
53 0.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
  " __________ , the global economy has recovered from the effects of the recent recession."
  332
  1280
  414
  86
  742
]
54 0.12 ms
"COMMIT"
Parameters:
[]
55 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:
[
  373
]
56 0.05 ms
"START TRANSACTION"
Parameters:
[]
57 0.30 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 conference will focus on renewable energy,  __________  as the role of policy in shaping sustainable practices.</em> ""
  373
  1280
  86
  742
  127
]
58 0.11 ms
"COMMIT"
Parameters:
[]
59 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:
[
  783
]
60 0.05 ms
"START TRANSACTION"
Parameters:
[]
61 0.71 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 policy is  __________  reduce carbon emissions by encouraging the use of renewable energy sources."
  783
  1280
  4
  619
  168
]
62 0.10 ms
"COMMIT"
Parameters:
[]
63 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:
[
  250
]
64 0.11 ms
"START TRANSACTION"
Parameters:
[]
65 0.85 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 benefited from small class sizes,  __________ , they had access to personalized mentoring sessions."
  250
  1280
  742
  783
  701
]
66 0.17 ms
"COMMIT"
Parameters:
[]
67 0.12 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
]
68 0.04 ms
"START TRANSACTION"
Parameters:
[]
69 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 company invested in research and development  __________  it could stay competitive."
  537
  1280
  127
  4
  86
]
70 0.15 ms
"COMMIT"
Parameters:
[]
71 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:
[
  45
]
72 0.24 ms
"START TRANSACTION"
Parameters:
[]
73 0.92 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 authors presented the hypothesis in the first section;  __________ , they provided evidence supporting their claims through case studies."
  45
  1280
  127
  660
  619
]
74 0.21 ms
"COMMIT"
Parameters:
[]
75 0.55 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
]
76 1.96 ms
"START TRANSACTION"
Parameters:
[]
77 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
  "The students were allowed to retake the exam  __________  they submitted a formal request in advance."
  578
  1280
  4
  127
  168
]
78 0.81 ms
"COMMIT"
Parameters:
[]
79 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:
[
  701
]
80 0.48 ms
"START TRANSACTION"
Parameters:
[]
81 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
  "If we  __________  that climate change is accelerating, immediate policy changes will be necessary to mitigate its effects."
  701
  1280
  4
  783
  168
]
82 0.16 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.