Symfony Profiler

SELECT
  t0.c_projectline_id AS c_projectline_id_1,
  t0.ad_client_id AS ad_client_id_2,
  t0.ad_org_id AS ad_org_id_3,
  t0.isactive AS isactive_4,
  t0.created AS created_5,
  t0.createdby AS createdby_6,
  t0.updated AS updated_7,
  t0.updatedby AS updatedby_8,
  t0.line AS line_9,
  t0.description AS description_10,
  t0.plannedqty AS plannedqty_11,
  t0.plannedprice AS plannedprice_12,
  t0.plannedamt AS plannedamt_13,
  t0.plannedmarginamt AS plannedmarginamt_14,
  t0.committedamt AS committedamt_15,
  t0.invoicedamt AS invoicedamt_16,
  t0.invoicedqty AS invoicedqty_17,
  t0.committedqty AS committedqty_18,
  t0.isprinted AS isprinted_19,
  t0.processed AS processed_20,
  t0.dopricing AS dopricing_21,
  t0.coo_prjlpfc AS coo_prjlpfc_22,
  t0.coo_projectldocstatus AS coo_projectldocstatus_23,
  t0.m_locator_id AS m_locator_id_24,
  t0.datefinish AS datefinish_25,
  t0.oo_copy_pl_bom AS oo_copy_pl_bom_26,
  t0.coo_btnprintpfcv AS coo_btnprintpfcv_27,
  t0.coo_createoda AS coo_createoda_28,
  t0.oogenerateinventoryfromproline AS oogenerateinventoryfromproline_29,
  t0.coo_generateinventorypl AS coo_generateinventorypl_30,
  t0.description2 AS description2_31,
  t0.s_resourceassignment_id AS s_resourceassignment_id_32,
  t0.uuid AS uuid_33,
  t0.c_order_id AS c_order_id_34,
  t0.c_orderpo_id AS c_orderpo_id_35,
  t0.c_projectissue_id AS c_projectissue_id_36,
  t0.c_projectphase_id AS c_projectphase_id_37,
  t0.c_projecttask_id AS c_projecttask_id_38,
  t0.m_product_id AS m_product_id_39,
  t0.m_product_category_id AS m_product_category_id_40,
  t0.c_project_id AS c_project_id_41
FROM
  c_projectline t0
WHERE
  t0.c_projectline_id = ?

SELECT t0.c_projectline_id AS c_projectline_id_1, t0.ad_client_id AS ad_client_id_2, t0.ad_org_id AS ad_org_id_3, t0.isactive AS isactive_4, t0.created AS created_5, t0.createdby AS createdby_6, t0.updated AS updated_7, t0.updatedby AS updatedby_8, t0.line AS line_9, t0.description AS description_10, t0.plannedqty AS plannedqty_11, t0.plannedprice AS plannedprice_12, t0.plannedamt AS plannedamt_13, t0.plannedmarginamt AS plannedmarginamt_14, t0.committedamt AS committedamt_15, t0.invoicedamt AS invoicedamt_16, t0.invoicedqty AS invoicedqty_17, t0.committedqty AS committedqty_18, t0.isprinted AS isprinted_19, t0.processed AS processed_20, t0.dopricing AS dopricing_21, t0.coo_prjlpfc AS coo_prjlpfc_22, t0.coo_projectldocstatus AS coo_projectldocstatus_23, t0.m_locator_id AS m_locator_id_24, t0.datefinish AS datefinish_25, t0.oo_copy_pl_bom AS oo_copy_pl_bom_26, t0.coo_btnprintpfcv AS coo_btnprintpfcv_27, t0.coo_createoda AS coo_createoda_28, t0.oogenerateinventoryfromproline AS oogenerateinventoryfromproline_29, t0.coo_generateinventorypl AS coo_generateinventorypl_30, t0.description2 AS description2_31, t0.s_resourceassignment_id AS s_resourceassignment_id_32, t0.uuid AS uuid_33, t0.c_order_id AS c_order_id_34, t0.c_orderpo_id AS c_orderpo_id_35, t0.c_projectissue_id AS c_projectissue_id_36, t0.c_projectphase_id AS c_projectphase_id_37, t0.c_projecttask_id AS c_projecttask_id_38, t0.m_product_id AS m_product_id_39, t0.m_product_category_id AS m_product_category_id_40, t0.c_project_id AS c_project_id_41 FROM c_projectline t0 WHERE t0.c_projectline_id = '1118021';

