http://hyfindrdev.com/cookie_consent_alt?locale=en

Query Metrics

15 Database Queries
15 Different statements
11.51 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
1.59 ms
(13.77%)
1
SELECT DISTINCT id_8 FROM (SELECT DISTINCT id_8 FROM (SELECT b0_.uuid AS uuid_0, b0_.code AS code_1, b0_.published_at AS published_at_2, b0_.last_verified_at AS last_verified_at_3, b0_.created_at AS created_at_4, b0_.deleted AS deleted_5, b0_.enabled AS enabled_6, b0_.verification_status AS verification_status_7, b0_.id AS id_8, b1_.id AS id_9, b2_.id AS id_10 FROM bitbag_open_marketplace_product_listing b0_ INNER JOIN bitbag_open_marketplace_product_draft b1_ ON b0_.id = b1_.product_listing_id LEFT JOIN bitbag_open_marketplace_product_draft b2_ ON b0_.id = b2_.product_listing_id AND (b1_.id < b2_.id) WHERE b2_.id IS NULL AND b0_.vendor_id = ? AND b0_.deleted = ?) dctrn_result_inner ORDER BY id_8 ASC) dctrn_result LIMIT 10
Parameters:
[
  1
  0
]
0.95 ms
(8.24%)
1
SELECT t0.username AS username_1, t0.username_canonical AS username_canonical_2, t0.enabled AS enabled_3, t0.salt AS salt_4, t0.password AS password_5, t0.encoder_name AS encoder_name_6, t0.last_login AS last_login_7, t0.password_reset_token AS password_reset_token_8, t0.password_requested_at AS password_requested_at_9, t0.email_verification_token AS email_verification_token_10, t0.verified_at AS verified_at_11, t0.locked AS locked_12, t0.expires_at AS expires_at_13, t0.credentials_expire_at AS credentials_expire_at_14, t0.roles AS roles_15, t0.email AS email_16, t0.email_canonical AS email_canonical_17, t0.created_at AS created_at_18, t0.updated_at AS updated_at_19, t0.id AS id_20, t0.activationToken AS activationToken_21, t0.customer_id AS customer_id_22 FROM sylius_shop_user t0 WHERE t0.id = ?
Parameters:
[
  3
]
0.89 ms
(7.73%)
1
SELECT t0.email AS email_1, t0.email_canonical AS email_canonical_2, t0.first_name AS first_name_3, t0.last_name AS last_name_4, t0.birthday AS birthday_5, t0.gender AS gender_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.phone_number AS phone_number_9, t0.subscribed_to_newsletter AS subscribed_to_newsletter_10, t0.id AS id_11, t0.customer_group_id AS customer_group_id_12, t0.inviter_id AS inviter_id_13, t0.organization_id AS organization_id_14, t0.default_address_id AS default_address_id_15, t16.username AS username_17, t16.username_canonical AS username_canonical_18, t16.enabled AS enabled_19, t16.salt AS salt_20, t16.password AS password_21, t16.encoder_name AS encoder_name_22, t16.last_login AS last_login_23, t16.password_reset_token AS password_reset_token_24, t16.password_requested_at AS password_requested_at_25, t16.email_verification_token AS email_verification_token_26, t16.verified_at AS verified_at_27, t16.locked AS locked_28, t16.expires_at AS expires_at_29, t16.credentials_expire_at AS credentials_expire_at_30, t16.roles AS roles_31, t16.email AS email_32, t16.email_canonical AS email_canonical_33, t16.created_at AS created_at_34, t16.updated_at AS updated_at_35, t16.id AS id_36, t16.activationToken AS activationToken_37, t16.customer_id AS customer_id_38 FROM sylius_customer t0 LEFT JOIN sylius_shop_user t16 ON t16.customer_id = t0.id WHERE t0.id = ?
Parameters:
[
  3
]
0.87 ms
(7.59%)
1
SELECT t0.seo_not_indexable AS seo_not_indexable_1, t0.seo_metadata_title AS seo_metadata_title_2, t0.seo_metadata_description AS seo_metadata_description_3, t0.seo_og_metadata_title AS seo_og_metadata_title_4, t0.seo_og_metadata_description AS seo_og_metadata_description_5, t0.seo_og_metadata_url AS seo_og_metadata_url_6, t0.seo_og_metadata_image AS seo_og_metadata_image_7, t0.seo_og_metadata_type AS seo_og_metadata_type_8, t0.id AS id_9, t0.keywords AS keywords_10, t0.locale AS locale_11, t0.translatable_id AS translatable_id_12 FROM dedi_sylius_seo_content_translation t0 WHERE t0.translatable_id = ? AND t0.locale = ? LIMIT 1
Parameters:
[
  1
  "en"
]
0.86 ms
(7.47%)
1
SELECT t0.code AS code_1, t0.name AS name_2, t0.color AS color_3, t0.description AS description_4, t0.enabled AS enabled_5, t0.hostname AS hostname_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.id AS id_9, t0.theme_name AS theme_name_10, t0.tax_calculation_strategy AS tax_calculation_strategy_11, t0.contact_email AS contact_email_12, t0.contact_phone_number AS contact_phone_number_13, t0.skipping_shipping_step_allowed AS skipping_shipping_step_allowed_14, t0.skipping_payment_step_allowed AS skipping_payment_step_allowed_15, t0.account_verification_required AS account_verification_required_16, t0.google_analytics_code AS google_analytics_code_17, t0.google_tag_manager_id AS google_tag_manager_id_18, t0.brevo_api_key AS brevo_api_key_19, t0.brevo_directory_id AS brevo_directory_id_20, t0.brevo_test_mode AS brevo_test_mode_21, t0.is_vendor_stats_menu_enabled AS is_vendor_stats_menu_enabled_22, t0.voiceflow_api_key AS voiceflow_api_key_23, t0.voiceflow_version AS voiceflow_version_24, t0.default_locale_id AS default_locale_id_25, t26.code AS code_27, t26.created_at AS created_at_28, t26.updated_at AS updated_at_29, t26.id AS id_30, t0.base_currency_id AS base_currency_id_31, t32.code AS code_33, t32.created_at AS created_at_34, t32.updated_at AS updated_at_35, t32.id AS id_36, t0.default_tax_zone_id AS default_tax_zone_id_37, t0.menu_taxon_id AS menu_taxon_id_38, t0.referenceable_content_id AS referenceable_content_id_39, t0.shop_billing_data_id AS shop_billing_data_id_40 FROM sylius_channel t0 INNER JOIN sylius_locale t26 ON t0.default_locale_id = t26.id INNER JOIN sylius_currency t32 ON t0.base_currency_id = t32.id WHERE t0.hostname = ? AND t0.enabled = ? LIMIT 1
Parameters:
[
  "hyfindrdev.com"
  1
]
0.85 ms
(7.42%)
1
SELECT t0.code AS code_1, t0.name AS name_2, t0.color AS color_3, t0.description AS description_4, t0.enabled AS enabled_5, t0.hostname AS hostname_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.id AS id_9, t0.theme_name AS theme_name_10, t0.tax_calculation_strategy AS tax_calculation_strategy_11, t0.contact_email AS contact_email_12, t0.contact_phone_number AS contact_phone_number_13, t0.skipping_shipping_step_allowed AS skipping_shipping_step_allowed_14, t0.skipping_payment_step_allowed AS skipping_payment_step_allowed_15, t0.account_verification_required AS account_verification_required_16, t0.google_analytics_code AS google_analytics_code_17, t0.google_tag_manager_id AS google_tag_manager_id_18, t0.brevo_api_key AS brevo_api_key_19, t0.brevo_directory_id AS brevo_directory_id_20, t0.brevo_test_mode AS brevo_test_mode_21, t0.is_vendor_stats_menu_enabled AS is_vendor_stats_menu_enabled_22, t0.voiceflow_api_key AS voiceflow_api_key_23, t0.voiceflow_version AS voiceflow_version_24, t0.default_locale_id AS default_locale_id_25, t26.code AS code_27, t26.created_at AS created_at_28, t26.updated_at AS updated_at_29, t26.id AS id_30, t0.base_currency_id AS base_currency_id_31, t32.code AS code_33, t32.created_at AS created_at_34, t32.updated_at AS updated_at_35, t32.id AS id_36, t0.default_tax_zone_id AS default_tax_zone_id_37, t0.menu_taxon_id AS menu_taxon_id_38, t0.referenceable_content_id AS referenceable_content_id_39, t0.shop_billing_data_id AS shop_billing_data_id_40 FROM sylius_channel t0 INNER JOIN sylius_locale t26 ON t0.default_locale_id = t26.id INNER JOIN sylius_currency t32 ON t0.base_currency_id = t32.id
Parameters:
[]
0.84 ms
(7.31%)
1
SELECT t0.name AS name_1, t0.description AS description_2, t0.email AS email_3, t0.phone_number AS phone_number_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.id AS id_7, t0.is_vendor_register AS is_vendor_register_8, t0.account_stripe_id AS account_stripe_id_9, t0.customer_stripe_id AS customer_stripe_id_10, t0.stripe_session_id AS stripe_session_id_11, t0.stripe_status AS stripe_status_12, t0.stripe_enabled AS stripe_enabled_13, t0.verified AS verified_14, t0.pricing_list_id AS pricing_list_id_15, t0.billing_data_id AS billing_data_id_16, t17.uuid AS uuid_18, t17.company_name AS company_name_19, t17.tax_identifier AS tax_identifier_20, t17.phone_number AS phone_number_21, t17.status AS status_22, t17.enabled AS enabled_23, t17.edited_at AS edited_at_24, t17.commission AS commission_25, t17.commission_type AS commission_type_26, t17.verified_at AS verified_at_27, t17.slug AS slug_28, t17.flq AS flq_29, t17.id AS id_30, t17.vendor_address_id AS vendor_address_id_31, t17.referenceable_content_id AS referenceable_content_id_32, t17.organization_id AS organization_id_33, t0.default_address_id AS default_address_id_34 FROM bitbag_organization t0 LEFT JOIN bitbag_open_marketplace_vendor t17 ON t17.organization_id = t0.id WHERE t0.id = ?
Parameters:
[
  1
]
0.81 ms
(7.02%)
1
SELECT a0_.created_at AS created_at_0, a0_.valid_from AS valid_from_1, a0_.valid_to AS valid_to_2, a0_.prolong AS prolong_3, a0_.id AS id_4, a0_.order_id AS order_id_5, a0_.vendor_id AS vendor_id_6, a0_.seller_plan_id AS seller_plan_id_7 FROM app_subscription a0_ WHERE a0_.vendor_id = ? AND a0_.valid_to > ? AND a0_.valid_from <= ? ORDER BY a0_.valid_to DESC, a0_.id ASC
Parameters:
[
  1
  "2024-09-20 12:40:48"
  "2024-09-20 12:40:48"
]
0.81 ms
(7.00%)
1
SELECT t0.code AS code_1, t0.enabled AS enabled_2, t0.id AS id_3 FROM sylius_country t0 INNER JOIN sylius_channel_countries ON t0.id = sylius_channel_countries.country_id WHERE sylius_channel_countries.channel_id = ?
Parameters:
[
  1
]
0.65 ms
(5.61%)
1
SELECT t0.code AS code_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.id AS id_4 FROM sylius_currency t0 INNER JOIN sylius_channel_currencies ON t0.id = sylius_channel_currencies.currency_id WHERE sylius_channel_currencies.channel_id = ? ORDER BY t0.id ASC
Parameters:
[
  1
]
0.62 ms
(5.42%)
1
SELECT t0.uuid AS uuid_1, t0.path AS path_2, t0.id AS id_3, t0.owner_id AS owner_id_4 FROM bitbag_open_marketplace_vendor_image t0 WHERE t0.owner_id = ?
Parameters:
[
  1
]
0.59 ms
(5.09%)
1
SELECT t0.id AS id_1 FROM dedi_sylius_seo_content t0 WHERE t0.id = ?
Parameters:
[
  1
]
0.44 ms
(3.83%)
1
SELECT b0_.uuid AS uuid_0, b0_.code AS code_1, b0_.published_at AS published_at_2, b0_.last_verified_at AS last_verified_at_3, b0_.created_at AS created_at_4, b0_.deleted AS deleted_5, b0_.enabled AS enabled_6, b0_.verification_status AS verification_status_7, b0_.id AS id_8, b0_.latest_draft_id AS latest_draft_id_9, b0_.vendor_id AS vendor_id_10, b0_.product_id AS product_id_11 FROM bitbag_open_marketplace_product_listing b0_ INNER JOIN bitbag_open_marketplace_product_draft b1_ ON b0_.id = b1_.product_listing_id LEFT JOIN bitbag_open_marketplace_product_draft b2_ ON b0_.id = b2_.product_listing_id AND (b1_.id < b2_.id) WHERE b2_.id IS NULL AND b0_.vendor_id = ? AND b0_.deleted = ? AND b0_.id IN (?) ORDER BY b0_.id ASC
Parameters:
[
  1
  0
  [
    1
    3
    4
    5
  ]
]
0.39 ms
(3.38%)
1
SELECT t0.uuid AS uuid_1, t0.path AS path_2, t0.id AS id_3, t0.owner_id AS owner_id_4 FROM bitbag_open_marketplace_vendor_background_image t0 WHERE t0.owner_id = ?
Parameters:
[
  1
]
0.36 ms
(3.13%)
1
SELECT t0.code AS code_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.id AS id_4 FROM sylius_locale t0 INNER JOIN sylius_channel_locales ON t0.id = sylius_channel_locales.locale_id WHERE sylius_channel_locales.channel_id = ?
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
BitBag\SyliusB2BPlugin\Entity\ProductVariantPrice No errors.
Sylius\Component\Order\Model\Order No errors.
Sylius\Component\Core\Model\Order No errors.
BitBag\OpenMarketplace\Component\Order\Entity\Order No errors.
Sylius\Component\Shipping\Model\Shipment No errors.
Sylius\Component\Core\Model\Shipment No errors.
BitBag\OpenMarketplace\Component\Order\Entity\Shipment No errors.
BitBag\SyliusWishlistPlugin\Entity\Wishlist No errors.
Sylius\Component\Channel\Model\Channel No errors.
Sylius\Component\Core\Model\Channel No errors.
BitBag\OpenMarketplace\Component\Channel\Entity\Channel No errors.
Sylius\Component\Locale\Model\Locale No errors.
Sylius\Component\Currency\Model\Currency No errors.
Sylius\Component\Addressing\Model\Zone No errors.
BitBag\OpenMarketplace\Component\Addressing\Entity\Zone No errors.
Sylius\Component\Taxonomy\Model\Taxon No errors.
Sylius\Component\Core\Model\Taxon No errors.
BitBag\OpenMarketplace\Component\Taxonomy\Entity\Taxon No errors.
Dedi\SyliusSEOPlugin\Entity\SEOContent No errors.
BitBag\OpenMarketplace\Component\SEO\Entity\SEOContent No errors.
Sylius\Component\Core\Model\ShopBillingData No errors.
Sylius\Component\Addressing\Model\Country No errors.
BitBag\OpenMarketplace\Component\Addressing\Entity\Country No errors.
Sylius\Component\User\Model\User No errors.
Sylius\Component\Core\Model\AdminUser No errors.
Sylius\Component\Core\Model\ShopUser No errors.
BitBag\OpenMarketplace\Component\Vendor\Entity\ShopUser No errors.
Sylius\Component\Customer\Model\Customer No errors.
Sylius\Component\Core\Model\Customer No errors.
BitBag\OpenMarketplace\Component\Customer\Entity\Customer No errors.
Sylius\Component\User\Model\UserOAuth No errors.
Sylius\Component\Customer\Model\CustomerGroup No errors.
BitBag\OpenMarketplace\Component\Customer\Entity\CustomerGroup No errors.
BitBag\SyliusB2BPlugin\Entity\Organization No errors.
BitBag\OpenMarketplace\Component\Organization\Entity\Organization No errors.
Sylius\Component\Addressing\Model\Address No errors.
Sylius\Component\Core\Model\Address No errors.
BitBag\OpenMarketplace\Component\Addressing\Entity\Address No errors.
BitBag\SyliusB2BPlugin\Entity\OrganizationPricingList No errors.
BitBag\SyliusB2BPlugin\Entity\OrganizationBillingData No errors.
BitBag\OpenMarketplace\Component\Organization\Entity\OrganizationBillingData No errors.
BitBag\OpenMarketplace\Component\Vendor\Entity\Vendor No errors.
BitBag\OpenMarketplace\Component\Vendor\Entity\Address No errors.
BitBag\OpenMarketplace\Component\MessageRouting\Entity\MessageRouting No errors.
BitBag\OpenMarketplace\Component\RFQ\Entity\RFQ No errors.
BitBag\OpenMarketplace\Component\Inquiry\Entity\Inquiry No errors.
BitBag\OpenMarketplace\Component\Vendor\Entity\VendorShippingMethod No errors.
BitBag\OpenMarketplace\Component\SellerPlan\Entity\Subscription No errors.
BitBag\OpenMarketplace\Component\AddOn\Entity\PurchasedAddOn No errors.
BitBag\OpenMarketplace\Component\Vendor\Entity\VendorTranslation No errors.
BitBag\OpenMarketplace\Component\Vendor\Entity\LogoImage No errors.
BitBag\OpenMarketplace\Component\Vendor\Entity\BackgroundImage No errors.
Sylius\Component\Product\Model\Product No errors.
Sylius\Component\Core\Model\Product No errors.
BitBag\OpenMarketplace\Component\Product\Entity\Product No errors.
BitBag\OpenMarketplace\Component\ProductListing\Entity\Listing No errors.
BitBag\OpenMarketplace\Component\ProductListing\Entity\Draft No errors.
BitBag\OpenMarketplace\Component\SellerPlan\Entity\SellerPlan No errors.
BitBag\SyliusCmsPlugin\Entity\Page No errors.
BitBag\OpenMarketplace\Component\Cms\Entity\Page No errors.
BitBag\SyliusCmsPlugin\Entity\Block No errors.
BitBag\SyliusCmsPlugin\Entity\Media No errors.
BitBag\SyliusBannerPlugin\Entity\Ad No errors.
BitBag\SyliusCmsPlugin\Entity\Section No errors.
Sylius\Component\Product\Model\ProductTranslation No errors.
Sylius\Component\Core\Model\ProductTranslation No errors.
Sylius\Component\Core\Model\ChannelPricing No errors.
BitBag\SyliusCmsPlugin\Entity\PageTranslation No errors.
Sylius\Component\Taxonomy\Model\TaxonTranslation No errors.
BitBag\SyliusBannerPlugin\Entity\Banner No errors.
BitBag\OpenMarketplace\Component\Banner\Entity\Banner No errors.
BitBag\OpenMarketplace\Component\Stats\Entity\Analytics No errors.
BitBag\OpenMarketplace\Component\Stats\Entity\ProductImpressionAnalytics No errors.
Dedi\SyliusSEOPlugin\Entity\SEOContentTranslation No errors.
BitBag\OpenMarketplace\Component\SEO\Entity\SEOContentTranslation No errors.