Query Metrics
325
Database Queries
46
Different statements
193.26 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
40.36 ms (20.88%) |
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 19666 23898 81866 81907 81908 81909 81940 81931 81924 80789 80747 80748 80797 80700 80687 80553 80679 80557 80540 80511 80490 80387 80254 80262 80168 80033 80035 80119 79939 80084 79932 79942 79983 79892 79904 79906 79926 79865 79604 79609 79652 79685 79540 79449 79450 79455 79407 79234 79236 79245 78979 79047 78703 78765 78837 78838 78773 78786 78636 78637 78640 78448 78532 78535 78540 78527 78395 78212 78239 78157 78201 78203 78205 78206 78171 78053 78097 78100 78101 78109 78176 78177 78051 78001 77934 77843 77844 77769 77493 77543 77347 77351 77436 77548 77549 77550 77551 77570 77576 77358 77359 77361 77290 77293 77381 77222 77127 76510 76509 76589 76529 76429 76137 76112 76061 76060 75961 75837 75836 75945 75850 75848 73991 74061 74062 74072 74196 74199 74281 74338 74514 16105 16103 16126 16191 16281 16267 16326 16350 15820 15833 15841 16456 6025 6016 6014 6111 6122 5870 5989 5940 5946 376 483 486 524 533 6342 653 6407 6411 6412 6437 6442 779 781 866 871 876 6468 6470 6479 6530 6535 6536 1173 6542 1302 6560 1312 1319 1333 1334 6583 6595 6598 6621 6630 6629 6645 1706 1733 6684 6689 1748 6701 6709 6712 6721 6737 1861 1907 6753 2028 2100 2142 6801 2165 2350 2372 2413 2440 2512 2547 2574 2593 2605 2660 2712 2748 2766 2809 2796 2815 2918 2909 2912 2960 3007 3117 3163 3164 3144 3146 3153 3208 3283 3291 3365 3386 3566 3603 3691 7159 3953 4068 4090 4268 4275 4426 4437 4449 4453 4454 4463 7318 4545 4677 4711 4826 4834 4843 4844 4865 4897 4966 4994 4995 4996 5019 7566 7770 7777 7862 7911 7952 8072 8082 8099 8108 8122 8299 8300 8303 8322 8328 8339 8341 8345 8362 8442 8463 8464 5363 8650 8687 5369 8855 8895 8905 5375 8936 8953 9016 9038 9024 9027 9032 9079 9140 9159 9179 9237 9311 9374 9504 9520 9553 9555 9602 5419 9719 9730 9841 9861 9871 9872 9918 9931 10045 10085 10103 10221 10352 5457 10463 10478 10512 10540 10548 10572 10605 10610 10636 10663 10689 10702 10746 10755 10854 10979 11030 11042 11054 11057 11062 11108 11203 11238 11262 11412 11453 11507 11529 11634 11758 11806 11810 11835 11891 11951 11994 12052 12027 12033 5543 5544 12183 12161 12203 12266 12261 5554 12379 12401 12462 12532 12542 12598 12679 12698 12705 12902 12909 12922 12962 13060 13125 13128 13130 13258 13319 13323 13332 13335 13359 13427 13554 13610 13615 13618 13636 13696 13935 13939 14008 14058 14145 14142 14158 14211 14399 14667 14674 5680 5681 14903 15174 15176 15185 15252 15279 15284 15367 15395 15400 15437 15479 15506 15555 15690 16540 16663 16739 5756 16847 17007 17025 17052 17054 17061 17113 17161 17162 17255 17290 17378 17380 17436 17485 17582 17639 17688 17692 17748 17802 17789 17818 17907 17945 17946 17964 17965 18195 5835 18218 18366 18367 18453 18458 5843 18598 18608 18609 18639 18642 18945 18988 19131 19111 19252 19358 19360 19827 19865 20005 20017 19987 20153 20344 20349 20273 20288 20357 20589 20666 20637 20699 20706 20804 20808 20995 20912 20902 21035 21277 21455 21545 21552 21663 21765 21857 21859 21860 21998 22039 22209 22210 22262 22304 22357 22546 22568 22574 22666 22631 22777 22778 22805 22826 22834 22843 22844 22845 22858 22862 22865 22902 23055 23068 23128 23310 23432 23552 23506 23510 23556 23662 23664 23683 23687 23748 23779 23806 23925 23978 24022 24048 24049 24010 24140 24158 24286 24288 24487 24538 24589 24625 24764 24813 24910 24924 25017 25061 25075 25088 25117 25105 25146 25177 25182 25220 25400 25493 25522 25610 25613 25859 25750 25716 25709 25664 25676 25688 25623 25629 25925 25984 26048 26150 26156 26401 26391 26400 26409 26451 26448 26452 26453 26478 26484 26488 26490 26495 26535 26556 26568 26624 26536 26670 26685 26688 26714 26732 26779 26789 26933 26979 26983 27037 27094 27114 27124 27147 27224 27303 27563 27614 27590 27654 27673 27883 27928 27966 27990 28017 28090 28081 28168 28577 28629 28642 28704 28724 28794 28972 28983 28997 29051 29052 29163 29164 29191 29234 29308 29357 29365 29385 29490 29406 29411 29418 29452 29469 29538 29599 29600 29598 29755 29669 29740 29764 30048 30170 30164 30230 30250 30309 30334 30274 30317 30438 30596 30682 30472 30763 30842 31061 31248 31261 31038 31070 31157 31333 31322 31403 31569 74632 74634 31666 31631 31860 31865 32287 32153 32035 32036 32037 32083 32130 32258 32292 32522 32390 32391 32470 32621 32853 32662 32650 32659 32773 32782 32820 32826 33062 32876 32898 32996 33172 33224 33301 33320 33458 33425 33432 33481 33510 33615 33624 33777 33785 33900 33937 34065 34072 34260 34438 34362 34441 34713 34770 34779 34801 34836 34973 34905 34882 34987 35098 35251 35526 35572 35593 35847 35746 35660 35628 36016 35968 36311 36263 36132 36093 36587 36573 36429 37044 37053 36809 36718 36719 36720 37192 37194 37095 37555 37485 37852 37803 37743 37691 38152 38134 38061 38021 38027 38440 38384 38358 38698 38659 38669 38545 39054 38990 38969 38934 38935 38852 38834 38809 38851 39368 39217 39146 39145 39272 39273 39329 39409 39553 39571 39544 39445 39449 39526 39871 40166 40007 40010 40005 40342 40625 40522 40762 41207 41049 41023 41118 41637 41578 41545 41499 76030 41470 41913 41914 41889 41755 41743 41731 41956 42208 42177 42441 42378 42355 42334 42683 42572 42548 42530 42812 42816 42912 43059 43324 43232 43432 43470 43828 43798 43660 44029 44006 43868 44288 44248 44169 44177 44468 44643 44719 44750 44763 44828 44908 44976 45077 45083 45126 45213 45490 45604 45812 45892 45933 46001 46093 46099 46100 46202 46245 46321 46333 46437 46554 46599 46612 74880 74822 46896 46951 47352 47110 47411 47479 47906 47978 48058 48109 48209 48380 48620 48893 48944 49283 49233 49494 49403 49608 49854 49938 50087 50013 50236 50873 50986 50994 51306 51371 51385 51688 51585 51895 51810 52098 52045 52803 53478 53375 53652 53662 53692 53674 53870 53803 54092 54049 54184 54385 54348 54303 54183 54520 54484 54663 54638 54588 54770 54916 54840 55233 55028 55347 55301 55272 55275 56067 ] |
|
29.10 ms (15.06%) |
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_zone_geographique h3_ ON h0_.id = h3_.ouvrage_id INNER JOIN har_zone_geographique h4_ ON h3_.zone_geographique_id = h4_.id WHERE h2_.externe_id NOT IN (?, ?) AND h4_.id = ? GROUP BY h0_.id ORDER BY SUM(h1_.quantity) DESC LIMIT 4
Parameters:
[ 5 6 76 ] |
|
25.44 ms (13.17%) |
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
]
|
|
15.57 ms (8.06%) |
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:
[ 27008 5980 25206 33243 14973 543 3619 8079 55186 1195 38425 50443 2557 2823 8167 19186 19494 20976 22434 48323 586 1302 1643 1992 2183 2382 4224 4872 5351 5600 5710 11710 15853 19072 20669 22600 23020 32043 38806 46159 48740 48999 460 1023 3620 4045 4529 4750 5015 6057 6095 6277 6625 8298 9786 9819 11355 18278 18615 20925 21759 23138 24127 24363 25006 25888 26676 27005 27821 29446 31879 33175 48277 49210 49560 50351 164 1044 1362 1891 2602 2695 3125 4453 4459 4486 4487 4622 4907 5408 5986 6084 6291 6389 6917 7330 7492 7510 7637 8449 8477 8519 8524 8526 8894 8910 9061 9387 10085 10173 10390 10416 10462 10811 10865 10957 11559 11604 11917 11993 12385 12481 12552 12707 12895 12983 13017 13063 13401 13710 14567 14704 14895 15004 15089 15184 15413 16017 16942 17553 18179 18309 18814 18821 19352 19565 20231 21080 21180 22092 22553 22935 23523 24444 25189 25517 25533 25921 26108 26205 27443 28118 29237 29563 29566 31437 32977 33811 36028 38007 38064 40349 42014 43968 47567 48646 48730 48739 48816 49024 49273 49745 49792 49863 50381 50440 50676 51049 51997 52008 57623 6 339 363 461 615 645 755 1043 1140 1241 1292 1373 1430 1474 1475 1525 1678 1777 2086 2096 2192 2359 2625 2630 2806 2916 2917 3198 3434 3540 3657 3669 3703 3803 3877 3891 3893 4427 4523 4643 4716 4752 4760 4807 5109 5190 5197 5259 5292 5315 5334 5356 5402 5414 5547 5900 5912 5982 6126 6154 6231 6521 6585 6595 6674 6775 6815 6859 6869 6880 6944 7063 7103 7118 7131 7133 7284 7334 7335 7341 7372 7374 7479 7499 7555 7585 7591 7594 7608 7911 7934 7935 8010 8026 8037 8088 8146 8166 8263 8293 8302 8333 8382 8409 8462 8507 8509 8513 8520 8521 8522 8527 8535 8584 8668 8681 8810 8885 8911 9043 9180 9226 9341 9375 9379 9444 9474 9520 9537 9572 9575 9595 9650 9662 9850 10062 10117 10272 10357 10418 10829 10905 10942 10953 10955 11137 11301 11397 11517 11557 11560 11561 11658 11770 11938 11941 11959 12018 12048 12074 12139 12179 12219 12221 12227 12321 12334 12340 12483 12508 12536 12551 12600 12645 12685 12841 12874 13092 13094 13104 13291 13375 13452 13586 13674 13683 13761 13771 13819 13893 13998 14068 14146 14179 14301 14326 14394 14488 14560 14623 14647 14653 14686 15177 15185 15333 15334 15404 15624 15721 15840 15856 15902 16053 16209 16236 16420 16546 16652 16781 16822 16846 16969 17018 17071 17092 17329 17331 17351 17429 17438 17525 17527 17656 17715 17722 17788 17804 17826 17828 17868 17875 17896 17979 17983 18035 18119 18206 18224 18242 18285 18404 18513 18539 18569 18592 18676 18699 18736 18737 18760 19031 19043 19063 19167 19197 19220 19270 19329 19368 19520 19587 19628 19665 19738 19745 19747 19899 19924 19950 19986 20098 20288 20471 20631 20690 20716 20766 20836 21009 21368 21541 21653 21731 21734 21768 21772 21811 21900 21945 22003 22196 22297 22303 22315 22441 22463 22491 22605 22635 22685 22739 23126 23164 23168 23185 23316 23529 23545 23647 23753 23759 23792 23862 23998 24064 24251 24316 24337 24443 24469 24502 24707 24859 24878 24981 25019 25029 25126 25149 25190 25287 25361 25552 26133 26563 26602 26815 27131 27261 27316 27373 27837 28023 28141 28145 28153 28361 28386 28414 28450 28460 28566 28869 28903 28944 28960 29003 29036 29120 29244 29493 29507 29715 29814 29933 29964 29965 30422 31287 31337 31411 31593 31595 31726 32206 32272 32273 32274 32283 32355 32536 32683 32789 32791 32860 33021 33250 33360 33459 33461 33466 33569 33707 33727 33731 33734 34133 34259 34472 34632 35174 35219 35226 35927 35969 35972 36097 36159 36312 36472 36488 36508 36781 36979 37330 37551 38056 38098 38107 38461 38685 38690 38807 39105 39107 39113 39385 39444 39446 39781 40094 40115 40265 40290 40405 40730 41044 41302 41307 41391 41411 41645 42182 42236 42249 42250 42259 42261 42262 42305 42391 42438 42533 42545 42832 42834 42867 42927 43041 43117 43298 43302 43327 43425 43522 43603 43669 43792 43814 43959 44006 44010 44018 44322 44323 44391 44393 44460 44676 44709 44842 44981 44982 44983 45000 45001 45003 45005 45006 45015 45280 45769 45979 46020 46138 46148 46150 46806 46983 47121 47122 47137 47146 47160 47241 47303 47551 47618 47660 48251 48252 48253 48266 48283 48360 48378 48422 48497 48518 48615 48620 48724 48731 48732 48733 48736 48738 48741 48753 48826 48949 48954 49113 49127 49146 49214 49278 49575 49695 49770 49862 49929 49930 50001 50004 50148 50265 50348 50385 50393 50394 50464 50466 50487 50560 50645 50656 50699 50702 50812 50907 50953 51143 51211 51258 51262 51265 51318 51328 51412 51583 51738 51883 51998 52009 52012 52100 52149 52185 52191 52283 52377 52533 52636 52637 52655 52721 52731 52863 52917 52958 53033 53097 53505 53534 53584 53642 53660 53679 53863 53914 53983 54438 54580 54793 54844 54848 54849 54850 54918 54989 55079 55143 55222 55270 55424 55518 55522 55565 55577 55769 55799 55976 56037 56108 56113 56146 56332 56478 56630 56870 56875 56894 57022 57627 57807 58159 58240 58309 58465 58529 58530 58936 59684 ] |
|
14.46 ms (7.48%) |
42 |
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:
[
345
]
|
|
13.61 ms (7.04%) |
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:
[ 6917 5986 5912 6277 6595 6084 27316 6095 25190 1044 14973 26676 2359 5900 3620 9850 3434 1302 6126 5710 2086 2557 6154 3657 460 461 15089 52100 6625 5980 54989 7479 18615 49560 42236 34632 21653 32283 19031 19043 13063 4872 27005 4459 6880 22441 50381 7492 4622 23316 48251 27008 33250 48253 48252 1430 42262 54918 7499 7510 12600 586 20976 49575 14647 13375 40349 1373 11710 755 11397 48266 51258 25006 5600 24707 16089 3893 20716 7555 48277 48283 1195 33569 17715 16420 38007 1992 29003 16822 7585 22092 19587 38056 16969 7591 29933 7594 24337 32043 40405 12685 38064 39385 33459 31593 5408 7608 15856 40115 1678 50953 4045 16846 2382 42533 11941 20098 33727 21772 31337 33360 7637 2630 1643 19986 5351 24878 25533 24316 18242 38098 7372 5334 4752 17092 20471 32272 38107 17018 22739 21900 55079 25126 49863 21180 11355 53914 23862 51049 15185 19747 52863 10416 26563 48360 3669 10865 42927 27131 18736 18404 23792 28361 48378 34259 51328 4807 43117 4224 26133 39444 55270 14567 6231 43302 43327 22685 48422 18309 35972 56146 21731 40730 25361 7911 49695 29446 26602 27261 18676 18737 29036 11770 11917 51262 52958 7934 7935 15334 18569 10811 37551 50440 18224 1362 17983 22196 33175 1292 9595 22315 18206 31595 43603 14179 32860 7334 19329 48323 24502 23545 8010 28414 13998 8026 29715 8037 22463 53584 47660 35226 48497 32206 28869 10117 9662 25189 17722 8079 32355 10942 50676 48518 43814 21734 23998 49745 13893 9650 18035 28566 51738 56894 18539 58465 8088 16017 12139 36781 28960 14326 21541 4427 6 43959 18821 3198 18513 43968 19072 7335 33461 8146 26205 25029 40094 11938 12219 1043 27373 49770 37330 32683 8166 8167 19063 24443 33731 7374 23168 10955 24469 22759 23647 2729 15840 14686 24127 41044 8263 1241 19565 38806 54793 29237 33811 21080 27443 44322 17525 13771 38807 17804 17351 44391 49792 22605 8293 48615 20231 44393 2183 19220 35219 8298 15177 2602 56478 36488 8302 32977 48620 11604 44460 24981 5356 16942 17875 24363 8333 17553 50394 50443 48646 44676 25921 8382 11301 56108 4907 19628 8409 20836 3703 12074 363 57022 28944 55799 615 11959 22434 8449 15404 50812 53660 51583 18278 19352 2916 12551 8462 13401 31287 29964 29965 8477 31726 6585 2192 12221 8507 8509 4486 5190 32791 13819 6859 17656 18285 4716 24859 3619 2806 11559 4523 19665 14704 12048 33243 55518 1525 8513 6869 55186 32273 13452 28460 19197 13683 49862 11517 15902 15413 36979 164 25019 34133 39105 22491 8520 40265 58309 14560 52917 4487 8519 48730 12321 8521 48731 16209 32536 48732 8522 16652 48733 2917 22635 25517 48724 10173 8524 3125 25888 14623 48736 20690 17788 8526 36508 17438 48738 29120 12179 48740 17329 48739 35927 12841 12481 22600 1777 22553 50907 19368 11993 48741 10462 57627 19167 50385 55222 45003 45005 25206 38425 24444 12874 15853 34472 3540 41307 8527 20669 8535 5015 54844 29507 17527 6291 50348 36312 48753 51412 8584 33707 36028 41391 8681 10418 6521 20766 7131 11137 38461 41411 36097 12707 22297 12552 23529 35174 5292 16236 48816 8668 28386 29493 48826 18699 645 54580 16781 10390 2096 15004 32789 17979 17331 19899 8810 21009 5197 30422 12483 48949 26108 20925 51143 9819 52283 6815 22935 48954 29814 55424 9786 7341 12536 20288 8894 22466 23523 57623 50351 7063 19270 6389 24251 8910 41645 8911 50001 27821 50004 21811 2823 53642 46020 12334 19745 3803 48999 17826 33466 27837 17071 4760 40290 19950 4529 11560 2695 33021 4643 46148 50265 14653 11561 23185 13586 54438 28153 9043 31879 49024 11658 46159 51211 28450 9061 18119 36159 10957 21768 13710 26815 9180 17896 29563 19520 4453 9226 10272 25552 15624 46806 49113 23759 35969 39113 13674 38685 13761 7330 38690 49127 21945 7103 32274 28023 10085 1891 18814 23020 49146 55976 15721 1474 7133 51997 55143 53097 16053 51998 9341 1140 14895 10905 42014 9375 12385 13092 9379 31437 12983 12645 5259 29244 47160 39107 6944 9387 28141 23138 5315 23753 12895 10829 22303 14146 11557 543 31411 50148 6057 1023 1475 19186 24064 49210 6674 50645 16546 49214 21368 17429 13094 4188 9444 47303 56875 14488 14068 9474 339 28118 25149 5402 19924 33734 20631 9520 10953 29566 9537 49273 12227 14301 12340 18760 14394 10062 18592 49278 13017 19494 18179 3891 19738 39781 6775 17828 7118 2625 15333 17868 5109 23164 22003 42182 15184 23126 4750 9572 25287 36472 9575 12018 13291 21759 10357 3877 41302 5414 8885 47551 52185 ] |
|
12.56 ms (6.50%) |
1 |
WITH RECURSIVE zones AS ( SELECT id, parent_id FROM har_zone_geographique WHERE parent_id = :parent_id UNION ALL SELECT zg.id, zg.parent_id FROM har_zone_geographique zg JOIN zones z ON zg.parent_id = z.id ) SELECT DISTINCT z.id FROM zones z JOIN har_ouvrage_zone_geographique ozg ON ozg.zone_geographique_id = z.id;
Parameters:
[ "parent_id" => 76 ] |
|
12.13 ms (6.27%) |
1 |
SELECT a.id FROM har_intervenant a, har_ouvrage_intervenant b, har_ouvrage_zone_geographique c, har_zone_geographique d WHERE d.id = :zoneGeographique AND b.type_intervenant_id = :type AND c.zone_geographique_id = d.id AND b.ouvrage_id = c.ouvrage_id AND a.id = b.intervenant_id ORDER BY b.intervenant_position, a.nom
Parameters:
[ "zoneGeographique" => 76 "type" => 1 ] |
|
6.03 ms (3.12%) |
51 |
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:
[
19666
]
|
|
2.20 ms (1.14%) |
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
]
|
|
2.05 ms (1.06%) |
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"
]
|
|
2.04 ms (1.06%) |
12 |
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:
[
76
]
|
|
1.91 ms (0.99%) |
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
]
|
|
1.91 ms (0.99%) |
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:
[ 153 173 170 141 230 166 241 108 176 186 89 120 325 107 349 323 345 307 348 165 185 116 193 344 23 39 79 140 155 175 334 358 236 78 167 171 244 300 370 159 174 342 2 142 72 113 147 157 314 336 360 362 373 160 291 293 322 408 91 295 331 361 363 383 403 35 84 109 110 117 139 152 168 189 209 231 240 266 285 312 316 328 330 332 350 377 385 388 3 24 30 75 76 106 112 114 123 136 154 161 172 177 192 223 235 237 238 239 248 249 257 263 275 333 339 351 354 378 380 386 387 394 405 410 ] |
|
1.81 ms (0.94%) |
15 |
SELECT * FROM phpcr_nodes WHERE identifier = ? AND workspace_name = ?
Parameters:
[ "dd991113-3aa4-4e99-b3f3-684362ec7aa8" "default_live" ] |
|
1.76 ms (0.91%) |
20 |
SELECT path, parent FROM phpcr_nodes WHERE parent IN (?) AND workspace_name = ? ORDER BY sort_order ASC
Parameters:
[ "/cmf/default/contents" "default_live" ] |
|
1.15 ms (0.59%) |
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:
[ 47 70 341 67 394 687 531 382 306 374 1185 55 239 583 836 60 275 90 340 669 88 181 212 240 269 150 205 209 348 468 630 709 735 28 49 57 65 73 93 130 137 230 242 664 683 693 788 822 826 1048 64 89 92 112 117 147 153 160 163 196 208 224 241 250 297 338 362 388 526 556 586 642 658 731 759 775 776 825 840 844 856 857 874 1104 1148 1195 1209 1227 1305 ] |
|
0.93 ms (0.48%) |
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.77 ms (0.40%) |
4 |
SELECT DATABASE()
Parameters:
[] |
|
0.74 ms (0.38%) |
6 |
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:
[
67
]
|
|
0.69 ms (0.36%) |
1 |
SELECT z.id, z.libelle, z.slug, count(*) as nbOuvrage FROM har_zone_geographique z INNER JOIN har_ouvrage_zone_geographique oz ON z.id = oz.zone_geographique_id INNER JOIN har_ouvrage o ON oz.ouvrage_id = o.id INNER JOIN har_disponibilite_ouvrage dp ON o.disponibilite_papier_id = dp.id WHERE z.parent_id = :zoneGeographique AND dp.externe_id NOT IN (:disponibilitePapierIds) GROUP BY 1 ORDER BY 2 ASC
Parameters:
[ "zoneGeographique" => 76 "disponibilitePapierIds" => "5,6" ] |
|
0.68 ms (0.35%) |
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 73 80 66 95 24 2 21 38 ] |
|
0.68 ms (0.35%) |
5 |
SELECT * FROM phpcr_nodes WHERE path = ? AND workspace_name = ? ORDER BY depth, sort_order ASC
Parameters:
[ "/cmf/default/contents" "default_live" ] |
|
0.51 ms (0.26%) |
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:
[
81997
]
|
|
0.45 ms (0.23%) |
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:
[ 69 27 79 151 ] |
|
0.40 ms (0.21%) |
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.31 ms (0.16%) |
3 |
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:
[
5355
]
|
|
0.29 ms (0.15%) |
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.28 ms (0.14%) |
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.24 ms (0.12%) |
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.19 ms (0.10%) |
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.17 ms (0.09%) |
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-04" "2026-02-04" 1 ] |
|
0.17 ms (0.09%) |
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-04 00:00:00" "2026-02-04 00:00:00" "["client"]" ] |
|
0.16 ms (0.09%) |
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
]
|
|
0.16 ms (0.08%) |
2 |
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
]
|
|
0.15 ms (0.08%) |
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.15 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 81875 81893 82005 82006 81997 ] |
|
0.15 ms (0.08%) |
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:
[
76
]
|
|
0.14 ms (0.07%) |
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.13 ms (0.07%) |
1 |
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.13 ms (0.07%) |
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
]
|
|
0.11 ms (0.06%) |
1 |
SELECT prefix, uri FROM phpcr_namespaces
Parameters:
[] |
|
0.11 ms (0.06%) |
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-04" "2026-02-04" 1 ] |
|
0.11 ms (0.06%) |
1 |
SELECT 1 FROM phpcr_workspaces WHERE name = ?
Parameters:
[
"default_live"
]
|
|
0.10 ms (0.05%) |
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.09 ms (0.05%) |
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.