Query Metrics
3
Database Queries
3
Different statements
18.54 ms
Query time
0
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
13.89 ms (74.92%) |
1 |
SELECT t0.expiration AS expiration_1, t0.ready AS ready_2, t0.error AS error_3, t0.id AS id_4, t0.uid AS uid_5, t0.createdAt AS createdAt_6, t0.updatedAt AS updatedAt_7, t0.touchedAt AS touchedAt_8, t0.data_privateKey AS data_privateKey_9, t0.data_intermediateCertificates AS data_intermediateCertificates_10, t0.data_certficate AS data_certficate_11, t0.data_certificateSigningRequest AS data_certificateSigningRequest_12, t0.domain AS domain_13, t0.tenant AS tenant_14, t0.createdBy AS createdBy_15, t0.updatedBy AS updatedBy_16, t0.touchedBy AS touchedBy_17, t0._discr, t0.csr_email AS csr_email_18, t0.csr_organization AS csr_organization_19, t0.csr_unit AS csr_unit_20, t0.csr_country AS csr_country_21, t0.csr_province AS csr_province_22, t0.csr_locality AS csr_locality_23, t0.le_challenge AS le_challenge_24, t0.le_token AS le_token_25, t0.le_payload AS le_payload_26 FROM cms__domain__ssl_certificate t0 WHERE t0.id = ? AND t0._discr IN ('custom', 'lets-encrypt')
Parameters:
[
5
]
|
3.87 ms (20.90%) |
1 |
SELECT c0_.name AS name_0, c0_.httpsUpgrade AS httpsUpgrade_1, c0_.id AS id_2, c0_.uid AS uid_3, c0_.createdAt AS createdAt_4, c0_.updatedAt AS updatedAt_5, c0_.touchedAt AS touchedAt_6, c0_.dnsLookupAt AS dnsLookupAt_7, c0_.dnsLookupResult AS dnsLookupResult_8, c0_.redirection_enabled AS redirection_enabled_9, c0_.redirection_host AS redirection_host_10, c0_.redirection_path AS redirection_path_11, c0_.redirection_appendPath AS redirection_appendPath_12, c0_.redirection_query AS redirection_query_13, c0_.redirection_appendQuery AS redirection_appendQuery_14, c0_.redirection_code AS redirection_code_15, c0_.apex AS apex_16, c0_.certificate AS certificate_17, c0_.tenant AS tenant_18, c0_.createdBy AS createdBy_19, c0_.updatedBy AS updatedBy_20, c0_.touchedBy AS touchedBy_21 FROM cms__domain__domain c0_ LEFT JOIN cms__domain__apex c1_ ON c0_.apex = c1_.id WHERE (c0_.name = ? AND c1_.host = ?) OR (c0_.name = ? AND c1_.host = ?) LIMIT 1
Parameters:
[ "" "campusstein.com" "campusstein" "com" ] |
0.77 ms (4.18%) |
1 |
SELECT t0.host AS host_1, t0.id AS id_2, t0.uid AS uid_3, t0.createdAt AS createdAt_4, t0.updatedAt AS updatedAt_5, t0.touchedAt AS touchedAt_6, t0.dnsLookupAt AS dnsLookupAt_7, t0.dnsLookupResult AS dnsLookupResult_8, t0.verification_code AS verification_code_9, t0.verification_date AS verification_date_10, t0.tenant AS tenant_11, t0.createdBy AS createdBy_12, t0.updatedBy AS updatedBy_13, t0.touchedBy AS touchedBy_14 FROM cms__domain__apex t0 WHERE t0.id = ? AND ((t0.tenant = 7))
Parameters:
[
3
]
|
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 |
---|---|
Cms\DomainBundle\Entity\Domain | No errors. |
Cms\DomainBundle\Entity\Apex | No errors. |
Cms\DomainBundle\Entity\SslCertificate | No errors. |
Cms\TenantBundle\Entity\Tenant | No errors. |
Platform\SecurityBundle\Entity\Identity\Account | No errors. |
Cms\DomainBundle\Entity\SslCertificates\CustomSslCertificate | No errors. |
Cms\DomainBundle\Entity\SslCertificates\LetsEncryptSslCertificate | No errors. |