SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002023s ]
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 'MMT-125-02-S-DH-A%' OR `brand` LIKE 'MMT-125-02-S-DH-A%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.015545s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.007008s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12762203 LIMIT 5 [ RunTime:0.020686s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.005146s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12762203 ORDER BY `minOrder` ASC [ RunTime:0.040266s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.005671s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12762203 ORDER BY `unit` DESC [ RunTime:0.028795s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.010316s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12762203 LIMIT 2 [ RunTime:0.029187s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12762203 ORDER BY `minOrder` ASC [ RunTime:0.009359s ]
select * from pdf where partno='MMT-125-02-S-DH-A-026' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.025882s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12762202 LIMIT 5 [ RunTime:0.064724s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12762202 ORDER BY `minOrder` ASC [ RunTime:0.038395s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12762202 ORDER BY `unit` DESC [ RunTime:0.033522s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12762202 LIMIT 2 [ RunTime:0.048038s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12762202 ORDER BY `minOrder` ASC [ RunTime:0.017291s ]
select * from pdf where partno='MMT-125-02-S-DH-A-025' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.030233s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11588147 LIMIT 5 [ RunTime:0.030029s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11588147 ORDER BY `minOrder` ASC [ RunTime:0.016277s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11588147 ORDER BY `unit` DESC [ RunTime:0.033897s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11588147 LIMIT 2 [ RunTime:0.041151s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11588147 ORDER BY `minOrder` ASC [ RunTime:0.062894s ]
select * from pdf where partno='MMT-125-02-S-DH-A-027' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.029481s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11588026 LIMIT 5 [ RunTime:0.041237s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11588026 ORDER BY `minOrder` ASC [ RunTime:0.044843s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11588026 ORDER BY `unit` DESC [ RunTime:0.004317s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11588026 LIMIT 2 [ RunTime:0.009527s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11588026 ORDER BY `minOrder` ASC [ RunTime:0.047660s ]
select * from pdf where partno='MMT-125-02-S-DH-A' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.066480s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11582872 LIMIT 5 [ RunTime:0.033456s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11582872 ORDER BY `minOrder` ASC [ RunTime:0.034961s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11582872 ORDER BY `unit` DESC [ RunTime:0.029307s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11582872 LIMIT 2 [ RunTime:0.039559s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11582872 ORDER BY `minOrder` ASC [ RunTime:0.040109s ]
select * from pdf where partno='MMT-125-02-S-DH-A-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.026225s ]
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 'MMT-125-02-S-DH-A%' OR `brand` LIKE 'MMT-125-02-S-DH-A%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.031616s ]
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 'MMT-125-02-S-DH-A%' OR `brand` LIKE 'MMT-125-02-S-DH-A%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.050130s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59728836 LIMIT 5 [ RunTime:0.013483s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59728836 ORDER BY `minOrder` ASC [ RunTime:0.039600s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59728836 ORDER BY `unit` DESC [ RunTime:0.029722s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59728836 LIMIT 2 [ RunTime:0.052693s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59728836 ORDER BY `minOrder` ASC [ RunTime:0.001675s ]
select * from pdf where partno='MMT-125-02-S-DH-A-027' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.009327s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002345s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MMT-125-02-S-DH-A-027' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.016533s ]
SELECT `id` FROM `stock` WHERE `id` <> 59728836 AND `partno` = 'MMT-125-02-S-DH-A-027' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.030962s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11588147 [ RunTime:0.018384s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59728835 LIMIT 5 [ RunTime:0.019239s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59728835 ORDER BY `minOrder` ASC [ RunTime:0.007663s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59728835 ORDER BY `unit` DESC [ RunTime:0.034422s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59728835 LIMIT 2 [ RunTime:0.008711s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59728835 ORDER BY `minOrder` ASC [ RunTime:0.012467s ]
select * from pdf where partno='MMT-125-02-S-DH-A-026' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.014826s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MMT-125-02-S-DH-A-026' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.024194s ]
SELECT `id` FROM `stock` WHERE `id` <> 59728835 AND `partno` = 'MMT-125-02-S-DH-A-026' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.011535s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12762203 [ RunTime:0.024139s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59728834 LIMIT 5 [ RunTime:0.014315s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59728834 ORDER BY `minOrder` ASC [ RunTime:0.046602s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59728834 ORDER BY `unit` DESC [ RunTime:0.053543s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59728834 LIMIT 2 [ RunTime:0.011777s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59728834 ORDER BY `minOrder` ASC [ RunTime:0.009568s ]
select * from pdf where partno='MMT-125-02-S-DH-A-025' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.011268s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MMT-125-02-S-DH-A-025' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.027684s ]
SELECT `id` FROM `stock` WHERE `id` <> 59728834 AND `partno` = 'MMT-125-02-S-DH-A-025' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.016329s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12762202 [ RunTime:0.030425s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59728430 LIMIT 5 [ RunTime:0.016378s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59728430 ORDER BY `minOrder` ASC [ RunTime:0.034293s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59728430 ORDER BY `unit` DESC [ RunTime:0.050633s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59728430 LIMIT 2 [ RunTime:0.038758s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59728430 ORDER BY `minOrder` ASC [ RunTime:0.018490s ]
select * from pdf where partno='MMT-125-02-S-DH-A' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.013015s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MMT-125-02-S-DH-A' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.030573s ]
SELECT `id` FROM `stock` WHERE `id` <> 59728430 AND `partno` = 'MMT-125-02-S-DH-A' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.040410s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11588026 [ RunTime:0.031806s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59728052 LIMIT 5 [ RunTime:0.021826s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59728052 ORDER BY `minOrder` ASC [ RunTime:0.039334s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59728052 ORDER BY `unit` DESC [ RunTime:0.104473s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59728052 LIMIT 2 [ RunTime:0.029164s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59728052 ORDER BY `minOrder` ASC [ RunTime:0.083568s ]
select * from pdf where partno='MMT-125-02-S-DH-A-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.017735s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MMT-125-02-S-DH-A-TR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.040892s ]
SELECT `id` FROM `stock` WHERE `id` <> 59728052 AND `partno` = 'MMT-125-02-S-DH-A-TR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.059454s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11582872 [ RunTime:0.061921s ]
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 'MMT-125-02-S-DH-A%' OR `brand` LIKE 'MMT-125-02-S-DH-A%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.024845s ]
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 'MMT-125-02-S-DH-A%' OR `brand` LIKE 'MMT-125-02-S-DH-A%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.053246s ]
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 'MMT-125-02-S-DH-A%' OR `brand` LIKE 'MMT-125-02-S-DH-A%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.066628s ]
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 'MMT-125-02-S-DH-A%' OR `brand` LIKE 'MMT-125-02-S-DH-A%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.089174s ]
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 'MMT-125-02-S-DH-A%' OR `brand` LIKE 'MMT-125-02-S-DH-A%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.037102s ]
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 'MMT-125-02-S-DH-A%' OR `brand` LIKE 'MMT-125-02-S-DH-A%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.022182s ]
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 'MMT-125-02-S-DH-A%' OR `brand` LIKE 'MMT-125-02-S-DH-A%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.063559s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'MMT-125-02-S-DH-A%' OR `brand` LIKE 'MMT-125-02-S-DH-A%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.015102s ]