Slow View and What to Do?!

DBCreator · March 1, 2021, 3:08pm

I have a view which loads very slowly, relatively to other pages.

I have confirmed that the controller action itself happens relatively fast, but the rendering of the view itself is slower than I’d like (5-7 second). This view use Kartik’s Gridview and utilizes a lot of related attribute values

‘value’=>‘employee.FullName’,

or Functions

and the filters map full related tables.

So a lot of data, and I get that.

I was just wondering what I could possibly do to try and optimize thing.

Instead of using

‘value’=>‘employee.FullName’,

could I directly integrate it in the Search model so it doesn’t need to do this lookup for each records at runtime?

I’m open to any ideas.

samdark · March 1, 2021, 6:43pm

What’s the SQL generated and executed? How many queries?

DBCreator · March 1, 2021, 7:04pm

Not sure what to post here to answer that question. The Model Search, individual dropdowns, log file, …? If you can explain a little more what you need, I’ll do my best to post it for you to review.

MetaCrawler · March 2, 2021, 7:12am

Hi,

Do you have the Debug Toolbar enabled?
https://www.yiiframework.com/extension/yiisoft/yii2-debug/doc/guide/2.1/en/installation

There you can see how many DB Queries are executed and how long they need to complete… and you could copy these queries, so that we can see them and make suggestions how to improve them.

Regards

DBCreator · March 2, 2021, 11:51am

Here’s a copy of the log that is generated by the view
06:45:46.508 trace yii\base\Application::bootstrap Bootstrap with slightlydiff\xero\Bootstrap::bootstrap()
06:45:46.508 trace yii\base\Application::bootstrap Bootstrap with yii\log\Dispatcher
06:45:46.508 trace yii\base\Module::getModule Loading module: debug
06:45:46.608 info yii\web\Session::open Session started
06:45:46.698 info yii\db\Command::query SELECT * FROM user WHERE (id=1) AND (status=10)

Z:\M\Websites\www.testing.com\vendor\mdmsoft\yii2-admin\models\User.php:67

06:45:46.698 info yii\db\Connection::open Opening DB connection: mysql:host=localhost;dbname=testing

Z:\M\Websites\www.testing.com\vendor\mdmsoft\yii2-admin\models\User.php:67

06:45:46.718 trace yii\base\Application::bootstrap Bootstrap with yii\debug\Module::bootstrap()
06:45:46.728 trace yii\base\Module::getModule Loading module: gii
06:45:46.748 trace yii\base\Application::bootstrap Bootstrap with yii\gii\Module::bootstrap()
06:45:46.748 trace yii\web\Application::handleRequest Route requested: ‘projects/index’
06:45:46.768 trace yii\base\Controller::runAction Route to run: projects/index
06:45:46.778 trace yii\base\InlineAction::runWithParams Running action: backend\controllers\ProjectsController::actionIndex()
06:45:46.778 info yii\db\Command::execute DELETE FROM projects_locks WHERE dtModification < ‘2021-03-02 00:45:46’

Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:1045
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:76

06:45:46.878 info yii\db\Command::query SELECT * FROM user_settings WHERE (UserId=1) AND (SettingName=‘projectIndexHiddenColumns’)

Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:87

06:45:46.888 trace yii\base\View::renderFile Rendering view file: Z:\M\Websites\www.testing.com\backend\views\projects\index.php

Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:47.148 trace yii\base\Module::getModule Loading module: gridview

Z:\M\Websites\www.testing.com\vendor\kartik-v\yii2-krajee-base\src\Config.php:305
Z:\M\Websites\www.testing.com\vendor\kartik-v\yii2-grid\src\GridView.php:1437
Z:\M\Websites\www.testing.com\vendor\kartik-v\yii2-grid\src\GridView.php:1060

06:45:47.458 trace yii\base\View::renderFile Rendering view file: Z:\M\Websites\www.testing.com/vendor/kartik-v/yii2-export/src/views/_columns.php

Z:\M\Websites\www.testing.com\vendor\kartik-v\yii2-export\src\ExportMenu.php:1078
Z:\M\Websites\www.testing.com\vendor\kartik-v\yii2-export\src\ExportMenu.php:1048
Z:\M\Websites\www.testing.com\vendor\kartik-v\yii2-export\src\ExportMenu.php:754

06:45:47.548 info yii\db\Command::query SELECT * FROM lst_projects_statuses ORDER BY Status

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:576
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:47.568 info yii\db\Command::query SELECT EmpId, FirstName, LastName FROM employees ORDER BY FirstName, LastName

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:745
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:47.578 info yii\db\Command::query SELECT * FROM lst_projects_legs_servtypes ORDER BY ServTypeId

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:785
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:47.588 info yii\db\Command::query SELECT id, FirstName, LastName FROM user ORDER BY FirstName, LastName

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:811
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:47.588 info yii\db\Command::query SELECT id, FirstName, LastName FROM user ORDER BY FirstName, LastName

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:853
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:47.648 info yii\db\Command::query SELECT COUNT(*) FROM projects LEFT JOIN lst_projects_statuses ON projects.StatusId = lst_projects_statuses.StatusId LEFT JOIN clients ON projects.ClientId = clients.ClientId LEFT JOIN user ON projects.DispatcherId = user.id LEFT JOIN projects_legs ON projects.ProjId=projects_legs.ProjId WHERE (projects.StartDt BETWEEN ‘2020-12-02’ AND ‘2021-03-02’) OR (projects.StatusId NOT IN (1, 6))

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:47.648 info yii\db\Command::query SELECT projects.ProjId, projects.ProjNo, projects.StatusId, projects.StatusIdJustificationId, projects.Invoiced, projects.XeroInvoiceId, projects.StartDt, projects.ClientId, projects.CompTripNo, projects.TruckNo FROM projects LEFT JOIN lst_projects_statuses ON projects.StatusId = lst_projects_statuses.StatusId LEFT JOIN clients ON projects.ClientId = clients.ClientId LEFT JOIN user ON projects.DispatcherId = user.id LEFT JOIN projects_legs ON projects.ProjId=projects_legs.ProjId WHERE (projects.StartDt BETWEEN ‘2020-12-02’ AND ‘2021-03-02’) OR (projects.StatusId NOT IN (1, 6)) ORDER BY projects.ProjNo DESC LIMIT 100

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:47.658 info yii\db\Command::query SELECT * FROM lst_projects_statuses WHERE StatusId IN (6, 5, 4)

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:47.668 info yii\db\Command::query SELECT * FROM clients WHERE ClientId IN (174, 6, 2, 1, 57, 389, 509, 140, 529, 99, 11, 157, 154, 4, 500, 390, 132, 150, 528, 120, 165, 129, 334, 438, 3, 161, 147, 203, 125, 100, 160, 14)

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:47.688 info yii\db\Command::query SELECT * FROM auth_assignment WHERE user_id=‘1’

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:442
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:47.688 info yii\db\Command::query SELECT * FROM auth_item WHERE name=‘Finance’

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:442
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:47.688 trace yii\rbac\DbManager::checkAccessRecursive Checking role: Finance

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:442
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:47.698 info yii\db\Command::query SELECT COUNT(*) FROM projects_locks WHERE ProjId=51781

Z:\M\Websites\www.testing.com\backend\models\Projects.php:379
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:479
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082

06:45:47.698 info yii\db\Command::query SELECT COUNT(*) FROM projects_locks WHERE ProjId=51781

Z:\M\Websites\www.testing.com\backend\models\Projects.php:379
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:481
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082

06:45:47.698 info yii\db\Command::query SELECT COUNT(*) FROM projects_locks WHERE ProjId=51781

Z:\M\Websites\www.testing.com\backend\models\Projects.php:379
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:494
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082

06:45:47.698 info yii\db\Command::query SELECT * FROM projects_legs WHERE ProjId=51781 ORDER BY LegNo, StartDt

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:664
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:47.708 info yii\db\Command::query SELECT * FROM lst_projects_legs_servtypes WHERE ServTypeId=44

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:765
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:47.718 info yii\db\Command::query SELECT * FROM user WHERE id=1

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:831
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:48.508 info yii\db\Command::query SELECT COUNT(*) FROM projects_locks WHERE ProjId=51780

Z:\M\Websites\www.testing.com\backend\models\Projects.php:379
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:479
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082

06:45:48.508 info yii\db\Command::query SELECT COUNT(*) FROM projects_locks WHERE ProjId=51780

Z:\M\Websites\www.testing.com\backend\models\Projects.php:379
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:481
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082

06:45:48.508 info yii\db\Command::query SELECT COUNT(*) FROM projects_locks WHERE ProjId=51780

Z:\M\Websites\www.testing.com\backend\models\Projects.php:379
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:494
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082

06:45:48.508 info yii\db\Command::query SELECT * FROM projects_legs WHERE ProjId=51780 ORDER BY LegNo, StartDt

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:664
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:48.528 info yii\db\Command::query SELECT * FROM employees WHERE EmpId=2

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:723
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:48.528 info yii\db\Command::query SELECT * FROM lst_projects_legs_servtypes WHERE ServTypeId=5

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:765
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:48.528 info yii\db\Command::query SELECT * FROM user WHERE id=49

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:831
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:48.568 info yii\db\Command::query SELECT COUNT(*) FROM projects_locks WHERE ProjId=51779

Z:\M\Websites\www.testing.com\backend\models\Projects.php:379
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:479
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082

06:45:48.568 info yii\db\Command::query SELECT COUNT(*) FROM projects_locks WHERE ProjId=51779

Z:\M\Websites\www.testing.com\backend\models\Projects.php:379
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:481
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082

06:45:48.568 info yii\db\Command::query SELECT COUNT(*) FROM projects_locks WHERE ProjId=51779

Z:\M\Websites\www.testing.com\backend\models\Projects.php:379
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:494
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082

06:45:48.568 info yii\db\Command::query SELECT * FROM projects_legs WHERE ProjId=51779 ORDER BY LegNo, StartDt

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:664
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:48.598 info yii\db\Command::query SELECT COUNT(*) FROM projects_locks WHERE ProjId=51778

Z:\M\Websites\www.testing.com\backend\models\Projects.php:379
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:479
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082

06:45:48.608 info yii\db\Command::query SELECT COUNT(*) FROM projects_locks WHERE ProjId=51778

Z:\M\Websites\www.testing.com\backend\models\Projects.php:379
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:481
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082

06:45:48.608 info yii\db\Command::query SELECT COUNT(*) FROM projects_locks WHERE ProjId=51778

Z:\M\Websites\www.testing.com\backend\models\Projects.php:379
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:494
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082

06:45:48.608 info yii\db\Command::query SELECT * FROM projects_legs WHERE ProjId=51778 ORDER BY LegNo, StartDt

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:664
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:48.638 info yii\db\Command::query SELECT COUNT(*) FROM projects_locks WHERE ProjId=51777

Z:\M\Websites\www.testing.com\backend\models\Projects.php:379
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:479
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082

06:45:48.638 info yii\db\Command::query SELECT COUNT(*) FROM projects_locks WHERE ProjId=51777

Z:\M\Websites\www.testing.com\backend\models\Projects.php:379
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:481
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082

06:45:48.638 info yii\db\Command::query SELECT COUNT(*) FROM projects_locks WHERE ProjId=51777

Z:\M\Websites\www.testing.com\backend\models\Projects.php:379
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:494
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082

06:45:48.638 info yii\db\Command::query SELECT * FROM projects_legs WHERE ProjId=51777 ORDER BY LegNo, StartDt

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:664
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:48.638 info yii\db\Command::query SELECT * FROM lst_projects_legs_servtypes WHERE ServTypeId=4

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:765
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:48.638 info yii\db\Command::query SELECT * FROM user WHERE id=1

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:831
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:48.678 info yii\db\Command::query SELECT COUNT(*) FROM projects_locks WHERE ProjId=51776

Z:\M\Websites\www.testing.com\backend\models\Projects.php:379
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:479
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082

06:45:48.678 info yii\db\Command::query SELECT COUNT(*) FROM projects_locks WHERE ProjId=51776

