Query Metrics
4
Database Queries
3
Different statements
1.63 ms
Query time
0
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
0.94 ms (57.45%) |
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.51 ms (31.02%) |
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 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 CASE WHEN p0_.file_category = ? THEN 1 WHEN p0_.file_category = ? THEN 2 WHEN p0_.file_category = ? THEN 3 WHEN p0_.file_category = ? THEN 4 WHEN p0_.file_category = ? THEN 5 WHEN p0_.file_category = ? THEN 6 WHEN p0_.file_category = ? THEN 7 WHEN p0_.file_category = ? THEN 8 WHEN p0_.file_category = ? THEN 9 ELSE 8 END ASC LIMIT 16
Parameters:
[ 1 [ 27 4 12 11 5 21 33 1 20 2 9 28 ] "video" "webm" "embed-link" "image" "url" "audio" "pdf" "pptx" "docx" ] |
0.19 ms (11.53%) |
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
]
|
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 |
---|---|
App\Entity\Message | No errors. |
App\Entity\Company | No errors. |
App\Entity\Campaign | No errors. |
App\Entity\User | No errors. |
App\Entity\Mission | No errors. |
App\Entity\MissionParticipant | No errors. |
App\Entity\WorkflowStep | No errors. |
App\Entity\CreditHistory | No errors. |
App\Entity\CommandeLogging | No errors. |
App\Entity\NotificationToSend | No errors. |
App\Entity\ConfidentialityContract | No errors. |
App\Entity\CampaignPendingToSend | No errors. |
App\Entity\SystemEmail | No errors. |
App\Entity\BalanceTransactions | No errors. |
App\Entity\Service | No errors. |
App\Entity\Historique | No errors. |
App\Entity\SubContractorCompany | No errors. |
App\Entity\Job | No errors. |
App\Entity\CompanyData | No errors. |
App\Entity\Portfolio | No errors. |