Symfony Profiler

Query Metrics

30 Database Queries

2 Different statements

10.31 ms Query time

1 Invalid entities

Queries

default connection


SELECT m0_.id AS id_0, m0_.name AS name_1, m0_.position AS position_2, m0_.created_date AS created_date_3, m0_.updated_date AS updated_date_4, m0_.program_level_id AS program_level_id_5 FROM major m0_ WHERE m0_.program_level_id = ? AND m0_.id <> ? AND m0_.id <> ? ORDER BY m0_.position ASC
SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.position AS position_2, s0_.is_active AS is_active_3, s0_.id_speciality_regional AS id_speciality_regional_4, s0_.created_date AS created_date_5, s0_.updated_date AS updated_date_6, s0_.program_level_id AS program_level_id_7, s0_.major_id AS major_id_8 FROM speciality s0_ WHERE s0_.id <> ? AND s0_.major_id = ? AND s0_.is_active = 1 ORDER BY s0_.position ASC
SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.position AS position_2, s0_.is_active AS is_active_3, s0_.id_speciality_regional AS id_speciality_regional_4, s0_.created_date AS created_date_5, s0_.updated_date AS updated_date_6, s0_.program_level_id AS program_level_id_7, s0_.major_id AS major_id_8 FROM speciality s0_ WHERE s0_.id <> ? AND s0_.major_id = ? AND s0_.is_active = 1 ORDER BY s0_.position ASC
SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.position AS position_2, s0_.is_active AS is_active_3, s0_.id_speciality_regional AS id_speciality_regional_4, s0_.created_date AS created_date_5, s0_.updated_date AS updated_date_6, s0_.program_level_id AS program_level_id_7, s0_.major_id AS major_id_8 FROM speciality s0_ WHERE s0_.id <> ? AND s0_.major_id = ? AND s0_.is_active = 1 ORDER BY s0_.position ASC
SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.position AS position_2, s0_.is_active AS is_active_3, s0_.id_speciality_regional AS id_speciality_regional_4, s0_.created_date AS created_date_5, s0_.updated_date AS updated_date_6, s0_.program_level_id AS program_level_id_7, s0_.major_id AS major_id_8 FROM speciality s0_ WHERE s0_.id <> ? AND s0_.major_id = ? AND s0_.is_active = 1 ORDER BY s0_.position ASC
SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.position AS position_2, s0_.is_active AS is_active_3, s0_.id_speciality_regional AS id_speciality_regional_4, s0_.created_date AS created_date_5, s0_.updated_date AS updated_date_6, s0_.program_level_id AS program_level_id_7, s0_.major_id AS major_id_8 FROM speciality s0_ WHERE s0_.id <> ? AND s0_.major_id = ? AND s0_.is_active = 1 ORDER BY s0_.position ASC
SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.position AS position_2, s0_.is_active AS is_active_3, s0_.id_speciality_regional AS id_speciality_regional_4, s0_.created_date AS created_date_5, s0_.updated_date AS updated_date_6, s0_.program_level_id AS program_level_id_7, s0_.major_id AS major_id_8 FROM speciality s0_ WHERE s0_.id <> ? AND s0_.major_id = ? AND s0_.is_active = 1 ORDER BY s0_.position ASC
SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.position AS position_2, s0_.is_active AS is_active_3, s0_.id_speciality_regional AS id_speciality_regional_4, s0_.created_date AS created_date_5, s0_.updated_date AS updated_date_6, s0_.program_level_id AS program_level_id_7, s0_.major_id AS major_id_8 FROM speciality s0_ WHERE s0_.id <> ? AND s0_.major_id = ? AND s0_.is_active = 1 ORDER BY s0_.position ASC
SELECT m0_.id AS id_0, m0_.name AS name_1, m0_.position AS position_2, m0_.created_date AS created_date_3, m0_.updated_date AS updated_date_4, m0_.program_level_id AS program_level_id_5 FROM major m0_ WHERE m0_.program_level_id = ? AND m0_.id <> ? AND m0_.id <> ? ORDER BY m0_.position ASC
SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.position AS position_2, s0_.is_active AS is_active_3, s0_.id_speciality_regional AS id_speciality_regional_4, s0_.created_date AS created_date_5, s0_.updated_date AS updated_date_6, s0_.program_level_id AS program_level_id_7, s0_.major_id AS major_id_8 FROM speciality s0_ WHERE s0_.id <> ? AND s0_.major_id = ? AND s0_.is_active = 1 ORDER BY s0_.position ASC
SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.position AS position_2, s0_.is_active AS is_active_3, s0_.id_speciality_regional AS id_speciality_regional_4, s0_.created_date AS created_date_5, s0_.updated_date AS updated_date_6, s0_.program_level_id AS program_level_id_7, s0_.major_id AS major_id_8 FROM speciality s0_ WHERE s0_.id <> ? AND s0_.major_id = ? AND s0_.is_active = 1 ORDER BY s0_.position ASC
SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.position AS position_2, s0_.is_active AS is_active_3, s0_.id_speciality_regional AS id_speciality_regional_4, s0_.created_date AS created_date_5, s0_.updated_date AS updated_date_6, s0_.program_level_id AS program_level_id_7, s0_.major_id AS major_id_8 FROM speciality s0_ WHERE s0_.id <> ? AND s0_.major_id = ? AND s0_.is_active = 1 ORDER BY s0_.position ASC
SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.position AS position_2, s0_.is_active AS is_active_3, s0_.id_speciality_regional AS id_speciality_regional_4, s0_.created_date AS created_date_5, s0_.updated_date AS updated_date_6, s0_.program_level_id AS program_level_id_7, s0_.major_id AS major_id_8 FROM speciality s0_ WHERE s0_.id <> ? AND s0_.major_id = ? AND s0_.is_active = 1 ORDER BY s0_.position ASC
SELECT m0_.id AS id_0, m0_.name AS name_1, m0_.position AS position_2, m0_.created_date AS created_date_3, m0_.updated_date AS updated_date_4, m0_.program_level_id AS program_level_id_5 FROM major m0_ WHERE m0_.program_level_id = ? AND m0_.id <> ? AND m0_.id <> ? ORDER BY m0_.position ASC
SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.position AS position_2, s0_.is_active AS is_active_3, s0_.id_speciality_regional AS id_speciality_regional_4, s0_.created_date AS created_date_5, s0_.updated_date AS updated_date_6, s0_.program_level_id AS program_level_id_7, s0_.major_id AS major_id_8 FROM speciality s0_ WHERE s0_.id <> ? AND s0_.major_id = ? AND s0_.is_active = 1 ORDER BY s0_.position ASC
SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.position AS position_2, s0_.is_active AS is_active_3, s0_.id_speciality_regional AS id_speciality_regional_4, s0_.created_date AS created_date_5, s0_.updated_date AS updated_date_6, s0_.program_level_id AS program_level_id_7, s0_.major_id AS major_id_8 FROM speciality s0_ WHERE s0_.id <> ? AND s0_.major_id = ? AND s0_.is_active = 1 ORDER BY s0_.position ASC
SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.position AS position_2, s0_.is_active AS is_active_3, s0_.id_speciality_regional AS id_speciality_regional_4, s0_.created_date AS created_date_5, s0_.updated_date AS updated_date_6, s0_.program_level_id AS program_level_id_7, s0_.major_id AS major_id_8 FROM speciality s0_ WHERE s0_.id <> ? AND s0_.major_id = ? AND s0_.is_active = 1 ORDER BY s0_.position ASC
SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.position AS position_2, s0_.is_active AS is_active_3, s0_.id_speciality_regional AS id_speciality_regional_4, s0_.created_date AS created_date_5, s0_.updated_date AS updated_date_6, s0_.program_level_id AS program_level_id_7, s0_.major_id AS major_id_8 FROM speciality s0_ WHERE s0_.id <> ? AND s0_.major_id = ? AND s0_.is_active = 1 ORDER BY s0_.position ASC
SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.position AS position_2, s0_.is_active AS is_active_3, s0_.id_speciality_regional AS id_speciality_regional_4, s0_.created_date AS created_date_5, s0_.updated_date AS updated_date_6, s0_.program_level_id AS program_level_id_7, s0_.major_id AS major_id_8 FROM speciality s0_ WHERE s0_.id <> ? AND s0_.major_id = ? AND s0_.is_active = 1 ORDER BY s0_.position ASC
SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.position AS position_2, s0_.is_active AS is_active_3, s0_.id_speciality_regional AS id_speciality_regional_4, s0_.created_date AS created_date_5, s0_.updated_date AS updated_date_6, s0_.program_level_id AS program_level_id_7, s0_.major_id AS major_id_8 FROM speciality s0_ WHERE s0_.id <> ? AND s0_.major_id = ? AND s0_.is_active = 1 ORDER BY s0_.position ASC
SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.position AS position_2, s0_.is_active AS is_active_3, s0_.id_speciality_regional AS id_speciality_regional_4, s0_.created_date AS created_date_5, s0_.updated_date AS updated_date_6, s0_.program_level_id AS program_level_id_7, s0_.major_id AS major_id_8 FROM speciality s0_ WHERE s0_.id <> ? AND s0_.major_id = ? AND s0_.is_active = 1 ORDER BY s0_.position ASC
SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.position AS position_2, s0_.is_active AS is_active_3, s0_.id_speciality_regional AS id_speciality_regional_4, s0_.created_date AS created_date_5, s0_.updated_date AS updated_date_6, s0_.program_level_id AS program_level_id_7, s0_.major_id AS major_id_8 FROM speciality s0_ WHERE s0_.id <> ? AND s0_.major_id = ? AND s0_.is_active = 1 ORDER BY s0_.position ASC
SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.position AS position_2, s0_.is_active AS is_active_3, s0_.id_speciality_regional AS id_speciality_regional_4, s0_.created_date AS created_date_5, s0_.updated_date AS updated_date_6, s0_.program_level_id AS program_level_id_7, s0_.major_id AS major_id_8 FROM speciality s0_ WHERE s0_.id <> ? AND s0_.major_id = ? AND s0_.is_active = 1 ORDER BY s0_.position ASC
SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.position AS position_2, s0_.is_active AS is_active_3, s0_.id_speciality_regional AS id_speciality_regional_4, s0_.created_date AS created_date_5, s0_.updated_date AS updated_date_6, s0_.program_level_id AS program_level_id_7, s0_.major_id AS major_id_8 FROM speciality s0_ WHERE s0_.id <> ? AND s0_.major_id = ? AND s0_.is_active = 1 ORDER BY s0_.position ASC
SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.position AS position_2, s0_.is_active AS is_active_3, s0_.id_speciality_regional AS id_speciality_regional_4, s0_.created_date AS created_date_5, s0_.updated_date AS updated_date_6, s0_.program_level_id AS program_level_id_7, s0_.major_id AS major_id_8 FROM speciality s0_ WHERE s0_.id <> ? AND s0_.major_id = ? AND s0_.is_active = 1 ORDER BY s0_.position ASC
SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.position AS position_2, s0_.is_active AS is_active_3, s0_.id_speciality_regional AS id_speciality_regional_4, s0_.created_date AS created_date_5, s0_.updated_date AS updated_date_6, s0_.program_level_id AS program_level_id_7, s0_.major_id AS major_id_8 FROM speciality s0_ WHERE s0_.id <> ? AND s0_.major_id = ? AND s0_.is_active = 1 ORDER BY s0_.position ASC
SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.position AS position_2, s0_.is_active AS is_active_3, s0_.id_speciality_regional AS id_speciality_regional_4, s0_.created_date AS created_date_5, s0_.updated_date AS updated_date_6, s0_.program_level_id AS program_level_id_7, s0_.major_id AS major_id_8 FROM speciality s0_ WHERE s0_.id <> ? AND s0_.major_id = ? AND s0_.is_active = 1 ORDER BY s0_.position ASC
SELECT m0_.id AS id_0, m0_.name AS name_1, m0_.position AS position_2, m0_.created_date AS created_date_3, m0_.updated_date AS updated_date_4, m0_.program_level_id AS program_level_id_5 FROM major m0_ WHERE m0_.program_level_id = ? AND m0_.id <> ? AND m0_.id <> ? ORDER BY m0_.position ASC
SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.position AS position_2, s0_.is_active AS is_active_3, s0_.id_speciality_regional AS id_speciality_regional_4, s0_.created_date AS created_date_5, s0_.updated_date AS updated_date_6, s0_.program_level_id AS program_level_id_7, s0_.major_id AS major_id_8 FROM speciality s0_ WHERE s0_.id <> ? AND s0_.major_id = ? AND s0_.is_active = 1 ORDER BY s0_.position ASC
SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.position AS position_2, s0_.is_active AS is_active_3, s0_.id_speciality_regional AS id_speciality_regional_4, s0_.created_date AS created_date_5, s0_.updated_date AS updated_date_6, s0_.program_level_id AS program_level_id_7, s0_.major_id AS major_id_8 FROM speciality s0_ WHERE s0_.id <> ? AND s0_.major_id = ? AND s0_.is_active = 1 ORDER BY s0_.position ASC

