Redirect 302 redirect from GET @redirect_to_locale (691858)

GET http://dev.shamscout.delivery/en/

Query Metrics

12 Database Queries
9 Different statements
24.27 ms Query time
0 Invalid entities
0 Managed entities

Queries

Group similar statements

# Time Info
1 7.15 ms
SELECT r0_.type AS type_0, r0_.name AS name_1, r0_.description AS description_2, r0_.enabled AS enabled_3, r0_.deposit_refund_enabled AS deposit_refund_enabled_4, r0_.deposit_refund_optin AS deposit_refund_optin_5, r0_.shipping_options_days AS shipping_options_days_6, r0_.image_name AS image_name_7, r0_.banner_image_name AS banner_image_name_8, r0_.website AS website_9, r0_.telephone AS telephone_10, r0_.created_at AS created_at_11, r0_.updated_at AS updated_at_12, r0_.legal_name AS legal_name_13, r0_.delivery_perimeter_expression AS delivery_perimeter_expression_14, r0_.vat_id AS vat_id_15, r0_.additional_properties AS additional_properties_16, r0_.rate_limit_range_duration AS rate_limit_range_duration_17, r0_.rate_limit_amount AS rate_limit_amount_18, r0_.state AS state_19, r0_.stripe_connect_roles AS stripe_connect_roles_20, r0_.mercadopago_connect_roles AS mercadopago_connect_roles_21, r0_.deleted_at AS deleted_at_22, r0_.exclusive AS exclusive_23, r0_.quotes_allowed AS quotes_allowed_24, r0_.loopeat_enabled AS loopeat_enabled_25, r0_.loopeat_mandatory AS loopeat_mandatory_26, r0_.loopeat_access_token AS loopeat_access_token_27, r0_.loopeat_refresh_token AS loopeat_refresh_token_28, r0_.featured AS featured_29, r0_.stripe_payment_methods AS stripe_payment_methods_30, r0_.edenred_merchant_id AS edenred_merchant_id_31, r0_.edenred_enabled AS edenred_enabled_32, r0_.edenred_trcard_enabled AS edenred_trcard_enabled_33, r0_.edenred_sync_sent AS edenred_sync_sent_34, r0_.vytal_enabled AS vytal_enabled_35, r0_.cash_on_delivery_enabled AS cash_on_delivery_enabled_36, r0_.en_boite_le_plat_enabled AS en_boite_le_plat_enabled_37, r0_.en_boite_le_plat_platform_fee AS en_boite_le_plat_platform_fee_38, r0_.auto_accept_orders_enabled AS auto_accept_orders_enabled_39, r0_.paygreen_shop_id AS paygreen_shop_id_40, r0_.billing_method AS billing_method_41, r0_.payment_gateway AS payment_gateway_42, r0_.pawapay_enabled AS pawapay_enabled_43, r0_.id AS id_44, r0_.pledge_id AS pledge_id_45, r0_.mercadopago_account_id AS mercadopago_account_id_46, r0_.contract_id AS contract_id_47, r0_.address_id AS address_id_48, r0_.business_address_id AS business_address_id_49, r0_.active_menu_taxon_id AS active_menu_taxon_id_50, r0_.organization_id AS organization_id_51, r0_.hub_id AS hub_id_52, r0_.failure_reason_set_id AS failure_reason_set_id_53 FROM restaurant r0_ WHERE (r0_.enabled = ?) AND (r0_.enabled = '1') AND (r0_.deleted_at IS NULL)
Parameters:
[
  1
]
2 4.30 ms
SELECT t0.section AS section_1, t0.name AS name_2, t0.value AS value_3 FROM craue_config_setting t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
  "motto"
]
3 0.76 ms
SELECT t0.section AS section_1, t0.name AS name_2, t0.value AS value_3 FROM craue_config_setting t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
  "homepage_published"
]
4 2.04 ms
SELECT r0_.type AS type_0, COUNT(r0_.id) AS sclr_1 FROM restaurant r0_ WHERE (r0_.enabled = '1') AND (r0_.deleted_at IS NULL) GROUP BY r0_.type ORDER BY sclr_1 DESC
Parameters:
[]
5 2.85 ms
SELECT c0_.name AS name_0, COUNT(r1_.id) AS sclr_1 FROM restaurant r1_ INNER JOIN restaurant_cuisine r2_ ON r1_.id = r2_.restaurant_id INNER JOIN cuisine c0_ ON c0_.id = r2_.cuisine_id WHERE (r1_.enabled = '1') AND (r1_.deleted_at IS NULL) GROUP BY c0_.name ORDER BY sclr_1 DESC
Parameters:
[]
6 0.68 ms
SELECT COUNT(r0_.id) AS sclr_0 FROM restaurant r0_ WHERE (r0_.enabled = ? AND (r0_.deposit_refund_enabled = ? OR r0_.loopeat_enabled = ?)) AND (r0_.enabled = '1') AND (r0_.deleted_at IS NULL)
Parameters:
[
  1
  1
  1
]
7 1.41 ms
SELECT d0_.with_vehicle AS with_vehicle_0, d0_.with_weight AS with_weight_1, d0_.show_homepage AS show_homepage_2, d0_.created_at AS created_at_3, d0_.updated_at AS updated_at_4, d0_.id AS id_5, d0_.pricing_rule_set_id AS pricing_rule_set_id_6, d0_.time_slot_id AS time_slot_id_7, d0_.package_set_id AS package_set_id_8 FROM delivery_form d0_ WHERE d0_.show_homepage = ? LIMIT 1
Parameters:
[
  1
]
8 1.02 ms
SELECT r0_.type AS type_0, r0_.name AS name_1, r0_.description AS description_2, r0_.enabled AS enabled_3, r0_.deposit_refund_enabled AS deposit_refund_enabled_4, r0_.deposit_refund_optin AS deposit_refund_optin_5, r0_.shipping_options_days AS shipping_options_days_6, r0_.image_name AS image_name_7, r0_.banner_image_name AS banner_image_name_8, r0_.website AS website_9, r0_.telephone AS telephone_10, r0_.created_at AS created_at_11, r0_.updated_at AS updated_at_12, r0_.legal_name AS legal_name_13, r0_.delivery_perimeter_expression AS delivery_perimeter_expression_14, r0_.vat_id AS vat_id_15, r0_.additional_properties AS additional_properties_16, r0_.rate_limit_range_duration AS rate_limit_range_duration_17, r0_.rate_limit_amount AS rate_limit_amount_18, r0_.state AS state_19, r0_.stripe_connect_roles AS stripe_connect_roles_20, r0_.mercadopago_connect_roles AS mercadopago_connect_roles_21, r0_.deleted_at AS deleted_at_22, r0_.exclusive AS exclusive_23, r0_.quotes_allowed AS quotes_allowed_24, r0_.loopeat_enabled AS loopeat_enabled_25, r0_.loopeat_mandatory AS loopeat_mandatory_26, r0_.loopeat_access_token AS loopeat_access_token_27, r0_.loopeat_refresh_token AS loopeat_refresh_token_28, r0_.featured AS featured_29, r0_.stripe_payment_methods AS stripe_payment_methods_30, r0_.edenred_merchant_id AS edenred_merchant_id_31, r0_.edenred_enabled AS edenred_enabled_32, r0_.edenred_trcard_enabled AS edenred_trcard_enabled_33, r0_.edenred_sync_sent AS edenred_sync_sent_34, r0_.vytal_enabled AS vytal_enabled_35, r0_.cash_on_delivery_enabled AS cash_on_delivery_enabled_36, r0_.en_boite_le_plat_enabled AS en_boite_le_plat_enabled_37, r0_.en_boite_le_plat_platform_fee AS en_boite_le_plat_platform_fee_38, r0_.auto_accept_orders_enabled AS auto_accept_orders_enabled_39, r0_.paygreen_shop_id AS paygreen_shop_id_40, r0_.billing_method AS billing_method_41, r0_.payment_gateway AS payment_gateway_42, r0_.pawapay_enabled AS pawapay_enabled_43, r0_.id AS id_44, r0_.pledge_id AS pledge_id_45, r0_.mercadopago_account_id AS mercadopago_account_id_46, r0_.contract_id AS contract_id_47, r0_.address_id AS address_id_48, r0_.business_address_id AS business_address_id_49, r0_.active_menu_taxon_id AS active_menu_taxon_id_50, r0_.organization_id AS organization_id_51, r0_.hub_id AS hub_id_52, r0_.failure_reason_set_id AS failure_reason_set_id_53 FROM restaurant r0_ WHERE (r0_.featured = ?) AND (r0_.enabled = '1') AND (r0_.deleted_at IS NULL)
Parameters:
[
  1
]
9 1.00 ms
SELECT r0_.type AS type_0, r0_.name AS name_1, r0_.description AS description_2, r0_.enabled AS enabled_3, r0_.deposit_refund_enabled AS deposit_refund_enabled_4, r0_.deposit_refund_optin AS deposit_refund_optin_5, r0_.shipping_options_days AS shipping_options_days_6, r0_.image_name AS image_name_7, r0_.banner_image_name AS banner_image_name_8, r0_.website AS website_9, r0_.telephone AS telephone_10, r0_.created_at AS created_at_11, r0_.updated_at AS updated_at_12, r0_.legal_name AS legal_name_13, r0_.delivery_perimeter_expression AS delivery_perimeter_expression_14, r0_.vat_id AS vat_id_15, r0_.additional_properties AS additional_properties_16, r0_.rate_limit_range_duration AS rate_limit_range_duration_17, r0_.rate_limit_amount AS rate_limit_amount_18, r0_.state AS state_19, r0_.stripe_connect_roles AS stripe_connect_roles_20, r0_.mercadopago_connect_roles AS mercadopago_connect_roles_21, r0_.deleted_at AS deleted_at_22, r0_.exclusive AS exclusive_23, r0_.quotes_allowed AS quotes_allowed_24, r0_.loopeat_enabled AS loopeat_enabled_25, r0_.loopeat_mandatory AS loopeat_mandatory_26, r0_.loopeat_access_token AS loopeat_access_token_27, r0_.loopeat_refresh_token AS loopeat_refresh_token_28, r0_.featured AS featured_29, r0_.stripe_payment_methods AS stripe_payment_methods_30, r0_.edenred_merchant_id AS edenred_merchant_id_31, r0_.edenred_enabled AS edenred_enabled_32, r0_.edenred_trcard_enabled AS edenred_trcard_enabled_33, r0_.edenred_sync_sent AS edenred_sync_sent_34, r0_.vytal_enabled AS vytal_enabled_35, r0_.cash_on_delivery_enabled AS cash_on_delivery_enabled_36, r0_.en_boite_le_plat_enabled AS en_boite_le_plat_enabled_37, r0_.en_boite_le_plat_platform_fee AS en_boite_le_plat_platform_fee_38, r0_.auto_accept_orders_enabled AS auto_accept_orders_enabled_39, r0_.paygreen_shop_id AS paygreen_shop_id_40, r0_.billing_method AS billing_method_41, r0_.payment_gateway AS payment_gateway_42, r0_.pawapay_enabled AS pawapay_enabled_43, r0_.id AS id_44, r0_.pledge_id AS pledge_id_45, r0_.mercadopago_account_id AS mercadopago_account_id_46, r0_.contract_id AS contract_id_47, r0_.address_id AS address_id_48, r0_.business_address_id AS business_address_id_49, r0_.active_menu_taxon_id AS active_menu_taxon_id_50, r0_.organization_id AS organization_id_51, r0_.hub_id AS hub_id_52, r0_.failure_reason_set_id AS failure_reason_set_id_53 FROM restaurant r0_ WHERE (r0_.exclusive = ?) AND (r0_.enabled = '1') AND (r0_.deleted_at IS NULL)
Parameters:
[
  1
]
10 2.07 ms
SELECT r0_.type AS type_0, r0_.name AS name_1, r0_.description AS description_2, r0_.enabled AS enabled_3, r0_.deposit_refund_enabled AS deposit_refund_enabled_4, r0_.deposit_refund_optin AS deposit_refund_optin_5, r0_.shipping_options_days AS shipping_options_days_6, r0_.image_name AS image_name_7, r0_.banner_image_name AS banner_image_name_8, r0_.website AS website_9, r0_.telephone AS telephone_10, r0_.created_at AS created_at_11, r0_.updated_at AS updated_at_12, r0_.legal_name AS legal_name_13, r0_.delivery_perimeter_expression AS delivery_perimeter_expression_14, r0_.vat_id AS vat_id_15, r0_.additional_properties AS additional_properties_16, r0_.rate_limit_range_duration AS rate_limit_range_duration_17, r0_.rate_limit_amount AS rate_limit_amount_18, r0_.state AS state_19, r0_.stripe_connect_roles AS stripe_connect_roles_20, r0_.mercadopago_connect_roles AS mercadopago_connect_roles_21, r0_.deleted_at AS deleted_at_22, r0_.exclusive AS exclusive_23, r0_.quotes_allowed AS quotes_allowed_24, r0_.loopeat_enabled AS loopeat_enabled_25, r0_.loopeat_mandatory AS loopeat_mandatory_26, r0_.loopeat_access_token AS loopeat_access_token_27, r0_.loopeat_refresh_token AS loopeat_refresh_token_28, r0_.featured AS featured_29, r0_.stripe_payment_methods AS stripe_payment_methods_30, r0_.edenred_merchant_id AS edenred_merchant_id_31, r0_.edenred_enabled AS edenred_enabled_32, r0_.edenred_trcard_enabled AS edenred_trcard_enabled_33, r0_.edenred_sync_sent AS edenred_sync_sent_34, r0_.vytal_enabled AS vytal_enabled_35, r0_.cash_on_delivery_enabled AS cash_on_delivery_enabled_36, r0_.en_boite_le_plat_enabled AS en_boite_le_plat_enabled_37, r0_.en_boite_le_plat_platform_fee AS en_boite_le_plat_platform_fee_38, r0_.auto_accept_orders_enabled AS auto_accept_orders_enabled_39, r0_.paygreen_shop_id AS paygreen_shop_id_40, r0_.billing_method AS billing_method_41, r0_.payment_gateway AS payment_gateway_42, r0_.pawapay_enabled AS pawapay_enabled_43, r0_.id AS id_44, r0_.pledge_id AS pledge_id_45, r0_.mercadopago_account_id AS mercadopago_account_id_46, r0_.contract_id AS contract_id_47, r0_.address_id AS address_id_48, r0_.business_address_id AS business_address_id_49, r0_.active_menu_taxon_id AS active_menu_taxon_id_50, r0_.organization_id AS organization_id_51, r0_.hub_id AS hub_id_52, r0_.failure_reason_set_id AS failure_reason_set_id_53 FROM restaurant r0_ WHERE (r0_.enabled = '1') AND (r0_.deleted_at IS NULL) ORDER BY r0_.created_at DESC LIMIT 12
Parameters:
[]
11 0.52 ms
SELECT t0.section AS section_1, t0.name AS name_2, t0.value AS value_3 FROM craue_config_setting t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
  "phone_number"
]
12 0.46 ms
SELECT t0.section AS section_1, t0.name AS name_2, t0.value AS value_3 FROM craue_config_setting t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
  "enable_restaurant_pledges"
]

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.

