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

Query Metrics

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

Queries

Group similar statements

# Time Info
1 0.61 ms
SELECT t0.id AS id_1 FROM pack t0 WHERE t0.id = ?
Parameters:
[
  "7"
]
2 0.08 ms
"START TRANSACTION"
Parameters:
[]
3 0.21 ms
INSERT INTO quiz (pack_id) VALUES (?)
Parameters:
[
  7
]
4 0.08 ms
"COMMIT"
Parameters:
[]
5 0.07 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 1.68 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
]
7 0.06 ms
"START TRANSACTION"
Parameters:
[]
8 0.51 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 analyzed the data.  __________ , a comprehensive report was prepared.""
  622
  1030
  335
  458
  89
]
9 0.08 ms
"COMMIT"
Parameters:
[]
10 0.91 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
]
11 0.05 ms
"START TRANSACTION"
Parameters:
[]
12 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 first experiment demonstrated a correlation, the second experiment confirmed causation."
  540
  1030
  212
  704
  376
]
13 0.05 ms
"COMMIT"
Parameters:
[]
14 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:
[
  376
]
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
  "<em>The proposal has received broad support from the committee.  __________ , it is likely to be approved in the next meeting.</em>"
  376
  1030
  663
  581
  89
]
17 0.04 ms
"COMMIT"
Parameters:
[]
18 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:
[
  417
]
19 0.08 ms
"START TRANSACTION"
Parameters:
[]
20 0.89 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 impact of climate change is undeniable; <em> __________ </em>, recent temperature records show a consistent rise over the past century."
  417
  1030
  540
  376
  335
]
21 0.07 ms
"COMMIT"
Parameters:
[]
22 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:
[
  458
]
23 0.04 ms
"START TRANSACTION"
Parameters:
[]
24 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 government has introduced new policies <em> __________ </em> reducing carbon emissions and promoting sustainability."
  458
  1030
  335
  786
  704
]
25 0.04 ms
"COMMIT"
Parameters:
[]
26 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:
[
  335
]
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
  "The company's failure to comply with environmental regulations led to heavy fines,  __________  financial losses."
  335
  1030
  745
  663
  458
]
29 0.04 ms
"COMMIT"
Parameters:
[]
30 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:
[
  704
]
31 0.05 ms
"START TRANSACTION"
Parameters:
[]
32 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 education system needs to be reformed."
  704
  1030
  540
  786
  458
]
33 0.04 ms
"COMMIT"
Parameters:
[]
34 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:
[
  130
]
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 experiment failed;  __________ , the researchers had to redesign the study."
  130
  1030
  89
  786
  745
]
37 0.04 ms
"COMMIT"
Parameters:
[]
38 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:
[
  212
]
39 0.04 ms
"START TRANSACTION"
Parameters:
[]
40 0.61 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 is not only profitable but also socially responsible;  __________ , it donates a portion of its profits to charity."
  212
  1030
  704
  745
  253
]
41 0.05 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:
[
  499
]
43 0.04 ms
"START TRANSACTION"
Parameters:
[]
44 0.49 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
  1030
  376
  335
  581
]
45 0.05 ms
"COMMIT"
Parameters:
[]
46 0.30 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.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
  "<em> __________ , consider the rapid adoption of smartphones in developing countries over the past decade.</em>"
  581
  1030
  745
  253
  89
]
49 0.04 ms
"COMMIT"
Parameters:
[]
50 0.43 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
]
51 0.04 ms
"START TRANSACTION"
Parameters:
[]
52 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
  "Artificial intelligence is transforming healthcare; <em> __________ </em>, AI-assisted diagnostic tools now outperform human doctors in detecting certain diseases."
  7
  1030
  253
  581
  212
]
53 0.04 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:
[
  663
]
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
  "Firstly, the novel presents a critique of political corruption;  __________ , it explores the moral dilemmas faced by its main characters."
  663
  1030
  335
  253
  704
]
57 0.07 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:
[
  294
]
59 0.04 ms
"START TRANSACTION"
Parameters:
[]
60 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 museum entrance is  __________  the central plaza, directly facing the historical monument."
  294
  1030
  212
  786
  458
]
61 0.04 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:
[
  745
]
63 0.04 ms
"START TRANSACTION"
Parameters:
[]
64 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 study analyzed the economic impact of climate change, <em> __________ </em> the effectiveness of current mitigation strategies."
  745
  1030
  704
  89
  294
]
65 0.04 ms
"COMMIT"
Parameters:
[]
66 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:
[
  89
]
67 0.05 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 results of the survey indicated shifting consumer preferences; <em> __________ </em>, companies must prioritize digital marketing strategies to remain competitive."
  89
  1030
  376
  212
  294
]
69 0.04 ms
"COMMIT"
Parameters:
[]
70 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:
[
  786
]
71 0.04 ms
"START TRANSACTION"
Parameters:
[]
72 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
  " __________  an emergency, please call 911."
  786
  1030
  663
  581
  294
]
73 0.04 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:
[
  171
]
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 company promotes itself as environmentally friendly; <em> __________ </em>, its carbon footprint suggests otherwise."
  171
  1030
  89
  663
  458
]
77 0.04 ms
"COMMIT"
Parameters:
[]
78 0.29 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
]
79 0.05 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 findings are significant,  __________  because they challenge the assumptions of previous studies."
  48
  1030
  458
  745
  581
]
81 0.04 ms
"COMMIT"
Parameters:
[]
82 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:
[
  253
]
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 many challenges faced by the organization, financial instability remains the most critical."
  253
  1030
  376
  581
  458
]
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.