Query Metrics
1
Database Queries
1
Different statements
70.45 ms
Query time
0
Invalid entities
Queries
default connection
| #▲ | Time | Info |
|---|---|---|
| 1 | 70.45 ms |
SELECT i0_.id AS id_0, i0_.created_at AS created_at_1, i0_.updated_at AS updated_at_2, i0_.user_id AS user_id_3, i0_.`from` AS from_4, i0_.`to` AS to_5, u1_.id AS id_6, u1_.login_at AS login_at_7, u1_.password_at AS password_at_8, u1_.activation_at AS activation_at_9, u1_.username_at AS username_at_10, u1_.password_token AS password_token_11, u1_.password_token_created_at AS password_token_created_at_12, u1_.activation_token AS activation_token_13, u1_.username_token AS username_token_14, u1_.source AS source_15, u1_.role AS role_16, u1_.roles AS roles_17, u1_.company_id AS company_id_18, u1_.manager AS manager_19, u1_.username AS username_20, u1_.hash AS hash_21, u1_.name AS name_22, u1_.salutation AS salutation_23, u1_.firstname AS firstname_24, u1_.lastname_prefix AS lastname_prefix_25, u1_.lastname AS lastname_26, u1_.initials AS initials_27, u1_.sex AS sex_28, u1_.job AS job_29, u1_.username_change AS username_change_30, u1_.migrated_id AS migrated_id_31, u1_.deleted_at AS deleted_at_32, u1_.created_at AS created_at_33, u1_.updated_at AS updated_at_34, c2_.id AS id_35, c2_.created_at AS created_at_36, c2_.updated_at AS updated_at_37, c2_.source AS source_38, c2_.name AS name_39, c2_.street AS street_40, c2_.housenumber AS housenumber_41, c2_.zipcode AS zipcode_42, c2_.city AS city_43, c2_.telephone AS telephone_44, c2_.fax AS fax_45, c2_.customernumber AS customernumber_46, c2_.ordernumber AS ordernumber_47, c2_.vatnumber AS vatnumber_48, c2_.couponcode AS couponcode_49, c2_.invoice AS invoice_50, c2_.invoice_street AS invoice_street_51, c2_.invoice_housenumber AS invoice_housenumber_52, c2_.invoice_zipcode AS invoice_zipcode_53, c2_.invoice_city AS invoice_city_54, c2_.license_product AS license_product_55, c2_.license_amount AS license_amount_56, c2_.license_price AS license_price_57, c2_.license_caption AS license_caption_58, c2_.license_starts_at AS license_starts_at_59, c2_.license_ends_at AS license_ends_at_60, c2_.license_trial AS license_trial_61, c2_.license_upgrade AS license_upgrade_62, c2_.license_testing AS license_testing_63, c2_.license_code AS license_code_64, c2_.license_type AS license_type_65, c2_.contractnumber AS contractnumber_66, c2_.remarks AS remarks_67, c2_.edit_token AS edit_token_68, c2_.migrated_id AS migrated_id_69, c2_.deleted_at AS deleted_at_70, c2_.logo_file_name AS logo_file_name_71, c2_.logo_file_original_name AS logo_file_original_name_72, c2_.logo_file_mime_type AS logo_file_mime_type_73, c2_.logo_file_size AS logo_file_size_74, c2_.logo_file_dimensions AS logo_file_dimensions_75, i0_.user_id AS user_id_76, u1_.company_id AS company_id_77 FROM ips i0_ INNER JOIN users u1_ ON i0_.user_id = u1_.id AND (u1_.deleted_at IS NULL) INNER JOIN companies c2_ ON u1_.company_id = c2_.id AND (c2_.deleted_at IS NULL) WHERE i0_.`from` <= 3628718223 AND i0_.`to` >= 3628718223 LIMIT 1
Parameters:
[] |
old connection
No database queries were performed.
Database Connections
| Name | Service |
|---|---|
| default | doctrine.dbal.default_connection |
| old | doctrine.dbal.old_connection |
Entity Managers
| Name | Service |
|---|---|
| default | doctrine.orm.default_entity_manager |
| old | doctrine.orm.old_entity_manager |
Second Level Cache
Second Level Cache is not enabled.
Entities Mapping
default entity manager
| Class | Mapping errors |
|---|---|
| Nen\Bundle\KennisbankPlatformBundle\Entity\User | No errors. |
| App\Entity\User | No errors. |
| App\Entity\Questionnaire | No errors. |
| Nen\Bundle\KennisbankPlatformBundle\Entity\Ip | No errors. |
| Nen\Bundle\KennisbankPlatformBundle\Entity\Company | No errors. |
| Vich\UploaderBundle\Entity\File | No errors. |
| App\Entity\Company | No errors. |
| Nen\Bundle\KennisbankPlatformBundle\Entity\Bolt\BoltEntity | No errors. |
| Nen\Bundle\KennisbankPlatformBundle\Entity\BoltPage | No errors. |
| App\Entity\Respondent | No errors. |
| Nen\Bundle\KennisbankPlatformBundle\Entity\BoltSettings | No errors. |
| Nen\Bundle\KennisbankPlatformBundle\Entity\BoltSnippet | No errors. |
| Nen\Bundle\KennisbankPlatformBundle\Entity\BoltPublication | No errors. |
| Nen\Bundle\KennisbankPlatformBundle\Entity\BoltBlock | No errors. |
| Nen\Bundle\QuestionnaireBundle\Entity\QuestionnaireRespondent | No errors. |
| Nen\Bundle\QuestionnaireBundle\Entity\Explanation | No errors. |
| Nen\Bundle\QuestionnaireBundle\Entity\CompanyQuestionExplanation | No errors. |
old entity manager
No loaded entities.