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/9119edfe'
        /home/www/sitessvn/yii/framework/web/widgets/pagers/pager.css: '/assets/918d2236/pager.css'
        /home/www/sitessvn/yii/framework/web/js/source: '/assets/72069362'
      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/9119edfe/gridview/styles.css: ''
        /assets/918d2236/pager.css: ''
      *->scriptFiles:       
        2:         
          /assets/9119edfe/gridview/jquery.yiigridview.js: '/assets/9119edfe/gridview/jquery.yiigridview.js'
        0:         
          /assets/72069362/jquery.js: '/assets/72069362/jquery.js'
          /assets/72069362/jquery.ba-bbq.js: '/assets/72069362/jquery.ba-bbq.js'
      *->metaTags: { }
      *->linkTags: { }
      *->css: { }
      *->hasScripts: true
      *->coreScripts:       
        jquery:         
          js:           
            0: 'jquery.js'
          baseUrl: '/assets/72069362'
        bbq:         
          js:           
            0: 'jquery.ba-bbq.js'
          depends:           
            0: 'jquery'
          baseUrl: '/assets/72069362'
      coreScriptPosition: 0
      defaultScriptFilePosition: 0
      defaultScriptPosition: 4
      CClientScript->_baseUrl: '/assets/72069362'
      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
      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'
      errorAction: 'site/error'
    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
14:59:46.807943	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)
14:59:46.810600	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)
14:59:46.811532	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)
14:59:46.815099	trace	system.db.CDbCommand	Querying SQL: PRAGMA table_info('track') in /home/www/sitessvn/yii/demos/relatedsearchbehavior/protected/extensions/RelatedSearchBehavior.php (258) in /home/www/sitessvn/yii/demos/relatedsearchbehavior/protected/models/Invoiceline.php (150) in /home/www/sitessvn/yii/demos/relatedsearchbehavior/protected/models/Invoiceline.php (141)
14:59:46.815485	trace	system.db.CDbCommand	Querying SQL: PRAGMA foreign_key_list('track') in /home/www/sitessvn/yii/demos/relatedsearchbehavior/protected/extensions/RelatedSearchBehavior.php (258) in /home/www/sitessvn/yii/demos/relatedsearchbehavior/protected/models/Invoiceline.php (150) in /home/www/sitessvn/yii/demos/relatedsearchbehavior/protected/models/Invoiceline.php (141)
14:59:46.817111	trace	system.db.CDbCommand	Querying SQL: PRAGMA table_info('invoice') in /home/www/sitessvn/yii/demos/relatedsearchbehavior/protected/extensions/RelatedSearchBehavior.php (258) in /home/www/sitessvn/yii/demos/relatedsearchbehavior/protected/models/Invoiceline.php (150) in /home/www/sitessvn/yii/demos/relatedsearchbehavior/protected/models/Invoiceline.php (141)
14:59:46.817512	trace	system.db.CDbCommand	Querying SQL: PRAGMA foreign_key_list('invoice') in /home/www/sitessvn/yii/demos/relatedsearchbehavior/protected/extensions/RelatedSearchBehavior.php (258) in /home/www/sitessvn/yii/demos/relatedsearchbehavior/protected/models/Invoiceline.php (150) in /home/www/sitessvn/yii/demos/relatedsearchbehavior/protected/models/Invoiceline.php (141)
14:59:46.820569	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 (61) in /home/www/sitessvn/yii/demos/relatedsearchbehavior/protected/controllers/SiteController.php (5)
14:59:46.824676	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 (61) in /home/www/sitessvn/yii/demos/relatedsearchbehavior/protected/controllers/SiteController.php (5)
14:59:46.824944	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 (61) in /home/www/sitessvn/yii/demos/relatedsearchbehavior/protected/controllers/SiteController.php (5)
14:59:46.825608	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 (61) in /home/www/sitessvn/yii/demos/relatedsearchbehavior/protected/controllers/SiteController.php (5)
14:59:46.825967	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 (61) in /home/www/sitessvn/yii/demos/relatedsearchbehavior/protected/controllers/SiteController.php (5)
14:59:46.826188	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 (61) in /home/www/sitessvn/yii/demos/relatedsearchbehavior/protected/controllers/SiteController.php (5)
14:59:46.826673	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 (61) in /home/www/sitessvn/yii/demos/relatedsearchbehavior/protected/controllers/SiteController.php (5)
14:59:46.835314	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 (61) in /home/www/sitessvn/yii/demos/relatedsearchbehavior/protected/controllers/SiteController.php (5)
14:59:46.836219	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 (61) in /home/www/sitessvn/yii/demos/relatedsearchbehavior/protected/controllers/SiteController.php (5)
14:59:46.846534	trace	system.db.ar.CActiveRecord	Invoiceline.findAllByAttributes() in /home/www/sitessvn/yii/demos/relatedsearchbehavior/protected/extensions/KeenActiveDataProvider.php (239) in /home/www/sitessvn/yii/demos/relatedsearchbehavior/protected/extensions/KeenActiveDataProvider.php (143) in /home/www/sitessvn/yii/demos/relatedsearchbehavior/protected/views/site/index.php (61)
14:59:46.847448	trace	system.db.CDbCommand	Querying SQL: PRAGMA table_info('mediatype') in /home/www/sitessvn/yii/demos/relatedsearchbehavior/protected/extensions/KeenActiveDataProvider.php (239) in /home/www/sitessvn/yii/demos/relatedsearchbehavior/protected/extensions/KeenActiveDataProvider.php (143) in /home/www/sitessvn/yii/demos/relatedsearchbehavior/protected/views/site/index.php (61)
14:59:46.847685	trace	system.db.CDbCommand	Querying SQL: PRAGMA foreign_key_list('mediatype') in /home/www/sitessvn/yii/demos/relatedsearchbehavior/protected/extensions/KeenActiveDataProvider.php (239) in /home/www/sitessvn/yii/demos/relatedsearchbehavior/protected/extensions/KeenActiveDataProvider.php (143) in /home/www/sitessvn/yii/demos/relatedsearchbehavior/protected/views/site/index.php (61)
14:59:46.848315	trace	system.db.CDbCommand	Querying SQL: PRAGMA table_info('customer') in /home/www/sitessvn/yii/demos/relatedsearchbehavior/protected/extensions/KeenActiveDataProvider.php (239) in /home/www/sitessvn/yii/demos/relatedsearchbehavior/protected/extensions/KeenActiveDataProvider.php (143) in /home/www/sitessvn/yii/demos/relatedsearchbehavior/protected/views/site/index.php (61)
14:59:46.848851	trace	system.db.CDbCommand	Querying SQL: PRAGMA foreign_key_list('customer') in /home/www/sitessvn/yii/demos/relatedsearchbehavior/protected/extensions/KeenActiveDataProvider.php (239) in /home/www/sitessvn/yii/demos/relatedsearchbehavior/protected/extensions/KeenActiveDataProvider.php (143) in /home/www/sitessvn/yii/demos/relatedsearchbehavior/protected/views/site/index.php (61)
14:59:46.849437	trace	system.db.CDbCommand	Querying SQL: PRAGMA table_info('employee') in /home/www/sitessvn/yii/demos/relatedsearchbehavior/protected/extensions/KeenActiveDataProvider.php (239) in /home/www/sitessvn/yii/demos/relatedsearchbehavior/protected/extensions/KeenActiveDataProvider.php (143) in /home/www/sitessvn/yii/demos/relatedsearchbehavior/protected/views/site/index.php (61)
14:59:46.850023	trace	system.db.CDbCommand	Querying SQL: PRAGMA foreign_key_list('employee') in /home/www/sitessvn/yii/demos/relatedsearchbehavior/protected/extensions/KeenActiveDataProvider.php (239) in /home/www/sitessvn/yii/demos/relatedsearchbehavior/protected/extensions/KeenActiveDataProvider.php (143) in /home/www/sitessvn/yii/demos/relatedsearchbehavior/protected/views/site/index.php (61)
14:59:46.850532	trace	system.db.CDbCommand	Querying SQL: PRAGMA table_info('genre') in /home/www/sitessvn/yii/demos/relatedsearchbehavior/protected/extensions/KeenActiveDataProvider.php (239) in /home/www/sitessvn/yii/demos/relatedsearchbehavior/protected/extensions/KeenActiveDataProvider.php (143) in /home/www/sitessvn/yii/demos/relatedsearchbehavior/protected/views/site/index.php (61)
14:59:46.850763	trace	system.db.CDbCommand	Querying SQL: PRAGMA foreign_key_list('genre') in /home/www/sitessvn/yii/demos/relatedsearchbehavior/protected/extensions/KeenActiveDataProvider.php (239) in /home/www/sitessvn/yii/demos/relatedsearchbehavior/protected/extensions/KeenActiveDataProvider.php (143) in /home/www/sitessvn/yii/demos/relatedsearchbehavior/protected/views/site/index.php (61)
14:59:46.851855	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 (239) in /home/www/sitessvn/yii/demos/relatedsearchbehavior/protected/extensions/KeenActiveDataProvider.php (143) in /home/www/sitessvn/yii/demos/relatedsearchbehavior/protected/views/site/index.php (61)

