Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

2 Database Queries

2 Different statements

1.47 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼	Count	Info
1.24 ms (84.24%)	1	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.23 ms (15.76%)	1	SELECT t0.id AS id_1, t0.firstname AS firstname_2, t0.new_add AS new_add_3, t0.all_company AS all_company_4, t0.salary AS salary_5, t0.manager AS manager_6, t0.partner AS partner_7, t0.share_my_email AS share_my_email_8, t0.share_my_phone AS share_my_phone_9, t0.lastname AS lastname_10, t0.cell_phone AS cell_phone_11, t0.enabled AS enabled_12, t0.external AS external_13, t0.daily_rate AS daily_rate_14, t0.resale_rate AS resale_rate_15, t0.billing_method AS billing_method_16, t0.picture_name AS picture_name_17, t0.updated_at AS updated_at_18, t0.email AS email_19, t0.original_email AS original_email_20, t0.roles AS roles_21, t0.password AS password_22, t0.created_at AS created_at_23, t0.last_connection_at AS last_connection_at_24, t0.account_type AS account_type_25, t0.notification_type AS notification_type_26, t0.notification AS notification_27, t0.freq_notification AS freq_notification_28, t0.freq_notification_everytime AS freq_notification_everytime_29, t0.freq_notification_per_day AS freq_notification_per_day_30, t0.freq_notification_per_week AS freq_notification_per_week_31, t0.freq_notification_per_month AS freq_notification_per_month_32, t0.is_active_notification AS is_active_notification_33, t0.deleted AS deleted_34, t0.referencing_confirmation_notification AS referencing_confirmation_notification_35, t0.gender AS gender_36, t0.device_connected_list AS device_connected_list_37, t0.invisible AS invisible_38, t0.last_activity_at AS last_activity_at_39, t0.is_logged AS is_logged_40, t0.is_new_client AS is_new_client_41, t0.autorization_date_at AS autorization_date_at_42, t0.accept_presentation AS accept_presentation_43, t0.description AS description_44, t0.title AS title_45, t0.one_time_login_token AS one_time_login_token_46, t0.state AS state_47, t0.company_id AS company_id_48, t0.user_data_id AS user_data_id_49, t0.parent_id AS parent_id_50 FROM users t0 WHERE t0.email = ? LIMIT 1 Parameters: [`""`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.firstname AS firstname_2, t0.new_add AS new_add_3, t0.all_company AS all_company_4, t0.salary AS salary_5, t0.manager AS manager_6, t0.partner AS partner_7, t0.share_my_email AS share_my_email_8, t0.share_my_phone AS share_my_phone_9, t0.lastname AS lastname_10, t0.cell_phone AS cell_phone_11, t0.enabled AS enabled_12, t0.external AS external_13, t0.daily_rate AS daily_rate_14, t0.resale_rate AS resale_rate_15, t0.billing_method AS billing_method_16, t0.picture_name AS picture_name_17, t0.updated_at AS updated_at_18, t0.email AS email_19, t0.original_email AS original_email_20, t0.roles AS roles_21, t0.password AS password_22, t0.created_at AS created_at_23, t0.last_connection_at AS last_connection_at_24, t0.account_type AS account_type_25, t0.notification_type AS notification_type_26, t0.notification AS notification_27, t0.freq_notification AS freq_notification_28, t0.freq_notification_everytime AS freq_notification_everytime_29, t0.freq_notification_per_day AS freq_notification_per_day_30, t0.freq_notification_per_week AS freq_notification_per_week_31, t0.freq_notification_per_month AS freq_notification_per_month_32, t0.is_active_notification AS is_active_notification_33, t0.deleted AS deleted_34, t0.referencing_confirmation_notification AS referencing_confirmation_notification_35, t0.gender AS gender_36, t0.device_connected_list AS device_connected_list_37, t0.invisible AS invisible_38, t0.last_activity_at AS last_activity_at_39, t0.is_logged AS is_logged_40, t0.is_new_client AS is_new_client_41, t0.autorization_date_at AS autorization_date_at_42, t0.accept_presentation AS accept_presentation_43, t0.description AS description_44, t0.title AS title_45, t0.one_time_login_token AS one_time_login_token_46, t0.state AS state_47, t0.company_id AS company_id_48, t0.user_data_id AS user_data_id_49, t0.parent_id AS parent_id_50 FROM users t0 WHERE t0.email = ? LIMIT 1 SELECT t0.id AS id_1, t0.firstname AS firstname_2, t0.new_add AS new_add_3, t0.all_company AS all_company_4, t0.salary AS salary_5, t0.manager AS manager_6, t0.partner AS partner_7, t0.share_my_email AS share_my_email_8, t0.share_my_phone AS share_my_phone_9, t0.lastname AS lastname_10, t0.cell_phone AS cell_phone_11, t0.enabled AS enabled_12, t0.external AS external_13, t0.daily_rate AS daily_rate_14, t0.resale_rate AS resale_rate_15, t0.billing_method AS billing_method_16, t0.picture_name AS picture_name_17, t0.updated_at AS updated_at_18, t0.email AS email_19, t0.original_email AS original_email_20, t0.roles AS roles_21, t0.password AS password_22, t0.created_at AS created_at_23, t0.last_connection_at AS last_connection_at_24, t0.account_type AS account_type_25, t0.notification_type AS notification_type_26, t0.notification AS notification_27, t0.freq_notification AS freq_notification_28, t0.freq_notification_everytime AS freq_notification_everytime_29, t0.freq_notification_per_day AS freq_notification_per_day_30, t0.freq_notification_per_week AS freq_notification_per_week_31, t0.freq_notification_per_month AS freq_notification_per_month_32, t0.is_active_notification AS is_active_notification_33, t0.deleted AS deleted_34, t0.referencing_confirmation_notification AS referencing_confirmation_notification_35, t0.gender AS gender_36, t0.device_connected_list AS device_connected_list_37, t0.invisible AS invisible_38, t0.last_activity_at AS last_activity_at_39, t0.is_logged AS is_logged_40, t0.is_new_client AS is_new_client_41, t0.autorization_date_at AS autorization_date_at_42, t0.accept_presentation AS accept_presentation_43, t0.description AS description_44, t0.title AS title_45, t0.one_time_login_token AS one_time_login_token_46, t0.state AS state_47, t0.company_id AS company_id_48, t0.user_data_id AS user_data_id_49, t0.parent_id AS parent_id_50 FROM users t0 WHERE t0.email = '' LIMIT 1;

Time▼

Count

Info

1.24 ms
(84.24%)

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.23 ms
(15.76%)

SELECT t0.id AS id_1, t0.firstname AS firstname_2, t0.new_add AS new_add_3, t0.all_company AS all_company_4, t0.salary AS salary_5, t0.manager AS manager_6, t0.partner AS partner_7, t0.share_my_email AS share_my_email_8, t0.share_my_phone AS share_my_phone_9, t0.lastname AS lastname_10, t0.cell_phone AS cell_phone_11, t0.enabled AS enabled_12, t0.external AS external_13, t0.daily_rate AS daily_rate_14, t0.resale_rate AS resale_rate_15, t0.billing_method AS billing_method_16, t0.picture_name AS picture_name_17, t0.updated_at AS updated_at_18, t0.email AS email_19, t0.original_email AS original_email_20, t0.roles AS roles_21, t0.password AS password_22, t0.created_at AS created_at_23, t0.last_connection_at AS last_connection_at_24, t0.account_type AS account_type_25, t0.notification_type AS notification_type_26, t0.notification AS notification_27, t0.freq_notification AS freq_notification_28, t0.freq_notification_everytime AS freq_notification_everytime_29, t0.freq_notification_per_day AS freq_notification_per_day_30, t0.freq_notification_per_week AS freq_notification_per_week_31, t0.freq_notification_per_month AS freq_notification_per_month_32, t0.is_active_notification AS is_active_notification_33, t0.deleted AS deleted_34, t0.referencing_confirmation_notification AS referencing_confirmation_notification_35, t0.gender AS gender_36, t0.device_connected_list AS device_connected_list_37, t0.invisible AS invisible_38, t0.last_activity_at AS last_activity_at_39, t0.is_logged AS is_logged_40, t0.is_new_client AS is_new_client_41, t0.autorization_date_at AS autorization_date_at_42, t0.accept_presentation AS accept_presentation_43, t0.description AS description_44, t0.title AS title_45, t0.one_time_login_token AS one_time_login_token_46, t0.state AS state_47, t0.company_id AS company_id_48, t0.user_data_id AS user_data_id_49, t0.parent_id AS parent_id_50 FROM users t0 WHERE t0.email = ? LIMIT 1

Parameters:

[
  ""
]

View formatted query View runnable query Explain query

SELECT
  t0.id AS id_1,
  t0.firstname AS firstname_2,
  t0.new_add AS new_add_3,
  t0.all_company AS all_company_4,
  t0.salary AS salary_5,
  t0.manager AS manager_6,
  t0.partner AS partner_7,
  t0.share_my_email AS share_my_email_8,
  t0.share_my_phone AS share_my_phone_9,
  t0.lastname AS lastname_10,
  t0.cell_phone AS cell_phone_11,
  t0.enabled AS enabled_12,
  t0.external AS external_13,
  t0.daily_rate AS daily_rate_14,
  t0.resale_rate AS resale_rate_15,
  t0.billing_method AS billing_method_16,
  t0.picture_name AS picture_name_17,
  t0.updated_at AS updated_at_18,
  t0.email AS email_19,
  t0.original_email AS original_email_20,
  t0.roles AS roles_21,
  t0.password AS password_22,
  t0.created_at AS created_at_23,
  t0.last_connection_at AS last_connection_at_24,
  t0.account_type AS account_type_25,
  t0.notification_type AS notification_type_26,
  t0.notification AS notification_27,
  t0.freq_notification AS freq_notification_28,
  t0.freq_notification_everytime AS freq_notification_everytime_29,
  t0.freq_notification_per_day AS freq_notification_per_day_30,
  t0.freq_notification_per_week AS freq_notification_per_week_31,
  t0.freq_notification_per_month AS freq_notification_per_month_32,
  t0.is_active_notification AS is_active_notification_33,
  t0.deleted AS deleted_34,
  t0.referencing_confirmation_notification AS referencing_confirmation_notification_35,
  t0.gender AS gender_36,
  t0.device_connected_list AS device_connected_list_37,
  t0.invisible AS invisible_38,
  t0.last_activity_at AS last_activity_at_39,
  t0.is_logged AS is_logged_40,
  t0.is_new_client AS is_new_client_41,
  t0.autorization_date_at AS autorization_date_at_42,
  t0.accept_presentation AS accept_presentation_43,
  t0.description AS description_44,
  t0.title AS title_45,
  t0.one_time_login_token AS one_time_login_token_46,
  t0.state AS state_47,
  t0.company_id AS company_id_48,
  t0.user_data_id AS user_data_id_49,
  t0.parent_id AS parent_id_50
FROM
  users t0
WHERE
  t0.email = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.firstname AS firstname_2, t0.new_add AS new_add_3, t0.all_company AS all_company_4, t0.salary AS salary_5, t0.manager AS manager_6, t0.partner AS partner_7, t0.share_my_email AS share_my_email_8, t0.share_my_phone AS share_my_phone_9, t0.lastname AS lastname_10, t0.cell_phone AS cell_phone_11, t0.enabled AS enabled_12, t0.external AS external_13, t0.daily_rate AS daily_rate_14, t0.resale_rate AS resale_rate_15, t0.billing_method AS billing_method_16, t0.picture_name AS picture_name_17, t0.updated_at AS updated_at_18, t0.email AS email_19, t0.original_email AS original_email_20, t0.roles AS roles_21, t0.password AS password_22, t0.created_at AS created_at_23, t0.last_connection_at AS last_connection_at_24, t0.account_type AS account_type_25, t0.notification_type AS notification_type_26, t0.notification AS notification_27, t0.freq_notification AS freq_notification_28, t0.freq_notification_everytime AS freq_notification_everytime_29, t0.freq_notification_per_day AS freq_notification_per_day_30, t0.freq_notification_per_week AS freq_notification_per_week_31, t0.freq_notification_per_month AS freq_notification_per_month_32, t0.is_active_notification AS is_active_notification_33, t0.deleted AS deleted_34, t0.referencing_confirmation_notification AS referencing_confirmation_notification_35, t0.gender AS gender_36, t0.device_connected_list AS device_connected_list_37, t0.invisible AS invisible_38, t0.last_activity_at AS last_activity_at_39, t0.is_logged AS is_logged_40, t0.is_new_client AS is_new_client_41, t0.autorization_date_at AS autorization_date_at_42, t0.accept_presentation AS accept_presentation_43, t0.description AS description_44, t0.title AS title_45, t0.one_time_login_token AS one_time_login_token_46, t0.state AS state_47, t0.company_id AS company_id_48, t0.user_data_id AS user_data_id_49, t0.parent_id AS parent_id_50 FROM users t0 WHERE t0.email = '' LIMIT 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\UserData	No errors.
App\Entity\FileMission	No errors.
App\Entity\WorkflowAction	No errors.
App\Entity\InfoMission	No errors.
App\Entity\Device	No errors.
App\Entity\MessageReaction	No errors.
App\Entity\Emoji	No errors.
App\Entity\Support	No errors.
App\Entity\Portfolio	No errors.
App\Entity\SignedContract	No errors.
App\Entity\Product	No errors.