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

Query Metrics

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

Queries

Group similar statements

# Time Info
1 0.33 ms
SELECT t0.id AS id_1 FROM pack t0 WHERE t0.id = ?
Parameters:
[
  "29"
]
2 0.07 ms
"START TRANSACTION"
Parameters:
[]
3 0.21 ms
INSERT INTO quiz (pack_id) VALUES (?)
Parameters:
[
  29
]
4 0.06 ms
"COMMIT"
Parameters:
[]
5 0.83 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:
[
  29
]
6 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:
[
  685
]
7 0.04 ms
"START TRANSACTION"
Parameters:
[]
8 1.06 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 scientist estimated that the experiment would take  __________  three weeks to complete.""
  685
  1611
  275
  29
  767
]
9 0.06 ms
"COMMIT"
Parameters:
[]
10 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:
[
  808
]
11 0.07 ms
"START TRANSACTION"
Parameters:
[]
12 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 study highlights the importance of sustainable agricultural practices in ensuring long-term food security."
  808
  1611
  562
  152
  234
]
13 0.04 ms
"COMMIT"
Parameters:
[]
14 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:
[
  398
]
15 0.04 ms
"START TRANSACTION"
Parameters:
[]
16 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 study reviewed existing literature,  __________  proposed a new theoretical framework to explain the findings."
  398
  1611
  808
  29
  562
]
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:
[
  275
]
19 0.04 ms
"START TRANSACTION"
Parameters:
[]
20 1.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
  " __________  historical records are incomplete, how can historians reconstruct past events with accuracy?""
  275
  1611
  562
  29
  644
]
21 0.22 ms
"COMMIT"
Parameters:
[]
22 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:
[
  152
]
23 0.04 ms
"START TRANSACTION"
Parameters:
[]
24 0.63 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
  "Genetic modifications can improve crop yields; <em> __________ </em>, they also raise concerns about biodiversity and long-term ecological impact."
  152
  1611
  644
  808
  480
]
25 0.04 ms
"COMMIT"
Parameters:
[]
26 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:
[
  357
]
27 0.04 ms
"START TRANSACTION"
Parameters:
[]
28 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
  "From the findings,  __________  early intervention in education significantly improves student outcomes."
  357
  1611
  152
  644
  480
]
29 0.04 ms
"COMMIT"
Parameters:
[]
30 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:
[
  29
]
31 0.03 ms
"START TRANSACTION"
Parameters:
[]
32 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 results in Figure 3 are displayed  __________ , while the control group data is plotted on the right."
  29
  1611
  808
  480
  767
]
33 0.04 ms
"COMMIT"
Parameters:
[]
34 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:
[
  439
]
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 effectiveness of the new policy will,  __________ , depend on its proper implementation and enforcement."
  439
  1611
  234
  562
  808
]
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:
[
  111
]
39 0.03 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 experiment is successful, we can publish the results."
  111
  1611
  603
  644
  152
]
41 0.04 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:
[
  562
]
43 0.04 ms
"START TRANSACTION"
Parameters:
[]
44 0.65 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 mechanism of this enzyme is  __________  a lock and key, where the substrate fits perfectly."
  562
  1611
  480
  29
  603
]
45 0.04 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:
[
  726
]
47 0.04 ms
"START TRANSACTION"
Parameters:
[]
48 0.63 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 survey, 70% of respondents prefer online learning over traditional methods.""
  726
  1611
  767
  603
  234
]
49 0.04 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:
[
  234
]
51 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:
[
  70
]
52 0.04 ms
"START TRANSACTION"
Parameters:
[]
53 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
  " __________  in urban settings, the demand for public transportation has increased substantially."
  70
  1611
  152
  808
  29
]
54 0.23 ms
"COMMIT"
Parameters:
[]
55 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:
[
  480
]
56 0.04 ms
"START TRANSACTION"
Parameters:
[]
57 0.64 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
  "Urban areas are becoming overcrowded.  __________  is the rapid population growth in megacities like Tokyo and Mumbai."
  480
  1611
  726
  29
  644
]
58 0.04 ms
"COMMIT"
Parameters:
[]
59 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:
[
  521
]
60 0.03 ms
"START TRANSACTION"
Parameters:
[]
61 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 was conducted in three stages;  __________ , the results confirmed the initial hypothesis."
  521
  1611
  603
  480
  275
]
62 0.04 ms
"COMMIT"
Parameters:
[]
63 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:
[
  767
]
64 0.04 ms
"START TRANSACTION"
Parameters:
[]
65 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 experiment yielded unexpected results;  __________  anomalies, similar discrepancies were observed in previous studies."
  767
  1611
  275
  644
  29
]
66 0.04 ms
"COMMIT"
Parameters:
[]
67 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:
[
  193
]
68 0.05 ms
"START TRANSACTION"
Parameters:
[]
69 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 research highlights that the impact of pollution on marine life is <em> __________ </em> devastating."
  193
  1611
  603
  152
  808
]
70 0.04 ms
"COMMIT"
Parameters:
[]
71 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:
[
  603
]
72 0.04 ms
"START TRANSACTION"
Parameters:
[]
73 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 had  __________  implemented a different strategy, but it was later revised."
  603
  1611
  767
  562
  808
]
74 0.04 ms
"COMMIT"
Parameters:
[]
75 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:
[
  644
]
76 0.04 ms
"START TRANSACTION"
Parameters:
[]
77 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 experiment failed,  __________  we followed the instructions carefully."
  644
  1611
  603
  29
  562
]
78 0.04 ms
"COMMIT"
Parameters:
[]
79 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:
[
  316
]
80 0.04 ms
"START TRANSACTION"
Parameters:
[]
81 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 professor will publish a revised edition of the textbook next year; <em> __________ </em>, students should refer to the current version for their studies."
  316
  1611
  726
  275
  767
]
82 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.