SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001978s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000505s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002540s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.133' ) [ RunTime:0.000351s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001844s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.003263s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (2475,2518,2568) AND `id` > 799 [ RunTime:0.016067s ]
SELECT `id`,`typeid`,`name`,`typestr`,`order_number`,`productnum` FROM `product_type` WHERE `id` IN (49,50,51,52,53) OR `typeid` IN (49,50,51,52,53) ORDER BY `order_number` ASC [ RunTime:0.008882s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002851s ]
SELECT * FROM `stock` WHERE `categoryid` IN (608,711,720,676,644,49,615,50,671,696,645,721,646,718,722,621,51,665,698,674,643,647,52,723,648,675,636,724,53,699,725,673,700,649,623,650,701,604,669,726,727,651,702,667,603,703,611,668,652,728,653,612,666,704,729,730,613,654,705,670,614,655,706,661,731,707,672,732,656,605,616,708,733,663,657,617,664,734,709,658,735,710,618,659,662,619,736,660,695,737,677,712,620,738,606,713,678,622,679,739,714,610,740,715,680,741,681,624,716,682,717,742,625,683,626,697,627,719,684,685,628,686,629,630,687,688,631,689,632,690,633,691,634,635,692,693,607,637,694,638,639,640,641,642,609) ORDER BY `id` DESC LIMIT 24 [ RunTime:0.006473s ]
SELECT `s`.`id`,s.partno name,`s`.`categoryid`,`s`.`imgurl`,s.minOrderPrice as marketPrice,`u`.`city` FROM `stock` `s` LEFT JOIN `user` `u` ON `u`.`id`=`s`.`userid` WHERE `s`.`categoryid` = '608' ORDER BY `s`.`id` DESC LIMIT 5 [ RunTime:0.003740s ]
SELECT `s`.`id`,s.partno name,`s`.`categoryid`,`s`.`imgurl`,s.minOrderPrice as marketPrice,`u`.`city` FROM `stock` `s` LEFT JOIN `user` `u` ON `u`.`id`=`s`.`userid` WHERE `s`.`categoryid` = '615' ORDER BY `s`.`id` DESC LIMIT 10 [ RunTime:0.002793s ]
SELECT `s`.`id`,s.partno name,`s`.`categoryid`,`s`.`imgurl`,s.minOrderPrice as marketPrice,`u`.`city` FROM `stock` `s` LEFT JOIN `user` `u` ON `u`.`id`=`s`.`userid` WHERE `s`.`categoryid` = '621' ORDER BY `s`.`id` DESC LIMIT 10 [ RunTime:0.001020s ]
SELECT `s`.`id`,s.partno name,`s`.`categoryid`,`s`.`imgurl`,s.minOrderPrice as marketPrice,`u`.`city` FROM `stock` `s` LEFT JOIN `user` `u` ON `u`.`id`=`s`.`userid` WHERE `s`.`categoryid` = '643' ORDER BY `s`.`id` DESC LIMIT 10 [ RunTime:0.004346s ]
SELECT `s`.`id`,s.partno name,`s`.`categoryid`,`s`.`imgurl`,s.minOrderPrice as marketPrice,`u`.`city` FROM `stock` `s` LEFT JOIN `user` `u` ON `u`.`id`=`s`.`userid` WHERE `s`.`categoryid` = '636' ORDER BY `s`.`id` DESC LIMIT 10 [ RunTime:0.000750s ]
SELECT `s`.`id`,s.partno name,`s`.`categoryid`,`s`.`imgurl`,s.minOrderPrice as marketPrice,`u`.`city` FROM `stock` `s` LEFT JOIN `user` `u` ON `u`.`id`=`s`.`userid` WHERE `s`.`categoryid` = '623' ORDER BY `s`.`id` DESC LIMIT 10 [ RunTime:0.008237s ]
SELECT `s`.`id`,s.partno name,`s`.`categoryid`,`s`.`imgurl`,s.minOrderPrice as marketPrice,`u`.`city` FROM `stock` `s` LEFT JOIN `user` `u` ON `u`.`id`=`s`.`userid` WHERE `s`.`categoryid` = '604' ORDER BY `s`.`id` DESC LIMIT 10 [ RunTime:0.001034s ]
SELECT `s`.`id`,s.partno name,`s`.`categoryid`,`s`.`imgurl`,s.minOrderPrice as marketPrice,`u`.`city` FROM `stock` `s` LEFT JOIN `user` `u` ON `u`.`id`=`s`.`userid` WHERE `s`.`categoryid` = '603' ORDER BY `s`.`id` DESC LIMIT 10 [ RunTime:0.000679s ]
SELECT `s`.`id`,s.partno name,`s`.`categoryid`,`s`.`imgurl`,s.minOrderPrice as marketPrice,`u`.`city` FROM `stock` `s` LEFT JOIN `user` `u` ON `u`.`id`=`s`.`userid` WHERE `s`.`categoryid` = '611' ORDER BY `s`.`id` DESC LIMIT 10 [ RunTime:0.000569s ]
SELECT `s`.`id`,s.partno name,`s`.`categoryid`,`s`.`imgurl`,s.minOrderPrice as marketPrice,`u`.`city` FROM `stock` `s` LEFT JOIN `user` `u` ON `u`.`id`=`s`.`userid` WHERE `s`.`categoryid` = '644' ORDER BY `s`.`id` DESC LIMIT 5 [ RunTime:0.000516s ]
SELECT `s`.`id`,s.partno name,`s`.`categoryid`,`s`.`imgurl`,s.minOrderPrice as marketPrice,`u`.`city` FROM `stock` `s` LEFT JOIN `user` `u` ON `u`.`id`=`s`.`userid` WHERE `s`.`categoryid` = '645' ORDER BY `s`.`id` DESC LIMIT 10 [ RunTime:0.002194s ]
SELECT `s`.`id`,s.partno name,`s`.`categoryid`,`s`.`imgurl`,s.minOrderPrice as marketPrice,`u`.`city` FROM `stock` `s` LEFT JOIN `user` `u` ON `u`.`id`=`s`.`userid` WHERE `s`.`categoryid` = '646' ORDER BY `s`.`id` DESC LIMIT 10 [ RunTime:0.000719s ]
SELECT `s`.`id`,s.partno name,`s`.`categoryid`,`s`.`imgurl`,s.minOrderPrice as marketPrice,`u`.`city` FROM `stock` `s` LEFT JOIN `user` `u` ON `u`.`id`=`s`.`userid` WHERE `s`.`categoryid` = '647' ORDER BY `s`.`id` DESC LIMIT 10 [ RunTime:0.001690s ]
SELECT `s`.`id`,s.partno name,`s`.`categoryid`,`s`.`imgurl`,s.minOrderPrice as marketPrice,`u`.`city` FROM `stock` `s` LEFT JOIN `user` `u` ON `u`.`id`=`s`.`userid` WHERE `s`.`categoryid` = '648' ORDER BY `s`.`id` DESC LIMIT 10 [ RunTime:0.003578s ]
SELECT `s`.`id`,s.partno name,`s`.`categoryid`,`s`.`imgurl`,s.minOrderPrice as marketPrice,`u`.`city` FROM `stock` `s` LEFT JOIN `user` `u` ON `u`.`id`=`s`.`userid` WHERE `s`.`categoryid` = '649' ORDER BY `s`.`id` DESC LIMIT 10 [ RunTime:0.001295s ]
SELECT `s`.`id`,s.partno name,`s`.`categoryid`,`s`.`imgurl`,s.minOrderPrice as marketPrice,`u`.`city` FROM `stock` `s` LEFT JOIN `user` `u` ON `u`.`id`=`s`.`userid` WHERE `s`.`categoryid` = '650' ORDER BY `s`.`id` DESC LIMIT 10 [ RunTime:0.000511s ]
SELECT `s`.`id`,s.partno name,`s`.`categoryid`,`s`.`imgurl`,s.minOrderPrice as marketPrice,`u`.`city` FROM `stock` `s` LEFT JOIN `user` `u` ON `u`.`id`=`s`.`userid` WHERE `s`.`categoryid` = '651' ORDER BY `s`.`id` DESC LIMIT 10 [ RunTime:0.000522s ]
SELECT `s`.`id`,s.partno name,`s`.`categoryid`,`s`.`imgurl`,s.minOrderPrice as marketPrice,`u`.`city` FROM `stock` `s` LEFT JOIN `user` `u` ON `u`.`id`=`s`.`userid` WHERE `s`.`categoryid` = '652' ORDER BY `s`.`id` DESC LIMIT 10 [ RunTime:0.000469s ]
SELECT `s`.`id`,s.partno name,`s`.`categoryid`,`s`.`imgurl`,s.minOrderPrice as marketPrice,`u`.`city` FROM `stock` `s` LEFT JOIN `user` `u` ON `u`.`id`=`s`.`userid` WHERE `s`.`categoryid` = '676' ORDER BY `s`.`id` DESC LIMIT 5 [ RunTime:0.001624s ]
SELECT `s`.`id`,s.partno name,`s`.`categoryid`,`s`.`imgurl`,s.minOrderPrice as marketPrice,`u`.`city` FROM `stock` `s` LEFT JOIN `user` `u` ON `u`.`id`=`s`.`userid` WHERE `s`.`categoryid` = '671' ORDER BY `s`.`id` DESC LIMIT 10 [ RunTime:0.000709s ]
SELECT `s`.`id`,s.partno name,`s`.`categoryid`,`s`.`imgurl`,s.minOrderPrice as marketPrice,`u`.`city` FROM `stock` `s` LEFT JOIN `user` `u` ON `u`.`id`=`s`.`userid` WHERE `s`.`categoryid` = '665' ORDER BY `s`.`id` DESC LIMIT 10 [ RunTime:0.002850s ]
SELECT `s`.`id`,s.partno name,`s`.`categoryid`,`s`.`imgurl`,s.minOrderPrice as marketPrice,`u`.`city` FROM `stock` `s` LEFT JOIN `user` `u` ON `u`.`id`=`s`.`userid` WHERE `s`.`categoryid` = '674' ORDER BY `s`.`id` DESC LIMIT 10 [ RunTime:0.002723s ]
SELECT `s`.`id`,s.partno name,`s`.`categoryid`,`s`.`imgurl`,s.minOrderPrice as marketPrice,`u`.`city` FROM `stock` `s` LEFT JOIN `user` `u` ON `u`.`id`=`s`.`userid` WHERE `s`.`categoryid` = '675' ORDER BY `s`.`id` DESC LIMIT 10 [ RunTime:0.000734s ]
SELECT `s`.`id`,s.partno name,`s`.`categoryid`,`s`.`imgurl`,s.minOrderPrice as marketPrice,`u`.`city` FROM `stock` `s` LEFT JOIN `user` `u` ON `u`.`id`=`s`.`userid` WHERE `s`.`categoryid` = '673' ORDER BY `s`.`id` DESC LIMIT 10 [ RunTime:0.000538s ]
SELECT `s`.`id`,s.partno name,`s`.`categoryid`,`s`.`imgurl`,s.minOrderPrice as marketPrice,`u`.`city` FROM `stock` `s` LEFT JOIN `user` `u` ON `u`.`id`=`s`.`userid` WHERE `s`.`categoryid` = '669' ORDER BY `s`.`id` DESC LIMIT 10 [ RunTime:0.000544s ]
SELECT `s`.`id`,s.partno name,`s`.`categoryid`,`s`.`imgurl`,s.minOrderPrice as marketPrice,`u`.`city` FROM `stock` `s` LEFT JOIN `user` `u` ON `u`.`id`=`s`.`userid` WHERE `s`.`categoryid` = '667' ORDER BY `s`.`id` DESC LIMIT 10 [ RunTime:0.001755s ]
SELECT `s`.`id`,s.partno name,`s`.`categoryid`,`s`.`imgurl`,s.minOrderPrice as marketPrice,`u`.`city` FROM `stock` `s` LEFT JOIN `user` `u` ON `u`.`id`=`s`.`userid` WHERE `s`.`categoryid` = '668' ORDER BY `s`.`id` DESC LIMIT 10 [ RunTime:0.009121s ]
SELECT `s`.`id`,s.partno name,`s`.`categoryid`,`s`.`imgurl`,s.minOrderPrice as marketPrice,`u`.`city` FROM `stock` `s` LEFT JOIN `user` `u` ON `u`.`id`=`s`.`userid` WHERE `s`.`categoryid` = '711' ORDER BY `s`.`id` DESC LIMIT 5 [ RunTime:0.009854s ]
SELECT `s`.`id`,s.partno name,`s`.`categoryid`,`s`.`imgurl`,s.minOrderPrice as marketPrice,`u`.`city` FROM `stock` `s` LEFT JOIN `user` `u` ON `u`.`id`=`s`.`userid` WHERE `s`.`categoryid` = '696' ORDER BY `s`.`id` DESC LIMIT 10 [ RunTime:0.001249s ]
SELECT `s`.`id`,s.partno name,`s`.`categoryid`,`s`.`imgurl`,s.minOrderPrice as marketPrice,`u`.`city` FROM `stock` `s` LEFT JOIN `user` `u` ON `u`.`id`=`s`.`userid` WHERE `s`.`categoryid` = '718' ORDER BY `s`.`id` DESC LIMIT 10 [ RunTime:0.007592s ]
SELECT `s`.`id`,s.partno name,`s`.`categoryid`,`s`.`imgurl`,s.minOrderPrice as marketPrice,`u`.`city` FROM `stock` `s` LEFT JOIN `user` `u` ON `u`.`id`=`s`.`userid` WHERE `s`.`categoryid` = '698' ORDER BY `s`.`id` DESC LIMIT 10 [ RunTime:0.002194s ]
SELECT `s`.`id`,s.partno name,`s`.`categoryid`,`s`.`imgurl`,s.minOrderPrice as marketPrice,`u`.`city` FROM `stock` `s` LEFT JOIN `user` `u` ON `u`.`id`=`s`.`userid` WHERE `s`.`categoryid` = '699' ORDER BY `s`.`id` DESC LIMIT 10 [ RunTime:0.001703s ]
SELECT `s`.`id`,s.partno name,`s`.`categoryid`,`s`.`imgurl`,s.minOrderPrice as marketPrice,`u`.`city` FROM `stock` `s` LEFT JOIN `user` `u` ON `u`.`id`=`s`.`userid` WHERE `s`.`categoryid` = '700' ORDER BY `s`.`id` DESC LIMIT 10 [ RunTime:0.001581s ]
SELECT `s`.`id`,s.partno name,`s`.`categoryid`,`s`.`imgurl`,s.minOrderPrice as marketPrice,`u`.`city` FROM `stock` `s` LEFT JOIN `user` `u` ON `u`.`id`=`s`.`userid` WHERE `s`.`categoryid` = '701' ORDER BY `s`.`id` DESC LIMIT 10 [ RunTime:0.001566s ]
SELECT `s`.`id`,s.partno name,`s`.`categoryid`,`s`.`imgurl`,s.minOrderPrice as marketPrice,`u`.`city` FROM `stock` `s` LEFT JOIN `user` `u` ON `u`.`id`=`s`.`userid` WHERE `s`.`categoryid` = '702' ORDER BY `s`.`id` DESC LIMIT 10 [ RunTime:0.000469s ]
SELECT `s`.`id`,s.partno name,`s`.`categoryid`,`s`.`imgurl`,s.minOrderPrice as marketPrice,`u`.`city` FROM `stock` `s` LEFT JOIN `user` `u` ON `u`.`id`=`s`.`userid` WHERE `s`.`categoryid` = '703' ORDER BY `s`.`id` DESC LIMIT 10 [ RunTime:0.000388s ]
SELECT `s`.`id`,s.partno name,`s`.`categoryid`,`s`.`imgurl`,s.minOrderPrice as marketPrice,`u`.`city` FROM `stock` `s` LEFT JOIN `user` `u` ON `u`.`id`=`s`.`userid` WHERE `s`.`categoryid` = '720' ORDER BY `s`.`id` DESC LIMIT 5 [ RunTime:0.000368s ]
SELECT `s`.`id`,s.partno name,`s`.`categoryid`,`s`.`imgurl`,s.minOrderPrice as marketPrice,`u`.`city` FROM `stock` `s` LEFT JOIN `user` `u` ON `u`.`id`=`s`.`userid` WHERE `s`.`categoryid` = '721' ORDER BY `s`.`id` DESC LIMIT 10 [ RunTime:0.001255s ]
SELECT `s`.`id`,s.partno name,`s`.`categoryid`,`s`.`imgurl`,s.minOrderPrice as marketPrice,`u`.`city` FROM `stock` `s` LEFT JOIN `user` `u` ON `u`.`id`=`s`.`userid` WHERE `s`.`categoryid` = '722' ORDER BY `s`.`id` DESC LIMIT 10 [ RunTime:0.005277s ]
SELECT `s`.`id`,s.partno name,`s`.`categoryid`,`s`.`imgurl`,s.minOrderPrice as marketPrice,`u`.`city` FROM `stock` `s` LEFT JOIN `user` `u` ON `u`.`id`=`s`.`userid` WHERE `s`.`categoryid` = '723' ORDER BY `s`.`id` DESC LIMIT 10 [ RunTime:0.000549s ]
SELECT `s`.`id`,s.partno name,`s`.`categoryid`,`s`.`imgurl`,s.minOrderPrice as marketPrice,`u`.`city` FROM `stock` `s` LEFT JOIN `user` `u` ON `u`.`id`=`s`.`userid` WHERE `s`.`categoryid` = '724' ORDER BY `s`.`id` DESC LIMIT 10 [ RunTime:0.000378s ]
SELECT `s`.`id`,s.partno name,`s`.`categoryid`,`s`.`imgurl`,s.minOrderPrice as marketPrice,`u`.`city` FROM `stock` `s` LEFT JOIN `user` `u` ON `u`.`id`=`s`.`userid` WHERE `s`.`categoryid` = '725' ORDER BY `s`.`id` DESC LIMIT 10 [ RunTime:0.000399s ]
SELECT `s`.`id`,s.partno name,`s`.`categoryid`,`s`.`imgurl`,s.minOrderPrice as marketPrice,`u`.`city` FROM `stock` `s` LEFT JOIN `user` `u` ON `u`.`id`=`s`.`userid` WHERE `s`.`categoryid` = '726' ORDER BY `s`.`id` DESC LIMIT 10 [ RunTime:0.000384s ]
SELECT `s`.`id`,s.partno name,`s`.`categoryid`,`s`.`imgurl`,s.minOrderPrice as marketPrice,`u`.`city` FROM `stock` `s` LEFT JOIN `user` `u` ON `u`.`id`=`s`.`userid` WHERE `s`.`categoryid` = '727' ORDER BY `s`.`id` DESC LIMIT 10 [ RunTime:0.002535s ]
SELECT `s`.`id`,s.partno name,`s`.`categoryid`,`s`.`imgurl`,s.minOrderPrice as marketPrice,`u`.`city` FROM `stock` `s` LEFT JOIN `user` `u` ON `u`.`id`=`s`.`userid` WHERE `s`.`categoryid` = '728' ORDER BY `s`.`id` DESC LIMIT 10 [ RunTime:0.000401s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000303s ]
SHOW FULL COLUMNS FROM `news` [ RunTime:0.001139s ]
SELECT `id`,`typeid`,`title` FROM `news` WHERE `typeid` <> 433 ORDER BY `id` DESC LIMIT 4 [ RunTime:0.002005s ]
SHOW FULL COLUMNS FROM `stock_brand` [ RunTime:0.002744s ]
SELECT `id`,`brandshort`,`Logo`,`LogoNew` FROM `stock_brand` WHERE ( ( `type` = 1 OR `type` = 3 ) ) LIMIT 20 [ RunTime:0.004450s ]