|
DEBUG
01:48:15
|
doctrine |
SELECT r0_.id AS id_0, r0_.prefix AS prefix_1, r0_.source AS source_2, r0_.target AS target_3 FROM redirect r0_ WHERE r0_.source = ? OR (r0_.prefix = 1 AND ? LIKE CONCAT(r0_.source, '%')) LIMIT 1 [
"/nl/zelf-samenstellen/878",
"/nl/zelf-samenstellen/878"
]
|
|
INFO
01:48:15
|
request |
Matched route "tmk_individual_parts". {
"route": "tmk_individual_parts",
"route_parameters": {
"_route": "tmk_individual_parts",
"_controller": "App\\Controller\\IndividualPartsController::individualParts",
"_locale": "nl",
"id": "878"
},
"request_uri": "https://tmk-4so.z2d.nl/nl/zelf-samenstellen/878?page=1",
"method": "GET"
}
|
|
INFO
01:48:15
|
php |
Deprecated: explode(): Passing null to parameter #2 ($string) of type string is deprecated {
"exception": {}
}
|
|
DEBUG
01:48:15
|
security |
Checking for authenticator support. {
"firewall_name": "boldr_users",
"authenticators": 1
}
|
|
DEBUG
01:48:15
|
security |
Checking support on authenticator. {
"firewall_name": "boldr_users",
"authenticator": "Boldr\\Cms\\UsersBundle\\Security\\UserAuthenticator"
}
|
|
DEBUG
01:48:15
|
security |
Authenticator does not support the request. {
"firewall_name": "boldr_users",
"authenticator": "Boldr\\Cms\\UsersBundle\\Security\\UserAuthenticator"
}
|
|
DEBUG
01:48:15
|
event |
Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\DebugHandlersListener::configure". {
"event": "kernel.request",
"listener": "Symfony\\Component\\HttpKernel\\EventListener\\DebugHandlersListener::configure"
}
|
|
DEBUG
01:48:15
|
event |
Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\ValidateRequestListener::onKernelRequest". {
"event": "kernel.request",
"listener": "Symfony\\Component\\HttpKernel\\EventListener\\ValidateRequestListener::onKernelRequest"
}
|
|
DEBUG
01:48:15
|
event |
Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\SessionListener::onKernelRequest". {
"event": "kernel.request",
"listener": "Symfony\\Component\\HttpKernel\\EventListener\\SessionListener::onKernelRequest"
}
|
|
DEBUG
01:48:15
|
event |
Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\LocaleListener::setDefaultLocale". {
"event": "kernel.request",
"listener": "Symfony\\Component\\HttpKernel\\EventListener\\LocaleListener::setDefaultLocale"
}
|
|
DEBUG
01:48:15
|
event |
Notified event "kernel.request" to listener "Boldr\Cms\RedirectBundle\EventSubscriber\KernelEventSubscriber::onKernelRequest". {
"event": "kernel.request",
"listener": "Boldr\\Cms\\RedirectBundle\\EventSubscriber\\KernelEventSubscriber::onKernelRequest"
}
|
|
DEBUG
01:48:15
|
event |
Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\RouterListener::onKernelRequest". {
"event": "kernel.request",
"listener": "Symfony\\Component\\HttpKernel\\EventListener\\RouterListener::onKernelRequest"
}
|
|
DEBUG
01:48:15
|
event |
Notified event "kernel.request" to listener "Boldr\Cms\CmsBundle\EventSubscriber\LocaleSubscriber::onKernelRequest". {
"event": "kernel.request",
"listener": "Boldr\\Cms\\CmsBundle\\EventSubscriber\\LocaleSubscriber::onKernelRequest"
}
|
|
DEBUG
01:48:15
|
event |
Notified event "kernel.request" to listener "Boldr\Cms\CmsBundle\EventSubscriber\CookieSubscriber::onKernelRequest". {
"event": "kernel.request",
"listener": "Boldr\\Cms\\CmsBundle\\EventSubscriber\\CookieSubscriber::onKernelRequest"
}
|
|
DEBUG
01:48:15
|
event |
Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\LocaleListener::onKernelRequest". {
"event": "kernel.request",
"listener": "Symfony\\Component\\HttpKernel\\EventListener\\LocaleListener::onKernelRequest"
}
|
|
DEBUG
01:48:15
|
event |
Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\LocaleAwareListener::onKernelRequest". {
"event": "kernel.request",
"listener": "Symfony\\Component\\HttpKernel\\EventListener\\LocaleAwareListener::onKernelRequest"
}
|
|
DEBUG
01:48:15
|
event |
Notified event "kernel.request" to listener "EasyCorp\Bundle\EasyAdminBundle\EventListener\AdminRouterSubscriber::handleLegacyEaContext". {
"event": "kernel.request",
"listener": "EasyCorp\\Bundle\\EasyAdminBundle\\EventListener\\AdminRouterSubscriber::handleLegacyEaContext"
}
|
|
DEBUG
01:48:15
|
event |
Notified event "kernel.request" to listener "Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener::configureLogoutUrlGenerator". {
"event": "kernel.request",
"listener": "Symfony\\Bundle\\SecurityBundle\\Debug\\TraceableFirewallListener::configureLogoutUrlGenerator"
}
|
|
DEBUG
01:48:15
|
event |
Notified event "kernel.request" to listener "Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener::onKernelRequest". {
"event": "kernel.request",
"listener": "Symfony\\Bundle\\SecurityBundle\\Debug\\TraceableFirewallListener::onKernelRequest"
}
|
|
DEBUG
01:48:15
|
event |
Notified event "kernel.request" to listener "App\EventSubscriber\CustomerLocaleSubscriber::onKernelRequest". {
"event": "kernel.request",
"listener": "App\\EventSubscriber\\CustomerLocaleSubscriber::onKernelRequest"
}
|
|
DEBUG
01:48:15
|
event |
Notified event "kernel.request" to listener "EasyCorp\Bundle\EasyAdminBundle\EventListener\AdminRouterSubscriber::onKernelRequest". {
"event": "kernel.request",
"listener": "EasyCorp\\Bundle\\EasyAdminBundle\\EventListener\\AdminRouterSubscriber::onKernelRequest"
}
|
|
DEBUG
01:48:15
|
event |
Notified event "kernel.request" to listener "Boldr\Shop\ShopUtmBundle\EventSubscriber::onKernelRequest". {
"event": "kernel.request",
"listener": "Boldr\\Shop\\ShopUtmBundle\\EventSubscriber::onKernelRequest"
}
|
|
DEBUG
01:48:15
|
doctrine |
SELECT t0.id AS id_1, t0.enabled AS enabled_2, t0.deleted AS deleted_3, t0.primary_category_id AS primary_category_id_4, t0.primary_image_id AS primary_image_id_5, t0.primary_product_image_id AS primary_product_image_id_6, t0.default_variant_id AS default_variant_id_7 FROM shop_product t0 WHERE t0.id = ? [
"878"
]
|
|
DEBUG
01:48:15
|
event |
Notified event "kernel.controller" to listener "EasyCorp\Bundle\EasyAdminBundle\EventListener\AdminRouterSubscriber::onKernelController". {
"event": "kernel.controller",
"listener": "EasyCorp\\Bundle\\EasyAdminBundle\\EventListener\\AdminRouterSubscriber::onKernelController"
}
|
|
DEBUG
01:48:15
|
event |
Notified event "kernel.controller" to listener "Symfony\Bundle\FrameworkBundle\DataCollector\RouterDataCollector::onKernelController". {
"event": "kernel.controller",
"listener": "Symfony\\Bundle\\FrameworkBundle\\DataCollector\\RouterDataCollector::onKernelController"
}
|
|
DEBUG
01:48:15
|
event |
Notified event "kernel.controller" to listener "Symfony\Component\HttpKernel\DataCollector\RequestDataCollector::onKernelController". {
"event": "kernel.controller",
"listener": "Symfony\\Component\\HttpKernel\\DataCollector\\RequestDataCollector::onKernelController"
}
|
|
DEBUG
01:48:15
|
event |
Notified event "kernel.controller" to listener "Sensio\Bundle\FrameworkExtraBundle\EventListener\ControllerListener::onKernelController". {
"event": "kernel.controller",
"listener": "Sensio\\Bundle\\FrameworkExtraBundle\\EventListener\\ControllerListener::onKernelController"
}
|
|
DEBUG
01:48:15
|
event |
Notified event "kernel.controller" to listener "Sensio\Bundle\FrameworkExtraBundle\EventListener\ParamConverterListener::onKernelController". {
"event": "kernel.controller",
"listener": "Sensio\\Bundle\\FrameworkExtraBundle\\EventListener\\ParamConverterListener::onKernelController"
}
|
|
DEBUG
01:48:15
|
event |
Notified event "kernel.controller" to listener "Sensio\Bundle\FrameworkExtraBundle\EventListener\HttpCacheListener::onKernelController". {
"event": "kernel.controller",
"listener": "Sensio\\Bundle\\FrameworkExtraBundle\\EventListener\\HttpCacheListener::onKernelController"
}
|
|
DEBUG
01:48:15
|
event |
Notified event "kernel.controller" to listener "Sensio\Bundle\FrameworkExtraBundle\EventListener\TemplateListener::onKernelController". {
"event": "kernel.controller",
"listener": "Sensio\\Bundle\\FrameworkExtraBundle\\EventListener\\TemplateListener::onKernelController"
}
|
|
DEBUG
01:48:15
|
event |
Notified event "kernel.controller_arguments" to listener "Symfony\Component\HttpKernel\EventListener\ErrorListener::onControllerArguments". {
"event": "kernel.controller_arguments",
"listener": "Symfony\\Component\\HttpKernel\\EventListener\\ErrorListener::onControllerArguments"
}
|
|
DEBUG
01:48:15
|
event |
Notified event "kernel.controller_arguments" to listener "Sensio\Bundle\FrameworkExtraBundle\EventListener\SecurityListener::onKernelControllerArguments". {
"event": "kernel.controller_arguments",
"listener": "Sensio\\Bundle\\FrameworkExtraBundle\\EventListener\\SecurityListener::onKernelControllerArguments"
}
|
|
DEBUG
01:48:15
|
event |
Notified event "kernel.controller_arguments" to listener "Sensio\Bundle\FrameworkExtraBundle\EventListener\IsGrantedListener::onKernelControllerArguments". {
"event": "kernel.controller_arguments",
"listener": "Sensio\\Bundle\\FrameworkExtraBundle\\EventListener\\IsGrantedListener::onKernelControllerArguments"
}
|
|
DEBUG
01:48:15
|
doctrine |
SELECT t0.id AS id_1, t0.enabled AS enabled_2, t0.time_added AS time_added_3, t0.sort_order AS sort_order_4, t0.product_id AS product_id_5, t6.id AS id_7, t6.enabled AS enabled_8, t6.deleted AS deleted_9, t6.primary_category_id AS primary_category_id_10, t6.primary_image_id AS primary_image_id_11, t6.primary_product_image_id AS primary_product_image_id_12, t6.default_variant_id AS default_variant_id_13, t0.primary_image_id AS primary_image_id_14 FROM shop_product_variant t0 INNER JOIN shop_product t6 ON t0.product_id = t6.id WHERE t0.product_id = ? ORDER BY t0.sort_order ASC [
878
]
|
|
DEBUG
01:48:15
|
doctrine |
SELECT s0_.id AS id_0, s0_.enabled AS enabled_1, s0_.time_added AS time_added_2, s0_.sort_order AS sort_order_3, s1_.id AS id_4, s1_.locale AS locale_5, s1_.name AS name_6, s1_.permalink AS permalink_7, s1_.description AS description_8, s1_.short_description AS short_description_9, s0_.product_id AS product_id_10, s0_.primary_image_id AS primary_image_id_11, s1_.product_variant_id AS product_variant_id_12 FROM shop_product_variant s0_ LEFT JOIN shop_product_variant_translation s1_ ON s0_.id = s1_.product_variant_id LEFT JOIN shop_product s2_ ON s0_.product_id = s2_.id WHERE s0_.id IN (?) AND s0_.enabled = 1 AND s2_.enabled = 1 [
[
878,
879,
880,
881,
882,
1242
]
]
|
|
DEBUG
01:48:15
|
doctrine |
SELECT s0_.id AS id_0, s0_.enabled AS enabled_1, s0_.deleted AS deleted_2, s1_.sort_order AS sort_order_3, s2_.id AS id_4, s2_.visible AS visible_5, s2_.sort_order AS sort_order_6, s2_.show_as_filter AS show_as_filter_7, s3_.id AS id_8, s3_.locale AS locale_9, s3_.name AS name_10, s3_.permalink AS permalink_11, s3_.content_elements AS content_elements_12, s0_.primary_category_id AS primary_category_id_13, s0_.primary_image_id AS primary_image_id_14, s0_.primary_product_image_id AS primary_product_image_id_15, s0_.default_variant_id AS default_variant_id_16, s1_.product_id AS product_id_17, s1_.category_id AS category_id_18, s2_.parent_id AS parent_id_19, s3_.category_id AS category_id_20 FROM shop_product s0_ LEFT JOIN shop_product_category s1_ ON s0_.id = s1_.product_id LEFT JOIN shop_category s2_ ON s1_.category_id = s2_.id LEFT JOIN shop_category_translation s3_ ON s2_.id = s3_.category_id WHERE s0_.id IN (?) [
[
878
]
]
|
|
DEBUG
01:48:15
|
doctrine |
SELECT s0_.id AS id_0, s0_.enabled AS enabled_1, s0_.deleted AS deleted_2, s1_.id AS id_3, s1_.locale AS locale_4, s1_.name AS name_5, s1_.permalink AS permalink_6, s1_.description AS description_7, s1_.short_description AS short_description_8, s0_.primary_category_id AS primary_category_id_9, s0_.primary_image_id AS primary_image_id_10, s0_.primary_product_image_id AS primary_product_image_id_11, s0_.default_variant_id AS default_variant_id_12, s1_.product_id AS product_id_13 FROM shop_product s0_ LEFT JOIN shop_product_translation s1_ ON s0_.id = s1_.product_id WHERE s0_.id IN (?) [
[
878
]
]
|
|
DEBUG
01:48:15
|
doctrine |
SELECT s0_.id AS id_0, s0_.enabled AS enabled_1, s0_.deleted AS deleted_2, s1_.id AS id_3, s1_.enabled AS enabled_4, s1_.time_added AS time_added_5, s1_.sort_order AS sort_order_6, s0_.primary_category_id AS primary_category_id_7, s0_.primary_image_id AS primary_image_id_8, s0_.primary_product_image_id AS primary_product_image_id_9, s0_.default_variant_id AS default_variant_id_10, s1_.product_id AS product_id_11, s1_.primary_image_id AS primary_image_id_12 FROM shop_product s0_ LEFT JOIN shop_product_variant s1_ ON s0_.id = s1_.product_id WHERE s0_.id IN (?) ORDER BY s1_.sort_order ASC [
[
878
]
]
|
|
DEBUG
01:48:15
|
doctrine |
SELECT t0.show_individual_parts_on_product_page AS show_individual_parts_on_product_page_1, t0.hide_price AS hide_price_2, t0.search_weight AS search_weight_3, t0.product_id AS product_id_4, t0.header_image_id AS header_image_id_5, t0.hover_image_id AS hover_image_id_6, t0.component_option_id AS component_option_id_7 FROM tmk_product_options t0 WHERE t0.product_id IN (?) [
878
]
|
|
DEBUG
01:48:15
|
doctrine |
SELECT t0.video AS video_1, t0.product_id AS product_id_2, t0.shop_id AS shop_id_3 FROM tmk_shop_product_options t0 WHERE t0.product_id IN (?) [
878
]
|
|
DEBUG
01:48:15
|
doctrine |
SELECT p0_.locale AS locale_0, p0_.meta_description AS meta_description_1, p0_.product_id AS product_id_2 FROM product_options_translation p0_ LEFT JOIN shop_product s1_ ON p0_.product_id = s1_.id WHERE s1_.id IN (?) AND p0_.locale = ? [
[
878
],
"nl"
]
|
|
DEBUG
01:48:15
|
doctrine |
SELECT s0_.id AS id_0, s1_.id AS id_1 FROM shop_product_category s2_ LEFT JOIN shop_product s0_ ON s2_.product_id = s0_.id LEFT JOIN shop_category s1_ ON s2_.category_id = s1_.id WHERE s2_.product_id IN (?) [
[
878
]
]
|
|
DEBUG
01:48:15
|
doctrine |
SELECT t0.id AS id_1, t0.display_order AS display_order_2 FROM faq_category t0 WHERE t0.id IN (?) [
175
]
|
|
DEBUG
01:48:15
|
doctrine |
SELECT b0_.id AS id_0, s1_.id AS id_1 FROM shop_product_brand s2_ LEFT JOIN shop_product s1_ ON s2_.product_id = s1_.id LEFT JOIN brand_brand b0_ ON s2_.brand_id = b0_.id WHERE s1_.id IN (?) [
[
878
]
]
|
|
DEBUG
01:48:15
|
doctrine |
SELECT t0.id AS id_1, t0.name AS name_2, t0.permalink AS permalink_3, t0.sort_order AS sort_order_4, t0.logo_id AS logo_id_5 FROM brand_brand t0 WHERE t0.id IN (?) [
19
]
|
|
DEBUG
01:48:15
|
doctrine |
SELECT s0_.id AS id_0, s1_.rate AS rate_1 FROM shop_product s0_ LEFT JOIN shop_product_vat_rate s1_ ON (s1_.product_id = s0_.id) WHERE s0_.id IN (?) AND s1_.product_id IS NOT NULL [
[
878
]
]
|
|
DEBUG
01:48:15
|
doctrine |
SELECT s0_.id AS id_0, s1_.rate AS rate_1 FROM shop_product s0_ LEFT JOIN shop_product_category s2_ ON s0_.id = s2_.product_id LEFT JOIN shop_category_vat_rate s1_ ON (s1_.category_id = s2_.category_id) WHERE s0_.id IN (?) AND s1_.category_id IS NOT NULL [
[
878
]
]
|
|
DEBUG
01:48:15
|
doctrine |
SELECT s0_.id AS id_0, p1_.id AS id_1, COUNT(s2_.id) AS sclr_2 FROM product_label_product_label p3_ LEFT JOIN shop_product s0_ ON p3_.product_id = s0_.id LEFT JOIN product_label_label p1_ ON p3_.label_id = p1_.id LEFT JOIN shop_product_variant s2_ ON s0_.id = s2_.product_id WHERE s0_.id IN (?) GROUP BY s0_.id, p1_.id [
[
878
]
]
|
|
DEBUG
01:48:15
|
doctrine |
SELECT s0_.id AS id_0, COUNT(s1_.id) AS sclr_1 FROM shop_product s0_ LEFT JOIN shop_product_variant s1_ ON s0_.id = s1_.product_id WHERE s0_.id IN (?) GROUP BY s0_.id [
[
878
]
]
|
|
DEBUG
01:48:15
|
doctrine |
SELECT t0.id AS id_1, t0.name AS name_2, t0.noreply_email AS noreply_email_3, t0.confirmation_email AS confirmation_email_4, t0.enabled AS enabled_5, t0.company_name AS company_name_6, t0.company_address AS company_address_7, t0.company_registration_details AS company_registration_details_8, t0.default_country AS default_country_9, t0.logo_id AS logo_id_10 FROM multishop_shop t0 |
|
DEBUG
01:48:15
|
doctrine |
SELECT s0_.id AS id_0, p1_.id AS id_1, m2_.id AS id_2 FROM shop_product_label_product_label s3_ LEFT JOIN shop_product s0_ ON s3_.product_id = s0_.id LEFT JOIN product_label_label p1_ ON s3_.label_id = p1_.id LEFT JOIN multishop_shop m2_ ON s3_.shop_id = m2_.id WHERE s0_.id IN (?) [
[
878
]
]
|
|
DEBUG
01:48:15
|
doctrine |
SELECT s0_.id AS id_0, m1_.id AS id_1, t2_.price AS price_2, t2_.sale_price AS sale_price_3 FROM tmk_shop_product_variant_options t2_ LEFT JOIN shop_product_variant s0_ ON t2_.product_variant_id = s0_.id LEFT JOIN multishop_shop m1_ ON t2_.shop_id = m1_.id WHERE s0_.id IN (?) [
[
878,
879,
880,
881,
882,
1242
]
]
|
|
DEBUG
01:48:15
|
doctrine |
SELECT t0.id AS id_1, t0.domain AS domain_2, t0.shop_id AS shop_id_3 FROM multishop_shop_domain t0 WHERE t0.domain = ? LIMIT 1 [
"tmk-4so.z2d.nl"
]
|
|
DEBUG
01:48:15
|
doctrine |
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.shop_id AS shop_id_3, t0.price_shop_id AS price_shop_id_4 FROM tmk_shop_locale_price_parent t0 WHERE t0.shop_id = ? AND t0.locale = ? LIMIT 1 [
1,
"nl"
]
|
|
DEBUG
01:48:15
|
doctrine |
SELECT t0.site_class AS site_class_1, t0.phone AS phone_2, t0.email AS email_3, t0.product_menu_location AS product_menu_location_4, t0.trusted_shops_channel_id AS trusted_shops_channel_id_5, t0.separate_category_texts AS separate_category_texts_6, t0.shop_id AS shop_id_7, t0.parent_id AS parent_id_8, t0.review_parent_id AS review_parent_id_9, t0.structure_parent_id AS structure_parent_id_10, t0.logo_de_id AS logo_de_id_11, t0.logo_en_id AS logo_en_id_12, t0.homepage_id AS homepage_id_13 FROM tmk_shop_options t0 WHERE t0.shop_id = ? LIMIT 1 [
1
]
|
|
DEBUG
01:48:15
|
doctrine |
SELECT t0.show_tip_best_deal AS show_tip_best_deal_1, t0.article_number AS article_number_2, t0.amount_multiple AS amount_multiple_3, t0.product_variant_id AS product_variant_id_4, t0.hover_image_id AS hover_image_id_5 FROM tmk_product_variant_options t0 WHERE t0.product_variant_id IN (?, ?, ?, ?, ?, ?) [
878,
879,
880,
881,
882,
1242
]
|
|
DEBUG
01:48:15
|
doctrine |
SELECT c0_.id AS id_0, c0_.type AS type_1, c0_.storage_identifier AS storage_identifier_2, c0_.public_name AS public_name_3, c0_.derivatives AS derivatives_4, c0_.enqueued_derivatives AS enqueued_derivatives_5, c0_.derivatives_enqueued AS derivatives_enqueued_6, c0_.mime_type AS mime_type_7, c0_.size AS size_8, c0_.width AS width_9, c0_.height AS height_10, c0_.time_uploaded AS time_uploaded_11, c1_.id AS id_12, c1_.locale AS locale_13, c1_.display_name AS display_name_14, c1_.description AS description_15, c1_.upload_id AS upload_id_16 FROM cms_upload c0_ LEFT JOIN cms_upload_translation c1_ ON c0_.id = c1_.upload_id WHERE c0_.id IN (?) [
[
13752
]
]
|
|
DEBUG
01:48:15
|
doctrine |
SELECT t0.locale AS locale_1, t0.extra_text AS extra_text_2, t0.meta_description AS meta_description_3, t0.product_variant_id AS product_variant_id_4 FROM product_variant_options_translation t0 WHERE t0.product_variant_id IN (?, ?, ?, ?, ?, ?) [
878,
879,
880,
881,
882,
1242
]
|
|
DEBUG
01:48:15
|
doctrine |
SELECT t0.pay_in_advance AS pay_in_advance_1, t0.price AS price_2, t0.sale_price AS sale_price_3, t0.enabled AS enabled_4, t0.video AS video_5, t0.shop_id AS shop_id_6, t0.product_variant_id AS product_variant_id_7, t0.shipping_costs_category_id AS shipping_costs_category_id_8 FROM tmk_shop_product_variant_options t0 WHERE t0.product_variant_id IN (?, ?, ?, ?, ?, ?) AND t0.shop_id = ? [
878,
879,
880,
881,
882,
1242,
1
]
|
|
DEBUG
01:48:15
|
doctrine |
SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.match_field AS match_field_2, s0_.match_pattern AS match_pattern_3, s0_.match_condition AS match_condition_4, s0_.parent_id AS parent_id_5 FROM shop_zone s0_ WHERE s0_.match_field IS NOT NULL AND s0_.parent_id IS NULL |
|
DEBUG
01:48:15
|
doctrine |
SELECT t0.id AS id_1, t0.name AS name_2, t0.match_field AS match_field_3, t0.match_pattern AS match_pattern_4, t0.match_condition AS match_condition_5, t0.parent_id AS parent_id_6 FROM shop_zone t0 WHERE t0.parent_id = ? [
2
]
|
|
DEBUG
01:48:15
|
doctrine |
SELECT s0_.id AS id_0 FROM shop_product_category s1_ LEFT JOIN shop_product s2_ ON s1_.product_id = s2_.id LEFT JOIN shop_product_variant s0_ ON s2_.id = s0_.product_id WHERE s0_.id IN (?) AND s1_.category_id IN (?) [
[
878,
879,
880,
881,
882,
1242
],
[
203,
204
]
]
|
|
DEBUG
01:48:15
|
doctrine |
SELECT s0_.id AS id_0, s1_.id AS id_1 FROM tmk_product_options t2_ LEFT JOIN shop_option s1_ ON t2_.component_option_id = s1_.id LEFT JOIN shop_select_option s3_ ON s1_.id = s3_.id LEFT JOIN shop_product s4_ ON t2_.product_id = s4_.id LEFT JOIN shop_product_variant s5_ ON s4_.id = s5_.product_id LEFT JOIN variant_component v6_ ON (v6_.component_id = s5_.id) LEFT JOIN shop_product_variant s0_ ON v6_.variant_id = s0_.id WHERE s0_.id IN (?) [
[
878,
879,
880,
881,
882,
1242
]
]
|
|
DEBUG
01:48:15
|
doctrine |
SELECT t0.id AS id_2, t0.name AS name_3, t0.dtype, t1.multiple AS multiple_4 FROM shop_option t0 LEFT JOIN shop_select_option t1 ON t0.id = t1.id WHERE 1=0 |
|
DEBUG
01:48:15
|
doctrine |
SELECT s0_.id AS id_0, s1_.id AS id_1 FROM shop_product_variant s0_ LEFT JOIN shop_product s1_ ON s0_.product_id = s1_.id WHERE s0_.id IN (?) [
[
878,
879,
880,
881,
882,
1242
]
]
|
|
DEBUG
01:48:15
|
doctrine |
SELECT s0_.id AS id_0, s1_.id AS id_1 FROM shop_option s1_ LEFT JOIN shop_select_option s2_ ON s1_.id = s2_.id LEFT JOIN shop_product s0_ ON (EXISTS (SELECT 1 FROM shop_product_option s3_ WHERE s3_.product_id = s0_.id AND s3_.option_id IN (s1_.id))) WHERE s0_.id IN (?) [
[
878
]
]
|
|
DEBUG
01:48:15
|
doctrine |
SELECT s0_.id AS id_0, s1_.id AS id_1 FROM shop_option s1_ LEFT JOIN shop_select_option s2_ ON s1_.id = s2_.id LEFT JOIN shop_product_variant s0_ ON (EXISTS (SELECT 1 FROM shop_product_variant_option s3_ WHERE s3_.product_variant_id = s0_.id AND s3_.option_id IN (s1_.id))) WHERE s0_.id IN (?) [
[
878,
879,
880,
881,
882,
1242
]
]
|
|
DEBUG
01:48:15
|
doctrine |
SELECT t0.id AS id_2, t0.name AS name_3, t0.dtype, t1.multiple AS multiple_4 FROM shop_option t0 LEFT JOIN shop_select_option t1 ON t0.id = t1.id WHERE 1=0 |
|
DEBUG
01:48:15
|
doctrine |
SELECT s0_.id AS id_0, s1_.rate AS rate_1 FROM shop_product_variant s0_ LEFT JOIN shop_product s2_ ON s0_.product_id = s2_.id LEFT JOIN shop_product_vat_rate s1_ ON (s1_.product_id = s2_.id) WHERE s0_.id IN (?) AND s1_.product_id IS NOT NULL [
[
878,
879,
880,
881,
882,
1242
]
]
|
|
DEBUG
01:48:15
|
doctrine |
SELECT s0_.id AS id_0, s1_.rate AS rate_1 FROM shop_product_variant s0_ LEFT JOIN shop_product s2_ ON s0_.product_id = s2_.id LEFT JOIN shop_product_category s3_ ON s2_.id = s3_.product_id LEFT JOIN shop_category_vat_rate s1_ ON (s1_.category_id = s3_.category_id) WHERE s1_.category_id IS NOT NULL AND s0_.id IN (?) [
[
878,
879,
880,
881,
882,
1242
]
]
|
|
DEBUG
01:48:15
|
doctrine |
SELECT s0_.id AS id_0, a1_.id AS id_1 FROM product_variant_availability_status p2_ LEFT JOIN shop_product_variant s0_ ON p2_.product_variant_id = s0_.id LEFT JOIN availability_status a1_ ON p2_.availability_status_id = a1_.id WHERE s0_.id IN (?) [
[
878,
879,
880,
881,
882,
1242
]
]
|
|
DEBUG
01:48:15
|
doctrine |
SELECT t0.id AS id_1, t0.orderable AS orderable_2, t0.hide_price AS hide_price_3, t0.in_stock AS in_stock_4, t0.show_name AS show_name_5, t0.max_orderable AS max_orderable_6, t0.next_status_id AS next_status_id_7 FROM availability_status t0 WHERE 1=0 |
|
DEBUG
01:48:15
|
doctrine |
SELECT s0_.id AS id_0, p1_.id AS id_1 FROM product_label_product_variant_label p2_ LEFT JOIN shop_product_variant s0_ ON p2_.product_variant_id = s0_.id LEFT JOIN product_label_label p1_ ON p2_.label_id = p1_.id WHERE s0_.id IN (?) [
[
878,
879,
880,
881,
882,
1242
]
]
|
|
DEBUG
01:48:15
|
doctrine |
SELECT t0.id AS id_1, t0.name AS name_2, t0.noreply_email AS noreply_email_3, t0.confirmation_email AS confirmation_email_4, t0.enabled AS enabled_5, t0.company_name AS company_name_6, t0.company_address AS company_address_7, t0.company_registration_details AS company_registration_details_8, t0.default_country AS default_country_9, t0.logo_id AS logo_id_10 FROM multishop_shop t0 |
|
DEBUG
01:48:15
|
doctrine |
SELECT s0_.id AS id_0, p1_.id AS id_1, m2_.id AS id_2 FROM shop_product_label_product_variant_label s3_ LEFT JOIN shop_product_variant s0_ ON s3_.product_variant_id = s0_.id LEFT JOIN product_label_label p1_ ON s3_.label_id = p1_.id LEFT JOIN multishop_shop m2_ ON s3_.shop_id = m2_.id WHERE s0_.id IN (?) [
[
878,
879,
880,
881,
882,
1242
]
]
|
|
INFO
01:48:15
|
php |
User Deprecated: Class "Boldr\Shop\VatBundle\Price\PriceModifierCategoryProvider" should implement method "Boldr\Shop\ShopBundle\Price\PriceModifierCategoryProviderInterface::displayAsSurchargeOnInvoice(string $category, ?Customer $customer): bool". {
"exception": {}
}
|
|
DEBUG
01:48:15
|
doctrine |
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.warranty AS warranty_3, t0.brand_id AS brand_id_4, t0.pdf_id AS pdf_id_5 FROM brand_options_translation t0 WHERE t0.locale = ? [
"nl"
]
|
|
DEBUG
01:48:15
|
doctrine |
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.warranty AS warranty_3, t0.product_id AS product_id_4 FROM shop_product_warranty_translation t0 WHERE t0.product_id = ? AND t0.locale = ? LIMIT 1 [
878,
"nl"
]
|
|
DEBUG
01:48:15
|
doctrine |
SELECT s0_.name AS name_0, s1_.value AS value_1 FROM shop_product_property_value s2_ LEFT JOIN shop_property_value s3_ ON s2_.property_value_id = s3_.id LEFT JOIN shop_property s4_ ON s3_.property_id = s4_.id LEFT JOIN shop_property_translation s0_ ON s4_.id = s0_.property_id LEFT JOIN shop_property_value_translation s1_ ON s3_.id = s1_.property_value_id WHERE s1_.locale = ? AND s0_.locale = ? AND s2_.product_id = ? ORDER BY s4_.sort_order ASC [
"nl",
"nl",
878
]
|
|
DEBUG
01:48:15
|
doctrine |
SELECT t0.id AS id_1, t0.type AS type_2, t0.storage_identifier AS storage_identifier_3, t0.public_name AS public_name_4, t0.derivatives AS derivatives_5, t0.enqueued_derivatives AS enqueued_derivatives_6, t0.derivatives_enqueued AS derivatives_enqueued_7, t0.mime_type AS mime_type_8, t0.size AS size_9, t0.width AS width_10, t0.height AS height_11, t0.time_uploaded AS time_uploaded_12 FROM cms_upload t0 WHERE t0.id = ? [
13768
]
|
|
DEBUG
01:48:15
|
doctrine |
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.display_name AS display_name_3, t0.description AS description_4, t0.upload_id AS upload_id_5 FROM cms_upload_translation t0 WHERE t0.upload_id = ? [
13768
]
|
|
DEBUG
01:48:15
|
doctrine |
SELECT t0.id AS id_1, t0.product_options_id AS product_options_id_2, t0.upload_id AS upload_id_3 FROM tmk_product_options_logo_image t0 WHERE t0.product_options_id = ? [
878
]
|
|
DEBUG
01:48:15
|
doctrine |
SELECT t0.id AS id_1, t0.type AS type_2, t0.storage_identifier AS storage_identifier_3, t0.public_name AS public_name_4, t0.derivatives AS derivatives_5, t0.enqueued_derivatives AS enqueued_derivatives_6, t0.derivatives_enqueued AS derivatives_enqueued_7, t0.mime_type AS mime_type_8, t0.size AS size_9, t0.width AS width_10, t0.height AS height_11, t0.time_uploaded AS time_uploaded_12 FROM cms_upload t0 WHERE t0.id = ? [
14922
]
|
|
DEBUG
01:48:15
|
doctrine |
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.display_name AS display_name_3, t0.description AS description_4, t0.upload_id AS upload_id_5 FROM cms_upload_translation t0 WHERE t0.upload_id = ? [
14922
]
|
|
DEBUG
01:48:15
|
doctrine |
SELECT t0.id AS id_1, t0.name AS name_2, t0.permalink AS permalink_3, t0.sort_order AS sort_order_4, t0.logo_id AS logo_id_5 FROM brand_brand t0 INNER JOIN tmk_shop_options_brands ON t0.id = tmk_shop_options_brands.brand_id WHERE tmk_shop_options_brands.shop_id = ? [
1
]
|
|
DEBUG
01:48:15
|
doctrine |
SELECT t0_.category_id AS category_id_0, t0_.shop_id AS shop_id_1 FROM tmk_category_shop t0_ LEFT JOIN shop_category s1_ ON t0_.category_id = s1_.id WHERE t0_.shop_id = ? [
1
]
|
|
DEBUG
01:48:15
|
doctrine |
SELECT t0.id AS id_1, t0.name AS name_2, t0.permalink AS permalink_3, t0.sort_order AS sort_order_4, t0.logo_id AS logo_id_5 FROM brand_brand t0 ORDER BY t0.sort_order ASC |
|
DEBUG
01:48:15
|
doctrine |
SELECT s0_.id AS id_0, s0_.visible AS visible_1, s0_.sort_order AS sort_order_2, s0_.show_as_filter AS show_as_filter_3, COUNT(s1_.id) AS sclr_4, s0_.parent_id AS parent_id_5 FROM shop_category s0_ LEFT JOIN shop_product_category s2_ ON s0_.id = s2_.category_id LEFT JOIN shop_product s3_ ON s2_.product_id = s3_.id LEFT JOIN shop_product_variant s1_ ON s3_.id = s1_.product_id WHERE s0_.show_as_filter = 1 AND s0_.visible = 1 AND s1_.id IN (?) GROUP BY s0_.id ORDER BY s0_.sort_order ASC [
[
883,
5687,
884,
885,
5688,
2075,
886,
5689,
2871,
5690,
887,
2074,
477,
2039,
864,
1253,
1219,
1254,
1218,
622,
2101,
1220,
2009,
2832,
5536,
2844,
2833,
2010,
1221,
2037,
2038,
2045,
2046,
2153,
2840,
2838,
2839,
865,
1222,
2016,
860,
3984,
3986,
3987
]
]
|
|
DEBUG
01:48:15
|
doctrine |
SELECT s0_.id AS id_0, s0_.visible AS visible_1, s0_.sort_order AS sort_order_2, s0_.show_as_filter AS show_as_filter_3, s1_.id AS id_4, s1_.locale AS locale_5, s1_.name AS name_6, s1_.permalink AS permalink_7, s1_.content_elements AS content_elements_8, s0_.parent_id AS parent_id_9, s1_.category_id AS category_id_10 FROM shop_category s0_ LEFT JOIN shop_category_translation s1_ ON s0_.id = s1_.category_id WHERE s0_.id IN (?) [
[]
]
|
|
DEBUG
01:48:15
|
doctrine |
SELECT s0_.id AS id_0, m1_.id AS id_1, t2_.price AS price_2, t2_.sale_price AS sale_price_3 FROM tmk_shop_product_variant_options t2_ LEFT JOIN shop_product_variant s0_ ON t2_.product_variant_id = s0_.id LEFT JOIN multishop_shop m1_ ON t2_.shop_id = m1_.id WHERE s0_.id IN (?) [
[
883,
5687,
884,
885,
5688,
2075,
886,
5689,
2871,
5690,
887,
2074,
477,
2039,
864,
1253,
1219,
1254,
1218,
622,
2101,
1220,
2009,
2832,
5536,
2844,
2833,
2010,
1221,
2037,
2038,
2045,
2046,
2153,
2840,
2838,
2839,
865,
1222,
2016,
860,
3984,
3986,
3987
]
]
|
|
DEBUG
01:48:15
|
doctrine |
SELECT s0_.id AS id_0, s1_.rate AS rate_1 FROM shop_product_variant s0_ LEFT JOIN shop_product s2_ ON s0_.product_id = s2_.id LEFT JOIN shop_product_vat_rate s1_ ON (s1_.product_id = s2_.id) WHERE s0_.id IN (?) AND s1_.product_id IS NOT NULL [
[
883,
5687,
884,
885,
5688,
2075,
886,
5689,
2871,
5690,
887,
2074,
477,
2039,
864,
1253,
1219,
1254,
1218,
622,
2101,
1220,
2009,
2832,
5536,
2844,
2833,
2010,
1221,
2037,
2038,
2045,
2046,
2153,
2840,
2838,
2839,
865,
1222,
2016,
860,
3984,
3986,
3987
]
]
|
|
DEBUG
01:48:15
|
doctrine |
SELECT s0_.id AS id_0, s1_.rate AS rate_1 FROM shop_product_variant s0_ LEFT JOIN shop_product s2_ ON s0_.product_id = s2_.id LEFT JOIN shop_product_category s3_ ON s2_.id = s3_.product_id LEFT JOIN shop_category_vat_rate s1_ ON (s1_.category_id = s3_.category_id) WHERE s1_.category_id IS NOT NULL AND s0_.id IN (?) [
[
883,
5687,
884,
885,
5688,
2075,
886,
5689,
2871,
5690,
887,
2074,
477,
2039,
864,
1253,
1219,
1254,
1218,
622,
2101,
1220,
2009,
2832,
5536,
2844,
2833,
2010,
1221,
2037,
2038,
2045,
2046,
2153,
2840,
2838,
2839,
865,
1222,
2016,
860,
3984,
3986,
3987
]
]
|
|
DEBUG
01:48:15
|
doctrine |
SELECT t0.id AS id_1, t0.filterable AS filterable_2, t0.sort_order AS sort_order_3, t0.group_id AS group_id_4 FROM shop_property t0 WHERE t0.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY t0.sort_order ASC [
26,
27,
29,
33,
34,
40,
42,
47,
53,
56
]
|
|
DEBUG
01:48:15
|
doctrine |
SELECT t0.id AS id_1, t0.property_id AS property_id_2 FROM shop_property_value t0 WHERE t0.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) [
412,
413,
414,
817,
949,
416,
417,
426,
478,
481,
484,
533,
540,
541,
542,
543,
544,
557,
628,
655,
656,
657
]
|
|
DEBUG
01:48:15
|
doctrine |
SELECT t0.id AS id_1, t0.name AS name_2, t0.permalink AS permalink_3, t0.sort_order AS sort_order_4, t0.logo_id AS logo_id_5 FROM brand_brand t0 ORDER BY t0.sort_order ASC |
|
DEBUG
01:48:15
|
doctrine |
SELECT t0.id AS id_1, t0.filterable AS filterable_2, t0.sort_order AS sort_order_3, t0.group_id AS group_id_4 FROM shop_property t0 WHERE t0.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY t0.sort_order ASC [
26,
27,
29,
33,
34,
40,
42,
47,
53,
56
]
|
|
DEBUG
01:48:15
|
doctrine |
SELECT t0.id AS id_1, t0.property_id AS property_id_2 FROM shop_property_value t0 WHERE t0.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) [
412,
413,
414,
817,
949,
416,
417,
426,
478,
481,
484,
533,
540,
541,
542,
543,
544,
557,
628,
655,
656,
657
]
|
|
DEBUG
01:48:15
|
doctrine |
SELECT s0_.id AS id_0, s1_.id AS id_1 FROM shop_product_variant s0_ LEFT JOIN shop_product s1_ ON s0_.product_id = s1_.id WHERE s0_.id IN (?) [
{
"0": 883,
"1": 5687,
"2": 884,
"3": 885,
"4": 5688,
"5": 2075,
"6": 886,
"7": 5689,
"8": 2871,
"9": 5690,
"10": 887,
"11": 2074,
"12": 477,
"13": 2039,
"14": 864,
"15": 1253,
"16": 1219,
"17": 1254,
"18": 1218,
"19": 622,
"20": 2101,
"21": 1220,
"22": 2009,
"23": 2832,
"24": 5536,
"27": 2010,
"28": 1221,
"29": 2037,
"30": 2038,
"31": 2045,
"32": 2046,
"33": 2153,
"39": 2016,
"40": 860,
"41": 3984,
"42": 3986,
"43": 3987
}
]
|
|
DEBUG
01:48:15
|
doctrine |
SELECT s0_.id AS id_0, s0_.enabled AS enabled_1, s0_.time_added AS time_added_2, s0_.sort_order AS sort_order_3, s1_.id AS id_4, s1_.locale AS locale_5, s1_.name AS name_6, s1_.permalink AS permalink_7, s1_.description AS description_8, s1_.short_description AS short_description_9, s0_.product_id AS product_id_10, s0_.primary_image_id AS primary_image_id_11, s1_.product_variant_id AS product_variant_id_12 FROM shop_product_variant s0_ LEFT JOIN shop_product_variant_translation s1_ ON s0_.id = s1_.product_variant_id LEFT JOIN shop_product s2_ ON s0_.product_id = s2_.id WHERE s0_.id IN (?) AND s0_.enabled = 1 AND s2_.enabled = 1 [
[
883,
5687,
884,
885,
5688,
2075,
886,
5689,
2871,
5690,
887,
2074,
477,
2039,
864,
1253,
1219,
1254
]
]
|
|
DEBUG
01:48:15
|
doctrine |
SELECT t0.id AS id_1, t0.enabled AS enabled_2, t0.deleted AS deleted_3, t0.primary_category_id AS primary_category_id_4, t0.primary_image_id AS primary_image_id_5, t0.primary_product_image_id AS primary_product_image_id_6, t0.default_variant_id AS default_variant_id_7 FROM shop_product t0 WHERE t0.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) [
477,
864,
883,
884,
885,
886,
887,
1219,
1253,
1254,
2039,
2074,
2075,
2871,
5251,
5252,
5253,
5254
]
|
|
DEBUG
01:48:15
|
doctrine |
SELECT s0_.id AS id_0, s0_.enabled AS enabled_1, s0_.deleted AS deleted_2, s1_.sort_order AS sort_order_3, s2_.id AS id_4, s2_.visible AS visible_5, s2_.sort_order AS sort_order_6, s2_.show_as_filter AS show_as_filter_7, s3_.id AS id_8, s3_.locale AS locale_9, s3_.name AS name_10, s3_.permalink AS permalink_11, s3_.content_elements AS content_elements_12, s0_.primary_category_id AS primary_category_id_13, s0_.primary_image_id AS primary_image_id_14, s0_.primary_product_image_id AS primary_product_image_id_15, s0_.default_variant_id AS default_variant_id_16, s1_.product_id AS product_id_17, s1_.category_id AS category_id_18, s2_.parent_id AS parent_id_19, s3_.category_id AS category_id_20 FROM shop_product s0_ LEFT JOIN shop_product_category s1_ ON s0_.id = s1_.product_id LEFT JOIN shop_category s2_ ON s1_.category_id = s2_.id LEFT JOIN shop_category_translation s3_ ON s2_.id = s3_.category_id WHERE s0_.id IN (?) [
[
477,
864,
883,
884,
885,
886,
887,
1219,
1253,
1254,
2039,
2074,
2075,
2871,
5251,
5252,
5253,
5254
]
]
|
|
DEBUG
01:48:15
|
doctrine |
SELECT s0_.id AS id_0, s0_.enabled AS enabled_1, s0_.deleted AS deleted_2, s1_.id AS id_3, s1_.locale AS locale_4, s1_.name AS name_5, s1_.permalink AS permalink_6, s1_.description AS description_7, s1_.short_description AS short_description_8, s0_.primary_category_id AS primary_category_id_9, s0_.primary_image_id AS primary_image_id_10, s0_.primary_product_image_id AS primary_product_image_id_11, s0_.default_variant_id AS default_variant_id_12, s1_.product_id AS product_id_13 FROM shop_product s0_ LEFT JOIN shop_product_translation s1_ ON s0_.id = s1_.product_id WHERE s0_.id IN (?) [
[
477,
864,
883,
884,
885,
886,
887,
1219,
1253,
1254,
2039,
2074,
2075,
2871,
5251,
5252,
5253,
5254
]
]
|
|
DEBUG
01:48:15
|
doctrine |
SELECT s0_.id AS id_0, s0_.enabled AS enabled_1, s0_.deleted AS deleted_2, s1_.id AS id_3, s1_.enabled AS enabled_4, s1_.time_added AS time_added_5, s1_.sort_order AS sort_order_6, s0_.primary_category_id AS primary_category_id_7, s0_.primary_image_id AS primary_image_id_8, s0_.primary_product_image_id AS primary_product_image_id_9, s0_.default_variant_id AS default_variant_id_10, s1_.product_id AS product_id_11, s1_.primary_image_id AS primary_image_id_12 FROM shop_product s0_ LEFT JOIN shop_product_variant s1_ ON s0_.id = s1_.product_id WHERE s0_.id IN (?) ORDER BY s1_.sort_order ASC [
[
477,
864,
883,
884,
885,
886,
887,
1219,
1253,
1254,
2039,
2074,
2075,
2871,
5251,
5252,
5253,
5254
]
]
|
|
DEBUG
01:48:15
|
doctrine |
SELECT t0.show_individual_parts_on_product_page AS show_individual_parts_on_product_page_1, t0.hide_price AS hide_price_2, t0.search_weight AS search_weight_3, t0.product_id AS product_id_4, t0.header_image_id AS header_image_id_5, t0.hover_image_id AS hover_image_id_6, t0.component_option_id AS component_option_id_7 FROM tmk_product_options t0 WHERE t0.product_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) [
477,
864,
883,
884,
885,
886,
887,
1219,
1253,
1254,
2039,
2074,
2075,
2871,
5251,
5252,
5253,
5254
]
|
|
DEBUG
01:48:15
|
doctrine |
SELECT c0_.id AS id_0, c0_.type AS type_1, c0_.storage_identifier AS storage_identifier_2, c0_.public_name AS public_name_3, c0_.derivatives AS derivatives_4, c0_.enqueued_derivatives AS enqueued_derivatives_5, c0_.derivatives_enqueued AS derivatives_enqueued_6, c0_.mime_type AS mime_type_7, c0_.size AS size_8, c0_.width AS width_9, c0_.height AS height_10, c0_.time_uploaded AS time_uploaded_11, c1_.id AS id_12, c1_.locale AS locale_13, c1_.display_name AS display_name_14, c1_.description AS description_15, c1_.upload_id AS upload_id_16 FROM cms_upload c0_ LEFT JOIN cms_upload_translation c1_ ON c0_.id = c1_.upload_id WHERE c0_.id IN (?) [
[
6483,
13626,
13752,
13746,
13748,
13625,
13627,
5913,
13755,
13759,
13764
]
]
|
|
DEBUG
01:48:15
|
doctrine |
SELECT t0.video AS video_1, t0.product_id AS product_id_2, t0.shop_id AS shop_id_3 FROM tmk_shop_product_options t0 WHERE t0.product_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) [
477,
864,
883,
884,
885,
886,
887,
1219,
1253,
1254,
2039,
2074,
2075,
2871,
5251,
5252,
5253,
5254
]
|
|
DEBUG
01:48:15
|
doctrine |
SELECT p0_.locale AS locale_0, p0_.meta_description AS meta_description_1, p0_.product_id AS product_id_2 FROM product_options_translation p0_ LEFT JOIN shop_product s1_ ON p0_.product_id = s1_.id WHERE s1_.id IN (?) AND p0_.locale = ? [
[
477,
864,
883,
884,
885,
886,
887,
1219,
1253,
1254,
2039,
2074,
2075,
2871,
5251,
5252,
5253,
5254
],
"nl"
]
|
|
DEBUG
01:48:15
|
doctrine |
SELECT s0_.id AS id_0, s1_.id AS id_1 FROM shop_product_category s2_ LEFT JOIN shop_product s0_ ON s2_.product_id = s0_.id LEFT JOIN shop_category s1_ ON s2_.category_id = s1_.id WHERE s2_.product_id IN (?) [
[
477,
864,
883,
884,
885,
886,
887,
1219,
1253,
1254,
2039,
2074,
2075,
2871,
5251,
5252,
5253,
5254
]
]
|
|
DEBUG
01:48:15
|
doctrine |
SELECT t0.id AS id_1, t0.display_order AS display_order_2 FROM faq_category t0 WHERE t0.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) [
176,
179,
180,
204,
176,
166,
166,
166,
176,
176,
222,
222,
176,
176,
204,
225,
166,
166,
225
]
|
|
DEBUG
01:48:15
|
doctrine |
SELECT b0_.id AS id_0, s1_.id AS id_1 FROM shop_product_brand s2_ LEFT JOIN shop_product s1_ ON s2_.product_id = s1_.id LEFT JOIN brand_brand b0_ ON s2_.brand_id = b0_.id WHERE s1_.id IN (?) [
[
477,
864,
883,
884,
885,
886,
887,
1219,
1253,
1254,
2039,
2074,
2075,
2871,
5251,
5252,
5253,
5254
]
]
|
|
DEBUG
01:48:15
|
doctrine |
SELECT t0.id AS id_1, t0.name AS name_2, t0.permalink AS permalink_3, t0.sort_order AS sort_order_4, t0.logo_id AS logo_id_5 FROM brand_brand t0 WHERE t0.id IN (?, ?) [
18,
19
]
|
|
DEBUG
01:48:15
|
doctrine |
SELECT s0_.id AS id_0, s1_.rate AS rate_1 FROM shop_product s0_ LEFT JOIN shop_product_vat_rate s1_ ON (s1_.product_id = s0_.id) WHERE s0_.id IN (?) AND s1_.product_id IS NOT NULL [
[
477,
864,
883,
884,
885,
886,
887,
1219,
1253,
1254,
2039,
2074,
2075,
2871,
5251,
5252,
5253,
5254
]
]
|
|
DEBUG
01:48:15
|
doctrine |
SELECT s0_.id AS id_0, s1_.rate AS rate_1 FROM shop_product s0_ LEFT JOIN shop_product_category s2_ ON s0_.id = s2_.product_id LEFT JOIN shop_category_vat_rate s1_ ON (s1_.category_id = s2_.category_id) WHERE s0_.id IN (?) AND s1_.category_id IS NOT NULL [
[
477,
864,
883,
884,
885,
886,
887,
1219,
1253,
1254,
2039,
2074,
2075,
2871,
5251,
5252,
5253,
5254
]
]
|
|
DEBUG
01:48:15
|
doctrine |
SELECT s0_.id AS id_0, p1_.id AS id_1, COUNT(s2_.id) AS sclr_2 FROM product_label_product_label p3_ LEFT JOIN shop_product s0_ ON p3_.product_id = s0_.id LEFT JOIN product_label_label p1_ ON p3_.label_id = p1_.id LEFT JOIN shop_product_variant s2_ ON s0_.id = s2_.product_id WHERE s0_.id IN (?) GROUP BY s0_.id, p1_.id [
[
477,
864,
883,
884,
885,
886,
887,
1219,
1253,
1254,
2039,
2074,
2075,
2871,
5251,
5252,
5253,
5254
]
]
|
|
DEBUG
01:48:15
|
doctrine |
SELECT s0_.id AS id_0, COUNT(s1_.id) AS sclr_1 FROM shop_product s0_ LEFT JOIN shop_product_variant s1_ ON s0_.id = s1_.product_id WHERE s0_.id IN (?) GROUP BY s0_.id [
[
477,
864,
883,
884,
885,
886,
887,
1219,
1253,
1254,
2039,
2074,
2075,
2871,
5251,
5252,
5253,
5254
]
]
|
|
DEBUG
01:48:15
|
doctrine |
SELECT s0_.id AS id_0, p1_.id AS id_1, m2_.id AS id_2 FROM shop_product_label_product_label s3_ LEFT JOIN shop_product s0_ ON s3_.product_id = s0_.id LEFT JOIN product_label_label p1_ ON s3_.label_id = p1_.id LEFT JOIN multishop_shop m2_ ON s3_.shop_id = m2_.id WHERE s0_.id IN (?) [
[
477,
864,
883,
884,
885,
886,
887,
1219,
1253,
1254,
2039,
2074,
2075,
2871,
5251,
5252,
5253,
5254
]
]
|
|
DEBUG
01:48:15
|
doctrine |
SELECT t0.show_tip_best_deal AS show_tip_best_deal_1, t0.article_number AS article_number_2, t0.amount_multiple AS amount_multiple_3, t0.product_variant_id AS product_variant_id_4, t0.hover_image_id AS hover_image_id_5 FROM tmk_product_variant_options t0 WHERE t0.product_variant_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) [
883,
5687,
884,
885,
5688,
2075,
886,
5689,
2871,
5690,
887,
2074,
477,
2039,
864,
1253,
1219,
1254
]
|
|
DEBUG
01:48:15
|
doctrine |
SELECT t0.locale AS locale_1, t0.extra_text AS extra_text_2, t0.meta_description AS meta_description_3, t0.product_variant_id AS product_variant_id_4 FROM product_variant_options_translation t0 WHERE t0.product_variant_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) [
883,
5687,
884,
885,
5688,
2075,
886,
5689,
2871,
5690,
887,
2074,
477,
2039,
864,
1253,
1219,
1254
]
|
|
DEBUG
01:48:15
|
doctrine |
SELECT t0.pay_in_advance AS pay_in_advance_1, t0.price AS price_2, t0.sale_price AS sale_price_3, t0.enabled AS enabled_4, t0.video AS video_5, t0.shop_id AS shop_id_6, t0.product_variant_id AS product_variant_id_7, t0.shipping_costs_category_id AS shipping_costs_category_id_8 FROM tmk_shop_product_variant_options t0 WHERE t0.product_variant_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND t0.shop_id = ? [
883,
5687,
884,
885,
5688,
2075,
886,
5689,
2871,
5690,
887,
2074,
477,
2039,
864,
1253,
1219,
1254,
1
]
|
|
DEBUG
01:48:15
|
doctrine |
SELECT s0_.id AS id_0 FROM shop_product_category s1_ LEFT JOIN shop_product s2_ ON s1_.product_id = s2_.id LEFT JOIN shop_product_variant s0_ ON s2_.id = s0_.product_id WHERE s0_.id IN (?) AND s1_.category_id IN (?) [
[
883,
5687,
884,
885,
5688,
2075,
886,
5689,
2871,
5690,
887,
2074,
477,
2039,
864,
1253,
1219,
1254
],
[
203,
204
]
]
|
|
DEBUG
01:48:15
|
doctrine |
SELECT s0_.id AS id_0, s1_.id AS id_1 FROM tmk_product_options t2_ LEFT JOIN shop_option s1_ ON t2_.component_option_id = s1_.id LEFT JOIN shop_select_option s3_ ON s1_.id = s3_.id LEFT JOIN shop_product s4_ ON t2_.product_id = s4_.id LEFT JOIN shop_product_variant s5_ ON s4_.id = s5_.product_id LEFT JOIN variant_component v6_ ON (v6_.component_id = s5_.id) LEFT JOIN shop_product_variant s0_ ON v6_.variant_id = s0_.id WHERE s0_.id IN (?) [
[
883,
5687,
884,
885,
5688,
2075,
886,
5689,
2871,
5690,
887,
2074,
477,
2039,
864,
1253,
1219,
1254
]
]
|
|
DEBUG
01:48:15
|
doctrine |
SELECT t0.id AS id_2, t0.name AS name_3, t0.dtype, t1.multiple AS multiple_4 FROM shop_option t0 LEFT JOIN shop_select_option t1 ON t0.id = t1.id WHERE 1=0 |
|
DEBUG
01:48:15
|
doctrine |
SELECT s0_.id AS id_0, s1_.id AS id_1 FROM shop_product_variant s0_ LEFT JOIN shop_product s1_ ON s0_.product_id = s1_.id WHERE s0_.id IN (?) [
[
883,
5687,
884,
885,
5688,
2075,
886,
5689,
2871,
5690,
887,
2074,
477,
2039,
864,
1253,
1219,
1254
]
]
|
|
DEBUG
01:48:15
|
doctrine |
SELECT s0_.id AS id_0, s1_.id AS id_1 FROM shop_option s1_ LEFT JOIN shop_select_option s2_ ON s1_.id = s2_.id LEFT JOIN shop_product s0_ ON (EXISTS (SELECT 1 FROM shop_product_option s3_ WHERE s3_.product_id = s0_.id AND s3_.option_id IN (s1_.id))) WHERE s0_.id IN (?) [
[
477,
864,
883,
884,
885,
886,
887,
1219,
1253,
1254,
2039,
2074,
2075,
2871,
5251,
5252,
5253,
5254
]
]
|
|
DEBUG
01:48:15
|
doctrine |
SELECT s0_.id AS id_0, s1_.id AS id_1 FROM shop_option s1_ LEFT JOIN shop_select_option s2_ ON s1_.id = s2_.id LEFT JOIN shop_product_variant s0_ ON (EXISTS (SELECT 1 FROM shop_product_variant_option s3_ WHERE s3_.product_variant_id = s0_.id AND s3_.option_id IN (s1_.id))) WHERE s0_.id IN (?) [
[
883,
5687,
884,
885,
5688,
2075,
886,
5689,
2871,
5690,
887,
2074,
477,
2039,
864,
1253,
1219,
1254
]
]
|
|
DEBUG
01:48:15
|
doctrine |
SELECT t0.id AS id_2, t0.name AS name_3, t0.dtype, t1.multiple AS multiple_4 FROM shop_option t0 LEFT JOIN shop_select_option t1 ON t0.id = t1.id WHERE 1=0 |
|
DEBUG
01:48:15
|
doctrine |
SELECT s0_.id AS id_0, a1_.id AS id_1 FROM product_variant_availability_status p2_ LEFT JOIN shop_product_variant s0_ ON p2_.product_variant_id = s0_.id LEFT JOIN availability_status a1_ ON p2_.availability_status_id = a1_.id WHERE s0_.id IN (?) [
[
883,
5687,
884,
885,
5688,
2075,
886,
5689,
2871,
5690,
887,
2074,
477,
2039,
864,
1253,
1219,
1254
]
]
|
|
DEBUG
01:48:15
|
doctrine |
SELECT t0.id AS id_1, t0.orderable AS orderable_2, t0.hide_price AS hide_price_3, t0.in_stock AS in_stock_4, t0.show_name AS show_name_5, t0.max_orderable AS max_orderable_6, t0.next_status_id AS next_status_id_7 FROM availability_status t0 WHERE 1=0 |
|
DEBUG
01:48:15
|
doctrine |
SELECT s0_.id AS id_0, p1_.id AS id_1 FROM product_label_product_variant_label p2_ LEFT JOIN shop_product_variant s0_ ON p2_.product_variant_id = s0_.id LEFT JOIN product_label_label p1_ ON p2_.label_id = p1_.id WHERE s0_.id IN (?) [
[
883,
5687,
884,
885,
5688,
2075,
886,
5689,
2871,
5690,
887,
2074,
477,
2039,
864,
1253,
1219,
1254
]
]
|
|
DEBUG
01:48:15
|
doctrine |
SELECT t0.id AS id_1, t0.name AS name_2, t0.noreply_email AS noreply_email_3, t0.confirmation_email AS confirmation_email_4, t0.enabled AS enabled_5, t0.company_name AS company_name_6, t0.company_address AS company_address_7, t0.company_registration_details AS company_registration_details_8, t0.default_country AS default_country_9, t0.logo_id AS logo_id_10 FROM multishop_shop t0 |
|
DEBUG
01:48:15
|
doctrine |
SELECT s0_.id AS id_0, p1_.id AS id_1, m2_.id AS id_2 FROM shop_product_label_product_variant_label s3_ LEFT JOIN shop_product_variant s0_ ON s3_.product_variant_id = s0_.id LEFT JOIN product_label_label p1_ ON s3_.label_id = p1_.id LEFT JOIN multishop_shop m2_ ON s3_.shop_id = m2_.id WHERE s0_.id IN (?) [
[
883,
5687,
884,
885,
5688,
2075,
886,
5689,
2871,
5690,
887,
2074,
477,
2039,
864,
1253,
1219,
1254
]
]
|
|
DEBUG
01:48:15
|
doctrine |
SELECT s0_.id AS id_0, s1_.value AS value_1 FROM shop_property_value_translation s1_ LEFT JOIN shop_property_value s0_ ON s1_.property_value_id = s0_.id WHERE s0_.id IN (?) AND s1_.locale = ? [
[
655,
656,
657
],
"nl"
]
|
|
DEBUG
01:48:15
|
doctrine |
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.name AS name_3, t0.property_id AS property_id_4 FROM shop_property_translation t0 WHERE t0.property_id = ? [
56
]
|
|
DEBUG
01:48:15
|
doctrine |
SELECT s0_.id AS id_0, s1_.value AS value_1 FROM shop_property_value_translation s1_ LEFT JOIN shop_property_value s0_ ON s1_.property_value_id = s0_.id WHERE s0_.id IN (?) AND s1_.locale = ? [
[
426
],
"nl"
]
|
|
DEBUG
01:48:15
|
doctrine |
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.name AS name_3, t0.property_id AS property_id_4 FROM shop_property_translation t0 WHERE t0.property_id = ? [
29
]
|
|
DEBUG
01:48:15
|
doctrine |
SELECT s0_.id AS id_0, s1_.value AS value_1 FROM shop_property_value_translation s1_ LEFT JOIN shop_property_value s0_ ON s1_.property_value_id = s0_.id WHERE s0_.id IN (?) AND s1_.locale = ? [
[
533
],
"nl"
]
|
|
DEBUG
01:48:15
|
doctrine |
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.name AS name_3, t0.property_id AS property_id_4 FROM shop_property_translation t0 WHERE t0.property_id = ? [
40
]
|
|
DEBUG
01:48:15
|
doctrine |
SELECT s0_.id AS id_0, s1_.value AS value_1 FROM shop_property_value_translation s1_ LEFT JOIN shop_property_value s0_ ON s1_.property_value_id = s0_.id WHERE s0_.id IN (?) AND s1_.locale = ? [
[
478
],
"nl"
]
|
|
DEBUG
01:48:15
|
doctrine |
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.name AS name_3, t0.property_id AS property_id_4 FROM shop_property_translation t0 WHERE t0.property_id = ? [
33
]
|
|
DEBUG
01:48:15
|
doctrine |
SELECT s0_.id AS id_0, s1_.value AS value_1 FROM shop_property_value_translation s1_ LEFT JOIN shop_property_value s0_ ON s1_.property_value_id = s0_.id WHERE s0_.id IN (?) AND s1_.locale = ? [
[
412,
413,
414,
817,
949
],
"nl"
]
|
|
DEBUG
01:48:15
|
doctrine |
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.name AS name_3, t0.property_id AS property_id_4 FROM shop_property_translation t0 WHERE t0.property_id = ? [
26
]
|
|
DEBUG
01:48:15
|
doctrine |
SELECT s0_.id AS id_0, s1_.value AS value_1 FROM shop_property_value_translation s1_ LEFT JOIN shop_property_value s0_ ON s1_.property_value_id = s0_.id WHERE s0_.id IN (?) AND s1_.locale = ? [
[
540,
541,
542,
543,
544
],
"nl"
]
|
|
DEBUG
01:48:15
|
doctrine |
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.name AS name_3, t0.property_id AS property_id_4 FROM shop_property_translation t0 WHERE t0.property_id = ? [
42
]
|
|
DEBUG
01:48:15
|
doctrine |
SELECT s0_.id AS id_0, s1_.value AS value_1 FROM shop_property_value_translation s1_ LEFT JOIN shop_property_value s0_ ON s1_.property_value_id = s0_.id WHERE s0_.id IN (?) AND s1_.locale = ? [
[
416,
417
],
"nl"
]
|
|
DEBUG
01:48:15
|
doctrine |
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.name AS name_3, t0.property_id AS property_id_4 FROM shop_property_translation t0 WHERE t0.property_id = ? [
27
]
|
|
DEBUG
01:48:15
|
doctrine |
SELECT s0_.id AS id_0, s1_.value AS value_1 FROM shop_property_value_translation s1_ LEFT JOIN shop_property_value s0_ ON s1_.property_value_id = s0_.id WHERE s0_.id IN (?) AND s1_.locale = ? [
[
481,
484
],
"nl"
]
|
|
DEBUG
01:48:15
|
doctrine |
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.name AS name_3, t0.property_id AS property_id_4 FROM shop_property_translation t0 WHERE t0.property_id = ? [
34
]
|
|
DEBUG
01:48:15
|
doctrine |
SELECT s0_.id AS id_0, s1_.value AS value_1 FROM shop_property_value_translation s1_ LEFT JOIN shop_property_value s0_ ON s1_.property_value_id = s0_.id WHERE s0_.id IN (?) AND s1_.locale = ? [
[
557
],
"nl"
]
|
|
DEBUG
01:48:15
|
doctrine |
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.name AS name_3, t0.property_id AS property_id_4 FROM shop_property_translation t0 WHERE t0.property_id = ? [
47
]
|
|
DEBUG
01:48:15
|
doctrine |
SELECT s0_.id AS id_0, s1_.value AS value_1 FROM shop_property_value_translation s1_ LEFT JOIN shop_property_value s0_ ON s1_.property_value_id = s0_.id WHERE s0_.id IN (?) AND s1_.locale = ? [
[
628
],
"nl"
]
|
|
DEBUG
01:48:15
|
doctrine |
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.name AS name_3, t0.property_id AS property_id_4 FROM shop_property_translation t0 WHERE t0.property_id = ? [
53
]
|
|
DEBUG
01:48:15
|
doctrine |
SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.enabled AS enabled_2, c0_.priority AS priority_3, c1_.id AS id_4, c1_.locale AS locale_5, c1_.title AS title_6, c1_.content_elements AS content_elements_7, c1_.link AS link_8, c1_.popup_id AS popup_id_9, c1_.image_id AS image_id_10 FROM cms_popup c0_ LEFT JOIN cms_popup_translation c1_ ON c0_.id = c1_.popup_id WHERE c0_.enabled = 1 AND c1_.locale = ? ORDER BY c0_.priority ASC [
"nl"
]
|
|
DEBUG
01:48:15
|
doctrine |
SELECT t0.id AS id_1, t0.domain AS domain_2, t0.shop_id AS shop_id_3 FROM multishop_shop_domain t0 WHERE t0.shop_id = ? LIMIT 1 [
1
]
|
|
INFO
01:48:15
|
php |
Deprecated: Creation of dynamic property Boldr\Shop\MultishopBundle\Presenter\ShopView::$domain is deprecated {
"exception": {}
}
|
|
DEBUG
01:48:15
|
doctrine |
SELECT d0_.id AS id_0, d0_.active AS active_1, d0_.alignment_x AS alignment_x_2, d0_.alignment_y AS alignment_y_3, d0_.discount_id AS discount_id_4, d0_.image_id AS image_id_5 FROM discount_popup d0_ LEFT JOIN discount_popup_translation d1_ ON d0_.id = d1_.discount_popup_id LEFT JOIN shop_discount s2_ ON d0_.discount_id = s2_.id WHERE d0_.active = 1 AND (s2_.date_end IS NULL OR s2_.date_end >= ?) AND (s2_.date_start IS NULL OR s2_.date_start <= ?) AND d1_.locale = ? LIMIT 1 [
"2026-08-20",
"2026-08-20",
"nl"
]
|
|
DEBUG
01:48:15
|
doctrine |
SELECT t0.id AS id_1, t0.type AS type_2, t0.storage_identifier AS storage_identifier_3, t0.public_name AS public_name_4, t0.derivatives AS derivatives_5, t0.enqueued_derivatives AS enqueued_derivatives_6, t0.derivatives_enqueued AS derivatives_enqueued_7, t0.mime_type AS mime_type_8, t0.size AS size_9, t0.width AS width_10, t0.height AS height_11, t0.time_uploaded AS time_uploaded_12 FROM cms_upload t0 WHERE t0.id = ? [
15462
]
|
|
DEBUG
01:48:15
|
doctrine |
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.display_name AS display_name_3, t0.description AS description_4, t0.upload_id AS upload_id_5 FROM cms_upload_translation t0 WHERE t0.upload_id = ? [
15462
]
|
|
DEBUG
01:48:15
|
doctrine |
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.title AS title_3, t0.text AS text_4, t0.bar_text AS bar_text_5, t0.discount_popup_id AS discount_popup_id_6 FROM discount_popup_translation t0 WHERE t0.discount_popup_id = ? [
1
]
|
|
DEBUG
01:48:15
|
doctrine |
SELECT t0.locale AS locale_1, t0.name AS name_2, t0.button_text AS button_text_3, t0.button_text_short AS button_text_short_4, t0.explanation_text AS explanation_text_5, t0.unavailable_message AS unavailable_message_6, t0.invoice_discount_label AS invoice_discount_label_7, t0.your_inquiry AS your_inquiry_8, t0.your_price AS your_price_9, t0.missing_favorite_configuration AS missing_favorite_configuration_10, t0.request_offer AS request_offer_11 FROM best_deal_translation t0 WHERE t0.locale = ? [
"nl"
]
|
|
DEBUG
01:48:15
|
doctrine |
SELECT t0.id AS id_1, t0.name AS name_2, t0.permalink AS permalink_3, t0.sort_order AS sort_order_4, t0.logo_id AS logo_id_5 FROM brand_brand t0 ORDER BY t0.sort_order ASC |
|
DEBUG
01:48:15
|
doctrine |
SELECT t0.id AS id_1, t0.name AS name_2, t0.by_appointment AS by_appointment_3 FROM opening_hours_set t0 WHERE t0.id = ? [
1
]
|
|
DEBUG
01:48:15
|
doctrine |
SELECT t0.id AS id_1, t0.date AS date_2, t0.day_of_the_week AS day_of_the_week_3, t0.time_start AS time_start_4, t0.time_end AS time_end_5, t0.preparation_time AS preparation_time_6, t0.set_id AS set_id_7 FROM opening_hours_opening_hours t0 WHERE t0.set_id = ? [
1
]
|
|
DEBUG
01:48:15
|
doctrine |
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.caption AS caption_3, t0.set_id AS set_id_4 FROM opening_hours_set_translation t0 WHERE t0.set_id = ? [
1
]
|
|
DEBUG
01:48:15
|
doctrine |
SELECT t0.id AS id_1, t0.domain AS domain_2, t0.shop_id AS shop_id_3 FROM multishop_shop_domain t0 WHERE t0.shop_id = ? LIMIT 1 [
1
]
|
|
INFO
01:48:15
|
php |
Deprecated: Creation of dynamic property Boldr\Shop\MultishopBundle\Presenter\ShopView::$domain is deprecated {
"exception": {}
}
|
|
DEBUG
01:48:15
|
doctrine |
SELECT t0.id AS id_1, t0.layout AS layout_2, t0.serialized_layout AS serialized_layout_3, t0.time_last_updated AS time_last_updated_4, t0.synchronize_translations AS synchronize_translations_5, t0.type AS type_6, t0.parent_id AS parent_id_7, t0.primary_image_id AS primary_image_id_8 FROM cms_page t0 WHERE t0.id = ? [
9
]
|
|
DEBUG
01:48:15
|
doctrine |
SHOW FULL TABLES WHERE Table_type = 'BASE TABLE' |
|
DEBUG
01:48:15
|
doctrine |
SHOW FULL TABLES WHERE Table_type = 'BASE TABLE' |
|
DEBUG
01:48:15
|
doctrine |
SELECT COLUMN_NAME AS Field, COLUMN_TYPE AS Type, IS_NULLABLE AS `Null`, COLUMN_KEY AS `Key`, COLUMN_DEFAULT AS `Default`, EXTRA AS Extra, COLUMN_COMMENT AS Comment, CHARACTER_SET_NAME AS CharacterSet, COLLATION_NAME AS Collation FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = 'z2d_tmk' AND TABLE_NAME = 'doctrine_migration_versions' ORDER BY ORDINAL_POSITION ASC |
|
DEBUG
01:48:15
|
doctrine |
SELECT DISTINCT k.`CONSTRAINT_NAME`, k.`COLUMN_NAME`, k.`REFERENCED_TABLE_NAME`, k.`REFERENCED_COLUMN_NAME` /*!50116 , c.update_rule, c.delete_rule */ FROM information_schema.key_column_usage k /*!50116 INNER JOIN information_schema.referential_constraints c ON c.constraint_name = k.constraint_name AND c.table_name = 'doctrine_migration_versions' */ WHERE k.table_name = 'doctrine_migration_versions' AND k.table_schema = 'z2d_tmk' /*!50116 AND c.constraint_schema = 'z2d_tmk' */ AND k.`REFERENCED_COLUMN_NAME` is not NULL |
|
DEBUG
01:48:15
|
doctrine |
SELECT NON_UNIQUE AS Non_Unique, INDEX_NAME AS Key_name, COLUMN_NAME AS Column_Name, SUB_PART AS Sub_Part, INDEX_TYPE AS Index_Type FROM information_schema.STATISTICS WHERE TABLE_NAME = 'doctrine_migration_versions' AND TABLE_SCHEMA = 'z2d_tmk' ORDER BY SEQ_IN_INDEX ASC |
|
DEBUG
01:48:15
|
doctrine |
SELECT ENGINE, AUTO_INCREMENT, TABLE_COLLATION, TABLE_COMMENT, CREATE_OPTIONS
FROM information_schema.TABLES
WHERE TABLE_TYPE = 'BASE TABLE' AND TABLE_SCHEMA = DATABASE() AND TABLE_NAME = 'doctrine_migration_versions' |
|
DEBUG
01:48:15
|
doctrine |
SELECT * FROM doctrine_migration_versions |
|
DEBUG
01:48:15
|
event |
Notified event "kernel.response" to listener "Symfony\Component\Security\Http\Firewall\ContextListener::onKernelResponse". {
"event": "kernel.response",
"listener": "Symfony\\Component\\Security\\Http\\Firewall\\ContextListener::onKernelResponse"
}
|
|
DEBUG
01:48:15
|
event |
Notified event "kernel.response" to listener "Symfony\Component\Security\Http\Firewall\ContextListener::onKernelResponse". {
"event": "kernel.response",
"listener": "Symfony\\Component\\Security\\Http\\Firewall\\ContextListener::onKernelResponse"
}
|
|
DEBUG
01:48:15
|
event |
Notified event "kernel.response" to listener "Symfony\Component\HttpKernel\EventListener\ResponseListener::onKernelResponse". {
"event": "kernel.response",
"listener": "Symfony\\Component\\HttpKernel\\EventListener\\ResponseListener::onKernelResponse"
}
|
|
DEBUG
01:48:15
|
event |
Notified event "kernel.response" to listener "Symfony\Component\WebLink\EventListener\AddLinkHeaderListener::onKernelResponse". {
"event": "kernel.response",
"listener": "Symfony\\Component\\WebLink\\EventListener\\AddLinkHeaderListener::onKernelResponse"
}
|
|
DEBUG
01:48:15
|
event |
Notified event "kernel.response" to listener "Symfony\Component\HttpKernel\DataCollector\RequestDataCollector::onKernelResponse". {
"event": "kernel.response",
"listener": "Symfony\\Component\\HttpKernel\\DataCollector\\RequestDataCollector::onKernelResponse"
}
|
|
DEBUG
01:48:15
|
event |
Notified event "kernel.response" to listener "Sensio\Bundle\FrameworkExtraBundle\EventListener\HttpCacheListener::onKernelResponse". {
"event": "kernel.response",
"listener": "Sensio\\Bundle\\FrameworkExtraBundle\\EventListener\\HttpCacheListener::onKernelResponse"
}
|
|
DEBUG
01:48:15
|
event |
Notified event "kernel.response" to listener "Symfony\Component\Security\Http\RememberMe\ResponseListener::onKernelResponse". {
"event": "kernel.response",
"listener": "Symfony\\Component\\Security\\Http\\RememberMe\\ResponseListener::onKernelResponse"
}
|
|
DEBUG
01:48:15
|
event |
Notified event "kernel.response" to listener "Boldr\Cms\CmsBundle\EventSubscriber\CookieSubscriber::onKernelResponse". {
"event": "kernel.response",
"listener": "Boldr\\Cms\\CmsBundle\\EventSubscriber\\CookieSubscriber::onKernelResponse"
}
|
|
DEBUG
01:48:15
|
event |
Notified event "kernel.response" to listener "Boldr\Cms\CmsBundle\EventSubscriber\LocaleSubscriber::onKernelResponse". {
"event": "kernel.response",
"listener": "Boldr\\Cms\\CmsBundle\\EventSubscriber\\LocaleSubscriber::onKernelResponse"
}
|
|
DEBUG
01:48:15
|
event |
Notified event "kernel.response" to listener "Symfony\Component\HttpKernel\EventListener\ProfilerListener::onKernelResponse". {
"event": "kernel.response",
"listener": "Symfony\\Component\\HttpKernel\\EventListener\\ProfilerListener::onKernelResponse"
}
|
|
DEBUG
01:48:15
|
event |
Notified event "kernel.response" to listener "Symfony\Component\HttpKernel\EventListener\ErrorListener::removeCspHeader". {
"event": "kernel.response",
"listener": "Symfony\\Component\\HttpKernel\\EventListener\\ErrorListener::removeCspHeader"
}
|
|
DEBUG
01:48:15
|
event |
Notified event "kernel.response" to listener "Symfony\Bundle\WebProfilerBundle\EventListener\WebDebugToolbarListener::onKernelResponse". {
"event": "kernel.response",
"listener": "Symfony\\Bundle\\WebProfilerBundle\\EventListener\\WebDebugToolbarListener::onKernelResponse"
}
|
|
DEBUG
01:48:15
|
event |
Notified event "kernel.response" to listener "Symfony\Component\HttpKernel\EventListener\DisallowRobotsIndexingListener::onResponse". {
"event": "kernel.response",
"listener": "Symfony\\Component\\HttpKernel\\EventListener\\DisallowRobotsIndexingListener::onResponse"
}
|
|
DEBUG
01:48:15
|
event |
Notified event "kernel.response" to listener "Symfony\Component\HttpKernel\EventListener\SessionListener::onKernelResponse". {
"event": "kernel.response",
"listener": "Symfony\\Component\\HttpKernel\\EventListener\\SessionListener::onKernelResponse"
}
|
|
CRITICAL
01:48:15
|
request |
Uncaught PHP Exception ErrorException: "Warning: Cannot modify header information - headers already sent by (output started at /home/z2d/sites/tmk/app/local_bundles/shop-bundle/src/ProductList/QueryExecutor.php:64)" at /home/z2d/sites/tmk/app/vendor/symfony/http-foundation/Session/SessionUtils.php line 52 {
"exception": {},
"url": "https://tmk-4so.z2d.nl/nl/zelf-samenstellen/878?page=1"
}
|
|
DEBUG
01:48:15
|
doctrine |
SELECT r0_.id AS id_0, r0_.prefix AS prefix_1, r0_.source AS source_2, r0_.target AS target_3 FROM redirect r0_ WHERE r0_.source = ? OR (r0_.prefix = 1 AND ? LIKE CONCAT(r0_.source, '%')) LIMIT 1 [
"/nl/zelf-samenstellen/878",
"/nl/zelf-samenstellen/878"
]
|
|
INFO
01:48:15
|
php |
Deprecated: explode(): Passing null to parameter #2 ($string) of type string is deprecated {
"exception": {}
}
|
|
DEBUG
01:48:15
|
event |
Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\DebugHandlersListener::configure". {
"event": "kernel.request",
"listener": "Symfony\\Component\\HttpKernel\\EventListener\\DebugHandlersListener::configure"
}
|
|
DEBUG
01:48:15
|
event |
Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\ValidateRequestListener::onKernelRequest". {
"event": "kernel.request",
"listener": "Symfony\\Component\\HttpKernel\\EventListener\\ValidateRequestListener::onKernelRequest"
}
|
|
DEBUG
01:48:15
|
event |
Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\SessionListener::onKernelRequest". {
"event": "kernel.request",
"listener": "Symfony\\Component\\HttpKernel\\EventListener\\SessionListener::onKernelRequest"
}
|
|
DEBUG
01:48:15
|
event |
Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\LocaleListener::setDefaultLocale". {
"event": "kernel.request",
"listener": "Symfony\\Component\\HttpKernel\\EventListener\\LocaleListener::setDefaultLocale"
}
|
|
DEBUG
01:48:15
|
event |
Notified event "kernel.request" to listener "Boldr\Cms\RedirectBundle\EventSubscriber\KernelEventSubscriber::onKernelRequest". {
"event": "kernel.request",
"listener": "Boldr\\Cms\\RedirectBundle\\EventSubscriber\\KernelEventSubscriber::onKernelRequest"
}
|
|
DEBUG
01:48:15
|
event |
Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\RouterListener::onKernelRequest". {
"event": "kernel.request",
"listener": "Symfony\\Component\\HttpKernel\\EventListener\\RouterListener::onKernelRequest"
}
|
|
DEBUG
01:48:15
|
event |
Notified event "kernel.request" to listener "Boldr\Cms\CmsBundle\EventSubscriber\LocaleSubscriber::onKernelRequest". {
"event": "kernel.request",
"listener": "Boldr\\Cms\\CmsBundle\\EventSubscriber\\LocaleSubscriber::onKernelRequest"
}
|
|
DEBUG
01:48:15
|
event |
Notified event "kernel.request" to listener "Boldr\Cms\CmsBundle\EventSubscriber\CookieSubscriber::onKernelRequest". {
"event": "kernel.request",
"listener": "Boldr\\Cms\\CmsBundle\\EventSubscriber\\CookieSubscriber::onKernelRequest"
}
|
|
DEBUG
01:48:15
|
event |
Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\LocaleListener::onKernelRequest". {
"event": "kernel.request",
"listener": "Symfony\\Component\\HttpKernel\\EventListener\\LocaleListener::onKernelRequest"
}
|
|
DEBUG
01:48:15
|
event |
Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\LocaleAwareListener::onKernelRequest". {
"event": "kernel.request",
"listener": "Symfony\\Component\\HttpKernel\\EventListener\\LocaleAwareListener::onKernelRequest"
}
|
|
DEBUG
01:48:15
|
event |
Notified event "kernel.request" to listener "EasyCorp\Bundle\EasyAdminBundle\EventListener\AdminRouterSubscriber::handleLegacyEaContext". {
"event": "kernel.request",
"listener": "EasyCorp\\Bundle\\EasyAdminBundle\\EventListener\\AdminRouterSubscriber::handleLegacyEaContext"
}
|
|
DEBUG
01:48:15
|
event |
Notified event "kernel.request" to listener "Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener::configureLogoutUrlGenerator". {
"event": "kernel.request",
"listener": "Symfony\\Bundle\\SecurityBundle\\Debug\\TraceableFirewallListener::configureLogoutUrlGenerator"
}
|
|
DEBUG
01:48:15
|
event |
Notified event "kernel.request" to listener "Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener::onKernelRequest". {
"event": "kernel.request",
"listener": "Symfony\\Bundle\\SecurityBundle\\Debug\\TraceableFirewallListener::onKernelRequest"
}
|
|
DEBUG
01:48:15
|
event |
Notified event "kernel.request" to listener "App\EventSubscriber\CustomerLocaleSubscriber::onKernelRequest". {
"event": "kernel.request",
"listener": "App\\EventSubscriber\\CustomerLocaleSubscriber::onKernelRequest"
}
|
|
DEBUG
01:48:15
|
event |
Notified event "kernel.request" to listener "EasyCorp\Bundle\EasyAdminBundle\EventListener\AdminRouterSubscriber::onKernelRequest". {
"event": "kernel.request",
"listener": "EasyCorp\\Bundle\\EasyAdminBundle\\EventListener\\AdminRouterSubscriber::onKernelRequest"
}
|
|
DEBUG
01:48:15
|
event |
Notified event "kernel.request" to listener "Boldr\Shop\ShopUtmBundle\EventSubscriber::onKernelRequest". {
"event": "kernel.request",
"listener": "Boldr\\Shop\\ShopUtmBundle\\EventSubscriber::onKernelRequest"
}
|
|
DEBUG
01:48:15
|
event |
Notified event "kernel.controller" to listener "EasyCorp\Bundle\EasyAdminBundle\EventListener\AdminRouterSubscriber::onKernelController". {
"event": "kernel.controller",
"listener": "EasyCorp\\Bundle\\EasyAdminBundle\\EventListener\\AdminRouterSubscriber::onKernelController"
}
|
|
DEBUG
01:48:15
|
event |
Notified event "kernel.controller" to listener "Symfony\Bundle\FrameworkBundle\DataCollector\RouterDataCollector::onKernelController". {
"event": "kernel.controller",
"listener": "Symfony\\Bundle\\FrameworkBundle\\DataCollector\\RouterDataCollector::onKernelController"
}
|
|
DEBUG
01:48:15
|
event |
Notified event "kernel.controller" to listener "Symfony\Component\HttpKernel\DataCollector\RequestDataCollector::onKernelController". {
"event": "kernel.controller",
"listener": "Symfony\\Component\\HttpKernel\\DataCollector\\RequestDataCollector::onKernelController"
}
|
|
DEBUG
01:48:15
|
event |
Notified event "kernel.controller" to listener "Sensio\Bundle\FrameworkExtraBundle\EventListener\ControllerListener::onKernelController". {
"event": "kernel.controller",
"listener": "Sensio\\Bundle\\FrameworkExtraBundle\\EventListener\\ControllerListener::onKernelController"
}
|
|
DEBUG
01:48:15
|
event |
Notified event "kernel.controller" to listener "Sensio\Bundle\FrameworkExtraBundle\EventListener\ParamConverterListener::onKernelController". {
"event": "kernel.controller",
"listener": "Sensio\\Bundle\\FrameworkExtraBundle\\EventListener\\ParamConverterListener::onKernelController"
}
|
|
DEBUG
01:48:15
|
event |
Notified event "kernel.controller" to listener "Sensio\Bundle\FrameworkExtraBundle\EventListener\HttpCacheListener::onKernelController". {
"event": "kernel.controller",
"listener": "Sensio\\Bundle\\FrameworkExtraBundle\\EventListener\\HttpCacheListener::onKernelController"
}
|
|
DEBUG
01:48:15
|
event |
Notified event "kernel.controller" to listener "Sensio\Bundle\FrameworkExtraBundle\EventListener\TemplateListener::onKernelController". {
"event": "kernel.controller",
"listener": "Sensio\\Bundle\\FrameworkExtraBundle\\EventListener\\TemplateListener::onKernelController"
}
|
|
DEBUG
01:48:15
|
event |
Notified event "kernel.controller_arguments" to listener "Symfony\Component\HttpKernel\EventListener\ErrorListener::onControllerArguments". {
"event": "kernel.controller_arguments",
"listener": "Symfony\\Component\\HttpKernel\\EventListener\\ErrorListener::onControllerArguments"
}
|
|
DEBUG
01:48:15
|
event |
Notified event "kernel.controller_arguments" to listener "Sensio\Bundle\FrameworkExtraBundle\EventListener\SecurityListener::onKernelControllerArguments". {
"event": "kernel.controller_arguments",
"listener": "Sensio\\Bundle\\FrameworkExtraBundle\\EventListener\\SecurityListener::onKernelControllerArguments"
}
|
|
DEBUG
01:48:15
|
event |
Notified event "kernel.controller_arguments" to listener "Sensio\Bundle\FrameworkExtraBundle\EventListener\IsGrantedListener::onKernelControllerArguments". {
"event": "kernel.controller_arguments",
"listener": "Sensio\\Bundle\\FrameworkExtraBundle\\EventListener\\IsGrantedListener::onKernelControllerArguments"
}
|