Query Metrics
10
Database Queries
8
Different statements
5.08 ms
Query time
0
Invalid entities
85
Managed entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
0.96 ms (18.83%) |
3 |
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" ] |
|
0.87 ms (17.24%) |
1 |
SELECT t0.id AS id_1, t0.title AS title_2, t0.seo_title AS seo_title_3, t0.permalink AS permalink_4, t0.content AS content_5, t0.content_title AS content_title_6, t0.secondary_content AS secondary_content_7, t0.secondary_content_title AS secondary_content_title_8, t0.brand AS brand_9, t0.model AS model_10, t0.video_id AS video_id_11, t0.search_link AS search_link_12, t0.created_at AS created_at_13, t0.deleted_at AS deleted_at_14, t0.publishing_status AS publishing_status_15 FROM page t0 WHERE t0.publishing_status = ? AND t0.deleted_at IS NULL ORDER BY t0.created_at DESC
Parameters:
[
"published"
]
|
|
0.77 ms (15.25%) |
1 |
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"
]
|
|
0.63 ms (12.41%) |
1 |
SELECT * FROM read_proposal_list WHERE fastDelivery = ? ORDER BY installment ASC
Parameters:
[
"1"
]
|
|
0.60 ms (11.90%) |
1 |
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.page_id AS page_id_8 FROM page_image t0 WHERE t0.page_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY t0.ordering ASC
Parameters:
[ "75250492-d0ca-4a3d-b5bd-55baa31159ce" "d3a140f1-2dc3-4780-b75b-d4e4ec8800e4" "d4d30211-19be-40ae-97e1-2efcc8eb0e06" "983f47f1-f724-4506-abd2-c1f185ee6c1f" "370b3b2f-16d4-4fa6-80ee-80fb12ecee54" "7f4da4d5-d21a-4ca2-a5cb-4bcb13ff9809" "aa365749-a040-4299-b699-ed31e96cc778" "ea13d083-fc14-4bf7-8c47-5312b5dd1d5e" "d514757d-75a6-4319-ac33-dc4f912922df" "f6b3bf04-75f3-4145-bd32-d565f2e24cc8" "fdb4989d-41e1-4954-8a89-dff9c9637163" "ba23ec27-f37e-41e1-acde-e09265ada9f7" "95db1ac7-6560-4f8a-a275-5db7c6498604" "74ade17e-6f67-4e1c-a61d-9c60adcd39a6" "b4a479c5-9d30-4bdb-b351-4ec823ef8551" "363ffeda-f066-49ac-b57e-d86ea41a7b7f" "9e5b97e6-d789-49f9-b3f3-c0de22cb7cb9" "d7be5b19-507b-4b4e-8652-08ae01496d20" "d6e73116-13d5-4e6f-8248-12c75a37db73" "d2fbffc8-76fd-4551-87b9-193957e314d4" "9f6ccc0d-aa2a-441d-9d04-44dc119e56f1" "d035df59-f034-4492-aa16-33a2bb657d75" "86ba3f79-167f-4910-b114-5813b64e8a2e" "fb62e57c-d5f4-464b-8b22-4f1052e61cf4" "9c7a1e49-55f7-4ed5-ab9a-3ea7b6f849c3" "0d9f2c28-0925-4052-8598-f4af91e503e3" "558b48f2-1164-4223-9d4b-0a78912c5c49" "ad446648-e2e5-450c-8d63-213a4a0a002f" "081f3386-7bdf-4476-978d-56c86af3e9b4" "25225f70-6715-4782-bab1-43768fd57ea3" "e93ce1c3-c337-497f-89d1-c5f4de4b730f" "27682452-2d7a-4b58-ae8d-80bd28367a5f" "ee6d4f82-c7bd-423b-849b-00497bb1c7da" "594204f3-6f44-4add-ba9c-2624c7e38334" "817c3038-9d36-404b-9cc0-fa948b385396" "691c982d-2dca-42eb-bfa8-68cb903674f1" "a529e593-c816-47e4-b5d7-2db06afdd30c" "137f31f5-01c9-42f3-b2fa-487907decb5e" ] |
|
0.55 ms (10.85%) |
1 |
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, t0.permalink AS permalink_49 FROM proposal t0 WHERE t0.id = ? AND t0.deleted_at IS NULL LIMIT 1
Parameters:
[
"c66e5c05-dcaa-4877-aa68-2e3162f0b04a"
]
|
|
0.41 ms (8.02%) |
1 |
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:
[
"c66e5c05-dcaa-4877-aa68-2e3162f0b04a"
]
|
|
0.28 ms (5.50%) |
1 |
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:
[
"c66e5c05-dcaa-4877-aa68-2e3162f0b04a"
]
|
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\Page\Entity\Page | 38 |
| App\Domain\Page\Entity\PageImage | 38 |
| App\Domain\Proposal\Entity\ProposalImage | 4 |
| App\Domain\Proposal\Entity\ProposalPrice | 4 |
| 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. |
| App\Domain\Campaign\Entity\CampaignBanner | No errors. |
| App\Domain\Campaign\Entity\CampaignProposal | No errors. |
| App\Domain\Branding\Entity\BrandingBanner | No errors. |
| App\Domain\Page\Entity\Page | No errors. |
| App\Domain\Page\Entity\PageImage | No errors. |