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

Query Metrics

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

Queries

Group similar statements

# Time Info
1 0.40 ms
SELECT t0.id AS id_1 FROM pack t0 WHERE t0.id = ?
Parameters:
[
  "16"
]
2 0.07 ms
"START TRANSACTION"
Parameters:
[]
3 0.20 ms
INSERT INTO quiz (pack_id) VALUES (?)
Parameters:
[
  16
]
4 0.08 ms
"COMMIT"
Parameters:
[]
5 0.57 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:
[
  16
]
6 0.28 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:
[
  508
]
7 0.06 ms
"START TRANSACTION"
Parameters:
[]
8 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
  "<em> __________ , after several attempts, the team successfully implemented the new software system.</em>"
  508
  1620
  754
  16
  549
]
9 0.05 ms
"COMMIT"
Parameters:
[]
10 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:
[
  180
]
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
  "<em> __________ , the experiment yielded unexpected results, but after adjusting the variables, the outcomes aligned with expectations.</em> ""
  180
  1620
  16
  98
  344
]
13 0.05 ms
"COMMIT"
Parameters:
[]
14 0.38 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:
[
  795
]
15 0.04 ms
"START TRANSACTION"
Parameters:
[]
16 1.09 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 weather began to improve."
  795
  1620
  344
  98
  303
]
17 0.05 ms
"COMMIT"
Parameters:
[]
18 0.14 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:
[
  467
]
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
  " __________ , the book is about a young woman's journey of self-discovery."
  467
  1620
  16
  795
  98
]
21 0.04 ms
"COMMIT"
Parameters:
[]
22 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:
[
  98
]
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 discussion on renewable energy is complex; <em> __________ </em>, the main debate revolves around cost-effectiveness and environmental impact."
  98
  1620
  16
  795
  549
]
25 0.04 ms
"COMMIT"
Parameters:
[]
26 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:
[
  631
]
27 0.05 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 examined the effects of climate change on biodiversity; <em> __________ </em>, it is evident that habitat loss remains a critical threat to species survival."
  631
  1620
  344
  754
  795
]
29 0.05 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:
[
  16
]
31 0.05 ms
"START TRANSACTION"
Parameters:
[]
32 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 depends on <em> __________ </em> the government provides sufficient funding."
  16
  1620
  303
  344
  754
]
33 0.22 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:
[
  262
]
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
  "Urban areas were rapidly modernizing;  __________ , rural communities struggled with limited access to resources."
  262
  1620
  344
  754
  98
]
37 0.04 ms
"COMMIT"
Parameters:
[]
38 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:
[
  672
]
39 0.03 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 data must be analyzed  __________  to ensure the accuracy of the statistical conclusions."
  672
  1620
  344
  549
  795
]
41 0.04 ms
"COMMIT"
Parameters:
[]
42 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:
[
  754
]
43 0.04 ms
"START TRANSACTION"
Parameters:
[]
44 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
  "Residents expressed concerns about the environmental impact of a factory being built  __________ ."
  754
  1620
  672
  98
  795
]
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:
[
  426
]
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
  "Historical artifacts were discovered  __________  the excavation site, providing insight into ancient civilizations."
  426
  1620
  713
  549
  98
]
49 0.04 ms
"COMMIT"
Parameters:
[]
50 0.27 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:
[
  344
]
51 0.04 ms
"START TRANSACTION"
Parameters:
[]
52 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 would have gone bankrupt  __________  the new strategy implemented by its CEO."
  344
  1620
  16
  98
  713
]
53 0.04 ms
"COMMIT"
Parameters:
[]
54 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:
[
  303
]
55 0.04 ms
"START TRANSACTION"
Parameters:
[]
56 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 provided financial aid to employees;  __________ , they introduced new training programs to improve skills."
  303
  1620
  98
  713
  549
]
57 0.04 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:
[
  385
]
59 0.04 ms
"START TRANSACTION"
Parameters:
[]
60 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 merger between the two corporations is not official yet, but <em> __________ </em>, they are already operating as a single entity."
  385
  1620
  303
  795
  344
]
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:
[
  713
]
63 0.04 ms
"START TRANSACTION"
Parameters:
[]
64 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 yielded consistent results;  __________ , the hypothesis was proven correct."
  713
  1620
  303
  549
  672
]
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:
[
  590
]
67 0.04 ms
"START TRANSACTION"
Parameters:
[]
68 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 river flows  __________  the bridge, creating a scenic view for pedestrians."
  590
  1620
  672
  549
  713
]
69 0.26 ms
"COMMIT"
Parameters:
[]
70 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:
[
  549
]
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
  "<em>The factory ignored safety regulations.  __________ , several accidents occurred within a short period.</em>"
  549
  1620
  303
  754
  672
]
73 0.04 ms
"COMMIT"
Parameters:
[]
74 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:
[
  57
]
75 0.05 ms
"START TRANSACTION"
Parameters:
[]
76 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 museum's collection is impressive,  __________  smaller than that of its counterparts in larger cities. ""
  57
  1620
  16
  713
  98
]
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:
[
  221
]
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
  "The policy aims to reduce pollution;  __________ , it targets carbon emissions from transportation."
  221
  1620
  303
  344
  549
]
81 0.04 ms
"COMMIT"
Parameters:
[]
82 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:
[
  139
]
83 0.04 ms
"START TRANSACTION"
Parameters:
[]
84 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 funding has been secured, the project can proceed to its implementation phase."
  139
  1620
  795
  344
  672
]
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.