Query Metrics
16
Database Queries
8
Different statements
5.20 ms
Query time
5
Invalid entities
Queries
default connection
| #▲ | Time | Info |
|---|---|---|
| 1 | 0.76 ms |
SELECT o0_.id AS id_0, o0_.title AS title_1, o0_.min_tjm AS min_tjm_2, o0_.max_tjm AS max_tjm_3, o0_.open_society AS open_society_4, o0_.location AS location_5, o0_.description AS description_6, o0_.duration_value AS duration_value_7, o0_.duration_type AS duration_type_8, o0_.mode_remote AS mode_remote_9, o0_.year_required AS year_required_10, o0_.show_coordinate AS show_coordinate_11, o0_.edited_by_admin AS edited_by_admin_12, o0_.renew AS renew_13, o0_.invalid AS invalid_14, o0_.created_at AS created_at_15, o0_.expire_at AS expire_at_16, o0_.contact_civility AS contact_civility_17, o0_.contact_mail AS contact_mail_18, o0_.contact_phone AS contact_phone_19, o0_.starting_type AS starting_type_20, o0_.startin_date AS startin_date_21, o0_.contact_name AS contact_name_22, o0_.questions AS questions_23, o0_.view AS view_24, o0_.unseen_candidature AS unseen_candidature_25, o0_.ville AS ville_26, o0_.priorize AS priorize_27, o0_.weekly AS weekly_28, o0_.daily AS daily_29, o0_.date_remonter AS date_remonter_30, o0_.check_link_extern AS check_link_extern_31, o0_.link_extern AS link_extern_32, o0_.siren AS siren_33, o0_.share_on_social_network AS share_on_social_network_34, o0_.by_super_admin AS by_super_admin_35, o0_.slug AS slug_36, o0_.site_map_index AS site_map_index_37, o0_.cdi AS cdi_38, o0_.montant_min AS montant_min_39, o0_.reason_rejection AS reason_rejection_40, o0_.contrats AS contrats_41, o0_.montant_max AS montant_max_42, o0_.society_id AS society_id_43, o0_.user_id AS user_id_44, o0_.user_recruteur_id AS user_recruteur_id_45, o0_.user_by_admin_id AS user_by_admin_id_46 FROM offer o0_ ORDER BY o0_.id DESC LIMIT 10
Parameters:
[] |
| 2 | 0.41 ms |
SELECT p0_.id AS id_0, p0_.cost AS cost_1, p0_.cost_type AS cost_type_2, p0_.experience_number AS experience_number_3, p0_.profile_type AS profile_type_4, p0_.about AS about_5, p0_.photo AS photo_6, p0_.cv_file AS cv_file_7, p0_.location AS location_8, p0_.mobility AS mobility_9, p0_.disponibility AS disponibility_10, p0_.name AS name_11, p0_.linkedin AS linkedin_12, p0_.title AS title_13, p0_.is_intercontrat AS is_intercontrat_14, p0_.finished AS finished_15, p0_.firstname AS firstname_16, p0_.english_level AS english_level_17, p0_.legal_status AS legal_status_18, p0_.phone AS phone_19, p0_.url AS url_20, p0_.cvname AS cvname_21, p0_.is_visible AS is_visible_22, p0_.is_highlight AS is_highlight_23, p0_.cv_older_scan AS cv_older_scan_24, p0_.cv_text AS cv_text_25, p0_.slug AS slug_26, p0_.birthday AS birthday_27, p0_.cdi AS cdi_28, p0_.montant AS montant_29, p0_.contrats AS contrats_30, p0_.user_id AS user_id_31, p0_.user_recruteur_id AS user_recruteur_id_32 FROM profile p0_ WHERE p0_.is_intercontrat <> 1 AND p0_.profile_type <> ? AND p0_.finished <> 0 ORDER BY p0_.user_id DESC LIMIT 3
Parameters:
[
2
]
|
| 3 | 0.37 ms |
SELECT n0_.id AS id_0, n0_.owner AS owner_1, n0_.description AS description_2, n0_.link AS link_3, n0_.created_at AS created_at_4, n0_.news_link AS news_link_5, n0_.date AS date_6 FROM news n0_ ORDER BY n0_.date DESC LIMIT 15
Parameters:
[] |
| 4 | 0.29 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.breadcrumb AS breadcrumb_3, t0.slug AS slug_4, t0.keywords AS keywords_5, t0.description AS description_6, t0.rt_time AS rt_time_7, t0.view AS view_8, t0.content AS content_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.bigtitle AS bigtitle_12, t0.blogimage_id AS blogimage_id_13 FROM blog t0 ORDER BY t0.created_at DESC LIMIT 3
Parameters:
[] |
| 5 | 0.63 ms |
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.is_verified AS is_verified_5, t0.relance_profile AS relance_profile_6, t0.firstname AS firstname_7, t0.lastname AS lastname_8, t0.phone AS phone_9, t0.type AS type_10, t0.photo AS photo_11, t0.subscription_id AS subscription_id_12, t0.delete_at AS delete_at_13, t0.last_connection AS last_connection_14, t0.created_at AS created_at_15, t0.civility AS civility_16, t0.job_society AS job_society_17, t0.compte_test_is_not_active AS compte_test_is_not_active_18, t0.google_sub_id AS google_sub_id_19, t0.is_blocked AS is_blocked_20, t0.mail_relance AS mail_relance_21, t0.last_login_time AS last_login_time_22, t0.expo_push_tokens AS expo_push_tokens_23, t0.last_lougout_time AS last_lougout_time_24, t0.last_reminder_time AS last_reminder_time_25, t26.id AS id_27, t26.name AS name_28, t26.siren AS siren_29, t26.type AS type_30, t26.employe_number AS employe_number_31, t26.ca AS ca_32, t26.contact AS contact_33, t26.phone AS phone_34, t26.site AS site_35, t26.linkedin AS linkedin_36, t26.profile_view AS profile_view_37, t26.can_upload AS can_upload_38, t26.intercontrat_number AS intercontrat_number_39, t26.package AS package_40, t26.package_date AS package_date_41, t26.priorize_number AS priorize_number_42, t26.once_everyday AS once_everyday_43, t26.once_week AS once_week_44, t26.pause_date AS pause_date_45, t26.package_expire_at AS package_expire_at_46, t26.description AS description_47, t26.adress AS adress_48, t26.ville AS ville_49, t26.pause_number AS pause_number_50, t26.intercontrat_une AS intercontrat_une_51, t26.slug AS slug_52, t26.nb_mission AS nb_mission_53, t26.post_intercontrat AS post_intercontrat_54, t26.user_id AS user_id_55, t0.compte_society_id AS compte_society_id_56 FROM user t0 LEFT JOIN society t26 ON t26.user_id = t0.id WHERE t0.id = ?
Parameters:
[
1147
]
|
| 6 | 0.40 ms |
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.is_verified AS is_verified_5, t0.relance_profile AS relance_profile_6, t0.firstname AS firstname_7, t0.lastname AS lastname_8, t0.phone AS phone_9, t0.type AS type_10, t0.photo AS photo_11, t0.subscription_id AS subscription_id_12, t0.delete_at AS delete_at_13, t0.last_connection AS last_connection_14, t0.created_at AS created_at_15, t0.civility AS civility_16, t0.job_society AS job_society_17, t0.compte_test_is_not_active AS compte_test_is_not_active_18, t0.google_sub_id AS google_sub_id_19, t0.is_blocked AS is_blocked_20, t0.mail_relance AS mail_relance_21, t0.last_login_time AS last_login_time_22, t0.expo_push_tokens AS expo_push_tokens_23, t0.last_lougout_time AS last_lougout_time_24, t0.last_reminder_time AS last_reminder_time_25, t26.id AS id_27, t26.name AS name_28, t26.siren AS siren_29, t26.type AS type_30, t26.employe_number AS employe_number_31, t26.ca AS ca_32, t26.contact AS contact_33, t26.phone AS phone_34, t26.site AS site_35, t26.linkedin AS linkedin_36, t26.profile_view AS profile_view_37, t26.can_upload AS can_upload_38, t26.intercontrat_number AS intercontrat_number_39, t26.package AS package_40, t26.package_date AS package_date_41, t26.priorize_number AS priorize_number_42, t26.once_everyday AS once_everyday_43, t26.once_week AS once_week_44, t26.pause_date AS pause_date_45, t26.package_expire_at AS package_expire_at_46, t26.description AS description_47, t26.adress AS adress_48, t26.ville AS ville_49, t26.pause_number AS pause_number_50, t26.intercontrat_une AS intercontrat_une_51, t26.slug AS slug_52, t26.nb_mission AS nb_mission_53, t26.post_intercontrat AS post_intercontrat_54, t26.user_id AS user_id_55, t0.compte_society_id AS compte_society_id_56 FROM user t0 LEFT JOIN society t26 ON t26.user_id = t0.id WHERE t0.id = ?
Parameters:
[
1143
]
|
| 7 | 0.40 ms |
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.is_verified AS is_verified_5, t0.relance_profile AS relance_profile_6, t0.firstname AS firstname_7, t0.lastname AS lastname_8, t0.phone AS phone_9, t0.type AS type_10, t0.photo AS photo_11, t0.subscription_id AS subscription_id_12, t0.delete_at AS delete_at_13, t0.last_connection AS last_connection_14, t0.created_at AS created_at_15, t0.civility AS civility_16, t0.job_society AS job_society_17, t0.compte_test_is_not_active AS compte_test_is_not_active_18, t0.google_sub_id AS google_sub_id_19, t0.is_blocked AS is_blocked_20, t0.mail_relance AS mail_relance_21, t0.last_login_time AS last_login_time_22, t0.expo_push_tokens AS expo_push_tokens_23, t0.last_lougout_time AS last_lougout_time_24, t0.last_reminder_time AS last_reminder_time_25, t26.id AS id_27, t26.name AS name_28, t26.siren AS siren_29, t26.type AS type_30, t26.employe_number AS employe_number_31, t26.ca AS ca_32, t26.contact AS contact_33, t26.phone AS phone_34, t26.site AS site_35, t26.linkedin AS linkedin_36, t26.profile_view AS profile_view_37, t26.can_upload AS can_upload_38, t26.intercontrat_number AS intercontrat_number_39, t26.package AS package_40, t26.package_date AS package_date_41, t26.priorize_number AS priorize_number_42, t26.once_everyday AS once_everyday_43, t26.once_week AS once_week_44, t26.pause_date AS pause_date_45, t26.package_expire_at AS package_expire_at_46, t26.description AS description_47, t26.adress AS adress_48, t26.ville AS ville_49, t26.pause_number AS pause_number_50, t26.intercontrat_une AS intercontrat_une_51, t26.slug AS slug_52, t26.nb_mission AS nb_mission_53, t26.post_intercontrat AS post_intercontrat_54, t26.user_id AS user_id_55, t0.compte_society_id AS compte_society_id_56 FROM user t0 LEFT JOIN society t26 ON t26.user_id = t0.id WHERE t0.id = ?
Parameters:
[
1140
]
|
| 8 | 0.21 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.path AS path_3 FROM publication_image t0 WHERE t0.id = ?
Parameters:
[
83
]
|
| 9 | 0.25 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3 FROM sous_thematique t0 INNER JOIN blog_sous_thematique ON t0.id = blog_sous_thematique.sous_thematique_id WHERE blog_sous_thematique.blog_id = ?
Parameters:
[
89
]
|
| 10 | 0.24 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3 FROM thematique t0 INNER JOIN blog_thematique ON t0.id = blog_thematique.thematique_id WHERE blog_thematique.blog_id = ?
Parameters:
[
89
]
|
| 11 | 0.20 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.path AS path_3 FROM publication_image t0 WHERE t0.id = ?
Parameters:
[
82
]
|
| 12 | 0.23 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3 FROM sous_thematique t0 INNER JOIN blog_sous_thematique ON t0.id = blog_sous_thematique.sous_thematique_id WHERE blog_sous_thematique.blog_id = ?
Parameters:
[
88
]
|
| 13 | 0.20 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3 FROM thematique t0 INNER JOIN blog_thematique ON t0.id = blog_thematique.thematique_id WHERE blog_thematique.blog_id = ?
Parameters:
[
88
]
|
| 14 | 0.16 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.path AS path_3 FROM publication_image t0 WHERE t0.id = ?
Parameters:
[
81
]
|
| 15 | 0.22 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3 FROM sous_thematique t0 INNER JOIN blog_sous_thematique ON t0.id = blog_sous_thematique.sous_thematique_id WHERE blog_sous_thematique.blog_id = ?
Parameters:
[
87
]
|
| 16 | 0.22 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3 FROM thematique t0 INNER JOIN blog_thematique ON t0.id = blog_thematique.thematique_id WHERE blog_thematique.blog_id = ?
Parameters:
[
87
]
|
Database Connections
| Name | Service |
|---|---|
| default | doctrine.dbal.default_connection |
| formation | doctrine.dbal.formation_connection |
Entity Managers
| Name | Service |
|---|---|
| default | doctrine.orm.default_entity_manager |
Second Level Cache
Second Level Cache is not enabled.
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\Offer |
|
| App\Entity\Society | No errors. |
| App\Entity\User | No errors. |
| App\Entity\Candidature | No errors. |
| App\Entity\OfferFavorite | No errors. |
| App\Entity\OfferVisit | No errors. |
| App\Entity\Profile | No errors. |
| App\Entity\Skill | No errors. |
| App\Entity\Experience | No errors. |
| App\Entity\Diplome | No errors. |
| App\Entity\Certification | No errors. |
| App\Entity\ProfileVisit |
|
| App\Entity\ProfileFavorite | No errors. |
| App\Entity\News | No errors. |
| App\Entity\Blog | No errors. |
| App\Entity\PublicationImage |
|
| App\Entity\Thematique | No errors. |
| App\Entity\SousThematique | No errors. |
| App\Entity\Message | No errors. |
| App\Entity\Room |
|
| App\Entity\AuthLog | No errors. |
| App\Entity\Report |
|
| App\Entity\OfferAlert | No errors. |
| App\Entity\Publication | No errors. |