SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001260s ]
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 '8706%' OR `brand` LIKE '8706%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.014217s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001246s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19809411 LIMIT 5 [ RunTime:0.004987s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001554s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19809411 ORDER BY `minOrder` ASC [ RunTime:0.002893s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.001724s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19809411 ORDER BY `unit` DESC [ RunTime:0.004651s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.001018s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19809411 LIMIT 2 [ RunTime:0.006380s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19809411 ORDER BY `minOrder` ASC [ RunTime:0.000259s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19809410 LIMIT 5 [ RunTime:0.001096s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19809410 ORDER BY `minOrder` ASC [ RunTime:0.001294s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19809410 ORDER BY `unit` DESC [ RunTime:0.011056s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19809410 LIMIT 2 [ RunTime:0.011217s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19809410 ORDER BY `minOrder` ASC [ RunTime:0.000352s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19808198 LIMIT 5 [ RunTime:0.005298s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19808198 ORDER BY `minOrder` ASC [ RunTime:0.000642s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19808198 ORDER BY `unit` DESC [ RunTime:0.000455s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19808198 LIMIT 2 [ RunTime:0.000874s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19808198 ORDER BY `minOrder` ASC [ RunTime:0.002824s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19797486 LIMIT 5 [ RunTime:0.001891s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19797486 ORDER BY `minOrder` ASC [ RunTime:0.000413s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19797486 ORDER BY `unit` DESC [ RunTime:0.001026s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19797486 LIMIT 2 [ RunTime:0.002917s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19797486 ORDER BY `minOrder` ASC [ RunTime:0.001746s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19021089 LIMIT 5 [ RunTime:0.007134s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19021089 ORDER BY `minOrder` ASC [ RunTime:0.001754s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19021089 ORDER BY `unit` DESC [ RunTime:0.000532s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19021089 LIMIT 2 [ RunTime:0.005934s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19021089 ORDER BY `minOrder` ASC [ RunTime:0.000366s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16210136 LIMIT 5 [ RunTime:0.004606s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16210136 ORDER BY `minOrder` ASC [ RunTime:0.001958s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16210136 ORDER BY `unit` DESC [ RunTime:0.006571s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16210136 LIMIT 2 [ RunTime:0.001038s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16210136 ORDER BY `minOrder` ASC [ RunTime:0.000453s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16206401 LIMIT 5 [ RunTime:0.001371s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16206401 ORDER BY `minOrder` ASC [ RunTime:0.007801s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16206401 ORDER BY `unit` DESC [ RunTime:0.010196s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16206401 LIMIT 2 [ RunTime:0.001311s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16206401 ORDER BY `minOrder` ASC [ RunTime:0.000464s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15482556 LIMIT 5 [ RunTime:0.003408s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15482556 ORDER BY `minOrder` ASC [ RunTime:0.000795s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15482556 ORDER BY `unit` DESC [ RunTime:0.003148s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15482556 LIMIT 2 [ RunTime:0.001245s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15482556 ORDER BY `minOrder` ASC [ RunTime:0.000448s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14841557 LIMIT 5 [ RunTime:0.001242s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14841557 ORDER BY `minOrder` ASC [ RunTime:0.000828s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14841557 ORDER BY `unit` DESC [ RunTime:0.000608s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14841557 LIMIT 2 [ RunTime:0.002705s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14841557 ORDER BY `minOrder` ASC [ RunTime:0.000443s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14841556 LIMIT 5 [ RunTime:0.001213s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14841556 ORDER BY `minOrder` ASC [ RunTime:0.000650s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14841556 ORDER BY `unit` DESC [ RunTime:0.000707s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14841556 LIMIT 2 [ RunTime:0.002487s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14841556 ORDER BY `minOrder` ASC [ RunTime:0.000666s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14841555 LIMIT 5 [ RunTime:0.002023s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14841555 ORDER BY `minOrder` ASC [ RunTime:0.001434s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14841555 ORDER BY `unit` DESC [ RunTime:0.000733s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14841555 LIMIT 2 [ RunTime:0.000818s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14841555 ORDER BY `minOrder` ASC [ RunTime:0.000511s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14841554 LIMIT 5 [ RunTime:0.002629s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14841554 ORDER BY `minOrder` ASC [ RunTime:0.001960s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14841554 ORDER BY `unit` DESC [ RunTime:0.000831s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14841554 LIMIT 2 [ RunTime:0.000704s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14841554 ORDER BY `minOrder` ASC [ RunTime:0.000501s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14841510 LIMIT 5 [ RunTime:0.001854s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14841510 ORDER BY `minOrder` ASC [ RunTime:0.003925s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14841510 ORDER BY `unit` DESC [ RunTime:0.002089s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14841510 LIMIT 2 [ RunTime:0.001446s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14841510 ORDER BY `minOrder` ASC [ RunTime:0.000515s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13940255 LIMIT 5 [ RunTime:0.001488s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13940255 ORDER BY `minOrder` ASC [ RunTime:0.000925s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13940255 ORDER BY `unit` DESC [ RunTime:0.002883s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13940255 LIMIT 2 [ RunTime:0.001780s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13940255 ORDER BY `minOrder` ASC [ RunTime:0.000433s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13940218 LIMIT 5 [ RunTime:0.002157s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13940218 ORDER BY `minOrder` ASC [ RunTime:0.000655s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13940218 ORDER BY `unit` DESC [ RunTime:0.000641s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13940218 LIMIT 2 [ RunTime:0.002644s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13940218 ORDER BY `minOrder` ASC [ RunTime:0.000465s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13940217 LIMIT 5 [ RunTime:0.001891s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13940217 ORDER BY `minOrder` ASC [ RunTime:0.001533s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13940217 ORDER BY `unit` DESC [ RunTime:0.000620s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13940217 LIMIT 2 [ RunTime:0.001189s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13940217 ORDER BY `minOrder` ASC [ RunTime:0.000495s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13328072 LIMIT 5 [ RunTime:0.003739s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13328072 ORDER BY `minOrder` ASC [ RunTime:0.002038s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13328072 ORDER BY `unit` DESC [ RunTime:0.000517s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13328072 LIMIT 2 [ RunTime:0.000967s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13328072 ORDER BY `minOrder` ASC [ RunTime:0.000504s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13284860 LIMIT 5 [ RunTime:0.001152s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13284860 ORDER BY `minOrder` ASC [ RunTime:0.001622s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13284860 ORDER BY `unit` DESC [ RunTime:0.001951s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13284860 LIMIT 2 [ RunTime:0.002420s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13284860 ORDER BY `minOrder` ASC [ RunTime:0.001264s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12766663 LIMIT 5 [ RunTime:0.001579s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12766663 ORDER BY `minOrder` ASC [ RunTime:0.000670s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12766663 ORDER BY `unit` DESC [ RunTime:0.000873s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12766663 LIMIT 2 [ RunTime:0.002990s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12766663 ORDER BY `minOrder` ASC [ RunTime:0.003738s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12766472 LIMIT 5 [ RunTime:0.003285s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12766472 ORDER BY `minOrder` ASC [ RunTime:0.002481s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12766472 ORDER BY `unit` DESC [ RunTime:0.000875s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12766472 LIMIT 2 [ RunTime:0.000713s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12766472 ORDER BY `minOrder` ASC [ RunTime:0.000443s ]
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 '8706%' OR `brand` LIKE '8706%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001806s ]
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 '8706%' OR `brand` LIKE '8706%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.006132s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 52884032 LIMIT 5 [ RunTime:0.000501s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52884032 ORDER BY `minOrder` ASC [ RunTime:0.006975s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 52884032 ORDER BY `unit` DESC [ RunTime:0.001398s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 52884032 LIMIT 2 [ RunTime:0.000495s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52884032 ORDER BY `minOrder` ASC [ RunTime:0.000333s ]
select * from pdf where partno='87061-225LF' and brandshort='Amphenol ICC FCI' limit 1 [ RunTime:0.001842s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001526s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '87061-225LF' OR `brand` LIKE 'Amphenol ICC (FCI)%' ) ) LIMIT 1 [ RunTime:0.004741s ]
SELECT `id` FROM `stock` WHERE `id` <> 52884032 AND `partno` = '87061-225LF' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol icc%' ) [ RunTime:0.000984s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12766472 [ RunTime:0.000967s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 52883908 LIMIT 5 [ RunTime:0.001857s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52883908 ORDER BY `minOrder` ASC [ RunTime:0.007336s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 52883908 ORDER BY `unit` DESC [ RunTime:0.000600s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 52883908 LIMIT 2 [ RunTime:0.000563s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52883908 ORDER BY `minOrder` ASC [ RunTime:0.000309s ]
select * from pdf where partno='87061-325LF' and brandshort='Amphenol ICC FCI' limit 1 [ RunTime:0.000515s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '87061-325LF' OR `brand` LIKE 'Amphenol ICC (FCI)%' ) ) LIMIT 1 [ RunTime:0.003291s ]
SELECT `id` FROM `stock` WHERE `id` <> 52883908 AND `partno` = '87061-325LF' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol icc%' ) [ RunTime:0.000794s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 52882565 LIMIT 5 [ RunTime:0.000517s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52882565 ORDER BY `minOrder` ASC [ RunTime:0.004281s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 52882565 ORDER BY `unit` DESC [ RunTime:0.002503s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 52882565 LIMIT 2 [ RunTime:0.001084s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52882565 ORDER BY `minOrder` ASC [ RunTime:0.000389s ]
select * from pdf where partno='87061-217LF' and brandshort='Amphenol ICC FCI' limit 1 [ RunTime:0.000993s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '87061-217LF' OR `brand` LIKE 'Amphenol ICC (FCI)%' ) ) LIMIT 1 [ RunTime:0.008134s ]
SELECT `id` FROM `stock` WHERE `id` <> 52882565 AND `partno` = '87061-217LF' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol icc%' ) [ RunTime:0.001004s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12765757 [ RunTime:0.001366s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 52881473 LIMIT 5 [ RunTime:0.001119s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52881473 ORDER BY `minOrder` ASC [ RunTime:0.002156s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 52881473 ORDER BY `unit` DESC [ RunTime:0.000556s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 52881473 LIMIT 2 [ RunTime:0.000602s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52881473 ORDER BY `minOrder` ASC [ RunTime:0.000424s ]
select * from pdf where partno='87061-213LF' and brandshort='Amphenol ICC FCI' limit 1 [ RunTime:0.000897s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '87061-213LF' OR `brand` LIKE 'Amphenol ICC (FCI)%' ) ) LIMIT 1 [ RunTime:0.002130s ]
SELECT `id` FROM `stock` WHERE `id` <> 52881473 AND `partno` = '87061-213LF' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol icc%' ) [ RunTime:0.001628s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12764853 [ RunTime:0.001726s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 52879742 LIMIT 5 [ RunTime:0.001342s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52879742 ORDER BY `minOrder` ASC [ RunTime:0.002358s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 52879742 ORDER BY `unit` DESC [ RunTime:0.000701s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 52879742 LIMIT 2 [ RunTime:0.000627s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52879742 ORDER BY `minOrder` ASC [ RunTime:0.003334s ]
select * from pdf where partno='87061-617LF' and brandshort='Amphenol ICC FCI' limit 1 [ RunTime:0.001391s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '87061-617LF' OR `brand` LIKE 'Amphenol ICC (FCI)%' ) ) LIMIT 1 [ RunTime:0.000727s ]
SELECT `id` FROM `stock` WHERE `id` <> 52879742 AND `partno` = '87061-617LF' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol icc%' ) [ RunTime:0.000901s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11589227 [ RunTime:0.001274s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 52874640 LIMIT 5 [ RunTime:0.001366s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52874640 ORDER BY `minOrder` ASC [ RunTime:0.001091s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 52874640 ORDER BY `unit` DESC [ RunTime:0.000549s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 52874640 LIMIT 2 [ RunTime:0.000564s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52874640 ORDER BY `minOrder` ASC [ RunTime:0.000847s ]
select * from pdf where partno='87061-605LF' and brandshort='Amphenol ICC FCI' limit 1 [ RunTime:0.003562s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '87061-605LF' OR `brand` LIKE 'Amphenol ICC (FCI)%' ) ) LIMIT 1 [ RunTime:0.000790s ]
SELECT `id` FROM `stock` WHERE `id` <> 52874640 AND `partno` = '87061-605LF' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol icc%' ) [ RunTime:0.001139s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12760877 [ RunTime:0.001212s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 52870106 LIMIT 5 [ RunTime:0.003009s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52870106 ORDER BY `minOrder` ASC [ RunTime:0.002751s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 52870106 ORDER BY `unit` DESC [ RunTime:0.000630s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 52870106 LIMIT 2 [ RunTime:0.000548s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52870106 ORDER BY `minOrder` ASC [ RunTime:0.006807s ]
select * from pdf where partno='87061-305LF' and brandshort='Amphenol ICC FCI' limit 1 [ RunTime:0.001217s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '87061-305LF' OR `brand` LIKE 'Amphenol ICC (FCI)%' ) ) LIMIT 1 [ RunTime:0.002590s ]
SELECT `id` FROM `stock` WHERE `id` <> 52870106 AND `partno` = '87061-305LF' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol icc%' ) [ RunTime:0.011092s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12758830 [ RunTime:0.001172s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 49641094 LIMIT 5 [ RunTime:0.007768s ]
SELECT * FROM `stock_price` WHERE `stockid` = 49641094 ORDER BY `minOrder` ASC [ RunTime:0.003842s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 49641094 ORDER BY `unit` DESC [ RunTime:0.000387s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 49641094 LIMIT 2 [ RunTime:0.000749s ]
SELECT * FROM `stock_price` WHERE `stockid` = 49641094 ORDER BY `minOrder` ASC [ RunTime:0.000370s ]
select * from pdf where partno='8706' and brandshort='Serpac' limit 1 [ RunTime:0.000552s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '8706' OR `brand` LIKE 'Serpac%' ) ) LIMIT 1 [ RunTime:0.000381s ]
SELECT `id` FROM `stock` WHERE `id` <> 49641094 AND `partno` = '8706' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%serpac%' ) [ RunTime:0.000798s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36834029 [ RunTime:0.003594s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 49587442 LIMIT 5 [ RunTime:0.000577s ]
SELECT * FROM `stock_price` WHERE `stockid` = 49587442 ORDER BY `minOrder` ASC [ RunTime:0.007118s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 49587442 ORDER BY `unit` DESC [ RunTime:0.001617s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 49587442 LIMIT 2 [ RunTime:0.000564s ]
SELECT * FROM `stock_price` WHERE `stockid` = 49587442 ORDER BY `minOrder` ASC [ RunTime:0.000404s ]
select * from pdf where partno='8706' and brandshort='ABBATRON' limit 1 [ RunTime:0.000536s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '8706' OR `brand` LIKE 'ABBATRON%' ) ) LIMIT 1 [ RunTime:0.000383s ]
SELECT `id` FROM `stock` WHERE `id` <> 49587442 AND `partno` = '8706' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%abbatron%' ) [ RunTime:0.000867s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36780572 [ RunTime:0.000383s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 49554469 LIMIT 5 [ RunTime:0.000582s ]
SELECT * FROM `stock_price` WHERE `stockid` = 49554469 ORDER BY `minOrder` ASC [ RunTime:0.004707s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 49554469 ORDER BY `unit` DESC [ RunTime:0.000381s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 49554469 LIMIT 2 [ RunTime:0.004754s ]
SELECT * FROM `stock_price` WHERE `stockid` = 49554469 ORDER BY `minOrder` ASC [ RunTime:0.003005s ]
select * from pdf where partno='8706' and brandshort='Keystone Electronics' limit 1 [ RunTime:0.000623s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '8706' OR `brand` LIKE 'Keystone Electronics%' ) ) LIMIT 1 [ RunTime:0.000455s ]
SELECT `id` FROM `stock` WHERE `id` <> 49554469 AND `partno` = '8706' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%keystone electronics%' ) [ RunTime:0.003120s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13328072 [ RunTime:0.000457s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 41855025 LIMIT 5 [ RunTime:0.000642s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41855025 ORDER BY `minOrder` ASC [ RunTime:0.001197s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 41855025 ORDER BY `unit` DESC [ RunTime:0.010695s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 41855025 LIMIT 2 [ RunTime:0.003608s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41855025 ORDER BY `minOrder` ASC [ RunTime:0.001988s ]
select * from pdf where partno='87063-024' and brandshort='Littelfuse Inc.' limit 1 [ RunTime:0.001990s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '87063-024' OR `brand` LIKE 'Littelfuse Inc.%' ) ) LIMIT 1 [ RunTime:0.006444s ]
SELECT `id` FROM `stock` WHERE `id` <> 41855025 AND `partno` = '87063-024' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%littelfuse inc.%' ) [ RunTime:0.002860s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13940218 [ RunTime:0.001264s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 41855024 LIMIT 5 [ RunTime:0.001577s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41855024 ORDER BY `minOrder` ASC [ RunTime:0.005755s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 41855024 ORDER BY `unit` DESC [ RunTime:0.002232s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 41855024 LIMIT 2 [ RunTime:0.001755s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41855024 ORDER BY `minOrder` ASC [ RunTime:0.000277s ]
select * from pdf where partno='87063-020' and brandshort='Littelfuse Inc.' limit 1 [ RunTime:0.000676s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '87063-020' OR `brand` LIKE 'Littelfuse Inc.%' ) ) LIMIT 1 [ RunTime:0.007338s ]
SELECT `id` FROM `stock` WHERE `id` <> 41855024 AND `partno` = '87063-020' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%littelfuse inc.%' ) [ RunTime:0.000559s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13940217 [ RunTime:0.007892s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 41855023 LIMIT 5 [ RunTime:0.001388s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41855023 ORDER BY `minOrder` ASC [ RunTime:0.000539s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 41855023 ORDER BY `unit` DESC [ RunTime:0.008476s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 41855023 LIMIT 2 [ RunTime:0.002664s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41855023 ORDER BY `minOrder` ASC [ RunTime:0.000405s ]
select * from pdf where partno='87063-016' and brandshort='Littelfuse Inc.' limit 1 [ RunTime:0.002502s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '87063-016' OR `brand` LIKE 'Littelfuse Inc.%' ) ) LIMIT 1 [ RunTime:0.001030s ]
SELECT `id` FROM `stock` WHERE `id` <> 41855023 AND `partno` = '87063-016' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%littelfuse inc.%' ) [ RunTime:0.001013s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14841510 [ RunTime:0.015375s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36834029 LIMIT 5 [ RunTime:0.003973s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36834029 ORDER BY `minOrder` ASC [ RunTime:0.003492s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36834029 ORDER BY `unit` DESC [ RunTime:0.000702s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36834029 LIMIT 2 [ RunTime:0.000648s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36834029 ORDER BY `minOrder` ASC [ RunTime:0.000419s ]
select * from pdf where partno='8706' and brandshort='Serpac' limit 1 [ RunTime:0.000555s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '8706' OR `brand` LIKE 'Serpac%' ) ) LIMIT 1 [ RunTime:0.000419s ]
SELECT `id` FROM `stock` WHERE `id` <> 36834029 AND `partno` = '8706' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%serpac%' ) [ RunTime:0.000900s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 49641094 [ RunTime:0.004131s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36780572 LIMIT 5 [ RunTime:0.000617s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36780572 ORDER BY `minOrder` ASC [ RunTime:0.008707s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36780572 ORDER BY `unit` DESC [ RunTime:0.000517s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36780572 LIMIT 2 [ RunTime:0.003391s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36780572 ORDER BY `minOrder` ASC [ RunTime:0.000488s ]
select * from pdf where partno='8706' and brandshort='ABBATRON' limit 1 [ RunTime:0.000459s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '8706' OR `brand` LIKE 'ABBATRON%' ) ) LIMIT 1 [ RunTime:0.000348s ]
SELECT `id` FROM `stock` WHERE `id` <> 36780572 AND `partno` = '8706' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%abbatron%' ) [ RunTime:0.002950s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 49587442 [ RunTime:0.000407s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36747858 LIMIT 5 [ RunTime:0.002042s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36747858 ORDER BY `minOrder` ASC [ RunTime:0.001128s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36747858 ORDER BY `unit` DESC [ RunTime:0.000269s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36747858 LIMIT 2 [ RunTime:0.000523s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36747858 ORDER BY `minOrder` ASC [ RunTime:0.000301s ]
select * from pdf where partno='8706' and brandshort='Keystone Electronics' limit 1 [ RunTime:0.004385s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '8706' OR `brand` LIKE 'Keystone Electronics%' ) ) LIMIT 1 [ RunTime:0.000283s ]
SELECT `id` FROM `stock` WHERE `id` <> 36747858 AND `partno` = '8706' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%keystone electronics%' ) [ RunTime:0.003429s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13328072 [ RunTime:0.000269s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32363865 LIMIT 5 [ RunTime:0.000937s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32363865 ORDER BY `minOrder` ASC [ RunTime:0.001169s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32363865 ORDER BY `unit` DESC [ RunTime:0.001881s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32363865 LIMIT 2 [ RunTime:0.000687s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32363865 ORDER BY `minOrder` ASC [ RunTime:0.000482s ]
select * from pdf where partno='87061-000' and brandshort='TE Connectivity Measurement Specialties' limit 1 [ RunTime:0.005843s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '87061-000' OR `brand` LIKE 'TE Connectivity Measurement Specialties%' ) ) LIMIT 1 [ RunTime:0.001941s ]
SELECT `id` FROM `stock` WHERE `id` <> 32363865 AND `partno` = '87061-000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity measurement specialties%' ) [ RunTime:0.001047s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13284860 [ RunTime:0.003086s ]
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 '8706%' OR `brand` LIKE '8706%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.009069s ]
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 '8706%' OR `brand` LIKE '8706%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.007091s ]
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 '8706%' OR `brand` LIKE '8706%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001506s ]
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 '8706%' OR `brand` LIKE '8706%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.010912s ]
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 '8706%' OR `brand` LIKE '8706%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002703s ]
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 '8706%' OR `brand` LIKE '8706%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000981s ]
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 '8706%' OR `brand` LIKE '8706%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.008914s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '8706%' OR `brand` LIKE '8706%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.002981s ]