Query Metrics
326
Database Queries
47
Different statements
812.49 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
217.23 ms (26.74%) |
1 |
SELECT h0_.type AS type_0, h0_.titre AS titre_1, h0_.slug AS slug_2, h0_.sous_titre AS sous_titre_3, h0_.tome AS tome_4, h0_.revue_numero AS revue_numero_5, h0_.resume AS resume_6, h0_.date_publication AS date_publication_7, h0_.biographie AS biographie_8, h0_.extrait_pdf AS extrait_pdf_9, h0_.extrait_audio AS extrait_audio_10, h0_.sommaire AS sommaire_11, h0_.date_modification AS date_modification_12, h0_.prix_papier AS prix_papier_13, h0_.prix_numerique AS prix_numerique_14, h0_.prix_audio AS prix_audio_15, h0_.disponibilite_epub AS disponibilite_epub_16, h0_.largeur AS largeur_17, h0_.hauteur AS hauteur_18, h0_.nb_pages AS nb_pages_19, h0_.poids AS poids_20, h0_.isbn AS isbn_21, h0_.ean13 AS ean13_22, h0_.ean_epub AS ean_epub_23, h0_.ean_pdf AS ean_pdf_24, h0_.multilingue AS multilingue_25, h0_.avis_expert AS avis_expert_26, h0_.externe_id AS externe_id_27, h0_.image_recto_url_externe AS image_recto_url_externe_28, h0_.image_verso_url_externe AS image_verso_url_externe_29, h0_.updated AS updated_30, h0_.added AS added_31, h0_.image_changed AS image_changed_32, h0_.a_la_une AS a_la_une_33, h0_.lien_aplat AS lien_aplat_34, h0_.id AS id_35, h0_.created AS created_36, h0_.changed AS changed_37, h0_.revue_id AS revue_id_38, h0_.image_recto_id AS image_recto_id_39, h0_.image_verso_id AS image_verso_id_40, h0_.disponibilite_papier_id AS disponibilite_papier_id_41, h0_.disponibilite_numerique_id AS disponibilite_numerique_id_42, h0_.disponibilite_audio_id AS disponibilite_audio_id_43, h0_.editeur_id AS editeur_id_44, h0_.collection_id AS collection_id_45, h0_.sous_collection_id AS sous_collection_id_46, h0_.nature_id AS nature_id_47, h0_.type_couverture_id AS type_couverture_id_48 FROM har_ouvrage h0_ INNER JOIN har_commande_detail h1_ ON h0_.id = h1_.ouvrage_id INNER JOIN har_disponibilite_ouvrage h2_ ON h0_.disponibilite_papier_id = h2_.id INNER JOIN har_ouvrage_thematique h3_ ON h0_.id = h3_.ouvrage_id WHERE h2_.externe_id NOT IN (?, ?) AND h3_.thematique_id = ? GROUP BY h0_.id ORDER BY SUM(h1_.quantity) DESC LIMIT 4
Parameters:
[ 5 6 79 ] |
|
81.67 ms (10.05%) |
1 |
SELECT h0_.nom AS nom_0, h0_.prenom AS prenom_1, h0_.slug AS slug_2, h0_.photo_url_externe AS photo_url_externe_3, h0_.structure_professionnelle AS structure_professionnelle_4, h0_.site_web AS site_web_5, h0_.facebook AS facebook_6, h0_.twitter AS twitter_7, h0_.linkedin AS linkedin_8, h0_.instagram AS instagram_9, h0_.titres_diplomes AS titres_diplomes_10, h0_.fonctions_actuelles AS fonctions_actuelles_11, h0_.biographie AS biographie_12, h0_.autres_parutions AS autres_parutions_13, h0_.artiste_id AS artiste_id_14, h0_.externe_id AS externe_id_15, h0_.date_creation AS date_creation_16, h0_.date_modification AS date_modification_17, h0_.image_changed AS image_changed_18, h0_.id AS id_19, h0_.created AS created_20, h0_.changed AS changed_21, h0_.compte_id AS compte_id_22, h0_.photo_id AS photo_id_23, h0_.parent_id AS parent_id_24 FROM har_intervenant h0_ INNER JOIN har_ouvrage_intervenant h1_ ON h0_.id = h1_.intervenant_id WHERE h0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY h0_.prenom ASC, h0_.nom ASC
Parameters:
[ 7412 97 1223 28116 48721 623 5440 11159 27197 29278 2277 2624 3604 5907 15509 21474 23586 24724 31597 37712 46738 442 1054 1860 3131 4067 5444 8244 10597 12345 19358 22743 27014 27640 36408 46310 48304 399 679 949 1230 1636 2065 2244 2450 2526 2646 2787 2893 3120 3140 3232 3637 3826 3875 4062 4435 6009 8084 9275 9353 9606 10449 10818 11417 13032 15187 15188 15190 15972 17180 18961 21493 21562 23020 25311 27675 27776 27915 28408 28980 29077 29924 29926 29927 29929 31897 32318 32319 34088 34171 34921 42573 45647 45943 49156 49578 50187 52683 483 1127 1269 1376 1469 1647 2285 2327 2340 2603 2978 2985 3068 3133 3206 3239 3606 3610 3623 3673 3928 4027 4077 4188 4887 5598 5655 6350 6354 6547 6728 6785 7276 7309 8469 8475 9796 10193 10440 10584 10592 10653 10689 11033 11064 11226 11589 11653 11675 12179 12382 12822 12853 13217 13404 13474 13523 14687 15067 15384 15549 15769 16566 16711 16712 16941 17417 17429 17493 17701 18163 18266 18303 19025 19198 19320 19487 19570 19600 19940 20102 21064 21456 21573 21780 22252 22263 22402 22511 22601 22636 23363 23779 24255 24261 24463 24707 25044 25069 25240 25319 25369 25474 25589 25820 26822 27002 27307 27554 27645 27979 28026 28053 28162 28419 29071 29074 29573 32602 33244 33246 34010 34431 36041 36176 36419 36459 36461 36738 39308 39453 39785 40390 42308 42815 43685 43907 44839 46500 48201 48935 48951 49421 49580 49847 49903 50643 52696 52865 53023 53047 53685 54264 54688 55704 36 74 126 205 318 392 439 445 470 532 638 761 768 787 869 913 918 993 1012 1072 1083 1117 1121 1125 1140 1157 1168 1195 1227 1267 1273 1296 1370 1414 1425 1463 1464 1539 1543 1567 1586 1630 1673 1694 1697 1724 1770 1798 1838 1842 1850 1927 1993 1999 2028 2032 2059 2151 2183 2207 2223 2257 2328 2357 2494 2507 2544 2546 2571 2600 2608 2650 2661 2664 2710 2768 2789 2797 2948 2966 2976 2981 2987 3013 3077 3102 3103 3106 3107 3226 3240 3259 3317 3322 3351 3431 3450 3459 3463 3499 3545 3556 3619 3642 3712 3714 3723 3751 3758 3773 3785 3839 3846 3891 3892 3910 3945 3969 4013 4022 4023 4030 4047 4068 4069 4075 4092 4106 4135 4179 4183 4209 4214 4325 4338 4394 4437 4439 4494 4582 4601 4623 4625 4644 4647 4678 4719 4738 4759 4822 4824 4827 4860 4880 4892 4990 4991 4996 5069 5193 5205 5230 5277 5281 5310 5332 5353 5388 5395 5412 5420 5467 5643 5691 5711 5806 5836 5944 5946 5953 5997 6043 6048 6088 6116 6129 6134 6164 6165 6181 6195 6198 6199 6245 6279 6298 6311 6396 6407 6410 6436 6478 6498 6513 6536 6599 6606 6674 6704 6709 6710 6747 6835 6866 6903 6923 6996 7003 7006 7019 7144 7179 7252 7256 7278 7279 7320 7399 7416 7431 7432 7443 7520 7524 7588 7621 7623 7660 7661 7673 7677 7690 7719 7721 7724 7732 7813 7814 7826 7851 7869 7900 7909 7910 7930 7936 7974 7982 8014 8021 8066 8080 8134 8146 8164 8173 8179 8246 8330 8362 8390 8459 8461 8485 8487 8491 8500 8503 8505 8585 8595 8596 8605 8665 8676 8775 8806 8809 8827 8839 9012 9070 9091 9092 9094 9102 9138 9168 9200 9204 9207 9264 9268 9273 9337 9409 9419 9449 9451 9507 9532 9550 9583 9589 9639 9647 9677 9688 9691 9701 9825 9851 9870 9884 9922 9956 9961 9979 10057 10100 10109 10214 10220 10226 10228 10258 10269 10288 10315 10333 10377 10473 10505 10563 10583 10616 10631 10644 10655 10701 10730 10855 10870 10884 10933 11025 11031 11090 11119 11154 11188 11198 11218 11228 11288 11320 11324 11344 11346 11373 11382 11420 11468 11513 11524 11542 11601 11604 11608 11613 11624 11654 11669 11711 11811 11882 11961 11977 12011 12021 12047 12062 12063 12105 12186 12207 12212 12337 12371 12479 12499 12519 12566 12607 12640 12692 12743 12758 12810 12864 12972 12978 12990 13019 13125 13152 13212 13220 13301 13306 13308 13486 13522 13525 13528 13529 13542 13547 13577 13648 13693 13718 13745 13746 13762 13848 13871 13875 13882 13889 13908 13988 14091 14099 14125 14178 14220 14223 14280 14324 14353 14430 14453 14487 14511 14564 14589 14610 14614 14637 14641 14681 14693 14742 14748 14798 14799 14802 14852 14870 14915 14935 14947 14953 14990 15007 15020 15047 15062 15093 15095 15118 15119 15233 15273 15293 15311 15317 15486 15572 15580 15581 15608 15722 15750 15830 15859 15866 15902 15904 15996 15999 16079 16131 16138 16140 16191 16309 16346 16348 16373 16445 16471 16504 16509 16514 16581 16591 16610 16685 16693 16703 16739 16745 16763 16765 16774 16790 16804 16811 16849 16879 16907 16911 16968 16990 17003 17009 17150 17165 17216 17240 17260 17293 17355 17370 17424 17453 17574 17603 17613 17618 17723 17747 17752 17769 17773 17795 17834 17845 17858 17902 17938 17999 18049 18076 18085 18091 18105 18160 18254 18256 18296 18315 18364 18367 18376 18493 18561 18684 18691 18771 18969 18979 18993 19018 19034 19042 19082 19084 19176 19190 19288 19359 19417 19422 19436 19462 19465 19475 19503 19529 19537 19543 19551 19557 19611 19693 19755 19765 19782 19789 19832 19867 19891 19925 20056 20118 20139 20172 20345 20355 20490 20507 20538 20542 20544 20578 20669 20754 20842 20900 20924 20938 20987 21008 21024 21035 21094 21129 21188 21205 21209 21229 21243 21326 21363 21411 21467 21513 21519 21527 21555 21583 21588 21655 21689 21707 21860 21893 21976 22022 22029 22062 22132 22148 22179 22207 22212 22231 22240 22257 22272 22302 22331 22332 22355 22390 22405 22442 22481 22482 22499 22506 22573 22631 22647 22648 22683 22693 22701 22744 22763 22803 22804 22835 22840 22868 22872 22929 22985 23019 23075 23150 23174 23201 23227 23266 23275 23307 23336 23339 23372 23381 23417 23447 23470 23503 23521 23570 23621 23645 23723 23736 23775 23803 23818 23829 23867 23912 23939 23954 23961 23978 23979 23993 24109 24111 24127 24140 24178 24194 24233 24237 24315 24329 24352 24419 24483 24496 24551 24572 24613 24651 24678 24698 24702 24716 24738 24744 24765 24808 24845 24864 24918 24990 25038 25079 25099 25120 25151 25198 25203 25239 25277 25329 25336 25412 25444 25458 25466 25470 25534 25587 25659 25699 25845 25893 26060 26112 26139 26170 26172 26178 26245 26285 26382 26413 26447 26486 26532 26544 26596 26662 26673 26729 26749 26797 26837 26867 26883 26903 26953 26971 27035 27037 27042 27067 27068 27118 27121 27149 27170 27206 27213 27254 27258 27276 27316 27324 27332 27333 27345 27363 27374 27378 27387 27397 27415 27418 27444 27489 27509 27514 27517 27532 27534 27545 27548 27550 27569 27570 27579 27608 27621 27634 27649 27653 27686 27695 27716 27749 27774 27791 27794 27799 27813 27824 27829 27883 27905 27923 27966 27981 28006 28046 28119 28143 28158 28284 28292 28367 28395 28455 28486 28491 28503 28537 28546 28566 28568 28574 28673 28813 28836 28849 28903 28925 28983 28984 28991 29213 29322 29372 29471 29579 29615 29670 29671 29672 29675 29692 29716 29728 29730 29763 29767 29768 29769 29771 29789 29804 29842 29880 29946 30051 30065 30198 30300 30320 30322 30351 30352 30511 30519 30520 30539 30560 30588 30604 30607 30647 30677 30683 30696 30698 30699 30714 30720 30721 30722 30752 30762 30790 30899 31138 31382 31574 31588 31590 31591 31624 31735 31737 31765 31794 31830 31833 31834 31856 31943 31945 31948 31963 31983 32068 32071 32078 32129 32131 32138 32167 32197 32320 32404 32405 32410 32594 32596 32597 32605 32606 32626 32789 32858 32859 32880 32903 33003 33010 33112 33114 33205 33228 33229 33278 33359 33480 33518 33538 33539 33638 33662 33665 33670 33674 33827 33828 33835 33837 34016 34072 34079 34109 34158 34174 34272 34274 34318 34327 34328 34338 34350 34424 34451 34485 34488 34492 34531 34591 34617 34618 34698 34706 34708 34752 34754 34755 34756 34758 34766 34787 34817 34858 34859 34874 34889 34895 34898 34900 35021 35046 35110 35224 35243 35244 35344 35345 35350 35367 35374 35432 35433 35434 35436 35437 35439 35440 35442 35458 35460 35464 35465 35492 35497 35504 35535 35537 35563 35571 35584 35594 35601 35608 35613 35674 35677 35678 35679 35683 35684 35688 35691 35710 35767 35775 35815 35835 36014 36040 36061 36074 36148 36248 36374 36406 36462 36467 36477 36481 36504 36556 36748 36751 36756 36757 36759 36766 36864 36869 36876 36880 36886 36933 37112 37114 37116 37119 37120 37122 37191 37206 37243 37286 37356 37376 37386 37389 37412 37524 37649 37733 37816 37819 37876 37901 37902 38120 38123 38358 38432 38433 38440 38493 38506 38543 38813 38820 38827 38908 39057 39059 39087 39117 39131 39141 39198 39230 39258 39267 39269 39305 39387 39388 39389 39404 39405 39528 39589 39739 39837 40091 40154 40340 40358 40444 40521 40556 40596 40648 40788 40856 40941 41016 41024 41135 41396 41458 41528 41668 41670 41712 41753 41808 41842 41850 41872 41876 41906 41988 41996 42045 42129 42136 42244 42367 42458 42558 42588 42630 42633 42645 42655 42667 42745 42828 42842 42843 42861 42919 42971 43019 43086 43120 43141 43201 43242 43263 43298 43322 43336 43344 43539 43552 43571 43599 43607 43638 43642 43665 43695 43734 43739 43791 43792 43812 43884 43935 43947 43958 43964 44001 44045 44046 44062 44110 44144 44171 44219 44247 44250 44264 44271 44290 44334 44339 44385 44394 44403 44445 44653 44657 44666 44711 44813 44910 44918 45102 45208 45255 45309 45320 45353 45395 45396 45539 45690 45702 45762 45809 45822 45825 45832 45848 45858 45873 45894 45922 45942 46025 46046 46104 46123 46166 46193 46220 46230 46302 46377 46390 46446 46573 46612 46672 46677 46705 46722 46757 46758 46829 46866 46886 46927 46976 46989 47045 47142 47144 47147 47246 47280 47295 47311 47390 47431 47441 47448 47468 47526 47534 47571 47599 47776 47872 48409 48466 48470 48476 48485 48529 48545 48580 48627 48835 48846 48847 48854 48876 48886 48901 48937 48991 49011 49088 49193 49344 49431 49437 49570 49605 49622 49747 49751 49753 49770 49857 49897 49945 50012 50022 50029 50222 50223 50226 50280 50309 50336 50371 50417 50420 50435 50438 50443 50447 50504 50506 50509 50535 50614 50673 50686 50708 50860 50862 50893 50913 51048 51050 51057 51060 51087 51154 51155 51157 51184 51221 51238 51239 51240 51280 51324 51342 51376 51474 51860 51888 51924 51968 51985 52064 52175 52201 52225 52264 52328 52366 52369 52416 52441 52635 52647 52649 52650 52698 52701 52707 52716 52798 52837 52843 52861 52982 53013 53063 53389 53401 53403 53420 53423 53623 53634 53818 53826 53829 53830 53846 53850 53851 53954 53985 54019 54139 54152 54262 54554 54641 54681 54730 54952 54997 55341 55366 55392 55564 55566 55902 56157 56170 56214 56217 56258 56335 56623 56624 56680 56853 56869 56929 56937 56977 56978 57003 57004 57059 57086 57211 57405 57817 57856 57975 58197 58262 58841 58871 58872 58873 58959 58994 59768 ] |
|
65.80 ms (8.10%) |
1 |
SELECT h0_.nom AS nom_0, h0_.prenom AS prenom_1, h0_.slug AS slug_2, h0_.photo_url_externe AS photo_url_externe_3, h0_.structure_professionnelle AS structure_professionnelle_4, h0_.site_web AS site_web_5, h0_.facebook AS facebook_6, h0_.twitter AS twitter_7, h0_.linkedin AS linkedin_8, h0_.instagram AS instagram_9, h0_.titres_diplomes AS titres_diplomes_10, h0_.fonctions_actuelles AS fonctions_actuelles_11, h0_.biographie AS biographie_12, h0_.autres_parutions AS autres_parutions_13, h0_.artiste_id AS artiste_id_14, h0_.externe_id AS externe_id_15, h0_.date_creation AS date_creation_16, h0_.date_modification AS date_modification_17, h0_.image_changed AS image_changed_18, h0_.id AS id_19, h0_.created AS created_20, h0_.changed AS changed_21, h0_.compte_id AS compte_id_22, h0_.photo_id AS photo_id_23, h0_.parent_id AS parent_id_24 FROM har_intervenant h0_ INNER JOIN har_ouvrage_intervenant h1_ ON h0_.id = h1_.intervenant_id WHERE h0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY h0_.prenom ASC, h0_.nom ASC
Parameters:
[ 27014 97 5997 4013 5836 5944 1157 11417 5953 6129 27824 5806 6199 28116 16968 19755 4023 36459 1724 14453 27002 2065 12810 21707 35046 30714 19543 40390 12853 1227 15118 25038 58873 36876 34072 3892 22481 42308 40340 22701 7520 14687 4106 7524 22442 12972 49578 50893 17858 34708 14798 16309 51087 26532 24707 25151 16089 40358 19557 42367 20118 1195 34088 23939 25444 31574 1543 9688 22683 24255 1842 18961 29670 25079 27035 4623 7588 27037 11961 2710 30604 48304 20490 23993 27042 34079 12479 949 7621 49605 7623 34431 6298 11513 4077 42558 37376 22985 22332 21573 42573 18684 15020 30899 6513 12186 22132 40444 13019 3013 32131 30588 26903 42630 42633 25198 16907 34010 42645 36504 29728 7252 42655 34921 19782 7660 42667 19034 27067 27068 3928 14564 35344 1230 26245 17613 24765 36880 37112 35432 35433 16471 11033 37243 36477 7673 11320 28983 17701 7677 42745 3499 11344 7690 22022 19018 1376 28836 14799 12207 30198 679 38120 31590 23521 50614 40521 19190 13875 5598 17165 42815 26178 19529 38123 74 34817 42843 19789 34318 21562 23417 7719 36556 10701 7724 2494 35224 27118 35345 27121 34424 7732 13889 42458 42919 10597 7432 13220 16804 15769 36461 25458 36462 31856 2976 12499 11188 40091 35710 42971 33665 2978 6923 1850 43019 15972 27149 40596 31948 392 3351 15608 26883 35434 36074 1993 34485 17003 57003 2244 638 3673 27170 33662 23266 35674 43120 7813 15187 31794 22743 7814 43141 14637 17355 35535 31830 7826 15572 6903 3604 27197 11373 20578 30051 43201 13648 19551 16703 33480 21519 39141 5230 35767 27206 11025 37524 7851 43242 37386 31138 29573 3758 48409 13486 17938 27213 43263 22868 2450 7869 14178 23363 12021 10057 35608 33033 15549 43322 43336 36014 43344 24808 21363 22803 19176 23470 25470 39405 7900 19475 32071 14589 26596 36481 26285 7909 1121 35021 1647 32858 54262 7910 28292 21008 11624 35537 33112 18256 27254 30320 36748 2327 39198 35458 27258 34752 37114 14353 18254 7930 18160 974 16763 7936 25699 22062 19765 27276 22835 43539 32859 23503 16191 43552 15486 15581 9589 6599 3606 15509 34889 6709 43571 20345 40788 36766 16581 32597 32596 21243 32318 43599 32320 32319 43607 20507 16739 4047 7974 43638 48466 2787 31983 10109 7982 3102 10818 18561 48470 2646 43685 3103 35677 10377 43695 29767 27307 35678 47776 9825 40856 29924 50309 27316 10193 13848 8014 8021 30696 6088 4394 48485 2507 11675 14091 36406 6996 13542 14280 52201 25534 318 4991 8066 27324 12822 8080 17769 28395 43812 8084 15119 18376 21555 27332 27333 20754 6407 29671 28566 10333 11324 24551 16990 2985 11119 22482 3106 48529 34338 27345 43884 37116 15996 29672 17574 31897 49753 11524 15830 35835 35679 43907 10258 23621 25203 21474 3107 43935 18105 11198 1273 37389 14947 29322 43964 34787 53047 8134 7003 16131 8146 30520 35492 27363 14487 3839 34706 10592 19082 126 29763 49770 4880 8164 3773 30511 20355 9691 8173 44045 44062 18091 34109 27378 39230 5412 44046 18266 27374 7006 23586 21655 11468 23645 3463 39528 19600 44110 16941 7278 2987 27387 6009 44144 36751 3068 27397 11601 16711 18979 48580 2948 4325 44171 1927 16685 52264 24864 25311 44219 27415 29768 24990 41016 8179 3610 44250 27418 41024 16610 1999 8244 7320 44271 14802 7309 36061 36408 20139 2357 22763 34171 34488 14915 49421 7276 24127 36148 22648 16079 25044 10884 14870 6181 36886 24233 23912 57004 27444 44339 23779 26662 35374 36040 52798 25589 12990 35460 33835 6606 761 44385 12640 29716 2183 44394 34174 3910 28574 44403 13404 24111 7019 11604 29769 44445 30065 37649 35584 19417 17260 25277 19537 16811 6536 19832 7412 27489 1463 22573 8330 22506 48627 44247 23336 913 26060 12047 36 41135 2603 21456 13547 21893 18493 4738 34158 12062 25336 22355 3206 25120 8362 27509 50443 38358 12063 22499 27517 21493 21064 15188 14231 2661 11669 44653 44657 23307 32068 44666 54681 26673 23954 993 1296 27532 27534 24744 32410 55366 44711 16765 2664 22929 31833 918 22405 19925 35436 8390 53846 14125 3846 27545 39258 27548 36738 1838 2257 27550 37286 10644 44813 20952 3431 21689 34698 53634 3785 11218 13125 37119 44839 26139 35437 4435 14953 17747 22804 17150 27569 27570 49847 19084 35497 11542 8459 32880 532 8461 15062 15047 39267 10653 8469 27579 44918 10855 8475 13745 53063 35815 58197 54641 8487 51060 24483 11608 35613 8491 49857 19503 8503 8505 20538 15273 6710 29071 30752 17834 48721 3619 35683 12758 15902 33674 27608 4439 12179 32626 19611 20669 16849 4214 16138 21205 16712 30539 36248 38433 38432 20924 37120 4996 12345 19487 36041 10730 3623 11226 442 45102 19358 22263 37712 27634 5946 38813 5440 13522 13746 27640 38440 12212 1694 27645 21583 22272 10870 20544 8585 26953 27649 31737 13718 17009 11228 24237 5643 23075 1539 21035 8595 3945 8596 45208 27653 13474 37191 8605 14935 20938 23201 36864 32602 30647 25659 1046 1127 28162 20542 2608 28367 32197 16911 3131 3712 16140 13762 35684 49897 21411 26170 29926 51985 10449 41458 4092 33244 13032 31834 37733 9851 45309 27675 45320 15318 4179 12371 33538 13525 35775 27686 49903 17417 27621 26382 3714 34451 19422 27695 7144 56335 24918 6116 8665 15384 21326 32138 10473 45395 15317 45396 32404 3317 10228 8676 34327 31588 35439 16346 25474 34328 1697 27716 10100 29927 16693 38493 34016 18315 49945 48854 3133 13693 23150 19359 29946 39589 6396 10220 30322 24724 33539 53829 50280 17618 15233 4183 7179 38506 28537 5193 56170 17773 35350 23818 9606 22636 34859 19465 45647 41528 3556 22601 7279 26749 25329 10505 27749 47872 48886 14220 28455 15311 30720 32789 8775 13988 45690 30677 33670 12978 22179 15999 29880 48901 205 23174 52837 14511 29471 31963 10631 34895 20102 35688 6498 22029 4062 24716 33359 33827 45762 2028 3637 29789 8806 27774 15904 27776 4860 2546 29692 30721 13301 2207 8809 17845 23961 31382 16591 35440 22511 45809 10440 3322 8827 45822 45825 27791 21860 45848 27794 8839 23570 3226 45858 23829 38543 45873 27799 26192 6747 48835 30607 4601 25587 11882 1012 48935 48937 20172 16445 45922 17795 45942 45943 55704 48951 19867 27813 18993 5711 33837 34617 1370 9922 30722 9979 22840 27829 6728 5444 23723 7416 10584 48991 41668 34754 26413 14693 32903 52328 20842 9796 39308 34618 17752 1054 38820 57975 30790 17723 32167 9012 623 16504 30351 14748 2340 4887 9639 49011 24329 3642 19198 37356 32129 4135 16879 6245 22302 24419 41712 18691 35563 33638 46193 21527 32405 37816 9070 50535 19891 46220 4644 27883 19320 46230 11420 11589 25239 37819 24261 29804 34900 11154 24738 36467 18296 49431 20900 35504 2893 2277 17293 22207 12743 9091 35464 9092 19288 33114 9094 33246 27905 21209 46310 6835 53389 23775 3232 5277 37412 17180 31597 18303 17216 26797 23381 27915 23736 25240 16790 7443 17453 3140 46377 27923 46390 14852 25893 21467 23978 9138 24194 23979 34591 34492 21024 25099 31055 13908 37122 6048 5907 24678 35243 13523 46500 34755 34272 17493 29842 9168 23339 10563 24140 33828 11159 35442 30300 1673 12607 41842 2966 21780 26447 11064 22693 16373 33003 41850 35244 22231 6354 35571 1630 21129 18969 24572 46612 29278 26822 22252 24315 23227 9200 2223 41876 4827 28546 9204 23019 9207 4067 27979 34874 16745 46672 46677 49088 18364 21229 13306 34898 46705 37876 19693 36756 46738 24702 15293 18163 6410 36933 19025 9264 14610 46757 46758 25069 29929 16514 30698 1083 19570 11977 15750 10214 31765 49437 36374 2032 1636 6547 37206 2624 46829 13882 9268 46866 35601 9273 19042 9275 46722 2285 28006 26112 2151 46886 52843 30699 24698 9677 22744 4647 26837 20987 29771 23275 15580 32078 46927 19436 13577 17424 25466 28408 46976 30560 49580 46989 36419 22390 23020 12566 28026 2571 41988 13871 9337 35594 24178 10933 49156 29675 47045 10288 28980 33228 41996 37901 37902 9353 36757 31624 56978 34531 21513 16566 1140 38827 5205 22402 28046 47144 47147 2768 11613 14223 33205 18085 14324 28053 49193 1223 35691 16509 29615 11031 23372 9409 23867 11811 21188 14430 9419 19462 11090 14742 33518 20056 22148 35110 4338 33229 3239 6674 28903 25319 21976 17429 47280 4188 3450 34350 34756 39087 9449 34274 24613 22331 14614 24651 9451 4892 35465 16348 24352 16774 6785 1860 31591 25845 1425 14990 26867 32594 24109 47431 15722 18367 33278 24463 47448 26486 24845 17603 22872 33010 47468 28849 9701 22257 483 17240 12382 28119 30683 10689 9507 12519 15095 35367 22631 34758 3826 36176 47571 9532 11653 23803 9550 50187 34766 39739 4022 19940 11654 39785 29730 36759 7661 4625 54554 31735 15093 4027 31943 29077 13212 43665 56977 22240 48545 5467 39059 39269 9884 5310 53851 14641 9102 10315 30352 39117 4069 1168 13528 5281 11711 15190 4030 31945 10616 28284 53850 11346 13217 46302 12864 29213 13529 14681 39057 11288 ] |
|
61.29 ms (7.54%) |
15 |
SELECT * FROM phpcr_nodes WHERE identifier = ? AND workspace_name = ?
Parameters:
[ "dd991113-3aa4-4e99-b3f3-684362ec7aa8" "default_live" ] |
|
56.96 ms (7.01%) |
75 |
SELECT m0_.id AS id_0, m0_.created AS created_1, m0_.changed AS changed_2, m1_.name AS name_3, m1_.description AS description_4, m1_.id AS id_5, m2_.style AS style_6, m2_.lft AS lft_7, m2_.rgt AS rgt_8, m2_.depth AS depth_9, m2_.collection_key AS collection_key_10, m2_.id AS id_11, m2_.created AS created_12, m2_.changed AS changed_13, m3_.version AS version_14, m3_.id AS id_15, m3_.created AS created_16, m3_.changed AS changed_17, m4_.name AS name_18, m4_.version AS version_19, m4_.subVersion AS subVersion_20, m4_.size AS size_21, m4_.downloadCounter AS downloadCounter_22, m4_.storageOptions AS storageOptions_23, m4_.mimeType AS mimeType_24, m4_.properties AS properties_25, m4_.focusPointX AS focusPointX_26, m4_.focusPointY AS focusPointY_27, m4_.id AS id_28, m4_.created AS created_29, m4_.changed AS changed_30, t5_.name AS name_31, t5_.id AS id_32, t5_.created AS created_33, t5_.changed AS changed_34, m6_.crop_x AS crop_x_35, m6_.crop_y AS crop_y_36, m6_.crop_width AS crop_width_37, m6_.crop_height AS crop_height_38, m6_.format_key AS format_key_39, m7_.title AS title_40, m7_.description AS description_41, m7_.copyright AS copyright_42, m7_.credits AS credits_43, m7_.locale AS locale_44, m7_.id AS id_45, m8_.title AS title_46, m8_.description AS description_47, m8_.copyright AS copyright_48, m8_.credits AS credits_49, m8_.locale AS locale_50, m8_.id AS id_51, m9_.locale AS locale_52, m9_.id AS id_53, m10_.locale AS locale_54, m10_.id AS id_55, s11_.username AS username_56, s11_.password AS password_57, s11_.locale AS locale_58, s11_.salt AS salt_59, s11_.locked AS locked_60, s11_.enabled AS enabled_61, s11_.lastLogin AS lastLogin_62, s11_.confirmationKey AS confirmationKey_63, s11_.passwordResetToken AS passwordResetToken_64, s11_.passwordResetTokenExpiresAt AS passwordResetTokenExpiresAt_65, s11_.passwordResetTokenEmailsSent AS passwordResetTokenEmailsSent_66, s11_.privateKey AS privateKey_67, s11_.apiKey AS apiKey_68, s11_.email AS email_69, s11_.id AS id_70, s11_.created AS created_71, s11_.changed AS changed_72, s11_.from_api AS from_api_73, s11_.from_csv AS from_csv_74, s11_.token_google AS token_google_75, s11_.token_facebook AS token_facebook_76, s11_.front_access_token AS front_access_token_77, s11_.front_access_token_expires_at AS front_access_token_expires_at_78, c12_.firstName AS firstName_79, c12_.middleName AS middleName_80, c12_.lastName AS lastName_81, c12_.birthday AS birthday_82, c12_.salutation AS salutation_83, c12_.formOfAddress AS formOfAddress_84, c12_.newsletter AS newsletter_85, c12_.gender AS gender_86, c12_.note AS note_87, c12_.mainEmail AS mainEmail_88, c12_.mainPhone AS mainPhone_89, c12_.mainFax AS mainFax_90, c12_.mainUrl AS mainUrl_91, c12_.id AS id_92, c12_.created AS created_93, c12_.changed AS changed_94, s13_.username AS username_95, s13_.password AS password_96, s13_.locale AS locale_97, s13_.salt AS salt_98, s13_.locked AS locked_99, s13_.enabled AS enabled_100, s13_.lastLogin AS lastLogin_101, s13_.confirmationKey AS confirmationKey_102, s13_.passwordResetToken AS passwordResetToken_103, s13_.passwordResetTokenExpiresAt AS passwordResetTokenExpiresAt_104, s13_.passwordResetTokenEmailsSent AS passwordResetTokenEmailsSent_105, s13_.privateKey AS privateKey_106, s13_.apiKey AS apiKey_107, s13_.email AS email_108, s13_.id AS id_109, s13_.created AS created_110, s13_.changed AS changed_111, s13_.from_api AS from_api_112, s13_.from_csv AS from_csv_113, s13_.token_google AS token_google_114, s13_.token_facebook AS token_facebook_115, s13_.front_access_token AS front_access_token_116, s13_.front_access_token_expires_at AS front_access_token_expires_at_117, c14_.firstName AS firstName_118, c14_.middleName AS middleName_119, c14_.lastName AS lastName_120, c14_.birthday AS birthday_121, c14_.salutation AS salutation_122, c14_.formOfAddress AS formOfAddress_123, c14_.newsletter AS newsletter_124, c14_.gender AS gender_125, c14_.note AS note_126, c14_.mainEmail AS mainEmail_127, c14_.mainPhone AS mainPhone_128, c14_.mainFax AS mainFax_129, c14_.mainUrl AS mainUrl_130, c14_.id AS id_131, c14_.created AS created_132, c14_.changed AS changed_133, m15_.id AS id_134, m15_.created AS created_135, m15_.changed AS changed_136, m0_.idMediaTypes AS idMediaTypes_137, m0_.idPreviewImage AS idPreviewImage_138, m0_.idCollections AS idCollections_139, m0_.idUsersCreator AS idUsersCreator_140, m0_.idUsersChanger AS idUsersChanger_141, m2_.idCollectionsMetaDefault AS idCollectionsMetaDefault_142, m2_.idCollectionTypes AS idCollectionTypes_143, m2_.idCollectionsParent AS idCollectionsParent_144, m2_.idUsersCreator AS idUsersCreator_145, m2_.idUsersChanger AS idUsersChanger_146, m3_.idMedia AS idMedia_147, m3_.idUsersCreator AS idUsersCreator_148, m3_.idUsersChanger AS idUsersChanger_149, m4_.idFileVersionsMetaDefault AS idFileVersionsMetaDefault_150, m4_.idFiles AS idFiles_151, m4_.idUsersCreator AS idUsersCreator_152, m4_.idUsersChanger AS idUsersChanger_153, t5_.idUsersCreator AS idUsersCreator_154, t5_.idUsersChanger AS idUsersChanger_155, m6_.fileVersion AS fileVersion_156, m7_.idFileVersions AS idFileVersions_157, m8_.idFileVersions AS idFileVersions_158, m9_.idFileVersions AS idFileVersions_159, m10_.idFileVersions AS idFileVersions_160, s11_.idUsersCreator AS idUsersCreator_161, s11_.idUsersChanger AS idUsersChanger_162, s11_.idContacts AS idContacts_163, c12_.idTitles AS idTitles_164, c12_.avatar AS avatar_165, c12_.idUsersCreator AS idUsersCreator_166, c12_.idUsersChanger AS idUsersChanger_167, s13_.idUsersCreator AS idUsersCreator_168, s13_.idUsersChanger AS idUsersChanger_169, s13_.idContacts AS idContacts_170, c14_.idTitles AS idTitles_171, c14_.avatar AS avatar_172, c14_.idUsersCreator AS idUsersCreator_173, c14_.idUsersChanger AS idUsersChanger_174, m15_.idMediaTypes AS idMediaTypes_175, m15_.idPreviewImage AS idPreviewImage_176, m15_.idCollections AS idCollections_177, m15_.idUsersCreator AS idUsersCreator_178, m15_.idUsersChanger AS idUsersChanger_179 FROM me_media m0_ LEFT JOIN me_media_types m1_ ON m0_.idMediaTypes = m1_.id LEFT JOIN me_collections m2_ ON m0_.idCollections = m2_.id LEFT JOIN me_files m3_ ON m0_.id = m3_.idMedia LEFT JOIN me_file_versions m4_ ON m3_.id = m4_.idFiles LEFT JOIN me_file_version_tags m16_ ON m4_.id = m16_.idFileVersions LEFT JOIN ta_tags t5_ ON t5_.id = m16_.idTags LEFT JOIN me_file_version_categories m18_ ON m4_.id = m18_.idFileVersions LEFT JOIN ca_categories c17_ ON c17_.id = m18_.idCategories LEFT JOIN me_format_options m6_ ON m4_.id = m6_.fileVersion LEFT JOIN me_file_version_meta m7_ ON m4_.id = m7_.idFileVersions LEFT JOIN me_file_version_meta m8_ ON m4_.idFileVersionsMetaDefault = m8_.id LEFT JOIN me_file_version_content_languages m9_ ON m4_.id = m9_.idFileVersions LEFT JOIN me_file_version_publish_languages m10_ ON m4_.id = m10_.idFileVersions LEFT JOIN se_users s11_ ON m0_.idUsersCreator = s11_.id LEFT JOIN co_contacts c12_ ON s11_.idContacts = c12_.id LEFT JOIN se_users s13_ ON m0_.idUsersChanger = s13_.id LEFT JOIN co_contacts c14_ ON s13_.idContacts = c14_.id LEFT JOIN me_media m15_ ON m0_.idPreviewImage = m15_.id WHERE m0_.id = ?
Parameters:
[
232567
]
|
|
50.35 ms (6.20%) |
1 |
SELECT a.id FROM har_intervenant a, har_ouvrage_intervenant b, har_ouvrage_thematique c, har_thematique d WHERE d.id = :thematique AND b.type_intervenant_id = :type AND c.thematique_id = d.id AND b.ouvrage_id = c.ouvrage_id AND a.id = b.intervenant_id ORDER BY b.intervenant_position, a.nom
Parameters:
[ "thematique" => 79 "type" => 1 ] |
|
29.85 ms (3.67%) |
20 |
SELECT path, parent FROM phpcr_nodes WHERE parent IN (?) AND workspace_name = ? ORDER BY sort_order ASC
Parameters:
[ "/cmf/default/contents" "default_live" ] |
|
21.44 ms (2.64%) |
14 |
SELECT t0.libelle AS libelle_1, t0.description AS description_2, t0.date AS date_3, t0.id AS id_4, t0.created AS created_5, t0.changed AS changed_6, t0.ouvrage_id AS ouvrage_id_7 FROM har_prix t0 WHERE t0.ouvrage_id = ?
Parameters:
[
57535
]
|
|
20.88 ms (2.57%) |
37 |
SELECT t0.libelle AS libelle_1, t0.slug AS slug_2, t0.description AS description_3, t0.level AS level_4, t0.externe_id AS externe_id_5, t0.id AS id_6, t0.created AS created_7, t0.changed AS changed_8, t0.parent_id AS parent_id_9 FROM har_thematique t0 WHERE t0.id = ?
Parameters:
[
79
]
|
|
20.29 ms (2.50%) |
1 |
SELECT h0_.nom AS nom_0, h0_.slug AS slug_1, h0_.externe_id AS externe_id_2, h0_.sous_titre AS sous_titre_3, h0_.description AS description_4, h0_.date_revue AS date_revue_5, h0_.abonnement AS abonnement_6, h0_.issn AS issn_7, h0_.periodicite AS periodicite_8, h0_.adresse AS adresse_9, h0_.code_postal AS code_postal_10, h0_.ville AS ville_11, h0_.email AS email_12, h0_.id AS id_13, h0_.created AS created_14, h0_.changed AS changed_15, h0_.editeur_id AS editeur_id_16, h0_.code_pays_id AS code_pays_id_17 FROM har_revue h0_ WHERE h0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY h0_.nom ASC
Parameters:
[ 30 187 47 28 8 17 21 82 92 24 27 34 89 98 99 116 123 148 156 158 179 210 223 ] |
|
19.67 ms (2.42%) |
33 |
SELECT t0.zone_principale AS zone_principale_1, t0.id AS id_2, t0.created AS created_3, t0.changed AS changed_4, t0.ouvrage_id AS ouvrage_id_5, t0.zone_geographique_id AS zone_geographique_id_6 FROM har_ouvrage_zone_geographique t0 WHERE t0.ouvrage_id = ?
Parameters:
[
1
]
|
|
19.23 ms (2.37%) |
1 |
SELECT h0_.type AS type_0, h0_.titre AS titre_1, h0_.slug AS slug_2, h0_.sous_titre AS sous_titre_3, h0_.tome AS tome_4, h0_.revue_numero AS revue_numero_5, h0_.resume AS resume_6, h0_.date_publication AS date_publication_7, h0_.biographie AS biographie_8, h0_.extrait_pdf AS extrait_pdf_9, h0_.extrait_audio AS extrait_audio_10, h0_.sommaire AS sommaire_11, h0_.date_modification AS date_modification_12, h0_.prix_papier AS prix_papier_13, h0_.prix_numerique AS prix_numerique_14, h0_.prix_audio AS prix_audio_15, h0_.disponibilite_epub AS disponibilite_epub_16, h0_.largeur AS largeur_17, h0_.hauteur AS hauteur_18, h0_.nb_pages AS nb_pages_19, h0_.poids AS poids_20, h0_.isbn AS isbn_21, h0_.ean13 AS ean13_22, h0_.ean_epub AS ean_epub_23, h0_.ean_pdf AS ean_pdf_24, h0_.multilingue AS multilingue_25, h0_.avis_expert AS avis_expert_26, h0_.externe_id AS externe_id_27, h0_.image_recto_url_externe AS image_recto_url_externe_28, h0_.image_verso_url_externe AS image_verso_url_externe_29, h0_.updated AS updated_30, h0_.added AS added_31, h0_.image_changed AS image_changed_32, h0_.a_la_une AS a_la_une_33, h0_.lien_aplat AS lien_aplat_34, h0_.id AS id_35, h0_.created AS created_36, h0_.changed AS changed_37, h0_.revue_id AS revue_id_38, h0_.image_recto_id AS image_recto_id_39, h0_.image_verso_id AS image_verso_id_40, h0_.disponibilite_papier_id AS disponibilite_papier_id_41, h0_.disponibilite_numerique_id AS disponibilite_numerique_id_42, h0_.disponibilite_audio_id AS disponibilite_audio_id_43, h0_.editeur_id AS editeur_id_44, h0_.collection_id AS collection_id_45, h0_.sous_collection_id AS sous_collection_id_46, h0_.nature_id AS nature_id_47, h0_.type_couverture_id AS type_couverture_id_48 FROM har_ouvrage h0_ INNER JOIN har_disponibilite_ouvrage h1_ ON h0_.disponibilite_papier_id = h1_.id WHERE h1_.externe_id NOT IN (?, ?) AND h0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY h0_.a_la_une DESC, h0_.date_publication DESC
Parameters:
[ 5 6 16 82022 81957 81951 81922 81756 81758 81761 81746 80768 80804 80695 80648 80606 80631 80587 80588 80608 80397 80564 80332 80244 80245 80259 80260 80339 80158 80159 80181 80247 80034 80095 80119 80164 80200 80058 79954 79886 79914 79921 80006 79844 79641 79819 79740 79745 79680 79421 79514 79339 79230 79231 79243 79244 79252 79331 79332 78939 78941 79174 78953 78969 79203 78997 79035 79064 79067 78871 79120 78924 78926 78833 79147 79148 78844 78770 78635 78670 78746 78750 78756 78557 78559 78562 78578 78486 78348 78354 78455 78459 78258 78337 78357 78382 78329 78431 78233 78319 78031 79163 78134 78073 77915 77948 77872 77746 77788 77634 77771 77565 77706 77727 77723 77475 77678 77568 77572 77627 77342 77360 77361 77439 77248 77255 77256 77280 77336 77339 77171 77346 76619 76622 76555 76422 76545 76638 76242 76227 76305 76070 76018 76092 75919 76005 75866 75846 75841 75838 73985 75829 74025 74098 74124 74195 74153 74163 74152 74200 74238 74264 74294 74348 74381 74422 73945 73929 74456 73934 74514 74554 74555 16101 74550 16116 16208 16274 16320 16351 15812 16429 16430 16431 16434 15846 16458 16459 6032 6058 6063 6141 6109 5866 5899 5904 5885 5886 5913 19 37 40 49 86 221 293 350 384 394 452 463 479 567 6387 695 735 798 822 893 993 996 6507 6514 6510 1083 6524 6535 1169 1173 1203 1206 1228 1235 1267 1291 1295 6565 1304 1340 1387 1417 1445 1499 1519 1551 1602 1627 6642 1714 1740 6697 1770 6718 6723 1853 1884 1893 1947 2005 2059 2068 2075 2085 6798 2119 2188 2191 2204 2205 2208 2295 2306 2308 2324 2316 2423 2444 2494 2508 2528 6843 2544 2672 2706 2716 2733 2744 2827 2831 2842 2907 2923 2971 2978 6946 3068 3074 3093 3215 3242 3247 3310 6983 3303 3370 7004 3417 7014 3434 7018 3625 3629 7082 3711 3757 3829 3862 3930 3997 4000 4059 7212 4164 4303 4323 4427 4439 4449 4467 4481 7299 7310 4574 4575 4580 4620 4647 4653 4716 4753 7391 4905 4921 4931 4935 4942 4960 4968 7475 5151 5155 7515 5208 5252 5257 7585 5288 5299 7609 7617 7645 7694 7729 7765 7801 7822 7856 7859 7866 7877 7889 7918 7984 7991 8045 8070 8080 8087 8089 8099 8134 8163 8230 8267 8299 8356 8382 8429 8643 8700 8712 8748 5369 8907 8909 8990 9038 9043 9111 9181 9217 9223 9267 9274 9327 9341 9353 9448 9456 9457 9510 9515 9556 9612 9701 9766 9864 9934 9936 9940 9958 9996 10016 10022 10059 10060 10064 10075 10151 10170 10291 10311 10314 10375 10360 10395 10408 10484 10597 10625 10648 10658 10720 10700 10835 10887 10961 10979 10983 11034 11098 11146 11170 11160 11191 11230 11342 11301 11310 11274 11329 11388 11375 11413 11458 11566 11664 11767 11791 11890 11948 11998 12022 12128 12244 12259 12269 12252 12254 12377 12433 12438 12474 12485 12560 12583 12622 12631 12643 12653 12800 12838 12875 12915 13020 13058 13072 13112 13140 13143 13203 13204 13225 13235 13270 13345 13387 5621 13486 13577 13626 13657 13672 13707 13721 13743 13826 13831 13868 13859 13947 14009 14133 5658 14342 14443 14572 14730 14763 14795 14807 14821 14856 14886 14906 14895 14968 15206 15214 15249 15291 15287 15331 15390 15455 15550 15558 15642 15665 15673 15711 16524 16529 16541 16659 5751 16742 16766 16797 16928 17042 17170 17186 17195 17188 17220 17221 17279 17327 17457 17464 17523 17541 17598 17669 17661 17660 17697 17757 17770 17773 17836 17842 17881 17909 17912 17928 18021 18031 18065 18143 18159 18281 18319 18373 18389 18407 18442 18460 18610 18611 18647 18660 18709 18737 18749 18811 18854 18905 19157 19115 19085 19178 19199 19257 19238 19243 19220 19289 19461 19466 19426 19428 19442 19728 19799 19810 19797 19777 19787 20014 20026 20025 20063 20153 20279 20300 20437 20420 20371 20384 20454 20621 20627 20702 20777 20761 20763 20967 20968 20969 20950 21328 21330 21302 21308 21416 21417 21375 21567 21656 21866 21807 21881 21968 21977 21942 21949 21916 21901 21902 21944 22165 22110 22175 22220 22245 22184 22318 22383 22360 22398 22488 22464 22441 22451 22452 22429 22430 22440 22525 22507 22676 22694 22665 22643 22813 22880 22812 22814 22802 22972 22948 23006 22977 23028 23123 23159 23240 23251 23271 23394 23402 23417 23425 23437 23438 23460 23518 23539 23614 23684 23726 23819 23842 23976 23977 24016 24155 24141 24324 24317 24358 24443 24446 24463 24486 24490 24505 24506 24607 24750 24736 24715 24721 24741 24773 24879 24882 24903 24929 24977 25007 25029 25002 25200 25214 25299 25311 25331 25508 25441 25450 25452 25458 25460 25462 25484 25495 25497 25548 25610 25612 25617 25751 25915 26171 26206 26232 26233 26234 26249 26328 26376 26413 26414 26523 26597 26703 26815 26843 26873 26893 27013 27015 26992 26996 26997 27008 27122 27129 27154 27235 27240 27261 27515 27440 27465 27491 27511 27517 27607 27611 27628 27802 27760 27770 27805 28116 28112 28191 28180 28192 28170 28373 28593 28596 28652 28659 28661 28667 28702 28684 28903 28824 28811 28874 28876 28880 28885 28900 28902 28938 29004 29130 29189 29225 29262 29282 29391 29408 29419 29441 29487 29495 29546 29550 29616 29784 29691 29703 29710 29722 29772 29869 29830 29858 30007 29993 30008 30012 30020 30021 30043 30098 30099 30225 30234 30325 30405 30714 30454 30464 30508 30533 30670 30726 30948 30926 30894 30895 30849 30853 30932 30939 30946 30961 31002 31196 31210 31244 31247 31018 31108 31369 31320 31402 31448 31543 31581 31756 31758 31763 32264 31939 31970 32047 32104 32194 32222 32302 32474 32350 32475 32372 32429 32448 32464 32469 32544 32604 32770 32646 32666 32688 32690 32815 32961 33060 32937 32894 32904 32907 32918 32967 32983 33072 33073 33096 33102 33127 33149 33169 33183 33235 33238 33244 33256 33280 33281 33324 33364 33631 33635 33476 33473 33483 33493 33539 33543 33555 33600 33633 33714 34054 33974 33880 33882 33885 33928 33951 34030 34086 34212 34151 34185 34196 34203 34264 34412 34385 34354 34431 34452 34497 34460 34594 34721 34699 34748 34816 34833 ] |
|
16.23 ms (2.00%) |
52 |
SELECT t0.thematique_principale AS thematique_principale_1, t0.id AS id_2, t0.created AS created_3, t0.changed AS changed_4, t0.ouvrage_id AS ouvrage_id_5, t0.thematique_id AS thematique_id_6 FROM har_ouvrage_thematique t0 WHERE t0.ouvrage_id = ?
Parameters:
[
16
]
|
|
14.90 ms (1.83%) |
1 |
SELECT w0_.title AS title_0, w0_.webspace_key AS webspace_key_1, w0_.all_domains AS all_domains_2, w0_.content AS content_3, w0_.type AS type_4, w0_.id AS id_5, w1_.url AS url_6, w1_.environment AS environment_7, w1_.id AS id_8 FROM we_analytics w0_ LEFT JOIN we_analytics_domains w2_ ON w0_.id = w2_.analytics LEFT JOIN we_domains w1_ ON w1_.id = w2_.domain WHERE (w0_.all_domains = 1 OR (w1_.url = ? AND w1_.environment = ?)) AND w0_.webspace_key = ? ORDER BY w0_.id ASC, w1_.id ASC
Parameters:
[ "harmattan.feelandclic.dev" "dev" "default" ] |
|
13.71 ms (1.69%) |
1 |
SELECT t0.id AS id_1, t0.created AS created_2, t0.changed AS changed_3, t0.idMediaTypes AS idMediaTypes_4, t0.idPreviewImage AS idPreviewImage_5, t0.idCollections AS idCollections_6, t0.idUsersCreator AS idUsersCreator_7, t0.idUsersChanger AS idUsersChanger_8 FROM me_media t0 WHERE t0.id = ?
Parameters:
[
128995
]
|
|
12.64 ms (1.56%) |
1 |
SELECT prefix, uri FROM phpcr_namespaces
Parameters:
[] |
|
12.02 ms (1.48%) |
1 |
SELECT h0_.nom AS nom_0, h0_.periode_validite_du AS periode_validite_du_1, h0_.periode_validite_au AS periode_validite_au_2, h0_.formats AS formats_3, h0_.cibles AS cibles_4, h0_.montant AS montant_5, h0_.enabled AS enabled_6, h0_.affichage_bandeau AS affichage_bandeau_7, h0_.filtre_par AS filtre_par_8, h0_.id AS id_9, h0_.created AS created_10, h0_.changed AS changed_11, h0_.thematique_id AS thematique_id_12, h0_.zone_geographique_id AS zone_geographique_id_13, h0_.collection_id AS collection_id_14, h0_.idUsersCreator AS idUsersCreator_15, h0_.idUsersChanger AS idUsersChanger_16 FROM har_code_avantage h0_ WHERE h0_.periode_validite_du <= ? AND h0_.periode_validite_au >= ? AND JSON_CONTAINS(h0_.cibles, ?) = 1 AND ((h0_.filtre_par IS NULL OR h0_.filtre_par = '')) AND h0_.enabled = 1 AND h0_.affichage_bandeau = 1 ORDER BY h0_.montant DESC LIMIT 1
Parameters:
[ "2026-02-06 00:00:00" "2026-02-06 00:00:00" "["client"]" ] |
|
9.47 ms (1.17%) |
5 |
SELECT t0.type_intervenant_position AS type_intervenant_position_1, t0.intervenant_position AS intervenant_position_2, t0.id AS id_3, t0.created AS created_4, t0.changed AS changed_5, t0.ouvrage_id AS ouvrage_id_6, t0.type_intervenant_id AS type_intervenant_id_7, t0.intervenant_id AS intervenant_id_8 FROM har_ouvrage_intervenant t0 WHERE t0.ouvrage_id = ?
Parameters:
[
81922
]
|
|
9.13 ms (1.12%) |
3 |
SELECT t0.nom AS nom_1, t0.disponible AS disponible_2, t0.externe_id AS externe_id_3, t0.id AS id_4, t0.created AS created_5, t0.changed AS changed_6 FROM har_disponibilite_ouvrage t0 WHERE t0.id = ?
Parameters:
[
1
]
|
|
7.59 ms (0.93%) |
1 |
SELECT h0_.libelle AS libelle_0, h0_.slug AS slug_1, h0_.description AS description_2, h0_.level AS level_3, h0_.externe_id AS externe_id_4, h0_.id AS id_5, h0_.created AS created_6, h0_.changed AS changed_7, h1_.libelle AS libelle_8, h1_.slug AS slug_9, h1_.description AS description_10, h1_.level AS level_11, h1_.externe_id AS externe_id_12, h1_.id AS id_13, h1_.created AS created_14, h1_.changed AS changed_15, h0_.parent_id AS parent_id_16, h1_.parent_id AS parent_id_17 FROM har_thematique h0_ LEFT JOIN har_thematique h1_ ON h0_.parent_id = h1_.id WHERE h0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY h1_.libelle ASC, h0_.libelle ASC
Parameters:
[ 79 85 84 81 87 86 80 83 88 82 ] |
|
6.74 ms (0.83%) |
1 |
SELECT h0_.nom AS nom_0, h0_.slug AS slug_1, h0_.description AS description_2, h0_.hors_collection AS hors_collection_3, h0_.issn AS issn_4, h0_.erp_id AS erp_id_5, h0_.externe_id AS externe_id_6, h0_.id AS id_7, h0_.created AS created_8, h0_.changed AS changed_9, h0_.editeur_id AS editeur_id_10 FROM har_collection h0_ WHERE h0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY h0_.nom ASC
Parameters:
[ 683 224 230 70 73 434 212 209 276 359 786 302 152 210 290 241 139 47 49 100 662 468 879 1021 113 964 1132 636 1203 58 364 417 521 790 256 384 452 679 823 1024 1218 1254 160 208 355 395 751 192 255 503 635 677 704 707 717 785 826 892 1048 64 201 202 242 394 413 619 641 708 804 840 902 1090 1352 120 122 138 155 157 214 233 293 338 381 516 631 659 660 663 680 686 695 716 765 784 806 835 846 876 916 921 1074 1239 1245 1304 5 17 72 108 111 115 117 121 146 162 174 194 234 237 238 246 250 253 260 263 286 296 367 380 428 435 446 533 550 560 562 617 688 691 693 699 706 709 735 753 768 776 787 788 794 811 819 821 822 833 838 841 853 889 914 945 952 961 978 1115 1123 1156 1170 1176 1183 1189 1195 1206 1216 1224 1250 1255 1267 1277 1305 1312 1326 1343 ] |
|
5.74 ms (0.71%) |
1 |
WITH RECURSIVE thematiques AS ( SELECT id, parent_id FROM har_thematique WHERE id = :id UNION ALL SELECT ht.id, ht.parent_id FROM har_thematique ht JOIN thematiques t ON ht.parent_id = t.id ) SELECT DISTINCT t.id FROM thematiques t JOIN har_ouvrage_thematique ot ON ot.thematique_id = t.id;
Parameters:
[ "id" => 79 ] |
|
5.11 ms (0.63%) |
5 |
SELECT * FROM phpcr_nodes WHERE path = ? AND workspace_name = ? ORDER BY depth, sort_order ASC
Parameters:
[ "/cmf/default/contents" "default_live" ] |
|
4.51 ms (0.55%) |
1 |
SELECT h0_.titre AS titre_0, h0_.source AS source_1, h0_.media AS media_2, h0_.media_url AS media_url_3, h0_.lien AS lien_4, h0_.lien_url AS lien_url_5, h0_.mois AS mois_6, h0_.annee AS annee_7, h0_.externe_id AS externe_id_8, h0_.en_ligne AS en_ligne_9, h0_.date_modification AS date_modification_10, h0_.id AS id_11, h0_.created AS created_12, h0_.changed AS changed_13, h0_.categorie_id AS categorie_id_14, h0_.media_image_id AS media_image_id_15, h0_.lien_fichier_id AS lien_fichier_id_16, h0_.idUsersCreator AS idUsersCreator_17, h0_.idUsersChanger AS idUsersChanger_18 FROM har_actualite_media h0_ WHERE h0_.en_ligne = ? ORDER BY h0_.created DESC LIMIT 3
Parameters:
[
1
]
|
|
3.79 ms (0.47%) |
4 |
SELECT t0.nom AS nom_1, t0.prenom AS prenom_2, t0.slug AS slug_3, t0.photo_url_externe AS photo_url_externe_4, t0.structure_professionnelle AS structure_professionnelle_5, t0.site_web AS site_web_6, t0.facebook AS facebook_7, t0.twitter AS twitter_8, t0.linkedin AS linkedin_9, t0.instagram AS instagram_10, t0.titres_diplomes AS titres_diplomes_11, t0.fonctions_actuelles AS fonctions_actuelles_12, t0.biographie AS biographie_13, t0.autres_parutions AS autres_parutions_14, t0.artiste_id AS artiste_id_15, t0.externe_id AS externe_id_16, t0.date_creation AS date_creation_17, t0.date_modification AS date_modification_18, t0.image_changed AS image_changed_19, t0.id AS id_20, t0.created AS created_21, t0.changed AS changed_22, t0.compte_id AS compte_id_23, t0.photo_id AS photo_id_24, t0.parent_id AS parent_id_25 FROM har_intervenant t0 WHERE t0.id = ?
Parameters:
[
58262
]
|
|
3.61 ms (0.44%) |
1 |
SELECT count(DISTINCT h0_.id) AS sclr_0 FROM har_evenement h0_ WHERE (h0_.date_debut >= ? OR (h0_.date_fin IS NOT NULL AND h0_.date_fin >= ?)) AND h0_.en_ligne = ? ORDER BY h0_.date_debut ASC
Parameters:
[ "2026-02-06" "2026-02-06" 1 ] |
|
3.37 ms (0.42%) |
1 |
SELECT n0.path AS n0_path, n0.identifier AS n0_identifier, n0.props AS n0_props FROM phpcr_nodes n0 WHERE n0.workspace_name = ? AND n0.type IN ('nt:unstructured', 'rep:root') AND (n0.parent = '/cmf/snippets/main_menu' AND EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="jcr:mixinTypes"]/sv:value[text()="sulu:snippet"]) > 0')) ORDER BY CAST(EXTRACTVALUE(n0.numerical_props, '//sv:property[@sv:name="i18n:fr-title"]/sv:value[1]') AS DECIMAL) ASC, EXTRACTVALUE(n0.props, '//sv:property[@sv:name="i18n:fr-title"]/sv:value[1]') ASC
Parameters:
[
"default_live"
]
|
|
3.27 ms (0.40%) |
10 |
SELECT t0.libelle AS libelle_1, t0.slug AS slug_2, t0.description AS description_3, t0.level AS level_4, t0.externe_id AS externe_id_5, t0.id AS id_6, t0.created AS created_7, t0.changed AS changed_8, t0.parent_id AS parent_id_9 FROM har_zone_geographique t0 WHERE t0.id = ?
Parameters:
[
2
]
|
|
2.81 ms (0.35%) |
1 |
SELECT t.id, t.libelle, t.slug, count(*) as nbOuvrage FROM har_thematique t INNER JOIN har_ouvrage_thematique ot ON t.id = ot.thematique_id INNER JOIN har_ouvrage o ON ot.ouvrage_id = o.id INNER JOIN har_disponibilite_ouvrage dp ON o.disponibilite_papier_id = dp.id WHERE t.parent_id = :thematique AND dp.externe_id NOT IN (:disponibilitePapierIds) GROUP BY t.id ORDER BY t.libelle ASC
Parameters:
[ "thematique" => 79 "disponibilitePapierIds" => "5,6" ] |
|
2.73 ms (0.34%) |
1 |
SELECT h0_.libelle AS libelle_0, h0_.slug AS slug_1, h0_.description AS description_2, h0_.level AS level_3, h0_.externe_id AS externe_id_4, h0_.id AS id_5, h0_.created AS created_6, h0_.changed AS changed_7, h1_.libelle AS libelle_8, h1_.slug AS slug_9, h1_.description AS description_10, h1_.level AS level_11, h1_.externe_id AS externe_id_12, h1_.id AS id_13, h1_.created AS created_14, h1_.changed AS changed_15, h0_.parent_id AS parent_id_16, h1_.parent_id AS parent_id_17 FROM har_zone_geographique h0_ LEFT JOIN har_zone_geographique h1_ ON h0_.parent_id = h1_.id WHERE h0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY h0_.libelle ASC
Parameters:
[ 114 21 68 86 64 3 2 79 60 76 223 69 82 62 65 154 20 74 167 14 22 5 7 57 72 73 113 119 155 216 227 36 89 94 116 123 143 173 320 1 38 67 70 84 112 127 129 135 141 150 179 190 209 212 220 230 252 314 323 326 341 344 347 ] |
|
2.13 ms (0.26%) |
4 |
SELECT DATABASE()
Parameters:
[] |
|
1.80 ms (0.22%) |
1 |
SELECT h0_.titre AS titre_0, h0_.slug AS slug_1, h0_.format AS format_2, h0_.date_debut AS date_debut_3, h0_.date_fin AS date_fin_4, h0_.horaire AS horaire_5, h0_.resume AS resume_6, h0_.description AS description_7, h0_.savoir_plus AS savoir_plus_8, h0_.externe_id AS externe_id_9, h0_.en_ligne AS en_ligne_10, h0_.location AS location_11, h0_.nom_lieu AS nom_lieu_12, h0_.email AS email_13, h0_.informations AS informations_14, h0_.date_modification AS date_modification_15, h0_.id AS id_16, h0_.created AS created_17, h0_.changed AS changed_18, h0_.categorie_id AS categorie_id_19, h0_.image_id AS image_id_20 FROM har_evenement h0_ WHERE (h0_.date_debut >= ? OR (h0_.date_fin IS NOT NULL AND h0_.date_fin >= ?)) AND h0_.en_ligne = ? ORDER BY h0_.date_debut ASC LIMIT 4
Parameters:
[ "2026-02-06" "2026-02-06" 1 ] |
|
1.68 ms (0.21%) |
9 |
SELECT t0.nom AS nom_1, t0.slug AS slug_2, t0.description AS description_3, t0.hors_collection AS hors_collection_4, t0.issn AS issn_5, t0.erp_id AS erp_id_6, t0.externe_id AS externe_id_7, t0.id AS id_8, t0.created AS created_9, t0.changed AS changed_10, t0.editeur_id AS editeur_id_11 FROM har_collection t0 WHERE t0.id = ?
Parameters:
[
683
]
|
|
0.92 ms (0.11%) |
1 |
SELECT n0.path AS n0_path, n0.identifier AS n0_identifier, n0.props AS n0_props FROM phpcr_nodes n0 WHERE n0.workspace_name = ? AND n0.type IN ('nt:unstructured', 'rep:root') AND (n0.parent = '/cmf/snippets/footer' AND EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="jcr:mixinTypes"]/sv:value[text()="sulu:snippet"]) > 0')) ORDER BY CAST(EXTRACTVALUE(n0.numerical_props, '//sv:property[@sv:name="i18n:fr-title"]/sv:value[1]') AS DECIMAL) ASC, EXTRACTVALUE(n0.props, '//sv:property[@sv:name="i18n:fr-title"]/sv:value[1]') ASC
Parameters:
[
"default_live"
]
|
|
0.84 ms (0.10%) |
1 |
SELECT h0_.nom AS nom_0, h0_.nom_abrege AS nom_abrege_1, h0_.slug AS slug_2, h0_.description AS description_3, h0_.gln AS gln_4, h0_.groupehmt AS groupehmt_5, h0_.type AS type_6, h0_.adresse AS adresse_7, h0_.code_postal AS code_postal_8, h0_.ville AS ville_9, h0_.telephone AS telephone_10, h0_.telephone2 AS telephone2_11, h0_.email AS email_12, h0_.url AS url_13, h0_.externe_id AS externe_id_14, h0_.date_creation AS date_creation_15, h0_.date_modification AS date_modification_16, h0_.id AS id_17, h0_.created AS created_18, h0_.changed AS changed_19, h0_.logo_id AS logo_id_20, h0_.code_pays_id AS code_pays_id_21 FROM har_editeur h0_ WHERE h0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY h0_.nom ASC
Parameters:
[ 8 2 34 24 73 30 7 12 19 40 84 17 21 27 42 43 64 80 82 85 99 115 ] |
|
0.66 ms (0.08%) |
1 |
SELECT h0_.type AS type_0, h0_.titre AS titre_1, h0_.slug AS slug_2, h0_.sous_titre AS sous_titre_3, h0_.tome AS tome_4, h0_.revue_numero AS revue_numero_5, h0_.resume AS resume_6, h0_.date_publication AS date_publication_7, h0_.biographie AS biographie_8, h0_.extrait_pdf AS extrait_pdf_9, h0_.extrait_audio AS extrait_audio_10, h0_.sommaire AS sommaire_11, h0_.date_modification AS date_modification_12, h0_.prix_papier AS prix_papier_13, h0_.prix_numerique AS prix_numerique_14, h0_.prix_audio AS prix_audio_15, h0_.disponibilite_epub AS disponibilite_epub_16, h0_.largeur AS largeur_17, h0_.hauteur AS hauteur_18, h0_.nb_pages AS nb_pages_19, h0_.poids AS poids_20, h0_.isbn AS isbn_21, h0_.ean13 AS ean13_22, h0_.ean_epub AS ean_epub_23, h0_.ean_pdf AS ean_pdf_24, h0_.multilingue AS multilingue_25, h0_.avis_expert AS avis_expert_26, h0_.externe_id AS externe_id_27, h0_.image_recto_url_externe AS image_recto_url_externe_28, h0_.image_verso_url_externe AS image_verso_url_externe_29, h0_.updated AS updated_30, h0_.added AS added_31, h0_.image_changed AS image_changed_32, h0_.a_la_une AS a_la_une_33, h0_.lien_aplat AS lien_aplat_34, h0_.id AS id_35, h0_.created AS created_36, h0_.changed AS changed_37, h0_.revue_id AS revue_id_38, h0_.image_recto_id AS image_recto_id_39, h0_.image_verso_id AS image_verso_id_40, h0_.disponibilite_papier_id AS disponibilite_papier_id_41, h0_.disponibilite_numerique_id AS disponibilite_numerique_id_42, h0_.disponibilite_audio_id AS disponibilite_audio_id_43, h0_.editeur_id AS editeur_id_44, h0_.collection_id AS collection_id_45, h0_.sous_collection_id AS sous_collection_id_46, h0_.nature_id AS nature_id_47, h0_.type_couverture_id AS type_couverture_id_48 FROM har_ouvrage h0_ INNER JOIN har_disponibilite_ouvrage h1_ ON h0_.disponibilite_papier_id = h1_.id WHERE h1_.externe_id NOT IN (?, ?) AND h0_.id IN (?, ?, ?, ?, ?) ORDER BY h0_.a_la_une DESC, h0_.date_publication DESC
Parameters:
[ 5 6 81922 81923 81896 82016 81806 ] |
|
0.44 ms (0.05%) |
3 |
SELECT t0.email AS email_1, t0.nom AS nom_2, t0.prenom AS prenom_3, t0.telephone AS telephone_4, t0.telephone2 AS telephone2_5, t0.date_naissance AS date_naissance_6, t0.lieu_naissance AS lieu_naissance_7, t0.adresse_intitule AS adresse_intitule_8, t0.adresse AS adresse_9, t0.complement_adresse AS complement_adresse_10, t0.code_postal AS code_postal_11, t0.ville AS ville_12, t0.code_auteur AS code_auteur_13, t0.isni AS isni_14, t0.securite_sociale AS securite_sociale_15, t0.securite_social_numero AS securite_social_numero_16, t0.rib_iban AS rib_iban_17, t0.rib_bic AS rib_bic_18, t0.droits_num AS droits_num_19, t0.externe_id AS externe_id_20, t0.image_auteur_url_externe AS image_auteur_url_externe_21, t0.date_creation AS date_creation_22, t0.date_modification AS date_modification_23, t0.reference AS reference_24, t0.civilite AS civilite_25, t0.indicateur_telephonique AS indicateur_telephonique_26, t0.indicateur_telephonique2 AS indicateur_telephonique2_27, t0.societe AS societe_28, t0.numero_tva AS numero_tva_29, t0.siret AS siret_30, t0.latitude AS latitude_31, t0.longitude AS longitude_32, t0.ref_banque_intitule_compte AS ref_banque_intitule_compte_33, t0.ref_banque_iban AS ref_banque_iban_34, t0.ref_banque_code_swift AS ref_banque_code_swift_35, t0.image_changed AS image_changed_36, t0.client_auteur AS client_auteur_37, t0.id AS id_38, t0.created AS created_39, t0.changed AS changed_40, t0.idUser AS idUser_41, t0.image_auteur_id AS image_auteur_id_42, t0.code_pays_id AS code_pays_id_43 FROM har_compte t0 WHERE t0.idUser = ?
Parameters:
[
35411
]
|
|
0.38 ms (0.05%) |
3 |
SELECT t0.method AS method_1, t0.options AS options_2, t0.id AS id_3, t0.idUsers AS idUsers_4 FROM se_user_two_factors t0 WHERE t0.idUsers = ?
Parameters:
[
35411
]
|
|
0.27 ms (0.03%) |
2 |
SELECT phpcr_type_nodes.name AS node_name, phpcr_type_nodes.is_abstract AS node_abstract, phpcr_type_nodes.is_mixin AS node_mixin, phpcr_type_nodes.queryable AS node_queryable, phpcr_type_nodes.orderable_child_nodes AS node_has_orderable_child_nodes, phpcr_type_nodes.primary_item AS node_primary_item_name, phpcr_type_nodes.supertypes AS declared_super_type_names, phpcr_type_props.name AS property_name, phpcr_type_props.auto_created AS property_auto_created, phpcr_type_props.mandatory AS property_mandatory, phpcr_type_props.protected AS property_protected, phpcr_type_props.on_parent_version AS property_on_parent_version, phpcr_type_props.required_type AS property_required_type, phpcr_type_props.multiple AS property_multiple, phpcr_type_props.fulltext_searchable AS property_fulltext_searchable, phpcr_type_props.query_orderable AS property_query_orderable, phpcr_type_props.default_value as property_default_value, phpcr_type_childs.name AS child_name, phpcr_type_childs.auto_created AS child_auto_created, phpcr_type_childs.mandatory AS child_mandatory, phpcr_type_childs.protected AS child_protected, phpcr_type_childs.on_parent_version AS child_on_parent_version, phpcr_type_childs.default_type AS child_default_type, phpcr_type_childs.primary_types AS child_primary_types FROM phpcr_type_nodes LEFT JOIN phpcr_type_props ON phpcr_type_nodes.node_type_id = phpcr_type_props.node_type_id LEFT JOIN phpcr_type_childs ON phpcr_type_nodes.node_type_id = phpcr_type_childs.node_type_id
Parameters:
[] |
|
0.23 ms (0.03%) |
2 |
SELECT n0.path AS n0_path, n0.identifier AS n0_identifier, n0.props AS n0_props FROM phpcr_nodes n0 WHERE n0.workspace_name = ? AND n0.type IN ('nt:unstructured', 'rep:root') AND (EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:fr-template"]/sv:value[text()="homepage"]) > 0') AND (EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="jcr:mixinTypes"]/sv:value[text()="sulu:page"]) > 0') OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="jcr:mixinTypes"]/sv:value[text()="sulu:home"]) > 0')))
Parameters:
[
"default_live"
]
|
|
0.22 ms (0.03%) |
2 |
SELECT t0.nom AS nom_1, t0.nom_abrege AS nom_abrege_2, t0.slug AS slug_3, t0.description AS description_4, t0.gln AS gln_5, t0.groupehmt AS groupehmt_6, t0.type AS type_7, t0.adresse AS adresse_8, t0.code_postal AS code_postal_9, t0.ville AS ville_10, t0.telephone AS telephone_11, t0.telephone2 AS telephone2_12, t0.email AS email_13, t0.url AS url_14, t0.externe_id AS externe_id_15, t0.date_creation AS date_creation_16, t0.date_modification AS date_modification_17, t0.id AS id_18, t0.created AS created_19, t0.changed AS changed_20, t0.logo_id AS logo_id_21, t0.code_pays_id AS code_pays_id_22 FROM har_editeur t0 WHERE t0.id = ?
Parameters:
[
8
]
|
|
0.22 ms (0.03%) |
1 |
SELECT h0_.type AS type_0, h0_.titre AS titre_1, h0_.slug AS slug_2, h0_.sous_titre AS sous_titre_3, h0_.tome AS tome_4, h0_.revue_numero AS revue_numero_5, h0_.resume AS resume_6, h0_.date_publication AS date_publication_7, h0_.biographie AS biographie_8, h0_.extrait_pdf AS extrait_pdf_9, h0_.extrait_audio AS extrait_audio_10, h0_.sommaire AS sommaire_11, h0_.date_modification AS date_modification_12, h0_.prix_papier AS prix_papier_13, h0_.prix_numerique AS prix_numerique_14, h0_.prix_audio AS prix_audio_15, h0_.disponibilite_epub AS disponibilite_epub_16, h0_.largeur AS largeur_17, h0_.hauteur AS hauteur_18, h0_.nb_pages AS nb_pages_19, h0_.poids AS poids_20, h0_.isbn AS isbn_21, h0_.ean13 AS ean13_22, h0_.ean_epub AS ean_epub_23, h0_.ean_pdf AS ean_pdf_24, h0_.multilingue AS multilingue_25, h0_.avis_expert AS avis_expert_26, h0_.externe_id AS externe_id_27, h0_.image_recto_url_externe AS image_recto_url_externe_28, h0_.image_verso_url_externe AS image_verso_url_externe_29, h0_.updated AS updated_30, h0_.added AS added_31, h0_.image_changed AS image_changed_32, h0_.a_la_une AS a_la_une_33, h0_.lien_aplat AS lien_aplat_34, h0_.id AS id_35, h0_.created AS created_36, h0_.changed AS changed_37, h0_.revue_id AS revue_id_38, h0_.image_recto_id AS image_recto_id_39, h0_.image_verso_id AS image_verso_id_40, h0_.disponibilite_papier_id AS disponibilite_papier_id_41, h0_.disponibilite_numerique_id AS disponibilite_numerique_id_42, h0_.disponibilite_audio_id AS disponibilite_audio_id_43, h0_.editeur_id AS editeur_id_44, h0_.collection_id AS collection_id_45, h0_.sous_collection_id AS sous_collection_id_46, h0_.nature_id AS nature_id_47, h0_.type_couverture_id AS type_couverture_id_48 FROM har_ouvrage h0_ WHERE h0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ 78324 19666 77717 76148 74008 75862 2895 1461 537 13 1830 1 8 9 10 1046 11 12 14 6434 16092 74511 6402 16137 17636 23898 74344 4710 74399 74481 73971 57535 16 ] |
|
0.15 ms (0.02%) |
1 |
SELECT t0.type AS type_1, t0.titre AS titre_2, t0.slug AS slug_3, t0.sous_titre AS sous_titre_4, t0.tome AS tome_5, t0.revue_numero AS revue_numero_6, t0.resume AS resume_7, t0.date_publication AS date_publication_8, t0.biographie AS biographie_9, t0.extrait_pdf AS extrait_pdf_10, t0.extrait_audio AS extrait_audio_11, t0.sommaire AS sommaire_12, t0.date_modification AS date_modification_13, t0.prix_papier AS prix_papier_14, t0.prix_numerique AS prix_numerique_15, t0.prix_audio AS prix_audio_16, t0.disponibilite_epub AS disponibilite_epub_17, t0.largeur AS largeur_18, t0.hauteur AS hauteur_19, t0.nb_pages AS nb_pages_20, t0.poids AS poids_21, t0.isbn AS isbn_22, t0.ean13 AS ean13_23, t0.ean_epub AS ean_epub_24, t0.ean_pdf AS ean_pdf_25, t0.multilingue AS multilingue_26, t0.avis_expert AS avis_expert_27, t0.externe_id AS externe_id_28, t0.image_recto_url_externe AS image_recto_url_externe_29, t0.image_verso_url_externe AS image_verso_url_externe_30, t0.updated AS updated_31, t0.added AS added_32, t0.image_changed AS image_changed_33, t0.a_la_une AS a_la_une_34, t0.lien_aplat AS lien_aplat_35, t0.id AS id_36, t0.created AS created_37, t0.changed AS changed_38, t0.revue_id AS revue_id_39, t0.image_recto_id AS image_recto_id_40, t0.image_verso_id AS image_verso_id_41, t0.disponibilite_papier_id AS disponibilite_papier_id_42, t0.disponibilite_numerique_id AS disponibilite_numerique_id_43, t0.disponibilite_audio_id AS disponibilite_audio_id_44, t0.editeur_id AS editeur_id_45, t0.collection_id AS collection_id_46, t0.sous_collection_id AS sous_collection_id_47, t0.nature_id AS nature_id_48, t0.type_couverture_id AS type_couverture_id_49 FROM har_ouvrage t0 WHERE t0.id IN (NULL)
Parameters:
[] |
|
0.15 ms (0.02%) |
1 |
SELECT t0.version AS version_1, t0.id AS id_2, t0.created AS created_3, t0.changed AS changed_4, t0.idMedia AS idMedia_5, t0.idUsersCreator AS idUsersCreator_6, t0.idUsersChanger AS idUsersChanger_7 FROM me_files t0 WHERE t0.idMedia = ?
Parameters:
[
128995
]
|
|
0.14 ms (0.02%) |
1 |
SELECT DISTINCT h0_.indicateur_telephonique AS indicateur_telephonique_0 FROM har_code_pays h0_ WHERE h0_.indicateur_telephonique IS NOT NULL AND h0_.indisponible = ? ORDER BY CAST(h0_.indicateur_telephonique AS signed) ASC
Parameters:
[
0
]
|
|
0.12 ms (0.01%) |
1 |
SELECT 1 FROM phpcr_workspaces WHERE name = ?
Parameters:
[
"default_live"
]
|
|
0.09 ms (0.01%) |
1 |
SELECT t0.name AS name_1, t0.version AS version_2, t0.subVersion AS subVersion_3, t0.size AS size_4, t0.downloadCounter AS downloadCounter_5, t0.storageOptions AS storageOptions_6, t0.mimeType AS mimeType_7, t0.properties AS properties_8, t0.focusPointX AS focusPointX_9, t0.focusPointY AS focusPointY_10, t0.id AS id_11, t0.created AS created_12, t0.changed AS changed_13, t0.idFileVersionsMetaDefault AS idFileVersionsMetaDefault_14, t0.idFiles AS idFiles_15, t0.idUsersCreator AS idUsersCreator_16, t0.idUsersChanger AS idUsersChanger_17 FROM me_file_versions t0 WHERE t0.idFiles = ?
Parameters:
[
128995
]
|
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.