Query Metrics
114
Database Queries
15
Different statements
287.12 ms
Query time
7
Invalid entities
234
Managed entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 6.91 ms |
SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.slug AS slug_2, c0_.status AS status_3, c0_.ordering AS ordering_4, c0_.city AS city_5, c0_.youtube_url AS youtube_url_6, c0_.link360 AS link360_7, c0_.address AS address_8, c0_.cp AS cp_9, c0_.description AS description_10, c0_.is_main AS is_main_11, c0_.google_map AS google_map_12, c0_.created_date AS created_date_13, c0_.updated_date AS updated_date_14, c0_.seo_title AS seo_title_15, c0_.seo_h1 AS seo_h1_16, c0_.seo_keyword AS seo_keyword_17, c0_.seo_description AS seo_description_18 FROM campus c0_ LEFT JOIN program_campus p2_ ON c0_.id = p2_.campus_id LEFT JOIN program p1_ ON p1_.id = p2_.program_id WHERE p1_.status = 1 AND p1_.is_register = 1 ORDER BY c0_.id ASC) dctrn_result) dctrn_table
Parameters:
[] |
| 2 | 2.22 ms |
SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0 FROM (SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.slug AS slug_2, c0_.status AS status_3, c0_.ordering AS ordering_4, c0_.city AS city_5, c0_.youtube_url AS youtube_url_6, c0_.link360 AS link360_7, c0_.address AS address_8, c0_.cp AS cp_9, c0_.description AS description_10, c0_.is_main AS is_main_11, c0_.google_map AS google_map_12, c0_.created_date AS created_date_13, c0_.updated_date AS updated_date_14, c0_.seo_title AS seo_title_15, c0_.seo_h1 AS seo_h1_16, c0_.seo_keyword AS seo_keyword_17, c0_.seo_description AS seo_description_18, p1_.id AS id_19, p1_.name AS name_20, p1_.slug AS slug_21, p1_.status AS status_22, p1_.pace AS pace_23, p1_.rncp AS rncp_24, p1_.metadata AS metadata_25, p1_.description AS description_26, p1_.entreprise AS entreprise_27, p1_.speciality_id AS speciality_id_28, p1_.ordering AS ordering_29, p1_.is_register AS is_register_30, p1_.is_initial AS is_initial_31, p1_.is_alternance AS is_alternance_32, p1_.year AS year_33, p1_.rncp_level AS rncp_level_34, p1_.qcm_list AS qcm_list_35, p1_.entrance_fee AS entrance_fee_36, p1_.total_payment AS total_payment_37, p1_.old_slug AS old_slug_38, p1_.is_opening AS is_opening_39, p1_.is_international AS is_international_40, p1_.subtitle AS subtitle_41, p1_.link_out_side AS link_out_side_42, p1_.admin_program AS admin_program_43, p1_.widget AS widget_44, p1_.ranking AS ranking_45, p1_.information AS information_46, p1_.type AS type_47, p1_.overview_images AS overview_images_48, p1_.currency AS currency_49, p1_.created_date AS created_date_50, p1_.updated_date AS updated_date_51, p1_.seo_title AS seo_title_52, p1_.seo_h1 AS seo_h1_53, p1_.seo_keyword AS seo_keyword_54, p1_.seo_description AS seo_description_55 FROM campus c0_ LEFT JOIN program_campus p2_ ON c0_.id = p2_.campus_id LEFT JOIN program p1_ ON p1_.id = p2_.program_id WHERE p1_.status = 1 AND p1_.is_register = 1) dctrn_result_inner ORDER BY id_0 ASC) dctrn_result LIMIT 50
Parameters:
[] |
| 3 | 6.02 ms |
SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.slug AS slug_2, c0_.status AS status_3, c0_.ordering AS ordering_4, c0_.city AS city_5, c0_.youtube_url AS youtube_url_6, c0_.link360 AS link360_7, c0_.address AS address_8, c0_.cp AS cp_9, c0_.description AS description_10, c0_.is_main AS is_main_11, c0_.google_map AS google_map_12, c0_.created_date AS created_date_13, c0_.updated_date AS updated_date_14, c0_.seo_title AS seo_title_15, c0_.seo_h1 AS seo_h1_16, c0_.seo_keyword AS seo_keyword_17, c0_.seo_description AS seo_description_18, c0_.logo_id AS logo_id_19, c0_.country_id AS country_id_20 FROM campus c0_ LEFT JOIN program_campus p2_ ON c0_.id = p2_.campus_id LEFT JOIN program p1_ ON p1_.id = p2_.program_id WHERE p1_.status = 1 AND p1_.is_register = 1 AND c0_.id IN (?, ?, ?, ?) ORDER BY c0_.id ASC
Parameters:
[ 1 2 3 4 ] |
| 4 | 6.07 ms |
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
Parameters:
[ "1" "en" "App\Entity\Campus" ] |
| 5 | 3.27 ms |
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
Parameters:
[ "2" "en" "App\Entity\Campus" ] |
| 6 | 1.64 ms |
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
Parameters:
[ "3" "en" "App\Entity\Campus" ] |
| 7 | 0.55 ms |
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
Parameters:
[ "4" "en" "App\Entity\Campus" ] |
| 8 | 4.23 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.path AS path_3, t0.campus_id AS campus_id_4 FROM campus_image t0 WHERE t0.campus_id = ?
Parameters:
[
1
]
|
| 9 | 6.16 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.status AS status_4, t0.pace AS pace_5, t0.rncp AS rncp_6, t0.metadata AS metadata_7, t0.description AS description_8, t0.entreprise AS entreprise_9, t0.speciality_id AS speciality_id_10, t0.ordering AS ordering_11, t0.is_register AS is_register_12, t0.is_initial AS is_initial_13, t0.is_alternance AS is_alternance_14, t0.year AS year_15, t0.rncp_level AS rncp_level_16, t0.qcm_list AS qcm_list_17, t0.entrance_fee AS entrance_fee_18, t0.total_payment AS total_payment_19, t0.old_slug AS old_slug_20, t0.is_opening AS is_opening_21, t0.is_international AS is_international_22, t0.subtitle AS subtitle_23, t0.link_out_side AS link_out_side_24, t0.admin_program AS admin_program_25, t0.widget AS widget_26, t0.ranking AS ranking_27, t0.information AS information_28, t0.type AS type_29, t0.overview_images AS overview_images_30, t0.currency AS currency_31, t0.created_date AS created_date_32, t0.updated_date AS updated_date_33, t0.seo_title AS seo_title_34, t0.seo_h1 AS seo_h1_35, t0.seo_keyword AS seo_keyword_36, t0.seo_description AS seo_description_37, t0.brochure_id AS brochure_id_38, t0.media_id AS media_id_39, t0.director_image_id AS director_image_id_40, t0.review_image_id AS review_image_id_41, t0.intervenant_image_id AS intervenant_image_id_42, t0.prerequisites_image_id AS prerequisites_image_id_43, t0.cost_training_image_id AS cost_training_image_id_44, t0.outcomes_image_id AS outcomes_image_id_45, t0.level_id AS level_id_46, t0.domain_id AS domain_id_47, t0.alumni_interview_poster_id AS alumni_interview_poster_id_48, t0.plus_formation_file_id AS plus_formation_file_id_49 FROM program t0 INNER JOIN program_campus ON t0.id = program_campus.program_id WHERE program_campus.campus_id = ?
Parameters:
[
1
]
|
| 10 | 3.59 ms |
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
Parameters:
[ "1" "en" "App\Entity\Program" ] |
| 11 | 3.59 ms |
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
Parameters:
[ "2" "en" "App\Entity\Program" ] |
| 12 | 0.72 ms |
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
Parameters:
[ "3" "en" "App\Entity\Program" ] |
| 13 | 3.49 ms |
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
Parameters:
[ "4" "en" "App\Entity\Program" ] |
| 14 | 0.64 ms |
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
Parameters:
[ "5" "en" "App\Entity\Program" ] |
| 15 | 2.72 ms |
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
Parameters:
[ "6" "en" "App\Entity\Program" ] |
| 16 | 0.52 ms |
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
Parameters:
[ "7" "en" "App\Entity\Program" ] |
| 17 | 4.43 ms |
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
Parameters:
[ "8" "en" "App\Entity\Program" ] |
| 18 | 0.68 ms |
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
Parameters:
[ "9" "en" "App\Entity\Program" ] |
| 19 | 0.43 ms |
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
Parameters:
[ "10" "en" "App\Entity\Program" ] |
| 20 | 0.37 ms |
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
Parameters:
[ "14" "en" "App\Entity\Program" ] |
| 21 | 2.26 ms |
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
Parameters:
[ "15" "en" "App\Entity\Program" ] |
| 22 | 3.84 ms |
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
Parameters:
[ "17" "en" "App\Entity\Program" ] |
| 23 | 0.54 ms |
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
Parameters:
[ "20" "en" "App\Entity\Program" ] |
| 24 | 0.40 ms |
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
Parameters:
[ "21" "en" "App\Entity\Program" ] |
| 25 | 3.04 ms |
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
Parameters:
[ "23" "en" "App\Entity\Program" ] |
| 26 | 2.50 ms |
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
Parameters:
[ "27" "en" "App\Entity\Program" ] |
| 27 | 1.62 ms |
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
Parameters:
[ "34" "en" "App\Entity\Program" ] |
| 28 | 0.50 ms |
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
Parameters:
[ "37" "en" "App\Entity\Program" ] |
| 29 | 3.91 ms |
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
Parameters:
[ "45" "en" "App\Entity\Program" ] |
| 30 | 0.80 ms |
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
Parameters:
[ "47" "en" "App\Entity\Program" ] |
| 31 | 0.37 ms |
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
Parameters:
[ "48" "en" "App\Entity\Program" ] |
| 32 | 0.35 ms |
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
Parameters:
[ "55" "en" "App\Entity\Program" ] |
| 33 | 2.60 ms |
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
Parameters:
[ "56" "en" "App\Entity\Program" ] |
| 34 | 0.44 ms |
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
Parameters:
[ "59" "en" "App\Entity\Program" ] |
| 35 | 0.34 ms |
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
Parameters:
[ "64" "en" "App\Entity\Program" ] |
| 36 | 2.66 ms |
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
Parameters:
[ "65" "en" "App\Entity\Program" ] |
| 37 | 0.50 ms |
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
Parameters:
[ "69" "en" "App\Entity\Program" ] |
| 38 | 0.34 ms |
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
Parameters:
[ "77" "en" "App\Entity\Program" ] |
| 39 | 3.53 ms |
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
Parameters:
[ "79" "en" "App\Entity\Program" ] |
| 40 | 2.15 ms |
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
Parameters:
[ "80" "en" "App\Entity\Program" ] |
| 41 | 3.66 ms |
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
Parameters:
[ "81" "en" "App\Entity\Program" ] |
| 42 | 0.61 ms |
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
Parameters:
[ "83" "en" "App\Entity\Program" ] |
| 43 | 0.37 ms |
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
Parameters:
[ "86" "en" "App\Entity\Program" ] |
| 44 | 0.35 ms |
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
Parameters:
[ "92" "en" "App\Entity\Program" ] |
| 45 | 3.04 ms |
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
Parameters:
[ "93" "en" "App\Entity\Program" ] |
| 46 | 1.80 ms |
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
Parameters:
[ "95" "en" "App\Entity\Program" ] |
| 47 | 0.47 ms |
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
Parameters:
[ "102" "en" "App\Entity\Program" ] |
| 48 | 0.42 ms |
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
Parameters:
[ "150" "en" "App\Entity\Program" ] |
| 49 | 1.51 ms |
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
Parameters:
[ "151" "en" "App\Entity\Program" ] |
| 50 | 2.62 ms |
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
Parameters:
[ "152" "en" "App\Entity\Program" ] |
| 51 | 0.57 ms |
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
Parameters:
[ "153" "en" "App\Entity\Program" ] |
| 52 | 3.86 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.created_date AS created_date_4, t0.updated_date AS updated_date_5, t0.group_id AS group_id_6 FROM program_level t0 WHERE t0.id = ?
Parameters:
[
4
]
|
| 53 | 3.71 ms |
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
Parameters:
[ "4" "en" "App\Entity\ProgramLevel" ] |
| 54 | 0.81 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.created_date AS created_date_4, t0.updated_date AS updated_date_5, t0.group_id AS group_id_6 FROM program_level t0 WHERE t0.id = ?
Parameters:
[
5
]
|
| 55 | 3.61 ms |
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
Parameters:
[ "5" "en" "App\Entity\ProgramLevel" ] |
| 56 | 0.44 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.created_date AS created_date_4, t0.updated_date AS updated_date_5, t0.group_id AS group_id_6 FROM program_level t0 WHERE t0.id = ?
Parameters:
[
6
]
|
| 57 | 1.29 ms |
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
Parameters:
[ "6" "en" "App\Entity\ProgramLevel" ] |
| 58 | 3.56 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.created_date AS created_date_4, t0.updated_date AS updated_date_5, t0.group_id AS group_id_6 FROM program_level t0 WHERE t0.id = ?
Parameters:
[
2
]
|
| 59 | 0.50 ms |
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
Parameters:
[ "2" "en" "App\Entity\ProgramLevel" ] |
| 60 | 0.27 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.created_date AS created_date_4, t0.updated_date AS updated_date_5, t0.group_id AS group_id_6 FROM program_level t0 WHERE t0.id = ?
Parameters:
[
7
]
|
| 61 | 0.36 ms |
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
Parameters:
[ "7" "en" "App\Entity\ProgramLevel" ] |
| 62 | 0.27 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.created_date AS created_date_4, t0.updated_date AS updated_date_5, t0.group_id AS group_id_6 FROM program_level t0 WHERE t0.id = ?
Parameters:
[
3
]
|
| 63 | 0.34 ms |
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
Parameters:
[ "3" "en" "App\Entity\ProgramLevel" ] |
| 64 | 3.02 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.created_date AS created_date_4, t0.updated_date AS updated_date_5, t0.group_id AS group_id_6 FROM program_level t0 WHERE t0.id = ?
Parameters:
[
1
]
|
| 65 | 0.61 ms |
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
Parameters:
[ "1" "en" "App\Entity\ProgramLevel" ] |
| 66 | 6.17 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.service AS service_3, t0.position AS position_4, t0.email AS email_5, t0.telephone AS telephone_6, t0.title AS title_7, t0.image_id AS image_id_8 FROM manager t0 INNER JOIN campus_manager ON t0.id = campus_manager.manager_id WHERE campus_manager.campus_id = ?
Parameters:
[
1
]
|
| 67 | 0.62 ms |
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
Parameters:
[ "49" "en" "App\Entity\Manager" ] |
| 68 | 3.70 ms |
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
Parameters:
[ "50" "en" "App\Entity\Manager" ] |
| 69 | 1.70 ms |
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
Parameters:
[ "51" "en" "App\Entity\Manager" ] |
| 70 | 0.71 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.type AS type_3, t0.path AS path_4, t0.size AS size_5, t0.has_webp AS has_webp_6, t0.has_webm AS has_webm_7, t0.has_thumb AS has_thumb_8 FROM media t0 WHERE t0.id = ?
Parameters:
[
1114
]
|
| 71 | 7.75 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.status AS status_4, t0.ordering AS ordering_5, t0.city AS city_6, t0.youtube_url AS youtube_url_7, t0.link360 AS link360_8, t0.address AS address_9, t0.cp AS cp_10, t0.description AS description_11, t0.is_main AS is_main_12, t0.google_map AS google_map_13, t0.created_date AS created_date_14, t0.updated_date AS updated_date_15, t0.seo_title AS seo_title_16, t0.seo_h1 AS seo_h1_17, t0.seo_keyword AS seo_keyword_18, t0.seo_description AS seo_description_19, t0.logo_id AS logo_id_20, t0.country_id AS country_id_21 FROM campus t0 INNER JOIN manager_campus ON t0.id = manager_campus.campus_id WHERE manager_campus.manager_id = ?
Parameters:
[
49
]
|
| 72 | 3.89 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.type AS type_3, t0.path AS path_4, t0.size AS size_5, t0.has_webp AS has_webp_6, t0.has_webm AS has_webm_7, t0.has_thumb AS has_thumb_8 FROM media t0 WHERE t0.id = ?
Parameters:
[
1113
]
|
| 73 | 6.55 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.status AS status_4, t0.ordering AS ordering_5, t0.city AS city_6, t0.youtube_url AS youtube_url_7, t0.link360 AS link360_8, t0.address AS address_9, t0.cp AS cp_10, t0.description AS description_11, t0.is_main AS is_main_12, t0.google_map AS google_map_13, t0.created_date AS created_date_14, t0.updated_date AS updated_date_15, t0.seo_title AS seo_title_16, t0.seo_h1 AS seo_h1_17, t0.seo_keyword AS seo_keyword_18, t0.seo_description AS seo_description_19, t0.logo_id AS logo_id_20, t0.country_id AS country_id_21 FROM campus t0 INNER JOIN manager_campus ON t0.id = manager_campus.campus_id WHERE manager_campus.manager_id = ?
Parameters:
[
50
]
|
| 74 | 0.72 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.type AS type_3, t0.path AS path_4, t0.size AS size_5, t0.has_webp AS has_webp_6, t0.has_webm AS has_webm_7, t0.has_thumb AS has_thumb_8 FROM media t0 WHERE t0.id = ?
Parameters:
[
1119
]
|
| 75 | 5.43 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.status AS status_4, t0.ordering AS ordering_5, t0.city AS city_6, t0.youtube_url AS youtube_url_7, t0.link360 AS link360_8, t0.address AS address_9, t0.cp AS cp_10, t0.description AS description_11, t0.is_main AS is_main_12, t0.google_map AS google_map_13, t0.created_date AS created_date_14, t0.updated_date AS updated_date_15, t0.seo_title AS seo_title_16, t0.seo_h1 AS seo_h1_17, t0.seo_keyword AS seo_keyword_18, t0.seo_description AS seo_description_19, t0.logo_id AS logo_id_20, t0.country_id AS country_id_21 FROM campus t0 INNER JOIN manager_campus ON t0.id = manager_campus.campus_id WHERE manager_campus.manager_id = ?
Parameters:
[
51
]
|
| 76 | 5.98 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.ordering AS ordering_4, t0.nationality AS nationality_5, t0.language AS language_6, t0.zone_id AS zone_id_7 FROM country t0 WHERE t0.id = ?
Parameters:
[
1
]
|
| 77 | 6.15 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.path AS path_3, t0.campus_id AS campus_id_4 FROM campus_image t0 WHERE t0.campus_id = ?
Parameters:
[
2
]
|
| 78 | 4.03 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.status AS status_4, t0.pace AS pace_5, t0.rncp AS rncp_6, t0.metadata AS metadata_7, t0.description AS description_8, t0.entreprise AS entreprise_9, t0.speciality_id AS speciality_id_10, t0.ordering AS ordering_11, t0.is_register AS is_register_12, t0.is_initial AS is_initial_13, t0.is_alternance AS is_alternance_14, t0.year AS year_15, t0.rncp_level AS rncp_level_16, t0.qcm_list AS qcm_list_17, t0.entrance_fee AS entrance_fee_18, t0.total_payment AS total_payment_19, t0.old_slug AS old_slug_20, t0.is_opening AS is_opening_21, t0.is_international AS is_international_22, t0.subtitle AS subtitle_23, t0.link_out_side AS link_out_side_24, t0.admin_program AS admin_program_25, t0.widget AS widget_26, t0.ranking AS ranking_27, t0.information AS information_28, t0.type AS type_29, t0.overview_images AS overview_images_30, t0.currency AS currency_31, t0.created_date AS created_date_32, t0.updated_date AS updated_date_33, t0.seo_title AS seo_title_34, t0.seo_h1 AS seo_h1_35, t0.seo_keyword AS seo_keyword_36, t0.seo_description AS seo_description_37, t0.brochure_id AS brochure_id_38, t0.media_id AS media_id_39, t0.director_image_id AS director_image_id_40, t0.review_image_id AS review_image_id_41, t0.intervenant_image_id AS intervenant_image_id_42, t0.prerequisites_image_id AS prerequisites_image_id_43, t0.cost_training_image_id AS cost_training_image_id_44, t0.outcomes_image_id AS outcomes_image_id_45, t0.level_id AS level_id_46, t0.domain_id AS domain_id_47, t0.alumni_interview_poster_id AS alumni_interview_poster_id_48, t0.plus_formation_file_id AS plus_formation_file_id_49 FROM program t0 INNER JOIN program_campus ON t0.id = program_campus.program_id WHERE program_campus.campus_id = ?
Parameters:
[
2
]
|
| 79 | 2.46 ms |
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
Parameters:
[ "39" "en" "App\Entity\Program" ] |
| 80 | 0.50 ms |
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
Parameters:
[ "40" "en" "App\Entity\Program" ] |
| 81 | 4.25 ms |
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
Parameters:
[ "43" "en" "App\Entity\Program" ] |
| 82 | 2.02 ms |
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
Parameters:
[ "44" "en" "App\Entity\Program" ] |
| 83 | 2.40 ms |
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
Parameters:
[ "49" "en" "App\Entity\Program" ] |
| 84 | 2.18 ms |
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
Parameters:
[ "60" "en" "App\Entity\Program" ] |
| 85 | 3.62 ms |
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
Parameters:
[ "90" "en" "App\Entity\Program" ] |
| 86 | 1.74 ms |
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
Parameters:
[ "104" "en" "App\Entity\Program" ] |
| 87 | 1.02 ms |
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
Parameters:
[ "154" "en" "App\Entity\Program" ] |
| 88 | 2.66 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.service AS service_3, t0.position AS position_4, t0.email AS email_5, t0.telephone AS telephone_6, t0.title AS title_7, t0.image_id AS image_id_8 FROM manager t0 INNER JOIN campus_manager ON t0.id = campus_manager.manager_id WHERE campus_manager.campus_id = ?
Parameters:
[
2
]
|
| 89 | 4.22 ms |
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
Parameters:
[ "48" "en" "App\Entity\Manager" ] |
| 90 | 0.48 ms |
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
Parameters:
[ "65" "en" "App\Entity\Manager" ] |
| 91 | 0.90 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.type AS type_3, t0.path AS path_4, t0.size AS size_5, t0.has_webp AS has_webp_6, t0.has_webm AS has_webm_7, t0.has_thumb AS has_thumb_8 FROM media t0 WHERE t0.id = ?
Parameters:
[
1106
]
|
| 92 | 5.25 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.status AS status_4, t0.ordering AS ordering_5, t0.city AS city_6, t0.youtube_url AS youtube_url_7, t0.link360 AS link360_8, t0.address AS address_9, t0.cp AS cp_10, t0.description AS description_11, t0.is_main AS is_main_12, t0.google_map AS google_map_13, t0.created_date AS created_date_14, t0.updated_date AS updated_date_15, t0.seo_title AS seo_title_16, t0.seo_h1 AS seo_h1_17, t0.seo_keyword AS seo_keyword_18, t0.seo_description AS seo_description_19, t0.logo_id AS logo_id_20, t0.country_id AS country_id_21 FROM campus t0 INNER JOIN manager_campus ON t0.id = manager_campus.campus_id WHERE manager_campus.manager_id = ?
Parameters:
[
48
]
|
| 93 | 2.78 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.status AS status_4, t0.ordering AS ordering_5, t0.city AS city_6, t0.youtube_url AS youtube_url_7, t0.link360 AS link360_8, t0.address AS address_9, t0.cp AS cp_10, t0.description AS description_11, t0.is_main AS is_main_12, t0.google_map AS google_map_13, t0.created_date AS created_date_14, t0.updated_date AS updated_date_15, t0.seo_title AS seo_title_16, t0.seo_h1 AS seo_h1_17, t0.seo_keyword AS seo_keyword_18, t0.seo_description AS seo_description_19, t0.logo_id AS logo_id_20, t0.country_id AS country_id_21 FROM campus t0 INNER JOIN manager_campus ON t0.id = manager_campus.campus_id WHERE manager_campus.manager_id = ?
Parameters:
[
65
]
|
| 94 | 1.54 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.path AS path_3, t0.campus_id AS campus_id_4 FROM campus_image t0 WHERE t0.campus_id = ?
Parameters:
[
3
]
|
| 95 | 2.04 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.status AS status_4, t0.pace AS pace_5, t0.rncp AS rncp_6, t0.metadata AS metadata_7, t0.description AS description_8, t0.entreprise AS entreprise_9, t0.speciality_id AS speciality_id_10, t0.ordering AS ordering_11, t0.is_register AS is_register_12, t0.is_initial AS is_initial_13, t0.is_alternance AS is_alternance_14, t0.year AS year_15, t0.rncp_level AS rncp_level_16, t0.qcm_list AS qcm_list_17, t0.entrance_fee AS entrance_fee_18, t0.total_payment AS total_payment_19, t0.old_slug AS old_slug_20, t0.is_opening AS is_opening_21, t0.is_international AS is_international_22, t0.subtitle AS subtitle_23, t0.link_out_side AS link_out_side_24, t0.admin_program AS admin_program_25, t0.widget AS widget_26, t0.ranking AS ranking_27, t0.information AS information_28, t0.type AS type_29, t0.overview_images AS overview_images_30, t0.currency AS currency_31, t0.created_date AS created_date_32, t0.updated_date AS updated_date_33, t0.seo_title AS seo_title_34, t0.seo_h1 AS seo_h1_35, t0.seo_keyword AS seo_keyword_36, t0.seo_description AS seo_description_37, t0.brochure_id AS brochure_id_38, t0.media_id AS media_id_39, t0.director_image_id AS director_image_id_40, t0.review_image_id AS review_image_id_41, t0.intervenant_image_id AS intervenant_image_id_42, t0.prerequisites_image_id AS prerequisites_image_id_43, t0.cost_training_image_id AS cost_training_image_id_44, t0.outcomes_image_id AS outcomes_image_id_45, t0.level_id AS level_id_46, t0.domain_id AS domain_id_47, t0.alumni_interview_poster_id AS alumni_interview_poster_id_48, t0.plus_formation_file_id AS plus_formation_file_id_49 FROM program t0 INNER JOIN program_campus ON t0.id = program_campus.program_id WHERE program_campus.campus_id = ?
Parameters:
[
3
]
|
| 96 | 4.45 ms |
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
Parameters:
[ "100" "en" "App\Entity\Program" ] |
| 97 | 1.17 ms |
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
Parameters:
[ "148" "en" "App\Entity\Program" ] |
| 98 | 5.20 ms |
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
Parameters:
[ "149" "en" "App\Entity\Program" ] |
| 99 | 1.87 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.service AS service_3, t0.position AS position_4, t0.email AS email_5, t0.telephone AS telephone_6, t0.title AS title_7, t0.image_id AS image_id_8 FROM manager t0 INNER JOIN campus_manager ON t0.id = campus_manager.manager_id WHERE campus_manager.campus_id = ?
Parameters:
[
3
]
|
| 100 | 2.38 ms |
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
Parameters:
[ "69" "en" "App\Entity\Manager" ] |
| 101 | 1.64 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.status AS status_4, t0.ordering AS ordering_5, t0.city AS city_6, t0.youtube_url AS youtube_url_7, t0.link360 AS link360_8, t0.address AS address_9, t0.cp AS cp_10, t0.description AS description_11, t0.is_main AS is_main_12, t0.google_map AS google_map_13, t0.created_date AS created_date_14, t0.updated_date AS updated_date_15, t0.seo_title AS seo_title_16, t0.seo_h1 AS seo_h1_17, t0.seo_keyword AS seo_keyword_18, t0.seo_description AS seo_description_19, t0.logo_id AS logo_id_20, t0.country_id AS country_id_21 FROM campus t0 INNER JOIN manager_campus ON t0.id = manager_campus.campus_id WHERE manager_campus.manager_id = ?
Parameters:
[
69
]
|
| 102 | 0.42 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.path AS path_3, t0.campus_id AS campus_id_4 FROM campus_image t0 WHERE t0.campus_id = ?
Parameters:
[
4
]
|
| 103 | 0.61 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.status AS status_4, t0.pace AS pace_5, t0.rncp AS rncp_6, t0.metadata AS metadata_7, t0.description AS description_8, t0.entreprise AS entreprise_9, t0.speciality_id AS speciality_id_10, t0.ordering AS ordering_11, t0.is_register AS is_register_12, t0.is_initial AS is_initial_13, t0.is_alternance AS is_alternance_14, t0.year AS year_15, t0.rncp_level AS rncp_level_16, t0.qcm_list AS qcm_list_17, t0.entrance_fee AS entrance_fee_18, t0.total_payment AS total_payment_19, t0.old_slug AS old_slug_20, t0.is_opening AS is_opening_21, t0.is_international AS is_international_22, t0.subtitle AS subtitle_23, t0.link_out_side AS link_out_side_24, t0.admin_program AS admin_program_25, t0.widget AS widget_26, t0.ranking AS ranking_27, t0.information AS information_28, t0.type AS type_29, t0.overview_images AS overview_images_30, t0.currency AS currency_31, t0.created_date AS created_date_32, t0.updated_date AS updated_date_33, t0.seo_title AS seo_title_34, t0.seo_h1 AS seo_h1_35, t0.seo_keyword AS seo_keyword_36, t0.seo_description AS seo_description_37, t0.brochure_id AS brochure_id_38, t0.media_id AS media_id_39, t0.director_image_id AS director_image_id_40, t0.review_image_id AS review_image_id_41, t0.intervenant_image_id AS intervenant_image_id_42, t0.prerequisites_image_id AS prerequisites_image_id_43, t0.cost_training_image_id AS cost_training_image_id_44, t0.outcomes_image_id AS outcomes_image_id_45, t0.level_id AS level_id_46, t0.domain_id AS domain_id_47, t0.alumni_interview_poster_id AS alumni_interview_poster_id_48, t0.plus_formation_file_id AS plus_formation_file_id_49 FROM program t0 INNER JOIN program_campus ON t0.id = program_campus.program_id WHERE program_campus.campus_id = ?
Parameters:
[
4
]
|
| 104 | 2.47 ms |
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
Parameters:
[ "88" "en" "App\Entity\Program" ] |
| 105 | 0.92 ms |
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
Parameters:
[ "101" "en" "App\Entity\Program" ] |
| 106 | 0.92 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.service AS service_3, t0.position AS position_4, t0.email AS email_5, t0.telephone AS telephone_6, t0.title AS title_7, t0.image_id AS image_id_8 FROM manager t0 INNER JOIN campus_manager ON t0.id = campus_manager.manager_id WHERE campus_manager.campus_id = ?
Parameters:
[
4
]
|
| 107 | 3.76 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.ordering AS ordering_4, t0.nationality AS nationality_5, t0.language AS language_6, t0.zone_id AS zone_id_7 FROM country t0 WHERE t0.id = ?
Parameters:
[
96
]
|
| 108 | 19.64 ms |
SELECT p0_.id AS id_0, COALESCE(t1_.content, p0_.name) AS name_1, p0_.slug AS slug_2 FROM program_level_group p0_ INNER JOIN program_level p2_ ON p0_.id = p2_.group_id INNER JOIN program p4_ ON p2_.id = p4_.level_id LEFT JOIN ext_translations t1_ ON t1_.locale = 'en' AND t1_.field = 'name' AND t1_.object_class = 'App\\Entity\\ProgramLevelGroup' AND t1_.foreign_key = p0_.id LEFT JOIN ext_translations t3_ ON t3_.locale = 'en' AND t3_.field = 'name' AND t3_.object_class = 'App\\Entity\\ProgramLevel' AND t3_.foreign_key = p2_.id LEFT JOIN ext_translations t5_ ON t5_.locale = 'en' AND t5_.field = 'name' AND t5_.object_class = 'App\\Entity\\Program' AND t5_.foreign_key = p4_.id LEFT JOIN ext_translations t6_ ON t6_.locale = 'en' AND t6_.field = 'metadata' AND t6_.object_class = 'App\\Entity\\Program' AND t6_.foreign_key = p4_.id LEFT JOIN ext_translations t7_ ON t7_.locale = 'en' AND t7_.field = 'description' AND t7_.object_class = 'App\\Entity\\Program' AND t7_.foreign_key = p4_.id LEFT JOIN ext_translations t8_ ON t8_.locale = 'en' AND t8_.field = 'entreprise' AND t8_.object_class = 'App\\Entity\\Program' AND t8_.foreign_key = p4_.id LEFT JOIN ext_translations t9_ ON t9_.locale = 'en' AND t9_.field = 'subtitle' AND t9_.object_class = 'App\\Entity\\Program' AND t9_.foreign_key = p4_.id WHERE p4_.status = 1 GROUP BY p0_.id ORDER BY p0_.id ASC
Parameters:
[] |
| 109 | 1.04 ms |
SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.slug AS slug_2, c0_.status AS status_3, c0_.ordering AS ordering_4, c0_.city AS city_5, c0_.youtube_url AS youtube_url_6, c0_.link360 AS link360_7, c0_.address AS address_8, c0_.cp AS cp_9, c0_.description AS description_10, c0_.is_main AS is_main_11, c0_.google_map AS google_map_12, c0_.created_date AS created_date_13, c0_.updated_date AS updated_date_14, c0_.seo_title AS seo_title_15, c0_.seo_h1 AS seo_h1_16, c0_.seo_keyword AS seo_keyword_17, c0_.seo_description AS seo_description_18 FROM campus c0_ LEFT JOIN manager_campus m2_ ON c0_.id = m2_.campus_id LEFT JOIN manager m1_ ON m1_.id = m2_.manager_id LEFT JOIN news_campus n4_ ON c0_.id = n4_.campus_id LEFT JOIN news n3_ ON n3_.id = n4_.news_id WHERE (c0_.description <> '' OR c0_.address <> '' OR c0_.link360 <> '' OR c0_.youtube_url <> '') AND c0_.id IN (?, ?, ?)) dctrn_result) dctrn_table
Parameters:
[ 1 2 4 ] |
| 110 | 2.70 ms |
SELECT DISTINCT id_0 FROM (SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.slug AS slug_2, c0_.status AS status_3, c0_.ordering AS ordering_4, c0_.city AS city_5, c0_.youtube_url AS youtube_url_6, c0_.link360 AS link360_7, c0_.address AS address_8, c0_.cp AS cp_9, c0_.description AS description_10, c0_.is_main AS is_main_11, c0_.google_map AS google_map_12, c0_.created_date AS created_date_13, c0_.updated_date AS updated_date_14, c0_.seo_title AS seo_title_15, c0_.seo_h1 AS seo_h1_16, c0_.seo_keyword AS seo_keyword_17, c0_.seo_description AS seo_description_18 FROM campus c0_ LEFT JOIN manager_campus m2_ ON c0_.id = m2_.campus_id LEFT JOIN manager m1_ ON m1_.id = m2_.manager_id LEFT JOIN news_campus n4_ ON c0_.id = n4_.campus_id LEFT JOIN news n3_ ON n3_.id = n4_.news_id WHERE (c0_.description <> '' OR c0_.address <> '' OR c0_.link360 <> '' OR c0_.youtube_url <> '') AND c0_.id IN (?, ?, ?)) dctrn_result LIMIT 50
Parameters:
[ 1 2 4 ] |
| 111 | 3.66 ms |
SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.slug AS slug_2, c0_.status AS status_3, c0_.ordering AS ordering_4, c0_.city AS city_5, c0_.youtube_url AS youtube_url_6, c0_.link360 AS link360_7, c0_.address AS address_8, c0_.cp AS cp_9, c0_.description AS description_10, c0_.is_main AS is_main_11, c0_.google_map AS google_map_12, c0_.created_date AS created_date_13, c0_.updated_date AS updated_date_14, c0_.seo_title AS seo_title_15, c0_.seo_h1 AS seo_h1_16, c0_.seo_keyword AS seo_keyword_17, c0_.seo_description AS seo_description_18, c0_.logo_id AS logo_id_19, c0_.country_id AS country_id_20 FROM campus c0_ LEFT JOIN manager_campus m2_ ON c0_.id = m2_.campus_id LEFT JOIN manager m1_ ON m1_.id = m2_.manager_id LEFT JOIN news_campus n4_ ON c0_.id = n4_.campus_id LEFT JOIN news n3_ ON n3_.id = n4_.news_id WHERE (c0_.description <> '' OR c0_.address <> '' OR c0_.link360 <> '' OR c0_.youtube_url <> '') AND c0_.id IN (?, ?, ?) AND c0_.id IN (?, ?, ?)
Parameters:
[ 1 2 4 1 2 4 ] |
| 112 | 5.34 ms |
SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.slug AS slug_2, c0_.status AS status_3, c0_.ordering AS ordering_4, c0_.city AS city_5, c0_.youtube_url AS youtube_url_6, c0_.link360 AS link360_7, c0_.address AS address_8, c0_.cp AS cp_9, c0_.description AS description_10, c0_.is_main AS is_main_11, c0_.google_map AS google_map_12, c0_.created_date AS created_date_13, c0_.updated_date AS updated_date_14, c0_.seo_title AS seo_title_15, c0_.seo_h1 AS seo_h1_16, c0_.seo_keyword AS seo_keyword_17, c0_.seo_description AS seo_description_18 FROM campus c0_ LEFT JOIN manager_campus m2_ ON c0_.id = m2_.campus_id LEFT JOIN manager m1_ ON m1_.id = m2_.manager_id LEFT JOIN news_campus n4_ ON c0_.id = n4_.campus_id LEFT JOIN news n3_ ON n3_.id = n4_.news_id WHERE (c0_.description <> '' OR c0_.address <> '' OR c0_.link360 <> '' OR c0_.youtube_url <> '') AND c0_.id IN (?, ?, ?)) dctrn_result) dctrn_table
Parameters:
[ 1 2 4 ] |
| 113 | 4.67 ms |
SELECT DISTINCT id_0 FROM (SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.slug AS slug_2, c0_.status AS status_3, c0_.ordering AS ordering_4, c0_.city AS city_5, c0_.youtube_url AS youtube_url_6, c0_.link360 AS link360_7, c0_.address AS address_8, c0_.cp AS cp_9, c0_.description AS description_10, c0_.is_main AS is_main_11, c0_.google_map AS google_map_12, c0_.created_date AS created_date_13, c0_.updated_date AS updated_date_14, c0_.seo_title AS seo_title_15, c0_.seo_h1 AS seo_h1_16, c0_.seo_keyword AS seo_keyword_17, c0_.seo_description AS seo_description_18 FROM campus c0_ LEFT JOIN manager_campus m2_ ON c0_.id = m2_.campus_id LEFT JOIN manager m1_ ON m1_.id = m2_.manager_id LEFT JOIN news_campus n4_ ON c0_.id = n4_.campus_id LEFT JOIN news n3_ ON n3_.id = n4_.news_id WHERE (c0_.description <> '' OR c0_.address <> '' OR c0_.link360 <> '' OR c0_.youtube_url <> '') AND c0_.id IN (?, ?, ?)) dctrn_result LIMIT 50
Parameters:
[ 1 2 4 ] |
| 114 | 1.74 ms |
SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.slug AS slug_2, c0_.status AS status_3, c0_.ordering AS ordering_4, c0_.city AS city_5, c0_.youtube_url AS youtube_url_6, c0_.link360 AS link360_7, c0_.address AS address_8, c0_.cp AS cp_9, c0_.description AS description_10, c0_.is_main AS is_main_11, c0_.google_map AS google_map_12, c0_.created_date AS created_date_13, c0_.updated_date AS updated_date_14, c0_.seo_title AS seo_title_15, c0_.seo_h1 AS seo_h1_16, c0_.seo_keyword AS seo_keyword_17, c0_.seo_description AS seo_description_18, c0_.logo_id AS logo_id_19, c0_.country_id AS country_id_20 FROM campus c0_ LEFT JOIN manager_campus m2_ ON c0_.id = m2_.campus_id LEFT JOIN manager m1_ ON m1_.id = m2_.manager_id LEFT JOIN news_campus n4_ ON c0_.id = n4_.campus_id LEFT JOIN news n3_ ON n3_.id = n4_.news_id WHERE (c0_.description <> '' OR c0_.address <> '' OR c0_.link360 <> '' OR c0_.youtube_url <> '') AND c0_.id IN (?, ?, ?) AND c0_.id IN (?, ?, ?)
Parameters:
[ 1 2 4 1 2 4 ] |
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.
Managed Entities
default entity manager
| Class | Amount of managed objects |
|---|---|
| App\Entity\Media | 146 |
| App\Entity\Program | 56 |
| App\Entity\ProgramLevel | 7 |
| App\Entity\Manager | 6 |
| App\Entity\ProgramDomain | 5 |
| App\Entity\Campus | 4 |
| App\Entity\ProgramLevelGroup | 4 |
| App\Entity\Country | 2 |
| App\Entity\CampusImage | 2 |
| App\Entity\Zone | 2 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\Campus | No errors. |
| App\Entity\Program | No errors. |
| App\Entity\Media | No errors. |
| App\Entity\Country | No errors. |
| App\Entity\Profile |
|
| App\Entity\News | No errors. |
| App\Entity\Manager | No errors. |
| App\Entity\SpoDate | No errors. |
| App\Entity\CampusImage | No errors. |
| App\Entity\AcademicPartner | No errors. |
| Gedmo\Translatable\Entity\MappedSuperclass\AbstractTranslation | No errors. |
| Gedmo\Translatable\Entity\Translation | No errors. |
| App\Entity\ProgramLevel | No errors. |
| App\Entity\ProgramDomain | No errors. |
| App\Entity\Qcm | No errors. |
| App\Entity\Cursus | No errors. |
| App\Entity\Spo | No errors. |
| App\Entity\ProgramLevelGroup | No errors. |
| App\Entity\Zone | No errors. |
| App\Entity\User |
|
| App\Entity\Partenaire | No errors. |
| App\Entity\StudyLevel | No errors. |
| App\Entity\EnglishLevel | No errors. |
| App\Entity\ProfileFile | No errors. |
| App\Entity\Jury | No errors. |
| App\Entity\Oraux | No errors. |
| App\Entity\Status | No errors. |
| App\Entity\Campaign |
|
| App\Entity\ProfileNote | No errors. |
| App\Entity\MediaChannel | No errors. |
| App\Entity\Landingpage | No errors. |
| App\Entity\ProfileQcm | No errors. |
| App\Entity\OpenDayPerson |
|
| App\Entity\Task | No errors. |
| App\Entity\Notification | No errors. |
| App\Entity\ProfileSource | No errors. |
| App\Entity\Site | No errors. |
| App\Entity\Source | No errors. |
| App\Entity\Payment | No errors. |
| App\Entity\Contract | No errors. |
| App\Entity\CvType | No errors. |
| App\Entity\ContractType | No errors. |
| App\Entity\WorkStudy | No errors. |
| App\Entity\AcademicImage | No errors. |
| App\Entity\QcmQuestion | No errors. |
| App\Entity\Role | No errors. |
| App\Entity\OpenDay |
|
| App\Entity\LandingpageFile | No errors. |
| App\Entity\SourceBudget | No errors. |
| App\Entity\Enterprise | No errors. |
| App\Entity\EnterpriseTutor | No errors. |
| App\Entity\EnterpriseStaff | No errors. |
| App\Entity\ProfileStep | No errors. |
| App\Entity\EnterpriseAddress | No errors. |
| App\Entity\Bill | No errors. |
| App\Entity\Opco |
|
| App\Entity\OpcoAddress |
|
| App\Entity\OpcoContact | No errors. |
| App\Entity\CandidateStatus | No errors. |
| App\Entity\Permission | No errors. |