GET https://www.jobindustry.test-appli.cz/_fragment?_path=_format%3Dhtml%26_locale%3Dcs%26_controller%3DApp%255CController%255CNewsletterController%253A%253AshowFor…

Response
200 OK
IP
172.19.0.2
Profiled on
Token
afc1b8

Query Metrics

25 Database Queries
14 Different statements
289.50 ms Query time
0 Invalid entities

Queries

Group similar statements

#▲ Time Info
1 0.38 ms 
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.created_at AS created_at_4 FROM type t0
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
2 0.33 ms 
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.created_at AS created_at_4 FROM specialization t0
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
3 0.66 ms 
SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT j0_.id AS id_0, j0_.name AS name_1, j0_.slug AS slug_2, j0_.description AS description_3, j0_.description_text AS description_text_4, j0_.address AS address_5, j0_.offer AS offer_6, j0_.offer_text AS offer_text_7, j0_.requirement AS requirement_8, j0_.requirement_text AS requirement_text_9, j0_.work_hours_type AS work_hours_type_10, j0_.salary AS salary_11, j0_.is_remote AS is_remote_12, j0_.superior AS superior_13, j0_.superior_email AS superior_email_14, j0_.superior_phone AS superior_phone_15, j0_.superior_linkedin AS superior_linkedin_16, j0_.link AS link_17, j0_.video_link AS video_link_18, j0_.suitability AS suitability_19, j0_.email AS email_20, j0_.phone AS phone_21, j0_.image AS image_22, j0_.state AS state_23, j0_.region AS region_24, j0_.created_at AS created_at_25, j0_.published_at AS published_at_26, j0_.renewed_at AS renewed_at_27, j0_.expires_at AS expires_at_28, j0_.topped_at AS topped_at_29, j0_.type AS type_30, j0_.views AS views_31, j0_.detail_views AS detail_views_32, j0_.web_views AS web_views_33 FROM job j0_ LEFT JOIN company c1_ ON j0_.company_id = c1_.id LEFT JOIN job_specialization j3_ ON j0_.id = j3_.job_id LEFT JOIN specialization s2_ ON s2_.id = j3_.specialization_id LEFT JOIN job_type j5_ ON j0_.id = j5_.job_id LEFT JOIN type t4_ ON t4_.id = j5_.type_id WHERE j0_.state = ? AND j0_.expires_at > ? ORDER BY CASE WHEN j0_.topped_at IS NOT NULL AND j0_.topped_at <= CURRENT_TIMESTAMP THEN j0_.topped_at ELSE j0_.published_at END DESC) dctrn_result) dctrn_table
Parameters: 
[
  "PUBLISHED"
  "2025-11-08 06:30:30"
]
View formatted query    View runnable query    Explain query    View query backtrace
4 0.61 ms 
SELECT j0_.id AS id_0, j0_.name AS name_1, j0_.slug AS slug_2, j0_.description AS description_3, j0_.description_text AS description_text_4, j0_.address AS address_5, j0_.offer AS offer_6, j0_.offer_text AS offer_text_7, j0_.requirement AS requirement_8, j0_.requirement_text AS requirement_text_9, j0_.work_hours_type AS work_hours_type_10, j0_.salary AS salary_11, j0_.is_remote AS is_remote_12, j0_.superior AS superior_13, j0_.superior_email AS superior_email_14, j0_.superior_phone AS superior_phone_15, j0_.superior_linkedin AS superior_linkedin_16, j0_.link AS link_17, j0_.video_link AS video_link_18, j0_.suitability AS suitability_19, j0_.email AS email_20, j0_.phone AS phone_21, j0_.image AS image_22, j0_.state AS state_23, j0_.region AS region_24, j0_.created_at AS created_at_25, j0_.published_at AS published_at_26, j0_.renewed_at AS renewed_at_27, j0_.expires_at AS expires_at_28, j0_.topped_at AS topped_at_29, j0_.type AS type_30, j0_.views AS views_31, j0_.detail_views AS detail_views_32, j0_.web_views AS web_views_33, j0_.company_id AS company_id_34 FROM job j0_ LEFT JOIN company c1_ ON j0_.company_id = c1_.id LEFT JOIN job_specialization j3_ ON j0_.id = j3_.job_id LEFT JOIN specialization s2_ ON s2_.id = j3_.specialization_id LEFT JOIN job_type j5_ ON j0_.id = j5_.job_id LEFT JOIN type t4_ ON t4_.id = j5_.type_id WHERE j0_.state = ? AND j0_.expires_at > ? ORDER BY CASE WHEN j0_.topped_at IS NOT NULL AND j0_.topped_at <= CURRENT_TIMESTAMP THEN j0_.topped_at ELSE j0_.published_at END DESC
Parameters: 
[
  "PUBLISHED"
  "2025-11-08 06:30:30"
]
View formatted query    View runnable query    Explain query    View query backtrace
5 0.60 ms 
SELECT j0_.id AS id_0, j0_.name AS name_1, j0_.slug AS slug_2, j0_.description AS description_3, j0_.description_text AS description_text_4, j0_.address AS address_5, j0_.offer AS offer_6, j0_.offer_text AS offer_text_7, j0_.requirement AS requirement_8, j0_.requirement_text AS requirement_text_9, j0_.work_hours_type AS work_hours_type_10, j0_.salary AS salary_11, j0_.is_remote AS is_remote_12, j0_.superior AS superior_13, j0_.superior_email AS superior_email_14, j0_.superior_phone AS superior_phone_15, j0_.superior_linkedin AS superior_linkedin_16, j0_.link AS link_17, j0_.video_link AS video_link_18, j0_.suitability AS suitability_19, j0_.email AS email_20, j0_.phone AS phone_21, j0_.image AS image_22, j0_.state AS state_23, j0_.region AS region_24, j0_.created_at AS created_at_25, j0_.published_at AS published_at_26, j0_.renewed_at AS renewed_at_27, j0_.expires_at AS expires_at_28, j0_.topped_at AS topped_at_29, j0_.type AS type_30, j0_.views AS views_31, j0_.detail_views AS detail_views_32, j0_.web_views AS web_views_33, j0_.company_id AS company_id_34 FROM job j0_ LEFT JOIN company c1_ ON j0_.company_id = c1_.id LEFT JOIN job_specialization j3_ ON j0_.id = j3_.job_id LEFT JOIN specialization s2_ ON s2_.id = j3_.specialization_id LEFT JOIN job_type j5_ ON j0_.id = j5_.job_id LEFT JOIN type t4_ ON t4_.id = j5_.type_id WHERE j0_.state = ? AND j0_.expires_at > ?
Parameters: 
[
  "PUBLISHED"
  "2025-11-08 06:30:30"
]
View formatted query    View runnable query    Explain query    View query backtrace
6 0.32 ms 
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.created_at AS created_at_4 FROM specialization t0 INNER JOIN job_specialization ON t0.id = job_specialization.specialization_id WHERE job_specialization.job_id = ?
Parameters: 
[
  b"\x01ÖÖ▀ÏÌ~Bü+2â\x06ò*¶"
]
View formatted query    View runnable query    Explain query    View query backtrace
7 0.26 ms 
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.created_at AS created_at_4 FROM specialization t0 INNER JOIN job_specialization ON t0.id = job_specialization.specialization_id WHERE job_specialization.job_id = ?
Parameters: 
[
  b"""
    \x01Ö£\n
    Ç@t°î \x03ó¦ñeü
    """
]
View formatted query    View runnable query    Explain query    View query backtrace
8 0.28 ms 
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.created_at AS created_at_4 FROM specialization t0 INNER JOIN job_specialization ON t0.id = job_specialization.specialization_id WHERE job_specialization.job_id = ?
Parameters: 
[
  b"\x01™â\x13zmyfŽ)ZŽÉ@[¬"
]
View formatted query    View runnable query    Explain query    View query backtrace
9 0.49 ms 
SELECT j0_.id AS id_0, j0_.name AS name_1, j0_.slug AS slug_2, j0_.description AS description_3, j0_.description_text AS description_text_4, j0_.address AS address_5, j0_.offer AS offer_6, j0_.offer_text AS offer_text_7, j0_.requirement AS requirement_8, j0_.requirement_text AS requirement_text_9, j0_.work_hours_type AS work_hours_type_10, j0_.salary AS salary_11, j0_.is_remote AS is_remote_12, j0_.superior AS superior_13, j0_.superior_email AS superior_email_14, j0_.superior_phone AS superior_phone_15, j0_.superior_linkedin AS superior_linkedin_16, j0_.link AS link_17, j0_.video_link AS video_link_18, j0_.suitability AS suitability_19, j0_.email AS email_20, j0_.phone AS phone_21, j0_.image AS image_22, j0_.state AS state_23, j0_.region AS region_24, j0_.created_at AS created_at_25, j0_.published_at AS published_at_26, j0_.renewed_at AS renewed_at_27, j0_.expires_at AS expires_at_28, j0_.topped_at AS topped_at_29, j0_.type AS type_30, j0_.views AS views_31, j0_.detail_views AS detail_views_32, j0_.web_views AS web_views_33, j0_.company_id AS company_id_34 FROM job j0_ LEFT JOIN company c1_ ON j0_.company_id = c1_.id LEFT JOIN job_specialization j3_ ON j0_.id = j3_.job_id LEFT JOIN specialization s2_ ON s2_.id = j3_.specialization_id LEFT JOIN job_type j5_ ON j0_.id = j5_.job_id LEFT JOIN type t4_ ON t4_.id = j5_.type_id WHERE j0_.state = ? AND j0_.expires_at > ?
Parameters: 
[
  "PUBLISHED"
  "2025-11-08 06:30:30"
]
View formatted query    View runnable query    Explain query    View query backtrace
10 0.23 ms 
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.created_at AS created_at_4 FROM type t0 INNER JOIN job_type ON t0.id = job_type.type_id WHERE job_type.job_id = ?
Parameters: 
[
  b"\x01ÖÖ▀ÏÌ~Bü+2â\x06ò*¶"
]
View formatted query    View runnable query    Explain query    View query backtrace
11 0.23 ms 
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.created_at AS created_at_4 FROM type t0 INNER JOIN job_type ON t0.id = job_type.type_id WHERE job_type.job_id = ?
Parameters: 
[
  b"""
    \x01Ö£\n
    Ç@t°î \x03ó¦ñeü
    """
]
View formatted query    View runnable query    Explain query    View query backtrace
12 0.24 ms 
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.created_at AS created_at_4 FROM type t0 INNER JOIN job_type ON t0.id = job_type.type_id WHERE job_type.job_id = ?
Parameters: 
[
  b"\x01™â\x13zmyfŽ)ZŽÉ@[¬"
]
View formatted query    View runnable query    Explain query    View query backtrace
13 0.41 ms 
SELECT j0_.id AS id_0, j0_.name AS name_1, j0_.slug AS slug_2, j0_.description AS description_3, j0_.description_text AS description_text_4, j0_.address AS address_5, j0_.offer AS offer_6, j0_.offer_text AS offer_text_7, j0_.requirement AS requirement_8, j0_.requirement_text AS requirement_text_9, j0_.work_hours_type AS work_hours_type_10, j0_.salary AS salary_11, j0_.is_remote AS is_remote_12, j0_.superior AS superior_13, j0_.superior_email AS superior_email_14, j0_.superior_phone AS superior_phone_15, j0_.superior_linkedin AS superior_linkedin_16, j0_.link AS link_17, j0_.video_link AS video_link_18, j0_.suitability AS suitability_19, j0_.email AS email_20, j0_.phone AS phone_21, j0_.image AS image_22, j0_.state AS state_23, j0_.region AS region_24, j0_.created_at AS created_at_25, j0_.published_at AS published_at_26, j0_.renewed_at AS renewed_at_27, j0_.expires_at AS expires_at_28, j0_.topped_at AS topped_at_29, j0_.type AS type_30, j0_.views AS views_31, j0_.detail_views AS detail_views_32, j0_.web_views AS web_views_33, j0_.company_id AS company_id_34 FROM job j0_ LEFT JOIN company c1_ ON j0_.company_id = c1_.id LEFT JOIN job_specialization j3_ ON j0_.id = j3_.job_id LEFT JOIN specialization s2_ ON s2_.id = j3_.specialization_id LEFT JOIN job_type j5_ ON j0_.id = j5_.job_id LEFT JOIN type t4_ ON t4_.id = j5_.type_id WHERE j0_.state = ? AND j0_.expires_at > ?
Parameters: 
[
  "PUBLISHED"
  "2025-11-08 06:30:30"
]
View formatted query    View runnable query    Explain query    View query backtrace
14 0.56 ms 
SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0, CASE WHEN topped_at_29 IS NOT NULL AND topped_at_29 <= CURRENT_TIMESTAMP THEN topped_at_29 ELSE published_at_26 END FROM (SELECT j0_.id AS id_0, j0_.name AS name_1, j0_.slug AS slug_2, j0_.description AS description_3, j0_.description_text AS description_text_4, j0_.address AS address_5, j0_.offer AS offer_6, j0_.offer_text AS offer_text_7, j0_.requirement AS requirement_8, j0_.requirement_text AS requirement_text_9, j0_.work_hours_type AS work_hours_type_10, j0_.salary AS salary_11, j0_.is_remote AS is_remote_12, j0_.superior AS superior_13, j0_.superior_email AS superior_email_14, j0_.superior_phone AS superior_phone_15, j0_.superior_linkedin AS superior_linkedin_16, j0_.link AS link_17, j0_.video_link AS video_link_18, j0_.suitability AS suitability_19, j0_.email AS email_20, j0_.phone AS phone_21, j0_.image AS image_22, j0_.state AS state_23, j0_.region AS region_24, j0_.created_at AS created_at_25, j0_.published_at AS published_at_26, j0_.renewed_at AS renewed_at_27, j0_.expires_at AS expires_at_28, j0_.topped_at AS topped_at_29, j0_.type AS type_30, j0_.views AS views_31, j0_.detail_views AS detail_views_32, j0_.web_views AS web_views_33 FROM job j0_ LEFT JOIN company c1_ ON j0_.company_id = c1_.id LEFT JOIN job_specialization j3_ ON j0_.id = j3_.job_id LEFT JOIN specialization s2_ ON s2_.id = j3_.specialization_id LEFT JOIN job_type j5_ ON j0_.id = j5_.job_id LEFT JOIN type t4_ ON t4_.id = j5_.type_id WHERE j0_.state = ? AND j0_.expires_at > ?) dctrn_result_inner ORDER BY CASE WHEN topped_at_29 IS NOT NULL AND topped_at_29 <= CURRENT_TIMESTAMP THEN topped_at_29 ELSE published_at_26 END DESC) dctrn_result LIMIT 20
Parameters: 
[
  "PUBLISHED"
  "2025-11-08 06:30:30"
]
View formatted query    View runnable query    Explain query    View query backtrace
15 0.87 ms 
SELECT j0_.id AS id_0, j0_.name AS name_1, j0_.slug AS slug_2, j0_.description AS description_3, j0_.description_text AS description_text_4, j0_.address AS address_5, j0_.offer AS offer_6, j0_.offer_text AS offer_text_7, j0_.requirement AS requirement_8, j0_.requirement_text AS requirement_text_9, j0_.work_hours_type AS work_hours_type_10, j0_.salary AS salary_11, j0_.is_remote AS is_remote_12, j0_.superior AS superior_13, j0_.superior_email AS superior_email_14, j0_.superior_phone AS superior_phone_15, j0_.superior_linkedin AS superior_linkedin_16, j0_.link AS link_17, j0_.video_link AS video_link_18, j0_.suitability AS suitability_19, j0_.email AS email_20, j0_.phone AS phone_21, j0_.image AS image_22, j0_.state AS state_23, j0_.region AS region_24, j0_.created_at AS created_at_25, j0_.published_at AS published_at_26, j0_.renewed_at AS renewed_at_27, j0_.expires_at AS expires_at_28, j0_.topped_at AS topped_at_29, j0_.type AS type_30, j0_.views AS views_31, j0_.detail_views AS detail_views_32, j0_.web_views AS web_views_33, j0_.company_id AS company_id_34 FROM job j0_ LEFT JOIN company c1_ ON j0_.company_id = c1_.id LEFT JOIN job_specialization j3_ ON j0_.id = j3_.job_id LEFT JOIN specialization s2_ ON s2_.id = j3_.specialization_id LEFT JOIN job_type j5_ ON j0_.id = j5_.job_id LEFT JOIN type t4_ ON t4_.id = j5_.type_id WHERE j0_.state = ? AND j0_.expires_at > ? AND j0_.id IN (?, ?, ?) ORDER BY CASE WHEN j0_.topped_at IS NOT NULL AND j0_.topped_at <= CURRENT_TIMESTAMP THEN j0_.topped_at ELSE j0_.published_at END DESC
Parameters: 
[
  "PUBLISHED"
  "2025-11-08 06:30:30"
  b"\x01ÖÖ▀ÏÌ~Bü+2â\x06ò*¶"
  b"\x01™â\x13zmyfŽ)ZŽÉ@[¬"
  b"""
    \x01Ö£\n
    Ç@t°î \x03ó¦ñeü
    """
]
View formatted query    View runnable query    Explain query    View query backtrace
16 0.19 ms 
"START TRANSACTION"
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
17 0.39 ms 
UPDATE job SET views = ? WHERE id = ?
Parameters: 
[
  220
  b"\x01ÖÖ▀ÏÌ~Bü+2â\x06ò*¶"
]
View formatted query    View runnable query    Explain query    View query backtrace
18 0.30 ms 
UPDATE job SET views = ? WHERE id = ?
Parameters: 
[
  210
  b"\x01™â\x13zmyfŽ)ZŽÉ@[¬"
]
View formatted query    View runnable query    Explain query    View query backtrace
19 0.27 ms 
UPDATE job SET views = ? WHERE id = ?
Parameters: 
[
  220
  b"""
    \x01Ö£\n
    Ç@t°î \x03ó¦ñeü
    """
]
View formatted query    View runnable query    Explain query    View query backtrace
20 279.93 ms 
"COMMIT"
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
21 0.41 ms 
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.created_at AS created_at_4 FROM type t0
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
22 0.30 ms 
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.created_at AS created_at_4 FROM specialization t0
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
23 0.36 ms 
SELECT b0_.id AS id_0, b0_.name AS name_1, b0_.link AS link_2, b0_.size AS size_3, b0_.image AS image_4, b0_.deleted_at AS deleted_at_5, b0_.views AS views_6, b0_.clicks AS clicks_7, b0_.created_at AS created_at_8, b0_.updated_at AS updated_at_9, b0_.published_from AS published_from_10, b0_.published_to AS published_to_11 FROM banner b0_ WHERE ((b0_.published_from <= ? AND b0_.published_to >= ?) OR (b0_.published_from IS NULL AND b0_.published_to IS NULL) OR (b0_.published_from IS NULL AND b0_.published_to >= ?) OR (b0_.published_from <= ? AND b0_.published_to IS NULL)) AND b0_.size = ?
Parameters: 
[
  "2025-11-08 06:30:31"
  "2025-11-08 06:30:31"
  "2025-11-08 06:30:31"
  "2025-11-08 06:30:31"
  "small_banner"
]
View formatted query    View runnable query    Explain query    View query backtrace
24 0.39 ms 
SELECT b0_.id AS id_0, b0_.name AS name_1, b0_.link AS link_2, b0_.size AS size_3, b0_.image AS image_4, b0_.deleted_at AS deleted_at_5, b0_.views AS views_6, b0_.clicks AS clicks_7, b0_.created_at AS created_at_8, b0_.updated_at AS updated_at_9, b0_.published_from AS published_from_10, b0_.published_to AS published_to_11 FROM banner b0_ WHERE ((b0_.published_from <= ? AND b0_.published_to >= ?) OR (b0_.published_from IS NULL AND b0_.published_to IS NULL) OR (b0_.published_from IS NULL AND b0_.published_to >= ?) OR (b0_.published_from <= ? AND b0_.published_to IS NULL)) AND b0_.size = ?
Parameters: 
[
  "2025-11-08 06:30:31"
  "2025-11-08 06:30:31"
  "2025-11-08 06:30:31"
  "2025-11-08 06:30:31"
  "big_banner"
]
View formatted query    View runnable query    Explain query    View query backtrace
25 0.49 ms 
SELECT t0.id AS id_1, t0.name AS name_2, t0.billing_name AS billing_name_3, t0.billing_email AS billing_email_4, t0.slug AS slug_5, t0.description AS description_6, t0.ico AS ico_7, t0.dic AS dic_8, t0.street AS street_9, t0.city AS city_10, t0.zip AS zip_11, t0.country AS country_12, t0.website AS website_13, t0.top AS top_14, t0.sequence AS sequence_15, t0.residence AS residence_16, t0.image_name AS image_name_17, t0.video_title AS video_title_18, t0.video_description AS video_description_19, t0.video_link AS video_link_20, t0.gallery_title AS gallery_title_21, t0.gallery_description AS gallery_description_22, t0.linkedin AS linkedin_23, t0.facebook AS facebook_24, t0.instagram AS instagram_25, t0.youtube AS youtube_26, t0.created_at AS created_at_27, t0.updated_at AS updated_at_28, t0.bank_prefix AS bank_prefix_29, t0.bank_account AS bank_account_30, t0.bank_code AS bank_code_31 FROM company t0 WHERE t0.id = ?
Parameters: 
[
  b"\x01™™Ôµ.p\x03»µ8CæÄ\x1D"
]
View formatted query    View runnable query    Explain query    View query backtrace

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\Type No errors.
App\Entity\Job No errors.
App\Entity\Specialization No errors.
App\Entity\Company No errors.
App\Entity\Notification No errors.
App\Entity\Banner No errors.
App\Entity\User No errors.
App\Entity\CreditTransaction No errors.
App\Entity\Gallery No errors.
App\Entity\Invoice No errors.