基本文件流程错误 SQL 调试

/app/www/index.php ( 0.80 KB )
/app/www/ThinkPHP/ThinkPHP.php ( 1.71 KB )
/app/www/ThinkPHP/Common/runtime.php ( 9.73 KB )
/app/www/ThinkPHP/Common/common.php ( 26.72 KB )
/app/www/ThinkPHP/Lib/Core/Think.class.php ( 11.45 KB )
/app/www/ThinkPHP/Lib/Core/ThinkException.class.php ( 0.78 KB )
/app/www/ThinkPHP/Lib/Core/Behavior.class.php ( 1.71 KB )
/app/www/ThinkPHP/Conf/alias.php ( 1.15 KB )
/app/www/ThinkPHP/Conf/convention.php ( 9.17 KB )
/app/www/Home/Conf/config.php ( 0.70 KB )
/app/www/config.php ( 2.88 KB )
/app/www/setting.config.php ( 0.21 KB )
/app/www/ThinkPHP/Lang/zh-cn.php ( 2.59 KB )
/app/www/ThinkPHP/Conf/tags.php ( 1.47 KB )
/app/www/ThinkPHP/Common/functions.php ( 234.30 KB )
/app/www/ThinkPHP/Lib/Core/Log.class.php ( 4.70 KB )
/app/www/ThinkPHP/Lib/Core/Dispatcher.class.php ( 12.30 KB )
/app/www/ThinkPHP/Lib/Core/App.class.php ( 12.44 KB )
/app/www/ThinkPHP/Lib/Core/Action.class.php ( 17.46 KB )
/app/www/ThinkPHP/Lib/Core/View.class.php ( 8.18 KB )
/app/www/Home/Common/common.php ( 15.10 KB )
/app/www/ThinkPHP/Conf/debug.php ( 1.73 KB )
/app/www/ThinkPHP/Lib/Behavior/CheckRouteBehavior.class.php ( 9.01 KB )
/app/www/ThinkPHP/Lib/Behavior/ReadHtmlCacheBehavior.class.php ( 5.48 KB )
/app/www/Home/Lib/Action/ShopAction.class.php ( 57.44 KB )
/app/www/Home/Lib/Action/BaseAction.class.php ( 47.95 KB )
/app/www/ThinkPHP/Lib/Core/Model.class.php ( 54.29 KB )
/app/www/ThinkPHP/Lib/Core/Db.class.php ( 33.49 KB )
/app/www/ThinkPHP/Lib/Driver/Db/DbMysql.class.php ( 10.93 KB )
/app/www/Admin/Lib/Model/ChannelModel.class.php ( 9.62 KB )
/app/www/Shop/Lib/Model/ShopModel.class.php ( 4.33 KB )
/app/www/Shop/Lib/Model/Shop_goodsModel.class.php ( 13.55 KB )
/app/www/Shop/Lib/Model/Auction_goodsModel.class.php ( 1.90 KB )
/app/www/ThinkPHP/Lib/Behavior/ParseTemplateBehavior.class.php ( 6.16 KB )
/app/www/ThinkPHP/Lib/Template/ThinkTemplate.class.php ( 28.41 KB )
/app/www/ThinkPHP/Lib/Driver/TagLib/TagLibCx.class.php ( 24.35 KB )
/app/www/ThinkPHP/Lib/Template/TagLib.class.php ( 8.55 KB )
/app/www/Runtime/Home/Cache/80eda34f88a57544b7c094bc1219adb2.php ( 508.86 KB )
/app/www/ThinkPHP/Lib/Behavior/ContentReplaceBehavior.class.php ( 2.29 KB )
/app/www/ThinkPHP/Lib/Behavior/TokenBuildBehavior.class.php ( 2.51 KB )
/app/www/ThinkPHP/Lib/Behavior/WriteHtmlCacheBehavior.class.php ( 1.41 KB )
/app/www/ThinkPHP/Lib/Behavior/ShowRuntimeBehavior.class.php ( 3.59 KB )
/app/www/ThinkPHP/Lib/Behavior/ShowPageTraceBehavior.class.php ( 5.52 KB )

