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

Query Metrics

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

Queries

Group similar statements

# Time Info
1 0.50 ms
SELECT t0.id AS id_1 FROM pack t0 WHERE t0.id = ?
Parameters:
[
  "10"
]
2 0.08 ms
"START TRANSACTION"
Parameters:
[]
3 0.21 ms
INSERT INTO quiz (pack_id) VALUES (?)
Parameters:
[
  10
]
4 0.09 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:
[
  10
]
6 0.76 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:
[
  748
]
7 0.08 ms
"START TRANSACTION"
Parameters:
[]
8 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 model remains accurate  __________  applied to entirely different datasets."
  748
  1036
  338
  379
  625
]
9 0.06 ms
"COMMIT"
Parameters:
[]
10 0.71 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:
[
  379
]
11 0.04 ms
"START TRANSACTION"
Parameters:
[]
12 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 medication proved effective in clinical trials, <em> __________ </em> its long-term side effects are still unknown."
  379
  1036
  543
  215
  625
]
13 0.06 ms
"COMMIT"
Parameters:
[]
14 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:
[
  174
]
15 0.04 ms
"START TRANSACTION"
Parameters:
[]
16 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 participants were instructed to complete the survey  __________  attending the workshop."
  174
  1036
  256
  338
  379
]
17 0.05 ms
"COMMIT"
Parameters:
[]
18 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:
[
  584
]
19 0.04 ms
"START TRANSACTION"
Parameters:
[]
20 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 company hired a consultant  __________  improving its marketing strategy."
  584
  1036
  707
  338
  748
]
21 0.05 ms
"COMMIT"
Parameters:
[]
22 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:
[
  461
]
23 0.05 ms
"START TRANSACTION"
Parameters:
[]
24 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 statistical model can be used  __________  to analyze small sample sizes but may not be reliable for larger datasets."
  461
  1036
  748
  379
  789
]
25 0.05 ms
"COMMIT"
Parameters:
[]
26 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:
[
  10
]
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 results of the study showed that the hypothesis was  __________  supported by the data."
  10
  1036
  256
  666
  51
]
29 0.04 ms
"COMMIT"
Parameters:
[]
30 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:
[
  707
]
31 0.05 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 literature review identified several gaps in existing studies.  __________ , it provided a comprehensive framework for future research."
  707
  1036
  666
  748
  379
]
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:
[
  338
]
35 0.04 ms
"START TRANSACTION"
Parameters:
[]
36 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
  "In the experimental setup, the microscope was placed  __________  the spectrometer to facilitate simultaneous data collection."
  338
  1036
  748
  666
  543
]
37 0.05 ms
"COMMIT"
Parameters:
[]
38 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:
[
  789
]
39 0.04 ms
"START TRANSACTION"
Parameters:
[]
40 0.13 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 downturn was primarily  __________  a decline in consumer spending during the recession."
  789
  1036
  748
  51
  625
]
41 0.05 ms
"COMMIT"
Parameters:
[]
42 0.22 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:
[
  256
]
43 0.03 ms
"START TRANSACTION"
Parameters:
[]
44 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
  " __________  of the recipes in this cookbook are difficult to follow."
  256
  1036
  789
  666
  625
]
45 0.04 ms
"COMMIT"
Parameters:
[]
46 0.40 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:
[
  133
]
47 0.04 ms
"START TRANSACTION"
Parameters:
[]
48 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 medication showed positive effects in trials,  __________  it had significant side effects in some patients."
  133
  1036
  543
  748
  338
]
49 0.06 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:
[
  502
]
51 0.04 ms
"START TRANSACTION"
Parameters:
[]
52 0.13 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 failed to comply with the regulations.  __________ , it faced heavy fines and penalties."
  502
  1036
  256
  666
  748
]
53 0.04 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:
[
  92
]
55 0.05 ms
"START TRANSACTION"
Parameters:
[]
56 0.12 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 yielded  __________  the results we predicted."
  92
  1036
  625
  748
  215
]
57 0.04 ms
"COMMIT"
Parameters:
[]
58 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:
[
  420
]
59 0.04 ms
"START TRANSACTION"
Parameters:
[]
60 0.13 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> __________  reducing emissions, public transportation systems have been expanded in urban areas.</em>"
  420
  1036
  338
  748
  666
]
61 0.04 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:
[
  297
]
63 0.04 ms
"START TRANSACTION"
Parameters:
[]
64 0.74 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 research highlights the role of diet in health outcomes,  __________  in the prevention of cardiovascular diseases."
  297
  1036
  10
  379
  707
]
65 0.05 ms
"COMMIT"
Parameters:
[]
66 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:
[
  215
]
67 0.05 ms
"START TRANSACTION"
Parameters:
[]
68 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 efficiency of renewable energy sources has been debated; <em> __________ </em>, the report presents case studies of countries successfully reducing their carbon footprint."
  215
  1036
  666
  707
  625
]
69 0.05 ms
"COMMIT"
Parameters:
[]
70 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:
[
  543
]
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 initial findings suggest a strong correlation;  __________ , further evidence will be provided to support this claim."
  543
  1036
  748
  789
  215
]
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:
[
  625
]
75 0.04 ms
"START TRANSACTION"
Parameters:
[]
76 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 marketing campaign was designed <em> __________ </em> attracting a broader international audience."
  625
  1036
  338
  666
  10
]
77 0.05 ms
"COMMIT"
Parameters:
[]
78 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:
[
  51
]
79 0.05 ms
"START TRANSACTION"
Parameters:
[]
80 0.13 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 focuses on renewable energy, which is  __________  an inexhaustible resource."
  51
  1036
  256
  338
  748
]
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:
[
  666
]
83 0.04 ms
"START TRANSACTION"
Parameters:
[]
84 0.13 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 clarifies that,  __________ , the policy change will affect only a small percentage of the population.""
  666
  1036
  625
  51
  789
]
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.