https://app.dev.my-flow.fr/user/my-flow/realisation-subcontractor-16

Query Metrics

4 Database Queries
3 Different statements
1.63 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

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.