| # |
type |
message |
| 1 |  sfPatternRouting | Match route "lang_products_by_title" (/:culture/:idshop/:index/:title.html) for /de/38/T9300-005-L/bluza-z-bawelny-z-recyklingu-iqoniq-zion-155264.html with parameters array ( 'module' => 'products', 'action' => 'show', 'culture' => 'de', 'idshop' => '38', 'index' => 'T9300-005-L', 'title' => 'bluza-z-bawelny-z-recyklingu-iqoniq-zion-155264',) |
| 2 | Doctrine_Connection_Mysql | exec : SET NAMES 'UTF8' - () |
| 3 | Doctrine_Connection_Mysql | query : SELECT c.idconfig AS c__idconfig, c.option_name AS c__option_name, c.option_value AS c__option_value FROM config_system c - () |
| 4 | Doctrine_Connection_Statement | execute : SELECT p.idshop AS p__idshop, p.active AS p__active, p.name_application AS p__name_application, p.phone_infoline AS p__phone_infoline, p.phone_landline AS p__phone_landline, p.phone_mobile AS p__phone_mobile, p.contact_mail AS p__contact_mail, p.title AS p__title, p.body_script AS p__body_script, p.head_script AS p__head_script, p.homepage_products_count_row AS p__homepage_products_count_row, p.ms_lang_install_signature AS p__ms_lang_install_signature, p.layout AS p__layout, p.meta_keywords AS p__meta_keywords, p.meta_description AS p__meta_description, p.image_thumb_width AS p__image_thumb_width, p.breadcrumbs_name AS p__breadcrumbs_name, p.breadcrumbs_title AS p__breadcrumbs_title, p.css AS p__css, p.js AS p__js, p.enabled_compress AS p__enabled_compress, p.google_robots_status AS p__google_robots_status, p.option_menu_exclude_catalog AS p__option_menu_exclude_catalog, p.option_price_type AS p__option_price_type, p.option_ssl AS p__option_ssl, p.products_shop_templates_idproducts_shop_temp AS p__products_shop_templates_idproducts_shop_temp, p.option_promotion AS p__option_promotion, p.title_additional AS p__title_additional, p.option_promotion_discount_code AS p__option_promotion_discount_code, p.option_lang_enabled AS p__option_lang_enabled, p.option_gus_validation AS p__option_gus_validation, p.option_products_view_only_cannonical_master AS p__option_products_view_only_cannonical_master, p.option_section_bestseller AS p__option_section_bestseller, p.option_section_news AS p__option_section_news, p.option_products_page_card_info AS p__option_products_page_card_info, p.option_products_page_card_marking AS p__option_products_page_card_marking, p.option_products_menu_version AS p__option_products_menu_version, p.option_short_url AS p__option_short_url, p.no_required_nip AS p__no_required_nip, p.idms_currency_type AS p__idms_currency_type, p.option_section_promo AS p__option_section_promo, m.ms_lang_install_signature AS m__ms_lang_install_signature, m.products_shop_idshop AS m__products_shop_idshop, m.lang_title AS m__lang_title, m.lang_meta_keywords AS m__lang_meta_keywords, m.lang_meta_description AS m__lang_meta_description, m.lang_title_additional AS m__lang_title_additional, m.lang_head_script AS m__lang_head_script, m.lang_body_script AS m__lang_body_script, m.lang_option_slideshow_html AS m__lang_option_slideshow_html FROM products_shop p LEFT JOIN ms_products_shop_i18n m ON p.idshop = m.products_shop_idshop AND (m.ms_lang_install_signature = ?) WHERE (p.name_application = ?) - (de, gifterso.de) |
| 5 | Doctrine_Connection_Statement | execute : SELECT m.ms_lang_install_signature AS m__ms_lang_install_signature, m.products_shop_idshop AS m__products_shop_idshop, m2.idlang_install AS m2__idlang_install, m2.name AS m2__name, m2.signature AS m2__signature, m2.publication AS m2__publication, m2.lang_icons AS m2__lang_icons FROM ms_lang_install_has_products_shop m INNER JOIN ms_lang_install m2 ON m.ms_lang_install_signature = m2.signature WHERE (m2.publication = ? AND m.products_shop_idshop = ?) - (1, 38) |
| 6 | Doctrine_Connection_Statement | execute : SELECT m.idms_products_shop_templates_text AS m__idms_products_shop_templates_text, m.text_name AS m__text_name, m.text_value AS m__text_value FROM ms_products_shop_templates_text m WHERE (m.products_shop_templates_idproducts_shop_temp = ?) - (14) |
| 7 | Doctrine_Connection_Statement | execute : SELECT m.idms_redirect_manager_deny_parameters AS m__idms_redirect_manager_deny_parameters, m.param_name AS m__param_name, m.created_at AS m__created_at, m.type AS m__type FROM ms_redirect_manager_deny_parameters m WHERE (m.type = ?) - (params) |
| 8 | Doctrine_Connection_Statement | execute : SELECT m.idms_redirect_manager_deny_parameters AS m__idms_redirect_manager_deny_parameters, m.param_name AS m__param_name, m.created_at AS m__created_at, m.type AS m__type FROM ms_redirect_manager_deny_parameters m WHERE (m.type = ?) - (string) |
| 9 | Doctrine_Connection_Statement | execute : SELECT COUNT(*) AS num_results FROM products p WHERE p.product_index = ? - (show) |
| 10 | Doctrine_Connection_Statement | execute : SELECT m.source_url AS m__source_url, m.destination_url AS m__destination_url, m.status AS m__status, m.active AS m__active, m.comment AS m__comment, m.redirect_type AS m__redirect_type, m.after_action AS m__after_action, m.created_at AS m__created_at, m.idms_redirect_manager AS m__idms_redirect_manager FROM ms_redirect_manager m WHERE (m.source_url = ? AND m.active = ?) - (https://gifterso.de/de/38/T9300-005-L/bluza-z-bawelny-z-recyklingu-iqoniq-zion-155264.html, 1) |
| 11 | Doctrine_Connection_Statement | execute : SELECT m.idlang_install AS m__idlang_install, m.name AS m__name, m.signature AS m__signature, m.publication AS m__publication, m.lang_icons AS m__lang_icons FROM ms_lang_install m WHERE (m.signature = ?) LIMIT 1 - (de) |
| 12 | sfFilterChain | Executing filter "sfRenderingFilter" |
| 13 | sfFilterChain | Executing filter "sfCacheFilter" |
| 14 | sfFilterChain | Executing filter "sfExecutionFilter" |
| 15 | productsActions | Call "productsActions->executeShow()" |
| 16 | Doctrine_Connection_Statement | execute : SELECT p.idproducts AS p__idproducts, p.name AS p__name, p.body AS p__body, p.active AS p__active, p.product_index AS p__product_index, p.created_at AS p__created_at, p.price AS p__price, p.price_promotion AS p__price_promotion, p.price_wholesaler AS p__price_wholesaler, p.price_thresholds AS p__price_thresholds, p.products_manufacturer_idproducts_manufacturer AS p__products_manufacturer_idproducts_manufacturer, p.products_status_idproducts_status AS p__products_status_idproducts_status, p.products_unit_idproducts_unit AS p__products_unit_idproducts_unit, p.products_tax_idproducts_tax AS p__products_tax_idproducts_tax, p.no_premium AS p__no_premium, p.price_min_wholeseller AS p__price_min_wholeseller, p.price_min_regular AS p__price_min_regular, p.price_buy AS p__price_buy, p.catalogue_price AS p__catalogue_price, p.body_weight AS p__body_weight, p.body_size AS p__body_size, p.body_material AS p__body_material, p.body_print_tech AS p__body_print_tech, p.body_print_size AS p__body_print_size, p.body_handling AS p__body_handling, p.ms_products_color_idms_products_color AS p__ms_products_color_idms_products_color, p.name_url AS p__name_url, p.last_update AS p__last_update, p.type AS p__type, p.import_photo AS p__import_photo, p.color_hex AS p__color_hex, p.color_manu AS p__color_manu, p.last_update_prev_price_buy AS p__last_update_prev_price_buy, p.last_update_prev AS p__last_update_prev, p.id_product_manufacturer AS p__id_product_manufacturer, p.model_product_manufacturer AS p__model_product_manufacturer, p.price_brutto AS p__price_brutto, p.meta_link_canonical AS p__meta_link_canonical, p.code_product_manufacturer AS p__code_product_manufacturer, p.tags AS p__tags, p.slug AS p__slug, p.show_on_store AS p__show_on_store, p.ms_product_index AS p__ms_product_index, p.price_range_divisor AS p__price_range_divisor, p.merchant_status AS p__merchant_status, p.idproducts_sync AS p__idproducts_sync, p.disable_price_calculation AS p__disable_price_calculation, p.gratisownia_shop_menu_names AS p__gratisownia_shop_menu_names FROM products p WHERE (p.product_index = ? OR p.ms_product_index = ?) - (T9300-005-L, T9300-005-L) |
| 17 | Doctrine_Connection_Statement | execute : SELECT c.idconfig AS c__idconfig, c.option_name AS c__option_name, c.option_value AS c__option_value FROM config_system c WHERE (c.option_name = ?) - (min_printing_await_time_in_days) |
| 18 | Doctrine_Connection_Statement | execute : SELECT c.idconfig AS c__idconfig, c.option_name AS c__option_name, c.option_value AS c__option_value FROM config_system c WHERE (c.option_name = ?) - (max_printing_await_time_in_days) |
| 19 | Doctrine_Connection_Statement | execute : SELECT m.ms_lang_install_signature AS m__ms_lang_install_signature, m.products_shop_idshop AS m__products_shop_idshop, m2.idlang_install AS m2__idlang_install, m2.name AS m2__name, m2.signature AS m2__signature, m2.publication AS m2__publication, m2.lang_icons AS m2__lang_icons FROM ms_lang_install_has_products_shop m INNER JOIN ms_lang_install m2 ON m.ms_lang_install_signature = m2.signature WHERE (m2.publication = ? AND m.products_shop_idshop = ?) - (1, 38) |
| 20 | Doctrine_Connection_Statement | execute : SELECT p.idproducts AS p__idproducts, p.product_index AS p__product_index, p.price_brutto AS p__price_brutto, p.meta_link_canonical AS p__meta_link_canonical FROM products p WHERE (p.product_index = ?) - (T9300-005-L) |
| 21 | Doctrine_Connection_Statement | execute : SELECT m.ms_lang_install_signature AS m__ms_lang_install_signature, m.products_shop_idshop AS m__products_shop_idshop, m2.idlang_install AS m2__idlang_install, m2.name AS m2__name, m2.signature AS m2__signature, m2.publication AS m2__publication, m2.lang_icons AS m2__lang_icons FROM ms_lang_install_has_products_shop m INNER JOIN ms_lang_install m2 ON m.ms_lang_install_signature = m2.signature WHERE (m2.publication = ? AND m.products_shop_idshop = ?) - (1, 38) |
| 22 | Doctrine_Connection_Statement | execute : SELECT p.idms_offer_creator_marking_type AS p__idms_offer_creator_marking_type, p.products_idproducts AS p__products_idproducts, m.idms_offer_creator_marking_type AS m__idms_offer_creator_marking_type, m.name_full AS m__name_full, m.max_color AS m__max_color FROM products_settings_marking_type p INNER JOIN ms_offer_creator_marking_type m ON p.idms_offer_creator_marking_type = m.idms_offer_creator_marking_type WHERE (p.products_idproducts = ? AND m.publication = ? AND (p.verified = ? OR p.verified = ?)) - (155264, 1, 1, 2) |
| 23 | Doctrine_Connection_Statement | execute : SELECT p.idproducts_location AS p__idproducts_location, p.products_category_idproducts_category AS p__products_category_idproducts_category FROM products_location p WHERE (p.products_shop_idshop = ? AND p.products_idproducts = ?) - (38, 155264) |
| 24 | Doctrine_Connection_Statement | execute : SELECT DISTINCT p5.idproducts_location FROM products_location p5 INNER JOIN products p6 ON p5.products_idproducts = p6.idproducts AND ((p6.active = ? AND show_on_store = ?)) INNER JOIN products_gallery p7 ON p6.idproducts = p7.products_idproducts AND (p7.http_status = ?) INNER JOIN products_price_range p8 ON p5.idproducts_location = p8.products_location_idproducts_location WHERE p5.products_category_idproducts_category = ? AND p5.products_shop_idshop = ? AND p5.products_idproducts NOT IN (?) GROUP BY p5.products_idproducts ORDER BY p8.price_range ASC, RAND() LIMIT 20 - (1, 1, 200, 1651, 38, 155264) |
| 25 | Doctrine_Connection_Statement | execute : SELECT p.idproducts_location AS p__idproducts_location, p.products_shop_idshop AS p__products_shop_idshop, p.products_catalog_idproducts_catalog AS p__products_catalog_idproducts_catalog, p.products_category_idproducts_category AS p__products_category_idproducts_category, p.products_idproducts AS p__products_idproducts, p.products_price_thresholds AS p__products_price_thresholds, p.products_price_range_max_agency AS p__products_price_range_max_agency, p.products_price_range_max_customer AS p__products_price_range_max_customer, p.idms_currency_type AS p__idms_currency_type, p.idms_products_menu AS p__idms_products_menu, p2.idproducts AS p2__idproducts, p2.name AS p2__name, p2.body AS p2__body, p2.active AS p2__active, p2.product_index AS p2__product_index, p2.created_at AS p2__created_at, p2.price AS p2__price, p2.price_promotion AS p2__price_promotion, p2.price_wholesaler AS p2__price_wholesaler, p2.price_thresholds AS p2__price_thresholds, p2.products_manufacturer_idproducts_manufacturer AS p2__products_manufacturer_idproducts_manufacturer, p2.products_status_idproducts_status AS p2__products_status_idproducts_status, p2.products_unit_idproducts_unit AS p2__products_unit_idproducts_unit, p2.products_tax_idproducts_tax AS p2__products_tax_idproducts_tax, p2.no_premium AS p2__no_premium, p2.price_min_wholeseller AS p2__price_min_wholeseller, p2.price_min_regular AS p2__price_min_regular, p2.price_buy AS p2__price_buy, p2.catalogue_price AS p2__catalogue_price, p2.body_weight AS p2__body_weight, p2.body_size AS p2__body_size, p2.body_material AS p2__body_material, p2.body_print_tech AS p2__body_print_tech, p2.body_print_size AS p2__body_print_size, p2.body_handling AS p2__body_handling, p2.ms_products_color_idms_products_color AS p2__ms_products_color_idms_products_color, p2.name_url AS p2__name_url, p2.last_update AS p2__last_update, p2.type AS p2__type, p2.import_photo AS p2__import_photo, p2.color_hex AS p2__color_hex, p2.color_manu AS p2__color_manu, p2.last_update_prev_price_buy AS p2__last_update_prev_price_buy, p2.last_update_prev AS p2__last_update_prev, p2.id_product_manufacturer AS p2__id_product_manufacturer, p2.model_product_manufacturer AS p2__model_product_manufacturer, p2.price_brutto AS p2__price_brutto, p2.meta_link_canonical AS p2__meta_link_canonical, p2.code_product_manufacturer AS p2__code_product_manufacturer, p2.tags AS p2__tags, p2.slug AS p2__slug, p2.show_on_store AS p2__show_on_store, p2.ms_product_index AS p2__ms_product_index, p2.price_range_divisor AS p2__price_range_divisor, p2.merchant_status AS p2__merchant_status, p2.idproducts_sync AS p2__idproducts_sync, p2.disable_price_calculation AS p2__disable_price_calculation, p2.gratisownia_shop_menu_names AS p2__gratisownia_shop_menu_names, p3.idproducts_gallery AS p3__idproducts_gallery, p3.file_name AS p3__file_name, p3.products_idproducts AS p3__products_idproducts, p3.publication AS p3__publication, p3.file_custom AS p3__file_custom, p3.position AS p3__position, p3.http_status AS p3__http_status, p3.main_status AS p3__main_status, p3.webp_status AS p3__webp_status, p3.updated_at AS p3__updated_at, p4.idproducts_price_range AS p4__idproducts_price_range, p4.price_range AS p4__price_range, p4.price_customer AS p4__price_customer, p4.price_agency AS p4__price_agency, p4.products_location_idproducts_location AS p4__products_location_idproducts_location, p4.price_range_text AS p4__price_range_text, p4.min_amount AS p4__min_amount, p4.max_amount AS p4__max_amount, p4.recommendation AS p4__recommendation FROM products_location p INNER JOIN products p2 ON p.products_idproducts = p2.idproducts AND ((p2.active = ? AND show_on_store = ?)) INNER JOIN products_gallery p3 ON p2.idproducts = p3.products_idproducts AND (p3.http_status = ?) INNER JOIN products_price_range p4 ON p.idproducts_location = p4.products_location_idproducts_location WHERE p.idproducts_location IN ('37791075', '37794268', '37790406', '37787459', '37784335', '37803767', '37812448', '37788305', '37788079', '37781741', '37782234', '37780815', '37781889', '37782636', '37779536', '37788340', '37790580', '37786141', '37794186', '37780513') AND (p.products_category_idproducts_category = ? AND p.products_shop_idshop = ? AND p.products_idproducts NOT IN (?)) GROUP BY p.products_idproducts ORDER BY p4.price_range ASC, RAND() - (1, 1, 200, 1651, 38, 155264) |
| 26 | Doctrine_Connection_Statement | execute : SELECT u.idusers AS u__idusers, u.name AS u__name, u.mail AS u__mail, u.passwd AS u__passwd, u.active AS u__active, u.profil_account AS u__profil_account, u.price_premium_wholesaler AS u__price_premium_wholesaler, u.price_premium AS u__price_premium, u.landline_phone AS u__landline_phone, u.phone AS u__phone, u.com_skype AS u__com_skype, u.com_gg AS u__com_gg, u.homepage AS u__homepage, u.username AS u__username, u.last_synch AS u__last_synch, u.stats AS u__stats, u.ar_proof AS u__ar_proof, u.cu_proof AS u__cu_proof, u.last_pass_change AS u__last_pass_change, u.last_login AS u__last_login, u.shop_customers AS u__shop_customers, u.gender AS u__gender, u.avatar_image AS u__avatar_image, u.idusers_workplace AS u__idusers_workplace, u.position_row AS u__position_row, u.initials AS u__initials, u.account_pin AS u__account_pin, u.account_code AS u__account_code, u.first_name AS u__first_name, u.last_name AS u__last_name, u.updated_at AS u__updated_at, u.days_search_offset AS u__days_search_offset, u2.idusers AS u2__idusers, u2.ms_lang_install_signature AS u2__ms_lang_install_signature, m.idlang_install AS m__idlang_install, m.name AS m__name, m.signature AS m__signature, m.publication AS m__publication, m.lang_icons AS m__lang_icons FROM users u LEFT JOIN users_has_ms_lang_install u2 ON u.idusers = u2.idusers LEFT JOIN ms_lang_install m ON u2.ms_lang_install_signature = m.signature WHERE (u.name = ?) ORDER BY u.position_row ASC - (Infolinia Handlowa) |
| 27 | Doctrine_Connection_Statement | execute : SELECT p.idproducts_menu AS p__idproducts_menu, p.personal_name_category AS p__personal_name_category FROM products_menu p WHERE (p.products_shop_idshop = ? AND p.products_category_idproducts_category = ?) - (38, 1651) |
| 28 | Doctrine_Connection_Statement | execute : SELECT m.ms_lang_install_signature AS m__ms_lang_install_signature, m.products_shop_idshop AS m__products_shop_idshop, m2.idlang_install AS m2__idlang_install, m2.name AS m2__name, m2.signature AS m2__signature, m2.publication AS m2__publication, m2.lang_icons AS m2__lang_icons FROM ms_lang_install_has_products_shop m INNER JOIN ms_lang_install m2 ON m.ms_lang_install_signature = m2.signature WHERE (m2.publication = ? AND m.products_shop_idshop = ?) - (1, 38) |
| 29 | Doctrine_Connection_Statement | execute : SELECT p.idproducts_has_color AS p__idproducts_has_color, p.color_hex AS p__color_hex FROM products_has_color p WHERE (p.products_idproducts = ?) - (155264) |
| 30 | Doctrine_Connection_Statement | execute : SELECT p.idproducts_has_color AS p__idproducts_has_color, p.color_hex AS p__color_hex FROM products_has_color p WHERE (p.products_idproducts = ?) - (155264) |
| 31 | Doctrine_Connection_Statement | execute : SELECT p.idproducts_color AS p__idproducts_color, p.tag AS p__tag, p.name AS p__name, p.name_variants AS p__name_variants FROM products_color p WHERE (p.tag = ?) - (#279107) |
| 32 | Doctrine_Connection_Statement | execute : SELECT p.idproducts_has_color AS p__idproducts_has_color, p.color_hex AS p__color_hex FROM products_has_color p WHERE (p.products_idproducts = ?) - (155264) |
| 33 | Doctrine_Connection_Statement | execute : SELECT p.idproducts_has_color AS p__idproducts_has_color, p.color_hex AS p__color_hex FROM products_has_color p WHERE (p.products_idproducts = ?) - (155264) |
| 34 | Doctrine_Connection_Statement | execute : SELECT p.idproducts_color AS p__idproducts_color, p.tag AS p__tag, p.name AS p__name, p.name_variants AS p__name_variants FROM products_color p WHERE (p.tag = ?) - (#279107) |
| 35 | Doctrine_Connection_Statement | execute : SELECT m.ms_lang_install_signature AS m__ms_lang_install_signature, m.products_shop_idshop AS m__products_shop_idshop, m2.idlang_install AS m2__idlang_install, m2.name AS m2__name, m2.signature AS m2__signature, m2.publication AS m2__publication, m2.lang_icons AS m2__lang_icons FROM ms_lang_install_has_products_shop m INNER JOIN ms_lang_install m2 ON m.ms_lang_install_signature = m2.signature WHERE (m2.publication = ? AND m.products_shop_idshop = ?) - (1, 38) |
| 36 | Doctrine_Connection_Statement | execute : SELECT p.idproducts_manufacturer AS p__idproducts_manufacturer, p.name AS p__name, p.publication AS p__publication, p.discount AS p__discount, p.margin AS p__margin, p.min_wholeseller AS p__min_wholeseller, p.min_regular AS p__min_regular, p.stock_url_local AS p__stock_url_local, p.stock_url_import AS p__stock_url_import, p.stock_login AS p__stock_login, p.stock_passwd AS p__stock_passwd, p.photo_db_url AS p__photo_db_url, p.photo_db_login AS p__photo_db_login, p.photo_db_passwd AS p__photo_db_passwd, p.products_manufacturer_group_idproducts_manufacturer AS p__products_manufacturer_group_idproducts_manufacturer, p.comparison_length_string AS p__comparison_length_string, p.position AS p__position, p.photo_ftp_remote_dir AS p__photo_ftp_remote_dir, p.photo_ftp_login AS p__photo_ftp_login, p.photo_ftp_passwd AS p__photo_ftp_passwd, p.photo_ftp_url AS p__photo_ftp_url, p.not_recalculate_price AS p__not_recalculate_price, p.option_disabled_stock AS p__option_disabled_stock, p.option_disabled_thresholds AS p__option_disabled_thresholds FROM products_manufacturer p WHERE (p.idproducts_manufacturer = ?) - (22) |
| 37 | Doctrine_Connection_Statement | execute : SELECT p.idproducts_has_color AS p__idproducts_has_color, p.color_hex AS p__color_hex FROM products_has_color p WHERE (p.products_idproducts = ?) - (155264) |
| 38 | Doctrine_Connection_Statement | execute : SELECT p.idproducts_has_color AS p__idproducts_has_color, p.color_hex AS p__color_hex FROM products_has_color p WHERE (p.products_idproducts = ?) - (155264) |
| 39 | Doctrine_Connection_Statement | execute : SELECT p.idproducts_color AS p__idproducts_color, p.tag AS p__tag, p.name AS p__name, p.name_variants AS p__name_variants FROM products_color p WHERE (p.tag = ?) - (#279107) |
| 40 | Doctrine_Connection_Statement | execute : SELECT COUNT(*) AS num_results FROM (SELECT p.idms_offer_creator_marking_type, p.products_idproducts FROM products_settings_marking_type p LEFT JOIN ms_offer_creator_marking_type m ON p.idms_offer_creator_marking_type = m.idms_offer_creator_marking_type WHERE p.products_idproducts = ? AND (p.verified = ? OR p.verified = ?) AND m.publication = ? GROUP BY p.idms_offer_creator_marking_type, p.products_idproducts) dctrn_count_query - (155264, 1, 2, 1) |
| 41 | Doctrine_Connection_Statement | execute : SELECT p.idms_offer_creator_marking_type AS p__idms_offer_creator_marking_type, p.products_idproducts AS p__products_idproducts, p.verified AS p__verified, m.idms_offer_creator_marking_type AS m__idms_offer_creator_marking_type, m.name AS m__name, m.publication AS m__publication, m.name_full AS m__name_full, m.one_color AS m__one_color, m.position AS m__position, m.heat AS m__heat, m.next_cost AS m__next_cost, m.1 AS m__1, m.101 AS m__101, m.251 AS m__251, m.501 AS m__501, m.1001 AS m__1001, m.2501 AS m__2501, m.5001 AS m__5001, m.more_count AS m__more_count, m.next_1 AS m__next_1, m.next_101 AS m__next_101, m.next_251 AS m__next_251, m.next_501 AS m__next_501, m.next_1001 AS m__next_1001, m.next_2501 AS m__next_2501, m.next_5001 AS m__next_5001, m.next_more_count AS m__next_more_count, m.desc_title AS m__desc_title, m.desc_text AS m__desc_text, m.section_amount_input AS m__section_amount_input, m.publication_offer_creator AS m__publication_offer_creator, m.section_print_size_input AS m__section_print_size_input, m.print_time_one_cm AS m__print_time_one_cm, m.max_color AS m__max_color, m.updated_at AS m__updated_at FROM products_settings_marking_type p LEFT JOIN ms_offer_creator_marking_type m ON p.idms_offer_creator_marking_type = m.idms_offer_creator_marking_type WHERE (p.products_idproducts = ? AND (p.verified = ? OR p.verified = ?) AND m.publication = ? AND m.name IN (?)) - (155264, 1, 2, 1, BN) |
| 42 | Doctrine_Connection_Statement | execute : SELECT p.idms_offer_creator_marking_type AS p__idms_offer_creator_marking_type, p.products_idproducts AS p__products_idproducts, p.verified AS p__verified, m.idms_offer_creator_marking_type AS m__idms_offer_creator_marking_type, m.name AS m__name, m.publication AS m__publication, m.name_full AS m__name_full, m.one_color AS m__one_color, m.position AS m__position, m.heat AS m__heat, m.next_cost AS m__next_cost, m.1 AS m__1, m.101 AS m__101, m.251 AS m__251, m.501 AS m__501, m.1001 AS m__1001, m.2501 AS m__2501, m.5001 AS m__5001, m.more_count AS m__more_count, m.next_1 AS m__next_1, m.next_101 AS m__next_101, m.next_251 AS m__next_251, m.next_501 AS m__next_501, m.next_1001 AS m__next_1001, m.next_2501 AS m__next_2501, m.next_5001 AS m__next_5001, m.next_more_count AS m__next_more_count, m.desc_title AS m__desc_title, m.desc_text AS m__desc_text, m.section_amount_input AS m__section_amount_input, m.publication_offer_creator AS m__publication_offer_creator, m.section_print_size_input AS m__section_print_size_input, m.print_time_one_cm AS m__print_time_one_cm, m.max_color AS m__max_color, m.updated_at AS m__updated_at FROM products_settings_marking_type p LEFT JOIN ms_offer_creator_marking_type m ON p.idms_offer_creator_marking_type = m.idms_offer_creator_marking_type WHERE (p.products_idproducts = ? AND (p.verified = ? OR p.verified = ?) AND m.publication = ? AND m.name IN (?, ?, ?)) - (155264, 1, 2, 1, SB, Z, I) |
| 43 | Doctrine_Connection_Statement | execute : SELECT p.idms_offer_creator_repackaging AS p__idms_offer_creator_repackaging, p.products_idproducts AS p__products_idproducts, m.idms_offer_creator_repackaging AS m__idms_offer_creator_repackaging, m.name AS m__name, m.price_unit AS m__price_unit, m.price_custom AS m__price_custom, m.handling_time AS m__handling_time, m.publication AS m__publication FROM products_settings_repackaging p LEFT JOIN ms_offer_creator_repackaging m ON p.idms_offer_creator_repackaging = m.idms_offer_creator_repackaging WHERE (p.products_idproducts = ?) - (155264) |
| 44 | Doctrine_Connection_Statement | execute : SELECT p.idms_offer_creator_repackaging AS p__idms_offer_creator_repackaging, p.products_idproducts AS p__products_idproducts, m.idms_offer_creator_repackaging AS m__idms_offer_creator_repackaging, m.name AS m__name, m.price_unit AS m__price_unit, m.price_custom AS m__price_custom, m.handling_time AS m__handling_time, m.publication AS m__publication FROM products_settings_repackaging p LEFT JOIN ms_offer_creator_repackaging m ON p.idms_offer_creator_repackaging = m.idms_offer_creator_repackaging WHERE (p.products_idproducts = ?) - (155264) |
| 45 | sfPHPView | Render "sf_app_dir/modules/products/templates/showSuccess.php" |
| 46 | Doctrine_Connection_Statement | execute : SELECT p.idproducts_gallery AS p__idproducts_gallery, p.file_name AS p__file_name, p.products_idproducts AS p__products_idproducts, p.publication AS p__publication, p.file_custom AS p__file_custom, p.position AS p__position, p.http_status AS p__http_status, p.main_status AS p__main_status, p.webp_status AS p__webp_status, p.updated_at AS p__updated_at FROM products_gallery p WHERE (p.products_idproducts = ? AND p.http_status = ?) AND (((p.publication = ? AND p.file_custom = ?) OR p.publication = ?) AND p.http_status = ?) ORDER BY p.position ASC - (155264, 200, 1, 1, 1, 200) |
| 47 | Doctrine_Connection_Statement | execute : SELECT p.idproducts AS p__idproducts, p.name AS p__name, p.body AS p__body, p.active AS p__active, p.product_index AS p__product_index, p.created_at AS p__created_at, p.price AS p__price, p.price_promotion AS p__price_promotion, p.price_wholesaler AS p__price_wholesaler, p.price_thresholds AS p__price_thresholds, p.products_manufacturer_idproducts_manufacturer AS p__products_manufacturer_idproducts_manufacturer, p.products_status_idproducts_status AS p__products_status_idproducts_status, p.products_unit_idproducts_unit AS p__products_unit_idproducts_unit, p.products_tax_idproducts_tax AS p__products_tax_idproducts_tax, p.no_premium AS p__no_premium, p.price_min_wholeseller AS p__price_min_wholeseller, p.price_min_regular AS p__price_min_regular, p.price_buy AS p__price_buy, p.catalogue_price AS p__catalogue_price, p.body_weight AS p__body_weight, p.body_size AS p__body_size, p.body_material AS p__body_material, p.body_print_tech AS p__body_print_tech, p.body_print_size AS p__body_print_size, p.body_handling AS p__body_handling, p.ms_products_color_idms_products_color AS p__ms_products_color_idms_products_color, p.name_url AS p__name_url, p.last_update AS p__last_update, p.type AS p__type, p.import_photo AS p__import_photo, p.color_hex AS p__color_hex, p.color_manu AS p__color_manu, p.last_update_prev_price_buy AS p__last_update_prev_price_buy, p.last_update_prev AS p__last_update_prev, p.id_product_manufacturer AS p__id_product_manufacturer, p.model_product_manufacturer AS p__model_product_manufacturer, p.price_brutto AS p__price_brutto, p.meta_link_canonical AS p__meta_link_canonical, p.code_product_manufacturer AS p__code_product_manufacturer, p.tags AS p__tags, p.slug AS p__slug, p.show_on_store AS p__show_on_store, p.ms_product_index AS p__ms_product_index, p.price_range_divisor AS p__price_range_divisor, p.merchant_status AS p__merchant_status, p.idproducts_sync AS p__idproducts_sync, p.disable_price_calculation AS p__disable_price_calculation, p.gratisownia_shop_menu_names AS p__gratisownia_shop_menu_names FROM products p WHERE (p.idproducts = ?) - (155264) |
| 48 | Doctrine_Connection_Statement | execute : SELECT m.ms_lang_install_signature AS m__ms_lang_install_signature, m.products_shop_idshop AS m__products_shop_idshop, m2.idlang_install AS m2__idlang_install, m2.name AS m2__name, m2.signature AS m2__signature, m2.publication AS m2__publication, m2.lang_icons AS m2__lang_icons FROM ms_lang_install_has_products_shop m INNER JOIN ms_lang_install m2 ON m.ms_lang_install_signature = m2.signature WHERE (m2.publication = ? AND m.products_shop_idshop = ?) - (1, 38) |
| 49 | Doctrine_Connection_Statement | execute : SELECT p.idproducts_has_color AS p__idproducts_has_color, p.color_hex AS p__color_hex FROM products_has_color p WHERE (p.products_idproducts = ?) - (155264) |
| 50 | Doctrine_Connection_Statement | execute : SELECT p.idproducts_has_color AS p__idproducts_has_color, p.color_hex AS p__color_hex FROM products_has_color p WHERE (p.products_idproducts = ?) - (155264) |
| 51 | Doctrine_Connection_Statement | execute : SELECT p.idproducts_color AS p__idproducts_color, p.tag AS p__tag, p.name AS p__name, p.name_variants AS p__name_variants FROM products_color p WHERE (p.tag = ?) - (#279107) |
| 52 | Doctrine_Connection_Statement | execute : SELECT p.idproducts_has_color AS p__idproducts_has_color, p.color_hex AS p__color_hex FROM products_has_color p WHERE (p.products_idproducts = ?) - (155264) |
| 53 | Doctrine_Connection_Statement | execute : SELECT p.idproducts_has_color AS p__idproducts_has_color, p.color_hex AS p__color_hex FROM products_has_color p WHERE (p.products_idproducts = ?) - (155264) |
| 54 | Doctrine_Connection_Statement | execute : SELECT p.idproducts_color AS p__idproducts_color, p.tag AS p__tag, p.name AS p__name, p.name_variants AS p__name_variants FROM products_color p WHERE (p.tag = ?) - (#279107) |
| 55 | Doctrine_Connection_Statement | execute : SELECT p.idproducts_gallery AS p__idproducts_gallery, p.file_name AS p__file_name, p.products_idproducts AS p__products_idproducts, p.publication AS p__publication, p.file_custom AS p__file_custom, p.position AS p__position, p.http_status AS p__http_status, p.main_status AS p__main_status, p.webp_status AS p__webp_status, p.updated_at AS p__updated_at FROM products_gallery p WHERE (p.products_idproducts IN (?)) - (155264) |
| 56 | Doctrine_Connection_Statement | execute : SELECT m.idms_products_gallery_settings AS m__idms_products_gallery_settings, m.image_title AS m__image_title FROM ms_products_gallery_settings m WHERE (m.idproducts_gallery = ?) - (412464846) |
| 57 | Doctrine_Connection_Statement | execute : SELECT m.ms_lang_install_signature AS m__ms_lang_install_signature, m.products_shop_idshop AS m__products_shop_idshop, m2.idlang_install AS m2__idlang_install, m2.name AS m2__name, m2.signature AS m2__signature, m2.publication AS m2__publication, m2.lang_icons AS m2__lang_icons FROM ms_lang_install_has_products_shop m INNER JOIN ms_lang_install m2 ON m.ms_lang_install_signature = m2.signature WHERE (m2.publication = ? AND m.products_shop_idshop = ?) - (1, 38) |
| 58 | Doctrine_Connection_Statement | execute : SELECT p.idproducts_has_color AS p__idproducts_has_color, p.color_hex AS p__color_hex FROM products_has_color p WHERE (p.products_idproducts = ?) - (155264) |
| 59 | Doctrine_Connection_Statement | execute : SELECT p.idproducts_has_color AS p__idproducts_has_color, p.color_hex AS p__color_hex FROM products_has_color p WHERE (p.products_idproducts = ?) - (155264) |
| 60 | Doctrine_Connection_Statement | execute : SELECT p.idproducts_color AS p__idproducts_color, p.tag AS p__tag, p.name AS p__name, p.name_variants AS p__name_variants FROM products_color p WHERE (p.tag = ?) - (#279107) |
| 61 | Doctrine_Connection_Statement | execute : SELECT p.idproducts_has_color AS p__idproducts_has_color, p.color_hex AS p__color_hex FROM products_has_color p WHERE (p.products_idproducts = ?) - (155264) |
| 62 | Doctrine_Connection_Statement | execute : SELECT p.idproducts_has_color AS p__idproducts_has_color, p.color_hex AS p__color_hex FROM products_has_color p WHERE (p.products_idproducts = ?) - (155264) |
| 63 | Doctrine_Connection_Statement | execute : SELECT p.idproducts_color AS p__idproducts_color, p.tag AS p__tag, p.name AS p__name, p.name_variants AS p__name_variants FROM products_color p WHERE (p.tag = ?) - (#279107) |
| 64 | Doctrine_Connection_Statement | execute : SELECT m.idms_products_gallery_settings AS m__idms_products_gallery_settings, m.image_alt AS m__image_alt FROM ms_products_gallery_settings m WHERE (m.idproducts_gallery = ?) - (412464846) |
| 65 | Doctrine_Connection_Statement | execute : SELECT p.idproducts AS p__idproducts, p.name AS p__name, p.body AS p__body, p.active AS p__active, p.product_index AS p__product_index, p.created_at AS p__created_at, p.price AS p__price, p.price_promotion AS p__price_promotion, p.price_wholesaler AS p__price_wholesaler, p.price_thresholds AS p__price_thresholds, p.products_manufacturer_idproducts_manufacturer AS p__products_manufacturer_idproducts_manufacturer, p.products_status_idproducts_status AS p__products_status_idproducts_status, p.products_unit_idproducts_unit AS p__products_unit_idproducts_unit, p.products_tax_idproducts_tax AS p__products_tax_idproducts_tax, p.no_premium AS p__no_premium, p.price_min_wholeseller AS p__price_min_wholeseller, p.price_min_regular AS p__price_min_regular, p.price_buy AS p__price_buy, p.catalogue_price AS p__catalogue_price, p.body_weight AS p__body_weight, p.body_size AS p__body_size, p.body_material AS p__body_material, p.body_print_tech AS p__body_print_tech, p.body_print_size AS p__body_print_size, p.body_handling AS p__body_handling, p.ms_products_color_idms_products_color AS p__ms_products_color_idms_products_color, p.name_url AS p__name_url, p.last_update AS p__last_update, p.type AS p__type, p.import_photo AS p__import_photo, p.color_hex AS p__color_hex, p.color_manu AS p__color_manu, p.last_update_prev_price_buy AS p__last_update_prev_price_buy, p.last_update_prev AS p__last_update_prev, p.id_product_manufacturer AS p__id_product_manufacturer, p.model_product_manufacturer AS p__model_product_manufacturer, p.price_brutto AS p__price_brutto, p.meta_link_canonical AS p__meta_link_canonical, p.code_product_manufacturer AS p__code_product_manufacturer, p.tags AS p__tags, p.slug AS p__slug, p.show_on_store AS p__show_on_store, p.ms_product_index AS p__ms_product_index, p.price_range_divisor AS p__price_range_divisor, p.merchant_status AS p__merchant_status, p.idproducts_sync AS p__idproducts_sync, p.disable_price_calculation AS p__disable_price_calculation, p.gratisownia_shop_menu_names AS p__gratisownia_shop_menu_names FROM products p WHERE (p.idproducts = ?) - (155264) |
| 66 | Doctrine_Connection_Statement | execute : SELECT m.ms_lang_install_signature AS m__ms_lang_install_signature, m.products_shop_idshop AS m__products_shop_idshop, m2.idlang_install AS m2__idlang_install, m2.name AS m2__name, m2.signature AS m2__signature, m2.publication AS m2__publication, m2.lang_icons AS m2__lang_icons FROM ms_lang_install_has_products_shop m INNER JOIN ms_lang_install m2 ON m.ms_lang_install_signature = m2.signature WHERE (m2.publication = ? AND m.products_shop_idshop = ?) - (1, 38) |
| 67 | Doctrine_Connection_Statement | execute : SELECT p.idproducts_has_color AS p__idproducts_has_color, p.color_hex AS p__color_hex FROM products_has_color p WHERE (p.products_idproducts = ?) - (155264) |
| 68 | Doctrine_Connection_Statement | execute : SELECT p.idproducts_has_color AS p__idproducts_has_color, p.color_hex AS p__color_hex FROM products_has_color p WHERE (p.products_idproducts = ?) - (155264) |
| 69 | Doctrine_Connection_Statement | execute : SELECT p.idproducts_color AS p__idproducts_color, p.tag AS p__tag, p.name AS p__name, p.name_variants AS p__name_variants FROM products_color p WHERE (p.tag = ?) - (#279107) |
| 70 | Doctrine_Connection_Statement | execute : SELECT p.idproducts_has_color AS p__idproducts_has_color, p.color_hex AS p__color_hex FROM products_has_color p WHERE (p.products_idproducts = ?) - (155264) |
| 71 | Doctrine_Connection_Statement | execute : SELECT p.idproducts_has_color AS p__idproducts_has_color, p.color_hex AS p__color_hex FROM products_has_color p WHERE (p.products_idproducts = ?) - (155264) |
| 72 | Doctrine_Connection_Statement | execute : SELECT p.idproducts_color AS p__idproducts_color, p.tag AS p__tag, p.name AS p__name, p.name_variants AS p__name_variants FROM products_color p WHERE (p.tag = ?) - (#279107) |
| 73 | Doctrine_Connection_Statement | execute : SELECT m.idms_products_gallery_settings AS m__idms_products_gallery_settings, m.image_title AS m__image_title FROM ms_products_gallery_settings m WHERE (m.idproducts_gallery = ?) - (412464846) |
| 74 | Doctrine_Connection_Statement | execute : SELECT m.ms_lang_install_signature AS m__ms_lang_install_signature, m.products_shop_idshop AS m__products_shop_idshop, m2.idlang_install AS m2__idlang_install, m2.name AS m2__name, m2.signature AS m2__signature, m2.publication AS m2__publication, m2.lang_icons AS m2__lang_icons FROM ms_lang_install_has_products_shop m INNER JOIN ms_lang_install m2 ON m.ms_lang_install_signature = m2.signature WHERE (m2.publication = ? AND m.products_shop_idshop = ?) - (1, 38) |
| 75 | Doctrine_Connection_Statement | execute : SELECT p.idproducts_has_color AS p__idproducts_has_color, p.color_hex AS p__color_hex FROM products_has_color p WHERE (p.products_idproducts = ?) - (155264) |
| 76 | Doctrine_Connection_Statement | execute : SELECT p.idproducts_has_color AS p__idproducts_has_color, p.color_hex AS p__color_hex FROM products_has_color p WHERE (p.products_idproducts = ?) - (155264) |
| 77 | Doctrine_Connection_Statement | execute : SELECT p.idproducts_color AS p__idproducts_color, p.tag AS p__tag, p.name AS p__name, p.name_variants AS p__name_variants FROM products_color p WHERE (p.tag = ?) - (#279107) |
| 78 | Doctrine_Connection_Statement | execute : SELECT p.idproducts_has_color AS p__idproducts_has_color, p.color_hex AS p__color_hex FROM products_has_color p WHERE (p.products_idproducts = ?) - (155264) |
| 79 | Doctrine_Connection_Statement | execute : SELECT p.idproducts_has_color AS p__idproducts_has_color, p.color_hex AS p__color_hex FROM products_has_color p WHERE (p.products_idproducts = ?) - (155264) |
| 80 | Doctrine_Connection_Statement | execute : SELECT p.idproducts_color AS p__idproducts_color, p.tag AS p__tag, p.name AS p__name, p.name_variants AS p__name_variants FROM products_color p WHERE (p.tag = ?) - (#279107) |
| 81 | Doctrine_Connection_Statement | execute : SELECT m.idms_products_gallery_settings AS m__idms_products_gallery_settings, m.image_alt AS m__image_alt FROM ms_products_gallery_settings m WHERE (m.idproducts_gallery = ?) - (412464846) |
| 82 | Doctrine_Connection_Statement | execute : SELECT p.idproducts AS p__idproducts, p.name AS p__name, p.body AS p__body, p.active AS p__active, p.product_index AS p__product_index, p.created_at AS p__created_at, p.price AS p__price, p.price_promotion AS p__price_promotion, p.price_wholesaler AS p__price_wholesaler, p.price_thresholds AS p__price_thresholds, p.products_manufacturer_idproducts_manufacturer AS p__products_manufacturer_idproducts_manufacturer, p.products_status_idproducts_status AS p__products_status_idproducts_status, p.products_unit_idproducts_unit AS p__products_unit_idproducts_unit, p.products_tax_idproducts_tax AS p__products_tax_idproducts_tax, p.no_premium AS p__no_premium, p.price_min_wholeseller AS p__price_min_wholeseller, p.price_min_regular AS p__price_min_regular, p.price_buy AS p__price_buy, p.catalogue_price AS p__catalogue_price, p.body_weight AS p__body_weight, p.body_size AS p__body_size, p.body_material AS p__body_material, p.body_print_tech AS p__body_print_tech, p.body_print_size AS p__body_print_size, p.body_handling AS p__body_handling, p.ms_products_color_idms_products_color AS p__ms_products_color_idms_products_color, p.name_url AS p__name_url, p.last_update AS p__last_update, p.type AS p__type, p.import_photo AS p__import_photo, p.color_hex AS p__color_hex, p.color_manu AS p__color_manu, p.last_update_prev_price_buy AS p__last_update_prev_price_buy, p.last_update_prev AS p__last_update_prev, p.id_product_manufacturer AS p__id_product_manufacturer, p.model_product_manufacturer AS p__model_product_manufacturer, p.price_brutto AS p__price_brutto, p.meta_link_canonical AS p__meta_link_canonical, p.code_product_manufacturer AS p__code_product_manufacturer, p.tags AS p__tags, p.slug AS p__slug, p.show_on_store AS p__show_on_store, p.ms_product_index AS p__ms_product_index, p.price_range_divisor AS p__price_range_divisor, p.merchant_status AS p__merchant_status, p.idproducts_sync AS p__idproducts_sync, p.disable_price_calculation AS p__disable_price_calculation, p.gratisownia_shop_menu_names AS p__gratisownia_shop_menu_names FROM products p WHERE (p.idproducts = ?) - (155264) |
| 83 | Doctrine_Connection_Statement | execute : SELECT m.ms_lang_install_signature AS m__ms_lang_install_signature, m.products_shop_idshop AS m__products_shop_idshop, m2.idlang_install AS m2__idlang_install, m2.name AS m2__name, m2.signature AS m2__signature, m2.publication AS m2__publication, m2.lang_icons AS m2__lang_icons FROM ms_lang_install_has_products_shop m INNER JOIN ms_lang_install m2 ON m.ms_lang_install_signature = m2.signature WHERE (m2.publication = ? AND m.products_shop_idshop = ?) - (1, 38) |
| 84 | Doctrine_Connection_Statement | execute : SELECT p.idproducts_has_color AS p__idproducts_has_color, p.color_hex AS p__color_hex FROM products_has_color p WHERE (p.products_idproducts = ?) - (155264) |
| 85 | Doctrine_Connection_Statement | execute : SELECT p.idproducts_has_color AS p__idproducts_has_color, p.color_hex AS p__color_hex FROM products_has_color p WHERE (p.products_idproducts = ?) - (155264) |
| 86 | Doctrine_Connection_Statement | execute : SELECT p.idproducts_color AS p__idproducts_color, p.tag AS p__tag, p.name AS p__name, p.name_variants AS p__name_variants FROM products_color p WHERE (p.tag = ?) - (#279107) |
| 87 | Doctrine_Connection_Statement | execute : SELECT p.idproducts_has_color AS p__idproducts_has_color, p.color_hex AS p__color_hex FROM products_has_color p WHERE (p.products_idproducts = ?) - (155264) |
| 88 | Doctrine_Connection_Statement | execute : SELECT p.idproducts_has_color AS p__idproducts_has_color, p.color_hex AS p__color_hex FROM products_has_color p WHERE (p.products_idproducts = ?) - (155264) |
| 89 | Doctrine_Connection_Statement | execute : SELECT p.idproducts_color AS p__idproducts_color, p.tag AS p__tag, p.name AS p__name, p.name_variants AS p__name_variants FROM products_color p WHERE (p.tag = ?) - (#279107) |
| 90 | Doctrine_Connection_Statement | execute : SELECT m.idms_products_gallery_settings AS m__idms_products_gallery_settings, m.image_title AS m__image_title FROM ms_products_gallery_settings m WHERE (m.idproducts_gallery = ?) - (412464846) |
| 91 | Doctrine_Connection_Statement | execute : SELECT m.ms_lang_install_signature AS m__ms_lang_install_signature, m.products_shop_idshop AS m__products_shop_idshop, m2.idlang_install AS m2__idlang_install, m2.name AS m2__name, m2.signature AS m2__signature, m2.publication AS m2__publication, m2.lang_icons AS m2__lang_icons FROM ms_lang_install_has_products_shop m INNER JOIN ms_lang_install m2 ON m.ms_lang_install_signature = m2.signature WHERE (m2.publication = ? AND m.products_shop_idshop = ?) - (1, 38) |
| 92 | Doctrine_Connection_Statement | execute : SELECT p.idproducts_has_color AS p__idproducts_has_color, p.color_hex AS p__color_hex FROM products_has_color p WHERE (p.products_idproducts = ?) - (155264) |
| 93 | Doctrine_Connection_Statement | execute : SELECT p.idproducts_has_color AS p__idproducts_has_color, p.color_hex AS p__color_hex FROM products_has_color p WHERE (p.products_idproducts = ?) - (155264) |
| 94 | Doctrine_Connection_Statement | execute : SELECT p.idproducts_color AS p__idproducts_color, p.tag AS p__tag, p.name AS p__name, p.name_variants AS p__name_variants FROM products_color p WHERE (p.tag = ?) - (#279107) |
| 95 | Doctrine_Connection_Statement | execute : SELECT p.idproducts_has_color AS p__idproducts_has_color, p.color_hex AS p__color_hex FROM products_has_color p WHERE (p.products_idproducts = ?) - (155264) |
| 96 | Doctrine_Connection_Statement | execute : SELECT p.idproducts_has_color AS p__idproducts_has_color, p.color_hex AS p__color_hex FROM products_has_color p WHERE (p.products_idproducts = ?) - (155264) |
| 97 | Doctrine_Connection_Statement | execute : SELECT p.idproducts_color AS p__idproducts_color, p.tag AS p__tag, p.name AS p__name, p.name_variants AS p__name_variants FROM products_color p WHERE (p.tag = ?) - (#279107) |
| 98 | Doctrine_Connection_Statement | execute : SELECT m.idms_products_gallery_settings AS m__idms_products_gallery_settings, m.image_alt AS m__image_alt FROM ms_products_gallery_settings m WHERE (m.idproducts_gallery = ?) - (412464846) |
| 99 | Doctrine_Connection_Statement | execute : SELECT p.idproducts_location AS p__idproducts_location, p.products_shop_idshop AS p__products_shop_idshop, p.products_catalog_idproducts_catalog AS p__products_catalog_idproducts_catalog, p.products_category_idproducts_category AS p__products_category_idproducts_category, p.products_idproducts AS p__products_idproducts, p.products_price_thresholds AS p__products_price_thresholds, p.products_price_range_max_agency AS p__products_price_range_max_agency, p.products_price_range_max_customer AS p__products_price_range_max_customer, p.idms_currency_type AS p__idms_currency_type, p.idms_products_menu AS p__idms_products_menu, p2.idproducts AS p2__idproducts, p2.name AS p2__name, p2.body AS p2__body, p2.active AS p2__active, p2.product_index AS p2__product_index, p2.created_at AS p2__created_at, p2.price AS p2__price, p2.price_promotion AS p2__price_promotion, p2.price_wholesaler AS p2__price_wholesaler, p2.price_thresholds AS p2__price_thresholds, p2.products_manufacturer_idproducts_manufacturer AS p2__products_manufacturer_idproducts_manufacturer, p2.products_status_idproducts_status AS p2__products_status_idproducts_status, p2.products_unit_idproducts_unit AS p2__products_unit_idproducts_unit, p2.products_tax_idproducts_tax AS p2__products_tax_idproducts_tax, p2.no_premium AS p2__no_premium, p2.price_min_wholeseller AS p2__price_min_wholeseller, p2.price_min_regular AS p2__price_min_regular, p2.price_buy AS p2__price_buy, p2.catalogue_price AS p2__catalogue_price, p2.body_weight AS p2__body_weight, p2.body_size AS p2__body_size, p2.body_material AS p2__body_material, p2.body_print_tech AS p2__body_print_tech, p2.body_print_size AS p2__body_print_size, p2.body_handling AS p2__body_handling, p2.ms_products_color_idms_products_color AS p2__ms_products_color_idms_products_color, p2.name_url AS p2__name_url, p2.last_update AS p2__last_update, p2.type AS p2__type, p2.import_photo AS p2__import_photo, p2.color_hex AS p2__color_hex, p2.color_manu AS p2__color_manu, p2.last_update_prev_price_buy AS p2__last_update_prev_price_buy, p2.last_update_prev AS p2__last_update_prev, p2.id_product_manufacturer AS p2__id_product_manufacturer, p2.model_product_manufacturer AS p2__model_product_manufacturer, p2.price_brutto AS p2__price_brutto, p2.meta_link_canonical AS p2__meta_link_canonical, p2.code_product_manufacturer AS p2__code_product_manufacturer, p2.tags AS p2__tags, p2.slug AS p2__slug, p2.show_on_store AS p2__show_on_store, p2.ms_product_index AS p2__ms_product_index, p2.price_range_divisor AS p2__price_range_divisor, p2.merchant_status AS p2__merchant_status, p2.idproducts_sync AS p2__idproducts_sync, p2.disable_price_calculation AS p2__disable_price_calculation, p2.gratisownia_shop_menu_names AS p2__gratisownia_shop_menu_names, p3.idproducts_settings AS p3__idproducts_settings, p3.news AS p3__news, p3.homepage AS p3__homepage, p3.awarded AS p3__awarded, p3.negotiations AS p3__negotiations, p3.promotion AS p3__promotion, p3.products_idproducts AS p3__products_idproducts, p3.bestseller AS p3__bestseller, m.idms_products_location_promotion AS m__idms_products_location_promotion, m.products_price_thresholds AS m__products_price_thresholds, m.products_price_range_max_agency AS m__products_price_range_max_agency, m.products_price_range_max_customer AS m__products_price_range_max_customer, m.products_location_idproducts_location AS m__products_location_idproducts_location, m.ms_products_promotion_idms_products_promotion AS m__ms_products_promotion_idms_products_promotion, m2.idms_products_promotion AS m2__idms_products_promotion, m2.title AS m2__title, m2.description AS m2__description, m2.created_at AS m2__created_at, m2.time_start AS m2__time_start, m2.time_end AS m2__time_end, m2.active AS m2__active, m2.max_products AS m2__max_products, m2.min_products AS m2__min_products, m2.discount_code AS m2__discount_code, m2.sale_type AS m2__sale_type, m2.sale_value AS m2__sale_value, m2.order_amount_min AS m2__order_amount_min, m2.order_amount_max AS m2__order_amount_max, m2.discount_code_limit AS m2__discount_code_limit, m2.discount_code_customers_usage_limit AS m2__discount_code_customers_usage_limit, m2.task_status AS m2__task_status, m2.task_products_processed AS m2__task_products_processed, m2.task_products_count AS m2__task_products_count, m2.task_time_start AS m2__task_time_start, m2.task_time_end AS m2__task_time_end, m2.view_label_list AS m2__view_label_list, m2.view_label_show AS m2__view_label_show, m2.tag AS m2__tag FROM products_location p INNER JOIN products p2 ON p.products_idproducts = p2.idproducts INNER JOIN products_settings p3 ON p2.idproducts = p3.products_idproducts LEFT JOIN ms_products_promotion_location m ON p.idproducts_location = m.products_location_idproducts_location LEFT JOIN ms_products_promotion m2 ON m.ms_products_promotion_idms_products_promotion = m2.idms_products_promotion AND ((m2.active = ? AND m2.time_start <= ? AND m2.time_end >= ?)) WHERE (p.products_idproducts = ? AND p.products_shop_idshop = ?) - (1, 1765833684, 1765833684, 155264, 38) |
| 100 | Doctrine_Connection_Statement | execute : SELECT p.idproducts_gallery AS p__idproducts_gallery, p.file_name AS p__file_name, p.products_idproducts AS p__products_idproducts, p.publication AS p__publication, p.file_custom AS p__file_custom, p.position AS p__position, p.http_status AS p__http_status, p.main_status AS p__main_status, p.webp_status AS p__webp_status, p.updated_at AS p__updated_at FROM products_gallery p WHERE (p.products_idproducts = ? AND p.http_status = ?) AND (((p.publication = ? AND p.file_custom = ?) OR p.publication = ?) AND p.http_status = ?) ORDER BY p.position ASC - (155264, 200, 1, 1, 1, 200) |
| 101 | Doctrine_Connection_Statement | execute : SELECT m.ms_lang_install_signature AS m__ms_lang_install_signature, m.products_shop_idshop AS m__products_shop_idshop, m2.idlang_install AS m2__idlang_install, m2.name AS m2__name, m2.signature AS m2__signature, m2.publication AS m2__publication, m2.lang_icons AS m2__lang_icons FROM ms_lang_install_has_products_shop m INNER JOIN ms_lang_install m2 ON m.ms_lang_install_signature = m2.signature WHERE (m2.publication = ? AND m.products_shop_idshop = ?) - (1, 38) |
| 102 | Doctrine_Connection_Statement | execute : SELECT p.idproducts_has_color AS p__idproducts_has_color, p.color_hex AS p__color_hex FROM products_has_color p WHERE (p.products_idproducts = ?) - (155264) |
| 103 | Doctrine_Connection_Statement | execute : SELECT p.idproducts_has_color AS p__idproducts_has_color, p.color_hex AS p__color_hex FROM products_has_color p WHERE (p.products_idproducts = ?) - (155264) |
| 104 | Doctrine_Connection_Statement | execute : SELECT p.idproducts_color AS p__idproducts_color, p.tag AS p__tag, p.name AS p__name, p.name_variants AS p__name_variants FROM products_color p WHERE (p.tag = ?) - (#279107) |
| 105 | Doctrine_Connection_Statement | execute : SELECT p.idproducts_has_color AS p__idproducts_has_color, p.color_hex AS p__color_hex FROM products_has_color p WHERE (p.products_idproducts = ?) - (155264) |
| 106 | Doctrine_Connection_Statement | execute : SELECT p.idproducts_has_color AS p__idproducts_has_color, p.color_hex AS p__color_hex FROM products_has_color p WHERE (p.products_idproducts = ?) - (155264) |
| 107 | Doctrine_Connection_Statement | execute : SELECT p.idproducts_color AS p__idproducts_color, p.tag AS p__tag, p.name AS p__name, p.name_variants AS p__name_variants FROM products_color p WHERE (p.tag = ?) - (#279107) |
| 108 | Doctrine_Connection_Statement | execute : SELECT m.idms_products_gallery_settings AS m__idms_products_gallery_settings, m.image_title AS m__image_title FROM ms_products_gallery_settings m WHERE (m.idproducts_gallery = ?) - (412464846) |
| 109 | Doctrine_Connection_Statement | execute : SELECT m.ms_lang_install_signature AS m__ms_lang_install_signature, m.products_shop_idshop AS m__products_shop_idshop, m2.idlang_install AS m2__idlang_install, m2.name AS m2__name, m2.signature AS m2__signature, m2.publication AS m2__publication, m2.lang_icons AS m2__lang_icons FROM ms_lang_install_has_products_shop m INNER JOIN ms_lang_install m2 ON m.ms_lang_install_signature = m2.signature WHERE (m2.publication = ? AND m.products_shop_idshop = ?) - (1, 38) |
| 110 | Doctrine_Connection_Statement | execute : SELECT p.idproducts_has_color AS p__idproducts_has_color, p.color_hex AS p__color_hex FROM products_has_color p WHERE (p.products_idproducts = ?) - (155264) |
| 111 | Doctrine_Connection_Statement | execute : SELECT p.idproducts_has_color AS p__idproducts_has_color, p.color_hex AS p__color_hex FROM products_has_color p WHERE (p.products_idproducts = ?) - (155264) |
| 112 | Doctrine_Connection_Statement | execute : SELECT p.idproducts_color AS p__idproducts_color, p.tag AS p__tag, p.name AS p__name, p.name_variants AS p__name_variants FROM products_color p WHERE (p.tag = ?) - (#279107) |
| 113 | Doctrine_Connection_Statement | execute : SELECT p.idproducts_has_color AS p__idproducts_has_color, p.color_hex AS p__color_hex FROM products_has_color p WHERE (p.products_idproducts = ?) - (155264) |
| 114 | Doctrine_Connection_Statement | execute : SELECT p.idproducts_has_color AS p__idproducts_has_color, p.color_hex AS p__color_hex FROM products_has_color p WHERE (p.products_idproducts = ?) - (155264) |
| 115 | Doctrine_Connection_Statement | execute : SELECT p.idproducts_color AS p__idproducts_color, p.tag AS p__tag, p.name AS p__name, p.name_variants AS p__name_variants FROM products_color p WHERE (p.tag = ?) - (#279107) |
| 116 | Doctrine_Connection_Statement | execute : SELECT m.idms_products_gallery_settings AS m__idms_products_gallery_settings, m.image_alt AS m__image_alt FROM ms_products_gallery_settings m WHERE (m.idproducts_gallery = ?) - (412464846) |
| 117 | Doctrine_Connection_Statement | execute : SELECT m.ms_lang_install_signature AS m__ms_lang_install_signature, m.products_shop_idshop AS m__products_shop_idshop, m2.idlang_install AS m2__idlang_install, m2.name AS m2__name, m2.signature AS m2__signature, m2.publication AS m2__publication, m2.lang_icons AS m2__lang_icons FROM ms_lang_install_has_products_shop m INNER JOIN ms_lang_install m2 ON m.ms_lang_install_signature = m2.signature WHERE (m2.publication = ? AND m.products_shop_idshop = ?) - (1, 38) |
| 118 | Doctrine_Connection_Statement | execute : SELECT p.idproducts_has_color AS p__idproducts_has_color, p.color_hex AS p__color_hex FROM products_has_color p WHERE (p.products_idproducts = ?) - (155264) |
| 119 | Doctrine_Connection_Statement | execute : SELECT p.idproducts_has_color AS p__idproducts_has_color, p.color_hex AS p__color_hex FROM products_has_color p WHERE (p.products_idproducts = ?) - (155264) |
| 120 | Doctrine_Connection_Statement | execute : SELECT p.idproducts_color AS p__idproducts_color, p.tag AS p__tag, p.name AS p__name, p.name_variants AS p__name_variants FROM products_color p WHERE (p.tag = ?) - (#279107) |
| 121 | Doctrine_Connection_Statement | execute : SELECT p.idproducts_has_color AS p__idproducts_has_color, p.color_hex AS p__color_hex FROM products_has_color p WHERE (p.products_idproducts = ?) - (155264) |
| 122 | Doctrine_Connection_Statement | execute : SELECT p.idproducts_has_color AS p__idproducts_has_color, p.color_hex AS p__color_hex FROM products_has_color p WHERE (p.products_idproducts = ?) - (155264) |
| 123 | Doctrine_Connection_Statement | execute : SELECT p.idproducts_color AS p__idproducts_color, p.tag AS p__tag, p.name AS p__name, p.name_variants AS p__name_variants FROM products_color p WHERE (p.tag = ?) - (#279107) |
| 124 | Doctrine_Connection_Statement | execute : SELECT m.idms_products_gallery_settings AS m__idms_products_gallery_settings, m.image_title AS m__image_title FROM ms_products_gallery_settings m WHERE (m.idproducts_gallery = ?) - (412464846) |
| 125 | Doctrine_Connection_Statement | execute : SELECT m.ms_lang_install_signature AS m__ms_lang_install_signature, m.products_shop_idshop AS m__products_shop_idshop, m2.idlang_install AS m2__idlang_install, m2.name AS m2__name, m2.signature AS m2__signature, m2.publication AS m2__publication, m2.lang_icons AS m2__lang_icons FROM ms_lang_install_has_products_shop m INNER JOIN ms_lang_install m2 ON m.ms_lang_install_signature = m2.signature WHERE (m2.publication = ? AND m.products_shop_idshop = ?) - (1, 38) |
| 126 | Doctrine_Connection_Statement | execute : SELECT p.idproducts_has_color AS p__idproducts_has_color, p.color_hex AS p__color_hex FROM products_has_color p WHERE (p.products_idproducts = ?) - (155264) |
| 127 | Doctrine_Connection_Statement | execute : SELECT p.idproducts_has_color AS p__idproducts_has_color, p.color_hex AS p__color_hex FROM products_has_color p WHERE (p.products_idproducts = ?) - (155264) |
| 128 | Doctrine_Connection_Statement | execute : SELECT p.idproducts_color AS p__idproducts_color, p.tag AS p__tag, p.name AS p__name, p.name_variants AS p__name_variants FROM products_color p WHERE (p.tag = ?) - (#279107) |
| 129 | Doctrine_Connection_Statement | execute : SELECT p.idproducts_has_color AS p__idproducts_has_color, p.color_hex AS p__color_hex FROM products_has_color p WHERE (p.products_idproducts = ?) - (155264) |
| 130 | Doctrine_Connection_Statement | execute : SELECT p.idproducts_has_color AS p__idproducts_has_color, p.color_hex AS p__color_hex FROM products_has_color p WHERE (p.products_idproducts = ?) - (155264) |
| 131 | Doctrine_Connection_Statement | execute : SELECT p.idproducts_color AS p__idproducts_color, p.tag AS p__tag, p.name AS p__name, p.name_variants AS p__name_variants FROM products_color p WHERE (p.tag = ?) - (#279107) |
| 132 | Doctrine_Connection_Statement | execute : SELECT m.idms_products_gallery_settings AS m__idms_products_gallery_settings, m.image_alt AS m__image_alt FROM ms_products_gallery_settings m WHERE (m.idproducts_gallery = ?) - (412464846) |
| 133 | Doctrine_Connection_Statement | execute : SELECT m.ms_lang_install_signature AS m__ms_lang_install_signature, m.products_shop_idshop AS m__products_shop_idshop, m2.idlang_install AS m2__idlang_install, m2.name AS m2__name, m2.signature AS m2__signature, m2.publication AS m2__publication, m2.lang_icons AS m2__lang_icons FROM ms_lang_install_has_products_shop m INNER JOIN ms_lang_install m2 ON m.ms_lang_install_signature = m2.signature WHERE (m2.publication = ? AND m.products_shop_idshop = ?) - (1, 38) |
| 134 | Doctrine_Connection_Statement | execute : SELECT u.idusers AS u__idusers, u.landline_phone AS u__landline_phone FROM users u WHERE (u.profil_account = ? AND u.active = ? AND u.landline_phone != ?) ORDER BY RAND() - (0, 1, ) |
| 135 | Doctrine_Connection_Statement | execute : SELECT p.products_idproducts AS p__products_idproducts, p.amount_local AS p__amount_local, p.amount_import AS p__amount_import, p.next_delivery_amount AS p__next_delivery_amount, p.next_delivery_date AS p__next_delivery_date FROM products_stock p WHERE (p.products_idproducts = ?) - (155264) |
| 136 | Doctrine_Connection_Statement | execute : SELECT m.ms_lang_install_signature AS m__ms_lang_install_signature, m.products_shop_idshop AS m__products_shop_idshop, m2.idlang_install AS m2__idlang_install, m2.name AS m2__name, m2.signature AS m2__signature, m2.publication AS m2__publication, m2.lang_icons AS m2__lang_icons FROM ms_lang_install_has_products_shop m INNER JOIN ms_lang_install m2 ON m.ms_lang_install_signature = m2.signature WHERE (m2.publication = ? AND m.products_shop_idshop = ?) - (1, 38) |
| 137 | Doctrine_Connection_Statement | execute : SELECT m.ms_lang_install_signature AS m__ms_lang_install_signature, m.products_shop_idshop AS m__products_shop_idshop, m2.idlang_install AS m2__idlang_install, m2.name AS m2__name, m2.signature AS m2__signature, m2.publication AS m2__publication, m2.lang_icons AS m2__lang_icons FROM ms_lang_install_has_products_shop m INNER JOIN ms_lang_install m2 ON m.ms_lang_install_signature = m2.signature WHERE (m2.publication = ? AND m.products_shop_idshop = ?) - (1, 38) |
| 138 | Doctrine_Connection_Statement | execute : SELECT m.ms_lang_install_signature AS m__ms_lang_install_signature, m.products_idproducts AS m__products_idproducts, m.lang_name AS m__lang_name, m.lang_body AS m__lang_body, m.lang_body_weight AS m__lang_body_weight, m.lang_body_size AS m__lang_body_size, m.lang_body_material AS m__lang_body_material, m.lang_body_print_tech AS m__lang_body_print_tech, m.lang_body_print_size AS m__lang_body_print_size, m.lang_body_handling AS m__lang_body_handling, m.lang_name_url AS m__lang_name_url FROM ms_products_i18n m WHERE (m.products_idproducts = ? AND m.ms_lang_install_signature = ?) - (155264, pl) |
| 139 | Doctrine_Connection_Statement | execute : SELECT m.idms_products_custom_description AS m__idms_products_custom_description, m.body AS m__body, m.created_at AS m__created_at, m.updated_at AS m__updated_at, m.users_idusers AS m__users_idusers, m.products_idproducts AS m__products_idproducts, m.products_shop_idshop AS m__products_shop_idshop FROM ms_products_custom_description m WHERE (m.products_idproducts = ? AND m.products_shop_idshop = ?) - (155264, 38) |
| 140 | Doctrine_Connection_Statement | execute : SELECT p.idproducts_location AS p__idproducts_location FROM products_location p WHERE (p.products_idproducts = ? AND p.products_shop_idshop = ?) - (155264, 38) |
| 141 | Doctrine_Connection_Statement | execute : SELECT p.idproducts_price_range AS p__idproducts_price_range, p.price_range AS p__price_range, p.price_customer AS p__price_customer, p.price_agency AS p__price_agency, p.products_location_idproducts_location AS p__products_location_idproducts_location, p.price_range_text AS p__price_range_text, p.min_amount AS p__min_amount, p.max_amount AS p__max_amount, p.recommendation AS p__recommendation FROM products_price_range p WHERE (p.products_location_idproducts_location = ? AND p.price_range <= ?) ORDER BY p.price_range DESC - (37779090, 1) |
| 142 | Doctrine_Connection_Statement | execute : SELECT m.idms_products_promotion_price_range AS m__idms_products_promotion_price_range, m.price_range AS m__price_range, m.price_range_text AS m__price_range_text, m.price_customer AS m__price_customer, m.price_agency AS m__price_agency, m.products_location_idproducts_location AS m__products_location_idproducts_location, m.ms_products_promotion_idms_products_promotion AS m__ms_products_promotion_idms_products_promotion, m.min_amount AS m__min_amount, m.max_amount AS m__max_amount, m2.idms_products_promotion AS m2__idms_products_promotion, m2.title AS m2__title, m2.description AS m2__description, m2.created_at AS m2__created_at, m2.time_start AS m2__time_start, m2.time_end AS m2__time_end, m2.active AS m2__active, m2.max_products AS m2__max_products, m2.min_products AS m2__min_products, m2.discount_code AS m2__discount_code, m2.sale_type AS m2__sale_type, m2.sale_value AS m2__sale_value, m2.order_amount_min AS m2__order_amount_min, m2.order_amount_max AS m2__order_amount_max, m2.discount_code_limit AS m2__discount_code_limit, m2.discount_code_customers_usage_limit AS m2__discount_code_customers_usage_limit, m2.task_status AS m2__task_status, m2.task_products_processed AS m2__task_products_processed, m2.task_products_count AS m2__task_products_count, m2.task_time_start AS m2__task_time_start, m2.task_time_end AS m2__task_time_end, m2.view_label_list AS m2__view_label_list, m2.view_label_show AS m2__view_label_show, m2.tag AS m2__tag FROM ms_products_promotion_price_range m INNER JOIN ms_products_promotion m2 ON m.ms_products_promotion_idms_products_promotion = m2.idms_products_promotion WHERE (m.products_location_idproducts_location = ? AND (m2.time_start <= ? AND m2.time_end >= ? AND m2.active = ?) AND m.price_range <= ?) ORDER BY m.price_range DESC - (37779090, 1765833684, 1765833684, 1, 1) |
| 143 | main | Call "products->executeValuation()" |
| 144 | Doctrine_Connection_Statement | execute : SELECT p.idproducts AS p__idproducts, p.product_index AS p__product_index, p.price_brutto AS p__price_brutto, p.meta_link_canonical AS p__meta_link_canonical FROM products p WHERE (p.idproducts = ?) - (155264) |
| 145 | Doctrine_Connection_Statement | execute : SELECT m.idmsoffercreatorvaluation AS m__idmsoffercreatorvaluation, m.count_title AS m__count_title, m.count_desc AS m__count_desc, m.type_title AS m__type_title, m.type_desc AS m__type_desc, m.color_title AS m__color_title, m.color_desc AS m__color_desc, m.place_title AS m__place_title, m.place_desc AS m__place_desc FROM ms_offer_creator_valuation m WHERE (m.idmsoffercreatorvaluation = ?) - (1) |
| 146 | Doctrine_Connection_Statement | execute : SELECT m.ms_lang_install_signature AS m__ms_lang_install_signature, m.products_shop_idshop AS m__products_shop_idshop, m2.idlang_install AS m2__idlang_install, m2.name AS m2__name, m2.signature AS m2__signature, m2.publication AS m2__publication, m2.lang_icons AS m2__lang_icons FROM ms_lang_install_has_products_shop m INNER JOIN ms_lang_install m2 ON m.ms_lang_install_signature = m2.signature WHERE (m2.publication = ? AND m.products_shop_idshop = ?) - (1, 38) |
| 147 | Doctrine_Connection_Statement | execute : SELECT p.idms_offer_creator_marking_type AS p__idms_offer_creator_marking_type, p.products_idproducts AS p__products_idproducts, m.idms_offer_creator_marking_type AS m__idms_offer_creator_marking_type, m.name_full AS m__name_full, m.max_color AS m__max_color FROM products_settings_marking_type p INNER JOIN ms_offer_creator_marking_type m ON p.idms_offer_creator_marking_type = m.idms_offer_creator_marking_type WHERE (p.products_idproducts = ? AND m.publication = ? AND (p.verified = ? OR p.verified = ?)) ORDER BY m.position ASC - (155264, 1, 1, 2) |
| 148 | Doctrine_Connection_Statement | execute : SELECT m.idms_offer_creator_marking_type AS m__idms_offer_creator_marking_type, m.section_amount_input AS m__section_amount_input FROM ms_offer_creator_marking_type m WHERE (m.idms_offer_creator_marking_type IN (?, ?, ?, ?, ?, ?)) - (33, 23, 24, 25, 27, 26) |
| 149 | sfPartialView | Render "sf_app_dir/modules/products/templates/_valuation.php" |
| 150 | Doctrine_Connection_Statement | execute : SELECT m.ms_lang_install_signature AS m__ms_lang_install_signature, m.products_shop_idshop AS m__products_shop_idshop, m2.idlang_install AS m2__idlang_install, m2.name AS m2__name, m2.signature AS m2__signature, m2.publication AS m2__publication, m2.lang_icons AS m2__lang_icons FROM ms_lang_install_has_products_shop m INNER JOIN ms_lang_install m2 ON m.ms_lang_install_signature = m2.signature WHERE (m2.publication = ? AND m.products_shop_idshop = ?) - (1, 38) |
| 151 | Doctrine_Connection_Statement | execute : SELECT m.ms_lang_install_signature AS m__ms_lang_install_signature, m.products_shop_idshop AS m__products_shop_idshop, m2.idlang_install AS m2__idlang_install, m2.name AS m2__name, m2.signature AS m2__signature, m2.publication AS m2__publication, m2.lang_icons AS m2__lang_icons FROM ms_lang_install_has_products_shop m INNER JOIN ms_lang_install m2 ON m.ms_lang_install_signature = m2.signature WHERE (m2.publication = ? AND m.products_shop_idshop = ?) - (1, 38) |
| 152 | Doctrine_Connection_Statement | execute : SELECT t.idtag_page AS t__idtag_page, t.name AS t__name, t.description AS t__description, t.active AS t__active FROM tag_system_page t WHERE (t.name = ?) - (privacy_policy_contact_form) |
| 153 | Doctrine_Connection_Statement | execute : SELECT p.idproducts AS p__idproducts, p.name AS p__name, p.body AS p__body, p.active AS p__active, p.product_index AS p__product_index, p.created_at AS p__created_at, p.price AS p__price, p.price_promotion AS p__price_promotion, p.price_wholesaler AS p__price_wholesaler, p.price_thresholds AS p__price_thresholds, p.products_manufacturer_idproducts_manufacturer AS p__products_manufacturer_idproducts_manufacturer, p.products_status_idproducts_status AS p__products_status_idproducts_status, p.products_unit_idproducts_unit AS p__products_unit_idproducts_unit, p.products_tax_idproducts_tax AS p__products_tax_idproducts_tax, p.no_premium AS p__no_premium, p.price_min_wholeseller AS p__price_min_wholeseller, p.price_min_regular AS p__price_min_regular, p.price_buy AS p__price_buy, p.catalogue_price AS p__catalogue_price, p.body_weight AS p__body_weight, p.body_size AS p__body_size, p.body_material AS p__body_material, p.body_print_tech AS p__body_print_tech, p.body_print_size AS p__body_print_size, p.body_handling AS p__body_handling, p.ms_products_color_idms_products_color AS p__ms_products_color_idms_products_color, p.name_url AS p__name_url, p.last_update AS p__last_update, p.type AS p__type, p.import_photo AS p__import_photo, p.color_hex AS p__color_hex, p.color_manu AS p__color_manu, p.last_update_prev_price_buy AS p__last_update_prev_price_buy, p.last_update_prev AS p__last_update_prev, p.id_product_manufacturer AS p__id_product_manufacturer, p.model_product_manufacturer AS p__model_product_manufacturer, p.price_brutto AS p__price_brutto, p.meta_link_canonical AS p__meta_link_canonical, p.code_product_manufacturer AS p__code_product_manufacturer, p.tags AS p__tags, p.slug AS p__slug, p.show_on_store AS p__show_on_store, p.ms_product_index AS p__ms_product_index, p.price_range_divisor AS p__price_range_divisor, p.merchant_status AS p__merchant_status, p.idproducts_sync AS p__idproducts_sync, p.disable_price_calculation AS p__disable_price_calculation, p.gratisownia_shop_menu_names AS p__gratisownia_shop_menu_names FROM products p WHERE (p.idproducts = ?) LIMIT 1 - (155264) |
| 154 | Doctrine_Connection_Statement | execute : SELECT p.idproducts_has_color AS p__idproducts_has_color, p.color_hex AS p__color_hex FROM products_has_color p WHERE (p.products_idproducts = ?) - (155264) |
| 155 | Doctrine_Connection_Statement | execute : SELECT p.idproducts_color AS p__idproducts_color, p.name AS p__name FROM products_color p WHERE (p.tag = ?) - (#279107) |
| 156 | Doctrine_Connection_Statement | execute : SELECT p.idproducts_has_color AS p__idproducts_has_color, p.color_hex AS p__color_hex FROM products_has_color p WHERE (p.products_idproducts = ?) - (155264) |
| 157 | Doctrine_Connection_Statement | execute : SELECT p.idproducts_color AS p__idproducts_color, p.name AS p__name FROM products_color p WHERE (p.tag = ?) - (#279107) |
| 158 | Doctrine_Connection_Statement | execute : SELECT m.ms_lang_install_signature AS m__ms_lang_install_signature, m.products_shop_idshop AS m__products_shop_idshop, m2.idlang_install AS m2__idlang_install, m2.name AS m2__name, m2.signature AS m2__signature, m2.publication AS m2__publication, m2.lang_icons AS m2__lang_icons FROM ms_lang_install_has_products_shop m INNER JOIN ms_lang_install m2 ON m.ms_lang_install_signature = m2.signature WHERE (m2.publication = ? AND m.products_shop_idshop = ?) - (1, 38) |
| 159 | Doctrine_Connection_Statement | execute : SELECT p.idms_offer_creator_marking_type AS p__idms_offer_creator_marking_type, p.products_idproducts AS p__products_idproducts, m.idms_offer_creator_marking_type AS m__idms_offer_creator_marking_type, m.name AS m__name, m.name_full AS m__name_full, m.desc_text AS m__desc_text FROM products_settings_marking_type p INNER JOIN ms_offer_creator_marking_type m ON p.idms_offer_creator_marking_type = m.idms_offer_creator_marking_type WHERE ((p.products_idproducts = ? AND (p.verified = ? OR p.verified = ?)) AND m.publication = ?) - (155264, 1, 2, 1) |
| 160 | Doctrine_Connection_Statement | execute : SELECT m.ms_lang_install_signature AS m__ms_lang_install_signature, m.products_shop_idshop AS m__products_shop_idshop, m2.idlang_install AS m2__idlang_install, m2.name AS m2__name, m2.signature AS m2__signature, m2.publication AS m2__publication, m2.lang_icons AS m2__lang_icons FROM ms_lang_install_has_products_shop m INNER JOIN ms_lang_install m2 ON m.ms_lang_install_signature = m2.signature WHERE (m2.publication = ? AND m.products_shop_idshop = ?) - (1, 38) |
| 161 | Doctrine_Connection_Statement | execute : SELECT p.idms_offer_creator_marking_type AS p__idms_offer_creator_marking_type, p.products_idproducts AS p__products_idproducts, m.idms_offer_creator_marking_type AS m__idms_offer_creator_marking_type, m.name AS m__name, m.name_full AS m__name_full, m.desc_text AS m__desc_text FROM products_settings_marking_type p INNER JOIN ms_offer_creator_marking_type m ON p.idms_offer_creator_marking_type = m.idms_offer_creator_marking_type WHERE ((p.products_idproducts = ? AND (p.verified = ? OR p.verified = ?)) AND m.publication = ?) - (155264, 1, 2, 1) |
| 162 | Doctrine_Connection_Statement | execute : SELECT p.products_has_products_print_position_id AS p__products_has_products_print_position_id, p.products_idproducts AS p__products_idproducts, p.products_print_position_idproducts_print_position AS p__products_print_position_idproducts_print_position, p.products_print_technique_idproducts_print_technique AS p__products_print_technique_idproducts_print_technique, p2.idproducts_print_position AS p2__idproducts_print_position, p2.position_manu_name AS p2__position_manu_name, p2.width AS p2__width, p2.height AS p2__height, p2.size_unit AS p2__size_unit, p3.idproducts_print_technique AS p3__idproducts_print_technique, p3.technique_manu_name AS p3__technique_manu_name FROM products_has_products_print_position p INNER JOIN products_print_position p2 ON p.products_print_position_idproducts_print_position = p2.idproducts_print_position INNER JOIN products_print_technique p3 ON p.products_print_technique_idproducts_print_technique = p3.idproducts_print_technique WHERE (p.products_idproducts = ?) ORDER BY p3.idproducts_print_technique - (155264) |
| 163 | sfPHPView | Decorate content with "sf_app_dir/templates/layout.php" |
| 164 | sfPHPView | Render "sf_app_dir/templates/layout.php" |
| 165 | main | Call "home->executeMeta()" |
| 166 | sfPartialView | Render "sf_app_dir/modules/home/templates/_meta.php" |
| 167 | Doctrine_Connection_Statement | execute : SELECT p.idproducts AS p__idproducts, p.name AS p__name, p.body AS p__body, p.active AS p__active, p.product_index AS p__product_index, p.created_at AS p__created_at, p.price AS p__price, p.price_promotion AS p__price_promotion, p.price_wholesaler AS p__price_wholesaler, p.price_thresholds AS p__price_thresholds, p.products_manufacturer_idproducts_manufacturer AS p__products_manufacturer_idproducts_manufacturer, p.products_status_idproducts_status AS p__products_status_idproducts_status, p.products_unit_idproducts_unit AS p__products_unit_idproducts_unit, p.products_tax_idproducts_tax AS p__products_tax_idproducts_tax, p.no_premium AS p__no_premium, p.price_min_wholeseller AS p__price_min_wholeseller, p.price_min_regular AS p__price_min_regular, p.price_buy AS p__price_buy, p.catalogue_price AS p__catalogue_price, p.body_weight AS p__body_weight, p.body_size AS p__body_size, p.body_material AS p__body_material, p.body_print_tech AS p__body_print_tech, p.body_print_size AS p__body_print_size, p.body_handling AS p__body_handling, p.ms_products_color_idms_products_color AS p__ms_products_color_idms_products_color, p.name_url AS p__name_url, p.last_update AS p__last_update, p.type AS p__type, p.import_photo AS p__import_photo, p.color_hex AS p__color_hex, p.color_manu AS p__color_manu, p.last_update_prev_price_buy AS p__last_update_prev_price_buy, p.last_update_prev AS p__last_update_prev, p.id_product_manufacturer AS p__id_product_manufacturer, p.model_product_manufacturer AS p__model_product_manufacturer, p.price_brutto AS p__price_brutto, p.meta_link_canonical AS p__meta_link_canonical, p.code_product_manufacturer AS p__code_product_manufacturer, p.tags AS p__tags, p.slug AS p__slug, p.show_on_store AS p__show_on_store, p.ms_product_index AS p__ms_product_index, p.price_range_divisor AS p__price_range_divisor, p.merchant_status AS p__merchant_status, p.idproducts_sync AS p__idproducts_sync, p.disable_price_calculation AS p__disable_price_calculation, p.gratisownia_shop_menu_names AS p__gratisownia_shop_menu_names FROM products p WHERE (p.product_index = ? OR p.ms_product_index = ?) - (T9300-005-L, T9300-005-L) |
| 168 | Doctrine_Connection_Statement | execute : SELECT p.idproducts AS p__idproducts, p.name AS p__name, p.body AS p__body, p.active AS p__active, p.product_index AS p__product_index, p.created_at AS p__created_at, p.price AS p__price, p.price_promotion AS p__price_promotion, p.price_wholesaler AS p__price_wholesaler, p.price_thresholds AS p__price_thresholds, p.products_manufacturer_idproducts_manufacturer AS p__products_manufacturer_idproducts_manufacturer, p.products_status_idproducts_status AS p__products_status_idproducts_status, p.products_unit_idproducts_unit AS p__products_unit_idproducts_unit, p.products_tax_idproducts_tax AS p__products_tax_idproducts_tax, p.no_premium AS p__no_premium, p.price_min_wholeseller AS p__price_min_wholeseller, p.price_min_regular AS p__price_min_regular, p.price_buy AS p__price_buy, p.catalogue_price AS p__catalogue_price, p.body_weight AS p__body_weight, p.body_size AS p__body_size, p.body_material AS p__body_material, p.body_print_tech AS p__body_print_tech, p.body_print_size AS p__body_print_size, p.body_handling AS p__body_handling, p.ms_products_color_idms_products_color AS p__ms_products_color_idms_products_color, p.name_url AS p__name_url, p.last_update AS p__last_update, p.type AS p__type, p.import_photo AS p__import_photo, p.color_hex AS p__color_hex, p.color_manu AS p__color_manu, p.last_update_prev_price_buy AS p__last_update_prev_price_buy, p.last_update_prev AS p__last_update_prev, p.id_product_manufacturer AS p__id_product_manufacturer, p.model_product_manufacturer AS p__model_product_manufacturer, p.price_brutto AS p__price_brutto, p.meta_link_canonical AS p__meta_link_canonical, p.code_product_manufacturer AS p__code_product_manufacturer, p.tags AS p__tags, p.slug AS p__slug, p.show_on_store AS p__show_on_store, p.ms_product_index AS p__ms_product_index, p.price_range_divisor AS p__price_range_divisor, p.merchant_status AS p__merchant_status, p.idproducts_sync AS p__idproducts_sync, p.disable_price_calculation AS p__disable_price_calculation, p.gratisownia_shop_menu_names AS p__gratisownia_shop_menu_names FROM products p WHERE (p.product_index = ? OR p.ms_product_index = ?) - (T9300-005-L, T9300-005-L) |
| 169 | main | Call "home->executeLang()" |
| 170 | sfPartialView | Render "sf_app_dir/modules/home/templates/_lang.php" |
| 171 | Doctrine_Connection_Statement | execute : SELECT m.ms_lang_install_signature AS m__ms_lang_install_signature, m.products_shop_idshop AS m__products_shop_idshop, m2.idlang_install AS m2__idlang_install, m2.name AS m2__name, m2.signature AS m2__signature, m2.publication AS m2__publication, m2.lang_icons AS m2__lang_icons FROM ms_lang_install_has_products_shop m INNER JOIN ms_lang_install m2 ON m.ms_lang_install_signature = m2.signature WHERE (m2.publication = ? AND m.products_shop_idshop = ?) - (1, 38) |
| 172 | Doctrine_Connection_Statement | execute : SELECT m.ms_lang_install_signature AS m__ms_lang_install_signature, m.products_shop_idshop AS m__products_shop_idshop, m2.idlang_install AS m2__idlang_install, m2.name AS m2__name, m2.signature AS m2__signature, m2.publication AS m2__publication, m2.lang_icons AS m2__lang_icons FROM ms_lang_install_has_products_shop m INNER JOIN ms_lang_install m2 ON m.ms_lang_install_signature = m2.signature WHERE (m2.publication = ? AND m.products_shop_idshop = ?) - (1, 38) |
| 173 | Doctrine_Connection_Statement | execute : SELECT m.ms_lang_install_signature AS m__ms_lang_install_signature, m.products_shop_idshop AS m__products_shop_idshop, m2.idlang_install AS m2__idlang_install, m2.name AS m2__name, m2.signature AS m2__signature, m2.publication AS m2__publication, m2.lang_icons AS m2__lang_icons FROM ms_lang_install_has_products_shop m INNER JOIN ms_lang_install m2 ON m.ms_lang_install_signature = m2.signature WHERE (m2.publication = ? AND m.products_shop_idshop = ?) - (1, 38) |
| 174 | sfViewCacheManager | Generate cache key |
| 175 | sfViewCacheManager | Cache for "@sf_cache_partial?module=cms&action=_menutop&sf_cache_key=40cd750bba9870f18aada2478b24840a" exists |
| 176 | main | Call "home->executeTechnicalProblems()" |
| 177 | Doctrine_Connection_Statement | execute : SELECT m.ms_lang_install_signature AS m__ms_lang_install_signature, m.products_shop_idshop AS m__products_shop_idshop, m2.idlang_install AS m2__idlang_install, m2.name AS m2__name, m2.signature AS m2__signature, m2.publication AS m2__publication, m2.lang_icons AS m2__lang_icons FROM ms_lang_install_has_products_shop m INNER JOIN ms_lang_install m2 ON m.ms_lang_install_signature = m2.signature WHERE (m2.publication = ? AND m.products_shop_idshop = ?) - (1, 38) |
| 178 | Doctrine_Connection_Statement | execute : SELECT m.idms_popup_information AS m__idms_popup_information, m.system_name AS m__system_name, m.title AS m__title, m.description AS m__description, m.status AS m__status, m.created_at AS m__created_at FROM ms_popup_information m WHERE (m.status = ?) - (1) |
| 179 | sfPartialView | Render "sf_app_dir/modules/home/templates/_technicalProblems.php" |
| 180 | main | Call "cms->executeGetPageContent()" |
| 181 | sfPartialView | Render "sf_app_dir/modules/cms/templates/_getPageContent.php" |
| 182 | main | Call "products->executeLocation()" |
| 183 | Doctrine_Connection_Statement | execute : SELECT p.idproducts AS p__idproducts, p.name AS p__name, p.body AS p__body, p.active AS p__active, p.product_index AS p__product_index, p.created_at AS p__created_at, p.price AS p__price, p.price_promotion AS p__price_promotion, p.price_wholesaler AS p__price_wholesaler, p.price_thresholds AS p__price_thresholds, p.products_manufacturer_idproducts_manufacturer AS p__products_manufacturer_idproducts_manufacturer, p.products_status_idproducts_status AS p__products_status_idproducts_status, p.products_unit_idproducts_unit AS p__products_unit_idproducts_unit, p.products_tax_idproducts_tax AS p__products_tax_idproducts_tax, p.no_premium AS p__no_premium, p.price_min_wholeseller AS p__price_min_wholeseller, p.price_min_regular AS p__price_min_regular, p.price_buy AS p__price_buy, p.catalogue_price AS p__catalogue_price, p.body_weight AS p__body_weight, p.body_size AS p__body_size, p.body_material AS p__body_material, p.body_print_tech AS p__body_print_tech, p.body_print_size AS p__body_print_size, p.body_handling AS p__body_handling, p.ms_products_color_idms_products_color AS p__ms_products_color_idms_products_color, p.name_url AS p__name_url, p.last_update AS p__last_update, p.type AS p__type, p.import_photo AS p__import_photo, p.color_hex AS p__color_hex, p.color_manu AS p__color_manu, p.last_update_prev_price_buy AS p__last_update_prev_price_buy, p.last_update_prev AS p__last_update_prev, p.id_product_manufacturer AS p__id_product_manufacturer, p.model_product_manufacturer AS p__model_product_manufacturer, p.price_brutto AS p__price_brutto, p.meta_link_canonical AS p__meta_link_canonical, p.code_product_manufacturer AS p__code_product_manufacturer, p.tags AS p__tags, p.slug AS p__slug, p.show_on_store AS p__show_on_store, p.ms_product_index AS p__ms_product_index, p.price_range_divisor AS p__price_range_divisor, p.merchant_status AS p__merchant_status, p.idproducts_sync AS p__idproducts_sync, p.disable_price_calculation AS p__disable_price_calculation, p.gratisownia_shop_menu_names AS p__gratisownia_shop_menu_names FROM products p WHERE (p.product_index = ?) LIMIT 1 - (T9300-005-L) |
| 184 | Doctrine_Connection_Statement | execute : SELECT p.idproducts_location AS p__idproducts_location, p.products_shop_idshop AS p__products_shop_idshop, p.products_catalog_idproducts_catalog AS p__products_catalog_idproducts_catalog, p.products_category_idproducts_category AS p__products_category_idproducts_category, p.products_idproducts AS p__products_idproducts, p.products_price_thresholds AS p__products_price_thresholds, p.products_price_range_max_agency AS p__products_price_range_max_agency, p.products_price_range_max_customer AS p__products_price_range_max_customer, p.idms_currency_type AS p__idms_currency_type, p.idms_products_menu AS p__idms_products_menu, p2.idproducts_category AS p2__idproducts_category, p2.name AS p2__name, p2.publication AS p2__publication FROM products_location p LEFT JOIN products_category p2 ON p.products_category_idproducts_category = p2.idproducts_category WHERE (p.products_shop_idshop = ? AND p.products_idproducts = ?) - (38, 155264) |
| 185 | Doctrine_Connection_Statement | execute : SELECT p.idproducts_menu AS p__idproducts_menu, p.products_shop_idshop AS p__products_shop_idshop, p.products_category_idproducts_category AS p__products_category_idproducts_category, p.products_catalog_idproducts_catalog AS p__products_catalog_idproducts_catalog, p.personal_name_category AS p__personal_name_category, p.personal_name_catalog AS p__personal_name_catalog, p.publication AS p__publication, p.meta_keywords AS p__meta_keywords, p.meta_description AS p__meta_description, p.custom_h1 AS p__custom_h1, p.custom_description AS p__custom_description, p.custom_title AS p__custom_title, p.name_for_url_link AS p__name_for_url_link, p.position_row AS p__position_row, p.position_row_catalog AS p__position_row_catalog, p.link_to_redirect AS p__link_to_redirect, p.name_for_url_link_catalog AS p__name_for_url_link_catalog, p.custom_h1_catalog AS p__custom_h1_catalog, p.custom_description_catalog AS p__custom_description_catalog, p.custom_title_catalog AS p__custom_title_catalog, p.publication_catalog AS p__publication_catalog, p.google_robots_status AS p__google_robots_status, p.google_robots_status_catalog AS p__google_robots_status_catalog, p.icon_class AS p__icon_class, p2.idproducts_catalog AS p2__idproducts_catalog, p2.name AS p2__name, p2.publication AS p2__publication, p3.idproducts_category AS p3__idproducts_category, p3.name AS p3__name, p3.publication AS p3__publication FROM products_menu p LEFT JOIN products_catalog p2 ON p.products_catalog_idproducts_catalog = p2.idproducts_catalog LEFT JOIN products_category p3 ON p.products_category_idproducts_category = p3.idproducts_category WHERE (p.products_shop_idshop = ? AND p.products_category_idproducts_category = ? AND p.publication = ?) - (38, 1651, 1) |
| 186 | Doctrine_Connection_Statement | execute : SELECT p.idproducts AS p__idproducts, p.name AS p__name, p.body AS p__body, p.active AS p__active, p.product_index AS p__product_index, p.created_at AS p__created_at, p.price AS p__price, p.price_promotion AS p__price_promotion, p.price_wholesaler AS p__price_wholesaler, p.price_thresholds AS p__price_thresholds, p.products_manufacturer_idproducts_manufacturer AS p__products_manufacturer_idproducts_manufacturer, p.products_status_idproducts_status AS p__products_status_idproducts_status, p.products_unit_idproducts_unit AS p__products_unit_idproducts_unit, p.products_tax_idproducts_tax AS p__products_tax_idproducts_tax, p.no_premium AS p__no_premium, p.price_min_wholeseller AS p__price_min_wholeseller, p.price_min_regular AS p__price_min_regular, p.price_buy AS p__price_buy, p.catalogue_price AS p__catalogue_price, p.body_weight AS p__body_weight, p.body_size AS p__body_size, p.body_material AS p__body_material, p.body_print_tech AS p__body_print_tech, p.body_print_size AS p__body_print_size, p.body_handling AS p__body_handling, p.ms_products_color_idms_products_color AS p__ms_products_color_idms_products_color, p.name_url AS p__name_url, p.last_update AS p__last_update, p.type AS p__type, p.import_photo AS p__import_photo, p.color_hex AS p__color_hex, p.color_manu AS p__color_manu, p.last_update_prev_price_buy AS p__last_update_prev_price_buy, p.last_update_prev AS p__last_update_prev, p.id_product_manufacturer AS p__id_product_manufacturer, p.model_product_manufacturer AS p__model_product_manufacturer, p.price_brutto AS p__price_brutto, p.meta_link_canonical AS p__meta_link_canonical, p.code_product_manufacturer AS p__code_product_manufacturer, p.tags AS p__tags, p.slug AS p__slug, p.show_on_store AS p__show_on_store, p.ms_product_index AS p__ms_product_index, p.price_range_divisor AS p__price_range_divisor, p.merchant_status AS p__merchant_status, p.idproducts_sync AS p__idproducts_sync, p.disable_price_calculation AS p__disable_price_calculation, p.gratisownia_shop_menu_names AS p__gratisownia_shop_menu_names FROM products p WHERE (p.product_index = ?) LIMIT 1 - (T9300-005-L) |
| 187 | Doctrine_Connection_Statement | execute : SELECT p.idproducts_location AS p__idproducts_location, p.products_shop_idshop AS p__products_shop_idshop, p.products_catalog_idproducts_catalog AS p__products_catalog_idproducts_catalog, p.products_category_idproducts_category AS p__products_category_idproducts_category, p.products_idproducts AS p__products_idproducts, p.products_price_thresholds AS p__products_price_thresholds, p.products_price_range_max_agency AS p__products_price_range_max_agency, p.products_price_range_max_customer AS p__products_price_range_max_customer, p.idms_currency_type AS p__idms_currency_type, p.idms_products_menu AS p__idms_products_menu FROM products_location p WHERE (p.products_shop_idshop = ? AND p.products_idproducts = ?) - (38, 155264) |
| 188 | Doctrine_Connection_Statement | execute : SELECT p.idproducts_menu AS p__idproducts_menu, p.products_shop_idshop AS p__products_shop_idshop, p.products_category_idproducts_category AS p__products_category_idproducts_category, p.products_catalog_idproducts_catalog AS p__products_catalog_idproducts_catalog, p.personal_name_category AS p__personal_name_category, p.personal_name_catalog AS p__personal_name_catalog, p.publication AS p__publication, p.meta_keywords AS p__meta_keywords, p.meta_description AS p__meta_description, p.custom_h1 AS p__custom_h1, p.custom_description AS p__custom_description, p.custom_title AS p__custom_title, p.name_for_url_link AS p__name_for_url_link, p.position_row AS p__position_row, p.position_row_catalog AS p__position_row_catalog, p.link_to_redirect AS p__link_to_redirect, p.name_for_url_link_catalog AS p__name_for_url_link_catalog, p.custom_h1_catalog AS p__custom_h1_catalog, p.custom_description_catalog AS p__custom_description_catalog, p.custom_title_catalog AS p__custom_title_catalog, p.publication_catalog AS p__publication_catalog, p.google_robots_status AS p__google_robots_status, p.google_robots_status_catalog AS p__google_robots_status_catalog, p.icon_class AS p__icon_class FROM products_menu p WHERE (p.products_shop_idshop = ? AND p.products_category_idproducts_category = ? AND p.publication = ?) - (38, 1651, 1) |
| 189 | Doctrine_Connection_Statement | execute : SELECT p.idproducts_catalog AS p__idproducts_catalog, p.name AS p__name, p.publication AS p__publication FROM products_catalog p WHERE (p.idproducts_catalog = ?) LIMIT 1 - (156) |
| 190 | Doctrine_Connection_Statement | execute : SELECT p.idproducts_category AS p__idproducts_category, p.name AS p__name, p.publication AS p__publication FROM products_category p WHERE (p.idproducts_category = ?) LIMIT 1 - (1651) |
| 191 | Doctrine_Connection_Statement | execute : SELECT m.ms_lang_install_signature AS m__ms_lang_install_signature, m.products_category_idproducts_category AS m__products_category_idproducts_category, m.lang_name AS m__lang_name FROM ms_products_category_i18n m WHERE (m.products_category_idproducts_category = ? AND m.ms_lang_install_signature = ?) - (1651, de) |
| 192 | Doctrine_Connection_Statement | execute : SELECT m.ms_lang_install_signature AS m__ms_lang_install_signature, m.products_shop_idshop AS m__products_shop_idshop, m2.idlang_install AS m2__idlang_install, m2.name AS m2__name, m2.signature AS m2__signature, m2.publication AS m2__publication, m2.lang_icons AS m2__lang_icons FROM ms_lang_install_has_products_shop m INNER JOIN ms_lang_install m2 ON m.ms_lang_install_signature = m2.signature WHERE (m2.publication = ? AND m.products_shop_idshop = ?) - (1, 38) |
| 193 | Doctrine_Connection_Statement | execute : SELECT p.idproducts_catalog AS p__idproducts_catalog, p.name AS p__name FROM products_catalog p INNER JOIN products_menu p2 ON p.idproducts_catalog = p2.products_catalog_idproducts_catalog AND (p2.products_shop_idshop = ?) WHERE (p.publication = ?) - (38, 1) |
| 194 | Doctrine_Connection_Statement | execute : SELECT p.idproducts_category AS p__idproducts_category, p.name AS p__name FROM products_category p INNER JOIN products_menu p2 ON p.idproducts_category = p2.products_category_idproducts_category AND (p2.products_shop_idshop = ?) WHERE (p.publication = ? AND p.idproducts_category = ?) - (38, 1, 1651) |
| 195 | Doctrine_Connection_Statement | execute : SELECT p.idproducts_menu AS p__idproducts_menu, p.products_catalog_idproducts_catalog AS p__products_catalog_idproducts_catalog, p.products_category_idproducts_category AS p__products_category_idproducts_category, p.personal_name_catalog AS p__personal_name_catalog, p.personal_name_category AS p__personal_name_category, p.name_for_url_link AS p__name_for_url_link, p.name_for_url_link_catalog AS p__name_for_url_link_catalog, p.publication AS p__publication, p.publication_catalog AS p__publication_catalog, p.position_row AS p__position_row, p.link_to_redirect AS p__link_to_redirect, p.position_row_catalog AS p__position_row_catalog, p.google_robots_status AS p__google_robots_status, p.google_robots_status_catalog AS p__google_robots_status_catalog, p.icon_class AS p__icon_class, p.custom_h1 AS p__custom_h1, p.custom_description AS p__custom_description, p.custom_title AS p__custom_title FROM products_menu p WHERE (p.products_shop_idshop = ? AND (p.publication = ? AND p.publication_catalog = ?)) ORDER BY p.position_row_catalog ASC,p.position_row ASC - (38, 1, 1) |
| 196 | Doctrine_Connection_Statement | execute : SELECT m.ms_lang_install_signature AS m__ms_lang_install_signature, m.products_shop_idshop AS m__products_shop_idshop, m2.idlang_install AS m2__idlang_install, m2.name AS m2__name, m2.signature AS m2__signature, m2.publication AS m2__publication, m2.lang_icons AS m2__lang_icons FROM ms_lang_install_has_products_shop m INNER JOIN ms_lang_install m2 ON m.ms_lang_install_signature = m2.signature WHERE (m2.publication = ? AND m.products_shop_idshop = ?) - (1, 38) |
| 197 | Doctrine_Connection_Statement | execute : SELECT p.idproducts AS p__idproducts, p.name AS p__name, p.body AS p__body, p.active AS p__active, p.product_index AS p__product_index, p.created_at AS p__created_at, p.price AS p__price, p.price_promotion AS p__price_promotion, p.price_wholesaler AS p__price_wholesaler, p.price_thresholds AS p__price_thresholds, p.products_manufacturer_idproducts_manufacturer AS p__products_manufacturer_idproducts_manufacturer, p.products_status_idproducts_status AS p__products_status_idproducts_status, p.products_unit_idproducts_unit AS p__products_unit_idproducts_unit, p.products_tax_idproducts_tax AS p__products_tax_idproducts_tax, p.no_premium AS p__no_premium, p.price_min_wholeseller AS p__price_min_wholeseller, p.price_min_regular AS p__price_min_regular, p.price_buy AS p__price_buy, p.catalogue_price AS p__catalogue_price, p.body_weight AS p__body_weight, p.body_size AS p__body_size, p.body_material AS p__body_material, p.body_print_tech AS p__body_print_tech, p.body_print_size AS p__body_print_size, p.body_handling AS p__body_handling, p.ms_products_color_idms_products_color AS p__ms_products_color_idms_products_color, p.name_url AS p__name_url, p.last_update AS p__last_update, p.type AS p__type, p.import_photo AS p__import_photo, p.color_hex AS p__color_hex, p.color_manu AS p__color_manu, p.last_update_prev_price_buy AS p__last_update_prev_price_buy, p.last_update_prev AS p__last_update_prev, p.id_product_manufacturer AS p__id_product_manufacturer, p.model_product_manufacturer AS p__model_product_manufacturer, p.price_brutto AS p__price_brutto, p.meta_link_canonical AS p__meta_link_canonical, p.code_product_manufacturer AS p__code_product_manufacturer, p.tags AS p__tags, p.slug AS p__slug, p.show_on_store AS p__show_on_store, p.ms_product_index AS p__ms_product_index, p.price_range_divisor AS p__price_range_divisor, p.merchant_status AS p__merchant_status, p.idproducts_sync AS p__idproducts_sync, p.disable_price_calculation AS p__disable_price_calculation, p.gratisownia_shop_menu_names AS p__gratisownia_shop_menu_names FROM products p WHERE (p.product_index = ?) - (T9300-005-L) |
| 198 | Doctrine_Connection_Statement | execute : SELECT m.ms_lang_install_signature AS m__ms_lang_install_signature, m.products_shop_idshop AS m__products_shop_idshop, m2.idlang_install AS m2__idlang_install, m2.name AS m2__name, m2.signature AS m2__signature, m2.publication AS m2__publication, m2.lang_icons AS m2__lang_icons FROM ms_lang_install_has_products_shop m INNER JOIN ms_lang_install m2 ON m.ms_lang_install_signature = m2.signature WHERE (m2.publication = ? AND m.products_shop_idshop = ?) - (1, 38) |
| 199 | Doctrine_Connection_Statement | execute : SELECT m.ms_lang_install_signature AS m__ms_lang_install_signature, m.products_shop_idshop AS m__products_shop_idshop, m2.idlang_install AS m2__idlang_install, m2.name AS m2__name, m2.signature AS m2__signature, m2.publication AS m2__publication, m2.lang_icons AS m2__lang_icons FROM ms_lang_install_has_products_shop m INNER JOIN ms_lang_install m2 ON m.ms_lang_install_signature = m2.signature WHERE (m2.publication = ? AND m.products_shop_idshop = ?) - (1, 38) |
| 200 | Doctrine_Connection_Statement | execute : SELECT p.idproducts AS p__idproducts, p2.idproducts_location AS p2__idproducts_location, p2.idms_products_menu AS p2__idms_products_menu FROM products p INNER JOIN products_location p2 ON p.idproducts = p2.products_idproducts AND ((p2.products_shop_idshop = ? AND p2.idms_products_menu > ?)) INNER JOIN ms_products_menu m ON p2.idms_products_menu = m.idms_products_menu AND (m.publication = ?) WHERE (p.product_index = ?) - (38, 1, 1, T9300-005-L) |
| 201 | Doctrine_Connection_Statement | execute : SELECT m.idms_products_menu AS m__idms_products_menu, m.menu_a_name AS m__menu_a_name, m.menu_a_url AS m__menu_a_url, m.menu_a_icon_class AS m__menu_a_icon_class, m.menu_a_icon_path AS m__menu_a_icon_path, m.page_h1 AS m__page_h1, m.page_description AS m__page_description, m.page_description_header AS m__page_description_header, m.page_keywords AS m__page_keywords, m.meta_title AS m__meta_title, m.meta_description AS m__meta_description, m.meta_keywords AS m__meta_keywords, m.products_shop_idshop AS m__products_shop_idshop, m.position_row AS m__position_row, m.parent_idms_products_menu AS m__parent_idms_products_menu, m.publication AS m__publication, m.generate_location_status AS m__generate_location_status FROM ms_products_menu m WHERE (m.idms_products_menu = ?) LIMIT 1 - (1562) |
| 202 | Doctrine_Connection_Statement | execute : SELECT m.idms_products_menu AS m__idms_products_menu, m.menu_a_name AS m__menu_a_name, m.menu_a_url AS m__menu_a_url, m.menu_a_icon_class AS m__menu_a_icon_class, m.menu_a_icon_path AS m__menu_a_icon_path, m.page_h1 AS m__page_h1, m.page_description AS m__page_description, m.page_description_header AS m__page_description_header, m.page_keywords AS m__page_keywords, m.meta_title AS m__meta_title, m.meta_description AS m__meta_description, m.meta_keywords AS m__meta_keywords, m.products_shop_idshop AS m__products_shop_idshop, m.position_row AS m__position_row, m.parent_idms_products_menu AS m__parent_idms_products_menu, m.publication AS m__publication, m.generate_location_status AS m__generate_location_status FROM ms_products_menu m WHERE (m.idms_products_menu = ?) LIMIT 1 - (1555) |
| 203 | sfPartialView | Render "sf_app_dir/modules/products/templates/_location.php" |
| 204 | main | Call "home->executeTechnicalProblems()" |
| 205 | Doctrine_Connection_Statement | execute : SELECT m.ms_lang_install_signature AS m__ms_lang_install_signature, m.products_shop_idshop AS m__products_shop_idshop, m2.idlang_install AS m2__idlang_install, m2.name AS m2__name, m2.signature AS m2__signature, m2.publication AS m2__publication, m2.lang_icons AS m2__lang_icons FROM ms_lang_install_has_products_shop m INNER JOIN ms_lang_install m2 ON m.ms_lang_install_signature = m2.signature WHERE (m2.publication = ? AND m.products_shop_idshop = ?) - (1, 38) |
| 206 | Doctrine_Connection_Statement | execute : SELECT m.idms_popup_information AS m__idms_popup_information, m.system_name AS m__system_name, m.title AS m__title, m.description AS m__description, m.status AS m__status, m.created_at AS m__created_at FROM ms_popup_information m WHERE (m.status = ?) - (1) |
| 207 | sfPartialView | Render "sf_app_dir/modules/home/templates/_technicalProblems.php" |
| 208 | main | Call "products->executeMenu()" |
| 209 | Doctrine_Connection_Statement | execute : SELECT m.idms_products_menu AS m__idms_products_menu, m.menu_a_name AS m__menu_a_name, m.menu_a_url AS m__menu_a_url, m.menu_a_icon_class AS m__menu_a_icon_class, m.menu_a_icon_path AS m__menu_a_icon_path, m.page_h1 AS m__page_h1, m.page_description AS m__page_description, m.page_description_header AS m__page_description_header, m.page_keywords AS m__page_keywords, m.meta_title AS m__meta_title, m.meta_description AS m__meta_description, m.meta_keywords AS m__meta_keywords, m.products_shop_idshop AS m__products_shop_idshop, m.position_row AS m__position_row, m.parent_idms_products_menu AS m__parent_idms_products_menu, m.publication AS m__publication, m.generate_location_status AS m__generate_location_status, m2.idms_products_menu AS m2__idms_products_menu, m2.ms_lang_install_signature AS m2__ms_lang_install_signature, m2.menu_a_name AS m2__menu_a_name, m2.menu_a_url AS m2__menu_a_url, m2.page_h1 AS m2__page_h1, m2.page_description AS m2__page_description, m2.page_description_header AS m2__page_description_header, m2.page_keywords AS m2__page_keywords, m2.meta_title AS m2__meta_title, m2.meta_description AS m2__meta_description, m2.meta_keywords AS m2__meta_keywords FROM ms_products_menu m LEFT JOIN ms_products_menu_lang m2 ON m.idms_products_menu = m2.idms_products_menu AND (m2.ms_lang_install_signature = ?) WHERE (m.products_shop_idshop = ? AND m.publication = ?) ORDER BY m.position_row ASC - (de, 38, 1) |
| 210 | Doctrine_Connection_Mysql | query : SELECT m.idms_products_menu_rules AS m__idms_products_menu_rules, m.structure AS m__structure, m.idms_products_menu AS m__idms_products_menu FROM ms_products_menu_rules m - () |
| 211 | Doctrine_Connection_Statement | execute : SELECT m.idms_products_menu AS m__idms_products_menu, m.menu_a_name AS m__menu_a_name, m.menu_a_url AS m__menu_a_url, m.menu_a_icon_class AS m__menu_a_icon_class, m.menu_a_icon_path AS m__menu_a_icon_path, m.page_h1 AS m__page_h1, m.page_description AS m__page_description, m.page_description_header AS m__page_description_header, m.page_keywords AS m__page_keywords, m.meta_title AS m__meta_title, m.meta_description AS m__meta_description, m.meta_keywords AS m__meta_keywords, m.products_shop_idshop AS m__products_shop_idshop, m.position_row AS m__position_row, m.parent_idms_products_menu AS m__parent_idms_products_menu, m.publication AS m__publication, m.generate_location_status AS m__generate_location_status, m2.idms_products_menu AS m2__idms_products_menu, m2.ms_lang_install_signature AS m2__ms_lang_install_signature, m2.menu_a_name AS m2__menu_a_name, m2.menu_a_url AS m2__menu_a_url, m2.page_h1 AS m2__page_h1, m2.page_description AS m2__page_description, m2.page_description_header AS m2__page_description_header, m2.page_keywords AS m2__page_keywords, m2.meta_title AS m2__meta_title, m2.meta_description AS m2__meta_description, m2.meta_keywords AS m2__meta_keywords FROM ms_products_menu m LEFT JOIN ms_products_menu_lang m2 ON m.idms_products_menu = m2.idms_products_menu AND (m2.ms_lang_install_signature = ?) WHERE (m.products_shop_idshop = ? AND m.publication = ?) ORDER BY m.position_row ASC - (de, 38, 1) |
| 212 | sfPartialView | Render "sf_app_dir/modules/products/templates/_menu.php" |
| 213 | main | Call "home->executeOffercreatorinfobox()" |
| 214 | sfPartialView | Render "sf_app_dir/modules/home/templates/_offercreatorinfobox.php" |
| 215 | sfWebResponse | Send status "HTTP/1.0 200 OK" |
| 216 | sfWebResponse | Send header "Content-Type: text/html; charset=utf-8" |
| 217 | sfWebResponse | Send cookie "ms_referer_page_url": "https%3A%2F%2Fgifterso.de%2Fde%2F38%2FT9300-005-L%2Fbluza-z-bawelny-z-recyklingu-iqoniq-zion-155264.html" |
config
view
logs
12288.0 KB
967 ms
186
