SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001396s ]
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 'UTP28X125%' OR `brand` LIKE 'UTP28X125%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.038151s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.004229s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16499336 LIMIT 5 [ RunTime:0.002118s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.003669s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16499336 ORDER BY `minOrder` ASC [ RunTime:0.012514s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.002531s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16499336 ORDER BY `unit` DESC [ RunTime:0.007422s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.004063s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16499336 LIMIT 2 [ RunTime:0.036530s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16499336 ORDER BY `minOrder` ASC [ RunTime:0.014498s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16499335 LIMIT 5 [ RunTime:0.036927s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16499335 ORDER BY `minOrder` ASC [ RunTime:0.031446s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16499335 ORDER BY `unit` DESC [ RunTime:0.024120s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16499335 LIMIT 2 [ RunTime:0.016918s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16499335 ORDER BY `minOrder` ASC [ RunTime:0.008734s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14508001 LIMIT 5 [ RunTime:0.005444s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14508001 ORDER BY `minOrder` ASC [ RunTime:0.008618s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14508001 ORDER BY `unit` DESC [ RunTime:0.027320s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14508001 LIMIT 2 [ RunTime:0.010534s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14508001 ORDER BY `minOrder` ASC [ RunTime:0.011162s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14508000 LIMIT 5 [ RunTime:0.010209s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14508000 ORDER BY `minOrder` ASC [ RunTime:0.023868s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14508000 ORDER BY `unit` DESC [ RunTime:0.010269s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14508000 LIMIT 2 [ RunTime:0.023235s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14508000 ORDER BY `minOrder` ASC [ RunTime:0.003473s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14507999 LIMIT 5 [ RunTime:0.024578s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14507999 ORDER BY `minOrder` ASC [ RunTime:0.019542s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14507999 ORDER BY `unit` DESC [ RunTime:0.019982s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14507999 LIMIT 2 [ RunTime:0.048975s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14507999 ORDER BY `minOrder` ASC [ RunTime:0.005239s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14507998 LIMIT 5 [ RunTime:0.010455s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14507998 ORDER BY `minOrder` ASC [ RunTime:0.023312s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14507998 ORDER BY `unit` DESC [ RunTime:0.027232s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14507998 LIMIT 2 [ RunTime:0.021467s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14507998 ORDER BY `minOrder` ASC [ RunTime:0.039160s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14507997 LIMIT 5 [ RunTime:0.010360s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14507997 ORDER BY `minOrder` ASC [ RunTime:0.042179s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14507997 ORDER BY `unit` DESC [ RunTime:0.008626s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14507997 LIMIT 2 [ RunTime:0.030303s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14507997 ORDER BY `minOrder` ASC [ RunTime:0.010798s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14507996 LIMIT 5 [ RunTime:0.029804s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14507996 ORDER BY `minOrder` ASC [ RunTime:0.027498s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14507996 ORDER BY `unit` DESC [ RunTime:0.033787s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14507996 LIMIT 2 [ RunTime:0.034904s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14507996 ORDER BY `minOrder` ASC [ RunTime:0.018158s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14507995 LIMIT 5 [ RunTime:0.011858s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14507995 ORDER BY `minOrder` ASC [ RunTime:0.037524s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14507995 ORDER BY `unit` DESC [ RunTime:0.063900s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14507995 LIMIT 2 [ RunTime:0.017940s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14507995 ORDER BY `minOrder` ASC [ RunTime:0.008910s ]
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 'UTP28X125%' OR `brand` LIKE 'UTP28X125%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.033135s ]
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 'UTP28X125%' OR `brand` LIKE 'UTP28X125%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.020155s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 55593237 LIMIT 5 [ RunTime:0.004857s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55593237 ORDER BY `minOrder` ASC [ RunTime:0.001784s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 55593237 ORDER BY `unit` DESC [ RunTime:0.007094s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 55593237 LIMIT 2 [ RunTime:0.001475s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55593237 ORDER BY `minOrder` ASC [ RunTime:0.023698s ]
select * from pdf where partno='UTP28X125YL' and brandshort='Panduit Corp' limit 1 [ RunTime:0.005905s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.004421s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'UTP28X125YL' OR `brand` LIKE 'Panduit Corp%' ) ) LIMIT 1 [ RunTime:0.011069s ]
SELECT `id` FROM `stock` WHERE `id` <> 55593237 AND `partno` = 'UTP28X125YL' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%panduit corp%' ) [ RunTime:0.002045s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14508001 [ RunTime:0.003986s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 55593236 LIMIT 5 [ RunTime:0.002753s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55593236 ORDER BY `minOrder` ASC [ RunTime:0.012472s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 55593236 ORDER BY `unit` DESC [ RunTime:0.009964s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 55593236 LIMIT 2 [ RunTime:0.015158s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55593236 ORDER BY `minOrder` ASC [ RunTime:0.000611s ]
select * from pdf where partno='UTP28X125RD' and brandshort='Panduit Corp' limit 1 [ RunTime:0.004134s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'UTP28X125RD' OR `brand` LIKE 'Panduit Corp%' ) ) LIMIT 1 [ RunTime:0.010237s ]
SELECT `id` FROM `stock` WHERE `id` <> 55593236 AND `partno` = 'UTP28X125RD' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%panduit corp%' ) [ RunTime:0.010627s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14507999 [ RunTime:0.016862s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 55593235 LIMIT 5 [ RunTime:0.001080s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55593235 ORDER BY `minOrder` ASC [ RunTime:0.003604s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 55593235 ORDER BY `unit` DESC [ RunTime:0.010062s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 55593235 LIMIT 2 [ RunTime:0.008542s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55593235 ORDER BY `minOrder` ASC [ RunTime:0.004529s ]
select * from pdf where partno='UTP28X125OR' and brandshort='Panduit Corp' limit 1 [ RunTime:0.017004s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'UTP28X125OR' OR `brand` LIKE 'Panduit Corp%' ) ) LIMIT 1 [ RunTime:0.005235s ]
SELECT `id` FROM `stock` WHERE `id` <> 55593235 AND `partno` = 'UTP28X125OR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%panduit corp%' ) [ RunTime:0.004049s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14507998 [ RunTime:0.026187s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 55593234 LIMIT 5 [ RunTime:0.003466s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55593234 ORDER BY `minOrder` ASC [ RunTime:0.002570s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 55593234 ORDER BY `unit` DESC [ RunTime:0.000939s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 55593234 LIMIT 2 [ RunTime:0.002517s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55593234 ORDER BY `minOrder` ASC [ RunTime:0.005744s ]
select * from pdf where partno='UTP28X125GY' and brandshort='Panduit Corp' limit 1 [ RunTime:0.000681s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'UTP28X125GY' OR `brand` LIKE 'Panduit Corp%' ) ) LIMIT 1 [ RunTime:0.000599s ]
SELECT `id` FROM `stock` WHERE `id` <> 55593234 AND `partno` = 'UTP28X125GY' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%panduit corp%' ) [ RunTime:0.000632s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16499336 [ RunTime:0.000560s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 55593233 LIMIT 5 [ RunTime:0.017447s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55593233 ORDER BY `minOrder` ASC [ RunTime:0.009502s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 55593233 ORDER BY `unit` DESC [ RunTime:0.000998s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 55593233 LIMIT 2 [ RunTime:0.007551s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55593233 ORDER BY `minOrder` ASC [ RunTime:0.003170s ]
select * from pdf where partno='UTP28X125GR' and brandshort='Panduit Corp' limit 1 [ RunTime:0.001910s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'UTP28X125GR' OR `brand` LIKE 'Panduit Corp%' ) ) LIMIT 1 [ RunTime:0.008726s ]
SELECT `id` FROM `stock` WHERE `id` <> 55593233 AND `partno` = 'UTP28X125GR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%panduit corp%' ) [ RunTime:0.009568s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16499335 [ RunTime:0.005560s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 55593232 LIMIT 5 [ RunTime:0.000758s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55593232 ORDER BY `minOrder` ASC [ RunTime:0.002111s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 55593232 ORDER BY `unit` DESC [ RunTime:0.002615s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 55593232 LIMIT 2 [ RunTime:0.002151s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55593232 ORDER BY `minOrder` ASC [ RunTime:0.000366s ]
select * from pdf where partno='UTP28X125BL' and brandshort='Panduit Corp' limit 1 [ RunTime:0.011282s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'UTP28X125BL' OR `brand` LIKE 'Panduit Corp%' ) ) LIMIT 1 [ RunTime:0.017378s ]
SELECT `id` FROM `stock` WHERE `id` <> 55593232 AND `partno` = 'UTP28X125BL' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%panduit corp%' ) [ RunTime:0.006760s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14507996 [ RunTime:0.000481s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 55593231 LIMIT 5 [ RunTime:0.005740s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55593231 ORDER BY `minOrder` ASC [ RunTime:0.013099s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 55593231 ORDER BY `unit` DESC [ RunTime:0.005810s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 55593231 LIMIT 2 [ RunTime:0.009155s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55593231 ORDER BY `minOrder` ASC [ RunTime:0.003146s ]
select * from pdf where partno='UTP28X125' and brandshort='Panduit Corp' limit 1 [ RunTime:0.004526s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'UTP28X125' OR `brand` LIKE 'Panduit Corp%' ) ) LIMIT 1 [ RunTime:0.005733s ]
SELECT `id` FROM `stock` WHERE `id` <> 55593231 AND `partno` = 'UTP28X125' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%panduit corp%' ) [ RunTime:0.018168s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14507995 [ RunTime:0.033589s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 55593216 LIMIT 5 [ RunTime:0.016499s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55593216 ORDER BY `minOrder` ASC [ RunTime:0.020175s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 55593216 ORDER BY `unit` DESC [ RunTime:0.010315s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 55593216 LIMIT 2 [ RunTime:0.009263s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55593216 ORDER BY `minOrder` ASC [ RunTime:0.019554s ]
select * from pdf where partno='UTP28X125VL' and brandshort='Panduit Corp' limit 1 [ RunTime:0.008824s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'UTP28X125VL' OR `brand` LIKE 'Panduit Corp%' ) ) LIMIT 1 [ RunTime:0.003812s ]
SELECT `id` FROM `stock` WHERE `id` <> 55593216 AND `partno` = 'UTP28X125VL' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%panduit corp%' ) [ RunTime:0.015175s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14508000 [ RunTime:0.013831s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 55593215 LIMIT 5 [ RunTime:0.027537s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55593215 ORDER BY `minOrder` ASC [ RunTime:0.009740s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 55593215 ORDER BY `unit` DESC [ RunTime:0.015032s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 55593215 LIMIT 2 [ RunTime:0.016178s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55593215 ORDER BY `minOrder` ASC [ RunTime:0.017948s ]
select * from pdf where partno='UTP28X125BU' and brandshort='Panduit Corp' limit 1 [ RunTime:0.043332s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'UTP28X125BU' OR `brand` LIKE 'Panduit Corp%' ) ) LIMIT 1 [ RunTime:0.024081s ]
SELECT `id` FROM `stock` WHERE `id` <> 55593215 AND `partno` = 'UTP28X125BU' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%panduit corp%' ) [ RunTime:0.006268s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14507997 [ RunTime:0.026789s ]
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 'UTP28X125%' OR `brand` LIKE 'UTP28X125%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.018892s ]
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 'UTP28X125%' OR `brand` LIKE 'UTP28X125%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.011774s ]
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 'UTP28X125%' OR `brand` LIKE 'UTP28X125%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.017739s ]
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 'UTP28X125%' OR `brand` LIKE 'UTP28X125%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.049424s ]
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 'UTP28X125%' OR `brand` LIKE 'UTP28X125%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.036066s ]
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 'UTP28X125%' OR `brand` LIKE 'UTP28X125%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.084212s ]
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 'UTP28X125%' OR `brand` LIKE 'UTP28X125%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.062458s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'UTP28X125%' OR `brand` LIKE 'UTP28X125%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.066495s ]