General
Name |
Open Connections |
Max Connections |
jacq_mirror |
0 |
100 |
berlinnegatives |
0 |
100 |
autographen |
0 |
100 |
algaterracf1 |
1 |
100 |
ggbn_index |
1 |
100 |
herbar |
5 |
100 |
SQL Queries
|
Name |
Records |
Time |
Usage |
Datasource |
Source |
Line |
Cached |
|
SpecimenPK
|
1 |
67.5 ms |
- |
herbar |
C:\inetpub\wwwroot\Herbarium\templates\build_name_link4.cfm |
214 |
No |
SQL
SELECT Specimen_Pk, SpecimenSequenz, idThumb_FK, MaterialCategoryID
FROM weboutput_2
WHERE HerbariumID like 'BW12718010' group by Specimen_Pk, SpecimenSequenz, idThumb_FK, MaterialCategoryID;
|
|
sp_GetImageDetail_3
|
1 |
60.9 ms |
- |
herbar |
C:\inetpub\wwwroot\Herbarium\templates\build_name_link4.cfm |
0 |
No |
SQL (Merged Parameters)
{ call sp_GetImageDetail_3('151905','1') }
SQL (Explicit Parameters)
{ call sp_GetImageDetail_3({type: "CF_SQL_CHAR", value: '151905'},{type: "CF_SQL_CHAR", value: '1'}) }
|
|
SpecimenSequenz2
|
1 |
15.1 ms |
- |
herbar |
C:\inetpub\wwwroot\Herbarium\specimen.cfm |
224 |
No |
SQL
SELECT Barcode_FK AS Barcode
FROM dbo.trSpecimenIdentifikation
WHERE (dbo.trSpecimenIdentifikation.specimen_fk=151905 AND SpecimenSequenz = 1)
Order by specimensequenz;
|
|
TypisierteNamen
|
0 |
12.2 ms |
- |
herbar |
C:\inetpub\wwwroot\Herbarium\templates\elements\navi\navi-left_viewer_en2.cfm |
15 |
No |
SQL
SELECT * from dbo.View_TypisierteNamen
WHERE (specimen_fk=151905) AND(ProofOnlineDesignation = 0) AND (OnlineDesignation = 0) order by PreferredFlag DESC, TypeName DESC;
|
|
Annotations
|
0 |
10.8 ms |
- |
herbar |
C:\inetpub\wwwroot\Herbarium\templates\elements\navi\navi-left_viewer_en2.cfm |
19 |
No |
SQL
SELECT * from dbo.View_TypisierteNamen
WHERE (specimen_fk=151905) AND OnlineDesignation = 1 AND ProofOnlineDesignation = 0 order by PreferredFlag DESC, TypeName DESC;
|
|
SpecimenData
|
1 |
65.1 ms |
- |
herbar |
C:\inetpub\wwwroot\Herbarium\templates\elements\navi\navi-left_viewer_en2.cfm |
24 |
No |
SQL
SELECT kBarcode AS Barcode, kBarcode, Spepi, Inepi, RankFK, FullNameCache, DesignationType, Identifier, IdentifierDate, TitelEtikett, Meaning, Anmerkungen, TypeMarker, Expeditionsangabe, Locality, Family, Specimen_PK, PartofSpecimen, InitialView, Genus, DefinitionAndExplanation, SourceCatalog, Description, SubColKurzform, AnzahlImages, SpecimenSequenz, AnzahlSpecimen, PathName, Latitude, Longitude, DesignationNotes,Literatur,determinator,TypeDesignationDate,TypeReference,BestReference,BestDesigNotes,TypeDesignation_Fk FROM Weboutput_2
WHERE (specimen_pk=151905) AND (HerbariumID like 'BW12718010') order by SpecimenSequenz
|
|
DNA_Link
|
0 |
3337.5 ms |
- |
ggbn_index |
C:\inetpub\wwwroot\Herbarium\templates\elements\navi\navi-left_viewer_en2.cfm |
34 |
No |
SQL
SELECT ggbnId_encoded FROM ggbn_id WHERE (ggbn_id.guid like '%herbarium.bgbm.org/object/BW12718010')
|
|
Protologe
|
0 |
32.4 ms |
- |
herbar |
C:\inetpub\wwwroot\Herbarium\templates\elements\navi\navi-left_viewer_en2.cfm |
40 |
No |
SQL
SELECT TOP (100) PERCENT * FROM dbo.view_zusaetzliche_Bilder
WHERE (keyword LIKE 'B -W 12718 -01 0%p')
ORDER BY name
|
|
GetWilldenow
|
2 |
343.6 ms |
- |
herbar |
C:\inetpub\wwwroot\Herbarium\templates\elements\navi\navi-left_viewer_en2.cfm |
288 |
No |
SQL
SELECT trSpecimenIdentifikation.Specimen_Fk,kBarcode
FROM Thumbnail INNER JOIN ((tdThumbnailIdentification INNER JOIN fs.tdBarcode ON tdThumbnailIdentification.Barcode_Fk = fs.tdBarcode.kBarcode) INNER JOIN trSpecimenIdentifikation ON fs.tdBarcode.kBarcode = trSpecimenIdentifikation.Barcode_Fk) ON Thumbnail.idThumb = tdThumbnailIdentification.idThumb_FK
WHERE (((Thumbnail.name) Like 'B_-W_12718 %')) group by trSpecimenIdentifikation.Specimen_Fk, kBarcode order by kbarcode;
|
|
sp_GetImageDetail_Willdenow
|
1 |
61.1 ms |
- |
herbar |
C:\inetpub\wwwroot\Herbarium\templates\elements\navi\navi-left_viewer_en2.cfm |
0 |
No |
SQL (Merged Parameters)
{ call sp_GetImageDetail_Willdenow('128423') }
SQL (Explicit Parameters)
{ call sp_GetImageDetail_Willdenow({type: "CF_SQL_CHAR", value: '128423'}) }
|
|
sp_GetImageDetail_Willdenow
|
1 |
57.1 ms |
- |
herbar |
C:\inetpub\wwwroot\Herbarium\templates\elements\navi\navi-left_viewer_en2.cfm |
0 |
No |
SQL (Merged Parameters)
{ call sp_GetImageDetail_Willdenow('151905') }
SQL (Explicit Parameters)
{ call sp_GetImageDetail_Willdenow({type: "CF_SQL_CHAR", value: '151905'}) }
|
|
|