#▲	Time	Info
1	1.13 ms	SELECT m0_.id AS id_0, m0_.name AS name_1, m0_.position AS position_2, m0_.created_date AS created_date_3, m0_.updated_date AS updated_date_4, m0_.program_level_id AS program_level_id_5 FROM major m0_ WHERE m0_.program_level_id = ? AND m0_.id <> ? AND m0_.id <> ? ORDER BY m0_.position ASC Parameters: [`2 1 14`] View formatted query View runnable query Explain query SELECT m0_.id AS id_0, m0_.name AS name_1, m0_.position AS position_2, m0_.created_date AS created_date_3, m0_.updated_date AS updated_date_4, m0_.program_level_id AS program_level_id_5 FROM major m0_ WHERE m0_.program_level_id = ? AND m0_.id <> ? AND m0_.id <> ? ORDER BY m0_.position ASC SELECT m0_.id AS id_0, m0_.name AS name_1, m0_.position AS position_2, m0_.created_date AS created_date_3, m0_.updated_date AS updated_date_4, m0_.program_level_id AS program_level_id_5 FROM major m0_ WHERE m0_.program_level_id = 2 AND m0_.id <> 1 AND m0_.id <> 14 ORDER BY m0_.position ASC;
2	0.84 ms	SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.position AS position_2, s0_.is_active AS is_active_3, s0_.id_speciality_regional AS id_speciality_regional_4, s0_.created_date AS created_date_5, s0_.updated_date AS updated_date_6, s0_.program_level_id AS program_level_id_7, s0_.major_id AS major_id_8 FROM speciality s0_ WHERE s0_.id <> ? AND s0_.major_id = ? AND s0_.is_active = 1 ORDER BY s0_.position ASC Parameters: [`299 2`] View formatted query View runnable query Explain query SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.position AS position_2, s0_.is_active AS is_active_3, s0_.id_speciality_regional AS id_speciality_regional_4, s0_.created_date AS created_date_5, s0_.updated_date AS updated_date_6, s0_.program_level_id AS program_level_id_7, s0_.major_id AS major_id_8 FROM speciality s0_ WHERE s0_.id <> ? AND s0_.major_id = ? AND s0_.is_active = 1 ORDER BY s0_.position ASC SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.position AS position_2, s0_.is_active AS is_active_3, s0_.id_speciality_regional AS id_speciality_regional_4, s0_.created_date AS created_date_5, s0_.updated_date AS updated_date_6, s0_.program_level_id AS program_level_id_7, s0_.major_id AS major_id_8 FROM speciality s0_ WHERE s0_.id <> 299 AND s0_.major_id = 2 AND s0_.is_active = 1 ORDER BY s0_.position ASC;
3	0.25 ms	SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.position AS position_2, s0_.is_active AS is_active_3, s0_.id_speciality_regional AS id_speciality_regional_4, s0_.created_date AS created_date_5, s0_.updated_date AS updated_date_6, s0_.program_level_id AS program_level_id_7, s0_.major_id AS major_id_8 FROM speciality s0_ WHERE s0_.id <> ? AND s0_.major_id = ? AND s0_.is_active = 1 ORDER BY s0_.position ASC Parameters: [`299 3`] View formatted query View runnable query Explain query SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.position AS position_2, s0_.is_active AS is_active_3, s0_.id_speciality_regional AS id_speciality_regional_4, s0_.created_date AS created_date_5, s0_.updated_date AS updated_date_6, s0_.program_level_id AS program_level_id_7, s0_.major_id AS major_id_8 FROM speciality s0_ WHERE s0_.id <> ? AND s0_.major_id = ? AND s0_.is_active = 1 ORDER BY s0_.position ASC SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.position AS position_2, s0_.is_active AS is_active_3, s0_.id_speciality_regional AS id_speciality_regional_4, s0_.created_date AS created_date_5, s0_.updated_date AS updated_date_6, s0_.program_level_id AS program_level_id_7, s0_.major_id AS major_id_8 FROM speciality s0_ WHERE s0_.id <> 299 AND s0_.major_id = 3 AND s0_.is_active = 1 ORDER BY s0_.position ASC;
4	0.22 ms	SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.position AS position_2, s0_.is_active AS is_active_3, s0_.id_speciality_regional AS id_speciality_regional_4, s0_.created_date AS created_date_5, s0_.updated_date AS updated_date_6, s0_.program_level_id AS program_level_id_7, s0_.major_id AS major_id_8 FROM speciality s0_ WHERE s0_.id <> ? AND s0_.major_id = ? AND s0_.is_active = 1 ORDER BY s0_.position ASC Parameters: [`299 4`] View formatted query View runnable query Explain query SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.position AS position_2, s0_.is_active AS is_active_3, s0_.id_speciality_regional AS id_speciality_regional_4, s0_.created_date AS created_date_5, s0_.updated_date AS updated_date_6, s0_.program_level_id AS program_level_id_7, s0_.major_id AS major_id_8 FROM speciality s0_ WHERE s0_.id <> ? AND s0_.major_id = ? AND s0_.is_active = 1 ORDER BY s0_.position ASC SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.position AS position_2, s0_.is_active AS is_active_3, s0_.id_speciality_regional AS id_speciality_regional_4, s0_.created_date AS created_date_5, s0_.updated_date AS updated_date_6, s0_.program_level_id AS program_level_id_7, s0_.major_id AS major_id_8 FROM speciality s0_ WHERE s0_.id <> 299 AND s0_.major_id = 4 AND s0_.is_active = 1 ORDER BY s0_.position ASC;
5	0.20 ms	SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.position AS position_2, s0_.is_active AS is_active_3, s0_.id_speciality_regional AS id_speciality_regional_4, s0_.created_date AS created_date_5, s0_.updated_date AS updated_date_6, s0_.program_level_id AS program_level_id_7, s0_.major_id AS major_id_8 FROM speciality s0_ WHERE s0_.id <> ? AND s0_.major_id = ? AND s0_.is_active = 1 ORDER BY s0_.position ASC Parameters: [`299 5`] View formatted query View runnable query Explain query SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.position AS position_2, s0_.is_active AS is_active_3, s0_.id_speciality_regional AS id_speciality_regional_4, s0_.created_date AS created_date_5, s0_.updated_date AS updated_date_6, s0_.program_level_id AS program_level_id_7, s0_.major_id AS major_id_8 FROM speciality s0_ WHERE s0_.id <> ? AND s0_.major_id = ? AND s0_.is_active = 1 ORDER BY s0_.position ASC SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.position AS position_2, s0_.is_active AS is_active_3, s0_.id_speciality_regional AS id_speciality_regional_4, s0_.created_date AS created_date_5, s0_.updated_date AS updated_date_6, s0_.program_level_id AS program_level_id_7, s0_.major_id AS major_id_8 FROM speciality s0_ WHERE s0_.id <> 299 AND s0_.major_id = 5 AND s0_.is_active = 1 ORDER BY s0_.position ASC;
6	0.22 ms	SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.position AS position_2, s0_.is_active AS is_active_3, s0_.id_speciality_regional AS id_speciality_regional_4, s0_.created_date AS created_date_5, s0_.updated_date AS updated_date_6, s0_.program_level_id AS program_level_id_7, s0_.major_id AS major_id_8 FROM speciality s0_ WHERE s0_.id <> ? AND s0_.major_id = ? AND s0_.is_active = 1 ORDER BY s0_.position ASC Parameters: [`299 6`] View formatted query View runnable query Explain query SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.position AS position_2, s0_.is_active AS is_active_3, s0_.id_speciality_regional AS id_speciality_regional_4, s0_.created_date AS created_date_5, s0_.updated_date AS updated_date_6, s0_.program_level_id AS program_level_id_7, s0_.major_id AS major_id_8 FROM speciality s0_ WHERE s0_.id <> ? AND s0_.major_id = ? AND s0_.is_active = 1 ORDER BY s0_.position ASC SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.position AS position_2, s0_.is_active AS is_active_3, s0_.id_speciality_regional AS id_speciality_regional_4, s0_.created_date AS created_date_5, s0_.updated_date AS updated_date_6, s0_.program_level_id AS program_level_id_7, s0_.major_id AS major_id_8 FROM speciality s0_ WHERE s0_.id <> 299 AND s0_.major_id = 6 AND s0_.is_active = 1 ORDER BY s0_.position ASC;
7	0.21 ms	SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.position AS position_2, s0_.is_active AS is_active_3, s0_.id_speciality_regional AS id_speciality_regional_4, s0_.created_date AS created_date_5, s0_.updated_date AS updated_date_6, s0_.program_level_id AS program_level_id_7, s0_.major_id AS major_id_8 FROM speciality s0_ WHERE s0_.id <> ? AND s0_.major_id = ? AND s0_.is_active = 1 ORDER BY s0_.position ASC Parameters: [`299 7`] View formatted query View runnable query Explain query SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.position AS position_2, s0_.is_active AS is_active_3, s0_.id_speciality_regional AS id_speciality_regional_4, s0_.created_date AS created_date_5, s0_.updated_date AS updated_date_6, s0_.program_level_id AS program_level_id_7, s0_.major_id AS major_id_8 FROM speciality s0_ WHERE s0_.id <> ? AND s0_.major_id = ? AND s0_.is_active = 1 ORDER BY s0_.position ASC SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.position AS position_2, s0_.is_active AS is_active_3, s0_.id_speciality_regional AS id_speciality_regional_4, s0_.created_date AS created_date_5, s0_.updated_date AS updated_date_6, s0_.program_level_id AS program_level_id_7, s0_.major_id AS major_id_8 FROM speciality s0_ WHERE s0_.id <> 299 AND s0_.major_id = 7 AND s0_.is_active = 1 ORDER BY s0_.position ASC;
8	2.56 ms	SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.position AS position_2, s0_.is_active AS is_active_3, s0_.id_speciality_regional AS id_speciality_regional_4, s0_.created_date AS created_date_5, s0_.updated_date AS updated_date_6, s0_.program_level_id AS program_level_id_7, s0_.major_id AS major_id_8 FROM speciality s0_ WHERE s0_.id <> ? AND s0_.major_id = ? AND s0_.is_active = 1 ORDER BY s0_.position ASC Parameters: [`299 13`] View formatted query View runnable query Explain query SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.position AS position_2, s0_.is_active AS is_active_3, s0_.id_speciality_regional AS id_speciality_regional_4, s0_.created_date AS created_date_5, s0_.updated_date AS updated_date_6, s0_.program_level_id AS program_level_id_7, s0_.major_id AS major_id_8 FROM speciality s0_ WHERE s0_.id <> ? AND s0_.major_id = ? AND s0_.is_active = 1 ORDER BY s0_.position ASC SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.position AS position_2, s0_.is_active AS is_active_3, s0_.id_speciality_regional AS id_speciality_regional_4, s0_.created_date AS created_date_5, s0_.updated_date AS updated_date_6, s0_.program_level_id AS program_level_id_7, s0_.major_id AS major_id_8 FROM speciality s0_ WHERE s0_.id <> 299 AND s0_.major_id = 13 AND s0_.is_active = 1 ORDER BY s0_.position ASC;
9	0.20 ms	SELECT m0_.id AS id_0, m0_.name AS name_1, m0_.position AS position_2, m0_.created_date AS created_date_3, m0_.updated_date AS updated_date_4, m0_.program_level_id AS program_level_id_5 FROM major m0_ WHERE m0_.program_level_id = ? AND m0_.id <> ? AND m0_.id <> ? ORDER BY m0_.position ASC Parameters: [`3 1 14`] View formatted query View runnable query Explain query SELECT m0_.id AS id_0, m0_.name AS name_1, m0_.position AS position_2, m0_.created_date AS created_date_3, m0_.updated_date AS updated_date_4, m0_.program_level_id AS program_level_id_5 FROM major m0_ WHERE m0_.program_level_id = ? AND m0_.id <> ? AND m0_.id <> ? ORDER BY m0_.position ASC SELECT m0_.id AS id_0, m0_.name AS name_1, m0_.position AS position_2, m0_.created_date AS created_date_3, m0_.updated_date AS updated_date_4, m0_.program_level_id AS program_level_id_5 FROM major m0_ WHERE m0_.program_level_id = 3 AND m0_.id <> 1 AND m0_.id <> 14 ORDER BY m0_.position ASC;
10	0.21 ms	SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.position AS position_2, s0_.is_active AS is_active_3, s0_.id_speciality_regional AS id_speciality_regional_4, s0_.created_date AS created_date_5, s0_.updated_date AS updated_date_6, s0_.program_level_id AS program_level_id_7, s0_.major_id AS major_id_8 FROM speciality s0_ WHERE s0_.id <> ? AND s0_.major_id = ? AND s0_.is_active = 1 ORDER BY s0_.position ASC Parameters: [`299 9`] View formatted query View runnable query Explain query SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.position AS position_2, s0_.is_active AS is_active_3, s0_.id_speciality_regional AS id_speciality_regional_4, s0_.created_date AS created_date_5, s0_.updated_date AS updated_date_6, s0_.program_level_id AS program_level_id_7, s0_.major_id AS major_id_8 FROM speciality s0_ WHERE s0_.id <> ? AND s0_.major_id = ? AND s0_.is_active = 1 ORDER BY s0_.position ASC SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.position AS position_2, s0_.is_active AS is_active_3, s0_.id_speciality_regional AS id_speciality_regional_4, s0_.created_date AS created_date_5, s0_.updated_date AS updated_date_6, s0_.program_level_id AS program_level_id_7, s0_.major_id AS major_id_8 FROM speciality s0_ WHERE s0_.id <> 299 AND s0_.major_id = 9 AND s0_.is_active = 1 ORDER BY s0_.position ASC;
11	0.26 ms	SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.position AS position_2, s0_.is_active AS is_active_3, s0_.id_speciality_regional AS id_speciality_regional_4, s0_.created_date AS created_date_5, s0_.updated_date AS updated_date_6, s0_.program_level_id AS program_level_id_7, s0_.major_id AS major_id_8 FROM speciality s0_ WHERE s0_.id <> ? AND s0_.major_id = ? AND s0_.is_active = 1 ORDER BY s0_.position ASC Parameters: [`299 10`] View formatted query View runnable query Explain query SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.position AS position_2, s0_.is_active AS is_active_3, s0_.id_speciality_regional AS id_speciality_regional_4, s0_.created_date AS created_date_5, s0_.updated_date AS updated_date_6, s0_.program_level_id AS program_level_id_7, s0_.major_id AS major_id_8 FROM speciality s0_ WHERE s0_.id <> ? AND s0_.major_id = ? AND s0_.is_active = 1 ORDER BY s0_.position ASC SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.position AS position_2, s0_.is_active AS is_active_3, s0_.id_speciality_regional AS id_speciality_regional_4, s0_.created_date AS created_date_5, s0_.updated_date AS updated_date_6, s0_.program_level_id AS program_level_id_7, s0_.major_id AS major_id_8 FROM speciality s0_ WHERE s0_.id <> 299 AND s0_.major_id = 10 AND s0_.is_active = 1 ORDER BY s0_.position ASC;
12	0.22 ms	SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.position AS position_2, s0_.is_active AS is_active_3, s0_.id_speciality_regional AS id_speciality_regional_4, s0_.created_date AS created_date_5, s0_.updated_date AS updated_date_6, s0_.program_level_id AS program_level_id_7, s0_.major_id AS major_id_8 FROM speciality s0_ WHERE s0_.id <> ? AND s0_.major_id = ? AND s0_.is_active = 1 ORDER BY s0_.position ASC Parameters: [`299 11`] View formatted query View runnable query Explain query SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.position AS position_2, s0_.is_active AS is_active_3, s0_.id_speciality_regional AS id_speciality_regional_4, s0_.created_date AS created_date_5, s0_.updated_date AS updated_date_6, s0_.program_level_id AS program_level_id_7, s0_.major_id AS major_id_8 FROM speciality s0_ WHERE s0_.id <> ? AND s0_.major_id = ? AND s0_.is_active = 1 ORDER BY s0_.position ASC SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.position AS position_2, s0_.is_active AS is_active_3, s0_.id_speciality_regional AS id_speciality_regional_4, s0_.created_date AS created_date_5, s0_.updated_date AS updated_date_6, s0_.program_level_id AS program_level_id_7, s0_.major_id AS major_id_8 FROM speciality s0_ WHERE s0_.id <> 299 AND s0_.major_id = 11 AND s0_.is_active = 1 ORDER BY s0_.position ASC;
13	0.20 ms	SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.position AS position_2, s0_.is_active AS is_active_3, s0_.id_speciality_regional AS id_speciality_regional_4, s0_.created_date AS created_date_5, s0_.updated_date AS updated_date_6, s0_.program_level_id AS program_level_id_7, s0_.major_id AS major_id_8 FROM speciality s0_ WHERE s0_.id <> ? AND s0_.major_id = ? AND s0_.is_active = 1 ORDER BY s0_.position ASC Parameters: [`299 12`] View formatted query View runnable query Explain query SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.position AS position_2, s0_.is_active AS is_active_3, s0_.id_speciality_regional AS id_speciality_regional_4, s0_.created_date AS created_date_5, s0_.updated_date AS updated_date_6, s0_.program_level_id AS program_level_id_7, s0_.major_id AS major_id_8 FROM speciality s0_ WHERE s0_.id <> ? AND s0_.major_id = ? AND s0_.is_active = 1 ORDER BY s0_.position ASC SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.position AS position_2, s0_.is_active AS is_active_3, s0_.id_speciality_regional AS id_speciality_regional_4, s0_.created_date AS created_date_5, s0_.updated_date AS updated_date_6, s0_.program_level_id AS program_level_id_7, s0_.major_id AS major_id_8 FROM speciality s0_ WHERE s0_.id <> 299 AND s0_.major_id = 12 AND s0_.is_active = 1 ORDER BY s0_.position ASC;
14	0.24 ms	SELECT m0_.id AS id_0, m0_.name AS name_1, m0_.position AS position_2, m0_.created_date AS created_date_3, m0_.updated_date AS updated_date_4, m0_.program_level_id AS program_level_id_5 FROM major m0_ WHERE m0_.program_level_id = ? AND m0_.id <> ? AND m0_.id <> ? ORDER BY m0_.position ASC Parameters: [`1 1 14`] View formatted query View runnable query Explain query SELECT m0_.id AS id_0, m0_.name AS name_1, m0_.position AS position_2, m0_.created_date AS created_date_3, m0_.updated_date AS updated_date_4, m0_.program_level_id AS program_level_id_5 FROM major m0_ WHERE m0_.program_level_id = ? AND m0_.id <> ? AND m0_.id <> ? ORDER BY m0_.position ASC SELECT m0_.id AS id_0, m0_.name AS name_1, m0_.position AS position_2, m0_.created_date AS created_date_3, m0_.updated_date AS updated_date_4, m0_.program_level_id AS program_level_id_5 FROM major m0_ WHERE m0_.program_level_id = 1 AND m0_.id <> 1 AND m0_.id <> 14 ORDER BY m0_.position ASC;
15	0.20 ms	SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.position AS position_2, s0_.is_active AS is_active_3, s0_.id_speciality_regional AS id_speciality_regional_4, s0_.created_date AS created_date_5, s0_.updated_date AS updated_date_6, s0_.program_level_id AS program_level_id_7, s0_.major_id AS major_id_8 FROM speciality s0_ WHERE s0_.id <> ? AND s0_.major_id = ? AND s0_.is_active = 1 ORDER BY s0_.position ASC Parameters: [`299 15`] View formatted query View runnable query Explain query SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.position AS position_2, s0_.is_active AS is_active_3, s0_.id_speciality_regional AS id_speciality_regional_4, s0_.created_date AS created_date_5, s0_.updated_date AS updated_date_6, s0_.program_level_id AS program_level_id_7, s0_.major_id AS major_id_8 FROM speciality s0_ WHERE s0_.id <> ? AND s0_.major_id = ? AND s0_.is_active = 1 ORDER BY s0_.position ASC SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.position AS position_2, s0_.is_active AS is_active_3, s0_.id_speciality_regional AS id_speciality_regional_4, s0_.created_date AS created_date_5, s0_.updated_date AS updated_date_6, s0_.program_level_id AS program_level_id_7, s0_.major_id AS major_id_8 FROM speciality s0_ WHERE s0_.id <> 299 AND s0_.major_id = 15 AND s0_.is_active = 1 ORDER BY s0_.position ASC;
16	0.22 ms	SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.position AS position_2, s0_.is_active AS is_active_3, s0_.id_speciality_regional AS id_speciality_regional_4, s0_.created_date AS created_date_5, s0_.updated_date AS updated_date_6, s0_.program_level_id AS program_level_id_7, s0_.major_id AS major_id_8 FROM speciality s0_ WHERE s0_.id <> ? AND s0_.major_id = ? AND s0_.is_active = 1 ORDER BY s0_.position ASC Parameters: [`299 16`] View formatted query View runnable query Explain query SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.position AS position_2, s0_.is_active AS is_active_3, s0_.id_speciality_regional AS id_speciality_regional_4, s0_.created_date AS created_date_5, s0_.updated_date AS updated_date_6, s0_.program_level_id AS program_level_id_7, s0_.major_id AS major_id_8 FROM speciality s0_ WHERE s0_.id <> ? AND s0_.major_id = ? AND s0_.is_active = 1 ORDER BY s0_.position ASC SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.position AS position_2, s0_.is_active AS is_active_3, s0_.id_speciality_regional AS id_speciality_regional_4, s0_.created_date AS created_date_5, s0_.updated_date AS updated_date_6, s0_.program_level_id AS program_level_id_7, s0_.major_id AS major_id_8 FROM speciality s0_ WHERE s0_.id <> 299 AND s0_.major_id = 16 AND s0_.is_active = 1 ORDER BY s0_.position ASC;
17	0.21 ms	SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.position AS position_2, s0_.is_active AS is_active_3, s0_.id_speciality_regional AS id_speciality_regional_4, s0_.created_date AS created_date_5, s0_.updated_date AS updated_date_6, s0_.program_level_id AS program_level_id_7, s0_.major_id AS major_id_8 FROM speciality s0_ WHERE s0_.id <> ? AND s0_.major_id = ? AND s0_.is_active = 1 ORDER BY s0_.position ASC Parameters: [`299 17`] View formatted query View runnable query Explain query SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.position AS position_2, s0_.is_active AS is_active_3, s0_.id_speciality_regional AS id_speciality_regional_4, s0_.created_date AS created_date_5, s0_.updated_date AS updated_date_6, s0_.program_level_id AS program_level_id_7, s0_.major_id AS major_id_8 FROM speciality s0_ WHERE s0_.id <> ? AND s0_.major_id = ? AND s0_.is_active = 1 ORDER BY s0_.position ASC SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.position AS position_2, s0_.is_active AS is_active_3, s0_.id_speciality_regional AS id_speciality_regional_4, s0_.created_date AS created_date_5, s0_.updated_date AS updated_date_6, s0_.program_level_id AS program_level_id_7, s0_.major_id AS major_id_8 FROM speciality s0_ WHERE s0_.id <> 299 AND s0_.major_id = 17 AND s0_.is_active = 1 ORDER BY s0_.position ASC;
18	0.20 ms	SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.position AS position_2, s0_.is_active AS is_active_3, s0_.id_speciality_regional AS id_speciality_regional_4, s0_.created_date AS created_date_5, s0_.updated_date AS updated_date_6, s0_.program_level_id AS program_level_id_7, s0_.major_id AS major_id_8 FROM speciality s0_ WHERE s0_.id <> ? AND s0_.major_id = ? AND s0_.is_active = 1 ORDER BY s0_.position ASC Parameters: [`299 18`] View formatted query View runnable query Explain query SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.position AS position_2, s0_.is_active AS is_active_3, s0_.id_speciality_regional AS id_speciality_regional_4, s0_.created_date AS created_date_5, s0_.updated_date AS updated_date_6, s0_.program_level_id AS program_level_id_7, s0_.major_id AS major_id_8 FROM speciality s0_ WHERE s0_.id <> ? AND s0_.major_id = ? AND s0_.is_active = 1 ORDER BY s0_.position ASC SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.position AS position_2, s0_.is_active AS is_active_3, s0_.id_speciality_regional AS id_speciality_regional_4, s0_.created_date AS created_date_5, s0_.updated_date AS updated_date_6, s0_.program_level_id AS program_level_id_7, s0_.major_id AS major_id_8 FROM speciality s0_ WHERE s0_.id <> 299 AND s0_.major_id = 18 AND s0_.is_active = 1 ORDER BY s0_.position ASC;
19	0.22 ms	SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.position AS position_2, s0_.is_active AS is_active_3, s0_.id_speciality_regional AS id_speciality_regional_4, s0_.created_date AS created_date_5, s0_.updated_date AS updated_date_6, s0_.program_level_id AS program_level_id_7, s0_.major_id AS major_id_8 FROM speciality s0_ WHERE s0_.id <> ? AND s0_.major_id = ? AND s0_.is_active = 1 ORDER BY s0_.position ASC Parameters: [`299 19`] View formatted query View runnable query Explain query SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.position AS position_2, s0_.is_active AS is_active_3, s0_.id_speciality_regional AS id_speciality_regional_4, s0_.created_date AS created_date_5, s0_.updated_date AS updated_date_6, s0_.program_level_id AS program_level_id_7, s0_.major_id AS major_id_8 FROM speciality s0_ WHERE s0_.id <> ? AND s0_.major_id = ? AND s0_.is_active = 1 ORDER BY s0_.position ASC SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.position AS position_2, s0_.is_active AS is_active_3, s0_.id_speciality_regional AS id_speciality_regional_4, s0_.created_date AS created_date_5, s0_.updated_date AS updated_date_6, s0_.program_level_id AS program_level_id_7, s0_.major_id AS major_id_8 FROM speciality s0_ WHERE s0_.id <> 299 AND s0_.major_id = 19 AND s0_.is_active = 1 ORDER BY s0_.position ASC;
20	0.19 ms	SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.position AS position_2, s0_.is_active AS is_active_3, s0_.id_speciality_regional AS id_speciality_regional_4, s0_.created_date AS created_date_5, s0_.updated_date AS updated_date_6, s0_.program_level_id AS program_level_id_7, s0_.major_id AS major_id_8 FROM speciality s0_ WHERE s0_.id <> ? AND s0_.major_id = ? AND s0_.is_active = 1 ORDER BY s0_.position ASC Parameters: [`299 20`] View formatted query View runnable query Explain query SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.position AS position_2, s0_.is_active AS is_active_3, s0_.id_speciality_regional AS id_speciality_regional_4, s0_.created_date AS created_date_5, s0_.updated_date AS updated_date_6, s0_.program_level_id AS program_level_id_7, s0_.major_id AS major_id_8 FROM speciality s0_ WHERE s0_.id <> ? AND s0_.major_id = ? AND s0_.is_active = 1 ORDER BY s0_.position ASC SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.position AS position_2, s0_.is_active AS is_active_3, s0_.id_speciality_regional AS id_speciality_regional_4, s0_.created_date AS created_date_5, s0_.updated_date AS updated_date_6, s0_.program_level_id AS program_level_id_7, s0_.major_id AS major_id_8 FROM speciality s0_ WHERE s0_.id <> 299 AND s0_.major_id = 20 AND s0_.is_active = 1 ORDER BY s0_.position ASC;
21	0.22 ms	SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.position AS position_2, s0_.is_active AS is_active_3, s0_.id_speciality_regional AS id_speciality_regional_4, s0_.created_date AS created_date_5, s0_.updated_date AS updated_date_6, s0_.program_level_id AS program_level_id_7, s0_.major_id AS major_id_8 FROM speciality s0_ WHERE s0_.id <> ? AND s0_.major_id = ? AND s0_.is_active = 1 ORDER BY s0_.position ASC Parameters: [`299 21`] View formatted query View runnable query Explain query SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.position AS position_2, s0_.is_active AS is_active_3, s0_.id_speciality_regional AS id_speciality_regional_4, s0_.created_date AS created_date_5, s0_.updated_date AS updated_date_6, s0_.program_level_id AS program_level_id_7, s0_.major_id AS major_id_8 FROM speciality s0_ WHERE s0_.id <> ? AND s0_.major_id = ? AND s0_.is_active = 1 ORDER BY s0_.position ASC SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.position AS position_2, s0_.is_active AS is_active_3, s0_.id_speciality_regional AS id_speciality_regional_4, s0_.created_date AS created_date_5, s0_.updated_date AS updated_date_6, s0_.program_level_id AS program_level_id_7, s0_.major_id AS major_id_8 FROM speciality s0_ WHERE s0_.id <> 299 AND s0_.major_id = 21 AND s0_.is_active = 1 ORDER BY s0_.position ASC;
22	0.22 ms	SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.position AS position_2, s0_.is_active AS is_active_3, s0_.id_speciality_regional AS id_speciality_regional_4, s0_.created_date AS created_date_5, s0_.updated_date AS updated_date_6, s0_.program_level_id AS program_level_id_7, s0_.major_id AS major_id_8 FROM speciality s0_ WHERE s0_.id <> ? AND s0_.major_id = ? AND s0_.is_active = 1 ORDER BY s0_.position ASC Parameters: [`299 22`] View formatted query View runnable query Explain query SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.position AS position_2, s0_.is_active AS is_active_3, s0_.id_speciality_regional AS id_speciality_regional_4, s0_.created_date AS created_date_5, s0_.updated_date AS updated_date_6, s0_.program_level_id AS program_level_id_7, s0_.major_id AS major_id_8 FROM speciality s0_ WHERE s0_.id <> ? AND s0_.major_id = ? AND s0_.is_active = 1 ORDER BY s0_.position ASC SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.position AS position_2, s0_.is_active AS is_active_3, s0_.id_speciality_regional AS id_speciality_regional_4, s0_.created_date AS created_date_5, s0_.updated_date AS updated_date_6, s0_.program_level_id AS program_level_id_7, s0_.major_id AS major_id_8 FROM speciality s0_ WHERE s0_.id <> 299 AND s0_.major_id = 22 AND s0_.is_active = 1 ORDER BY s0_.position ASC;
23	0.20 ms	SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.position AS position_2, s0_.is_active AS is_active_3, s0_.id_speciality_regional AS id_speciality_regional_4, s0_.created_date AS created_date_5, s0_.updated_date AS updated_date_6, s0_.program_level_id AS program_level_id_7, s0_.major_id AS major_id_8 FROM speciality s0_ WHERE s0_.id <> ? AND s0_.major_id = ? AND s0_.is_active = 1 ORDER BY s0_.position ASC Parameters: [`299 23`] View formatted query View runnable query Explain query SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.position AS position_2, s0_.is_active AS is_active_3, s0_.id_speciality_regional AS id_speciality_regional_4, s0_.created_date AS created_date_5, s0_.updated_date AS updated_date_6, s0_.program_level_id AS program_level_id_7, s0_.major_id AS major_id_8 FROM speciality s0_ WHERE s0_.id <> ? AND s0_.major_id = ? AND s0_.is_active = 1 ORDER BY s0_.position ASC SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.position AS position_2, s0_.is_active AS is_active_3, s0_.id_speciality_regional AS id_speciality_regional_4, s0_.created_date AS created_date_5, s0_.updated_date AS updated_date_6, s0_.program_level_id AS program_level_id_7, s0_.major_id AS major_id_8 FROM speciality s0_ WHERE s0_.id <> 299 AND s0_.major_id = 23 AND s0_.is_active = 1 ORDER BY s0_.position ASC;
24	0.21 ms	SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.position AS position_2, s0_.is_active AS is_active_3, s0_.id_speciality_regional AS id_speciality_regional_4, s0_.created_date AS created_date_5, s0_.updated_date AS updated_date_6, s0_.program_level_id AS program_level_id_7, s0_.major_id AS major_id_8 FROM speciality s0_ WHERE s0_.id <> ? AND s0_.major_id = ? AND s0_.is_active = 1 ORDER BY s0_.position ASC Parameters: [`299 24`] View formatted query View runnable query Explain query SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.position AS position_2, s0_.is_active AS is_active_3, s0_.id_speciality_regional AS id_speciality_regional_4, s0_.created_date AS created_date_5, s0_.updated_date AS updated_date_6, s0_.program_level_id AS program_level_id_7, s0_.major_id AS major_id_8 FROM speciality s0_ WHERE s0_.id <> ? AND s0_.major_id = ? AND s0_.is_active = 1 ORDER BY s0_.position ASC SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.position AS position_2, s0_.is_active AS is_active_3, s0_.id_speciality_regional AS id_speciality_regional_4, s0_.created_date AS created_date_5, s0_.updated_date AS updated_date_6, s0_.program_level_id AS program_level_id_7, s0_.major_id AS major_id_8 FROM speciality s0_ WHERE s0_.id <> 299 AND s0_.major_id = 24 AND s0_.is_active = 1 ORDER BY s0_.position ASC;
25	0.20 ms	SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.position AS position_2, s0_.is_active AS is_active_3, s0_.id_speciality_regional AS id_speciality_regional_4, s0_.created_date AS created_date_5, s0_.updated_date AS updated_date_6, s0_.program_level_id AS program_level_id_7, s0_.major_id AS major_id_8 FROM speciality s0_ WHERE s0_.id <> ? AND s0_.major_id = ? AND s0_.is_active = 1 ORDER BY s0_.position ASC Parameters: [`299 27`] View formatted query View runnable query Explain query SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.position AS position_2, s0_.is_active AS is_active_3, s0_.id_speciality_regional AS id_speciality_regional_4, s0_.created_date AS created_date_5, s0_.updated_date AS updated_date_6, s0_.program_level_id AS program_level_id_7, s0_.major_id AS major_id_8 FROM speciality s0_ WHERE s0_.id <> ? AND s0_.major_id = ? AND s0_.is_active = 1 ORDER BY s0_.position ASC SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.position AS position_2, s0_.is_active AS is_active_3, s0_.id_speciality_regional AS id_speciality_regional_4, s0_.created_date AS created_date_5, s0_.updated_date AS updated_date_6, s0_.program_level_id AS program_level_id_7, s0_.major_id AS major_id_8 FROM speciality s0_ WHERE s0_.id <> 299 AND s0_.major_id = 27 AND s0_.is_active = 1 ORDER BY s0_.position ASC;
26	0.22 ms	SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.position AS position_2, s0_.is_active AS is_active_3, s0_.id_speciality_regional AS id_speciality_regional_4, s0_.created_date AS created_date_5, s0_.updated_date AS updated_date_6, s0_.program_level_id AS program_level_id_7, s0_.major_id AS major_id_8 FROM speciality s0_ WHERE s0_.id <> ? AND s0_.major_id = ? AND s0_.is_active = 1 ORDER BY s0_.position ASC Parameters: [`299 25`] View formatted query View runnable query Explain query SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.position AS position_2, s0_.is_active AS is_active_3, s0_.id_speciality_regional AS id_speciality_regional_4, s0_.created_date AS created_date_5, s0_.updated_date AS updated_date_6, s0_.program_level_id AS program_level_id_7, s0_.major_id AS major_id_8 FROM speciality s0_ WHERE s0_.id <> ? AND s0_.major_id = ? AND s0_.is_active = 1 ORDER BY s0_.position ASC SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.position AS position_2, s0_.is_active AS is_active_3, s0_.id_speciality_regional AS id_speciality_regional_4, s0_.created_date AS created_date_5, s0_.updated_date AS updated_date_6, s0_.program_level_id AS program_level_id_7, s0_.major_id AS major_id_8 FROM speciality s0_ WHERE s0_.id <> 299 AND s0_.major_id = 25 AND s0_.is_active = 1 ORDER BY s0_.position ASC;
27	0.20 ms	SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.position AS position_2, s0_.is_active AS is_active_3, s0_.id_speciality_regional AS id_speciality_regional_4, s0_.created_date AS created_date_5, s0_.updated_date AS updated_date_6, s0_.program_level_id AS program_level_id_7, s0_.major_id AS major_id_8 FROM speciality s0_ WHERE s0_.id <> ? AND s0_.major_id = ? AND s0_.is_active = 1 ORDER BY s0_.position ASC Parameters: [`299 26`] View formatted query View runnable query Explain query SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.position AS position_2, s0_.is_active AS is_active_3, s0_.id_speciality_regional AS id_speciality_regional_4, s0_.created_date AS created_date_5, s0_.updated_date AS updated_date_6, s0_.program_level_id AS program_level_id_7, s0_.major_id AS major_id_8 FROM speciality s0_ WHERE s0_.id <> ? AND s0_.major_id = ? AND s0_.is_active = 1 ORDER BY s0_.position ASC SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.position AS position_2, s0_.is_active AS is_active_3, s0_.id_speciality_regional AS id_speciality_regional_4, s0_.created_date AS created_date_5, s0_.updated_date AS updated_date_6, s0_.program_level_id AS program_level_id_7, s0_.major_id AS major_id_8 FROM speciality s0_ WHERE s0_.id <> 299 AND s0_.major_id = 26 AND s0_.is_active = 1 ORDER BY s0_.position ASC;
28	0.19 ms	SELECT m0_.id AS id_0, m0_.name AS name_1, m0_.position AS position_2, m0_.created_date AS created_date_3, m0_.updated_date AS updated_date_4, m0_.program_level_id AS program_level_id_5 FROM major m0_ WHERE m0_.program_level_id = ? AND m0_.id <> ? AND m0_.id <> ? ORDER BY m0_.position ASC Parameters: [`7 1 14`] View formatted query View runnable query Explain query SELECT m0_.id AS id_0, m0_.name AS name_1, m0_.position AS position_2, m0_.created_date AS created_date_3, m0_.updated_date AS updated_date_4, m0_.program_level_id AS program_level_id_5 FROM major m0_ WHERE m0_.program_level_id = ? AND m0_.id <> ? AND m0_.id <> ? ORDER BY m0_.position ASC SELECT m0_.id AS id_0, m0_.name AS name_1, m0_.position AS position_2, m0_.created_date AS created_date_3, m0_.updated_date AS updated_date_4, m0_.program_level_id AS program_level_id_5 FROM major m0_ WHERE m0_.program_level_id = 7 AND m0_.id <> 1 AND m0_.id <> 14 ORDER BY m0_.position ASC;
29	0.22 ms	SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.position AS position_2, s0_.is_active AS is_active_3, s0_.id_speciality_regional AS id_speciality_regional_4, s0_.created_date AS created_date_5, s0_.updated_date AS updated_date_6, s0_.program_level_id AS program_level_id_7, s0_.major_id AS major_id_8 FROM speciality s0_ WHERE s0_.id <> ? AND s0_.major_id = ? AND s0_.is_active = 1 ORDER BY s0_.position ASC Parameters: [`299 40`] View formatted query View runnable query Explain query SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.position AS position_2, s0_.is_active AS is_active_3, s0_.id_speciality_regional AS id_speciality_regional_4, s0_.created_date AS created_date_5, s0_.updated_date AS updated_date_6, s0_.program_level_id AS program_level_id_7, s0_.major_id AS major_id_8 FROM speciality s0_ WHERE s0_.id <> ? AND s0_.major_id = ? AND s0_.is_active = 1 ORDER BY s0_.position ASC SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.position AS position_2, s0_.is_active AS is_active_3, s0_.id_speciality_regional AS id_speciality_regional_4, s0_.created_date AS created_date_5, s0_.updated_date AS updated_date_6, s0_.program_level_id AS program_level_id_7, s0_.major_id AS major_id_8 FROM speciality s0_ WHERE s0_.id <> 299 AND s0_.major_id = 40 AND s0_.is_active = 1 ORDER BY s0_.position ASC;
30	0.26 ms	SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.position AS position_2, s0_.is_active AS is_active_3, s0_.id_speciality_regional AS id_speciality_regional_4, s0_.created_date AS created_date_5, s0_.updated_date AS updated_date_6, s0_.program_level_id AS program_level_id_7, s0_.major_id AS major_id_8 FROM speciality s0_ WHERE s0_.id <> ? AND s0_.major_id = ? AND s0_.is_active = 1 ORDER BY s0_.position ASC Parameters: [`299 39`] View formatted query View runnable query Explain query SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.position AS position_2, s0_.is_active AS is_active_3, s0_.id_speciality_regional AS id_speciality_regional_4, s0_.created_date AS created_date_5, s0_.updated_date AS updated_date_6, s0_.program_level_id AS program_level_id_7, s0_.major_id AS major_id_8 FROM speciality s0_ WHERE s0_.id <> ? AND s0_.major_id = ? AND s0_.is_active = 1 ORDER BY s0_.position ASC SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.position AS position_2, s0_.is_active AS is_active_3, s0_.id_speciality_regional AS id_speciality_regional_4, s0_.created_date AS created_date_5, s0_.updated_date AS updated_date_6, s0_.program_level_id AS program_level_id_7, s0_.major_id AS major_id_8 FROM speciality s0_ WHERE s0_.id <> 299 AND s0_.major_id = 39 AND s0_.is_active = 1 ORDER BY s0_.position ASC;

Database Connections

Name	Service
default	doctrine.dbal.default_connection
megabase	doctrine.dbal.megabase_connection

Entity Managers

Name	Service
default	doctrine.orm.default_entity_manager
megabase	doctrine.orm.megabase_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

default entity manager

Class	Mapping errors
App\Entity\Major	No errors.
App\Entity\ProgramLevel	No errors.
App\Entity\Speciality	No errors.
App\Entity\Program	No errors.
App\Entity\ProgramRegion	The mappings App\Entity\ProgramRegion#Specialities and App\Entity\Speciality#programRegions are inconsistent with each other. If association App\Entity\ProgramRegion#Specialities is many-to-many, then the inversed side App\Entity\Speciality#programRegions has to be many-to-many as well.

megabase entity manager

No loaded entities.

Symfony Profiler

GET https://staging.classements.france.eduniversal.com/login

Configuration Settings

Theme

Page Width

Query Metrics

Queries

default connection

Database Connections

Entity Managers

Second Level Cache

Entities Mapping

default entity manager

megabase entity manager