Query Metrics
5
Database Queries
5
Different statements
3.19 ms
Query time
0
Invalid entities
9
Managed entities
Queries
#▲ | Time | Info |
---|---|---|
1 | 1.01 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.start_date AS start_date_4, t0.end_date AS end_date_5, t0.discount AS discount_6, t0.linear_badge AS linear_badge_7, t0.linear_badge_color AS linear_badge_color_8, t0.round_badge AS round_badge_9, t0.round_badge_color AS round_badge_color_10, t0.ribbon_badge AS ribbon_badge_11, t0.ribbon_badge_color AS ribbon_badge_color_12, t0.created_at AS created_at_13, t0.deleted_at AS deleted_at_14, t0.publishing_status AS publishing_status_15 FROM campaign t0 WHERE t0.deleted_at IS NULL AND t0.publishing_status = ?
Parameters:
[
"published"
]
|
2 | 0.63 ms |
SELECT t0.id AS id_1, t0.brand_name AS brand_name_2, t0.brand_slug AS brand_slug_3, t0.model_name AS model_name_4, t0.model_slug AS model_slug_5, t0.version AS version_6, t0.doors AS doors_7, t0.gearbox AS gearbox_8, t0.gearbox_slug AS gearbox_slug_9, t0.power_hp AS power_hp_10, t0.power_kw AS power_kw_11, t0.category_name AS category_name_12, t0.category_slug AS category_slug_13, t0.convertible_to_truck AS convertible_to_truck_14, t0.new_driver AS new_driver_15, t0.private AS private_16, t0.business AS business_17, t0.fleet AS fleet_18, t0.emission AS emission_19, t0.fuel_name AS fuel_name_20, t0.fuel_slug AS fuel_slug_21, t0.displacement AS displacement_22, t0.drive AS drive_23, t0.average_consumption AS average_consumption_24, t0.video_id AS video_id_25, t0.priority AS priority_26, t0.ready_to_deliver AS ready_to_deliver_27, t0.adv AS adv_28, t0.featured AS featured_29, t0.linear_badge AS linear_badge_30, t0.linear_badge_color AS linear_badge_color_31, t0.round_badge AS round_badge_32, t0.round_badge_color AS round_badge_color_33, t0.ribbon_badge AS ribbon_badge_34, t0.ribbon_badge_color AS ribbon_badge_color_35, t0.legal_rca_limit AS legal_rca_limit_36, t0.legal_rca_excess AS legal_rca_excess_37, t0.legal_theft_excess AS legal_theft_excess_38, t0.legal_kasko_excess AS legal_kasko_excess_39, t0.legal_accident_limit AS legal_accident_limit_40, t0.legal_accident_excess AS legal_accident_excess_41, t0.sizes AS sizes_42, t0.capacity AS capacity_43, t0.seats AS seats_44, t0.created_at AS created_at_45, t0.deleted_at AS deleted_at_46, t0.publishing_status AS publishing_status_47, t0.first_price_id AS first_price_id_48 FROM proposal t0 WHERE t0.id = ? AND t0.deleted_at IS NULL LIMIT 1
Parameters:
[
"2bd388e8-c3d1-4bb5-8952-44ef33c0b26e"
]
|
3 | 0.61 ms |
SELECT t0.id AS id_1, t0.code AS code_2, t0.alt AS alt_3, t0.src AS src_4, t0.original_src AS original_src_5, t0.ordering AS ordering_6, t0.published AS published_7, t0.proposal_id AS proposal_id_8 FROM proposal_image t0 WHERE t0.proposal_id IN (?) ORDER BY t0.ordering ASC
Parameters:
[
"2bd388e8-c3d1-4bb5-8952-44ef33c0b26e"
]
|
4 | 0.36 ms |
SELECT t0.id AS id_1, t0.price AS price_2, t0.deposit AS deposit_3, t0.duration AS duration_4, t0.distance AS distance_5, t0.proposal_id AS proposal_id_6 FROM proposal_price t0 WHERE t0.proposal_id IN (?) ORDER BY t0.price ASC
Parameters:
[
"2bd388e8-c3d1-4bb5-8952-44ef33c0b26e"
]
|
5 | 0.57 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.active AS active_4, t0.created_at AS created_at_5, t0.deleted_at AS deleted_at_6, t0.publishing_status AS publishing_status_7 FROM branding t0 WHERE t0.active = ? AND t0.deleted_at IS NULL AND t0.publishing_status = ? LIMIT 1
Parameters:
[ 1 "published" ] |
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\Domain\Proposal\Entity\ProposalImage | 6 |
App\Domain\Proposal\Entity\ProposalPrice | 2 |
App\Domain\Proposal\Entity\Proposal | 1 |
Entities Mapping
Class | Mapping errors |
---|---|
App\Domain\Proposal\Entity\Proposal | No errors. |
App\Domain\Campaign\Entity\Campaign | No errors. |
App\Domain\Proposal\Entity\ProposalImage | No errors. |
App\Domain\Proposal\Entity\ProposalPrice | No errors. |
App\Domain\Branding\Entity\Branding | No errors. |