Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

1 Database Queries

1 Different statements

1.07 ms Query time

5 Invalid entities

Queries

Group similar statements

#▲	Time	Info
1	1.07 ms	SELECT t0.id AS id_1, t0.slug AS slug_2, t0.is_draft AS is_draft_3, t0.is_blocked AS is_blocked_4, t0.is_sold_out AS is_sold_out_5, t0.weight AS weight_6, t0.width AS width_7, t0.length AS length_8, t0.height AS height_9, t0.volumetric_weight AS volumetric_weight_10, t0.units_per_box AS units_per_box_11, t0.units_per_box_grouped AS units_per_box_grouped_12, t0.hide_discount AS hide_discount_13, t0.ean AS ean_14, t0.purchase_order_number AS purchase_order_number_15, t0.is_mandatory_product_features AS is_mandatory_product_features_16, t0.is_mandatory_producer AS is_mandatory_producer_17, t0.is_mandatory_triweer_list AS is_mandatory_triweer_list_18, t0.is_mandatory_triweer_comments AS is_mandatory_triweer_comments_19, t0.is_live_shopping AS is_live_shopping_20, t0.has_blockchain_traceability AS has_blockchain_traceability_21, t0.show_on_wall AS show_on_wall_22, t0.allow_return AS allow_return_23, t0.n_days_allowed_for_return AS n_days_allowed_for_return_24, t0.send_notifications AS send_notifications_25, t0.producer_purchase_order_number AS producer_purchase_order_number_26, t0.limit_units_per_buyer AS limit_units_per_buyer_27, t0.limit_units_to_sell AS limit_units_to_sell_28, t0.coming_soon_date AS coming_soon_date_29, t0.offer_launch_date AS offer_launch_date_30, t0.countdown_date AS countdown_date_31, t0.end_offer_date AS end_offer_date_32, t0.shipping_date AS shipping_date_33, t0.individual_shipping_duration AS individual_shipping_duration_34, t0.shared_shipping_duration AS shared_shipping_duration_35, t0.individual_package_format AS individual_package_format_36, t0.n_hours_on_wall_after_end AS n_hours_on_wall_after_end_37, t0.max_coins_to_spent AS max_coins_to_spent_38, t0.original_price AS original_price_39, t0.individual_price AS individual_price_40, t0.individual_disabled AS individual_disabled_41, t0.fake_users AS fake_users_42, t0.additional_info AS additional_info_43, t0.shipping_cost AS shipping_cost_44, t0.holded_id AS holded_id_45, t0.only_adults AS only_adults_46, t0.amount_for_free_shipping AS amount_for_free_shipping_47, t0.better_price AS better_price_48, t0.meta_title AS meta_title_49, t0.meta_description AS meta_description_50, t0.show_price AS show_price_51, t0.created_by AS created_by_52, t0.updated_by AS updated_by_53, t0.created_at AS created_at_54, t0.updated_at AS updated_at_55, t0.type_id AS type_id_56, t0.iva_id AS iva_id_57, t0.brand_id AS brand_id_58, t0.producer_id AS producer_id_59, t0.unit_measurement_id AS unit_measurement_id_60, t0.product_unique_id AS product_unique_id_61, t0.shipping_id AS shipping_id_62 FROM product t0 WHERE t0.id = ? Parameters: [`"#"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.slug AS slug_2, t0.is_draft AS is_draft_3, t0.is_blocked AS is_blocked_4, t0.is_sold_out AS is_sold_out_5, t0.weight AS weight_6, t0.width AS width_7, t0.length AS length_8, t0.height AS height_9, t0.volumetric_weight AS volumetric_weight_10, t0.units_per_box AS units_per_box_11, t0.units_per_box_grouped AS units_per_box_grouped_12, t0.hide_discount AS hide_discount_13, t0.ean AS ean_14, t0.purchase_order_number AS purchase_order_number_15, t0.is_mandatory_product_features AS is_mandatory_product_features_16, t0.is_mandatory_producer AS is_mandatory_producer_17, t0.is_mandatory_triweer_list AS is_mandatory_triweer_list_18, t0.is_mandatory_triweer_comments AS is_mandatory_triweer_comments_19, t0.is_live_shopping AS is_live_shopping_20, t0.has_blockchain_traceability AS has_blockchain_traceability_21, t0.show_on_wall AS show_on_wall_22, t0.allow_return AS allow_return_23, t0.n_days_allowed_for_return AS n_days_allowed_for_return_24, t0.send_notifications AS send_notifications_25, t0.producer_purchase_order_number AS producer_purchase_order_number_26, t0.limit_units_per_buyer AS limit_units_per_buyer_27, t0.limit_units_to_sell AS limit_units_to_sell_28, t0.coming_soon_date AS coming_soon_date_29, t0.offer_launch_date AS offer_launch_date_30, t0.countdown_date AS countdown_date_31, t0.end_offer_date AS end_offer_date_32, t0.shipping_date AS shipping_date_33, t0.individual_shipping_duration AS individual_shipping_duration_34, t0.shared_shipping_duration AS shared_shipping_duration_35, t0.individual_package_format AS individual_package_format_36, t0.n_hours_on_wall_after_end AS n_hours_on_wall_after_end_37, t0.max_coins_to_spent AS max_coins_to_spent_38, t0.original_price AS original_price_39, t0.individual_price AS individual_price_40, t0.individual_disabled AS individual_disabled_41, t0.fake_users AS fake_users_42, t0.additional_info AS additional_info_43, t0.shipping_cost AS shipping_cost_44, t0.holded_id AS holded_id_45, t0.only_adults AS only_adults_46, t0.amount_for_free_shipping AS amount_for_free_shipping_47, t0.better_price AS better_price_48, t0.meta_title AS meta_title_49, t0.meta_description AS meta_description_50, t0.show_price AS show_price_51, t0.created_by AS created_by_52, t0.updated_by AS updated_by_53, t0.created_at AS created_at_54, t0.updated_at AS updated_at_55, t0.type_id AS type_id_56, t0.iva_id AS iva_id_57, t0.brand_id AS brand_id_58, t0.producer_id AS producer_id_59, t0.unit_measurement_id AS unit_measurement_id_60, t0.product_unique_id AS product_unique_id_61, t0.shipping_id AS shipping_id_62 FROM product t0 WHERE t0.id = ? SELECT t0.id AS id_1, t0.slug AS slug_2, t0.is_draft AS is_draft_3, t0.is_blocked AS is_blocked_4, t0.is_sold_out AS is_sold_out_5, t0.weight AS weight_6, t0.width AS width_7, t0.length AS length_8, t0.height AS height_9, t0.volumetric_weight AS volumetric_weight_10, t0.units_per_box AS units_per_box_11, t0.units_per_box_grouped AS units_per_box_grouped_12, t0.hide_discount AS hide_discount_13, t0.ean AS ean_14, t0.purchase_order_number AS purchase_order_number_15, t0.is_mandatory_product_features AS is_mandatory_product_features_16, t0.is_mandatory_producer AS is_mandatory_producer_17, t0.is_mandatory_triweer_list AS is_mandatory_triweer_list_18, t0.is_mandatory_triweer_comments AS is_mandatory_triweer_comments_19, t0.is_live_shopping AS is_live_shopping_20, t0.has_blockchain_traceability AS has_blockchain_traceability_21, t0.show_on_wall AS show_on_wall_22, t0.allow_return AS allow_return_23, t0.n_days_allowed_for_return AS n_days_allowed_for_return_24, t0.send_notifications AS send_notifications_25, t0.producer_purchase_order_number AS producer_purchase_order_number_26, t0.limit_units_per_buyer AS limit_units_per_buyer_27, t0.limit_units_to_sell AS limit_units_to_sell_28, t0.coming_soon_date AS coming_soon_date_29, t0.offer_launch_date AS offer_launch_date_30, t0.countdown_date AS countdown_date_31, t0.end_offer_date AS end_offer_date_32, t0.shipping_date AS shipping_date_33, t0.individual_shipping_duration AS individual_shipping_duration_34, t0.shared_shipping_duration AS shared_shipping_duration_35, t0.individual_package_format AS individual_package_format_36, t0.n_hours_on_wall_after_end AS n_hours_on_wall_after_end_37, t0.max_coins_to_spent AS max_coins_to_spent_38, t0.original_price AS original_price_39, t0.individual_price AS individual_price_40, t0.individual_disabled AS individual_disabled_41, t0.fake_users AS fake_users_42, t0.additional_info AS additional_info_43, t0.shipping_cost AS shipping_cost_44, t0.holded_id AS holded_id_45, t0.only_adults AS only_adults_46, t0.amount_for_free_shipping AS amount_for_free_shipping_47, t0.better_price AS better_price_48, t0.meta_title AS meta_title_49, t0.meta_description AS meta_description_50, t0.show_price AS show_price_51, t0.created_by AS created_by_52, t0.updated_by AS updated_by_53, t0.created_at AS created_at_54, t0.updated_at AS updated_at_55, t0.type_id AS type_id_56, t0.iva_id AS iva_id_57, t0.brand_id AS brand_id_58, t0.producer_id AS producer_id_59, t0.unit_measurement_id AS unit_measurement_id_60, t0.product_unique_id AS product_unique_id_61, t0.shipping_id AS shipping_id_62 FROM product t0 WHERE t0.id = '#';

#▲

Time

Info

1.07 ms

SELECT t0.id AS id_1, t0.slug AS slug_2, t0.is_draft AS is_draft_3, t0.is_blocked AS is_blocked_4, t0.is_sold_out AS is_sold_out_5, t0.weight AS weight_6, t0.width AS width_7, t0.length AS length_8, t0.height AS height_9, t0.volumetric_weight AS volumetric_weight_10, t0.units_per_box AS units_per_box_11, t0.units_per_box_grouped AS units_per_box_grouped_12, t0.hide_discount AS hide_discount_13, t0.ean AS ean_14, t0.purchase_order_number AS purchase_order_number_15, t0.is_mandatory_product_features AS is_mandatory_product_features_16, t0.is_mandatory_producer AS is_mandatory_producer_17, t0.is_mandatory_triweer_list AS is_mandatory_triweer_list_18, t0.is_mandatory_triweer_comments AS is_mandatory_triweer_comments_19, t0.is_live_shopping AS is_live_shopping_20, t0.has_blockchain_traceability AS has_blockchain_traceability_21, t0.show_on_wall AS show_on_wall_22, t0.allow_return AS allow_return_23, t0.n_days_allowed_for_return AS n_days_allowed_for_return_24, t0.send_notifications AS send_notifications_25, t0.producer_purchase_order_number AS producer_purchase_order_number_26, t0.limit_units_per_buyer AS limit_units_per_buyer_27, t0.limit_units_to_sell AS limit_units_to_sell_28, t0.coming_soon_date AS coming_soon_date_29, t0.offer_launch_date AS offer_launch_date_30, t0.countdown_date AS countdown_date_31, t0.end_offer_date AS end_offer_date_32, t0.shipping_date AS shipping_date_33, t0.individual_shipping_duration AS individual_shipping_duration_34, t0.shared_shipping_duration AS shared_shipping_duration_35, t0.individual_package_format AS individual_package_format_36, t0.n_hours_on_wall_after_end AS n_hours_on_wall_after_end_37, t0.max_coins_to_spent AS max_coins_to_spent_38, t0.original_price AS original_price_39, t0.individual_price AS individual_price_40, t0.individual_disabled AS individual_disabled_41, t0.fake_users AS fake_users_42, t0.additional_info AS additional_info_43, t0.shipping_cost AS shipping_cost_44, t0.holded_id AS holded_id_45, t0.only_adults AS only_adults_46, t0.amount_for_free_shipping AS amount_for_free_shipping_47, t0.better_price AS better_price_48, t0.meta_title AS meta_title_49, t0.meta_description AS meta_description_50, t0.show_price AS show_price_51, t0.created_by AS created_by_52, t0.updated_by AS updated_by_53, t0.created_at AS created_at_54, t0.updated_at AS updated_at_55, t0.type_id AS type_id_56, t0.iva_id AS iva_id_57, t0.brand_id AS brand_id_58, t0.producer_id AS producer_id_59, t0.unit_measurement_id AS unit_measurement_id_60, t0.product_unique_id AS product_unique_id_61, t0.shipping_id AS shipping_id_62 FROM product t0 WHERE t0.id = ?

Parameters:

[
  "#"
]

View formatted query View runnable query Explain query

SELECT
  t0.id AS id_1,
  t0.slug AS slug_2,
  t0.is_draft AS is_draft_3,
  t0.is_blocked AS is_blocked_4,
  t0.is_sold_out AS is_sold_out_5,
  t0.weight AS weight_6,
  t0.width AS width_7,
  t0.length AS length_8,
  t0.height AS height_9,
  t0.volumetric_weight AS volumetric_weight_10,
  t0.units_per_box AS units_per_box_11,
  t0.units_per_box_grouped AS units_per_box_grouped_12,
  t0.hide_discount AS hide_discount_13,
  t0.ean AS ean_14,
  t0.purchase_order_number AS purchase_order_number_15,
  t0.is_mandatory_product_features AS is_mandatory_product_features_16,
  t0.is_mandatory_producer AS is_mandatory_producer_17,
  t0.is_mandatory_triweer_list AS is_mandatory_triweer_list_18,
  t0.is_mandatory_triweer_comments AS is_mandatory_triweer_comments_19,
  t0.is_live_shopping AS is_live_shopping_20,
  t0.has_blockchain_traceability AS has_blockchain_traceability_21,
  t0.show_on_wall AS show_on_wall_22,
  t0.allow_return AS allow_return_23,
  t0.n_days_allowed_for_return AS n_days_allowed_for_return_24,
  t0.send_notifications AS send_notifications_25,
  t0.producer_purchase_order_number AS producer_purchase_order_number_26,
  t0.limit_units_per_buyer AS limit_units_per_buyer_27,
  t0.limit_units_to_sell AS limit_units_to_sell_28,
  t0.coming_soon_date AS coming_soon_date_29,
  t0.offer_launch_date AS offer_launch_date_30,
  t0.countdown_date AS countdown_date_31,
  t0.end_offer_date AS end_offer_date_32,
  t0.shipping_date AS shipping_date_33,
  t0.individual_shipping_duration AS individual_shipping_duration_34,
  t0.shared_shipping_duration AS shared_shipping_duration_35,
  t0.individual_package_format AS individual_package_format_36,
  t0.n_hours_on_wall_after_end AS n_hours_on_wall_after_end_37,
  t0.max_coins_to_spent AS max_coins_to_spent_38,
  t0.original_price AS original_price_39,
  t0.individual_price AS individual_price_40,
  t0.individual_disabled AS individual_disabled_41,
  t0.fake_users AS fake_users_42,
  t0.additional_info AS additional_info_43,
  t0.shipping_cost AS shipping_cost_44,
  t0.holded_id AS holded_id_45,
  t0.only_adults AS only_adults_46,
  t0.amount_for_free_shipping AS amount_for_free_shipping_47,
  t0.better_price AS better_price_48,
  t0.meta_title AS meta_title_49,
  t0.meta_description AS meta_description_50,
  t0.show_price AS show_price_51,
  t0.created_by AS created_by_52,
  t0.updated_by AS updated_by_53,
  t0.created_at AS created_at_54,
  t0.updated_at AS updated_at_55,
  t0.type_id AS type_id_56,
  t0.iva_id AS iva_id_57,
  t0.brand_id AS brand_id_58,
  t0.producer_id AS producer_id_59,
  t0.unit_measurement_id AS unit_measurement_id_60,
  t0.product_unique_id AS product_unique_id_61,
  t0.shipping_id AS shipping_id_62
FROM
  product t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.slug AS slug_2, t0.is_draft AS is_draft_3, t0.is_blocked AS is_blocked_4, t0.is_sold_out AS is_sold_out_5, t0.weight AS weight_6, t0.width AS width_7, t0.length AS length_8, t0.height AS height_9, t0.volumetric_weight AS volumetric_weight_10, t0.units_per_box AS units_per_box_11, t0.units_per_box_grouped AS units_per_box_grouped_12, t0.hide_discount AS hide_discount_13, t0.ean AS ean_14, t0.purchase_order_number AS purchase_order_number_15, t0.is_mandatory_product_features AS is_mandatory_product_features_16, t0.is_mandatory_producer AS is_mandatory_producer_17, t0.is_mandatory_triweer_list AS is_mandatory_triweer_list_18, t0.is_mandatory_triweer_comments AS is_mandatory_triweer_comments_19, t0.is_live_shopping AS is_live_shopping_20, t0.has_blockchain_traceability AS has_blockchain_traceability_21, t0.show_on_wall AS show_on_wall_22, t0.allow_return AS allow_return_23, t0.n_days_allowed_for_return AS n_days_allowed_for_return_24, t0.send_notifications AS send_notifications_25, t0.producer_purchase_order_number AS producer_purchase_order_number_26, t0.limit_units_per_buyer AS limit_units_per_buyer_27, t0.limit_units_to_sell AS limit_units_to_sell_28, t0.coming_soon_date AS coming_soon_date_29, t0.offer_launch_date AS offer_launch_date_30, t0.countdown_date AS countdown_date_31, t0.end_offer_date AS end_offer_date_32, t0.shipping_date AS shipping_date_33, t0.individual_shipping_duration AS individual_shipping_duration_34, t0.shared_shipping_duration AS shared_shipping_duration_35, t0.individual_package_format AS individual_package_format_36, t0.n_hours_on_wall_after_end AS n_hours_on_wall_after_end_37, t0.max_coins_to_spent AS max_coins_to_spent_38, t0.original_price AS original_price_39, t0.individual_price AS individual_price_40, t0.individual_disabled AS individual_disabled_41, t0.fake_users AS fake_users_42, t0.additional_info AS additional_info_43, t0.shipping_cost AS shipping_cost_44, t0.holded_id AS holded_id_45, t0.only_adults AS only_adults_46, t0.amount_for_free_shipping AS amount_for_free_shipping_47, t0.better_price AS better_price_48, t0.meta_title AS meta_title_49, t0.meta_description AS meta_description_50, t0.show_price AS show_price_51, t0.created_by AS created_by_52, t0.updated_by AS updated_by_53, t0.created_at AS created_at_54, t0.updated_at AS updated_at_55, t0.type_id AS type_id_56, t0.iva_id AS iva_id_57, t0.brand_id AS brand_id_58, t0.producer_id AS producer_id_59, t0.unit_measurement_id AS unit_measurement_id_60, t0.product_unique_id AS product_unique_id_61, t0.shipping_id AS shipping_id_62 FROM product t0 WHERE t0.id = '#';

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\Product	The mappings App\Entity\Product#userReviews and App\Entity\Review#product are inconsistent with each other.
App\Entity\BaseNameSlug	No errors.
App\Entity\ProductType	No errors.
App\Entity\Iva	The mappings App\Entity\Iva#productUniques and App\Entity\Product#iva are inconsistent with each other.
App\Entity\Brand	No errors.
App\Entity\Producer	No errors.
App\Entity\UnitMeasurement	No errors.
App\Entity\ProductUnique	No errors.
App\Entity\Shipping	No errors.
App\Entity\Category	No errors.
App\Entity\Subcategory	No errors.
App\Entity\Media	No errors.
App\Entity\Label	No errors.
App\Entity\ProductPriceScale	No errors.
App\Entity\OrderDetail	No errors.
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\UserShared	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\ProductTranslation	No errors.
App\Entity\BrandTranslation	No errors.
App\Entity\Address	No errors.
App\Entity\ProducerTranslation	No errors.
App\Entity\ShippingScale	No errors.
App\Entity\CategoryTranslation	No errors.
App\Entity\SubcategoryTranslation	No errors.
App\Entity\LabelTranslation	No errors.
App\Entity\Order	No errors.
App\Entity\ShoppingCart	No errors.
App\Entity\Card	No errors.
App\Entity\Wallet	No errors.
App\Entity\ProductReturn	No errors.
App\Entity\FriendTriweer	No errors.
App\Entity\SharedAddress	No errors.
App\Entity\BaseKeyValue	No errors.
App\Entity\ShareType	No errors.
App\Entity\Language	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\PaymentMethod	No errors.
App\Entity\ReviewTranslation	No errors.
App\Entity\Country	No errors.
App\Entity\Province	No errors.
App\Entity\OrderLM	No errors.
App\Entity\Banner	No errors.
App\Entity\BannerTranslation	No errors.
App\Entity\ActionType	No errors.
App\Entity\Option	No errors.
App\Entity\Slide	No errors.
App\Entity\SlideTranslation	No errors.
App\Entity\Menu	No errors.
App\Entity\ShoppingCartDetail	No errors.
App\Entity\Translation	No errors.
App\Entity\OrderStatus	No errors.
App\Entity\ReturnReasons	No errors.
App\Entity\TpvResult	No errors.
App\Entity\ResetPasswordRequest	No errors.
App\Entity\Notification	No errors.
App\Entity\ProductReturnStatus	No errors.
App\Entity\AchievementLevel	No errors.
App\Entity\Action	No errors.
App\Entity\FrequentQuestion	No errors.
App\Entity\Achievement	No errors.
Vich\UploaderBundle\Entity\File	No errors.

Symfony Profiler

https://pre-app.triwuu.com/product/shopping-cart/%23?isIndividual=0&newCart=1

Configuration Settings

Theme