Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.username AS username_5,
  t0.currency AS currency_6,
  t0.recent_requests AS recent_requests_7,
  t0.recent_materials AS recent_materials_8,
  t0.recent_routings AS recent_routings_9
FROM
  user t0
WHERE
  t0.email = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.username AS username_5, t0.currency AS currency_6, t0.recent_requests AS recent_requests_7, t0.recent_materials AS recent_materials_8, t0.recent_routings AS recent_routings_9 FROM user t0 WHERE t0.email = 'khalil.khattab@linxens.com' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.titre AS titre_2,
  t0.prixref AS prixref_3,
  t0.refinterne AS refinterne_4,
  t0.bomusage AS bomusage_5,
  t0.bomunit AS bomunit_6,
  t0.createdon AS createdon_7,
  t0.inforec AS inforec_8,
  t0.pint AS pint_9,
  t0.mtyp AS mtyp_10,
  t0.proctype AS proctype_11,
  t0.crcy AS crcy_12,
  t0.checknotif AS checknotif_13,
  t0.updatedon AS updatedon_14
FROM
  matiere_premiere t0

SELECT t0.id AS id_1, t0.titre AS titre_2, t0.prixref AS prixref_3, t0.refinterne AS refinterne_4, t0.bomusage AS bomusage_5, t0.bomunit AS bomunit_6, t0.createdon AS createdon_7, t0.inforec AS inforec_8, t0.pint AS pint_9, t0.mtyp AS mtyp_10, t0.proctype AS proctype_11, t0.crcy AS crcy_12, t0.checknotif AS checknotif_13, t0.updatedon AS updatedon_14 FROM matiere_premiere t0;

SELECT
  t0.id AS id_1,
  t0.titre AS titre_2,
  t0.refinterne AS refinterne_3,
  t0.workcenter AS workcenter_4,
  t0.plant AS plant_5,
  t0.controlkey AS controlkey_6,
  t0.textkey AS textkey_7,
  t0.unit AS unit_8,
  t0.setupquantity AS setupquantity_9,
  t0.checknotif AS checknotif_10,
  t0.crcy AS crcy_11,
  t0.createdon AS createdon_12,
  t0.baseqty AS baseqty_13
FROM
  process_prod t0

SELECT t0.id AS id_1, t0.titre AS titre_2, t0.refinterne AS refinterne_3, t0.workcenter AS workcenter_4, t0.plant AS plant_5, t0.controlkey AS controlkey_6, t0.textkey AS textkey_7, t0.unit AS unit_8, t0.setupquantity AS setupquantity_9, t0.checknotif AS checknotif_10, t0.crcy AS crcy_11, t0.createdon AS createdon_12, t0.baseqty AS baseqty_13 FROM process_prod t0;

SELECT
  c0_.id AS id_0,
  c0_.titre AS titre_1,
  c0_.createdat AS createdat_2,
  c0_.updatedat AS updatedat_3,
  c0_.status AS status_4,
  c0_.refclient AS refclient_5,
  c0_.quantite AS quantite_6,
  c0_.description AS description_7,
  c0_.drawing AS drawing_8,
  c0_.alttext AS alttext_9,
  c0_.drawinga AS drawinga_10,
  c0_.isactivesimul AS isactivesimul_11,
  c0_.createur_id AS createur_id_12,
  c0_.parent_id AS parent_id_13,
  c0_.stdconfig_id AS stdconfig_id_14
FROM
  cotation c0_
WHERE
  c0_.status IN ('INIT', 'DRAFT', 'OK', 'Autre')
ORDER BY
  c0_.createdat DESC

SELECT c0_.id AS id_0, c0_.titre AS titre_1, c0_.createdat AS createdat_2, c0_.updatedat AS updatedat_3, c0_.status AS status_4, c0_.refclient AS refclient_5, c0_.quantite AS quantite_6, c0_.description AS description_7, c0_.drawing AS drawing_8, c0_.alttext AS alttext_9, c0_.drawinga AS drawinga_10, c0_.isactivesimul AS isactivesimul_11, c0_.createur_id AS createur_id_12, c0_.parent_id AS parent_id_13, c0_.stdconfig_id AS stdconfig_id_14 FROM cotation c0_ WHERE c0_.status IN ('INIT', 'DRAFT', 'OK', 'Autre') ORDER BY c0_.createdat DESC;

