Query Metrics
4
Database Queries
3
Different statements
1.28 ms
Query time
2
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
0.75 ms (58.64%) |
2 |
SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.domaine_name AS domaine_name_2, c0_.email_project AS email_project_3, c0_.mdp_email_project AS mdp_email_project_4, c0_.marge_my_flow AS marge_my_flow_5, c0_.logo_name AS logo_name_6, c0_.favicon_name AS favicon_name_7, c0_.enabled AS enabled_8, c0_.type_company AS type_company_9, c0_.cb_payment AS cb_payment_10, c0_.contract AS contract_11, c0_.customer_discount AS customer_discount_12, c0_.default_credit_cost AS default_credit_cost_13, c0_.cost_of_discounted_credit AS cost_of_discounted_credit_14, c0_.created_at AS created_at_15, c0_.updated_at AS updated_at_16, c0_.siren AS siren_17, c0_.front_id AS front_id_18, c0_.current_credit AS current_credit_19, c0_.current_balance AS current_balance_20, c0_.deleted AS deleted_21, c0_.link_my_flow_confidentiality_commitment AS link_my_flow_confidentiality_commitment_22, c0_.extension_domain AS extension_domain_23, c0_.parent_id AS parent_id_24, c0_.company_data_id AS company_data_id_25, c0_.representative_id AS representative_id_26 FROM companies c0_ WHERE c0_.domaine_name LIKE ?
Parameters:
[
"%app.dev.my-flow.fr%"
]
|
0.29 ms (22.44%) |
1 |
SELECT p0_.id AS id_0 FROM portfolio p0_ LEFT JOIN users u1_ ON p0_.user_id = u1_.id WHERE u1_.accept_presentation = ? AND p0_.file_category = 'image'
Parameters:
[
1
]
|
0.24 ms (18.92%) |
1 |
SELECT p0_.id AS id_0, p0_.file_category AS file_category_1, p0_.thumbnail AS thumbnail_2, p0_.file_url AS file_url_3, p0_.client_logo AS client_logo_4, p0_.is_new AS is_new_5 FROM portfolio p0_ LEFT JOIN users u1_ ON p0_.user_id = u1_.id WHERE ((u1_.accept_presentation = ? AND p0_.file_category = 'image') OR p0_.file_category = 'video' OR p0_.file_category = 'webm' OR p0_.file_category = 'embed-link') AND p0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY p0_.id DESC LIMIT 16
Parameters:
[ 1 22 21 9 5 33 1 4 17 20 51 11 7 ] |
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 |
---|