SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002471s ]
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 'TEM-125-02-07.0-H-D%' OR `brand` LIKE 'TEM-125-02-07.0-H-D%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.073131s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.002422s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15478224 LIMIT 5 [ RunTime:0.036509s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.034705s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15478224 ORDER BY `minOrder` ASC [ RunTime:0.051927s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.007954s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15478224 ORDER BY `unit` DESC [ RunTime:0.023656s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.003562s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15478224 LIMIT 2 [ RunTime:0.041512s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15478224 ORDER BY `minOrder` ASC [ RunTime:0.121114s ]
select * from pdf where partno='TEM-125-02-07.0-H-D-WT' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.098765s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12757275 LIMIT 5 [ RunTime:0.035822s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12757275 ORDER BY `minOrder` ASC [ RunTime:0.039723s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12757275 ORDER BY `unit` DESC [ RunTime:0.077884s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12757275 LIMIT 2 [ RunTime:0.138326s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12757275 ORDER BY `minOrder` ASC [ RunTime:0.027218s ]
select * from pdf where partno='TEM-125-02-07.0-H-D-A-K' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.056346s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12757007 LIMIT 5 [ RunTime:0.045620s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12757007 ORDER BY `minOrder` ASC [ RunTime:0.059695s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12757007 ORDER BY `unit` DESC [ RunTime:0.077756s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12757007 LIMIT 2 [ RunTime:0.083375s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12757007 ORDER BY `minOrder` ASC [ RunTime:0.063264s ]
select * from pdf where partno='TEM-125-02-07.0-H-D-A' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.022193s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12754209 LIMIT 5 [ RunTime:0.004956s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12754209 ORDER BY `minOrder` ASC [ RunTime:0.031724s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12754209 ORDER BY `unit` DESC [ RunTime:0.114924s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12754209 LIMIT 2 [ RunTime:0.050409s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12754209 ORDER BY `minOrder` ASC [ RunTime:0.039174s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12754208 LIMIT 5 [ RunTime:0.012101s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12754208 ORDER BY `minOrder` ASC [ RunTime:0.040725s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12754208 ORDER BY `unit` DESC [ RunTime:0.056347s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12754208 LIMIT 2 [ RunTime:0.004617s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12754208 ORDER BY `minOrder` ASC [ RunTime:0.014680s ]
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 'TEM-125-02-07.0-H-D%' OR `brand` LIKE 'TEM-125-02-07.0-H-D%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.048275s ]
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 'TEM-125-02-07.0-H-D%' OR `brand` LIKE 'TEM-125-02-07.0-H-D%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.056105s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59541834 LIMIT 5 [ RunTime:0.029465s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59541834 ORDER BY `minOrder` ASC [ RunTime:0.041447s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59541834 ORDER BY `unit` DESC [ RunTime:0.025226s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59541834 LIMIT 2 [ RunTime:0.057345s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59541834 ORDER BY `minOrder` ASC [ RunTime:0.014144s ]
select * from pdf where partno='TEM-125-02-07.0-H-D-WT' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.005787s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002498s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TEM-125-02-07.0-H-D-WT' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.021816s ]
SELECT `id` FROM `stock` WHERE `id` <> 59541834 AND `partno` = 'TEM-125-02-07.0-H-D-WT' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.049591s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15478224 [ RunTime:0.032386s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59738946 LIMIT 5 [ RunTime:0.030189s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59738946 ORDER BY `minOrder` ASC [ RunTime:0.053470s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59738946 ORDER BY `unit` DESC [ RunTime:0.051756s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59738946 LIMIT 2 [ RunTime:0.061382s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59738946 ORDER BY `minOrder` ASC [ RunTime:0.107762s ]
select * from pdf where partno='TEM-125-02-07.0-H-D-WT-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.070758s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TEM-125-02-07.0-H-D-WT-TR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.001113s ]
SELECT `id` FROM `stock` WHERE `id` <> 59738946 AND `partno` = 'TEM-125-02-07.0-H-D-WT-TR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.088394s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59733687 LIMIT 5 [ RunTime:0.069549s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59733687 ORDER BY `minOrder` ASC [ RunTime:0.060760s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59733687 ORDER BY `unit` DESC [ RunTime:0.100276s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59733687 LIMIT 2 [ RunTime:0.051795s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59733687 ORDER BY `minOrder` ASC [ RunTime:0.012899s ]
select * from pdf where partno='TEM-125-02-07.0-H-D-WT-K' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.052298s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TEM-125-02-07.0-H-D-WT-K' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.053881s ]
SELECT `id` FROM `stock` WHERE `id` <> 59733687 AND `partno` = 'TEM-125-02-07.0-H-D-WT-K' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.092011s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59733527 LIMIT 5 [ RunTime:0.038496s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59733527 ORDER BY `minOrder` ASC [ RunTime:0.067137s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59733527 ORDER BY `unit` DESC [ RunTime:0.092087s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59733527 LIMIT 2 [ RunTime:0.020214s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59733527 ORDER BY `minOrder` ASC [ RunTime:0.043628s ]
select * from pdf where partno='TEM-125-02-07.0-H-D-A-K' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.014895s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TEM-125-02-07.0-H-D-A-K' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.025950s ]
SELECT `id` FROM `stock` WHERE `id` <> 59733527 AND `partno` = 'TEM-125-02-07.0-H-D-A-K' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.124523s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12757275 [ RunTime:0.010664s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59733123 LIMIT 5 [ RunTime:0.046267s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59733123 ORDER BY `minOrder` ASC [ RunTime:0.065305s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59733123 ORDER BY `unit` DESC [ RunTime:0.031357s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59733123 LIMIT 2 [ RunTime:0.031085s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59733123 ORDER BY `minOrder` ASC [ RunTime:0.036781s ]
select * from pdf where partno='TEM-125-02-07.0-H-D-A' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.014483s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TEM-125-02-07.0-H-D-A' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.028327s ]
SELECT `id` FROM `stock` WHERE `id` <> 59733123 AND `partno` = 'TEM-125-02-07.0-H-D-A' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.052532s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12757007 [ RunTime:0.055087s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59732388 LIMIT 5 [ RunTime:0.039207s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59732388 ORDER BY `minOrder` ASC [ RunTime:0.131996s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59732388 ORDER BY `unit` DESC [ RunTime:0.063282s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59732388 LIMIT 2 [ RunTime:0.025909s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59732388 ORDER BY `minOrder` ASC [ RunTime:0.030600s ]
select * from pdf where partno='TEM-125-02-07.0-H-D' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.033586s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TEM-125-02-07.0-H-D' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.039012s ]
SELECT `id` FROM `stock` WHERE `id` <> 59732388 AND `partno` = 'TEM-125-02-07.0-H-D' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.148390s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59725726 LIMIT 5 [ RunTime:0.062482s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59725726 ORDER BY `minOrder` ASC [ RunTime:0.034150s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59725726 ORDER BY `unit` DESC [ RunTime:0.023275s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59725726 LIMIT 2 [ RunTime:0.024062s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59725726 ORDER BY `minOrder` ASC [ RunTime:0.000319s ]
select * from pdf where partno='TEM-125-02-07.0-H-D-WT-K-FR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.056533s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TEM-125-02-07.0-H-D-WT-K-FR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.086202s ]
SELECT `id` FROM `stock` WHERE `id` <> 59725726 AND `partno` = 'TEM-125-02-07.0-H-D-WT-K-FR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.113554s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59725715 LIMIT 5 [ RunTime:0.059016s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59725715 ORDER BY `minOrder` ASC [ RunTime:0.090860s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59725715 ORDER BY `unit` DESC [ RunTime:0.076881s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59725715 LIMIT 2 [ RunTime:0.046643s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59725715 ORDER BY `minOrder` ASC [ RunTime:0.020248s ]
select * from pdf where partno='TEM-125-02-07.0-H-D-WT-K-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.034011s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TEM-125-02-07.0-H-D-WT-K-TR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.133184s ]
SELECT `id` FROM `stock` WHERE `id` <> 59725715 AND `partno` = 'TEM-125-02-07.0-H-D-WT-K-TR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.069156s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12754209 [ RunTime:0.047214s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59725714 LIMIT 5 [ RunTime:0.077402s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59725714 ORDER BY `minOrder` ASC [ RunTime:0.066453s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59725714 ORDER BY `unit` DESC [ RunTime:0.050976s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59725714 LIMIT 2 [ RunTime:0.082875s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59725714 ORDER BY `minOrder` ASC [ RunTime:0.056981s ]
select * from pdf where partno='TEM-125-02-07.0-H-D-A-K-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.042855s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TEM-125-02-07.0-H-D-A-K-TR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.158394s ]
SELECT `id` FROM `stock` WHERE `id` <> 59725714 AND `partno` = 'TEM-125-02-07.0-H-D-A-K-TR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.147559s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12754208 [ RunTime:0.044637s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59724716 LIMIT 5 [ RunTime:0.056880s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59724716 ORDER BY `minOrder` ASC [ RunTime:0.088453s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59724716 ORDER BY `unit` DESC [ RunTime:0.079528s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59724716 LIMIT 2 [ RunTime:0.046825s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59724716 ORDER BY `minOrder` ASC [ RunTime:0.051338s ]
select * from pdf where partno='TEM-125-02-07.0-H-D-K-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.042948s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TEM-125-02-07.0-H-D-K-TR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.024037s ]
SELECT `id` FROM `stock` WHERE `id` <> 59724716 AND `partno` = 'TEM-125-02-07.0-H-D-K-TR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.023315s ]
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 'TEM-125-02-07.0-H-D%' OR `brand` LIKE 'TEM-125-02-07.0-H-D%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.111781s ]
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 'TEM-125-02-07.0-H-D%' OR `brand` LIKE 'TEM-125-02-07.0-H-D%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.019556s ]
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 'TEM-125-02-07.0-H-D%' OR `brand` LIKE 'TEM-125-02-07.0-H-D%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.093993s ]
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 'TEM-125-02-07.0-H-D%' OR `brand` LIKE 'TEM-125-02-07.0-H-D%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.091427s ]
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 'TEM-125-02-07.0-H-D%' OR `brand` LIKE 'TEM-125-02-07.0-H-D%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.034362s ]
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 'TEM-125-02-07.0-H-D%' OR `brand` LIKE 'TEM-125-02-07.0-H-D%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.032933s ]
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 'TEM-125-02-07.0-H-D%' OR `brand` LIKE 'TEM-125-02-07.0-H-D%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.026796s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'TEM-125-02-07.0-H-D%' OR `brand` LIKE 'TEM-125-02-07.0-H-D%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.048592s ]