Z:\M\Websites\www.testing.com\backend\models\Projects.php:379
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:481
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082

06:45:48.678 info yii\db\Command::query SELECT COUNT(*) FROM projects_locks WHERE ProjId=51776

Z:\M\Websites\www.testing.com\backend\models\Projects.php:379
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:494
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082

06:45:48.678 info yii\db\Command::query SELECT * FROM projects_legs WHERE ProjId=51776 ORDER BY LegNo, StartDt

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:664
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:48.678 info yii\db\Command::query SELECT * FROM lst_projects_legs_servtypes WHERE ServTypeId=44

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:765
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:48.678 info yii\db\Command::query SELECT * FROM user WHERE id=1

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:831
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:48.718 info yii\db\Command::query SELECT COUNT(*) FROM projects_locks WHERE ProjId=51774

Z:\M\Websites\www.testing.com\backend\models\Projects.php:379
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:479
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082

06:45:48.718 info yii\db\Command::query SELECT COUNT(*) FROM projects_locks WHERE ProjId=51774

Z:\M\Websites\www.testing.com\backend\models\Projects.php:379
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:481
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082

06:45:48.718 info yii\db\Command::query SELECT COUNT(*) FROM projects_locks WHERE ProjId=51774

Z:\M\Websites\www.testing.com\backend\models\Projects.php:379
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:494
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082

06:45:48.718 info yii\db\Command::query SELECT * FROM projects_legs WHERE ProjId=51774 ORDER BY LegNo, StartDt

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:664
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:48.718 info yii\db\Command::query SELECT * FROM employees WHERE EmpId=1968

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:723
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:48.718 info yii\db\Command::query SELECT * FROM lst_projects_legs_servtypes WHERE ServTypeId=4

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:765
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:48.718 info yii\db\Command::query SELECT * FROM user WHERE id=45

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:831
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:48.758 info yii\db\Command::query SELECT COUNT(*) FROM projects_locks WHERE ProjId=51773

Z:\M\Websites\www.testing.com\backend\models\Projects.php:379
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:479
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082

06:45:48.758 info yii\db\Command::query SELECT COUNT(*) FROM projects_locks WHERE ProjId=51773

Z:\M\Websites\www.testing.com\backend\models\Projects.php:379
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:481
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082

06:45:48.758 info yii\db\Command::query SELECT COUNT(*) FROM projects_locks WHERE ProjId=51773

Z:\M\Websites\www.testing.com\backend\models\Projects.php:379
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:494
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082

06:45:48.758 info yii\db\Command::query SELECT * FROM projects_legs WHERE ProjId=51773 ORDER BY LegNo, StartDt

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:664
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:48.758 info yii\db\Command::query SELECT * FROM employees WHERE EmpId=1322

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:723
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:48.758 info yii\db\Command::query SELECT * FROM lst_projects_legs_servtypes WHERE ServTypeId=5

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:765
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:48.758 info yii\db\Command::query SELECT * FROM user WHERE id=49

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:831
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:48.798 info yii\db\Command::query SELECT COUNT(*) FROM projects_locks WHERE ProjId=51772

Z:\M\Websites\www.testing.com\backend\models\Projects.php:379
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:479
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082

06:45:48.798 info yii\db\Command::query SELECT COUNT(*) FROM projects_locks WHERE ProjId=51772

Z:\M\Websites\www.testing.com\backend\models\Projects.php:379
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:481
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082

06:45:48.798 info yii\db\Command::query SELECT COUNT(*) FROM projects_locks WHERE ProjId=51772

Z:\M\Websites\www.testing.com\backend\models\Projects.php:379
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:494
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082

06:45:48.798 info yii\db\Command::query SELECT * FROM projects_legs WHERE ProjId=51772 ORDER BY LegNo, StartDt

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:664
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:48.798 info yii\db\Command::query SELECT * FROM employees WHERE EmpId=16

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:723
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:48.798 info yii\db\Command::query SELECT * FROM lst_projects_legs_servtypes WHERE ServTypeId=5

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:765
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:48.798 info yii\db\Command::query SELECT * FROM user WHERE id=49

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:831
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:48.838 info yii\db\Command::query SELECT COUNT(*) FROM projects_locks WHERE ProjId=51771

Z:\M\Websites\www.testing.com\backend\models\Projects.php:379
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:479
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082

06:45:48.838 info yii\db\Command::query SELECT COUNT(*) FROM projects_locks WHERE ProjId=51771

Z:\M\Websites\www.testing.com\backend\models\Projects.php:379
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:481
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082

06:45:48.838 info yii\db\Command::query SELECT COUNT(*) FROM projects_locks WHERE ProjId=51771

Z:\M\Websites\www.testing.com\backend\models\Projects.php:379
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:494
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082

06:45:48.838 info yii\db\Command::query SELECT * FROM projects_legs WHERE ProjId=51771 ORDER BY LegNo, StartDt

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:664
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:48.838 info yii\db\Command::query SELECT * FROM employees WHERE EmpId=1951

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:723
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:48.838 info yii\db\Command::query SELECT * FROM lst_projects_legs_servtypes WHERE ServTypeId=5

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:765
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:48.848 info yii\db\Command::query SELECT * FROM user WHERE id=45

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:831
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:48.888 info yii\db\Command::query SELECT COUNT(*) FROM projects_locks WHERE ProjId=51770

Z:\M\Websites\www.testing.com\backend\models\Projects.php:379
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:479
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082

06:45:48.888 info yii\db\Command::query SELECT COUNT(*) FROM projects_locks WHERE ProjId=51770

Z:\M\Websites\www.testing.com\backend\models\Projects.php:379
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:481
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082

06:45:48.888 info yii\db\Command::query SELECT COUNT(*) FROM projects_locks WHERE ProjId=51770

Z:\M\Websites\www.testing.com\backend\models\Projects.php:379
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:494
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082

06:45:48.888 info yii\db\Command::query SELECT * FROM projects_legs WHERE ProjId=51770 ORDER BY LegNo, StartDt

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:664
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:48.888 info yii\db\Command::query SELECT * FROM employees WHERE EmpId=1569

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:723
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

DBCreator · March 2, 2021, 11:52am

cont’d

06:45:48.888 info yii\db\Command::query SELECT * FROM lst_projects_legs_servtypes WHERE ServTypeId=34

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:765
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:48.888 info yii\db\Command::query SELECT * FROM user WHERE id=49

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:831
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:48.928 info yii\db\Command::query SELECT COUNT(*) FROM projects_locks WHERE ProjId=51769

Z:\M\Websites\www.testing.com\backend\models\Projects.php:379
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:479
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082

06:45:48.928 info yii\db\Command::query SELECT COUNT(*) FROM projects_locks WHERE ProjId=51769

Z:\M\Websites\www.testing.com\backend\models\Projects.php:379
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:481
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082

06:45:48.928 info yii\db\Command::query SELECT COUNT(*) FROM projects_locks WHERE ProjId=51769

Z:\M\Websites\www.testing.com\backend\models\Projects.php:379
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:494
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082

06:45:48.928 info yii\db\Command::query SELECT * FROM projects_legs WHERE ProjId=51769 ORDER BY LegNo, StartDt

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:664
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:48.928 info yii\db\Command::query SELECT * FROM employees WHERE EmpId=1511

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:723
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:48.928 info yii\db\Command::query SELECT * FROM lst_projects_legs_servtypes WHERE ServTypeId=3

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:765
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:48.928 info yii\db\Command::query SELECT * FROM user WHERE id=44

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:831
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:48.968 info yii\db\Command::query SELECT COUNT(*) FROM projects_locks WHERE ProjId=51768

Z:\M\Websites\www.testing.com\backend\models\Projects.php:379
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:479
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082

06:45:48.978 info yii\db\Command::query SELECT COUNT(*) FROM projects_locks WHERE ProjId=51768

Z:\M\Websites\www.testing.com\backend\models\Projects.php:379
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:481
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082

06:45:48.978 info yii\db\Command::query SELECT COUNT(*) FROM projects_locks WHERE ProjId=51768

Z:\M\Websites\www.testing.com\backend\models\Projects.php:379
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:494
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082

06:45:48.978 info yii\db\Command::query SELECT * FROM projects_legs WHERE ProjId=51768 ORDER BY LegNo, StartDt

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:664
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:48.978 info yii\db\Command::query SELECT * FROM lst_projects_legs_servtypes WHERE ServTypeId=5

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:765
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:48.978 info yii\db\Command::query SELECT * FROM user WHERE id=45

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:831
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:49.018 info yii\db\Command::query SELECT COUNT(*) FROM projects_locks WHERE ProjId=51767

Z:\M\Websites\www.testing.com\backend\models\Projects.php:379
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:479
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082

06:45:49.018 info yii\db\Command::query SELECT COUNT(*) FROM projects_locks WHERE ProjId=51767

Z:\M\Websites\www.testing.com\backend\models\Projects.php:379
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:481
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082

06:45:49.018 info yii\db\Command::query SELECT COUNT(*) FROM projects_locks WHERE ProjId=51767

Z:\M\Websites\www.testing.com\backend\models\Projects.php:379
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:494
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082

06:45:49.018 info yii\db\Command::query SELECT * FROM projects_legs WHERE ProjId=51767 ORDER BY LegNo, StartDt

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:664
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:49.018 info yii\db\Command::query SELECT * FROM employees WHERE EmpId=831

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:723
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:49.018 info yii\db\Command::query SELECT * FROM lst_projects_legs_servtypes WHERE ServTypeId=5

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:765
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:49.018 info yii\db\Command::query SELECT * FROM user WHERE id=45

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:831
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:49.058 info yii\db\Command::query SELECT COUNT(*) FROM projects_locks WHERE ProjId=51766

Z:\M\Websites\www.testing.com\backend\models\Projects.php:379
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:479
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082

06:45:49.058 info yii\db\Command::query SELECT COUNT(*) FROM projects_locks WHERE ProjId=51766

Z:\M\Websites\www.testing.com\backend\models\Projects.php:379
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:481
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082

06:45:49.068 info yii\db\Command::query SELECT COUNT(*) FROM projects_locks WHERE ProjId=51766

Z:\M\Websites\www.testing.com\backend\models\Projects.php:379
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:494
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082

06:45:49.068 info yii\db\Command::query SELECT * FROM projects_legs WHERE ProjId=51766 ORDER BY LegNo, StartDt

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:664
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:49.068 info yii\db\Command::query SELECT * FROM lst_projects_legs_servtypes WHERE ServTypeId=5

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:765
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:49.068 info yii\db\Command::query SELECT * FROM user WHERE id=45

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:831
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:49.078 info yii\db\Command::query SELECT COUNT(*) FROM projects_locks WHERE ProjId=51765

Z:\M\Websites\www.testing.com\backend\models\Projects.php:379
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:479
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082

06:45:49.078 info yii\db\Command::query SELECT COUNT(*) FROM projects_locks WHERE ProjId=51765

Z:\M\Websites\www.testing.com\backend\models\Projects.php:379
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:481
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082

06:45:49.078 info yii\db\Command::query SELECT COUNT(*) FROM projects_locks WHERE ProjId=51765

Z:\M\Websites\www.testing.com\backend\models\Projects.php:379
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:494
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082

06:45:49.078 info yii\db\Command::query SELECT * FROM projects_legs WHERE ProjId=51765 ORDER BY LegNo, StartDt

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:664
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:49.078 info yii\db\Command::query SELECT * FROM employees WHERE EmpId=824

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:723
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:49.078 info yii\db\Command::query SELECT * FROM lst_projects_legs_servtypes WHERE ServTypeId=5

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:765
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:49.078 info yii\db\Command::query SELECT * FROM lst_projects_legs_servtypes WHERE ServTypeId=43

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:765
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:49.078 info yii\db\Command::query SELECT * FROM user WHERE id=49

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:831
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:49.078 info yii\db\Command::query SELECT * FROM user WHERE id=1

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:831
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:49.148 info yii\db\Command::query SELECT COUNT(*) FROM projects_locks WHERE ProjId=51764

