| 3 |
2.19 ms |
SELECT p0_.id AS id_0, p0_.prix AS prix_1, p0_.stock AS stock_2, p0_.qte_vendu AS qte_vendu_3, p0_.qte_approvisionne AS qte_approvisionne_4, p0_.qte_retourne AS qte_retourne_5, p0_.nb_reportion AS nb_reportion_6, p0_.stock_en_portion AS stock_en_portion_7, p0_.reference_systeme AS reference_systeme_8, p0_.reference_manuel AS reference_manuel_9, p0_.cree_le AS cree_le_10, p0_.modifie_le AS modifie_le_11, s1_.id AS id_12, s1_.libelle AS libelle_13, s1_.description AS description_14, s1_.image AS image_15, s1_.featured AS featured_16, s1_.image_service AS image_service_17, s1_.slug AS slug_18, s1_.reference_systeme AS reference_systeme_19, s1_.reference_manuel AS reference_manuel_20, s1_.cree_le AS cree_le_21, s1_.modifie_le AS modifie_le_22, p2_.id AS id_23, p2_.libelle AS libelle_24, p2_.prix_ht AS prix_ht_25, p2_.prix_achat AS prix_achat_26, p2_.description AS description_27, p2_.code_barre AS code_barre_28, p2_.code_barre_fournisseur AS code_barre_fournisseur_29, p2_.stock_actuel AS stock_actuel_30, p2_.qte_reapprovissement AS qte_reapprovissement_31, p2_.qte_mini AS qte_mini_32, p2_.qte_vente AS qte_vente_33, p2_.qte_rebus AS qte_rebus_34, p2_.prix_revient AS prix_revient_35, p2_.est_matiere_premiere AS est_matiere_premiere_36, p2_.est_stockable AS est_stockable_37, p2_.est_disponible AS est_disponible_38, p2_.unite AS unite_39, p2_.unite_detail AS unite_detail_40, p2_.nbre_unite AS nbre_unite_41, p2_.stock_alerte AS stock_alerte_42, p2_.reference_systeme AS reference_systeme_43, p2_.reference_manuel AS reference_manuel_44, p2_.cree_le AS cree_le_45, p2_.modifie_le AS modifie_le_46, f3_.id AS id_47, f3_.libelle AS libelle_48, f3_.numero_s AS numero_s_49, f3_.description AS description_50, f3_.supprimer AS supprimer_51, f3_.urlimage AS urlimage_52, f3_.slug AS slug_53, f3_.reference_systeme AS reference_systeme_54, f3_.reference_manuel AS reference_manuel_55, f3_.cree_le AS cree_le_56, f3_.modifie_le AS modifie_le_57, p0_.service_id AS service_id_58, p0_.produit_id AS produit_id_59, p2_.famille_id AS famille_id_60 FROM prix_aapplique p0_ INNER JOIN services s1_ ON p0_.service_id = s1_.id INNER JOIN produit p2_ ON p0_.produit_id = p2_.id INNER JOIN famille f3_ ON p2_.famille_id = f3_.id WHERE p0_.service_id = ?
Parameters: [
b"\x01—»è¿6|u¬6Ú¸ãàŽv"
]
SELECT
p0_.id AS id_0,
p0_.prix AS prix_1,
p0_.stock AS stock_2,
p0_.qte_vendu AS qte_vendu_3,
p0_.qte_approvisionne AS qte_approvisionne_4,
p0_.qte_retourne AS qte_retourne_5,
p0_.nb_reportion AS nb_reportion_6,
p0_.stock_en_portion AS stock_en_portion_7,
p0_.reference_systeme AS reference_systeme_8,
p0_.reference_manuel AS reference_manuel_9,
p0_.cree_le AS cree_le_10,
p0_.modifie_le AS modifie_le_11,
s1_.id AS id_12,
s1_.libelle AS libelle_13,
s1_.description AS description_14,
s1_.image AS image_15,
s1_.featured AS featured_16,
s1_.image_service AS image_service_17,
s1_.slug AS slug_18,
s1_.reference_systeme AS reference_systeme_19,
s1_.reference_manuel AS reference_manuel_20,
s1_.cree_le AS cree_le_21,
s1_.modifie_le AS modifie_le_22,
p2_.id AS id_23,
p2_.libelle AS libelle_24,
p2_.prix_ht AS prix_ht_25,
p2_.prix_achat AS prix_achat_26,
p2_.description AS description_27,
p2_.code_barre AS code_barre_28,
p2_.code_barre_fournisseur AS code_barre_fournisseur_29,
p2_.stock_actuel AS stock_actuel_30,
p2_.qte_reapprovissement AS qte_reapprovissement_31,
p2_.qte_mini AS qte_mini_32,
p2_.qte_vente AS qte_vente_33,
p2_.qte_rebus AS qte_rebus_34,
p2_.prix_revient AS prix_revient_35,
p2_.est_matiere_premiere AS est_matiere_premiere_36,
p2_.est_stockable AS est_stockable_37,
p2_.est_disponible AS est_disponible_38,
p2_.unite AS unite_39,
p2_.unite_detail AS unite_detail_40,
p2_.nbre_unite AS nbre_unite_41,
p2_.stock_alerte AS stock_alerte_42,
p2_.reference_systeme AS reference_systeme_43,
p2_.reference_manuel AS reference_manuel_44,
p2_.cree_le AS cree_le_45,
p2_.modifie_le AS modifie_le_46,
f3_.id AS id_47,
f3_.libelle AS libelle_48,
f3_.numero_s AS numero_s_49,
f3_.description AS description_50,
f3_.supprimer AS supprimer_51,
f3_.urlimage AS urlimage_52,
f3_.slug AS slug_53,
f3_.reference_systeme AS reference_systeme_54,
f3_.reference_manuel AS reference_manuel_55,
f3_.cree_le AS cree_le_56,
f3_.modifie_le AS modifie_le_57,
p0_.service_id AS service_id_58,
p0_.produit_id AS produit_id_59,
p2_.famille_id AS famille_id_60
FROM
prix_aapplique p0_
INNER JOIN services s1_ ON p0_.service_id = s1_.id
INNER JOIN produit p2_ ON p0_.produit_id = p2_.id
INNER JOIN famille f3_ ON p2_.famille_id = f3_.id
WHERE
p0_.service_id = ?
SELECT p0_.id AS id_0, p0_.prix AS prix_1, p0_.stock AS stock_2, p0_.qte_vendu AS qte_vendu_3, p0_.qte_approvisionne AS qte_approvisionne_4, p0_.qte_retourne AS qte_retourne_5, p0_.nb_reportion AS nb_reportion_6, p0_.stock_en_portion AS stock_en_portion_7, p0_.reference_systeme AS reference_systeme_8, p0_.reference_manuel AS reference_manuel_9, p0_.cree_le AS cree_le_10, p0_.modifie_le AS modifie_le_11, s1_.id AS id_12, s1_.libelle AS libelle_13, s1_.description AS description_14, s1_.image AS image_15, s1_.featured AS featured_16, s1_.image_service AS image_service_17, s1_.slug AS slug_18, s1_.reference_systeme AS reference_systeme_19, s1_.reference_manuel AS reference_manuel_20, s1_.cree_le AS cree_le_21, s1_.modifie_le AS modifie_le_22, p2_.id AS id_23, p2_.libelle AS libelle_24, p2_.prix_ht AS prix_ht_25, p2_.prix_achat AS prix_achat_26, p2_.description AS description_27, p2_.code_barre AS code_barre_28, p2_.code_barre_fournisseur AS code_barre_fournisseur_29, p2_.stock_actuel AS stock_actuel_30, p2_.qte_reapprovissement AS qte_reapprovissement_31, p2_.qte_mini AS qte_mini_32, p2_.qte_vente AS qte_vente_33, p2_.qte_rebus AS qte_rebus_34, p2_.prix_revient AS prix_revient_35, p2_.est_matiere_premiere AS est_matiere_premiere_36, p2_.est_stockable AS est_stockable_37, p2_.est_disponible AS est_disponible_38, p2_.unite AS unite_39, p2_.unite_detail AS unite_detail_40, p2_.nbre_unite AS nbre_unite_41, p2_.stock_alerte AS stock_alerte_42, p2_.reference_systeme AS reference_systeme_43, p2_.reference_manuel AS reference_manuel_44, p2_.cree_le AS cree_le_45, p2_.modifie_le AS modifie_le_46, f3_.id AS id_47, f3_.libelle AS libelle_48, f3_.numero_s AS numero_s_49, f3_.description AS description_50, f3_.supprimer AS supprimer_51, f3_.urlimage AS urlimage_52, f3_.slug AS slug_53, f3_.reference_systeme AS reference_systeme_54, f3_.reference_manuel AS reference_manuel_55, f3_.cree_le AS cree_le_56, f3_.modifie_le AS modifie_le_57, p0_.service_id AS service_id_58, p0_.produit_id AS produit_id_59, p2_.famille_id AS famille_id_60 FROM prix_aapplique p0_ INNER JOIN services s1_ ON p0_.service_id = s1_.id INNER JOIN produit p2_ ON p0_.produit_id = p2_.id INNER JOIN famille f3_ ON p2_.famille_id = f3_.id WHERE p0_.service_id = 0x0197BBE8BF367C75AC36DAB8E3E08E76;
|