SELECT
  t0.id AS id_1,
  t0.titre AS titre_2,
  t0.createdat AS createdat_3,
  t0.updatedat AS updatedat_4,
  t0.status AS status_5,
  t0.refclient AS refclient_6,
  t0.quantite AS quantite_7,
  t0.description AS description_8,
  t0.drawing AS drawing_9,
  t0.alttext AS alttext_10,
  t0.drawinga AS drawinga_11,
  t0.isactivesimul AS isactivesimul_12,
  t0.createur_id AS createur_id_13,
  t0.parent_id AS parent_id_14,
  t0.stdconfig_id AS stdconfig_id_15
FROM
  cotation t0
WHERE
  t0.status = ?
ORDER BY
  t0.createdat DESC

SELECT t0.id AS id_1, t0.titre AS titre_2, t0.createdat AS createdat_3, t0.updatedat AS updatedat_4, t0.status AS status_5, t0.refclient AS refclient_6, t0.quantite AS quantite_7, t0.description AS description_8, t0.drawing AS drawing_9, t0.alttext AS alttext_10, t0.drawinga AS drawinga_11, t0.isactivesimul AS isactivesimul_12, t0.createur_id AS createur_id_13, t0.parent_id AS parent_id_14, t0.stdconfig_id AS stdconfig_id_15 FROM cotation t0 WHERE t0.status = 'SIMUL' ORDER BY t0.createdat DESC;

SELECT
  t0.id AS id_1,
  t0.titre AS titre_2,
  t0.stdrequest_id AS stdrequest_id_3
FROM
  std_configuration t0

SELECT t0.id AS id_1, t0.titre AS titre_2, t0.stdrequest_id AS stdrequest_id_3 FROM std_configuration t0;

SELECT
  c0_.id AS id_0,
  c0_.titre AS titre_1,
  c0_.createdat AS createdat_2,
  c0_.updatedat AS updatedat_3,
  c0_.status AS status_4,
  c0_.refclient AS refclient_5,
  c0_.quantite AS quantite_6,
  c0_.description AS description_7,
  c0_.drawing AS drawing_8,
  c0_.alttext AS alttext_9,
  c0_.drawinga AS drawinga_10,
  c0_.isactivesimul AS isactivesimul_11,
  c0_.createur_id AS createur_id_12,
  c0_.parent_id AS parent_id_13,
  c0_.stdconfig_id AS stdconfig_id_14
FROM
  cotation c0_
WHERE
  c0_.status NOT IN ('SIMUL', 'STD_CONFIG', 'Autre')
  AND c0_.createur_id = ?
ORDER BY
  c0_.createdat DESC

SELECT c0_.id AS id_0, c0_.titre AS titre_1, c0_.createdat AS createdat_2, c0_.updatedat AS updatedat_3, c0_.status AS status_4, c0_.refclient AS refclient_5, c0_.quantite AS quantite_6, c0_.description AS description_7, c0_.drawing AS drawing_8, c0_.alttext AS alttext_9, c0_.drawinga AS drawinga_10, c0_.isactivesimul AS isactivesimul_11, c0_.createur_id AS createur_id_12, c0_.parent_id AS parent_id_13, c0_.stdconfig_id AS stdconfig_id_14 FROM cotation c0_ WHERE c0_.status NOT IN ('SIMUL', 'STD_CONFIG', 'Autre') AND c0_.createur_id = 2 ORDER BY c0_.createdat DESC;

SELECT
  m0_.id AS id_0,
  m0_.titre AS titre_1,
  m0_.prixref AS prixref_2,
  m0_.refinterne AS refinterne_3,
  m0_.bomusage AS bomusage_4,
  m0_.bomunit AS bomunit_5,
  m0_.createdon AS createdon_6,
  m0_.inforec AS inforec_7,
  m0_.pint AS pint_8,
  m0_.mtyp AS mtyp_9,
  m0_.proctype AS proctype_10,
  m0_.crcy AS crcy_11,
  m0_.checknotif AS checknotif_12,
  m0_.updatedon AS updatedon_13
FROM
  matiere_premiere m0_
WHERE
  m0_.refinterne = ?
  AND m0_.checknotif = ?
ORDER BY
  m0_.refinterne DESC

SELECT m0_.id AS id_0, m0_.titre AS titre_1, m0_.prixref AS prixref_2, m0_.refinterne AS refinterne_3, m0_.bomusage AS bomusage_4, m0_.bomunit AS bomunit_5, m0_.createdon AS createdon_6, m0_.inforec AS inforec_7, m0_.pint AS pint_8, m0_.mtyp AS mtyp_9, m0_.proctype AS proctype_10, m0_.crcy AS crcy_11, m0_.checknotif AS checknotif_12, m0_.updatedon AS updatedon_13 FROM matiere_premiere m0_ WHERE m0_.refinterne = '-' AND m0_.checknotif = 1 ORDER BY m0_.refinterne DESC;

