2.23 ms (32.15%)
9
SELECT t0 . photo AS photo_1 , t0 . PrixHT AS PrixHT_2 , t0 . QteReappro AS QteReappro_3 , t0 . QteMini AS QteMini_4 , t0 . TauxTVA AS TauxTVA_5 , t0 . GenCode AS GenCode_6 , t0 . CodeBarre AS CodeBarre_7 , t0 . SaisiPar AS SaisiPar_8 , t0 . SaisiLe AS SaisiLe_9 , t0 . Observations AS Observations_10 , t0 . AIB AS AIB_11 , t0 . stockActuel AS stockActuel_12 , t0 . ID AS ID_13 , t0 . proFamille AS proFamille_14 , t0 . LibProd AS LibProd_15 , t0 . Description AS Description_16 , t0 . assujettiTVA AS assujettiTVA_17 , t0 . assujettiAIB AS assujettiAIB_18 , t0 . IDSOCIETE AS IDSOCIETE_19 , t0 . IDAnnee AS IDAnnee_20 , t0 . referenceInexistante AS referenceInexistante_21 , t0 . codebare AS codebare_22 , t0 . QTEAPPRO AS QTEAPPRO_23 , t0 . QteVente AS QteVente_24 , t0 . QteRebus AS QteRebus_25 , t0 . LibFamille AS LibFamille_26 , t0 . LibProdV AS LibProdV_27 , t0 . PrixRevient AS PrixRevient_28 , t0 . Marge AS Marge_29 , t0 . NIM_Facture_Preuve AS NIM_Facture_Preuve_30 , t0 . Signature_Facure_Preuve AS Signature_Facure_Preuve_31 , t0 . PTVA_Marge AS PTVA_Marge_32 , t0 . PTVA_HT AS PTVA_HT_33 , t0 . estMatieresPremiere AS estMatieresPremiere_34 , t0 . estStockable AS estStockable_35 , t0 . estdisponible AS estdisponible_36 , t0 . Reference AS Reference_37 , t0 . feat AS feat_38 , t0 . CodeFamille AS CodeFamille_39 FROM produit t0 WHERE t0 . ID = ?
Parameters :
[
"P0000004 "
]
SELECT t0 . photo AS photo_1 , t0 . PrixHT AS PrixHT_2 , t0 . QteReappro AS QteReappro_3 , t0 . QteMini AS QteMini_4 , t0 . TauxTVA AS TauxTVA_5 , t0 . GenCode AS GenCode_6 , t0 . CodeBarre AS CodeBarre_7 , t0 . SaisiPar AS SaisiPar_8 , t0 . SaisiLe AS SaisiLe_9 , t0 . Observations AS Observations_10 , t0 . AIB AS AIB_11 , t0 . stockActuel AS stockActuel_12 , t0 . ID AS ID_13 , t0 . proFamille AS proFamille_14 , t0 . LibProd AS LibProd_15 , t0 . Description AS Description_16 , t0 . assujettiTVA AS assujettiTVA_17 , t0 . assujettiAIB AS assujettiAIB_18 , t0 . IDSOCIETE AS IDSOCIETE_19 , t0 . IDAnnee AS IDAnnee_20 , t0 . referenceInexistante AS referenceInexistante_21 , t0 . codebare AS codebare_22 , t0 . QTEAPPRO AS QTEAPPRO_23 , t0 . QteVente AS QteVente_24 , t0 . QteRebus AS QteRebus_25 , t0 . LibFamille AS LibFamille_26 , t0 . LibProdV AS LibProdV_27 , t0 . PrixRevient AS PrixRevient_28 , t0 . Marge AS Marge_29 , t0 . NIM_Facture_Preuve AS NIM_Facture_Preuve_30 , t0 . Signature_Facure_Preuve AS Signature_Facure_Preuve_31 , t0 . PTVA_Marge AS PTVA_Marge_32 , t0 . PTVA_HT AS PTVA_HT_33 , t0 . estMatieresPremiere AS estMatieresPremiere_34 , t0 . estStockable AS estStockable_35 , t0 . estdisponible AS estdisponible_36 , t0 . Reference AS Reference_37 , t0 . feat AS feat_38 , t0 . CodeFamille AS CodeFamille_39 FROM produit t0 WHERE t0 . ID = 'P0000004' ;
Copy
0.75 ms (10.75%)
1
SELECT p0_ . codeprix_applique AS codeprix_applique_0 , p0_ . codeservices AS codeservices_1 , p0_ . prix AS prix_2 , p0_ . stock AS stock_3 , p0_ . qteVendu AS qteVendu_4 , p0_ . qteapprovisionne AS qteapprovisionne_5 , p0_ . qteretourne AS qteretourne_6 , p0_ . ID AS ID_7 , p0_ . codeservices AS codeservices_8 FROM Prix_A_Appliquer p0_ INNER JOIN produit p1_ ON p0_ . ID = p1_ . ID INNER JOIN images_produits i2_ ON p1_ . ID = i2_ . produit_id INNER JOIN famille f3_ ON p1_ . CodeFamille = f3_ . CodeFamille WHERE f3_ . numeroS NOT IN (5 , 2 , 3 ) AND p1_ . feat = 1 LIMIT 6
SELECT p0_ . codeprix_applique AS codeprix_applique_0 , p0_ . codeservices AS codeservices_1 , p0_ . prix AS prix_2 , p0_ . stock AS stock_3 , p0_ . qteVendu AS qteVendu_4 , p0_ . qteapprovisionne AS qteapprovisionne_5 , p0_ . qteretourne AS qteretourne_6 , p0_ . ID AS ID_7 , p0_ . codeservices AS codeservices_8 FROM Prix_A_Appliquer p0_ INNER JOIN produit p1_ ON p0_ . ID = p1_ . ID INNER JOIN images_produits i2_ ON p1_ . ID = i2_ . produit_id INNER JOIN famille f3_ ON p1_ . CodeFamille = f3_ . CodeFamille WHERE f3_ . numeroS NOT IN (5 , 2 , 3 ) AND p1_ . feat = 1 LIMIT 6 ;
Copy
0.48 ms (6.97%)
1
SELECT p0_ . codeprix_applique AS codeprix_applique_0 , p0_ . codeservices AS codeservices_1 , p0_ . prix AS prix_2 , p0_ . stock AS stock_3 , p0_ . qteVendu AS qteVendu_4 , p0_ . qteapprovisionne AS qteapprovisionne_5 , p0_ . qteretourne AS qteretourne_6 , p0_ . ID AS ID_7 , p0_ . codeservices AS codeservices_8 FROM Prix_A_Appliquer p0_ INNER JOIN produit p1_ ON p0_ . ID = p1_ . ID INNER JOIN famille f2_ ON p1_ . CodeFamille = f2_ . CodeFamille INNER JOIN services s3_ ON p0_ . codeservices = s3_ . codeservices WHERE s3_ . codeservices = ? AND p1_ . feat = 1 LIMIT 5
Parameters :
[
"S0000011 "
]
SELECT p0_ . codeprix_applique AS codeprix_applique_0 , p0_ . codeservices AS codeservices_1 , p0_ . prix AS prix_2 , p0_ . stock AS stock_3 , p0_ . qteVendu AS qteVendu_4 , p0_ . qteapprovisionne AS qteapprovisionne_5 , p0_ . qteretourne AS qteretourne_6 , p0_ . ID AS ID_7 , p0_ . codeservices AS codeservices_8 FROM Prix_A_Appliquer p0_ INNER JOIN produit p1_ ON p0_ . ID = p1_ . ID INNER JOIN famille f2_ ON p1_ . CodeFamille = f2_ . CodeFamille INNER JOIN services s3_ ON p0_ . codeservices = s3_ . codeservices WHERE s3_ . codeservices = 'S0000011' AND p1_ . feat = 1 LIMIT 5 ;
Copy