SHOW FULL COLUMNS FROM `stock` [ RunTime:0.003557s ]
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 '25524%' OR `brand` LIKE '25524%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.127354s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.002441s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12041619 LIMIT 5 [ RunTime:0.046070s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.006730s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12041619 ORDER BY `minOrder` ASC [ RunTime:0.079138s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.008233s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12041619 ORDER BY `unit` DESC [ RunTime:0.013345s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.001262s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12041619 LIMIT 2 [ RunTime:0.031073s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12041619 ORDER BY `minOrder` ASC [ RunTime:0.031876s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14422165 LIMIT 5 [ RunTime:0.086786s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14422165 ORDER BY `minOrder` ASC [ RunTime:0.111745s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14422165 ORDER BY `unit` DESC [ RunTime:0.062372s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14422165 LIMIT 2 [ RunTime:0.167560s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14422165 ORDER BY `minOrder` ASC [ RunTime:0.045896s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13512724 LIMIT 5 [ RunTime:0.032670s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13512724 ORDER BY `minOrder` ASC [ RunTime:0.034628s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13512724 ORDER BY `unit` DESC [ RunTime:0.122523s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13512724 LIMIT 2 [ RunTime:0.017282s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13512724 ORDER BY `minOrder` ASC [ RunTime:0.000646s ]
select * from pdf where partno='25524 BK005' and brandshort='Alpha Wire' limit 1 [ RunTime:0.027437s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13507859 LIMIT 5 [ RunTime:0.038093s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13507859 ORDER BY `minOrder` ASC [ RunTime:0.043699s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13507859 ORDER BY `unit` DESC [ RunTime:0.024125s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13507859 LIMIT 2 [ RunTime:0.082206s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13507859 ORDER BY `minOrder` ASC [ RunTime:0.026180s ]
select * from pdf where partno='25524 SL199' and brandshort='Alpha Wire' limit 1 [ RunTime:0.026774s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13507858 LIMIT 5 [ RunTime:0.028439s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13507858 ORDER BY `minOrder` ASC [ RunTime:0.076692s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13507858 ORDER BY `unit` DESC [ RunTime:0.122251s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13507858 LIMIT 2 [ RunTime:0.016181s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13507858 ORDER BY `minOrder` ASC [ RunTime:0.021226s ]
select * from pdf where partno='25524 BK199' and brandshort='Alpha Wire' limit 1 [ RunTime:0.016603s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12564031 LIMIT 5 [ RunTime:0.053174s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12564031 ORDER BY `minOrder` ASC [ RunTime:0.163413s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12564031 ORDER BY `unit` DESC [ RunTime:0.073281s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12564031 LIMIT 2 [ RunTime:0.079000s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12564031 ORDER BY `minOrder` ASC [ RunTime:0.013894s ]
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 '25524%' OR `brand` LIKE '25524%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.028849s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51087093 LIMIT 5 [ RunTime:0.027713s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51087093 ORDER BY `minOrder` ASC [ RunTime:0.048008s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51087093 ORDER BY `unit` DESC [ RunTime:0.027388s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51087093 LIMIT 2 [ RunTime:0.016329s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51087093 ORDER BY `minOrder` ASC [ RunTime:0.014381s ]
select * from pdf where partno='2552480000' and brandshort='weidmuller' limit 1 [ RunTime:0.047679s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002225s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2552480000' OR `brand` LIKE 'weidmuller%' ) ) LIMIT 1 [ RunTime:0.034772s ]
SELECT `id` FROM `stock` WHERE `id` <> 51087093 AND `partno` = '2552480000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmuller%' ) [ RunTime:0.033436s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12564031 [ RunTime:0.012986s ]
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 '25524%' OR `brand` LIKE '25524%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.030911s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 49574404 LIMIT 5 [ RunTime:0.073431s ]
SELECT * FROM `stock_price` WHERE `stockid` = 49574404 ORDER BY `minOrder` ASC [ RunTime:0.043359s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 49574404 ORDER BY `unit` DESC [ RunTime:0.072771s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 49574404 LIMIT 2 [ RunTime:0.072037s ]
SELECT * FROM `stock_price` WHERE `stockid` = 49574404 ORDER BY `minOrder` ASC [ RunTime:0.044463s ]
select * from pdf where partno='25524' and brandshort='Keystone Electronics' limit 1 [ RunTime:0.117038s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '25524' OR `brand` LIKE 'Keystone Electronics%' ) ) LIMIT 1 [ RunTime:0.072253s ]
SELECT `id` FROM `stock` WHERE `id` <> 49574404 AND `partno` = '25524' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%keystone electronics%' ) [ RunTime:0.110953s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12041619 [ RunTime:0.209952s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36767615 LIMIT 5 [ RunTime:0.075823s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36767615 ORDER BY `minOrder` ASC [ RunTime:0.111903s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36767615 ORDER BY `unit` DESC [ RunTime:0.047971s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36767615 LIMIT 2 [ RunTime:0.078843s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36767615 ORDER BY `minOrder` ASC [ RunTime:0.023930s ]
select * from pdf where partno='25524' and brandshort='Keystone Electronics' limit 1 [ RunTime:0.004302s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '25524' OR `brand` LIKE 'Keystone Electronics%' ) ) LIMIT 1 [ RunTime:0.021616s ]
SELECT `id` FROM `stock` WHERE `id` <> 36767615 AND `partno` = '25524' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%keystone electronics%' ) [ RunTime:0.037210s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12041619 [ RunTime:0.039784s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53652368 LIMIT 5 [ RunTime:0.080879s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53652368 ORDER BY `minOrder` ASC [ RunTime:0.098570s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53652368 ORDER BY `unit` DESC [ RunTime:0.033820s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53652368 LIMIT 2 [ RunTime:0.048542s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53652368 ORDER BY `minOrder` ASC [ RunTime:0.023997s ]
select * from pdf where partno='2552480000' and brandshort='Weidmüller' limit 1 [ RunTime:0.064055s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2552480000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.039931s ]
SELECT `id` FROM `stock` WHERE `id` <> 53652368 AND `partno` = '2552480000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.059177s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12564031 [ RunTime:0.010813s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 50705817 LIMIT 5 [ RunTime:0.031830s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50705817 ORDER BY `minOrder` ASC [ RunTime:0.007507s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 50705817 ORDER BY `unit` DESC [ RunTime:0.057431s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 50705817 LIMIT 2 [ RunTime:0.011922s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50705817 ORDER BY `minOrder` ASC [ RunTime:0.020732s ]
select * from pdf where partno='25524' and brandshort='Brady Corporation' limit 1 [ RunTime:0.029540s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '25524' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.011033s ]
SELECT `id` FROM `stock` WHERE `id` <> 50705817 AND `partno` = '25524' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.020145s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14422165 [ RunTime:0.004333s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 49253922 LIMIT 5 [ RunTime:0.005335s ]
SELECT * FROM `stock_price` WHERE `stockid` = 49253922 ORDER BY `minOrder` ASC [ RunTime:0.013025s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 49253922 ORDER BY `unit` DESC [ RunTime:0.006047s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 49253922 LIMIT 2 [ RunTime:0.005908s ]
SELECT * FROM `stock_price` WHERE `stockid` = 49253922 ORDER BY `minOrder` ASC [ RunTime:0.013529s ]
select * from pdf where partno='25524.9' and brandshort='Conta-Clip, Inc.' limit 1 [ RunTime:0.023405s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '25524.9' OR `brand` LIKE 'Conta-Clip, Inc.%' ) ) LIMIT 1 [ RunTime:0.005751s ]
SELECT `id` FROM `stock` WHERE `id` <> 49253922 AND `partno` = '25524.9' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%conta-clip, inc.%' ) [ RunTime:0.014293s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36457477 [ RunTime:0.010468s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 49204146 LIMIT 5 [ RunTime:0.009665s ]
SELECT * FROM `stock_price` WHERE `stockid` = 49204146 ORDER BY `minOrder` ASC [ RunTime:0.002673s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 49204146 ORDER BY `unit` DESC [ RunTime:0.003212s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 49204146 LIMIT 2 [ RunTime:0.007830s ]
SELECT * FROM `stock_price` WHERE `stockid` = 49204146 ORDER BY `minOrder` ASC [ RunTime:0.008258s ]
select * from pdf where partno='25524 BK199' and brandshort='Alpha Wire' limit 1 [ RunTime:0.008099s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '25524 BK199' OR `brand` LIKE 'Alpha Wire%' ) ) LIMIT 1 [ RunTime:0.008014s ]
SELECT `id` FROM `stock` WHERE `id` <> 49204146 AND `partno` = '25524 BK199' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%alpha wire%' ) [ RunTime:0.013953s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13507858 [ RunTime:0.002505s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 49203008 LIMIT 5 [ RunTime:0.001539s ]
SELECT * FROM `stock_price` WHERE `stockid` = 49203008 ORDER BY `minOrder` ASC [ RunTime:0.001321s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 49203008 ORDER BY `unit` DESC [ RunTime:0.007122s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 49203008 LIMIT 2 [ RunTime:0.000396s ]
SELECT * FROM `stock_price` WHERE `stockid` = 49203008 ORDER BY `minOrder` ASC [ RunTime:0.000362s ]
select * from pdf where partno='25524 SL199' and brandshort='Alpha Wire' limit 1 [ RunTime:0.000739s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '25524 SL199' OR `brand` LIKE 'Alpha Wire%' ) ) LIMIT 1 [ RunTime:0.000383s ]
SELECT `id` FROM `stock` WHERE `id` <> 49203008 AND `partno` = '25524 SL199' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%alpha wire%' ) [ RunTime:0.001243s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13507859 [ RunTime:0.000346s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 38090866 LIMIT 5 [ RunTime:0.000567s ]
SELECT * FROM `stock_price` WHERE `stockid` = 38090866 ORDER BY `minOrder` ASC [ RunTime:0.007593s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 38090866 ORDER BY `unit` DESC [ RunTime:0.051012s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 38090866 LIMIT 2 [ RunTime:0.050951s ]
SELECT * FROM `stock_price` WHERE `stockid` = 38090866 ORDER BY `minOrder` ASC [ RunTime:0.040207s ]
select * from pdf where partno='25524' and brandshort='Brady Corporation' limit 1 [ RunTime:0.020345s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '25524' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.009856s ]
SELECT `id` FROM `stock` WHERE `id` <> 38090866 AND `partno` = '25524' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.013192s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14422165 [ RunTime:0.015281s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36457477 LIMIT 5 [ RunTime:0.001352s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36457477 ORDER BY `minOrder` ASC [ RunTime:0.007235s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36457477 ORDER BY `unit` DESC [ RunTime:0.001495s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36457477 LIMIT 2 [ RunTime:0.000255s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36457477 ORDER BY `minOrder` ASC [ RunTime:0.006939s ]
select * from pdf where partno='25524.9' and brandshort='Conta-Clip, Inc.' limit 1 [ RunTime:0.000899s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '25524.9' OR `brand` LIKE 'Conta-Clip, Inc.%' ) ) LIMIT 1 [ RunTime:0.007306s ]
SELECT `id` FROM `stock` WHERE `id` <> 36457477 AND `partno` = '25524.9' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%conta-clip, inc.%' ) [ RunTime:0.000620s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 49253922 [ RunTime:0.009801s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36408001 LIMIT 5 [ RunTime:0.000248s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36408001 ORDER BY `minOrder` ASC [ RunTime:0.000852s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36408001 ORDER BY `unit` DESC [ RunTime:0.001840s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36408001 LIMIT 2 [ RunTime:0.000233s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36408001 ORDER BY `minOrder` ASC [ RunTime:0.000223s ]
select * from pdf where partno='25524 BK199' and brandshort='Alpha Wire' limit 1 [ RunTime:0.000822s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '25524 BK199' OR `brand` LIKE 'Alpha Wire%' ) ) LIMIT 1 [ RunTime:0.000260s ]
SELECT `id` FROM `stock` WHERE `id` <> 36408001 AND `partno` = '25524 BK199' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%alpha wire%' ) [ RunTime:0.000593s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13507858 [ RunTime:0.004803s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36406865 LIMIT 5 [ RunTime:0.000290s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36406865 ORDER BY `minOrder` ASC [ RunTime:0.000981s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36406865 ORDER BY `unit` DESC [ RunTime:0.001076s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36406865 LIMIT 2 [ RunTime:0.000294s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36406865 ORDER BY `minOrder` ASC [ RunTime:0.000292s ]
select * from pdf where partno='25524 SL199' and brandshort='Alpha Wire' limit 1 [ RunTime:0.000705s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '25524 SL199' OR `brand` LIKE 'Alpha Wire%' ) ) LIMIT 1 [ RunTime:0.000339s ]
SELECT `id` FROM `stock` WHERE `id` <> 36406865 AND `partno` = '25524 SL199' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%alpha wire%' ) [ RunTime:0.000694s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13507859 [ RunTime:0.003840s ]
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 '25524%' OR `brand` LIKE '25524%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001202s ]
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 '25524%' OR `brand` LIKE '25524%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001411s ]
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 '25524%' OR `brand` LIKE '25524%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000937s ]
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 '25524%' OR `brand` LIKE '25524%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001095s ]
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 '25524%' OR `brand` LIKE '25524%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000926s ]
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 '25524%' OR `brand` LIKE '25524%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001049s ]
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 '25524%' OR `brand` LIKE '25524%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.007314s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '25524%' OR `brand` LIKE '25524%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.009259s ]