SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002578s ]
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 'EHF-113-01-F-D-SM-LC%' OR `brand` LIKE 'EHF-113-01-F-D-SM-LC%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.018093s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001086s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19841402 LIMIT 5 [ RunTime:0.017015s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001782s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19841402 ORDER BY `minOrder` ASC [ RunTime:0.016417s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.001599s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19841402 ORDER BY `unit` DESC [ RunTime:0.017668s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.000947s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19841402 LIMIT 2 [ RunTime:0.019194s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19841402 ORDER BY `minOrder` ASC [ RunTime:0.001179s ]
select * from pdf where partno='EHF-113-01-F-D-SM-LC' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.012582s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12761534 LIMIT 5 [ RunTime:0.009143s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12761534 ORDER BY `minOrder` ASC [ RunTime:0.014965s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12761534 ORDER BY `unit` DESC [ RunTime:0.009331s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12761534 LIMIT 2 [ RunTime:0.005556s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12761534 ORDER BY `minOrder` ASC [ RunTime:0.009556s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12760990 LIMIT 5 [ RunTime:0.011856s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12760990 ORDER BY `minOrder` ASC [ RunTime:0.036376s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12760990 ORDER BY `unit` DESC [ RunTime:0.002669s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12760990 LIMIT 2 [ RunTime:0.024854s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12760990 ORDER BY `minOrder` ASC [ RunTime:0.009592s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12744906 LIMIT 5 [ RunTime:0.035393s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12744906 ORDER BY `minOrder` ASC [ RunTime:0.068381s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12744906 ORDER BY `unit` DESC [ RunTime:0.061698s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12744906 LIMIT 2 [ RunTime:0.036643s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12744906 ORDER BY `minOrder` ASC [ RunTime:0.034183s ]
select * from pdf where partno='EHF-113-01-F-D-SM-LC-01-P' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.038205s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12743593 LIMIT 5 [ RunTime:0.026163s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12743593 ORDER BY `minOrder` ASC [ RunTime:0.052068s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12743593 ORDER BY `unit` DESC [ RunTime:0.038430s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12743593 LIMIT 2 [ RunTime:0.012243s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12743593 ORDER BY `minOrder` ASC [ RunTime:0.000538s ]
select * from pdf where partno='EHF-113-01-F-D-SM-LC-K' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.028504s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11587611 LIMIT 5 [ RunTime:0.034842s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11587611 ORDER BY `minOrder` ASC [ RunTime:0.043009s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11587611 ORDER BY `unit` DESC [ RunTime:0.014847s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11587611 LIMIT 2 [ RunTime:0.028336s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11587611 ORDER BY `minOrder` ASC [ RunTime:0.012494s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11587610 LIMIT 5 [ RunTime:0.004348s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11587610 ORDER BY `minOrder` ASC [ RunTime:0.035896s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11587610 ORDER BY `unit` DESC [ RunTime:0.009641s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11587610 LIMIT 2 [ RunTime:0.019216s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11587610 ORDER BY `minOrder` ASC [ RunTime:0.021375s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11574373 LIMIT 5 [ RunTime:0.013689s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11574373 ORDER BY `minOrder` ASC [ RunTime:0.006160s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11574373 ORDER BY `unit` DESC [ RunTime:0.011006s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11574373 LIMIT 2 [ RunTime:0.003355s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11574373 ORDER BY `minOrder` ASC [ RunTime:0.001689s ]
select * from pdf where partno='EHF-113-01-F-D-SM-LC-01' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.003692s ]
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 'EHF-113-01-F-D-SM-LC%' OR `brand` LIKE 'EHF-113-01-F-D-SM-LC%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.012855s ]
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 'EHF-113-01-F-D-SM-LC%' OR `brand` LIKE 'EHF-113-01-F-D-SM-LC%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.005564s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59435297 LIMIT 5 [ RunTime:0.002897s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59435297 ORDER BY `minOrder` ASC [ RunTime:0.003360s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59435297 ORDER BY `unit` DESC [ RunTime:0.003129s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59435297 LIMIT 2 [ RunTime:0.002390s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59435297 ORDER BY `minOrder` ASC [ RunTime:0.005961s ]
select * from pdf where partno='EHF-113-01-F-D-SM-LC' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.003051s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001937s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'EHF-113-01-F-D-SM-LC' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.009231s ]
SELECT `id` FROM `stock` WHERE `id` <> 59435297 AND `partno` = 'EHF-113-01-F-D-SM-LC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.016073s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19841402 [ RunTime:0.000499s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59730981 LIMIT 5 [ RunTime:0.012549s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59730981 ORDER BY `minOrder` ASC [ RunTime:0.005382s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59730981 ORDER BY `unit` DESC [ RunTime:0.003039s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59730981 LIMIT 2 [ RunTime:0.000437s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59730981 ORDER BY `minOrder` ASC [ RunTime:0.008817s ]
select * from pdf where partno='EHF-113-01-F-D-SM-LC-02' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.012040s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'EHF-113-01-F-D-SM-LC-02' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.012483s ]
SELECT `id` FROM `stock` WHERE `id` <> 59730981 AND `partno` = 'EHF-113-01-F-D-SM-LC-02' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.029995s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11587611 [ RunTime:0.001521s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59730980 LIMIT 5 [ RunTime:0.008243s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59730980 ORDER BY `minOrder` ASC [ RunTime:0.002387s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59730980 ORDER BY `unit` DESC [ RunTime:0.000669s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59730980 LIMIT 2 [ RunTime:0.008036s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59730980 ORDER BY `minOrder` ASC [ RunTime:0.008214s ]
select * from pdf where partno='EHF-113-01-F-D-SM-LC-10' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.004281s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'EHF-113-01-F-D-SM-LC-10' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.002008s ]
SELECT `id` FROM `stock` WHERE `id` <> 59730980 AND `partno` = 'EHF-113-01-F-D-SM-LC-10' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.006422s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12761534 [ RunTime:0.002550s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59729650 LIMIT 5 [ RunTime:0.000641s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59729650 ORDER BY `minOrder` ASC [ RunTime:0.005263s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59729650 ORDER BY `unit` DESC [ RunTime:0.000702s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59729650 LIMIT 2 [ RunTime:0.000584s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59729650 ORDER BY `minOrder` ASC [ RunTime:0.002657s ]
select * from pdf where partno='EHF-113-01-F-D-SM-LC-26' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.008515s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'EHF-113-01-F-D-SM-LC-26' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.000843s ]
SELECT `id` FROM `stock` WHERE `id` <> 59729650 AND `partno` = 'EHF-113-01-F-D-SM-LC-26' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.001097s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12760990 [ RunTime:0.011053s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59727280 LIMIT 5 [ RunTime:0.002537s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59727280 ORDER BY `minOrder` ASC [ RunTime:0.002497s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59727280 ORDER BY `unit` DESC [ RunTime:0.000847s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59727280 LIMIT 2 [ RunTime:0.000618s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59727280 ORDER BY `minOrder` ASC [ RunTime:0.000447s ]
select * from pdf where partno='EHF-113-01-F-D-SM-LC-04' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.004105s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'EHF-113-01-F-D-SM-LC-04' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.000814s ]
SELECT `id` FROM `stock` WHERE `id` <> 59727280 AND `partno` = 'EHF-113-01-F-D-SM-LC-04' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.004882s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11587610 [ RunTime:0.001561s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59702746 LIMIT 5 [ RunTime:0.011190s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59702746 ORDER BY `minOrder` ASC [ RunTime:0.002949s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59702746 ORDER BY `unit` DESC [ RunTime:0.000699s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59702746 LIMIT 2 [ RunTime:0.000628s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59702746 ORDER BY `minOrder` ASC [ RunTime:0.001465s ]
select * from pdf where partno='EHF-113-01-F-D-SM-LC-01-P' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.000787s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'EHF-113-01-F-D-SM-LC-01-P' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.000803s ]
SELECT `id` FROM `stock` WHERE `id` <> 59702746 AND `partno` = 'EHF-113-01-F-D-SM-LC-01-P' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.004578s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12744906 [ RunTime:0.000739s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59701267 LIMIT 5 [ RunTime:0.004702s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59701267 ORDER BY `minOrder` ASC [ RunTime:0.006964s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59701267 ORDER BY `unit` DESC [ RunTime:0.000788s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59701267 LIMIT 2 [ RunTime:0.000639s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59701267 ORDER BY `minOrder` ASC [ RunTime:0.000465s ]
select * from pdf where partno='EHF-113-01-F-D-SM-LC-P' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.003908s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'EHF-113-01-F-D-SM-LC-P' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.001770s ]
SELECT `id` FROM `stock` WHERE `id` <> 59701267 AND `partno` = 'EHF-113-01-F-D-SM-LC-P' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.003364s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59700354 LIMIT 5 [ RunTime:0.000673s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59700354 ORDER BY `minOrder` ASC [ RunTime:0.001751s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59700354 ORDER BY `unit` DESC [ RunTime:0.000904s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59700354 LIMIT 2 [ RunTime:0.001045s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59700354 ORDER BY `minOrder` ASC [ RunTime:0.000468s ]
select * from pdf where partno='EHF-113-01-F-D-SM-LC-01' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.000633s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'EHF-113-01-F-D-SM-LC-01' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.001533s ]
SELECT `id` FROM `stock` WHERE `id` <> 59700354 AND `partno` = 'EHF-113-01-F-D-SM-LC-01' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.001269s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11574373 [ RunTime:0.005958s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59700121 LIMIT 5 [ RunTime:0.004654s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59700121 ORDER BY `minOrder` ASC [ RunTime:0.005265s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59700121 ORDER BY `unit` DESC [ RunTime:0.005815s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59700121 LIMIT 2 [ RunTime:0.001988s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59700121 ORDER BY `minOrder` ASC [ RunTime:0.003118s ]
select * from pdf where partno='EHF-113-01-F-D-SM-LC-K' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.000735s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'EHF-113-01-F-D-SM-LC-K' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.000849s ]
SELECT `id` FROM `stock` WHERE `id` <> 59700121 AND `partno` = 'EHF-113-01-F-D-SM-LC-K' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.010657s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12743593 [ RunTime:0.006306s ]
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 'EHF-113-01-F-D-SM-LC%' OR `brand` LIKE 'EHF-113-01-F-D-SM-LC%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001541s ]
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 'EHF-113-01-F-D-SM-LC%' OR `brand` LIKE 'EHF-113-01-F-D-SM-LC%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001166s ]
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 'EHF-113-01-F-D-SM-LC%' OR `brand` LIKE 'EHF-113-01-F-D-SM-LC%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.005895s ]
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 'EHF-113-01-F-D-SM-LC%' OR `brand` LIKE 'EHF-113-01-F-D-SM-LC%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.010694s ]
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 'EHF-113-01-F-D-SM-LC%' OR `brand` LIKE 'EHF-113-01-F-D-SM-LC%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002839s ]
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 'EHF-113-01-F-D-SM-LC%' OR `brand` LIKE 'EHF-113-01-F-D-SM-LC%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001215s ]
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 'EHF-113-01-F-D-SM-LC%' OR `brand` LIKE 'EHF-113-01-F-D-SM-LC%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.004952s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'EHF-113-01-F-D-SM-LC%' OR `brand` LIKE 'EHF-113-01-F-D-SM-LC%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.002656s ]