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

Query Metrics

82 Database Queries
7 Different statements
14.18 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:
[
  "8"
]
2 0.07 ms
"START TRANSACTION"
Parameters:
[]
3 0.20 ms
INSERT INTO quiz (pack_id) VALUES (?)
Parameters:
[
  8
]
4 0.08 ms
"COMMIT"
Parameters:
[]
5 0.06 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:
[
  8
]
6 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:
[
  623
]
7 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:
[
  295
]
8 0.04 ms
"START TRANSACTION"
Parameters:
[]
9 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 company expects to launch its latest software update  __________ , addressing several security vulnerabilities."
  295
  1040
  664
  541
  746
]
10 0.05 ms
"COMMIT"
Parameters:
[]
11 0.22 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:
[
  131
]
12 0.03 ms
"START TRANSACTION"
Parameters:
[]
13 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 new software is user-friendly.  __________ , it is very efficient."
  131
  1040
  582
  664
  541
]
14 0.05 ms
"COMMIT"
Parameters:
[]
15 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:
[
  254
]
16 0.04 ms
"START TRANSACTION"
Parameters:
[]
17 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 high levels of stress among employees are  __________  a decline in overall productivity."
  254
  1040
  746
  664
  459
]
18 0.04 ms
"COMMIT"
Parameters:
[]
19 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:
[
  705
]
20 0.04 ms
"START TRANSACTION"
Parameters:
[]
21 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
  " __________ , climate change is the most pressing issue facing our planet."
  705
  1040
  787
  254
  459
]
22 0.04 ms
"COMMIT"
Parameters:
[]
23 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:
[
  377
]
24 0.03 ms
"START TRANSACTION"
Parameters:
[]
25 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 theory suggests that the universe began with a big bang."
  377
  1040
  582
  541
  664
]
26 0.04 ms
"COMMIT"
Parameters:
[]
27 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:
[
  500
]
28 0.04 ms
"START TRANSACTION"
Parameters:
[]
29 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 policy has been widely criticized;  __________ , many experts have called for its immediate revision."
  500
  1040
  213
  295
  459
]
30 0.05 ms
"COMMIT"
Parameters:
[]
31 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:
[
  336
]
32 0.03 ms
"START TRANSACTION"
Parameters:
[]
33 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 new software is more efficient than the old one, and  __________  importantly, it is user-friendly." (O novo software é mais eficiente que o antigo e, ainda mais importante, ele é fácil de usar.)"
  336
  1040
  213
  787
  377
]
34 0.05 ms
"COMMIT"
Parameters:
[]
35 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:
[
  172
]
36 0.04 ms
"START TRANSACTION"
Parameters:
[]
37 0.12 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
  "Linguistic structures of this complexity are  __________  found in everyday speech."
  172
  1040
  582
  459
  787
]
38 0.04 ms
"COMMIT"
Parameters:
[]
39 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:
[
  213
]
40 0.04 ms
"START TRANSACTION"
Parameters:
[]
41 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
  "Patients  __________  report side effects from this medication."
  213
  1040
  49
  664
  787
]
42 0.04 ms
"COMMIT"
Parameters:
[]
43 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:
[
  8
]
44 0.04 ms
"START TRANSACTION"
Parameters:
[]
45 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 project was  __________  due to the effective collaboration among team members."
  8
  1040
  418
  459
  377
]
46 0.04 ms
"COMMIT"
Parameters:
[]
47 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:
[
  541
]
48 0.04 ms
"START TRANSACTION"
Parameters:
[]
49 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 time required to complete the project was  __________  shorter than initially anticipated."
  541
  1040
  418
  213
  377
]
50 0.04 ms
"COMMIT"
Parameters:
[]
51 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:
[
  664
]
52 0.04 ms
"START TRANSACTION"
Parameters:
[]
53 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 company has invested in multiple renewable energy sources,  __________  solar and wind power."
  664
  1040
  746
  295
  213
]
54 0.04 ms
"COMMIT"
Parameters:
[]
55 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:
[
  746
]
56 0.04 ms
"START TRANSACTION"
Parameters:
[]
57 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
  "While some people believe that technology is making our lives easier, others argue that it is making us more isolated;  __________  this belief, they believe that technology is creating new opportunities for connection."
  746
  1040
  418
  254
  459
]
58 0.04 ms
"COMMIT"
Parameters:
[]
59 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:
[
  582
]
60 0.03 ms
"START TRANSACTION"
Parameters:
[]
61 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
  " __________ , there is a discrepancy between the survey responses and the actual behavior of participants."
  582
  1040
  705
  418
  295
]
62 0.04 ms
"COMMIT"
Parameters:
[]
63 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:
[
  90
]
64 0.04 ms
"START TRANSACTION"
Parameters:
[]
65 0.68 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 conducted in the morning.  __________ , the data was analyzed using statistical software.""
  90
  1040
  459
  377
  746
]
66 0.05 ms
"COMMIT"
Parameters:
[]
67 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:
[
  459
]
68 0.04 ms
"START TRANSACTION"
Parameters:
[]
69 3.05 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 two groups behaved  __________  expected under the experimental conditions.""
  459
  1040
  664
  295
  213
]
70 0.08 ms
"COMMIT"
Parameters:
[]
71 0.09 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:
[
  418
]
72 0.07 ms
"START TRANSACTION"
Parameters:
[]
73 0.72 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 rabbit ran  __________  and faster than the fox."
  418
  1040
  459
  664
  746
]
74 0.05 ms
"COMMIT"
Parameters:
[]
75 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:
[
  787
]
76 0.04 ms
"START TRANSACTION"
Parameters:
[]
77 0.85 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 software update fixed previous bugs,  __________ , it introduced several new security features."
  787
  1040
  295
  213
  746
]
78 0.05 ms
"COMMIT"
Parameters:
[]
79 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:
[
  49
]
80 0.04 ms
"START TRANSACTION"
Parameters:
[]
81 1.67 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 is  __________  investigate the impact of social media on adolescent behavior."
  49
  1040
  459
  254
  664
]
82 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.