https://testavoatest.avopy.com/searchjobs

Query Metrics

8 Database Queries
4 Different statements
37.62 ms Query time
1 Invalid entities

Grouped Statements

Show all queries

Time Count Info
26.17 ms
(69.57%)
3
SELECT t0.id AS id_1, t0.title AS title_2, t0.min_tjm AS min_tjm_3, t0.max_tjm AS max_tjm_4, t0.open_society AS open_society_5, t0.location AS location_6, t0.description AS description_7, t0.duration_value AS duration_value_8, t0.duration_type AS duration_type_9, t0.mode_remote AS mode_remote_10, t0.year_required AS year_required_11, t0.show_coordinate AS show_coordinate_12, t0.renew AS renew_13, t0.created_at AS created_at_14, t0.expire_at AS expire_at_15, t0.contact_civility AS contact_civility_16, t0.contact_mail AS contact_mail_17, t0.contact_phone AS contact_phone_18, t0.starting_type AS starting_type_19, t0.startin_date AS startin_date_20, t0.contact_name AS contact_name_21, t0.questions AS questions_22, t0.view AS view_23, t0.unseen_candidature AS unseen_candidature_24, t0.ville AS ville_25, t0.priorize AS priorize_26, t0.weekly AS weekly_27, t0.daily AS daily_28, t0.civility AS civility_29, t0.type_search AS type_search_30, t0.salary_per_month_min AS salary_per_month_min_31, t0.salary_per_month_max AS salary_per_month_max_32, t0.salary_per_hour_min AS salary_per_hour_min_33, t0.salary_per_hour_max AS salary_per_hour_max_34, t0.society_extern_name AS society_extern_name_35, t0.link_extern AS link_extern_36, t0.not_draft AS not_draft_37, t0.date_remonter AS date_remonter_38, t0.share_on_social_network AS share_on_social_network_39, t0.by_super_admin AS by_super_admin_40, t0.site_map_index AS site_map_index_41, t0.slug AS slug_42, t0.society_id AS society_id_43, t0.user_recruteur_id AS user_recruteur_id_44, t0.user_by_admin_id AS user_by_admin_id_45 FROM offer t0
Parameters:
[]
10.94 ms
(29.09%)
3
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_.renew AS renew_12, o0_.created_at AS created_at_13, o0_.expire_at AS expire_at_14, o0_.contact_civility AS contact_civility_15, o0_.contact_mail AS contact_mail_16, o0_.contact_phone AS contact_phone_17, o0_.starting_type AS starting_type_18, o0_.startin_date AS startin_date_19, o0_.contact_name AS contact_name_20, o0_.questions AS questions_21, o0_.view AS view_22, o0_.unseen_candidature AS unseen_candidature_23, o0_.ville AS ville_24, o0_.priorize AS priorize_25, o0_.weekly AS weekly_26, o0_.daily AS daily_27, o0_.civility AS civility_28, o0_.type_search AS type_search_29, o0_.salary_per_month_min AS salary_per_month_min_30, o0_.salary_per_month_max AS salary_per_month_max_31, o0_.salary_per_hour_min AS salary_per_hour_min_32, o0_.salary_per_hour_max AS salary_per_hour_max_33, o0_.society_extern_name AS society_extern_name_34, o0_.link_extern AS link_extern_35, o0_.not_draft AS not_draft_36, o0_.date_remonter AS date_remonter_37, o0_.share_on_social_network AS share_on_social_network_38, o0_.by_super_admin AS by_super_admin_39, o0_.site_map_index AS site_map_index_40, o0_.slug AS slug_41, o0_.society_id AS society_id_42, o0_.user_recruteur_id AS user_recruteur_id_43, o0_.user_by_admin_id AS user_by_admin_id_44 FROM offer o0_ WHERE o0_.id <> 0 AND o0_.not_draft = 1
Parameters:
[]
0.28 ms
(0.73%)
1
SELECT t0.id AS id_1, t0.keyword AS keyword_2, t0.localisation AS localisation_3, t0.remote AS remote_4, t0.min_tjm AS min_tjm_5, t0.last_send AS last_send_6, t0.type_search AS type_search_7, t0.year_requireds AS year_requireds_8, t0.user_id AS user_id_9 FROM offer_alert t0 WHERE t0.keyword = ? AND t0.localisation = ? AND t0.type_search = ? AND t0.user_id IS NULL LIMIT 1
Parameters:
[
  ""
  "All UAE"
  ""
]
0.23 ms
(0.60%)
1
SELECT t0.id AS id_1, t0.alias AS alias_2, t0.created_at AS created_at_3, t0.deleted_at AS deleted_at_4, t0.user_id AS user_id_5 FROM forum_user t0 ORDER BY t0.id DESC LIMIT 1
Parameters:
[]

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.

Entities Mapping

Class Mapping errors
App\Entity\User No errors.
App\Entity\Offer No errors.
App\Entity\OfferAlert No errors.
App\Entity\Candidature No errors.
App\Entity\Society No errors.
App\Entity\OfferFavorite No errors.
App\Entity\ForumUser No errors.
App\Entity\ForumPost No errors.
App\Entity\ForumComment No errors.
App\Entity\ForumCommentReply 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\Notification No errors.
App\Entity\ForumReport No errors.