SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002053s ]
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 'ps2581al1-a%' OR `brand` LIKE 'ps2581al1-a%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.027714s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.008440s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18692714 LIMIT 5 [ RunTime:0.048980s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.013383s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18692714 ORDER BY `minOrder` ASC [ RunTime:0.037118s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.001252s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18692714 ORDER BY `unit` DESC [ RunTime:0.024293s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.001245s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18692714 LIMIT 2 [ RunTime:0.035504s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18692714 ORDER BY `minOrder` ASC [ RunTime:0.014772s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14171285 LIMIT 5 [ RunTime:0.040138s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14171285 ORDER BY `minOrder` ASC [ RunTime:0.049254s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14171285 ORDER BY `unit` DESC [ RunTime:0.061192s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14171285 LIMIT 2 [ RunTime:0.142226s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14171285 ORDER BY `minOrder` ASC [ RunTime:0.054591s ]
select * from pdf where partno='PS2581AL1-A' and brandshort='CEL' limit 1 [ RunTime:0.050954s ]
select foldpath,foldpath2,filename from pdf_file where id=1048015 limit 1 [ RunTime:0.045089s ]
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 'ps2581al1-a%' OR `brand` LIKE 'ps2581al1-a%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.061127s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51051025 LIMIT 5 [ RunTime:0.132332s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51051025 ORDER BY `minOrder` ASC [ RunTime:0.069727s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51051025 ORDER BY `unit` DESC [ RunTime:0.042125s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51051025 LIMIT 2 [ RunTime:0.017218s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51051025 ORDER BY `minOrder` ASC [ RunTime:0.027053s ]
select * from pdf where partno='ps2581al1-a' and brandshort='renesas electronics' limit 1 [ RunTime:0.008502s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002713s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'ps2581al1-a' OR `brand` LIKE 'renesas electronics%' ) ) LIMIT 1 [ RunTime:0.015619s ]
SELECT `id` FROM `stock` WHERE `id` <> 51051025 AND `partno` = 'ps2581al1-a' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%renesas electronics%' ) [ RunTime:0.024190s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18692714 [ RunTime:0.017572s ]
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 'ps2581al1-a%' OR `brand` LIKE 'ps2581al1-a%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.038947s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57450068 LIMIT 5 [ RunTime:0.013008s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57450068 ORDER BY `minOrder` ASC [ RunTime:0.021460s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57450068 ORDER BY `unit` DESC [ RunTime:0.014685s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57450068 LIMIT 2 [ RunTime:0.009589s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57450068 ORDER BY `minOrder` ASC [ RunTime:0.008955s ]
select * from pdf where partno='PS2581AL1-A' and brandshort='Renesas Electronics Corporation' limit 1 [ RunTime:0.008591s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PS2581AL1-A' OR `brand` LIKE 'Renesas Electronics Corporation%' ) ) LIMIT 1 [ RunTime:0.013061s ]
SELECT `id` FROM `stock` WHERE `id` <> 57450068 AND `partno` = 'PS2581AL1-A' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%renesas electronics corporation%' ) [ RunTime:0.015206s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18692714 [ RunTime:0.010966s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57455321 LIMIT 5 [ RunTime:0.013688s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57455321 ORDER BY `minOrder` ASC [ RunTime:0.031468s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57455321 ORDER BY `unit` DESC [ RunTime:0.006471s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57455321 LIMIT 2 [ RunTime:0.013303s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57455321 ORDER BY `minOrder` ASC [ RunTime:0.007058s ]
select * from pdf where partno='PS2581AL1-A' and brandshort='CEL' limit 1 [ RunTime:0.000759s ]
select foldpath,foldpath2,filename from pdf_file where id=1048015 limit 1 [ RunTime:0.008451s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PS2581AL1-A' OR `brand` LIKE 'CEL%' ) ) LIMIT 1 [ RunTime:0.011817s ]
SELECT `id` FROM `stock` WHERE `id` <> 57455321 AND `partno` = 'PS2581AL1-A' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cel%' ) [ RunTime:0.011218s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14171285 [ RunTime:0.001673s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57454907 LIMIT 5 [ RunTime:0.009700s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57454907 ORDER BY `minOrder` ASC [ RunTime:0.011475s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57454907 ORDER BY `unit` DESC [ RunTime:0.017372s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57454907 LIMIT 2 [ RunTime:0.004188s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57454907 ORDER BY `minOrder` ASC [ RunTime:0.002525s ]
select * from pdf where partno='PS2581AL1-A-Q' and brandshort='Renesas Electronics Corporation' limit 1 [ RunTime:0.001651s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PS2581AL1-A-Q' OR `brand` LIKE 'Renesas Electronics Corporation%' ) ) LIMIT 1 [ RunTime:0.004582s ]
SELECT `id` FROM `stock` WHERE `id` <> 57454907 AND `partno` = 'PS2581AL1-A-Q' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%renesas electronics corporation%' ) [ RunTime:0.013429s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57454906 LIMIT 5 [ RunTime:0.014078s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57454906 ORDER BY `minOrder` ASC [ RunTime:0.007563s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57454906 ORDER BY `unit` DESC [ RunTime:0.011263s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57454906 LIMIT 2 [ RunTime:0.005857s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57454906 ORDER BY `minOrder` ASC [ RunTime:0.000814s ]
select * from pdf where partno='PS2581AL1-A-H' and brandshort='Renesas Electronics Corporation' limit 1 [ RunTime:0.008626s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PS2581AL1-A-H' OR `brand` LIKE 'Renesas Electronics Corporation%' ) ) LIMIT 1 [ RunTime:0.003875s ]
SELECT `id` FROM `stock` WHERE `id` <> 57454906 AND `partno` = 'PS2581AL1-A-H' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%renesas electronics corporation%' ) [ RunTime:0.008777s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57454905 LIMIT 5 [ RunTime:0.011137s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57454905 ORDER BY `minOrder` ASC [ RunTime:0.010948s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57454905 ORDER BY `unit` DESC [ RunTime:0.022122s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57454905 LIMIT 2 [ RunTime:0.007886s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57454905 ORDER BY `minOrder` ASC [ RunTime:0.016702s ]
select * from pdf where partno='PS2581AL1-A-L' and brandshort='Renesas Electronics Corporation' limit 1 [ RunTime:0.010549s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PS2581AL1-A-L' OR `brand` LIKE 'Renesas Electronics Corporation%' ) ) LIMIT 1 [ RunTime:0.013778s ]
SELECT `id` FROM `stock` WHERE `id` <> 57454905 AND `partno` = 'PS2581AL1-A-L' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%renesas electronics corporation%' ) [ RunTime:0.011045s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57454903 LIMIT 5 [ RunTime:0.000698s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57454903 ORDER BY `minOrder` ASC [ RunTime:0.000736s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57454903 ORDER BY `unit` DESC [ RunTime:0.000711s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57454903 LIMIT 2 [ RunTime:0.005615s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57454903 ORDER BY `minOrder` ASC [ RunTime:0.002599s ]
select * from pdf where partno='PS2581AL1-A-QJR' and brandshort='Renesas Electronics Corporation' limit 1 [ RunTime:0.000974s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PS2581AL1-A-QJR' OR `brand` LIKE 'Renesas Electronics Corporation%' ) ) LIMIT 1 [ RunTime:0.007173s ]
SELECT `id` FROM `stock` WHERE `id` <> 57454903 AND `partno` = 'PS2581AL1-A-QJR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%renesas electronics corporation%' ) [ RunTime:0.015954s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57454902 LIMIT 5 [ RunTime:0.009869s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57454902 ORDER BY `minOrder` ASC [ RunTime:0.004979s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57454902 ORDER BY `unit` DESC [ RunTime:0.041728s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57454902 LIMIT 2 [ RunTime:0.048275s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57454902 ORDER BY `minOrder` ASC [ RunTime:0.011495s ]
select * from pdf where partno='PS2581AL1-A/QK' and brandshort='Renesas Electronics Corporation' limit 1 [ RunTime:0.001457s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PS2581AL1-A/QK' OR `brand` LIKE 'Renesas Electronics Corporation%' ) ) LIMIT 1 [ RunTime:0.004146s ]
SELECT `id` FROM `stock` WHERE `id` <> 57454902 AND `partno` = 'PS2581AL1-A/QK' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%renesas electronics corporation%' ) [ RunTime:0.011359s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57454901 LIMIT 5 [ RunTime:0.010205s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57454901 ORDER BY `minOrder` ASC [ RunTime:0.012873s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57454901 ORDER BY `unit` DESC [ RunTime:0.002110s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57454901 LIMIT 2 [ RunTime:0.001785s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57454901 ORDER BY `minOrder` ASC [ RunTime:0.005699s ]
select * from pdf where partno='PS2581AL1-A-QKR' and brandshort='Renesas Electronics Corporation' limit 1 [ RunTime:0.012590s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PS2581AL1-A-QKR' OR `brand` LIKE 'Renesas Electronics Corporation%' ) ) LIMIT 1 [ RunTime:0.004150s ]
SELECT `id` FROM `stock` WHERE `id` <> 57454901 AND `partno` = 'PS2581AL1-A-QKR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%renesas electronics corporation%' ) [ RunTime:0.000827s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57454900 LIMIT 5 [ RunTime:0.004278s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57454900 ORDER BY `minOrder` ASC [ RunTime:0.007247s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57454900 ORDER BY `unit` DESC [ RunTime:0.014686s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57454900 LIMIT 2 [ RunTime:0.025133s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57454900 ORDER BY `minOrder` ASC [ RunTime:0.004470s ]
select * from pdf where partno='PS2581AL1-A/QKR' and brandshort='Renesas Electronics Corporation' limit 1 [ RunTime:0.012291s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PS2581AL1-A/QKR' OR `brand` LIKE 'Renesas Electronics Corporation%' ) ) LIMIT 1 [ RunTime:0.001252s ]
SELECT `id` FROM `stock` WHERE `id` <> 57454900 AND `partno` = 'PS2581AL1-A/QKR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%renesas electronics corporation%' ) [ RunTime:0.003308s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57454899 LIMIT 5 [ RunTime:0.007130s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57454899 ORDER BY `minOrder` ASC [ RunTime:0.029860s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57454899 ORDER BY `unit` DESC [ RunTime:0.008448s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57454899 LIMIT 2 [ RunTime:0.008666s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57454899 ORDER BY `minOrder` ASC [ RunTime:0.006798s ]
select * from pdf where partno='PS2581AL1-A/QJ2' and brandshort='Renesas Electronics Corporation' limit 1 [ RunTime:0.011849s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PS2581AL1-A/QJ2' OR `brand` LIKE 'Renesas Electronics Corporation%' ) ) LIMIT 1 [ RunTime:0.025372s ]
SELECT `id` FROM `stock` WHERE `id` <> 57454899 AND `partno` = 'PS2581AL1-A/QJ2' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%renesas electronics corporation%' ) [ RunTime:0.008675s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57454898 LIMIT 5 [ RunTime:0.039641s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57454898 ORDER BY `minOrder` ASC [ RunTime:0.016320s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57454898 ORDER BY `unit` DESC [ RunTime:0.039254s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57454898 LIMIT 2 [ RunTime:0.041548s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57454898 ORDER BY `minOrder` ASC [ RunTime:0.012826s ]
select * from pdf where partno='PS2581AL1-A/W' and brandshort='Renesas Electronics Corporation' limit 1 [ RunTime:0.014994s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PS2581AL1-A/W' OR `brand` LIKE 'Renesas Electronics Corporation%' ) ) LIMIT 1 [ RunTime:0.026822s ]
SELECT `id` FROM `stock` WHERE `id` <> 57454898 AND `partno` = 'PS2581AL1-A/W' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%renesas electronics corporation%' ) [ RunTime:0.032768s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57454896 LIMIT 5 [ RunTime:0.049775s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57454896 ORDER BY `minOrder` ASC [ RunTime:0.025232s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57454896 ORDER BY `unit` DESC [ RunTime:0.029344s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57454896 LIMIT 2 [ RunTime:0.014938s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57454896 ORDER BY `minOrder` ASC [ RunTime:0.016986s ]
select * from pdf where partno='PS2581AL1-A/H' and brandshort='Renesas Electronics Corporation' limit 1 [ RunTime:0.009937s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PS2581AL1-A/H' OR `brand` LIKE 'Renesas Electronics Corporation%' ) ) LIMIT 1 [ RunTime:0.015408s ]
SELECT `id` FROM `stock` WHERE `id` <> 57454896 AND `partno` = 'PS2581AL1-A/H' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%renesas electronics corporation%' ) [ RunTime:0.038207s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57454894 LIMIT 5 [ RunTime:0.037888s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57454894 ORDER BY `minOrder` ASC [ RunTime:0.004683s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57454894 ORDER BY `unit` DESC [ RunTime:0.013377s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57454894 LIMIT 2 [ RunTime:0.016600s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57454894 ORDER BY `minOrder` ASC [ RunTime:0.011700s ]
select * from pdf where partno='PS2581AL1-A-W' and brandshort='Renesas Electronics Corporation' limit 1 [ RunTime:0.037073s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PS2581AL1-A-W' OR `brand` LIKE 'Renesas Electronics Corporation%' ) ) LIMIT 1 [ RunTime:0.024117s ]
SELECT `id` FROM `stock` WHERE `id` <> 57454894 AND `partno` = 'PS2581AL1-A-W' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%renesas electronics corporation%' ) [ RunTime:0.034294s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57454893 LIMIT 5 [ RunTime:0.027296s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57454893 ORDER BY `minOrder` ASC [ RunTime:0.055764s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57454893 ORDER BY `unit` DESC [ RunTime:0.023498s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57454893 LIMIT 2 [ RunTime:0.016242s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57454893 ORDER BY `minOrder` ASC [ RunTime:0.024165s ]
select * from pdf where partno='PS2581AL1-A/L' and brandshort='Renesas Electronics Corporation' limit 1 [ RunTime:0.017558s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PS2581AL1-A/L' OR `brand` LIKE 'Renesas Electronics Corporation%' ) ) LIMIT 1 [ RunTime:0.032560s ]
SELECT `id` FROM `stock` WHERE `id` <> 57454893 AND `partno` = 'PS2581AL1-A/L' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%renesas electronics corporation%' ) [ RunTime:0.037042s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57454892 LIMIT 5 [ RunTime:0.030162s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57454892 ORDER BY `minOrder` ASC [ RunTime:0.012155s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57454892 ORDER BY `unit` DESC [ RunTime:0.039828s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57454892 LIMIT 2 [ RunTime:0.048683s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57454892 ORDER BY `minOrder` ASC [ RunTime:0.011103s ]
select * from pdf where partno='PS2581AL1-A/WJ2' and brandshort='Renesas Electronics Corporation' limit 1 [ RunTime:0.035367s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PS2581AL1-A/WJ2' OR `brand` LIKE 'Renesas Electronics Corporation%' ) ) LIMIT 1 [ RunTime:0.019484s ]
SELECT `id` FROM `stock` WHERE `id` <> 57454892 AND `partno` = 'PS2581AL1-A/WJ2' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%renesas electronics corporation%' ) [ RunTime:0.087182s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57454890 LIMIT 5 [ RunTime:0.047572s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57454890 ORDER BY `minOrder` ASC [ RunTime:0.046366s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57454890 ORDER BY `unit` DESC [ RunTime:0.058670s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57454890 LIMIT 2 [ RunTime:0.059960s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57454890 ORDER BY `minOrder` ASC [ RunTime:0.022083s ]
select * from pdf where partno='PS2581AL1-A/Q' and brandshort='Renesas Electronics Corporation' limit 1 [ RunTime:0.027825s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PS2581AL1-A/Q' OR `brand` LIKE 'Renesas Electronics Corporation%' ) ) LIMIT 1 [ RunTime:0.028526s ]
SELECT `id` FROM `stock` WHERE `id` <> 57454890 AND `partno` = 'PS2581AL1-A/Q' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%renesas electronics corporation%' ) [ RunTime:0.030840s ]
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 'ps2581al1-a%' OR `brand` LIKE 'ps2581al1-a%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.030504s ]
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 'ps2581al1-a%' OR `brand` LIKE 'ps2581al1-a%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.018375s ]
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 'ps2581al1-a%' OR `brand` LIKE 'ps2581al1-a%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.027942s ]
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 'ps2581al1-a%' OR `brand` LIKE 'ps2581al1-a%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.017279s ]
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 'ps2581al1-a%' OR `brand` LIKE 'ps2581al1-a%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.016715s ]
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 'ps2581al1-a%' OR `brand` LIKE 'ps2581al1-a%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.028119s ]
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 'ps2581al1-a%' OR `brand` LIKE 'ps2581al1-a%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.042670s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'ps2581al1-a%' OR `brand` LIKE 'ps2581al1-a%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.009642s ]