Log Messages
Info. & Errors 2
Informational and error log messages generated during the execution of the application.
Level | Channel | Message |
---|---|---|
INFO | request |
Matched route "category" .
[ "route" => "category" "route_parameters" => [ "_route" => "category" "av24h" => null "_controller" => "App\Controller\CategoryController::indexAction" "slug" => "narozniki-ogrodowe" "id" => "324" ] "request_uri" => "https://ckdev.centrumkrzesel.pl/narozniki-ogrodowe/324/c" "method" => "GET" ] |
INFO | security | Populated the TokenStorage with an anonymous Token. |
Deprecations 133
Log messages generated by using features marked as deprecated.
Debug 215
Unimportant log messages generated during the execution of the application.
Time | Channel | Message |
---|---|---|
event |
Notified event "debug.security.authorization.vote" to listener "Symfony\Bundle\SecurityBundle\EventListener\VoteListener::onVoterVote" .
[ "event" => "debug.security.authorization.vote" "listener" => "Symfony\Bundle\SecurityBundle\EventListener\VoteListener::onVoterVote" ] |
|
doctrine |
SELECT t0.id AS id_1, t0.sign AS sign_2, t0.currency_separator AS currency_separator_3, t0.position_price AS position_price_4, t0.is_default AS is_default_5, t0.is_active AS is_active_6, t0.factorPln AS factorPln_7, t0.iso_code AS iso_code_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.created_by AS created_by_11, t0.updated_by AS updated_by_12, t0.deleted_by AS deleted_by_13 FROM currency t0 WHERE t0.is_default = ? AND t0.deleted_by IS NULL LIMIT 1
[
true
]
|
|
doctrine |
SELECT t0.id AS id_1, t0.from_url AS from_url_2, t0.to_url AS to_url_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.created_by AS created_by_6, t0.updated_by AS updated_by_7, t0.deleted_by AS deleted_by_8 FROM url_redirect t0 WHERE t0.deleted_by IS NULL AND t0.from_url = ? LIMIT 1
[
"https://ckdev.centrumkrzes [...]"
]
|
|
doctrine | SELECT t0.id AS id_1, t0.token AS token_2, t0.valid_to AS valid_to_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.created_by AS created_by_6, t0.updated_by AS updated_by_7, t0.deleted_by AS deleted_by_8, t0.user_id AS user_id_9 FROM fos_user_token t0 WHERE t0.deleted_by IS NULL AND t0.token IS NULL LIMIT 1 | |
event |
Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\DebugHandlersListener::configure" .
[ "event" => "kernel.request" "listener" => "Symfony\Component\HttpKernel\EventListener\DebugHandlersListener::configure" ] |
|
event |
Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\ValidateRequestListener::onKernelRequest" .
[ "event" => "kernel.request" "listener" => "Symfony\Component\HttpKernel\EventListener\ValidateRequestListener::onKernelRequest" ] |
|
event |
Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\SessionListener::onKernelRequest" .
[ "event" => "kernel.request" "listener" => "Symfony\Component\HttpKernel\EventListener\SessionListener::onKernelRequest" ] |
|
event |
Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\RouterListener::onKernelRequest" .
[ "event" => "kernel.request" "listener" => "Symfony\Component\HttpKernel\EventListener\RouterListener::onKernelRequest" ] |
|
event |
Notified event "kernel.request" to listener "Symfony\Bundle\FrameworkBundle\EventListener\ResolveControllerNameSubscriber::onKernelRequest" .
[ "event" => "kernel.request" "listener" => "Symfony\Bundle\FrameworkBundle\EventListener\ResolveControllerNameSubscriber::onKernelRequest" ] |
|
event |
Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\LocaleListener::onKernelRequest" .
[ "event" => "kernel.request" "listener" => "Symfony\Component\HttpKernel\EventListener\LocaleListener::onKernelRequest" ] |
|
event |
Notified event "kernel.request" to listener "FOS\RestBundle\EventListener\BodyListener::onKernelRequest" .
[ "event" => "kernel.request" "listener" => "FOS\RestBundle\EventListener\BodyListener::onKernelRequest" ] |
|
event |
Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\TranslatorListener::onKernelRequest" .
[ "event" => "kernel.request" "listener" => "Symfony\Component\HttpKernel\EventListener\TranslatorListener::onKernelRequest" ] |
|
event |
Notified event "kernel.request" to listener "Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener::onKernelRequest" .
[ "event" => "kernel.request" "listener" => "Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener::onKernelRequest" ] |
|
event |
Notified event "kernel.request" to listener "Knp\Bundle\PaginatorBundle\Subscriber\SlidingPaginationSubscriber::onKernelRequest" .
[ "event" => "kernel.request" "listener" => "Knp\Bundle\PaginatorBundle\Subscriber\SlidingPaginationSubscriber::onKernelRequest" ] |
|
event |
Notified event "kernel.request" to listener "App\Listener\RequestListener::onKernelRequest" .
[ "event" => "kernel.request" "listener" => "App\Listener\RequestListener::onKernelRequest" ] |
|
event |
Notified event "kernel.controller" to listener "Symfony\Bundle\FrameworkBundle\DataCollector\RouterDataCollector::onKernelController" .
[ "event" => "kernel.controller" "listener" => "Symfony\Bundle\FrameworkBundle\DataCollector\RouterDataCollector::onKernelController" ] |
|
event |
Notified event "kernel.controller" to listener "Symfony\Component\HttpKernel\DataCollector\RequestDataCollector::onKernelController" .
[ "event" => "kernel.controller" "listener" => "Symfony\Component\HttpKernel\DataCollector\RequestDataCollector::onKernelController" ] |
|
event |
Notified event "kernel.controller" to listener "Sensio\Bundle\FrameworkExtraBundle\EventListener\ControllerListener::onKernelController" .
[ "event" => "kernel.controller" "listener" => "Sensio\Bundle\FrameworkExtraBundle\EventListener\ControllerListener::onKernelController" ] |
|
event |
Notified event "kernel.controller" to listener "Sensio\Bundle\FrameworkExtraBundle\EventListener\ParamConverterListener::onKernelController" .
[ "event" => "kernel.controller" "listener" => "Sensio\Bundle\FrameworkExtraBundle\EventListener\ParamConverterListener::onKernelController" ] |
|
event |
Notified event "kernel.controller" to listener "Sensio\Bundle\FrameworkExtraBundle\EventListener\HttpCacheListener::onKernelController" .
[ "event" => "kernel.controller" "listener" => "Sensio\Bundle\FrameworkExtraBundle\EventListener\HttpCacheListener::onKernelController" ] |
|
event |
Notified event "kernel.controller" to listener "Sensio\Bundle\FrameworkExtraBundle\EventListener\TemplateListener::onKernelController" .
[ "event" => "kernel.controller" "listener" => "Sensio\Bundle\FrameworkExtraBundle\EventListener\TemplateListener::onKernelController" ] |
|
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" ] |
|
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" ] |
|
doctrine |
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.domain AS domain_3, t0.is_active AS is_active_4, t0.is_default AS is_default_5, t0.helpline AS helpline_6, t0.rounding_precision AS rounding_precision_7, t0.phone AS phone_8, t0.address AS address_9, t0.shop_name AS shop_name_10, t0.email AS email_11, t0.facebook AS facebook_12, t0.instagram AS instagram_13, t0.youtube AS youtube_14, t0.store_url AS store_url_15, t0.password_protected AS password_protected_16, t0.store_password AS store_password_17, t0.fb_pixel AS fb_pixel_18, t0.fb_token AS fb_token_19, t0.is_comments AS is_comments_20, t0.send_comment_request_days AS send_comment_request_days_21, t0.store_email AS store_email_22, t0.admin_store_email AS admin_store_email_23, t0.complaint_email AS complaint_email_24, t0.product_return_email AS product_return_email_25, t0.getresponse_campaign_id AS getresponse_campaign_id_26, t0.created_at AS created_at_27, t0.updated_at AS updated_at_28, t0.created_by AS created_by_29, t0.updated_by AS updated_by_30, t0.deleted_by AS deleted_by_31, t0.currency_id AS currency_id_32 FROM language t0 WHERE t0.locale = ? AND t0.deleted_by IS NULL LIMIT 1
[
"pl"
]
|
|
doctrine |
SELECT c0_.id AS id_0, c0_.level AS level_1, c0_.position AS position_2, c0_.alt AS alt_3, c0_.image_custom_name AS image_custom_name_4, c0_.image_name_2 AS image_name_2_5, c0_.image_name_3 AS image_name_3_6, c0_.image_name AS image_name_7, c0_.created_at AS created_at_8, c0_.updated_at AS updated_at_9, c0_.created_by AS created_by_10, c0_.updated_by AS updated_by_11, c0_.deleted_by AS deleted_by_12, c1_.id AS id_13, c1_.name AS name_14, c1_.description AS description_15, c1_.meta_title AS meta_title_16, c1_.meta_description AS meta_description_17, c1_.meta_keywords AS meta_keywords_18, c1_.custom_h1 AS custom_h1_19, c1_.canonical AS canonical_20, c1_.slug AS slug_21, c1_.google_product_type AS google_product_type_22, c1_.google_product_category AS google_product_category_23, c1_.special_product_category AS special_product_category_24, c1_.locale AS locale_25, c2_.id AS id_26, c2_.level AS level_27, c2_.position AS position_28, c2_.alt AS alt_29, c2_.image_custom_name AS image_custom_name_30, c2_.image_name_2 AS image_name_2_31, c2_.image_name_3 AS image_name_3_32, c2_.image_name AS image_name_33, c2_.created_at AS created_at_34, c2_.updated_at AS updated_at_35, c2_.created_by AS created_by_36, c2_.updated_by AS updated_by_37, c2_.deleted_by AS deleted_by_38, c3_.id AS id_39, c3_.name AS name_40, c3_.description AS description_41, c3_.meta_title AS meta_title_42, c3_.meta_description AS meta_description_43, c3_.meta_keywords AS meta_keywords_44, c3_.custom_h1 AS custom_h1_45, c3_.canonical AS canonical_46, c3_.slug AS slug_47, c3_.google_product_type AS google_product_type_48, c3_.google_product_category AS google_product_category_49, c3_.special_product_category AS special_product_category_50, c3_.locale AS locale_51, c4_.id AS id_52, c4_.visible AS visible_53, c4_.special AS special_54, c4_.shortcut AS shortcut_55, c4_.position AS position_56, c4_.is_homepage AS is_homepage_57, c4_.nb_products AS nb_products_58, c0_.category_parent_id AS category_parent_id_59, c1_.translatable_id AS translatable_id_60, c2_.category_parent_id AS category_parent_id_61, c3_.translatable_id AS translatable_id_62, c4_.category_id AS category_id_63, c4_.language AS language_64 FROM category c0_ INNER JOIN category_translation c1_ ON c0_.id = c1_.translatable_id INNER JOIN category_lang_param c5_ ON c0_.id = c5_.category_id INNER JOIN language l6_ ON c5_.language = l6_.id LEFT JOIN category c2_ ON c0_.id = c2_.category_parent_id LEFT JOIN category_translation c3_ ON c2_.id = c3_.translatable_id LEFT JOIN category_lang_param c4_ ON c2_.id = c4_.category_id LEFT JOIN language l7_ ON c4_.language = l7_.id WHERE c1_.locale = ? AND l6_.locale = ? AND c5_.special = ? AND c5_.shortcut = ? AND c0_.deleted_by IS NULL AND c5_.visible = ? AND c2_.deleted_by IS NULL AND l7_.locale = ? AND c4_.visible = 1 AND c0_.category_parent_id IS NULL AND c0_.id <> 209 AND c0_.id <> 121 ORDER BY c5_.position ASC, c4_.position ASC, c2_.position ASC
[ "pl" "pl" 0 0 true "pl" ] |
|
doctrine |
SELECT f0_.id AS id_0, f0_.image_name AS image_name_1, f0_.created_at AS created_at_2, f0_.updated_at AS updated_at_3, f0_.created_by AS created_by_4, f0_.updated_by AS updated_by_5, f0_.deleted_by AS deleted_by_6, f1_.id AS id_7, f1_.name AS name_8, f1_.description AS description_9, f1_.meta_title AS meta_title_10, f1_.meta_description AS meta_description_11, f1_.meta_keywords AS meta_keywords_12, f1_.canonical AS canonical_13, f1_.slug AS slug_14, f1_.locale AS locale_15, f2_.id AS id_16, f2_.visible AS visible_17, f2_.position AS position_18, f2_.nb_products AS nb_products_19, f0_.vat_id AS vat_id_20, f1_.translatable_id AS translatable_id_21, f2_.furniture_type_id AS furniture_type_id_22, f2_.language AS language_23 FROM furniture_type f0_ INNER JOIN furniture_type_translation f1_ ON f0_.id = f1_.translatable_id INNER JOIN furniture_lang_param f2_ ON f0_.id = f2_.furniture_type_id INNER JOIN language l3_ ON f2_.language = l3_.id WHERE f1_.locale = ? AND f0_.deleted_by IS NULL AND l3_.locale = ? AND f2_.visible = ? ORDER BY f2_.position ASC
[ "pl" "pl" 1 ] |
|
doctrine |
SELECT c0_.id AS id_0, c0_.level AS level_1, c0_.position AS position_2, c0_.alt AS alt_3, c0_.image_custom_name AS image_custom_name_4, c0_.image_name_2 AS image_name_2_5, c0_.image_name_3 AS image_name_3_6, c0_.image_name AS image_name_7, c0_.created_at AS created_at_8, c0_.updated_at AS updated_at_9, c0_.created_by AS created_by_10, c0_.updated_by AS updated_by_11, c0_.deleted_by AS deleted_by_12, c0_.category_parent_id AS category_parent_id_13 FROM category c0_ WHERE c0_.id IN (?)
[
[
"324"
]
]
|
|
doctrine |
SELECT p0_.id AS id_0, p0_.available AS available_1, p0_.created_at AS created_at_2, p0_.updated_at AS updated_at_3, p0_.created_by AS created_by_4, p0_.updated_by AS updated_by_5, p0_.deleted_by AS deleted_by_6, p1_.id AS id_7, p1_.is_filter AS is_filter_8, p1_.choosable AS choosable_9, p1_.group_name AS group_name_10, p1_.simple AS simple_11, p1_.created_at AS created_at_12, p1_.updated_at AS updated_at_13, p1_.created_by AS created_by_14, p1_.updated_by AS updated_by_15, p1_.deleted_by AS deleted_by_16, p0_.product_id AS product_id_17, p0_.product_parameter_id AS product_parameter_id_18, p0_.product_parameter_value_id AS product_parameter_value_id_19 FROM product_filter p0_ INNER JOIN product p2_ ON p0_.product_id = p2_.id INNER JOIN product_parameter p1_ ON p0_.product_parameter_id = p1_.id INNER JOIN product_category p3_ ON p2_.id = p3_.product_id INNER JOIN category c4_ ON p3_.category_id = c4_.id INNER JOIN product_parameter_lang_param p5_ ON p1_.id = p5_.product_parameter_id INNER JOIN language l6_ ON p5_.language = l6_.id WHERE l6_.locale = ? AND p0_.available = ? AND c4_.id = ? AND p0_.deleted_by IS NULL GROUP BY p1_.id
[ "pl" 1 "324" ] |
|
doctrine |
SELECT p0_.listingMarkersIds AS listingMarkersIds_0, p1_.promotion_icon AS promotion_icon_1, p1_.is_new AS is_new_2, p2_.image_name AS image_name_3, p3_.image_name AS image_name_4, p1_.bestseller AS bestseller_5, p4_.id AS id_6, c5_.sign AS sign_7, c5_.id AS id_8, p1_.price_description AS price_description_9, p1_.price_crossed AS price_crossed_10, p1_.omnibus_price AS omnibus_price_11, p0_.id AS id_12, p0_.symbol AS symbol_13, p0_.photo3d AS photo3d_14, p0_.is_variants AS is_variants_15, p0_.is_palette_delivery AS is_palette_delivery_16, p0_.payu AS payu_17, p0_.automatic_price AS automatic_price_18, p0_.halmar_stock_exchange AS halmar_stock_exchange_19, p0_.diablo_stock_exchange AS diablo_stock_exchange_20, p0_.jan_nowak_stock_exchange AS jan_nowak_stock_exchange_21, p0_.actona_stock_exchange AS actona_stock_exchange_22, p0_.unique_stock_exchange AS unique_stock_exchange_23, p0_.is_compare AS is_compare_24, p0_.priority_search_engine AS priority_search_engine_25, p0_.is_negotiate AS is_negotiate_26, p0_.is_rebate_code AS is_rebate_code_27, p0_.old_price AS old_price_28, p0_.film AS film_29, p0_.small_product_photo AS small_product_photo_30, p0_.max_quantity AS max_quantity_31, p0_.listingMarkersIds AS listingMarkersIds_32, p0_.temporary_unavailable AS temporary_unavailable_33, p0_.last_ranking_update AS last_ranking_update_34, p0_.height AS height_35, p0_.width AS width_36, p0_.depth AS depth_37, p0_.shipping_category AS shipping_category_38, p0_.created_at AS created_at_39, p0_.updated_at AS updated_at_40, p0_.created_by AS created_by_41, p0_.updated_by AS updated_by_42, p0_.deleted_by AS deleted_by_43, p6_.id AS id_44, p6_.name AS name_45, p6_.description AS description_46, p6_.meta_title AS meta_title_47, p6_.meta_description AS meta_description_48, p6_.meta_keywords AS meta_keywords_49, p6_.slug AS slug_50, p6_.short_description AS short_description_51, p6_.short_description_textile AS short_description_textile_52, p6_.short_description_color AS short_description_color_53, p6_.short_function_description AS short_function_description_54, p6_.search_engine AS search_engine_55, p6_.photo3d_gallery_url AS photo3d_gallery_url_56, p6_.youtube_gallery_url AS youtube_gallery_url_57, p6_.trans_film AS trans_film_58, p6_.canonical AS canonical_59, p6_.photo3d_additional AS photo3d_additional_60, p6_.locale AS locale_61, p1_.id AS id_62, p1_.visible AS visible_63, p1_.price_description AS price_description_64, p1_.promotion AS promotion_65, p1_.is_new AS is_new_66, p1_.bestseller AS bestseller_67, p1_.promote_one_homepage AS promote_one_homepage_68, p1_.ready_for_publication AS ready_for_publication_69, p1_.sale AS sale_70, p1_.rating_value AS rating_value_71, p1_.review_count AS review_count_72, p1_.price_change AS price_change_73, p1_.priority AS priority_74, p1_.price_crossed AS price_crossed_75, p1_.omnibus_price AS omnibus_price_76, p1_.promotion_icon AS promotion_icon_77, p1_.promo_price AS promo_price_78, l7_.id AS id_79, l7_.locale AS locale_80, l7_.domain AS domain_81, l7_.is_active AS is_active_82, l7_.is_default AS is_default_83, l7_.helpline AS helpline_84, l7_.rounding_precision AS rounding_precision_85, l7_.phone AS phone_86, l7_.address AS address_87, l7_.shop_name AS shop_name_88, l7_.email AS email_89, l7_.facebook AS facebook_90, l7_.instagram AS instagram_91, l7_.youtube AS youtube_92, l7_.store_url AS store_url_93, l7_.password_protected AS password_protected_94, l7_.store_password AS store_password_95, l7_.fb_pixel AS fb_pixel_96, l7_.fb_token AS fb_token_97, l7_.is_comments AS is_comments_98, l7_.send_comment_request_days AS send_comment_request_days_99, l7_.store_email AS store_email_100, l7_.admin_store_email AS admin_store_email_101, l7_.complaint_email AS complaint_email_102, l7_.product_return_email AS product_return_email_103, l7_.getresponse_campaign_id AS getresponse_campaign_id_104, l7_.created_at AS created_at_105, l7_.updated_at AS updated_at_106, l7_.created_by AS created_by_107, l7_.updated_by AS updated_by_108, l7_.deleted_by AS deleted_by_109, c5_.id AS id_110, c5_.sign AS sign_111, c5_.currency_separator AS currency_separator_112, c5_.position_price AS position_price_113, c5_.is_default AS is_default_114, c5_.is_active AS is_active_115, c5_.factorPln AS factorPln_116, c5_.iso_code AS iso_code_117, c5_.created_at AS created_at_118, c5_.updated_at AS updated_at_119, c5_.created_by AS created_by_120, c5_.updated_by AS updated_by_121, c5_.deleted_by AS deleted_by_122, a8_.id AS id_123, a8_.is_visible AS is_visible_124, a8_.is_currentyly_unavailable AS is_currentyly_unavailable_125, a8_.days AS days_126, a8_.ceneo_days AS ceneo_days_127, a8_.internal_name AS internal_name_128, a8_.created_at AS created_at_129, a8_.updated_at AS updated_at_130, a8_.created_by AS created_by_131, a8_.updated_by AS updated_by_132, a8_.deleted_by AS deleted_by_133, a9_.id AS id_134, a9_.name AS name_135, a9_.locale AS locale_136, p10_.id AS id_137, p10_.name AS name_138, p10_.responsible_entity AS responsible_entity_139, p10_.image_name AS image_name_140, p10_.created_at AS created_at_141, p10_.updated_at AS updated_at_142, p10_.created_by AS created_by_143, p10_.updated_by AS updated_by_144, p10_.deleted_by AS deleted_by_145, p3_.id AS id_146, p3_.main AS main_147, p3_.lifestyle AS lifestyle_148, p3_.hover AS hover_149, p3_.name AS name_150, p3_.image_name AS image_name_151, p3_.position AS position_152, p3_.alt AS alt_153, p3_.image_custom_name AS image_custom_name_154, l11_.id AS id_155, l11_.locale AS locale_156, l11_.domain AS domain_157, l11_.is_active AS is_active_158, l11_.is_default AS is_default_159, l11_.helpline AS helpline_160, l11_.rounding_precision AS rounding_precision_161, l11_.phone AS phone_162, l11_.address AS address_163, l11_.shop_name AS shop_name_164, l11_.email AS email_165, l11_.facebook AS facebook_166, l11_.instagram AS instagram_167, l11_.youtube AS youtube_168, l11_.store_url AS store_url_169, l11_.password_protected AS password_protected_170, l11_.store_password AS store_password_171, l11_.fb_pixel AS fb_pixel_172, l11_.fb_token AS fb_token_173, l11_.is_comments AS is_comments_174, l11_.send_comment_request_days AS send_comment_request_days_175, l11_.store_email AS store_email_176, l11_.admin_store_email AS admin_store_email_177, l11_.complaint_email AS complaint_email_178, l11_.product_return_email AS product_return_email_179, l11_.getresponse_campaign_id AS getresponse_campaign_id_180, l11_.created_at AS created_at_181, l11_.updated_at AS updated_at_182, l11_.created_by AS created_by_183, l11_.updated_by AS updated_by_184, l11_.deleted_by AS deleted_by_185, p12_.id AS id_186, p12_.price AS price_187, p12_.discount AS discount_188, p12_.old_price AS old_price_189, p12_.active AS active_190, p12_.automatic_price_comment AS automatic_price_comment_191, p12_.ean AS ean_192, p12_.automatic_price AS automatic_price_193, p12_.automatic_price_discount AS automatic_price_discount_194, p12_.created_at AS created_at_195, p12_.updated_at AS updated_at_196, p12_.created_by AS created_by_197, p12_.updated_by AS updated_by_198, p12_.deleted_by AS deleted_by_199, p0_.product_family_id AS product_family_id_200, p0_.product_producer_id AS product_producer_id_201, p0_.availability_id AS availability_id_202, p0_.main_category_id AS main_category_id_203, p6_.translatable_id AS translatable_id_204, p1_.product_id AS product_id_205, p1_.language AS language_206, p1_.vat_id AS vat_id_207, p1_.availability_id AS availability_id_208, p1_.product_producer_id AS product_producer_id_209, l7_.currency_id AS currency_id_210, a9_.translatable_id AS translatable_id_211, p3_.product_id AS product_id_212, l11_.currency_id AS currency_id_213, p12_.product_id AS product_id_214, p12_.parent_product_price_id AS parent_product_price_id_215, p12_.currency_id AS currency_id_216, p12_.language AS language_217 FROM product p0_ INNER JOIN product_translation p6_ ON p0_.id = p6_.translatable_id INNER JOIN product_lang_param p1_ ON p0_.id = p1_.product_id INNER JOIN language l7_ ON p1_.language = l7_.id INNER JOIN product_vat p4_ ON p1_.vat_id = p4_.id INNER JOIN currency c5_ ON l7_.currency_id = c5_.id INNER JOIN availability a8_ ON p1_.availability_id = a8_.id INNER JOIN availability_translation a9_ ON a8_.id = a9_.translatable_id INNER JOIN product_producer p10_ ON p1_.product_producer_id = p10_.id INNER JOIN product_photo p3_ ON p0_.id = p3_.product_id LEFT JOIN product_photo p2_ ON p0_.id = p2_.product_id AND (p2_.lifestyle = 1) INNER JOIN product_photo_language p13_ ON p3_.id = p13_.product_photo_id INNER JOIN language l11_ ON l11_.id = p13_.language_id LEFT JOIN product_price p12_ ON p0_.id = p12_.product_id LEFT JOIN language l14_ ON p12_.language = l14_.id INNER JOIN product_category p15_ ON p0_.id = p15_.product_id LEFT JOIN category c16_ ON p0_.main_category_id = c16_.id LEFT JOIN product_product_color p18_ ON p0_.id = p18_.product_id LEFT JOIN product_color p17_ ON p17_.id = p18_.product_color_id WHERE p6_.locale = ? AND a9_.locale = ? AND l14_.locale = ? AND a8_.deleted_by IS NULL AND (p3_.main = ?) AND l11_.locale = ? AND l7_.locale = ? AND p12_.deleted_by IS NULL AND p0_.deleted_by IS NULL AND p1_.visible = ? AND p15_.category_id = ? AND c16_.deleted_by IS NULL GROUP BY p0_.id ORDER BY p15_.position ASC, p3_.position ASC
[ "pl" "pl" "pl" true "pl" "pl" true 324 ] |
|
doctrine |
SELECT p0_.id AS id_0, p0_.is_filter AS is_filter_1, p0_.choosable AS choosable_2, p0_.group_name AS group_name_3, p0_.simple AS simple_4, p0_.created_at AS created_at_5, p0_.updated_at AS updated_at_6, p0_.created_by AS created_by_7, p0_.updated_by AS updated_by_8, p0_.deleted_by AS deleted_by_9, p1_.id AS id_10, p1_.name AS name_11, p1_.locale AS locale_12, p2_.id AS id_13, p2_.visible AS visible_14, p2_.position AS position_15, l3_.id AS id_16, l3_.locale AS locale_17, l3_.domain AS domain_18, l3_.is_active AS is_active_19, l3_.is_default AS is_default_20, l3_.helpline AS helpline_21, l3_.rounding_precision AS rounding_precision_22, l3_.phone AS phone_23, l3_.address AS address_24, l3_.shop_name AS shop_name_25, l3_.email AS email_26, l3_.facebook AS facebook_27, l3_.instagram AS instagram_28, l3_.youtube AS youtube_29, l3_.store_url AS store_url_30, l3_.password_protected AS password_protected_31, l3_.store_password AS store_password_32, l3_.fb_pixel AS fb_pixel_33, l3_.fb_token AS fb_token_34, l3_.is_comments AS is_comments_35, l3_.send_comment_request_days AS send_comment_request_days_36, l3_.store_email AS store_email_37, l3_.admin_store_email AS admin_store_email_38, l3_.complaint_email AS complaint_email_39, l3_.product_return_email AS product_return_email_40, l3_.getresponse_campaign_id AS getresponse_campaign_id_41, l3_.created_at AS created_at_42, l3_.updated_at AS updated_at_43, l3_.created_by AS created_by_44, l3_.updated_by AS updated_by_45, l3_.deleted_by AS deleted_by_46, p1_.translatable_id AS translatable_id_47, p2_.product_parameter_id AS product_parameter_id_48, p2_.language AS language_49, l3_.currency_id AS currency_id_50 FROM product_parameter p0_ INNER JOIN product_parameter_translation p1_ ON p0_.id = p1_.translatable_id INNER JOIN product_parameter_lang_param p2_ ON p0_.id = p2_.product_parameter_id INNER JOIN language l3_ ON p2_.language = l3_.id WHERE p1_.locale = ? AND l3_.locale = ? AND p2_.visible = ? AND p0_.is_filter = 1 AND p0_.deleted_by IS NULL AND p0_.group_name = ? AND p0_.id IN (?) ORDER BY p2_.position ASC
[ "pl" "pl" 1 "ergonomia" [ 82 ] ] |
|
doctrine |
SELECT p0_.id AS id_0, p0_.is_filter AS is_filter_1, p0_.choosable AS choosable_2, p0_.group_name AS group_name_3, p0_.simple AS simple_4, p0_.created_at AS created_at_5, p0_.updated_at AS updated_at_6, p0_.created_by AS created_by_7, p0_.updated_by AS updated_by_8, p0_.deleted_by AS deleted_by_9, p1_.id AS id_10, p1_.name AS name_11, p1_.locale AS locale_12, p2_.id AS id_13, p2_.visible AS visible_14, p2_.position AS position_15, l3_.id AS id_16, l3_.locale AS locale_17, l3_.domain AS domain_18, l3_.is_active AS is_active_19, l3_.is_default AS is_default_20, l3_.helpline AS helpline_21, l3_.rounding_precision AS rounding_precision_22, l3_.phone AS phone_23, l3_.address AS address_24, l3_.shop_name AS shop_name_25, l3_.email AS email_26, l3_.facebook AS facebook_27, l3_.instagram AS instagram_28, l3_.youtube AS youtube_29, l3_.store_url AS store_url_30, l3_.password_protected AS password_protected_31, l3_.store_password AS store_password_32, l3_.fb_pixel AS fb_pixel_33, l3_.fb_token AS fb_token_34, l3_.is_comments AS is_comments_35, l3_.send_comment_request_days AS send_comment_request_days_36, l3_.store_email AS store_email_37, l3_.admin_store_email AS admin_store_email_38, l3_.complaint_email AS complaint_email_39, l3_.product_return_email AS product_return_email_40, l3_.getresponse_campaign_id AS getresponse_campaign_id_41, l3_.created_at AS created_at_42, l3_.updated_at AS updated_at_43, l3_.created_by AS created_by_44, l3_.updated_by AS updated_by_45, l3_.deleted_by AS deleted_by_46, p1_.translatable_id AS translatable_id_47, p2_.product_parameter_id AS product_parameter_id_48, p2_.language AS language_49, l3_.currency_id AS currency_id_50 FROM product_parameter p0_ INNER JOIN product_parameter_translation p1_ ON p0_.id = p1_.translatable_id INNER JOIN product_parameter_lang_param p2_ ON p0_.id = p2_.product_parameter_id INNER JOIN language l3_ ON p2_.language = l3_.id WHERE p1_.locale = ? AND l3_.locale = ? AND p2_.visible = ? AND p0_.is_filter = 1 AND p0_.deleted_by IS NULL AND p0_.group_name = ? AND p0_.id IN (?) ORDER BY p2_.position ASC
[ "pl" "pl" 1 "funkcje" [ 82 ] ] |
|
doctrine |
SELECT p0_.id AS id_0, p0_.is_filter AS is_filter_1, p0_.choosable AS choosable_2, p0_.group_name AS group_name_3, p0_.simple AS simple_4, p0_.created_at AS created_at_5, p0_.updated_at AS updated_at_6, p0_.created_by AS created_by_7, p0_.updated_by AS updated_by_8, p0_.deleted_by AS deleted_by_9, p1_.id AS id_10, p1_.name AS name_11, p1_.locale AS locale_12, p2_.id AS id_13, p2_.visible AS visible_14, p2_.position AS position_15, l3_.id AS id_16, l3_.locale AS locale_17, l3_.domain AS domain_18, l3_.is_active AS is_active_19, l3_.is_default AS is_default_20, l3_.helpline AS helpline_21, l3_.rounding_precision AS rounding_precision_22, l3_.phone AS phone_23, l3_.address AS address_24, l3_.shop_name AS shop_name_25, l3_.email AS email_26, l3_.facebook AS facebook_27, l3_.instagram AS instagram_28, l3_.youtube AS youtube_29, l3_.store_url AS store_url_30, l3_.password_protected AS password_protected_31, l3_.store_password AS store_password_32, l3_.fb_pixel AS fb_pixel_33, l3_.fb_token AS fb_token_34, l3_.is_comments AS is_comments_35, l3_.send_comment_request_days AS send_comment_request_days_36, l3_.store_email AS store_email_37, l3_.admin_store_email AS admin_store_email_38, l3_.complaint_email AS complaint_email_39, l3_.product_return_email AS product_return_email_40, l3_.getresponse_campaign_id AS getresponse_campaign_id_41, l3_.created_at AS created_at_42, l3_.updated_at AS updated_at_43, l3_.created_by AS created_by_44, l3_.updated_by AS updated_by_45, l3_.deleted_by AS deleted_by_46, p1_.translatable_id AS translatable_id_47, p2_.product_parameter_id AS product_parameter_id_48, p2_.language AS language_49, l3_.currency_id AS currency_id_50 FROM product_parameter p0_ INNER JOIN product_parameter_translation p1_ ON p0_.id = p1_.translatable_id INNER JOIN product_parameter_lang_param p2_ ON p0_.id = p2_.product_parameter_id INNER JOIN language l3_ ON p2_.language = l3_.id WHERE p1_.locale = ? AND l3_.locale = ? AND p2_.visible = ? AND p0_.is_filter = 1 AND p0_.deleted_by IS NULL AND p0_.group_name = ? AND p0_.id IN (?) ORDER BY p2_.position ASC
[ "pl" "pl" 1 "wykonanie" [ 82 ] ] |
|
doctrine |
SELECT a0_.id AS id_0, a0_.is_visible AS is_visible_1, a0_.is_currentyly_unavailable AS is_currentyly_unavailable_2, a0_.days AS days_3, a0_.ceneo_days AS ceneo_days_4, a0_.internal_name AS internal_name_5, a0_.created_at AS created_at_6, a0_.updated_at AS updated_at_7, a0_.created_by AS created_by_8, a0_.updated_by AS updated_by_9, a0_.deleted_by AS deleted_by_10 FROM availability a0_ INNER JOIN availability_translation a1_ ON a0_.id = a1_.translatable_id WHERE a1_.locale = ? AND a0_.deleted_by IS NULL AND a0_.is_visible = 1
[
"pl"
]
|
|
doctrine |
SELECT t0.id AS id_1, t0.name AS name_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM availability_translation t0 WHERE t0.translatable_id = ?
[
5
]
|
|
doctrine |
SELECT p0_.id AS id_0, p0_.group_name AS group_name_1, p0_.created_at AS created_at_2, p0_.updated_at AS updated_at_3, p0_.created_by AS created_by_4, p0_.updated_by AS updated_by_5, p0_.deleted_by AS deleted_by_6 FROM product_color p0_ INNER JOIN product_color_translation p1_ ON p0_.id = p1_.translatable_id WHERE p1_.locale = ? AND p0_.deleted_by IS NULL ORDER BY p1_.name ASC
[
"pl"
]
|
|
doctrine |
SELECT t0.id AS id_1, t0.name AS name_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM product_color_translation t0 WHERE t0.translatable_id = ?
[
1
]
|
|
doctrine |
SELECT t0.id AS id_1, t0.name AS name_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM product_color_translation t0 WHERE t0.translatable_id = ?
[
2
]
|
|
doctrine |
SELECT t0.id AS id_1, t0.name AS name_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM product_color_translation t0 WHERE t0.translatable_id = ?
[
5
]
|
|
doctrine |
SELECT t0.id AS id_1, t0.name AS name_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM product_color_translation t0 WHERE t0.translatable_id = ?
[
10
]
|
|
doctrine |
SELECT t0.id AS id_1, t0.name AS name_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM product_color_translation t0 WHERE t0.translatable_id = ?
[
3
]
|
|
doctrine |
SELECT t0.id AS id_1, t0.name AS name_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM product_color_translation t0 WHERE t0.translatable_id = ?
[
11
]
|
|
doctrine |
SELECT t0.id AS id_1, t0.name AS name_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM product_color_translation t0 WHERE t0.translatable_id = ?
[
6
]
|
|
doctrine |
SELECT t0.id AS id_1, t0.name AS name_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM product_color_translation t0 WHERE t0.translatable_id = ?
[
9
]
|
|
doctrine |
SELECT t0.id AS id_1, t0.name AS name_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM product_color_translation t0 WHERE t0.translatable_id = ?
[
12
]
|
|
doctrine |
SELECT t0.id AS id_1, t0.name AS name_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM product_color_translation t0 WHERE t0.translatable_id = ?
[
4
]
|
|
doctrine |
SELECT t0.id AS id_1, t0.name AS name_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM product_color_translation t0 WHERE t0.translatable_id = ?
[
7
]
|
|
doctrine |
SELECT t0.id AS id_1, t0.name AS name_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM product_color_translation t0 WHERE t0.translatable_id = ?
[
8
]
|
|
doctrine |
SELECT p0_.promotion_icon AS promotion_icon_0, p0_.is_new AS is_new_1, p1_.image_name AS image_name_2, p0_.bestseller AS bestseller_3, p2_.id AS id_4, c3_.id AS id_5, p0_.price_description AS price_description_6, p4_.id AS id_7, p4_.session AS session_8, p4_.created_at AS created_at_9, p4_.updated_at AS updated_at_10, p5_.id AS id_11, p5_.symbol AS symbol_12, p5_.photo3d AS photo3d_13, p5_.is_variants AS is_variants_14, p5_.is_palette_delivery AS is_palette_delivery_15, p5_.payu AS payu_16, p5_.automatic_price AS automatic_price_17, p5_.halmar_stock_exchange AS halmar_stock_exchange_18, p5_.diablo_stock_exchange AS diablo_stock_exchange_19, p5_.jan_nowak_stock_exchange AS jan_nowak_stock_exchange_20, p5_.actona_stock_exchange AS actona_stock_exchange_21, p5_.unique_stock_exchange AS unique_stock_exchange_22, p5_.is_compare AS is_compare_23, p5_.priority_search_engine AS priority_search_engine_24, p5_.is_negotiate AS is_negotiate_25, p5_.is_rebate_code AS is_rebate_code_26, p5_.old_price AS old_price_27, p5_.film AS film_28, p5_.small_product_photo AS small_product_photo_29, p5_.max_quantity AS max_quantity_30, p5_.listingMarkersIds AS listingMarkersIds_31, p5_.temporary_unavailable AS temporary_unavailable_32, p5_.last_ranking_update AS last_ranking_update_33, p5_.height AS height_34, p5_.width AS width_35, p5_.depth AS depth_36, p5_.shipping_category AS shipping_category_37, p5_.created_at AS created_at_38, p5_.updated_at AS updated_at_39, p5_.created_by AS created_by_40, p5_.updated_by AS updated_by_41, p5_.deleted_by AS deleted_by_42, p6_.id AS id_43, p6_.name AS name_44, p6_.description AS description_45, p6_.meta_title AS meta_title_46, p6_.meta_description AS meta_description_47, p6_.meta_keywords AS meta_keywords_48, p6_.slug AS slug_49, p6_.short_description AS short_description_50, p6_.short_description_textile AS short_description_textile_51, p6_.short_description_color AS short_description_color_52, p6_.short_function_description AS short_function_description_53, p6_.search_engine AS search_engine_54, p6_.photo3d_gallery_url AS photo3d_gallery_url_55, p6_.youtube_gallery_url AS youtube_gallery_url_56, p6_.trans_film AS trans_film_57, p6_.canonical AS canonical_58, p6_.photo3d_additional AS photo3d_additional_59, p6_.locale AS locale_60, p0_.id AS id_61, p0_.visible AS visible_62, p0_.price_description AS price_description_63, p0_.promotion AS promotion_64, p0_.is_new AS is_new_65, p0_.bestseller AS bestseller_66, p0_.promote_one_homepage AS promote_one_homepage_67, p0_.ready_for_publication AS ready_for_publication_68, p0_.sale AS sale_69, p0_.rating_value AS rating_value_70, p0_.review_count AS review_count_71, p0_.price_change AS price_change_72, p0_.priority AS priority_73, p0_.price_crossed AS price_crossed_74, p0_.omnibus_price AS omnibus_price_75, p0_.promotion_icon AS promotion_icon_76, p0_.promo_price AS promo_price_77, p7_.id AS id_78, p7_.name AS name_79, p7_.responsible_entity AS responsible_entity_80, p7_.image_name AS image_name_81, p7_.created_at AS created_at_82, p7_.updated_at AS updated_at_83, p7_.created_by AS created_by_84, p7_.updated_by AS updated_by_85, p7_.deleted_by AS deleted_by_86, l8_.id AS id_87, l8_.locale AS locale_88, l8_.domain AS domain_89, l8_.is_active AS is_active_90, l8_.is_default AS is_default_91, l8_.helpline AS helpline_92, l8_.rounding_precision AS rounding_precision_93, l8_.phone AS phone_94, l8_.address AS address_95, l8_.shop_name AS shop_name_96, l8_.email AS email_97, l8_.facebook AS facebook_98, l8_.instagram AS instagram_99, l8_.youtube AS youtube_100, l8_.store_url AS store_url_101, l8_.password_protected AS password_protected_102, l8_.store_password AS store_password_103, l8_.fb_pixel AS fb_pixel_104, l8_.fb_token AS fb_token_105, l8_.is_comments AS is_comments_106, l8_.send_comment_request_days AS send_comment_request_days_107, l8_.store_email AS store_email_108, l8_.admin_store_email AS admin_store_email_109, l8_.complaint_email AS complaint_email_110, l8_.product_return_email AS product_return_email_111, l8_.getresponse_campaign_id AS getresponse_campaign_id_112, l8_.created_at AS created_at_113, l8_.updated_at AS updated_at_114, l8_.created_by AS created_by_115, l8_.updated_by AS updated_by_116, l8_.deleted_by AS deleted_by_117, c3_.id AS id_118, c3_.sign AS sign_119, c3_.currency_separator AS currency_separator_120, c3_.position_price AS position_price_121, c3_.is_default AS is_default_122, c3_.is_active AS is_active_123, c3_.factorPln AS factorPln_124, c3_.iso_code AS iso_code_125, c3_.created_at AS created_at_126, c3_.updated_at AS updated_at_127, c3_.created_by AS created_by_128, c3_.updated_by AS updated_by_129, c3_.deleted_by AS deleted_by_130, a9_.id AS id_131, a9_.is_visible AS is_visible_132, a9_.is_currentyly_unavailable AS is_currentyly_unavailable_133, a9_.days AS days_134, a9_.ceneo_days AS ceneo_days_135, a9_.internal_name AS internal_name_136, a9_.created_at AS created_at_137, a9_.updated_at AS updated_at_138, a9_.created_by AS created_by_139, a9_.updated_by AS updated_by_140, a9_.deleted_by AS deleted_by_141, a10_.id AS id_142, a10_.name AS name_143, a10_.locale AS locale_144, p1_.id AS id_145, p1_.main AS main_146, p1_.lifestyle AS lifestyle_147, p1_.hover AS hover_148, p1_.name AS name_149, p1_.image_name AS image_name_150, p1_.position AS position_151, p1_.alt AS alt_152, p1_.image_custom_name AS image_custom_name_153, l11_.id AS id_154, l11_.locale AS locale_155, l11_.domain AS domain_156, l11_.is_active AS is_active_157, l11_.is_default AS is_default_158, l11_.helpline AS helpline_159, l11_.rounding_precision AS rounding_precision_160, l11_.phone AS phone_161, l11_.address AS address_162, l11_.shop_name AS shop_name_163, l11_.email AS email_164, l11_.facebook AS facebook_165, l11_.instagram AS instagram_166, l11_.youtube AS youtube_167, l11_.store_url AS store_url_168, l11_.password_protected AS password_protected_169, l11_.store_password AS store_password_170, l11_.fb_pixel AS fb_pixel_171, l11_.fb_token AS fb_token_172, l11_.is_comments AS is_comments_173, l11_.send_comment_request_days AS send_comment_request_days_174, l11_.store_email AS store_email_175, l11_.admin_store_email AS admin_store_email_176, l11_.complaint_email AS complaint_email_177, l11_.product_return_email AS product_return_email_178, l11_.getresponse_campaign_id AS getresponse_campaign_id_179, l11_.created_at AS created_at_180, l11_.updated_at AS updated_at_181, l11_.created_by AS created_by_182, l11_.updated_by AS updated_by_183, l11_.deleted_by AS deleted_by_184, p12_.id AS id_185, p12_.price AS price_186, p12_.discount AS discount_187, p12_.old_price AS old_price_188, p12_.active AS active_189, p12_.automatic_price_comment AS automatic_price_comment_190, p12_.ean AS ean_191, p12_.automatic_price AS automatic_price_192, p12_.automatic_price_discount AS automatic_price_discount_193, p12_.created_at AS created_at_194, p12_.updated_at AS updated_at_195, p12_.created_by AS created_by_196, p12_.updated_by AS updated_by_197, p12_.deleted_by AS deleted_by_198, p4_.product_id AS product_id_199, p5_.product_family_id AS product_family_id_200, p5_.product_producer_id AS product_producer_id_201, p5_.availability_id AS availability_id_202, p5_.main_category_id AS main_category_id_203, p6_.translatable_id AS translatable_id_204, p0_.product_id AS product_id_205, p0_.language AS language_206, p0_.vat_id AS vat_id_207, p0_.availability_id AS availability_id_208, p0_.product_producer_id AS product_producer_id_209, l8_.currency_id AS currency_id_210, a10_.translatable_id AS translatable_id_211, p1_.product_id AS product_id_212, l11_.currency_id AS currency_id_213, p12_.product_id AS product_id_214, p12_.parent_product_price_id AS parent_product_price_id_215, p12_.currency_id AS currency_id_216, p12_.language AS language_217 FROM product_view p4_ LEFT JOIN product p5_ ON p4_.product_id = p5_.id INNER JOIN product_translation p6_ ON p5_.id = p6_.translatable_id INNER JOIN product_lang_param p0_ ON p5_.id = p0_.product_id LEFT JOIN product_producer p7_ ON p0_.product_producer_id = p7_.id INNER JOIN language l8_ ON p0_.language = l8_.id INNER JOIN product_vat p2_ ON p0_.vat_id = p2_.id INNER JOIN currency c3_ ON l8_.currency_id = c3_.id INNER JOIN availability a9_ ON p0_.availability_id = a9_.id INNER JOIN availability_translation a10_ ON a9_.id = a10_.translatable_id INNER JOIN product_photo p1_ ON p5_.id = p1_.product_id INNER JOIN product_photo_language p13_ ON p1_.id = p13_.product_photo_id INNER JOIN language l11_ ON l11_.id = p13_.language_id LEFT JOIN product_price p12_ ON p5_.id = p12_.product_id LEFT JOIN language l14_ ON p12_.language = l14_.id WHERE p4_.session = ? AND p6_.locale = ? AND a10_.locale = ? AND l14_.locale = ? AND a9_.deleted_by IS NULL AND p1_.main = ? AND l11_.locale = ? AND l8_.locale = ? AND p5_.deleted_by IS NULL AND p0_.visible = ? ORDER BY p4_.id DESC, p1_.position ASC LIMIT 4
[ "fa1743b9bb3e51fb90a1e9cf9fcca6e1" "pl" "pl" "pl" true "pl" "pl" true ] |
|
event |
Notified event "knp_pager.before" to listener "Knp\Component\Pager\Event\Subscriber\Sortable\SortableSubscriber::before" .
[ "event" => "knp_pager.before" "listener" => "Knp\Component\Pager\Event\Subscriber\Sortable\SortableSubscriber::before" ] |
|
event |
Notified event "knp_pager.before" to listener "Knp\Component\Pager\Event\Subscriber\Filtration\FiltrationSubscriber::before" .
[ "event" => "knp_pager.before" "listener" => "Knp\Component\Pager\Event\Subscriber\Filtration\FiltrationSubscriber::before" ] |
|
event |
Notified event "knp_pager.before" to listener "Knp\Component\Pager\Event\Subscriber\Paginate\PaginationSubscriber::before" .
[ "event" => "knp_pager.before" "listener" => "Knp\Component\Pager\Event\Subscriber\Paginate\PaginationSubscriber::before" ] |
|
doctrine |
SELECT COUNT(*) AS dctrn_count FROM (SELECT p0_.listingMarkersIds AS listingMarkersIds_0, p1_.promotion_icon AS promotion_icon_1, p1_.is_new AS is_new_2, p2_.image_name AS image_name_3, p3_.image_name AS image_name_4, p1_.bestseller AS bestseller_5, p4_.id AS id_6, c5_.sign AS sign_7, c5_.id AS id_8, p1_.price_description AS price_description_9, p1_.price_crossed AS price_crossed_10, p1_.omnibus_price AS omnibus_price_11, p0_.id AS id_12, p0_.symbol AS symbol_13, p0_.photo3d AS photo3d_14, p0_.is_variants AS is_variants_15, p0_.is_palette_delivery AS is_palette_delivery_16, p0_.payu AS payu_17, p0_.automatic_price AS automatic_price_18, p0_.halmar_stock_exchange AS halmar_stock_exchange_19, p0_.diablo_stock_exchange AS diablo_stock_exchange_20, p0_.jan_nowak_stock_exchange AS jan_nowak_stock_exchange_21, p0_.actona_stock_exchange AS actona_stock_exchange_22, p0_.unique_stock_exchange AS unique_stock_exchange_23, p0_.is_compare AS is_compare_24, p0_.priority_search_engine AS priority_search_engine_25, p0_.is_negotiate AS is_negotiate_26, p0_.is_rebate_code AS is_rebate_code_27, p0_.old_price AS old_price_28, p0_.film AS film_29, p0_.small_product_photo AS small_product_photo_30, p0_.max_quantity AS max_quantity_31, p0_.listingMarkersIds AS listingMarkersIds_32, p0_.temporary_unavailable AS temporary_unavailable_33, p0_.last_ranking_update AS last_ranking_update_34, p0_.height AS height_35, p0_.width AS width_36, p0_.depth AS depth_37, p0_.shipping_category AS shipping_category_38, p0_.created_at AS created_at_39, p0_.updated_at AS updated_at_40, p0_.created_by AS created_by_41, p0_.updated_by AS updated_by_42, p0_.deleted_by AS deleted_by_43, p6_.id AS id_44, p6_.name AS name_45, p6_.description AS description_46, p6_.meta_title AS meta_title_47, p6_.meta_description AS meta_description_48, p6_.meta_keywords AS meta_keywords_49, p6_.slug AS slug_50, p6_.short_description AS short_description_51, p6_.short_description_textile AS short_description_textile_52, p6_.short_description_color AS short_description_color_53, p6_.short_function_description AS short_function_description_54, p6_.search_engine AS search_engine_55, p6_.photo3d_gallery_url AS photo3d_gallery_url_56, p6_.youtube_gallery_url AS youtube_gallery_url_57, p6_.trans_film AS trans_film_58, p6_.canonical AS canonical_59, p6_.photo3d_additional AS photo3d_additional_60, p6_.locale AS locale_61, p1_.id AS id_62, p1_.visible AS visible_63, p1_.price_description AS price_description_64, p1_.promotion AS promotion_65, p1_.is_new AS is_new_66, p1_.bestseller AS bestseller_67, p1_.promote_one_homepage AS promote_one_homepage_68, p1_.ready_for_publication AS ready_for_publication_69, p1_.sale AS sale_70, p1_.rating_value AS rating_value_71, p1_.review_count AS review_count_72, p1_.price_change AS price_change_73, p1_.priority AS priority_74, p1_.price_crossed AS price_crossed_75, p1_.omnibus_price AS omnibus_price_76, p1_.promotion_icon AS promotion_icon_77, p1_.promo_price AS promo_price_78, l7_.id AS id_79, l7_.locale AS locale_80, l7_.domain AS domain_81, l7_.is_active AS is_active_82, l7_.is_default AS is_default_83, l7_.helpline AS helpline_84, l7_.rounding_precision AS rounding_precision_85, l7_.phone AS phone_86, l7_.address AS address_87, l7_.shop_name AS shop_name_88, l7_.email AS email_89, l7_.facebook AS facebook_90, l7_.instagram AS instagram_91, l7_.youtube AS youtube_92, l7_.store_url AS store_url_93, l7_.password_protected AS password_protected_94, l7_.store_password AS store_password_95, l7_.fb_pixel AS fb_pixel_96, l7_.fb_token AS fb_token_97, l7_.is_comments AS is_comments_98, l7_.send_comment_request_days AS send_comment_request_days_99, l7_.store_email AS store_email_100, l7_.admin_store_email AS admin_store_email_101, l7_.complaint_email AS complaint_email_102, l7_.product_return_email AS product_return_email_103, l7_.getresponse_campaign_id AS getresponse_campaign_id_104, l7_.created_at AS created_at_105, l7_.updated_at AS updated_at_106, l7_.created_by AS created_by_107, l7_.updated_by AS updated_by_108, l7_.deleted_by AS deleted_by_109, c5_.id AS id_110, c5_.sign AS sign_111, c5_.currency_separator AS currency_separator_112, c5_.position_price AS position_price_113, c5_.is_default AS is_default_114, c5_.is_active AS is_active_115, c5_.factorPln AS factorPln_116, c5_.iso_code AS iso_code_117, c5_.created_at AS created_at_118, c5_.updated_at AS updated_at_119, c5_.created_by AS created_by_120, c5_.updated_by AS updated_by_121, c5_.deleted_by AS deleted_by_122, a8_.id AS id_123, a8_.is_visible AS is_visible_124, a8_.is_currentyly_unavailable AS is_currentyly_unavailable_125, a8_.days AS days_126, a8_.ceneo_days AS ceneo_days_127, a8_.internal_name AS internal_name_128, a8_.created_at AS created_at_129, a8_.updated_at AS updated_at_130, a8_.created_by AS created_by_131, a8_.updated_by AS updated_by_132, a8_.deleted_by AS deleted_by_133, a9_.id AS id_134, a9_.name AS name_135, a9_.locale AS locale_136, p10_.id AS id_137, p10_.name AS name_138, p10_.responsible_entity AS responsible_entity_139, p10_.image_name AS image_name_140, p10_.created_at AS created_at_141, p10_.updated_at AS updated_at_142, p10_.created_by AS created_by_143, p10_.updated_by AS updated_by_144, p10_.deleted_by AS deleted_by_145, p3_.id AS id_146, p3_.main AS main_147, p3_.lifestyle AS lifestyle_148, p3_.hover AS hover_149, p3_.name AS name_150, p3_.image_name AS image_name_151, p3_.position AS position_152, p3_.alt AS alt_153, p3_.image_custom_name AS image_custom_name_154, l11_.id AS id_155, l11_.locale AS locale_156, l11_.domain AS domain_157, l11_.is_active AS is_active_158, l11_.is_default AS is_default_159, l11_.helpline AS helpline_160, l11_.rounding_precision AS rounding_precision_161, l11_.phone AS phone_162, l11_.address AS address_163, l11_.shop_name AS shop_name_164, l11_.email AS email_165, l11_.facebook AS facebook_166, l11_.instagram AS instagram_167, l11_.youtube AS youtube_168, l11_.store_url AS store_url_169, l11_.password_protected AS password_protected_170, l11_.store_password AS store_password_171, l11_.fb_pixel AS fb_pixel_172, l11_.fb_token AS fb_token_173, l11_.is_comments AS is_comments_174, l11_.send_comment_request_days AS send_comment_request_days_175, l11_.store_email AS store_email_176, l11_.admin_store_email AS admin_store_email_177, l11_.complaint_email AS complaint_email_178, l11_.product_return_email AS product_return_email_179, l11_.getresponse_campaign_id AS getresponse_campaign_id_180, l11_.created_at AS created_at_181, l11_.updated_at AS updated_at_182, l11_.created_by AS created_by_183, l11_.updated_by AS updated_by_184, l11_.deleted_by AS deleted_by_185, p12_.id AS id_186, p12_.price AS price_187, p12_.discount AS discount_188, p12_.old_price AS old_price_189, p12_.active AS active_190, p12_.automatic_price_comment AS automatic_price_comment_191, p12_.ean AS ean_192, p12_.automatic_price AS automatic_price_193, p12_.automatic_price_discount AS automatic_price_discount_194, p12_.created_at AS created_at_195, p12_.updated_at AS updated_at_196, p12_.created_by AS created_by_197, p12_.updated_by AS updated_by_198, p12_.deleted_by AS deleted_by_199 FROM product p0_ INNER JOIN product_translation p6_ ON p0_.id = p6_.translatable_id INNER JOIN product_lang_param p1_ ON p0_.id = p1_.product_id INNER JOIN language l7_ ON p1_.language = l7_.id INNER JOIN product_vat p4_ ON p1_.vat_id = p4_.id INNER JOIN currency c5_ ON l7_.currency_id = c5_.id INNER JOIN availability a8_ ON p1_.availability_id = a8_.id INNER JOIN availability_translation a9_ ON a8_.id = a9_.translatable_id INNER JOIN product_producer p10_ ON p1_.product_producer_id = p10_.id INNER JOIN product_photo p3_ ON p0_.id = p3_.product_id LEFT JOIN product_photo p2_ ON p0_.id = p2_.product_id AND (p2_.lifestyle = 1) INNER JOIN product_photo_language p13_ ON p3_.id = p13_.product_photo_id INNER JOIN language l11_ ON l11_.id = p13_.language_id LEFT JOIN product_price p12_ ON p0_.id = p12_.product_id LEFT JOIN language l14_ ON p12_.language = l14_.id INNER JOIN product_category p15_ ON p0_.id = p15_.product_id LEFT JOIN category c16_ ON p0_.main_category_id = c16_.id LEFT JOIN product_product_color p18_ ON p0_.id = p18_.product_id LEFT JOIN product_color p17_ ON p17_.id = p18_.product_color_id WHERE p6_.locale = ? AND a9_.locale = ? AND l14_.locale = ? AND a8_.deleted_by IS NULL AND (p3_.main = ?) AND l11_.locale = ? AND l7_.locale = ? AND p12_.deleted_by IS NULL AND p0_.deleted_by IS NULL AND p1_.visible = ? AND p15_.category_id = ? AND c16_.deleted_by IS NULL GROUP BY p0_.id ORDER BY p15_.position ASC, p3_.position ASC) dctrn_table
[ "pl" "pl" "pl" true "pl" "pl" true 324 ] |
|
doctrine |
SELECT DISTINCT id_12 FROM (SELECT DISTINCT id_12, position_202 FROM (SELECT p0_.listingMarkersIds AS listingMarkersIds_0, p1_.promotion_icon AS promotion_icon_1, p1_.is_new AS is_new_2, p2_.image_name AS image_name_3, p3_.image_name AS image_name_4, p1_.bestseller AS bestseller_5, p4_.id AS id_6, c5_.sign AS sign_7, c5_.id AS id_8, p1_.price_description AS price_description_9, p1_.price_crossed AS price_crossed_10, p1_.omnibus_price AS omnibus_price_11, p0_.id AS id_12, p0_.symbol AS symbol_13, p0_.photo3d AS photo3d_14, p0_.is_variants AS is_variants_15, p0_.is_palette_delivery AS is_palette_delivery_16, p0_.payu AS payu_17, p0_.automatic_price AS automatic_price_18, p0_.halmar_stock_exchange AS halmar_stock_exchange_19, p0_.diablo_stock_exchange AS diablo_stock_exchange_20, p0_.jan_nowak_stock_exchange AS jan_nowak_stock_exchange_21, p0_.actona_stock_exchange AS actona_stock_exchange_22, p0_.unique_stock_exchange AS unique_stock_exchange_23, p0_.is_compare AS is_compare_24, p0_.priority_search_engine AS priority_search_engine_25, p0_.is_negotiate AS is_negotiate_26, p0_.is_rebate_code AS is_rebate_code_27, p0_.old_price AS old_price_28, p0_.film AS film_29, p0_.small_product_photo AS small_product_photo_30, p0_.max_quantity AS max_quantity_31, p0_.listingMarkersIds AS listingMarkersIds_32, p0_.temporary_unavailable AS temporary_unavailable_33, p0_.last_ranking_update AS last_ranking_update_34, p0_.height AS height_35, p0_.width AS width_36, p0_.depth AS depth_37, p0_.shipping_category AS shipping_category_38, p0_.created_at AS created_at_39, p0_.updated_at AS updated_at_40, p0_.created_by AS created_by_41, p0_.updated_by AS updated_by_42, p0_.deleted_by AS deleted_by_43, p6_.id AS id_44, p6_.name AS name_45, p6_.description AS description_46, p6_.meta_title AS meta_title_47, p6_.meta_description AS meta_description_48, p6_.meta_keywords AS meta_keywords_49, p6_.slug AS slug_50, p6_.short_description AS short_description_51, p6_.short_description_textile AS short_description_textile_52, p6_.short_description_color AS short_description_color_53, p6_.short_function_description AS short_function_description_54, p6_.search_engine AS search_engine_55, p6_.photo3d_gallery_url AS photo3d_gallery_url_56, p6_.youtube_gallery_url AS youtube_gallery_url_57, p6_.trans_film AS trans_film_58, p6_.canonical AS canonical_59, p6_.photo3d_additional AS photo3d_additional_60, p6_.locale AS locale_61, p1_.id AS id_62, p1_.visible AS visible_63, p1_.price_description AS price_description_64, p1_.promotion AS promotion_65, p1_.is_new AS is_new_66, p1_.bestseller AS bestseller_67, p1_.promote_one_homepage AS promote_one_homepage_68, p1_.ready_for_publication AS ready_for_publication_69, p1_.sale AS sale_70, p1_.rating_value AS rating_value_71, p1_.review_count AS review_count_72, p1_.price_change AS price_change_73, p1_.priority AS priority_74, p1_.price_crossed AS price_crossed_75, p1_.omnibus_price AS omnibus_price_76, p1_.promotion_icon AS promotion_icon_77, p1_.promo_price AS promo_price_78, l7_.id AS id_79, l7_.locale AS locale_80, l7_.domain AS domain_81, l7_.is_active AS is_active_82, l7_.is_default AS is_default_83, l7_.helpline AS helpline_84, l7_.rounding_precision AS rounding_precision_85, l7_.phone AS phone_86, l7_.address AS address_87, l7_.shop_name AS shop_name_88, l7_.email AS email_89, l7_.facebook AS facebook_90, l7_.instagram AS instagram_91, l7_.youtube AS youtube_92, l7_.store_url AS store_url_93, l7_.password_protected AS password_protected_94, l7_.store_password AS store_password_95, l7_.fb_pixel AS fb_pixel_96, l7_.fb_token AS fb_token_97, l7_.is_comments AS is_comments_98, l7_.send_comment_request_days AS send_comment_request_days_99, l7_.store_email AS store_email_100, l7_.admin_store_email AS admin_store_email_101, l7_.complaint_email AS complaint_email_102, l7_.product_return_email AS product_return_email_103, l7_.getresponse_campaign_id AS getresponse_campaign_id_104, l7_.created_at AS created_at_105, l7_.updated_at AS updated_at_106, l7_.created_by AS created_by_107, l7_.updated_by AS updated_by_108, l7_.deleted_by AS deleted_by_109, c5_.id AS id_110, c5_.sign AS sign_111, c5_.currency_separator AS currency_separator_112, c5_.position_price AS position_price_113, c5_.is_default AS is_default_114, c5_.is_active AS is_active_115, c5_.factorPln AS factorPln_116, c5_.iso_code AS iso_code_117, c5_.created_at AS created_at_118, c5_.updated_at AS updated_at_119, c5_.created_by AS created_by_120, c5_.updated_by AS updated_by_121, c5_.deleted_by AS deleted_by_122, a8_.id AS id_123, a8_.is_visible AS is_visible_124, a8_.is_currentyly_unavailable AS is_currentyly_unavailable_125, a8_.days AS days_126, a8_.ceneo_days AS ceneo_days_127, a8_.internal_name AS internal_name_128, a8_.created_at AS created_at_129, a8_.updated_at AS updated_at_130, a8_.created_by AS created_by_131, a8_.updated_by AS updated_by_132, a8_.deleted_by AS deleted_by_133, a9_.id AS id_134, a9_.name AS name_135, a9_.locale AS locale_136, p10_.id AS id_137, p10_.name AS name_138, p10_.responsible_entity AS responsible_entity_139, p10_.image_name AS image_name_140, p10_.created_at AS created_at_141, p10_.updated_at AS updated_at_142, p10_.created_by AS created_by_143, p10_.updated_by AS updated_by_144, p10_.deleted_by AS deleted_by_145, p3_.id AS id_146, p3_.main AS main_147, p3_.lifestyle AS lifestyle_148, p3_.hover AS hover_149, p3_.name AS name_150, p3_.image_name AS image_name_151, p3_.position AS position_152, p3_.alt AS alt_153, p3_.image_custom_name AS image_custom_name_154, l11_.id AS id_155, l11_.locale AS locale_156, l11_.domain AS domain_157, l11_.is_active AS is_active_158, l11_.is_default AS is_default_159, l11_.helpline AS helpline_160, l11_.rounding_precision AS rounding_precision_161, l11_.phone AS phone_162, l11_.address AS address_163, l11_.shop_name AS shop_name_164, l11_.email AS email_165, l11_.facebook AS facebook_166, l11_.instagram AS instagram_167, l11_.youtube AS youtube_168, l11_.store_url AS store_url_169, l11_.password_protected AS password_protected_170, l11_.store_password AS store_password_171, l11_.fb_pixel AS fb_pixel_172, l11_.fb_token AS fb_token_173, l11_.is_comments AS is_comments_174, l11_.send_comment_request_days AS send_comment_request_days_175, l11_.store_email AS store_email_176, l11_.admin_store_email AS admin_store_email_177, l11_.complaint_email AS complaint_email_178, l11_.product_return_email AS product_return_email_179, l11_.getresponse_campaign_id AS getresponse_campaign_id_180, l11_.created_at AS created_at_181, l11_.updated_at AS updated_at_182, l11_.created_by AS created_by_183, l11_.updated_by AS updated_by_184, l11_.deleted_by AS deleted_by_185, p12_.id AS id_186, p12_.price AS price_187, p12_.discount AS discount_188, p12_.old_price AS old_price_189, p12_.active AS active_190, p12_.automatic_price_comment AS automatic_price_comment_191, p12_.ean AS ean_192, p12_.automatic_price AS automatic_price_193, p12_.automatic_price_discount AS automatic_price_discount_194, p12_.created_at AS created_at_195, p12_.updated_at AS updated_at_196, p12_.created_by AS created_by_197, p12_.updated_by AS updated_by_198, p12_.deleted_by AS deleted_by_199, p2_.lifestyle AS lifestyle_200, l13_.locale AS locale_201, p14_.position AS position_202, c15_.deleted_by AS deleted_by_203 FROM product p0_ INNER JOIN product_translation p6_ ON p0_.id = p6_.translatable_id INNER JOIN product_lang_param p1_ ON p0_.id = p1_.product_id INNER JOIN language l7_ ON p1_.language = l7_.id INNER JOIN product_vat p4_ ON p1_.vat_id = p4_.id INNER JOIN currency c5_ ON l7_.currency_id = c5_.id INNER JOIN availability a8_ ON p1_.availability_id = a8_.id INNER JOIN availability_translation a9_ ON a8_.id = a9_.translatable_id INNER JOIN product_producer p10_ ON p1_.product_producer_id = p10_.id INNER JOIN product_photo p3_ ON p0_.id = p3_.product_id LEFT JOIN product_photo p2_ ON p0_.id = p2_.product_id AND (p2_.lifestyle = 1) INNER JOIN product_photo_language p16_ ON p3_.id = p16_.product_photo_id INNER JOIN language l11_ ON l11_.id = p16_.language_id LEFT JOIN product_price p12_ ON p0_.id = p12_.product_id LEFT JOIN language l13_ ON p12_.language = l13_.id INNER JOIN product_category p14_ ON p0_.id = p14_.product_id LEFT JOIN category c15_ ON p0_.main_category_id = c15_.id LEFT JOIN product_product_color p18_ ON p0_.id = p18_.product_id LEFT JOIN product_color p17_ ON p17_.id = p18_.product_color_id WHERE p6_.locale = ? AND a9_.locale = ? AND l13_.locale = ? AND a8_.deleted_by IS NULL AND (p3_.main = ?) AND l11_.locale = ? AND l7_.locale = ? AND p12_.deleted_by IS NULL AND p0_.deleted_by IS NULL AND p1_.visible = ? AND p14_.category_id = ? AND c15_.deleted_by IS NULL GROUP BY p0_.id ORDER BY p3_.position ASC, p2_.position ASC) dctrn_result_inner ORDER BY position_202 ASC) dctrn_result LIMIT 30
[ "pl" "pl" "pl" true "pl" "pl" true 324 ] |
|
doctrine |
SELECT p0_.listingMarkersIds AS listingMarkersIds_0, p1_.promotion_icon AS promotion_icon_1, p1_.is_new AS is_new_2, p2_.image_name AS image_name_3, p3_.image_name AS image_name_4, p1_.bestseller AS bestseller_5, p4_.id AS id_6, c5_.sign AS sign_7, c5_.id AS id_8, p1_.price_description AS price_description_9, p1_.price_crossed AS price_crossed_10, p1_.omnibus_price AS omnibus_price_11, p0_.id AS id_12, p0_.symbol AS symbol_13, p0_.photo3d AS photo3d_14, p0_.is_variants AS is_variants_15, p0_.is_palette_delivery AS is_palette_delivery_16, p0_.payu AS payu_17, p0_.automatic_price AS automatic_price_18, p0_.halmar_stock_exchange AS halmar_stock_exchange_19, p0_.diablo_stock_exchange AS diablo_stock_exchange_20, p0_.jan_nowak_stock_exchange AS jan_nowak_stock_exchange_21, p0_.actona_stock_exchange AS actona_stock_exchange_22, p0_.unique_stock_exchange AS unique_stock_exchange_23, p0_.is_compare AS is_compare_24, p0_.priority_search_engine AS priority_search_engine_25, p0_.is_negotiate AS is_negotiate_26, p0_.is_rebate_code AS is_rebate_code_27, p0_.old_price AS old_price_28, p0_.film AS film_29, p0_.small_product_photo AS small_product_photo_30, p0_.max_quantity AS max_quantity_31, p0_.listingMarkersIds AS listingMarkersIds_32, p0_.temporary_unavailable AS temporary_unavailable_33, p0_.last_ranking_update AS last_ranking_update_34, p0_.height AS height_35, p0_.width AS width_36, p0_.depth AS depth_37, p0_.shipping_category AS shipping_category_38, p0_.created_at AS created_at_39, p0_.updated_at AS updated_at_40, p0_.created_by AS created_by_41, p0_.updated_by AS updated_by_42, p0_.deleted_by AS deleted_by_43, p6_.id AS id_44, p6_.name AS name_45, p6_.description AS description_46, p6_.meta_title AS meta_title_47, p6_.meta_description AS meta_description_48, p6_.meta_keywords AS meta_keywords_49, p6_.slug AS slug_50, p6_.short_description AS short_description_51, p6_.short_description_textile AS short_description_textile_52, p6_.short_description_color AS short_description_color_53, p6_.short_function_description AS short_function_description_54, p6_.search_engine AS search_engine_55, p6_.photo3d_gallery_url AS photo3d_gallery_url_56, p6_.youtube_gallery_url AS youtube_gallery_url_57, p6_.trans_film AS trans_film_58, p6_.canonical AS canonical_59, p6_.photo3d_additional AS photo3d_additional_60, p6_.locale AS locale_61, p1_.id AS id_62, p1_.visible AS visible_63, p1_.price_description AS price_description_64, p1_.promotion AS promotion_65, p1_.is_new AS is_new_66, p1_.bestseller AS bestseller_67, p1_.promote_one_homepage AS promote_one_homepage_68, p1_.ready_for_publication AS ready_for_publication_69, p1_.sale AS sale_70, p1_.rating_value AS rating_value_71, p1_.review_count AS review_count_72, p1_.price_change AS price_change_73, p1_.priority AS priority_74, p1_.price_crossed AS price_crossed_75, p1_.omnibus_price AS omnibus_price_76, p1_.promotion_icon AS promotion_icon_77, p1_.promo_price AS promo_price_78, l7_.id AS id_79, l7_.locale AS locale_80, l7_.domain AS domain_81, l7_.is_active AS is_active_82, l7_.is_default AS is_default_83, l7_.helpline AS helpline_84, l7_.rounding_precision AS rounding_precision_85, l7_.phone AS phone_86, l7_.address AS address_87, l7_.shop_name AS shop_name_88, l7_.email AS email_89, l7_.facebook AS facebook_90, l7_.instagram AS instagram_91, l7_.youtube AS youtube_92, l7_.store_url AS store_url_93, l7_.password_protected AS password_protected_94, l7_.store_password AS store_password_95, l7_.fb_pixel AS fb_pixel_96, l7_.fb_token AS fb_token_97, l7_.is_comments AS is_comments_98, l7_.send_comment_request_days AS send_comment_request_days_99, l7_.store_email AS store_email_100, l7_.admin_store_email AS admin_store_email_101, l7_.complaint_email AS complaint_email_102, l7_.product_return_email AS product_return_email_103, l7_.getresponse_campaign_id AS getresponse_campaign_id_104, l7_.created_at AS created_at_105, l7_.updated_at AS updated_at_106, l7_.created_by AS created_by_107, l7_.updated_by AS updated_by_108, l7_.deleted_by AS deleted_by_109, c5_.id AS id_110, c5_.sign AS sign_111, c5_.currency_separator AS currency_separator_112, c5_.position_price AS position_price_113, c5_.is_default AS is_default_114, c5_.is_active AS is_active_115, c5_.factorPln AS factorPln_116, c5_.iso_code AS iso_code_117, c5_.created_at AS created_at_118, c5_.updated_at AS updated_at_119, c5_.created_by AS created_by_120, c5_.updated_by AS updated_by_121, c5_.deleted_by AS deleted_by_122, a8_.id AS id_123, a8_.is_visible AS is_visible_124, a8_.is_currentyly_unavailable AS is_currentyly_unavailable_125, a8_.days AS days_126, a8_.ceneo_days AS ceneo_days_127, a8_.internal_name AS internal_name_128, a8_.created_at AS created_at_129, a8_.updated_at AS updated_at_130, a8_.created_by AS created_by_131, a8_.updated_by AS updated_by_132, a8_.deleted_by AS deleted_by_133, a9_.id AS id_134, a9_.name AS name_135, a9_.locale AS locale_136, p10_.id AS id_137, p10_.name AS name_138, p10_.responsible_entity AS responsible_entity_139, p10_.image_name AS image_name_140, p10_.created_at AS created_at_141, p10_.updated_at AS updated_at_142, p10_.created_by AS created_by_143, p10_.updated_by AS updated_by_144, p10_.deleted_by AS deleted_by_145, p3_.id AS id_146, p3_.main AS main_147, p3_.lifestyle AS lifestyle_148, p3_.hover AS hover_149, p3_.name AS name_150, p3_.image_name AS image_name_151, p3_.position AS position_152, p3_.alt AS alt_153, p3_.image_custom_name AS image_custom_name_154, l11_.id AS id_155, l11_.locale AS locale_156, l11_.domain AS domain_157, l11_.is_active AS is_active_158, l11_.is_default AS is_default_159, l11_.helpline AS helpline_160, l11_.rounding_precision AS rounding_precision_161, l11_.phone AS phone_162, l11_.address AS address_163, l11_.shop_name AS shop_name_164, l11_.email AS email_165, l11_.facebook AS facebook_166, l11_.instagram AS instagram_167, l11_.youtube AS youtube_168, l11_.store_url AS store_url_169, l11_.password_protected AS password_protected_170, l11_.store_password AS store_password_171, l11_.fb_pixel AS fb_pixel_172, l11_.fb_token AS fb_token_173, l11_.is_comments AS is_comments_174, l11_.send_comment_request_days AS send_comment_request_days_175, l11_.store_email AS store_email_176, l11_.admin_store_email AS admin_store_email_177, l11_.complaint_email AS complaint_email_178, l11_.product_return_email AS product_return_email_179, l11_.getresponse_campaign_id AS getresponse_campaign_id_180, l11_.created_at AS created_at_181, l11_.updated_at AS updated_at_182, l11_.created_by AS created_by_183, l11_.updated_by AS updated_by_184, l11_.deleted_by AS deleted_by_185, p12_.id AS id_186, p12_.price AS price_187, p12_.discount AS discount_188, p12_.old_price AS old_price_189, p12_.active AS active_190, p12_.automatic_price_comment AS automatic_price_comment_191, p12_.ean AS ean_192, p12_.automatic_price AS automatic_price_193, p12_.automatic_price_discount AS automatic_price_discount_194, p12_.created_at AS created_at_195, p12_.updated_at AS updated_at_196, p12_.created_by AS created_by_197, p12_.updated_by AS updated_by_198, p12_.deleted_by AS deleted_by_199, p0_.product_family_id AS product_family_id_200, p0_.product_producer_id AS product_producer_id_201, p0_.availability_id AS availability_id_202, p0_.main_category_id AS main_category_id_203, p6_.translatable_id AS translatable_id_204, p1_.product_id AS product_id_205, p1_.language AS language_206, p1_.vat_id AS vat_id_207, p1_.availability_id AS availability_id_208, p1_.product_producer_id AS product_producer_id_209, l7_.currency_id AS currency_id_210, a9_.translatable_id AS translatable_id_211, p3_.product_id AS product_id_212, l11_.currency_id AS currency_id_213, p12_.product_id AS product_id_214, p12_.parent_product_price_id AS parent_product_price_id_215, p12_.currency_id AS currency_id_216, p12_.language AS language_217 FROM product p0_ INNER JOIN product_translation p6_ ON p0_.id = p6_.translatable_id INNER JOIN product_lang_param p1_ ON p0_.id = p1_.product_id INNER JOIN language l7_ ON p1_.language = l7_.id INNER JOIN product_vat p4_ ON p1_.vat_id = p4_.id INNER JOIN currency c5_ ON l7_.currency_id = c5_.id INNER JOIN availability a8_ ON p1_.availability_id = a8_.id INNER JOIN availability_translation a9_ ON a8_.id = a9_.translatable_id INNER JOIN product_producer p10_ ON p1_.product_producer_id = p10_.id INNER JOIN product_photo p3_ ON p0_.id = p3_.product_id LEFT JOIN product_photo p2_ ON p0_.id = p2_.product_id AND (p2_.lifestyle = 1) INNER JOIN product_photo_language p13_ ON p3_.id = p13_.product_photo_id INNER JOIN language l11_ ON l11_.id = p13_.language_id LEFT JOIN product_price p12_ ON p0_.id = p12_.product_id LEFT JOIN language l14_ ON p12_.language = l14_.id INNER JOIN product_category p15_ ON p0_.id = p15_.product_id LEFT JOIN category c16_ ON p0_.main_category_id = c16_.id LEFT JOIN product_product_color p18_ ON p0_.id = p18_.product_id LEFT JOIN product_color p17_ ON p17_.id = p18_.product_color_id WHERE p6_.locale = ? AND a9_.locale = ? AND l14_.locale = ? AND a8_.deleted_by IS NULL AND (p3_.main = ?) AND l11_.locale = ? AND l7_.locale = ? AND p12_.deleted_by IS NULL AND p0_.deleted_by IS NULL AND p1_.visible = ? AND p15_.category_id = ? AND c16_.deleted_by IS NULL AND p0_.id IN (?) GROUP BY p0_.id ORDER BY p15_.position ASC, p3_.position ASC
[ "pl" "pl" "pl" true "pl" "pl" true 324 [ 8028 8033 ] ] |
|
event |
Notified event "knp_pager.items" to listener "Knp\Component\Pager\Event\Subscriber\Paginate\Doctrine\ORM\QueryBuilderSubscriber::items" .
[ "event" => "knp_pager.items" "listener" => "Knp\Component\Pager\Event\Subscriber\Paginate\Doctrine\ORM\QueryBuilderSubscriber::items" ] |
|
event |
Notified event "knp_pager.items" to listener "Knp\Component\Pager\Event\Subscriber\Paginate\Doctrine\ODM\MongoDB\QueryBuilderSubscriber::items" .
[ "event" => "knp_pager.items" "listener" => "Knp\Component\Pager\Event\Subscriber\Paginate\Doctrine\ODM\MongoDB\QueryBuilderSubscriber::items" ] |
|
event |
Notified event "knp_pager.items" to listener "Knp\Component\Pager\Event\Subscriber\Paginate\Doctrine\ODM\PHPCR\QueryBuilderSubscriber::items" .
[ "event" => "knp_pager.items" "listener" => "Knp\Component\Pager\Event\Subscriber\Paginate\Doctrine\ODM\PHPCR\QueryBuilderSubscriber::items" ] |
|
event |
Notified event "knp_pager.items" to listener "Knp\Component\Pager\Event\Subscriber\Paginate\Doctrine\DBALQueryBuilderSubscriber::items" .
[ "event" => "knp_pager.items" "listener" => "Knp\Component\Pager\Event\Subscriber\Paginate\Doctrine\DBALQueryBuilderSubscriber::items" ] |
|
event |
Notified event "knp_pager.items" to listener "Knp\Component\Pager\Event\Subscriber\Sortable\Doctrine\ORM\QuerySubscriber::items" .
[ "event" => "knp_pager.items" "listener" => "Knp\Component\Pager\Event\Subscriber\Sortable\Doctrine\ORM\QuerySubscriber::items" ] |
|
event |
Notified event "knp_pager.items" to listener "Knp\Component\Pager\Event\Subscriber\Sortable\Doctrine\ODM\MongoDB\QuerySubscriber::items" .
[ "event" => "knp_pager.items" "listener" => "Knp\Component\Pager\Event\Subscriber\Sortable\Doctrine\ODM\MongoDB\QuerySubscriber::items" ] |
|
event |
Notified event "knp_pager.items" to listener "Knp\Component\Pager\Event\Subscriber\Sortable\ElasticaQuerySubscriber::items" .
[ "event" => "knp_pager.items" "listener" => "Knp\Component\Pager\Event\Subscriber\Sortable\ElasticaQuerySubscriber::items" ] |
|
event |
Notified event "knp_pager.items" to listener "Knp\Component\Pager\Event\Subscriber\Sortable\PropelQuerySubscriber::items" .
[ "event" => "knp_pager.items" "listener" => "Knp\Component\Pager\Event\Subscriber\Sortable\PropelQuerySubscriber::items" ] |
|
event |
Notified event "knp_pager.items" to listener "Knp\Component\Pager\Event\Subscriber\Sortable\SolariumQuerySubscriber::items" .
[ "event" => "knp_pager.items" "listener" => "Knp\Component\Pager\Event\Subscriber\Sortable\SolariumQuerySubscriber::items" ] |
|
event |
Notified event "knp_pager.items" to listener "Knp\Component\Pager\Event\Subscriber\Sortable\ArraySubscriber::items" .
[ "event" => "knp_pager.items" "listener" => "Knp\Component\Pager\Event\Subscriber\Sortable\ArraySubscriber::items" ] |
|
event |
Notified event "knp_pager.items" to listener "Knp\Component\Pager\Event\Subscriber\Filtration\Doctrine\ORM\QuerySubscriber::items" .
[ "event" => "knp_pager.items" "listener" => "Knp\Component\Pager\Event\Subscriber\Filtration\Doctrine\ORM\QuerySubscriber::items" ] |
|
event |
Notified event "knp_pager.items" to listener "Knp\Component\Pager\Event\Subscriber\Filtration\PropelQuerySubscriber::items" .
[ "event" => "knp_pager.items" "listener" => "Knp\Component\Pager\Event\Subscriber\Filtration\PropelQuerySubscriber::items" ] |
|
event |
Notified event "knp_pager.items" to listener "Knp\Component\Pager\Event\Subscriber\Paginate\Doctrine\ORM\QuerySubscriber\UsesPaginator::items" .
[ "event" => "knp_pager.items" "listener" => "Knp\Component\Pager\Event\Subscriber\Paginate\Doctrine\ORM\QuerySubscriber\UsesPaginator::items" ] |
|
event |
Listener "Knp\Component\Pager\Event\Subscriber\Paginate\Doctrine\ORM\QuerySubscriber\UsesPaginator::items" stopped propagation of the event "knp_pager.items" .
[ "event" => "knp_pager.items" "listener" => "Knp\Component\Pager\Event\Subscriber\Paginate\Doctrine\ORM\QuerySubscriber\UsesPaginator::items" ] |
|
event |
Listener "Knp\Component\Pager\Event\Subscriber\Paginate\Doctrine\ORM\QuerySubscriber::items" was not called for event "knp_pager.items" .
[ "event" => "knp_pager.items" "listener" => "Knp\Component\Pager\Event\Subscriber\Paginate\Doctrine\ORM\QuerySubscriber::items" ] |
|
event |
Listener "Knp\Component\Pager\Event\Subscriber\Paginate\Doctrine\ODM\MongoDB\QuerySubscriber::items" was not called for event "knp_pager.items" .
[ "event" => "knp_pager.items" "listener" => "Knp\Component\Pager\Event\Subscriber\Paginate\Doctrine\ODM\MongoDB\QuerySubscriber::items" ] |
|
event |
Listener "Knp\Component\Pager\Event\Subscriber\Paginate\Doctrine\ODM\PHPCR\QuerySubscriber::items" was not called for event "knp_pager.items" .
[ "event" => "knp_pager.items" "listener" => "Knp\Component\Pager\Event\Subscriber\Paginate\Doctrine\ODM\PHPCR\QuerySubscriber::items" ] |
|
event |
Listener "Knp\Component\Pager\Event\Subscriber\Paginate\Doctrine\CollectionSubscriber::items" was not called for event "knp_pager.items" .
[ "event" => "knp_pager.items" "listener" => "Knp\Component\Pager\Event\Subscriber\Paginate\Doctrine\CollectionSubscriber::items" ] |
|
event |
Listener "Knp\Component\Pager\Event\Subscriber\Paginate\PropelQuerySubscriber::items" was not called for event "knp_pager.items" .
[ "event" => "knp_pager.items" "listener" => "Knp\Component\Pager\Event\Subscriber\Paginate\PropelQuerySubscriber::items" ] |
|
event |
Listener "Knp\Component\Pager\Event\Subscriber\Paginate\SolariumQuerySubscriber::items" was not called for event "knp_pager.items" .
[ "event" => "knp_pager.items" "listener" => "Knp\Component\Pager\Event\Subscriber\Paginate\SolariumQuerySubscriber::items" ] |
|
event |
Listener "Knp\Component\Pager\Event\Subscriber\Paginate\ElasticaQuerySubscriber::items" was not called for event "knp_pager.items" .
[ "event" => "knp_pager.items" "listener" => "Knp\Component\Pager\Event\Subscriber\Paginate\ElasticaQuerySubscriber::items" ] |
|
event |
Listener "Knp\Component\Pager\Event\Subscriber\Paginate\ArraySubscriber::items" was not called for event "knp_pager.items" .
[ "event" => "knp_pager.items" "listener" => "Knp\Component\Pager\Event\Subscriber\Paginate\ArraySubscriber::items" ] |
|
event |
Notified event "knp_pager.pagination" to listener "Knp\Bundle\PaginatorBundle\Subscriber\SlidingPaginationSubscriber::pagination" .
[ "event" => "knp_pager.pagination" "listener" => "Knp\Bundle\PaginatorBundle\Subscriber\SlidingPaginationSubscriber::pagination" ] |
|
event |
Listener "Knp\Bundle\PaginatorBundle\Subscriber\SlidingPaginationSubscriber::pagination" stopped propagation of the event "knp_pager.pagination" .
[ "event" => "knp_pager.pagination" "listener" => "Knp\Bundle\PaginatorBundle\Subscriber\SlidingPaginationSubscriber::pagination" ] |
|
event |
Listener "Knp\Component\Pager\Event\Subscriber\Paginate\PaginationSubscriber::pagination" was not called for event "knp_pager.pagination" .
[ "event" => "knp_pager.pagination" "listener" => "Knp\Component\Pager\Event\Subscriber\Paginate\PaginationSubscriber::pagination" ] |
|
doctrine |
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.domain AS domain_3, t0.is_active AS is_active_4, t0.is_default AS is_default_5, t0.helpline AS helpline_6, t0.rounding_precision AS rounding_precision_7, t0.phone AS phone_8, t0.address AS address_9, t0.shop_name AS shop_name_10, t0.email AS email_11, t0.facebook AS facebook_12, t0.instagram AS instagram_13, t0.youtube AS youtube_14, t0.store_url AS store_url_15, t0.password_protected AS password_protected_16, t0.store_password AS store_password_17, t0.fb_pixel AS fb_pixel_18, t0.fb_token AS fb_token_19, t0.is_comments AS is_comments_20, t0.send_comment_request_days AS send_comment_request_days_21, t0.store_email AS store_email_22, t0.admin_store_email AS admin_store_email_23, t0.complaint_email AS complaint_email_24, t0.product_return_email AS product_return_email_25, t0.getresponse_campaign_id AS getresponse_campaign_id_26, t0.created_at AS created_at_27, t0.updated_at AS updated_at_28, t0.created_by AS created_by_29, t0.updated_by AS updated_by_30, t0.deleted_by AS deleted_by_31, t0.currency_id AS currency_id_32 FROM language t0 WHERE t0.deleted_by IS NULL AND t0.locale = ? LIMIT 1
[
"pl"
]
|
|
doctrine | SELECT t0.id AS id_1, t0.session AS session_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.product_id AS product_id_5 FROM compare_product t0 WHERE t0.session IS NULL | |
doctrine |
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.responsible_entity AS responsible_entity_2, p0_.image_name AS image_name_3, p0_.created_at AS created_at_4, p0_.updated_at AS updated_at_5, p0_.created_by AS created_by_6, p0_.updated_by AS updated_by_7, p0_.deleted_by AS deleted_by_8 FROM product_producer p0_ INNER JOIN product_producer_languages p2_ ON p0_.id = p2_.product_producer_id INNER JOIN language l1_ ON l1_.id = p2_.language_id WHERE p0_.deleted_by IS NULL AND p0_.id IN (?) AND l1_.locale = ?
[ [ 80 ] "pl" ] |
|
doctrine |
SELECT t0.id AS id_1, t0.level AS level_2, t0.position AS position_3, t0.alt AS alt_4, t0.image_custom_name AS image_custom_name_5, t0.image_name_2 AS image_name_2_6, t0.image_name_3 AS image_name_3_7, t0.image_name AS image_name_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.created_by AS created_by_11, t0.updated_by AS updated_by_12, t0.deleted_by AS deleted_by_13, t0.category_parent_id AS category_parent_id_14 FROM category t0 INNER JOIN category_parent_relation ON t0.id = category_parent_relation.category_id WHERE category_parent_relation.parent_id = ? ORDER BY t0.position ASC
[
119
]
|
|
doctrine |
SELECT t0.id AS id_1, t0.level AS level_2, t0.position AS position_3, t0.alt AS alt_4, t0.image_custom_name AS image_custom_name_5, t0.image_name_2 AS image_name_2_6, t0.image_name_3 AS image_name_3_7, t0.image_name AS image_name_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.created_by AS created_by_11, t0.updated_by AS updated_by_12, t0.deleted_by AS deleted_by_13, t0.category_parent_id AS category_parent_id_14 FROM category t0 INNER JOIN category_parent_relation ON t0.id = category_parent_relation.category_id WHERE category_parent_relation.parent_id = ? ORDER BY t0.position ASC
[
118
]
|
|
doctrine |
SELECT t0.id AS id_1, t0.level AS level_2, t0.position AS position_3, t0.alt AS alt_4, t0.image_custom_name AS image_custom_name_5, t0.image_name_2 AS image_name_2_6, t0.image_name_3 AS image_name_3_7, t0.image_name AS image_name_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.created_by AS created_by_11, t0.updated_by AS updated_by_12, t0.deleted_by AS deleted_by_13, t0.category_parent_id AS category_parent_id_14 FROM category t0 INNER JOIN category_parent_relation ON t0.id = category_parent_relation.category_id WHERE category_parent_relation.parent_id = ? ORDER BY t0.position ASC
[
122
]
|
|
doctrine |
SELECT t0.id AS id_1, t0.level AS level_2, t0.position AS position_3, t0.alt AS alt_4, t0.image_custom_name AS image_custom_name_5, t0.image_name_2 AS image_name_2_6, t0.image_name_3 AS image_name_3_7, t0.image_name AS image_name_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.created_by AS created_by_11, t0.updated_by AS updated_by_12, t0.deleted_by AS deleted_by_13, t0.category_parent_id AS category_parent_id_14 FROM category t0 INNER JOIN category_parent_relation ON t0.id = category_parent_relation.category_id WHERE category_parent_relation.parent_id = ? ORDER BY t0.position ASC
[
129
]
|
|
doctrine |
SELECT t0.id AS id_1, t0.level AS level_2, t0.position AS position_3, t0.alt AS alt_4, t0.image_custom_name AS image_custom_name_5, t0.image_name_2 AS image_name_2_6, t0.image_name_3 AS image_name_3_7, t0.image_name AS image_name_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.created_by AS created_by_11, t0.updated_by AS updated_by_12, t0.deleted_by AS deleted_by_13, t0.category_parent_id AS category_parent_id_14 FROM category t0 INNER JOIN category_parent_relation ON t0.id = category_parent_relation.category_id WHERE category_parent_relation.parent_id = ? ORDER BY t0.position ASC
[
123
]
|
|
doctrine |
SELECT t0.id AS id_1, t0.level AS level_2, t0.position AS position_3, t0.alt AS alt_4, t0.image_custom_name AS image_custom_name_5, t0.image_name_2 AS image_name_2_6, t0.image_name_3 AS image_name_3_7, t0.image_name AS image_name_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.created_by AS created_by_11, t0.updated_by AS updated_by_12, t0.deleted_by AS deleted_by_13, t0.category_parent_id AS category_parent_id_14 FROM category t0 INNER JOIN category_parent_relation ON t0.id = category_parent_relation.category_id WHERE category_parent_relation.parent_id = ? ORDER BY t0.position ASC
[
245
]
|
|
doctrine |
SELECT t0.id AS id_1, t0.level AS level_2, t0.position AS position_3, t0.alt AS alt_4, t0.image_custom_name AS image_custom_name_5, t0.image_name_2 AS image_name_2_6, t0.image_name_3 AS image_name_3_7, t0.image_name AS image_name_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.created_by AS created_by_11, t0.updated_by AS updated_by_12, t0.deleted_by AS deleted_by_13, t0.category_parent_id AS category_parent_id_14 FROM category t0 INNER JOIN category_parent_relation ON t0.id = category_parent_relation.category_id WHERE category_parent_relation.parent_id = ? ORDER BY t0.position ASC
[
133
]
|
|
doctrine |
SELECT t0.id AS id_1, t0.level AS level_2, t0.position AS position_3, t0.alt AS alt_4, t0.image_custom_name AS image_custom_name_5, t0.image_name_2 AS image_name_2_6, t0.image_name_3 AS image_name_3_7, t0.image_name AS image_name_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.created_by AS created_by_11, t0.updated_by AS updated_by_12, t0.deleted_by AS deleted_by_13, t0.category_parent_id AS category_parent_id_14 FROM category t0 INNER JOIN category_parent_relation ON t0.id = category_parent_relation.category_id WHERE category_parent_relation.parent_id = ? ORDER BY t0.position ASC
[
138
]
|
|
doctrine |
SELECT t0.id AS id_1, t0.level AS level_2, t0.position AS position_3, t0.alt AS alt_4, t0.image_custom_name AS image_custom_name_5, t0.image_name_2 AS image_name_2_6, t0.image_name_3 AS image_name_3_7, t0.image_name AS image_name_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.created_by AS created_by_11, t0.updated_by AS updated_by_12, t0.deleted_by AS deleted_by_13, t0.category_parent_id AS category_parent_id_14 FROM category t0 INNER JOIN category_parent_relation ON t0.id = category_parent_relation.category_id WHERE category_parent_relation.parent_id = ? ORDER BY t0.position ASC
[
287
]
|
|
doctrine |
SELECT t0.id AS id_1, t0.level AS level_2, t0.position AS position_3, t0.alt AS alt_4, t0.image_custom_name AS image_custom_name_5, t0.image_name_2 AS image_name_2_6, t0.image_name_3 AS image_name_3_7, t0.image_name AS image_name_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.created_by AS created_by_11, t0.updated_by AS updated_by_12, t0.deleted_by AS deleted_by_13, t0.category_parent_id AS category_parent_id_14 FROM category t0 INNER JOIN category_parent_relation ON t0.id = category_parent_relation.category_id WHERE category_parent_relation.parent_id = ? ORDER BY t0.position ASC
[
124
]
|
|
doctrine |
SELECT t0.id AS id_1, t0.level AS level_2, t0.position AS position_3, t0.alt AS alt_4, t0.image_custom_name AS image_custom_name_5, t0.image_name_2 AS image_name_2_6, t0.image_name_3 AS image_name_3_7, t0.image_name AS image_name_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.created_by AS created_by_11, t0.updated_by AS updated_by_12, t0.deleted_by AS deleted_by_13, t0.category_parent_id AS category_parent_id_14 FROM category t0 INNER JOIN category_parent_relation ON t0.id = category_parent_relation.category_id WHERE category_parent_relation.parent_id = ? ORDER BY t0.position ASC
[
298
]
|
|
doctrine |
SELECT t0.id AS id_1, t0.level AS level_2, t0.position AS position_3, t0.alt AS alt_4, t0.image_custom_name AS image_custom_name_5, t0.image_name_2 AS image_name_2_6, t0.image_name_3 AS image_name_3_7, t0.image_name AS image_name_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.created_by AS created_by_11, t0.updated_by AS updated_by_12, t0.deleted_by AS deleted_by_13, t0.category_parent_id AS category_parent_id_14 FROM category t0 INNER JOIN category_parent_relation ON t0.id = category_parent_relation.category_id WHERE category_parent_relation.parent_id = ? ORDER BY t0.position ASC
[
292
]
|
|
doctrine |
SELECT t0.id AS id_1, t0.level AS level_2, t0.position AS position_3, t0.alt AS alt_4, t0.image_custom_name AS image_custom_name_5, t0.image_name_2 AS image_name_2_6, t0.image_name_3 AS image_name_3_7, t0.image_name AS image_name_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.created_by AS created_by_11, t0.updated_by AS updated_by_12, t0.deleted_by AS deleted_by_13, t0.category_parent_id AS category_parent_id_14 FROM category t0 INNER JOIN category_parent_relation ON t0.id = category_parent_relation.category_id WHERE category_parent_relation.parent_id = ? ORDER BY t0.position ASC
[
273
]
|
|
doctrine |
SELECT t0.id AS id_1, t0.level AS level_2, t0.position AS position_3, t0.alt AS alt_4, t0.image_custom_name AS image_custom_name_5, t0.image_name_2 AS image_name_2_6, t0.image_name_3 AS image_name_3_7, t0.image_name AS image_name_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.created_by AS created_by_11, t0.updated_by AS updated_by_12, t0.deleted_by AS deleted_by_13, t0.category_parent_id AS category_parent_id_14 FROM category t0 INNER JOIN category_parent_relation ON t0.id = category_parent_relation.category_id WHERE category_parent_relation.parent_id = ? ORDER BY t0.position ASC
[
255
]
|
|
doctrine |
SELECT t0.id AS id_1, t0.level AS level_2, t0.position AS position_3, t0.alt AS alt_4, t0.image_custom_name AS image_custom_name_5, t0.image_name_2 AS image_name_2_6, t0.image_name_3 AS image_name_3_7, t0.image_name AS image_name_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.created_by AS created_by_11, t0.updated_by AS updated_by_12, t0.deleted_by AS deleted_by_13, t0.category_parent_id AS category_parent_id_14 FROM category t0 INNER JOIN category_parent_relation ON t0.id = category_parent_relation.category_id WHERE category_parent_relation.parent_id = ? ORDER BY t0.position ASC
[
139
]
|
|
doctrine |
SELECT t0.id AS id_1, t0.level AS level_2, t0.position AS position_3, t0.alt AS alt_4, t0.image_custom_name AS image_custom_name_5, t0.image_name_2 AS image_name_2_6, t0.image_name_3 AS image_name_3_7, t0.image_name AS image_name_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.created_by AS created_by_11, t0.updated_by AS updated_by_12, t0.deleted_by AS deleted_by_13, t0.category_parent_id AS category_parent_id_14 FROM category t0 INNER JOIN category_parent_relation ON t0.id = category_parent_relation.category_id WHERE category_parent_relation.parent_id = ? ORDER BY t0.position ASC
[
279
]
|
|
doctrine |
SELECT t0.id AS id_1, t0.level AS level_2, t0.position AS position_3, t0.alt AS alt_4, t0.image_custom_name AS image_custom_name_5, t0.image_name_2 AS image_name_2_6, t0.image_name_3 AS image_name_3_7, t0.image_name AS image_name_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.created_by AS created_by_11, t0.updated_by AS updated_by_12, t0.deleted_by AS deleted_by_13, t0.category_parent_id AS category_parent_id_14 FROM category t0 INNER JOIN category_parent_relation ON t0.id = category_parent_relation.category_id WHERE category_parent_relation.parent_id = ? ORDER BY t0.position ASC
[
147
]
|
|
doctrine |
SELECT t0.id AS id_1, t0.content AS content_2, t0.image_name AS image_name_3, t0.marker_text AS marker_text_4, t0.background_color AS background_color_5, t0.text_color AS text_color_6, t0.is_active AS is_active_7, t0.url AS url_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.created_by AS created_by_11, t0.updated_by AS updated_by_12, t0.deleted_by AS deleted_by_13, t0.language AS language_14, t0.product_producer_id AS product_producer_id_15, t0.landing_page_id AS landing_page_id_16, t0.availability_id AS availability_id_17 FROM listing_marker t0 WHERE t0.id = ?
[
"411"
]
|
|
doctrine |
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.domain AS domain_3, t0.is_active AS is_active_4, t0.is_default AS is_default_5, t0.helpline AS helpline_6, t0.rounding_precision AS rounding_precision_7, t0.phone AS phone_8, t0.address AS address_9, t0.shop_name AS shop_name_10, t0.email AS email_11, t0.facebook AS facebook_12, t0.instagram AS instagram_13, t0.youtube AS youtube_14, t0.store_url AS store_url_15, t0.password_protected AS password_protected_16, t0.store_password AS store_password_17, t0.fb_pixel AS fb_pixel_18, t0.fb_token AS fb_token_19, t0.is_comments AS is_comments_20, t0.send_comment_request_days AS send_comment_request_days_21, t0.store_email AS store_email_22, t0.admin_store_email AS admin_store_email_23, t0.complaint_email AS complaint_email_24, t0.product_return_email AS product_return_email_25, t0.getresponse_campaign_id AS getresponse_campaign_id_26, t0.created_at AS created_at_27, t0.updated_at AS updated_at_28, t0.created_by AS created_by_29, t0.updated_by AS updated_by_30, t0.deleted_by AS deleted_by_31, t0.currency_id AS currency_id_32 FROM language t0 WHERE t0.currency_id = ? LIMIT 1
[
1
]
|
|
doctrine |
SELECT p0_.id AS id_0, p0_.main AS main_1, p0_.lifestyle AS lifestyle_2, p0_.hover AS hover_3, p0_.name AS name_4, p0_.image_name AS image_name_5, p0_.position AS position_6, p0_.alt AS alt_7, p0_.image_custom_name AS image_custom_name_8, l1_.id AS id_9, l1_.locale AS locale_10, l1_.domain AS domain_11, l1_.is_active AS is_active_12, l1_.is_default AS is_default_13, l1_.helpline AS helpline_14, l1_.rounding_precision AS rounding_precision_15, l1_.phone AS phone_16, l1_.address AS address_17, l1_.shop_name AS shop_name_18, l1_.email AS email_19, l1_.facebook AS facebook_20, l1_.instagram AS instagram_21, l1_.youtube AS youtube_22, l1_.store_url AS store_url_23, l1_.password_protected AS password_protected_24, l1_.store_password AS store_password_25, l1_.fb_pixel AS fb_pixel_26, l1_.fb_token AS fb_token_27, l1_.is_comments AS is_comments_28, l1_.send_comment_request_days AS send_comment_request_days_29, l1_.store_email AS store_email_30, l1_.admin_store_email AS admin_store_email_31, l1_.complaint_email AS complaint_email_32, l1_.product_return_email AS product_return_email_33, l1_.getresponse_campaign_id AS getresponse_campaign_id_34, l1_.created_at AS created_at_35, l1_.updated_at AS updated_at_36, l1_.created_by AS created_by_37, l1_.updated_by AS updated_by_38, l1_.deleted_by AS deleted_by_39, p0_.product_id AS product_id_40, l1_.currency_id AS currency_id_41 FROM product_photo p0_ INNER JOIN product_photo_language p2_ ON p0_.id = p2_.product_photo_id INNER JOIN language l1_ ON l1_.id = p2_.language_id WHERE p0_.product_id = ? AND l1_.id = ? AND p0_.main <> 1 ORDER BY p0_.position ASC
[ 8028 1 ] |
|
doctrine |
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.domain AS domain_3, t0.is_active AS is_active_4, t0.is_default AS is_default_5, t0.helpline AS helpline_6, t0.rounding_precision AS rounding_precision_7, t0.phone AS phone_8, t0.address AS address_9, t0.shop_name AS shop_name_10, t0.email AS email_11, t0.facebook AS facebook_12, t0.instagram AS instagram_13, t0.youtube AS youtube_14, t0.store_url AS store_url_15, t0.password_protected AS password_protected_16, t0.store_password AS store_password_17, t0.fb_pixel AS fb_pixel_18, t0.fb_token AS fb_token_19, t0.is_comments AS is_comments_20, t0.send_comment_request_days AS send_comment_request_days_21, t0.store_email AS store_email_22, t0.admin_store_email AS admin_store_email_23, t0.complaint_email AS complaint_email_24, t0.product_return_email AS product_return_email_25, t0.getresponse_campaign_id AS getresponse_campaign_id_26, t0.created_at AS created_at_27, t0.updated_at AS updated_at_28, t0.created_by AS created_by_29, t0.updated_by AS updated_by_30, t0.deleted_by AS deleted_by_31, t0.currency_id AS currency_id_32 FROM language t0 WHERE t0.currency_id = ? LIMIT 1
[
1
]
|
|
doctrine |
SELECT p0_.id AS id_0, p0_.main AS main_1, p0_.lifestyle AS lifestyle_2, p0_.hover AS hover_3, p0_.name AS name_4, p0_.image_name AS image_name_5, p0_.position AS position_6, p0_.alt AS alt_7, p0_.image_custom_name AS image_custom_name_8, l1_.id AS id_9, l1_.locale AS locale_10, l1_.domain AS domain_11, l1_.is_active AS is_active_12, l1_.is_default AS is_default_13, l1_.helpline AS helpline_14, l1_.rounding_precision AS rounding_precision_15, l1_.phone AS phone_16, l1_.address AS address_17, l1_.shop_name AS shop_name_18, l1_.email AS email_19, l1_.facebook AS facebook_20, l1_.instagram AS instagram_21, l1_.youtube AS youtube_22, l1_.store_url AS store_url_23, l1_.password_protected AS password_protected_24, l1_.store_password AS store_password_25, l1_.fb_pixel AS fb_pixel_26, l1_.fb_token AS fb_token_27, l1_.is_comments AS is_comments_28, l1_.send_comment_request_days AS send_comment_request_days_29, l1_.store_email AS store_email_30, l1_.admin_store_email AS admin_store_email_31, l1_.complaint_email AS complaint_email_32, l1_.product_return_email AS product_return_email_33, l1_.getresponse_campaign_id AS getresponse_campaign_id_34, l1_.created_at AS created_at_35, l1_.updated_at AS updated_at_36, l1_.created_by AS created_by_37, l1_.updated_by AS updated_by_38, l1_.deleted_by AS deleted_by_39, p0_.product_id AS product_id_40, l1_.currency_id AS currency_id_41 FROM product_photo p0_ INNER JOIN product_photo_language p2_ ON p0_.id = p2_.product_photo_id INNER JOIN language l1_ ON l1_.id = p2_.language_id WHERE p0_.product_id = ? AND l1_.id = ? AND p0_.main <> 1 ORDER BY p0_.position ASC
[ 8033 1 ] |
|
event |
Notified event "kernel.response" to listener "App\Listener\GenerateCookieListener::onKernelResponse" .
[ "event" => "kernel.response" "listener" => "App\Listener\GenerateCookieListener::onKernelResponse" ] |
|
event |
Notified event "kernel.response" to listener "Symfony\Component\HttpKernel\EventListener\ResponseListener::onKernelResponse" .
[ "event" => "kernel.response" "listener" => "Symfony\Component\HttpKernel\EventListener\ResponseListener::onKernelResponse" ] |
|
event |
Notified event "kernel.response" to listener "Symfony\Component\HttpKernel\DataCollector\RequestDataCollector::onKernelResponse" .
[ "event" => "kernel.response" "listener" => "Symfony\Component\HttpKernel\DataCollector\RequestDataCollector::onKernelResponse" ] |
|
event |
Notified event "kernel.response" to listener "Symfony\Component\WebLink\EventListener\AddLinkHeaderListener::onKernelResponse" .
[ "event" => "kernel.response" "listener" => "Symfony\Component\WebLink\EventListener\AddLinkHeaderListener::onKernelResponse" ] |
|
event |
Notified event "kernel.response" to listener "Sensio\Bundle\FrameworkExtraBundle\EventListener\HttpCacheListener::onKernelResponse" .
[ "event" => "kernel.response" "listener" => "Sensio\Bundle\FrameworkExtraBundle\EventListener\HttpCacheListener::onKernelResponse" ] |
|
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" ] |
|
event |
Notified event "kernel.response" to listener "Symfony\Component\HttpKernel\EventListener\ProfilerListener::onKernelResponse" .
[ "event" => "kernel.response" "listener" => "Symfony\Component\HttpKernel\EventListener\ProfilerListener::onKernelResponse" ] |
|
event |
Notified event "kernel.response" to listener "Symfony\Bundle\WebProfilerBundle\EventListener\WebDebugToolbarListener::onKernelResponse" .
[ "event" => "kernel.response" "listener" => "Symfony\Bundle\WebProfilerBundle\EventListener\WebDebugToolbarListener::onKernelResponse" ] |
|
event |
Notified event "kernel.response" to listener "Symfony\Component\HttpKernel\EventListener\SessionListener::onKernelResponse" .
[ "event" => "kernel.response" "listener" => "Symfony\Component\HttpKernel\EventListener\SessionListener::onKernelResponse" ] |
|
event |
Notified event "kernel.response" to listener "Symfony\Component\HttpKernel\EventListener\StreamedResponseListener::onKernelResponse" .
[ "event" => "kernel.response" "listener" => "Symfony\Component\HttpKernel\EventListener\StreamedResponseListener::onKernelResponse" ] |
|
event |
Notified event "kernel.finish_request" to listener "Symfony\Component\HttpKernel\EventListener\LocaleListener::onKernelFinishRequest" .
[ "event" => "kernel.finish_request" "listener" => "Symfony\Component\HttpKernel\EventListener\LocaleListener::onKernelFinishRequest" ] |
|
event |
Notified event "kernel.finish_request" to listener "Symfony\Component\HttpKernel\EventListener\SessionListener::onFinishRequest" .
[ "event" => "kernel.finish_request" "listener" => "Symfony\Component\HttpKernel\EventListener\SessionListener::onFinishRequest" ] |
|
event |
Notified event "kernel.finish_request" to listener "Symfony\Component\HttpKernel\EventListener\TranslatorListener::onKernelFinishRequest" .
[ "event" => "kernel.finish_request" "listener" => "Symfony\Component\HttpKernel\EventListener\TranslatorListener::onKernelFinishRequest" ] |
|
event |
Notified event "kernel.finish_request" to listener "Symfony\Component\HttpKernel\EventListener\RouterListener::onKernelFinishRequest" .
[ "event" => "kernel.finish_request" "listener" => "Symfony\Component\HttpKernel\EventListener\RouterListener::onKernelFinishRequest" ] |
|
event |
Notified event "kernel.finish_request" to listener "Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener::onKernelFinishRequest" .
[ "event" => "kernel.finish_request" "listener" => "Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener::onKernelFinishRequest" ] |
|
event |
Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\DebugHandlersListener::configure" .
[ "event" => "kernel.request" "listener" => "Symfony\Component\HttpKernel\EventListener\DebugHandlersListener::configure" ] |
|
event |
Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\ValidateRequestListener::onKernelRequest" .
[ "event" => "kernel.request" "listener" => "Symfony\Component\HttpKernel\EventListener\ValidateRequestListener::onKernelRequest" ] |
|
event |
Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\SessionListener::onKernelRequest" .
[ "event" => "kernel.request" "listener" => "Symfony\Component\HttpKernel\EventListener\SessionListener::onKernelRequest" ] |
|
event |
Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\RouterListener::onKernelRequest" .
[ "event" => "kernel.request" "listener" => "Symfony\Component\HttpKernel\EventListener\RouterListener::onKernelRequest" ] |
|
event |
Notified event "kernel.request" to listener "Symfony\Bundle\FrameworkBundle\EventListener\ResolveControllerNameSubscriber::onKernelRequest" .
[ "event" => "kernel.request" "listener" => "Symfony\Bundle\FrameworkBundle\EventListener\ResolveControllerNameSubscriber::onKernelRequest" ] |
|
event |
Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\LocaleListener::onKernelRequest" .
[ "event" => "kernel.request" "listener" => "Symfony\Component\HttpKernel\EventListener\LocaleListener::onKernelRequest" ] |
|
event |
Notified event "kernel.request" to listener "FOS\RestBundle\EventListener\BodyListener::onKernelRequest" .
[ "event" => "kernel.request" "listener" => "FOS\RestBundle\EventListener\BodyListener::onKernelRequest" ] |
|
event |
Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\TranslatorListener::onKernelRequest" .
[ "event" => "kernel.request" "listener" => "Symfony\Component\HttpKernel\EventListener\TranslatorListener::onKernelRequest" ] |
|
event |
Notified event "kernel.request" to listener "Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener::onKernelRequest" .
[ "event" => "kernel.request" "listener" => "Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener::onKernelRequest" ] |
|
event |
Notified event "kernel.request" to listener "Knp\Bundle\PaginatorBundle\Subscriber\SlidingPaginationSubscriber::onKernelRequest" .
[ "event" => "kernel.request" "listener" => "Knp\Bundle\PaginatorBundle\Subscriber\SlidingPaginationSubscriber::onKernelRequest" ] |
|
event |
Notified event "kernel.request" to listener "App\Listener\RequestListener::onKernelRequest" .
[ "event" => "kernel.request" "listener" => "App\Listener\RequestListener::onKernelRequest" ] |
|
event |
Notified event "kernel.controller" to listener "Symfony\Bundle\FrameworkBundle\DataCollector\RouterDataCollector::onKernelController" .
[ "event" => "kernel.controller" "listener" => "Symfony\Bundle\FrameworkBundle\DataCollector\RouterDataCollector::onKernelController" ] |
|
event |
Notified event "kernel.controller" to listener "Symfony\Component\HttpKernel\DataCollector\RequestDataCollector::onKernelController" .
[ "event" => "kernel.controller" "listener" => "Symfony\Component\HttpKernel\DataCollector\RequestDataCollector::onKernelController" ] |
|
event |
Notified event "kernel.controller" to listener "Sensio\Bundle\FrameworkExtraBundle\EventListener\ControllerListener::onKernelController" .
[ "event" => "kernel.controller" "listener" => "Sensio\Bundle\FrameworkExtraBundle\EventListener\ControllerListener::onKernelController" ] |
|
event |
Notified event "kernel.controller" to listener "Sensio\Bundle\FrameworkExtraBundle\EventListener\ParamConverterListener::onKernelController" .
[ "event" => "kernel.controller" "listener" => "Sensio\Bundle\FrameworkExtraBundle\EventListener\ParamConverterListener::onKernelController" ] |
|
event |
Notified event "kernel.controller" to listener "Sensio\Bundle\FrameworkExtraBundle\EventListener\HttpCacheListener::onKernelController" .
[ "event" => "kernel.controller" "listener" => "Sensio\Bundle\FrameworkExtraBundle\EventListener\HttpCacheListener::onKernelController" ] |
|
event |
Notified event "kernel.controller" to listener "Sensio\Bundle\FrameworkExtraBundle\EventListener\TemplateListener::onKernelController" .
[ "event" => "kernel.controller" "listener" => "Sensio\Bundle\FrameworkExtraBundle\EventListener\TemplateListener::onKernelController" ] |
|
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" ] |
|
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" ] |
|
doctrine |
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.domain AS domain_3, t0.is_active AS is_active_4, t0.is_default AS is_default_5, t0.helpline AS helpline_6, t0.rounding_precision AS rounding_precision_7, t0.phone AS phone_8, t0.address AS address_9, t0.shop_name AS shop_name_10, t0.email AS email_11, t0.facebook AS facebook_12, t0.instagram AS instagram_13, t0.youtube AS youtube_14, t0.store_url AS store_url_15, t0.password_protected AS password_protected_16, t0.store_password AS store_password_17, t0.fb_pixel AS fb_pixel_18, t0.fb_token AS fb_token_19, t0.is_comments AS is_comments_20, t0.send_comment_request_days AS send_comment_request_days_21, t0.store_email AS store_email_22, t0.admin_store_email AS admin_store_email_23, t0.complaint_email AS complaint_email_24, t0.product_return_email AS product_return_email_25, t0.getresponse_campaign_id AS getresponse_campaign_id_26, t0.created_at AS created_at_27, t0.updated_at AS updated_at_28, t0.created_by AS created_by_29, t0.updated_by AS updated_by_30, t0.deleted_by AS deleted_by_31, t0.currency_id AS currency_id_32 FROM language t0 WHERE t0.locale = ? AND t0.deleted_by IS NULL LIMIT 1
[
"pl"
]
|
|
doctrine |
SELECT w0_.id AS id_0, w0_.day AS day_1, w0_.name AS name_2, w0_.working_hours_type AS working_hours_type_3, w0_.nb_of_the_day AS nb_of_the_day_4, w0_.created_at AS created_at_5, w0_.updated_at AS updated_at_6, w0_.created_by AS created_by_7, w0_.updated_by AS updated_by_8, w0_.deleted_by AS deleted_by_9, w1_.id AS id_10, w1_.name AS name_11, w1_.short_name AS short_name_12, w1_.locale AS locale_13, w1_.translatable_id AS translatable_id_14 FROM working_hours w0_ INNER JOIN working_hours_translation w1_ ON w0_.id = w1_.translatable_id WHERE w1_.locale = ? AND w0_.deleted_by IS NULL AND w0_.nb_of_the_day = ? AND w0_.working_hours_type = ?
[ "pl" "6" "main" ] |
|
doctrine |
SELECT h0_.id AS id_0, h0_.day AS day_1, h0_.nb_of_the_day AS nb_of_the_day_2, h0_.created_at AS created_at_3, h0_.updated_at AS updated_at_4, h0_.created_by AS created_by_5, h0_.updated_by AS updated_by_6, h0_.deleted_by AS deleted_by_7, h1_.id AS id_8, h1_.name AS name_9, h1_.short_name AS short_name_10, h1_.locale AS locale_11, h1_.translatable_id AS translatable_id_12 FROM helpline_hours h0_ INNER JOIN helpline_hours_translation h1_ ON h0_.id = h1_.translatable_id WHERE h1_.locale = ? AND h0_.deleted_by IS NULL AND h0_.nb_of_the_day = ?
[ "pl" "6" ] |
|
doctrine |
SELECT c0_.id AS id_0, c0_.level AS level_1, c0_.position AS position_2, c0_.alt AS alt_3, c0_.image_custom_name AS image_custom_name_4, c0_.image_name_2 AS image_name_2_5, c0_.image_name_3 AS image_name_3_6, c0_.image_name AS image_name_7, c0_.created_at AS created_at_8, c0_.updated_at AS updated_at_9, c0_.created_by AS created_by_10, c0_.updated_by AS updated_by_11, c0_.deleted_by AS deleted_by_12, c1_.id AS id_13, c1_.name AS name_14, c1_.description AS description_15, c1_.meta_title AS meta_title_16, c1_.meta_description AS meta_description_17, c1_.meta_keywords AS meta_keywords_18, c1_.custom_h1 AS custom_h1_19, c1_.canonical AS canonical_20, c1_.slug AS slug_21, c1_.google_product_type AS google_product_type_22, c1_.google_product_category AS google_product_category_23, c1_.special_product_category AS special_product_category_24, c1_.locale AS locale_25, c2_.id AS id_26, c2_.level AS level_27, c2_.position AS position_28, c2_.alt AS alt_29, c2_.image_custom_name AS image_custom_name_30, c2_.image_name_2 AS image_name_2_31, c2_.image_name_3 AS image_name_3_32, c2_.image_name AS image_name_33, c2_.created_at AS created_at_34, c2_.updated_at AS updated_at_35, c2_.created_by AS created_by_36, c2_.updated_by AS updated_by_37, c2_.deleted_by AS deleted_by_38, c3_.id AS id_39, c3_.name AS name_40, c3_.description AS description_41, c3_.meta_title AS meta_title_42, c3_.meta_description AS meta_description_43, c3_.meta_keywords AS meta_keywords_44, c3_.custom_h1 AS custom_h1_45, c3_.canonical AS canonical_46, c3_.slug AS slug_47, c3_.google_product_type AS google_product_type_48, c3_.google_product_category AS google_product_category_49, c3_.special_product_category AS special_product_category_50, c3_.locale AS locale_51, c4_.id AS id_52, c4_.visible AS visible_53, c4_.special AS special_54, c4_.shortcut AS shortcut_55, c4_.position AS position_56, c4_.is_homepage AS is_homepage_57, c4_.nb_products AS nb_products_58, c0_.category_parent_id AS category_parent_id_59, c1_.translatable_id AS translatable_id_60, c2_.category_parent_id AS category_parent_id_61, c3_.translatable_id AS translatable_id_62, c4_.category_id AS category_id_63, c4_.language AS language_64 FROM category c0_ INNER JOIN category_translation c1_ ON c0_.id = c1_.translatable_id INNER JOIN category_lang_param c5_ ON c0_.id = c5_.category_id INNER JOIN language l6_ ON c5_.language = l6_.id LEFT JOIN category c2_ ON c0_.id = c2_.category_parent_id LEFT JOIN category_translation c3_ ON c2_.id = c3_.translatable_id LEFT JOIN category_lang_param c4_ ON c2_.id = c4_.category_id LEFT JOIN language l7_ ON c4_.language = l7_.id WHERE c1_.locale = ? AND l6_.locale = ? AND c5_.special = ? AND c5_.shortcut = ? AND c0_.deleted_by IS NULL AND c5_.visible = ? AND c2_.deleted_by IS NULL AND l7_.locale = ? AND c4_.visible = 1 AND c0_.category_parent_id IS NULL AND c0_.id <> 209 AND c0_.id <> 121 ORDER BY c5_.position ASC, c4_.position ASC, c2_.position ASC
[ "pl" "pl" 0 0 true "pl" ] |
|
doctrine |
SELECT f0_.id AS id_0, f0_.image_name AS image_name_1, f0_.created_at AS created_at_2, f0_.updated_at AS updated_at_3, f0_.created_by AS created_by_4, f0_.updated_by AS updated_by_5, f0_.deleted_by AS deleted_by_6, f1_.id AS id_7, f1_.name AS name_8, f1_.description AS description_9, f1_.meta_title AS meta_title_10, f1_.meta_description AS meta_description_11, f1_.meta_keywords AS meta_keywords_12, f1_.canonical AS canonical_13, f1_.slug AS slug_14, f1_.locale AS locale_15, f2_.id AS id_16, f2_.visible AS visible_17, f2_.position AS position_18, f2_.nb_products AS nb_products_19, f0_.vat_id AS vat_id_20, f1_.translatable_id AS translatable_id_21, f2_.furniture_type_id AS furniture_type_id_22, f2_.language AS language_23 FROM furniture_type f0_ INNER JOIN furniture_type_translation f1_ ON f0_.id = f1_.translatable_id INNER JOIN furniture_lang_param f2_ ON f0_.id = f2_.furniture_type_id INNER JOIN language l3_ ON f2_.language = l3_.id WHERE f1_.locale = ? AND f0_.deleted_by IS NULL AND l3_.locale = ? AND f2_.visible = ? ORDER BY f2_.position ASC
[ "pl" "pl" 1 ] |
|
doctrine |
SELECT a0_.id AS id_0, a0_.title AS title_1, a0_.content AS content_2, a0_.slug AS slug_3, a0_.header AS header_4, a0_.footer AS footer_5, a0_.created_at AS created_at_6, a0_.updated_at AS updated_at_7, a0_.created_by AS created_by_8, a0_.updated_by AS updated_by_9, a0_.deleted_by AS deleted_by_10, l1_.id AS id_11, l1_.locale AS locale_12, l1_.domain AS domain_13, l1_.is_active AS is_active_14, l1_.is_default AS is_default_15, l1_.helpline AS helpline_16, l1_.rounding_precision AS rounding_precision_17, l1_.phone AS phone_18, l1_.address AS address_19, l1_.shop_name AS shop_name_20, l1_.email AS email_21, l1_.facebook AS facebook_22, l1_.instagram AS instagram_23, l1_.youtube AS youtube_24, l1_.store_url AS store_url_25, l1_.password_protected AS password_protected_26, l1_.store_password AS store_password_27, l1_.fb_pixel AS fb_pixel_28, l1_.fb_token AS fb_token_29, l1_.is_comments AS is_comments_30, l1_.send_comment_request_days AS send_comment_request_days_31, l1_.store_email AS store_email_32, l1_.admin_store_email AS admin_store_email_33, l1_.complaint_email AS complaint_email_34, l1_.product_return_email AS product_return_email_35, l1_.getresponse_campaign_id AS getresponse_campaign_id_36, l1_.created_at AS created_at_37, l1_.updated_at AS updated_at_38, l1_.created_by AS created_by_39, l1_.updated_by AS updated_by_40, l1_.deleted_by AS deleted_by_41, a0_.language_id AS language_id_42, l1_.currency_id AS currency_id_43 FROM article a0_ INNER JOIN language l1_ ON a0_.language_id = l1_.id WHERE a0_.deleted_by IS NULL AND l1_.locale = ?
[
"pl"
]
|
|
doctrine |
SELECT c0_.id AS id_0, c0_.level AS level_1, c0_.position AS position_2, c0_.alt AS alt_3, c0_.image_custom_name AS image_custom_name_4, c0_.image_name_2 AS image_name_2_5, c0_.image_name_3 AS image_name_3_6, c0_.image_name AS image_name_7, c0_.created_at AS created_at_8, c0_.updated_at AS updated_at_9, c0_.created_by AS created_by_10, c0_.updated_by AS updated_by_11, c0_.deleted_by AS deleted_by_12, c1_.id AS id_13, c1_.name AS name_14, c1_.description AS description_15, c1_.meta_title AS meta_title_16, c1_.meta_description AS meta_description_17, c1_.meta_keywords AS meta_keywords_18, c1_.custom_h1 AS custom_h1_19, c1_.canonical AS canonical_20, c1_.slug AS slug_21, c1_.google_product_type AS google_product_type_22, c1_.google_product_category AS google_product_category_23, c1_.special_product_category AS special_product_category_24, c1_.locale AS locale_25, c2_.id AS id_26, c2_.level AS level_27, c2_.position AS position_28, c2_.alt AS alt_29, c2_.image_custom_name AS image_custom_name_30, c2_.image_name_2 AS image_name_2_31, c2_.image_name_3 AS image_name_3_32, c2_.image_name AS image_name_33, c2_.created_at AS created_at_34, c2_.updated_at AS updated_at_35, c2_.created_by AS created_by_36, c2_.updated_by AS updated_by_37, c2_.deleted_by AS deleted_by_38, c3_.id AS id_39, c3_.name AS name_40, c3_.description AS description_41, c3_.meta_title AS meta_title_42, c3_.meta_description AS meta_description_43, c3_.meta_keywords AS meta_keywords_44, c3_.custom_h1 AS custom_h1_45, c3_.canonical AS canonical_46, c3_.slug AS slug_47, c3_.google_product_type AS google_product_type_48, c3_.google_product_category AS google_product_category_49, c3_.special_product_category AS special_product_category_50, c3_.locale AS locale_51, c0_.category_parent_id AS category_parent_id_52, c1_.translatable_id AS translatable_id_53, c2_.category_parent_id AS category_parent_id_54, c3_.translatable_id AS translatable_id_55 FROM category c0_ INNER JOIN category_translation c1_ ON c0_.id = c1_.translatable_id INNER JOIN category_lang_param c4_ ON c0_.id = c4_.category_id INNER JOIN language l5_ ON c4_.language = l5_.id LEFT JOIN category c2_ ON c0_.id = c2_.category_parent_id LEFT JOIN category_translation c3_ ON c2_.id = c3_.translatable_id INNER JOIN product_category p6_ ON c0_.id = p6_.category_id INNER JOIN product p7_ ON p6_.product_id = p7_.id INNER JOIN product_lang_param p8_ ON p7_.id = p8_.product_id INNER JOIN availability a9_ ON p8_.availability_id = a9_.id WHERE c1_.locale = ? AND l5_.locale = ? AND c4_.special = ? AND c4_.shortcut = ? AND c0_.deleted_by IS NULL AND c4_.visible = ? AND c2_.deleted_by IS NULL AND a9_.id = ? AND c0_.category_parent_id IS NULL AND c0_.id <> ? GROUP BY c0_.id ORDER BY c4_.position ASC, c2_.position ASC
[ "pl" "pl" 0 0 true 1 209 ] |
|
doctrine |
SELECT f0_.id AS id_0, f0_.image_name AS image_name_1, f0_.created_at AS created_at_2, f0_.updated_at AS updated_at_3, f0_.created_by AS created_by_4, f0_.updated_by AS updated_by_5, f0_.deleted_by AS deleted_by_6, f1_.id AS id_7, f1_.name AS name_8, f1_.description AS description_9, f1_.meta_title AS meta_title_10, f1_.meta_description AS meta_description_11, f1_.meta_keywords AS meta_keywords_12, f1_.canonical AS canonical_13, f1_.slug AS slug_14, f1_.locale AS locale_15, f2_.id AS id_16, f2_.visible AS visible_17, f2_.position AS position_18, f2_.nb_products AS nb_products_19, f0_.vat_id AS vat_id_20, f1_.translatable_id AS translatable_id_21, f2_.furniture_type_id AS furniture_type_id_22, f2_.language AS language_23 FROM furniture_type f0_ INNER JOIN furniture_type_translation f1_ ON f0_.id = f1_.translatable_id INNER JOIN furniture_lang_param f2_ ON f0_.id = f2_.furniture_type_id INNER JOIN language l3_ ON f2_.language = l3_.id INNER JOIN product_furniture_type p4_ ON f0_.id = p4_.furniture_type_id INNER JOIN product p5_ ON p4_.product_id = p5_.id INNER JOIN product_lang_param p6_ ON p5_.id = p6_.product_id INNER JOIN availability a7_ ON p6_.availability_id = a7_.id WHERE f1_.locale = ? AND f0_.deleted_by IS NULL AND l3_.locale = ? AND f2_.visible = ? AND a7_.id = ? GROUP BY f0_.id ORDER BY f2_.position ASC
[ "pl" "pl" 1 1 ] |
|
doctrine |
SELECT f0_.id AS id_0, f0_.image_name AS image_name_1, f0_.created_at AS created_at_2, f0_.updated_at AS updated_at_3, f0_.created_by AS created_by_4, f0_.updated_by AS updated_by_5, f0_.deleted_by AS deleted_by_6, f1_.id AS id_7, f1_.name AS name_8, f1_.description AS description_9, f1_.meta_title AS meta_title_10, f1_.meta_description AS meta_description_11, f1_.meta_keywords AS meta_keywords_12, f1_.canonical AS canonical_13, f1_.slug AS slug_14, f1_.locale AS locale_15, f2_.id AS id_16, f2_.visible AS visible_17, f2_.position AS position_18, f2_.nb_products AS nb_products_19, f0_.vat_id AS vat_id_20, f1_.translatable_id AS translatable_id_21, f2_.furniture_type_id AS furniture_type_id_22, f2_.language AS language_23 FROM furniture_type f0_ INNER JOIN furniture_type_translation f1_ ON f0_.id = f1_.translatable_id INNER JOIN furniture_lang_param f2_ ON f0_.id = f2_.furniture_type_id INNER JOIN language l3_ ON f2_.language = l3_.id INNER JOIN product_furniture_type p4_ ON f0_.id = p4_.furniture_type_id INNER JOIN product p5_ ON p4_.product_id = p5_.id INNER JOIN product_category p6_ ON p5_.id = p6_.product_id INNER JOIN category c7_ ON p6_.category_id = c7_.id WHERE f1_.locale = ? AND f0_.deleted_by IS NULL AND l3_.locale = ? AND f2_.visible = ? AND ((c7_.id = 237 OR c7_.id = 127)) GROUP BY f0_.id ORDER BY f2_.position ASC
[ "pl" "pl" 1 ] |
|
doctrine |
SELECT c0_.id AS id_0, c0_.level AS level_1, c0_.position AS position_2, c0_.alt AS alt_3, c0_.image_custom_name AS image_custom_name_4, c0_.image_name_2 AS image_name_2_5, c0_.image_name_3 AS image_name_3_6, c0_.image_name AS image_name_7, c0_.created_at AS created_at_8, c0_.updated_at AS updated_at_9, c0_.created_by AS created_by_10, c0_.updated_by AS updated_by_11, c0_.deleted_by AS deleted_by_12, c0_.category_parent_id AS category_parent_id_13 FROM category c0_ WHERE c0_.id IN (?)
[ [ 237 121 ] ] |
|
doctrine |
SELECT p0_.listingMarkersIds AS listingMarkersIds_0, p1_.promotion_icon AS promotion_icon_1, p1_.is_new AS is_new_2, p2_.image_name AS image_name_3, p3_.image_name AS image_name_4, p1_.bestseller AS bestseller_5, p4_.id AS id_6, c5_.sign AS sign_7, c5_.id AS id_8, p1_.price_description AS price_description_9, p1_.price_crossed AS price_crossed_10, p1_.omnibus_price AS omnibus_price_11, p0_.id AS id_12, p0_.symbol AS symbol_13, p0_.photo3d AS photo3d_14, p0_.is_variants AS is_variants_15, p0_.is_palette_delivery AS is_palette_delivery_16, p0_.payu AS payu_17, p0_.automatic_price AS automatic_price_18, p0_.halmar_stock_exchange AS halmar_stock_exchange_19, p0_.diablo_stock_exchange AS diablo_stock_exchange_20, p0_.jan_nowak_stock_exchange AS jan_nowak_stock_exchange_21, p0_.actona_stock_exchange AS actona_stock_exchange_22, p0_.unique_stock_exchange AS unique_stock_exchange_23, p0_.is_compare AS is_compare_24, p0_.priority_search_engine AS priority_search_engine_25, p0_.is_negotiate AS is_negotiate_26, p0_.is_rebate_code AS is_rebate_code_27, p0_.old_price AS old_price_28, p0_.film AS film_29, p0_.small_product_photo AS small_product_photo_30, p0_.max_quantity AS max_quantity_31, p0_.listingMarkersIds AS listingMarkersIds_32, p0_.temporary_unavailable AS temporary_unavailable_33, p0_.last_ranking_update AS last_ranking_update_34, p0_.height AS height_35, p0_.width AS width_36, p0_.depth AS depth_37, p0_.shipping_category AS shipping_category_38, p0_.created_at AS created_at_39, p0_.updated_at AS updated_at_40, p0_.created_by AS created_by_41, p0_.updated_by AS updated_by_42, p0_.deleted_by AS deleted_by_43, p6_.id AS id_44, p6_.name AS name_45, p6_.description AS description_46, p6_.meta_title AS meta_title_47, p6_.meta_description AS meta_description_48, p6_.meta_keywords AS meta_keywords_49, p6_.slug AS slug_50, p6_.short_description AS short_description_51, p6_.short_description_textile AS short_description_textile_52, p6_.short_description_color AS short_description_color_53, p6_.short_function_description AS short_function_description_54, p6_.search_engine AS search_engine_55, p6_.photo3d_gallery_url AS photo3d_gallery_url_56, p6_.youtube_gallery_url AS youtube_gallery_url_57, p6_.trans_film AS trans_film_58, p6_.canonical AS canonical_59, p6_.photo3d_additional AS photo3d_additional_60, p6_.locale AS locale_61, p1_.id AS id_62, p1_.visible AS visible_63, p1_.price_description AS price_description_64, p1_.promotion AS promotion_65, p1_.is_new AS is_new_66, p1_.bestseller AS bestseller_67, p1_.promote_one_homepage AS promote_one_homepage_68, p1_.ready_for_publication AS ready_for_publication_69, p1_.sale AS sale_70, p1_.rating_value AS rating_value_71, p1_.review_count AS review_count_72, p1_.price_change AS price_change_73, p1_.priority AS priority_74, p1_.price_crossed AS price_crossed_75, p1_.omnibus_price AS omnibus_price_76, p1_.promotion_icon AS promotion_icon_77, p1_.promo_price AS promo_price_78, l7_.id AS id_79, l7_.locale AS locale_80, l7_.domain AS domain_81, l7_.is_active AS is_active_82, l7_.is_default AS is_default_83, l7_.helpline AS helpline_84, l7_.rounding_precision AS rounding_precision_85, l7_.phone AS phone_86, l7_.address AS address_87, l7_.shop_name AS shop_name_88, l7_.email AS email_89, l7_.facebook AS facebook_90, l7_.instagram AS instagram_91, l7_.youtube AS youtube_92, l7_.store_url AS store_url_93, l7_.password_protected AS password_protected_94, l7_.store_password AS store_password_95, l7_.fb_pixel AS fb_pixel_96, l7_.fb_token AS fb_token_97, l7_.is_comments AS is_comments_98, l7_.send_comment_request_days AS send_comment_request_days_99, l7_.store_email AS store_email_100, l7_.admin_store_email AS admin_store_email_101, l7_.complaint_email AS complaint_email_102, l7_.product_return_email AS product_return_email_103, l7_.getresponse_campaign_id AS getresponse_campaign_id_104, l7_.created_at AS created_at_105, l7_.updated_at AS updated_at_106, l7_.created_by AS created_by_107, l7_.updated_by AS updated_by_108, l7_.deleted_by AS deleted_by_109, c5_.id AS id_110, c5_.sign AS sign_111, c5_.currency_separator AS currency_separator_112, c5_.position_price AS position_price_113, c5_.is_default AS is_default_114, c5_.is_active AS is_active_115, c5_.factorPln AS factorPln_116, c5_.iso_code AS iso_code_117, c5_.created_at AS created_at_118, c5_.updated_at AS updated_at_119, c5_.created_by AS created_by_120, c5_.updated_by AS updated_by_121, c5_.deleted_by AS deleted_by_122, a8_.id AS id_123, a8_.is_visible AS is_visible_124, a8_.is_currentyly_unavailable AS is_currentyly_unavailable_125, a8_.days AS days_126, a8_.ceneo_days AS ceneo_days_127, a8_.internal_name AS internal_name_128, a8_.created_at AS created_at_129, a8_.updated_at AS updated_at_130, a8_.created_by AS created_by_131, a8_.updated_by AS updated_by_132, a8_.deleted_by AS deleted_by_133, a9_.id AS id_134, a9_.name AS name_135, a9_.locale AS locale_136, p10_.id AS id_137, p10_.name AS name_138, p10_.responsible_entity AS responsible_entity_139, p10_.image_name AS image_name_140, p10_.created_at AS created_at_141, p10_.updated_at AS updated_at_142, p10_.created_by AS created_by_143, p10_.updated_by AS updated_by_144, p10_.deleted_by AS deleted_by_145, p3_.id AS id_146, p3_.main AS main_147, p3_.lifestyle AS lifestyle_148, p3_.hover AS hover_149, p3_.name AS name_150, p3_.image_name AS image_name_151, p3_.position AS position_152, p3_.alt AS alt_153, p3_.image_custom_name AS image_custom_name_154, l11_.id AS id_155, l11_.locale AS locale_156, l11_.domain AS domain_157, l11_.is_active AS is_active_158, l11_.is_default AS is_default_159, l11_.helpline AS helpline_160, l11_.rounding_precision AS rounding_precision_161, l11_.phone AS phone_162, l11_.address AS address_163, l11_.shop_name AS shop_name_164, l11_.email AS email_165, l11_.facebook AS facebook_166, l11_.instagram AS instagram_167, l11_.youtube AS youtube_168, l11_.store_url AS store_url_169, l11_.password_protected AS password_protected_170, l11_.store_password AS store_password_171, l11_.fb_pixel AS fb_pixel_172, l11_.fb_token AS fb_token_173, l11_.is_comments AS is_comments_174, l11_.send_comment_request_days AS send_comment_request_days_175, l11_.store_email AS store_email_176, l11_.admin_store_email AS admin_store_email_177, l11_.complaint_email AS complaint_email_178, l11_.product_return_email AS product_return_email_179, l11_.getresponse_campaign_id AS getresponse_campaign_id_180, l11_.created_at AS created_at_181, l11_.updated_at AS updated_at_182, l11_.created_by AS created_by_183, l11_.updated_by AS updated_by_184, l11_.deleted_by AS deleted_by_185, p12_.id AS id_186, p12_.price AS price_187, p12_.discount AS discount_188, p12_.old_price AS old_price_189, p12_.active AS active_190, p12_.automatic_price_comment AS automatic_price_comment_191, p12_.ean AS ean_192, p12_.automatic_price AS automatic_price_193, p12_.automatic_price_discount AS automatic_price_discount_194, p12_.created_at AS created_at_195, p12_.updated_at AS updated_at_196, p12_.created_by AS created_by_197, p12_.updated_by AS updated_by_198, p12_.deleted_by AS deleted_by_199, p0_.product_family_id AS product_family_id_200, p0_.product_producer_id AS product_producer_id_201, p0_.availability_id AS availability_id_202, p0_.main_category_id AS main_category_id_203, p6_.translatable_id AS translatable_id_204, p1_.product_id AS product_id_205, p1_.language AS language_206, p1_.vat_id AS vat_id_207, p1_.availability_id AS availability_id_208, p1_.product_producer_id AS product_producer_id_209, l7_.currency_id AS currency_id_210, a9_.translatable_id AS translatable_id_211, p3_.product_id AS product_id_212, l11_.currency_id AS currency_id_213, p12_.product_id AS product_id_214, p12_.parent_product_price_id AS parent_product_price_id_215, p12_.currency_id AS currency_id_216, p12_.language AS language_217 FROM product p0_ INNER JOIN product_translation p6_ ON p0_.id = p6_.translatable_id INNER JOIN product_lang_param p1_ ON p0_.id = p1_.product_id INNER JOIN language l7_ ON p1_.language = l7_.id INNER JOIN product_vat p4_ ON p1_.vat_id = p4_.id INNER JOIN currency c5_ ON l7_.currency_id = c5_.id INNER JOIN availability a8_ ON p1_.availability_id = a8_.id INNER JOIN availability_translation a9_ ON a8_.id = a9_.translatable_id INNER JOIN product_producer p10_ ON p1_.product_producer_id = p10_.id INNER JOIN product_photo p3_ ON p0_.id = p3_.product_id LEFT JOIN product_photo p2_ ON p0_.id = p2_.product_id AND (p2_.lifestyle = 1) INNER JOIN product_photo_language p13_ ON p3_.id = p13_.product_photo_id INNER JOIN language l11_ ON l11_.id = p13_.language_id LEFT JOIN product_price p12_ ON p0_.id = p12_.product_id LEFT JOIN language l14_ ON p12_.language = l14_.id WHERE p6_.locale = ? AND a9_.locale = ? AND l14_.locale = ? AND a8_.deleted_by IS NULL AND (p3_.main = ?) AND l11_.locale = ? AND l7_.locale = ? AND p12_.deleted_by IS NULL AND p0_.deleted_by IS NULL AND p1_.visible = ? AND (p1_.promotion = ?) ORDER BY p0_.id DESC, p3_.position ASC
[ "pl" "pl" "pl" true "pl" "pl" true true ] |
|
doctrine |
SELECT t0.id AS id_1, t0.name AS name_2, t0.header AS header_3, t0.description AS description_4, t0.visible AS visible_5, t0.special_for_buy_cheaper AS special_for_buy_cheaper_6, t0.slug AS slug_7, t0.redirect AS redirect_8, t0.meta_title AS meta_title_9, t0.meta_description AS meta_description_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.created_by AS created_by_13, t0.updated_by AS updated_by_14, t0.deleted_by AS deleted_by_15, t0.top_banner_id AS top_banner_id_16, t0.language_id AS language_id_17, t0.product_producer_id AS product_producer_id_18, t0.banner_id AS banner_id_19 FROM landing_page t0 WHERE t0.id = ?
[
228
]
|
|
doctrine |
SELECT b0_.id AS id_0, b0_.name AS name_1, b0_.title AS title_2, b0_.banner_type AS banner_type_3, b0_.visible AS visible_4, b0_.visible_in_promotions AS visible_in_promotions_5, b0_.url AS url_6, b0_.position AS position_7, b0_.color AS color_8, b0_.additional_text AS additional_text_9, b0_.button_color AS button_color_10, b0_.button_text_color AS button_text_color_11, b0_.campaign_text_color AS campaign_text_color_12, b0_.button_text AS button_text_13, b0_.bottom_button_text AS bottom_button_text_14, b0_.bottom_button_text_color AS bottom_button_text_color_15, b0_.bottom_button_color AS bottom_button_color_16, b0_.bottom_background_color AS bottom_background_color_17, b0_.bottom_text_color AS bottom_text_color_18, b0_.image_name AS image_name_19, b0_.created_at AS created_at_20, b0_.updated_at AS updated_at_21, b0_.created_by AS created_by_22, b0_.updated_by AS updated_by_23, b0_.deleted_by AS deleted_by_24, b0_.language AS language_25 FROM banners b0_ INNER JOIN language l1_ ON b0_.language = l1_.id WHERE l1_.locale = ? AND b0_.deleted_by IS NULL AND b0_.visible = ? AND b0_.button_text IS NOT NULL AND b0_.visible_in_promotions = ? ORDER BY b0_.position ASC
[ "pl" true true ] |
|
doctrine | SELECT t0.id AS id_1, t0.shipping_cost AS shipping_cost_2, t0.session AS session_3, t0.ip AS ip_4, t0.user_agent AS user_agent_5, t0.rebate_code_content AS rebate_code_content_6, t0.removed_products_notiication AS removed_products_notiication_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.created_by AS created_by_10, t0.updated_by AS updated_by_11, t0.deleted_by AS deleted_by_12, t0.user_id AS user_id_13, t0.delivery_country_id AS delivery_country_id_14, t0.language_id AS language_id_15, t0.delivery_method_id AS delivery_method_id_16, t0.payment_method_id AS payment_method_id_17, t0.rebate_code_id AS rebate_code_id_18 FROM cart t0 WHERE t0.session IS NULL LIMIT 1 | |
doctrine |
SELECT t0.id AS id_1, t0.quantity AS quantity_2, t0.inscription AS inscription_3, t0.price AS price_4, t0.session AS session_5, t0.code AS code_6, t0.price_initial AS price_initial_7, t0.price_net AS price_net_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.created_by AS created_by_11, t0.updated_by AS updated_by_12, t0.deleted_by AS deleted_by_13, t0.cart_id AS cart_id_14, t0.product_id AS product_id_15, t0.sub_product_id AS sub_product_id_16, t0.currency_id AS currency_id_17, t0.vat_id AS vat_id_18, t0.variant_id AS variant_id_19 FROM cart_product t0 WHERE t0.cart_id = ? ORDER BY t0.id DESC
[
239957
]
|
|
doctrine |
SELECT t0_.id AS id_0, t0_.name AS name_1, t0_.is_active AS is_active_2, t0_.text_left AS text_left_3, t0_.text_right AS text_right_4, t0_.url AS url_5, t0_.background AS background_6, t0_.text_color AS text_color_7, t0_.end_date AS end_date_8, t0_.created_at AS created_at_9, t0_.updated_at AS updated_at_10, t0_.created_by AS created_by_11, t0_.updated_by AS updated_by_12, t0_.deleted_by AS deleted_by_13, t0_.language AS language_14 FROM top_banner t0_ INNER JOIN language l1_ ON t0_.language = l1_.id WHERE t0_.deleted_by IS NULL AND l1_.locale = ? AND t0_.is_active = ?
[ "pl" true ] |
|
doctrine | SELECT t0.id AS id_1, t0.session AS session_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.product_id AS product_id_5 FROM compare_product t0 WHERE t0.session IS NULL | |
doctrine |
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.domain AS domain_3, t0.is_active AS is_active_4, t0.is_default AS is_default_5, t0.helpline AS helpline_6, t0.rounding_precision AS rounding_precision_7, t0.phone AS phone_8, t0.address AS address_9, t0.shop_name AS shop_name_10, t0.email AS email_11, t0.facebook AS facebook_12, t0.instagram AS instagram_13, t0.youtube AS youtube_14, t0.store_url AS store_url_15, t0.password_protected AS password_protected_16, t0.store_password AS store_password_17, t0.fb_pixel AS fb_pixel_18, t0.fb_token AS fb_token_19, t0.is_comments AS is_comments_20, t0.send_comment_request_days AS send_comment_request_days_21, t0.store_email AS store_email_22, t0.admin_store_email AS admin_store_email_23, t0.complaint_email AS complaint_email_24, t0.product_return_email AS product_return_email_25, t0.getresponse_campaign_id AS getresponse_campaign_id_26, t0.created_at AS created_at_27, t0.updated_at AS updated_at_28, t0.created_by AS created_by_29, t0.updated_by AS updated_by_30, t0.deleted_by AS deleted_by_31, t0.currency_id AS currency_id_32 FROM language t0 WHERE t0.deleted_by IS NULL AND t0.locale = ? LIMIT 1
[
"pl"
]
|
|
doctrine |
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.meta_title AS meta_title_4, t0.meta_description AS meta_description_5, t0.meta_keywords AS meta_keywords_6, t0.custom_h1 AS custom_h1_7, t0.canonical AS canonical_8, t0.slug AS slug_9, t0.google_product_type AS google_product_type_10, t0.google_product_category AS google_product_category_11, t0.special_product_category AS special_product_category_12, t0.locale AS locale_13, t0.translatable_id AS translatable_id_14 FROM category_translation t0 WHERE t0.translatable_id = ?
[
121
]
|
|
doctrine |
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.meta_title AS meta_title_4, t0.meta_description AS meta_description_5, t0.meta_keywords AS meta_keywords_6, t0.custom_h1 AS custom_h1_7, t0.canonical AS canonical_8, t0.slug AS slug_9, t0.google_product_type AS google_product_type_10, t0.google_product_category AS google_product_category_11, t0.special_product_category AS special_product_category_12, t0.locale AS locale_13, t0.translatable_id AS translatable_id_14 FROM category_translation t0 WHERE t0.translatable_id = ?
[
237
]
|
|
event |
Notified event "kernel.response" to listener "App\Listener\GenerateCookieListener::onKernelResponse" .
[ "event" => "kernel.response" "listener" => "App\Listener\GenerateCookieListener::onKernelResponse" ] |
|
event |
Notified event "kernel.response" to listener "Symfony\Component\HttpKernel\EventListener\ResponseListener::onKernelResponse" .
[ "event" => "kernel.response" "listener" => "Symfony\Component\HttpKernel\EventListener\ResponseListener::onKernelResponse" ] |
|
event |
Notified event "kernel.response" to listener "Symfony\Component\HttpKernel\DataCollector\RequestDataCollector::onKernelResponse" .
[ "event" => "kernel.response" "listener" => "Symfony\Component\HttpKernel\DataCollector\RequestDataCollector::onKernelResponse" ] |
|
event |
Notified event "kernel.response" to listener "Symfony\Component\WebLink\EventListener\AddLinkHeaderListener::onKernelResponse" .
[ "event" => "kernel.response" "listener" => "Symfony\Component\WebLink\EventListener\AddLinkHeaderListener::onKernelResponse" ] |
|
event |
Notified event "kernel.response" to listener "Sensio\Bundle\FrameworkExtraBundle\EventListener\HttpCacheListener::onKernelResponse" .
[ "event" => "kernel.response" "listener" => "Sensio\Bundle\FrameworkExtraBundle\EventListener\HttpCacheListener::onKernelResponse" ] |
|
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" ] |
|
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" ] |
|
event |
Notified event "kernel.response" to listener "Symfony\Component\HttpKernel\EventListener\ProfilerListener::onKernelResponse" .
[ "event" => "kernel.response" "listener" => "Symfony\Component\HttpKernel\EventListener\ProfilerListener::onKernelResponse" ] |
|
event |
Notified event "kernel.response" to listener "Symfony\Bundle\WebProfilerBundle\EventListener\WebDebugToolbarListener::onKernelResponse" .
[ "event" => "kernel.response" "listener" => "Symfony\Bundle\WebProfilerBundle\EventListener\WebDebugToolbarListener::onKernelResponse" ] |
|
event |
Notified event "kernel.response" to listener "Symfony\Component\HttpKernel\EventListener\SessionListener::onKernelResponse" .
[ "event" => "kernel.response" "listener" => "Symfony\Component\HttpKernel\EventListener\SessionListener::onKernelResponse" ] |
|
event |
Notified event "kernel.response" to listener "Symfony\Component\HttpKernel\EventListener\StreamedResponseListener::onKernelResponse" .
[ "event" => "kernel.response" "listener" => "Symfony\Component\HttpKernel\EventListener\StreamedResponseListener::onKernelResponse" ] |
|
event |
Notified event "kernel.finish_request" to listener "Symfony\Component\HttpKernel\EventListener\LocaleListener::onKernelFinishRequest" .
[ "event" => "kernel.finish_request" "listener" => "Symfony\Component\HttpKernel\EventListener\LocaleListener::onKernelFinishRequest" ] |
|
event |
Notified event "kernel.finish_request" to listener "Symfony\Component\HttpKernel\EventListener\SessionListener::onFinishRequest" .
[ "event" => "kernel.finish_request" "listener" => "Symfony\Component\HttpKernel\EventListener\SessionListener::onFinishRequest" ] |
|
event |
Notified event "kernel.finish_request" to listener "Symfony\Component\HttpKernel\EventListener\TranslatorListener::onKernelFinishRequest" .
[ "event" => "kernel.finish_request" "listener" => "Symfony\Component\HttpKernel\EventListener\TranslatorListener::onKernelFinishRequest" ] |
|
event |
Notified event "kernel.finish_request" to listener "Symfony\Component\HttpKernel\EventListener\RouterListener::onKernelFinishRequest" .
[ "event" => "kernel.finish_request" "listener" => "Symfony\Component\HttpKernel\EventListener\RouterListener::onKernelFinishRequest" ] |
|
event |
Notified event "kernel.finish_request" to listener "Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener::onKernelFinishRequest" .
[ "event" => "kernel.finish_request" "listener" => "Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener::onKernelFinishRequest" ] |
|
event |
Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\DebugHandlersListener::configure" .
[ "event" => "kernel.request" "listener" => "Symfony\Component\HttpKernel\EventListener\DebugHandlersListener::configure" ] |
|
event |
Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\ValidateRequestListener::onKernelRequest" .
[ "event" => "kernel.request" "listener" => "Symfony\Component\HttpKernel\EventListener\ValidateRequestListener::onKernelRequest" ] |
|
event |
Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\SessionListener::onKernelRequest" .
[ "event" => "kernel.request" "listener" => "Symfony\Component\HttpKernel\EventListener\SessionListener::onKernelRequest" ] |
|
event |
Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\RouterListener::onKernelRequest" .
[ "event" => "kernel.request" "listener" => "Symfony\Component\HttpKernel\EventListener\RouterListener::onKernelRequest" ] |
|
event |
Notified event "kernel.request" to listener "Symfony\Bundle\FrameworkBundle\EventListener\ResolveControllerNameSubscriber::onKernelRequest" .
[ "event" => "kernel.request" "listener" => "Symfony\Bundle\FrameworkBundle\EventListener\ResolveControllerNameSubscriber::onKernelRequest" ] |
|
event |
Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\LocaleListener::onKernelRequest" .
[ "event" => "kernel.request" "listener" => "Symfony\Component\HttpKernel\EventListener\LocaleListener::onKernelRequest" ] |
|
event |
Notified event "kernel.request" to listener "FOS\RestBundle\EventListener\BodyListener::onKernelRequest" .
[ "event" => "kernel.request" "listener" => "FOS\RestBundle\EventListener\BodyListener::onKernelRequest" ] |
|
event |
Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\TranslatorListener::onKernelRequest" .
[ "event" => "kernel.request" "listener" => "Symfony\Component\HttpKernel\EventListener\TranslatorListener::onKernelRequest" ] |
|
event |
Notified event "kernel.request" to listener "Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener::onKernelRequest" .
[ "event" => "kernel.request" "listener" => "Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener::onKernelRequest" ] |
|
event |
Notified event "kernel.request" to listener "Knp\Bundle\PaginatorBundle\Subscriber\SlidingPaginationSubscriber::onKernelRequest" .
[ "event" => "kernel.request" "listener" => "Knp\Bundle\PaginatorBundle\Subscriber\SlidingPaginationSubscriber::onKernelRequest" ] |
|
event |
Notified event "kernel.request" to listener "App\Listener\RequestListener::onKernelRequest" .
[ "event" => "kernel.request" "listener" => "App\Listener\RequestListener::onKernelRequest" ] |
|
event |
Notified event "kernel.controller" to listener "Symfony\Bundle\FrameworkBundle\DataCollector\RouterDataCollector::onKernelController" .
[ "event" => "kernel.controller" "listener" => "Symfony\Bundle\FrameworkBundle\DataCollector\RouterDataCollector::onKernelController" ] |
|
event |
Notified event "kernel.controller" to listener "Symfony\Component\HttpKernel\DataCollector\RequestDataCollector::onKernelController" .
[ "event" => "kernel.controller" "listener" => "Symfony\Component\HttpKernel\DataCollector\RequestDataCollector::onKernelController" ] |
|
event |
Notified event "kernel.controller" to listener "Sensio\Bundle\FrameworkExtraBundle\EventListener\ControllerListener::onKernelController" .
[ "event" => "kernel.controller" "listener" => "Sensio\Bundle\FrameworkExtraBundle\EventListener\ControllerListener::onKernelController" ] |
|
event |
Notified event "kernel.controller" to listener "Sensio\Bundle\FrameworkExtraBundle\EventListener\ParamConverterListener::onKernelController" .
[ "event" => "kernel.controller" "listener" => "Sensio\Bundle\FrameworkExtraBundle\EventListener\ParamConverterListener::onKernelController" ] |
|
event |
Notified event "kernel.controller" to listener "Sensio\Bundle\FrameworkExtraBundle\EventListener\HttpCacheListener::onKernelController" .
[ "event" => "kernel.controller" "listener" => "Sensio\Bundle\FrameworkExtraBundle\EventListener\HttpCacheListener::onKernelController" ] |
|
event |
Notified event "kernel.controller" to listener "Sensio\Bundle\FrameworkExtraBundle\EventListener\TemplateListener::onKernelController" .
[ "event" => "kernel.controller" "listener" => "Sensio\Bundle\FrameworkExtraBundle\EventListener\TemplateListener::onKernelController" ] |
|
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" ] |
|
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" ] |
|
doctrine |
SELECT h0_.id AS id_0, h0_.day AS day_1, h0_.nb_of_the_day AS nb_of_the_day_2, h0_.created_at AS created_at_3, h0_.updated_at AS updated_at_4, h0_.created_by AS created_by_5, h0_.updated_by AS updated_by_6, h0_.deleted_by AS deleted_by_7, h1_.id AS id_8, h1_.name AS name_9, h1_.short_name AS short_name_10, h1_.locale AS locale_11, h1_.translatable_id AS translatable_id_12 FROM helpline_hours h0_ INNER JOIN helpline_hours_translation h1_ ON h0_.id = h1_.translatable_id WHERE h1_.locale = ? AND h0_.deleted_by IS NULL ORDER BY h0_.nb_of_the_day ASC
[
"pl"
]
|
|
doctrine |
SELECT a0_.id AS id_0, a0_.title AS title_1, a0_.content AS content_2, a0_.slug AS slug_3, a0_.created_at AS created_at_4, a0_.updated_at AS updated_at_5, a0_.created_by AS created_by_6, a0_.updated_by AS updated_by_7, a0_.deleted_by AS deleted_by_8, l1_.id AS id_9, l1_.locale AS locale_10, l1_.domain AS domain_11, l1_.is_active AS is_active_12, l1_.is_default AS is_default_13, l1_.helpline AS helpline_14, l1_.rounding_precision AS rounding_precision_15, l1_.phone AS phone_16, l1_.address AS address_17, l1_.shop_name AS shop_name_18, l1_.email AS email_19, l1_.facebook AS facebook_20, l1_.instagram AS instagram_21, l1_.youtube AS youtube_22, l1_.store_url AS store_url_23, l1_.password_protected AS password_protected_24, l1_.store_password AS store_password_25, l1_.fb_pixel AS fb_pixel_26, l1_.fb_token AS fb_token_27, l1_.is_comments AS is_comments_28, l1_.send_comment_request_days AS send_comment_request_days_29, l1_.store_email AS store_email_30, l1_.admin_store_email AS admin_store_email_31, l1_.complaint_email AS complaint_email_32, l1_.product_return_email AS product_return_email_33, l1_.getresponse_campaign_id AS getresponse_campaign_id_34, l1_.created_at AS created_at_35, l1_.updated_at AS updated_at_36, l1_.created_by AS created_by_37, l1_.updated_by AS updated_by_38, l1_.deleted_by AS deleted_by_39, a0_.language_id AS language_id_40, l1_.currency_id AS currency_id_41 FROM article_news a0_ INNER JOIN language l1_ ON a0_.language_id = l1_.id WHERE a0_.deleted_by IS NULL AND l1_.locale = ? ORDER BY a0_.id DESC
[
"pl"
]
|
|
doctrine |
SELECT a0_.id AS id_0, a0_.title AS title_1, a0_.content AS content_2, a0_.slug AS slug_3, a0_.header AS header_4, a0_.footer AS footer_5, a0_.created_at AS created_at_6, a0_.updated_at AS updated_at_7, a0_.created_by AS created_by_8, a0_.updated_by AS updated_by_9, a0_.deleted_by AS deleted_by_10, l1_.id AS id_11, l1_.locale AS locale_12, l1_.domain AS domain_13, l1_.is_active AS is_active_14, l1_.is_default AS is_default_15, l1_.helpline AS helpline_16, l1_.rounding_precision AS rounding_precision_17, l1_.phone AS phone_18, l1_.address AS address_19, l1_.shop_name AS shop_name_20, l1_.email AS email_21, l1_.facebook AS facebook_22, l1_.instagram AS instagram_23, l1_.youtube AS youtube_24, l1_.store_url AS store_url_25, l1_.password_protected AS password_protected_26, l1_.store_password AS store_password_27, l1_.fb_pixel AS fb_pixel_28, l1_.fb_token AS fb_token_29, l1_.is_comments AS is_comments_30, l1_.send_comment_request_days AS send_comment_request_days_31, l1_.store_email AS store_email_32, l1_.admin_store_email AS admin_store_email_33, l1_.complaint_email AS complaint_email_34, l1_.product_return_email AS product_return_email_35, l1_.getresponse_campaign_id AS getresponse_campaign_id_36, l1_.created_at AS created_at_37, l1_.updated_at AS updated_at_38, l1_.created_by AS created_by_39, l1_.updated_by AS updated_by_40, l1_.deleted_by AS deleted_by_41, a0_.language_id AS language_id_42, l1_.currency_id AS currency_id_43 FROM article a0_ INNER JOIN language l1_ ON a0_.language_id = l1_.id WHERE a0_.deleted_by IS NULL AND l1_.locale = ?
[
"pl"
]
|
|
doctrine |
SELECT c0_.id AS id_0, c0_.level AS level_1, c0_.position AS position_2, c0_.alt AS alt_3, c0_.image_custom_name AS image_custom_name_4, c0_.image_name_2 AS image_name_2_5, c0_.image_name_3 AS image_name_3_6, c0_.image_name AS image_name_7, c0_.created_at AS created_at_8, c0_.updated_at AS updated_at_9, c0_.created_by AS created_by_10, c0_.updated_by AS updated_by_11, c0_.deleted_by AS deleted_by_12, c1_.id AS id_13, c1_.name AS name_14, c1_.description AS description_15, c1_.meta_title AS meta_title_16, c1_.meta_description AS meta_description_17, c1_.meta_keywords AS meta_keywords_18, c1_.custom_h1 AS custom_h1_19, c1_.canonical AS canonical_20, c1_.slug AS slug_21, c1_.google_product_type AS google_product_type_22, c1_.google_product_category AS google_product_category_23, c1_.special_product_category AS special_product_category_24, c1_.locale AS locale_25, c0_.category_parent_id AS category_parent_id_26, c1_.translatable_id AS translatable_id_27 FROM category c0_ INNER JOIN category_translation c1_ ON c0_.id = c1_.translatable_id INNER JOIN category_lang_param c2_ ON c0_.id = c2_.category_id INNER JOIN language l3_ ON c2_.language = l3_.id WHERE c1_.locale = ? AND l3_.locale = ? AND c2_.shortcut = ? AND c0_.deleted_by IS NULL AND c2_.visible = ? AND c0_.category_parent_id IS NULL ORDER BY c2_.position ASC
[ "pl" "pl" 1 true ] |
|
doctrine |
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.domain AS domain_3, t0.is_active AS is_active_4, t0.is_default AS is_default_5, t0.helpline AS helpline_6, t0.rounding_precision AS rounding_precision_7, t0.phone AS phone_8, t0.address AS address_9, t0.shop_name AS shop_name_10, t0.email AS email_11, t0.facebook AS facebook_12, t0.instagram AS instagram_13, t0.youtube AS youtube_14, t0.store_url AS store_url_15, t0.password_protected AS password_protected_16, t0.store_password AS store_password_17, t0.fb_pixel AS fb_pixel_18, t0.fb_token AS fb_token_19, t0.is_comments AS is_comments_20, t0.send_comment_request_days AS send_comment_request_days_21, t0.store_email AS store_email_22, t0.admin_store_email AS admin_store_email_23, t0.complaint_email AS complaint_email_24, t0.product_return_email AS product_return_email_25, t0.getresponse_campaign_id AS getresponse_campaign_id_26, t0.created_at AS created_at_27, t0.updated_at AS updated_at_28, t0.created_by AS created_by_29, t0.updated_by AS updated_by_30, t0.deleted_by AS deleted_by_31, t0.currency_id AS currency_id_32 FROM language t0 WHERE t0.deleted_by IS NULL AND t0.locale = ? LIMIT 1
[
"pl"
]
|
|
doctrine |
SELECT b0_.id AS id_0, b0_.title AS title_1, b0_.content AS content_2, b0_.meta_title AS meta_title_3, b0_.meta_description AS meta_description_4, b0_.meta_keywords AS meta_keywords_5, b0_.alt AS alt_6, b0_.image_custom_name AS image_custom_name_7, b0_.tags AS tags_8, b0_.slug AS slug_9, b0_.visible AS visible_10, b0_.special AS special_11, b0_.image_name AS image_name_12, b0_.created_at AS created_at_13, b0_.updated_at AS updated_at_14, b0_.created_by AS created_by_15, b0_.updated_by AS updated_by_16, b0_.deleted_by AS deleted_by_17, l1_.id AS id_18, l1_.locale AS locale_19, l1_.domain AS domain_20, l1_.is_active AS is_active_21, l1_.is_default AS is_default_22, l1_.helpline AS helpline_23, l1_.rounding_precision AS rounding_precision_24, l1_.phone AS phone_25, l1_.address AS address_26, l1_.shop_name AS shop_name_27, l1_.email AS email_28, l1_.facebook AS facebook_29, l1_.instagram AS instagram_30, l1_.youtube AS youtube_31, l1_.store_url AS store_url_32, l1_.password_protected AS password_protected_33, l1_.store_password AS store_password_34, l1_.fb_pixel AS fb_pixel_35, l1_.fb_token AS fb_token_36, l1_.is_comments AS is_comments_37, l1_.send_comment_request_days AS send_comment_request_days_38, l1_.store_email AS store_email_39, l1_.admin_store_email AS admin_store_email_40, l1_.complaint_email AS complaint_email_41, l1_.product_return_email AS product_return_email_42, l1_.getresponse_campaign_id AS getresponse_campaign_id_43, l1_.created_at AS created_at_44, l1_.updated_at AS updated_at_45, l1_.created_by AS created_by_46, l1_.updated_by AS updated_by_47, l1_.deleted_by AS deleted_by_48, b0_.language AS language_49, l1_.currency_id AS currency_id_50 FROM blog b0_ INNER JOIN language l1_ ON b0_.language = l1_.id WHERE b0_.deleted_by IS NULL AND l1_.locale = ? AND b0_.visible = 1 ORDER BY b0_.id DESC
[
"pl"
]
|
|
event |
Notified event "kernel.response" to listener "App\Listener\GenerateCookieListener::onKernelResponse" .
[ "event" => "kernel.response" "listener" => "App\Listener\GenerateCookieListener::onKernelResponse" ] |
|
event |
Notified event "kernel.response" to listener "Symfony\Component\HttpKernel\EventListener\ResponseListener::onKernelResponse" .
[ "event" => "kernel.response" "listener" => "Symfony\Component\HttpKernel\EventListener\ResponseListener::onKernelResponse" ] |
|
event |
Notified event "kernel.response" to listener "Symfony\Component\HttpKernel\DataCollector\RequestDataCollector::onKernelResponse" .
[ "event" => "kernel.response" "listener" => "Symfony\Component\HttpKernel\DataCollector\RequestDataCollector::onKernelResponse" ] |
|
event |
Notified event "kernel.response" to listener "Symfony\Component\WebLink\EventListener\AddLinkHeaderListener::onKernelResponse" .
[ "event" => "kernel.response" "listener" => "Symfony\Component\WebLink\EventListener\AddLinkHeaderListener::onKernelResponse" ] |
|
event |
Notified event "kernel.response" to listener "Sensio\Bundle\FrameworkExtraBundle\EventListener\HttpCacheListener::onKernelResponse" .
[ "event" => "kernel.response" "listener" => "Sensio\Bundle\FrameworkExtraBundle\EventListener\HttpCacheListener::onKernelResponse" ] |
|
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" ] |
|
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" ] |
|
event |
Notified event "kernel.response" to listener "Symfony\Component\HttpKernel\EventListener\ProfilerListener::onKernelResponse" .
[ "event" => "kernel.response" "listener" => "Symfony\Component\HttpKernel\EventListener\ProfilerListener::onKernelResponse" ] |
|
event |
Notified event "kernel.response" to listener "Symfony\Bundle\WebProfilerBundle\EventListener\WebDebugToolbarListener::onKernelResponse" .
[ "event" => "kernel.response" "listener" => "Symfony\Bundle\WebProfilerBundle\EventListener\WebDebugToolbarListener::onKernelResponse" ] |
|
event |
Notified event "kernel.response" to listener "Symfony\Component\HttpKernel\EventListener\SessionListener::onKernelResponse" .
[ "event" => "kernel.response" "listener" => "Symfony\Component\HttpKernel\EventListener\SessionListener::onKernelResponse" ] |
|
event |
Notified event "kernel.response" to listener "Symfony\Component\HttpKernel\EventListener\StreamedResponseListener::onKernelResponse" .
[ "event" => "kernel.response" "listener" => "Symfony\Component\HttpKernel\EventListener\StreamedResponseListener::onKernelResponse" ] |
|
event |
Notified event "kernel.finish_request" to listener "Symfony\Component\HttpKernel\EventListener\LocaleListener::onKernelFinishRequest" .
[ "event" => "kernel.finish_request" "listener" => "Symfony\Component\HttpKernel\EventListener\LocaleListener::onKernelFinishRequest" ] |
|
event |
Notified event "kernel.finish_request" to listener "Symfony\Component\HttpKernel\EventListener\SessionListener::onFinishRequest" .
[ "event" => "kernel.finish_request" "listener" => "Symfony\Component\HttpKernel\EventListener\SessionListener::onFinishRequest" ] |
|
event |
Notified event "kernel.finish_request" to listener "Symfony\Component\HttpKernel\EventListener\TranslatorListener::onKernelFinishRequest" .
[ "event" => "kernel.finish_request" "listener" => "Symfony\Component\HttpKernel\EventListener\TranslatorListener::onKernelFinishRequest" ] |
|
event |
Notified event "kernel.finish_request" to listener "Symfony\Component\HttpKernel\EventListener\RouterListener::onKernelFinishRequest" .
[ "event" => "kernel.finish_request" "listener" => "Symfony\Component\HttpKernel\EventListener\RouterListener::onKernelFinishRequest" ] |
|
event |
Notified event "kernel.finish_request" to listener "Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener::onKernelFinishRequest" .
[ "event" => "kernel.finish_request" "listener" => "Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener::onKernelFinishRequest" ] |
PHP Notices 0
Log messages generated by PHP notices silenced with the @ operator.
There are no log messages of this level.
Container 2094
Log messages generated during the compilation of the service container.
Class | Messages |
---|---|
Liip\ImagineBundle\DependencyInjection\Compiler\LoadersCompilerPass
|
1 |
Liip\ImagineBundle\DependencyInjection\Compiler\FiltersCompilerPass
|
17 |
Liip\ImagineBundle\DependencyInjection\Compiler\PostProcessorsCompilerPass
|
4 |
Liip\ImagineBundle\DependencyInjection\Compiler\ResolversCompilerPass
|
2 |
Symfony\Component\DependencyInjection\Compiler\ResolveChildDefinitionsPass
|
588 |
Symfony\Component\DependencyInjection\Compiler\RemovePrivateAliasesPass
|
169 |
Symfony\Component\DependencyInjection\Compiler\ReplaceAliasByActualDefinitionPass
|
243 |
Symfony\Component\DependencyInjection\Compiler\RemoveAbstractDefinitionsPass
|
613 |
Symfony\Component\DependencyInjection\Compiler\RemoveUnusedDefinitionsPass
|
90 |
Symfony\Component\DependencyInjection\Compiler\InlineServiceDefinitionsPass
|
366 |
Symfony\Bundle\FrameworkBundle\DependencyInjection\Compiler\UnusedTagsPass
|
1 |