SELECT
  t0.c_project_id AS c_project_id_1,
  t0.isactive AS isactive_2,
  t0.created AS created_3,
  t0.createdby AS createdby_4,
  t0.updated AS updated_5,
  t0.updatedby AS updatedby_6,
  t0.value AS value_7,
  t0.name AS name_8,
  t0.description AS description_9,
  t0.note AS note_10,
  t0.issummary AS issummary_11,
  t0.poreference AS poreference_12,
  t0.iscommitment AS iscommitment_13,
  t0.plannedamt AS plannedamt_14,
  t0.plannedqty AS plannedqty_15,
  t0.plannedmarginamt AS plannedmarginamt_16,
  t0.committedamt AS committedamt_17,
  t0.datecontract AS datecontract_18,
  t0.datefinish AS datefinish_19,
  t0.generateto AS generateto_20,
  t0.processed AS processed_21,
  t0.copyfrom AS copyfrom_22,
  t0.committedqty AS committedqty_23,
  t0.invoicedamt AS invoicedamt_24,
  t0.invoicedqty AS invoicedqty_25,
  t0.projectbalanceamt AS projectbalanceamt_26,
  t0.iscommitceiling AS iscommitceiling_27,
  t0.projectcategory AS projectcategory_28,
  t0.processing AS processing_29,
  t0.projinvoicerule AS projinvoicerule_30,
  t0.projectlinelevel AS projectlinelevel_31,
  t0.coo_projectdocstatus AS coo_projectdocstatus_32,
  t0.coo_generatemovement AS coo_generatemovement_33,
  t0.oogeneratesaleorder AS oogeneratesaleorder_34,
  t0.paymentrule AS paymentrule_35,
  t0.isachieved AS isachieved_36,
  t0.uuid AS uuid_37,
  t0.iseurokit AS iseurokit_38,
  t0.coo_selezionaverniciatori AS coo_selezionaverniciatori_39,
  t0.coo_generateclorders AS coo_generateclorders_40,
  t0.c_bpartner_location_id AS c_bpartner_location_id_41,
  t0.c_campaign_id AS c_campaign_id_42,
  t0.c_currency_id AS c_currency_id_43,
  t0.c_paymentterm_id AS c_paymentterm_id_44,
  t0.c_phase_id AS c_phase_id_45,
  t0.c_projecttype_id AS c_projecttype_id_46,
  t0.m_pricelist_version_id AS m_pricelist_version_id_47,
  t0.m_warehouse_id AS m_warehouse_id_48,
  t0.ad_client_id AS ad_client_id_49,
  t0.ad_org_id AS ad_org_id_50,
  t0.ad_user_id AS ad_user_id_51,
  t0.salesrep_id AS salesrep_id_52,
  t0.c_bpartner_id AS c_bpartner_id_53,
  t0.c_bpartnersr_id AS c_bpartnersr_id_54
FROM
  c_project t0
WHERE
  t0.c_project_id = ?

