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

Query Metrics

15 Database Queries
4 Different statements
6.17 ms Query time
4 Invalid entities
  • Queries
  • Database Connections
  • Entity Managers
  • Second Level Cache
  • Entities Mapping

Group similar statements

# Time Info
1 0.97 ms
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:
0 of 0
[ "meta_title_default" ]
2 0.28 ms
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:
0 of 0
[ "meta_description_default" ]
3 0.63 ms
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:
0 of 0
[ 1 ]
4 1.14 ms
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:
0 of 0
[ 287 ]
5 0.38 ms
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:
0 of 0
[ 11 ]
6 0.35 ms
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:
0 of 0
[ 24 ]
7 0.17 ms
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:
0 of 0
[ 6 ]
8 0.40 ms
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:
0 of 0
[ 18 ]
9 0.15 ms
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:
0 of 0
[ 5 ]
10 0.33 ms
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:
0 of 0
[ 64 ]
11 0.26 ms
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:
0 of 0
[ 4 ]
12 0.37 ms
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:
0 of 0
[ 61 ]
13 0.20 ms
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:
0 of 0
[ 3 ]
14 0.37 ms
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:
0 of 0
[ 202 ]
15 0.19 ms
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:
0 of 0
[ 2 ]