SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002716s ]
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 'tlc5615cd%' OR `brand` LIKE 'tlc5615cd%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.069746s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001340s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11248872 LIMIT 5 [ RunTime:0.044634s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.002601s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11248872 ORDER BY `minOrder` ASC [ RunTime:0.011969s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.002150s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11248872 ORDER BY `unit` DESC [ RunTime:0.025859s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.004342s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11248872 LIMIT 2 [ RunTime:0.050973s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11248872 ORDER BY `minOrder` ASC [ RunTime:0.068506s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12256008 LIMIT 5 [ RunTime:0.014889s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12256008 ORDER BY `minOrder` ASC [ RunTime:0.045116s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12256008 ORDER BY `unit` DESC [ RunTime:0.057966s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12256008 LIMIT 2 [ RunTime:0.131456s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12256008 ORDER BY `minOrder` ASC [ RunTime:0.039836s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11246698 LIMIT 5 [ RunTime:0.089079s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11246698 ORDER BY `minOrder` ASC [ RunTime:0.134718s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11246698 ORDER BY `unit` DESC [ RunTime:0.020800s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11246698 LIMIT 2 [ RunTime:0.167126s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11246698 ORDER BY `minOrder` ASC [ RunTime:0.039903s ]
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 'tlc5615cd%' OR `brand` LIKE 'tlc5615cd%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.097116s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51063259 LIMIT 5 [ RunTime:0.033365s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51063259 ORDER BY `minOrder` ASC [ RunTime:0.130897s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51063259 ORDER BY `unit` DESC [ RunTime:0.048307s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51063259 LIMIT 2 [ RunTime:0.095104s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51063259 ORDER BY `minOrder` ASC [ RunTime:0.022202s ]
select * from pdf where partno='tlc5615cdr' and brandshort='texas instruments' limit 1 [ RunTime:0.025901s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002439s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'tlc5615cdr' OR `brand` LIKE 'texas instruments%' ) ) LIMIT 1 [ RunTime:0.071874s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51063379 LIMIT 5 [ RunTime:0.150439s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51063379 ORDER BY `minOrder` ASC [ RunTime:0.062390s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51063379 ORDER BY `unit` DESC [ RunTime:0.052793s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51063379 LIMIT 2 [ RunTime:0.078828s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51063379 ORDER BY `minOrder` ASC [ RunTime:0.012049s ]
select * from pdf where partno='tlc5615cd' and brandshort='texas instruments' limit 1 [ RunTime:0.081146s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'tlc5615cd' OR `brand` LIKE 'texas instruments%' ) ) LIMIT 1 [ RunTime:0.098545s ]
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 'tlc5615cd%' OR `brand` LIKE 'tlc5615cd%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.102878s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63766696 LIMIT 5 [ RunTime:0.043525s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63766696 ORDER BY `minOrder` ASC [ RunTime:0.102645s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63766696 ORDER BY `unit` DESC [ RunTime:0.070027s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63766696 LIMIT 2 [ RunTime:0.153505s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63766696 ORDER BY `minOrder` ASC [ RunTime:0.012082s ]
select * from pdf where partno='TLC5615CD' and brandshort='Texas Instruments' limit 1 [ RunTime:0.064523s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TLC5615CD' OR `brand` LIKE 'Texas Instruments%' ) ) LIMIT 1 [ RunTime:0.050822s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63768173 LIMIT 5 [ RunTime:0.103024s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63768173 ORDER BY `minOrder` ASC [ RunTime:0.075578s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63768173 ORDER BY `unit` DESC [ RunTime:0.038037s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63768173 LIMIT 2 [ RunTime:0.091193s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63768173 ORDER BY `minOrder` ASC [ RunTime:0.095413s ]
select * from pdf where partno='TLC5615CDR' and brandshort='Texas Instruments' limit 1 [ RunTime:0.023641s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TLC5615CDR' OR `brand` LIKE 'Texas Instruments%' ) ) LIMIT 1 [ RunTime:0.090713s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63770356 LIMIT 5 [ RunTime:0.070924s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63770356 ORDER BY `minOrder` ASC [ RunTime:0.015903s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63770356 ORDER BY `unit` DESC [ RunTime:0.066522s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63770356 LIMIT 2 [ RunTime:0.012383s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63770356 ORDER BY `minOrder` ASC [ RunTime:0.029381s ]
select * from pdf where partno='TLC5615CDG4' and brandshort='Texas Instruments' limit 1 [ RunTime:0.026188s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TLC5615CDG4' OR `brand` LIKE 'Texas Instruments%' ) ) LIMIT 1 [ RunTime:0.032306s ]
SELECT `id` FROM `stock` WHERE `id` <> 63770356 AND `partno` = 'TLC5615CDG4' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%texas instruments%' ) [ RunTime:0.033219s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63768109 LIMIT 5 [ RunTime:0.034344s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63768109 ORDER BY `minOrder` ASC [ RunTime:0.091154s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63768109 ORDER BY `unit` DESC [ RunTime:0.208204s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63768109 LIMIT 2 [ RunTime:0.055239s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63768109 ORDER BY `minOrder` ASC [ RunTime:0.005879s ]
select * from pdf where partno='TLC5615CDGK' and brandshort='Texas Instruments' limit 1 [ RunTime:0.034511s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TLC5615CDGK' OR `brand` LIKE 'Texas Instruments%' ) ) LIMIT 1 [ RunTime:0.078678s ]
SELECT `id` FROM `stock` WHERE `id` <> 63768109 AND `partno` = 'TLC5615CDGK' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%texas instruments%' ) [ RunTime:0.103625s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12256008 [ RunTime:0.064526s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63768067 LIMIT 5 [ RunTime:0.049955s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63768067 ORDER BY `minOrder` ASC [ RunTime:0.084942s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63768067 ORDER BY `unit` DESC [ RunTime:0.060098s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63768067 LIMIT 2 [ RunTime:0.069399s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63768067 ORDER BY `minOrder` ASC [ RunTime:0.031016s ]
select * from pdf where partno='TLC5615CDGKR' and brandshort='Texas Instruments' limit 1 [ RunTime:0.079977s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TLC5615CDGKR' OR `brand` LIKE 'Texas Instruments%' ) ) LIMIT 1 [ RunTime:0.013434s ]
SELECT `id` FROM `stock` WHERE `id` <> 63768067 AND `partno` = 'TLC5615CDGKR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%texas instruments%' ) [ RunTime:0.054405s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11246698 [ RunTime:0.070587s ]
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 'tlc5615cd%' OR `brand` LIKE 'tlc5615cd%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.035908s ]
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 'tlc5615cd%' OR `brand` LIKE 'tlc5615cd%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.038353s ]
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 'tlc5615cd%' OR `brand` LIKE 'tlc5615cd%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.090764s ]
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 'tlc5615cd%' OR `brand` LIKE 'tlc5615cd%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.029876s ]
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 'tlc5615cd%' OR `brand` LIKE 'tlc5615cd%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.041870s ]
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 'tlc5615cd%' OR `brand` LIKE 'tlc5615cd%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.032381s ]
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 'tlc5615cd%' OR `brand` LIKE 'tlc5615cd%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.053018s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'tlc5615cd%' OR `brand` LIKE 'tlc5615cd%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.074910s ]