SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002797s ]
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 'TMM-120-06-G-D-SM-A%' OR `brand` LIKE 'TMM-120-06-G-D-SM-A%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.022211s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.011550s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19812070 LIMIT 5 [ RunTime:0.008812s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.008561s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19812070 ORDER BY `minOrder` ASC [ RunTime:0.005499s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.004265s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19812070 ORDER BY `unit` DESC [ RunTime:0.009899s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.003229s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19812070 LIMIT 2 [ RunTime:0.018141s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19812070 ORDER BY `minOrder` ASC [ RunTime:0.024846s ]
select * from pdf where partno='TMM-120-06-G-D-SM-A-P-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.039867s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19811363 LIMIT 5 [ RunTime:0.057567s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19811363 ORDER BY `minOrder` ASC [ RunTime:0.030734s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19811363 ORDER BY `unit` DESC [ RunTime:0.024468s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19811363 LIMIT 2 [ RunTime:0.021009s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19811363 ORDER BY `minOrder` ASC [ RunTime:0.021134s ]
select * from pdf where partno='TMM-120-06-G-D-SM-A-M-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.006965s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12743920 LIMIT 5 [ RunTime:0.027889s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12743920 ORDER BY `minOrder` ASC [ RunTime:0.018317s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12743920 ORDER BY `unit` DESC [ RunTime:0.025262s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12743920 LIMIT 2 [ RunTime:0.011411s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12743920 ORDER BY `minOrder` ASC [ RunTime:0.017570s ]
select * from pdf where partno='TMM-120-06-G-D-SM-A' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.019278s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11575393 LIMIT 5 [ RunTime:0.015912s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11575393 ORDER BY `minOrder` ASC [ RunTime:0.016659s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11575393 ORDER BY `unit` DESC [ RunTime:0.014709s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11575393 LIMIT 2 [ RunTime:0.014573s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11575393 ORDER BY `minOrder` ASC [ RunTime:0.021086s ]
select * from pdf where partno='TMM-120-06-G-D-SM-A-P' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.024157s ]
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 'TMM-120-06-G-D-SM-A%' OR `brand` LIKE 'TMM-120-06-G-D-SM-A%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.042004s ]
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 'TMM-120-06-G-D-SM-A%' OR `brand` LIKE 'TMM-120-06-G-D-SM-A%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.023459s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59702763 LIMIT 5 [ RunTime:0.006191s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59702763 ORDER BY `minOrder` ASC [ RunTime:0.022350s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59702763 ORDER BY `unit` DESC [ RunTime:0.046574s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59702763 LIMIT 2 [ RunTime:0.036363s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59702763 ORDER BY `minOrder` ASC [ RunTime:0.021823s ]
select * from pdf where partno='TMM-120-06-G-D-SM-A-P' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.003588s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002453s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TMM-120-06-G-D-SM-A-P' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.024111s ]
SELECT `id` FROM `stock` WHERE `id` <> 59702763 AND `partno` = 'TMM-120-06-G-D-SM-A-P' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.017276s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11575393 [ RunTime:0.013136s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59700565 LIMIT 5 [ RunTime:0.021173s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59700565 ORDER BY `minOrder` ASC [ RunTime:0.005638s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59700565 ORDER BY `unit` DESC [ RunTime:0.004186s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59700565 LIMIT 2 [ RunTime:0.005364s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59700565 ORDER BY `minOrder` ASC [ RunTime:0.006549s ]
select * from pdf where partno='TMM-120-06-G-D-SM-A' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.000584s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TMM-120-06-G-D-SM-A' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.003359s ]
SELECT `id` FROM `stock` WHERE `id` <> 59700565 AND `partno` = 'TMM-120-06-G-D-SM-A' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.020091s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12743920 [ RunTime:0.003179s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59697035 LIMIT 5 [ RunTime:0.008727s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59697035 ORDER BY `minOrder` ASC [ RunTime:0.018921s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59697035 ORDER BY `unit` DESC [ RunTime:0.000797s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59697035 LIMIT 2 [ RunTime:0.009001s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59697035 ORDER BY `minOrder` ASC [ RunTime:0.002432s ]
select * from pdf where partno='TMM-120-06-G-D-SM-A-P-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.000588s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TMM-120-06-G-D-SM-A-P-TR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.000920s ]
SELECT `id` FROM `stock` WHERE `id` <> 59697035 AND `partno` = 'TMM-120-06-G-D-SM-A-P-TR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.003912s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19812070 [ RunTime:0.007048s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59696174 LIMIT 5 [ RunTime:0.006481s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59696174 ORDER BY `minOrder` ASC [ RunTime:0.006911s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59696174 ORDER BY `unit` DESC [ RunTime:0.007805s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59696174 LIMIT 2 [ RunTime:0.000766s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59696174 ORDER BY `minOrder` ASC [ RunTime:0.000575s ]
select * from pdf where partno='TMM-120-06-G-D-SM-A-M-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.000665s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TMM-120-06-G-D-SM-A-M-TR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.000923s ]
SELECT `id` FROM `stock` WHERE `id` <> 59696174 AND `partno` = 'TMM-120-06-G-D-SM-A-M-TR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.007856s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19811363 [ RunTime:0.006898s ]
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 'TMM-120-06-G-D-SM-A%' OR `brand` LIKE 'TMM-120-06-G-D-SM-A%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001515s ]
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 'TMM-120-06-G-D-SM-A%' OR `brand` LIKE 'TMM-120-06-G-D-SM-A%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.010237s ]
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 'TMM-120-06-G-D-SM-A%' OR `brand` LIKE 'TMM-120-06-G-D-SM-A%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.015090s ]
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 'TMM-120-06-G-D-SM-A%' OR `brand` LIKE 'TMM-120-06-G-D-SM-A%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001721s ]
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 'TMM-120-06-G-D-SM-A%' OR `brand` LIKE 'TMM-120-06-G-D-SM-A%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003915s ]
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 'TMM-120-06-G-D-SM-A%' OR `brand` LIKE 'TMM-120-06-G-D-SM-A%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.014771s ]
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 'TMM-120-06-G-D-SM-A%' OR `brand` LIKE 'TMM-120-06-G-D-SM-A%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002701s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'TMM-120-06-G-D-SM-A%' OR `brand` LIKE 'TMM-120-06-G-D-SM-A%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.027269s ]