3.54 ms (34.76%)
|
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.logo AS logo_3, t0.siret AS siret_4, t0.tva AS tva_5, t0.phone AS phone_6, t0.siren AS siren_7, t0.nic AS nic_8, t0.cat_juridique AS cat_juridique_9, t0.denomination AS denomination_10, t0.activite_principal AS activite_principal_11, t0.address1 AS address1_12, t0.address2 AS address2_13, t0.zip_code AS zip_code_14, t0.city AS city_15, t0.frequency AS frequency_16, t0.iban AS iban_17, t0.bic AS bic_18, t0.mandate_id AS mandate_id_19, t0.mandate_date AS mandate_date_20, t0.offer_value AS offer_value_21, t0.societe_old_id AS societe_old_id_22, t0.tirelire AS tirelire_23, t0.abondement AS abondement_24, t0.subdomain AS subdomain_25, t0.color_primary AS color_primary_26, t0.color_secondary AS color_secondary_27, t0.contract_date AS contract_date_28, t0.date_abondement AS date_abondement_29, t0.bans AS bans_30, t0.bans_sg AS bans_sg_31, t0.card_price AS card_price_32, t0.wallet_id AS wallet_id_33, t0.start_contract AS start_contract_34, t0.contract_duration AS contract_duration_35, t0.renewal_year AS renewal_year_36, t0.months_notice AS months_notice_37, t0.date_cancellation AS date_cancellation_38, t0.theoretical_end_contract AS theoretical_end_contract_39, t0.end_contract_renewal AS end_contract_renewal_40, t0.date_request_cancellation AS date_request_cancellation_41, t0.benefeciary_id AS benefeciary_id_42, t0.offer_id AS offer_id_43, t0.salesperson_id AS salesperson_id_44, t0.departement_id AS departement_id_45, t46.id AS id_47, t46.bic AS bic_48, t46.iban AS iban_49, t46.company_id_id AS company_id_id_50, t0.debit_bank_id AS debit_bank_id_51 FROM company t0 LEFT JOIN company_treezor_wallet t46 ON t46.company_id_id = t0.id WHERE t0.subdomain = ? LIMIT 1
Parameters: [
"developpement"
]
SELECT
t0.id AS id_1,
t0.name AS name_2,
t0.logo AS logo_3,
t0.siret AS siret_4,
t0.tva AS tva_5,
t0.phone AS phone_6,
t0.siren AS siren_7,
t0.nic AS nic_8,
t0.cat_juridique AS cat_juridique_9,
t0.denomination AS denomination_10,
t0.activite_principal AS activite_principal_11,
t0.address1 AS address1_12,
t0.address2 AS address2_13,
t0.zip_code AS zip_code_14,
t0.city AS city_15,
t0.frequency AS frequency_16,
t0.iban AS iban_17,
t0.bic AS bic_18,
t0.mandate_id AS mandate_id_19,
t0.mandate_date AS mandate_date_20,
t0.offer_value AS offer_value_21,
t0.societe_old_id AS societe_old_id_22,
t0.tirelire AS tirelire_23,
t0.abondement AS abondement_24,
t0.subdomain AS subdomain_25,
t0.color_primary AS color_primary_26,
t0.color_secondary AS color_secondary_27,
t0.contract_date AS contract_date_28,
t0.date_abondement AS date_abondement_29,
t0.bans AS bans_30,
t0.bans_sg AS bans_sg_31,
t0.card_price AS card_price_32,
t0.wallet_id AS wallet_id_33,
t0.start_contract AS start_contract_34,
t0.contract_duration AS contract_duration_35,
t0.renewal_year AS renewal_year_36,
t0.months_notice AS months_notice_37,
t0.date_cancellation AS date_cancellation_38,
t0.theoretical_end_contract AS theoretical_end_contract_39,
t0.end_contract_renewal AS end_contract_renewal_40,
t0.date_request_cancellation AS date_request_cancellation_41,
t0.benefeciary_id AS benefeciary_id_42,
t0.offer_id AS offer_id_43,
t0.salesperson_id AS salesperson_id_44,
t0.departement_id AS departement_id_45,
t46.id AS id_47,
t46.bic AS bic_48,
t46.iban AS iban_49,
t46.company_id_id AS company_id_id_50,
t0.debit_bank_id AS debit_bank_id_51
FROM
company t0
LEFT JOIN company_treezor_wallet t46 ON t46.company_id_id = t0.id
WHERE
t0.subdomain = ?
LIMIT
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.logo AS logo_3, t0.siret AS siret_4, t0.tva AS tva_5, t0.phone AS phone_6, t0.siren AS siren_7, t0.nic AS nic_8, t0.cat_juridique AS cat_juridique_9, t0.denomination AS denomination_10, t0.activite_principal AS activite_principal_11, t0.address1 AS address1_12, t0.address2 AS address2_13, t0.zip_code AS zip_code_14, t0.city AS city_15, t0.frequency AS frequency_16, t0.iban AS iban_17, t0.bic AS bic_18, t0.mandate_id AS mandate_id_19, t0.mandate_date AS mandate_date_20, t0.offer_value AS offer_value_21, t0.societe_old_id AS societe_old_id_22, t0.tirelire AS tirelire_23, t0.abondement AS abondement_24, t0.subdomain AS subdomain_25, t0.color_primary AS color_primary_26, t0.color_secondary AS color_secondary_27, t0.contract_date AS contract_date_28, t0.date_abondement AS date_abondement_29, t0.bans AS bans_30, t0.bans_sg AS bans_sg_31, t0.card_price AS card_price_32, t0.wallet_id AS wallet_id_33, t0.start_contract AS start_contract_34, t0.contract_duration AS contract_duration_35, t0.renewal_year AS renewal_year_36, t0.months_notice AS months_notice_37, t0.date_cancellation AS date_cancellation_38, t0.theoretical_end_contract AS theoretical_end_contract_39, t0.end_contract_renewal AS end_contract_renewal_40, t0.date_request_cancellation AS date_request_cancellation_41, t0.benefeciary_id AS benefeciary_id_42, t0.offer_id AS offer_id_43, t0.salesperson_id AS salesperson_id_44, t0.departement_id AS departement_id_45, t46.id AS id_47, t46.bic AS bic_48, t46.iban AS iban_49, t46.company_id_id AS company_id_id_50, t0.debit_bank_id AS debit_bank_id_51 FROM company t0 LEFT JOIN company_treezor_wallet t46 ON t46.company_id_id = t0.id WHERE t0.subdomain = 'developpement' LIMIT 1;
|