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

Query Metrics

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

Queries

Group similar statements

# Time Info
1 0.38 ms
SELECT t0.id AS id_1 FROM pack t0 WHERE t0.id = ?
Parameters:
[
  "1"
]
2 0.09 ms
"START TRANSACTION"
Parameters:
[]
3 0.24 ms
INSERT INTO quiz (pack_id) VALUES (?)
Parameters:
[
  1
]
4 0.07 ms
"COMMIT"
Parameters:
[]
5 0.40 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:
[
  1
]
6 0.25 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:
[
  493
]
7 0.05 ms
"START TRANSACTION"
Parameters:
[]
8 0.26 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. (Eventualmente, após muitos anos de pesquisa, os cientistas encontraram uma cura para a doença.)"
  493
  1297
  411
  1
  329
]
9 0.06 ms
"COMMIT"
Parameters:
[]
10 0.33 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:
[
  411
]
11 0.04 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 experiment yielded unexpected results, and <em> __________ </em>, we need further testing before drawing any conclusions."
  411
  1297
  493
  575
  370
]
13 0.05 ms
"COMMIT"
Parameters:
[]
14 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:
[
  698
]
15 0.04 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
  "Many believed the technology would complicate the process;  __________ , it has streamlined operations and improved efficiency."
  698
  1297
  657
  411
  370
]
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:
[
  534
]
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 introduction of automation has led to increased productivity in manufacturing;  __________ , digital tools have revolutionized efficiency in administrative tasks."
  534
  1297
  739
  411
  493
]
21 0.05 ms
"COMMIT"
Parameters:
[]
22 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:
[
  165
]
23 0.05 ms
"START TRANSACTION"
Parameters:
[]
24 0.44 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 interviews, the candidates were asked about their previous experiences in similar roles."
  165
  1297
  739
  780
  370
]
25 0.17 ms
"COMMIT"
Parameters:
[]
26 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:
[
  780
]
27 0.05 ms
"START TRANSACTION"
Parameters:
[]
28 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
  "" __________  historical data supports the theory that trade networks were crucial to ancient civilizations.""
  780
  1297
  657
  493
  329
]
29 0.05 ms
"COMMIT"
Parameters:
[]
30 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:
[
  83
]
31 0.06 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
  " __________ , the study highlights the importance of sustainable agricultural practices in ensuring long-term food security."
  83
  1297
  698
  780
  657
]
33 0.04 ms
"COMMIT"
Parameters:
[]
34 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:
[
  575
]
35 0.04 ms
"START TRANSACTION"
Parameters:
[]
36 1.30 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 a pattern in urban migration trends;  __________ , rural areas showed a similar demographic shift."
  575
  1297
  657
  411
  739
]
37 0.23 ms
"COMMIT"
Parameters:
[]
38 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:
[
  370
]
39 0.04 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
  " __________ , the research found that there is a strong correlation between education and income."
  370
  1297
  698
  575
  616
]
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:
[
  247
]
43 0.05 ms
"START TRANSACTION"
Parameters:
[]
44 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 new policy is  __________  to reduce emissions significantly, according to recent simulations."
  247
  1297
  657
  411
  329
]
45 0.07 ms
"COMMIT"
Parameters:
[]
46 0.46 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:
[
  1
]
47 0.04 ms
"START TRANSACTION"
Parameters:
[]
48 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 study results were inconclusive  __________  the small sample size and lack of control variables."
  1
  1297
  616
  575
  370
]
49 0.05 ms
"COMMIT"
Parameters:
[]
50 0.86 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:
[
  657
]
51 0.04 ms
"START TRANSACTION"
Parameters:
[]
52 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 city has many historical landmarks,  __________ , the Eiffel Tower and the Louvre Museum."
  657
  1297
  616
  411
  575
]
53 0.05 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:
[
  42
]
55 0.05 ms
"START TRANSACTION"
Parameters:
[]
56 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
  " __________ , this discovery represents one of the most significant breakthroughs in medical research."
  42
  1297
  83
  493
  370
]
57 0.05 ms
"COMMIT"
Parameters:
[]
58 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:
[
  124
]
59 0.04 ms
"START TRANSACTION"
Parameters:
[]
60 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 findings challenge traditional theories,  __________  those considered foundational in the field."
  124
  1297
  411
  780
  370
]
61 0.30 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:
[
  329
]
63 0.06 ms
"START TRANSACTION"
Parameters:
[]
64 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 author argues that climate change poses a significant threat;  __________ , recent data supports this claim."
  329
  1297
  698
  780
  1
]
65 0.05 ms
"COMMIT"
Parameters:
[]
66 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:
[
  452
]
67 0.04 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 team performed well overall, but  __________ , they faced challenges due to lack of communication. ""
  452
  1297
  698
  329
  493
]
69 0.04 ms
"COMMIT"
Parameters:
[]
70 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:
[
  288
]
71 0.05 ms
"START TRANSACTION"
Parameters:
[]
72 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 professor explained that the hypothesis cannot be validated <em> __________ </em> further experiments are conducted."
  288
  1297
  780
  83
  411
]
73 0.05 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:
[
  206
]
75 0.04 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
  "The temperature in the region dropped  __________  during the winter months, impacting agricultural production."
  206
  1297
  698
  493
  616
]
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:
[
  739
]
79 0.04 ms
"START TRANSACTION"
Parameters:
[]
80 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 theory, though widely accepted, has  __________  been fully tested in real-world scenarios."
  739
  1297
  1
  698
  493
]
81 0.04 ms
"COMMIT"
Parameters:
[]
82 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:
[
  616
]
83 0.04 ms
"START TRANSACTION"
Parameters:
[]
84 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 analysis focuses on <em> __________ </em> economic growth can be sustained without increasing environmental damage."
  616
  1297
  493
  739
  1
]
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.