SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002255s ]
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 '23202%' OR `brand` LIKE '23202%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.009171s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001069s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19766972 LIMIT 5 [ RunTime:0.000898s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.002673s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19766972 ORDER BY `minOrder` ASC [ RunTime:0.000447s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.001119s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19766972 ORDER BY `unit` DESC [ RunTime:0.000418s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.005675s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19766972 LIMIT 2 [ RunTime:0.002709s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19766972 ORDER BY `minOrder` ASC [ RunTime:0.002372s ]
select * from pdf where partno='2320201-1' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.004631s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13352427 LIMIT 5 [ RunTime:0.005728s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13352427 ORDER BY `minOrder` ASC [ RunTime:0.009238s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13352427 ORDER BY `unit` DESC [ RunTime:0.010270s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13352427 LIMIT 2 [ RunTime:0.022716s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13352427 ORDER BY `minOrder` ASC [ RunTime:0.017921s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12068936 LIMIT 5 [ RunTime:0.011779s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12068936 ORDER BY `minOrder` ASC [ RunTime:0.039315s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12068936 ORDER BY `unit` DESC [ RunTime:0.034884s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12068936 LIMIT 2 [ RunTime:0.047726s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12068936 ORDER BY `minOrder` ASC [ RunTime:0.058818s ]
select * from pdf where partno='2320212' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.002695s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13352422 LIMIT 5 [ RunTime:0.002730s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13352422 ORDER BY `minOrder` ASC [ RunTime:0.001403s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13352422 ORDER BY `unit` DESC [ RunTime:0.000501s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13352422 LIMIT 2 [ RunTime:0.005031s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13352422 ORDER BY `minOrder` ASC [ RunTime:0.002834s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12068958 LIMIT 5 [ RunTime:0.011770s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12068958 ORDER BY `minOrder` ASC [ RunTime:0.001865s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12068958 ORDER BY `unit` DESC [ RunTime:0.000748s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12068958 LIMIT 2 [ RunTime:0.003044s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12068958 ORDER BY `minOrder` ASC [ RunTime:0.001499s ]
select * from pdf where partno='2320241' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.001604s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13352406 LIMIT 5 [ RunTime:0.009369s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13352406 ORDER BY `minOrder` ASC [ RunTime:0.003847s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13352406 ORDER BY `unit` DESC [ RunTime:0.000676s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13352406 LIMIT 2 [ RunTime:0.005586s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13352406 ORDER BY `minOrder` ASC [ RunTime:0.005084s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13352403 LIMIT 5 [ RunTime:0.002237s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13352403 ORDER BY `minOrder` ASC [ RunTime:0.009676s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13352403 ORDER BY `unit` DESC [ RunTime:0.006770s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13352403 LIMIT 2 [ RunTime:0.011433s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13352403 ORDER BY `minOrder` ASC [ RunTime:0.001889s ]
select * from pdf where partno='2320238' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.003741s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13457452 LIMIT 5 [ RunTime:0.006871s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13457452 ORDER BY `minOrder` ASC [ RunTime:0.007093s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13457452 ORDER BY `unit` DESC [ RunTime:0.004263s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13457452 LIMIT 2 [ RunTime:0.001774s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13457452 ORDER BY `minOrder` ASC [ RunTime:0.005674s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17140990 LIMIT 5 [ RunTime:0.004819s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17140990 ORDER BY `minOrder` ASC [ RunTime:0.002250s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17140990 ORDER BY `unit` DESC [ RunTime:0.004502s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17140990 LIMIT 2 [ RunTime:0.008734s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17140990 ORDER BY `minOrder` ASC [ RunTime:0.014417s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14419754 LIMIT 5 [ RunTime:0.017495s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14419754 ORDER BY `minOrder` ASC [ RunTime:0.007048s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14419754 ORDER BY `unit` DESC [ RunTime:0.013118s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14419754 LIMIT 2 [ RunTime:0.017117s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14419754 ORDER BY `minOrder` ASC [ RunTime:0.001189s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13352409 LIMIT 5 [ RunTime:0.003615s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13352409 ORDER BY `minOrder` ASC [ RunTime:0.000758s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13352409 ORDER BY `unit` DESC [ RunTime:0.008657s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13352409 LIMIT 2 [ RunTime:0.012052s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13352409 ORDER BY `minOrder` ASC [ RunTime:0.000865s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11482667 LIMIT 5 [ RunTime:0.002747s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11482667 ORDER BY `minOrder` ASC [ RunTime:0.002408s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11482667 ORDER BY `unit` DESC [ RunTime:0.000677s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11482667 LIMIT 2 [ RunTime:0.004826s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11482667 ORDER BY `minOrder` ASC [ RunTime:0.002988s ]
select * from pdf where partno='2320281-1' and brandshort='TE Connectivity Deutsch Connectors' limit 1 [ RunTime:0.001047s ]
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 '23202%' OR `brand` LIKE '23202%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.005462s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32168621 LIMIT 5 [ RunTime:0.000832s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32168621 ORDER BY `minOrder` ASC [ RunTime:0.008305s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32168621 ORDER BY `unit` DESC [ RunTime:0.000693s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32168621 LIMIT 2 [ RunTime:0.000635s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32168621 ORDER BY `minOrder` ASC [ RunTime:0.001759s ]
select * from pdf where partno='2320225' and brandshort='phoenix contact' limit 1 [ RunTime:0.001069s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.005552s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2320225' OR `brand` LIKE 'phoenix contact%' ) ) LIMIT 1 [ RunTime:0.004724s ]
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 '23202%' OR `brand` LIKE '23202%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003656s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 49248102 LIMIT 5 [ RunTime:0.000446s ]
SELECT * FROM `stock_price` WHERE `stockid` = 49248102 ORDER BY `minOrder` ASC [ RunTime:0.000809s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 49248102 ORDER BY `unit` DESC [ RunTime:0.000445s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 49248102 LIMIT 2 [ RunTime:0.002016s ]
SELECT * FROM `stock_price` WHERE `stockid` = 49248102 ORDER BY `minOrder` ASC [ RunTime:0.000434s ]
select * from pdf where partno='23202.9' and brandshort='Pflitsch' limit 1 [ RunTime:0.000623s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '23202.9' OR `brand` LIKE 'Pflitsch%' ) ) LIMIT 1 [ RunTime:0.000644s ]
SELECT `id` FROM `stock` WHERE `id` <> 49248102 AND `partno` = '23202.9' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%pflitsch%' ) [ RunTime:0.001663s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36451677 [ RunTime:0.000402s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36451677 LIMIT 5 [ RunTime:0.001374s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36451677 ORDER BY `minOrder` ASC [ RunTime:0.005556s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36451677 ORDER BY `unit` DESC [ RunTime:0.000441s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36451677 LIMIT 2 [ RunTime:0.000396s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36451677 ORDER BY `minOrder` ASC [ RunTime:0.000425s ]
select * from pdf where partno='23202.9' and brandshort='Pflitsch' limit 1 [ RunTime:0.000389s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '23202.9' OR `brand` LIKE 'Pflitsch%' ) ) LIMIT 1 [ RunTime:0.000281s ]
SELECT `id` FROM `stock` WHERE `id` <> 36451677 AND `partno` = '23202.9' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%pflitsch%' ) [ RunTime:0.000527s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 49248102 [ RunTime:0.000384s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 50305263 LIMIT 5 [ RunTime:0.002251s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50305263 ORDER BY `minOrder` ASC [ RunTime:0.002290s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 50305263 ORDER BY `unit` DESC [ RunTime:0.000450s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 50305263 LIMIT 2 [ RunTime:0.000388s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50305263 ORDER BY `minOrder` ASC [ RunTime:0.001493s ]
select * from pdf where partno='2320225' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.000631s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2320225' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.001830s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37502797 LIMIT 5 [ RunTime:0.000403s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37502797 ORDER BY `minOrder` ASC [ RunTime:0.001747s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37502797 ORDER BY `unit` DESC [ RunTime:0.000589s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37502797 LIMIT 2 [ RunTime:0.000434s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37502797 ORDER BY `minOrder` ASC [ RunTime:0.000429s ]
select * from pdf where partno='2320225' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.000355s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2320225' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.000306s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 50305284 LIMIT 5 [ RunTime:0.000394s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50305284 ORDER BY `minOrder` ASC [ RunTime:0.001289s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 50305284 ORDER BY `unit` DESC [ RunTime:0.000383s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 50305284 LIMIT 2 [ RunTime:0.006104s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50305284 ORDER BY `minOrder` ASC [ RunTime:0.000630s ]
select * from pdf where partno='2320283' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.001032s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2320283' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.003457s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37502815 LIMIT 5 [ RunTime:0.003123s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37502815 ORDER BY `minOrder` ASC [ RunTime:0.004403s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37502815 ORDER BY `unit` DESC [ RunTime:0.000845s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37502815 LIMIT 2 [ RunTime:0.000661s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37502815 ORDER BY `minOrder` ASC [ RunTime:0.000645s ]
select * from pdf where partno='2320283' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.003204s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2320283' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.002285s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37502812 LIMIT 5 [ RunTime:0.001219s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37502812 ORDER BY `minOrder` ASC [ RunTime:0.000617s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37502812 ORDER BY `unit` DESC [ RunTime:0.001092s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37502812 LIMIT 2 [ RunTime:0.002941s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37502812 ORDER BY `minOrder` ASC [ RunTime:0.000697s ]
select * from pdf where partno='2320270' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.000656s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2320270' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.005286s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 50305281 LIMIT 5 [ RunTime:0.000651s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50305281 ORDER BY `minOrder` ASC [ RunTime:0.000636s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 50305281 ORDER BY `unit` DESC [ RunTime:0.000620s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 50305281 LIMIT 2 [ RunTime:0.003558s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50305281 ORDER BY `minOrder` ASC [ RunTime:0.000604s ]
select * from pdf where partno='2320270' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.000382s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2320270' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.000375s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37502795 LIMIT 5 [ RunTime:0.000553s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37502795 ORDER BY `minOrder` ASC [ RunTime:0.000748s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37502795 ORDER BY `unit` DESC [ RunTime:0.000578s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37502795 LIMIT 2 [ RunTime:0.001393s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37502795 ORDER BY `minOrder` ASC [ RunTime:0.004719s ]
select * from pdf where partno='2320212' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.000450s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2320212' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.003094s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 50305376 LIMIT 5 [ RunTime:0.000727s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50305376 ORDER BY `minOrder` ASC [ RunTime:0.000963s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 50305376 ORDER BY `unit` DESC [ RunTime:0.000590s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 50305376 LIMIT 2 [ RunTime:0.000542s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50305376 ORDER BY `minOrder` ASC [ RunTime:0.006862s ]
select * from pdf where partno='2320212' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.000421s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2320212' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.000385s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37502907 LIMIT 5 [ RunTime:0.000587s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37502907 ORDER BY `minOrder` ASC [ RunTime:0.000951s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37502907 ORDER BY `unit` DESC [ RunTime:0.000699s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37502907 LIMIT 2 [ RunTime:0.000567s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37502907 ORDER BY `minOrder` ASC [ RunTime:0.000611s ]
select * from pdf where partno='2320241' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.000350s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2320241' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.003003s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 50305382 LIMIT 5 [ RunTime:0.007145s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50305382 ORDER BY `minOrder` ASC [ RunTime:0.000833s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 50305382 ORDER BY `unit` DESC [ RunTime:0.000580s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 50305382 LIMIT 2 [ RunTime:0.000567s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50305382 ORDER BY `minOrder` ASC [ RunTime:0.000606s ]
select * from pdf where partno='2320241' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.000383s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2320241' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.000579s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 50701192 LIMIT 5 [ RunTime:0.000581s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50701192 ORDER BY `minOrder` ASC [ RunTime:0.001114s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 50701192 ORDER BY `unit` DESC [ RunTime:0.000574s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 50701192 LIMIT 2 [ RunTime:0.000536s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50701192 ORDER BY `minOrder` ASC [ RunTime:0.000733s ]
select * from pdf where partno='23202' and brandshort='Brady Corporation' limit 1 [ RunTime:0.000925s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '23202' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.005071s ]
SELECT `id` FROM `stock` WHERE `id` <> 50701192 AND `partno` = '23202' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.008480s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13457452 [ RunTime:0.003883s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 50701092 LIMIT 5 [ RunTime:0.001878s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50701092 ORDER BY `minOrder` ASC [ RunTime:0.004520s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 50701092 ORDER BY `unit` DESC [ RunTime:0.000712s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 50701092 LIMIT 2 [ RunTime:0.000626s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50701092 ORDER BY `minOrder` ASC [ RunTime:0.000613s ]
select * from pdf where partno='23202' and brandshort='Brady Corporation' limit 1 [ RunTime:0.001600s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '23202' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.000382s ]
SELECT `id` FROM `stock` WHERE `id` <> 50701092 AND `partno` = '23202' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.000881s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13457452 [ RunTime:0.000370s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 50305562 LIMIT 5 [ RunTime:0.000601s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50305562 ORDER BY `minOrder` ASC [ RunTime:0.003099s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 50305562 ORDER BY `unit` DESC [ RunTime:0.000575s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 50305562 LIMIT 2 [ RunTime:0.006469s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50305562 ORDER BY `minOrder` ASC [ RunTime:0.000635s ]
select * from pdf where partno='2320254' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.000671s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2320254' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.006056s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 38083861 LIMIT 5 [ RunTime:0.000636s ]
SELECT * FROM `stock_price` WHERE `stockid` = 38083861 ORDER BY `minOrder` ASC [ RunTime:0.001100s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 38083861 ORDER BY `unit` DESC [ RunTime:0.000574s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 38083861 LIMIT 2 [ RunTime:0.001084s ]
SELECT * FROM `stock_price` WHERE `stockid` = 38083861 ORDER BY `minOrder` ASC [ RunTime:0.000601s ]
select * from pdf where partno='23202' and brandshort='Brady Corporation' limit 1 [ RunTime:0.000400s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '23202' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.000376s ]
SELECT `id` FROM `stock` WHERE `id` <> 38083861 AND `partno` = '23202' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.000828s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13457452 [ RunTime:0.000364s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37503090 LIMIT 5 [ RunTime:0.000769s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37503090 ORDER BY `minOrder` ASC [ RunTime:0.002929s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37503090 ORDER BY `unit` DESC [ RunTime:0.000414s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37503090 LIMIT 2 [ RunTime:0.000379s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37503090 ORDER BY `minOrder` ASC [ RunTime:0.001172s ]
select * from pdf where partno='2320254' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.003304s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2320254' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.000286s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53552046 LIMIT 5 [ RunTime:0.005817s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53552046 ORDER BY `minOrder` ASC [ RunTime:0.000822s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53552046 ORDER BY `unit` DESC [ RunTime:0.000549s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53552046 LIMIT 2 [ RunTime:0.000379s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53552046 ORDER BY `minOrder` ASC [ RunTime:0.000394s ]
select * from pdf where partno='2320214-1' and brandshort='TE Connectivity Deutsch Connectors' limit 1 [ RunTime:0.000815s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2320214-1' OR `brand` LIKE 'TE Connectivity Deutsch Connectors%' ) ) LIMIT 1 [ RunTime:0.002875s ]
SELECT `id` FROM `stock` WHERE `id` <> 53552046 AND `partno` = '2320214-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity deutsch connectors%' ) [ RunTime:0.000533s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53529628 LIMIT 5 [ RunTime:0.000382s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53529628 ORDER BY `minOrder` ASC [ RunTime:0.002640s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53529628 ORDER BY `unit` DESC [ RunTime:0.003591s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53529628 LIMIT 2 [ RunTime:0.000395s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53529628 ORDER BY `minOrder` ASC [ RunTime:0.000406s ]
select * from pdf where partno='2320281-1' and brandshort='TE Connectivity Deutsch Connectors' limit 1 [ RunTime:0.000381s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2320281-1' OR `brand` LIKE 'TE Connectivity Deutsch Connectors%' ) ) LIMIT 1 [ RunTime:0.000447s ]
SELECT `id` FROM `stock` WHERE `id` <> 53529628 AND `partno` = '2320281-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity deutsch connectors%' ) [ RunTime:0.001064s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11482667 [ RunTime:0.000616s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 52715032 LIMIT 5 [ RunTime:0.000514s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52715032 ORDER BY `minOrder` ASC [ RunTime:0.001030s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 52715032 ORDER BY `unit` DESC [ RunTime:0.000393s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 52715032 LIMIT 2 [ RunTime:0.001332s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52715032 ORDER BY `minOrder` ASC [ RunTime:0.000423s ]
select * from pdf where partno='2320201-1' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.000387s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2320201-1' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.000543s ]
SELECT `id` FROM `stock` WHERE `id` <> 52715032 AND `partno` = '2320201-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.001214s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19766972 [ RunTime:0.001978s ]
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 '23202%' OR `brand` LIKE '23202%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.007039s ]
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 '23202%' OR `brand` LIKE '23202%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001328s ]
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 '23202%' OR `brand` LIKE '23202%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001110s ]
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 '23202%' OR `brand` LIKE '23202%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001030s ]
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 '23202%' OR `brand` LIKE '23202%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001026s ]
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 '23202%' OR `brand` LIKE '23202%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001039s ]
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 '23202%' OR `brand` LIKE '23202%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002910s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '23202%' OR `brand` LIKE '23202%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.001085s ]