当前位置:欧洲房产网 >> 海外房产 >> 意大利资讯


物业状态



10.863 msSELECT f.*, ff.name AS upname FROM supe_categories f LEFT JOIN supe_categories ff ON ff.catid=f.upid WHERE f.catid='28'
Explain
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEfconstPRIMARYPRIMARY2const1-
24.369 msSELECT COUNT(*) FROM supe_houseitems i, supe_housemessage m WHERE i.itemid=m.itemid AND i.catid IN (28) AND 1
Explain
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEirefPRIMARY,catidcatid2const1Using index
1D:\wwwroot\tctd.cc\m.php
2D:\wwwroot\tctd.cc\common.php
3D:\wwwroot\tctd.cc\config.php
4D:\wwwroot\tctd.cc\function\common.func.php
5D:\wwwroot\tctd.cc\data\system\config.cache.php
6D:\wwwroot\tctd.cc\language\main.lang.php
7D:\wwwroot\tctd.cc\class\db_mysql.class.php
8D:\wwwroot\tctd.cc\data\system\group.cache.php
9D:\wwwroot\tctd.cc\data\system\cron.cache.php
10D:\wwwroot\tctd.cc\function\cron.func.php
11D:\wwwroot\tctd.cc\data\system\crons.cache.php
12D:\wwwroot\tctd.cc\function\model.func.php
13D:\wwwroot\tctd.cc\cache\model\model_house.cache.php
14D:\wwwroot\tctd.cc\class\tree.class.php
15D:\wwwroot\tctd.cc\cache\tpl\tpl_mthemes_default_category.html.php.php
16D:\wwwroot\tctd.cc\cache\tpl\tpl_new_site_header.php
17D:\wwwroot\tctd.cc\cache\tpl\tpl_new_site_footer.php
18D:\wwwroot\tctd.cc\include\debug.inc.php
1$_REQUEST['name']house
2$_REQUEST['mo_catid']28