SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002109s ]
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 'WG92PR9SY%' OR `brand` LIKE 'WG92PR9SY%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.006407s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001208s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12493245 LIMIT 5 [ RunTime:0.000880s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.005544s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12493245 ORDER BY `minOrder` ASC [ RunTime:0.002899s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.011395s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12493245 ORDER BY `unit` DESC [ RunTime:0.009669s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.006587s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12493245 LIMIT 2 [ RunTime:0.000531s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12493245 ORDER BY `minOrder` ASC [ RunTime:0.001019s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12768030 LIMIT 5 [ RunTime:0.006249s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12768030 ORDER BY `minOrder` ASC [ RunTime:0.000616s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12768030 ORDER BY `unit` DESC [ RunTime:0.006333s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12768030 LIMIT 2 [ RunTime:0.004393s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12768030 ORDER BY `minOrder` ASC [ RunTime:0.007077s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12768029 LIMIT 5 [ RunTime:0.001458s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12768029 ORDER BY `minOrder` ASC [ RunTime:0.005822s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12768029 ORDER BY `unit` DESC [ RunTime:0.006891s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12768029 LIMIT 2 [ RunTime:0.007713s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12768029 ORDER BY `minOrder` ASC [ RunTime:0.003580s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12767910 LIMIT 5 [ RunTime:0.002629s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12767910 ORDER BY `minOrder` ASC [ RunTime:0.004629s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12767910 ORDER BY `unit` DESC [ RunTime:0.008186s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12767910 LIMIT 2 [ RunTime:0.003482s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12767910 ORDER BY `minOrder` ASC [ RunTime:0.009968s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12767909 LIMIT 5 [ RunTime:0.008567s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12767909 ORDER BY `minOrder` ASC [ RunTime:0.011964s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12767909 ORDER BY `unit` DESC [ RunTime:0.002495s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12767909 LIMIT 2 [ RunTime:0.017655s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12767909 ORDER BY `minOrder` ASC [ RunTime:0.023233s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12767908 LIMIT 5 [ RunTime:0.025701s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12767908 ORDER BY `minOrder` ASC [ RunTime:0.011992s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12767908 ORDER BY `unit` DESC [ RunTime:0.010944s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12767908 LIMIT 2 [ RunTime:0.003458s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12767908 ORDER BY `minOrder` ASC [ RunTime:0.004320s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12767907 LIMIT 5 [ RunTime:0.007643s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12767907 ORDER BY `minOrder` ASC [ RunTime:0.026968s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12767907 ORDER BY `unit` DESC [ RunTime:0.019229s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12767907 LIMIT 2 [ RunTime:0.012072s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12767907 ORDER BY `minOrder` ASC [ RunTime:0.008326s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12767906 LIMIT 5 [ RunTime:0.010445s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12767906 ORDER BY `minOrder` ASC [ RunTime:0.031063s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12767906 ORDER BY `unit` DESC [ RunTime:0.011714s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12767906 LIMIT 2 [ RunTime:0.051099s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12767906 ORDER BY `minOrder` ASC [ RunTime:0.020875s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12767905 LIMIT 5 [ RunTime:0.004341s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12767905 ORDER BY `minOrder` ASC [ RunTime:0.014891s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12767905 ORDER BY `unit` DESC [ RunTime:0.004442s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12767905 LIMIT 2 [ RunTime:0.013815s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12767905 ORDER BY `minOrder` ASC [ RunTime:0.005956s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12767904 LIMIT 5 [ RunTime:0.012335s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12767904 ORDER BY `minOrder` ASC [ RunTime:0.007218s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12767904 ORDER BY `unit` DESC [ RunTime:0.000967s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12767904 LIMIT 2 [ RunTime:0.009852s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12767904 ORDER BY `minOrder` ASC [ RunTime:0.005726s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12767903 LIMIT 5 [ RunTime:0.002883s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12767903 ORDER BY `minOrder` ASC [ RunTime:0.016103s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12767903 ORDER BY `unit` DESC [ RunTime:0.006434s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12767903 LIMIT 2 [ RunTime:0.000543s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12767903 ORDER BY `minOrder` ASC [ RunTime:0.002467s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12767902 LIMIT 5 [ RunTime:0.013245s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12767902 ORDER BY `minOrder` ASC [ RunTime:0.003521s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12767902 ORDER BY `unit` DESC [ RunTime:0.015778s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12767902 LIMIT 2 [ RunTime:0.013307s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12767902 ORDER BY `minOrder` ASC [ RunTime:0.022418s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12767901 LIMIT 5 [ RunTime:0.044408s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12767901 ORDER BY `minOrder` ASC [ RunTime:0.023227s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12767901 ORDER BY `unit` DESC [ RunTime:0.056295s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12767901 LIMIT 2 [ RunTime:0.048881s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12767901 ORDER BY `minOrder` ASC [ RunTime:0.015374s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12767900 LIMIT 5 [ RunTime:0.004014s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12767900 ORDER BY `minOrder` ASC [ RunTime:0.007718s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12767900 ORDER BY `unit` DESC [ RunTime:0.004836s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12767900 LIMIT 2 [ RunTime:0.001796s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12767900 ORDER BY `minOrder` ASC [ RunTime:0.009347s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12767899 LIMIT 5 [ RunTime:0.022879s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12767899 ORDER BY `minOrder` ASC [ RunTime:0.022026s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12767899 ORDER BY `unit` DESC [ RunTime:0.009130s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12767899 LIMIT 2 [ RunTime:0.000582s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12767899 ORDER BY `minOrder` ASC [ RunTime:0.001978s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12020277 LIMIT 5 [ RunTime:0.002689s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12020277 ORDER BY `minOrder` ASC [ RunTime:0.005265s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12020277 ORDER BY `unit` DESC [ RunTime:0.000452s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12020277 LIMIT 2 [ RunTime:0.009541s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12020277 ORDER BY `minOrder` ASC [ RunTime:0.003849s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11592292 LIMIT 5 [ RunTime:0.000957s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11592292 ORDER BY `minOrder` ASC [ RunTime:0.006056s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11592292 ORDER BY `unit` DESC [ RunTime:0.007312s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11592292 LIMIT 2 [ RunTime:0.020805s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11592292 ORDER BY `minOrder` ASC [ RunTime:0.001983s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11592291 LIMIT 5 [ RunTime:0.006871s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11592291 ORDER BY `minOrder` ASC [ RunTime:0.009344s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11592291 ORDER BY `unit` DESC [ RunTime:0.018679s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11592291 LIMIT 2 [ RunTime:0.009742s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11592291 ORDER BY `minOrder` ASC [ RunTime:0.022992s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11592290 LIMIT 5 [ RunTime:0.014725s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11592290 ORDER BY `minOrder` ASC [ RunTime:0.018883s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11592290 ORDER BY `unit` DESC [ RunTime:0.014361s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11592290 LIMIT 2 [ RunTime:0.022211s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11592290 ORDER BY `minOrder` ASC [ RunTime:0.004545s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11592289 LIMIT 5 [ RunTime:0.013101s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11592289 ORDER BY `minOrder` ASC [ RunTime:0.022102s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11592289 ORDER BY `unit` DESC [ RunTime:0.017521s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11592289 LIMIT 2 [ RunTime:0.009650s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11592289 ORDER BY `minOrder` ASC [ RunTime:0.003754s ]
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 'WG92PR9SY%' OR `brand` LIKE 'WG92PR9SY%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.005689s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32267004 LIMIT 5 [ RunTime:0.003858s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32267004 ORDER BY `minOrder` ASC [ RunTime:0.028119s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32267004 ORDER BY `unit` DESC [ RunTime:0.012015s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32267004 LIMIT 2 [ RunTime:0.008098s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32267004 ORDER BY `minOrder` ASC [ RunTime:0.001334s ]
select * from pdf where partno='wg92pr9sy' and brandshort='molex / airborn' limit 1 [ RunTime:0.010997s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001487s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'wg92pr9sy' OR `brand` LIKE 'molex / airborn%' ) ) LIMIT 1 [ RunTime:0.004452s ]
SELECT `id` FROM `stock` WHERE `id` <> 32267004 AND `partno` = 'wg92pr9sy' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%molex / airborn%' ) [ RunTime:0.009919s ]
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 'WG92PR9SY%' OR `brand` LIKE 'WG92PR9SY%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.009511s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60944309 LIMIT 5 [ RunTime:0.020761s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60944309 ORDER BY `minOrder` ASC [ RunTime:0.022348s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60944309 ORDER BY `unit` DESC [ RunTime:0.002541s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60944309 LIMIT 2 [ RunTime:0.011631s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60944309 ORDER BY `minOrder` ASC [ RunTime:0.006773s ]
select * from pdf where partno='WG92PR9SY' and brandshort='Molex' limit 1 [ RunTime:0.008057s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'WG92PR9SY' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.018559s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59747720 LIMIT 5 [ RunTime:0.002813s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59747720 ORDER BY `minOrder` ASC [ RunTime:0.009152s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59747720 ORDER BY `unit` DESC [ RunTime:0.006921s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59747720 LIMIT 2 [ RunTime:0.002867s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59747720 ORDER BY `minOrder` ASC [ RunTime:0.003252s ]
select * from pdf where partno='WG92PR9SY342-3' and brandshort='AirBorn, a Molex company' limit 1 [ RunTime:0.030867s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'WG92PR9SY342-3' OR `brand` LIKE 'AirBorn, a Molex company%' ) ) LIMIT 1 [ RunTime:0.031019s ]
SELECT `id` FROM `stock` WHERE `id` <> 59747720 AND `partno` = 'WG92PR9SY342-3' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%airborn, a molex company%' ) [ RunTime:0.013446s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12768030 [ RunTime:0.002235s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59747719 LIMIT 5 [ RunTime:0.000792s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59747719 ORDER BY `minOrder` ASC [ RunTime:0.002431s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59747719 ORDER BY `unit` DESC [ RunTime:0.012697s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59747719 LIMIT 2 [ RunTime:0.007793s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59747719 ORDER BY `minOrder` ASC [ RunTime:0.004308s ]
select * from pdf where partno='WG92PR9SY-0' and brandshort='AirBorn, a Molex company' limit 1 [ RunTime:0.037872s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'WG92PR9SY-0' OR `brand` LIKE 'AirBorn, a Molex company%' ) ) LIMIT 1 [ RunTime:0.013130s ]
SELECT `id` FROM `stock` WHERE `id` <> 59747719 AND `partno` = 'WG92PR9SY-0' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%airborn, a molex company%' ) [ RunTime:0.024527s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12768029 [ RunTime:0.017237s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59747582 LIMIT 5 [ RunTime:0.012866s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59747582 ORDER BY `minOrder` ASC [ RunTime:0.050934s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59747582 ORDER BY `unit` DESC [ RunTime:0.016802s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59747582 LIMIT 2 [ RunTime:0.006635s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59747582 ORDER BY `minOrder` ASC [ RunTime:0.015897s ]
select * from pdf where partno='WG92PR9SY342-11' and brandshort='Molex' limit 1 [ RunTime:0.001134s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'WG92PR9SY342-11' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.024054s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59747581 LIMIT 5 [ RunTime:0.058526s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59747581 ORDER BY `minOrder` ASC [ RunTime:0.054442s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59747581 ORDER BY `unit` DESC [ RunTime:0.037565s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59747581 LIMIT 2 [ RunTime:0.021547s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59747581 ORDER BY `minOrder` ASC [ RunTime:0.012711s ]
select * from pdf where partno='WG92PR9SY342-4' and brandshort='Molex' limit 1 [ RunTime:0.042626s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'WG92PR9SY342-4' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.039533s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59747580 LIMIT 5 [ RunTime:0.054721s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59747580 ORDER BY `minOrder` ASC [ RunTime:0.021764s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59747580 ORDER BY `unit` DESC [ RunTime:0.019598s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59747580 LIMIT 2 [ RunTime:0.013109s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59747580 ORDER BY `minOrder` ASC [ RunTime:0.005681s ]
select * from pdf where partno='WG92PR9SY342-2' and brandshort='Molex' limit 1 [ RunTime:0.001480s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'WG92PR9SY342-2' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.032504s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59747579 LIMIT 5 [ RunTime:0.024944s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59747579 ORDER BY `minOrder` ASC [ RunTime:0.025106s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59747579 ORDER BY `unit` DESC [ RunTime:0.019881s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59747579 LIMIT 2 [ RunTime:0.030522s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59747579 ORDER BY `minOrder` ASC [ RunTime:0.029208s ]
select * from pdf where partno='WG92PR9SY342-6' and brandshort='Molex' limit 1 [ RunTime:0.008314s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'WG92PR9SY342-6' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.026028s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59747578 LIMIT 5 [ RunTime:0.014749s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59747578 ORDER BY `minOrder` ASC [ RunTime:0.019605s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59747578 ORDER BY `unit` DESC [ RunTime:0.006448s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59747578 LIMIT 2 [ RunTime:0.023374s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59747578 ORDER BY `minOrder` ASC [ RunTime:0.002276s ]
select * from pdf where partno='WG92PR9SY342-16' and brandshort='Molex' limit 1 [ RunTime:0.004580s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'WG92PR9SY342-16' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.024574s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59747577 LIMIT 5 [ RunTime:0.017900s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59747577 ORDER BY `minOrder` ASC [ RunTime:0.008657s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59747577 ORDER BY `unit` DESC [ RunTime:0.012943s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59747577 LIMIT 2 [ RunTime:0.028666s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59747577 ORDER BY `minOrder` ASC [ RunTime:0.011070s ]
select * from pdf where partno='WG92PR9SY342-23' and brandshort='Molex' limit 1 [ RunTime:0.009868s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'WG92PR9SY342-23' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.037031s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59747576 LIMIT 5 [ RunTime:0.027161s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59747576 ORDER BY `minOrder` ASC [ RunTime:0.020889s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59747576 ORDER BY `unit` DESC [ RunTime:0.008164s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59747576 LIMIT 2 [ RunTime:0.014301s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59747576 ORDER BY `minOrder` ASC [ RunTime:0.003125s ]
select * from pdf where partno='WG92PR9SY342-9' and brandshort='Molex' limit 1 [ RunTime:0.000893s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'WG92PR9SY342-9' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.013915s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59747575 LIMIT 5 [ RunTime:0.002834s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59747575 ORDER BY `minOrder` ASC [ RunTime:0.001098s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59747575 ORDER BY `unit` DESC [ RunTime:0.004855s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59747575 LIMIT 2 [ RunTime:0.009489s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59747575 ORDER BY `minOrder` ASC [ RunTime:0.000465s ]
select * from pdf where partno='WG92PR9SY342-7' and brandshort='Molex' limit 1 [ RunTime:0.002343s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'WG92PR9SY342-7' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.018139s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59747574 LIMIT 5 [ RunTime:0.003284s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59747574 ORDER BY `minOrder` ASC [ RunTime:0.000753s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59747574 ORDER BY `unit` DESC [ RunTime:0.005522s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59747574 LIMIT 2 [ RunTime:0.000656s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59747574 ORDER BY `minOrder` ASC [ RunTime:0.003069s ]
select * from pdf where partno='WG92PR9SY342-5' and brandshort='Molex' limit 1 [ RunTime:0.027547s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'WG92PR9SY342-5' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.027828s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59747573 LIMIT 5 [ RunTime:0.003754s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59747573 ORDER BY `minOrder` ASC [ RunTime:0.000779s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59747573 ORDER BY `unit` DESC [ RunTime:0.004709s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59747573 LIMIT 2 [ RunTime:0.009534s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59747573 ORDER BY `minOrder` ASC [ RunTime:0.000860s ]
select * from pdf where partno='WG92PR9SY342-28' and brandshort='Molex' limit 1 [ RunTime:0.005478s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'WG92PR9SY342-28' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.017168s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59747572 LIMIT 5 [ RunTime:0.014687s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59747572 ORDER BY `minOrder` ASC [ RunTime:0.004806s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59747572 ORDER BY `unit` DESC [ RunTime:0.000716s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59747572 LIMIT 2 [ RunTime:0.009020s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59747572 ORDER BY `minOrder` ASC [ RunTime:0.000535s ]
select * from pdf where partno='WG92PR9SY342-15' and brandshort='Molex' limit 1 [ RunTime:0.004873s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'WG92PR9SY342-15' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.021849s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59747571 LIMIT 5 [ RunTime:0.000668s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59747571 ORDER BY `minOrder` ASC [ RunTime:0.013928s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59747571 ORDER BY `unit` DESC [ RunTime:0.001923s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59747571 LIMIT 2 [ RunTime:0.017530s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59747571 ORDER BY `minOrder` ASC [ RunTime:0.008623s ]
select * from pdf where partno='WG92PR9SY342-12' and brandshort='Molex' limit 1 [ RunTime:0.004411s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'WG92PR9SY342-12' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.015813s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59747570 LIMIT 5 [ RunTime:0.002118s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59747570 ORDER BY `minOrder` ASC [ RunTime:0.005078s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59747570 ORDER BY `unit` DESC [ RunTime:0.000654s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59747570 LIMIT 2 [ RunTime:0.004480s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59747570 ORDER BY `minOrder` ASC [ RunTime:0.005063s ]
select * from pdf where partno='WG92PR9SY342-17' and brandshort='Molex' limit 1 [ RunTime:0.001058s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'WG92PR9SY342-17' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.020124s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59747569 LIMIT 5 [ RunTime:0.013461s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59747569 ORDER BY `minOrder` ASC [ RunTime:0.007816s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59747569 ORDER BY `unit` DESC [ RunTime:0.012847s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59747569 LIMIT 2 [ RunTime:0.002014s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59747569 ORDER BY `minOrder` ASC [ RunTime:0.000449s ]
select * from pdf where partno='WG92PR9SY342-13' and brandshort='Molex' limit 1 [ RunTime:0.013674s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'WG92PR9SY342-13' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.012479s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59747568 LIMIT 5 [ RunTime:0.003334s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59747568 ORDER BY `minOrder` ASC [ RunTime:0.000513s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59747568 ORDER BY `unit` DESC [ RunTime:0.000483s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59747568 LIMIT 2 [ RunTime:0.000448s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59747568 ORDER BY `minOrder` ASC [ RunTime:0.000437s ]
select * from pdf where partno='WG92PR9SY-1' and brandshort='Molex' limit 1 [ RunTime:0.000805s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'WG92PR9SY-1' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.000469s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59747567 LIMIT 5 [ RunTime:0.000766s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59747567 ORDER BY `minOrder` ASC [ RunTime:0.000712s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59747567 ORDER BY `unit` DESC [ RunTime:0.010047s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59747567 LIMIT 2 [ RunTime:0.014753s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59747567 ORDER BY `minOrder` ASC [ RunTime:0.007990s ]
select * from pdf where partno='WG92PR9SY342-1' and brandshort='Molex' limit 1 [ RunTime:0.010103s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'WG92PR9SY342-1' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.012517s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59747566 LIMIT 5 [ RunTime:0.001952s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59747566 ORDER BY `minOrder` ASC [ RunTime:0.007992s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59747566 ORDER BY `unit` DESC [ RunTime:0.037591s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59747566 LIMIT 2 [ RunTime:0.006131s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59747566 ORDER BY `minOrder` ASC [ RunTime:0.007267s ]
select * from pdf where partno='WG92PR9SY-3' and brandshort='Molex' limit 1 [ RunTime:0.000963s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'WG92PR9SY-3' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.023039s ]
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 'WG92PR9SY%' OR `brand` LIKE 'WG92PR9SY%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.008488s ]
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 'WG92PR9SY%' OR `brand` LIKE 'WG92PR9SY%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.016274s ]
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 'WG92PR9SY%' OR `brand` LIKE 'WG92PR9SY%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.013713s ]
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 'WG92PR9SY%' OR `brand` LIKE 'WG92PR9SY%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.013714s ]
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 'WG92PR9SY%' OR `brand` LIKE 'WG92PR9SY%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.022084s ]
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 'WG92PR9SY%' OR `brand` LIKE 'WG92PR9SY%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.075459s ]
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 'WG92PR9SY%' OR `brand` LIKE 'WG92PR9SY%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.058116s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'WG92PR9SY%' OR `brand` LIKE 'WG92PR9SY%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.031938s ]