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

Query Metrics

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

Queries

Group similar statements

# Time Info
1 0.28 ms
SELECT t0.id AS id_1 FROM pack t0 WHERE t0.id = ?
Parameters:
[
  "24"
]
2 0.07 ms
"START TRANSACTION"
Parameters:
[]
3 0.19 ms
INSERT INTO quiz (pack_id) VALUES (?)
Parameters:
[
  24
]
4 0.06 ms
"COMMIT"
Parameters:
[]
5 0.79 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:
[
  24
]
6 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:
[
  24
]
7 0.05 ms
"START TRANSACTION"
Parameters:
[]
8 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
  "The performance had its flaws, but  __________ , it was an enjoyable evening for the audience."
  24
  1633
  65
  803
  721
]
9 0.06 ms
"COMMIT"
Parameters:
[]
10 0.26 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:
[
  311
]
11 0.05 ms
"START TRANSACTION"
Parameters:
[]
12 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 effectiveness of the new teaching methodology was tested  __________  schools in both rural and urban areas."
  311
  1633
  434
  680
  24
]
13 0.04 ms
"COMMIT"
Parameters:
[]
14 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:
[
  393
]
15 0.03 ms
"START TRANSACTION"
Parameters:
[]
16 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 results of the experiment, while generally consistent, deviated  __________  due to external factors."
  393
  1633
  557
  721
  598
]
17 0.04 ms
"COMMIT"
Parameters:
[]
18 0.15 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:
[
  147
]
19 0.04 ms
"START TRANSACTION"
Parameters:
[]
20 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 economic impact of technological advancements can be seen in multiple sectors,  __________ , manufacturing, finance, and healthcare."
  147
  1633
  598
  434
  65
]
21 0.04 ms
"COMMIT"
Parameters:
[]
22 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:
[
  762
]
23 0.04 ms
"START TRANSACTION"
Parameters:
[]
24 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
  " __________  she is allergic to peanuts, she cannot eat this cake."
  762
  1633
  598
  721
  24
]
25 0.04 ms
"COMMIT"
Parameters:
[]
26 0.16 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:
[
  106
]
27 0.05 ms
"START TRANSACTION"
Parameters:
[]
28 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
  " __________ , animals should be treated with respect."
  106
  1633
  598
  434
  680
]
29 0.05 ms
"COMMIT"
Parameters:
[]
30 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:
[
  598
]
31 0.04 ms
"START TRANSACTION"
Parameters:
[]
32 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 lack of clear guidelines for implementing the proposed policy."
  598
  1633
  680
  434
  721
]
33 0.04 ms
"COMMIT"
Parameters:
[]
34 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:
[
  352
]
35 0.04 ms
"START TRANSACTION"
Parameters:
[]
36 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
  " __________  upon graduation, she began her job search."
  352
  1633
  803
  24
  598
]
37 0.34 ms
"COMMIT"
Parameters:
[]
38 0.16 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:
[
  639
]
39 0.04 ms
"START TRANSACTION"
Parameters:
[]
40 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>, renewable energy sources will play a crucial role in reducing global carbon emissions in the coming decades."
  639
  1633
  762
  65
  24
]
41 0.04 ms
"COMMIT"
Parameters:
[]
42 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:
[
  680
]
43 0.05 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 lack of investment in infrastructure has hindered economic development in rural regions."
  680
  1633
  65
  762
  24
]
45 0.04 ms
"COMMIT"
Parameters:
[]
46 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:
[
  557
]
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
  "<em> __________  the results are available, they will be published on the website.</em>"
  557
  1633
  147
  721
  598
]
49 0.04 ms
"COMMIT"
Parameters:
[]
50 0.17 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:
[
  229
]
51 0.04 ms
"START TRANSACTION"
Parameters:
[]
52 0.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
  "<em>The study revealed significant changes in behavior  __________  prolonged exposure to stress.</em> ""
  229
  1633
  311
  65
  803
]
53 0.05 ms
"COMMIT"
Parameters:
[]
54 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:
[
  188
]
55 0.04 ms
"START TRANSACTION"
Parameters:
[]
56 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
  "<em>The patient delayed seeking medical attention.  __________ , the illness progressed to a critical stage.</em>"
  188
  1633
  557
  434
  311
]
57 0.04 ms
"COMMIT"
Parameters:
[]
58 0.16 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:
[
  803
]
59 0.04 ms
"START TRANSACTION"
Parameters:
[]
60 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 success of similar projects in other countries  __________  suggests that this model could be applied in developing nations as well."
  803
  1633
  311
  65
  762
]
61 0.04 ms
"COMMIT"
Parameters:
[]
62 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:
[
  721
]
63 0.05 ms
"START TRANSACTION"
Parameters:
[]
64 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 death penalty is cruel and unusual punishment."
  721
  1633
  434
  557
  598
]
65 0.04 ms
"COMMIT"
Parameters:
[]
66 0.16 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:
[
  270
]
67 0.04 ms
"START TRANSACTION"
Parameters:
[]
68 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 organization issued a statement  __________  its commitment to reducing carbon emissions by 2030."
  270
  1633
  311
  721
  147
]
69 0.30 ms
"COMMIT"
Parameters:
[]
70 0.19 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:
[
  434
]
71 0.05 ms
"START TRANSACTION"
Parameters:
[]
72 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 data shows that <em> __________ </em> rainfall patterns have been significantly affected by climate change."
  434
  1633
  147
  762
  24
]
73 0.05 ms
"COMMIT"
Parameters:
[]
74 0.16 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:
[
  475
]
75 0.04 ms
"START TRANSACTION"
Parameters:
[]
76 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 researchers identified a potential flaw in the study;  __________ , they revised their methodology to improve accuracy."
  475
  1633
  680
  721
  434
]
77 0.06 ms
"COMMIT"
Parameters:
[]
78 0.17 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:
[
  516
]
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 participants completed a questionnaire  __________  watching the instructional video to assess their understanding."
  516
  1633
  65
  147
  598
]
81 0.06 ms
"COMMIT"
Parameters:
[]
82 0.17 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:
[
  65
]
83 0.04 ms
"START TRANSACTION"
Parameters:
[]
84 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 success of the intervention can be  __________  attributed to the active involvement of local communities."
  65
  1633
  598
  557
  680
]
85 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.