SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.002133s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000648s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002366s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '18.97.14.82' ) [ RunTime:0.000350s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001126s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000307s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (2475,2518,2568) AND `id` > 799 [ RunTime:0.011303s ]
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.008167s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001450s ]
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.007974s ]
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.001340s ]
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.003653s ]
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.003041s ]
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.000705s ]
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.002800s ]
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.008215s ]
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.007238s ]
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.003767s ]
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.001267s ]
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.001086s ]
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.000364s ]
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.000826s ]
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.000375s ]
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.007429s ]
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.001472s ]
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.001016s ]
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.000373s ]
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.000362s ]
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.001200s ]
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.000850s ]
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.000418s ]
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.000373s ]
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.000510s ]
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.001087s ]
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.000626s ]
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.000354s ]
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.000725s ]
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.001401s ]
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.001374s ]
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.000524s ]
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.000829s ]
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.004475s ]
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.003488s ]
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.000391s ]
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.001318s ]
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.002728s ]
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.000351s ]
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.000716s ]
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.003336s ]
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.000591s ]
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.001467s ]
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.002706s ]
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.001595s ]
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.001653s ]
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.001448s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000297s ]
SHOW FULL COLUMNS FROM `news` [ RunTime:0.001298s ]
SELECT `id`,`typeid`,`title` FROM `news` WHERE `typeid` <> 433 ORDER BY `id` DESC LIMIT 4 [ RunTime:0.000244s ]
SHOW FULL COLUMNS FROM `stock_brand` [ RunTime:0.001053s ]
SELECT `id`,`brandshort`,`Logo`,`LogoNew` FROM `stock_brand` WHERE ( ( `type` = 1 OR `type` = 3 ) ) LIMIT 20 [ RunTime:0.000823s ]