https://dbtechafricatracer.org/DBTA/public/en/login Return to referer URL

Method
POST
HTTP Status
302
IP
196.188.177.20
Profiled on
Token
1aa553

Query Metrics

4 Database Queries
4 Different statements
2.97 ms Query time
8 Invalid entities

Queries

Group similar statements

#▲ Time Info
1 1.20 ms 
SELECT t0.id AS id_1, t0.username AS username_2, t0.roles AS roles_3, t0.password AS password_4, t0.api_token AS api_token_5, t0.diaspora AS diaspora_6, t0.phone AS phone_7, t0.enabled AS enabled_8, t0.email AS email_9, t0.valid_code AS valid_code_10, t0.last_login AS last_login_11, t0.password_requested_at AS password_requested_at_12, t0.salt AS salt_13, t0.email_canonical AS email_canonical_14, t0.username_canonical AS username_canonical_15, t0.confirmation_token AS confirmation_token_16, t0.principal_school AS principal_school_17, t0.image_name AS image_name_18, t0.country_id AS country_id_19, t0.region_id AS region_id_20, t0.residence_country_id AS residence_country_id_21, t0.residence_region_id AS residence_region_id_22, t23.status AS status_24, t23.type AS type_25, t23.agree_rgpd AS agree_rgpd_26, t23.last_degree_year AS last_degree_year_27, t23.last_degree_month AS last_degree_month_28, t23.other_degree AS other_degree_29, t23.diaspora AS diaspora_30, t23.address_diaspora AS address_diaspora_31, t23.created_date AS created_date_32, t23.updated_date AS updated_date_33, t23.client_updated_date AS client_updated_date_34, t23.previousEndedContract AS previousEndedContract_35, t23.registration_student_school AS registration_student_school_36, t23.check_school AS check_school_37, t23.other_school AS other_school_38, t23.monthly_salary AS monthly_salary_39, t23.other_activity AS other_activity_40, t23.temporary_passwd AS temporary_passwd_41, t23.lastIdSatisfactionSalary AS lastIdSatisfactionSalary_42, t23.lastIdSatisfactionSearch AS lastIdSatisfactionSearch_43, t23.lastIdSatisfactionCreato AS lastIdSatisfactionCreato_44, t23.unlocked AS unlocked_45, t23.id AS id_46, t23.firstname AS firstname_47, t23.lastname AS lastname_48, t23.birth_date AS birth_date_49, t23.address_number AS address_number_50, t23.address_locality AS address_locality_51, t23.address_road AS address_road_52, t23.other_city AS other_city_53, t23.latitude AS latitude_54, t23.longitude AS longitude_55, t23.maps_address AS maps_address_56, t23.phone_mobile1 AS phone_mobile1_57, t23.phone_mobile2 AS phone_mobile2_58, t23.phone_mobile3 AS phone_mobile3_59, t23.phone_home AS phone_home_60, t23.phone_office AS phone_office_61, t23.location_mode AS location_mode_62, t23.email AS email_63, t23.sex AS sex_64, t23.residence_country_id AS residence_country_id_65, t23.residence_region_id AS residence_region_id_66, t23.id_degree AS id_degree_67, t23.school_id AS school_id_68, t23.lasted_company_id AS lasted_company_id_69, t23.activity_id AS activity_id_70, t23.id_sectorArea AS id_sectorArea_71, t23.lasted_contract_id AS lasted_contract_id_72, t23.lasted_company_id AS lasted_company_id_73, t23.user_id AS user_id_74, t23.id_city AS id_city_75, t23.id_region AS id_region_76, t23.id_country AS id_country_77, t23.id_image AS id_image_78, t79.id AS id_80, t79.name AS name_81, t79.url AS url_82, t79.created_date AS created_date_83, t79.updated_date AS updated_date_84, t79.client_updated_date AS client_updated_date_85, t79.other_city AS other_city_86, t79.address_number AS address_number_87, t79.address_locality AS address_locality_88, t79.address_road AS address_road_89, t79.phone_standard AS phone_standard_90, t79.phone_other AS phone_other_91, t79.email AS email_92, t79.temporary_passwd AS temporary_passwd_93, t79.latitude AS latitude_94, t79.longitude AS longitude_95, t79.maps_address AS maps_address_96, t79.location_fixed AS location_fixed_97, t79.agree_rgpd AS agree_rgpd_98, t79.location_mode AS location_mode_99, t79.unlocked AS unlocked_100, t79.id_city AS id_city_101, t79.id_region AS id_region_102, t79.id_country AS id_country_103, t79.id_contactCompany AS id_contactCompany_104, t79.id_sectorArea AS id_sectorArea_105, t79.id_legal_status AS id_legal_status_106, t79.user_id AS user_id_107, t79.id_image AS id_image_108, t109.id AS id_110, t109.created_date AS created_date_111, t109.updated_date AS updated_date_112, t109.client_updated_date AS client_updated_date_113, t109.name AS name_114, t109.type AS type_115, t109.agree_rgpd AS agree_rgpd_116, t109.description AS description_117, t109.address_number AS address_number_118, t109.address_locality AS address_locality_119, t109.address_road AS address_road_120, t109.phone_standard AS phone_standard_121, t109.phone_other AS phone_other_122, t109.email AS email_123, t109.latitude AS latitude_124, t109.longitude AS longitude_125, t109.maps_address AS maps_address_126, t109.other_activity1 AS other_activity1_127, t109.other_activity2 AS other_activity2_128, t109.other_activity3 AS other_activity3_129, t109.other_activity4 AS other_activity4_130, t109.other_activity5 AS other_activity5_131, t109.other_activity6 AS other_activity6_132, t109.registration AS registration_133, t109.other_degree AS other_degree_134, t109.location_mode AS location_mode_135, t109.id_city AS id_city_136, t109.id_region AS id_region_137, t109.id_country AS id_country_138, t109.id_image AS id_image_139, t109.user_id AS user_id_140, t109.id_sector_area1 AS id_sector_area1_141, t109.id_sector_area2 AS id_sector_area2_142, t109.id_sector_area3 AS id_sector_area3_143, t109.id_sector_area4 AS id_sector_area4_144, t109.id_sector_area5 AS id_sector_area5_145, t109.id_sector_area6 AS id_sector_area6_146 FROM user t0 LEFT JOIN person_degree t23 ON t23.user_id = t0.id LEFT JOIN company t79 ON t79.user_id = t0.id LEFT JOIN school t109 ON t109.user_id = t0.id WHERE t0.phone = ? LIMIT 1
Parameters: 
[
  "+251911132974"
]
View formatted query    View runnable query    Explain query
2 0.73 ms 
SELECT t0.id AS id_1, t0.username AS username_2, t0.roles AS roles_3, t0.password AS password_4, t0.api_token AS api_token_5, t0.diaspora AS diaspora_6, t0.phone AS phone_7, t0.enabled AS enabled_8, t0.email AS email_9, t0.valid_code AS valid_code_10, t0.last_login AS last_login_11, t0.password_requested_at AS password_requested_at_12, t0.salt AS salt_13, t0.email_canonical AS email_canonical_14, t0.username_canonical AS username_canonical_15, t0.confirmation_token AS confirmation_token_16, t0.principal_school AS principal_school_17, t0.image_name AS image_name_18, t0.country_id AS country_id_19, t0.region_id AS region_id_20, t0.residence_country_id AS residence_country_id_21, t0.residence_region_id AS residence_region_id_22, t23.status AS status_24, t23.type AS type_25, t23.agree_rgpd AS agree_rgpd_26, t23.last_degree_year AS last_degree_year_27, t23.last_degree_month AS last_degree_month_28, t23.other_degree AS other_degree_29, t23.diaspora AS diaspora_30, t23.address_diaspora AS address_diaspora_31, t23.created_date AS created_date_32, t23.updated_date AS updated_date_33, t23.client_updated_date AS client_updated_date_34, t23.previousEndedContract AS previousEndedContract_35, t23.registration_student_school AS registration_student_school_36, t23.check_school AS check_school_37, t23.other_school AS other_school_38, t23.monthly_salary AS monthly_salary_39, t23.other_activity AS other_activity_40, t23.temporary_passwd AS temporary_passwd_41, t23.lastIdSatisfactionSalary AS lastIdSatisfactionSalary_42, t23.lastIdSatisfactionSearch AS lastIdSatisfactionSearch_43, t23.lastIdSatisfactionCreato AS lastIdSatisfactionCreato_44, t23.unlocked AS unlocked_45, t23.id AS id_46, t23.firstname AS firstname_47, t23.lastname AS lastname_48, t23.birth_date AS birth_date_49, t23.address_number AS address_number_50, t23.address_locality AS address_locality_51, t23.address_road AS address_road_52, t23.other_city AS other_city_53, t23.latitude AS latitude_54, t23.longitude AS longitude_55, t23.maps_address AS maps_address_56, t23.phone_mobile1 AS phone_mobile1_57, t23.phone_mobile2 AS phone_mobile2_58, t23.phone_mobile3 AS phone_mobile3_59, t23.phone_home AS phone_home_60, t23.phone_office AS phone_office_61, t23.location_mode AS location_mode_62, t23.email AS email_63, t23.sex AS sex_64, t23.residence_country_id AS residence_country_id_65, t23.residence_region_id AS residence_region_id_66, t23.id_degree AS id_degree_67, t23.school_id AS school_id_68, t23.lasted_company_id AS lasted_company_id_69, t23.activity_id AS activity_id_70, t23.id_sectorArea AS id_sectorArea_71, t23.lasted_contract_id AS lasted_contract_id_72, t23.lasted_company_id AS lasted_company_id_73, t23.user_id AS user_id_74, t23.id_city AS id_city_75, t23.id_region AS id_region_76, t23.id_country AS id_country_77, t23.id_image AS id_image_78, t79.id AS id_80, t79.name AS name_81, t79.url AS url_82, t79.created_date AS created_date_83, t79.updated_date AS updated_date_84, t79.client_updated_date AS client_updated_date_85, t79.other_city AS other_city_86, t79.address_number AS address_number_87, t79.address_locality AS address_locality_88, t79.address_road AS address_road_89, t79.phone_standard AS phone_standard_90, t79.phone_other AS phone_other_91, t79.email AS email_92, t79.temporary_passwd AS temporary_passwd_93, t79.latitude AS latitude_94, t79.longitude AS longitude_95, t79.maps_address AS maps_address_96, t79.location_fixed AS location_fixed_97, t79.agree_rgpd AS agree_rgpd_98, t79.location_mode AS location_mode_99, t79.unlocked AS unlocked_100, t79.id_city AS id_city_101, t79.id_region AS id_region_102, t79.id_country AS id_country_103, t79.id_contactCompany AS id_contactCompany_104, t79.id_sectorArea AS id_sectorArea_105, t79.id_legal_status AS id_legal_status_106, t79.user_id AS user_id_107, t79.id_image AS id_image_108, t109.id AS id_110, t109.created_date AS created_date_111, t109.updated_date AS updated_date_112, t109.client_updated_date AS client_updated_date_113, t109.name AS name_114, t109.type AS type_115, t109.agree_rgpd AS agree_rgpd_116, t109.description AS description_117, t109.address_number AS address_number_118, t109.address_locality AS address_locality_119, t109.address_road AS address_road_120, t109.phone_standard AS phone_standard_121, t109.phone_other AS phone_other_122, t109.email AS email_123, t109.latitude AS latitude_124, t109.longitude AS longitude_125, t109.maps_address AS maps_address_126, t109.other_activity1 AS other_activity1_127, t109.other_activity2 AS other_activity2_128, t109.other_activity3 AS other_activity3_129, t109.other_activity4 AS other_activity4_130, t109.other_activity5 AS other_activity5_131, t109.other_activity6 AS other_activity6_132, t109.registration AS registration_133, t109.other_degree AS other_degree_134, t109.location_mode AS location_mode_135, t109.id_city AS id_city_136, t109.id_region AS id_region_137, t109.id_country AS id_country_138, t109.id_image AS id_image_139, t109.user_id AS user_id_140, t109.id_sector_area1 AS id_sector_area1_141, t109.id_sector_area2 AS id_sector_area2_142, t109.id_sector_area3 AS id_sector_area3_143, t109.id_sector_area4 AS id_sector_area4_144, t109.id_sector_area5 AS id_sector_area5_145, t109.id_sector_area6 AS id_sector_area6_146 FROM user t0 LEFT JOIN person_degree t23 ON t23.user_id = t0.id LEFT JOIN company t79 ON t79.user_id = t0.id LEFT JOIN school t109 ON t109.user_id = t0.id WHERE t0.id = ?
Parameters: 
[
  21073
]
View formatted query    View runnable query    Explain query
3 0.38 ms 
SELECT t0.id AS id_1, t0.role AS role_2, t0.pseudo AS pseudo_3 FROM role t0 INNER JOIN user_role ON t0.id = user_role.role_id WHERE user_role.user_id = ?
Parameters: 
[
  21073
]
View formatted query    View runnable query    Explain query
4 0.66 ms 
SELECT t0.id AS id_1, t0.username AS username_2, t0.roles AS roles_3, t0.password AS password_4, t0.api_token AS api_token_5, t0.diaspora AS diaspora_6, t0.phone AS phone_7, t0.enabled AS enabled_8, t0.email AS email_9, t0.valid_code AS valid_code_10, t0.last_login AS last_login_11, t0.password_requested_at AS password_requested_at_12, t0.salt AS salt_13, t0.email_canonical AS email_canonical_14, t0.username_canonical AS username_canonical_15, t0.confirmation_token AS confirmation_token_16, t0.principal_school AS principal_school_17, t0.image_name AS image_name_18, t0.country_id AS country_id_19, t0.region_id AS region_id_20, t0.residence_country_id AS residence_country_id_21, t0.residence_region_id AS residence_region_id_22, t23.status AS status_24, t23.type AS type_25, t23.agree_rgpd AS agree_rgpd_26, t23.last_degree_year AS last_degree_year_27, t23.last_degree_month AS last_degree_month_28, t23.other_degree AS other_degree_29, t23.diaspora AS diaspora_30, t23.address_diaspora AS address_diaspora_31, t23.created_date AS created_date_32, t23.updated_date AS updated_date_33, t23.client_updated_date AS client_updated_date_34, t23.previousEndedContract AS previousEndedContract_35, t23.registration_student_school AS registration_student_school_36, t23.check_school AS check_school_37, t23.other_school AS other_school_38, t23.monthly_salary AS monthly_salary_39, t23.other_activity AS other_activity_40, t23.temporary_passwd AS temporary_passwd_41, t23.lastIdSatisfactionSalary AS lastIdSatisfactionSalary_42, t23.lastIdSatisfactionSearch AS lastIdSatisfactionSearch_43, t23.lastIdSatisfactionCreato AS lastIdSatisfactionCreato_44, t23.unlocked AS unlocked_45, t23.id AS id_46, t23.firstname AS firstname_47, t23.lastname AS lastname_48, t23.birth_date AS birth_date_49, t23.address_number AS address_number_50, t23.address_locality AS address_locality_51, t23.address_road AS address_road_52, t23.other_city AS other_city_53, t23.latitude AS latitude_54, t23.longitude AS longitude_55, t23.maps_address AS maps_address_56, t23.phone_mobile1 AS phone_mobile1_57, t23.phone_mobile2 AS phone_mobile2_58, t23.phone_mobile3 AS phone_mobile3_59, t23.phone_home AS phone_home_60, t23.phone_office AS phone_office_61, t23.location_mode AS location_mode_62, t23.email AS email_63, t23.sex AS sex_64, t23.residence_country_id AS residence_country_id_65, t23.residence_region_id AS residence_region_id_66, t23.id_degree AS id_degree_67, t23.school_id AS school_id_68, t23.lasted_company_id AS lasted_company_id_69, t23.activity_id AS activity_id_70, t23.id_sectorArea AS id_sectorArea_71, t23.lasted_contract_id AS lasted_contract_id_72, t23.lasted_company_id AS lasted_company_id_73, t23.user_id AS user_id_74, t23.id_city AS id_city_75, t23.id_region AS id_region_76, t23.id_country AS id_country_77, t23.id_image AS id_image_78, t79.id AS id_80, t79.name AS name_81, t79.url AS url_82, t79.created_date AS created_date_83, t79.updated_date AS updated_date_84, t79.client_updated_date AS client_updated_date_85, t79.other_city AS other_city_86, t79.address_number AS address_number_87, t79.address_locality AS address_locality_88, t79.address_road AS address_road_89, t79.phone_standard AS phone_standard_90, t79.phone_other AS phone_other_91, t79.email AS email_92, t79.temporary_passwd AS temporary_passwd_93, t79.latitude AS latitude_94, t79.longitude AS longitude_95, t79.maps_address AS maps_address_96, t79.location_fixed AS location_fixed_97, t79.agree_rgpd AS agree_rgpd_98, t79.location_mode AS location_mode_99, t79.unlocked AS unlocked_100, t79.id_city AS id_city_101, t79.id_region AS id_region_102, t79.id_country AS id_country_103, t79.id_contactCompany AS id_contactCompany_104, t79.id_sectorArea AS id_sectorArea_105, t79.id_legal_status AS id_legal_status_106, t79.user_id AS user_id_107, t79.id_image AS id_image_108, t109.id AS id_110, t109.created_date AS created_date_111, t109.updated_date AS updated_date_112, t109.client_updated_date AS client_updated_date_113, t109.name AS name_114, t109.type AS type_115, t109.agree_rgpd AS agree_rgpd_116, t109.description AS description_117, t109.address_number AS address_number_118, t109.address_locality AS address_locality_119, t109.address_road AS address_road_120, t109.phone_standard AS phone_standard_121, t109.phone_other AS phone_other_122, t109.email AS email_123, t109.latitude AS latitude_124, t109.longitude AS longitude_125, t109.maps_address AS maps_address_126, t109.other_activity1 AS other_activity1_127, t109.other_activity2 AS other_activity2_128, t109.other_activity3 AS other_activity3_129, t109.other_activity4 AS other_activity4_130, t109.other_activity5 AS other_activity5_131, t109.other_activity6 AS other_activity6_132, t109.registration AS registration_133, t109.other_degree AS other_degree_134, t109.location_mode AS location_mode_135, t109.id_city AS id_city_136, t109.id_region AS id_region_137, t109.id_country AS id_country_138, t109.id_image AS id_image_139, t109.user_id AS user_id_140, t109.id_sector_area1 AS id_sector_area1_141, t109.id_sector_area2 AS id_sector_area2_142, t109.id_sector_area3 AS id_sector_area3_143, t109.id_sector_area4 AS id_sector_area4_144, t109.id_sector_area5 AS id_sector_area5_145, t109.id_sector_area6 AS id_sector_area6_146 FROM user t0 LEFT JOIN person_degree t23 ON t23.user_id = t0.id LEFT JOIN company t79 ON t79.user_id = t0.id LEFT JOIN school t109 ON t109.user_id = t0.id WHERE t0.username = ? LIMIT 1
Parameters: 
[
  "+251911132974"
]
View formatted query    View runnable query    Explain query

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\PersonDegree
  • The field App\Entity\PersonDegree#satisfactionSalaries is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\SatisfactionSalary#personDegree does not contain the required 'inversedBy="satisfactionSalaries"' attribute.
  • The field App\Entity\PersonDegree#satisfactionSearches is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\SatisfactionSearch#personDegree does not contain the required 'inversedBy="satisfactionSearches"' attribute.
  • The field App\Entity\PersonDegree#satisfactionCreators is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\SatisfactionCreator#personDegree does not contain the required 'inversedBy="satisfactionCreators"' attribute.
