Query Metrics
8
Database Queries
7
Different statements
5.65 ms
Query time
0
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
1.25 ms (22.03%) |
1 |
SELECT count(DISTINCT a0_.id) AS sclr_0 FROM Artykul a0_ LEFT JOIN artykul_autor a2_ ON a0_.id = a2_.artykul_id LEFT JOIN author a1_ ON a1_.id = a2_.author_id LEFT JOIN Numerczasopisma n3_ ON a0_.numerczasopisma_id = n3_.id WHERE a0_.is_actived = ? AND a1_.id = ? AND n3_.is_actived = 1
Parameters: [0 => 1, 1 => 158]
|
1.15 ms (20.37%) |
1 |
SELECT a0_.id AS id_0, a0_.name AS name_1, a0_.comment_count AS comment_count_2, a0_.extId AS extId_3, a0_.rozmowca AS rozmowca_4, a0_.ekspertsComment AS ekspertsComment_5, a0_.is_actived AS is_actived_6, a0_.is_free AS is_free_7, a0_.is_sponsored AS is_sponsored_8, a0_.frontPage AS frontPage_9, a0_.prawaAutorskieOczekiwanie AS prawaAutorskieOczekiwanie_10, a0_.prawaAutorskieOdmowa AS prawaAutorskieOdmowa_11, a0_.frontPageFull AS frontPageFull_12, a0_.frontPageBox AS frontPageBox_13, a0_.onlyPdf AS onlyPdf_14, a0_.path AS path_15, a0_.imagename AS imagename_16, a0_.seoTitle AS seoTitle_17, a0_.seoDesc AS seoDesc_18, a0_.przypisy AS przypisy_19, a0_.image_description AS image_description_20, a0_.open_count AS open_count_21, a0_.download_count AS download_count_22, a0_.start AS start_23, a0_.end AS end_24, a0_.newEvent AS newEvent_25, a0_.created_at AS created_at_26, a0_.updated_at AS updated_at_27, a0_.topicNumber AS topicNumber_28, a0_.fbTitle AS fbTitle_29, a0_.fbDesc AS fbDesc_30, a0_.miasto AS miasto_31, a0_.slug AS slug_32, a0_.lead AS lead_33, a0_.contentFree AS contentFree_34, a0_.zachetaToContentPay AS zachetaToContentPay_35, a0_.contentPay AS contentPay_36, a0_.dzialczasopisma_id AS dzialczasopisma_id_37, a0_.numerczasopisma_id AS numerczasopisma_id_38, a0_.fbImage AS fbImage_39, a0_.image AS image_40 FROM Artykul a0_ LEFT JOIN artykul_autor a2_ ON a0_.id = a2_.artykul_id LEFT JOIN author a1_ ON a1_.id = a2_.author_id LEFT JOIN Numerczasopisma n3_ ON a0_.numerczasopisma_id = n3_.id WHERE a0_.is_actived = ? AND a1_.id = ? AND n3_.is_actived = 1 AND a0_.id IN (?) ORDER BY a0_.created_at DESC
Parameters: [
0 => 1,
1 => 158,
2 => [
0 => 708
]
]
|
1.11 ms (19.64%) |
2 |
SELECT t0.name AS name_1, t0.description AS description_2, t0.enabled AS enabled_3, t0.provider_name AS provider_name_4, t0.provider_status AS provider_status_5, t0.provider_reference AS provider_reference_6, t0.provider_metadata AS provider_metadata_7, t0.width AS width_8, t0.height AS height_9, t0.length AS length_10, t0.content_type AS content_type_11, t0.content_size AS content_size_12, t0.copyright AS copyright_13, t0.author_name AS author_name_14, t0.context AS context_15, t0.cdn_is_flushable AS cdn_is_flushable_16, t0.cdn_flush_identifier AS cdn_flush_identifier_17, t0.cdn_flush_at AS cdn_flush_at_18, t0.cdn_status AS cdn_status_19, t0.updated_at AS updated_at_20, t0.created_at AS created_at_21, t0.id AS id_22, t0.category_id AS category_id_23 FROM media__media t0 WHERE t0.id = ?
Parameters: [0 => 2775]
|
0.65 ms (11.45%) |
1 |
SELECT DISTINCT a0_.id AS id_0, a0_.created_at AS created_at_1 FROM Artykul a0_ LEFT JOIN artykul_autor a2_ ON a0_.id = a2_.artykul_id LEFT JOIN author a1_ ON a1_.id = a2_.author_id LEFT JOIN Numerczasopisma n3_ ON a0_.numerczasopisma_id = n3_.id WHERE a0_.is_actived = ? AND a1_.id = ? AND n3_.is_actived = 1 ORDER BY a0_.created_at DESC LIMIT 10 OFFSET 0
Parameters: [0 => 1, 1 => 158]
|
0.62 ms (10.95%) |
1 |
SELECT t0.name AS name_1, t0.tytul AS tytul_2, t0.content AS content_3, t0.id AS id_4, t0.created AS created_5, t0.updated AS updated_6, t0.seoTitle AS seoTitle_7, t0.seoDesc AS seoDesc_8, t0.instytucjaNazwa AS instytucjaNazwa_9, t0.showInFotter AS showInFotter_10, t0.czyInstytucja AS czyInstytucja_11, t0.typUdzialu AS typUdzialu_12, t0.stanowisko AS stanowisko_13, t0.path AS path_14, t0.imagename AS imagename_15, t0.slug AS slug_16, t0.typ_id AS typ_id_17, t0.image AS image_18 FROM author t0 WHERE t0.slug = ? LIMIT 1
Parameters: [0 => mgr-zuzanna-baraniak]
|
0.47 ms (8.39%) |
1 |
SELECT t0.name AS name_1, t0.tytul AS tytul_2, t0.content AS content_3, t0.id AS id_4, t0.created AS created_5, t0.updated AS updated_6, t0.seoTitle AS seoTitle_7, t0.seoDesc AS seoDesc_8, t0.instytucjaNazwa AS instytucjaNazwa_9, t0.showInFotter AS showInFotter_10, t0.czyInstytucja AS czyInstytucja_11, t0.typUdzialu AS typUdzialu_12, t0.stanowisko AS stanowisko_13, t0.path AS path_14, t0.imagename AS imagename_15, t0.slug AS slug_16, t0.typ_id AS typ_id_17, t0.image AS image_18 FROM author t0 INNER JOIN artykul_autor ON t0.id = artykul_autor.author_id WHERE artykul_autor.artykul_id = ?
Parameters: [0 => 708]
|
0.41 ms (7.18%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.cssClass AS cssClass_3, t0.position AS position_4, t0.lead AS lead_5, t0.path AS path_6, t0.imagename AS imagename_7, t0.seoTitle AS seoTitle_8, t0.seoDesc AS seoDesc_9, t0.menuIsActived AS menuIsActived_10, t0.slug AS slug_11, t0.czasopismo_id AS czasopismo_id_12 FROM Dzialczasopisma t0 WHERE t0.id = ?
Parameters: [0 => 30]
|
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 |
---|---|
FOS\UserBundle\Entity\User | No errors. |
Sonata\UserBundle\Entity\BaseUser | No errors. |
Application\Sonata\UserBundle\Entity\User | No errors. |
App\GeneralBundle\Entity\Author | No errors. |
App\GeneralBundle\Entity\AuthorTyp | No errors. |
Sonata\MediaBundle\Entity\BaseMedia | No errors. |
Application\Sonata\MediaBundle\Entity\Media | No errors. |
App\GeneralBundle\Entity\Artykul | No errors. |
App\GeneralBundle\Entity\Numerczasopisma | No errors. |
App\GeneralBundle\Entity\Dzialczasopisma | No errors. |
App\GeneralBundle\Entity\Tag | No errors. |
App\GeneralBundle\Entity\Source | No errors. |
App\GeneralBundle\Entity\Plik | No errors. |
Sonata\ClassificationBundle\Entity\BaseCategory | No errors. |
Application\Sonata\ClassificationBundle\Entity\Category | No errors. |
Sonata\MediaBundle\Entity\BaseGalleryHasMedia | No errors. |
Application\Sonata\MediaBundle\Entity\GalleryHasMedia | No errors. |
App\GeneralBundle\Entity\Czasopismo | No errors. |