Related Search Behavior Demo

The Grid View below lists all invoice lines of the database. All fields are searcheable, and can be sorted.

The implementation is very easy with RelatedSearchBehavior. Check out the 'Invoiceline' model to see how it is done.

In the left corner above you may have access to debug functionnality. Click on "DB Query" to see the SQL queries, and specifically the search query near the end.

The database is open source from http://chinookdatabase.codeplex.com The schema is shown further below.

Displaying 1-4 of 2240 results.

Invoice	Track Name	Composer	Unit Price	Album Title	Artist	Media Type	Genre	Last Name	First Name	Support Last Name	Support First Name	Support Phone	Support Email

60	Harvester Of Sorrow	James Hetfield and Lars Ulrich	0.99	...And Justice For All	Metallica	MPEG audio file	Metal	Gordon	John	Park	Margaret	+1 (403) 263-4423	margaret@chinookcorp.com
165	Blackened	James Hetfield, Lars Ulrich & Jason Newsted	0.99	...And Justice For All	Metallica	MPEG audio file	Metal	Tremblay	François	Peacock	Jane	+1 (403) 262-3443	jane@chinookcorp.com
165	The Frayed Ends Of Sanity	James Hetfield, Lars Ulrich and Kirk Hammett	0.99	...And Justice For All	Metallica	MPEG audio file	Metal	Tremblay	François	Peacock	Jane	+1 (403) 262-3443	jane@chinookcorp.com
270	...And Justice For All	James Hetfield, Lars Ulrich & Kirk Hammett	0.99	...And Justice For All	Metallica	MPEG audio file	Metal	Girard	Wyatt	Peacock	Jane	+1 (403) 262-3443	jane@chinookcorp.com

+Globals

+Session

+Php

+Request

+Yii::app()


