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

Query Metrics

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

Queries

Group similar statements

# Time Info
1 0.48 ms
SELECT t0.id AS id_1 FROM pack t0 WHERE t0.id = ?
Parameters:
[
  "12"
]
2 0.09 ms
"START TRANSACTION"
Parameters:
[]
3 0.19 ms
INSERT INTO quiz (pack_id) VALUES (?)
Parameters:
[
  12
]
4 0.08 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:
[
  12
]
6 0.06 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:
[
  709
]
7 0.04 ms
"START TRANSACTION"
Parameters:
[]
8 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 data must be validated  __________  it can be included in the final report."
  709
  1035
  463
  545
  791
]
9 0.06 ms
"COMMIT"
Parameters:
[]
10 0.38 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:
[
  463
]
11 0.04 ms
"START TRANSACTION"
Parameters:
[]
12 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
  "<em> __________  urban development is concerned, the city has adopted several sustainable practices.</em>"
  463
  1035
  12
  504
  586
]
13 0.05 ms
"COMMIT"
Parameters:
[]
14 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:
[
  299
]
15 0.06 ms
"START TRANSACTION"
Parameters:
[]
16 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 author argues that,  __________ , the historical event had a much broader impact than commonly acknowledged.""
  299
  1035
  750
  586
  545
]
17 0.04 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:
[
  627
]
19 0.04 ms
"START TRANSACTION"
Parameters:
[]
20 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 new highway runs  __________  the eastern border of the city."
  627
  1035
  340
  12
  586
]
21 0.04 ms
"COMMIT"
Parameters:
[]
22 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:
[
  12
]
23 0.05 ms
"START TRANSACTION"
Parameters:
[]
24 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 new product is not only more efficient, but  __________ , it is also more environmentally friendly."
  12
  1035
  668
  463
  545
]
25 0.05 ms
"COMMIT"
Parameters:
[]
26 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:
[
  750
]
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
  " __________ , the organizers contacted all participants to confirm their availability for the event. ""
  750
  1035
  504
  791
  12
]
29 0.04 ms
"COMMIT"
Parameters:
[]
30 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:
[
  135
]
31 0.03 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 findings highlight the need for improved public health policies in urban areas."
  135
  1035
  463
  750
  504
]
33 0.04 ms
"COMMIT"
Parameters:
[]
34 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:
[
  791
]
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
  "The company prioritized cost reduction strategies;  __________ , it managed to maintain product quality."
  791
  1035
  668
  463
  504
]
37 0.04 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:
[
  381
]
39 0.03 ms
"START TRANSACTION"
Parameters:
[]
40 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 experimental psychology, researchers <em> __________ </em> conduct multiple trials to confirm the validity of their findings."
  381
  1035
  627
  586
  791
]
41 0.05 ms
"COMMIT"
Parameters:
[]
42 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:
[
  94
]
43 0.04 ms
"START TRANSACTION"
Parameters:
[]
44 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> __________  the results, they were consistent with our initial predictions.</em>"
  94
  1035
  668
  627
  504
]
45 0.04 ms
"COMMIT"
Parameters:
[]
46 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:
[
  504
]
47 0.03 ms
"START TRANSACTION"
Parameters:
[]
48 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 research team encounters logistical challenges  __________ , but they usually find solutions quickly. ""
  504
  1035
  586
  340
  627
]
49 0.04 ms
"COMMIT"
Parameters:
[]
50 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:
[
  217
]
51 0.10 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 research indicates a strong correlation between diet and mental health; <em> __________ </em>, further studies are necessary to establish causation rather than mere association."
  217
  1035
  545
  627
  504
]
53 0.04 ms
"COMMIT"
Parameters:
[]
54 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:
[
  176
]
55 0.04 ms
"START TRANSACTION"
Parameters:
[]
56 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 policy has faced criticism in certain areas;  __________ , it has been well received by the public."
  176
  1035
  12
  627
  586
]
57 0.05 ms
"COMMIT"
Parameters:
[]
58 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:
[
  340
]
59 0.04 ms
"START TRANSACTION"
Parameters:
[]
60 0.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
  " __________  everyone has the right to pursue their dreams."
  340
  1035
  463
  750
  791
]
61 0.20 ms
"COMMIT"
Parameters:
[]
62 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:
[
  545
]
63 0.10 ms
"START TRANSACTION"
Parameters:
[]
64 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 policy underwent significant revisions;  __________ , it received unanimous approval from the committee."
  545
  1035
  12
  750
  627
]
65 0.05 ms
"COMMIT"
Parameters:
[]
66 0.06 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:
[
  258
]
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 experiment demonstrated that <em> __________ </em> oxygen, cellular respiration cannot occur."
  258
  1035
  791
  750
  12
]
69 0.04 ms
"COMMIT"
Parameters:
[]
70 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:
[
  422
]
71 0.04 ms
"START TRANSACTION"
Parameters:
[]
72 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 patient's condition worsened  __________  after surgery."
  422
  1035
  668
  340
  627
]
73 0.04 ms
"COMMIT"
Parameters:
[]
74 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:
[
  586
]
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 new policy has  __________  altered the way companies report their financial transactions."
  586
  1035
  750
  463
  504
]
77 0.06 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:
[
  53
]
79 0.04 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 patient showed significant improvement after the initial treatment."
  53
  1035
  791
  627
  463
]
81 0.05 ms
"COMMIT"
Parameters:
[]
82 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:
[
  668
]
83 0.05 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 experiment was a failure;  __________ , the data collected provided valuable insights into the problem."
  668
  1035
  750
  791
  340
]
85 0.04 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.