GET https://jobindustry.test-appli.cz/pozice/reditel-78382

Response
200 OK
IP
172.19.0.2
Profiled on
Token
2a0a32

Query Metrics

4 Database Queries
4 Different statements
110.84 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time▼ Count Info
109.36 ms
(98.67%) 		1 
"COMMIT"
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.72 ms
(0.65%) 		1 
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, c1_.id AS id_34, c1_.name AS name_35, c1_.billing_name AS billing_name_36, c1_.billing_email AS billing_email_37, c1_.slug AS slug_38, c1_.description AS description_39, c1_.ico AS ico_40, c1_.dic AS dic_41, c1_.street AS street_42, c1_.city AS city_43, c1_.zip AS zip_44, c1_.country AS country_45, c1_.website AS website_46, c1_.top AS top_47, c1_.sequence AS sequence_48, c1_.residence AS residence_49, c1_.image_name AS image_name_50, c1_.video_title AS video_title_51, c1_.video_description AS video_description_52, c1_.video_link AS video_link_53, c1_.gallery_title AS gallery_title_54, c1_.gallery_description AS gallery_description_55, c1_.linkedin AS linkedin_56, c1_.facebook AS facebook_57, c1_.instagram AS instagram_58, c1_.youtube AS youtube_59, c1_.created_at AS created_at_60, c1_.updated_at AS updated_at_61, c1_.bank_prefix AS bank_prefix_62, c1_.bank_account AS bank_account_63, c1_.bank_code AS bank_code_64, j0_.company_id AS company_id_65 FROM job j0_ LEFT JOIN company c1_ ON j0_.company_id = c1_.id WHERE j0_.slug = ?
Parameters: 
[
  "reditel-78382"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.46 ms
(0.42%) 		1 
UPDATE job SET detail_views = ? WHERE id = ?
Parameters: 
[
  28
  b"""
    \x01Ö£\n
    Ç@t°î \x03ó¦ñeü
    """
]
View formatted query    View runnable query    Explain query    View query backtrace
0.30 ms
(0.27%) 		1 
"START TRANSACTION"
Parameters: 
[]
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\Job No errors.
App\Entity\Company No errors.
App\Entity\Specialization No errors.
App\Entity\Type No errors.
App\Entity\Notification No errors.
App\Entity\User No errors.
App\Entity\CreditTransaction No errors.
App\Entity\Gallery No errors.
App\Entity\Invoice No errors.
App\Entity\UserNotification No errors.
App\Entity\Token No errors.