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

Query Metrics

81 Database Queries
7 Different statements
27.78 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 0.67 ms
SELECT t0.id AS id_1 FROM pack t0 WHERE t0.id = ?
Parameters:
[
  "39"
]
2 0.12 ms
"START TRANSACTION"
Parameters:
[]
3 0.23 ms
INSERT INTO quiz (pack_id) VALUES (?)
Parameters:
[
  39
]
4 0.12 ms
"COMMIT"
Parameters:
[]
5 0.81 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:
[
  39
]
6 1.59 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:
[
  121
]
7 0.06 ms
"START TRANSACTION"
Parameters:
[]
8 0.77 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 introduced subsidies for renewable energy,  __________  the country continue to rely on fossil fuels."
  121
  1282
  695
  80
  367
]
9 0.07 ms
"COMMIT"
Parameters:
[]
10 1.47 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:
[
  408
]
11 0.04 ms
"START TRANSACTION"
Parameters:
[]
12 0.84 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
  "Despite minor setbacks,  __________ , the project met its objectives within the expected timeframe."
  408
  1282
  449
  736
  572
]
13 0.07 ms
"COMMIT"
Parameters:
[]
14 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:
[
  203
]
15 0.05 ms
"START TRANSACTION"
Parameters:
[]
16 1.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
  "The policy was not designed to penalize businesses;  __________ , it aimed to incentivize sustainable practices."
  203
  1282
  736
  367
  695
]
17 0.20 ms
"COMMIT"
Parameters:
[]
18 1.15 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:
[
  244
]
19 0.07 ms
"START TRANSACTION"
Parameters:
[]
20 0.23 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 divided into two main parts: first, the preparation of the samples;  __________ , the analysis of the results."
  244
  1282
  777
  367
  736
]
21 0.05 ms
"COMMIT"
Parameters:
[]
22 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:
[
  572
]
23 0.05 ms
"START TRANSACTION"
Parameters:
[]
24 0.82 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 fails to produce the expected results; this would indicate a flaw in the initial hypothesis."
  572
  1282
  80
  777
  695
]
25 0.06 ms
"COMMIT"
Parameters:
[]
26 0.67 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:
[
  531
]
27 0.05 ms
"START TRANSACTION"
Parameters:
[]
28 0.34 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 failed to meet safety standards, its operations were temporarily suspended."
  531
  1282
  326
  490
  367
]
29 0.05 ms
"COMMIT"
Parameters:
[]
30 0.65 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:
[
  326
]
31 0.05 ms
"START TRANSACTION"
Parameters:
[]
32 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
  "<em> __________  the weather permits, the outdoor event will take place on Saturday.</em>"
  326
  1282
  490
  80
  736
]
33 0.05 ms
"COMMIT"
Parameters:
[]
34 0.96 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:
[
  613
]
35 0.04 ms
"START TRANSACTION"
Parameters:
[]
36 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
  "He would have been promoted if his performance  __________  improved."
  613
  1282
  777
  736
  490
]
37 0.05 ms
"COMMIT"
Parameters:
[]
38 0.49 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:
[
  777
]
39 0.05 ms
"START TRANSACTION"
Parameters:
[]
40 1.03 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 feedback from the survey was  __________  positive, indicating a high level of satisfaction."
  777
  1282
  203
  572
  80
]
41 0.08 ms
"COMMIT"
Parameters:
[]
42 0.77 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:
[
  367
]
43 0.04 ms
"START TRANSACTION"
Parameters:
[]
44 1.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
  "" __________  the guidelines, all participants must provide informed consent before the study begins.""
  367
  1282
  572
  203
  80
]
45 0.11 ms
"COMMIT"
Parameters:
[]
46 0.57 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:
[
  490
]
47 0.04 ms
"START TRANSACTION"
Parameters:
[]
48 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 economy has shown consistent growth over the past decade;  __________ , analysts predict a stable financial outlook."
  490
  1282
  572
  203
  80
]
49 0.18 ms
"COMMIT"
Parameters:
[]
50 0.40 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:
[
  162
]
51 0.06 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
  "<em> __________  public opinion is concerned, the new law has faced significant opposition.</em> ""
  162
  1282
  695
  490
  80
]
53 0.04 ms
"COMMIT"
Parameters:
[]
54 0.42 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:
[
  449
]
55 0.04 ms
"START TRANSACTION"
Parameters:
[]
56 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
  " __________ , I don't believe a word he said."
  449
  1282
  777
  367
  490
]
57 0.05 ms
"COMMIT"
Parameters:
[]
58 0.42 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:
[
  695
]
59 0.04 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
  "The archaeological team excavated the site  __________  they uncovered all the artifacts predicted by their survey."
  695
  1282
  203
  736
  490
]
61 0.05 ms
"COMMIT"
Parameters:
[]
62 0.78 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:
[
  736
]
63 0.05 ms
"START TRANSACTION"
Parameters:
[]
64 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 experiment showed that the new material is <em> __________ </em> resistant to extreme temperatures and pressure."
  736
  1282
  777
  490
  203
]
65 0.05 ms
"COMMIT"
Parameters:
[]
66 0.53 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:
[
  285
]
67 0.05 ms
"START TRANSACTION"
Parameters:
[]
68 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 book focuses  __________  on the ethical implications of artificial intelligence."
  285
  1282
  326
  736
  449
]
69 0.07 ms
"COMMIT"
Parameters:
[]
70 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:
[
  80
]
71 0.05 ms
"START TRANSACTION"
Parameters:
[]
72 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 first phase of the project required extensive collaboration;  __________ , the second phase will rely on interdisciplinary teamwork."
  80
  1282
  367
  777
  695
]
73 0.05 ms
"COMMIT"
Parameters:
[]
74 0.88 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:
[
  654
]
75 0.05 ms
"START TRANSACTION"
Parameters:
[]
76 1.34 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
  "Automation has replaced many traditional jobs; <em> __________ </em>, it has also created new opportunities in technology-driven industries."
  654
  1282
  367
  326
  449
]
77 0.06 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:
[
  39
]
79 0.04 ms
"START TRANSACTION"
Parameters:
[]
80 0.18 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 increase in temperature levels is primarily  __________  the rise in greenhouse gas emissions over the past century."
  39
  1282
  777
  736
  326
]
81 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.