GET http://172.16.61.85:4600/api/ref_energies

Query Metrics

6 Database Queries
6 Different statements
5.91 ms Query time
4 Invalid entities

Queries

Group similar statements

default connection

# Time Info
1 2.80 ms
SELECT t0.id AS id_1, t0.civility AS civility_2, t0.image AS image_3, t0.firstname AS firstname_4, t0.lastname AS lastname_5, t0.phone AS phone_6, t0.cgv AS cgv_7, t0.email AS email_8, t0.password AS password_9, t0.roles AS roles_10, t0.stripe_customer_id AS stripe_customer_id_11, t0.sage_customer_id AS sage_customer_id_12, t0.social_reason AS social_reason_13, t0.neofleet AS neofleet_14, t0.channel AS channel_15, t0.position AS position_16, t0.admin AS admin_17, t0.renewability_thresholds AS renewability_thresholds_18, t0.neoplaque_config AS neoplaque_config_19, t0.business_central_id AS business_central_id_20, t0.business_central_num AS business_central_num_21, t0.deleted_at AS deleted_at_22, t0.created_at AS created_at_23, t0.updated_at AS updated_at_24, t0.status_id AS status_id_25, t0.job_id AS job_id_26, t0.sector_id AS sector_id_27, t0.usage_id AS usage_id_28, t0.company_id AS company_id_29, t30.id AS id_31, t30.sage_company_id AS sage_company_id_32, t30.stripe_customer_id AS stripe_customer_id_33, t30.name AS name_34, t30.name_complement AS name_complement_35, t30.phone AS phone_36, t30.accountancy_emails AS accountancy_emails_37, t30.siret AS siret_38, t30.customer_code AS customer_code_39, t30.vat_rate AS vat_rate_40, t30.channel AS channel_41, t30.address AS address_42, t30.bad_payer AS bad_payer_43, t30.accountant_email AS accountant_email_44, t30.business_central_id AS business_central_id_45, t30.business_central_num AS business_central_num_46, t30.deleted_at AS deleted_at_47, t30.created_at AS created_at_48, t30.updated_at AS updated_at_49, t30.payment_methods_allowed_methods AS payment_methods_allowed_methods_50, t30.payment_limits_limits AS payment_limits_limits_51, t30.owner_id AS owner_id_52, t30.sector_id AS sector_id_53, t30.status_id AS status_id_54 FROM "user" t0 LEFT JOIN company t30 ON t30.owner_id = t0.id WHERE t0.email = ? AND ((t0.deleted_at IS NULL)) LIMIT 1
Parameters:
[
  "jblondeau@dataneo.fr"
]
2 0.87 ms
SELECT t0.id AS id_1, t0.code AS code_2, t0.area AS area_3, t0.description AS description_4, t0.zc_custom AS zc_custom_5, t0.deleted_at AS deleted_at_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.company_id AS company_id_9, t0.brand_id AS brand_id_10, t0.status_id AS status_id_11 FROM dealership t0 WHERE t0.id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
  "1ee950cc-2fd8-67bc-ad7b-03163a0bc151"
]
3 0.57 ms
SELECT t0.id AS id_1, t0.employee_id AS employee_id_2, t0.role_id AS role_id_3, t0.dealership_id AS dealership_id_4, t0.subscription_licence_id AS subscription_licence_id_5 FROM user_dealership t0 WHERE t0.dealership_id = ?
Parameters:
[
  "1ee950cc-2fd8-67bc-ad7b-03163a0bc151"
]
4 0.80 ms
SELECT t0.id AS id_1, t0.field AS field_2, t0.code AS code_3, t0.title AS title_4, t0.description AS description_5, t0.comment AS comment_6, t0.value AS value_7, t0.position AS position_8, t0.deleted_at AS deleted_at_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.parent_code_id AS parent_code_id_12 FROM code t0 WHERE t0.id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
  "1ec41710-58be-6df4-90be-4326b70135fd"
]
5 0.56 ms
SELECT count(r0_.id) AS sclr_0 FROM ref_energy r0_
Parameters:
[]
6 0.31 ms
SELECT r0_.id AS id_0, r0_.name AS name_1, r0_.family AS family_2 FROM ref_energy r0_ ORDER BY r0_.id ASC LIMIT 30
Parameters:
[]

Database Connections

Name Service
default doctrine.dbal.default_connection
crm doctrine.dbal.crm_connection
ddi doctrine.dbal.ddi_connection
neo doctrine.dbal.neo_connection
stat doctrine.dbal.stat_connection
marketref doctrine.dbal.marketref_connection
cmco doctrine.dbal.cmco_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\RefEnergy No errors.
Gesdinet\JWTRefreshTokenBundle\Entity\RefreshToken No errors.
App\Entity\RefreshToken No errors.
App\Entity\User
  • The field App\Entity\User#catchmentAreas is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\CatchmentArea#owner does not contain the required 'inversedBy="catchmentAreas"' attribute.
App\Entity\Code No errors.
App\Entity\Embeddable\PaymentMethods No errors.
App\Entity\Embeddable\PaymentLimits No errors.
App\Entity\Company No errors.
App\Entity\UserDealership No errors.
App\Entity\Goal No errors.
App\Entity\Template
  • The field 'App\Entity\Template#hits' has the property type 'int' that differs from the metadata field type 'string' returned by the 'bigint' DBAL type.
App\Entity\Listing No errors.
App\Entity\Comment No errors.
App\Entity\Task No errors.
App\Entity\CatchmentArea No errors.
App\Entity\CatchmentAreaAddress No errors.
App\Entity\Command No errors.
App\Entity\SessionLogin No errors.
App\Entity\Dealership
  • The association App\Entity\Dealership#companySheetInfos refers to the owning side field App\Entity\CompanySheetInfo#dealership_id which does not exist.
App\Entity\Brand No errors.
App\Entity\Criteria No errors.
App\Entity\CompanySheetInfo
  • The mappings App\Entity\CompanySheetInfo#dealership and App\Entity\Dealership#companySheetInfos are inconsistent with each other.
App\Entity\SubscriptionLicence No errors.
App\Entity\Access No errors.