| # |
type |
message |
| 1 |  myPatternRouting | Match route "category" (/category) for /category with parameters array ( 'module' => 'product', 'action' => 'all',) |
| 2 | sfFilterChain | Executing filter "sfRenderingFilter" |
| 3 | sfFilterChain | Executing filter "sslFilter" |
| 4 | sfFilterChain | Executing filter "domainCultureFilter" |
| 5 | sfFilterChain | Executing filter "checkMobileFilter" |
| 6 | sfFilterChain | Executing filter "sfExecutionFilter" |
| 7 | productActions | Call "productActions->executeAll()" |
| 8 | Doctrine_Connection_Mysql | exec : SET NAMES 'UTF8' - () |
| 9 | Doctrine_Connection_Statement | execute : SELECT COUNT(*) AS num_results FROM (SELECT p.id FROM product p LEFT JOIN product_translation p2 ON p.id = p2.id AND (p2.lang = ?) LEFT JOIN category c ON p.category_id = c.id LEFT JOIN category_translation c2 ON c.id = c2.id AND (c2.lang = ?) LEFT JOIN product_type p3 ON p.product_type_id = p3.id LEFT JOIN product_type_translation p4 ON p3.id = p4.id AND (p4.lang = ?) INNER JOIN sale s ON p.sale_id = s.id LEFT JOIN bid b ON p.id = b.product_id WHERE p.sale_id = ? AND p.enabled = 1 AND p.htva_price > 0 AND p.end_at > NOW() AND s.enabled = 1 AND s.end_at > NOW() AND ((p.isinstantsell = 1 AND p.stock_quantity_initial > p.stock_quantity_sold) OR (p.isinstantsell = 0 OR p.isinstantsell IS NULL)) GROUP BY p.id) dctrn_count_query - (fr, fr, fr, 10574) |
| 10 | Doctrine_Connection_Statement | execute : SELECT s.id AS s__id, s.ref AS s__ref, s.sale_mother_id AS s__sale_mother_id, s.image AS s__image, s.banner AS s__banner, s.banner_new AS s__banner_new, s.judge_id AS s__judge_id, s.curator_id AS s__curator_id, s.associate_member_id AS s__associate_member_id, s.sale_type_id AS s__sale_type_id, s.last_invoice_id AS s__last_invoice_id, s.commercial_court AS s__commercial_court, s.begin_at AS s__begin_at, s.first_end_at AS s__first_end_at, s.end_at AS s__end_at, s.company_name AS s__company_name, s.address1 AS s__address1, s.address2 AS s__address2, s.post_code AS s__post_code, s.city AS s__city, s.social_reason AS s__social_reason, s.company_social_reason_id AS s__company_social_reason_id, s.matricule AS s__matricule, s.vat_number AS s__vat_number, s.country_id AS s__country_id, s.owner_description AS s__owner_description, s.activity_domain AS s__activity_domain, s.mission_description AS s__mission_description, s.enabled AS s__enabled, s.category_id AS s__category_id, s.mission_end AS s__mission_end, s.inventory_at AS s__inventory_at, s.validated_contract_at AS s__validated_contract_at, s.implementated_at AS s__implementated_at, s.sfguarduser_id AS s__sfguarduser_id, s.stock_id AS s__stock_id, s.tva AS s__tva, s.vat_rate_id AS s__vat_rate_id, s.commission AS s__commission, s.tva_commission AS s__tva_commission, s.vat_rate_commission_id AS s__vat_rate_commission_id, s.vendor_commission AS s__vendor_commission, s.account_to_receive AS s__account_to_receive, s.account_received AS s__account_received, s.vat_only AS s__vat_only, s.visit_pad AS s__visit_pad, s.visited_at AS s__visited_at, s.visit_closed AS s__visit_closed, s.visited_at_day AS s__visited_at_day, s.delivery_at AS s__delivery_at, s.delivery_at_day AS s__delivery_at_day, s.delivery_planned AS s__delivery_planned, s.delivery_temporary_planification AS s__delivery_temporary_planification, s.external_invoice AS s__external_invoice, s.type_external_invoice AS s__type_external_invoice, s.type_commission AS s__type_commission, s.sell_mode AS s__sell_mode, s.last_invoice_number AS s__last_invoice_number, s.invoice_prefix AS s__invoice_prefix, s.last_credit_note AS s__last_credit_note, s.last_proforma AS s__last_proforma, s.bank_nummer AS s__bank_nummer, s.bic_number AS s__bic_number, s.account AS s__account, s.bank_nummer2 AS s__bank_nummer2, s.bic_number2 AS s__bic_number2, s.account2 AS s__account2, s.bank_nummer3 AS s__bank_nummer3, s.bic_number3 AS s__bic_number3, s.account3 AS s__account3, s.ogone_enabled AS s__ogone_enabled, s.choice_stock AS s__choice_stock, s.view_counter AS s__view_counter, s.cpt AS s__cpt, s.cpt_nc AS s__cpt_nc, s.cpt_pf AS s__cpt_pf, s.info_additional_invoice AS s__info_additional_invoice, s.fund_to_be_transferred AS s__fund_to_be_transferred, s.fund_to_be_transferred_bank AS s__fund_to_be_transferred_bank, s.fund_transferred AS s__fund_transferred, s.is_stock_in_trade AS s__is_stock_in_trade, s.is_stock_in_trade_url AS s__is_stock_in_trade_url, s.sale_status_id AS s__sale_status_id, s.position AS s__position, s.limit_at AS s__limit_at, s.locked_by AS s__locked_by, s.locked_until AS s__locked_until, s.global AS s__global, s.global_only AS s__global_only, s.manager_id AS s__manager_id, s.leader_id AS s__leader_id, s.could_be_closed AS s__could_be_closed, s.soon_available AS s__soon_available, s.report_before_start AS s__report_before_start, s.key_status_id AS s__key_status_id, s.key_position AS s__key_position, s.sepa_communication_type AS s__sepa_communication_type, s.created_at AS s__created_at, s.updated_at AS s__updated_at FROM sale s WHERE (s.id = ?) LIMIT 1 - (10574) |
| 11 | Doctrine_Connection_Statement | execute : SELECT s.id AS s__id, s.public_title AS s__public_title, s.public_subtitle AS s__public_subtitle, s.public_description AS s__public_description, s.description_for_product AS s__description_for_product, s.specific_condition_pdf AS s__specific_condition_pdf, s.lang AS s__lang FROM sale_translation s WHERE (s.id IN (?)) - (10574) |
| 12 | sfPHPView | Render "sf_app_dir/modules/product/templates/allSuccess.php" |
| 13 | main | Call "default->executeWidget_category()" |
| 14 | sfPartialView | Render "sf_app_dir/modules/default/templates/_widget_category.php" |
| 15 | Doctrine_Connection_Statement | execute : SELECT p.id AS p__id, p.template_id AS p__template_id, p.code AS p__code, p.position AS p__position, p.in_sitemap AS p__in_sitemap, p.enabled AS p__enabled, p.created_at AS p__created_at, p.updated_at AS p__updated_at, p2.id AS p2__id, p2.meta_title AS p2__meta_title, p2.meta_keyword AS p2__meta_keyword, p2.meta_description AS p2__meta_description, p2.lang AS p2__lang, p2.slug AS p2__slug FROM page p LEFT JOIN page_translation p2 ON p.id = p2.id WHERE (p.code = ?) - (TELEVIE) |
| 16 | main | Call "sale->executeHeader()" |
| 17 | Doctrine_Connection_Statement | execute : SELECT s.id AS s__id, s.ref AS s__ref, s.sale_mother_id AS s__sale_mother_id, s.image AS s__image, s.banner AS s__banner, s.banner_new AS s__banner_new, s.judge_id AS s__judge_id, s.curator_id AS s__curator_id, s.associate_member_id AS s__associate_member_id, s.sale_type_id AS s__sale_type_id, s.last_invoice_id AS s__last_invoice_id, s.commercial_court AS s__commercial_court, s.begin_at AS s__begin_at, s.first_end_at AS s__first_end_at, s.end_at AS s__end_at, s.company_name AS s__company_name, s.address1 AS s__address1, s.address2 AS s__address2, s.post_code AS s__post_code, s.city AS s__city, s.social_reason AS s__social_reason, s.company_social_reason_id AS s__company_social_reason_id, s.matricule AS s__matricule, s.vat_number AS s__vat_number, s.country_id AS s__country_id, s.owner_description AS s__owner_description, s.activity_domain AS s__activity_domain, s.mission_description AS s__mission_description, s.enabled AS s__enabled, s.category_id AS s__category_id, s.mission_end AS s__mission_end, s.inventory_at AS s__inventory_at, s.validated_contract_at AS s__validated_contract_at, s.implementated_at AS s__implementated_at, s.sfguarduser_id AS s__sfguarduser_id, s.stock_id AS s__stock_id, s.tva AS s__tva, s.vat_rate_id AS s__vat_rate_id, s.commission AS s__commission, s.tva_commission AS s__tva_commission, s.vat_rate_commission_id AS s__vat_rate_commission_id, s.vendor_commission AS s__vendor_commission, s.account_to_receive AS s__account_to_receive, s.account_received AS s__account_received, s.vat_only AS s__vat_only, s.visit_pad AS s__visit_pad, s.visited_at AS s__visited_at, s.visit_closed AS s__visit_closed, s.visited_at_day AS s__visited_at_day, s.delivery_at AS s__delivery_at, s.delivery_at_day AS s__delivery_at_day, s.delivery_planned AS s__delivery_planned, s.delivery_temporary_planification AS s__delivery_temporary_planification, s.external_invoice AS s__external_invoice, s.type_external_invoice AS s__type_external_invoice, s.type_commission AS s__type_commission, s.sell_mode AS s__sell_mode, s.last_invoice_number AS s__last_invoice_number, s.invoice_prefix AS s__invoice_prefix, s.last_credit_note AS s__last_credit_note, s.last_proforma AS s__last_proforma, s.bank_nummer AS s__bank_nummer, s.bic_number AS s__bic_number, s.account AS s__account, s.bank_nummer2 AS s__bank_nummer2, s.bic_number2 AS s__bic_number2, s.account2 AS s__account2, s.bank_nummer3 AS s__bank_nummer3, s.bic_number3 AS s__bic_number3, s.account3 AS s__account3, s.ogone_enabled AS s__ogone_enabled, s.choice_stock AS s__choice_stock, s.view_counter AS s__view_counter, s.cpt AS s__cpt, s.cpt_nc AS s__cpt_nc, s.cpt_pf AS s__cpt_pf, s.info_additional_invoice AS s__info_additional_invoice, s.fund_to_be_transferred AS s__fund_to_be_transferred, s.fund_to_be_transferred_bank AS s__fund_to_be_transferred_bank, s.fund_transferred AS s__fund_transferred, s.is_stock_in_trade AS s__is_stock_in_trade, s.is_stock_in_trade_url AS s__is_stock_in_trade_url, s.sale_status_id AS s__sale_status_id, s.position AS s__position, s.limit_at AS s__limit_at, s.locked_by AS s__locked_by, s.locked_until AS s__locked_until, s.global AS s__global, s.global_only AS s__global_only, s.manager_id AS s__manager_id, s.leader_id AS s__leader_id, s.could_be_closed AS s__could_be_closed, s.soon_available AS s__soon_available, s.report_before_start AS s__report_before_start, s.key_status_id AS s__key_status_id, s.key_position AS s__key_position, s.sepa_communication_type AS s__sepa_communication_type, s.created_at AS s__created_at, s.updated_at AS s__updated_at FROM sale s WHERE (s.id = ? AND s.enabled = 1 AND s.end_at >= NOW()) - (10574) |
| 18 | Doctrine_Connection_Statement | execute : SELECT SUM(p.counter_view) AS p__0 FROM product p WHERE (p.enabled = 1 AND p.sale_id = ?) - (10574) |
| 19 | Doctrine_Connection_Statement | execute : SELECT COUNT(b.id) AS b__0 FROM bid b INNER JOIN product p ON b.product_id = p.id WHERE (p.enabled = 1 AND p.sale_id = ?) - (10574) |
| 20 | sfPartialView | Render "sf_app_dir/modules/sale/templates/_header.php" |
| 21 | sfPartialView | Render "sf_app_dir/modules/sale/templates/_flag.php" |
| 22 | Doctrine_Connection_Statement | execute : SELECT s.id AS s__id, s.code AS s__code, s.mandat_judiciaire AS s__mandat_judiciaire, s.create_associate_member AS s__create_associate_member, s.position AS s__position, s.enabled AS s__enabled, s.created_at AS s__created_at, s.updated_at AS s__updated_at FROM sale_type s WHERE (s.id = ?) - (5) |
| 23 | Doctrine_Connection_Statement | execute : SELECT s.id AS s__id, s.title AS s__title, s.description AS s__description, s.public_header AS s__public_header, s.lang AS s__lang, s.slug AS s__slug FROM sale_type_translation s WHERE (s.id IN (?)) - (5) |
| 24 | Doctrine_Connection_Statement | execute : SELECT m.id AS m__id, m.facebook_id AS m__facebook_id, m.company_social_reason_id AS m__company_social_reason_id, m.ref AS m__ref, m.civility AS m__civility, m.last_name AS m__last_name, m.first_name AS m__first_name, m.birthdate AS m__birthdate, m.address1 AS m__address1, m.address2 AS m__address2, m.post_code AS m__post_code, m.post_box AS m__post_box, m.city AS m__city, m.country_id AS m__country_id, m.phone_number AS m__phone_number, m.gsm_number AS m__gsm_number, m.sms_code AS m__sms_code, m.verified_mobile AS m__verified_mobile, m.mail AS m__mail, m.mail_alternate AS m__mail_alternate, m.vacancy_mail AS m__vacancy_mail, m.password AS m__password, m.new_password AS m__new_password, m.token AS m__token, m.remember_key AS m__remember_key, m.identity_number AS m__identity_number, m.national_register AS m__national_register, m.company_name AS m__company_name, m.matricule AS m__matricule, m.vat_number AS m__vat_number, m.dft_culture AS m__dft_culture, m.dft_site AS m__dft_site, m.member_type_id AS m__member_type_id, m.last_connection_at AS m__last_connection_at, m.accept_cgv_at AS m__accept_cgv_at, m.is_newsletter AS m__is_newsletter, m.enabled AS m__enabled, m.bank_nummer AS m__bank_nummer, m.bic_number AS m__bic_number, m.can_create_file AS m__can_create_file, m.account AS m__account, m.bank_nummer2 AS m__bank_nummer2, m.account2 AS m__account2, m.bank_report AS m__bank_report, m.exact_hash AS m__exact_hash, m.exact_clictelia_hash AS m__exact_clictelia_hash, m.vies_checked_at AS m__vies_checked_at, m.created_at AS m__created_at, m.updated_at AS m__updated_at FROM member m WHERE (m.id = ?) - (112475) |
| 25 | sfPartialView | Render "sf_app_dir/modules/sale/templates/_timer_js.php" |
| 26 | Doctrine_Connection_Mysql | query : SELECT COUNT(*) AS num_results FROM sale_visit s WHERE s.sale_id = 10574 - () |
| 27 | Doctrine_Connection_Statement | execute : SELECT c.id AS c__id, c.number AS c__number, c.alpha3 AS c__alpha3, c.alpha2 AS c__alpha2, c.vat_mask AS c__vat_mask, c.enabled AS c__enabled, c.position AS c__position, c.created_at AS c__created_at, c.updated_at AS c__updated_at FROM country c WHERE (c.id = ?) - (20) |
| 28 | Doctrine_Connection_Statement | execute : SELECT c.id AS c__id, c.name AS c__name, c.lang AS c__lang FROM country_translation c WHERE (c.id IN (?)) - (20) |
| 29 | sfPartialView | Render "sf_app_dir/modules/sale/templates/_map.php" |
| 30 | Doctrine_Connection_Statement | execute : SELECT s.id AS s__id, s.ref AS s__ref, s.sale_mother_id AS s__sale_mother_id, s.image AS s__image, s.banner AS s__banner, s.banner_new AS s__banner_new, s.judge_id AS s__judge_id, s.curator_id AS s__curator_id, s.associate_member_id AS s__associate_member_id, s.sale_type_id AS s__sale_type_id, s.last_invoice_id AS s__last_invoice_id, s.commercial_court AS s__commercial_court, s.begin_at AS s__begin_at, s.first_end_at AS s__first_end_at, s.end_at AS s__end_at, s.company_name AS s__company_name, s.address1 AS s__address1, s.address2 AS s__address2, s.post_code AS s__post_code, s.city AS s__city, s.social_reason AS s__social_reason, s.company_social_reason_id AS s__company_social_reason_id, s.matricule AS s__matricule, s.vat_number AS s__vat_number, s.country_id AS s__country_id, s.owner_description AS s__owner_description, s.activity_domain AS s__activity_domain, s.mission_description AS s__mission_description, s.enabled AS s__enabled, s.category_id AS s__category_id, s.mission_end AS s__mission_end, s.inventory_at AS s__inventory_at, s.validated_contract_at AS s__validated_contract_at, s.implementated_at AS s__implementated_at, s.sfguarduser_id AS s__sfguarduser_id, s.stock_id AS s__stock_id, s.tva AS s__tva, s.vat_rate_id AS s__vat_rate_id, s.commission AS s__commission, s.tva_commission AS s__tva_commission, s.vat_rate_commission_id AS s__vat_rate_commission_id, s.vendor_commission AS s__vendor_commission, s.account_to_receive AS s__account_to_receive, s.account_received AS s__account_received, s.vat_only AS s__vat_only, s.visit_pad AS s__visit_pad, s.visited_at AS s__visited_at, s.visit_closed AS s__visit_closed, s.visited_at_day AS s__visited_at_day, s.delivery_at AS s__delivery_at, s.delivery_at_day AS s__delivery_at_day, s.delivery_planned AS s__delivery_planned, s.delivery_temporary_planification AS s__delivery_temporary_planification, s.external_invoice AS s__external_invoice, s.type_external_invoice AS s__type_external_invoice, s.type_commission AS s__type_commission, s.sell_mode AS s__sell_mode, s.last_invoice_number AS s__last_invoice_number, s.invoice_prefix AS s__invoice_prefix, s.last_credit_note AS s__last_credit_note, s.last_proforma AS s__last_proforma, s.bank_nummer AS s__bank_nummer, s.bic_number AS s__bic_number, s.account AS s__account, s.bank_nummer2 AS s__bank_nummer2, s.bic_number2 AS s__bic_number2, s.account2 AS s__account2, s.bank_nummer3 AS s__bank_nummer3, s.bic_number3 AS s__bic_number3, s.account3 AS s__account3, s.ogone_enabled AS s__ogone_enabled, s.choice_stock AS s__choice_stock, s.view_counter AS s__view_counter, s.cpt AS s__cpt, s.cpt_nc AS s__cpt_nc, s.cpt_pf AS s__cpt_pf, s.info_additional_invoice AS s__info_additional_invoice, s.fund_to_be_transferred AS s__fund_to_be_transferred, s.fund_to_be_transferred_bank AS s__fund_to_be_transferred_bank, s.fund_transferred AS s__fund_transferred, s.is_stock_in_trade AS s__is_stock_in_trade, s.is_stock_in_trade_url AS s__is_stock_in_trade_url, s.sale_status_id AS s__sale_status_id, s.position AS s__position, s.limit_at AS s__limit_at, s.locked_by AS s__locked_by, s.locked_until AS s__locked_until, s.global AS s__global, s.global_only AS s__global_only, s.manager_id AS s__manager_id, s.leader_id AS s__leader_id, s.could_be_closed AS s__could_be_closed, s.soon_available AS s__soon_available, s.report_before_start AS s__report_before_start, s.key_status_id AS s__key_status_id, s.key_position AS s__key_position, s.sepa_communication_type AS s__sepa_communication_type, s.created_at AS s__created_at, s.updated_at AS s__updated_at FROM sale s WHERE (s.id = ?) LIMIT 1 - (10305) |
| 31 | sfPartialView | Render "sf_app_dir/modules/product/templates/_sort.php" |
| 32 | sfPartialView | Render "sf_app_dir/modules/product/templates/_sort.php" |
| 33 | sfPartialView | Render "sf_app_dir/modules/product/templates/_sort.php" |
| 34 | sfPartialView | Render "sf_app_dir/modules/product/templates/_sort.php" |
| 35 | sfPartialView | Render "sf_app_dir/modules/product/templates/_pager.php" |
| 36 | Doctrine_Connection_Statement | execute : SELECT DISTINCT p5.id, if(p5.isinstantsell, -1, COUNT(b2.product_id)) AS p5__8 FROM product p5 LEFT JOIN product_translation p6 ON p5.id = p6.id AND (p6.lang = ?) LEFT JOIN category c3 ON p5.category_id = c3.id LEFT JOIN category_translation c4 ON c3.id = c4.id AND (c4.lang = ?) LEFT JOIN product_type p7 ON p5.product_type_id = p7.id LEFT JOIN product_type_translation p8 ON p7.id = p8.id AND (p8.lang = ?) INNER JOIN sale s2 ON p5.sale_id = s2.id LEFT JOIN bid b2 ON p5.id = b2.product_id WHERE p5.sale_id = ? AND p5.enabled = 1 AND p5.htva_price > 0 AND p5.end_at > NOW() AND s2.enabled = 1 AND s2.end_at > NOW() AND ((p5.isinstantsell = 1 AND p5.stock_quantity_initial > p5.stock_quantity_sold) OR (p5.isinstantsell = 0 OR p5.isinstantsell IS NULL)) GROUP BY p5.id ORDER BY p5__8 DESC, p5.position ASC, GREATEST(p5.end_at, s2.end_at) ASC, p5.created_at ASC, p5.id ASC LIMIT 50 - (fr, fr, fr, 10574) |
| 37 | Doctrine_Connection_Statement | execute : SELECT p.id AS p__id, p.position AS p__position, p.parent_id AS p__parent_id, p.ref AS p__ref, p.reception_title AS p__reception_title, p.reception_model AS p__reception_model, p.reception_description AS p__reception_description, p.bids_count AS p__bids_count, p.actual_bid AS p__actual_bid, p.product_state_id AS p__product_state_id, p.begin_at AS p__begin_at, p.end_at AS p__end_at, p.adjudicated_at AS p__adjudicated_at, p.product_type_id AS p__product_type_id, p.weight AS p__weight, p.dimension AS p__dimension, p.ean_code AS p__ean_code, p.sell_type AS p__sell_type, p.htva_estimated_price AS p__htva_estimated_price, p.htva_price AS p__htva_price, p.htva_reserved_price AS p__htva_reserved_price, p.tva AS p__tva, p.vat_only AS p__vat_only, p.vat_rate_id AS p__vat_rate_id, p.vat_rate_commission_id AS p__vat_rate_commission_id, p.isinstantsell AS p__isinstantsell, p.instantprice AS p__instantprice, p.instant_serial AS p__instant_serial, p.instant_serial_mask AS p__instant_serial_mask, p.stock_quantity_initial AS p__stock_quantity_initial, p.stock_quantity_sold AS p__stock_quantity_sold, p.reduction AS p__reduction, p.type_commission AS p__type_commission, p.sell_mode AS p__sell_mode, p.type_ovc AS p__type_ovc, p.commission AS p__commission, p.tva_commission AS p__tva_commission, p.shipping AS p__shipping, p.estimated_delivery_at AS p__estimated_delivery_at, p.planned_delivery_at AS p__planned_delivery_at, p.enabled AS p__enabled, p.need_immatriculation_mandat AS p__need_immatriculation_mandat, p.hidden AS p__hidden, p.homepage AS p__homepage, p.brand_id AS p__brand_id, p.sale_id AS p__sale_id, p.category_id AS p__category_id, p.product_status_id AS p__product_status_id, p.stock_id AS p__stock_id, p.visited_at AS p__visited_at, p.delivery_at AS p__delivery_at, p.is_new AS p__is_new, p.date_end_new AS p__date_end_new, p.in_inventory AS p__in_inventory, p.is_stock_in_trade AS p__is_stock_in_trade, p.counter_consult AS p__counter_consult, p.counter_view AS p__counter_view, p.validated_at AS p__validated_at, p.created_at AS p__created_at, p.updated_at AS p__updated_at, p2.id AS p2__id, p2.lang AS p2__lang, p2.title AS p2__0, p2.slug AS p2__1, p2.description AS p2__2, p2.short_description AS p2__4, c.id AS c__id, c.banner AS c__banner, c.position AS c__position, c.enabled AS c__enabled, c.parent_category_id AS c__parent_category_id, c.icon AS c__icon, c.created_at AS c__created_at, c.updated_at AS c__updated_at, c2.id AS c2__id, c2.lang AS c2__lang, c2.slug AS c2__3, c2.title AS c2__5, p3.id AS p3__id, p3.banner AS p3__banner, p3.position AS p3__position, p3.enabled AS p3__enabled, p3.created_at AS p3__created_at, p3.updated_at AS p3__updated_at, p4.id AS p4__id, p4.lang AS p4__lang, p4.title AS p4__6, p2.title AS p2__0, p2.slug AS p2__1, p2.description AS p2__2, c2.slug AS c2__3, p2.short_description AS p2__4, c2.title AS c2__5, p4.title AS p4__6, (SELECT COUNT(b2.id) AS b2__0 FROM bid b2 WHERE (b2.product_id = p.id)) AS p__7, if(p.isinstantsell, -1, COUNT(b.product_id)) AS p__8 FROM product p LEFT JOIN product_translation p2 ON p.id = p2.id AND (p2.lang = ?) LEFT JOIN category c ON p.category_id = c.id LEFT JOIN category_translation c2 ON c.id = c2.id AND (c2.lang = ?) LEFT JOIN product_type p3 ON p.product_type_id = p3.id LEFT JOIN product_type_translation p4 ON p3.id = p4.id AND (p4.lang = ?) INNER JOIN sale s ON p.sale_id = s.id LEFT JOIN bid b ON p.id = b.product_id WHERE p.id IN ('201296') AND (p.sale_id = ? AND p.enabled = 1 AND p.htva_price > 0 AND p.end_at > NOW() AND s.enabled = 1 AND s.end_at > NOW() AND ((p.isinstantsell = 1 AND p.stock_quantity_initial > p.stock_quantity_sold) OR (p.isinstantsell = 0 OR p.isinstantsell IS NULL))) GROUP BY p.id ORDER BY p__8 DESC, p.position ASC, GREATEST(p.end_at, s.end_at) ASC, p.created_at ASC, p.id ASC - (fr, fr, fr, 10574) |
| 38 | sfPartialView | Render "sf_app_dir/modules/default/templates/_product_row.php" |
| 39 | Doctrine_Connection_Statement | execute : SELECT b.id AS b__id, b.price AS b__price, b.max_price AS b__max_price, b.member_id AS b__member_id, b.product_id AS b__product_id, b.adjudicated_at AS b__adjudicated_at, b.created_at AS b__created_at, b.updated_at AS b__updated_at FROM bid b WHERE (b.product_id = ?) ORDER BY b.created_at DESC, b.id DESC - (201296) |
| 40 | Doctrine_Connection_Statement | execute : SELECT i.id AS i__id, IF(i.new_position IS NULL, position, i.new_position) AS i__0 FROM image_product i WHERE (i.enabled = 1 AND i.product_id = ?) ORDER BY i__0 ASC - (201296) |
| 41 | Doctrine_Connection_Statement | execute : SELECT s.id AS s__id, s.ref AS s__ref, s.sale_mother_id AS s__sale_mother_id, s.image AS s__image, s.banner AS s__banner, s.banner_new AS s__banner_new, s.judge_id AS s__judge_id, s.curator_id AS s__curator_id, s.associate_member_id AS s__associate_member_id, s.sale_type_id AS s__sale_type_id, s.last_invoice_id AS s__last_invoice_id, s.commercial_court AS s__commercial_court, s.begin_at AS s__begin_at, s.first_end_at AS s__first_end_at, s.end_at AS s__end_at, s.company_name AS s__company_name, s.address1 AS s__address1, s.address2 AS s__address2, s.post_code AS s__post_code, s.city AS s__city, s.social_reason AS s__social_reason, s.company_social_reason_id AS s__company_social_reason_id, s.matricule AS s__matricule, s.vat_number AS s__vat_number, s.country_id AS s__country_id, s.owner_description AS s__owner_description, s.activity_domain AS s__activity_domain, s.mission_description AS s__mission_description, s.enabled AS s__enabled, s.category_id AS s__category_id, s.mission_end AS s__mission_end, s.inventory_at AS s__inventory_at, s.validated_contract_at AS s__validated_contract_at, s.implementated_at AS s__implementated_at, s.sfguarduser_id AS s__sfguarduser_id, s.stock_id AS s__stock_id, s.tva AS s__tva, s.vat_rate_id AS s__vat_rate_id, s.commission AS s__commission, s.tva_commission AS s__tva_commission, s.vat_rate_commission_id AS s__vat_rate_commission_id, s.vendor_commission AS s__vendor_commission, s.account_to_receive AS s__account_to_receive, s.account_received AS s__account_received, s.vat_only AS s__vat_only, s.visit_pad AS s__visit_pad, s.visited_at AS s__visited_at, s.visit_closed AS s__visit_closed, s.visited_at_day AS s__visited_at_day, s.delivery_at AS s__delivery_at, s.delivery_at_day AS s__delivery_at_day, s.delivery_planned AS s__delivery_planned, s.delivery_temporary_planification AS s__delivery_temporary_planification, s.external_invoice AS s__external_invoice, s.type_external_invoice AS s__type_external_invoice, s.type_commission AS s__type_commission, s.sell_mode AS s__sell_mode, s.last_invoice_number AS s__last_invoice_number, s.invoice_prefix AS s__invoice_prefix, s.last_credit_note AS s__last_credit_note, s.last_proforma AS s__last_proforma, s.bank_nummer AS s__bank_nummer, s.bic_number AS s__bic_number, s.account AS s__account, s.bank_nummer2 AS s__bank_nummer2, s.bic_number2 AS s__bic_number2, s.account2 AS s__account2, s.bank_nummer3 AS s__bank_nummer3, s.bic_number3 AS s__bic_number3, s.account3 AS s__account3, s.ogone_enabled AS s__ogone_enabled, s.choice_stock AS s__choice_stock, s.view_counter AS s__view_counter, s.cpt AS s__cpt, s.cpt_nc AS s__cpt_nc, s.cpt_pf AS s__cpt_pf, s.info_additional_invoice AS s__info_additional_invoice, s.fund_to_be_transferred AS s__fund_to_be_transferred, s.fund_to_be_transferred_bank AS s__fund_to_be_transferred_bank, s.fund_transferred AS s__fund_transferred, s.is_stock_in_trade AS s__is_stock_in_trade, s.is_stock_in_trade_url AS s__is_stock_in_trade_url, s.sale_status_id AS s__sale_status_id, s.position AS s__position, s.limit_at AS s__limit_at, s.locked_by AS s__locked_by, s.locked_until AS s__locked_until, s.global AS s__global, s.global_only AS s__global_only, s.manager_id AS s__manager_id, s.leader_id AS s__leader_id, s.could_be_closed AS s__could_be_closed, s.soon_available AS s__soon_available, s.report_before_start AS s__report_before_start, s.key_status_id AS s__key_status_id, s.key_position AS s__key_position, s.sepa_communication_type AS s__sepa_communication_type, s.created_at AS s__created_at, s.updated_at AS s__updated_at FROM sale s WHERE (s.id = ?) - (10574) |
| 42 | sfPartialView | Render "sf_app_dir/modules/product/templates/_counter.php" |
| 43 | Doctrine_Connection_Statement | execute : SELECT v.id AS v__id, v.country_id AS v__country_id, v.vat_rate AS v__vat_rate, v.enabled AS v__enabled FROM vat_rate v WHERE (v.id = ?) LIMIT 1 - (4) |
| 44 | sfPartialView | Render "sf_app_dir/modules/product/templates/_message_bid.php" |
| 45 | main | Set slot "isNotBestBidder" |
| 46 | sfPartialView | Render "sf_app_dir/modules/default/templates/_script-js-follow.js.php" |
| 47 | sfPHPView | Decorate content with "sf_app_dir/templates/layout.php" |
| 48 | sfPHPView | Render "sf_app_dir/templates/layout.php" |
| 49 | sfPartialView | Render "sf_app_dir/modules/default/templates/_analytics.php" |
| 50 | sfPartialView | Render "sf_app_dir/modules/default/templates/_header.php" |
| 51 | Doctrine_Connection_Statement | execute : SELECT d.id AS d__id, d.code AS d__code, d.value AS d__value, d.created_at AS d__created_at, d.updated_at AS d__updated_at FROM data d WHERE (d.code = ?) LIMIT 1 - (HOME_TEXT_FR) |
| 52 | sfPartialView | Render "sf_app_dir/modules/default/templates/_navigation.php" |
| 53 | main | Call "default->executeSearch()" |
| 54 | sfPartialView | Render "sf_app_dir/modules/default/templates/_search.php" |
| 55 | sfPartialView | Render "sf_app_dir/modules/default/templates/_member_menu.php" |
| 56 | sfPartialView | Render "sf_app_dir/modules/default/templates/_sub_footer.php" |
| 57 | main | Call "default->executeWidget_newsletter()" |
| 58 | sfPartialView | Render "sf_app_dir/modules/default/templates/_widget_newsletter.php" |
| 59 | sfPartialView | Render "sf_app_dir/modules/default/templates/_widget_beginnow.php" |
| 60 | main | Call "default->executeWidget_selection()" |
| 61 | Doctrine_Connection_Statement | execute : SELECT DISTINCT p3.id FROM product p3 LEFT JOIN product_translation p4 ON p3.id = p4.id AND (p4.lang = ?) LEFT JOIN image_product i2 ON p3.id = i2.product_id INNER JOIN sale s2 ON p3.sale_id = s2.id WHERE i2.enabled = ? AND p3.homepage = ? AND p3.enabled = 1 AND p3.htva_price > 0 AND p3.end_at > NOW() AND s2.enabled = 1 AND s2.end_at > NOW() ORDER BY i2.position LIMIT 4 - (fr, 1, 1) |
| 62 | Doctrine_Connection_Statement | execute : SELECT p.id AS p__id, p.position AS p__position, p.parent_id AS p__parent_id, p.ref AS p__ref, p.reception_title AS p__reception_title, p.reception_model AS p__reception_model, p.reception_description AS p__reception_description, p.bids_count AS p__bids_count, p.actual_bid AS p__actual_bid, p.product_state_id AS p__product_state_id, p.begin_at AS p__begin_at, p.end_at AS p__end_at, p.adjudicated_at AS p__adjudicated_at, p.product_type_id AS p__product_type_id, p.weight AS p__weight, p.dimension AS p__dimension, p.ean_code AS p__ean_code, p.sell_type AS p__sell_type, p.htva_estimated_price AS p__htva_estimated_price, p.htva_price AS p__htva_price, p.htva_reserved_price AS p__htva_reserved_price, p.tva AS p__tva, p.vat_only AS p__vat_only, p.vat_rate_id AS p__vat_rate_id, p.vat_rate_commission_id AS p__vat_rate_commission_id, p.isinstantsell AS p__isinstantsell, p.instantprice AS p__instantprice, p.instant_serial AS p__instant_serial, p.instant_serial_mask AS p__instant_serial_mask, p.stock_quantity_initial AS p__stock_quantity_initial, p.stock_quantity_sold AS p__stock_quantity_sold, p.reduction AS p__reduction, p.type_commission AS p__type_commission, p.sell_mode AS p__sell_mode, p.type_ovc AS p__type_ovc, p.commission AS p__commission, p.tva_commission AS p__tva_commission, p.shipping AS p__shipping, p.estimated_delivery_at AS p__estimated_delivery_at, p.planned_delivery_at AS p__planned_delivery_at, p.enabled AS p__enabled, p.need_immatriculation_mandat AS p__need_immatriculation_mandat, p.hidden AS p__hidden, p.homepage AS p__homepage, p.brand_id AS p__brand_id, p.sale_id AS p__sale_id, p.category_id AS p__category_id, p.product_status_id AS p__product_status_id, p.stock_id AS p__stock_id, p.visited_at AS p__visited_at, p.delivery_at AS p__delivery_at, p.is_new AS p__is_new, p.date_end_new AS p__date_end_new, p.in_inventory AS p__in_inventory, p.is_stock_in_trade AS p__is_stock_in_trade, p.counter_consult AS p__counter_consult, p.counter_view AS p__counter_view, p.validated_at AS p__validated_at, p.created_at AS p__created_at, p.updated_at AS p__updated_at, p2.id AS p2__id, p2.title AS p2__title, p2.title_balise AS p2__title_balise, p2.short_description AS p2__short_description, p2.description AS p2__description, p2.meta_desc AS p2__meta_desc, p2.meta_keyword AS p2__meta_keyword, p2.place_to_take AS p2__place_to_take, p2.meeting_option AS p2__meeting_option, p2.video_code AS p2__video_code, p2.line_invoice1 AS p2__line_invoice1, p2.line_invoice2 AS p2__line_invoice2, p2.line_invoice3 AS p2__line_invoice3, p2.lang AS p2__lang, p2.slug AS p2__slug, i.id AS i__id, i.url AS i__url, i.product_id AS i__product_id, i.extension AS i__extension, i.position AS i__position, i.new_position AS i__new_position, i.enabled AS i__enabled, i.created_at AS i__created_at, i.updated_at AS i__updated_at, s.id AS s__id, s.ref AS s__ref, s.sale_mother_id AS s__sale_mother_id, s.image AS s__image, s.banner AS s__banner, s.banner_new AS s__banner_new, s.judge_id AS s__judge_id, s.curator_id AS s__curator_id, s.associate_member_id AS s__associate_member_id, s.sale_type_id AS s__sale_type_id, s.last_invoice_id AS s__last_invoice_id, s.commercial_court AS s__commercial_court, s.begin_at AS s__begin_at, s.first_end_at AS s__first_end_at, s.end_at AS s__end_at, s.company_name AS s__company_name, s.address1 AS s__address1, s.address2 AS s__address2, s.post_code AS s__post_code, s.city AS s__city, s.social_reason AS s__social_reason, s.company_social_reason_id AS s__company_social_reason_id, s.matricule AS s__matricule, s.vat_number AS s__vat_number, s.country_id AS s__country_id, s.owner_description AS s__owner_description, s.activity_domain AS s__activity_domain, s.mission_description AS s__mission_description, s.enabled AS s__enabled, s.category_id AS s__category_id, s.mission_end AS s__mission_end, s.inventory_at AS s__inventory_at, s.validated_contract_at AS s__validated_contract_at, s.implementated_at AS s__implementated_at, s.sfguarduser_id AS s__sfguarduser_id, s.stock_id AS s__stock_id, s.tva AS s__tva, s.vat_rate_id AS s__vat_rate_id, s.commission AS s__commission, s.tva_commission AS s__tva_commission, s.vat_rate_commission_id AS s__vat_rate_commission_id, s.vendor_commission AS s__vendor_commission, s.account_to_receive AS s__account_to_receive, s.account_received AS s__account_received, s.vat_only AS s__vat_only, s.visit_pad AS s__visit_pad, s.visited_at AS s__visited_at, s.visit_closed AS s__visit_closed, s.visited_at_day AS s__visited_at_day, s.delivery_at AS s__delivery_at, s.delivery_at_day AS s__delivery_at_day, s.delivery_planned AS s__delivery_planned, s.delivery_temporary_planification AS s__delivery_temporary_planification, s.external_invoice AS s__external_invoice, s.type_external_invoice AS s__type_external_invoice, s.type_commission AS s__type_commission, s.sell_mode AS s__sell_mode, s.last_invoice_number AS s__last_invoice_number, s.invoice_prefix AS s__invoice_prefix, s.last_credit_note AS s__last_credit_note, s.last_proforma AS s__last_proforma, s.bank_nummer AS s__bank_nummer, s.bic_number AS s__bic_number, s.account AS s__account, s.bank_nummer2 AS s__bank_nummer2, s.bic_number2 AS s__bic_number2, s.account2 AS s__account2, s.bank_nummer3 AS s__bank_nummer3, s.bic_number3 AS s__bic_number3, s.account3 AS s__account3, s.ogone_enabled AS s__ogone_enabled, s.choice_stock AS s__choice_stock, s.view_counter AS s__view_counter, s.cpt AS s__cpt, s.cpt_nc AS s__cpt_nc, s.cpt_pf AS s__cpt_pf, s.info_additional_invoice AS s__info_additional_invoice, s.fund_to_be_transferred AS s__fund_to_be_transferred, s.fund_to_be_transferred_bank AS s__fund_to_be_transferred_bank, s.fund_transferred AS s__fund_transferred, s.is_stock_in_trade AS s__is_stock_in_trade, s.is_stock_in_trade_url AS s__is_stock_in_trade_url, s.sale_status_id AS s__sale_status_id, s.position AS s__position, s.limit_at AS s__limit_at, s.locked_by AS s__locked_by, s.locked_until AS s__locked_until, s.global AS s__global, s.global_only AS s__global_only, s.manager_id AS s__manager_id, s.leader_id AS s__leader_id, s.could_be_closed AS s__could_be_closed, s.soon_available AS s__soon_available, s.report_before_start AS s__report_before_start, s.key_status_id AS s__key_status_id, s.key_position AS s__key_position, s.sepa_communication_type AS s__sepa_communication_type, s.created_at AS s__created_at, s.updated_at AS s__updated_at FROM product p LEFT JOIN product_translation p2 ON p.id = p2.id AND (p2.lang = ?) LEFT JOIN image_product i ON p.id = i.product_id INNER JOIN sale s ON p.sale_id = s.id WHERE p.id IN ('199396', '199722', '199845', '200388') AND (i.enabled = ? AND p.homepage = ? AND p.enabled = 1 AND p.htva_price > 0 AND p.end_at > NOW() AND s.enabled = 1 AND s.end_at > NOW()) ORDER BY i.position - (fr, 1, 1) |
| 63 | sfPartialView | Render "sf_app_dir/modules/default/templates/_widget_selection.php" |
| 64 | Doctrine_Connection_Statement | execute : SELECT c.id AS c__id, c.number AS c__number, c.alpha3 AS c__alpha3, c.alpha2 AS c__alpha2, c.vat_mask AS c__vat_mask, c.enabled AS c__enabled, c.position AS c__position, c.created_at AS c__created_at, c.updated_at AS c__updated_at FROM country c WHERE (c.id = ?) - (20) |
| 65 | sfPartialView | Render "sf_app_dir/modules/product/templates/_counter.php" |
| 66 | sfPartialView | Render "sf_app_dir/modules/default/templates/_script-js-follow.js.php" |
| 67 | Doctrine_Connection_Statement | execute : SELECT c.id AS c__id, c.number AS c__number, c.alpha3 AS c__alpha3, c.alpha2 AS c__alpha2, c.vat_mask AS c__vat_mask, c.enabled AS c__enabled, c.position AS c__position, c.created_at AS c__created_at, c.updated_at AS c__updated_at FROM country c WHERE (c.id = ?) - (20) |
| 68 | sfPartialView | Render "sf_app_dir/modules/product/templates/_counter.php" |
| 69 | sfPartialView | Render "sf_app_dir/modules/default/templates/_script-js-follow.js.php" |
| 70 | Doctrine_Connection_Statement | execute : SELECT c.id AS c__id, c.number AS c__number, c.alpha3 AS c__alpha3, c.alpha2 AS c__alpha2, c.vat_mask AS c__vat_mask, c.enabled AS c__enabled, c.position AS c__position, c.created_at AS c__created_at, c.updated_at AS c__updated_at FROM country c WHERE (c.id = ?) - (20) |
| 71 | sfPartialView | Render "sf_app_dir/modules/product/templates/_counter.php" |
| 72 | sfPartialView | Render "sf_app_dir/modules/default/templates/_script-js-follow.js.php" |
| 73 | Doctrine_Connection_Statement | execute : SELECT c.id AS c__id, c.number AS c__number, c.alpha3 AS c__alpha3, c.alpha2 AS c__alpha2, c.vat_mask AS c__vat_mask, c.enabled AS c__enabled, c.position AS c__position, c.created_at AS c__created_at, c.updated_at AS c__updated_at FROM country c WHERE (c.id = ?) - (20) |
| 74 | sfPartialView | Render "sf_app_dir/modules/product/templates/_counter.php" |
| 75 | sfPartialView | Render "sf_app_dir/modules/default/templates/_script-js-follow.js.php" |
| 76 | sfPartialView | Render "sf_app_dir/modules/default/templates/_footer.php" |
| 77 | Doctrine_Connection_Statement | execute : SELECT p.id AS p__id, p.template_id AS p__template_id, p.code AS p__code, p.position AS p__position, p.in_sitemap AS p__in_sitemap, p.enabled AS p__enabled, p.created_at AS p__created_at, p.updated_at AS p__updated_at, p2.id AS p2__id, p2.meta_title AS p2__meta_title, p2.meta_keyword AS p2__meta_keyword, p2.meta_description AS p2__meta_description, p2.lang AS p2__lang, p2.slug AS p2__slug FROM page p LEFT JOIN page_translation p2 ON p.id = p2.id WHERE (p.code = ?) - (HELP) |
| 78 | Doctrine_Connection_Statement | execute : SELECT p.id AS p__id, p.template_id AS p__template_id, p.code AS p__code, p.position AS p__position, p.in_sitemap AS p__in_sitemap, p.enabled AS p__enabled, p.created_at AS p__created_at, p.updated_at AS p__updated_at, p2.id AS p2__id, p2.meta_title AS p2__meta_title, p2.meta_keyword AS p2__meta_keyword, p2.meta_description AS p2__meta_description, p2.lang AS p2__lang, p2.slug AS p2__slug FROM page p LEFT JOIN page_translation p2 ON p.id = p2.id WHERE (p.code = ?) - (CGV) |
| 79 | Doctrine_Connection_Statement | execute : SELECT p.id AS p__id, p.template_id AS p__template_id, p.code AS p__code, p.position AS p__position, p.in_sitemap AS p__in_sitemap, p.enabled AS p__enabled, p.created_at AS p__created_at, p.updated_at AS p__updated_at, p2.id AS p2__id, p2.meta_title AS p2__meta_title, p2.meta_keyword AS p2__meta_keyword, p2.meta_description AS p2__meta_description, p2.lang AS p2__lang, p2.slug AS p2__slug FROM page p LEFT JOIN page_translation p2 ON p.id = p2.id WHERE (p.code = ?) - (COOKIE) |
| 80 | Doctrine_Connection_Statement | execute : SELECT p.id AS p__id, p.template_id AS p__template_id, p.code AS p__code, p.position AS p__position, p.in_sitemap AS p__in_sitemap, p.enabled AS p__enabled, p.created_at AS p__created_at, p.updated_at AS p__updated_at, p2.id AS p2__id, p2.meta_title AS p2__meta_title, p2.meta_keyword AS p2__meta_keyword, p2.meta_description AS p2__meta_description, p2.lang AS p2__lang, p2.slug AS p2__slug FROM page p LEFT JOIN page_translation p2 ON p.id = p2.id WHERE (p.code = ?) - (ACCESSIBILITE) |
| 81 | sfPartialView | Render "sf_app_dir/modules/default/templates/_robot.php" |
| 82 | sfWebResponse | Send status "HTTP/1.1 200 OK" |
| 83 | sfWebResponse | Send header "Content-Type: text/html; charset=utf-8" |
config
view
logs
2048.0 KB
406 ms
32
