SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.002469s ]
INSERT INTO `visit_log` SET `ip` = '216.73.217.142' , `useragent` = 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)' , `reffer` = '' , `host` = 'https://www.ic118.com/stock?keyword=BSM&search=1' [ RunTime:0.002933s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.002334s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000932s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002526s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.142' ) [ RunTime:0.004955s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.002832s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.005209s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.002296s ]
SELECT * FROM `stock_search` WHERE `partno` = 'BSM' LIMIT 1 [ RunTime:0.007993s ]
UPDATE `stock_search` SET `count` = 4 , `updatetime` = '2026-08-02 02:08:12' WHERE `partno` = 'BSM' [ RunTime:0.008436s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001571s ]
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` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'BSM%' OR `brand` LIKE 'BSM%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.006278s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001233s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12088771 LIMIT 5 [ RunTime:0.000791s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.006745s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12088771 ORDER BY `minOrder` ASC [ RunTime:0.000321s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.001939s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12088771 ORDER BY `unit` DESC [ RunTime:0.000390s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.006535s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12088771 LIMIT 2 [ RunTime:0.005792s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12088771 ORDER BY `minOrder` ASC [ RunTime:0.003048s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14274106 LIMIT 5 [ RunTime:0.000792s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14274106 ORDER BY `minOrder` ASC [ RunTime:0.000540s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14274106 ORDER BY `unit` DESC [ RunTime:0.000354s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14274106 LIMIT 2 [ RunTime:0.000884s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14274106 ORDER BY `minOrder` ASC [ RunTime:0.000628s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 23943 LIMIT 5 [ RunTime:0.002750s ]
SELECT * FROM `stock_price` WHERE `stockid` = 23943 ORDER BY `minOrder` ASC [ RunTime:0.004503s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 23943 ORDER BY `unit` DESC [ RunTime:0.003494s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 23943 LIMIT 2 [ RunTime:0.006103s ]
SELECT * FROM `stock_price` WHERE `stockid` = 23943 ORDER BY `minOrder` ASC [ RunTime:0.000780s ]
select * from pdf where partno='BSM150GB120DN2' and brandshort='INF' limit 1 [ RunTime:0.002389s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002625s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BSM150GB120DN2' OR `brand` LIKE 'INF%' ) ) LIMIT 1 [ RunTime:0.013676s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12093621 LIMIT 5 [ RunTime:0.008736s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12093621 ORDER BY `minOrder` ASC [ RunTime:0.003193s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12093621 ORDER BY `unit` DESC [ RunTime:0.000593s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12093621 LIMIT 2 [ RunTime:0.012127s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12093621 ORDER BY `minOrder` ASC [ RunTime:0.001149s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18581974 LIMIT 5 [ RunTime:0.011436s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18581974 ORDER BY `minOrder` ASC [ RunTime:0.003350s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18581974 ORDER BY `unit` DESC [ RunTime:0.000688s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18581974 LIMIT 2 [ RunTime:0.002008s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18581974 ORDER BY `minOrder` ASC [ RunTime:0.004612s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19584553 LIMIT 5 [ RunTime:0.003513s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19584553 ORDER BY `minOrder` ASC [ RunTime:0.008190s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19584553 ORDER BY `unit` DESC [ RunTime:0.003604s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19584553 LIMIT 2 [ RunTime:0.002332s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19584553 ORDER BY `minOrder` ASC [ RunTime:0.003723s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19584552 LIMIT 5 [ RunTime:0.002489s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19584552 ORDER BY `minOrder` ASC [ RunTime:0.001786s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19584552 ORDER BY `unit` DESC [ RunTime:0.000649s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19584552 LIMIT 2 [ RunTime:0.006271s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19584552 ORDER BY `minOrder` ASC [ RunTime:0.003785s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19584551 LIMIT 5 [ RunTime:0.000718s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19584551 ORDER BY `minOrder` ASC [ RunTime:0.000660s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19584551 ORDER BY `unit` DESC [ RunTime:0.003089s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19584551 LIMIT 2 [ RunTime:0.001099s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19584551 ORDER BY `minOrder` ASC [ RunTime:0.006773s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19584550 LIMIT 5 [ RunTime:0.004116s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19584550 ORDER BY `minOrder` ASC [ RunTime:0.000721s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19584550 ORDER BY `unit` DESC [ RunTime:0.000640s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19584550 LIMIT 2 [ RunTime:0.005807s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19584550 ORDER BY `minOrder` ASC [ RunTime:0.002157s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19584549 LIMIT 5 [ RunTime:0.000672s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19584549 ORDER BY `minOrder` ASC [ RunTime:0.002474s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19584549 ORDER BY `unit` DESC [ RunTime:0.004597s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19584549 LIMIT 2 [ RunTime:0.003315s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19584549 ORDER BY `minOrder` ASC [ RunTime:0.001679s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19584548 LIMIT 5 [ RunTime:0.000680s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19584548 ORDER BY `minOrder` ASC [ RunTime:0.009096s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19584548 ORDER BY `unit` DESC [ RunTime:0.003526s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19584548 LIMIT 2 [ RunTime:0.015793s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19584548 ORDER BY `minOrder` ASC [ RunTime:0.017839s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19583869 LIMIT 5 [ RunTime:0.005041s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19583869 ORDER BY `minOrder` ASC [ RunTime:0.005567s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19583869 ORDER BY `unit` DESC [ RunTime:0.000716s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19583869 LIMIT 2 [ RunTime:0.013704s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19583869 ORDER BY `minOrder` ASC [ RunTime:0.007818s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19583868 LIMIT 5 [ RunTime:0.005985s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19583868 ORDER BY `minOrder` ASC [ RunTime:0.000674s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19583868 ORDER BY `unit` DESC [ RunTime:0.000689s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19583868 LIMIT 2 [ RunTime:0.003999s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19583868 ORDER BY `minOrder` ASC [ RunTime:0.001740s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19583858 LIMIT 5 [ RunTime:0.000938s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19583858 ORDER BY `minOrder` ASC [ RunTime:0.007148s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19583858 ORDER BY `unit` DESC [ RunTime:0.000656s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19583858 LIMIT 2 [ RunTime:0.006302s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19583858 ORDER BY `minOrder` ASC [ RunTime:0.009387s ]
select * from pdf where partno='BSMV6X-L' and brandshort='Panduit Corp' limit 1 [ RunTime:0.007687s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19583824 LIMIT 5 [ RunTime:0.001377s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19583824 ORDER BY `minOrder` ASC [ RunTime:0.004668s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19583824 ORDER BY `unit` DESC [ RunTime:0.008494s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19583824 LIMIT 2 [ RunTime:0.008249s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19583824 ORDER BY `minOrder` ASC [ RunTime:0.007041s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19583821 LIMIT 5 [ RunTime:0.019147s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19583821 ORDER BY `minOrder` ASC [ RunTime:0.008512s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19583821 ORDER BY `unit` DESC [ RunTime:0.011491s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19583821 LIMIT 2 [ RunTime:0.009754s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19583821 ORDER BY `minOrder` ASC [ RunTime:0.022397s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19583820 LIMIT 5 [ RunTime:0.041109s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19583820 ORDER BY `minOrder` ASC [ RunTime:0.016112s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19583820 ORDER BY `unit` DESC [ RunTime:0.008871s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19583820 LIMIT 2 [ RunTime:0.019492s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19583820 ORDER BY `minOrder` ASC [ RunTime:0.001377s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19583751 LIMIT 5 [ RunTime:0.013337s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19583751 ORDER BY `minOrder` ASC [ RunTime:0.003184s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19583751 ORDER BY `unit` DESC [ RunTime:0.002717s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19583751 LIMIT 2 [ RunTime:0.000736s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19583751 ORDER BY `minOrder` ASC [ RunTime:0.000648s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19583750 LIMIT 5 [ RunTime:0.003700s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19583750 ORDER BY `minOrder` ASC [ RunTime:0.007418s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19583750 ORDER BY `unit` DESC [ RunTime:0.000747s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19583750 LIMIT 2 [ RunTime:0.000707s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19583750 ORDER BY `minOrder` ASC [ RunTime:0.000679s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19583730 LIMIT 5 [ RunTime:0.005206s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19583730 ORDER BY `minOrder` ASC [ RunTime:0.000657s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19583730 ORDER BY `unit` DESC [ RunTime:0.011615s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19583730 LIMIT 2 [ RunTime:0.008643s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19583730 ORDER BY `minOrder` ASC [ RunTime:0.002917s ]
select * from pdf where partno='BSMV2BX-M' and brandshort='Panduit Corp' limit 1 [ RunTime:0.000698s ]
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` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'BSM%' OR `brand` LIKE 'BSM%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.004179s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51027222 LIMIT 5 [ RunTime:0.010744s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51027222 ORDER BY `minOrder` ASC [ RunTime:0.001912s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51027222 ORDER BY `unit` DESC [ RunTime:0.003655s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51027222 LIMIT 2 [ RunTime:0.002638s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51027222 ORDER BY `minOrder` ASC [ RunTime:0.004102s ]
select * from pdf where partno='bsm250d17p2e004' and brandshort='rohm semiconductor' limit 1 [ RunTime:0.000651s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'bsm250d17p2e004' OR `brand` LIKE 'rohm semiconductor%' ) ) LIMIT 1 [ RunTime:0.002000s ]
SELECT `id` FROM `stock` WHERE `id` <> 51027222 AND `partno` = 'bsm250d17p2e004' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%rohm semiconductor%' ) [ RunTime:0.001095s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58703652 [ RunTime:0.000662s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51028787 LIMIT 5 [ RunTime:0.001514s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51028787 ORDER BY `minOrder` ASC [ RunTime:0.001165s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51028787 ORDER BY `unit` DESC [ RunTime:0.000716s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51028787 LIMIT 2 [ RunTime:0.003322s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51028787 ORDER BY `minOrder` ASC [ RunTime:0.000656s ]
select * from pdf where partno='bsm120d12p2c005' and brandshort='rohm semiconductor' limit 1 [ RunTime:0.002965s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'bsm120d12p2c005' OR `brand` LIKE 'rohm semiconductor%' ) ) LIMIT 1 [ RunTime:0.000766s ]
SELECT `id` FROM `stock` WHERE `id` <> 51028787 AND `partno` = 'bsm120d12p2c005' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%rohm semiconductor%' ) [ RunTime:0.001428s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58703334 [ RunTime:0.002099s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51026532 LIMIT 5 [ RunTime:0.007160s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51026532 ORDER BY `minOrder` ASC [ RunTime:0.005798s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51026532 ORDER BY `unit` DESC [ RunTime:0.003123s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51026532 LIMIT 2 [ RunTime:0.002533s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51026532 ORDER BY `minOrder` ASC [ RunTime:0.008072s ]
select * from pdf where partno='bsm180d12p3c007' and brandshort='rohm semiconductor' limit 1 [ RunTime:0.000984s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'bsm180d12p3c007' OR `brand` LIKE 'rohm semiconductor%' ) ) LIMIT 1 [ RunTime:0.001651s ]
SELECT `id` FROM `stock` WHERE `id` <> 51026532 AND `partno` = 'bsm180d12p3c007' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%rohm semiconductor%' ) [ RunTime:0.003701s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58703337 [ RunTime:0.003082s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51027138 LIMIT 5 [ RunTime:0.002645s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51027138 ORDER BY `minOrder` ASC [ RunTime:0.008056s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51027138 ORDER BY `unit` DESC [ RunTime:0.000664s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51027138 LIMIT 2 [ RunTime:0.000520s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51027138 ORDER BY `minOrder` ASC [ RunTime:0.002478s ]
select * from pdf where partno='bsm600d12p4g103' and brandshort='rohm semiconductor' limit 1 [ RunTime:0.004042s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'bsm600d12p4g103' OR `brand` LIKE 'rohm semiconductor%' ) ) LIMIT 1 [ RunTime:0.001131s ]
SELECT `id` FROM `stock` WHERE `id` <> 51027138 AND `partno` = 'bsm600d12p4g103' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%rohm semiconductor%' ) [ RunTime:0.002486s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58703121 [ RunTime:0.002376s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51027137 LIMIT 5 [ RunTime:0.004069s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51027137 ORDER BY `minOrder` ASC [ RunTime:0.001609s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51027137 ORDER BY `unit` DESC [ RunTime:0.000831s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51027137 LIMIT 2 [ RunTime:0.002669s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51027137 ORDER BY `minOrder` ASC [ RunTime:0.002877s ]
select * from pdf where partno='bsm450d12p4g102' and brandshort='rohm semiconductor' limit 1 [ RunTime:0.000888s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'bsm450d12p4g102' OR `brand` LIKE 'rohm semiconductor%' ) ) LIMIT 1 [ RunTime:0.000968s ]
SELECT `id` FROM `stock` WHERE `id` <> 51027137 AND `partno` = 'bsm450d12p4g102' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%rohm semiconductor%' ) [ RunTime:0.004645s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58705579 [ RunTime:0.000772s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51027136 LIMIT 5 [ RunTime:0.004295s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51027136 ORDER BY `minOrder` ASC [ RunTime:0.001593s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51027136 ORDER BY `unit` DESC [ RunTime:0.001832s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51027136 LIMIT 2 [ RunTime:0.001148s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51027136 ORDER BY `minOrder` ASC [ RunTime:0.002424s ]
select * from pdf where partno='bsm300d12p4g101' and brandshort='rohm semiconductor' limit 1 [ RunTime:0.001601s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'bsm300d12p4g101' OR `brand` LIKE 'rohm semiconductor%' ) ) LIMIT 1 [ RunTime:0.000789s ]
SELECT `id` FROM `stock` WHERE `id` <> 51027136 AND `partno` = 'bsm300d12p4g101' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%rohm semiconductor%' ) [ RunTime:0.001057s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58703026 [ RunTime:0.002740s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51026849 LIMIT 5 [ RunTime:0.001457s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51026849 ORDER BY `minOrder` ASC [ RunTime:0.002928s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51026849 ORDER BY `unit` DESC [ RunTime:0.000742s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51026849 LIMIT 2 [ RunTime:0.003977s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51026849 ORDER BY `minOrder` ASC [ RunTime:0.006981s ]
select * from pdf where partno='bsm300d12p3e005' and brandshort='rohm semiconductor' limit 1 [ RunTime:0.007113s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'bsm300d12p3e005' OR `brand` LIKE 'rohm semiconductor%' ) ) LIMIT 1 [ RunTime:0.003784s ]
SELECT `id` FROM `stock` WHERE `id` <> 51026849 AND `partno` = 'bsm300d12p3e005' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%rohm semiconductor%' ) [ RunTime:0.002490s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58703345 [ RunTime:0.002933s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51026814 LIMIT 5 [ RunTime:0.003330s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51026814 ORDER BY `minOrder` ASC [ RunTime:0.003021s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51026814 ORDER BY `unit` DESC [ RunTime:0.000612s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51026814 LIMIT 2 [ RunTime:0.001612s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51026814 ORDER BY `minOrder` ASC [ RunTime:0.002920s ]
select * from pdf where partno='bsm300c12p3e201' and brandshort='rohm semiconductor' limit 1 [ RunTime:0.006234s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'bsm300c12p3e201' OR `brand` LIKE 'rohm semiconductor%' ) ) LIMIT 1 [ RunTime:0.005092s ]
SELECT `id` FROM `stock` WHERE `id` <> 51026814 AND `partno` = 'bsm300c12p3e201' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%rohm semiconductor%' ) [ RunTime:0.005243s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 44065596 [ RunTime:0.006518s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51026787 LIMIT 5 [ RunTime:0.002815s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51026787 ORDER BY `minOrder` ASC [ RunTime:0.006213s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51026787 ORDER BY `unit` DESC [ RunTime:0.001117s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51026787 LIMIT 2 [ RunTime:0.002789s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51026787 ORDER BY `minOrder` ASC [ RunTime:0.008406s ]
select * from pdf where partno='bsm180c12p2e202' and brandshort='rohm semiconductor' limit 1 [ RunTime:0.001532s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'bsm180c12p2e202' OR `brand` LIKE 'rohm semiconductor%' ) ) LIMIT 1 [ RunTime:0.002206s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51026737 LIMIT 5 [ RunTime:0.003390s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51026737 ORDER BY `minOrder` ASC [ RunTime:0.006073s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51026737 ORDER BY `unit` DESC [ RunTime:0.000607s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51026737 LIMIT 2 [ RunTime:0.000695s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51026737 ORDER BY `minOrder` ASC [ RunTime:0.002494s ]
select * from pdf where partno='bsm400c12p3g202' and brandshort='rohm semiconductor' limit 1 [ RunTime:0.001165s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'bsm400c12p3g202' OR `brand` LIKE 'rohm semiconductor%' ) ) LIMIT 1 [ RunTime:0.001449s ]
SELECT `id` FROM `stock` WHERE `id` <> 51026737 AND `partno` = 'bsm400c12p3g202' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%rohm semiconductor%' ) [ RunTime:0.000877s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 44065597 [ RunTime:0.003358s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51026633 LIMIT 5 [ RunTime:0.005994s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51026633 ORDER BY `minOrder` ASC [ RunTime:0.002728s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51026633 ORDER BY `unit` DESC [ RunTime:0.001941s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51026633 LIMIT 2 [ RunTime:0.003109s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51026633 ORDER BY `minOrder` ASC [ RunTime:0.006070s ]
select * from pdf where partno='bsm600d12p3g001' and brandshort='rohm semiconductor' limit 1 [ RunTime:0.000988s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'bsm600d12p3g001' OR `brand` LIKE 'rohm semiconductor%' ) ) LIMIT 1 [ RunTime:0.001445s ]
SELECT `id` FROM `stock` WHERE `id` <> 51026633 AND `partno` = 'bsm600d12p3g001' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%rohm semiconductor%' ) [ RunTime:0.000856s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51026533 LIMIT 5 [ RunTime:0.002927s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51026533 ORDER BY `minOrder` ASC [ RunTime:0.006555s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51026533 ORDER BY `unit` DESC [ RunTime:0.000668s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51026533 LIMIT 2 [ RunTime:0.004229s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51026533 ORDER BY `minOrder` ASC [ RunTime:0.003396s ]
select * from pdf where partno='bsm300d12p2e001' and brandshort='rohm semiconductor' limit 1 [ RunTime:0.007355s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'bsm300d12p2e001' OR `brand` LIKE 'rohm semiconductor%' ) ) LIMIT 1 [ RunTime:0.005495s ]
SELECT `id` FROM `stock` WHERE `id` <> 51026533 AND `partno` = 'bsm300d12p2e001' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%rohm semiconductor%' ) [ RunTime:0.001073s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58703027 [ RunTime:0.007645s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51026917 LIMIT 5 [ RunTime:0.000653s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51026917 ORDER BY `minOrder` ASC [ RunTime:0.006398s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51026917 ORDER BY `unit` DESC [ RunTime:0.004929s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51026917 LIMIT 2 [ RunTime:0.006969s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51026917 ORDER BY `minOrder` ASC [ RunTime:0.000688s ]
select * from pdf where partno='bsm180d12p2c101' and brandshort='rohm semiconductor' limit 1 [ RunTime:0.001006s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'bsm180d12p2c101' OR `brand` LIKE 'rohm semiconductor%' ) ) LIMIT 1 [ RunTime:0.001501s ]
SELECT `id` FROM `stock` WHERE `id` <> 51026917 AND `partno` = 'bsm180d12p2c101' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%rohm semiconductor%' ) [ RunTime:0.000900s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58705561 [ RunTime:0.000672s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51026852 LIMIT 5 [ RunTime:0.010017s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51026852 ORDER BY `minOrder` ASC [ RunTime:0.007793s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51026852 ORDER BY `unit` DESC [ RunTime:0.000693s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51026852 LIMIT 2 [ RunTime:0.000637s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51026852 ORDER BY `minOrder` ASC [ RunTime:0.000675s ]
select * from pdf where partno='bsm400d12p3g002' and brandshort='rohm semiconductor' limit 1 [ RunTime:0.001487s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'bsm400d12p3g002' OR `brand` LIKE 'rohm semiconductor%' ) ) LIMIT 1 [ RunTime:0.007776s ]
SELECT `id` FROM `stock` WHERE `id` <> 51026852 AND `partno` = 'bsm400d12p3g002' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%rohm semiconductor%' ) [ RunTime:0.000988s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58703344 [ RunTime:0.002759s ]
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` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'BSM%' OR `brand` LIKE 'BSM%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.007550s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58713934 LIMIT 5 [ RunTime:0.000480s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58713934 ORDER BY `minOrder` ASC [ RunTime:0.002046s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58713934 ORDER BY `unit` DESC [ RunTime:0.000446s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58713934 LIMIT 2 [ RunTime:0.000350s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58713934 ORDER BY `minOrder` ASC [ RunTime:0.000626s ]
select * from pdf where partno='BSM100GB120DN2HOSA1' and brandshort='Infineon Technologies' limit 1 [ RunTime:0.001134s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BSM100GB120DN2HOSA1' OR `brand` LIKE 'Infineon Technologies%' ) ) LIMIT 1 [ RunTime:0.000514s ]
SELECT `id` FROM `stock` WHERE `id` <> 58713934 AND `partno` = 'BSM100GB120DN2HOSA1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%infineon technologies%' ) [ RunTime:0.000535s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58104913 LIMIT 5 [ RunTime:0.000427s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58104913 ORDER BY `minOrder` ASC [ RunTime:0.000861s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58104913 ORDER BY `unit` DESC [ RunTime:0.002555s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58104913 LIMIT 2 [ RunTime:0.001598s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58104913 ORDER BY `minOrder` ASC [ RunTime:0.001438s ]
select * from pdf where partno='BSM' and brandshort='MPD Memory Protection Devices' limit 1 [ RunTime:0.001167s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BSM' OR `brand` LIKE 'MPD (Memory Protection Devices)%' ) ) LIMIT 1 [ RunTime:0.000761s ]
SELECT `id` FROM `stock` WHERE `id` <> 58104913 AND `partno` = 'BSM' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%mpd%' ) [ RunTime:0.000568s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14274106 [ RunTime:0.000466s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 41589857 LIMIT 5 [ RunTime:0.000721s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41589857 ORDER BY `minOrder` ASC [ RunTime:0.001035s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 41589857 ORDER BY `unit` DESC [ RunTime:0.000676s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 41589857 LIMIT 2 [ RunTime:0.000397s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41589857 ORDER BY `minOrder` ASC [ RunTime:0.003770s ]
select * from pdf where partno='BSM400S-19' and brandshort='Astrodyne TDI' limit 1 [ RunTime:0.001108s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BSM400S-19' OR `brand` LIKE 'Astrodyne TDI%' ) ) LIMIT 1 [ RunTime:0.000604s ]
SELECT `id` FROM `stock` WHERE `id` <> 41589857 AND `partno` = 'BSM400S-19' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%astrodyne tdi%' ) [ RunTime:0.000558s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12088771 [ RunTime:0.000682s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58713867 LIMIT 5 [ RunTime:0.001523s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58713867 ORDER BY `minOrder` ASC [ RunTime:0.000478s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58713867 ORDER BY `unit` DESC [ RunTime:0.000565s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58713867 LIMIT 2 [ RunTime:0.003640s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58713867 ORDER BY `minOrder` ASC [ RunTime:0.001273s ]
select * from pdf where partno='BSM100GB120DN2KHOSA1' and brandshort='Infineon Technologies' limit 1 [ RunTime:0.001089s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BSM100GB120DN2KHOSA1' OR `brand` LIKE 'Infineon Technologies%' ) ) LIMIT 1 [ RunTime:0.000752s ]
SELECT `id` FROM `stock` WHERE `id` <> 58713867 AND `partno` = 'BSM100GB120DN2KHOSA1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%infineon technologies%' ) [ RunTime:0.000476s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58713932 LIMIT 5 [ RunTime:0.000561s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58713932 ORDER BY `minOrder` ASC [ RunTime:0.000427s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58713932 ORDER BY `unit` DESC [ RunTime:0.000355s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58713932 LIMIT 2 [ RunTime:0.002383s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58713932 ORDER BY `minOrder` ASC [ RunTime:0.002128s ]
select * from pdf where partno='BSM100GB120DLCHOSA1' and brandshort='Infineon Technologies' limit 1 [ RunTime:0.000974s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BSM100GB120DLCHOSA1' OR `brand` LIKE 'Infineon Technologies%' ) ) LIMIT 1 [ RunTime:0.001747s ]
SELECT `id` FROM `stock` WHERE `id` <> 58713932 AND `partno` = 'BSM100GB120DLCHOSA1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%infineon technologies%' ) [ RunTime:0.000990s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58713837 LIMIT 5 [ RunTime:0.000389s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58713837 ORDER BY `minOrder` ASC [ RunTime:0.000388s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58713837 ORDER BY `unit` DESC [ RunTime:0.000559s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58713837 LIMIT 2 [ RunTime:0.000375s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58713837 ORDER BY `minOrder` ASC [ RunTime:0.001499s ]
select * from pdf where partno='BSM50GP60B2BOSA1' and brandshort='Infineon Technologies' limit 1 [ RunTime:0.001077s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BSM50GP60B2BOSA1' OR `brand` LIKE 'Infineon Technologies%' ) ) LIMIT 1 [ RunTime:0.000496s ]
SELECT `id` FROM `stock` WHERE `id` <> 58713837 AND `partno` = 'BSM50GP60B2BOSA1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%infineon technologies%' ) [ RunTime:0.000451s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58713850 LIMIT 5 [ RunTime:0.000549s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58713850 ORDER BY `minOrder` ASC [ RunTime:0.000374s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58713850 ORDER BY `unit` DESC [ RunTime:0.000382s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58713850 LIMIT 2 [ RunTime:0.001585s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58713850 ORDER BY `minOrder` ASC [ RunTime:0.002674s ]
select * from pdf where partno='BSM100GB120DN2FE325HOSA1' and brandshort='Infineon Technologies' limit 1 [ RunTime:0.001164s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BSM100GB120DN2FE325HOSA1' OR `brand` LIKE 'Infineon Technologies%' ) ) LIMIT 1 [ RunTime:0.001679s ]
SELECT `id` FROM `stock` WHERE `id` <> 58713850 AND `partno` = 'BSM100GB120DN2FE325HOSA1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%infineon technologies%' ) [ RunTime:0.001402s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58713933 LIMIT 5 [ RunTime:0.000368s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58713933 ORDER BY `minOrder` ASC [ RunTime:0.000401s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58713933 ORDER BY `unit` DESC [ RunTime:0.000584s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58713933 LIMIT 2 [ RunTime:0.000422s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58713933 ORDER BY `minOrder` ASC [ RunTime:0.001583s ]
select * from pdf where partno='BSM300GB120DLCE3256HOSA1' and brandshort='Infineon Technologies' limit 1 [ RunTime:0.001105s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BSM300GB120DLCE3256HOSA1' OR `brand` LIKE 'Infineon Technologies%' ) ) LIMIT 1 [ RunTime:0.000498s ]
SELECT `id` FROM `stock` WHERE `id` <> 58713933 AND `partno` = 'BSM300GB120DLCE3256HOSA1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%infineon technologies%' ) [ RunTime:0.000544s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58713840 LIMIT 5 [ RunTime:0.000371s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58713840 ORDER BY `minOrder` ASC [ RunTime:0.000368s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58713840 ORDER BY `unit` DESC [ RunTime:0.000363s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58713840 LIMIT 2 [ RunTime:0.001779s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58713840 ORDER BY `minOrder` ASC [ RunTime:0.003227s ]
select * from pdf where partno='BSM10GP60BOSA1' and brandshort='Infineon Technologies' limit 1 [ RunTime:0.001084s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BSM10GP60BOSA1' OR `brand` LIKE 'Infineon Technologies%' ) ) LIMIT 1 [ RunTime:0.001696s ]
SELECT `id` FROM `stock` WHERE `id` <> 58713840 AND `partno` = 'BSM10GP60BOSA1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%infineon technologies%' ) [ RunTime:0.001909s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58714521 LIMIT 5 [ RunTime:0.000461s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58714521 ORDER BY `minOrder` ASC [ RunTime:0.000891s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58714521 ORDER BY `unit` DESC [ RunTime:0.000490s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58714521 LIMIT 2 [ RunTime:0.000423s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58714521 ORDER BY `minOrder` ASC [ RunTime:0.001725s ]
select * from pdf where partno='BSM20GD60DLC' and brandshort='Infineon Technologies' limit 1 [ RunTime:0.001145s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BSM20GD60DLC' OR `brand` LIKE 'Infineon Technologies%' ) ) LIMIT 1 [ RunTime:0.000518s ]
SELECT `id` FROM `stock` WHERE `id` <> 58714521 AND `partno` = 'BSM20GD60DLC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%infineon technologies%' ) [ RunTime:0.000547s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58618616 LIMIT 5 [ RunTime:0.000446s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58618616 ORDER BY `minOrder` ASC [ RunTime:0.000978s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58618616 ORDER BY `unit` DESC [ RunTime:0.000449s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58618616 LIMIT 2 [ RunTime:0.001778s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58618616 ORDER BY `minOrder` ASC [ RunTime:0.003997s ]
select * from pdf where partno='BSM300GA160DN13CB7HOSA1' and brandshort='Infineon Technologies' limit 1 [ RunTime:0.001578s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BSM300GA160DN13CB7HOSA1' OR `brand` LIKE 'Infineon Technologies%' ) ) LIMIT 1 [ RunTime:0.002433s ]
SELECT `id` FROM `stock` WHERE `id` <> 58618616 AND `partno` = 'BSM300GA160DN13CB7HOSA1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%infineon technologies%' ) [ RunTime:0.000573s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 41591877 LIMIT 5 [ RunTime:0.000688s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41591877 ORDER BY `minOrder` ASC [ RunTime:0.000898s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 41591877 ORDER BY `unit` DESC [ RunTime:0.000434s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 41591877 LIMIT 2 [ RunTime:0.002016s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41591877 ORDER BY `minOrder` ASC [ RunTime:0.003627s ]
select * from pdf where partno='BSM200S-18' and brandshort='Astrodyne TDI' limit 1 [ RunTime:0.001230s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BSM200S-18' OR `brand` LIKE 'Astrodyne TDI%' ) ) LIMIT 1 [ RunTime:0.001833s ]
SELECT `id` FROM `stock` WHERE `id` <> 41591877 AND `partno` = 'BSM200S-18' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%astrodyne tdi%' ) [ RunTime:0.000602s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12093621 [ RunTime:0.000428s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58701192 LIMIT 5 [ RunTime:0.000484s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58701192 ORDER BY `minOrder` ASC [ RunTime:0.001889s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58701192 ORDER BY `unit` DESC [ RunTime:0.000422s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58701192 LIMIT 2 [ RunTime:0.002123s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58701192 ORDER BY `minOrder` ASC [ RunTime:0.000401s ]
select * from pdf where partno='BSM080D12P2C008' and brandshort='Rohm Semiconductor' limit 1 [ RunTime:0.000945s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BSM080D12P2C008' OR `brand` LIKE 'Rohm Semiconductor%' ) ) LIMIT 1 [ RunTime:0.003387s ]
SELECT `id` FROM `stock` WHERE `id` <> 58701192 AND `partno` = 'BSM080D12P2C008' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%rohm semiconductor%' ) [ RunTime:0.000498s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58714023 LIMIT 5 [ RunTime:0.000388s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58714023 ORDER BY `minOrder` ASC [ RunTime:0.000408s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58714023 ORDER BY `unit` DESC [ RunTime:0.000424s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58714023 LIMIT 2 [ RunTime:0.001902s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58714023 ORDER BY `minOrder` ASC [ RunTime:0.004038s ]
select * from pdf where partno='BSM200GB170DLCE3256HDLA1' and brandshort='Infineon Technologies' limit 1 [ RunTime:0.001198s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BSM200GB170DLCE3256HDLA1' OR `brand` LIKE 'Infineon Technologies%' ) ) LIMIT 1 [ RunTime:0.001866s ]
SELECT `id` FROM `stock` WHERE `id` <> 58714023 AND `partno` = 'BSM200GB170DLCE3256HDLA1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%infineon technologies%' ) [ RunTime:0.003171s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58713912 LIMIT 5 [ RunTime:0.000695s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58713912 ORDER BY `minOrder` ASC [ RunTime:0.000448s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58713912 ORDER BY `unit` DESC [ RunTime:0.003058s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58713912 LIMIT 2 [ RunTime:0.003882s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58713912 ORDER BY `minOrder` ASC [ RunTime:0.000410s ]
select * from pdf where partno='BSM300GA170DLS' and brandshort='Infineon Technologies' limit 1 [ RunTime:0.001193s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BSM300GA170DLS' OR `brand` LIKE 'Infineon Technologies%' ) ) LIMIT 1 [ RunTime:0.003573s ]
SELECT `id` FROM `stock` WHERE `id` <> 58713912 AND `partno` = 'BSM300GA170DLS' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%infineon technologies%' ) [ RunTime:0.000627s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58714015 LIMIT 5 [ RunTime:0.000389s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58714015 ORDER BY `minOrder` ASC [ RunTime:0.000396s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58714015 ORDER BY `unit` DESC [ RunTime:0.000448s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58714015 LIMIT 2 [ RunTime:0.001318s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58714015 ORDER BY `minOrder` ASC [ RunTime:0.000364s ]
select * from pdf where partno='BSM100GB120DN2S7HOSA1' and brandshort='Infineon Technologies' limit 1 [ RunTime:0.001124s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BSM100GB120DN2S7HOSA1' OR `brand` LIKE 'Infineon Technologies%' ) ) LIMIT 1 [ RunTime:0.005311s ]
SELECT `id` FROM `stock` WHERE `id` <> 58714015 AND `partno` = 'BSM100GB120DN2S7HOSA1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%infineon technologies%' ) [ RunTime:0.000551s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58714577 LIMIT 5 [ RunTime:0.000405s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58714577 ORDER BY `minOrder` ASC [ RunTime:0.000400s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58714577 ORDER BY `unit` DESC [ RunTime:0.000372s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58714577 LIMIT 2 [ RunTime:0.000343s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58714577 ORDER BY `minOrder` ASC [ RunTime:0.000367s ]
select * from pdf where partno='BSM75GB120DN2_E3223C-SE' and brandshort='Infineon Technologies' limit 1 [ RunTime:0.001207s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BSM75GB120DN2_E3223C-SE' OR `brand` LIKE 'Infineon Technologies%' ) ) LIMIT 1 [ RunTime:0.000483s ]
SELECT `id` FROM `stock` WHERE `id` <> 58714577 AND `partno` = 'BSM75GB120DN2_E3223C-SE' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%infineon technologies%' ) [ RunTime:0.005022s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58714613 LIMIT 5 [ RunTime:0.000480s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58714613 ORDER BY `minOrder` ASC [ RunTime:0.000677s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58714613 ORDER BY `unit` DESC [ RunTime:0.000432s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58714613 LIMIT 2 [ RunTime:0.000997s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58714613 ORDER BY `minOrder` ASC [ RunTime:0.000387s ]
select * from pdf where partno='BSM200GB170DLCHOSA1' and brandshort='Infineon Technologies' limit 1 [ RunTime:0.001139s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BSM200GB170DLCHOSA1' OR `brand` LIKE 'Infineon Technologies%' ) ) LIMIT 1 [ RunTime:0.000560s ]
SELECT `id` FROM `stock` WHERE `id` <> 58714613 AND `partno` = 'BSM200GB170DLCHOSA1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%infineon technologies%' ) [ RunTime:0.000514s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58714527 LIMIT 5 [ RunTime:0.000404s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58714527 ORDER BY `minOrder` ASC [ RunTime:0.000371s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58714527 ORDER BY `unit` DESC [ RunTime:0.000375s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58714527 LIMIT 2 [ RunTime:0.000343s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58714527 ORDER BY `minOrder` ASC [ RunTime:0.000882s ]
select * from pdf where partno='BSM25GB120DN2' and brandshort='Infineon Technologies' limit 1 [ RunTime:0.001422s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BSM25GB120DN2' OR `brand` LIKE 'Infineon Technologies%' ) ) LIMIT 1 [ RunTime:0.000484s ]
SELECT `id` FROM `stock` WHERE `id` <> 58714527 AND `partno` = 'BSM25GB120DN2' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%infineon technologies%' ) [ RunTime:0.000461s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58714568 LIMIT 5 [ RunTime:0.000428s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58714568 ORDER BY `minOrder` ASC [ RunTime:0.000369s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58714568 ORDER BY `unit` DESC [ RunTime:0.000365s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58714568 LIMIT 2 [ RunTime:0.000433s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58714568 ORDER BY `minOrder` ASC [ RunTime:0.000358s ]
select * from pdf where partno='BSM100GB120DN2B2HOSA1' and brandshort='Infineon Technologies' limit 1 [ RunTime:0.001029s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BSM100GB120DN2B2HOSA1' OR `brand` LIKE 'Infineon Technologies%' ) ) LIMIT 1 [ RunTime:0.001752s ]
SELECT `id` FROM `stock` WHERE `id` <> 58714568 AND `partno` = 'BSM100GB120DN2B2HOSA1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%infineon technologies%' ) [ RunTime:0.000549s ]
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` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'BSM%' OR `brand` LIKE 'BSM%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000736s ]
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` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'BSM%' OR `brand` LIKE 'BSM%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000642s ]
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` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'BSM%' OR `brand` LIKE 'BSM%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000634s ]
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` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'BSM%' OR `brand` LIKE 'BSM%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.004180s ]
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` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'BSM%' OR `brand` LIKE 'BSM%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001014s ]
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` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'BSM%' OR `brand` LIKE 'BSM%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003775s ]
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` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'BSM%' OR `brand` LIKE 'BSM%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.006183s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58021621 LIMIT 5 [ RunTime:0.000431s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58021621 ORDER BY `minOrder` ASC [ RunTime:0.001167s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58021621 ORDER BY `unit` DESC [ RunTime:0.000582s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58021621 LIMIT 2 [ RunTime:0.000354s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58021621 ORDER BY `minOrder` ASC [ RunTime:0.000391s ]
select * from pdf where partno='BSMD0603-050-6V' and brandshort='BHFUSE' limit 1 [ RunTime:0.001131s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BSMD0603-050-6V' OR `brand` LIKE 'BHFUSE(佰宏)%' ) ) LIMIT 1 [ RunTime:0.001278s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58021518 LIMIT 5 [ RunTime:0.000424s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58021518 ORDER BY `minOrder` ASC [ RunTime:0.000681s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58021518 ORDER BY `unit` DESC [ RunTime:0.000447s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58021518 LIMIT 2 [ RunTime:0.000343s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58021518 ORDER BY `minOrder` ASC [ RunTime:0.002167s ]
select * from pdf where partno='BSMD1206-100-30V' and brandshort='BHFUSE' limit 1 [ RunTime:0.001270s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BSMD1206-100-30V' OR `brand` LIKE 'BHFUSE(佰宏)%' ) ) LIMIT 1 [ RunTime:0.000753s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58021493 LIMIT 5 [ RunTime:0.000522s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58021493 ORDER BY `minOrder` ASC [ RunTime:0.000942s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58021493 ORDER BY `unit` DESC [ RunTime:0.000379s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58021493 LIMIT 2 [ RunTime:0.000355s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58021493 ORDER BY `minOrder` ASC [ RunTime:0.000376s ]
select * from pdf where partno='BSMD1812-200-30V' and brandshort='BHFUSE' limit 1 [ RunTime:0.001098s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BSMD1812-200-30V' OR `brand` LIKE 'BHFUSE(佰宏)%' ) ) LIMIT 1 [ RunTime:0.000958s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58021505 LIMIT 5 [ RunTime:0.000406s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58021505 ORDER BY `minOrder` ASC [ RunTime:0.000454s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58021505 ORDER BY `unit` DESC [ RunTime:0.000671s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58021505 LIMIT 2 [ RunTime:0.000374s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58021505 ORDER BY `minOrder` ASC [ RunTime:0.001873s ]
select * from pdf where partno='BSMD0603-010-33V' and brandshort='BHFUSE' limit 1 [ RunTime:0.001040s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BSMD0603-010-33V' OR `brand` LIKE 'BHFUSE(佰宏)%' ) ) LIMIT 1 [ RunTime:0.001680s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58021503 LIMIT 5 [ RunTime:0.000390s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58021503 ORDER BY `minOrder` ASC [ RunTime:0.000390s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58021503 ORDER BY `unit` DESC [ RunTime:0.000613s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58021503 LIMIT 2 [ RunTime:0.000365s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58021503 ORDER BY `minOrder` ASC [ RunTime:0.001569s ]
select * from pdf where partno='BSMD0805-050-24V' and brandshort='BHFUSE' limit 1 [ RunTime:0.002337s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BSMD0805-050-24V' OR `brand` LIKE 'BHFUSE(佰宏)%' ) ) LIMIT 1 [ RunTime:0.006962s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58021661 LIMIT 5 [ RunTime:0.000765s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58021661 ORDER BY `minOrder` ASC [ RunTime:0.001194s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58021661 ORDER BY `unit` DESC [ RunTime:0.000870s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58021661 LIMIT 2 [ RunTime:0.000681s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58021661 ORDER BY `minOrder` ASC [ RunTime:0.002447s ]
select * from pdf where partno='BSMD0603L-150' and brandshort='BHFUSE' limit 1 [ RunTime:0.001178s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BSMD0603L-150' OR `brand` LIKE 'BHFUSE(佰宏)%' ) ) LIMIT 1 [ RunTime:0.001710s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58021774 LIMIT 5 [ RunTime:0.000665s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58021774 ORDER BY `minOrder` ASC [ RunTime:0.001081s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58021774 ORDER BY `unit` DESC [ RunTime:0.000847s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58021774 LIMIT 2 [ RunTime:0.000605s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58021774 ORDER BY `minOrder` ASC [ RunTime:0.002357s ]
select * from pdf where partno='BSMD1812-200-33V' and brandshort='BHFUSE' limit 1 [ RunTime:0.004270s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BSMD1812-200-33V' OR `brand` LIKE 'BHFUSE(佰宏)%' ) ) LIMIT 1 [ RunTime:0.001402s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58021831 LIMIT 5 [ RunTime:0.002142s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58021831 ORDER BY `minOrder` ASC [ RunTime:0.002324s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58021831 ORDER BY `unit` DESC [ RunTime:0.001106s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58021831 LIMIT 2 [ RunTime:0.000534s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58021831 ORDER BY `minOrder` ASC [ RunTime:0.000578s ]
select * from pdf where partno='BSMD0603-075-6V' and brandshort='BHFUSE' limit 1 [ RunTime:0.000921s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BSMD0603-075-6V' OR `brand` LIKE 'BHFUSE(佰宏)%' ) ) LIMIT 1 [ RunTime:0.001680s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58021506 LIMIT 5 [ RunTime:0.000668s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58021506 ORDER BY `minOrder` ASC [ RunTime:0.000600s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58021506 ORDER BY `unit` DESC [ RunTime:0.000648s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58021506 LIMIT 2 [ RunTime:0.000579s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58021506 ORDER BY `minOrder` ASC [ RunTime:0.002378s ]
select * from pdf where partno='BSMD1206-100-24V' and brandshort='BHFUSE' limit 1 [ RunTime:0.004913s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BSMD1206-100-24V' OR `brand` LIKE 'BHFUSE(佰宏)%' ) ) LIMIT 1 [ RunTime:0.003547s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58021701 LIMIT 5 [ RunTime:0.003615s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58021701 ORDER BY `minOrder` ASC [ RunTime:0.000627s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58021701 ORDER BY `unit` DESC [ RunTime:0.000686s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58021701 LIMIT 2 [ RunTime:0.001273s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58021701 ORDER BY `minOrder` ASC [ RunTime:0.004142s ]
select * from pdf where partno='BSMD1206-150-16V' and brandshort='BHFUSE' limit 1 [ RunTime:0.000941s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BSMD1206-150-16V' OR `brand` LIKE 'BHFUSE(佰宏)%' ) ) LIMIT 1 [ RunTime:0.006187s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58021625 LIMIT 5 [ RunTime:0.000821s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58021625 ORDER BY `minOrder` ASC [ RunTime:0.000725s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58021625 ORDER BY `unit` DESC [ RunTime:0.000676s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58021625 LIMIT 2 [ RunTime:0.002551s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58021625 ORDER BY `minOrder` ASC [ RunTime:0.005475s ]
select * from pdf where partno='BSMD0805-005-60V' and brandshort='BHFUSE' limit 1 [ RunTime:0.000976s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BSMD0805-005-60V' OR `brand` LIKE 'BHFUSE(佰宏)%' ) ) LIMIT 1 [ RunTime:0.002476s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58021622 LIMIT 5 [ RunTime:0.000769s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58021622 ORDER BY `minOrder` ASC [ RunTime:0.000696s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58021622 ORDER BY `unit` DESC [ RunTime:0.001643s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58021622 LIMIT 2 [ RunTime:0.004041s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58021622 ORDER BY `minOrder` ASC [ RunTime:0.001709s ]
select * from pdf where partno='BSMD0603-001-60V' and brandshort='BHFUSE' limit 1 [ RunTime:0.000932s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BSMD0603-001-60V' OR `brand` LIKE 'BHFUSE(佰宏)%' ) ) LIMIT 1 [ RunTime:0.003209s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58021695 LIMIT 5 [ RunTime:0.004384s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58021695 ORDER BY `minOrder` ASC [ RunTime:0.000763s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58021695 ORDER BY `unit` DESC [ RunTime:0.003425s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58021695 LIMIT 2 [ RunTime:0.005373s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58021695 ORDER BY `minOrder` ASC [ RunTime:0.003490s ]
select * from pdf where partno='BSMD0603-020-16V' and brandshort='BHFUSE' limit 1 [ RunTime:0.001058s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BSMD0603-020-16V' OR `brand` LIKE 'BHFUSE(佰宏)%' ) ) LIMIT 1 [ RunTime:0.001449s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58021820 LIMIT 5 [ RunTime:0.009843s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58021820 ORDER BY `minOrder` ASC [ RunTime:0.000759s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58021820 ORDER BY `unit` DESC [ RunTime:0.000638s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58021820 LIMIT 2 [ RunTime:0.000613s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58021820 ORDER BY `minOrder` ASC [ RunTime:0.005343s ]
select * from pdf where partno='BSMD1206-050-33V' and brandshort='BHFUSE' limit 1 [ RunTime:0.003885s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BSMD1206-050-33V' OR `brand` LIKE 'BHFUSE(佰宏)%' ) ) LIMIT 1 [ RunTime:0.003665s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58021731 LIMIT 5 [ RunTime:0.000638s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58021731 ORDER BY `minOrder` ASC [ RunTime:0.001178s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58021731 ORDER BY `unit` DESC [ RunTime:0.000784s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58021731 LIMIT 2 [ RunTime:0.000640s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58021731 ORDER BY `minOrder` ASC [ RunTime:0.002693s ]
select * from pdf where partno='BSMD1206-020-30V' and brandshort='BHFUSE' limit 1 [ RunTime:0.000925s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BSMD1206-020-30V' OR `brand` LIKE 'BHFUSE(佰宏)%' ) ) LIMIT 1 [ RunTime:0.001995s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58021897 LIMIT 5 [ RunTime:0.000900s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58021897 ORDER BY `minOrder` ASC [ RunTime:0.000950s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58021897 ORDER BY `unit` DESC [ RunTime:0.000658s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58021897 LIMIT 2 [ RunTime:0.000792s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58021897 ORDER BY `minOrder` ASC [ RunTime:0.000703s ]
select * from pdf where partno='BSMD0805-075-6V' and brandshort='BHFUSE' limit 1 [ RunTime:0.000909s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BSMD0805-075-6V' OR `brand` LIKE 'BHFUSE(佰宏)%' ) ) LIMIT 1 [ RunTime:0.001857s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58021705 LIMIT 5 [ RunTime:0.000920s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58021705 ORDER BY `minOrder` ASC [ RunTime:0.000693s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58021705 ORDER BY `unit` DESC [ RunTime:0.000562s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58021705 LIMIT 2 [ RunTime:0.000669s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58021705 ORDER BY `minOrder` ASC [ RunTime:0.000578s ]
select * from pdf where partno='BSMD1812-110-33V' and brandshort='BHFUSE' limit 1 [ RunTime:0.000754s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BSMD1812-110-33V' OR `brand` LIKE 'BHFUSE(佰宏)%' ) ) LIMIT 1 [ RunTime:0.001705s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58021534 LIMIT 5 [ RunTime:0.001003s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58021534 ORDER BY `minOrder` ASC [ RunTime:0.000601s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58021534 ORDER BY `unit` DESC [ RunTime:0.000642s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58021534 LIMIT 2 [ RunTime:0.000946s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58021534 ORDER BY `minOrder` ASC [ RunTime:0.000602s ]
select * from pdf where partno='BSMD1812-300-24V' and brandshort='BHFUSE' limit 1 [ RunTime:0.000933s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BSMD1812-300-24V' OR `brand` LIKE 'BHFUSE(佰宏)%' ) ) LIMIT 1 [ RunTime:0.002813s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58021754 LIMIT 5 [ RunTime:0.001504s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58021754 ORDER BY `minOrder` ASC [ RunTime:0.000604s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58021754 ORDER BY `unit` DESC [ RunTime:0.000605s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58021754 LIMIT 2 [ RunTime:0.001064s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58021754 ORDER BY `minOrder` ASC [ RunTime:0.000606s ]
select * from pdf where partno='BSMD0603-003-30V' and brandshort='BHFUSE' limit 1 [ RunTime:0.000789s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BSMD0603-003-30V' OR `brand` LIKE 'BHFUSE(佰宏)%' ) ) LIMIT 1 [ RunTime:0.002906s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58021910 LIMIT 5 [ RunTime:0.001401s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58021910 ORDER BY `minOrder` ASC [ RunTime:0.001010s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58021910 ORDER BY `unit` DESC [ RunTime:0.000695s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58021910 LIMIT 2 [ RunTime:0.000674s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58021910 ORDER BY `minOrder` ASC [ RunTime:0.000679s ]
select * from pdf where partno='BSMD1812-050-30V' and brandshort='BHFUSE' limit 1 [ RunTime:0.000791s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BSMD1812-050-30V' OR `brand` LIKE 'BHFUSE(佰宏)%' ) ) LIMIT 1 [ RunTime:0.003104s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'BSM%' OR `brand` LIKE 'BSM%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.001567s ]