Поиск по id:

Test::find(1);

Результат запроса:

^ array:6 [▼
  "id" => "1"
  "title" => "title"
  "slug" => "slug"
  "text" => "text"
  "created_at" => "2022-02-23 14:36:06"
  "updated_at" => "2022-02-23 14:36:06"
]

Запрос по предопределенному полю:

Test::findBy('created_at', '2022-02-23 14:36:06');

Поиск по предопределенному полю:

Test::search('ti', 'title')

Результат запросов findBy и search:

^ array:1 [▼
  0 => array:6 [▼
    "id" => "1"
    "title" => "title"
    "slug" => "slug"
    "text" => "text"
    "created_at" => "2022-02-23 14:36:06"
    "updated_at" => "2022-02-23 14:36:06"
  ]
]

Получение всех записей из БД:

Test::getAll();

Результат запроса:

^ array:1 [▼
  0 => array:6 [▶]
]

Получить данные о структуре таблицы:

Test::getColumns();

Результат для "DSN"  mysql:

^ array:6 [▼
  0 => array:6 [▼
    "Field" => "id"
    "Type" => "int"
    "Null" => "NO"
    "Key" => "PRI"
    "Default" => null
    "Extra" => "auto_increment"
  ]
  1 => array:6 [▼
    "Field" => "title"
    "Type" => "varchar(255)"
    "Null" => "NO"
    "Key" => ""
    "Default" => null
    "Extra" => ""
  ]
  2 => array:6 [▼
    "Field" => "slug"
    "Type" => "varchar(255)"
    "Null" => "NO"
    "Key" => ""
    "Default" => null
    "Extra" => ""
  ]
  3 => array:6 [▼
    "Field" => "text"
    "Type" => "text"
    "Null" => "YES"
    "Key" => ""
    "Default" => null
    "Extra" => ""
  ]
  4 => array:6 [▼
    "Field" => "created_at"
    "Type" => "timestamp"
    "Null" => "NO"
    "Key" => ""
    "Default" => "CURRENT_TIMESTAMP"
    "Extra" => "DEFAULT_GENERATED"
  ]
  5 => array:6 [▼
    "Field" => "updated_at"
    "Type" => "timestamp"
    "Null" => "NO"
    "Key" => ""
    "Default" => "CURRENT_TIMESTAMP"
    "Extra" => "DEFAULT_GENERATED on update CURRENT_TIMESTAMP"
  ]
]

Получить только наименования полей:

Test::getFields();

Результат для "DSN"  mysql:

^ array:6 [▼
  0 => "id"
  1 => "title"
  2 => "slug"
  3 => "text"
  4 => "created_at"
  5 => "updated_at"
]