SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002208s ]
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 '40-901-5000-psi%' OR `brand` LIKE '40-901-5000-psi%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.015180s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001389s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18859802 LIMIT 5 [ RunTime:0.005042s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.002190s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18859802 ORDER BY `minOrder` ASC [ RunTime:0.002980s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.001614s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18859802 ORDER BY `unit` DESC [ RunTime:0.005049s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.001570s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18859802 LIMIT 2 [ RunTime:0.008052s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18859802 ORDER BY `minOrder` ASC [ RunTime:0.009224s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18859801 LIMIT 5 [ RunTime:0.000502s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18859801 ORDER BY `minOrder` ASC [ RunTime:0.006527s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18859801 ORDER BY `unit` DESC [ RunTime:0.005032s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18859801 LIMIT 2 [ RunTime:0.005986s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18859801 ORDER BY `minOrder` ASC [ RunTime:0.002549s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18859776 LIMIT 5 [ RunTime:0.004965s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18859776 ORDER BY `minOrder` ASC [ RunTime:0.000841s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18859776 ORDER BY `unit` DESC [ RunTime:0.000328s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18859776 LIMIT 2 [ RunTime:0.015391s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18859776 ORDER BY `minOrder` ASC [ RunTime:0.006212s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18859514 LIMIT 5 [ RunTime:0.012836s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18859514 ORDER BY `minOrder` ASC [ RunTime:0.003562s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18859514 ORDER BY `unit` DESC [ RunTime:0.033913s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18859514 LIMIT 2 [ RunTime:0.022601s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18859514 ORDER BY `minOrder` ASC [ RunTime:0.013619s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18859024 LIMIT 5 [ RunTime:0.026492s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18859024 ORDER BY `minOrder` ASC [ RunTime:0.021669s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18859024 ORDER BY `unit` DESC [ RunTime:0.034637s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18859024 LIMIT 2 [ RunTime:0.048974s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18859024 ORDER BY `minOrder` ASC [ RunTime:0.002309s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18859023 LIMIT 5 [ RunTime:0.000792s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18859023 ORDER BY `minOrder` ASC [ RunTime:0.006172s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18859023 ORDER BY `unit` DESC [ RunTime:0.020282s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18859023 LIMIT 2 [ RunTime:0.008148s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18859023 ORDER BY `minOrder` ASC [ RunTime:0.000859s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18858998 LIMIT 5 [ RunTime:0.002564s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18858998 ORDER BY `minOrder` ASC [ RunTime:0.014549s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18858998 ORDER BY `unit` DESC [ RunTime:0.002154s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18858998 LIMIT 2 [ RunTime:0.004996s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18858998 ORDER BY `minOrder` ASC [ RunTime:0.001451s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18858997 LIMIT 5 [ RunTime:0.000602s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18858997 ORDER BY `minOrder` ASC [ RunTime:0.007111s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18858997 ORDER BY `unit` DESC [ RunTime:0.005465s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18858997 LIMIT 2 [ RunTime:0.018388s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18858997 ORDER BY `minOrder` ASC [ RunTime:0.017243s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18858917 LIMIT 5 [ RunTime:0.019494s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18858917 ORDER BY `minOrder` ASC [ RunTime:0.017546s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18858917 ORDER BY `unit` DESC [ RunTime:0.011096s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18858917 LIMIT 2 [ RunTime:0.007093s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18858917 ORDER BY `minOrder` ASC [ RunTime:0.000782s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18858916 LIMIT 5 [ RunTime:0.011276s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18858916 ORDER BY `minOrder` ASC [ RunTime:0.013894s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18858916 ORDER BY `unit` DESC [ RunTime:0.045957s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18858916 LIMIT 2 [ RunTime:0.013482s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18858916 ORDER BY `minOrder` ASC [ RunTime:0.032471s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18858915 LIMIT 5 [ RunTime:0.004571s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18858915 ORDER BY `minOrder` ASC [ RunTime:0.065292s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18858915 ORDER BY `unit` DESC [ RunTime:0.025333s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18858915 LIMIT 2 [ RunTime:0.030384s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18858915 ORDER BY `minOrder` ASC [ RunTime:0.010035s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18858914 LIMIT 5 [ RunTime:0.019203s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18858914 ORDER BY `minOrder` ASC [ RunTime:0.001029s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18858914 ORDER BY `unit` DESC [ RunTime:0.006936s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18858914 LIMIT 2 [ RunTime:0.016566s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18858914 ORDER BY `minOrder` ASC [ RunTime:0.010031s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17025895 LIMIT 5 [ RunTime:0.022553s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17025895 ORDER BY `minOrder` ASC [ RunTime:0.031865s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17025895 ORDER BY `unit` DESC [ RunTime:0.034033s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17025895 LIMIT 2 [ RunTime:0.021084s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17025895 ORDER BY `minOrder` ASC [ RunTime:0.042756s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17025855 LIMIT 5 [ RunTime:0.033868s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17025855 ORDER BY `minOrder` ASC [ RunTime:0.007060s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17025855 ORDER BY `unit` DESC [ RunTime:0.023869s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17025855 LIMIT 2 [ RunTime:0.007486s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17025855 ORDER BY `minOrder` ASC [ RunTime:0.000313s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15240812 LIMIT 5 [ RunTime:0.005220s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15240812 ORDER BY `minOrder` ASC [ RunTime:0.005843s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15240812 ORDER BY `unit` DESC [ RunTime:0.016003s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15240812 LIMIT 2 [ RunTime:0.027081s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15240812 ORDER BY `minOrder` ASC [ RunTime:0.016173s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15240811 LIMIT 5 [ RunTime:0.011632s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15240811 ORDER BY `minOrder` ASC [ RunTime:0.003204s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15240811 ORDER BY `unit` DESC [ RunTime:0.012149s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15240811 LIMIT 2 [ RunTime:0.024941s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15240811 ORDER BY `minOrder` ASC [ RunTime:0.016414s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18860289 LIMIT 5 [ RunTime:0.027945s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18860289 ORDER BY `minOrder` ASC [ RunTime:0.008462s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18860289 ORDER BY `unit` DESC [ RunTime:0.014871s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18860289 LIMIT 2 [ RunTime:0.022334s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18860289 ORDER BY `minOrder` ASC [ RunTime:0.024461s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18860288 LIMIT 5 [ RunTime:0.022073s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18860288 ORDER BY `minOrder` ASC [ RunTime:0.033253s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18860288 ORDER BY `unit` DESC [ RunTime:0.016543s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18860288 LIMIT 2 [ RunTime:0.002026s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18860288 ORDER BY `minOrder` ASC [ RunTime:0.006689s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18859518 LIMIT 5 [ RunTime:0.004262s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18859518 ORDER BY `minOrder` ASC [ RunTime:0.025308s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18859518 ORDER BY `unit` DESC [ RunTime:0.034994s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18859518 LIMIT 2 [ RunTime:0.022493s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18859518 ORDER BY `minOrder` ASC [ RunTime:0.016057s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18859517 LIMIT 5 [ RunTime:0.020757s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18859517 ORDER BY `minOrder` ASC [ RunTime:0.026072s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18859517 ORDER BY `unit` DESC [ RunTime:0.002515s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18859517 LIMIT 2 [ RunTime:0.014721s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18859517 ORDER BY `minOrder` ASC [ RunTime:0.006864s ]
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 '40-901-5000-psi%' OR `brand` LIKE '40-901-5000-psi%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.013928s ]
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 '40-901-5000-psi%' OR `brand` LIKE '40-901-5000-psi%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.034333s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37472959 LIMIT 5 [ RunTime:0.005203s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37472959 ORDER BY `minOrder` ASC [ RunTime:0.011899s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37472959 ORDER BY `unit` DESC [ RunTime:0.004712s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37472959 LIMIT 2 [ RunTime:0.004313s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37472959 ORDER BY `minOrder` ASC [ RunTime:0.002991s ]
select * from pdf where partno='40-901-5000-psi/kPa-1/2-SSRF-MIP-BT8-CC' and brandshort='NOSHOK, Inc.' limit 1 [ RunTime:0.018170s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001255s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '40-901-5000-psi/kPa-1/2-SSRF-MIP-BT8-CC' OR `brand` LIKE 'NOSHOK, Inc.%' ) ) LIMIT 1 [ RunTime:0.000784s ]
SELECT `id` FROM `stock` WHERE `id` <> 37472959 AND `partno` = '40-901-5000-psi/kPa-1/2-SSRF-MIP-BT8-CC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%noshok, inc.%' ) [ RunTime:0.011587s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18858125 [ RunTime:0.009920s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37472936 LIMIT 5 [ RunTime:0.013157s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37472936 ORDER BY `minOrder` ASC [ RunTime:0.007119s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37472936 ORDER BY `unit` DESC [ RunTime:0.008646s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37472936 LIMIT 2 [ RunTime:0.002113s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37472936 ORDER BY `minOrder` ASC [ RunTime:0.002729s ]
select * from pdf where partno='40-901-5000-psi/kPa-1/2-SSRF-MIP-CC' and brandshort='NOSHOK, Inc.' limit 1 [ RunTime:0.005518s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '40-901-5000-psi/kPa-1/2-SSRF-MIP-CC' OR `brand` LIKE 'NOSHOK, Inc.%' ) ) LIMIT 1 [ RunTime:0.001724s ]
SELECT `id` FROM `stock` WHERE `id` <> 37472936 AND `partno` = '40-901-5000-psi/kPa-1/2-SSRF-MIP-CC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%noshok, inc.%' ) [ RunTime:0.001874s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15240635 [ RunTime:0.009508s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37471875 LIMIT 5 [ RunTime:0.020596s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37471875 ORDER BY `minOrder` ASC [ RunTime:0.006920s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37471875 ORDER BY `unit` DESC [ RunTime:0.003080s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37471875 LIMIT 2 [ RunTime:0.007046s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37471875 ORDER BY `minOrder` ASC [ RunTime:0.010145s ]
select * from pdf where partno='40-901-5000-psi/kPa-1/2-SSRF-BT8-CC' and brandshort='NOSHOK, Inc.' limit 1 [ RunTime:0.009802s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '40-901-5000-psi/kPa-1/2-SSRF-BT8-CC' OR `brand` LIKE 'NOSHOK, Inc.%' ) ) LIMIT 1 [ RunTime:0.019083s ]
SELECT `id` FROM `stock` WHERE `id` <> 37471875 AND `partno` = '40-901-5000-psi/kPa-1/2-SSRF-BT8-CC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%noshok, inc.%' ) [ RunTime:0.012902s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18857515 [ RunTime:0.021630s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37471874 LIMIT 5 [ RunTime:0.001856s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37471874 ORDER BY `minOrder` ASC [ RunTime:0.005360s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37471874 ORDER BY `unit` DESC [ RunTime:0.008707s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37471874 LIMIT 2 [ RunTime:0.003613s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37471874 ORDER BY `minOrder` ASC [ RunTime:0.002961s ]
select * from pdf where partno='40-901-5000-psi-1/2-SSRF-BT8-CC' and brandshort='NOSHOK, Inc.' limit 1 [ RunTime:0.000588s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '40-901-5000-psi-1/2-SSRF-BT8-CC' OR `brand` LIKE 'NOSHOK, Inc.%' ) ) LIMIT 1 [ RunTime:0.002101s ]
SELECT `id` FROM `stock` WHERE `id` <> 37471874 AND `partno` = '40-901-5000-psi-1/2-SSRF-BT8-CC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%noshok, inc.%' ) [ RunTime:0.008354s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18857514 [ RunTime:0.001735s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37471731 LIMIT 5 [ RunTime:0.009003s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37471731 ORDER BY `minOrder` ASC [ RunTime:0.022566s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37471731 ORDER BY `unit` DESC [ RunTime:0.003508s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37471731 LIMIT 2 [ RunTime:0.008791s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37471731 ORDER BY `minOrder` ASC [ RunTime:0.014038s ]
select * from pdf where partno='40-901-5000-psi/kPa-1/2-SSRF-CC' and brandshort='NOSHOK, Inc.' limit 1 [ RunTime:0.006409s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '40-901-5000-psi/kPa-1/2-SSRF-CC' OR `brand` LIKE 'NOSHOK, Inc.%' ) ) LIMIT 1 [ RunTime:0.001670s ]
SELECT `id` FROM `stock` WHERE `id` <> 37471731 AND `partno` = '40-901-5000-psi/kPa-1/2-SSRF-CC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%noshok, inc.%' ) [ RunTime:0.020981s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18857448 [ RunTime:0.005753s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37471730 LIMIT 5 [ RunTime:0.015281s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37471730 ORDER BY `minOrder` ASC [ RunTime:0.010139s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37471730 ORDER BY `unit` DESC [ RunTime:0.000350s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37471730 LIMIT 2 [ RunTime:0.003480s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37471730 ORDER BY `minOrder` ASC [ RunTime:0.002124s ]
select * from pdf where partno='40-901-5000-psi-1/2-SSRF-CC' and brandshort='NOSHOK, Inc.' limit 1 [ RunTime:0.013140s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '40-901-5000-psi-1/2-SSRF-CC' OR `brand` LIKE 'NOSHOK, Inc.%' ) ) LIMIT 1 [ RunTime:0.001917s ]
SELECT `id` FROM `stock` WHERE `id` <> 37471730 AND `partno` = '40-901-5000-psi-1/2-SSRF-CC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%noshok, inc.%' ) [ RunTime:0.008999s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18857447 [ RunTime:0.003285s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37470943 LIMIT 5 [ RunTime:0.004969s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37470943 ORDER BY `minOrder` ASC [ RunTime:0.012837s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37470943 ORDER BY `unit` DESC [ RunTime:0.007553s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37470943 LIMIT 2 [ RunTime:0.001192s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37470943 ORDER BY `minOrder` ASC [ RunTime:0.006432s ]
select * from pdf where partno='40-901-5000-psi/kPa-1/2-SSRF-MIP-BT8' and brandshort='NOSHOK, Inc.' limit 1 [ RunTime:0.005388s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '40-901-5000-psi/kPa-1/2-SSRF-MIP-BT8' OR `brand` LIKE 'NOSHOK, Inc.%' ) ) LIMIT 1 [ RunTime:0.007121s ]
SELECT `id` FROM `stock` WHERE `id` <> 37470943 AND `partno` = '40-901-5000-psi/kPa-1/2-SSRF-MIP-BT8' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%noshok, inc.%' ) [ RunTime:0.004811s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17025371 [ RunTime:0.000911s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37470912 LIMIT 5 [ RunTime:0.002835s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37470912 ORDER BY `minOrder` ASC [ RunTime:0.005853s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37470912 ORDER BY `unit` DESC [ RunTime:0.007407s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37470912 LIMIT 2 [ RunTime:0.000695s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37470912 ORDER BY `minOrder` ASC [ RunTime:0.000280s ]
select * from pdf where partno='40-901-5000-psi/kPa-1/2-SSRF-MIP' and brandshort='NOSHOK, Inc.' limit 1 [ RunTime:0.006705s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '40-901-5000-psi/kPa-1/2-SSRF-MIP' OR `brand` LIKE 'NOSHOK, Inc.%' ) ) LIMIT 1 [ RunTime:0.008695s ]
SELECT `id` FROM `stock` WHERE `id` <> 37470912 AND `partno` = '40-901-5000-psi/kPa-1/2-SSRF-MIP' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%noshok, inc.%' ) [ RunTime:0.017724s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18856995 [ RunTime:0.014998s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37470271 LIMIT 5 [ RunTime:0.000906s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37470271 ORDER BY `minOrder` ASC [ RunTime:0.000274s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37470271 ORDER BY `unit` DESC [ RunTime:0.001695s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37470271 LIMIT 2 [ RunTime:0.000314s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37470271 ORDER BY `minOrder` ASC [ RunTime:0.000299s ]
select * from pdf where partno='40-901-5000-psi-1/2-SSRF-BT8' and brandshort='NOSHOK, Inc.' limit 1 [ RunTime:0.001983s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '40-901-5000-psi-1/2-SSRF-BT8' OR `brand` LIKE 'NOSHOK, Inc.%' ) ) LIMIT 1 [ RunTime:0.000310s ]
SELECT `id` FROM `stock` WHERE `id` <> 37470271 AND `partno` = '40-901-5000-psi-1/2-SSRF-BT8' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%noshok, inc.%' ) [ RunTime:0.001511s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18856719 [ RunTime:0.000320s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37470270 LIMIT 5 [ RunTime:0.010857s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37470270 ORDER BY `minOrder` ASC [ RunTime:0.008315s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37470270 ORDER BY `unit` DESC [ RunTime:0.028655s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37470270 LIMIT 2 [ RunTime:0.001446s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37470270 ORDER BY `minOrder` ASC [ RunTime:0.000818s ]
select * from pdf where partno='40-901-5000-psi/kPa-1/2-SSRF-BT8' and brandshort='NOSHOK, Inc.' limit 1 [ RunTime:0.001049s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '40-901-5000-psi/kPa-1/2-SSRF-BT8' OR `brand` LIKE 'NOSHOK, Inc.%' ) ) LIMIT 1 [ RunTime:0.001535s ]
SELECT `id` FROM `stock` WHERE `id` <> 37470270 AND `partno` = '40-901-5000-psi/kPa-1/2-SSRF-BT8' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%noshok, inc.%' ) [ RunTime:0.003615s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18856718 [ RunTime:0.007551s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37470232 LIMIT 5 [ RunTime:0.000649s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37470232 ORDER BY `minOrder` ASC [ RunTime:0.002714s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37470232 ORDER BY `unit` DESC [ RunTime:0.000431s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37470232 LIMIT 2 [ RunTime:0.007413s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37470232 ORDER BY `minOrder` ASC [ RunTime:0.000689s ]
select * from pdf where partno='40-901-5000-psi-1/2-SSRF' and brandshort='NOSHOK, Inc.' limit 1 [ RunTime:0.000685s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '40-901-5000-psi-1/2-SSRF' OR `brand` LIKE 'NOSHOK, Inc.%' ) ) LIMIT 1 [ RunTime:0.003235s ]
SELECT `id` FROM `stock` WHERE `id` <> 37470232 AND `partno` = '40-901-5000-psi-1/2-SSRF' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%noshok, inc.%' ) [ RunTime:0.000602s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18856698 [ RunTime:0.000467s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37470231 LIMIT 5 [ RunTime:0.003316s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37470231 ORDER BY `minOrder` ASC [ RunTime:0.010669s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37470231 ORDER BY `unit` DESC [ RunTime:0.001585s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37470231 LIMIT 2 [ RunTime:0.000643s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37470231 ORDER BY `minOrder` ASC [ RunTime:0.001348s ]
select * from pdf where partno='40-901-5000-psi/kPa-1/2-SSRF' and brandshort='NOSHOK, Inc.' limit 1 [ RunTime:0.003636s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '40-901-5000-psi/kPa-1/2-SSRF' OR `brand` LIKE 'NOSHOK, Inc.%' ) ) LIMIT 1 [ RunTime:0.000999s ]
SELECT `id` FROM `stock` WHERE `id` <> 37470231 AND `partno` = '40-901-5000-psi/kPa-1/2-SSRF' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%noshok, inc.%' ) [ RunTime:0.001008s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18856697 [ RunTime:0.000742s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37472970 LIMIT 5 [ RunTime:0.004846s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37472970 ORDER BY `minOrder` ASC [ RunTime:0.000639s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37472970 ORDER BY `unit` DESC [ RunTime:0.008365s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37472970 LIMIT 2 [ RunTime:0.002560s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37472970 ORDER BY `minOrder` ASC [ RunTime:0.005113s ]
select * from pdf where partno='40-901-5000-psi/kPa-SSRF-MIP-BT8-CC' and brandshort='NOSHOK, Inc.' limit 1 [ RunTime:0.001394s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '40-901-5000-psi/kPa-SSRF-MIP-BT8-CC' OR `brand` LIKE 'NOSHOK, Inc.%' ) ) LIMIT 1 [ RunTime:0.000820s ]
SELECT `id` FROM `stock` WHERE `id` <> 37472970 AND `partno` = '40-901-5000-psi/kPa-SSRF-MIP-BT8-CC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%noshok, inc.%' ) [ RunTime:0.000855s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18860779 [ RunTime:0.001051s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37472948 LIMIT 5 [ RunTime:0.008257s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37472948 ORDER BY `minOrder` ASC [ RunTime:0.003350s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37472948 ORDER BY `unit` DESC [ RunTime:0.000637s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37472948 LIMIT 2 [ RunTime:0.000614s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37472948 ORDER BY `minOrder` ASC [ RunTime:0.002019s ]
select * from pdf where partno='40-901-5000-psi/kPa-SSRF-MIP-CC' and brandshort='NOSHOK, Inc.' limit 1 [ RunTime:0.014489s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '40-901-5000-psi/kPa-SSRF-MIP-CC' OR `brand` LIKE 'NOSHOK, Inc.%' ) ) LIMIT 1 [ RunTime:0.001170s ]
SELECT `id` FROM `stock` WHERE `id` <> 37472948 AND `partno` = '40-901-5000-psi/kPa-SSRF-MIP-CC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%noshok, inc.%' ) [ RunTime:0.000806s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17026066 [ RunTime:0.000906s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37471891 LIMIT 5 [ RunTime:0.000892s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37471891 ORDER BY `minOrder` ASC [ RunTime:0.004845s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37471891 ORDER BY `unit` DESC [ RunTime:0.004459s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37471891 LIMIT 2 [ RunTime:0.011149s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37471891 ORDER BY `minOrder` ASC [ RunTime:0.013126s ]
select * from pdf where partno='40-901-5000-psi/kPa-SSRF-BT8-CC' and brandshort='NOSHOK, Inc.' limit 1 [ RunTime:0.001745s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '40-901-5000-psi/kPa-SSRF-BT8-CC' OR `brand` LIKE 'NOSHOK, Inc.%' ) ) LIMIT 1 [ RunTime:0.009615s ]
SELECT `id` FROM `stock` WHERE `id` <> 37471891 AND `partno` = '40-901-5000-psi/kPa-SSRF-BT8-CC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%noshok, inc.%' ) [ RunTime:0.003607s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15240982 [ RunTime:0.003589s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37471890 LIMIT 5 [ RunTime:0.001382s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37471890 ORDER BY `minOrder` ASC [ RunTime:0.000903s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37471890 ORDER BY `unit` DESC [ RunTime:0.002876s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37471890 LIMIT 2 [ RunTime:0.007290s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37471890 ORDER BY `minOrder` ASC [ RunTime:0.004519s ]
select * from pdf where partno='40-901-5000-psi-SSRF-BT8-CC' and brandshort='NOSHOK, Inc.' limit 1 [ RunTime:0.010971s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '40-901-5000-psi-SSRF-BT8-CC' OR `brand` LIKE 'NOSHOK, Inc.%' ) ) LIMIT 1 [ RunTime:0.005668s ]
SELECT `id` FROM `stock` WHERE `id` <> 37471890 AND `partno` = '40-901-5000-psi-SSRF-BT8-CC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%noshok, inc.%' ) [ RunTime:0.003527s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15240981 [ RunTime:0.011633s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37471748 LIMIT 5 [ RunTime:0.000919s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37471748 ORDER BY `minOrder` ASC [ RunTime:0.000618s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37471748 ORDER BY `unit` DESC [ RunTime:0.002820s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37471748 LIMIT 2 [ RunTime:0.004104s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37471748 ORDER BY `minOrder` ASC [ RunTime:0.006766s ]
select * from pdf where partno='40-901-5000-psi/kPa-SSRF-CC' and brandshort='NOSHOK, Inc.' limit 1 [ RunTime:0.013091s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '40-901-5000-psi/kPa-SSRF-CC' OR `brand` LIKE 'NOSHOK, Inc.%' ) ) LIMIT 1 [ RunTime:0.011543s ]
SELECT `id` FROM `stock` WHERE `id` <> 37471748 AND `partno` = '40-901-5000-psi/kPa-SSRF-CC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%noshok, inc.%' ) [ RunTime:0.004586s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18860289 [ RunTime:0.002344s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37471743 LIMIT 5 [ RunTime:0.002283s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37471743 ORDER BY `minOrder` ASC [ RunTime:0.012061s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37471743 ORDER BY `unit` DESC [ RunTime:0.006267s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37471743 LIMIT 2 [ RunTime:0.009921s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37471743 ORDER BY `minOrder` ASC [ RunTime:0.005422s ]
select * from pdf where partno='40-901-5000-psi-SSRF-CC' and brandshort='NOSHOK, Inc.' limit 1 [ RunTime:0.002093s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '40-901-5000-psi-SSRF-CC' OR `brand` LIKE 'NOSHOK, Inc.%' ) ) LIMIT 1 [ RunTime:0.001495s ]
SELECT `id` FROM `stock` WHERE `id` <> 37471743 AND `partno` = '40-901-5000-psi-SSRF-CC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%noshok, inc.%' ) [ RunTime:0.000654s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18860288 [ RunTime:0.000485s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37470953 LIMIT 5 [ RunTime:0.010885s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37470953 ORDER BY `minOrder` ASC [ RunTime:0.030128s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37470953 ORDER BY `unit` DESC [ RunTime:0.012309s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37470953 LIMIT 2 [ RunTime:0.014616s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37470953 ORDER BY `minOrder` ASC [ RunTime:0.001733s ]
select * from pdf where partno='40-901-5000-psi/kPa-SSRF-MIP-BT8' and brandshort='NOSHOK, Inc.' limit 1 [ RunTime:0.002355s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '40-901-5000-psi/kPa-SSRF-MIP-BT8' OR `brand` LIKE 'NOSHOK, Inc.%' ) ) LIMIT 1 [ RunTime:0.000952s ]
SELECT `id` FROM `stock` WHERE `id` <> 37470953 AND `partno` = '40-901-5000-psi/kPa-SSRF-MIP-BT8' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%noshok, inc.%' ) [ RunTime:0.000720s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18860004 [ RunTime:0.002443s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37470926 LIMIT 5 [ RunTime:0.001540s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37470926 ORDER BY `minOrder` ASC [ RunTime:0.004449s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37470926 ORDER BY `unit` DESC [ RunTime:0.000558s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37470926 LIMIT 2 [ RunTime:0.003328s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37470926 ORDER BY `minOrder` ASC [ RunTime:0.004503s ]
select * from pdf where partno='40-901-5000-psi/kPa-SSRF-MIP' and brandshort='NOSHOK, Inc.' limit 1 [ RunTime:0.012272s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '40-901-5000-psi/kPa-SSRF-MIP' OR `brand` LIKE 'NOSHOK, Inc.%' ) ) LIMIT 1 [ RunTime:0.032770s ]
SELECT `id` FROM `stock` WHERE `id` <> 37470926 AND `partno` = '40-901-5000-psi/kPa-SSRF-MIP' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%noshok, inc.%' ) [ RunTime:0.006815s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18859892 [ RunTime:0.008450s ]
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 '40-901-5000-psi%' OR `brand` LIKE '40-901-5000-psi%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.023821s ]
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 '40-901-5000-psi%' OR `brand` LIKE '40-901-5000-psi%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001686s ]
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 '40-901-5000-psi%' OR `brand` LIKE '40-901-5000-psi%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.006673s ]
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 '40-901-5000-psi%' OR `brand` LIKE '40-901-5000-psi%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.019733s ]
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 '40-901-5000-psi%' OR `brand` LIKE '40-901-5000-psi%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.012998s ]
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 '40-901-5000-psi%' OR `brand` LIKE '40-901-5000-psi%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.010743s ]
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 '40-901-5000-psi%' OR `brand` LIKE '40-901-5000-psi%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.020949s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '40-901-5000-psi%' OR `brand` LIKE '40-901-5000-psi%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.020661s ]