0.00031 |
SELECT id, search_key, search_string FROM searches WHERE user_id="" ORDER BY id DESC |
0.00039 |
SELECT * FROM posts_comments WHERE post_id="1453029" ORDER BY id ASC |
0.00027 |
SELECT * FROM posts_comments WHERE post_id="1453331" ORDER BY id ASC |
0.00032 |
SELECT * FROM posts_comments WHERE post_id="1453965" ORDER BY id ASC |
0.00031 |
SELECT * FROM posts_comments WHERE post_id="1454614" ORDER BY id ASC |
0.00028 |
SELECT id, type, data FROM posts_attachments WHERE post_id="1456609" LIMIT 1 |
0.00041 |
SELECT * FROM posts_comments WHERE post_id="1456699" ORDER BY id ASC |
0.00040 |
SELECT * FROM posts_comments WHERE post_id="1457829" ORDER BY id ASC |
0.00036 |
SELECT * FROM posts_comments WHERE post_id="1458209" ORDER BY id ASC |
0.00025 |
SELECT id, type, data FROM posts_attachments WHERE post_id="1458209" LIMIT 1 |
0.00034 |
SELECT * FROM posts_comments WHERE post_id="1459272" ORDER BY id ASC |
0.00028 |
SELECT id, type, data FROM posts_attachments WHERE post_id="1459272" LIMIT 1 |
0.00022 |
SELECT user_id FROM posts_reshares WHERE post_id="1460084" ORDER BY id DESC LIMIT 1 |
0.00039 |
SELECT * FROM posts_comments WHERE post_id="1460084" ORDER BY id ASC |
0.00021 |
SELECT user_id FROM posts_comments_mentioned WHERE comment_id="133402" LIMIT 1 |
0.00035 |
SELECT * FROM posts_comments WHERE post_id="1464210" ORDER BY id ASC |
0.00029 |
SELECT id, type, data FROM posts_attachments WHERE post_id="1464210" LIMIT 1 |
0.00026 |
SELECT * FROM posts_comments WHERE post_id="1464215" ORDER BY id ASC |
0.00046 |
SELECT * FROM posts_comments WHERE post_id="1464891" ORDER BY id ASC |
0.03169 |
SELECT *, "public" AS `type` FROM posts WHERE (api_id=2 OR user_id<>0) AND (message LIKE "%WEB%" OR id IN(1291345, 1292955, 1294464, 1293645, 1293645, 1320882, 1324139, 1360589, 1330297, 1332077, 1339675, 1343336, 1350411, 1352004, 1345623, 1382841, 1373657, 1379989, 1380746, 1381508, 1381586, 1380746, 1391068, 1380746, 1388451, 1393649, 1394351, 1471742, 1471742, 1395672, 1398556, 1399787, 1454614, 1403755, 1405896, 1405911, 1405315, 1410892, 1411835, 1444247, 1416411, 1416513, 1418344, 1418868, 1420220, 1421748, 1421807, 1422785, 1422785, 1424444, 1424444, 1426073, 1470619, 1428894, 1457829, 1429659, 1431442, 1433991, 1434645, 1437457, 1438597, 1441930, 1446532, 1448919, 1449434, 1450455, 1453029, 1453965, 1456699, 1459272, 1464210, 1464215, 1465583, 1464891, 1464891, 1464891, 1466194, 1466396, 1470430, 1468296, 1468345, 1469566)) AND group_id NOT IN(132, 221, 240, 343, 358, 365) ORDER BY id DESC LIMIT 15, 15 |
0.50151 |
SELECT COUNT(id) FROM posts WHERE (api_id=2 OR user_id<>0) AND (message LIKE "%WEB%" OR id IN(1291345, 1292955, 1294464, 1293645, 1293645, 1320882, 1324139, 1360589, 1330297, 1332077, 1339675, 1343336, 1350411, 1352004, 1345623, 1382841, 1373657, 1379989, 1380746, 1381508, 1381586, 1380746, 1391068, 1380746, 1388451, 1393649, 1394351, 1471742, 1471742, 1395672, 1398556, 1399787, 1454614, 1403755, 1405896, 1405911, 1405315, 1410892, 1411835, 1444247, 1416411, 1416513, 1418344, 1418868, 1420220, 1421748, 1421807, 1422785, 1422785, 1424444, 1424444, 1426073, 1470619, 1428894, 1457829, 1429659, 1431442, 1433991, 1434645, 1437457, 1438597, 1441930, 1446532, 1448919, 1449434, 1450455, 1453029, 1453965, 1456699, 1459272, 1464210, 1464215, 1465583, 1464891, 1464891, 1464891, 1466194, 1466396, 1470430, 1468296, 1468345, 1469566)) AND group_id NOT IN(132, 221, 240, 343, 358, 365) |
0.00044 |
SELECT id FROM groups WHERE is_public=0 |
0.07548 |
SELECT post_id FROM posts_comments WHERE message LIKE "%WEB%" |
0.00023 |
SELECT id FROM searches WHERE user_id="" AND search_key="313b1261a5842fcb514bc8bf99ed6044" LIMIT 1 |
0.00024 |
SELECT FROM_UNIXTIME(date,"%Y") FROM posts ORDER BY id ASC LIMIT 1 |
0.00029 |
SELECT * FROM settings |
0.00115 |
CONNECT 49.12.223.183:9906 |
0.00010 |
GET |
f5dad|1000|n:1,post_app:1 |
object |
0.00014 |
GET |
f5dad|1000|n:1,userid:2408 |
object |
0.00009 |
GET |
f5dad|1000|n:1,userid:7690 |
object |
0.00011 |
GET |
f5dad|1000|n:1,userid:936 |
object |
0.00014 |
GET |
f5dad|1000|n:1,userid:15094 |
object |
0.00012 |
GET |
f5dad|1000|n:1,userid:10647 |
object |
0.00011 |
GET |
f5dad|1000|n:1,userid:6580 |
object |
0.00012 |
GET |
f5dad|1000|n:1,userid:8479 |
object |
0.00012 |
GET |
f5dad|1000|n:1,userid:1343 |
object |
0.00009 |
GET |
f5dad|1000|n:1,userid:153 |
object |
0.00010 |
GET |
f5dad|1000|n:1,userid:38 |
object |
0.00013 |
GET |
f5dad|1000|n:1,userid:383 |
object |
0.00012 |
GET |
f5dad|1000|n:1,userid:5794 |
object |
0.00012 |
GET |
f5dad|1000|n:1,userid:3430 |
object |
0.00008 |
GET |
f5dad|1000|n:1,userid:6354 |
object |
0.00009 |
GET |
f5dad|1000|n:1,userid:8313 |
object |
0.00011 |
GET |
f5dad|1000|n:1,userid:2628 |
object |
0.00015 |
GET |
f5dad|1000|n:1,userid:16279 |
object |
0.00007 |
GET |
f5dad|1000|n:1,groupid:365 |
object |
0.00008 |
GET |
f5dad|1000|n:1,groupid:358 |
object |
0.00010 |
GET |
f5dad|1000|n:1,groupid:343 |
object |
0.00010 |
GET |
f5dad|1000|n:1,groupid:240 |
object |
0.00012 |
GET |
f5dad|1000|n:1,groupid:221 |
object |
0.00035 |
GET |
f5dad|1000|n:1,groupid:132 |
object |
0.00002 |
CONNECT |
172.20.0.6:11211 |
TRUE |
Apr 28 2015, 00:56Deprecated: preg_replace(): The /e modifier is deprecated, use preg_replace_callback instead in /var/www/html/system/classes/class_postcomment.php on line 102
и аз съм php-нещо-си и видях бахти simplicity-то тука http://www.w3schools.com/aspnet/showfile_c.as...ges_cs_003
вместо да пишеш sql завката можеш да напишеш linq which translates to this : db.Products.ToList() or db.Products.Where(x=> x.Name == "whatever".ToList()
Apr 28 2015, 09:45which makes things even more simpler
Apr 28 2015, 09:46Или просто Model::find(array( 'where' => array('x', 'y'))); (FuelPHP)
Apr 28 2015, 09:55ewww... ewww ... no ..
Apr 28 2015, 10:19