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

Query Metrics

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

Queries

Group similar statements

# Time Info
1 0.10 ms
SELECT t0.id AS id_1 FROM pack t0 WHERE t0.id = ?
Parameters:
[
  "1"
]
2 0.13 ms
"START TRANSACTION"
Parameters:
[]
3 0.29 ms
INSERT INTO quiz (pack_id) VALUES (?)
Parameters:
[
  1
]
4 0.43 ms
"COMMIT"
Parameters:
[]
5 0.51 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.31 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
]
7 0.07 ms
"START TRANSACTION"
Parameters:
[]
8 0.37 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 crisis affected the labor market in Europe;  __________ , North American countries experienced a rise in unemployment rates."
  534
  1616
  616
  411
  83
]
9 0.09 ms
"COMMIT"
Parameters:
[]
10 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:
[
  1
]
11 0.06 ms
"START TRANSACTION"
Parameters:
[]
12 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
  "The experiment was delayed  __________  equipment malfunctions in the laboratory."
  1
  1616
  83
  493
  739
]
13 0.26 ms
"COMMIT"
Parameters:
[]
14 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:
[
  698
]
15 0.06 ms
"START TRANSACTION"
Parameters:
[]
16 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 data does not suggest a decline in productivity;  __________ , it highlights a steady increase over the past decade."
  698
  1616
  657
  493
  329
]
17 0.06 ms
"COMMIT"
Parameters:
[]
18 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:
[
  165
]
19 0.05 ms
"START TRANSACTION"
Parameters:
[]
20 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 data was analyzed  __________  the final phase of the project to ensure its accuracy."
  165
  1616
  739
  1
  780
]
21 0.05 ms
"COMMIT"
Parameters:
[]
22 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:
[
  206
]
23 0.05 ms
"START TRANSACTION"
Parameters:
[]
24 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 population of the city has grown  __________  over the last two decades due to increased urbanization."
  206
  1616
  698
  493
  411
]
25 0.05 ms
"COMMIT"
Parameters:
[]
26 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:
[
  493
]
27 0.05 ms
"START TRANSACTION"
Parameters:
[]
28 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
  "I am sure that  __________  you will understand. (Tenho certeza que eventualmente você entenderá.)"
  493
  1616
  575
  657
  411
]
29 0.06 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:
[
  329
]
31 0.06 ms
"START TRANSACTION"
Parameters:
[]
32 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 findings were consistent across all regions;  __________ , they showed a remarkable degree of uniformity."
  329
  1616
  698
  370
  493
]
33 0.07 ms
"COMMIT"
Parameters:
[]
34 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:
[
  411
]
35 0.05 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 literature review presents several perspectives on the subject; <em> __________ </em>, some of them lack substantial empirical evidence."
  411
  1616
  657
  493
  329
]
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:
[
  780
]
39 0.04 ms
"START TRANSACTION"
Parameters:
[]
40 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
  "" __________  historical data supports the theory that trade networks were crucial to ancient civilizations.""
  780
  1616
  83
  698
  657
]
41 0.04 ms
"COMMIT"
Parameters:
[]
42 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:
[
  247
]
43 0.05 ms
"START TRANSACTION"
Parameters:
[]
44 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 data suggest that climate change is  __________  to accelerate the loss of biodiversity worldwide."
  247
  1616
  739
  1
  370
]
45 0.05 ms
"COMMIT"
Parameters:
[]
46 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:
[
  370
]
47 0.06 ms
"START TRANSACTION"
Parameters:
[]
48 0.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
  "The novel explores themes of love, loss, and identity;  __________ , it is a coming-of-age story."
  370
  1616
  780
  1
  493
]
49 0.24 ms
"COMMIT"
Parameters:
[]
50 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:
[
  42
]
51 0.04 ms
"START TRANSACTION"
Parameters:
[]
52 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 policy changes,  __________ , had a greater impact on rural areas than on urban centers."
  42
  1616
  575
  493
  1
]
53 0.05 ms
"COMMIT"
Parameters:
[]
54 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:
[
  288
]
55 0.05 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 study suggests that economic growth will not be sustainable <em> __________ </em> governments implement strict environmental regulations."
  288
  1616
  657
  1
  370
]
57 0.05 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:
[
  452
]
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 narrative of the novel, though engaging, can feel disjointed  __________  due to the nonlinear storytelling."
  452
  1616
  616
  329
  83
]
61 0.04 ms
"COMMIT"
Parameters:
[]
62 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:
[
  575
]
63 0.04 ms
"START TRANSACTION"
Parameters:
[]
64 0.77 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
  " __________  that plants require sunlight for growth, human beings need social interaction for emotional well-being."
  575
  1616
  1
  370
  493
]
65 0.05 ms
"COMMIT"
Parameters:
[]
66 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
]
67 0.04 ms
"START TRANSACTION"
Parameters:
[]
68 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 success of the program depends on <em> __________ </em> adequate funding is provided by the government."
  616
  1616
  657
  329
  83
]
69 0.04 ms
"COMMIT"
Parameters:
[]
70 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:
[
  83
]
71 0.03 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 historical analysis demonstrates recurring patterns in political instability;  __________ , economic factors often play a decisive role."
  83
  1616
  780
  411
  616
]
73 0.06 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:
[
  124
]
75 0.04 ms
"START TRANSACTION"
Parameters:
[]
76 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 new treatment proved effective,  __________  in cases where other methods had failed."
  124
  1616
  1
  370
  657
]
77 0.06 ms
"COMMIT"
Parameters:
[]
78 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:
[
  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 results of the study showed that the hypothesis was  __________  supported by the data."
  739
  1616
  1
  83
  370
]
81 0.26 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:
[
  657
]
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 city has many historical landmarks,  __________ , the Eiffel Tower and the Louvre Museum."
  657
  1616
  1
  329
  493
]
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.