GET https://oomai.app/manager/crm/form_task

Response
200 OK
Browse referrer URL
IP
91.174.182.59
Profiled on
Token
978095

Query Metrics

93 Database Queries
10 Different statements
73.63 ms Query time
3 Invalid entities
459 Managed entities

Grouped Statements

Show all queries

Time▼ Count Info
50.05 ms
(67.98%) 		78 
SELECT t0.id AS id_1, t0.date_creation AS date_creation_2, t0.entity_type AS entity_type_3, t0.name AS name_4, t0.login AS login_5, t0.passwd AS passwd_6, t0.profile AS profile_7, t0.notification_mail AS notification_mail_8, t0.view_support AS view_support_9, t0.phone AS phone_10, t0.profile_color AS profile_color_11, t0.date_start AS date_start_12, t0.date_end AS date_end_13, t0.active AS active_14, t0.passwd_reset_code AS passwd_reset_code_15, t0.google_api_access_token AS google_api_access_token_16, t0.google_api_refresh_token AS google_api_refresh_token_17, t0.google_api_expires_at AS google_api_expires_at_18, t0.google_calendar_id AS google_calendar_id_19, t0.google_user_email AS google_user_email_20, t0.google_channel_id AS google_channel_id_21, t0.google_channel_resource_id AS google_channel_resource_id_22, t0.google_channel_expires_at AS google_channel_expires_at_23, t0.google_last_sync AS google_last_sync_24, t0.purchaser_id AS purchaser_id_25 FROM dm_site_admin_user t0 INNER JOIN dm_form_task_share_user ON t0.id = dm_form_task_share_user.site_admin_user_id WHERE dm_form_task_share_user.form_task_id = ?
Parameters: 
[
  355
]
View formatted query    View runnable query    Explain query    View query backtrace
9.90 ms
(13.45%) 		1 
SELECT d0_.id AS id_0, d0_.date_creation AS date_creation_1, d0_.is_star AS is_star_2, d0_.date_modification AS date_modification_3, d0_.entity_type AS entity_type_4, d0_.entity_state AS entity_state_5, d0_.state_message AS state_message_6, d0_.label AS label_7, d0_.description AS description_8, d0_.todo AS todo_9, d0_.google_event_id AS google_event_id_10, d0_.ticket_number AS ticket_number_11, d0_.date_first_response AS date_first_response_12, d0_.real_date_end AS real_date_end_13, d0_.elapsed_time AS elapsed_time_14, d0_.note AS note_15, d0_.date_start AS date_start_16, d0_.date_end AS date_end_17, d0_.time_start AS time_start_18, d0_.time_end AS time_end_19, d0_.active AS active_20, d1_.id AS id_21, d1_.date_creation AS date_creation_22, d1_.label AS label_23, d1_.color AS color_24, d1_.date_start AS date_start_25, d1_.date_end AS date_end_26, d1_.active AS active_27, d1_.position AS position_28, d2_.id AS id_29, d2_.date_creation AS date_creation_30, d2_.entity_type AS entity_type_31, d2_.name AS name_32, d2_.login AS login_33, d2_.passwd AS passwd_34, d2_.profile AS profile_35, d2_.notification_mail AS notification_mail_36, d2_.view_support AS view_support_37, d2_.phone AS phone_38, d2_.profile_color AS profile_color_39, d2_.date_start AS date_start_40, d2_.date_end AS date_end_41, d2_.active AS active_42, d2_.passwd_reset_code AS passwd_reset_code_43, d2_.google_api_access_token AS google_api_access_token_44, d2_.google_api_refresh_token AS google_api_refresh_token_45, d2_.google_api_expires_at AS google_api_expires_at_46, d2_.google_calendar_id AS google_calendar_id_47, d2_.google_user_email AS google_user_email_48, d2_.google_channel_id AS google_channel_id_49, d2_.google_channel_resource_id AS google_channel_resource_id_50, d2_.google_channel_expires_at AS google_channel_expires_at_51, d2_.google_last_sync AS google_last_sync_52, d3_.id AS id_53, d3_.date_creation AS date_creation_54, d3_.entity_type AS entity_type_55, d3_.label AS label_56, d3_.hourly_rate AS hourly_rate_57, d3_.color AS color_58, d3_.icon AS icon_59, d3_.date_start AS date_start_60, d3_.date_end AS date_end_61, d3_.active AS active_62, d4_.id AS id_63, d4_.date_creation AS date_creation_64, d4_.is_star AS is_star_65, d4_.date_modification AS date_modification_66, d4_.entity_type AS entity_type_67, d4_.entity_state AS entity_state_68, d4_.state_message AS state_message_69, d4_.label AS label_70, d4_.amount AS amount_71, d4_.probability AS probability_72, d4_.description AS description_73, d4_.todo AS todo_74, d4_.contract_number AS contract_number_75, d4_.budget_signed AS budget_signed_76, d4_.budget_consumed AS budget_consumed_77, d4_.expected_margin AS expected_margin_78, d4_.workdays_signed AS workdays_signed_79, d4_.workdays_consumed AS workdays_consumed_80, d4_.note AS note_81, d4_.date_start AS date_start_82, d4_.date_end AS date_end_83, d4_.active AS active_84, d5_.id AS id_85, d5_.date_creation AS date_creation_86, d5_.is_star AS is_star_87, d5_.date_modification AS date_modification_88, d5_.entity_type AS entity_type_89, d5_.entity_state AS entity_state_90, d5_.state_message AS state_message_91, d5_.label AS label_92, d5_.amount AS amount_93, d5_.probability AS probability_94, d5_.description AS description_95, d5_.todo AS todo_96, d5_.contract_number AS contract_number_97, d5_.budget_signed AS budget_signed_98, d5_.budget_consumed AS budget_consumed_99, d5_.expected_margin AS expected_margin_100, d5_.workdays_signed AS workdays_signed_101, d5_.workdays_consumed AS workdays_consumed_102, d5_.note AS note_103, d5_.date_start AS date_start_104, d5_.date_end AS date_end_105, d5_.active AS active_106, d6_.id AS id_107, d6_.date_creation AS date_creation_108, d6_.entity_type AS entity_type_109, d6_.entity_state AS entity_state_110, d6_.label AS label_111, d6_.siret AS siret_112, d6_.billing_address AS billing_address_113, d6_.billing_address1 AS billing_address1_114, d6_.billing_address2 AS billing_address2_115, d6_.billing_address3 AS billing_address3_116, d6_.billing_postal_code AS billing_postal_code_117, d6_.billing_city AS billing_city_118, d6_.shipping_label AS shipping_label_119, d6_.shipping_address AS shipping_address_120, d6_.shipping_address1 AS shipping_address1_121, d6_.shipping_address2 AS shipping_address2_122, d6_.shipping_address3 AS shipping_address3_123, d6_.shipping_postal_code AS shipping_postal_code_124, d6_.shipping_city AS shipping_city_125, d6_.first_name AS first_name_126, d6_.last_name AS last_name_127, d6_.phone AS phone_128, d6_.email AS email_129, d6_.fax AS fax_130, d6_.website AS website_131, d6_.industry AS industry_132, d6_.discount_amount AS discount_amount_133, d6_.discount_unit AS discount_unit_134, d6_.tva_applicable AS tva_applicable_135, d6_.tva_rate AS tva_rate_136, d6_.tva_number AS tva_number_137, d6_.payment_condition_nbdays AS payment_condition_nbdays_138, d6_.payment_condition_when AS payment_condition_when_139, d6_.payment_condition_date AS payment_condition_date_140, d6_.prospection_status AS prospection_status_141, d6_.note AS note_142, d6_.profile_color AS profile_color_143, d6_.date_start AS date_start_144, d6_.date_end AS date_end_145, d6_.active AS active_146, d7_.id AS id_147, d7_.date_creation AS date_creation_148, d7_.entity_type AS entity_type_149, d7_.name AS name_150, d7_.login AS login_151, d7_.passwd AS passwd_152, d7_.profile AS profile_153, d7_.notification_mail AS notification_mail_154, d7_.view_support AS view_support_155, d7_.phone AS phone_156, d7_.profile_color AS profile_color_157, d7_.date_start AS date_start_158, d7_.date_end AS date_end_159, d7_.active AS active_160, d7_.passwd_reset_code AS passwd_reset_code_161, d7_.google_api_access_token AS google_api_access_token_162, d7_.google_api_refresh_token AS google_api_refresh_token_163, d7_.google_api_expires_at AS google_api_expires_at_164, d7_.google_calendar_id AS google_calendar_id_165, d7_.google_user_email AS google_user_email_166, d7_.google_channel_id AS google_channel_id_167, d7_.google_channel_resource_id AS google_channel_resource_id_168, d7_.google_channel_expires_at AS google_channel_expires_at_169, d7_.google_last_sync AS google_last_sync_170, d8_.id AS id_171, d8_.date_creation AS date_creation_172, d8_.is_star AS is_star_173, d8_.date_modification AS date_modification_174, d8_.entity_type AS entity_type_175, d8_.entity_state AS entity_state_176, d8_.state_message AS state_message_177, d8_.label AS label_178, d8_.description AS description_179, d8_.todo AS todo_180, d8_.google_event_id AS google_event_id_181, d8_.ticket_number AS ticket_number_182, d8_.date_first_response AS date_first_response_183, d8_.real_date_end AS real_date_end_184, d8_.elapsed_time AS elapsed_time_185, d8_.note AS note_186, d8_.date_start AS date_start_187, d8_.date_end AS date_end_188, d8_.time_start AS time_start_189, d8_.time_end AS time_end_190, d8_.active AS active_191, d9_.id AS id_192, d9_.date_creation AS date_creation_193, d9_.is_star AS is_star_194, d9_.date_modification AS date_modification_195, d9_.entity_type AS entity_type_196, d9_.entity_state AS entity_state_197, d9_.state_message AS state_message_198, d9_.label AS label_199, d9_.description AS description_200, d9_.todo AS todo_201, d9_.google_event_id AS google_event_id_202, d9_.ticket_number AS ticket_number_203, d9_.date_first_response AS date_first_response_204, d9_.real_date_end AS real_date_end_205, d9_.elapsed_time AS elapsed_time_206, d9_.note AS note_207, d9_.date_start AS date_start_208, d9_.date_end AS date_end_209, d9_.time_start AS time_start_210, d9_.time_end AS time_end_211, d9_.active AS active_212, d0_.purchaser_id AS purchaser_id_213, d0_.task_category_id AS task_category_id_214, d0_.company_id AS company_id_215, d0_.project_id AS project_id_216, d0_.opportunity_id AS opportunity_id_217, d0_.priority_id AS priority_id_218, d0_.assigned_user_id AS assigned_user_id_219, d0_.admin_user_id AS admin_user_id_220, d0_.origin_ticket_id AS origin_ticket_id_221, d0_.parent_task_id AS parent_task_id_222, d2_.purchaser_id AS purchaser_id_223, d3_.purchaser_id AS purchaser_id_224, d4_.purchaser_id AS purchaser_id_225, d4_.project_category_id AS project_category_id_226, d4_.project_cycle_id AS project_cycle_id_227, d4_.company_id AS company_id_228, d4_.assigned_user_id AS assigned_user_id_229, d4_.admin_user_id AS admin_user_id_230, d4_.origin_opportunity_id AS origin_opportunity_id_231, d5_.purchaser_id AS purchaser_id_232, d5_.project_category_id AS project_category_id_233, d5_.project_cycle_id AS project_cycle_id_234, d5_.company_id AS company_id_235, d5_.assigned_user_id AS assigned_user_id_236, d5_.admin_user_id AS admin_user_id_237, d5_.origin_opportunity_id AS origin_opportunity_id_238, d6_.purchaser_id AS purchaser_id_239, d6_.company_category_id AS company_category_id_240, d6_.legal_status_id AS legal_status_id_241, d6_.company_size_id AS company_size_id_242, d6_.lead_source_id AS lead_source_id_243, d6_.billing_country_id AS billing_country_id_244, d6_.shipping_country_id AS shipping_country_id_245, d6_.assigned_user_id AS assigned_user_id_246, d6_.payment_method_id AS payment_method_id_247, d6_.admin_user_id AS admin_user_id_248, d7_.purchaser_id AS purchaser_id_249, d8_.purchaser_id AS purchaser_id_250, d8_.task_category_id AS task_category_id_251, d8_.company_id AS company_id_252, d8_.project_id AS project_id_253, d8_.opportunity_id AS opportunity_id_254, d8_.priority_id AS priority_id_255, d8_.assigned_user_id AS assigned_user_id_256, d8_.admin_user_id AS admin_user_id_257, d8_.origin_ticket_id AS origin_ticket_id_258, d8_.parent_task_id AS parent_task_id_259, d9_.purchaser_id AS purchaser_id_260, d9_.task_category_id AS task_category_id_261, d9_.company_id AS company_id_262, d9_.project_id AS project_id_263, d9_.opportunity_id AS opportunity_id_264, d9_.priority_id AS priority_id_265, d9_.assigned_user_id AS assigned_user_id_266, d9_.admin_user_id AS admin_user_id_267, d9_.origin_ticket_id AS origin_ticket_id_268, d9_.parent_task_id AS parent_task_id_269 FROM dm_form_task d0_ LEFT JOIN dm_lib_generic_priority d1_ ON d0_.priority_id = d1_.id LEFT JOIN dm_site_admin_user d2_ ON d0_.assigned_user_id = d2_.id LEFT JOIN dm_lib_task_category d3_ ON d0_.task_category_id = d3_.id LEFT JOIN dm_form_project d4_ ON d0_.project_id = d4_.id LEFT JOIN dm_form_project d5_ ON d0_.opportunity_id = d5_.id LEFT JOIN dm_lib_company d6_ ON d0_.company_id = d6_.id LEFT JOIN dm_form_task_share_user d10_ ON d0_.id = d10_.form_task_id LEFT JOIN dm_site_admin_user d7_ ON d7_.id = d10_.site_admin_user_id LEFT JOIN dm_form_task d8_ ON d0_.id = d8_.origin_ticket_id LEFT JOIN dm_form_task d9_ ON d0_.id = d9_.parent_task_id WHERE (d0_.entity_type = ? AND d0_.entity_state IN (?, ?, ?, ?) AND d0_.parent_task_id IS NULL) OR (d0_.entity_type = ? AND d0_.entity_state IN (?, ?, ?, ?) AND d0_.parent_task_id IS NULL) OR (d0_.entity_type = ? AND d0_.entity_state IN (?, ?, ?, ?) AND d0_.parent_task_id IS NULL) OR (d0_.entity_type = ? AND d0_.entity_state IN (?, ?, ?, ?) AND d0_.parent_task_id IS NULL) OR (d0_.entity_type = ? AND d0_.entity_state IN (?, ?, ?, ?) AND d0_.parent_task_id IS NULL) ORDER BY d0_.date_creation DESC
Parameters: 
[
  "tâche"
  "new"
  "update"
  "valid"
  "archive"
  "tâche"
  "new"
  "update"
  "valid"
  "archive"
  "tâche"
  "new"
  "update"
  "valid"
  "archive"
  "tâche"
  "new"
  "update"
  "valid"
  "archive"
  "tâche"
  "new"
  "update"
  "valid"
  "archive"
]
View formatted query    View runnable query    Explain query    View query backtrace
3.52 ms
(4.79%) 		3 
SELECT d0_.id AS id_0, d0_.name AS name_1, d0_.label AS label_2, d0_.active AS active_3, d0_.standalone AS standalone_4, d0_.entity AS entity_5, d0_.entity_type AS entity_type_6, d0_.entity_state AS entity_state_7, d0_.entity_state_controls AS entity_state_controls_8, d0_.entity_childs AS entity_childs_9, d0_.list_fields AS list_fields_10, d0_.exclude_fields AS exclude_fields_11, d0_.association_route AS association_route_12, d0_.only_one AS only_one_13, d0_.special_route AS special_route_14, d0_.sortable AS sortable_15, d0_.pinnable AS pinnable_16, d0_.countable AS countable_17, d0_.pagination AS pagination_18, d0_.search AS search_19, d0_.filters AS filters_20, d0_.views AS views_21, d0_.details AS details_22, d0_.sort AS sort_23, d0_.add_item AS add_item_24, d0_.info_status AS info_status_25, d0_.color_status AS color_status_26, d0_.page_overview AS page_overview_27, d0_.export AS export_28, d0_.icon AS icon_29, d0_.position AS position_30, d0_.wp_access AS wp_access_31, d1_.id AS id_32, d1_.name AS name_33, d1_.label AS label_34, d1_.icon AS icon_35, d0_.config_type_id AS config_type_id_36 FROM dm_config_manager d0_ INNER JOIN dm_config_manager_type_label d1_ ON d0_.config_type_id = d1_.id WHERE d0_.name = ?
Parameters: 
[
  "form_task"
]
View formatted query    View runnable query    Explain query    View query backtrace
3.33 ms
(4.52%) 		5 
SELECT t0.id AS id_1, t0.name AS name_2, t0.label AS label_3, t0.active AS active_4, t0.standalone AS standalone_5, t0.entity AS entity_6, t0.entity_type AS entity_type_7, t0.entity_state AS entity_state_8, t0.entity_state_controls AS entity_state_controls_9, t0.entity_childs AS entity_childs_10, t0.list_fields AS list_fields_11, t0.exclude_fields AS exclude_fields_12, t0.association_route AS association_route_13, t0.only_one AS only_one_14, t0.special_route AS special_route_15, t0.sortable AS sortable_16, t0.pinnable AS pinnable_17, t0.countable AS countable_18, t0.pagination AS pagination_19, t0.search AS search_20, t0.filters AS filters_21, t0.views AS views_22, t0.details AS details_23, t0.sort AS sort_24, t0.add_item AS add_item_25, t0.info_status AS info_status_26, t0.color_status AS color_status_27, t0.page_overview AS page_overview_28, t0.export AS export_29, t0.icon AS icon_30, t0.position AS position_31, t0.wp_access AS wp_access_32, t0.config_type_id AS config_type_id_33 FROM dm_config_manager t0
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
1.63 ms
(2.22%) 		1 
SELECT d0_.id AS id_0, d0_.name AS name_1, d0_.label AS label_2, d0_.active AS active_3, d0_.standalone AS standalone_4, d0_.entity AS entity_5, d0_.entity_type AS entity_type_6, d0_.entity_state AS entity_state_7, d0_.entity_state_controls AS entity_state_controls_8, d0_.entity_childs AS entity_childs_9, d0_.list_fields AS list_fields_10, d0_.exclude_fields AS exclude_fields_11, d0_.association_route AS association_route_12, d0_.only_one AS only_one_13, d0_.special_route AS special_route_14, d0_.sortable AS sortable_15, d0_.pinnable AS pinnable_16, d0_.countable AS countable_17, d0_.pagination AS pagination_18, d0_.search AS search_19, d0_.filters AS filters_20, d0_.views AS views_21, d0_.details AS details_22, d0_.sort AS sort_23, d0_.add_item AS add_item_24, d0_.info_status AS info_status_25, d0_.color_status AS color_status_26, d0_.page_overview AS page_overview_27, d0_.export AS export_28, d0_.icon AS icon_29, d0_.position AS position_30, d0_.wp_access AS wp_access_31, d1_.id AS id_32, d1_.name AS name_33, d1_.label AS label_34, d1_.icon AS icon_35, d0_.config_type_id AS config_type_id_36 FROM dm_config_manager d0_ INNER JOIN dm_config_manager_type_label d1_ ON d0_.config_type_id = d1_.id ORDER BY d0_.position ASC, d0_.id ASC
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
1.46 ms
(1.99%) 		1 
SELECT COUNT(DISTINCT d0_.id) AS sclr_0 FROM dm_form_task d0_ LEFT JOIN dm_lib_generic_priority d1_ ON d0_.priority_id = d1_.id LEFT JOIN dm_site_admin_user d2_ ON d0_.assigned_user_id = d2_.id LEFT JOIN dm_lib_task_category d3_ ON d0_.task_category_id = d3_.id LEFT JOIN dm_form_project d4_ ON d0_.project_id = d4_.id LEFT JOIN dm_form_project d5_ ON d0_.opportunity_id = d5_.id LEFT JOIN dm_lib_company d6_ ON d0_.company_id = d6_.id LEFT JOIN dm_form_task_share_user d8_ ON d0_.id = d8_.form_task_id LEFT JOIN dm_site_admin_user d7_ ON d7_.id = d8_.site_admin_user_id LEFT JOIN dm_form_task d9_ ON d0_.id = d9_.origin_ticket_id LEFT JOIN dm_form_task d10_ ON d0_.id = d10_.parent_task_id WHERE (d0_.entity_type = ? AND d0_.entity_state IN (?, ?, ?, ?) AND d0_.parent_task_id IS NULL AND d0_.is_star = ?) OR (d0_.entity_type = ? AND d0_.entity_state IN (?, ?, ?, ?) AND d0_.parent_task_id IS NULL AND d0_.is_star = ?) OR (d0_.entity_type = ? AND d0_.entity_state IN (?, ?, ?, ?) AND d0_.parent_task_id IS NULL AND d0_.is_star = ?) OR (d0_.entity_type = ? AND d0_.entity_state IN (?, ?, ?, ?) AND d0_.parent_task_id IS NULL AND d0_.is_star = ?) OR (d0_.entity_type = ? AND d0_.entity_state IN (?, ?, ?, ?) AND d0_.parent_task_id IS NULL AND d0_.is_star = ?)
Parameters: 
[
  "tâche"
  "new"
  "update"
  "valid"
  "archive"
  1
  "tâche"
  "new"
  "update"
  "valid"
  "archive"
  1
  "tâche"
  "new"
  "update"
  "valid"
  "archive"
  1
  "tâche"
  "new"
  "update"
  "valid"
  "archive"
  1
  "tâche"
  "new"
  "update"
  "valid"
  "archive"
  1
]
View formatted query    View runnable query    Explain query    View query backtrace
1.36 ms
(1.85%) 		1 
SELECT d0_.id AS id_0, d0_.active AS active_1, d1_.id AS id_2, d1_.date_creation AS date_creation_3, d1_.is_star AS is_star_4, d1_.date_modification AS date_modification_5, d1_.entity_type AS entity_type_6, d1_.entity_state AS entity_state_7, d1_.state_message AS state_message_8, d1_.label AS label_9, d1_.description AS description_10, d1_.link AS link_11, d1_.date_start AS date_start_12, d1_.date_end AS date_end_13, d1_.active AS active_14, d0_.notification_id AS notification_id_15, d0_.admin_user_id AS admin_user_id_16, d1_.purchaser_id AS purchaser_id_17 FROM dm_form_notification_user d0_ INNER JOIN dm_form_notification d1_ ON d0_.notification_id = d1_.id WHERE d0_.admin_user_id = ? AND d0_.active = ? ORDER BY d1_.date_creation DESC, d1_.id ASC
Parameters: 
[
  4
  1
]
View formatted query    View runnable query    Explain query    View query backtrace
1.15 ms
(1.57%) 		1 
SELECT COUNT(DISTINCT d0_.id) AS sclr_0 FROM dm_form_task d0_ LEFT JOIN dm_lib_generic_priority d1_ ON d0_.priority_id = d1_.id LEFT JOIN dm_site_admin_user d2_ ON d0_.assigned_user_id = d2_.id LEFT JOIN dm_lib_task_category d3_ ON d0_.task_category_id = d3_.id LEFT JOIN dm_form_project d4_ ON d0_.project_id = d4_.id LEFT JOIN dm_form_project d5_ ON d0_.opportunity_id = d5_.id LEFT JOIN dm_lib_company d6_ ON d0_.company_id = d6_.id LEFT JOIN dm_form_task_share_user d8_ ON d0_.id = d8_.form_task_id LEFT JOIN dm_site_admin_user d7_ ON d7_.id = d8_.site_admin_user_id LEFT JOIN dm_form_task d9_ ON d0_.id = d9_.origin_ticket_id LEFT JOIN dm_form_task d10_ ON d0_.id = d10_.parent_task_id WHERE (d0_.entity_type = ? AND d0_.entity_state IN (?, ?, ?, ?) AND d0_.is_star = ?) OR (d0_.entity_type = ? AND d0_.entity_state IN (?, ?, ?, ?) AND d0_.is_star = ?)
Parameters: 
[
  "ticket"
  "new"
  "update"
  "valid"
  "archive"
  1
  "ticket"
  "new"
  "update"
  "valid"
  "archive"
  1
]
View formatted query    View runnable query    Explain query    View query backtrace
0.73 ms
(0.99%) 		1 
SELECT t0.id AS id_1, t0.date_creation AS date_creation_2, t0.entity_type AS entity_type_3, t0.label AS label_4, t0.hourly_rate AS hourly_rate_5, t0.color AS color_6, t0.icon AS icon_7, t0.date_start AS date_start_8, t0.date_end AS date_end_9, t0.active AS active_10, t0.purchaser_id AS purchaser_id_11 FROM dm_lib_task_category t0 WHERE t0.entity_type = ? AND t0.active = ? ORDER BY t0.label ASC
Parameters: 
[
  "tâche"
  1
]
View formatted query    View runnable query    Explain query    View query backtrace
0.49 ms
(0.66%) 		1 
SELECT t0.id AS id_1, t0.date_creation AS date_creation_2, t0.label AS label_3, t0.color AS color_4, t0.date_start AS date_start_5, t0.date_end AS date_end_6, t0.active AS active_7, t0.position AS position_8 FROM dm_lib_generic_priority t0 WHERE t0.active = ? ORDER BY t0.position ASC
Parameters: 
[
  1
]
View formatted query    View runnable query    Explain query    View query backtrace

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.

