Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

42 Database Queries

20 Different statements

32.06 ms Query time

0 Invalid entities

Queries

Group similar statements


SELECT i0_.id AS id_0, i0_.src AS src_1, i0_.alt AS alt_2, i0_.titre AS titre_3, i0_.description AS description_4, i0_.rang AS rang_5, i0_.slide AS slide_6, i0_.link AS link_7, i0_.date AS date_8, s1_.id AS id_9, s1_.nom AS nom_10, s1_.description AS description_11, s1_.link AS link_12, s1_.date AS date_13, s1_.nbvente AS nbvente_14, s1_.nbproduit AS nbproduit_15, s1_.rang AS rang_16, s1_.src AS src_17, s1_.alt AS alt_18, i0_.souscategorie_id AS souscategorie_id_19, i0_.user_id AS user_id_20, s1_.user_id AS user_id_21, s1_.categorie_id AS categorie_id_22 FROM imgslide i0_ LEFT JOIN souscategorie s1_ ON i0_.souscategorie_id = s1_.id ORDER BY i0_.rang ASC
SELECT p0_.id AS id_0, p0_.nom AS nom_1, p0_.contenu AS contenu_2, p0_.description AS description_3, p0_.date AS date_4, p0_.nbvote AS nbvote_5, p0_.totalnote AS totalnote_6, p0_.nblike AS nblike_7, p0_.nbenregistrer AS nbenregistrer_8, p0_.nbpartage AS nbpartage_9, p0_.nbvente AS nbvente_10, p0_.nbpoint AS nbpoint_11, p0_.nbpiece AS nbpiece_12, p0_.produitdetail AS produitdetail_13, p0_.valide AS valide_14, p0_.recommander AS recommander_15, p0_.newprise AS newprise_16, p0_.lastprise AS lastprise_17, p0_.difference AS difference_18, p0_.prixlivraison AS prixlivraison_19, p0_.prod_number AS prod_number_20, s1_.id AS id_21, s1_.nom AS nom_22, s1_.description AS description_23, s1_.link AS link_24, s1_.date AS date_25, s1_.nbvente AS nbvente_26, s1_.nbproduit AS nbproduit_27, s1_.rang AS rang_28, s1_.src AS src_29, s1_.alt AS alt_30, p0_.user_id AS user_id_31, p0_.souscategorie_id AS souscategorie_id_32, p0_.marqueproduit_id AS marqueproduit_id_33, p0_.produitgro_id AS produitgro_id_34, s1_.user_id AS user_id_35, s1_.categorie_id AS categorie_id_36 FROM produit p0_ LEFT JOIN souscategorie s1_ ON p0_.souscategorie_id = s1_.id ORDER BY p0_.nbpoint DESC LIMIT 10
SELECT p0_.id AS id_0, p0_.nom AS nom_1, p0_.contenu AS contenu_2, p0_.description AS description_3, p0_.date AS date_4, p0_.nbvote AS nbvote_5, p0_.totalnote AS totalnote_6, p0_.nblike AS nblike_7, p0_.nbenregistrer AS nbenregistrer_8, p0_.nbpartage AS nbpartage_9, p0_.nbvente AS nbvente_10, p0_.nbpoint AS nbpoint_11, p0_.nbpiece AS nbpiece_12, p0_.produitdetail AS produitdetail_13, p0_.valide AS valide_14, p0_.recommander AS recommander_15, p0_.newprise AS newprise_16, p0_.lastprise AS lastprise_17, p0_.difference AS difference_18, p0_.prixlivraison AS prixlivraison_19, p0_.prod_number AS prod_number_20, s1_.id AS id_21, s1_.nom AS nom_22, s1_.description AS description_23, s1_.link AS link_24, s1_.date AS date_25, s1_.nbvente AS nbvente_26, s1_.nbproduit AS nbproduit_27, s1_.rang AS rang_28, s1_.src AS src_29, s1_.alt AS alt_30, p0_.user_id AS user_id_31, p0_.souscategorie_id AS souscategorie_id_32, p0_.marqueproduit_id AS marqueproduit_id_33, p0_.produitgro_id AS produitgro_id_34, s1_.user_id AS user_id_35, s1_.categorie_id AS categorie_id_36 FROM produit p0_ LEFT JOIN souscategorie s1_ ON p0_.souscategorie_id = s1_.id WHERE p0_.recommander = 1 ORDER BY p0_.nbpoint DESC LIMIT 50
SELECT s0_.id AS id_0, s0_.nom AS nom_1, s0_.description AS description_2, s0_.link AS link_3, s0_.date AS date_4, s0_.nbvente AS nbvente_5, s0_.nbproduit AS nbproduit_6, s0_.rang AS rang_7, s0_.src AS src_8, s0_.alt AS alt_9, s0_.user_id AS user_id_10, s0_.categorie_id AS categorie_id_11 FROM souscategorie s0_ ORDER BY s0_.rang ASC
SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT o0_.id AS id_0, o0_.titre AS titre_1, o0_.date AS date_2, o0_.link AS link_3, o0_.src AS src_4, o0_.alt AS alt_5, o0_.rang AS rang_6, o0_.timestamp AS timestamp_7, p1_.id AS id_8, p1_.nom AS nom_9, p1_.slogan AS slogan_10, p1_.date AS date_11, p1_.nbvisit AS nbvisit_12, p1_.siteweb AS siteweb_13, p1_.email AS email_14, p1_.tel AS tel_15, p1_.telpublic AS telpublic_16, p1_.villetext AS villetext_17, p1_.boutiquemobile AS boutiquemobile_18, p1_.twitter AS twitter_19, p1_.google AS google_20, p1_.linkedin AS linkedin_21, p1_.facebook AS facebook_22, p1_.clicklink AS clicklink_23, p1_.nbpoint AS nbpoint_24, p1_.tcode AS tcode_25, p1_.valide AS valide_26, p1_.inscriptionacheve AS inscriptionacheve_27, p1_.pageprojet AS pageprojet_28, p1_.montantrecu AS montantrecu_29, p1_.binplace AS binplace_30, p1_.nblike AS nblike_31, p1_.nbabonne AS nbabonne_32, p1_.nbconsultation AS nbconsultation_33, p1_.note AS note_34, p1_.nbdon AS nbdon_35, p1_.nbproduit AS nbproduit_36, p1_.profilupload AS profilupload_37 FROM offrespeciale o0_ LEFT JOIN projet p1_ ON o0_.projet_id = p1_.id ORDER BY o0_.date DESC) dctrn_result) dctrn_table
SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0, date_2 FROM (SELECT o0_.id AS id_0, o0_.titre AS titre_1, o0_.date AS date_2, o0_.link AS link_3, o0_.src AS src_4, o0_.alt AS alt_5, o0_.rang AS rang_6, o0_.timestamp AS timestamp_7, p1_.id AS id_8, p1_.nom AS nom_9, p1_.slogan AS slogan_10, p1_.date AS date_11, p1_.nbvisit AS nbvisit_12, p1_.siteweb AS siteweb_13, p1_.email AS email_14, p1_.tel AS tel_15, p1_.telpublic AS telpublic_16, p1_.villetext AS villetext_17, p1_.boutiquemobile AS boutiquemobile_18, p1_.twitter AS twitter_19, p1_.google AS google_20, p1_.linkedin AS linkedin_21, p1_.facebook AS facebook_22, p1_.clicklink AS clicklink_23, p1_.nbpoint AS nbpoint_24, p1_.tcode AS tcode_25, p1_.valide AS valide_26, p1_.inscriptionacheve AS inscriptionacheve_27, p1_.pageprojet AS pageprojet_28, p1_.montantrecu AS montantrecu_29, p1_.binplace AS binplace_30, p1_.nblike AS nblike_31, p1_.nbabonne AS nbabonne_32, p1_.nbconsultation AS nbconsultation_33, p1_.note AS note_34, p1_.nbdon AS nbdon_35, p1_.nbproduit AS nbproduit_36, p1_.profilupload AS profilupload_37 FROM offrespeciale o0_ LEFT JOIN projet p1_ ON o0_.projet_id = p1_.id) dctrn_result_inner ORDER BY date_2 DESC) dctrn_result LIMIT 20
SELECT o0_.id AS id_0, o0_.titre AS titre_1, o0_.date AS date_2, o0_.link AS link_3, o0_.src AS src_4, o0_.alt AS alt_5, o0_.rang AS rang_6, o0_.timestamp AS timestamp_7, p1_.id AS id_8, p1_.nom AS nom_9, p1_.slogan AS slogan_10, p1_.date AS date_11, p1_.nbvisit AS nbvisit_12, p1_.siteweb AS siteweb_13, p1_.email AS email_14, p1_.tel AS tel_15, p1_.telpublic AS telpublic_16, p1_.villetext AS villetext_17, p1_.boutiquemobile AS boutiquemobile_18, p1_.twitter AS twitter_19, p1_.google AS google_20, p1_.linkedin AS linkedin_21, p1_.facebook AS facebook_22, p1_.clicklink AS clicklink_23, p1_.nbpoint AS nbpoint_24, p1_.tcode AS tcode_25, p1_.valide AS valide_26, p1_.inscriptionacheve AS inscriptionacheve_27, p1_.pageprojet AS pageprojet_28, p1_.montantrecu AS montantrecu_29, p1_.binplace AS binplace_30, p1_.nblike AS nblike_31, p1_.nbabonne AS nbabonne_32, p1_.nbconsultation AS nbconsultation_33, p1_.note AS note_34, p1_.nbdon AS nbdon_35, p1_.nbproduit AS nbproduit_36, p1_.profilupload AS profilupload_37, o0_.projet_id AS projet_id_38, o0_.souscategorie_id AS souscategorie_id_39, o0_.user_id AS user_id_40, p1_.user_id AS user_id_41, p1_.pays_id AS pays_id_42, p1_.ville_id AS ville_id_43, p1_.typeprojet_id AS typeprojet_id_44 FROM offrespeciale o0_ LEFT JOIN projet p1_ ON o0_.projet_id = p1_.id WHERE o0_.id IN (?) ORDER BY o0_.date DESC
SELECT t0.id AS id_1, t0.src AS src_2, t0.alt AS alt_3, t0.projet_id AS projet_id_4 FROM imgprofilprojet t0 WHERE t0.projet_id = ?
SELECT t0.id AS id_1, t0.src AS src_2, t0.alt AS alt_3, t0.projet_id AS projet_id_4 FROM imgcouvertureprojet t0 WHERE t0.projet_id = ?
SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0, date_2 FROM (SELECT o0_.id AS id_0, o0_.titre AS titre_1, o0_.date AS date_2, o0_.link AS link_3, o0_.src AS src_4, o0_.alt AS alt_5, o0_.rang AS rang_6, o0_.timestamp AS timestamp_7, p1_.id AS id_8, p1_.nom AS nom_9, p1_.slogan AS slogan_10, p1_.date AS date_11, p1_.nbvisit AS nbvisit_12, p1_.siteweb AS siteweb_13, p1_.email AS email_14, p1_.tel AS tel_15, p1_.telpublic AS telpublic_16, p1_.villetext AS villetext_17, p1_.boutiquemobile AS boutiquemobile_18, p1_.twitter AS twitter_19, p1_.google AS google_20, p1_.linkedin AS linkedin_21, p1_.facebook AS facebook_22, p1_.clicklink AS clicklink_23, p1_.nbpoint AS nbpoint_24, p1_.tcode AS tcode_25, p1_.valide AS valide_26, p1_.inscriptionacheve AS inscriptionacheve_27, p1_.pageprojet AS pageprojet_28, p1_.montantrecu AS montantrecu_29, p1_.binplace AS binplace_30, p1_.nblike AS nblike_31, p1_.nbabonne AS nbabonne_32, p1_.nbconsultation AS nbconsultation_33, p1_.note AS note_34, p1_.nbdon AS nbdon_35, p1_.nbproduit AS nbproduit_36, p1_.profilupload AS profilupload_37 FROM offrespeciale o0_ LEFT JOIN projet p1_ ON o0_.projet_id = p1_.id) dctrn_result_inner ORDER BY date_2 DESC) dctrn_result LIMIT 20
SELECT o0_.id AS id_0, o0_.titre AS titre_1, o0_.date AS date_2, o0_.link AS link_3, o0_.src AS src_4, o0_.alt AS alt_5, o0_.rang AS rang_6, o0_.timestamp AS timestamp_7, p1_.id AS id_8, p1_.nom AS nom_9, p1_.slogan AS slogan_10, p1_.date AS date_11, p1_.nbvisit AS nbvisit_12, p1_.siteweb AS siteweb_13, p1_.email AS email_14, p1_.tel AS tel_15, p1_.telpublic AS telpublic_16, p1_.villetext AS villetext_17, p1_.boutiquemobile AS boutiquemobile_18, p1_.twitter AS twitter_19, p1_.google AS google_20, p1_.linkedin AS linkedin_21, p1_.facebook AS facebook_22, p1_.clicklink AS clicklink_23, p1_.nbpoint AS nbpoint_24, p1_.tcode AS tcode_25, p1_.valide AS valide_26, p1_.inscriptionacheve AS inscriptionacheve_27, p1_.pageprojet AS pageprojet_28, p1_.montantrecu AS montantrecu_29, p1_.binplace AS binplace_30, p1_.nblike AS nblike_31, p1_.nbabonne AS nbabonne_32, p1_.nbconsultation AS nbconsultation_33, p1_.note AS note_34, p1_.nbdon AS nbdon_35, p1_.nbproduit AS nbproduit_36, p1_.profilupload AS profilupload_37, o0_.projet_id AS projet_id_38, o0_.souscategorie_id AS souscategorie_id_39, o0_.user_id AS user_id_40, p1_.user_id AS user_id_41, p1_.pays_id AS pays_id_42, p1_.ville_id AS ville_id_43, p1_.typeprojet_id AS typeprojet_id_44 FROM offrespeciale o0_ LEFT JOIN projet p1_ ON o0_.projet_id = p1_.id WHERE o0_.id IN (?) ORDER BY o0_.date DESC
SELECT a0_.id AS id_0, a0_.date AS date_1, a0_.aimer AS aimer_2, a0_.enregistrer AS enregistrer_3, a0_.partager AS partager_4, u1_.id AS id_5, u1_.username AS username_6, u1_.password AS password_7, u1_.salt AS salt_8, u1_.roles AS roles_9, u1_.nom AS nom_10, u1_.poste AS poste_11, u1_.villetext AS villetext_12, u1_.statut AS statut_13, u1_.prenom AS prenom_14, u1_.tel AS tel_15, u1_.tcode AS tcode_16, u1_.email AS email_17, u1_.datenaiss AS datenaiss_18, u1_.publieridentite AS publieridentite_19, u1_.complet AS complet_20, u1_.typeaccount AS typeaccount_21, u1_.adresse AS adresse_22, u1_.sexe AS sexe_23, u1_.nbprojetvue AS nbprojetvue_24, u1_.nbabonne AS nbabonne_25, u1_.nbpubconsulter AS nbpubconsulter_26, u1_.nbabonnement AS nbabonnement_27, u1_.nbabonnementprojet AS nbabonnementprojet_28, u1_.nbvisiteur AS nbvisiteur_29, u1_.projetconnecter AS projetconnecter_30, u1_.nbprojet AS nbprojet_31, u1_.dernierevisite AS dernierevisite_32, u1_.heurearrive AS heurearrive_33, u1_.datebeg AS datebeg_34, u1_.dateinscription AS dateinscription_35, u1_.cni AS cni_36, u1_.puui AS puui_37, u1_.publication AS publication_38, p2_.id AS id_39, p2_.nom AS nom_40, p2_.contenu AS contenu_41, p2_.description AS description_42, p2_.date AS date_43, p2_.nbvote AS nbvote_44, p2_.totalnote AS totalnote_45, p2_.nblike AS nblike_46, p2_.nbenregistrer AS nbenregistrer_47, p2_.nbpartage AS nbpartage_48, p2_.nbvente AS nbvente_49, p2_.nbpoint AS nbpoint_50, p2_.nbpiece AS nbpiece_51, p2_.produitdetail AS produitdetail_52, p2_.valide AS valide_53, p2_.recommander AS recommander_54, p2_.newprise AS newprise_55, p2_.lastprise AS lastprise_56, p2_.difference AS difference_57, p2_.prixlivraison AS prixlivraison_58, p2_.prod_number AS prod_number_59, a0_.user_id AS user_id_60, a0_.produit_id AS produit_id_61, u1_.pays_id AS pays_id_62, p2_.user_id AS user_id_63, p2_.souscategorie_id AS souscategorie_id_64, p2_.marqueproduit_id AS marqueproduit_id_65, p2_.produitgro_id AS produitgro_id_66 FROM animationproduit a0_ LEFT JOIN user u1_ ON a0_.user_id = u1_.id LEFT JOIN produit p2_ ON a0_.produit_id = p2_.id WHERE a0_.enregistrer = 1 ORDER BY a0_.date DESC LIMIT 10
SELECT t0.id AS id_1, t0.date AS date_2, t0.domaine AS domaine_3, t0.payer AS payer_4, t0.livrer AS livrer_5, t0.panierdachat AS panierdachat_6, t0.coastlivraison AS coastlivraison_7, t0.sousmis AS sousmis_8, t0.online_panier AS online_panier_9, t0.local_panier AS local_panier_10, t0.reconcilier AS reconcilier_11, t0.reconciliertresor AS reconciliertresor_12, t0.montantht AS montantht_13, t0.montantttc AS montantttc_14, t0.prisetotal AS prisetotal_15, t0.versementtresor AS versementtresor_16, t0.livraisonpayer AS livraisonpayer_17, t0.tel AS tel_18, t0.destination AS destination_19, t0.user_id AS user_id_20, t0.auteur_id AS auteur_id_21, t0.service_id AS service_id_22, t0.projet_id AS projet_id_23, t0.projetmobile_id AS projetmobile_id_24, t0.client_id AS client_id_25, t0.commercial_id AS commercial_id_26, t0.firstpanier_id AS firstpanier_id_27, t0.ville_id AS ville_id_28, t0.affilier_id AS affilier_id_29, t0.couponcard_id AS couponcard_id_30, t0.contact_id AS contact_id_31 FROM panier t0 WHERE t0.id = ? AND t0.sousmis = ? LIMIT 1
SELECT t0.id AS id_1, t0.type AS type_2, t0.valeur AS valeur_3, t0.link AS link_4, t0.description AS description_5, t0.date AS date_6, t0.rang AS rang_7, t0.src AS src_8, t0.alt AS alt_9, t0.user_id AS user_id_10 FROM parametreadmin t0 WHERE t0.type = ? LIMIT 1
SELECT m0_.id AS id_0, m0_.nom AS nom_1, m0_.description AS description_2, m0_.rang AS rang_3, m0_.src AS src_4, m0_.alt AS alt_5 FROM marqueproduit m0_ ORDER BY m0_.rang ASC
SELECT p0_.id AS id_0, p0_.nom AS nom_1, p0_.contenu AS contenu_2, p0_.description AS description_3, p0_.date AS date_4, p0_.nbvote AS nbvote_5, p0_.totalnote AS totalnote_6, p0_.nblike AS nblike_7, p0_.nbenregistrer AS nbenregistrer_8, p0_.nbpartage AS nbpartage_9, p0_.nbvente AS nbvente_10, p0_.nbpoint AS nbpoint_11, p0_.nbpiece AS nbpiece_12, p0_.produitdetail AS produitdetail_13, p0_.valide AS valide_14, p0_.recommander AS recommander_15, p0_.newprise AS newprise_16, p0_.lastprise AS lastprise_17, p0_.difference AS difference_18, p0_.prixlivraison AS prixlivraison_19, p0_.prod_number AS prod_number_20, s1_.id AS id_21, s1_.nom AS nom_22, s1_.description AS description_23, s1_.link AS link_24, s1_.date AS date_25, s1_.nbvente AS nbvente_26, s1_.nbproduit AS nbproduit_27, s1_.rang AS rang_28, s1_.src AS src_29, s1_.alt AS alt_30, p0_.user_id AS user_id_31, p0_.souscategorie_id AS souscategorie_id_32, p0_.marqueproduit_id AS marqueproduit_id_33, p0_.produitgro_id AS produitgro_id_34, s1_.user_id AS user_id_35, s1_.categorie_id AS categorie_id_36 FROM produit p0_ LEFT JOIN souscategorie s1_ ON p0_.souscategorie_id = s1_.id ORDER BY p0_.date DESC LIMIT 10
SELECT t0.id AS id_1, t0.type AS type_2, t0.valeur AS valeur_3, t0.link AS link_4, t0.description AS description_5, t0.date AS date_6, t0.rang AS rang_7, t0.src AS src_8, t0.alt AS alt_9, t0.user_id AS user_id_10 FROM parametreadmin t0 WHERE t0.type = ? LIMIT 1
SELECT t0.id AS id_1, t0.type AS type_2, t0.valeur AS valeur_3, t0.link AS link_4, t0.description AS description_5, t0.date AS date_6, t0.rang AS rang_7, t0.src AS src_8, t0.alt AS alt_9, t0.user_id AS user_id_10 FROM parametreadmin t0 WHERE t0.type = ? LIMIT 1
SELECT t0.id AS id_1, t0.type AS type_2, t0.valeur AS valeur_3, t0.link AS link_4, t0.description AS description_5, t0.date AS date_6, t0.rang AS rang_7, t0.src AS src_8, t0.alt AS alt_9, t0.user_id AS user_id_10 FROM parametreadmin t0 WHERE t0.type = ? LIMIT 1
SHOW FULL TABLES WHERE Table_type = 'BASE TABLE'
SHOW FULL TABLES WHERE Table_type = 'BASE TABLE'
SELECT COLUMN_NAME AS Field, COLUMN_TYPE AS Type, IS_NULLABLE AS `Null`, COLUMN_KEY AS `Key`, COLUMN_DEFAULT AS `Default`, EXTRA AS Extra, COLUMN_COMMENT AS Comment, CHARACTER_SET_NAME AS CharacterSet, COLLATION_NAME AS Collation FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = 'mbill' AND TABLE_NAME = 'doctrine_migration_versions' ORDER BY ORDINAL_POSITION ASC
SELECT DISTINCT k.`CONSTRAINT_NAME`, k.`COLUMN_NAME`, k.`REFERENCED_TABLE_NAME`, k.`REFERENCED_COLUMN_NAME` /*!50116 , c.update_rule, c.delete_rule */ FROM information_schema.key_column_usage k /*!50116 INNER JOIN information_schema.referential_constraints c ON   c.constraint_name = k.constraint_name AND   c.table_name = 'doctrine_migration_versions' */ WHERE k.table_name = 'doctrine_migration_versions' AND k.table_schema = 'mbill' /*!50116 AND c.constraint_schema = 'mbill' */ AND k.`REFERENCED_COLUMN_NAME` is not NULL
SELECT NON_UNIQUE AS Non_Unique, INDEX_NAME AS Key_name, COLUMN_NAME AS Column_Name, SUB_PART AS Sub_Part, INDEX_TYPE AS Index_Type FROM information_schema.STATISTICS WHERE TABLE_NAME = 'doctrine_migration_versions' AND TABLE_SCHEMA = 'mbill' ORDER BY SEQ_IN_INDEX ASC
SELECT ENGINE, AUTO_INCREMENT, TABLE_COLLATION, TABLE_COMMENT, CREATE_OPTIONS
FROM information_schema.TABLES
WHERE TABLE_TYPE = 'BASE TABLE' AND TABLE_SCHEMA = DATABASE() AND TABLE_NAME = 'doctrine_migration_versions'
SELECT * FROM doctrine_migration_versions
SHOW FULL TABLES WHERE Table_type = 'BASE TABLE'
SHOW FULL TABLES WHERE Table_type = 'BASE TABLE'
SELECT COLUMN_NAME AS Field, COLUMN_TYPE AS Type, IS_NULLABLE AS `Null`, COLUMN_KEY AS `Key`, COLUMN_DEFAULT AS `Default`, EXTRA AS Extra, COLUMN_COMMENT AS Comment, CHARACTER_SET_NAME AS CharacterSet, COLLATION_NAME AS Collation FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = 'mbill' AND TABLE_NAME = 'doctrine_migration_versions' ORDER BY ORDINAL_POSITION ASC
SELECT DISTINCT k.`CONSTRAINT_NAME`, k.`COLUMN_NAME`, k.`REFERENCED_TABLE_NAME`, k.`REFERENCED_COLUMN_NAME` /*!50116 , c.update_rule, c.delete_rule */ FROM information_schema.key_column_usage k /*!50116 INNER JOIN information_schema.referential_constraints c ON   c.constraint_name = k.constraint_name AND   c.table_name = 'doctrine_migration_versions' */ WHERE k.table_name = 'doctrine_migration_versions' AND k.table_schema = 'mbill' /*!50116 AND c.constraint_schema = 'mbill' */ AND k.`REFERENCED_COLUMN_NAME` is not NULL
SELECT NON_UNIQUE AS Non_Unique, INDEX_NAME AS Key_name, COLUMN_NAME AS Column_Name, SUB_PART AS Sub_Part, INDEX_TYPE AS Index_Type FROM information_schema.STATISTICS WHERE TABLE_NAME = 'doctrine_migration_versions' AND TABLE_SCHEMA = 'mbill' ORDER BY SEQ_IN_INDEX ASC
SELECT ENGINE, AUTO_INCREMENT, TABLE_COLLATION, TABLE_COMMENT, CREATE_OPTIONS
FROM information_schema.TABLES
WHERE TABLE_TYPE = 'BASE TABLE' AND TABLE_SCHEMA = DATABASE() AND TABLE_NAME = 'doctrine_migration_versions'
SELECT * FROM doctrine_migration_versions
SHOW FULL TABLES WHERE Table_type = 'BASE TABLE'
SHOW FULL TABLES WHERE Table_type = 'BASE TABLE'
SELECT COLUMN_NAME AS Field, COLUMN_TYPE AS Type, IS_NULLABLE AS `Null`, COLUMN_KEY AS `Key`, COLUMN_DEFAULT AS `Default`, EXTRA AS Extra, COLUMN_COMMENT AS Comment, CHARACTER_SET_NAME AS CharacterSet, COLLATION_NAME AS Collation FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = 'mbill' AND TABLE_NAME = 'doctrine_migration_versions' ORDER BY ORDINAL_POSITION ASC
SELECT DISTINCT k.`CONSTRAINT_NAME`, k.`COLUMN_NAME`, k.`REFERENCED_TABLE_NAME`, k.`REFERENCED_COLUMN_NAME` /*!50116 , c.update_rule, c.delete_rule */ FROM information_schema.key_column_usage k /*!50116 INNER JOIN information_schema.referential_constraints c ON   c.constraint_name = k.constraint_name AND   c.table_name = 'doctrine_migration_versions' */ WHERE k.table_name = 'doctrine_migration_versions' AND k.table_schema = 'mbill' /*!50116 AND c.constraint_schema = 'mbill' */ AND k.`REFERENCED_COLUMN_NAME` is not NULL
SELECT NON_UNIQUE AS Non_Unique, INDEX_NAME AS Key_name, COLUMN_NAME AS Column_Name, SUB_PART AS Sub_Part, INDEX_TYPE AS Index_Type FROM information_schema.STATISTICS WHERE TABLE_NAME = 'doctrine_migration_versions' AND TABLE_SCHEMA = 'mbill' ORDER BY SEQ_IN_INDEX ASC
SELECT ENGINE, AUTO_INCREMENT, TABLE_COLLATION, TABLE_COMMENT, CREATE_OPTIONS
FROM information_schema.TABLES
WHERE TABLE_TYPE = 'BASE TABLE' AND TABLE_SCHEMA = DATABASE() AND TABLE_NAME = 'doctrine_migration_versions'
SELECT * FROM doctrine_migration_versions
SELECT t0.id AS id_1, t0.type AS type_2, t0.valeur AS valeur_3, t0.link AS link_4, t0.description AS description_5, t0.date AS date_6, t0.rang AS rang_7, t0.src AS src_8, t0.alt AS alt_9, t0.user_id AS user_id_10 FROM parametreadmin t0 WHERE t0.type = ? LIMIT 1
SELECT t0.id AS id_1, t0.type AS type_2, t0.valeur AS valeur_3, t0.link AS link_4, t0.description AS description_5, t0.date AS date_6, t0.rang AS rang_7, t0.src AS src_8, t0.alt AS alt_9, t0.user_id AS user_id_10 FROM parametreadmin t0 WHERE t0.type = ? LIMIT 1

