SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001079s ]
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 'W4218%' OR `brand` LIKE 'W4218%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.044754s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.015036s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13257404 LIMIT 5 [ RunTime:0.038517s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.015056s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13257404 ORDER BY `minOrder` ASC [ RunTime:0.019761s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.006626s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13257404 ORDER BY `unit` DESC [ RunTime:0.031724s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.045680s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13257404 LIMIT 2 [ RunTime:0.017862s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13257404 ORDER BY `minOrder` ASC [ RunTime:0.021608s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18935274 LIMIT 5 [ RunTime:0.052462s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18935274 ORDER BY `minOrder` ASC [ RunTime:0.126611s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18935274 ORDER BY `unit` DESC [ RunTime:0.070351s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18935274 LIMIT 2 [ RunTime:0.053361s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18935274 ORDER BY `minOrder` ASC [ RunTime:0.025936s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18935199 LIMIT 5 [ RunTime:0.043205s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18935199 ORDER BY `minOrder` ASC [ RunTime:0.053531s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18935199 ORDER BY `unit` DESC [ RunTime:0.009385s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18935199 LIMIT 2 [ RunTime:0.052054s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18935199 ORDER BY `minOrder` ASC [ RunTime:0.030258s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18935198 LIMIT 5 [ RunTime:0.053522s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18935198 ORDER BY `minOrder` ASC [ RunTime:0.113784s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18935198 ORDER BY `unit` DESC [ RunTime:0.065455s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18935198 LIMIT 2 [ RunTime:0.064940s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18935198 ORDER BY `minOrder` ASC [ RunTime:0.050286s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18881320 LIMIT 5 [ RunTime:0.034346s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18881320 ORDER BY `minOrder` ASC [ RunTime:0.042454s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18881320 ORDER BY `unit` DESC [ RunTime:0.054807s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18881320 LIMIT 2 [ RunTime:0.052558s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18881320 ORDER BY `minOrder` ASC [ RunTime:0.008134s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18881176 LIMIT 5 [ RunTime:0.023609s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18881176 ORDER BY `minOrder` ASC [ RunTime:0.062454s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18881176 ORDER BY `unit` DESC [ RunTime:0.005878s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18881176 LIMIT 2 [ RunTime:0.009390s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18881176 ORDER BY `minOrder` ASC [ RunTime:0.014851s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18881008 LIMIT 5 [ RunTime:0.011219s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18881008 ORDER BY `minOrder` ASC [ RunTime:0.049844s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18881008 ORDER BY `unit` DESC [ RunTime:0.027158s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18881008 LIMIT 2 [ RunTime:0.041934s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18881008 ORDER BY `minOrder` ASC [ RunTime:0.025713s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18881007 LIMIT 5 [ RunTime:0.022944s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18881007 ORDER BY `minOrder` ASC [ RunTime:0.057005s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18881007 ORDER BY `unit` DESC [ RunTime:0.031017s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18881007 LIMIT 2 [ RunTime:0.081246s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18881007 ORDER BY `minOrder` ASC [ RunTime:0.000516s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18873374 LIMIT 5 [ RunTime:0.039853s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18873374 ORDER BY `minOrder` ASC [ RunTime:0.029656s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18873374 ORDER BY `unit` DESC [ RunTime:0.020065s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18873374 LIMIT 2 [ RunTime:0.018152s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18873374 ORDER BY `minOrder` ASC [ RunTime:0.000561s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18870705 LIMIT 5 [ RunTime:0.002274s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18870705 ORDER BY `minOrder` ASC [ RunTime:0.001109s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18870705 ORDER BY `unit` DESC [ RunTime:0.003861s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18870705 LIMIT 2 [ RunTime:0.016061s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18870705 ORDER BY `minOrder` ASC [ RunTime:0.007056s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16014623 LIMIT 5 [ RunTime:0.017326s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16014623 ORDER BY `minOrder` ASC [ RunTime:0.027867s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16014623 ORDER BY `unit` DESC [ RunTime:0.021646s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16014623 LIMIT 2 [ RunTime:0.003621s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16014623 ORDER BY `minOrder` ASC [ RunTime:0.010972s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15244957 LIMIT 5 [ RunTime:0.033196s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15244957 ORDER BY `minOrder` ASC [ RunTime:0.009733s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15244957 ORDER BY `unit` DESC [ RunTime:0.011320s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15244957 LIMIT 2 [ RunTime:0.009166s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15244957 ORDER BY `minOrder` ASC [ RunTime:0.019029s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15244922 LIMIT 5 [ RunTime:0.034663s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15244922 ORDER BY `minOrder` ASC [ RunTime:0.016550s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15244922 ORDER BY `unit` DESC [ RunTime:0.046486s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15244922 LIMIT 2 [ RunTime:0.024421s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15244922 ORDER BY `minOrder` ASC [ RunTime:0.019921s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14194790 LIMIT 5 [ RunTime:0.016976s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14194790 ORDER BY `minOrder` ASC [ RunTime:0.029957s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14194790 ORDER BY `unit` DESC [ RunTime:0.017702s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14194790 LIMIT 2 [ RunTime:0.012251s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14194790 ORDER BY `minOrder` ASC [ RunTime:0.018495s ]
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 'W4218%' OR `brand` LIKE 'W4218%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.024370s ]
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 'W4218%' OR `brand` LIKE 'W4218%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.026264s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37614613 LIMIT 5 [ RunTime:0.083615s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37614613 ORDER BY `minOrder` ASC [ RunTime:0.020703s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37614613 ORDER BY `unit` DESC [ RunTime:0.023407s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37614613 LIMIT 2 [ RunTime:0.066697s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37614613 ORDER BY `minOrder` ASC [ RunTime:0.000723s ]
select * from pdf where partno='W4218' and brandshort='Pulse Electronics' limit 1 [ RunTime:0.032036s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001755s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'W4218' OR `brand` LIKE 'Pulse Electronics%' ) ) LIMIT 1 [ RunTime:0.026575s ]
SELECT `id` FROM `stock` WHERE `id` <> 37614613 AND `partno` = 'W4218' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%pulse electronics%' ) [ RunTime:0.021514s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13257404 [ RunTime:0.026370s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 50417305 LIMIT 5 [ RunTime:0.011465s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50417305 ORDER BY `minOrder` ASC [ RunTime:0.007742s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 50417305 ORDER BY `unit` DESC [ RunTime:0.025240s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 50417305 LIMIT 2 [ RunTime:0.013259s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50417305 ORDER BY `minOrder` ASC [ RunTime:0.017412s ]
select * from pdf where partno='W4218' and brandshort='Pulse Electronics' limit 1 [ RunTime:0.008118s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'W4218' OR `brand` LIKE 'Pulse Electronics%' ) ) LIMIT 1 [ RunTime:0.040258s ]
SELECT `id` FROM `stock` WHERE `id` <> 50417305 AND `partno` = 'W4218' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%pulse electronics%' ) [ RunTime:0.031806s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13257404 [ RunTime:0.022694s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 41551353 LIMIT 5 [ RunTime:0.039887s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41551353 ORDER BY `minOrder` ASC [ RunTime:0.074222s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 41551353 ORDER BY `unit` DESC [ RunTime:0.023995s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 41551353 LIMIT 2 [ RunTime:0.025934s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41551353 ORDER BY `minOrder` ASC [ RunTime:0.008144s ]
select * from pdf where partno='W42180-06-U2-AR' and brandshort='Seoul Semiconductor Inc.' limit 1 [ RunTime:0.037404s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'W42180-06-U2-AR' OR `brand` LIKE 'Seoul Semiconductor Inc.%' ) ) LIMIT 1 [ RunTime:0.025275s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 41551339 LIMIT 5 [ RunTime:0.043203s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41551339 ORDER BY `minOrder` ASC [ RunTime:0.029705s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 41551339 ORDER BY `unit` DESC [ RunTime:0.026532s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 41551339 LIMIT 2 [ RunTime:0.016425s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41551339 ORDER BY `minOrder` ASC [ RunTime:0.009690s ]
select * from pdf where partno='W42180-U2' and brandshort='Seoul Semiconductor Inc.' limit 1 [ RunTime:0.005655s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'W42180-U2' OR `brand` LIKE 'Seoul Semiconductor Inc.%' ) ) LIMIT 1 [ RunTime:0.013547s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 41550832 LIMIT 5 [ RunTime:0.018831s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41550832 ORDER BY `minOrder` ASC [ RunTime:0.023823s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 41550832 ORDER BY `unit` DESC [ RunTime:0.011507s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 41550832 LIMIT 2 [ RunTime:0.022620s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41550832 ORDER BY `minOrder` ASC [ RunTime:0.013954s ]
select * from pdf where partno='W42180-06-U3-AA' and brandshort='Seoul Semiconductor Inc.' limit 1 [ RunTime:0.020087s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'W42180-06-U3-AA' OR `brand` LIKE 'Seoul Semiconductor Inc.%' ) ) LIMIT 1 [ RunTime:0.017266s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 41550659 LIMIT 5 [ RunTime:0.018883s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41550659 ORDER BY `minOrder` ASC [ RunTime:0.012967s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 41550659 ORDER BY `unit` DESC [ RunTime:0.028004s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 41550659 LIMIT 2 [ RunTime:0.013249s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41550659 ORDER BY `minOrder` ASC [ RunTime:0.007630s ]
select * from pdf where partno='W42180-U3' and brandshort='Seoul Semiconductor Inc.' limit 1 [ RunTime:0.019735s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'W42180-U3' OR `brand` LIKE 'Seoul Semiconductor Inc.%' ) ) LIMIT 1 [ RunTime:0.031211s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 41550157 LIMIT 5 [ RunTime:0.035178s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41550157 ORDER BY `minOrder` ASC [ RunTime:0.026450s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 41550157 ORDER BY `unit` DESC [ RunTime:0.056127s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 41550157 LIMIT 2 [ RunTime:0.056114s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41550157 ORDER BY `minOrder` ASC [ RunTime:0.010619s ]
select * from pdf where partno='W42180-07-U3-BA' and brandshort='Seoul Semiconductor Inc.' limit 1 [ RunTime:0.057397s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'W42180-07-U3-BA' OR `brand` LIKE 'Seoul Semiconductor Inc.%' ) ) LIMIT 1 [ RunTime:0.019414s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 41550156 LIMIT 5 [ RunTime:0.044088s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41550156 ORDER BY `minOrder` ASC [ RunTime:0.031501s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 41550156 ORDER BY `unit` DESC [ RunTime:0.019744s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 41550156 LIMIT 2 [ RunTime:0.047296s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41550156 ORDER BY `minOrder` ASC [ RunTime:0.026969s ]
select * from pdf where partno='W42180-06-U1-BA' and brandshort='Seoul Semiconductor Inc.' limit 1 [ RunTime:0.068863s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'W42180-06-U1-BA' OR `brand` LIKE 'Seoul Semiconductor Inc.%' ) ) LIMIT 1 [ RunTime:0.022699s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 41548995 LIMIT 5 [ RunTime:0.011785s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41548995 ORDER BY `minOrder` ASC [ RunTime:0.027841s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 41548995 ORDER BY `unit` DESC [ RunTime:0.017462s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 41548995 LIMIT 2 [ RunTime:0.035398s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41548995 ORDER BY `minOrder` ASC [ RunTime:0.020908s ]
select * from pdf where partno='W42180-06-U2' and brandshort='Seoul Semiconductor Inc.' limit 1 [ RunTime:0.015666s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'W42180-06-U2' OR `brand` LIKE 'Seoul Semiconductor Inc.%' ) ) LIMIT 1 [ RunTime:0.021450s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 41528474 LIMIT 5 [ RunTime:0.016537s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41528474 ORDER BY `minOrder` ASC [ RunTime:0.020307s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 41528474 ORDER BY `unit` DESC [ RunTime:0.045815s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 41528474 LIMIT 2 [ RunTime:0.092655s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41528474 ORDER BY `minOrder` ASC [ RunTime:0.038135s ]
select * from pdf where partno='W42180-08-V1W1-BA' and brandshort='Seoul Semiconductor Inc.' limit 1 [ RunTime:0.018058s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'W42180-08-V1W1-BA' OR `brand` LIKE 'Seoul Semiconductor Inc.%' ) ) LIMIT 1 [ RunTime:0.037610s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 41447440 LIMIT 5 [ RunTime:0.046111s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41447440 ORDER BY `minOrder` ASC [ RunTime:0.018255s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 41447440 ORDER BY `unit` DESC [ RunTime:0.021276s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 41447440 LIMIT 2 [ RunTime:0.023466s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41447440 ORDER BY `minOrder` ASC [ RunTime:0.010966s ]
select * from pdf where partno='W42182-U2' and brandshort='Seoul Semiconductor Inc.' limit 1 [ RunTime:0.015935s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'W42182-U2' OR `brand` LIKE 'Seoul Semiconductor Inc.%' ) ) LIMIT 1 [ RunTime:0.013761s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 41447368 LIMIT 5 [ RunTime:0.030750s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41447368 ORDER BY `minOrder` ASC [ RunTime:0.005938s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 41447368 ORDER BY `unit` DESC [ RunTime:0.025705s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 41447368 LIMIT 2 [ RunTime:0.019641s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41447368 ORDER BY `minOrder` ASC [ RunTime:0.010069s ]
select * from pdf where partno='W42182-08-V1V3' and brandshort='Seoul Semiconductor Inc.' limit 1 [ RunTime:0.044596s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'W42182-08-V1V3' OR `brand` LIKE 'Seoul Semiconductor Inc.%' ) ) LIMIT 1 [ RunTime:0.026993s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 41447367 LIMIT 5 [ RunTime:0.030679s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41447367 ORDER BY `minOrder` ASC [ RunTime:0.026914s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 41447367 ORDER BY `unit` DESC [ RunTime:0.038523s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 41447367 LIMIT 2 [ RunTime:0.049328s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41447367 ORDER BY `minOrder` ASC [ RunTime:0.028627s ]
select * from pdf where partno='W42182-U3' and brandshort='Seoul Semiconductor Inc.' limit 1 [ RunTime:0.021093s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'W42182-U3' OR `brand` LIKE 'Seoul Semiconductor Inc.%' ) ) LIMIT 1 [ RunTime:0.036442s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 41446458 LIMIT 5 [ RunTime:0.047469s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41446458 ORDER BY `minOrder` ASC [ RunTime:0.018994s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 41446458 ORDER BY `unit` DESC [ RunTime:0.038500s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 41446458 LIMIT 2 [ RunTime:0.021508s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41446458 ORDER BY `minOrder` ASC [ RunTime:0.008682s ]
select * from pdf where partno='W42182-U1' and brandshort='Seoul Semiconductor Inc.' limit 1 [ RunTime:0.010557s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'W42182-U1' OR `brand` LIKE 'Seoul Semiconductor Inc.%' ) ) LIMIT 1 [ RunTime:0.036168s ]
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 'W4218%' OR `brand` LIKE 'W4218%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.017094s ]
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 'W4218%' OR `brand` LIKE 'W4218%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.016899s ]
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 'W4218%' OR `brand` LIKE 'W4218%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.035145s ]
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 'W4218%' OR `brand` LIKE 'W4218%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.032247s ]
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 'W4218%' OR `brand` LIKE 'W4218%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.045723s ]
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 'W4218%' OR `brand` LIKE 'W4218%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.020720s ]
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 'W4218%' OR `brand` LIKE 'W4218%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.031963s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'W4218%' OR `brand` LIKE 'W4218%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.051033s ]