SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.002712s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000614s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001269s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.186' ) [ RunTime:0.000223s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001049s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000188s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (2475,2518,2568) AND `id` > 799 [ RunTime:0.019480s ]
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.004920s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001221s ]
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.005231s ]
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.000598s ]
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.006486s ]
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.004194s ]
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.009035s ]
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.000482s ]
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.003644s ]
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.000440s ]
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.000297s ]
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.001024s ]
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.002418s ]
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.000723s ]
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.001495s ]
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.007231s ]
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.000653s ]
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.000279s ]
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.000273s ]
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.002587s ]
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.000820s ]
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.000492s ]
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.002066s ]
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.000335s ]
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.000405s ]
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.000297s ]
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.000597s ]
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.008523s ]
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.001416s ]
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.000359s ]
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.000684s ]
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.001493s ]
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.001351s ]
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.001201s ]
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.001101s ]
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.000712s ]
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.000422s ]
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.000273s ]
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.000336s ]
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.000981s ]
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.001031s ]
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.001628s ]
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.003002s ]
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.001917s ]
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.000727s ]
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.000301s ]
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.000270s ]
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.000264s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000211s ]
SHOW FULL COLUMNS FROM `news` [ RunTime:0.001192s ]
SELECT `id`,`typeid`,`title` FROM `news` WHERE `typeid` <> 433 ORDER BY `id` DESC LIMIT 4 [ RunTime:0.000168s ]
SHOW FULL COLUMNS FROM `stock_brand` [ RunTime:0.000848s ]
SELECT `id`,`brandshort`,`Logo`,`LogoNew` FROM `stock_brand` WHERE ( ( `type` = 1 OR `type` = 3 ) ) LIMIT 20 [ RunTime:0.000645s ]