SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002658s ]
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 'PS2802-1-F3%' OR `brand` LIKE 'PS2802-1-F3%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.004601s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001246s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14170775 LIMIT 5 [ RunTime:0.002125s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.009217s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14170775 ORDER BY `minOrder` ASC [ RunTime:0.004015s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.002752s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14170775 ORDER BY `unit` DESC [ RunTime:0.001302s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.002908s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14170775 LIMIT 2 [ RunTime:0.001919s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14170775 ORDER BY `minOrder` ASC [ RunTime:0.007542s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18693553 LIMIT 5 [ RunTime:0.014915s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18693553 ORDER BY `minOrder` ASC [ RunTime:0.006272s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18693553 ORDER BY `unit` DESC [ RunTime:0.011030s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18693553 LIMIT 2 [ RunTime:0.016674s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18693553 ORDER BY `minOrder` ASC [ RunTime:0.000959s ]
select * from pdf where partno='PS2802-1-F3-L-A' and brandshort='CEL' limit 1 [ RunTime:0.009697s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18689108 LIMIT 5 [ RunTime:0.013651s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18689108 ORDER BY `minOrder` ASC [ RunTime:0.008313s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18689108 ORDER BY `unit` DESC [ RunTime:0.011513s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18689108 LIMIT 2 [ RunTime:0.002947s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18689108 ORDER BY `minOrder` ASC [ RunTime:0.007611s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18689107 LIMIT 5 [ RunTime:0.001579s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18689107 ORDER BY `minOrder` ASC [ RunTime:0.003476s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18689107 ORDER BY `unit` DESC [ RunTime:0.002841s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18689107 LIMIT 2 [ RunTime:0.014925s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18689107 ORDER BY `minOrder` ASC [ RunTime:0.009897s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16992102 LIMIT 5 [ RunTime:0.006713s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16992102 ORDER BY `minOrder` ASC [ RunTime:0.003953s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16992102 ORDER BY `unit` DESC [ RunTime:0.013298s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16992102 LIMIT 2 [ RunTime:0.015882s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16992102 ORDER BY `minOrder` ASC [ RunTime:0.016906s ]
select * from pdf where partno='PS2802-1-F3-K-A' and brandshort='CEL' limit 1 [ RunTime:0.021988s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15204654 LIMIT 5 [ RunTime:0.007373s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15204654 ORDER BY `minOrder` ASC [ RunTime:0.003129s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15204654 ORDER BY `unit` DESC [ RunTime:0.000661s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15204654 LIMIT 2 [ RunTime:0.011917s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15204654 ORDER BY `minOrder` ASC [ RunTime:0.011499s ]
select * from pdf where partno='PS2802-1-F3-A' and brandshort='CEL' limit 1 [ RunTime:0.001413s ]
select foldpath,foldpath2,filename from pdf_file where id=751896 limit 1 [ RunTime:0.009487s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15204474 LIMIT 5 [ RunTime:0.014228s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15204474 ORDER BY `minOrder` ASC [ RunTime:0.000943s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15204474 ORDER BY `unit` DESC [ RunTime:0.000426s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15204474 LIMIT 2 [ RunTime:0.000719s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15204474 ORDER BY `minOrder` ASC [ RunTime:0.003189s ]
select * from pdf where partno='PS2802-1-F3' and brandshort='CEL' limit 1 [ RunTime:0.002035s ]
select foldpath,foldpath2,filename from pdf_file where id=751896 limit 1 [ RunTime:0.002253s ]
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 'PS2802-1-F3%' OR `brand` LIKE 'PS2802-1-F3%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001864s ]
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 'PS2802-1-F3%' OR `brand` LIKE 'PS2802-1-F3%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.009915s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37648300 LIMIT 5 [ RunTime:0.004256s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37648300 ORDER BY `minOrder` ASC [ RunTime:0.011287s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37648300 ORDER BY `unit` DESC [ RunTime:0.000532s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37648300 LIMIT 2 [ RunTime:0.007771s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37648300 ORDER BY `minOrder` ASC [ RunTime:0.012200s ]
select * from pdf where partno='PS2802-1-F3-A' and brandshort='Renesas Electronics Corporation' limit 1 [ RunTime:0.002416s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002443s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PS2802-1-F3-A' OR `brand` LIKE 'Renesas Electronics Corporation%' ) ) LIMIT 1 [ RunTime:0.010294s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 50450920 LIMIT 5 [ RunTime:0.012031s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50450920 ORDER BY `minOrder` ASC [ RunTime:0.007308s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 50450920 ORDER BY `unit` DESC [ RunTime:0.002583s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 50450920 LIMIT 2 [ RunTime:0.003051s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50450920 ORDER BY `minOrder` ASC [ RunTime:0.001282s ]
select * from pdf where partno='PS2802-1-F3-A' and brandshort='Renesas Electronics Corporation' limit 1 [ RunTime:0.000428s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PS2802-1-F3-A' OR `brand` LIKE 'Renesas Electronics Corporation%' ) ) LIMIT 1 [ RunTime:0.000311s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 50460830 LIMIT 5 [ RunTime:0.005794s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50460830 ORDER BY `minOrder` ASC [ RunTime:0.006549s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 50460830 ORDER BY `unit` DESC [ RunTime:0.004998s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 50460830 LIMIT 2 [ RunTime:0.002751s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50460830 ORDER BY `minOrder` ASC [ RunTime:0.008655s ]
select * from pdf where partno='PS2802-1-F3-A' and brandshort='CEL' limit 1 [ RunTime:0.002937s ]
select foldpath,foldpath2,filename from pdf_file where id=751896 limit 1 [ RunTime:0.005719s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PS2802-1-F3-A' OR `brand` LIKE 'CEL%' ) ) LIMIT 1 [ RunTime:0.029227s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 50459537 LIMIT 5 [ RunTime:0.014385s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50459537 ORDER BY `minOrder` ASC [ RunTime:0.059004s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 50459537 ORDER BY `unit` DESC [ RunTime:0.050928s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 50459537 LIMIT 2 [ RunTime:0.050934s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50459537 ORDER BY `minOrder` ASC [ RunTime:0.051139s ]
select * from pdf where partno='PS2802-1-F3-A/N' and brandshort='Renesas Electronics Corporation' limit 1 [ RunTime:0.051489s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PS2802-1-F3-A/N' OR `brand` LIKE 'Renesas Electronics Corporation%' ) ) LIMIT 1 [ RunTime:0.051339s ]
SELECT `id` FROM `stock` WHERE `id` <> 50459537 AND `partno` = 'PS2802-1-F3-A/N' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%renesas electronics corporation%' ) [ RunTime:0.051182s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37656640 [ RunTime:0.050903s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 50459535 LIMIT 5 [ RunTime:0.050858s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50459535 ORDER BY `minOrder` ASC [ RunTime:0.051021s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 50459535 ORDER BY `unit` DESC [ RunTime:0.050912s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 50459535 LIMIT 2 [ RunTime:0.050858s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50459535 ORDER BY `minOrder` ASC [ RunTime:0.050963s ]
select * from pdf where partno='PS2802-1-F3-A/KL2' and brandshort='Renesas Electronics Corporation' limit 1 [ RunTime:0.051153s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PS2802-1-F3-A/KL2' OR `brand` LIKE 'Renesas Electronics Corporation%' ) ) LIMIT 1 [ RunTime:0.051106s ]
SELECT `id` FROM `stock` WHERE `id` <> 50459535 AND `partno` = 'PS2802-1-F3-A/KL2' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%renesas electronics corporation%' ) [ RunTime:0.051174s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37656902 [ RunTime:0.030056s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 50459534 LIMIT 5 [ RunTime:0.068792s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50459534 ORDER BY `minOrder` ASC [ RunTime:0.035737s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 50459534 ORDER BY `unit` DESC [ RunTime:0.079238s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 50459534 LIMIT 2 [ RunTime:0.142669s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50459534 ORDER BY `minOrder` ASC [ RunTime:0.107239s ]
select * from pdf where partno='PS2802-1-F3-A-M' and brandshort='Renesas Electronics Corporation' limit 1 [ RunTime:0.127692s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PS2802-1-F3-A-M' OR `brand` LIKE 'Renesas Electronics Corporation%' ) ) LIMIT 1 [ RunTime:0.075979s ]
SELECT `id` FROM `stock` WHERE `id` <> 50459534 AND `partno` = 'PS2802-1-F3-A-M' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%renesas electronics corporation%' ) [ RunTime:0.076608s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37656901 [ RunTime:0.097731s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 50459532 LIMIT 5 [ RunTime:0.070577s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50459532 ORDER BY `minOrder` ASC [ RunTime:0.009898s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 50459532 ORDER BY `unit` DESC [ RunTime:0.014489s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 50459532 LIMIT 2 [ RunTime:0.004283s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50459532 ORDER BY `minOrder` ASC [ RunTime:0.007551s ]
select * from pdf where partno='PS2802-1-F3-A-K' and brandshort='Renesas Electronics Corporation' limit 1 [ RunTime:0.022306s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PS2802-1-F3-A-K' OR `brand` LIKE 'Renesas Electronics Corporation%' ) ) LIMIT 1 [ RunTime:0.010703s ]
SELECT `id` FROM `stock` WHERE `id` <> 50459532 AND `partno` = 'PS2802-1-F3-A-K' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%renesas electronics corporation%' ) [ RunTime:0.010399s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37656899 [ RunTime:0.000776s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 50459275 LIMIT 5 [ RunTime:0.008516s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50459275 ORDER BY `minOrder` ASC [ RunTime:0.014562s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 50459275 ORDER BY `unit` DESC [ RunTime:0.019488s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 50459275 LIMIT 2 [ RunTime:0.029974s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50459275 ORDER BY `minOrder` ASC [ RunTime:0.017116s ]
select * from pdf where partno='PS2802-1-F3-A-N' and brandshort='Renesas Electronics Corporation' limit 1 [ RunTime:0.016551s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PS2802-1-F3-A-N' OR `brand` LIKE 'Renesas Electronics Corporation%' ) ) LIMIT 1 [ RunTime:0.003557s ]
SELECT `id` FROM `stock` WHERE `id` <> 50459275 AND `partno` = 'PS2802-1-F3-A-N' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%renesas electronics corporation%' ) [ RunTime:0.010604s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37656641 [ RunTime:0.007633s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 50459274 LIMIT 5 [ RunTime:0.012633s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50459274 ORDER BY `minOrder` ASC [ RunTime:0.004696s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 50459274 ORDER BY `unit` DESC [ RunTime:0.000748s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 50459274 LIMIT 2 [ RunTime:0.018631s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50459274 ORDER BY `minOrder` ASC [ RunTime:0.004333s ]
select * from pdf where partno='PS2802-1-F3-A/K' and brandshort='Renesas Electronics Corporation' limit 1 [ RunTime:0.010715s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PS2802-1-F3-A/K' OR `brand` LIKE 'Renesas Electronics Corporation%' ) ) LIMIT 1 [ RunTime:0.001550s ]
SELECT `id` FROM `stock` WHERE `id` <> 50459274 AND `partno` = 'PS2802-1-F3-A/K' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%renesas electronics corporation%' ) [ RunTime:0.011883s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37656639 [ RunTime:0.005063s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 50459273 LIMIT 5 [ RunTime:0.015519s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50459273 ORDER BY `minOrder` ASC [ RunTime:0.004475s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 50459273 ORDER BY `unit` DESC [ RunTime:0.000741s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 50459273 LIMIT 2 [ RunTime:0.012931s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50459273 ORDER BY `minOrder` ASC [ RunTime:0.004643s ]
select * from pdf where partno='PS2802-1-F3-A/M' and brandshort='Renesas Electronics Corporation' limit 1 [ RunTime:0.001011s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PS2802-1-F3-A/M' OR `brand` LIKE 'Renesas Electronics Corporation%' ) ) LIMIT 1 [ RunTime:0.001529s ]
SELECT `id` FROM `stock` WHERE `id` <> 50459273 AND `partno` = 'PS2802-1-F3-A/M' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%renesas electronics corporation%' ) [ RunTime:0.006241s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37656638 [ RunTime:0.000638s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 50459272 LIMIT 5 [ RunTime:0.005103s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50459272 ORDER BY `minOrder` ASC [ RunTime:0.004120s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 50459272 ORDER BY `unit` DESC [ RunTime:0.004508s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 50459272 LIMIT 2 [ RunTime:0.011730s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50459272 ORDER BY `minOrder` ASC [ RunTime:0.012327s ]
select * from pdf where partno='PS2802-1-F3-A/KL' and brandshort='Renesas Electronics Corporation' limit 1 [ RunTime:0.007136s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PS2802-1-F3-A/KL' OR `brand` LIKE 'Renesas Electronics Corporation%' ) ) LIMIT 1 [ RunTime:0.007036s ]
SELECT `id` FROM `stock` WHERE `id` <> 50459272 AND `partno` = 'PS2802-1-F3-A/KL' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%renesas electronics corporation%' ) [ RunTime:0.020421s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37656637 [ RunTime:0.006129s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 50459271 LIMIT 5 [ RunTime:0.016194s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50459271 ORDER BY `minOrder` ASC [ RunTime:0.010199s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 50459271 ORDER BY `unit` DESC [ RunTime:0.006183s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 50459271 LIMIT 2 [ RunTime:0.014831s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50459271 ORDER BY `minOrder` ASC [ RunTime:0.013227s ]
select * from pdf where partno='PS2802-1-F3-A/L' and brandshort='Renesas Electronics Corporation' limit 1 [ RunTime:0.000584s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PS2802-1-F3-A/L' OR `brand` LIKE 'Renesas Electronics Corporation%' ) ) LIMIT 1 [ RunTime:0.001325s ]
SELECT `id` FROM `stock` WHERE `id` <> 50459271 AND `partno` = 'PS2802-1-F3-A/L' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%renesas electronics corporation%' ) [ RunTime:0.005497s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37656636 [ RunTime:0.006192s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 50459267 LIMIT 5 [ RunTime:0.022364s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50459267 ORDER BY `minOrder` ASC [ RunTime:0.031592s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 50459267 ORDER BY `unit` DESC [ RunTime:0.035582s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 50459267 LIMIT 2 [ RunTime:0.027623s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50459267 ORDER BY `minOrder` ASC [ RunTime:0.032696s ]
select * from pdf where partno='PS2802-1-F3-A-L' and brandshort='Renesas Electronics Corporation' limit 1 [ RunTime:0.057329s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PS2802-1-F3-A-L' OR `brand` LIKE 'Renesas Electronics Corporation%' ) ) LIMIT 1 [ RunTime:0.018832s ]
SELECT `id` FROM `stock` WHERE `id` <> 50459267 AND `partno` = 'PS2802-1-F3-A-L' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%renesas electronics corporation%' ) [ RunTime:0.025754s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37656632 [ RunTime:0.015473s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 50458990 LIMIT 5 [ RunTime:0.052866s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50458990 ORDER BY `minOrder` ASC [ RunTime:0.045643s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 50458990 ORDER BY `unit` DESC [ RunTime:0.038821s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 50458990 LIMIT 2 [ RunTime:0.022492s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50458990 ORDER BY `minOrder` ASC [ RunTime:0.038302s ]
select * from pdf where partno='PS2802-1-F3' and brandshort='CEL' limit 1 [ RunTime:0.014335s ]
select foldpath,foldpath2,filename from pdf_file where id=751896 limit 1 [ RunTime:0.011105s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PS2802-1-F3' OR `brand` LIKE 'CEL%' ) ) LIMIT 1 [ RunTime:0.012923s ]
SELECT `id` FROM `stock` WHERE `id` <> 50458990 AND `partno` = 'PS2802-1-F3' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cel%' ) [ RunTime:0.059759s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15204474 [ RunTime:0.008092s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 50458928 LIMIT 5 [ RunTime:0.042610s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50458928 ORDER BY `minOrder` ASC [ RunTime:0.045966s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 50458928 ORDER BY `unit` DESC [ RunTime:0.013586s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 50458928 LIMIT 2 [ RunTime:0.016050s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50458928 ORDER BY `minOrder` ASC [ RunTime:0.021348s ]
select * from pdf where partno='PS2802-1-F3-L-A' and brandshort='CEL' limit 1 [ RunTime:0.015606s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PS2802-1-F3-L-A' OR `brand` LIKE 'CEL%' ) ) LIMIT 1 [ RunTime:0.037691s ]
SELECT `id` FROM `stock` WHERE `id` <> 50458928 AND `partno` = 'PS2802-1-F3-L-A' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cel%' ) [ RunTime:0.014151s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18693553 [ RunTime:0.019937s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 50458925 LIMIT 5 [ RunTime:0.021166s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50458925 ORDER BY `minOrder` ASC [ RunTime:0.031514s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 50458925 ORDER BY `unit` DESC [ RunTime:0.022746s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 50458925 LIMIT 2 [ RunTime:0.024042s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50458925 ORDER BY `minOrder` ASC [ RunTime:0.015160s ]
select * from pdf where partno='PS2802-1-F3-K-A' and brandshort='CEL' limit 1 [ RunTime:0.019935s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PS2802-1-F3-K-A' OR `brand` LIKE 'CEL%' ) ) LIMIT 1 [ RunTime:0.034676s ]
SELECT `id` FROM `stock` WHERE `id` <> 50458925 AND `partno` = 'PS2802-1-F3-K-A' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cel%' ) [ RunTime:0.008399s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16992102 [ RunTime:0.012556s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37658194 LIMIT 5 [ RunTime:0.009514s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37658194 ORDER BY `minOrder` ASC [ RunTime:0.013797s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37658194 ORDER BY `unit` DESC [ RunTime:0.006485s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37658194 LIMIT 2 [ RunTime:0.018146s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37658194 ORDER BY `minOrder` ASC [ RunTime:0.034046s ]
select * from pdf where partno='PS2802-1-F3-A' and brandshort='CEL' limit 1 [ RunTime:0.004954s ]
select foldpath,foldpath2,filename from pdf_file where id=751896 limit 1 [ RunTime:0.037642s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PS2802-1-F3-A' OR `brand` LIKE 'CEL%' ) ) LIMIT 1 [ RunTime:0.013659s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37656902 LIMIT 5 [ RunTime:0.050428s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37656902 ORDER BY `minOrder` ASC [ RunTime:0.028147s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37656902 ORDER BY `unit` DESC [ RunTime:0.008036s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37656902 LIMIT 2 [ RunTime:0.007283s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37656902 ORDER BY `minOrder` ASC [ RunTime:0.016083s ]
select * from pdf where partno='PS2802-1-F3-A/KL2' and brandshort='Renesas Electronics Corporation' limit 1 [ RunTime:0.016663s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PS2802-1-F3-A/KL2' OR `brand` LIKE 'Renesas Electronics Corporation%' ) ) LIMIT 1 [ RunTime:0.005107s ]
SELECT `id` FROM `stock` WHERE `id` <> 37656902 AND `partno` = 'PS2802-1-F3-A/KL2' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%renesas electronics corporation%' ) [ RunTime:0.004218s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 50459535 [ RunTime:0.007818s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37656901 LIMIT 5 [ RunTime:0.006812s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37656901 ORDER BY `minOrder` ASC [ RunTime:0.007790s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37656901 ORDER BY `unit` DESC [ RunTime:0.000350s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37656901 LIMIT 2 [ RunTime:0.006683s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37656901 ORDER BY `minOrder` ASC [ RunTime:0.007453s ]
select * from pdf where partno='PS2802-1-F3-A-M' and brandshort='Renesas Electronics Corporation' limit 1 [ RunTime:0.006792s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PS2802-1-F3-A-M' OR `brand` LIKE 'Renesas Electronics Corporation%' ) ) LIMIT 1 [ RunTime:0.003920s ]
SELECT `id` FROM `stock` WHERE `id` <> 37656901 AND `partno` = 'PS2802-1-F3-A-M' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%renesas electronics corporation%' ) [ RunTime:0.008331s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 50459534 [ RunTime:0.009407s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37656899 LIMIT 5 [ RunTime:0.021451s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37656899 ORDER BY `minOrder` ASC [ RunTime:0.003142s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37656899 ORDER BY `unit` DESC [ RunTime:0.000764s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37656899 LIMIT 2 [ RunTime:0.004561s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37656899 ORDER BY `minOrder` ASC [ RunTime:0.006556s ]
select * from pdf where partno='PS2802-1-F3-A-K' and brandshort='Renesas Electronics Corporation' limit 1 [ RunTime:0.000503s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PS2802-1-F3-A-K' OR `brand` LIKE 'Renesas Electronics Corporation%' ) ) LIMIT 1 [ RunTime:0.000431s ]
SELECT `id` FROM `stock` WHERE `id` <> 37656899 AND `partno` = 'PS2802-1-F3-A-K' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%renesas electronics corporation%' ) [ RunTime:0.000768s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 50459532 [ RunTime:0.000540s ]
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 'PS2802-1-F3%' OR `brand` LIKE 'PS2802-1-F3%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.004484s ]
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 'PS2802-1-F3%' OR `brand` LIKE 'PS2802-1-F3%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001238s ]
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 'PS2802-1-F3%' OR `brand` LIKE 'PS2802-1-F3%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.006480s ]
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 'PS2802-1-F3%' OR `brand` LIKE 'PS2802-1-F3%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003243s ]
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 'PS2802-1-F3%' OR `brand` LIKE 'PS2802-1-F3%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.004002s ]
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 'PS2802-1-F3%' OR `brand` LIKE 'PS2802-1-F3%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003648s ]
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 'PS2802-1-F3%' OR `brand` LIKE 'PS2802-1-F3%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.005028s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'PS2802-1-F3%' OR `brand` LIKE 'PS2802-1-F3%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.001180s ]