Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.firstname AS firstname_5,
  t0.lastname AS lastname_6
FROM
  user t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.firstname AS firstname_5, t0.lastname AS lastname_6 FROM user t0 WHERE t0.id = 8;

SELECT
  t0.id AS id_1,
  t0.business_name AS business_name_2,
  t0.street_address AS street_address_3,
  t0.state AS state_4,
  t0.fixe_phone AS fixe_phone_5,
  t0.fax_number AS fax_number_6,
  t0.mobile AS mobile_7,
  t0.email AS email_8,
  t0.website AS website_9,
  t0.categories AS categories_10,
  t0.logo AS logo_11,
  t0.city AS city_12,
  t0.description AS description_13,
  t0.contact_name AS contact_name_14,
  t0.business_title AS business_title_15,
  t0.custmer_type AS custmer_type_16,
  t0.key_words AS key_words_17,
  t0.general_info AS general_info_18,
  t0.created_by AS created_by_19,
  t0.statut AS statut_20,
  t0.created_date AS created_date_21,
  t0.company_presentation AS company_presentation_22,
  t0.year_established AS year_established_23,
  t0.service_photo_1 AS service_photo_1_24,
  t0.service_photo_2 AS service_photo_2_25,
  t0.service_photo_3 AS service_photo_3_26,
  t0.service_photo_4 AS service_photo_4_27,
  t0.service_photo_5 AS service_photo_5_28,
  t0.service_photo_6 AS service_photo_6_29,
  t0.documentations_catalogs AS documentations_catalogs_30,
  t0.company_references AS company_references_31,
  t0.video_entreprise AS video_entreprise_32,
  t0.facebook AS facebook_33,
  t0.youtube AS youtube_34,
  t0.maps AS maps_35,
  t0.banner AS banner_36,
  t0.add_date AS add_date_37,
  t0.maquette AS maquette_38,
  t0.alaune AS alaune_39
FROM
  business_information t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.business_name AS business_name_2, t0.street_address AS street_address_3, t0.state AS state_4, t0.fixe_phone AS fixe_phone_5, t0.fax_number AS fax_number_6, t0.mobile AS mobile_7, t0.email AS email_8, t0.website AS website_9, t0.categories AS categories_10, t0.logo AS logo_11, t0.city AS city_12, t0.description AS description_13, t0.contact_name AS contact_name_14, t0.business_title AS business_title_15, t0.custmer_type AS custmer_type_16, t0.key_words AS key_words_17, t0.general_info AS general_info_18, t0.created_by AS created_by_19, t0.statut AS statut_20, t0.created_date AS created_date_21, t0.company_presentation AS company_presentation_22, t0.year_established AS year_established_23, t0.service_photo_1 AS service_photo_1_24, t0.service_photo_2 AS service_photo_2_25, t0.service_photo_3 AS service_photo_3_26, t0.service_photo_4 AS service_photo_4_27, t0.service_photo_5 AS service_photo_5_28, t0.service_photo_6 AS service_photo_6_29, t0.documentations_catalogs AS documentations_catalogs_30, t0.company_references AS company_references_31, t0.video_entreprise AS video_entreprise_32, t0.facebook AS facebook_33, t0.youtube AS youtube_34, t0.maps AS maps_35, t0.banner AS banner_36, t0.add_date AS add_date_37, t0.maquette AS maquette_38, t0.alaune AS alaune_39 FROM business_information t0 WHERE t0.id = '93237';

"START TRANSACTION"

"START TRANSACTION";

UPDATE
  business_information
SET
  company_presentation = ?,
  service_photo_6 = ?
WHERE
  id = ?

UPDATE business_information SET company_presentation = '<div><strong>SARL SONARIC </strong>est une entreprise nationale algérienne, spécialisé dans la production et la commercialisation des produits électroménagers. elle s’est forgée une solide notoriété dans la fabrication électronique professionnelle, une équipe d’universitaires compétente, un outil industriel moderne, une offre produit / service bien identifiée, bien adapter à notre marché et apte a exporter, car tous nos produits sont aux normes International.&nbsp;<br><br></div><h1><strong>Nos réseaux de distribution :</strong></h1><div><strong>1- Unité centrale technique commerciale (UCTC) wilaya d\'Alger :<br>Adresse : </strong>Route de Baraki BP 240, 16208, Kouba<br>16205, Djasr Kassentina, Alger<strong><br>Tél. : </strong>(023) 93 41 60 / 61 / 62 <br><strong>Fax :</strong> (023) 93 41 97<strong><br>Mob. : </strong>(0555) 06 11 16/28<strong><br>E-mail : </strong>d.uctc@sonaric.dz<br><strong><br>2- Unité de production et commercialisation de Si Mustapha : wilaya de Boumerdès (UCDI) :</strong> <strong><br></strong>Production de cuisinières domestiques, table de cuissons, chauffe-eau/bain et climatiseurs<strong><br>Adresse : </strong>03,<strong> </strong>rue Rabah Teldja, BP 33, 35270, Si Mustapha, Boumerdès<strong><br>Tél. : </strong>(024) 95 58 92/93<br><strong>Fax :</strong> (024) 95 58 91<strong><br>Mob. : </strong>(0555) 06 11 18/30<strong><br>E-mail : </strong>d.ucd@sonaric.dz<br><strong><br>3- Unité commerciale d\'Akbou (UCC) wilaya de Béjaia :<br>Adresse : </strong>Route nationale N°26, zone industrielle, 06200, Akbou, Béjaia<strong><br>Tél. : </strong>(034) 10 65 34<br><strong>Fax :</strong> (034) 10 65 31<strong><br>Mob. : </strong>(0555) 06 11 46/22<strong><br>E-mail : </strong>d.ucc@sonaric.dz <br><strong><br>4- Unité de production et commercialisation de Ferdjioua (URD) : Wilaya de Mila :</strong> <strong><br></strong>Production de radiateur de chauffage NEW WEARM, chaudière et climatiseur<strong><br>Adresse : </strong>BP 76, 43310, Ferdjioua, Mila<strong><br>Tél. : </strong>(031) 45 26 11/13<br><strong>Fax :</strong> (031) 45 26 12<strong><br>Mob. : </strong>(0555) 06 11 43/20<strong><br>E-mail : </strong>d.urd@sonaric.dz <br><strong><br>5- Unité de production et commercialisation de Sidi Akkacha : wilaya de Chlef (UBL) :</strong> <strong><br></strong>Production de radiateurs de chauffage Djurdjura<strong><br>Adresse : </strong>Zone industrielle 02210, Sidi, Akkacha, Chlef <strong><br>Tél. : </strong>(027) 75 07 63/65<br><strong>Fax :</strong> (027) 75 07 64<strong><br>Mob. : </strong>(0555) 06 11 48/21<strong><br>E-mail : </strong>d.ubl@sonaric.dz <br><br><strong>Direction commerciale centrale au niveau de la DG :<br>Mob. : </strong>(0555) 06 11 67/15<strong><br>E-mail : </strong>d.cmmerciale@sonaric.dz<br><br><strong>Cellule d\'écoute au niveau de la DG : 0555 06 11 66</strong></div>', service_photo_6 = NULL WHERE id = 93237;

"COMMIT"

"COMMIT";