https://testavoatest.avopy.com/sitemap.xml

Query Metrics

2 Database Queries
2 Different statements
7.45 ms Query time
1 Invalid entities

Grouped Statements

Show all queries

Time Count Info
6.09 ms
(81.80%)
1
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:
[]
1.36 ms
(18.20%)
1
SELECT t0.id AS id_1, t0.link AS link_2, t0.updated_at AS updated_at_3, t0.priority AS priority_4 FROM site_map t0 ORDER BY t0.priority DESC
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\SiteMap No errors.
App\Entity\Society No errors.
App\Entity\Candidature No errors.
App\Entity\OfferFavorite 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\ForumPost No errors.
App\Entity\ForumReport No errors.