SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001746s ]
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 'SMBJ10A%' OR `brand` LIKE 'SMBJ10A%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.016377s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001018s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16663396 LIMIT 5 [ RunTime:0.004263s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001814s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16663396 ORDER BY `minOrder` ASC [ RunTime:0.001547s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.001071s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16663396 ORDER BY `unit` DESC [ RunTime:0.004646s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.008153s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16663396 LIMIT 2 [ RunTime:0.006743s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16663396 ORDER BY `minOrder` ASC [ RunTime:0.004109s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16662753 LIMIT 5 [ RunTime:0.005724s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16662753 ORDER BY `minOrder` ASC [ RunTime:0.002178s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16662753 ORDER BY `unit` DESC [ RunTime:0.012129s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16662753 LIMIT 2 [ RunTime:0.009790s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16662753 ORDER BY `minOrder` ASC [ RunTime:0.003197s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16663676 LIMIT 5 [ RunTime:0.004846s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16663676 ORDER BY `minOrder` ASC [ RunTime:0.008131s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16663676 ORDER BY `unit` DESC [ RunTime:0.006169s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16663676 LIMIT 2 [ RunTime:0.003187s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16663676 ORDER BY `minOrder` ASC [ RunTime:0.009470s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16676258 LIMIT 5 [ RunTime:0.013288s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16676258 ORDER BY `minOrder` ASC [ RunTime:0.005508s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16676258 ORDER BY `unit` DESC [ RunTime:0.006896s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16676258 LIMIT 2 [ RunTime:0.009712s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16676258 ORDER BY `minOrder` ASC [ RunTime:0.004707s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14829046 LIMIT 5 [ RunTime:0.009436s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14829046 ORDER BY `minOrder` ASC [ RunTime:0.002357s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14829046 ORDER BY `unit` DESC [ RunTime:0.038454s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14829046 LIMIT 2 [ RunTime:0.007370s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14829046 ORDER BY `minOrder` ASC [ RunTime:0.017420s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16665487 LIMIT 5 [ RunTime:0.004030s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16665487 ORDER BY `minOrder` ASC [ RunTime:0.004771s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16665487 ORDER BY `unit` DESC [ RunTime:0.016452s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16665487 LIMIT 2 [ RunTime:0.017415s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16665487 ORDER BY `minOrder` ASC [ RunTime:0.004112s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13907538 LIMIT 5 [ RunTime:0.003868s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13907538 ORDER BY `minOrder` ASC [ RunTime:0.017807s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13907538 ORDER BY `unit` DESC [ RunTime:0.038274s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13907538 LIMIT 2 [ RunTime:0.021782s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13907538 ORDER BY `minOrder` ASC [ RunTime:0.008289s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14817188 LIMIT 5 [ RunTime:0.071894s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14817188 ORDER BY `minOrder` ASC [ RunTime:0.005216s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14817188 ORDER BY `unit` DESC [ RunTime:0.006118s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14817188 LIMIT 2 [ RunTime:0.009388s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14817188 ORDER BY `minOrder` ASC [ RunTime:0.007147s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16662493 LIMIT 5 [ RunTime:0.010397s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16662493 ORDER BY `minOrder` ASC [ RunTime:0.000595s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16662493 ORDER BY `unit` DESC [ RunTime:0.009431s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16662493 LIMIT 2 [ RunTime:0.009856s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16662493 ORDER BY `minOrder` ASC [ RunTime:0.012655s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14829437 LIMIT 5 [ RunTime:0.009434s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14829437 ORDER BY `minOrder` ASC [ RunTime:0.007009s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14829437 ORDER BY `unit` DESC [ RunTime:0.011259s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14829437 LIMIT 2 [ RunTime:0.016566s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14829437 ORDER BY `minOrder` ASC [ RunTime:0.006451s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16661320 LIMIT 5 [ RunTime:0.011064s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16661320 ORDER BY `minOrder` ASC [ RunTime:0.008261s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16661320 ORDER BY `unit` DESC [ RunTime:0.003299s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16661320 LIMIT 2 [ RunTime:0.008819s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16661320 ORDER BY `minOrder` ASC [ RunTime:0.018450s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14801056 LIMIT 5 [ RunTime:0.010621s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14801056 ORDER BY `minOrder` ASC [ RunTime:0.006812s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14801056 ORDER BY `unit` DESC [ RunTime:0.005584s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14801056 LIMIT 2 [ RunTime:0.003125s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14801056 ORDER BY `minOrder` ASC [ RunTime:0.000525s ]
select * from pdf where partno='SMBJ10A' and brandshort='Littelfuse Inc.' limit 1 [ RunTime:0.004401s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13908439 LIMIT 5 [ RunTime:0.003723s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13908439 ORDER BY `minOrder` ASC [ RunTime:0.000593s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13908439 ORDER BY `unit` DESC [ RunTime:0.000675s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13908439 LIMIT 2 [ RunTime:0.012016s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13908439 ORDER BY `minOrder` ASC [ RunTime:0.012797s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 24616 LIMIT 5 [ RunTime:0.000892s ]
SELECT * FROM `stock_price` WHERE `stockid` = 24616 ORDER BY `minOrder` ASC [ RunTime:0.001232s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 24616 ORDER BY `unit` DESC [ RunTime:0.005105s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 24616 LIMIT 2 [ RunTime:0.010785s ]
SELECT * FROM `stock_price` WHERE `stockid` = 24616 ORDER BY `minOrder` ASC [ RunTime:0.005527s ]
select * from pdf where partno='SMBJ10A' and brandshort='VISHAY' limit 1 [ RunTime:0.000799s ]
select foldpath,foldpath2,filename from pdf_file where id=446825 limit 1 [ RunTime:0.000749s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001473s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMBJ10A' OR `brand` LIKE 'VISHAY%' ) ) LIMIT 1 [ RunTime:0.010826s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16691150 LIMIT 5 [ RunTime:0.004445s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16691150 ORDER BY `minOrder` ASC [ RunTime:0.002514s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16691150 ORDER BY `unit` DESC [ RunTime:0.008735s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16691150 LIMIT 2 [ RunTime:0.004273s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16691150 ORDER BY `minOrder` ASC [ RunTime:0.000497s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16674192 LIMIT 5 [ RunTime:0.001746s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16674192 ORDER BY `minOrder` ASC [ RunTime:0.005130s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16674192 ORDER BY `unit` DESC [ RunTime:0.019584s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16674192 LIMIT 2 [ RunTime:0.024580s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16674192 ORDER BY `minOrder` ASC [ RunTime:0.011746s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16672321 LIMIT 5 [ RunTime:0.027088s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16672321 ORDER BY `minOrder` ASC [ RunTime:0.014075s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16672321 ORDER BY `unit` DESC [ RunTime:0.008492s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16672321 LIMIT 2 [ RunTime:0.020101s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16672321 ORDER BY `minOrder` ASC [ RunTime:0.000812s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16671586 LIMIT 5 [ RunTime:0.002408s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16671586 ORDER BY `minOrder` ASC [ RunTime:0.008452s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16671586 ORDER BY `unit` DESC [ RunTime:0.014056s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16671586 LIMIT 2 [ RunTime:0.001102s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16671586 ORDER BY `minOrder` ASC [ RunTime:0.004534s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16671534 LIMIT 5 [ RunTime:0.002517s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16671534 ORDER BY `minOrder` ASC [ RunTime:0.000463s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16671534 ORDER BY `unit` DESC [ RunTime:0.000340s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16671534 LIMIT 2 [ RunTime:0.012309s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16671534 ORDER BY `minOrder` ASC [ RunTime:0.011653s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16671087 LIMIT 5 [ RunTime:0.007069s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16671087 ORDER BY `minOrder` ASC [ RunTime:0.000817s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16671087 ORDER BY `unit` DESC [ RunTime:0.001119s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16671087 LIMIT 2 [ RunTime:0.017541s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16671087 ORDER BY `minOrder` ASC [ RunTime:0.018686s ]
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 'SMBJ10A%' OR `brand` LIKE 'SMBJ10A%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002859s ]
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 'SMBJ10A%' OR `brand` LIKE 'SMBJ10A%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.025024s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42160127 LIMIT 5 [ RunTime:0.001605s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42160127 ORDER BY `minOrder` ASC [ RunTime:0.012756s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42160127 ORDER BY `unit` DESC [ RunTime:0.010785s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42160127 LIMIT 2 [ RunTime:0.003410s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42160127 ORDER BY `minOrder` ASC [ RunTime:0.008711s ]
select * from pdf where partno='SMBJ10AL00S0KX' and brandshort='NextGen Components' limit 1 [ RunTime:0.004294s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMBJ10AL00S0KX' OR `brand` LIKE 'NextGen Components%' ) ) LIMIT 1 [ RunTime:0.002141s ]
SELECT `id` FROM `stock` WHERE `id` <> 42160127 AND `partno` = 'SMBJ10AL00S0KX' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%nextgen components%' ) [ RunTime:0.004020s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16663396 [ RunTime:0.000948s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42101090 LIMIT 5 [ RunTime:0.001104s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42101090 ORDER BY `minOrder` ASC [ RunTime:0.009300s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42101090 ORDER BY `unit` DESC [ RunTime:0.002361s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42101090 LIMIT 2 [ RunTime:0.005335s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42101090 ORDER BY `minOrder` ASC [ RunTime:0.000652s ]
select * from pdf where partno='SMBJ10A-13-F' and brandshort='Diodes Incorporated' limit 1 [ RunTime:0.001251s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMBJ10A-13-F' OR `brand` LIKE 'Diodes Incorporated%' ) ) LIMIT 1 [ RunTime:0.000851s ]
SELECT `id` FROM `stock` WHERE `id` <> 42101090 AND `partno` = 'SMBJ10A-13-F' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%diodes incorporated%' ) [ RunTime:0.000887s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16662753 [ RunTime:0.000746s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42161989 LIMIT 5 [ RunTime:0.000682s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42161989 ORDER BY `minOrder` ASC [ RunTime:0.001194s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42161989 ORDER BY `unit` DESC [ RunTime:0.000707s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42161989 LIMIT 2 [ RunTime:0.003895s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42161989 ORDER BY `minOrder` ASC [ RunTime:0.005476s ]
select * from pdf where partno='SMBJ10A' and brandshort='MDD' limit 1 [ RunTime:0.000896s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMBJ10A' OR `brand` LIKE 'MDD%' ) ) LIMIT 1 [ RunTime:0.003770s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42099777 LIMIT 5 [ RunTime:0.003653s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42099777 ORDER BY `minOrder` ASC [ RunTime:0.007322s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42099777 ORDER BY `unit` DESC [ RunTime:0.000882s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42099777 LIMIT 2 [ RunTime:0.000607s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42099777 ORDER BY `minOrder` ASC [ RunTime:0.000613s ]
select * from pdf where partno='SMBJ10A' and brandshort='Littelfuse Inc.' limit 1 [ RunTime:0.000403s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMBJ10A' OR `brand` LIKE 'Littelfuse Inc.%' ) ) LIMIT 1 [ RunTime:0.001095s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42113359 LIMIT 5 [ RunTime:0.010550s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42113359 ORDER BY `minOrder` ASC [ RunTime:0.007412s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42113359 ORDER BY `unit` DESC [ RunTime:0.006151s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42113359 LIMIT 2 [ RunTime:0.010954s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42113359 ORDER BY `minOrder` ASC [ RunTime:0.014049s ]
select * from pdf where partno='SMBJ10A' and brandshort='Bourns Inc.' limit 1 [ RunTime:0.023249s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMBJ10A' OR `brand` LIKE 'Bourns Inc.%' ) ) LIMIT 1 [ RunTime:0.003765s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42114247 LIMIT 5 [ RunTime:0.012149s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42114247 ORDER BY `minOrder` ASC [ RunTime:0.006246s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42114247 ORDER BY `unit` DESC [ RunTime:0.005217s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42114247 LIMIT 2 [ RunTime:0.001389s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42114247 ORDER BY `minOrder` ASC [ RunTime:0.000733s ]
select * from pdf where partno='SMBJ10A' and brandshort='Taiwan Semiconductor Corporation' limit 1 [ RunTime:0.011126s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMBJ10A' OR `brand` LIKE 'Taiwan Semiconductor Corporation%' ) ) LIMIT 1 [ RunTime:0.006229s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42149495 LIMIT 5 [ RunTime:0.010890s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42149495 ORDER BY `minOrder` ASC [ RunTime:0.007404s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42149495 ORDER BY `unit` DESC [ RunTime:0.004331s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42149495 LIMIT 2 [ RunTime:0.004411s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42149495 ORDER BY `minOrder` ASC [ RunTime:0.002102s ]
select * from pdf where partno='SMBJ10A' and brandshort='Good-Ark Semiconductor' limit 1 [ RunTime:0.009478s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMBJ10A' OR `brand` LIKE 'Good-Ark Semiconductor%' ) ) LIMIT 1 [ RunTime:0.004239s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42151445 LIMIT 5 [ RunTime:0.000943s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42151445 ORDER BY `minOrder` ASC [ RunTime:0.001681s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42151445 ORDER BY `unit` DESC [ RunTime:0.000984s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42151445 LIMIT 2 [ RunTime:0.002002s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42151445 ORDER BY `minOrder` ASC [ RunTime:0.001502s ]
select * from pdf where partno='SMBJ10A' and brandshort='Eaton - Electronics Division' limit 1 [ RunTime:0.001138s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMBJ10A' OR `brand` LIKE 'Eaton - Electronics Division%' ) ) LIMIT 1 [ RunTime:0.002692s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42141837 LIMIT 5 [ RunTime:0.003254s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42141837 ORDER BY `minOrder` ASC [ RunTime:0.001427s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42141837 ORDER BY `unit` DESC [ RunTime:0.002262s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42141837 LIMIT 2 [ RunTime:0.007968s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42141837 ORDER BY `minOrder` ASC [ RunTime:0.000968s ]
select * from pdf where partno='SMBJ10A' and brandshort='Semtech Corporation' limit 1 [ RunTime:0.002430s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMBJ10A' OR `brand` LIKE 'Semtech Corporation%' ) ) LIMIT 1 [ RunTime:0.001435s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42122953 LIMIT 5 [ RunTime:0.001176s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42122953 ORDER BY `minOrder` ASC [ RunTime:0.001117s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42122953 ORDER BY `unit` DESC [ RunTime:0.001362s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42122953 LIMIT 2 [ RunTime:0.003784s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42122953 ORDER BY `minOrder` ASC [ RunTime:0.005025s ]
select * from pdf where partno='SMBJ10A/TR13' and brandshort='YAGEO' limit 1 [ RunTime:0.003098s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMBJ10A/TR13' OR `brand` LIKE 'YAGEO%' ) ) LIMIT 1 [ RunTime:0.008313s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42114311 LIMIT 5 [ RunTime:0.003844s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42114311 ORDER BY `minOrder` ASC [ RunTime:0.005748s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42114311 ORDER BY `unit` DESC [ RunTime:0.002534s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42114311 LIMIT 2 [ RunTime:0.003477s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42114311 ORDER BY `minOrder` ASC [ RunTime:0.009727s ]
select * from pdf where partno='SMBJ10A-TR' and brandshort='STMicroelectronics' limit 1 [ RunTime:0.001345s ]
select foldpath,foldpath2,filename from pdf_file where id=446839 limit 1 [ RunTime:0.001945s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMBJ10A-TR' OR `brand` LIKE 'STMicroelectronics%' ) ) LIMIT 1 [ RunTime:0.001331s ]
SELECT `id` FROM `stock` WHERE `id` <> 42114311 AND `partno` = 'SMBJ10A-TR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%stmicroelectronics%' ) [ RunTime:0.004217s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16676258 [ RunTime:0.007896s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42101083 LIMIT 5 [ RunTime:0.004553s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42101083 ORDER BY `minOrder` ASC [ RunTime:0.003693s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42101083 ORDER BY `unit` DESC [ RunTime:0.011142s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42101083 LIMIT 2 [ RunTime:0.007738s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42101083 ORDER BY `minOrder` ASC [ RunTime:0.000872s ]
select * from pdf where partno='SMBJ10A-E3/52' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.006441s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMBJ10A-E3/52' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.005006s ]
SELECT `id` FROM `stock` WHERE `id` <> 42101083 AND `partno` = 'SMBJ10A-E3/52' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.008258s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13907538 [ RunTime:0.014392s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42160970 LIMIT 5 [ RunTime:0.010045s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42160970 ORDER BY `minOrder` ASC [ RunTime:0.001025s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42160970 ORDER BY `unit` DESC [ RunTime:0.000726s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42160970 LIMIT 2 [ RunTime:0.000758s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42160970 ORDER BY `minOrder` ASC [ RunTime:0.000733s ]
select * from pdf where partno='SMBJ10A' and brandshort='HY Electronic Cayman Limited' limit 1 [ RunTime:0.002178s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMBJ10A' OR `brand` LIKE 'HY Electronic (Cayman) Limited%' ) ) LIMIT 1 [ RunTime:0.006279s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42112009 LIMIT 5 [ RunTime:0.000676s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42112009 ORDER BY `minOrder` ASC [ RunTime:0.001147s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42112009 ORDER BY `unit` DESC [ RunTime:0.003266s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42112009 LIMIT 2 [ RunTime:0.000632s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42112009 ORDER BY `minOrder` ASC [ RunTime:0.000708s ]
select * from pdf where partno='SMBJ10A-TP' and brandshort='MCC Micro Commercial Components' limit 1 [ RunTime:0.004371s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMBJ10A-TP' OR `brand` LIKE 'MCC (Micro Commercial Components)%' ) ) LIMIT 1 [ RunTime:0.000805s ]
SELECT `id` FROM `stock` WHERE `id` <> 42112009 AND `partno` = 'SMBJ10A-TP' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%mcc%' ) [ RunTime:0.000934s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14817188 [ RunTime:0.003387s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42409788 LIMIT 5 [ RunTime:0.000959s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42409788 ORDER BY `minOrder` ASC [ RunTime:0.001158s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42409788 ORDER BY `unit` DESC [ RunTime:0.002944s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42409788 LIMIT 2 [ RunTime:0.001075s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42409788 ORDER BY `minOrder` ASC [ RunTime:0.000702s ]
select * from pdf where partno='SMBJ10A-HR' and brandshort='Littelfuse Inc.' limit 1 [ RunTime:0.001494s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMBJ10A-HR' OR `brand` LIKE 'Littelfuse Inc.%' ) ) LIMIT 1 [ RunTime:0.001753s ]
SELECT `id` FROM `stock` WHERE `id` <> 42409788 AND `partno` = 'SMBJ10A-HR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%littelfuse inc.%' ) [ RunTime:0.000907s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14823627 [ RunTime:0.004883s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42398054 LIMIT 5 [ RunTime:0.001794s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42398054 ORDER BY `minOrder` ASC [ RunTime:0.003159s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42398054 ORDER BY `unit` DESC [ RunTime:0.006917s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42398054 LIMIT 2 [ RunTime:0.004141s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42398054 ORDER BY `minOrder` ASC [ RunTime:0.001735s ]
select * from pdf where partno='SMBJ10A-HRA' and brandshort='Littelfuse Inc.' limit 1 [ RunTime:0.005383s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMBJ10A-HRA' OR `brand` LIKE 'Littelfuse Inc.%' ) ) LIMIT 1 [ RunTime:0.007903s ]
SELECT `id` FROM `stock` WHERE `id` <> 42398054 AND `partno` = 'SMBJ10A-HRA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%littelfuse inc.%' ) [ RunTime:0.002240s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13924545 [ RunTime:0.004958s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42296696 LIMIT 5 [ RunTime:0.008960s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42296696 ORDER BY `minOrder` ASC [ RunTime:0.007991s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42296696 ORDER BY `unit` DESC [ RunTime:0.010953s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42296696 LIMIT 2 [ RunTime:0.023331s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42296696 ORDER BY `minOrder` ASC [ RunTime:0.000947s ]
select * from pdf where partno='SMBJ10A-13' and brandshort='Diodes Incorporated' limit 1 [ RunTime:0.002219s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMBJ10A-13' OR `brand` LIKE 'Diodes Incorporated%' ) ) LIMIT 1 [ RunTime:0.012973s ]
SELECT `id` FROM `stock` WHERE `id` <> 42296696 AND `partno` = 'SMBJ10A-13' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%diodes incorporated%' ) [ RunTime:0.000957s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14820206 [ RunTime:0.001642s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42274334 LIMIT 5 [ RunTime:0.009304s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42274334 ORDER BY `minOrder` ASC [ RunTime:0.008316s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42274334 ORDER BY `unit` DESC [ RunTime:0.004619s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42274334 LIMIT 2 [ RunTime:0.000747s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42274334 ORDER BY `minOrder` ASC [ RunTime:0.000702s ]
select * from pdf where partno='SMBJ10A-E3/5B' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.012273s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMBJ10A-E3/5B' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.002483s ]
SELECT `id` FROM `stock` WHERE `id` <> 42274334 AND `partno` = 'SMBJ10A-E3/5B' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.000924s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14816218 [ RunTime:0.002858s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42266363 LIMIT 5 [ RunTime:0.000695s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42266363 ORDER BY `minOrder` ASC [ RunTime:0.004562s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42266363 ORDER BY `unit` DESC [ RunTime:0.005706s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42266363 LIMIT 2 [ RunTime:0.004925s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42266363 ORDER BY `minOrder` ASC [ RunTime:0.000729s ]
select * from pdf where partno='SMBJ10AE3/TR13' and brandshort='Microchip Technology' limit 1 [ RunTime:0.004940s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMBJ10AE3/TR13' OR `brand` LIKE 'Microchip Technology%' ) ) LIMIT 1 [ RunTime:0.002535s ]
SELECT `id` FROM `stock` WHERE `id` <> 42266363 AND `partno` = 'SMBJ10AE3/TR13' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%microchip technology%' ) [ RunTime:0.002840s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16674192 [ RunTime:0.006056s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42239371 LIMIT 5 [ RunTime:0.007691s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42239371 ORDER BY `minOrder` ASC [ RunTime:0.001509s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42239371 ORDER BY `unit` DESC [ RunTime:0.001070s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42239371 LIMIT 2 [ RunTime:0.000564s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42239371 ORDER BY `minOrder` ASC [ RunTime:0.015153s ]
select * from pdf where partno='SMBJ10AQ-13-F' and brandshort='Diodes Incorporated' limit 1 [ RunTime:0.001045s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMBJ10AQ-13-F' OR `brand` LIKE 'Diodes Incorporated%' ) ) LIMIT 1 [ RunTime:0.015089s ]
SELECT `id` FROM `stock` WHERE `id` <> 42239371 AND `partno` = 'SMBJ10AQ-13-F' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%diodes incorporated%' ) [ RunTime:0.001075s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16672321 [ RunTime:0.003984s ]
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 'SMBJ10A%' OR `brand` LIKE 'SMBJ10A%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001295s ]
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 'SMBJ10A%' OR `brand` LIKE 'SMBJ10A%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001013s ]
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 'SMBJ10A%' OR `brand` LIKE 'SMBJ10A%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000968s ]
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 'SMBJ10A%' OR `brand` LIKE 'SMBJ10A%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000955s ]
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 'SMBJ10A%' OR `brand` LIKE 'SMBJ10A%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000939s ]
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 'SMBJ10A%' OR `brand` LIKE 'SMBJ10A%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003304s ]
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 'SMBJ10A%' OR `brand` LIKE 'SMBJ10A%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001100s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'SMBJ10A%' OR `brand` LIKE 'SMBJ10A%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.001444s ]