SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001163s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.014029s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001417s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.121' ) [ RunTime:0.008395s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001299s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.027153s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 0 LIMIT 1 [ RunTime:0.009961s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` = 0 [ RunTime:0.014958s ]
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.008146s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001479s ]
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.021093s ]
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 9780,20 [ RunTime:0.142237s ]
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 ('11938','10595','9676','9517','9396','9177','8444','7122','6941','6812','5206','3173','2253','1802','1719','556','1219','2796','9210','7529') ORDER BY FIELD(s.id, 11938,10595,9676,9517,9396,9177,8444,7122,6941,6812,5206,3173,2253,1802,1719,556,1219,2796,9210,7529) [ RunTime:0.076700s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.003642s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11938 LIMIT 4 [ RunTime:0.023629s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.002750s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11938 ORDER BY `minOrder` ASC [ RunTime:0.032932s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.044412s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11938 ORDER BY `unit` DESC [ RunTime:0.030009s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.015309s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11938 LIMIT 2 [ RunTime:0.014357s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11938 ORDER BY `minOrder` ASC [ RunTime:0.023394s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002217s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'RB706UM-40FHTL' OR `brand` LIKE 'ROHM%' ) ) LIMIT 1 [ RunTime:0.017456s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10595 LIMIT 4 [ RunTime:0.069104s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10595 ORDER BY `minOrder` ASC [ RunTime:0.041912s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 10595 ORDER BY `unit` DESC [ RunTime:0.030241s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 10595 LIMIT 2 [ RunTime:0.038423s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10595 ORDER BY `minOrder` ASC [ RunTime:0.005604s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '34729-0082' OR `brand` LIKE 'MOLEX%' ) ) LIMIT 1 [ RunTime:0.039388s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 9676 LIMIT 4 [ RunTime:0.032894s ]
SELECT * FROM `stock_price` WHERE `stockid` = 9676 ORDER BY `minOrder` ASC [ RunTime:0.010641s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 9676 ORDER BY `unit` DESC [ RunTime:0.024897s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 9676 LIMIT 2 [ RunTime:0.011354s ]
SELECT * FROM `stock_price` WHERE `stockid` = 9676 ORDER BY `minOrder` ASC [ RunTime:0.007643s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMMBT3906WT1G' OR `brand` LIKE 'ONSEMI%' ) ) LIMIT 1 [ RunTime:0.028073s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 9517 LIMIT 4 [ RunTime:0.015744s ]
SELECT * FROM `stock_price` WHERE `stockid` = 9517 ORDER BY `minOrder` ASC [ RunTime:0.011966s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 9517 ORDER BY `unit` DESC [ RunTime:0.017608s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 9517 LIMIT 2 [ RunTime:0.004680s ]
SELECT * FROM `stock_price` WHERE `stockid` = 9517 ORDER BY `minOrder` ASC [ RunTime:0.006443s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SS34FA' OR `brand` LIKE 'ONSEMI%' ) ) LIMIT 1 [ RunTime:0.020607s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 9396 LIMIT 4 [ RunTime:0.005488s ]
SELECT * FROM `stock_price` WHERE `stockid` = 9396 ORDER BY `minOrder` ASC [ RunTime:0.004016s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 9396 ORDER BY `unit` DESC [ RunTime:0.007719s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 9396 LIMIT 2 [ RunTime:0.000974s ]
SELECT * FROM `stock_price` WHERE `stockid` = 9396 ORDER BY `minOrder` ASC [ RunTime:0.011148s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'EEUFC1H470H' OR `brand` LIKE 'PANASONIC%' ) ) LIMIT 1 [ RunTime:0.000718s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 9177 LIMIT 4 [ RunTime:0.003826s ]
SELECT * FROM `stock_price` WHERE `stockid` = 9177 ORDER BY `minOrder` ASC [ RunTime:0.019130s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 9177 ORDER BY `unit` DESC [ RunTime:0.006547s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 9177 LIMIT 2 [ RunTime:0.046715s ]
SELECT * FROM `stock_price` WHERE `stockid` = 9177 ORDER BY `minOrder` ASC [ RunTime:0.002655s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MC33926PNBR2' OR `brand` LIKE 'NXP%' ) ) LIMIT 1 [ RunTime:0.023990s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 8444 LIMIT 4 [ RunTime:0.020718s ]
SELECT * FROM `stock_price` WHERE `stockid` = 8444 ORDER BY `minOrder` ASC [ RunTime:0.023154s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 8444 ORDER BY `unit` DESC [ RunTime:0.010740s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 8444 LIMIT 2 [ RunTime:0.005374s ]
SELECT * FROM `stock_price` WHERE `stockid` = 8444 ORDER BY `minOrder` ASC [ RunTime:0.008833s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'GRM21BR6YA106KE43L' OR `brand` LIKE 'MURATA%' ) ) LIMIT 1 [ RunTime:0.042433s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 7122 LIMIT 4 [ RunTime:0.011528s ]
SELECT * FROM `stock_price` WHERE `stockid` = 7122 ORDER BY `minOrder` ASC [ RunTime:0.026578s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 7122 ORDER BY `unit` DESC [ RunTime:0.020169s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 7122 LIMIT 2 [ RunTime:0.034477s ]
SELECT * FROM `stock_price` WHERE `stockid` = 7122 ORDER BY `minOrder` ASC [ RunTime:0.003610s ]
select * from pdf where partno='BSC028N06NSATMA1' and brandshort='INFINEON' limit 1 [ RunTime:0.010605s ]
select foldpath,foldpath2,filename from pdf_file where id=1196037 limit 1 [ RunTime:0.015356s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BSC028N06NSATMA1' OR `brand` LIKE 'INFINEON%' ) ) LIMIT 1 [ RunTime:0.024010s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 6941 LIMIT 4 [ RunTime:0.003215s ]
SELECT * FROM `stock_price` WHERE `stockid` = 6941 ORDER BY `minOrder` ASC [ RunTime:0.017308s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 6941 ORDER BY `unit` DESC [ RunTime:0.012304s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 6941 LIMIT 2 [ RunTime:0.002724s ]
SELECT * FROM `stock_price` WHERE `stockid` = 6941 ORDER BY `minOrder` ASC [ RunTime:0.013339s ]
select * from pdf where partno='PSMN2R4-30MLDX' and brandshort='NEXPERIA' limit 1 [ RunTime:0.028849s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PSMN2R4-30MLDX' OR `brand` LIKE 'NEXPERIA%' ) ) LIMIT 1 [ RunTime:0.020921s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 6812 LIMIT 4 [ RunTime:0.016727s ]
SELECT * FROM `stock_price` WHERE `stockid` = 6812 ORDER BY `minOrder` ASC [ RunTime:0.007020s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 6812 ORDER BY `unit` DESC [ RunTime:0.011897s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 6812 LIMIT 2 [ RunTime:0.004499s ]
SELECT * FROM `stock_price` WHERE `stockid` = 6812 ORDER BY `minOrder` ASC [ RunTime:0.005512s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MPZ1608S101ATAH0' OR `brand` LIKE 'TDK%' ) ) LIMIT 1 [ RunTime:0.014996s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 5206 LIMIT 4 [ RunTime:0.009715s ]
SELECT * FROM `stock_price` WHERE `stockid` = 5206 ORDER BY `minOrder` ASC [ RunTime:0.005467s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 5206 ORDER BY `unit` DESC [ RunTime:0.013320s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 5206 LIMIT 2 [ RunTime:0.003902s ]
SELECT * FROM `stock_price` WHERE `stockid` = 5206 ORDER BY `minOrder` ASC [ RunTime:0.003513s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'STM32F407VGT6' OR `brand` LIKE 'STMICROELECTRONICS%' ) ) LIMIT 1 [ RunTime:0.007451s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 3173 LIMIT 4 [ RunTime:0.031256s ]
SELECT * FROM `stock_price` WHERE `stockid` = 3173 ORDER BY `minOrder` ASC [ RunTime:0.015906s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 3173 ORDER BY `unit` DESC [ RunTime:0.009508s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 3173 LIMIT 2 [ RunTime:0.002689s ]
SELECT * FROM `stock_price` WHERE `stockid` = 3173 ORDER BY `minOrder` ASC [ RunTime:0.006169s ]
select * from pdf where partno='CRCW06034K12FKEA' and brandshort='VISHAY' limit 1 [ RunTime:0.013140s ]
select foldpath,foldpath2,filename from pdf_file where id=1487005 limit 1 [ RunTime:0.005055s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CRCW06034K12FKEA' OR `brand` LIKE 'VISHAY%' ) ) LIMIT 1 [ RunTime:0.020104s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 2253 LIMIT 4 [ RunTime:0.001639s ]
SELECT * FROM `stock_price` WHERE `stockid` = 2253 ORDER BY `minOrder` ASC [ RunTime:0.003556s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 2253 ORDER BY `unit` DESC [ RunTime:0.011700s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 2253 LIMIT 2 [ RunTime:0.014026s ]
SELECT * FROM `stock_price` WHERE `stockid` = 2253 ORDER BY `minOrder` ASC [ RunTime:0.000392s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'ULN2003D1013TR' OR `brand` LIKE 'STMICROELECTRONICS%' ) ) LIMIT 1 [ RunTime:0.009314s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 1802 LIMIT 4 [ RunTime:0.016027s ]
SELECT * FROM `stock_price` WHERE `stockid` = 1802 ORDER BY `minOrder` ASC [ RunTime:0.015703s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 1802 ORDER BY `unit` DESC [ RunTime:0.003714s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 1802 LIMIT 2 [ RunTime:0.009359s ]
SELECT * FROM `stock_price` WHERE `stockid` = 1802 ORDER BY `minOrder` ASC [ RunTime:0.003764s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '87831-4020' OR `brand` LIKE 'MOLEX%' ) ) LIMIT 1 [ RunTime:0.029015s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 1719 LIMIT 4 [ RunTime:0.016321s ]
SELECT * FROM `stock_price` WHERE `stockid` = 1719 ORDER BY `minOrder` ASC [ RunTime:0.009181s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 1719 ORDER BY `unit` DESC [ RunTime:0.002896s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 1719 LIMIT 2 [ RunTime:0.011485s ]
SELECT * FROM `stock_price` WHERE `stockid` = 1719 ORDER BY `minOrder` ASC [ RunTime:0.017787s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '3-643816-3' OR `brand` LIKE 'AMP - TE CONNECTIVITY%' ) ) LIMIT 1 [ RunTime:0.007117s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 556 LIMIT 4 [ RunTime:0.008446s ]
SELECT * FROM `stock_price` WHERE `stockid` = 556 ORDER BY `minOrder` ASC [ RunTime:0.002173s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 556 ORDER BY `unit` DESC [ RunTime:0.008154s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 556 LIMIT 2 [ RunTime:0.010392s ]
SELECT * FROM `stock_price` WHERE `stockid` = 556 ORDER BY `minOrder` ASC [ RunTime:0.003027s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'D25S24A4GV00LF' OR `brand` LIKE 'AMPHENOL COMMUNICATIONS SOLUTIONS%' ) ) LIMIT 1 [ RunTime:0.007461s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 1219 LIMIT 4 [ RunTime:0.001038s ]
SELECT * FROM `stock_price` WHERE `stockid` = 1219 ORDER BY `minOrder` ASC [ RunTime:0.004909s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 1219 ORDER BY `unit` DESC [ RunTime:0.010355s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 1219 LIMIT 2 [ RunTime:0.007197s ]
SELECT * FROM `stock_price` WHERE `stockid` = 1219 ORDER BY `minOrder` ASC [ RunTime:0.008173s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MC78M12CDTG' OR `brand` LIKE 'ONSEMI%' ) ) LIMIT 1 [ RunTime:0.022834s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 2796 LIMIT 4 [ RunTime:0.002160s ]
SELECT * FROM `stock_price` WHERE `stockid` = 2796 ORDER BY `minOrder` ASC [ RunTime:0.003779s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 2796 ORDER BY `unit` DESC [ RunTime:0.011322s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 2796 LIMIT 2 [ RunTime:0.036948s ]
SELECT * FROM `stock_price` WHERE `stockid` = 2796 ORDER BY `minOrder` ASC [ RunTime:0.009426s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2212S-02SG-85' OR `brand` LIKE 'MULTICOMP PRO%' ) ) LIMIT 1 [ RunTime:0.005008s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 9210 LIMIT 4 [ RunTime:0.004330s ]
SELECT * FROM `stock_price` WHERE `stockid` = 9210 ORDER BY `minOrder` ASC [ RunTime:0.000570s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 9210 ORDER BY `unit` DESC [ RunTime:0.000991s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 9210 LIMIT 2 [ RunTime:0.000666s ]
SELECT * FROM `stock_price` WHERE `stockid` = 9210 ORDER BY `minOrder` ASC [ RunTime:0.000273s ]
select * from pdf where partno='5.0SMDJ150A' and brandshort='LITTELFUSE' limit 1 [ RunTime:0.002271s ]
select foldpath,foldpath2,filename from pdf_file where id=740737 limit 1 [ RunTime:0.001497s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5.0SMDJ150A' OR `brand` LIKE 'LITTELFUSE%' ) ) LIMIT 1 [ RunTime:0.017368s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 7529 LIMIT 4 [ RunTime:0.010192s ]
SELECT * FROM `stock_price` WHERE `stockid` = 7529 ORDER BY `minOrder` ASC [ RunTime:0.003796s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 7529 ORDER BY `unit` DESC [ RunTime:0.000401s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 7529 LIMIT 2 [ RunTime:0.004843s ]
SELECT * FROM `stock_price` WHERE `stockid` = 7529 ORDER BY `minOrder` ASC [ RunTime:0.004232s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'NCP380HMUAJAATBG' OR `brand` LIKE 'ONSEMI%' ) ) LIMIT 1 [ RunTime:0.013695s ]
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.001969s ]