SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.003957s ]
INSERT INTO `visit_log` SET `ip` = '216.73.216.89' , `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=AP6&search=1' [ RunTime:0.004047s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.002526s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.001317s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.004461s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.89' ) [ RunTime:0.001307s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001528s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.013999s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.002488s ]
SELECT * FROM `stock_search` WHERE `partno` = 'AP6' LIMIT 1 [ RunTime:0.009685s ]
UPDATE `stock_search` SET `count` = 2 , `updatetime` = '2026-08-18 23:10:09' WHERE `partno` = 'AP6' [ RunTime:0.003835s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002439s ]
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 'AP6%' OR `brand` LIKE 'AP6%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.029052s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.003016s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19125590 LIMIT 5 [ RunTime:0.011536s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001148s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19125590 ORDER BY `minOrder` ASC [ RunTime:0.025123s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.005014s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19125590 ORDER BY `unit` DESC [ RunTime:0.007490s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.002179s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19125590 LIMIT 2 [ RunTime:0.004162s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19125590 ORDER BY `minOrder` ASC [ RunTime:0.004549s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19125573 LIMIT 5 [ RunTime:0.015688s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19125573 ORDER BY `minOrder` ASC [ RunTime:0.004499s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19125573 ORDER BY `unit` DESC [ RunTime:0.009458s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19125573 LIMIT 2 [ RunTime:0.025520s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19125573 ORDER BY `minOrder` ASC [ RunTime:0.007000s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19126039 LIMIT 5 [ RunTime:0.005106s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19126039 ORDER BY `minOrder` ASC [ RunTime:0.017639s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19126039 ORDER BY `unit` DESC [ RunTime:0.019409s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19126039 LIMIT 2 [ RunTime:0.011640s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19126039 ORDER BY `minOrder` ASC [ RunTime:0.002198s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15313134 LIMIT 5 [ RunTime:0.010459s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15313134 ORDER BY `minOrder` ASC [ RunTime:0.034752s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15313134 ORDER BY `unit` DESC [ RunTime:0.016493s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15313134 LIMIT 2 [ RunTime:0.012984s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15313134 ORDER BY `minOrder` ASC [ RunTime:0.007574s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15311832 LIMIT 5 [ RunTime:0.007450s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15311832 ORDER BY `minOrder` ASC [ RunTime:0.007483s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15311832 ORDER BY `unit` DESC [ RunTime:0.031096s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15311832 LIMIT 2 [ RunTime:0.015666s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15311832 ORDER BY `minOrder` ASC [ RunTime:0.013501s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16064602 LIMIT 5 [ RunTime:0.001440s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16064602 ORDER BY `minOrder` ASC [ RunTime:0.009274s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16064602 ORDER BY `unit` DESC [ RunTime:0.014117s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16064602 LIMIT 2 [ RunTime:0.017540s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16064602 ORDER BY `minOrder` ASC [ RunTime:0.013829s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15311830 LIMIT 5 [ RunTime:0.008297s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15311830 ORDER BY `minOrder` ASC [ RunTime:0.008474s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15311830 ORDER BY `unit` DESC [ RunTime:0.007982s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15311830 LIMIT 2 [ RunTime:0.003666s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15311830 ORDER BY `minOrder` ASC [ RunTime:0.017235s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17091122 LIMIT 5 [ RunTime:0.010288s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17091122 ORDER BY `minOrder` ASC [ RunTime:0.001155s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17091122 ORDER BY `unit` DESC [ RunTime:0.007825s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17091122 LIMIT 2 [ RunTime:0.022097s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17091122 ORDER BY `minOrder` ASC [ RunTime:0.018786s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19120744 LIMIT 5 [ RunTime:0.012134s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19120744 ORDER BY `minOrder` ASC [ RunTime:0.000885s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19120744 ORDER BY `unit` DESC [ RunTime:0.011173s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19120744 LIMIT 2 [ RunTime:0.000657s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19120744 ORDER BY `minOrder` ASC [ RunTime:0.003658s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19120712 LIMIT 5 [ RunTime:0.002643s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19120712 ORDER BY `minOrder` ASC [ RunTime:0.008944s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19120712 ORDER BY `unit` DESC [ RunTime:0.007106s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19120712 LIMIT 2 [ RunTime:0.003020s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19120712 ORDER BY `minOrder` ASC [ RunTime:0.002758s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16062044 LIMIT 5 [ RunTime:0.001281s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16062044 ORDER BY `minOrder` ASC [ RunTime:0.000608s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16062044 ORDER BY `unit` DESC [ RunTime:0.001912s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16062044 LIMIT 2 [ RunTime:0.004647s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16062044 ORDER BY `minOrder` ASC [ RunTime:0.000401s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16064603 LIMIT 5 [ RunTime:0.000553s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16064603 ORDER BY `minOrder` ASC [ RunTime:0.004797s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16064603 ORDER BY `unit` DESC [ RunTime:0.002078s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16064603 LIMIT 2 [ RunTime:0.000790s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16064603 ORDER BY `minOrder` ASC [ RunTime:0.000850s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15313136 LIMIT 5 [ RunTime:0.000822s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15313136 ORDER BY `minOrder` ASC [ RunTime:0.006365s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15313136 ORDER BY `unit` DESC [ RunTime:0.002229s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15313136 LIMIT 2 [ RunTime:0.001095s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15313136 ORDER BY `minOrder` ASC [ RunTime:0.004318s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16062049 LIMIT 5 [ RunTime:0.000862s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16062049 ORDER BY `minOrder` ASC [ RunTime:0.006415s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16062049 ORDER BY `unit` DESC [ RunTime:0.002575s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16062049 LIMIT 2 [ RunTime:0.005047s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16062049 ORDER BY `minOrder` ASC [ RunTime:0.000834s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17094436 LIMIT 5 [ RunTime:0.001658s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17094436 ORDER BY `minOrder` ASC [ RunTime:0.001769s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17094436 ORDER BY `unit` DESC [ RunTime:0.006404s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17094436 LIMIT 2 [ RunTime:0.002626s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17094436 ORDER BY `minOrder` ASC [ RunTime:0.000600s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17092469 LIMIT 5 [ RunTime:0.001107s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17092469 ORDER BY `minOrder` ASC [ RunTime:0.000650s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17092469 ORDER BY `unit` DESC [ RunTime:0.007045s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17092469 LIMIT 2 [ RunTime:0.003261s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17092469 ORDER BY `minOrder` ASC [ RunTime:0.000438s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19130465 LIMIT 5 [ RunTime:0.002470s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19130465 ORDER BY `minOrder` ASC [ RunTime:0.001067s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19130465 ORDER BY `unit` DESC [ RunTime:0.000508s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19130465 LIMIT 2 [ RunTime:0.000507s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19130465 ORDER BY `minOrder` ASC [ RunTime:0.000357s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17182 LIMIT 5 [ RunTime:0.000489s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17182 ORDER BY `minOrder` ASC [ RunTime:0.002736s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17182 ORDER BY `unit` DESC [ RunTime:0.000681s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17182 LIMIT 2 [ RunTime:0.001574s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17182 ORDER BY `minOrder` ASC [ RunTime:0.005151s ]
select * from pdf where partno='AP6946A' and brandshort='APM' limit 1 [ RunTime:0.006192s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001996s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'AP6946A' OR `brand` LIKE 'APM%' ) ) LIMIT 1 [ RunTime:0.011018s ]
SELECT `id` FROM `stock` WHERE `id` <> 17182 AND `partno` = 'AP6946A' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%apm%' ) [ RunTime:0.010374s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14223861 LIMIT 5 [ RunTime:0.001219s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14223861 ORDER BY `minOrder` ASC [ RunTime:0.000545s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14223861 ORDER BY `unit` DESC [ RunTime:0.007978s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14223861 LIMIT 2 [ RunTime:0.008981s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14223861 ORDER BY `minOrder` ASC [ RunTime:0.002767s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15313124 LIMIT 5 [ RunTime:0.030870s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15313124 ORDER BY `minOrder` ASC [ RunTime:0.018009s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15313124 ORDER BY `unit` DESC [ RunTime:0.018744s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15313124 LIMIT 2 [ RunTime:0.019234s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15313124 ORDER BY `minOrder` ASC [ RunTime:0.001631s ]
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 'AP6%' OR `brand` LIKE 'AP6%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003366s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51047445 LIMIT 5 [ RunTime:0.000741s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51047445 ORDER BY `minOrder` ASC [ RunTime:0.033762s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51047445 ORDER BY `unit` DESC [ RunTime:0.025317s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51047445 LIMIT 2 [ RunTime:0.006886s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51047445 ORDER BY `minOrder` ASC [ RunTime:0.003368s ]
select * from pdf where partno='ap62200wu-7' and brandshort='diodes incorporated' limit 1 [ RunTime:0.006206s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'ap62200wu-7' OR `brand` LIKE 'diodes incorporated%' ) ) LIMIT 1 [ RunTime:0.016822s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51047207 LIMIT 5 [ RunTime:0.007631s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51047207 ORDER BY `minOrder` ASC [ RunTime:0.013849s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51047207 ORDER BY `unit` DESC [ RunTime:0.004996s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51047207 LIMIT 2 [ RunTime:0.006628s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51047207 ORDER BY `minOrder` ASC [ RunTime:0.001872s ]
select * from pdf where partno='ap62301wu-7' and brandshort='diodes incorporated' limit 1 [ RunTime:0.010457s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'ap62301wu-7' OR `brand` LIKE 'diodes incorporated%' ) ) LIMIT 1 [ RunTime:0.015314s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51048144 LIMIT 5 [ RunTime:0.009582s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51048144 ORDER BY `minOrder` ASC [ RunTime:0.005081s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51048144 ORDER BY `unit` DESC [ RunTime:0.016268s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51048144 LIMIT 2 [ RunTime:0.010763s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51048144 ORDER BY `minOrder` ASC [ RunTime:0.000571s ]
select * from pdf where partno='ap61100qz6-7' and brandshort='diodes incorporated' limit 1 [ RunTime:0.004514s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'ap61100qz6-7' OR `brand` LIKE 'diodes incorporated%' ) ) LIMIT 1 [ RunTime:0.003105s ]
SELECT `id` FROM `stock` WHERE `id` <> 51048144 AND `partno` = 'ap61100qz6-7' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%diodes incorporated%' ) [ RunTime:0.003533s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19126039 [ RunTime:0.000862s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51091552 LIMIT 5 [ RunTime:0.007898s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51091552 ORDER BY `minOrder` ASC [ RunTime:0.009329s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51091552 ORDER BY `unit` DESC [ RunTime:0.004242s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51091552 LIMIT 2 [ RunTime:0.004200s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51091552 ORDER BY `minOrder` ASC [ RunTime:0.004030s ]
select * from pdf where partno='ap6m266-g' and brandshort='idec' limit 1 [ RunTime:0.008718s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'ap6m266-g' OR `brand` LIKE 'idec%' ) ) LIMIT 1 [ RunTime:0.004937s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51034644 LIMIT 5 [ RunTime:0.014246s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51034644 ORDER BY `minOrder` ASC [ RunTime:0.020488s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51034644 ORDER BY `unit` DESC [ RunTime:0.003402s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51034644 LIMIT 2 [ RunTime:0.008580s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51034644 ORDER BY `minOrder` ASC [ RunTime:0.000402s ]
select * from pdf where partno='ap64gah356b' and brandshort='apacer' limit 1 [ RunTime:0.001336s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'ap64gah356b' OR `brand` LIKE 'apacer%' ) ) LIMIT 1 [ RunTime:0.018790s ]
SELECT `id` FROM `stock` WHERE `id` <> 51034644 AND `partno` = 'ap64gah356b' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%apacer%' ) [ RunTime:0.009710s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14273052 [ RunTime:0.029756s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51034642 LIMIT 5 [ RunTime:0.017091s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51034642 ORDER BY `minOrder` ASC [ RunTime:0.026332s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51034642 ORDER BY `unit` DESC [ RunTime:0.019646s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51034642 LIMIT 2 [ RunTime:0.013724s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51034642 ORDER BY `minOrder` ASC [ RunTime:0.007667s ]
select * from pdf where partno='ap64gah155u' and brandshort='apacer' limit 1 [ RunTime:0.017817s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'ap64gah155u' OR `brand` LIKE 'apacer%' ) ) LIMIT 1 [ RunTime:0.001072s ]
SELECT `id` FROM `stock` WHERE `id` <> 51034642 AND `partno` = 'ap64gah155u' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%apacer%' ) [ RunTime:0.017507s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14273129 [ RunTime:0.006845s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51112030 LIMIT 5 [ RunTime:0.025962s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51112030 ORDER BY `minOrder` ASC [ RunTime:0.034944s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51112030 ORDER BY `unit` DESC [ RunTime:0.012319s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51112030 LIMIT 2 [ RunTime:0.003652s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51112030 ORDER BY `minOrder` ASC [ RunTime:0.005471s ]
select * from pdf where partno='ap63205wu-evm' and brandshort='diodes incorporated' limit 1 [ RunTime:0.002676s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'ap63205wu-evm' OR `brand` LIKE 'diodes incorporated%' ) ) LIMIT 1 [ RunTime:0.004735s ]
SELECT `id` FROM `stock` WHERE `id` <> 51112030 AND `partno` = 'ap63205wu-evm' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%diodes incorporated%' ) [ RunTime:0.007590s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15427568 [ RunTime:0.013197s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51111778 LIMIT 5 [ RunTime:0.022106s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51111778 ORDER BY `minOrder` ASC [ RunTime:0.031982s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51111778 ORDER BY `unit` DESC [ RunTime:0.001266s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51111778 LIMIT 2 [ RunTime:0.007471s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51111778 ORDER BY `minOrder` ASC [ RunTime:0.017976s ]
select * from pdf where partno='ap66200fvbw-evm' and brandshort='diodes incorporated' limit 1 [ RunTime:0.008822s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'ap66200fvbw-evm' OR `brand` LIKE 'diodes incorporated%' ) ) LIMIT 1 [ RunTime:0.005757s ]
SELECT `id` FROM `stock` WHERE `id` <> 51111778 AND `partno` = 'ap66200fvbw-evm' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%diodes incorporated%' ) [ RunTime:0.021072s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19516901 [ RunTime:0.029188s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51111669 LIMIT 5 [ RunTime:0.005241s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51111669 ORDER BY `minOrder` ASC [ RunTime:0.001120s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51111669 ORDER BY `unit` DESC [ RunTime:0.010974s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51111669 LIMIT 2 [ RunTime:0.009234s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51111669 ORDER BY `minOrder` ASC [ RunTime:0.000353s ]
select * from pdf where partno='ap63203qwu-evm' and brandshort='diodes incorporated' limit 1 [ RunTime:0.019616s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'ap63203qwu-evm' OR `brand` LIKE 'diodes incorporated%' ) ) LIMIT 1 [ RunTime:0.014722s ]
SELECT `id` FROM `stock` WHERE `id` <> 51111669 AND `partno` = 'ap63203qwu-evm' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%diodes incorporated%' ) [ RunTime:0.019414s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17269565 [ RunTime:0.009967s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51035379 LIMIT 5 [ RunTime:0.003073s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51035379 ORDER BY `minOrder` ASC [ RunTime:0.017181s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51035379 ORDER BY `unit` DESC [ RunTime:0.006853s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51035379 LIMIT 2 [ RunTime:0.009479s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51035379 ORDER BY `minOrder` ASC [ RunTime:0.026363s ]
select * from pdf where partno='ap64gpjm1a08-ba134' and brandshort='apacer' limit 1 [ RunTime:0.027728s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'ap64gpjm1a08-ba134' OR `brand` LIKE 'apacer%' ) ) LIMIT 1 [ RunTime:0.035493s ]
SELECT `id` FROM `stock` WHERE `id` <> 51035379 AND `partno` = 'ap64gpjm1a08-ba134' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%apacer%' ) [ RunTime:0.018829s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13380185 [ RunTime:0.022993s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51034643 LIMIT 5 [ RunTime:0.023517s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51034643 ORDER BY `minOrder` ASC [ RunTime:0.038878s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51034643 ORDER BY `unit` DESC [ RunTime:0.018922s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51034643 LIMIT 2 [ RunTime:0.025953s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51034643 ORDER BY `minOrder` ASC [ RunTime:0.023457s ]
select * from pdf where partno='ap64gah355b' and brandshort='apacer' limit 1 [ RunTime:0.017899s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'ap64gah355b' OR `brand` LIKE 'apacer%' ) ) LIMIT 1 [ RunTime:0.022539s ]
SELECT `id` FROM `stock` WHERE `id` <> 51034643 AND `partno` = 'ap64gah355b' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%apacer%' ) [ RunTime:0.020710s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14273100 [ RunTime:0.029235s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32302946 LIMIT 5 [ RunTime:0.003843s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32302946 ORDER BY `minOrder` ASC [ RunTime:0.003104s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32302946 ORDER BY `unit` DESC [ RunTime:0.003765s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32302946 LIMIT 2 [ RunTime:0.003835s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32302946 ORDER BY `minOrder` ASC [ RunTime:0.003317s ]
select * from pdf where partno='ap66200qfvbw-evm' and brandshort='diodes incorporated' limit 1 [ RunTime:0.000923s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'ap66200qfvbw-evm' OR `brand` LIKE 'diodes incorporated%' ) ) LIMIT 1 [ RunTime:0.018395s ]
SELECT `id` FROM `stock` WHERE `id` <> 32302946 AND `partno` = 'ap66200qfvbw-evm' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%diodes incorporated%' ) [ RunTime:0.021987s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19516909 [ RunTime:0.009663s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32192087 LIMIT 5 [ RunTime:0.023299s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32192087 ORDER BY `minOrder` ASC [ RunTime:0.011619s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32192087 ORDER BY `unit` DESC [ RunTime:0.006791s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32192087 LIMIT 2 [ RunTime:0.011166s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32192087 ORDER BY `minOrder` ASC [ RunTime:0.011638s ]
select * from pdf where partno='ap66200qfvbw-evm' and brandshort='diodes incorporated' limit 1 [ RunTime:0.002564s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'ap66200qfvbw-evm' OR `brand` LIKE 'diodes incorporated%' ) ) LIMIT 1 [ RunTime:0.007909s ]
SELECT `id` FROM `stock` WHERE `id` <> 32192087 AND `partno` = 'ap66200qfvbw-evm' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%diodes incorporated%' ) [ RunTime:0.009893s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19516909 [ RunTime:0.002759s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51111677 LIMIT 5 [ RunTime:0.006886s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51111677 ORDER BY `minOrder` ASC [ RunTime:0.024118s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51111677 ORDER BY `unit` DESC [ RunTime:0.004420s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51111677 LIMIT 2 [ RunTime:0.001845s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51111677 ORDER BY `minOrder` ASC [ RunTime:0.000541s ]
select * from pdf where partno='ap66300qfvbw-evm' and brandshort='diodes incorporated' limit 1 [ RunTime:0.006209s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'ap66300qfvbw-evm' OR `brand` LIKE 'diodes incorporated%' ) ) LIMIT 1 [ RunTime:0.006834s ]
SELECT `id` FROM `stock` WHERE `id` <> 51111677 AND `partno` = 'ap66300qfvbw-evm' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%diodes incorporated%' ) [ RunTime:0.019117s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19516910 [ RunTime:0.021881s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51092356 LIMIT 5 [ RunTime:0.000868s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51092356 ORDER BY `minOrder` ASC [ RunTime:0.009343s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51092356 ORDER BY `unit` DESC [ RunTime:0.002291s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51092356 LIMIT 2 [ RunTime:0.000650s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51092356 ORDER BY `minOrder` ASC [ RunTime:0.000796s ]
select * from pdf where partno='ap6qs54m-r' and brandshort='idec' limit 1 [ RunTime:0.006925s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'ap6qs54m-r' OR `brand` LIKE 'idec%' ) ) LIMIT 1 [ RunTime:0.008532s ]
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 'AP6%' OR `brand` LIKE 'AP6%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.010066s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63871706 LIMIT 5 [ RunTime:0.001168s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63871706 ORDER BY `minOrder` ASC [ RunTime:0.001875s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63871706 ORDER BY `unit` DESC [ RunTime:0.000836s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63871706 LIMIT 2 [ RunTime:0.000522s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63871706 ORDER BY `minOrder` ASC [ RunTime:0.000394s ]
select * from pdf where partno='AP61100QZ6-7' and brandshort='Diodes Incorporated' limit 1 [ RunTime:0.001099s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'AP61100QZ6-7' OR `brand` LIKE 'Diodes Incorporated%' ) ) LIMIT 1 [ RunTime:0.007785s ]
SELECT `id` FROM `stock` WHERE `id` <> 63871706 AND `partno` = 'AP61100QZ6-7' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%diodes incorporated%' ) [ RunTime:0.001016s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19126039 [ RunTime:0.001579s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63871644 LIMIT 5 [ RunTime:0.016126s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63871644 ORDER BY `minOrder` ASC [ RunTime:0.001507s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63871644 ORDER BY `unit` DESC [ RunTime:0.000824s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63871644 LIMIT 2 [ RunTime:0.001864s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63871644 ORDER BY `minOrder` ASC [ RunTime:0.005766s ]
select * from pdf where partno='AP62200TWU-7' and brandshort='Diodes Incorporated' limit 1 [ RunTime:0.004987s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'AP62200TWU-7' OR `brand` LIKE 'Diodes Incorporated%' ) ) LIMIT 1 [ RunTime:0.001207s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63871682 LIMIT 5 [ RunTime:0.000635s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63871682 ORDER BY `minOrder` ASC [ RunTime:0.001904s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63871682 ORDER BY `unit` DESC [ RunTime:0.000614s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63871682 LIMIT 2 [ RunTime:0.000621s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63871682 ORDER BY `minOrder` ASC [ RunTime:0.000435s ]
select * from pdf where partno='AP62301WU-7' and brandshort='Diodes Incorporated' limit 1 [ RunTime:0.002119s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'AP62301WU-7' OR `brand` LIKE 'Diodes Incorporated%' ) ) LIMIT 1 [ RunTime:0.000825s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63871628 LIMIT 5 [ RunTime:0.000616s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63871628 ORDER BY `minOrder` ASC [ RunTime:0.000978s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63871628 ORDER BY `unit` DESC [ RunTime:0.002858s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63871628 LIMIT 2 [ RunTime:0.000647s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63871628 ORDER BY `minOrder` ASC [ RunTime:0.000440s ]
select * from pdf where partno='AP61100Z6-7' and brandshort='Diodes Incorporated' limit 1 [ RunTime:0.001171s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'AP61100Z6-7' OR `brand` LIKE 'Diodes Incorporated%' ) ) LIMIT 1 [ RunTime:0.004780s ]
SELECT `id` FROM `stock` WHERE `id` <> 63871628 AND `partno` = 'AP61100Z6-7' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%diodes incorporated%' ) [ RunTime:0.009523s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19125573 [ RunTime:0.010782s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63870129 LIMIT 5 [ RunTime:0.012662s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63870129 ORDER BY `minOrder` ASC [ RunTime:0.010417s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63870129 ORDER BY `unit` DESC [ RunTime:0.008417s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63870129 LIMIT 2 [ RunTime:0.001077s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63870129 ORDER BY `minOrder` ASC [ RunTime:0.000326s ]
select * from pdf where partno='AP63301WU-7' and brandshort='Diodes Incorporated' limit 1 [ RunTime:0.000954s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'AP63301WU-7' OR `brand` LIKE 'Diodes Incorporated%' ) ) LIMIT 1 [ RunTime:0.010286s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63870099 LIMIT 5 [ RunTime:0.004024s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63870099 ORDER BY `minOrder` ASC [ RunTime:0.001165s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63870099 ORDER BY `unit` DESC [ RunTime:0.000441s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63870099 LIMIT 2 [ RunTime:0.003071s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63870099 ORDER BY `minOrder` ASC [ RunTime:0.006709s ]
select * from pdf where partno='AP62301Z6-7' and brandshort='Diodes Incorporated' limit 1 [ RunTime:0.008768s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'AP62301Z6-7' OR `brand` LIKE 'Diodes Incorporated%' ) ) LIMIT 1 [ RunTime:0.007422s ]
SELECT `id` FROM `stock` WHERE `id` <> 63870099 AND `partno` = 'AP62301Z6-7' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%diodes incorporated%' ) [ RunTime:0.002091s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15311832 [ RunTime:0.003066s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63870107 LIMIT 5 [ RunTime:0.001684s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63870107 ORDER BY `minOrder` ASC [ RunTime:0.009884s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63870107 ORDER BY `unit` DESC [ RunTime:0.002766s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63870107 LIMIT 2 [ RunTime:0.007014s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63870107 ORDER BY `minOrder` ASC [ RunTime:0.000240s ]
select * from pdf where partno='AP64060WU-7' and brandshort='Diodes Incorporated' limit 1 [ RunTime:0.000521s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'AP64060WU-7' OR `brand` LIKE 'Diodes Incorporated%' ) ) LIMIT 1 [ RunTime:0.001930s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63870092 LIMIT 5 [ RunTime:0.002349s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63870092 ORDER BY `minOrder` ASC [ RunTime:0.010551s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63870092 ORDER BY `unit` DESC [ RunTime:0.002445s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63870092 LIMIT 2 [ RunTime:0.011962s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63870092 ORDER BY `minOrder` ASC [ RunTime:0.001485s ]
select * from pdf where partno='AP61102Z6-7' and brandshort='Diodes Incorporated' limit 1 [ RunTime:0.000689s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'AP61102Z6-7' OR `brand` LIKE 'Diodes Incorporated%' ) ) LIMIT 1 [ RunTime:0.006375s ]
SELECT `id` FROM `stock` WHERE `id` <> 63870092 AND `partno` = 'AP61102Z6-7' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%diodes incorporated%' ) [ RunTime:0.011207s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16064602 [ RunTime:0.007391s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63870130 LIMIT 5 [ RunTime:0.012386s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63870130 ORDER BY `minOrder` ASC [ RunTime:0.005117s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63870130 ORDER BY `unit` DESC [ RunTime:0.000549s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63870130 LIMIT 2 [ RunTime:0.019386s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63870130 ORDER BY `minOrder` ASC [ RunTime:0.007074s ]
select * from pdf where partno='AP63357DV-7' and brandshort='Diodes Incorporated' limit 1 [ RunTime:0.001484s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'AP63357DV-7' OR `brand` LIKE 'Diodes Incorporated%' ) ) LIMIT 1 [ RunTime:0.000945s ]
SELECT `id` FROM `stock` WHERE `id` <> 63870130 AND `partno` = 'AP63357DV-7' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%diodes incorporated%' ) [ RunTime:0.016484s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17091122 [ RunTime:0.017619s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63870233 LIMIT 5 [ RunTime:0.005872s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63870233 ORDER BY `minOrder` ASC [ RunTime:0.027947s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63870233 ORDER BY `unit` DESC [ RunTime:0.024403s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63870233 LIMIT 2 [ RunTime:0.002555s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63870233 ORDER BY `minOrder` ASC [ RunTime:0.002292s ]
select * from pdf where partno='AP64100QSP-13' and brandshort='Diodes Incorporated' limit 1 [ RunTime:0.019866s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'AP64100QSP-13' OR `brand` LIKE 'Diodes Incorporated%' ) ) LIMIT 1 [ RunTime:0.001663s ]
SELECT `id` FROM `stock` WHERE `id` <> 63870233 AND `partno` = 'AP64100QSP-13' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%diodes incorporated%' ) [ RunTime:0.002062s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19125516 [ RunTime:0.024516s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63870097 LIMIT 5 [ RunTime:0.007707s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63870097 ORDER BY `minOrder` ASC [ RunTime:0.004451s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63870097 ORDER BY `unit` DESC [ RunTime:0.020455s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63870097 LIMIT 2 [ RunTime:0.026552s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63870097 ORDER BY `minOrder` ASC [ RunTime:0.004180s ]
select * from pdf where partno='AP62300TWU-7' and brandshort='Diodes Incorporated' limit 1 [ RunTime:0.014950s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'AP62300TWU-7' OR `brand` LIKE 'Diodes Incorporated%' ) ) LIMIT 1 [ RunTime:0.009645s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63870134 LIMIT 5 [ RunTime:0.006405s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63870134 ORDER BY `minOrder` ASC [ RunTime:0.009471s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63870134 ORDER BY `unit` DESC [ RunTime:0.022939s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63870134 LIMIT 2 [ RunTime:0.025257s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63870134 ORDER BY `minOrder` ASC [ RunTime:0.015097s ]
select * from pdf where partno='AP63200QWU-7' and brandshort='Diodes Incorporated' limit 1 [ RunTime:0.010582s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'AP63200QWU-7' OR `brand` LIKE 'Diodes Incorporated%' ) ) LIMIT 1 [ RunTime:0.022900s ]
SELECT `id` FROM `stock` WHERE `id` <> 63870134 AND `partno` = 'AP63200QWU-7' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%diodes incorporated%' ) [ RunTime:0.004711s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16062056 [ RunTime:0.002587s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63871677 LIMIT 5 [ RunTime:0.004395s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63871677 ORDER BY `minOrder` ASC [ RunTime:0.020236s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63871677 ORDER BY `unit` DESC [ RunTime:0.037790s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63871677 LIMIT 2 [ RunTime:0.055211s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63871677 ORDER BY `minOrder` ASC [ RunTime:0.018901s ]
select * from pdf where partno='AP62201WU-7' and brandshort='Diodes Incorporated' limit 1 [ RunTime:0.028611s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'AP62201WU-7' OR `brand` LIKE 'Diodes Incorporated%' ) ) LIMIT 1 [ RunTime:0.004429s ]
SELECT `id` FROM `stock` WHERE `id` <> 63871677 AND `partno` = 'AP62201WU-7' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%diodes incorporated%' ) [ RunTime:0.012666s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16064603 [ RunTime:0.013414s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63870098 LIMIT 5 [ RunTime:0.052303s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63870098 ORDER BY `minOrder` ASC [ RunTime:0.006065s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63870098 ORDER BY `unit` DESC [ RunTime:0.015078s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63870098 LIMIT 2 [ RunTime:0.016428s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63870098 ORDER BY `minOrder` ASC [ RunTime:0.015627s ]
select * from pdf where partno='AP62150Z6-7' and brandshort='Diodes Incorporated' limit 1 [ RunTime:0.012030s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'AP62150Z6-7' OR `brand` LIKE 'Diodes Incorporated%' ) ) LIMIT 1 [ RunTime:0.004226s ]
SELECT `id` FROM `stock` WHERE `id` <> 63870098 AND `partno` = 'AP62150Z6-7' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%diodes incorporated%' ) [ RunTime:0.032327s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19120712 [ RunTime:0.021971s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63870140 LIMIT 5 [ RunTime:0.006552s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63870140 ORDER BY `minOrder` ASC [ RunTime:0.013706s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63870140 ORDER BY `unit` DESC [ RunTime:0.003710s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63870140 LIMIT 2 [ RunTime:0.010166s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63870140 ORDER BY `minOrder` ASC [ RunTime:0.002673s ]
select * from pdf where partno='AP63356DV-7' and brandshort='Diodes Incorporated' limit 1 [ RunTime:0.012986s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'AP63356DV-7' OR `brand` LIKE 'Diodes Incorporated%' ) ) LIMIT 1 [ RunTime:0.020195s ]
SELECT `id` FROM `stock` WHERE `id` <> 63870140 AND `partno` = 'AP63356DV-7' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%diodes incorporated%' ) [ RunTime:0.027286s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15311835 [ RunTime:0.014414s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63871683 LIMIT 5 [ RunTime:0.031805s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63871683 ORDER BY `minOrder` ASC [ RunTime:0.041076s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63871683 ORDER BY `unit` DESC [ RunTime:0.019695s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63871683 LIMIT 2 [ RunTime:0.017089s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63871683 ORDER BY `minOrder` ASC [ RunTime:0.060541s ]
select * from pdf where partno='AP62250Z6-7' and brandshort='Diodes Incorporated' limit 1 [ RunTime:0.017452s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'AP62250Z6-7' OR `brand` LIKE 'Diodes Incorporated%' ) ) LIMIT 1 [ RunTime:0.012477s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63871749 LIMIT 5 [ RunTime:0.028320s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63871749 ORDER BY `minOrder` ASC [ RunTime:0.063653s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63871749 ORDER BY `unit` DESC [ RunTime:0.013230s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63871749 LIMIT 2 [ RunTime:0.007821s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63871749 ORDER BY `minOrder` ASC [ RunTime:0.000428s ]
select * from pdf where partno='AP6714M10G-13' and brandshort='Diodes Incorporated' limit 1 [ RunTime:0.001308s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'AP6714M10G-13' OR `brand` LIKE 'Diodes Incorporated%' ) ) LIMIT 1 [ RunTime:0.004396s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63870400 LIMIT 5 [ RunTime:0.002528s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63870400 ORDER BY `minOrder` ASC [ RunTime:0.007352s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63870400 ORDER BY `unit` DESC [ RunTime:0.000639s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63870400 LIMIT 2 [ RunTime:0.002252s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63870400 ORDER BY `minOrder` ASC [ RunTime:0.000455s ]
select * from pdf where partno='AP64500SP-13' and brandshort='Diodes Incorporated' limit 1 [ RunTime:0.006008s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'AP64500SP-13' OR `brand` LIKE 'Diodes Incorporated%' ) ) LIMIT 1 [ RunTime:0.001946s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63871634 LIMIT 5 [ RunTime:0.000627s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63871634 ORDER BY `minOrder` ASC [ RunTime:0.000788s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63871634 ORDER BY `unit` DESC [ RunTime:0.006794s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63871634 LIMIT 2 [ RunTime:0.011557s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63871634 ORDER BY `minOrder` ASC [ RunTime:0.002423s ]
select * from pdf where partno='AP61300Z6-7' and brandshort='Diodes Incorporated' limit 1 [ RunTime:0.000771s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'AP61300Z6-7' OR `brand` LIKE 'Diodes Incorporated%' ) ) LIMIT 1 [ RunTime:0.001272s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63871680 LIMIT 5 [ RunTime:0.001761s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63871680 ORDER BY `minOrder` ASC [ RunTime:0.001300s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63871680 ORDER BY `unit` DESC [ RunTime:0.000606s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63871680 LIMIT 2 [ RunTime:0.003399s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63871680 ORDER BY `minOrder` ASC [ RunTime:0.002822s ]
select * from pdf where partno='AP62300Z6-7' and brandshort='Diodes Incorporated' limit 1 [ RunTime:0.001833s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'AP62300Z6-7' OR `brand` LIKE 'Diodes Incorporated%' ) ) LIMIT 1 [ RunTime:0.000963s ]
SELECT `id` FROM `stock` WHERE `id` <> 63871680 AND `partno` = 'AP62300Z6-7' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%diodes incorporated%' ) [ RunTime:0.000793s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19125588 [ RunTime:0.000661s ]
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 'AP6%' OR `brand` LIKE 'AP6%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001723s ]
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 'AP6%' OR `brand` LIKE 'AP6%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001061s ]
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 'AP6%' OR `brand` LIKE 'AP6%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001923s ]
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 'AP6%' OR `brand` LIKE 'AP6%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002239s ]
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 'AP6%' OR `brand` LIKE 'AP6%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003333s ]
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 'AP6%' OR `brand` LIKE 'AP6%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.005172s ]
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 'AP6%' OR `brand` LIKE 'AP6%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.006801s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'AP6%' OR `brand` LIKE 'AP6%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.008253s ]