标题：*
140 字

TAG标签：（用空格隔开）
30 字

恢复历史版本：

HTML转MD HTML转MD2

header(&#39;Location: <a href="http://www.example.com/'">http://www.example.com/&#39;</a>);&nbsp;// Date in the past <code>header(&quot;Expires: Mon, 26 Jul 1997 05:00:00 GMT&quot;); header(&quot;Cache-Control: no-cache&quot;); header(&quot;Pragma: no-cache&quot;);</code>&nbsp;&nbsp; header(&quot;Content-type: text/html; charset=utf-8&quot;); <pre class="brush:php;toolbar:false">$j=1000;	
g(&#39;s1&#39;);		
echo&nbsp;&#39;来自数据库:&#39;;
$db&nbsp;=&nbsp;new&nbsp;PDO(&#39;mysql:host=127.0.0.1;dbname=shua_net&#39;,&nbsp;&#39;qqtxt&#39;,&nbsp;&#39;zhh1981zhh&#39;);
g(&#39;s2&#39;);
for($i=0;$iprepare(&#39;update&nbsp;&#39;.C(&#39;DB_PREFIX&#39;).&#39;admin&nbsp;set&nbsp;username=&quot;admin&#39;.$i.&#39;&quot;&nbsp;where&nbsp;admin_id=3&#39;);$sth-&gt;execute();$sth=$db-&gt;prepare(&#39;select&nbsp;username&nbsp;from&nbsp;&#39;.C(&#39;DB_PREFIX&#39;).&#39;admin&nbsp;where&nbsp;admin_id=3&#39;);$sth-&gt;execute();$a=$sth-&gt;fetchColumn();}
echo&nbsp;&#39;初始化：&#39;.g(&#39;s1&#39;,&#39;s2&#39;,8).&#39;&nbsp;执行：&#39;.g(&#39;s2&#39;,&#39;s3&#39;,8);

g(&#39;ss1&#39;);
echo&nbsp;&#39;
来自文件:&#39;;
for($i=0;$iget(&#39;phone&#39;);}
echo&nbsp;&#39;初始化：&#39;.g(&#39;sss1&#39;,&#39;sss2&#39;,8).&#39;&nbsp;执行：&#39;.g(&#39;sss2&#39;,&#39;sss3&#39;,8);
echo&nbsp;&quot;
$a
$b
$c
&quot;;
return;

结果
来自数据库:初始化：0.00124907&nbsp;执行：3.03205800
来自文件:0.73245597
来自redis初始化：0.00031805&nbsp;执行：0.13012195
admin999
admin999
admin999

用写读来破缓冲，都是1000次，原生redis完胜

统计某商家全部店任务缓冲&nbsp;SELECT&nbsp;sum(total_num),sum(`undo_num`),sum(`doing_num`),sum(`back_num`),sum(`cmt_num`),sum(`sure_num`),sum(`finish_num`),sum(`withdraw_num`)&nbsp;FROM&nbsp;`je_task`&nbsp;where&nbsp;uid=15929&nbsp;and&nbsp;pay_status=1&nbsp;and&nbsp;withdraw_num=0
找某商家全部店SELECT&nbsp;count(*)&nbsp;FROM&nbsp;`je_task_item`&nbsp;where&nbsp;uid=15929&nbsp;and&nbsp;status&lt;3

找一个tiid生成了两个订单以上&nbsp;&nbsp;select&nbsp;*&nbsp;from&nbsp;(SELECT&nbsp;toid,add_time,tiid,count(*)&nbsp;as&nbsp;c&nbsp;FROM&nbsp;`je_task_order`&nbsp;WHERE&nbsp;status1
最多返款&nbsp;select&nbsp;shop_uid,&nbsp;count(*)&nbsp;as&nbsp;num&nbsp;from&nbsp;je_task_order&nbsp;where&nbsp;pay_status=0&nbsp;and&nbsp;status&lt;5&nbsp;group&nbsp;by&nbsp;shop_uid&nbsp;order&nbsp;by&nbsp;num&nbsp;desc
找最多订单的&nbsp;&nbsp;select&nbsp;shop_uid,&nbsp;count(*)&nbsp;as&nbsp;num&nbsp;from&nbsp;je_task_order&nbsp;where&nbsp;pay_status=1&nbsp;and&nbsp;status1538841600&nbsp;and&nbsp;status1536559626&nbsp;and&nbsp;status=0&nbsp;order&nbsp;by&nbsp;start_time</pre> /etc/hosts文件修改后如何生效 sudo /etc/init.d/networking restart 开机挂载sudo dedit /etc/fstab 在末行回车添加类似，使用sudo mount -a对该配置文件生效。如果有问题会报错，根据问题再修改即可/dev/sdb9&nbsp; &nbsp; /media/yoqu/mylinux&nbsp; &nbsp; &nbsp; &nbsp; ext4&nbsp; &nbsp; defaults&nbsp; &nbsp; &nbsp; &nbsp; 1&nbsp; &nbsp; &nbsp; &nbsp;2 sudo chmod -R 755 asudo chmod -R 755 datasudo chmod -R 755 dedesudo chmod 755 .htaccesssudo chmod -R 755 imagessudo chmod -R 755 includesudo chmod&nbsp; 755 index.htmlsudo chmod 755 index.phpsudo chmod -R 755 installsudo chmod -R 755 logreportsudo chmod -R 755 plussudo chmod 755 README.mdsudo chmod 755 robots.txtsudo chmod -R 755 specialsudo chmod 755 tags.phpsudo chmod -R 755 templetssudo chmod -R 755 uploadssudo chmod 755 zip.php sudo chown -R www:www asudo chown -R www:www datasudo chown -R www:www dedesudo chown www:www .htaccesssudo chown -R www:www imagessudo chown -R www:www includesudo chown www:www index.htmlsudo chown www:www index.phpsudo chown -R www:www installsudo chown -R www:www logreportsudo chown -R www:www plussudo chown www:www README.mdsudo chown www:www robots.txtsudo chown -R www:www specialsudo chown www:www tags.phpsudo chown -R www:www templetssudo chown -R www:www uploadssudo chown www:www zip.php