Query Metrics
2
Database Queries
2
Different statements
4.53 ms
Query time
1
Invalid entities
Grouped Statements
Time▼ | Count | Info | ||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3.79 ms (83.69%) |
1 |
SELECT j0_.id AS id_0, j0_.title AS title_1, j0_.slug AS slug_2, j0_.description AS description_3, j0_.location AS location_4, j0_.employment_type AS employment_type_5, j0_.route_type AS route_type_6, j0_.requirements AS requirements_7, j0_.required_endorsements AS required_endorsements_8, j0_.salary AS salary_9, j0_.is_active AS is_active_10, j0_.expires_at AS expires_at_11, j0_.custom_questions AS custom_questions_12, j0_.video_url AS video_url_13, j0_.parsed_video_embed AS parsed_video_embed_14, j0_.radius AS radius_15, j0_.minimum_experience AS minimum_experience_16, j0_.pay_range AS pay_range_17, j0_.created_at AS created_at_18, j0_.updated_at AS updated_at_19, j0_.company_id AS company_id_20 FROM job_posting j0_ WHERE j0_.is_active = ? AND (j0_.expires_at > ? OR j0_.expires_at IS NULL) ORDER BY j0_.created_at DESC LIMIT 6
Parameters:
[ 1 "2025-06-07 10:49:57" ]
|
||||||||||||||||||||||||||
0.74 ms (16.31%) |
1 |
SELECT t0.id AS id_1, t0.company_name AS company_name_2, t0.description AS description_3, t0.website AS website_4, t0.address AS address_5, t0.city AS city_6, t0.state AS state_7, t0.zip_code AS zip_code_8, t0.phone AS phone_9, t0.is_verified AS is_verified_10, t0.is_profile_complete AS is_profile_complete_11, t0.company_size AS company_size_12, t0.status AS status_13, t0.created_at AS created_at_14, t0.last_activity_at AS last_activity_at_15, t0.activity_metrics AS activity_metrics_16, t0.integration_statuses AS integration_statuses_17, t0.owner_id AS owner_id_18 FROM company t0 WHERE t0.id = ?
Parameters:
[
1
]
|
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\JobPosting | No errors. |
App\Entity\Company | No errors. |
App\Entity\JobApplication |
|
App\Entity\User | No errors. |