SHOW FULL COLUMNS FROM `stock` [ RunTime:0.003197s ]
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 '2834%' OR `brand` LIKE '2834%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.021143s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001416s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19667761 LIMIT 5 [ RunTime:0.033078s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.007470s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19667761 ORDER BY `minOrder` ASC [ RunTime:0.007316s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.001172s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19667761 ORDER BY `unit` DESC [ RunTime:0.047722s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.018836s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19667761 LIMIT 2 [ RunTime:0.113827s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19667761 ORDER BY `minOrder` ASC [ RunTime:0.071210s ]
select * from pdf where partno='2834167-3' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.046080s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12610137 LIMIT 5 [ RunTime:0.032827s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12610137 ORDER BY `minOrder` ASC [ RunTime:0.037614s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12610137 ORDER BY `unit` DESC [ RunTime:0.016875s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12610137 LIMIT 2 [ RunTime:0.009203s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12610137 ORDER BY `minOrder` ASC [ RunTime:0.010873s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12610138 LIMIT 5 [ RunTime:0.006839s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12610138 ORDER BY `minOrder` ASC [ RunTime:0.012252s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12610138 ORDER BY `unit` DESC [ RunTime:0.011466s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12610138 LIMIT 2 [ RunTime:0.001268s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12610138 ORDER BY `minOrder` ASC [ RunTime:0.000869s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11481715 LIMIT 5 [ RunTime:0.005760s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11481715 ORDER BY `minOrder` ASC [ RunTime:0.009330s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11481715 ORDER BY `unit` DESC [ RunTime:0.014756s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11481715 LIMIT 2 [ RunTime:0.001011s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11481715 ORDER BY `minOrder` ASC [ RunTime:0.000617s ]
select * from pdf where partno='2834464-5' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.003132s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19668473 LIMIT 5 [ RunTime:0.015328s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19668473 ORDER BY `minOrder` ASC [ RunTime:0.001655s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19668473 ORDER BY `unit` DESC [ RunTime:0.000665s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19668473 LIMIT 2 [ RunTime:0.000752s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19668473 ORDER BY `minOrder` ASC [ RunTime:0.001002s ]
select * from pdf where partno='2834049-3' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.003567s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17313875 LIMIT 5 [ RunTime:0.005404s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17313875 ORDER BY `minOrder` ASC [ RunTime:0.001164s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17313875 ORDER BY `unit` DESC [ RunTime:0.000816s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17313875 LIMIT 2 [ RunTime:0.000444s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17313875 ORDER BY `minOrder` ASC [ RunTime:0.000386s ]
select * from pdf where partno='2834048-3' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.002561s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19668113 LIMIT 5 [ RunTime:0.006256s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19668113 ORDER BY `minOrder` ASC [ RunTime:0.000454s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19668113 ORDER BY `unit` DESC [ RunTime:0.001254s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19668113 LIMIT 2 [ RunTime:0.000514s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19668113 ORDER BY `minOrder` ASC [ RunTime:0.000373s ]
select * from pdf where partno='2834049-2' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.002137s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17313876 LIMIT 5 [ RunTime:0.000434s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17313876 ORDER BY `minOrder` ASC [ RunTime:0.000396s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17313876 ORDER BY `unit` DESC [ RunTime:0.000380s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17313876 LIMIT 2 [ RunTime:0.000375s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17313876 ORDER BY `minOrder` ASC [ RunTime:0.000384s ]
select * from pdf where partno='2834048-4' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.001696s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19668111 LIMIT 5 [ RunTime:0.000376s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19668111 ORDER BY `minOrder` ASC [ RunTime:0.000398s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19668111 ORDER BY `unit` DESC [ RunTime:0.000374s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19668111 LIMIT 2 [ RunTime:0.000332s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19668111 ORDER BY `minOrder` ASC [ RunTime:0.000959s ]
select * from pdf where partno='2834048-2' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.001988s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15454122 LIMIT 5 [ RunTime:0.000808s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15454122 ORDER BY `minOrder` ASC [ RunTime:0.000740s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15454122 ORDER BY `unit` DESC [ RunTime:0.000377s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15454122 LIMIT 2 [ RunTime:0.000446s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15454122 ORDER BY `minOrder` ASC [ RunTime:0.000470s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19668112 LIMIT 5 [ RunTime:0.000800s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19668112 ORDER BY `minOrder` ASC [ RunTime:0.000482s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19668112 ORDER BY `unit` DESC [ RunTime:0.000461s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19668112 LIMIT 2 [ RunTime:0.000463s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19668112 ORDER BY `minOrder` ASC [ RunTime:0.000564s ]
select * from pdf where partno='2834048-1' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.002493s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12556536 LIMIT 5 [ RunTime:0.000894s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12556536 ORDER BY `minOrder` ASC [ RunTime:0.008449s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12556536 ORDER BY `unit` DESC [ RunTime:0.000567s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12556536 LIMIT 2 [ RunTime:0.000641s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12556536 ORDER BY `minOrder` ASC [ RunTime:0.000616s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19668402 LIMIT 5 [ RunTime:0.000995s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19668402 ORDER BY `minOrder` ASC [ RunTime:0.000624s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19668402 ORDER BY `unit` DESC [ RunTime:0.000864s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19668402 LIMIT 2 [ RunTime:0.001090s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19668402 ORDER BY `minOrder` ASC [ RunTime:0.000624s ]
select * from pdf where partno='2834049-4' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.004184s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19668117 LIMIT 5 [ RunTime:0.000734s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19668117 ORDER BY `minOrder` ASC [ RunTime:0.000521s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19668117 ORDER BY `unit` DESC [ RunTime:0.001829s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19668117 LIMIT 2 [ RunTime:0.000944s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19668117 ORDER BY `minOrder` ASC [ RunTime:0.000586s ]
select * from pdf where partno='2834006-2' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.002728s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19668115 LIMIT 5 [ RunTime:0.000541s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19668115 ORDER BY `minOrder` ASC [ RunTime:0.000462s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19668115 ORDER BY `unit` DESC [ RunTime:0.000448s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19668115 LIMIT 2 [ RunTime:0.000672s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19668115 ORDER BY `minOrder` ASC [ RunTime:0.000560s ]
select * from pdf where partno='2834049-1' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.001828s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19667784 LIMIT 5 [ RunTime:0.001545s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19667784 ORDER BY `minOrder` ASC [ RunTime:0.000425s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19667784 ORDER BY `unit` DESC [ RunTime:0.000452s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19667784 LIMIT 2 [ RunTime:0.000438s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19667784 ORDER BY `minOrder` ASC [ RunTime:0.000386s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19668408 LIMIT 5 [ RunTime:0.000521s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19668408 ORDER BY `minOrder` ASC [ RunTime:0.000450s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19668408 ORDER BY `unit` DESC [ RunTime:0.000437s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19668408 LIMIT 2 [ RunTime:0.000361s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19668408 ORDER BY `minOrder` ASC [ RunTime:0.000380s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19668479 LIMIT 5 [ RunTime:0.000435s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19668479 ORDER BY `minOrder` ASC [ RunTime:0.000484s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19668479 ORDER BY `unit` DESC [ RunTime:0.000537s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19668479 LIMIT 2 [ RunTime:0.000395s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19668479 ORDER BY `minOrder` ASC [ RunTime:0.000633s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17313718 LIMIT 5 [ RunTime:0.000918s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17313718 ORDER BY `minOrder` ASC [ RunTime:0.008031s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17313718 ORDER BY `unit` DESC [ RunTime:0.000475s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17313718 LIMIT 2 [ RunTime:0.001217s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17313718 ORDER BY `minOrder` ASC [ RunTime:0.000427s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12544141 LIMIT 5 [ RunTime:0.001027s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12544141 ORDER BY `minOrder` ASC [ RunTime:0.000505s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12544141 ORDER BY `unit` DESC [ RunTime:0.001883s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12544141 LIMIT 2 [ RunTime:0.000714s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12544141 ORDER BY `minOrder` ASC [ RunTime:0.000508s ]
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 '2834%' OR `brand` LIKE '2834%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002680s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51070268 LIMIT 5 [ RunTime:0.000475s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51070268 ORDER BY `minOrder` ASC [ RunTime:0.001341s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51070268 ORDER BY `unit` DESC [ RunTime:0.000456s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51070268 LIMIT 2 [ RunTime:0.000712s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51070268 ORDER BY `minOrder` ASC [ RunTime:0.000509s ]
select * from pdf where partno='2834048-3' and brandshort='te connectivity' limit 1 [ RunTime:0.002848s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001558s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2834048-3' OR `brand` LIKE 'te connectivity%' ) ) LIMIT 1 [ RunTime:0.021682s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51070414 LIMIT 5 [ RunTime:0.002432s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51070414 ORDER BY `minOrder` ASC [ RunTime:0.000931s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51070414 ORDER BY `unit` DESC [ RunTime:0.001255s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51070414 LIMIT 2 [ RunTime:0.001302s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51070414 ORDER BY `minOrder` ASC [ RunTime:0.000643s ]
select * from pdf where partno='2834049-2' and brandshort='te connectivity' limit 1 [ RunTime:0.001182s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2834049-2' OR `brand` LIKE 'te connectivity%' ) ) LIMIT 1 [ RunTime:0.018258s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51070416 LIMIT 5 [ RunTime:0.000590s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51070416 ORDER BY `minOrder` ASC [ RunTime:0.002602s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51070416 ORDER BY `unit` DESC [ RunTime:0.000639s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51070416 LIMIT 2 [ RunTime:0.010628s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51070416 ORDER BY `minOrder` ASC [ RunTime:0.002417s ]
select * from pdf where partno='2834167-3' and brandshort='te connectivity / p&b' limit 1 [ RunTime:0.001006s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2834167-3' OR `brand` LIKE 'te connectivity / p&b%' ) ) LIMIT 1 [ RunTime:0.004376s ]
SELECT `id` FROM `stock` WHERE `id` <> 51070416 AND `partno` = '2834167-3' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity / p&b%' ) [ RunTime:0.006408s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51070658 LIMIT 5 [ RunTime:0.000792s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51070658 ORDER BY `minOrder` ASC [ RunTime:0.003390s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51070658 ORDER BY `unit` DESC [ RunTime:0.001865s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51070658 LIMIT 2 [ RunTime:0.000839s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51070658 ORDER BY `minOrder` ASC [ RunTime:0.000800s ]
select * from pdf where partno='2834010-3' and brandshort='te connectivity / raychem' limit 1 [ RunTime:0.002276s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2834010-3' OR `brand` LIKE 'te connectivity / raychem%' ) ) LIMIT 1 [ RunTime:0.005971s ]
SELECT `id` FROM `stock` WHERE `id` <> 51070658 AND `partno` = '2834010-3' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity / raychem%' ) [ RunTime:0.001555s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51070229 LIMIT 5 [ RunTime:0.002360s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51070229 ORDER BY `minOrder` ASC [ RunTime:0.002535s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51070229 ORDER BY `unit` DESC [ RunTime:0.000456s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51070229 LIMIT 2 [ RunTime:0.001417s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51070229 ORDER BY `minOrder` ASC [ RunTime:0.000724s ]
select * from pdf where partno='2834171-3' and brandshort='te connectivity' limit 1 [ RunTime:0.002828s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2834171-3' OR `brand` LIKE 'te connectivity%' ) ) LIMIT 1 [ RunTime:0.028393s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51070696 LIMIT 5 [ RunTime:0.013083s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51070696 ORDER BY `minOrder` ASC [ RunTime:0.006368s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51070696 ORDER BY `unit` DESC [ RunTime:0.018718s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51070696 LIMIT 2 [ RunTime:0.005980s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51070696 ORDER BY `minOrder` ASC [ RunTime:0.004788s ]
select * from pdf where partno='2834036-1' and brandshort='te connectivity / amp' limit 1 [ RunTime:0.013362s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2834036-1' OR `brand` LIKE 'te connectivity / amp%' ) ) LIMIT 1 [ RunTime:0.007120s ]
SELECT `id` FROM `stock` WHERE `id` <> 51070696 AND `partno` = '2834036-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity / amp%' ) [ RunTime:0.007337s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51070413 LIMIT 5 [ RunTime:0.011374s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51070413 ORDER BY `minOrder` ASC [ RunTime:0.015400s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51070413 ORDER BY `unit` DESC [ RunTime:0.004206s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51070413 LIMIT 2 [ RunTime:0.008571s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51070413 ORDER BY `minOrder` ASC [ RunTime:0.003261s ]
select * from pdf where partno='2834048-2' and brandshort='te connectivity' limit 1 [ RunTime:0.006797s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2834048-2' OR `brand` LIKE 'te connectivity%' ) ) LIMIT 1 [ RunTime:0.026867s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51070697 LIMIT 5 [ RunTime:0.016577s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51070697 ORDER BY `minOrder` ASC [ RunTime:0.010738s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51070697 ORDER BY `unit` DESC [ RunTime:0.012130s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51070697 LIMIT 2 [ RunTime:0.024607s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51070697 ORDER BY `minOrder` ASC [ RunTime:0.001312s ]
select * from pdf where partno='2834037-1' and brandshort='te connectivity / amp' limit 1 [ RunTime:0.011639s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2834037-1' OR `brand` LIKE 'te connectivity / amp%' ) ) LIMIT 1 [ RunTime:0.015391s ]
SELECT `id` FROM `stock` WHERE `id` <> 51070697 AND `partno` = '2834037-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity / amp%' ) [ RunTime:0.004434s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51070225 LIMIT 5 [ RunTime:0.021852s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51070225 ORDER BY `minOrder` ASC [ RunTime:0.014562s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51070225 ORDER BY `unit` DESC [ RunTime:0.013226s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51070225 LIMIT 2 [ RunTime:0.010162s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51070225 ORDER BY `minOrder` ASC [ RunTime:0.000426s ]
select * from pdf where partno='2834049-4' and brandshort='te connectivity' limit 1 [ RunTime:0.003073s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2834049-4' OR `brand` LIKE 'te connectivity%' ) ) LIMIT 1 [ RunTime:0.018838s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51070411 LIMIT 5 [ RunTime:0.009513s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51070411 ORDER BY `minOrder` ASC [ RunTime:0.003680s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51070411 ORDER BY `unit` DESC [ RunTime:0.011334s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51070411 LIMIT 2 [ RunTime:0.005752s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51070411 ORDER BY `minOrder` ASC [ RunTime:0.004462s ]
select * from pdf where partno='2834006-2' and brandshort='te connectivity' limit 1 [ RunTime:0.007498s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2834006-2' OR `brand` LIKE 'te connectivity%' ) ) LIMIT 1 [ RunTime:0.024736s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51070536 LIMIT 5 [ RunTime:0.006511s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51070536 ORDER BY `minOrder` ASC [ RunTime:0.009702s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51070536 ORDER BY `unit` DESC [ RunTime:0.007168s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51070536 LIMIT 2 [ RunTime:0.016390s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51070536 ORDER BY `minOrder` ASC [ RunTime:0.010266s ]
select * from pdf where partno='2834012-3' and brandshort='te connectivity / p&b' limit 1 [ RunTime:0.013407s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2834012-3' OR `brand` LIKE 'te connectivity / p&b%' ) ) LIMIT 1 [ RunTime:0.008676s ]
SELECT `id` FROM `stock` WHERE `id` <> 51070536 AND `partno` = '2834012-3' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity / p&b%' ) [ RunTime:0.009632s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51070412 LIMIT 5 [ RunTime:0.008749s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51070412 ORDER BY `minOrder` ASC [ RunTime:0.006727s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51070412 ORDER BY `unit` DESC [ RunTime:0.008385s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51070412 LIMIT 2 [ RunTime:0.015196s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51070412 ORDER BY `minOrder` ASC [ RunTime:0.008414s ]
select * from pdf where partno='2834048-1' and brandshort='te connectivity / raychem' limit 1 [ RunTime:0.010834s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2834048-1' OR `brand` LIKE 'te connectivity / raychem%' ) ) LIMIT 1 [ RunTime:0.002236s ]
SELECT `id` FROM `stock` WHERE `id` <> 51070412 AND `partno` = '2834048-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity / raychem%' ) [ RunTime:0.009012s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51070659 LIMIT 5 [ RunTime:0.009399s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51070659 ORDER BY `minOrder` ASC [ RunTime:0.007097s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51070659 ORDER BY `unit` DESC [ RunTime:0.002706s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51070659 LIMIT 2 [ RunTime:0.004734s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51070659 ORDER BY `minOrder` ASC [ RunTime:0.005493s ]
select * from pdf where partno='2834049-1' and brandshort='te connectivity' limit 1 [ RunTime:0.006737s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2834049-1' OR `brand` LIKE 'te connectivity%' ) ) LIMIT 1 [ RunTime:0.024520s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32275954 LIMIT 5 [ RunTime:0.008074s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32275954 ORDER BY `minOrder` ASC [ RunTime:0.002430s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32275954 ORDER BY `unit` DESC [ RunTime:0.005599s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32275954 LIMIT 2 [ RunTime:0.019247s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32275954 ORDER BY `minOrder` ASC [ RunTime:0.015657s ]
select * from pdf where partno='2834082-1' and brandshort='te connectivity' limit 1 [ RunTime:0.008429s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2834082-1' OR `brand` LIKE 'te connectivity%' ) ) LIMIT 1 [ RunTime:0.027183s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51070660 LIMIT 5 [ RunTime:0.013779s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51070660 ORDER BY `minOrder` ASC [ RunTime:0.015555s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51070660 ORDER BY `unit` DESC [ RunTime:0.013588s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51070660 LIMIT 2 [ RunTime:0.025939s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51070660 ORDER BY `minOrder` ASC [ RunTime:0.006929s ]
select * from pdf where partno='2834055-3' and brandshort='te connectivity' limit 1 [ RunTime:0.008832s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2834055-3' OR `brand` LIKE 'te connectivity%' ) ) LIMIT 1 [ RunTime:0.035911s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32275955 LIMIT 5 [ RunTime:0.004582s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32275955 ORDER BY `minOrder` ASC [ RunTime:0.007188s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32275955 ORDER BY `unit` DESC [ RunTime:0.009535s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32275955 LIMIT 2 [ RunTime:0.007131s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32275955 ORDER BY `minOrder` ASC [ RunTime:0.004351s ]
select * from pdf where partno='2834098-1' and brandshort='te connectivity / raychem' limit 1 [ RunTime:0.002365s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2834098-1' OR `brand` LIKE 'te connectivity / raychem%' ) ) LIMIT 1 [ RunTime:0.002191s ]
SELECT `id` FROM `stock` WHERE `id` <> 32275955 AND `partno` = '2834098-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity / raychem%' ) [ RunTime:0.008005s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51070415 LIMIT 5 [ RunTime:0.004781s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51070415 ORDER BY `minOrder` ASC [ RunTime:0.007672s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51070415 ORDER BY `unit` DESC [ RunTime:0.008408s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51070415 LIMIT 2 [ RunTime:0.006135s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51070415 ORDER BY `minOrder` ASC [ RunTime:0.007464s ]
select * from pdf where partno='2834055-1' and brandshort='te connectivity' limit 1 [ RunTime:0.009306s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2834055-1' OR `brand` LIKE 'te connectivity%' ) ) LIMIT 1 [ RunTime:0.024114s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51070647 LIMIT 5 [ RunTime:0.009600s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51070647 ORDER BY `minOrder` ASC [ RunTime:0.012609s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51070647 ORDER BY `unit` DESC [ RunTime:0.021547s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51070647 LIMIT 2 [ RunTime:0.007307s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51070647 ORDER BY `minOrder` ASC [ RunTime:0.022201s ]
select * from pdf where partno='2834171-3 (mouser reel)' and brandshort='te connectivity / amp' limit 1 [ RunTime:0.006406s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2834171-3 (mouser reel)' OR `brand` LIKE 'te connectivity / amp%' ) ) LIMIT 1 [ RunTime:0.011259s ]
SELECT `id` FROM `stock` WHERE `id` <> 51070647 AND `partno` = '2834171-3 (mouser reel)' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity / amp%' ) [ RunTime:0.015531s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32275953 LIMIT 5 [ RunTime:0.009072s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32275953 ORDER BY `minOrder` ASC [ RunTime:0.010486s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32275953 ORDER BY `unit` DESC [ RunTime:0.016738s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32275953 LIMIT 2 [ RunTime:0.029783s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32275953 ORDER BY `minOrder` ASC [ RunTime:0.006668s ]
select * from pdf where partno='2834076-1' and brandshort='te connectivity' limit 1 [ RunTime:0.014720s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2834076-1' OR `brand` LIKE 'te connectivity%' ) ) LIMIT 1 [ RunTime:0.035653s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32275625 LIMIT 5 [ RunTime:0.026801s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32275625 ORDER BY `minOrder` ASC [ RunTime:0.014140s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32275625 ORDER BY `unit` DESC [ RunTime:0.007948s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32275625 LIMIT 2 [ RunTime:0.011549s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32275625 ORDER BY `minOrder` ASC [ RunTime:0.006426s ]
select * from pdf where partno='2834078-1' and brandshort='te connectivity' limit 1 [ RunTime:0.013388s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2834078-1' OR `brand` LIKE 'te connectivity%' ) ) LIMIT 1 [ RunTime:0.034121s ]
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 '2834%' OR `brand` LIKE '2834%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.014167s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62126252 LIMIT 5 [ RunTime:0.001874s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62126252 ORDER BY `minOrder` ASC [ RunTime:0.008551s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62126252 ORDER BY `unit` DESC [ RunTime:0.019003s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62126252 LIMIT 2 [ RunTime:0.019846s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62126252 ORDER BY `minOrder` ASC [ RunTime:0.006550s ]
select * from pdf where partno='2834171-3' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.010735s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2834171-3' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.008096s ]
SELECT `id` FROM `stock` WHERE `id` <> 62126252 AND `partno` = '2834171-3' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.008428s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17313717 [ RunTime:0.012682s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62125167 LIMIT 5 [ RunTime:0.010091s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62125167 ORDER BY `minOrder` ASC [ RunTime:0.029530s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62125167 ORDER BY `unit` DESC [ RunTime:0.010457s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62125167 LIMIT 2 [ RunTime:0.005249s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62125167 ORDER BY `minOrder` ASC [ RunTime:0.000402s ]
select * from pdf where partno='2834049-3' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.006975s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2834049-3' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.002612s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60345773 LIMIT 5 [ RunTime:0.002018s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60345773 ORDER BY `minOrder` ASC [ RunTime:0.006852s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60345773 ORDER BY `unit` DESC [ RunTime:0.015327s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60345773 LIMIT 2 [ RunTime:0.015936s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60345773 ORDER BY `minOrder` ASC [ RunTime:0.008804s ]
select * from pdf where partno='2834666-1' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.001060s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2834666-1' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.002126s ]
SELECT `id` FROM `stock` WHERE `id` <> 60345773 AND `partno` = '2834666-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.010353s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12610137 [ RunTime:0.007240s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60345774 LIMIT 5 [ RunTime:0.007256s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60345774 ORDER BY `minOrder` ASC [ RunTime:0.005891s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60345774 ORDER BY `unit` DESC [ RunTime:0.000905s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60345774 LIMIT 2 [ RunTime:0.000658s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60345774 ORDER BY `minOrder` ASC [ RunTime:0.000461s ]
select * from pdf where partno='2834666-2' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.005588s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2834666-2' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.003348s ]
SELECT `id` FROM `stock` WHERE `id` <> 60345774 AND `partno` = '2834666-2' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.003284s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12610138 [ RunTime:0.003086s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62125166 LIMIT 5 [ RunTime:0.006691s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62125166 ORDER BY `minOrder` ASC [ RunTime:0.015288s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62125166 ORDER BY `unit` DESC [ RunTime:0.020592s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62125166 LIMIT 2 [ RunTime:0.000577s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62125166 ORDER BY `minOrder` ASC [ RunTime:0.000413s ]
select * from pdf where partno='2834048-3' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.000610s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2834048-3' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.013214s ]
SELECT `id` FROM `stock` WHERE `id` <> 62125166 AND `partno` = '2834048-3' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.003898s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17313875 [ RunTime:0.000658s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62125408 LIMIT 5 [ RunTime:0.008582s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62125408 ORDER BY `minOrder` ASC [ RunTime:0.008948s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62125408 ORDER BY `unit` DESC [ RunTime:0.009927s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62125408 LIMIT 2 [ RunTime:0.006930s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62125408 ORDER BY `minOrder` ASC [ RunTime:0.000361s ]
select * from pdf where partno='2834048-4' and brandshort='TE Connectivity' limit 1 [ RunTime:0.000831s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2834048-4' OR `brand` LIKE 'TE Connectivity%' ) ) LIMIT 1 [ RunTime:0.031084s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62125064 LIMIT 5 [ RunTime:0.002536s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62125064 ORDER BY `minOrder` ASC [ RunTime:0.001300s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62125064 ORDER BY `unit` DESC [ RunTime:0.010980s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62125064 LIMIT 2 [ RunTime:0.003119s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62125064 ORDER BY `minOrder` ASC [ RunTime:0.002975s ]
select * from pdf where partno='2834048-4' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.006373s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2834048-4' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.012041s ]
SELECT `id` FROM `stock` WHERE `id` <> 62125064 AND `partno` = '2834048-4' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.008696s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17313876 [ RunTime:0.016804s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62126270 LIMIT 5 [ RunTime:0.002305s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62126270 ORDER BY `minOrder` ASC [ RunTime:0.004397s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62126270 ORDER BY `unit` DESC [ RunTime:0.004009s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62126270 LIMIT 2 [ RunTime:0.012638s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62126270 ORDER BY `minOrder` ASC [ RunTime:0.001800s ]
select * from pdf where partno='2834010-3' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.000947s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2834010-3' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.002438s ]
SELECT `id` FROM `stock` WHERE `id` <> 62126270 AND `partno` = '2834010-3' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.002579s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17313718 [ RunTime:0.003500s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60344028 LIMIT 5 [ RunTime:0.012033s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60344028 ORDER BY `minOrder` ASC [ RunTime:0.003741s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60344028 ORDER BY `unit` DESC [ RunTime:0.001813s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60344028 LIMIT 2 [ RunTime:0.007914s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60344028 ORDER BY `minOrder` ASC [ RunTime:0.008466s ]
select * from pdf where partno='2834464-5' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.006082s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2834464-5' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.000930s ]
SELECT `id` FROM `stock` WHERE `id` <> 60344028 AND `partno` = '2834464-5' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.007379s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11481715 [ RunTime:0.002693s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62124983 LIMIT 5 [ RunTime:0.006473s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62124983 ORDER BY `minOrder` ASC [ RunTime:0.003668s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62124983 ORDER BY `unit` DESC [ RunTime:0.012373s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62124983 LIMIT 2 [ RunTime:0.016613s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62124983 ORDER BY `minOrder` ASC [ RunTime:0.004802s ]
select * from pdf where partno='2834006-1' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.010944s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2834006-1' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.012810s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62124987 LIMIT 5 [ RunTime:0.011987s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62124987 ORDER BY `minOrder` ASC [ RunTime:0.003057s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62124987 ORDER BY `unit` DESC [ RunTime:0.009199s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62124987 LIMIT 2 [ RunTime:0.003723s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62124987 ORDER BY `minOrder` ASC [ RunTime:0.009440s ]
select * from pdf where partno='2834049-2' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.001308s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2834049-2' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.002418s ]
SELECT `id` FROM `stock` WHERE `id` <> 62124987 AND `partno` = '2834049-2' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.005947s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19668113 [ RunTime:0.002999s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60559763 LIMIT 5 [ RunTime:0.018486s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60559763 ORDER BY `minOrder` ASC [ RunTime:0.010115s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60559763 ORDER BY `unit` DESC [ RunTime:0.000805s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60559763 LIMIT 2 [ RunTime:0.002461s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60559763 ORDER BY `minOrder` ASC [ RunTime:0.000520s ]
select * from pdf where partno='2834076-1' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.001234s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2834076-1' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.000938s ]
SELECT `id` FROM `stock` WHERE `id` <> 60559763 AND `partno` = '2834076-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.003448s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12556536 [ RunTime:0.004882s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62126279 LIMIT 5 [ RunTime:0.000917s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62126279 ORDER BY `minOrder` ASC [ RunTime:0.001615s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62126279 ORDER BY `unit` DESC [ RunTime:0.002754s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62126279 LIMIT 2 [ RunTime:0.007953s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62126279 ORDER BY `minOrder` ASC [ RunTime:0.007056s ]
select * from pdf where partno='2834012-3' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.001286s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2834012-3' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.000912s ]
SELECT `id` FROM `stock` WHERE `id` <> 62126279 AND `partno` = '2834012-3' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.001649s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15454122 [ RunTime:0.000820s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62124985 LIMIT 5 [ RunTime:0.000781s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62124985 ORDER BY `minOrder` ASC [ RunTime:0.000975s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62124985 ORDER BY `unit` DESC [ RunTime:0.010014s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62124985 LIMIT 2 [ RunTime:0.000745s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62124985 ORDER BY `minOrder` ASC [ RunTime:0.000772s ]
select * from pdf where partno='2834048-2' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.007579s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2834048-2' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.000879s ]
SELECT `id` FROM `stock` WHERE `id` <> 62124985 AND `partno` = '2834048-2' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.001052s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19668111 [ RunTime:0.003272s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62125067 LIMIT 5 [ RunTime:0.003616s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62125067 ORDER BY `minOrder` ASC [ RunTime:0.011586s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62125067 ORDER BY `unit` DESC [ RunTime:0.000843s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62125067 LIMIT 2 [ RunTime:0.004527s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62125067 ORDER BY `minOrder` ASC [ RunTime:0.002584s ]
select * from pdf where partno='2834049-4' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.001029s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2834049-4' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.001351s ]
SELECT `id` FROM `stock` WHERE `id` <> 62125067 AND `partno` = '2834049-4' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.001908s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19668402 [ RunTime:0.003570s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62125012 LIMIT 5 [ RunTime:0.005465s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62125012 ORDER BY `minOrder` ASC [ RunTime:0.000846s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62125012 ORDER BY `unit` DESC [ RunTime:0.005275s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62125012 LIMIT 2 [ RunTime:0.002392s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62125012 ORDER BY `minOrder` ASC [ RunTime:0.003030s ]
select * from pdf where partno='2834006-3' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.000900s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2834006-3' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.007538s ]
SELECT `id` FROM `stock` WHERE `id` <> 62125012 AND `partno` = '2834006-3' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.000966s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19668133 [ RunTime:0.001474s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62124986 LIMIT 5 [ RunTime:0.003123s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62124986 ORDER BY `minOrder` ASC [ RunTime:0.005180s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62124986 ORDER BY `unit` DESC [ RunTime:0.001758s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62124986 LIMIT 2 [ RunTime:0.003551s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62124986 ORDER BY `minOrder` ASC [ RunTime:0.001158s ]
select * from pdf where partno='2834048-1' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.001774s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2834048-1' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.007959s ]
SELECT `id` FROM `stock` WHERE `id` <> 62124986 AND `partno` = '2834048-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.009609s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19668112 [ RunTime:0.012029s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60345114 LIMIT 5 [ RunTime:0.016397s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60345114 ORDER BY `minOrder` ASC [ RunTime:0.006964s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60345114 ORDER BY `unit` DESC [ RunTime:0.002554s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60345114 LIMIT 2 [ RunTime:0.005355s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60345114 ORDER BY `minOrder` ASC [ RunTime:0.004730s ]
select * from pdf where partno='2834464-6' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.001938s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2834464-6' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.000971s ]
SELECT `id` FROM `stock` WHERE `id` <> 60345114 AND `partno` = '2834464-6' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.001184s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62125173 LIMIT 5 [ RunTime:0.001866s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62125173 ORDER BY `minOrder` ASC [ RunTime:0.001273s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62125173 ORDER BY `unit` DESC [ RunTime:0.000833s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62125173 LIMIT 2 [ RunTime:0.009095s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62125173 ORDER BY `minOrder` ASC [ RunTime:0.004350s ]
select * from pdf where partno='2834054-4' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.004615s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2834054-4' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.001721s ]
SELECT `id` FROM `stock` WHERE `id` <> 62125173 AND `partno` = '2834054-4' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.006576s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19668479 [ RunTime:0.009556s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60561229 LIMIT 5 [ RunTime:0.002659s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60561229 ORDER BY `minOrder` ASC [ RunTime:0.015028s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60561229 ORDER BY `unit` DESC [ RunTime:0.002440s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60561229 LIMIT 2 [ RunTime:0.005891s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60561229 ORDER BY `minOrder` ASC [ RunTime:0.001801s ]
select * from pdf where partno='2834080-1' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.006372s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2834080-1' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.003766s ]
SELECT `id` FROM `stock` WHERE `id` <> 60561229 AND `partno` = '2834080-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.003361s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12544141 [ RunTime:0.000879s ]
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 '2834%' OR `brand` LIKE '2834%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.008110s ]
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 '2834%' OR `brand` LIKE '2834%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.007755s ]
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 '2834%' OR `brand` LIKE '2834%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.021930s ]
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 '2834%' OR `brand` LIKE '2834%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001281s ]
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 '2834%' OR `brand` LIKE '2834%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.004412s ]
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 '2834%' OR `brand` LIKE '2834%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.004523s ]
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 '2834%' OR `brand` LIKE '2834%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.004999s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '2834%' OR `brand` LIKE '2834%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.005341s ]