Managed Entities

default entity manager

Class Amount of managed objects
App\Entity\FormTask 302
App\Entity\ConfigManager 36
App\Entity\LibTaskCategory 26
App\Entity\FormProject 24
App\Entity\LibCompany 24
App\Entity\ConfigManagerTypeLabel 7
App\Entity\LibProjectCategory 7
App\Entity\FormNotificationUser 5
App\Entity\FormNotification 5
App\Entity\SiteAdminUser 4
App\Entity\LibPriority 4
App\Entity\LibCompanyCategory 4
App\Entity\LibCompanyPaymentMethod 3
App\Entity\LibPurchaser 2
App\Entity\LibLegalStatus 2
App\Entity\LibProjectCycle 2
App\Entity\LibCountry 1
App\Entity\LibCompanySize 1

Entities Mapping

Class Mapping errors
App\Entity\ConfigManager No errors.
App\Entity\ConfigManagerTypeLabel No errors.
App\Entity\SiteAdminUser No errors.
App\Entity\FormTask No errors.
App\Entity\LibPriority No errors.
App\Entity\LibTaskCategory No errors.
App\Entity\FormProject No errors.
App\Entity\LibCompany
  • The association App\Entity\LibCompany#billing_country refers to the inverse side field App\Entity\LibCountry#libCompanies which does not exist.
  • The association App\Entity\LibCompany#shipping_country refers to the inverse side field App\Entity\LibCountry#libCompanies which does not exist.
App\Entity\LibPurchaser No errors.
App\Entity\LibProjectCategory No errors.
App\Entity\LibProjectCycle No errors.
App\Entity\LibCompanyCategory No errors.
App\Entity\LibLegalStatus No errors.
App\Entity\LibCompanySize No errors.
App\Entity\LibCompanyLeadSource No errors.
App\Entity\LibCountry
  • The mappings App\Entity\LibCountry#libShippingCompanies and App\Entity\LibCompany#shipping_country are inconsistent with each other.
  • The mappings App\Entity\LibCountry#libBillingCompanies and App\Entity\LibCompany#billing_country are inconsistent with each other.
App\Entity\LibCompanyPaymentMethod No errors.
App\Entity\LibCompanyContact No errors.
App\Entity\LibPurchaserDocument No errors.
App\Entity\FormTaskChild No errors.
App\Entity\SitePage No errors.
App\Entity\FormQuotationInvoice No errors.
App\Entity\FormLicence
  • The association App\Entity\FormLicence#licence_expires refers to the inverse side field App\Entity\LibLicenceExpires#formLicenses which does not exist.
App\Entity\LibCompanyDocument No errors.
App\Entity\FormNotificationUser No errors.
App\Entity\FormNotification No errors.