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

Query Metrics

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

Queries

Group similar statements

# Time Info
1 0.37 ms
SELECT t0.id AS id_1 FROM pack t0 WHERE t0.id = ?
Parameters:
[
  "31"
]
2 0.07 ms
"START TRANSACTION"
Parameters:
[]
3 0.22 ms
INSERT INTO quiz (pack_id) VALUES (?)
Parameters:
[
  31
]
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:
[
  31
]
6 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:
[
  31
]
7 0.05 ms
"START TRANSACTION"
Parameters:
[]
8 0.90 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 <em> __________ </em> stress at work reduces productivity and increases employee burnout."
  31
  1033
  646
  687
  318
]
9 0.06 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:
[
  154
]
11 0.03 ms
"START TRANSACTION"
Parameters:
[]
12 0.66 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 project was completed on time. (Eventualmente, o projeto foi conclu&iacute;do no prazo.)"
  154
  1033
  523
  605
  318
]
13 0.05 ms
"COMMIT"
Parameters:
[]
14 0.55 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:
[
  687
]
15 0.04 ms
"START TRANSACTION"
Parameters:
[]
16 1.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
  " __________ , we need to identify the problem."
  687
  1033
  113
  810
  564
]
17 0.07 ms
"COMMIT"
Parameters:
[]
18 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:
[
  564
]
19 0.05 ms
"START TRANSACTION"
Parameters:
[]
20 0.59 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 development of renewable energy sources is <em> __________ </em> essential to reducing carbon emissions."
  564
  1033
  769
  113
  810
]
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:
[
  728
]
23 0.04 ms
"START TRANSACTION"
Parameters:
[]
24 0.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 authors emphasize that collaboration across disciplines is necessary for progress."
  728
  1033
  482
  605
  318
]
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:
[
  277
]
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 study required  __________  50 hours of work to complete all the analyses."
  277
  1033
  113
  564
  523
]
29 0.04 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:
[
  605
]
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
  "Conservationists are  __________  protect endangered species by implementing stricter wildlife protection laws."
  605
  1033
  769
  564
  113
]
33 0.06 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:
[
  195
]
35 0.03 ms
"START TRANSACTION"
Parameters:
[]
36 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 policy  __________  improved productivity, although no official data has been released."
  195
  1033
  359
  605
  523
]
37 0.04 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:
[
  359
]
39 0.04 ms
"START TRANSACTION"
Parameters:
[]
40 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
  "<em> __________ , academic writing requires a formal tone and precise language.</em>"
  359
  1033
  318
  646
  564
]
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:
[
  441
]
43 0.04 ms
"START TRANSACTION"
Parameters:
[]
44 0.69 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 aims to reduce its environmental footprint while,  __________ , increasing its profitability."
  441
  1033
  482
  277
  810
]
45 0.05 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:
[
  113
]
47 0.05 ms
"START TRANSACTION"
Parameters:
[]
48 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
  "There are many different learning styles,  __________ , visual, auditory, and kinesthetic."
  113
  1033
  687
  646
  810
]
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:
[
  72
]
51 0.04 ms
"START TRANSACTION"
Parameters:
[]
52 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 new policy aims to reduce carbon emissions;  __________ , it encourages investment in renewable energy sources."
  72
  1033
  728
  564
  359
]
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:
[
  810
]
55 0.04 ms
"START TRANSACTION"
Parameters:
[]
56 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 project successfully reduced waste production;  __________ , it increased recycling rates across the region."
  810
  1033
  359
  523
  482
]
57 0.04 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:
[
  523
]
59 0.05 ms
"START TRANSACTION"
Parameters:
[]
60 0.88 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 discussion covered various aspects of urbanization; <em> __________ </em>, rapid population growth in cities requires better infrastructure planning."
  523
  1033
  810
  318
  646
]
61 0.05 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:
[
  646
]
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 treatment will be effective  __________  administered within the first 48 hours of symptom onset."
  646
  1033
  523
  564
  277
]
65 0.04 ms
"COMMIT"
Parameters:
[]
66 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:
[
  400
]
67 0.04 ms
"START TRANSACTION"
Parameters:
[]
68 0.28 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 collection was incomplete, the researchers decided to conduct further studies."
  400
  1033
  646
  564
  113
]
69 0.08 ms
"COMMIT"
Parameters:
[]
70 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:
[
  236
]
71 0.06 ms
"START TRANSACTION"
Parameters:
[]
72 0.39 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 breakthrough is  __________  the most significant advancement in medical research in the last decade. ""
  236
  1033
  605
  523
  359
]
73 0.05 ms
"COMMIT"
Parameters:
[]
74 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:
[
  482
]
75 0.05 ms
"START TRANSACTION"
Parameters:
[]
76 0.50 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>She acted  __________  she knew the answer to every question, even when she was unsure.</em>"
  482
  1033
  605
  277
  728
]
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:
[
  769
]
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
  "<em> __________  advancements in technology, communication has become more efficient and accessible.</em>"
  769
  1033
  810
  277
  564
]
81 0.08 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:
[
  318
]
83 0.05 ms
"START TRANSACTION"
Parameters:
[]
84 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
  "The study showed that the new drug was effective;  __________ , there were some serious side effects."
  318
  1033
  564
  769
  482
]
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.