Query Metrics
15
Database Queries
4
Different statements
7.26 ms
Query time
4
Invalid entities
Queries
#▲ | Time | Info |
---|---|---|
1 | 1.21 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:
[
"meta_title_default"
]
|
2 | 0.23 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:
[
"meta_description_default"
]
|
3 | 0.81 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:
[
1
]
|
4 | 1.64 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:
[
287
]
|
5 | 0.48 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:
[
11
]
|
6 | 0.51 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:
[
24
]
|
7 | 0.21 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:
[
6
]
|
8 | 0.42 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:
[
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:
[
5
]
|
10 | 0.38 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:
[
64
]
|
11 | 0.16 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:
[
4
]
|
12 | 0.30 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:
[
61
]
|
13 | 0.18 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:
[
3
]
|
14 | 0.42 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:
[
202
]
|
15 | 0.18 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:
[
2
]
|
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 |
|
App\Entity\User |
|
App\Entity\Product |
|
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 |
|
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. |