https://fluentech.nanoe.net/fr/network/60/edit

Method
GET
HTTP Status
302
IP
216.73.216.42
Profiled on
Token
b63dc4

Query Metrics

1 Database Queries
1 Different statements
2.42 ms Query time
6 Invalid entities

Queries

Group similar statements

#▲ Time Info
1 2.42 ms 
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.status AS status_4, t0.localization_long AS localization_long_5, t0.localization_lat AS localization_lat_6, t0.address AS address_7, t0.quarter AS quarter_8, t0.zip AS zip_9, t0.city AS city_10, t0.date_start_construction AS date_start_construction_11, t0.date_start_service AS date_start_service_12, t0.date_end_service AS date_end_service_13, t0.date_creation AS date_creation_14, t0.date_update AS date_update_15, t0.active AS active_16, t0.check_updated AS check_updated_17, t0.ash_key AS ash_key_18, t0.permutation_key AS permutation_key_19, t0.workflow_state AS workflow_state_20, t0.project_number AS project_number_21, t0.prospect_number AS prospect_number_22, t0.network_number AS network_number_23, t0.stake_localization_long AS stake_localization_long_24, t0.stake_localization_lat AS stake_localization_lat_25, t0.total_power AS total_power_26, t0.total_storage_capacity AS total_storage_capacity_27, t0.total_voltage AS total_voltage_28, t0.total_cost AS total_cost_29, t0.total_wire_length AS total_wire_length_30, t0.total_max_power_consumption AS total_max_power_consumption_31, t0.total_consumption_day AS total_consumption_day_32, t0.commission_percentage AS commission_percentage_33, t0.commissions AS commissions_34, t0.nano_entrepreneur AS nano_entrepreneur_35, t0.comment AS comment_36, t0.cryptage AS cryptage_37, t0.deleted_at AS deleted_at_38, t0.zone_id AS zone_id_39, t0.owner_id AS owner_id_40, t0.country AS country_41 FROM network t0 WHERE t0.id = ? AND ((t0.deleted_at IS NULL))
Parameters: 
[
  "60"
]
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\Network
  • The field App\Entity\Network#devices is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\NetworkDevice#network does not contain the required 'inversedBy="devices"' attribute.
  • The field App\Entity\Network#customers is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Customer#network does not contain the required 'inversedBy="customers"' attribute.
  • The field App\Entity\Network#customerOperations is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\CustomerOperations#network does not contain the required 'inversedBy="customerOperations"' attribute.
  • The field App\Entity\Network#tensionRecords is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\TensionRecord#network does not contain the required 'inversedBy="tensionRecords"' attribute.
  • The field App\Entity\Network#reloadRecords is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\ReloadRecord#network does not contain the required 'inversedBy="reloadRecords"' attribute.
  • The field App\Entity\Network#aggTensionRecords is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\AggTensionRecord#network does not contain the required 'inversedBy="aggTensionRecords"' attribute.
  • The field App\Entity\Network#aggTransactionRecords is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\AggTransactionRecord#network does not contain the required 'inversedBy="aggTransactionRecords"' attribute.
  • The field App\Entity\Network#interventions is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Intervention#network does not contain the required 'inversedBy="interventions"' attribute.
  • The field App\Entity\Network#commissionEntrepreneurs is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Commission#network does not contain the required 'inversedBy="commissionEntrepreneurs"' attribute.
  • The field App\Entity\Network#nanoEntrepreneurs is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\NanoEntrepreneur#network does not contain the required 'inversedBy="nanoEntrepreneurs"' attribute.
  • The field App\Entity\Network#networkCustomerHistoric is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\NetworkCustomerHistoric#network does not contain the required 'inversedBy="networkCustomerHistoric"' attribute.
  • The field App\Entity\Network#generatedCodes is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\GeneratedCode#network does not contain the required 'inversedBy="generatedCodes"' attribute.
App\Entity\Zone
  • The field App\Entity\Zone#zoneLocalizations is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\ZoneLocalization#zone does not contain the required 'inversedBy="zoneLocalizations"' attribute.
  • The mappings App\Entity\Zone#user and App\Entity\Users#zone are inconsistent with each other.
  • The field App\Entity\Zone#customers is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Customer#zone does not contain the required 'inversedBy="customers"' attribute.
  • The field App\Entity\Zone#networks is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Network#zone does not contain the required 'inversedBy="networks"' attribute.
  • The field App\Entity\Zone#readOnly is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\ReadOnly#zone does not contain the required 'inversedBy="readOnly"' attribute.
