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

Query Metrics

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

Queries

Group similar statements

# Time Info
1 0.66 ms
SELECT t0.id AS id_1 FROM pack t0 WHERE t0.id = ?
Parameters:
[
  "2"
]
2 0.08 ms
"START TRANSACTION"
Parameters:
[]
3 0.22 ms
INSERT INTO quiz (pack_id) VALUES (?)
Parameters:
[
  2
]
4 0.07 ms
"COMMIT"
Parameters:
[]
5 0.28 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:
[
  2
]
6 0.32 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:
[
  43
]
7 0.05 ms
"START TRANSACTION"
Parameters:
[]
8 0.23 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 educational reforms highlighted key issues; <em> __________ </em>, policymakers must prioritize equitable access to quality education."
  43
  1643
  289
  494
  453
]
9 0.31 ms
"COMMIT"
Parameters:
[]
10 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:
[
  740
]
11 0.05 ms
"START TRANSACTION"
Parameters:
[]
12 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
  "The researchers initially focused on primary sources;  __________ , they conducted interviews with experts in the field."
  740
  1643
  617
  494
  699
]
13 0.05 ms
"COMMIT"
Parameters:
[]
14 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:
[
  2
]
15 0.05 ms
"START TRANSACTION"
Parameters:
[]
16 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 team developed an innovative solution and,  __________ , ensured it was scalable for global implementation. ""
  2
  1643
  453
  617
  658
]
17 0.05 ms
"COMMIT"
Parameters:
[]
18 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:
[
  125
]
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 novel explores complex themes, offering a compelling narrative that,  __________ , challenges societal norms."
  125
  1643
  781
  699
  658
]
21 0.05 ms
"COMMIT"
Parameters:
[]
22 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:
[
  658
]
23 0.05 ms
"START TRANSACTION"
Parameters:
[]
24 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 findings indicate that urban populations are  __________  to experience more severe heatwaves in the coming decades. ""
  658
  1643
  453
  576
  617
]
25 0.04 ms
"COMMIT"
Parameters:
[]
26 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:
[
  535
]
27 0.04 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 researcher proposed a new framework for data encryption; <em> __________ </em>, the system integrates quantum computing principles to enhance security."
  535
  1643
  494
  576
  740
]
29 0.04 ms
"COMMIT"
Parameters:
[]
30 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:
[
  453
]
31 0.04 ms
"START TRANSACTION"
Parameters:
[]
32 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> __________ , longer essays require more comprehensive research to support their arguments.</em> ""
  453
  1643
  617
  740
  289
]
33 0.04 ms
"COMMIT"
Parameters:
[]
34 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:
[
  289
]
35 0.05 ms
"START TRANSACTION"
Parameters:
[]
36 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 evidence supported the hypothesis;  __________ , the theory was accepted by the scientific community.""
  289
  1643
  453
  699
  494
]
37 0.06 ms
"COMMIT"
Parameters:
[]
38 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:
[
  371
]
39 0.04 ms
"START TRANSACTION"
Parameters:
[]
40 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 construction of the new facility will begin  __________  the necessary permits are obtained. ""
  371
  1643
  617
  658
  699
]
41 0.37 ms
"COMMIT"
Parameters:
[]
42 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:
[
  617
]
43 0.10 ms
"START TRANSACTION"
Parameters:
[]
44 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 protective c __________  was placed  __________  the samples to prevent contamination."
  617
  1643
  494
  658
  781
]
45 0.05 ms
"COMMIT"
Parameters:
[]
46 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:
[
  330
]
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 project required  __________  500 hours of work to be completed successfully.""
  330
  1643
  576
  740
  617
]
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:
[
  248
]
51 0.04 ms
"START TRANSACTION"
Parameters:
[]
52 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 software update is being developed;  __________ , users are advised to rely on the existing version."
  248
  1643
  453
  289
  781
]
53 0.04 ms
"COMMIT"
Parameters:
[]
54 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:
[
  781
]
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
  "After many years of research, scientists  __________  found a cure for the disease."
  781
  1643
  617
  740
  699
]
57 0.04 ms
"COMMIT"
Parameters:
[]
58 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:
[
  166
]
59 0.05 ms
"START TRANSACTION"
Parameters:
[]
60 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 findings of the study are  __________  consistent with previous research in the field.""
  166
  1643
  494
  289
  617
]
61 0.04 ms
"COMMIT"
Parameters:
[]
62 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:
[
  84
]
63 0.05 ms
"START TRANSACTION"
Parameters:
[]
64 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 museum features exhibits on art and history  __________  different periods, from antiquity to modern times."
  84
  1643
  494
  699
  535
]
65 0.04 ms
"COMMIT"
Parameters:
[]
66 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:
[
  576
]
67 0.04 ms
"START TRANSACTION"
Parameters:
[]
68 0.69 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 reveals significant inconsistencies,  __________  among the most controlled experiments."
  576
  1643
  781
  699
  453
]
69 0.07 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:
[
  494
]
71 0.04 ms
"START TRANSACTION"
Parameters:
[]
72 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
  "The experiment involved several variables,  __________  temperature, pressure, and humidity, to ensure accurate results. ""
  494
  1643
  617
  658
  289
]
73 0.23 ms
"COMMIT"
Parameters:
[]
74 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:
[
  412
]
75 0.03 ms
"START TRANSACTION"
Parameters:
[]
76 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
  "There are  __________  books on the shelf that might interest you."
  412
  1643
  576
  658
  535
]
77 0.07 ms
"COMMIT"
Parameters:
[]
78 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:
[
  699
]
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 experiment lasted  __________  three hours, during which data were collected at regular intervals."
  699
  1643
  289
  658
  617
]
81 0.04 ms
"COMMIT"
Parameters:
[]
82 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:
[
  207
]
83 0.05 ms
"START TRANSACTION"
Parameters:
[]
84 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 study revealed some inconsistencies;  __________ , however, the results support the initial hypothesis."
  207
  1643
  658
  576
  535
]
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.