Z:\M\Websites\www.testing.com\backend\models\Projects.php:379
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:479
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082

06:45:49.158 info yii\db\Command::query SELECT COUNT(*) FROM projects_locks WHERE ProjId=51764

Z:\M\Websites\www.testing.com\backend\models\Projects.php:379
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:481
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082

06:45:49.158 info yii\db\Command::query SELECT COUNT(*) FROM projects_locks WHERE ProjId=51764

Z:\M\Websites\www.testing.com\backend\models\Projects.php:379
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:494
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082

06:45:49.158 info yii\db\Command::query SELECT * FROM projects_legs WHERE ProjId=51764 ORDER BY LegNo, StartDt

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:664
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:49.158 info yii\db\Command::query SELECT * FROM employees WHERE EmpId=1422

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:723
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:49.158 info yii\db\Command::query SELECT * FROM lst_projects_legs_servtypes WHERE ServTypeId=5

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:765
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:49.158 info yii\db\Command::query SELECT * FROM user WHERE id=49

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:831
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:49.198 info yii\db\Command::query SELECT COUNT(*) FROM projects_locks WHERE ProjId=51763

Z:\M\Websites\www.testing.com\backend\models\Projects.php:379
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:479
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082

06:45:49.198 info yii\db\Command::query SELECT COUNT(*) FROM projects_locks WHERE ProjId=51763

Z:\M\Websites\www.testing.com\backend\models\Projects.php:379
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:481
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082

06:45:49.198 info yii\db\Command::query SELECT COUNT(*) FROM projects_locks WHERE ProjId=51763

Z:\M\Websites\www.testing.com\backend\models\Projects.php:379
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:494
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082

06:45:49.198 info yii\db\Command::query SELECT * FROM projects_legs WHERE ProjId=51763 ORDER BY LegNo, StartDt

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:664
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:49.198 info yii\db\Command::query SELECT * FROM employees WHERE EmpId=1865

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:723
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:49.198 info yii\db\Command::query SELECT * FROM lst_projects_legs_servtypes WHERE ServTypeId=5

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:765
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:49.198 info yii\db\Command::query SELECT * FROM user WHERE id=49

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:831
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:49.238 info yii\db\Command::query SELECT COUNT(*) FROM projects_locks WHERE ProjId=51762

Z:\M\Websites\www.testing.com\backend\models\Projects.php:379
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:479
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082

06:45:49.238 info yii\db\Command::query SELECT COUNT(*) FROM projects_locks WHERE ProjId=51762

Z:\M\Websites\www.testing.com\backend\models\Projects.php:379
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:481
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082

06:45:49.238 info yii\db\Command::query SELECT COUNT(*) FROM projects_locks WHERE ProjId=51762

Z:\M\Websites\www.testing.com\backend\models\Projects.php:379
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:494
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082

06:45:49.238 info yii\db\Command::query SELECT * FROM projects_legs WHERE ProjId=51762 ORDER BY LegNo, StartDt

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:664
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:49.238 info yii\db\Command::query SELECT * FROM employees WHERE EmpId=186

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:723
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:49.238 info yii\db\Command::query SELECT * FROM lst_projects_legs_servtypes WHERE ServTypeId=5

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:765
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:49.238 info yii\db\Command::query SELECT * FROM user WHERE id=49

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:831
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:49.278 info yii\db\Command::query SELECT COUNT(*) FROM projects_locks WHERE ProjId=51760

Z:\M\Websites\www.testing.com\backend\models\Projects.php:379
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:479
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082

06:45:49.278 info yii\db\Command::query SELECT COUNT(*) FROM projects_locks WHERE ProjId=51760

Z:\M\Websites\www.testing.com\backend\models\Projects.php:379
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:481
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082

06:45:49.278 info yii\db\Command::query SELECT COUNT(*) FROM projects_locks WHERE ProjId=51760

Z:\M\Websites\www.testing.com\backend\models\Projects.php:379
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:494
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082

06:45:49.278 info yii\db\Command::query SELECT * FROM projects_legs WHERE ProjId=51760 ORDER BY LegNo, StartDt

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:664
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:49.278 info yii\db\Command::query SELECT * FROM employees WHERE EmpId=1554

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:723
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:49.278 info yii\db\Command::query SELECT * FROM lst_projects_legs_servtypes WHERE ServTypeId=5

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:765
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:49.278 info yii\db\Command::query SELECT * FROM user WHERE id=45

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:831
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:49.308 info yii\db\Command::query SELECT COUNT(*) FROM projects_locks WHERE ProjId=51759

Z:\M\Websites\www.testing.com\backend\models\Projects.php:379
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:479
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082

06:45:49.318 info yii\db\Command::query SELECT COUNT(*) FROM projects_locks WHERE ProjId=51759

Z:\M\Websites\www.testing.com\backend\models\Projects.php:379
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:481
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082

06:45:49.318 info yii\db\Command::query SELECT COUNT(*) FROM projects_locks WHERE ProjId=51759

Z:\M\Websites\www.testing.com\backend\models\Projects.php:379
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:494
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082

06:45:49.318 info yii\db\Command::query SELECT * FROM projects_legs WHERE ProjId=51759 ORDER BY LegNo, StartDt

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:664
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:49.318 info yii\db\Command::query SELECT * FROM employees WHERE EmpId=1554

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:723
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:49.318 info yii\db\Command::query SELECT * FROM lst_projects_legs_servtypes WHERE ServTypeId=5

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:765
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:49.318 info yii\db\Command::query SELECT * FROM user WHERE id=45

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:831
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:49.348 info yii\db\Command::query SELECT COUNT(*) FROM projects_locks WHERE ProjId=51758

Z:\M\Websites\www.testing.com\backend\models\Projects.php:379
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:479
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082

06:45:49.348 info yii\db\Command::query SELECT COUNT(*) FROM projects_locks WHERE ProjId=51758

Z:\M\Websites\www.testing.com\backend\models\Projects.php:379
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:481
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082

06:45:49.348 info yii\db\Command::query SELECT COUNT(*) FROM projects_locks WHERE ProjId=51758

Z:\M\Websites\www.testing.com\backend\models\Projects.php:379
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:494
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082

06:45:49.348 info yii\db\Command::query SELECT * FROM projects_legs WHERE ProjId=51758 ORDER BY LegNo, StartDt

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:664
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:49.358 info yii\db\Command::query SELECT * FROM employees WHERE EmpId=1361

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:723
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:49.358 info yii\db\Command::query SELECT * FROM employees WHERE EmpId=52

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:723
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:49.358 info yii\db\Command::query SELECT * FROM lst_projects_legs_servtypes WHERE ServTypeId=4

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:765
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:49.358 info yii\db\Command::query SELECT * FROM lst_projects_legs_servtypes WHERE ServTypeId=5

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:765
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:49.358 info yii\db\Command::query SELECT * FROM user WHERE id=42

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:831
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:49.358 info yii\db\Command::query SELECT * FROM user WHERE id=42

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:831
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:49.388 info yii\db\Command::query SELECT COUNT(*) FROM projects_locks WHERE ProjId=51757

Z:\M\Websites\www.testing.com\backend\models\Projects.php:379
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:479
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082

DBCreator · March 2, 2021, 11:53am

Cont’d

06:45:49.398 info yii\db\Command::query SELECT COUNT(*) FROM projects_locks WHERE ProjId=51757

Z:\M\Websites\www.testing.com\backend\models\Projects.php:379
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:481
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082

06:45:49.398 info yii\db\Command::query SELECT COUNT(*) FROM projects_locks WHERE ProjId=51757

Z:\M\Websites\www.testing.com\backend\models\Projects.php:379
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:494
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082

06:45:49.398 info yii\db\Command::query SELECT * FROM projects_legs WHERE ProjId=51757 ORDER BY LegNo, StartDt

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:664
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:49.398 info yii\db\Command::query SELECT * FROM employees WHERE EmpId=1283

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:723
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:49.398 info yii\db\Command::query SELECT * FROM employees WHERE EmpId=80

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:723
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:49.398 info yii\db\Command::query SELECT * FROM lst_projects_legs_servtypes WHERE ServTypeId=4

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:765
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:49.398 info yii\db\Command::query SELECT * FROM lst_projects_legs_servtypes WHERE ServTypeId=5

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:765
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:49.398 info yii\db\Command::query SELECT * FROM user WHERE id=42

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:831
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:49.398 info yii\db\Command::query SELECT * FROM user WHERE id=42

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:831
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:49.428 info yii\db\Command::query SELECT COUNT(*) FROM projects_locks WHERE ProjId=51756

Z:\M\Websites\www.testing.com\backend\models\Projects.php:379
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:479
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082

06:45:49.438 info yii\db\Command::query SELECT COUNT(*) FROM projects_locks WHERE ProjId=51756

Z:\M\Websites\www.testing.com\backend\models\Projects.php:379
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:481
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082

06:45:49.438 info yii\db\Command::query SELECT COUNT(*) FROM projects_locks WHERE ProjId=51756

Z:\M\Websites\www.testing.com\backend\models\Projects.php:379
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:494
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082

06:45:49.438 info yii\db\Command::query SELECT * FROM projects_legs WHERE ProjId=51756 ORDER BY LegNo, StartDt

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:664
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:49.438 info yii\db\Command::query SELECT * FROM employees WHERE EmpId=242

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:723
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:49.438 info yii\db\Command::query SELECT * FROM employees WHERE EmpId=1095

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:723
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:49.438 info yii\db\Command::query SELECT * FROM lst_projects_legs_servtypes WHERE ServTypeId=5

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:765
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:49.438 info yii\db\Command::query SELECT * FROM lst_projects_legs_servtypes WHERE ServTypeId=4

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:765
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:49.438 info yii\db\Command::query SELECT * FROM user WHERE id=42

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:831
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:49.438 info yii\db\Command::query SELECT * FROM user WHERE id=42

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:831
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:49.468 info yii\db\Command::query SELECT COUNT(*) FROM projects_locks WHERE ProjId=51755

Z:\M\Websites\www.testing.com\backend\models\Projects.php:379
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:479
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082

06:45:49.478 info yii\db\Command::query SELECT COUNT(*) FROM projects_locks WHERE ProjId=51755

Z:\M\Websites\www.testing.com\backend\models\Projects.php:379
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:481
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082

06:45:49.478 info yii\db\Command::query SELECT COUNT(*) FROM projects_locks WHERE ProjId=51755

Z:\M\Websites\www.testing.com\backend\models\Projects.php:379
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:494
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082

06:45:49.478 info yii\db\Command::query SELECT * FROM projects_legs WHERE ProjId=51755 ORDER BY LegNo, StartDt

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:664
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:49.478 info yii\db\Command::query SELECT * FROM lst_projects_legs_servtypes WHERE ServTypeId=4

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:765
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:49.478 info yii\db\Command::query SELECT * FROM lst_projects_legs_servtypes WHERE ServTypeId=5

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:765
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:49.478 info yii\db\Command::query SELECT * FROM user WHERE id=49

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:831
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:49.478 info yii\db\Command::query SELECT * FROM user WHERE id=49

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:831
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:49.508 info yii\db\Command::query SELECT COUNT(*) FROM projects_locks WHERE ProjId=51754

Z:\M\Websites\www.testing.com\backend\models\Projects.php:379
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:479
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082

06:45:49.518 info yii\db\Command::query SELECT COUNT(*) FROM projects_locks WHERE ProjId=51754

Z:\M\Websites\www.testing.com\backend\models\Projects.php:379
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:481
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082

06:45:49.518 info yii\db\Command::query SELECT COUNT(*) FROM projects_locks WHERE ProjId=51754

Z:\M\Websites\www.testing.com\backend\models\Projects.php:379
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:494
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082

06:45:49.518 info yii\db\Command::query SELECT * FROM projects_legs WHERE ProjId=51754 ORDER BY LegNo, StartDt

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:664
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:49.518 info yii\db\Command::query SELECT * FROM employees WHERE EmpId=16

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:723
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:49.518 info yii\db\Command::query SELECT * FROM lst_projects_legs_servtypes WHERE ServTypeId=5

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:765
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:49.518 info yii\db\Command::query SELECT * FROM user WHERE id=44

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:831
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:49.548 info yii\db\Command::query SELECT COUNT(*) FROM projects_locks WHERE ProjId=51753

