https://dev.shop.bak2.com/fr/shop/14/stock

Query Metrics

2 Database Queries
2 Different statements
47.57 ms Query time
1 Invalid entities

Grouped Statements

Show all queries

Time Count Info
46.77 ms
(98.32%)
1
SELECT s0_.id AS id_0, s0_.rank AS rank_1, s0_.qty AS qty_2, s0_.price AS price_3, s0_.grade AS grade_4, s0_.source_grade AS source_grade_5, s0_.public_price AS public_price_6, s0_.enabled AS enabled_7, s0_.updated AS updated_8, s0_.override AS override_9, s0_.option_price AS option_price_10, s0_.shop_id AS shop_id_11, s0_.model_id AS model_id_12, s0_.color_id AS color_id_13, s0_.product_id AS product_id_14 FROM stock s0_ INNER JOIN model m1_ ON s0_.model_id = m1_.id INNER JOIN manufacturer m2_ ON m1_.manufacturer_id = m2_.id INNER JOIN color c3_ ON s0_.color_id = c3_.id INNER JOIN category c4_ ON m1_.category_id = c4_.id WHERE s0_.shop_id = ? AND s0_.qty <> ? AND s0_.enabled = ? AND s0_.price > ? ORDER BY s0_.price ASC
Parameters:
[
  14
  0
  1
  "100"
]
0.80 ms
(1.68%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.country AS country_3, t0.wtt_id AS wtt_id_4, t0.wtt_name AS wtt_name_5, t0.logo AS logo_6, t0.config AS config_7, t0.apikey AS apikey_8, t0.login_hash AS login_hash_9, t0.channel AS channel_10, t0.mail_copy AS mail_copy_11, t0.active AS active_12 FROM shop t0 WHERE t0.id = ?
Parameters:
[
  "14"
]

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\Shop No errors.
App\Entity\User
  • The mappings App\Entity\User#shop and App\Entity\Shop#users are inconsistent with each other.
  • If association App\Entity\User#shop is many-to-one, then the inversed side App\Entity\Shop#users has to be one-to-many.
App\Entity\Order No errors.
App\Entity\Stock No errors.
App\Entity\Company No errors.
App\Entity\ShopSetting No errors.
App\Entity\Imei No errors.
App\Entity\Coupon No errors.
App\Entity\Category No errors.
App\Entity\Option No errors.
App\Entity\Status No errors.
App\Entity\Model No errors.
App\Entity\Manufacturer No errors.
App\Entity\Color No errors.
App\Entity\Product No errors.