CWebApplication ID:#1
  defaultController: 'site'
  layout: 'main'
  controllerMap: { }
  catchAllRequest: null
  controllerNamespace: null
  CWebApplication->_controllerPath: '/home/www/sitessvn/yii/demos/relatedsearchbehavior/protected/controllers'
  CWebApplication->_viewPath: '/home/www/sitessvn/yii/demos/relatedsearchbehavior/protected/views'
  CWebApplication->_systemViewPath: null
  CWebApplication->_layoutPath: '/home/www/sitessvn/yii/demos/relatedsearchbehavior/protected/views/layouts'
  CWebApplication->_controller: null
  CWebApplication->_theme: null
  name: 'Related Search Behavior Demo'
  charset: 'UTF-8'
  sourceLanguage: 'en_us'
  localeClass: 'CLocale'
  CApplication->_id: null
  CApplication->_basePath: '/home/www/sitessvn/yii/demos/relatedsearchbehavior/protected'
  CApplication->_runtimePath: '/home/www/sitessvn/yii/demos/relatedsearchbehavior/protected/runtime'
  CApplication->_extensionPath: null
  CApplication->_globalState: null
  CApplication->_stateChanged: null
  CApplication->_ended: true
  CApplication->_language: null
  CApplication->_homeUrl: null
  preload:   
    0: 'log'
  behaviors: { }
  CModule->_parentModule: null
  CModule->_modulePath: null
  CModule->_params: CAttributeCollection ID:#2
    caseSensitive: true
    CMap->_d:     
      adminEmail: 'webmaster@example.com'
    CMap->_r: false
    CComponent->_e: null
    CComponent->_m: null
    CComponent->_behaviorsToAttach: null
    CComponent->_isAttachingBehaviors: false
  )
  CModule->_modules: { }
  CModule->_moduleConfig:   
    gii:     
      class: 'system.gii.GiiModule'
      password: 'test'
      ipFilters:       
        0: '127.0.0.1'
        1: '::1'
  CModule->_components:   
    log: CLogRouter ID:#3
      CLogRouter->_routes:       
        0: CFileLogRoute ID:#4
          CFileLogRoute->_maxFileSize: 1024
          CFileLogRoute->_maxLogFiles: 5
          CFileLogRoute->_logPath: '/home/www/sitessvn/yii/demos/relatedsearchbehavior/protected/runtime'
          CFileLogRoute->_logFile: 'application.log'
          rotateByCopy: false
          enabled: true
          levels: 'error, warning, info, trace'
          categories: { }
          except: { }
          filter: null
          logs: { }
          CComponent->_e: null
          CComponent->_m: null
          CComponent->_behaviorsToAttach: null
          CComponent->_isAttachingBehaviors: false
        )
        xweb: XWebDebugRouter ID:#5
          config: 'alignLeft, opaque, runInDebug, fixedPos, yamlStyle'
          allowedIPs:           
            0: '.*'
          enabled: true
          levels: 'error, warning, trace, profile, info'
          categories: { }
          except: { }
          filter: null
          logs: { }
          CComponent->_e: null
          CComponent->_m: null
          CComponent->_behaviorsToAttach: null
          CComponent->_isAttachingBehaviors: false
        )
      behaviors: { }
      CApplicationComponent->_initialized: true
      CComponent->_e: null
      CComponent->_m: null
      CComponent->_behaviorsToAttach: { }
      CComponent->_isAttachingBehaviors: false
    )
    request: CHttpRequest ID:#6
      jsonAsArray: true
      enableCookieValidation: false
      enableCsrfValidation: false
      csrfTokenName: 'YII_CSRF_TOKEN'
      csrfCookie: null
      CHttpRequest->_requestUri: '/index.php?r=site/index&Invoiceline_sort=AlbumTitle'
      CHttpRequest->_pathInfo: null
      CHttpRequest->_scriptFile: '/home/www/sitessvn/yii/demos/relatedsearchbehavior/index.php'
      CHttpRequest->_scriptUrl: '/index.php'
      CHttpRequest->_hostInfo: null
      CHttpRequest->_baseUrl: ''
      CHttpRequest->_cookies: null
      CHttpRequest->_preferredAcceptTypes: null
      CHttpRequest->_preferredLanguages: null
      CHttpRequest->_csrfToken: null
      CHttpRequest->_restParams: null
      CHttpRequest->_httpVersion: null
      CHttpRequest->_port: null
      CHttpRequest->_securePort: null
      behaviors: { }
      CApplicationComponent->_initialized: true
      CComponent->_e: null
      CComponent->_m: null
      CComponent->_behaviorsToAttach: { }
      CComponent->_isAttachingBehaviors: false
    )
    urlManager: CUrlManager ID:#7
      rules: { }
      urlSuffix: ''
      showScriptName: true
      appendParams: true
      routeVar: 'r'
      caseSensitive: true
      matchValue: false
      cacheID: 'cache'
      useStrictParsing: false
      urlRuleClass: 'CUrlRule'
      CUrlManager->_urlFormat: 'get'
      CUrlManager->_rules: { }
      CUrlManager->_baseUrl: '/index.php'
      behaviors: { }
      CApplicationComponent->_initialized: true
      CComponent->_e: null
      CComponent->_m: null
      CComponent->_behaviorsToAttach: { }
      CComponent->_isAttachingBehaviors: false
    )
    db: CDbConnection ID:#8
      connectionString: 'sqlite:protected/data/Chinook_Sqlite_AutoIncrementPKs.sqlite'
      username: ''
      password: ''
      schemaCachingDuration: 0
      schemaCachingExclude: { }
      schemaCacheID: 'cache'
      queryCachingDuration: 0
      queryCachingDependency: null
      queryCachingCount: 0
      queryCacheID: 'cache'
      autoConnect: true
      charset: null
      emulatePrepare: null
      enableParamLogging: false
      enableProfiling: false
      tablePrefix: 'ae_g_'
      initSQLs: null
      driverMap:       
        cubrid: 'CCubridSchema'
        pgsql: 'CPgsqlSchema'
        mysqli: 'CMysqlSchema'
        mysql: 'CMysqlSchema'
        sqlite: 'CSqliteSchema'
        sqlite2: 'CSqliteSchema'
        mssql: 'CMssqlSchema'
        dblib: 'CMssqlSchema'
        sqlsrv: 'CMssqlSchema'
        oci: 'COciSchema'
      pdoClass: 'PDO'
      CDbConnection->_driverName: 'sqlite'
      CDbConnection->_attributes: { }
      CDbConnection->_active: true
      CDbConnection->_pdo: PDO ID:#9
      )
      CDbConnection->_transaction: null
      CDbConnection->_schema: CSqliteSchema ID:#10
        columnTypes:         
          pk: 'integer PRIMARY KEY AUTOINCREMENT NOT NULL'
          bigpk: 'integer PRIMARY KEY AUTOINCREMENT NOT NULL'
          string: 'varchar(255)'
          text: 'text'
          integer: 'integer'
          bigint: 'integer'
          float: 'float'
          decimal: 'decimal'
          datetime: 'datetime'
          timestamp: 'timestamp'
          time: 'time'
          date: 'date'
          binary: 'blob'
          boolean: 'tinyint(1)'
          money: 'decimal(19,4)'
        CDbSchema->_tableNames: { }
        CDbSchema->_tables:         
          invoiceline: CDbTableSchema ID:#11
            name: 'invoiceline'
            rawName: ''invoiceline''
            primaryKey: 'InvoiceLineId'
            sequenceName: ''
            foreignKeys:             
              TrackId:               
                0: 'Track'
                1: 'TrackId'
              InvoiceId:               
                0: 'Invoice'
                1: 'InvoiceId'
            columns:             
              InvoiceLineId: CSqliteColumnSchema ID:#12
                name: 'InvoiceLineId'
                rawName: '"InvoiceLineId"'
                allowNull: false
                dbType: 'integer'
                type: 'integer'
                defaultValue: null
                size: null
                precision: null
                scale: null
                isPrimaryKey: true
                isForeignKey: false
                autoIncrement: true
                comment: null
                CComponent->_e: null
                CComponent->_m: null
                CComponent->_behaviorsToAttach: null
                CComponent->_isAttachingBehaviors: false
              )
              InvoiceId: CSqliteColumnSchema ID:#13
                name: 'InvoiceId'
                rawName: '"InvoiceId"'
                allowNull: false
                dbType: 'integer'
                type: 'integer'
                defaultValue: null
                size: null
                precision: null
                scale: null
                isPrimaryKey: false
                isForeignKey: true
                autoIncrement: false
                comment: null
                CComponent->_e: null
                CComponent->_m: null
                CComponent->_behaviorsToAttach: null
                CComponent->_isAttachingBehaviors: false
              )
              TrackId: CSqliteColumnSchema ID:#14
                name: 'TrackId'
                rawName: '"TrackId"'
                allowNull: false
                dbType: 'integer'
                type: 'integer'
                defaultValue: null
                size: null
                precision: null
                scale: null
                isPrimaryKey: false
                isForeignKey: true
                autoIncrement: false
                comment: null
                CComponent->_e: null
                CComponent->_m: null
                CComponent->_behaviorsToAttach: null
                CComponent->_isAttachingBehaviors: false
              )
              UnitPrice: CSqliteColumnSchema ID:#15
                name: 'UnitPrice'
                rawName: '"UnitPrice"'
                allowNull: false
                dbType: 'numeric(10,2)'
                type: 'string'
                defaultValue: null
                size: 10
                precision: 10
                scale: 2
                isPrimaryKey: false
                isForeignKey: false
                autoIncrement: false
                comment: null
                CComponent->_e: null
                CComponent->_m: null
                CComponent->_behaviorsToAttach: null
                CComponent->_isAttachingBehaviors: false
              )
              Quantity: CSqliteColumnSchema ID:#16
                name: 'Quantity'
                rawName: '"Quantity"'
                allowNull: false
                dbType: 'integer'
                type: 'integer'
                defaultValue: null
                size: null
                precision: null
                scale: null
                isPrimaryKey: false
                isForeignKey: false
                autoIncrement: false
                comment: null
                CComponent->_e: null
                CComponent->_m: null
                CComponent->_behaviorsToAttach: null
                CComponent->_isAttachingBehaviors: false
              )
            CComponent->_e: null
            CComponent->_m: null
            CComponent->_behaviorsToAttach: null
            CComponent->_isAttachingBehaviors: false
          )
          track: CDbTableSchema ID:#17
            name: 'track'
            rawName: ''track''
            primaryKey: 'TrackId'
            sequenceName: ''
            foreignKeys:             
              MediaTypeId:               
                0: 'MediaType'
                1: 'MediaTypeId'
              GenreId:               
                0: 'Genre'
                1: 'GenreId'
              AlbumId:               
                0: 'Album'
                1: 'AlbumId'
            columns:             
              TrackId: CSqliteColumnSchema ID:#18
                name: 'TrackId'
                rawName: '"TrackId"'
                allowNull: false
                dbType: 'integer'
                type: 'integer'
                defaultValue: null
                size: null
                precision: null
                scale: null
                isPrimaryKey: true
                isForeignKey: false
                autoIncrement: true
                comment: null
                CComponent->_e: null
                CComponent->_m: null
                CComponent->_behaviorsToAttach: null
                CComponent->_isAttachingBehaviors: false
              )
              Name: CSqliteColumnSchema ID:#19
                name: 'Name'
                rawName: '"Name"'
                allowNull: false
                dbType: 'nvarchar(200)'
                type: 'string'
                defaultValue: null
                size: 200
                precision: 200
                scale: null
                isPrimaryKey: false
                isForeignKey: false
                autoIncrement: false
                comment: null
                CComponent->_e: null
                CComponent->_m: null
                CComponent->_behaviorsToAttach: null
                CComponent->_isAttachingBehaviors: false
              )
              AlbumId: CSqliteColumnSchema ID:#20
                name: 'AlbumId'
                rawName: '"AlbumId"'
                allowNull: true
                dbType: 'integer'
                type: 'integer'
                defaultValue: null
                size: null
                precision: null
                scale: null
                isPrimaryKey: false
                isForeignKey: true
                autoIncrement: false
                comment: null
                CComponent->_e: null
                CComponent->_m: null
                CComponent->_behaviorsToAttach: null
                CComponent->_isAttachingBehaviors: false
              )
              MediaTypeId: CSqliteColumnSchema ID:#21
                name: 'MediaTypeId'
                rawName: '"MediaTypeId"'
                allowNull: false
                dbType: 'integer'
                type: 'integer'
                defaultValue: null
                size: null
                precision: null
                scale: null
                isPrimaryKey: false
                isForeignKey: true
                autoIncrement: false
                comment: null
                CComponent->_e: null
                CComponent->_m: null
                CComponent->_behaviorsToAttach: null
                CComponent->_isAttachingBehaviors: false
              )
              GenreId: CSqliteColumnSchema ID:#22
                name: 'GenreId'
                rawName: '"GenreId"'
                allowNull: true
                dbType: 'integer'
                type: 'integer'
                defaultValue: null
                size: null
                precision: null
                scale: null
                isPrimaryKey: false
                isForeignKey: true
                autoIncrement: false
                comment: null
                CComponent->_e: null
                CComponent->_m: null
                CComponent->_behaviorsToAttach: null
                CComponent->_isAttachingBehaviors: false
              )
              Composer: CSqliteColumnSchema ID:#23
                name: 'Composer'
                rawName: '"Composer"'
                allowNull: true
                dbType: 'nvarchar(220)'
                type: 'string'
                defaultValue: null
                size: 220
                precision: 220
                scale: null
                isPrimaryKey: false
                isForeignKey: false
                autoIncrement: false
                comment: null
                CComponent->_e: null
                CComponent->_m: null
                CComponent->_behaviorsToAttach: null
                CComponent->_isAttachingBehaviors: false
              )
              Milliseconds: CSqliteColumnSchema ID:#24
                name: 'Milliseconds'
                rawName: '"Milliseconds"'
                allowNull: false
                dbType: 'integer'
                type: 'integer'
                defaultValue: null
                size: null
                precision: null
                scale: null
                isPrimaryKey: false
                isForeignKey: false
                autoIncrement: false
                comment: null
                CComponent->_e: null
                CComponent->_m: null
                CComponent->_behaviorsToAttach: null
                CComponent->_isAttachingBehaviors: false
              )
              Bytes: CSqliteColumnSchema ID:#25
                name: 'Bytes'
                rawName: '"Bytes"'
                allowNull: true
                dbType: 'integer'
                type: 'integer'
                defaultValue: null
                size: null
                precision: null
                scale: null
                isPrimaryKey: false
                isForeignKey: false
                autoIncrement: false
                comment: null
                CComponent->_e: null
                CComponent->_m: null
                CComponent->_behaviorsToAttach: null
                CComponent->_isAttachingBehaviors: false
              )
              UnitPrice: CSqliteColumnSchema ID:#26
                name: 'UnitPrice'
                rawName: '"UnitPrice"'
                allowNull: false
                dbType: 'numeric(10,2)'
                type: 'string'
                defaultValue: null
                size: 10
                precision: 10
                scale: 2
                isPrimaryKey: false
                isForeignKey: false
                autoIncrement: false
                comment: null
                CComponent->_e: null
                CComponent->_m: null
                CComponent->_behaviorsToAttach: null
                CComponent->_isAttachingBehaviors: false
              )
            CComponent->_e: null
            CComponent->_m: null
            CComponent->_behaviorsToAttach: null
            CComponent->_isAttachingBehaviors: false
          )
          invoice: CDbTableSchema ID:#27
            name: 'invoice'
            rawName: ''invoice''
            primaryKey: 'InvoiceId'
            sequenceName: ''
            foreignKeys:             
              CustomerId:               
                0: 'Customer'
                1: 'CustomerId'
            columns:             
              InvoiceId: CSqliteColumnSchema ID:#28
                name: 'InvoiceId'
                rawName: '"InvoiceId"'
                allowNull: false
                dbType: 'integer'
                type: 'integer'
                defaultValue: null
                size: null
                precision: null
                scale: null
                isPrimaryKey: true
                isForeignKey: false
                autoIncrement: true
                comment: null
                CComponent->_e: null
                CComponent->_m: null
                CComponent->_behaviorsToAttach: null
                CComponent->_isAttachingBehaviors: false
              )
              CustomerId: CSqliteColumnSchema ID:#29
                name: 'CustomerId'
                rawName: '"CustomerId"'
                allowNull: false
                dbType: 'integer'
                type: 'integer'
                defaultValue: null
                size: null
                precision: null
                scale: null
                isPrimaryKey: false
                isForeignKey: true
                autoIncrement: false
                comment: null
                CComponent->_e: null
                CComponent->_m: null
                CComponent->_behaviorsToAttach: null
                CComponent->_isAttachingBehaviors: false
              )
              InvoiceDate: CSqliteColumnSchema ID:#30
                name: 'InvoiceDate'
                rawName: '"InvoiceDate"'
                allowNull: false
                dbType: 'datetime'
                type: 'string'
                defaultValue: null
                size: null
                precision: null
                scale: null
                isPrimaryKey: false
                isForeignKey: false
                autoIncrement: false
                comment: null
                CComponent->_e: null
                CComponent->_m: null
                CComponent->_behaviorsToAttach: null
                CComponent->_isAttachingBehaviors: false
              )
              BillingAddress: CSqliteColumnSchema ID:#31
                name: 'BillingAddress'
                rawName: '"BillingAddress"'
                allowNull: true
                dbType: 'nvarchar(70)'
                type: 'string'
                defaultValue: null
                size: 70
                precision: 70
                scale: null
                isPrimaryKey: false
                isForeignKey: false
                autoIncrement: false
                comment: null
                CComponent->_e: null
                CComponent->_m: null
                CComponent->_behaviorsToAttach: null
                CComponent->_isAttachingBehaviors: false
              )
              BillingCity: CSqliteColumnSchema ID:#32
                name: 'BillingCity'
                rawName: '"BillingCity"'
                allowNull: true
                dbType: 'nvarchar(40)'
                type: 'string'
                defaultValue: null
                size: 40
                precision: 40
                scale: null
                isPrimaryKey: false
                isForeignKey: false
                autoIncrement: false
                comment: null
                CComponent->_e: null
                CComponent->_m: null
                CComponent->_behaviorsToAttach: null
                CComponent->_isAttachingBehaviors: false
              )
              BillingState: CSqliteColumnSchema ID:#33
                name: 'BillingState'
                rawName: '"BillingState"'
                allowNull: true
                dbType: 'nvarchar(40)'
                type: 'string'
                defaultValue: null
                size: 40
                precision: 40
                scale: null
                isPrimaryKey: false
                isForeignKey: false
                autoIncrement: false
                comment: null
                CComponent->_e: null
                CComponent->_m: null
                CComponent->_behaviorsToAttach: null
                CComponent->_isAttachingBehaviors: false
              )
              BillingCountry: CSqliteColumnSchema ID:#34
                name: 'BillingCountry'
                rawName: '"BillingCountry"'
                allowNull: true
                dbType: 'nvarchar(40)'
                type: 'string'
                defaultValue: null
                size: 40
                precision: 40
                scale: null
                isPrimaryKey: false
                isForeignKey: false
                autoIncrement: false
                comment: null
                CComponent->_e: null
                CComponent->_m: null
                CComponent->_behaviorsToAttach: null
                CComponent->_isAttachingBehaviors: false
              )
              BillingPostalCode: CSqliteColumnSchema ID:#35
                name: 'BillingPostalCode'
                rawName: '"BillingPostalCode"'
                allowNull: true
                dbType: 'nvarchar(10)'
                type: 'string'
                defaultValue: null
                size: 10
                precision: 10
                scale: null
                isPrimaryKey: false
                isForeignKey: false
                autoIncrement: false
                comment: null
                CComponent->_e: null
                CComponent->_m: null
                CComponent->_behaviorsToAttach: null
                CComponent->_isAttachingBehaviors: false
              )
              Total: CSqliteColumnSchema ID:#36
                name: 'Total'
                rawName: '"Total"'
                allowNull: false
                dbType: 'numeric(10,2)'
                type: 'string'
                defaultValue: null
                size: 10
                precision: 10
                scale: 2
                isPrimaryKey: false
                isForeignKey: false
                autoIncrement: false
                comment: null
                CComponent->_e: null
                CComponent->_m: null
                CComponent->_behaviorsToAttach: null
                CComponent->_isAttachingBehaviors: false
              )
            CComponent->_e: null
            CComponent->_m: null
            CComponent->_behaviorsToAttach: null
            CComponent->_isAttachingBehaviors: false
          )
          album: CDbTableSchema ID:#37
            name: 'album'
            rawName: ''album''
            primaryKey: 'AlbumId'
            sequenceName: ''
            foreignKeys:             
              ArtistId:               
                0: 'Artist'
                1: 'ArtistId'
            columns:             
              AlbumId: CSqliteColumnSchema ID:#38
                name: 'AlbumId'
                rawName: '"AlbumId"'
                allowNull: false
                dbType: 'integer'
                type: 'integer'
                defaultValue: null
                size: null
                precision: null
                scale: null
                isPrimaryKey: true
                isForeignKey: false
                autoIncrement: true
                comment: null
                CComponent->_e: null
                CComponent->_m: null
                CComponent->_behaviorsToAttach: null
                CComponent->_isAttachingBehaviors: false
              )
              Title: CSqliteColumnSchema ID:#39
                name: 'Title'
                rawName: '"Title"'
                allowNull: false
                dbType: 'nvarchar(160)'
                type: 'string'
                defaultValue: null
                size: 160
                precision: 160
                scale: null
                isPrimaryKey: false
                isForeignKey: false
                autoIncrement: false
                comment: null
                CComponent->_e: null
                CComponent->_m: null
                CComponent->_behaviorsToAttach: null
                CComponent->_isAttachingBehaviors: false
              )
              ArtistId: CSqliteColumnSchema ID:#40
                name: 'ArtistId'
                rawName: '"ArtistId"'
                allowNull: false
                dbType: 'integer'
                type: 'integer'
                defaultValue: null
                size: null
                precision: null
                scale: null
                isPrimaryKey: false
                isForeignKey: true
                autoIncrement: false
                comment: null
                CComponent->_e: null
                CComponent->_m: null
                CComponent->_behaviorsToAttach: null
                CComponent->_isAttachingBehaviors: false
              )
            CComponent->_e: null
            CComponent->_m: null
            CComponent->_behaviorsToAttach: null
            CComponent->_isAttachingBehaviors: false
          )
          artist: CDbTableSchema ID:#41
            name: 'artist'
            rawName: ''artist''
            primaryKey: 'ArtistId'
            sequenceName: ''
            foreignKeys: { }
            columns:             
              ArtistId: CSqliteColumnSchema ID:#42
                name: 'ArtistId'
                rawName: '"ArtistId"'
                allowNull: false
                dbType: 'integer'
                type: 'integer'
                defaultValue: null
                size: null
                precision: null
                scale: null
                isPrimaryKey: true
                isForeignKey: false
                autoIncrement: true
                comment: null
                CComponent->_e: null
                CComponent->_m: null
                CComponent->_behaviorsToAttach: null
                CComponent->_isAttachingBehaviors: false
              )
              Name: CSqliteColumnSchema ID:#43
                name: 'Name'
                rawName: '"Name"'
                allowNull: true
                dbType: 'nvarchar(120)'
                type: 'string'
                defaultValue: null
                size: 120
                precision: 120
                scale: null
                isPrimaryKey: false
                isForeignKey: false
                autoIncrement: false
                comment: null
                CComponent->_e: null
                CComponent->_m: null
                CComponent->_behaviorsToAttach: null
                CComponent->_isAttachingBehaviors: false
              )
            CComponent->_e: null
            CComponent->_m: null
            CComponent->_behaviorsToAttach: null
            CComponent->_isAttachingBehaviors: false
          )
          mediatype: CDbTableSchema ID:#44
            name: 'mediatype'
            rawName: ''mediatype''
            primaryKey: 'MediaTypeId'
            sequenceName: ''
            foreignKeys: { }
            columns:             
              MediaTypeId: CSqliteColumnSchema ID:#45
                name: 'MediaTypeId'
                rawName: '"MediaTypeId"'
                allowNull: false
                dbType: 'integer'
                type: 'integer'
                defaultValue: null
                size: null
                precision: null
                scale: null
                isPrimaryKey: true
                isForeignKey: false
                autoIncrement: true
                comment: null
                CComponent->_e: null
                CComponent->_m: null
                CComponent->_behaviorsToAttach: null
                CComponent->_isAttachingBehaviors: false
              )
              Name: CSqliteColumnSchema ID:#46
                name: 'Name'
                rawName: '"Name"'
                allowNull: true
                dbType: 'nvarchar(120)'
                type: 'string'
                defaultValue: null
                size: 120
                precision: 120
                scale: null
                isPrimaryKey: false
                isForeignKey: false
                autoIncrement: false
                comment: null
                CComponent->_e: null
                CComponent->_m: null
                CComponent->_behaviorsToAttach: null
                CComponent->_isAttachingBehaviors: false
              )
            CComponent->_e: null
            CComponent->_m: null
            CComponent->_behaviorsToAttach: null
            CComponent->_isAttachingBehaviors: false
          )
          customer: CDbTableSchema ID:#47
            name: 'customer'
            rawName: ''customer''
            primaryKey: 'CustomerId'
            sequenceName: ''
            foreignKeys:             
              SupportRepId:               
                0: 'Employee'
                1: 'EmployeeId'
            columns:             
              CustomerId: CSqliteColumnSchema ID:#48
                name: 'CustomerId'
                rawName: '"CustomerId"'
                allowNull: false
                dbType: 'integer'
                type: 'integer'
                defaultValue: null
                size: null
                precision: null
                scale: null
                isPrimaryKey: true
                isForeignKey: false
                autoIncrement: true
                comment: null
                CComponent->_e: null
                CComponent->_m: null
                CComponent->_behaviorsToAttach: null
                CComponent->_isAttachingBehaviors: false
              )
              FirstName: CSqliteColumnSchema ID:#49
                name: 'FirstName'
                rawName: '"FirstName"'
                allowNull: false
                dbType: 'nvarchar(40)'
                type: 'string'
                defaultValue: null
                size: 40
                precision: 40
                scale: null
                isPrimaryKey: false
                isForeignKey: false
                autoIncrement: false
                comment: null
                CComponent->_e: null
                CComponent->_m: null
                CComponent->_behaviorsToAttach: null
                CComponent->_isAttachingBehaviors: false
              )
              LastName: CSqliteColumnSchema ID:#50
                name: 'LastName'
                rawName: '"LastName"'
                allowNull: false
                dbType: 'nvarchar(20)'
                type: 'string'
                defaultValue: null
                size: 20
                precision: 20
                scale: null
                isPrimaryKey: false
                isForeignKey: false
                autoIncrement: false
                comment: null
                CComponent->_e: null
                CComponent->_m: null
                CComponent->_behaviorsToAttach: null
                CComponent->_isAttachingBehaviors: false
              )
              Company: CSqliteColumnSchema ID:#51
                name: 'Company'
                rawName: '"Company"'
                allowNull: true
                dbType: 'nvarchar(80)'
                type: 'string'
                defaultValue: null
                size: 80
                precision: 80
                scale: null
                isPrimaryKey: false
                isForeignKey: false
                autoIncrement: false
                comment: null
                CComponent->_e: null
                CComponent->_m: null
                CComponent->_behaviorsToAttach: null
                CComponent->_isAttachingBehaviors: false
              )
              Address: CSqliteColumnSchema ID:#52
                name: 'Address'
                rawName: '"Address"'
                allowNull: true
                dbType: 'nvarchar(70)'
                type: 'string'
                defaultValue: null
                size: 70
                precision: 70
                scale: null
                isPrimaryKey: false
                isForeignKey: false
                autoIncrement: false
                comment: null
                CComponent->_e: null
                CComponent->_m: null
                CComponent->_behaviorsToAttach: null
                CComponent->_isAttachingBehaviors: false
              )
              City: CSqliteColumnSchema ID:#53
                name: 'City'
                rawName: '"City"'
                allowNull: true
                dbType: 'nvarchar(40)'
                type: 'string'
                defaultValue: null
                size: 40
                precision: 40
                scale: null
                isPrimaryKey: false
                isForeignKey: false
                autoIncrement: false
                comment: null
                CComponent->_e: null
                CComponent->_m: null
                CComponent->_behaviorsToAttach: null
                CComponent->_isAttachingBehaviors: false
              )
              State: CSqliteColumnSchema ID:#54
                name: 'State'
                rawName: '"State"'
                allowNull: true
                dbType: 'nvarchar(40)'
                type: 'string'
                defaultValue: null
                size: 40
                precision: 40
                scale: null
                isPrimaryKey: false
                isForeignKey: false
                autoIncrement: false
                comment: null
                CComponent->_e: null
                CComponent->_m: null
                CComponent->_behaviorsToAttach: null
                CComponent->_isAttachingBehaviors: false
              )
              Country: CSqliteColumnSchema ID:#55
                name: 'Country'
                rawName: '"Country"'
                allowNull: true
                dbType: 'nvarchar(40)'
                type: 'string'
                defaultValue: null
                size: 40
                precision: 40
                scale: null
                isPrimaryKey: false
                isForeignKey: false
                autoIncrement: false
                comment: null
                CComponent->_e: null
                CComponent->_m: null
                CComponent->_behaviorsToAttach: null
                CComponent->_isAttachingBehaviors: false
              )
              PostalCode: CSqliteColumnSchema ID:#56
                name: 'PostalCode'
                rawName: '"PostalCode"'
                allowNull: true
                dbType: 'nvarchar(10)'
                type: 'string'
                defaultValue: null
                size: 10
                precision: 10
                scale: null
                isPrimaryKey: false
                isForeignKey: false
                autoIncrement: false
                comment: null
                CComponent->_e: null
                CComponent->_m: null
                CComponent->_behaviorsToAttach: null
                CComponent->_isAttachingBehaviors: false
              )
              Phone: CSqliteColumnSchema ID:#57
                name: 'Phone'
                rawName: '"Phone"'
                allowNull: true
                dbType: 'nvarchar(24)'
                type: 'string'
                defaultValue: null
                size: 24
                precision: 24
                scale: null
                isPrimaryKey: false
                isForeignKey: false
                autoIncrement: false
                comment: null
                CComponent->_e: null
                CComponent->_m: null
                CComponent->_behaviorsToAttach: null
                CComponent->_isAttachingBehaviors: false
              )
              Fax: CSqliteColumnSchema ID:#58
                name: 'Fax'
                rawName: '"Fax"'
                allowNull: true
                dbType: 'nvarchar(24)'
                type: 'string'
                defaultValue: null
                size: 24
                precision: 24
                scale: null
                isPrimaryKey: false
                isForeignKey: false
                autoIncrement: false
                comment: null
                CComponent->_e: null
                CComponent->_m: null
                CComponent->_behaviorsToAttach: null
                CComponent->_isAttachingBehaviors: false
              )
              Email: CSqliteColumnSchema ID:#59
                name: 'Email'
                rawName: '"Email"'
                allowNull: false
                dbType: 'nvarchar(60)'
                type: 'string'
                defaultValue: null
                size: 60
                precision: 60
                scale: null
                isPrimaryKey: false
                isForeignKey: false
                autoIncrement: false
                comment: null
                CComponent->_e: null
                CComponent->_m: null
                CComponent->_behaviorsToAttach: null
                CComponent->_isAttachingBehaviors: false
              )
              SupportRepId: CSqliteColumnSchema ID:#60
                name: 'SupportRepId'
                rawName: '"SupportRepId"'
                allowNull: true
                dbType: 'integer'
                type: 'integer'
                defaultValue: null
                size: null
                precision: null
                scale: null
                isPrimaryKey: false
                isForeignKey: true
                autoIncrement: false
                comment: null
                CComponent->_e: null
                CComponent->_m: null
                CComponent->_behaviorsToAttach: null
                CComponent->_isAttachingBehaviors: false
              )
            CComponent->_e: null
            CComponent->_m: null
            CComponent->_behaviorsToAttach: null
            CComponent->_isAttachingBehaviors: false
          )
          employee: CDbTableSchema ID:#61
            name: 'employee'
            rawName: ''employee''
            primaryKey: 'EmployeeId'
            sequenceName: ''
            foreignKeys:             
              ReportsTo:               
                0: 'Employee'
                1: 'EmployeeId'
            columns:             
              EmployeeId: CSqliteColumnSchema ID:#62
                name: 'EmployeeId'
                rawName: '"EmployeeId"'
                allowNull: false
                dbType: 'integer'
                type: 'integer'
                defaultValue: null
                size: null
                precision: null
                scale: null
                isPrimaryKey: true
                isForeignKey: false
                autoIncrement: true
                comment: null
                CComponent->_e: null
                CComponent->_m: null
                CComponent->_behaviorsToAttach: null
                CComponent->_isAttachingBehaviors: false
              )
              LastName: CSqliteColumnSchema ID:#63
                name: 'LastName'
                rawName: '"LastName"'
                allowNull: false
                dbType: 'nvarchar(20)'
                type: 'string'
                defaultValue: null
                size: 20
                precision: 20
                scale: null
                isPrimaryKey: false
                isForeignKey: false
                autoIncrement: false
                comment: null
                CComponent->_e: null
                CComponent->_m: null
                CComponent->_behaviorsToAttach: null
                CComponent->_isAttachingBehaviors: false
              )
              FirstName: CSqliteColumnSchema ID:#64
                name: 'FirstName'
                rawName: '"FirstName"'
                allowNull: false
                dbType: 'nvarchar(20)'
                type: 'string'
                defaultValue: null
                size: 20
                precision: 20
                scale: null
                isPrimaryKey: false
                isForeignKey: false
                autoIncrement: false
                comment: null
                CComponent->_e: null
                CComponent->_m: null
                CComponent->_behaviorsToAttach: null
                CComponent->_isAttachingBehaviors: false
              )
              Title: CSqliteColumnSchema ID:#65
                name: 'Title'
                rawName: '"Title"'
                allowNull: true
                dbType: 'nvarchar(30)'
                type: 'string'
                defaultValue: null
                size: 30
                precision: 30
                scale: null
                isPrimaryKey: false
                isForeignKey: false
                autoIncrement: false
                comment: null
                CComponent->_e: null
                CComponent->_m: null
                CComponent->_behaviorsToAttach: null
                CComponent->_isAttachingBehaviors: false
              )
              ReportsTo: CSqliteColumnSchema ID:#66
                name: 'ReportsTo'
                rawName: '"ReportsTo"'
                allowNull: true
                dbType: 'integer'
                type: 'integer'
                defaultValue: null
                size: null
                precision: null
                scale: null
                isPrimaryKey: false
                isForeignKey: true
                autoIncrement: false
                comment: null
                CComponent->_e: null
                CComponent->_m: null
                CComponent->_behaviorsToAttach: null
                CComponent->_isAttachingBehaviors: false
              )
              BirthDate: CSqliteColumnSchema ID:#67
                name: 'BirthDate'
                rawName: '"BirthDate"'
                allowNull: true
                dbType: 'datetime'
                type: 'string'
                defaultValue: null
                size: null
                precision: null
                scale: null
                isPrimaryKey: false
                isForeignKey: false
                autoIncrement: false
                comment: null
                CComponent->_e: null
                CComponent->_m: null
                CComponent->_behaviorsToAttach: null
                CComponent->_isAttachingBehaviors: false
              )
              HireDate: CSqliteColumnSchema ID:#68
                name: 'HireDate'
                rawName: '"HireDate"'
                allowNull: true
                dbType: 'datetime'
                type: 'string'
                defaultValue: null
                size: null
                precision: null
                scale: null
                isPrimaryKey: false
                isForeignKey: false
                autoIncrement: false
                comment: null
                CComponent->_e: null
                CComponent->_m: null
                CComponent->_behaviorsToAttach: null
                CComponent->_isAttachingBehaviors: false
              )
              Address: CSqliteColumnSchema ID:#69
                name: 'Address'
                rawName: '"Address"'
                allowNull: true
                dbType: 'nvarchar(70)'
                type: 'string'
                defaultValue: null
                size: 70
                precision: 70
                scale: null
                isPrimaryKey: false
                isForeignKey: false
                autoIncrement: false
                comment: null
                CComponent->_e: null
                CComponent->_m: null
                CComponent->_behaviorsToAttach: null
                CComponent->_isAttachingBehaviors: false
              )
              City: CSqliteColumnSchema ID:#70
                name: 'City'
                rawName: '"City"'
                allowNull: true
                dbType: 'nvarchar(40)'
                type: 'string'
                defaultValue: null
                size: 40
                precision: 40
                scale: null
                isPrimaryKey: false
                isForeignKey: false
                autoIncrement: false
                comment: null
                CComponent->_e: null
                CComponent->_m: null
                CComponent->_behaviorsToAttach: null
                CComponent->_isAttachingBehaviors: false
              )
              State: CSqliteColumnSchema ID:#71
                name: 'State'
                rawName: '"State"'
                allowNull: true
                dbType: 'nvarchar(40)'
                type: 'string'
                defaultValue: null
                size: 40
                precision: 40
                scale: null
                isPrimaryKey: false
                isForeignKey: false
                autoIncrement: false
                comment: null
                CComponent->_e: null
                CComponent->_m: null
                CComponent->_behaviorsToAttach: null
                CComponent->_isAttachingBehaviors: false
              )
              Country: CSqliteColumnSchema ID:#72
                name: 'Country'
                rawName: '"Country"'
                allowNull: true
                dbType: 'nvarchar(40)'
                type: 'string'
                defaultValue: null
                size: 40
                precision: 40
                scale: null
                isPrimaryKey: false
                isForeignKey: false
                autoIncrement: false
                comment: null
                CComponent->_e: null
                CComponent->_m: null
                CComponent->_behaviorsToAttach: null
                CComponent->_isAttachingBehaviors: false
              )
              PostalCode: CSqliteColumnSchema ID:#73
                name: 'PostalCode'
                rawName: '"PostalCode"'
                allowNull: true
                dbType: 'nvarchar(10)'
                type: 'string'
                defaultValue: null
                size: 10
                precision: 10
                scale: null
                isPrimaryKey: false
                isForeignKey: false
                autoIncrement: false
                comment: null
                CComponent->_e: null
                CComponent->_m: null
                CComponent->_behaviorsToAttach: null
                CComponent->_isAttachingBehaviors: false
              )
              Phone: CSqliteColumnSchema ID:#74
                name: 'Phone'
                rawName: '"Phone"'
                allowNull: true
                dbType: 'nvarchar(24)'
                type: 'string'
                defaultValue: null
                size: 24
                precision: 24
                scale: null
                isPrimaryKey: false
                isForeignKey: false
                autoIncrement: false
                comment: null
                CComponent->_e: null
                CComponent->_m: null
                CComponent->_behaviorsToAttach: null
                CComponent->_isAttachingBehaviors: false
              )
              Fax: CSqliteColumnSchema ID:#75
                name: 'Fax'
                rawName: '"Fax"'
                allowNull: true
                dbType: 'nvarchar(24)'
                type: 'string'
                defaultValue: null
                size: 24
                precision: 24
                scale: null
                isPrimaryKey: false
                isForeignKey: false
                autoIncrement: false
                comment: null
                CComponent->_e: null
                CComponent->_m: null
                CComponent->_behaviorsToAttach: null
                CComponent->_isAttachingBehaviors: false
              )
              Email: CSqliteColumnSchema ID:#76
                name: 'Email'
                rawName: '"Email"'
                allowNull: true
                dbType: 'nvarchar(60)'
                type: 'string'
                defaultValue: null
                size: 60
                precision: 60
                scale: null
                isPrimaryKey: false
                isForeignKey: false
                autoIncrement: false
                comment: null
                CComponent->_e: null
                CComponent->_m: null
                CComponent->_behaviorsToAttach: null
                CComponent->_isAttachingBehaviors: false
              )
            CComponent->_e: null
            CComponent->_m: null
            CComponent->_behaviorsToAttach: null
            CComponent->_isAttachingBehaviors: false
          )
          genre: CDbTableSchema ID:#77
            name: 'genre'
            rawName: ''genre''
            primaryKey: 'GenreId'
            sequenceName: ''
            foreignKeys: { }
            columns:             
              GenreId: CSqliteColumnSchema ID:#78
                name: 'GenreId'
                rawName: '"GenreId"'
                allowNull: false
                dbType: 'integer'
                type: 'integer'
                defaultValue: null
                size: null
                precision: null
                scale: null
                isPrimaryKey: true
                isForeignKey: false
                autoIncrement: true
                comment: null
                CComponent->_e: null
                CComponent->_m: null
                CComponent->_behaviorsToAttach: null
                CComponent->_isAttachingBehaviors: false
              )
              Name: CSqliteColumnSchema ID:#79
                name: 'Name'
                rawName: '"Name"'
                allowNull: true
                dbType: 'nvarchar(120)'
                type: 'string'
                defaultValue: null
                size: 120
                precision: 120
                scale: null
                isPrimaryKey: false
                isForeignKey: false
                autoIncrement: false
                comment: null
                CComponent->_e: null
                CComponent->_m: null
                CComponent->_behaviorsToAttach: null
                CComponent->_isAttachingBehaviors: false
              )
            CComponent->_e: null
            CComponent->_m: null
            CComponent->_behaviorsToAttach: null
            CComponent->_isAttachingBehaviors: false
          )
        CDbSchema->_connection: CDbConnection#8(...)
        CDbSchema->_builder: CSqliteCommandBuilder ID:#80
          CDbCommandBuilder->_schema: CSqliteSchema#10(...)
          CDbCommandBuilder->_connection: CDbConnection#8(...)
          CComponent->_e: null
          CComponent->_m: null
          CComponent->_behaviorsToAttach: null
          CComponent->_isAttachingBehaviors: false
        )
        CDbSchema->_cacheExclude: { }
        CComponent->_e: null
        CComponent->_m: null
        CComponent->_behaviorsToAttach: null
        CComponent->_isAttachingBehaviors: false
      )
      behaviors: { }
      CApplicationComponent->_initialized: true
      CComponent->_e: null
      CComponent->_m: null
      CComponent->_behaviorsToAttach: { }
      CComponent->_isAttachingBehaviors: false
    )
    widgetFactory: CWidgetFactory ID:#81
      enableSkin: false
      widgets: { }
      skinnableWidgets: null
      skinPath: null
      CWidgetFactory->_skins: { }
      behaviors: { }
      CApplicationComponent->_initialized: true
      CComponent->_e: null
      CComponent->_m: null
      CComponent->_behaviorsToAttach: { }
      CComponent->_isAttachingBehaviors: false
    )
    assetManager: CAssetManager ID:#82
      linkAssets: false
      excludeFiles:       
        0: '.svn'
        1: '.gitignore'
      newFileMode: 438
      newDirMode: 511
      forceCopy: false
      CAssetManager->_basePath: '/home/www/sitessvn/yii/demos/relatedsearchbehavior/assets'
      CAssetManager->_baseUrl: '/assets'
      CAssetManager->_published:       
        /home/www/sitessvn/yii/framework/zii/widgets/assets: '/assets/ae15994b'
        /home/www/sitessvn/yii/framework/web/widgets/pagers/pager.css: '/assets/5a7598eb/pager.css'
        /home/www/sitessvn/yii/framework/web/js/source: '/assets/4a5acadb'
      behaviors: { }
      CApplicationComponent->_initialized: true
      CComponent->_e: null
      CComponent->_m: null
      CComponent->_behaviorsToAttach: { }
      CComponent->_isAttachingBehaviors: false
    )
    clientScript: CClientScript ID:#83
      enableJavaScript: true
      scriptMap: { }
      packages: { }
      corePackages:       
        jquery:         
          js:           
            0: 'jquery.js'
        yii:         
          js:           
            0: 'jquery.yii.js'
          depends:           
            0: 'jquery'
        yiitab:         
          js:           
            0: 'jquery.yiitab.js'
          depends:           
            0: 'jquery'
        yiiactiveform:         
          js:           
            0: 'jquery.yiiactiveform.js'
          depends:           
            0: 'jquery'
        jquery.ui:         
          js:           
            0: 'jui/js/jquery-ui.min.js'
          depends:           
            0: 'jquery'
        bgiframe:         
          js:           
            0: 'jquery.bgiframe.js'
          depends:           
            0: 'jquery'
        ajaxqueue:         
          js:           
            0: 'jquery.ajaxqueue.js'
          depends:           
            0: 'jquery'
        autocomplete:         
          js:           
            0: 'jquery.autocomplete.js'
          depends:           
            0: 'jquery'
            1: 'bgiframe'
            2: 'ajaxqueue'
        maskedinput:         
          js:           
            0: 'jquery.maskedinput.js'
          depends:           
            0: 'jquery'
        cookie:         
          js:           
            0: 'jquery.cookie.js'
          depends:           
            0: 'jquery'
        treeview:         
          js:           
            0: 'jquery.treeview.js'
            1: 'jquery.treeview.edit.js'
            2: 'jquery.treeview.async.js'
          depends:           
            0: 'jquery'
            1: 'cookie'
        multifile:         
          js:           
            0: 'jquery.multifile.js'
          depends:           
            0: 'jquery'
        rating:         
          js:           
            0: 'jquery.rating.js'
          depends:           
            0: 'jquery'
            1: 'metadata'
        metadata:         
          js:           
            0: 'jquery.metadata.js'
          depends:           
            0: 'jquery'
        bbq:         
          js:           
            0: 'jquery.ba-bbq.js'
          depends:           
            0: 'jquery'
        history:         
          js:           
            0: 'jquery.history.js'
          depends:           
            0: 'jquery'
        punycode:         
          js:           
            0: 'punycode.js'
      scripts:       
        4:         
          CGridView#yw0: 'jQuery('#yw0').yiiGridView({'ajaxUpdate':['yw0'],'ajaxVar':'ajax','pagerClass':'pager','loadingClass':'grid\x2Dview\x2Dloading','filterClass':'filters','tableClass':'items','selectableRows':1,'enableHistory':false,'updateSelector':'\x7Bpage\x7D,\x20\x7Bsort\x7D','filterSelector':'\x7Bfilter\x7D','pageVar':'Invoiceline_page'});'
      *->cssFiles:       
        /assets/ae15994b/gridview/styles.css: ''
        /assets/5a7598eb/pager.css: ''
      *->scriptFiles:       
        2:         
          /assets/ae15994b/gridview/jquery.yiigridview.js: '/assets/ae15994b/gridview/jquery.yiigridview.js'
        0:         
          /assets/4a5acadb/jquery.js: '/assets/4a5acadb/jquery.js'
          /assets/4a5acadb/jquery.ba-bbq.js: '/assets/4a5acadb/jquery.ba-bbq.js'
      *->metaTags: { }
      *->linkTags: { }
      *->css: { }
      *->hasScripts: true
      *->coreScripts:       
        jquery:         
          js:           
            0: 'jquery.js'
          baseUrl: '/assets/4a5acadb'
        bbq:         
          js:           
            0: 'jquery.ba-bbq.js'
          depends:           
            0: 'jquery'
          baseUrl: '/assets/4a5acadb'
      coreScriptPosition: 0
      defaultScriptFilePosition: 0
      defaultScriptPosition: 4
      CClientScript->_baseUrl: '/assets/4a5acadb'
      behaviors: { }
      CApplicationComponent->_initialized: true
      CComponent->_e: null
      CComponent->_m: null
      CComponent->_behaviorsToAttach: { }
      CComponent->_isAttachingBehaviors: false
    )
    coreMessages: CPhpMessageSource ID:#84
      cachingDuration: 0
      cacheID: 'cache'
      basePath: '/home/www/sitessvn/yii/framework/messages'
      extensionPaths: { }
      CPhpMessageSource->_files: { }
      forceTranslation: false
      CMessageSource->_language: 'en_us'
      CMessageSource->_messages: { }
      behaviors: { }
      CApplicationComponent->_initialized: true
      CComponent->_e: null
      CComponent->_m: null
      CComponent->_behaviorsToAttach: { }
      CComponent->_isAttachingBehaviors: false
    )
    format: CFormatter ID:#85
      CFormatter->_htmlPurifier: null
      dateFormat: 'Y/m/d'
      timeFormat: 'h:i:s A'
      datetimeFormat: 'Y/m/d h:i:s A'
      numberFormat:       
        decimals: null
        decimalSeparator: null
        thousandSeparator: null
      booleanFormat:       
        0: 'No'
        1: 'Yes'
      htmlPurifierOptions: { }
      sizeFormat:       
        base: 1024
        decimals: 2
        decimalSeparator: null
      behaviors: { }
      CApplicationComponent->_initialized: true
      CComponent->_e: null
      CComponent->_m: null
      CComponent->_behaviorsToAttach: { }
      CComponent->_isAttachingBehaviors: false
    )
    session: CHttpSession ID:#86
      autoStart: true
      CHttpSession->_frozenData: null
      behaviors: { }
      CApplicationComponent->_initialized: true
      CComponent->_e: null
      CComponent->_m: null
      CComponent->_behaviorsToAttach: { }
      CComponent->_isAttachingBehaviors: false
    )
  CModule->_componentConfig:   
    coreMessages:     
      class: 'CPhpMessageSource'
      language: 'en_us'
      basePath: '/home/www/sitessvn/yii/framework/messages'
    db:     
      class: 'CDbConnection'
      connectionString: 'sqlite:protected/data/Chinook_Sqlite_AutoIncrementPKs.sqlite'
      tablePrefix: 'ae_g_'
    messages:     
      class: 'CPhpMessageSource'
    errorHandler:     
      class: 'CErrorHandler'
    securityManager:     
      class: 'CSecurityManager'
    statePersister:     
      class: 'CStatePersister'
    urlManager:     
      class: 'CUrlManager'
    request:     
      class: 'CHttpRequest'
    format:     
      class: 'CFormatter'
    session:     
      class: 'CHttpSession'
    assetManager:     
      class: 'CAssetManager'
    user:     
      class: 'CWebUser'
      allowAutoLogin: true
    themeManager:     
      class: 'CThemeManager'
    authManager:     
      class: 'CPhpAuthManager'
    clientScript:     
      class: 'CClientScript'
    widgetFactory:     
      class: 'CWidgetFactory'
    dbtestcasesqlite:     
      connectionString: 'sqlite:/home/www/sitessvn/yii/demos/relatedsearchbehavior/protected/config/../data/testdrive.db'
      tablePrefix: 'ae_g_'
    dbchinooksqlite: { }
    dbchinookmysql:     
      connectionString: 'mysql:host=localhost;dbname=chinook'
      username: 'root'
      tablePrefix: ''
    dbchinookpgsql:     
      connectionString: 'pgsql:host=localhost;port=5432;dbname=Chinook'
      username: 'postgres'
      tablePrefix: ''
    log:     
      class: 'CLogRouter'
      routes:       
        0:         
          class: 'CFileLogRoute'
          levels: 'error, warning, info, trace'
        xweb:         
          class: 'XWebDebugRouter'
          config: 'alignLeft, opaque, runInDebug, fixedPos, yamlStyle'
          levels: 'error, warning, trace, profile, info'
          allowedIPs:           
            0: '.*'
  CComponent->_e:   
    onendrequest: CList ID:#87
      CList->_d:       
        0:         
          0: CLogRouter#3(...)
          1: 'processLogs'
      CList->_c: 1
      CList->_r: false
      CComponent->_e: null
      CComponent->_m: null
      CComponent->_behaviorsToAttach: null
      CComponent->_isAttachingBehaviors: false
    )
  CComponent->_m: null
  CComponent->_behaviorsToAttach: null
  CComponent->_isAttachingBehaviors: false
  CModule->_id: null
  CModule->_basePath: null
)

