Query Metrics
29
Database Queries
14
Different statements
33.67 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
18.45 ms (54.80%) |
1 |
SELECT u0_.id AS id_0, u0_.email AS email_1, u0_.roles AS roles_2, u0_.specialCustomer AS specialCustomer_3, u0_.generatePasswordRecovery AS generatePasswordRecovery_4, u0_.resetToken AS resetToken_5, u0_.resetTokenExpiresAt AS resetTokenExpiresAt_6, u0_.additionalPercentage AS additionalPercentage_7, u0_.name AS name_8, u0_.firstName AS firstName_9, u0_.address AS address_10, u0_.postal AS postal_11, u0_.locality AS locality_12, u0_.country AS country_13, u0_.phoneNumber AS phoneNumber_14, u0_.directPhone AS directPhone_15, u0_.otherMail AS otherMail_16, u0_.companyName AS companyName_17, u0_.active AS active_18, u0_.gender AS gender_19, u0_.userSupplementsPurchaseDecisionMaker AS userSupplementsPurchaseDecisionMaker_20, u0_.password AS password_21, a1_.id AS id_22, a1_.generalCondition AS generalCondition_23, a1_.storeSize AS storeSize_24, a1_.idClientMercator AS idClientMercator_25, a1_.customerCategoryMercator AS customerCategoryMercator_26, a1_.mercatorBE AS mercatorBE_27, a1_.mercatorLU AS mercatorLU_28, a1_.salesAreaForFoodSupplements AS salesAreaForFoodSupplements_29, a1_.companyAddress AS companyAddress_30, a1_.companyTypePro AS companyTypePro_31, a1_.ibanrib AS ibanrib_32, a1_.companyPostal AS companyPostal_33, a1_.townAddressCompany AS townAddressCompany_34, a1_.companyCountry AS companyCountry_35, a1_.ribPdf AS ribPdf_36, a1_.companyRibValidate AS companyRibValidate_37, a1_.legalForm AS legalForm_38, a1_.sirenNumber AS sirenNumber_39, a1_.siretNumber AS siretNumber_40, a1_.tva AS tva_41, a1_.rcs AS rcs_42, a1_.companyWebsite AS companyWebsite_43, a1_.companyName AS companyName_44, a1_.accountantGender AS accountantGender_45, a1_.accountantFirstName AS accountantFirstName_46, a1_.accountantLastName AS accountantLastName_47, a1_.accountantPhone AS accountantPhone_48, a1_.accountantMobilePhone AS accountantMobilePhone_49, a1_.accountantSupplementsPurchaseDecisionMaker AS accountantSupplementsPurchaseDecisionMaker_50, a1_.accountantEmail AS accountantEmail_51, a1_.therapistGender AS therapistGender_52, a1_.therapistFirstName AS therapistFirstName_53, a1_.therapistLastName AS therapistLastName_54, a1_.therapistPhone AS therapistPhone_55, a1_.therapistMobilePhone AS therapistMobilePhone_56, a1_.therapistEmail AS therapistEmail_57, a1_.therapistSupplementsPurchaseDecisionMaker AS therapistSupplementsPurchaseDecisionMaker_58, a1_.ceoGender AS ceoGender_59, a1_.ceoFirstName AS ceoFirstName_60, a1_.ceoLastName AS ceoLastName_61, a1_.ceoPhone AS ceoPhone_62, a1_.ceoMobilePhone AS ceoMobilePhone_63, a1_.ceoEmail AS ceoEmail_64, a1_.ceoSupplementsPurchaseDecisionMaker AS ceoSupplementsPurchaseDecisionMaker_65, d2_.id AS id_66, d2_.companyName AS companyName_67, d2_.name AS name_68, d2_.firstName AS firstName_69, d2_.address AS address_70, d2_.postal AS postal_71, d2_.town AS town_72, d2_.country AS country_73, d2_.phoneNumber AS phoneNumber_74, d2_.monday AS monday_75, d2_.morningMonday AS morningMonday_76, d2_.morningMondayEnd AS morningMondayEnd_77, d2_.afternoonMonday AS afternoonMonday_78, d2_.afternoonMondayEnd AS afternoonMondayEnd_79, d2_.tuesday AS tuesday_80, d2_.morningTuesday AS morningTuesday_81, d2_.morningTuesdayEnd AS morningTuesdayEnd_82, d2_.afternoonTuesday AS afternoonTuesday_83, d2_.afternoonTuesdayEnd AS afternoonTuesdayEnd_84, d2_.wednesday AS wednesday_85, d2_.morningWednesday AS morningWednesday_86, d2_.morningWednesdayEnd AS morningWednesdayEnd_87, d2_.afternoonWednesday AS afternoonWednesday_88, d2_.afternoonWednesdayEnd AS afternoonWednesdayEnd_89, d2_.thursday AS thursday_90, d2_.morningThursday AS morningThursday_91, d2_.morningThursdayEnd AS morningThursdayEnd_92, d2_.afternoonThursday AS afternoonThursday_93, d2_.afternoonThursdayeEnd AS afternoonThursdayeEnd_94, d2_.friday AS friday_95, d2_.morningFriday AS morningFriday_96, d2_.morningFridayEnd AS morningFridayEnd_97, d2_.afternoonFriday AS afternoonFriday_98, d2_.afternoonFridayEnd AS afternoonFridayEnd_99, d2_.saturday AS saturday_100, d2_.morningSaturday AS morningSaturday_101, d2_.morningSaturdayEnd AS morningSaturdayEnd_102, d2_.afternoonSaturday AS afternoonSaturday_103, d2_.afternoonSaturdayEnd AS afternoonSaturdayEnd_104, d2_.sunday AS sunday_105, d2_.morningSunday AS morningSunday_106, d2_.morningSundayEnd AS morningSundayEnd_107, d2_.afternoonSunday AS afternoonSunday_108, d2_.afternoonSundayEnd AS afternoonSundayEnd_109, d2_.hourlyMonday AS hourlyMonday_110, d2_.hourlyMorningMonday AS hourlyMorningMonday_111, d2_.hourlyMorningMondayEnd AS hourlyMorningMondayEnd_112, d2_.hourlyTuesday AS hourlyTuesday_113, d2_.hourlyMorningTuesday AS hourlyMorningTuesday_114, d2_.hourlyMorningTuesdayEnd AS hourlyMorningTuesdayEnd_115, d2_.hourlyWednesday AS hourlyWednesday_116, d2_.hourlyMorningWednesday AS hourlyMorningWednesday_117, d2_.hourlyMorningWednesdayEnd AS hourlyMorningWednesdayEnd_118, d2_.hourlyThursday AS hourlyThursday_119, d2_.hourlyMorningThursday AS hourlyMorningThursday_120, d2_.hourlyMorningThursdayEnd AS hourlyMorningThursdayEnd_121, d2_.hourlyFriday AS hourlyFriday_122, d2_.hourlyMorningFriday AS hourlyMorningFriday_123, d2_.hourlyMorningFridayEnd AS hourlyMorningFridayEnd_124, d2_.hourlySaturday AS hourlySaturday_125, d2_.hourlyMorningSaturday AS hourlyMorningSaturday_126, d2_.hourlyMorningSaturdayEnd AS hourlyMorningSaturdayEnd_127, d2_.hourlySunday AS hourlySunday_128, d2_.hourlyMorningSunday AS hourlyMorningSunday_129, d2_.hourlyMorningSundayEnd AS hourlyMorningSundayEnd_130, t3_.id AS id_131, t3_.tvaNumber AS tvaNumber_132 FROM user u0_ LEFT JOIN additional_company_information a1_ ON u0_.id = a1_.user_id LEFT JOIN delivery_address d2_ ON u0_.id = d2_.user_id LEFT JOIN tva t3_ ON u0_.id = t3_.client_id
Parameters:
[] |
|
4.97 ms (14.77%) |
10 |
SELECT t0.id AS id_1, t0.generalCondition AS generalCondition_2, t0.storeSize AS storeSize_3, t0.idClientMercator AS idClientMercator_4, t0.customerCategoryMercator AS customerCategoryMercator_5, t0.mercatorBE AS mercatorBE_6, t0.mercatorLU AS mercatorLU_7, t0.salesAreaForFoodSupplements AS salesAreaForFoodSupplements_8, t0.companyAddress AS companyAddress_9, t0.companyTypePro AS companyTypePro_10, t0.ibanrib AS ibanrib_11, t0.companyPostal AS companyPostal_12, t0.townAddressCompany AS townAddressCompany_13, t0.companyCountry AS companyCountry_14, t0.ribPdf AS ribPdf_15, t0.companyRibValidate AS companyRibValidate_16, t0.legalForm AS legalForm_17, t0.sirenNumber AS sirenNumber_18, t0.siretNumber AS siretNumber_19, t0.tva AS tva_20, t0.rcs AS rcs_21, t0.companyWebsite AS companyWebsite_22, t0.companyName AS companyName_23, t0.accountantGender AS accountantGender_24, t0.accountantFirstName AS accountantFirstName_25, t0.accountantLastName AS accountantLastName_26, t0.accountantPhone AS accountantPhone_27, t0.accountantMobilePhone AS accountantMobilePhone_28, t0.accountantSupplementsPurchaseDecisionMaker AS accountantSupplementsPurchaseDecisionMaker_29, t0.accountantEmail AS accountantEmail_30, t0.therapistGender AS therapistGender_31, t0.therapistFirstName AS therapistFirstName_32, t0.therapistLastName AS therapistLastName_33, t0.therapistPhone AS therapistPhone_34, t0.therapistMobilePhone AS therapistMobilePhone_35, t0.therapistEmail AS therapistEmail_36, t0.therapistSupplementsPurchaseDecisionMaker AS therapistSupplementsPurchaseDecisionMaker_37, t0.ceoGender AS ceoGender_38, t0.ceoFirstName AS ceoFirstName_39, t0.ceoLastName AS ceoLastName_40, t0.ceoPhone AS ceoPhone_41, t0.ceoMobilePhone AS ceoMobilePhone_42, t0.ceoEmail AS ceoEmail_43, t0.ceoSupplementsPurchaseDecisionMaker AS ceoSupplementsPurchaseDecisionMaker_44, t0.user_id AS user_id_45, t46.id AS id_47, t46.email AS email_48, t46.roles AS roles_49, t46.specialCustomer AS specialCustomer_50, t46.generatePasswordRecovery AS generatePasswordRecovery_51, t46.resetToken AS resetToken_52, t46.resetTokenExpiresAt AS resetTokenExpiresAt_53, t46.additionalPercentage AS additionalPercentage_54, t46.name AS name_55, t46.firstName AS firstName_56, t46.address AS address_57, t46.postal AS postal_58, t46.locality AS locality_59, t46.country AS country_60, t46.phoneNumber AS phoneNumber_61, t46.directPhone AS directPhone_62, t46.otherMail AS otherMail_63, t46.companyName AS companyName_64, t46.active AS active_65, t46.gender AS gender_66, t46.userSupplementsPurchaseDecisionMaker AS userSupplementsPurchaseDecisionMaker_67, t46.password AS password_68 FROM additional_company_information t0 LEFT JOIN user t46 ON t0.user_id = t46.id WHERE t0.user_id = ?
Parameters:
[
779
]
|
|
1.64 ms (4.87%) |
1 |
SELECT DISTINCT c0_.id AS id_0, c0_.commandDate AS commandDate_1 FROM cart_finished c0_ LEFT JOIN user u1_ ON c0_.user_id = u1_.id ORDER BY c0_.commandDate DESC LIMIT 20
Parameters:
[] |
|
1.20 ms (3.55%) |
3 |
SELECT t0.id AS id_1, t0.finish AS finish_2, t0.user_id AS user_id_3, t0.customer_id AS customer_id_4 FROM customer_control t0 WHERE t0.user_id = ? AND t0.finish = ? LIMIT 1
Parameters:
[ 10 0 ] |
|
1.17 ms (3.47%) |
2 |
SELECT t0.id AS id_1, t0.generalCondition AS generalCondition_2, t0.storeSize AS storeSize_3, t0.idClientMercator AS idClientMercator_4, t0.customerCategoryMercator AS customerCategoryMercator_5, t0.mercatorBE AS mercatorBE_6, t0.mercatorLU AS mercatorLU_7, t0.salesAreaForFoodSupplements AS salesAreaForFoodSupplements_8, t0.companyAddress AS companyAddress_9, t0.companyTypePro AS companyTypePro_10, t0.ibanrib AS ibanrib_11, t0.companyPostal AS companyPostal_12, t0.townAddressCompany AS townAddressCompany_13, t0.companyCountry AS companyCountry_14, t0.ribPdf AS ribPdf_15, t0.companyRibValidate AS companyRibValidate_16, t0.legalForm AS legalForm_17, t0.sirenNumber AS sirenNumber_18, t0.siretNumber AS siretNumber_19, t0.tva AS tva_20, t0.rcs AS rcs_21, t0.companyWebsite AS companyWebsite_22, t0.companyName AS companyName_23, t0.accountantGender AS accountantGender_24, t0.accountantFirstName AS accountantFirstName_25, t0.accountantLastName AS accountantLastName_26, t0.accountantPhone AS accountantPhone_27, t0.accountantMobilePhone AS accountantMobilePhone_28, t0.accountantSupplementsPurchaseDecisionMaker AS accountantSupplementsPurchaseDecisionMaker_29, t0.accountantEmail AS accountantEmail_30, t0.therapistGender AS therapistGender_31, t0.therapistFirstName AS therapistFirstName_32, t0.therapistLastName AS therapistLastName_33, t0.therapistPhone AS therapistPhone_34, t0.therapistMobilePhone AS therapistMobilePhone_35, t0.therapistEmail AS therapistEmail_36, t0.therapistSupplementsPurchaseDecisionMaker AS therapistSupplementsPurchaseDecisionMaker_37, t0.ceoGender AS ceoGender_38, t0.ceoFirstName AS ceoFirstName_39, t0.ceoLastName AS ceoLastName_40, t0.ceoPhone AS ceoPhone_41, t0.ceoMobilePhone AS ceoMobilePhone_42, t0.ceoEmail AS ceoEmail_43, t0.ceoSupplementsPurchaseDecisionMaker AS ceoSupplementsPurchaseDecisionMaker_44, t0.user_id AS user_id_45, t46.id AS id_47, t46.email AS email_48, t46.roles AS roles_49, t46.specialCustomer AS specialCustomer_50, t46.generatePasswordRecovery AS generatePasswordRecovery_51, t46.resetToken AS resetToken_52, t46.resetTokenExpiresAt AS resetTokenExpiresAt_53, t46.additionalPercentage AS additionalPercentage_54, t46.name AS name_55, t46.firstName AS firstName_56, t46.address AS address_57, t46.postal AS postal_58, t46.locality AS locality_59, t46.country AS country_60, t46.phoneNumber AS phoneNumber_61, t46.directPhone AS directPhone_62, t46.otherMail AS otherMail_63, t46.companyName AS companyName_64, t46.active AS active_65, t46.gender AS gender_66, t46.userSupplementsPurchaseDecisionMaker AS userSupplementsPurchaseDecisionMaker_67, t46.password AS password_68 FROM additional_company_information t0 LEFT JOIN user t46 ON t0.user_id = t46.id WHERE t0.user_id = ? LIMIT 1
Parameters:
[
10
]
|
|
1.08 ms (3.20%) |
3 |
SELECT r0_.id AS id_0, r0_.min AS min_1, r0_.max AS max_2, r0_.pourcentRebate AS pourcentRebate_3, r0_.status AS status_4, r0_.excluded_products AS excluded_products_5, r0_.specific_products AS specific_products_6 FROM rebate r0_ WHERE r0_.status = 1 AND r0_.specific_products IS NULL ORDER BY r0_.min DESC
Parameters:
[] |
|
1.05 ms (3.12%) |
2 |
SELECT t0.id AS id_1, t0.finish AS finish_2, t0.commandNumber AS commandNumber_3, t0.quantity AS quantity_4, t0.message AS message_5, t0.user_id AS user_id_6, t0.products_id AS products_id_7, t8.id AS id_9, t8.nameFr AS nameFr_10, t8.nameBe AS nameBe_11, t8.description AS description_12, t8.price AS price_13, t8.pricePharmacy AS pricePharmacy_14, t8.capacity AS capacity_15, t8.quantity AS quantity_16, t8.useCouncil AS useCouncil_17, t8.contraindication AS contraindication_18, t8.ingredient AS ingredient_19, t8.nutritionChart AS nutritionChart_20, t8.image AS image_21, t8.status AS status_22, t8.tools AS tools_23, t8.publicPrice AS publicPrice_24, t8.publicPriceHtva AS publicPriceHtva_25, t8.consumptionTime AS consumptionTime_26, t8.brand AS brand_27, t8.idOnNaturaSite AS idOnNaturaSite_28, t8.idProductFeatureOnNatura AS idProductFeatureOnNatura_29, t8.idProductOnMercator AS idProductOnMercator_30, t8.reference AS reference_31, t8.idStockAvailables AS idStockAvailables_32, t8.cnk AS cnk_33, t8.nut AS nut_34, t8.ean AS ean_35, t8.eanImage AS eanImage_36, t8.eanImageBase64 AS eanImageBase64_37, t8.tvaBe AS tvaBe_38, t8.tvaFr AS tvaFr_39, t8.tvaLu AS tvaLu_40, t8.saleFr AS saleFr_41, t8.saleBe AS saleBe_42, t8.saleLux AS saleLux_43, t8.actionShock AS actionShock_44 FROM cart t0 LEFT JOIN products t8 ON t0.products_id = t8.id WHERE t0.user_id = ? AND t0.finish = ?
Parameters:
[ 10 0 ] |
|
0.74 ms (2.21%) |
1 |
SELECT COUNT(DISTINCT c0_.id) AS sclr_0 FROM cart_finished c0_ LEFT JOIN user u1_ ON c0_.user_id = u1_.id
Parameters:
[] |
|
0.63 ms (1.87%) |
1 |
SELECT c0_.id AS id_0, c0_.commandId AS commandId_1, c0_.commandDate AS commandDate_2, c0_.totalPaid AS totalPaid_3, c0_.totalPriceWithNoReduction AS totalPriceWithNoReduction_4, c0_.totalPriceProductLowVatHtva AS totalPriceProductLowVatHtva_5, c0_.totalPriceProductHighVatHtva AS totalPriceProductHighVatHtva_6, c0_.totalPriceProductLowVatTvac AS totalPriceProductLowVatTvac_7, c0_.totalPriceProductHighVatTvac AS totalPriceProductHighVatTvac_8, c0_.totalPriceAllProductHtva AS totalPriceAllProductHtva_9, c0_.totalPriceTvacWithRebate AS totalPriceTvacWithRebate_10, c0_.totalRebate AS totalRebate_11, c0_.pourcentRebate AS pourcentRebate_12, c0_.usedJoker AS usedJoker_13, u1_.id AS id_14, u1_.email AS email_15, u1_.roles AS roles_16, u1_.specialCustomer AS specialCustomer_17, u1_.generatePasswordRecovery AS generatePasswordRecovery_18, u1_.resetToken AS resetToken_19, u1_.resetTokenExpiresAt AS resetTokenExpiresAt_20, u1_.additionalPercentage AS additionalPercentage_21, u1_.name AS name_22, u1_.firstName AS firstName_23, u1_.address AS address_24, u1_.postal AS postal_25, u1_.locality AS locality_26, u1_.country AS country_27, u1_.phoneNumber AS phoneNumber_28, u1_.directPhone AS directPhone_29, u1_.otherMail AS otherMail_30, u1_.companyName AS companyName_31, u1_.active AS active_32, u1_.gender AS gender_33, u1_.userSupplementsPurchaseDecisionMaker AS userSupplementsPurchaseDecisionMaker_34, u1_.password AS password_35, c0_.user_id AS user_id_36, c0_.delivery_address_id AS delivery_address_id_37, c0_.delivery_billing_address_id AS delivery_billing_address_id_38 FROM cart_finished c0_ LEFT JOIN user u1_ ON c0_.user_id = u1_.id WHERE c0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY c0_.commandDate DESC
Parameters:
[ 969 963 968 962 971 961 972 970 958 959 960 957 956 953 954 955 949 948 945 946 ] |
|
0.62 ms (1.83%) |
1 |
SELECT COUNT(*) FROM user t0 WHERE t0.active = ?
Parameters:
[
0
]
|
|
0.60 ms (1.78%) |
1 |
SELECT t0.id AS id_1, t0.companyName AS companyName_2, t0.name AS name_3, t0.firstName AS firstName_4, t0.address AS address_5, t0.postal AS postal_6, t0.town AS town_7, t0.country AS country_8, t0.phoneNumber AS phoneNumber_9, t0.monday AS monday_10, t0.morningMonday AS morningMonday_11, t0.morningMondayEnd AS morningMondayEnd_12, t0.afternoonMonday AS afternoonMonday_13, t0.afternoonMondayEnd AS afternoonMondayEnd_14, t0.tuesday AS tuesday_15, t0.morningTuesday AS morningTuesday_16, t0.morningTuesdayEnd AS morningTuesdayEnd_17, t0.afternoonTuesday AS afternoonTuesday_18, t0.afternoonTuesdayEnd AS afternoonTuesdayEnd_19, t0.wednesday AS wednesday_20, t0.morningWednesday AS morningWednesday_21, t0.morningWednesdayEnd AS morningWednesdayEnd_22, t0.afternoonWednesday AS afternoonWednesday_23, t0.afternoonWednesdayEnd AS afternoonWednesdayEnd_24, t0.thursday AS thursday_25, t0.morningThursday AS morningThursday_26, t0.morningThursdayEnd AS morningThursdayEnd_27, t0.afternoonThursday AS afternoonThursday_28, t0.afternoonThursdayeEnd AS afternoonThursdayeEnd_29, t0.friday AS friday_30, t0.morningFriday AS morningFriday_31, t0.morningFridayEnd AS morningFridayEnd_32, t0.afternoonFriday AS afternoonFriday_33, t0.afternoonFridayEnd AS afternoonFridayEnd_34, t0.saturday AS saturday_35, t0.morningSaturday AS morningSaturday_36, t0.morningSaturdayEnd AS morningSaturdayEnd_37, t0.afternoonSaturday AS afternoonSaturday_38, t0.afternoonSaturdayEnd AS afternoonSaturdayEnd_39, t0.sunday AS sunday_40, t0.morningSunday AS morningSunday_41, t0.morningSundayEnd AS morningSundayEnd_42, t0.afternoonSunday AS afternoonSunday_43, t0.afternoonSundayEnd AS afternoonSundayEnd_44, t0.hourlyMonday AS hourlyMonday_45, t0.hourlyMorningMonday AS hourlyMorningMonday_46, t0.hourlyMorningMondayEnd AS hourlyMorningMondayEnd_47, t0.hourlyTuesday AS hourlyTuesday_48, t0.hourlyMorningTuesday AS hourlyMorningTuesday_49, t0.hourlyMorningTuesdayEnd AS hourlyMorningTuesdayEnd_50, t0.hourlyWednesday AS hourlyWednesday_51, t0.hourlyMorningWednesday AS hourlyMorningWednesday_52, t0.hourlyMorningWednesdayEnd AS hourlyMorningWednesdayEnd_53, t0.hourlyThursday AS hourlyThursday_54, t0.hourlyMorningThursday AS hourlyMorningThursday_55, t0.hourlyMorningThursdayEnd AS hourlyMorningThursdayEnd_56, t0.hourlyFriday AS hourlyFriday_57, t0.hourlyMorningFriday AS hourlyMorningFriday_58, t0.hourlyMorningFridayEnd AS hourlyMorningFridayEnd_59, t0.hourlySaturday AS hourlySaturday_60, t0.hourlyMorningSaturday AS hourlyMorningSaturday_61, t0.hourlyMorningSaturdayEnd AS hourlyMorningSaturdayEnd_62, t0.hourlySunday AS hourlySunday_63, t0.hourlyMorningSunday AS hourlyMorningSunday_64, t0.hourlyMorningSundayEnd AS hourlyMorningSundayEnd_65, t0.user_id AS user_id_66 FROM delivery_address t0 WHERE t0.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ 1075 20 1069 806 608 711 563 737 926 793 783 ] |
|
0.59 ms (1.74%) |
1 |
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.specialCustomer AS specialCustomer_4, t0.generatePasswordRecovery AS generatePasswordRecovery_5, t0.resetToken AS resetToken_6, t0.resetTokenExpiresAt AS resetTokenExpiresAt_7, t0.additionalPercentage AS additionalPercentage_8, t0.name AS name_9, t0.firstName AS firstName_10, t0.address AS address_11, t0.postal AS postal_12, t0.locality AS locality_13, t0.country AS country_14, t0.phoneNumber AS phoneNumber_15, t0.directPhone AS directPhone_16, t0.otherMail AS otherMail_17, t0.companyName AS companyName_18, t0.active AS active_19, t0.gender AS gender_20, t0.userSupplementsPurchaseDecisionMaker AS userSupplementsPurchaseDecisionMaker_21, t0.password AS password_22 FROM user t0 WHERE t0.id = ?
Parameters:
[
10
]
|
|
0.55 ms (1.63%) |
1 |
SELECT t0.id AS id_1, t0.dateStart AS dateStart_2, t0.dateEnd AS dateEnd_3, t0.pourcentRebate AS pourcentRebate_4, t0.image AS image_5, t0.product_id AS product_id_6, t7.id AS id_8, t7.nameFr AS nameFr_9, t7.nameBe AS nameBe_10, t7.description AS description_11, t7.price AS price_12, t7.pricePharmacy AS pricePharmacy_13, t7.capacity AS capacity_14, t7.quantity AS quantity_15, t7.useCouncil AS useCouncil_16, t7.contraindication AS contraindication_17, t7.ingredient AS ingredient_18, t7.nutritionChart AS nutritionChart_19, t7.image AS image_20, t7.status AS status_21, t7.tools AS tools_22, t7.publicPrice AS publicPrice_23, t7.publicPriceHtva AS publicPriceHtva_24, t7.consumptionTime AS consumptionTime_25, t7.brand AS brand_26, t7.idOnNaturaSite AS idOnNaturaSite_27, t7.idProductFeatureOnNatura AS idProductFeatureOnNatura_28, t7.idProductOnMercator AS idProductOnMercator_29, t7.reference AS reference_30, t7.idStockAvailables AS idStockAvailables_31, t7.cnk AS cnk_32, t7.nut AS nut_33, t7.ean AS ean_34, t7.eanImage AS eanImage_35, t7.eanImageBase64 AS eanImageBase64_36, t7.tvaBe AS tvaBe_37, t7.tvaFr AS tvaFr_38, t7.tvaLu AS tvaLu_39, t7.saleFr AS saleFr_40, t7.saleBe AS saleBe_41, t7.saleLux AS saleLux_42, t7.actionShock AS actionShock_43 FROM special_discount t0 LEFT JOIN products t7 ON t0.product_id = t7.id WHERE t0.product_id = ? LIMIT 1
Parameters:
[
1087
]
|
|
0.39 ms (1.16%) |
1 |
SELECT b0_.id AS id_0, b0_.brandName AS brandName_1, b0_.rebateLow AS rebateLow_2, b0_.rebateHeigh AS rebateHeigh_3, b0_.active AS active_4 FROM brand_discount b0_ WHERE b0_.active = 1 AND LOWER(b0_.brandName) = ? LIMIT 1
Parameters:
[
"naturamedicatrix"
]
|
Database Connections
| Name | Service |
|---|---|
| default | doctrine.dbal.default_connection |
Entity Managers
| Name | Service |
|---|---|
| default | doctrine.orm.default_entity_manager |
Second Level Cache
Second Level Cache is not enabled.
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\User | No errors. |
| App\Entity\Cart | No errors. |
| App\Entity\SpecialCustomer | No errors. |
| App\Entity\CustomerControl | No errors. |
| App\Entity\Billings | No errors. |
| App\Entity\Invoices | No errors. |
| App\Entity\CartFinished | No errors. |
| App\Entity\AdditionalCompanyInformation | No errors. |
| App\Entity\Joker | No errors. |
| App\Entity\DeliveryAddress | No errors. |
| App\Entity\Tva | No errors. |
| App\Entity\Products | No errors. |
| App\Entity\Barcode | No errors. |
| App\Entity\ProductsAnalysis | No errors. |
| App\Entity\SpecialDiscount | No errors. |
| App\Entity\ActionShock | No errors. |
| App\Entity\CountryOfSale | No errors. |
| App\Entity\LotNumber | No errors. |
| App\Entity\Rebate | No errors. |
| App\Entity\BrandDiscount | No errors. |