Managed Entities

default entity manager

Class Amount of managed objects

Entities Mapping

Class Mapping errors
Sylius\Component\Product\Model\Product No errors.
AppBundle\Entity\Sylius\Product No errors.
Sylius\Component\Product\Model\ProductOptionValue No errors.
AppBundle\Entity\Sylius\ProductOptionValue No errors.
Sylius\Component\Product\Model\ProductVariant No errors.
AppBundle\Entity\Sylius\ProductVariant No errors.
Sylius\Component\Taxation\Model\TaxCategory No errors.
AppBundle\Entity\Sylius\TaxCategory No errors.
Sylius\Component\Promotion\Model\Promotion No errors.
AppBundle\Entity\Sylius\Promotion No errors.
Sylius\Component\Order\Model\Order No errors.
AppBundle\Entity\Sylius\Order No errors.
AppBundle\Entity\TaskCollection No errors.
AppBundle\Entity\Delivery No errors.
Sylius\Component\Promotion\Model\PromotionCoupon No errors.
AppBundle\Entity\Sylius\PromotionCoupon No errors.
AppBundle\Entity\Zone No errors.
Sylius\Component\Currency\Model\ExchangeRate No errors.
AppBundle\Entity\LocalBusiness No errors.
Sylius\Component\Product\Model\ProductOption No errors.
AppBundle\Entity\Sylius\ProductOption No errors.
Sylius\Component\Taxation\Model\TaxRate No errors.
AppBundle\Entity\Sylius\TaxRate No errors.
Sylius\Component\Payment\Model\PaymentMethod No errors.
Sylius\Component\Customer\Model\Customer No errors.
AppBundle\Entity\Sylius\Customer No errors.
Sylius\Component\Taxonomy\Model\Taxon No errors.
AppBundle\Entity\Sylius\Taxon No errors.
AppBundle\Entity\Restaurant\Pledge No errors.
AppBundle\Entity\MercadopagoAccount No errors.
AppBundle\Entity\Contract No errors.
AppBundle\Entity\Base\PostalAddress No errors.
AppBundle\Entity\Address No errors.
AppBundle\Entity\Organization No errors.
AppBundle\Entity\Hub No errors.
AppBundle\Entity\Delivery\FailureReasonSet No errors.
Craue\ConfigBundle\Entity\BaseSetting No errors.
AppBundle\Entity\Setting No errors.
AppBundle\Entity\Cuisine No errors.
AppBundle\Entity\DeliveryForm No errors.
AppBundle\Entity\Delivery\PricingRuleSet No errors.
AppBundle\Entity\TimeSlot No errors.
AppBundle\Entity\PackageSet No errors.