Query Metrics
6
Database Queries
4
Different statements
1.54 ms
Query time
0
Invalid entities
8
Managed entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 0.10 ms |
SELECT t0.id AS id_1, t0.nom_site AS nom_site_2, t0.url_site AS url_site_3, t0.meta_description AS meta_description_4, t0.meta_mots_cles AS meta_mots_cles_5, t0.description AS description_6, t0.meta_title AS meta_title_7, t0.a_propos AS a_propos_8, t0.titre_apropos AS titre_apropos_9, t0.slug_apropos AS slug_apropos_10, t0.resume_apropos AS resume_apropos_11, t0.instagram_user_id AS instagram_user_id_12, t0.instagram_access_token AS instagram_access_token_13, t0.image_format_default AS image_format_default_14, t0.auteur_principal_id AS auteur_principal_id_15 FROM site t0 WHERE t0.url_site = ? LIMIT 1
Parameters:
[
"la-buse.fr"
]
|
||||||||||||||||||||||||||||
| 2 | 0.10 ms |
SELECT a0_.id AS id_0, a0_.title AS title_1, a0_.slug AS slug_2, a0_.summary AS summary_3, a0_.content AS content_4, a0_.published_at AS published_at_5, a0_.link AS link_6, a0_.image AS image_7, a0_.old_slug AS old_slug_8, a0_.dossier AS dossier_9, a0_.fichier_image AS fichier_image_10, a0_.publie AS publie_11, a0_.date_modif_at AS date_modif_at_12, a0_.en_avant AS en_avant_13, a0_.editeur AS editeur_14, a0_.credit AS credit_15, a0_.meta_description AS meta_description_16, a0_.note AS note_17, a0_.source AS source_18, a0_.guid AS guid_19, a0_.instagram_published_at AS instagram_published_at_20, a0_.image_format AS image_format_21, a0_.author_id AS author_id_22, a0_.categorie_id AS categorie_id_23, a0_.site_id AS site_id_24, a0_.flux_rss_id AS flux_rss_id_25 FROM article a0_ LEFT JOIN site s1_ ON a0_.site_id = s1_.id WHERE a0_.slug = ? AND s1_.url_site = ?
Parameters:
[ "le-taux-de-demandeurs-d-emploi-s-eleve-desormais-a-7-9" "la-buse.fr" ]
|
||||||||||||||||||||||||||||
| 3 | 0.62 ms |
SELECT a0_.id AS id_0, a0_.title AS title_1, a0_.slug AS slug_2, a0_.summary AS summary_3, a0_.content AS content_4, a0_.published_at AS published_at_5, a0_.link AS link_6, a0_.image AS image_7, a0_.old_slug AS old_slug_8, a0_.dossier AS dossier_9, a0_.fichier_image AS fichier_image_10, a0_.publie AS publie_11, a0_.date_modif_at AS date_modif_at_12, a0_.en_avant AS en_avant_13, a0_.editeur AS editeur_14, a0_.credit AS credit_15, a0_.meta_description AS meta_description_16, a0_.note AS note_17, a0_.source AS source_18, a0_.guid AS guid_19, a0_.instagram_published_at AS instagram_published_at_20, a0_.image_format AS image_format_21, a0_.author_id AS author_id_22, a0_.categorie_id AS categorie_id_23, a0_.site_id AS site_id_24, a0_.flux_rss_id AS flux_rss_id_25 FROM article a0_ LEFT JOIN site s1_ ON a0_.site_id = s1_.id WHERE s1_.url_site = ? AND a0_.published_at > ? ORDER BY a0_.published_at ASC LIMIT 1
Parameters:
[ "la-buse.fr" "2008-02-21 16:12:40" ]
|
||||||||||||||||||||||||||||
| 4 | 0.51 ms |
SELECT a0_.id AS id_0, a0_.title AS title_1, a0_.slug AS slug_2, a0_.summary AS summary_3, a0_.content AS content_4, a0_.published_at AS published_at_5, a0_.link AS link_6, a0_.image AS image_7, a0_.old_slug AS old_slug_8, a0_.dossier AS dossier_9, a0_.fichier_image AS fichier_image_10, a0_.publie AS publie_11, a0_.date_modif_at AS date_modif_at_12, a0_.en_avant AS en_avant_13, a0_.editeur AS editeur_14, a0_.credit AS credit_15, a0_.meta_description AS meta_description_16, a0_.note AS note_17, a0_.source AS source_18, a0_.guid AS guid_19, a0_.instagram_published_at AS instagram_published_at_20, a0_.image_format AS image_format_21, a0_.author_id AS author_id_22, a0_.categorie_id AS categorie_id_23, a0_.site_id AS site_id_24, a0_.flux_rss_id AS flux_rss_id_25 FROM article a0_ LEFT JOIN site s1_ ON a0_.site_id = s1_.id WHERE s1_.url_site = ? AND a0_.published_at < ? ORDER BY a0_.published_at DESC LIMIT 1
Parameters:
[ "la-buse.fr" "2008-02-21 16:12:40" ]
|
||||||||||||||||||||||||||||
| 5 | 0.11 ms |
SELECT t0.id AS id_1, t0.nom_site AS nom_site_2, t0.url_site AS url_site_3, t0.meta_description AS meta_description_4, t0.meta_mots_cles AS meta_mots_cles_5, t0.description AS description_6, t0.meta_title AS meta_title_7, t0.a_propos AS a_propos_8, t0.titre_apropos AS titre_apropos_9, t0.slug_apropos AS slug_apropos_10, t0.resume_apropos AS resume_apropos_11, t0.instagram_user_id AS instagram_user_id_12, t0.instagram_access_token AS instagram_access_token_13, t0.image_format_default AS image_format_default_14, t0.auteur_principal_id AS auteur_principal_id_15 FROM site t0 WHERE t0.url_site = ? LIMIT 1
Parameters:
[
"la-buse.fr"
]
|
||||||||||||||||||||||||||||
| 6 | 0.10 ms |
SELECT t0.id AS id_1, t0.nom_site AS nom_site_2, t0.url_site AS url_site_3, t0.meta_description AS meta_description_4, t0.meta_mots_cles AS meta_mots_cles_5, t0.description AS description_6, t0.meta_title AS meta_title_7, t0.a_propos AS a_propos_8, t0.titre_apropos AS titre_apropos_9, t0.slug_apropos AS slug_apropos_10, t0.resume_apropos AS resume_apropos_11, t0.instagram_user_id AS instagram_user_id_12, t0.instagram_access_token AS instagram_access_token_13, t0.image_format_default AS image_format_default_14, t0.auteur_principal_id AS auteur_principal_id_15 FROM site t0 WHERE t0.url_site = ? LIMIT 1
Parameters:
[
"la-buse.fr"
]
|
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.
Managed Entities
default entity manager
| Class | Amount of managed objects |
|---|---|
| App\Entity\Article | 3 |
| App\Entity\User | 2 |
| App\Entity\Categorie | 2 |
| App\Entity\Site | 1 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\Site | No errors. |
| App\Entity\User | No errors. |
| App\Entity\Categorie | No errors. |
| App\Entity\Gallerie | No errors. |
| App\Entity\Article | No errors. |
| App\Entity\Tag | No errors. |
| App\Entity\FluxRss | No errors. |
| App\Entity\ItemRss | No errors. |
| App\Entity\Comment | No errors. |