Query Metrics
11
Database Queries
7
Different statements
5.05 ms
Query time
0
Invalid entities
76
Managed entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 0.98 ms |
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.model = ? AND t0.brand = ? AND t0.deleted_at IS NULL LIMIT 1
Parameters:
[ "c3" "CIT" ] |
| 2 | 0.34 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.page_id AS page_id_8 FROM page_image t0 WHERE t0.page_id IN (?) ORDER BY t0.ordering ASC
Parameters:
[
"d2fbffc8-76fd-4551-87b9-193957e314d4"
]
|
| 3 | 0.42 ms |
SELECT * FROM read_proposal_list WHERE (brandSlug IN ('CIT')) AND (modelSlug IN ('C3')) ORDER BY installment ASC
Parameters:
[] |
| 4 | 0.39 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"
]
|
| 5 | 0.24 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" ] |
| 6 | 0.23 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" ] |
| 7 | 0.26 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" ] |
| 8 | 0.23 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" ] |
| 9 | 0.96 ms |
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"
]
|
| 10 | 0.66 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.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" "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" ] |
| 11 | 0.33 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\Page\Entity\Page | 38 |
| App\Domain\Page\Entity\PageImage | 38 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Domain\Page\Entity\Page | No errors. |
| App\Domain\Page\Entity\PageImage | No errors. |
| App\Domain\Campaign\Entity\Campaign | No errors. |
| App\Domain\Proposal\Entity\Proposal | 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\Proposal\Entity\ProposalImage | No errors. |
| App\Domain\Proposal\Entity\ProposalPrice | No errors. |
| App\Domain\Branding\Entity\BrandingBanner | No errors. |