SELECT t0.c_project_id AS c_project_id_1, t0.isactive AS isactive_2, t0.created AS created_3, t0.createdby AS createdby_4, t0.updated AS updated_5, t0.updatedby AS updatedby_6, t0.value AS value_7, t0.name AS name_8, t0.description AS description_9, t0.note AS note_10, t0.issummary AS issummary_11, t0.poreference AS poreference_12, t0.iscommitment AS iscommitment_13, t0.plannedamt AS plannedamt_14, t0.plannedqty AS plannedqty_15, t0.plannedmarginamt AS plannedmarginamt_16, t0.committedamt AS committedamt_17, t0.datecontract AS datecontract_18, t0.datefinish AS datefinish_19, t0.generateto AS generateto_20, t0.processed AS processed_21, t0.copyfrom AS copyfrom_22, t0.committedqty AS committedqty_23, t0.invoicedamt AS invoicedamt_24, t0.invoicedqty AS invoicedqty_25, t0.projectbalanceamt AS projectbalanceamt_26, t0.iscommitceiling AS iscommitceiling_27, t0.projectcategory AS projectcategory_28, t0.processing AS processing_29, t0.projinvoicerule AS projinvoicerule_30, t0.projectlinelevel AS projectlinelevel_31, t0.coo_projectdocstatus AS coo_projectdocstatus_32, t0.coo_generatemovement AS coo_generatemovement_33, t0.oogeneratesaleorder AS oogeneratesaleorder_34, t0.paymentrule AS paymentrule_35, t0.isachieved AS isachieved_36, t0.uuid AS uuid_37, t0.iseurokit AS iseurokit_38, t0.coo_selezionaverniciatori AS coo_selezionaverniciatori_39, t0.coo_generateclorders AS coo_generateclorders_40, t0.c_bpartner_location_id AS c_bpartner_location_id_41, t0.c_campaign_id AS c_campaign_id_42, t0.c_currency_id AS c_currency_id_43, t0.c_paymentterm_id AS c_paymentterm_id_44, t0.c_phase_id AS c_phase_id_45, t0.c_projecttype_id AS c_projecttype_id_46, t0.m_pricelist_version_id AS m_pricelist_version_id_47, t0.m_warehouse_id AS m_warehouse_id_48, t0.ad_client_id AS ad_client_id_49, t0.ad_org_id AS ad_org_id_50, t0.ad_user_id AS ad_user_id_51, t0.salesrep_id AS salesrep_id_52, t0.c_bpartner_id AS c_bpartner_id_53, t0.c_bpartnersr_id AS c_bpartnersr_id_54 FROM c_project t0 WHERE t0.c_project_id = '1022820';

SELECT
  c0_.coo_pf_pistolettate_id AS coo_pf_pistolettate_id_0,
  c0_.ad_client_id AS ad_client_id_1,
  c0_.ad_org_id AS ad_org_id_2,
  c0_.isactive AS isactive_3,
  c0_.created AS created_4,
  c0_.createdby AS createdby_5,
  c0_.updated AS updated_6,
  c0_.updatedby AS updatedby_7,
  c0_.name AS name_8,
  c0_.coo_pf_event_type AS coo_pf_event_type_9,
  c0_.status AS status_10,
  c0_.description AS description_11,
  c0_.data_lettura AS data_lettura_12,
  c0_.posizione AS posizione_13,
  c0_.coo_pf_postazioni_id AS coo_pf_postazioni_id_14,
  c0_.c_project_id AS c_project_id_15,
  c0_.ad_user_id AS ad_user_id_16,
  c0_.c_projectline_id AS c_projectline_id_17
FROM
  coo_pf_pistolettate c0_
  INNER JOIN c_project c1_ ON c0_.c_project_id = c1_.c_project_id
  INNER JOIN coo_pf_postazioni c2_ ON c0_.coo_pf_postazioni_id = c2_.coo_pf_postazioni_id
WHERE
  c0_.isactive = ?
  AND c1_.isactive = ?
  AND c0_.name IS NOT NULL
  AND c0_.name <> ''
  AND c2_.coo_pf_postazioni_id = ?
ORDER BY
  c0_.coo_pf_pistolettate_id DESC

