我正在嘗試優(yōu)化我對 Cakephp 中帶有分頁結果的頁面的查詢，因此我希望使用 PHP 函數(shù)計算準確的時間microtime()。這樣，我將更好地了解執(zhí)行特定請求需要多少時間。此外，我正在嘗試通過 Cache::read 和 Cache::write 緩存分頁結果，它們都是 Cakephp 2.x 中關于緩存方法的內部 Cakephp 函數(shù)。因此，此時我所擁有的是：我在想，為了準確計算整個游戲中時光倒流，我應該將其余代碼放在 while 循環(huán)中嗎？任何幫助將不勝感激。謝謝 $start = microtime(true); while ($start) { $this->paginate = $options; $resultado = $this->paginate('Doctor'); } $time_elapsed_secs = microtime(true) - $start; pr($time_elapsed_secs); foreach ($resultado AS $k => $r) { $hasProduct = Cache::read(__('thedoctors::') . 'hasProduct_by_dr_' . PAIS . '_' . $r['Doctor']['id'], '1day'); if (empty($hasProduct)) { $hasProduct = $this->DoctorsProduct->find('all', [ 'recursive' => -1, 'fields' => ['Product.*', 'DoctorsProduct.*'], 'joins' => [ ['table' => 'td_products', 'alias' => 'Product', 'type' => 'INNER', 'conditions' => [ 'Product.id = DoctorsProduct.id_product' ] ] ], 'conditions' => [ 'id_doctor' => $r['Doctor']['id'], 'DoctorsProduct.status' => 1 ], 'order' => [ 'Product.id ASC', ] ]); Cache::write(__('thedoctors::') . 'hasProduct_by_dr_' . PAIS, $hasProduct, '1day'); } $resultado[$k]['Products'] = $hasProduct; $resultado[$k]['Article'] = 0; }
1 回答
神不在的星期二
TA貢獻1963條經驗 獲得超6個贊
好吧，我發(fā)布的方法確實是錯誤的，可能會無限循環(huán)。最后，我發(fā)現(xiàn)解決這個問題的方法是將 microtime 函數(shù)放在最開始。我將一個新變量聲明為$time.
在此之后，我只是用之前聲明的時間減去實際的微時間。奇跡般有效。
$time = microtime( TRUE );
foreach ($resultado AS $k => $r) {
$hasProduct = Cache::read(__('thedoctors::') . 'hasProduct_by_dr_' . PAIS . '_' . $r['Doctor']['id'], '1day');
if (empty($hasProduct)) {
$hasProduct = $this->DoctorsProduct->find('all', [
'fields' => ['Product.*', 'DoctorsProduct.*'],
'joins' => [
['table' => 'td_products',
'alias' => 'Product',
'type' => 'INNER',
'conditions' => [
'Product.id = DoctorsProduct.id_product'
]
],
],
'conditions' => [
'id_doctor' => $r['Doctor']['id'],
'DoctorsProduct.status' => 1
],
'order' => [
'Product.id ASC',
]
]);
Cache::write(__('thedoctors::') . 'hasProduct_by_dr_' . PAIS,
$hasProduct, '1day');
}
$resultado[$k]['Products'] = $hasProduct;
$resultado[$k]['Article'] = 0;
}
$time = microtime( TRUE ) - $time;
echo $time;
die("123");
- 1 回答
- 0 關注
- 115 瀏覽
添加回答
舉報
0/150
提交
取消