1064:You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'and id<>106291 and stock>0 and is_added=1 and is_del=0 and iskill=0 ) ORDER BY s' at line 1 [ SQL语句 ] : SELECT `id`,`sid`,`name`,`thumb160`,`sales`,`price`,`sprice`,`star` FROM `qt_shop_goods` WHERE ( typeid= and id<>106291 and stock>0 and is_added=1 and is_del=0 and iskill=0 ) ORDER BY sales desc LIMIT 0,8
1064:You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'and id<>106291 and stock>0 and is_added=1 and is_del=0 and iskill=0 ) ORDER BY s' at line 1 [ SQL语句 ] : SELECT `id`,`sid`,`name`,`thumb160`,`sales`,`price`,`sprice`,`star` FROM `qt_shop_goods` WHERE ( sid=200258 AND typeid= and id<>106291 and stock>0 and is_added=1 and is_del=0 and iskill=0 ) ORDER BY sales desc LIMIT 0,8
[8] Undefined variable: HTTP_SERVER_VARS /app/www/ThinkPHP/Common/functions.php 第 5655 行.
[8] Undefined variable: HTTP_SERVER_VARS /app/www/ThinkPHP/Common/functions.php 第 5651 行.
[8] Undefined variable: HTTP_SERVER_VARS /app/www/ThinkPHP/Common/functions.php 第 5653 行.
[8] Undefined variable: HTTP_SERVER_VARS /app/www/ThinkPHP/Common/functions.php 第 5655 行.
[8] Undefined variable: HTTP_SERVER_VARS /app/www/ThinkPHP/Common/functions.php 第 5651 行.
[8] Undefined variable: HTTP_SERVER_VARS /app/www/ThinkPHP/Common/functions.php 第 5653 行.
[8] Undefined variable: HTTP_SERVER_VARS /app/www/ThinkPHP/Common/functions.php 第 5655 行.
[8] Undefined variable: HTTP_SERVER_VARS /app/www/ThinkPHP/Common/functions.php 第 5651 行.
[8] Undefined variable: HTTP_SERVER_VARS /app/www/ThinkPHP/Common/functions.php 第 5653 行.
[8] Undefined variable: HTTP_SERVER_VARS /app/www/ThinkPHP/Common/functions.php 第 5655 行.
[8] Undefined variable: HTTP_SERVER_VARS /app/www/ThinkPHP/Common/functions.php 第 5651 行.
[8] Undefined variable: HTTP_SERVER_VARS /app/www/ThinkPHP/Common/functions.php 第 5653 行.
[8] Undefined variable: HTTP_SERVER_VARS /app/www/ThinkPHP/Common/functions.php 第 5655 行.
[8] Undefined variable: HTTP_SERVER_VARS /app/www/ThinkPHP/Common/functions.php 第 5651 行.
[8] Undefined variable: HTTP_SERVER_VARS /app/www/ThinkPHP/Common/functions.php 第 5653 行.
[8] Undefined variable: HTTP_SERVER_VARS /app/www/ThinkPHP/Common/functions.php 第 5655 行.
[8] Undefined variable: HTTP_SERVER_VARS /app/www/ThinkPHP/Common/functions.php 第 5651 行.
[8] Undefined variable: HTTP_SERVER_VARS /app/www/ThinkPHP/Common/functions.php 第 5653 行.
[8] Undefined variable: HTTP_SERVER_VARS /app/www/ThinkPHP/Common/functions.php 第 5655 行.
[8] Undefined index: uid /app/www/Home/Lib/Action/BaseAction.class.php 第 53 行.
[8] Undefined variable: ch /app/www/Home/Lib/Action/BaseAction.class.php 第 305 行.
[8] Undefined variable: ch /app/www/Home/Lib/Action/BaseAction.class.php 第 306 行.
[8] Undefined variable: ch /app/www/Home/Lib/Action/BaseAction.class.php 第 307 行.
[8] Undefined variable: ch /app/www/Home/Lib/Action/BaseAction.class.php 第 308 行.
[8] Undefined variable: ch /app/www/Home/Lib/Action/BaseAction.class.php 第 309 行.
[8] Undefined variable: ch /app/www/Home/Lib/Action/BaseAction.class.php 第 310 行.
[8] Undefined variable: ch /app/www/Home/Lib/Action/BaseAction.class.php 第 311 行.
[8] Undefined index: redirect_quan_id /app/www/Home/Lib/Action/ShopAction.class.php 第 423 行.
[8] Undefined index: id /app/www/Home/Lib/Action/ShopAction.class.php 第 693 行.
[8] Undefined variable: promoInfo /app/www/Home/Lib/Action/ShopAction.class.php 第 723 行.
[8] Undefined variable: total /app/www/Home/Lib/Action/ShopAction.class.php 第 738 行.
[8] Undefined variable: stotal /app/www/Home/Lib/Action/ShopAction.class.php 第 739 行.
[2] Invalid argument supplied for foreach() /app/www/Home/Lib/Action/ShopAction.class.php 第 779 行.