SELECT c0_.coo_pf_pistolettate_id AS coo_pf_pistolettate_id_0, c0_.ad_client_id AS ad_client_id_1, c0_.ad_org_id AS ad_org_id_2, c0_.isactive AS isactive_3, c0_.created AS created_4, c0_.createdby AS createdby_5, c0_.updated AS updated_6, c0_.updatedby AS updatedby_7, c0_.name AS name_8, c0_.coo_pf_event_type AS coo_pf_event_type_9, c0_.status AS status_10, c0_.description AS description_11, c0_.data_lettura AS data_lettura_12, c0_.posizione AS posizione_13, c0_.coo_pf_postazioni_id AS coo_pf_postazioni_id_14, c0_.c_project_id AS c_project_id_15, c0_.ad_user_id AS ad_user_id_16, c0_.c_projectline_id AS c_projectline_id_17 FROM coo_pf_pistolettate c0_ INNER JOIN c_project c1_ ON c0_.c_project_id = c1_.c_project_id INNER JOIN coo_pf_postazioni c2_ ON c0_.coo_pf_postazioni_id = c2_.coo_pf_postazioni_id WHERE c0_.isactive = 'Y' AND c1_.isactive = 'Y' AND c0_.name IS NOT NULL AND c0_.name <> '' AND c2_.coo_pf_postazioni_id = '1000007' ORDER BY c0_.coo_pf_pistolettate_id DESC;

SELECT
  t0.ad_user_id AS ad_user_id_1,
  t0.isactive AS isactive_2,
  t0.created AS created_3,
  t0.createdby AS createdby_4,
  t0.updated AS updated_5,
  t0.updatedby AS updatedby_6,
  t0.name AS name_7,
  t0.description AS description_8,
  t0.password AS password_9,
  t0.email AS email_10,
  t0.processing AS processing_11,
  t0.emailuser AS emailuser_12,
  t0.emailuserpw AS emailuserpw_13,
  t0.title AS title_14,
  t0.comments AS comments_15,
  t0.phone AS phone_16,
  t0.phone2 AS phone2_17,
  t0.fax AS fax_18,
  t0.lastcontact AS lastcontact_19,
  t0.lastresult AS lastresult_20,
  t0.birthday AS birthday_21,
  t0.emailverify AS emailverify_22,
  t0.emailverifydate AS emailverifydate_23,
  t0.notificationtype AS notificationtype_24,
  t0.isfullbpaccess AS isfullbpaccess_25,
  t0.ldapuser AS ldapuser_26,
  t0.connectionprofile AS connectionprofile_27,
  t0.value AS value_28,
  t0.userpin AS userpin_29,
  t0.isinpayroll AS isinpayroll_30,
  t0.coo_ispec AS coo_ispec_31,
  t0.salt AS salt_32,
  t0.issaleslead AS issaleslead_33,
  t0.c_location_id AS c_location_id_34,
  t0.leadsource AS leadsource_35,
  t0.leadstatus AS leadstatus_36,
  t0.leadsourcedescription AS leadsourcedescription_37,
  t0.leadstatusdescription AS leadstatusdescription_38,
  t0.c_campaign_id AS c_campaign_id_39,
  t0.salesrep_id AS salesrep_id_40,
  t0.bpname AS bpname_41,
  t0.bp_location_id AS bp_location_id_42,
  t0.isloginuser AS isloginuser_43,
  t0.isinternaluser AS isinternaluser_44,
  t0.iswebstoreuser AS iswebstoreuser_45,
  t0.recentitemsmaxsaved AS recentitemsmaxsaved_46,
  t0.recentitemsmaxshown AS recentitemsmaxshown_47,
  t0.uuid AS uuid_48,
  t0.coo_issollecito AS coo_issollecito_49,
  t0.coo_interfaccia1 AS coo_interfaccia1_50,
  t0.coo_interfaccia2 AS coo_interfaccia2_51,
  t0.coo_contactrole AS coo_contactrole_52,
  t0.coo_dipartimento_lotus AS coo_dipartimento_lotus_53,
  t0.c_bpartner_id AS c_bpartner_id_54,
  t0.supervisor_id AS supervisor_id_55
FROM
  ad_user t0
WHERE
  t0.name = ?
LIMIT
  1