Z:\M\Websites\www.testing.com\backend\models\Projects.php:379
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:479
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082

06:45:49.548 info yii\db\Command::query SELECT COUNT(*) FROM projects_locks WHERE ProjId=51753

Z:\M\Websites\www.testing.com\backend\models\Projects.php:379
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:481
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082

06:45:49.558 info yii\db\Command::query SELECT COUNT(*) FROM projects_locks WHERE ProjId=51753

Z:\M\Websites\www.testing.com\backend\models\Projects.php:379
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:494
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082

06:45:49.558 info yii\db\Command::query SELECT * FROM projects_legs WHERE ProjId=51753 ORDER BY LegNo, StartDt

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:664
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:49.558 info yii\db\Command::query SELECT * FROM lst_projects_legs_servtypes WHERE ServTypeId=5

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:765
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:49.558 info yii\db\Command::query SELECT * FROM user WHERE id=44

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:831
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:49.588 info yii\db\Command::query SELECT COUNT(*) FROM projects_locks WHERE ProjId=51752

Z:\M\Websites\www.testing.com\backend\models\Projects.php:379
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:479
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082

06:45:49.588 info yii\db\Command::query SELECT COUNT(*) FROM projects_locks WHERE ProjId=51752

Z:\M\Websites\www.testing.com\backend\models\Projects.php:379
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:481
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082

06:45:49.588 info yii\db\Command::query SELECT COUNT(*) FROM projects_locks WHERE ProjId=51752

Z:\M\Websites\www.testing.com\backend\models\Projects.php:379
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:494
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082

06:45:49.588 info yii\db\Command::query SELECT * FROM projects_legs WHERE ProjId=51752 ORDER BY LegNo, StartDt

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:664
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:49.588 info yii\db\Command::query SELECT * FROM employees WHERE EmpId=515

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:723
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:49.588 info yii\db\Command::query SELECT * FROM lst_projects_legs_servtypes WHERE ServTypeId=5

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:765
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:49.588 info yii\db\Command::query SELECT * FROM lst_projects_legs_servtypes WHERE ServTypeId=4

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:765
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:49.598 info yii\db\Command::query SELECT * FROM user WHERE id=42

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:831
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:49.598 info yii\db\Command::query SELECT * FROM user WHERE id=44

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:831
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:49.628 info yii\db\Command::query SELECT COUNT(*) FROM projects_locks WHERE ProjId=51751

Z:\M\Websites\www.testing.com\backend\models\Projects.php:379
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:479
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082

06:45:49.628 info yii\db\Command::query SELECT COUNT(*) FROM projects_locks WHERE ProjId=51751

Z:\M\Websites\www.testing.com\backend\models\Projects.php:379
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:481
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082

06:45:49.628 info yii\db\Command::query SELECT COUNT(*) FROM projects_locks WHERE ProjId=51751

Z:\M\Websites\www.testing.com\backend\models\Projects.php:379
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:494
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082

06:45:49.628 info yii\db\Command::query SELECT * FROM projects_legs WHERE ProjId=51751 ORDER BY LegNo, StartDt

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:664
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:49.628 info yii\db\Command::query SELECT * FROM employees WHERE EmpId=1763

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:723
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:49.628 info yii\db\Command::query SELECT * FROM employees WHERE EmpId=824

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:723
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:49.628 info yii\db\Command::query SELECT * FROM lst_projects_legs_servtypes WHERE ServTypeId=5

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:765
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:49.628 info yii\db\Command::query SELECT * FROM lst_projects_legs_servtypes WHERE ServTypeId=4

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:765
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:49.628 info yii\db\Command::query SELECT * FROM user WHERE id=45

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:831
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:49.638 info yii\db\Command::query SELECT * FROM user WHERE id=45

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:831
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:49.668 info yii\db\Command::query SELECT COUNT(*) FROM projects_locks WHERE ProjId=51750

Z:\M\Websites\www.testing.com\backend\models\Projects.php:379
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:479
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082

06:45:49.668 info yii\db\Command::query SELECT COUNT(*) FROM projects_locks WHERE ProjId=51750

Z:\M\Websites\www.testing.com\backend\models\Projects.php:379
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:481
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082

06:45:49.668 info yii\db\Command::query SELECT COUNT(*) FROM projects_locks WHERE ProjId=51750

Z:\M\Websites\www.testing.com\backend\models\Projects.php:379
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:494
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082

06:45:49.668 info yii\db\Command::query SELECT * FROM projects_legs WHERE ProjId=51750 ORDER BY LegNo, StartDt

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:664
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:49.668 info yii\db\Command::query SELECT * FROM employees WHERE EmpId=824

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:723
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:49.668 info yii\db\Command::query SELECT * FROM lst_projects_legs_servtypes WHERE ServTypeId=5

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:765
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:49.668 info yii\db\Command::query SELECT * FROM user WHERE id=42

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:831
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:49.708 info yii\db\Command::query SELECT COUNT(*) FROM projects_locks WHERE ProjId=51749

Z:\M\Websites\www.testing.com\backend\models\Projects.php:379
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:479
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082

06:45:49.708 info yii\db\Command::query SELECT COUNT(*) FROM projects_locks WHERE ProjId=51749

Z:\M\Websites\www.testing.com\backend\models\Projects.php:379
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:481
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082

06:45:49.708 info yii\db\Command::query SELECT COUNT(*) FROM projects_locks WHERE ProjId=51749

Z:\M\Websites\www.testing.com\backend\models\Projects.php:379
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:494
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082

06:45:49.708 info yii\db\Command::query SELECT * FROM projects_legs WHERE ProjId=51749 ORDER BY LegNo, StartDt

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:664
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:49.708 info yii\db\Command::query SELECT * FROM lst_projects_legs_servtypes WHERE ServTypeId=45

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:765
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:49.708 info yii\db\Command::query SELECT * FROM lst_projects_legs_servtypes WHERE ServTypeId=45

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:765
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:49.708 info yii\db\Command::query SELECT * FROM user WHERE id=44

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:831
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:49.708 info yii\db\Command::query SELECT * FROM user WHERE id=44

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:831
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:49.738 info yii\db\Command::query SELECT COUNT(*) FROM projects_locks WHERE ProjId=51748

Z:\M\Websites\www.testing.com\backend\models\Projects.php:379
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:479
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082

06:45:49.748 info yii\db\Command::query SELECT COUNT(*) FROM projects_locks WHERE ProjId=51748

Z:\M\Websites\www.testing.com\backend\models\Projects.php:379
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:481
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082

06:45:49.748 info yii\db\Command::query SELECT COUNT(*) FROM projects_locks WHERE ProjId=51748

Z:\M\Websites\www.testing.com\backend\models\Projects.php:379
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:494
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082

06:45:49.748 info yii\db\Command::query SELECT * FROM projects_legs WHERE ProjId=51748 ORDER BY LegNo, StartDt

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:664
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:49.748 info yii\db\Command::query SELECT * FROM employees WHERE EmpId=1996

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:723
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:49.748 info yii\db\Command::query SELECT * FROM lst_projects_legs_servtypes WHERE ServTypeId=5

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:765
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:49.748 info yii\db\Command::query SELECT * FROM user WHERE id=42

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:831
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:49.778 info yii\db\Command::query SELECT COUNT(*) FROM projects_locks WHERE ProjId=51747

Z:\M\Websites\www.testing.com\backend\models\Projects.php:379
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:479
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082

06:45:49.778 info yii\db\Command::query SELECT COUNT(*) FROM projects_locks WHERE ProjId=51747

Z:\M\Websites\www.testing.com\backend\models\Projects.php:379
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:481
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082

DBCreator · March 2, 2021, 11:53am

Cont’d

06:45:49.788 info yii\db\Command::query SELECT COUNT(*) FROM projects_locks WHERE ProjId=51747

Z:\M\Websites\www.testing.com\backend\models\Projects.php:379
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:494
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082

06:45:49.788 info yii\db\Command::query SELECT * FROM projects_legs WHERE ProjId=51747 ORDER BY LegNo, StartDt

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:664
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:49.788 info yii\db\Command::query SELECT * FROM employees WHERE EmpId=1569

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:723
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:49.788 info yii\db\Command::query SELECT * FROM lst_projects_legs_servtypes WHERE ServTypeId=5

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:765
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:49.788 info yii\db\Command::query SELECT * FROM lst_projects_legs_servtypes WHERE ServTypeId=5

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:765
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:49.788 info yii\db\Command::query SELECT * FROM user WHERE id=44

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:831
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:49.788 info yii\db\Command::query SELECT * FROM user WHERE id=44

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:831
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:49.818 info yii\db\Command::query SELECT COUNT(*) FROM projects_locks WHERE ProjId=51746

Z:\M\Websites\www.testing.com\backend\models\Projects.php:379
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:479
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082

06:45:49.818 info yii\db\Command::query SELECT COUNT(*) FROM projects_locks WHERE ProjId=51746

Z:\M\Websites\www.testing.com\backend\models\Projects.php:379
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:481
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082

06:45:49.818 info yii\db\Command::query SELECT COUNT(*) FROM projects_locks WHERE ProjId=51746

Z:\M\Websites\www.testing.com\backend\models\Projects.php:379
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:494
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082

06:45:49.818 info yii\db\Command::query SELECT * FROM projects_legs WHERE ProjId=51746 ORDER BY LegNo, StartDt

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:664
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:49.828 info yii\db\Command::query SELECT * FROM employees WHERE EmpId=333

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:723
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:49.828 info yii\db\Command::query SELECT * FROM employees WHERE EmpId=333

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:723
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:49.828 info yii\db\Command::query SELECT * FROM lst_projects_legs_servtypes WHERE ServTypeId=6

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:765
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:49.828 info yii\db\Command::query SELECT * FROM lst_projects_legs_servtypes WHERE ServTypeId=4

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:765
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:49.828 info yii\db\Command::query SELECT * FROM user WHERE id=49

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:831
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:49.828 info yii\db\Command::query SELECT * FROM user WHERE id=49

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:831
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:49.858 info yii\db\Command::query SELECT COUNT(*) FROM projects_locks WHERE ProjId=51745

Z:\M\Websites\www.testing.com\backend\models\Projects.php:379
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:479
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082

06:45:49.868 info yii\db\Command::query SELECT COUNT(*) FROM projects_locks WHERE ProjId=51745

Z:\M\Websites\www.testing.com\backend\models\Projects.php:379
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:481
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082

06:45:49.868 info yii\db\Command::query SELECT COUNT(*) FROM projects_locks WHERE ProjId=51745

Z:\M\Websites\www.testing.com\backend\models\Projects.php:379
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:494
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082

06:45:49.868 info yii\db\Command::query SELECT * FROM projects_legs WHERE ProjId=51745 ORDER BY LegNo, StartDt

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:664
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:49.868 info yii\db\Command::query SELECT * FROM employees WHERE EmpId=1985

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:723
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:49.868 info yii\db\Command::query SELECT * FROM lst_projects_legs_servtypes WHERE ServTypeId=5

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:765
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:49.868 info yii\db\Command::query SELECT * FROM user WHERE id=49

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:831
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:49.898 info yii\db\Command::query SELECT COUNT(*) FROM projects_locks WHERE ProjId=51742

Z:\M\Websites\www.testing.com\backend\models\Projects.php:379
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:479
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082

06:45:49.898 info yii\db\Command::query SELECT COUNT(*) FROM projects_locks WHERE ProjId=51742

Z:\M\Websites\www.testing.com\backend\models\Projects.php:379
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:481
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082

06:45:49.898 info yii\db\Command::query SELECT COUNT(*) FROM projects_locks WHERE ProjId=51742

Z:\M\Websites\www.testing.com\backend\models\Projects.php:379
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:494
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082

