Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

4 Database Queries

2 Different statements

1.58 ms Query time

3 Invalid entities

Grouped Statements

Show all queries

Time▼	Count	Info
1.26 ms (79.69%)	3	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%"`] View formatted query View runnable query Explain query 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 ? 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 '%app.dev.my-flow.fr%';
0.32 ms (20.31%)	1	SELECT t0.id AS id_1, t0.content AS content_2, t0.created_at AS created_at_3, t0.user_list_who_read AS user_list_who_read_4, t0.origin AS origin_5, t0.reply_to AS reply_to_6, t0.original_content AS original_content_7, t0.is_deleted AS is_deleted_8, t0.insert_pinned AS insert_pinned_9, t0.is_modified AS is_modified_10, t0.platform AS platform_11, t0.user_id AS user_id_12, t0.campaign_id AS campaign_id_13, t0.mission_id AS mission_id_14, t0.discussion_group_id AS discussion_group_id_15 FROM messages t0 WHERE t0.id = ? Parameters: [`"undefined"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.content AS content_2, t0.created_at AS created_at_3, t0.user_list_who_read AS user_list_who_read_4, t0.origin AS origin_5, t0.reply_to AS reply_to_6, t0.original_content AS original_content_7, t0.is_deleted AS is_deleted_8, t0.insert_pinned AS insert_pinned_9, t0.is_modified AS is_modified_10, t0.platform AS platform_11, t0.user_id AS user_id_12, t0.campaign_id AS campaign_id_13, t0.mission_id AS mission_id_14, t0.discussion_group_id AS discussion_group_id_15 FROM messages t0 WHERE t0.id = ? SELECT t0.id AS id_1, t0.content AS content_2, t0.created_at AS created_at_3, t0.user_list_who_read AS user_list_who_read_4, t0.origin AS origin_5, t0.reply_to AS reply_to_6, t0.original_content AS original_content_7, t0.is_deleted AS is_deleted_8, t0.insert_pinned AS insert_pinned_9, t0.is_modified AS is_modified_10, t0.platform AS platform_11, t0.user_id AS user_id_12, t0.campaign_id AS campaign_id_13, t0.mission_id AS mission_id_14, t0.discussion_group_id AS discussion_group_id_15 FROM messages t0 WHERE t0.id = 'undefined';

Time▼

Count

Info

1.26 ms
(79.69%)

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%"
]

View formatted query View runnable query Explain query

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 ?

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 '%app.dev.my-flow.fr%';

0.32 ms
(20.31%)

SELECT t0.id AS id_1, t0.content AS content_2, t0.created_at AS created_at_3, t0.user_list_who_read AS user_list_who_read_4, t0.origin AS origin_5, t0.reply_to AS reply_to_6, t0.original_content AS original_content_7, t0.is_deleted AS is_deleted_8, t0.insert_pinned AS insert_pinned_9, t0.is_modified AS is_modified_10, t0.platform AS platform_11, t0.user_id AS user_id_12, t0.campaign_id AS campaign_id_13, t0.mission_id AS mission_id_14, t0.discussion_group_id AS discussion_group_id_15 FROM messages t0 WHERE t0.id = ?

Parameters:

[
  "undefined"
]

View formatted query View runnable query Explain query

SELECT
  t0.id AS id_1,
  t0.content AS content_2,
  t0.created_at AS created_at_3,
  t0.user_list_who_read AS user_list_who_read_4,
  t0.origin AS origin_5,
  t0.reply_to AS reply_to_6,
  t0.original_content AS original_content_7,
  t0.is_deleted AS is_deleted_8,
  t0.insert_pinned AS insert_pinned_9,
  t0.is_modified AS is_modified_10,
  t0.platform AS platform_11,
  t0.user_id AS user_id_12,
  t0.campaign_id AS campaign_id_13,
  t0.mission_id AS mission_id_14,
  t0.discussion_group_id AS discussion_group_id_15
FROM
  messages t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.content AS content_2, t0.created_at AS created_at_3, t0.user_list_who_read AS user_list_who_read_4, t0.origin AS origin_5, t0.reply_to AS reply_to_6, t0.original_content AS original_content_7, t0.is_deleted AS is_deleted_8, t0.insert_pinned AS insert_pinned_9, t0.is_modified AS is_modified_10, t0.platform AS platform_11, t0.user_id AS user_id_12, t0.campaign_id AS campaign_id_13, t0.mission_id AS mission_id_14, t0.discussion_group_id AS discussion_group_id_15 FROM messages t0 WHERE t0.id = 'undefined';

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

array:3 [
  "App\Entity\Company" => array:1 [
    0 => "The field 'App\Entity\Company#currentBalance' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type."
  ]
  "App\Entity\User" => array:2 [
    0 => "The field 'App\Entity\User#dailyRate' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type."
    1 => "The field 'App\Entity\User#resaleRate' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type."
  ]
  "App\Entity\Mission" => array:4 [
    0 => "The field 'App\Entity\Mission#price' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type."
    1 => "The field 'App\Entity\Mission#priceWithMargeMyFlow' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type."
    2 => "The field 'App\Entity\Mission#margeMyFlow' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type."
    3 => "The field 'App\Entity\Mission#priceSale' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type."
  ]
]

array:3 [
  "App\Entity\Company" => array:1 [
    0 => "The field 'App\Entity\Company#currentBalance' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type."
  ]
  "App\Entity\User" => array:2 [
    0 => "The field 'App\Entity\User#dailyRate' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type."
    1 => "The field 'App\Entity\User#resaleRate' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type."
  ]
  "App\Entity\Mission" => array:4 [
    0 => "The field 'App\Entity\Mission#price' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type."
    1 => "The field 'App\Entity\Mission#priceWithMargeMyFlow' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type."
    2 => "The field 'App\Entity\Mission#margeMyFlow' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type."
    3 => "The field 'App\Entity\Mission#priceSale' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type."
  ]
]

array:3 [
  "App\Entity\Company" => array:1 [
    0 => "The field 'App\Entity\Company#currentBalance' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type."
  ]
  "App\Entity\User" => array:2 [
    0 => "The field 'App\Entity\User#dailyRate' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type."
    1 => "The field 'App\Entity\User#resaleRate' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type."
  ]
  "App\Entity\Mission" => array:4 [
    0 => "The field 'App\Entity\Mission#price' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type."
    1 => "The field 'App\Entity\Mission#priceWithMargeMyFlow' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type."
    2 => "The field 'App\Entity\Mission#margeMyFlow' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type."
    3 => "The field 'App\Entity\Mission#priceSale' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type."
  ]
]

array:3 [
  "App\Entity\Company" => array:1 [
    0 => "The field 'App\Entity\Company#currentBalance' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type."
  ]
  "App\Entity\User" => array:2 [
    0 => "The field 'App\Entity\User#dailyRate' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type."
    1 => "The field 'App\Entity\User#resaleRate' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type."
  ]
  "App\Entity\Mission" => array:4 [
    0 => "The field 'App\Entity\Mission#price' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type."
    1 => "The field 'App\Entity\Mission#priceWithMargeMyFlow' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type."
    2 => "The field 'App\Entity\Mission#margeMyFlow' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type."
    3 => "The field 'App\Entity\Mission#priceSale' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type."
  ]
]

array:3 [
  "App\Entity\Company" => array:1 [
    0 => "The field 'App\Entity\Company#currentBalance' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type."
  ]
  "App\Entity\User" => array:2 [
    0 => "The field 'App\Entity\User#dailyRate' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type."
    1 => "The field 'App\Entity\User#resaleRate' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type."
  ]
  "App\Entity\Mission" => array:4 [
    0 => "The field 'App\Entity\Mission#price' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type."
    1 => "The field 'App\Entity\Mission#priceWithMargeMyFlow' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type."
    2 => "The field 'App\Entity\Mission#margeMyFlow' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type."
    3 => "The field 'App\Entity\Mission#priceSale' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type."
  ]
]

array:3 [
  "App\Entity\Company" => array:1 [
    0 => "The field 'App\Entity\Company#currentBalance' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type."
  ]
  "App\Entity\User" => array:2 [
    0 => "The field 'App\Entity\User#dailyRate' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type."
    1 => "The field 'App\Entity\User#resaleRate' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type."
  ]
  "App\Entity\Mission" => array:4 [
    0 => "The field 'App\Entity\Mission#price' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type."
    1 => "The field 'App\Entity\Mission#priceWithMargeMyFlow' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type."
    2 => "The field 'App\Entity\Mission#margeMyFlow' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type."
    3 => "The field 'App\Entity\Mission#priceSale' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type."
  ]
]

array:3 [
  "App\Entity\Company" => array:1 [
    0 => "The field 'App\Entity\Company#currentBalance' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type."
  ]
  "App\Entity\User" => array:2 [
    0 => "The field 'App\Entity\User#dailyRate' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type."
    1 => "The field 'App\Entity\User#resaleRate' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type."
  ]
  "App\Entity\Mission" => array:4 [
    0 => "The field 'App\Entity\Mission#price' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type."
    1 => "The field 'App\Entity\Mission#priceWithMargeMyFlow' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type."
    2 => "The field 'App\Entity\Mission#margeMyFlow' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type."
    3 => "The field 'App\Entity\Mission#priceSale' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type."
  ]
]

Class	Mapping errors

Symfony Profiler

https://app.dev.my-flow.fr/messages/get/user/who/read/undefined?currentUserId=8WHR9ottYVM4zcAhJhKJje

Configuration Settings

Theme