SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002551s ]
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 'CD74HC30M%' OR `brand` LIKE 'CD74HC30M%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.014426s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.002493s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19191166 LIMIT 5 [ RunTime:0.017661s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001234s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19191166 ORDER BY `minOrder` ASC [ RunTime:0.038862s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.013619s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19191166 ORDER BY `unit` DESC [ RunTime:0.028436s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.005740s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19191166 LIMIT 2 [ RunTime:0.011851s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19191166 ORDER BY `minOrder` ASC [ RunTime:0.008731s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19191277 LIMIT 5 [ RunTime:0.023801s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19191277 ORDER BY `minOrder` ASC [ RunTime:0.023380s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19191277 ORDER BY `unit` DESC [ RunTime:0.007738s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19191277 LIMIT 2 [ RunTime:0.025513s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19191277 ORDER BY `minOrder` ASC [ RunTime:0.013187s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19192561 LIMIT 5 [ RunTime:0.015310s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19192561 ORDER BY `minOrder` ASC [ RunTime:0.013469s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19192561 ORDER BY `unit` DESC [ RunTime:0.015508s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19192561 LIMIT 2 [ RunTime:0.010779s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19192561 ORDER BY `minOrder` ASC [ RunTime:0.016631s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19192562 LIMIT 5 [ RunTime:0.006645s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19192562 ORDER BY `minOrder` ASC [ RunTime:0.023879s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19192562 ORDER BY `unit` DESC [ RunTime:0.011079s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19192562 LIMIT 2 [ RunTime:0.013388s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19192562 ORDER BY `minOrder` ASC [ RunTime:0.000598s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17107933 LIMIT 5 [ RunTime:0.012107s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17107933 ORDER BY `minOrder` ASC [ RunTime:0.006281s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17107933 ORDER BY `unit` DESC [ RunTime:0.018323s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17107933 LIMIT 2 [ RunTime:0.007623s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17107933 ORDER BY `minOrder` ASC [ RunTime:0.000803s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14237792 LIMIT 5 [ RunTime:0.001023s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14237792 ORDER BY `minOrder` ASC [ RunTime:0.000481s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14237792 ORDER BY `unit` DESC [ RunTime:0.000478s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14237792 LIMIT 2 [ RunTime:0.006342s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14237792 ORDER BY `minOrder` ASC [ RunTime:0.005630s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14236539 LIMIT 5 [ RunTime:0.011213s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14236539 ORDER BY `minOrder` ASC [ RunTime:0.004776s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14236539 ORDER BY `unit` DESC [ RunTime:0.003076s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14236539 LIMIT 2 [ RunTime:0.011916s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14236539 ORDER BY `minOrder` ASC [ RunTime:0.002115s ]
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 'CD74HC30M%' OR `brand` LIKE 'CD74HC30M%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.022950s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51059855 LIMIT 5 [ RunTime:0.009540s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51059855 ORDER BY `minOrder` ASC [ RunTime:0.008170s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51059855 ORDER BY `unit` DESC [ RunTime:0.005024s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51059855 LIMIT 2 [ RunTime:0.016999s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51059855 ORDER BY `minOrder` ASC [ RunTime:0.014778s ]
select * from pdf where partno='cd74hc30m961g4' and brandshort='texas instruments' limit 1 [ RunTime:0.010577s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002527s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'cd74hc30m961g4' OR `brand` LIKE 'texas instruments%' ) ) LIMIT 1 [ RunTime:0.004517s ]
SELECT `id` FROM `stock` WHERE `id` <> 51059855 AND `partno` = 'cd74hc30m961g4' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%texas instruments%' ) [ RunTime:0.003456s ]
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 'CD74HC30M%' OR `brand` LIKE 'CD74HC30M%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003634s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63793302 LIMIT 5 [ RunTime:0.001422s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63793302 ORDER BY `minOrder` ASC [ RunTime:0.002202s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63793302 ORDER BY `unit` DESC [ RunTime:0.000339s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63793302 LIMIT 2 [ RunTime:0.000582s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63793302 ORDER BY `minOrder` ASC [ RunTime:0.001869s ]
select * from pdf where partno='CD74HC30M' and brandshort='Harris Corporation' limit 1 [ RunTime:0.000491s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CD74HC30M' OR `brand` LIKE 'Harris Corporation%' ) ) LIMIT 1 [ RunTime:0.000383s ]
SELECT `id` FROM `stock` WHERE `id` <> 63793302 AND `partno` = 'CD74HC30M' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%harris corporation%' ) [ RunTime:0.000394s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19191166 [ RunTime:0.000323s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63788725 LIMIT 5 [ RunTime:0.001381s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63788725 ORDER BY `minOrder` ASC [ RunTime:0.001470s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63788725 ORDER BY `unit` DESC [ RunTime:0.001435s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63788725 LIMIT 2 [ RunTime:0.000532s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63788725 ORDER BY `minOrder` ASC [ RunTime:0.000639s ]
select * from pdf where partno='CD74HC30M96' and brandshort='Texas Instruments' limit 1 [ RunTime:0.007295s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CD74HC30M96' OR `brand` LIKE 'Texas Instruments%' ) ) LIMIT 1 [ RunTime:0.000978s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63793020 LIMIT 5 [ RunTime:0.000597s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63793020 ORDER BY `minOrder` ASC [ RunTime:0.001975s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63793020 ORDER BY `unit` DESC [ RunTime:0.014982s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63793020 LIMIT 2 [ RunTime:0.000725s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63793020 ORDER BY `minOrder` ASC [ RunTime:0.000473s ]
select * from pdf where partno='CD74HC30MT' and brandshort='Texas Instruments' limit 1 [ RunTime:0.000940s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CD74HC30MT' OR `brand` LIKE 'Texas Instruments%' ) ) LIMIT 1 [ RunTime:0.002335s ]
SELECT `id` FROM `stock` WHERE `id` <> 63793020 AND `partno` = 'CD74HC30MT' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%texas instruments%' ) [ RunTime:0.000823s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19192561 [ RunTime:0.001038s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63798555 LIMIT 5 [ RunTime:0.002790s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63798555 ORDER BY `minOrder` ASC [ RunTime:0.000318s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63798555 ORDER BY `unit` DESC [ RunTime:0.000339s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63798555 LIMIT 2 [ RunTime:0.000314s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63798555 ORDER BY `minOrder` ASC [ RunTime:0.000301s ]
select * from pdf where partno='CD74HC30MG4' and brandshort='Texas Instruments' limit 1 [ RunTime:0.000421s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CD74HC30MG4' OR `brand` LIKE 'Texas Instruments%' ) ) LIMIT 1 [ RunTime:0.000341s ]
SELECT `id` FROM `stock` WHERE `id` <> 63798555 AND `partno` = 'CD74HC30MG4' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%texas instruments%' ) [ RunTime:0.000378s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14236539 [ RunTime:0.000297s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63798547 LIMIT 5 [ RunTime:0.003476s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63798547 ORDER BY `minOrder` ASC [ RunTime:0.010321s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63798547 ORDER BY `unit` DESC [ RunTime:0.009312s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63798547 LIMIT 2 [ RunTime:0.004962s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63798547 ORDER BY `minOrder` ASC [ RunTime:0.001798s ]
select * from pdf where partno='CD74HC30MTE4' and brandshort='Texas Instruments' limit 1 [ RunTime:0.013974s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CD74HC30MTE4' OR `brand` LIKE 'Texas Instruments%' ) ) LIMIT 1 [ RunTime:0.001570s ]
SELECT `id` FROM `stock` WHERE `id` <> 63798547 AND `partno` = 'CD74HC30MTE4' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%texas instruments%' ) [ RunTime:0.003173s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17107933 [ RunTime:0.006524s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63796958 LIMIT 5 [ RunTime:0.012535s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63796958 ORDER BY `minOrder` ASC [ RunTime:0.004454s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63796958 ORDER BY `unit` DESC [ RunTime:0.011129s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63796958 LIMIT 2 [ RunTime:0.002657s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63796958 ORDER BY `minOrder` ASC [ RunTime:0.007542s ]
select * from pdf where partno='CD74HC30M96G4' and brandshort='Texas Instruments' limit 1 [ RunTime:0.000647s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CD74HC30M96G4' OR `brand` LIKE 'Texas Instruments%' ) ) LIMIT 1 [ RunTime:0.008696s ]
SELECT `id` FROM `stock` WHERE `id` <> 63796958 AND `partno` = 'CD74HC30M96G4' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%texas instruments%' ) [ RunTime:0.002865s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14237792 [ RunTime:0.002662s ]
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 'CD74HC30M%' OR `brand` LIKE 'CD74HC30M%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.019228s ]
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 'CD74HC30M%' OR `brand` LIKE 'CD74HC30M%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.017655s ]
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 'CD74HC30M%' OR `brand` LIKE 'CD74HC30M%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.024952s ]
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 'CD74HC30M%' OR `brand` LIKE 'CD74HC30M%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.052292s ]
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 'CD74HC30M%' OR `brand` LIKE 'CD74HC30M%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.044330s ]
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 'CD74HC30M%' OR `brand` LIKE 'CD74HC30M%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.025235s ]
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 'CD74HC30M%' OR `brand` LIKE 'CD74HC30M%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.011590s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'CD74HC30M%' OR `brand` LIKE 'CD74HC30M%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.067499s ]