| 1 |
1.84 ms |
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.ordering AS ordering_2, p0_.type_id AS type_id_3 FROM position p0_
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.ordering AS ordering_2, p0_.type_id AS type_id_3 FROM position p0_;
|
| 2 |
0.87 ms |
SELECT t0.id AS id_1, t0.name AS name_2 FROM position_type t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.name AS name_2 FROM position_type t0 WHERE t0.id = 1;
|
| 3 |
0.72 ms |
SELECT t0.id AS id_1, t0.name AS name_2 FROM position_type t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.name AS name_2 FROM position_type t0 WHERE t0.id = 2;
|
| 4 |
0.74 ms |
SELECT t0.id AS id_1, t0.name AS name_2 FROM position_type t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.name AS name_2 FROM position_type t0 WHERE t0.id = 3;
|
| 5 |
0.56 ms |
SELECT t0.id AS id_1, t0.name AS name_2 FROM position_type t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.name AS name_2 FROM position_type t0 WHERE t0.id = 4;
|
| 6 |
5.45 ms |
SELECT COUNT(c0_.id) AS sclr_0 FROM certificate c0_
SELECT COUNT(c0_.id) AS sclr_0 FROM certificate c0_;
|
| 7 |
0.91 ms |
SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.orange_period AS orange_period_2, c0_.red_period AS red_period_3 FROM certificate c0_ ORDER BY c0_.id ASC LIMIT 25
SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.orange_period AS orange_period_2, c0_.red_period AS red_period_3 FROM certificate c0_ ORDER BY c0_.id ASC LIMIT 25;
|
| 8 |
2.13 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.ordering AS ordering_3, t0.type_id AS type_id_4 FROM position t0 INNER JOIN certificate_position ON t0.id = certificate_position.position_id WHERE certificate_position.certificate_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.ordering AS ordering_3, t0.type_id AS type_id_4 FROM position t0 INNER JOIN certificate_position ON t0.id = certificate_position.position_id WHERE certificate_position.certificate_id = 1;
|
| 9 |
0.51 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.ordering AS ordering_3, t0.type_id AS type_id_4 FROM position t0 INNER JOIN certificate_position ON t0.id = certificate_position.position_id WHERE certificate_position.certificate_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.ordering AS ordering_3, t0.type_id AS type_id_4 FROM position t0 INNER JOIN certificate_position ON t0.id = certificate_position.position_id WHERE certificate_position.certificate_id = 2;
|
| 10 |
0.48 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.ordering AS ordering_3, t0.type_id AS type_id_4 FROM position t0 INNER JOIN certificate_position ON t0.id = certificate_position.position_id WHERE certificate_position.certificate_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.ordering AS ordering_3, t0.type_id AS type_id_4 FROM position t0 INNER JOIN certificate_position ON t0.id = certificate_position.position_id WHERE certificate_position.certificate_id = 3;
|
| 11 |
0.64 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.ordering AS ordering_3, t0.type_id AS type_id_4 FROM position t0 INNER JOIN certificate_position ON t0.id = certificate_position.position_id WHERE certificate_position.certificate_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.ordering AS ordering_3, t0.type_id AS type_id_4 FROM position t0 INNER JOIN certificate_position ON t0.id = certificate_position.position_id WHERE certificate_position.certificate_id = 4;
|
| 12 |
0.95 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.ordering AS ordering_3, t0.type_id AS type_id_4 FROM position t0 INNER JOIN certificate_position ON t0.id = certificate_position.position_id WHERE certificate_position.certificate_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.ordering AS ordering_3, t0.type_id AS type_id_4 FROM position t0 INNER JOIN certificate_position ON t0.id = certificate_position.position_id WHERE certificate_position.certificate_id = 5;
|
| 13 |
1.09 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.ordering AS ordering_3, t0.type_id AS type_id_4 FROM position t0 INNER JOIN certificate_position ON t0.id = certificate_position.position_id WHERE certificate_position.certificate_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.ordering AS ordering_3, t0.type_id AS type_id_4 FROM position t0 INNER JOIN certificate_position ON t0.id = certificate_position.position_id WHERE certificate_position.certificate_id = 6;
|
| 14 |
0.80 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.ordering AS ordering_3, t0.type_id AS type_id_4 FROM position t0 INNER JOIN certificate_position ON t0.id = certificate_position.position_id WHERE certificate_position.certificate_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.ordering AS ordering_3, t0.type_id AS type_id_4 FROM position t0 INNER JOIN certificate_position ON t0.id = certificate_position.position_id WHERE certificate_position.certificate_id = 7;
|
| 15 |
0.94 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.ordering AS ordering_3, t0.type_id AS type_id_4 FROM position t0 INNER JOIN certificate_position ON t0.id = certificate_position.position_id WHERE certificate_position.certificate_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.ordering AS ordering_3, t0.type_id AS type_id_4 FROM position t0 INNER JOIN certificate_position ON t0.id = certificate_position.position_id WHERE certificate_position.certificate_id = 8;
|
| 16 |
1.12 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.ordering AS ordering_3, t0.type_id AS type_id_4 FROM position t0 INNER JOIN certificate_position ON t0.id = certificate_position.position_id WHERE certificate_position.certificate_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.ordering AS ordering_3, t0.type_id AS type_id_4 FROM position t0 INNER JOIN certificate_position ON t0.id = certificate_position.position_id WHERE certificate_position.certificate_id = 9;
|
| 17 |
0.66 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.ordering AS ordering_3, t0.type_id AS type_id_4 FROM position t0 INNER JOIN certificate_position ON t0.id = certificate_position.position_id WHERE certificate_position.certificate_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.ordering AS ordering_3, t0.type_id AS type_id_4 FROM position t0 INNER JOIN certificate_position ON t0.id = certificate_position.position_id WHERE certificate_position.certificate_id = 10;
|
| 18 |
0.62 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.ordering AS ordering_3, t0.type_id AS type_id_4 FROM position t0 INNER JOIN certificate_position ON t0.id = certificate_position.position_id WHERE certificate_position.certificate_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.ordering AS ordering_3, t0.type_id AS type_id_4 FROM position t0 INNER JOIN certificate_position ON t0.id = certificate_position.position_id WHERE certificate_position.certificate_id = 11;
|