SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001476s ]
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 'MURS160%' OR `brand` LIKE 'MURS160%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.007142s ]
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 'MURS160%' OR `brand` LIKE 'MURS160%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.009443s ]
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 'MURS160%' OR `brand` LIKE 'MURS160%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.027685s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.003161s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 44079564 LIMIT 5 [ RunTime:0.019499s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001449s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44079564 ORDER BY `minOrder` ASC [ RunTime:0.032456s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.004277s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 44079564 ORDER BY `unit` DESC [ RunTime:0.008498s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.001198s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 44079564 LIMIT 2 [ RunTime:0.014716s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44079564 ORDER BY `minOrder` ASC [ RunTime:0.012032s ]
select * from pdf where partno='MURS160-E3/52T' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.027022s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001285s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MURS160-E3/52T' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.041302s ]
SELECT `id` FROM `stock` WHERE `id` <> 44079564 AND `partno` = 'MURS160-E3/52T' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.040336s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 44079512 LIMIT 5 [ RunTime:0.028162s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44079512 ORDER BY `minOrder` ASC [ RunTime:0.028104s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 44079512 ORDER BY `unit` DESC [ RunTime:0.022959s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 44079512 LIMIT 2 [ RunTime:0.017928s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44079512 ORDER BY `minOrder` ASC [ RunTime:0.014896s ]
select * from pdf where partno='MURS160-13-F' and brandshort='Diodes Incorporated' limit 1 [ RunTime:0.052032s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MURS160-13-F' OR `brand` LIKE 'Diodes Incorporated%' ) ) LIMIT 1 [ RunTime:0.063859s ]
SELECT `id` FROM `stock` WHERE `id` <> 44079512 AND `partno` = 'MURS160-13-F' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%diodes incorporated%' ) [ RunTime:0.090082s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 44081832 LIMIT 5 [ RunTime:0.087686s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44081832 ORDER BY `minOrder` ASC [ RunTime:0.070837s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 44081832 ORDER BY `unit` DESC [ RunTime:0.070096s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 44081832 LIMIT 2 [ RunTime:0.123932s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44081832 ORDER BY `minOrder` ASC [ RunTime:0.024669s ]
select * from pdf where partno='MURS160-E3/5BT' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.036413s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MURS160-E3/5BT' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.058513s ]
SELECT `id` FROM `stock` WHERE `id` <> 44081832 AND `partno` = 'MURS160-E3/5BT' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.105884s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 44084911 LIMIT 5 [ RunTime:0.097885s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44084911 ORDER BY `minOrder` ASC [ RunTime:0.038003s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 44084911 ORDER BY `unit` DESC [ RunTime:0.072732s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 44084911 LIMIT 2 [ RunTime:0.066283s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44084911 ORDER BY `minOrder` ASC [ RunTime:0.010093s ]
select * from pdf where partno='MURS160HE3_A/I' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.059570s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MURS160HE3_A/I' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.039892s ]
SELECT `id` FROM `stock` WHERE `id` <> 44084911 AND `partno` = 'MURS160HE3_A/I' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.041534s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 44081116 LIMIT 5 [ RunTime:0.026631s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44081116 ORDER BY `minOrder` ASC [ RunTime:0.031024s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 44081116 ORDER BY `unit` DESC [ RunTime:0.026428s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 44081116 LIMIT 2 [ RunTime:0.053277s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44081116 ORDER BY `minOrder` ASC [ RunTime:0.026736s ]
select * from pdf where partno='MURS160' and brandshort='Diodes Incorporated' limit 1 [ RunTime:0.030711s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MURS160' OR `brand` LIKE 'Diodes Incorporated%' ) ) LIMIT 1 [ RunTime:0.002940s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 44091463 LIMIT 5 [ RunTime:0.005589s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44091463 ORDER BY `minOrder` ASC [ RunTime:0.010714s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 44091463 ORDER BY `unit` DESC [ RunTime:0.001582s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 44091463 LIMIT 2 [ RunTime:0.029396s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44091463 ORDER BY `minOrder` ASC [ RunTime:0.009450s ]
select * from pdf where partno='MURS160J' and brandshort='WeEn Semiconductors' limit 1 [ RunTime:0.017549s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MURS160J' OR `brand` LIKE 'WeEn Semiconductors%' ) ) LIMIT 1 [ RunTime:0.027963s ]
SELECT `id` FROM `stock` WHERE `id` <> 44091463 AND `partno` = 'MURS160J' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%ween semiconductors%' ) [ RunTime:0.019647s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 44091660 LIMIT 5 [ RunTime:0.014299s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44091660 ORDER BY `minOrder` ASC [ RunTime:0.010223s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 44091660 ORDER BY `unit` DESC [ RunTime:0.008704s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 44091660 LIMIT 2 [ RunTime:0.008881s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44091660 ORDER BY `minOrder` ASC [ RunTime:0.007787s ]
select * from pdf where partno='MURS160' and brandshort='Good-Ark Semiconductor' limit 1 [ RunTime:0.009676s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MURS160' OR `brand` LIKE 'Good-Ark Semiconductor%' ) ) LIMIT 1 [ RunTime:0.012844s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 44084906 LIMIT 5 [ RunTime:0.043983s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44084906 ORDER BY `minOrder` ASC [ RunTime:0.043285s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 44084906 ORDER BY `unit` DESC [ RunTime:0.025750s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 44084906 LIMIT 2 [ RunTime:0.038044s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44084906 ORDER BY `minOrder` ASC [ RunTime:0.016706s ]
select * from pdf where partno='MURS160-M3/5BT' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.078906s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MURS160-M3/5BT' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.004448s ]
SELECT `id` FROM `stock` WHERE `id` <> 44084906 AND `partno` = 'MURS160-M3/5BT' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.045845s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 44091709 LIMIT 5 [ RunTime:0.019290s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44091709 ORDER BY `minOrder` ASC [ RunTime:0.037879s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 44091709 ORDER BY `unit` DESC [ RunTime:0.020981s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 44091709 LIMIT 2 [ RunTime:0.071075s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44091709 ORDER BY `minOrder` ASC [ RunTime:0.016808s ]
select * from pdf where partno='MURS160BJ' and brandshort='WeEn Semiconductors' limit 1 [ RunTime:0.047755s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MURS160BJ' OR `brand` LIKE 'WeEn Semiconductors%' ) ) LIMIT 1 [ RunTime:0.046513s ]
SELECT `id` FROM `stock` WHERE `id` <> 44091709 AND `partno` = 'MURS160BJ' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%ween semiconductors%' ) [ RunTime:0.071236s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 44087812 LIMIT 5 [ RunTime:0.140647s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44087812 ORDER BY `minOrder` ASC [ RunTime:0.072593s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 44087812 ORDER BY `unit` DESC [ RunTime:0.048075s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 44087812 LIMIT 2 [ RunTime:0.050574s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44087812 ORDER BY `minOrder` ASC [ RunTime:0.037151s ]
select * from pdf where partno='MURS160Q-13-F' and brandshort='Diodes Incorporated' limit 1 [ RunTime:0.026683s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MURS160Q-13-F' OR `brand` LIKE 'Diodes Incorporated%' ) ) LIMIT 1 [ RunTime:0.097665s ]
SELECT `id` FROM `stock` WHERE `id` <> 44087812 AND `partno` = 'MURS160Q-13-F' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%diodes incorporated%' ) [ RunTime:0.069793s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 44084035 LIMIT 5 [ RunTime:0.056387s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44084035 ORDER BY `minOrder` ASC [ RunTime:0.041181s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 44084035 ORDER BY `unit` DESC [ RunTime:0.062671s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 44084035 LIMIT 2 [ RunTime:0.006252s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44084035 ORDER BY `minOrder` ASC [ RunTime:0.019026s ]
select * from pdf where partno='MURS160A-13' and brandshort='Diodes Incorporated' limit 1 [ RunTime:0.090749s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MURS160A-13' OR `brand` LIKE 'Diodes Incorporated%' ) ) LIMIT 1 [ RunTime:0.022119s ]
SELECT `id` FROM `stock` WHERE `id` <> 44084035 AND `partno` = 'MURS160A-13' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%diodes incorporated%' ) [ RunTime:0.094040s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 44094208 LIMIT 5 [ RunTime:0.088581s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44094208 ORDER BY `minOrder` ASC [ RunTime:0.066302s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 44094208 ORDER BY `unit` DESC [ RunTime:0.009225s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 44094208 LIMIT 2 [ RunTime:0.087240s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44094208 ORDER BY `minOrder` ASC [ RunTime:0.028892s ]
select * from pdf where partno='MURS160HE3_A/H' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.038971s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MURS160HE3_A/H' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.017733s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 44095072 LIMIT 5 [ RunTime:0.036616s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44095072 ORDER BY `minOrder` ASC [ RunTime:0.030418s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 44095072 ORDER BY `unit` DESC [ RunTime:0.031220s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 44095072 LIMIT 2 [ RunTime:0.054815s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44095072 ORDER BY `minOrder` ASC [ RunTime:0.046408s ]
select * from pdf where partno='MURS160' and brandshort='SMC Diode Solutions' limit 1 [ RunTime:0.037263s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MURS160' OR `brand` LIKE 'SMC Diode Solutions%' ) ) LIMIT 1 [ RunTime:0.016067s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 44094779 LIMIT 5 [ RunTime:0.046414s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44094779 ORDER BY `minOrder` ASC [ RunTime:0.016494s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 44094779 ORDER BY `unit` DESC [ RunTime:0.012278s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 44094779 LIMIT 2 [ RunTime:0.030629s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44094779 ORDER BY `minOrder` ASC [ RunTime:0.002505s ]
select * from pdf where partno='MURS160AJ' and brandshort='Nexperia USA Inc.' limit 1 [ RunTime:0.020698s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MURS160AJ' OR `brand` LIKE 'Nexperia USA Inc.%' ) ) LIMIT 1 [ RunTime:0.024398s ]
SELECT `id` FROM `stock` WHERE `id` <> 44094779 AND `partno` = 'MURS160AJ' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%nexperia usa inc.%' ) [ RunTime:0.018280s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 44104723 LIMIT 5 [ RunTime:0.004808s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44104723 ORDER BY `minOrder` ASC [ RunTime:0.027822s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 44104723 ORDER BY `unit` DESC [ RunTime:0.022733s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 44104723 LIMIT 2 [ RunTime:0.020120s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44104723 ORDER BY `minOrder` ASC [ RunTime:0.009817s ]
select * from pdf where partno='MURS160BJ' and brandshort='Nexperia USA Inc.' limit 1 [ RunTime:0.008935s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MURS160BJ' OR `brand` LIKE 'Nexperia USA Inc.%' ) ) LIMIT 1 [ RunTime:0.010742s ]
SELECT `id` FROM `stock` WHERE `id` <> 44104723 AND `partno` = 'MURS160BJ' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%nexperia usa inc.%' ) [ RunTime:0.024212s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 44109461 LIMIT 5 [ RunTime:0.039530s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44109461 ORDER BY `minOrder` ASC [ RunTime:0.011105s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 44109461 ORDER BY `unit` DESC [ RunTime:0.025769s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 44109461 LIMIT 2 [ RunTime:0.029748s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44109461 ORDER BY `minOrder` ASC [ RunTime:0.014712s ]
select * from pdf where partno='MURS160-13' and brandshort='Diodes Incorporated' limit 1 [ RunTime:0.037492s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MURS160-13' OR `brand` LIKE 'Diodes Incorporated%' ) ) LIMIT 1 [ RunTime:0.044983s ]
SELECT `id` FROM `stock` WHERE `id` <> 44109461 AND `partno` = 'MURS160-13' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%diodes incorporated%' ) [ RunTime:0.019439s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 44107918 LIMIT 5 [ RunTime:0.017298s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44107918 ORDER BY `minOrder` ASC [ RunTime:0.013325s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 44107918 ORDER BY `unit` DESC [ RunTime:0.012662s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 44107918 LIMIT 2 [ RunTime:0.046465s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44107918 ORDER BY `minOrder` ASC [ RunTime:0.008405s ]
select * from pdf where partno='MURS160B' and brandshort='Huixin' limit 1 [ RunTime:0.027575s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MURS160B' OR `brand` LIKE 'Huixin%' ) ) LIMIT 1 [ RunTime:0.034710s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 44105059 LIMIT 5 [ RunTime:0.001383s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44105059 ORDER BY `minOrder` ASC [ RunTime:0.020939s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 44105059 ORDER BY `unit` DESC [ RunTime:0.005707s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 44105059 LIMIT 2 [ RunTime:0.010388s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44105059 ORDER BY `minOrder` ASC [ RunTime:0.016295s ]
select * from pdf where partno='MURS160T3' and brandshort='onsemi' limit 1 [ RunTime:0.011293s ]
select foldpath,foldpath2,filename from pdf_file where id=108797 limit 1 [ RunTime:0.019132s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MURS160T3' OR `brand` LIKE 'onsemi%' ) ) LIMIT 1 [ RunTime:0.028406s ]
SELECT `id` FROM `stock` WHERE `id` <> 44105059 AND `partno` = 'MURS160T3' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%onsemi%' ) [ RunTime:0.019707s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 44099828 LIMIT 5 [ RunTime:0.011681s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44099828 ORDER BY `minOrder` ASC [ RunTime:0.020585s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 44099828 ORDER BY `unit` DESC [ RunTime:0.022525s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 44099828 LIMIT 2 [ RunTime:0.023673s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44099828 ORDER BY `minOrder` ASC [ RunTime:0.014506s ]
select * from pdf where partno='MURS160A' and brandshort='Diodes Incorporated' limit 1 [ RunTime:0.023847s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MURS160A' OR `brand` LIKE 'Diodes Incorporated%' ) ) LIMIT 1 [ RunTime:0.014240s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 44096664 LIMIT 5 [ RunTime:0.011279s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44096664 ORDER BY `minOrder` ASC [ RunTime:0.029332s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 44096664 ORDER BY `unit` DESC [ RunTime:0.017344s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 44096664 LIMIT 2 [ RunTime:0.026104s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44096664 ORDER BY `minOrder` ASC [ RunTime:0.005044s ]
select * from pdf where partno='MURS160-M3/52T' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.028377s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MURS160-M3/52T' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.022483s ]
SELECT `id` FROM `stock` WHERE `id` <> 44096664 AND `partno` = 'MURS160-M3/52T' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.042796s ]
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 'MURS160%' OR `brand` LIKE 'MURS160%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.023634s ]
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 'MURS160%' OR `brand` LIKE 'MURS160%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.017087s ]
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 'MURS160%' OR `brand` LIKE 'MURS160%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.030591s ]
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 'MURS160%' OR `brand` LIKE 'MURS160%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.032563s ]
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 'MURS160%' OR `brand` LIKE 'MURS160%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.005810s ]
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 'MURS160%' OR `brand` LIKE 'MURS160%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.018675s ]
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 'MURS160%' OR `brand` LIKE 'MURS160%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.026596s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'MURS160%' OR `brand` LIKE 'MURS160%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.009860s ]