https://www.wspolczesnadietetyka.pl/app_dev.php/autorzy/joanna-lewandowska

Query Metrics

8 Database Queries
7 Different statements
5.28 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 1.02 ms
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 => joanna-lewandowska]
2 1.03 ms
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 => 266]
3 0.50 ms
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 => 266]
4 0.90 ms
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 => 266, 2 => [ 0 => 1195 ] ]
5 0.70 ms
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 => 3115]
6 0.46 ms
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 => 1]
7 0.30 ms
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 => 3114]
8 0.37 ms
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 => 1195]

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.