SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001203s ]
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 'SSQ-106-02-G-D%' OR `brand` LIKE 'SSQ-106-02-G-D%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.004965s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001243s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11545583 LIMIT 5 [ RunTime:0.023327s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.005474s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11545583 ORDER BY `minOrder` ASC [ RunTime:0.020030s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.000904s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11545583 ORDER BY `unit` DESC [ RunTime:0.009631s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.005646s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11545583 LIMIT 2 [ RunTime:0.036362s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11545583 ORDER BY `minOrder` ASC [ RunTime:0.002405s ]
select * from pdf where partno='SSQ-106-02-G-D' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.024671s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12635517 LIMIT 5 [ RunTime:0.019637s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12635517 ORDER BY `minOrder` ASC [ RunTime:0.016032s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12635517 ORDER BY `unit` DESC [ RunTime:0.011342s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12635517 LIMIT 2 [ RunTime:0.029341s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12635517 ORDER BY `minOrder` ASC [ RunTime:0.022082s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12633780 LIMIT 5 [ RunTime:0.047399s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12633780 ORDER BY `minOrder` ASC [ RunTime:0.068567s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12633780 ORDER BY `unit` DESC [ RunTime:0.110697s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12633780 LIMIT 2 [ RunTime:0.050309s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12633780 ORDER BY `minOrder` ASC [ RunTime:0.029118s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11548151 LIMIT 5 [ RunTime:0.054459s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11548151 ORDER BY `minOrder` ASC [ RunTime:0.036953s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11548151 ORDER BY `unit` DESC [ RunTime:0.047745s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11548151 LIMIT 2 [ RunTime:0.068253s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11548151 ORDER BY `minOrder` ASC [ RunTime:0.049090s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11516532 LIMIT 5 [ RunTime:0.052461s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11516532 ORDER BY `minOrder` ASC [ RunTime:0.065343s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11516532 ORDER BY `unit` DESC [ RunTime:0.017910s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11516532 LIMIT 2 [ RunTime:0.125602s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11516532 ORDER BY `minOrder` ASC [ RunTime:0.150145s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11498999 LIMIT 5 [ RunTime:0.069886s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11498999 ORDER BY `minOrder` ASC [ RunTime:0.052846s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11498999 ORDER BY `unit` DESC [ RunTime:0.083963s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11498999 LIMIT 2 [ RunTime:0.057007s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11498999 ORDER BY `minOrder` ASC [ RunTime:0.021258s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11497877 LIMIT 5 [ RunTime:0.042981s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11497877 ORDER BY `minOrder` ASC [ RunTime:0.052279s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11497877 ORDER BY `unit` DESC [ RunTime:0.063082s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11497877 LIMIT 2 [ RunTime:0.018906s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11497877 ORDER BY `minOrder` ASC [ RunTime:0.012974s ]
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 'SSQ-106-02-G-D%' OR `brand` LIKE 'SSQ-106-02-G-D%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.010405s ]
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 'SSQ-106-02-G-D%' OR `brand` LIKE 'SSQ-106-02-G-D%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.042097s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 52897726 LIMIT 5 [ RunTime:0.019122s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52897726 ORDER BY `minOrder` ASC [ RunTime:0.025976s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 52897726 ORDER BY `unit` DESC [ RunTime:0.003157s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 52897726 LIMIT 2 [ RunTime:0.000476s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52897726 ORDER BY `minOrder` ASC [ RunTime:0.001698s ]
select * from pdf where partno='SSQ-106-02-G-D' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.018681s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001537s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SSQ-106-02-G-D' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.016240s ]
SELECT `id` FROM `stock` WHERE `id` <> 52897726 AND `partno` = 'SSQ-106-02-G-D' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.007265s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11545583 [ RunTime:0.010463s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 52897946 LIMIT 5 [ RunTime:0.008670s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52897946 ORDER BY `minOrder` ASC [ RunTime:0.007443s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 52897946 ORDER BY `unit` DESC [ RunTime:0.000598s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 52897946 LIMIT 2 [ RunTime:0.006152s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52897946 ORDER BY `minOrder` ASC [ RunTime:0.000417s ]
select * from pdf where partno='SSQ-106-02-G-D-RA' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.001570s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SSQ-106-02-G-D-RA' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.011392s ]
SELECT `id` FROM `stock` WHERE `id` <> 52897946 AND `partno` = 'SSQ-106-02-G-D-RA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.035927s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 52897924 LIMIT 5 [ RunTime:0.007423s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52897924 ORDER BY `minOrder` ASC [ RunTime:0.015189s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 52897924 ORDER BY `unit` DESC [ RunTime:0.004600s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 52897924 LIMIT 2 [ RunTime:0.006920s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52897924 ORDER BY `minOrder` ASC [ RunTime:0.006753s ]
select * from pdf where partno='SSQ-106-02-G-D-RA-008' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.007601s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SSQ-106-02-G-D-RA-008' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.009622s ]
SELECT `id` FROM `stock` WHERE `id` <> 52897924 AND `partno` = 'SSQ-106-02-G-D-RA-008' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.017904s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12635517 [ RunTime:0.016609s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 52897923 LIMIT 5 [ RunTime:0.006993s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52897923 ORDER BY `minOrder` ASC [ RunTime:0.009736s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 52897923 ORDER BY `unit` DESC [ RunTime:0.013921s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 52897923 LIMIT 2 [ RunTime:0.010970s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52897923 ORDER BY `minOrder` ASC [ RunTime:0.003488s ]
select * from pdf where partno='SSQ-106-02-G-D-RA-005' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.011915s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SSQ-106-02-G-D-RA-005' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.022181s ]
SELECT `id` FROM `stock` WHERE `id` <> 52897923 AND `partno` = 'SSQ-106-02-G-D-RA-005' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.003958s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11498999 [ RunTime:0.016812s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 52897794 LIMIT 5 [ RunTime:0.011790s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52897794 ORDER BY `minOrder` ASC [ RunTime:0.019573s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 52897794 ORDER BY `unit` DESC [ RunTime:0.014717s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 52897794 LIMIT 2 [ RunTime:0.009693s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52897794 ORDER BY `minOrder` ASC [ RunTime:0.006013s ]
select * from pdf where partno='SSQ-106-02-G-D-RA-LL' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.002783s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SSQ-106-02-G-D-RA-LL' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.007785s ]
SELECT `id` FROM `stock` WHERE `id` <> 52897794 AND `partno` = 'SSQ-106-02-G-D-RA-LL' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.015383s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 52897677 LIMIT 5 [ RunTime:0.009712s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52897677 ORDER BY `minOrder` ASC [ RunTime:0.026291s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 52897677 ORDER BY `unit` DESC [ RunTime:0.003399s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 52897677 LIMIT 2 [ RunTime:0.018194s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52897677 ORDER BY `minOrder` ASC [ RunTime:0.010786s ]
select * from pdf where partno='SSQ-106-02-G-D-011' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.020103s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SSQ-106-02-G-D-011' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.012192s ]
SELECT `id` FROM `stock` WHERE `id` <> 52897677 AND `partno` = 'SSQ-106-02-G-D-011' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.019747s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11497877 [ RunTime:0.036006s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 52897674 LIMIT 5 [ RunTime:0.007386s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52897674 ORDER BY `minOrder` ASC [ RunTime:0.045329s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 52897674 ORDER BY `unit` DESC [ RunTime:0.013747s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 52897674 LIMIT 2 [ RunTime:0.000591s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52897674 ORDER BY `minOrder` ASC [ RunTime:0.008670s ]
select * from pdf where partno='SSQ-106-02-G-D-001' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.008218s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SSQ-106-02-G-D-001' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.001130s ]
SELECT `id` FROM `stock` WHERE `id` <> 52897674 AND `partno` = 'SSQ-106-02-G-D-001' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.000930s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12633780 [ RunTime:0.013215s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 52897514 LIMIT 5 [ RunTime:0.004948s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52897514 ORDER BY `minOrder` ASC [ RunTime:0.000863s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 52897514 ORDER BY `unit` DESC [ RunTime:0.012639s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 52897514 LIMIT 2 [ RunTime:0.017466s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52897514 ORDER BY `minOrder` ASC [ RunTime:0.001490s ]
select * from pdf where partno='SSQ-106-02-G-D-LL' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.023709s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SSQ-106-02-G-D-LL' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.007385s ]
SELECT `id` FROM `stock` WHERE `id` <> 52897514 AND `partno` = 'SSQ-106-02-G-D-LL' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.007276s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11548151 [ RunTime:0.015977s ]
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 'SSQ-106-02-G-D%' OR `brand` LIKE 'SSQ-106-02-G-D%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.004490s ]
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 'SSQ-106-02-G-D%' OR `brand` LIKE 'SSQ-106-02-G-D%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.008843s ]
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 'SSQ-106-02-G-D%' OR `brand` LIKE 'SSQ-106-02-G-D%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.031289s ]
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 'SSQ-106-02-G-D%' OR `brand` LIKE 'SSQ-106-02-G-D%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.049047s ]
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 'SSQ-106-02-G-D%' OR `brand` LIKE 'SSQ-106-02-G-D%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.021941s ]
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 'SSQ-106-02-G-D%' OR `brand` LIKE 'SSQ-106-02-G-D%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.030164s ]
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 'SSQ-106-02-G-D%' OR `brand` LIKE 'SSQ-106-02-G-D%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.055921s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'SSQ-106-02-G-D%' OR `brand` LIKE 'SSQ-106-02-G-D%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.035217s ]