--Run 1 -> $filter = "([ID]='".$sessid.')"; [Mon Jan 18 08:16:13 2016].298000 msPostGISLayerIsOpen called. [Mon Jan 18 08:16:13 2016].299000 msDrawMap(): rendering using outputformat named jpeg (AGG/JPEG). [Mon Jan 18 08:16:13 2016].299000 msDrawMap(): WMS/WFS set-up and query, 0.000s [Mon Jan 18 08:16:13 2016].353000 msDrawMap(): Layer 0 (AVD), 0.054s [Mon Jan 18 08:16:13 2016].353000 msOracleSpatialLayerOpen called with: KARTOBJ_SDO FROM c2.KARTA$TMP2 (Layer pointer 082EC7C0) [Mon Jan 18 08:16:13 2016].390000 msOracleSpatialLayerOpen. Shared connection not available. Creating one. [Mon Jan 18 08:16:13 2016].390000 msConnPoolRegister(X,c2/c2a@//192.168.0.101/fwt,0830E060) [Mon Jan 18 08:16:13 2016].399000 msOracleSpatialLayerFreeItemInfo was called. [Mon Jan 18 08:16:13 2016].399000 msOracleSpatialLayerInitItemInfo was called. [Mon Jan 18 08:16:13 2016].399000 msOracleSpatialLayerTranslateFilter. String: [ID]='1eokfraqi19niup7402g3iflp7' [Mon Jan 18 08:16:13 2016].399000 msOracleSpatialLayerTranslateFilter. There are tokens to process [Mon Jan 18 08:16:13 2016].399000 msOracleSpatialLayerWhichShapes was called. [Mon Jan 18 08:16:13 2016].399000 msOracleSpatialLayerWhichShapes. Using this Sql to retrieve the data: SELECT ID, rownum, KARTOBJ_SDO FROM c2.KARTA$TMP2 WHERE ID = '1eokfraqi19niup7402g3iflp7' AND SDO_FILTER( KARTOBJ_SDO, MDSYS.SDO_GEOMETRY(2003, :srid, NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,3),:ordinates),'querytype=window') = 'TRUE' [Mon Jan 18 08:16:13 2016].399000 msOracleSpatialLayerWhichShapes. Bind values: srid:-1 minx:393339.500000 miny:6773950.000000 maxx:394169.500000 maxy:6774780.000000 [Mon Jan 18 08:16:13 2016].400000 msOracleSpatialLayerWhichShapes bind by name and object. [Mon Jan 18 08:16:13 2016].400000 msOracleSpatialLayerWhichShapes name and object now bound. [Mon Jan 18 08:16:13 2016].403000 msOracleSpatialLayerFreeItemInfo was called. [Mon Jan 18 08:16:13 2016].403000 msOracleSpatialLayerClose was called. Layer: 082EC7C0, Layer name: X [Mon Jan 18 08:16:13 2016].403000 msConnPoolRelease(X,c2/c2a@//192.168.0.101/fwt,0830E060) [Mon Jan 18 08:16:13 2016].403000 msConnPoolClose(c2/c2a@//192.168.0.101/fwt,0830E060) [Mon Jan 18 08:16:13 2016].406000 msDrawMap(): Layer 1 (X), 0.053s [Mon Jan 18 08:16:13 2016].406000 msDrawMap(): Drawing Label Cache, 0.000s [Mon Jan 18 08:16:13 2016].406000 msDrawMap() total time: 0.108s [Mon Jan 18 08:16:13 2016].418000 msOracleSpatialLayerClose was called. Layer: 082EC7C0, Layer name: X --Run 2 -> the filter line is commented [Mon Jan 18 08:27:37 2016].108000 msPostGISLayerIsOpen called. [Mon Jan 18 08:27:37 2016].109000 msDrawMap(): rendering using outputformat named jpeg (AGG/JPEG). [Mon Jan 18 08:27:37 2016].109000 msDrawMap(): WMS/WFS set-up and query, 0.000s [Mon Jan 18 08:27:37 2016].166000 msDrawMap(): Layer 0 (AVD), 0.057s [Mon Jan 18 08:27:37 2016].166000 msOracleSpatialLayerOpen called with: KARTOBJ_SDO FROM c2.KARTA$TMP2 (Layer pointer 0829C7C0) [Mon Jan 18 08:27:37 2016].193000 msOracleSpatialLayerOpen. Shared connection not available. Creating one. [Mon Jan 18 08:27:37 2016].193000 msConnPoolRegister(X,c2/c2a@//192.168.0.101/fwt,082BE060) [Mon Jan 18 08:27:37 2016].202000 msOracleSpatialLayerFreeItemInfo was called. [Mon Jan 18 08:27:37 2016].202000 msOracleSpatialLayerWhichShapes was called. [Mon Jan 18 08:27:37 2016].202000 msOracleSpatialLayerWhichShapes. Using this Sql to retrieve the data: SELECT rownum, KARTOBJ_SDO FROM c2.KARTA$TMP2 WHERE SDO_FILTER( KARTOBJ_SDO, MDSYS.SDO_GEOMETRY(2003, :srid, NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,3),:ordinates),'querytype=window') = 'TRUE' [Mon Jan 18 08:27:37 2016].202000 msOracleSpatialLayerWhichShapes. Bind values: srid:-1 minx:393339.500000 miny:6773950.000000 maxx:394169.500000 maxy:6774780.000000 [Mon Jan 18 08:27:37 2016].203000 msOracleSpatialLayerWhichShapes bind by name and object. [Mon Jan 18 08:27:37 2016].203000 msOracleSpatialLayerWhichShapes name and object now bound. [Mon Jan 18 08:27:37 2016].229000 msOracleSpatialLayerFreeItemInfo was called. [Mon Jan 18 08:27:37 2016].229000 msOracleSpatialLayerClose was called. Layer: 0829C7C0, Layer name: X [Mon Jan 18 08:27:37 2016].229000 msConnPoolRelease(X,c2/c2a@//192.168.0.101/fwt,082BE060) [Mon Jan 18 08:27:37 2016].229000 msConnPoolClose(c2/c2a@//192.168.0.101/fwt,082BE060) [Mon Jan 18 08:27:37 2016].232000 msDrawMap(): Layer 1 (X), 0.066s [Mon Jan 18 08:27:37 2016].232000 msDrawMap(): Drawing Label Cache, 0.000s [Mon Jan 18 08:27:37 2016].232000 msDrawMap() total time: 0.124s [Mon Jan 18 08:27:37 2016].244000 msOracleSpatialLayerClose was called. Layer: 0829C7C0, Layer name: X