SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002666s ]
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 '103g%' OR `brand` LIKE '103g%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.010467s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001532s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13275091 LIMIT 5 [ RunTime:0.009038s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001181s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13275091 ORDER BY `minOrder` ASC [ RunTime:0.009125s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.003042s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13275091 ORDER BY `unit` DESC [ RunTime:0.006097s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.001740s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13275091 LIMIT 2 [ RunTime:0.009471s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13275091 ORDER BY `minOrder` ASC [ RunTime:0.008668s ]
select * from pdf where partno='103GG1K' and brandshort='Littelfuse Inc.' limit 1 [ RunTime:0.004901s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12510246 LIMIT 5 [ RunTime:0.025801s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12510246 ORDER BY `minOrder` ASC [ RunTime:0.012899s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12510246 ORDER BY `unit` DESC [ RunTime:0.039747s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12510246 LIMIT 2 [ RunTime:0.001963s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12510246 ORDER BY `minOrder` ASC [ RunTime:0.003769s ]
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 '103g%' OR `brand` LIKE '103g%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.017356s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32287501 LIMIT 5 [ RunTime:0.023294s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32287501 ORDER BY `minOrder` ASC [ RunTime:0.050417s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32287501 ORDER BY `unit` DESC [ RunTime:0.008948s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32287501 LIMIT 2 [ RunTime:0.022736s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32287501 ORDER BY `minOrder` ASC [ RunTime:0.024256s ]
select * from pdf where partno='103g' and brandshort='aavid' limit 1 [ RunTime:0.009295s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001366s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '103g' OR `brand` LIKE 'aavid%' ) ) LIMIT 1 [ RunTime:0.013014s ]
SELECT `id` FROM `stock` WHERE `id` <> 32287501 AND `partno` = '103g' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%aavid%' ) [ RunTime:0.007934s ]
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 '103g%' OR `brand` LIKE '103g%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.004260s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63208349 LIMIT 5 [ RunTime:0.002891s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63208349 ORDER BY `minOrder` ASC [ RunTime:0.006059s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63208349 ORDER BY `unit` DESC [ RunTime:0.003721s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63208349 LIMIT 2 [ RunTime:0.006737s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63208349 ORDER BY `minOrder` ASC [ RunTime:0.012542s ]
select * from pdf where partno='103GG1K' and brandshort='Littelfuse Inc.' limit 1 [ RunTime:0.000467s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '103GG1K' OR `brand` LIKE 'Littelfuse Inc.%' ) ) LIMIT 1 [ RunTime:0.001933s ]
SELECT `id` FROM `stock` WHERE `id` <> 63208349 AND `partno` = '103GG1K' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%littelfuse inc.%' ) [ RunTime:0.010528s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13275091 [ RunTime:0.001186s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60392124 LIMIT 5 [ RunTime:0.000713s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60392124 ORDER BY `minOrder` ASC [ RunTime:0.000872s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60392124 ORDER BY `unit` DESC [ RunTime:0.000514s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60392124 LIMIT 2 [ RunTime:0.005095s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60392124 ORDER BY `minOrder` ASC [ RunTime:0.006898s ]
select * from pdf where partno='103G40' and brandshort='Anderson Power Products, Inc.' limit 1 [ RunTime:0.003360s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '103G40' OR `brand` LIKE 'Anderson Power Products, Inc.%' ) ) LIMIT 1 [ RunTime:0.008481s ]
SELECT `id` FROM `stock` WHERE `id` <> 60392124 AND `partno` = '103G40' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%anderson power products, inc.%' ) [ RunTime:0.000591s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12510246 [ RunTime:0.001232s ]
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 '103g%' OR `brand` LIKE '103g%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000813s ]
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 '103g%' OR `brand` LIKE '103g%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000675s ]
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 '103g%' OR `brand` LIKE '103g%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000743s ]
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 '103g%' OR `brand` LIKE '103g%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000764s ]
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 '103g%' OR `brand` LIKE '103g%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000654s ]
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 '103g%' OR `brand` LIKE '103g%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000664s ]
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 '103g%' OR `brand` LIKE '103g%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000886s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '103g%' OR `brand` LIKE '103g%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.000676s ]