SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002131s ]
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 'PR10%' OR `brand` LIKE 'PR10%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.022222s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001789s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17145128 LIMIT 5 [ RunTime:0.001148s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001262s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17145128 ORDER BY `minOrder` ASC [ RunTime:0.006661s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.020557s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17145128 ORDER BY `unit` DESC [ RunTime:0.000983s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.001854s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17145128 LIMIT 2 [ RunTime:0.000854s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17145128 ORDER BY `minOrder` ASC [ RunTime:0.000349s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17145127 LIMIT 5 [ RunTime:0.007360s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17145127 ORDER BY `minOrder` ASC [ RunTime:0.016741s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17145127 ORDER BY `unit` DESC [ RunTime:0.007827s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17145127 LIMIT 2 [ RunTime:0.008131s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17145127 ORDER BY `minOrder` ASC [ RunTime:0.004765s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15365013 LIMIT 5 [ RunTime:0.012616s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15365013 ORDER BY `minOrder` ASC [ RunTime:0.021953s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15365013 ORDER BY `unit` DESC [ RunTime:0.005562s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15365013 LIMIT 2 [ RunTime:0.000628s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15365013 ORDER BY `minOrder` ASC [ RunTime:0.005339s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19276278 LIMIT 5 [ RunTime:0.027187s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19276278 ORDER BY `minOrder` ASC [ RunTime:0.009287s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19276278 ORDER BY `unit` DESC [ RunTime:0.005009s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19276278 LIMIT 2 [ RunTime:0.011739s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19276278 ORDER BY `minOrder` ASC [ RunTime:0.025394s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19276279 LIMIT 5 [ RunTime:0.028118s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19276279 ORDER BY `minOrder` ASC [ RunTime:0.040365s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19276279 ORDER BY `unit` DESC [ RunTime:0.011217s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19276279 LIMIT 2 [ RunTime:0.047701s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19276279 ORDER BY `minOrder` ASC [ RunTime:0.000724s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17143606 LIMIT 5 [ RunTime:0.019964s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17143606 ORDER BY `minOrder` ASC [ RunTime:0.024846s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17143606 ORDER BY `unit` DESC [ RunTime:0.022706s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17143606 LIMIT 2 [ RunTime:0.042290s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17143606 ORDER BY `minOrder` ASC [ RunTime:0.024257s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13280976 LIMIT 5 [ RunTime:0.015066s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13280976 ORDER BY `minOrder` ASC [ RunTime:0.017617s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13280976 ORDER BY `unit` DESC [ RunTime:0.030693s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13280976 LIMIT 2 [ RunTime:0.019191s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13280976 ORDER BY `minOrder` ASC [ RunTime:0.022889s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13281660 LIMIT 5 [ RunTime:0.025674s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13281660 ORDER BY `minOrder` ASC [ RunTime:0.009934s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13281660 ORDER BY `unit` DESC [ RunTime:0.020932s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13281660 LIMIT 2 [ RunTime:0.018378s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13281660 ORDER BY `minOrder` ASC [ RunTime:0.017310s ]
select * from pdf where partno='PR100197' and brandshort='Kunbus GmbH' limit 1 [ RunTime:0.020201s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12009537 LIMIT 5 [ RunTime:0.037455s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12009537 ORDER BY `minOrder` ASC [ RunTime:0.021363s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12009537 ORDER BY `unit` DESC [ RunTime:0.023293s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12009537 LIMIT 2 [ RunTime:0.006357s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12009537 ORDER BY `minOrder` ASC [ RunTime:0.010257s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13280973 LIMIT 5 [ RunTime:0.018166s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13280973 ORDER BY `minOrder` ASC [ RunTime:0.005313s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13280973 ORDER BY `unit` DESC [ RunTime:0.014698s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13280973 LIMIT 2 [ RunTime:0.000739s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13280973 ORDER BY `minOrder` ASC [ RunTime:0.000459s ]
select * from pdf where partno='PR100195' and brandshort='Kunbus GmbH' limit 1 [ RunTime:0.015229s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13281428 LIMIT 5 [ RunTime:0.009530s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13281428 ORDER BY `minOrder` ASC [ RunTime:0.015564s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13281428 ORDER BY `unit` DESC [ RunTime:0.014715s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13281428 LIMIT 2 [ RunTime:0.000765s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13281428 ORDER BY `minOrder` ASC [ RunTime:0.000489s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13281505 LIMIT 5 [ RunTime:0.008487s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13281505 ORDER BY `minOrder` ASC [ RunTime:0.009053s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13281505 ORDER BY `unit` DESC [ RunTime:0.014945s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13281505 LIMIT 2 [ RunTime:0.006175s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13281505 ORDER BY `minOrder` ASC [ RunTime:0.005178s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12010171 LIMIT 5 [ RunTime:0.008574s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12010171 ORDER BY `minOrder` ASC [ RunTime:0.026096s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12010171 ORDER BY `unit` DESC [ RunTime:0.033587s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12010171 LIMIT 2 [ RunTime:0.001750s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12010171 ORDER BY `minOrder` ASC [ RunTime:0.001190s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12010103 LIMIT 5 [ RunTime:0.010203s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12010103 ORDER BY `minOrder` ASC [ RunTime:0.006928s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12010103 ORDER BY `unit` DESC [ RunTime:0.003344s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12010103 LIMIT 2 [ RunTime:0.002723s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12010103 ORDER BY `minOrder` ASC [ RunTime:0.004288s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12013257 LIMIT 5 [ RunTime:0.001837s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12013257 ORDER BY `minOrder` ASC [ RunTime:0.002950s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12013257 ORDER BY `unit` DESC [ RunTime:0.003153s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12013257 LIMIT 2 [ RunTime:0.011016s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12013257 ORDER BY `minOrder` ASC [ RunTime:0.001995s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12010104 LIMIT 5 [ RunTime:0.002592s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12010104 ORDER BY `minOrder` ASC [ RunTime:0.005783s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12010104 ORDER BY `unit` DESC [ RunTime:0.000681s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12010104 LIMIT 2 [ RunTime:0.003128s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12010104 ORDER BY `minOrder` ASC [ RunTime:0.006640s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18849880 LIMIT 5 [ RunTime:0.020318s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18849880 ORDER BY `minOrder` ASC [ RunTime:0.006498s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18849880 ORDER BY `unit` DESC [ RunTime:0.000745s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18849880 LIMIT 2 [ RunTime:0.000620s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18849880 ORDER BY `minOrder` ASC [ RunTime:0.002437s ]
select * from pdf where partno='PR100378' and brandshort='Kunbus GmbH' limit 1 [ RunTime:0.002175s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12010168 LIMIT 5 [ RunTime:0.005026s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12010168 ORDER BY `minOrder` ASC [ RunTime:0.012020s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12010168 ORDER BY `unit` DESC [ RunTime:0.008419s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12010168 LIMIT 2 [ RunTime:0.006143s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12010168 ORDER BY `minOrder` ASC [ RunTime:0.003494s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17023919 LIMIT 5 [ RunTime:0.001637s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17023919 ORDER BY `minOrder` ASC [ RunTime:0.003538s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17023919 ORDER BY `unit` DESC [ RunTime:0.003862s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17023919 LIMIT 2 [ RunTime:0.008194s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17023919 ORDER BY `minOrder` ASC [ RunTime:0.000511s ]
select * from pdf where partno='PR100379' and brandshort='Kunbus GmbH' limit 1 [ RunTime:0.000977s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18850448 LIMIT 5 [ RunTime:0.002737s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18850448 ORDER BY `minOrder` ASC [ RunTime:0.001667s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18850448 ORDER BY `unit` DESC [ RunTime:0.002156s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18850448 LIMIT 2 [ RunTime:0.003698s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18850448 ORDER BY `minOrder` ASC [ RunTime:0.000462s ]
select * from pdf where partno='PR100272' and brandshort='Kunbus GmbH' limit 1 [ RunTime:0.008024s ]
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 'PR10%' OR `brand` LIKE 'PR10%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.004977s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51025752 LIMIT 5 [ RunTime:0.001418s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51025752 ORDER BY `minOrder` ASC [ RunTime:0.001647s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51025752 ORDER BY `unit` DESC [ RunTime:0.004346s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51025752 LIMIT 2 [ RunTime:0.001535s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51025752 ORDER BY `minOrder` ASC [ RunTime:0.000297s ]
select * from pdf where partno='pr1007g_hf' and brandshort='diodes incorporated' limit 1 [ RunTime:0.001006s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001315s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'pr1007g_hf' OR `brand` LIKE 'diodes incorporated%' ) ) LIMIT 1 [ RunTime:0.004807s ]
SELECT `id` FROM `stock` WHERE `id` <> 51025752 AND `partno` = 'pr1007g_hf' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%diodes incorporated%' ) [ RunTime:0.008521s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 44098432 [ RunTime:0.002099s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32212086 LIMIT 5 [ RunTime:0.000313s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32212086 ORDER BY `minOrder` ASC [ RunTime:0.002586s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32212086 ORDER BY `unit` DESC [ RunTime:0.003250s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32212086 LIMIT 2 [ RunTime:0.000302s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32212086 ORDER BY `minOrder` ASC [ RunTime:0.001463s ]
select * from pdf where partno='pr10-24v-450-1a' and brandshort='same sky' limit 1 [ RunTime:0.000803s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'pr10-24v-450-1a' OR `brand` LIKE 'same sky%' ) ) LIMIT 1 [ RunTime:0.004199s ]
SELECT `id` FROM `stock` WHERE `id` <> 32212086 AND `partno` = 'pr10-24v-450-1a' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%same sky%' ) [ RunTime:0.015167s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17145128 [ RunTime:0.001196s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51072185 LIMIT 5 [ RunTime:0.001165s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51072185 ORDER BY `minOrder` ASC [ RunTime:0.002123s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51072185 ORDER BY `unit` DESC [ RunTime:0.001001s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51072185 LIMIT 2 [ RunTime:0.000623s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51072185 ORDER BY `minOrder` ASC [ RunTime:0.003545s ]
select * from pdf where partno='pr10-832' and brandshort='pem' limit 1 [ RunTime:0.004440s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'pr10-832' OR `brand` LIKE 'pem%' ) ) LIMIT 1 [ RunTime:0.015327s ]
SELECT `id` FROM `stock` WHERE `id` <> 51072185 AND `partno` = 'pr10-832' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%pem%' ) [ RunTime:0.004884s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32211284 LIMIT 5 [ RunTime:0.001345s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32211284 ORDER BY `minOrder` ASC [ RunTime:0.001921s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32211284 ORDER BY `unit` DESC [ RunTime:0.009466s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32211284 LIMIT 2 [ RunTime:0.008740s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32211284 ORDER BY `minOrder` ASC [ RunTime:0.000459s ]
select * from pdf where partno='pr10-5v-450-1a' and brandshort='same sky' limit 1 [ RunTime:0.016405s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'pr10-5v-450-1a' OR `brand` LIKE 'same sky%' ) ) LIMIT 1 [ RunTime:0.003221s ]
SELECT `id` FROM `stock` WHERE `id` <> 32211284 AND `partno` = 'pr10-5v-450-1a' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%same sky%' ) [ RunTime:0.001218s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17145127 [ RunTime:0.006008s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32212177 LIMIT 5 [ RunTime:0.012514s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32212177 ORDER BY `minOrder` ASC [ RunTime:0.025615s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32212177 ORDER BY `unit` DESC [ RunTime:0.003499s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32212177 LIMIT 2 [ RunTime:0.000639s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32212177 ORDER BY `minOrder` ASC [ RunTime:0.003274s ]
select * from pdf where partno='pr10-12v-450-1a' and brandshort='same sky' limit 1 [ RunTime:0.009279s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'pr10-12v-450-1a' OR `brand` LIKE 'same sky%' ) ) LIMIT 1 [ RunTime:0.002822s ]
SELECT `id` FROM `stock` WHERE `id` <> 32212177 AND `partno` = 'pr10-12v-450-1a' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%same sky%' ) [ RunTime:0.000997s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15365013 [ RunTime:0.013660s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51072257 LIMIT 5 [ RunTime:0.014441s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51072257 ORDER BY `minOrder` ASC [ RunTime:0.021774s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51072257 ORDER BY `unit` DESC [ RunTime:0.000913s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51072257 LIMIT 2 [ RunTime:0.025372s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51072257 ORDER BY `minOrder` ASC [ RunTime:0.014583s ]
select * from pdf where partno='pr10-m5' and brandshort='pem' limit 1 [ RunTime:0.022395s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'pr10-m5' OR `brand` LIKE 'pem%' ) ) LIMIT 1 [ RunTime:0.010701s ]
SELECT `id` FROM `stock` WHERE `id` <> 51072257 AND `partno` = 'pr10-m5' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%pem%' ) [ RunTime:0.020419s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32211223 LIMIT 5 [ RunTime:0.010386s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32211223 ORDER BY `minOrder` ASC [ RunTime:0.009704s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32211223 ORDER BY `unit` DESC [ RunTime:0.007175s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32211223 LIMIT 2 [ RunTime:0.016925s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32211223 ORDER BY `minOrder` ASC [ RunTime:0.008479s ]
select * from pdf where partno='pr10-5v-450-1c' and brandshort='same sky' limit 1 [ RunTime:0.004620s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'pr10-5v-450-1c' OR `brand` LIKE 'same sky%' ) ) LIMIT 1 [ RunTime:0.026178s ]
SELECT `id` FROM `stock` WHERE `id` <> 32211223 AND `partno` = 'pr10-5v-450-1c' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%same sky%' ) [ RunTime:0.005788s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19276278 [ RunTime:0.009667s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32211308 LIMIT 5 [ RunTime:0.026343s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32211308 ORDER BY `minOrder` ASC [ RunTime:0.013369s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32211308 ORDER BY `unit` DESC [ RunTime:0.001619s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32211308 LIMIT 2 [ RunTime:0.003272s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32211308 ORDER BY `minOrder` ASC [ RunTime:0.002998s ]
select * from pdf where partno='pr10-24v-450-1c' and brandshort='same sky' limit 1 [ RunTime:0.017322s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'pr10-24v-450-1c' OR `brand` LIKE 'same sky%' ) ) LIMIT 1 [ RunTime:0.006950s ]
SELECT `id` FROM `stock` WHERE `id` <> 32211308 AND `partno` = 'pr10-24v-450-1c' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%same sky%' ) [ RunTime:0.019252s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17143606 [ RunTime:0.001734s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51072256 LIMIT 5 [ RunTime:0.020002s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51072256 ORDER BY `minOrder` ASC [ RunTime:0.006787s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51072256 ORDER BY `unit` DESC [ RunTime:0.006361s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51072256 LIMIT 2 [ RunTime:0.005552s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51072256 ORDER BY `minOrder` ASC [ RunTime:0.003155s ]
select * from pdf where partno='pr10-632' and brandshort='pem' limit 1 [ RunTime:0.001040s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'pr10-632' OR `brand` LIKE 'pem%' ) ) LIMIT 1 [ RunTime:0.004331s ]
SELECT `id` FROM `stock` WHERE `id` <> 51072256 AND `partno` = 'pr10-632' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%pem%' ) [ RunTime:0.003406s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51088846 LIMIT 5 [ RunTime:0.008316s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51088846 ORDER BY `minOrder` ASC [ RunTime:0.001058s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51088846 ORDER BY `unit` DESC [ RunTime:0.000521s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51088846 LIMIT 2 [ RunTime:0.000478s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51088846 ORDER BY `minOrder` ASC [ RunTime:0.002144s ]
select * from pdf where partno='pr100197' and brandshort='kunbus' limit 1 [ RunTime:0.001202s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'pr100197' OR `brand` LIKE 'kunbus%' ) ) LIMIT 1 [ RunTime:0.000846s ]
SELECT `id` FROM `stock` WHERE `id` <> 51088846 AND `partno` = 'pr100197' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%kunbus%' ) [ RunTime:0.002772s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13281660 [ RunTime:0.013732s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51088821 LIMIT 5 [ RunTime:0.005696s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51088821 ORDER BY `minOrder` ASC [ RunTime:0.012884s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51088821 ORDER BY `unit` DESC [ RunTime:0.014501s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51088821 LIMIT 2 [ RunTime:0.005837s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51088821 ORDER BY `minOrder` ASC [ RunTime:0.000676s ]
select * from pdf where partno='pr100386' and brandshort='kunbus' limit 1 [ RunTime:0.001412s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'pr100386' OR `brand` LIKE 'kunbus%' ) ) LIMIT 1 [ RunTime:0.011162s ]
SELECT `id` FROM `stock` WHERE `id` <> 51088821 AND `partno` = 'pr100386' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%kunbus%' ) [ RunTime:0.008424s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64382742 [ RunTime:0.011799s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51070967 LIMIT 5 [ RunTime:0.002015s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51070967 ORDER BY `minOrder` ASC [ RunTime:0.019041s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51070967 ORDER BY `unit` DESC [ RunTime:0.002544s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51070967 LIMIT 2 [ RunTime:0.000705s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51070967 ORDER BY `minOrder` ASC [ RunTime:0.003159s ]
select * from pdf where partno='pr100369' and brandshort='kunbus' limit 1 [ RunTime:0.010256s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'pr100369' OR `brand` LIKE 'kunbus%' ) ) LIMIT 1 [ RunTime:0.001538s ]
SELECT `id` FROM `stock` WHERE `id` <> 51070967 AND `partno` = 'pr100369' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%kunbus%' ) [ RunTime:0.001391s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13281446 [ RunTime:0.000881s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51088908 LIMIT 5 [ RunTime:0.003870s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51088908 ORDER BY `minOrder` ASC [ RunTime:0.022236s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51088908 ORDER BY `unit` DESC [ RunTime:0.001006s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51088908 LIMIT 2 [ RunTime:0.003641s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51088908 ORDER BY `minOrder` ASC [ RunTime:0.002327s ]
select * from pdf where partno='pr100250' and brandshort='kunbus' limit 1 [ RunTime:0.024752s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'pr100250' OR `brand` LIKE 'kunbus%' ) ) LIMIT 1 [ RunTime:0.051331s ]
SELECT `id` FROM `stock` WHERE `id` <> 51088908 AND `partno` = 'pr100250' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%kunbus%' ) [ RunTime:0.052728s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18862205 [ RunTime:0.019132s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51070964 LIMIT 5 [ RunTime:0.030867s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51070964 ORDER BY `minOrder` ASC [ RunTime:0.033479s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51070964 ORDER BY `unit` DESC [ RunTime:0.085454s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51070964 LIMIT 2 [ RunTime:0.035490s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51070964 ORDER BY `minOrder` ASC [ RunTime:0.016994s ]
select * from pdf where partno='pr100365' and brandshort='kunbus' limit 1 [ RunTime:0.022153s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'pr100365' OR `brand` LIKE 'kunbus%' ) ) LIMIT 1 [ RunTime:0.008561s ]
SELECT `id` FROM `stock` WHERE `id` <> 51070964 AND `partno` = 'pr100365' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%kunbus%' ) [ RunTime:0.016491s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13280976 [ RunTime:0.026819s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51070750 LIMIT 5 [ RunTime:0.014396s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51070750 ORDER BY `minOrder` ASC [ RunTime:0.024367s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51070750 ORDER BY `unit` DESC [ RunTime:0.000596s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51070750 LIMIT 2 [ RunTime:0.007695s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51070750 ORDER BY `minOrder` ASC [ RunTime:0.010011s ]
select * from pdf where partno='pr100371' and brandshort='kunbus' limit 1 [ RunTime:0.008971s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'pr100371' OR `brand` LIKE 'kunbus%' ) ) LIMIT 1 [ RunTime:0.001016s ]
SELECT `id` FROM `stock` WHERE `id` <> 51070750 AND `partno` = 'pr100371' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%kunbus%' ) [ RunTime:0.008517s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18851294 [ RunTime:0.014328s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51070767 LIMIT 5 [ RunTime:0.016094s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51070767 ORDER BY `minOrder` ASC [ RunTime:0.014733s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51070767 ORDER BY `unit` DESC [ RunTime:0.003162s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51070767 LIMIT 2 [ RunTime:0.011967s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51070767 ORDER BY `minOrder` ASC [ RunTime:0.003777s ]
select * from pdf where partno='pr100395' and brandshort='kunbus' limit 1 [ RunTime:0.008061s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'pr100395' OR `brand` LIKE 'kunbus%' ) ) LIMIT 1 [ RunTime:0.000665s ]
SELECT `id` FROM `stock` WHERE `id` <> 51070767 AND `partno` = 'pr100395' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%kunbus%' ) [ RunTime:0.008917s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12010716 [ RunTime:0.006551s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51079924 LIMIT 5 [ RunTime:0.010203s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51079924 ORDER BY `minOrder` ASC [ RunTime:0.006662s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51079924 ORDER BY `unit` DESC [ RunTime:0.005850s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51079924 LIMIT 2 [ RunTime:0.003519s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51079924 ORDER BY `minOrder` ASC [ RunTime:0.001602s ]
select * from pdf where partno='pr100286' and brandshort='kunbus' limit 1 [ RunTime:0.000902s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'pr100286' OR `brand` LIKE 'kunbus%' ) ) LIMIT 1 [ RunTime:0.000652s ]
SELECT `id` FROM `stock` WHERE `id` <> 51079924 AND `partno` = 'pr100286' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%kunbus%' ) [ RunTime:0.006041s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13281511 [ RunTime:0.002422s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51088907 LIMIT 5 [ RunTime:0.005365s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51088907 ORDER BY `minOrder` ASC [ RunTime:0.006029s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51088907 ORDER BY `unit` DESC [ RunTime:0.003391s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51088907 LIMIT 2 [ RunTime:0.005465s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51088907 ORDER BY `minOrder` ASC [ RunTime:0.000499s ]
select * from pdf where partno='pr100196' and brandshort='kunbus' limit 1 [ RunTime:0.001109s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'pr100196' OR `brand` LIKE 'kunbus%' ) ) LIMIT 1 [ RunTime:0.004091s ]
SELECT `id` FROM `stock` WHERE `id` <> 51088907 AND `partno` = 'pr100196' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%kunbus%' ) [ RunTime:0.002768s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64381938 [ RunTime:0.002169s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51088909 LIMIT 5 [ RunTime:0.002310s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51088909 ORDER BY `minOrder` ASC [ RunTime:0.000775s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51088909 ORDER BY `unit` DESC [ RunTime:0.001610s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51088909 LIMIT 2 [ RunTime:0.000613s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51088909 ORDER BY `minOrder` ASC [ RunTime:0.000468s ]
select * from pdf where partno='pr100323' and brandshort='kunbus' limit 1 [ RunTime:0.000946s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'pr100323' OR `brand` LIKE 'kunbus%' ) ) LIMIT 1 [ RunTime:0.000933s ]
SELECT `id` FROM `stock` WHERE `id` <> 51088909 AND `partno` = 'pr100323' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%kunbus%' ) [ RunTime:0.000856s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12009537 [ RunTime:0.000667s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51070963 LIMIT 5 [ RunTime:0.000621s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51070963 ORDER BY `minOrder` ASC [ RunTime:0.000687s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51070963 ORDER BY `unit` DESC [ RunTime:0.001076s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51070963 LIMIT 2 [ RunTime:0.015568s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51070963 ORDER BY `minOrder` ASC [ RunTime:0.009705s ]
select * from pdf where partno='pr100363' and brandshort='kunbus' limit 1 [ RunTime:0.020651s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'pr100363' OR `brand` LIKE 'kunbus%' ) ) LIMIT 1 [ RunTime:0.003239s ]
SELECT `id` FROM `stock` WHERE `id` <> 51070963 AND `partno` = 'pr100363' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%kunbus%' ) [ RunTime:0.017128s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12010171 [ RunTime:0.011512s ]
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 'PR10%' OR `brand` LIKE 'PR10%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.023273s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 44083817 LIMIT 5 [ RunTime:0.001039s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44083817 ORDER BY `minOrder` ASC [ RunTime:0.002138s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 44083817 ORDER BY `unit` DESC [ RunTime:0.003088s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 44083817 LIMIT 2 [ RunTime:0.000629s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44083817 ORDER BY `minOrder` ASC [ RunTime:0.000374s ]
select * from pdf where partno='PR1006G-T' and brandshort='Diodes Incorporated' limit 1 [ RunTime:0.003406s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PR1006G-T' OR `brand` LIKE 'Diodes Incorporated%' ) ) LIMIT 1 [ RunTime:0.004574s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 44086120 LIMIT 5 [ RunTime:0.003437s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44086120 ORDER BY `minOrder` ASC [ RunTime:0.001319s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 44086120 ORDER BY `unit` DESC [ RunTime:0.011663s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 44086120 LIMIT 2 [ RunTime:0.011089s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44086120 ORDER BY `minOrder` ASC [ RunTime:0.002154s ]
select * from pdf where partno='PR1007G-T' and brandshort='Diodes Incorporated' limit 1 [ RunTime:0.003007s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PR1007G-T' OR `brand` LIKE 'Diodes Incorporated%' ) ) LIMIT 1 [ RunTime:0.003385s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 44086538 LIMIT 5 [ RunTime:0.005462s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44086538 ORDER BY `minOrder` ASC [ RunTime:0.005777s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 44086538 ORDER BY `unit` DESC [ RunTime:0.006212s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 44086538 LIMIT 2 [ RunTime:0.009241s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44086538 ORDER BY `minOrder` ASC [ RunTime:0.002606s ]
select * from pdf where partno='PR1005G-T' and brandshort='Diodes Incorporated' limit 1 [ RunTime:0.018845s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PR1005G-T' OR `brand` LIKE 'Diodes Incorporated%' ) ) LIMIT 1 [ RunTime:0.001462s ]
SELECT `id` FROM `stock` WHERE `id` <> 44086538 AND `partno` = 'PR1005G-T' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%diodes incorporated%' ) [ RunTime:0.006836s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 44088808 LIMIT 5 [ RunTime:0.002028s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44088808 ORDER BY `minOrder` ASC [ RunTime:0.003929s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 44088808 ORDER BY `unit` DESC [ RunTime:0.009496s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 44088808 LIMIT 2 [ RunTime:0.003530s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44088808 ORDER BY `minOrder` ASC [ RunTime:0.008252s ]
select * from pdf where partno='PR1007G_HF-A52' and brandshort='Diodes Incorporated' limit 1 [ RunTime:0.021775s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PR1007G_HF-A52' OR `brand` LIKE 'Diodes Incorporated%' ) ) LIMIT 1 [ RunTime:0.010596s ]
SELECT `id` FROM `stock` WHERE `id` <> 44088808 AND `partno` = 'PR1007G_HF-A52' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%diodes incorporated%' ) [ RunTime:0.000755s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 43757369 LIMIT 5 [ RunTime:0.007956s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43757369 ORDER BY `minOrder` ASC [ RunTime:0.017407s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 43757369 ORDER BY `unit` DESC [ RunTime:0.015697s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 43757369 LIMIT 2 [ RunTime:0.004121s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43757369 ORDER BY `minOrder` ASC [ RunTime:0.004998s ]
select * from pdf where partno='PR10-24V-450-1A' and brandshort='Same Sky Formerly CUI Devices' limit 1 [ RunTime:0.015127s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PR10-24V-450-1A' OR `brand` LIKE 'Same Sky (Formerly CUI Devices)%' ) ) LIMIT 1 [ RunTime:0.008729s ]
SELECT `id` FROM `stock` WHERE `id` <> 43757369 AND `partno` = 'PR10-24V-450-1A' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%same sky%' ) [ RunTime:0.004248s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32212086 [ RunTime:0.000565s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17145128 [ RunTime:0.010621s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 43757363 LIMIT 5 [ RunTime:0.012579s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43757363 ORDER BY `minOrder` ASC [ RunTime:0.030245s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 43757363 ORDER BY `unit` DESC [ RunTime:0.017158s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 43757363 LIMIT 2 [ RunTime:0.010210s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43757363 ORDER BY `minOrder` ASC [ RunTime:0.006703s ]
select * from pdf where partno='PR10-5V-450-1A' and brandshort='Same Sky Formerly CUI Devices' limit 1 [ RunTime:0.021296s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PR10-5V-450-1A' OR `brand` LIKE 'Same Sky (Formerly CUI Devices)%' ) ) LIMIT 1 [ RunTime:0.008459s ]
SELECT `id` FROM `stock` WHERE `id` <> 43757363 AND `partno` = 'PR10-5V-450-1A' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%same sky%' ) [ RunTime:0.017055s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32211284 [ RunTime:0.035342s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17145127 [ RunTime:0.015607s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 43757364 LIMIT 5 [ RunTime:0.023784s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43757364 ORDER BY `minOrder` ASC [ RunTime:0.022405s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 43757364 ORDER BY `unit` DESC [ RunTime:0.001888s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 43757364 LIMIT 2 [ RunTime:0.018443s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43757364 ORDER BY `minOrder` ASC [ RunTime:0.000462s ]
select * from pdf where partno='PR10-12V-450-1A' and brandshort='Same Sky Formerly CUI Devices' limit 1 [ RunTime:0.005413s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PR10-12V-450-1A' OR `brand` LIKE 'Same Sky (Formerly CUI Devices)%' ) ) LIMIT 1 [ RunTime:0.009839s ]
SELECT `id` FROM `stock` WHERE `id` <> 43757364 AND `partno` = 'PR10-12V-450-1A' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%same sky%' ) [ RunTime:0.007813s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32212177 [ RunTime:0.007822s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15365013 [ RunTime:0.021795s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 43757384 LIMIT 5 [ RunTime:0.016937s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43757384 ORDER BY `minOrder` ASC [ RunTime:0.005055s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 43757384 ORDER BY `unit` DESC [ RunTime:0.012078s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 43757384 LIMIT 2 [ RunTime:0.021542s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43757384 ORDER BY `minOrder` ASC [ RunTime:0.013573s ]
select * from pdf where partno='PR10-5V-450-1C' and brandshort='Same Sky Formerly CUI Devices' limit 1 [ RunTime:0.016559s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PR10-5V-450-1C' OR `brand` LIKE 'Same Sky (Formerly CUI Devices)%' ) ) LIMIT 1 [ RunTime:0.006535s ]
SELECT `id` FROM `stock` WHERE `id` <> 43757384 AND `partno` = 'PR10-5V-450-1C' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%same sky%' ) [ RunTime:0.029084s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32211223 [ RunTime:0.028205s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19276278 [ RunTime:0.017871s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 43757385 LIMIT 5 [ RunTime:0.003226s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43757385 ORDER BY `minOrder` ASC [ RunTime:0.020653s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 43757385 ORDER BY `unit` DESC [ RunTime:0.009397s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 43757385 LIMIT 2 [ RunTime:0.036100s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43757385 ORDER BY `minOrder` ASC [ RunTime:0.028041s ]
select * from pdf where partno='PR10-12V-450-1C' and brandshort='Same Sky Formerly CUI Devices' limit 1 [ RunTime:0.035826s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PR10-12V-450-1C' OR `brand` LIKE 'Same Sky (Formerly CUI Devices)%' ) ) LIMIT 1 [ RunTime:0.033783s ]
SELECT `id` FROM `stock` WHERE `id` <> 43757385 AND `partno` = 'PR10-12V-450-1C' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%same sky%' ) [ RunTime:0.017975s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19276279 [ RunTime:0.018374s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 43757396 LIMIT 5 [ RunTime:0.023426s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43757396 ORDER BY `minOrder` ASC [ RunTime:0.028795s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 43757396 ORDER BY `unit` DESC [ RunTime:0.005875s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 43757396 LIMIT 2 [ RunTime:0.004316s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43757396 ORDER BY `minOrder` ASC [ RunTime:0.003529s ]
select * from pdf where partno='PR10-24V-450-1C' and brandshort='Same Sky Formerly CUI Devices' limit 1 [ RunTime:0.018918s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PR10-24V-450-1C' OR `brand` LIKE 'Same Sky (Formerly CUI Devices)%' ) ) LIMIT 1 [ RunTime:0.028630s ]
SELECT `id` FROM `stock` WHERE `id` <> 43757396 AND `partno` = 'PR10-24V-450-1C' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%same sky%' ) [ RunTime:0.013046s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32211308 [ RunTime:0.016623s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17143606 [ RunTime:0.004596s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64388998 LIMIT 5 [ RunTime:0.028081s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64388998 ORDER BY `minOrder` ASC [ RunTime:0.024332s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64388998 ORDER BY `unit` DESC [ RunTime:0.019139s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64388998 LIMIT 2 [ RunTime:0.016456s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64388998 ORDER BY `minOrder` ASC [ RunTime:0.004785s ]
select * from pdf where partno='PR100197' and brandshort='Kunbus GmbH' limit 1 [ RunTime:0.005357s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PR100197' OR `brand` LIKE 'Kunbus GmbH%' ) ) LIMIT 1 [ RunTime:0.001299s ]
SELECT `id` FROM `stock` WHERE `id` <> 64388998 AND `partno` = 'PR100197' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%kunbus gmbh%' ) [ RunTime:0.001123s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13281660 [ RunTime:0.000482s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64105988 LIMIT 5 [ RunTime:0.005971s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64105988 ORDER BY `minOrder` ASC [ RunTime:0.029454s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64105988 ORDER BY `unit` DESC [ RunTime:0.004902s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64105988 LIMIT 2 [ RunTime:0.026928s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64105988 ORDER BY `minOrder` ASC [ RunTime:0.006741s ]
select * from pdf where partno='PR100250' and brandshort='Kunbus GmbH' limit 1 [ RunTime:0.014866s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PR100250' OR `brand` LIKE 'Kunbus GmbH%' ) ) LIMIT 1 [ RunTime:0.019846s ]
SELECT `id` FROM `stock` WHERE `id` <> 64105988 AND `partno` = 'PR100250' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%kunbus gmbh%' ) [ RunTime:0.025389s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18862205 [ RunTime:0.011960s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64381945 LIMIT 5 [ RunTime:0.010490s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64381945 ORDER BY `minOrder` ASC [ RunTime:0.032921s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64381945 ORDER BY `unit` DESC [ RunTime:0.003633s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64381945 LIMIT 2 [ RunTime:0.003037s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64381945 ORDER BY `minOrder` ASC [ RunTime:0.009178s ]
select * from pdf where partno='PR100365' and brandshort='Kunbus GmbH' limit 1 [ RunTime:0.019463s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PR100365' OR `brand` LIKE 'Kunbus GmbH%' ) ) LIMIT 1 [ RunTime:0.020280s ]
SELECT `id` FROM `stock` WHERE `id` <> 64381945 AND `partno` = 'PR100365' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%kunbus gmbh%' ) [ RunTime:0.009745s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13280976 [ RunTime:0.010299s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64099634 LIMIT 5 [ RunTime:0.015292s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64099634 ORDER BY `minOrder` ASC [ RunTime:0.015845s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64099634 ORDER BY `unit` DESC [ RunTime:0.007438s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64099634 LIMIT 2 [ RunTime:0.018984s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64099634 ORDER BY `minOrder` ASC [ RunTime:0.009132s ]
select * from pdf where partno='PR100380' and brandshort='Kunbus GmbH' limit 1 [ RunTime:0.012616s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PR100380' OR `brand` LIKE 'Kunbus GmbH%' ) ) LIMIT 1 [ RunTime:0.003801s ]
SELECT `id` FROM `stock` WHERE `id` <> 64099634 AND `partno` = 'PR100380' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%kunbus gmbh%' ) [ RunTime:0.024180s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17023920 [ RunTime:0.012940s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64381942 LIMIT 5 [ RunTime:0.003558s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64381942 ORDER BY `minOrder` ASC [ RunTime:0.029476s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64381942 ORDER BY `unit` DESC [ RunTime:0.018439s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64381942 LIMIT 2 [ RunTime:0.010986s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64381942 ORDER BY `minOrder` ASC [ RunTime:0.002952s ]
select * from pdf where partno='PR100323' and brandshort='Kunbus GmbH' limit 1 [ RunTime:0.005498s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PR100323' OR `brand` LIKE 'Kunbus GmbH%' ) ) LIMIT 1 [ RunTime:0.007117s ]
SELECT `id` FROM `stock` WHERE `id` <> 64381942 AND `partno` = 'PR100323' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%kunbus gmbh%' ) [ RunTime:0.022513s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12009537 [ RunTime:0.019154s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64099632 LIMIT 5 [ RunTime:0.001373s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64099632 ORDER BY `minOrder` ASC [ RunTime:0.022925s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64099632 ORDER BY `unit` DESC [ RunTime:0.015338s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64099632 LIMIT 2 [ RunTime:0.020218s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64099632 ORDER BY `minOrder` ASC [ RunTime:0.010366s ]
select * from pdf where partno='PR100378' and brandshort='Kunbus GmbH' limit 1 [ RunTime:0.010625s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PR100378' OR `brand` LIKE 'Kunbus GmbH%' ) ) LIMIT 1 [ RunTime:0.005950s ]
SELECT `id` FROM `stock` WHERE `id` <> 64099632 AND `partno` = 'PR100378' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%kunbus gmbh%' ) [ RunTime:0.001031s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18849880 [ RunTime:0.003324s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64389024 LIMIT 5 [ RunTime:0.007379s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64389024 ORDER BY `minOrder` ASC [ RunTime:0.015161s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64389024 ORDER BY `unit` DESC [ RunTime:0.003054s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64389024 LIMIT 2 [ RunTime:0.003873s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64389024 ORDER BY `minOrder` ASC [ RunTime:0.008718s ]
select * from pdf where partno='PR100419' and brandshort='Kunbus GmbH' limit 1 [ RunTime:0.001404s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PR100419' OR `brand` LIKE 'Kunbus GmbH%' ) ) LIMIT 1 [ RunTime:0.012110s ]
SELECT `id` FROM `stock` WHERE `id` <> 64389024 AND `partno` = 'PR100419' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%kunbus gmbh%' ) [ RunTime:0.014251s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12013621 [ RunTime:0.017558s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64389021 LIMIT 5 [ RunTime:0.028543s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64389021 ORDER BY `minOrder` ASC [ RunTime:0.022645s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64389021 ORDER BY `unit` DESC [ RunTime:0.013320s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64389021 LIMIT 2 [ RunTime:0.012328s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64389021 ORDER BY `minOrder` ASC [ RunTime:0.003652s ]
select * from pdf where partno='PR100416' and brandshort='Kunbus GmbH' limit 1 [ RunTime:0.012545s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PR100416' OR `brand` LIKE 'Kunbus GmbH%' ) ) LIMIT 1 [ RunTime:0.019887s ]
SELECT `id` FROM `stock` WHERE `id` <> 64389021 AND `partno` = 'PR100416' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%kunbus gmbh%' ) [ RunTime:0.028600s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13283693 [ RunTime:0.024019s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64389014 LIMIT 5 [ RunTime:0.036043s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64389014 ORDER BY `minOrder` ASC [ RunTime:0.014463s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64389014 ORDER BY `unit` DESC [ RunTime:0.033160s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64389014 LIMIT 2 [ RunTime:0.010172s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64389014 ORDER BY `minOrder` ASC [ RunTime:0.006360s ]
select * from pdf where partno='PR100368' and brandshort='Kunbus GmbH' limit 1 [ RunTime:0.021026s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PR100368' OR `brand` LIKE 'Kunbus GmbH%' ) ) LIMIT 1 [ RunTime:0.003978s ]
SELECT `id` FROM `stock` WHERE `id` <> 64389014 AND `partno` = 'PR100368' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%kunbus gmbh%' ) [ RunTime:0.009366s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12013257 [ RunTime:0.019885s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64381964 LIMIT 5 [ RunTime:0.017924s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64381964 ORDER BY `minOrder` ASC [ RunTime:0.002630s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64381964 ORDER BY `unit` DESC [ RunTime:0.002232s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64381964 LIMIT 2 [ RunTime:0.005005s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64381964 ORDER BY `minOrder` ASC [ RunTime:0.001396s ]
select * from pdf where partno='PR100361' and brandshort='Kunbus GmbH' limit 1 [ RunTime:0.001207s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PR100361' OR `brand` LIKE 'Kunbus GmbH%' ) ) LIMIT 1 [ RunTime:0.000846s ]
SELECT `id` FROM `stock` WHERE `id` <> 64381964 AND `partno` = 'PR100361' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%kunbus gmbh%' ) [ RunTime:0.000905s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12010168 [ RunTime:0.007597s ]
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 'PR10%' OR `brand` LIKE 'PR10%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.004595s ]
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 'PR10%' OR `brand` LIKE 'PR10%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003208s ]
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 'PR10%' OR `brand` LIKE 'PR10%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.005738s ]
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 'PR10%' OR `brand` LIKE 'PR10%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.008315s ]
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 'PR10%' OR `brand` LIKE 'PR10%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.013087s ]
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 'PR10%' OR `brand` LIKE 'PR10%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.013449s ]
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 'PR10%' OR `brand` LIKE 'PR10%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002996s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'PR10%' OR `brand` LIKE 'PR10%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.011264s ]