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

Query Metrics

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

Queries

Group similar statements

# Time Info
1 0.53 ms
SELECT t0.id AS id_1 FROM pack t0 WHERE t0.id = ?
Parameters:
[
  "7"
]
2 0.16 ms
"START TRANSACTION"
Parameters:
[]
3 0.32 ms
INSERT INTO quiz (pack_id) VALUES (?)
Parameters:
[
  7
]
4 0.12 ms
"COMMIT"
Parameters:
[]
5 0.42 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:
[
  7
]
6 0.93 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:
[
  704
]
7 0.09 ms
"START TRANSACTION"
Parameters:
[]
8 0.41 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
  " __________  it is important to be kind to others."
  704
  1289
  253
  540
  335
]
9 0.28 ms
"COMMIT"
Parameters:
[]
10 0.76 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:
[
  212
]
11 0.08 ms
"START TRANSACTION"
Parameters:
[]
12 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
  "climate change is a serious threat;  __________ , it is the most pressing issue facing our planet."
  212
  1289
  335
  786
  294
]
13 0.10 ms
"COMMIT"
Parameters:
[]
14 0.56 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:
[
  171
]
15 0.17 ms
"START TRANSACTION"
Parameters:
[]
16 0.36 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 book is widely praised for its depth of analysis, but <em> __________ </em>, I found some arguments to be overly speculative."
  171
  1289
  376
  663
  786
]
17 0.11 ms
"COMMIT"
Parameters:
[]
18 0.63 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:
[
  253
]
19 0.10 ms
"START TRANSACTION"
Parameters:
[]
20 0.32 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 phenomenon is frequently observed  __________  populations living in coastal areas. ""
  253
  1289
  663
  581
  376
]
21 0.08 ms
"COMMIT"
Parameters:
[]
22 0.93 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:
[
  294
]
23 0.08 ms
"START TRANSACTION"
Parameters:
[]
24 0.35 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 library is located  __________  the main administration building, making it easily accessible to students."
  294
  1289
  540
  704
  89
]
25 0.11 ms
"COMMIT"
Parameters:
[]
26 0.88 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:
[
  663
]
27 0.07 ms
"START TRANSACTION"
Parameters:
[]
28 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 results indicate two major trends: firstly, an increase in online consumer behavior;  __________ , a decline in traditional retail sales."
  663
  1289
  376
  294
  786
]
29 0.06 ms
"COMMIT"
Parameters:
[]
30 0.50 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:
[
  7
]
31 0.05 ms
"START TRANSACTION"
Parameters:
[]
32 0.25 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 tested the effects of sleep deprivation on concentration; <em> __________ </em>, participants who slept less than five hours showed a significant decline in cognitive performance."
  7
  1289
  704
  786
  540
]
33 0.06 ms
"COMMIT"
Parameters:
[]
34 0.59 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:
[
  499
]
35 0.06 ms
"START TRANSACTION"
Parameters:
[]
36 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 results were inconclusive  __________  the initial phase of the study was completed."
  499
  1289
  786
  540
  704
]
37 0.05 ms
"COMMIT"
Parameters:
[]
38 0.67 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:
[
  130
]
39 0.06 ms
"START TRANSACTION"
Parameters:
[]
40 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 company made a significant profit last year;  __________ , it was able to expand its operations."
  130
  1289
  294
  581
  253
]
41 0.05 ms
"COMMIT"
Parameters:
[]
42 0.41 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:
[
  417
]
43 0.04 ms
"START TRANSACTION"
Parameters:
[]
44 0.78 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 correlation between diet and cardiovascular health is well established; <em> __________ </em>, the research analyzed data from over 10,000 participants."
  417
  1289
  704
  294
  786
]
45 0.22 ms
"COMMIT"
Parameters:
[]
46 0.37 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:
[
  581
]
47 0.05 ms
"START TRANSACTION"
Parameters:
[]
48 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
  "<em> __________ , the analysis includes data from several countries with varying levels of economic development.</em> ""
  581
  1289
  704
  253
  89
]
49 0.05 ms
"COMMIT"
Parameters:
[]
50 0.89 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:
[
  786
]
51 0.06 ms
"START TRANSACTION"
Parameters:
[]
52 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
  "You should bring an umbrella  __________  rain."
  786
  1289
  704
  458
  89
]
53 0.06 ms
"COMMIT"
Parameters:
[]
54 0.54 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:
[
  335
]
55 0.05 ms
"START TRANSACTION"
Parameters:
[]
56 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 expansion of global trade has facilitated economic growth,  __________  greater interdependence among nations."
  335
  1289
  745
  376
  663
]
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:
[
  48
]
59 0.04 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
  "This phenomenon is observed in various ecosystems,  __________  in tropical rainforests with high biodiversity."
  48
  1289
  540
  704
  294
]
61 0.05 ms
"COMMIT"
Parameters:
[]
62 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:
[
  458
]
63 0.04 ms
"START TRANSACTION"
Parameters:
[]
64 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
  "Scientists are exploring alternative energy sources <em> __________ </em> minimizing reliance on fossil fuels."
  458
  1289
  212
  663
  704
]
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:
[
  89
]
67 0.04 ms
"START TRANSACTION"
Parameters:
[]
68 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 psychological effects of social media were examined; <em> __________ </em>, excessive use can lead to anxiety and decreased self-esteem."
  89
  1289
  581
  704
  663
]
69 0.04 ms
"COMMIT"
Parameters:
[]
70 0.42 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:
[
  376
]
71 0.05 ms
"START TRANSACTION"
Parameters:
[]
72 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
  "<em>The experiment was designed to test a specific hypothesis.  __________ , only the relevant variables were manipulated.</em>"
  376
  1289
  663
  212
  704
]
73 0.05 ms
"COMMIT"
Parameters:
[]
74 0.70 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:
[
  622
]
75 0.04 ms
"START TRANSACTION"
Parameters:
[]
76 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 committee evaluated the proposals.  __________ , the shortlisted candidates were invited for interviews.""
  622
  1289
  335
  253
  458
]
77 0.23 ms
"COMMIT"
Parameters:
[]
78 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:
[
  745
]
79 0.03 ms
"START TRANSACTION"
Parameters:
[]
80 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
  "Increased government investment in education, <em> __________ </em> community-driven initiatives, has led to higher literacy rates."
  745
  1289
  704
  581
  212
]
81 0.05 ms
"COMMIT"
Parameters:
[]
82 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:
[
  540
]
83 0.05 ms
"START TRANSACTION"
Parameters:
[]
84 0.45 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
  " __________  social media has transformed communication, e-commerce has revolutionized retail industries."
  540
  1289
  253
  745
  704
]
85 0.06 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.