SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002214s ]
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 '1069902%' OR `brand` LIKE '1069902%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.018403s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.003440s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12397227 LIMIT 5 [ RunTime:0.015755s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001672s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12397227 ORDER BY `minOrder` ASC [ RunTime:0.001008s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.003014s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12397227 ORDER BY `unit` DESC [ RunTime:0.007930s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.001912s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12397227 LIMIT 2 [ RunTime:0.014551s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12397227 ORDER BY `minOrder` ASC [ RunTime:0.003089s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14700971 LIMIT 5 [ RunTime:0.002511s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14700971 ORDER BY `minOrder` ASC [ RunTime:0.005455s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14700971 ORDER BY `unit` DESC [ RunTime:0.030058s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14700971 LIMIT 2 [ RunTime:0.006231s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14700971 ORDER BY `minOrder` ASC [ RunTime:0.020947s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13388249 LIMIT 5 [ RunTime:0.010792s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13388249 ORDER BY `minOrder` ASC [ RunTime:0.000876s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13388249 ORDER BY `unit` DESC [ RunTime:0.006607s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13388249 LIMIT 2 [ RunTime:0.004454s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13388249 ORDER BY `minOrder` ASC [ RunTime:0.032913s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17858051 LIMIT 5 [ RunTime:0.017207s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17858051 ORDER BY `minOrder` ASC [ RunTime:0.047795s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17858051 ORDER BY `unit` DESC [ RunTime:0.032581s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17858051 LIMIT 2 [ RunTime:0.007108s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17858051 ORDER BY `minOrder` ASC [ RunTime:0.030902s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18775124 LIMIT 5 [ RunTime:0.065231s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18775124 ORDER BY `minOrder` ASC [ RunTime:0.003811s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18775124 ORDER BY `unit` DESC [ RunTime:0.016474s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18775124 LIMIT 2 [ RunTime:0.019496s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18775124 ORDER BY `minOrder` ASC [ RunTime:0.014865s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17858483 LIMIT 5 [ RunTime:0.036238s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17858483 ORDER BY `minOrder` ASC [ RunTime:0.039883s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17858483 ORDER BY `unit` DESC [ RunTime:0.009266s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17858483 LIMIT 2 [ RunTime:0.042137s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17858483 ORDER BY `minOrder` ASC [ RunTime:0.003553s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17858470 LIMIT 5 [ RunTime:0.029506s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17858470 ORDER BY `minOrder` ASC [ RunTime:0.013518s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17858470 ORDER BY `unit` DESC [ RunTime:0.085287s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17858470 LIMIT 2 [ RunTime:0.037786s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17858470 ORDER BY `minOrder` ASC [ RunTime:0.021364s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17858469 LIMIT 5 [ RunTime:0.008674s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17858469 ORDER BY `minOrder` ASC [ RunTime:0.047021s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17858469 ORDER BY `unit` DESC [ RunTime:0.054662s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17858469 LIMIT 2 [ RunTime:0.040010s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17858469 ORDER BY `minOrder` ASC [ RunTime:0.016069s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17858468 LIMIT 5 [ RunTime:0.051959s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17858468 ORDER BY `minOrder` ASC [ RunTime:0.040454s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17858468 ORDER BY `unit` DESC [ RunTime:0.029899s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17858468 LIMIT 2 [ RunTime:0.035528s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17858468 ORDER BY `minOrder` ASC [ RunTime:0.043910s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17858467 LIMIT 5 [ RunTime:0.024097s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17858467 ORDER BY `minOrder` ASC [ RunTime:0.018458s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17858467 ORDER BY `unit` DESC [ RunTime:0.047103s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17858467 LIMIT 2 [ RunTime:0.044942s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17858467 ORDER BY `minOrder` ASC [ RunTime:0.024099s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17858466 LIMIT 5 [ RunTime:0.066560s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17858466 ORDER BY `minOrder` ASC [ RunTime:0.017758s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17858466 ORDER BY `unit` DESC [ RunTime:0.083963s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17858466 LIMIT 2 [ RunTime:0.073609s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17858466 ORDER BY `minOrder` ASC [ RunTime:0.060941s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17858465 LIMIT 5 [ RunTime:0.032443s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17858465 ORDER BY `minOrder` ASC [ RunTime:0.029924s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17858465 ORDER BY `unit` DESC [ RunTime:0.043034s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17858465 LIMIT 2 [ RunTime:0.032969s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17858465 ORDER BY `minOrder` ASC [ RunTime:0.033576s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13786309 LIMIT 5 [ RunTime:0.036508s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13786309 ORDER BY `minOrder` ASC [ RunTime:0.066870s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13786309 ORDER BY `unit` DESC [ RunTime:0.031482s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13786309 LIMIT 2 [ RunTime:0.030290s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13786309 ORDER BY `minOrder` ASC [ RunTime:0.013781s ]
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 '1069902%' OR `brand` LIKE '1069902%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.058039s ]
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 '1069902%' OR `brand` LIKE '1069902%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.023937s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62448021 LIMIT 5 [ RunTime:0.046886s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62448021 ORDER BY `minOrder` ASC [ RunTime:0.015613s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62448021 ORDER BY `unit` DESC [ RunTime:0.044237s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62448021 LIMIT 2 [ RunTime:0.004048s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62448021 ORDER BY `minOrder` ASC [ RunTime:0.004194s ]
select * from pdf where partno='106990248' and brandshort='Seeed Technology Co., Ltd' limit 1 [ RunTime:0.020573s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002545s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '106990248' OR `brand` LIKE 'Seeed Technology Co., Ltd%' ) ) LIMIT 1 [ RunTime:0.023036s ]
SELECT `id` FROM `stock` WHERE `id` <> 62448021 AND `partno` = '106990248' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%seeed technology co., ltd%' ) [ RunTime:0.040025s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14700971 [ RunTime:0.018889s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64021214 LIMIT 5 [ RunTime:0.015147s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64021214 ORDER BY `minOrder` ASC [ RunTime:0.028737s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64021214 ORDER BY `unit` DESC [ RunTime:0.007703s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64021214 LIMIT 2 [ RunTime:0.025843s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64021214 ORDER BY `minOrder` ASC [ RunTime:0.014716s ]
select * from pdf where partno='106990290' and brandshort='Seeed Technology Co., Ltd' limit 1 [ RunTime:0.026758s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '106990290' OR `brand` LIKE 'Seeed Technology Co., Ltd%' ) ) LIMIT 1 [ RunTime:0.008695s ]
SELECT `id` FROM `stock` WHERE `id` <> 64021214 AND `partno` = '106990290' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%seeed technology co., ltd%' ) [ RunTime:0.019825s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12397227 [ RunTime:0.000998s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58105305 LIMIT 5 [ RunTime:0.012547s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58105305 ORDER BY `minOrder` ASC [ RunTime:0.021898s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58105305 ORDER BY `unit` DESC [ RunTime:0.002670s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58105305 LIMIT 2 [ RunTime:0.001627s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58105305 ORDER BY `minOrder` ASC [ RunTime:0.000545s ]
select * from pdf where partno='106990288' and brandshort='Seeed Technology Co., Ltd' limit 1 [ RunTime:0.007541s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '106990288' OR `brand` LIKE 'Seeed Technology Co., Ltd%' ) ) LIMIT 1 [ RunTime:0.022274s ]
SELECT `id` FROM `stock` WHERE `id` <> 58105305 AND `partno` = '106990288' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%seeed technology co., ltd%' ) [ RunTime:0.045818s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13388249 [ RunTime:0.004161s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58164031 LIMIT 5 [ RunTime:0.010441s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58164031 ORDER BY `minOrder` ASC [ RunTime:0.035449s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58164031 ORDER BY `unit` DESC [ RunTime:0.027680s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58164031 LIMIT 2 [ RunTime:0.011353s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58164031 ORDER BY `minOrder` ASC [ RunTime:0.007030s ]
select * from pdf where partno='106990249' and brandshort='Seeed Technology Co., Ltd' limit 1 [ RunTime:0.018363s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '106990249' OR `brand` LIKE 'Seeed Technology Co., Ltd%' ) ) LIMIT 1 [ RunTime:0.005063s ]
SELECT `id` FROM `stock` WHERE `id` <> 58164031 AND `partno` = '106990249' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%seeed technology co., ltd%' ) [ RunTime:0.021252s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17858051 [ RunTime:0.023019s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63507067 LIMIT 5 [ RunTime:0.009746s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63507067 ORDER BY `minOrder` ASC [ RunTime:0.078378s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63507067 ORDER BY `unit` DESC [ RunTime:0.033556s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63507067 LIMIT 2 [ RunTime:0.006940s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63507067 ORDER BY `minOrder` ASC [ RunTime:0.003326s ]
select * from pdf where partno='106990268' and brandshort='Seeed Technology Co., Ltd' limit 1 [ RunTime:0.029304s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '106990268' OR `brand` LIKE 'Seeed Technology Co., Ltd%' ) ) LIMIT 1 [ RunTime:0.020356s ]
SELECT `id` FROM `stock` WHERE `id` <> 63507067 AND `partno` = '106990268' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%seeed technology co., ltd%' ) [ RunTime:0.037040s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58170023 LIMIT 5 [ RunTime:0.019990s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58170023 ORDER BY `minOrder` ASC [ RunTime:0.001207s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58170023 ORDER BY `unit` DESC [ RunTime:0.003553s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58170023 LIMIT 2 [ RunTime:0.013881s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58170023 ORDER BY `minOrder` ASC [ RunTime:0.030180s ]
select * from pdf where partno='106990289' and brandshort='Seeed Technology Co., Ltd' limit 1 [ RunTime:0.015079s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '106990289' OR `brand` LIKE 'Seeed Technology Co., Ltd%' ) ) LIMIT 1 [ RunTime:0.010762s ]
SELECT `id` FROM `stock` WHERE `id` <> 58170023 AND `partno` = '106990289' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%seeed technology co., ltd%' ) [ RunTime:0.012236s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17858483 [ RunTime:0.002579s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58170005 LIMIT 5 [ RunTime:0.023714s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58170005 ORDER BY `minOrder` ASC [ RunTime:0.032709s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58170005 ORDER BY `unit` DESC [ RunTime:0.029467s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58170005 LIMIT 2 [ RunTime:0.052295s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58170005 ORDER BY `minOrder` ASC [ RunTime:0.005167s ]
select * from pdf where partno='106990291' and brandshort='Seeed Technology Co., Ltd' limit 1 [ RunTime:0.022597s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '106990291' OR `brand` LIKE 'Seeed Technology Co., Ltd%' ) ) LIMIT 1 [ RunTime:0.023660s ]
SELECT `id` FROM `stock` WHERE `id` <> 58170005 AND `partno` = '106990291' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%seeed technology co., ltd%' ) [ RunTime:0.018587s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17858470 [ RunTime:0.016463s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58170004 LIMIT 5 [ RunTime:0.029181s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58170004 ORDER BY `minOrder` ASC [ RunTime:0.011496s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58170004 ORDER BY `unit` DESC [ RunTime:0.008464s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58170004 LIMIT 2 [ RunTime:0.029379s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58170004 ORDER BY `minOrder` ASC [ RunTime:0.042091s ]
select * from pdf where partno='106990296' and brandshort='Seeed Technology Co., Ltd' limit 1 [ RunTime:0.001078s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '106990296' OR `brand` LIKE 'Seeed Technology Co., Ltd%' ) ) LIMIT 1 [ RunTime:0.013615s ]
SELECT `id` FROM `stock` WHERE `id` <> 58170004 AND `partno` = '106990296' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%seeed technology co., ltd%' ) [ RunTime:0.041008s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17858469 [ RunTime:0.023844s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58170003 LIMIT 5 [ RunTime:0.038066s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58170003 ORDER BY `minOrder` ASC [ RunTime:0.023800s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58170003 ORDER BY `unit` DESC [ RunTime:0.017032s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58170003 LIMIT 2 [ RunTime:0.006288s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58170003 ORDER BY `minOrder` ASC [ RunTime:0.024775s ]
select * from pdf where partno='106990292' and brandshort='Seeed Technology Co., Ltd' limit 1 [ RunTime:0.028984s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '106990292' OR `brand` LIKE 'Seeed Technology Co., Ltd%' ) ) LIMIT 1 [ RunTime:0.019608s ]
SELECT `id` FROM `stock` WHERE `id` <> 58170003 AND `partno` = '106990292' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%seeed technology co., ltd%' ) [ RunTime:0.035704s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17858468 [ RunTime:0.016774s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58170002 LIMIT 5 [ RunTime:0.008744s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58170002 ORDER BY `minOrder` ASC [ RunTime:0.011900s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58170002 ORDER BY `unit` DESC [ RunTime:0.010928s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58170002 LIMIT 2 [ RunTime:0.013433s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58170002 ORDER BY `minOrder` ASC [ RunTime:0.004601s ]
select * from pdf where partno='106990294' and brandshort='Seeed Technology Co., Ltd' limit 1 [ RunTime:0.003554s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '106990294' OR `brand` LIKE 'Seeed Technology Co., Ltd%' ) ) LIMIT 1 [ RunTime:0.007197s ]
SELECT `id` FROM `stock` WHERE `id` <> 58170002 AND `partno` = '106990294' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%seeed technology co., ltd%' ) [ RunTime:0.016923s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17858467 [ RunTime:0.000850s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58170001 LIMIT 5 [ RunTime:0.009374s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58170001 ORDER BY `minOrder` ASC [ RunTime:0.013674s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58170001 ORDER BY `unit` DESC [ RunTime:0.016247s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58170001 LIMIT 2 [ RunTime:0.005691s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58170001 ORDER BY `minOrder` ASC [ RunTime:0.007394s ]
select * from pdf where partno='106990293' and brandshort='Seeed Technology Co., Ltd' limit 1 [ RunTime:0.016954s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '106990293' OR `brand` LIKE 'Seeed Technology Co., Ltd%' ) ) LIMIT 1 [ RunTime:0.001058s ]
SELECT `id` FROM `stock` WHERE `id` <> 58170001 AND `partno` = '106990293' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%seeed technology co., ltd%' ) [ RunTime:0.009082s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17858466 [ RunTime:0.013519s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58170000 LIMIT 5 [ RunTime:0.011549s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58170000 ORDER BY `minOrder` ASC [ RunTime:0.008635s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58170000 ORDER BY `unit` DESC [ RunTime:0.011338s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58170000 LIMIT 2 [ RunTime:0.001825s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58170000 ORDER BY `minOrder` ASC [ RunTime:0.009157s ]
select * from pdf where partno='106990295' and brandshort='Seeed Technology Co., Ltd' limit 1 [ RunTime:0.001082s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '106990295' OR `brand` LIKE 'Seeed Technology Co., Ltd%' ) ) LIMIT 1 [ RunTime:0.010642s ]
SELECT `id` FROM `stock` WHERE `id` <> 58170000 AND `partno` = '106990295' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%seeed technology co., ltd%' ) [ RunTime:0.004406s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17858465 [ RunTime:0.007209s ]
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 '1069902%' OR `brand` LIKE '1069902%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.004287s ]
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 '1069902%' OR `brand` LIKE '1069902%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.008174s ]
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 '1069902%' OR `brand` LIKE '1069902%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003400s ]
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 '1069902%' OR `brand` LIKE '1069902%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.015245s ]
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 '1069902%' OR `brand` LIKE '1069902%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.017670s ]
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 '1069902%' OR `brand` LIKE '1069902%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.008224s ]
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 '1069902%' OR `brand` LIKE '1069902%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.004939s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '1069902%' OR `brand` LIKE '1069902%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.001778s ]