SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001414s ]
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 '6042%' OR `brand` LIKE '6042%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.067142s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001019s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14793998 LIMIT 5 [ RunTime:0.022729s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.054940s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14793998 ORDER BY `minOrder` ASC [ RunTime:0.002493s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.002407s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14793998 ORDER BY `unit` DESC [ RunTime:0.015438s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.004356s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14793998 LIMIT 2 [ RunTime:0.021274s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14793998 ORDER BY `minOrder` ASC [ RunTime:0.014067s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13343827 LIMIT 5 [ RunTime:0.037694s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13343827 ORDER BY `minOrder` ASC [ RunTime:0.050248s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13343827 ORDER BY `unit` DESC [ RunTime:0.026994s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13343827 LIMIT 2 [ RunTime:0.043411s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13343827 ORDER BY `minOrder` ASC [ RunTime:0.014808s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15426564 LIMIT 5 [ RunTime:0.017786s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15426564 ORDER BY `minOrder` ASC [ RunTime:0.000522s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15426564 ORDER BY `unit` DESC [ RunTime:0.000535s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15426564 LIMIT 2 [ RunTime:0.011765s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15426564 ORDER BY `minOrder` ASC [ RunTime:0.000453s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17510065 LIMIT 5 [ RunTime:0.028822s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17510065 ORDER BY `minOrder` ASC [ RunTime:0.018080s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17510065 ORDER BY `unit` DESC [ RunTime:0.035649s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17510065 LIMIT 2 [ RunTime:0.026272s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17510065 ORDER BY `minOrder` ASC [ RunTime:0.019711s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12881191 LIMIT 5 [ RunTime:0.024292s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12881191 ORDER BY `minOrder` ASC [ RunTime:0.076802s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12881191 ORDER BY `unit` DESC [ RunTime:0.050250s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12881191 LIMIT 2 [ RunTime:0.051889s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12881191 ORDER BY `minOrder` ASC [ RunTime:0.024559s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11682388 LIMIT 5 [ RunTime:0.114830s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11682388 ORDER BY `minOrder` ASC [ RunTime:0.056734s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11682388 ORDER BY `unit` DESC [ RunTime:0.034734s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11682388 LIMIT 2 [ RunTime:0.064740s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11682388 ORDER BY `minOrder` ASC [ RunTime:0.032450s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11682372 LIMIT 5 [ RunTime:0.026727s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11682372 ORDER BY `minOrder` ASC [ RunTime:0.009546s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11682372 ORDER BY `unit` DESC [ RunTime:0.029833s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11682372 LIMIT 2 [ RunTime:0.020099s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11682372 ORDER BY `minOrder` ASC [ RunTime:0.019228s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11682371 LIMIT 5 [ RunTime:0.009610s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11682371 ORDER BY `minOrder` ASC [ RunTime:0.026263s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11682371 ORDER BY `unit` DESC [ RunTime:0.019756s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11682371 LIMIT 2 [ RunTime:0.012664s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11682371 ORDER BY `minOrder` ASC [ RunTime:0.007753s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11682102 LIMIT 5 [ RunTime:0.016161s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11682102 ORDER BY `minOrder` ASC [ RunTime:0.008081s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11682102 ORDER BY `unit` DESC [ RunTime:0.002413s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11682102 LIMIT 2 [ RunTime:0.000658s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11682102 ORDER BY `minOrder` ASC [ RunTime:0.001814s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12880876 LIMIT 5 [ RunTime:0.003788s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12880876 ORDER BY `minOrder` ASC [ RunTime:0.021319s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12880876 ORDER BY `unit` DESC [ RunTime:0.023177s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12880876 LIMIT 2 [ RunTime:0.014803s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12880876 ORDER BY `minOrder` ASC [ RunTime:0.008637s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12880875 LIMIT 5 [ RunTime:0.011803s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12880875 ORDER BY `minOrder` ASC [ RunTime:0.022142s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12880875 ORDER BY `unit` DESC [ RunTime:0.004309s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12880875 LIMIT 2 [ RunTime:0.006911s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12880875 ORDER BY `minOrder` ASC [ RunTime:0.013764s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18792078 LIMIT 5 [ RunTime:0.005565s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18792078 ORDER BY `minOrder` ASC [ RunTime:0.001889s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18792078 ORDER BY `unit` DESC [ RunTime:0.000597s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18792078 LIMIT 2 [ RunTime:0.000542s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18792078 ORDER BY `minOrder` ASC [ RunTime:0.002464s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18792077 LIMIT 5 [ RunTime:0.001403s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18792077 ORDER BY `minOrder` ASC [ RunTime:0.000634s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18792077 ORDER BY `unit` DESC [ RunTime:0.003610s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18792077 LIMIT 2 [ RunTime:0.009403s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18792077 ORDER BY `minOrder` ASC [ RunTime:0.009677s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11995191 LIMIT 5 [ RunTime:0.010157s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11995191 ORDER BY `minOrder` ASC [ RunTime:0.029975s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11995191 ORDER BY `unit` DESC [ RunTime:0.023747s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11995191 LIMIT 2 [ RunTime:0.007263s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11995191 ORDER BY `minOrder` ASC [ RunTime:0.002525s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14693283 LIMIT 5 [ RunTime:0.010698s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14693283 ORDER BY `minOrder` ASC [ RunTime:0.001117s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14693283 ORDER BY `unit` DESC [ RunTime:0.000543s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14693283 LIMIT 2 [ RunTime:0.009477s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14693283 ORDER BY `minOrder` ASC [ RunTime:0.008172s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13804256 LIMIT 5 [ RunTime:0.019690s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13804256 ORDER BY `minOrder` ASC [ RunTime:0.003844s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13804256 ORDER BY `unit` DESC [ RunTime:0.002767s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13804256 LIMIT 2 [ RunTime:0.014925s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13804256 ORDER BY `minOrder` ASC [ RunTime:0.001272s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12881919 LIMIT 5 [ RunTime:0.014160s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12881919 ORDER BY `minOrder` ASC [ RunTime:0.015723s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12881919 ORDER BY `unit` DESC [ RunTime:0.020399s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12881919 LIMIT 2 [ RunTime:0.033167s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12881919 ORDER BY `minOrder` ASC [ RunTime:0.004147s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12868294 LIMIT 5 [ RunTime:0.024371s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12868294 ORDER BY `minOrder` ASC [ RunTime:0.036188s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12868294 ORDER BY `unit` DESC [ RunTime:0.019271s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12868294 LIMIT 2 [ RunTime:0.013816s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12868294 ORDER BY `minOrder` ASC [ RunTime:0.006039s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11200517 LIMIT 5 [ RunTime:0.034256s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11200517 ORDER BY `minOrder` ASC [ RunTime:0.017600s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11200517 ORDER BY `unit` DESC [ RunTime:0.013839s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11200517 LIMIT 2 [ RunTime:0.013757s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11200517 ORDER BY `minOrder` ASC [ RunTime:0.003415s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18818491 LIMIT 5 [ RunTime:0.005924s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18818491 ORDER BY `minOrder` ASC [ RunTime:0.017620s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18818491 ORDER BY `unit` DESC [ RunTime:0.008832s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18818491 LIMIT 2 [ RunTime:0.023095s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18818491 ORDER BY `minOrder` ASC [ RunTime:0.013889s ]
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 '6042%' OR `brand` LIKE '6042%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.016803s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51138146 LIMIT 5 [ RunTime:0.014083s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51138146 ORDER BY `minOrder` ASC [ RunTime:0.013626s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51138146 ORDER BY `unit` DESC [ RunTime:0.014406s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51138146 LIMIT 2 [ RunTime:0.006108s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51138146 ORDER BY `minOrder` ASC [ RunTime:0.002085s ]
select * from pdf where partno='6042153001' and brandshort='te connectivity' limit 1 [ RunTime:0.013061s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002093s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6042153001' OR `brand` LIKE 'te connectivity%' ) ) LIMIT 1 [ RunTime:0.027986s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51111368 LIMIT 5 [ RunTime:0.004527s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51111368 ORDER BY `minOrder` ASC [ RunTime:0.006948s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51111368 ORDER BY `unit` DESC [ RunTime:0.005563s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51111368 LIMIT 2 [ RunTime:0.003868s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51111368 ORDER BY `minOrder` ASC [ RunTime:0.000473s ]
select * from pdf where partno='6042' and brandshort='adafruit' limit 1 [ RunTime:0.000560s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6042' OR `brand` LIKE 'adafruit%' ) ) LIMIT 1 [ RunTime:0.002868s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32282313 LIMIT 5 [ RunTime:0.004217s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32282313 ORDER BY `minOrder` ASC [ RunTime:0.011151s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32282313 ORDER BY `unit` DESC [ RunTime:0.000772s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32282313 LIMIT 2 [ RunTime:0.003343s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32282313 ORDER BY `minOrder` ASC [ RunTime:0.002206s ]
select * from pdf where partno='604220-1' and brandshort='te connectivity / amp' limit 1 [ RunTime:0.001235s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '604220-1' OR `brand` LIKE 'te connectivity / amp%' ) ) LIMIT 1 [ RunTime:0.009413s ]
SELECT `id` FROM `stock` WHERE `id` <> 32282313 AND `partno` = '604220-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity / amp%' ) [ RunTime:0.017977s ]
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 '6042%' OR `brand` LIKE '6042%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.033244s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60645292 LIMIT 5 [ RunTime:0.003127s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60645292 ORDER BY `minOrder` ASC [ RunTime:0.002735s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60645292 ORDER BY `unit` DESC [ RunTime:0.005291s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60645292 LIMIT 2 [ RunTime:0.002705s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60645292 ORDER BY `minOrder` ASC [ RunTime:0.005770s ]
select * from pdf where partno='60422-3' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.008541s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '60422-3' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.013036s ]
SELECT `id` FROM `stock` WHERE `id` <> 60645292 AND `partno` = '60422-3' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.007735s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63503983 LIMIT 5 [ RunTime:0.006469s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63503983 ORDER BY `minOrder` ASC [ RunTime:0.002682s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63503983 ORDER BY `unit` DESC [ RunTime:0.002474s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63503983 LIMIT 2 [ RunTime:0.004484s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63503983 ORDER BY `minOrder` ASC [ RunTime:0.004176s ]
select * from pdf where partno='6042' and brandshort='Keystone Electronics' limit 1 [ RunTime:0.008582s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6042' OR `brand` LIKE 'Keystone Electronics%' ) ) LIMIT 1 [ RunTime:0.002817s ]
SELECT `id` FROM `stock` WHERE `id` <> 63503983 AND `partno` = '6042' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%keystone electronics%' ) [ RunTime:0.012932s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14793998 [ RunTime:0.004285s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64574911 LIMIT 5 [ RunTime:0.004038s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64574911 ORDER BY `minOrder` ASC [ RunTime:0.007616s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64574911 ORDER BY `unit` DESC [ RunTime:0.003801s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64574911 LIMIT 2 [ RunTime:0.000555s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64574911 ORDER BY `minOrder` ASC [ RunTime:0.000370s ]
select * from pdf where partno='6042CS' and brandshort='Century Spring Corp' limit 1 [ RunTime:0.002193s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6042CS' OR `brand` LIKE 'Century Spring Corp%' ) ) LIMIT 1 [ RunTime:0.001374s ]
SELECT `id` FROM `stock` WHERE `id` <> 64574911 AND `partno` = '6042CS' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%century spring corp%' ) [ RunTime:0.002629s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13343827 [ RunTime:0.000847s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64019089 LIMIT 5 [ RunTime:0.000704s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64019089 ORDER BY `minOrder` ASC [ RunTime:0.001293s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64019089 ORDER BY `unit` DESC [ RunTime:0.002670s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64019089 LIMIT 2 [ RunTime:0.004322s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64019089 ORDER BY `minOrder` ASC [ RunTime:0.004370s ]
select * from pdf where partno='6042' and brandshort='Adafruit Industries LLC' limit 1 [ RunTime:0.005097s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6042' OR `brand` LIKE 'Adafruit Industries LLC%' ) ) LIMIT 1 [ RunTime:0.001910s ]
SELECT `id` FROM `stock` WHERE `id` <> 64019089 AND `partno` = '6042' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%adafruit industries llc%' ) [ RunTime:0.002292s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15426564 [ RunTime:0.004893s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61914194 LIMIT 5 [ RunTime:0.000665s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61914194 ORDER BY `minOrder` ASC [ RunTime:0.001686s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61914194 ORDER BY `unit` DESC [ RunTime:0.001092s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61914194 LIMIT 2 [ RunTime:0.000507s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61914194 ORDER BY `minOrder` ASC [ RunTime:0.000380s ]
select * from pdf where partno='60426522411120' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.007946s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '60426522411120' OR `brand` LIKE 'Würth Elektronik%' ) ) LIMIT 1 [ RunTime:0.000781s ]
SELECT `id` FROM `stock` WHERE `id` <> 61914194 AND `partno` = '60426522411120' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%würth elektronik%' ) [ RunTime:0.000681s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11682372 [ RunTime:0.000673s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61914189 LIMIT 5 [ RunTime:0.002964s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61914189 ORDER BY `minOrder` ASC [ RunTime:0.013832s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61914189 ORDER BY `unit` DESC [ RunTime:0.006355s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61914189 LIMIT 2 [ RunTime:0.000890s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61914189 ORDER BY `minOrder` ASC [ RunTime:0.000472s ]
select * from pdf where partno='60425522512220' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.001077s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '60425522512220' OR `brand` LIKE 'Würth Elektronik%' ) ) LIMIT 1 [ RunTime:0.001321s ]
SELECT `id` FROM `stock` WHERE `id` <> 61914189 AND `partno` = '60425522512220' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%würth elektronik%' ) [ RunTime:0.000898s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11682371 [ RunTime:0.000706s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61914188 LIMIT 5 [ RunTime:0.002095s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61914188 ORDER BY `minOrder` ASC [ RunTime:0.001599s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61914188 ORDER BY `unit` DESC [ RunTime:0.001283s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61914188 LIMIT 2 [ RunTime:0.001551s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61914188 ORDER BY `minOrder` ASC [ RunTime:0.000454s ]
select * from pdf where partno='60425522512120' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.004156s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '60425522512120' OR `brand` LIKE 'Würth Elektronik%' ) ) LIMIT 1 [ RunTime:0.001834s ]
SELECT `id` FROM `stock` WHERE `id` <> 61914188 AND `partno` = '60425522512120' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%würth elektronik%' ) [ RunTime:0.001280s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11682388 [ RunTime:0.001124s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61914187 LIMIT 5 [ RunTime:0.003820s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61914187 ORDER BY `minOrder` ASC [ RunTime:0.002310s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61914187 ORDER BY `unit` DESC [ RunTime:0.002577s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61914187 LIMIT 2 [ RunTime:0.005080s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61914187 ORDER BY `minOrder` ASC [ RunTime:0.000473s ]
select * from pdf where partno='60425522510420' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.001598s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '60425522510420' OR `brand` LIKE 'Würth Elektronik%' ) ) LIMIT 1 [ RunTime:0.000806s ]
SELECT `id` FROM `stock` WHERE `id` <> 61914187 AND `partno` = '60425522510420' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%würth elektronik%' ) [ RunTime:0.004128s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12881191 [ RunTime:0.003349s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61913501 LIMIT 5 [ RunTime:0.000850s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61913501 ORDER BY `minOrder` ASC [ RunTime:0.001997s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61913501 ORDER BY `unit` DESC [ RunTime:0.000635s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61913501 LIMIT 2 [ RunTime:0.004980s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61913501 ORDER BY `minOrder` ASC [ RunTime:0.000473s ]
select * from pdf where partno='60426522411520' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.011056s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '60426522411520' OR `brand` LIKE 'Würth Elektronik%' ) ) LIMIT 1 [ RunTime:0.000968s ]
SELECT `id` FROM `stock` WHERE `id` <> 61913501 AND `partno` = '60426522411520' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%würth elektronik%' ) [ RunTime:0.005176s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11682102 [ RunTime:0.002038s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61913502 LIMIT 5 [ RunTime:0.000624s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61913502 ORDER BY `minOrder` ASC [ RunTime:0.001637s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61913502 ORDER BY `unit` DESC [ RunTime:0.000650s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61913502 LIMIT 2 [ RunTime:0.000606s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61913502 ORDER BY `minOrder` ASC [ RunTime:0.000449s ]
select * from pdf where partno='60429522410720' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.000966s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '60429522410720' OR `brand` LIKE 'Würth Elektronik%' ) ) LIMIT 1 [ RunTime:0.003150s ]
SELECT `id` FROM `stock` WHERE `id` <> 61913502 AND `partno` = '60429522410720' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%würth elektronik%' ) [ RunTime:0.001011s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12880876 [ RunTime:0.004438s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61913498 LIMIT 5 [ RunTime:0.000618s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61913498 ORDER BY `minOrder` ASC [ RunTime:0.001365s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61913498 ORDER BY `unit` DESC [ RunTime:0.010177s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61913498 LIMIT 2 [ RunTime:0.000672s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61913498 ORDER BY `minOrder` ASC [ RunTime:0.000442s ]
select * from pdf where partno='60425522512320' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.000975s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '60425522512320' OR `brand` LIKE 'Würth Elektronik%' ) ) LIMIT 1 [ RunTime:0.003800s ]
SELECT `id` FROM `stock` WHERE `id` <> 61913498 AND `partno` = '60425522512320' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%würth elektronik%' ) [ RunTime:0.001183s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12880875 [ RunTime:0.000692s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62449486 LIMIT 5 [ RunTime:0.000813s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62449486 ORDER BY `minOrder` ASC [ RunTime:0.001445s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62449486 ORDER BY `unit` DESC [ RunTime:0.000613s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62449486 LIMIT 2 [ RunTime:0.000538s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62449486 ORDER BY `minOrder` ASC [ RunTime:0.000411s ]
select * from pdf where partno='6042517' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.000902s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6042517' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.002865s ]
SELECT `id` FROM `stock` WHERE `id` <> 62449486 AND `partno` = '6042517' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.005118s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17510065 [ RunTime:0.004478s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61913509 LIMIT 5 [ RunTime:0.004622s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61913509 ORDER BY `minOrder` ASC [ RunTime:0.001045s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61913509 ORDER BY `unit` DESC [ RunTime:0.001133s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61913509 LIMIT 2 [ RunTime:0.000820s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61913509 ORDER BY `minOrder` ASC [ RunTime:0.000414s ]
select * from pdf where partno='60426522410120' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.000960s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '60426522410120' OR `brand` LIKE 'Würth Elektronik%' ) ) LIMIT 1 [ RunTime:0.009943s ]
SELECT `id` FROM `stock` WHERE `id` <> 61913509 AND `partno` = '60426522410120' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%würth elektronik%' ) [ RunTime:0.003188s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64784547 LIMIT 5 [ RunTime:0.000670s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64784547 ORDER BY `minOrder` ASC [ RunTime:0.011152s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64784547 ORDER BY `unit` DESC [ RunTime:0.016081s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64784547 LIMIT 2 [ RunTime:0.001237s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64784547 ORDER BY `minOrder` ASC [ RunTime:0.000467s ]
select * from pdf where partno='6042018' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.006667s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6042018' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.000894s ]
SELECT `id` FROM `stock` WHERE `id` <> 64784547 AND `partno` = '6042018' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.004519s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18792077 [ RunTime:0.010047s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64178174 LIMIT 5 [ RunTime:0.003454s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64178174 ORDER BY `minOrder` ASC [ RunTime:0.009686s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64178174 ORDER BY `unit` DESC [ RunTime:0.003076s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64178174 LIMIT 2 [ RunTime:0.002843s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64178174 ORDER BY `minOrder` ASC [ RunTime:0.004148s ]
select * from pdf where partno='6042212' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.002823s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6042212' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.008150s ]
SELECT `id` FROM `stock` WHERE `id` <> 64178174 AND `partno` = '6042212' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.000985s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11995191 [ RunTime:0.000666s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62956276 LIMIT 5 [ RunTime:0.011124s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62956276 ORDER BY `minOrder` ASC [ RunTime:0.001463s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62956276 ORDER BY `unit` DESC [ RunTime:0.000706s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62956276 LIMIT 2 [ RunTime:0.002716s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62956276 ORDER BY `minOrder` ASC [ RunTime:0.003301s ]
select * from pdf where partno='6042499' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.013231s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6042499' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.005041s ]
SELECT `id` FROM `stock` WHERE `id` <> 62956276 AND `partno` = '6042499' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.011231s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14666416 [ RunTime:0.004091s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63334110 LIMIT 5 [ RunTime:0.009608s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63334110 ORDER BY `minOrder` ASC [ RunTime:0.015403s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63334110 ORDER BY `unit` DESC [ RunTime:0.002586s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63334110 LIMIT 2 [ RunTime:0.000664s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63334110 ORDER BY `minOrder` ASC [ RunTime:0.000534s ]
select * from pdf where partno='6042576' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.001008s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6042576' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.005332s ]
SELECT `id` FROM `stock` WHERE `id` <> 63334110 AND `partno` = '6042576' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.006325s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11200517 [ RunTime:0.011506s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63278161 LIMIT 5 [ RunTime:0.013453s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63278161 ORDER BY `minOrder` ASC [ RunTime:0.005050s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63278161 ORDER BY `unit` DESC [ RunTime:0.023813s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63278161 LIMIT 2 [ RunTime:0.016438s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63278161 ORDER BY `minOrder` ASC [ RunTime:0.002307s ]
select * from pdf where partno='6042085' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.009228s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6042085' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.003657s ]
SELECT `id` FROM `stock` WHERE `id` <> 63278161 AND `partno` = '6042085' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.018452s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12868294 [ RunTime:0.016174s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61195663 LIMIT 5 [ RunTime:0.000659s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61195663 ORDER BY `minOrder` ASC [ RunTime:0.003982s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61195663 ORDER BY `unit` DESC [ RunTime:0.000926s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61195663 LIMIT 2 [ RunTime:0.003747s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61195663 ORDER BY `minOrder` ASC [ RunTime:0.014926s ]
select * from pdf where partno='6042093' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.015627s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6042093' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.008188s ]
SELECT `id` FROM `stock` WHERE `id` <> 61195663 AND `partno` = '6042093' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.011818s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64786462 LIMIT 5 [ RunTime:0.012773s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64786462 ORDER BY `minOrder` ASC [ RunTime:0.020666s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64786462 ORDER BY `unit` DESC [ RunTime:0.015501s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64786462 LIMIT 2 [ RunTime:0.013362s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64786462 ORDER BY `minOrder` ASC [ RunTime:0.004768s ]
select * from pdf where partno='6042022' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.009713s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6042022' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.004493s ]
SELECT `id` FROM `stock` WHERE `id` <> 64786462 AND `partno` = '6042022' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.006191s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18792078 [ RunTime:0.000610s ]
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 '6042%' OR `brand` LIKE '6042%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000880s ]
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 '6042%' OR `brand` LIKE '6042%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.008714s ]
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 '6042%' OR `brand` LIKE '6042%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002141s ]
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 '6042%' OR `brand` LIKE '6042%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002252s ]
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 '6042%' OR `brand` LIKE '6042%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.006015s ]
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 '6042%' OR `brand` LIKE '6042%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002459s ]
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 '6042%' OR `brand` LIKE '6042%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.007675s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '6042%' OR `brand` LIKE '6042%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.005979s ]