06:45:49.898 info yii\db\Command::query SELECT * FROM projects_legs WHERE ProjId=51742 ORDER BY LegNo, StartDt

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:664
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:49.908 info yii\db\Command::query SELECT * FROM employees WHERE EmpId=242

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:723
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:49.908 info yii\db\Command::query SELECT * FROM lst_projects_legs_servtypes WHERE ServTypeId=5

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:765
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:49.908 info yii\db\Command::query SELECT * FROM user WHERE id=44

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:831
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:49.938 info yii\db\Command::query SELECT COUNT(*) FROM projects_locks WHERE ProjId=51741

Z:\M\Websites\www.testing.com\backend\models\Projects.php:379
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:479
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082

06:45:49.938 info yii\db\Command::query SELECT COUNT(*) FROM projects_locks WHERE ProjId=51741

Z:\M\Websites\www.testing.com\backend\models\Projects.php:379
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:481
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082

06:45:49.938 info yii\db\Command::query SELECT COUNT(*) FROM projects_locks WHERE ProjId=51741

Z:\M\Websites\www.testing.com\backend\models\Projects.php:379
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:494
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082

06:45:49.938 info yii\db\Command::query SELECT * FROM projects_legs WHERE ProjId=51741 ORDER BY LegNo, StartDt

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:664
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:49.938 info yii\db\Command::query SELECT * FROM employees WHERE EmpId=16

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:723
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:49.938 info yii\db\Command::query SELECT * FROM lst_projects_legs_servtypes WHERE ServTypeId=5

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:765
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:49.938 info yii\db\Command::query SELECT * FROM user WHERE id=42

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:831
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:49.978 info yii\db\Command::query SELECT COUNT(*) FROM projects_locks WHERE ProjId=51740

Z:\M\Websites\www.testing.com\backend\models\Projects.php:379
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:479
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082

06:45:49.978 info yii\db\Command::query SELECT COUNT(*) FROM projects_locks WHERE ProjId=51740

Z:\M\Websites\www.testing.com\backend\models\Projects.php:379
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:481
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082

06:45:49.978 info yii\db\Command::query SELECT COUNT(*) FROM projects_locks WHERE ProjId=51740

Z:\M\Websites\www.testing.com\backend\models\Projects.php:379
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:494
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082

06:45:49.978 info yii\db\Command::query SELECT * FROM projects_legs WHERE ProjId=51740 ORDER BY LegNo, StartDt

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:664
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:49.978 info yii\db\Command::query SELECT * FROM employees WHERE EmpId=1880

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:723
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:49.978 info yii\db\Command::query SELECT * FROM lst_projects_legs_servtypes WHERE ServTypeId=5

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:765
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:49.978 info yii\db\Command::query SELECT * FROM user WHERE id=49

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:831
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:50.018 info yii\db\Command::query SELECT COUNT(*) FROM projects_locks WHERE ProjId=51739

Z:\M\Websites\www.testing.com\backend\models\Projects.php:379
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:479
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082

06:45:50.018 info yii\db\Command::query SELECT COUNT(*) FROM projects_locks WHERE ProjId=51739

Z:\M\Websites\www.testing.com\backend\models\Projects.php:379
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:481
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082

06:45:50.018 info yii\db\Command::query SELECT COUNT(*) FROM projects_locks WHERE ProjId=51739

Z:\M\Websites\www.testing.com\backend\models\Projects.php:379
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:494
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082

06:45:50.018 info yii\db\Command::query SELECT * FROM projects_legs WHERE ProjId=51739 ORDER BY LegNo, StartDt

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:664
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:50.018 info yii\db\Command::query SELECT * FROM lst_projects_legs_servtypes WHERE ServTypeId=6

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:765
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:50.018 info yii\db\Command::query SELECT * FROM lst_projects_legs_servtypes WHERE ServTypeId=4

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:765
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:50.018 info yii\db\Command::query SELECT * FROM user WHERE id=44

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:831
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:50.018 info yii\db\Command::query SELECT * FROM user WHERE id=44

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:831
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:50.058 info yii\db\Command::query SELECT COUNT(*) FROM projects_locks WHERE ProjId=51738

Z:\M\Websites\www.testing.com\backend\models\Projects.php:379
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:479
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082

06:45:50.058 info yii\db\Command::query SELECT COUNT(*) FROM projects_locks WHERE ProjId=51738

Z:\M\Websites\www.testing.com\backend\models\Projects.php:379
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:481
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082

06:45:50.058 info yii\db\Command::query SELECT COUNT(*) FROM projects_locks WHERE ProjId=51738

Z:\M\Websites\www.testing.com\backend\models\Projects.php:379
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:494
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082

06:45:50.058 info yii\db\Command::query SELECT * FROM projects_legs WHERE ProjId=51738 ORDER BY LegNo, StartDt

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:664
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:50.058 info yii\db\Command::query SELECT * FROM lst_projects_legs_servtypes WHERE ServTypeId=4

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:765
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:50.058 info yii\db\Command::query SELECT * FROM user WHERE id=44

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:831
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:50.088 info yii\db\Command::query SELECT COUNT(*) FROM projects_locks WHERE ProjId=51737

Z:\M\Websites\www.testing.com\backend\models\Projects.php:379
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:479
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082

06:45:50.098 info yii\db\Command::query SELECT COUNT(*) FROM projects_locks WHERE ProjId=51737

Z:\M\Websites\www.testing.com\backend\models\Projects.php:379
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:481
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082

06:45:50.098 info yii\db\Command::query SELECT COUNT(*) FROM projects_locks WHERE ProjId=51737

Z:\M\Websites\www.testing.com\backend\models\Projects.php:379
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:494
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082

06:45:50.098 info yii\db\Command::query SELECT * FROM projects_legs WHERE ProjId=51737 ORDER BY LegNo, StartDt

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:664
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:50.098 info yii\db\Command::query SELECT * FROM lst_projects_legs_servtypes WHERE ServTypeId=4

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:765
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:50.098 info yii\db\Command::query SELECT * FROM user WHERE id=44

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:831
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:50.128 info yii\db\Command::query SELECT COUNT(*) FROM projects_locks WHERE ProjId=51735

Z:\M\Websites\www.testing.com\backend\models\Projects.php:379
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:479
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082

06:45:50.128 info yii\db\Command::query SELECT COUNT(*) FROM projects_locks WHERE ProjId=51735

Z:\M\Websites\www.testing.com\backend\models\Projects.php:379
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:481
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082

06:45:50.128 info yii\db\Command::query SELECT COUNT(*) FROM projects_locks WHERE ProjId=51735

Z:\M\Websites\www.testing.com\backend\models\Projects.php:379
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:494
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082

06:45:50.128 info yii\db\Command::query SELECT * FROM projects_legs WHERE ProjId=51735 ORDER BY LegNo, StartDt

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:664
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:50.128 info yii\db\Command::query SELECT * FROM employees WHERE EmpId=648

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:723
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:50.128 info yii\db\Command::query SELECT * FROM lst_projects_legs_servtypes WHERE ServTypeId=5

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:765
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:50.128 info yii\db\Command::query SELECT * FROM user WHERE id=45

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:831
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:50.168 info yii\db\Command::query SELECT COUNT(*) FROM projects_locks WHERE ProjId=51734

Z:\M\Websites\www.testing.com\backend\models\Projects.php:379
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:479
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082

06:45:50.168 info yii\db\Command::query SELECT COUNT(*) FROM projects_locks WHERE ProjId=51734

Z:\M\Websites\www.testing.com\backend\models\Projects.php:379
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:481
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082

06:45:50.168 info yii\db\Command::query SELECT COUNT(*) FROM projects_locks WHERE ProjId=51734

Z:\M\Websites\www.testing.com\backend\models\Projects.php:379
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:494
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082

06:45:50.168 info yii\db\Command::query SELECT * FROM projects_legs WHERE ProjId=51734 ORDER BY LegNo, StartDt

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:664
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:50.168 info yii\db\Command::query SELECT * FROM employees WHERE EmpId=31

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:723
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:50.168 info yii\db\Command::query SELECT * FROM employees WHERE EmpId=31

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:723
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:50.168 info yii\db\Command::query SELECT * FROM lst_projects_legs_servtypes WHERE ServTypeId=4

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:765
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:50.168 info yii\db\Command::query SELECT * FROM lst_projects_legs_servtypes WHERE ServTypeId=5

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:765
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:50.168 info yii\db\Command::query SELECT * FROM user WHERE id=42

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:831
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:50.168 info yii\db\Command::query SELECT * FROM user WHERE id=42

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:831
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:50.208 info yii\db\Command::query SELECT COUNT(*) FROM projects_locks WHERE ProjId=51733

Z:\M\Websites\www.testing.com\backend\models\Projects.php:379
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:479
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082

DBCreator · March 2, 2021, 11:54am

Cont’d

06:45:50.208 info yii\db\Command::query SELECT COUNT(*) FROM projects_locks WHERE ProjId=51733

Z:\M\Websites\www.testing.com\backend\models\Projects.php:379
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:481
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082

06:45:50.218 info yii\db\Command::query SELECT COUNT(*) FROM projects_locks WHERE ProjId=51733

Z:\M\Websites\www.testing.com\backend\models\Projects.php:379
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:494
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082

06:45:50.218 info yii\db\Command::query SELECT * FROM projects_legs WHERE ProjId=51733 ORDER BY LegNo, StartDt

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:664
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:50.218 info yii\db\Command::query SELECT * FROM employees WHERE EmpId=1283

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:723
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:50.218 info yii\db\Command::query SELECT * FROM lst_projects_legs_servtypes WHERE ServTypeId=5

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:765
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:50.218 info yii\db\Command::query SELECT * FROM user WHERE id=42

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:831
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:50.248 info yii\db\Command::query SELECT COUNT(*) FROM projects_locks WHERE ProjId=51732

Z:\M\Websites\www.testing.com\backend\models\Projects.php:379
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:479
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082

06:45:50.248 info yii\db\Command::query SELECT COUNT(*) FROM projects_locks WHERE ProjId=51732

Z:\M\Websites\www.testing.com\backend\models\Projects.php:379
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:481
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082

06:45:50.248 info yii\db\Command::query SELECT COUNT(*) FROM projects_locks WHERE ProjId=51732

Z:\M\Websites\www.testing.com\backend\models\Projects.php:379
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:494
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082

06:45:50.248 info yii\db\Command::query SELECT * FROM projects_legs WHERE ProjId=51732 ORDER BY LegNo, StartDt

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:664
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:50.258 info yii\db\Command::query SELECT * FROM employees WHERE EmpId=1283

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:723
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:50.258 info yii\db\Command::query SELECT * FROM lst_projects_legs_servtypes WHERE ServTypeId=5

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:765
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:50.258 info yii\db\Command::query SELECT * FROM user WHERE id=42

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:831
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:50.288 info yii\db\Command::query SELECT COUNT(*) FROM projects_locks WHERE ProjId=51731

Z:\M\Websites\www.testing.com\backend\models\Projects.php:379
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:479
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082

06:45:50.288 info yii\db\Command::query SELECT COUNT(*) FROM projects_locks WHERE ProjId=51731

Z:\M\Websites\www.testing.com\backend\models\Projects.php:379
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:481
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082

06:45:50.288 info yii\db\Command::query SELECT COUNT(*) FROM projects_locks WHERE ProjId=51731

Z:\M\Websites\www.testing.com\backend\models\Projects.php:379
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:494
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082

06:45:50.298 info yii\db\Command::query SELECT * FROM projects_legs WHERE ProjId=51731 ORDER BY LegNo, StartDt

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:664
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:50.298 info yii\db\Command::query SELECT * FROM employees WHERE EmpId=1795

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:723
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:50.298 info yii\db\Command::query SELECT * FROM employees WHERE EmpId=342

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:723
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:50.298 info yii\db\Command::query SELECT * FROM lst_projects_legs_servtypes WHERE ServTypeId=2

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:765
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:50.298 info yii\db\Command::query SELECT * FROM lst_projects_legs_servtypes WHERE ServTypeId=3

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:765
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:50.298 info yii\db\Command::query SELECT * FROM lst_projects_legs_servtypes WHERE ServTypeId=5

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:765
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:50.298 info yii\db\Command::query SELECT * FROM user WHERE id=44

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:831
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:50.298 info yii\db\Command::query SELECT * FROM user WHERE id=42

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:831
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:50.298 info yii\db\Command::query SELECT * FROM user WHERE id=42

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:831
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:50.328 info yii\db\Command::query SELECT COUNT(*) FROM projects_locks WHERE ProjId=51730

