SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002129s ]
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 'BC807-25W%' OR `brand` LIKE 'BC807-25W%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.069486s ]
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 'BC807-25W%' OR `brand` LIKE 'BC807-25W%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.027981s ]
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 'BC807-25W%' OR `brand` LIKE 'BC807-25W%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.048084s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.002478s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51737565 LIMIT 5 [ RunTime:0.033422s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.007013s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51737565 ORDER BY `minOrder` ASC [ RunTime:0.020889s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.017805s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51737565 ORDER BY `unit` DESC [ RunTime:0.042821s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.022631s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51737565 LIMIT 2 [ RunTime:0.060851s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51737565 ORDER BY `minOrder` ASC [ RunTime:0.019185s ]
select * from pdf where partno='BC807-25WE6327' and brandshort='Infineon Technologies' limit 1 [ RunTime:0.062634s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001491s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BC807-25WE6327' OR `brand` LIKE 'Infineon Technologies%' ) ) LIMIT 1 [ RunTime:0.026097s ]
SELECT `id` FROM `stock` WHERE `id` <> 51737565 AND `partno` = 'BC807-25WE6327' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%infineon technologies%' ) [ RunTime:0.037674s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51736340 LIMIT 5 [ RunTime:0.006591s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51736340 ORDER BY `minOrder` ASC [ RunTime:0.037469s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51736340 ORDER BY `unit` DESC [ RunTime:0.011602s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51736340 LIMIT 2 [ RunTime:0.023063s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51736340 ORDER BY `minOrder` ASC [ RunTime:0.011542s ]
select * from pdf where partno='BC807-25WT1G' and brandshort='onsemi' limit 1 [ RunTime:0.026269s ]
select foldpath,foldpath2,filename from pdf_file where id=2030316 limit 1 [ RunTime:0.065614s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BC807-25WT1G' OR `brand` LIKE 'onsemi%' ) ) LIMIT 1 [ RunTime:0.014009s ]
SELECT `id` FROM `stock` WHERE `id` <> 51736340 AND `partno` = 'BC807-25WT1G' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%onsemi%' ) [ RunTime:0.011447s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51737041 LIMIT 5 [ RunTime:0.017542s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51737041 ORDER BY `minOrder` ASC [ RunTime:0.025916s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51737041 ORDER BY `unit` DESC [ RunTime:0.002920s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51737041 LIMIT 2 [ RunTime:0.024258s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51737041 ORDER BY `minOrder` ASC [ RunTime:0.002389s ]
select * from pdf where partno='BC807-25W RFG' and brandshort='Taiwan Semiconductor Corporation' limit 1 [ RunTime:0.031335s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BC807-25W RFG' OR `brand` LIKE 'Taiwan Semiconductor Corporation%' ) ) LIMIT 1 [ RunTime:0.022925s ]
SELECT `id` FROM `stock` WHERE `id` <> 51737041 AND `partno` = 'BC807-25W RFG' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%taiwan semiconductor corporation%' ) [ RunTime:0.006413s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51737350 LIMIT 5 [ RunTime:0.018543s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51737350 ORDER BY `minOrder` ASC [ RunTime:0.021338s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51737350 ORDER BY `unit` DESC [ RunTime:0.022443s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51737350 LIMIT 2 [ RunTime:0.010340s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51737350 ORDER BY `minOrder` ASC [ RunTime:0.008926s ]
select * from pdf where partno='BC807-25WH RFG' and brandshort='Taiwan Semiconductor Corporation' limit 1 [ RunTime:0.000924s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BC807-25WH RFG' OR `brand` LIKE 'Taiwan Semiconductor Corporation%' ) ) LIMIT 1 [ RunTime:0.004126s ]
SELECT `id` FROM `stock` WHERE `id` <> 51737350 AND `partno` = 'BC807-25WH RFG' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%taiwan semiconductor corporation%' ) [ RunTime:0.004002s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51738669 LIMIT 5 [ RunTime:0.016227s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51738669 ORDER BY `minOrder` ASC [ RunTime:0.033882s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51738669 ORDER BY `unit` DESC [ RunTime:0.053324s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51738669 LIMIT 2 [ RunTime:0.010773s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51738669 ORDER BY `minOrder` ASC [ RunTime:0.015175s ]
select * from pdf where partno='BC807-25W-AU_R1_000A1' and brandshort='Panjit International Inc.' limit 1 [ RunTime:0.004140s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BC807-25W-AU_R1_000A1' OR `brand` LIKE 'Panjit International Inc.%' ) ) LIMIT 1 [ RunTime:0.008195s ]
SELECT `id` FROM `stock` WHERE `id` <> 51738669 AND `partno` = 'BC807-25W-AU_R1_000A1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%panjit international inc.%' ) [ RunTime:0.008615s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51736989 LIMIT 5 [ RunTime:0.008114s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51736989 ORDER BY `minOrder` ASC [ RunTime:0.010055s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51736989 ORDER BY `unit` DESC [ RunTime:0.000951s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51736989 LIMIT 2 [ RunTime:0.009362s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51736989 ORDER BY `minOrder` ASC [ RunTime:0.000518s ]
select * from pdf where partno='BC807-25W_R1_00001' and brandshort='Panjit International Inc.' limit 1 [ RunTime:0.001122s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BC807-25W_R1_00001' OR `brand` LIKE 'Panjit International Inc.%' ) ) LIMIT 1 [ RunTime:0.006308s ]
SELECT `id` FROM `stock` WHERE `id` <> 51736989 AND `partno` = 'BC807-25W_R1_00001' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%panjit international inc.%' ) [ RunTime:0.000697s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51736308 LIMIT 5 [ RunTime:0.000471s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51736308 ORDER BY `minOrder` ASC [ RunTime:0.000714s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51736308 ORDER BY `unit` DESC [ RunTime:0.002863s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51736308 LIMIT 2 [ RunTime:0.005288s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51736308 ORDER BY `minOrder` ASC [ RunTime:0.001798s ]
select * from pdf where partno='BC807-25W' and brandshort='Diotec Semiconductor' limit 1 [ RunTime:0.007458s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BC807-25W' OR `brand` LIKE 'Diotec Semiconductor%' ) ) LIMIT 1 [ RunTime:0.001709s ]
SELECT `id` FROM `stock` WHERE `id` <> 51736308 AND `partno` = 'BC807-25W' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%diotec semiconductor%' ) [ RunTime:0.004779s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51740851 LIMIT 5 [ RunTime:0.005277s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51740851 ORDER BY `minOrder` ASC [ RunTime:0.005451s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51740851 ORDER BY `unit` DESC [ RunTime:0.014271s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51740851 LIMIT 2 [ RunTime:0.016018s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51740851 ORDER BY `minOrder` ASC [ RunTime:0.003827s ]
select * from pdf where partno='BC807-25W-QX' and brandshort='Nexperia USA Inc.' limit 1 [ RunTime:0.025070s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BC807-25W-QX' OR `brand` LIKE 'Nexperia USA Inc.%' ) ) LIMIT 1 [ RunTime:0.000790s ]
SELECT `id` FROM `stock` WHERE `id` <> 51740851 AND `partno` = 'BC807-25W-QX' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%nexperia usa inc.%' ) [ RunTime:0.017961s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51744081 LIMIT 5 [ RunTime:0.000549s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51744081 ORDER BY `minOrder` ASC [ RunTime:0.001844s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51744081 ORDER BY `unit` DESC [ RunTime:0.002775s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51744081 LIMIT 2 [ RunTime:0.006203s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51744081 ORDER BY `minOrder` ASC [ RunTime:0.009803s ]
select * from pdf where partno='BC807-25W' and brandshort='Taiwan Semiconductor Corporation' limit 1 [ RunTime:0.005149s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BC807-25W' OR `brand` LIKE 'Taiwan Semiconductor Corporation%' ) ) LIMIT 1 [ RunTime:0.000645s ]
SELECT `id` FROM `stock` WHERE `id` <> 51744081 AND `partno` = 'BC807-25W' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%taiwan semiconductor corporation%' ) [ RunTime:0.000677s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51743915 LIMIT 5 [ RunTime:0.000398s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51743915 ORDER BY `minOrder` ASC [ RunTime:0.002454s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51743915 ORDER BY `unit` DESC [ RunTime:0.008386s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51743915 LIMIT 2 [ RunTime:0.013142s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51743915 ORDER BY `minOrder` ASC [ RunTime:0.017618s ]
select * from pdf where partno='BC807-25WHE3-TP' and brandshort='MCC Micro Commercial Components' limit 1 [ RunTime:0.023489s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BC807-25WHE3-TP' OR `brand` LIKE 'MCC (Micro Commercial Components)%' ) ) LIMIT 1 [ RunTime:0.002801s ]
SELECT `id` FROM `stock` WHERE `id` <> 51743915 AND `partno` = 'BC807-25WHE3-TP' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%mcc%' ) [ RunTime:0.011532s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51742822 LIMIT 5 [ RunTime:0.012173s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51742822 ORDER BY `minOrder` ASC [ RunTime:0.011748s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51742822 ORDER BY `unit` DESC [ RunTime:0.007253s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51742822 LIMIT 2 [ RunTime:0.001304s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51742822 ORDER BY `minOrder` ASC [ RunTime:0.000328s ]
select * from pdf where partno='BC807-25W-QF' and brandshort='Nexperia USA Inc.' limit 1 [ RunTime:0.002145s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BC807-25W-QF' OR `brand` LIKE 'Nexperia USA Inc.%' ) ) LIMIT 1 [ RunTime:0.002368s ]
SELECT `id` FROM `stock` WHERE `id` <> 51742822 AND `partno` = 'BC807-25W-QF' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%nexperia usa inc.%' ) [ RunTime:0.009539s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51742074 LIMIT 5 [ RunTime:0.006709s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51742074 ORDER BY `minOrder` ASC [ RunTime:0.014647s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51742074 ORDER BY `unit` DESC [ RunTime:0.002879s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51742074 LIMIT 2 [ RunTime:0.006112s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51742074 ORDER BY `minOrder` ASC [ RunTime:0.007182s ]
select * from pdf where partno='BC807-25W,135' and brandshort='Nexperia USA Inc.' limit 1 [ RunTime:0.006075s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BC807-25W,135' OR `brand` LIKE 'Nexperia USA Inc.%' ) ) LIMIT 1 [ RunTime:0.008056s ]
SELECT `id` FROM `stock` WHERE `id` <> 51742074 AND `partno` = 'BC807-25W,135' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%nexperia usa inc.%' ) [ RunTime:0.012621s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51741758 LIMIT 5 [ RunTime:0.013172s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51741758 ORDER BY `minOrder` ASC [ RunTime:0.008186s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51741758 ORDER BY `unit` DESC [ RunTime:0.004638s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51741758 LIMIT 2 [ RunTime:0.004000s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51741758 ORDER BY `minOrder` ASC [ RunTime:0.005763s ]
select * from pdf where partno='BC807-25W-7' and brandshort='Diodes Incorporated' limit 1 [ RunTime:0.026347s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BC807-25W-7' OR `brand` LIKE 'Diodes Incorporated%' ) ) LIMIT 1 [ RunTime:0.016612s ]
SELECT `id` FROM `stock` WHERE `id` <> 51741758 AND `partno` = 'BC807-25W-7' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%diodes incorporated%' ) [ RunTime:0.000666s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51741683 LIMIT 5 [ RunTime:0.002343s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51741683 ORDER BY `minOrder` ASC [ RunTime:0.007244s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51741683 ORDER BY `unit` DESC [ RunTime:0.002113s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51741683 LIMIT 2 [ RunTime:0.000388s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51741683 ORDER BY `minOrder` ASC [ RunTime:0.000296s ]
select * from pdf where partno='BC807-25W,115' and brandshort='Nexperia USA Inc.' limit 1 [ RunTime:0.000863s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BC807-25W,115' OR `brand` LIKE 'Nexperia USA Inc.%' ) ) LIMIT 1 [ RunTime:0.002155s ]
SELECT `id` FROM `stock` WHERE `id` <> 51741683 AND `partno` = 'BC807-25W,115' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%nexperia usa inc.%' ) [ RunTime:0.000535s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 44707479 LIMIT 5 [ RunTime:0.003990s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44707479 ORDER BY `minOrder` ASC [ RunTime:0.006951s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 44707479 ORDER BY `unit` DESC [ RunTime:0.002588s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 44707479 LIMIT 2 [ RunTime:0.021021s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44707479 ORDER BY `minOrder` ASC [ RunTime:0.000530s ]
select * from pdf where partno='BC807-25W-TP' and brandshort='MCC Micro Commercial Components' limit 1 [ RunTime:0.001120s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BC807-25W-TP' OR `brand` LIKE 'MCC (Micro Commercial Components)%' ) ) LIMIT 1 [ RunTime:0.003315s ]
SELECT `id` FROM `stock` WHERE `id` <> 44707479 AND `partno` = 'BC807-25W-TP' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%mcc%' ) [ RunTime:0.011580s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33194247 [ RunTime:0.017974s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33194247 LIMIT 5 [ RunTime:0.018122s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33194247 ORDER BY `minOrder` ASC [ RunTime:0.007763s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33194247 ORDER BY `unit` DESC [ RunTime:0.008041s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33194247 LIMIT 2 [ RunTime:0.010368s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33194247 ORDER BY `minOrder` ASC [ RunTime:0.004999s ]
select * from pdf where partno='BC807-25W-TP' and brandshort='MCC Micro Commercial Components' limit 1 [ RunTime:0.004407s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BC807-25W-TP' OR `brand` LIKE 'MCC (Micro Commercial Components)%' ) ) LIMIT 1 [ RunTime:0.002497s ]
SELECT `id` FROM `stock` WHERE `id` <> 33194247 AND `partno` = 'BC807-25W-TP' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%mcc%' ) [ RunTime:0.007528s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 44707479 [ RunTime:0.009321s ]
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 'BC807-25W%' OR `brand` LIKE 'BC807-25W%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.005519s ]
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 'BC807-25W%' OR `brand` LIKE 'BC807-25W%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.012077s ]
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 'BC807-25W%' OR `brand` LIKE 'BC807-25W%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.017792s ]
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 'BC807-25W%' OR `brand` LIKE 'BC807-25W%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003376s ]
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 'BC807-25W%' OR `brand` LIKE 'BC807-25W%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.010184s ]
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 'BC807-25W%' OR `brand` LIKE 'BC807-25W%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.011259s ]
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 'BC807-25W%' OR `brand` LIKE 'BC807-25W%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.028556s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'BC807-25W%' OR `brand` LIKE 'BC807-25W%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.016512s ]