SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002501s ]
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 '121863%' OR `brand` LIKE '121863%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.009079s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001467s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19655619 LIMIT 5 [ RunTime:0.005679s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001748s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19655619 ORDER BY `minOrder` ASC [ RunTime:0.010692s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.005403s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19655619 ORDER BY `unit` DESC [ RunTime:0.001333s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.010670s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19655619 LIMIT 2 [ RunTime:0.007603s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19655619 ORDER BY `minOrder` ASC [ RunTime:0.009194s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16505300 LIMIT 5 [ RunTime:0.014058s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16505300 ORDER BY `minOrder` ASC [ RunTime:0.013097s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16505300 ORDER BY `unit` DESC [ RunTime:0.021063s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16505300 LIMIT 2 [ RunTime:0.015862s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16505300 ORDER BY `minOrder` ASC [ RunTime:0.001520s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12500957 LIMIT 5 [ RunTime:0.015560s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12500957 ORDER BY `minOrder` ASC [ RunTime:0.004968s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12500957 ORDER BY `unit` DESC [ RunTime:0.018911s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12500957 LIMIT 2 [ RunTime:0.011878s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12500957 ORDER BY `minOrder` ASC [ RunTime:0.014999s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12198035 LIMIT 5 [ RunTime:0.009699s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12198035 ORDER BY `minOrder` ASC [ RunTime:0.021023s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12198035 ORDER BY `unit` DESC [ RunTime:0.015950s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12198035 LIMIT 2 [ RunTime:0.008756s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12198035 ORDER BY `minOrder` ASC [ RunTime:0.006880s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12197484 LIMIT 5 [ RunTime:0.008556s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12197484 ORDER BY `minOrder` ASC [ RunTime:0.011080s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12197484 ORDER BY `unit` DESC [ RunTime:0.017180s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12197484 LIMIT 2 [ RunTime:0.001368s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12197484 ORDER BY `minOrder` ASC [ RunTime:0.004167s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11406786 LIMIT 5 [ RunTime:0.002186s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11406786 ORDER BY `minOrder` ASC [ RunTime:0.001757s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11406786 ORDER BY `unit` DESC [ RunTime:0.003542s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11406786 LIMIT 2 [ RunTime:0.000485s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11406786 ORDER BY `minOrder` ASC [ RunTime:0.002871s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11206344 LIMIT 5 [ RunTime:0.000845s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11206344 ORDER BY `minOrder` ASC [ RunTime:0.001408s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11206344 ORDER BY `unit` DESC [ RunTime:0.000506s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11206344 LIMIT 2 [ RunTime:0.001093s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11206344 ORDER BY `minOrder` ASC [ RunTime:0.000394s ]
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 '121863%' OR `brand` LIKE '121863%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001254s ]
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 '121863%' OR `brand` LIKE '121863%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003999s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60632881 LIMIT 5 [ RunTime:0.001463s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60632881 ORDER BY `minOrder` ASC [ RunTime:0.001523s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60632881 ORDER BY `unit` DESC [ RunTime:0.000811s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60632881 LIMIT 2 [ RunTime:0.000661s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60632881 ORDER BY `minOrder` ASC [ RunTime:0.000321s ]
select * from pdf where partno='1218639-1' and brandshort='WEC' limit 1 [ RunTime:0.001500s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001286s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1218639-1' OR `brand` LIKE 'WEC%' ) ) LIMIT 1 [ RunTime:0.000971s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60633172 LIMIT 5 [ RunTime:0.000708s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60633172 ORDER BY `minOrder` ASC [ RunTime:0.000483s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60633172 ORDER BY `unit` DESC [ RunTime:0.004494s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60633172 LIMIT 2 [ RunTime:0.001049s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60633172 ORDER BY `minOrder` ASC [ RunTime:0.000228s ]
select * from pdf where partno='1218639-1' and brandshort='TE Connectivity Aerospace, Defense and Marine' limit 1 [ RunTime:0.000936s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1218639-1' OR `brand` LIKE 'TE Connectivity Aerospace, Defense and Marine%' ) ) LIMIT 1 [ RunTime:0.000424s ]
SELECT `id` FROM `stock` WHERE `id` <> 60633172 AND `partno` = '1218639-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity aerospace, defense and marine%' ) [ RunTime:0.000577s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11406786 [ RunTime:0.000660s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60633159 LIMIT 5 [ RunTime:0.001551s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60633159 ORDER BY `minOrder` ASC [ RunTime:0.002475s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60633159 ORDER BY `unit` DESC [ RunTime:0.002555s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60633159 LIMIT 2 [ RunTime:0.002262s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60633159 ORDER BY `minOrder` ASC [ RunTime:0.000755s ]
select * from pdf where partno='1218638-1' and brandshort='TE Connectivity Aerospace, Defense and Marine' limit 1 [ RunTime:0.000837s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1218638-1' OR `brand` LIKE 'TE Connectivity Aerospace, Defense and Marine%' ) ) LIMIT 1 [ RunTime:0.004268s ]
SELECT `id` FROM `stock` WHERE `id` <> 60633159 AND `partno` = '1218638-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity aerospace, defense and marine%' ) [ RunTime:0.002246s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60632894 LIMIT 5 [ RunTime:0.003128s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60632894 ORDER BY `minOrder` ASC [ RunTime:0.001165s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60632894 ORDER BY `unit` DESC [ RunTime:0.005821s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60632894 LIMIT 2 [ RunTime:0.002263s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60632894 ORDER BY `minOrder` ASC [ RunTime:0.000743s ]
select * from pdf where partno='1218630-1' and brandshort='TE Connectivity Aerospace, Defense and Marine' limit 1 [ RunTime:0.001200s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1218630-1' OR `brand` LIKE 'TE Connectivity Aerospace, Defense and Marine%' ) ) LIMIT 1 [ RunTime:0.000750s ]
SELECT `id` FROM `stock` WHERE `id` <> 60632894 AND `partno` = '1218630-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity aerospace, defense and marine%' ) [ RunTime:0.002097s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60554884 LIMIT 5 [ RunTime:0.001126s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60554884 ORDER BY `minOrder` ASC [ RunTime:0.002124s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60554884 ORDER BY `unit` DESC [ RunTime:0.002143s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60554884 LIMIT 2 [ RunTime:0.000520s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60554884 ORDER BY `minOrder` ASC [ RunTime:0.001682s ]
select * from pdf where partno='1218630000' and brandshort='Weidmüller' limit 1 [ RunTime:0.000467s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1218630000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.000318s ]
SELECT `id` FROM `stock` WHERE `id` <> 60554884 AND `partno` = '1218630000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.000767s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19655619 [ RunTime:0.001299s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57701766 LIMIT 5 [ RunTime:0.004732s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57701766 ORDER BY `minOrder` ASC [ RunTime:0.003792s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57701766 ORDER BY `unit` DESC [ RunTime:0.006174s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57701766 LIMIT 2 [ RunTime:0.001895s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57701766 ORDER BY `minOrder` ASC [ RunTime:0.000970s ]
select * from pdf where partno='121863' and brandshort='Brady Corporation' limit 1 [ RunTime:0.002660s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '121863' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.003339s ]
SELECT `id` FROM `stock` WHERE `id` <> 57701766 AND `partno` = '121863' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.001314s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16505300 [ RunTime:0.002457s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57652849 LIMIT 5 [ RunTime:0.002332s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57652849 ORDER BY `minOrder` ASC [ RunTime:0.002154s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57652849 ORDER BY `unit` DESC [ RunTime:0.001796s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57652849 LIMIT 2 [ RunTime:0.003997s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57652849 ORDER BY `minOrder` ASC [ RunTime:0.000789s ]
select * from pdf where partno='1218636' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.000996s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1218636' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.001300s ]
SELECT `id` FROM `stock` WHERE `id` <> 57652849 AND `partno` = '1218636' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.001878s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12198035 [ RunTime:0.001775s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57652683 LIMIT 5 [ RunTime:0.003149s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57652683 ORDER BY `minOrder` ASC [ RunTime:0.002078s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57652683 ORDER BY `unit` DESC [ RunTime:0.002132s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57652683 LIMIT 2 [ RunTime:0.001625s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57652683 ORDER BY `minOrder` ASC [ RunTime:0.001172s ]
select * from pdf where partno='1218635' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.001019s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1218635' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.000622s ]
SELECT `id` FROM `stock` WHERE `id` <> 57652683 AND `partno` = '1218635' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.001958s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57651642 LIMIT 5 [ RunTime:0.001216s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57651642 ORDER BY `minOrder` ASC [ RunTime:0.002101s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57651642 ORDER BY `unit` DESC [ RunTime:0.002246s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57651642 LIMIT 2 [ RunTime:0.001537s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57651642 ORDER BY `minOrder` ASC [ RunTime:0.001088s ]
select * from pdf where partno='1218634' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.001162s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1218634' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.002104s ]
SELECT `id` FROM `stock` WHERE `id` <> 57651642 AND `partno` = '1218634' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.002271s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12197484 [ RunTime:0.001381s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57650989 LIMIT 5 [ RunTime:0.002923s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57650989 ORDER BY `minOrder` ASC [ RunTime:0.002349s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57650989 ORDER BY `unit` DESC [ RunTime:0.002266s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57650989 LIMIT 2 [ RunTime:0.003966s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57650989 ORDER BY `minOrder` ASC [ RunTime:0.003199s ]
select * from pdf where partno='1218637' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.001077s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1218637' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.006635s ]
SELECT `id` FROM `stock` WHERE `id` <> 57650989 AND `partno` = '1218637' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.001564s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11206344 [ RunTime:0.005110s ]
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 '121863%' OR `brand` LIKE '121863%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003201s ]
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 '121863%' OR `brand` LIKE '121863%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002305s ]
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 '121863%' OR `brand` LIKE '121863%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001493s ]
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 '121863%' OR `brand` LIKE '121863%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001384s ]
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 '121863%' OR `brand` LIKE '121863%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000759s ]
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 '121863%' OR `brand` LIKE '121863%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002892s ]
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 '121863%' OR `brand` LIKE '121863%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001321s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '121863%' OR `brand` LIKE '121863%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.007717s ]