SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001970s ]
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 'VM15%' OR `brand` LIKE 'VM15%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.021644s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001567s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19637193 LIMIT 5 [ RunTime:0.020669s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.002167s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19637193 ORDER BY `minOrder` ASC [ RunTime:0.007119s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.001833s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19637193 ORDER BY `unit` DESC [ RunTime:0.024812s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.013529s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19637193 LIMIT 2 [ RunTime:0.017407s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19637193 ORDER BY `minOrder` ASC [ RunTime:0.020985s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19637192 LIMIT 5 [ RunTime:0.026808s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19637192 ORDER BY `minOrder` ASC [ RunTime:0.008146s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19637192 ORDER BY `unit` DESC [ RunTime:0.034956s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19637192 LIMIT 2 [ RunTime:0.028531s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19637192 ORDER BY `minOrder` ASC [ RunTime:0.012040s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19637190 LIMIT 5 [ RunTime:0.081732s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19637190 ORDER BY `minOrder` ASC [ RunTime:0.025258s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19637190 ORDER BY `unit` DESC [ RunTime:0.095132s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19637190 LIMIT 2 [ RunTime:0.026934s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19637190 ORDER BY `minOrder` ASC [ RunTime:0.015126s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19636711 LIMIT 5 [ RunTime:0.052345s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19636711 ORDER BY `minOrder` ASC [ RunTime:0.004761s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19636711 ORDER BY `unit` DESC [ RunTime:0.010478s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19636711 LIMIT 2 [ RunTime:0.006194s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19636711 ORDER BY `minOrder` ASC [ RunTime:0.011153s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19636269 LIMIT 5 [ RunTime:0.040896s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19636269 ORDER BY `minOrder` ASC [ RunTime:0.036682s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19636269 ORDER BY `unit` DESC [ RunTime:0.032441s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19636269 LIMIT 2 [ RunTime:0.052583s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19636269 ORDER BY `minOrder` ASC [ RunTime:0.029596s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19636268 LIMIT 5 [ RunTime:0.017086s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19636268 ORDER BY `minOrder` ASC [ RunTime:0.060900s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19636268 ORDER BY `unit` DESC [ RunTime:0.074919s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19636268 LIMIT 2 [ RunTime:0.012154s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19636268 ORDER BY `minOrder` ASC [ RunTime:0.031011s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19636267 LIMIT 5 [ RunTime:0.011348s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19636267 ORDER BY `minOrder` ASC [ RunTime:0.002283s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19636267 ORDER BY `unit` DESC [ RunTime:0.035789s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19636267 LIMIT 2 [ RunTime:0.018324s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19636267 ORDER BY `minOrder` ASC [ RunTime:0.023422s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19636071 LIMIT 5 [ RunTime:0.015663s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19636071 ORDER BY `minOrder` ASC [ RunTime:0.005807s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19636071 ORDER BY `unit` DESC [ RunTime:0.017346s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19636071 LIMIT 2 [ RunTime:0.032548s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19636071 ORDER BY `minOrder` ASC [ RunTime:0.016715s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19636070 LIMIT 5 [ RunTime:0.007609s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19636070 ORDER BY `minOrder` ASC [ RunTime:0.033180s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19636070 ORDER BY `unit` DESC [ RunTime:0.007430s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19636070 LIMIT 2 [ RunTime:0.004933s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19636070 ORDER BY `minOrder` ASC [ RunTime:0.020695s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19636068 LIMIT 5 [ RunTime:0.008673s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19636068 ORDER BY `minOrder` ASC [ RunTime:0.007215s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19636068 ORDER BY `unit` DESC [ RunTime:0.015604s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19636068 LIMIT 2 [ RunTime:0.012234s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19636068 ORDER BY `minOrder` ASC [ RunTime:0.013942s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19635696 LIMIT 5 [ RunTime:0.013119s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19635696 ORDER BY `minOrder` ASC [ RunTime:0.011172s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19635696 ORDER BY `unit` DESC [ RunTime:0.013483s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19635696 LIMIT 2 [ RunTime:0.000805s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19635696 ORDER BY `minOrder` ASC [ RunTime:0.007208s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19635620 LIMIT 5 [ RunTime:0.018848s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19635620 ORDER BY `minOrder` ASC [ RunTime:0.019816s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19635620 ORDER BY `unit` DESC [ RunTime:0.001426s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19635620 LIMIT 2 [ RunTime:0.010743s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19635620 ORDER BY `minOrder` ASC [ RunTime:0.014002s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19635619 LIMIT 5 [ RunTime:0.011145s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19635619 ORDER BY `minOrder` ASC [ RunTime:0.008770s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19635619 ORDER BY `unit` DESC [ RunTime:0.015038s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19635619 LIMIT 2 [ RunTime:0.005203s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19635619 ORDER BY `minOrder` ASC [ RunTime:0.005146s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19634797 LIMIT 5 [ RunTime:0.006158s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19634797 ORDER BY `minOrder` ASC [ RunTime:0.003007s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19634797 ORDER BY `unit` DESC [ RunTime:0.008521s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19634797 LIMIT 2 [ RunTime:0.001967s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19634797 ORDER BY `minOrder` ASC [ RunTime:0.000488s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19634796 LIMIT 5 [ RunTime:0.018554s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19634796 ORDER BY `minOrder` ASC [ RunTime:0.002501s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19634796 ORDER BY `unit` DESC [ RunTime:0.009087s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19634796 LIMIT 2 [ RunTime:0.024954s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19634796 ORDER BY `minOrder` ASC [ RunTime:0.012006s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19634795 LIMIT 5 [ RunTime:0.011477s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19634795 ORDER BY `minOrder` ASC [ RunTime:0.017079s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19634795 ORDER BY `unit` DESC [ RunTime:0.034919s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19634795 LIMIT 2 [ RunTime:0.030225s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19634795 ORDER BY `minOrder` ASC [ RunTime:0.032664s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19634794 LIMIT 5 [ RunTime:0.024825s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19634794 ORDER BY `minOrder` ASC [ RunTime:0.026040s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19634794 ORDER BY `unit` DESC [ RunTime:0.012780s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19634794 LIMIT 2 [ RunTime:0.013323s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19634794 ORDER BY `minOrder` ASC [ RunTime:0.023714s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19634549 LIMIT 5 [ RunTime:0.025524s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19634549 ORDER BY `minOrder` ASC [ RunTime:0.024866s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19634549 ORDER BY `unit` DESC [ RunTime:0.002807s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19634549 LIMIT 2 [ RunTime:0.024422s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19634549 ORDER BY `minOrder` ASC [ RunTime:0.017155s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19634542 LIMIT 5 [ RunTime:0.016466s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19634542 ORDER BY `minOrder` ASC [ RunTime:0.014547s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19634542 ORDER BY `unit` DESC [ RunTime:0.003502s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19634542 LIMIT 2 [ RunTime:0.016307s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19634542 ORDER BY `minOrder` ASC [ RunTime:0.002927s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19634541 LIMIT 5 [ RunTime:0.016151s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19634541 ORDER BY `minOrder` ASC [ RunTime:0.008935s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19634541 ORDER BY `unit` DESC [ RunTime:0.006198s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19634541 LIMIT 2 [ RunTime:0.016828s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19634541 ORDER BY `minOrder` ASC [ RunTime:0.006952s ]
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 'VM15%' OR `brand` LIKE 'VM15%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.013149s ]
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 'VM15%' OR `brand` LIKE 'VM15%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.054859s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53713749 LIMIT 5 [ RunTime:0.057073s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53713749 ORDER BY `minOrder` ASC [ RunTime:0.025494s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53713749 ORDER BY `unit` DESC [ RunTime:0.056239s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53713749 LIMIT 2 [ RunTime:0.020209s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53713749 ORDER BY `minOrder` ASC [ RunTime:0.006988s ]
select * from pdf where partno='VM1575820000G' and brandshort='Amphenol Anytek' limit 1 [ RunTime:0.016468s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001650s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'VM1575820000G' OR `brand` LIKE 'Amphenol Anytek%' ) ) LIMIT 1 [ RunTime:0.004238s ]
SELECT `id` FROM `stock` WHERE `id` <> 53713749 AND `partno` = 'VM1575820000G' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol anytek%' ) [ RunTime:0.006512s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19637193 [ RunTime:0.011198s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53713748 LIMIT 5 [ RunTime:0.009188s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53713748 ORDER BY `minOrder` ASC [ RunTime:0.003494s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53713748 ORDER BY `unit` DESC [ RunTime:0.005676s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53713748 LIMIT 2 [ RunTime:0.006609s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53713748 ORDER BY `minOrder` ASC [ RunTime:0.008659s ]
select * from pdf where partno='VM1575020000G' and brandshort='Amphenol Anytek' limit 1 [ RunTime:0.008115s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'VM1575020000G' OR `brand` LIKE 'Amphenol Anytek%' ) ) LIMIT 1 [ RunTime:0.005740s ]
SELECT `id` FROM `stock` WHERE `id` <> 53713748 AND `partno` = 'VM1575020000G' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol anytek%' ) [ RunTime:0.013892s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19637192 [ RunTime:0.000485s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53713746 LIMIT 5 [ RunTime:0.009921s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53713746 ORDER BY `minOrder` ASC [ RunTime:0.007112s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53713746 ORDER BY `unit` DESC [ RunTime:0.004237s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53713746 LIMIT 2 [ RunTime:0.026159s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53713746 ORDER BY `minOrder` ASC [ RunTime:0.012900s ]
select * from pdf where partno='VM1575520000G' and brandshort='Amphenol Anytek' limit 1 [ RunTime:0.017252s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'VM1575520000G' OR `brand` LIKE 'Amphenol Anytek%' ) ) LIMIT 1 [ RunTime:0.012431s ]
SELECT `id` FROM `stock` WHERE `id` <> 53713746 AND `partno` = 'VM1575520000G' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol anytek%' ) [ RunTime:0.011193s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19637190 [ RunTime:0.002336s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53713145 LIMIT 5 [ RunTime:0.013110s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53713145 ORDER BY `minOrder` ASC [ RunTime:0.020778s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53713145 ORDER BY `unit` DESC [ RunTime:0.012235s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53713145 LIMIT 2 [ RunTime:0.000910s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53713145 ORDER BY `minOrder` ASC [ RunTime:0.003528s ]
select * from pdf where partno='VM1505530000G' and brandshort='Amphenol Anytek' limit 1 [ RunTime:0.017445s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'VM1505530000G' OR `brand` LIKE 'Amphenol Anytek%' ) ) LIMIT 1 [ RunTime:0.017762s ]
SELECT `id` FROM `stock` WHERE `id` <> 53713145 AND `partno` = 'VM1505530000G' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol anytek%' ) [ RunTime:0.018157s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17307918 [ RunTime:0.030483s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53712547 LIMIT 5 [ RunTime:0.017130s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53712547 ORDER BY `minOrder` ASC [ RunTime:0.014413s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53712547 ORDER BY `unit` DESC [ RunTime:0.022379s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53712547 LIMIT 2 [ RunTime:0.010888s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53712547 ORDER BY `minOrder` ASC [ RunTime:0.002269s ]
select * from pdf where partno='VM1555820000G' and brandshort='Amphenol Anytek' limit 1 [ RunTime:0.007033s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'VM1555820000G' OR `brand` LIKE 'Amphenol Anytek%' ) ) LIMIT 1 [ RunTime:0.017382s ]
SELECT `id` FROM `stock` WHERE `id` <> 53712547 AND `partno` = 'VM1555820000G' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol anytek%' ) [ RunTime:0.008051s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19636269 [ RunTime:0.000657s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53712314 LIMIT 5 [ RunTime:0.004302s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53712314 ORDER BY `minOrder` ASC [ RunTime:0.010297s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53712314 ORDER BY `unit` DESC [ RunTime:0.024361s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53712314 LIMIT 2 [ RunTime:0.035135s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53712314 ORDER BY `minOrder` ASC [ RunTime:0.009860s ]
select * from pdf where partno='VM15A5830000G' and brandshort='Amphenol Anytek' limit 1 [ RunTime:0.011689s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'VM15A5830000G' OR `brand` LIKE 'Amphenol Anytek%' ) ) LIMIT 1 [ RunTime:0.009279s ]
SELECT `id` FROM `stock` WHERE `id` <> 53712314 AND `partno` = 'VM15A5830000G' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol anytek%' ) [ RunTime:0.034952s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19636071 [ RunTime:0.040843s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53712313 LIMIT 5 [ RunTime:0.012976s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53712313 ORDER BY `minOrder` ASC [ RunTime:0.011141s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53712313 ORDER BY `unit` DESC [ RunTime:0.016721s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53712313 LIMIT 2 [ RunTime:0.010739s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53712313 ORDER BY `minOrder` ASC [ RunTime:0.007321s ]
select * from pdf where partno='VM15A5030000G' and brandshort='Amphenol Anytek' limit 1 [ RunTime:0.023334s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'VM15A5030000G' OR `brand` LIKE 'Amphenol Anytek%' ) ) LIMIT 1 [ RunTime:0.025726s ]
SELECT `id` FROM `stock` WHERE `id` <> 53712313 AND `partno` = 'VM15A5030000G' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol anytek%' ) [ RunTime:0.004590s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19636070 [ RunTime:0.006357s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53712310 LIMIT 5 [ RunTime:0.006252s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53712310 ORDER BY `minOrder` ASC [ RunTime:0.003656s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53712310 ORDER BY `unit` DESC [ RunTime:0.010472s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53712310 LIMIT 2 [ RunTime:0.005635s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53712310 ORDER BY `minOrder` ASC [ RunTime:0.015741s ]
select * from pdf where partno='VM15A5530000G' and brandshort='Amphenol Anytek' limit 1 [ RunTime:0.015487s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'VM15A5530000G' OR `brand` LIKE 'Amphenol Anytek%' ) ) LIMIT 1 [ RunTime:0.005009s ]
SELECT `id` FROM `stock` WHERE `id` <> 53712310 AND `partno` = 'VM15A5530000G' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol anytek%' ) [ RunTime:0.001634s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19636068 [ RunTime:0.000779s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53711730 LIMIT 5 [ RunTime:0.009913s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53711730 ORDER BY `minOrder` ASC [ RunTime:0.028924s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53711730 ORDER BY `unit` DESC [ RunTime:0.026329s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53711730 LIMIT 2 [ RunTime:0.012663s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53711730 ORDER BY `minOrder` ASC [ RunTime:0.000574s ]
select * from pdf where partno='VM1505810000G' and brandshort='Amphenol Anytek' limit 1 [ RunTime:0.001587s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'VM1505810000G' OR `brand` LIKE 'Amphenol Anytek%' ) ) LIMIT 1 [ RunTime:0.001159s ]
SELECT `id` FROM `stock` WHERE `id` <> 53711730 AND `partno` = 'VM1505810000G' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol anytek%' ) [ RunTime:0.005671s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17307710 [ RunTime:0.007791s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53711729 LIMIT 5 [ RunTime:0.012628s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53711729 ORDER BY `minOrder` ASC [ RunTime:0.004400s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53711729 ORDER BY `unit` DESC [ RunTime:0.000675s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53711729 LIMIT 2 [ RunTime:0.000520s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53711729 ORDER BY `minOrder` ASC [ RunTime:0.000509s ]
select * from pdf where partno='VM1505010000G' and brandshort='Amphenol Anytek' limit 1 [ RunTime:0.000949s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'VM1505010000G' OR `brand` LIKE 'Amphenol Anytek%' ) ) LIMIT 1 [ RunTime:0.000582s ]
SELECT `id` FROM `stock` WHERE `id` <> 53711729 AND `partno` = 'VM1505010000G' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol anytek%' ) [ RunTime:0.000636s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16149523 [ RunTime:0.004638s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53711728 LIMIT 5 [ RunTime:0.000726s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53711728 ORDER BY `minOrder` ASC [ RunTime:0.010576s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53711728 ORDER BY `unit` DESC [ RunTime:0.006216s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53711728 LIMIT 2 [ RunTime:0.004974s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53711728 ORDER BY `minOrder` ASC [ RunTime:0.000450s ]
select * from pdf where partno='VM1505510000G' and brandshort='Amphenol Anytek' limit 1 [ RunTime:0.004601s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'VM1505510000G' OR `brand` LIKE 'Amphenol Anytek%' ) ) LIMIT 1 [ RunTime:0.000953s ]
SELECT `id` FROM `stock` WHERE `id` <> 53711728 AND `partno` = 'VM1505510000G' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol anytek%' ) [ RunTime:0.000749s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19635696 [ RunTime:0.000623s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53711618 LIMIT 5 [ RunTime:0.003997s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53711618 ORDER BY `minOrder` ASC [ RunTime:0.016332s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53711618 ORDER BY `unit` DESC [ RunTime:0.004829s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53711618 LIMIT 2 [ RunTime:0.005624s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53711618 ORDER BY `minOrder` ASC [ RunTime:0.001464s ]
select * from pdf where partno='VM15A5810000G' and brandshort='Amphenol Anytek' limit 1 [ RunTime:0.004318s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'VM15A5810000G' OR `brand` LIKE 'Amphenol Anytek%' ) ) LIMIT 1 [ RunTime:0.001252s ]
SELECT `id` FROM `stock` WHERE `id` <> 53711618 AND `partno` = 'VM15A5810000G' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol anytek%' ) [ RunTime:0.000660s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19635620 [ RunTime:0.000640s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53711617 LIMIT 5 [ RunTime:0.003179s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53711617 ORDER BY `minOrder` ASC [ RunTime:0.004707s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53711617 ORDER BY `unit` DESC [ RunTime:0.003721s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53711617 LIMIT 2 [ RunTime:0.001040s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53711617 ORDER BY `minOrder` ASC [ RunTime:0.000332s ]
select * from pdf where partno='VM15A5510000G' and brandshort='Amphenol Anytek' limit 1 [ RunTime:0.000805s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'VM15A5510000G' OR `brand` LIKE 'Amphenol Anytek%' ) ) LIMIT 1 [ RunTime:0.002219s ]
SELECT `id` FROM `stock` WHERE `id` <> 53711617 AND `partno` = 'VM15A5510000G' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol anytek%' ) [ RunTime:0.005071s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17307692 [ RunTime:0.002310s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53710595 LIMIT 5 [ RunTime:0.000409s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53710595 ORDER BY `minOrder` ASC [ RunTime:0.003701s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53710595 ORDER BY `unit` DESC [ RunTime:0.001073s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53710595 LIMIT 2 [ RunTime:0.002137s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53710595 ORDER BY `minOrder` ASC [ RunTime:0.001040s ]
select * from pdf where partno='VM1575000000G' and brandshort='Amphenol Anytek' limit 1 [ RunTime:0.000827s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'VM1575000000G' OR `brand` LIKE 'Amphenol Anytek%' ) ) LIMIT 1 [ RunTime:0.007412s ]
SELECT `id` FROM `stock` WHERE `id` <> 53710595 AND `partno` = 'VM1575000000G' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol anytek%' ) [ RunTime:0.034078s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19634796 [ RunTime:0.000455s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53710594 LIMIT 5 [ RunTime:0.004143s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53710594 ORDER BY `minOrder` ASC [ RunTime:0.026390s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53710594 ORDER BY `unit` DESC [ RunTime:0.023768s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53710594 LIMIT 2 [ RunTime:0.003319s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53710594 ORDER BY `minOrder` ASC [ RunTime:0.002059s ]
select * from pdf where partno='VM1555800000G' and brandshort='Amphenol Anytek' limit 1 [ RunTime:0.000880s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'VM1555800000G' OR `brand` LIKE 'Amphenol Anytek%' ) ) LIMIT 1 [ RunTime:0.004618s ]
SELECT `id` FROM `stock` WHERE `id` <> 53710594 AND `partno` = 'VM1555800000G' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol anytek%' ) [ RunTime:0.015431s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19634795 [ RunTime:0.010871s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53710593 LIMIT 5 [ RunTime:0.009324s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53710593 ORDER BY `minOrder` ASC [ RunTime:0.004024s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53710593 ORDER BY `unit` DESC [ RunTime:0.002575s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53710593 LIMIT 2 [ RunTime:0.001235s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53710593 ORDER BY `minOrder` ASC [ RunTime:0.000302s ]
select * from pdf where partno='VM1555000000G' and brandshort='Amphenol Anytek' limit 1 [ RunTime:0.000815s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'VM1555000000G' OR `brand` LIKE 'Amphenol Anytek%' ) ) LIMIT 1 [ RunTime:0.015631s ]
SELECT `id` FROM `stock` WHERE `id` <> 53710593 AND `partno` = 'VM1555000000G' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol anytek%' ) [ RunTime:0.000651s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19634794 [ RunTime:0.000517s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53710592 LIMIT 5 [ RunTime:0.001570s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53710592 ORDER BY `minOrder` ASC [ RunTime:0.000605s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53710592 ORDER BY `unit` DESC [ RunTime:0.029235s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53710592 LIMIT 2 [ RunTime:0.007815s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53710592 ORDER BY `minOrder` ASC [ RunTime:0.009854s ]
select * from pdf where partno='VM1575500000G' and brandshort='Amphenol Anytek' limit 1 [ RunTime:0.011851s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'VM1575500000G' OR `brand` LIKE 'Amphenol Anytek%' ) ) LIMIT 1 [ RunTime:0.004085s ]
SELECT `id` FROM `stock` WHERE `id` <> 53710592 AND `partno` = 'VM1575500000G' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol anytek%' ) [ RunTime:0.001227s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15448882 [ RunTime:0.001023s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53710591 LIMIT 5 [ RunTime:0.002912s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53710591 ORDER BY `minOrder` ASC [ RunTime:0.002797s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53710591 ORDER BY `unit` DESC [ RunTime:0.005745s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53710591 LIMIT 2 [ RunTime:0.003158s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53710591 ORDER BY `minOrder` ASC [ RunTime:0.002735s ]
select * from pdf where partno='VM1555500000G' and brandshort='Amphenol Anytek' limit 1 [ RunTime:0.007776s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'VM1555500000G' OR `brand` LIKE 'Amphenol Anytek%' ) ) LIMIT 1 [ RunTime:0.000733s ]
SELECT `id` FROM `stock` WHERE `id` <> 53710591 AND `partno` = 'VM1555500000G' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol anytek%' ) [ RunTime:0.000665s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15448881 [ RunTime:0.007034s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53710282 LIMIT 5 [ RunTime:0.001257s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53710282 ORDER BY `minOrder` ASC [ RunTime:0.002787s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53710282 ORDER BY `unit` DESC [ RunTime:0.021568s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53710282 LIMIT 2 [ RunTime:0.005337s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53710282 ORDER BY `minOrder` ASC [ RunTime:0.000332s ]
select * from pdf where partno='VM1555830000G' and brandshort='Amphenol Anytek' limit 1 [ RunTime:0.000812s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'VM1555830000G' OR `brand` LIKE 'Amphenol Anytek%' ) ) LIMIT 1 [ RunTime:0.000493s ]
SELECT `id` FROM `stock` WHERE `id` <> 53710282 AND `partno` = 'VM1555830000G' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol anytek%' ) [ RunTime:0.001919s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19634542 [ RunTime:0.008653s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53710281 LIMIT 5 [ RunTime:0.010399s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53710281 ORDER BY `minOrder` ASC [ RunTime:0.001472s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53710281 ORDER BY `unit` DESC [ RunTime:0.014551s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53710281 LIMIT 2 [ RunTime:0.000491s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53710281 ORDER BY `minOrder` ASC [ RunTime:0.000332s ]
select * from pdf where partno='VM1555030000G' and brandshort='Amphenol Anytek' limit 1 [ RunTime:0.009499s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'VM1555030000G' OR `brand` LIKE 'Amphenol Anytek%' ) ) LIMIT 1 [ RunTime:0.003381s ]
SELECT `id` FROM `stock` WHERE `id` <> 53710281 AND `partno` = 'VM1555030000G' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol anytek%' ) [ RunTime:0.000917s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19634541 [ RunTime:0.000431s ]
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 'VM15%' OR `brand` LIKE 'VM15%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001160s ]
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 'VM15%' OR `brand` LIKE 'VM15%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.004295s ]
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 'VM15%' OR `brand` LIKE 'VM15%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000958s ]
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 'VM15%' OR `brand` LIKE 'VM15%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000950s ]
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 'VM15%' OR `brand` LIKE 'VM15%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.004142s ]
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 'VM15%' OR `brand` LIKE 'VM15%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.007214s ]
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 'VM15%' OR `brand` LIKE 'VM15%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.010654s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'VM15%' OR `brand` LIKE 'VM15%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.005435s ]