SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002175s ]
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 'UTP28SP1M%' OR `brand` LIKE 'UTP28SP1M%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.086653s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.034783s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14506443 LIMIT 5 [ RunTime:0.038149s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.005074s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14506443 ORDER BY `minOrder` ASC [ RunTime:0.035024s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.002314s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14506443 ORDER BY `unit` DESC [ RunTime:0.093802s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.005714s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14506443 LIMIT 2 [ RunTime:0.092633s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14506443 ORDER BY `minOrder` ASC [ RunTime:0.057556s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14504134 LIMIT 5 [ RunTime:0.031468s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14504134 ORDER BY `minOrder` ASC [ RunTime:0.064334s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14504134 ORDER BY `unit` DESC [ RunTime:0.064010s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14504134 LIMIT 2 [ RunTime:0.088148s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14504134 ORDER BY `minOrder` ASC [ RunTime:0.012404s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16503681 LIMIT 5 [ RunTime:0.047668s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16503681 ORDER BY `minOrder` ASC [ RunTime:0.096689s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16503681 ORDER BY `unit` DESC [ RunTime:0.026331s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16503681 LIMIT 2 [ RunTime:0.092703s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16503681 ORDER BY `minOrder` ASC [ RunTime:0.043830s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14499424 LIMIT 5 [ RunTime:0.031404s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14499424 ORDER BY `minOrder` ASC [ RunTime:0.139053s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14499424 ORDER BY `unit` DESC [ RunTime:0.153140s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14499424 LIMIT 2 [ RunTime:0.055718s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14499424 ORDER BY `minOrder` ASC [ RunTime:0.027573s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14499423 LIMIT 5 [ RunTime:0.035902s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14499423 ORDER BY `minOrder` ASC [ RunTime:0.089884s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14499423 ORDER BY `unit` DESC [ RunTime:0.023874s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14499423 LIMIT 2 [ RunTime:0.038088s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14499423 ORDER BY `minOrder` ASC [ RunTime:0.035102s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14499422 LIMIT 5 [ RunTime:0.047882s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14499422 ORDER BY `minOrder` ASC [ RunTime:0.056720s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14499422 ORDER BY `unit` DESC [ RunTime:0.040882s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14499422 LIMIT 2 [ RunTime:0.041180s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14499422 ORDER BY `minOrder` ASC [ RunTime:0.039444s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14499421 LIMIT 5 [ RunTime:0.015804s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14499421 ORDER BY `minOrder` ASC [ RunTime:0.031707s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14499421 ORDER BY `unit` DESC [ RunTime:0.041461s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14499421 LIMIT 2 [ RunTime:0.020757s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14499421 ORDER BY `minOrder` ASC [ RunTime:0.013358s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13631172 LIMIT 5 [ RunTime:0.007888s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13631172 ORDER BY `minOrder` ASC [ RunTime:0.010078s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13631172 ORDER BY `unit` DESC [ RunTime:0.004691s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13631172 LIMIT 2 [ RunTime:0.003054s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13631172 ORDER BY `minOrder` ASC [ RunTime:0.021167s ]
select * from pdf where partno='UTP28SP1MVL' and brandshort='Panduit Corp' limit 1 [ RunTime:0.012476s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13631171 LIMIT 5 [ RunTime:0.005875s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13631171 ORDER BY `minOrder` ASC [ RunTime:0.003216s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13631171 ORDER BY `unit` DESC [ RunTime:0.000697s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13631171 LIMIT 2 [ RunTime:0.000738s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13631171 ORDER BY `minOrder` ASC [ RunTime:0.000478s ]
select * from pdf where partno='UTP28SP1MRD' and brandshort='Panduit Corp' limit 1 [ RunTime:0.005011s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13631170 LIMIT 5 [ RunTime:0.001899s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13631170 ORDER BY `minOrder` ASC [ RunTime:0.001997s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13631170 ORDER BY `unit` DESC [ RunTime:0.010611s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13631170 LIMIT 2 [ RunTime:0.012238s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13631170 ORDER BY `minOrder` ASC [ RunTime:0.009632s ]
select * from pdf where partno='UTP28SP1MOR' and brandshort='Panduit Corp' limit 1 [ RunTime:0.000617s ]
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 'UTP28SP1M%' OR `brand` LIKE 'UTP28SP1M%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003576s ]
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 'UTP28SP1M%' OR `brand` LIKE 'UTP28SP1M%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.012674s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 55574308 LIMIT 5 [ RunTime:0.005902s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55574308 ORDER BY `minOrder` ASC [ RunTime:0.013709s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 55574308 ORDER BY `unit` DESC [ RunTime:0.002690s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 55574308 LIMIT 2 [ RunTime:0.005762s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55574308 ORDER BY `minOrder` ASC [ RunTime:0.017340s ]
select * from pdf where partno='UTP28SP1MYL' and brandshort='Panduit Corp' limit 1 [ RunTime:0.008203s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002216s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'UTP28SP1MYL' OR `brand` LIKE 'Panduit Corp%' ) ) LIMIT 1 [ RunTime:0.012859s ]
SELECT `id` FROM `stock` WHERE `id` <> 55574308 AND `partno` = 'UTP28SP1MYL' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%panduit corp%' ) [ RunTime:0.005618s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14499424 [ RunTime:0.001917s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 55574307 LIMIT 5 [ RunTime:0.006798s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55574307 ORDER BY `minOrder` ASC [ RunTime:0.007533s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 55574307 ORDER BY `unit` DESC [ RunTime:0.004907s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 55574307 LIMIT 2 [ RunTime:0.001933s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55574307 ORDER BY `minOrder` ASC [ RunTime:0.000535s ]
select * from pdf where partno='UTP28SP1MVL' and brandshort='Panduit Corp' limit 1 [ RunTime:0.000712s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'UTP28SP1MVL' OR `brand` LIKE 'Panduit Corp%' ) ) LIMIT 1 [ RunTime:0.002969s ]
SELECT `id` FROM `stock` WHERE `id` <> 55574307 AND `partno` = 'UTP28SP1MVL' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%panduit corp%' ) [ RunTime:0.009851s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13631172 [ RunTime:0.000805s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 55574306 LIMIT 5 [ RunTime:0.002670s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55574306 ORDER BY `minOrder` ASC [ RunTime:0.001024s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 55574306 ORDER BY `unit` DESC [ RunTime:0.000751s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 55574306 LIMIT 2 [ RunTime:0.011599s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55574306 ORDER BY `minOrder` ASC [ RunTime:0.002292s ]
select * from pdf where partno='UTP28SP1MRD' and brandshort='Panduit Corp' limit 1 [ RunTime:0.002438s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'UTP28SP1MRD' OR `brand` LIKE 'Panduit Corp%' ) ) LIMIT 1 [ RunTime:0.001004s ]
SELECT `id` FROM `stock` WHERE `id` <> 55574306 AND `partno` = 'UTP28SP1MRD' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%panduit corp%' ) [ RunTime:0.000947s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13631171 [ RunTime:0.000747s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 55574305 LIMIT 5 [ RunTime:0.017098s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55574305 ORDER BY `minOrder` ASC [ RunTime:0.027246s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 55574305 ORDER BY `unit` DESC [ RunTime:0.027383s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 55574305 LIMIT 2 [ RunTime:0.009499s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55574305 ORDER BY `minOrder` ASC [ RunTime:0.002480s ]
select * from pdf where partno='UTP28SP1MPK' and brandshort='Panduit Corp' limit 1 [ RunTime:0.004402s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'UTP28SP1MPK' OR `brand` LIKE 'Panduit Corp%' ) ) LIMIT 1 [ RunTime:0.005023s ]
SELECT `id` FROM `stock` WHERE `id` <> 55574305 AND `partno` = 'UTP28SP1MPK' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%panduit corp%' ) [ RunTime:0.007359s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14499423 [ RunTime:0.013643s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 55574304 LIMIT 5 [ RunTime:0.005860s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55574304 ORDER BY `minOrder` ASC [ RunTime:0.028352s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 55574304 ORDER BY `unit` DESC [ RunTime:0.026582s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 55574304 LIMIT 2 [ RunTime:0.003923s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55574304 ORDER BY `minOrder` ASC [ RunTime:0.009529s ]
select * from pdf where partno='UTP28SP1MOR' and brandshort='Panduit Corp' limit 1 [ RunTime:0.013889s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'UTP28SP1MOR' OR `brand` LIKE 'Panduit Corp%' ) ) LIMIT 1 [ RunTime:0.004365s ]
SELECT `id` FROM `stock` WHERE `id` <> 55574304 AND `partno` = 'UTP28SP1MOR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%panduit corp%' ) [ RunTime:0.050602s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13631170 [ RunTime:0.018648s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 55574303 LIMIT 5 [ RunTime:0.054967s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55574303 ORDER BY `minOrder` ASC [ RunTime:0.020310s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 55574303 ORDER BY `unit` DESC [ RunTime:0.033461s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 55574303 LIMIT 2 [ RunTime:0.049328s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55574303 ORDER BY `minOrder` ASC [ RunTime:0.013918s ]
select * from pdf where partno='UTP28SP1MGY' and brandshort='Panduit Corp' limit 1 [ RunTime:0.014773s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'UTP28SP1MGY' OR `brand` LIKE 'Panduit Corp%' ) ) LIMIT 1 [ RunTime:0.034037s ]
SELECT `id` FROM `stock` WHERE `id` <> 55574303 AND `partno` = 'UTP28SP1MGY' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%panduit corp%' ) [ RunTime:0.010904s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14499422 [ RunTime:0.000424s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 55574302 LIMIT 5 [ RunTime:0.010465s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55574302 ORDER BY `minOrder` ASC [ RunTime:0.027898s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 55574302 ORDER BY `unit` DESC [ RunTime:0.042911s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 55574302 LIMIT 2 [ RunTime:0.032169s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55574302 ORDER BY `minOrder` ASC [ RunTime:0.018262s ]
select * from pdf where partno='UTP28SP1MGR' and brandshort='Panduit Corp' limit 1 [ RunTime:0.043098s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'UTP28SP1MGR' OR `brand` LIKE 'Panduit Corp%' ) ) LIMIT 1 [ RunTime:0.017279s ]
SELECT `id` FROM `stock` WHERE `id` <> 55574302 AND `partno` = 'UTP28SP1MGR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%panduit corp%' ) [ RunTime:0.013232s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14499421 [ RunTime:0.027226s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 55568438 LIMIT 5 [ RunTime:0.037643s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55568438 ORDER BY `minOrder` ASC [ RunTime:0.083784s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 55568438 ORDER BY `unit` DESC [ RunTime:0.046402s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 55568438 LIMIT 2 [ RunTime:0.027471s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55568438 ORDER BY `minOrder` ASC [ RunTime:0.009398s ]
select * from pdf where partno='UTP28SP1MBL' and brandshort='Panduit Corp' limit 1 [ RunTime:0.026214s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'UTP28SP1MBL' OR `brand` LIKE 'Panduit Corp%' ) ) LIMIT 1 [ RunTime:0.028522s ]
SELECT `id` FROM `stock` WHERE `id` <> 55568438 AND `partno` = 'UTP28SP1MBL' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%panduit corp%' ) [ RunTime:0.021310s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16503681 [ RunTime:0.029089s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 55566750 LIMIT 5 [ RunTime:0.019046s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55566750 ORDER BY `minOrder` ASC [ RunTime:0.016821s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 55566750 ORDER BY `unit` DESC [ RunTime:0.034407s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 55566750 LIMIT 2 [ RunTime:0.032215s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55566750 ORDER BY `minOrder` ASC [ RunTime:0.024256s ]
select * from pdf where partno='UTP28SP1MBU' and brandshort='Panduit Corp' limit 1 [ RunTime:0.006959s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'UTP28SP1MBU' OR `brand` LIKE 'Panduit Corp%' ) ) LIMIT 1 [ RunTime:0.024216s ]
SELECT `id` FROM `stock` WHERE `id` <> 55566750 AND `partno` = 'UTP28SP1MBU' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%panduit corp%' ) [ RunTime:0.018106s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14506443 [ RunTime:0.027429s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 55566749 LIMIT 5 [ RunTime:0.018633s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55566749 ORDER BY `minOrder` ASC [ RunTime:0.014897s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 55566749 ORDER BY `unit` DESC [ RunTime:0.003634s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 55566749 LIMIT 2 [ RunTime:0.030889s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55566749 ORDER BY `minOrder` ASC [ RunTime:0.005478s ]
select * from pdf where partno='UTP28SP1M' and brandshort='Panduit Corp' limit 1 [ RunTime:0.023646s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'UTP28SP1M' OR `brand` LIKE 'Panduit Corp%' ) ) LIMIT 1 [ RunTime:0.006359s ]
SELECT `id` FROM `stock` WHERE `id` <> 55566749 AND `partno` = 'UTP28SP1M' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%panduit corp%' ) [ RunTime:0.031254s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14504134 [ RunTime:0.005403s ]
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 'UTP28SP1M%' OR `brand` LIKE 'UTP28SP1M%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.023646s ]
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 'UTP28SP1M%' OR `brand` LIKE 'UTP28SP1M%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.025692s ]
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 'UTP28SP1M%' OR `brand` LIKE 'UTP28SP1M%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.015659s ]
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 'UTP28SP1M%' OR `brand` LIKE 'UTP28SP1M%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.023651s ]
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 'UTP28SP1M%' OR `brand` LIKE 'UTP28SP1M%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.011794s ]
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 'UTP28SP1M%' OR `brand` LIKE 'UTP28SP1M%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.027772s ]
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 'UTP28SP1M%' OR `brand` LIKE 'UTP28SP1M%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.042340s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'UTP28SP1M%' OR `brand` LIKE 'UTP28SP1M%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.026488s ]