Symfony Profiler

• Request / Response
• Performance
• Validator
• Forms
• Exception
• Logs 4
• Events
• Routing
• Cache
• Translation
• Security
• Twig
• Twig Components
• HTTP Client
• Doctrine
• Debug
• Messages
• Emails
• Notifications
• Serializer
• EasyAdmin
• Configuration

Query Metrics

SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.contract_type AS contract_type_4, t0.company_name AS company_name_5, t0.location AS location_6, t0.salary AS salary_7, t0.education_level AS education_level_8, t0.min_experience AS min_experience_9, t0.advantages AS advantages_10, t0.photo AS photo_11, t0.duration AS duration_12, t0.has_housing AS has_housing_13, t0.latitude AS latitude_14, t0.longitude AS longitude_15, t0.created_at AS created_at_16, t0.view_count AS view_count_17, t0.status AS status_18, t0.offer_type AS offer_type_19, t0.stripe_session_id AS stripe_session_id_20, t0.company_id AS company_id_21, t0.category_id AS category_id_22, t0.region_id AS region_id_23 FROM job_offer t0 WHERE t0.id = ?

[
  "61"
]

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.description AS description_3,
  t0.contract_type AS contract_type_4,
  t0.company_name AS company_name_5,
  t0.location AS location_6,
  t0.salary AS salary_7,
  t0.education_level AS education_level_8,
  t0.min_experience AS min_experience_9,
  t0.advantages AS advantages_10,
  t0.photo AS photo_11,
  t0.duration AS duration_12,
  t0.has_housing AS has_housing_13,
  t0.latitude AS latitude_14,
  t0.longitude AS longitude_15,
  t0.created_at AS created_at_16,
  t0.view_count AS view_count_17,
  t0.status AS status_18,
  t0.offer_type AS offer_type_19,
  t0.stripe_session_id AS stripe_session_id_20,
  t0.company_id AS company_id_21,
  t0.category_id AS category_id_22,
  t0.region_id AS region_id_23
FROM
  job_offer t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.contract_type AS contract_type_4, t0.company_name AS company_name_5, t0.location AS location_6, t0.salary AS salary_7, t0.education_level AS education_level_8, t0.min_experience AS min_experience_9, t0.advantages AS advantages_10, t0.photo AS photo_11, t0.duration AS duration_12, t0.has_housing AS has_housing_13, t0.latitude AS latitude_14, t0.longitude AS longitude_15, t0.created_at AS created_at_16, t0.view_count AS view_count_17, t0.status AS status_18, t0.offer_type AS offer_type_19, t0.stripe_session_id AS stripe_session_id_20, t0.company_id AS company_id_21, t0.category_id AS category_id_22, t0.region_id AS region_id_23 FROM job_offer t0 WHERE t0.id = '61';

"START TRANSACTION"

[]

"START TRANSACTION"

"START TRANSACTION";

UPDATE job_offer SET view_count = ? WHERE id = ?

[
  8
  61
]

UPDATE
  job_offer
SET
  view_count = ?
WHERE
  id = ?

UPDATE job_offer SET view_count = 8 WHERE id = 61;

"COMMIT"

[]

"COMMIT"

"COMMIT";

SELECT j0_.id AS id_0, j0_.title AS title_1, j0_.description AS description_2, j0_.contract_type AS contract_type_3, j0_.company_name AS company_name_4, j0_.location AS location_5, j0_.salary AS salary_6, j0_.education_level AS education_level_7, j0_.min_experience AS min_experience_8, j0_.advantages AS advantages_9, j0_.photo AS photo_10, j0_.duration AS duration_11, j0_.has_housing AS has_housing_12, j0_.latitude AS latitude_13, j0_.longitude AS longitude_14, j0_.created_at AS created_at_15, j0_.view_count AS view_count_16, j0_.status AS status_17, j0_.offer_type AS offer_type_18, j0_.stripe_session_id AS stripe_session_id_19, j0_.company_id AS company_id_20, j0_.category_id AS category_id_21, j0_.region_id AS region_id_22 FROM job_offer j0_ WHERE j0_.id <> ? AND j0_.status = ? AND j0_.category_id = ? ORDER BY j0_.created_at DESC LIMIT 3

[
  61
  "active"
  41
]

SELECT
  j0_.id AS id_0,
  j0_.title AS title_1,
  j0_.description AS description_2,
  j0_.contract_type AS contract_type_3,
  j0_.company_name AS company_name_4,
  j0_.location AS location_5,
  j0_.salary AS salary_6,
  j0_.education_level AS education_level_7,
  j0_.min_experience AS min_experience_8,
  j0_.advantages AS advantages_9,
  j0_.photo AS photo_10,
  j0_.duration AS duration_11,
  j0_.has_housing AS has_housing_12,
  j0_.latitude AS latitude_13,
  j0_.longitude AS longitude_14,
  j0_.created_at AS created_at_15,
  j0_.view_count AS view_count_16,
  j0_.status AS status_17,
  j0_.offer_type AS offer_type_18,
  j0_.stripe_session_id AS stripe_session_id_19,
  j0_.company_id AS company_id_20,
  j0_.category_id AS category_id_21,
  j0_.region_id AS region_id_22
FROM
  job_offer j0_
WHERE
  j0_.id <> ?
  AND j0_.status = ?
  AND j0_.category_id = ?
ORDER BY
  j0_.created_at DESC
LIMIT
  3