SHOW COLUMNS FROM `qt_weather` [ RunTime:0.000536s ]
SELECT * FROM `qt_weather` ORDER BY id desc LIMIT 1 [ RunTime:0.000318s ]
SHOW COLUMNS FROM `qt_adv_not_key` [ RunTime:0.000429s ]
SELECT * FROM `qt_adv_not_key` WHERE ( is_out=0 ) ORDER BY rand() LIMIT 1 [ RunTime:0.000315s ]
SHOW COLUMNS FROM `qt_shop_domain` [ RunTime:0.000384s ]
SELECT `sid`,`domain` FROM `qt_shop_domain` WHERE ( domain='zccnsc.com' AND status=1 ) LIMIT 1 [ RunTime:0.000277s ]
SHOW COLUMNS FROM `qt_channel` [ RunTime:0.002473s ]
SHOW COLUMNS FROM `qt_user_message` [ RunTime:0.000461s ]
SELECT COUNT(*) AS tp_count FROM `qt_user_message` as um inner join qt_message m on um.mid=m.id WHERE ( m.status=0 and um.status=0 and um.toid=0 ) LIMIT 1 [ RunTime:0.000316s ]
SHOW COLUMNS FROM `qt_site` [ RunTime:0.000382s ]
SELECT `id` FROM `qt_site` WHERE ( code="good" ) LIMIT 1 [ RunTime:0.000234s ]
SHOW COLUMNS FROM `qt_keywords` [ RunTime:0.000821s ]
SELECT DISTINCT `keywords` FROM `qt_keywords` ORDER BY count desc LIMIT 6 [ RunTime:0.001249s ]
SHOW COLUMNS FROM `qt_shop` [ RunTime:0.000792s ]
SHOW COLUMNS FROM `qt_shop_goods` [ RunTime:0.001004s ]
SELECT qt_shop_goods.*,glabel.img as goods_label_img,s.delivery_setting FROM `qt_shop_goods` LEFT JOIN qt_shop s on s.id=qt_shop_goods.sid LEFT JOIN qt_goods_label as glabel on glabel.id=qt_shop_goods.label_id WHERE ( qt_shop_goods.id=106291 ) LIMIT 1 [ RunTime:0.000692s ]
SELECT s.`id`,s.`name`,s.`entry`,s.`password`,s.`bid`,s.`sort`,s.`logo`,s.`start`,s.`stop`,s.`official`,s.`telphone`,s.`diamond`,s.`gold`,s.`silver`,s.`special`,s.`drebate`,s.`grebate`,s.`srebate`,s.`rebate`,s.`channel`,s.`lanmu`,s.`typeid`,s.`qq`,s.`email`,s.`x`,s.`y`,s.`country`,s.`city`,s.`area`,s.`address`,s.`is_del`,s.`is_hide`,s.`rest_uid`,s.`s_type`,s.`time`,s.`posid`,s.`posid_time`,s.`status`,s.`liaison`,s.`shipping_scope`,s.`score`,s.`dtuid`,s.`delivery_remark`,s.`delivery_setting`,s.`clear_type`,s.`delivery_type`,s.`code`,s.`logo_small`,s.`home_tmpl`,s.`list_tmpl`,s.`head_tmpl`,s.`foot_tmpl`,s.`home_tmpl_ver`,s.`list_tmpl_ver`,s.`head_tmpl_ver`,s.`foot_tmpl_ver`,s.`sign_tmpl`,s.`menu_tmpl`,s.`sign_tmpl_ver`,s.`menu_tmpl_ver`,s.`quan_tmpl`,s.`activity_tmpl`,s.`quan_tmpl_ver`,s.`activity_tmpl_ver`,s.`about_tmpl`,s.`page_tmpl`,s.`about_tmpl_ver`,s.`page_tmpl_ver`,s.`is_forbidden`,s.`login_trycount`,s.`common_style`,s.`common_script`,s.`low_amount`,s.`pub_inc` FROM `qt_shop` AS s INNER JOIN qt_businese AS b ON b.id=s.bid WHERE ( s.id=200258 AND s.is_hide=1 AND s.is_del=0 AND b.is_del=0 AND b.is_hide=1 ) LIMIT 1 [ RunTime:0.000511s ]
SELECT `sid`,`domain` FROM `qt_shop_domain` WHERE ( sid='200258' AND status=1 ) LIMIT 1 [ RunTime:0.000234s ]
SHOW COLUMNS FROM `qt_auction_goods` [ RunTime:0.001326s ]
SHOW COLUMNS FROM `qt_shop_goods` [ RunTime:0.000994s ]
SELECT * FROM `qt_shop_goods` WHERE ( `id` = 106291 ) LIMIT 1 [ RunTime:0.000514s ]
SHOW COLUMNS FROM `qt_channel` [ RunTime:0.000426s ]
SELECT `tips` FROM `qt_channel` WHERE ( id=7473 ) LIMIT 1 [ RunTime:0.000239s ]
SHOW COLUMNS FROM `qt_channel` [ RunTime:0.000388s ]
SELECT `id`,`name`,`type` FROM `qt_channel` WHERE ( id IN (7473,4) ) ORDER BY type ASC [ RunTime:0.000270s ]
SELECT 0 AS gid,p.*,r.id AS rid,r.amount,r.reduce FROM qt_sales_promotion p INNER JOIN qt_sales_promotion_rule r ON r.pid=p.id WHERE p.sid=200258 AND p.status=0 AND p.scope=0 AND p.starttime<=1779574864 AND p.endtime>=1779574864 AND p.id NOT IN ( SELECT p.id FROM qt_sales_promotion p LEFT JOIN qt_sales_promotion_goods g ON g.pid=p.id WHERE p.sid=200258 AND p.type=0 AND p.status=0 AND p.scope=0 AND p.starttime<=1779574864 AND p.endtime>=1779574864 AND g.gid=106291 ) UNION ALL SELECT g.gid,p.*,r.id AS rid,r.amount,r.reduce FROM qt_sales_promotion p INNER JOIN qt_sales_promotion_rule r ON r.pid=p.id INNER JOIN qt_sales_promotion_goods g ON g.pid=p.id WHERE p.sid=200258 AND p.type=0 AND p.status=0 AND g.gid=106291 AND p.scope=1 AND p.starttime<=1779574864 AND p.endtime>=1779574864 UNION ALL SELECT 0 as gid,qt_sales_promotion.*,0 AS rid,0 AS amount,0 AS reduce FROM qt_sales_promotion WHERE sid=200258 AND type=2 AND status=0 AND scope = 0 AND starttime<=1779574864 AND endtime>=1779574864 AND id NOT IN ( SELECT p.id FROM qt_sales_promotion p LEFT JOIN qt_sales_promotion_goods g ON g.pid=p.id WHERE p.sid=200258 AND p.type=2 AND p.status=0 AND p.scope=0 AND p.starttime<=1779574864 AND p.endtime>=1779574864 AND g.gid=106291 ) UNION ALL SELECT g.gid,p.*,0 AS rid,0 AS amount,0 AS reduce FROM qt_sales_promotion p INNER JOIN qt_sales_promotion_goods g ON g.pid=p.id WHERE p.sid=200258 AND p.type=2 AND p.scope = 1 AND p.status=0 AND g.gid=106291 AND p.starttime<=1779574864 AND p.endtime>=1779574864 [ RunTime:0.000725s ]
SHOW COLUMNS FROM `qt_shop_goods_suits` [ RunTime:0.000362s ]
SELECT s.type,s.price AS suit_price,sg.id,sg.sid,sg.name,singlesprice as sprice,singleprice as price,`thumb160` FROM `qt_shop_goods_suits` AS s INNER JOIN qt_shop_goods sg ON sg.id=s.sid WHERE ( s.gid=106291 ) [ RunTime:0.000290s ]
SHOW COLUMNS FROM `qt_sales_promotion` [ RunTime:0.000369s ]
SELECT DISTINCT s.id FROM `qt_sales_promotion` AS s INNER JOIN qt_sales_promotion_goods pg ON pg.pid=s.id WHERE ( s.type=3 AND pg.gid=106291 AND s.starttime<=1779574864 AND s.endtime>=1779574864 AND s.status=0 ) [ RunTime:0.000320s ]
SHOW COLUMNS FROM `qt_shop_goods` [ RunTime:0.000890s ]
SELECT `id`,`sid`,`name`,`thumb160`,`sales`,`price`,`sprice`,`star` FROM `qt_shop_goods` WHERE ( typeid= and id<>106291 and stock>0 and is_added=1 and is_del=0 and iskill=0 ) ORDER BY sales desc LIMIT 0,8 [ RunTime:0.000147s ]
SELECT `id`,`sid`,`name`,`thumb160`,`sales`,`price`,`sprice`,`star` FROM `qt_shop_goods` WHERE ( sid=200258 AND typeid= and id<>106291 and stock>0 and is_added=1 and is_del=0 and iskill=0 ) ORDER BY sales desc LIMIT 0,8 [ RunTime:0.000099s ]
SHOW COLUMNS FROM `qt_goods_eval` [ RunTime:0.000420s ]
SELECT COUNT(*) AS tp_count FROM `qt_goods_eval` WHERE ( gid=106291 and type=1 and is_disabled=0 ) LIMIT 1 [ RunTime:0.000251s ]