Time

Level

Time	Level	Category	Message
14:59:46.796458	trace	system.CModule	Loading "log" application component in /home/www/sitessvn/yii/demos/relatedsearchbehavior/index.php (13)
14:59:46.798091	trace	system.CModule	Loading "request" application component in /home/www/sitessvn/yii/demos/relatedsearchbehavior/index.php (13)
14:59:46.799505	trace	system.CModule	Loading "urlManager" application component in /home/www/sitessvn/yii/demos/relatedsearchbehavior/index.php (13)
14:59:46.807261	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)
14:59:46.818900	trace	system.CModule	Loading "widgetFactory" application component in /home/www/sitessvn/yii/demos/relatedsearchbehavior/protected/views/site/index.php (61) in /home/www/sitessvn/yii/demos/relatedsearchbehavior/protected/controllers/SiteController.php (5) in /home/www/sitessvn/yii/demos/relatedsearchbehavior/index.php (13)
14:59:46.855525	trace	system.CModule	Loading "assetManager" application component in /home/www/sitessvn/yii/demos/relatedsearchbehavior/protected/views/site/index.php (61) in /home/www/sitessvn/yii/demos/relatedsearchbehavior/protected/controllers/SiteController.php (5) in /home/www/sitessvn/yii/demos/relatedsearchbehavior/index.php (13)
14:59:46.856053	trace	system.CModule	Loading "clientScript" application component in /home/www/sitessvn/yii/demos/relatedsearchbehavior/protected/views/site/index.php (61) in /home/www/sitessvn/yii/demos/relatedsearchbehavior/protected/controllers/SiteController.php (5) in /home/www/sitessvn/yii/demos/relatedsearchbehavior/index.php (13)
14:59:46.858944	trace	system.CModule	Loading "coreMessages" application component in /home/www/sitessvn/yii/demos/relatedsearchbehavior/protected/views/site/index.php (61) in /home/www/sitessvn/yii/demos/relatedsearchbehavior/protected/controllers/SiteController.php (5) in /home/www/sitessvn/yii/demos/relatedsearchbehavior/index.php (13)
14:59:46.866167	trace	system.CModule	Loading "format" application component in /home/www/sitessvn/yii/demos/relatedsearchbehavior/protected/views/site/index.php (61) 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