Time	Level	Category	Message
07:43:33.911196	trace	system.db.CDbConnection	Opening DB connection in /home/www/sitessvn/yii/demos/relatedsearchbehavior/protected/views/site/index.php (11) in /home/www/sitessvn/yii/demos/relatedsearchbehavior/protected/controllers/SiteController.php (5) in /home/www/sitessvn/yii/demos/relatedsearchbehavior/index.php (13)
07:43:33.911452	trace	system.db.CDbCommand	Querying SQL: PRAGMA table_info('invoiceline') in /home/www/sitessvn/yii/demos/relatedsearchbehavior/protected/views/site/index.php (11) in /home/www/sitessvn/yii/demos/relatedsearchbehavior/protected/controllers/SiteController.php (5) in /home/www/sitessvn/yii/demos/relatedsearchbehavior/index.php (13)
07:43:33.912007	trace	system.db.CDbCommand	Querying SQL: PRAGMA foreign_key_list('invoiceline') in /home/www/sitessvn/yii/demos/relatedsearchbehavior/protected/views/site/index.php (11) in /home/www/sitessvn/yii/demos/relatedsearchbehavior/protected/controllers/SiteController.php (5) in /home/www/sitessvn/yii/demos/relatedsearchbehavior/index.php (13)
07:43:33.912537	trace	system.db.CDbCommand	Querying SQL: PRAGMA table_info('track') in /home/www/sitessvn/yii/demos/relatedsearchbehavior/protected/extensions/RelatedSearchBehavior.php (273) in /home/www/sitessvn/yii/demos/relatedsearchbehavior/protected/models/Invoiceline.php (150) in /home/www/sitessvn/yii/demos/relatedsearchbehavior/protected/models/Invoiceline.php (136)
07:43:33.912756	trace	system.db.CDbCommand	Querying SQL: PRAGMA foreign_key_list('track') in /home/www/sitessvn/yii/demos/relatedsearchbehavior/protected/extensions/RelatedSearchBehavior.php (273) in /home/www/sitessvn/yii/demos/relatedsearchbehavior/protected/models/Invoiceline.php (150) in /home/www/sitessvn/yii/demos/relatedsearchbehavior/protected/models/Invoiceline.php (136)
07:43:33.913584	trace	system.db.CDbCommand	Querying SQL: PRAGMA table_info('invoice') in /home/www/sitessvn/yii/demos/relatedsearchbehavior/protected/extensions/RelatedSearchBehavior.php (273) in /home/www/sitessvn/yii/demos/relatedsearchbehavior/protected/models/Invoiceline.php (150) in /home/www/sitessvn/yii/demos/relatedsearchbehavior/protected/models/Invoiceline.php (136)
07:43:33.913814	trace	system.db.CDbCommand	Querying SQL: PRAGMA foreign_key_list('invoice') in /home/www/sitessvn/yii/demos/relatedsearchbehavior/protected/extensions/RelatedSearchBehavior.php (273) in /home/www/sitessvn/yii/demos/relatedsearchbehavior/protected/models/Invoiceline.php (150) in /home/www/sitessvn/yii/demos/relatedsearchbehavior/protected/models/Invoiceline.php (136)
07:43:33.914691	trace	system.db.ar.CActiveRecord	Invoiceline.count() in /home/www/sitessvn/yii/demos/relatedsearchbehavior/protected/extensions/KeenActiveDataProvider.php (141) in /home/www/sitessvn/yii/demos/relatedsearchbehavior/protected/views/site/index.php (39) in /home/www/sitessvn/yii/demos/relatedsearchbehavior/protected/controllers/SiteController.php (5)
07:43:33.915003	trace	system.db.CDbCommand	Querying SQL: PRAGMA table_info('album') in /home/www/sitessvn/yii/demos/relatedsearchbehavior/protected/extensions/KeenActiveDataProvider.php (141) in /home/www/sitessvn/yii/demos/relatedsearchbehavior/protected/views/site/index.php (39) in /home/www/sitessvn/yii/demos/relatedsearchbehavior/protected/controllers/SiteController.php (5)
07:43:33.915163	trace	system.db.CDbCommand	Querying SQL: PRAGMA foreign_key_list('album') in /home/www/sitessvn/yii/demos/relatedsearchbehavior/protected/extensions/KeenActiveDataProvider.php (141) in /home/www/sitessvn/yii/demos/relatedsearchbehavior/protected/views/site/index.php (39) in /home/www/sitessvn/yii/demos/relatedsearchbehavior/protected/controllers/SiteController.php (5)
07:43:33.915405	trace	system.db.CDbCommand	Querying SQL: PRAGMA table_info('artist') in /home/www/sitessvn/yii/demos/relatedsearchbehavior/protected/extensions/KeenActiveDataProvider.php (141) in /home/www/sitessvn/yii/demos/relatedsearchbehavior/protected/views/site/index.php (39) in /home/www/sitessvn/yii/demos/relatedsearchbehavior/protected/controllers/SiteController.php (5)
07:43:33.915549	trace	system.db.CDbCommand	Querying SQL: PRAGMA foreign_key_list('artist') in /home/www/sitessvn/yii/demos/relatedsearchbehavior/protected/extensions/KeenActiveDataProvider.php (141) in /home/www/sitessvn/yii/demos/relatedsearchbehavior/protected/views/site/index.php (39) in /home/www/sitessvn/yii/demos/relatedsearchbehavior/protected/controllers/SiteController.php (5)
07:43:33.915626	trace	system.db.ar.CActiveRecord	Invoiceline.count() eagerly in /home/www/sitessvn/yii/demos/relatedsearchbehavior/protected/extensions/KeenActiveDataProvider.php (141) in /home/www/sitessvn/yii/demos/relatedsearchbehavior/protected/views/site/index.php (39) in /home/www/sitessvn/yii/demos/relatedsearchbehavior/protected/controllers/SiteController.php (5)
07:43:33.915798	trace	system.db.CDbCommand	Querying SQL: SELECT COUNT(*) FROM (SELECT 't'."InvoiceLineId" AS "t0_c0", 't'."InvoiceId" AS "t0_c1", 't'."TrackId" AS "t0_c2", 't'."UnitPrice" AS "t0_c3", 't'."Quantity" AS "t0_c4" FROM 'invoiceline' 't' LEFT OUTER JOIN 'track' 'track' ON ('track'."TrackId"='t'."TrackId") LEFT OUTER JOIN 'album' 'album' ON ('album'."AlbumId"='track'."AlbumId") LEFT OUTER JOIN 'artist' 'artist' ON ('artist'."ArtistId"='album'."ArtistId") GROUP BY 't'."InvoiceLineId") sq in /home/www/sitessvn/yii/demos/relatedsearchbehavior/protected/extensions/KeenActiveDataProvider.php (141) in /home/www/sitessvn/yii/demos/relatedsearchbehavior/protected/views/site/index.php (39) in /home/www/sitessvn/yii/demos/relatedsearchbehavior/protected/controllers/SiteController.php (5)
07:43:33.918548	trace	system.db.ar.CActiveRecord	Invoiceline.findAll() in /home/www/sitessvn/yii/demos/relatedsearchbehavior/protected/extensions/KeenActiveDataProvider.php (141) in /home/www/sitessvn/yii/demos/relatedsearchbehavior/protected/views/site/index.php (39) in /home/www/sitessvn/yii/demos/relatedsearchbehavior/protected/controllers/SiteController.php (5)
07:43:33.918896	trace	system.db.CDbCommand	Querying SQL: SELECT 't'."InvoiceLineId" AS "t0_c0", 't'."InvoiceId" AS "t0_c1", 't'."TrackId" AS "t0_c2", 't'."UnitPrice" AS "t0_c3", 't'."Quantity" AS "t0_c4" FROM 'invoiceline' 't' LEFT OUTER JOIN 'track' 'track' ON ('track'."TrackId"='t'."TrackId") LEFT OUTER JOIN 'album' 'album' ON ('album'."AlbumId"='track'."AlbumId") LEFT OUTER JOIN 'artist' 'artist' ON ('artist'."ArtistId"='album'."ArtistId") GROUP BY 't'."InvoiceLineId" ORDER BY 'album'."Title" LIMIT 4 in /home/www/sitessvn/yii/demos/relatedsearchbehavior/protected/extensions/KeenActiveDataProvider.php (141) in /home/www/sitessvn/yii/demos/relatedsearchbehavior/protected/views/site/index.php (39) in /home/www/sitessvn/yii/demos/relatedsearchbehavior/protected/controllers/SiteController.php (5)
07:43:33.922631	trace	system.db.ar.CActiveRecord	Invoiceline.findAllByAttributes() in /home/www/sitessvn/yii/demos/relatedsearchbehavior/protected/extensions/KeenActiveDataProvider.php (238) in /home/www/sitessvn/yii/demos/relatedsearchbehavior/protected/extensions/KeenActiveDataProvider.php (143) in /home/www/sitessvn/yii/demos/relatedsearchbehavior/protected/views/site/index.php (39)
07:43:33.922998	trace	system.db.CDbCommand	Querying SQL: PRAGMA table_info('mediatype') in /home/www/sitessvn/yii/demos/relatedsearchbehavior/protected/extensions/KeenActiveDataProvider.php (238) in /home/www/sitessvn/yii/demos/relatedsearchbehavior/protected/extensions/KeenActiveDataProvider.php (143) in /home/www/sitessvn/yii/demos/relatedsearchbehavior/protected/views/site/index.php (39)
07:43:33.923137	trace	system.db.CDbCommand	Querying SQL: PRAGMA foreign_key_list('mediatype') in /home/www/sitessvn/yii/demos/relatedsearchbehavior/protected/extensions/KeenActiveDataProvider.php (238) in /home/www/sitessvn/yii/demos/relatedsearchbehavior/protected/extensions/KeenActiveDataProvider.php (143) in /home/www/sitessvn/yii/demos/relatedsearchbehavior/protected/views/site/index.php (39)
07:43:33.923419	trace	system.db.CDbCommand	Querying SQL: PRAGMA table_info('customer') in /home/www/sitessvn/yii/demos/relatedsearchbehavior/protected/extensions/KeenActiveDataProvider.php (238) in /home/www/sitessvn/yii/demos/relatedsearchbehavior/protected/extensions/KeenActiveDataProvider.php (143) in /home/www/sitessvn/yii/demos/relatedsearchbehavior/protected/views/site/index.php (39)
07:43:33.923722	trace	system.db.CDbCommand	Querying SQL: PRAGMA foreign_key_list('customer') in /home/www/sitessvn/yii/demos/relatedsearchbehavior/protected/extensions/KeenActiveDataProvider.php (238) in /home/www/sitessvn/yii/demos/relatedsearchbehavior/protected/extensions/KeenActiveDataProvider.php (143) in /home/www/sitessvn/yii/demos/relatedsearchbehavior/protected/views/site/index.php (39)
07:43:33.923949	trace	system.db.CDbCommand	Querying SQL: PRAGMA table_info('employee') in /home/www/sitessvn/yii/demos/relatedsearchbehavior/protected/extensions/KeenActiveDataProvider.php (238) in /home/www/sitessvn/yii/demos/relatedsearchbehavior/protected/extensions/KeenActiveDataProvider.php (143) in /home/www/sitessvn/yii/demos/relatedsearchbehavior/protected/views/site/index.php (39)
07:43:33.924269	trace	system.db.CDbCommand	Querying SQL: PRAGMA foreign_key_list('employee') in /home/www/sitessvn/yii/demos/relatedsearchbehavior/protected/extensions/KeenActiveDataProvider.php (238) in /home/www/sitessvn/yii/demos/relatedsearchbehavior/protected/extensions/KeenActiveDataProvider.php (143) in /home/www/sitessvn/yii/demos/relatedsearchbehavior/protected/views/site/index.php (39)
07:43:33.924489	trace	system.db.CDbCommand	Querying SQL: PRAGMA table_info('genre') in /home/www/sitessvn/yii/demos/relatedsearchbehavior/protected/extensions/KeenActiveDataProvider.php (238) in /home/www/sitessvn/yii/demos/relatedsearchbehavior/protected/extensions/KeenActiveDataProvider.php (143) in /home/www/sitessvn/yii/demos/relatedsearchbehavior/protected/views/site/index.php (39)
07:43:33.924618	trace	system.db.CDbCommand	Querying SQL: PRAGMA foreign_key_list('genre') in /home/www/sitessvn/yii/demos/relatedsearchbehavior/protected/extensions/KeenActiveDataProvider.php (238) in /home/www/sitessvn/yii/demos/relatedsearchbehavior/protected/extensions/KeenActiveDataProvider.php (143) in /home/www/sitessvn/yii/demos/relatedsearchbehavior/protected/views/site/index.php (39)
07:43:33.925160	trace	system.db.CDbCommand	Querying SQL: SELECT 't'."InvoiceLineId" AS "t0_c0", 'track'."TrackId" AS "t1_c0", 'track'."Name" AS "t1_c1", 'track'."AlbumId" AS "t1_c2", 'track'."MediaTypeId" AS "t1_c3", 'track'."GenreId" AS "t1_c4", 'track'."Composer" AS "t1_c5", 'track'."Milliseconds" AS "t1_c6", 'track'."Bytes" AS "t1_c7", 'track'."UnitPrice" AS "t1_c8", 'album'."AlbumId" AS "t2_c0", 'album'."Title" AS "t2_c1", 'album'."ArtistId" AS "t2_c2", 'artist'."ArtistId" AS "t3_c0", 'artist'."Name" AS "t3_c1", 'mediatype'."MediaTypeId" AS "t4_c0", 'mediatype'."Name" AS "t4_c1", 'genre'."GenreId" AS "t8_c0", 'genre'."Name" AS "t8_c1", 'invoice'."InvoiceId" AS "t5_c0", 'invoice'."CustomerId" AS "t5_c1", 'invoice'."InvoiceDate" AS "t5_c2", 'invoice'."BillingAddress" AS "t5_c3", 'invoice'."BillingCity" AS "t5_c4", 'invoice'."BillingState" AS "t5_c5", 'invoice'."BillingCountry" AS "t5_c6", 'invoice'."BillingPostalCode" AS "t5_c7", 'invoice'."Total" AS "t5_c8", 'customer'."CustomerId" AS "t6_c0", 'customer'."FirstName" AS "t6_c1", 'customer'."LastName" AS "t6_c2", 'customer'."Company" AS "t6_c3", 'customer'."Address" AS "t6_c4", 'customer'."City" AS "t6_c5", 'customer'."State" AS "t6_c6", 'customer'."Country" AS "t6_c7", 'customer'."PostalCode" AS "t6_c8", 'customer'."Phone" AS "t6_c9", 'customer'."Fax" AS "t6_c10", 'customer'."Email" AS "t6_c11", 'customer'."SupportRepId" AS "t6_c12", 'support'."EmployeeId" AS "t7_c0", 'support'."LastName" AS "t7_c1", 'support'."FirstName" AS "t7_c2", 'support'."Title" AS "t7_c3", 'support'."ReportsTo" AS "t7_c4", 'support'."BirthDate" AS "t7_c5", 'support'."HireDate" AS "t7_c6", 'support'."Address" AS "t7_c7", 'support'."City" AS "t7_c8", 'support'."State" AS "t7_c9", 'support'."Country" AS "t7_c10", 'support'."PostalCode" AS "t7_c11", 'support'."Phone" AS "t7_c12", 'support'."Fax" AS "t7_c13", 'support'."Email" AS "t7_c14" FROM 'invoiceline' 't' LEFT OUTER JOIN 'track' 'track' ON ('track'."TrackId"='t'."TrackId") LEFT OUTER JOIN 'album' 'album' ON ('album'."AlbumId"='track'."AlbumId") LEFT OUTER JOIN 'artist' 'artist' ON ('artist'."ArtistId"='album'."ArtistId") LEFT OUTER JOIN 'mediatype' 'mediatype' ON ('mediatype'."MediaTypeId"='track'."MediaTypeId") LEFT OUTER JOIN 'genre' 'genre' ON ('genre'."GenreId"='track'."GenreId") LEFT OUTER JOIN 'invoice' 'invoice' ON ('invoice'."InvoiceId"='t'."InvoiceId") LEFT OUTER JOIN 'customer' 'customer' ON ('customer'."CustomerId"='invoice'."CustomerId") LEFT OUTER JOIN 'employee' 'support' ON ('support'."EmployeeId"='customer'."SupportRepId") WHERE ('t'."InvoiceLineId" IN (317, 890, 891, 1464)) in /home/www/sitessvn/yii/demos/relatedsearchbehavior/protected/extensions/KeenActiveDataProvider.php (238) in /home/www/sitessvn/yii/demos/relatedsearchbehavior/protected/extensions/KeenActiveDataProvider.php (143) in /home/www/sitessvn/yii/demos/relatedsearchbehavior/protected/views/site/index.php (39)

