SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001534s ]
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 '1061705%' OR `brand` LIKE '1061705%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.004998s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001712s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11225649 LIMIT 5 [ RunTime:0.005673s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.003792s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11225649 ORDER BY `minOrder` ASC [ RunTime:0.007425s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.018000s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11225649 ORDER BY `unit` DESC [ RunTime:0.010745s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.006719s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11225649 LIMIT 2 [ RunTime:0.009890s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11225649 ORDER BY `minOrder` ASC [ RunTime:0.014187s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11225127 LIMIT 5 [ RunTime:0.018392s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11225127 ORDER BY `minOrder` ASC [ RunTime:0.042954s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11225127 ORDER BY `unit` DESC [ RunTime:0.010578s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11225127 LIMIT 2 [ RunTime:0.110339s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11225127 ORDER BY `minOrder` ASC [ RunTime:0.035451s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12224415 LIMIT 5 [ RunTime:0.013709s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12224415 ORDER BY `minOrder` ASC [ RunTime:0.024166s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12224415 ORDER BY `unit` DESC [ RunTime:0.064645s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12224415 LIMIT 2 [ RunTime:0.039008s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12224415 ORDER BY `minOrder` ASC [ RunTime:0.005338s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12225358 LIMIT 5 [ RunTime:0.072111s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12225358 ORDER BY `minOrder` ASC [ RunTime:0.016479s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12225358 ORDER BY `unit` DESC [ RunTime:0.022369s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12225358 LIMIT 2 [ RunTime:0.038480s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12225358 ORDER BY `minOrder` ASC [ RunTime:0.016532s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12223915 LIMIT 5 [ RunTime:0.037119s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12223915 ORDER BY `minOrder` ASC [ RunTime:0.054265s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12223915 ORDER BY `unit` DESC [ RunTime:0.016507s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12223915 LIMIT 2 [ RunTime:0.031682s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12223915 ORDER BY `minOrder` ASC [ RunTime:0.004418s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11225070 LIMIT 5 [ RunTime:0.020931s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11225070 ORDER BY `minOrder` ASC [ RunTime:0.016625s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11225070 ORDER BY `unit` DESC [ RunTime:0.020438s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11225070 LIMIT 2 [ RunTime:0.044251s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11225070 ORDER BY `minOrder` ASC [ RunTime:0.013723s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12224604 LIMIT 5 [ RunTime:0.015827s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12224604 ORDER BY `minOrder` ASC [ RunTime:0.021067s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12224604 ORDER BY `unit` DESC [ RunTime:0.041459s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12224604 LIMIT 2 [ RunTime:0.004479s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12224604 ORDER BY `minOrder` ASC [ RunTime:0.002647s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18773604 LIMIT 5 [ RunTime:0.029172s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18773604 ORDER BY `minOrder` ASC [ RunTime:0.023960s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18773604 ORDER BY `unit` DESC [ RunTime:0.022148s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18773604 LIMIT 2 [ RunTime:0.022769s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18773604 ORDER BY `minOrder` ASC [ RunTime:0.036617s ]
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 '1061705%' OR `brand` LIKE '1061705%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.021390s ]
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 '1061705%' OR `brand` LIKE '1061705%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.045417s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58147562 LIMIT 5 [ RunTime:0.012493s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58147562 ORDER BY `minOrder` ASC [ RunTime:0.010629s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58147562 ORDER BY `unit` DESC [ RunTime:0.004946s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58147562 LIMIT 2 [ RunTime:0.020707s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58147562 ORDER BY `minOrder` ASC [ RunTime:0.000885s ]
select * from pdf where partno='1061705852-02-C' and brandshort='ATGBICS' limit 1 [ RunTime:0.003574s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002588s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1061705852-02-C' OR `brand` LIKE 'ATGBICS%' ) ) LIMIT 1 [ RunTime:0.015694s ]
SELECT `id` FROM `stock` WHERE `id` <> 58147562 AND `partno` = '1061705852-02-C' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%atgbics%' ) [ RunTime:0.002468s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12225358 [ RunTime:0.000728s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58142946 LIMIT 5 [ RunTime:0.016538s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58142946 ORDER BY `minOrder` ASC [ RunTime:0.018050s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58142946 ORDER BY `unit` DESC [ RunTime:0.023158s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58142946 LIMIT 2 [ RunTime:0.016420s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58142946 ORDER BY `minOrder` ASC [ RunTime:0.003665s ]
select * from pdf where partno='1061705854-02-C' and brandshort='ATGBICS' limit 1 [ RunTime:0.022498s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1061705854-02-C' OR `brand` LIKE 'ATGBICS%' ) ) LIMIT 1 [ RunTime:0.034854s ]
SELECT `id` FROM `stock` WHERE `id` <> 58142946 AND `partno` = '1061705854-02-C' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%atgbics%' ) [ RunTime:0.009719s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58143732 LIMIT 5 [ RunTime:0.001663s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58143732 ORDER BY `minOrder` ASC [ RunTime:0.010414s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58143732 ORDER BY `unit` DESC [ RunTime:0.017750s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58143732 LIMIT 2 [ RunTime:0.012036s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58143732 ORDER BY `minOrder` ASC [ RunTime:0.013567s ]
select * from pdf where partno='1061705850-02-C' and brandshort='ATGBICS' limit 1 [ RunTime:0.008375s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1061705850-02-C' OR `brand` LIKE 'ATGBICS%' ) ) LIMIT 1 [ RunTime:0.011788s ]
SELECT `id` FROM `stock` WHERE `id` <> 58143732 AND `partno` = '1061705850-02-C' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%atgbics%' ) [ RunTime:0.046826s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11225127 [ RunTime:0.025551s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58145054 LIMIT 5 [ RunTime:0.044119s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58145054 ORDER BY `minOrder` ASC [ RunTime:0.026584s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58145054 ORDER BY `unit` DESC [ RunTime:0.026931s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58145054 LIMIT 2 [ RunTime:0.015252s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58145054 ORDER BY `minOrder` ASC [ RunTime:0.018021s ]
select * from pdf where partno='1061705851-02-C' and brandshort='ATGBICS' limit 1 [ RunTime:0.020581s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1061705851-02-C' OR `brand` LIKE 'ATGBICS%' ) ) LIMIT 1 [ RunTime:0.036126s ]
SELECT `id` FROM `stock` WHERE `id` <> 58145054 AND `partno` = '1061705851-02-C' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%atgbics%' ) [ RunTime:0.025716s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12224415 [ RunTime:0.017414s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58146005 LIMIT 5 [ RunTime:0.027097s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58146005 ORDER BY `minOrder` ASC [ RunTime:0.029343s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58146005 ORDER BY `unit` DESC [ RunTime:0.049591s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58146005 LIMIT 2 [ RunTime:0.025107s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58146005 ORDER BY `minOrder` ASC [ RunTime:0.010921s ]
select * from pdf where partno='1061705851-01-C' and brandshort='ATGBICS' limit 1 [ RunTime:0.015513s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1061705851-01-C' OR `brand` LIKE 'ATGBICS%' ) ) LIMIT 1 [ RunTime:0.031285s ]
SELECT `id` FROM `stock` WHERE `id` <> 58146005 AND `partno` = '1061705851-01-C' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%atgbics%' ) [ RunTime:0.043109s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11225649 [ RunTime:0.074646s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58144583 LIMIT 5 [ RunTime:0.017213s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58144583 ORDER BY `minOrder` ASC [ RunTime:0.052023s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58144583 ORDER BY `unit` DESC [ RunTime:0.035138s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58144583 LIMIT 2 [ RunTime:0.057747s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58144583 ORDER BY `minOrder` ASC [ RunTime:0.070651s ]
select * from pdf where partno='1061705875-01-C' and brandshort='ATGBICS' limit 1 [ RunTime:0.051152s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1061705875-01-C' OR `brand` LIKE 'ATGBICS%' ) ) LIMIT 1 [ RunTime:0.061263s ]
SELECT `id` FROM `stock` WHERE `id` <> 58144583 AND `partno` = '1061705875-01-C' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%atgbics%' ) [ RunTime:0.067878s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58143606 LIMIT 5 [ RunTime:0.123791s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58143606 ORDER BY `minOrder` ASC [ RunTime:0.064860s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58143606 ORDER BY `unit` DESC [ RunTime:0.024010s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58143606 LIMIT 2 [ RunTime:0.054571s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58143606 ORDER BY `minOrder` ASC [ RunTime:0.007192s ]
select * from pdf where partno='1061705876-01-C' and brandshort='ATGBICS' limit 1 [ RunTime:0.059703s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1061705876-01-C' OR `brand` LIKE 'ATGBICS%' ) ) LIMIT 1 [ RunTime:0.028162s ]
SELECT `id` FROM `stock` WHERE `id` <> 58143606 AND `partno` = '1061705876-01-C' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%atgbics%' ) [ RunTime:0.022425s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12223915 [ RunTime:0.008686s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58143655 LIMIT 5 [ RunTime:0.018874s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58143655 ORDER BY `minOrder` ASC [ RunTime:0.031543s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58143655 ORDER BY `unit` DESC [ RunTime:0.055383s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58143655 LIMIT 2 [ RunTime:0.042596s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58143655 ORDER BY `minOrder` ASC [ RunTime:0.009273s ]
select * from pdf where partno='1061705877-01-C' and brandshort='ATGBICS' limit 1 [ RunTime:0.029818s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1061705877-01-C' OR `brand` LIKE 'ATGBICS%' ) ) LIMIT 1 [ RunTime:0.032110s ]
SELECT `id` FROM `stock` WHERE `id` <> 58143655 AND `partno` = '1061705877-01-C' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%atgbics%' ) [ RunTime:0.006673s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11225070 [ RunTime:0.014859s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58144844 LIMIT 5 [ RunTime:0.018237s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58144844 ORDER BY `minOrder` ASC [ RunTime:0.012903s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58144844 ORDER BY `unit` DESC [ RunTime:0.017457s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58144844 LIMIT 2 [ RunTime:0.034492s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58144844 ORDER BY `minOrder` ASC [ RunTime:0.013796s ]
select * from pdf where partno='1061705874-01-C' and brandshort='ATGBICS' limit 1 [ RunTime:0.015368s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1061705874-01-C' OR `brand` LIKE 'ATGBICS%' ) ) LIMIT 1 [ RunTime:0.009763s ]
SELECT `id` FROM `stock` WHERE `id` <> 58144844 AND `partno` = '1061705874-01-C' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%atgbics%' ) [ RunTime:0.026987s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12224604 [ RunTime:0.024358s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64804998 LIMIT 5 [ RunTime:0.012162s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64804998 ORDER BY `minOrder` ASC [ RunTime:0.015291s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64804998 ORDER BY `unit` DESC [ RunTime:0.012585s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64804998 LIMIT 2 [ RunTime:0.024243s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64804998 ORDER BY `minOrder` ASC [ RunTime:0.004478s ]
select * from pdf where partno='1061705' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.009206s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1061705' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.016065s ]
SELECT `id` FROM `stock` WHERE `id` <> 64804998 AND `partno` = '1061705' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.018585s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18773604 [ RunTime:0.017889s ]
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 '1061705%' OR `brand` LIKE '1061705%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.014801s ]
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 '1061705%' OR `brand` LIKE '1061705%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.016557s ]
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 '1061705%' OR `brand` LIKE '1061705%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001316s ]
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 '1061705%' OR `brand` LIKE '1061705%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.016610s ]
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 '1061705%' OR `brand` LIKE '1061705%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001990s ]
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 '1061705%' OR `brand` LIKE '1061705%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.006975s ]
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 '1061705%' OR `brand` LIKE '1061705%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001003s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '1061705%' OR `brand` LIKE '1061705%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.008052s ]