Query Metrics
8
Database Queries
4
Different statements
37.62 ms
Query time
1
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 0.28 ms |
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"
""
]
|
| 2 | 3.55 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_.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:
[] |
| 3 | 3.63 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_.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:
[] |
| 4 | 9.61 ms |
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:
[] |
| 5 | 3.77 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_.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:
[] |
| 6 | 0.23 ms |
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:
[] |
| 7 | 8.15 ms |
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:
[] |
| 8 | 8.40 ms |
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:
[] |
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 |
|
| App\Entity\Notification | No errors. |
| App\Entity\ForumReport | No errors. |