Executed 648 times
SELECT   sakai_site.site_id,
         sakai_site.title,
         sakai_site.TYPE,
         sakai_site.short_desc,
         sakai_site.description,
         sakai_site.icon_url,
         sakai_site.info_url,
         sakai_site.skin,
         sakai_site.published,
         sakai_site.joinable,
         sakai_site.pubview,
         sakai_site.join_role,
         sakai_site.is_special,
         sakai_site.is_user,
         sakai_site.createdby,
         sakai_site.modifiedby,
         sakai_site.createdon,
         sakai_site.modifiedon,
         sakai_site.custom_page_ordered
FROM     sakai_site, sakai_site_user
WHERE    sakai_site.site_id = sakai_site_user.site_id
AND      sakai_site_user.user_id = :1
AND      sakai_site.is_user = '0'
AND      sakai_site.is_special = '0'
AND      sakai_site_user.permission <= sakai_site.published
ORDER BY sakai_site.title

Executed 5000 times
SELECT group_id,
       name,
       VALUE
FROM   sakai_site_group_property
WHERE  (site_id = :1)
647 v
SELECT COUNT (1)
FROM   sakai_realm_rl_fn
WHERE  realm_key IN (SELECT realm_key
                     FROM   sakai_realm
                     WHERE  sakai_realm.realm_id IN (:1, :2, :3, :4, :5, :6, :7))
AND    function_key IN (SELECT function_key
                        FROM   sakai_realm_function
                        WHERE  function_name = :8)
AND    (   role_key IN
              (SELECT role_key
               FROM   sakai_realm_rl_gr
               WHERE  active = '1'
AND                   user_id = :9
AND                   realm_key IN (SELECT realm_key
                                    FROM   sakai_realm
                                    WHERE  sakai_realm.realm_id IN
                                                (:10, :11, :12, :13, :14, :15, :16)))
        OR role_key IN
              (SELECT role_key
               FROM   sakai_realm_role
               WHERE  role_name = '.anon')
       )

Executed 2500 times
SELECT xml
FROM   content_collection
WHERE  (collection_id = :1)

Executed 1700 times
SELECT COUNT (in_collection)
FROM   content_collection
WHERE  in_collection = :1

Execute 647 times

SELECT structured0_.id AS id95_,
       structured0_.description AS descript2_95_,
       structured0_.documentroot AS document3_95_,
       structured0_.owner AS owner95_,
       structured0_.created AS created95_,
       structured0_.modified AS modified95_,
       structured0_.systemonly AS systemonly95_,
       structured0_.externaltype AS external8_95_,
       structured0_.siteid AS siteid95_,
       structured0_.sitestate AS sitestate95_,
       structured0_.globalstate AS globals11_95_,
       structured0_.schemadata AS schemadata95_,
       structured0_.instruction AS instruc13_95_,
       structured0_.schema_hash AS schema14_95_
