SHOW FULL COLUMNS FROM `stock` [ RunTime:0.003730s ]
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 '2385%' OR `brand` LIKE '2385%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.026916s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001222s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11495929 LIMIT 5 [ RunTime:0.000937s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001909s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11495929 ORDER BY `minOrder` ASC [ RunTime:0.002456s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.003293s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11495929 ORDER BY `unit` DESC [ RunTime:0.007694s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.010284s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11495929 LIMIT 2 [ RunTime:0.008470s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11495929 ORDER BY `minOrder` ASC [ RunTime:0.003253s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12630636 LIMIT 5 [ RunTime:0.002650s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12630636 ORDER BY `minOrder` ASC [ RunTime:0.007426s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12630636 ORDER BY `unit` DESC [ RunTime:0.000399s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12630636 LIMIT 2 [ RunTime:0.004313s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12630636 ORDER BY `minOrder` ASC [ RunTime:0.007045s ]
select * from pdf where partno='2385533-2' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.008831s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12630665 LIMIT 5 [ RunTime:0.003093s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12630665 ORDER BY `minOrder` ASC [ RunTime:0.007435s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12630665 ORDER BY `unit` DESC [ RunTime:0.002955s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12630665 LIMIT 2 [ RunTime:0.000792s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12630665 ORDER BY `minOrder` ASC [ RunTime:0.000468s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12618240 LIMIT 5 [ RunTime:0.011926s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12618240 ORDER BY `minOrder` ASC [ RunTime:0.002765s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12618240 ORDER BY `unit` DESC [ RunTime:0.008041s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12618240 LIMIT 2 [ RunTime:0.000928s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12618240 ORDER BY `minOrder` ASC [ RunTime:0.000949s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11487448 LIMIT 5 [ RunTime:0.000892s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11487448 ORDER BY `minOrder` ASC [ RunTime:0.000454s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11487448 ORDER BY `unit` DESC [ RunTime:0.013485s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11487448 LIMIT 2 [ RunTime:0.014264s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11487448 ORDER BY `minOrder` ASC [ RunTime:0.000410s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14348532 LIMIT 5 [ RunTime:0.000985s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14348532 ORDER BY `minOrder` ASC [ RunTime:0.000489s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14348532 ORDER BY `unit` DESC [ RunTime:0.002246s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14348532 LIMIT 2 [ RunTime:0.000983s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14348532 ORDER BY `minOrder` ASC [ RunTime:0.000333s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12386498 LIMIT 5 [ RunTime:0.001448s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12386498 ORDER BY `minOrder` ASC [ RunTime:0.001236s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12386498 ORDER BY `unit` DESC [ RunTime:0.000676s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12386498 LIMIT 2 [ RunTime:0.006818s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12386498 ORDER BY `minOrder` ASC [ RunTime:0.010023s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12042728 LIMIT 5 [ RunTime:0.001255s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12042728 ORDER BY `minOrder` ASC [ RunTime:0.000655s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12042728 ORDER BY `unit` DESC [ RunTime:0.000408s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12042728 LIMIT 2 [ RunTime:0.000601s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12042728 ORDER BY `minOrder` ASC [ RunTime:0.001431s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16357678 LIMIT 5 [ RunTime:0.000932s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16357678 ORDER BY `minOrder` ASC [ RunTime:0.002294s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16357678 ORDER BY `unit` DESC [ RunTime:0.003712s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16357678 LIMIT 2 [ RunTime:0.001302s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16357678 ORDER BY `minOrder` ASC [ RunTime:0.010582s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 20078705 LIMIT 5 [ RunTime:0.001297s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20078705 ORDER BY `minOrder` ASC [ RunTime:0.000801s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 20078705 ORDER BY `unit` DESC [ RunTime:0.000748s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 20078705 LIMIT 2 [ RunTime:0.003346s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20078705 ORDER BY `minOrder` ASC [ RunTime:0.005126s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 20078706 LIMIT 5 [ RunTime:0.005283s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20078706 ORDER BY `minOrder` ASC [ RunTime:0.017702s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 20078706 ORDER BY `unit` DESC [ RunTime:0.007251s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 20078706 LIMIT 2 [ RunTime:0.000684s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20078706 ORDER BY `minOrder` ASC [ RunTime:0.005146s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12881267 LIMIT 5 [ RunTime:0.001119s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12881267 ORDER BY `minOrder` ASC [ RunTime:0.005019s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12881267 ORDER BY `unit` DESC [ RunTime:0.003472s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12881267 LIMIT 2 [ RunTime:0.000943s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12881267 ORDER BY `minOrder` ASC [ RunTime:0.000423s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 20078704 LIMIT 5 [ RunTime:0.000702s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20078704 ORDER BY `minOrder` ASC [ RunTime:0.000636s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 20078704 ORDER BY `unit` DESC [ RunTime:0.010556s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 20078704 LIMIT 2 [ RunTime:0.011786s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20078704 ORDER BY `minOrder` ASC [ RunTime:0.000909s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16357680 LIMIT 5 [ RunTime:0.000675s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16357680 ORDER BY `minOrder` ASC [ RunTime:0.001426s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16357680 ORDER BY `unit` DESC [ RunTime:0.009976s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16357680 LIMIT 2 [ RunTime:0.002283s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16357680 ORDER BY `minOrder` ASC [ RunTime:0.000437s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 20078956 LIMIT 5 [ RunTime:0.000908s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20078956 ORDER BY `minOrder` ASC [ RunTime:0.012121s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 20078956 ORDER BY `unit` DESC [ RunTime:0.003120s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 20078956 LIMIT 2 [ RunTime:0.003124s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20078956 ORDER BY `minOrder` ASC [ RunTime:0.000280s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18730543 LIMIT 5 [ RunTime:0.001004s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18730543 ORDER BY `minOrder` ASC [ RunTime:0.000791s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18730543 ORDER BY `unit` DESC [ RunTime:0.000564s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18730543 LIMIT 2 [ RunTime:0.000412s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18730543 ORDER BY `minOrder` ASC [ RunTime:0.000256s ]
select * from pdf where partno='2385411-1' and brandshort='TE Application Tooling' limit 1 [ RunTime:0.004417s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18730537 LIMIT 5 [ RunTime:0.002564s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18730537 ORDER BY `minOrder` ASC [ RunTime:0.001970s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18730537 ORDER BY `unit` DESC [ RunTime:0.000574s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18730537 LIMIT 2 [ RunTime:0.000497s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18730537 ORDER BY `minOrder` ASC [ RunTime:0.000760s ]
select * from pdf where partno='2385850-1' and brandshort='TE Application Tooling' limit 1 [ RunTime:0.000666s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17371711 LIMIT 5 [ RunTime:0.003925s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17371711 ORDER BY `minOrder` ASC [ RunTime:0.005905s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17371711 ORDER BY `unit` DESC [ RunTime:0.010428s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17371711 LIMIT 2 [ RunTime:0.020660s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17371711 ORDER BY `minOrder` ASC [ RunTime:0.002423s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17371710 LIMIT 5 [ RunTime:0.009409s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17371710 ORDER BY `minOrder` ASC [ RunTime:0.001745s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17371710 ORDER BY `unit` DESC [ RunTime:0.002438s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17371710 LIMIT 2 [ RunTime:0.000638s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17371710 ORDER BY `minOrder` ASC [ RunTime:0.011849s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17009402 LIMIT 5 [ RunTime:0.004984s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17009402 ORDER BY `minOrder` ASC [ RunTime:0.011001s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17009402 ORDER BY `unit` DESC [ RunTime:0.005133s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17009402 LIMIT 2 [ RunTime:0.004446s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17009402 ORDER BY `minOrder` ASC [ RunTime:0.000637s ]
select * from pdf where partno='2385850-2' and brandshort='TE Application Tooling' limit 1 [ RunTime:0.000849s ]
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 '2385%' OR `brand` LIKE '2385%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.007294s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51095358 LIMIT 5 [ RunTime:0.000851s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51095358 ORDER BY `minOrder` ASC [ RunTime:0.005696s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51095358 ORDER BY `unit` DESC [ RunTime:0.003976s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51095358 LIMIT 2 [ RunTime:0.000748s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51095358 ORDER BY `minOrder` ASC [ RunTime:0.000532s ]
select * from pdf where partno='2385' and brandshort='scs' limit 1 [ RunTime:0.001649s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.004542s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2385' OR `brand` LIKE 'scs%' ) ) LIMIT 1 [ RunTime:0.003558s ]
SELECT `id` FROM `stock` WHERE `id` <> 51095358 AND `partno` = '2385' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%scs%' ) [ RunTime:0.003965s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12386498 [ RunTime:0.002207s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51093080 LIMIT 5 [ RunTime:0.000758s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51093080 ORDER BY `minOrder` ASC [ RunTime:0.001214s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51093080 ORDER BY `unit` DESC [ RunTime:0.003025s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51093080 LIMIT 2 [ RunTime:0.009328s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51093080 ORDER BY `minOrder` ASC [ RunTime:0.000493s ]
select * from pdf where partno='2385850-1' and brandshort='te connectivity' limit 1 [ RunTime:0.002535s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2385850-1' OR `brand` LIKE 'te connectivity%' ) ) LIMIT 1 [ RunTime:0.020499s ]
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 '2385%' OR `brand` LIKE '2385%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.018491s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 52532939 LIMIT 5 [ RunTime:0.001459s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52532939 ORDER BY `minOrder` ASC [ RunTime:0.000732s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 52532939 ORDER BY `unit` DESC [ RunTime:0.002201s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 52532939 LIMIT 2 [ RunTime:0.000437s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52532939 ORDER BY `minOrder` ASC [ RunTime:0.000203s ]
select * from pdf where partno='2385692-1' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.000537s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2385692-1' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.000465s ]
SELECT `id` FROM `stock` WHERE `id` <> 52532939 AND `partno` = '2385692-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.002119s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53662352 LIMIT 5 [ RunTime:0.000998s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53662352 ORDER BY `minOrder` ASC [ RunTime:0.001537s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53662352 ORDER BY `unit` DESC [ RunTime:0.002977s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53662352 LIMIT 2 [ RunTime:0.000744s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53662352 ORDER BY `minOrder` ASC [ RunTime:0.000202s ]
select * from pdf where partno='2385009-5' and brandshort='TE Connectivity' limit 1 [ RunTime:0.000804s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2385009-5' OR `brand` LIKE 'TE Connectivity%' ) ) LIMIT 1 [ RunTime:0.009803s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53082179 LIMIT 5 [ RunTime:0.013595s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53082179 ORDER BY `minOrder` ASC [ RunTime:0.007408s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53082179 ORDER BY `unit` DESC [ RunTime:0.004917s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53082179 LIMIT 2 [ RunTime:0.000902s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53082179 ORDER BY `minOrder` ASC [ RunTime:0.000178s ]
select * from pdf where partno='2385532-2' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.024668s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2385532-2' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.033733s ]
SELECT `id` FROM `stock` WHERE `id` <> 53082179 AND `partno` = '2385532-2' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.024752s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11495929 [ RunTime:0.011890s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53082152 LIMIT 5 [ RunTime:0.015879s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53082152 ORDER BY `minOrder` ASC [ RunTime:0.006921s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53082152 ORDER BY `unit` DESC [ RunTime:0.029646s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53082152 LIMIT 2 [ RunTime:0.037316s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53082152 ORDER BY `minOrder` ASC [ RunTime:0.001593s ]
select * from pdf where partno='2385533-4' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.007867s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2385533-4' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.013766s ]
SELECT `id` FROM `stock` WHERE `id` <> 53082152 AND `partno` = '2385533-4' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.018751s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12630665 [ RunTime:0.000638s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53082180 LIMIT 5 [ RunTime:0.000567s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53082180 ORDER BY `minOrder` ASC [ RunTime:0.002849s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53082180 ORDER BY `unit` DESC [ RunTime:0.011464s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53082180 LIMIT 2 [ RunTime:0.029536s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53082180 ORDER BY `minOrder` ASC [ RunTime:0.001659s ]
select * from pdf where partno='2385533-2' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.007549s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2385533-2' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.006484s ]
SELECT `id` FROM `stock` WHERE `id` <> 53082180 AND `partno` = '2385533-2' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.006988s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12630636 [ RunTime:0.003078s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53090801 LIMIT 5 [ RunTime:0.014332s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53090801 ORDER BY `minOrder` ASC [ RunTime:0.026291s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53090801 ORDER BY `unit` DESC [ RunTime:0.012878s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53090801 LIMIT 2 [ RunTime:0.016537s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53090801 ORDER BY `minOrder` ASC [ RunTime:0.017407s ]
select * from pdf where partno='2385533-6' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.006710s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2385533-6' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.011017s ]
SELECT `id` FROM `stock` WHERE `id` <> 53090801 AND `partno` = '2385533-6' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.002686s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12618240 [ RunTime:0.005257s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53090784 LIMIT 5 [ RunTime:0.002156s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53090784 ORDER BY `minOrder` ASC [ RunTime:0.009411s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53090784 ORDER BY `unit` DESC [ RunTime:0.005529s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53090784 LIMIT 2 [ RunTime:0.007707s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53090784 ORDER BY `minOrder` ASC [ RunTime:0.002631s ]
select * from pdf where partno='2385532-4' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.001159s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2385532-4' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.008605s ]
SELECT `id` FROM `stock` WHERE `id` <> 53090784 AND `partno` = '2385532-4' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.001172s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11487448 [ RunTime:0.000770s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51413279 LIMIT 5 [ RunTime:0.005694s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51413279 ORDER BY `minOrder` ASC [ RunTime:0.002198s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51413279 ORDER BY `unit` DESC [ RunTime:0.009643s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51413279 LIMIT 2 [ RunTime:0.004163s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51413279 ORDER BY `minOrder` ASC [ RunTime:0.001904s ]
select * from pdf where partno='2385' and brandshort='Pololu' limit 1 [ RunTime:0.001950s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2385' OR `brand` LIKE 'Pololu%' ) ) LIMIT 1 [ RunTime:0.013622s ]
SELECT `id` FROM `stock` WHERE `id` <> 51413279 AND `partno` = '2385' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%pololu%' ) [ RunTime:0.011015s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14348532 [ RunTime:0.012765s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 49580500 LIMIT 5 [ RunTime:0.009988s ]
SELECT * FROM `stock_price` WHERE `stockid` = 49580500 ORDER BY `minOrder` ASC [ RunTime:0.026784s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 49580500 ORDER BY `unit` DESC [ RunTime:0.007195s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 49580500 LIMIT 2 [ RunTime:0.003758s ]
SELECT * FROM `stock_price` WHERE `stockid` = 49580500 ORDER BY `minOrder` ASC [ RunTime:0.000553s ]
select * from pdf where partno='2385' and brandshort='Keystone Electronics' limit 1 [ RunTime:0.023832s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2385' OR `brand` LIKE 'Keystone Electronics%' ) ) LIMIT 1 [ RunTime:0.009878s ]
SELECT `id` FROM `stock` WHERE `id` <> 49580500 AND `partno` = '2385' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%keystone electronics%' ) [ RunTime:0.014662s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12042728 [ RunTime:0.000483s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36773706 LIMIT 5 [ RunTime:0.002858s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36773706 ORDER BY `minOrder` ASC [ RunTime:0.006556s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36773706 ORDER BY `unit` DESC [ RunTime:0.002998s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36773706 LIMIT 2 [ RunTime:0.007915s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36773706 ORDER BY `minOrder` ASC [ RunTime:0.001989s ]
select * from pdf where partno='2385' and brandshort='Keystone Electronics' limit 1 [ RunTime:0.000421s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2385' OR `brand` LIKE 'Keystone Electronics%' ) ) LIMIT 1 [ RunTime:0.000437s ]
SELECT `id` FROM `stock` WHERE `id` <> 36773706 AND `partno` = '2385' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%keystone electronics%' ) [ RunTime:0.015057s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12042728 [ RunTime:0.001484s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 49675878 LIMIT 5 [ RunTime:0.011348s ]
SELECT * FROM `stock_price` WHERE `stockid` = 49675878 ORDER BY `minOrder` ASC [ RunTime:0.009867s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 49675878 ORDER BY `unit` DESC [ RunTime:0.015892s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 49675878 LIMIT 2 [ RunTime:0.020406s ]
SELECT * FROM `stock_price` WHERE `stockid` = 49675878 ORDER BY `minOrder` ASC [ RunTime:0.007470s ]
select * from pdf where partno='2385' and brandshort='SCS' limit 1 [ RunTime:0.008574s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2385' OR `brand` LIKE 'SCS%' ) ) LIMIT 1 [ RunTime:0.006167s ]
SELECT `id` FROM `stock` WHERE `id` <> 49675878 AND `partno` = '2385' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%scs%' ) [ RunTime:0.014142s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12386498 [ RunTime:0.000502s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36869179 LIMIT 5 [ RunTime:0.004315s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36869179 ORDER BY `minOrder` ASC [ RunTime:0.011266s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36869179 ORDER BY `unit` DESC [ RunTime:0.002942s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36869179 LIMIT 2 [ RunTime:0.034954s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36869179 ORDER BY `minOrder` ASC [ RunTime:0.009221s ]
select * from pdf where partno='2385' and brandshort='SCS' limit 1 [ RunTime:0.008371s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2385' OR `brand` LIKE 'SCS%' ) ) LIMIT 1 [ RunTime:0.002914s ]
SELECT `id` FROM `stock` WHERE `id` <> 36869179 AND `partno` = '2385' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%scs%' ) [ RunTime:0.002969s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12386498 [ RunTime:0.006426s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53786899 LIMIT 5 [ RunTime:0.015533s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53786899 ORDER BY `minOrder` ASC [ RunTime:0.008291s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53786899 ORDER BY `unit` DESC [ RunTime:0.001425s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53786899 LIMIT 2 [ RunTime:0.010440s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53786899 ORDER BY `minOrder` ASC [ RunTime:0.003173s ]
select * from pdf where partno='2385343-1' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.003726s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2385343-1' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.014666s ]
SELECT `id` FROM `stock` WHERE `id` <> 53786899 AND `partno` = '2385343-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.001277s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16357678 [ RunTime:0.000760s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53786910 LIMIT 5 [ RunTime:0.000799s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53786910 ORDER BY `minOrder` ASC [ RunTime:0.009758s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53786910 ORDER BY `unit` DESC [ RunTime:0.001933s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53786910 LIMIT 2 [ RunTime:0.005939s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53786910 ORDER BY `minOrder` ASC [ RunTime:0.000423s ]
select * from pdf where partno='2385341-1' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.000946s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2385341-1' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.002909s ]
SELECT `id` FROM `stock` WHERE `id` <> 53786910 AND `partno` = '2385341-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.008424s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 20078705 [ RunTime:0.001174s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 55093055 LIMIT 5 [ RunTime:0.003845s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55093055 ORDER BY `minOrder` ASC [ RunTime:0.002089s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 55093055 ORDER BY `unit` DESC [ RunTime:0.001230s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 55093055 LIMIT 2 [ RunTime:0.000639s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55093055 ORDER BY `minOrder` ASC [ RunTime:0.003209s ]
select * from pdf where partno='2385352-1' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.005776s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2385352-1' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.003341s ]
SELECT `id` FROM `stock` WHERE `id` <> 55093055 AND `partno` = '2385352-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.001253s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12881267 [ RunTime:0.003887s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53786911 LIMIT 5 [ RunTime:0.000865s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53786911 ORDER BY `minOrder` ASC [ RunTime:0.000702s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53786911 ORDER BY `unit` DESC [ RunTime:0.000619s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53786911 LIMIT 2 [ RunTime:0.000609s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53786911 ORDER BY `minOrder` ASC [ RunTime:0.008868s ]
select * from pdf where partno='2385340-1' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.004122s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2385340-1' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.010668s ]
SELECT `id` FROM `stock` WHERE `id` <> 53786911 AND `partno` = '2385340-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.001423s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 20078706 [ RunTime:0.000922s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53786901 LIMIT 5 [ RunTime:0.000841s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53786901 ORDER BY `minOrder` ASC [ RunTime:0.005584s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53786901 ORDER BY `unit` DESC [ RunTime:0.000917s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53786901 LIMIT 2 [ RunTime:0.002477s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53786901 ORDER BY `minOrder` ASC [ RunTime:0.000464s ]
select * from pdf where partno='2385344-1' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.000975s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2385344-1' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.007540s ]
SELECT `id` FROM `stock` WHERE `id` <> 53786901 AND `partno` = '2385344-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.002857s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 20078704 [ RunTime:0.005663s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53786900 LIMIT 5 [ RunTime:0.003510s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53786900 ORDER BY `minOrder` ASC [ RunTime:0.009634s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53786900 ORDER BY `unit` DESC [ RunTime:0.004208s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53786900 LIMIT 2 [ RunTime:0.000594s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53786900 ORDER BY `minOrder` ASC [ RunTime:0.002492s ]
select * from pdf where partno='2385342-1' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.006440s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2385342-1' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.008323s ]
SELECT `id` FROM `stock` WHERE `id` <> 53786900 AND `partno` = '2385342-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.001142s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16357680 [ RunTime:0.000715s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53787565 LIMIT 5 [ RunTime:0.004622s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53787565 ORDER BY `minOrder` ASC [ RunTime:0.014812s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53787565 ORDER BY `unit` DESC [ RunTime:0.004278s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53787565 LIMIT 2 [ RunTime:0.000635s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53787565 ORDER BY `minOrder` ASC [ RunTime:0.010639s ]
select * from pdf where partno='2385345-1' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.009637s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2385345-1' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.013912s ]
SELECT `id` FROM `stock` WHERE `id` <> 53787565 AND `partno` = '2385345-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.008197s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16357772 [ RunTime:0.008149s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53787564 LIMIT 5 [ RunTime:0.010434s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53787564 ORDER BY `minOrder` ASC [ RunTime:0.008005s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53787564 ORDER BY `unit` DESC [ RunTime:0.022944s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53787564 LIMIT 2 [ RunTime:0.002578s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53787564 ORDER BY `minOrder` ASC [ RunTime:0.015339s ]
select * from pdf where partno='2385349-1' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.013916s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2385349-1' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.008536s ]
SELECT `id` FROM `stock` WHERE `id` <> 53787564 AND `partno` = '2385349-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.013657s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 20078956 [ RunTime:0.003568s ]
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 '2385%' OR `brand` LIKE '2385%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.004968s ]
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 '2385%' OR `brand` LIKE '2385%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.010313s ]
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 '2385%' OR `brand` LIKE '2385%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.012813s ]
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 '2385%' OR `brand` LIKE '2385%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003689s ]
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 '2385%' OR `brand` LIKE '2385%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001421s ]
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 '2385%' OR `brand` LIKE '2385%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.014103s ]
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 '2385%' OR `brand` LIKE '2385%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001425s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '2385%' OR `brand` LIKE '2385%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.004590s ]