Z:\M\Websites\www.testing.com\backend\models\Projects.php:379
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:479
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082

06:45:50.338 info yii\db\Command::query SELECT COUNT(*) FROM projects_locks WHERE ProjId=51730

Z:\M\Websites\www.testing.com\backend\models\Projects.php:379
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:481
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082

06:45:50.338 info yii\db\Command::query SELECT COUNT(*) FROM projects_locks WHERE ProjId=51730

Z:\M\Websites\www.testing.com\backend\models\Projects.php:379
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:494
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082

06:45:50.338 info yii\db\Command::query SELECT * FROM projects_legs WHERE ProjId=51730 ORDER BY LegNo, StartDt

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:664
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:50.338 info yii\db\Command::query SELECT * FROM employees WHERE EmpId=1941

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:723
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:50.338 info yii\db\Command::query SELECT * FROM employees WHERE EmpId=188

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:723
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:50.338 info yii\db\Command::query SELECT * FROM lst_projects_legs_servtypes WHERE ServTypeId=5

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:765
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:50.338 info yii\db\Command::query SELECT * FROM lst_projects_legs_servtypes WHERE ServTypeId=4

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:765
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:50.338 info yii\db\Command::query SELECT * FROM lst_projects_legs_servtypes WHERE ServTypeId=5

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:765
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:50.338 info yii\db\Command::query SELECT * FROM user WHERE id=44

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:831
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:50.338 info yii\db\Command::query SELECT * FROM user WHERE id=44

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:831
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:50.338 info yii\db\Command::query SELECT * FROM user WHERE id=44

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:831
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:50.378 info yii\db\Command::query SELECT COUNT(*) FROM projects_locks WHERE ProjId=51729

Z:\M\Websites\www.testing.com\backend\models\Projects.php:379
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:479
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082

06:45:50.378 info yii\db\Command::query SELECT COUNT(*) FROM projects_locks WHERE ProjId=51729

Z:\M\Websites\www.testing.com\backend\models\Projects.php:379
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:481
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082

06:45:50.378 info yii\db\Command::query SELECT COUNT(*) FROM projects_locks WHERE ProjId=51729

Z:\M\Websites\www.testing.com\backend\models\Projects.php:379
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:494
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082

06:45:50.378 info yii\db\Command::query SELECT * FROM projects_legs WHERE ProjId=51729 ORDER BY LegNo, StartDt

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:664
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:50.378 info yii\db\Command::query SELECT * FROM employees WHERE EmpId=1970

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:723
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:50.378 info yii\db\Command::query SELECT * FROM employees WHERE EmpId=234

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:723
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:50.378 info yii\db\Command::query SELECT * FROM lst_projects_legs_servtypes WHERE ServTypeId=5

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:765
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:50.378 info yii\db\Command::query SELECT * FROM lst_projects_legs_servtypes WHERE ServTypeId=4

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:765
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:50.378 info yii\db\Command::query SELECT * FROM user WHERE id=49

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:831
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:50.378 info yii\db\Command::query SELECT * FROM user WHERE id=49

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:831
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:50.418 info yii\db\Command::query SELECT COUNT(*) FROM projects_locks WHERE ProjId=51728

Z:\M\Websites\www.testing.com\backend\models\Projects.php:379
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:479
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082

06:45:50.418 info yii\db\Command::query SELECT COUNT(*) FROM projects_locks WHERE ProjId=51728

Z:\M\Websites\www.testing.com\backend\models\Projects.php:379
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:481
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082

06:45:50.418 info yii\db\Command::query SELECT COUNT(*) FROM projects_locks WHERE ProjId=51728

Z:\M\Websites\www.testing.com\backend\models\Projects.php:379
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:494
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082

06:45:50.418 info yii\db\Command::query SELECT * FROM projects_legs WHERE ProjId=51728 ORDER BY LegNo, StartDt

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:664
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:50.418 info yii\db\Command::query SELECT * FROM lst_projects_legs_servtypes WHERE ServTypeId=4

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:765
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:50.418 info yii\db\Command::query SELECT * FROM lst_projects_legs_servtypes WHERE ServTypeId=5

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:765
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:50.418 info yii\db\Command::query SELECT * FROM user WHERE id=42

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:831
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:50.418 info yii\db\Command::query SELECT * FROM user WHERE id=42

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:831
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:50.458 info yii\db\Command::query SELECT COUNT(*) FROM projects_locks WHERE ProjId=51727

Z:\M\Websites\www.testing.com\backend\models\Projects.php:379
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:479
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082

06:45:50.458 info yii\db\Command::query SELECT COUNT(*) FROM projects_locks WHERE ProjId=51727

Z:\M\Websites\www.testing.com\backend\models\Projects.php:379
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:481
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082

06:45:50.458 info yii\db\Command::query SELECT COUNT(*) FROM projects_locks WHERE ProjId=51727

Z:\M\Websites\www.testing.com\backend\models\Projects.php:379
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:494
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082

06:45:50.458 info yii\db\Command::query SELECT * FROM projects_legs WHERE ProjId=51727 ORDER BY LegNo, StartDt

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:664
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:50.458 info yii\db\Command::query SELECT * FROM employees WHERE EmpId=1884

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:723
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:50.458 info yii\db\Command::query SELECT * FROM lst_projects_legs_servtypes WHERE ServTypeId=45

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:765
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:50.458 info yii\db\Command::query SELECT * FROM user WHERE id=44

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:831
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:50.498 info yii\db\Command::query SELECT COUNT(*) FROM projects_locks WHERE ProjId=51726

Z:\M\Websites\www.testing.com\backend\models\Projects.php:379
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:479
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082

06:45:50.498 info yii\db\Command::query SELECT COUNT(*) FROM projects_locks WHERE ProjId=51726

Z:\M\Websites\www.testing.com\backend\models\Projects.php:379
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:481
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082

06:45:50.498 info yii\db\Command::query SELECT COUNT(*) FROM projects_locks WHERE ProjId=51726

Z:\M\Websites\www.testing.com\backend\models\Projects.php:379
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:494
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082

06:45:50.498 info yii\db\Command::query SELECT * FROM projects_legs WHERE ProjId=51726 ORDER BY LegNo, StartDt

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:664
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:50.498 info yii\db\Command::query SELECT * FROM lst_projects_legs_servtypes WHERE ServTypeId=5

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:765
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:50.498 info yii\db\Command::query SELECT * FROM user WHERE id=42

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:831
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:50.538 info yii\db\Command::query SELECT COUNT(*) FROM projects_locks WHERE ProjId=51725

Z:\M\Websites\www.testing.com\backend\models\Projects.php:379
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:479
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082

06:45:50.538 info yii\db\Command::query SELECT COUNT(*) FROM projects_locks WHERE ProjId=51725

Z:\M\Websites\www.testing.com\backend\models\Projects.php:379
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:481
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082

06:45:50.538 info yii\db\Command::query SELECT COUNT(*) FROM projects_locks WHERE ProjId=51725

Z:\M\Websites\www.testing.com\backend\models\Projects.php:379
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:494
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082

06:45:50.538 info yii\db\Command::query SELECT * FROM projects_legs WHERE ProjId=51725 ORDER BY LegNo, StartDt

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:664
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:50.538 info yii\db\Command::query SELECT * FROM lst_projects_legs_servtypes WHERE ServTypeId=5

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:765
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:50.538 info yii\db\Command::query SELECT * FROM lst_projects_legs_servtypes WHERE ServTypeId=5

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:765
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:50.538 info yii\db\Command::query SELECT * FROM lst_projects_legs_servtypes WHERE ServTypeId=5

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:765
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:50.538 info yii\db\Command::query SELECT * FROM user WHERE id=42

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:831
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:50.538 info yii\db\Command::query SELECT * FROM user WHERE id=42

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:831
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:50.538 info yii\db\Command::query SELECT * FROM user WHERE id=42

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:831
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:50.578 info yii\db\Command::query SELECT COUNT(*) FROM projects_locks WHERE ProjId=51724

Z:\M\Websites\www.testing.com\backend\models\Projects.php:379
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:479
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082

06:45:50.578 info yii\db\Command::query SELECT COUNT(*) FROM projects_locks WHERE ProjId=51724

Z:\M\Websites\www.testing.com\backend\models\Projects.php:379
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:481
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082

06:45:50.578 info yii\db\Command::query SELECT COUNT(*) FROM projects_locks WHERE ProjId=51724

Z:\M\Websites\www.testing.com\backend\models\Projects.php:379
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:494
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082

06:45:50.578 info yii\db\Command::query SELECT * FROM projects_legs WHERE ProjId=51724 ORDER BY LegNo, StartDt

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:664
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:50.578 info yii\db\Command::query SELECT * FROM employees WHERE EmpId=1554

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:723
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

DBCreator · March 2, 2021, 11:54am

Cont’d

06:45:50.578 info yii\db\Command::query SELECT * FROM lst_projects_legs_servtypes WHERE ServTypeId=3

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:765
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:50.578 info yii\db\Command::query SELECT * FROM user WHERE id=42

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:831
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:50.618 info yii\db\Command::query SELECT COUNT(*) FROM projects_locks WHERE ProjId=51723

Z:\M\Websites\www.testing.com\backend\models\Projects.php:379
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:479
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082

06:45:50.618 info yii\db\Command::query SELECT COUNT(*) FROM projects_locks WHERE ProjId=51723

Z:\M\Websites\www.testing.com\backend\models\Projects.php:379
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:481
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082

06:45:50.618 info yii\db\Command::query SELECT COUNT(*) FROM projects_locks WHERE ProjId=51723

Z:\M\Websites\www.testing.com\backend\models\Projects.php:379
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:494
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082

06:45:50.618 info yii\db\Command::query SELECT * FROM projects_legs WHERE ProjId=51723 ORDER BY LegNo, StartDt

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:664
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:50.618 info yii\db\Command::query SELECT * FROM employees WHERE EmpId=1554

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:723
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:50.618 info yii\db\Command::query SELECT * FROM lst_projects_legs_servtypes WHERE ServTypeId=3

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:765
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:50.618 info yii\db\Command::query SELECT * FROM user WHERE id=42

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:831
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:50.648 info yii\db\Command::query SELECT COUNT(*) FROM projects_locks WHERE ProjId=51722

Z:\M\Websites\www.testing.com\backend\models\Projects.php:379
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:479
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082

06:45:50.658 info yii\db\Command::query SELECT COUNT(*) FROM projects_locks WHERE ProjId=51722

Z:\M\Websites\www.testing.com\backend\models\Projects.php:379
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:481
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082

06:45:50.658 info yii\db\Command::query SELECT COUNT(*) FROM projects_locks WHERE ProjId=51722

Z:\M\Websites\www.testing.com\backend\models\Projects.php:379
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:494
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082

06:45:50.658 info yii\db\Command::query SELECT * FROM projects_legs WHERE ProjId=51722 ORDER BY LegNo, StartDt

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:664
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:50.658 info yii\db\Command::query SELECT * FROM employees WHERE EmpId=234

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:723
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:50.658 info yii\db\Command::query SELECT * FROM lst_projects_legs_servtypes WHERE ServTypeId=4

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:765
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:50.658 info yii\db\Command::query SELECT * FROM user WHERE id=44

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:831
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:50.698 info yii\db\Command::query SELECT COUNT(*) FROM projects_locks WHERE ProjId=51721

Z:\M\Websites\www.testing.com\backend\models\Projects.php:379
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:479
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082

06:45:50.698 info yii\db\Command::query SELECT COUNT(*) FROM projects_locks WHERE ProjId=51721