FROM   metaobj_form_def structured0_
WHERE  (   structured0_.globalstate = :1
        OR     structured0_.owner = :2
           AND (structured0_.siteid IS NULL)
        OR     (   structured0_.owner = :3
                OR structured0_.sitestate = :4
               )
           AND (structured0_.siteid IN
                      ('5e6485cf-12cf-4e0b-80bc-147738446461',
                       '33b69fdc-c3ae-40e0-00b5-509bb435b645',
                       '8bc07e8f-5f63-4eb5-0057-9e61e76228e1',
                       'ed8d985e-b7d0-4f6f-8078-83faf14e193d',
                       '59cc9409-7eec-4fa6-001f-81bdfd8921c8',
                       '7b63bb84-7a9c-48f3-80ff-bada6ff0177d',
                       '5f8d606e-7548-4837-80fa-c39dce351eed',
                       '6ac2a3ce-a571-472d-808e-8051d364e6d8',
                       'ad014528-46f8-4ae0-8003-07b183d82235',
                       '78a2efd4-d6cf-452b-0054-67e72351fccc',
                       'deb35482-8bc7-46f7-0024-8e25d4e35a51',
                       '1427db11-a2fb-4177-8024-1b1646dbc1cc',
                       'f5d681ed-ee0b-440e-0004-4786019159cd',
                       '59017096-2b50-440e-805c-3f7850f55629',
                       '88cb4150-d5fc-4c2c-80dc-2fd93bfacbe6',
                       'ddfc2fa5-9195-4de4-00dd-120c8c7d925c',
                       'df050695-baa8-464d-00c2-cf586900974f',
                       '6a875e0c-bd7a-4d58-80c1-fed17945c4c8',
                       '8e6e33cf-c60d-4a3f-8065-41e7683bac55',
                       'CFP_260_338',
                       'b39e8d3b-3f8d-4f4d-8093-435362e23b6f',
                       '1fe74a69-15fe-41fc-00f4-2aaec5c14a6e',
                       '!admin',
                       '1a60f1e4-1e72-4e93-8063-5acbf6c70744',
                       'BIENFISICA',
                       'BIENMATEMATICAS',
                       'BIENQUIMICA',
                       'b2f8be89-96eb-4bf1-00b3-48afe214bd20',
                       '854bb4bb-5611-4619-0076-9b8956af2e1e',
                       'ALU_4730_2006',
                       '594aa2bf-8ea9-4c80-006e-7df810e18f6f',
                       '7b3a7ea7-ea8b-4cb3-0071-6c8130321e9e',
                       '2a51de77-e288-4bf7-004e-b10e79ad7549',
                       '7cec0504-8d7b-43cd-0045-d1813b258363',
                       '455cc6d4-1fa9-4da8-808e-f7d01dd8d3fc',
                       'a0491cd7-a162-4f30-8022-db79fe9f22f2',
                       '5e5d0bc7-ecd3-4438-80a8-33d22f9135c9',
                       '9554e26a-aa6a-4063-00a8-eabc5b9de0f2',
                       '5606a4c0-ac5a-4193-80cb-b90f5657c31b',
                       '6f439d14-e126-4921-8096-4caa2286ec16',
                       'cf8eff10-dff5-4a06-000c-af61a63dcfcd',
                       'cd96e9a2-b658-434b-00ac-151e57752de2',
                       'DEMO_POLIFORMAT',
                       '9efa9f75-14ef-423a-0064-5ec14f6e7695',
                       '96ea8d04-50d3-4088-00e3-d4ccee6ba2c3',
                       'ENCUESTA_ALUM',
                       'ENCUESTAS_PROF',
                       'ALU_3352_2006',
                       'e81838e5-1e34-45dd-00e8-0a3a56afe0ca',
                       '6a5aef08-d6cb-4b41-80f6-53d033849c46',
                       'ALU_4790_2006',
                       '034b726f-8c8c-4a17-008d-73271c44b44b',
                       'dfb22537-de5a-4d9b-006d-33d760c07058',
                       'c82c5e7b-2dc0-4e21-80a0-f5cff5f42618',
                       '2a77b0ec-0144-47e1-00e6-8d88101cee77',
                       'b6cbe37c-d6e9-43d1-80dc-e9555b5777e8',
                       'b5a73387-d61f-4a70-8069-03c8d680cb72',
                       '7e03a6f0-7b55-4096-8073-1e00e52b0611',
                       '093a301d-bff6-434e-800b-24e9a6229ceb',
                       'f32f17d2-5e4f-4969-80f8-06d011857ffc',
                       '18d88b39-b643-45ad-002e-faf0cf96f214',
                       'e344e670-f023-44d9-8007-40908b2a1dc9',
                       '9a8d77a4-2deb-4177-004a-b1f057dd4ec6',
                       'c3d3238b-81cb-441d-008f-a79817a40211',
                       'd8288ee1-550c-4724-00fc-82156d6d8e02',
                       'e133a43f-795a-4843-8074-5e27d964bc40',
                       'PRUEBA',
                       'bef40dd0-e949-41d0-00a0-8b3a25f86750',
                       'PortfolioAdmin',
                       '6f0f95fd-83af-431c-8005-665e1f24401e',
                       '49cdcf76-b04f-46e6-80c1-44cfbc3d4a1c',
                       '4b6b60a2-661c-4b22-802f-01ef3d51bec8',
                       '581467f6-386d-4273-806d-bfe2562a3e50',
                       '6d7f4a57-f70a-4c57-8099-22c5658aceac',
                       'e9ad743f-03a4-457c-003e-3e009edfa973',
                       'd1fe0af2-2abc-4abf-00a4-8f7bfa589095',
                       '520f126b-b82f-4dcc-8097-3714f519af47',
                       'mercury',
                       '320ce139-5499-4886-80c4-5aefc912eb5c',
                       '02a7b386-3ad9-4828-80fd-a52d2b7d7425',
                       '85d22642-30a2-45df-807a-4f828cdda428',
                       '2ccc8408-6bd3-4f3c-800e-6b7a948613c0',
                       'be44ff8c-527e-445e-00b7-99e9425b8a63',
                       ''
                      )
               )
       )
AND    structured0_.systemonly <> 1

Executed 647 times
SELECT eid
FROM   sakai_user_id_map
WHERE  user_id = :1