FOS\UserBundle\Model\User No errors.
App\Entity\Users
  • The field App\Entity\Users#networks is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Network#owner does not contain the required 'inversedBy="networks"' attribute.
  • The field App\Entity\Users#alerts is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\AlertSuperClass#user does not contain the required 'inversedBy="alerts"' attribute.
  • The field App\Entity\Users#aggTransactionRecords is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\AggTransactionRecord#contractor does not contain the required 'inversedBy="aggTransactionRecords"' attribute.
  • The field App\Entity\Users#investigatedCustomers is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Customer#investigator does not contain the required 'inversedBy="investigatedCustomers"' attribute.
  • The field App\Entity\Users#tasks is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Task#creator does not contain the required 'inversedBy="tasks"' attribute.
  • The association App\Entity\Users#zone refers to the inverse side field App\Entity\Zone#users which does not exist.
  • The field App\Entity\Users#readOnly is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\ReadOnly#user does not contain the required 'inversedBy="readOnly"' attribute.
  • The field App\Entity\Users#nanoEntrepreneurs is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\NanoEntrepreneur#owner does not contain the required 'inversedBy="nanoEntrepreneurs"' attribute.
  • The field App\Entity\Users#userCaisses is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\UserCaisse#user does not contain the required 'inversedBy="userCaisses"' attribute.
  • The association App\Entity\Users#locaux refers to the inverse side field App\Entity\LocalAgence#users which does not exist.
App\Entity\CommonCountry No errors.
App\Entity\NetworkDevice No errors.
App\Entity\Customer
  • The field App\Entity\Customer#devices is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\DeviceCustomer#customer does not contain the required 'inversedBy="devices"' attribute.
  • The field App\Entity\Customer#offerChangeHistorics is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\OfferChangeHistoric#customer does not contain the required 'inversedBy="offerChangeHistorics"' attribute.
  • The field App\Entity\Customer#transactions is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Transaction#customer does not contain the required 'inversedBy="transactions"' attribute.
  • The field App\Entity\Customer#customerOperations is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\CustomerOperations#customer does not contain the required 'inversedBy="customerOperations"' attribute.
  • The field App\Entity\Customer#generatedCodes is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\GeneratedCode#customer does not contain the required 'inversedBy="generatedCodes"' attribute.
  • The field App\Entity\Customer#intensityRecords is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\IntensityRecord#customer does not contain the required 'inversedBy="intensityRecords"' attribute.
  • The field App\Entity\Customer#eventRecords is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\EventRecord#customer does not contain the required 'inversedBy="eventRecords"' attribute.
  • The field App\Entity\Customer#offerConsumptionRecords is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\OfferConsumptionRecord#customer does not contain the required 'inversedBy="offerConsumptionRecords"' attribute.
  • The field App\Entity\Customer#aggCreditRecords is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\AggCreditRecord#customer does not contain the required 'inversedBy="aggCreditRecords"' attribute.
  • The field App\Entity\Customer#aggIntensityRecords is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\AggIntensityRecord#customer does not contain the required 'inversedBy="aggIntensityRecords"' attribute.
  • The field App\Entity\Customer#aggTransactionRecords is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\AggTransactionRecord#customer does not contain the required 'inversedBy="aggTransactionRecords"' attribute.
App\Entity\CustomerOperations
  • The field App\Entity\CustomerOperations#operationsCaisses is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\CustomerOperationsCaisse#operation does not contain the required 'inversedBy="operationsCaisses"' attribute.
App\Entity\TensionRecord No errors.
App\Entity\ReloadRecord No errors.
App\Entity\AggTensionRecord No errors.
App\Entity\AggTransactionRecord No errors.
App\Entity\Intervention No errors.
App\Entity\Commission No errors.
App\Entity\NanoEntrepreneur No errors.
App\Entity\NetworkCustomerHistoric No errors.
App\Entity\GeneratedCode
  • The field App\Entity\GeneratedCode#reloadRecords is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\ReloadRecord#generatedCode does not contain the required 'inversedBy="reloadRecords"' attribute.
  • The field App\Entity\GeneratedCode#aggCreditRecords is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\AggCreditRecord#reloadGeneratedCode does not contain the required 'inversedBy="aggCreditRecords"' attribute.
App\Entity\Stock No errors.