Time

Level

Time	Level	Category	Message
07:43:33.910370	trace	system.CModule	Loading "log" application component in /home/www/sitessvn/yii/demos/relatedsearchbehavior/index.php (13)
07:43:33.910595	trace	system.CModule	Loading "request" application component in /home/www/sitessvn/yii/demos/relatedsearchbehavior/index.php (13)
07:43:33.910660	trace	system.CModule	Loading "urlManager" application component in /home/www/sitessvn/yii/demos/relatedsearchbehavior/index.php (13)
07:43:33.911120	trace	system.CModule	Loading "db" application component in /home/www/sitessvn/yii/demos/relatedsearchbehavior/protected/views/site/index.php (11) in /home/www/sitessvn/yii/demos/relatedsearchbehavior/protected/controllers/SiteController.php (5) in /home/www/sitessvn/yii/demos/relatedsearchbehavior/index.php (13)
07:43:33.913184	trace	application	Extra With:array ( 'track' => array ( 'with' => array ( 'album' => array ( 'select' => array() ) ) 'select' => array() ) ) in /home/www/sitessvn/yii/demos/relatedsearchbehavior/protected/extensions/RelatedSearchBehavior.php (344) in /home/www/sitessvn/yii/demos/relatedsearchbehavior/protected/models/Invoiceline.php (150) in /home/www/sitessvn/yii/demos/relatedsearchbehavior/protected/models/Invoiceline.php (136)
07:43:33.914401	trace	system.CModule	Loading "widgetFactory" application component in /home/www/sitessvn/yii/demos/relatedsearchbehavior/protected/views/site/index.php (39) in /home/www/sitessvn/yii/demos/relatedsearchbehavior/protected/controllers/SiteController.php (5) in /home/www/sitessvn/yii/demos/relatedsearchbehavior/index.php (13)
07:43:33.926753	trace	system.CModule	Loading "assetManager" application component in /home/www/sitessvn/yii/demos/relatedsearchbehavior/protected/views/site/index.php (39) in /home/www/sitessvn/yii/demos/relatedsearchbehavior/protected/controllers/SiteController.php (5) in /home/www/sitessvn/yii/demos/relatedsearchbehavior/index.php (13)
07:43:33.926896	trace	system.CModule	Loading "clientScript" application component in /home/www/sitessvn/yii/demos/relatedsearchbehavior/protected/views/site/index.php (39) in /home/www/sitessvn/yii/demos/relatedsearchbehavior/protected/controllers/SiteController.php (5) in /home/www/sitessvn/yii/demos/relatedsearchbehavior/index.php (13)
07:43:33.927591	trace	system.CModule	Loading "coreMessages" application component in /home/www/sitessvn/yii/demos/relatedsearchbehavior/protected/views/site/index.php (39) in /home/www/sitessvn/yii/demos/relatedsearchbehavior/protected/controllers/SiteController.php (5) in /home/www/sitessvn/yii/demos/relatedsearchbehavior/index.php (13)
07:43:33.929924	trace	system.CModule	Loading "format" application component in /home/www/sitessvn/yii/demos/relatedsearchbehavior/protected/views/site/index.php (39) in /home/www/sitessvn/yii/demos/relatedsearchbehavior/protected/controllers/SiteController.php (5) in /home/www/sitessvn/yii/demos/relatedsearchbehavior/index.php (13)

+Globals

+Session

+Php

+Request

+Yii::app()

+Webdebugtoolbar