App\Entity\School
  • The field App\Entity\School#personDegrees is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\PersonDegree#school does not contain the required 'inversedBy="personDegrees"' attribute.
App\Entity\Company
  • The field App\Entity\Company#salaries is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\PersonDegree#company does not contain the required 'inversedBy="salaries"' attribute.
  • The field App\Entity\Company#apprentices is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Apprentice#company does not contain the required 'inversedBy="apprentices"' attribute.
  • The field App\Entity\Company#satisfactionCompanies is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\SatisfactionCompany#company does not contain the required 'inversedBy="satisfactionCompanies"' attribute.
  • The field App\Entity\Company#schools is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\School#companies does not contain the required 'inversedBy="schools"' attribute.
App\Entity\User
  • The field App\Entity\User#school is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\School#user does not contain the required 'inversedBy="school"' attribute.
App\Entity\Country No errors.
App\Entity\Region
  • The association App\Entity\Region#currency refers to the inverse side field App\Entity\Currency#regions which does not exist.
  • The association App\Entity\Region#prefectures refers to the owning side field App\Entity\Prefecture#regions which does not exist.
App\Entity\Degree
  • The association App\Entity\Degree#schools refers to the owning side field App\Entity\School#degree which does not exist.
App\Entity\Activity
  • The association App\Entity\Activity#country refers to the owning side field App\Entity\Country#activity which does not exist.
App\Entity\SectorArea No errors.
App\Entity\Contract No errors.
App\Entity\City No errors.
App\Entity\Image No errors.
App\Entity\ContactCompany No errors.
App\Entity\LegalStatus No errors.
App\Entity\Role No errors.
App\Entity\SocialNetwork No errors.
App\Entity\JobOffer No errors.
App\Entity\Prefecture
  • The mappings App\Entity\Prefecture#region and App\Entity\Region#prefectures are inconsistent with each other.
App\Entity\SatisfactionCompany No errors.
App\Entity\SatisfactionSearch No errors.
App\Entity\JobNotFoundReason No errors.
App\Entity\SatisfactionSalary No errors.
App\Entity\SatisfactionCreator No errors.