Z:\M\Websites\www.testing.com\backend\models\Projects.php:379
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:481
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082

06:45:50.698 info yii\db\Command::query SELECT COUNT(*) FROM projects_locks WHERE ProjId=51721

Z:\M\Websites\www.testing.com\backend\models\Projects.php:379
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:494
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082

06:45:50.698 info yii\db\Command::query SELECT * FROM projects_legs WHERE ProjId=51721 ORDER BY LegNo, StartDt

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:664
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:50.698 info yii\db\Command::query SELECT * FROM employees WHERE EmpId=15

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:723
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:50.698 info yii\db\Command::query SELECT * FROM lst_projects_legs_servtypes WHERE ServTypeId=5

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:765
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:50.698 info yii\db\Command::query SELECT * FROM user WHERE id=44

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:831
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:50.728 info yii\db\Command::query SELECT COUNT(*) FROM projects_locks WHERE ProjId=51720

Z:\M\Websites\www.testing.com\backend\models\Projects.php:379
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:479
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082

06:45:50.738 info yii\db\Command::query SELECT COUNT(*) FROM projects_locks WHERE ProjId=51720

Z:\M\Websites\www.testing.com\backend\models\Projects.php:379
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:481
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082

06:45:50.738 info yii\db\Command::query SELECT COUNT(*) FROM projects_locks WHERE ProjId=51720

Z:\M\Websites\www.testing.com\backend\models\Projects.php:379
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:494
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082

06:45:50.738 info yii\db\Command::query SELECT * FROM projects_legs WHERE ProjId=51720 ORDER BY LegNo, StartDt

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:664
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:50.738 info yii\db\Command::query SELECT * FROM employees WHERE EmpId=441

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:723
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:50.738 info yii\db\Command::query SELECT * FROM employees WHERE EmpId=18

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:723
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:50.738 info yii\db\Command::query SELECT * FROM lst_projects_legs_servtypes WHERE ServTypeId=2

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:765
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:50.738 info yii\db\Command::query SELECT * FROM lst_projects_legs_servtypes WHERE ServTypeId=2

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:765
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:50.738 info yii\db\Command::query SELECT * FROM user WHERE id=45

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:831
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:50.738 info yii\db\Command::query SELECT * FROM user WHERE id=45

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:831
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:50.768 info yii\db\Command::query SELECT COUNT(*) FROM projects_locks WHERE ProjId=51719

Z:\M\Websites\www.testing.com\backend\models\Projects.php:379
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:479
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082

06:45:50.778 info yii\db\Command::query SELECT COUNT(*) FROM projects_locks WHERE ProjId=51719

Z:\M\Websites\www.testing.com\backend\models\Projects.php:379
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:481
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082

06:45:50.778 info yii\db\Command::query SELECT COUNT(*) FROM projects_locks WHERE ProjId=51719

Z:\M\Websites\www.testing.com\backend\models\Projects.php:379
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:494
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082

06:45:50.778 info yii\db\Command::query SELECT * FROM projects_legs WHERE ProjId=51719 ORDER BY LegNo, StartDt

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:664
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:50.778 info yii\db\Command::query SELECT * FROM employees WHERE EmpId=1970

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:723
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:50.778 info yii\db\Command::query SELECT * FROM lst_projects_legs_servtypes WHERE ServTypeId=5

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:765
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:50.778 info yii\db\Command::query SELECT * FROM user WHERE id=45

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:831
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:50.818 info yii\db\Command::query SELECT COUNT(*) FROM projects_locks WHERE ProjId=51718

Z:\M\Websites\www.testing.com\backend\models\Projects.php:379
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:479
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082

06:45:50.818 info yii\db\Command::query SELECT COUNT(*) FROM projects_locks WHERE ProjId=51718

Z:\M\Websites\www.testing.com\backend\models\Projects.php:379
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:481
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082

06:45:50.818 info yii\db\Command::query SELECT COUNT(*) FROM projects_locks WHERE ProjId=51718

Z:\M\Websites\www.testing.com\backend\models\Projects.php:379
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:494
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082

06:45:50.818 info yii\db\Command::query SELECT * FROM projects_legs WHERE ProjId=51718 ORDER BY LegNo, StartDt

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:664
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:50.818 info yii\db\Command::query SELECT * FROM employees WHERE EmpId=1810

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:723
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:50.818 info yii\db\Command::query SELECT * FROM employees WHERE EmpId=1810

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:723
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:50.818 info yii\db\Command::query SELECT * FROM lst_projects_legs_servtypes WHERE ServTypeId=5

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:765
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:50.818 info yii\db\Command::query SELECT * FROM lst_projects_legs_servtypes WHERE ServTypeId=4

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:765
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:50.818 info yii\db\Command::query SELECT * FROM user WHERE id=42

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:831
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:50.818 info yii\db\Command::query SELECT * FROM user WHERE id=42

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:831
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:50.858 info yii\db\Command::query SELECT COUNT(*) FROM projects_locks WHERE ProjId=51717

Z:\M\Websites\www.testing.com\backend\models\Projects.php:379
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:479
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082

06:45:50.858 info yii\db\Command::query SELECT COUNT(*) FROM projects_locks WHERE ProjId=51717

Z:\M\Websites\www.testing.com\backend\models\Projects.php:379
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:481
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082

06:45:50.858 info yii\db\Command::query SELECT COUNT(*) FROM projects_locks WHERE ProjId=51717

Z:\M\Websites\www.testing.com\backend\models\Projects.php:379
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:494
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082

06:45:50.858 info yii\db\Command::query SELECT * FROM projects_legs WHERE ProjId=51717 ORDER BY LegNo, StartDt

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:664
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:50.858 info yii\db\Command::query SELECT * FROM lst_projects_legs_servtypes WHERE ServTypeId=5

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:765
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:50.858 info yii\db\Command::query SELECT * FROM user WHERE id=58

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:831
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:50.888 info yii\db\Command::query SELECT COUNT(*) FROM projects_locks WHERE ProjId=51716

Z:\M\Websites\www.testing.com\backend\models\Projects.php:379
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:479
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082

06:45:50.898 info yii\db\Command::query SELECT COUNT(*) FROM projects_locks WHERE ProjId=51716

Z:\M\Websites\www.testing.com\backend\models\Projects.php:379
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:481
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082

06:45:50.898 info yii\db\Command::query SELECT COUNT(*) FROM projects_locks WHERE ProjId=51716

Z:\M\Websites\www.testing.com\backend\models\Projects.php:379
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:494
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082

06:45:50.898 info yii\db\Command::query SELECT * FROM projects_legs WHERE ProjId=51716 ORDER BY LegNo, StartDt

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:664
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:50.898 info yii\db\Command::query SELECT * FROM employees WHERE EmpId=14

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:723
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:50.898 info yii\db\Command::query SELECT * FROM employees WHERE EmpId=14

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:723
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:50.898 info yii\db\Command::query SELECT * FROM lst_projects_legs_servtypes WHERE ServTypeId=4

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:765
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:50.898 info yii\db\Command::query SELECT * FROM lst_projects_legs_servtypes WHERE ServTypeId=5

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:765
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:50.898 info yii\db\Command::query SELECT * FROM user WHERE id=49

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:831
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:50.898 info yii\db\Command::query SELECT * FROM user WHERE id=49

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:831
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:50.928 info yii\db\Command::query SELECT COUNT(*) FROM projects_locks WHERE ProjId=51715

Z:\M\Websites\www.testing.com\backend\models\Projects.php:379
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:479
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082

06:45:50.938 info yii\db\Command::query SELECT COUNT(*) FROM projects_locks WHERE ProjId=51715

Z:\M\Websites\www.testing.com\backend\models\Projects.php:379
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:481
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082

06:45:50.938 info yii\db\Command::query SELECT COUNT(*) FROM projects_locks WHERE ProjId=51715

Z:\M\Websites\www.testing.com\backend\models\Projects.php:379
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:494
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082

06:45:50.938 info yii\db\Command::query SELECT * FROM projects_legs WHERE ProjId=51715 ORDER BY LegNo, StartDt

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:664
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:50.938 info yii\db\Command::query SELECT * FROM employees WHERE EmpId=1556

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:723
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:50.938 info yii\db\Command::query SELECT * FROM employees WHERE EmpId=926

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:723
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:50.938 info yii\db\Command::query SELECT * FROM lst_projects_legs_servtypes WHERE ServTypeId=4

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:765
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:50.938 info yii\db\Command::query SELECT * FROM lst_projects_legs_servtypes WHERE ServTypeId=5

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:765
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:50.938 info yii\db\Command::query SELECT * FROM user WHERE id=49

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:831
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:50.938 info yii\db\Command::query SELECT * FROM user WHERE id=49

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:831
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:50.978 info yii\db\Command::query SELECT COUNT(*) FROM projects_locks WHERE ProjId=51714

Z:\M\Websites\www.testing.com\backend\models\Projects.php:379
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:479
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082

06:45:50.978 info yii\db\Command::query SELECT COUNT(*) FROM projects_locks WHERE ProjId=51714

Z:\M\Websites\www.testing.com\backend\models\Projects.php:379
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:481
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082

06:45:50.978 info yii\db\Command::query SELECT COUNT(*) FROM projects_locks WHERE ProjId=51714

Z:\M\Websites\www.testing.com\backend\models\Projects.php:379
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:494
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082

06:45:50.978 info yii\db\Command::query SELECT * FROM projects_legs WHERE ProjId=51714 ORDER BY LegNo, StartDt

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:664
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:50.978 info yii\db\Command::query SELECT * FROM employees WHERE EmpId=455

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:723
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:50.978 info yii\db\Command::query SELECT * FROM employees WHERE EmpId=455

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:723
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:50.978 info yii\db\Command::query SELECT * FROM employees WHERE EmpId=242

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:723
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

DBCreator · March 2, 2021, 11:55am

Cont’d (final)

06:45:50.978 info yii\db\Command::query SELECT * FROM lst_projects_legs_servtypes WHERE ServTypeId=3

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:765
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:50.978 info yii\db\Command::query SELECT * FROM lst_projects_legs_servtypes WHERE ServTypeId=5

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:765
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:50.978 info yii\db\Command::query SELECT * FROM lst_projects_legs_servtypes WHERE ServTypeId=4

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:765
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:50.978 info yii\db\Command::query SELECT * FROM user WHERE id=49

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:831
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:50.978 info yii\db\Command::query SELECT * FROM user WHERE id=44

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:831
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:50.978 info yii\db\Command::query SELECT * FROM user WHERE id=42

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:831
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:51.018 info yii\db\Command::query SELECT COUNT(*) FROM projects_locks WHERE ProjId=51713

Z:\M\Websites\www.testing.com\backend\models\Projects.php:379
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:479
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082

06:45:51.018 info yii\db\Command::query SELECT COUNT(*) FROM projects_locks WHERE ProjId=51713

Z:\M\Websites\www.testing.com\backend\models\Projects.php:379
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:481
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082

06:45:51.018 info yii\db\Command::query SELECT COUNT(*) FROM projects_locks WHERE ProjId=51713

Z:\M\Websites\www.testing.com\backend\models\Projects.php:379
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:494
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082

06:45:51.018 info yii\db\Command::query SELECT * FROM projects_legs WHERE ProjId=51713 ORDER BY LegNo, StartDt

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:664
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:51.018 info yii\db\Command::query SELECT * FROM employees WHERE EmpId=1614

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:723
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:51.018 info yii\db\Command::query SELECT * FROM employees WHERE EmpId=242

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:723
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:51.018 info yii\db\Command::query SELECT * FROM employees WHERE EmpId=242

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:723
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:51.018 info yii\db\Command::query SELECT * FROM lst_projects_legs_servtypes WHERE ServTypeId=5

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:765
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:51.028 info yii\db\Command::query SELECT * FROM lst_projects_legs_servtypes WHERE ServTypeId=4

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:765
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:51.028 info yii\db\Command::query SELECT * FROM lst_projects_legs_servtypes WHERE ServTypeId=5

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:765
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:51.028 info yii\db\Command::query SELECT * FROM user WHERE id=49

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:831
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:51.028 info yii\db\Command::query SELECT * FROM user WHERE id=49

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:831
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:51.028 info yii\db\Command::query SELECT * FROM user WHERE id=49

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:831
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:51.058 info yii\db\Command::query SELECT COUNT(*) FROM projects_locks WHERE ProjId=51712

