https://pre-app.triwuu.com/faq

Query Metrics

15 Database Queries
4 Different statements
6.38 ms Query time
4 Invalid entities

Grouped Statements

Show all queries

Time Count Info
2.90 ms
(45.38%)
6
SELECT t0.id AS id_1, t0.username AS username_2, t0.nickname AS nickname_3, t0.roles AS roles_4, t0.password AS password_5, t0.email AS email_6, t0.is_on_boarding AS is_on_boarding_7, t0.accepted_communications AS accepted_communications_8, t0.accepted_policies AS accepted_policies_9, t0.is_active AS is_active_10, t0.legal_age AS legal_age_11, t0.is_notifications_active AS is_notifications_active_12, t0.is_verified AS is_verified_13, t0.name AS name_14, t0.surname AS surname_15, t0.cif AS cif_16, t0.phone AS phone_17, t0.cpostal AS cpostal_18, t0.sex AS sex_19, t0.holded_id AS holded_id_20, t0.notification_whatsapp AS notification_whatsapp_21, t0.email_token AS email_token_22, t0.email_token_expires_at AS email_token_expires_at_23, t0.birthday AS birthday_24, t0.bank_transfer_active AS bank_transfer_active_25, t0.created_by AS created_by_26, t0.updated_by AS updated_by_27, t0.created_at AS created_at_28, t0.updated_at AS updated_at_29, t0.avatar_id AS avatar_id_30, t31.id AS id_32, t31.save_card AS save_card_33, t31.is_billing_address_same_as_shipping AS is_billing_address_same_as_shipping_34, t31.delivery_method AS delivery_method_35, t31.use_coins AS use_coins_36, t31.payment_method AS payment_method_37, t31.phone AS phone_38, t31.need_bill AS need_bill_39, t31.cif AS cif_40, t31.buy_not_enought AS buy_not_enought_41, t31.better_price AS better_price_42, t31.is_individual_purchase AS is_individual_purchase_43, t31.created_by AS created_by_44, t31.updated_by AS updated_by_45, t31.created_at AS created_at_46, t31.updated_at AS updated_at_47, t31.buyer_id AS buyer_id_48, t31.card_id AS card_id_49, t31.shipping_address_entity_id AS shipping_address_entity_id_50, t31.buying_group_entity_id AS buying_group_entity_id_51, t31.shared_shipping_address_entity_id AS shared_shipping_address_entity_id_52, t31.billing_address_entity_id AS billing_address_entity_id_53, t0.share_favourite_products_type_id AS share_favourite_products_type_id_54, t0.share_shopping_type_id AS share_shopping_type_id_55, t0.language_id AS language_id_56, t0.payment_method_id AS payment_method_id_57 FROM "user" t0 LEFT JOIN shopping_cart t31 ON t31.buyer_id = t0.id WHERE t0.id = ?
Parameters:
[
  287
]
1.33 ms
(20.88%)
2
SELECT o0_.id AS id_0, o0_.description AS description_1, o0_.key AS key_2, o0_.value AS value_3, o0_.created_by AS created_by_4, o0_.updated_by AS updated_by_5, o0_.created_at AS created_at_6, o0_.updated_at AS updated_at_7 FROM option o0_ WHERE o0_.key = ?
Parameters:
[
  "meta_title_default"
]
1.18 ms
(18.47%)
6
SELECT t0.id AS id_1, t0.comment AS comment_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM review_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  11
]
0.97 ms
(15.28%)
1
SELECT r0_.id AS id_0, r0_.rating AS rating_1, r0_.visible AS visible_2, r0_.created_by AS created_by_3, r0_.updated_by AS updated_by_4, r0_.created_at AS created_at_5, r0_.updated_at AS updated_at_6, r0_.user_id AS user_id_7, r0_.product_id AS product_id_8 FROM review r0_ WHERE r0_.product_id IS NULL AND r0_.visible = ? ORDER BY r0_.created_at DESC LIMIT 10
Parameters:
[
  1
]

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\BaseKeyValue No errors.
App\Entity\Option No errors.
App\Entity\Review
  • The association App\Entity\Review#user refers to the inverse side field App\Entity\User#reviews which does not exist.
  • The association App\Entity\Review#product refers to the inverse side field App\Entity\Product#reviews which does not exist.
App\Entity\User
  • The field App\Entity\User#asFakeTriweerInOffer is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Product#fakeTriweersInOffer does not contain the required 'inversedBy="asFakeTriweerInOffer"' attribute.
  • The association App\Entity\User#productReturns refers to the owning side field App\Entity\ProductReturn#Buyer which does not exist.
  • The field App\Entity\User#friendships is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\FriendTriweer#friendUser does not contain the required 'inversedBy="friendships"' attribute.
  • The field App\Entity\User#memberBuyingGroups is on the owning side of a bi-directional relationship, but the specified inversedBy association on the target-entity App\Entity\BuyingGroup#members does not contain the required 'mappedBy="memberBuyingGroups"' attribute.
App\Entity\Product
  • The mappings App\Entity\Product#userReviews and App\Entity\Review#product are inconsistent with each other.
App\Entity\ReviewTranslation No errors.
App\Entity\Media No errors.
App\Entity\ShoppingCart No errors.
App\Entity\Card No errors.
App\Entity\Address No errors.
App\Entity\BuyingGroup
  • The mappings App\Entity\BuyingGroup#members and App\Entity\User#buyingGroups are inconsistent with each other.
  • If association App\Entity\BuyingGroup#members is many-to-many, then the inversed side App\Entity\User#buyingGroups has to be many-to-many as well.
App\Entity\SharedAddress No errors.
App\Entity\ShareType No errors.
App\Entity\Language No errors.
App\Entity\PaymentMethod No errors.
App\Entity\Category No errors.
App\Entity\Subcategory No errors.
App\Entity\Order No errors.
App\Entity\Wallet No errors.
App\Entity\ProductReturn No errors.
App\Entity\FriendTriweer No errors.