GET https://ftpjkblog.ondravotava.cz/api/job-offers-faceted?limit=10&page=1

Response
200 OK
Browse referrer URL
IP
66.249.66.74
Profiled on
Token
22c073

Query Metrics

3 Database Queries
3 Different statements
9.68 ms Query time
0 Invalid entities
0 Managed entities

Queries

Group similar statements

#▲ Time Info
1 1.83 ms 
SELECT jo.id, jo.title, jo.created_at as createdAt, jo.salary_min as salaryMin, jo.salary_max as salaryMax, l.city AS cityName
		FROM job_offer jo
		LEFT JOIN location l ON jo.location_id = l.id
		LEFT JOIN work_position wp ON jo.work_position_id = wp.id
		LEFT JOIN work_industry wi ON wp.work_industry_id = wi.id
		LEFT JOIN job_offer_employment_type joet ON jo.id = joet.job_offer_id
		LEFT JOIN employment_type et ON et.id = joet.employment_type_id
		WHERE jo.published_until > NOW()
		GROUP BY jo.id
		ORDER BY jo.created_at DESC
		LIMIT 10 OFFSET 0
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
2 1.16 ms 
SELECT COUNT(DISTINCT jo.id)
		FROM job_offer jo
		LEFT JOIN location l ON jo.location_id = l.id
		LEFT JOIN work_position wp ON jo.work_position_id = wp.id
		LEFT JOIN work_industry wi ON wp.work_industry_id = wi.id
		LEFT JOIN job_offer_employment_type joet ON jo.id = joet.job_offer_id
		LEFT JOIN employment_type et ON et.id = joet.employment_type_id
		WHERE jo.published_until > NOW()
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
3 6.70 ms 
SELECT sub.* FROM (
		SELECT '1' AS position, 'region' AS facet, l.region AS value, COUNT(DISTINCT jo.id) AS count
		FROM job_offer jo
		INNER JOIN location l ON jo.location_id = l.id
		LEFT JOIN work_position wp ON jo.work_position_id = wp.id
		LEFT JOIN work_industry wi ON wp.work_industry_id = wi.id
		LEFT JOIN job_offer_employment_type joet ON jo.id = joet.job_offer_id
		LEFT JOIN employment_type et ON et.id = joet.employment_type_id
		WHERE jo.published_until > NOW()
		GROUP BY l.region
	 UNION 
		SELECT '2' AS position, 'work_position' AS facet, wp.name AS value, COUNT(DISTINCT jo.id) AS count
		FROM job_offer jo
		INNER JOIN work_position wp ON wp.id = jo.work_position_id
		LEFT JOIN location l ON jo.location_id = l.id
		LEFT JOIN work_industry wi ON wp.work_industry_id = wi.id
		LEFT JOIN job_offer_employment_type joet ON jo.id = joet.job_offer_id
		LEFT JOIN employment_type et ON et.id = joet.employment_type_id
		WHERE jo.published_until > NOW()
		GROUP BY wp.name
	 UNION 
		SELECT '3' AS position, 'work_industry' AS facet, wi.name AS value, COUNT(DISTINCT jo.id) AS count
		FROM job_offer jo
		INNER JOIN work_position wp ON wp.id = jo.work_position_id
		INNER JOIN work_industry wi ON wp.work_industry_id = wi.id
		LEFT JOIN location l ON jo.location_id = l.id
		LEFT JOIN job_offer_employment_type joet ON jo.id = joet.job_offer_id
		LEFT JOIN employment_type et ON et.id = joet.employment_type_id
		WHERE jo.published_until > NOW()
		GROUP BY wi.name
	 UNION 
		SELECT '4' AS position, 'employment_type' AS facet, et.name AS value, COUNT(DISTINCT jo.id) AS count
		FROM job_offer jo
		INNER JOIN job_offer_employment_type joet ON jo.id = joet.job_offer_id
		INNER JOIN employment_type et ON et.id = joet.employment_type_id
		LEFT JOIN location l ON jo.location_id = l.id
		LEFT JOIN work_position wp ON jo.work_position_id = wp.id
		LEFT JOIN work_industry wi ON wp.work_industry_id = wi.id
		WHERE jo.published_until > NOW()
		GROUP BY et.name
	 UNION 
				SELECT '5' AS position, 'min_salary' AS facet, '600' AS value, COUNT(DISTINCT jo.id) AS count
				FROM job_offer jo
				LEFT JOIN location l ON jo.location_id = l.id
				LEFT JOIN work_position wp ON wp.id = jo.work_position_id
				LEFT JOIN work_industry wi ON wp.work_industry_id = wi.id
				LEFT JOIN job_offer_employment_type joet ON jo.id = joet.job_offer_id
				LEFT JOIN employment_type et ON et.id = joet.employment_type_id
				WHERE jo.published_until > NOW()  AND jo.salary_min >= ?
			 UNION 
				SELECT '5' AS position, 'min_salary' AS facet, '800' AS value, COUNT(DISTINCT jo.id) AS count
				FROM job_offer jo
				LEFT JOIN location l ON jo.location_id = l.id
				LEFT JOIN work_position wp ON wp.id = jo.work_position_id
				LEFT JOIN work_industry wi ON wp.work_industry_id = wi.id
				LEFT JOIN job_offer_employment_type joet ON jo.id = joet.job_offer_id
				LEFT JOIN employment_type et ON et.id = joet.employment_type_id
				WHERE jo.published_until > NOW()  AND jo.salary_min >= ?
			 UNION 
				SELECT '5' AS position, 'min_salary' AS facet, '1000' AS value, COUNT(DISTINCT jo.id) AS count
				FROM job_offer jo
				LEFT JOIN location l ON jo.location_id = l.id
				LEFT JOIN work_position wp ON wp.id = jo.work_position_id
				LEFT JOIN work_industry wi ON wp.work_industry_id = wi.id
				LEFT JOIN job_offer_employment_type joet ON jo.id = joet.job_offer_id
				LEFT JOIN employment_type et ON et.id = joet.employment_type_id
				WHERE jo.published_until > NOW()  AND jo.salary_min >= ?
			 UNION 
				SELECT '5' AS position, 'min_salary' AS facet, '1300' AS value, COUNT(DISTINCT jo.id) AS count
				FROM job_offer jo
				LEFT JOIN location l ON jo.location_id = l.id
				LEFT JOIN work_position wp ON wp.id = jo.work_position_id
				LEFT JOIN work_industry wi ON wp.work_industry_id = wi.id
				LEFT JOIN job_offer_employment_type joet ON jo.id = joet.job_offer_id
				LEFT JOIN employment_type et ON et.id = joet.employment_type_id
				WHERE jo.published_until > NOW()  AND jo.salary_min >= ?
			 UNION 
				SELECT '5' AS position, 'min_salary' AS facet, '1500' AS value, COUNT(DISTINCT jo.id) AS count
				FROM job_offer jo
				LEFT JOIN location l ON jo.location_id = l.id
				LEFT JOIN work_position wp ON wp.id = jo.work_position_id
				LEFT JOIN work_industry wi ON wp.work_industry_id = wi.id
				LEFT JOIN job_offer_employment_type joet ON jo.id = joet.job_offer_id
				LEFT JOIN employment_type et ON et.id = joet.employment_type_id
				WHERE jo.published_until > NOW()  AND jo.salary_min >= ?
			 UNION 
				SELECT '5' AS position, 'min_salary' AS facet, '1800' AS value, COUNT(DISTINCT jo.id) AS count
				FROM job_offer jo
				LEFT JOIN location l ON jo.location_id = l.id
				LEFT JOIN work_position wp ON wp.id = jo.work_position_id
				LEFT JOIN work_industry wi ON wp.work_industry_id = wi.id
				LEFT JOIN job_offer_employment_type joet ON jo.id = joet.job_offer_id
				LEFT JOIN employment_type et ON et.id = joet.employment_type_id
				WHERE jo.published_until > NOW()  AND jo.salary_min >= ?
			 UNION 
				SELECT '5' AS position, 'min_salary' AS facet, '2000' AS value, COUNT(DISTINCT jo.id) AS count
				FROM job_offer jo
				LEFT JOIN location l ON jo.location_id = l.id
				LEFT JOIN work_position wp ON wp.id = jo.work_position_id
				LEFT JOIN work_industry wi ON wp.work_industry_id = wi.id
				LEFT JOIN job_offer_employment_type joet ON jo.id = joet.job_offer_id
				LEFT JOIN employment_type et ON et.id = joet.employment_type_id
				WHERE jo.published_until > NOW()  AND jo.salary_min >= ?
			 UNION 
				SELECT '5' AS position, 'min_salary' AS facet, '2500' AS value, COUNT(DISTINCT jo.id) AS count
				FROM job_offer jo
				LEFT JOIN location l ON jo.location_id = l.id
				LEFT JOIN work_position wp ON wp.id = jo.work_position_id
				LEFT JOIN work_industry wi ON wp.work_industry_id = wi.id
				LEFT JOIN job_offer_employment_type joet ON jo.id = joet.job_offer_id
				LEFT JOIN employment_type et ON et.id = joet.employment_type_id
				WHERE jo.published_until > NOW()  AND jo.salary_min >= ?
			) AS sub ORDER BY position ASC, count DESC
Parameters: 
[
  600
  800
  1000
  1300
  1500
  1800
  2000
  2500
]
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

Entities Mapping

No loaded entities.