SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001314s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.004878s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.003113s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.217' ) [ RunTime:0.002349s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.002222s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.002509s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 0 LIMIT 1 [ RunTime:0.004107s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` = 0 [ RunTime:0.000302s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` IN (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,800,1068,1296,1456,1822,1929,2017,2101,2342,2393,2475,2518,2568) [ RunTime:0.000979s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002116s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` INNER JOIN `user` `u` ON `s`.`userid`=`u`.`stockuserid` WHERE ( `status` <> 2 ) AND `u`.`lockUser` = '0' [ RunTime:0.000561s ]
SELECT `s`.`id` FROM `stock` `s` INNER JOIN `user` `u` ON `s`.`userid`=`u`.`stockuserid` WHERE `u`.`lockUser` = '0' AND ( (s.isDisplay = 1) ) AND ( `status` <> 2 ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 8540,20 [ RunTime:0.223594s ]
SELECT `s`.`id`,`s`.`userid`,`s`.`status`,`havePdf`,`categoryid`,`categories`,`minOrderPrice`,`minOrderQuantity`,`deliveryNum`,`sellNum`,`stockNum`,`code`,`partno`,`brand`,`package`,`imgurl`,`note`,`description`,`expiretime`,`pdfurl`,`t`.`name` FROM `stock` `s` INNER JOIN `user` `u` ON `s`.`userid`=`u`.`stockuserid` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE `u`.`lockUser` = '0' AND ( (s.isDisplay = 1) ) AND `s`.`id` IN ('14082','6889','11481328','11239476','11488351','10458030','10458029','11495685','11174391','11954556','2617','11481683','11609822','10440436','3106','11417337','11481457','12043388','11487183','11170467') ORDER BY FIELD(s.id, 14082,6889,11481328,11239476,11488351,10458030,10458029,11495685,11174391,11954556,2617,11481683,11609822,10440436,3106,11417337,11481457,12043388,11487183,11170467) [ RunTime:0.015841s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.002361s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14082 LIMIT 4 [ RunTime:0.002045s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.003638s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14082 ORDER BY `minOrder` ASC [ RunTime:0.002944s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.001214s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14082 ORDER BY `unit` DESC [ RunTime:0.005305s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.001249s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14082 LIMIT 2 [ RunTime:0.001189s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14082 ORDER BY `minOrder` ASC [ RunTime:0.005418s ]
select * from pdf where partno='RC0805FR-071KL' and brandshort='YAGEO' limit 1 [ RunTime:0.008089s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002821s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'RC0805FR-071KL' OR `brand` LIKE 'YAGEO%' ) ) LIMIT 1 [ RunTime:0.006842s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 6889 LIMIT 4 [ RunTime:0.002514s ]
SELECT * FROM `stock_price` WHERE `stockid` = 6889 ORDER BY `minOrder` ASC [ RunTime:0.001423s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 6889 ORDER BY `unit` DESC [ RunTime:0.001399s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 6889 LIMIT 2 [ RunTime:0.005030s ]
SELECT * FROM `stock_price` WHERE `stockid` = 6889 ORDER BY `minOrder` ASC [ RunTime:0.003108s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'NTR5198NLT1G' OR `brand` LIKE 'ONSEMI%' ) ) LIMIT 1 [ RunTime:0.016188s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11481328 LIMIT 4 [ RunTime:0.004585s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11481328 ORDER BY `minOrder` ASC [ RunTime:0.004210s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11481328 ORDER BY `unit` DESC [ RunTime:0.004610s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11481328 LIMIT 2 [ RunTime:0.002664s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11481328 ORDER BY `minOrder` ASC [ RunTime:0.000329s ]
select * from pdf where partno='963900-1' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.006801s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11239476 LIMIT 4 [ RunTime:0.012987s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11239476 ORDER BY `minOrder` ASC [ RunTime:0.017704s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11239476 ORDER BY `unit` DESC [ RunTime:0.005936s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11239476 LIMIT 2 [ RunTime:0.003860s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11239476 ORDER BY `minOrder` ASC [ RunTime:0.007868s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11488351 LIMIT 4 [ RunTime:0.004948s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11488351 ORDER BY `minOrder` ASC [ RunTime:0.032037s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11488351 ORDER BY `unit` DESC [ RunTime:0.026058s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11488351 LIMIT 2 [ RunTime:0.012372s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11488351 ORDER BY `minOrder` ASC [ RunTime:0.000446s ]
select * from pdf where partno='0039014032' and brandshort='Molex' limit 1 [ RunTime:0.013848s ]
select foldpath,foldpath2,filename from pdf_file where id=834387 limit 1 [ RunTime:0.011551s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10458030 LIMIT 4 [ RunTime:0.003340s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10458030 ORDER BY `minOrder` ASC [ RunTime:0.002240s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 10458030 ORDER BY `unit` DESC [ RunTime:0.001208s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 10458030 LIMIT 2 [ RunTime:0.010808s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10458030 ORDER BY `minOrder` ASC [ RunTime:0.000887s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10458029 LIMIT 4 [ RunTime:0.011878s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10458029 ORDER BY `minOrder` ASC [ RunTime:0.013440s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 10458029 ORDER BY `unit` DESC [ RunTime:0.002546s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 10458029 LIMIT 2 [ RunTime:0.001186s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10458029 ORDER BY `minOrder` ASC [ RunTime:0.002783s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11495685 LIMIT 4 [ RunTime:0.015821s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11495685 ORDER BY `minOrder` ASC [ RunTime:0.001831s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11495685 ORDER BY `unit` DESC [ RunTime:0.002950s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11495685 LIMIT 2 [ RunTime:0.009159s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11495685 ORDER BY `minOrder` ASC [ RunTime:0.000485s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11174391 LIMIT 4 [ RunTime:0.002636s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11174391 ORDER BY `minOrder` ASC [ RunTime:0.002133s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11174391 ORDER BY `unit` DESC [ RunTime:0.000493s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11174391 LIMIT 2 [ RunTime:0.000440s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11174391 ORDER BY `minOrder` ASC [ RunTime:0.001188s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11954556 LIMIT 4 [ RunTime:0.003122s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11954556 ORDER BY `minOrder` ASC [ RunTime:0.000947s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11954556 ORDER BY `unit` DESC [ RunTime:0.004264s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11954556 LIMIT 2 [ RunTime:0.000998s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11954556 ORDER BY `minOrder` ASC [ RunTime:0.000781s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 2617 LIMIT 4 [ RunTime:0.000634s ]
SELECT * FROM `stock_price` WHERE `stockid` = 2617 ORDER BY `minOrder` ASC [ RunTime:0.000766s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 2617 ORDER BY `unit` DESC [ RunTime:0.000570s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 2617 LIMIT 2 [ RunTime:0.001549s ]
SELECT * FROM `stock_price` WHERE `stockid` = 2617 ORDER BY `minOrder` ASC [ RunTime:0.002942s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'STN951' OR `brand` LIKE 'STMICROELECTRONICS%' ) ) LIMIT 1 [ RunTime:0.008214s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11481683 LIMIT 4 [ RunTime:0.006855s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11481683 ORDER BY `minOrder` ASC [ RunTime:0.000713s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11481683 ORDER BY `unit` DESC [ RunTime:0.007426s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11481683 LIMIT 2 [ RunTime:0.011920s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11481683 ORDER BY `minOrder` ASC [ RunTime:0.000581s ]
select * from pdf where partno='350415-5' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.001810s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11609822 LIMIT 4 [ RunTime:0.005093s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11609822 ORDER BY `minOrder` ASC [ RunTime:0.001038s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11609822 ORDER BY `unit` DESC [ RunTime:0.002328s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11609822 LIMIT 2 [ RunTime:0.000378s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11609822 ORDER BY `minOrder` ASC [ RunTime:0.000262s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10440436 LIMIT 4 [ RunTime:0.001046s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10440436 ORDER BY `minOrder` ASC [ RunTime:0.000384s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 10440436 ORDER BY `unit` DESC [ RunTime:0.013971s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 10440436 LIMIT 2 [ RunTime:0.003375s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10440436 ORDER BY `minOrder` ASC [ RunTime:0.000342s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 3106 LIMIT 4 [ RunTime:0.001153s ]
SELECT * FROM `stock_price` WHERE `stockid` = 3106 ORDER BY `minOrder` ASC [ RunTime:0.001107s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 3106 ORDER BY `unit` DESC [ RunTime:0.000663s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 3106 LIMIT 2 [ RunTime:0.001588s ]
SELECT * FROM `stock_price` WHERE `stockid` = 3106 ORDER BY `minOrder` ASC [ RunTime:0.008333s ]
select * from pdf where partno='CK05BX104K' and brandshort='KEMET' limit 1 [ RunTime:0.011896s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CK05BX104K' OR `brand` LIKE 'KEMET%' ) ) LIMIT 1 [ RunTime:0.009474s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11417337 LIMIT 4 [ RunTime:0.003080s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11417337 ORDER BY `minOrder` ASC [ RunTime:0.010762s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11417337 ORDER BY `unit` DESC [ RunTime:0.002709s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11417337 LIMIT 2 [ RunTime:0.002768s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11417337 ORDER BY `minOrder` ASC [ RunTime:0.008827s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11481457 LIMIT 4 [ RunTime:0.000730s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11481457 ORDER BY `minOrder` ASC [ RunTime:0.000729s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11481457 ORDER BY `unit` DESC [ RunTime:0.005346s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11481457 LIMIT 2 [ RunTime:0.000385s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11481457 ORDER BY `minOrder` ASC [ RunTime:0.000320s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12043388 LIMIT 4 [ RunTime:0.000745s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12043388 ORDER BY `minOrder` ASC [ RunTime:0.001795s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12043388 ORDER BY `unit` DESC [ RunTime:0.000387s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12043388 LIMIT 2 [ RunTime:0.000364s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12043388 ORDER BY `minOrder` ASC [ RunTime:0.000261s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11487183 LIMIT 4 [ RunTime:0.000696s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11487183 ORDER BY `minOrder` ASC [ RunTime:0.000751s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11487183 ORDER BY `unit` DESC [ RunTime:0.003310s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11487183 LIMIT 2 [ RunTime:0.003028s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11487183 ORDER BY `minOrder` ASC [ RunTime:0.000337s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11170467 LIMIT 4 [ RunTime:0.001375s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11170467 ORDER BY `minOrder` ASC [ RunTime:0.000396s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11170467 ORDER BY `unit` DESC [ RunTime:0.000329s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11170467 LIMIT 2 [ RunTime:0.001746s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11170467 ORDER BY `minOrder` ASC [ RunTime:0.001090s ]
select * from pdf where partno='LR1F39K' and brandshort='TE Connectivity Passive Product' limit 1 [ RunTime:0.001616s ]
SELECT brand, count(*) as count FROM `stock` WHERE ( `status` <> 2 ) AND `brand` IS NOT NULL AND `brand` <> '' GROUP BY `brand` ORDER BY `count` DESC LIMIT 10000 [ RunTime:0.001286s ]