SELECT t0.ad_user_id AS ad_user_id_1, t0.isactive AS isactive_2, t0.created AS created_3, t0.createdby AS createdby_4, t0.updated AS updated_5, t0.updatedby AS updatedby_6, t0.name AS name_7, t0.description AS description_8, t0.password AS password_9, t0.email AS email_10, t0.processing AS processing_11, t0.emailuser AS emailuser_12, t0.emailuserpw AS emailuserpw_13, t0.title AS title_14, t0.comments AS comments_15, t0.phone AS phone_16, t0.phone2 AS phone2_17, t0.fax AS fax_18, t0.lastcontact AS lastcontact_19, t0.lastresult AS lastresult_20, t0.birthday AS birthday_21, t0.emailverify AS emailverify_22, t0.emailverifydate AS emailverifydate_23, t0.notificationtype AS notificationtype_24, t0.isfullbpaccess AS isfullbpaccess_25, t0.ldapuser AS ldapuser_26, t0.connectionprofile AS connectionprofile_27, t0.value AS value_28, t0.userpin AS userpin_29, t0.isinpayroll AS isinpayroll_30, t0.coo_ispec AS coo_ispec_31, t0.salt AS salt_32, t0.issaleslead AS issaleslead_33, t0.c_location_id AS c_location_id_34, t0.leadsource AS leadsource_35, t0.leadstatus AS leadstatus_36, t0.leadsourcedescription AS leadsourcedescription_37, t0.leadstatusdescription AS leadstatusdescription_38, t0.c_campaign_id AS c_campaign_id_39, t0.salesrep_id AS salesrep_id_40, t0.bpname AS bpname_41, t0.bp_location_id AS bp_location_id_42, t0.isloginuser AS isloginuser_43, t0.isinternaluser AS isinternaluser_44, t0.iswebstoreuser AS iswebstoreuser_45, t0.recentitemsmaxsaved AS recentitemsmaxsaved_46, t0.recentitemsmaxshown AS recentitemsmaxshown_47, t0.uuid AS uuid_48, t0.coo_issollecito AS coo_issollecito_49, t0.coo_interfaccia1 AS coo_interfaccia1_50, t0.coo_interfaccia2 AS coo_interfaccia2_51, t0.coo_contactrole AS coo_contactrole_52, t0.coo_dipartimento_lotus AS coo_dipartimento_lotus_53, t0.c_bpartner_id AS c_bpartner_id_54, t0.supervisor_id AS supervisor_id_55 FROM ad_user t0 WHERE t0.name = 'zsoltek' LIMIT 1;

SELECT
  t0.coo_pf_postazioni_id AS coo_pf_postazioni_id_1,
  t0.ad_client_id AS ad_client_id_2,
  t0.ad_org_id AS ad_org_id_3,
  t0.isactive AS isactive_4,
  t0.read_posizione AS read_posizione_5,
  t0.created AS created_6,
  t0.createdby AS createdby_7,
  t0.updated AS updated_8,
  t0.updatedby AS updatedby_9,
  t0.name AS name_10,
  t0.description AS description_11,
  t0.line AS line_12,
  t0.coo_icon AS coo_icon_13,
  t0.coo_stabilimento_id AS coo_stabilimento_id_14
FROM
  coo_pf_postazioni t0
WHERE
  t0.coo_pf_postazioni_id = ?

SELECT t0.coo_pf_postazioni_id AS coo_pf_postazioni_id_1, t0.ad_client_id AS ad_client_id_2, t0.ad_org_id AS ad_org_id_3, t0.isactive AS isactive_4, t0.read_posizione AS read_posizione_5, t0.created AS created_6, t0.createdby AS createdby_7, t0.updated AS updated_8, t0.updatedby AS updatedby_9, t0.name AS name_10, t0.description AS description_11, t0.line AS line_12, t0.coo_icon AS coo_icon_13, t0.coo_stabilimento_id AS coo_stabilimento_id_14 FROM coo_pf_postazioni t0 WHERE t0.coo_pf_postazioni_id = 1000007;