GET https://bill.flexzob.com/jobs?page=2

Response
200 OK
IP
216.73.216.136
Profiled on
Token
b79351

Query Metrics

6 Database Queries
6 Different statements
22.13 ms Query time
0 Invalid entities
92 Managed entities

Grouped Statements

Show all queries

Time▼ Count Info
8.15 ms
(36.83%) 		1 
SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT DISTINCT b0_.id AS id_0, b0_.title AS title_1, b0_.description AS description_2, b0_.status AS status_3, b0_.country AS country_4, b0_.state AS state_5, b0_.city AS city_6, b0_.street_address AS street_address_7, b0_.expiration_date AS expiration_date_8, b0_.highlight AS highlight_9, b0_.schedule AS schedule_10, b0_.start_date AS start_date_11, b0_.year_of_experience AS year_of_experience_12, b0_.pay_rate AS pay_rate_13, b0_.work_type AS work_type_14, b0_.need AS need_15, b0_.pay_rate_hourly AS pay_rate_hourly_16, b0_.pay_rate_daily AS pay_rate_daily_17, b0_.annual_salary AS annual_salary_18, b0_.monthly_salary AS monthly_salary_19, b0_.salary_type AS salary_type_20, b0_.blocked AS blocked_21, b0_.job_id AS job_id_22, b0_.verified AS verified_23, b0_.is_mediated AS is_mediated_24, b0_.`rank` AS rank_25, b0_.created_at AS created_at_26, b0_.updated_at AS updated_at_27 FROM b_job b0_ LEFT JOIN b_job_recruiter b1_ ON (b1_.job_id = b0_.id) LEFT JOIN b_application b2_ ON (b2_.job_id = b0_.id) WHERE 1 = 1 AND b0_.blocked = ? AND b0_.verified = ? AND b0_.status = ? ORDER BY b0_.id DESC) dctrn_result) dctrn_table
Parameters: 
[
  0
  1
  "published"
]
View formatted query    View runnable query    Explain query    View query backtrace
7.53 ms
(34.05%) 		1 
SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0 FROM (SELECT DISTINCT b0_.id AS id_0, b0_.title AS title_1, b0_.description AS description_2, b0_.status AS status_3, b0_.country AS country_4, b0_.state AS state_5, b0_.city AS city_6, b0_.street_address AS street_address_7, b0_.expiration_date AS expiration_date_8, b0_.highlight AS highlight_9, b0_.schedule AS schedule_10, b0_.start_date AS start_date_11, b0_.year_of_experience AS year_of_experience_12, b0_.pay_rate AS pay_rate_13, b0_.work_type AS work_type_14, b0_.need AS need_15, b0_.pay_rate_hourly AS pay_rate_hourly_16, b0_.pay_rate_daily AS pay_rate_daily_17, b0_.annual_salary AS annual_salary_18, b0_.monthly_salary AS monthly_salary_19, b0_.salary_type AS salary_type_20, b0_.blocked AS blocked_21, b0_.job_id AS job_id_22, b0_.verified AS verified_23, b0_.is_mediated AS is_mediated_24, b0_.`rank` AS rank_25, b0_.created_at AS created_at_26, b0_.updated_at AS updated_at_27, b1_.id AS id_28, b1_.status AS status_29, b1_.commission_rate AS commission_rate_30, b1_.assigned_at AS assigned_at_31, b2_.id AS id_32, b2_.status AS status_33, b2_.applied_at AS applied_at_34, b2_.hired_at AS hired_at_35, b2_.document_requested_at AS document_requested_at_36, b2_.document_provided_at AS document_provided_at_37, b2_.one_file_requested_at AS one_file_requested_at_38, b2_.one_file_provided_at AS one_file_provided_at_39, b2_.contract_sent_at AS contract_sent_at_40, b2_.contract_file_name AS contract_file_name_41, b2_.contract_signed_at AS contract_signed_at_42, b2_.contract_signed_file_name AS contract_signed_file_name_43, b2_.`rank` AS rank_44, b2_.archived_at AS archived_at_45, b2_.is_archived AS is_archived_46, b2_.created_at AS created_at_47, b2_.updated_at AS updated_at_48 FROM b_job b0_ LEFT JOIN b_job_recruiter b1_ ON (b1_.job_id = b0_.id) LEFT JOIN b_application b2_ ON (b2_.job_id = b0_.id) WHERE 1 = 1 AND b0_.blocked = ? AND b0_.verified = ? AND b0_.status = ?) dctrn_result_inner ORDER BY id_0 DESC) dctrn_result LIMIT 25 OFFSET 25
Parameters: 
[
  0
  1
  "published"
]
View formatted query    View runnable query    Explain query    View query backtrace
3.59 ms
(16.24%) 		1 
SELECT DISTINCT b0_.id AS id_0, b0_.title AS title_1, b0_.description AS description_2, b0_.status AS status_3, b0_.country AS country_4, b0_.state AS state_5, b0_.city AS city_6, b0_.street_address AS street_address_7, b0_.expiration_date AS expiration_date_8, b0_.highlight AS highlight_9, b0_.schedule AS schedule_10, b0_.start_date AS start_date_11, b0_.year_of_experience AS year_of_experience_12, b0_.pay_rate AS pay_rate_13, b0_.work_type AS work_type_14, b0_.need AS need_15, b0_.pay_rate_hourly AS pay_rate_hourly_16, b0_.pay_rate_daily AS pay_rate_daily_17, b0_.annual_salary AS annual_salary_18, b0_.monthly_salary AS monthly_salary_19, b0_.salary_type AS salary_type_20, b0_.blocked AS blocked_21, b0_.job_id AS job_id_22, b0_.verified AS verified_23, b0_.is_mediated AS is_mediated_24, b0_.`rank` AS rank_25, b0_.created_at AS created_at_26, b0_.updated_at AS updated_at_27, b0_.user_id AS user_id_28, b0_.employer_id AS employer_id_29, b0_.profession_id AS profession_id_30, b0_.speciality_id AS speciality_id_31, b0_.assigned_recruiter_id AS assigned_recruiter_id_32 FROM b_job b0_ LEFT JOIN b_job_recruiter b1_ ON (b1_.job_id = b0_.id) LEFT JOIN b_application b2_ ON (b2_.job_id = b0_.id) WHERE 1 = 1 AND b0_.blocked = ? AND b0_.verified = ? AND b0_.status = ? AND b0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY b0_.id DESC
Parameters: 
[
  0
  1
  "published"
  b"\x01ûÏ¥8h\x7FÔë@▀­ÍÉ\rG"
  b"\x01–ؾ8h\x7Fâ‰@ßðÕè[§"
  b"\x01–ؾ8h\x7Fâ‰@ßðÕ&4«"
  b"\x01ûÏ¥8gr\x18üW%k╗Z═½"
  b"\x01–ؾ8Y|ÿ”ÙíS‰Ýh‰"
  b"\x01–ؾ8Y|ÿ”ÙíS‰0\v²"
  b"\x01ûÏ¥8Xt2ûõ*ò|╝É×"
  b"\x01–ؾ8Xt2–ä*•|„éë"
  b"\x01–ؾ8Xt2–ä*•{š¶\x13"
  b"\x01–ؾ8W~û•\x0E¨ÉH˜Å\x14"
  b"\x01–ؾ8W~û•\x0E¨ÉGº2´"
  b"\x01–ؾ8W~û•\x0E¨ÉG|íB"
  b"\x01–ؾ8VyjšÊ²\x13Òãó\x11"
  b"\x01–ؾ8VyjšÊ²\x13ÒE\x10q"
  b"\x01–ؾ8IuĪ3ý\x00Lårä"
  b"\x01–ؾ8IuĪ3ý\x00L\x04¬›"
  b"\x01–ؾ8Hp׸K‚_oµ¶ñ"
  b"\x01–ؾ8Hp׸K‚_o7\x1FÒ"
  b"\x01–ؾ8Hp׸K‚_nåla"
  b"\x01–ؾ8G}q±9“÷¼\x1A¢\x17"
  b"\x01–ؾ8G}q±9“÷»R¡ "
  b"\x01–ؾ8G}q±9“÷»\x1CRk"
  b"\x01–ؾ8Fs%²—\x05º,\x1C&G"
  b"\x01–ؾ8Fs%²—\x05º+áÚL"
  b"\x01–ؾ89xw‚æ¹\x13\x11Hw¾"
]
View formatted query    View runnable query    Explain query    View query backtrace
1.04 ms
(4.68%) 		1 
SELECT t0.id AS id_1, t0.name AS name_2, t0.profession_id AS profession_id_3 FROM b_speciality t0 ORDER BY t0.name ASC
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.91 ms
(4.13%) 		1 
SELECT t0.id AS id_1, t0.name AS name_2, t0.position AS position_3 FROM b_profession t0 ORDER BY t0.position ASC
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.90 ms
(4.07%) 		1 
SELECT t0.id AS id_1, t0.config_key AS config_key_2, t0.config_value AS config_value_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5 FROM b_config t0
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.

Managed Entities

default entity manager

Class Amount of managed objects
App\Entity\Speciality 36
App\Entity\Job 25
App\Entity\Config 23
App\Entity\Profession 6
App\Entity\User 1
App\Entity\Employer 1

Entities Mapping

Class Mapping errors
App\Entity\Job No errors.
App\Entity\JobRecruiter No errors.
App\Entity\Application No errors.
App\Entity\User No errors.
App\Entity\Employer No errors.
App\Entity\Profession No errors.
App\Entity\Speciality No errors.
App\Entity\Recruiter No errors.
App\Entity\Config No errors.