SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001938s ]
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 'RP10-1205SE%' OR `brand` LIKE 'RP10-1205SE%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.035129s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.003382s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16644061 LIMIT 5 [ RunTime:0.023856s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001424s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16644061 ORDER BY `minOrder` ASC [ RunTime:0.028543s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.008822s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16644061 ORDER BY `unit` DESC [ RunTime:0.027719s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.008842s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16644061 LIMIT 2 [ RunTime:0.025576s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16644061 ORDER BY `minOrder` ASC [ RunTime:0.016383s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16644060 LIMIT 5 [ RunTime:0.038597s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16644060 ORDER BY `minOrder` ASC [ RunTime:0.022691s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16644060 ORDER BY `unit` DESC [ RunTime:0.045914s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16644060 LIMIT 2 [ RunTime:0.043490s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16644060 ORDER BY `minOrder` ASC [ RunTime:0.028675s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16643940 LIMIT 5 [ RunTime:0.041847s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16643940 ORDER BY `minOrder` ASC [ RunTime:0.063718s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16643940 ORDER BY `unit` DESC [ RunTime:0.014530s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16643940 LIMIT 2 [ RunTime:0.024219s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16643940 ORDER BY `minOrder` ASC [ RunTime:0.027792s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16643812 LIMIT 5 [ RunTime:0.021837s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16643812 ORDER BY `minOrder` ASC [ RunTime:0.070432s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16643812 ORDER BY `unit` DESC [ RunTime:0.066259s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16643812 LIMIT 2 [ RunTime:0.068372s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16643812 ORDER BY `minOrder` ASC [ RunTime:0.019848s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14780816 LIMIT 5 [ RunTime:0.028089s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14780816 ORDER BY `minOrder` ASC [ RunTime:0.093577s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14780816 ORDER BY `unit` DESC [ RunTime:0.043329s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14780816 LIMIT 2 [ RunTime:0.036946s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14780816 ORDER BY `minOrder` ASC [ RunTime:0.003242s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14762361 LIMIT 5 [ RunTime:0.020067s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14762361 ORDER BY `minOrder` ASC [ RunTime:0.009949s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14762361 ORDER BY `unit` DESC [ RunTime:0.012964s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14762361 LIMIT 2 [ RunTime:0.002715s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14762361 ORDER BY `minOrder` ASC [ RunTime:0.010914s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13887471 LIMIT 5 [ RunTime:0.033891s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13887471 ORDER BY `minOrder` ASC [ RunTime:0.016203s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13887471 ORDER BY `unit` DESC [ RunTime:0.034876s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13887471 LIMIT 2 [ RunTime:0.019879s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13887471 ORDER BY `minOrder` ASC [ RunTime:0.010063s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13887470 LIMIT 5 [ RunTime:0.015943s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13887470 ORDER BY `minOrder` ASC [ RunTime:0.010725s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13887470 ORDER BY `unit` DESC [ RunTime:0.013687s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13887470 LIMIT 2 [ RunTime:0.012561s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13887470 ORDER BY `minOrder` ASC [ RunTime:0.009142s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13887152 LIMIT 5 [ RunTime:0.013553s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13887152 ORDER BY `minOrder` ASC [ RunTime:0.008327s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13887152 ORDER BY `unit` DESC [ RunTime:0.028737s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13887152 LIMIT 2 [ RunTime:0.005454s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13887152 ORDER BY `minOrder` ASC [ RunTime:0.001823s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13887010 LIMIT 5 [ RunTime:0.018912s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13887010 ORDER BY `minOrder` ASC [ RunTime:0.016279s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13887010 ORDER BY `unit` DESC [ RunTime:0.002311s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13887010 LIMIT 2 [ RunTime:0.021762s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13887010 ORDER BY `minOrder` ASC [ RunTime:0.010629s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13887009 LIMIT 5 [ RunTime:0.006503s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13887009 ORDER BY `minOrder` ASC [ RunTime:0.019150s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13887009 ORDER BY `unit` DESC [ RunTime:0.006525s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13887009 LIMIT 2 [ RunTime:0.000653s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13887009 ORDER BY `minOrder` ASC [ RunTime:0.003143s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13886887 LIMIT 5 [ RunTime:0.012405s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13886887 ORDER BY `minOrder` ASC [ RunTime:0.005194s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13886887 ORDER BY `unit` DESC [ RunTime:0.008393s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13886887 LIMIT 2 [ RunTime:0.000536s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13886887 ORDER BY `minOrder` ASC [ RunTime:0.005480s ]
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 'RP10-1205SE%' OR `brand` LIKE 'RP10-1205SE%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.007427s ]
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 'RP10-1205SE%' OR `brand` LIKE 'RP10-1205SE%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.017314s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64358509 LIMIT 5 [ RunTime:0.001547s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64358509 ORDER BY `minOrder` ASC [ RunTime:0.008921s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64358509 ORDER BY `unit` DESC [ RunTime:0.007048s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64358509 LIMIT 2 [ RunTime:0.002493s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64358509 ORDER BY `minOrder` ASC [ RunTime:0.000926s ]
select * from pdf where partno='RP10-1205SE/P/M1-HC' and brandshort='Recom Power' limit 1 [ RunTime:0.012229s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.004174s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'RP10-1205SE/P/M1-HC' OR `brand` LIKE 'Recom Power%' ) ) LIMIT 1 [ RunTime:0.007212s ]
SELECT `id` FROM `stock` WHERE `id` <> 64358509 AND `partno` = 'RP10-1205SE/P/M1-HC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%recom power%' ) [ RunTime:0.008485s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13887471 [ RunTime:0.019736s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64358508 LIMIT 5 [ RunTime:0.035231s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64358508 ORDER BY `minOrder` ASC [ RunTime:0.009529s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64358508 ORDER BY `unit` DESC [ RunTime:0.020471s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64358508 LIMIT 2 [ RunTime:0.022760s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64358508 ORDER BY `minOrder` ASC [ RunTime:0.000501s ]
select * from pdf where partno='RP10-1205SE/N/M1-HC' and brandshort='Recom Power' limit 1 [ RunTime:0.003287s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'RP10-1205SE/N/M1-HC' OR `brand` LIKE 'Recom Power%' ) ) LIMIT 1 [ RunTime:0.004321s ]
SELECT `id` FROM `stock` WHERE `id` <> 64358508 AND `partno` = 'RP10-1205SE/N/M1-HC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%recom power%' ) [ RunTime:0.008877s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13887470 [ RunTime:0.003856s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64357958 LIMIT 5 [ RunTime:0.015522s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64357958 ORDER BY `minOrder` ASC [ RunTime:0.018703s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64357958 ORDER BY `unit` DESC [ RunTime:0.004919s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64357958 LIMIT 2 [ RunTime:0.000490s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64357958 ORDER BY `minOrder` ASC [ RunTime:0.000288s ]
select * from pdf where partno='RP10-1205SE/P/M1' and brandshort='Recom Power' limit 1 [ RunTime:0.004240s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'RP10-1205SE/P/M1' OR `brand` LIKE 'Recom Power%' ) ) LIMIT 1 [ RunTime:0.021958s ]
SELECT `id` FROM `stock` WHERE `id` <> 64357958 AND `partno` = 'RP10-1205SE/P/M1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%recom power%' ) [ RunTime:0.013084s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16644061 [ RunTime:0.000717s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64357957 LIMIT 5 [ RunTime:0.002086s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64357957 ORDER BY `minOrder` ASC [ RunTime:0.004180s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64357957 ORDER BY `unit` DESC [ RunTime:0.005229s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64357957 LIMIT 2 [ RunTime:0.028811s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64357957 ORDER BY `minOrder` ASC [ RunTime:0.004404s ]
select * from pdf where partno='RP10-1205SE/N/M1' and brandshort='Recom Power' limit 1 [ RunTime:0.009183s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'RP10-1205SE/N/M1' OR `brand` LIKE 'Recom Power%' ) ) LIMIT 1 [ RunTime:0.006004s ]
SELECT `id` FROM `stock` WHERE `id` <> 64357957 AND `partno` = 'RP10-1205SE/N/M1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%recom power%' ) [ RunTime:0.012766s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16644060 [ RunTime:0.045242s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64357554 LIMIT 5 [ RunTime:0.028298s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64357554 ORDER BY `minOrder` ASC [ RunTime:0.041862s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64357554 ORDER BY `unit` DESC [ RunTime:0.018520s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64357554 LIMIT 2 [ RunTime:0.037454s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64357554 ORDER BY `minOrder` ASC [ RunTime:0.003159s ]
select * from pdf where partno='RP10-1205SE/P-HC' and brandshort='Recom Power' limit 1 [ RunTime:0.021556s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'RP10-1205SE/P-HC' OR `brand` LIKE 'Recom Power%' ) ) LIMIT 1 [ RunTime:0.022193s ]
SELECT `id` FROM `stock` WHERE `id` <> 64357554 AND `partno` = 'RP10-1205SE/P-HC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%recom power%' ) [ RunTime:0.036296s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16643940 [ RunTime:0.010353s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64357553 LIMIT 5 [ RunTime:0.040466s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64357553 ORDER BY `minOrder` ASC [ RunTime:0.013071s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64357553 ORDER BY `unit` DESC [ RunTime:0.006778s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64357553 LIMIT 2 [ RunTime:0.040105s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64357553 ORDER BY `minOrder` ASC [ RunTime:0.033508s ]
select * from pdf where partno='RP10-1205SE/N-HC' and brandshort='Recom Power' limit 1 [ RunTime:0.067038s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'RP10-1205SE/N-HC' OR `brand` LIKE 'Recom Power%' ) ) LIMIT 1 [ RunTime:0.010816s ]
SELECT `id` FROM `stock` WHERE `id` <> 64357553 AND `partno` = 'RP10-1205SE/N-HC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%recom power%' ) [ RunTime:0.037547s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13887152 [ RunTime:0.017433s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64357552 LIMIT 5 [ RunTime:0.056744s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64357552 ORDER BY `minOrder` ASC [ RunTime:0.065327s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64357552 ORDER BY `unit` DESC [ RunTime:0.036932s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64357552 LIMIT 2 [ RunTime:0.003758s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64357552 ORDER BY `minOrder` ASC [ RunTime:0.031053s ]
select * from pdf where partno='RP10-1205SE/M1-HC' and brandshort='Recom Power' limit 1 [ RunTime:0.044951s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'RP10-1205SE/M1-HC' OR `brand` LIKE 'Recom Power%' ) ) LIMIT 1 [ RunTime:0.025256s ]
SELECT `id` FROM `stock` WHERE `id` <> 64357552 AND `partno` = 'RP10-1205SE/M1-HC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%recom power%' ) [ RunTime:0.087936s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14780816 [ RunTime:0.056806s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64357085 LIMIT 5 [ RunTime:0.147802s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64357085 ORDER BY `minOrder` ASC [ RunTime:0.090462s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64357085 ORDER BY `unit` DESC [ RunTime:0.045251s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64357085 LIMIT 2 [ RunTime:0.105213s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64357085 ORDER BY `minOrder` ASC [ RunTime:0.043738s ]
select * from pdf where partno='RP10-1205SE/P' and brandshort='Recom Power' limit 1 [ RunTime:0.143060s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'RP10-1205SE/P' OR `brand` LIKE 'Recom Power%' ) ) LIMIT 1 [ RunTime:0.196781s ]
SELECT `id` FROM `stock` WHERE `id` <> 64357085 AND `partno` = 'RP10-1205SE/P' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%recom power%' ) [ RunTime:0.090630s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13887010 [ RunTime:0.057377s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64357084 LIMIT 5 [ RunTime:0.064465s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64357084 ORDER BY `minOrder` ASC [ RunTime:0.002089s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64357084 ORDER BY `unit` DESC [ RunTime:0.036879s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64357084 LIMIT 2 [ RunTime:0.089517s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64357084 ORDER BY `minOrder` ASC [ RunTime:0.055119s ]
select * from pdf where partno='RP10-1205SE/N' and brandshort='Recom Power' limit 1 [ RunTime:0.008457s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'RP10-1205SE/N' OR `brand` LIKE 'Recom Power%' ) ) LIMIT 1 [ RunTime:0.040399s ]
SELECT `id` FROM `stock` WHERE `id` <> 64357084 AND `partno` = 'RP10-1205SE/N' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%recom power%' ) [ RunTime:0.022585s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13887009 [ RunTime:0.002446s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64357083 LIMIT 5 [ RunTime:0.034434s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64357083 ORDER BY `minOrder` ASC [ RunTime:0.057411s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64357083 ORDER BY `unit` DESC [ RunTime:0.079262s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64357083 LIMIT 2 [ RunTime:0.049027s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64357083 ORDER BY `minOrder` ASC [ RunTime:0.014856s ]
select * from pdf where partno='RP10-1205SE/M1' and brandshort='Recom Power' limit 1 [ RunTime:0.016594s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'RP10-1205SE/M1' OR `brand` LIKE 'Recom Power%' ) ) LIMIT 1 [ RunTime:0.022018s ]
SELECT `id` FROM `stock` WHERE `id` <> 64357083 AND `partno` = 'RP10-1205SE/M1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%recom power%' ) [ RunTime:0.008293s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16643812 [ RunTime:0.054880s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64356719 LIMIT 5 [ RunTime:0.015639s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64356719 ORDER BY `minOrder` ASC [ RunTime:0.046230s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64356719 ORDER BY `unit` DESC [ RunTime:0.019839s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64356719 LIMIT 2 [ RunTime:0.022142s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64356719 ORDER BY `minOrder` ASC [ RunTime:0.002177s ]
select * from pdf where partno='RP10-1205SE-HC' and brandshort='Recom Power' limit 1 [ RunTime:0.045343s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'RP10-1205SE-HC' OR `brand` LIKE 'Recom Power%' ) ) LIMIT 1 [ RunTime:0.017315s ]
SELECT `id` FROM `stock` WHERE `id` <> 64356719 AND `partno` = 'RP10-1205SE-HC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%recom power%' ) [ RunTime:0.049889s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13886887 [ RunTime:0.036181s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64317230 LIMIT 5 [ RunTime:0.038498s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64317230 ORDER BY `minOrder` ASC [ RunTime:0.032270s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64317230 ORDER BY `unit` DESC [ RunTime:0.027493s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64317230 LIMIT 2 [ RunTime:0.035103s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64317230 ORDER BY `minOrder` ASC [ RunTime:0.006150s ]
select * from pdf where partno='RP10-1205SE' and brandshort='Recom Power' limit 1 [ RunTime:0.015332s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'RP10-1205SE' OR `brand` LIKE 'Recom Power%' ) ) LIMIT 1 [ RunTime:0.008343s ]
SELECT `id` FROM `stock` WHERE `id` <> 64317230 AND `partno` = 'RP10-1205SE' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%recom power%' ) [ RunTime:0.035745s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14762361 [ RunTime:0.013678s ]
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 'RP10-1205SE%' OR `brand` LIKE 'RP10-1205SE%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.012365s ]
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 'RP10-1205SE%' OR `brand` LIKE 'RP10-1205SE%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.027010s ]
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 'RP10-1205SE%' OR `brand` LIKE 'RP10-1205SE%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.015845s ]
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 'RP10-1205SE%' OR `brand` LIKE 'RP10-1205SE%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.019657s ]
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 'RP10-1205SE%' OR `brand` LIKE 'RP10-1205SE%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.005805s ]
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 'RP10-1205SE%' OR `brand` LIKE 'RP10-1205SE%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003893s ]
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 'RP10-1205SE%' OR `brand` LIKE 'RP10-1205SE%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.007350s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'RP10-1205SE%' OR `brand` LIKE 'RP10-1205SE%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.004883s ]