301 redirect from GET @shop_agent (4fa127)

Query Metrics

7 Database Queries
6 Different statements
24.49 ms Query time
7 Invalid entities

Grouped Statements

Show all queries

default connection

Time▼ Count Info
12.67 ms
(51.72%)
1
SELECT DISTINCT l0_.id AS id_0, l0_.logged_at AS logged_at_1 FROM log_history l0_ WHERE l0_.object_class = 'App\\Flexy\\ShopBundle\\Entity\\Order\\Order' AND l0_.action = 'update' AND l0_.object_id = ? GROUP BY l0_.logged_at ORDER BY l0_.logged_at DESC LIMIT 20
Parameters:
[
  "11615"
]
4.42 ms
(18.06%)
2
SELECT t0.id AS id_1, t0.is_monday AS is_monday_2, t0.is_tuesday AS is_tuesday_3, t0.is_wednesday AS is_wednesday_4, t0.is_thursday AS is_thursday_5, t0.is_friday AS is_friday_6, t0.is_saturday AS is_saturday_7, t0.is_sunday AS is_sunday_8, t0.start_work_at AS start_work_at_9, t0.end_work_at AS end_work_at_10, t0.exclude_days AS exclude_days_11, t0.exclude_dates AS exclude_dates_12, t0.exclude_hours AS exclude_hours_13, t0.logo AS logo_14, t0.logo_base64 AS logo_base64_15, t0.favicon AS favicon_16, t0.email AS email_17, t0.address AS address_18, t0.currency AS currency_19, t0.default_lang AS default_lang_20, t0.project_name AS project_name_21, t0.code AS code_22, t0.asset_folder_name AS asset_folder_name_23, t0.mail_order_created_body AS mail_order_created_body_24, t0.mail_order_created_title AS mail_order_created_title_25, t0.prefix_order AS prefix_order_26, t0.root_url AS root_url_27, t0.description AS description_28, t0.is_mercure_enabled AS is_mercure_enabled_29, t0.front_theme_id AS front_theme_id_30 FROM settings t0 WHERE t0.code = ? LIMIT 1
Parameters:
[
  "main"
]
2.85 ms
(11.63%)
1
SELECT count(l0_.id) AS sclr_0 FROM log_history l0_ WHERE l0_.object_class = 'App\\Flexy\\ShopBundle\\Entity\\Order\\Order' AND l0_.action = 'update' AND l0_.object_id = ? GROUP BY l0_.logged_at
Parameters:
[
  "11615"
]
2.37 ms
(9.66%)
1
SELECT l0_.id AS id_0, l0_.action AS action_1, l0_.logged_at AS logged_at_2, l0_.object_id AS object_id_3, l0_.object_class AS object_class_4, l0_.version AS version_5, l0_.data AS data_6, l0_.username AS username_7 FROM log_history l0_ WHERE l0_.object_class = 'App\\Flexy\\ShopBundle\\Entity\\Order\\Order' AND l0_.action = 'update' AND l0_.object_id = ? AND l0_.id IN (?) GROUP BY l0_.logged_at ORDER BY l0_.logged_at DESC
Parameters:
[
  "11615"
  16706
]
1.47 ms
(6.01%)
1
SELECT t0.id AS id_2, t0.created_at AS created_at_3, t0.description AS description_4, t0.first_name AS first_name_5, t0.last_name AS last_name_6, t0.company_name AS company_name_7, t0.address AS address_8, t0.city AS city_9, t0.country AS country_10, t0.department AS department_11, t0.postcode AS postcode_12, t0.email AS email_13, t0.tel AS tel_14, t0.comment AS comment_15, t0.status AS status_16, t0.source AS source_17, t0.delivery_at AS delivery_at_18, t0.recovery_at AS recovery_at_19, t0.old_order_number AS old_order_number_20, t0.reduction AS reduction_21, t0.distance AS distance_22, t0.payed_amount AS payed_amount_23, t0.start_processing_at AS start_processing_at_24, t0.delivery_type AS delivery_type_25, t0.start_delivery_at AS start_delivery_at_26, t0.is_to_do AS is_to_do_27, t0.collect_address AS collect_address_28, t0.shipping_address AS shipping_address_29, t0.collect_tel AS collect_tel_30, t0.is_heavy AS is_heavy_31, t0.shipping_tips AS shipping_tips_32, t0.wallet_payment_amount AS wallet_payment_amount_33, t0.is_checked AS is_checked_34, t0.token_stripe AS token_stripe_35, t0.order_type AS order_type_36, t0.deleted_at AS deleted_at_37, t0.created_by AS created_by_38, t0.reference AS reference_39, t0.is_multiclub AS is_multiclub_40, t0.is_local AS is_local_41, t0.customer_id AS customer_id_42, t0.demande_fund_id AS demande_fund_id_43, t0.shipping_method_id AS shipping_method_id_44, t0.agent_id AS agent_id_45, t0.payment_method_id AS payment_method_id_46, t0.coupon_id AS coupon_id_47, t0.agent_to_do_id AS agent_to_do_id_48, t0.city_region_shipping_id AS city_region_shipping_id_49, t0.city_region_collect_id AS city_region_collect_id_50, t0.vendor_id AS vendor_id_51, t0.store_id AS store_id_52, t0.shipment_id AS shipment_id_53, t0.invoice_id AS invoice_id_54, t0.cash_box_order_id AS cash_box_order_id_55, t0.dtype, t1.type AS type_56 FROM `order` t0 LEFT JOIN document t1 ON t0.id = t1.id WHERE t0.id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
  11615
]
0.72 ms
(2.93%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.image AS image_3, t0.created_at AS created_at_4, t0.email AS email_5, t0.description AS description_6, t0.is_valid AS is_valid_7, t0.full_name AS full_name_8, t0.tel AS tel_9, t0.address AS address_10, t0.city AS city_11, t0.ice AS ice_12, t0.rc AS rc_13, t0.simulate_username AS simulate_username_14, t0.simulate_password AS simulate_password_15, t0.cover_image AS cover_image_16, t0.path_rcimage AS path_rcimage_17, t0.path_ice_image AS path_ice_image_18, t0.path_ifimage AS path_ifimage_19, t0.identifiant_fiscale AS identifiant_fiscale_20, t0.user_id AS user_id_21 FROM vendor t0 WHERE t0.user_id IS NULL LIMIT 1
Parameters:
[]

Database Connections

Name Service
default doctrine.dbal.default_connection
salle2 doctrine.dbal.salle2_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\Flexy\ShopBundle\Entity\Vendor\Vendor No errors.
App\Entity\User No errors.
App\Entity\LogHistory No errors.
App\Entity\Settings No errors.
App\Entity\FrontTheme No errors.
App\Flexy\ShopBundle\Entity\Order\Order
  • The mappings App\Flexy\ShopBundle\Entity\Order\Order#cityRegionShipping and App\Flexy\ShopBundle\Entity\Shipping\CityRegion#orders are inconsistent with each other.
App\Flexy\StockBundle\Entity\Document
  • The mappings App\Flexy\StockBundle\Entity\Document#cityRegionShipping and App\Flexy\ShopBundle\Entity\Shipping\CityRegion#orders are inconsistent with each other.
App\Flexy\ShopBundle\Entity\Customer\Customer No errors.
App\Flexy\ShopBundle\Entity\Order\DemandeFund No errors.
App\Flexy\ShopBundle\Entity\Shipping\ShippingMethod No errors.
App\Flexy\ShopBundle\Entity\Resource\Agent
  • The association App\Flexy\ShopBundle\Entity\Resource\Agent#agentObjective refers to the inverse side field App\Flexy\ShopBundle\Entity\Resource\AgentObjective#agent which does not exist.
App\Flexy\ShopBundle\Entity\Payment\PaymentMethod No errors.
App\Flexy\ShopBundle\Entity\Promotion\Coupon No errors.
App\Flexy\ShopBundle\Entity\Shipping\CityRegion
  • The association App\Flexy\ShopBundle\Entity\Shipping\CityRegion#orders refers to the owning side field App\Flexy\ShopBundle\Entity\Order\Order#cityRegion which does not exist.
  • The association App\Flexy\ShopBundle\Entity\Shipping\CityRegion#stores refers to the owning side field App\Flexy\ShopBundle\Entity\Store\Store#�cityRegion which does not exist.
App\Flexy\ShopBundle\Entity\Store\Store
  • The mappings App\Flexy\ShopBundle\Entity\Store\Store#cityRegion and App\Flexy\ShopBundle\Entity\Shipping\CityRegion#stores are inconsistent with each other.
App\Flexy\ShopBundle\Entity\Shipping\Shipment No errors.
App\Flexy\ShopBundle\Entity\Accounting\Invoice
  • The association App\Flexy\ShopBundle\Entity\Accounting\Invoice#customerWalletPoints refers to the owning side field App\Flexy\ShopBundle\Entity\Customer\CustomerWalletPoint#invoice which does not exist.
App\Flexy\ShopBundle\Entity\Order\CashBoxOrder No errors.
App\Flexy\ShopBundle\Entity\Order\OrderItem No errors.
App\Flexy\ShopBundle\Entity\Order\Adjustment No errors.
App\Flexy\ShopBundle\Entity\Customer\CustomerWalletPoint
  • The mappings App\Flexy\ShopBundle\Entity\Customer\CustomerWalletPoint#originInvoice and App\Flexy\ShopBundle\Entity\Accounting\Invoice#customerWalletPoints are inconsistent with each other.
App\Flexy\ShopBundle\Entity\Payment\Payment No errors.