SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002216s ]
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 '15022%' OR `brand` LIKE '15022%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.022344s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.000996s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14865853 LIMIT 5 [ RunTime:0.003920s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.000920s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14865853 ORDER BY `minOrder` ASC [ RunTime:0.002399s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.001117s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14865853 ORDER BY `unit` DESC [ RunTime:0.003054s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.004842s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14865853 LIMIT 2 [ RunTime:0.003397s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14865853 ORDER BY `minOrder` ASC [ RunTime:0.005522s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12230942 LIMIT 5 [ RunTime:0.002566s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12230942 ORDER BY `minOrder` ASC [ RunTime:0.001720s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12230942 ORDER BY `unit` DESC [ RunTime:0.001618s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12230942 LIMIT 2 [ RunTime:0.000840s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12230942 ORDER BY `minOrder` ASC [ RunTime:0.005337s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12231077 LIMIT 5 [ RunTime:0.006887s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12231077 ORDER BY `minOrder` ASC [ RunTime:0.006576s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12231077 ORDER BY `unit` DESC [ RunTime:0.024499s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12231077 LIMIT 2 [ RunTime:0.000549s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12231077 ORDER BY `minOrder` ASC [ RunTime:0.000344s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13957536 LIMIT 5 [ RunTime:0.002232s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13957536 ORDER BY `minOrder` ASC [ RunTime:0.006574s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13957536 ORDER BY `unit` DESC [ RunTime:0.004838s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13957536 LIMIT 2 [ RunTime:0.002938s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13957536 ORDER BY `minOrder` ASC [ RunTime:0.001205s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14865481 LIMIT 5 [ RunTime:0.024273s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14865481 ORDER BY `minOrder` ASC [ RunTime:0.004492s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14865481 ORDER BY `unit` DESC [ RunTime:0.019753s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14865481 LIMIT 2 [ RunTime:0.010055s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14865481 ORDER BY `minOrder` ASC [ RunTime:0.002592s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14881010 LIMIT 5 [ RunTime:0.021366s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14881010 ORDER BY `minOrder` ASC [ RunTime:0.010715s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14881010 ORDER BY `unit` DESC [ RunTime:0.004649s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14881010 LIMIT 2 [ RunTime:0.006905s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14881010 ORDER BY `minOrder` ASC [ RunTime:0.010787s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13957187 LIMIT 5 [ RunTime:0.025142s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13957187 ORDER BY `minOrder` ASC [ RunTime:0.036243s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13957187 ORDER BY `unit` DESC [ RunTime:0.012298s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13957187 LIMIT 2 [ RunTime:0.019017s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13957187 ORDER BY `minOrder` ASC [ RunTime:0.001518s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13961052 LIMIT 5 [ RunTime:0.019805s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13961052 ORDER BY `minOrder` ASC [ RunTime:0.005847s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13961052 ORDER BY `unit` DESC [ RunTime:0.005727s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13961052 LIMIT 2 [ RunTime:0.029133s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13961052 ORDER BY `minOrder` ASC [ RunTime:0.009530s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12674250 LIMIT 5 [ RunTime:0.009674s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12674250 ORDER BY `minOrder` ASC [ RunTime:0.019283s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12674250 ORDER BY `unit` DESC [ RunTime:0.019696s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12674250 LIMIT 2 [ RunTime:0.028782s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12674250 ORDER BY `minOrder` ASC [ RunTime:0.011162s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11230996 LIMIT 5 [ RunTime:0.010509s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11230996 ORDER BY `minOrder` ASC [ RunTime:0.029519s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11230996 ORDER BY `unit` DESC [ RunTime:0.030754s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11230996 LIMIT 2 [ RunTime:0.026796s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11230996 ORDER BY `minOrder` ASC [ RunTime:0.012864s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12233013 LIMIT 5 [ RunTime:0.014409s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12233013 ORDER BY `minOrder` ASC [ RunTime:0.018013s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12233013 ORDER BY `unit` DESC [ RunTime:0.071578s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12233013 LIMIT 2 [ RunTime:0.014335s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12233013 ORDER BY `minOrder` ASC [ RunTime:0.003584s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14863645 LIMIT 5 [ RunTime:0.023272s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14863645 ORDER BY `minOrder` ASC [ RunTime:0.026752s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14863645 ORDER BY `unit` DESC [ RunTime:0.033351s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14863645 LIMIT 2 [ RunTime:0.048393s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14863645 ORDER BY `minOrder` ASC [ RunTime:0.034247s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11524441 LIMIT 5 [ RunTime:0.022606s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11524441 ORDER BY `minOrder` ASC [ RunTime:0.027528s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11524441 ORDER BY `unit` DESC [ RunTime:0.032682s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11524441 LIMIT 2 [ RunTime:0.012829s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11524441 ORDER BY `minOrder` ASC [ RunTime:0.007520s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12233004 LIMIT 5 [ RunTime:0.010560s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12233004 ORDER BY `minOrder` ASC [ RunTime:0.011190s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12233004 ORDER BY `unit` DESC [ RunTime:0.034105s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12233004 LIMIT 2 [ RunTime:0.009970s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12233004 ORDER BY `minOrder` ASC [ RunTime:0.002763s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12674218 LIMIT 5 [ RunTime:0.031326s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12674218 ORDER BY `minOrder` ASC [ RunTime:0.023386s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12674218 ORDER BY `unit` DESC [ RunTime:0.034636s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12674218 LIMIT 2 [ RunTime:0.006544s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12674218 ORDER BY `minOrder` ASC [ RunTime:0.000896s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12634361 LIMIT 5 [ RunTime:0.001973s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12634361 ORDER BY `minOrder` ASC [ RunTime:0.008557s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12634361 ORDER BY `unit` DESC [ RunTime:0.000970s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12634361 LIMIT 2 [ RunTime:0.012582s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12634361 ORDER BY `minOrder` ASC [ RunTime:0.004755s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19650586 LIMIT 5 [ RunTime:0.030112s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19650586 ORDER BY `minOrder` ASC [ RunTime:0.066548s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19650586 ORDER BY `unit` DESC [ RunTime:0.024290s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19650586 LIMIT 2 [ RunTime:0.018627s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19650586 ORDER BY `minOrder` ASC [ RunTime:0.012293s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19646568 LIMIT 5 [ RunTime:0.042909s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19646568 ORDER BY `minOrder` ASC [ RunTime:0.020344s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19646568 ORDER BY `unit` DESC [ RunTime:0.051672s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19646568 LIMIT 2 [ RunTime:0.027501s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19646568 ORDER BY `minOrder` ASC [ RunTime:0.009021s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19019851 LIMIT 5 [ RunTime:0.060698s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19019851 ORDER BY `minOrder` ASC [ RunTime:0.048016s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19019851 ORDER BY `unit` DESC [ RunTime:0.058732s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19019851 LIMIT 2 [ RunTime:0.065386s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19019851 ORDER BY `minOrder` ASC [ RunTime:0.022251s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19019846 LIMIT 5 [ RunTime:0.050393s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19019846 ORDER BY `minOrder` ASC [ RunTime:0.034469s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19019846 ORDER BY `unit` DESC [ RunTime:0.023413s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19019846 LIMIT 2 [ RunTime:0.020001s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19019846 ORDER BY `minOrder` ASC [ RunTime:0.014398s ]
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 '15022%' OR `brand` LIKE '15022%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.029857s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51132753 LIMIT 5 [ RunTime:0.065235s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51132753 ORDER BY `minOrder` ASC [ RunTime:0.057501s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51132753 ORDER BY `unit` DESC [ RunTime:0.097309s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51132753 LIMIT 2 [ RunTime:0.068789s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51132753 ORDER BY `minOrder` ASC [ RunTime:0.013818s ]
select * from pdf where partno='15022-1030' and brandshort='molex' limit 1 [ RunTime:0.039388s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002342s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '15022-1030' OR `brand` LIKE 'molex%' ) ) LIMIT 1 [ RunTime:0.087986s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51132074 LIMIT 5 [ RunTime:0.067502s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51132074 ORDER BY `minOrder` ASC [ RunTime:0.037376s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51132074 ORDER BY `unit` DESC [ RunTime:0.091225s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51132074 LIMIT 2 [ RunTime:0.079049s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51132074 ORDER BY `minOrder` ASC [ RunTime:0.023539s ]
select * from pdf where partno='15022-1080' and brandshort='molex' limit 1 [ RunTime:0.060211s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '15022-1080' OR `brand` LIKE 'molex%' ) ) LIMIT 1 [ RunTime:0.055776s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51132752 LIMIT 5 [ RunTime:0.051293s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51132752 ORDER BY `minOrder` ASC [ RunTime:0.059067s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51132752 ORDER BY `unit` DESC [ RunTime:0.084757s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51132752 LIMIT 2 [ RunTime:0.009131s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51132752 ORDER BY `minOrder` ASC [ RunTime:0.007304s ]
select * from pdf where partno='15022-0880' and brandshort='molex' limit 1 [ RunTime:0.022661s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '15022-0880' OR `brand` LIKE 'molex%' ) ) LIMIT 1 [ RunTime:0.035902s ]
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 '15022%' OR `brand` LIKE '15022%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.017996s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 41338694 LIMIT 5 [ RunTime:0.036552s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41338694 ORDER BY `minOrder` ASC [ RunTime:0.028869s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 41338694 ORDER BY `unit` DESC [ RunTime:0.056168s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 41338694 LIMIT 2 [ RunTime:0.045913s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41338694 ORDER BY `minOrder` ASC [ RunTime:0.000698s ]
select * from pdf where partno='150224VS73100A' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.021085s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '150224VS73100A' OR `brand` LIKE 'Würth Elektronik%' ) ) LIMIT 1 [ RunTime:0.024752s ]
SELECT `id` FROM `stock` WHERE `id` <> 41338694 AND `partno` = '150224VS73100A' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%würth elektronik%' ) [ RunTime:0.039970s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 41338696 LIMIT 5 [ RunTime:0.080388s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41338696 ORDER BY `minOrder` ASC [ RunTime:0.041172s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 41338696 ORDER BY `unit` DESC [ RunTime:0.041133s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 41338696 LIMIT 2 [ RunTime:0.009016s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41338696 ORDER BY `minOrder` ASC [ RunTime:0.034195s ]
select * from pdf where partno='150224GS73100A' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.014287s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '150224GS73100A' OR `brand` LIKE 'Würth Elektronik%' ) ) LIMIT 1 [ RunTime:0.043512s ]
SELECT `id` FROM `stock` WHERE `id` <> 41338696 AND `partno` = '150224GS73100A' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%würth elektronik%' ) [ RunTime:0.057606s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 40312045 LIMIT 5 [ RunTime:0.061247s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40312045 ORDER BY `minOrder` ASC [ RunTime:0.043919s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 40312045 ORDER BY `unit` DESC [ RunTime:0.044385s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 40312045 LIMIT 2 [ RunTime:0.032724s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40312045 ORDER BY `minOrder` ASC [ RunTime:0.006172s ]
select * from pdf where partno='150225K100LE' and brandshort='Cornell Dubilier Knowles' limit 1 [ RunTime:0.019578s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '150225K100LE' OR `brand` LIKE 'Cornell Dubilier Knowles%' ) ) LIMIT 1 [ RunTime:0.016277s ]
SELECT `id` FROM `stock` WHERE `id` <> 40312045 AND `partno` = '150225K100LE' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cornell dubilier knowles%' ) [ RunTime:0.034069s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14865853 [ RunTime:0.039022s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 41341570 LIMIT 5 [ RunTime:0.032143s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41341570 ORDER BY `minOrder` ASC [ RunTime:0.019638s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 41341570 ORDER BY `unit` DESC [ RunTime:0.028594s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 41341570 LIMIT 2 [ RunTime:0.025998s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41341570 ORDER BY `minOrder` ASC [ RunTime:0.011324s ]
select * from pdf where partno='150224AS73100' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.018371s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '150224AS73100' OR `brand` LIKE 'Würth Elektronik%' ) ) LIMIT 1 [ RunTime:0.030814s ]
SELECT `id` FROM `stock` WHERE `id` <> 41341570 AND `partno` = '150224AS73100' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%würth elektronik%' ) [ RunTime:0.014877s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12233004 [ RunTime:0.027355s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 41338716 LIMIT 5 [ RunTime:0.007305s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41338716 ORDER BY `minOrder` ASC [ RunTime:0.015532s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 41338716 ORDER BY `unit` DESC [ RunTime:0.025708s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 41338716 LIMIT 2 [ RunTime:0.019624s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41338716 ORDER BY `minOrder` ASC [ RunTime:0.015156s ]
select * from pdf where partno='150224RS73100A' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.025537s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '150224RS73100A' OR `brand` LIKE 'Würth Elektronik%' ) ) LIMIT 1 [ RunTime:0.023255s ]
SELECT `id` FROM `stock` WHERE `id` <> 41338716 AND `partno` = '150224RS73100A' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%würth elektronik%' ) [ RunTime:0.013721s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11230997 [ RunTime:0.032293s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 41342125 LIMIT 5 [ RunTime:0.005202s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41342125 ORDER BY `minOrder` ASC [ RunTime:0.031678s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 41342125 ORDER BY `unit` DESC [ RunTime:0.005418s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 41342125 LIMIT 2 [ RunTime:0.010440s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41342125 ORDER BY `minOrder` ASC [ RunTime:0.005884s ]
select * from pdf where partno='150224YS73100' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.004867s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '150224YS73100' OR `brand` LIKE 'Würth Elektronik%' ) ) LIMIT 1 [ RunTime:0.027456s ]
SELECT `id` FROM `stock` WHERE `id` <> 41342125 AND `partno` = '150224YS73100' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%würth elektronik%' ) [ RunTime:0.017390s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 41340304 LIMIT 5 [ RunTime:0.014659s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41340304 ORDER BY `minOrder` ASC [ RunTime:0.017856s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 41340304 ORDER BY `unit` DESC [ RunTime:0.023129s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 41340304 LIMIT 2 [ RunTime:0.041414s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41340304 ORDER BY `minOrder` ASC [ RunTime:0.035036s ]
select * from pdf where partno='150224SS73100' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.013286s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '150224SS73100' OR `brand` LIKE 'Würth Elektronik%' ) ) LIMIT 1 [ RunTime:0.018394s ]
SELECT `id` FROM `stock` WHERE `id` <> 41340304 AND `partno` = '150224SS73100' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%würth elektronik%' ) [ RunTime:0.012514s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12233013 [ RunTime:0.020394s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 41340595 LIMIT 5 [ RunTime:0.048761s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41340595 ORDER BY `minOrder` ASC [ RunTime:0.033226s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 41340595 ORDER BY `unit` DESC [ RunTime:0.008198s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 41340595 LIMIT 2 [ RunTime:0.015572s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41340595 ORDER BY `minOrder` ASC [ RunTime:0.018984s ]
select * from pdf where partno='150224BS73100' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.021030s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '150224BS73100' OR `brand` LIKE 'Würth Elektronik%' ) ) LIMIT 1 [ RunTime:0.020824s ]
SELECT `id` FROM `stock` WHERE `id` <> 41340595 AND `partno` = '150224BS73100' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%würth elektronik%' ) [ RunTime:0.038661s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12230942 [ RunTime:0.007301s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59750581 LIMIT 5 [ RunTime:0.009486s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59750581 ORDER BY `minOrder` ASC [ RunTime:0.036230s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59750581 ORDER BY `unit` DESC [ RunTime:0.028263s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59750581 LIMIT 2 [ RunTime:0.040145s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59750581 ORDER BY `minOrder` ASC [ RunTime:0.003313s ]
select * from pdf where partno='150220-6002-RB' and brandshort='3M' limit 1 [ RunTime:0.011978s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '150220-6002-RB' OR `brand` LIKE '3M%' ) ) LIMIT 1 [ RunTime:0.035799s ]
SELECT `id` FROM `stock` WHERE `id` <> 59750581 AND `partno` = '150220-6002-RB' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%3m%' ) [ RunTime:0.029529s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12671485 [ RunTime:0.059328s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 40308454 LIMIT 5 [ RunTime:0.020210s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40308454 ORDER BY `minOrder` ASC [ RunTime:0.043704s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 40308454 ORDER BY `unit` DESC [ RunTime:0.034074s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 40308454 LIMIT 2 [ RunTime:0.010501s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40308454 ORDER BY `minOrder` ASC [ RunTime:0.012529s ]
select * from pdf where partno='150224J400FE' and brandshort='Cornell Dubilier Knowles' limit 1 [ RunTime:0.038716s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '150224J400FE' OR `brand` LIKE 'Cornell Dubilier Knowles%' ) ) LIMIT 1 [ RunTime:0.031753s ]
SELECT `id` FROM `stock` WHERE `id` <> 40308454 AND `partno` = '150224J400FE' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cornell dubilier knowles%' ) [ RunTime:0.010763s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13957536 [ RunTime:0.053350s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 40311380 LIMIT 5 [ RunTime:0.022246s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40311380 ORDER BY `minOrder` ASC [ RunTime:0.030640s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 40311380 ORDER BY `unit` DESC [ RunTime:0.058112s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 40311380 LIMIT 2 [ RunTime:0.009377s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40311380 ORDER BY `minOrder` ASC [ RunTime:0.005758s ]
select * from pdf where partno='150223K630DB' and brandshort='Cornell Dubilier Knowles' limit 1 [ RunTime:0.016005s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '150223K630DB' OR `brand` LIKE 'Cornell Dubilier Knowles%' ) ) LIMIT 1 [ RunTime:0.059606s ]
SELECT `id` FROM `stock` WHERE `id` <> 40311380 AND `partno` = '150223K630DB' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cornell dubilier knowles%' ) [ RunTime:0.023911s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13961052 [ RunTime:0.043989s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 41340873 LIMIT 5 [ RunTime:0.011204s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41340873 ORDER BY `minOrder` ASC [ RunTime:0.013739s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 41340873 ORDER BY `unit` DESC [ RunTime:0.039799s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 41340873 LIMIT 2 [ RunTime:0.047382s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41340873 ORDER BY `minOrder` ASC [ RunTime:0.000607s ]
select * from pdf where partno='150224GS73100' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.014656s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '150224GS73100' OR `brand` LIKE 'Würth Elektronik%' ) ) LIMIT 1 [ RunTime:0.014123s ]
SELECT `id` FROM `stock` WHERE `id` <> 41340873 AND `partno` = '150224GS73100' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%würth elektronik%' ) [ RunTime:0.037458s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12231077 [ RunTime:0.012446s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 40311405 LIMIT 5 [ RunTime:0.025120s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40311405 ORDER BY `minOrder` ASC [ RunTime:0.020167s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 40311405 ORDER BY `unit` DESC [ RunTime:0.010644s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 40311405 LIMIT 2 [ RunTime:0.010801s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40311405 ORDER BY `minOrder` ASC [ RunTime:0.008505s ]
select * from pdf where partno='150223J400BB' and brandshort='Cornell Dubilier Knowles' limit 1 [ RunTime:0.021766s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '150223J400BB' OR `brand` LIKE 'Cornell Dubilier Knowles%' ) ) LIMIT 1 [ RunTime:0.062313s ]
SELECT `id` FROM `stock` WHERE `id` <> 40311405 AND `partno` = '150223J400BB' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cornell dubilier knowles%' ) [ RunTime:0.061923s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14881010 [ RunTime:0.028605s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 40310997 LIMIT 5 [ RunTime:0.013068s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40310997 ORDER BY `minOrder` ASC [ RunTime:0.034946s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 40310997 ORDER BY `unit` DESC [ RunTime:0.010027s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 40310997 LIMIT 2 [ RunTime:0.026625s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40310997 ORDER BY `minOrder` ASC [ RunTime:0.008243s ]
select * from pdf where partno='150223J250BB' and brandshort='Cornell Dubilier Knowles' limit 1 [ RunTime:0.022797s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '150223J250BB' OR `brand` LIKE 'Cornell Dubilier Knowles%' ) ) LIMIT 1 [ RunTime:0.010963s ]
SELECT `id` FROM `stock` WHERE `id` <> 40310997 AND `partno` = '150223J250BB' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cornell dubilier knowles%' ) [ RunTime:0.033788s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 40308249 LIMIT 5 [ RunTime:0.017972s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40308249 ORDER BY `minOrder` ASC [ RunTime:0.082977s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 40308249 ORDER BY `unit` DESC [ RunTime:0.042100s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 40308249 LIMIT 2 [ RunTime:0.043625s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40308249 ORDER BY `minOrder` ASC [ RunTime:0.002973s ]
select * from pdf where partno='150222J630BB' and brandshort='Cornell Dubilier Knowles' limit 1 [ RunTime:0.087504s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '150222J630BB' OR `brand` LIKE 'Cornell Dubilier Knowles%' ) ) LIMIT 1 [ RunTime:0.054891s ]
SELECT `id` FROM `stock` WHERE `id` <> 40308249 AND `partno` = '150222J630BB' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cornell dubilier knowles%' ) [ RunTime:0.029727s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14863645 [ RunTime:0.043919s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59752981 LIMIT 5 [ RunTime:0.045778s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59752981 ORDER BY `minOrder` ASC [ RunTime:0.016506s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59752981 ORDER BY `unit` DESC [ RunTime:0.045692s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59752981 LIMIT 2 [ RunTime:0.061585s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59752981 ORDER BY `minOrder` ASC [ RunTime:0.013168s ]
select * from pdf where partno='150226-6002-RB' and brandshort='3M' limit 1 [ RunTime:0.037391s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '150226-6002-RB' OR `brand` LIKE '3M%' ) ) LIMIT 1 [ RunTime:0.027849s ]
SELECT `id` FROM `stock` WHERE `id` <> 59752981 AND `partno` = '150226-6002-RB' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%3m%' ) [ RunTime:0.022075s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12674218 [ RunTime:0.122032s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59754720 LIMIT 5 [ RunTime:0.124649s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59754720 ORDER BY `minOrder` ASC [ RunTime:0.114140s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59754720 ORDER BY `unit` DESC [ RunTime:0.048367s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59754720 LIMIT 2 [ RunTime:0.074128s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59754720 ORDER BY `minOrder` ASC [ RunTime:0.026412s ]
select * from pdf where partno='150228-6002-RB' and brandshort='3M' limit 1 [ RunTime:0.025073s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '150228-6002-RB' OR `brand` LIKE '3M%' ) ) LIMIT 1 [ RunTime:0.081553s ]
SELECT `id` FROM `stock` WHERE `id` <> 59754720 AND `partno` = '150228-6002-RB' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%3m%' ) [ RunTime:0.056774s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12674250 [ RunTime:0.049116s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 40308364 LIMIT 5 [ RunTime:0.044645s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40308364 ORDER BY `minOrder` ASC [ RunTime:0.049613s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 40308364 ORDER BY `unit` DESC [ RunTime:0.039843s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 40308364 LIMIT 2 [ RunTime:0.033474s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40308364 ORDER BY `minOrder` ASC [ RunTime:0.029308s ]
select * from pdf where partno='150223J630DB' and brandshort='Cornell Dubilier Knowles' limit 1 [ RunTime:0.059729s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '150223J630DB' OR `brand` LIKE 'Cornell Dubilier Knowles%' ) ) LIMIT 1 [ RunTime:0.007070s ]
SELECT `id` FROM `stock` WHERE `id` <> 40308364 AND `partno` = '150223J630DB' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cornell dubilier knowles%' ) [ RunTime:0.029327s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13957187 [ RunTime:0.033877s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 40311904 LIMIT 5 [ RunTime:0.028238s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40311904 ORDER BY `minOrder` ASC [ RunTime:0.074100s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 40311904 ORDER BY `unit` DESC [ RunTime:0.062710s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 40311904 LIMIT 2 [ RunTime:0.019760s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40311904 ORDER BY `minOrder` ASC [ RunTime:0.023987s ]
select * from pdf where partno='150224J630LE' and brandshort='Cornell Dubilier Knowles' limit 1 [ RunTime:0.057812s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '150224J630LE' OR `brand` LIKE 'Cornell Dubilier Knowles%' ) ) LIMIT 1 [ RunTime:0.035001s ]
SELECT `id` FROM `stock` WHERE `id` <> 40311904 AND `partno` = '150224J630LE' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cornell dubilier knowles%' ) [ RunTime:0.035038s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14865481 [ RunTime:0.043114s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59759376 LIMIT 5 [ RunTime:0.031445s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59759376 ORDER BY `minOrder` ASC [ RunTime:0.075037s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59759376 ORDER BY `unit` DESC [ RunTime:0.012712s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59759376 LIMIT 2 [ RunTime:0.044202s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59759376 ORDER BY `minOrder` ASC [ RunTime:0.005305s ]
select * from pdf where partno='150220-2000-RB' and brandshort='3M' limit 1 [ RunTime:0.039736s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '150220-2000-RB' OR `brand` LIKE '3M%' ) ) LIMIT 1 [ RunTime:0.035002s ]
SELECT `id` FROM `stock` WHERE `id` <> 59759376 AND `partno` = '150220-2000-RB' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%3m%' ) [ RunTime:0.046494s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12634361 [ RunTime:0.008372s ]
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 '15022%' OR `brand` LIKE '15022%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.037409s ]
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 '15022%' OR `brand` LIKE '15022%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.017253s ]
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 '15022%' OR `brand` LIKE '15022%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.026689s ]
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 '15022%' OR `brand` LIKE '15022%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.041419s ]
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 '15022%' OR `brand` LIKE '15022%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.016294s ]
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 '15022%' OR `brand` LIKE '15022%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.023447s ]
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 '15022%' OR `brand` LIKE '15022%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.031146s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '15022%' OR `brand` LIKE '15022%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.054287s ]