SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001398s ]
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 'NRN3%' OR `brand` LIKE 'NRN3%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.020489s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001386s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18796575 LIMIT 5 [ RunTime:0.012802s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.007035s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18796575 ORDER BY `minOrder` ASC [ RunTime:0.001343s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.002220s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18796575 ORDER BY `unit` DESC [ RunTime:0.024025s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.007331s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18796575 LIMIT 2 [ RunTime:0.002929s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18796575 ORDER BY `minOrder` ASC [ RunTime:0.012265s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18797986 LIMIT 5 [ RunTime:0.015253s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18797986 ORDER BY `minOrder` ASC [ RunTime:0.015747s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18797986 ORDER BY `unit` DESC [ RunTime:0.026797s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18797986 LIMIT 2 [ RunTime:0.012926s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18797986 ORDER BY `minOrder` ASC [ RunTime:0.028594s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18789856 LIMIT 5 [ RunTime:0.021580s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18789856 ORDER BY `minOrder` ASC [ RunTime:0.017930s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18789856 ORDER BY `unit` DESC [ RunTime:0.033117s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18789856 LIMIT 2 [ RunTime:0.004345s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18789856 ORDER BY `minOrder` ASC [ RunTime:0.024948s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18789789 LIMIT 5 [ RunTime:0.071705s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18789789 ORDER BY `minOrder` ASC [ RunTime:0.029925s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18789789 ORDER BY `unit` DESC [ RunTime:0.041736s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18789789 LIMIT 2 [ RunTime:0.026965s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18789789 ORDER BY `minOrder` ASC [ RunTime:0.016952s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18789650 LIMIT 5 [ RunTime:0.051051s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18789650 ORDER BY `minOrder` ASC [ RunTime:0.029727s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18789650 ORDER BY `unit` DESC [ RunTime:0.043604s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18789650 LIMIT 2 [ RunTime:0.041773s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18789650 ORDER BY `minOrder` ASC [ RunTime:0.029576s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17014394 LIMIT 5 [ RunTime:0.043683s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17014394 ORDER BY `minOrder` ASC [ RunTime:0.044945s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17014394 ORDER BY `unit` DESC [ RunTime:0.019387s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17014394 LIMIT 2 [ RunTime:0.006489s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17014394 ORDER BY `minOrder` ASC [ RunTime:0.005685s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17012922 LIMIT 5 [ RunTime:0.008172s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17012922 ORDER BY `minOrder` ASC [ RunTime:0.003324s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17012922 ORDER BY `unit` DESC [ RunTime:0.009759s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17012922 LIMIT 2 [ RunTime:0.005941s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17012922 ORDER BY `minOrder` ASC [ RunTime:0.014951s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17012897 LIMIT 5 [ RunTime:0.021538s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17012897 ORDER BY `minOrder` ASC [ RunTime:0.007176s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17012897 ORDER BY `unit` DESC [ RunTime:0.005921s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17012897 LIMIT 2 [ RunTime:0.007303s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17012897 ORDER BY `minOrder` ASC [ RunTime:0.002088s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17012896 LIMIT 5 [ RunTime:0.003057s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17012896 ORDER BY `minOrder` ASC [ RunTime:0.018983s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17012896 ORDER BY `unit` DESC [ RunTime:0.012166s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17012896 LIMIT 2 [ RunTime:0.022325s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17012896 ORDER BY `minOrder` ASC [ RunTime:0.014578s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15226837 LIMIT 5 [ RunTime:0.003111s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15226837 ORDER BY `minOrder` ASC [ RunTime:0.000809s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15226837 ORDER BY `unit` DESC [ RunTime:0.004227s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15226837 LIMIT 2 [ RunTime:0.004525s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15226837 ORDER BY `minOrder` ASC [ RunTime:0.012549s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15226836 LIMIT 5 [ RunTime:0.026837s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15226836 ORDER BY `minOrder` ASC [ RunTime:0.041884s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15226836 ORDER BY `unit` DESC [ RunTime:0.000605s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15226836 LIMIT 2 [ RunTime:0.007798s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15226836 ORDER BY `minOrder` ASC [ RunTime:0.013838s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15226835 LIMIT 5 [ RunTime:0.007172s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15226835 ORDER BY `minOrder` ASC [ RunTime:0.017682s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15226835 ORDER BY `unit` DESC [ RunTime:0.007356s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15226835 LIMIT 2 [ RunTime:0.002640s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15226835 ORDER BY `minOrder` ASC [ RunTime:0.006869s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15226834 LIMIT 5 [ RunTime:0.003485s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15226834 ORDER BY `minOrder` ASC [ RunTime:0.006676s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15226834 ORDER BY `unit` DESC [ RunTime:0.008938s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15226834 LIMIT 2 [ RunTime:0.014599s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15226834 ORDER BY `minOrder` ASC [ RunTime:0.000508s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15226833 LIMIT 5 [ RunTime:0.007348s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15226833 ORDER BY `minOrder` ASC [ RunTime:0.008303s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15226833 ORDER BY `unit` DESC [ RunTime:0.003576s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15226833 LIMIT 2 [ RunTime:0.004217s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15226833 ORDER BY `minOrder` ASC [ RunTime:0.001679s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14720331 LIMIT 5 [ RunTime:0.012827s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14720331 ORDER BY `minOrder` ASC [ RunTime:0.002912s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14720331 ORDER BY `unit` DESC [ RunTime:0.003416s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14720331 LIMIT 2 [ RunTime:0.010275s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14720331 ORDER BY `minOrder` ASC [ RunTime:0.010255s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14718365 LIMIT 5 [ RunTime:0.018470s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14718365 ORDER BY `minOrder` ASC [ RunTime:0.018507s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14718365 ORDER BY `unit` DESC [ RunTime:0.006917s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14718365 LIMIT 2 [ RunTime:0.009386s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14718365 ORDER BY `minOrder` ASC [ RunTime:0.000454s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14718324 LIMIT 5 [ RunTime:0.001934s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14718324 ORDER BY `minOrder` ASC [ RunTime:0.010327s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14718324 ORDER BY `unit` DESC [ RunTime:0.009046s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14718324 LIMIT 2 [ RunTime:0.009546s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14718324 ORDER BY `minOrder` ASC [ RunTime:0.000459s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14717897 LIMIT 5 [ RunTime:0.000982s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14717897 ORDER BY `minOrder` ASC [ RunTime:0.002379s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14717897 ORDER BY `unit` DESC [ RunTime:0.003939s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14717897 LIMIT 2 [ RunTime:0.002075s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14717897 ORDER BY `minOrder` ASC [ RunTime:0.005165s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13828578 LIMIT 5 [ RunTime:0.022347s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13828578 ORDER BY `minOrder` ASC [ RunTime:0.008897s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13828578 ORDER BY `unit` DESC [ RunTime:0.007297s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13828578 LIMIT 2 [ RunTime:0.002101s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13828578 ORDER BY `minOrder` ASC [ RunTime:0.000306s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13827217 LIMIT 5 [ RunTime:0.004205s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13827217 ORDER BY `minOrder` ASC [ RunTime:0.001074s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13827217 ORDER BY `unit` DESC [ RunTime:0.017572s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13827217 LIMIT 2 [ RunTime:0.001777s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13827217 ORDER BY `minOrder` ASC [ RunTime:0.000352s ]
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 'NRN3%' OR `brand` LIKE 'NRN3%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.004231s ]
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 'NRN3%' OR `brand` LIKE 'NRN3%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.015097s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64785099 LIMIT 5 [ RunTime:0.015316s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64785099 ORDER BY `minOrder` ASC [ RunTime:0.023789s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64785099 ORDER BY `unit` DESC [ RunTime:0.011979s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64785099 LIMIT 2 [ RunTime:0.005483s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64785099 ORDER BY `minOrder` ASC [ RunTime:0.011807s ]
select * from pdf where partno='NRN35-L3-A2-C-V1' and brandshort='Pepperl+Fuchs, Inc.' limit 1 [ RunTime:0.030415s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.004665s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'NRN35-L3-A2-C-V1' OR `brand` LIKE 'Pepperl+Fuchs, Inc.%' ) ) LIMIT 1 [ RunTime:0.044752s ]
SELECT `id` FROM `stock` WHERE `id` <> 64785099 AND `partno` = 'NRN35-L3-A2-C-V1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%pepperl+fuchs, inc.%' ) [ RunTime:0.021176s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18796575 [ RunTime:0.005548s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64796188 LIMIT 5 [ RunTime:0.024134s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64796188 ORDER BY `minOrder` ASC [ RunTime:0.001222s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64796188 ORDER BY `unit` DESC [ RunTime:0.010383s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64796188 LIMIT 2 [ RunTime:0.008165s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64796188 ORDER BY `minOrder` ASC [ RunTime:0.000477s ]
select * from pdf where partno='NRN30-30GM50-E2-IO-C-V1' and brandshort='Pepperl+Fuchs, Inc.' limit 1 [ RunTime:0.007534s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'NRN30-30GM50-E2-IO-C-V1' OR `brand` LIKE 'Pepperl+Fuchs, Inc.%' ) ) LIMIT 1 [ RunTime:0.000521s ]
SELECT `id` FROM `stock` WHERE `id` <> 64796188 AND `partno` = 'NRN30-30GM50-E2-IO-C-V1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%pepperl+fuchs, inc.%' ) [ RunTime:0.004476s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17012922 [ RunTime:0.003514s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64796186 LIMIT 5 [ RunTime:0.007759s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64796186 ORDER BY `minOrder` ASC [ RunTime:0.004536s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64796186 ORDER BY `unit` DESC [ RunTime:0.009486s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64796186 LIMIT 2 [ RunTime:0.002951s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64796186 ORDER BY `minOrder` ASC [ RunTime:0.020090s ]
select * from pdf where partno='NRN30-30GM50-E2-IO-C' and brandshort='Pepperl+Fuchs, Inc.' limit 1 [ RunTime:0.007091s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'NRN30-30GM50-E2-IO-C' OR `brand` LIKE 'Pepperl+Fuchs, Inc.%' ) ) LIMIT 1 [ RunTime:0.014781s ]
SELECT `id` FROM `stock` WHERE `id` <> 64796186 AND `partno` = 'NRN30-30GM50-E2-IO-C' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%pepperl+fuchs, inc.%' ) [ RunTime:0.003992s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18789856 [ RunTime:0.010622s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64796092 LIMIT 5 [ RunTime:0.002017s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64796092 ORDER BY `minOrder` ASC [ RunTime:0.012358s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64796092 ORDER BY `unit` DESC [ RunTime:0.022812s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64796092 LIMIT 2 [ RunTime:0.007624s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64796092 ORDER BY `minOrder` ASC [ RunTime:0.020429s ]
select * from pdf where partno='NRN30-30GM50-A2-C' and brandshort='Pepperl+Fuchs, Inc.' limit 1 [ RunTime:0.003442s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'NRN30-30GM50-A2-C' OR `brand` LIKE 'Pepperl+Fuchs, Inc.%' ) ) LIMIT 1 [ RunTime:0.005244s ]
SELECT `id` FROM `stock` WHERE `id` <> 64796092 AND `partno` = 'NRN30-30GM50-A2-C' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%pepperl+fuchs, inc.%' ) [ RunTime:0.007061s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18789789 [ RunTime:0.027677s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64796076 LIMIT 5 [ RunTime:0.015526s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64796076 ORDER BY `minOrder` ASC [ RunTime:0.034621s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64796076 ORDER BY `unit` DESC [ RunTime:0.011191s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64796076 LIMIT 2 [ RunTime:0.011760s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64796076 ORDER BY `minOrder` ASC [ RunTime:0.024034s ]
select * from pdf where partno='NRN30-30GH50-E2' and brandshort='Pepperl+Fuchs, Inc.' limit 1 [ RunTime:0.041978s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'NRN30-30GH50-E2' OR `brand` LIKE 'Pepperl+Fuchs, Inc.%' ) ) LIMIT 1 [ RunTime:0.009920s ]
SELECT `id` FROM `stock` WHERE `id` <> 64796076 AND `partno` = 'NRN30-30GH50-E2' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%pepperl+fuchs, inc.%' ) [ RunTime:0.019489s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15226837 [ RunTime:0.017086s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64796075 LIMIT 5 [ RunTime:0.002044s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64796075 ORDER BY `minOrder` ASC [ RunTime:0.016021s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64796075 ORDER BY `unit` DESC [ RunTime:0.011926s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64796075 LIMIT 2 [ RunTime:0.008018s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64796075 ORDER BY `minOrder` ASC [ RunTime:0.009640s ]
select * from pdf where partno='NRN30-30GH50-E2-V1' and brandshort='Pepperl+Fuchs, Inc.' limit 1 [ RunTime:0.015437s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'NRN30-30GH50-E2-V1' OR `brand` LIKE 'Pepperl+Fuchs, Inc.%' ) ) LIMIT 1 [ RunTime:0.015925s ]
SELECT `id` FROM `stock` WHERE `id` <> 64796075 AND `partno` = 'NRN30-30GH50-E2-V1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%pepperl+fuchs, inc.%' ) [ RunTime:0.009869s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15226836 [ RunTime:0.011032s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64796074 LIMIT 5 [ RunTime:0.014437s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64796074 ORDER BY `minOrder` ASC [ RunTime:0.008562s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64796074 ORDER BY `unit` DESC [ RunTime:0.000645s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64796074 LIMIT 2 [ RunTime:0.000564s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64796074 ORDER BY `minOrder` ASC [ RunTime:0.013494s ]
select * from pdf where partno='NRN30-30GM50-E2-C-V1' and brandshort='Pepperl+Fuchs, Inc.' limit 1 [ RunTime:0.014286s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'NRN30-30GM50-E2-C-V1' OR `brand` LIKE 'Pepperl+Fuchs, Inc.%' ) ) LIMIT 1 [ RunTime:0.015010s ]
SELECT `id` FROM `stock` WHERE `id` <> 64796074 AND `partno` = 'NRN30-30GM50-E2-C-V1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%pepperl+fuchs, inc.%' ) [ RunTime:0.025088s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15226835 [ RunTime:0.017501s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64796073 LIMIT 5 [ RunTime:0.003605s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64796073 ORDER BY `minOrder` ASC [ RunTime:0.008931s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64796073 ORDER BY `unit` DESC [ RunTime:0.000562s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64796073 LIMIT 2 [ RunTime:0.026540s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64796073 ORDER BY `minOrder` ASC [ RunTime:0.009201s ]
select * from pdf where partno='NRN30-30GS50-E2-IO-V1' and brandshort='Pepperl+Fuchs, Inc.' limit 1 [ RunTime:0.006074s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'NRN30-30GS50-E2-IO-V1' OR `brand` LIKE 'Pepperl+Fuchs, Inc.%' ) ) LIMIT 1 [ RunTime:0.018740s ]
SELECT `id` FROM `stock` WHERE `id` <> 64796073 AND `partno` = 'NRN30-30GS50-E2-IO-V1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%pepperl+fuchs, inc.%' ) [ RunTime:0.009968s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15226834 [ RunTime:0.000762s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64796072 LIMIT 5 [ RunTime:0.007201s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64796072 ORDER BY `minOrder` ASC [ RunTime:0.011470s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64796072 ORDER BY `unit` DESC [ RunTime:0.019705s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64796072 LIMIT 2 [ RunTime:0.020431s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64796072 ORDER BY `minOrder` ASC [ RunTime:0.015143s ]
select * from pdf where partno='NRN30-30GS50-E2-IO' and brandshort='Pepperl+Fuchs, Inc.' limit 1 [ RunTime:0.008706s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'NRN30-30GS50-E2-IO' OR `brand` LIKE 'Pepperl+Fuchs, Inc.%' ) ) LIMIT 1 [ RunTime:0.016825s ]
SELECT `id` FROM `stock` WHERE `id` <> 64796072 AND `partno` = 'NRN30-30GS50-E2-IO' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%pepperl+fuchs, inc.%' ) [ RunTime:0.019682s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15226833 [ RunTime:0.010674s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64795973 LIMIT 5 [ RunTime:0.009306s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64795973 ORDER BY `minOrder` ASC [ RunTime:0.014605s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64795973 ORDER BY `unit` DESC [ RunTime:0.006205s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64795973 LIMIT 2 [ RunTime:0.009201s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64795973 ORDER BY `minOrder` ASC [ RunTime:0.012198s ]
select * from pdf where partno='NRN30-30GS50-E2-V1' and brandshort='Pepperl+Fuchs, Inc.' limit 1 [ RunTime:0.040043s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'NRN30-30GS50-E2-V1' OR `brand` LIKE 'Pepperl+Fuchs, Inc.%' ) ) LIMIT 1 [ RunTime:0.003408s ]
SELECT `id` FROM `stock` WHERE `id` <> 64795973 AND `partno` = 'NRN30-30GS50-E2-V1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%pepperl+fuchs, inc.%' ) [ RunTime:0.013030s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18789650 [ RunTime:0.005654s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64795969 LIMIT 5 [ RunTime:0.001536s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64795969 ORDER BY `minOrder` ASC [ RunTime:0.027791s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64795969 ORDER BY `unit` DESC [ RunTime:0.009708s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64795969 LIMIT 2 [ RunTime:0.031604s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64795969 ORDER BY `minOrder` ASC [ RunTime:0.002890s ]
select * from pdf where partno='NRN30-30GS50-E2' and brandshort='Pepperl+Fuchs, Inc.' limit 1 [ RunTime:0.037556s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'NRN30-30GS50-E2' OR `brand` LIKE 'Pepperl+Fuchs, Inc.%' ) ) LIMIT 1 [ RunTime:0.025469s ]
SELECT `id` FROM `stock` WHERE `id` <> 64795969 AND `partno` = 'NRN30-30GS50-E2' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%pepperl+fuchs, inc.%' ) [ RunTime:0.018213s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17012897 [ RunTime:0.003000s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64795968 LIMIT 5 [ RunTime:0.021196s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64795968 ORDER BY `minOrder` ASC [ RunTime:0.033383s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64795968 ORDER BY `unit` DESC [ RunTime:0.015304s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64795968 LIMIT 2 [ RunTime:0.018350s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64795968 ORDER BY `minOrder` ASC [ RunTime:0.013188s ]
select * from pdf where partno='NRN30-30GS50-E3-V1' and brandshort='Pepperl+Fuchs, Inc.' limit 1 [ RunTime:0.027161s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'NRN30-30GS50-E3-V1' OR `brand` LIKE 'Pepperl+Fuchs, Inc.%' ) ) LIMIT 1 [ RunTime:0.013207s ]
SELECT `id` FROM `stock` WHERE `id` <> 64795968 AND `partno` = 'NRN30-30GS50-E3-V1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%pepperl+fuchs, inc.%' ) [ RunTime:0.033389s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17012896 [ RunTime:0.041648s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64793744 LIMIT 5 [ RunTime:0.031912s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64793744 ORDER BY `minOrder` ASC [ RunTime:0.068635s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64793744 ORDER BY `unit` DESC [ RunTime:0.032185s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64793744 LIMIT 2 [ RunTime:0.040941s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64793744 ORDER BY `minOrder` ASC [ RunTime:0.007331s ]
select * from pdf where partno='NRN35-L3-E2-C-V1' and brandshort='Pepperl+Fuchs, Inc.' limit 1 [ RunTime:0.028348s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'NRN35-L3-E2-C-V1' OR `brand` LIKE 'Pepperl+Fuchs, Inc.%' ) ) LIMIT 1 [ RunTime:0.060049s ]
SELECT `id` FROM `stock` WHERE `id` <> 64793744 AND `partno` = 'NRN35-L3-E2-C-V1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%pepperl+fuchs, inc.%' ) [ RunTime:0.022969s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18797986 [ RunTime:0.006620s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64793230 LIMIT 5 [ RunTime:0.016956s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64793230 ORDER BY `minOrder` ASC [ RunTime:0.031719s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64793230 ORDER BY `unit` DESC [ RunTime:0.035357s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64793230 LIMIT 2 [ RunTime:0.020720s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64793230 ORDER BY `minOrder` ASC [ RunTime:0.012840s ]
select * from pdf where partno='NRN35-L3-A2-V1' and brandshort='Pepperl+Fuchs, Inc.' limit 1 [ RunTime:0.013056s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'NRN35-L3-A2-V1' OR `brand` LIKE 'Pepperl+Fuchs, Inc.%' ) ) LIMIT 1 [ RunTime:0.010990s ]
SELECT `id` FROM `stock` WHERE `id` <> 64793230 AND `partno` = 'NRN35-L3-A2-V1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%pepperl+fuchs, inc.%' ) [ RunTime:0.019867s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17014394 [ RunTime:0.015968s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58239483 LIMIT 5 [ RunTime:0.026742s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58239483 ORDER BY `minOrder` ASC [ RunTime:0.029891s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58239483 ORDER BY `unit` DESC [ RunTime:0.038869s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58239483 LIMIT 2 [ RunTime:0.022051s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58239483 ORDER BY `minOrder` ASC [ RunTime:0.032049s ]
select * from pdf where partno='NRN300' and brandshort='Mersen USA Newburyport-MA L.L.C.' limit 1 [ RunTime:0.038483s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'NRN300' OR `brand` LIKE 'Mersen USA Newburyport-MA L.L.C.%' ) ) LIMIT 1 [ RunTime:0.013966s ]
SELECT `id` FROM `stock` WHERE `id` <> 58239483 AND `partno` = 'NRN300' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%mersen usa newburyport-ma l.l.c.%' ) [ RunTime:0.009472s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14720331 [ RunTime:0.013868s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58239482 LIMIT 5 [ RunTime:0.021212s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58239482 ORDER BY `minOrder` ASC [ RunTime:0.020582s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58239482 ORDER BY `unit` DESC [ RunTime:0.031922s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58239482 LIMIT 2 [ RunTime:0.025261s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58239482 ORDER BY `minOrder` ASC [ RunTime:0.010635s ]
select * from pdf where partno='NRN350' and brandshort='Mersen USA Newburyport-MA L.L.C.' limit 1 [ RunTime:0.015029s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'NRN350' OR `brand` LIKE 'Mersen USA Newburyport-MA L.L.C.%' ) ) LIMIT 1 [ RunTime:0.029148s ]
SELECT `id` FROM `stock` WHERE `id` <> 58239482 AND `partno` = 'NRN350' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%mersen usa newburyport-ma l.l.c.%' ) [ RunTime:0.014857s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13828578 [ RunTime:0.023086s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58235658 LIMIT 5 [ RunTime:0.037962s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58235658 ORDER BY `minOrder` ASC [ RunTime:0.032069s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58235658 ORDER BY `unit` DESC [ RunTime:0.053247s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58235658 LIMIT 2 [ RunTime:0.030922s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58235658 ORDER BY `minOrder` ASC [ RunTime:0.027916s ]
select * from pdf where partno='NRN35' and brandshort='Mersen USA Newburyport-MA L.L.C.' limit 1 [ RunTime:0.031140s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'NRN35' OR `brand` LIKE 'Mersen USA Newburyport-MA L.L.C.%' ) ) LIMIT 1 [ RunTime:0.031567s ]
SELECT `id` FROM `stock` WHERE `id` <> 58235658 AND `partno` = 'NRN35' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%mersen usa newburyport-ma l.l.c.%' ) [ RunTime:0.051723s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13827217 [ RunTime:0.010453s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58235657 LIMIT 5 [ RunTime:0.029421s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58235657 ORDER BY `minOrder` ASC [ RunTime:0.029967s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58235657 ORDER BY `unit` DESC [ RunTime:0.030223s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58235657 LIMIT 2 [ RunTime:0.031570s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58235657 ORDER BY `minOrder` ASC [ RunTime:0.012162s ]
select * from pdf where partno='NRN35BP' and brandshort='Mersen USA Newburyport-MA L.L.C.' limit 1 [ RunTime:0.022523s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'NRN35BP' OR `brand` LIKE 'Mersen USA Newburyport-MA L.L.C.%' ) ) LIMIT 1 [ RunTime:0.032491s ]
SELECT `id` FROM `stock` WHERE `id` <> 58235657 AND `partno` = 'NRN35BP' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%mersen usa newburyport-ma l.l.c.%' ) [ RunTime:0.031251s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13827216 [ RunTime:0.011986s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58234821 LIMIT 5 [ RunTime:0.016837s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58234821 ORDER BY `minOrder` ASC [ RunTime:0.010609s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58234821 ORDER BY `unit` DESC [ RunTime:0.003653s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58234821 LIMIT 2 [ RunTime:0.037153s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58234821 ORDER BY `minOrder` ASC [ RunTime:0.025142s ]
select * from pdf where partno='NRN30' and brandshort='Mersen USA Newburyport-MA L.L.C.' limit 1 [ RunTime:0.010261s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'NRN30' OR `brand` LIKE 'Mersen USA Newburyport-MA L.L.C.%' ) ) LIMIT 1 [ RunTime:0.000672s ]
SELECT `id` FROM `stock` WHERE `id` <> 58234821 AND `partno` = 'NRN30' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%mersen usa newburyport-ma l.l.c.%' ) [ RunTime:0.003350s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14718365 [ RunTime:0.031037s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58234713 LIMIT 5 [ RunTime:0.017495s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58234713 ORDER BY `minOrder` ASC [ RunTime:0.014435s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58234713 ORDER BY `unit` DESC [ RunTime:0.011735s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58234713 LIMIT 2 [ RunTime:0.017947s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58234713 ORDER BY `minOrder` ASC [ RunTime:0.022631s ]
select * from pdf where partno='NRN3' and brandshort='Mersen USA Newburyport-MA L.L.C.' limit 1 [ RunTime:0.003184s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'NRN3' OR `brand` LIKE 'Mersen USA Newburyport-MA L.L.C.%' ) ) LIMIT 1 [ RunTime:0.018213s ]
SELECT `id` FROM `stock` WHERE `id` <> 58234713 AND `partno` = 'NRN3' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%mersen usa newburyport-ma l.l.c.%' ) [ RunTime:0.000593s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14718324 [ RunTime:0.002299s ]
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 'NRN3%' OR `brand` LIKE 'NRN3%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.010993s ]
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 'NRN3%' OR `brand` LIKE 'NRN3%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.039739s ]
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 'NRN3%' OR `brand` LIKE 'NRN3%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.008544s ]
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 'NRN3%' OR `brand` LIKE 'NRN3%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.011768s ]
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 'NRN3%' OR `brand` LIKE 'NRN3%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.018485s ]
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 'NRN3%' OR `brand` LIKE 'NRN3%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.024645s ]
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 'NRN3%' OR `brand` LIKE 'NRN3%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.021379s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'NRN3%' OR `brand` LIKE 'NRN3%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.030084s ]