SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002689s ]
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 '10143%' OR `brand` LIKE '10143%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.059783s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.011313s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12066340 LIMIT 5 [ RunTime:0.033229s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.018035s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12066340 ORDER BY `minOrder` ASC [ RunTime:0.049872s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.004717s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12066340 ORDER BY `unit` DESC [ RunTime:0.016436s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.002470s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12066340 LIMIT 2 [ RunTime:0.001822s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12066340 ORDER BY `minOrder` ASC [ RunTime:0.001699s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16187611 LIMIT 5 [ RunTime:0.025024s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16187611 ORDER BY `minOrder` ASC [ RunTime:0.038032s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16187611 ORDER BY `unit` DESC [ RunTime:0.056084s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16187611 LIMIT 2 [ RunTime:0.055429s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16187611 ORDER BY `minOrder` ASC [ RunTime:0.004481s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19833816 LIMIT 5 [ RunTime:0.039871s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19833816 ORDER BY `minOrder` ASC [ RunTime:0.022153s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19833816 ORDER BY `unit` DESC [ RunTime:0.064005s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19833816 LIMIT 2 [ RunTime:0.035228s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19833816 ORDER BY `minOrder` ASC [ RunTime:0.061858s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16185470 LIMIT 5 [ RunTime:0.047614s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16185470 ORDER BY `minOrder` ASC [ RunTime:0.005121s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16185470 ORDER BY `unit` DESC [ RunTime:0.026719s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16185470 LIMIT 2 [ RunTime:0.055543s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16185470 ORDER BY `minOrder` ASC [ RunTime:0.032831s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15489055 LIMIT 5 [ RunTime:0.067283s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15489055 ORDER BY `minOrder` ASC [ RunTime:0.093539s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15489055 ORDER BY `unit` DESC [ RunTime:0.041368s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15489055 LIMIT 2 [ RunTime:0.039733s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15489055 ORDER BY `minOrder` ASC [ RunTime:0.024415s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19751534 LIMIT 5 [ RunTime:0.039768s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19751534 ORDER BY `minOrder` ASC [ RunTime:0.010611s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19751534 ORDER BY `unit` DESC [ RunTime:0.023878s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19751534 LIMIT 2 [ RunTime:0.013986s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19751534 ORDER BY `minOrder` ASC [ RunTime:0.005033s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19831297 LIMIT 5 [ RunTime:0.006175s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19831297 ORDER BY `minOrder` ASC [ RunTime:0.019988s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19831297 ORDER BY `unit` DESC [ RunTime:0.014191s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19831297 LIMIT 2 [ RunTime:0.000489s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19831297 ORDER BY `minOrder` ASC [ RunTime:0.005722s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19774388 LIMIT 5 [ RunTime:0.012004s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19774388 ORDER BY `minOrder` ASC [ RunTime:0.000532s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19774388 ORDER BY `unit` DESC [ RunTime:0.005536s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19774388 LIMIT 2 [ RunTime:0.012506s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19774388 ORDER BY `minOrder` ASC [ RunTime:0.000620s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19661760 LIMIT 5 [ RunTime:0.002078s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19661760 ORDER BY `minOrder` ASC [ RunTime:0.000526s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19661760 ORDER BY `unit` DESC [ RunTime:0.000467s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19661760 LIMIT 2 [ RunTime:0.000839s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19661760 ORDER BY `minOrder` ASC [ RunTime:0.002407s ]
select * from pdf where partno='1014370000' and brandshort='Weidmüller' limit 1 [ RunTime:0.005533s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19661850 LIMIT 5 [ RunTime:0.010052s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19661850 ORDER BY `minOrder` ASC [ RunTime:0.000858s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19661850 ORDER BY `unit` DESC [ RunTime:0.003073s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19661850 LIMIT 2 [ RunTime:0.004997s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19661850 ORDER BY `minOrder` ASC [ RunTime:0.000477s ]
select * from pdf where partno='1014380000' and brandshort='Weidmüller' limit 1 [ RunTime:0.001608s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11446439 LIMIT 5 [ RunTime:0.001105s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11446439 ORDER BY `minOrder` ASC [ RunTime:0.002226s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11446439 ORDER BY `unit` DESC [ RunTime:0.000739s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11446439 LIMIT 2 [ RunTime:0.000495s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11446439 ORDER BY `minOrder` ASC [ RunTime:0.000374s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19662030 LIMIT 5 [ RunTime:0.000801s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19662030 ORDER BY `minOrder` ASC [ RunTime:0.001071s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19662030 ORDER BY `unit` DESC [ RunTime:0.007541s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19662030 LIMIT 2 [ RunTime:0.002798s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19662030 ORDER BY `minOrder` ASC [ RunTime:0.004649s ]
select * from pdf where partno='1014390000' and brandshort='Weidmüller' limit 1 [ RunTime:0.003854s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11396231 LIMIT 5 [ RunTime:0.001688s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11396231 ORDER BY `minOrder` ASC [ RunTime:0.000522s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11396231 ORDER BY `unit` DESC [ RunTime:0.000455s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11396231 LIMIT 2 [ RunTime:0.000431s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11396231 ORDER BY `minOrder` ASC [ RunTime:0.000336s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12184 LIMIT 5 [ RunTime:0.000452s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12184 ORDER BY `minOrder` ASC [ RunTime:0.004132s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12184 ORDER BY `unit` DESC [ RunTime:0.003155s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12184 LIMIT 2 [ RunTime:0.000512s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12184 ORDER BY `minOrder` ASC [ RunTime:0.004825s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001467s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '10143578-102KLF' OR `brand` LIKE 'AMPHENOL COMMUNICATIONS SOLUTIONS%' ) ) LIMIT 1 [ RunTime:0.003976s ]
SELECT `id` FROM `stock` WHERE `id` <> 12184 AND `partno` = '10143578-102KLF' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol communications solutions%' ) [ RunTime:0.004500s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19911972 LIMIT 5 [ RunTime:0.006113s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19911972 ORDER BY `minOrder` ASC [ RunTime:0.002944s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19911972 ORDER BY `unit` DESC [ RunTime:0.000565s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19911972 LIMIT 2 [ RunTime:0.000448s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19911972 ORDER BY `minOrder` ASC [ RunTime:0.000342s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19863341 LIMIT 5 [ RunTime:0.001014s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19863341 ORDER BY `minOrder` ASC [ RunTime:0.000672s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19863341 ORDER BY `unit` DESC [ RunTime:0.006376s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19863341 LIMIT 2 [ RunTime:0.003567s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19863341 ORDER BY `minOrder` ASC [ RunTime:0.002443s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19817622 LIMIT 5 [ RunTime:0.003578s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19817622 ORDER BY `minOrder` ASC [ RunTime:0.003211s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19817622 ORDER BY `unit` DESC [ RunTime:0.007867s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19817622 LIMIT 2 [ RunTime:0.006011s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19817622 ORDER BY `minOrder` ASC [ RunTime:0.000534s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19764407 LIMIT 5 [ RunTime:0.001593s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19764407 ORDER BY `minOrder` ASC [ RunTime:0.000590s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19764407 ORDER BY `unit` DESC [ RunTime:0.004268s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19764407 LIMIT 2 [ RunTime:0.001408s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19764407 ORDER BY `minOrder` ASC [ RunTime:0.003768s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19656912 LIMIT 5 [ RunTime:0.001534s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19656912 ORDER BY `minOrder` ASC [ RunTime:0.000407s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19656912 ORDER BY `unit` DESC [ RunTime:0.000406s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19656912 LIMIT 2 [ RunTime:0.003047s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19656912 ORDER BY `minOrder` ASC [ RunTime:0.002680s ]
select * from pdf where partno='1014360000' and brandshort='Weidmüller' limit 1 [ RunTime:0.003955s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19656513 LIMIT 5 [ RunTime:0.007744s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19656513 ORDER BY `minOrder` ASC [ RunTime:0.006145s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19656513 ORDER BY `unit` DESC [ RunTime:0.006682s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19656513 LIMIT 2 [ RunTime:0.003784s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19656513 ORDER BY `minOrder` ASC [ RunTime:0.000357s ]
select * from pdf where partno='1014340000' and brandshort='Weidmüller' limit 1 [ RunTime:0.004251s ]
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 '10143%' OR `brand` LIKE '10143%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.011753s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32284526 LIMIT 5 [ RunTime:0.003237s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32284526 ORDER BY `minOrder` ASC [ RunTime:0.006248s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32284526 ORDER BY `unit` DESC [ RunTime:0.003145s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32284526 LIMIT 2 [ RunTime:0.011679s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32284526 ORDER BY `minOrder` ASC [ RunTime:0.001977s ]
select * from pdf where partno='101438-000' and brandshort='smiths interconnect / idi' limit 1 [ RunTime:0.002948s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '101438-000' OR `brand` LIKE 'smiths interconnect / idi%' ) ) LIMIT 1 [ RunTime:0.011361s ]
SELECT `id` FROM `stock` WHERE `id` <> 32284526 AND `partno` = '101438-000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%smiths interconnect / idi%' ) [ RunTime:0.004329s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32278286 [ RunTime:0.000685s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32278286 LIMIT 5 [ RunTime:0.000604s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32278286 ORDER BY `minOrder` ASC [ RunTime:0.001146s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32278286 ORDER BY `unit` DESC [ RunTime:0.001804s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32278286 LIMIT 2 [ RunTime:0.003581s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32278286 ORDER BY `minOrder` ASC [ RunTime:0.004110s ]
select * from pdf where partno='101438-000' and brandshort='smiths interconnect / idi' limit 1 [ RunTime:0.000498s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '101438-000' OR `brand` LIKE 'smiths interconnect / idi%' ) ) LIMIT 1 [ RunTime:0.000392s ]
SELECT `id` FROM `stock` WHERE `id` <> 32278286 AND `partno` = '101438-000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%smiths interconnect / idi%' ) [ RunTime:0.000841s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32284526 [ RunTime:0.001292s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32254590 LIMIT 5 [ RunTime:0.000513s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32254590 ORDER BY `minOrder` ASC [ RunTime:0.001150s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32254590 ORDER BY `unit` DESC [ RunTime:0.002487s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32254590 LIMIT 2 [ RunTime:0.005000s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32254590 ORDER BY `minOrder` ASC [ RunTime:0.000412s ]
select * from pdf where partno='10143762-102lf' and brandshort='amphenol fci' limit 1 [ RunTime:0.001527s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '10143762-102lf' OR `brand` LIKE 'amphenol fci%' ) ) LIMIT 1 [ RunTime:0.001739s ]
SELECT `id` FROM `stock` WHERE `id` <> 32254590 AND `partno` = '10143762-102lf' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol fci%' ) [ RunTime:0.001003s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32254616 LIMIT 5 [ RunTime:0.000723s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32254616 ORDER BY `minOrder` ASC [ RunTime:0.000850s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32254616 ORDER BY `unit` DESC [ RunTime:0.003166s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32254616 LIMIT 2 [ RunTime:0.003049s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32254616 ORDER BY `minOrder` ASC [ RunTime:0.002889s ]
select * from pdf where partno='10143758-101lf' and brandshort='amphenol fci' limit 1 [ RunTime:0.001324s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '10143758-101lf' OR `brand` LIKE 'amphenol fci%' ) ) LIMIT 1 [ RunTime:0.005579s ]
SELECT `id` FROM `stock` WHERE `id` <> 32254616 AND `partno` = '10143758-101lf' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol fci%' ) [ RunTime:0.007098s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32254741 LIMIT 5 [ RunTime:0.001963s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32254741 ORDER BY `minOrder` ASC [ RunTime:0.002006s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32254741 ORDER BY `unit` DESC [ RunTime:0.004022s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32254741 LIMIT 2 [ RunTime:0.002511s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32254741 ORDER BY `minOrder` ASC [ RunTime:0.000495s ]
select * from pdf where partno='10143762-101lf' and brandshort='amphenol fci' limit 1 [ RunTime:0.001563s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '10143762-101lf' OR `brand` LIKE 'amphenol fci%' ) ) LIMIT 1 [ RunTime:0.000956s ]
SELECT `id` FROM `stock` WHERE `id` <> 32254741 AND `partno` = '10143762-101lf' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol fci%' ) [ RunTime:0.000763s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51095548 LIMIT 5 [ RunTime:0.000735s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51095548 ORDER BY `minOrder` ASC [ RunTime:0.003787s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51095548 ORDER BY `unit` DESC [ RunTime:0.005998s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51095548 LIMIT 2 [ RunTime:0.004344s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51095548 ORDER BY `minOrder` ASC [ RunTime:0.000795s ]
select * from pdf where partno='1014303' and brandshort='phoenix contact' limit 1 [ RunTime:0.001162s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1014303' OR `brand` LIKE 'phoenix contact%' ) ) LIMIT 1 [ RunTime:0.007336s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51095553 LIMIT 5 [ RunTime:0.003463s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51095553 ORDER BY `minOrder` ASC [ RunTime:0.002573s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51095553 ORDER BY `unit` DESC [ RunTime:0.001885s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51095553 LIMIT 2 [ RunTime:0.018758s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51095553 ORDER BY `minOrder` ASC [ RunTime:0.000569s ]
select * from pdf where partno='1014315' and brandshort='phoenix contact' limit 1 [ RunTime:0.009376s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1014315' OR `brand` LIKE 'phoenix contact%' ) ) LIMIT 1 [ RunTime:0.012989s ]
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 '10143%' OR `brand` LIKE '10143%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.020889s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57738277 LIMIT 5 [ RunTime:0.000611s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57738277 ORDER BY `minOrder` ASC [ RunTime:0.005145s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57738277 ORDER BY `unit` DESC [ RunTime:0.000607s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57738277 LIMIT 2 [ RunTime:0.000523s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57738277 ORDER BY `minOrder` ASC [ RunTime:0.002912s ]
select * from pdf where partno='10143CS' and brandshort='Century Spring Corp' limit 1 [ RunTime:0.022038s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '10143CS' OR `brand` LIKE 'Century Spring Corp%' ) ) LIMIT 1 [ RunTime:0.007473s ]
SELECT `id` FROM `stock` WHERE `id` <> 57738277 AND `partno` = '10143CS' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%century spring corp%' ) [ RunTime:0.032516s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12066340 [ RunTime:0.000557s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 52583477 LIMIT 5 [ RunTime:0.005053s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52583477 ORDER BY `minOrder` ASC [ RunTime:0.005552s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 52583477 ORDER BY `unit` DESC [ RunTime:0.012757s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 52583477 LIMIT 2 [ RunTime:0.004622s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52583477 ORDER BY `minOrder` ASC [ RunTime:0.000325s ]
select * from pdf where partno='10143535-108KLF' and brandshort='Amphenol ICC FCI' limit 1 [ RunTime:0.000930s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '10143535-108KLF' OR `brand` LIKE 'Amphenol ICC (FCI)%' ) ) LIMIT 1 [ RunTime:0.005228s ]
SELECT `id` FROM `stock` WHERE `id` <> 52583477 AND `partno` = '10143535-108KLF' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol icc%' ) [ RunTime:0.007481s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19831297 [ RunTime:0.000706s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 52588191 LIMIT 5 [ RunTime:0.000530s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52588191 ORDER BY `minOrder` ASC [ RunTime:0.003922s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 52588191 ORDER BY `unit` DESC [ RunTime:0.002103s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 52588191 LIMIT 2 [ RunTime:0.002369s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52588191 ORDER BY `minOrder` ASC [ RunTime:0.004925s ]
select * from pdf where partno='10143535-112KLF' and brandshort='Amphenol ICC FCI' limit 1 [ RunTime:0.001479s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '10143535-112KLF' OR `brand` LIKE 'Amphenol ICC (FCI)%' ) ) LIMIT 1 [ RunTime:0.004531s ]
SELECT `id` FROM `stock` WHERE `id` <> 52588191 AND `partno` = '10143535-112KLF' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol icc%' ) [ RunTime:0.000707s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16187611 [ RunTime:0.000504s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 52640273 LIMIT 5 [ RunTime:0.000959s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52640273 ORDER BY `minOrder` ASC [ RunTime:0.002883s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 52640273 ORDER BY `unit` DESC [ RunTime:0.002315s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 52640273 LIMIT 2 [ RunTime:0.001162s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52640273 ORDER BY `minOrder` ASC [ RunTime:0.000507s ]
select * from pdf where partno='10143578-106KLF' and brandshort='Amphenol ICC FCI' limit 1 [ RunTime:0.001201s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '10143578-106KLF' OR `brand` LIKE 'Amphenol ICC (FCI)%' ) ) LIMIT 1 [ RunTime:0.000601s ]
SELECT `id` FROM `stock` WHERE `id` <> 52640273 AND `partno` = '10143578-106KLF' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol icc%' ) [ RunTime:0.013005s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 52582735 LIMIT 5 [ RunTime:0.001615s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52582735 ORDER BY `minOrder` ASC [ RunTime:0.018486s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 52582735 ORDER BY `unit` DESC [ RunTime:0.003757s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 52582735 LIMIT 2 [ RunTime:0.005503s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52582735 ORDER BY `minOrder` ASC [ RunTime:0.002156s ]
select * from pdf where partno='10143535-104KLF' and brandshort='Amphenol ICC FCI' limit 1 [ RunTime:0.004443s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '10143535-104KLF' OR `brand` LIKE 'Amphenol ICC (FCI)%' ) ) LIMIT 1 [ RunTime:0.000581s ]
SELECT `id` FROM `stock` WHERE `id` <> 52582735 AND `partno` = '10143535-104KLF' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol icc%' ) [ RunTime:0.002168s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15489055 [ RunTime:0.002774s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53048356 LIMIT 5 [ RunTime:0.006798s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53048356 ORDER BY `minOrder` ASC [ RunTime:0.002510s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53048356 ORDER BY `unit` DESC [ RunTime:0.001074s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53048356 LIMIT 2 [ RunTime:0.000481s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53048356 ORDER BY `minOrder` ASC [ RunTime:0.000306s ]
select * from pdf where partno='10143486-101LF' and brandshort='Amphenol ICC FCI' limit 1 [ RunTime:0.001099s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '10143486-101LF' OR `brand` LIKE 'Amphenol ICC (FCI)%' ) ) LIMIT 1 [ RunTime:0.007792s ]
SELECT `id` FROM `stock` WHERE `id` <> 53048356 AND `partno` = '10143486-101LF' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol icc%' ) [ RunTime:0.003035s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12800066 [ RunTime:0.011426s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 52578444 LIMIT 5 [ RunTime:0.001716s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52578444 ORDER BY `minOrder` ASC [ RunTime:0.006516s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 52578444 ORDER BY `unit` DESC [ RunTime:0.001087s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 52578444 LIMIT 2 [ RunTime:0.001947s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52578444 ORDER BY `minOrder` ASC [ RunTime:0.000463s ]
select * from pdf where partno='10143535-116KLF' and brandshort='Amphenol ICC FCI' limit 1 [ RunTime:0.001015s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '10143535-116KLF' OR `brand` LIKE 'Amphenol ICC (FCI)%' ) ) LIMIT 1 [ RunTime:0.001174s ]
SELECT `id` FROM `stock` WHERE `id` <> 52578444 AND `partno` = '10143535-116KLF' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol icc%' ) [ RunTime:0.007741s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19833816 [ RunTime:0.003931s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 52644658 LIMIT 5 [ RunTime:0.001886s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52644658 ORDER BY `minOrder` ASC [ RunTime:0.008034s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 52644658 ORDER BY `unit` DESC [ RunTime:0.005773s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 52644658 LIMIT 2 [ RunTime:0.002139s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52644658 ORDER BY `minOrder` ASC [ RunTime:0.001917s ]
select * from pdf where partno='10143578-108KLF' and brandshort='Amphenol ICC FCI' limit 1 [ RunTime:0.000803s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '10143578-108KLF' OR `brand` LIKE 'Amphenol ICC (FCI)%' ) ) LIMIT 1 [ RunTime:0.003463s ]
SELECT `id` FROM `stock` WHERE `id` <> 52644658 AND `partno` = '10143578-108KLF' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol icc%' ) [ RunTime:0.003729s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19774388 [ RunTime:0.004019s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53647109 LIMIT 5 [ RunTime:0.000813s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53647109 ORDER BY `minOrder` ASC [ RunTime:0.002637s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53647109 ORDER BY `unit` DESC [ RunTime:0.011633s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53647109 LIMIT 2 [ RunTime:0.000873s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53647109 ORDER BY `minOrder` ASC [ RunTime:0.000615s ]
select * from pdf where partno='1014300000' and brandshort='Weidmüller' limit 1 [ RunTime:0.001048s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1014300000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.007092s ]
SELECT `id` FROM `stock` WHERE `id` <> 53647109 AND `partno` = '1014300000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.004057s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11446439 [ RunTime:0.006141s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53109223 LIMIT 5 [ RunTime:0.003548s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53109223 ORDER BY `minOrder` ASC [ RunTime:0.002652s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53109223 ORDER BY `unit` DESC [ RunTime:0.004047s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53109223 LIMIT 2 [ RunTime:0.000340s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53109223 ORDER BY `minOrder` ASC [ RunTime:0.000228s ]
select * from pdf where partno='101439-01' and brandshort='TE Connectivity Deutsch Connectors' limit 1 [ RunTime:0.000569s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '101439-01' OR `brand` LIKE 'TE Connectivity Deutsch Connectors%' ) ) LIMIT 1 [ RunTime:0.008439s ]
SELECT `id` FROM `stock` WHERE `id` <> 53109223 AND `partno` = '101439-01' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity deutsch connectors%' ) [ RunTime:0.018279s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 52582913 LIMIT 5 [ RunTime:0.001694s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52582913 ORDER BY `minOrder` ASC [ RunTime:0.004806s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 52582913 ORDER BY `unit` DESC [ RunTime:0.001710s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 52582913 LIMIT 2 [ RunTime:0.007373s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52582913 ORDER BY `minOrder` ASC [ RunTime:0.000468s ]
select * from pdf where partno='10143535-105KLF' and brandshort='Amphenol ICC FCI' limit 1 [ RunTime:0.001025s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '10143535-105KLF' OR `brand` LIKE 'Amphenol ICC (FCI)%' ) ) LIMIT 1 [ RunTime:0.010774s ]
SELECT `id` FROM `stock` WHERE `id` <> 52582913 AND `partno` = '10143535-105KLF' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol icc%' ) [ RunTime:0.002915s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19751534 [ RunTime:0.007364s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 54120379 LIMIT 5 [ RunTime:0.001484s ]
SELECT * FROM `stock_price` WHERE `stockid` = 54120379 ORDER BY `minOrder` ASC [ RunTime:0.002974s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 54120379 ORDER BY `unit` DESC [ RunTime:0.003799s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 54120379 LIMIT 2 [ RunTime:0.006399s ]
SELECT * FROM `stock_price` WHERE `stockid` = 54120379 ORDER BY `minOrder` ASC [ RunTime:0.003775s ]
select * from pdf where partno='10143762-102LF' and brandshort='Amphenol ICC FCI' limit 1 [ RunTime:0.002271s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '10143762-102LF' OR `brand` LIKE 'Amphenol ICC (FCI)%' ) ) LIMIT 1 [ RunTime:0.000559s ]
SELECT `id` FROM `stock` WHERE `id` <> 54120379 AND `partno` = '10143762-102LF' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol icc%' ) [ RunTime:0.000552s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11396231 [ RunTime:0.002318s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 52679799 LIMIT 5 [ RunTime:0.007829s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52679799 ORDER BY `minOrder` ASC [ RunTime:0.011140s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 52679799 ORDER BY `unit` DESC [ RunTime:0.001078s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 52679799 LIMIT 2 [ RunTime:0.000497s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52679799 ORDER BY `minOrder` ASC [ RunTime:0.000287s ]
select * from pdf where partno='10143535-106KLF' and brandshort='Amphenol ICC FCI' limit 1 [ RunTime:0.000888s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '10143535-106KLF' OR `brand` LIKE 'Amphenol ICC (FCI)%' ) ) LIMIT 1 [ RunTime:0.000570s ]
SELECT `id` FROM `stock` WHERE `id` <> 52679799 AND `partno` = '10143535-106KLF' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol icc%' ) [ RunTime:0.006181s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16185470 [ RunTime:0.000552s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 54119881 LIMIT 5 [ RunTime:0.002152s ]
SELECT * FROM `stock_price` WHERE `stockid` = 54119881 ORDER BY `minOrder` ASC [ RunTime:0.006476s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 54119881 ORDER BY `unit` DESC [ RunTime:0.000420s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 54119881 LIMIT 2 [ RunTime:0.000380s ]
SELECT * FROM `stock_price` WHERE `stockid` = 54119881 ORDER BY `minOrder` ASC [ RunTime:0.001923s ]
select * from pdf where partno='10143758-101LF' and brandshort='Amphenol ICC FCI' limit 1 [ RunTime:0.000917s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '10143758-101LF' OR `brand` LIKE 'Amphenol ICC (FCI)%' ) ) LIMIT 1 [ RunTime:0.000530s ]
SELECT `id` FROM `stock` WHERE `id` <> 54119881 AND `partno` = '10143758-101LF' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol icc%' ) [ RunTime:0.000554s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12499568 [ RunTime:0.000687s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53665137 LIMIT 5 [ RunTime:0.001475s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53665137 ORDER BY `minOrder` ASC [ RunTime:0.011299s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53665137 ORDER BY `unit` DESC [ RunTime:0.008059s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53665137 LIMIT 2 [ RunTime:0.002121s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53665137 ORDER BY `minOrder` ASC [ RunTime:0.017998s ]
select * from pdf where partno='1014370000' and brandshort='Weidmüller' limit 1 [ RunTime:0.000694s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1014370000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.010461s ]
SELECT `id` FROM `stock` WHERE `id` <> 53665137 AND `partno` = '1014370000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.005001s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19661760 [ RunTime:0.003528s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53665396 LIMIT 5 [ RunTime:0.000744s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53665396 ORDER BY `minOrder` ASC [ RunTime:0.002068s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53665396 ORDER BY `unit` DESC [ RunTime:0.000637s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53665396 LIMIT 2 [ RunTime:0.002230s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53665396 ORDER BY `minOrder` ASC [ RunTime:0.001279s ]
select * from pdf where partno='1014390000' and brandshort='Weidmüller' limit 1 [ RunTime:0.000630s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1014390000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.017523s ]
SELECT `id` FROM `stock` WHERE `id` <> 53665396 AND `partno` = '1014390000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.005872s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19662030 [ RunTime:0.004502s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53666255 LIMIT 5 [ RunTime:0.019349s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53666255 ORDER BY `minOrder` ASC [ RunTime:0.003636s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53666255 ORDER BY `unit` DESC [ RunTime:0.001278s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53666255 LIMIT 2 [ RunTime:0.000619s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53666255 ORDER BY `minOrder` ASC [ RunTime:0.000430s ]
select * from pdf where partno='1014320000' and brandshort='Weidmüller' limit 1 [ RunTime:0.001079s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1014320000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.009242s ]
SELECT `id` FROM `stock` WHERE `id` <> 53666255 AND `partno` = '1014320000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.004828s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53670969 LIMIT 5 [ RunTime:0.003246s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53670969 ORDER BY `minOrder` ASC [ RunTime:0.002869s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53670969 ORDER BY `unit` DESC [ RunTime:0.000669s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53670969 LIMIT 2 [ RunTime:0.004018s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53670969 ORDER BY `minOrder` ASC [ RunTime:0.004365s ]
select * from pdf where partno='1014380000' and brandshort='Weidmüller' limit 1 [ RunTime:0.000614s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1014380000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.001633s ]
SELECT `id` FROM `stock` WHERE `id` <> 53670969 AND `partno` = '1014380000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.009053s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19661850 [ RunTime:0.005826s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57690072 LIMIT 5 [ RunTime:0.000719s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57690072 ORDER BY `minOrder` ASC [ RunTime:0.004206s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57690072 ORDER BY `unit` DESC [ RunTime:0.011551s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57690072 LIMIT 2 [ RunTime:0.020287s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57690072 ORDER BY `minOrder` ASC [ RunTime:0.003411s ]
select * from pdf where partno='1014317' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.002235s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1014317' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.023000s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57689856 LIMIT 5 [ RunTime:0.012387s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57689856 ORDER BY `minOrder` ASC [ RunTime:0.017346s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57689856 ORDER BY `unit` DESC [ RunTime:0.008251s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57689856 LIMIT 2 [ RunTime:0.011321s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57689856 ORDER BY `minOrder` ASC [ RunTime:0.000494s ]
select * from pdf where partno='1014315' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.000618s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1014315' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.007053s ]
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 '10143%' OR `brand` LIKE '10143%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002649s ]
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 '10143%' OR `brand` LIKE '10143%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001378s ]
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 '10143%' OR `brand` LIKE '10143%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001122s ]
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 '10143%' OR `brand` LIKE '10143%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.004294s ]
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 '10143%' OR `brand` LIKE '10143%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.005378s ]
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 '10143%' OR `brand` LIKE '10143%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.004694s ]
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 '10143%' OR `brand` LIKE '10143%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002759s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '10143%' OR `brand` LIKE '10143%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.009906s ]