SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001543s ]
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-30-psi-SSRF%' OR `brand` LIKE '40-901-30-psi-SSRF%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.015981s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001501s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18857376 LIMIT 5 [ RunTime:0.011138s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001295s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18857376 ORDER BY `minOrder` ASC [ RunTime:0.013358s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.005873s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18857376 ORDER BY `unit` DESC [ RunTime:0.004161s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.001921s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18857376 LIMIT 2 [ RunTime:0.013178s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18857376 ORDER BY `minOrder` ASC [ RunTime:0.003069s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18857324 LIMIT 5 [ RunTime:0.001793s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18857324 ORDER BY `minOrder` ASC [ RunTime:0.011014s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18857324 ORDER BY `unit` DESC [ RunTime:0.012489s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18857324 LIMIT 2 [ RunTime:0.012948s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18857324 ORDER BY `minOrder` ASC [ RunTime:0.009940s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18856686 LIMIT 5 [ RunTime:0.031345s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18856686 ORDER BY `minOrder` ASC [ RunTime:0.050402s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18856686 ORDER BY `unit` DESC [ RunTime:0.018699s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18856686 LIMIT 2 [ RunTime:0.039741s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18856686 ORDER BY `minOrder` ASC [ RunTime:0.010619s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18856679 LIMIT 5 [ RunTime:0.008293s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18856679 ORDER BY `minOrder` ASC [ RunTime:0.041715s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18856679 ORDER BY `unit` DESC [ RunTime:0.015825s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18856679 LIMIT 2 [ RunTime:0.017493s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18856679 ORDER BY `minOrder` ASC [ RunTime:0.013400s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18858106 LIMIT 5 [ RunTime:0.020818s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18858106 ORDER BY `minOrder` ASC [ RunTime:0.063709s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18858106 ORDER BY `unit` DESC [ RunTime:0.024926s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18858106 LIMIT 2 [ RunTime:0.023095s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18858106 ORDER BY `minOrder` ASC [ RunTime:0.028373s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18858099 LIMIT 5 [ RunTime:0.014431s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18858099 ORDER BY `minOrder` ASC [ RunTime:0.045502s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18858099 ORDER BY `unit` DESC [ RunTime:0.060013s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18858099 LIMIT 2 [ RunTime:0.073099s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18858099 ORDER BY `minOrder` ASC [ RunTime:0.008543s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18856977 LIMIT 5 [ RunTime:0.015569s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18856977 ORDER BY `minOrder` ASC [ RunTime:0.019326s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18856977 ORDER BY `unit` DESC [ RunTime:0.017941s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18856977 LIMIT 2 [ RunTime:0.053958s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18856977 ORDER BY `minOrder` ASC [ RunTime:0.031971s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18856967 LIMIT 5 [ RunTime:0.036030s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18856967 ORDER BY `minOrder` ASC [ RunTime:0.020080s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18856967 ORDER BY `unit` DESC [ RunTime:0.004078s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18856967 LIMIT 2 [ RunTime:0.021582s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18856967 ORDER BY `minOrder` ASC [ RunTime:0.004258s ]
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-30-psi-SSRF%' OR `brand` LIKE '40-901-30-psi-SSRF%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.020681s ]
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-30-psi-SSRF%' OR `brand` LIKE '40-901-30-psi-SSRF%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.011728s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37476270 LIMIT 5 [ RunTime:0.004365s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37476270 ORDER BY `minOrder` ASC [ RunTime:0.021918s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37476270 ORDER BY `unit` DESC [ RunTime:0.004459s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37476270 LIMIT 2 [ RunTime:0.011164s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37476270 ORDER BY `minOrder` ASC [ RunTime:0.002069s ]
select * from pdf where partno='40-901-30-psi-SSRF-MIP-BT8-CC' and brandshort='NOSHOK, Inc.' limit 1 [ RunTime:0.011940s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002442s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '40-901-30-psi-SSRF-MIP-BT8-CC' OR `brand` LIKE 'NOSHOK, Inc.%' ) ) LIMIT 1 [ RunTime:0.025750s ]
SELECT `id` FROM `stock` WHERE `id` <> 37476270 AND `partno` = '40-901-30-psi-SSRF-MIP-BT8-CC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%noshok, inc.%' ) [ RunTime:0.011179s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18858106 [ RunTime:0.014877s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37476255 LIMIT 5 [ RunTime:0.015938s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37476255 ORDER BY `minOrder` ASC [ RunTime:0.004805s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37476255 ORDER BY `unit` DESC [ RunTime:0.028932s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37476255 LIMIT 2 [ RunTime:0.028174s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37476255 ORDER BY `minOrder` ASC [ RunTime:0.010447s ]
select * from pdf where partno='40-901-30-psi-SSRF-MIP-CC' and brandshort='NOSHOK, Inc.' limit 1 [ RunTime:0.013779s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '40-901-30-psi-SSRF-MIP-CC' OR `brand` LIKE 'NOSHOK, Inc.%' ) ) LIMIT 1 [ RunTime:0.010116s ]
SELECT `id` FROM `stock` WHERE `id` <> 37476255 AND `partno` = '40-901-30-psi-SSRF-MIP-CC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%noshok, inc.%' ) [ RunTime:0.021672s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18858099 [ RunTime:0.016564s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37475728 LIMIT 5 [ RunTime:0.014519s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37475728 ORDER BY `minOrder` ASC [ RunTime:0.002902s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37475728 ORDER BY `unit` DESC [ RunTime:0.002992s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37475728 LIMIT 2 [ RunTime:0.000737s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37475728 ORDER BY `minOrder` ASC [ RunTime:0.009471s ]
select * from pdf where partno='40-901-30-psi-SSRF-BT8-CC' and brandshort='NOSHOK, Inc.' limit 1 [ RunTime:0.001094s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '40-901-30-psi-SSRF-BT8-CC' OR `brand` LIKE 'NOSHOK, Inc.%' ) ) LIMIT 1 [ RunTime:0.004392s ]
SELECT `id` FROM `stock` WHERE `id` <> 37475728 AND `partno` = '40-901-30-psi-SSRF-BT8-CC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%noshok, inc.%' ) [ RunTime:0.003955s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18857376 [ RunTime:0.000426s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37475682 LIMIT 5 [ RunTime:0.000409s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37475682 ORDER BY `minOrder` ASC [ RunTime:0.000397s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37475682 ORDER BY `unit` DESC [ RunTime:0.000379s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37475682 LIMIT 2 [ RunTime:0.000361s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37475682 ORDER BY `minOrder` ASC [ RunTime:0.000400s ]
select * from pdf where partno='40-901-30-psi-SSRF-CC' and brandshort='NOSHOK, Inc.' limit 1 [ RunTime:0.000557s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '40-901-30-psi-SSRF-CC' OR `brand` LIKE 'NOSHOK, Inc.%' ) ) LIMIT 1 [ RunTime:0.000374s ]
SELECT `id` FROM `stock` WHERE `id` <> 37475682 AND `partno` = '40-901-30-psi-SSRF-CC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%noshok, inc.%' ) [ RunTime:0.001450s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18857324 [ RunTime:0.003774s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37475389 LIMIT 5 [ RunTime:0.001797s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37475389 ORDER BY `minOrder` ASC [ RunTime:0.008483s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37475389 ORDER BY `unit` DESC [ RunTime:0.004452s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37475389 LIMIT 2 [ RunTime:0.010360s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37475389 ORDER BY `minOrder` ASC [ RunTime:0.002142s ]
select * from pdf where partno='40-901-30-psi-SSRF-MIP-BT8' and brandshort='NOSHOK, Inc.' limit 1 [ RunTime:0.002029s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '40-901-30-psi-SSRF-MIP-BT8' OR `brand` LIKE 'NOSHOK, Inc.%' ) ) LIMIT 1 [ RunTime:0.000658s ]
SELECT `id` FROM `stock` WHERE `id` <> 37475389 AND `partno` = '40-901-30-psi-SSRF-MIP-BT8' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%noshok, inc.%' ) [ RunTime:0.007352s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18856977 [ RunTime:0.017878s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37475357 LIMIT 5 [ RunTime:0.007865s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37475357 ORDER BY `minOrder` ASC [ RunTime:0.035515s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37475357 ORDER BY `unit` DESC [ RunTime:0.003382s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37475357 LIMIT 2 [ RunTime:0.013705s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37475357 ORDER BY `minOrder` ASC [ RunTime:0.001607s ]
select * from pdf where partno='40-901-30-psi-SSRF-MIP' and brandshort='NOSHOK, Inc.' limit 1 [ RunTime:0.014352s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '40-901-30-psi-SSRF-MIP' OR `brand` LIKE 'NOSHOK, Inc.%' ) ) LIMIT 1 [ RunTime:0.010466s ]
SELECT `id` FROM `stock` WHERE `id` <> 37475357 AND `partno` = '40-901-30-psi-SSRF-MIP' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%noshok, inc.%' ) [ RunTime:0.008203s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18856967 [ RunTime:0.020832s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37474935 LIMIT 5 [ RunTime:0.017436s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37474935 ORDER BY `minOrder` ASC [ RunTime:0.014673s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37474935 ORDER BY `unit` DESC [ RunTime:0.003434s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37474935 LIMIT 2 [ RunTime:0.015435s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37474935 ORDER BY `minOrder` ASC [ RunTime:0.007471s ]
select * from pdf where partno='40-901-30-psi-SSRF-BT8' and brandshort='NOSHOK, Inc.' limit 1 [ RunTime:0.013383s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '40-901-30-psi-SSRF-BT8' OR `brand` LIKE 'NOSHOK, Inc.%' ) ) LIMIT 1 [ RunTime:0.015767s ]
SELECT `id` FROM `stock` WHERE `id` <> 37474935 AND `partno` = '40-901-30-psi-SSRF-BT8' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%noshok, inc.%' ) [ RunTime:0.038820s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18856686 [ RunTime:0.028312s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37474918 LIMIT 5 [ RunTime:0.014398s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37474918 ORDER BY `minOrder` ASC [ RunTime:0.025224s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37474918 ORDER BY `unit` DESC [ RunTime:0.009845s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37474918 LIMIT 2 [ RunTime:0.019038s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37474918 ORDER BY `minOrder` ASC [ RunTime:0.001807s ]
select * from pdf where partno='40-901-30-psi-SSRF' and brandshort='NOSHOK, Inc.' limit 1 [ RunTime:0.008965s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '40-901-30-psi-SSRF' OR `brand` LIKE 'NOSHOK, Inc.%' ) ) LIMIT 1 [ RunTime:0.014141s ]
SELECT `id` FROM `stock` WHERE `id` <> 37474918 AND `partno` = '40-901-30-psi-SSRF' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%noshok, inc.%' ) [ RunTime:0.026463s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18856679 [ RunTime:0.031316s ]
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-30-psi-SSRF%' OR `brand` LIKE '40-901-30-psi-SSRF%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.013669s ]
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-30-psi-SSRF%' OR `brand` LIKE '40-901-30-psi-SSRF%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.012635s ]
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-30-psi-SSRF%' OR `brand` LIKE '40-901-30-psi-SSRF%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.011379s ]
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-30-psi-SSRF%' OR `brand` LIKE '40-901-30-psi-SSRF%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.033578s ]
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-30-psi-SSRF%' OR `brand` LIKE '40-901-30-psi-SSRF%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.017873s ]
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-30-psi-SSRF%' OR `brand` LIKE '40-901-30-psi-SSRF%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.010301s ]
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-30-psi-SSRF%' OR `brand` LIKE '40-901-30-psi-SSRF%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.004755s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '40-901-30-psi-SSRF%' OR `brand` LIKE '40-901-30-psi-SSRF%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.018499s ]