https://testafaire.workdispo.com/

Query Metrics

16 Database Queries
8 Different statements
5.20 ms Query time
5 Invalid entities

Grouped Statements

Show all queries

default connection

Time Count Info
1.44 ms
(27.64%)
3
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
]
0.76 ms
(14.67%)
1
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:
[]
0.70 ms
(13.45%)
3
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
]
0.66 ms
(12.67%)
3
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
]
0.57 ms
(10.91%)
3
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
]
0.41 ms
(7.97%)
1
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
]
0.37 ms
(7.15%)
1
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:
[]
0.29 ms
(5.54%)
1
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:
[]

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
  • The association App\Entity\Offer#user refers to the inverse side field App\Entity\User#offers which does not exist.
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
  • The association App\Entity\ProfileVisit#user refers to the inverse side field App\Entity\User#profileVisits which does not exist.
App\Entity\ProfileFavorite No errors.
App\Entity\News No errors.
App\Entity\Blog No errors.
App\Entity\PublicationImage
  • The field App\Entity\PublicationImage#blog is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Blog#blogimage does not contain the required 'inversedBy="blog"' attribute.
App\Entity\Thematique No errors.
App\Entity\SousThematique No errors.
App\Entity\Message No errors.
App\Entity\Room
  • The mappings App\Entity\Room#called and App\Entity\User#rooms are inconsistent with each other.
App\Entity\AuthLog No errors.
App\Entity\Report
  • The association App\Entity\Report#society refers to the inverse side field App\Entity\Society#reports which does not exist.
  • The association App\Entity\Report#profile refers to the inverse side field App\Entity\Profile#reports which does not exist.
App\Entity\OfferAlert No errors.
App\Entity\Publication No errors.