Z:\M\Websites\www.testing.com\backend\models\Projects.php:379
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:479
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082

06:45:51.058 info yii\db\Command::query SELECT COUNT(*) FROM projects_locks WHERE ProjId=51712

Z:\M\Websites\www.testing.com\backend\models\Projects.php:379
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:481
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082

06:45:51.058 info yii\db\Command::query SELECT COUNT(*) FROM projects_locks WHERE ProjId=51712

Z:\M\Websites\www.testing.com\backend\models\Projects.php:379
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:494
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082

06:45:51.068 info yii\db\Command::query SELECT * FROM projects_legs WHERE ProjId=51712 ORDER BY LegNo, StartDt

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:664
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:51.068 info yii\db\Command::query SELECT * FROM employees WHERE EmpId=1401

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:723
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:51.068 info yii\db\Command::query SELECT * FROM employees WHERE EmpId=16

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:723
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:51.068 info yii\db\Command::query SELECT * FROM lst_projects_legs_servtypes WHERE ServTypeId=5

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:765
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:51.068 info yii\db\Command::query SELECT * FROM lst_projects_legs_servtypes WHERE ServTypeId=5

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:765
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:51.068 info yii\db\Command::query SELECT * FROM user WHERE id=49

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:831
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:51.068 info yii\db\Command::query SELECT * FROM user WHERE id=49

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:831
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:51.108 info yii\db\Command::query SELECT COUNT(*) FROM projects_locks WHERE ProjId=51711

Z:\M\Websites\www.testing.com\backend\models\Projects.php:379
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:479
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082

06:45:51.108 info yii\db\Command::query SELECT COUNT(*) FROM projects_locks WHERE ProjId=51711

Z:\M\Websites\www.testing.com\backend\models\Projects.php:379
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:481
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082

06:45:51.108 info yii\db\Command::query SELECT COUNT(*) FROM projects_locks WHERE ProjId=51711

Z:\M\Websites\www.testing.com\backend\models\Projects.php:379
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:494
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082

06:45:51.108 info yii\db\Command::query SELECT * FROM projects_legs WHERE ProjId=51711 ORDER BY LegNo, StartDt

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:664
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:51.108 info yii\db\Command::query SELECT * FROM employees WHERE EmpId=725

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:723
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:51.108 info yii\db\Command::query SELECT * FROM employees WHERE EmpId=725

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:723
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:51.108 info yii\db\Command::query SELECT * FROM employees WHERE EmpId=1996

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:723
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:51.108 info yii\db\Command::query SELECT * FROM lst_projects_legs_servtypes WHERE ServTypeId=5

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:765
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:51.108 info yii\db\Command::query SELECT * FROM lst_projects_legs_servtypes WHERE ServTypeId=4

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:765
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:51.108 info yii\db\Command::query SELECT * FROM lst_projects_legs_servtypes WHERE ServTypeId=5

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:765
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:51.108 info yii\db\Command::query SELECT * FROM user WHERE id=49

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:831
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:51.108 info yii\db\Command::query SELECT * FROM user WHERE id=49

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:831
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:51.108 info yii\db\Command::query SELECT * FROM user WHERE id=49

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:831
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:51.148 info yii\db\Command::query SELECT COUNT(*) FROM projects_locks WHERE ProjId=51710

Z:\M\Websites\www.testing.com\backend\models\Projects.php:379
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:479
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082

06:45:51.148 info yii\db\Command::query SELECT COUNT(*) FROM projects_locks WHERE ProjId=51710

Z:\M\Websites\www.testing.com\backend\models\Projects.php:379
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:481
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082

06:45:51.148 info yii\db\Command::query SELECT COUNT(*) FROM projects_locks WHERE ProjId=51710

Z:\M\Websites\www.testing.com\backend\models\Projects.php:379
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:494
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082

06:45:51.148 info yii\db\Command::query SELECT * FROM projects_legs WHERE ProjId=51710 ORDER BY LegNo, StartDt

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:664
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:51.148 info yii\db\Command::query SELECT * FROM employees WHERE EmpId=14

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:723
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:51.148 info yii\db\Command::query SELECT * FROM lst_projects_legs_servtypes WHERE ServTypeId=5

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:765
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:51.148 info yii\db\Command::query SELECT * FROM user WHERE id=49

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:831
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:51.188 info yii\db\Command::query SELECT COUNT(*) FROM projects_locks WHERE ProjId=51709

Z:\M\Websites\www.testing.com\backend\models\Projects.php:379
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:479
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082

06:45:51.188 info yii\db\Command::query SELECT COUNT(*) FROM projects_locks WHERE ProjId=51709

Z:\M\Websites\www.testing.com\backend\models\Projects.php:379
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:481
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082

06:45:51.188 info yii\db\Command::query SELECT COUNT(*) FROM projects_locks WHERE ProjId=51709

Z:\M\Websites\www.testing.com\backend\models\Projects.php:379
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:494
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082

06:45:51.188 info yii\db\Command::query SELECT * FROM projects_legs WHERE ProjId=51709 ORDER BY LegNo, StartDt

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:664
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:51.188 info yii\db\Command::query SELECT * FROM employees WHERE EmpId=137

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:723
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:51.188 info yii\db\Command::query SELECT * FROM lst_projects_legs_servtypes WHERE ServTypeId=5

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:765
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:51.188 info yii\db\Command::query SELECT * FROM user WHERE id=44

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:831
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:51.228 info yii\db\Command::query SELECT COUNT(*) FROM projects_locks WHERE ProjId=51708

Z:\M\Websites\www.testing.com\backend\models\Projects.php:379
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:479
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082

06:45:51.228 info yii\db\Command::query SELECT COUNT(*) FROM projects_locks WHERE ProjId=51708

Z:\M\Websites\www.testing.com\backend\models\Projects.php:379
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:481
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082

06:45:51.228 info yii\db\Command::query SELECT COUNT(*) FROM projects_locks WHERE ProjId=51708

Z:\M\Websites\www.testing.com\backend\models\Projects.php:379
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:494
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082

06:45:51.228 info yii\db\Command::query SELECT * FROM projects_legs WHERE ProjId=51708 ORDER BY LegNo, StartDt

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:664
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:51.228 info yii\db\Command::query SELECT * FROM lst_projects_legs_servtypes WHERE ServTypeId=5

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:765
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:51.228 info yii\db\Command::query SELECT * FROM user WHERE id=45

Z:\M\Websites\www.testing.com\backend\views\projects\index.php:831
Z:\M\Websites\www.testing.com\backend\views\projects\index.php:1082
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:51.298 trace yii\base\View::renderFile Rendering view file: Z:\M\Websites\www.testing.com\backend\views\layouts\main.php

Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:51.348 info yii\db\Command::query SELECT * FROM auth_item WHERE name=‘Administrator’

Z:\M\Websites\www.testing.com\backend\views\layouts\main.php:70
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:51.348 trace yii\rbac\DbManager::checkAccessRecursive Checking role: Administrator

Z:\M\Websites\www.testing.com\backend\views\layouts\main.php:70
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:51.348 info yii\db\Command::query SELECT * FROM auth_item WHERE name=‘Dashboard-User’

Z:\M\Websites\www.testing.com\backend\views\layouts\main.php:116
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:51.348 trace yii\rbac\DbManager::checkAccessRecursive Checking permission: Dashboard-User

Z:\M\Websites\www.testing.com\backend\views\layouts\main.php:116
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:51.348 info yii\db\Command::query SELECT parent FROM auth_item_child WHERE child=‘Dashboard-User’

Z:\M\Websites\www.testing.com\backend\views\layouts\main.php:116
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:51.348 info yii\db\Command::query SELECT * FROM auth_item WHERE name=‘Administrator’

Z:\M\Websites\www.testing.com\backend\views\layouts\main.php:116
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:51.348 trace yii\rbac\DbManager::checkAccessRecursive Checking role: Administrator

Z:\M\Websites\www.testing.com\backend\views\layouts\main.php:116
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:51.348 info yii\db\Command::query SELECT * FROM auth_item WHERE name=‘Dashboard-Finance’

Z:\M\Websites\www.testing.com\backend\views\layouts\main.php:120
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:51.348 trace yii\rbac\DbManager::checkAccessRecursive Checking permission: Dashboard-Finance

Z:\M\Websites\www.testing.com\backend\views\layouts\main.php:120
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:51.348 info yii\db\Command::query SELECT parent FROM auth_item_child WHERE child=‘Dashboard-Finance’

Z:\M\Websites\www.testing.com\backend\views\layouts\main.php:120
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:51.348 info yii\db\Command::query SELECT * FROM auth_item WHERE name=‘Administrator’

Z:\M\Websites\www.testing.com\backend\views\layouts\main.php:120
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:51.348 trace yii\rbac\DbManager::checkAccessRecursive Checking role: Administrator

Z:\M\Websites\www.testing.com\backend\views\layouts\main.php:120
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:51.348 info yii\db\Command::query SELECT * FROM auth_item WHERE name=‘Backup’

Z:\M\Websites\www.testing.com\backend\views\layouts\main.php:126
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

06:45:51.348 trace yii\rbac\DbManager::checkAccessRecursive Checking role: Backup

Z:\M\Websites\www.testing.com\backend\views\layouts\main.php:126
Z:\M\Websites\www.testing.com\backend\controllers\ProjectsController.php:103

DBCreator · March 2, 2021, 12:19pm

Now, looking over the log file, I notice that things like

[
	'attribute'=>'ClientId',
	'format' => 'html',
	'content' => function($model, $key) {
		if(isset($model->ContactId)){
			return '<div title="' . (isset($model->contact->contactInfoText) ? $model->contact->contactInfoText : '') . '">' . (isset($model->client->Company) ? $model->client->Company : '') . '</div>';
		}else{
			return (isset($model->client->Company) ? $model->client->Company : '');
		}
	},
],

is generating multiple (100 records per view) queries like

SELECT * FROM projects_legsWHEREProjId=51781 ORDER BY LegNo, StartDt`

which is pulling the entire record (all fields) when I only need a subset of fields.

Would switching to an approach like

$model = Contacts::find()->select()...

, where I limit the fields, be better?

DBCreator · March 2, 2021, 2:50pm

Also, in the case of a column definition like

...
'class' => (($model->IsLocked != 0) ? 'btn btn-warning btn-xs modalButton' : 'btn btn-info btn-xs modalButton ' ),
'title'=> (($model->IsLocked != 0) ? Yii::t('app', 'Booking Details of Project No.').' '.$model->ProjNo.
...

I’m querying multiple times $model->IsLocked which is a model function

public function getProjectsLocks()
{
    return $this->hasOne(ProjectsLocks::class, ['ProjId' => 'ProjId']);
}    
public function getIsLocked()
{
     return $this->getProjectsLocks()->count();
}

How can I modify my code to only make that check once, but reuse the result in other aspects of the column?
Can my getIsLocked function be better created?

DBCreator · March 2, 2021, 3:16pm

One more area I see I might be able to optimize is

foreach ($model->projectsLegs as $projectLeg) {
    $LegsFrom[] = $projectLeg->LocFrom;
}

where projectsLegs is a model function

public function getProjectsLegs()
{
    return $this->hasMany(ProjectsLegs::class, ['ProjId' => 'ProjId'])->orderBy(['LegNo'=>SORT_ASC, 'StartDt'=>SORT_ASC]);
}

This first pull all the table columns for me to only use LocFrom. How could I better approach this?

samdark · March 2, 2021, 6:58pm

Read on “eager loading”: https://www.yiiframework.com/doc/guide/2.0/en/db-active-record#lazy-eager-loading

DBCreator · March 2, 2021, 7:24pm

Thank you, I will look into it immediately.