Query Metrics
116
Database Queries
8
Different statements
44.80 ms
Query time
0
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
28.03 ms (62.57%) |
88 |
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 => 1891]
|
6.71 ms (14.97%) |
14 |
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 => 1041]
|
2.64 ms (5.89%) |
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_ INNER JOIN Dzialczasopisma d1_ ON a0_.dzialczasopisma_id = d1_.id INNER JOIN Numerczasopisma n2_ ON a0_.numerczasopisma_id = n2_.id WHERE a0_.is_actived = 1 AND n2_.is_actived = 1 AND a0_.numerczasopisma_id = ? ORDER BY d1_.position ASC
Parameters: [0 => 50]
|
2.39 ms (5.33%) |
9 |
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 => 8]
|
1.75 ms (3.90%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.comment_count AS comment_count_3, t0.extId AS extId_4, t0.rozmowca AS rozmowca_5, t0.ekspertsComment AS ekspertsComment_6, t0.is_actived AS is_actived_7, t0.is_free AS is_free_8, t0.is_sponsored AS is_sponsored_9, t0.frontPage AS frontPage_10, t0.prawaAutorskieOczekiwanie AS prawaAutorskieOczekiwanie_11, t0.prawaAutorskieOdmowa AS prawaAutorskieOdmowa_12, t0.frontPageFull AS frontPageFull_13, t0.frontPageBox AS frontPageBox_14, t0.onlyPdf AS onlyPdf_15, t0.path AS path_16, t0.imagename AS imagename_17, t0.seoTitle AS seoTitle_18, t0.seoDesc AS seoDesc_19, t0.przypisy AS przypisy_20, t0.image_description AS image_description_21, t0.open_count AS open_count_22, t0.download_count AS download_count_23, t0.start AS start_24, t0.end AS end_25, t0.newEvent AS newEvent_26, t0.created_at AS created_at_27, t0.updated_at AS updated_at_28, t0.topicNumber AS topicNumber_29, t0.fbTitle AS fbTitle_30, t0.fbDesc AS fbDesc_31, t0.miasto AS miasto_32, t0.slug AS slug_33, t0.lead AS lead_34, t0.contentFree AS contentFree_35, t0.zachetaToContentPay AS zachetaToContentPay_36, t0.contentPay AS contentPay_37, t0.dzialczasopisma_id AS dzialczasopisma_id_38, t0.numerczasopisma_id AS numerczasopisma_id_39, t0.fbImage AS fbImage_40, t0.image AS image_41 FROM Artykul t0 WHERE t0.numerczasopisma_id = ?
Parameters: [0 => 50]
|
1.48 ms (3.31%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.numer AS numer_3, t0.tematNumeru AS tematNumeru_4, t0.numerAbsolutny AS numerAbsolutny_5, t0.fbParse AS fbParse_6, t0.fbConverted AS fbConverted_7, t0.isActivedFB AS isActivedFB_8, t0.indexFB AS indexFB_9, t0.token AS token_10, t0.tematNumeruPromocyjny AS tematNumeruPromocyjny_11, t0.is_actived AS is_actived_12, t0.created_at AS created_at_13, t0.updated_at AS updated_at_14, t0.lead AS lead_15, t0.short_lead AS short_lead_16, t0.nextArt AS nextArt_17, t0.pdfPath AS pdfPath_18, t0.path AS path_19, t0.imagename AS imagename_20, t0.data_at AS data_at_21, t0.slug AS slug_22, t0.image AS image_23, t0.czasopismo_id AS czasopismo_id_24, t25.id AS id_26, t25.name AS name_27, t25.name2 AS name2_28, t25.price_netto AS price_netto_29, t25.price_brutto AS price_brutto_30, t25.product_nr AS product_nr_31, t25.created AS created_32, t25.updated AS updated_33, t25.is_actived AS is_actived_34, t25.content AS content_35, t25.name_to_sb AS name_to_sb_36, t25.slug AS slug_37, t25.uniqInBasket AS uniqInBasket_38, t25.position AS position_39, t25.delivery_group_id AS delivery_group_id_40, t25.czasopismo_id AS czasopismo_id_41, t25.numerczasopisma_id AS numerczasopisma_id_42 FROM Numerczasopisma t0 LEFT JOIN product_numery t25 ON t25.numerczasopisma_id = t0.id WHERE t0.is_actived = ? AND t0.czasopismo_id = ? ORDER BY t0.data_at DESC
Parameters: [0 => 1, 1 => 1]
|
0.99 ms (2.21%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.numer AS numer_3, t0.tematNumeru AS tematNumeru_4, t0.numerAbsolutny AS numerAbsolutny_5, t0.fbParse AS fbParse_6, t0.fbConverted AS fbConverted_7, t0.isActivedFB AS isActivedFB_8, t0.indexFB AS indexFB_9, t0.token AS token_10, t0.tematNumeruPromocyjny AS tematNumeruPromocyjny_11, t0.is_actived AS is_actived_12, t0.created_at AS created_at_13, t0.updated_at AS updated_at_14, t0.lead AS lead_15, t0.short_lead AS short_lead_16, t0.nextArt AS nextArt_17, t0.pdfPath AS pdfPath_18, t0.path AS path_19, t0.imagename AS imagename_20, t0.data_at AS data_at_21, t0.slug AS slug_22, t0.image AS image_23, t0.czasopismo_id AS czasopismo_id_24, t25.id AS id_26, t25.name AS name_27, t25.name2 AS name2_28, t25.price_netto AS price_netto_29, t25.price_brutto AS price_brutto_30, t25.product_nr AS product_nr_31, t25.created AS created_32, t25.updated AS updated_33, t25.is_actived AS is_actived_34, t25.content AS content_35, t25.name_to_sb AS name_to_sb_36, t25.slug AS slug_37, t25.uniqInBasket AS uniqInBasket_38, t25.position AS position_39, t25.delivery_group_id AS delivery_group_id_40, t25.czasopismo_id AS czasopismo_id_41, t25.numerczasopisma_id AS numerczasopisma_id_42 FROM Numerczasopisma t0 LEFT JOIN product_numery t25 ON t25.numerczasopisma_id = t0.id WHERE t0.numer = ? AND t0.is_actived = ? LIMIT 1
Parameters: [0 => 49/2023, 1 => 1]
|
0.82 ms (1.82%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.is_actived AS is_actived_3, t0.template AS template_4, t0.redakcja_email AS redakcja_email_5, t0.zamowienia_email AS zamowienia_email_6, t0.google_id AS google_id_7, t0.headCode AS headCode_8, t0.reMarketing AS reMarketing_9 FROM Czasopismo t0 WHERE t0.id = ?
Parameters: [0 => 1]
|
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\Numerczasopisma | No errors. |
Sonata\MediaBundle\Entity\BaseMedia | No errors. |
Application\Sonata\MediaBundle\Entity\Media | No errors. |
App\GeneralBundle\Entity\Czasopismo | No errors. |
App\CartBundle\Entity\Product | No errors. |
App\Product\NumeryBundle\Entity\NumeryProduct | No errors. |
App\CartBundle\Entity\DeliveryGroup | No errors. |
App\GeneralBundle\Entity\Artykul | No errors. |
App\GeneralBundle\Entity\Dzialczasopisma | No errors. |
App\GeneralBundle\Entity\Tag | No errors. |
App\GeneralBundle\Entity\Author | No errors. |
App\GeneralBundle\Entity\Source | No errors. |
App\GeneralBundle\Entity\Plik | No errors. |
App\GeneralBundle\Entity\AuthorTyp | No errors. |
App\CartBundle\Entity\Item | No errors. |
App\Product\NumeryBundle\Entity\NumeryItem | No errors. |
App\Product\SubscriptionBundle\Entity\SubscriptionProduct | 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. |