SELECT
  m0_.id AS id_0,
  m0_.titre AS titre_1,
  m0_.prixref AS prixref_2,
  m0_.refinterne AS refinterne_3,
  m0_.bomusage AS bomusage_4,
  m0_.bomunit AS bomunit_5,
  m0_.createdon AS createdon_6,
  m0_.inforec AS inforec_7,
  m0_.pint AS pint_8,
  m0_.mtyp AS mtyp_9,
  m0_.proctype AS proctype_10,
  m0_.crcy AS crcy_11,
  m0_.checknotif AS checknotif_12,
  m0_.updatedon AS updatedon_13
FROM
  matiere_premiere m0_
WHERE
  m0_.refinterne <> ?
  AND m0_.checknotif = ?
ORDER BY
  m0_.refinterne DESC

SELECT m0_.id AS id_0, m0_.titre AS titre_1, m0_.prixref AS prixref_2, m0_.refinterne AS refinterne_3, m0_.bomusage AS bomusage_4, m0_.bomunit AS bomunit_5, m0_.createdon AS createdon_6, m0_.inforec AS inforec_7, m0_.pint AS pint_8, m0_.mtyp AS mtyp_9, m0_.proctype AS proctype_10, m0_.crcy AS crcy_11, m0_.checknotif AS checknotif_12, m0_.updatedon AS updatedon_13 FROM matiere_premiere m0_ WHERE m0_.refinterne <> '-' AND m0_.checknotif = '1' ORDER BY m0_.refinterne DESC;

SELECT
  p0_.id AS id_0,
  p0_.titre AS titre_1,
  p0_.refinterne AS refinterne_2,
  p0_.workcenter AS workcenter_3,
  p0_.plant AS plant_4,
  p0_.controlkey AS controlkey_5,
  p0_.textkey AS textkey_6,
  p0_.unit AS unit_7,
  p0_.setupquantity AS setupquantity_8,
  p0_.checknotif AS checknotif_9,
  p0_.crcy AS crcy_10,
  p0_.createdon AS createdon_11,
  p0_.baseqty AS baseqty_12
FROM
  process_prod p0_
WHERE
  p0_.refinterne = ?
  AND p0_.checknotif = ?
ORDER BY
  p0_.refinterne DESC

SELECT p0_.id AS id_0, p0_.titre AS titre_1, p0_.refinterne AS refinterne_2, p0_.workcenter AS workcenter_3, p0_.plant AS plant_4, p0_.controlkey AS controlkey_5, p0_.textkey AS textkey_6, p0_.unit AS unit_7, p0_.setupquantity AS setupquantity_8, p0_.checknotif AS checknotif_9, p0_.crcy AS crcy_10, p0_.createdon AS createdon_11, p0_.baseqty AS baseqty_12 FROM process_prod p0_ WHERE p0_.refinterne = '-' AND p0_.checknotif = 1 ORDER BY p0_.refinterne DESC;

SELECT
  p0_.id AS id_0,
  p0_.titre AS titre_1,
  p0_.refinterne AS refinterne_2,
  p0_.workcenter AS workcenter_3,
  p0_.plant AS plant_4,
  p0_.controlkey AS controlkey_5,
  p0_.textkey AS textkey_6,
  p0_.unit AS unit_7,
  p0_.setupquantity AS setupquantity_8,
  p0_.checknotif AS checknotif_9,
  p0_.crcy AS crcy_10,
  p0_.createdon AS createdon_11,
  p0_.baseqty AS baseqty_12
FROM
  process_prod p0_
WHERE
  p0_.refinterne <> ?
  AND p0_.checknotif = ?
ORDER BY
  p0_.refinterne DESC

SELECT p0_.id AS id_0, p0_.titre AS titre_1, p0_.refinterne AS refinterne_2, p0_.workcenter AS workcenter_3, p0_.plant AS plant_4, p0_.controlkey AS controlkey_5, p0_.textkey AS textkey_6, p0_.unit AS unit_7, p0_.setupquantity AS setupquantity_8, p0_.checknotif AS checknotif_9, p0_.crcy AS crcy_10, p0_.createdon AS createdon_11, p0_.baseqty AS baseqty_12 FROM process_prod p0_ WHERE p0_.refinterne <> '-' AND p0_.checknotif = '1' ORDER BY p0_.refinterne DESC;

