SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001361s ]
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 '02131%' OR `brand` LIKE '02131%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.037380s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.002820s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13814565 LIMIT 5 [ RunTime:0.081764s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.004108s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13814565 ORDER BY `minOrder` ASC [ RunTime:0.035285s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.002536s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13814565 ORDER BY `unit` DESC [ RunTime:0.049443s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.063333s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13814565 LIMIT 2 [ RunTime:0.091015s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13814565 ORDER BY `minOrder` ASC [ RunTime:0.084808s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16628324 LIMIT 5 [ RunTime:0.046575s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16628324 ORDER BY `minOrder` ASC [ RunTime:0.037296s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16628324 ORDER BY `unit` DESC [ RunTime:0.087921s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16628324 LIMIT 2 [ RunTime:0.064036s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16628324 ORDER BY `minOrder` ASC [ RunTime:0.037347s ]
select * from pdf where partno='02131.25MXBP' and brandshort='Littelfuse Inc.' limit 1 [ RunTime:0.032422s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14706010 LIMIT 5 [ RunTime:0.029801s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14706010 ORDER BY `minOrder` ASC [ RunTime:0.120499s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14706010 ORDER BY `unit` DESC [ RunTime:0.017695s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14706010 LIMIT 2 [ RunTime:0.077775s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14706010 ORDER BY `minOrder` ASC [ RunTime:0.028394s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14702688 LIMIT 5 [ RunTime:0.056332s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14702688 ORDER BY `minOrder` ASC [ RunTime:0.056453s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14702688 ORDER BY `unit` DESC [ RunTime:0.099054s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14702688 LIMIT 2 [ RunTime:0.031283s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14702688 ORDER BY `minOrder` ASC [ RunTime:0.014456s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13815269 LIMIT 5 [ RunTime:0.132737s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13815269 ORDER BY `minOrder` ASC [ RunTime:0.075952s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13815269 ORDER BY `unit` DESC [ RunTime:0.095330s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13815269 LIMIT 2 [ RunTime:0.044751s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13815269 ORDER BY `minOrder` ASC [ RunTime:0.040313s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13815195 LIMIT 5 [ RunTime:0.058181s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13815195 ORDER BY `minOrder` ASC [ RunTime:0.132855s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13815195 ORDER BY `unit` DESC [ RunTime:0.092478s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13815195 LIMIT 2 [ RunTime:0.088233s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13815195 ORDER BY `minOrder` ASC [ RunTime:0.103273s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13812652 LIMIT 5 [ RunTime:0.064897s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13812652 ORDER BY `minOrder` ASC [ RunTime:0.051160s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13812652 ORDER BY `unit` DESC [ RunTime:0.053316s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13812652 LIMIT 2 [ RunTime:0.094231s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13812652 ORDER BY `minOrder` ASC [ RunTime:0.073814s ]
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 '02131%' OR `brand` LIKE '02131%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.021608s ]
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 '02131%' OR `brand` LIKE '02131%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.089981s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58188255 LIMIT 5 [ RunTime:0.098471s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58188255 ORDER BY `minOrder` ASC [ RunTime:0.086808s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58188255 ORDER BY `unit` DESC [ RunTime:0.056774s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58188255 LIMIT 2 [ RunTime:0.033796s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58188255 ORDER BY `minOrder` ASC [ RunTime:0.028133s ]
select * from pdf where partno='02131.25MXP' and brandshort='Littelfuse Inc.' limit 1 [ RunTime:0.047118s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002560s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '02131.25MXP' OR `brand` LIKE 'Littelfuse Inc.%' ) ) LIMIT 1 [ RunTime:0.086692s ]
SELECT `id` FROM `stock` WHERE `id` <> 58188255 AND `partno` = '02131.25MXP' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%littelfuse inc.%' ) [ RunTime:0.089669s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13814565 [ RunTime:0.011904s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58196490 LIMIT 5 [ RunTime:0.052657s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58196490 ORDER BY `minOrder` ASC [ RunTime:0.028351s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58196490 ORDER BY `unit` DESC [ RunTime:0.085184s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58196490 LIMIT 2 [ RunTime:0.032246s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58196490 ORDER BY `minOrder` ASC [ RunTime:0.051676s ]
select * from pdf where partno='02131.25TXP' and brandshort='Littelfuse Inc.' limit 1 [ RunTime:0.104347s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '02131.25TXP' OR `brand` LIKE 'Littelfuse Inc.%' ) ) LIMIT 1 [ RunTime:0.158951s ]
SELECT `id` FROM `stock` WHERE `id` <> 58196490 AND `partno` = '02131.25TXP' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%littelfuse inc.%' ) [ RunTime:0.156657s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14706010 [ RunTime:0.108556s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58196347 LIMIT 5 [ RunTime:0.067974s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58196347 ORDER BY `minOrder` ASC [ RunTime:0.082539s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58196347 ORDER BY `unit` DESC [ RunTime:0.049358s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58196347 LIMIT 2 [ RunTime:0.043380s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58196347 ORDER BY `minOrder` ASC [ RunTime:0.009586s ]
select * from pdf where partno='02131.25MXEP' and brandshort='Littelfuse Inc.' limit 1 [ RunTime:0.077150s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '02131.25MXEP' OR `brand` LIKE 'Littelfuse Inc.%' ) ) LIMIT 1 [ RunTime:0.027551s ]
SELECT `id` FROM `stock` WHERE `id` <> 58196347 AND `partno` = '02131.25MXEP' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%littelfuse inc.%' ) [ RunTime:0.092781s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13815269 [ RunTime:0.110044s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58196124 LIMIT 5 [ RunTime:0.041177s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58196124 ORDER BY `minOrder` ASC [ RunTime:0.113695s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58196124 ORDER BY `unit` DESC [ RunTime:0.060465s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58196124 LIMIT 2 [ RunTime:0.215472s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58196124 ORDER BY `minOrder` ASC [ RunTime:0.047469s ]
select * from pdf where partno='02131.25MRET1P' and brandshort='Littelfuse Inc.' limit 1 [ RunTime:0.136708s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '02131.25MRET1P' OR `brand` LIKE 'Littelfuse Inc.%' ) ) LIMIT 1 [ RunTime:0.055507s ]
SELECT `id` FROM `stock` WHERE `id` <> 58196124 AND `partno` = '02131.25MRET1P' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%littelfuse inc.%' ) [ RunTime:0.072143s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13815195 [ RunTime:0.129604s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58194060 LIMIT 5 [ RunTime:0.026786s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58194060 ORDER BY `minOrder` ASC [ RunTime:0.071909s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58194060 ORDER BY `unit` DESC [ RunTime:0.055209s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58194060 LIMIT 2 [ RunTime:0.258236s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58194060 ORDER BY `minOrder` ASC [ RunTime:0.100182s ]
select * from pdf where partno='02131.25MXBP' and brandshort='Littelfuse Inc.' limit 1 [ RunTime:0.027855s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '02131.25MXBP' OR `brand` LIKE 'Littelfuse Inc.%' ) ) LIMIT 1 [ RunTime:0.032414s ]
SELECT `id` FROM `stock` WHERE `id` <> 58194060 AND `partno` = '02131.25MXBP' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%littelfuse inc.%' ) [ RunTime:0.076857s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16628324 [ RunTime:0.160111s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32543996 LIMIT 5 [ RunTime:0.051561s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32543996 ORDER BY `minOrder` ASC [ RunTime:0.122841s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32543996 ORDER BY `unit` DESC [ RunTime:0.050820s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32543996 LIMIT 2 [ RunTime:0.206931s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32543996 ORDER BY `minOrder` ASC [ RunTime:0.077085s ]
select * from pdf where partno='02131' and brandshort='Greenlee Communications' limit 1 [ RunTime:0.045638s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '02131' OR `brand` LIKE 'Greenlee Communications%' ) ) LIMIT 1 [ RunTime:0.087438s ]
SELECT `id` FROM `stock` WHERE `id` <> 32543996 AND `partno` = '02131' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%greenlee communications%' ) [ RunTime:0.096316s ]
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 '02131%' OR `brand` LIKE '02131%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.122120s ]
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 '02131%' OR `brand` LIKE '02131%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.176950s ]
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 '02131%' OR `brand` LIKE '02131%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.074628s ]
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 '02131%' OR `brand` LIKE '02131%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.035409s ]
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 '02131%' OR `brand` LIKE '02131%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.055770s ]
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 '02131%' OR `brand` LIKE '02131%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.054022s ]
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 '02131%' OR `brand` LIKE '02131%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.067903s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '02131%' OR `brand` LIKE '02131%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.128133s ]