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

Query Metrics

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

Queries

Group similar statements

# Time Info
1 0.12 ms
SELECT t0.id AS id_1 FROM pack t0 WHERE t0.id = ?
Parameters:
[
  "40"
]
2 0.08 ms
"START TRANSACTION"
Parameters:
[]
3 0.49 ms
INSERT INTO quiz (pack_id) VALUES (?)
Parameters:
[
  40
]
4 0.07 ms
"COMMIT"
Parameters:
[]
5 0.67 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:
[
  40
]
6 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:
[
  122
]
7 0.07 ms
"START TRANSACTION"
Parameters:
[]
8 0.92 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 highlights the importance of implementing long-term policies to address environmental challenges."
  122
  1608
  778
  286
  655
]
9 0.19 ms
"COMMIT"
Parameters:
[]
10 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:
[
  737
]
11 0.09 ms
"START TRANSACTION"
Parameters:
[]
12 0.99 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 aims to determine <em> __________ </em> climate change policies have a measurable impact on carbon emissions."
  737
  1608
  655
  573
  532
]
13 0.06 ms
"COMMIT"
Parameters:
[]
14 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:
[
  40
]
15 0.09 ms
"START TRANSACTION"
Parameters:
[]
16 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
  " __________ , people are more optimistic about the future."
  40
  1608
  573
  368
  286
]
17 0.05 ms
"COMMIT"
Parameters:
[]
18 0.25 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:
[
  778
]
19 0.24 ms
"START TRANSACTION"
Parameters:
[]
20 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
  "A healthy diet should include a variety of proteins,  __________ , fish, chicken, or legumes, to ensure balanced nutrition."
  778
  1608
  368
  122
  655
]
21 0.05 ms
"COMMIT"
Parameters:
[]
22 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:
[
  327
]
23 0.04 ms
"START TRANSACTION"
Parameters:
[]
24 0.33 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 patient reported feeling discomfort  __________ , but overall, the treatment was well tolerated."
  327
  1608
  655
  122
  163
]
25 0.05 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:
[
  245
]
27 0.05 ms
"START TRANSACTION"
Parameters:
[]
28 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
  "You should bring an umbrella  __________  rain."
  245
  1608
  573
  122
  368
]
29 0.05 ms
"COMMIT"
Parameters:
[]
30 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:
[
  163
]
31 0.04 ms
"START TRANSACTION"
Parameters:
[]
32 0.57 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 comply with safety regulations;  __________ , it faced substantial fines and legal penalties."
  163
  1608
  204
  614
  122
]
33 0.05 ms
"COMMIT"
Parameters:
[]
34 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:
[
  204
]
35 0.04 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
  " __________ , we can all relax and enjoy the vacation."
  204
  1608
  368
  532
  737
]
37 0.05 ms
"COMMIT"
Parameters:
[]
38 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:
[
  655
]
39 0.06 ms
"START TRANSACTION"
Parameters:
[]
40 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 weather forecast predicted rain;  __________ , the sun came out."
  655
  1608
  286
  573
  614
]
41 0.17 ms
"COMMIT"
Parameters:
[]
42 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:
[
  614
]
43 0.04 ms
"START TRANSACTION"
Parameters:
[]
44 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 researchers concluded that the phenomenon cannot be  __________  explained by the current theoretical framework."
  614
  1608
  368
  122
  204
]
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:
[
  81
]
47 0.05 ms
"START TRANSACTION"
Parameters:
[]
48 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
  "The company is facing bankruptcy.  __________ , the shareholders are losing money."
  81
  1608
  573
  655
  778
]
49 0.05 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:
[
  696
]
51 0.05 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 research concludes that urban air quality will not improve <em> __________ </em> cities reduce vehicle emissions and promote public transportation."
  696
  1608
  614
  778
  655
]
53 0.04 ms
"COMMIT"
Parameters:
[]
54 0.30 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:
[
  409
]
55 0.04 ms
"START TRANSACTION"
Parameters:
[]
56 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
  "Many countries have adopted renewable energy sources, <em> __________ </em> fossil fuels still dominate the global energy market."
  409
  1608
  204
  163
  122
]
57 0.05 ms
"COMMIT"
Parameters:
[]
58 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:
[
  450
]
59 0.05 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 new methodology has been  __________  successful in improving the accuracy of predictions."
  450
  1608
  573
  614
  286
]
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:
[
  491
]
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 team&rsquo;s performance was below expectations;  __________ , they showed significant improvement over time. ""
  491
  1608
  368
  573
  204
]
65 0.05 ms
"COMMIT"
Parameters:
[]
66 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:
[
  286
]
67 0.04 ms
"START TRANSACTION"
Parameters:
[]
68 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 contract was terminated  __________  the terms of the agreement."
  286
  1608
  573
  122
  368
]
69 0.05 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:
[
  573
]
71 0.05 ms
"START TRANSACTION"
Parameters:
[]
72 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 edges of the map, there are detailed annotations explaining the symbols."
  573
  1608
  655
  532
  204
]
73 0.04 ms
"COMMIT"
Parameters:
[]
74 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:
[
  532
]
75 0.06 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 research shows that students who study in groups <em> __________ </em> perform better on standardized tests."
  532
  1608
  573
  778
  368
]
77 0.24 ms
"COMMIT"
Parameters:
[]
78 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:
[
  368
]
79 0.05 ms
"START TRANSACTION"
Parameters:
[]
80 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 company adopted new strategies <em> __________ </em> expanding its global market reach."
  368
  1608
  778
  532
  122
]
81 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.