PHP N+1问题

一个小菜鸟x

已于 2022-04-12 11:23:47 修改

阅读量218

点赞数

分类专栏： php 文章标签： php

于 2021-09-29 18:04:34 首次发布

本文链接：https://blog.csdn.net/qq_44718170/article/details/120553650

版权

php 专栏收录该内容

9 篇文章 0 订阅

订阅专栏

<?php
include '../mysql.php';

// N+1问题
// customer_rec表 customer_id 关联 customer表

$rec = $DB->query("select * from `customer_rec`");

$rec_id = array();
$cid = array();
$rec_data = array();

while ($recs = $DB->fetch_assoc($rec)){
    if (!in_array($recs['customer_id'],$rec_id)){
        $rec_id[] = $recs['customer_id'];
        $rec_data[$recs['customer_id']] = $recs;
    }
}

$c =  $DB->query("select * from `customer` where id in (".implode(',',$rec_id).")");
while ($rec = $DB->fetch_assoc($c)){
    $cid[$rec['id']] = $rec;
}

foreach ($rec_data as $data){
//    $rec_data[$data['customer_id']]['client_name'] = $cid[$data['customer_id']];  
    $rec_data[$data['customer_id']]['client_name'] = $cid[$data['customer_id']]['client_name'];
}

print_r($rec_data);