SELECT
  c0_.id AS id_0,
  c0_.cname AS cname_1,
  c0_.cvalueint AS cvalueint_2,
  c0_.cvaluedate AS cvaluedate_3,
  c0_.cvaluefloat AS cvaluefloat_4
FROM
  cogsconfig c0_
WHERE
  c0_.cname = ?

SELECT c0_.id AS id_0, c0_.cname AS cname_1, c0_.cvalueint AS cvalueint_2, c0_.cvaluedate AS cvaluedate_3, c0_.cvaluefloat AS cvaluefloat_4 FROM cogsconfig c0_ WHERE c0_.cname = 'UNIT_PER_REQUEST';

SELECT
  c0_.id AS id_0,
  c0_.cname AS cname_1,
  c0_.cvalueint AS cvalueint_2,
  c0_.cvaluedate AS cvaluedate_3,
  c0_.cvaluefloat AS cvaluefloat_4
FROM
  cogsconfig c0_
WHERE
  c0_.cname = ?

SELECT c0_.id AS id_0, c0_.cname AS cname_1, c0_.cvalueint AS cvalueint_2, c0_.cvaluedate AS cvaluedate_3, c0_.cvaluefloat AS cvaluefloat_4 FROM cogsconfig c0_ WHERE c0_.cname = 'DATE_MAJ_MAT';

SELECT
  c0_.id AS id_0,
  c0_.cname AS cname_1,
  c0_.cvalueint AS cvalueint_2,
  c0_.cvaluedate AS cvaluedate_3,
  c0_.cvaluefloat AS cvaluefloat_4
FROM
  cogsconfig c0_
WHERE
  c0_.cname = ?

SELECT c0_.id AS id_0, c0_.cname AS cname_1, c0_.cvalueint AS cvalueint_2, c0_.cvaluedate AS cvaluedate_3, c0_.cvaluefloat AS cvaluefloat_4 FROM cogsconfig c0_ WHERE c0_.cname = 'DATE_MAJ_ROU';

SELECT
  t0.id AS id_1,
  t0.refinterne AS refinterne_2,
  t0.titre AS titre_3,
  t0.activitycost AS activitycost_4
FROM
  activity t0

SELECT t0.id AS id_1, t0.refinterne AS refinterne_2, t0.titre AS titre_3, t0.activitycost AS activitycost_4 FROM activity t0;

SELECT
  t0.id AS id_1,
  t0.refinterne AS refinterne_2,
  t0.titre AS titre_3
FROM
  cost_center t0

SELECT t0.id AS id_1, t0.refinterne AS refinterne_2, t0.titre AS titre_3 FROM cost_center t0;

SELECT
  t0.id AS id_1,
  t0.thbunit AS thbunit_2,
  t0.eurunit AS eurunit_3,
  t0.currency AS currency_4,
  t0.costcenter_id AS costcenter_id_5,
  t0.activity_id AS activity_id_6
FROM
  cost_center_line t0

SELECT t0.id AS id_1, t0.thbunit AS thbunit_2, t0.eurunit AS eurunit_3, t0.currency AS currency_4, t0.costcenter_id AS costcenter_id_5, t0.activity_id AS activity_id_6 FROM cost_center_line t0;

SELECT
  t0.id AS id_1,
  t0.prix AS prix_2,
  t0.bomusage AS bomusage_3,
  t0.costbool AS costbool_4,
  t0.scrap AS scrap_5,
  t0.bomunit AS bomunit_6,
  t0.linenb AS linenb_7,
  t0.ischip AS ischip_8,
  t0.cotation_id AS cotation_id_9,
  t0.matierepremiere_id AS matierepremiere_id_10
FROM
  cotation_detail t0
WHERE
  t0.cotation_id = ?

SELECT t0.id AS id_1, t0.prix AS prix_2, t0.bomusage AS bomusage_3, t0.costbool AS costbool_4, t0.scrap AS scrap_5, t0.bomunit AS bomunit_6, t0.linenb AS linenb_7, t0.ischip AS ischip_8, t0.cotation_id AS cotation_id_9, t0.matierepremiere_id AS matierepremiere_id_10 FROM cotation_detail t0 WHERE t0.cotation_id = 289;

SELECT
  t0.id AS id_1,
  t0.prix AS prix_2,
  t0.bomusage AS bomusage_3,
  t0.costbool AS costbool_4,
  t0.scrap AS scrap_5,
  t0.bomunit AS bomunit_6,
  t0.linenb AS linenb_7,
  t0.ischip AS ischip_8,
  t0.cotation_id AS cotation_id_9,
  t0.matierepremiere_id AS matierepremiere_id_10
