Query Metrics
7
Database Queries
5
Different statements
3.69 ms
Query time
0
Invalid entities
7
Managed entities
Queries
default connection
| #▲ | Time | Info | ||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 1.20 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.url AS url_3, t0.api_key AS api_key_4, t0.auth_token AS auth_token_5, t0.headers AS headers_6, t0.timeout AS timeout_7, t0.max_retry_attempts AS max_retry_attempts_8, t0.retry_interval AS retry_interval_9, t0.request_parameters AS request_parameters_10, t0.response_mapping AS response_mapping_11, t0.endpoint AS endpoint_12 FROM api_configuration t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
"CodeIgniterFetch"
]
|
||||||||||||||||||||||||||||
| 2 | 0.43 ms |
SELECT t0.encryption AS encryption_1, t0.id AS id_2, t0.name AS name_3, t0.maintenance AS maintenance_4, t0.address AS address_5, t0.office_ip_address AS office_ip_address_6, t0.postal_code AS postal_code_7, t0.city AS city_8, t0.email AS email_9, t0.email_password AS email_password_10, t0.email_port AS email_port_11, t0.email_smtp AS email_smtp_12, t0.password_reset_days AS password_reset_days_13, t0.has_password_reset AS has_password_reset_14, t0.phone AS phone_15, t0.helpdesk AS helpdesk_16, t0.meta_keywords AS meta_keywords_17, t0.meta_description AS meta_description_18, t0.fiscal_number AS fiscal_number_19, t0.domain AS domain_20, t0.file AS file_21, t0.coords_google_maps AS coords_google_maps_22, t0.profit_margin AS profit_margin_23, t0.first_tag_head AS first_tag_head_24, t0.first_tag_body AS first_tag_body_25, t0.last_tag_head AS last_tag_head_26, t0.license AS license_27, t0.booking_hours_advance AS booking_hours_advance_28, t0.commercial_registry_office AS commercial_registry_office_29, t0.expire_payment AS expire_payment_30 FROM company t0 LIMIT 1
Parameters:
[] |
||||||||||||||||||||||||||||
| 3 | 0.53 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.url AS url_3, t0.api_key AS api_key_4, t0.auth_token AS auth_token_5, t0.headers AS headers_6, t0.timeout AS timeout_7, t0.max_retry_attempts AS max_retry_attempts_8, t0.retry_interval AS retry_interval_9, t0.request_parameters AS request_parameters_10, t0.response_mapping AS response_mapping_11, t0.endpoint AS endpoint_12 FROM api_configuration t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
"Stripe"
]
|
||||||||||||||||||||||||||||
| 4 | 0.52 ms |
SELECT t0.encryption AS encryption_1, t0.id AS id_2, t0.name AS name_3, t0.maintenance AS maintenance_4, t0.address AS address_5, t0.office_ip_address AS office_ip_address_6, t0.postal_code AS postal_code_7, t0.city AS city_8, t0.email AS email_9, t0.email_password AS email_password_10, t0.email_port AS email_port_11, t0.email_smtp AS email_smtp_12, t0.password_reset_days AS password_reset_days_13, t0.has_password_reset AS has_password_reset_14, t0.phone AS phone_15, t0.helpdesk AS helpdesk_16, t0.meta_keywords AS meta_keywords_17, t0.meta_description AS meta_description_18, t0.fiscal_number AS fiscal_number_19, t0.domain AS domain_20, t0.file AS file_21, t0.coords_google_maps AS coords_google_maps_22, t0.profit_margin AS profit_margin_23, t0.first_tag_head AS first_tag_head_24, t0.first_tag_body AS first_tag_body_25, t0.last_tag_head AS last_tag_head_26, t0.license AS license_27, t0.booking_hours_advance AS booking_hours_advance_28, t0.commercial_registry_office AS commercial_registry_office_29, t0.expire_payment AS expire_payment_30 FROM company t0 LIMIT 1
Parameters:
[]
|
||||||||||||||||||||||||||||
| 5 | 0.25 ms |
SELECT t0.id AS id_1, t0.is_active AS is_active_2, t0.name AS name_3, t0.url AS url_4, t0.icon AS icon_5 FROM social_network t0 WHERE t0.is_active = ?
Parameters:
[
1
]
|
||||||||||||||||||||||||||||
| 6 | 0.45 ms |
SELECT w0_.id AS id_0, w0_.name AS name_1, w0_.html AS html_2, w0_.locale_id AS locale_id_3, w0_.warning_id AS warning_id_4 FROM warning_translation w0_ LEFT JOIN locale l1_ ON w0_.locale_id = l1_.id LEFT JOIN warning w2_ ON w0_.warning_id = w2_.id WHERE (w2_.is_active = ? OR w2_.id IS NULL) AND l1_.name = ? AND w2_.is_public = ? LIMIT 1
Parameters:
[ 1 "en" 1 ]
|
||||||||||||||||||||||||||||
| 7 | 0.29 ms |
SELECT p0_.id AS id_0, p0_.is_active AS is_active_1, p0_.is_mobile_active AS is_mobile_active_2, p0_.file AS file_3, p0_.position AS position_4, p0_.file_in_banner AS file_in_banner_5, p0_.page_id AS page_id_6 FROM page_template p0_ INNER JOIN page p1_ ON p0_.page_id = p1_.id WHERE p1_.is_active = ? AND p0_.is_active = ? AND p1_.reference = ? AND p1_.is_public = ? ORDER BY p0_.position ASC
Parameters:
[ 1 1 "p.php" 1 ]
|
Database Connections
| Name | Service |
|---|---|
| default | doctrine.dbal.default_connection |
| log | doctrine.dbal.log_connection |
Entity Managers
| Name | Service |
|---|---|
| naming_strategy | doctrine.orm.naming_strategy_entity_manager |
| default | doctrine.orm.default_entity_manager |
| log | doctrine.orm.log_entity_manager |
Second Level Cache
Second Level Cache is not enabled.
Managed Entities
naming_strategy entity manager
| Class | Amount of managed objects |
|---|
default entity manager
| Class | Amount of managed objects |
|---|---|
| App\Entity\SocialNetwork | 4 |
| App\Entity\ApiConfiguration | 2 |
| App\Entity\Company | 1 |
log entity manager
| Class | Amount of managed objects |
|---|
Entities Mapping
naming_strategy entity manager
No loaded entities.
default entity manager
| Class | Mapping errors |
|---|---|
| App\Entity\ApiConfiguration | No errors. |
| App\Entity\Company | No errors. |
| App\Entity\SocialNetwork | No errors. |
| App\Entity\WarningTranslation | No errors. |
| App\Entity\Locale | No errors. |
| App\Entity\Warning | No errors. |
| App\Entity\PageTemplate | No errors. |
| App\Entity\Page | No errors. |
| App\Entity\PageTemplateTranslation | No errors. |
log entity manager
No loaded entities.