SHOW FULL COLUMNS FROM `stock` [ RunTime:0.003972s ]
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 'HMC30DRTN%' OR `brand` LIKE 'HMC30DRTN%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.077314s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.026470s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19971097 LIMIT 5 [ RunTime:0.126501s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.036514s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19971097 ORDER BY `minOrder` ASC [ RunTime:0.066520s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.006671s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19971097 ORDER BY `unit` DESC [ RunTime:0.021795s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.002368s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19971097 LIMIT 2 [ RunTime:0.028641s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19971097 ORDER BY `minOrder` ASC [ RunTime:0.019570s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19967869 LIMIT 5 [ RunTime:0.025701s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19967869 ORDER BY `minOrder` ASC [ RunTime:0.040977s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19967869 ORDER BY `unit` DESC [ RunTime:0.049546s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19967869 LIMIT 2 [ RunTime:0.095062s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19967869 ORDER BY `minOrder` ASC [ RunTime:0.082858s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16299421 LIMIT 5 [ RunTime:0.104304s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16299421 ORDER BY `minOrder` ASC [ RunTime:0.031024s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16299421 ORDER BY `unit` DESC [ RunTime:0.042368s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16299421 LIMIT 2 [ RunTime:0.044763s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16299421 ORDER BY `minOrder` ASC [ RunTime:0.024875s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16296269 LIMIT 5 [ RunTime:0.118803s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16296269 ORDER BY `minOrder` ASC [ RunTime:0.022841s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16296269 ORDER BY `unit` DESC [ RunTime:0.051464s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16296269 LIMIT 2 [ RunTime:0.150551s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16296269 ORDER BY `minOrder` ASC [ RunTime:0.034722s ]
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 'HMC30DRTN%' OR `brand` LIKE 'HMC30DRTN%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.075978s ]
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 'HMC30DRTN%' OR `brand` LIKE 'HMC30DRTN%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.074244s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59109286 LIMIT 5 [ RunTime:0.040731s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59109286 ORDER BY `minOrder` ASC [ RunTime:0.017294s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59109286 ORDER BY `unit` DESC [ RunTime:0.001612s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59109286 LIMIT 2 [ RunTime:0.018750s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59109286 ORDER BY `minOrder` ASC [ RunTime:0.004668s ]
select * from pdf where partno='HMC30DRTN-S13' and brandshort='Sullins Connector Solutions' limit 1 [ RunTime:0.003222s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002782s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'HMC30DRTN-S13' OR `brand` LIKE 'Sullins Connector Solutions%' ) ) LIMIT 1 [ RunTime:0.017014s ]
SELECT `id` FROM `stock` WHERE `id` <> 59109286 AND `partno` = 'HMC30DRTN-S13' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sullins connector solutions%' ) [ RunTime:0.007850s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19967869 [ RunTime:0.015808s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59107443 LIMIT 5 [ RunTime:0.014502s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59107443 ORDER BY `minOrder` ASC [ RunTime:0.006903s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59107443 ORDER BY `unit` DESC [ RunTime:0.003740s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59107443 LIMIT 2 [ RunTime:0.004328s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59107443 ORDER BY `minOrder` ASC [ RunTime:0.015215s ]
select * from pdf where partno='HMC30DRTN-S93' and brandshort='Sullins Connector Solutions' limit 1 [ RunTime:0.007702s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'HMC30DRTN-S93' OR `brand` LIKE 'Sullins Connector Solutions%' ) ) LIMIT 1 [ RunTime:0.007399s ]
SELECT `id` FROM `stock` WHERE `id` <> 59107443 AND `partno` = 'HMC30DRTN-S93' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sullins connector solutions%' ) [ RunTime:0.026530s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19971097 [ RunTime:0.022101s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59105269 LIMIT 5 [ RunTime:0.001939s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59105269 ORDER BY `minOrder` ASC [ RunTime:0.000367s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59105269 ORDER BY `unit` DESC [ RunTime:0.000326s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59105269 LIMIT 2 [ RunTime:0.001368s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59105269 ORDER BY `minOrder` ASC [ RunTime:0.007061s ]
select * from pdf where partno='HMC30DRTN-S734' and brandshort='Sullins Connector Solutions' limit 1 [ RunTime:0.000556s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'HMC30DRTN-S734' OR `brand` LIKE 'Sullins Connector Solutions%' ) ) LIMIT 1 [ RunTime:0.000347s ]
SELECT `id` FROM `stock` WHERE `id` <> 59105269 AND `partno` = 'HMC30DRTN-S734' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sullins connector solutions%' ) [ RunTime:0.000302s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16299421 [ RunTime:0.000267s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59102087 LIMIT 5 [ RunTime:0.000485s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59102087 ORDER BY `minOrder` ASC [ RunTime:0.000274s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59102087 ORDER BY `unit` DESC [ RunTime:0.000276s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59102087 LIMIT 2 [ RunTime:0.000398s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59102087 ORDER BY `minOrder` ASC [ RunTime:0.000324s ]
select * from pdf where partno='HMC30DRTN' and brandshort='Sullins Connector Solutions' limit 1 [ RunTime:0.001710s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'HMC30DRTN' OR `brand` LIKE 'Sullins Connector Solutions%' ) ) LIMIT 1 [ RunTime:0.000273s ]
SELECT `id` FROM `stock` WHERE `id` <> 59102087 AND `partno` = 'HMC30DRTN' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sullins connector solutions%' ) [ RunTime:0.014092s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16296269 [ RunTime:0.004141s ]
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 'HMC30DRTN%' OR `brand` LIKE 'HMC30DRTN%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.015053s ]
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 'HMC30DRTN%' OR `brand` LIKE 'HMC30DRTN%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001966s ]
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 'HMC30DRTN%' OR `brand` LIKE 'HMC30DRTN%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003383s ]
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 'HMC30DRTN%' OR `brand` LIKE 'HMC30DRTN%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003493s ]
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 'HMC30DRTN%' OR `brand` LIKE 'HMC30DRTN%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000658s ]
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 'HMC30DRTN%' OR `brand` LIKE 'HMC30DRTN%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000597s ]
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 'HMC30DRTN%' OR `brand` LIKE 'HMC30DRTN%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001615s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'HMC30DRTN%' OR `brand` LIKE 'HMC30DRTN%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.006813s ]