SELECT j0_.id AS id_0, j0_.title AS title_1, j0_.description AS description_2, j0_.contract_type AS contract_type_3, j0_.company_name AS company_name_4, j0_.location AS location_5, j0_.salary AS salary_6, j0_.education_level AS education_level_7, j0_.min_experience AS min_experience_8, j0_.advantages AS advantages_9, j0_.photo AS photo_10, j0_.duration AS duration_11, j0_.has_housing AS has_housing_12, j0_.latitude AS latitude_13, j0_.longitude AS longitude_14, j0_.created_at AS created_at_15, j0_.view_count AS view_count_16, j0_.status AS status_17, j0_.offer_type AS offer_type_18, j0_.stripe_session_id AS stripe_session_id_19, j0_.company_id AS company_id_20, j0_.category_id AS category_id_21, j0_.region_id AS region_id_22 FROM job_offer j0_ WHERE j0_.id <> 61 AND j0_.status = 'active' AND j0_.category_id = 41 ORDER BY j0_.created_at DESC LIMIT 3;

SELECT t0.id AS id_1, t0.company_name AS company_name_2, t0.description AS description_3, t0.website AS website_4, t0.logo AS logo_5, t0.stripe_customer_id AS stripe_customer_id_6, t0.stripe_cvtheque_subscription_id AS stripe_cvtheque_subscription_id_7, t0.cvtheque_active AS cvtheque_active_8, t0.user_id AS user_id_9 FROM company_profile t0 WHERE t0.id = ?

[
  11
]

SELECT
  t0.id AS id_1,
  t0.company_name AS company_name_2,
  t0.description AS description_3,
  t0.website AS website_4,
  t0.logo AS logo_5,
  t0.stripe_customer_id AS stripe_customer_id_6,
  t0.stripe_cvtheque_subscription_id AS stripe_cvtheque_subscription_id_7,
  t0.cvtheque_active AS cvtheque_active_8,
  t0.user_id AS user_id_9
FROM
  company_profile t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.company_name AS company_name_2, t0.description AS description_3, t0.website AS website_4, t0.logo AS logo_5, t0.stripe_customer_id AS stripe_customer_id_6, t0.stripe_cvtheque_subscription_id AS stripe_cvtheque_subscription_id_7, t0.cvtheque_active AS cvtheque_active_8, t0.user_id AS user_id_9 FROM company_profile t0 WHERE t0.id = 11;

SELECT t0.id AS id_1, t0.company_name AS company_name_2, t0.description AS description_3, t0.website AS website_4, t0.logo AS logo_5, t0.stripe_customer_id AS stripe_customer_id_6, t0.stripe_cvtheque_subscription_id AS stripe_cvtheque_subscription_id_7, t0.cvtheque_active AS cvtheque_active_8, t0.user_id AS user_id_9 FROM company_profile t0 WHERE t0.id = ?

[
  14
]

SELECT
  t0.id AS id_1,
  t0.company_name AS company_name_2,
  t0.description AS description_3,
  t0.website AS website_4,
  t0.logo AS logo_5,
  t0.stripe_customer_id AS stripe_customer_id_6,
  t0.stripe_cvtheque_subscription_id AS stripe_cvtheque_subscription_id_7,
  t0.cvtheque_active AS cvtheque_active_8,
  t0.user_id AS user_id_9
FROM
  company_profile t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.company_name AS company_name_2, t0.description AS description_3, t0.website AS website_4, t0.logo AS logo_5, t0.stripe_customer_id AS stripe_customer_id_6, t0.stripe_cvtheque_subscription_id AS stripe_cvtheque_subscription_id_7, t0.cvtheque_active AS cvtheque_active_8, t0.user_id AS user_id_9 FROM company_profile t0 WHERE t0.id = 14;

SELECT t0.id AS id_1, t0.company_name AS company_name_2, t0.description AS description_3, t0.website AS website_4, t0.logo AS logo_5, t0.stripe_customer_id AS stripe_customer_id_6, t0.stripe_cvtheque_subscription_id AS stripe_cvtheque_subscription_id_7, t0.cvtheque_active AS cvtheque_active_8, t0.user_id AS user_id_9 FROM company_profile t0 WHERE t0.id = ?

[
  12
]

SELECT
  t0.id AS id_1,
  t0.company_name AS company_name_2,
  t0.description AS description_3,
  t0.website AS website_4,
  t0.logo AS logo_5,
  t0.stripe_customer_id AS stripe_customer_id_6,
  t0.stripe_cvtheque_subscription_id AS stripe_cvtheque_subscription_id_7,
  t0.cvtheque_active AS cvtheque_active_8,
  t0.user_id AS user_id_9
FROM
  company_profile t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.company_name AS company_name_2, t0.description AS description_3, t0.website AS website_4, t0.logo AS logo_5, t0.stripe_customer_id AS stripe_customer_id_6, t0.stripe_cvtheque_subscription_id AS stripe_cvtheque_subscription_id_7, t0.cvtheque_active AS cvtheque_active_8, t0.user_id AS user_id_9 FROM company_profile t0 WHERE t0.id = 12;

SELECT t0.id AS id_1, t0.type AS type_2, t0.name AS name_3 FROM taxonomy t0 WHERE t0.id = ?

[
  41
]

SELECT
  t0.id AS id_1,
  t0.type AS type_2,
  t0.name AS name_3
FROM
  taxonomy t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.type AS type_2, t0.name AS name_3 FROM taxonomy t0 WHERE t0.id = 41;