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
08:24:22.861866	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)
08:24:22.905180	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)
08:24:22.906438	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)
08:24:22.907442	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)
08:24:22.907813	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)
08:24:22.909275	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)
08:24:22.909672	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)
08:24:22.918114	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)
08:24:22.919051	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)
08:24:22.919348	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)
08:24:22.919761	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)
08:24:22.919997	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)
08:24:22.920144	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)
08:24:22.920605	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)
08:24:22.933051	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)
08:24:22.933985	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)
08:24:22.944606	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)
08:24:22.945491	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)
08:24:22.945750	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)
08:24:22.946249	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)
08:24:22.946784	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)
08:24:22.947236	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)
08:24:22.947818	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)
08:24:22.948245	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)
08:24:22.948470	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)
08:24:22.949570	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
08:24:22.829266	trace	system.CModule	Loading "log" application component in /home/www/sitessvn/yii/demos/relatedsearchbehavior/index.php (13)
08:24:22.845411	trace	system.CModule	Loading "request" application component in /home/www/sitessvn/yii/demos/relatedsearchbehavior/index.php (13)
08:24:22.845560	trace	system.CModule	Loading "urlManager" application component in /home/www/sitessvn/yii/demos/relatedsearchbehavior/index.php (13)
08:24:22.861695	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)
08:24:22.910865	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)
08:24:22.953275	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)
08:24:22.956085	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)
08:24:22.957469	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)
08:24:22.962538	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