Symfony Profiler

Query Metrics

16 Database Queries

11 Different statements

32.70 ms Query time

19 Invalid entities

Queries


SELECT t0.id AS id_1, t0.email AS email_2, t0.password AS password_3, t0.username AS username_4, t0.address AS address_5, t0.roles AS roles_6, t0.company_relation AS company_relation_7, t0.avatar AS avatar_8, t0.phone AS phone_9, t0.birth_date AS birth_date_10, t0.card_number AS card_number_11, t0.cad_date_issue AS cad_date_issue_12, t0.card_expiry_date AS card_expiry_date_13, t0.license_number AS license_number_14, t0.license_date_issue AS license_date_issue_15, t0.license_expiry_date AS license_expiry_date_16, t0.stripecustomerid AS stripecustomerid_17, t0.phones AS phones_18, t0.discount_limit AS discount_limit_19, t0.points AS points_20, t0.deleted_at AS deleted_at_21, t0.reset_token AS reset_token_22, t0.reset_token_expires_at AS reset_token_expires_at_23, t0.visa_card_number AS visa_card_number_24, t0.car_transferred_points AS car_transferred_points_25, t0.created_at AS created_at_26, t0.updated_at AS updated_at_27, t0.user_id AS user_id_28, t0.company_id AS company_id_29, t0.role_id AS role_id_30, t0.company_agency_id AS company_agency_id_31, t0.country_id AS country_id_32, t0.created_by_id AS created_by_id_33, t34.id AS id_35, t34.deleted_at AS deleted_at_36, t34.status AS status_37, t34.created_at AS created_at_38, t34.updated_at AS updated_at_39, t34.badge_id AS badge_id_40, t34.customer_id AS customer_id_41, t34.affected_by_id AS affected_by_id_42, t34.company_id AS company_id_43, t0.user_organization_id AS user_organization_id_44 FROM user_company t0 LEFT JOIN user_badge t34 ON t34.customer_id = t0.id WHERE t0.email = ? AND ((t0.deleted_at IS NULL)) LIMIT 1
SELECT t0.id AS id_1, t0.star_date AS star_date_2, t0.end_date AS end_date_3, t0.start_date_transfer AS start_date_transfer_4, t0.end_date_transfer AS end_date_transfer_5, t0.deleted_at AS deleted_at_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.authority_role_id AS authority_role_id_9, t0.user_company_id AS user_company_id_10, t0.transfer_to_id AS transfer_to_id_11 FROM user_role t0 WHERE t0.user_company_id IN (?) AND ((t0.deleted_at IS NULL))
SELECT t0.id AS id_1, t0.label AS label_2, t0.code AS code_3, t0.flag AS flag_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6 FROM language t0 WHERE t0.code = ? LIMIT 1
SELECT c0_.id AS id_0, c0_.phone AS phone_1, c0_.fax AS fax_2, c0_.repair_center AS repair_center_3, c0_.email AS email_4, c0_.latitude AS latitude_5, c0_.longitude AS longitude_6, c0_.location AS location_7, c0_.phones AS phones_8, c0_.created_at AS created_at_9, c0_.updated_at AS updated_at_10, COUNT(c1_.id) AS sclr_11, c0_.company_id AS company_id_12, c0_.created_by_id AS created_by_id_13, c0_.updated_by_id AS updated_by_id_14, c0_.city_id AS city_id_15 FROM company_agency c0_ INNER JOIN company c2_ ON c0_.company_id = c2_.id AND (c2_.deleted_at IS NULL) INNER JOIN company_agency_translate c3_ ON c0_.id = c3_.company_agency_id LEFT JOIN car c1_ ON c0_.id = c1_.company_agency_id AND (c1_.deleted_at IS NULL) WHERE c3_.language_id = ? AND c2_.id = ? AND LOWER(c3_.name) LIKE ? GROUP BY c0_.id ORDER BY c0_.created_at DESC
SELECT t0.id AS id_1, t0.name AS name_2, t0.address AS address_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.company_agency_id AS company_agency_id_6, t0.language_id AS language_id_7, t0.user_id AS user_id_8 FROM company_agency_translate t0 WHERE t0.company_agency_id = ?
SELECT t0.id AS id_1, t0.phone AS phone_2, t0.email AS email_3, t0.website AS website_4, t0.tax_number AS tax_number_5, t0.logo AS logo_6, t0.fax AS fax_7, t0.type AS type_8, t0.longitude AS longitude_9, t0.latitude AS latitude_10, t0.online_payment AS online_payment_11, t0.cash_payment AS cash_payment_12, t0.phones AS phones_13, t0.installment_payment AS installment_payment_14, t0.deleted_at AS deleted_at_15, t0.vat AS vat_16, t0.letter_head AS letter_head_17, t0.company_number AS company_number_18, t0.last_import_violation AS last_import_violation_19, t0.last_violation_number AS last_violation_number_20, t0.footer_content AS footer_content_21, t0.booking_notification_duration AS booking_notification_duration_22, t0.is_new_partner AS is_new_partner_23, t0.agent_request_point AS agent_request_point_24, t0.agent_response_point AS agent_response_point_25, t0.booking_transfer_point AS booking_transfer_point_26, t0.created_at AS created_at_27, t0.updated_at AS updated_at_28, t29.id AS id_30, t29.primary_color AS primary_color_31, t29.secondary_color AS secondary_color_32, t29.favicon AS favicon_33, t29.logo AS logo_34, t29.active AS active_35, t29.disable AS disable_36, t29.lable AS lable_37, t29.button AS button_38, t29.border AS border_39, t29.danger AS danger_40, t29.created_at AS created_at_41, t29.updated_at AS updated_at_42, t29.company_id AS company_id_43, t0.country_id AS country_id_44, t0.company_type_id AS company_type_id_45, t46.id AS id_47, t46.created_at AS created_at_48, t46.updated_at AS updated_at_49, t46.country_id AS country_id_50, t46.company_id AS company_id_51, t0.booking_charge_id AS booking_charge_id_52 FROM company t0 LEFT JOIN company_setting t29 ON t29.company_id = t0.id LEFT JOIN terms t46 ON t46.company_id = t0.id WHERE t0.id = ? AND ((t0.deleted_at IS NULL))
SELECT t0.id AS id_1, t0.name AS name_2, t0.address AS address_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.company_id AS company_id_6, t0.language_id AS language_id_7 FROM company_translate t0 WHERE t0.company_id = ?
SELECT t0.id AS id_1, t0.label AS label_2, t0.code AS code_3, t0.flag AS flag_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6 FROM language t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.email AS email_2, t0.password AS password_3, t0.username AS username_4, t0.address AS address_5, t0.roles AS roles_6, t0.company_relation AS company_relation_7, t0.avatar AS avatar_8, t0.phone AS phone_9, t0.birth_date AS birth_date_10, t0.card_number AS card_number_11, t0.cad_date_issue AS cad_date_issue_12, t0.card_expiry_date AS card_expiry_date_13, t0.license_number AS license_number_14, t0.license_date_issue AS license_date_issue_15, t0.license_expiry_date AS license_expiry_date_16, t0.stripecustomerid AS stripecustomerid_17, t0.phones AS phones_18, t0.discount_limit AS discount_limit_19, t0.points AS points_20, t0.deleted_at AS deleted_at_21, t0.reset_token AS reset_token_22, t0.reset_token_expires_at AS reset_token_expires_at_23, t0.visa_card_number AS visa_card_number_24, t0.car_transferred_points AS car_transferred_points_25, t0.created_at AS created_at_26, t0.updated_at AS updated_at_27, t0.user_id AS user_id_28, t0.company_id AS company_id_29, t0.role_id AS role_id_30, t0.company_agency_id AS company_agency_id_31, t0.country_id AS country_id_32, t0.created_by_id AS created_by_id_33, t34.id AS id_35, t34.deleted_at AS deleted_at_36, t34.status AS status_37, t34.created_at AS created_at_38, t34.updated_at AS updated_at_39, t34.badge_id AS badge_id_40, t34.customer_id AS customer_id_41, t34.affected_by_id AS affected_by_id_42, t34.company_id AS company_id_43, t0.user_organization_id AS user_organization_id_44 FROM user_company t0 LEFT JOIN user_badge t34 ON t34.customer_id = t0.id WHERE t0.company_agency_id = ? AND ((t0.deleted_at IS NULL))
SELECT t0.id AS id_1, t0.name AS name_2, t0.address AS address_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.company_agency_id AS company_agency_id_6, t0.language_id AS language_id_7, t0.user_id AS user_id_8 FROM company_agency_translate t0 WHERE t0.company_agency_id = ?
SELECT t0.id AS id_1, t0.email AS email_2, t0.password AS password_3, t0.username AS username_4, t0.address AS address_5, t0.roles AS roles_6, t0.company_relation AS company_relation_7, t0.avatar AS avatar_8, t0.phone AS phone_9, t0.birth_date AS birth_date_10, t0.card_number AS card_number_11, t0.cad_date_issue AS cad_date_issue_12, t0.card_expiry_date AS card_expiry_date_13, t0.license_number AS license_number_14, t0.license_date_issue AS license_date_issue_15, t0.license_expiry_date AS license_expiry_date_16, t0.stripecustomerid AS stripecustomerid_17, t0.phones AS phones_18, t0.discount_limit AS discount_limit_19, t0.points AS points_20, t0.deleted_at AS deleted_at_21, t0.reset_token AS reset_token_22, t0.reset_token_expires_at AS reset_token_expires_at_23, t0.visa_card_number AS visa_card_number_24, t0.car_transferred_points AS car_transferred_points_25, t0.created_at AS created_at_26, t0.updated_at AS updated_at_27, t0.user_id AS user_id_28, t0.company_id AS company_id_29, t0.role_id AS role_id_30, t0.company_agency_id AS company_agency_id_31, t0.country_id AS country_id_32, t0.created_by_id AS created_by_id_33, t34.id AS id_35, t34.deleted_at AS deleted_at_36, t34.status AS status_37, t34.created_at AS created_at_38, t34.updated_at AS updated_at_39, t34.badge_id AS badge_id_40, t34.customer_id AS customer_id_41, t34.affected_by_id AS affected_by_id_42, t34.company_id AS company_id_43, t0.user_organization_id AS user_organization_id_44 FROM user_company t0 LEFT JOIN user_badge t34 ON t34.customer_id = t0.id WHERE t0.company_agency_id = ? AND ((t0.deleted_at IS NULL))
SELECT t0.id AS id_1, t0.name AS name_2, t0.address AS address_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.company_agency_id AS company_agency_id_6, t0.language_id AS language_id_7, t0.user_id AS user_id_8 FROM company_agency_translate t0 WHERE t0.company_agency_id = ?
SELECT t0.id AS id_1, t0.email AS email_2, t0.password AS password_3, t0.username AS username_4, t0.address AS address_5, t0.roles AS roles_6, t0.company_relation AS company_relation_7, t0.avatar AS avatar_8, t0.phone AS phone_9, t0.birth_date AS birth_date_10, t0.card_number AS card_number_11, t0.cad_date_issue AS cad_date_issue_12, t0.card_expiry_date AS card_expiry_date_13, t0.license_number AS license_number_14, t0.license_date_issue AS license_date_issue_15, t0.license_expiry_date AS license_expiry_date_16, t0.stripecustomerid AS stripecustomerid_17, t0.phones AS phones_18, t0.discount_limit AS discount_limit_19, t0.points AS points_20, t0.deleted_at AS deleted_at_21, t0.reset_token AS reset_token_22, t0.reset_token_expires_at AS reset_token_expires_at_23, t0.visa_card_number AS visa_card_number_24, t0.car_transferred_points AS car_transferred_points_25, t0.created_at AS created_at_26, t0.updated_at AS updated_at_27, t0.user_id AS user_id_28, t0.company_id AS company_id_29, t0.role_id AS role_id_30, t0.company_agency_id AS company_agency_id_31, t0.country_id AS country_id_32, t0.created_by_id AS created_by_id_33, t34.id AS id_35, t34.deleted_at AS deleted_at_36, t34.status AS status_37, t34.created_at AS created_at_38, t34.updated_at AS updated_at_39, t34.badge_id AS badge_id_40, t34.customer_id AS customer_id_41, t34.affected_by_id AS affected_by_id_42, t34.company_id AS company_id_43, t0.user_organization_id AS user_organization_id_44 FROM user_company t0 LEFT JOIN user_badge t34 ON t34.customer_id = t0.id WHERE t0.company_agency_id = ? AND ((t0.deleted_at IS NULL))
SELECT t0.id AS id_1, t0.star_date AS star_date_2, t0.end_date AS end_date_3, t0.start_date_transfer AS start_date_transfer_4, t0.end_date_transfer AS end_date_transfer_5, t0.deleted_at AS deleted_at_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.authority_role_id AS authority_role_id_9, t0.user_company_id AS user_company_id_10, t0.transfer_to_id AS transfer_to_id_11 FROM user_role t0 WHERE t0.user_company_id IN (?) AND ((t0.deleted_at IS NULL))
SELECT t0.id AS id_1, t0.first_name AS first_name_2, t0.last_name AS last_name_3, t0.nationality AS nationality_4, t0.id_card_type AS id_card_type_5, t0.address AS address_6, t0.card_place_issue AS card_place_issue_7, t0.license_place_issue AS license_place_issue_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.user_company_id AS user_company_id_11, t0.language_id AS language_id_12 FROM user_company_translate t0 WHERE t0.user_company_id = ?
SELECT t0.id AS id_1, t0.role AS role_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4 FROM role t0 WHERE t0.id = ?

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
Gesdinet\JWTRefreshTokenBundle\Entity\RefreshToken	No errors.
App\Entity\RefreshToken	No errors.
App\Entity\UserCompany	The association App\Entity\UserCompany#companies refers to the owning side field App\Entity\Company#createdBy which does not exist. The association App\Entity\UserCompany#incomes refers to the owning side field App\Entity\Income#userCompany which does not exist.
App\Entity\User	No errors.
App\Entity\Company	No errors.
App\Entity\Role	No errors.
App\Entity\CompanyAgency	The mappings App\Entity\CompanyAgency#updatedBy and App\Entity\UserCompany#companyAgencies are inconsistent with each other.
App\Entity\Country	No errors.
App\Entity\UserBadge	No errors.
App\Entity\Badge	No errors.
App\Entity\UserOrganization	No errors.
App\Entity\UserRole	No errors.
App\Entity\UserCompanyTranslate	No errors.
App\Entity\OptionValue	No errors.
App\Entity\Booking	The mappings App\Entity\Booking#checkedOutBy and App\Entity\UserCompany#bookingsChecked are inconsistent with each other. The mappings App\Entity\Booking#driverBy and App\Entity\UserCompany#bookingsChecked are inconsistent with each other.
App\Entity\Car	The mappings App\Entity\Car#updatedBy and App\Entity\UserCompany#cars are inconsistent with each other.
App\Entity\Invoice	The association App\Entity\Invoice#bank refers to the inverse side field App\Entity\Bank#invoices which does not exist.
App\Entity\Maintenance	No errors.
App\Entity\DamageType	No errors.
App\Entity\PaymentMethod	The association App\Entity\PaymentMethod#bookings refers to the owning side field App\Entity\Booking#paymentMethod which is not defined as association, but as field. The association App\Entity\PaymentMethod#bookings refers to the owning side field App\Entity\Booking#paymentMethod which does not exist.
App\Entity\NotificationUser	No errors.
App\Entity\Favori	No errors.
App\Entity\UserHistory	No errors.
App\Entity\FeedBack	No errors.
App\Entity\Ressource	No errors.
App\Entity\MaintenanceBuy	No errors.
App\Entity\Chat	No errors.
App\Entity\Message	No errors.
App\Entity\Support	No errors.
App\Entity\SupportResponse	No errors.
App\Entity\Subscription	No errors.
App\Entity\Request	No errors.
App\Entity\RequestPartnerCar	No errors.
App\Entity\CarExpense	No errors.
App\Entity\BookingPackage	No errors.
App\Entity\AuthorityRole	No errors.
App\Entity\RequestDiscount	No errors.
App\Entity\UserPoint	No errors.
App\Entity\BlackList	The mappings App\Entity\BlackList#createdBy and App\Entity\UserCompany#blackLists are inconsistent with each other.
App\Entity\Insurance	No errors.
App\Entity\VehicleLicense	No errors.
App\Entity\PaymentInstallment	The mappings App\Entity\PaymentInstallment#income and App\Entity\Income#paymentInstallments are inconsistent with each other.
App\Entity\Bank	No errors.
App\Entity\Violation	No errors.
App\Entity\Income	The mappings App\Entity\Income#incomeTranslates and App\Entity\IncomeTranslate#income are inconsistent with each other. The mappings App\Entity\Income#customer and App\Entity\UserCompany#incomes are inconsistent with each other. The field App\Entity\Income#bookingGuarantee is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Booking#incomeGuarantee does not contain the required 'inversedBy="bookingGuarantee"' attribute.
App\Entity\Expense	The field App\Entity\Expense#bookingGuarantee is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Booking#expenseGuarantee does not contain the required 'inversedBy="bookingGuarantee"' attribute.
App\Entity\CompanyCustomer	No errors.
App\Entity\CustomerDelivery	No errors.
App\Entity\Partner	The mappings App\Entity\Partner#companyPartner and App\Entity\Company#partners are inconsistent with each other. The mappings App\Entity\Partner#companyAgencyPartner and App\Entity\CompanyAgency#partners are inconsistent with each other.
App\Entity\PartnerCar	No errors.
App\Entity\Language	The association App\Entity\Language#optionTranslates refers to the owning side field App\Entity\OptionTranslate#langauge which does not exist.
App\Entity\UserTranslate	No errors.
App\Entity\CompanyTranslate	No errors.
App\Entity\AuthorityActionTranslate	No errors.
App\Entity\CompanyAgencyTranslate	The association App\Entity\CompanyAgencyTranslate#user refers to the inverse side field App\Entity\UserCompany#companyAgencyTranslate which does not exist.
App\Entity\CarTranslate	No errors.
App\Entity\OptionTranslate	The mappings App\Entity\OptionTranslate#language and App\Entity\Language#optionTranslates are inconsistent with each other.
App\Entity\OptionValueTranslate	No errors.
App\Entity\DamageTypeTranslate	No errors.
App\Entity\MaintenanceTranslate	No errors.
App\Entity\PaymentMethodTranslate	No errors.
App\Entity\NotificationTemplateTranslate	No errors.
App\Entity\AuthorityModuleTranslate	No errors.
App\Entity\BookingTypeTranslate	No errors.
App\Entity\CityTranslate	No errors.
App\Entity\CountryTranslate	No errors.
App\Entity\AuthorityRoleTranslate	No errors.
App\Entity\UserHistoryTranslate	No errors.
App\Entity\CompanyTypeTranslate	No errors.
App\Entity\PurchaseTypeTranslate	No errors.
App\Entity\InsuranceTypeTranslate	No errors.
App\Entity\MaintenanceTypeTranslate	No errors.
App\Entity\CarPropertyTranslate	No errors.
App\Entity\CurrencyTranslate	No errors.
App\Entity\CarCategoryTranslate	No errors.
App\Entity\MaintenanceBuyTranslate	No errors.
App\Entity\TermsTranslate	No errors.
App\Entity\IncomeTranslate	The association App\Entity\IncomeTranslate#income refers to the inverse side field App\Entity\Income#incometranslates which does not exist.
App\Entity\IncomeTypeTranslate	The association App\Entity\IncomeTypeTranslate#incomeType refers to the inverse side field App\Entity\IncomeType#incometypeTranslates which does not exist.
App\Entity\ExpenseTypeTranslate	No errors.
App\Entity\ExpenseTranslate	No errors.
App\Entity\PackageTranslate	No errors.
App\Entity\CarOptionTranslate	No errors.
App\Entity\CarExpenseTranslate	No errors.
App\Entity\PenaltyTranslate	No errors.
App\Entity\VersionOptionTranslate	No errors.
App\Entity\BadgeTranslate	No errors.
App\Entity\UserOrganizationTranslate	No errors.
App\Entity\ColorTranslate	No errors.
App\Entity\BankTranslate	No errors.
App\Entity\LetterSettingTranslate	No errors.
App\Entity\LetterToTranslate	No errors.
App\Entity\ViolationTypeTranslate	The association App\Entity\ViolationTypeTranslate#violationType refers to the inverse side field App\Entity\ViolationType#violationTypeTRanslates which does not exist.
App\Entity\CarTypeTranslate	No errors.
App\Entity\MarkTranslate	No errors.
App\Entity\Modeltranslate	No errors.
App\Entity\VersionTranslate	No errors.
App\Entity\CarLevelTranslate	No errors.
App\Entity\FundingTypeTranslate	No errors.
App\Entity\City	No errors.
App\Entity\BookingCar	No errors.
App\Entity\Contract	No errors.
App\Entity\Station	No errors.
App\Entity\CompanySetting	No errors.
App\Entity\CompanyType	No errors.
App\Entity\Terms	No errors.
App\Entity\BookingCharge	The field 'App\Entity\BookingCharge#pricePerKm' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type. The field 'App\Entity\BookingCharge#pricePerKmToPickup' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type.
App\Entity\CarOption	No errors.
App\Entity\Penalty	No errors.
App\Entity\LoyaltyCard	No errors.
App\Entity\Package	No errors.
App\Entity\LetterSetting	No errors.
App\Entity\LetterTo	No errors.
App\Entity\VatSetting	No errors.
App\Entity\ViolationType	The mappings App\Entity\ViolationType#violationTypeTranslates and App\Entity\ViolationTypeTranslate#violationType are inconsistent with each other.
App\Entity\ContractPackage	No errors.
App\Entity\CompanyUserOrganization	No errors.
App\Entity\TermsFullInsurance	No errors.
App\Entity\ImportedFile	No errors.

Symfony Profiler

GET https://api-car.demo-projects.ifbegin.com/api/v1/companyAgency/bycompany?localeLang=ar&withPagination=false

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Entities Mapping