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

Query Metrics

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

Queries

Group similar statements

# Time Info
1 0.39 ms
SELECT t0.id AS id_1 FROM pack t0 WHERE t0.id = ?
Parameters:
[
  "19"
]
2 0.08 ms
"START TRANSACTION"
Parameters:
[]
3 0.23 ms
INSERT INTO quiz (pack_id) VALUES (?)
Parameters:
[
  19
]
4 0.07 ms
"COMMIT"
Parameters:
[]
5 0.34 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:
[
  19
]
6 0.07 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:
[
  798
]
7 0.05 ms
"START TRANSACTION"
Parameters:
[]
8 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
  "He made a backup copy of the file  __________ ."
  798
  1315
  634
  183
  675
]
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:
[
  757
]
11 0.04 ms
"START TRANSACTION"
Parameters:
[]
12 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 included a diverse sample  __________  the findings could be generalized to a larger population."
  757
  1315
  470
  716
  593
]
13 0.04 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:
[
  265
]
15 0.04 ms
"START TRANSACTION"
Parameters:
[]
16 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 effects of climate change have become apparent in many parts of the world."
  265
  1315
  306
  634
  183
]
17 0.04 ms
"COMMIT"
Parameters:
[]
18 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:
[
  552
]
19 0.04 ms
"START TRANSACTION"
Parameters:
[]
20 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 government's approach to climate change needs to be more aggressive.</em>"
  552
  1315
  388
  347
  511
]
21 0.24 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:
[
  429
]
23 0.05 ms
"START TRANSACTION"
Parameters:
[]
24 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
  "All participants must sign the consent form  __________  ethical guidelines."
  429
  1315
  470
  511
  388
]
25 0.04 ms
"COMMIT"
Parameters:
[]
26 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:
[
  101
]
27 0.03 ms
"START TRANSACTION"
Parameters:
[]
28 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 company has increased its market share significantly;  __________ , it has expanded into international markets."
  101
  1315
  634
  757
  675
]
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:
[
  716
]
31 0.04 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
  " __________ , I believe that climate change is the biggest threat facing humanity."
  716
  1315
  388
  593
  675
]
33 0.04 ms
"COMMIT"
Parameters:
[]
34 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:
[
  634
]
35 0.03 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
  "She double-checked her work  __________  she might make a mistake."
  634
  1315
  470
  757
  306
]
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:
[
  19
]
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 program offers  __________  of opportunities for students to engage in hands-on learning experiences."
  19
  1315
  306
  757
  716
]
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:
[
  511
]
43 0.04 ms
"START TRANSACTION"
Parameters:
[]
44 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> __________  of the document, you will find a list of references and further readings.</em>"
  511
  1315
  593
  757
  798
]
45 0.04 ms
"COMMIT"
Parameters:
[]
46 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:
[
  347
]
47 0.04 ms
"START TRANSACTION"
Parameters:
[]
48 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 process is  __________  finished; we just need to verify the data."
  347
  1315
  757
  470
  634
]
49 0.04 ms
"COMMIT"
Parameters:
[]
50 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:
[
  224
]
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 temperature drops below freezing, additional measures will be implemented to protect the samples."
  224
  1315
  757
  716
  183
]
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:
[
  60
]
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
  "The policy can be considered effective  __________  it reduces unemployment rates in urban areas."
  60
  1315
  306
  675
  183
]
57 0.29 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:
[
  183
]
59 0.03 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
  " __________  renewable energy reduces dependency on fossil fuels, sustainable farming minimizes the need for chemical fertilizers."
  183
  1315
  634
  716
  798
]
61 0.04 ms
"COMMIT"
Parameters:
[]
62 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:
[
  142
]
63 0.04 ms
"START TRANSACTION"
Parameters:
[]
64 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 delays in the construction process were  __________  caused by adverse weather conditions."
  142
  1315
  593
  306
  634
]
65 0.06 ms
"COMMIT"
Parameters:
[]
66 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:
[
  675
]
67 0.05 ms
"START TRANSACTION"
Parameters:
[]
68 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 paper builds on concepts introduced  __________  in the literature review."
  675
  1315
  183
  757
  388
]
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:
[
  593
]
71 0.16 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 policy aims to reduce carbon emissions;  __________ , it seeks to promote the use of renewable energy sources."
  593
  1315
  183
  511
  675
]
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:
[
  388
]
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
  "Researchers developed an experimental vaccine <em> __________ </em> preventing the spread of infectious diseases."
  388
  1315
  511
  675
  306
]
77 0.04 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:
[
  306
]
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
  " __________  do patients with this condition recover fully."
  306
  1315
  634
  675
  388
]
81 0.04 ms
"COMMIT"
Parameters:
[]
82 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:
[
  470
]
83 0.04 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 study focuses on the effects of pollution,  __________  on vulnerable populations such as children and the elderly."
  470
  1315
  634
  306
  716
]
85 0.05 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.