FROM
  cotation_detail t0
WHERE
  t0.cotation_id = ?

SELECT t0.id AS id_1, t0.prix AS prix_2, t0.bomusage AS bomusage_3, t0.costbool AS costbool_4, t0.scrap AS scrap_5, t0.bomunit AS bomunit_6, t0.linenb AS linenb_7, t0.ischip AS ischip_8, t0.cotation_id AS cotation_id_9, t0.matierepremiere_id AS matierepremiere_id_10 FROM cotation_detail t0 WHERE t0.cotation_id = 287;

SELECT
  t0.id AS id_1,
  t0.prix AS prix_2,
  t0.bomusage AS bomusage_3,
  t0.costbool AS costbool_4,
  t0.scrap AS scrap_5,
  t0.bomunit AS bomunit_6,
  t0.linenb AS linenb_7,
  t0.ischip AS ischip_8,
  t0.cotation_id AS cotation_id_9,
  t0.matierepremiere_id AS matierepremiere_id_10
FROM
  cotation_detail t0
WHERE
  t0.cotation_id = ?

SELECT t0.id AS id_1, t0.prix AS prix_2, t0.bomusage AS bomusage_3, t0.costbool AS costbool_4, t0.scrap AS scrap_5, t0.bomunit AS bomunit_6, t0.linenb AS linenb_7, t0.ischip AS ischip_8, t0.cotation_id AS cotation_id_9, t0.matierepremiere_id AS matierepremiere_id_10 FROM cotation_detail t0 WHERE t0.cotation_id = 288;

SELECT
  t0.id AS id_1,
  t0.prix AS prix_2,
  t0.bomusage AS bomusage_3,
  t0.costbool AS costbool_4,
  t0.scrap AS scrap_5,
  t0.bomunit AS bomunit_6,
  t0.linenb AS linenb_7,
  t0.ischip AS ischip_8,
  t0.cotation_id AS cotation_id_9,
  t0.matierepremiere_id AS matierepremiere_id_10
FROM
  cotation_detail t0
WHERE
  t0.cotation_id = ?

SELECT t0.id AS id_1, t0.prix AS prix_2, t0.bomusage AS bomusage_3, t0.costbool AS costbool_4, t0.scrap AS scrap_5, t0.bomunit AS bomunit_6, t0.linenb AS linenb_7, t0.ischip AS ischip_8, t0.cotation_id AS cotation_id_9, t0.matierepremiere_id AS matierepremiere_id_10 FROM cotation_detail t0 WHERE t0.cotation_id = 280;

SELECT
  t0.id AS id_1,
  t0.prix AS prix_2,
  t0.bomusage AS bomusage_3,
  t0.costbool AS costbool_4,
  t0.scrap AS scrap_5,
  t0.bomunit AS bomunit_6,
  t0.linenb AS linenb_7,
  t0.ischip AS ischip_8,
  t0.cotation_id AS cotation_id_9,
  t0.matierepremiere_id AS matierepremiere_id_10
FROM
  cotation_detail t0
WHERE
  t0.cotation_id = ?

SELECT t0.id AS id_1, t0.prix AS prix_2, t0.bomusage AS bomusage_3, t0.costbool AS costbool_4, t0.scrap AS scrap_5, t0.bomunit AS bomunit_6, t0.linenb AS linenb_7, t0.ischip AS ischip_8, t0.cotation_id AS cotation_id_9, t0.matierepremiere_id AS matierepremiere_id_10 FROM cotation_detail t0 WHERE t0.cotation_id = 283;

SELECT
  t0.id AS id_1,
  t0.prix AS prix_2,
  t0.bomusage AS bomusage_3,
  t0.costbool AS costbool_4,
  t0.scrap AS scrap_5,
  t0.bomunit AS bomunit_6,
  t0.linenb AS linenb_7,
  t0.ischip AS ischip_8,
  t0.cotation_id AS cotation_id_9,
  t0.matierepremiere_id AS matierepremiere_id_10
FROM
  cotation_detail t0
WHERE
  t0.cotation_id = ?

SELECT t0.id AS id_1, t0.prix AS prix_2, t0.bomusage AS bomusage_3, t0.costbool AS costbool_4, t0.scrap AS scrap_5, t0.bomunit AS bomunit_6, t0.linenb AS linenb_7, t0.ischip AS ischip_8, t0.cotation_id AS cotation_id_9, t0.matierepremiere_id AS matierepremiere_id_10 FROM cotation_detail t0 WHERE t0.cotation_id = 276;