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
06:42:36.419488	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)
06:42:36.419696	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)
06:42:36.420192	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)
06:42:36.420509	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)
06:42:36.420624	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)
06:42:36.420892	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)
06:42:36.421008	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)
06:42:36.421385	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)
06:42:36.421544	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)
06:42:36.421631	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)
06:42:36.421751	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)
06:42:36.421828	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)
06:42:36.421871	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)
06:42:36.421957	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)
06:42:36.425729	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)
06:42:36.425858	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)
06:42:36.430555	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)
06:42:36.430736	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)
06:42:36.430830	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)
06:42:36.430953	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)
06:42:36.431102	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)
06:42:36.431238	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)
06:42:36.431391	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)
06:42:36.431515	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)
06:42:36.431592	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)
06:42:36.431766	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
06:42:36.418908	trace	system.CModule	Loading "log" application component in /home/www/sitessvn/yii/demos/relatedsearchbehavior/index.php (13)
06:42:36.419056	trace	system.CModule	Loading "request" application component in /home/www/sitessvn/yii/demos/relatedsearchbehavior/index.php (13)
06:42:36.419097	trace	system.CModule	Loading "urlManager" application component in /home/www/sitessvn/yii/demos/relatedsearchbehavior/index.php (13)
06:42:36.419439	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)
06:42:36.421247	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)
06:42:36.432569	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)
06:42:36.432666	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)
06:42:36.432948	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)
06:42:36.433773	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