301 redirect from GET @article (9f00c5)

GET http://asin.olasoft.net/opportunite/6/avis-recrutement-technicien-centre-services/

Query Metrics

9 Database Queries
9 Different statements
12.85 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 6.94 ms
SELECT t0.opening_date AS opening_date_1, t0.closing_date AS closing_date_2, t0.structure AS structure_3, t0.place AS place_4, t0.submission_link AS submission_link_5, t0.submission_btn_title AS submission_btn_title_6, t0.id AS id_7, t0.title AS title_8, t0.description AS description_9, t0.content AS content_10, t0.slug AS slug_11, t0.date AS date_12, t0.createdAt AS createdAt_13, t0.lastUpdate AS lastUpdate_14, t0.isEnabled AS isEnabled_15, t0.biblio_id AS biblio_id_16, t17.id AS id_18, t17.title AS title_19, t17.isEnabled AS isEnabled_20, t0.category_id AS category_id_21, t22.id AS id_23, t22.label AS label_24, t22.description AS description_25, t22.slug AS slug_26, t22.isEnabled AS isEnabled_27, t0.type_id AS type_id_28, t0.banner_id AS banner_id_29, t30.target AS target_31, t30.thumbnailDir AS thumbnailDir_32, t30.hasThumbnail AS hasThumbnail_33, t30.id AS id_34, t30.pages AS pages_35, t30.downloads AS downloads_36, t30.reading AS reading_37, t30.name AS name_38, t30.dir AS dir_39, t30.source AS source_40, t30.size AS size_41, t30.is_enabled AS is_enabled_42, t30.is_deleted AS is_deleted_43, t30.last_update AS last_update_44, t30.created_at AS created_at_45, t30.formatSize AS formatSize_46, t30.mimetype AS mimetype_47, t0.sector_id AS sector_id_48, t0.user_id AS user_id_49, t50.id AS id_51, t50.fName AS fName_52, t50.lName AS lName_53, t50.phone AS phone_54, t50.createdAt AS createdAt_55, t50.lastLogin AS lastLogin_56, t50.password AS password_57, t50.token AS token_58, t50.sex AS sex_59, t50.isEnabled AS isEnabled_60, t50.email AS email_61, t50.profile_id AS profile_id_62, t0.updatedBy AS updatedBy_63 FROM opportunities t0 LEFT JOIN biblios t17 ON t0.biblio_id = t17.id LEFT JOIN opportunities_categories t22 ON t0.category_id = t22.id LEFT JOIN picture t30 ON t0.banner_id = t30.id LEFT JOIN users t50 ON t0.user_id = t50.id WHERE t0.id = ?
Parameters:
[
  "6"
]
2 0.67 ms
SELECT o0_.opening_date AS opening_date_0, o0_.closing_date AS closing_date_1, o0_.structure AS structure_2, o0_.place AS place_3, o0_.submission_link AS submission_link_4, o0_.submission_btn_title AS submission_btn_title_5, o0_.id AS id_6, o0_.title AS title_7, o0_.description AS description_8, o0_.content AS content_9, o0_.slug AS slug_10, o0_.date AS date_11, o0_.createdAt AS createdAt_12, o0_.lastUpdate AS lastUpdate_13, o0_.isEnabled AS isEnabled_14, o0_.biblio_id AS biblio_id_15, o0_.category_id AS category_id_16, o0_.type_id AS type_id_17, o0_.banner_id AS banner_id_18, o0_.sector_id AS sector_id_19, o0_.user_id AS user_id_20, o0_.updatedBy AS updatedBy_21 FROM opportunities o0_ WHERE o0_.isEnabled = 1
Parameters:
[]
3 0.49 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.isEnabled AS isEnabled_3 FROM biblios t0 WHERE t0.id IN (?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  1
  2
  3
  4
  5
  7
  8
]
4 0.54 ms
SELECT t0.id AS id_1, t0.label AS label_2, t0.description AS description_3, t0.slug AS slug_4, t0.isEnabled AS isEnabled_5 FROM opportunities_categories t0 WHERE t0.id IN (?)
Parameters:
[
  1
]
5 0.64 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.description AS description_4, t0.isEnabled AS isEnabled_5, t0.banner_id AS banner_id_6 FROM articles_categories t0 WHERE t0.isEnabled = ?
Parameters:
[
  1
]
6 0.38 ms
SELECT t0.id AS id_1, t0.label AS label_2, t0.description AS description_3, t0.slug AS slug_4, t0.isEnabled AS isEnabled_5 FROM opportunities_categories t0 WHERE t0.isEnabled = ?
Parameters:
[
  1
]
7 0.57 ms
SELECT t0.id AS id_1, t0.label AS label_2, t0.description AS description_3, t0.slug AS slug_4 FROM resources_categories t0
Parameters:
[]
8 0.50 ms
SELECT t0.id AS id_1, t0.label AS label_2, t0.description AS description_3, t0.slug AS slug_4, t0.isEnabled AS isEnabled_5 FROM videos_categories t0 WHERE t0.isEnabled = ?
Parameters:
[
  1
]
9 2.12 ms
SELECT t0.id AS id_1, t0.target AS target_2, t0.pages AS pages_3, t0.downloads AS downloads_4, t0.reading AS reading_5, t0.name AS name_6, t0.dir AS dir_7, t0.source AS source_8, t0.size AS size_9, t0.is_enabled AS is_enabled_10, t0.is_deleted AS is_deleted_11, t0.last_update AS last_update_12, t0.created_at AS created_at_13, t0.formatSize AS formatSize_14, t0.mimetype AS mimetype_15 FROM file t0 INNER JOIN biblios_file ON t0.id = biblios_file.file_id WHERE biblios_file.biblios_id = ?
Parameters:
[
  6
]

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\OSEntity No errors.
App\Entity\Opportunities No errors.
App\Entity\Biblios No errors.
App\Entity\OpportunitiesCategories No errors.
App\Entity\OpportunitiesTypes No errors.
App\Entity\OSFile No errors.
App\Entity\Picture No errors.
App\Entity\Sectors No errors.
App\Entity\Users No errors.
App\Entity\Profiles No errors.
App\Entity\Tags No errors.
App\Entity\File No errors.
App\Entity\ArticlesCategories No errors.
App\Entity\Articles No errors.
App\Entity\ResourcesCategories No errors.
App\Entity\VideosCategories No errors.
App\Entity\ArticlesTypes No errors.
App\Entity\Albums No errors.
App\Entity\Resources No errors.
App\Entity\Subscribers No errors.