https://survey.gridinternational.com/user/survey/50?X-AUTH-TOKEN=2eca1585b3434691689a4d888ab50ea5&p=user%2Fsurvey%2F50

Method
GET
HTTP Status
302
IP
47.128.21.124
Profiled on
Token
8511f0

Query Metrics

6 Database Queries
5 Different statements
19.71 ms Query time
1 Invalid entities

Queries

Group similar statements

#▲ Time Info
1 3.33 ms 
SELECT t0.id AS id_1, t0.username AS username_2, t0.password AS password_3, t0.token AS token_4, t0.oauth_token AS oauth_token_5, t0.is_active AS is_active_6 FROM users t0 WHERE t0.oauth_token = ? LIMIT 1
Parameters: 
[
  "2eca1585b3434691689a4d888ab50ea5"
]
View formatted query    View runnable query    Explain query
2 0.79 ms 
SELECT t0.id AS id_1, t0.username AS username_2, t0.password AS password_3, t0.token AS token_4, t0.oauth_token AS oauth_token_5, t0.is_active AS is_active_6 FROM users t0 WHERE t0.oauth_token = ? LIMIT 1
Parameters: 
[
  "2eca1585b3434691689a4d888ab50ea5"
]
View formatted query    View runnable query    Explain query
3 4.61 ms 
SELECT t0.id AS id_1, t0.role AS role_2 FROM role t0 INNER JOIN users_roles ON t0.id = users_roles.role_id WHERE users_roles.user_id = ?
Parameters: 
[
  1450
]
View formatted query    View runnable query    Explain query
4 4.76 ms 
SELECT t0.id AS id_1, t0.student_id AS student_id_2, t0.survey_id AS survey_id_3, t0.q1a1 AS q1a1_4, t0.q1a2 AS q1a2_5, t0.q1a3 AS q1a3_6, t0.q1a4 AS q1a4_7, t0.q1a5 AS q1a5_8, t0.q1a6 AS q1a6_9, t0.q1a7 AS q1a7_10, t0.q1a8 AS q1a8_11, t0.q2a1 AS q2a1_12, t0.q2a2 AS q2a2_13, t0.q2a3 AS q2a3_14, t0.q2a4 AS q2a4_15, t0.q2a5 AS q2a5_16, t0.q2a6 AS q2a6_17, t0.q2a7 AS q2a7_18, t0.q2a8 AS q2a8_19, t0.q3a1 AS q3a1_20, t0.q3a2 AS q3a2_21, t0.q3a3 AS q3a3_22, t0.q3a4 AS q3a4_23, t0.q3a5 AS q3a5_24, t0.q3a6 AS q3a6_25, t0.q3a7 AS q3a7_26, t0.q3a8 AS q3a8_27, t0.q4a1 AS q4a1_28, t0.q4a2 AS q4a2_29, t0.q4a3 AS q4a3_30, t0.q4a4 AS q4a4_31, t0.q4a5 AS q4a5_32, t0.q4a6 AS q4a6_33, t0.q4a7 AS q4a7_34, t0.q4a8 AS q4a8_35, t0.q5a1 AS q5a1_36, t0.q5a2 AS q5a2_37, t0.q5a3 AS q5a3_38, t0.q5a4 AS q5a4_39, t0.q5a5 AS q5a5_40, t0.q5a6 AS q5a6_41, t0.q5a7 AS q5a7_42, t0.q5a8 AS q5a8_43, t0.q6a1 AS q6a1_44, t0.q6a2 AS q6a2_45, t0.q6a3 AS q6a3_46, t0.q6a4 AS q6a4_47, t0.q6a5 AS q6a5_48, t0.q6a6 AS q6a6_49, t0.q6a7 AS q6a7_50, t0.q6a8 AS q6a8_51, t0.q7a1 AS q7a1_52, t0.q7a2 AS q7a2_53, t0.q7a3 AS q7a3_54, t0.q7a4 AS q7a4_55, t0.q7a5 AS q7a5_56, t0.q7a6 AS q7a6_57, t0.q7a7 AS q7a7_58, t0.q7a8 AS q7a8_59, t0.q8a1 AS q8a1_60, t0.q8a2 AS q8a2_61, t0.q8a3 AS q8a3_62, t0.q8a4 AS q8a4_63, t0.q8a5 AS q8a5_64, t0.q8a6 AS q8a6_65, t0.q8a7 AS q8a7_66, t0.q8a8 AS q8a8_67, t0.exp1 AS exp1_68, t0.cat1 AS cat1_69, t0.exp2 AS exp2_70, t0.cat2 AS cat2_71, t0.exp3 AS exp3_72, t0.cat3 AS cat3_73, t0.exp4 AS exp4_74, t0.cat4 AS cat4_75, t0.exp5 AS exp5_76, t0.cat5 AS cat5_77, t0.exp6 AS exp6_78, t0.cat6 AS cat6_79, t0.exp7 AS exp7_80, t0.cat7 AS cat7_81, t0.exp8 AS exp8_82, t0.cat8 AS cat8_83, t0.comment AS comment_84, t0.status AS status_85 FROM student_survey t0 WHERE t0.student_id = ? AND t0.status = ? AND t0.survey_id = ? LIMIT 1
Parameters: 
[
  1450
  0
  "50"
]
View formatted query    View runnable query    Explain query
5 3.70 ms 
SELECT t0.id AS id_1, t0.name AS name_2, t0.start_date AS start_date_3, t0.end_date AS end_date_4, t0.type AS type_5 FROM survey t0 WHERE t0.id = ?
Parameters: 
[
  50
]
View formatted query    View runnable query    Explain query
6 2.53 ms 
SELECT t0.id AS id_1, t0.question AS question_2, t0.description AS description_3, t0.type AS type_4 FROM question t0 WHERE t0.type = ?
Parameters: 
[
  "4"
]
View formatted query    View runnable query    Explain query

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\Users No errors.
App\Entity\Role No errors.
App\Entity\SurveySent No errors.
App\Entity\Survey No errors.
App\Entity\Student No errors.
App\Entity\Question
  • The field App\Entity\Question#answers is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Answers#qid does not contain the required 'inversedBy="answers"' attribute.
App\Entity\Answers No errors.