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

306	Camarão que Dorme e Onda Leva	Acyi Marques/Arlindo Bruz/Braço, Beto Sem/Zeca Pagodinho	0.99	Ao Vivo [IMPORT]	Zeca Pagodinho	MPEG audio file	Latin	Wichterlová	František	Park	Margaret	+1 (403) 263-4423	margaret@chinookcorp.com
306	Coração Em Desalinho	Mauro Diniz/Ratino Sigem	0.99	Ao Vivo [IMPORT]	Zeca Pagodinho	MPEG audio file	Latin	Wichterlová	František	Park	Margaret	+1 (403) 263-4423	margaret@chinookcorp.com
201	Faixa Amarela	Beto Gogo/Jessé Pai/Luiz Carlos/Zeca Pagodinho	0.99	Ao Vivo [IMPORT]	Zeca Pagodinho	MPEG audio file	Latin	Stevens	Victor	Johnson	Steve	1 (780) 836-9987	steve@chinookcorp.com
411	Feirinha da Pavuna/Luz do Repente/Bagaço da Laranja	Arlindo Cruz/Franco/Marquinhos PQD/Negro, Jovelina Pérolo/Zeca Pagodinho	0.99	Ao Vivo [IMPORT]	Zeca Pagodinho	MPEG audio file	Latin	Hämäläinen	Terhi	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: '/'
      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
23:25:46.928684	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)
23:25:46.928951	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)
23:25:46.929543	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)
23:25:46.930068	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)
23:25:46.930305	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)
23:25:46.931049	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)
23:25:46.931292	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)
23:25:46.932172	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)
23:25:46.932497	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)
23:25:46.932665	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)
23:25:46.932898	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)
23:25:46.933047	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)
23:25:46.933139	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)
23:25:46.933392	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", '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" 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)
23:25:46.937143	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)
23:25:46.937562	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", '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" 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 'artist'."Name" DESC,'track'."Name",'track'."UnitPrice" DESC 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)
23:25:46.942562	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)
23:25:46.942938	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)
23:25:46.943089	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)
23:25:46.943331	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)
23:25:46.943640	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)
23:25:46.943876	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)
23:25:46.944211	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)
23:25:46.944434	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)
23:25:46.944572	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)
23:25:46.945151	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 (1666, 1665, 1092, 2238)) 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
23:25:46.927822	trace	system.CModule	Loading "log" application component in /home/www/sitessvn/yii/demos/relatedsearchbehavior/index.php (13)
23:25:46.928061	trace	system.CModule	Loading "request" application component in /home/www/sitessvn/yii/demos/relatedsearchbehavior/index.php (13)
23:25:46.928134	trace	system.CModule	Loading "urlManager" application component in /home/www/sitessvn/yii/demos/relatedsearchbehavior/index.php (13)
23:25:46.928603	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)
23:25:46.931879	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)
23:25:46.946866	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)
23:25:46.947031	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)
23:25:46.947736	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)
23:25:46.950073	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