#▲	Time	Info
1	0.97 ms	SELECT i0_.id AS id_0, i0_.src AS src_1, i0_.alt AS alt_2, i0_.titre AS titre_3, i0_.description AS description_4, i0_.rang AS rang_5, i0_.slide AS slide_6, i0_.link AS link_7, i0_.date AS date_8, s1_.id AS id_9, s1_.nom AS nom_10, s1_.description AS description_11, s1_.link AS link_12, s1_.date AS date_13, s1_.nbvente AS nbvente_14, s1_.nbproduit AS nbproduit_15, s1_.rang AS rang_16, s1_.src AS src_17, s1_.alt AS alt_18, i0_.souscategorie_id AS souscategorie_id_19, i0_.user_id AS user_id_20, s1_.user_id AS user_id_21, s1_.categorie_id AS categorie_id_22 FROM imgslide i0_ LEFT JOIN souscategorie s1_ ON i0_.souscategorie_id = s1_.id ORDER BY i0_.rang ASC Parameters: [] View formatted query View runnable query Explain query SELECT i0_.id AS id_0, i0_.src AS src_1, i0_.alt AS alt_2, i0_.titre AS titre_3, i0_.description AS description_4, i0_.rang AS rang_5, i0_.slide AS slide_6, i0_.link AS link_7, i0_.date AS date_8, s1_.id AS id_9, s1_.nom AS nom_10, s1_.description AS description_11, s1_.link AS link_12, s1_.date AS date_13, s1_.nbvente AS nbvente_14, s1_.nbproduit AS nbproduit_15, s1_.rang AS rang_16, s1_.src AS src_17, s1_.alt AS alt_18, i0_.souscategorie_id AS souscategorie_id_19, i0_.user_id AS user_id_20, s1_.user_id AS user_id_21, s1_.categorie_id AS categorie_id_22 FROM imgslide i0_ LEFT JOIN souscategorie s1_ ON i0_.souscategorie_id = s1_.id ORDER BY i0_.rang ASC SELECT i0_.id AS id_0, i0_.src AS src_1, i0_.alt AS alt_2, i0_.titre AS titre_3, i0_.description AS description_4, i0_.rang AS rang_5, i0_.slide AS slide_6, i0_.link AS link_7, i0_.date AS date_8, s1_.id AS id_9, s1_.nom AS nom_10, s1_.description AS description_11, s1_.link AS link_12, s1_.date AS date_13, s1_.nbvente AS nbvente_14, s1_.nbproduit AS nbproduit_15, s1_.rang AS rang_16, s1_.src AS src_17, s1_.alt AS alt_18, i0_.souscategorie_id AS souscategorie_id_19, i0_.user_id AS user_id_20, s1_.user_id AS user_id_21, s1_.categorie_id AS categorie_id_22 FROM imgslide i0_ LEFT JOIN souscategorie s1_ ON i0_.souscategorie_id = s1_.id ORDER BY i0_.rang ASC;
2	1.19 ms	SELECT p0_.id AS id_0, p0_.nom AS nom_1, p0_.contenu AS contenu_2, p0_.description AS description_3, p0_.date AS date_4, p0_.nbvote AS nbvote_5, p0_.totalnote AS totalnote_6, p0_.nblike AS nblike_7, p0_.nbenregistrer AS nbenregistrer_8, p0_.nbpartage AS nbpartage_9, p0_.nbvente AS nbvente_10, p0_.nbpoint AS nbpoint_11, p0_.nbpiece AS nbpiece_12, p0_.produitdetail AS produitdetail_13, p0_.valide AS valide_14, p0_.recommander AS recommander_15, p0_.newprise AS newprise_16, p0_.lastprise AS lastprise_17, p0_.difference AS difference_18, p0_.prixlivraison AS prixlivraison_19, p0_.prod_number AS prod_number_20, s1_.id AS id_21, s1_.nom AS nom_22, s1_.description AS description_23, s1_.link AS link_24, s1_.date AS date_25, s1_.nbvente AS nbvente_26, s1_.nbproduit AS nbproduit_27, s1_.rang AS rang_28, s1_.src AS src_29, s1_.alt AS alt_30, p0_.user_id AS user_id_31, p0_.souscategorie_id AS souscategorie_id_32, p0_.marqueproduit_id AS marqueproduit_id_33, p0_.produitgro_id AS produitgro_id_34, s1_.user_id AS user_id_35, s1_.categorie_id AS categorie_id_36 FROM produit p0_ LEFT JOIN souscategorie s1_ ON p0_.souscategorie_id = s1_.id ORDER BY p0_.nbpoint DESC LIMIT 10 Parameters: [] View formatted query View runnable query Explain query SELECT p0_.id AS id_0, p0_.nom AS nom_1, p0_.contenu AS contenu_2, p0_.description AS description_3, p0_.date AS date_4, p0_.nbvote AS nbvote_5, p0_.totalnote AS totalnote_6, p0_.nblike AS nblike_7, p0_.nbenregistrer AS nbenregistrer_8, p0_.nbpartage AS nbpartage_9, p0_.nbvente AS nbvente_10, p0_.nbpoint AS nbpoint_11, p0_.nbpiece AS nbpiece_12, p0_.produitdetail AS produitdetail_13, p0_.valide AS valide_14, p0_.recommander AS recommander_15, p0_.newprise AS newprise_16, p0_.lastprise AS lastprise_17, p0_.difference AS difference_18, p0_.prixlivraison AS prixlivraison_19, p0_.prod_number AS prod_number_20, s1_.id AS id_21, s1_.nom AS nom_22, s1_.description AS description_23, s1_.link AS link_24, s1_.date AS date_25, s1_.nbvente AS nbvente_26, s1_.nbproduit AS nbproduit_27, s1_.rang AS rang_28, s1_.src AS src_29, s1_.alt AS alt_30, p0_.user_id AS user_id_31, p0_.souscategorie_id AS souscategorie_id_32, p0_.marqueproduit_id AS marqueproduit_id_33, p0_.produitgro_id AS produitgro_id_34, s1_.user_id AS user_id_35, s1_.categorie_id AS categorie_id_36 FROM produit p0_ LEFT JOIN souscategorie s1_ ON p0_.souscategorie_id = s1_.id ORDER BY p0_.nbpoint DESC LIMIT 10 SELECT p0_.id AS id_0, p0_.nom AS nom_1, p0_.contenu AS contenu_2, p0_.description AS description_3, p0_.date AS date_4, p0_.nbvote AS nbvote_5, p0_.totalnote AS totalnote_6, p0_.nblike AS nblike_7, p0_.nbenregistrer AS nbenregistrer_8, p0_.nbpartage AS nbpartage_9, p0_.nbvente AS nbvente_10, p0_.nbpoint AS nbpoint_11, p0_.nbpiece AS nbpiece_12, p0_.produitdetail AS produitdetail_13, p0_.valide AS valide_14, p0_.recommander AS recommander_15, p0_.newprise AS newprise_16, p0_.lastprise AS lastprise_17, p0_.difference AS difference_18, p0_.prixlivraison AS prixlivraison_19, p0_.prod_number AS prod_number_20, s1_.id AS id_21, s1_.nom AS nom_22, s1_.description AS description_23, s1_.link AS link_24, s1_.date AS date_25, s1_.nbvente AS nbvente_26, s1_.nbproduit AS nbproduit_27, s1_.rang AS rang_28, s1_.src AS src_29, s1_.alt AS alt_30, p0_.user_id AS user_id_31, p0_.souscategorie_id AS souscategorie_id_32, p0_.marqueproduit_id AS marqueproduit_id_33, p0_.produitgro_id AS produitgro_id_34, s1_.user_id AS user_id_35, s1_.categorie_id AS categorie_id_36 FROM produit p0_ LEFT JOIN souscategorie s1_ ON p0_.souscategorie_id = s1_.id ORDER BY p0_.nbpoint DESC LIMIT 10;
3	0.93 ms	SELECT p0_.id AS id_0, p0_.nom AS nom_1, p0_.contenu AS contenu_2, p0_.description AS description_3, p0_.date AS date_4, p0_.nbvote AS nbvote_5, p0_.totalnote AS totalnote_6, p0_.nblike AS nblike_7, p0_.nbenregistrer AS nbenregistrer_8, p0_.nbpartage AS nbpartage_9, p0_.nbvente AS nbvente_10, p0_.nbpoint AS nbpoint_11, p0_.nbpiece AS nbpiece_12, p0_.produitdetail AS produitdetail_13, p0_.valide AS valide_14, p0_.recommander AS recommander_15, p0_.newprise AS newprise_16, p0_.lastprise AS lastprise_17, p0_.difference AS difference_18, p0_.prixlivraison AS prixlivraison_19, p0_.prod_number AS prod_number_20, s1_.id AS id_21, s1_.nom AS nom_22, s1_.description AS description_23, s1_.link AS link_24, s1_.date AS date_25, s1_.nbvente AS nbvente_26, s1_.nbproduit AS nbproduit_27, s1_.rang AS rang_28, s1_.src AS src_29, s1_.alt AS alt_30, p0_.user_id AS user_id_31, p0_.souscategorie_id AS souscategorie_id_32, p0_.marqueproduit_id AS marqueproduit_id_33, p0_.produitgro_id AS produitgro_id_34, s1_.user_id AS user_id_35, s1_.categorie_id AS categorie_id_36 FROM produit p0_ LEFT JOIN souscategorie s1_ ON p0_.souscategorie_id = s1_.id WHERE p0_.recommander = 1 ORDER BY p0_.nbpoint DESC LIMIT 50 Parameters: [] View formatted query View runnable query Explain query SELECT p0_.id AS id_0, p0_.nom AS nom_1, p0_.contenu AS contenu_2, p0_.description AS description_3, p0_.date AS date_4, p0_.nbvote AS nbvote_5, p0_.totalnote AS totalnote_6, p0_.nblike AS nblike_7, p0_.nbenregistrer AS nbenregistrer_8, p0_.nbpartage AS nbpartage_9, p0_.nbvente AS nbvente_10, p0_.nbpoint AS nbpoint_11, p0_.nbpiece AS nbpiece_12, p0_.produitdetail AS produitdetail_13, p0_.valide AS valide_14, p0_.recommander AS recommander_15, p0_.newprise AS newprise_16, p0_.lastprise AS lastprise_17, p0_.difference AS difference_18, p0_.prixlivraison AS prixlivraison_19, p0_.prod_number AS prod_number_20, s1_.id AS id_21, s1_.nom AS nom_22, s1_.description AS description_23, s1_.link AS link_24, s1_.date AS date_25, s1_.nbvente AS nbvente_26, s1_.nbproduit AS nbproduit_27, s1_.rang AS rang_28, s1_.src AS src_29, s1_.alt AS alt_30, p0_.user_id AS user_id_31, p0_.souscategorie_id AS souscategorie_id_32, p0_.marqueproduit_id AS marqueproduit_id_33, p0_.produitgro_id AS produitgro_id_34, s1_.user_id AS user_id_35, s1_.categorie_id AS categorie_id_36 FROM produit p0_ LEFT JOIN souscategorie s1_ ON p0_.souscategorie_id = s1_.id WHERE p0_.recommander = 1 ORDER BY p0_.nbpoint DESC LIMIT 50 SELECT p0_.id AS id_0, p0_.nom AS nom_1, p0_.contenu AS contenu_2, p0_.description AS description_3, p0_.date AS date_4, p0_.nbvote AS nbvote_5, p0_.totalnote AS totalnote_6, p0_.nblike AS nblike_7, p0_.nbenregistrer AS nbenregistrer_8, p0_.nbpartage AS nbpartage_9, p0_.nbvente AS nbvente_10, p0_.nbpoint AS nbpoint_11, p0_.nbpiece AS nbpiece_12, p0_.produitdetail AS produitdetail_13, p0_.valide AS valide_14, p0_.recommander AS recommander_15, p0_.newprise AS newprise_16, p0_.lastprise AS lastprise_17, p0_.difference AS difference_18, p0_.prixlivraison AS prixlivraison_19, p0_.prod_number AS prod_number_20, s1_.id AS id_21, s1_.nom AS nom_22, s1_.description AS description_23, s1_.link AS link_24, s1_.date AS date_25, s1_.nbvente AS nbvente_26, s1_.nbproduit AS nbproduit_27, s1_.rang AS rang_28, s1_.src AS src_29, s1_.alt AS alt_30, p0_.user_id AS user_id_31, p0_.souscategorie_id AS souscategorie_id_32, p0_.marqueproduit_id AS marqueproduit_id_33, p0_.produitgro_id AS produitgro_id_34, s1_.user_id AS user_id_35, s1_.categorie_id AS categorie_id_36 FROM produit p0_ LEFT JOIN souscategorie s1_ ON p0_.souscategorie_id = s1_.id WHERE p0_.recommander = 1 ORDER BY p0_.nbpoint DESC LIMIT 50;
4	0.87 ms	SELECT s0_.id AS id_0, s0_.nom AS nom_1, s0_.description AS description_2, s0_.link AS link_3, s0_.date AS date_4, s0_.nbvente AS nbvente_5, s0_.nbproduit AS nbproduit_6, s0_.rang AS rang_7, s0_.src AS src_8, s0_.alt AS alt_9, s0_.user_id AS user_id_10, s0_.categorie_id AS categorie_id_11 FROM souscategorie s0_ ORDER BY s0_.rang ASC Parameters: [] View formatted query View runnable query Explain query SELECT s0_.id AS id_0, s0_.nom AS nom_1, s0_.description AS description_2, s0_.link AS link_3, s0_.date AS date_4, s0_.nbvente AS nbvente_5, s0_.nbproduit AS nbproduit_6, s0_.rang AS rang_7, s0_.src AS src_8, s0_.alt AS alt_9, s0_.user_id AS user_id_10, s0_.categorie_id AS categorie_id_11 FROM souscategorie s0_ ORDER BY s0_.rang ASC SELECT s0_.id AS id_0, s0_.nom AS nom_1, s0_.description AS description_2, s0_.link AS link_3, s0_.date AS date_4, s0_.nbvente AS nbvente_5, s0_.nbproduit AS nbproduit_6, s0_.rang AS rang_7, s0_.src AS src_8, s0_.alt AS alt_9, s0_.user_id AS user_id_10, s0_.categorie_id AS categorie_id_11 FROM souscategorie s0_ ORDER BY s0_.rang ASC;
5	1.20 ms	SELECT COUNT() AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT o0_.id AS id_0, o0_.titre AS titre_1, o0_.date AS date_2, o0_.link AS link_3, o0_.src AS src_4, o0_.alt AS alt_5, o0_.rang AS rang_6, o0_.timestamp AS timestamp_7, p1_.id AS id_8, p1_.nom AS nom_9, p1_.slogan AS slogan_10, p1_.date AS date_11, p1_.nbvisit AS nbvisit_12, p1_.siteweb AS siteweb_13, p1_.email AS email_14, p1_.tel AS tel_15, p1_.telpublic AS telpublic_16, p1_.villetext AS villetext_17, p1_.boutiquemobile AS boutiquemobile_18, p1_.twitter AS twitter_19, p1_.google AS google_20, p1_.linkedin AS linkedin_21, p1_.facebook AS facebook_22, p1_.clicklink AS clicklink_23, p1_.nbpoint AS nbpoint_24, p1_.tcode AS tcode_25, p1_.valide AS valide_26, p1_.inscriptionacheve AS inscriptionacheve_27, p1_.pageprojet AS pageprojet_28, p1_.montantrecu AS montantrecu_29, p1_.binplace AS binplace_30, p1_.nblike AS nblike_31, p1_.nbabonne AS nbabonne_32, p1_.nbconsultation AS nbconsultation_33, p1_.note AS note_34, p1_.nbdon AS nbdon_35, p1_.nbproduit AS nbproduit_36, p1_.profilupload AS profilupload_37 FROM offrespeciale o0_ LEFT JOIN projet p1_ ON o0_.projet_id = p1_.id ORDER BY o0_.date DESC) dctrn_result) dctrn_table Parameters: [] View formatted query View runnable query Explain query SELECT COUNT() AS dctrn_count FROM ( SELECT DISTINCT id_0 FROM ( SELECT o0_.id AS id_0, o0_.titre AS titre_1, o0_.date AS date_2, o0_.link AS link_3, o0_.src AS src_4, o0_.alt AS alt_5, o0_.rang AS rang_6, o0_.timestamp AS timestamp_7, p1_.id AS id_8, p1_.nom AS nom_9, p1_.slogan AS slogan_10, p1_.date AS date_11, p1_.nbvisit AS nbvisit_12, p1_.siteweb AS siteweb_13, p1_.email AS email_14, p1_.tel AS tel_15, p1_.telpublic AS telpublic_16, p1_.villetext AS villetext_17, p1_.boutiquemobile AS boutiquemobile_18, p1_.twitter AS twitter_19, p1_.google AS google_20, p1_.linkedin AS linkedin_21, p1_.facebook AS facebook_22, p1_.clicklink AS clicklink_23, p1_.nbpoint AS nbpoint_24, p1_.tcode AS tcode_25, p1_.valide AS valide_26, p1_.inscriptionacheve AS inscriptionacheve_27, p1_.pageprojet AS pageprojet_28, p1_.montantrecu AS montantrecu_29, p1_.binplace AS binplace_30, p1_.nblike AS nblike_31, p1_.nbabonne AS nbabonne_32, p1_.nbconsultation AS nbconsultation_33, p1_.note AS note_34, p1_.nbdon AS nbdon_35, p1_.nbproduit AS nbproduit_36, p1_.profilupload AS profilupload_37 FROM offrespeciale o0_ LEFT JOIN projet p1_ ON o0_.projet_id = p1_.id ORDER BY o0_.date DESC ) dctrn_result ) dctrn_table SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT o0_.id AS id_0, o0_.titre AS titre_1, o0_.date AS date_2, o0_.link AS link_3, o0_.src AS src_4, o0_.alt AS alt_5, o0_.rang AS rang_6, o0_.timestamp AS timestamp_7, p1_.id AS id_8, p1_.nom AS nom_9, p1_.slogan AS slogan_10, p1_.date AS date_11, p1_.nbvisit AS nbvisit_12, p1_.siteweb AS siteweb_13, p1_.email AS email_14, p1_.tel AS tel_15, p1_.telpublic AS telpublic_16, p1_.villetext AS villetext_17, p1_.boutiquemobile AS boutiquemobile_18, p1_.twitter AS twitter_19, p1_.google AS google_20, p1_.linkedin AS linkedin_21, p1_.facebook AS facebook_22, p1_.clicklink AS clicklink_23, p1_.nbpoint AS nbpoint_24, p1_.tcode AS tcode_25, p1_.valide AS valide_26, p1_.inscriptionacheve AS inscriptionacheve_27, p1_.pageprojet AS pageprojet_28, p1_.montantrecu AS montantrecu_29, p1_.binplace AS binplace_30, p1_.nblike AS nblike_31, p1_.nbabonne AS nbabonne_32, p1_.nbconsultation AS nbconsultation_33, p1_.note AS note_34, p1_.nbdon AS nbdon_35, p1_.nbproduit AS nbproduit_36, p1_.profilupload AS profilupload_37 FROM offrespeciale o0_ LEFT JOIN projet p1_ ON o0_.projet_id = p1_.id ORDER BY o0_.date DESC) dctrn_result) dctrn_table;
6	0.94 ms	SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0, date_2 FROM (SELECT o0_.id AS id_0, o0_.titre AS titre_1, o0_.date AS date_2, o0_.link AS link_3, o0_.src AS src_4, o0_.alt AS alt_5, o0_.rang AS rang_6, o0_.timestamp AS timestamp_7, p1_.id AS id_8, p1_.nom AS nom_9, p1_.slogan AS slogan_10, p1_.date AS date_11, p1_.nbvisit AS nbvisit_12, p1_.siteweb AS siteweb_13, p1_.email AS email_14, p1_.tel AS tel_15, p1_.telpublic AS telpublic_16, p1_.villetext AS villetext_17, p1_.boutiquemobile AS boutiquemobile_18, p1_.twitter AS twitter_19, p1_.google AS google_20, p1_.linkedin AS linkedin_21, p1_.facebook AS facebook_22, p1_.clicklink AS clicklink_23, p1_.nbpoint AS nbpoint_24, p1_.tcode AS tcode_25, p1_.valide AS valide_26, p1_.inscriptionacheve AS inscriptionacheve_27, p1_.pageprojet AS pageprojet_28, p1_.montantrecu AS montantrecu_29, p1_.binplace AS binplace_30, p1_.nblike AS nblike_31, p1_.nbabonne AS nbabonne_32, p1_.nbconsultation AS nbconsultation_33, p1_.note AS note_34, p1_.nbdon AS nbdon_35, p1_.nbproduit AS nbproduit_36, p1_.profilupload AS profilupload_37 FROM offrespeciale o0_ LEFT JOIN projet p1_ ON o0_.projet_id = p1_.id) dctrn_result_inner ORDER BY date_2 DESC) dctrn_result LIMIT 20 Parameters: [] View formatted query View runnable query Explain query SELECT DISTINCT id_0 FROM ( SELECT DISTINCT id_0, date_2 FROM ( SELECT o0_.id AS id_0, o0_.titre AS titre_1, o0_.date AS date_2, o0_.link AS link_3, o0_.src AS src_4, o0_.alt AS alt_5, o0_.rang AS rang_6, o0_.timestamp AS timestamp_7, p1_.id AS id_8, p1_.nom AS nom_9, p1_.slogan AS slogan_10, p1_.date AS date_11, p1_.nbvisit AS nbvisit_12, p1_.siteweb AS siteweb_13, p1_.email AS email_14, p1_.tel AS tel_15, p1_.telpublic AS telpublic_16, p1_.villetext AS villetext_17, p1_.boutiquemobile AS boutiquemobile_18, p1_.twitter AS twitter_19, p1_.google AS google_20, p1_.linkedin AS linkedin_21, p1_.facebook AS facebook_22, p1_.clicklink AS clicklink_23, p1_.nbpoint AS nbpoint_24, p1_.tcode AS tcode_25, p1_.valide AS valide_26, p1_.inscriptionacheve AS inscriptionacheve_27, p1_.pageprojet AS pageprojet_28, p1_.montantrecu AS montantrecu_29, p1_.binplace AS binplace_30, p1_.nblike AS nblike_31, p1_.nbabonne AS nbabonne_32, p1_.nbconsultation AS nbconsultation_33, p1_.note AS note_34, p1_.nbdon AS nbdon_35, p1_.nbproduit AS nbproduit_36, p1_.profilupload AS profilupload_37 FROM offrespeciale o0_ LEFT JOIN projet p1_ ON o0_.projet_id = p1_.id ) dctrn_result_inner ORDER BY date_2 DESC ) dctrn_result LIMIT 20 SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0, date_2 FROM (SELECT o0_.id AS id_0, o0_.titre AS titre_1, o0_.date AS date_2, o0_.link AS link_3, o0_.src AS src_4, o0_.alt AS alt_5, o0_.rang AS rang_6, o0_.timestamp AS timestamp_7, p1_.id AS id_8, p1_.nom AS nom_9, p1_.slogan AS slogan_10, p1_.date AS date_11, p1_.nbvisit AS nbvisit_12, p1_.siteweb AS siteweb_13, p1_.email AS email_14, p1_.tel AS tel_15, p1_.telpublic AS telpublic_16, p1_.villetext AS villetext_17, p1_.boutiquemobile AS boutiquemobile_18, p1_.twitter AS twitter_19, p1_.google AS google_20, p1_.linkedin AS linkedin_21, p1_.facebook AS facebook_22, p1_.clicklink AS clicklink_23, p1_.nbpoint AS nbpoint_24, p1_.tcode AS tcode_25, p1_.valide AS valide_26, p1_.inscriptionacheve AS inscriptionacheve_27, p1_.pageprojet AS pageprojet_28, p1_.montantrecu AS montantrecu_29, p1_.binplace AS binplace_30, p1_.nblike AS nblike_31, p1_.nbabonne AS nbabonne_32, p1_.nbconsultation AS nbconsultation_33, p1_.note AS note_34, p1_.nbdon AS nbdon_35, p1_.nbproduit AS nbproduit_36, p1_.profilupload AS profilupload_37 FROM offrespeciale o0_ LEFT JOIN projet p1_ ON o0_.projet_id = p1_.id) dctrn_result_inner ORDER BY date_2 DESC) dctrn_result LIMIT 20;
7	1.63 ms	SELECT o0_.id AS id_0, o0_.titre AS titre_1, o0_.date AS date_2, o0_.link AS link_3, o0_.src AS src_4, o0_.alt AS alt_5, o0_.rang AS rang_6, o0_.timestamp AS timestamp_7, p1_.id AS id_8, p1_.nom AS nom_9, p1_.slogan AS slogan_10, p1_.date AS date_11, p1_.nbvisit AS nbvisit_12, p1_.siteweb AS siteweb_13, p1_.email AS email_14, p1_.tel AS tel_15, p1_.telpublic AS telpublic_16, p1_.villetext AS villetext_17, p1_.boutiquemobile AS boutiquemobile_18, p1_.twitter AS twitter_19, p1_.google AS google_20, p1_.linkedin AS linkedin_21, p1_.facebook AS facebook_22, p1_.clicklink AS clicklink_23, p1_.nbpoint AS nbpoint_24, p1_.tcode AS tcode_25, p1_.valide AS valide_26, p1_.inscriptionacheve AS inscriptionacheve_27, p1_.pageprojet AS pageprojet_28, p1_.montantrecu AS montantrecu_29, p1_.binplace AS binplace_30, p1_.nblike AS nblike_31, p1_.nbabonne AS nbabonne_32, p1_.nbconsultation AS nbconsultation_33, p1_.note AS note_34, p1_.nbdon AS nbdon_35, p1_.nbproduit AS nbproduit_36, p1_.profilupload AS profilupload_37, o0_.projet_id AS projet_id_38, o0_.souscategorie_id AS souscategorie_id_39, o0_.user_id AS user_id_40, p1_.user_id AS user_id_41, p1_.pays_id AS pays_id_42, p1_.ville_id AS ville_id_43, p1_.typeprojet_id AS typeprojet_id_44 FROM offrespeciale o0_ LEFT JOIN projet p1_ ON o0_.projet_id = p1_.id WHERE o0_.id IN (?) ORDER BY o0_.date DESC Parameters: [`[ 3 2 1 ]`] View formatted query View runnable query Explain query SELECT o0_.id AS id_0, o0_.titre AS titre_1, o0_.date AS date_2, o0_.link AS link_3, o0_.src AS src_4, o0_.alt AS alt_5, o0_.rang AS rang_6, o0_.timestamp AS timestamp_7, p1_.id AS id_8, p1_.nom AS nom_9, p1_.slogan AS slogan_10, p1_.date AS date_11, p1_.nbvisit AS nbvisit_12, p1_.siteweb AS siteweb_13, p1_.email AS email_14, p1_.tel AS tel_15, p1_.telpublic AS telpublic_16, p1_.villetext AS villetext_17, p1_.boutiquemobile AS boutiquemobile_18, p1_.twitter AS twitter_19, p1_.google AS google_20, p1_.linkedin AS linkedin_21, p1_.facebook AS facebook_22, p1_.clicklink AS clicklink_23, p1_.nbpoint AS nbpoint_24, p1_.tcode AS tcode_25, p1_.valide AS valide_26, p1_.inscriptionacheve AS inscriptionacheve_27, p1_.pageprojet AS pageprojet_28, p1_.montantrecu AS montantrecu_29, p1_.binplace AS binplace_30, p1_.nblike AS nblike_31, p1_.nbabonne AS nbabonne_32, p1_.nbconsultation AS nbconsultation_33, p1_.note AS note_34, p1_.nbdon AS nbdon_35, p1_.nbproduit AS nbproduit_36, p1_.profilupload AS profilupload_37, o0_.projet_id AS projet_id_38, o0_.souscategorie_id AS souscategorie_id_39, o0_.user_id AS user_id_40, p1_.user_id AS user_id_41, p1_.pays_id AS pays_id_42, p1_.ville_id AS ville_id_43, p1_.typeprojet_id AS typeprojet_id_44 FROM offrespeciale o0_ LEFT JOIN projet p1_ ON o0_.projet_id = p1_.id WHERE o0_.id IN (?) ORDER BY o0_.date DESC SELECT o0_.id AS id_0, o0_.titre AS titre_1, o0_.date AS date_2, o0_.link AS link_3, o0_.src AS src_4, o0_.alt AS alt_5, o0_.rang AS rang_6, o0_.timestamp AS timestamp_7, p1_.id AS id_8, p1_.nom AS nom_9, p1_.slogan AS slogan_10, p1_.date AS date_11, p1_.nbvisit AS nbvisit_12, p1_.siteweb AS siteweb_13, p1_.email AS email_14, p1_.tel AS tel_15, p1_.telpublic AS telpublic_16, p1_.villetext AS villetext_17, p1_.boutiquemobile AS boutiquemobile_18, p1_.twitter AS twitter_19, p1_.google AS google_20, p1_.linkedin AS linkedin_21, p1_.facebook AS facebook_22, p1_.clicklink AS clicklink_23, p1_.nbpoint AS nbpoint_24, p1_.tcode AS tcode_25, p1_.valide AS valide_26, p1_.inscriptionacheve AS inscriptionacheve_27, p1_.pageprojet AS pageprojet_28, p1_.montantrecu AS montantrecu_29, p1_.binplace AS binplace_30, p1_.nblike AS nblike_31, p1_.nbabonne AS nbabonne_32, p1_.nbconsultation AS nbconsultation_33, p1_.note AS note_34, p1_.nbdon AS nbdon_35, p1_.nbproduit AS nbproduit_36, p1_.profilupload AS profilupload_37, o0_.projet_id AS projet_id_38, o0_.souscategorie_id AS souscategorie_id_39, o0_.user_id AS user_id_40, p1_.user_id AS user_id_41, p1_.pays_id AS pays_id_42, p1_.ville_id AS ville_id_43, p1_.typeprojet_id AS typeprojet_id_44 FROM offrespeciale o0_ LEFT JOIN projet p1_ ON o0_.projet_id = p1_.id WHERE o0_.id IN (3, 2, 1) ORDER BY o0_.date DESC;
8	0.60 ms	SELECT t0.id AS id_1, t0.src AS src_2, t0.alt AS alt_3, t0.projet_id AS projet_id_4 FROM imgprofilprojet t0 WHERE t0.projet_id = ? Parameters: [`1`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.src AS src_2, t0.alt AS alt_3, t0.projet_id AS projet_id_4 FROM imgprofilprojet t0 WHERE t0.projet_id = ? SELECT t0.id AS id_1, t0.src AS src_2, t0.alt AS alt_3, t0.projet_id AS projet_id_4 FROM imgprofilprojet t0 WHERE t0.projet_id = 1;
9	0.34 ms	SELECT t0.id AS id_1, t0.src AS src_2, t0.alt AS alt_3, t0.projet_id AS projet_id_4 FROM imgcouvertureprojet t0 WHERE t0.projet_id = ? Parameters: [`1`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.src AS src_2, t0.alt AS alt_3, t0.projet_id AS projet_id_4 FROM imgcouvertureprojet t0 WHERE t0.projet_id = ? SELECT t0.id AS id_1, t0.src AS src_2, t0.alt AS alt_3, t0.projet_id AS projet_id_4 FROM imgcouvertureprojet t0 WHERE t0.projet_id = 1;
10	0.67 ms	SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0, date_2 FROM (SELECT o0_.id AS id_0, o0_.titre AS titre_1, o0_.date AS date_2, o0_.link AS link_3, o0_.src AS src_4, o0_.alt AS alt_5, o0_.rang AS rang_6, o0_.timestamp AS timestamp_7, p1_.id AS id_8, p1_.nom AS nom_9, p1_.slogan AS slogan_10, p1_.date AS date_11, p1_.nbvisit AS nbvisit_12, p1_.siteweb AS siteweb_13, p1_.email AS email_14, p1_.tel AS tel_15, p1_.telpublic AS telpublic_16, p1_.villetext AS villetext_17, p1_.boutiquemobile AS boutiquemobile_18, p1_.twitter AS twitter_19, p1_.google AS google_20, p1_.linkedin AS linkedin_21, p1_.facebook AS facebook_22, p1_.clicklink AS clicklink_23, p1_.nbpoint AS nbpoint_24, p1_.tcode AS tcode_25, p1_.valide AS valide_26, p1_.inscriptionacheve AS inscriptionacheve_27, p1_.pageprojet AS pageprojet_28, p1_.montantrecu AS montantrecu_29, p1_.binplace AS binplace_30, p1_.nblike AS nblike_31, p1_.nbabonne AS nbabonne_32, p1_.nbconsultation AS nbconsultation_33, p1_.note AS note_34, p1_.nbdon AS nbdon_35, p1_.nbproduit AS nbproduit_36, p1_.profilupload AS profilupload_37 FROM offrespeciale o0_ LEFT JOIN projet p1_ ON o0_.projet_id = p1_.id) dctrn_result_inner ORDER BY date_2 DESC) dctrn_result LIMIT 20 Parameters: [] View formatted query View runnable query Explain query SELECT DISTINCT id_0 FROM ( SELECT DISTINCT id_0, date_2 FROM ( SELECT o0_.id AS id_0, o0_.titre AS titre_1, o0_.date AS date_2, o0_.link AS link_3, o0_.src AS src_4, o0_.alt AS alt_5, o0_.rang AS rang_6, o0_.timestamp AS timestamp_7, p1_.id AS id_8, p1_.nom AS nom_9, p1_.slogan AS slogan_10, p1_.date AS date_11, p1_.nbvisit AS nbvisit_12, p1_.siteweb AS siteweb_13, p1_.email AS email_14, p1_.tel AS tel_15, p1_.telpublic AS telpublic_16, p1_.villetext AS villetext_17, p1_.boutiquemobile AS boutiquemobile_18, p1_.twitter AS twitter_19, p1_.google AS google_20, p1_.linkedin AS linkedin_21, p1_.facebook AS facebook_22, p1_.clicklink AS clicklink_23, p1_.nbpoint AS nbpoint_24, p1_.tcode AS tcode_25, p1_.valide AS valide_26, p1_.inscriptionacheve AS inscriptionacheve_27, p1_.pageprojet AS pageprojet_28, p1_.montantrecu AS montantrecu_29, p1_.binplace AS binplace_30, p1_.nblike AS nblike_31, p1_.nbabonne AS nbabonne_32, p1_.nbconsultation AS nbconsultation_33, p1_.note AS note_34, p1_.nbdon AS nbdon_35, p1_.nbproduit AS nbproduit_36, p1_.profilupload AS profilupload_37 FROM offrespeciale o0_ LEFT JOIN projet p1_ ON o0_.projet_id = p1_.id ) dctrn_result_inner ORDER BY date_2 DESC ) dctrn_result LIMIT 20 SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0, date_2 FROM (SELECT o0_.id AS id_0, o0_.titre AS titre_1, o0_.date AS date_2, o0_.link AS link_3, o0_.src AS src_4, o0_.alt AS alt_5, o0_.rang AS rang_6, o0_.timestamp AS timestamp_7, p1_.id AS id_8, p1_.nom AS nom_9, p1_.slogan AS slogan_10, p1_.date AS date_11, p1_.nbvisit AS nbvisit_12, p1_.siteweb AS siteweb_13, p1_.email AS email_14, p1_.tel AS tel_15, p1_.telpublic AS telpublic_16, p1_.villetext AS villetext_17, p1_.boutiquemobile AS boutiquemobile_18, p1_.twitter AS twitter_19, p1_.google AS google_20, p1_.linkedin AS linkedin_21, p1_.facebook AS facebook_22, p1_.clicklink AS clicklink_23, p1_.nbpoint AS nbpoint_24, p1_.tcode AS tcode_25, p1_.valide AS valide_26, p1_.inscriptionacheve AS inscriptionacheve_27, p1_.pageprojet AS pageprojet_28, p1_.montantrecu AS montantrecu_29, p1_.binplace AS binplace_30, p1_.nblike AS nblike_31, p1_.nbabonne AS nbabonne_32, p1_.nbconsultation AS nbconsultation_33, p1_.note AS note_34, p1_.nbdon AS nbdon_35, p1_.nbproduit AS nbproduit_36, p1_.profilupload AS profilupload_37 FROM offrespeciale o0_ LEFT JOIN projet p1_ ON o0_.projet_id = p1_.id) dctrn_result_inner ORDER BY date_2 DESC) dctrn_result LIMIT 20;
11	0.58 ms	SELECT o0_.id AS id_0, o0_.titre AS titre_1, o0_.date AS date_2, o0_.link AS link_3, o0_.src AS src_4, o0_.alt AS alt_5, o0_.rang AS rang_6, o0_.timestamp AS timestamp_7, p1_.id AS id_8, p1_.nom AS nom_9, p1_.slogan AS slogan_10, p1_.date AS date_11, p1_.nbvisit AS nbvisit_12, p1_.siteweb AS siteweb_13, p1_.email AS email_14, p1_.tel AS tel_15, p1_.telpublic AS telpublic_16, p1_.villetext AS villetext_17, p1_.boutiquemobile AS boutiquemobile_18, p1_.twitter AS twitter_19, p1_.google AS google_20, p1_.linkedin AS linkedin_21, p1_.facebook AS facebook_22, p1_.clicklink AS clicklink_23, p1_.nbpoint AS nbpoint_24, p1_.tcode AS tcode_25, p1_.valide AS valide_26, p1_.inscriptionacheve AS inscriptionacheve_27, p1_.pageprojet AS pageprojet_28, p1_.montantrecu AS montantrecu_29, p1_.binplace AS binplace_30, p1_.nblike AS nblike_31, p1_.nbabonne AS nbabonne_32, p1_.nbconsultation AS nbconsultation_33, p1_.note AS note_34, p1_.nbdon AS nbdon_35, p1_.nbproduit AS nbproduit_36, p1_.profilupload AS profilupload_37, o0_.projet_id AS projet_id_38, o0_.souscategorie_id AS souscategorie_id_39, o0_.user_id AS user_id_40, p1_.user_id AS user_id_41, p1_.pays_id AS pays_id_42, p1_.ville_id AS ville_id_43, p1_.typeprojet_id AS typeprojet_id_44 FROM offrespeciale o0_ LEFT JOIN projet p1_ ON o0_.projet_id = p1_.id WHERE o0_.id IN (?) ORDER BY o0_.date DESC Parameters: [`[ 3 2 1 ]`] View formatted query View runnable query Explain query SELECT o0_.id AS id_0, o0_.titre AS titre_1, o0_.date AS date_2, o0_.link AS link_3, o0_.src AS src_4, o0_.alt AS alt_5, o0_.rang AS rang_6, o0_.timestamp AS timestamp_7, p1_.id AS id_8, p1_.nom AS nom_9, p1_.slogan AS slogan_10, p1_.date AS date_11, p1_.nbvisit AS nbvisit_12, p1_.siteweb AS siteweb_13, p1_.email AS email_14, p1_.tel AS tel_15, p1_.telpublic AS telpublic_16, p1_.villetext AS villetext_17, p1_.boutiquemobile AS boutiquemobile_18, p1_.twitter AS twitter_19, p1_.google AS google_20, p1_.linkedin AS linkedin_21, p1_.facebook AS facebook_22, p1_.clicklink AS clicklink_23, p1_.nbpoint AS nbpoint_24, p1_.tcode AS tcode_25, p1_.valide AS valide_26, p1_.inscriptionacheve AS inscriptionacheve_27, p1_.pageprojet AS pageprojet_28, p1_.montantrecu AS montantrecu_29, p1_.binplace AS binplace_30, p1_.nblike AS nblike_31, p1_.nbabonne AS nbabonne_32, p1_.nbconsultation AS nbconsultation_33, p1_.note AS note_34, p1_.nbdon AS nbdon_35, p1_.nbproduit AS nbproduit_36, p1_.profilupload AS profilupload_37, o0_.projet_id AS projet_id_38, o0_.souscategorie_id AS souscategorie_id_39, o0_.user_id AS user_id_40, p1_.user_id AS user_id_41, p1_.pays_id AS pays_id_42, p1_.ville_id AS ville_id_43, p1_.typeprojet_id AS typeprojet_id_44 FROM offrespeciale o0_ LEFT JOIN projet p1_ ON o0_.projet_id = p1_.id WHERE o0_.id IN (?) ORDER BY o0_.date DESC SELECT o0_.id AS id_0, o0_.titre AS titre_1, o0_.date AS date_2, o0_.link AS link_3, o0_.src AS src_4, o0_.alt AS alt_5, o0_.rang AS rang_6, o0_.timestamp AS timestamp_7, p1_.id AS id_8, p1_.nom AS nom_9, p1_.slogan AS slogan_10, p1_.date AS date_11, p1_.nbvisit AS nbvisit_12, p1_.siteweb AS siteweb_13, p1_.email AS email_14, p1_.tel AS tel_15, p1_.telpublic AS telpublic_16, p1_.villetext AS villetext_17, p1_.boutiquemobile AS boutiquemobile_18, p1_.twitter AS twitter_19, p1_.google AS google_20, p1_.linkedin AS linkedin_21, p1_.facebook AS facebook_22, p1_.clicklink AS clicklink_23, p1_.nbpoint AS nbpoint_24, p1_.tcode AS tcode_25, p1_.valide AS valide_26, p1_.inscriptionacheve AS inscriptionacheve_27, p1_.pageprojet AS pageprojet_28, p1_.montantrecu AS montantrecu_29, p1_.binplace AS binplace_30, p1_.nblike AS nblike_31, p1_.nbabonne AS nbabonne_32, p1_.nbconsultation AS nbconsultation_33, p1_.note AS note_34, p1_.nbdon AS nbdon_35, p1_.nbproduit AS nbproduit_36, p1_.profilupload AS profilupload_37, o0_.projet_id AS projet_id_38, o0_.souscategorie_id AS souscategorie_id_39, o0_.user_id AS user_id_40, p1_.user_id AS user_id_41, p1_.pays_id AS pays_id_42, p1_.ville_id AS ville_id_43, p1_.typeprojet_id AS typeprojet_id_44 FROM offrespeciale o0_ LEFT JOIN projet p1_ ON o0_.projet_id = p1_.id WHERE o0_.id IN (3, 2, 1) ORDER BY o0_.date DESC;
12	0.71 ms	SELECT a0_.id AS id_0, a0_.date AS date_1, a0_.aimer AS aimer_2, a0_.enregistrer AS enregistrer_3, a0_.partager AS partager_4, u1_.id AS id_5, u1_.username AS username_6, u1_.password AS password_7, u1_.salt AS salt_8, u1_.roles AS roles_9, u1_.nom AS nom_10, u1_.poste AS poste_11, u1_.villetext AS villetext_12, u1_.statut AS statut_13, u1_.prenom AS prenom_14, u1_.tel AS tel_15, u1_.tcode AS tcode_16, u1_.email AS email_17, u1_.datenaiss AS datenaiss_18, u1_.publieridentite AS publieridentite_19, u1_.complet AS complet_20, u1_.typeaccount AS typeaccount_21, u1_.adresse AS adresse_22, u1_.sexe AS sexe_23, u1_.nbprojetvue AS nbprojetvue_24, u1_.nbabonne AS nbabonne_25, u1_.nbpubconsulter AS nbpubconsulter_26, u1_.nbabonnement AS nbabonnement_27, u1_.nbabonnementprojet AS nbabonnementprojet_28, u1_.nbvisiteur AS nbvisiteur_29, u1_.projetconnecter AS projetconnecter_30, u1_.nbprojet AS nbprojet_31, u1_.dernierevisite AS dernierevisite_32, u1_.heurearrive AS heurearrive_33, u1_.datebeg AS datebeg_34, u1_.dateinscription AS dateinscription_35, u1_.cni AS cni_36, u1_.puui AS puui_37, u1_.publication AS publication_38, p2_.id AS id_39, p2_.nom AS nom_40, p2_.contenu AS contenu_41, p2_.description AS description_42, p2_.date AS date_43, p2_.nbvote AS nbvote_44, p2_.totalnote AS totalnote_45, p2_.nblike AS nblike_46, p2_.nbenregistrer AS nbenregistrer_47, p2_.nbpartage AS nbpartage_48, p2_.nbvente AS nbvente_49, p2_.nbpoint AS nbpoint_50, p2_.nbpiece AS nbpiece_51, p2_.produitdetail AS produitdetail_52, p2_.valide AS valide_53, p2_.recommander AS recommander_54, p2_.newprise AS newprise_55, p2_.lastprise AS lastprise_56, p2_.difference AS difference_57, p2_.prixlivraison AS prixlivraison_58, p2_.prod_number AS prod_number_59, a0_.user_id AS user_id_60, a0_.produit_id AS produit_id_61, u1_.pays_id AS pays_id_62, p2_.user_id AS user_id_63, p2_.souscategorie_id AS souscategorie_id_64, p2_.marqueproduit_id AS marqueproduit_id_65, p2_.produitgro_id AS produitgro_id_66 FROM animationproduit a0_ LEFT JOIN user u1_ ON a0_.user_id = u1_.id LEFT JOIN produit p2_ ON a0_.produit_id = p2_.id WHERE a0_.enregistrer = 1 ORDER BY a0_.date DESC LIMIT 10 Parameters: [] View formatted query View runnable query Explain query SELECT a0_.id AS id_0, a0_.date AS date_1, a0_.aimer AS aimer_2, a0_.enregistrer AS enregistrer_3, a0_.partager AS partager_4, u1_.id AS id_5, u1_.username AS username_6, u1_.password AS password_7, u1_.salt AS salt_8, u1_.roles AS roles_9, u1_.nom AS nom_10, u1_.poste AS poste_11, u1_.villetext AS villetext_12, u1_.statut AS statut_13, u1_.prenom AS prenom_14, u1_.tel AS tel_15, u1_.tcode AS tcode_16, u1_.email AS email_17, u1_.datenaiss AS datenaiss_18, u1_.publieridentite AS publieridentite_19, u1_.complet AS complet_20, u1_.typeaccount AS typeaccount_21, u1_.adresse AS adresse_22, u1_.sexe AS sexe_23, u1_.nbprojetvue AS nbprojetvue_24, u1_.nbabonne AS nbabonne_25, u1_.nbpubconsulter AS nbpubconsulter_26, u1_.nbabonnement AS nbabonnement_27, u1_.nbabonnementprojet AS nbabonnementprojet_28, u1_.nbvisiteur AS nbvisiteur_29, u1_.projetconnecter AS projetconnecter_30, u1_.nbprojet AS nbprojet_31, u1_.dernierevisite AS dernierevisite_32, u1_.heurearrive AS heurearrive_33, u1_.datebeg AS datebeg_34, u1_.dateinscription AS dateinscription_35, u1_.cni AS cni_36, u1_.puui AS puui_37, u1_.publication AS publication_38, p2_.id AS id_39, p2_.nom AS nom_40, p2_.contenu AS contenu_41, p2_.description AS description_42, p2_.date AS date_43, p2_.nbvote AS nbvote_44, p2_.totalnote AS totalnote_45, p2_.nblike AS nblike_46, p2_.nbenregistrer AS nbenregistrer_47, p2_.nbpartage AS nbpartage_48, p2_.nbvente AS nbvente_49, p2_.nbpoint AS nbpoint_50, p2_.nbpiece AS nbpiece_51, p2_.produitdetail AS produitdetail_52, p2_.valide AS valide_53, p2_.recommander AS recommander_54, p2_.newprise AS newprise_55, p2_.lastprise AS lastprise_56, p2_.difference AS difference_57, p2_.prixlivraison AS prixlivraison_58, p2_.prod_number AS prod_number_59, a0_.user_id AS user_id_60, a0_.produit_id AS produit_id_61, u1_.pays_id AS pays_id_62, p2_.user_id AS user_id_63, p2_.souscategorie_id AS souscategorie_id_64, p2_.marqueproduit_id AS marqueproduit_id_65, p2_.produitgro_id AS produitgro_id_66 FROM animationproduit a0_ LEFT JOIN user u1_ ON a0_.user_id = u1_.id LEFT JOIN produit p2_ ON a0_.produit_id = p2_.id WHERE a0_.enregistrer = 1 ORDER BY a0_.date DESC LIMIT 10 SELECT a0_.id AS id_0, a0_.date AS date_1, a0_.aimer AS aimer_2, a0_.enregistrer AS enregistrer_3, a0_.partager AS partager_4, u1_.id AS id_5, u1_.username AS username_6, u1_.password AS password_7, u1_.salt AS salt_8, u1_.roles AS roles_9, u1_.nom AS nom_10, u1_.poste AS poste_11, u1_.villetext AS villetext_12, u1_.statut AS statut_13, u1_.prenom AS prenom_14, u1_.tel AS tel_15, u1_.tcode AS tcode_16, u1_.email AS email_17, u1_.datenaiss AS datenaiss_18, u1_.publieridentite AS publieridentite_19, u1_.complet AS complet_20, u1_.typeaccount AS typeaccount_21, u1_.adresse AS adresse_22, u1_.sexe AS sexe_23, u1_.nbprojetvue AS nbprojetvue_24, u1_.nbabonne AS nbabonne_25, u1_.nbpubconsulter AS nbpubconsulter_26, u1_.nbabonnement AS nbabonnement_27, u1_.nbabonnementprojet AS nbabonnementprojet_28, u1_.nbvisiteur AS nbvisiteur_29, u1_.projetconnecter AS projetconnecter_30, u1_.nbprojet AS nbprojet_31, u1_.dernierevisite AS dernierevisite_32, u1_.heurearrive AS heurearrive_33, u1_.datebeg AS datebeg_34, u1_.dateinscription AS dateinscription_35, u1_.cni AS cni_36, u1_.puui AS puui_37, u1_.publication AS publication_38, p2_.id AS id_39, p2_.nom AS nom_40, p2_.contenu AS contenu_41, p2_.description AS description_42, p2_.date AS date_43, p2_.nbvote AS nbvote_44, p2_.totalnote AS totalnote_45, p2_.nblike AS nblike_46, p2_.nbenregistrer AS nbenregistrer_47, p2_.nbpartage AS nbpartage_48, p2_.nbvente AS nbvente_49, p2_.nbpoint AS nbpoint_50, p2_.nbpiece AS nbpiece_51, p2_.produitdetail AS produitdetail_52, p2_.valide AS valide_53, p2_.recommander AS recommander_54, p2_.newprise AS newprise_55, p2_.lastprise AS lastprise_56, p2_.difference AS difference_57, p2_.prixlivraison AS prixlivraison_58, p2_.prod_number AS prod_number_59, a0_.user_id AS user_id_60, a0_.produit_id AS produit_id_61, u1_.pays_id AS pays_id_62, p2_.user_id AS user_id_63, p2_.souscategorie_id AS souscategorie_id_64, p2_.marqueproduit_id AS marqueproduit_id_65, p2_.produitgro_id AS produitgro_id_66 FROM animationproduit a0_ LEFT JOIN user u1_ ON a0_.user_id = u1_.id LEFT JOIN produit p2_ ON a0_.produit_id = p2_.id WHERE a0_.enregistrer = 1 ORDER BY a0_.date DESC LIMIT 10;
13	0.71 ms	SELECT t0.id AS id_1, t0.date AS date_2, t0.domaine AS domaine_3, t0.payer AS payer_4, t0.livrer AS livrer_5, t0.panierdachat AS panierdachat_6, t0.coastlivraison AS coastlivraison_7, t0.sousmis AS sousmis_8, t0.online_panier AS online_panier_9, t0.local_panier AS local_panier_10, t0.reconcilier AS reconcilier_11, t0.reconciliertresor AS reconciliertresor_12, t0.montantht AS montantht_13, t0.montantttc AS montantttc_14, t0.prisetotal AS prisetotal_15, t0.versementtresor AS versementtresor_16, t0.livraisonpayer AS livraisonpayer_17, t0.tel AS tel_18, t0.destination AS destination_19, t0.user_id AS user_id_20, t0.auteur_id AS auteur_id_21, t0.service_id AS service_id_22, t0.projet_id AS projet_id_23, t0.projetmobile_id AS projetmobile_id_24, t0.client_id AS client_id_25, t0.commercial_id AS commercial_id_26, t0.firstpanier_id AS firstpanier_id_27, t0.ville_id AS ville_id_28, t0.affilier_id AS affilier_id_29, t0.couponcard_id AS couponcard_id_30, t0.contact_id AS contact_id_31 FROM panier t0 WHERE t0.id = ? AND t0.sousmis = ? LIMIT 1 Parameters: [`0 0`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.date AS date_2, t0.domaine AS domaine_3, t0.payer AS payer_4, t0.livrer AS livrer_5, t0.panierdachat AS panierdachat_6, t0.coastlivraison AS coastlivraison_7, t0.sousmis AS sousmis_8, t0.online_panier AS online_panier_9, t0.local_panier AS local_panier_10, t0.reconcilier AS reconcilier_11, t0.reconciliertresor AS reconciliertresor_12, t0.montantht AS montantht_13, t0.montantttc AS montantttc_14, t0.prisetotal AS prisetotal_15, t0.versementtresor AS versementtresor_16, t0.livraisonpayer AS livraisonpayer_17, t0.tel AS tel_18, t0.destination AS destination_19, t0.user_id AS user_id_20, t0.auteur_id AS auteur_id_21, t0.service_id AS service_id_22, t0.projet_id AS projet_id_23, t0.projetmobile_id AS projetmobile_id_24, t0.client_id AS client_id_25, t0.commercial_id AS commercial_id_26, t0.firstpanier_id AS firstpanier_id_27, t0.ville_id AS ville_id_28, t0.affilier_id AS affilier_id_29, t0.couponcard_id AS couponcard_id_30, t0.contact_id AS contact_id_31 FROM panier t0 WHERE t0.id = ? AND t0.sousmis = ? LIMIT 1 SELECT t0.id AS id_1, t0.date AS date_2, t0.domaine AS domaine_3, t0.payer AS payer_4, t0.livrer AS livrer_5, t0.panierdachat AS panierdachat_6, t0.coastlivraison AS coastlivraison_7, t0.sousmis AS sousmis_8, t0.online_panier AS online_panier_9, t0.local_panier AS local_panier_10, t0.reconcilier AS reconcilier_11, t0.reconciliertresor AS reconciliertresor_12, t0.montantht AS montantht_13, t0.montantttc AS montantttc_14, t0.prisetotal AS prisetotal_15, t0.versementtresor AS versementtresor_16, t0.livraisonpayer AS livraisonpayer_17, t0.tel AS tel_18, t0.destination AS destination_19, t0.user_id AS user_id_20, t0.auteur_id AS auteur_id_21, t0.service_id AS service_id_22, t0.projet_id AS projet_id_23, t0.projetmobile_id AS projetmobile_id_24, t0.client_id AS client_id_25, t0.commercial_id AS commercial_id_26, t0.firstpanier_id AS firstpanier_id_27, t0.ville_id AS ville_id_28, t0.affilier_id AS affilier_id_29, t0.couponcard_id AS couponcard_id_30, t0.contact_id AS contact_id_31 FROM panier t0 WHERE t0.id = 0 AND t0.sousmis = 0 LIMIT 1;
14	0.57 ms	SELECT t0.id AS id_1, t0.type AS type_2, t0.valeur AS valeur_3, t0.link AS link_4, t0.description AS description_5, t0.date AS date_6, t0.rang AS rang_7, t0.src AS src_8, t0.alt AS alt_9, t0.user_id AS user_id_10 FROM parametreadmin t0 WHERE t0.type = ? LIMIT 1 Parameters: [`"aproposaccueil"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.type AS type_2, t0.valeur AS valeur_3, t0.link AS link_4, t0.description AS description_5, t0.date AS date_6, t0.rang AS rang_7, t0.src AS src_8, t0.alt AS alt_9, t0.user_id AS user_id_10 FROM parametreadmin t0 WHERE t0.type = ? LIMIT 1 SELECT t0.id AS id_1, t0.type AS type_2, t0.valeur AS valeur_3, t0.link AS link_4, t0.description AS description_5, t0.date AS date_6, t0.rang AS rang_7, t0.src AS src_8, t0.alt AS alt_9, t0.user_id AS user_id_10 FROM parametreadmin t0 WHERE t0.type = 'aproposaccueil' LIMIT 1;
15	0.60 ms	SELECT m0_.id AS id_0, m0_.nom AS nom_1, m0_.description AS description_2, m0_.rang AS rang_3, m0_.src AS src_4, m0_.alt AS alt_5 FROM marqueproduit m0_ ORDER BY m0_.rang ASC Parameters: [] View formatted query View runnable query Explain query SELECT m0_.id AS id_0, m0_.nom AS nom_1, m0_.description AS description_2, m0_.rang AS rang_3, m0_.src AS src_4, m0_.alt AS alt_5 FROM marqueproduit m0_ ORDER BY m0_.rang ASC SELECT m0_.id AS id_0, m0_.nom AS nom_1, m0_.description AS description_2, m0_.rang AS rang_3, m0_.src AS src_4, m0_.alt AS alt_5 FROM marqueproduit m0_ ORDER BY m0_.rang ASC;
16	1.22 ms	SELECT p0_.id AS id_0, p0_.nom AS nom_1, p0_.contenu AS contenu_2, p0_.description AS description_3, p0_.date AS date_4, p0_.nbvote AS nbvote_5, p0_.totalnote AS totalnote_6, p0_.nblike AS nblike_7, p0_.nbenregistrer AS nbenregistrer_8, p0_.nbpartage AS nbpartage_9, p0_.nbvente AS nbvente_10, p0_.nbpoint AS nbpoint_11, p0_.nbpiece AS nbpiece_12, p0_.produitdetail AS produitdetail_13, p0_.valide AS valide_14, p0_.recommander AS recommander_15, p0_.newprise AS newprise_16, p0_.lastprise AS lastprise_17, p0_.difference AS difference_18, p0_.prixlivraison AS prixlivraison_19, p0_.prod_number AS prod_number_20, s1_.id AS id_21, s1_.nom AS nom_22, s1_.description AS description_23, s1_.link AS link_24, s1_.date AS date_25, s1_.nbvente AS nbvente_26, s1_.nbproduit AS nbproduit_27, s1_.rang AS rang_28, s1_.src AS src_29, s1_.alt AS alt_30, p0_.user_id AS user_id_31, p0_.souscategorie_id AS souscategorie_id_32, p0_.marqueproduit_id AS marqueproduit_id_33, p0_.produitgro_id AS produitgro_id_34, s1_.user_id AS user_id_35, s1_.categorie_id AS categorie_id_36 FROM produit p0_ LEFT JOIN souscategorie s1_ ON p0_.souscategorie_id = s1_.id ORDER BY p0_.date DESC LIMIT 10 Parameters: [] View formatted query View runnable query Explain query SELECT p0_.id AS id_0, p0_.nom AS nom_1, p0_.contenu AS contenu_2, p0_.description AS description_3, p0_.date AS date_4, p0_.nbvote AS nbvote_5, p0_.totalnote AS totalnote_6, p0_.nblike AS nblike_7, p0_.nbenregistrer AS nbenregistrer_8, p0_.nbpartage AS nbpartage_9, p0_.nbvente AS nbvente_10, p0_.nbpoint AS nbpoint_11, p0_.nbpiece AS nbpiece_12, p0_.produitdetail AS produitdetail_13, p0_.valide AS valide_14, p0_.recommander AS recommander_15, p0_.newprise AS newprise_16, p0_.lastprise AS lastprise_17, p0_.difference AS difference_18, p0_.prixlivraison AS prixlivraison_19, p0_.prod_number AS prod_number_20, s1_.id AS id_21, s1_.nom AS nom_22, s1_.description AS description_23, s1_.link AS link_24, s1_.date AS date_25, s1_.nbvente AS nbvente_26, s1_.nbproduit AS nbproduit_27, s1_.rang AS rang_28, s1_.src AS src_29, s1_.alt AS alt_30, p0_.user_id AS user_id_31, p0_.souscategorie_id AS souscategorie_id_32, p0_.marqueproduit_id AS marqueproduit_id_33, p0_.produitgro_id AS produitgro_id_34, s1_.user_id AS user_id_35, s1_.categorie_id AS categorie_id_36 FROM produit p0_ LEFT JOIN souscategorie s1_ ON p0_.souscategorie_id = s1_.id ORDER BY p0_.date DESC LIMIT 10 SELECT p0_.id AS id_0, p0_.nom AS nom_1, p0_.contenu AS contenu_2, p0_.description AS description_3, p0_.date AS date_4, p0_.nbvote AS nbvote_5, p0_.totalnote AS totalnote_6, p0_.nblike AS nblike_7, p0_.nbenregistrer AS nbenregistrer_8, p0_.nbpartage AS nbpartage_9, p0_.nbvente AS nbvente_10, p0_.nbpoint AS nbpoint_11, p0_.nbpiece AS nbpiece_12, p0_.produitdetail AS produitdetail_13, p0_.valide AS valide_14, p0_.recommander AS recommander_15, p0_.newprise AS newprise_16, p0_.lastprise AS lastprise_17, p0_.difference AS difference_18, p0_.prixlivraison AS prixlivraison_19, p0_.prod_number AS prod_number_20, s1_.id AS id_21, s1_.nom AS nom_22, s1_.description AS description_23, s1_.link AS link_24, s1_.date AS date_25, s1_.nbvente AS nbvente_26, s1_.nbproduit AS nbproduit_27, s1_.rang AS rang_28, s1_.src AS src_29, s1_.alt AS alt_30, p0_.user_id AS user_id_31, p0_.souscategorie_id AS souscategorie_id_32, p0_.marqueproduit_id AS marqueproduit_id_33, p0_.produitgro_id AS produitgro_id_34, s1_.user_id AS user_id_35, s1_.categorie_id AS categorie_id_36 FROM produit p0_ LEFT JOIN souscategorie s1_ ON p0_.souscategorie_id = s1_.id ORDER BY p0_.date DESC LIMIT 10;
17	0.63 ms	SELECT t0.id AS id_1, t0.type AS type_2, t0.valeur AS valeur_3, t0.link AS link_4, t0.description AS description_5, t0.date AS date_6, t0.rang AS rang_7, t0.src AS src_8, t0.alt AS alt_9, t0.user_id AS user_id_10 FROM parametreadmin t0 WHERE t0.type = ? LIMIT 1 Parameters: [`"templatewebsite"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.type AS type_2, t0.valeur AS valeur_3, t0.link AS link_4, t0.description AS description_5, t0.date AS date_6, t0.rang AS rang_7, t0.src AS src_8, t0.alt AS alt_9, t0.user_id AS user_id_10 FROM parametreadmin t0 WHERE t0.type = ? LIMIT 1 SELECT t0.id AS id_1, t0.type AS type_2, t0.valeur AS valeur_3, t0.link AS link_4, t0.description AS description_5, t0.date AS date_6, t0.rang AS rang_7, t0.src AS src_8, t0.alt AS alt_9, t0.user_id AS user_id_10 FROM parametreadmin t0 WHERE t0.type = 'templatewebsite' LIMIT 1;
18	0.40 ms	SELECT t0.id AS id_1, t0.type AS type_2, t0.valeur AS valeur_3, t0.link AS link_4, t0.description AS description_5, t0.date AS date_6, t0.rang AS rang_7, t0.src AS src_8, t0.alt AS alt_9, t0.user_id AS user_id_10 FROM parametreadmin t0 WHERE t0.type = ? LIMIT 1 Parameters: [`"logosm"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.type AS type_2, t0.valeur AS valeur_3, t0.link AS link_4, t0.description AS description_5, t0.date AS date_6, t0.rang AS rang_7, t0.src AS src_8, t0.alt AS alt_9, t0.user_id AS user_id_10 FROM parametreadmin t0 WHERE t0.type = ? LIMIT 1 SELECT t0.id AS id_1, t0.type AS type_2, t0.valeur AS valeur_3, t0.link AS link_4, t0.description AS description_5, t0.date AS date_6, t0.rang AS rang_7, t0.src AS src_8, t0.alt AS alt_9, t0.user_id AS user_id_10 FROM parametreadmin t0 WHERE t0.type = 'logosm' LIMIT 1;
19	0.51 ms	SELECT t0.id AS id_1, t0.type AS type_2, t0.valeur AS valeur_3, t0.link AS link_4, t0.description AS description_5, t0.date AS date_6, t0.rang AS rang_7, t0.src AS src_8, t0.alt AS alt_9, t0.user_id AS user_id_10 FROM parametreadmin t0 WHERE t0.type = ? LIMIT 1 Parameters: [`"templatewebsite"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.type AS type_2, t0.valeur AS valeur_3, t0.link AS link_4, t0.description AS description_5, t0.date AS date_6, t0.rang AS rang_7, t0.src AS src_8, t0.alt AS alt_9, t0.user_id AS user_id_10 FROM parametreadmin t0 WHERE t0.type = ? LIMIT 1 SELECT t0.id AS id_1, t0.type AS type_2, t0.valeur AS valeur_3, t0.link AS link_4, t0.description AS description_5, t0.date AS date_6, t0.rang AS rang_7, t0.src AS src_8, t0.alt AS alt_9, t0.user_id AS user_id_10 FROM parametreadmin t0 WHERE t0.type = 'templatewebsite' LIMIT 1;
20	1.73 ms	SHOW FULL TABLES WHERE Table_type = 'BASE TABLE' Parameters: [] View formatted query View runnable query Explain query SHOW FULL TABLES WHERE Table_type = 'BASE TABLE' SHOW FULL TABLES WHERE Table_type = 'BASE TABLE';
21	1.41 ms	SHOW FULL TABLES WHERE Table_type = 'BASE TABLE' Parameters: [] View formatted query View runnable query Explain query SHOW FULL TABLES WHERE Table_type = 'BASE TABLE' SHOW FULL TABLES WHERE Table_type = 'BASE TABLE';
22	0.89 ms	SELECT COLUMN_NAME AS Field, COLUMN_TYPE AS Type, IS_NULLABLE AS `Null`, COLUMN_KEY AS `Key`, COLUMN_DEFAULT AS `Default`, EXTRA AS Extra, COLUMN_COMMENT AS Comment, CHARACTER_SET_NAME AS CharacterSet, COLLATION_NAME AS Collation FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = 'mbill' AND TABLE_NAME = 'doctrine_migration_versions' ORDER BY ORDINAL_POSITION ASC Parameters: [] View formatted query View runnable query Explain query SELECT COLUMN_NAME AS Field, COLUMN_TYPE AS Type, IS_NULLABLE AS `Null`, COLUMN_KEY AS `Key`, COLUMN_DEFAULT AS `Default`, EXTRA AS Extra, COLUMN_COMMENT AS Comment, CHARACTER_SET_NAME AS CharacterSet, COLLATION_NAME AS Collation FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = 'mbill' AND TABLE_NAME = 'doctrine_migration_versions' ORDER BY ORDINAL_POSITION ASC SELECT COLUMN_NAME AS Field, COLUMN_TYPE AS Type, IS_NULLABLE AS `Null`, COLUMN_KEY AS `Key`, COLUMN_DEFAULT AS `Default`, EXTRA AS Extra, COLUMN_COMMENT AS Comment, CHARACTER_SET_NAME AS CharacterSet, COLLATION_NAME AS Collation FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = 'mbill' AND TABLE_NAME = 'doctrine_migration_versions' ORDER BY ORDINAL_POSITION ASC;
23	0.50 ms	SELECT DISTINCT k.`CONSTRAINT_NAME`, k.`COLUMN_NAME`, k.`REFERENCED_TABLE_NAME`, k.`REFERENCED_COLUMN_NAME` /!50116 , c.update_rule, c.delete_rule / FROM information_schema.key_column_usage k /!50116 INNER JOIN information_schema.referential_constraints c ON c.constraint_name = k.constraint_name AND c.table_name = 'doctrine_migration_versions' / WHERE k.table_name = 'doctrine_migration_versions' AND k.table_schema = 'mbill' /!50116 AND c.constraint_schema = 'mbill' / AND k.`REFERENCED_COLUMN_NAME` is not NULL Parameters: [] View formatted query View runnable query Explain query SELECT DISTINCT k.`CONSTRAINT_NAME`, k.`COLUMN_NAME`, k.`REFERENCED_TABLE_NAME`, k.`REFERENCED_COLUMN_NAME` /!50116 , c.update_rule, c.delete_rule / FROM information_schema.key_column_usage k /!50116 INNER JOIN information_schema.referential_constraints c ON c.constraint_name = k.constraint_name AND c.table_name = 'doctrine_migration_versions' / WHERE k.table_name = 'doctrine_migration_versions' AND k.table_schema = 'mbill' /!50116 AND c.constraint_schema = 'mbill' / AND k.`REFERENCED_COLUMN_NAME` is not NULL SELECT DISTINCT k.`CONSTRAINT_NAME`, k.`COLUMN_NAME`, k.`REFERENCED_TABLE_NAME`, k.`REFERENCED_COLUMN_NAME` /!50116 , c.update_rule, c.delete_rule / FROM information_schema.key_column_usage k /!50116 INNER JOIN information_schema.referential_constraints c ON c.constraint_name = k.constraint_name AND c.table_name = 'doctrine_migration_versions' / WHERE k.table_name = 'doctrine_migration_versions' AND k.table_schema = 'mbill' /!50116 AND c.constraint_schema = 'mbill' / AND k.`REFERENCED_COLUMN_NAME` is not NULL;
24	0.35 ms	SELECT NON_UNIQUE AS Non_Unique, INDEX_NAME AS Key_name, COLUMN_NAME AS Column_Name, SUB_PART AS Sub_Part, INDEX_TYPE AS Index_Type FROM information_schema.STATISTICS WHERE TABLE_NAME = 'doctrine_migration_versions' AND TABLE_SCHEMA = 'mbill' ORDER BY SEQ_IN_INDEX ASC Parameters: [] View formatted query View runnable query Explain query SELECT NON_UNIQUE AS Non_Unique, INDEX_NAME AS Key_name, COLUMN_NAME AS Column_Name, SUB_PART AS Sub_Part, INDEX_TYPE AS Index_Type FROM information_schema.STATISTICS WHERE TABLE_NAME = 'doctrine_migration_versions' AND TABLE_SCHEMA = 'mbill' ORDER BY SEQ_IN_INDEX ASC SELECT NON_UNIQUE AS Non_Unique, INDEX_NAME AS Key_name, COLUMN_NAME AS Column_Name, SUB_PART AS Sub_Part, INDEX_TYPE AS Index_Type FROM information_schema.STATISTICS WHERE TABLE_NAME = 'doctrine_migration_versions' AND TABLE_SCHEMA = 'mbill' ORDER BY SEQ_IN_INDEX ASC;
25	0.38 ms	SELECT ENGINE, AUTO_INCREMENT, TABLE_COLLATION, TABLE_COMMENT, CREATE_OPTIONS FROM information_schema.TABLES WHERE TABLE_TYPE = 'BASE TABLE' AND TABLE_SCHEMA = DATABASE() AND TABLE_NAME = 'doctrine_migration_versions' Parameters: [] View formatted query View runnable query Explain query SELECT ENGINE, AUTO_INCREMENT, TABLE_COLLATION, TABLE_COMMENT, CREATE_OPTIONS FROM information_schema.TABLES WHERE TABLE_TYPE = 'BASE TABLE' AND TABLE_SCHEMA = DATABASE() AND TABLE_NAME = 'doctrine_migration_versions' SELECT ENGINE, AUTO_INCREMENT, TABLE_COLLATION, TABLE_COMMENT, CREATE_OPTIONS FROM information_schema.TABLES WHERE TABLE_TYPE = 'BASE TABLE' AND TABLE_SCHEMA = DATABASE() AND TABLE_NAME = 'doctrine_migration_versions';
26	0.24 ms	SELECT * FROM doctrine_migration_versions Parameters: [] View formatted query View runnable query Explain query SELECT * FROM doctrine_migration_versions SELECT * FROM doctrine_migration_versions;
27	1.26 ms	SHOW FULL TABLES WHERE Table_type = 'BASE TABLE' Parameters: [] View formatted query View runnable query Explain query SHOW FULL TABLES WHERE Table_type = 'BASE TABLE' SHOW FULL TABLES WHERE Table_type = 'BASE TABLE';
28	0.99 ms	SHOW FULL TABLES WHERE Table_type = 'BASE TABLE' Parameters: [] View formatted query View runnable query Explain query SHOW FULL TABLES WHERE Table_type = 'BASE TABLE' SHOW FULL TABLES WHERE Table_type = 'BASE TABLE';
29	1.15 ms	SELECT COLUMN_NAME AS Field, COLUMN_TYPE AS Type, IS_NULLABLE AS `Null`, COLUMN_KEY AS `Key`, COLUMN_DEFAULT AS `Default`, EXTRA AS Extra, COLUMN_COMMENT AS Comment, CHARACTER_SET_NAME AS CharacterSet, COLLATION_NAME AS Collation FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = 'mbill' AND TABLE_NAME = 'doctrine_migration_versions' ORDER BY ORDINAL_POSITION ASC Parameters: [] View formatted query View runnable query Explain query SELECT COLUMN_NAME AS Field, COLUMN_TYPE AS Type, IS_NULLABLE AS `Null`, COLUMN_KEY AS `Key`, COLUMN_DEFAULT AS `Default`, EXTRA AS Extra, COLUMN_COMMENT AS Comment, CHARACTER_SET_NAME AS CharacterSet, COLLATION_NAME AS Collation FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = 'mbill' AND TABLE_NAME = 'doctrine_migration_versions' ORDER BY ORDINAL_POSITION ASC SELECT COLUMN_NAME AS Field, COLUMN_TYPE AS Type, IS_NULLABLE AS `Null`, COLUMN_KEY AS `Key`, COLUMN_DEFAULT AS `Default`, EXTRA AS Extra, COLUMN_COMMENT AS Comment, CHARACTER_SET_NAME AS CharacterSet, COLLATION_NAME AS Collation FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = 'mbill' AND TABLE_NAME = 'doctrine_migration_versions' ORDER BY ORDINAL_POSITION ASC;
30	0.59 ms	SELECT DISTINCT k.`CONSTRAINT_NAME`, k.`COLUMN_NAME`, k.`REFERENCED_TABLE_NAME`, k.`REFERENCED_COLUMN_NAME` /!50116 , c.update_rule, c.delete_rule / FROM information_schema.key_column_usage k /!50116 INNER JOIN information_schema.referential_constraints c ON c.constraint_name = k.constraint_name AND c.table_name = 'doctrine_migration_versions' / WHERE k.table_name = 'doctrine_migration_versions' AND k.table_schema = 'mbill' /!50116 AND c.constraint_schema = 'mbill' / AND k.`REFERENCED_COLUMN_NAME` is not NULL Parameters: [] View formatted query View runnable query Explain query SELECT DISTINCT k.`CONSTRAINT_NAME`, k.`COLUMN_NAME`, k.`REFERENCED_TABLE_NAME`, k.`REFERENCED_COLUMN_NAME` /!50116 , c.update_rule, c.delete_rule / FROM information_schema.key_column_usage k /!50116 INNER JOIN information_schema.referential_constraints c ON c.constraint_name = k.constraint_name AND c.table_name = 'doctrine_migration_versions' / WHERE k.table_name = 'doctrine_migration_versions' AND k.table_schema = 'mbill' /!50116 AND c.constraint_schema = 'mbill' / AND k.`REFERENCED_COLUMN_NAME` is not NULL SELECT DISTINCT k.`CONSTRAINT_NAME`, k.`COLUMN_NAME`, k.`REFERENCED_TABLE_NAME`, k.`REFERENCED_COLUMN_NAME` /!50116 , c.update_rule, c.delete_rule / FROM information_schema.key_column_usage k /!50116 INNER JOIN information_schema.referential_constraints c ON c.constraint_name = k.constraint_name AND c.table_name = 'doctrine_migration_versions' / WHERE k.table_name = 'doctrine_migration_versions' AND k.table_schema = 'mbill' /!50116 AND c.constraint_schema = 'mbill' / AND k.`REFERENCED_COLUMN_NAME` is not NULL;
31	0.45 ms	SELECT NON_UNIQUE AS Non_Unique, INDEX_NAME AS Key_name, COLUMN_NAME AS Column_Name, SUB_PART AS Sub_Part, INDEX_TYPE AS Index_Type FROM information_schema.STATISTICS WHERE TABLE_NAME = 'doctrine_migration_versions' AND TABLE_SCHEMA = 'mbill' ORDER BY SEQ_IN_INDEX ASC Parameters: [] View formatted query View runnable query Explain query SELECT NON_UNIQUE AS Non_Unique, INDEX_NAME AS Key_name, COLUMN_NAME AS Column_Name, SUB_PART AS Sub_Part, INDEX_TYPE AS Index_Type FROM information_schema.STATISTICS WHERE TABLE_NAME = 'doctrine_migration_versions' AND TABLE_SCHEMA = 'mbill' ORDER BY SEQ_IN_INDEX ASC SELECT NON_UNIQUE AS Non_Unique, INDEX_NAME AS Key_name, COLUMN_NAME AS Column_Name, SUB_PART AS Sub_Part, INDEX_TYPE AS Index_Type FROM information_schema.STATISTICS WHERE TABLE_NAME = 'doctrine_migration_versions' AND TABLE_SCHEMA = 'mbill' ORDER BY SEQ_IN_INDEX ASC;
32	0.51 ms	SELECT ENGINE, AUTO_INCREMENT, TABLE_COLLATION, TABLE_COMMENT, CREATE_OPTIONS FROM information_schema.TABLES WHERE TABLE_TYPE = 'BASE TABLE' AND TABLE_SCHEMA = DATABASE() AND TABLE_NAME = 'doctrine_migration_versions' Parameters: [] View formatted query View runnable query Explain query SELECT ENGINE, AUTO_INCREMENT, TABLE_COLLATION, TABLE_COMMENT, CREATE_OPTIONS FROM information_schema.TABLES WHERE TABLE_TYPE = 'BASE TABLE' AND TABLE_SCHEMA = DATABASE() AND TABLE_NAME = 'doctrine_migration_versions' SELECT ENGINE, AUTO_INCREMENT, TABLE_COLLATION, TABLE_COMMENT, CREATE_OPTIONS FROM information_schema.TABLES WHERE TABLE_TYPE = 'BASE TABLE' AND TABLE_SCHEMA = DATABASE() AND TABLE_NAME = 'doctrine_migration_versions';
33	0.32 ms	SELECT * FROM doctrine_migration_versions Parameters: [] View formatted query View runnable query Explain query SELECT * FROM doctrine_migration_versions SELECT * FROM doctrine_migration_versions;
34	1.91 ms	SHOW FULL TABLES WHERE Table_type = 'BASE TABLE' Parameters: [] View formatted query View runnable query Explain query SHOW FULL TABLES WHERE Table_type = 'BASE TABLE' SHOW FULL TABLES WHERE Table_type = 'BASE TABLE';
35	0.93 ms	SHOW FULL TABLES WHERE Table_type = 'BASE TABLE' Parameters: [] View formatted query View runnable query Explain query SHOW FULL TABLES WHERE Table_type = 'BASE TABLE' SHOW FULL TABLES WHERE Table_type = 'BASE TABLE';
36	0.93 ms	SELECT COLUMN_NAME AS Field, COLUMN_TYPE AS Type, IS_NULLABLE AS `Null`, COLUMN_KEY AS `Key`, COLUMN_DEFAULT AS `Default`, EXTRA AS Extra, COLUMN_COMMENT AS Comment, CHARACTER_SET_NAME AS CharacterSet, COLLATION_NAME AS Collation FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = 'mbill' AND TABLE_NAME = 'doctrine_migration_versions' ORDER BY ORDINAL_POSITION ASC Parameters: [] View formatted query View runnable query Explain query SELECT COLUMN_NAME AS Field, COLUMN_TYPE AS Type, IS_NULLABLE AS `Null`, COLUMN_KEY AS `Key`, COLUMN_DEFAULT AS `Default`, EXTRA AS Extra, COLUMN_COMMENT AS Comment, CHARACTER_SET_NAME AS CharacterSet, COLLATION_NAME AS Collation FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = 'mbill' AND TABLE_NAME = 'doctrine_migration_versions' ORDER BY ORDINAL_POSITION ASC SELECT COLUMN_NAME AS Field, COLUMN_TYPE AS Type, IS_NULLABLE AS `Null`, COLUMN_KEY AS `Key`, COLUMN_DEFAULT AS `Default`, EXTRA AS Extra, COLUMN_COMMENT AS Comment, CHARACTER_SET_NAME AS CharacterSet, COLLATION_NAME AS Collation FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = 'mbill' AND TABLE_NAME = 'doctrine_migration_versions' ORDER BY ORDINAL_POSITION ASC;
37	0.43 ms	SELECT DISTINCT k.`CONSTRAINT_NAME`, k.`COLUMN_NAME`, k.`REFERENCED_TABLE_NAME`, k.`REFERENCED_COLUMN_NAME` /!50116 , c.update_rule, c.delete_rule / FROM information_schema.key_column_usage k /!50116 INNER JOIN information_schema.referential_constraints c ON c.constraint_name = k.constraint_name AND c.table_name = 'doctrine_migration_versions' / WHERE k.table_name = 'doctrine_migration_versions' AND k.table_schema = 'mbill' /!50116 AND c.constraint_schema = 'mbill' / AND k.`REFERENCED_COLUMN_NAME` is not NULL Parameters: [] View formatted query View runnable query Explain query SELECT DISTINCT k.`CONSTRAINT_NAME`, k.`COLUMN_NAME`, k.`REFERENCED_TABLE_NAME`, k.`REFERENCED_COLUMN_NAME` /!50116 , c.update_rule, c.delete_rule / FROM information_schema.key_column_usage k /!50116 INNER JOIN information_schema.referential_constraints c ON c.constraint_name = k.constraint_name AND c.table_name = 'doctrine_migration_versions' / WHERE k.table_name = 'doctrine_migration_versions' AND k.table_schema = 'mbill' /!50116 AND c.constraint_schema = 'mbill' / AND k.`REFERENCED_COLUMN_NAME` is not NULL SELECT DISTINCT k.`CONSTRAINT_NAME`, k.`COLUMN_NAME`, k.`REFERENCED_TABLE_NAME`, k.`REFERENCED_COLUMN_NAME` /!50116 , c.update_rule, c.delete_rule / FROM information_schema.key_column_usage k /!50116 INNER JOIN information_schema.referential_constraints c ON c.constraint_name = k.constraint_name AND c.table_name = 'doctrine_migration_versions' / WHERE k.table_name = 'doctrine_migration_versions' AND k.table_schema = 'mbill' /!50116 AND c.constraint_schema = 'mbill' / AND k.`REFERENCED_COLUMN_NAME` is not NULL;
38	0.32 ms	SELECT NON_UNIQUE AS Non_Unique, INDEX_NAME AS Key_name, COLUMN_NAME AS Column_Name, SUB_PART AS Sub_Part, INDEX_TYPE AS Index_Type FROM information_schema.STATISTICS WHERE TABLE_NAME = 'doctrine_migration_versions' AND TABLE_SCHEMA = 'mbill' ORDER BY SEQ_IN_INDEX ASC Parameters: [] View formatted query View runnable query Explain query SELECT NON_UNIQUE AS Non_Unique, INDEX_NAME AS Key_name, COLUMN_NAME AS Column_Name, SUB_PART AS Sub_Part, INDEX_TYPE AS Index_Type FROM information_schema.STATISTICS WHERE TABLE_NAME = 'doctrine_migration_versions' AND TABLE_SCHEMA = 'mbill' ORDER BY SEQ_IN_INDEX ASC SELECT NON_UNIQUE AS Non_Unique, INDEX_NAME AS Key_name, COLUMN_NAME AS Column_Name, SUB_PART AS Sub_Part, INDEX_TYPE AS Index_Type FROM information_schema.STATISTICS WHERE TABLE_NAME = 'doctrine_migration_versions' AND TABLE_SCHEMA = 'mbill' ORDER BY SEQ_IN_INDEX ASC;
39	0.37 ms	SELECT ENGINE, AUTO_INCREMENT, TABLE_COLLATION, TABLE_COMMENT, CREATE_OPTIONS FROM information_schema.TABLES WHERE TABLE_TYPE = 'BASE TABLE' AND TABLE_SCHEMA = DATABASE() AND TABLE_NAME = 'doctrine_migration_versions' Parameters: [] View formatted query View runnable query Explain query SELECT ENGINE, AUTO_INCREMENT, TABLE_COLLATION, TABLE_COMMENT, CREATE_OPTIONS FROM information_schema.TABLES WHERE TABLE_TYPE = 'BASE TABLE' AND TABLE_SCHEMA = DATABASE() AND TABLE_NAME = 'doctrine_migration_versions' SELECT ENGINE, AUTO_INCREMENT, TABLE_COLLATION, TABLE_COMMENT, CREATE_OPTIONS FROM information_schema.TABLES WHERE TABLE_TYPE = 'BASE TABLE' AND TABLE_SCHEMA = DATABASE() AND TABLE_NAME = 'doctrine_migration_versions';
40	0.26 ms	SELECT * FROM doctrine_migration_versions Parameters: [] View formatted query View runnable query Explain query SELECT * FROM doctrine_migration_versions SELECT * FROM doctrine_migration_versions;
41	0.40 ms	SELECT t0.id AS id_1, t0.type AS type_2, t0.valeur AS valeur_3, t0.link AS link_4, t0.description AS description_5, t0.date AS date_6, t0.rang AS rang_7, t0.src AS src_8, t0.alt AS alt_9, t0.user_id AS user_id_10 FROM parametreadmin t0 WHERE t0.type = ? LIMIT 1 Parameters: [`"logosm"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.type AS type_2, t0.valeur AS valeur_3, t0.link AS link_4, t0.description AS description_5, t0.date AS date_6, t0.rang AS rang_7, t0.src AS src_8, t0.alt AS alt_9, t0.user_id AS user_id_10 FROM parametreadmin t0 WHERE t0.type = ? LIMIT 1 SELECT t0.id AS id_1, t0.type AS type_2, t0.valeur AS valeur_3, t0.link AS link_4, t0.description AS description_5, t0.date AS date_6, t0.rang AS rang_7, t0.src AS src_8, t0.alt AS alt_9, t0.user_id AS user_id_10 FROM parametreadmin t0 WHERE t0.type = 'logosm' LIMIT 1;
42	0.45 ms	SELECT t0.id AS id_1, t0.type AS type_2, t0.valeur AS valeur_3, t0.link AS link_4, t0.description AS description_5, t0.date AS date_6, t0.rang AS rang_7, t0.src AS src_8, t0.alt AS alt_9, t0.user_id AS user_id_10 FROM parametreadmin t0 WHERE t0.type = ? LIMIT 1 Parameters: [`"templatewebsite"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.type AS type_2, t0.valeur AS valeur_3, t0.link AS link_4, t0.description AS description_5, t0.date AS date_6, t0.rang AS rang_7, t0.src AS src_8, t0.alt AS alt_9, t0.user_id AS user_id_10 FROM parametreadmin t0 WHERE t0.type = ? LIMIT 1 SELECT t0.id AS id_1, t0.type AS type_2, t0.valeur AS valeur_3, t0.link AS link_4, t0.description AS description_5, t0.date AS date_6, t0.rang AS rang_7, t0.src AS src_8, t0.alt AS alt_9, t0.user_id AS user_id_10 FROM parametreadmin t0 WHERE t0.type = 'templatewebsite' LIMIT 1;

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\Users\User\User	No errors.
App\Entity\Users\User\Imgslide	No errors.
App\Entity\Produit\Produit\Souscategorie	No errors.
App\Entity\Produit\Produit\Categorie	No errors.
App\Entity\Produit\Produit\Produit	No errors.
App\Entity\Produit\Produit\Marqueproduit	No errors.
App\Entity\Produit\Produit\Imgproduit	No errors.
App\Entity\Produit\Produit\Produitboutique	No errors.
App\Entity\Projet\Projet\Offrespeciale	No errors.
App\Entity\Projet\Projet\Projet	No errors.
App\Entity\Produit\Service\Pays	No errors.
App\Entity\Produit\Service\Ville	No errors.
App\Entity\Projet\Projet\Typeprojet	No errors.
App\Entity\Projet\Projet\Imgprofilprojet	No errors.
App\Entity\Projet\Projet\Imgcouvertureprojet	No errors.
App\Entity\Produit\Produit\Animationproduit	No errors.
App\Entity\Produit\Produit\Panier	No errors.
App\Entity\Produit\Service\Service	No errors.
App\Entity\Projet\Projet\Projetmobile	No errors.
App\Entity\Users\User\Commerciauxprojet	No errors.
App\Entity\Produit\Service\Couponcard	No errors.
App\Entity\Users\User\Contacts	No errors.
App\Entity\Produit\Produit\Coutlivraison	No errors.
App\Entity\Users\Adminuser\Parametreadmin	No errors.
App\Entity\Users\User\Imgprofil	No errors.
App\Entity\Users\User\Imgcouverture	No errors.
App\Entity\Produit\Service\Drapeau	No errors.
App\Entity\Produit\Service\Continent	No errors.
App\Entity\Produit\Produit\Produitpanier	No errors.
App\Entity\Projet\Tresorerie\Detailversement	No errors.
App\Entity\Produit\Service\Imgservice	No errors.
App\Entity\Produit\Service\Evenement	No errors.
App\Entity\Produit\Service\Typearticle	No errors.

Symfony Profiler

https://mbill.afhunt.com/_fragment?_path=_format%3Dhtml%26_locale%3Den%26_controller%3DApp%255CController%255CGeneral%255CTemplate%255CMenuController%253Arelicon

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Entities Mapping